QUESTION 4 15 points Save Answer Develop MRP records for all items needed for item F in the following product structure for product H, using the information provided in the following tables. The lead time to complete product H is one week. Master production schedule (MPS) calls for 170, 110, and 90 units of demand for period 4, 5, and 6. Pruded E (1) F (2) G (1) Planning Data F L4L L4L Q=15* 2 weeks Q=300* 2 weeks L4L 2 weeks 1 week 1 week Data Category Lot size rule Lead time Safety stock Scheduled receipts Beginning inventory 15** 25 35 None none 20 1,300 (wk 1) 20 700 (wk 1) 50 900 (wk 1) 0 30 40 "Planned order schedules must be the same or multiples of Q amount **minimum on hand (ending inventory) quantity to be observed FORMAT FOR ENTRIES: All quantities are INTEGER (120, for example). Enter 0 if you do not have quantity for any period. PROVIDE THE FOLLOWING SELECTED VALUES: Planned Order Release Quantities for Product H Period 2 Period 3 Period 4 Period 1 Period 5 Gross Requirements Quantities for Item F Period 3 Period 1 Period 2 Period 4 Period 5 Click Save and Submit to save and submit. Click Save All Answers to save all answers. QUESTION 4 15 points Save Answer Develop MRP records for all items needed for item F in the following product structure for product H, using the information provided in the following tables. The lead time to complete product H is one week. Master production schedule (MPS) calls for 170, 110, and 90 units of demand for period 4, 5, and 6. Pruded E (1) F (2) G (1) Planning Data F L4L L4L Q=15* 2 weeks Q=300* 2 weeks L4L 2 weeks 1 week 1 week Data Category Lot size rule Lead time Safety stock Scheduled receipts Beginning inventory 15** 25 35 None none 20 1,300 (wk 1) 20 700 (wk 1) 50 900 (wk 1) 0 30 40 "Planned order schedules must be the same or multiples of Q amount **minimum on hand (ending inventory) quantity to be observed FORMAT FOR ENTRIES: All quantities are INTEGER (120, for example). Enter 0 if you do not have quantity for any period. PROVIDE THE FOLLOWING SELECTED VALUES: Planned Order Release Quantities for Product H Period 2 Period 3 Period 4 Period 1 Period 5 Gross Requirements Quantities for Item F Period 3 Period 1 Period 2 Period 4 Period 5 Click Save and Submit to save and submit. Click Save All Answers to save all answers