Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
Optimizing Child Push Chair Shipments: A Transportation Essay
Question
Answered
Optimizing Child Push Chair Shipments: A Transportation Essay
Answer in Detail
Solved by qualified expert

1.The Childfair Company has three plants producing child push chairs that are to be shipped to four distribution centres. Plants 1, 2 and 3 produce 12, 17, and 11 shipments per month, respectively. Each distribution centre needs to receive 10 shipments per month. The distance from each plant to the respective distribution centres is given below: 

The freight cost for each shipment is $85 plus 55 cents mile. How much should be shipped from each plant to each of the distribution centres to minimize the total shipping cost?
The above situation can be formulated as a transportation problem. Using the Solver tool in Microsoft Excel, we can obtain the optimal mix of shipments from each plant to each of the distribution centre.

Basically this is a linear programming exercise. The whole exercise of linear programming involves three elements:
Firstly the data is tabulated in the form given in Sheet 1 of the attached excel file. The decision variables are the optimal mix of shipments from each plant to each of the distribution centre. The per shipment costs from each plant to the different distribution centres are given.

5 More Pages to Come in This Document. Get access to the complete answer.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

question

Writing Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close