Company summary

J102 Riverside school extension

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

J102 Riverside school extension

for Calder Construction Ltd · order £260,000, tender margin 12.0%

Forecast final value £260,000 £0 on last month
Forecast final cost £239,000 +£10,200 on last month
Forecast margin £21,000 8.1% · −3.92 pp
Cash outstanding £15,600 plus £2,400 retention

The CVR

This monthLast monthMovement
Forecast final measure £260,000 £260,000 £0
Recognised change £0 £0 £0
Less deductions / contras £0 £0 £0
Forecast final value £260,000 £260,000 £0
Forecast final cost £239,000 £228,800 +£10,200
Forecast margin £21,000 £31,200 −£10,200
Forecast margin % 8.1% 12.0% −3.92 pp
Against tender−3.92 pp
Internal valuation (not cash) £82,000 £40,000 +£42,000
Margin to date (valuation less cost to date) £4,300 £6,000 −£1,700
Over / (under) measure £2,000 £1,000 +£1,000
Accruals as a share of cost to date2.8%

Cost by head

Highlighted: a lazy or negative cost to complete
HeadBudgetLedgerAccrualsTo completeForecast finalMovedBasis
Own labour £90,000 £32,000 £0 £62,000 £94,000 +£4,000 Days x rate
Labour-only subs £50,000 £16,000 £0 £36,000 £52,000 +£2,000 Order +/- variations
Materials £60,000 £19,000 £2,200 £43,000 £64,200 +£4,200 Remeasure x current rates
Plant & access £12,800 £4,500 £0 £8,300 £12,800 £0 Time-related lazy
Sub-subcontract £8,000 £1,000 £0 £7,000 £8,000 £0 Order +/- variations lazy
Site overheads £8,000 £3,000 £0 £5,000 £8,000 £0 Time-related lazy

Why the margin moved

Forecast margin down 3.92 pp on last month, to 8.1% (−£10,200). Biggest movements: Materials −£4,200; Own labour −£4,000; Labour-only subs −£2,000.

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

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

    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 tenderLook at this

    Forecast margin moved -3.92 pp.

    Why it matters: Boards distrust a margin that jumps, or one far better than the tender, unless the reason is written down.

    What to do: Explain the move in the reasons box before the meeting.

  • 7. Main contractor valuing below our application, three months runningOK

Cash (not part of the margin)

Our application£82,000
Main contractor's gross valuation£80,000
Retention held£2,400
Deductions accepted£0
Net due£77,600
Paid to date (gross of CIS)£62,000
Outstanding£15,600
CIS deducted (memo)£6,200

Margin trend

Jun 202612.0%£31,200
Jul 20268.1%£21,000