Automation of demand planning and distribution optimizes material allocation across production units

Category

Project

Area

Demand Planning – Sales & Operations Planning (S&OP)

Industry

Manufacturing

Company Size

Large enterprise

Project Duration

10 months

Challenge

The allocation of additional materials across production units was done manually, involving complex monthly calculations based on variables such as quotas, inventory levels, orders, and customer loyalty. This process was time-consuming, prone to errors, and slowed down strategic sales and operations planning.

Proposed solution

Dojo developed an integrated solution combining Data Engineering, Python Scripts, and Business Intelligence, all connected to a robust Data Lake. The project automated the necessary calculations for material distribution and introduced dynamic dashboards to facilitate analysis and planning.

01

Calculation Automation

Integration of data engineering pipelines with standalone Python scripts to perform calculations automatically.

02

Dynamic Visualizations

Development of dashboards in Qlik Sense, enabling real-time tracking of data and S&OP results.

Results achieved

01

Complete automation

Eliminated manual calculations, reducing errors and freeing up time for strategic analysis.

02

Operational efficiency

Improved material distribution across plants, based on reliable data and strategic variables.

03

Enhanced visualizations

Interactive dashboards providing real-time insights to support data-driven decisions in sales and operations planning.