{"product_id":"product-costing-and-pricing-calculator","title":"Product Costing and Pricing Calculator","description":"\u003cp\u003eGeneral information only. It is not accounting, tax, legal or financial advice. This workbook only works out your costs and margins from the numbers you type. It does not suggest a price, and every rate and target in it is yours.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Costs sit in receipts, supplier lists and your head. It is hard to say what one unit of a product really costs once materials, your time and the running costs are counted, and what you keep from the price.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of materials, one of products, one of recipe lines (the materials in one unit of each product) and one of overheads. The workbook adds materials, labour and a share of overheads into a cost per unit, shows the margin in dollars and as a percent, and flags products at or below the target you typed.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee cost per unit for every product: materials, labour and overhead share.\u003c\/li\u003e\n\u003cli\u003eSee the margin in dollars and as a percent against the price you typed.\u003c\/li\u003e\n\u003cli\u003eSee the products at or below your own margin target, and the five most and five least profitable.\u003c\/li\u003e\n\u003cli\u003eSee a margin chart and a cost make-up chart for your first ten products.\u003c\/li\u003e\n\u003cli\u003eSpot mistakes: a recipe line whose product or material is not found, or has no quantity, is flagged and counted.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (handmade and food makers, trades and services, or retail resellers) to load suitable unit and category lists, then edit them to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and four export sheets repeat your materials, products, recipe lines and overheads under plain field names.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow cost is worked out\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eMaterials are each recipe line's quantity times the material's unit cost.\u003c\/li\u003e\n\u003cli\u003eLabour is the product's minutes divided by 60, times your labour rate.\u003c\/li\u003e\n\u003cli\u003eOverheads are shared equally: your total monthly overheads divided by the units per month you type, the same amount on every unit of every product. You set that units figure, so you set the share.\u003c\/li\u003e\n\u003cli\u003eA product is flagged when its margin percent is the same as, or lower than, your margin target. Leave the target empty and nothing is flagged.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name, then type your labour rate, the units per month and your margin target.\u003c\/li\u003e\n\u003cli\u003eAdd your materials, overheads and products, then a recipe line for each material a product uses.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Makers, sole traders and small businesses who want to see what each product costs them and what they keep.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Anyone who wants a price suggested for them. This is a calculation tool: it works out costs and margins from the numbers you type. It does not suggest a price, and it does not send anything or connect to other software.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e300 materials, 300 products, 1,500 recipe lines and 60 overhead rows are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eEvery rate, target and price is typed by you. Nothing is a built-in rule, and the overhead rule above is controlled by the units per month you type.\u003c\/li\u003e\n\u003cli\u003eType your prices the same way for every product, all with tax or all without. The workbook does not add or take off any tax.\u003c\/li\u003e\n\u003cli\u003eThe dashboard shows the first 25 products in its cost table and the first 10 in its charts. The Products sheet holds all of them.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up business shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your business data now. In future you can automate with AI.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262746829,"sku":null,"price":29.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_49af5d2f-0693-4bf6-9ee4-70f334b19f33.png?v=1795096154","url":"https:\/\/www.teleworld.online\/id\/products\/product-costing-and-pricing-calculator","provider":"TeleWorld Online","version":"1.0","type":"link"}