Please how to calculate each value step by step.

Save Answer QUESTION 4 15 points 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 190, 110, and 60 units of demand for period 4, 5, and 6 Product D (2) F (1) E (1) F (2) G (1) E (1) I (3) Question Completion Status: Planning Data Data Category D E F G I Lot size rule Q=15* Q 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 none 1,300 (wk 1) 900 (wk 1) 700 (wk 1) 50 30 40 20 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