Crisp's Inventory dashboards provide distribution center (DC) inventory data to help you easily pinpoint areas where inventory is too low or too high and identify which distribution centers are well-stocked for a promotion. The Inventory dashboard is divided into three sections:

  • Overview: See a snapshot of your inventory status and what's at risk.
  • Drivers: Understand the events that contribute to your inventory levels.
  • Details: Dig in to granular information that helps you take action when there's a mismatch between supply and demand.

Note: 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


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. 


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. 



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


The Current Inventory table provides an overview of what's on hand, what's on purchase order, and what's on sales order.



Note: The Weeks of Supply (WOS) metric is calculated as follows: 


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


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 Details table at the bottom of the dashboard provides more granular product and distribution center 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.