1
Pick an item
Demand is for an imagined cluster of about 1,500 sites
Data card
2
Build the sheet
Type into the yellow-bordered cells. Formulas start with =
Your checklist
Name box: click a cell, then type a name in the box at the top left and press Enter to name it, for example D for annual demand. Type a cell address such as B10 and Enter to jump to it. Names are not case sensitive.
3
Your policy, in pictures
Each picture unlocks as you finish its steps
Demand during lead time and the service level
Stock over time: order quantity, reorder point, safety stock
Total cost curve, from your data table
4
Test two service levels
Task: change the service level in B8, then log the result
Set B8 to one service level, for example 90%, and press Log. Then set it to another, for example 99%, and log again. Compare what the extra service costs in safety stock.
5