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