The following data was collected for Project Widget at Schuman Works. Data was collected following weeks 3 and 5. Note: AC = Actual Costs in the table below. This problem should be worked by hand or Excel, not using MSP.

Calculate EV and PV for each task and the total for the project for each time period. b. Calculate the CV, SV, CPI and SPI, ETC and EAC for the project (dont need each task) at each of those time periods. c. What can you say about the health of the project? 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? 3. (5 pts) Rework problem 1 parts a) and b) using MSP. Note that MSP does not calculate ETC. For this problem, upload your MSP file and copies (Task Tab, Copy, copy picture) for the initial project, the Tracking table and EV table for each week being tracked (3 and 5 with a total of 5 pictures). Paste these pictures into one word file. Upload the word doc and the MSP file. Make sure to include the top-level summary task, WBS numbers and highlight the critical path. Also show the status line for each status date tracking

1. (7 pts) The following data was collected for Project Widget at Schuman Works. Data was collected following weeks 3 and 5. Note: AC = Actual Costs in the table below. This problem should be worked by hand or Excel, not using MSP. Task Pred. Budget Duration (weeks) 2 2 - 2 3 2 % Completed After 3 weeks 100% 20% 10% 15% 0 % Completed After 5 weeks 100% 100% 45% 50% 20% 4 AC 5 weeks $4200 2700 4500 3500 1800 0 2 6 AC 3 weeks $4200 500 900 1350 0 0 0 $4000 2560 8400 6000 6400 4800 5600 5 Nam 2 5 4 6 3 7 5 4 0 0 8 6,7 4 0 0 0 a. Calculate EV and PV for each task and the total for the project for each time period. b. 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. What can you say about the health of the project? 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? 3. (5 pts) Rework problem 1 parts a) and b) using MSP. Note that MSP does not calculate ETC. For this problem, upload your MSP file and copies (Task Tab, Copy, copy picture) for the initial project, the Tracking table and EV table for each week being tracked (3 and 5 with a total of 5 pictures). Paste these pictures into one word file. Upload the word doc and the MSP file. Make sure to include the top-level summary task, WBS numbers and highlight the critical path. Also show the status line for each status date tracking