ons Problem 6-41 Algo (Location Decisions) Ques Ilint(s) Chec Spreadsheet Cunningham Products is evaluating five possible locations to build a distribution center. Data estimated from the accounting department are provided below. The annual production is estimated to be 25,000 units. CP Location Location 1 Location 2 Location 3 Location 4 Location 5 Analysis Data Fixed costs $80,000.00 $115,000.00 $ 109,000.00 $125,000.00 $115,000.00 Direct material $4.18 $4.65 $4.95 $4.70 $4.70 cost/unit Direct labor cost/unit $12.50 $14.00 $11.60 $15.60 $13.55 Overhead/unit $2.40 $2.40 $2.15 $3.25 $2.00 Transportation $0.55 $0.70 $0.40 $0.90 $0.22 cost/unit a. Use the Location Analysis Excel template to determine the lacation that provides the least cost. Calculate the total cost for each location. Round your answers to the nearest dollar. Location 1 Location 2 Location 3 Location 4 Location 5 Total costs $ S s 3$ $ Which location provides the least cost? Location 1 :) provides the least cost. b. For what range of demand would each location be best? CP Location Location 1 . Range of demand from 0 to 54,717 units no such range of demand from 54,717 to infinity no such range of demand no such range of demand Location 2 Location 3 Location 4 Location 5 + . Hide Feedback Partially Correct Hinta) Chec