← All prebuilt solutions
Industry

Manufacturing Product Costing (BOM)

Bill of materials, labour routing and overhead recovery for each product – the true cost, margin and the price you need

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

Manufacturing Product Costing (BOM)

Overview

Small manufacturers often price on materials plus a guess for labour. This workbook builds a proper standard cost for each product so you can see which products really make money, and what to charge.

Price
£20
Who it’s for
Industry
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Materials

Every material with unit and cost. What you do: one row per material.

Materials
BOM

Step 2

BOM

The materials and quantities in each product. What you do: one line per component.

Step 3

Products

Cost, margin and price for each product. What you do: nothing to enter.

Products

Step 4

Who it is for

Made for people like you

  • Example – text
  • Small manufacturers – Know what each product really costs to make.
  • Food and drink producers – Cost recipes and batches accurately.
  • Makers and craft businesses – Price wholesale and retail with confidence.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Production overheads and the direct labour hours they are spread over, selling and admin %, and your target margin.
  2. Materials – Everything you buy, with the price, the units in that price and typical waste.
  3. Operations – Each stage of production with the full hourly labour cost and any machine running cost.
  4. Products – Name, typical batch size and selling price.
  5. BOM and Routing – For each product, the materials in one unit and the minutes each operation takes.

Key features

  • Builds the cost of each product from a bill of materials (with waste) and a routing of operations (with set-up time spread over the batch).
  • Recovers production overheads on labour hours, adds selling and admin costs, and shows the margin, profit and the price you need to hit your target margin.
  • Includes a what-if for material price rises so you can see which products need a price increase first.

What’s included

  • Dashboard – Costs and margins
  • Settings – Overheads and targets
  • Materials – Materials and costs
  • Operations – Hourly rates
  • Products – Cost, price and margin
  • BOM – Bill of materials
  • Routing – Operations and times
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions