Project Execution
Veedish
Gauchito_EVM_Tool_Template-2015.xlsCalculation Sheet
| ID | Job Description | Immediate Predecessors | Planned Duration (Weeks) | Staff (Number) | Rate/Person/Week | Task Cost (BAC) |
| A | 1.0 ASSEMBLE ENGINE MOUNT | Start | 2 | 4 | $1,440 | $11,520 |
| B | 2.0 FIN PREPARATION | Start | 1 | 3 | $1,440 | $4,320 |
| C | 3.0 MARK FIN AND LAUNCH LUG LINES | Start | 1 | 3 | $1,440 | $4,320 |
| D | 4.0 INSERTING ENGINE MOUNT | A | 2 | 3 | $1,440 | $8,640 |
| E | 5.0 ATTACH FINS | D | 1 | 3 | $1,440 | $4,320 |
| F | 6.0 ATTACH SHOCK CORD | Start | 2 | 3 | $1,440 | $8,640 |
| G | 7.0 ASSEMBLE NOSE CONE | Start | 1 | 2 | $1,440 | $2,880 |
| H | 8.0 ATTACH PARACHUTE/SHOCK CORD | G | 1 | 1 | $1,440 | $1,440 |
| I | 9.0 ATTACH LAUNCH LUG | E | 1 | 1 | $1,440 | $1,440 |
| J | 10.0 PAINTING THE ROCKET | I | 1 | 4 | $1,440 | $5,760 |
| K | 11.0 APPLICATION OF DECALS | J | 1 | 1 | $1,440 | $1,440 |
| L | 12.0 APPLYING CLEAR COAT | K | 1 | 1 | $1,440 | $1,440 |
| M | 13.0 DISPLAY NOZZLE ASSEMBLY | K | 1 | 3 | $1,440 | $4,320 |
| N | 14.0 ROCKET PREFLIGHT | L | 1 | 2 | $1,440 | $2,880 |
| O | 15.0 PREPARE FOR TEST LAUNCH | N | 1 | 1 | $1,440 | $1,440 |
| 24 weeks Level of Effort | ||||||
| Blended Rate= | $1,440 | 11 weeks duration |
Performance Sheet
| BCWS (PV) TASK | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | BAC Totals | |||
| A | 1.0 ASSEMBLE ENGINE MOUNT | $0 | ||||||||||||||||||
| B | 2.0 FIN PREPARATION | $0 | ||||||||||||||||||
| C | 3.0 MARK FIN AND LAUNCH LUG LINES | $0 | ||||||||||||||||||
| D | 4.0 INSERTING ENGINE MOUNT | $0 | ||||||||||||||||||
| E | 5.0 ATTACH FINS | $0 | ||||||||||||||||||
| F | 6.0 ATTACH SHOCK CORD | $0 | ||||||||||||||||||
| G | 7.0 ASSEMBLE NOSE CONE | $0 | ||||||||||||||||||
| H | 8.0 ATTACH PARACHUTE/SHOCK CORD | $0 | ||||||||||||||||||
| I | 9.0 ATTACH LAUNCH LUG | $0 | ||||||||||||||||||
| J | 10.0 PAINTING THE ROCKET | $0 | ||||||||||||||||||
| K | 11.0 APPLICATION OF DECALS | $0 | ||||||||||||||||||
| L | 12.0 APPLYING CLEAR COAT | $0 | ||||||||||||||||||
| M | 13.0 DISPLAY NOZZLE ASSEMBLY | $0 | ||||||||||||||||||
| N | 14.0 ROCKET PREFLIGHT | $0 | ||||||||||||||||||
| O | 15.0 PREPARE FOR TEST LAUNCH | $0 | ||||||||||||||||||
| Equipment | $0 | |||||||||||||||||||
| Material | $0 | |||||||||||||||||||
| $0 | ||||||||||||||||||||
| Weekly Total | $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 | |||||||||
| ID | ACWP (AC) TASK | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | AC Totals | ||
| A | 1.0 ASSEMBLE ENGINE MOUNT | $0 | ||||||||||||||||||
| B | 2.0 FIN PREPARATION | $0 | ||||||||||||||||||
| C | 3.0 MARK FIN AND LAUNCH LUG LINES | $0 | ||||||||||||||||||
| D | 4.0 INSERTING ENGINE MOUNT | $0 | ||||||||||||||||||
| E | 5.0 ATTACH FINS | $0 | ||||||||||||||||||
| F | 6.0 ATTACH SHOCK CORD | $0 | ||||||||||||||||||
| G | 7.0 ASSEMBLE NOSE CONE | $0 | ||||||||||||||||||
| H | 8.0 ATTACH PARACHUTE/SHOCK CORD | $0 | ||||||||||||||||||
| I | 9.0 ATTACH LAUNCH LUG | $0 | ||||||||||||||||||
| J | 10.0 PAINTING THE ROCKET | $0 | ||||||||||||||||||
| K | 11.0 APPLICATION OF DECALS | $0 | ||||||||||||||||||
| L | 12.0 APPLYING CLEAR COAT | $0 | ||||||||||||||||||
| M | 13.0 DISPLAY NOZZLE ASSEMBLY | $0 | ||||||||||||||||||
| N | 14.0 ROCKET PREFLIGHT | $0 | ||||||||||||||||||
| O | 15.0 PREPARE FOR TEST LAUNCH | $0 | ||||||||||||||||||
| Equipment | $0 | |||||||||||||||||||
| Material | $0 | |||||||||||||||||||
| $0 | ||||||||||||||||||||
| Weekly Total | $0 | $0 | $0 | |||||||||||||||||
| Cumulative Cost (AC) | $0 | $0 | $0 | |||||||||||||||||
| ID | BCWP (EV) TASK | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | EV Totals | ||
| A | 1.0 ASSEMBLE ENGINE MOUNT | $0 | ||||||||||||||||||
| B | 2.0 FIN PREPARATION | $0 | ||||||||||||||||||
| C | 3.0 MARK FIN AND LAUNCH LUG LINES | $0 | ||||||||||||||||||
| D | 4.0 INSERTING ENGINE MOUNT | $0 | ||||||||||||||||||
| E | 5.0 ATTACH FINS | $0 | ||||||||||||||||||
| F | 6.0 ATTACH SHOCK CORD | $0 | ||||||||||||||||||
| G | 7.0 ASSEMBLE NOSE CONE | $0 | ||||||||||||||||||
| H | 8.0 ATTACH PARACHUTE/SHOCK CORD | $0 | ||||||||||||||||||
| I | 9.0 ATTACH LAUNCH LUG | $0 | ||||||||||||||||||
| J | 10.0 PAINTING THE ROCKET | $0 | ||||||||||||||||||
| K | 11.0 APPLICATION OF DECALS | $0 | ||||||||||||||||||
| L | 12.0 APPLYING CLEAR COAT | $0 | ||||||||||||||||||
| M | 13.0 DISPLAY NOZZLE ASSEMBLY | $0 | ||||||||||||||||||
| N | 14.0 ROCKET PREFLIGHT | $0 | ||||||||||||||||||
| O | 15.0 PREPARE FOR TEST LAUNCH | $0 | ||||||||||||||||||
| Equipment | $0 | |||||||||||||||||||
| Material | $0 | |||||||||||||||||||
| $0 | ||||||||||||||||||||
| Weekly Total | $0 | $0 | $0 | |||||||||||||||||
| Cumulative Cost (EV) | $0 | $0 | $0 | |||||||||||||||||
| Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | |||||
| Cumulative Cost (PV) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
| Cumulative Cost (AC) | $0 | $0 | $0 | |||||||||||||||||
| Cumulative Cost (EV) | $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 $xxK 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 isxx% over/under BAC and is/is not in trouble. |
May 22-28
May 29-Jun 4
Jun 5-Jun 11
Jun 12-Jun18
Jun 19-Jun 25
Jun 26-Jul 2
Jul 3-Jul9
Jul 10-Jul 16
Jul 17-Jul23
Jul 24-Jul30
Jul 31-Aug 6
Aug 7-Aug 13
Performance Sheet
Cumulative Cost (PV)
Cumulative Cost (AC)
Cumulative Cost (EV)
BAC=$xxx,xxxx
EAC=$xxx,xxx
Planned Value (PV) Section
Earned Value (EV) Section
Actual Cost (AC) Section
Cumulative or S-Curve Graph
Performance Measures Section
