Integration of COTS software products ARENA & CPLEX for an inventory/logistics problem

https://doi.org/10.1016/S0305-0548(03)00010-8Get rights and content

Abstract

This paper describes the integration of two commercially available, highly specialized, off-the-shelf software packages—CPLEX and ARENA. We present the need for such integration and the ways in which it differs from the more traditional methods of problem solving. The two products are described in detail followed by an example that requires this integration. A detailed account of the integration is also presented together with drawbacks of this approach.

Scope and purpose

The purpose of this paper is to demonstrate the mechanics of integrating two commonly used Operations Research software packages, CPLEX and ARENA. It then illustrates such integration by analyzing a sample supply chain application in the area of inventory/logistics. A discussion of the paper's findings and potential drawbacks to the approach are provided.

Section snippets

Motivation

Commercial-Off-The-Shelf (COTS) software products are products made available in the market to industries with specialized needs. These products are, in most cases, stand-alone applications. While the manufacturers of COTS products usually allow interfacing with programming languages (C, C++, BASIC, Java, etc.) and give their customers detailed instructions on how they can achieve this interface, they seldom document the possibility of integrating their COTS products with those of other

CPLEX and ARENA

In this section, we introduce the reader to the two COTS products in question, beginning with a brief introduction of the mathematical solver CPLEX and followed by a discussion on the simulation software ARENA.

A Sample supply chain problem requiring COTS integration

We look at a small segment of a Supply Chain with geographically dispersed distribution centers being replenished with product stock from the respective company's manufacturing facilities. These distribution centers are required to fulfill the requirements of customers as the demands for the various product-groups enter a central order management station. The function of the central order management station is to organize the distribution of these product groups to the customers from the

Integration

A major goal of this paper is to illustrate the integration of the COTS software CPLEX and ARENA. In this section, we provide the detailed steps needed to achieve this integration: All entities (demand arrivals) are made to pass through a VBA block as soon as they arrive into the system. As discussed earlier, the entry of an entity into a VBA block triggers a VBA_Block_Fire event. CPLEX is called from within the code for this event. Before CPLEX is called, however, certain attributes of the

Simulation experiment

The first point to be considered while designing a simulation experiment is deciding upon whether the system being modeled is best analyzed via a terminating simulation or a steady-state simulation. See Law and Kelton [14] for an extended discussion.

A terminating simulation is one that has a natural event (E) that specifies the length of each run. A non-terminating simulation, on the other hand, is one for which there is no natural event E to specify the length of a run. It is important to

Summary and limitations & alternatives to COTS integration

The COTS integration approach detailed in this paper is efficient in certain cases (e.g., the example discussed above). In this case the integration approach performs better than the traditional heuristic based approach (greedy order fulfillment policy) of Order Fulfillment.

There are, however, limitations to the use of COTS integration. As discussed in Nemhauser and Wosley [17], solution time for a MIP using the Branch-and-Bound scheme (such as that used by CPLEX) usually increases

Acknowledgements

This work was supported by a grant from Lockheed Martin Systems Integration—Owego. This support is gratefully acknowledged. The authors would also like to thank three anonymous referees for their helpful comments on earlier versions of this paper.

References (17)

  • M. Bogataj et al.

    Combinatorial optimization of the location-inventory problem

    International Journal of Production Economics

    (1992)
  • A.K. Chakravarty et al.

    Optimal multi-product inventory grouping for coordinated periodic replenishment under stochastic demand

    Computers & Operations Research

    (1988)
  • Yakimovich D, Bieman J, Basili VR. Software architecture classification for estimating the cost of COTS integration....
  • Stavridou V. COTS, integration and critical systems. COTS and safety critical systems IEEE colloquium (Digest) IEEE...
  • Verma D. Panel: commercial off-the-shelf (COTS) integration and support. Proceedings of the Annual Reliability and...
  • Stottlemyer AR, Hassett KM. Role of standards in COTS integration projects. Proceedings of the International...
  • ILOG Inc. ILOG CPLEX 6.5—user's manual. ILOG Inc., 1999....
  • ILOG Inc. ILOG CPLEX 6.5—reference manual. ILOG Inc., 1999....
There are more references available in the full text version of this article.

Cited by (30)

View all citing articles on Scopus
View full text