The Store and DC Inventory dashboards help you optimize inventory at the store or DC level, so you can meet customer demand and maximize sales. You can see how inventory stacks up by product, store, and region and determine if inventory levels are above or below average. This dashboard is divided into three sections:
- Overview: See a snapshot of inventory levels in stores, by quantities, units, and dollars on hand.
- Drivers: Understand the factors that contribute to your inventory levels.
- Details: Dig in to granular information that helps you take action when inventory is high or low.
The Overview section allows you to get a sense of your inventory status. Use the following map of the screen to guide you.
Quantity on Hand over Time
This line graph displays your inventory quantity on hand over time, helping you recognize cyclical and seasonal patterns. It is filtered to show only current inventory products.
- Latest Report Date: Lists the most recent dates that inventory data was received.
- Total Quantity on Hand: The total on hand units for the selected filters.
- Total Dollars on Hand: The total dollar value of your on hand units for the selected filters.
Note: The total dollar value may be based on different price metrics depending on the retailer. For UNFI, the dollar value is calculated using the average retailer purchase price, which is how much the retailer actually paid the vendor and is a negotiated value that can be below the listed wholesale price.
Inventory by Product
This table displays each product's inventory information and stores with inventory on the latest report date.
Inventory by State
This heat map allows you to get a pulse on whether inventory is high or low at stores by state, so you can take steps to normalize your inventory levels. This metric is calculated by taking the on hand inventory and dividing it by the average number of units selling in a week. For example, if you have 100 units on hand and sell 50 units in a typical week, you have 2 weeks of supply. The average number of units selling per week is calculated using the time frame you specify in the Weeks of Supply Lookback period drop-down menu at the top of the dashboard.