At present, there are 60 units of an end item in inventory. Order policy is fixed...

        

Transcribed Image Text:

At present, there are 60 units of an end item in inventory. Order policy is fixed at 125 units. Complete the MPS record in the Figure below for this end item. (Use a replicate of the Table presented below, fill it out, then respond to all the following questions related to this MPS Table) Item: A / Order Policy: 125 units Lead Time: 1 week Quantity On Hand: 60 Forecast Customer orders (booked) Projected on-hand inventory. MPS quantity 1 10 15 2 15 10 3 20 14 4 30 10 5 40 5 Week 6 60 10 7 80 5 8 120 10 9 120 5 10 120 5 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start Available-to- promise (ATP) inventory 10 15 15 Answer 10 20 14 30 10 What is the projected on-hand inventory in Week 1? Your Answer: 40 5 60 10 80 5 120 10 120 5 120 5 What is the projected on-hand inventory in Week 4? Your Answer: Answer What is the projected on-hand inventory in Week 6? Your Answer: Answer What is the projected on-hand inventory in Week 9? Your Answer: Answer What is the MPS quantity in Week 5? Your Answer: Answer What is the MPS quantity in Week 7? Your Answer: Answer What is the MPS start in Week 3? Your Answer: Answer What is the MPS start in Week 5? Your Answer: Answer At present, there are 60 units of an end item in inventory. Order policy is fixed at 125 units. Complete the MPS record in the Figure below for this end item. (Use a replicate of the Table presented below, fill it out, then respond to all the following questions related to this MPS Table) Item: A / Order Policy: 125 units Lead Time: 1 week Quantity On Hand: 60 Forecast Customer orders (booked) Projected on-hand inventory. MPS quantity 1 10 15 2 15 10 3 20 14 4 30 10 5 40 5 Week 6 60 10 7 80 5 8 120 10 9 120 5 10 120 5 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start Available-to- promise (ATP) inventory 10 15 15 Answer 10 20 14 30 10 What is the projected on-hand inventory in Week 1? Your Answer: 40 5 60 10 80 5 120 10 120 5 120 5 What is the projected on-hand inventory in Week 4? Your Answer: Answer What is the projected on-hand inventory in Week 6? Your Answer: Answer What is the projected on-hand inventory in Week 9? Your Answer: Answer What is the MPS quantity in Week 5? Your Answer: Answer What is the MPS quantity in Week 7? Your Answer: Answer What is the MPS start in Week 3? Your Answer: Answer What is the MPS start in Week 5? Your Answer: Answer