Which of the new possible plants should be opened

Assignment Help Operation Management
Reference no: EM131855596

Manaagerial Decision Modeling with Speadsheet

Introduction to Management Science.

Ashley's Auto Top Carriers currently maintains plants in Atlanta and Tulsa that supply major distribution centers in Los Angeles and New York. Because of an expanding demand, Ashley has decided to open a third plant and has narrowed the choice to one of two cities-New Orleans or Houston.

The pertinent production and distribution costs, as well as the plant capacities and distribution demands, are shown in the table.

from/to

LA

NY

NORMAL PRODUCTION

UNIT PRODUCTION



ATLANTA

8

5

600

6



TULSA

4

7

900

5



NEW ORLEANS

5

6

500

4

ANTICIPATED

HOUSTON

4

6

500

3

ANTICIPATED

FORECAST DEMAND

800

1200

2000




Which of the new possible plants should be opened?

Use Solver in Microsoft Excel to solve the question

Reference no: EM131855596

Questions Cloud

Patient with coronary artery disease : Ordered: Isoproterenol (Isuprel) IV inufsion 120 mcg/hr for a patient with coronary artery disease
How many different types of donor contacts to schedule : The athletic boosters club for Beaconville has planned a 2-day fund-raising drive to purchase uniforms for all the local high schools and to improve facilities.
Nursing interventions for the condition : State the risk factors, clinical presentation and nursing interventions for the condition, Lung Cancer.
Write procedure that get a specified number of float values : Write a procedure that will get a specified number of Float values from the keyboard and return their average.
Which of the new possible plants should be opened : Which of the new possible plants should be opened? Use Solver in Microsoft Excel to solve the question
How does hackler define rationing : 1) How does Hackler define rationing when it concerns healthcare product and services?
What makes the digital piracy of music so attractive : How can we, as criminal justice professionals, minimize digital piracy among this particular population?
Disabling intermittent claudicaiton : Which of the following medications should the primary care NP prescribe to treat this patient? Warfarin, Cilostazol, Pentoxifylline, Aspirin
Patient empowerment and principled behavior in nursing : Describe the relationship between patient empowerment and principled behavior in nursing.

Reviews

Write a Review

Operation Management Questions & Answers

  Should km be treating as a strategy or a task

What is KM governance and what role does it play in an overall KM strategy? Should KM be treating as a strategy or a task? Explain why?

  Discuss about the cost planning

1-Give at least 10 examples of resources for travel plan ? 2-Search the internet for "Cost Planning."

  Work breakdown structure-tasks-subtask and work package

What was the most complex project that you have been involved in? Give examples of the following as they pertain to the project: the work breakdown structure, tasks, subtask, and work package. Were you on the critical path? Did it have a good project..

  Describe their descope-lien list and cash reserve approaches

Describe their “de-scope,” “lien list,” and “cash reserve” approaches. How did a change in philosophy make such a drastic difference in project cost?

  Is law enforcement likely to discover his purchase of house

Joey Nariz is a narcotics trafficker who has made a career of smuggling cocaine into the United States. Over the years, he has bought most of his supply from Colombia but more recently had begun to obtain it in Peru. Is law enforcement likely to disc..

  Design a schedule of work sampling observations

Design a schedule of work sampling observations in which eight observations are made during one eight hour day

  Which allows firm to achieve economies of scale

What are the factors which allows firm to achieve economies of scale? What are the two ways through which firm can add capacity by using external capacity? What is meant by capacity flexibility and what are three ways by which firm can have flexible ..

  Their behavior be violation of law or regulation

What is the implication of each decision and would their behavior be a violation of law or regulation?

  Describe the potential advantages

Identify the methods dealing with resistance to change. Indicate when each method should be used and describe the potential advantages and disadvantages that are associated with using each method.

  Identify two different types of hospitals

Identify two different types of hospitals. Identify two Hospitals in Michigan.

  Researcher estimate of rate of return to schooling

Why is failure to control for cognitive ability among individuals in potential problem for credibility of researcher's estimate of rate of return to schooling?

  Working conditions in chinese factory

“Working Conditions in a Chinese Factory” , do you think the U.S. companies mentioned in this case need to make any changes to their current policies? If so, wh

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd