Price every product from what it really costs you: materials, making time, packaging, marketplace fees and the profit you want. Then see what a 10% or 20% discount would do before you run a sale.

What you get:

• Hourly rate sheet: the yearly income you want, your business costs and your real making hours give the rate to charge.

• Materials sheet for 100 materials with pack price and pack size, so the cost per unit is worked out for you.

• Recipes sheet with 400 lines: list what goes into each product and get its exact material cost.

• Prices sheet for 60 products: suggested price, profit per sale, profit at 10% and 20% off, and how many extra sales a discount needs.

• Input checks that flag missing or impossible entries.

• Quick start guide (PDF) with a worked example.

Format: XLSX workbook, 5 sheets (Start, Prices, Rate, Materials, Recipes), formulas only, no macros.

Works with: Excel 2016 or later, LibreOffice Calc and Google Sheets (upload the file to Google Drive).

Preview images show real sheets with fictional example data.

Licence: use and adapt for one business. Please do not resell or share the blank template.

More free calculators and guides for craft sellers: khairzada-craft-tools.pages.dev