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).

1. At the end of week 7, is the project performing according to the plan? How do you know this? (Answer using project performance metrics)

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

3. How much additional cost will the project manager need to complete the project? Use Exhibit below for weekly Actual Cost and Earned Value, Project Performance Metrics

Actual 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 Wk 12 1.1 Task 1 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 0Budgeted Cost of Work Planned Value (PV) or Budgeted Cost of Work Scheduled (BCWS) WBS Task Nam TBC 2 3 5 6 7 8 9 10 11 12 1.1 Task 1 3500 1000 500 2000 1.2 Task 2 4200 500 800 900 2000 1.3 Task 3 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 O 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 Earned 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/SPIEarned Value Cumulative Earned Value [EV] was Task Name TBC wk1 wk2 wk3 wk4 wk5 wk5 wk? wks wk9 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% 50% 25% 30% 100% 1.3 Task 3 4500 25% 40% 50% 100% 100% 1.4 Task 4 3300 25% 30% 90% 1.5 Task 5 3000 25% 25% 1.5 Task 5 5200 50% - 0 - 0 - 0 - 0 - 0 - 0 Insert new rows above this one Cumulative EV