Canada Spends Logo

Explorez notre analyse du budget 2026

Grant: Engage Grants Program

École Polytechnique de Montréal

$25,000.00

Developing real-time performance management and business intelligence system with dashboard to improve decision making at a sawmill

EF 2016-17

Résumé
In today's competitive and dynamic business environment, being able to integrate performance managementwith business intelligence (BI) and turn data into business information for better and faster decision-makinghave become an important competitive advantage. This is particularly important for Canadian forest productsindustry to capture business opportunities in the competitive global market environment through real-timeinformation-driven decision-making. In this project, we work with FPInnovations to develop a real-timeperformance management and BI system with dashboard, which can be linked to the mill ERP and databasesystems to support real-time information-driven decision-making and performance improvement for a sawmillcase. Sawmill manufacturing system consists of a multi-stage divergent process from sawing, drying, gradingto finishing that transform logs into different lumber products. Because the process is dealing with wide varietyof logs with different dimensions and qualities and serving different customers with different demand, makingwell-informed decisions to produce the right mix of lumber products and sell to the right customers thatmaximize the yield, satisfy the demand and maximize values are critical. Huge system data are collected butare not used. Due to the current manual decision making process and the lacks of information, the sawmilloften makes late decisions causing financial loses. This real-time performance management and BI systemdevelopment with dashboard will bring performance and business information together from system data. Itwill allow mill managers to track their performance, diagnose and make rectified decisions quickly, and carryout business analysis in real-time supporting better decision-making. The improved decision-making throughtimely information can create significant values for the sawmill and contribute to the stability and sustainabilityof the local forest community.
Programme
Engage Grants Program
Emplacement
Quebec, Canada
Type de bénéficiaire
Academia
Type
Grant
Source
NSERC's Awards Data

Tel que publié

Application id
493484-2016
Name nom
Lodi, Andrea
Department département
Mathématiques et génie industriel
Organization id
64
Institution établissement
École Polytechnique de Montréal
Province en
Québec
Province fr
Québec
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2016
Competition year année de concours
2016
Award amount
25000
Program id
EGP
Program name en
Engage Grants Program
Program name fr
Programme de subventions d'engagement partenariat
Group en
Research partnerships programs
Group fr
Programmes de partenariat
Committee code
1552
Committee name en
Quebec Internal Decision Committee
Committee name fr
Comité de décision interne pour le Québec
Area of application code
520
Area of application group en
Manufacturing processes and products
Area of application group fr
Procédés et produits industriels
Area of application en
Production and operations management
Area of application fr
Production et gestion des opérations
Research subject code
1600
Research subject group en
Industrial engineering
Research subject group fr
Génie industriel
Research subject en
Industrial engineering
Research subject fr
Génie industriel
Partie
1
Nb partie
1
Application title
Developing real-time performance management and business intelligence system with dashboard to improve decision making at a sawmill
Keyword
NSERC
Application summary
In today's competitive and dynamic business environment, being able to integrate performance managementwith business intelligence (BI) and turn data into business information for better and faster decision-makinghave become an important competitive advantage. This is particularly important for Canadian forest productsindustry to capture business opportunities in the competitive global market environment through real-timeinformation-driven decision-making. In this project, we work with FPInnovations to develop a real-timeperformance management and BI system with dashboard, which can be linked to the mill ERP and databasesystems to support real-time information-driven decision-making and performance improvement for a sawmillcase. Sawmill manufacturing system consists of a multi-stage divergent process from sawing, drying, gradingto finishing that transform logs into different lumber products. Because the process is dealing with wide varietyof logs with different dimensions and qualities and serving different customers with different demand, makingwell-informed decisions to produce the right mix of lumber products and sell to the right customers thatmaximize the yield, satisfy the demand and maximize values are critical. Huge system data are collected butare not used. Due to the current manual decision making process and the lacks of information, the sawmilloften makes late decisions causing financial loses. This real-time performance management and BI systemdevelopment with dashboard will bring performance and business information together from system data. Itwill allow mill managers to track their performance, diagnose and make rectified decisions quickly, and carryout business analysis in real-time supporting better decision-making. The improved decision-making throughtimely information can create significant values for the sawmill and contribute to the stability and sustainabilityof the local forest community.