Earned Value Analysis Exercise Note: 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 1st, sand samples on February 1st, and water samples on March 1st. The table below depicts the project performance plan: Activity Start End Time # of Total Samples Cost Sample Rock Jan 1st May 31st 5 months 500 $100,000 Sample Sand Feb 1st May 31st 4 months 1,000 $100,000 Sample Water Mar 1st May 31st 3 months 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 # of Samples Activity Start Time Tested Actual Cost Sample Rock Jan 1 3 months 200 $45,000 Sample Sand Feb 15 2 months $40,000 Sample Water Mar 14 1 month 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 Activity AC CV SV EAC Sample Rock Sample Sand Sample Water Total 450 PV EV Terms and Equations for Earned Value Analysis Term Description PV Planned Value EV Earned Value AC Actual Cost BAC Budget at Completion EAC Estimate at Completion ETC Estimate to Complete VAC Variance at Completion TERM Cost Variance (CV) Schedule Variance (SV) Cost Performance Index (CPI) Schedule Performance Index (SPI) Estimate at Completion (EAC) Use this equation Estimate to Complete (ETC) Variance at Completion (VAC) FORMULA EV - AC EV - PV EV / AC EV/PV BAC / CPI* EAC - AC BAC - EAC