Question: Given the project network and baseline information below, use an excel spreadsheet to enter the data and calculate the values for the empty spaces on

Given the project network and baseline information below, use an excel spreadsheet to enter the data and calculate the values for the empty spaces on the two forms provided; (i.e., EV, PV, CV and SV for each activity and the total project) to develop the status of the project at the end of period 4 and end of period 8

PROJECT BASELINE ($)
Task Duration ES LF PV 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
A 2 0 2 600 300 300
B 6 2 8 3600 600 600 600 600 600 600
C 5 2 9 2100 400 400 400 500 400
D 4 8 12 2400 600 600 600 600
E 3 7 12 1200 400 400 400
F 3 12 15 900 300 300 300
Total PV for Period 300 300 1000 1000 1000 1100 1000 1000 1000 1000 600 600 300 300 300
Total cumulative PV 300 600 1600 2600 3600 4700 5700 6700 7700 8700 9300 9900 10200 10500 10800

PROJECT STATUS AT THE END OF PERIOD 4
TASK % COMPLETE EV AC PV for Task CV SV
A Completed $500
B 50% $1,800
C 33% (i.e., 1/3) $700
D 0%
E 0%
F 0%
PROJECT TOTAL

PROJECT STATUS AT THE END OF PERIOD 8
TASK % COMPLETE EV AC PV for Task CV EV
A Completed $500
B Completed $4,000
C Completed $2,200
D 25% $600
E 33% (i.e., 1/3) $400
F 0%
PROJECT TOTAL

PLEASE WRITE STATEMENT TO DESCRIBE THE STATUS OF THE PROJECT AT THE END PERIOD 8

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!