A decision support methodology for stochastic multi-criteria linear programming using spreadsheets

A decision support methodology for stochastic multi-criteria linear programming using spreadsheets

0.00 Avg rating0 Votes
Article ID: iaor20043329
Country: Netherlands
Volume: 36
Issue: 1
Start Page Number: 99
End Page Number: 116
Publication Date: Sep 2003
Journal: Decision Support Systems
Authors: ,
Keywords: artificial intelligence: decision support, decision theory: multiple criteria, stochastic processes, spreadsheets
Abstract:

In recent years, tools for solving optimization problems have become widely available through the integration of optimization software (or solvers) with all major spreadsheet packages. These solvers are highly effective on traditional linear programming (LP) problems with known, deterministic parameters. However, thoughtful analysts may rightly question the quality and robustness of optimal solutions to problems where point estimates are substituted for model parameters that are stochastic in nature. Additionally, while many LP problems implicitly involve multiple objectives, current spreadsheet solvers provide no convenient facility for dealing with more than one objective. This paper introduces a decision support methodology for identifying robust solutions to LP problems involving stochastic parameters and multiple criteria using spreadsheets.

Reviews

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