Home › Hardcover Books › Linear and Nonlinear Optimization Using Spreadsheets

Linear and Nonlinear Optimization Using Spreadsheets

by Brusco Michael J Publisher: WORLD SCIENTIFIC PUB CO INC

Optimization and analysis through spreadsheet examples

Regular price $103.06 USD
Regular price $114.52 USD Sale price $103.06 USD
Save 10%

Hardcover New English

In stock · Dispatches in 1–2 business days
Delivery to your door
In stock·Dispatches in 1–2 business days
Standard shipping* from $4.35
Standard shipping transit* 5–8 business days after dispatch

Faster options are available.

Rates and delivery estimates depend on your destination and item quantity. Estimates are informational only; the final shipping method and rate are selected at checkout.

Secure checkout
American Express Apple Pay DiscoverGoogle Pay Mastercard PayPalVisa
30-day eligible returns Returns & refunds policy

AlbakiReads Editorial

Optimization and analysis through spreadsheet examples

Brusco presents optimization as a practical tool for business decision-making, using Excel-based examples to show how spreadsheet methods can address problems across planning, scheduling, logistics, design, finance, and other areas. The range extends from workforce and production planning to vehicle routing, revenue management, and portfolio management. The book also covers the mechanics of several statistical methods: regression, logistic regression, discriminant analysis, factor analysis, and cluster analysis. Together, these subjects connect spreadsheet problem-solving with a broader set of quantitative techniques used in business and operations research.

Good fit for readers who enjoy

  • Business and operations research students seeking applied optimization examples.
  • Practitioners interested in spreadsheet-based approaches to business decision-making.
  • Readers seeking an introduction to the mechanics of common statistical methods.

Themes

Spreadsheet-based optimizationBusiness decision-makingPlanning and schedulingStatistical methods

Based on publisher information and book metadata.

Book overview

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 & returnsShipping options, delivery timing, and our return policy.

In-stock items normally dispatch within 1–2 business days. The ZIP-code estimator on this page is informational only; the final shipping method, price, and availability are confirmed at checkout for your full order.

For the initial delivery estimate we use these transit windows after dispatch: Standard 5–8 business days, Expedited 2–4 business days, and Priority 1–2 business days. Holiday delays are not included.

Eligible items can be returned within 30 days in accordance with our return policy.

Customer reviews

M
AlbakiReads
Malaika Taylor

I highly recommend to for anyone looking for inner clarity

T
AlbakiReads
Thomas DiMassa

Great service and fast service

Great shopping experience! The book arrived quickly, was well packaged, and matched the description perfectly. I would definitely shop with you again

O
AlbakiReads
Olivia

Smooth.