Project management assignment
joshna
earnedvaluechart.xlsSheet1
| Earned Value Chart | |||||||||||||
| Date | |||||||||||||
| Be sure to enter your own data and check your formulas. | |||||||||||||
| Month | |||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total Cost | |
| WBS Categories | |||||||||||||
| 1. Initiating | 13,000 | $ 13,000 | |||||||||||
| 2. Planning | 6,000 | 16,000 | 8,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | $ 36,000 | |||
| 3. Executing | - 0 | - 0 | - 0 | $ - 0 | |||||||||
| 3.1 Course design and development | - 0 | - 0 | - 0 | $ - 0 | |||||||||
| 3.1.1 Supplier management training | 5,000 | 73,667 | 73,667 | 73,667 | $ 226,000 | ||||||||
| 3.1.2 Negotiating skills training | 5,000 | 35,500 | 35,500 | 35,500 | $ 111,500 | ||||||||
| 3.1.3 Project management training | 5,000 | 43,000 | 43,000 | 43,000 | $ 134,000 | ||||||||
| 3.1.4 Software applications training | 5,000 | 43,000 | 43,000 | 43,000 | $ 134,000 | ||||||||
| 3.2 Course administration | 17,000 | 53,333 | 53,333 | 53,333 | $ 177,000 | ||||||||
| 3.3.Course evaluation | 3,000 | 3,000 | 3,000 | 7,500 | $ 16,500 | ||||||||
| 3.4 Stakeholder communications | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | $ 16,500 | |
| 4. Monitoring and Controlling | 1,000 | 2,000 | 2,000 | 2,000 | 3,000 | 3,500 | 3,000 | 3,000 | 2,000 | 3,000 | 2,000 | 1,000 | $ 27,500 |
| 5. Closing | 8,000 | 3,000 | $ 11,000 | ||||||||||
| Subtotal | $ 903,000 | ||||||||||||
| Reserves | - 0 | - 0 | - 0 | 90,300 | $ 90,300 | ||||||||
| Total | 20,000 | 19,500 | 31,500 | 199,667 | 200,667 | 218,167 | 61,833 | 61,833 | 60,833 | 12,000 | 11,500 | 95,800 | 993,300 |
| $ 689,500 | |||||||||||||
| Monthly Planned Value (PV) | 20,000 | 19,500 | 31,500 | 199,667 | 200,667 | 218,167 | 61,833 | 61,833 | 60,833 | 12,000 | 11,500 | 95,800 | |
| Cumulative Planned Value (PV) | 20,000 | 39,500 | 71,000 | 270,667 | 471,333 | 689,500 | 751,333 | 813,167 | 874,000 | 886,000 | 897,500 | 993,300 | |
| Monthly Actual Cost (AC) | 20,000 | 20,000 | 35,000 | 210,000 | 220,000 | 245,000 | |||||||
| Cumulative Actual Cost (AC) | 20000 | 40,000 | 75,000 | 285,000 | 505,000 | 750,000 | |||||||
| Monthly Earned Value (EV) | 20,000 | 20,000 | 30,000 | 190,000 | 200,000 | 240,000 | |||||||
| Cumulative Earned Value (EV) | 20,000 | 40,000 | 70,000 | 260,000 | 460,000 | 700,000 | |||||||
| Project EV as of May 31 | 700,000 | ||||||||||||
| Project PV as of May 31 | 689,500 | ||||||||||||
| Project AC as of May 31 | $ 750,000 | ||||||||||||
| CV=EV-AC | $ (50,000) | ||||||||||||
| SV=EV-PV | $ 10,500 | ||||||||||||
| CPI=EV/AC | 93.33% | ||||||||||||
| SPI=EV/PV | 101.52% | ||||||||||||
| Estimate at Completion (EAC) | $ 1,071,429 | ||||||||||||
| Estimated time to complete | 11.82 |
Sheet1
Cumulative Planned Value (PV)
Cumulative Actual Cost (AC)
Cumulative Earned Value (EV)
Sheet2
BAC
EAC
