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 ...

Finally, using another Excel sheet containing your current stock, the Bill of Materials will let you know if you have enough components for the assembly stage. A video of the tool in action is ...

A bill of materials, or BOM, performs the same function but with text instead of images. One benefit of creating a BOM in Excel is that you can hide a project's details to reveal its larger ...