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.

User Account

All Pages