Inventory and throughput KPIs - Cargoflow Support

Summary

These KPIs tell you how much there is, how old it is, how fast it moves, and how much came in and went out. Most need the inventory module; the receipts and shipments charts need receiving and shipping. See The inventory dashboard for the operational view of the same stock.

Point-in-time snapshots

They do not use the date range and have no comparison: they always show today.

KPI	What it counts	By customer
On-hand units	Sum of stock in storage locations. Staging and cross-dock areas are not counted.	Yes
Active SKUs	Distinct products with stock in those locations.	Yes
Inventory value	Quantity × product unit cost. Needs the valuation permission. "No data" if no product has a cost.	Yes
Low stock	Products with a reorder point whose available quantity is below it.	Yes
Expiring soon	Lots with stock expiring in the next 30 days.	No
Expired	Lots with stock already expired.	No
ABC distribution	SKUs by class based on outbound over the last 90 days: A up to 80% of volume, B up to 95%, C the rest or no movement.	No
Inventory aging	On-hand units by days since first receipt: 0–30, 31–60, 61–90, over 90.	Yes
Location occupancy	Active storage locations holding stock ÷ all active ones. Occupied or free, not volume. Benchmark 90%.	No

Turns and days on hand

Turns: (units out in the range ÷ days in the range) × 365 ÷ on-hand units today. Times per year. Higher is better. Measured in units, not money.
Days on hand: on-hand units today ÷ average daily outbound in the range. How many days current stock would last. Lower is better.

Important: both use today's stock, even if you choose a range from last year. To compare old months, these two KPIs do not work: use the inventory report for that period. See Warehouse reports.

Throughput charts

KPI	What it counts	By operator
Receipts	Confirmed receipts per day, week or month.	No
Shipments	Closed shipments per period.	No
Units received	Sum of inbound stock movements.	Yes
Units shipped	Sum of outbound movements.	Yes

Shown as line or bar, with the card's grouping or the dashboard filter's. See Stock history for the movement-by-movement detail.

Worked example

Central Warehousing has 12,000 units today. In the last 30 days, 6,000 went out.

Daily outbound: 6,000 ÷ 30 = 200.
Days on hand: 12,000 ÷ 200 = 60 days.
Turns: 200 × 365 ÷ 12,000 = 6.1 times a year.
If 3,000 of those units came in more than 90 days ago, aging shows 25% in the last bucket: candidates to review with the customer.

Worth knowing

Expiring soon and expired count lots, not units.
The dashboard's client filter does not apply to expirations, ABC or occupancy: they always show the whole warehouse.
The card's zone filter only applies to on-hand units, active SKUs, value and aging.

Frequently asked questions

The client portal shows a different unit count

The portal summary counts all of the customer's stock, including staging and cross-dock areas; the KPI card only counts storage locations. Both numbers are right; they measure different things.

Occupancy is green and the warehouse is full

The occupancy benchmark is 90% with "higher is better", so an almost full warehouse turns green. If full is a problem for your operation, give the card your own target, or read it without looking at the color.