Watch the numbers! It's not the old one!

Task 2: A small Tennessee company makes fused magnesia and silica. To prepare input for the planning software, the company 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): January February Week 2 2 3 Forecast 55 55 66 66 66 Outstanding order 400 15 3 4 1 10 4 55 66 The initial inventory is 80,000 pounds and 60,000 pounds are desired as the minimum safety stock at the end of each week. Considering the holding and setup costs with EPQ, the company has found that the optimum production quantity is around 80,000 units in each run. Use this production quantity to determine the production schedule (MPS) and Available to Promise inventory for the next 7 weeks. (10 Marks] February January WK2 WK3 WK4 WK1 WK2 WK3 WK4 55 55 66 66 66 66 55 15 40 0 60 Forecast Committed Beg Inv. Production POHI (Min = 60) Available- to-promise