Question: please excel sheet solution... 3. Three industrial sites are considered for locating manufacturing plants. The plants send their supplies to three customers. The supply at

please excel sheet solution... 3. Three

please excel sheet solution...

3. Three industrial sites are considered for locating manufacturing plants. The plants send their supplies to three customers. The supply at the plants, the demand at the customers, and the unit transportation cost from the plants to the customers are given in the follow- ing table. Unit transportations cost ($) Customer 2 2 3 Supply Plant 1 2 3 10 17 15 15 14 10 12 20 11 1800 1400 1300 Demand 1200 1700 1600 In addition to the transportation costs, fixed costs are incurred at the rate of $12,000, $11,000, and $12,000 for plants 1,2, and 3, respectively. Formulate the problem as an ILP and find the optimum solution

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!

please solution 3. Three industrial sites are considered for locating manufacturing plants. The plants send their supplies to three customers. The supply at the plants, the demand at the customers,...

4. Three industrial sites are considered for locating manufacturing plants. The plants send their supplies to three customers. The supply at the plants, the demand at the customers, and the unit...

Three industrial sites are considered for locating manufacturing plants. The plants send their supplies to three customers. The supply at the plants, the demand at the customers, and the unit...

9-31. Three industrial sites are considered for locating manufacturing plants. The plants send their supplies to three customers. The supply at the plants, the demand at the customers, and the unit...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

PLEASE PROVIDE EXPLANATIONS FOR ALL YOUR ANSWERS TO ENSURE YOU CAN RECEIVE PARTIAL CREDIT. Q1 (15 points) A concrete company transports concrete from three plants, 1, 2 and 3, to three construction...

y"+16y= cos(41) !! 7. Solve the initial value problem y(0)=1 using the Laplace r(0)=1 transform. No credit for methods from Chapter 4.

Give an example of why using units, rather than the value of the products produced, in the numerator of a productivity ratio may give a misleading picture of the process that produced that output.

list 2 expenses that are included in the operating expense budget but are excluded from cash payments of operating expenses

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