Recipe and Bill of Materials Synchronization via Conflict Resolution
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In process industries, synchronizing recipe changes with bills of materials is complicated due to incomplete data in recipes and the need to scale quantities for production facilities, often requiring the use of alternative materials, necessitating an efficient method to manage these changes effectively.
Innovation Solution
A system and method that parameterizes approved recipes in a planning interface, synchronizes bills of materials with the recipes, and displays conflicts for user resolution, using a graphical user interface to manage conflicts and scale recipes appropriately for production facilities, including the option to select alternative materials and handle multi-level recipes by flattening or iteratively synchronizing sub-recipes.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If recipe changes are manually synchronized with bills of materials, then data accuracy can be maintained, but time consumption and operational complexity increase significantly
Solution Approach 1:
The system enables automatic self-synchronization between recipe changes and bills of materials through event-driven architecture. When a recipe is modified, the system automatically detects the change, identifies affected bills of materials, and propagates updates without requiring manual intervention, thus maintaining data accuracy while eliminating time consumption.
Solution Approach 2:
The system implements a feedback mechanism where bills of materials are continuously monitored for synchronization status with their source recipes. The synchronization flag provides real-time feedback on whether a bill of materials is up-to-date, triggering automatic updates when discrepancies are detected, ensuring data accuracy without manual oversight.
2Ease of manufacture
If recipe data is directly used for manufacturing, then process simplicity is maintained, but manufacturing constraints such as production scaling and material availability cannot be addressed
Solution Approach 1:
The system segments the data model into distinct layers: recipes for research and development and bills of materials for manufacturing. This segmentation allows each layer to serve its specific purpose independently, maintaining process simplicity in R&D while enabling manufacturing-specific adaptations in the bill of materials layer, including production scaling and material substitution.
Solution Approach 2:
The bill of materials acts as an intermediary layer between recipes and manufacturing execution. It receives data from recipes, applies manufacturing constraints such as production scaling factors and material availability, and generates manufacturing-ready instructions, thus bridging the gap between R&D simplicity and manufacturing adaptability.
3Loss of information
If complete manufacturing data is included in recipes, then data completeness for production is achieved, but recipe complexity and data management difficulty increase
Solution Approach 1:
The system divides data management responsibilities between two separate structures: recipes contain only essential formulation and process information for R&D, while bills of materials contain complete manufacturing data including quantities, scaling factors, and material specifications. This segmentation ensures data completeness for production without increasing recipe complexity.
4Productivity
If automatic synchronization is implemented, then operational efficiency is improved, but system complexity and conflict resolution requirements increase
Solution Approach 1:
The automatic synchronization system operates autonomously through event-driven triggers. When a recipe changes, the system automatically identifies affected bills of materials, propagates updates, and sets synchronization flags without requiring complex manual configuration or intervention, improving operational efficiency while keeping system management simple.
Data Source
AI summary
A system and method of synchronizing recipes and bills of materials (BOM). An approved recipe is parameterized in a planning interface. A BOM is synchronized with the parameterized recipe. The BOM is then displayed in a graphical user interface to allow a user to modify by a resolve conflict present during synchronization.