Sign-In
Cart
Optimization Modeling with Spreadsheets
Hardcover
Business GeneralManagementTechnology & Engineering
ISBN13: 9781118937693
Publisher: Wiley
Published: Jul 10 2015
Pages: 400
Weight: 1.50
Height: 1.00 Width: 6.10 Depth: 9.30
Language: English
An accessible introduction to optimization analysis using spreadsheets
Updated and revised, Optimization Modeling with Spreadsheets, Third Edition emphasizes model building skills in optimization analysis. By emphasizing both spreadsheet modeling and optimization tools in the freely available Microsoft(R) Office Excel(R) Solver, the book illustrates how to find solutions to real-world optimization problems without needing additional specialized software.
The Third Edition includes many practical applications of optimization models as well as a systematic framework that illuminates the common structures found in many successful models. With focused coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, Optimization Modeling with Spreadsheets, Third Edition features:
- An emphasis on model building using Excel Solver as well as appendices with additional instructions on more advanced packages such as Analytic Solver Platform and OpenSolver
- Additional space devoted to formulation principles and model building as opposed to algorithms
- New end-of-chapter homework exercises specifically for novice model builders
- Presentation of the Sensitivity Toolkit for sensitivity analysis with Excel Solver
- Classification of problem types to help readers see the broader possibilities for application
- Specific chapters devoted to network models and data envelopment analysis
- A companion website with interactive spreadsheets and supplementary homework exercises for additional practice
Optimization Modeling with Spreadsheets, Third Edition is an excellent textbook for upper-undergraduate and graduate-level courses that include deterministic models, optimization, spreadsheet modeling, quantitative methods, engineering management, engineering modeling, operations research, and management science. The book is an ideal reference for readers wishing to advance their knowledge of Excel and modeling and is also a useful guide for MBA students and modeling practitioners in business and non-profit sectors interested in spreadsheet optimization.
Also in
Management
Crucial Conversations Tools for Talking When Stakes Are High, Second Edition
Patterson, Kerry
Switzler, Al
Grenny, Joseph
Paperback
Quiet Girls Can Run the World: Owning Your Power When You're Not the Alpha in the Room
Holman, Rebecca
Paperback
The Art of Communication: How to Be Authentic, Lead Others, and Create Strong Connections
Apps, Judy
Hardcover
Unreasonable Hospitality: The Remarkable Power of Giving People More Than They Expect
Guidara, Will
Hardcover
Hbr's 10 Must Reads on Managing Yourself, Updated and Expanded (Featuring How Will You Measure Your Life? by Clayton M. Christensen)
Review, Harvard Business
Drucker, Peter F.
Gallo, Amy
Paperback
Hbr's 10 Must Reads on Mental Toughness, Updated and Expanded (Featuring How to Stop Worrying about What Other People Think of You by Michael Gervais)
Review, Harvard Business
Gervais, Michael
Duckworth, Angela L.
Paperback
Surrender to Lead: The Counterintuitive Approach to Driving Extraordinary Results
Terry, Joe
Kriegel, Jessica
Hardcover
Take Breaks, Work Better: Measure Impact, Not Hours, and Transform Your Profitability
Briggs, John
Paperback
Strong Ground: The Lessons of Daring Leadership, the Tenacity of Paradox, and the Wisdom of the Human Spirit
Brown, Brené
Hardcover
Hbr's 10 Must Reads on Leadership, Updated and Expanded (Featuring Begin with Trust by Frances X. Frei and Anne Morriss)
Review, Harvard Business
Edmondson, Amy C.
Ibarra, Herminia
Paperback
How We Could: The Framework to Lead Without Drama, Build Alignment, and Call Teams to Greatness
Dorr, Alex
Hardcover
The Year in Tech, 2026: The Insights You Need from Harvard Business Review
Review, Harvard Business
Anthony, Scott D.
Webb, Amy
Paperback
What the Heck Is Eos?: A Complete Guide for Employees in Companies Running on EOS
Wickman, Gino
Bouwer, Tom
Hardcover
The Coaching Habit: Say Less, Ask More, and Change the Way You Lead Forever
Stanier, Michael Bungay
Paperback
Stop Asking for Referrals: Build a Magnetic Business Through Intentional Care & Real Relationships
McNally, Flor de Maria
Paperback
Hbr's 10 Must Reads 2026: The Definitive Management Ideas of the Year from Harvard Business Review (Featuring the Strategic Genius of Taylor Swift by
Review, Harvard Business
Meyer, Erin
Flyvbjerg, Bent
Paperback
Get Scalable: The Operating System Your Business Needs To Run and Scale Without You
Deiss, Ryan
Paperback
Never Split the Difference: Negotiating as If Your Life Depended on It
Voss, Chris
Raz, Tahl
Hardcover
The Mom Test: How to talk to customers & learn if your business is a good idea when everyone is lying to you
Fitzpatrick, Rob
Paperback
Bookkeeping - Accounting for Small Business: A Quickstudy Laminated Reference Guide
Epstein, Lita
Other
Building Great Businesses: Create Momentum, Overcome Setbacks, and Scale with Confidence
Becker, Scott
Hardcover
Influence and Persuasion (HBR Emotional Intelligence Series)
Cialdini, Robert B.
Review, Harvard Business
Morgan, Nick
Paperback
The First 90 Days, Updated and Expanded: Proven Strategies for Getting Up to Speed Faster and Smarter
Watkins, Michael D.
Hardcover
Getting to Yes: Negotiating Agreement Without Giving in
Patton, Bruce
Fisher, Roger
Ury, William
Paperback
Take It Personal: How to Succeed by Building Relationships and Playing the Long Game
Grutman, David
Hardcover
Feedback That Works: How to Build and Deliver Your Message, Second Edition
Center for Creative Leadership
Paperback
Hbr's 10 Must Reads on Strategy, Updated and Expanded (Featuring the Five Competitive Forces That Shape Strategy by Michael E. Porter)
Kim, W. Chan
Review, Harvard Business
Porter, Michael E.
Paperback
Hbr's 10 Must Reads on High Performance, Updated and Expanded (Featuring Nine Things Successful People Do Differently by Heidi Grant)
Review, Harvard Business
Grant, Heidi
Goleman, Daniel
Paperback
Hbr's 10 Must Reads on Managing People, Updated and Expanded (Featuring Are You a Good Boss--Or a Great One? by Linda A. Hill and Kent Lineback)
Review, Harvard Business
Goleman, Daniel
Hill, Linda A.
Paperback
The Algorithm: The Hypergrowth Formula That Transformed Tesla, Lululemon, General Motors, and Spacex
McNeill, Jon
Hardcover
The Phoenix Project: A Novel about It, Devops, and Helping Your Business Win
Behr, Kevin
Spafford, George
Kim, Gene
Paperback
Dirtbag Billionaire: How Yvon Chouinard Built Patagonia, Made a Fortune, and Gave It All Away
Gelles, David
Hardcover
Genius at Scale: How Great Leaders Drive Innovation
Hill, Linda A.
Tedards, Emily
Wild, Jason
Hardcover
Anchored, Aligned, Accountable: A Framework for Transcending Bullsh*t and Transforming Our Lives and Work
Bethea, Aiko
Hardcover
The 360 Degree Leader Workbook: Developing Your Influence from Anywhere in the Organization
Maxwell, John C.
Paperback
Getting You Ready for Power: A Woman's Guide to Building Confidence, Community, and Career Success
Meruelo, Alexis
Paperback
Generative Ai: The Insights You Need from Harvard Business Review
Review, Harvard Business
Mollick, Ethan
Cremer, David De
Paperback
Competing in the Age of AI: Strategy and Leadership When Algorithms and Networks Run the World
Lakhani, Karim R.
Iansiti, Marco
Hardcover
The Way of the Shepherd: Seven Secrets to Managing Productive People
Leman, Kevin
Pentak, William
Hardcover
Indispensable: How to Become the Company That Your Customers Can't Live Without
Calloway, Joe
Hardcover
The Asshole Survival Guide: How to Deal with People Who Treat You Like Dirt
Sutton, Robert I.
Paperback
Hbr's 10 Must Reads on Emotional Intelligence, Updated and Expanded (Featuring What Makes a Leader by Daniel Goleman)
Review, Harvard Business
Goleman, Daniel
Ibarra, Hermina
Paperback
The 6 Types of Working Genius: A Better Way to Understand Your Gifts, Your Frustrations, and Your Team
Lencioni, Patrick M.
Hardcover
The Oz Principle: Getting Results Through Individual and Organizational Accountability
Hickman, Craig
Connors, Roger
Smith, Tom
Paperback
The 5 Languages of Appreciation in the Workplace: Empowering Organizations by Encouraging People
Chapman, Gary
White, Paul
Paperback
The One Thing: The Surprisingly Simple Truth about Extraordinary Results
Keller, Gary
Papasan, Jay
Hardcover
Demand-Side Sales 101: Stop Selling and Help Your Customers Make Progress
Engle, Greg
Moesta, Bob
Hardcover
The Heart Work of Modern Leadership: 6 Differentiators of Exceptional Leaders
Grossman, David
Paperback
Playing to Win, Expanded with Bonus HBR Articles: How Strategy Really Works
Lafley, A. G.
Martin, Roger L.
Hardcover
Biblia del Vendedor: Tecnicas Efectivas Para El Vendedor Competitivo
Dey, Alejandro
Dey, Alex
Paperback
The Hard Thing about Hard Things: Building a Business When There Are No Easy Answers
Horowitz, Ben
Hardcover
How to Win Friends and Influence People: Updated for the Next Generation of Leaders
Carnegie, Dale
Hardcover
Inner Excellence: Train Your Mind for Extraordinary Performance and the Best Possible Life
Murphy, Jim
Paperback
Never Settle: Persuasion and Negotiation Skills to Get What You Want
Qureshi, Attia
Richardson, John
Hardcover
The Things We Hide: A Guide to Identifying Hidden Barriers and Leading with Authenticity
Dickerhoof, Tyler
Hardcover
Difficult Conversations: How to Discuss What Matters Most
Heen, Sheila
Patton, Bruce
Stone, Douglas
Paperback
The Octopus Organization: A Guide to Thriving in a World of Continuous Transformation
Le-Brun, Phil
Werner, Jana
Hardcover
Leadership Unblocked: Break Through the Beliefs That Limit Your Potential
Wilkins, Muriel M.
Hardcover
Say This, Not That: How to Master 7 Dreaded Conversations As a Leader in the Modern Workplace
Flickinger, Chris
Paperback
You Don't Need a Title to Be a Leader: How Anyone, Anywhere, Can Make a Positive Difference
Sanborn, Mark
Hardcover
What Could Possibly Go Right?: The Essential Journey to Scale an Enduring Culture
Meyer, Danny
Hardcover
The Founder's Mentality: How to Overcome the Predictable Crises of Growth
Allen, James
Zook, Chris
Hardcover
Team Topologies, 2nd Edition: Organizing Business and Technology for Fast Flow of Value
Skelton, Matthew
Pais, Manuel
Paperback
Positive Intelligence: Why Only 20% of Teams and Individuals Achieve Their True Potential and How You Can Achieve Yours
Chamine, Shirzad
Hardcover
The Leading the Unleadable: How to Manage Mavericks, Cynics, Divas, and Other Difficult People
Willett, Alan
Paperback
The Advantage: Why Organizational Health Trumps Everything Else in Business
Lencioni, Patrick M.
Hardcover
The Trusted Advisor: 20th Anniversary Edition
Maister, David H.
Galford, Robert
Green, Charles
Paperback
The Outsiders: Eight Unconventional CEOs and Their Radically Rational Blueprint for Success
Thorndike, William N.
Hardcover
The New Gold Standard: 5 Leadership Principles for Creating a Legendary Customer Experience Courtesy of the Ritz-Carlton Hotel Company
Michelli, Joseph A.
Hardcover
The 21 Irrefutable Laws of Leadership: Follow Them and People Will Follow You
Maxwell, John C.
Hardcover
The Practice of Adaptive Leadership: Tools and Tactics for Changing Your Organization and the World
Grashow, Alexander
Linsky, Marty
Heifetz, Ronald A.
Hardcover
The Lean Six SIGMA Pocket Toolbook: A Quick Reference Guide to Nearly 100 Tools for Improving Quality and Speed
Rowlands, David T.
Price, Mark
George, Michael L.
Paperback
Rewired: McKinsey's Playbook on How Leading Companies Win with Technology and AI
Levin, Robert
Lamarre, Eric
Smaje, Kate
Hardcover
Human + Machine, Updated and Expanded: Reimagining Work in the Age of AI
Daugherty, Paul R.
Wilson, H. James
Hardcover
The Effective Executive: The Definitive Guide to Getting the Right Things Done
Drucker, Peter F.
Paperback
The Challenger Sale: Taking Control of the Customer Conversation
Dixon, Matthew
Adamson, Brent
Hardcover
Harvard Business Review Entrepreneur's Handbook: Everything You Need to Launch and Grow Your New Business
Review, Harvard Business
Paperback
Nolo's Guide to Single-Member Llcs: How to Form & Run Your Single-Member Limited Liability Company
Steingold, David M.
Paperback
Fight Less, Win More: How Master Negotiators Influence Hearts, Minds, and Deals
Gaunt, Derek
Smith, Jonathan B.
Hardcover
Scaling Up: How a Few Companies Make It...and Why the Rest Don't (Rockefeller Habits 2.0)
Harnish, Verne
Paperback
Dare to Think Differently: How Open-Mindedness Creates Exceptional Decision-Making
Zaltman, Gerald
Hardcover
Tax-Free Wealth: How to Build Massive Wealth by Permanently Lowering Your Taxes
Wheelwright, Tom
Paperback
The Next Conversation Workbook: Practical Exercises for Arguing Less and Talking More
Fisher, Jefferson
Paperback
The 360 Degree Leader: Developing Your Influence from Anywhere in the Organization
Maxwell, John C.
Paperback
The Ideal Team Player: How to Recognize and Cultivate the Three Essential Virtues
Lencioni, Patrick M.
Hardcover