Craft Material Cost Calculator Spreadsheet

About this template

This craft cost calculator works out what a piece costs in materials before you decide its price. It is for makers running a handmade business who want product costing they can trust rather than a rough guess.

Please read: This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).

Cost built from the recipe

Each product has a recipe: every material that goes into it, in the quantity used, at the unit price you set. The material cost adds itself up from those lines, and if one price changes, every piece that uses it re-costs itself. Every figure on the dashboard is calculated from the tabs behind it, and nothing is typed into a summary, so the front page always agrees with the rows it came from.

Ten connected tabs

Every tab reads the same source list, so nothing is entered twice:

• What you sell: Products, 120 rows, and Materials, 120 rows, with a recipe per product, cost built from the recipe, and one product list feeding everything, plus 300 recipe lines
• What it is worth: suggested price, margin before the fee and after it, stock valued at cost and at retail, and a reorder flag
• What sold: Orders, 400 lines, with profit per line, sales by channel and by month, and a live dashboard

The suggested price and the margin before and after the selling fee make it a pricing calculator as well, so you can see the profit margin on each piece before it goes on sale.

You get real spreadsheet files, not a PDF with a link in it: Excel and Google Sheets, each filled in and each blank and ready for yours. The filled copy is the file in the photos, so you can see how it behaves before you type anything.

Works with

• Microsoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.
• Google Sheets with a free Google account. No Google account is needed for the Excel files.
• No add-ins, no macros and no subscription

What you download

• The Excel workbook filled with a worked example, and the same workbook blank and ready for yours
• The instruction guide, which has one-click links to the Google Sheets versions (filled and blank)
• The terms of use as a PDF

Your files are ready to download as soon as payment clears. The Start Here tab walks you through setup in a few minutes. The files are for personal use on your own devices; please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.

Frequently asked questions

Does it work in Excel and Google Sheets?

Yes. You get Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own Google Sheets copies with a free Google account.

How is the material cost of a piece worked out?

From its recipe: each material, the quantity used and the unit cost you set. The line costs add up to the product cost.

What if a material price changes?

Change it once on the Materials tab and every product that uses it re-costs itself.

Does it suggest a selling price?

Yes. It shows a suggested price and your margin before and after the selling fee.

How much does it hold?

120 products, 120 materials, 300 recipe lines and 400 order lines.