- Overview: A snapshot of inventory levels in DCs by quantities, units, and dollars on hand.
- Drivers: Factors that contribute to your inventory levels.
- Details: Granular information to help you take action when inventory is high or low.
Overview
The Overview section gives you a sense of your inventory status.Quantity on Hand over Time
This line graph displays your inventory quantity on hand over time, helping you recognize cyclical and seasonal patterns. It’s filtered to show only current inventory products.Overview tiles
- Latest Report Date: 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.
Inventory by Product
This table displays each product’s inventory information and DCs with inventory on the latest report date.Drivers
Inventory by State
This heat map shows whether inventory is high or low at distribution centers by state, so you can take steps to normalize your inventory levels. The metric is Historical Weeks of Supply: on-hand inventory divided by the average number of units selling per week over the lookback period you set at the top of the dashboard. For example, if you have 100 units on hand and sell 50 units in a typical week, you have two weeks of supply. See Historical Weeks of Supply below for the full definition and how the lookback period affects the calculation.Inventory by Distribution Center
Each product’s inventory information by distribution center for the selected time period.Filtering by product availability
Use the Availability filter (located after the Group by filter) to narrow your view to products with a specific status. The filter supports multi-select, so you can view more than one status at a time. Availability values are translated into readable labels so you can filter without needing to know the underlying source codes. Common labels include Active, Discontinued, and Suspended. Additional statuses — such as For Sale — may appear depending on the business line you’re viewing. The exact set of values varies by business line: Natural, Conventional, Tony’s Fine Foods (TFF), Albert’s, and Canada each surface the statuses that apply to their catalog. Open the filter to see the options available for the business line you’re viewing. Because these labels reflect UNFI’s own product-lifecycle definitions, the precise meaning of a status (for example, when a product moves between Active, For Sale, and Discontinued) is set by UNFI. If you need an exact definition for a specific status in your business line, contact the UNFI Insights team.Inventory Details
The Inventory Details table at the bottom of the dashboard provides more granular product and DC information. You can select an individual cell in the table to filter by a specific DC.Demand Forecast Quantity details
The Demand Forecast Quantity column shows a proprietary estimate of expected weekly demand for the DC over the upcoming four-week window, and includes both seasonality and anticipated promotional lift. It is calculated as the average of UNFI’seffective_forecast for the next four Sunday-aligned weeks starting from the current Sunday.
If UNFI has not yet published a forecast for one of those four weeks, that week is dropped from the average rather than counted as zero demand, so a partial forecast horizon does not artificially deflate the number. A 0 value means there is no forecast demand for the window — either UNFI expects no demand, or no forecast has been published for that product and DC.
Note: This forecast can help you anticipate demand, but it’s not a commitment and may change until purchase orders (POs) are finalized.
Weeks of Supply
The dashboard exposes two Weeks of Supply (WOS) measures. Both estimate how many weeks your current on-hand inventory will cover, but they use different demand signals. For new users, we recommend using Forecast WOS. It reflects UNFI’s forward view of demand, including seasonality and promotions, so it gives you the most accurate read of how long your on-hand inventory will last. Historical WOS remains available so existing users who have built processes around the trailing sales calculation can transition to Forecast WOS at their own pace.Historical Weeks of Supply
Historical Weeks of Supply (Historical WOS) divides current on-hand inventory by the average number of units selling per week over a trailing lookback period. It answers the question “how many more weeks would this inventory last if it kept selling at the recent pace?”- The lookback period is set by the Lookback period dropdown at the top of the dashboard.
- Days with no sales are excluded from the weekly average. For example, if you select a two-week lookback but only the second week has sales data, only one week is used.
- Historical WOS is the metric used in the Inventory by State heat map and is available across all business lines.
Forecast Weeks of Supply
Forecast Weeks of Supply (Forecast WOS) projects how many weeks your current on-hand inventory will cover, using UNFI’s weekly demand forecast for the next 26 weeks instead of a trailing sales average. Starting from the current Sunday, Forecast WOS walks on-hand inventory forward one week at a time and subtracts each week’s forecasted demand, up to 26 weeks out. The result is the number of weeks of supply the current on-hand position covers against forward demand rather than recent sales history. A few things to know when reading Forecast WOS:- A week with
0forecasted demand still counts as a week of coverage. - A week with no published forecast is treated the same as
0forecasted demand, so the walk continues through it. - If on-hand inventory outlasts the full 26-week horizon, Forecast WOS shows >26 weeks.
- A product and DC combination with no published forecast at all also shows >26 weeks, because nothing is subtracted during the walk. Check the Demand Forecast Quantity column to tell these apart: a value of
0means there is no forecast demand behind the number.
