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. ✨ 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 c