Conventional optimization solvers provide a single optimal solution to an optimization model, which in some cases is undesirable to the decision maker because of the large discrepancy between the optimal solution and the existing conditions of the real-world situation the model represents. This project focuses on developing an algorithm and computational program to generate solutions to binary integer optimization problems that can simultaneously improve the objective function value and yet control disruption from the current condition. The program uses Dinkelbach’s algorithm to determine such a solution, and is implemented in Excel utilizing Visual Basic for Applications (VBA) in conjunction with OpenSolver. Detailed instructions are included to guide users through the entire process.

• This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.

Creator

• Nguyen, Uyen Ngoc Thao

Publisher

• Worcester Polytechnic Institute

Identifier

• E-project-031114-153750

Advisor

• Konrad, Renata
• Trapp, Andrew C

Year

• 2014

Date created

• 2014-03-11

Resource type

• Major Qualifying Project

Major

• Industrial Engineering

Rights statement

• In Copyright