Projects·Project·Lesson 60 of 62Pro
Café stock: what to reorder
A closing project, using what the course has covered.
What you’ll do
A café’s stock count. Each item has a reorder level, a unit cost and how many sold in the last 30 days. Decide what to order and what’s sitting on the shelf.
The steps
4 steps- 1In F2, show "Reorder" if the stock is at or below its reorder level, otherwise "OK". Fill it down to F12.
- 2In G2, work out what the stock of that item is worth: how many are in stock times the unit cost. Fill it down to G12.
- 3In J2, total the value of everything in stock.
- 4In J4, list the slow sellers: items that sold fewer than 5 in the last 30 days.
Project locked
Unlock the other 44 lessons for $49.99
Pro opens every drill, practice set, scenario, project and section review. One payment, yours to keep.