Scribd
Upload
90 views1 page

Solving Transportation Problems in Excel

This document uses Excel to solve a transportation problem. It sets up a transportation table with costs to ship products from factories to warehouses and supply/demand amounts. It then applies the Excel solver to determine the optimal shipping amounts to minimize costs while meeting supply and demand. The solver outputs an updated transportation table with shipping amounts and a total minimum cost of 460.

Uploaded by

Hemant Sudhir Wavhal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
90 views1 page

Solving Transportation Problems in Excel

This document uses Excel to solve a transportation problem. It sets up a transportation table with costs to ship products from factories to warehouses and supply/demand amounts. It then applies the Excel solver to determine the optimal shipping amounts to minimize costs while meeting supply and demand. The solver outputs an updated transportation table with shipping amounts and a total minimum cost of 460.

Uploaded by

Hemant Sudhir Wavhal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

A B C D E F G H I J K L M N O P Q R S T U V W X

2 USING EXCEL TO SOLVE A TRANSPORTATION PROBLEM


3

4
5 set up the problem
6

7
8 transportation costs supply and demand flows
9

10 warehouses warehouses
11 W1 W2 W3 W4 W1 W2 W3 W4 supply
12 F1 10 0 20 11 F1 0 0 0 0 20
13 factories F2 12 7 9 20 factories F2 0 0 0 0 25
14 F3 0 14 16 18 F3 0 0 0 0 15
15 demand 10 15 15 20
16

17
18
19

20

21
22

23
24 apply solver
25

26
27 transportation costs supply and demand flows
28
29 warehouses warehouses
30 W1 W2 W3 W4 W1 W2 W3 W4 total supply
31 factories F1 10 0 20 11 factories F1 0 5 0 15 20 20
32 F2 12 7 9 20 F2 0 10 15 0 25 25
33 F3 0 14 16 18 F3 10 0 0 5 15 15
34 total 10 15 15 20
35 supply 10 15 15 20
36

37 TOTAL COST = 460 THESE ARE EQUALITIES


38

39
40

41

42
43

44 SUMPRODUCT (E31:H33,L31:O33)
45
46

You might also like