Scribd
Upload
11 views5 pages

MODI Method Template & Example Guide

The document provides a template and example for solving transportation problems using the MODI method. Users can input their own cost matrix, supplies, and demands in the 'Input' sheet, and view a worked example in the 'Vogel' and 'MODI' sheets. The document also offers assistance for solving specific problems by uploading relevant data.

Uploaded by

Susi Santy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views5 pages

MODI Method Template & Example Guide

The document provides a template and example for solving transportation problems using the MODI method. Users can input their own cost matrix, supplies, and demands in the 'Input' sheet, and view a worked example in the 'Vogel' and 'MODI' sheets. The document also offers assistance for solving specific problems by uploading relevant data.

Uploaded by

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

MODI Method Template & Worked Example (3x3)

How to use:
1. Open the 'Input' sheet and replace the example cost matrix, supplies, and demands with your problem data.
2. The file contains a worked example: 'Vogel' sheet (initial feasible solution by Vogel's Approximation)
and 'MODI' sheet showing iterations and final optimal allocation computed for the example.
3. If you want me to solve your specific problem, upload a clear photo or paste the cost matrix, supplies, and demands.

Note: This file is a template + example. Replace values on 'Input' and I'll re-run calculations if you want me to solve your spec
r problem data.

supplies, and demands.

ou want me to solve your specific data.


Factories W1 W2 W3
F1 8 6 10
F2 9 7 4
F3 3 4 2
Supply 35 50 15
Demand 30 30 40
Costs matrix
F1 8 6 10
F2 9 7 4
F3 3 4 2

Supplies 35 50 15
Demands 30 30 40

Initial allocation by Vogel's Approximation (example)


F1 5 30 0
F2 10 0 40
F3 15 0 0

Total cost o 515


Final allocation after MODI optimization (example)
F1 5 30 0
F2 10 0 40
F3 15 0 0

Total optim 515

Iterations summary (showing delta min each iter)


Iter 1 min delta 0

You might also like