need it asap

Question 4) (30 Points) Product structure diagram of end item which is produced in IET Tec h. Company as follows. End Item (Filled and Capped Bottle) Week Scheduled receipt 8 50000 10 10000 0 Cap (1) Filled Bottle (1) Lead Time = 2 Weeks Lead Time = 3 Weeks Bottle (1) Ball (2) Lead Time = 1 Week Lead Time = 3 Weeks Predicted demand for the end item and scheduled receipt for different weeks are given in the tables below. Predicted Demand for End Item: Month Demand 7 200000 8 9 10 300000 300000 250000 Beginning inventory for end item is equal to 100000 at the end of week 6. (10 Points) 8 9 10 (10 Points) a) Find net demand for final product. Month 7 Demand b) Fill MRP table for Filled Bottle. week 4 5 Gross requirem ents Net requirement S Time-Phased Ne t Requirement 6 7 8 9 10 Page 5 of 8 Planned Order R elease (Lot for L ot) c) Fill MRP table for Ball. (10 Points) 5 1 N 3 4 week Gross requirem 6 7 89 10 ents Net requirement S Time-Phased Ne t Requirement Planned Order R elease (Lot for L ot)