Spreadsheet Modeling And Applications

This volume shows how spreadsheets are used in real life to model and analyse real business problems. By modelling problems using spreadsheets from the outset the text prepares future managers for the types of problems they will encounter in their daily workload.

CD-ROM contains: Crystal Ball -- TreePlan -- AnimaLP -- Queue -- ExcelWorkbooks.

In the Second Edition of their popular text, Wayne Winston and Chris Albright continue to build on their highly successful approach of teaching by example while using spreadsheets to model a wide variety of business problems. The authors show the relevance of topics through numerous examples of real-world implementation of management science. The ideal solution for people who want to teach by example and who want to solve real problems with spreadsheets and professional spreadsheet add-ins, this text is always interesting, in part due to the useful cases added to this edition.

CD-ROM contains: The DecisionTools Suite, Premium Solver, SolverTable, and Excel workbooks.

Practical Spreadsheet Modeling Using @Risk provides a guide of how to construct applied decision analysis models in spreadsheets. The focus is on the use of Monte Carlo simulation to provide quantitative assessment of uncertainties and key risk drivers. The book presents numerous examples based on real data and relevant practical decisions in a variety of settings, including health care, transportation, finance, natural resources, technology, manufacturing, retail, and sports and entertainment. All examples involve decision problems where uncertainties make simulation modeling useful to obtain decision insights and explore alternative choices. Good spreadsheet modeling practices are highlighted. The book is suitable for graduate students or advanced undergraduates in business, public policy, health care administration, or any field amenable to simulation modeling of decision problems. The book is also useful for applied practitioners seeking to build or enhance their spreadsheet modeling skills. Features Step-by-step examples of spreadsheet modeling and risk analysis in a variety of fields Description of probabilistic methods, their theoretical foundations, and their practical application in a spreadsheet environment Extensive example models and exercises based on real data and relevant decision problems Comprehensive use of the @Risk software for simulation analysis, including a free one-year educational software license

The book and accompanying disk use the capabilities of electronic spreasheet programs to provide 19 spreadsheet models that can be used for a wide range of urban and regional analysis and planning applications. The models have been developed for Lotus 1-2-3, Version 1.00, for the IBM personal computer and compatible systems and can be adapted for use with other spreadsheet programs.