Daves would like to develop another master production schedule for the Shimmer coat paint over the next 10 weeks. The weekly forecast (in 1000 gallons) is provided in the table below. Daves has currently 140K gallons of Shimmer coat 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 Daves, 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 2 3 5 10 Forecast On hand 100 100 100 100 100 100 100 100 Orders 8050 Projected Available Balance 140 Available to Promise MPS