IDEAS home Printed from
   My bibliography  Save this article

The development of a simulation-based approach to optimise the inventory policy in a single-echelon supply chain: a case study


  • A. Mahamani
  • K. Prahlada Rao
  • V. Pandurangadu


Inventory control is one way to increase profit margins without altering resources. A spreadsheet model was developed for the inventory control of packaging material in a real case study from a fruit juice manufacturing firm. The contribution of this paper is the construction of a spreadsheet model that incorporates a dynamic re-order point policy logic; using the result from the spreadsheet-based approach and analytical approximation method, a best alternate ordering policy for a single-echelon supply chain can be developed by the statistical analysis of the dynamic re-order point, static re-order point and existing ordering policies and the flexibility of the optimal ordering policy was evaluated using a randomly generated demand. The objective of this work is to develop the best ordering policy with a low total inventory cost to ensure a better service efficiency level across a single-echelon supply chain. The reduction in the total inventory costs obtained from the spreadsheet-based approach is compared with the analytical approximation method. This paper provides a basic understanding with respect to the development of an ordering policy for a single-echelon supply chain.

Suggested Citation

  • A. Mahamani & K. Prahlada Rao & V. Pandurangadu, 2008. "The development of a simulation-based approach to optimise the inventory policy in a single-echelon supply chain: a case study," International Journal of Data Analysis Techniques and Strategies, Inderscience Enterprises Ltd, vol. 1(2), pages 173-192.
  • Handle: RePEc:ids:injdan:v:1:y:2008:i:2:p:173-192

    Download full text from publisher

    File URL:
    Download Restriction: Access to full text is restricted to subscribers.

    As the access to this document is restricted, you may want to search for a different version of it.


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

    Cited by:

    1. Sari Viskari & Anita Ruokola & Miia Pirttilä & Timo Kärri, 2012. "Advanced model for working capital management: bridging theory and practice," International Journal of Applied Management Science, Inderscience Enterprises Ltd, vol. 4(1), pages 1-17.


    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:ids:injdan:v:1:y:2008:i:2:p:173-192. See general information about how to correct material in RePEc.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Darren Simpson). General contact details of provider: .

    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 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.

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

    IDEAS is a RePEc service hosted by the Research Division of the Federal Reserve Bank of St. Louis . RePEc uses bibliographic data supplied by the respective publishers.