Product Pricing Calculator Spreadsheet, Handmade Etsy Seller, Wholesale Retail Profit, Craft Pricing Calculator, Excel Google Sheets

Product Pricing Calculator Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Stop guessing your prices. This Handmade Product Pricing Calculator adds up your materials, labor, overhead, packaging and selling fees, then tells you the price you need to hit your target profit margin, plus wholesale and retail prices and your real profit at today's price. Perfect for Etsy sellers and handmade makers.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/PwDTjSH5iEA

✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition.

★ WHAT'S INCLUDED ★
• Clickable Start Here cover page with quick-start steps and a colour key (yellow = you type)
• Pricing Dashboard: active products, average margin, on target, below target, losing money, monthly revenue and profit, average cost and price, overhead, break-even revenue, profit left on the table, material price alerts and best channel, plus top earners, a raise-these-prices-first list, price health, a money map, 7 automatic insights and 4 charts
• Products: room for 100 products with SKU, category, status, batch size, your minutes and a helper's minutes, shipping you cover, your price, main channel, expected sales and wholesale minimum. Materials, packaging, labor, overhead and total cost per unit, wholesale price, retail price, suggested price, fees, profit, margin, markup, price rise needed, monthly profit and status are automatic
• Bill of Materials: 600 recipe lines (per batch) with product and material drop-downs, line costs, cost per unit and a check column
• Materials: 200 supplies with pack price, shipping, pack size and automatic cost per unit, plus price change vs. last time, last price check, products using it, monthly use, monthly spend and alerts (price up, check price, not used)
• Overhead: 30 fixed costs in any frequency, monthly and yearly totals, a by-category chart, spread per unit or per production hour
• Product Card: pick a product to see its cost build-up with a chart, its full recipe, wholesale, retail and suggested prices, effective hourly rate and profit on every channel
• Price Tester: test a new price, material cost change, labor time change, fee change and sales change. See before vs. after, charm prices (.99, .95, whole dollars, .50) and a 13-step price ladder with a chart
• Fee Comparison: one product on 10 selling channels side by side with fees, profit, margin, monthly profit, price for your target margin and rank, 2 charts, plus averages for all your products on each channel
• Channel Profit: every product on every channel, profit per unit and margin with colour scales, best and worst channel
• Margin Check: average cost, price and margin by category vs. target with a chart, plus your 25 lowest-margin products and the price rise each needs
• Break-Even: monthly fixed costs, expected revenue and contribution, break-even revenue, revenue for your profit goal, a revenue vs. total costs chart and break-even units for every product
• Price List: printable retail and wholesale price list with your business details, active products only
• Setup: your wage and a helper's wage, overhead method, default target margin, wholesale and retail multipliers, price rounding, default channel, category target margins, editable fee rates for 10 selling channels (example rates included) and the drop-down lists
• Sample data version so you can see how it works, plus a blank ready-to-use version

★ PERFECT FOR ★
✓ Etsy sellers and handmade makers
✓ Candle, soap, jewelry, sticker, print and craft businesses
✓ Craft fair and market vendors

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Purchase and download the .xlsx file instantly
2. Enter your wage, overhead, margin and fees on Setup
3. Add your materials and what goes into each product
4. See your true cost, suggested price and profit instantly

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ YOU MAY ALSO LIKE ★
Pairs well with the Small Business Spreadsheet Bundle (5 templates, save 50%): https://www.etsy.com/fi-en/listing/4600189442/small-business-spreadsheet-bundle

★ PLEASE NOTE ★
This is a digital download. No physical item will be shipped. Fee defaults are examples, so please check your marketplace's current fees. Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.