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

~m8h5q2~
Brian Trump has obtained fixed- and variable-cost information for four potential sites for his professional wrestling school and summarized it in tabular form below. All values are in dollars. Site Fixed Cost Variable Cost A 10,000 24 B 12,000 20 C 14,000 18 D 16,000 17 Brian plans to charge the same amount for tuition regardless of where he decides to establish his school. If he believes that 700 students will matriculate each year, which site will result in the lowest total cost?
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
Given is a decision payoff table. Alternatives Low Future Demand Moderate High 91 130 102 81 Small Facility 111 Medium Facility 51 Large Facility -12 124 126 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. e) If the probabilities for Future Demand when it is Low = 0.35, Moderate = 0.30, and High = 0.35, the best decision under risk is to select Blank 5 facility.
A plastic manufacturing company is considering 2 alternative locations for a new facility. The management considered 2 alternatives: Sta. Rosa and Sta. Rita. The fixed costs for Sta. Rosa is Php1M and variable cost is Php25 per unit. On the other hand, the fixed costs for Sta. Rita is Php1.5M and variable cost is Php23 per unit. 1. If the company plans on producing 50,000 units which location would be more attractive? 2. At what volume the two alternatives equal in cost?
The least cost theory is based upon finding the location with the lowest marginal and average total cost. True or False?
On the cost- volume analysis chart where the costs of two or more location alternatives have been plotted, the quantity at which two cost curves cross is the quantity at which:a) fixed costs arc equal for two alternative locations.b) variable costs are equal for two alternative locations.c) total costs are equal for all alternative locations.d) fixed costs equal variable costs for one location.c) total costs are equal for two alternative locations.
The Skulls, a student social organization, has two different locations underconsideration for constructing a new chapter house. Skull's president, a POM student, estimates that due to differing land costs, utility rates, etc., both fixed and variable costs would be different for each of the proposed sites, as follows: Location Annual Fixed Variable Alpha Ave $5000 $200 per person Beta Blvd $8000 $150 per person If it is estimated that thirty persons will be living in this new chapter house, which location should the Skulls select?
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 manufacturing company preparing to build a new plant is considering three potential locations for it. The fixed and variable costs for the three alternative locations are presented in the table below. Table 1 Costs A B C Fixed 500,000 600,000 800,000 Variable 40 30 20 Indicate over what range, each of the alternatives A, B, C is the low-cost choice. b) A larger and more modern post office is to be constructed at a new location in Sally Spring Georgia. Growing suburbs caused a shift in the population density from where it was 30 years ago when the current facility was built. Andy Browne, the postmaster asked his assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office are shown in the table below. Mail Source Point Round Trips per day X coordinate Y coordinate 1 6 2 8 2…
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 ] > >
Peter Billington Stereo, Inc., supplies car radios to auto manufacturers and is going to open a new plant. The company is undecided between Detroit and Dallas as the site. The fixed costs in Dallas are lower due to cheaper land costs, but the variable costs in Dallas are higher because shipping distances would increase. Dallas $600,000 $27/radio Detroit $840,000 $21/radio a) Based on the analysis of the volume, after rounding the numbers to the nearest whole number, Dallas is best below and Detroit is best above 40,000 b) Dallas's fixed costs have increased by 10%. Based on the analysis of the volume, after rounding the numbers to the nearest whole number, Dallas is best below and Detroit is best above Fixed costs Variable costs radios radios

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