UNFI Insights glossary

Visualization glossary

The following table lists and describes all of the visualizations (charts, graphs, tables, tiles, and table columns) in UNFI Insights to help you get clarification on terms or more deeply understand a calculated value. The Calculated by Crisp? column also indicates whether a visualization contains data that is calculated by Crisp or is directly derived from the source data we get from UNFI.

Visualization name	Type	Description	Calculated by Crisp?
Year Over Year Cases Shipped/Cases Shipped Over Time	Line graph	Displays your sales (in cases shipped) over time to help you track cyclical and seasonal patterns. Hover over a date for more information or click one to filter the dashboard by that date.	N
Year Over Year Sales Dollars/Sales Dollars Over Time	Line graph	Displays your sales over time to help you recognize cyclical and seasonal patterns. Hover over a date for more information or click one to filter the dashboard by that date.	Y (Conventional), N (Natural)
Cases Shipped Selected Period/Total Cases Shipped	Overview tile	Total sales (in cases shipped to stores) for the selected filters.	N
Sales Dollars Selected Period/Total Sales Dollars	Overview tile	Total sales in dollars for the selected filters. Calculated as follows: invoiced quantity * UNFI sell amount	Y
Sales Dollars Selected Period/Total Sales Dollars	Overview tile	Total sales in dollars for the selected filters.	N
Year Over Year Sales by Product/Sales by Product	Table	Provides each product’s cases shipped and dollar sales, sorted descending, to help you identify your best products or products that may need assistance in sales growth.	See individual metrics
Year Over Year Sales by State/Sales by State	Heat map	Provides year over year changes in cases shipped and dollars sold in each state to help you refine search engine optimization (SEO) decisions and optimize where you run digital marketing campaigns.	See individual metrics
Year Over Year Sales by City/Sales by City	Table	Provides year over year sales (dollars and cases shipped) by city, stored descending, to help you get insight into cities where product(s) sell well, geo-targeting for campaigns, city pattern analysis, and demo performance in particular cities.	See individual metrics
Year Over Year Sales by Chain/Sales by Chain	Table	Provides year over year sales (dollars and cases shipped) by chain, sorted descending, to help you understand which chains are purchasing your products and which are underperforming or not purchasing anymore.	See individual metrics
Year Over Year Sales by Distribution Center/Sales by Distribution Center	Table	Provides year over year sales (dollars and cases shipped) by distribution center (DC), sorted descending, so you can see which DCs stock your products and get a sense of regionality.	See individual metrics
Year Over Year Sales by Store/Sales by Store	Table	Provides year over year sales (dollars and cases shipped) by store, sorted descending, to help you gauge performance at individual stores.	See individual metrics
Year Over Year Sales Details/Sales Details	Table	Provides store-level details to help you put your insights into action.	See individual metrics
Cases Shipped Per Store Per Week Over Time	Line graph	Provides store-level details to help you put your insights into action.	N
Year Over Year Cases Shipped	Line graph	Displays your sales (in cases shipped) over the selected time period, as well as sales for the same date the prior year, to help you track patterns and gauge performance compared to the previous year. Hover over a date for more information or click to fliter the dashboard by that date.	N
Cases Shipped Per Store Per Week for Selected Period	Overview tile	Displays your sales (in cases shipped) over the selected time period, as well as sales for the same date the prior year, to help you track patterns and gauge performance compared to the previous year. Hover over a date for more information or click to fliter the dashboard by that date.	N
Cases Shipped for Selected Period	Overview tile	Displays the total sales in cases shipped for stores for the selected filters.	N
Year Over Year Cases Shipped Per Store Per Week by Product	Table	Displays your sales in cases shipped per store per week for the selected period, as well as sales for the same period in the prior year, to help you analyze your performance at the store level.	See individual metrics
Year Over Year % Change in Weekly Cases Shipped Per Store by State	Heat map	Displays the year over year percent change in weekly cases shipped per store and quantity sold for each state. This heat map is useful for refining your search engine optimization (SEO) strategy and planning digital marketing campaigns.	See individual metrics
Cases Shipped Per Store Per Week by City	Table	Displays your sales in cases shipped per store per week by city for the selected period, as well as sales for the same period in the prior year, to help you track regional performance, and plan search engine optimization (SEO) and digital marketing strategies.	See individual metrics
Cases Shipped Per Store Per Week by Chain	Table	Displays your sales in cases shipped per store per week by chain for the selected period, as well as sales for the same period in the prior year, to help you analyze your performance at the chain level.	See individual metrics
Cases Shipped Per Store Per Week by Distribution Center	Table	Displays your sales in cases shipped per store per week by distribution center (DC) for the selected period, as well as sales for the same period in the prior year, to help you analyze your performance at the DC level.	See individual metrics
Cases Shipped Per Store Per Week by Store	Table	Displays your sales in cases shipped per store per week by store for the selected period, as well as sales for the same period in the prior year, to help you analyze your performance at the store level.	See individual metrics
Year Over Year Velocity Details	Table	Displays your sales for the selected and the same period the prior year per store per week by product to help you analyze performance at the store/item level.	See individual metrics
Year Over Year Receiving Points of Distribution	Line graph	Displays your receiving points of distribution (PODs) over time, as well as for the same period in the prior year for comparison to help you spot trends and compare distribution compared to the previous year. Hover over data points for more information or click to filter the dashboard by that date.	Y
Receiving Points of Distribution for Selected Period	Overview tile	Displays your total receiving PODs for the selected filters.	Y
Year over Year Receiving Points of Distribution by Product	Table	Provides your receiving PODs by product to help you analyze distribution at the product level.	See individual metrics
Year over Year Change in Receiving Points of Distribution by State	Heat map	Displays the year over year percent change in receiving PODs and cases shipped for each state to help you identify regions where distribution is high or low.	See individual metrics
Receiving Points of Distribution by City	Table	Displays your receiving PODs by city for the selected period, as well as receiving PODs for the same period in the prior year, for comparison.	See individual metrics
Receiving Points of Distribution by Chain	Table	Displays your receiving PODs by chain for the selected period, as well as receiving PODs for the same period in the prior year, for comparison.	See individual metrics
Receiving Points of Distribution by Distribution Center	Table	Displays your receiving PODs by distribution center for the selected period, as well as receiving PODs for the same period in the prior year, for comparison.	See individual metrics
Receiving Points of Distribution by Store	Table	Displays your receiving PODs by store for the selected period, as well as receiving PODs for the same period in the prior year, for comparison.	See individual metrics
Year Over Year Receiving Points of Distribution Details	Table	Displays your receiving PODs by store and product for the selected period, as well as receiving PODs for the same period in the prior year, for comparison.	See individual metrics
Inventory by Product (Top 20)	Pie chart	Displays your inventory broken down by the top 20 products with the greatest on hand quantities. You can add filters to dig deeper into your product on hands, such as filtering by a specific distribution center (DC) to see the product makeup at that DC. You can also hover for details or click a slice to filter by that product.	Y
Inventory by DC (Top 20)	Pie chart	Displays your inventory broken down by the top 20 distribution centers with the greatest on hand quantities. You can hover for details or click a slice to filter by that DC.	Y
Total Units on Hand	Overview tile	Displays the total units on hand for the selected filters.	N
Total Dollars On Hand	Overview tile	Displays the total dollars on hand for the selected filters. Dollars on hand is calculated as follows: latest average retailer price (i.e., the amount retailers paid UNFI) * on hand quantity.	Y
Current Report Date	Overview tile	The latest report date for data that has been processed. Note: Once data is received, it may take a few hours to process, during which this date will display the previous report date.	N
Current Inventory	Table	Provides current on hand and on order quantities, weekly averages for on hand and on order quantities, and an estimate of how many weeks of supply you have remaining based on the number of weeks selected in the Weeks of Supply Lookback Period filter.	See individual metrics
Inventory by DC	Table	Provides a sortable breakdown of your inventory by distribution center.	See individual metrics
Details (Conventional Inventory dashboard)	Table	Provides a sortable breakdown of your inventory by distribution center and product.	See individual metrics
Quantity on Hand Over Time	Line graph	Displays your inventory quantity on hand over time, helping you recognize cyclical and seasonal patterns. It is filtered to only show current inventory products. Hover over data points for more information or click to filter the dashboard by that date.	N
Total Quantity on Hand	Overview tile	Displays the total units on hand for the selected filters.	N
Inventory by Product	Table	Provides each product’s inventory information and distribution centers with inventory as of the latest report date.	See individual metrics
Inventory by State	Table	For each state with inventory, provides current on hand and on order quantities, weekly averages for on hand and on order quantities, and an estimate of how many weeks of supply you have remaining based on the number of weeks selected in the Lookback Period filter.	See individual metrics
Inventory by Distribution Center	Table	For each distribution center, provides current on hand and on order quantities, weekly averages for on hand and on order quantities, and an estimate of how many weeks of supply you have remaining based on the number of weeks selected in the Lookback Period filter.	See individual metrics
Inventory Details	Table	By distribution center and product, provides current on hand and on order quantities, weekly averages for on hand and on order quantities, and an estimate of how many weeks of supply you have remaining based on the number of weeks selected in the Lookback Period filter.	See individual metrics
Net Wholesale Dollars At Risk Over Time	Line graph	Provides the net wholesale dollars at risk over time to help you understand the cost impact of the inventory at risk of spoilage and see how it has changed. This reflects the wholesale value of product at risk, not actual chargeback amounts for spoiled product. For more, see UNFI Spoilage Risk dashboard.	Y
Latest Report Date	Overview tile	The latest report date for data that has been processed. Note: Once data is received, it may take a few hours to process, during which this date will display the previous report date.	N
Total Dollars at Risk	Overview tile	The total net wholesale dollars at risk of spoilage for the selected filters.	Y
Total Quantity at Risk	Overview tile	The total units at risk of spoilage for the selected filters.	Y
Spoilage Risk by Product	Table	Displays inventory at risk of spoilage by product.	See individual metrics
Spoilage Risk by Distribution Center	Table	Displays inventory at risk of spoilage by distribution center.	See individual metrics
Spoilage Risk Detail	Table	Provides spoilage risk details for your products and allows you to sort by expiration date, weeks to expiration, weeks on hand by lot, wholesale dollars at risk by lot, and more.	See individual metrics
Category Share YOY Change	Bar chart	This drip chart in this section displays the percentage change in category share from the previous year over the specified time frame, so you can understand how your brand is gaining or losing category share to your competitors.	Y
Category YOY Percent Change	Bar chart	Displays the percent change in sales for the categories in which you sell products compared to the previous year.	Y
My YOY Percent Change	Bar chart	Displays the percent change in sales for your products compared to the previous year.	Y
Sales over Selected Period	Line graph	Displays sales over time for the category as a whole (in yellow) and sales for your products (in green) to help you understand how your growth compares to the category growth.	Y
Category Share	Overview tile	Displays your total category percent share for the selected filters.	Y
Category Share YOY Change	Overview tile	Displays the change in category share for your products (for the specified time frame and filters) compared to the previous year.	Y
Category YOY Change	Overview tile	Displays the total change in sales for the categories in which you sell products compared to the previous year.	Y
My YOY Change	Overview tile	Displays the total change in sales for your products compared to the previous year.	Y
Category Sales for Selected Period	Overview tile	Displays the total category sales for the selected time period.	Y
My Sales for Selected Period	Overview tile	Displays your total sales for the selected time period.	N
Category Sales Change YOY	Overview tile	Displays the change in category sales dollars year over year.	Y
My Sales Change YOY	Overview tile	Displays the change in your sales year over year.	Y
Category Sales by State	Heat map	Allows you to see states where category growth is high versus regions that are underperforming.	Y
My Sales by State	Heat map	Allows you to see states where your product growth is high versus regions that are underperforming.	Y
My Store Penetration	Line chart	Allows you to compare stores that sell products in your category to stores where your product is actually sold to help you understand the degree to which your product has penetrated the market at the store level.	Y
My Distribution Penetration	Line chart	Allows you to compare potential points of distribution (Crisp defines points of distribution as product/store combinations) in your category to your current points of distribution to help you understand the degree to which your product has penetrated the points of distribution in your category.	Y
Category Stores	Overview tile	Displays the number of stores that sell products in your category for the selected filters.	Y
My Stores	Overview tile	Displays stores where you are currently selling your products for the selected filters.	Y
My Store Penetration	Overview tile	Displays the percentage of stores that sell products in your category where you are actually selling your products.	Y
Possible Points of Distribution	Overview tile	Displays the number of stores that sell products in your category where you are not currently selling products to help you see the available opportunities for expansion.	Y
My Points of Distribution	Overview tile	Displays your total points of distribution for the selected time period.	Y
My Distribution Pentration	Overview tile	Provides your distribution penetration for the selected time period.	Y
Sales by State	Table	Provides sales data by state in table format to help you easily sort to find growing or declining regions or export your findings.	See individual metrics
Sales by Subcategory	Table	Allows you to see which subcategories are growing and shrinking to find areas ripe for expansion or product development.	See individual metrics
Sales by Chain	Table	This sortable table helps you identify chains that are good targets for expansion.	See individual metrics
My Product Sales	Table	Displays your sales by product to help you understand how your individual products are performing.	See individual metrics
Sales by Store	Table	Allows you to track growth or decline at the store level, so you can get a list of stores you want to target for expansion or for reduction in distribution.	See individual metrics
Products	Overview tile	Displays the count of distinct products for the selected filters.	Y
Chains	Overview tile	Displays the count of distinct chains for the selected filters.	Y
Potential Lost Sales by Product	Bar chart	This chart takes your weekly UNFI demand forecast and compares it to your quantity on hand. The yellow bars represent the deficit between the two, while the green bars show the wholesale dollars at risk. You can right-click a bar and select Show all to see a breakdown of the deficit.	Y
Potential Lost Sales by Distribution Center	Bar chart	This chart compares your UNFI demand forecast with your quantity on hand and rolls them up to the distribution center level. You can hover over a bar for more information or click on a bar to filter the dashboard by that DC.	Y
Wholesale Dollars at Risk	Overview tile	Provides the total wholesale dollars at risk given the current deficit in your on hand quantity compared to the forecasted need.	Y
Quantity on Hand Deficit to Forecast	Overview tile	Displays the total number of on hand units you are short of the forecasted need.	Y
Potential Lost Sales Detail	Bar chart	This sortable table breaks down potential lost sales in greater detail by showing by product and DC combinations.	Y
Total Pipe by Distribution Center	Bar chart	This chart compares your weekly forecast to your total warehouse pipe (cases on hand and on order). You can right click on a bar to see a breakdown by product.	Y
Forecast vs Quantity on Hand by Distribution Center	Bar chart	This chart focuses solely on what you have on hand at a DC versus what the demand forecast is. If your on hand quantity is low compared to the forecast, you can review the Total Pipe by Warehouse visualization to see how much is on order.	Y
Weeks on Hand by Distribution Center	Bar chart	This chart provides information about how many weeks of inventory you have at each DC before you run out. Weeks on hand is calculated as: on hand quantity / weekly forecast. Weeks of pipe is calculated as: on order quantity + on hand quantity / weekly forecast.	Y
Fill Rate Over Time	Bar chart	Allows you to see how your inbound fill rate has changed over time, so you can gauge the health of your service level.	Y
Fill Rate by Product	Bar chart	Displays your inbound fill rate percentage by product to help you understand if specific items are driving your performance.	Y
Fill Rate by Distribution Center	Bar chart	Displays your inbound fill rate percentage by distribution center to help you understand if specific distribution centers are driving your performance.	Y
Fill Rate	Overview tile	Your overall inbound fill rate percentage for the selected filters	Y
Orders	Overview tile	The total number of orders for the selected time period and filters.	N
Orders Overfilled	Overview tile	The number of orders where the quantity shipped was greater than the quantity ordered.	Y
Orders Underfilled	Overview tile	The number of orders where the quantity shipped was less than the quantity ordered.	Y
New Points of Distribution	Overview tile	The total number of new points of distribution (unique store/product combinations) gained in the selected time period.	Y
At Risk Points of Distribution	Overview tile	The total number of points of distribution that are at risk of becoming lost for the selected time period. The number reflects the number of stores at which more time than normal has passed since they last placed an order. Points of distribution are counted as at risk when the time since their last order is greater than 1 standard deviation above average.	Y
Lost Points of Distribution	Overview tile	The total number of points of distribution considered lost in the selected time period. Points of distribution are counted as lost when the time since their last order is greater than 2 standard deviations above average.	Y
Net Points of Distribution	Overview tile	The net gained/lost points of distribution for the selected time period.	Y
New and Lost Points of Distribution Over Time	Bar chart	Displays new, at-risk, and lost PODs over time, so you can spot big shifts in distribution and assess whether business changes (for example pack changes) are negatively or positively impacting your business. The data in this chart is dynamic - meaning that if you had 60 points of distribution lost six weeks ago and they are showing up on this chart, then they are still lost to this day.	Y
Estimated Lost Weekly Sales	Overview tile	Displays an estimate of the amount of money you will lose next week due to at risk and lost points of distribution. Lost sales are calculated using the average weekly sales for these stores in the past.	Y
New Weekly Sales	Overview tile	Displays the estimated additional weekly revenue you will gain from the new points of distribution. This is calculated using the most recent orders of these new stores.	Y
Net Weekly Sales	Overview tile	Displays the projected net change in weekly sales due to gained and lost points of distribution. Calculated as follows: New Weekly Sales - Potential Lost Weekly Sales.	Y
Product Details	Table	This sortable table provides distribution changes at the product level. You can click on a product name to filter by that product.	See individual metrics
Chain Details	Table	This sortable table provides distribution changes at the chain level. You can click on a chain name to filter by that chain.	See individual metrics
Store Details	Table	This sortable table provides distribution changes at the store level to help you or your broker take action on lost and at risk points of distribution. You can click on a chain name to filter by that store or download the table data to share with others.	See individual metrics
Chargebacks	Bar chart	This chart provides your total sales in dollars (green bars), total chargebacks in dollars (pink bars), and the chargeback percentage of your sales (purple line) over time. This can help you determine whether your spend has had a positive impact on sales.	Y
Total Sales Dollars	Overview tile	Displays your total sales dollars for the selected filters.	N
Total Chargeback Dollars	Overview tile	Displays your total chargeback dollars for the selected filters.	N
Chargeback % of Sales	Overview tile	Displays the percentage of your sales you spent on chargebacks for the selected filters.	Y
Chargebacks by Code	Pie chart	This chart breaks down your chargeback dollars by type, and you can hover over each slice for more information. UNFI’s chargeback codes vary by region. For a complete list of codes and their descriptions, see UNFI chargeback codes. Clicking a slice to filter by chargeback code will result in 0 sales since we cannot attribute sales figures to a given chargeback code without duplication.	N
Chargebacks by Chain	Table	This sortable table allows you to see chargeback dollars by chain to help you understand how efficient a retailer is at giving you a return on your investment.	Y
Chargebacks % of Sales by State	Heat map	This map provides your chargeback percentage of sales by state to help you determine which areas of the country may provide the best return on your chargeback dollar investment.	Y
Chargebacks by Product	Table	Provides your chargeback data by product to help you identify products that are doing well and could be worth investing in for promotions.	See individual metrics
Chargebacks by DC	Table	Provides your chargeback data by DC to help you identify more specific areas that are doing well and could be worth investing in for promotions.	See individual metrics
Details	Table	Displays store-level details and invoice numbers along with chargeback dollars, so you can assess performance at the store level.	See individual metrics
Total Invoice Amount	Overview tile	The total dollar value of the invoices and deductions currently posted on the account that are unpaid.	N
Total Terms Discount Amount	Overview tile	The total terms discount dollars that will be subtracted if paid
within the agreed upon terms. For specific cash terms details please review your Supplier
Agreement.	N
Total Net Payables	Overview tile	The total Invoice Amount minus the Total Terms Discount.	N
Open POs	Overview tile	The total number of purchase orders that have not yet been received by UNFI.	N
Late POs	Overview tile	The total number of late purchase orders. A purchase order is considered late if an open order’s ETA date is in the past or a received order’s ETA date is before the received date.	N
POs by DC	Pie chart	Displays the percentage of your POs that went to each DC. You can hover over a slice in the pie chart to see the number of orders for that DC.	N

Column glossary

The following table lists and describes all of the columns in UNFI Insights to help you get clarification on terms or more deeply understand a calculated value. Column name | Dashboard | Description | Calculated by Crisp?
---|---|---|---
Cases Shipped Selected Period | Year Over Year Sales | The total number of cases shipped in the selected time period. | N
Cases Shipped Prior Year | Year Over Year Sales | The total number of cases shipped during the same time period in the year prior to the selected period year. | N
Change in Cases Shipped | Year Over Year Sales | The difference between the cases shipped during the selected period and the cases shipped during the same period the year prior. Calculated as: current year cases shipped - prior year cases shipped | Y
Percent Change in Cases Shipped | Year Over Year Sales | The percent change in cases shipped from the prior year period to the current year period. Calculated as: (current year cases shipped - prior year cases shipped) / prior year cases shipped x 100 | Y
Sales Dollars Selected Period | Year Over Year Sales | The product sales in dollars for the selected time period. | N
Sales Dollars Prior Year | Year Over Year Sales | The product sales in dollars for the same time period the prior year. | N
Percent Change in Sales Dollars | Year Over Year Sales | The percent change in sales dollars from the prior year period to the current year period. Calculated as: (current year sales dollars - prior year sales dollars) | Y
Product Code | All Sales, Velocity, Distribution, and DC Inventory dashboards | A code that helps identify products that do not have a UPC, such as fresh products. | N
Source number | Year Over Year Sales | The store source number. | N
Weight | Year Over Year Sales/Conventional Sales | Provides the total pounds to help you track variable weight products. | N
Units Per Store Per Week Prior Year | Year Over Year Velocity | The average number of units sold per store per week in the same time period in the year prior. | Y
Units Per Store Per Week Selected Period | Year Over Year Velocity | The average number of units sold per store per week in the selected time period. | Y
Change in Units Per Store Per Week | Year Over Year Velocity | The difference between the average units sold per store per week during the selected period and the average units sold per store per week during the same period the year prior. Calculated as: current year units per store per week - prior year units per store per week. | Y
Percent Change in Units Per Store Per Week | Year Over Year Velocity | The percent change in average units sold per store per week from the prior year period to the current year period. Calculated as: (current year units per store per week - prior year units per store per week) / prior year units per store per week x 100. | Y
Dollars Per Store Per Week Prior Period | Year Over Year Velocity | The average dollars sold per store per week in the same time period in the year prior. | Y
Dollars Per Store Per Week Selected Period | Year Over Year Velocity | The average dollars sold per store per week in the selected time period. | Y
Percent Change In Dollars Per Store Per Week | Year Over Year Velocity | The percent change in dollars per store per week from the prior year period to the current year period. Calculated as: (current year dollars per store per week - prior year dollars per store per week) / prior year dollars per store per week x 100. | Y
Points of Distribution Prior Year | Year Over Year Distribution | The number of unique store/product combinations with sales for the same period in the prior year. | Y
Points of Distribution Selected Period | Year Over Year Distribution | The number of unique store/product combinations with sales for the selected period. | Y
Percent Change in Points of Distribution | Year Over Year Distribution | The percent change in the number of unique store/product combinations with sales from the prior year to this year. Calculated as: (points of distribution selected period - points of distribution prior year period)/ points of distribution prior year x 100 | Y
Dollars on Hand | Inventory | The amount, in dollars, of on hand inventory for the selected period. | Y
Quantity on Hand | Inventory | The number of on hand inventory units for the selected period. | N
Dollars on Order | Conventional Inventory | The dollar value of inventory on order for the selected period. | N
Quantity on Order | Conventional Inventory | The number of inventory units on order for the selected period. | N
Weeks of Supply | Inventory | The weeks of supply is calculated as the on hand quantity divided by the average weekly sales. Average weekly sales is based on the period selected in the Weeks of Supply Lookback Period filter. | Y
Average Dollars on Hand | Conventional Inventory | The average dollars on hand based on the prior period (e.g., Last 8 weeks) selected in the Weeks of Supply Lookback Period filter. | Y
Average Quantity on Hand | Inventory | The average quantity on hand for the selected period based on the prior period (e.g., Last 8 weeks) selected in the Weeks of Supply Lookback Period filter. | Y
Average Dollars on Order | Conventional Inventory | The average dollars on order for the selected period based on the prior period (e.g., Last 8 weeks) selected in the Weeks of Supply Lookback Period filter. | Y
Average Quantity on Order | Inventory | The average quantity on order for the selected period based on the prior period (e.g., Last 8 weeks) selected in the Weeks of Supply Lookback Period filter. | Y
Latest on Hand Date | Inventory | The latest report date for data that has been processed. Note: Once data is received, it may take a few hours to process, during which this date will display the previous report date. | N
Distribution Centers | Distribution Center Inventory | The number of distribution centers stocking the product. | Y
Forecast Quantity | Conventional Distribution Center Inventory | The forecasted weekly product demand (in units as sold to UNFI- either cases or eaches). | N
Forecast Dollars | Conventional Distribution Center Inventory | The forecasted weekly product demand (in dollars). | N
Avg Weekly Sales | Distribution Center Inventory | The average number of cases shipped per week based on the prior period (e.g., Last 4 weeks) selected in the Lookback Period filter. | Y
Weekly Forecast | Distribution Center Inventory | A proprietary estimate of the expected base demand for the upcoming week, excluding any anticipated lift from promotions.
Note: While this forecast can help you anticipate demand, it is not a commitment and may change until purchase orders (POs) are finalized.
For more details on using this data to do demand planning, see UNFI Insights Distribution Center overview > Weekly Forecast details section. | N
Avg Sales Amount per Case | Natural Distribution Center Inventory | The average sales amount per case. | Y
Avg Wholesale Price | Natural Distribution Center Inventory | The average wholesale price. | Y
Expiration Date | Spoilage Risk | The product expiration date for a given product lot. | N
Weeks to Expiration | Spoilage Risk | The number of weeks until the product lot reaches its expiration date. | Y
Net Wholesale Dollars at Risk | Spoilage Risk | The dollar value of units that you will not use before their expiration date based on the current forecast. For more on spoilage risk calculations see the UNFI Spoilage Risk dashboard article. | Y
My Volume for Selected Period | Category Performance | The sales volume for your products over the selected time period. | Y
My Volume Change YOY | Category Performance | The change in sales volume (in units) from the prior year. Calculated as: sales volume selected period - sales volume from same period prior year. | Y
My Volume % Change YOY | Category Performance | The percent change in sales volume (in units) from the prior year. Calculated as: (sales volume selected period - sales volume prior year period) / sales volume prior year period x 100 | Y
Category Volume for Selected Period | Category Performance | The category sales volume for the selected time period. | Y
Category Volume Change YOY | Category Performance | The change in sales volume (in units) for the entire category from the prior year. Calculated as: category sales volume selected period - category sales volume from same period prior year. | Y
Category Volume % Change YOY | Category Performance | The percent change in sales volume (in units) for the entire category from the prior year. Calculated as: (category sales volume selected period - category sales volume prior year period) / category sales volume prior year period x 100 | Y
Category Stores Selected Period | Distribution Expansion | The number of stores selling products in your category. | N
My Stores Selected Period | Distribution Expansion | The number of stores selling your products. | N
My Store Penetration Selected Period | Distribution Expansion | The percentage of stores selling your product out of stores that sell products in your category. | Y
My Distribution Penetration Selected Period | Distribution Expansion | The percentage of potential points of distribution (i.e., product/store combinations) in your category that you currently distribute to. | Y
Category Volume for Selected Period | Distribution Expansion | The number of units sold in the selected period. | N
My First Sale in Period | Conventional Distribution Expansion | The date of the first sale in the selected period. | N
Chain Count | Conventional Speciality Chain Sales | The number of chains that sell your product. | Y
Cases Shipped | Conventional Speciality Chain Sales | The number of cases shipped in the selected period. | N
Average Cases Shipped | Conventional Speciality Chain Sales | The average number of cases shipped based on the past 14 days. | Y
Sales Dollars | Conventional Speciality Chain Sales | The sales dollars for the selected period. | N
Total Quantity on Hand Deficit to Forecast | Natural Potential Lost Sales | The total number of units you are short of the forecasted demand. | Y
Total Wholesale Dollars at Risk | Natural Potential Lost Sales | The total wholesale dollar value of units you are short of the forecasted demand. | Y
Service Date | Natural Fill Rate | The first date of the week when the PO was supposed to land. | N
Promo Type | Natural Fill Rate | Indicates if the product was distributed for promotional purposes or not. | N
Quantity Received | Natural Fill Rate | The quantity received in the shipment. | N
Revised Quantity Ordered | Natural Fill Rate | The quantity submitted to revise the original quantity ordered on the purchase order (if no changes, the number will reflect the quantity originally ordered). | N
Fill Rate | Natural Fill Rate | The inbound quantity received for the order divided by the quantity ordered. If you see fill rates over 100% that means you have delivered more than was ordered. Less than 100% means you have delivered less than what was ordered. | Y
New | Natural Retention | The number of new points of distribution (PODs) in the selected period. A POD is counted as new when it has its first sale (weeks since last sale is 0). | Y
New Sales | Natural Retention | The total sales for new points of distribution. | Y
New Weekly Sales | Natural Retention | The average weekly sales for new points of distribution. | Y
At Risk | Natural Retention | The number of at risk points of distribution (PODs) in the selected period. PODs are counted as at risk when the time since their last order is greater than 1 standard deviation above average. | Y
Lost | Natural Retention | The number of lost points of distribution (PODs) in the selected period. PODs are counted as lost when the time since their last order is greater than 2 standard deviations above average. | Y
Estimated Lost Sales | Natural Retention | An estimate of the sales dollars you will lose in the selected period due to points of distribution at risk or lost. | Y
Estimated Lost Weekly Sales | Natural Retention | An estimate of the amount of money you will lose weekly due to at risk and lost points of distribution (store/product combinations). This is calculated based on the historical average weekly sales of the same stores. | Y
First Sales Period Date | Natural Retention | The date of the first sale of all time for the product at the given store. | Y
Lost Sales Period Date | Natural Retention | The date of the most recent purchase of the product at the given store. | Y
Weeks Since Last Purchase | Natural Retention | The number of weeks since the last purchase. | Y
Avg Weeks Between Purchases | Natural Retention | The average weeks between purchases. | Y
Current Status Date Date | Natural Retention | The date the current status was calculated - based on the comparison of weeks since last purchase and the average weeks between purchases. | Y
Status | Natural Retention | The status of the point of distribution. | Y
Quantity | Natural Retention | The total lifetime quantity of the product shipped to the given store. | N
Purchases | Natural Retention | The lifetime total number of purchase orders placed for the product at the given store. | N
Total Chargeback Dollars | Natural Chargebacks | The total dollar amount that went to chargebacks for the selected period. | Y
Chargeback % of Sales | Natural Chargebacks | The percentage of your sales that went to chargebacks. If no calculation appears, it is because the chain is confidential and we do not have sales for confidential chains. Sales are required to calculate percent of sales. | N
Number of Invoices | Natural Chargebacks | The number of invoices with chargebacks in the selected period. | N
Arranged by Vendor | Natural Chargebacks | This category is for ongoing deals (EDLPs, CLPs, etc.) that are sent to UNFI by the broker or retailer. | N
Shelf Sales | Natural Chargebacks | This category is for customer-specific discounts that run for about a month and are submitted directly to UNFI by the supplier or broker. This category does not include customer-specific OI discounts. | N
Promos | Natural Chargebacks | This category is for monthly promotions for a store/chain of stores that are sent to UNFI by the broker or vendor. | N
Turnovers | Natural Chargebacks | This category is for one time deals for a store/chain of stores that are sent by the supplier/broker. This category also includes new item plus-outs, trade show orders, and sample orders. | N
Customer-specific Published Deal | Natural Chargebacks | This category is for special discounts published through UNFI. Customers must sign up for the specific limited-time program to receive the deal. | N
Flyer | Natural Chargebacks | This category is for UNFI circular program discounts. | N
Broker/Vendor Turnovers | Natural Chargebacks | This category is for any turnover order discounts that are written by the broker on behalf of the supplier or by the supplier themselves. | N
Opening Order | Natural Chargebacks | This category is for new store openings for retail accounts that are sent to UNFI by the broker or vendor. | N
Miscellaneous | Natural Chargebacks | This category is for miscellaneous discounts, such as closeout orders. | N
EDLP | Natural Chargebacks | This category is for customer-specific discounts submitted directly to UNFI by the supplier/broker that are all entered as MCB. This category can only include published OI discounts. | N
New Store Opening | Natural Chargebacks | This category is for special discounts given on the first case purchase as part of a new store set. | N
Ad Deal | Natural Chargebacks | This category is for customer-specific discounts that run for about a month and are submitted in spreadsheet format by retailer. This category can include customer-specific OI discounts. | N
Region | Natural Open Payables | The UNFI Natural region that the invoice or deduction is posted to. The East and West accounts are separate accounts within the same remit #. Each region pays out independently of each other. Invoices and deductions are assigned to a region based on the DC that the invoice or charge ties back to. For National deductions they may vary which region they get applied to. | N
Distribution Center | Open Payables | Identifies which DC the invoice or deduction is connected to. If no DC is listed, then the charge could be from inventory that originated from multiple DC’s or could be non-inventory related. | N
Remit To Code | Open Payables | Not all suppliers have a remit to code. This is used if you have a secondary
address that receives physical checks from UNFI, multiple brands within a remit #, or if you receive electronic payment from UNFI via ACH. This will be a 4-letter combination based on the
state and city of the address. Example: Providence, RI = RIPR. Please ensure all items are properly applied to remit codes where necessary. | N
Invoice Number | Open Payables | UNFI manually generates invoice numbers for deductions that are processed. UNFI uses the invoice number provided on supplier invoices for inventory related invoices. For a complete breakdown of the deduction codes used, see UNFI supplier support site > Supplier Deduction Key. | N
Suffix | Open Payables | The invoice suffix. A “950” code (for Conventional) and a “111” code (for Natural) means there is a pricing or quantity discrepancy noted on the invoice. Review of the specific backup would be required to determine items, quantities, prices, etc. For Conventional suppliers, this is available within ePASS. | N
PO Number | Open Payables | This is the UNFI provided Purchase Order (PO) number given to suppliers. | N
Invoice Status | Natural Open Payables | Indicates whether the invoice is done being processed.

Released = The invoice is fully processed and eligible to be paid/deducted.
Unreleased = The invoice is either still waiting for inventory to be received, or there is a pricing or quantity issue between the PO, invoice, and what was received. If you notice an Unreleased invoice status after delivery please contact your direct AP to resolve.

​Visualization glossary

​

​Column glossary

Visualization glossary

Column glossary