Sherwin-Williams would like to develop another master productionschedule for the ?Cashmere Interior Acrylic Latex? paint over thenext
Question:
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.