Manaagerial decision modeling with speadsheetintroduction, Ask an Expert

Management Studies

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

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M92683953

Have any Question?Write your Review or question?

Related Questions in Operation Management

1 you are approached by a market researcher who asks you a

1. You are approached by a market researcher who asks you a series of questions about your favourite lunch options. To answer the questions you circle an option in a list or scale from one to five. What kind of research ...

1 list 4 advantages and 4 drawbacks an international

1. List 4 advantages and 4 drawbacks an international company (brewery) will have if it decides to cooperate with another company to enter and expend in this company's market. 2. When would a salesperson find the complim ...

Some risks are quantitative objective while others are more

Some risks are quantitative (objective), while others are more qualitative (subjective) in nature. Although quantifiable risks are often preferred as they provide certain data to support their impact, frequently leaders ...

Case study a good team playertopic leadershipinvolved

Case Study: A Good Team Player Topic: Leadership Involved Parties: Steven, Assistant Department Manager Kristin, Newly appointed supervisor of Steven's work team Having done well as a staff accountant in the accounts pay ...

1 choose an article that is not qualitative research give a

1. Choose an article that is not qualitative research. Give a brief overview of the article and why you think it is substantial. 2. The biggest international cross-over in recent years was Gangnam Style, whose popularity ...

Discuss your understanding of the captain of the ship

Discuss your understanding of the captain of the ship doctrine. Captain-of-the-Ship Doctrine is a principle of medical-malpractice law, holding a surgeon liable for the actions of assistants who are under the surgeon's c ...

1 celebrating success in an organization that is culturally

1. Celebrating success in an organization that is culturally diverse can be a challenge. For example, some cultures are very individualist, such as the United States, while other cultures are very collectivist. How would ...

1 explain your views and opinions about this statement

1. Explain your views and opinions about this statement: ‘If an organization has highly effective human resource management practices, a union is not necessary.’ Be sure to back up your views and opinions with evidence 2 ...

1 the society for human resource management now utilizes

1. The society for human resource management now utilizes the terms diversity and iclusiveness together why do you think that is the case what would you do to accomplish both simultaneously. 2. we cover the 2000 Election ...

1 what are the key components of return explain each

1. What are the key components of return? Explain each component. 2. Name five sources of risk which investors may face. 3. Define systematic risk and explain how it differs from nonsystematic risk? 4. List the three typ ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert