Company summary

J103 Mill Lane offices fit-out

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

J103 Mill Lane offices fit-out

for Pennine Interiors Ltd · order £145,000, tender margin 15.0%

Forecast final value £152,000 +£7,000 on last month
Forecast final cost £124,750 +£1,500 on last month
Forecast margin £27,250 17.9% · +2.93 pp
Cash outstanding £34,700 plus £3,300 retention

The CVR

This monthLast monthMovement
Forecast final measure £150,000 £145,000 +£5,000
Recognised change £2,000 £0 +£2,000
Less deductions / contras £0 £0 £0
Forecast final value £152,000 £145,000 +£7,000
Forecast final cost £124,750 £123,250 +£1,500
Forecast margin £27,250 £21,750 +£5,500
Forecast margin % 17.9% 15.0% +2.93 pp
Against tender+2.93 pp
Internal valuation (not cash) £69,000 £30,500 +£38,500
Margin to date (valuation less cost to date) £14,300 £5,800 +£8,500
Over / (under) measure £3,000 £1,000 +£2,000
Accruals as a share of cost to date2.7%

Cost by head

Highlighted: a lazy or negative cost to complete
HeadBudgetLedgerAccrualsTo completeForecast finalMovedBasis
Own labour £40,000 £17,000 £0 £23,000 £40,000 £0 Days x rate lazy
Labour-only subs £25,000 £10,500 £0 £14,500 £25,000 £0 Order +/- variations lazy
Materials £40,000 £19,000 £1,500 £21,000 £41,500 +£1,500 Remeasure x current rates
Plant & access £7,250 £2,800 £0 £4,450 £7,250 £0 Time-related lazy
Sub-subcontract £5,000 £1,500 £0 £3,500 £5,000 £0 Order +/- variations lazy
Site overheads £6,000 £2,400 £0 £3,600 £6,000 £0 Time-related lazy

Why the margin moved

Forecast margin up 2.93 pp on last month, to 17.9% (+£5,500). Biggest movements: Forecast final measure +£5,000; Recognised change +£2,000; Materials −£1,500.

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

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 monthOK
  • 3. Recognition overridden without a reasonLook at this

    No reason given for VO-03.

    Why it matters: Overriding how much of a variation counts changes the margin. Without a reason, nobody can check the judgement later.

    What to do: Give every override a reason, or remove it.

  • 4. Cost to complete is just budget less cost to dateLook at this

    Own labour, Labour-only subs, 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 +2.93 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£68,000
Main contractor's gross valuation£66,000
Retention held£3,300
Deductions accepted£0
Net due£62,700
Paid to date (gross of CIS)£28,000
Outstanding£34,700
CIS deducted (memo)£2,240

Margin trend

Aug 202615.0%£21,750
Sep 202617.9%£27,250