IDEAS home Printed from https://ideas.repec.org/a/ids/eujine/v13y2019i2p245-263.html
   My bibliography  Save this article

Development of an operational and tactical decision support tool for a Canadian beverage firm: a case study

Author

Listed:
  • Mehmet A. Begen
  • Martin L. Puterman
  • Hongtu Wu

Abstract

This paper describes a logistics optimisation case study for a Canadian beverage manufacturer and distributor. The goal was to determine production, distribution and inventory plans for a given product line to help the company with its challenges due to production shortages, stock-outs and high transportation costs in a new and highly competitive market. We built and implemented an optimisation model in Excel with VBA as a customised planning tool. Although we originally designed the tool for operational planning, the beverage company first used it for tactical planning (in price negotiations with the firm's subcontractors, deciding whether to buy a bankrupt subcontractor production site, and quantification of carrying extra inventory). The tool has changed the way the company conducts its business planning by evaluating 'what if' scenarios, finding an optimal operational plan, and forcing the company to think more strategically and for longer horizons. [Received: 21 January 2017; Revised: 30 March 2018; Revised: 30 September 2018; Accepted: 28 October 2018]

Suggested Citation

  • Mehmet A. Begen & Martin L. Puterman & Hongtu Wu, 2019. "Development of an operational and tactical decision support tool for a Canadian beverage firm: a case study," European Journal of Industrial Engineering, Inderscience Enterprises Ltd, vol. 13(2), pages 245-263.
    • Handle: RePEc:ids:eujine:v:13:y:2019:i:2:p:245-263
    as

    Download full text from publisher

    File URL: http://www.inderscience.com/link.php?id=98515
    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.

    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:ids:eujine:v:13:y:2019:i:2:p:245-263. 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: Sarah Parker (email available below). General contact details of provider: http://www.inderscience.com/browse/index.php?journalID=210 .

    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.