Spreadsheet modelling for management decision making

Abstract

Considers the potential use of spreadsheets as decision‐support systems (DSS). Commences by considering the nature of DSS and the advantages and disadvantages of spreadsheets as DSS, and then proceeds to consider and illustrate some of the models that can be easily built with modern spreadsheet packages, including models to support what‐if or scenario analysis, sensitivity analysis, goal seeking and optimization. Develops detailed examples using Excel, but most of the features used in model building in these examples are also available in recent releases of other spreadsheet packages.