Bill-of-Material Excel Dashboard

This Excel-based Bill of Materials (BOM) Dashboard provides a visualized way to track the Machine-Material-Manpower-Money components of factory production.

Use this interactive tool to easily answer questions like:

- Do we have enough raw materials in stock? If not, how long will it take to restock?  

- What will it cost to produce our target volume this month? 

- Do we have enough workers available, and what will labor costs look like?**  

- Are our machines ready, or do we need maintenance to avoid production delays?  

A walkthrough on how this dashboard was built is available on Youtube here