Request: The replenishment planner must explain why two supplier lead-time models produce different buffers. Build fixed-lead-time safety stock, independent variable-lead-time safety stock and reorder points. The six-sheet deliverable preserves units and assumptions for both product families.
Data: six linked worksheets contain original fictional quantities and cost assumptions. Each completed sheet stays in your workbook as you move to the next task.
Done: all six results pass, with the final numerical finding checked.
The replenishment planner must explain why two supplier lead-time models produce different buffers. Build fixed-lead-time safety stock, independent variable-lead-time safety stock and reorder points. The six-sheet deliverable preserves units and assumptions for both product families.
You work on Pine Harbor Distribution's fictional planning file. Before calculating, check the time period, the unit and which business event each input records. Keep those definitions in the workbook so another analyst can reproduce the result. The first task gives you the steps. Later tasks use new quantities, a boundary case and a handoff to another planner. Your answer is recalculated on a second copy of the inputs, so enter a formula rather than a number copied from the example.
With independent daily demand and a fixed lead time, safety stock is z times daily demand standard deviation times the square root of lead-time days. The square root adds variances over time. The normal approximation assumes a stable process; it is not a service guarantee for intermittent demand. The formula stays linked to the inputs when quantities change.