UNFI Insights glossary

Description

The total number of cases shipped in the selected time period.

The total number of cases shipped during the same time period in the year prior to the selected period year.

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

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

The product sales in dollars for the selected time period.

The product sales in dollars for the same time period the prior year.

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)

A code that helps identify products that do not have a UPC, such as fresh products.

The store source number.

Provides the total pounds to help you track variable weight products. 

The average number of units sold per store per week in the same time period in the year prior.

The average number of units sold per store per week in the selected time period.

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.

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.

The average dollars sold per store per week in the same time period in the year prior.

The average dollars sold per store per week in the selected time period.

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.

The number of unique store/product combinations with sales for the same period in the prior year.

The number of unique store/product combinations with sales for the selected period.

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

The amount, in dollars, of on hand inventory for the selected period.

The number of on hand inventory units for the selected period.

The dollar value of inventory on order for the selected period.

The number of inventory units on order for the selected period.

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.

The average dollars on hand based on the prior period (e.g., Last 8 weeks) selected in the Weeks of Supply Lookback Period filter.

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.

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.

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.

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.

The number of distribution centers stocking the product.

The forecasted weekly product demand (in units as sold to UNFI- either cases or eaches).

The forecasted weekly product demand (in dollars).

The average wholesale price.

The product expiration date for a given product lot.

The number of weeks until the product lot reaches its expiration date.

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.

The sales volume for your products over the selected time period.

The change in sales volume (in units) from the prior year. Calculated as: sales volume selected period - sales volume from same period prior year.

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

The category sales volume for the selected time period.

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.

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

The number of stores selling products in your category.

The number of stores selling your products.

The percentage of stores selling your product out of stores that sell products in your category.

The percentage of potential points of distribution (i.e., product/store combinations) in your category that you currently distribute to.

The number of units sold in the selected period.

The date of the first sale in the selected period.

The number of chains that sell your product.

The number of cases shipped in the selected period.

The average number of cases shipped based on the past 14 days.

The sales dollars for the selected period.

The total number of units you are short of the forecasted demand.

The total wholesale dollar value of units you are short of the forecasted demand.

The first date of the week when the PO was supposed to land.

Indicates if the product was distributed for promotional purposes or not.

The quantity received in the shipment.

The quantity submitted to revise the original quantity ordered on the purchase order (if no changes, the number will reflect the quantity originally ordered).

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.

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).

The total sales for new points of distribution.

The average weekly sales for new points of distribution.

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.

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.

An estimate of the sales dollars you will lose in the selected period due to points of distribution at risk or lost.

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.

The date of the first sale of all time for the product at the given store.

The date of the most recent purchase of the product at the given store.

The number of weeks since the last purchase.

The average weeks between purchases.

The date the current status was calculated - based on the comparison of weeks since last purchase and the average weeks between purchases.

The status of the point of distribution.

The total lifetime quantity of the product shipped to the given store.

The lifetime total number of purchase orders placed for the product at the given store.

The total dollar amount that went to chargebacks for the selected period.

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.

The number of invoices with chargebacks in the selected period.

This category is for ongoing deals (EDLPs, CLPs, etc.) that are sent to UNFI by the broker or retailer.

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.

This category is for monthly promotions for a store/chain of stores that are sent to UNFI by the broker or vendor.

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.

This category is for special discounts published through UNFI. Customers must sign up for the specific limited-time program to receive the deal.

This category is for UNFI circular program discounts.

This category is for any turnover order discounts that are written by the broker on behalf of the supplier or by the supplier themselves.

This category is for new store openings for retail accounts that are sent to UNFI by the broker or vendor.

This category is for miscellaneous discounts, such as closeout orders.

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.

This category is for special discounts given on the first case purchase as part of a new store set.

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.