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

Answers

The given solution is not optimal solution.

in the transportation problems there are three methods to calculate initial feasible solution.

1. northwest corner method (NWC)

2. Least cost method (LCM)

3. Vogel's approximation method (VAM)

the transportation cost of initial feasible solution through vogel approximation method will be least when compare to other two methods.

in the given question least cost method has been applied.

now VAM method shall be applied.

Algorithm for Vogel’s approximation method is as follows:
(i) Calculate penalties for each row and column by taking the difference between the smallest cost and next highest cost available in that row/column. If there are two smallest costs, then the penalty is zero.
(ii) Select the row/column, which has the largest penalty and make an allocation in the cell having the least cost in the selected row/column. If two or more equal penalties exist, select one where a row/column contains minimum unit cost. If there is again a tie, select one where maximum allocation can be made.
(iii) Delete the row/column, which has satisfied the supply and demand.
(iv) Repeat steps (i) and (ii) until the entire supply and demands are satisfied.
(v) Obtain the initial basic feasible solution.

solution:-

BOSTON NY CH IN SUPPLY PENALTY

DT 1575    20175 16 21 250 1 1 5 1

PT 25 1355 55 1170 130 6 6 2 2

BF 15 15 7235 17 235 8

DEMAND 75 230 240 70

PENALTY 0 2 2 6

10 7 11 10

10 7 10

7 10

according to above solution LEAST TRANSPORT COST is

DT to boston 15*75= 1125

DT to NY 20*175= 3500

PT to NY 13*55= 715

PT to CH 5*5= 25

PT to IN 11*70= 770

BF to CH 7*235= 1645

total least cost 7780


Similar Solved Questions

1 answers
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...
1 answers
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?...
1 answers
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....
1 answers
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...
1 answers
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...
1 answers
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...
1 answers
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...
1 answers
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 ...
1 answers
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....
1 answers
What is the slope and intercept of #y+2.5=5.5x#?
What is the slope and intercept of #y+2.5=5.5x#?...
1 answers
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, Η Η Н...
1 answers
(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 answers
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 ...
1 answers
Create a Matlab code to solve the two following equations for a pendulum: F = 10 m = 1 ks = 1 (m+M)x'' - ml'' cos + ml'' sin = F -x'' cos + l'' - g sin = 0 We w...
Create a Matlab code to solve the two following equations for a pendulum: F = 10 m = 1 ks = 1 (m+M)x'' - ml'' cos + ml'' sin = F -x'' cos + l'' - g sin = 0 We were unable to transcribe this imageWe were unable to transcribe this imageWe were unable to transcri...
1 answers
A football player punts the ball at a 49° angle. Without an effect from the wind...
A football player punts the ball at a 49° angle. Without an effect from the wind the ball would travel 62.0 meters horizontally. 16. +/2 points OSColPhys1 3.4.047 My Notes Ask Your Teacher A football player punts the ball at a 49° angle. Without an effect from the wind the ball would travel ...
1 answers
6. If the stresses and strains at a point in a linear elastic material are given...
6. If the stresses and strains at a point in a linear elastic material are given by σij = ε ⎛ ⎝ ⎜⎜ ⎞ ⎠ ⎟⎟ ⎛ ⎝ ⎜⎜ ⎞ ⎠ ⎟⎟ = 885 154 0 154 1038 615 0 615 577 0 002 0 001 0 0 001 0 003 0 004 0 0...
1 answers
7. Solve the system of equations: ii) X - 3 Y = 2 X - Y...
7. Solve the system of equations: ii) X - 3 Y = 2 X - Y = -2 Y= x - 1 X + Y = 11 iii) 2 X. +3Y=2 X - 2Y = 8...

-- 0.013268--