Search

Example solution of the simplex method in Excel

Fill data

  1. Load file template for testing in Excel
  2. Open the file in MS Excel
  3. Using Mouse or the keyboard, go to the cell G4
  4. Execute Tools / Solver

    Simplex method

    If this command is not listed, you must run Tools / Add-Ins
  5. In the dialog box, specify:
    search type (maximum value)
    in field altering cell: $B$2:$D$2
    in field Limits add limit
    Field should read as follows:
    $B$2:$D$2>=0
    $G$6<=$F$6
    $G$7<=$F$7
    $G$8<=$F$8
  6. Click on Run

Using Excel Solver