Work out this order's shipping cost
Real problems with no formula named for you. You decide what to use.
This freight report lists each order's dock handler, which won't factor into the cost. Both the per-unit shipping rate and the bulk discount live on a separate "Rates" sheet. Reach over there for both, and decide whether this order's quantity clears the bulk threshold before you finish the calculation.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Order | Handler | Units | Shipping Cost |
| 2 | #712 | Dock 3 | 14 |
This is the actual sheet the case study hands you, including whatever column turns out not to matter. Figuring out what to ignore is part of the exercise.
Why this one matters
A shipping calculation that pulls both its rate AND its discount rule from a shared Rates sheet, instead of hardcoding either, is exactly how a real logistics spreadsheet keeps working when rates change.
More case studies
- Break down spending by department and category
- Flag the SKUs actually at risk
- Build a dropdown from a list that isn't all still valid
Case Studies are part of the full unlock
Case Studies are locked until you unlock the full site: real, messier problems with no function named for you, graded the same way every Practice exercise is. Open this one to see how to unlock the rest.
Open this case study →