COGS divided by average inventory value. Below 2x annualised signals slow-moving stock.
At a glance
| What it counts | Annualised COGS / Average Inventory Value. Computed off 90-day rolling window. |
| Tax treatment | n/a (ratio). |
| Currency | Reporting Currency. |
| Time window | 90D |
| Alert trigger | <2 for stocked-products |
| Sentiment key | inv_turnover |
| Roles | owner, finance |
Calculation
Calculated automatically from your Microsoft Dynamics 365 data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
US distributor, annualised COGS 5.4M = 10.7x turnover. Healthy for electronics (benchmark 8-12x). Apparel typically 4-6x; food 12-20x.Sibling cards merchants should reference together
| Card | Why pair |
|---|---|
| Total COGS | Numerator. |
| Total Inventory Value | Denominator. |
| Dead Stock Value | What is not turning. |
| Inventory Carrying Cost | Cost of slow turn. |
Reconciling against the vendor’s own dashboard
Where to look in Business Central:Power BI > Inventory Performance > Turnover tile Manual: Income Statement COGS / Inventory Valuation reportWhy may differ:
| Reason | Direction | Why |
|---|---|---|
| Window selection | Either | 90D rolling vs annual |