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 :
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
––––––––––––––––––––––––––––––

[hockeytown]

This was exactly what I was looking for. Thank you. Very informative.

[raheimcason]

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?

[justinpark]

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

[devenderkumarshah]

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

[singaleonard]

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

[dennissept]

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.

[asephilman]

A very useful tool and simple explanation

[reetkay]

Great tool and excellent explanation!👍

[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!

[j.kaushikkaushik]

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

[arockiagibson]

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