show steps and solve in mrp table

21 points An upcoming demand of 70, 50 and 100 units of product E is anticipated in weeks 6, 7 and 8 respectively, where the structure of product is shown in the table below. Three cases (40 units per case) of have been ordered and they are expected to arrive in weeks 3, 4 and 6, respectively (one case each week). Item I must be ordered by the case, and item B must be produced in multiples of 50 units, whereas item is produced following a lot for lot policy. There are 25 units of B and 20 units of J on hand now and none of E. Manufacturing lead times are two weeks for E and B, and puthese lead time is one week for J. The company would like to retain a 10% safety stock of item (just in case), while the manufacturing process for itern I supplier is not perfect and generates a 10% icrap rate Direct components (end-item) 1(2)(2) 3(3), 2) Item Prepare the Material requirements plan for item (Notes: round up whenever there are fractional values. Also, make use of the MRP tables available on learn and make a man.com