D E B F 53 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 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 42,000 units per year. 60 61 per unit cost fixed cost per variable 62 location year materials labor overhead 63 Atlanta, GA $200,000 $0.60 $0.80 $0.40 64 Baltimore, MD $180,000 $0.83 $0.75 $0.75 65 Chicago, IL $170,000 $0.40 $0.40 $1.00 66 Denver, CO $210,000 $0.40 $0.30 $0.40 67 Indianapolis, IN $230,000 $0.50 $1.20 S0.80 68 Kansas, MO $220,000 $0.40 $0.80 $0.20 68 Los Angeles, CA $190,000 S0.20 $0.70 $1.00 70 Minneapolis, MN $206,000 50.30 song $0.30 71 New York, NY $196,000 $0.60 $0.50 $0.40 72 Orlando, FL $230,000 $0.20 $0.50 $0.50 73 Assume that the unit price is $22 75 Q1. Select the best city in terms of the annual profit and show the annual profit, 74 76 77 78 Q2. Select the second best city and show the annual profit. 79