BBampaa

Lessons › Retail & Allocation › Channels and launches

Retail & Allocation lesson

End of season

Extra stock is what a store holds beyond what it will sell before the season ends.

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

The idea

Extra stock is what a store holds beyond what it will sell before the season ends:

Formulas

Stock − Weekly sales × Weeks left

Key points

What it will sellHalifax: 2 a week × 4 weeks = 8 units.
Extra stockHalifax: 30 − 8 = +22 spare. Toronto: 20 − 40 = −20, room for 20.
Pull it togetherSend spare stock where it will sell, so fewer markdowns are needed.

Whatever is still left at the end gets marked down.

Practice

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

1. Halifax holds 30 units and sells 2 a week, with 4 weeks left. How many extra units does it have?
30 − 2 × 4 = 22 units
2. There are 4 weeks left. In D6, work out Calgary's extra stock.
=B6-C6*4
3. Tap a store that should send stock to another store.
Halifax, Calgary and Montreal hold more than they'll sell.
4. The three senders have 39 spare units. Toronto and Vancouver can take 26. What happens to the other 13?
Mark them down in the stores that hold them

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