Company summary

J101 Station Road flats

Example Northgate Interiors Ltd, a fictional drylining subcontractor with three jobs over four month-ends. Look around; nothing here is saved. Sign up free to run yours

J101 Station Road flats

for Hallam Build Ltd · order £480,000, tender margin 14.0%

Forecast final value £489,000 +£6,600 on last month
Forecast final cost £422,350 +£7,550 on last month
Forecast margin £66,650 13.6% · −0.38 pp
Cash outstanding £25,200 plus £10,800 retention

The CVR

This monthLast monthMovement
Forecast final measure £480,000 £480,000 £0
Recognised change £9,000 £2,400 +£6,600
Less deductions / contras £0 £0 £0
Forecast final value £489,000 £482,400 +£6,600
Forecast final cost £422,350 £414,800 +£7,550
Forecast margin £66,650 £67,600 −£950
Forecast margin % 13.6% 14.0% −0.38 pp
Against tender−0.37 pp
Internal valuation (not cash) £224,000 £159,400 +£64,600
Margin to date (valuation less cost to date) £24,900 £7,100 +£17,800
Over / (under) measure £8,000 £7,400 +£600
Accruals as a share of cost to date5.7%

Cost by head

Highlighted: a lazy or negative cost to complete
HeadBudgetLedgerAccrualsTo completeForecast finalMovedBasis
Own labour £150,000 £78,000 £3,000 £74,000 £155,000 +£4,000 Days x rate
Labour-only subs £90,000 £46,500 £0 £45,000 £91,500 +£500 Order +/- variations
Materials £120,000 £41,000 £6,400 £79,000 £126,400 +£6,400 Remeasure x current rates
Plant & access £22,800 £11,200 £2,000 £11,600 £24,800 +£2,000 Time-related
Sub-subcontract £15,000 £4,000 £0 £11,000 £15,000 £0 Order +/- variations lazy
Site overheads £15,000 £7,000 £0 £2,650 £9,650 −£5,350 Time-related

Why the margin moved

Forecast margin down 0.38 pp on last month, to 13.6% (−£950). Biggest movements: Recognised change +£6,600; Materials −£6,400; Site overheads +£5,350.

Forecast final measure£0
Recognised change+£6,600
Deductions / contras£0
Own labour−£4,000
Labour-only subs−£500
Materials−£6,400
Plant & access−£2,000
Sub-subcontract£0
Site overheads+£5,350
Total = margin movement−£950

Ties out to the margin movement.

Checks

2 to look at
  • 1. Value and cost entered for this monthOK
  • 2. Accruals carried from an earlier monthOK
  • 3. Recognition overridden without a reasonOK
  • 4. Cost to complete is just budget less cost to dateLook at this

    Sub-subcontract.

    Why it matters: That isn't a forecast: it assumes the rest of the job goes exactly to budget, which hides overruns until the end.

    What to do: Rebuild cost to complete from the work left to do.

  • 5. Negative cost to completeOK
  • 6. Big margin move, or well above tenderOK
  • 7. Main contractor valuing below our application, three months runningLook at this

    7.5% below our application this month.

    Why it matters: A gap that persists is rarely timing. It is usually work they dispute, and it becomes a cash problem.

    What to do: Ask for their breakdown and check any pay less notices.

Cash (not part of the margin)

Our application£233,500
Main contractor's gross valuation£216,000
Retention held£10,800
Deductions accepted£0
Net due£205,200
Paid to date (gross of CIS)£180,000
Outstanding£25,200
CIS deducted (memo)£16,200

Margin trend

Jun 202614.0%£67,200
Jul 202614.0%£67,600
Aug 202613.6%£66,650