Spreadsheet Modeling and Applications
Title | Spreadsheet Modeling and Applications PDF eBook |
Author | S. Christian Albright |
Publisher | South-Western College |
Pages | 698 |
Release | 2005 |
Genre | Business & Economics |
ISBN |
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.
Management Decision Making
Title | Management Decision Making PDF eBook |
Author | George E. Monahan |
Publisher | Cambridge University Press |
Pages | 760 |
Release | 2000-08-17 |
Genre | Business & Economics |
ISBN | 9780521781183 |
CD-ROM contains: Crystal Ball -- TreePlan -- AnimaLP -- Queue -- ExcelWorkbooks.
Practical Management Science
Title | Practical Management Science PDF eBook |
Author | Wayne L. Winston |
Publisher | South Western Educational Publishing |
Pages | 984 |
Release | 2001 |
Genre | Business & Economics |
ISBN |
CD-ROM contains: The DecisionTools Suite, Premium Solver, SolverTable, and Excel workbooks.
Optimization Modeling with Spreadsheets
Title | Optimization Modeling with Spreadsheets PDF eBook |
Author | Kenneth R. Baker |
Publisher | John Wiley & Sons |
Pages | 431 |
Release | 2012-01-10 |
Genre | Business & Economics |
ISBN | 1118008979 |
Reflects the latest applied research and features state-of-the-art software for building and solving spreadsheet optimization models Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Second Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets to represent and analyze those models. Developed and extensively classroom-tested by the author, the book features a systematic approach that equips readers with the skills to apply optimization tools effectively without the need to rely on specialized algorithms. This new edition uses the powerful software package Risk Solver Platform (RSP) for optimization, including its Evolutionary Solver, which employs many recently developed ideas for heuristic programming. The author provides expanded coverage of integer programming and discusses linear and nonlinear programming using a systematic approach that emphasizes the use of spreadsheet-based optimization tools. The Second Edition also features: Classifications for the various problem types, providing the reader with a broad framework for building and recognizing optimization models Network models that allow for a more general form of mass balance A systematic introduction to Data Envelopment Analysis (DEA) The identification of qualitative patterns in order to meaningfully interpret linear programming solutions An introduction to stochastic programming and the use of RSP to solve problems of this type Additional examples, exercises, and cases have been included throughout, allowing readers to test their comprehension of the material. In addition, a related website features Microsoft Office® Excel files to accompany the figures and data sets in the book. With its accessible and comprehensive presentation, Optimization Modeling with Spreadsheets, Second Edition is an excellent book for courses on deterministic models, optimization, and spreadsheet modeling at the upper-undergraduate and graduate levels. The book can also serve as a reference for researchers, practitioners, and consultants working in business, engineering, operations research, and management science.
Practical Spreadsheet Modeling Using @Risk
Title | Practical Spreadsheet Modeling Using @Risk PDF eBook |
Author | Dale Lehman |
Publisher | CRC Press |
Pages | 572 |
Release | 2019-11-11 |
Genre | Business & Economics |
ISBN | 0429509324 |
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
Practical Management Science
Title | Practical Management Science PDF eBook |
Author | Wayne L. Winston |
Publisher | |
Pages | 796 |
Release | 1998 |
Genre | Electronic spreadsheets |
ISBN | 9780534499877 |
Spreadsheet Models for Urban and Regional Analysis
Title | Spreadsheet Models for Urban and Regional Analysis PDF eBook |
Author | Richard E. Klosterman |
Publisher | Cupr/Transaction |
Pages | 500 |
Release | 1993 |
Genre | Business & Economics |
ISBN |
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.