Electronic Proceedings of the Twenty-third Annual International Conference on Technology in Collegiate Mathematics

Denver, Colorado, March 17-20, 2011

Paper C006

This is an electronic reprint, reproduced by permission of Pearson Education Inc. Originally appeared in the Proceedings of the Twenty-third Annual International Conference on Technology in Collegiate Mathematics, ISBN 0-321-68984-4, Copyright (C) 2012 by Pearson Education, Inc.


Using Excel Solver in Optimization Problems

Leslie Chandrakantha


John Jay College of Criminal Justice/CUNY

list of all papers by this author

Click to access this paper: paper.pdf

ABSTRACT

Spreadsheet modeling and Excel Solver can be used in solving optimization problems in an introductory Operations Research course. This is especially useful for students with less mathematics skills. Linear and Nonlinear programming problems from different areas such as manufacturing, transportation, and financial planning are discussed.

Keyword(s): spreadsheets, applications, modeling, linear programming