Inventory Reorder Decisions
Decide what to reorder and how much: look up lead times and minimum orders, test stock against a reorder point, size each order and total the cost by supplier.
What you will practise: Turn a reorder policy into formulas that combine lookups, a comparison, a quantity rule with a minimum, and a cost roll-up by supplier.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.