2. Consider the necessary information for an MRP application provided below. Develop the MRP table for this problem. Item z A Lead Time 2 z B On hand 40 24 32 18 60 35 2 A(2) B(2) D 1 3 2 E C(2) E(3) C(2) D(4) Requirements include 125 units (80 firm orders and 45 forecast) of Z in week 10 plus the following spares: Spares 1 2 3 7 4 5 6 8 10 9 23 17 A B D E 22 20 25 3. Consider the dynamic demand of an end item following the MRP explosion process. Week 1 2 3 4 5 6 Planned Order 50 75 20 Release 30 80 100 The order cost (setup) per order is $125. Inventory carrying charge is assumed to be $1 per unit per time period. Find out the dynamic lot sizes for this problem by using a) Silver-Meal Method b) LUC method c) PPB method d) Solve the problem optimally by using the Wagner-Whitin algorithm. e) In class, we assumed production cost was constant and therefore could be ignored in the calculations. However, the cost of the item varies due to supplier limitations. This supplier can only provide enough raw material for 55 units per week at a cost of $5 per unit. Additional raw material can be purchased from another supplier for $7 per unit. Propose a modification of the Wagner-Within algorithm to include the changing cost of the raw material and solve. f) Currently our inventory carrying charge is $1 per unit per time period. Your company is trying to decide if they should modify the way that hold inventory. If the modification is made, the inventory carrying cost would be 15% of the cost of the item per time period. Assuming FIFO, how would this change the cost of the solution you developed in part e? Calculate the total cost if we were to produce all at once