iEvery job's quoted revenue, approved variations, budget against actual labour and materials, open purchase commitments and expected margin.
Contract + approved variations
$1,011,396
$22,840 in variations
Forecast cost
$744,570
labour $231,856 · materials $301,132
Expected margin
$266,826
26.4% of revenue
Open purchase commitments
$76,560
ordered, not yet received
Claimed / invoiced / paid
$518,977
$489,598 invoiced · $383,230 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-034 Wollombi Coal Operations Pty Ltd | Complete | $55,800 | — | $55,800 | $17,077 / $21,860 · 244.5 of 296 h | $0 + $0 / $0 | $39,260 | $16,540 29.6% · quoted 30% | $55,800 | $55,800 | $55,800 | $0 |
| 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 |
| J-26-029 Barrington Gold Pty Ltd | Complete | $86,329 | — | $86,329 | $10,862 / $13,200 · 163 of 166 h | $50,974 + $0 / $50,974 | $65,074 | $21,255 24.6% · quoted 25% | $86,329 | $86,329 | $86,329 | $0 |
| Total | $988,556 | $22,840 | $1,011,396 | $125,373 / $231,856 | $224,572 + $76,560 / $358,694 | $744,570 | $266,826 26.4% | $518,977 | $489,598 | $383,230 | $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-034Wollombi Coal Operations Pty Ltd $17k J-26-033Ravensworth Ridge Mining Pty Ltd $50k J-26-032Bowen Basin Dewatering Pty Ltd $20k J-26-031Ravensworth Ridge Mining Pty Ltd $13k J-26-029Barrington Gold Pty Ltd $21k
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-034 · Wollombi Coal Operations Pty Ltd | $17k |
| 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 |
| J-26-029 · Barrington Gold Pty Ltd | $21k |
Revenue on open jobs — where it's at
Paid $383kInvoiced, not paid $106kClaimed, not invoiced $29kStill to claim $492k
Table
| Paid | $383k | 38% |
| Invoiced, not paid | $106k | 11% |
| Claimed, not invoiced | $29k | 3% |
| Still to claim | $492k | 49% |