Use excel and develop a distribution plan that minimizes, Ask an Expert

Management Studies

Consider the following transportation table where the values in the upper-right-hand corner of each cell represent unit shipping cost:

To: Warehouse Warehouse Warehouse

From: # 1 # 2 # 3 Supply

Plant A 50 32 40 700

Plant B 16 30 20 200

Plant C 35 28 42 200

Demand 300 400 400

a. Formulate it as a linear programming problem.

b. Use Excel and develop a distribution plan that minimizes total shipping cost.

c. If route 3-A is a unacceptable for some reason, what distribution plan would be optimal? What would its total cost be?

View complete question

Business Management, Management Studies

Category:- Business Management
Reference No.:- M988344

Have any Question?Write your Review or question?

Related Questions in Business Management

How could legislation impact on operations within your

How could legislation impact on operations within your organisation in relation to innovation, project management, and operational planning? Briefly outline any relevant requirements (e.g. intellectual property, WHS).

Information systemsdirections answer the following if you

Information Systems Directions: Answer the following: If you were asked to develop a logical model of the registration system at a school, would it be better to use a top-down or bottom-up approach? Explain your reasonin ...

If there is a market for leather but a new synthetic

If there is a market for leather but a new synthetic product that can replace leather in briefcases, furniture, etc. is introduced into the market but it cannot replace leather in shoes how will this affect supply and de ...

What are the costs and benefits to a country if they joined

What are the costs and benefits to a country if they joined the Eurozone?

In light of the winners curse must winning bidders in

In light of the winner's curse, must winning bidders in auctions necessarily "lose" in the sense of paying more than the acquired firm (or product) is worth? What steps can bidders take to prosper in auctions and/or corp ...

1 how could a manager educate stakeholders on effective

1) How could a manager educate stakeholders on effective risk management? 2) How risk management should relate to the scope, schedule and budget?

1 what are sources of power for managers2 how does power

1. What are sources of power for managers? 2. How does power relate to emotional intelligence? 3. How can they both be used in providing vision and direction for an organization and its employees?

How peoples upbringing and values when faced with an

How people's upbringing and values when faced with an ethical decision, whether it is in a business environment or not. How are our beliefs the same as or different than those of our parents or birth community? Has knowl ...

Discuss the link between strategy and performance select an

Discuss the link between strategy and performance. Select an industry and discuss 2 rival firms in that industry and how they illustrate the difference between strategy and performance

Fill the following table for cookies sold in a bakery

Fill the following table for cookies sold in a bakery. Indicate by a checkmark which customer requirements and which technical requirements are related. Use "âˆš" to show the relation and "x" to indicate that there is no ...

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 Business Management Expert