A company desires to locate a new facility. Based on preliminary analysis, the choice has been reduced to four locations: A, B, C, and D. These four locations were rated on a scale from 1 worst to 10 best on each of four criteria. Each criterion was also weighted to indicate its importance (i.e., the higher the weight, the more important). The list of ratings and weights follows. Location |Weight| B Factor Wages Labor climate A D 0.40 5 0.35 Local 0.15 0.10 3 6 2 regulation Weather 3 4 8 a- What would be the best location b- If the wights of weather and regulation be divided that the weather would be double of the regulations, what would be the best location

A company desires to locate a new facility. Based on preliminary analysis, the choice has been reduced to four locations: A, B, C, and D. These four locations were rated on a scale from 1 worst to 10 best on each of four criteria. Each criterion was also weighted to indicate its importance (i.e., the higher the weight, the more important). The list of ratings and weights follows. Location |Weight| B Factor Wages Labor climate A D 0.40 5 0.35 Local 0.15 0.10 3 6 2 regulation Weather 3 4 8 a- What would be the best location b- If the wights of weather and regulation be divided that the weather would be double of the regulations, what would be the best location

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A company desires to locate a new facility. Based on preliminary analysis, thechoice has been reduced to four locations: A, B, C, and D. These four locationswere rated on a scale from 1 worst to 10 best on each of four criteria. Eachcriterion was also weighted to indicate its importance (i.e., the higher theweight, the more important). The list of ratings and weights follows THE TABLE ATTACHED b- If the wights of weather and regulation be divided that the weatherwould be double of the regulations, what would be the best location. Please can you give me an answer with explanation.
A company desires to locate a new facility. Based on preliminary analysis, thechoice has been reduced to four locations: A, B, C, and D. These four locationswere rated on a scale from 1 worst to 10 best on each of four criteria. Eachcriterion was also weighted to indicate its importance (i.e., the higher theweight, the more important). The list of ratings and weights follows. LocationFactor Weight A B C DWages 0.40 7 5 3 5Laborclimate 0.35 6 5 9 5Localregulation 0.15 3 4 3 2Weather 0.10 2 8 6 9a- What would be the best locationb- If the wights of weather and regulation be divided that the weatherwould be double of the regulations, what would be the best location
Wagner Remodelers Inc. is looking for a new city in whichto relocate their home remodeling business. The companyemploys highly skilled craftspeople who rehabilitate oldhousing. Most of their current craftspeople will relocate withthe company; however, additional works at the new locationwill be hired. The most important location factors for thecompany were weighted and three target cities were scoredagainst these factors a. Which location is indicated by the preference matrix?b. Would the best location change if the company decidednot to relocate any of its current craftspeople but insteadhire only from the population at their new location?Assume that factors 8 and 9 are now given no weight andfactor 5 is twice as important.
Considering the following data:Location Alternatives(scored out of 100 pts each)Factors Weights A B CConvenience 0.15 86 85 78Parking Facilities 0.20 78 78 92Display Area 0.18 90 89 90Shopper Traffic 0.27 91 92 85Operating Costs 0.10 98 95 90Neighborhood 0.10 88 91 85a. Using the above factor ratings, calculate the composite score for each location.b. Determine which location alternative (A, B, or C) should be chosen on the basisof the maximum composite score.
Accel Express, Inc., collected the following information onwhere to locate a warehouse (1 = poor, 10 = excellent): a. Which location, A or B, should be chosen on the basis ofthe total weighted score? b. If the factors were weighted equally, would the choicechange?
Although most organizations may make the location decision infrequently, there are some organizations that make the decision quite regularly and often. Provide one or two examples. How might their approach to the location decision differ from the norm?
4. Identify the Country, Region, and Site considerations when making a location decision.
ABC Ltd. Wants to choose the best location for its new aluminium plant. The manager of productions and operations has three possible locations to choose from. His assistant recommends that he use the break-even analysis location technique to help determine which location is best based on costs. I. Design a numerical example in order to demonstrate to the Productions and Operations Manager how break-even analysis can be used in this case. II. Demonstrate to the OM manager how to go about choosing the best location using the numerical example you designed above.
Factor(100 points each) Weight A B C Convenience 0.15 86 75 80 Parking facilities 0.2 70 86 96 Display area 0.18 88 90 91 Shopper traffic 0.27 86 90 95 Operating costs 0.1 95 91 96 Neighborhood 0.1 88 88 91 1.00 A. Using the above factor ratings, calculate the composite score for each location. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Location Composite score A ______________ B ________________ C ________________
1a. Discuss one factor that should be considered in the selection of the location of a facility or business.1b. Provide an example of a local business that was poorly located and list down the consequences of a bad location decision.
A supply chain manager faced with choosing among four possible locations has assessed each location according to the following criteria, where the weights reflect the importance of the criteria. Location Total Points 1 2 3 4 -Select- Criteria Raw material availability Infrastructure Transportation costs is the best location and -Select- Labor relations Quality of life Weight 0.09 0.08 0.35 0.11 0.37 Using this information, determine the best and the worst location. Round your answers to two decimal places. 1 P G VG OK OK is the worst location. Location 2 OK G G VG VG 3 G VG OK P P VG = Very good 5 pts; G = Good 4 pts; OK = Acceptable 3 pts ; P = Poor 1 pt. 4 G OK VG P OK
10.determine which location has the highest composite score.