1. (7 pts) The following data was collected for Project Widget at Schuman Works. Data was collected following weeks 10 and 20. Note: AC = Actual Costs in the table below. This problem should be worked by hand or Excel, not using MSP. Task Pred. Duration (weeks) 5 6 4 2 3 4 5 6 7 8 000 9 10 - a. b. 2 2 3 3,4 4 5 6,7 8,9 78546 11 Budget $8000 9600 6400 11200 12800 17600 8400 6240 8640 % Completed After 10 weeks 100% 75% 90% 0 0 5% 0 0 0 AC 10 weeks $8,300 8000 5900 0 0 3000 0 0 0 % Completed After 20 weeks 100% 100% 100% 100% 100% 90% 30% 10% 0 AC 20 weeks $8,300 10,000 6500 11250 13000 16000 2400 650 0 (3 pts) Calculate EV and PV for each task and the total for the project for each time period. (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? (Must discuss the variances here) 2. (3 pts) Rework the information for parts a and b of problem 1 using the 50/50% rule for the percent completion. Any change in the health?