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 180, 120, and 70 units of demand for period 4, 5, and 6 PodacH D (2) F (1) E (1) F (2) G(1) E (1) I (3) Planning Data Data Category D E F G I Lot size rule Q=15* L4L L4L Q=300* L4L Lead time 2 weeks 1 week 1 week 2 weeks 2 weeks Lot size rule Q= 15* L4L L4L Q=300* L4L Lead time 2 weeks 1 week 1 week 2 weeks 2 weeks Safety stock 15** 25 20 35 0 Scheduled receipts None none 1,300 (wk 1) 700 (wk 1) 900 (wk 1) Beginning inventory 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