Most ebook files are in PDF format, so you can easily read them using various software such as Foxit Reader or directly on the Google Chrome browser.
Some ebook files are released by publishers in other formats such as .awz, .mobi, .epub, .fb2, etc. You may need to install specific software to read these formats on mobile/PC, such as Calibre.
Please read the tutorial at this link. https://ebooknice.com/page/post?id=faq
We offer FREE conversion to the popular formats you request; however, this may take some time. Therefore, right after payment, please email us, and we will try to provide the service as quickly as possible.
For some exceptional file formats or broken links (if any), please refrain from opening any disputes. Instead, email us first, and we will try to assist within a maximum of 6 hours.
EbookNice Team
Status:
Available4.8
17 reviewsISBN 10: 1501515101
ISBN 13: 9781501515101
Author: Nagraj Balakrishnan, Barry Render, Ralf M Stair, Chuck L Munson
This book fills a void for a balanced approach to spreadsheet-based decision modeling. In addition to using spreadsheets as a tool to quickly set up and solve decision models, the authors show 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.
Chapter 1: Introduction to Managerial Decision Modeling
1.1 What is Decision Modeling?
1.2 Types of Decision Models
Deterministic Models
Probabilistic Models
Quantitative versus Qualitative Data
Using Spreadsheets in Decision Modeling
1.3 Steps Involved in Decision Modeling
Step 1: Formulation
Step 2: Solution
Step 3: Interpretation and Sensitivity Analysis
1.4 Spreadsheet Example of a Decision Model: Tax Computation
1.5 Spreadsheet Example of a Decision Model: Break-Even Analysis
Using Goal Seek to Find the Break-Even Point
1.6 Possible Problems in Developing Decision Models
Defining the Problem
Developing a Model
Acquiring Input Data
Developing a Solution
Testing the Solution
Analyzing the Results
1.7 Implementation–Not Just the Final Step
1.8 Summary
1.9 Exercises
Chapter 2: Linear Programming Models: Graphical and Computer Methods
2.1 Introduction
2.2 Developing a Linear Programming Model
Formulation
Solution
Interpretation and Sensitivity Analysis
Properties of a Linear Programming Model
Basic Assumptions of a Linear Programming Model
2.3 Formulating a Linear Programming Problem
Linear Programming Example: Flair Furniture Company
Decision Variables
The Objective Function
Constraints
Nonnegativity Constraints and Integer Values
Guidelines for Developing a Correct LP Model
2.4 Graphical Solution of a Linear Programming Problem with Two Variables
Graphical Representation of Constraints
Painting Time Constraint
Feasible Region
Identifying an Optimal Solution by Using Level Lines
Identifying an Optimal Solution by Using All Corner Points
Comments on Flair Furniture’s Optimal Solution
Extension to Flair Furniture’s LP Model
2.5 A Minimization Linear Programming Problem
Holiday Meal Turkey Ranch
Graphical Solution of the Holiday Meal Turkey Ranch Problem
2.6 Special Situations in Solving Linear Programming Problems
Redundant Constraints
Infeasibility
Alternate Optimal Solutions
Unbounded Solution
2.7 Setting Up and Solving Linear Programming Problems Using Excel’s Solver
Using Solver to Solve the Flair Furniture Problem
The Objective Cell
Creating Cells for Constraint RHS Values
Entering Information in Solver
Using Solver to Solve Flair Furniture Company’s Modified Problem
Using Solver to Solve the Holiday Meal Turkey Ranch Problem
2.8 Algorithmic Solution Procedures for Linear Programming Problems
2.9 Summary
2.10 Exercises
Chapter 3: Linear Programming Modeling Applications with Computer Analyses in Excel
3.1 Using Linear Programming to Solve Real-World Problems
3.2 Manufacturing Applications
Product Mix Problem
Make-Buy Decision Problem
3.3 Marketing Applications
Media Selection Problem
Marketing Research Problem
3.4 Finance Applications
Portfolio Selection Problem
Alternate Formulations of the Portfolio Selection Problem
3.5 Employee Staffing Applications
Labor Planning Problem
Extensions to the Labor Planning Problem
Assignment Problem
3.6 Transportation Applications
Vehicle Loading Problem
Expanded Vehicle Loading Problem–Allocation Problem
Transportation Problem
3.7 Blending Applications
Diet Problem
Blending Problem
3.8 Multiperiod Applications
Production Scheduling Problem
Sinking Fund Problem
3.9 Summary
3.10 Exercises
Chapter 4: Linear Programming Sensitivity Analysis
4.1 Importance of Sensitivity Analysis
Why Do We Need Sensitivity Analysis?
4.2 Sensitivity Analysis Using Graphs
Types of Sensitivity Analysis
Impact of Changes in an Objective Function Coefficient
Impact of Changes in a Constraint’s Right-Hand-Side Value
4.3 Sensitivity Analysis Using Solver Reports
Solver Reports
Sensitivity Report
Impact of Changes in a Constraint’s RHS Value
Impact of Changes in an Objective Function Coefficient
4.4 Sensitivity Analysis for a Larger Maximization Example
Anderson Home Electronics Example
Some Questions We Want Answered
Alternate Optimal Solutions
4.5 Analyzing Simultaneous Changes by Using the 100% Rule
Simultaneous Changes in Constraint RHS Values
Simultaneous Changes in OFC Values
4.6 Pricing Out New Variables
Anderson’s Proposed New Product
4.7 Sensitivity Analysis for a Minimization Example
Burn-Off Diet Drink Example
Burn-Off’s Excel Solution
Answering Sensitivity Analysis Questions for Burn-Off
4.8 Summary
4.9 Exercises
Chapter 5: Transportation, Assignment, and Network Models
5.1 Types of Network Models
Transportation Model
Transshipment Model
Assignment Model
Maximal-Flow Model
Shortest-Path Model
Minimal-Spanning Tree Model
Implementation Issues
5.2 Characteristics of Network Models
Types of Arcs
Types of Nodes
Common Characteristics
5.3 Transportation Model
LP Formulation for Executive Furniture’s Transportation Model
Solving the Transportation Model Using Excel
Unbalanced Transportation Models
Alternate Optimal Solutions
An Application of the Transportation Model: Facility Location
5.4 Transportation Models with Max-Min and Min-Max Objectives
5.5 Transshipment Model
Executive Furniture Company Example–Revisited
LP Formulation for Executive Furniture’s Transshipment Model
Lopez Custom Outfits–A Larger Transshipment Example
LP Formulation for Lopez Custom Outfits Transshipment Model
5.6 Assignment Model
Fix-It Shop Example
Solving Assignment Models
LP Formulation for Fix-It Shop’s Assignment Model
5.7 Maximal-Flow Model
Road System in Waukesha, Wisconsin
LP Formulation for Waukesha Road System’s Maximal-Flow Model
5.8 Shortest-Path Model
Ray Design Inc. Example
LP Formulation for Ray Design Inc.’s Shortest-Path Model
5.9 Minimal-Spanning Tree Model
Lauderdale Construction Company Example
5.10 Summary
5.11 Exercises
managerial decision modeling
quantitative models for decision making examples
8 steps of decision making process with examples pdf
7 step decision making model example
6 step decision making model
Tags: Nagraj Balakrishnan, Barry Render, Ralf M Stair, Chuck L Munson, Managerial, Decision