Product Pricing Calculator Spreadsheet, Profit Margin and Wholesale Planning

Work out a cost-based selling price before listing a product. This pricing spreadsheet combines entered costs, profit and margin goals, fees and wholesale checks, with a one-product calculator, a 250-product catalog and a Quick Start PDF.

YOUR DOWNLOAD

• One XLSX pricing workbook and one Quick Start PDF

• PRICE IT calculator, 250-product pricing catalog, dashboard, material helper and editable settings

• Illustrative worked examples for handmade, resale, labour-heavy and fee-heavy products

Enter your real costs and see the price you need to break even, the price that hits your profit and margin goals, and a wholesale price that still makes money. Built for handmade, resale and any product business. Instant XLSX download, with Google Sheets import instructions. Check your converted copy before use.

WHAT IT WORKS OUT

• Total cost per item — materials, your labor, packaging, ads and the shipping you pay

• Break-even price — below it, every sale loses money

• The price for your profit goal and the price for your margin goal

• A recommended retail price that meets both goals, rounded up to .99, a whole dollar or the exact cent

• Net profit, margin and markup at that price, after fees

• Wholesale: the floor, a minimum that protects your margin, the price at your shop discount, a Works / Below minimum margin / Loses money check, a target wholesale price and the retail price that would make wholesale work

• A check of the price you charge now

• How many sales a month you need for your income goal

WHAT'S INSIDE

• PRICE IT — price one product in depth on one screen, with a what-if table of ten prices and a chart

• PRODUCT PRICING — price up to 250 products with SKU and category; each gets a status (Meets goals · Under goal · Below break-even) and a wholesale check

• DASHBOARD — how many products meet your goals, catalog averages and your five biggest price gaps

• MATERIAL HELPER — turn pack prices (wax by the pound, beads by the strand) into a cost per item

• SETTINGS — editable fee presets for Etsy, eBay, Shopify, Square, PayPal, Whatnot, cash and wholesale, plus two custom channels (editable modeled US fee assumptions; verify your plan, category, tier, tax treatment and special charges)

• One-page Quick Start PDF

Five worked examples show a low-cost handmade item, a higher-cost handmade piece, a resale find, a labor-heavy product and a fee-heavy marketplace sale. Type over the yellow input cells or clear only the input ranges identified in START HERE and the Quick Start. Preserve all formula columns.

WHAT YOU GET

1 Excel workbook (.xlsx) + 1 Quick Start PDF. Designed for Microsoft Excel and Google Sheets (File → Import); save a working copy and follow the Quick Start. Not tested in Apple Numbers.

FAQ

Q: Do I need Excel?

A: You can import the .xlsx file into Google Sheets using File → Import. Follow the Quick Start and check your inputs and fee assumptions before relying on a calculated price.

Q: Does it work for resale and vintage?

A: Yes. Enter what you paid as the product cost and your sourcing and listing time as labor.

Q: Will it tell me what my market will pay?

A: No. It shows your floor and the prices that meet your goals; compare those with what similar items actually sell for.

Q: Can I change the fees?

A: Yes. Every fee is an editable cell on SETTINGS, and every price updates.

Q: How is this different from the Reseller Fee & Profit Calculator in this shop?

A: That one compares fees across channels for one resale item. This one builds prices from your costs and goals for a whole catalog, including wholesale.

Also from MercantileDesk: the Small Business Inventory & Sales System, and Be Your Own Boss — The Product Seller Business System (the 111-page playbook plus both spreadsheets).

Made by MercantileDesk, the seller-tools line from LintHead Restorations.

A digital download for use in your own business; nothing ships. A business planning tool, not tax, accounting, legal or financial advice. Marketplace and payment fees change — confirm current rates with each platform. A calculated price doesn't guarantee buyers will pay it.