Bills of materials for small workshops
Write down what goes into each product once, and every order tells you what to buy, what it will cost and what is left over.
A recipe for a product
A bill of materials, or BOM, is the list of everything that goes into one product, with quantities. A bakery calls it a recipe. A furniture workshop usually keeps it in the head of its most experienced carpenter, which works until he is on leave.
Take an office desk, 140 × 70 cm. Its bill of materials might read:
- 1.5 boards of 18 mm MDF, 183 × 244 cm
- 6 m of 2 mm PVC edge banding
- 4 steel legs
- 24 screws, 4 × 40 mm
- 1 cable grommet
Buy in one unit, use in another
Boards are bought by the board and used in fractions. Edge banding is bought in 100 m rolls and used by the metre. Screws come in boxes of 200. Set each item’s base unit to the unit you use, and add the purchase unit with its factor: a roll of edge banding is 100 m, a box of screws is 200 pieces.
Stock is always kept in the base unit, so receiving 3 rolls adds 300 m, and a desk that uses 6 m takes exactly that. Quantities can be fractions, so a board can stay a board and a desk can use 1.5 of them.
Waste and offcuts
Cutting is never perfect. Each line of a bill of materials can carry a planned waste percentage, so the quantity used allows for it: 6 m of edge banding with 5% waste is 6.3 m.
Usable offcuts are different: they are stock. A bill of materials can list by-products, such as a 40 × 60 cm offcut from each desk, with a share of the cost. When the desk is produced, the offcut goes into stock and can be used for shelves instead of being thrown away.
Products made of products
A workstation for four people might use four desktops, one shared frame and a cable tray. If you make the frame yourself, give it its own bill of materials. The workstation’s bill then lists the frame as one component.
This is a multi-level bill of materials. It lets you build frames ahead of time when the workshop is quiet, and keep them in stock until an order needs them.
From order to real cost
With the bill in place, a production order for 20 desks knows it needs 30 boards, 126 m of edge banding with the 5% waste, 80 legs and 480 screws. You see what is short before you start, and when you make to order you can link the production order to the customer’s sales order.
Finishing the order takes the materials out of stock and puts the desks in. Production costing adds up the materials at the cost you actually paid, so if a desk cost EGP 3,850 in materials last spring and EGP 4,320 now, you see the difference before you quote the next customer.
Bills of materials, production orders, by-products and production costing come with the Make plan.
Examples are illustrative and use fictional businesses. Costing and tax treatment depend on your circumstances; your accountant can help apply them to your business.