Product Pricing Calculator
A three-tab Excel workbook for makers, bakers, and small-batch sellers who need to stop guessing what to charge. Tab one is a Read Me with the math written out plainly and a platform-fee cheat sheet (Etsy, Shopify, Square, Stripe). Tab two is the Pricing Calculator itself — per-SKU columns for materials, labor (hours × rate), packaging, shipping supplies, platform fee %, fixed fee, and target margin %, with a suggested retail price that solves the math after fees. Tab three is Batch Pricing — one product, multiple batch sizes, side-by-side per-unit cost so you can see whether scaling up is worth it before you do it.
- A Pricing Calculator tab with formulas wired in — true unit cost, suggested retail, profit per unit, effective margin
- Platform-fee handling done right: fees come out of revenue before margin is calculated, so the suggested price actually clears the target margin after Etsy or Stripe takes their cut
- A platform-fee cheat sheet for Etsy, Shopify, Square, PayPal, and Stripe — copy the right numbers into the calculator
- A real-world sanity check column that flags below-cost pricing, aggressive (70%+) margins, and thin (<30%) margins
- A Batch Pricing tab that shows per-unit cost at 5, 10, 25, 50, 100, and 250 units — the math behind "is it worth scaling up?"
- Six sample SKUs across candles, soap, baked goods, and jewelry you can replace with your own catalog in a few minutes
Or skip the spreadsheet entirely
A spreadsheet runs the math once. Ardent Seller runs it continuously — every time a material price changes, every recipe and product reprices itself, and your retail and wholesale tiers stay in sync with the cost. So the price you charge tomorrow reflects what the candle actually costs you today.
Recipe costing
Roll material, labor, and overhead into a true unit cost that updates automatically when an ingredient price moves — the calculator math, but always live.
Pricing tiers (retail & wholesale)
Maintain retail and wholesale prices per product, with one-click application of margin rules — synced with cost so a fee or material change reprices everything.
Production runs & batch tracking
Track real batch sizes, real labor, and real yield — so the per-unit cost in your reports comes from data, not estimates.
Related resources
Inventory Tracker Starter Kit
A working Excel inventory tracker for makers — raw materials, finished goods, packaging, and a purchase log. Reorder thresholds and a status column do the math; conditional formatting flashes red when you are below the line.
Wholesale Line Sheet
A working Excel line sheet for handmade wholesale — buyer-ready front sheet, per-SKU pricing math behind it, and the formulas already wired in.
Spreadsheet vs Inventory Software: The Decision Guide
When a spreadsheet is enough, when it stops working, and how to tell the difference before it costs you.
Craft Seller Startup Checklist
36 things to set up before — and after — your first sale. Inventory, pricing, and the legal essentials in one place.