Indented Bill of Material

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Simple worksheet for calculating material requirements using an exploded indented bill of materials (BOM). Modify the itemlist worksheet to suit materials actually used. Then manually write the exploded BOM on the BOM worksheet, on the left. Set the BOM level to indent the list on the right. To the list on the right add the unit quantities to make one unit of the parent assembly. Run StyleBOM macro to apply styles to each level, and assist with checking correct assignment of levels. Run macro CalcAggrQty to scan along each branch of the product-tree and calculate aggregate quantities for each item at point in tree. Run macro summariseAggrQty to scan the BOM, and then accummulate quantities for common items onto the itemlist worksheet. WARNING: The each macros can take a few minutes to complete. An improvement is to automatically exploded single level BOM's into the full BOM. Problem with that approach is Excel not good user interface without some VBA programming. I have such workbook, but takes ages to manually find and modify the single level BOM's. I will up load the various versions at a later date.

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
05 May 2010
Submitted By:
File Date:
02 May 2010
File Author:
Conrad Harrison
File Version:
File Size:
242.50 Kb
File Type:
stars/0.gifTotal Votes:0
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.


#1 leeyoung 2010-08-06 11:53
Thanks for sharing

Please sign in or register to add a comment.

We have 3 guests and 37 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Real Time Analytics