BBampaa

Lessons › Retail & Allocation › Channels and launches

Retail & Allocation lesson

Plan mix vs what sold

How the buyer split the order, next to what customers actually bought.

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

The idea

How the buyer split the order, next to what customers actually bought:

Formulas

Colour sold ÷ All sold
Share of sold − Plan mix

Key points

Plan mixHow the buyer split the order: 40% Black, 35% Navy, 25% Sage.
Share of soldBlack: 490 ÷ 1,000 = 0.49.
The gapBlack: 49% − 40% = +9 points, so it was under-bought.
Next orderMove the next buy towards what sold, then check again after a few weeks.

Plus means under-bought, minus means over-bought. The gap is what turns a sell-through report into a buying decision.

Practice

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

1. In D2, work out Black's share of what sold, as a decimal (no × 100).
=C2/C5
2. Sage made 18% of sales against a 25% plan. By how many percentage points did it fall short?
25% − 18% = 7 points short
3. Tap the colour the buyer under-bought.
Black sold 49% against a 40% plan.
4. The buyer is placing the next order of 2,000 units. What split do you suggest?
About 50% Black, 33% Navy and 17% Sage: closer to what customers bought

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