How to build a bill of materials explosion in Excel

If you ever wanted to calculate the #of components you needed for assembly or purchasing you will find this video useful.
Build on your own or get the file here :
www.etsy.com/ExcelHighway/lis...
I will show you how to build a bill of materials explosion in Excel in 5 minutes.
You can design it for any number of components and products, it's very flexible.
------------------------------
Track: Travel With Us - Vendredi [Audio Library Release]
Music provided by Audio Library Plus
Watch: • Travel With Us - Vendr...
Free Download / Stream: alplus.io/travel-us
------------------------------

[@justinpark9089]

I got great information from your youtube. I really appreciate it. I will use this wonderful skill to my job.

[@excelhighway3549]

Thank you! That's great feedback.

[@reetkay9208]

Great tool and excellent explanation!👍

[@excelhighway3549]

Glad you liked it!

[@BillyClever]

Thanks for your file sharing!

[@excelhighway3549]

My pleasure!

[@asephilman297]

A very useful tool and simple explanation

[@excelhighway3549]

Thank you

[@raheimcason1191]

I make frames with a number of different parts and I've been trying to create a sheet that would give a total of all the parts I need so thank you for this. Question, to make it work for me do I just substitute what you used as comp numbers with actual part numbers?

[@excelhighway3549]

Yes, comp and prod numbers should be replaced but actual items.

[@sammerkazwah]

Is there a way to create a BOM with hierarchy? Essentially a Top to Bottom Level Assembly with indentures that includes collapsing each level as such? I've been looking everywhere and can't seem to find a video to guide me. Thanks!

[@excelhighway3549]

It sounds like a challenge, I can take a look. If I find a way I will post a video on it.

[@excelhighway3549]

Please take a look at this video:
ruclips.net/video/izi2NDa9GZc/видео.html
I hope that will help.

[@singaleonard2136]

How do the opposite? You have the component stock, then into which Finish good item could to produce?

[@excelhighway3549]

This is called a where used report. I started working on that and will post a video about that in the future.

[@dennissept856]

My ingredients come in variable sizes/weights (KG, Grams, Litres, Gallons) how can this be accommodated as some of these ingredients are used on multiple final products but are stocked as bulk volumes/weights.

[@excelhighway3549]

You should probably always use the same unit. Only use KG and Litres for example. That way it's clear if you want to make changes.

[@dennissept856]

@@excelhighway3549 That is challenging, as example, we make a pre-rolled non-cannabis product that uses.5grams of dried hemp, infused with .003% CBD distillate, uses 1 pre-roll paper and a crutch/filter, placed 3 to a slider box, labeled, slider box is placed into a myler pouch and sealed/labeled, and 12 of these put into an inner case, and labeled, and 4 inner cases placed into a Master Case, which gets 2 labels. Kg’s will only come into play when calculating the pallet configuration prior to shipping. The distillate is the only input purchased by weight, all other requirements are purchased as counted quantities, which may have minimum order quantities as well so we also need to take into consideration any inventory we have in hand, and re-calculate the amounts to buy/not buy to manufacture a minimum production run. The inputs to all product lines have similar challenges. We actually purchase internationally, to build the final product so we need to use: Lbs, oz., KG, Grams, ml, Ltr., and individual counts for hard goods.

[@j.kaushikkaushik8966]

It's possible like sale report coloum in this feature in all products in add particles in Excel sheet plz help them

[@excelhighway3549]

Sorry, I did not understand

[@devenderkumarshah9951]

Hi need to prepare the List from complete stock how many kits I can prepare from given stock as per BOM

[@devenderkumarshah9951]

Please make an video

[@excelhighway3549]

I think this video could help you:
ruclips.net/video/pBZ3hG4ne9Y/видео.html
Please take a look.

[@excelhighway3549]

Get the file here:
www.etsy.com/ExcelHighway/listing/1313221836/bill-of-materials-explosion-file?Copy&ListingManager&Share&.lmsm&share_time=1666031391163

[@sandragualdron5863]

I'd like to have it. Thank you!

[@excelhighway3549]

@@sandragualdron5863 please send me an email

[@sandragualdron5863]

@@excelhighway3549 where can I find your e-mail address?

[@excelhighway3549]

@@sandragualdron5863 [e-mail]

[@arockiagibson2698]

not able to buy from the link.. is there any alternate way to purchase? pls share your email. thank you

[@excelhighway3549]

Email me at [e-mail]

[@khususkomen9227]

I do

[@excelhighway3549]

Please send an email

[@matthewmckenzie5151]

can i get this file please? Thanks

[@excelhighway3549]

Yes, please send an email

[@jazzz3014]

Can you please share the template

[@excelhighway3549]

Please send me an email

[@user-sc7ml3sr6g]

can you please share this template ?

[@excelhighway3549]

The file is available on my Patreon page:
www.patreon.com/ExcelHighway