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 35,000 units. a. Use the Location Analysis Excel template to determine the location that provides the least cost. Calculate the total cost for each location. Round your answers to the nearest dollar. provides the least cost. b. For what range of demand would each location be best? -Select- V provides the laast cost - Select- b. For what range of de from 0 to 357,143 units from 0 to 35,000 units from 35,000 to 343,346 units CP Location from 35,000 to 357,143 units Location 2 from 343,346 to 357,143 units Location 3 from 357,143 to 379,249 units from 357,143 to infinity \begin{tabular}{l|l} Location 4 & from 379,249 to infinity \\ no such range of demand \end{tabular} Location 5 Select