<abstract xmlns="http://www.w3.org/1999/xhtml">

<bold>Background:</bold> This paper focuses on activities related to Customer Orders Management withing an auto components plant in the Automotive Industry. The main challenge was highlighted: customers don’t always regard the flexibility rules agreed with the company. Hence, planners must decide if variation in ordered quantity can be accepted in the forecast period or if adjusting is necessary.
<bold>Objectives:</bold> The purpose was not only to streamline the decision-making process in the planning team but also to provide essential tools for the execution of their daily tasks – a visual and interactive dashboard to assess whether variations in customer orders were within the limits agreed with the company.
<bold>Methods/Approach:</bold> Following Lean information management and business intelligence principles, a thorough process analysis was carried out, centralized and standardized reports were created that served as databases, and the dashboard was developed.
<bold>Results:</bold> The proposed tool allowed reductions from 3,5h per week, spent mainly on collecting data, calculating variations, and selecting and adjusting the flexibility limits, to 0,2h a day per planner.
<bold>Conclusions:</bold> Besides streamlining planners’ daily activities, main contributions regard the promotion of digital transformation, data-driven decision-making, and an automated record of customer order variations that could easily be adapted to suppliers.
</abstract>

Background: This paper focuses on activities related to Customer Orders Management withing an auto components plant in the Automotive Industry. The main challenge was highlighted: customers don’t always regard the flexibility rules agreed with the company. Hence, planners must decide if variation in ordered quantity can be accepted in the forecast period or if adjusting is necessary.
Objectives: The purpose was not only to streamline the decision-making process in the planning team but also to provide essential tools for the execution of their daily tasks – a visual and interactive dashboard to assess whether variations in customer orders were within the limits agreed with the company.
Methods/Approach: Following Lean information management and business intelligence principles, a thorough process analysis was carried out, centralized and standardized reports were created that served as databases, and the dashboard was developed.
Results: The proposed tool allowed reductions from 3,5h per week, spent mainly on collecting data, calculating variations, and selecting and adjusting the flexibility limits, to 0,2h a day per planner.
Conclusions: Besides streamlining planners’ daily activities, main contributions regard the promotion of digital transformation, data-driven decision-making, and an automated record of customer order variations that could easily be adapted to suppliers.

Dashboard for the Management and Acceptance of Customer Orders

Business Systems Research Journal

This work is licensed under the Creative Commons Attribution 4.0 International License.

{"article-title":"Dashboard for the Management and Acceptance of Customer Orders"}

Background: This paper focuses on activities related to Customer Orders Management withing an auto components plant in the Automotive Industry. The main...

Dashboard for the Management and Acceptance of Customer Orders

Publié en ligne: 30 déc. 2022

Pages: 116 - 129

Reçu: 30 janv. 2022

Accepté: 06 nov. 2022

DOI: https://doi.org/10.2478/bsrj-2022-0028

Mots clés
Order variation calculation, flexibility rules, customer order management, dashboard development, data analytics, digital transformation

© 2022 Joana Nascimento et al., published by Sciendo

This work is licensed under the Creative Commons Attribution 4.0 International License.

Dashboard for the Management and Acceptance of Customer Orders

Publié en ligne: 30 déc. 2022

Pages: 116 - 129

Reçu: 30 janv. 2022

Accepté: 06 nov. 2022

DOI: https://doi.org/10.2478/bsrj-2022-0028

Mots clésOrder variation calculation, flexibility rules, customer order management, dashboard development, data analytics, digital transformation

© 2022 Joana Nascimento et al., published by Sciendo

This work is licensed under the Creative Commons Attribution 4.0 International License.

Mots clés
Order variation calculation, flexibility rules, customer order management, dashboard development, data analytics, digital transformation