7 A Detroit seafood restaurant is considering opening a second facility in the suburb of West Bloomfield. The table below shows its ratings of five factors at each of fourpotential sites. Which site should the owner, Lucy Lyu, select?FactorAffluence of local populationConstruction and land costTraffic flowParking availabilityGrowth potentialThe best site in the suburb of West Bloomfield isSite 1▼, with an average weighted score ofSite 2Site 3Weight1010252015Site 4Site 1 Site 2 Site 3706085859080706085809090908090Site 49060908075(round your response to two decimal places).

The given data can be tabulated as follows:FactorWeightSite 1Site 2Site 3Site 4Affluence of local…

Answered: A Detroit seafood restaurant is…

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

Accel Express, Inc., collected the following information on where to locate a warehouse (1 = poor, 10 = excellent): Location Score Location Factor Factor Weight A B Construction costs 10 8 5 Utilities available 10 7 7 Business services 10 4 7 Real estate cost 20 7 4 Quality of life 20 4 8 Transportation 30 7 6 a. Which location, A or B, should be chosen on the basis of the total weighted score?b. If the factors were weighted equally, would the choice change?
Accel Express, Inc., collected the following information on where to locate a warehouse (1 = poor, 10 = excellent): %3D Location Score Location Factor Factor Weight A В Construction costs 10 Utilities available 10 1 2 Business services 20 8 10 Real estate cost 20 1 Quality of life Transportation 20 6. 2 20 6. a. Which location, A or B, should be chosen on the basis of the total weighted score? The total weighted score for location A is and the total weighted score for location B is so location should be chosen on the basis of the total weighted score. (Enter your responses as integers.)
Peter Billington Stereo, Inc., supplies car radios to auto manufacturers a nd is going to open a new plant. The company is undecided between Detroit and Dallas as the site. The fixed costs in Dallas are lower due to cheaper land costs, but the variable costs in Dallas are higher because shipping distances would increase. Given the following costs: a) Perform an analysis of the volume over which each location is preferable.b) How does your answer change if Dallas's fixed costs increase by 10%?
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.
The owners of Speedy Logistics, a company that providesovernight delivery of documents, are considering where to locatetheir new facility in the Midwest. Th ey have narrowed their searchdown to two locations and have decided to use factor rating tomake their decision. They have listed the factors they considerimportant and assigned a factor score to each location basedon a fi ve-point scale. Th e information is shown here. Using theprocedure for factor rating, decide on the better location
Sap Manufacturing, a manufacturing company that manufactures football jerseys and located in Port Antonio, Jamaica, is preparing to build a new plant. J’s is considering three potential locations that are suitable for the construction of the plant. The fixed and variable costs for the three alternative locations are presented in the table below. Costs A B C Fixed Costs ($) 700,000 1,000,000 1,100,000 Variable ($ per unit) 28 20 18 Identify the range over which each alternative (A, B and C) is best. A manufacturing firm is considering three potential locations for a new parts manufacturing facility. A consulting firm has assessed three sites based on the four factors supplied by management as critical to the location's success. The factor weights and the consultant team scores are given in table 5 below. Scores are based on 50 = best. Locations Factors Weights A B C Labor Climate 10 35 45 20 Taxes 30 30 40 40 Utilities 20 25 20…
The fixed and variable costs for three potential manu-facturing plant sites for a rattan chair weaver are shown: SITE FIXED COST PER YEAR VARIABLE COST PER UNIT1 $ 500 $112 1,000 73 1,700 4a) Over what range of production is each location optimal?b) For a production of 200 units, which site is best?
The fixed and variable costs for three potential manufacturing plant sites for a rattan chair weaver are shown: Site Fixed Cost Per Year Variable Cost per Unit 1 $800 $10.00 $5.00 $4.00 $1,100 3 $2,100 a) Afteř rounding to the nearest whole number, site 1 is best below V units. After rounding to the nearest whole number, site 2 is best between V and V units. After rounding to the nearest whole number, site 3 is best above V units. b) If the demand is 1010 units, then the best location for the potential manufacturing plant is
Peggy Lane Corp., a producer of machine tools,wants to move to a larger site. Two alternative locations havebeen identified: Bonham and McKinney. Bonham would havefixed costs of $800,000 per year and variable costs of $14,000per standard unit produced. McKinney would have annual fixedcosts of $920,000 and variable costs of $13,000 per standard unit.The finished items sell for $29,000 each.a) At what volume of output would the two locations have thesame profit?b) For what range of output would Bonham be superior (havehigher profits)?c) For what range would McKinney be superior?d) What is the relevance of break-even points for thesecities?
The fixed and variable costs for four potential plant sites for Brent Snyder's Ski Supplies are shown here: a) Graph the total-cost lines for the four potential sites.b) Over what range of annual volume is each location the preferable one (that with lowest expected cost)?c) If expected volume of the ski equipment is 5,000 units, which location would you recommend?
The fixed and variable costs (in U.S. dollars) for thenew recycling plant that Eldon Yi is opening in Australia arecomputed as follows: a) Over what range is each city preferable?b) For a recycling of 5,000 units, which site is best?
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 ( )

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS