The task is to use this document and the data provided to create a project file using Microsoft Proj

The 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

Predecessors

1

Theme Park Project

180 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

69 days

9/9/2008

12/12/2008

1.21.1

Ferris Wheel

40 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 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

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 Ac€?oOUT IN THE FUTUREAc€?c on the 10/1/08 day. LetAc€?cs 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

WhatAc€?cs 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 Ac€?o 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 CP2 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.

Submission Requirements

CP-2 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 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-2 must include a cover page.

As a guide, the body of CP-2 should be between five and ten pages in length (i.e., not including cover page, appendix, etc.).