rotation stock
Tracking stock without complicated software
Three columns are enough to know what to restock and what to drop. The method fits on one sheet.
The three useful columns
Reference, units sold this month, units remaining. Nothing else is needed to make good buying decisions.
What those three numbers reveal immediately: what sells fast and runs out, and what has been sitting for three months.
The reorder threshold
Calculate units sold per week, multiply by the lead time in weeks, add a margin. That gives the level at which to reorder.
Without that calculation you order either too late — losing sales — or too early, tying up cash.
Deciding to drop a reference
A reference that has not moved in three months occupies space and money. Clearing it to recover cash beats hoping to sell it at full price in six months.
The space freed goes to doubling a reference that turns — the only trade-off that genuinely raises revenue.
Comments
Be the first to comment.
