Solve using Excel

2) (16 pts) Cody Parker is the manager of a small project that consists of four tasks indicated in the AON precedence network below. Task A Task C START END Task B Task D Following what he learned in the Op Mgt 450, Cody and his staff planned to start each task at its early start time. The planned durations and resource costs for each task are given in the table below. Task Duration (wks) Planned Value $2,400 $2,800 $1,395 $840 At the end of week 6, Cody received the following status report indicating that task A was completed in 5 weeks and task C was in progress. Task Current Status Completed In progress In progress Not started Actual Costs to Date $2,550 $2,725 $325 $0 Percent of work completed 100% 90% 35% 0% a) Given this status report, what is the schedule and cost variances of each task? What is the schedule and cost variances of the project as a whole? What are the schedule and cost indices for each task and the project? What is the critical ratio of this project? b) Based on the information to date, what is your assessment of the current status of the project