1. 

QUESTION 4 Develop MRP records for all items needed for item 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 200, 150, and 60 units of demand for period 4, 5, and 6. Product D (2) F (1) E (1) F (2) G(1) Planning Data E (1) I (3) Data Category D E F G 1 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 None none 1.300 (wk 1) 700 (wk 1) 900 (wk 1) Scheduled receipts Beginning inventory 30 40 20 50 0 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 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 1 Period 2 Period 3 Period 4 Period 5