Teaching Note—Some Practical Issues With Excel Solver: Lessons for Students and Instructors

James R. Evans - evansjr@ucmail.uc.edu
College of Business, University of Cincinnati, Cincinnati, Ohio 45221

Abstract

Spreadsheets have become the principal software application for teaching decision models in most business schools. In particular, Excel Solver is used extensively for solving and analyzing optimization models. However, there are a number of important issues in using Solver of which many users are unaware. These include the impact of spreadsheet design and cell formatting on Solver reports, handling of lower and upper bound constraints, and dealing with the implications of implicit assumptions in spreadsheet models when interpreting Solver sensitivity reports. Students and instructors, as well as most popular textbooks, rarely pay sufficient attention to these issues. This article summarizes these important issues, provides guidelines for avoiding problems, and offers examples that can be incorporated into the classroom.

Key words
excel solver; spreadsheet implementation; model assumptions; sensitivity analysis

History
Received: February 14, 2007; accepted: July 28, 2007. This paper was with the author 1 month for 2 revisions.

Download the PDF
10.1287/ited.8.2.89

Citation Information
Evans, J. R. 2008. Some practical issues with excel solver: Lessons for students and instructors. INFORMS Trans. Ed. 8(2) 89-95. Available online at http://ite.pubs.informs.org/.

DOI: 10.1287/ited.1070.0006