BBampaa

Lessons › Retail & Allocation › Allocation and merchandising

Retail & Allocation lesson

Presentation minimums

Every store needs at least 12 phone cases on display, however slowly it sells. Here's what each store sells, holds, and needs for 2 weeks.

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

The idea

Every store needs at least 12 phone cases on display, however slowly it sells. Here's what each store sells, holds, and needs for 2 weeks:

Formulas

Min − Stock

Key points

Presentation minimumThe fewest units a store needs for its display to look full.
Top-upHow many to send to reach it.
Send the biggerSend whichever is bigger: what sales need, or the top-up.

Small stores still need a full display: the minimum comes first, then sales decide the rest.

Practice

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

1. In D5, work out Halifax's top-up to the display minimum.
=C5-B5
2. In D5, work out how many to send Halifax: the bigger of its sales need (B5) and its top-up (C5).
=MAX(B5,C5)
3. Each store gets the bigger of its sales need and its top-up. How many phone cases go out in total?
20 + 16 + 18 + 8 + 6 + 14 = 82 units
4. Tap a store that gets more because of the display minimum than its sales alone would earn.
Halifax and Calgary: their top-ups (8 and 6) are bigger than their sales needs (2 and 4).
5. The buyer asks why Halifax got 8 phone cases when it sells 3 a week. What's the best answer?
Its display needs 12 to look full. With only 4 on hand, it would hardly sell at all

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