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 1 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 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 qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx Finish Predecessors 2 Page 1 CP3 Start Data 1.8 Interior Studs 20 days 9/1/2008 9/26/2008 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 3 days 12/8/2008 12/10/2008 1.17 Bathroom Compartments/Accessories Plumbing 85 days 7/28/2008 11/21/2008 1.17.1 Hangers & Supports 40 days 7/28/2008 9/19/2008 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 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 20 days 10/6/2008 10/31/2008 29 1.19.4 Wiring Devices/Switches/Receptacles 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 qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx 7 16 3FS+10 days 3FS+10 days Page 2 CP3 Start Data 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 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 1 day 12/12/2008 12/12/2008 1.22 Attraction install and training complete 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 1.25 Grand Opening 1 day 12/19/2008 12/19/2008 12,14,15,16,17, 52,53,54 55 36,7 45,46,47,48,49, 50,51 Next enter the Working Resource data below into the project Resource Sheet [View \\ Resource Sheet]. Resource Name Type Initials Max Units Std. Rate Customer Architect Work Work C A 400% 300% $0.00/hr $125.00/hr qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx Accrue At Prorated Prorated Page 3 CP3 Start Data Engineer Electrician Electrician 2 Builder Landscaper Builder 1 Builder 2 Builder 3 Builder 4 Painter Plumber Steamfitter Steamfitter 2 FW Supplier Ride Supplier Work Work Work Work Work Work Work Work Work Work Work Work Work Work Work E E E B L B B B B P P S S F R 500% 200% 100% 600% 100% 100% 100% 100% 100% 300% 100% 100% 100% 100% 600% $125.00/hr $80.00/hr $300.00/hr $65.00/hr $50.00/hr $85.00/hr $85.00/hr $85.00/hr $85.00/hr $200.00/hr $150.00/hr $125.00/hr $200.00/hr $100.00/hr $100.00/hr Prorated Prorated Prorated Prorated Prorated Prorated Prorated Prorated Prorated Prorated Prorated Prorated Prorated Prorated 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 qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx Page 4 CP3 Start Data 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 qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx Page 5 CP3 Start Data Steamfitter 1.18.4 Test 1.19 Electrical 1.19.1 Boxes Electrician 1.19.2 Conduit Electrician 1.19.3 Wiring Devices/Switches/Receptacles 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 Electrician qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx Page 6 CP3 Start Data 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 qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx Page 7 CP3 Start Data 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 1 Theme Park Project Fixed Cost $0.00 1.1 Site Layout & Site Grading $10,000.00 1.2 Footings & Foundations $30,000.00 1.3 Masonry 1.4 Frames, Columns and Beams $150,000.0 0 $85,000.00 1.5 Joists & Roof Deck 1.6 Slab on Grade 1.7 Rough Carpentry 1.8 Interior Studs $200,000.0 0 $250,000.0 0 $175,000.0 0 $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 1.15 Finish Carpentry $150,000.0 0 $125,000.0 0 $15,000.00 1.16 1.17 Bathroom Compartments/Accessories Plumbing $0.00 1.17.1 Hangers & Supports $30,000.00 1.17.2 Pipes & Fittings $40,000.00 qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx Page 8 CP3 Start Data 1.17.3 1.18 Test $2,000.00 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 1.19 Electrical $5,000.00 $0.00 1.19.1 Boxes $35,000.00 1.19.2 Conduit $15,000.00 1.19.3 1.19.4 1.19.5 Wiring Devices/Switches/Receptacles Light Fixtures Test $20,000.00 $40,000.00 $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.0 0 $4,000.00 1.21.1.2 Ferris Wheel Legs & fan install 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 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 $15,000.00 1.21.2 Ropes course install & Training 1.21.3 Climbing wall install & Training $180,000.0 0 $80,000.00 1.21.4 Carousel install & Training $30,000.00 qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx Page 9 CP3 Start Data 1.21.5 Bowling install & Training 1.21.6 Go Cart install & Training 1.21.7 Mini Golf install & Training 1.21.8 $350,000.0 0 $890,000.0 0 $65,000.00 1.22 Attraction install and training complete Furniture Installation $0.00 1.23 System and Security Training $110,000.0 0 $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 1.2 Footings & Foundations 1.6 Slab on Grade 1.14 Flooring 1.18.1 Stacks & Vents Fixed Cost $100,000.0 0 $300,000.0 0 $200,000.0 0 $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 qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx Page 10 CP3 Start Data 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 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/19/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. qattachments_37b6d648317ba74de7a2fc3e935f249caf18a3fa.docx Page 11