Rank what you hold
1-2 hours
Sort SKUs by annual movement multiplied by unit cost. The top band is usually a small share of lines and most of the value; the tail is most of the lines and very little value. That distribution is what makes rolling counts affordable.
- A workable starting split: top band counted monthly, middle quarterly, tail annually.
- Add anything with a history of shrinkage or repeated variance to the top band regardless of value.
- Count new lines in their first month; early errors compound.
Pitfall
Ranking by value alone puts a cheap fast-moving consumable in the annual tier, where it will quietly drift all year and oversell every month.