B Problem 1 (30 points) The United Packaging Company (UPC) is a manufacturer of corrugated fireboard shipping boxes used by companies across the United States. UPC is considering 1 an additional plant in each of two cities to be selected among the following 10 cities. 2 UPC has collected the fixed-cost and variable-cost data. The demand in each 3 of the following cities is assumed to be unformly 45,000 units per year. 74 15 16 location 17 Atlanta, GA 18 Baltimore, MD 19 Chicago, IL 20 Denver, CO 21 Indianapolis, IN 22 Kansas, MO 23 Los Angeles, CA 24 Minneapolis, MN Sheet1 Sheet2 Ready Type here to search per unit cost fixed cost variable per year materials labor overhead $210.000 $0.20 $0.40 $0.40 $180,000 $0.40 $0.40 $0.50 $170,000 $1.00 $1.00 $1.00 $210,000 $0.40 $0.30 $0.40 $230.000 $0.50 $1.20 $0.80 $180,000 $0.40 $0.60 $0.20 $200.000 S0.20 $0.50 $0.60 $230.000 $0.30 $0.30 $0.30 Sheet 15 Esc F2 F3 F4 F5 F5 a # $ % location Atlanta, GA Baltimore, MD Chicago, IL Denver, CO 1 Indianapolis, IN 2 Kansas, MO 3 Los Angeles, CA -4 Minneapolis, MN 5 New York, NY 26 Orlando, FL per unit cost fixed cost variable per year materials labor overhead $210,000 $0.20 $0.40 $0.40 $180,000 $0.40 $0.40 $0.50 $170,000 $1.00 $1.00 $1.00 $210,000 $0.40 $0.30 $0.40 $230,000 $0.50 $1.20 $0.80 $180,000 $0.40 $0.60 $0.20 $200,000 $0.20 $0.50 $0.60 $230,000 $0.30 $0.30 $0.30 $196,000 $0.60 $0.80 $0.40 $230,000 $0.20 $0.50 $0.50 Assume that the unit price is $20. Select the best city in terms of the maximum profit and show the maximum profit. Select the second best city and show the profit