On the use of integer programming versus evolutionary solver in spreadsheet optimization

On the use of integer programming versus evolutionary solver in spreadsheet optimization

0.00 Avg rating0 Votes
Article ID: iaor20061392
Country: United States
Volume: 5
Issue: 3
Publication Date: Jan 2004
Journal: INFORMS Transactions on Education
Authors: ,
Keywords: heuristics, education in OR, spreadsheets
Abstract:

The introduction of the evolutionary solver in Frontline Systems' Premium Solver for Education allows students to use any functions in Excel for modeling optimization problems. As a result, instructors teaching optimization now face a dilemma of how much emphasis to place on “traditional” integer programming versus the unrestricted but heuristic approach of the evolutionary solver. Our goal in this work is to shed some light on the tradeoffs in these two modeling approaches. We discuss some experimental results comparing the two approaches for a number of well-known problem types. We also report some observations of student performance with these two different approaches.

Reviews

Required fields are marked *. Your email address will not be published.