Location ScoreFactor(100 points each)WeightABCConvenience0.15879284Parking facilities0.20738393Display area0.18908996Shopper traffic0.27909093Operating costs0.10858988Neighborhood0.109587941.00Click here for the Excel Data Filea. Using the above factor ratings, calculate the composite score for each location. (Do not round Intermediate calculations. Roundyour final answers to 2 decimal places.)LocationACompositeScoreBCb. Determine which location alternative (A, B, or C) should be chosen on the basis of maximum composite score.OcOBOA13

To answer this problem, we must compute the composite score for each location using the provided…

Answered: Location Score Factor (100 points each)…

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

An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. Fixed Cost Variable Cost Location A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 i. ii. 300 200 100 2 4 6 8 10 14 16 18 20 Q (000s of units) Plot the total cost curves in the chart provided above and identify the range over which each location would be best. [7 marks] Use break-even analysis to calculate exactly the break-even quantity that defines each range. [3 marks]
In location planning, environmental regulations, cost and availability of utilities, and taxes are: Question 15Answer A. regional/community factors. B. irrelevant. C. site-related factors. D. global factors. E. country factors.
Consider you are an owner of one IT organization with 200 employees and you want to keep track of the location information of each employee. You know that none of the employees will go out from the city and the radius of the city is 50 km. What kind of location measure technique will be appropriate for you to keep rack of continuous location information? Explain with proper justification. Also, show how your chosen location measurement is better than the other ones.
The following table shows the fixed cost and variable cost for 3 locations. Construct cost curves for these 3 locations for production from 0 to 200 units at 20 units intervals. What would be the range of production units that would give Location A a competitive advantage? What would be the range for Location B and Location C, respectively?
Develop a network showing the origin nodes, destinations, arcs, cost per arc, supply, and demand. Match the correct answer to each question. Warehouse A B C D City E City F City G City H Warehouse Supply. 0.51 0.21 0.52 0.41 4000 Question 1 0.31 Question 2 0.56 0.43 0.35 0.41 0.28 City Demand 4,400 3,000 6,500 4,700 Match the correct answer to the following questions: 1. What is the supply constraint for Warehouse D? 2. What demand constraint for City H? 0.32 0.54 0.33 4000 0.54 0.34 0.52 6300 6000 [Choose ] [Choose ] > >
b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc 25 3 7 Zac Supermarket 13 5 2 Harry Inc. 6 8 4 Sky Productions 4 1 5 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products
Problem 8-10 Factor Initial cost Traffic Maintenance Dock space Neighborhood Location East #1 East #2 West Weight East #1 100 60 20 24 15 0 00 00 N West East #1 East #2 8 8 4 4 2 East #2 110 35 25 24 9 a. Using the above factor ratings, calculate the composite score for each location. West 110 35 Composite Score 25 13 11 b. Determine which location has the highest composite score:
2. Garysburg Fire Rescue (GFR) is considering three different locations for a new fire station. Using factor rating, GFR has created the following table. When rating these locations, GFR used a 5- point scale, where 1 means unfavorable and 5 means excellent. (Noteshaper Scenario #26) Factor Weight Location 1 Location 2 Location 3 Cost of land 0.5 4 1 Accessibility 0.3 2 2 4 Size of Land 0.2 1 3 3 a. Which of the following statements are true and which are false? I. The cost of the available land parcel is of the greatest importance in this analysis. I. Location 2 has better accessibility than location 3. GFR considers the size of the available land parcel to be the least important III. factor.
P2.3 Write up the position and orientation for the piston shown in Figure 2.63 through the Location Descriptions section. Assume that the center of the wheel is stationary. 10in α 6in Figure 2.63: Piston.

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