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 £482,400 +£2,400 on last month
Forecast final cost £414,800 +£2,000 on last month
Forecast margin £67,600 14.0% · +0.01 pp
Cash outstanding £19,400 plus £7,600 retention

The CVR

This monthLast monthMovement
Forecast final measure £480,000 £480,000 £0
Recognised change £2,400 £0 +£2,400
Less deductions / contras £0 £0 £0
Forecast final value £482,400 £480,000 +£2,400
Forecast final cost £414,800 £412,800 +£2,000
Forecast margin £67,600 £67,200 +£400
Forecast margin % 14.0% 14.0% +0.01 pp
Against tender+0.01 pp
Internal valuation (not cash) £159,400 £95,000 +£64,400
Margin to date (valuation less cost to date) £7,100 £8,800 −£1,700
Over / (under) measure £7,400 £3,000 +£4,400
Accruals as a share of cost to date0.0%

Cost by head

Highlighted: a lazy or negative cost to complete
HeadBudgetLedgerAccrualsTo completeForecast finalMovedBasis
Own labour £150,000 £56,000 £0 £95,000 £151,000 +£1,000 Days x rate
Labour-only subs £90,000 £33,000 £0 £58,000 £91,000 +£1,000 Order +/- variations
Materials £120,000 £44,000 £0 £76,000 £120,000 £0 Remeasure x current rates lazy
Plant & access £22,800 £9,500 £0 £13,300 £22,800 £0 Time-related lazy
Sub-subcontract £15,000 £3,000 £0 £12,000 £15,000 £0 Order +/- variations lazy
Site overheads £15,000 £6,800 £0 £8,200 £15,000 £0 Time-related lazy

Why the margin moved

Forecast margin up 0.01 pp on last month, to 14.0% (+£400). Biggest movements: Recognised change +£2,400; Own labour −£1,000; Labour-only subs −£1,000.

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

Ties out to the margin movement.

Checks

1 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

    Materials, Plant & access, Sub-subcontract, Site overheads.

    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 runningOK

Cash (not part of the margin)

Our application£162,000
Main contractor's gross valuation£152,000
Retention held£7,600
Deductions accepted£0
Net due£144,400
Paid to date (gross of CIS)£125,000
Outstanding£19,400
CIS deducted (memo)£11,250

Margin trend

Jun 202614.0%£67,200
Jul 202614.0%£67,600