Izvorni znanstveni članak
https://doi.org/10.2478/bsrj-2022-0028
Dashboard for the Management and Acceptance of Customer Orders
Joana Nascimento
; University of Minho, Guimarães, Portugal
Nuno Frazão
; Bosch Car Multimedia Portugal, S.A., Braga, Portugal
Senhorinha Teixeira
; University of Minho, ALGORITMI Center, Guimarães, Portugal
Ana Cecília Ribeiro
orcid.org/0000-0001-7487-7946
; Lusíada University, COMEGI, V. N. Famalicão, Portugal
Sažetak
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.
Ključne riječi
Order variation calculation; flexibility rules; customer order management; dashboard development; data analytics; digital transformation
Hrčak ID:
287474
URI
Datum izdavanja:
18.12.2022.
Posjeta: 303 *