Question: Please provide excel formulas to solve. R LT 5 days 3 days 20 per day 2 days D SS ZZ 23 Question 11.21 24 Reorder

Please provide excel formulas to solve.
R LT 5 days 3 days 20 per day 2 days D SS ZZ 23 Question 11.21 24 Reorder Period 25 Lead Time 26 Average Demand 27 Safety Stock 28 29 Target (Max) Inventory 30 DDLT+DR+SS 31 32 33 34 On Hand Inventory 35 Order Quantity 56 Demand During Lead Time Demand During Review Period Safety Stock DDLT+DR+SS 90Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
