A spreadsheet scenario analysis technique that integrates with optimization and simulation

Scenario analysis is a widely used technique, and business students should be proficient in running scenarios through a spreadsheet model. We propose 10 desirable properties for a scenario analysis technique, and show that the Microsoft Excel Scenario Manager tool satisfies only one of them. We prov...

Ausführliche Beschreibung

Bibliographische Detailangaben

Veröffentlicht in:	Transactions on education 2009-09, Vol.10 (1), p.18
Hauptverfasser:	Grossman, Thomas A, Ozluk, Ozgur
Format:	Artikel
Sprache:	eng
Schlagworte:	Computer simulation Computer-generated environments Mathematical optimization Methods Monte Carlo method Spreadsheets
Online-Zugang:	Volltext
Tags:	Tag hinzufügen Keine Tags, Fügen Sie den ersten Tag hinzu!