QUESTION 4 Develop MRP records for all items needed for item Fin 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 100 units of demand for period 4, 5, and 6. Predact D (2) F (1) Planning Data E (1) D E F G - F (2) G (1) Data Category Lot size rule Q= 15 L4L L4L Q=300" L4L E (1) Lead time 1 (3) 2 1 1 2. 2 weeks week week weeks weeks 2. 2 Safety 15" 25 20 35 0 stock Scheduled receipts None none 1,300 (wk 700 (wk 900 1) 1) (wk 1 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 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 1 Period 2 Period 3 Period 4 Period 5