Skip to main content
You can optimize inventory at the DC level using the Distribution Center Inventory dashboard, so you can meet customer demand and maximize sales. 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: 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.
Note: For UNFI, the dollar value is calculated using the average retailer purchase price — how much the retailer actually paid the vendor. This is a negotiated value that can be below the listed wholesale price and may differ from other retailers.

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’s effective_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.
Historical WOS reacts to recent sales, so it is best for spotting products whose demand pattern has just shifted.

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 0 forecasted demand still counts as a week of coverage.
  • A week with no published forecast is treated the same as 0 forecasted 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 0 means there is no forecast demand behind the number.
Forecast WOS is available for the Natural and Conventional business lines. Other business lines (Tony’s Fine Foods, Albert’s, Canada) continue to rely on Historical WOS only. If you have any questions or experience issues, please reach out to UNFIinsights@unfi.com.