WHAT YOU ACTUALLY PAID Supplier invoice price, per unit Straight off the invoice, before anything else is added. Waste / breakage allowance The roll cut short, the pail that cracked in the truck, the bundle nobody can find. 3% is a normal starting point on materials. Freight or delivery, per unit Set to 0 if you pick it up yourself. Your truck time is real, but it belongs in overhead, not in this cell. Sales tax you paid on the purchase Kentucky is 6%. Zero this only if you genuinely bought on a resale certificate and will remit later. Flat per-unit handling adder The contractor price card this sheet was modelled on carries a flat $2.00 per unit on top of supplier cost before markup — the column is literally headed 'Your Cost + 2'. Keep it, raise it, or zero it.

WHAT YOU CHARGE Markup on landed cost 40% is the figure written into the repair service agreement this was modelled on: materials priced at cost + 40% markup. Your gross margin floor The line below which a job is not worth signing. In the source agreement, dropping under 30% margin cuts the salesperson from 30% of net to 7% of net. Units of this item on the job

THE JOB AROUND IT Man-hours on site Minimum service fee Covers travel plus the first 2 hours of labour. Below this number a truck roll loses money no matter how small the repair is. Additional labour, per man-hour Charged for every hour past the two covered by the minimum service fee. What you pay the crew for this job Actual subcontractor or crew pay. Not what you charged — what leaves your account. House fee, taken off the top 10% of gross revenue, removed before any cost split. Ten percent off the top is not ten percent of the profit — on a thin job it can be a third of it. Booking draw already paid out Flat advance released when the signed contract and the deposit are both verified, then deducted at final settlement. The source paperwork uses $100 in the commission agreement and $500 on its settlement template — use whichever your own agreement says.

YOUR REAL LANDED COST

Material after waste allowance—

Sales tax paid on the purchase—

LANDED COST PER UNIT—

How far above the invoice price that is—

THE PRICE

RETAIL PRICE PER UNIT—

Gross profit per unit—

Gross margin that markup actually returns—

THE FLOOR CHECK

Markup you need to reach your floor—

Price per unit at your floor—

Per unit you are leaving on the table—

WHAT IT DOES TO THE WHOLE JOB

Material revenue—

Labour revenue—

Total job revenue—

House fee off the top—

Landed materials plus crew pay—

NET PROFIT ON THE JOB—

Job gross margin—

Commission tier this job earns—

Commission due, after the booking draw—

Price Book

One row per SKU you buy often. Type the landed cost and the markup — the rest computes.

	Retail price	Gross margin	Price at your floor	Under the floor by
1	—	—	—	—
2	—	—	—	—
3	—	—	—	—
4	—	—	—	—
5	—	—	—	—
6	—	—	—	—
7	—	—	—	—
8	—	—	—	—
9	—	—	—	—
10	—	—	—	—
11	—	—	—	—

Markup & Landed Cost Calculator

YOUR REAL LANDED COST

THE PRICE

THE FLOOR CHECK

WHAT IT DOES TO THE WHOLE JOB

Price Book

Want it as a spreadsheet you own?

Markup & Landed Cost Calculator: the full workbook

Email me these results

	Retail price	Gross margin	Price at your floor	Under the floor by
1	—	—	—	—
2	—	—	—	—
3	—	—	—	—
4	—	—	—	—
5	—	—	—	—
6	—	—	—	—
7	—	—	—	—
8	—	—	—	—
9	—	—	—	—
10	—	—	—	—
11	—	—	—	—

	Retail price	Gross margin	Price at your floor	Under the floor by
1	—	—	—	—
2	—	—	—	—
3	—	—	—	—
4	—	—	—	—
5	—	—	—	—
6	—	—	—	—
7	—	—	—	—
8	—	—	—	—
9	—	—	—	—
10	—	—	—	—
11	—	—	—	—

	Retail price	Gross margin	Price at your floor	Under the floor by
1	—	—	—	—
2	—	—	—	—
3	—	—	—	—
4	—	—	—	—
5	—	—	—	—
6	—	—	—	—
7	—	—	—	—
8	—	—	—	—
9	—	—	—	—
10	—	—	—	—
11	—	—	—	—