Overview

Margin on every job and customer at Acme Fabrication, counting labour, materials and overhead.

New quote Log time and materials

Revenue ex GST: $89,800; 12 completed jobs
Margin after overhead: $12,129; 13.5% of revenue
Jobs in progress: 6; 2 more quoted, not started
Jobs losing money: 1; J-1042

Losing money

Jobs in progress

J-1042 Machine guarding panels ×8

Pacific Engineering

Quoted ex GST: $4,800.00; 15.0% margin on quote
Cost to date: $5,310.00; 36 h logged
Margin to date: -$510.00; -10.6%

Cost to date is labour $1,888.00, materials $2,477.00 and overhead $945.00.

Customers, completed jobs

Metro Rail Services

Ranked 2 of 6 customers by revenue

Revenue ex GST: $23,800.00; 3 jobs
Actual cost: $24,818.00
Margin: -$1,018.00; -4.3%

Compare all customers

Jobs in progress

Cost to date against the quoted price, ex GST.

Job no.	Description	Quoted	Cost to date	Spent
J-1042	J-1042Machine guarding panels ×8Losing money	$4,800	$5,310	110% of quote spent. Over quote.
J-1043	J-1043Awning frames, retail frontage	$12,400	$5,563	44% of quote spent
J-1044	J-1044Bin enclosure gates ×4	$3,800	$1,346	35% of quote spent
J-1045	J-1045Loading dock canopy	$35,900	$16,948	47% of quote spent
J-1047	J-1047Hopper liners & chutes	$13,600	$7,569	55% of quote spent
J-1049	J-1049Plant platform & access ladder	$21,000	$7,437	35% of quote spent

Latest hours logged

Operators enter their hours on the Time and materials page. Supplier bills come in from Xero.

Date	Operator	Job	Hours
05/11/2026	Tom Fraser	J-1049	3 h
05/11/2026	Sam Nguyen	J-1047	4 h
05/11/2026	Sam Nguyen	J-1044	4 h
05/11/2026	Priya Sharma	J-1047	7 h
05/11/2026	Marco Rossi	J-1049	4 h

Log time and materials 2 Xero bill lines need a job number

Customers by margin

Completed jobs only, ex GST, sorted by revenue.

Rank	Customer	Jobs	Revenue	Actual cost	Margin	Margin %
1	Harbourside Construction	3	$30,700.00	$23,982.75	$6,717.25	21.9%
2	Metro Rail ServicesLosing money	3	$23,800.00	$24,818.00	-$1,018.00	-4.3%
3	Parramatta Shopfitters	2	$13,100.00	$10,418.25	$2,681.75	20.5%
4	Botany Marine	2	$9,200.00	$7,713.25	$1,486.75	16.2%
5	Western Sydney Developments	1	$7,200.00	$5,680.25	$1,519.75	21.1%
6	Pacific Engineering	1	$5,800.00	$5,058.75	$741.25	12.8%

Losing money

Jobs in progress

J-1042 Machine guarding panels ×8

Pacific Engineering

Quoted ex GST: $4,800.00; 15.0% margin on quote
Cost to date: $5,310.00; 36 h logged
Margin to date: -$510.00; -10.6%

Cost to date is labour $1,888.00, materials $2,477.00 and overhead $945.00.

Customers, completed jobs

Metro Rail Services

Ranked 2 of 6 customers by revenue

Revenue ex GST: $23,800.00; 3 jobs
Actual cost: $24,818.00
Margin: -$1,018.00; -4.3%

Compare all customers

Description

Spent

J-1042Machine guarding panels ×8Losing money

110% of quote spent. Over quote.

J-1043Awning frames, retail frontage

44% of quote spent

J-1044Bin enclosure gates ×4

35% of quote spent

J-1045Loading dock canopy

47% of quote spent

J-1047Hopper liners & chutes

55% of quote spent

J-1049Plant platform & access ladder

35% of quote spent

Operator

Job

Hours

Tom Fraser

J-1049

3 h

Sam Nguyen

J-1047

4 h

Sam Nguyen

J-1044

4 h

Priya Sharma

J-1047

7 h

Marco Rossi

J-1049

4 h

Customer

Margin

Margin %

Harbourside Construction

$6,717.25

21.9%

Metro Rail ServicesLosing money

-$1,018.00

-4.3%

Parramatta Shopfitters

$2,681.75

20.5%

Botany Marine

$1,486.75

16.2%

Western Sydney Developments

$1,519.75

21.1%

Pacific Engineering

$741.25

12.8%