Demo with sample data. Anything you enter stays in this browser.

Style
MinimalPremiumClassic
Acme FabricationJob costing
  • Overview
  • Jobs
  • Time and materials
  • New quote
  • Rates
Jobs/J-1033

J-1033 Cable tray support brackets ×120

Customer:
Metro Rail Services
Type:
Structural steel
Status
CComplete

J-1033 lost money

Quoted at $9,800.00 ex GST with a 17.2% margin. Final cost was $9,935.00, so the margin is -$135.00 (-1.4%).

Quoted price ex GST
$9,800.00
Quoted 07/09/2026
Estimated cost
$8,115.50
17.2% margin on quote
Actual cost
$9,935.00
Completed 30/09/2026
Actual margin
-$135.00
-1.4%
Estimate and actual cost
Labour at each operator's cost rate, materials at the price paid, and overhead for every hour logged.
Quoted $9,800.00
Estimate$8,115.50
Actual$9,935.00
LabourMaterialsOverheadQuoted price
Cost lineEstimateActual
Labour hours62 h84 h
Labour$3,388.00$4,554.00
Materials$3,100.00$3,176.00
Overhead at $26.25/h$1,627.50$2,205.00
Total cost$8,115.50$9,935.00
Quoted price$9,800.00$9,800.00
Margin$1,684.50
17.2%
-$135.00
-1.4%
Hours logged
84 h in total.
DateOperatorHoursLabour cost
28/09/2026Sam Nguyen
28/09/2026
4 h$232.00
25/09/2026Sam Nguyen
25/09/2026
4 h$232.00
24/09/2026Sam Nguyen
24/09/2026
4 h$232.00
23/09/2026Sam Nguyen
23/09/2026
4 h$232.00
22/09/2026Sam Nguyen
22/09/2026
4 h$232.00
21/09/2026Sam Nguyen
21/09/2026
4 h$232.00
18/09/2026Sam Nguyen
18/09/2026
4 h$232.00
17/09/2026Sam Nguyen
17/09/2026
4 h$232.00
17/09/2026Priya Sharma
17/09/2026
2 h$108.00
16/09/2026Sam Nguyen
16/09/2026
4 h$232.00
16/09/2026Priya Sharma
16/09/2026
4 h$216.00
15/09/2026Tom Fraser
15/09/2026
4 h$136.00
15/09/2026Sam Nguyen
15/09/2026
4 h$232.00
15/09/2026Priya Sharma
15/09/2026
4 h$216.00
14/09/2026Tom Fraser
14/09/2026
4 h$136.00
14/09/2026Sam Nguyen
14/09/2026
4 h$232.00
14/09/2026Priya Sharma
14/09/2026
4 h$216.00
14/09/2026Marco Rossi
14/09/2026
2 h$130.00
11/09/2026Tom Fraser
11/09/2026
4 h$136.00
11/09/2026Sam Nguyen
11/09/2026
4 h$232.00
11/09/2026Priya Sharma
11/09/2026
4 h$216.00
11/09/2026Marco Rossi
11/09/2026
4 h$260.00
Materials
Stock logged by hand and supplier bills from Xero.
ItemQtyAmountSource
Hot-dip galvanising (outsourced)
29/09/2026
640 kg at $1.90
Xero PG-7751
640 kg
at $1.90
$1,216.00Xero PG-7751
Mild steel plate 12mm 2400×1200
11/09/2026
2 sheets at $980.00
Xero WSS-48197
2 sheets
at $980.00
$1,960.00Xero WSS-48197
Estimate on the quote
The labour and materials the quoted price was based on.
LabourHoursRateCost
Laser cut & fold16 h$54.00/h$864.00
Weld brackets40 h$58.00/h$2,320.00
QA & pack6 h$34.00/h$204.00
MaterialQtyCost
Mild steel plate 12mm 2400×12002 sheets
at $980.00
$1,960.00
Hot-dip galvanising (outsourced)600 kg
at $1.90
$1,140.00