What it measures
% of total inventory value written off as expired or obsolete
it measures the financial outcome of forecasting, production, and inventory decisions made weeks or months prior. The cash is already lost when the write-off is booked.
Business impact
- Triggers a 'chaos tax' of unplanned disposal logistics, regulatory paperwork for destruction, and management time spent on inventory reconciliations instead of forward-looking planning.
- Shipping short-dated stock to avoid write-offs puts the business in the commercial red zone, triggering retailer SLA breach penalties and formal performance reviews—the final step before delisting.
Formula
Write-off value / Total inventory value x 100Grain
One row per material per batch per storage location per day
Inside the Implementation Pack
A preview of what's actually built for this KPI — extracted from the real Implementation Pack, not a mockup.
This is the primary ratio the pack's other measures build on — trend, rank, and period-comparison variants, all on Fact_Inventory_Snapshot. It guards against missing dates and values with NOT ISBLANK checks.
Fact_Inventory_Snapshot— 8 mandatory columns — inventory value blocked, storage location key, ...Dim_Batch— batch_key + batch_nbrDim_Material— material_key + material_descriptionDim_Plant— key + nameDim_Storage_Location— key + nameDim_Warehouse— key + nameDim_Date— Auto-generated calendar table — no customer data required
Full field-by-field data contract, in 4 SQL dialects (SQL Server, Snowflake, Databricks, BigQuery), ships in the pack.
| Target | 0.001 — performance considered compliant at or below this line |
| Warning | 0.01 — amber alert — triggers a review |
Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.
Everything you need to build Spoilage & Obsolescence Rate in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.