Spreadsheet Modeling and Simulation
SPREADSHEET MODELING AND SIMULATION
Instructor: Yanjun Li, office: KRAN 422, phone: 494-4525, e-mail: firstname.lastname@example.org
Office Hours: Tuesday 1:00 – 4:00 pm, or by appointment.
Course Packet: The course packet contains cases and readings from various sources.
Textbook: David Hartvigsen, SimQuick: Process Simulation with Excel, 2nd Edition, Prentice Hall, 2004. (ISBN: 0-13-107880-1)
References: Law, A. M. and W. D. Kelton, Simulation Modeling and Analysis, 3rd Edition, McGraw Hill, 2000.
Luenberger, D. G., Investment Science, Oxford University Press, 1998.
Winston, W. L., Simulation Modeling Using @RISK, Duxbury, 2001.
Computer Software: Palisade Decision Tools, including @RISK, RISKOptimizer, and StatTools, are available in the computer labs in the Krannert building and Rawls Hall. A student version of the software and the installation guide can be downloaded for free at https://intra.krannert.purdue.edu/admin/kcc/Pages/Resources.aspx. SimQuick is included in the companion CD of our textbook.
Course Prerequisites: MGMT 67000
In the past twenty years, Excel spreadsheets have become the standard tool that business people use to model and analyze quantitative problems. The latest versions of these spreadsheet packages contain powerful analytical tools that could be possible only with mainframe computers and mathematically trained personnel two decades ago. This course covers up-to-date and practical spreadsheet modeling and simulation tools that can be applied to a wide variety of business problems in finance, marketing, and operations.
The topical coverage mainly consists of the following four modules: (1) data analysis techniques to find the most likely description of the uncertainty in future business; (2) deterministic and stochastic optimization techniques to determine the best managerial
References: Law, A. M. and W. D. Kelton, Simulation Modeling and Analysis, 3rd Edition, McGraw Hill, 2000. Luenberger, D. G., Investment Science, Oxford University Press, 1998. Winston, W. L., Simulation Modeling Using @RISK, Duxbury, 2001.