UNFI suppliers with ClearVue subscriptions can access ClearVue-specific dashboards in Crisp. The dashboards and their visualizations are listed below, and you can quickly jump to a specific visualization by clicking these links:

Potential Lost Sales

Fill Rate

Spoilage Risk

Inventory

Potential Lost Sales

This dashboard combines Vendor Browse reports to identify where you may be missing out on sales due to low inventory.

Potential Lost Sales by Product

This 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. Right click on a bar and select "Show all" to see a breakdown of the deficit. 

Potential_Lost_Sales_by_Product.png

Potential Lost Sales by DC

Similar to the above chart, the Potential Lost Sales by DC visualization compares your UNFI demand forecast with your quantity on hand and rolls them up to the distribution center level. Hover over a bar for more information or click on a bar to filter the dashboard by that DC.

Potential_Lost_Sales_by_DC.png

Potential Lost Sales Detail

This sortable table breaks down potential lost sales in greater detail by showing by product+DC combinations.

Potential_Lost_Sales_Detail.png

Total Pipe by Warehouse

This chart compares your weekly forecast and with your total warehouse pipe (cases on hand and on order). Right click on a bar to see a breakdown by product.

Total_Pipe_by_Warehouse.png

Forecast vs Quantity on Hand by DC

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, scroll up to review the Total Pipe by Warehouse visualization to see how much is on order.

Forecast_vs_Quantity_on_Hand_by_DC.png

Weeks on Hand by DC

This chart presents another view of your supply chain. To come up with the number of weeks on hand, we've taken your on hand quantities by DC and then divided them by your weekly forecast. Weeks of pipe is calculated similarly, adding on order quantities to your on hands to show how many weeks you could go without any more orders. 

Weeks_on_Hand_by_DC.png

Fill Rate

Using UNFI's Weekly Supplier Service Level report, this dashboard displays information that helps you hone in on your level of service to distribution centers and areas where you may be over or under-shipping.

Fill Rate by Product, DC

These visualizations display your fill rate percentages by both product and distribution center. Hover on a bar for the exact percentage or click to filter the dashboard by product or DC.

Fill_Rate_by_Product.pngFill_Rate_by_DC.png

Fill Rate by Product by DC

The sortable Fill Rate by Product by DC table delves into greater detail, providing both service dates and information on whether or not an order was promo or non-promo. By filtering by promo type, you can gain a better sense of UNFI's ordering patterns and how those can affect your fill rate. 

Fill_Rate_by_Product_by_DC.png

Spoilage Risk

In this dashboard, Crisp provides ClearVue subscribers with insights into what products at which DCs are at risk of expiring, an issue which can contribute to both food and financial waste.

Spoilage Risk by Product, DC

Hover for more details into how many wholesale dollars are at risk for a given product or with a specific DC. For a warehouse with an especially high dollar amount at risk, you may want to click on it to filter the dashboard by that DC and identify products on its shelves that need to move quickly.

Spoilage_Risk_by_Product.pngSpoilage_Risk_by_DC.png

Spoilage Risk Detail

Click the headers in this table to sort your products by expiration date, weeks to expiration, weeks on hand by lot, and wholesale dollars at risk by lot. For aberrant or unexpected figures, we recommend contacting UNFI or the individual distribution center.  Spoilage_Risk_Detail.png