IE/POM/CAPM Automatic Explosion of Bill of Materials
Define an assembly in terms of single level bills of materials (BOM), then explode into an indented list. Run additional macros to aggregate quantities for individual branches of product-structure-tree, and to determine gross quantities of common items. Additional macros to check assemblies called up have definitions. Useful for students studying POM and CAPM. For large assemblies editing the single level BOMs gets cumbersome, so next stage of development is to add more dialogue boxes to ease the input of the assembly definition.
07 Jun 2010
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.