A manager received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are asfollows:FactorBusiness servicesCommunity servicesReal estate costConstruction costsCost of livingTaxesTransportationAсThus,Location ScoreAABсThus,1717178643289B66Click here for the Excel Data Filea. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores?87719191957is/are the best.C67768b. If business services and construction costs are given weights that are double the weights of the other factors, how would thelocations stack up?is/are best and48is/are least desirable.

Calculation: Factor Weight(W) Location A Location B Location C Business Services 1/7 8 6…

Answered: a. If the manager weights the factors…

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

Evaluating location alternatives by comparing their composite(weighted-average) scores involvesa) factor-rating analysis.b) cost–volume analysis.c) transportation model analysis.d) linear regression analysis.e) crossover analysis.
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A 25 26 27 28 29 30 B с 1 2 Based on the city distance dataset as follows: 3 4 5 6 7 8 9 1 Boston 2 Chicago 3 Dallas 4 Denver 5 LA 6 Miami 7 Phoenix 8 Seattle D Phoenix Chicago Denver Dallas 0 983 1815 1991 3036 1539 2664 2612 Boston Chicago Dallas Total trip miles by the traveler: Index Cities Seattle LA E Total trip miles 983 0 1205 1050 2112 1390 1729 2052 F Distance 1815 1205 0 801 1425 1332 1027 2404 G Denver LA 1991 1050 801 0 1174 2100 836 1373 H 3036 2112 1425 1174 0 2757 398 1909 I Miami 1539 1390 1332 2100 2757 0 2359 3389 J K Phoenix Seattle 2664 1729 1027 836 398 2359 0 1482 A resident of Seattle is embarking on a road trip that takes her to Los Angeles, Phoenix, Chicago, Denver, Dallas, and finally go back to Seattle. How many miles will she travel on this trip? Hint: Use INDEX and MATCH to answer the above question. 2612 2052 2404 1373 1909 3389 1482 0 L M N
CVS chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment along with the coordinates are as follows: Market Segment Location Coordinates Number of Customers x y 1 8 13 2000 2 10 16 800 3 4 8 1600 4 12 4 3200 Find the best location using the Center of Gravity Excel template
Careful selection of location is significant in the success of a business. Which among the following is a technique or model used for location decisions O a. Enterprise Resource Planning O b. Linear Regression Method Oc Weighted Factor Comparison Method O d. Historic Method
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 ] > >
Select all of the examples of companies locating a facility because of market асcess. O A company that supplies products to the US and European markets locates their production facility in southeast Asia. A major retailer is located in several major cities across the country. O A company locates a processing facility adjacent to the supplier's mining operations. O A business management consulting firm locates in the same cities as prestigious universities.
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
For the following scores 6, 1, 4, 2, 3, 4, 6, 6 find the: (d) What is the concern to use mean as measure of central location?
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 410 7 460 13 540 2 420 8 480 14 550 3 430 9 500 15 570 4 420 10 490 16 580 5 430 11 510 17 590 6 440 12 530 18 600 Click here for the Excel Data File a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) b. Use the above trend equation to predict expected loadings for Weeks 20 & 21. (Round your final answers to 2 decimal places.) c. The manager intends to install new equipment when the volume exceeds 990 loadings per week. Assuming the current trend continues, in which week (at the earliest) should the loading volume reach that level? (Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate calculations. Round your final answer to 2 decimal places.)
The Davis national drugstore chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment along with the coordinates are as follows: Location Coordinates Market Segment 1 2 3 4 Find the best location using the Center-of-Gravity Excel template. Round your answers to two decimal places. Cx: Cy: Choose the correct graph representing the center of gravity. The correct graph is-Select- A. 25 20 15 -10 5 Center of Gravity y- Coordinate L 5 10 15 20 x- Coordinate 25 B. 25+ 20+ 15 -10- 5- Center of Gravity y- Coordinate 5 8 10 15 20 x- Coordinate X 1 13 1 11 25 Y 14 21 1 1 Number of Customers 1,600 400 1,200 3,700
(use excel to show formulas used) Amazing is evaluating three locations for a second headquarters. Costs for construction at location A are $18,900,000, Location B are $21,700,000 and Location C are $23,300,000. Variable costs for Location A are $16, Location B are $14 and Location C are $12. The company plans to sell products for $27. What is the break-even point for each location?
a. You are given the following information for the Limassol District: Population 2020 Population growth rate 2021 Population growth rate 2022 Average household size 2020 Average household size 2021-2022 Total housing stock 2020 Number of housing units in building permits that were issued in 2019 Number of housing units in building permits that were issued in 2020 248,500 1.6% 2.3% 2.68 2.61 99,869 1,980 1,210 Assuming that it takes two years from the date of the building permit issuance to complete a housing unit and making any other assumptions needed, calculate the difference between demand for and supply of housing at the end of 2022. Show clearly and explain all your calculations. Also, explain what the result of your calculations means in terms of the expected market situation in 2022 (equilibrium, excess demand or oversupply) and how house prices should move as aresult of this situation.

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