5. Company Z wants to find a new place for a distribution center. They recently had some researchand feasibility studies around the city and came up with four candidate locations. They were ableto collect all the relevant costs of this investment under two main categories: fixed costs andvariable costs. Based on the analysis the list of each cost type for all candidate locations are asfollows:FixedVariableCostCost125000Alternative A27Alternative B175000 30Alternative Ċ150000 20Alternative D 200000 13a. Using the above table please approximate total cost of each investment candidate with alinear equation and write them for all four them.b. Please plot all of the equations you listed above on a two dimensional graph consideringmaximum yearly operation quantity/volume can be maximum 10000 units. (Hint: use totalcost as y axis and the yearly operating quantity/volume as the x axis)c. Indicate which one(s) are the preferable option in terms of cost based on the total cost plotyou have provided above.d. Calculate the exact quantities that change preferred alternative on the graph (i.e. theintersection points of the lines which belong to least cost alternatives)

A) Let the annual operation volume =x Linear equation for the total cost of alternative A (y): Y\…

Answered: 5. Company Z wants to find a new place…

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

During a major expansion in 2004, Douwalla’s Import Company developed a new processing line for which the delivered equipment cost was $1.75 million. This year, the board of directors decided to expand into new markets and expects to build the current version of the same line. Estimate the cost if the following factors are applicable: construction cost factor is 0.20, installation cost factor is 0.50, indirect cost factor applied against equipment is 0.25, and the total plant cost index has risen from 2509 to 3713 over the years.
A firm is considering three different locations in which to build a factory. The costs associated with each location are given below. Location A B C Fixed Costs 500 700 900 Variable costs per unit 10 6 4 2. What level of output will each location be preferred? 3. Write an equation to represent the costs for each location. 4. Use algebra to determine the crossover points
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 ] > >
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 D fixed costs 60,000 80,000 100,000 130,000 variable costs/units 30 20 15 10 i. Draw the total costs lines for each location on the same axes. (Use output ranges of 200, 400, 600, 800 etc. and intervals of $50,000 on the Y axis. ii. Over what range of output is location A the most preferred location? iii. Over what range of output is location B the most preferred location? iv. Over what range of output is location C the most preferred location?
PetSmart and PetCo are two major competitors offering pet supplies and pet food. Given the location decisions of PetSmart and PetCo in this city, you conclude that: a. PetSmart focuses on raising its quantity sold rather than raising its profit margin on each unit. b. PetSmart and Petco engage in intense price undercutting. c. PetSmart and PetCo differentiate themselves by location. d. PetCo chose its location primarily using demand side considerations.
Problem 8-10 Factor Initial cost Traffic Maintenance Dock space Neighborhood Location East #1 East #2 West Weight East #1 100 60 20 24 15 0 00 00 N West East #1 East #2 8 8 4 4 2 East #2 110 35 25 24 9 a. Using the above factor ratings, calculate the composite score for each location. West 110 35 Composite Score 25 13 11 b. Determine which location has the highest composite score:
Problem 8-4 (Algo) A company that produces pleasure boats has decided to expand one of its lines. Current facilities are insufficient to handle the increased workload, so the company is considering three alternatives, A (new location), B (subcontract), and C (expand existing facilities). Alternative A would involve substantial fixed costs but relatively low variable costs: fixed costs would be $285,000 per year, and variable costs would be $570 per boat. Subcontracting would involve a cost per boat of $2,570, and expansion would require an annual fixed cost of $59,000 and a variable cost of $1,040 per boat. a. Find the range of output for each alternative that would yield the lowest total cost. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the nearest whole number.) A B с Answer is not complete. or to to more b. Which alternative would yield the lowest total cost for an expected annual volume of 70 boats? C. What other factors might be…
A firm is considering three different locations in which to build a factory. The costs associated with each location are given below. Location A B C Fixed Costs 500 700 900 Variable costs per unit 10 6 4 Plot the crossover chart for the locations. What level of output will each location be preferred? Write an equation to represent the costs for each location. Use algebra to determine the crossover points.
Northeastern Insurance Company is considering opening an office in the U.S. The two cities under consideration are Philadelphia and New York. The factor ratings (higher scores are better) for the two cities are given in the following table. Factor Weight Philadelphia New York Customer convenience 0.25 70 80 Bank accessibility 0.20 40 90 Computer support 0.20 85 75 Rental costs 0.15 90 55 Labor costs 0.10 80 50 Taxes 0.10 90 50 Based on the given information, the best location for Northeastern Insurance Company to open the office is with a total weighted score of (Enter your response as a whole number.)
A car manufacturing company wants to start its manufacturing unit in Malaysia. For this, it selects three appropriate cities. Choose the best location for its manufacturing plant. Factors Factor Rating | Location 1 Location 2 Location 3 Labor availability 6. Facility of transportation 4 Closeness to supplies 4 3 4. 3 Basic amenities 8. 7 6. Land availability 3 4 Tax benefits 3 Preference of the owner 4. 3 4. 4. Climate conditions 4. No attempt
Please do not give solution in image formate thanku.
7

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