Scribd
Upload
4 views3 pages

Distribution Network Design Using Solver Tutorial

The document outlines a procedure for designing a distribution network using Microsoft Excel to minimize transportation costs. It details the necessary software, steps to input data, and constraints to be applied in the Excel solver. The final steps involve solving the optimization problem and saving the results.

Uploaded by

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

Distribution Network Design Using Solver Tutorial

The document outlines a procedure for designing a distribution network using Microsoft Excel to minimize transportation costs. It details the necessary software, steps to input data, and constraints to be applied in the Excel solver. The final steps involve solving the optimization problem and saving the results.

Uploaded by

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

DISTRIBUTION NETWORK DESIGN USING MS EXCEL

Aim:

To design and develop a distribution network for minimizing transportation


cost using MS excel.

Software required:

Microsoft Excel with solver Add-in

Procedure:

 Open MS excel and click file  new.


 Enter the details of the distribution network as shown in the figure.
 Enter total distribution cost as follows in cell K20.

((B8*K7)+(B9*K8)+(C8*K9)+(C9*K10)+(D8*K11)+(E8*K12)+(F8*K13)
+(D9*K14)+(E9*K15)+(F9*K16))

 Enter the constraints as shown in the table below.

Constraints Formula
P1 (K7+K8)
P2 (K9+K10)
C1 (K11+K14)
C2 (K12+K15)
C3 (K13+K16)
W1 (P) (K7+K9)
W2 (P) (K8+K10)
W1 (C) SUM(K11:K13)
W2 (C) SUM(K14:K16)
 Once the data is entered, save the spread sheet.
 Click on the Data tab in the menu bar and click on the solver button.

 In the solver window, enter the details and constraints as shown below.

 Click solve button to generate solver solution for optimum solution.


 Save the results.

You might also like