1. A Company is deciding between two locations, Dubai & Berlin. At the micro-level, the company has a list of six criteria with preferences that are the suitability of building, access to the site, the supply of skills, attractiveness of the buildings, attractiveness of the area, and the potential for expansion. However, the company is not identified as the key success factor for both these locations. Question: Being a company's senior management, advice the company to consider the key success factors in Dubai and Berlin before making their decision.

1. A Company is deciding between two locations, Dubai & Berlin. At the micro-level, the company has a list of six criteria with preferences that are the suitability of building, access to the site, the supply of skills, attractiveness of the buildings, attractiveness of the area, and the potential for expansion. However, the company is not identified as the key success factor for both these locations. Question: Being a company's senior management, advice the company to consider the key success factors in Dubai and Berlin before making their decision.

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

QUESTION 2 1. Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in the coming year. He has four locations in mind. The costs information for these locations is in the following table. Locations Fixed Costs Variable Costs/unit a. i. ii. iii. A 60,000 30 B 80,000 20 с 100,000 15 D 130,000 10 Write an equation to represent the total costs for each location. Draw the total costs lines for each location on the same axes. (Use output ranges of 2000, 4000, 6000, 8000 etc. and intervals of $50,000 on the Y axis. Over what range of output is location A the most preferred location?
Question 1. Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in the coming year. He has four locations in mind. The costs information for these locations is in the following table.Locations A B C DFixed Costs 60,000 80,000 100,000 130,000Variable Costs/unit30 20 15 10 i. Write an equation to represent the total costs for each location.ii. Draw the total costs lines for each location on the same axes. (Use output ranges of 2000, 4000, 6000, 8000 etc. and intervals of $50,000 on the Y axis.iii. Over what range of output is location A the most preferred location?iv. Over what range of output is location B the most preferred location?v. Over what range of output is location C the most preferred location?
QUESTION 2 1. Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in the coming year. He has four locations in mind. The costs information for these locations is in the following table. Locations A Fixed Costs 60,000 Variable 30 Costs/unit a. iv. V. B 80,000 20 с 100,000 15 D 130,000 10 Over what range of output is location B the most preferred location? Over what range of output is location C the most preferred location?
Question 1: A Canadian company was able until now to meet the demand of its customers from its factory located in the Quebec region. Strong sales growth, however, is forecasted for next year in the two markets served by the company (1:Eastern Quebec, 2: Western Quebec). The company, therefore, is considering the construction of another plant for which two potential sites have been identified: one in Rimouski and the other in Longueuil. The collected data are provided in Table below. Quebec plant Rimouski platform Longueuil platform Potential market (ton) Transportation costs ($ per ton) Market 1 Market 2 600 400 200 700 700 1000 300 800 Production cost Capacity Fixed cost ($ per ton) $3800 $3500 $3600 (ton) 1000 1000 1000 ($1000) $4000 $5900 $6200 Products sold can be grouped in a single family and the average sale price of the products of this family is $50,000 per ton on both markets. (a) Draw an activity graph that corresponds to this context. (b) Propose an optimization model to…
Question content area Part 1 The fixed and variable costs for four potential plant sites for Brent Snyder's Ski Supplies are shown below: Site Fixed Cost Per Year Variable Cost Per Unit Atlanta $120,000 $5 Burlington 70,000 4 Cleveland 95,000 3 Denver 45,000 11 Part 2
Questions i. Calculate the weighted score for each alternative location. ii. Which location should be chosen?
17. A company has established a project team to identify a location for a new manufacturing facility. Use a weighted scoring model to analyze three candidate locations (A, B, C) for setting up the new factory. The relative weights for each criterion are shown in the following table. A score of 1 represents unfavorable, 2 satisfactory, and 3 favorable. Location Category Weight A В Labor costs Labor productivity Labor supply Union relations Material supply Transport costs Infrastructure 20 20 10 10 10 25 5 1 2 3 3 1 2 1 3 3 3 2 2 1 1 1 2 3 2 2 2 889
Q 3 locations have been identified as suitable options for building a new factory. The fixed and variable costs for each of the 3 potential locations has been estimated. Identify the best location when a) Demand estimate is 2000 units b) Demand estimate is 3500 units and c) Identify point of indifference between B and C (Rupees) (Rupees) Location Annual Fixed Cost Unit Variable Cost A 5,00,000 300 B 7,50,000 200 C 9,00,000 100
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
Q4/ Let us assume that a new manufacturing plant, is to be located in Berlin. The location factors, factor rating and scores for three potential sites are shown in the following table. (1) Discuss the data of the table. (2) Which is the best location based on factor rating method? SI. No. Location factor Weight Scores Location 1 24 Location 2 Location 3 Facility utilization Total patient km per month Average time per emergency trip Land and construction costs Employee preferences 1. 2. 28 29 30 16 33 26 30 3. 27 20 20 27 4. 13 13 12 13 5. 10 3 5 2
Question 2 Acme Fasteners desires to locate a new facility. Based on preliminary analysis, the choice has been reduced to four locations: A, B, C, and D. These four locations were rated on a scale from 1 (worst) to 10 (best) on each of four criteria. Each criterion was also weighted to indicate its importance (i.e., the higher the weight, the more important). The list of ratings and weights follows. Based on weighted scores, where should Acme locate its new facility?
Question 2 SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 5 states listed below. There are four potential sites for home offices: Los Angeles, Tulsa, Denver, and Seattle. The annual fixed cost of locating an office in Los Angeles is $165,000, Tulsa is $131,000, Denver is $140,000, and Seattle is $145,000. The expected number of trips to each state and the travel costs from each potential site are shown below. Each consultant is expected to take at most 40 trips each year. If at most 3 consultants are to be assigned to a home office, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of this network? Washington Oregon California Idaho Nevada Los Angeles 150 150 75 150 100 Travel cost ($) Tulsa Denver 250 200 250 200 200 150 200 125 200 125 Seattle 25 75 125 125 150 Number of trips required 40 35 100 25 40 Tips: The limit number of…