AnsweredAssumed Answered

BOM for sub-assemblies

Question asked by Sorbsbuster on Jan 1, 2015
Latest reply on May 1, 2017 by coherentkris


BOM for sub-assemblies


I would appreciate advice on Best Practice for generating a Bill Of Materials for Products that include sub-assemblies.

I have a Products Table, with records for products such as:
- Cake
- Buns
- Trifle

I have a Product Items Table with the ingredients of each product.  For example, the Product 'Cake' could have:
- Butter
- Sugar
- Eggs

The solution accepts a Sales Forecast for the range of Products and generates the appropriate MRP (Materials Requirement Plan) down to Ingredient level.  That all works perfectly.

The next stage that I am asking for advice on is that an 'Ingredient' could be 'Caramelised Chestnuts'.  That Ingredient is a sub-assembly - it requires the Purchasing Department to buy the ingredients 'Chestnuts' and 'Sugar'.

This is a really common requirement (the automotive industry must be full of such requirements, for example), so I am reluctant to try to implement a method without first checking what the current industry modus operandi is for such a calculation.  Can anyone offer advice on the principle I should be using to calculate down to Ingredient level?  I would like the solution to be extensible, obviously - hopefully working even if 'Caramelised Chestnuts' had an Ingredient that was itself another sub-assembly.

I have developed a 'Proof Of Concept' file that loops through Sub-assembly levels, but it is very complex, and I fear I have missed some fundamental principle that has long-before been established.

All suggestions appreciated.