54 Problem 3 (30 points) 55 Industrial Packaging Solutions (IPS) is a manufacturer of corrugated fireboard 56 shipping boxes used by companies across the United States. IPS is considering an additional plant in each of two cities to be selected among the following cities. 58 IPS has collected the fixed-cost and variable-cost data. The demand in each 59 of the following cities is assumed to be unformly 42,000 units per year. ST 60 61 per unit cost fixed cost per year location 63 Atlanta, GA 64 Baltimore, MD 65 Chicago, IL 66 Denver, CO 61 Indianapolis, IN 68 Kansas, MO 63 Los Angeles, CA 70 Minneapolis, MN 71 New York, NY 72 Orlando, FL materials $0.60 $0.85 $0.40 $0.40 $0.50 S0.40 S0.20 $0.30 $0.60 $0.20 variable labor overhead $0.80 $0.40 $0.75 $0.75 $0.40 $1.00 $0.30 $0.40 $1.2011 $0.80 $0.80 $0.20 $0.70 $100 $0.30 $0.30 $0.80 $0.40 $0.50 $0.50 13 74 Assume that the unit price is $22 75 76 Select the best city in terms of the annual profit and show the annual profit 77 Q2 Select the second best city and show the annual profit 79 80 Sheet1 Sheet2 Sheets