BUAD 595 - Modeling & Analysis Modeling & Sim for Acctg

3

Designed to introduce students to basic modeling techniques that can be implemented with MS Excel. This course begins with an introduction to problem identification and formulation, sensitivity analysis, and the use of spreadsheets for constructing models. Includes the use of numerous internal Excel functions, as well as add-ins that can be found in Excel or purchased from outside vendors (Solver, @Risk®, Crystal Ball®, PHStats2, etc.) Techniques will also be developed that permit investigation of problems containing uncertainty by employing simulation- Monte Carlo simulation, discrete event simulation, what-if analysis, Scenarios and Goal Seeking. The course is about modeling and the subsequent analysis that is too often ignored.