{"product_id":"craft-material-cost-calculator","title":"Craft Material Cost Calculator Spreadsheet","description":"\u003cp\u003eThis 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e 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).\u003c\/p\u003e\u003ch2\u003eCost built from the recipe\u003c\/h2\u003e\u003cp\u003eEach 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.\u003c\/p\u003e\u003ch2\u003eTen connected tabs\u003c\/h2\u003e\u003cp\u003eEvery tab reads the same source list, so nothing is entered twice:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhat you sell:\u003c\/strong\u003e 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\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhat it is worth:\u003c\/strong\u003e suggested price, margin before the fee and after it, stock valued at cost and at retail, and a reorder flag\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhat sold:\u003c\/strong\u003e Orders, 400 lines, with profit per line, sales by channel and by month, and a live dashboard\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eThe 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.\u003c\/p\u003e\u003cp\u003eYou 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.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour 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.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. 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.\u003c\/p\u003e\u003ch3\u003eHow is the material cost of a piece worked out?\u003c\/h3\u003e\u003cp\u003eFrom its recipe: each material, the quantity used and the unit cost you set. The line costs add up to the product cost.\u003c\/p\u003e\u003ch3\u003eWhat if a material price changes?\u003c\/h3\u003e\u003cp\u003eChange it once on the Materials tab and every product that uses it re-costs itself.\u003c\/p\u003e\u003ch3\u003eDoes it suggest a selling price?\u003c\/h3\u003e\u003cp\u003eYes. It shows a suggested price and your margin before and after the selling fee.\u003c\/p\u003e\u003ch3\u003eHow much does it hold?\u003c\/h3\u003e\u003cp\u003e120 products, 120 materials, 300 recipe lines and 400 order lines.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597863747678,"sku":"OPX-062","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/craft-material-cost-calculator-01.jpg?v=1790832280","url":"https:\/\/opxviashop.com\/products\/craft-material-cost-calculator","provider":"OPXVIA","version":"1.0","type":"link"}