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

M D Troutt (), B K Yew and A Zhang
Additional contact information
M D Troutt: Kent State University
B K Yew: Arkansas Tech University
A Zhang: Southern Illinois University

Journal of the Operational Research Society, 2001, vol. 52, issue 5, 576-583

Abstract: 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 (search for similar items in EconPapers)
Date: 2001
References: Add references at CitEc
Citations:

Downloads: (external link)
http://link.springer.com/10.1057/palgrave.jors.2601125 Abstract (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:pal:jorsoc:v:52:y:2001:i:5:d:10.1057_palgrave.jors.2601125

Ordering information: This journal article can be ordered from
http://www.springer. ... search/journal/41274

DOI: 10.1057/palgrave.jors.2601125

Access Statistics for this article

Journal of the Operational Research Society is currently edited by Tom Archibald and Jonathan Crook

More articles in Journal of the Operational Research Society from Palgrave Macmillan, The OR Society
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().