Alpha develops an IT solution for a company having inventory management issues. Alpha estimates a 12-week timeline for successfully deliver the solution. At the end of the 7th week the project manager receives project status report (see excel attachment).

2. How much longer will the project manager need to complete the project? (Provide answer in weeks)

Use Exhibit below for weekly Actual Cost and Earned Value, Project Performance Metrics

Budgeted Cost of Work Planned Value (PV) or Budgeted Cost of Work Scheduled (BCWS) WB Task Nam TBC 1 2 3 5 7 8 9 10 11 12 1.1 Task 1 3500 1000 500 2000 1.2 Task 2 4200 500 800 DOE 2000 1.3 Task 4500 700 2000 1000 800 1.4 Task 4 3300 200 600 1000 1500 1.5 Task 5 3000 700 500 1000 800 1.6 Task 6 6700 700 2000 1000 2000 1000 0 0 Insert new rows above this one Total Budgeted Cost 25200 1000 1000 3700 3500 4700 2800 1000 1500 2000 1000 2000 1000 Cumulative Planned Value (PV) Actual Cost and Earned Value Cumulative Actual Cost (AC) Cumulative Eamed Value (EV) Project Performance Metrics Cost Variance (CV = EV - AC) Schedule Variance (SV = EV - PV) Cost Performance Index (CPI = EV/AC) Schedule Performance Index (SPI = EV/PV) Estimated Cost at Completion (EAC)=BAC/CPI Estimated time at Completion =original time/SPIActual Work Done Actual Cost (AC) of Work Performed WBS Task Name Wk 1 Wk 2 Wk 3 Wk 4 Wk 5 WK 6 WK 7 Wk 8 Wk 9 Wk 10 Wk 11 1.1 Task 1 Wk 12 800 250 1500 1.2 Task 2 900 700 1200 1700 1.3 Task 3 300 300 1250 1500 1.4 Task 4 100 500 900 700 400 1.5 Task 5 400 600 500 1.6 Task 6 Insert new rows above this one Total Actual Cost 800 1150 2600 2000 4250 2800 900 0 0 0 0 0Earned Value Cumulative Earned Value (EV) WBS Task Name TBC Wk 1 Wk 2 Wk 3 Wk 4 Wk 5 Wk 6 Wk 7 Wk 8 Wk 9 Wk 10 Wk 11 Wk 12 1.1 Task 1 3500 15% 50% 100% 100% 100% 100% 100% 1.2 Task 2 4200 25% 30% 60% 75% 90% 100% 1.3 Task 3 4500 25% 40% 50% 100% 100% 1.4 Task 4 3300 25% 80% 90% 1.5 Task 5 3000 25% 75% 1.6 Task 6 6700 50% 0 0 0 Insert new rows above this one Cumulative EV