3. (10 pts) After 20 days of work on the project, you run the following earned value report, but for an unknown reason it is not complete. Complete the table below and determine the project performance metrics. HINT: Use project performance metrics on Page 6 Steel Buildings, Inc. RP-47 EARNED VALUE REPORT - QUANTITY Crazy Cam's Cars 20:44 REPORT DATE: 10APR13 PAGE: 1 OF 1 ACTIVITY FILTER: All START DATE: 20MAR13 FINISH DATE: 30APR13 DATA DATE: 9APR13 CUMULATIVE TO DATE VARIANCE AT COMPLETION ACTIVITY ID DESCRIPTION PCT COMP ACWP BCWP BCWS COST SCHEDULE ESTIMATE BUDGET A1000 Foundations & Utilities 100% $ 14,700.00 $ 15,000.00 $ 15,000.00 $ 24,000.00 A1010 Structural Steel 100% $ 26,500.00 A1020 Floor Slab 100% $ 7,500.00 $ 24,000.00 $ 8,000.00 $ 3,500.00 $ 8,000.00 A1030 Roof Decking 60% $ 3,300.00 $ 4,000.00 A1040 Windows and Doors 100% $ 1,800.00 $ 2,000.00 $ 2,000.00 A1050 Electrical 0% $ $ $ 16,000.00 $ 6,000.00 A1060 Mechanical 0% $ $ A1070 Siding 20% $ 900.00 $ 1,400.00 $ 4,200.00 A1080 Insulation 0% $ $ $ 2,100.00 A1090 Interior Finishes 0 % $ $ $ 6,500.00 TOTAL 0% $ 54,700.00 $ 53,900.00 $ 87,800.00 Inputs Budgeted Cost of Work Scheduled (BCWS) - estimated cost of the work planned to be completed to date Budgeted Cost of Work Performed (BCWP) - estimated cost of the work completed to date Actual Cost of Work Performed (ACWP) - cost incurred for the work completed to date Budgeted Cost a Completion (BAC) - original estimated cost for the total project Planned Percent Complete (PPC) - percentage of total work planned to be completed to date BCWS PPC BAC Schedule Metrics Schedule Variance (SV)-deviation from the schedule In monetary terms: SV = BCWP-BCWS (+) values indicate ahead of schedule As a percentage of the plan: (BCWP-BCWS) SV%- BCWS Schedule Performance Index (SPI) ratio of work performed to work planned, based on estimated costs SPI>1 indicates ahead of schedule BCWS Cost Metrics Cost Variance (CV) - deviation from the budget In monetary terms: CV = BCWP-ACWP (+) values indicate under budget As a percentage of the plan: (BCWP-ACWP) CV%= BCWP Cost Performance Index (CPI) - ratio of actual to estimated costs, based on the work completed to date CPI= BCWP CPI >1 indicates under budget ACWP Project Metrics Estimated Cost at Completion (EAC) - current estimated cost for the total project based on actual cost performance to date and estimated costs of future work If all goes as planned: EAC = ACWP+(BAC - BCWP) If things continue as they have: SPI=BCWP EAC BAC CPI Percent Complete (PC) - percentage of total work completed to date based on estimated costs BCWP PC- BAC Page 6 of 11 (6 pts) a. The project is currently schedule and budget. b. The project is currently percent complete and was planned to be percent complete. c. The project SPI is and the project CPI is
