This dashboard was created to help track and manage key raw material purchasing data.
It brings together important details like the total number of purchase orders, their value, and confirmation status. It also highlights how purchase orders and raw materials are distributed across suppliers, and countries. By consolidating this information in one place, it provides development and production teams with a clearer view of their purchases 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. "Purchase Orders" - Total number of Purchase Orders.
2. "Raw Materials" - Total number of RMs on Purchase Orders.
3. "Confirmed PO" - Total number of 'Confirmed' Purchase Orders
4. "Material Category" - Splits of purchase order quantities across their assigned Raw Material Categories.
5. "PO Overview ( >Supplier >Purchase Order)" -
6. "Pending Purchase Orders" - Total number of open purchase orders pending delivery.
7. "Pending Raw Materials" - Total number of RMs with pending quantities on open purchase orders.
8. "Purchase Cost" - Total cost of Purchase Orders.
9. "Force Closed Value" ( >Supplier)- Total value of closed Purchase Orders.
10. "Raw Materials by Country" - Visual breakdown of a total count of Raw Material IDs on Purchase Orders split by country.
11. "PO Status ( >Supplier >Purchase Order)" - Summary of the values per status for the relevant purchase orders broken down by season, supplier, and Purchase Order number.
12. "Late: Value past 'Delivery To' date" - Total value or purchase orders past their 'Delivery To' date.
13. "Pending Purchase Cost" - Total cost of pending purchase order quantities.
14. "Pending Raw Materials ( >Supplier >Raw Material >Colour)" - Pending number of Raw Materials split by Supplier.
15. "Raw Materials Pending Value - Delivery From" - Pending purchase order units by cost sorted in ascending date order.
16. "Top Suppliers" - Visual breakdown of suppliers based on the count of Raw Materials across the Purchase Orders assigned to them.
17. "Payment Terms Value ( >Supplier)" - Purchase order costs split by Payments Terms.