15 points QUESTION 4 Develop MRP records for all is needed for item in the following product structure for product in the information provided in the follow tables. The lead time to complete product is one week Master production schedules for 150, 100 and 110 units of demand for period and 6 A he Sand Sub Praded DW (1) (1) F G(1) E(1) 10) FA Planning Data E D m F 6 Data Catogory Lot size rule 1 LAL Q: 159 LUL 141 Lead tune week 2 weeks 55 2 weeks 0300 2 wood 35 1 week 25 Safety Stock Scheduled receipts Beginning inventory None 900 20 1300 11 20 sone 40 7000 50 30 wuon completion Status 2 weeks 1 week 1 week 2 weeks 25 0 Lead time Safety stock Scheduled receipts Beginning inventory 15" None 30 2 weeks 35 700 (1) 50 20 1,300 (wk 1) 20 none 900 (1) 81 10 0 *Planned order schedules must be the same or multiples of amount ** minimum on hand (ending Inventory quality to be observed FORMAT FOR ENTRIES: All quantities are INTEGER (120, for example) Enter of you do not have quantity for any period PROVIDE THE FOLLOWING SELECTED VALUES: Planned Order Release Ouantities for Product H Perod 3 Period 1 Period 2 Period 4 Penica 5 Gross Requirements Quantities for tom F Period 3 Period 1 Period 2 Period 4 Period 5