1

# The objective of the transportation problem is to minimize the total cost of shipments, which is...

## Question

###### The objective of the transportation problem is to minimize the total cost of shipments, which is...

The objective of the transportation problem is to minimize the total cost of shipments, which is expressed the sum of the products shipment costs and amounts form the warehouses to the cities as follows.
How would you modify the Transportation Excel file that we used in the class to find a good solution to the problem? Can you come up with a good heuristic (rule of thumb) to find a good solution to this problem? Implement your solution in EXCEL and explain your heuristic.
Boston (BS) New York (NY) 20 13 Chicago (CH) Indianapolis (IN) Detroit (DT Pittsburgh(PT) Buffalo (BF) Supply Capacity 250 130 235 75 230 240 70 Boston (BS) 75 New York (NY 105 Chicago (CH) Indianapolis (IN) 70 Detroit (DT Pittsburgh(PT Buffalo (BF 130 110 240 Supply Used 250 130 235 125 230 Demand Satisfied 75 70 Demand Unsatisfied Total Cost- 7990

#### Similar Solved Questions

##### Which of the following influences the shape of the epidemic curve? A. Latency period B. Whether...
Which of the following influences the shape of the epidemic curve? A. Latency period B. Whether the exposure is removed gradually or suddenly. C. A point source or a continuous exposure D.All of the above influence the epidemic curve...
##### During isolation of b-carotene, if some of the sodium sulfate spilled over into the round bottom...
During isolation of b-carotene, if some of the sodium sulfate spilled over into the round bottom flask during decantation, how would that have affected the separation during column chromatography?...
##### Calculate the Yield to Maturity for a bond that has: A face value of \$100, a...
Calculate the Yield to Maturity for a bond that has: A face value of \$100, a current price of \$110, an annual coupon of 3.5%, and matures in six years....
##### Lasser Company plans to produce 14,000 units next period at a denominator activity of 28,000 direct...
Lasser Company plans to produce 14,000 units next period at a denominator activity of 28,000 direct labor-hours. The direct labor wage rate is \$12.00 per hour. The company's standards allow 2 yards of direct materials for each unit of product; the material costs \$9.50 per yard. The company's...
##### The Bronco Corporation exchanged land for equipment. The land had a book value of \$125.000 and...
The Bronco Corporation exchanged land for equipment. The land had a book value of \$125.000 and a fair value of \$160,000. Bronco paid the owner of the equipment \$15,000 to complete the exchange which has commercial substance Required: 1. What is the fair value of the equipment? 2. Prepare the journal...
##### Which of the following represent a major group that ratios are grouped into that make them...
Which of the following represent a major group that ratios are grouped into that make them easier to interrupt? a. Asset Management b. All of the above. c. Debt Management d. Profitability e. Liquidity...
##### Jackson MATH 1111 Fall19 (21422) Homework: Homework #9 Score: 0 of 1 pt 2.2.53 14 of...
Jackson MATH 1111 Fall19 (21422) Homework: Homework #9 Score: 0 of 1 pt 2.2.53 14 of 35 - 9x, but with the given maximum or minimum Write an equation in standard form of the parabola that has the same shape as the graph of f(x) = 9x or g(x) Macimum 4 at x -2 h(x) - 0...
##### STRUCTURE DETERMINATION PROBLEMS USING IR AND PROTON NMR SPECTROSCOPY Determine the structure of the six compounds...
STRUCTURE DETERMINATION PROBLEMS USING IR AND PROTON NMR SPECTROSCOPY Determine the structure of the six compounds whose IR and PMR spectra are provided on the attached sheets, given the following comments about the provided information and spectra. PMR Spectra: The PMR spectrum of each compound is ...
##### I need help with this. Thank you for your time. 4.2 Plot a rough sketch of...
I need help with this. Thank you for your time. 4.2 Plot a rough sketch of the three-dimensional vector field given by: F(x, y, z) = -(z2 + 1) Sketch the vector field on five plane that are parallel to and including z = 0....
##### What is the slope and intercept of #y+2.5=5.5x#?
What is the slope and intercept of #y+2.5=5.5x#?...
##### Review the structures below for a fatty acid. Recalling what you know about "like dissolves like"...
Review the structures below for a fatty acid. Recalling what you know about "like dissolves like" and the lab procedure, identify which of the following solvents would also be effective in extracting the fats from potato chips. *НО- НЬc — CH, Η Η Н...
##### (a) Taking the potential energy to be zero at infinite separation, find the potential energy of...
(a) Taking the potential energy to be zero at infinite separation, find the potential energy of a 30 kg object at the surface of the Earth. (Use 6.37 ✕ 106 m for the Earth's radius.) ________________J (b) Find the potential energy of the same object at a height above the Earth's surf...
##### 2. Design an idealized class B output stage, as shown in Figure 2, to deliver an...
2. Design an idealized class B output stage, as shown in Figure 2, to deliver an average of 25 W to an 82 speaker. The peak output voltage must be no larger than 80 percent of supply voltages Vcc. Determine: a) The required value of Voc b) The peak current in each transistor c) The power conversion ...