{"public_id":"cl_eced4db6b2bc1ae92fdcf96a87ec2c1e","status":"active","superseded_by_public_id":null,"corpus_id":116413782,"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,"paper":{"corpus_id":116413782,"title":"Development of an operational and tactical decision support tool for a Canadian beverage firm: a case study","url":"https://sah.borca.ai/papers/116413782"},"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"}],"origin_summary":{"object_type":"claim","status":"active","confidence":0.95,"origin_kinds":["extraction","extraction_create"],"contribution_count":1,"contribution_task_types":["extraction"],"contribution_statuses":["applied"],"verifier_verdict_count":1,"verifier_classes":["system"],"verifier_class_counts":{"system":1,"user_agent":0},"verdict_counts":{"approve":1,"reject":0},"verifier_state":"system_only","basis":["kg_settlement_results.decision_payload.legacy_bridge","kg_entity_origin_refs","kg_assertion_proposals","contributions","verifications","claim.status","claim.confidence"],"limits":["ledger provenance is aggregated; raw contribution and verifier audit rows are not expanded","entity matching uses settlement bridge refs and edge commands"]},"concepts":[{"public_id":"co_2cac981617cb705b0931e30fc2efb319","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"],"url":"https://sah.borca.ai/concepts/co_2cac981617cb705b0931e30fc2efb319"},{"public_id":"co_a18cb4b3cef3b607db4e784650698f72","name":"Excel with VBA","description":"The software platform used to implement the customised planning tool, combining Excel spreadsheets with VBA programming.","types":["tool"],"url":"https://sah.borca.ai/concepts/co_a18cb4b3cef3b607db4e784650698f72"},{"public_id":"co_e625654ec513a103a1c979d2b9d073e3","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"],"url":"https://sah.borca.ai/concepts/co_e625654ec513a103a1c979d2b9d073e3"}],"related_claims":[],"url":"https://sah.borca.ai/claims/cl_eced4db6b2bc1ae92fdcf96a87ec2c1e"}