Exploded Bill Of Materials

Estimating large projects requires an exploded bill of materials in order to get a good understanding of the requirements.   The larger the project you have to estimate the more in depth the bill of materials will be.   If you are estimating you want to make sure all the bills of materials are entered correctly into the estimate but also you want to enter the bill of materials efficiently.   Your estimating system should allow you to enter a proper bill of materials in order to allow creation of the requirements in order to calculate minimums, setups and quantity discounts properly.

If a bill of material list is available as shown below you can merge items together

Part Number                         Name                                       Quantity

Widget A                                 16 GAGE CRS  48×120       10

Widget B                                  16 GAGE CRS 48X120         3

Widget C                                  14 GAGE CRS 48X36            5

When you are estimating you generally would price each of these components separately and then roll the costs up for a grand total.   By creating an exploded bill of material which merges these items together you can actually get a more accurate cost because buying 13 if an item may be less expensive then purchasing 10 and 3.   The other advantage is if you are using raw materials like sheet stock, tubing, wood, etc. you may have the opportunity to nest the bill of material together to arrive at a quantity required which was 13 and would now be 9 through nesting.   Setup and minimums can also be reduced by aggregating the bills of material together.

You can see how beneficial an exploded bom is for quoting and estimating.    Job costing starts at the estimating and quoting area and extends throughout the ERP package.   Job cost estimating software can save you a lot of time, money and energy and help you to win new work.

Next we will be talking about an indented or exploded bill of material which includes labor.  Most bills of materials do not include a roll up of labor which can be very good for seeing an aggregated view of the labor required to manufacture the job.

MIE Solutions provides software products to make your business process more efficient so please take a look at our product line below.  MIE Trak and QuoteIt are two products which provide an efficient way to do job shop cost estimating.



Author: MIE Solutions

David Ferguson has over 20 years of experience in the manufacturing and fabrication industry. David Ferguson has been to over 100 manufacturing companies helping and guiding them to be more efficient and cost effective. As a child in Junior High School David Ferguson found a passion for the early computer systems, which would drive much of his future work. David Ferguson created and sold his first computer program, Arrow Data Systems, which was an early CAD/CAM system for the Apple 2e Computer. In the late 1980's after seeing his father (a sheet metal manufacturer) come home many nights estimating, David Ferguson saw an opportunity to optimize his effort through computer technology. Shortly thereafter the FabriTRAK Production Control package was developed. The Quote It! estimating package was developed out of the FabriTRAK system to become one of the leading sheet metal estimating packages in the world. David Ferguson has always had a passion for developing software to make the manufacturing process simpler, faster and more efficient. Prior to founding MIE Solutions David Ferguson worked with his father at Alco Sheet Metal, METALSOFT Inc. and was a consultant at Toyota Motors Sales. David Ferguson has his Masters in Computer Science and Mathematics from California State University, Long Beach.

One thought on “Exploded Bill Of Materials”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s