Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 2 4 6 8 10 14 16 18 20 Q (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.

Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 2 4 6 8 10 14 16 18 20 Q (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.

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

b. An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 6 8 10 14 16 18 20 0 (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
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
What are the three steps to locational cost–volume analysis?
1. What is the right business location? 2. What are the general criteria in selecting business location? Note: Please cite your reference
Dennison Manufacturing makes large helical springs used inaircraft landing gear. The company has narrowed its potentialchoices for its new manufacturing facility to four cities. Thefollowing information is known about the manufacturing andshipping costs of locating in each of these four cities: a. Use break-even point analysis to determine where Den-nison should locate.b. Based solely on break-even quantity, if Dennison’s manu-facturing forecast for the foreseeable future is 40,000 unitsannually, where should he locate?
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
Which of the following techniques works for location analysis for both service/retail/professional organizations as well as goods-producing organizations? A. Transportation method B. Traffic counts C. Factor-rating method D. Demographic analysis of drawing area.
b. A food manufacturer wants to locate a warehouse to serve its major customers.The customers, annual volume and the X and Y coordinates are shown in thetable below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc. 25 3 7Zac Supermarket 13 5 2Harry Inc. 6 8 4Sky Productions 4 1 5 i. Using the centre of gravity location technique, determine the locationcoordinates that will minimize the transportation costs for their family ofproducts
b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc 25 3 7 Zac Supermarket 13 5 2 Harry Inc. 6 8 4 Sky Productions 4 1 5 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products
Given is a decision payoff table. Alternatives Small Facility Medium Facility Large Facility Low 26 18 -7 Future Demand Moderate 21 31 30 High 18 22 42 a) The best decision under uncertainty using MAXIMAX is to select Blank 1 facility b) The best decision under uncertainty using MAXIMIN is to select Blank 2 facility c) The best decision under uncertainty using LAPLACE/EQUALITY LIKELY is to select Blank 3 facility d) If the probabilities for Future Demand when it is Low-0.35, Moderate -0.30, and High-0.35, the expected monetary value (EMV) for the large facility-Blank 4.
Explain the a ssumptions behind the center-of-gravity method. How can the model be used in a service facility location?
b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y- Coordinate Judy inc 25 3 7 Zac Supermarket 13 5 2 Harry Inc 6 8 4 Sky Production 4 1 5 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.