FREE SHIPPING BOTH WAYS
ON EVERY ORDER!
LIST PRICE:
$69.94

Sorry, this item is currently unavailable.

Spreadsheet Modeling and Decision Analysis : A Practical Introduction to Management Science

ISBN: 9780538881302 | 0538881305
Edition: 2nd
Publisher: ITP
Pub. Date: 1/1/1998

Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

Top 5 reasons to order all your textbooks from Knetbooks:

  • We have the lowest prices on thousands of popular textbooks
  • Free shipping both ways on ALL orders
  • Most orders ship within 48 hours
  • Need your book longer than expected? Extending your rental is simple
  • Our customer support team is always here to help
Table of Contents
Introduction to Modeling and Decision Analysis
1(15)
The Modeling Approach to Decision Making
3(1)
Characteristics and B... MORE
3(2)
Mathematical Models
5(1)
Categories of Mathematical Models
6(2)
The Problem-Solving Process
8(2)
Good Decisions vs. Good Outcomes
10(6)
Introduction to Optimization and Linear Programming
16(27)
Applications of Mathematical Optimization
16(1)
Characteristics of Optimization Problems
17(1)
Expressing Optimization Problems Mathematically
18(1)
Mathematical Programming Techniques
19(1)
An Example LP Problem
20(1)
Formulating LP Models
20(2)
Summary of the LP Model for the Example Problem
22(1)
The General Form of an LP Model
23(1)
Solving LP Problems: An Intuitive Approach
23(1)
Solving LP Problems: A Graphical Approach
24(9)
Special Conditions in LP Models
33(10)
Modeling and Solving LP Problems in a Spreadsheet
43(85)
Spreadsheet Solvers
43(1)
Solving LP Problems in a Spreadsheet
44(1)
The Steps in Implementing an LP Model in a Spreadsheet
45(1)
A Spreadsheet Model for the Blue Ridge Hot Tubs Problem
46(3)
How Solver Views the Model
49(2)
Using Solver
51(7)
Goals and Guidelines for Spreadsheet Design
58(1)
Make vs. Buy Decisions
59(6)
An Investment Problem
65(4)
An Employee Scheduling Problem
69(8)
A Transportation Problem
77(7)
A Blending Problem
84(7)
A Production and Inventory Planning Problem
91(6)
A Multi-Period Cash Flow Problem
97(31)
Sensitivity Analysis and the Simplex Method
128(31)
the Purpose of Sensitivity Analysis
128(1)
Approaches to Sensitivity Analysis
129(1)
An Example Problem
129(1)
The Answer Report
130(2)
The Sensitivity Report
132(11)
The Limits Report
143(1)
the Simplex Method (Optional)
144(15)
Network Modeling
159(47)
The Transshipment Problem
159(8)
The Shortest Path Problem
167(5)
the Equipment Replacement Problem
172(3)
Transportation/Assignment Problems
175(1)
Generalized Network Flow Problems
176(6)
Maximal Flow Problems
182(4)
Minimal Spanning Tree Problems
186(20)
Integer Linear Programming
206(58)
Integrality Conditions
206(1)
Relaxation
207(1)
Solving the Relaxed Problem
208(2)
Bounds
210(1)
Rounding
211(2)
Stopping Rules
213(1)
Solving ILP Problems Using Solver
214(3)
Other ILP Problems
217(1)
Binary Variables
218(1)
A Capital Budgeting Problem
219(5)
Binary Variables and Logical Condition
224(1)
The Fixed-Charge Problem
225(7)
Minimum Order/Purchase Size
232(1)
Quantity Discounts
233(1)
A Contract Award Problem
234(7)
The Branch-and-Bound Algorithm (Optional)
241(23)
Goal Programming and Multiple Objective Optimization
264(36)
Goal Programming
264(1)
A Goal Programming Example
265(9)
Comments About Goal Programming
274(2)
Multiple Objective Optimization
276(1)
An MOLP Example
276(11)
Comments on MOLP
287(13)
Nonlinear Programming
300(61)
The Nature of NLP Problems
300(2)
Solution strategies for NLP Problems
302(1)
Local vs. Global Solutions
303(2)
Economic Order Quantity Models
305(6)
Location Problems
311(6)
Nonlinear Network Flow Problem
317(5)
Project Selection Problems
322(6)
Optimizing Existing Financial Spreadsheet Models
328(5)
The Portfolio Selection Problem
333(9)
Sensitivity Analysis
342(3)
Solver Options for Solving NLPS
345(16)
Regression Analysis
361(48)
An Example
361(2)
Regression Models
363(2)
Simple Linear Regression Analysis
365(1)
Defining "Best Fit"
365(1)
Solving the Problem Using Solver
366(3)
Solving the Problem Using the Regression Tool
369(1)
Evaluating the Fit
370(3)
The R² Statistic
373(2)
Making Predictions
375(4)
Statistical Tests for Population Parameters
379(4)
Introduction to Multiple Regression
383(1)
A Multiple regression Example
384(2)
Selecting the Model
386(6)
Making Predictions
392(1)
Binary Independent Variables
393(1)
Statistical Tests for the Population Parameters
394(1)
Polynomial Regression
394(15)
Discriminant Analysis
409(26)
The Two-Group DA Problem
410(10)
The k-Group DA Problem
420(15)
Time Series Analysis
435(49)
Times Series Methods
436(1)
Measuring Accuracy
436(1)
Extrapolation Models
436(2)
Moving Averages
438(3)
Weighted Moving Averages
441(2)
Exponential Smoothing
443(4)
Trend Models
447(1)
Holt's Method
448(4)
Modeling Time Series Trends Using Regression
452(1)
Linear Trend Model
452(3)
Quadratic Trend Model
455(3)
Seasonality
458(1)
Adjusting Trend Predictions with Seasonal Indices
458(3)
Winter's Method
461(6)
Seasonal Regression Models
467(3)
Combining Forecasts
470(14)
Simulation
484(58)
Random Variables and Risk
484(1)
Why Analyze Risk?
485(1)
Methods of Risk Analysis
485(3)
A Corporate Health Insurance Example
488(2)
Random Number Generators
490(6)
Preparing the Model for Simulation
496(3)
Replicating the Model
499(4)
Data Analysis
503(4)
The Uncertainty of Sampling
507(3)
The Benefits of Simulation
510(1)
Additional Uses of Simulation
511(1)
An Inventory Control Example
511(9)
An Overbooking Example
520(22)
Simulation Using @Risk
542(52)
Random Variables and Risk
542(1)
Why Analyze Risk?
543(1)
Methods of Risk Analysis
544(2)
Corporate Health Insurance Example
546(2)
Spreadsheet Simulation Using @Risk
548(1)
Random Number Generators
549(3)
preparing the Model for Simulation
552(3)
Running the Simulation
555(2)
Data Analysis
557(4)
Incorporating Graphs and Statistics into a Spreadsheet
561(2)
The Uncertainty of Sampling
563(3)
The Benefits of Simulation
566(1)
Additional Uses of Simulation
566(1)
An Inventory Control Example
566(7)
An Overbooking Example
573(21)
Queuing Theory
594(30)
The Purpose of Queuing Models
594(1)
Queuing System Configurations
595(1)
Characteristics of Queuing Systems
596(4)
Kendall Notation
600(1)
Queuing Models
601(1)
The M/M/s Model
601(4)
The M/M/s Model with Finite Queue Length
605(3)
The M/M/s Model with Finite Population
608(4)
The M/G/1 Model
612(3)
The M/D/1 Model
615(1)
Simulating Queues
616(1)
The steady-State Assumption
617(7)
Project Management
624(46)
An Example
625(1)
Creating the Project Network
625(3)
CPM: An Overview
628(1)
The Forward Pass
629(2)
the Backward Pass
631(2)
Determining the Critical Path
633(2)
Project Management Using Spreadsheets
635(3)
Determining Earliest and Latest Start Times Using LP
638(7)
Project Crashing
645(9)
Certainty vs. Uncertainty
654(1)
PERT: An Overview
654(3)
Simulating Project Networks
657(13)
Decision Analysis
670(1)
Good Decisions vs. Good Outcomes
671(1)
Characteristics of Decision Problems
671(1)
An Example
672(1)
The Payoff Matrix
672(3)
Decision Rules
675(1)
Nonprobabilistic Methods
675(5)
Probabilistic Methods
680(2)
The Expected Value of Perfect Information
682(3)
Decision Trees
685(2)
Using Tree Plan
687(10)
Multistage Decision Problems
697(3)
Analyzing Risk in a Decision Tree
700(2)
Using Sample Information in Decision Making
702(3)
Computing Conditional Probabilities
705(3)
Utility Theory
708(7)
Multicriteria Decision Making
715(1)
The Multicriteria Scoring Model
716(1)
The Analytic Hierarchy Process
717

Related Products


  • Outlines and Highlights for Spreadsheet Modeling and Decision Analysis by Cliff Ragsdale, Isbn : 9780324656633
    Outlines and Highlights for Sp...
  • Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Management Science, 6th Edition
    Spreadsheet Modeling & Decisio...
  • Spreadsheet Modeling and Decision Analysis
    Spreadsheet Modeling and Decis...
  • Spreadsheet Modeling and Decision Analysis (with CD-ROM and Microsoft Project 2003 120 day version)
    Spreadsheet Modeling and Decis...
  • Spreadsheet Modeling and Decision Analysis : A Practical Introduction to Management Science
    Spreadsheet Modeling and Decis...
  • Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Management Science
    Spreadsheet Modeling and Decis...
  • Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Management Science
    Spreadsheet Modeling and Decis...
  • SPREADSHEET MODELNG&DEC ANALYS/2ND PRINTING
    SPREADSHEET MODELNG&DEC ANALYS...


Please wait while this item is added to your cart...