The most common pricing mistake small business owners make is calculating a price based on what sounds reasonable, then hoping the margin works out. It doesn’t work out. You end up busy but not profitable, or worse, losing money on your best-selling product without knowing it.
Cost-plus pricing flips that around: start with every cost, add your required margin, and you have a price you can defend. Here’s how to build the calculator.
The All-In Cost Structure
The single most important step is capturing costs you’re currently ignoring. Most business owners calculate material cost and maybe labor. The list is longer.
Set up your calculator with these cost categories:
Direct Costs (vary per unit):
- Raw materials or components: exact cost per unit
- Direct labor: hours to make/deliver × hourly wage (include payroll taxes — add ~12% on top of wage)
- Packaging: cost per unit
- Shipping/fulfillment: average outbound shipping cost
- Payment processing: typically 2.5-3% of selling price (use a placeholder and update after you set the price)
Indirect Costs (overhead allocated per unit):
- Monthly overhead ÷ number of units produced/sold per month
Monthly overhead includes rent, utilities, software, insurance, accounting, phone — everything that exists regardless of how much you sell.
Overhead Per Unit = Monthly Overhead / Monthly Units
If your monthly overhead is $3,500 and you sell 200 units, each unit carries $17.50 of overhead. Most people forget this number entirely.
Owner Labor: If you’re working in the business, your time has a cost. What would you have to pay someone to do your job? Use that as your implicit labor cost if you’re not already paying yourself a salary.
The Spreadsheet Layout
Set up two sections:
Input Section (yellow cells — fill these in):
| Line | Input |
|---|---|
| Material cost per unit | $_____ |
| Direct labor hours per unit | _____ |
| Your hourly labor rate (incl. taxes) | $_____ |
| Packaging cost per unit | $_____ |
| Average outbound shipping per unit | $_____ |
| Monthly overhead | $_____ |
| Monthly units sold | _____ |
| Target gross margin % | _____ % |
Calculated Section (formula cells — don’t touch):
| Line | Formula |
|---|---|
| Direct Labor Cost | =B3*B4 |
| Overhead Per Unit | =B7/B8 |
| Total Cost Before Payment Processing | =SUM(B2,B5,B6,B9,B10) |
| Target Selling Price (excl. processing) | =B11/(1-B12/100) |
| Payment Processing Fee | =B13*0.029 |
| Final Recommended Price | =B13+B14 |
| Actual Gross Margin % | =(B15-B11)/B15*100 |
The /(1-margin%) formula is important. If you want a 40% margin and your costs are $18, the price is NOT $18 × 1.40 = $25.20. That would give you a 28.6% margin (profit/price). The correct formula: $18 / (1 - 0.40) = $30.00. Now your $12 profit on a $30 sale is exactly 40%.
Pricing a New Product From Scratch
When you have no sales history to work from, you’re estimating some inputs. Here’s the sequence:
1. Research material costs precisely. Get actual supplier quotes, not estimates. Material cost is the one input you can nail down before launch.
2. Time yourself doing the work. For a service or handmade product, literally make one and time it. Multiply by 1.25 (add 25% for inefficiency, setup, and cleanup you’ll inevitably forget).
3. Use your current overhead allocation rate. Your overhead per unit is based on current volume. As you add new products, you’ll sell more units, which actually lowers overhead per unit across the board. This is a conservative estimate.
4. Run two scenarios. Set up your calculator with a base case (conservative volume, mid-range material cost) and an optimistic case. The range shows you where your price needs to be to make money even if things don’t go perfectly.
5. Check against the market. Cost-plus gives you your floor price — the minimum you need to charge to hit your margin target. The market tells you the ceiling — the maximum customers will pay. If your floor is above the ceiling, the product isn’t viable at current cost levels. Go fix the cost structure before you launch.
Common Costs People Miss
- Returns and refunds: If you have a 5% return rate and refund in full, add 5% × product cost to your unit economics.
- Credit card chargebacks: Small but real. Budget 0.5% of revenue.
- Storage costs: If you’re paying for warehouse space, that’s overhead.
- Sample and waste: Physical products have waste. Baked goods have a higher waste factor. Factor it in.
- Customer acquisition cost: This isn’t product cost, but knowing your CAC helps you understand whether your margin is actually enough to profitably acquire customers.
Adjusting for Volume
Build a simple volume sensitivity table. What happens to your cost structure if you sell 2× as many units?
| Monthly Units | Overhead/Unit | Total Cost/Unit | Price at 40% Margin |
|---|---|---|---|
| 100 | $35.00 | $58.00 | $96.67 |
| 200 | $17.50 | $40.50 | $67.50 |
| 500 | $7.00 | $30.00 | $50.00 |
Volume kills overhead per unit. This is why pricing can actually come down as you scale — not because you’re selling more, but because fixed costs get spread across more units.
Next Step
Open a spreadsheet and enter your actual costs for your best-selling product right now. Use real numbers, not estimates. Calculate the full cost-plus price and compare it to what you’re currently charging. If your current price is below the calculated minimum, you’re subsidizing your customers. That needs to change — start with a plan for how you’ll get from where you are to where you need to be.
5 Google Sheets Every Small Business Needs
Cash flow, P&L, mileage log, invoice tracker, and payroll — all free.
No spam. Unsubscribe any time.