{"corpus_id":116413782,"paper_sha":"027c2f393678fdcf8ac9947ee1f8ebfb348f6be9","doi":"10.1504/EJIE.2019.10020073","arxiv_id":null,"pmid":null,"pmcid":null,"mag_id":2923837574,"dblp_id":null,"acl_id":null,"title":"Development of an operational and tactical decision support tool for a Canadian beverage firm: a case study","year":2019,"publication_date":"2019-03-27","venue":"European J. of Industrial Engineering","journal":{"name":"European J. of Industrial Engineering","pages":null,"volume":null},"journal_issn":null,"journal_title":null,"publication_types":[],"pubmed_pub_types":null,"s2_fields_of_study":["Business","Engineering"],"reference_count":0,"citation_count":3,"influential_citation_count":0,"is_open_access":false,"arxiv_categories":null,"arxiv_license":null,"arxiv_journal_ref":null,"mesh_headings":null,"chemicals":null,"comments_corrections":null,"source_flags":1,"s2_open_access_pdf_url":null,"s2_open_access_landing_url":null,"s2_open_access_license":null,"s2_open_access_status":null,"pmc_open_access_pdf_url":null,"pmc_open_access_landing_url":null,"pmc_open_access_license":null,"pmc_open_access_status":null,"unpaywall_open_access_pdf_url":null,"unpaywall_open_access_landing_url":null,"unpaywall_open_access_license":null,"unpaywall_open_access_status":null,"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]","claims":[{"public_id":"cl_eced4db6b2bc1ae92fdcf96a87ec2c1e","status":"active","text":"The optimisation model was built and implemented in Excel with VBA as a customised planning tool for a Canadian beverage manufacturer and distributor.","confidence":0.95,"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/claims/cl_eced4db6b2bc1ae92fdcf96a87ec2c1e"},{"public_id":"cl_9bd1baf121d39ac1f896ce0199d88f1e","status":"active","text":"The tool changed the company's business planning by evaluating 'what if' scenarios, finding an optimal operational plan, and forcing the company to think more strategically and for longer horizons.","confidence":0.85,"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/claims/cl_9bd1baf121d39ac1f896ce0199d88f1e"},{"public_id":"cl_907e91ada98cd74072f541b028ddae03","status":"active","text":"The tool was originally designed for operational planning but first used for tactical planning, including price negotiations with subcontractors, deciding whether to buy a bankrupt subcontractor production site, and quantification of carrying extra inventory.","confidence":0.9,"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/claims/cl_907e91ada98cd74072f541b028ddae03"}],"concepts":[{"public_id":"co_0770c7e633f6c2b0df242262a66d87b5","status":"active","name":"what if scenarios","description":"Scenario evaluation capability enabled by the tool to explore alternative business plans.","types":["capability"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_0770c7e633f6c2b0df242262a66d87b5"},{"public_id":"co_0853767d59b0507e47c0250f4a373b50","status":"active","name":"bankrupt subcontractor production site","description":"A production site of a bankrupt subcontractor that the company considered buying, evaluated using the tool.","types":["asset"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_0853767d59b0507e47c0250f4a373b50"},{"public_id":"co_2cac981617cb705b0931e30fc2efb319","status":"active","name":"optimisation model","description":"A logistics optimisation model built in Excel with VBA to determine production, distribution and inventory plans for a beverage product line.","types":["method"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_2cac981617cb705b0931e30fc2efb319"},{"public_id":"co_372d2f50db909188b1b2f1e9768da343","status":"active","name":"tactical planning","description":"The actual first use of the tool by the company, involving price negotiations, acquisition decisions, and inventory carrying cost analysis.","types":["planning type"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_372d2f50db909188b1b2f1e9768da343"},{"public_id":"co_4d37e53a41ea3b0393907a24348ace58","status":"active","name":"carrying extra inventory","description":"The quantification of the cost and benefit of holding additional inventory, another tactical use of the tool.","types":["decision"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_4d37e53a41ea3b0393907a24348ace58"},{"public_id":"co_5b45a67b1588ce6da88001a638948731","status":"active","name":"subcontractor negotiations","description":"Price negotiations with the firm's subcontractors, one of the tactical planning applications of the tool.","types":["activity"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_5b45a67b1588ce6da88001a638948731"},{"public_id":"co_a18cb4b3cef3b607db4e784650698f72","status":"active","name":"Excel with VBA","description":"The software platform used to implement the customised planning tool, combining Excel spreadsheets with VBA programming.","types":["tool"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_a18cb4b3cef3b607db4e784650698f72"},{"public_id":"co_ab6d76474a96d9883837f74ae9d1447b","status":"active","name":"optimal operational plan","description":"The best production, distribution and inventory plan found by the optimisation model.","types":["output"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_ab6d76474a96d9883837f74ae9d1447b"},{"public_id":"co_bbfcc5564f29d2f9cefcb91ca90aeb43","status":"active","name":"operational planning","description":"The original intended use of the tool, focusing on day-to-day production, distribution and inventory decisions.","types":["planning type"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_bbfcc5564f29d2f9cefcb91ca90aeb43"},{"public_id":"co_e225cf86cd7efe874d6f543dc6048b97","status":"active","name":"strategic thinking","description":"The shift in the company's planning approach toward longer horizons and more strategic considerations, influenced by the tool.","types":["outcome"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_e225cf86cd7efe874d6f543dc6048b97"},{"public_id":"co_e625654ec513a103a1c979d2b9d073e3","status":"active","name":"Canadian beverage manufacturer and distributor","description":"The company that commissioned the case study, a Canadian beverage firm facing production shortages, stock-outs and high transportation costs.","types":["organization"],"aliases":[],"contributors":[{"id":2,"public_id":"4715169a40","public_label":"AK (4715169a40)","roles":["extraction"],"url":"https://sah.borca.ai/u/4715169a40"},{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["review"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_e625654ec513a103a1c979d2b9d073e3"}],"external_ids":{"DOI":"10.1504/EJIE.2019.10020073","ArXiv":null,"PubMed":null,"PubMedCentral":null,"MAG":2923837574,"DBLP":null,"ACL":null},"open_access":{"is_open_access":false,"pdf_url":null,"landing_url":"https://sah.borca.ai/papers/116413782","source":null,"pdf_url_source":null,"license":null,"reason":"pdf_url_not_indexed"},"reference_availability":{"status":"unknown","references_indexed":false,"full_text_available":false,"full_text_source":null,"count_basis":"semantic_scholar_metadata","extraction_status":"not_applicable","reason":null},"source":{"provider":"episteme2","base_corpus":"semantic_scholar_dump","freshness_mode":"unknown","basis":["semantic_scholar_metadata","postgres_metadata"],"limits":["paper metadata is based on indexed upstream scholarly datasets","claims and concepts are available only for extracted papers","absence of claims or concepts means no extracted graph data is available in this response"],"status":"available","degraded":false,"degraded_reasons":[],"diagnostics":{"status":"available","degraded":false,"degraded_reasons":[],"metadata_status":"available","graph_status":"available","abstract_status":"available"},"source_flags":1},"paper_id":632421,"paper_uid":"0fb99490-7713-4bc6-a575-8dff8290d2aa","canonical_identity":{"paper_id":632421,"paper_uid":"0fb99490-7713-4bc6-a575-8dff8290d2aa","identity_status":"available","lookup_basis":"semantic_scholar_external_id","compatibility_path":"corpus_id"},"url":"https://sah.borca.ai/papers/116413782"}