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

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.

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.

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.

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.

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.

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. 

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.

This is the UNFI provided Purchase Order (PO) number given to suppliers.

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.

This is typically the date the supplier creates and sends UNFI an invoice. UNFI acknowledges what is listed on the invoice. A deduction invoice date is typically around the date of performance.

The date UNFI would need to pay the invoice by to subtract the terms discount dollar amount. This is based on the details within the Supplier Agreement.

The date UNFI would be expected to make full payment for an inventory
invoice. This is determined by the agreed upon terms within the Supplier Agreement. The due date would also indicate when a deduction would be eligible to be factored into a payment.

The dollar amount listed on the invoice or deduction.

The dollar amount eligible to be subtracted from the invoice amount if paid within the previously agreed upon terms.

The total Invoice Amount minus the Total Terms Discount.

Indicates whether the purchase order is open or if it has been received.

The purchase order number.

The distribution center code.

The product identification code.

The original purchase order quantity.

The revised purchase order quantity.

The date the purchase order was created.

The requested delivery date.

The original estimated time of arrival date.

The revised estimated time of arrive date.

The date on which the delivery appointment is scheduled.

The date when goods physically arrive at the destination country or port.

The date when goods are officially checked in and accepted at the final destination.

The updated date when a shipment is scheduled to be picked up.

The quantity received in the shipment.

The total dollar amount of the purchase order.

A temporary discount or promotion applied directly to the invoice at the time of billing.

The price of a particular line item on the purchase order.

The shipment weight (in pounds).

The shipment delivery method (e.g., pickup or delivered).

The number of master cases (the outer carton used to group multiple units of a product for shipping) for the purchase order.

The buyer who placed the purchase order.

The address from which the order shipped.

The city from which the order shipped.

The state from which the order shipped.

The zip code from which the order shipped.