Business Analytics with Management Science Models and Methods

Index

A

AboutTheData.com, 11

accessing Excel Solver, 349–350

adding Solver to Tools menu, 349

Add-ins dialog box, 349

Airbus and multi-objective optimization models, 128

All Methods options (Solver), 353–355

Constraint Precision, 354

Ignore Integer Constraints, 354

Show Iteration Results, 354

solving limits, 354–355

Use Automatic Scaling, 354

all-integer programming model, 164

Amazon, 86

Answer Report, 79–80

Rolls Bakery Integer GP model, 170–172

Rolls Bakery LP model, 51

WCF (World Class Furniture) NLP model, 107–108

Apache Hadoop, 16

area of feasible solutions, graphing, 35–37, 40–41

aspiration level, Rolls Bakery GP model, 132

assignment method (IP models), 172–173

formulating, 173

solving with Solver, 173–178

AVERAGEIF function, 331, 332 ...