Algorithm and software implementation of manufacturing process duration and production department duration management

Abstract

The present application relates to the field of manufacturing production management, and in particular to a kind of manufacturing "process duration" and "production department duration" management algorithm and software implementation scheme.Solve the problems such as low efficiency, different standards, insufficient accuracy and difficult to trace caused by duration relying on manual calculation in prior art.The technical scheme includes: by listening to the "change of belonging department" and "change of process state" event of production order, automatically generating and updating "department duration" or "process duration" record;Define duration rules and overdue determination logic;Provide multi-dimensional statistical filtering function based on production order, department, process, worker, etc., generate detail table and statistical table.The present application realizes the automation and standardization management of duration, significantly improves production efficiency and data analysis capability.

Description

Technical Field

[0001] This invention relates to the field of information management technology in manufacturing, and in particular to an algorithm and software implementation scheme for the automated calculation, tracking and management of "process duration" and "production department duration" in the manufacturing production process. Background Technology

[0002] In production management within discrete manufacturing industries (such as jewelry, apparel, and machinery), accurately calculating the dwell time (i.e., lead time) of each production order in each department and process is crucial for production efficiency assessment, cost control, performance evaluation, and order delivery forecasting. Currently, the industry commonly faces the following problems:

[0003] 1. Manually driven and inefficient: Most factories rely on managers to manually record and calculate the timeline using Excel spreadsheets. This is a heavy workload, prone to errors, and results in significant delays.

[0004] 2. Lack of standards and difficulty in unification: Different factories and even different managers in the same factory use different rules for calculating the work period (such as whether to deduct non-working days and the method of converting working hours), which makes it impossible to compare data horizontally and lacks a reliable basis for management decisions.

[0005] 3. Data is scattered and difficult to trace: Information on departmental handover and process flow in the production process is scattered across different documents or systems, making it difficult to automatically link and integrate them, and making it impossible to quickly trace overdue links and responsible parties.

[0006] 4. Limited statistical dimensions and superficial analysis: Existing methods are unable to support real-time statistics and analysis across multiple dimensions (such as by department, process, worker, material type, etc.), and cannot provide data support for refined management.

[0007] 5. Although some production management (MES) software involves schedule management, its algorithms are mostly black boxes or strongly coupled with specific business functions, lacking a universal, transparent, and configurable standard algorithm to solve the above pain points. Summary of the Invention

[0008] (a) Technical problems to be solved

[0009] This invention aims to solve the technical problems of existing manufacturing schedule management, such as reliance on manual labor, inconsistent calculation standards, low efficiency, insufficient accuracy, and lack of multi-dimensional analysis capabilities.

[0010] (II) Technical Solution

[0011] To achieve the above objectives, the present invention adopts the following technical solution:

[0012] The core of an automated management method for manufacturing production schedules lies in establishing a detailed schedule data model, defining an event-driven record generation and update mechanism, implementing an accurate schedule calculation algorithm, and designing multi-dimensional statistical and display functions.

[0013] First, establish a detailed data model for the project schedule. Design a detailed schedule table in the database, which includes, but is not limited to, the following fields: production order number, department, process, operator, worker, schedule dimension (department schedule / process schedule), start time, end time, actual schedule, estimated schedule, cumulative schedule, overdue time, and whether it is overdue.

[0014] Secondly, an event-driven record generation and update mechanism is defined. When the department attribute of a production order changes, the system automatically generates a new record to identify the department's duration, recording information such as the new department and start time. When the production order leaves the department or is completed / scrapped, the system automatically updates the end time of the record and triggers duration calculation. When the status of a certain process in a production order changes to "issued," the system automatically generates a new record to identify the process duration, recording information such as the process, worker, and start time. When the status of the process changes to "returned" or the production order is scrapped, the system automatically updates the end time and triggers calculation.

[0015] Next, a precise schedule calculation algorithm was implemented, ensuring the accuracy and consistency of the calculation results through preset rounding rules. Finally, multi-dimensional statistical and display functions were designed, providing two functional views based on the above detailed data: schedule details query and schedule statistics. Users can freely select dimensions such as production order number, business object, department, process, worker, and whether it is overdue for filtering, grouping, and statistics as needed. The results are presented in tabular form and can be exported and printed.

[0016] (III) Beneficial Effects

[0017] Compared with the prior art, the technical solution provided by the present invention has the following significant advantages:

[0018] 1. Automation and high efficiency: Data recording and calculation are automatically triggered by system events, completely replacing manual data entry and greatly improving work efficiency and data real-time performance.

[0019] 2. Standardization and accuracy: Calculations are performed using unified and well-defined algorithmic rules (such as rounding rules and overdue judgment logic), ensuring the standardization and comparability of schedule data across the entire plant and even the entire industry.

[0020] 3. Refined Management and Traceability: Dual-dimensional timeline tracking of "departments" and "processes" can accurately pinpoint production bottlenecks and responsible links, providing a solid data foundation for management optimization.

[0021] 4. Powerful analysis functions: Multi-dimensional statistical filtering functions enable managers to quickly analyze project performance from different perspectives, meeting the needs of various management scenarios.

[0022] 5. Universality and scalability: This invention extracts the common needs of manufacturing schedule management. The algorithm logic is independent of specific business operations, has good universality and configurability, and is easy to promote and apply in different manufacturing enterprises. Attached Figure Description

[0023] Figure 1 This is a schematic diagram of the user interface for the project schedule detail table provided in an embodiment of the present invention.

[0024] Figure 2 This is a schematic diagram of the user interface for the project schedule statistics table provided in an embodiment of the present invention. Detailed Implementation

[0025] The present invention will now be described in detail with reference to the accompanying drawings and embodiments.

[0026] A typical implementation of the present invention is to integrate it into an existing Manufacturing Execution System (MES) or Enterprise Resource Planning (ERP) system.

[0027] Data source: The system monitors database change events (such as updates to the department field and process status field) in modules such as production order management and workshop operation management in real time through interfaces, and uses these as trigger signals.

[0028] Record generation and updating:

[0029] Taking "change of department" as an example: When the system detects that the department of a production order has changed from "molding department" to "stone inlay department", it immediately performs the following operations:

[0030] 1. Generate a new project schedule detail record.

[0031] 2. Set the duration dimension field to "Department Duration", the department to "Stone Inlay Department", the start time to the current timestamp, and fill in other basic information (production order number, product information, etc.).

[0032] 3. At the same time, the previous departmental work period record belonging to the "Modeling Department" will be updated: its end time will be set to the timestamp before the department change, and the actual work period, cumulative work period, overdue time and whether it is overdue will be automatically calculated.

[0033] Calculation logic: All project duration calculations are completed in the background service to ensure compliance with the rounding rules and overdue judgment logic defined in the claims.

[0034] Front-end interaction: Users can, for example, Figure 1The "Construction Schedule Details" page shows all original records, and allows for multi-dimensional queries using filters. (The rest of the text appears to be unrelated and likely refers to a different page.) Figure 2 On the “Construction Period Statistics” page shown, after the user selects the statistical dimension (such as by “Department”), the system background executes a grouped aggregation query to generate a statistical report.

[0035] This invention, through the combination of the aforementioned hardware and software, achieves automated, refined, and standardized management of manufacturing production schedules, effectively solving the various problems raised in the background art.

Claims

1. A method for automated management of production schedules in manufacturing, characterized in that, Includes the following steps: In response to a status change event of a production order in the production management system, the status change event includes a change of department or a change of process status; If a change in the department to which the production order belongs is detected, a departmental schedule record will be automatically generated and populated with the basic information of the production order, the department to which it belongs, the schedule dimension marked as "departmental schedule", and the start time when the record was changed. If the status of a specific process in the production order changes to "issued," a process duration record is automatically generated. This record is then filled with the basic production order information, process information, operator and worker information, duration dimension marked as "process duration," and the start time when the record was changed. When the department to which the production order belongs changes again, or the status changes to "scrapped" or "sold," the end time of the corresponding last department duration record is updated. Based on the difference between the start and end times, the actual duration, cumulative duration, overdue time, and overdue flag of the record are calculated and filled according to preset rounding rules. When the status of a specific process in the production order changes to "returned" or the production order status changes to "scrapped," the end time of the corresponding last process duration record is updated. Based on the difference between the start and end times, the actual duration, cumulative duration, overdue time, and overdue flag of the record are calculated and filled according to preset rounding rules. Based on all generated duration records, the system provides functions for filtering and statistical analysis by multiple dimensions and generating duration detail tables and duration statistics tables.

2. The method according to claim 1, characterized in that, The calculation logic for the overdue time is as follows: For records with the duration dimension of "department duration", the overdue time = the sum of the actual durations of all duration records under the same department for that production order - the department's preset estimated duration; For records with the duration dimension of "process duration", the overdue time = the actual duration of that record - the preset estimated duration of that process; If the calculated overdue time ≤ 0 or the estimated duration is null, the overdue time will be displayed as null.

3. The method according to claim 1, characterized in that, The various statistical dimensions include all or a combination of the following: production order number, business object, document type, product category, product type, product material, product sub-code, department, process, worker, production period dimension, and whether it is overdue.

4. A computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the manufacturing production schedule automation management method as described in any one of claims 1 to 3.

Images