BBampaa

Lessons › Retail & Allocation › Put it together

Retail & Allocation lesson

Monday morning report, part 2

The stock story: what to buy, what to clear

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

Key points

Headline firstHow the stock is doing, all together: sell-through, weeks of cover, turnover and GMROI.
Then the whyWhich category holds cash it shouldn't: slow turns, gaps on the shelf, price cuts, a forecast off target.
Then the actionWhat to buy less of, what to clear, and how much budget is left.

The store report says how we sold. The stock report says whether we bought the right stock.

Practice

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

1. In J2, total the sales across all five categories.
=SUM(B2:B6)
2. In J3, work out the gross margin $ for all five categories together.
=J2-SUM(C2:C6)
3. In J4, work out the stock turnover for all five categories together.
=SUM(C2:C6)/SUM(D2:D6)
4. In J5, work out the GMROI for all five categories together.
=J3/SUM(D2:D6)
5. In J6, work out the markdown % for all five categories together, as a decimal (no × 100).
=SUM(E2:E6)/J2

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