Project management assignment
joshna
earned_value.xlsxEV data
| Earned Value Calculations for Project Name | |||||||||||||||||
| Prepared by: | Date: | ||||||||||||||||
| Note: Change the entries to meet your project needs. This data is from Figure 7-4 of Schwalbe's text Information Technology Project Management, Fourth Edition. | |||||||||||||||||
| Also make sure the formulas work properly based on the data you enter. | |||||||||||||||||
| To Date | Planned | Actual | |||||||||||||||
| Activity | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | PV | % Complete | % Complete | RV | EV |
| Plan and staff project | 4,000 | 4,000 | 8,000 | 100 | 100 | 100% | 8,000 | ||||||||||
| Analyze requirements | 6,000 | 6,000 | 12,000 | 100 | 100 | 100% | 12,000 | ||||||||||
| Develop ERDs | 4,000 | 4,000 | 8,000 | 100 | 100 | 100% | 8,000 | ||||||||||
| Design database tables | 6,000 | 4,000 | 10,000 | 100 | 100 | 100% | 10,000 | ||||||||||
| Design forms, reports, and queries | 8,000 | 4,000 | 8,000 | 75 | 50 | 67% | 5,333 | ||||||||||
| Construct working prototype | 10,000 | - 0 | - 0 | ||||||||||||||
| Test/evaluate prototype | 2,000 | 6,000 | - 0 | - 0 | |||||||||||||
| Incorporate user feedback | 4,000 | 6,000 | 4,000 | - 0 | - 0 | ||||||||||||
| Test system | 4,000 | 4,000 | 2,000 | - 0 | - 0 | ||||||||||||
| Document system | 3,000 | 1,000 | - 0 | - 0 | |||||||||||||
| Train users | 4,000 | - 0 | - 0 | ||||||||||||||
| Monthly Planned Value (PV) | 4,000 | 10,000 | 10,000 | 10,000 | 12,000 | 16,000 | 10,000 | 6,000 | 8,000 | 4,000 | 5,000 | 5,000 | 43,333 | ||||
| Cumulative Planned Value (PV) | 4,000 | 14,000 | 24,000 | 34,000 | 46,000 | 62,000 | 72,000 | 78,000 | 86,000 | 90,000 | 95,000 | 100,000 | |||||
| Monthly Actual Cost (AC) | 4,000 | 11,000 | 11,000 | 12,000 | 15,000 | ||||||||||||
| Cumulative Actual Cost (AC) | 4,000 | 15,000 | 26,000 | 38,000 | 53,000 | ||||||||||||
| Monthly Earned Value (EV) | 4,000 | 10,000 | 10,000 | 10,000 | 9,333 | ||||||||||||
| Cumulative Earned Value (EV) | 4,000 | 14,000 | 24,000 | 34,000 | 43,333 | ||||||||||||
| Project EV as of May 31 | 43,333 | ||||||||||||||||
| Project PV as of May 31 | 46,000 | ||||||||||||||||
| Project AC as of May 31 | $ 53,000 | ||||||||||||||||
| CV=EV-AC | $ (9,667) | ||||||||||||||||
| SV=EV-PV | $ (2,667) | ||||||||||||||||
| CPI=EV/AC | 81.761% | ||||||||||||||||
| SPI=EV/PV | 94.203% | ||||||||||||||||
| Estimate at Completion (EAC) | $ 122,308 | (original plan of $100,000 divided by CPI) | |||||||||||||||
| Estimated time to complete | 12.74 | (original plan of 12 months divided by SPI) | |||||||||||||||
EV chart
Chart1
| 4000 | 4000 | 4000 |
| 14000 | 15000 | 14000 |
| 24000 | 26000 | 24000 |
| 34000 | 38000 | 34000 |
| 46000 | 53000 | 44000 |
| 62000 | ||
| 72000 | ||
| 78000 | ||
| 86000 | ||
| 90000 | ||
| 95000 | ||
| 100000 |
BCWS or Cumulative Plan
ACWP or Cumulative Actual
BCWP or Cumulative EV
Month
$
Chart4
| 3 | 4 | 3 |
| 8 | 8 | 8 |
| 19 | 18 | 19 |
| 32 | 29 | 31 |
| 47 | 41 | 41.5 |
| 63 | 56 | 48.645 |
| 91 | 83 | 73.045 |
| 145 | ||
| 206 | ||
| 233 | ||
| 246 | ||
| 254 |
BCWS or Cumulative Plan
ACWP or Cumulative Actual
BCWP or Cumulative EV
Month
$
Sheet1
| Activity | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Plan | % Complete | EV |
| Plan and staff project | 4,000 | 4,000 | 8,000 | 100 | 8,000 | ||||||||||
| Analyze requirements | 6,000 | 6,000 | 12,000 | 100 | 12,000 | ||||||||||
| Develop ERDs | 4,000 | 4,000 | 8,000 | 100 | 8,000 | ||||||||||
| Design database tables | 6,000 | 4,000 | 10,000 | 100 | 10,000 | ||||||||||
| Design forms, reports, and queries | 8,000 | 4,000 | 12,000 | 50 | 6,000 | ||||||||||
| Construct working prototype | 10,000 | 10,000 | - 0 | - 0 | |||||||||||
| Test/evaluate prototype | 2,000 | 6,000 | 8,000 | - 0 | - 0 | ||||||||||
| Incorporate user feedback | 4,000 | 6,000 | 4,000 | 14,000 | - 0 | - 0 | |||||||||
| Test system | 4,000 | 4,000 | 2,000 | 10,000 | - 0 | - 0 | |||||||||
| Document system | 3,000 | 1,000 | 4,000 | - 0 | - 0 | ||||||||||
| Train users | 4,000 | 4,000 | - 0 | - 0 | |||||||||||
| Monthly Plan | 4,000 | 10,000 | 10,000 | 10,000 | 12,000 | 16,000 | 10,000 | 6,000 | 8,000 | 4,000 | 5,000 | 5,000 | 100,000 | 44,000 | |
| BCWS or Cumulative Plan | 4,000 | 14,000 | 24,000 | 34,000 | 46,000 | 62,000 | 72,000 | 78,000 | 86,000 | 90,000 | 95,000 | 100,000 | |||
| Monthly Actual | 4,000 | 11,000 | 11,000 | 12,000 | 15,000 | ||||||||||
| ACWP or Cumulative Actual | 4,000 | 15,000 | 26,000 | 38,000 | 53,000 | ||||||||||
| Monthly EV | 4,000 | 10,000 | 10,000 | 10,000 | 10,000 | ||||||||||
| BCWP or Cumulative EV | 4,000 | 14,000 | 24,000 | 34,000 | 44,000 | ||||||||||
| Project BCWP as of May 31 | 44,000 | ||||||||||||||
| Project BCWS as of May 31 | 46,000 | ||||||||||||||
| Project ACWP as of May 31 | $ 53,000 | ||||||||||||||
| CV=BCWP-ACWP | $ (9,000) | ||||||||||||||
| SV=BCWP-BCWS | $ (2,000) | ||||||||||||||
| CPI=BCWP/ACWP | 83% | ||||||||||||||
| SVI=BCWP/BCWS | 96% | ||||||||||||||
| Estimated cost at completion | $ 120,455 | (original plan of $100,000 divided by CPI of 83%) | |||||||||||||
| Estimated time to complete | 12.55 | (original plan of 12 months divided by SVI of 96%) | |||||||||||||
| Above for Figure 6-2 | |||||||||||||||
| Chart below for Figure 6-3 |
Sheet1
| 0 | 0 | 0 |
| 0 | 0 | 0 |
| 0 | 0 | 0 |
| 0 | 0 | 0 |
| 0 | 0 | 0 |
| 0 | 0 | 0 |
| 0 | 0 | 0 |
| 0 | ||
| 0 | ||
| 0 | ||
| 0 | ||
| 0 |
BCWS or Cumulative Plan
ACWP or Cumulative Actual
BCWP or Cumulative EV
Month
$
Sheet2
Sheet3
-
20,000
40,000
60,000
80,000
100,000
120,000
123456789101112
Month
$
Planned Value (PV)
Budget at Completion (BAC)
Actual Cost (AC)
Earned Value (EV)
Estimate at Completion (EAC)
