IDEAS home Printed from https://ideas.repec.org/a/inm/ormnsc/v32y1986i3p360-373.html
   My bibliography  Save this article

Extending Planning Languages to Include Optimization Capabilities

Author

Listed:
  • Asim Roy

    (Department of Decision and Information Systems, College of Business, Arizona State University, Tempe, Arizona 85287)

  • L. S. Lasdon

    (Department of General Business, College of Business Administration, University of Texas, Austin, Texas 78712)

  • J. Lordeman

    (Sanus Texas Health Plan, 8600 Freeport Parkway, Irving, Texas 75063)

Abstract

Planning languages and spreadsheet systems are very popular, and the number of new users is increasing dramatically. On larger computers, IFPS, System W, and FCS-EPS are among the most widely used systems; while on personal computers, Multiplan and 1-2-3 enjoy great popularity. Currently, such languages operate mainly as simulators, evaluating specific cases. In this paper, we propose methodology which is useful in designing an optimization capability for these languages. This capability permits the user to designate certain model variables as decisions, constraints, and the objective. Upper and lower limits on the decisions and constraints are also specified. The optimization interface then diagnoses the problem as linear or nonlinear, computes first partial derivatives needed by the solution algorithms, and invokes the appropriate "solver." Information regarding the optimal solution is obtained using the reporting and graphics capabilities of the planning language. Sensitivity analysis and "what if" features permit easy modification of the problem for further analysis. These ideas have been implemented in a system called IFPS/OPTIMUM, which provides an optimization capability to users of the widely-used planning language IFPS. A simple IFPS/OPTIMUM example is presented, and two applications are described. Endowing planning languages with an optimization capability promises to increase dramatically the use of optimization. There are already hundreds of thousands of users of planning languages and spreadsheet systems, most of whom are unfamiliar with optimization models or methods. Making optimization a natural extension of systems they understand and find very useful holds great promise, both for applications and for teaching optimization concepts.

Suggested Citation

  • Asim Roy & L. S. Lasdon & J. Lordeman, 1986. "Extending Planning Languages to Include Optimization Capabilities," Management Science, INFORMS, vol. 32(3), pages 360-373, March.
    • Handle: RePEc:inm:ormnsc:v:32:y:1986:i:3:p:360-373
    DOI: 10.1287/mnsc.32.3.360
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/mnsc.32.3.360
    Download Restriction: no
    File URL: https://libkey.io/10.1287/mnsc.32.3.360?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Asim Roy & Jyrki Wallenius, 1991. "Nonlinear and unconstrained multiple‐objective optimization: Algorithm, computation, and application," Naval Research Logistics (NRL), John Wiley & Sons, vol. 38(4), pages 623-635, August.
    2. Huh, S. Y. & Chung, Q. B., 1995. "A model management framework for heterogeneous algebraic models: Object-oriented database management systems approach," Omega, Elsevier, vol. 23(3), pages 235-256, June.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:inm:ormnsc:v:32:y:1986:i:3:p:360-373. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.