Solver in Excel and VBA

Name: Solver in Excel and VBA (English version)
SKU: 9B11E028

Mehmet A. Begen; Wei Xia

Product #:9B11E028

Supplier:Ivey

Discipline:Management Science

Setting:2011

Details:Note (PDF) • 23 pages • 2011-08-22 (Rev: 2014-06-11)

Subjects:

Analytics and data science Data science

Your Price:

$9.71

Purchase this material with a free Educator Account and enjoy more benefits:

Free Educator Copy
Free Teaching Notes
Build your coursepack
Discounted academic price

This note is an introduction to Solver in Excel and Visual Basic for Applications (VBA). Solver is a Microsoft Excel tool that determines variables and objective function values of linear, integer, binary, and non-linear optimization models. These models are used in insurance, finance, operations, logistics, engineering, and medicine. This note uses screenshots to help demonstrate various examples of the use of Solver, including assembling a portfolio of ideal stocks and assigning the location of fire stations in cities.