A project manager surveyed his earned value table at the conclusion of month 24 The results are shown in the table below. {5 values shown} The planned payment schedule is shown with % Complete which can be used to calculate earned value for each activity. Pay attention to the Actual Copy the table below into Excel and show your work by expanding or adding the necessary rows and columns and then add a small table Calculate the Total Budget at Completion (BAC) for the project Calculate the Schedule Variance and the SPI for this project at the end of the 24th month Calculate the Cost Variance and the CPI for the project at the end ofthe 24th month Calculate the Estimate at Completion Is the project on budget / over budget/ under budget? What is showing you this? What might this mean in terms oi upcoming payments for this project? Is the project on schedule / ahead of schedule / behind schedule? What is showing you this? How do you feel overall about the way this project is proceeding? What would you report to the project sponsor? Submit the result as a single MS Excel spreadsheet with your name in cell A1 and your student number in cell Bl Activity 4 8 12 15 20 24 28 TOTAL % Complete Concept Design 5500 $1,500 $2,033 $3,000 53,000 51,500 $11,503 85% Proposal $450 $4,533 $100 $100 $4,500 $9,653 93% Negotiations $500 $1,200 $1,703 103% Resource Acquisition $5 33 $503 103% Training S333 $750 $950 $2,003 103% Modeling $400 $1,000 $1,403 75% Planning $2,000 $500 $3,000 $2,000 $7,503 63% Testing S533 $500 $1,000 $4,000 $6,003 13% Control 51,200 $2,000 $3,203 33% Quality Assurance $100 $5 33 $500 $500 $500 $3,500 $5,603 53% Scope Verication $1,033 51,000 $6,000 $8,003 3 3% Contract Closure $2,000 $4,000 $6,003 43% Total Cumulative Total ActualCost 5500 $5,000 $11,000 $5,500 58,000 58,000 Cumulative Actual Cost 5.3-4 Snippir