Optimization Modeling with Spreadsheets
Home > Mathematics and Science Textbooks > Mathematics > Probability and statistics > Optimization Modeling with Spreadsheets
Optimization Modeling with Spreadsheets

Optimization Modeling with Spreadsheets

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

Reflects the latest applied research and features state-of-the-art software for building and solving spreadsheet optimization models Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Second Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets to represent and analyze those models. Developed and extensively classroom-tested by the author, the book features a systematic approach that equips readers with the skills to apply optimization tools effectively without the need to rely on specialized algorithms. This new edition uses the powerful software package Risk Solver Platform (RSP) for optimization, including its Evolutionary Solver, which employs many recently developed ideas for heuristic programming. The author provides expanded coverage of integer programming and discusses linear and nonlinear programming using a systematic approach that emphasizes the use of spreadsheet-based optimization tools. The Second Edition also features: * Classifications for the various problem types, providing the reader with a broad framework for building and recognizing optimization models * Network models that allow for a more general form of mass balance * A systematic introduction to Data Envelopment Analysis (DEA) * The identification of qualitative patterns in order to meaningfully interpret linear programming solutions * An introduction to stochastic programming and the use of RSP to solve problems of this type Additional examples, exercises, and cases have been included throughout, allowing readers to test their comprehension of the material. In addition, a related website features Microsoft Office(R) Excel files to accompany the figures and data sets in the book. With its accessible and comprehensive presentation, Optimization Modeling with Spreadsheets, Second Edition is an excellent book for courses on deterministic models, optimization, and spreadsheet modeling at the upper-undergraduate and graduate levels. The book can also serve as a reference for researchers, practitioners, and consultants working in business, engineering, operations research, and management science.

Table of Contents:
Preface. Chapter 1. Introduction to Spreadsheet Models for Optimization. 1.1 Elements of Model. 1.2 Spreadsheet Models. 1.3 A Hierarchy for Analysis. 1.4 Optimization Software. 1.5 Using Solver. Chapter 2. Linear Programming: Allocation, Covering and Blending Models. 2.1 Linear Models. 2.2 Allocation Models. 2.3 Covering Models. 2.4 Blending Models. 2.5 Modeling Errors in Linear Programming. Chapter 3. Linear Programming Network Models. 3.1 The Transportation Model. 3.2 The Assignment Model. 3.3 The Transshipment Model. 3.4 Features of Special Network Models. 3.5 Building Network Models with Yields. 3.6 General Network Models with Yields. 3.7 General Network Models with Transformed Flows. Chapter 4. Sensitivity Analysis in Linear Programs. 4.1 Parameter Analysis in the Transportation Example 4.2 Parameter Analysis in the Allocation Example. 4.3 The Sensitivity Report and the Transportation Example. 4.4 The Sensitivity Report and the Allocation Example. 4.5 Degeneracy and Alternative Optima. 4.6 Patterns in Linear Programming Solutions. Chapter 5. Linear Programming: Data Envelopment Analysis. 5.1 A Graphical Perspective on DEA. 5.2 An Algebraic Perspective on DEA. 5.3 A Spreadsheet Model for DEA. 5.4 Indexing. 5.5 Finding Reference Sets and HSUs. 5.6 Assumptions and Limitations of DEA. Chapter 6. Integer Programming: Binary Choice Models. 6.1 Using Solver with Integer Requirements. 6.2 The Capital Budgeting Problem. 6.3 Set Covering. 6.4 Set Packing. 6.5 Set Partitioning. 6.6 Playoff Scheduling. 6.7 Solving a Large-Scale Set Partitioning Problem. 6.8 The Algorithm for Solving Integer Programs. Chapter 7. Integer Programming: Logical Constraints. 7.1 Simple Logical Constraints: Contingency and Exclusivity. 7.2 Linking Constraints: The Fixed Cost Problem. 7.3 Linking Constraints: The Threshold Level Problem. 7.4 Linking Constraints: The Facility Location Model. 7.5 Disjunctive Constraints: The Machine Sequencing Problem. 7.6 Tour and Subset Constraints: The Traveling Salesperson Problem. Chapter 8. Nonlinear Programming. 8.1 One-Variable Models. 8.2 Local Optima and the Search for an Optimum. 8.3 Two-Variable Models. 8.4 Nonlinear Models with Constraints. 8.5 Linearizations. Chapter 9. Heuristic Solutions with the Evolutionary Solver. 9.1 Features of the Evolutionary Solver. 9.2 An Illustrative Example: Nonlinear Regression. 9.3 The Machine-Sequencing Problem Revisited. 9.4 The Traveling Salesperson Problem Revisited. 9.5 Multi-Machine Scheduling. 9.6 Two-Dimensional Location. 9.7 Line Balancing. Appendices. 1. Optimization Software and Supplement Files. 2. Graphical Method for Linear Programming. 3. The Simplex Method. 4. Stochastic Programming. Index.


Best Sellers


Product Details
  • ISBN-13: 9780470928639
  • Publisher: John Wiley and Sons Ltd
  • Binding: Hardback
  • Height: 238 mm
  • Returnable: N
  • Weight: 734 gr
  • ISBN-10: 0470928638
  • Publisher Date: 19 Apr 2011
  • Edition: Revised edition
  • Language: English
  • Spine Width: 27 mm
  • Width: 172 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Optimization Modeling with Spreadsheets
John Wiley and Sons Ltd -
Optimization Modeling with Spreadsheets
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Optimization Modeling with Spreadsheets

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!