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

Forecast final value £145,000 £0 on last month
Forecast final cost £0 −£123,250 on last month
Forecast margin £145,000 100.0% · +85.00 pp
Cash outstanding £0 plus £0 retention

The CVR

This monthTenderMovement
Forecast final measure £145,000 £145,000 £0
Recognised change £0 £0 £0
Less deductions / contras £0 £0 £0
Forecast final value £145,000 £145,000 £0
Forecast final cost £0 £123,250 −£123,250
Forecast margin £145,000 £21,750 +£123,250
Forecast margin % 100.0% 15.0% +85.00 pp
Against tender+85.00 pp
Internal valuation (not cash) £0 £0 £0
Margin to date (valuation less cost to date) £0 £0 £0
Over / (under) measure £0 £0 £0
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 £40,000 £0 £0 £0 £0 −£40,000 —
Labour-only subs £25,000 £0 £0 £0 £0 −£25,000 —
Materials £40,000 £0 £0 £0 £0 −£40,000 —
Plant & access £7,250 £0 £0 £0 £0 −£7,250 —
Sub-subcontract £5,000 £0 £0 £0 £0 −£5,000 —
Site overheads £6,000 £0 £0 £0 £0 −£6,000 —

Why the margin moved

Forecast margin up 85.00 pp on the tender, to 100.0% (+£123,250). Biggest movements: Own labour +£40,000; Materials +£40,000; Labour-only subs +£25,000.

Forecast final measure£0
Recognised change£0
Deductions / contras£0
Own labour+£40,000
Labour-only subs+£25,000
Materials+£40,000
Plant & access+£7,250
Sub-subcontract+£5,000
Site overheads+£6,000
Total = margin movement+£123,250

Ties out to the margin movement.

Checks

2 to look at
  • 1. Value and cost entered for this monthLook at this

    No value entered for this month.

    Why it matters: A job with no figures for the month carries last month's position forward silently, so the company total is out of date.

    What to do: Add the job's value and costs for the month, or pick the right month.

  • 2. Accruals carried from an earlier monthOK
  • 3. Recognition overridden without a reasonOK
  • 4. Cost to complete is just budget less cost to dateOK
  • 5. Negative cost to completeOK
  • 6. Big margin move, or well above tenderLook at this

    Forecast margin moved +85.00 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£0
Main contractor's gross valuation£0
Retention held£0
Deductions accepted£0
Net due£0
Paid to date (gross of CIS)£0
Outstanding£0
CIS deducted (memo)£0

Margin trend

The trend starts once there are two month-ends.