Questionsi. Calculate the weighted score for each alternative location. ii. Which location should be chosen? C.Factor12A clothing chain is considering two different locations for a new retail outlet. The organizationhas identified the four factors listed in the following table as the basis for evaluation, and it hasassigned weights as shown. The manager has rated each location on each factor, on a 100-pointbasis (higher scores are better), as shown under the respective columns for Barclay and Chester.34FactorDescriptionAveragecommunityincomeCommunitygrowthpotentialAvailability ofpublictransportationLabor costWeight Georgetown Biabou.40.25.15.207560458070809060

Here, for each location, I would determine the weighted score, the location with the highest…

Answered: Calculate the weighted score for each…

Business

Operations Management

Calculate the weighted score for each alternative location. ii. Which location should be chosen?

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 clothing chain is considering two different locations for a new retail outlet. The organizationhas identified the four factors listed in the following table as the basis for evaluation, and it hasassigned weights as shown. The manager has rated each location on each factor, on a 100-pointbasis (higher scores are better), as shown under the respective columns for Barclay and Chester.FactorFactorDescription Weight Georgetown Biabou1Averagecommunityincome .40 75 702Communitygrowthpotential .25 60 803Availability ofpublictransportation .15 45 904 Labor cost .20 80 60i. Calculate the weighted score for each alternative location. ii. Which location should be chosen?
A clothing chain is considering two different locations for a new retail outlet. The organizationhas identified the four factors listed in the following table as the basis for evaluation, and it hasassigned weights as shown. The manager has rated each location on each factor, on a 100-pointbasis (higher scores are better), as shown under the respective columns for Barclay and Chester.FactorFactorDescription Weight Georgetown Biabou1Averagecommunityincome .40 75 702Communitygrowthpotential .25 60 803Availability ofpublictransportation .15 45 904 Labor cost .20 80 60i. Calculate the weighted score for each alternative location. ii. Which location should be chosen? Please answer section ii
A clothing chain is considering two different locations for a new retail outlet. The organization has identified the four factors listed in the following table as the basis for evaluation, and it has assigned weights as shown. The manager has rated each location on each factor, on a 100-point basis (higher scores are better), as shown under the respective columns for Georgetown and Biabou. Calculate the weighted score for each alternative location. Which location should be chosen?
Saporito chain of restaurants offers Italian food. The management is evaluating three different locations for their new restaurant. The factors considered, factor ratings and factor score for each location are as tabulated below. Identify the best location for the proposed restaurant. Give reasons for your answer. # Factor Factor Ratings Location Factor Score Location 1 Location 2 Location 3 1 Appearance 20 5 3 2 2 Ease of expansion 10 4 4 2 3 Proximity to markets 20 2 3 5 4 Parking facilities 15 5 3 3 5 Ease of access 15 5 2 3 6 Competition 10 2 4 5 7 Labor supply 10 3 3 4
Pan American Refineries, headquartered in Houston, must decide among three sites for the construction of a new oil-processing center. The firm has selected the six factors listed below as a basis for evaluation and has assigned rating weightsfrom 1 to 5 on each factor:FACTOR FACTOR NAME RATING WEIGHT1 Proximity to port facilities 52 Power-source availability and cost 33 Workforce attitude and cost 44 Distance from Houston 25 Community desirability 26 Equipment suppliers in area 3Subhajit Chakraborty, the CEO, has rated each location for eachfactor on a 1- to 100-point basis.FACTOR LOCATION A LOCATION B LOCATION C1 100 80 802 80 70 1003 30 60 704 10 80 605 90 60 806 50 60 90a) Which site will be recommended based on total weightedscores?b) If location B’s score for Proximity to port facilities was resetat 90, how would the result change? c) What score would location B need on Proximity to port facili-ties to change its ranking?
A full-service restaurant is considering opening a new facility in a specific city. The table below shows its ratings of four factors at each of two potential sites. Factor Weight Gary Mall Belt Line Affluence of local population .20 30 30 Traffic flow .40 20 20 Parking availability .20 30 20 Growth potential .20 10 30 The score for Gary Mall is ________ and the score for Belt Line is ________. 90; 100 18; 120 34; 28 22; 24 none of these
The Bakers Dozen Restaurant is considering opening anew location. It has considered many factors and identifi ed theones that are most important. Two locations are being evaluatedbased on these factors, using factor rating. Each location hasbeen evaluated relative to the factors on a five-point scale. Th esenumbers are shown here. Use factor rating to help the restaurantdecide on the better location.
A location analysis has been narrowed down to three locations. The management needs to select the best location. The critical success factors, their weights, and the ratings for each location are shown below: Location Location Location Factor Wt. A B C Labor Cost 0.3 80 85 75 Transportation Cost 0.2 85 85 60 Market Access 0.2 90 70 90 Raw Materials Cost 0.1 80 90 90 Utility Cost 0.2 75 90 75 a) The composite score for location A is ( )b) The best location is ( )
Alternative locations for a new drinking water treatment plant are being evaluated using four attributes identified as A, B, C, and D with weightsof 0.4, 0.3, 0.2, and 0.1, respectively. If the value rating scale is from 1 to 10, the evaluation measure of the weighted attribute method for ratings of 3,7, 2 and 10 for attributes A, B, C, and D, respectively, is closest to:a. 3.3b. 3.9c. 4.1d. 4.7
Benoit Manufacturing Company manufactures and sells parts for various musical gadgets. The following information to a single part which is used in the production of a wind instrument. The business earned Operating Income of $220,000 in 2019, when production was 3,000 units and the president of Darius is under pressure from shareholders to increase operating income in 2020 and is therefore considering the implementation of strategies mainly geared at increasing revenues and or decreasing variable costs. Data for variable cost per unit and total fixed costs were as follows: Variable expenses per unit: Direct Material $58 Direct Labour $74 Variable Manufacturing Overhead $48 Fixed expenses: Fixed Manufacturing Overhead $215,000 Fixed Selling Costs $65,000 Fixed Administrative Costs $160,000 The President of Benoit is under pressure from shareholders to increase operating income by 50% in 2020. Management…
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 ________________
Voice International is deciding between 2 Philippine companies to provide its call center services. A factor-rating method is used to evaluate. The factors are rated on a scale of 1-10, with 10 being the best score. If the factors are weighted equally with respective weights of .3333, which of the firm is preferred? FIRM FACTOR 1 FACTOR 2 FACTOR 3 A 6 7 10 B 8 9 8