Project Planning Data

You are managing a project to build a 6-sided shape parking lot fence. The approved budgeted cost of the fence is $15 per linear meter. The construction sequence is a follows:

• Side 1 is 160 meters long and it can start now.
• Side 2 is 150 meters long and it will start 2 weeks after side 1 is completed.
• Side 3 is 150 meters long and it will start 1 week before side 2 is completed.
• Side 4 is 150 meters long and it will start after side 3 is completed.
• Side 5 is 150 meters long and it will start after side 4 is completed.
• Side 6 is 150 meters long and it will start after side 5 is completed.

The duration of each side is 1 week. Side 1 also requires the installation of one-meter diameter culvert/pipe under the fence. The culvert installation is budgeted for $1,650 in total, it can be done in parallel with the construction of Side 1, and it will be completed in one week.

Actual Project Performance and the end of 4.5 Weeks:

• The first side of the fence and the culvert are completed.
• The second side is completed.
• Third side has 100 linear meters of fencing installed.
• Fourth side has 20 linear meters of fencing installed.
• The total amount spent up to this point is $12,000 in total.

Calculations at the end of 4.5 Weeks:

1. Budget at completion ( 5 marks)
2. Planned value: (5 marks)
3. Earned value: (5 marks)
4. CPI (four decimal points) and interpret the results. (2 marks)
5. SPI (four decimal points) and interpret the results. (2 marks)
6. What do you currently expect the total project cost at the end of the project? (2 marks)
7. From the end of 4.5 weeks, how much MORE do you expect to spend to finish the project? (2 marks)
8. What should be the future cost performance level required to finish the project on budget? (2 marks)

Show your calculations.