A manager has received an analysis of several cities being considered for a new order fulfillment center (warehouse) for Shop at Home Network. The scores (scale is 10 points = best) are contained in the tablebelow.a. If the manager weights the factors equally, how would the locations be ranked?b. If transportation costs and operating costs are given weights that are double the weights of the others, should the locations be ranked differently?FactorBusiness servicesCommunity servicesReal estate costConstruction costsOperating costsBusiness taxesW7578568X9736496LocationTransportation costsFor the toolbar pract ALT+F10/90 or ALTHEN+510 MadY5686767Z4765648

Answered: A manager has received an analysis of…

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 manager has received an analysis of several cities being considered for a new officecomplex. The data (10 pts maximum) are as follows:Location AlternativesFactors A B CBusiness Service 7 6 6Community Services 5 6 7Real Estate Cost 5 8 7Construction Cost 6 7 6Cost of Living 2 7 8Taxes 6 5 4Transportation 7 7 8a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores?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 manager received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Factor Business services Community services Real estate cost Construction costs Cost of living Taxes Transportation A с Thus, Location Score A A B с Thus, 17 17 17 8 6 4 3 2 8 9 B 6 6 Click here for the Excel Data File a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? 8 7 7 19 19 19 5 7 is/are the best. C 6 7 7 6 8 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? is/are best and 4 8 is/are least desirable.
Q2k Audi is considering three locations A, B and C for the production of its new model SUV XL500. The objective is to choose the location with the lowest costs. The costs are measured as annual fixed costs plus the variable costs of the product. The following data has been collected for the three locations.< Region Fixed costs per year A B C 10 000 000 20 000 000 25 000 000 Variable cost per unit 1. at what level of production will C be the best choice? 2. at what production rate will A be the best choice? 3. at what level of production will B be the best choice? 2500 2000< 1000< The company's projected annual production in the new plant is 0-60 000 units.< Ask
Identify and clarify seven key factors affecting decision on the location?
In deciding on where to locate their next grocery store, Publix narrowed it down to 3 locations (St. Augustine, the Airport area, or the Westside). They are using 2 criteria to make their decisions costs (with a weight of 70%) and customer base (with a weight of 30%). Each item was scored on a 10-point scale with 10 being the highest. St. Augustine rated a score of 4 for cost and 10 for customer base; the Airport area rated a score of 6 for cost and 5 for the customer base, and the Westside rated a score of 8 for cost and 2 for the customer base. __________ 2a. What is the computed mean score for each of the 3 locations? __________ 2b. Which location should be chosen based on the highest score?
On the cost- volume analysis chart where the costs of two or more location alternatives have been plotted, the quantity at which two cost curves cross is the quantity at which:a) fixed costs arc equal for two alternative locations.b) variable costs are equal for two alternative locations.c) total costs are equal for all alternative locations.d) fixed costs equal variable costs for one location.c) total costs are equal for two alternative locations.
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]
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 ] > >
Silky Industries is looking for a location for its second telephone remanufacturing facility. Two cities are under consideration. The two most important location factors are: Factor A "availability of resources" and Factor B "availability of customers." However, the company is having great difficulty assigning relative weights to these factors. Assuming that the factor weights must sum to 100, what range of weights would make Blake the superior location? E Click the icon to view the factors table. The total weighted factor scores are the same for the following weights: Factor A=O and Factor B =D. As the weight of Factor B becomes Blake will be the superior location. (Enter your responses as whole numbers.) More Info Factor Score for Each Location Factor City Factor Weight Blake Irmo A. Availability of resources B. Availability of customers Total 8 10 9 6. 100 Print Don
c. 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. Management-supplied the factor weights and the consultant team scores as seen in the table below. Scores are based on 50 = best. Location Factor Weight A B C Labor Climate 10 35 45 20 Taxes 30 30 40 40 Utilities 20 25 20 45 Wages 40 10 25 25 i. Which location should be selected and why?
Marilyn Helm Retailers is attempting to decide on a location for a new retail outlet. At the moment, the firm has three alternatives: stay where it is but enlarge the facility; locate along the main street in nearby Newbury; or locate in a new shopping mall in Hyde Park. The company has selected the four factors listed in the following table as the basis for evaluation and has assigned weights as shown: Factor Description Hyde Park Factor Weight Present Newbury Location 1 Average community 0.30 40 60 50 income Community growth potential 2 0.15 20 20 80 Availability of public transportation 0.20 30 60 50 Labor availability, attitude, and cost 4 0.35 80 50 50 a) Based on the given information, the best location for Marilyn Helm Retailers is to open the new retail outlet in with a total weighted score of 3.

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