Page 363 -

EXCEL SOLUTION OF TRANSPORTATION, ASSIGNMENT AND TRANSSHIPMENT PROBLEMS 343

Right-Hand Sides The right-hand sides of the constraints represent the supply
at each node. Cells K7:K14 are reserved for these values.
(Note the negative supply at the four demand nodes.)

Excel Solution
The solution can be obtained by selecting Solver from the Tools menu, entering
the proper values into the Solver Parameters dialogue box, selecting Standard
Simplex LP and specifying the option Assume Non-Negative.Then click Solve.
The information entered into the Solver Parameters dialogue box is shown in
Figure 7.19.

Figure 7.19 Solver Parameters Dialogue Box for the Ryan Problem

Copyright 2014 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has
deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.