Question: -Transportation Model: **Please, Show all the Excel steps clearly for this problem. Solve problem 1 using Excel or AMPL. Submit supporting work. 1. The Childfair

-Transportation Model:**Please, Show all the Excel steps clearly for this problem.

Solve problem 1 using Excel or AMPL. Submit supporting work. 1. The Childfair Company has three plants producing child push chairs that are to be shipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipments per month, respectively. Each distribution center needs to receive 10 shipments per month. The distance from each plant to the respective distributing is given below: Distance (miles) 1 Plant 2 3 Distribution Center 1 2. 3 800 1,300 400 1,100 | 1,400 600 600 1,200 800 4 700 1,000 900 The freight cost for each shipment is 50 cents per mile. How much should be shipped from each plant to each of the distribution centers to minimize the total shipping cost. a. Formulate this problem as a transportation model. b. What is the optimum shipping model to minimize monthly costs

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Section A - Transportation Model (25 Points) Solve problem 1 using Excel or AMPL. Submit supporting work. 1. The Onenote Co. produces a single product at three plants for four customers. The three...

-Transportation Model: Solve problem 1 using Excel or AMPL. Submit supporting work. 1. The Childfair Company has three plants producing child push chairs that are to be shipped to four distribution...

Background: Poseidon Corporation is a sailboat producing company. The company needs to establish a plan for production for the next four quarters. The sailboat demand for the first second, third, and...

Background: Poseidon Corporation is a sailboat producing company. The company needs to establish a plan for production for the next four quarters. The sailboat demand for the first, second, third,...

operation researches Background: Poseidon Corporation is a sailboat producing company. The company needs to establish a plan for production for the next four quarters. The sailboat demand for the...

By MARK@ (Ruska, Markevichus, Naniev, Grachev) Emerging russian ice-cream market is good area for different producers as it has great potential 1. Currently Russian ice-cream market is the 4th...

Support System for Production Scheduling. Solve this Mixed-Integer Programming Model problem with using following informations- notations and following Excel Spreadsheets that you can see in the...

please show solution for either option 1, 2 or 3 using excel spread sheet. thank you Recently, I noticed that our powerplant was producing too much air pollution. I offered a few explanations to our...

A restaurant critic goes to a place twice. If she has an unsatisfactory experience during both visits, she will go once more. Otherwise she will make only the two visits. Assuming that the results...

8. The table below presents data for CGS and ending inventory for the last six months of the most recent fiscal year for Claire Bear, Inc. July CGS $100 Inventory $40 August $150 $50 - September...

Sunk costs are always relevant in decision making. True False

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...