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
| 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 |
| 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 |
| 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
Get step-by-step solutions from verified subject matter experts
