Problem 5: Minco, a small Tennessee company, makes fused magnesia and silica. To prepare input for the planning software, Minco first uses a spreadsheet to determine the capacity requirements for the main equipment (the fusion furnaces) and the production schedule for main products Product 3050 had the following forecasted sales and outstanding orders (all in thousand pounds): Week Forecast Outstanding order 1 45 30 2 45 0 3 45 15 4 55 5 55 6 55 7. 55. The initial inventory is 100,000 pounds and 80,000 pounds are desired as the minimum safety stock at the end of each week, Considering the holding and setup costs with EPQ, Minco has found that the optimum production quantity is around 90,000 units. Use this production quantity to determine the production schedule (MPS) and Available to Promise inventory for the next 7 weeks. 17 Marks) WKI 45 30 WK2 45 0. WK3 45 15 WKA 55 WK5 55 WK6 55 WK7 55 Forecast Committed BegInv. Production POHI (Min -80) Available- to-promise