How to Create a BOM Using MS Excel. Tree diagrams use graphics to indicate the materials comprising a project or product and the relationships between those materials. A bill of materials, or BOM ...

If your company requires a simple bill of materials template, you can make one in Excel that lists the materials, descriptions and prices and calculates totals as well, rather than purchase ...