Shop Floor Production Management & Auto-Scheduling
An Odoo 17-based production management system for manufacturing shop floors. Implements priority calculation across 5 constraints, bottleneck visualization, OR-Tools-based auto-scheduling, and a tablet UI.
Duration
Contract development
Team
1-2 people
Client
A manufacturer
01 // OVERVIEW
Project Overview
An Odoo 17-based system that streamlines production management on the shop floor. It calculates task priority from 5 constraints - process sequence, skills, equipment, materials, and setup time - and visualizes bottlenecks in real time. Google OR-Tools-based auto-scheduling improves planning accuracy, and a tablet UI is provided for shop floor workers.
02 // KEY FEATURES
Key Features
Priority calculation based on 5 constraints
Calculates the priority of each task by combining 5 constraints: process sequence, skills, equipment, material stock, and setup time. Constraint information is displayed on the tablet screen so shop floor workers can decide the next process without hesitation.
Bottleneck visualization dashboard
Provides a dashboard that identifies and visualizes the rate-limiting process (bottleneck) on the production line in real time. Managers can see constraints at a glance and decide where to act first.
Auto-scheduling with OR-Tools
An optimization algorithm using Google OR-Tools cut the computation time for 100 tasks from 5 minutes to 60 seconds, and improved optimization accuracy from 60% to 85%. Also uses AI-driven, history-based adjustment suggestions (70-85% accuracy).
03 // TECHNICAL DEEP-DIVE
Technical Highlights
Solution
Integrating a constraint calculation engine into Odoo 17
Since Odoo's standard scheduling can't handle the combined calculation of 5 constraints, built a custom module implementing the priority calculation engine and OR-Tools integration. Also added tablet UI screens to Odoo's web client.
04 // IMPACT & RESULTS
Results
+42%
Improvement in optimization accuracy after adopting OR-Tools
-80%
Reduction in scheduling computation time
5 constraints
Accounts for process sequence, skills, equipment, materials, and setup