BBampaa

Lessons › Retail Supply Chain › Service and excess

Retail Supply Chain lesson

Aged stock %

Aged stock has been sitting for more than 26 weeks.

Try this lesson free →
About 5–10 minutes · no sign-up needed

The idea

Aged stock has been sitting for more than 26 weeks:

Formulas

Aged ÷ On hand × 100

Key points

Aged stockUnits that have been in stock longer than a set age, here 26 weeks.
Work it outDivide aged units by everything on hand, then multiply by 100.
Read itThe higher it is, the bigger the risk of markdowns or write-offs. Act before it ages further.

Aged stock is excess that has waited too long. Move it or mark it down before it loses more value.

Practice

Try each one in your head first, then open the answer.

1. What % of Nigeria's stock is aged?
270 ÷ 900 × 100 = 30%
2. In D3, work out the US aged %: aged units ÷ on hand, as a decimal (no × 100).
=C3/B3
3. Tap the market with the highest aged %.
30% of Nigeria's stock is over 26 weeks old.
4. Nigeria has 9 weeks of supply and 30% aged stock, while Canada is running short. What's the best action?
Move Nigeria's stock to Canada and pause Nigeria's orders

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

Try this lesson free →
About 5–10 minutes · no sign-up needed