iEvery job's quoted revenue, approved variations, budget against actual labour and materials, open purchase commitments and expected margin.
Contract + approved variations
$869,267
$22,840 in variations
Forecast cost
$640,236
labour $196,796 · materials $250,158
Expected margin
$229,031
26.3% of revenue
Open purchase commitments
$76,560
ordered, not yet received
Claimed / invoiced / paid
$376,848
$347,469 invoiced · $241,101 paid
| Job | Status | Contract | Variations | Revenue | Labour — actual vs budget | Materials — received + committed vs budget | Forecast cost | Expected margin | Claimed | Invoiced | Paid | To claim |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| J-26-042 Lower Hunter Water Services Pty Ltd | Procurement | $216,846 | — +$2,850 pending | $216,846 | $3,979 / $34,000 · 50 of 420 h | $10,656 + $67,810 / $115,018 | $163,818 | $53,028 24.5% · quoted 24% | $0 | $0 | $0 | $216,846 |
| J-26-041 Wollombi Coal Operations Pty Ltd | In production | $80,624 | $8,640 +$6,200 pending | $89,264 | $6,624 / $13,660 · 94.5 of 174 h | $41,704 + $1,580 / $49,244 | $65,904 | $23,360 26.2% · quoted 26% | $19,350 | $19,350 | $0 | $69,914 |
| J-26-040 Hexham Industrial Maintenance | Planning | $31,694 | — | $31,694 | $0 / $9,444 · 0 of 114 h | $0 + $0 / $3,680 | $22,824 | $8,870 28% · quoted 28% | $0 | $0 | $0 | $31,694 |
| J-26-039 Muswellbrook Quarry Products | In production | $32,750 | — | $32,750 | $5,297 / $11,328 · 73.2 of 150 h | $0 + $0 / $0 | $23,098 | $9,652 29.5% · quoted 29% | $0 | $0 | $0 | $32,750 |
| J-26-038 Myall Coast Regional Council | In production | $34,331 | — | $34,331 | $1,998 / $8,432 · 27.3 of 106 h | $7,125 + $7,170 / $14,295 | $24,727 | $9,604 28% · quoted 28% | $0 | $0 | $0 | $34,331 |
| J-26-037 Kooragang Bulk Handling Pty Ltd | On site | $62,391 | — | $62,391 | $8,012 / $15,092 · 116.2 of 188 h | $26,420 + $0 / $26,420 | $44,612 | $17,779 28.5% · quoted 28% | $24,083 | $4,991 | $0 | $38,308 |
| J-26-036 Bowen Basin Dewatering Pty Ltd | In production | $44,806 | — | $44,806 | $4,069 / $9,300 · 56 of 122 h | $21,978 + $0 / $21,978 | $33,128 | $11,678 26.1% · quoted 26% | $25,540 | $25,540 | $11,538 | $19,267 |
| J-26-035 Kooragang Bulk Handling Pty Ltd | On site | $34,120 | — | $34,120 | $8,983 / $20,608 · 133.7 of 256 h | $0 + $0 / $0 | $21,808 | $12,312 36.1% · quoted 36% | $22,093 | $22,093 | $12,369 | $12,027 |
| J-26-033 Ravensworth Ridge Mining Pty Ltd | Commissioning | $203,784 | $14,200 | $217,984 | $27,771 / $28,540 · 436.8 of 366 h | $65,715 + $0 / $75,615 | $168,255 | $49,729 22.8% · quoted 22% | $205,757 | $195,469 | $152,878 | $12,227 |
| J-26-032 Bowen Basin Dewatering Pty Ltd | In production | $65,942 | — | $65,942 | $17,696 / $27,256 · 261.7 of 372 h | $0 + $0 / $1,470 | $45,826 | $20,116 30.5% · quoted 31% | $50,280 | $50,280 | $42,203 | $15,661 |
| J-26-031 Ravensworth Ridge Mining Pty Ltd | On site | $39,140 | — | $39,140 | $13,006 / $19,136 · 191.2 of 242 h | $0 + $0 / $0 | $26,236 | $12,904 33% · quoted 33% | $29,746 | $29,746 | $22,114 | $9,394 |
| Total | $846,427 | $22,840 | $869,267 | $97,434 / $196,796 | $173,598 + $76,560 / $307,720 | $640,236 | $229,031 26.3% | $376,848 | $347,469 | $241,101 | $492,418 |
Forecast cost takes the larger of budget and actual for labour (timesheets at internal rates) and materials (received from POs or drawn from stock, plus orders still to arrive), plus other allowances from the quote. Supplier bills aren't added on top — the cost is counted once, when the goods are received.
Expected margin by job
J-26-042Lower Hunter Water Services Pty Ltd $53k J-26-041Wollombi Coal Operations Pty Ltd $23k J-26-040Hexham Industrial Maintenance $8.9k J-26-039Muswellbrook Quarry Products $9.7k J-26-038Myall Coast Regional Council $9.6k J-26-037Kooragang Bulk Handling Pty Ltd $18k J-26-036Bowen Basin Dewatering Pty Ltd $12k J-26-035Kooragang Bulk Handling Pty Ltd $12k J-26-033Ravensworth Ridge Mining Pty Ltd $50k J-26-032Bowen Basin Dewatering Pty Ltd $20k J-26-031Ravensworth Ridge Mining Pty Ltd $13k
Table
| Margin | |
|---|---|
| J-26-042 · Lower Hunter Water Services Pty Ltd | $53k |
| J-26-041 · Wollombi Coal Operations Pty Ltd | $23k |
| J-26-040 · Hexham Industrial Maintenance | $8.9k |
| J-26-039 · Muswellbrook Quarry Products | $9.7k |
| J-26-038 · Myall Coast Regional Council | $9.6k |
| J-26-037 · Kooragang Bulk Handling Pty Ltd | $18k |
| J-26-036 · Bowen Basin Dewatering Pty Ltd | $12k |
| J-26-035 · Kooragang Bulk Handling Pty Ltd | $12k |
| J-26-033 · Ravensworth Ridge Mining Pty Ltd | $50k |
| J-26-032 · Bowen Basin Dewatering Pty Ltd | $20k |
| J-26-031 · Ravensworth Ridge Mining Pty Ltd | $13k |
Revenue on open jobs — where it's at
Paid $241kInvoiced, not paid $106kClaimed, not invoiced $29kStill to claim $492k
Table
| Paid | $241k | 28% |
| Invoiced, not paid | $106k | 12% |
| Claimed, not invoiced | $29k | 3% |
| Still to claim | $492k | 57% |