内容

目次

I. MODELS AND MODELING.Introduction to Modeling.SpreadsheetModeling.II. OPTIMIZATION.Linear Programming: Formal Models.LinearProgramming: Spreadsheet Models.Linear Programming: GeometricRepresentations and Graphical Solutions.Linear Programming:Interpreting the Solver Sensitivity Report.Linear Programming:Applications.Integer and Non Linear Models.Multi-Objective DecisionMaking.III. MODELING UNDER UNCERTAINTY.Decision Analysis.Monte CarloSimulation.Simulation with Spreadsheet Add-ins.QueuingModels.Forecasting.Project Management.IV.IMPLEMENTATION.Implementation.Appendix A.Basic Concepts inProbability.Appendix B.Answers to Odd Numbered Problems.AppendixC.Excel Commands Useful for Modeling (30 pages).Appendix D.Solver Tipsand Messages (20-25 pages).Index.