Introducing Integer Modeling with Excel Solver

Dessislava Pachamanova - dpachamanova@babson.edu
Division of Mathematics and Sciences, Babson College, Babson
Park, Massachusetts 02457

Abstract

This article suggests ideas for introducing integer modeling of fixed (entry) costs with Excel Solver to business students. The presented example uses concepts from accounting, such as assessing distribution channel profitability, and blends them with management science techniques. The effectiveness of the software use is in integrating it successfully into a comprehensive discussion about assumptions, modeling, limitations, software pitfalls, validation, and implications for managerial decision making.

Download the PDF
pdf 10.1287/ited.7.1.88

Supplement File

Citation Information
Pachamanova, D. 2006. Introducing Integer Modeling with Excel Solver. INFORMS Trans. Ed. 7(1) 88-98. Available online at http://ite.pubs.informs.org/.

DOI: 10.1287/ited.7.1.88