A pricing spreadsheet is useful when it mirrors the way the shop actually works. A sheet with one “total cost” row becomes dangerous because it hides the assumptions behind that number. Build the workbook around a small set of linked inputs and review the results against completed orders.
Required columns and inputs
- Quantity, material cost per unit and remake percentage.
- Machine minutes per unit and machine cost per hour.
- Setup and design minutes per order.
- Hands-on labor minutes and hourly labor rate.
- Packaging cost per unit.
- Percentage sales fee and fixed transaction fee.
- Target profit margin, not a markup multiplier.
- Calculated break-even price, target price and expected profit.
Keep units explicit. Enter minutes as minutes rather than mixing hours and minutes in one column. Enter percentages as decimals or clearly formatted percentages, and make the formula visible.
Separate one-time costs from per-item costs
Design and setup apply to the whole job, while material and machine time usually vary with quantity. A spreadsheet that multiplies every cost by quantity can overstate a setup fee. Include the fixed transaction fee once per order unless the sales channel charges it per item.
Keep a machine-rate sheet
A job pricing sheet should reference a separate machine-cost calculation. Record purchase price, expected resale value, expected life hours, annual maintenance, annual machine hours, power draw and electricity cost. The resulting hourly rate becomes an input instead of a guessed number.
Record actual results
Add columns for quoted minutes, actual minutes, quoted material and actual material. After the order closes, record the actual marketplace payout. Over time, these differences tell you whether your pricing assumptions are drifting.
Review rather than trust
- Compare the total estimated cost with the actual job cost.
- Check whether the target margin was described as a margin or mistakenly applied as a markup.
- Look for sales fees that were omitted or applied only to part of the order.
- Check whether non-billable revisions and support time were recorded.
The free browser calculator covers the core job-pricing logic. A shop that needs reusable records, bulk planning or monthly tracking can later add those details to its own spreadsheet.