Question: Please provide excel formulas to solve. 1 2 3 4 5 50 50 85 50 110 Question 11.18 DC A: Transit Time=2, Q=100 1 Gross

Please provide excel formulas to solve.
1 2 3 4 5 50 50 85 50 110 Question 11.18 DC A: Transit Time=2, Q=100 1 Gross Requirements In Transit Projected Available Planned Order Release 100 75 2 3 4 5 1 120 110 115 100 105 200 50 DC B: Transit Time=1, Q=200 Gross Requirements 3 In Transit Projected Available O Planned Order Release 1 2 CDC: Lead Time=2, Q=500 3 Gross Requirements 4 In Transit 5 Projected Available 6 Planned Order Release 1 2 3 4 5 400 1 2 3 4 5 50 50 85 50 110 Question 11.18 DC A: Transit Time=2, Q=100 1 Gross Requirements In Transit Projected Available Planned Order Release 100 75 2 3 4 5 1 120 110 115 100 105 200 50 DC B: Transit Time=1, Q=200 Gross Requirements 3 In Transit Projected Available O Planned Order Release 1 2 CDC: Lead Time=2, Q=500 3 Gross Requirements 4 In Transit 5 Projected Available 6 Planned Order Release 1 2 3 4 5 400Step 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
