CP3 Start Data
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/19/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.
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 / Predecessors1 / Theme Park Project / 175 days / 4/14/2008 / 12/19/2008
1.1 / Site Layout & Site Grading / 10 days / 4/14/2008 / 4/25/2008
1.2 / Footings & Foundations / 55 days / 4/28/2008 / 7/11/2008 / 2
1.3 / Masonry / 60 days / 5/19/2008 / 8/8/2008 / 3SS+15 days
1.4 / Frames, Columns and Beams / 40 days / 7/7/2008 / 8/29/2008 / 4SS+35 days
1.5 / Joists & Roof Deck / 30 days / 9/1/2008 / 10/10/2008 / 5
1.6 / Slab on Grade / 35 days / 7/14/2008 / 8/29/2008 / 3
1.7 / Rough Carpentry / 35 days / 9/1/2008 / 10/17/2008 / 7
1.8 / Interior Studs / 20 days / 9/1/2008 / 9/26/2008 / 7
1.9 / Interior Drywall / 30 days / 10/13/2008 / 11/21/2008 / 9,6
1.10 / Painting / 35 days / 10/27/2008 / 12/12/2008 / 10FS-20 days
1.11 / Elevator / 30 days / 9/1/2008 / 10/10/2008 / 7
1.12 / Doors / 5 days / 10/20/2008 / 10/24/2008 / 8
1.13 / Custom Theme Painting / 15 days / 11/3/2008 / 11/21/2008 / 11SS+5 days
1.14 / Flooring / 15 days / 11/17/2008 / 12/5/2008 / 10FS-5 days
1.15 / Finish Carpentry / 15 days / 11/17/2008 / 12/5/2008 / 10FS-5 days
1.16 / Bathroom Compartments/Accessories / 3 days / 12/8/2008 / 12/10/2008 / 16
1.17 / Plumbing / 85 days / 7/28/2008 / 11/21/2008
1.17.1 / Hangers & Supports / 40 days / 7/28/2008 / 9/19/2008 / 3FS+10 days
1.17.2 / Pipes & Fittings / 40 days / 9/22/2008 / 11/14/2008 / 19
1.17.3 / Test / 5 days / 11/17/2008 / 11/21/2008 / 20
1.18 / HVAC / 95 days / 7/28/2008 / 12/5/2008
1.18.1 / Stacks & Vents / 30 days / 7/28/2008 / 9/5/2008 / 3FS+10 days
1.18.2 / Hangers & Supports / 30 days / 9/8/2008 / 10/17/2008 / 23
1.18.3 / Ductwork & Piping / 30 days / 10/20/2008 / 11/28/2008 / 24
1.18.4 / Test / 5 days / 12/1/2008 / 12/5/2008 / 25
1.19 / Electrical / 95 days / 7/28/2008 / 12/5/2008
1.19.1 / Boxes / 25 days / 7/28/2008 / 8/29/2008 / 3FS+10 days
1.19.2 / Conduit / 25 days / 9/1/2008 / 10/3/2008 / 28
1.19.3 / Wiring Devices/Switches/Receptacles / 20 days / 10/6/2008 / 10/31/2008 / 29
1.19.4 / Light Fixtures / 20 days / 11/3/2008 / 11/28/2008 / 30
1.19.5 / Test / 5 days / 12/1/2008 / 12/5/2008 / 31
1.20 / Mechanicals Complete / 1 day / 12/8/2008 / 12/8/2008 / 21,26,32
1.21 / Attraction Install and Training / 146 days / 9/9/2008 / 12/12/2008
1.21.1 / Ferris Wheel / 137 days / 9/29/2008 / 11/21/2008
1.21.1.1 / Ferris Wheel to ship / 3 days / 9/29/2008 / 10/1/2008
1.21.1.2 / Ferris Wheel Legs & fan install / 6 days / 10/2/2008 / 10/9/2008 / 36,7
1.21.1.3 / Ferris Wheel gondola install / 6 days / 10/10/2008 / 10/17/2008 / 37
1.21.1.4 / Ferris Wheel MEP install / 6 days / 10/20/2008 / 10/27/2008 / 38
1.21.1.5 / Ferris wheel platform design / 2 days / 10/28/2008 / 10/29/2008 / 39
1.21.1.6 / Ferris Wheel Platform / 6 days / 10/30/2008 / 11/6/2008 / 40
1.21.1.7 / Ferris Wheel Railing / 6 days / 11/7/2008 / 11/14/2008 / 41
1.21.1.8 / Ferris wheel turnstile / 3 days / 11/17/2008 / 11/19/2008 / 42
1.21.1.9 / Ferris wheel Training / 1 day / 11/20/2008 / 11/20/2008 / 43
1.21.1.10 / Ferris Wheel Certification / 1 day / 11/21/2008 / 11/21/2008 / 44
1.21.2 / Ropes course install & Training / 30 days / 9/9/2008 / 10/20/2008 / 7
1.21.3 / Climbing wall install & Training / 10 days / 11/24/2008 / 12/5/2008 / 7
1.21.4 / Carousel install & Training / 13 days / 11/6/2008 / 11/24/2008 / 7
1.21.5 / Bowling install & Training / 40 days / 10/17/2008 / 12/11/2008 / 7
1.21.6 / Go Cart install & Training / 45 days / 10/6/2008 / 12/5/2008 / 7
1.21.7 / Mini Golf install & Training / 15 days / 11/17/2008 / 12/5/2008 / 7
1.21.8 / Attraction install and training complete / 1 day / 12/12/2008 / 12/12/2008 / 45,46,47,48,49,50,51
1.22 / Furniture Installation / 5 days / 12/8/2008 / 12/12/2008
1.23 / System and Security Training / 3 days / 12/15/2008 / 12/17/2008 / 52
1.24 / Final Walkthrough / 1 day / 12/18/2008 / 12/18/2008 / 12,14,15,16,17,52,53,54
1.25 / Grand Opening / 1 day / 12/19/2008 / 12/19/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 AtCustomer / 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
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 / Resources1 / 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 Cost1 / 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 Cost1.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 CP3 DropBox.
View \ Tables \ More Views \ Earned Value