D01 Inventory Overview

The Inventory Overview dashboard provides a quick look at the state of inventory at the selected facilities.

Filters

The filter pane for this dashboard includes the following filters.

  • Seller Name
  • Facility Name

  • Channel (B2B, EB2C)

  • SKU Category

Data Items

Total On-Hand Units

The total number of units in inventory.

Unique SKU Count

The total number of unique SKUs in inventory.

Total On-Hand Value

The monetary value of all units in inventory.

Inventory Aging Summary

This table shows inventory aging data, summarized in four age categories.

Two summary views are offered, based on two different methods of calculating aging for an inventory unit.

  • Click Aging by Last Ship Date to view inventory aging with the ship date taken as day 0.
  • Click Aging by Last Receive Date to view inventory aging with the receive date taken as day 0.

Column

Description

Age Bucket

A category of inventory by aging.

SKU Count

The number of SKUs in this age bucket.

SKU Count%

The percentage of total SKUs that are in this age bucket.

Unit Count

The number of units in this age bucket.

Unit Count%

The percentage of total units that are in this age bucket.

Value

The monetary value of units in this age bucket.

Value%

The percentage of total monetary value that is in this age bucket.

Inventory Pareto – Unit Count%

This line and bar graph groups SKUs into ten deciles, from largest inventory quantity (the 10% group) to smallest inventory quantity. The line, graphed against the percentage scale on the left, shows the cumulative portion of inventory units for each decile. For example, the second line point shows the portion of units for the top 20% of SKUs.

Bars show the number of unique SKUs that are included in each cumulative decile level. Bars are graphed against the numeric scale on the right side of the graph.

Cycle Count

The Cycle Count section display information about cycle count inventory auditing in the selected facilities.

You can view cycle count information for a 6-, 12-, or 18-month period. To change the time period, make a selection in Select Cycle Count Period, and click Apply.

To change the selection of facilities, use the filters sidebar.

Cycle Count Avg. Accuracy%

These three measures show cycle count accuracy. They are calculated by comparing the actual count from cycle count activity against the expected count.

  • Net Unit Accuracy%: An overall measure of unit count as compared to expectations, in which the total number of units is expressed as a percentage of the expected total. In this measure overages of some items are offset against shortages of other items.
  • Absolute Unit Accuracy%: A stricter measure of unit count accuracy, in which the absolute value of overages and shortages are summed together as a percentage of the total expected count and subtracted from 100%, where 100% represents a perfectly accurate count.
  • Absolute Location Accuracy%: The percentage of locations where the expected count of units matched the actual count.

Cycle Count Accuracy%

This bar chart shows the month-by-month trend for Net Unit Accuracy%, Absolute Unit Accuracy%, and Absolute Location Accuracy%.