Customer hires a contractor to tile 40 identical rooms in his office building. The customer purchased the tile and the contractor will be reimbursed for labor only. The contractor assumes he can complete one room per day at eight hours per day and at a cost of $1000/day or $1000 per room The planned cost is $40,000 and the planned duration is 40 days

Current status At the end of 6 weeks (30 days). The contractor has completed 24 rooms at a cost of 27,000. This includes a freak accident where the tiles for two offices had to be removed & replaced.

Create a project status table similar to the one below and calculate the values for: PV, EV, AC, BAC, CV, CPI, SV, SPI, EAC, ETC, VAC, TCPI

Round any indices to two decimals

Planned value (PV)

Earned value (EV)

Actual cost (AC)

Budget at Completion (BAC)

Estimate to Complete (ETC)

Variance at Completion (VAC)

To Complete Performance Index (TCPI)

Cost Variance (CV)

Schedule Variance (SV)

Cost Performance Index (CPI)

Schedule Performance Index (SPI)

Estimate at Completion (EAC)