Share
Explore BrainMass

Excel Solver optimization translated into Lindo

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

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