Question: Solve using Excel or AMPL , Now handwritten solution please Solve problem 1 using Excel or AMPL. Submit supporting work. 1. The Childfair Company has

Solve using Excel or AMPL , Now handwritten solution please

Solve using Excel or AMPL , Now handwritten

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 Distribution Center (miles) 1 2 3 4 1 800 1,300 400 700 Plant 2 1,100 1,400 600 1,000 3 600 1,200 800 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!

-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...

-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...

Question 2 The Childfair Company has three plants producing child push chairs that are to be shipped to four distribution centers. Plants1, 2, and 3 produce 12, 17, and 11 shipments per month,...

What are the biggest ah-ha! moments from Oracy Development? 6 English-Language Oracy Development Learning Outcomes After reading this chapter, you should be able to ... . Describe the basics of...

1. Situation In this section of the case analysis, you will focus on identifying situational aspects that have led to the situation being reported in the case. These aspects should include relevant...

You have been hired as a consultant to help Ford Motor Company return to its glory days, when either Henry Ford or Alan Mulally ran the company. In doing so, you must produce a short report to Jim...

3 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....

I am looking for the solution or guidance with the following case study. The case study has been asked about by other students but I cannot find the solution. can you direct me to it or provide some...

a. Write the thermochemical equation for the reaction described in Exercise 6.3 for the case involving 1 mol N2H4. b. Write the thermochemical equation for the reverse of the reaction described in...

On March 17, Door Products Inc. sold building materials to Mar Homebuilding for $15,000 with terms of 3/10 n/20. What amount did Door Products Inc. record as revenue on March 25 when Mar paid for the...

Analysts must not engage in practices that distort prices or artificially inflate trading volume with the intent to mislead market participants. True False

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...