Pricing & Margin Calculator for Makers & Small Sellers | Excel + Google Sheets

Most makers price their products on a feeling. They double their material cost, call it a day, and never notice that labor and platform fees just ate half the profit. Then a "bestseller" turns out to barely break even — or quietly lose money.

Par Level's Pricing & Margin Calculator shows you the truth on every item. It was built by an operator who lives in real cost math, not a ChatGPT screenshot.

Drop in your products and it calculates — automatically:

• 💵 Your true unit cost — materials + packaging plus the labor you keep forgetting to pay yourself for
• ✂️ The fees each channel really takes — Etsy, Shopify, Faire, wholesale, in-person — platform cut + payment processing + flat fees
• 📈 Your real net margin on every product, after all of it (the number that actually matters)
• 🎯 The exact price to charge to hit your target margin — back-solved, not guessed
• 🟢🟠🔴 Color-coded status on every item — Healthy, Thin, Too Low, or Losing Money
• 💰 The money you're leaving on the table every month, totaled on the dashboard

What's inside (5 tabs):

• Start Here — a 5-minute setup guide
• Dashboard — average margin, underpriced items, monthly profit, and a "Raise These Prices" list
• Products — the engine; fill a few columns, everything calculates
• Channel Compare — drop in any price + cost, see your margin across every sales channel at once
• Fees & Settings — your labor rate, target margin, and an editable channel-fee table

Who it's for: Etsy & Shopify sellers, candle/soap/skincare makers, bakers, jewelry and craft sellers — anyone who makes a product and sells it across more than one channel.

The math (because it's real):
True Unit Cost = Materials + (Labor min ÷ 60 × your hourly rate) + Packaging + Other
Net Margin = (Price − Fees − Unit Cost) ÷ Price
Suggested Price = (Unit Cost + Flat Fee) ÷ (1 − Channel Fee % − Target Margin)

Instant download. Comes pre-loaded with sample data so you can see it working immediately, then swap in your own products. Works in Microsoft Excel (365), Google Sheets, and Apple Numbers.

⚠️ Note: the "Raise These Prices" list uses a dynamic formula best supported in Excel 365 or Google Sheets.

Pairs perfectly with the Par Level Inventory & Reorder System — that one tells you what to reorder; this one tells you what to charge.