1 / 9

Solving LP’s using Microsoft Excel™

Learn how to solve Linear Programming (LP) problems using Microsoft Excel and common LP solvers – LINDO, CPLEX, AMPL, OSL. Set up Excel, link solver libraries, input problem data, run solver, and interpret results. Advance your optimization skills easily!

graciaj
Download Presentation

Solving LP’s using Microsoft Excel™

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. Solving LP’s using Microsoft Excel™ Common LP Solvers: Commercial: LINDO, CPLEX, AMPL, OSL, … Free software: Several available on web, e.g. try: google search: java LP solver

  2. Setting up Microsoft Excel™ Step 0: Link the solver libraries MS Excel  Tools  Add-Ins…  Solver Add In Step 1. Set up the Problem data Step 2. Set up the solver data Step 3. Solve Step 4. Study results

  3. z( x, y) = 15 x + 10y Step 1. Set up problem data max z( x, y) = 15 x + 10y [objective] s.t. 2x + y ≤ 1500 [Urea] x + y ≤ 1200 [Potash] x ≤ 500 [Rock phosphate] x ≥ 0, [non-negativity] y ≥ 0 [non-negativity]

  4. 2x + y ≤ 1500 [Urea] Step 1. Set up the Problem Data max z( x, y) = 15 x + 10y [objective] s.t. 2x + y ≤ 1500 [Urea] x + y ≤ 1200 [Potash] x ≤ 500 [Rock phosphate] x ≥ 0, [non-negativity] y ≥ 0 [non-negativity]

  5. Step 2. Set up the Solver Data Step 2.1 Tools  Solver… Step 2.2 Objective function

  6. Step 2. Set up the Solver Data.. Step 2.3 Specifying the variables

  7. Step 2. Set up the Solver Data… Step 2.4 Specifying the constraints

  8. Step 3. Solve Complete problem specification

  9. Step 4. Study the results How much Type A to produce Optimum profit How much Type B to produce How much raw material we should order These reports give some more useful information

More Related