Periodic Review & Min–Max Inventory Policies: Review Periods, Order-Up-To Levels, Pipeline Stock, a 52-Week Simulation & Joint Replenishment
Run inventory the way many shops and warehouses do, with a check every week or month: set order-up-to levels, min–max rules and review periods, track on-hand, on-order and pipeline stock through a 52-week simulation, measure fill rates and stock-outs, and group a supplier's items into one combined order, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course runs the stock of a fictional office-supply wholesaler with a check every week or month. You compare continuous (s,Q), periodic (R,S) and min–max (s,S) policies, set order-up-to levels from demand over R + L plus safety stock with an XLOOKUP service factor and CEILING to case packs, choose the review period from ordering and holding cost, calculate the inventory position with on order and backorders, complete a 52-week simulation with arrivals after the lead time and a line chart, measure stock-out weeks, fill rate and average stock, tune six min–max settings with MINIFS and build a joint order for one supplier with a minimum order value.
Lessons
- Three Ways to Reorder: Continuous (s,Q), Periodic (R,S) and Min–Max (s,S) Pro
- The Order-Up-To Level: Demand Over R + L Plus Safety Stock Pro
- Choosing the Review Period: Ordering Cost Against Holding Cost Pro
- Inventory Position: On Hand + On Order − Backorders, and the Order at Each Review Pro
- A 52-Week Simulation: Arrivals After the Lead Time, Net Stock and the Pipeline Pro
- Service Measures: Stock-Out Weeks, Fill Rate and Average Stock Pro
- Tuning Min–Max: Cost Versus Service for Six (s,S) Settings Pro
- Joint Replenishment: One Supplier, a Common Review Day and a Minimum Order Value Pro