Skip to main content
SpringerLink
Log in

Optimization using spreadsheets on a microcomputer

  • III Interactive Optimization and Microcomputers
  • Published:
Annals of Operations Research Aims and scope Submit manuscript

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. B.W. Arden,What Can Be Automated?The Computer Science and Engineering Research Study (MIT Press, Cambridge, MA, 1980).

    Google Scholar 

  2. I. Benbassat and R. Schroder, An experimental investigation of some MIS design variables, MIS Quart. 1,1(1977)37.

    Article  Google Scholar 

  3. M.L. Fisher, Interactive optimization, Ann. Oper. Res. 5(1985/6)541.

    Article  Google Scholar 

  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. 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. H.C. Lucas, Jr., An experimental investigation of the use of computer-based graphics in decision making, Management Science 27, 7(1981)757.

    Article  Google Scholar 

  7. M.S. Scott Morton, Management decision systems, Division of Research, Graduate School of Business Administration, Harvard University (1971).

  8. R. Sharda and C. Somarajan, Comparative performance of some advanced microcomputer LP systems, Computers and Operations Research (1986) forthcoming.

Download references

Author information

Authors and Affiliations

  1. Department of Management, College of Business Administration, Oklahoma State University, 74078, Stillwater, OK, USA

    R. Sharda

Authors
  1. R. Sharda
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

About this article

Cite this article

Sharda, R. Optimization using spreadsheets on a microcomputer. Ann Oper Res 5, 599–612 (1986). https://doi.org/10.1007/BF02739241

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF02739241

Keywords and phrases

Search

Navigation