This paper was published as a Faculty Working Paper (no. 191) for the Lubin School of Business, Center for Applied Research, November 1999.

Document Type



Sir Arthur Conan Doyle's Sherlock Holmes explains to Watson and the reader how to use Solver, an application of Excel used to solve mathematical programming problems. Holmes walks his audience through modeling the problem in Excel, using Solver to get the optimal solution, a description of variables, a discussion of shadow prices and right-hand sensitivity analysis, and an explanation of reduced costs.