This business pricing worksheet helps you set and review selling prices by combining product or service costs, labor, overhead, marketplace fees, discounts, taxes, and target profit in one repeatable process. Use it for individual products, service packages, or a larger catalog whenever costs, fees, or promotional plans change.
Overview
A price can look profitable until a discount, payment fee, labor cost, or delivery expense is included. The purpose of a pricing worksheet is to make those inputs visible before you publish a price or approve a promotion.
The worksheet should answer four questions:
- What does one sale actually cost?
- How much cash remains after variable costs and fees?
- Does the price produce the desired margin or profit per sale?
- How does a discount change the result?
Keep sales tax or VAT separate from revenue when the business collects it on behalf of a tax authority. In many pricing decisions, the useful starting point is the pre-tax selling price. Tax treatment varies by location, product, customer, and registration status, so confirm the appropriate treatment for your business before relying on the worksheet for tax reporting.
For related formulas, see the Business Calculator Toolkit. If software subscriptions are part of your overhead, the software subscription audit checklist can help identify costs that belong in your assumptions.
How to estimate
Start with a price that excludes separately displayed sales tax or VAT. Then work through the following formulas.
1. Calculate fully allocated cost per sale
Fully allocated cost = direct materials or product cost + direct labor + variable fulfillment cost + allocated overhead
Direct costs are tied to the individual sale, such as inventory, packaging, contractor time, or payment processing. Allocated overhead may include software, rent, insurance, equipment, administration, or other operating costs. Divide a reasonable period total by expected units or billable projects to create an overhead amount per sale.
2. Add marketplace and payment fees
Record percentage-based fees and fixed per-transaction fees separately. If a platform charges a percentage of the customer-paid amount, confirm whether that percentage applies to the discounted price, shipping, tax, or the whole order. Use the platform's current fee terms rather than a remembered rate.
Total variable cost = fully allocated cost + percentage fee + fixed transaction fee
3. Calculate net profit per sale
Net profit per sale = net revenue received by the business - total costs
For a simple pre-tax worksheet, net revenue may be the selling price after discounts and applicable selling fees. If a fee is calculated as a percentage of the selling price, the calculation can be written as:
Net profit = discounted price - (costs + percentage fee + fixed fee)
4. Calculate margin and markup
Profit margin = net profit ÷ selling price × 100
Markup = net profit ÷ cost × 100
Margin uses the selling price as its denominator; markup uses cost. They are not interchangeable. To set a price from a target margin, use:
Price before percentage fees = (fixed costs per sale + target profit) ÷ (1 - percentage fee rate - target margin)
This formula is most useful when the target margin is based on the final selling price and the percentage fee applies to that price. Test the result against actual fee rules and round it according to your pricing policy.
Inputs and assumptions
Create one worksheet row for each product, service package, or pricing tier. Use these columns:
| Input | What to record |
|---|---|
| List price | Published price before discounts and separately shown tax |
| Discount rate or amount | Promotion, coupon, bundle reduction, or negotiated discount |
| Product or material cost | Inventory, ingredients, supplies, or other direct inputs |
| Labor time and rate | Expected time multiplied by the relevant internal labor rate |
| Fulfillment cost | Packaging, delivery, shipping subsidy, or transaction-specific handling |
| Allocated overhead | Reasonable share of recurring operating expenses |
| Percentage fee | Payment processor, marketplace, affiliate, or sales commission rate |
| Fixed fee | Per-order, per-invoice, or per-transaction charge |
| Tax rate | Reference value for customer-facing tax calculations, kept separate from profit |
Document assumptions beside the numbers. For example, state whether labor includes preparation and customer support, whether shipping is paid by the buyer, and whether overhead is allocated by unit, order, hour, or project. Consistent assumptions matter more than false precision.
For service businesses, replace product cost with delivery time and direct project expenses. An hourly-to-project rate calculator can help estimate a package price, but include non-billable administration, revisions, and coordination where they are part of delivery. For catalog businesses, use conservative volume assumptions when allocating overhead; a price that works only at an optimistic sales volume may not be sustainable.
Markup versus margin reference
| Markup on cost | Equivalent margin |
|---|---|
| 25% | 20.0% |
| 50% | 33.3% |
| 100% | 50.0% |
| 150% | 60.0% |
These conversions assume the listed markup is applied to cost and that no fees, discounts, or taxes reduce the result. Your worksheet should calculate the final margin after all relevant costs.
Worked examples
Example 1: Product sale with a marketplace fee
Assume a product has a list price of $80. The business offers a 10% discount, leaving a discounted price of $72. Product cost is $28, labor and packaging total $8, allocated overhead is $6, the marketplace fee is 8% of the discounted price, and the fixed transaction fee is $0.50.
- Percentage fee: $72 × 8% = $5.76
- Total cost: $28 + $8 + $6 + $5.76 + $0.50 = $48.26
- Net profit: $72 - $48.26 = $23.74
- Profit margin: $23.74 ÷ $72 = 32.97%, approximately 33.0%
Without the discount, the percentage fee would be higher in dollars, but the business would also retain more revenue. Compare both scenarios rather than judging the promotion by its discount percentage alone.
Example 2: Discount impact on profit
Suppose a service package sells for $500 and has $260 in total costs before any percentage fee. At full price, net profit is $240 and margin is 48%. A 15% discount reduces the customer price to $425. If there is no additional percentage fee, profit becomes $165 and margin falls to approximately 38.8%.
The price decreased by 15%, but profit decreased by 31.25%. This is why a discount calculator for pricing should show both the new margin and the change in profit per sale. Also calculate the extra number of sales required for a promotion to generate the same total profit:
Required sales at discounted profit = original total profit target ÷ discounted profit per sale
Use this result as a planning tool, not a guarantee. Customer demand, capacity, refunds, and fulfillment limits may change the outcome.
When to recalculate
Revisit the worksheet whenever a pricing input changes or a benchmark becomes less relevant. Common triggers include:
- A supplier, contractor, payroll, shipping, or packaging cost changes.
- A marketplace, payment processor, or sales channel changes its fee structure.
- You introduce a coupon, bundle, seasonal offer, or sales commission.
- Actual labor time differs from the estimate used in the worksheet.
- Sales volume changes enough to alter allocated overhead.
- Tax registration, product tax treatment, or operating locations change.
- You add a product, service tier, delivery option, or new sales channel.
Use a three-step review process. First, compare worksheet assumptions with recent invoices, supplier bills, payroll records, and platform statements. Second, run at least three scenarios: standard price, planned discount, and higher-cost or lower-volume conditions. Third, record the date, assumptions, and decision for each revision so later comparisons are meaningful.
Before publishing a price, check that the worksheet separates tax from revenue, includes every material fee, uses the correct margin formula, and reflects the time required to deliver the sale. Then test the price against customer expectations and comparable offers without treating competitors' prices as proof of your own costs. Recalculate after the next meaningful cost or fee change, and keep the worksheet as a living business tool rather than a one-time calculation.