Managerial Decision Modeling with Spreadsheets / Edition 1
Filling a void for a balanced approach to spreadsheet based decision modeling, this volume builds on the traditions and strengths of Render and Stair's Quantitative Methods for Management, a recognized and proven leader in teaching decision modeling. In addition to using spreadsheets as a tool to quickly set up and solve decision models, the authors teach how and why the methods work and combine the user's power to logically model and analyze diverse decision-making scenarios with software-based solutions. The book discusses the fundamental concepts, assumptions and limitations behind each decision modeling technique, shows how each decision model works and illustrates the real-world usefulness of each technique with many applications from both profit and nonprofit organizations. The authors provide an introduction to managerial decision modeling, linear programming models, modeling applications and sensitivity analysis, transportation, assignment, and network models, integer, goal, and nonlinear programming models, project management, decision theory, queuing models, simulation modeling, forecasting models and inventory control models. For anyone looking for a balanced approach to spreadsheet based decision modeling.
1. Introduction to Managerial Decision Modeling. 2. Linear Programming Models: Graphical and Computer Methods. 3. Linear Programming Modeling Applications: With Computer Analyses in Excel. 4. Linear Programming Sensitivity Analysis. 5. Transportation, Assignment, and Network Models. 6. Integer, Goal, and Nonlinear Programming Models. 7. Project Management. 8. Decision Theory. 9. Queuing Models. 10. Simulation Modeling. 11. Forecasting Models. 12. Inventory Control Models. Appendix A: Useful Excel Commands and Procedures for Installing Excel Modules. Appendix B: Probability Concepts and Applications. Appendix C: Areas Under the Standard Normal Curve. Appendix D: Solutions to Selected Problems. Appendix E: Solutions to Self-Tests.