Annals of Operations Research

, Volume 5, Issue 1–4, pp 599–612 | Cite as

Optimization using spreadsheets on a microcomputer

  • R. Sharda
III Interactive Optimization and Microcomputers


This paper discusses the advantages of using spreadsheets for problem specification and report generation in optimization projects. It summarizes some of the mathematical programming software which is compatible with popular spreadsheets. A small production planning problem is used to illustrate the steps in input and processing of the results. Two programs are compared in detail.

Keywords and phrases

Microcomputers spreadsheets linear programming optimization software 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    B.W. Arden,What Can Be Automated?The Computer Science and Engineering Research Study (MIT Press, Cambridge, MA, 1980).Google Scholar
  2. [2]
    I. Benbassat and R. Schroder, An experimental investigation of some MIS design variables, MIS Quart. 1,1(1977)37.CrossRefGoogle Scholar
  3. [3]
    M.L. Fisher, Interactive optimization, Ann. Oper. Res. 5(1985/6)541.CrossRefGoogle Scholar
  4. [4]
    E. Li and D.E. Ray, Using electronic spreadsheets for designing LP tableaus and for transmission to LP programs, Working Paper No. A.E. 8591, Department of Agricultural Economics, Oklahoma State University, Stillwater, OK 74078 (1985).Google Scholar
  5. [5]
    N.P. Loomba and A.O. Holsinger,Study Guide and Case Studies to Accompany Management -A Quantitative Perspective (Macmillan, New York, 1978).Google Scholar
  6. [6]
    H.C. Lucas, Jr., An experimental investigation of the use of computer-based graphics in decision making, Management Science 27, 7(1981)757.CrossRefGoogle Scholar
  7. [7]
    M.S. Scott Morton, Management decision systems, Division of Research, Graduate School of Business Administration, Harvard University (1971).Google Scholar
  8. [8]
    R. Sharda and C. Somarajan, Comparative performance of some advanced microcomputer LP systems, Computers and Operations Research (1986) forthcoming.Google Scholar

Copyright information

© J.C. Baltzer A.G., Scientific Publishing Company 1986

Authors and Affiliations

  • R. Sharda
    • 1
  1. 1.Department of Management, College of Business AdministrationOklahoma State UniversityStillwaterUSA

Personalised recommendations