Complete Exercise 2 Larson and Gray, complete the table below (note that SPI and CPI can be determined after the table is completed).Assume that cumulative EV, PV, CV, SV, SPI and CPI values are needed. At the end of Period 5, what is the status of this project (be specific)?

Discuss a strategy that you would use to communicate the status of the project to stakeholders. Use Microsoft Excel to complete this item and include all calculations in your Excel file. Note that showing all calculations in Excel is required.

2. On day 51 a project has an earned value of $600, an actual cost of $650, and a planned cost of $560. Compute the SV, CV, and CPI for the project. What is your assessment of the project on day 51? 6. The following labor hours data have been collected for a nanotechnology project for periods 1 through 6. Compute the SV, CV, SPI, and CPI for each period. Plot the EV and the AC on the summary graph provided (or a similar one). Plot the SPI, CPI, and PCIB on the index graph provided (or a similar one). What is your assess- ment of the project at the end of period 6? 2 5 2 4 1 3 7 2 6 2. Legend ES ID EF 4 6 SL SL 5 4 LS DUR LF Schedule information Baseline budget needs-labor hours (00) WP DUR ES LF SL Total PV Time period 6 7 8 0 1 2 4 5 9 10 11 12 13 14 1 2 0 2 0 20 10 10 2 2 2 7 3 24 16 00 3 6 2 11 3 30 5 5 5 10 3 2 10 2 2 1 4 5 2 7 0 25 10 10 5 4 4 11 3 16 4 4. 6 4 7 11 0 20 5 6 4 7 2 11 13 0 10 5 Total PV by period 10 10 31 9 5 6 4 5 5 Cumulative PV by period 10 20 51 74 90 99 106 120 125 131 135 140 145 Status Report: Ending Period 1 Task %Complete 1 50% Cumulative Totals EV CV SV || AC 500 500 PV 1000 1000 EV CV SV Status Report: Ending Period 2 Task %Complete 1 Finished Cumulative Totals AC 1500 1500 PV 2000 2000 CV SV EV 2000 PV 2000 Status Report: Ending Period 3 Task %Complete 1 Finished 2 0% 3 10% 4 20% Cumulative Totals AC 1500 0 200 500 2200 ||||| 2 Task CV SV EV 2000 AC 1500 PV 2000 Status Report: Ending Period 4 %Complete 1 Finished 2 50% 3 30% 4 40% Cumulative Totals 1000 SI|||| 800 1500 4800 CV SV EV 2000 PV 2000 Status Report: Ending Period 5 Task %Complete 1 Finished 2 Finished 3 50% 4 60% 5 25% Cumulative Totals AC 1500 2000 800 1500 400 6200 31||||| EV 2000 PV 2000 Status Report: Ending Period 6 Task %Complete 1 Finished 2 Finished 3 80% 4 80% 5 50% Cumulative Totals AC 1500 2000 2100 1800 600 8000 ||||| Period SPI CPI PCIB SPI=EV/PV CPI = EVIAC PCIB = EV/BAC 1 2 3 4 5 6 Summary Graph Indexes Periods 1-6 16000 2.20 PV 14000 2.00 1.80 12000 1.60 10000 1.40 Labor hours 8000 1.20 6000 Index 1.00 4000 .80 2000 .60 O 0 10 11 12 13 14 15 .40 6 7 8 9 Time periods .20 0 0 1 6 7 2 3 4 5 Time periods