Sherwin-Williams would like to develop another master productionschedule for the ?Cashmere Interior Acrylic Latex? paint over thenext 10 weeks. The weekly forecast (in 1000 gallons) is provided inthe table below. Sherwin-Williams has currently 140K gallons of?Cashmere Interior Acrylic Latex? paint on hand. It uses aproduction lot size of 300K gallons for this product. The salesteam let you know that they have already received orders for thisproduct from customers for the next 4 weeks as demonstrated in thetable below and would like to know (1) if they need to activelysearch for more customers and if so, (2) how many additional ordersthey can receive. As the production manager of Sherwin-Williams,develop a master production schedule to minimize the endinginventory (i.e., the inventory at the end of the 10th week) andprovide an answer to the sales team.

Week Forecast Orders Projected Available Balance Available to Promise MPS On hand 140 1 2 3 4 5 100 110 100 100 100 80 50 20 100 6 7 8 9 100 100 100 100 10 100