Crisp's Advanced dashboards provide extra analytics that help brands succeed with particular retailers and distributors. This article focuses on Crisp's KeHE inventory dashboard and its three sections: "Overview," or what's going on (and what's at risk) with your inventory; "Drivers," or the events contributing to your inventory levels; "Details," or granular information you can act on when inventory is running low.

It's important to note that new SKUs will need to be in distribution for a month and appear in KeHE's Full POD Vendor Report in order to have accurate information in the inventory dashboard.  

Quickly jump to a specific visualization by clicking the links below.

Inventory by Product (Top 20)
Inventory by DC
Total Units, Dollars on Hand
Current Inventory
Current Inventory
Quantity on Hand by DC (map)
Quantity on Hand by DC (table)
Quantity on Hand by Code Date
Inventory at Risk
Inventory Detail

Inventory Overview

Inventory by Product (Top 20)

This pie chart breaks down inventory levels for your top 20 products. Hover over a slice for an on-hand number or click to filter the dashboard by that product. 

Inventory_by_Product__Top_20_.png

Inventory by DC

The Inventory by DC pie chart shows which distribution centers your products are in. The chart changes when other filters are applied, and you can also right click on a slice to drill down into that distribution center by product. 

Inventory_by_DC_Drill_Down.png

Total Units, Dollars on Hand

These tiles, which update with your filters, show the total units and dollar value of your on hands.

Total_Units__Dollars_on_Hand.png

Current Inventory

The Current Inventory table provides an overview of what's on hand, what's on purchase order, and what's on sales order. By scrolling down further, you'll enter the Drivers section of the dashboard, which offers deeper insights into these figures. 

Current_Inventory.png

Inventory Drivers

Quantity on Hand by DC (map)

This map of your distribution centers visualizes your on hands, with green icons representing centers that have 10 weeks or more of supply on hand. Hover over an icon for inventory details or click to filter the dashboard by that distribution center. 

Quantity_on_Hand_by_DC.png

Quantity on Hand by DC (table)

Corresponding with the above map, the Quantity on Hand by DC table offers a sortable breakdown of your inventory by distribution center.

Quantity_on_Hand_by_DC__Table_.png

Quantity on Hand by Code Date

The Quantity on Hand by Code Date table provides a snapshot of your inventory and how it is stocked over the year, with on hand buckets of 0-30 days, 31-60 days, and so on. This can be sorted and used for identifying which products are (or are about to be) at risk of running out.

Quantity_on_Hand_by_Code_Date.png

Inventory at Risk

When a product from the the Quantity on Hand by Code Date table leave the 0-30 days bucket, it goes to the Inventory at Risk table, which breaks down in greater detail what specific products at which specific distribution centers are at risk of expiring. Use the "Guaranteed Shelf Life Days" and "Sell By Date" columns with "Unit Sales Velocity per Day" to identify slow-moving products that may have shelf life issues before shipping. Inventory_at_Risk.png

Inventory Detail

The Detail table at the bottom of the dashboard goes another level deeper and includes contact information. Click on an individual cell to apply a cross filter (for example, clicking "6" in the "Pack" column will filter the dashboard by all of your 6-pack products).

Inventory_Detail.png