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 by Product
- Potential Lost Sales by DC
- Potential Lost Sales Detail
- Total Pipe by Warehouse
- Forecast vs Quantity on Hand by DC
- Weeks on Hand by DC
Potential Lost Sales
This dashboard combines UNFI's Quantity on Hand by Product by Lot by DC and 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 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 Detail
This sortable table breaks down potential lost sales in greater detail by showing by product+DC combinations.
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.
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.
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.
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 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.
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 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.