Management Science: The Art of Modeling with Spreadsheets, 4th Edition

Index

A

Absolute addresses, 469

Absolute cell addressing, 459

Absolute cell references, 467

Additivity, 219

Advertising budget problem, 319–22

Algorithms, 187

Alldifferent constraint, 327, 331

Allocation models, 221–6

formulation, 221–2

optimization, 224–6

spreadsheet model, 222–4

Analysis using spreadsheets, 71–87

base-case analysis, 72

breakeven analysis, 81–3

optimization analysis, 83

risk analysis, 84

simulation, 84

what-if analysis, 72–81. See also individual entry

Analytic Solver Platform, 187

ANDandOR function, 483

Arithmetic operations, 468

Assignment model, 266–9

model formulation, 267

optimization, 268

sensitivity analysis, 268–9

spreadsheet model, 267–8

Assortment model, 309–10

Auditing software use, 68

Average, 501

Average outcome, 363

B

Back propagation, 160

Backward elimination, 146

Baker, K, 5

Balance equation, 271

Base-case analysis using spreadsheets, 72

Base-case model, 367–8, 376–8, 416–18, 422–5

Base value, 168, 179

Basic functions, 469–473

advanced functions, 483–486

ANDandOR, 483

CEILING, 486

COUNTIF, 484–485

financial functions, 486

FLOOR, 486

HLOOKUP, 484–485

INDEX, 485–486

INT, 486

MATCH, 485–486

RAND, 486

RANDBETWEEN, 486

ROUND, 486

SMALL, 485–486

SUMIF, 484

Text and Date functions, 486

VLOOKUP, 484–485

ISPMT function, 470–471

nesting of functions, 473

NPV Function, 472

Bayes Rule, 130

Benchmark criteria, 73–4, 338–9

maximax payoff criterion, 338

maximin payoff criterion, 338

minimax regret criterion, 339

Bernoulli distribution, 394, 498

Binary categorical ...