Explore BrainMass
Share

Explore BrainMass

    Excel Solver optimization translated into Lindo

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I have an optimization problem which is already solved using Excel solver, however, I need it to be solved with in lingo or lindo systems.

    every thing needed is described in the attached file

    © BrainMass Inc. brainmass.com October 10, 2019, 12:37 am ad1c9bdddf
    https://brainmass.com/math/optimization/excel-solver-optimization-translated-into-lindo-299435

    Attachments

    Solution Preview

    Student,

    Your LINDO solution is in two files:

    1] Practices.txt
    This is the LINDO output, which you can correlate to the Excel spreadsheet and see that the answer is the same, with allowances for some rounding out on the decimal places.

    2] Practices.ltx
    The .ltx extension is for opening in LINDO, but if you don't have LINDO, Notepad or any text file reader can read the file's contents, which are the objective function and it's constraints reproduced below. Some comments on LINDO syntax, which you may require

    a] ...

    Solution Summary

    LINDO solution is in two files:

    1] Practices.txt
    This is the LINDO output, which you can correlate to the Excel spreadsheet.

    2] Practices.ltx
    The .ltx extension is for opening in LINDO, but if you don't have LINDO, Notepad or any text file reader can read the file's contents, which are the objective function and it's constraints. Included is some comments on LINDO syntax.

    $2.19