Job-costing worksheet
An editable workbook that costs a job end-to-end — materials, decoration, setup, artwork, labour, packaging, shipping, wastage, overhead and fees — then shows cost per unit, break-even and target prices, profit, margin and markup with every formula visible.
Download
- Download spreadsheet
Spreadsheet (.xlsx) · 2 sheets · 10 KB
What it’s for
Keep a job's full costing in a file you can save, compare, and reopen — the same cost model as the online profit calculator, extended with wastage, artwork, packaging, shipping and payment fees.
Who it’s for: Owners and managers pricing jobs; anyone who wants costing history per job.
What’s included
- Fourteen editable inputs: quantity, material and decoration cost, setup, artwork/digitising, labour time and rate, packaging, shipping, wastage, overhead, payment/marketplace fees, target margin, and selling price
- Seven transparent outputs: total job cost, cost per unit, break-even price, target price for your margin, gross profit, gross margin, and markup
- Margin and markup shown separately, with their definitions on the sheet — they are different numbers and the workbook never swaps them
- A Read-me sheet defining every formula, the wastage and fee conventions, and the rounding rules
- Illustrative example values, clearly labelled as editable examples — not industry averages
Workbook structure
| Sheet | Contents |
|---|---|
| Read me | Definitions, formula documentation, conventions, and version |
| Job costing | Inputs (14 editable cells) · Outputs (7 protected formula cells) · Notes per line |
How to use it
- Replace the example inputs with the job's real numbers — every green input cell is yours to edit.
- Use one currency for every money cell; the workbook performs no exchange-rate conversion.
- Read break-even price as the floor and the target price as the ask; the gap is your negotiating room.
- Save a copy per job or per quote — the file becomes your costing history.
Limitations
- Outputs are estimates from your inputs — not accounting, tax, or pricing advice; VAT/sales-tax treatment is deliberately left to you and your accountant.
- The cost model matches the online print-job-profit calculator where they overlap, and extends it (wastage, artwork, packaging, shipping, fees) — results differ from the calculator exactly when those extra inputs are non-zero.
Version history
- v1.0 · 2026-07-17 — First public release.
Template
Daily production planner
Plan a production day on one sheet: jobs, processes, quantities, estimated minutes, operators, machines and status, with transparent capacity totals in the workbook version and a printable day sheet for the wall.
Calculator
Print job profit calculator
Work out the true cost, profit, and margin on any print or decoration job — materials, labour, setup time, and overhead included — and see the price you'd need to charge to hit a target margin.
Guide
How to price print jobs: costs, margin, and what shops get wrong
A practical pricing method for print and decoration businesses: build the true cost of a job (materials, labour, setup, overhead), choose margin deliberately, and avoid the mistakes — free owner labour, margin/markup confusion, and copying competitor prices.
Prefer the version that fills itself in?
damantra generates job sheets, approvals, and QC records from the order itself — with a portal where customers approve artwork online.