Answer in excel

A project consists of six tasks. Task A is scheduled to begin at the start of Week 1 and finish at the end of Week 4. Task B is scheduled to begin at the start of Week 1 and finish at the end of Week 2. Task C is scheduled to begin at the start of Week 3 and end at the end of Week 4. Task D is scheduled to begin at the start of Week 1 and end at the end of Week 1. Task E is scheduled to begin at the start of Week 2 and end at the end of Week 4. Task F is scheduled to begin at the start of Week 4 and end at the end of Week 4. The budgeted cost for Task A is $10,000, for Task B is $2,000, for Task C is $3,000, for Task D is $1,000, for Task E is $6,000, and for Task F is $4,000. At the end of the third week, Task A is 80% complete, Task B is 100% complete, Task C is 40% complete, Task D is 100% complete, Task E is 55% complete, and Task F has not started. What is the SPI for the project at the end of the third week? Show the budgeted cost of work scheduled (BCWS) for each task, BCWP and SPI calculation. Is the project ahead, behind, or on schedule? Show your work/calculations so that partial credit can be provided.

The ACWP at the end of the third week for the project in the Problem above is $16,500. Determine the CPI for the project. Is the project over or under budget?