BBampaa

Lessons › Retail & Allocation › Allocation and merchandising

Retail & Allocation lesson

Packs and rounding

Phone cases ship in packs of 6, and the warehouse doesn't open packs. So each store's need is rounded to whole packs.

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

The idea

Phone cases ship in packs of 6, and the warehouse doesn't open packs. So each store's need is rounded to whole packs:

Key points

PacksStock ships in fixed packs. You send whole packs only.
Round to packsNeed ÷ pack size, rounded to the nearest whole pack.
Balance the totalIf rounding sends more than you have, take packs back from the stores that can best wait.

Round each store to whole packs, then check the total against what's in the warehouse.

Practice

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

1. In C2, work out how many packs of 6 Toronto gets: its need rounded to the nearest whole pack.
=ROUND(B2/6,0)
2. Vancouver needs 16. How many units does it get, in packs of 6 rounded to the nearest whole pack?
16 ÷ 6 = 2.7, so 3 packs × 6 = 18 units
3. After rounding every store to whole packs, how many units go out in total?
(3 + 3 + 3 + 1 + 1 + 2) packs × 6 = 78 units
4. Rounding sends 78, but the warehouse only has 72. What do you do?
Take one pack back from a store that rounded up, like Vancouver: 18 for a need of 16
5. Halifax needs 8 to fill its display, but rounding gives it 1 pack: 6 units. What would you do?
Round Halifax up to 2 packs: its display needs the stock

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