Question: Week 1:** - Projected Inventory = Opening Inventory MPS - max(Forecast, Orders) - Projected Inventory = 250 300 - max(190, 198) - Projected Inventory =
Week 1:** - Projected Inventory = Opening Inventory MPS - max(Forecast, Orders) - Projected Inventory = 250 300 - max(190, 198) - Projected Inventory = 250 300 - 198 = 352 units - ATP = Projected Inventory - Backlog - ATP = 352 - 0 = 352 units **Week 2:** - Projected Inventory = Previous Week's Projected Inventory MPS - max(Forecast, Orders) - Projected Inventory = 352 300 - max(200, 156) - Projected Inventory = 352 300 - 200 = 452 units - ATP = Projected Inventory - Backlog - ATP = 452 - 0 = 452 units **Week 3:** - Projected Inventory = Previous Week's Projected Inventory MPS - max(Forecast, Orders) - Projected Inventory = 452 300 - max(205, 150) - Projected Inventory = 452 300 - 205 = 547 units - ATP = Projected Inventory - Backlog - ATP = 547 - 0 = 547 units **Week 4:** - Projected Inventory = Previous Week's Projected Inventory MPS - max(Forecast, Orders) - Projected Inventory = 547 150 - max(200, 0) (No order data for week 4, so we consider it as 0) - Projected Inventory = 547 150 - 200 = 497 units - ATP = Projected Inventory
Step 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
