Scenario Analysis in Spreadsheets with Excel's Scenario Tool

INFORMS Transactions on Education

Susan W. Palocsay¹  Ina S. Markham¹ 

[1] CIS & MS Department, MSC 0202, College of Business, James Madison University, Harrisonburg, Virginia 22807

关键词: sensitivity analysis;    teaching scenario analysis;    teaching MS;    breakeven analysis;    queuing;    decision analysis;   

DOI  :  10.1287/ited.6.2.23

学科分类：社会科学、人文和艺术（综合）

来源: INFORMS

【 摘 要 】

“What-if” or sensitivity analysis is one of the most important and valuable concepts in management science (MS). To emphasize its practical relevance in a business environment, we teach students in our introductory MS course to analyze “scenarios” with Excel's built-in Scenario tool. This paper demonstrates the application of the Scenario tool with several examples.

【 授权许可】

CC BY