COGS divided by average inventory value. Below 2x annualised signals slow-moving stock.
At a glance
Annualised COGS divided by average inventory value. Below 2x signals slow-moving stock.
| What it counts | Annualised_COGS / Average_Inventory_Value over 90D window. |
| Currency | Reporting ledger. |
| Time window | 90D |
| Alert trigger | <2 for stocked-products |
| Sentiment key | inv_turnover |
| Roles | owner, finance |
Calculation
Calculated automatically from your Oracle ERP Cloud data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US Fortune 500 retailer.| Value | |
|---|---|
| Annualised COGS | $1,400,000,000 |
| Average inventory | $277,000,000 |
| Turnover | 5.05x |
- 5x is healthy for retail. Above the 2x alert.
- B2B distribution targets 4-8x.
- Falling turnover = aging inventory.
- Pair with Inventory Aging.
- Per-category drill reveals which lines are slow.
Sibling cards merchants should reference together
| Card | Why pair |
|---|---|
| Total Inventory Value | Denominator. |
| Total COGS | Numerator. |
| Inventory Aging | Cause of low turnover. |
Reconciling against the vendor’s own dashboard
Where to look in Oracle ERP Cloud:OTBI → Inventory + Cost Management Real Time custom analysisCross-connector reconciliation: Internal Oracle metric.