3 Sh 4) Case Study Selecting a location using the factor-rating method. Superior Pump is a leader in submersible sump pumps for home and commercial use. Superior's sales are dominated (60 percent) by its 12 off-the-shelf products that are sold through company-owned and independent distributor channels to retailers throughout the United States, Canada, and Mexico. The remaining 40 percent of sales is a mixture of assemble and make-to-order (customized) pumps. Currently, management is looking to expand direct coverage by building a distribution facility on the west coast. In consideration of sites, management is particularly concerned about labor, transportation, infrastructure, and facilities costs. As the operations manager at Superior Pump, you have been asked to provide your expert opinion concerning the new location. The executive team members have done a lot of work narrowing down the locations and assessing the strengths and weaknesses of three possible sites: Seattle, San Diego, and Denver. They have also carefully detailed what critical decision issues need to be considered and have actually rated them on a scale of 1 to 100 The results of their efforts appear in the following worksheet. Your responsibility is to weigh the importance of each location decision issue based on management's goals and then to make a recommendation based on your findings. Use the information below, Site Scores (100 points) Decision issue Weight Seattle San Diego Denver 16 18 16 35 75 55 25 85 50 45 50 55 85 Labor cost Labor availability Transportation costs Transportation availability Taxes Quality of life Infrastructure costs Facilities cost 70 65 15 5 8 7 15 10 85 80 55 60 80 80 60 20 70 40 Based on your calculations, the optimal sites: (show all work) Now Now, If all things stayed the same except for the weight of Transportation availability now goes from 15% to 5% and Facilities cost from 15% to 25%. What are the new weighted scores. (show all work) Based on your new calculations, what is the optimal site