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):

LineInput
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):

LineFormula
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 UnitsOverhead/UnitTotal Cost/UnitPrice 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.