Please Answer 11,13,15

Managing Costs 1I. A project consists of six tasks rt of Week 1 and finish at Week 4. Task B is scheduled to be Week 1 and finish at the end of Week 2 uled to begin at the start of Week 3 a of Week 4. Task D is scheduled to he Week 1 and end at the end of Week 1. 7 uled to begin at the start of Week 2 begin at the start of Week landsk 7atthestador 2. Task CiL of - d at e Finish ene e end task and of Week 4. Task F is scheduled to begin nd t the ed egin at the 4. The end Week 4 and end at the end of Week cost for Task A is $10,000, for Task B is s2gi C is $3,000, for Task D is $1,000, for Task Task 8 and for Task F is $4,000. At the end of the th 0, Task A is 80% complete, Task B is 100% comand week, c is 40% complete, Task D is 100% complete, Taka 55% complete, and Task F hasnot started. What is the SPI for the project at the end of the third week? 10 12. The ACWP at the end of the second week for the project in Problem 10 is $37,900. Determine the CPI for the 10 project. 13. The ACWP at the end of the third week for the project in Problem 11 is $16,500. Determine the CPI for the 12 12 project. 14. Determine the total estimated cost at completion and estimated cost to complete for the project in Problem 12, assuming the CPI remains the same through the ans ally remainder of the job. 15. Determine the total estimated cost at completion and estimated cost to complete for the project in Problem 13, assuming the CPI remains the same through the led nd 0 ed- remainder of the job nd for 16. Create a cost-loaded spreadsheet like the one shown in Figure 5. The spreadsheet should handle 12 weeks and 20 tasks. Use the spreadsheet to solve Problems 8 and S IS Hint: use a combination of absolute and relative re he ences to copy the formula for the first week of the tirst task to the remainder of the weeks and tasks