E

Economic Order Quantity formula

calculating, 532

cost-minimizing batch size calculation, 533–535

interpreting, 532

parameters for, 531

quantity discounts and, 533

elasticity of demand, 549–550

elections, predicting, 400–403

employee scheduling, 231–233

entries, returning from specific row and column. See INDEX function

errors

preventing. See data validation

replacing. See IFERROR function

European stock options, 514.

See also call options;

put options

cash flow, modeling, 514

comparing with American options, 514

defined, 75

Evaluate Formula command, 151

Excel Solver

binary changing cells in, 241

binary problems, 245

bootstrapping calculation with, 497–498

capital budgeting with, 241–243

constraints, adding, 224–225

constraints, changing, 228–229

financial planning with, 247

infeasible solutions in, 227, 229

installing, 219

integer problems, 245

linear models, 226–227

opening, 223

optimal solutions found by, 219–220

point spread calculation with, 253–256

product mix problem, solving, 221–228

profit maximizing calculation with, 555–558

retirement planning with, 249–251

Set Values Do Not Converge result, 229

SUMPRODUCT function and, 222–223

target cell, setting, 224

Tolerance setting, 245

transportation problems in, 235–237

workforce scheduling with, 231–233

exercise price of stocks, 513

experience curve. See learning curve

EXPONDIST function, 461

exponential function, 373–375

large numbers and, 375

vs. power curve, 380–381

slowdown of, 375

exponential random variables, calculating probability of, 461