Question: excel page is shown B D E F H K 744 2 3 4 5 Management Instructions Beginning Inventory Safety Stock Lot Size 1,800 7

excel page is shown excel page is shown B D E F H K 744 2 3 4 5
excel page is shown B D E F H K 744 2 3 4 5
excel page is shown B D E F H K 744 2 3 4 5
B D E F H K 744 2 3 4 5 Management Instructions Beginning Inventory Safety Stock Lot Size 1,800 7 Period 3 5 6 7 6 Master Production Schedule 1 2 355 400 Customer Orders 383 381 8 640 Demand 8 425 440 475 500 600 389 400 355 395 245 9 10 163 Projected On Hand Inventory (POHI) 11 (at the end of the period) Master Production Schedule 12 Available To Promise (1-period look ahead) 13 14 15 16 17 18 10 Question 20 (20 points) Download Q7 (Excel download) and perform the necessary calculations. Then enter selected values below. What is the POHI value for Period 2? A What is the POHI value for Period 4? What is the POHI value for Period 8? What is the MPS for Period 2? What is the MPS for Period 5? AY What is the MPS for Period 6? What is the ATP for Period 1? What s the ATP for Period 4? What is the ATP for Period 7? What is the MPS for Period 8? 28 w PO DOO 80 F3 FT # A * $ 4 3 % 5 6 & 7 8 8 9 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!