6. Sherwin-Williams would like to develop another master production schedule for the "Cashmere Interior Acrylic Latex" paint over the next 10 weeks. The weekly forecast (in 1000 gallons) is provided in the table below. Sherwin-Williams has 140K gallons of "Cashmere Interior Acrylic Latex" paint on hand. It uses a production lot size of 300K gallons for this product. The sales team let you know that they have already received firm orders for this product from customers for the next 4 weeks with volumes in the table below. They would like to know (1) if they need to actively search for more customers and if so, (2) how much additional volume they can sell. As the production manager of Sherwin-Williams, develop a master production schedule to minimize the ending inventory (i.e., the inventory at the end of the 10th week) and provide an answer to the sales team. (10 points) Week 1 2 3 4 5 6 7 00 9 10 Forecast On hand 100 100 100 100 100 100 100 100 100 100 Orders 110 80 50 20 Projected Available Balance 140 Available to Promise MPS