Based on McBride and Zufryden XXXXXXXXXXA company is trying to determine which of five possible products to include in its product line. The fixed cost of producing each product and the unit profit...

Based on McBride and Zufryden (1988). A company is trying to determine which of five possible products to include in its product line. The fixed cost of producing each product and the unit profit for each product are listed in the file P06_98.xlsx. There are five customer segments. The number of customers in each segment and the utility each customer segment associates with each product are also listed in this file. If a consumer believes that all available products have a negative utility, this customer will buy nothing. Otherwise, each customer will buy the available product that has the largest utility. For example, if products 1, 2, and 3 are available, customer segment 4 will purchase product 3. Determine which products the company should produce to maximize its profit. (Hint: Use a binary changing cell for each product and a binary changing cell for each customer segment/product combination. To ensure that a customer buys only the product with the largest utility, include the following constraint for each combination of product and customer segment: