Introducing Integer Modeling with Excel Solver

INFORMS Transactions on Education

Dessislava Pachamanova¹ 

[1] Division of Mathematics and Sciences, Babson College, Babson Park, Massachusetts 02457

关键词: integer programming;    Excel’s Solver;    fixed costs;    spreadsheet modeling;    teaching optimization;   

DOI  :  10.1287/ited.7.1.88

学科分类：社会科学、人文和艺术（综合）

来源: INFORMS

【 摘 要 】

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.

【 授权许可】

CC BY