Lessons › Retail & Allocation › Channels and launches
Retail & Allocation lesson
Colours and SKUs
Sell-through, colour by colour, after four weeks.
Try this lesson free →The idea
Sell-through, colour by colour, after four weeks:
Formulas
Sold ÷ ReceivedKey points
By colourBlack: 240 ÷ 300 = 0.8, so 80%.
Chase the winnersSend the next delivery where it sells: Black and Blue.
Stop the slow onesSend no more Red. Move it, or plan a markdown.
A strong product can hide a colour that isn't selling.
Practice
1. In D3, work out White's sell-through, as a decimal (no × 100).
=C3/B32. What is Red's sell-through?
40 ÷ 200 = 0.2, so 20%3. Tap the colour that should get more of the next delivery.
Black sold 80% of its stock.4. Red has 160 units left and is selling slowly. What should the allocator do?
Send no more Red, and move what's left to the stores where it sellsLearn 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 →