Project Execution
Calculation Sheet
| ID | Job Description | Immediate Predecessors | Planned Duration (Months) | Staff (Number) | Rare/Person/Month | Task Cost (BAC) | 8 Mos Effort to Date (Mos) | % Complete | Outstanding Durtation (Mos) | Staff Level | ACWP (AC) | |
| A | Electrical Design | Start | 4 | 6 | $10,000 | $240,000 | 30 | 125% | 0 | 0 | $300,000 | |
| B | Assemble Boards | A | 4 | 3 | $10,000 | $120,000 | 9 | 75% | 1 | 3 | $90,000 | |
| C | Test Boards | B | 2 | 2 | $10,000 | $40,000 | 0 | 0% | 2 | 2 | $0 | |
| D | Software Design | Start | 4 | 1 | $10,000 | $40,000 | 4 | 100% | 0 | 0 | $40,000 | |
| E | Programming | D | 2 | 2 | $10,000 | $40,000 | 8 | 200% | 1 | 2 | $80,000 | |
| F | Software Testing | E | 2 | 2 | $10,000 | $40,000 | 0 | 0% | 4 | 2 | $0 | |
| G | Robot Body Design | A | 4 | 2 | $10,000 | $80,000 | 6 | 75% | 1 | 2 | $60,000 | |
| H | Robot Construction | G | 2 | 2 | $10,000 | $40,000 | 0 | 0% | 2 | 2 | $0 | |
| I | Final Assembly | C,F,H | 2 | 2 | $10,000 | $40,000 | 0 | 0% | 2 | 2 | $0 | |
| 26 | 22 | $680,000 | $570,000 | |||||||||
| Blended Rate= | $10,000 |
BCWS Gantt
| ID | BCWP (PV) TASK | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | BAC Totals | ||||||
| A | Electrical Design | $0 | ||||||||||||||||||
| B | Assemble Boards | $0 | ||||||||||||||||||
| C | Test Boards | $0 | ||||||||||||||||||
| D | Software Design | $0 | ||||||||||||||||||
| E | Programming | $0 | ||||||||||||||||||
| F | Software Testing | $0 | ||||||||||||||||||
| G | Robot Body Design | $0 | ||||||||||||||||||
| H | Robot Construction | $0 | ||||||||||||||||||
| I | Final Assembly | $0 | ||||||||||||||||||
| $0 | ||||||||||||||||||||
| Monthly Total | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||
| Cumulative Cost (PV) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||
| ID | ACWP (AC) TASK | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 13 | Month 14 | Month 15 | AC Totals | |||
| A | Electrical Design | $0 | ||||||||||||||||||
| B | Assemble Boards | $0 | ||||||||||||||||||
| C | Test Boards | $0 | ||||||||||||||||||
| D | Software Design | $0 | ||||||||||||||||||
| E | Programming | $0 | ||||||||||||||||||
| F | Software Testing | $0 | ||||||||||||||||||
| G | Robot Body Design | $0 | ||||||||||||||||||
| H | Robot Construction | $0 | ||||||||||||||||||
| I | Final Assembly | $0 | ||||||||||||||||||
| Monthly Total | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Cumulative Cost (AC) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||
| ID | BCWP (EV) TASK | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 13 | Month 14 | Month 15 | AC Totals | |||
| A | Electrical Design | $0 | ||||||||||||||||||
| B | Assemble Boards | $0 | ||||||||||||||||||
| C | Test Boards | $0 | ||||||||||||||||||
| D | Software Design | $0 | ||||||||||||||||||
| E | Programming | $0 | ||||||||||||||||||
| F | Software Testing | $0 | ||||||||||||||||||
| G | Robot Body Design | $0 | ||||||||||||||||||
| H | Robot Construction | $0 | ||||||||||||||||||
| I | Final Assembly | $0 | ||||||||||||||||||
| Monthly Total | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Cumulative Cost (EV) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |||||||||
| Cumulative Cost (PV) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||
| Cumulative Cost (AC) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||
| Cumulative Cost (EV) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||
| BAC= | 0 | |||||||||||||||||||
| BCWS (PV)= | 0 | |||||||||||||||||||
| ACWP (AC)= | 0 | |||||||||||||||||||
| BCWP (EV)= | 0 | |||||||||||||||||||
| SV= | BCWP-BCWS | CV= | BCWP-ACWP | |||||||||||||||||
| SV= | CV= | |||||||||||||||||||
| SV= | $0 | CV= | $0 | |||||||||||||||||
| Project is $xxK behind schedule | Project is $xxxK over budget | |||||||||||||||||||
| SPI= | BCWP/BCWS | CPI= | BCWP/ACWP | |||||||||||||||||
| SPI= | CPI= | |||||||||||||||||||
| SPI= | 0 | CPI= | 0 | |||||||||||||||||
| For every dollar spent on scheduled effort we realize $0.xx worth of progress. | For every dollar spent, we realize $0.xx of planned result. | |||||||||||||||||||
| EAC = | BAC/CPI | PM Eval= | +10% to -5% EAC | |||||||||||||||||
| EAC = | PM Eval= | EAC/BAC | ||||||||||||||||||
| EAC = | $0.00 | PM Eval= | 0% | EAC | ||||||||||||||||
| The PM's EAC is XX% over/under BAC and is in trouble/not in trouble. |
BCWS Gantt
Cumulative Cost (PV)
Cumulative Cost (AC)
Cumulative Cost (EV)
Sheet3
BAC=$XXX,XXX
EAC=$XXX,XXX