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 currently 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 orders for this product from customers for the next 4 weeks as demonstrated in the table below and would like to know (1) if they need to actively search for more customers and if so, (2) how many additional orders they can receive. 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.

Week 1 1 2 3 4 5 6 7 8 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