need help!

zoom in to see question clearly

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. Product D (2) F (1) E (1) F (2) G(1) E (1) I (3) Planning Data Data Category D E F G 1 Lot size rule Q= 15$ L4L L4L Q=300" L4L 2 weeks 1 week 1 week 2 weeks 2 weeks 15** 25 Lead time Safety stock Scheduled receipts Beginning inventory 20 1,300 (wk 1) 35 700 (wk 1) 0 900 (wk 1) None none 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 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 3 Period 1 Period 2 Period 4 Period 5