FOR SERVICE BUSINESS OWNERS
Service business pricing spreadsheet: what it should actually calculate
A useful pricing spreadsheet should solve the economics of the job before you quote the customer: paid labour, direct costs, travel, overhead, payment fees, minimum charge and target margin.
The core pricing equation
Start with the cost of delivering the job. Add paid labour, direct materials or consumables, travel and a realistic share of monthly overhead. Then account for sale-linked fees and solve for the selling price required to achieve the target retained margin.
Do not confuse markup with margin
Adding 30% to cost does not produce a 30% margin. A reusable spreadsheet should solve backwards from the desired margin so the business can see the profit retained after the costs it has modelled.
What the spreadsheet should include
- job-costing inputs
- minimum-charge logic
- customer quote support
- monthly revenue and profit planning
- break-even analysis
- capacity checks
Choose a niche-specific toolkit
Service Pricing Tools has downloadable pricing systems for multiple service businesses. Each one adapts the job inputs and examples to the work rather than using one generic price list.
Browse all Pro Toolkits · €24.99 each ↗