Optimization: Excel Solver

Jeffrey M. Keisler
Additional contact information
Jeffrey M. Keisler: University of Massachusetts Boston

Chapter 10 in Prescriptive Analytics, 2024, pp 221-246 from Springer

Abstract: Abstract The approach from the previous chapter can be extended to more input variables, resources, or constraints and to include different types of variables such as binary and integer variables, and in other ways, but there is a trade-off between precision and calculation time (as with any simulation) that makes it unattractive to use this approach in Excel for many problems of realistic size. This motivates the use of the Excel Solver add-in. Chapter 10 covers Solver in a rather routine way, covering linear, integer, binary, and nonlinear programming while tying it as much as possible to the previous chapters.

Date: 2024
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:sptchp:978-3-031-59353-6_10

Ordering information: This item can be ordered from
http://www.springer.com/9783031593536

DOI: 10.1007/978-3-031-59353-6_10

Access Statistics for this chapter

More chapters in Springer Texts in Business and Economics from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().