This dashboard was created to help track and manage key Raw Material Inventory data.
It brings together important details like the total number of purchase orders, their cost and your closing and manufacturer unallocated inventory levels and costs also.
It also highlights how the inventory levels are split by supplier, and material categories.
By consolidating this information in one place, it provides purchasing teams with a clearer view of performance, helping to spot trends, spark conversations, and quickly address any concerns.
Note, some of the widgets have Large Number Formatting switched on. (rounded to 2 dp)
1. "Main - Closing Cost" - Total cost of the Closing stock units in Main Raw Material Inventory.
2. "Main - Closing QTY" - Total number of Closing stock units in Main Raw Material Inventory.
3. "Negative Closing" - Total number of Raw Materials with Negative Closing Stock values.
4. "Negative Projected" - Total number of Raw Materials with Negative Projected Stock values.
5. "MFR - Unallocated Cost" - Total cost of Unallocated units across all manufacturer's inventory.
6. "MFR - Unallocated QTY" - Total number of Unallocated units across all manufacturer's inventory.
7. "Main - High Stock by Value" ( > Raw Material ID >Colour) - Proportional display of the total cost value of Raw Materials with the highest closing stock quantities within Main Inventory.
8. "Main - High Stock by QTY" ( > Raw Material ID >Colour) - Proportional display of Raw Materials with the highest closing stock quantities within Main Inventory.
9. "Inventory Movements" ( > Raw Material ID Colour) - A cost breakdown of raw material Inventory Movements per season.
10. "MFR - High Stock by Value" ( > Raw Material ID >Colour) - Proportional display of the total cost value of Raw Materials with the highest closing stock quantities within Manufacturer Inventory.
11. "MFR - High Stock by Quantity" ( > Raw Material ID >Colour) - Proportional display of Raw Materials with the highest closing stock quantities within Manufacturer Inventory.
12. "Main - Closing Cost by Season" - Total cost of Main Raw Material Closing stock per season.
13. "Main - Material Category" - Split of Raw Material Closing stock value by Raw Material Category within Main Inventory.
14. "MFR - Unallocated Cost by Season" - Total cost of Unallocated MFR stock per season.
15. "MFR - Material Category" - Split of Raw Material unallocated stock value by Raw Material Category within Manufacturer Inventory.
16. "Closing Stock Alert" - Total number of Raw Materials which have reached their stock alert threshold for their Closing Stock values.
17. "Projected Stock Alert" - Total number of Raw Materials which have reached their stock alert threshold for their Projected Stock values.