EVA; 450 cum brickwork canal

Given data

• Quantity = 450 cum; rate = Rs 16,000 per cum, so $BAC = 450 \times 16{,}000 = 72{,}00{,}000$.
• Duration = 40 days; status date = day 20; work completed = 30 % of 450 = 135 cum.
• Actual rate = Rs 16,500 per cum. Planned work is assumed uniform with time.

Calculation

$$\begin{aligned} PV &= \frac{20}{40} \times 72{,}00{,}000 = 36{,}00{,}000 \quad (225\ \text{cum planned}) \\ EV &= 0.30 \times 72{,}00{,}000 = 21{,}60{,}000 \quad (135\ \text{cum}) \\ AC &= 135 \times 16{,}500 = 22{,}27{,}500 \end{aligned}$$ $$\begin{aligned} SV &= EV - PV = 21{,}60{,}000 - 36{,}00{,}000 = -14{,}40{,}000 \\ CV &= EV - AC = 21{,}60{,}000 - 22{,}27{,}500 = -67{,}500 \\ SPI &= \frac{EV}{PV} = \frac{21{,}60{,}000}{36{,}00{,}000} = 0.60 \\ CPI &= \frac{EV}{AC} = \frac{21{,}60{,}000}{22{,}27{,}500} = 0.97 \\ EAC &= \frac{BAC}{CPI} = \frac{72{,}00{,}000}{0.9697} = 74{,}25{,}000 \\ ETC &= EAC - AC = 74{,}25{,}000 - 22{,}27{,}500 = 51{,}97{,}500 \\ VAC &= BAC - EAC = 72{,}00{,}000 - 74{,}25{,}000 = -2{,}25{,}000 \\ \text{Forecast duration} &= \frac{40}{SPI} = \frac{40}{0.6000} = 66.7\ \text{days} \end{aligned}$$

Analysis of the situation

• Schedule: SV = -14,40,000 and SPI = 0.60, so the project is behind schedule; only 60 % of the planned work is done. If the same rate continues, the duration becomes 66.7 days against 40 days planned.
• Cost: CV = -67,500 and CPI = 0.97, so the project is over budget; each rupee spent has earned Rs 0.97 of work.
• Forecast: EAC = Rs 74,25,000 against BAC = Rs 72,00,000, i.e. a final overrun of Rs 2,25,000.

The cost overrun is small (CPI close to 1), but the schedule delay is serious: only 135 cum is done against 225 cum planned (SPI = 0.60), and the job needs about 67 days at the present rate. Er. Jack should add masons, arrange materials and curing in advance, and work extra shifts to recover the 90 cum backlog, while bringing the actual rate of Rs 16,500 per cum back towards the contract rate of Rs 16,000.

Answer: CV = Rs -67,500, SV = Rs -14,40,000, CPI = 0.97, SPI = 0.60; the project is behind schedule and slightly over budget.