General 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.
The problem. 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.
What this does. 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.
What you can do with it
- See cost per unit for every product: materials, labour and overhead share.
- See the margin in dollars and as a percent against the price you typed.
- See the products at or below your own margin target, and the five most and five least profitable.
- See a margin chart and a cost make-up chart for your first ten products.
- Spot mistakes: a recipe line whose product or material is not found, or has no quantity, is flagged and counted.
- Choose 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.
- Keep 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.
How cost is worked out
- Materials are each recipe line's quantity times the material's unit cost.
- Labour is the product's minutes divided by 60, times your labour rate.
- Overheads 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.
- A 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.
How it works
- Enter your business name, then type your labour rate, the units per month and your margin target.
- Add your materials, overheads and products, then a recipe line for each material a product uses.
- Check the dashboard.
Who it is for. Makers, sole traders and small businesses who want to see what each product costs them and what they keep.
Who it is not for. 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.
What you need. Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.
Good to know
- 300 materials, 300 products, 1,500 recipe lines and 60 overhead rows are ready, and you can add more by dragging the last row down.
- Every 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.
- Type your prices the same way for every product, all with tax or all without. The workbook does not add or take off any tax.
- The dashboard shows the first 25 products in its cost table and the first 10 in its charts. The Products sheet holds all of them.
- An example copy with a made-up business shows every sheet working before you start.
- Nothing is locked or password protected.
- Use this template to capture and improve your business data now. In future you can automate with AI.