need help!

zoom in to view the question

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