Step-By-Step Optimization With Excel Solver - The Excel Statistical Master
Cód:
491_9781937159153
For anyone who wants to be operating at a high level with the Excel Solver quickly, this is the book for you. Step-By-Step Optimization With Excel Solver is more than 200+ pages of simple yet thorough explanations on how to use the Excel Solver to solve todays most widely known optimization problems. Loaded with screen shots that are coupled with easy-to-follow instructions, this book will simplify many difficult optimization problems and make you a master of the Excel Solver almost immediately. Here are just some of the Solver optimization problems that are solved completely with simple-to-understand instructions and screen shots in this book: • The famous Traveling Salesman problem using Solvers Alldifferent constraint and the Solvers Evolutionary method to find the shortest path to reach all customers. This also provides an advanced use of the Excel INDEX function. • The well-known Knapsack Problem which shows how optimize the use of limited space while satisfying numerous other criteria. • How to perform nonlinear regression and curve-fitting on the Solver using the Solvers GRG Nonlinear solving method. • How to solve the Cutting Stock Problem faced by many manufacturing companies who are trying to determine the optimal way to cut sheets of material to minimize waste while satisfying customer orders. • Portfolio optimization to maximize return or minimize risk. • Venture capital investment selection using the Solvers Binary constraint to maximize Net Present Value of selected cash flows at year 0. Clever use of the If-Then-Else statements makes this a simple problem. • How use Solver to minimize the total cost of purchasing and shipping goods from multiple suppliers to multiple locations. • How to optimize the selection of different production machine to minimize cost while fulfilling an order. • How to optimally allocate a marketing budget to generate the greatest reach and frequency or number of inbound leads at the lowest cost.
Veja mais
