Question

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
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
The objective of the transportation problem is to minimize the total cost of shipments, which is...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 4. A distributor received goods at five US ports, from which the goods are sent on...

    4. A distributor received goods at five US ports, from which the goods are sent on to ten major customers in the following ten cities: Salt Lake City, Las Vegas, Denver, St. Louis, Houston, Atlanta, Detroit, Boston, Baltimore, and Albany. Each customer has monthly demand of 300 cases. The monthly availability of the goods at the ports is shown in the table below: Ports = Seattle Oakland Norfolk Savannah New York Monthly Availability (cases) = 600 1000 500 400 500...

  • 38. Refer to the Baseball 2016 data, which report information on the 30 Major League Baseball teams for the 2016 season....

    38. Refer to the Baseball 2016 data, which report information on the 30 Major League Baseball teams for the 2016 season. Texas American 1994 144.31 2710402 95 4.37 0.262 215 2016 4.40 Toronto American 1989 112.90 3392299 89 3.78 0.248 221 Washington National 2008 166.01 2481938 95 3.51 0.256 203 At the .05 significance level, can we conclude that there is a difference in the mean salary of teams in the American League versus teams in the National League? At...

  • please solve this problem using excel and show steps please D. and the standard deviation of...

    please solve this problem using excel and show steps please D. and the standard deviation of this distribution. 71. FILE Refer to the Baseball 2016 data. Compute the mean number of home runs per game. To do this, first find the mean number of home runs per team for 2016. Next, divide this value by 162 (a season comprises 162 games). Then multiply by 2 because there are two teams in each game. Use the Poisson distribution to estimate the...

  • The Language Is SQL The language is SQL 13- List full details of agents with first...

    The Language Is SQL The language is SQL 13- List full details of agents with first names having exactly three or four letters sorted by the state attribute. 14- List the first name, the last name, the address, the city, the state, the branch number, and the email of agents working in the branch 8005 and having email addresses from yahoo.com. 15-List the first name, the last name, the address, the city, the state, the branch number, and the email...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT