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. 

Inventory_by_Product__Top_20_.png

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

 

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

Total_Units__Dollars_on_Hand.png

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

 

Current_Inventory.png

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

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

This table provides a monthly snapshot of how close your inventory is to reaching the code date (the date by which a product should be shipped to the store in order to have the chance to sell before expiration), with code date on hand buckets of 0-30 days, 31-60 days, and so on. This data can be sorted and used for identifying which products are (or are about to be) at risk of running out.

Note: How far the code date is from the expiration date is something typically determined by the retailer/wholesaler based on the category or other factors or is agreed upon by the supplier and retailer/wholesaler during item setup. If you have questions about this time frame for a product, please reach out to KeHE.

Quantity_on_Hand_by_Code_Date.png

Inventory at Risk

When a product has reached its code date, it goes to the Inventory at Risk table, which provides weekly data with greater detail into 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.

Inventory_Detail.png