LINEAR AND NONLINEAR OPTIMIZATION USING SPREADSHEETS

Examples for Prescriptive, Predictive and Descriptive Analytics

By: STEPHANIE STAHL MICHAEL J BRUSCO

Write A Review

Hardcover | 21 October 2024

At a Glance

Hardcover
360 Pages

Dimensions(cm)
22.86 x 15.24 x 2.06

Hardcover

$186.50

or 4 interest-free payments of $46.63 with

Aims to ship in 7 to 10 business days

The use of spreadsheets to obtain solutions to a diverse array of examples offers a reader-friendly way of addressing a topic (optimization) that can sometimes be viewed as intimidating. Many people are readily familiar with spreadsheets and how they work, yet are apt to be unaware of the incredible power of Excel for solving some rather complex optimization problems. A major goal of the book is to sell readers on why it is so important to understand optimization, and a large collection of examples for a wide range of business decision making areas (e.g., production planning and scheduling, workforce planning and scheduling, location and supply chain distribution, location of emergency services, assembly line balancing, vehicle routing, project scheduling, revenue management, advertising, product design, payout schedules, productivity measurement, investment portfolio management, sports league scheduling, ranking models, etc.) affords a practical mechanism for achieving that goal. Another important contribution of the book is that it provides coverage of the mechanics of some common yet sophisticated statistical methods (regression, logistic regression, discriminant analysis, factor analysis, and cluster analysis), which are often opaque to many users of such methods.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.