Type Carpet Vinyl tile Ceramic tile Total Problem 1 A flooring subcontractor must install three types of flooring in an existing building: B Type Quantity (SF)* 2,600 1,200 3,330 7,130 Carpet

Vinyl Tile Ceramic Tile Total ONE UNIT с Quantity (SF Unit Price ($/SF) "Carpet is usually sold and installed by the square yard. We used square foot (SF) here for conformity with the other flooring types. 2,600 1,200 3,330 7,130 2.30 2.95 4.95 D Unit Price ($/SF) Total Price ($) 5,980 3,540 16,484 26,004 2.3 2.95 4.95 A. Analyze each subtask (carpet, vinyl tile, ceramic tile) individually; determine its status with regard to the budget and the schedule. Total Price ($) E 5,890 3,540 16,484 26,004 Type Carpet Vinyl tile Ceramic tile F The subcontractor is given 10 days to finish all the work. Assume he has crews to start all three jobs concurrently. Four days after the start of the work, he discovers the following: Perform an EV analysis of the preceding task: Quantity Installed (SF) Quantity Installed (SF) 1,500 800 750 1,500 800 750 3,050 G 3,150 2,488 3,638 Actual Cost Earned Value (AC/ACWP) In (EV/BCWP) in $ 9,276 3,450 2,360 3,713 H 9,523 Actual Cost ($) 3,150 2,488 3,638 Planned Value (PV/BCWS) ✓ $ 2392 1416 6593.4 10,401 Formulas/Equations : Cost Variance (CV) = BCWP - ACWP =EV-AC Schedule Variance (SV) = BCWP - BCWS-EV-PV Schedule Variance in days (SV, days) = SV($)/Daily planned budget Cost Performance Index (CPI) = BCWP/ACWP=EV/AC Schedule Performance Index (SPI) = BCWP/BCWS EV/PV Forecasted Cost Variance (FCV) = CV/%Complete Forecasted Schedule Variance (FSV) = SV/%Complete Cost Varlance (C Schedule Varlance in $ (SV) 300 -128 75 247 1,058 944 -2,881 K -879 % Completion SV (day 58 67 23 42.7769986 M CPI N O 1.796265 1.095238 1.442308 2.666667 0.948553 1.666667 -1.74769 1.020478 0.563063 P SPI FCV (~ FSV 520 3.113526 -192 330.78 -7.75976 4 -0.33799 1.026574 0.915502 576.2443 -0.79011