Case Description 1A retail giant is planning to build a new retail store in a Northeastern state. The company's analyticteam is considering communities A, B, and C for the new store. Actual site selection will be doneat a later date after the community selection is complete. The marketing analytics group selectedthe criteria shown in the following table:CommunitiesCriteriaABс289Labor SupplyTransportation879Proximity to a distribution center3105Cost of land/acre ($1000's)345977HousingCommunity Attitude1085For each criterion, a larger number indicates a higher preference, except for the cost metric.Answer question (a) using the information provided in Case Description 1.(a) What is the ideal value?i.(10, 10, 10, 10, 10, 10)(10, 10, 10, 0, 10, 10)ii.iii.(10, 10, 10, 10, 10, 10)iv.(9, 9, 10, 5, 9, 10)V.(9, 9, 10, 3, 9, 10)

Here, we could see that there are six criteria and three communities, There are two kinds of…

Answered: (a) What is the ideal value? i. ii.…

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.c) crossover analysis.
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 Market Coordinates Number of Segment x y Customers 1 5 22 2,200 2 17 20 300 3 5 3 1,400 4 10 3 3,000 Find the best location using the Center of Gravity Excel template. Round your answers to two decimal places. Cx: ____________Cy: ______________
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
Populate the relevant data Is any alternative never preferred? Complete a numeric locational cost-volume Indicate over what range each of the alternatives A, B, C is the low-cost choice Costs A B C Fixed ($) 2,500,000 2,000,000 3,500,000 Variable ($ per unit) 20+6 23+6 15+6
A company wants to enter into the business of manufacturing medical consumable items such as Mask, Gloves, Disposable Caps, Face shield, PPE Kits etc. It is looking for an appropriate site to set up the plant. Suggest the factors that may affect the set-up of manufacturing plant for medical consumable items. Give reason for each suggested factor that a company needs to consider while selecting a particular site.
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
What r ole does real estate market analysis play in determining the feasibility of specific locations for businesses?
Develop a background for James Shoe Emporium. Describe the following: location of thecompany – country and city/town, type of shoes sold and price, the target market.
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.
List 5 business uses of location analytics and in what way a business can use location data?
Mean and Median are two representative measures for identifying central location. What are the pros and cons of using these two measures? Which one is more vulnerable to outliers and why?
What would be important criteria for selecting a site for an IKEA store?

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

(a) What is the ideal value? i. ii. (10, 10, 10, 10, 10, 10) (10, 10, 10, 0, 10, 10) (10, 10, 10, -10, 10, 10) iv. (9, 9, 10, 5, 9, 10) (9, 9, 10, 3, 9, 10)