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% · first month: compared with the tender

Forecast final value £480,000 £0 on last month
Forecast final cost £412,800 £0 on last month
Forecast margin £67,200 14.0% · 0.00 pp
Cash outstanding £17,400 plus £4,600 retention

The CVR

This monthTenderMovement
Forecast final measure £480,000 £480,000 £0
Recognised change £0 £0 £0
Less deductions / contras £0 £0 £0
Forecast final value £480,000 £480,000 £0
Forecast final cost £412,800 £412,800 £0
Forecast margin £67,200 £67,200 £0
Forecast margin % 14.0% 14.0% 0.00 pp
Against tender0.00 pp
Internal valuation (not cash) £95,000 £0 +£95,000
Margin to date (valuation less cost to date) £8,800 £0 +£8,800
Over / (under) measure £3,000 £0 +£3,000
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 £32,000 £0 £118,000 £150,000 £0 Days x rate lazy
Labour-only subs £90,000 £18,000 £0 £72,000 £90,000 £0 Order +/- variations lazy
Materials £120,000 £26,000 £0 £94,000 £120,000 £0 Remeasure x current rates lazy
Plant & access £22,800 £6,000 £0 £16,800 £22,800 £0 Time-related lazy
Sub-subcontract £15,000 £0 £0 £15,000 £15,000 £0 Order +/- variations lazy
Site overheads £15,000 £4,200 £0 £10,800 £15,000 £0 Time-related lazy

Why the margin moved

The forecast margin is unchanged from the tender at 14.0%.

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

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

    Own labour, Labour-only subs, 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£98,000
Main contractor's gross valuation£92,000
Retention held£4,600
Deductions accepted£0
Net due£87,400
Paid to date (gross of CIS)£70,000
Outstanding£17,400
CIS deducted (memo)£6,300

Margin trend

Jun 202614.0%£67,200