BBampaa

Lessons › Retail & Allocation › Allocation and merchandising

Retail & Allocation lesson

Allocating by grade

You've graded your 6 stores. Now share 120 new earbuds. Every store in a grade gets the same amount, so treat each grade as one big store: add up its sales, give it its share of the 120, then split that between its stores.

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

The idea

You've graded your 6 stores. Now share 120 new earbuds. Every store in a grade gets the same amount, so treat each grade as one big store: add up its sales, give it its share of the 120, then split that between its stores.

Formulas

Grade's sales ÷ Total sales
Share × 120
Units ÷ Stores in the grade

Key points

Grade's shareWhat part of all sales a grade makes. A: 89 ÷ 179 = 0.50.
Units for the gradeIts share of the stock. A: 0.50 × 120 = 60.
Each store, roundedA: 60 ÷ 2 = 30. Round each store, then check the total is still 120.

Grades are quicker, but less exact: both A stores get 30, though Toronto sells more.

Practice

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

1. What share of sales do the B stores make, as a decimal?
59 ÷ 179 = 0.33
2. How many units does grade B get, to one decimal?
0.33 × 120 = 39.6
3. In F4, work out how many units each C store gets, rounded to whole units. The number of stores is in B4.
=ROUND(E4/B4,0)
4. Check: 2 A stores get 30, 2 B stores 20 and 2 C stores 10. How many units go out in total?
2 × 30 + 2 × 20 + 2 × 10 = 120 units
5. Rounding each grade's units first can come out one too many or too few. What's the safer way?
Round each store's amount, then check the total

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