Inventory Health Dashboard
Overview:
How do you know if your stock on hand can cover the next X weeks?
Do you know your ending inventory based on your initial stock and your weekly demand?
Are you able to identify the main drivers that are contributing to stock outs?
This solution in Power BI tackles the aforementioned questions
Metrics:
WoC: Weeks of Coverage
Weekly Demand: average of Total Demand based on select No. of periods
Min Inventory based on select No. of periods
Inventory Health buckets:
Very low coverage (<1 wk)
Low coverage (1–2 wks)
Healthy coverage (2–5 wks)
High coverage (5–12 wks)
Very High coverage (>12 wks)
Features:
This tool is capable to tell you how healthy your inventory is based on ABC classification and the Inventory Health buckets.
Overview:
How do you know if your stock on hand can cover the next X weeks?
Do you know your ending inventory based on your initial stock and your weekly demand?
Are you able to identify the main drivers that are contributing to stock outs?
This solution in Power BI tackles the aforementioned questions
Metrics:
WoC: Weeks of Coverage
Weekly Demand: average of Total Demand based on select No. of periods
Min Inventory based on select No. of periods
Inventory Health buckets:
Very low coverage (<1 wk)
Low coverage (1–2 wks)
Healthy coverage (2–5 wks)
High coverage (5–12 wks)
Very High coverage (>12 wks)
Features:
This tool is capable to tell you how healthy your inventory is based on ABC classification and the Inventory Health buckets.
Overview:
How do you know if your stock on hand can cover the next X weeks?
Do you know your ending inventory based on your initial stock and your weekly demand?
Are you able to identify the main drivers that are contributing to stock outs?
This solution in Power BI tackles the aforementioned questions
Metrics:
WoC: Weeks of Coverage
Weekly Demand: average of Total Demand based on select No. of periods
Min Inventory based on select No. of periods
Inventory Health buckets:
Very low coverage (<1 wk)
Low coverage (1–2 wks)
Healthy coverage (2–5 wks)
High coverage (5–12 wks)
Very High coverage (>12 wks)
Features:
This tool is capable to tell you how healthy your inventory is based on ABC classification and the Inventory Health buckets.
Prerequisites:
You need to have Power BI Desktop installed in your computer before opening the PBIX File.
You need to have MS Excel installed in your computer before opening the sample file.