Small Business · Makers - Template 82
Product Pricing Calculator
Know exactly what to charge for everything you make.
Microsoft Excel◆Google Sheets◆.xlsx files
Add your materials, labour and running costs once, pick how you want to set your price, and this pricing calculator works out your selling price, discount, tax, real profit and margin for you. There are five ways to set a price, from a markup rate to a final price after discount and taxes, and every figure updates when you switch. Then log your sales, watch your profit on the dashboard by month and by sales channel, and see when to reorder materials. Made for handmade sellers, small shops and makers pricing physical products. You get a blank workbook and a sample workbook filled with a pottery studio example.
What's inside · 8 tabs
- Setup - your currency, two tax rates, a default hourly rate and your sales channels
- Dashboard - revenue, real profit, margin, units and orders by month, year and channel
- Materials - package price, unit price, stock level and colour coded stock status
- Reorder List - fills itself with everything out of stock or running low, and the cost to restock
- Pricing Calculator - batch costs, a price breakdown, a cost breakdown and a top 10 item costs chart
- Five pricing methods - markup rate, markup amount, selling price, net price or final price
- Price List - every price you set, with costs, profit and quantity sold
- Sales Log - pick the product and its price, SKU and profit fill in
- Competitor Prices - your latest price against other sellers, shipping included
- Two tax rates - for example VAT plus a marketplace or sales tax
In Motion
Five ways to set your price.
Change a material cost or switch the pricing method and the selling price, the profit and the margin all update at once.
Pairs Beautifully With
