Analyze each activity separately Angel Construction Company awarded a contract for material testing of soil and aggregate samples for the investigative site work for a large highway project. The contract calls for the ABC Testing Company to collect and test 500 rock samples at a rate of 100 per month; 1,000 sand samples at a rate of 250 per month; and 600 water samples at a rate of 200 per month. Testing of the rock samples is to start on January 1, sand samples on February 1, and water samples on March 1. The table below depicts the project performance plan Activity Start End Time Sample Rock Jan 1st May 31 5 months Sample Sand Feb 1st May 31st 4 months Sample Water Mar 1 May 31 3 months Total Cost # of Samples 500 $100,000 1,000 $100,000 600 $180,000 Total $380,000 At the end of March, the ABC Testing Company has been working for three months, but struggling in performing the tests. The table below presents the project status as of March 31. Elapsed Time # of Samples Tested Activity Sample Rock Start Jan 1st 3 months Sample Sand Feb 1 2 months Sample Water Mar 1 1 month Actual Cost 200 $45,000 450 $40,000 200 $65,000 Total $150,000 Your task is to determine the schedule and cost performance to date and to predict the outcome of the project. Complete the following table assuming the performance pattern will remain constant: Earned Value Analysis Summary CV EV AC PV SV EAC Activity Sample Rock Sample Sand Sample Water PV EV AC BAC Total Terms and Equations for Earned Value Analysis Term Description Planned Value Earned Value Actual Cost Budget at Completion EAC Estimate at Completion ETC Estimate to Complete VAC Variance at Completion TERM FORMULA Cost Variance (CV) EV-AC Schedule Variance (SV) EV-PV Cost Performance Index (CPI) EV/AC Schedule Performance Index (SPI) EV/PV Estimate at Completion (EAC) Use this equation BAC/CPI Estimate to Complete (ETC) EAC-AC Variance at Completion (VAC) BAC-EAC