1. Company Context
A mechanical engineering company needed a system to monitor processing times, costs, quality, and the use of human and machine resources. The goal was to integrate data from estimates, production, and invoicing to improve efficiency and profitability.
2. The Integrated Dashboard by Infosfera
Infosfera developed a KPI/OKR management dashboard that centralizes data from:
- Quotation System: to compare estimated and actual costs.
- Work Orders: to monitor the progress of production phases.
- Control Sheets: to ensure the quality of each produced batch.
- Human Resources Management: to plan shifts and verify optimal personnel utilization.
- Machine Monitoring: to control efficiency, usage times, and unplanned downtimes.
Main KPIs/OKRs monitored:
- Average completion time per order.
- Deviation between estimated and actual production costs.
- Machine utilization rate and downtime incidence.
- Contribution margin on each order (derived from invoicing data and actual costs).
- Percentage of delivery delays compared to agreed terms.
3. High-Level Steps (HLS) Flow Used
To create the dashboard, Infosfera followed a structured 5-phase process:
- Requirements Gathering
- Analysis of the company’s needs (quotations, management control, human resources, machinery).
- Definition of key objectives (KPIs and OKRs).
- Design
- Definition of data architecture and integrations with existing systems (ERP, spreadsheets, CNC software).
- Development of graphical layouts and functional sections of the dashboard.
- Development
- Implementation of back-end components (database, connectors, APIs).
- Creation of front-end views with KPI charts and tables.
- Testing & Deployment
- Functional verification and stress testing to ensure reliability and adequate performance.
- Release in the production environment with user training.
- Monitoring & Optimization
- Collection of feedback from production departments and management.
- Periodic optimizations of the interface and KPI calculations, in line with the company’s growth needs.
4. Main Benefits
- Reduction of Downtime: real-time monitoring of processes and resources.
- Improved Quotation Accuracy: continuous comparison between estimated and actual costs.
- Enhanced Quality Control: automatic and centralized recording of checks.
- Process Optimization: integrated planning of shifts and production flows.
- Complete Economic Visibility: analysis of costs and economic values related to each order, thanks to invoicing data (without managing invoice issuance).
Conclusion
The Integrated Dashboard developed by Infosfera, based on a 5-phase HLS flow, enabled the precision mechanical engineering company to control times, costs, resources, and invoicing data synergistically, optimizing production processes and increasing market competitiveness.