Kellwood, a company that produces a single product, has three plants and four customers. The three plants will produce 3000, 5000, and 5000 units, respectively, during the next time period. Kellwood...

Kellwood, a company that produces a single product, has three plants and four customers. The three plants will produce 3000, 5000, and 5000 units, respectively, during the next time period. Kellwood has made a commitment to sell 4000 units to customer 1, 3000 units to customer 2, and at least 3000 units to customer 3. Both customers 3 and 4 also want to buy as many of the remaining units as possible. The profit associated with shipping a unit from each plant to each customer is given in the file P05_80.xlsx. Determine how to maximize Kellwood’s profit.