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 His one week. Master production schedule (MPS) calls for 180, 140, and 80 units of demand for period 4, 5, and 6. Product I D (2) F (1) E (1) F (2) G (1) E (1) I (3) Planning Data D E F G I Q= 15* L4L L4L Q=300" L4L 2 weeks 1 week 1 week 2 weeks 2 weeks Data Category Lot size rule Lead time Safety stock Scheduled receipts Beginning inventory 15** 25 20 35 0 None none 1,300 (wk 1) 700 (wk 1) 900 (wk 1) 30 40 20 50 0 *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 1 Period 2 Period 3 Period 4 Period 5 Gross Requirements Quantities for Item F Period 1 Period 2 Period 3 Period 4 Period 5