Engineering a business analytics tool combining value chain optimization and marginal value heat map to improve the decision making process at a recycle plant

该项目旨在应用价值链优化、商业分析和热图的知识，这些知识越来越多地被用于商业智能，为BRQ Fibre&Broyure(BRQ)设计一个先进的商业分析工具。其目的是使公司经理能够评估产品、客户、供应商、地点的不同业务选择，以便做出有效和有利可图的业务决策，以支持业务增长。BRQ是一家总部位于魁北克的公司，提供回收服务，将建筑、翻新和拆除(CRD)材料中的废木转化为经过认证的清洁工业级材料，如木屑、纤维碳材料、有机生物质。在业务发展中，经理面临的挑战之一是识别客户和供应商，这些客户和供应商处于战略位置，他们的需求和供应与他们的生产和库存能力很好地结合在一起，以降低价值链成本，提高业务运营和利润。令人困惑的是，回收过程是一个发散的过程。在这个过程中可以使用不同的分拣策略，以不同的成本生产不同比例的产品，并导致不同的库存水平。根据客户和供应商所在地的不同，销售价格和运输成本也不同。该公司还面临季节性需求和供应。随着最近企业资源规划(ERP)系统的升级，该项目将帮助公司推进业务分析系统，并将导致决策过程的显著改善。在这个项目中，我们将与BRQ经理、工程师和ERP技术人员密切合作，了解价值链运营。然后，建立价值链优化模型和边际价值热图，并将其联系起来。这一先进的业务分析工具将使经理们能够有效地评估不同的业务选择，可视化业务强度变化，并确定最有利可图的战略。

This project is aimed at applying the knowledge of value chain optimization, business analytics and heat map,more increasingly used for business intelligence, to engineer an advanced business analytic tool for BRQ Fibre& Broyure (BRQ). The objective is to allow the managers of the company to evaluate different businessalternatives on products, customers, suppliers, locations in order to make effective and profitable businessdecisions to support the business growth. BRQ is a Quebec-based company providing recycling services thattransform waste wood from construction, renovation and demolition (CRD) materials into certified cleanindustrial grade materials, such as wood chips, fibrous carbon materials, organic biomass. In businessdevelopment, one of the challenges that the manager faces is to identify the customers and suppliers, which arestrategically located and their demand and supplies are aligned well with their production and stockingcapabilities in order to reduce value chain cost and improve both business operations and profits. Thecomplexity is that recycling process is a divergent process. Different sorting strategies can be used in theprocess, which produces different proportions of products, at different costs, and lead to different inventorylevels. Depending on the customer and supplier locations, selling prices and transportation costs are different.The company also faces seasonal demand and supplies. With the recent upgrading of the enterprise resourceplanning (ERP) system, this project will help the company in advancing the business analytics system and willlead to a significant improvement of the decision making process. In this project, we will work closely with theBRQ managers, engineer and the ERP technical personnel to understand the value chain operations. Then, avalue chain optimization model and marginal value heat map will be developed and connected. This advancedbusiness analytic tool will allow managers to effectively evaluate different business alternatives, visualizebusiness intensity changes and identify the most profitable strategy.