1 / 9

Operational Decision-Making Tools: Transportation Model

Chapter 10 Supplement. Operational Decision-Making Tools: Transportation Model. Operations Management - 5 th Edition. Roberta Russell & Bernard W. Taylor, III. Lecture Outline. Transportation Model. Transportation Model.

waite
Download Presentation

Operational Decision-Making Tools: Transportation Model

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 10 Supplement Operational Decision-Making Tools: Transportation Model Operations Management - 5th Edition Roberta Russell & Bernard W. Taylor, III

  2. Lecture Outline • Transportation Model

  3. Transportation Model • A transportation model is formulated for a class of problems with the following characteristics • a product is transported from a number of sources to a number of destinations at the minimum possible cost • each source is able to supply a fixed number of units of product • each destination has a fixed demand for product • Solution Methods • stepping-stone • modified distribution • Excel’s Solver

  4. Transportation Method: Example

  5. Transportation Method: Example

  6. How to Solve Using Excel • Input by hand • OM Tools Macro

  7. Caution Using Excel’s Solver • MS Excel’s default solver is NOT industrial strength • It will not always give you the correct answer • It can be frustrating

  8. Alternative Solvers • CPLEX by ILOG • Considered the best • XPRESS MP by Dash Optimization • Frontline (www.solver.com) • XA • Lindo • Lp_solve • An open source solver that I personally use and like • COIN-OR (www.coin-or.org)

  9. Algebraic Modeling Languages • MPL by Maximal Software • GAMS (www.gams.com) • AIMMS (www.aimms.com) • AMPL (www.ampl.com) • MathProg • An open source subset of AMPL

More Related