Problem 8-10FactorInitial costTrafficMaintenanceDock spaceNeighborhoodLocationEast #1East #2WestWeight East #1100602024150 00 00 NWestEast #1East #288442East #21103525249a. Using the above factor ratings, calculate the composite score for each location.West11035Composite Score251311b. Determine which location has the highest composite score:

Find the given details below: Given details:FactorWeightFactor ScoreEast #1East #2WestInitial…

Answered: Problem 8-10 Factor Initial cost…

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

Problem 8-9 (Static) Location Score Factor (100 points each) Weight A B Convenience 0.15 80 70 Parking facilities 0.20 72 76 Display area 0.18 88 90 90 Shopper traffic 0.27 94 86 Operating costs 0.10 98 90 Neighborhood 0.10 96 85 182820 C 60 92 80 82 75 1.00 Click here for the Excel Data File 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 0
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 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?
1. Using the center-of-gravity method, compute the centralized coordinates among the following locations, which are indicated via black cells with white text in LOCATION.xlsx: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 2. Using the weighted average center-of-gravity, which accounts for quantities to be shipped from locations, compute the centralized coordinates among the following locations: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 *Quantities to be shipped are listed within the existing locations (i.e. Location 7,1 ships 17 units) in LOCATION.xlsx
Problem 8-11 A manager has received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Location Score Factor A B C Business services 8 6 6 Community services 7 6 7 Real estate cost 3 8 7 Construction costs 5 8 7 Cost of living 3 7 8 Taxes 5 5 4 Transportation 6 7 8 a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? A / 7 B / 7 C / 7 Thus, (Click to select) A B C B and C A and B is the best. b. If business services and construction costs are given weights that are double the weights of the other factors, how would the locations stack up? A / 9 B / 9 C / 9 Thus, (Click to select) A B C A and B B and C is best and (Click to select) A B C A and B B and C…
Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 2 4 6 8 10 14 16 18 20 Q (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
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. 2 3 4 -Select- is the best location and -Select- -Select- Location 1 Location 2 Location 3 Location 4 Criteria Raw material availability Infrastructure Transportation costs Using this information, determine the best and the worst location. Round your answers to two decimal places. Location Total Points 1 is the worst location. Labor relations Quality of life Weight 0.11 0.13 0.23 0.23 0.30 1 VG G P G G W Location 2 OK OK OK P VG 3 OK VG OK VG G VG Very good 5 pts; G = Good 4 pts; OK = Acceptable 3 pts; P = Poor 1 pt. 4 OK OK G VG OK
ABC Ltd. Wants to choose the best location for its new aluminum plant. The manager ofproductions and operations has three possible locations to choose from. His assistantrecommends that he use break-even analysis location technique to help determine whichlocation is best based on costs.I. Design a numerical example in order to demonstrate to the Productions andOperations 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 thenumerical example you designed above.
Q) A discount store chain wants to build a new superstore in an area in Melbourne near four small towns with populations between 10,000 and 40,000. The coordinates (in miles) of these four towns and the market population in each are as follows: Coordinates Carlton St Kilda Ballarat Frankston 12 18 30 32 20 12 8 25 Population 18,000 17,000 10,300 10,000 a) Determine the best site using the center-of-gravity technique. b) Suppose the store is limited to two possible sites for locating a new superstore. The coordinates (in miles) of these two potential sites are site 1 (10, 30) and site 2 (20, 10). Using the load-distance technique, determine the best site for the new super store. c) Plot the four small towns and the proposed new distribution centers according to center of gravity method and load-distance method on a grid map. Give your own opinion about it.
Xun Xu Health and Fitness has several productionfacilities scattered around the central and northern pa rt ofIowa. It would be desirable to have a distribution center fromwhich to send product to retailers such as Sears, WaiMart,Kmart, and large sporting equipment re tailers. Using the datain the following table, calculate the center of gravity locationfor the proposed new facility.
The Zhao family of Atlanta, Georgia, is planning its annual summer vacation. Three vacation locations along with criteria weights and location ratings follow. What is the recommended vacation location? Criteria Travel distance Vacation Entertainment available Outdoor activities Unique experience Family fun O Myrtle Beach, South Carolina OSmoky Mountains Branson, Missouri Weight 2 5 3 2 4 5 Myrtle Beach, South Carolina 5 5 7 9 5 8 Ratings Smoky Mountains 9 6 4 6 9 9 Branson, Missouri 3 8 4 5 9 8
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…

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