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 →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
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 units3. After rounding every store to whole packs, how many units go out in total?
(3 + 3 + 3 + 1 + 1 + 2) packs × 6 = 78 units4. 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 165. 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 stockLearn 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 →