Project Closeout
Mkrenisky84
MSProjectExercise.xlsxReport
| MS Project Exercise | ||||||||||||||||
| Earned Value Analysis Report | ||||||||||||||||
| Earned Value Management Template | ||||||||||||||||
| Prepared By: | Mary Krenisky | © 2012-2017 Vertex42 LLC | ||||||||||||||
| Date: | 27-Aug-18 | |||||||||||||||
| [42] | ||||||||||||||||
| For Period: | Week 8 | |||||||||||||||
| Summary: | ||||||||||||||||
| According to the results of the graph that is prepared on the basis of various computations, shows the Planned value and earned value exceed the actual cost. | ||||||||||||||||
| Planned Value (PV) or Budgeted Cost of Work Scheduled (BCWS) | ||||||||||||||||
| WBS Vertex42: Work Breakdown Structure (WBS) | Task Name | TBC Vertex42: Total Budgeted Cost (TBC) | Jan | Feb | Mar | April | May | June | July | August | Sep | Oct | Nov | Dec | ← You can change the labels for the periods (e.g. Week 1/2/3, Jan/Feb/Mar, etc.) | |
| 1.1 | Retirement&social security benefits | 176 | 46 | 20 | 25 | 30 | 55 | ← Enter or edit values in the light-blue cells. | ||||||||
| 1.2 | Audit&risk evaluation | 143 | 25 | 43 | 25 | 30 | 50 | |||||||||
| 1.3 | Equipment&maintenance | 151 | 20 | 23 | 10 | 15 | 20 | 20 | 20 | |||||||
| 1.4 | Training&Development | 134 | 20 | 20 | 45 | 20 | 30 | 30 | 24 | |||||||
| 1.5 | Logistics,Appraisals&Rewards | 148 | 20 | 35 | 25 | 25 | 38 | 45 | ||||||||
| 0 | ||||||||||||||||
| 0 | ||||||||||||||||
| 0 | ||||||||||||||||
| 0 | ||||||||||||||||
| 0 | ||||||||||||||||
| 0 | ||||||||||||||||
| Insert new rows above this one | ← To add more tasks, insert rows above this one. You can or delete this row after you are done adding tasks. | |||||||||||||||
| Total Budgeted Cost | 752 | 46 | 45 | 88 | 98 | 135 | 145 | 65 | 75 | 88 | 69 | 0 | 0 | |||
| Cumulative Planned Value (PV) | 46 | 91 | 179 | 277 | 412 | 557 | 622 | 697 | 785 | 854 | 854 | 854 | ||||
| Actual Cost and Earned Value | ||||||||||||||||
| Cumulative Actual Cost (AC) | 48 | 126 | 229 | 325 | 439 | 531 | 607 | ← Enter the Actual Costs as calculated from the AC worksheet. | ||||||||
| Cumulative Earned Value (EV) | 26.4 | 101.15 | 232.24 | 311.45 | 460.4 | 553.7 | 627.35 | ← Enter the Earned Value as calculated from the EV worksheet. | ||||||||
| Project Performance Metrics | ||||||||||||||||
| Cost Variance (CV = EV - AC) | -21.6 | -24.85 | 3.24 | -13.55 | 21.4 | 22.7 | 20.35 | - | - | - | - | - | ||||
| Schedule Variance (SV = EV - PV) | -19.6 | 10.15 | 53.24 | 34.45 | 48.4 | -3.3 | 5.35 | - | - | - | - | - | ||||
| Cost Performance Index (CPI = EV/AC) | 0.55 | 0.80 | 1.01 | 0.96 | 1.05 | 1.04 | 1.03 | - | - | - | - | - | ||||
| Schedule Performance Index (SPI = EV/PV) | 0.57 | 1.11 | 1.30 | 1.12 | 1.12 | 0.99 | 1.01 | - | - | - | - | - | ||||
| Estimated Cost at Completion (EAC) | 1367 | 937 | 742 | 785 | 717 | 721 | 728 | - | - | - | - | - |
&8&K01+049https://www.vertex42.com/ExcelTemplates/earned-value-management.html &8&K01+049EVM Template © 2012 Vertex42 LLC
Planned Value (PV) Jan Feb Mar April May June July August Sep Oct Nov Dec 46 91 179 277 412 557 622 697 785 854 854 854 Earned Value (EV) Jan Feb Mar April May June July August Sep Oct Nov Dec 26.4 101.15 232.24 311.45000000000005 460.4 553.69999999 999993 627.35 Actual Cost (AC) Jan Feb Mar April May June July August Sep Oct Nov Dec 48 126 229 325 439 531 607Period
https://www.vertex42.com/ExcelTemplates/earned-value-management.html
EV
| Earned Value Worksheet | ||||||||||||||||
| This worksheet is used to help calculate the Earned Value (EV) or Budgeted Cost of Work Performed (BCWP). | Earned Value Management Template | |||||||||||||||
| Make sure that the WBS, Task Name, and TBC are identical to the table in the Report worksheet. | © 2012-2017 Vertex42 LLC | |||||||||||||||
| Enter the % Complete for each task to calculate the cumulative earned value. | ||||||||||||||||
| Cumulative Earned Value (EV) | ||||||||||||||||
| WBS | Task Name | TBC | Jan | Feb | March | Apr | May | June | July | Aug | Sep | Oct | Nov | Dec | ||
| 1.1 | Retirement&social security benefits | 176 | 15% | 20% | 45% | 100% | 85% | 80% | 100% | 100% | 100% | 100% | ||||
| 1.2 | Audit&risk evaluation | 143 | 25% | 50% | 15% | 55% | 70% | 65% | 45% | 75% | 100% | |||||
| 1.3 | Equipment&maintenance | 151 | 20% | 54% | 40% | 65% | 100% | 80% | 35% | 65% | 100% | |||||
| 1.4 | Training&Development | 134 | 40% | 100% | 60% | 100% | 55% | 80% | 100% | |||||||
| 1.5 | Logistics,Appraisals&Rewards | 148 | 55% | 70% | 40% | 70% | 90% | |||||||||
| - | - | 0 | ||||||||||||||
| - | - | 0 | ||||||||||||||
| - | - | 0 | ||||||||||||||
| - | - | 0 | ||||||||||||||
| - | - | 0 | ||||||||||||||
| - | - | 0 | ||||||||||||||
| - | - | 0 | ||||||||||||||
| Insert new rows above this one | ||||||||||||||||
| Cumulative EV | 26.4 | 101.15 | 232.24 | 311.45 | 460.4 | 553.7 | 627.35 | 426.1 | 592.2 | 737.2 | 0 | 0 |
AC
| Actual Cost Worksheet | ||||||||||||||||
| Use this worksheet to help calculate the Actual Cost (AC) of Work Performed (ACWP) by entering the costs incurred each period. | Earned Value Management Template | |||||||||||||||
| Make sure that the WBS, Task Name, and TBC are identical to the table in the Report worksheet. | © 2012-2017 Vertex42 LLC | |||||||||||||||
| Transfer the Cumulative Actual Cost to the Report worksheet. | ||||||||||||||||
| Actual Cost (AC) of Work Performed | ||||||||||||||||
| WBS | Task Name | Jan | Feb | March | April | May | June | July | Aug | Sep | Oct | Nov | Dec | |||
| 1.1 | Retirement&social security benefits | 48 | 25 | 52 | 21 | 30 | ||||||||||
| 1.2 | Audit&risk evaluation | 30 | 31 | 35 | 24 | 23 | ||||||||||
| 1.3 | Equipment&maintenance | 23 | 20 | 20 | 20 | 24 | 10 | 24 | 10 | |||||||
| 1.4 | Training&Development | 20 | 20 | 25 | 26 | 30 | 48 | 20 | ||||||||
| 1.5 | Logistics, Appraisals&Rewards | 20 | 20 | 40 | 26 | 20 | 22 | |||||||||
| - | - | |||||||||||||||
| - | - | |||||||||||||||
| - | - | |||||||||||||||
| - | - | |||||||||||||||
| - | - | |||||||||||||||
| - | - | |||||||||||||||
| Insert new rows above this one | ||||||||||||||||
| Total Actual Cost | 48 | 78 | 103 | 96 | 114 | 92 | 76 | 80 | 78 | 42 | 0 | 0 | ||||
| Cumulative Actual Cost (AC) | 48 | 126 | 229 | 325 | 439 | 531 | 607 | 687 | 765 | 807 | 807 | 807 |
©
| Earned Value Management (EVM) Template | |
| By Vertex42.com | |
| https://www.vertex42.com/ExcelTemplates/critical-path-method.html | |
| © 2012-2017 Vertex42 LLC | |
| This spreadsheet, including all worksheets and associated content is a copyrighted work under the United States and other copyright laws. | |
| Do not submit copies or modifications of this template to any website or online template gallery. | |
| Please review the following license agreement to learn how you may or may not use this template. Thank you. | |
| https://www.vertex42.com/licensing/EULA_privateuse.html | |
| Do not delete this worksheet. | |
