Basic Functions
Intermediate
Capstone: work out the pallet split
Whole cases, loose units, and a price rounded up to a sane number.
Task:
Stock comes in cases of 24. For each order work out how many complete cases it fills in column C, how many loose units are left over in column D, and in column E the discounted price — 85% of the unit count — rounded up to the next multiple of 5.
Learning Objectives:
- Pair QUOTIENT with MOD
- Round up to a multiple with CEILING
- Choose a rounding direction on purpose
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Order | Units | Full cases | Loose | Rounded price |
| 2 | P-1 | 100 | |||
| 3 | P-2 | 250 | |||
| 4 | P-3 | 73 |
What this exercise teaches (contains the answer)
QUOTIENT and MOD are two halves of the same division, which is why they always appear together in packing and scheduling work. CEILING rather than ROUND matters commercially: rounding a price down gives the margin away, and a warehouse would rather quote 215 than 212.50.