1.(7 pts) The following data was collected for Project Widget at Schuman Inc. Data was collected following weeks 3 (day 15) and 4 (day 20). Note: AC = Actual Costs in the table below. This problem should be worked by hand or Excel, not using MSP. % complete AC after 20 after 20 days days Task Duration Predecessors Budget % AC after 15 (days) complete days after 15 days A 5 $2560 100 2600 B 10 A 2800 100 2750 C 8 A 1920 100 2000 D 9 A 3240 95 3000 6 B 1730 20 450 F 10 3280 10 450 G 12 CD 3648 5 350 H 4 EF 1280 0 1 3 G 870 0 1 1 320 0 100 100 100 100 75 60 40 0 0 0 2600 2750 2000 3000 1450 2100 1400 0 DOO O (3 pts) Calculate EV and PV for each task and the total for the project for each time period. b. (3 pts) Calculate the CV, SV, CPI and SPI. ETC and EAC for the project (don't need each task) at each of those time periods. C. (1 pt) What can you say about the health of the project? 2: (3 pts) Rework the information for parts a and b of problem I using the 50/50% rule for the percent completion. Any change in the health? 1.(7 pts) The following data was collected for Project Widget at Schuman Inc. Data was collected following weeks 3 (day 15) and 4 (day 20). Note: AC = Actual Costs in the table below. This problem should be worked by hand or Excel, not using MSP. % complete AC after 20 after 20 days days Task Duration Predecessors Budget % AC after 15 (days) complete days after 15 days A 5 $2560 100 2600 B 10 A 2800 100 2750 C 8 A 1920 100 2000 D 9 A 3240 95 3000 6 B 1730 20 450 F 10 3280 10 450 G 12 CD 3648 5 350 H 4 EF 1280 0 1 3 G 870 0 1 1 320 0 100 100 100 100 75 60 40 0 0 0 2600 2750 2000 3000 1450 2100 1400 0 DOO O (3 pts) Calculate EV and PV for each task and the total for the project for each time period. b. (3 pts) Calculate the CV, SV, CPI and SPI. ETC and EAC for the project (don't need each task) at each of those time periods. C. (1 pt) What can you say about the health of the project? 2: (3 pts) Rework the information for parts a and b of problem I using the 50/50% rule for the percent completion. Any change in the health