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 £265,600 +£5,600 on last month
Forecast final cost £259,000 +£20,000 on last month
Forecast margin £6,600 2.5% · −5.60 pp
Cash outstanding £20,280 plus £3,720 retention

The CVR

This monthLast monthMovement
Forecast final measure £260,000 £260,000 £0
Recognised change £5,600 £0 +£5,600
Less deductions / contras £0 £0 £0
Forecast final value £265,600 £260,000 +£5,600
Forecast final cost £259,000 £239,000 +£20,000
Forecast margin £6,600 £21,000 −£14,400
Forecast margin % 2.5% 8.1% −5.60 pp
Against tender−9.52 pp
Internal valuation (not cash) £130,100 £82,000 +£48,100
Margin to date (valuation less cost to date) £6,900 £4,300 +£2,600
Over / (under) measure £6,100 £2,000 +£4,100
Accruals as a share of cost to date1.8%

Cost by head

Highlighted: a lazy or negative cost to complete
HeadBudgetLedgerAccrualsTo completeForecast finalMovedBasis
Own labour £90,000 £52,000 £0 £52,000 £104,000 +£10,000 Days x rate
Labour-only subs £50,000 £26,000 £0 £31,000 £57,000 +£5,000 Order +/- variations
Materials £60,000 £30,000 £2,200 £36,000 £68,200 +£4,000 Remeasure x current rates
Plant & access £12,800 £6,800 £0 £6,500 £13,300 +£500 Time-related
Sub-subcontract £8,000 £2,000 £0 £6,000 £8,000 £0 Order +/- variations lazy
Site overheads £8,000 £4,200 £0 £4,300 £8,500 +£500 Time-related

Why the margin moved

Forecast margin down 5.60 pp on last month, to 2.5% (−£14,400). Biggest movements: Own labour −£10,000; Recognised change +£5,600; Labour-only subs −£5,000.

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

Ties out to the margin movement.

Checks

3 to look at
  • 1. Value and cost entered for this monthOK
  • 2. Accruals carried from an earlier monthLook at this

    Confirm 1 carried accrual(s).

    Why it matters: An accrual left in for another month may already be on the ledger (counted twice) or may never be invoiced. Old ones are the riskiest.

    What to do: Confirm each one is still owed, with a reason, or release it.

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

    Forecast margin moved -5.60 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£128,000
Main contractor's gross valuation£124,000
Retention held£3,720
Deductions accepted£0
Net due£120,280
Paid to date (gross of CIS)£100,000
Outstanding£20,280
CIS deducted (memo)£10,000

Margin trend

Jun 202612.0%£31,200
Jul 20268.1%£21,000
Aug 20262.5%£6,600