54 Problem 3 55 Industrial Packaging Solutions (IPS) is a manufacturer of corrugated fireboard 56 shipping boxes used by companies across the United States. IPS is considering 57 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 27,000 units per year. 60 61 per unit cost fixed cost variable 62 location per year materials labor overhead 63 Atlanta, GA $200,000 $0.40 S0.40 $1.201 64 Baltimore, MD $180,000 $0.85 S0.75 S0.75 65 Chicago, IL $170,000 $1.00 $1.00 $1.00 66 Denver, CO $210,000 $0.40) $0.30 $0.401 67 Indianapolis, IN $230,000 $0.50 $1.20 $0.80 68 Kansas, MO $220,000 $0.40 $0.80 $0.201 69 Los Angeles, CA $190,000 $0.20 $0.70 $0.40 70 Minneapolis, MN $230,000 $0.30 $0.30 S0.30 71 New York, NY $196,000 $0.60 S0.40 S0.401 72 Orlando, FL $230,000 $0.20 S0.50 S0.500 73 Assume that the unit price is $24 75 Q1. Select the best city in terms of the annual profit and show the annual profit 74 76 78 Q2. Select the second best city and show the annual profit