Question 4: Develop a Material Requirements Plan (MRP) for the data in the following table that minimizes the total relevant costs. Count and cost inventory at the end of each period for calculating the inventory holding cost. 2 3 4 5 lo 6 7 8 11 1 30 10 10 30 60 10 12 50 10 20 10 Week Gross requirement Scheduled receipt On hand (beginning) On hand (end of period) Net requirement Planned order receipt Planned order release Lead time = 2 weeks; ordering cost = $400/order; holding cost = $0.5/unit/week; stockout cost = $10/unit; beginning inventory = 20 units. (a) What is the total cost associated with the optimal MRP? (b) What value of ordering cost will make the decision maker indifferent between the two lot sizing techniques (lot-for-lot and EOQ) for this problem? (3 marks for (a), and 2 marks for (b)) Question 4: Develop a Material Requirements Plan (MRP) for the data in the following table that minimizes the total relevant costs. Count and cost inventory at the end of each period for calculating the inventory holding cost. 2 3 4 5 lo 6 7 8 11 1 30 10 10 30 60 10 12 50 10 20 10 Week Gross requirement Scheduled receipt On hand (beginning) On hand (end of period) Net requirement Planned order receipt Planned order release Lead time = 2 weeks; ordering cost = $400/order; holding cost = $0.5/unit/week; stockout cost = $10/unit; beginning inventory = 20 units. (a) What is the total cost associated with the optimal MRP? (b) What value of ordering cost will make the decision maker indifferent between the two lot sizing techniques (lot-for-lot and EOQ) for this problem? (3 marks for (a), and 2 marks for (b))