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 worksheet to determine your answer. Site Scores (100 points) Weighted Scores Weight Seattle San Diego DEIVE Sealie San Diego Denver Labor costs 16. Labor availability 18 Transportation costs Transportation availability 15 Tags 5 Quality of life 8 17 Facilites cost 15 40 35 25 45 75 85 50 55 50 55 70 85 60 65 10 80 75 85 80 70 Infrastructure costs 80 60 55 70 Focus Enable Editing 75 85 BU net can contain viruses. Unless you need to edit it's safer to stay in Protected View. Quality of life 8 Infrastructure costs 7 Facilities cost 00 70 BO 60 40 55 70 Total Totals Based on your calculations, the optimal site is: (show all work) Now, If all things stayed the same except - you changed the weight of Transportation availability from 15% to 5% and Facilities cost from 15% to 25%. What are the new weighted scores. Based on your new calculations, what is the optimal site: (show all work) Marks breakdown Question 1 10 answers x 2 marks each Question 2 5 answers x 2 marks each Question 3: Clearly explained Question 4 Part A 4 answers x 5 marks Part B 4 answers x 5 marks = 20 = 10 = 20 = 20 = 20 All Calculations and formula must be shown = 10 100 max