Development of an operational and tactical decision support tool for a Canadian beverage firm: a case study
Mehmet A. Begen,
Martin L. Puterman and
European Journal of Industrial Engineering, 2019, vol. 13, issue 2, 245-263
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)
References: Add references at CitEc
Citations: Track citations by RSS feed
Downloads: (external link)
Access to full text is restricted to subscribers.
This item may be available elsewhere in EconPapers: Search for items with the same title.
Export reference: BibTeX
RIS (EndNote, ProCite, RefMan)
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 ().