Solving electronic spreadsheet models by interactive multicriterion optimization: a budgeting illustration

Abstract

In previous papers a connection between general spreadsheet models and interactive multicriterion optimization has been discussed. The purpose of the present paper is to provide proof of the concept with a detailed example. The main idea is that interactive multicriterion optimization can be viewed as a new way of interacting with spreadsheet models. It offers advantages over the two prevailing ones, namely what-if and goal-seeking. A simplified budgeting example is given to clarify this connection. Directions of improvement are assumed to be provided by the decision maker using one of the several existing methods. One improvement iteration is illustrated and analyzed following the method of Loganathan and Sherali.

Keywords:

• spreadsheet models
• man–machine interaction
• interactive multicriterion optimization
• what-if
• goal-seeking
• decision support systems