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.