Rank products by consumption value and identify inventory priorities.
No matching tools.
Consumption value is period quantity multiplied by unit cost. Use one reporting period and currency. A product crossing a threshold stays in the preceding class; equal-value products stay together. Zero total value is rejected. This is a prioritization worksheet, not a demand forecast.
Values 1000, 200 and 20 total 1220. With 80% and 95% thresholds, the first product is A, the second B and the third C.
consumption_value = period_quantity x unit_cost