Safety stock and reorder point planner

The brief

Too little stock loses sales and too much ties up cash. Using retail sales history, work out demand variation and lead time for each product, set reorder points and order sizes for a service level, and test the policy by simulation. Good looks like: service levels reached in simulation, cash tied up compared with the old rule, and different policies for fast and slow items.

What you will build

1. Load daily sales history for 50 products
2. Measure average demand and its variation
3. Set lead times and a service level
4. Calculate safety stock, reorder point and order size
5. Simulate a year under the policy
6. Compare cash and stock-outs with a fixed-weeks rule

Free, open data to build it with