Crisp's Retailer Waste dashboard provides metrics for tracking product waste, so you can pinpoint where waste occurs and take corrective action. Reducing waste helps you do your part to create a greener and more sustainable supply chain, as well as decreasing the profit loss associated with waste.
Note: The Retailer Waste dashboard currently only contains Walmart and Kroger data, but we will expand this dashboard to include data from additional retailers in the future.
The Crisp waste model tracks your shipments, on hand inventory, and sales units over time and counts any discrepancy as waste. For example, if you ship 100 units to a retailer and typically have 50 units in on hand inventory (for a total of 150), but only 120 units ever sell to customers, we assume 30 units were wasted. You can select filters at the top of the dashboard to refine the information shown in the visualizations. Since the model relies on historical data, we recommend analyzing waste over longer time periods, such as an entire quarter, to get the most precise picture of your waste.
Note: Though shipment data may not be available in other dashboards for a retailer, such as Kroger, we do collect shipment data from the source and use it in our waste model.
The Retailer Waste dashboard is divided into three sections:
- Overview: See a snapshot of waste metrics for your products.
- Drivers: Understand the factors that contribute to retailer waste.
- Details: Dig in to granular information that you can act on to address issues at stores and reduce waste.
To load the Retailer Waste dashboard:
From the dashboard menu, select Retailer Waste.
Overview
The Overview section provides high-level information waste metrics for your products. Use the following map of the screen to guide you.
Waste as a Percentage of Shipments
This line graph displays the percentage of your shipped product that ended up wasted over the specified time period, as well as the waste percentage for the same time period the previous year. The waste for the specified time period appears in green and the prior period's waste appears in yellow.
Waste Units
This bar chart displays your waste units over the specified time period and for the same time period the previous year, helping you track how many units were wasted and how waste trends over time.
Shipments
This line graph displays your shipments over the specified time period, providing a point of comparison for waste vs. your shipment volume.
Overview Tiles
These tiles provide high-level information about your waste performance and patterns. Once you add filters, these tiles add even more context, displaying waste totals for specific criteria. The Waste Units for prior period tile is calculated using data from the same period the previous year.
Note: The Average Confidence tile allows you to gauge the precision of the Crisp waste model data, with five being high confidence and one being low confidence. Confidence generally goes up when the time period granularity goes up (i.e., confidence is higher for an entire quarter than for a weekly time period). The Confidence filter at the top of the dashboard allows you to filter the dashboard by confidence rating at the store/product level.
Waste by Product
This sortable table updates based on your selected filters and shows your best and worst-performing products and comparison data from the previous year.
Drivers
Waste by State (heat map)
This heat map allows you to quickly observe states where waste is high versus states where there is little waste. Hover over a state to see its waste metrics, as well as the percent difference year over year.
Waste by City (table)
This sortable table provides waste data based on dimensions city to help you gauge where your waste is high and low. You can use this information to identify geographic patterns of waste, so you can mitigate waste in those areas.
Details
Details table
This table provides more store-level information to help you put your insights into action. You can click on a cell to filter the table or select the Tile actions menu (
), then select Download data to export your data to an Excel file that you can easily share with others.