A supply chain manager faced with choosing among four possible locations has assessed each location according to the following criteria, where the weights reflect theimportance of the criteria.Location Total Points1234-Select-CriteriaRaw material availabilityInfrastructureTransportation costsis the best location and -Select-Labor relationsQuality of lifeWeight0.090.080.350.110.37Using this information, determine the best and the worst location. Round your answers to two decimal places.1PGVGOKOKis the worst location.Location2OKGGVGVG3GVGOKPPVG = Very good 5 pts; G = Good 4 pts; OK = Acceptable 3 pts ; P = Poor 1 pt.4GOKVGPOK

Find the given details below: Factor weightLocationCriteria1234Raw material…

Answered: A supply chain manager faced with…

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

Fruit Centre Ice Cream Parlor is deciding where to locate a new facility. The annual fixed costs, initial fixed costs and variable costs for each site have been estimated as follows; Location Annual Fixed Costs (shs) Initial Fixed costs selling price (shs) Variable costs(shs) Namugongo 35,000 400,000 200/unit 200/unit Kireka 19,000 250,000 400/unit 45/unit Banda 15,000 200,000 600/unit 2500/unit Ntinda 95,000 170,000 100/unit 360/unit If demand is expected to be 2000 units, which location is best? and Forecasting is a key component in operations management. Identify and describe any three methods of forecasting that you would recommend to a service industry.
Explain what are the people that are involved in facility location decisions?
Explain some major factos that firms consider when choosing a country in which to locate ?
Location Score Factor (100 points each) Weight A B C Convenience 0.15 87 92 84 Parking facilities 0.20 73 83 93 Display area 0.18 90 89 96 Shopper traffic 0.27 90 90 93 Operating costs 0.10 85 89 88 Neighborhood 0.10 95 87 94 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 A Composite Score B C b. Determine which location alternative (A, B, or C) should be chosen on the basis of maximum composite score. Oc OB OA 13
A steel company is considering the relocation of one of its manufacturing plants. The company’s executives have selected four areas that they believe are suitable locations. However, they want to determine if the average wages are significantly different in any of the locations, since this could have a major impact on the cost of production. A survey of hourly wages of similar workers in each of the four areas is performed with the following results. Do the data indicate a significant difference among the average hourly wages in the three areas? Hourly Wages ($) Area 1 Area 2 Area 3 10 20 15 12 25 16 8 12 22 13 18 13 9 14 15 24 15 15 13 20 19 13 22 15 Step 1 of 2: Find the value of the test statistic to test for a difference in the areas. Round your answer to two decimal places, if necessary. Step 2 of 2: Make the decision to reject or fail to reject the null hypothesis of equal average hourly wages in the three areas and state the conclusion in terms of…
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?
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
A toy manufacturer produces toys in five locations throughout the country. Raw materials (primarily barrels of powdered plastic) will be shipped from a new, centralized warehouse whose location is to be determined. The monthly quantities to be shipped to each location are the same. A coordinate system has been established, and the coordinates of each location have been determined as shown. Determine the coordinates of the centralized warehouse.
Pan American Refineries, headquartered in Houston, must decide among three sites for the construction of a new oilprocessing center. T he firm has selected the six fac tors listedbelow as a basis for evaluation and has assigned rating weights from I to 5 on each factor: Subhajit Chakraborty, the CEO, has rated each location for each factor on a 1- to I 00-point basis a) Which si te will be recommended based on total weighted scores?b) If location B's score for Proximity to port facilities was reset at 90, how would the result change?c) Wha t score would location B need on Proximity to port faci lities to change its ranking?
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 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 Which location should be selected and why?

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