Dashboard for the Management and Acceptance of Customer Orders

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.