Construction of an ultra modern theme park
Order Instructions:
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 178 days 4/14/08 12/17/08
1.1 Site Layout & Site Grading 10 days 4/14/08 4/25/08
1.2 Footings & Foundations 55 days 4/28/08 7/11/08 2
1.3 Masonry 60 days 5/19/08 8/8/08 3SS+15 days
1.4 Frames, Columns and Beams 40 days 7/7/08 8/29/08 4SS+35 days
1.5 Joists & Roof Deck 30 days 9/1/08 10/10/08 5
1.6 Slab on Grade 35 days 7/14/08 8/29/08 3
1.7 Rough Carpentry 35 days 9/1/08 10/17/08 7
1.8 Interior Studs 20 days 9/1/08 9/26/08 7
1.9 Interior Drywall 30 days 10/13/08 11/21/08 9,6
1.10 Painting 35 days 10/27/08 12/12/08 10FS-20 days
1.11 Elevator 30 days 9/1/08 10/10/08 7
1.12 Doors 5 days 10/20/08 10/24/08 8
1.13 Custom Theme Painting 15 days 11/3/08 11/21/08 11SS+5 days
1.14 Flooring 15 days 11/17/08 12/5/08 10FS-5 days
1.15 Finish Carpentry 15 days 11/17/08 12/5/08 10FS-5 days
1.16 Bathroom Compartments/Accessories 3 days 12/8/08 Wed 12/10/08 16
1.17 Plumbing 85 days 7/28/08 11/21/08
1.17.1 Hangers & Supports 40 days 7/28/08 9/19/08 3FS+10 days
1.17.2 Pipes & Fittings 40 days 9/22/08 11/14/08 19
1.17.3 Test 5 days 11/17/08 11/21/08 20
1.18 HVAC 95 days 7/28/08 12/5/08
1.18.1 Stacks & Vents 30 days 7/28/08 9/5/08 3FS+10 days
1.18.2 Hangers & Supports 30 days 9/8/08 10/17/08 23
1.18.3 Ductwork & Piping 30 days 10/20/08 11/28/08 24
1.18.4 Test 5 days 12/1/08 12/5/08 25
1.19 Electrical 95 days 7/28/08 12/5/08
1.19.1 Boxes 25 days 7/28/08 8/29/08 3FS+10 days
1.19.2 Conduit 25 days 9/1/08 10/3/08 28
1.19.3 Wiring Devices/Switches/Receptacles 20 days 10/6/08 10/31/08 29
1.19.4 Light Fixtures 20 days 11/3/08 11/28/08 30
1.19.5 Test 5 days 12/1/08 12/5/08 31
1.20 Mechanicals Complete 1 day 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 137 days 4/14/08 10/21/08
1.21.1.1 Ferris Wheel to ship 3 days 4/14/08 4/16/08
1.21.1.2 Ferris Wheel Legs & fan install 6 days 9/1/08 9/8/08 36,7
1.21.1.3 Ferris Wheel gondola install 6 days 9/9/08 9/16/08 37
1.21.1.4 Ferris Wheel MEP install 6 days 9/17/08 9/24/08 38
1.21.1.5 Ferris wheel platform design 2 days 9/25/08 9/26/08 39
1.21.1.6 Ferris Wheel Platform 6 days 9/29/08 10/6/08 40
1.21.1.7 Ferris Wheel Railing 6 days 10/7/08 10/14/08 41
1.21.1.8 Ferris wheel turnstile 3 days 10/15/08 10/17/08 42
1.21.1.9 Ferris wheel Training 1 day 10/20/08 10/20/08 43
1.21.1.10 Ferris Wheel Certification 1 day 10/21/08 10/21/08 44
1.21.2 Ropes course install & Training 30 days 9/1/08 10/10/08 7
1.21.3 Climbing wall install & Training 10 days 9/1/08 9/12/08 7
1.21.4 Carousel install & Training 13 days 9/1/08 9/17/08 7
1.21.5 Bowling install & Training 40 days 9/1/08 10/24/08 7
1.21.6 Go Cart install & Training 45 days 9/1/08 10/31/08 7
1.21.7 Mini Golf install & Training 15 days 9/1/08 9/19/08 7
1.21.8 Attraction install and training complete 1 day 11/3/08 11/03/08 45,46,47,48,49,50,51
1.22 Furniture Installation 5 days 12/9/08 12/15/08 33
1.23 System and Security Training 3 days 11/4/08 11/6/08 52
1.24 Final Walkthrough 1 day 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 gond
SAMPLE ANSWER
Executive Summary
The project entails the construction of an ultra modern theme park that’s scheduled to take 178days for all the construction work. The commencement date for the Theme Park Construction was scheduled to take place on 14/7/2008. The cost of the project has been estimated to cost $4,449,920 as per the baseline while its completion data is desired to be December 17 2008. The projects milestone are; Site Layout & Site Grading which is scheduled to take 10 days, Footings & Foundations 55 days, Masonry 60 days, Frames, Columns and Beams 40 days, Joists & Roof Deck 30 days, Slab on Grade 35 days, Rough Carpentry 35 days, Interior Studs 20 days, Interior Drywall 30 days, Painting 30 days, Elevators 30 days, Doors 5 days, Custom theme painting 15 days, Flooring 15 days, Finish carpentry 15 days, Bathroom compartments 3 days, Plumbing 85 days, HVAC 95 days, Ferries wheels 137 days, System and Security Training 3 days, Final Walk through 1 day and the Final Opening 1 day.
Earned Value
Earned Value or EV is a management technique that measures the performance of the project objectively. EV =Current/Start ∑ PV (Completed). The EV curve, mostly in green is utilized to indicate the technical performance or the progress of the report. Without the Earned Value it would be difficult to track the progress of a project. The EV compliments the critical path analysis in pert diagrams (Ireland, 2006).
In October 1 2008, the project is scheduled to have surpassed or at half its completion stage. The earned value for quarter Q2 is $2,073,040 while the planned value was 2,073,040. The actual cost incurred is $52,440 the same as the baseline cost. Total costs incurred on the project as at the end of the Q2 totaled to 52,440 (Cleland & Gareis, 2006).
The earned value for the Q3 was 13,832,862 while the planned value was 15,609,960. The actual cost for the project amounted to 195,286 while the baseline costs amounted to $337,760. In quarter Q4 the earned value was 247726 while the planned value had been budgeted at 397,800. The actual cost was the same as the baseline costs that was budgeted (Phillips, 2003).
2008 Earned Value Planned Value AC Actual Cost Actual Work Baseline Cost Baseline Work Cost Cumulative Cost
Q2 2073040 2073040 2073040 52440 720 52440 720 415031 52440
Q3 13832862 15609960 13832862 195286 2202 337760 3728 2153980 390200
Q4 247726 397800 247726 0 0 316720 2848 1880909 706920
Total 16153628 18080800 16153628 247726 2922 706920 7296 4449920 706920
The budgeted cost of work (BCWS) amounted to 2628906 as at the beginning of october 2008. It was also the planned value. The earned value according to the work performed amounted to $1,1616,178.90 while the actual cost of work performed (ACWP) aounted to $1,620,698.46. The Schedule Variance amouned to $1,113,728.66.
The actual cost of the actual work done is very low compared to the Earned Value and the Planned value (Cattani, Ferriani, Frederiksen and Florian, 2011). The cost of the work performed is higher than the actual costs incurred (Harrison & Lock, 2004). The contractor must have done more work than what has actually what he has been paid. It means that the contractor must be due for payments (Lock, 2007).
The total work that must have been completed as at the beginning of October 2008 are
The following are the completed tasks as at the beginning of october 2008
Task allocations and Schedules.
Task Hrs % Days Start Finish
Site Layout & Site Grading 80 hrs 100% 10 days 4/15/2008 4/16/2008 Architect
Footings & Foundations 440 hrs 100% 55 days 4/16/2008 4/17/2008 Builder
Masonry 60 days 480 hrs 100% 60 days 4/17/2008 4/18/2008 Builder
Frames, Columns and Beams 320 hrs 100% 40 days 4/18/2008 4/19/2008 Builder
Slab on Grade 280 hrs 100% 35 days 4/20/2008 4/21/2008 Builder
Stacks & Vents 240 hrs 100% 30 days 5/6/2008 5/7/2008 Steamfitter
Boxes 200 hrs 100% 25 days 5/11/2008 5/12/2008 Electrician
Ferris Wheel to ship 24 hrs 100% 3 days 5/19/2008 5/20/2008 FW Supplier
Ferris Wheel Legs & fan install 48 hrs 100% 6 days 5/20/2008 5/21/2008 FW Supplier
Hangers & Supports 320 hrs 78% 40 days 5/2/2008 5/3/2008 Plumber
Climbing wall install & Training 80 hrs 62% 10 days 5/30/2008 5/31/2008 Ride Supplier
Carousel install & Training 104 hrs 48% 13 days 5/31/2008 6/1/2008 Ride Supplier
Mini Golf install & Training 120 hrs 42% 15 days 6/3/2008 6/4/2008 Ride Supplier
Theme Park Project 7,296 hrs 40% 178 days 4/14/2008 4/15/2008
Plumbing 680 hrs 37% 85 days 5/1/2008 5/2/2008
HVAC 760 hrs 33% 95 days 5/5/2008 5/6/2008
Electrical 760 hrs 33% 95 days 5/10/2008 5/11/2008
Interior Studs 160 hrs 31% 20 days 4/22/2008 4/23/2008 Builder
Conduit 200 hrs 25% 25 days 5/12/2008 5/13/2008 Electrician
Attraction Install and Training 1,544 hrs 24% 146 days 5/17/2008 5/18/2008
Ferris Wheel 320 hrs 23% 137 days 5/18/2008 5/19/2008
Joists & Roof Deck 240 hrs 21% 30 days 4/19/2008 4/20/2008 Builder
Elevator 240 hrs 21% 30 days 4/25/2008 4/26/2008 Builder
Ropes course install & Training 240 hrs 21% 30 days 5/29/2008 5/30/2008 Ride Supplier
Rough Carpentry 280 hrs 18% 35 days 4/21/2008 4/22/2008 Builder
Bowling install & Training 320 hrs 16% 40 days 6/1/2008 6/2/2008 Ride Supplier
Go Cart install & Training 360 hrs 14% 45 days 6/2/2008 6/3/2008 Ride Supplier
Hangers & Supports 240 hrs 4% 30 days 5/7/2008 5/8/2008 Steamfitter
Ferris Wheel gondola install 48 hrs 4% 6 days 5/21/2008 5/22/2008 FW Supplier
Interior Drywall 240 hrs 0% 30 days 4/23/2008 4/24/2008 Builder
Painting 280 hrs 0% 35 days 4/24/2008 4/25/2008 Painter
Doors 40 hrs 0% 5 days 4/26/2008 4/27/2008 Builder
Custom Theme Painting 120 hrs 0% 15 days 4/27/2008 4/28/2008 Painter
Flooring 120 hrs 0% 15 days 4/28/2008 4/29/2008 Builder 1
Finish Carpentry 120 hrs 0% 15 days 4/29/2008 4/30/2008 Builder 2
Bathroom Compartments / Acc 24 hrs 0% 3 days 4/30/2008 5/1/2008 Builder
Pipes & Fittings 320 hrs 0% 40 days 5/3/2008 5/4/2008 Plumber
Test 40 hrs 0% 5 days 5/4/2008 5/5/2008 Plumber
Ductwork & Piping 240 hrs 0% 30 days 5/8/2008 5/9/2008 Steamfitter
Test 40 hrs 0% 5 days 5/9/2008 5/10/2008 Steamfitter
Wiring Devices/Switches/Reception 160 hrs 0% 20 days 5/13/2008 5/14/2008 Electrician
Light Fixtures 160 hrs 0% 20 days 5/14/2008 5/15/2008 Electrician
Test 5days 40 hrs 0% 5 days 5/15/2008 5/16/2008 Electrician
Mechanicals Complete 0 hrs 0% 1 day 5/16/2008 5/17/2008
Ferris Wheel MEP install 48 hrs 0% 6 days 5/22/2008 5/23/2008 FW Supplier
Ferris wheel platform design 16 hrs 0% 2 days 5/23/2008 5/24/2008 FW Supplier
Ferris Wheel Platform 48 hrs 0% 6 days 5/24/2008 5/25/2008 FW Supplier
Ferris Wheel Railing 48 hrs 0% 6 days 5/25/2008 5/26/2008 FW Supplier
Ferris wheel turnstile 24 hrs 0% 3 days 5/26/2008 5/27/2008 FW Supplier
Ferris wheel Training 8 hrs 0% 1 day 5/27/2008 5/28/2008 FW Supplier
Ferris Wheel Certification 8 hrs 0% 1 day 5/28/2008 5/29/2008 FW Supplier
Attraction install & training comp 0 hrs 0% 1 day 6/4/2008 6/5/2008
Furniture Installation 40 hrs 0% 5 days 6/5/2008 6/6/2008 Builder 3
System and Security Training 24 hrs 0% 3 days 6/6/2008 6/7/2008 Builder 4
Final Walkthrough 16 hrs 0% 1 day 6/7/2008 6/8/2008 Builder, Custo
Grand Opening 8 hrs 0% 1 day 6/8/2008 6/9/2008 Customer
The following were the critical tasks and which were scheduled to end on the desired date of 17/12/2008.
The following were the critical costs that are expected to be incurred on the critical costs.
The following is a summary of the actual total costs at the expected 50% completion rate when the actual completion rate is 40%.
To summarize, as at the beginning of October when the project was scheduled to be 50% complete only 40% of the work had been completed. The total costs that had been incurred amounted to $1,520,596.45 while the balance amounted to $2,929,323.55 while the total baseline budget was 4,449,920.The total actual hours worked were 2921.62 and the remaining hours were 4374.38 hours. The total hours as per the baseline were 7296 hrs. The total days spent were 71.2 days while the remaining days were 106.8.
References
Ireland, L.R. (2006) Project Management. McGraw-Hill Professional.
Lock, D. (2007) Project Management (9th ed.) Gower Publishing, Ltd.
Phillips, J. (2003). PMP Project Management Professional Study Guide. McGraw-Hill Professional.
Cleland, D.I. & Gareis, R. (2006). Global Project Management Handbook. McGraw-Hill Professional.
Harrison, F.L. & Lock, D. (2004). Advanced project management: a structured approach. Gower Publishing, Ltd.
We can write this or a similar paper for you! Simply fill the order form!
