Posted: September 13th, 2017

Project Management

Project Management

Course Project Part 1
For Part 1 of the Course Project, assume you have been appointed project manager of a new project for your organization. Your first assignment is to create a scope statement and WBS for this project.
For this part of the Course Project, you select a project of your choosing. This selected project will be used in Project Part 1 and Project Part 2.
Select a project of personal interest. For example, select a project where you can identify realistic cost and scheduling concerns. Opening a small retail storefront or a franchise is one example. When selecting your project, keep in mind the goal of CP-1 is to create a scope statement and WBS. In Project Part 2, you will need to create a budget and schedule for this project. Choose something relatively straightforward. For example, simple start-ups, such as pizza or fast-food franchises, work well because information is readily available. It is preferred that you do NOT pick remodeling a house, but building a house or flipping a house is acceptable.
The CP-1 Project Proposal will be structured with the following sections.
•    Cover page including assignment, project title, course, and student contact information
•    Executive summary that summarizes the content from the entire document with quantifiable highlights, such as overall cost, duration, and so on
•    Project scope statement describing the project
•    Resource loaded WBS and schedule with proper grouping, indenting, and coding for approximately 25 to 40 line items
Submission Requirements
•    The scope statement should be written following guidelines for writing a scope as found in the PMBOK® Guide in Chapter 5.
•    The WBS should be created in MS Projects following standard indent and outdent practices used in WBS creation.
•    The assignment should be submitted as two files: one MS Word file for the scope statement and one MS Project file containing the project WBS.
Course Project Part 2
In project Part 2, we create a schedule and accurate budget for your project. You need to focus on detailed cost estimating, scheduling, and cost justification. Estimating includes specific assumptions made during the estimating process, as well as quantities, unit prices, hourly rates for tasks, and accumulated totals. You must justify all of your costs; this includes direct, indirect, variable, fixed, and overhead.
The CP-2 Project Proposal will be structured with the following sections.
•    Cover page including assignment, project title, course, and student contact information
•    Executive summary summarizing the content from the entire document with quantifiable highlights, such as overall cost, duration, and so on
•    Project scope statement describing the project
•    Resource loaded WBS and schedule with proper grouping, indenting, and coding for approximately 25 to 40 line items. This also needs to include a work package, deliverables, and activities, activity relationships, activity durations, and activity resources.
•    Cost estimates for each activity. Capital cost estimates should include building, franchise fees, equipment, and so on, if required for your project.
•    Cost assumptions including a list of assumptions made when deriving your estimates
NOTE: Each section should include the detail as described above, along with a proper discussion about the included data as well as the project manager’s analysis and interpretation of the information.
Submission Requirements
•    The assignment should be submitted as two files: one MS Word file for the scope statement and documentation excerpt for the WBS; and one MS Project file containing the project WBS, schedule, resource loading, and budget information.
•    CP-2 must include a cover page.
•    As a guide, the body of CP-2 should be between five and 10 pages in length (i.e., not including cover page, appendix, and MS Project file).
•    Submit the Word document to theWeek 4: Course Project, Part 2Dropbox.

Course Project Part 3
For CP-3, we will leave CP-2 behind and start fresh. CP-3 is a performance review of a new indoor theme park project. You will utilize the provided project information and data to create a new project schedule, which will represent your project at a specific point during implementation. You will load the information and data into Microsoft Project where the data will serve as the basis for project monitoring and control and earned value analysis. The output of the analysis, combined with a control plan, will be used to support the continuation of your project.
The CP-3 Project Performance Report will be structured with the following sections.
•    Cover page including assignment, project title, course, and student contact information
•    Executive summary summarizing the content from the entire document with quantifiable highlights, such as overall project cost and schedule performance and estimate to completion, and making the pitch to project stakeholders to continue the project
•    Schedule 1 an MSP Gantt chart schedule (required) that incorporates the provided project data, established baseline, and proper review date representing the anticipated 50% completion date
•    Performance analysis utilizing earned value data to analyze the project cost and schedule performance
•    Estimate at completion including a forward-looking estimate of the project completion date and the final project costs
•    Cost and schedule control plan providing a corrective action plan to bring the project back in line with your project baseline
•    Revised estimate at completion including the corrective actions from the control plan along with the resulting cost impact and schedule impact
•    Schedule 2 including revised MSP Gantt chart schedule (required) that reflects the impact of your corrective actions
NOTE: Each section should include the detail as described above, along with a proper discussion about the included data as well as the project manager’s analysis and interpretation of the information.
Background data for the CP-3 project can be found in Doc Sharing under the Course Project category or from this link: PROJ592_CourseHome_CP3_Start_Data.docx.
Submission Requirements
•    CP-3 must be submitted as a single document in MS Word. Information or details created with other tools like Excel or MS Project, such as tables, charts, or graphs, must be incorporated into the MS Word file submittal as an inserted object, such as a JPEG. (For help with MS Project, see the Video Tutorial link below.) Failure to follow this requirement will result in the return of the proposal for re-formatting to the requested MS Word format.
•    You may insert objects into the body of your paper to support your discussion if they are half a page or less. Larger items should be included in an appendix with appropriate references to this information.
•    CP-3 must include a cover page.
•    As a guide, the body of CP-3 should be between five and 10 pages in length (i.e., not including cover page, appendix, etc.).

Directions
For CP3 you will set your CP2 project and document deliverable aside and start fresh. Your task is to use this document and the data provided to create a project file using Microsoft Project. The data below will establish a project budget and schedule baseline with Budget = $4,449,920.00 and a highly desired completion date of 12/17/08.
We are trying to create a scenario for a time that is ‘out in the future’ here. We are fast forwarding the project and loading some fictional information to create a scenario for you to analyze using Earned Value and then provide course corrections to the project.

The project at this future date shows that our project is not performing very well. However, you are given the opportunity to make some changes to the project to still complete it on the desired date of 12/19/08.
These directions help you set the Gantt to represent the anticipated 50% completion ‘date’ of 10/1/08. This is the date where the project ‘should be’ 50% complete. You do NOT set the project to 50% complete, you set it to 40%. These are two different things and these 2 parameters set up the scenario for you to generate EV data and tell me about how the project is doing.

% Complete (The Reality)
The 40% should be set by you by setting the top level task (project name) to 40%. This is how ‘done’ we are saying we actually are with the project at this point in time.

% Scheduled (The Plan)
The date (i.e. point in time) provided for the review fast forwards the project to the ‘anticipated’ 50% project scheduled date. This is the date on the calendar when we ‘wanted’ to be 50% complete.

After opening MS Project, there is one system setting that needs to be changed in MS Project 2010 and MS Project 2013.  At the bottom left of the screen notice that New Tasks are set to Manually Scheduled.  Select this bar and change the setting so that all new tasks are set to Auto Schedule.  This can also be accomplished in the ribbon on the Task Tab and Tasks group.
First, change the project start date to Mon 4/14/08.
Use the following data to setup your baseline project file. Adjust indenting to match WBS coding provided.In MSP right mouse click the header row and insert a WBS Column as shown. Do not add durations or dates for the Summary Tasks because these will populate for you when you enter the lower task information.
WBS    Task Name    Duration    Start    Finish    Predecessors
1    Theme Park Project    178days    4/14/08    12/17/08
1.1    Site Layout & Site Grading    10days    4/14/08    4/25/08
1.2    Footings & Foundations    55days    4/28/08    7/11/08    2
1.3    Masonry    60days    5/19/08    8/8/08    3SS+15 days
1.4    Frames, Columns and Beams    40days    7/7/08    8/29/08    4SS+35 days
1.5    Joists & Roof Deck    30days    9/1/08    10/10/08    5
1.6    Slab on Grade    35days    7/14/08    8/29/08    3
1.7    Rough Carpentry    35days    9/1/08    10/17/08    7
1.8    Interior Studs    20days    9/1/08    9/26/08    7
1.9    Interior Drywall    30days    10/13/08    11/21/08    9,6
1.10    Painting    35days    10/27/08    12/12/08    10FS-20 days
1.11    Elevator    30days    9/1/08    10/10/08    7
1.12    Doors    5days    10/20/08    10/24/08    8
1.13    Custom Theme Painting    15days    11/3/08    11/21/08    11SS+5 days
1.14    Flooring    15days    11/17/08    12/5/08    10FS-5 days
1.15    Finish Carpentry    15days    11/17/08    12/5/08    10FS-5 days
1.16    Bathroom Compartments/Accessories    3days    12/8/08    Wed12/10/08    16
1.17    Plumbing    85days    7/28/08    11/21/08
1.17.1    Hangers & Supports    40days    7/28/08    9/19/08    3FS+10 days
1.17.2    Pipes & Fittings    40days    9/22/08    11/14/08    19
1.17.3    Test    5days    11/17/08    11/21/08    20
1.18    HVAC    95days    7/28/08    12/5/08
1.18.1    Stacks & Vents    30days    7/28/08    9/5/08    3FS+10 days
1.18.2    Hangers & Supports    30days    9/8/08    10/17/08    23
1.18.3    Ductwork & Piping    30days    10/20/08    11/28/08    24
1.18.4    Test    5days    12/1/08    12/5/08    25
1.19    Electrical    95days    7/28/08    12/5/08
1.19.1    Boxes    25days    7/28/08    8/29/08    3FS+10 days
1.19.2    Conduit    25days    9/1/08    10/3/08    28
1.19.3    Wiring Devices/Switches/Receptacles    20days    10/6/08    10/31/08    29
1.19.4    Light Fixtures    20days    11/3/08    11/28/08    30
1.19.5    Test    5days    12/1/08    12/5/08    31
1.20    Mechanicals Complete    1day    12/8/08    12/8/08    21,26,32
1.21    Attraction Install and Training    146 days    4/14/08    11/3/08
1.21.1    Ferris Wheel    137days    4/14/08    10/21/08
1.21.1.1    Ferris Wheel to ship    3days    4/14/08    4/16/08
1.21.1.2    Ferris Wheel Legs & fan install    6days    9/1/08    9/8/08    36,7
1.21.1.3    Ferris Wheel gondola install    6days    9/9/08    9/16/08    37
1.21.1.4    Ferris Wheel MEP install    6days    9/17/08    9/24/08    38
1.21.1.5    Ferris wheel platform design    2days    9/25/08    9/26/08    39
1.21.1.6    Ferris Wheel Platform    6days    9/29/08    10/6/08    40
1.21.1.7    Ferris Wheel Railing    6days    10/7/08    10/14/08    41
1.21.1.8    Ferris wheel turnstile    3days    10/15/08    10/17/08    42
1.21.1.9    Ferris wheel Training    1day    10/20/08    10/20/08    43
1.21.1.10    Ferris Wheel Certification    1day    10/21/08    10/21/08    44
1.21.2    Ropes course install & Training    30days    9/1/08    10/10/08    7
1.21.3    Climbing wall install & Training    10days    9/1/08    9/12/08    7
1.21.4    Carousel install & Training    13days    9/1/08    9/17/08    7
1.21.5    Bowling install & Training    40days    9/1/08    10/24/08    7
1.21.6    Go Cart install & Training    45days    9/1/08    10/31/08    7
1.21.7    Mini Golf install & Training    15days    9/1/08    9/19/08    7
1.21.8    Attraction install and training complete    1day    11/3/08    11/03/08    45,46,47,48,49,50,51
1.22    Furniture Installation    5days    12/9/08    12/15/08    33
1.23    System and Security Training    3days    11/4/08    11/6/08    52
1.24    Final Walkthrough    1day    12/16/08    12/16/08    12,14,15,16,17,52,53,54
1.25    Grand Opening    1 day    12/17/2008    12/17/2008    55
Next enter the Working Resource data below into the project Resource Sheet [View Resource Sheet].
Resource Name    Type    Initials    Max Units    Std. Rate    Accrue At
Customer    Work    C    400%    $0.00/hr    Prorated
Architect    Work    A    300%    $125.00/hr    Prorated
Engineer    Work    E    500%    $125.00/hr    Prorated
Electrician    Work    E    200%    $80.00/hr    Prorated
Electrician 2    Work    E    100%    $300.00/hr    Prorated
Builder    Work    B    600%    $65.00/hr    Prorated
Landscaper    Work    L    100%    $50.00/hr    Prorated
Builder 1    Work    B    100%    $85.00/hr    Prorated
Builder 2    Work    B    100%    $85.00/hr    Prorated
Builder 3     Work    B    100%    $85.00/hr    Prorated
Builder 4    Work    B    100%    $85.00/hr    Prorated
Painter    Work    P    300%    $200.00/hr    Prorated
Plumber    Work    P    100%    $150.00/hr    Prorated
Plumber 2    Work    P    100%    $225.00/hr    Prorated
Steamfitter    Work    S    100%    $125.00/hr    Prorated
Steamfitter 2    Work    S    100%    $200.00/hr    Prorated
FW Supplier    Work    F    100%    $100.00/hr    Prorated
Ride Supplier    Work    R    600%    $100.00/hr    Prorated
Now assign the resources to the project tasks as described below.
WBS    Task Name    Resources
1    Theme Park Project
1.1    Site Layout & Site Grading    Architect
1.2    Footings & Foundations    Builder
1.3    Masonry    Builder
1.4    Frames, Columns and Beams    Builder
1.5    Joists & Roof Deck    Builder
1.6    Slab on Grade    Builder
1.7    Rough Carpentry    Builder
1.8    Interior Studs    Builder
1.9    Interior Drywall    Builder
1.10    Painting    Painter
1.11    Elevator    Builder
1.12    Doors    Builder
1.13    Theme Painting    Painter
1.14    Flooring    Builder 1
1.15    Finish Carpentry    Builder 2
1.16    Bathroom Compartments/Accessories    Builder
1.17    Plumbing
1.17.1    Hangers & Supports    Plumber
1.17.2    Pipes & Fittings    Plumber
1.17.3    Test    Plumber
1.18    HVAC
1.18.1    Stacks & Vents    Steamfitter
1.18.2    Hangers & Supports    Steamfitter
1.18.3    Ductwork & Piping    Steamfitter
1.18.4    Test    Steamfitter
1.19    Electrical
1.19.1    Boxes    Electrician
1.19.2    Conduit    Electrician
1.19.3    Wiring Devices/Switches/Receptacles    Electrician
1.19.4    Light Fixtures    Electrician
1.19.5    Test    Electrician
1.20    Mechanicals Complete
1.21    Attraction Install and Training
1.21.1    Ferris Wheel
1.21.1.1    Ferris Wheel to ship    FW Supplier
1.21.1.2    Ferris Wheel Legs & fan install    FW Supplier
1.21.1.3    Ferris Wheel gondola install    FW Supplier
1.21.1.4    Ferris Wheel MEP install    FW Supplier
1.21.1.5    Ferris wheel platform design    FW Supplier
1.21.1.6    Ferris Wheel Platform    FW Supplier
1.21.1.7    Ferris Wheel Railing    FW Supplier
1.21.1.8    Ferris wheel turnstyle    FW Supplier
1.21.1.9    Ferris wheel Training    FW Supplier
1.21.1.10    Ferris Wheel Certification    FW Supplier
1.21.2    Ropes course install & Training    Ride Supplier
1.21.3    Climbing wall install & Training    Ride Supplier
1.21.4    Carousel install & Training    Ride Supplier
1.21.5    Bowling install & Training    Ride Supplier
1.21.6    Go Cart install & Training    Ride Supplier
1.21.7    Mini Golf install & Training    Ride Supplier
1.21.8    Attraction install and training complete
1.22    Furniture Installation    Builder 3
1.23    System and Security Training    Builder 4
1.24    Final Walkthrough    Builder,Customer
1.25    Grand Opening    Customer
Now we have to add the material costs for each task. In MSP we do this by adding a Prorated Fixed Cost in the Detail Gantt View, Table/Cost View.
WBS    Task Name    Fixed Cost
1    Theme Park Project    $0.00
1.1       Site Layout & Site Grading    $10,000.00
1.2       Footings & Foundations    $30,000.00
1.3       Masonry    $150,000.00
1.4       Frames, Columns and Beams    $85,000.00
1.5       Joists & Roof Deck    $200,000.00
1.6       Slab on Grade    $250,000.00
1.7       Rough Carpentry    $175,000.00
1.8       Interior Studs    $20,000.00
1.9       Interior Drywall    $30,000.00
1.10       Painting    $45,000.00
1.11       Elevator    $80,000.00
1.12       Doors    $25,000.00
1.13       Theme Painting    $30,000.00
1.14       Flooring    $150,000.00
1.15       Finish Carpentry    $125,000.00
1.16       Bathroom Compartments/Accessories    $15,000.00
1.17       Plumbing    $0.00
1.17.1          Hangers & Supports    $30,000.00
1.17.2          Pipes & Fittings    $40,000.00
1.17.3          Test    $2,000.00
1.18       HVAC    $0.00
1.18.1          Stacks & Vents    $25,000.00
1.18.2          Hangers & Supports    $10,000.00
1.18.3          Ductwork & Piping    $40,000.00
1.18.4          Test    $5,000.00
1.19       Electrical    $0.00
1.19.1          Boxes    $35,000.00
1.19.2          Conduit    $15,000.00
1.19.3          Wiring Devices/Switches/Receptacles    $20,000.00
1.19.4          Light Fixtures    $40,000.00
1.19.5          Test    $10,000.00
1.20       Mechanicals Complete    $0.00
1.21       Attraction Install and Training    $0.00
1.21.1          Ferris Wheel    $0.00
1.21.1.1             Ferris Wheel to ship    $250,000.00
1.21.1.2             Ferris Wheel Legs & fan install    $4,000.00
1.21.1.3             Ferris Wheel gondola install    $3,000.00
1.21.1.4             Ferris Wheel MEP install    $5,000.00
1.21.1.5             Ferris wheel platform design    $1,000.00
1.21.1.6             Ferris Wheel Platform    $15,000.00
1.21.1.7             Ferris Wheel Railing    $5,000.00
1.21.1.8             Ferris wheel turnstyle    $2,000.00
1.21.1.9             Ferris wheel Training    $5,000.00
1.21.1.10             Ferris Wheel Certification    $1,000.00
1.21.2          Ropes course install & Training    $180,000.00
1.21.3          Climbing wall install & Training    $80,000.00
1.21.4          Carousel install & Training    $30,000.00
1.21.5          Bowling install & Training    $350,000.00
1.21.6          Go Cart install & Training    $890,000.00
1.21.7          Mini Golf install & Training    $65,000.00
1.21.8          Attraction install and training complete    $0.00
1.22       Furniture Installation    $110,000.00
1.23       System and Security Training    $10,000.00
1.24       Final Walkthrough    $15,000.00
1.25       Grand Opening    $30,000.00
CRITICAL STEP!!!
Next, start tracking the project by setting the project baseline.Project Tools Set Baseline Set Baseline Set Baseline OK.
Next, set the project % complete to 40% by adjusting the % complete column for the project header task (Theme Park Project). This will adjust all task completions to a % complete based on the baseline schedule.
Next, adjust the Project Current Date to 10/1/08 AND adjust the Project Status Date to 10/1/08. Project Project Information.
Now we have to adjust a few task fixed costs because we have spent more on materials than we had estimated. In MSP we do this by adjusting the Prorated Fixed Cost in the Detail Gantt View, Table Cost View.
WBS    Task Name    Fixed Cost
1.2       Footings & Foundations    $100,000.00
1.6       Slab on Grade    $300,000.00
1.14       Flooring    $200,000.00
1.18.1          Stacks & Vents    $50,000.00
We now are ‘OUT IN THE FUTURE’ on the 10/1/08 day. Let’s see how the project is doing!
CRITICAL STEP!!!
Because we are behind, we need to move all the incomplete work into the future to get a true look at the estimated completion date. Select to Reschedule Incomplete Work to start date after: 10/1/08.
Project Update Project Select OK
What’s the new projected completion date? After we look at Earned Value below, we will have to do something about this issue.
In the Tracking Gantt – Earned Value view, use the project file to perform your Earned Value Analysis as described on the Project Tab under Course Home. Use the project file and your analysis to complete the Project Status Report which you will be submitting to the CP3DropBox.

View Tables More Views Earned Value
As mentioned above, the project at this future date shows that our project is not performing very well. Analyze the project and report on it.
Make your changes
The good news is you are given the opportunity to make some changes to the project to still complete it on the desired date of 12/17/08. You can do this by analyzing the critical path activities and then making changes to the project to pull the date in. Make your changes, for example to resources. Analyze the result of these changes to the project dates and the project costs (i.e. the date should improve and then cost may increase. Assume you need to do something proactive to catch up and then explain the impact of those changes.
Integration into WORD
There are two simple formatting tricks to get the MSP data into the WORD document.

1) Change the time scale to shrink down the MSP Gantt chart. Right click on the timeline to open a screen which lists Top, Middle and Bottom tabs. On the Middle tab select Quarters. On the Bottom Tab, select Months.

2) Print the MSP file. For a printer driver select Microsoft Office Document Image Writer (If you have this driver available to you). Save the file somewhere you can find it on your C drive. Insert as a picture file (Tif) into your Word Document. If this doesn’t work you may need to use print screen or some other screen capture tool like SnipIt.