QUESTION 4 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 200, 130, and 100 units of demand for period 4, 5, and 6. Product Planning Data Data Category D E F G 1 Lot size rule Q= 15* L4L L4L Q=300" L4L D (2) F (1) Lead time 2 weeks - 1 week 1 week 2 weeks 2 weeks Safety stock 15** 25 20 35 0 E (1) None none 1,300 (wk 1) 700 (wk 1 900 (wk 1) F (2) G(1) Scheduled receipts Beginning inventory 30 40 20 50 0 E (1) I (3) *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 o if you do not have quantity for any period. PROVIDE THE FOLLOWING SELECTED VALUES: Planned Order Release Quantities for Product H Period 1 Period 2 Period 3 Period 4 Period 5 Gross Requirements Quantities for Item F Period 3 Period 1 Period 2 Period 4 Period 5