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

Mehmet A. Begen, Martin L. Puterman and Hongtu Wu

European Journal of Industrial Engineering, 2019, vol. 13, issue 2, 245-263

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]

Keywords: operations research practice; decision support systems; optimisation; operational and tactical planning; Excel Solver; visual basic for applications; VBA. (search for similar items in EconPapers)
Date: 2019
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=98515 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ids:eujine:v:13:y:2019:i:2:p:245-263

Access Statistics for this article

More articles in European Journal of Industrial Engineering from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().