Complete set of material management and control method, system and computer equipment
By establishing a two-way association index and dynamic management between complete sets and sub-items, the problem of lack of dynamic maintenance of association relationships in the management of complete sets of materials has been solved, realizing close integration of procurement and production and efficient utilization of inventory, ensuring the stability of material supply and the continuity of production.
Patent Information
- Application Number
- CN202511194673.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2025-08-26
- Publication Date
- 2026-01-16
- Estimated Expiration
- 2045-08-26
AI Technical Summary
In the existing management of complete sets of materials, the relationship between complete sets and sub-items lacks dynamic maintenance, making it difficult to ensure the compatibility of complete sets when sub-item information changes; purchase orders are not closely linked to production needs, making it impossible to accurately control the procurement pace; and the matching of inventory information with requisition needs lacks real-time verification, which easily leads to over-requisition or inventory backlog.
By establishing a two-way association index between complete sets and sub-items, arrival traceability codes are generated, real-time verification of dynamic inventory data is performed, purchase orders are linked to production nodes, material allocation weights are calculated, storage locations are optimized, and loss warnings are monitored in real time, enabling full-process traceability and dynamic adjustment.
Ensure proper matching of complete sets and sub-items, link procurement plans with production schedules, avoid inventory backlog, improve inventory utilization efficiency and requisition accuracy, optimize cost control, and reduce material waste and loss.
Smart Images

Figure CN120707253B_ABST
Abstract
Description
TECHNICAL FIELD
[0001] The present application relates to the technical field of data processing, in particular to a complete set of material management and control method and system and computer equipment. BACKGROUND
[0002] The statements in this section merely provide background technology related to the present application and do not necessarily constitute prior art.
[0003] In the equipment manufacturing industry, especially in the shipbuilding field, the management of complete sets of materials is the core component of the supply chain link. Such materials cover mechanical equipment, electrical components, pipe fittings and other types, not only a wide variety, complex specifications, but also involving batch procurement, scattered use, long-term storage and other links, with extremely high management complexity. With the continuous development of industry technology, the production rhythm is accelerating, and higher requirements are put forward for the tracking accuracy, timeliness of supply and rationality of inventory of complete sets of materials. The traditional management method relies on manual recording and operation, and when dealing with large-scale, multi-batch complete sets of material flow, it gradually exposes problems such as low efficiency and information lag, which is difficult to meet the fine needs of modern production for material management.
[0004] However, the current complete set of material management and control scheme has the following problems: the association relationship between the complete set and the sub-item lacks a dynamic maintenance mechanism, making it difficult to ensure the matching of the complete set when the sub-item information changes; the connection between the purchase order and the production demand is not close enough, and the purchase rhythm cannot be accurately controlled according to the production node; the matching of inventory information and demand for use lacks real-time verification, and it is easy to have over-apply or inventory accumulation. SUMMARY
[0005] In order to solve the problems of the prior art, the present application provides a complete set of material management and control method, system and computer equipment, which effectively avoids over-apply or inventory accumulation, improves the inventory utilization efficiency and the accuracy of use, and further ensures the stability of production progress and optimizes the cost control.
[0006] In order to achieve the above purpose, the present application adopts the following technical scheme:
[0007] In the first aspect, the present application provides a complete set of material management and control method.
[0008] A complete set of material management and control method, comprising the following processes:
[0009] Establishing a bidirectional association index of the complete set and the sub-item, when receiving a complete set procurement application, according to the bidirectional association index, displaying the complete set to be purchased and the contained sub-item in association;
[0010] According to the received purchase order arrival information, generating an arrival trace code of the arrived sub-item;
[0011] Based on the received kit requisition application, determine the sub-items of the kit according to the bidirectional association index, and determine the kits to be issued and update the kit inventory according to the traceability code of the determined sub-items and the approved requisition application form.
[0012] When a sub-item requisition request is received, the sub-item to be shipped is determined based on the sub-item's arrival traceability code and the approved requisition request form, and the sub-item inventory is updated simultaneously. The kit inventory is updated based on the bidirectional association index and the updated sub-item inventory.
[0013] When sub-item information is edited, an association check is triggered. If the quantity ratio between sub-items exceeds a preset ratio threshold, a prompt message is issued to remind the user to adjust the quantity of related sub-items.
[0014] In one implementation of the first aspect of the present invention, when establishing a bidirectional association index between the kit and its sub-items, the proportion weight of the sub-items in the kit is recorded to verify the matching degree between the number of sub-items and the overall requirements of the kit.
[0015] In one implementation of the first aspect of the present invention, when binding a purchase order to a production node, the production node time window in the production planning module is retrieved, and the delivery date is set to a preset number of days before the start date of the window. The preset number of days is used to reserve time for material warehousing inspection and allocation. When verifying the sub-item information of the requisition application, the available inventory dynamic value of the sub-item is displayed. The available inventory dynamic value is the current inventory minus the amount of the application that has been approved but not yet issued.
[0016] In one implementation of the first aspect of the present invention, when processing the outbound procedures, if there is a difference between the actual outbound quantity and the requested quantity, a difference association form is generated, the un-outbound portion is marked as pending replenishment, and associated with the corresponding purchase order.
[0017] When retrieving sub-item information, the system calls the industry specification database to compare the deviation between the entered value and the standard value, and generates a standardized mapping code for non-standard specification sub-items, so as to realize the association retrieval between non-standard sub-items and standard sub-items when conducting procurement and requisition queries.
[0018] In one implementation of the first aspect of the present invention, the data is collected through an ERP system. Actual demand quantity of each component in the kit at each production stage Average demand throughout the entire production cycle Standard deviation of demand quantity In the Production phase demand urgency rating , No. Total duration of the production phase In the Initial inventory levels at the start of the production phase and the maximum inventory capacity ;
[0019] According to the first actual number of sub-items of the complete set required in each production stage average number of sub-items of the complete set required in the entire production cycle standard deviation of the number of requirements , the production demand fluctuation coefficient of the first sub-item of the complete set in the first production stage is calculated ;
[0020] According to the production demand fluctuation coefficient , the demand urgency score , the total duration of the first production stage , the inventory quantity at the beginning of the first production stage and the maximum inventory capacity , the distribution weight of the first sub-item of the complete set in the first production stage is obtained , and the distribution order of each sub-item in each production stage is sorted according to the size of the distribution weight , and the sub-item with a high weight is preferentially allocated to the material.
[0021] In an implementation form of the first aspect of the present application, the volume of each storage location, the current space utilization, the volume of each sub-item of the complete set, the access frequency and the access cost coefficient of each sub-item in different storage locations are collected.
[0022] According to the current space utilization, the volume of each sub-item of the complete set and the access cost coefficient of each sub-item in different storage locations, the storage location weight is calculated.
[0023] According to the storage location weight, the volume of each sub-item of the complete set, the volume of each storage location and the inventory layout optimization objective function, the linear programming algorithm is used for solving to determine the optimal storage location of each sub-item.
[0024] In an implementation form of the first aspect of the present application, according to the storage time loss factor of the first sub-item of the complete set at the time t, the loss factor of the first sub-item of the complete set due to the storage environment humidity at the time t, the handling frequency loss factor of the first sub-item of the complete set at the time t and the loss factor of the first sub-item of the complete set due to the storage environment humidity at the time t , the loss factor of the first sub-item of the complete set due to the storage environment humidity at the time t The environmental temperature loss factor at the time, and the material loss early warning index is obtained The loss early warning threshold is set for each kind of complete set sub-item according to historical loss data and the importance of the sub-item When The system issues a loss early warning.
[0025] As a further limitation of the first aspect of the application, the material loss early warning index , comprising:
[0026] ;
[0027] Wherein, represents the kind of complete set sub-item at the time The material loss early warning index; , , , is a weight coefficient, and ; is the storage time loss factor of the kind of complete set sub-item at the time ; is the loss factor of the storage environment humidity at the time to the kind of complete set sub-item; is the handling frequency loss factor of the kind of complete set sub-item at the time ; is the environmental temperature loss factor of the kind of complete set sub-item at the time
[0028] Secondly, the application provides a complete set of material management system.
[0029] A complete set of material management system, comprising:
[0030] The association determining unit is configured to establish a bidirectional association index of the complete set and the sub-item, and when a complete set procurement application is received, the bidirectional association index is used to associate and display the complete set to be procured and the contained sub-item;
[0031] The sub-item traceability code generating unit is configured to generate a delivery traceability code of the delivered sub-item according to the received procurement order delivery information;
[0032] The complete set taking unit is configured to determine the sub-item of the complete set according to the bidirectional association index according to the received complete set taking application, determine the complete set to be shipped out and update the complete set inventory according to the determined traceability code of the sub-item and the approved taking application;
[0033] The sub-item taking unit is configured to determine the sub-items to be taken out of the warehouse and update the sub-item inventory according to the arrival traceability code of the sub-items and the approved taking application when the sub-item taking application is received, and update the complete set inventory according to the bidirectional association index and the updated sub-item inventory;
[0034] The sub-item editing prompt unit is configured to trigger association verification when the sub-item information is edited, and issue a prompt information to remind the user to adjust the quantity of the related sub-items if the quantity ratio between the sub-items exceeds a preset ratio threshold.
[0035] In a third aspect, the present application provides a computer device, comprising: a processor and a computer readable storage medium;
[0036] The processor is adapted to execute the computer program;
[0037] The computer readable storage medium has a computer program stored therein, and the computer program is executed by the processor to implement the complete set management method according to the first aspect of the present application.
[0038] Compared with the prior art, the present application has the following beneficial effects:
[0039] 1、The present application establishes the bidirectional association index of the complete set and the sub-items and supports dynamic maintenance, solves the problem that the association relationship between the complete set and the sub-items in the prior art lacks dynamic maintenance and it is difficult to guarantee the matching of the complete set when the sub-item information is changed, realizes the association verification and proportion balance when the sub-item information is adjusted, and ensures that the sub-items of the complete set always maintain a reasonable matching relationship; by binding the purchase order and the production node, the problem that the purchase order and the production demand are not closely connected and the purchase rhythm cannot be accurately controlled is solved, so that the purchase plan and the production progress are linked to guarantee the matching of the material supply and the production node; by generating the arrival traceability code and throughout the taking and the warehousing whole process, the problem that the material whole process traceability chain is incomplete is solved, the whole process traceability of the sub-items from arrival to warehousing is realized, and the source and the flow track of the sub-items are quickly located; by real-time verification of the sub-item information of the taking application and association with the dynamic data of the inventory, the problem that the inventory information and the taking demand lack real-time verification is solved, over-application or inventory accumulation is effectively avoided, the inventory utilization efficiency and the taking accuracy are improved, and the stability of the production progress and the cost control are optimized.
[0040] 2. When establishing a bidirectional association index between complete kits and sub-items, this invention also records the proportion weight of sub-items in the complete kit. The proportion weight is used to quickly verify the matching degree between the quantity of sub-items and the overall requirements of the complete kit in subsequent procurement, delivery and requisition processes, ensuring the coordination of the proportion between the supply of sub-items and the assembly requirements of the complete kit. When editing sub-item information triggers association verification, if the quantity ratio between sub-items exceeds the preset ratio threshold, a prompt message is issued. This prompt message is used to remind the user to adjust the quantity of relevant sub-items in a timely manner to maintain the compatibility between the sub-items of the complete kit and avoid the complete kit from being unable to be assembled due to the imbalance of the quantity of a certain sub-item.
[0041] 3. When binding purchase orders to production nodes, this invention retrieves the production node time window from the production planning module and sets the delivery date to a preset number of days before the start date of the window. This preset number of days allows time for material warehousing inspection and allocation, ensuring timely supply of materials when production nodes start. When reviewing purchase orders, a production matching report is attached. The report includes the overlap time between the purchase order delivery date and the production node, as well as the compatibility verification results between the component items and the production process. This report provides reviewers with a basis for decision-making to determine whether purchase orders meet actual production needs and reduce unreasonable procurement.
[0042] 4. When verifying the sub-item information of a requisition application, this invention displays the dynamic value of the available inventory for each sub-item. The dynamic value of available inventory is the current inventory minus the quantity of applications that have been approved but not yet issued. This dynamic value is used to assist the requisitioning department in reasonably determining the application quantity, avoiding over-application or inventory backlog due to information lag. When processing the issuance procedures, if there is a difference between the actual issuance quantity and the application quantity, a difference association form is generated, marking the unissued portion as pending replenishment and linking it to the corresponding purchase order. This difference association form promotes the procurement process to prioritize replenishing the shortage sub-items, ensuring the continuity of production needs. When obtaining sub-item information, the industry specification database is called to compare the deviation between the entered value and the standard value. A standardized mapping code is generated for non-standard specification sub-items. This mapping code is used to realize the association retrieval of non-standard sub-items and standard sub-items during procurement and requisition queries, improving the accuracy and efficiency of information retrieval.
[0043] 5. When processing purchase orders, this invention automatically determines the approval level based on the order amount and the importance of the components, and pushes the corresponding related data to the approver's interface. Through hierarchical approval and precise data push, the efficiency of purchase order review is improved, while ensuring the quality of approval in important procurement processes. When generating a delivery note based on the delivery information of sub-items, if the delivery quantity of a sub-item exceeds the preset proportion of the unfulfilled requisition application quantity, an over-delivery prompt is marked on the delivery note and pushed to the inventory management module. This prompt is used to guide the inventory management department to adjust the storage strategy, prioritizing the allocation of the excess portion to the long-term storage area, thereby improving the utilization rate of storage space.
[0044] 6、The present application is aimed at the problem of significant fluctuations in the demand for sub-items of complete sets at different production stages in the equipment manufacturing industry. By calculating the production demand fluctuation coefficient and the material allocation weight, dynamic adjustment of material allocation is achieved, which can accurately identify the demand priority of each sub-item at different production stages, so that sub-items with high weight can obtain material allocation preferentially, thereby solving the problem of uneven material allocation caused by the traditional allocation method being difficult to flexibly respond to production changes. In the context of long production cycles and clear stage division, such as shipbuilding, it can ensure that in different stages such as hull construction and equipment installation, various sub-item materials such as steel plates and mechanical parts are reasonably allocated according to demand, reducing resource waste caused by excess materials in one stage and shortage of materials in another stage, ensuring the continuity of the production process, and improving the utilization efficiency of materials.
[0045] 7、In view of the problem that the storage time of complete set materials is long, the storage space utilization rate is low, and improper storage management can easily lead to damage or loss of materials, by calculating the storage location weight and constructing the inventory layout optimization objective function, the reasonable planning of inventory space is realized, considering the space utilization rate of storage location, the access frequency of sub-items and the access cost coefficient, the optimal storage location can be matched for complete set sub-items of different sizes, weights and access requirements (such as large mechanical parts, small electrical components, long pipelines, etc.). This solves the problem of space waste caused by unreasonable storage of materials in traditional storage layout, improves the utilization rate of storage space; at the same time, commonly used sub-items are arranged in positions convenient for access, reducing the access time and operation difficulty, reducing the risk of damage and loss of materials caused by frequent handling or improper storage, ensuring the safety and integrity of material storage, and indirectly reducing the manufacturing cost.
[0046] 8、The present application is aimed at the problem that the complete set materials in the equipment manufacturing industry have a high loss rate due to the lack of real-time monitoring. By collecting data such as storage time, environmental temperature and humidity, and handling frequency of sub-items of complete sets in real time, the material loss early warning index is calculated, the timely early warning of material loss risk is realized, the key factors affecting material loss can be accurately captured, such as humidity exceeding standard of electrical component storage environment, frequent handling of precision mechanical parts, etc., and the loss risk is quantified through early warning index; when the early warning index reaches the set threshold, the system timely issues an early warning, prompting the management personnel to take targeted measures (such as drying treatment for damp components, strengthening handling protection for fragile parts), thereby solving the problem of material damage and loss caused by the lack of timely discovery in traditional management, effectively reducing the material loss rate, ensuring the integrity of materials, and thus controlling the material cost in the production process such as shipbuilding, and shortening the production cycle delay caused by material loss replenishment.
[0047] The advantages of the additional aspects of the present application will be partially given in the following description, partially will become apparent from the following description, or will be known by the practice of the present application. BRIEF DESCRIPTION OF DRAWINGS
[0048] The accompanying drawings, which form a part of the specification, are included to provide a further understanding of the application and are incorporated herein in
[0049] Figure 1 A flowchart of a set of material management and control method provided for an exemplary embodiment of the present application is shown in FIG. 1.
[0050] Figure 2 A flowchart of a set of material management and control system provided for an exemplary embodiment of the present application is shown in FIG. 2.
[0051] Figure 3 A schematic diagram of a computer device provided for an exemplary embodiment of the present application is shown in FIG. 3. DETAILED DESCRIPTION
[0052] The present application will be further described below with reference to the accompanying drawings and embodiments.
[0053] It should be noted that the following detailed description is exemplary in nature and is intended to provide further description of the present application. Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs.
[0054] The present implementation proposes a set of material management and control method, as shown in FIG. 1, including the following processes: Figure 1
[0055] S101: Set maintenance.
[0056] The user logs in to the ERP system, clicks on the "supply chain management" option in the main interface, selects "set management" in the expanded submenu, then clicks on "set maintenance", and enters the set maintenance module. The system will automatically load the initial interface of the module, the top of the interface shows the filtering area, including the contract number, project number, supplier, set name, signing date, etc. The middle part is the set list display area, and the bottom is the operation button, such as "add", "edit", "delete", "sub-item maintenance", etc.
[0057] In the complete set maintenance module interface, click the "add" button, and the system pops up the complete set basic information entry window. The user needs to enter the complete set number, name, specification, model, auxiliary information, quantity, unit of measurement, auxiliary quantity, auxiliary unit of measurement, etc. Among them, the complete set number needs to be prepared according to the coding rules stipulated by the company to ensure uniqueness; the name should accurately reflect the purpose and composition of the complete set; the specification and model should be consistent with the actual material to facilitate subsequent procurement, warehousing, and delivery operations. After inputting, click the "save" button, and the system will check the entered information. If there are duplicate numbers or other errors, a prompt message will be displayed, and the user needs to modify and save again. If the verification is passed, the complete set basic information is stored in the system database, and a new record is added to the complete set list.
[0058] Select the newly added complete set record and click the "sub-item maintenance" button. The system pops up the sub-item maintenance window. The left side of the window is the sub-item list area, and the right side is the sub-item information entry area. Click the "add row" button to add a blank record to the sub-item list. The user enters the sub-item number, name, specification, model, quantity, unit, etc. in the right entry area. The sub-item number also needs to follow the coding rules and form a correlation relationship with the complete set. For each sub-item, the accuracy of the information needs to be ensured, as these information will directly affect the subsequent procurement, arrival, and delivery operations.
[0059] More specifically, when adding sub-item information, the system automatically establishes a two-way association index between the complete set and the sub-item. When entering the sub-item quantity, the system not only stores the sub-item information itself, but also synchronously records the proportion of the sub-item in the complete set (for example, if the sub-item quantity is 5 and the total number of sub-items in the complete set is 20, the proportion is 25%), and generates an association table containing the complete set number, sub-item number, and association timestamp.
[0060] When entering the sub-item specification, the system calls the pre-set industry specification database (including standard specifications of mechanical, electrical, and piping sub-items commonly used in the shipbuilding industry), and automatically compares the deviation between the entered value and the standard value. For example, when entering the specification of a certain piping sub-item as "DN100x5mm", the system finds that the standard specification should be "DN100x4.5mm", and immediately pops up a prompt, such as "The specification deviates from the industry standard by 11%. Do you want to use the standard specification or note the deviation reason?"
[0061] During the entry of sub-item information, the system will perform real-time verification. When entering the sub-item quantity, the system will check whether it is a positive integer; when entering the sub-item number, it will check whether it is duplicated with existing sub-item numbers; if errors are found, error prompt information will be displayed next to the corresponding input box. The user needs to modify the error information according to the prompt until all sub-item information verification is passed.
[0062] After all the sub-item information is entered and verified, click the "Save" button in the sub-item maintenance window; the system will store the sub-item information in association with the corresponding complete set, and update the sub-item row number and sub-item quantity of the complete set and other information; in the complete set list, the "sub-item row number" and "sub-item quantity" fields of the complete set record will display the corresponding values; click the "Close" button to return to the complete set maintenance module main interface.
[0063] More specifically, for non-standard specifications of sub-items, the system automatically generates a standardized mapping code when saving. For example, a custom motor sub-item specification is "380V 5.5kW 1450r / min", the system maps it to "M-380-5.5-1450" and associates it to the specification code of similar standard motors, facilitating subsequent fuzzy queries in the procurement and use stages (such as searching for "5.5kW motor" can match both standard and custom models).
[0064] If you need to modify the complete set or its sub-item information, select the corresponding complete set record in the complete set list and click the "Edit" button to modify the basic information of the complete set; click the "Sub-item Maintenance" button, select the sub-item record in the pop-up window, and click "Edit" to modify the sub-item information; after modification, click the "Save" button to update the information in the database.
[0065] More specifically, if the sub-item specification or quantity is modified, the system triggers the associated verification mechanism. For example, when the quantity of a sub-item is adjusted from 10 to 15, the system automatically checks whether the quantity proportion of other sub-items in the complete set meets the pre-set matching threshold (such as the requirement that the quantity deviation of each sub-item in a mechanical complete set should not exceed 10%), and if the threshold is exceeded, a prompt will be displayed, such as "Sub-item quantity proportion imbalance, do you want to adjust other associated sub-items simultaneously?"
[0066] When the complete set is no longer used or needs to be deleted due to errors, select the record in the complete set list and click the "Delete" button, the system will pop up a confirmation deletion prompt box. After the user clicks "Confirm", if the complete set has not occurred any procurement, arrival, etc. business, the system will delete it and the associated sub-item information from the database; if there are related business data, the system will prompt "The complete set has business data, cannot be deleted", the user needs to handle the related business data before deleting the operation;
[0067] The user can input the corresponding filtering conditions in the filtering area of the complete set maintenance module, such as contract number, supplier, signing date range, etc., and click the "Filter" button, the system will query the complete set records that meet the conditions from the database according to the filtering conditions and display them in the list. Select a complete set record and click the "Sub-item View" button to view all the sub-item information included in the complete set. Click "Default Filtering Scheme" to select the system's pre-set filtering scheme for quick query.
[0068] More specifically, the function of reverse lookup of the complete set by sub-item is supported. After inputting the sub-item number, the system retrieves the association table within 0.5 seconds, displays all the complete set lists to which the sub-item belongs, and marks the use status of the sub-item in each complete set (such as "purchased but not arrived" and "partly delivered"), solving the problem of "knowing the sub-item but not knowing the complete set" in traditional management.
[0069] When querying, the sorting by similarity of specifications is supported. After inputting "DN100 pipe", the system not only displays the sub-item that matches exactly, but also displays sub-items of similar specifications such as "DN90" and "DN110" in descending order of similarity, and marks the complete sets to which each sub-item belongs, helping users quickly find alternative materials.
[0070] S102: Create a purchase order.
[0071] The user clicks "purchase management" on the main interface of the ERP system, selects "purchase order" in the drop-down menu, and enters the purchase order module; the interface includes an order basic information area, a purchase detail area, and an operation button area. The order basic information area is used to fill in the number, supplier, order date, delivery date, and other information of the purchase order; the purchase detail area is used to add the material information that needs to be purchased; and the operation buttons include "add", "save", "submit", "review", etc.
[0072] Click the "add" button, and the system generates a new purchase order number and displays it in the order basic information area. The user needs to select a supplier, which can be searched and selected by inputting the supplier's name or number; set the order date as the current date; set the delivery date according to the production plan and material demand; and at the same time, fill in the special requirements or explanation information related to the purchase order in the remarks column.
[0073] More specifically, when filling in the purchase order basic information, the system adds the "production node association" option, and the user can select the corresponding shipbuilding production node (such as the hull closing stage and the main engine installation stage), and the system automatically retrieves the time window period (such as June 1, 2024 - June 30, 2024) of the node from the production plan module, and sets the delivery date as the starting date of the window period minus 7 days by default (with a buffer period).
[0074] Click the "refer to complete set" button in the purchase detail area, and the system pops up a complete set selection window. The window displays all the maintained complete set information, and the user can filter by inputting the complete set number, name, etc. After selecting the complete set that needs to be purchased, click the "OK" button, and the system adds the information of the complete set to the purchase detail area, including the complete set number, name, specification, model, quantity, unit, etc. The user can modify the purchase quantity and other information according to the actual purchase demand.
[0075] More specifically, after adding the kit procurement information, the system automatically compares the kit's demand node in the production BOM. For example, if a kit is used for cabin pipeline installation, and the production plan shows that the node will start in 3 months, the system will prompt "the current procurement cycle is 1 month, it is recommended to delay the procurement order creation time to 2 months to reduce inventory backlog."
[0076] Select the kit record in the procurement details area and click the "sub-item query" button. The system will pop up a sub-item information viewing window. The window displays the number, name, specification, model, quantity, unit, and other information of all sub-items included in the kit. The user can confirm whether the sub-items meet the procurement requirements. If the sub-item information is found to be incorrect or not meet the requirements, the user can return to the kit maintenance module to make modifications and then add it to the procurement order again.
[0077] In the procurement details area, for the added kit, the system will automatically bring out its sub-item information. The user needs to fill in the net price, tax-inclusive unit price, tax code, and other information for each sub-item. The net price is the tax-exclusive unit price, the tax-inclusive unit price = net price x (1 + tax rate corresponding to the tax code), the tax amount = net price x quantity x tax rate corresponding to the tax code, and the tax-inclusive total amount = tax-inclusive unit price x quantity. The system will automatically calculate the tax-inclusive unit price, tax amount, and tax-inclusive total amount based on the user's input of net price and tax code and display them in the corresponding fields.
[0078] After filling in all the information, click the "save" button. The system will verify the procurement order information, check whether the supplier is valid, whether the procurement quantity is positive, whether the price information is complete, etc. If there are errors, the system will prompt the user to modify and save again. If the verification is successful, the procurement order information is stored in the database, and the order status is "prepared".
[0079] Click the "submit" button, and the system will submit the procurement order to the auditor for review. After the auditor logs in to the system, they can see the procurement order in the "to be reviewed" list and click to view the details. If the review is passed, click the "review passed" button, and the order status becomes "audited". If there are problems, click the "reject" button and fill in the rejection reason. The order status returns to "prepared", and the user needs to modify and submit for review again according to the rejection reason.
[0080] More specifically, when submitting for review, the system attaches a "production matching degree report". The report includes the overlap duration of the procurement order delivery period and the production node, and the compatibility verification results of the kit sub-items and the production process (such as whether a certain electrical sub-item meets the requirements of the ship classification society). The auditor can quickly judge the rationality of the procurement order based on the report, reducing the risk of incorrect or missed procurement due to information asymmetry.
[0081] When submitting a purchase order, the system automatically determines the approval level based on the order amount and the importance of the complete set. For example, orders with an amount exceeding 50 million yuan or containing key power system complete sets are automatically routed to company-level approval; orders with an amount of 10-50 million yuan and ordinary structural parts are routed to department-level approval; orders below 10 million yuan are directly approved by the procurement supervisor.
[0082] During the approval process, the system pushes relevant data to the approver's interface in real time. When a department-level approver views an order, the system automatically displays the production node progress (e.g., "only 15 days left to the hull welding node") and existing inventory warnings (e.g., "only 3 sets of similar sub-items in stock") corresponding to the complete set; company-level approvers additionally see historical price curves (e.g., "the complete set's purchase price fluctuation range in the past 6 months is ±3%"), assisting in quick decision-making.
[0083] If the approval is rejected, the system automatically locates the modification node corresponding to the rejection reason. For example, if the approver rejects due to "high sub-item price", the system directly jumps to the price filling area and displays the reference prices of the last 3 purchases, reducing repetitive operation time.
[0084] S103: Purchase arrival processing.
[0085] The user clicks "Inventory Management" in the ERP system and selects "Purchase Arrival" to enter the purchase order arrival module. The top of the interface is the filtering area, which can filter based on inventory organization, procurement organization, order type, order number, supplier, etc.; the middle part is the purchase order arrival list, which displays order number, material drawing number, delivery date, order quantity, this time arrival quantity, etc.; the bottom is the operation button, such as "Maintain Sub-item Arrival", "Direct to Warehouse", "Generate Arrival Sheet", etc.
[0086] Enter or select the corresponding filtering conditions in the filtering area, such as order number, supplier, order date range, etc., and click the "Filter" button. The system queries the purchase order arrival records that meet the conditions and displays them in the list. The user can select the purchase order that needs to be processed according to the actual arrival situation.
[0087] Select the purchase order record to be processed, click the "Maintain Subitem to Stock" button, and the system will pop up the subitem to stock window. The window displays the complete set information corresponding to the purchase order, including order number, project number, complete set number, name, etc. Click the "Refer to Subitem Information" button, and the system will load all subitem information contained in the complete set into the subitem to stock list. Users fill in the actual to stock quantity of each subitem in the "This Time to Stock Quantity" column according to the actual to stock situation. If the subitem is to be delivered in batches, it can be processed multiple times, and the corresponding to stock quantity is filled in each time. At the same time, select the warehouse and location of the to stock, and if there is a difference between the actual to stock subitem and the purchase subitem, click "Add Row" in the "Actual to Stock Subitem" area to fill in the number, name, quantity, unit, etc. of the to stock supplier subitem, and maintain the correspondence between the two.
[0088] In the subitem to stock window, if this to stock is the last time for the complete set subitem, check the "Is the Last Time to Stock" checkbox; otherwise, do not check it. The system will make corresponding marks and reminders in subsequent to stock processing according to this setting.
[0089] After filling in, click the "Save" button, and the system will verify the to stock information, check if the to stock quantity exceeds the order quantity (considering the excess tolerance), and if the warehouse and location are valid. If there is an error, the system will prompt the user to modify and save again; if the verification is passed, the subitem to stock information is stored, and the cumulative to stock quantity and other information are updated.
[0090] More specifically, when saving the subitem to stock information, the system generates a unique "to stock trace code" for each subitem, which contains supplier code, to stock batch, quality inspection result, etc., and is bound to the purchase order number. For example, the to stock trace code "GY20240508-003-1" represents "GY" for the supplier "Guangyuan Machinery", "20240508" for the to stock date, "003" for the batch number, and "1" for the quality inspection.
[0091] After confirming the subitem to stock quantity, the system immediately compares the total quantity of the subitem to the to stock quantity. When the to stock quantity of a subitem exceeds 120% of the uncompleted to stock quantity, an inventory warning is automatically triggered, and the generated to stock list is marked with "excessive to stock, suggest to allocate to subsequent to stock plan first", and is pushed to the inventory management module at the same time, prompting to adjust the storage location (such as moving the excess part to the long-term storage area).
[0092] Click the "Generate to Stock List" button, and the system will generate a to stock list based on the subitem to stock information. The to stock list contains order number, supplier, to stock date, subitem to stock details, etc. The generated to stock list is in the state of "to be warehoused", and is recorded in the system.
[0093] For the goods that do not need further inspection, click the "direct into warehouse" button, the system will automatically handle the warehousing procedures according to the arrival order information, update the warehouse inventory quantity, and change the arrival order status to "warehoused". For the goods that need to be inspected, the inspection should be carried out first, and then the warehousing procedures are handled after the inspection is qualified.
[0094] If there is a goods return, click the "generate return order" button, and the system will pop up a return order filling window. The user fills in the number, name, quantity, return reason and other information of the return sub-item, and clicks the "save" button to generate the return order. After the return order is audited, the return and warehousing procedures are handled, the warehouse inventory quantity is reduced, and the cumulative warehousing quantity and other information are updated.
[0095] S104: Application for taking.
[0096] The production demand department personnel log in to the ERP system, click "inventory management", select "application for taking", and then click "application for taking of complete set sub-item", enter the application for taking module. The interface includes the basic information area of the application for taking and the sub-item taking detail area. The basic information area needs to fill in the movement type, business date, warehouse, distribution location and other information; the sub-item taking detail area is used to add the sub-item information that needs to be taken.
[0097] In the basic information area, select the movement type as "production taking"; set the business date as the current date; select the warehouse where the goods are taken, such as "steel plate warehouse"; fill in the distribution location as the specific location of the production workshop; input the receiver and the receiver's contact information, etc.
[0098] Click the "refer to sub-item information" button, and the system will pop up a sub-item selection window. The window displays all the available complete set sub-item information in the warehouse, and the user can filter by inputting the project number, complete set number, sub-item number, etc. After selecting the sub-item to be taken, click the "OK" button, and the system will add the sub-item information to the sub-item taking detail area. The user needs to fill in the taking quantity of each sub-item in the "application quantity" column, and set the demand date as the date when the goods need to be delivered to the production site.
[0099] More specifically, when adding the taking sub-item information, the system automatically associates the arrival tracking code. After the user selects the sub-item, the system displays the inventory distribution of all arrival batches of the sub-item, and can recommend the earliest batch of sub-item for taking according to the "first in, first out" principle, and mark the storage environment record of the batch (such as the average humidity of 55% in the past 30 days), to facilitate the taking department to judge the status of the goods.
[0100] When submitting the application, the system displays the "available inventory dynamic value" of the sub-item, which is the current inventory minus the amount of the application that has been audited but not yet shipped. For example, if the inventory of a certain sub-item is 100 pieces, and 20 pieces have been locked by other department's application, the system will show the "available inventory 80 pieces" to the current applicant, avoiding conflicts caused by over-application.
[0101] The system checks the application information in real time, checks whether the application quantity exceeds the inventory quantity of the sub-item, whether the demand date is reasonable, etc. If the application quantity exceeds the inventory quantity, the system prompts "inventory is insufficient, cannot apply"; if the demand date is earlier than the current date, it prompts "demand date is invalid". The user needs to modify the relevant information according to the prompt.
[0102] After all the information is filled in and the verification is passed, click the "save" button, the system will store the application information into the database, and the application form status is "compiled".
[0103] Click the "approval" button to submit the application form to the warehouse manager for approval. The warehouse manager checks the application form, if the inventory meets the requirements and the application is reasonable, click the "approval" button, the application form status becomes "approved"; if there are problems, reject the application form and explain the reason, the application form status returns to "compiled", the applicant modifies and resubmits.
[0104] S105: Sub-item shipment.
[0105] The warehouse manager logs in to the ERP system, clicks "inventory management", selects "shipment management", and then clicks "sub-item shipment" to enter the sub-item shipment module. The interface displays the list of application forms, including application number, project, department, warehouse, etc. At the same time, specific application forms can be found through filtering conditions.
[0106] In the application form list, select the approved application form and click the "handle" button, the system displays the sub-item application details of the application form, including sub-item number, name, specification, model, application quantity, etc.
[0107] The warehouse manager matches the sub-item according to the storage location and inventory of the sub-item. In the sub-item shipment interface, assign a corresponding storage location to each sub-item, and confirm the actual shipment quantity. If the actual shipment quantity is consistent with the application quantity, proceed to the next step; if there is a difference, the difference reason needs to be noted in the system and confirmed with the department.
[0108] After confirming that the matching is correct, click the "shipment confirmation" button, the system handles the shipment procedures, reduces the inventory quantity of the corresponding sub-item, updates the sub-item shipment quantity and cumulative shipment quantity, etc. At the same time, generate a shipment form, which contains the application form number, sub-item details, shipment quantity, shipment date, etc.
[0109] When handling the delivery procedures, the system binds the delivery information with the arrival tracking code to form a closed loop chain of "purchase order-arrival batch-receipt record". For example, when a sub-item is delivered, the system records that "the tracking code GY20240508-003-1 corresponds to the delivery quantity of 2 pieces, the receiving department is the hull workshop, and is used for the left side section of No. 3 ship", and the subsequent can be traced back to the corresponding purchase order and arrival inspection report through the record, solving the problem of "not clear where the materials are used" in traditional management.
[0110] When handling the delivery, if there is a difference between the actual delivery quantity and the application quantity (such as 5 pieces are applied but only 3 pieces can be delivered), the system automatically generates a "difference association sheet", marks the undelivered part as "to be supplemented", and associates it to the corresponding purchase order (if there is an incomplete arrival plan for the sub-item), and prompts the supplier to supplement the difference quantity in S3, forming a closed loop adjustment of "receipt-delivery-purchase".
[0111] The warehouse manager takes the sub-item materials from the warehouse location according to the delivery sheet, delivers them to the production workshop according to the delivery location, and signs and confirms the delivery sheet by the receiver. The warehouse manager archives the signed and confirmed delivery sheet as a voucher for the flow of materials.
[0112] After the delivery is completed, the system automatically updates the relevant data, including the inventory quantity of the sub-item, the delivery record, etc. At the same time, the delivery information is fed back to other related modules of the ERP system, such as the production management module, so that the production department can track the arrival of the materials.
[0113] In different stages of large equipment product construction, such as hull construction, equipment installation, electrical wiring, etc., the demand quantity and time requirements of various complete set sub-items are quite different. For example, in the hull construction stage, there is a large demand for structural sub-items such as steel plates and profiles; while in the equipment installation stage, the demand for various mechanical parts and electrical components increases, and the traditional allocation method is difficult to adjust flexibly according to these fluctuations, resulting in excess of materials in some stages and shortage of materials in some stages. Therefore, in some optional implementation manners, an optimized material allocation method based on production demand fluctuation is proposed, including the following processes:
[0114] First, the production demand fluctuation coefficient is calculated:
[0115] (1);
[0116] Wherein, represents the production demand fluctuation coefficient of the th complete set sub-item in the th production stage; is the production demand fluctuation coefficient of the th complete set sub-item in the actual demand quantity of the production stage; the average demand quantity of the first kit sub-item throughout the production cycle; the demand quantity standard deviation of the first kit sub-item throughout the production cycle.
[0117] Formula (1) reflects the demand fluctuation of the sub-item in different production stages by calculating the deviation of actual demand from average demand, combined with the demand dispersion, The larger the value, the greater the demand fluctuation of the sub-item in the production stage, which needs to be focused on its allocation.
[0118] Secondly, the material allocation weight calculation is carried out, including:
[0119] (2);
[0120] Among them, represents the allocation weight of the first kit sub-item in the first production stage; , , are weight coefficients, and , can be adjusted according to the actual production situation, for example , , , is the demand urgency score of the first kit sub-item in the first production stage, with a value range of 1-10, and the higher the score, the more urgent; is the total duration of the first production stage; is the initial inventory quantity of the first kit sub-item in the first production stage; is the maximum inventory capacity of the first kit sub-item.
[0121] Formula (2) considers the production demand fluctuation coefficient, demand urgency and inventory situation, and calculates the allocation weight of each sub-item in each production stage, The larger the value, the higher the allocation priority of the sub-item in the production stage.
[0122] Specifically, the following implementation steps are provided:
[0123] Collect the actual demand quantity of the first kit sub-item in each production stage through the ERP system Average demand throughout the entire production cycle Standard deviation of demand quantity In the Production phase demand urgency rating Total duration of production stage j Inventory quantity at the beginning of production stage j and maximum inventory capacity ;
[0124] According to the Actual demand quantity of each component in the kit at each production stage Average demand throughout the entire production cycle Standard deviation of demand quantity Combining with formula (1), the first... Production demand fluctuation coefficient of the kit item in the j-th production stage ;
[0125] Based on the importance of production and actual conditions, set , , The value can be appropriately increased, for example, in scenarios where demand fluctuations have a significant impact on production. The value;
[0126] Will , , , and Substituting into formula (2), we get the first... Seed kit sub-items in the first Allocation weights in the production stage ,according to The weight of each item determines its allocation order in each production stage, with items having higher weights receiving priority allocation of materials. In the material allocation module of the ERP system, the calculated allocation weights are input, and the system automatically generates a material allocation plan to guide the issuance and use of materials.
[0127] The construction of large equipment requires a wide variety of sub-items, varying significantly in size and weight, such as large mechanical components, small electrical components, and long pipes. These sub-items require different storage spaces, and an inefficient storage layout can lead to wasted space and increased difficulty in accessing materials. For example, storing large components in a confined space wastes surrounding space; storing frequently used items in remote locations increases access time. To improve storage utilization and reduce material damage and loss, an inventory layout optimization method based on storage utilization is proposed as an alternative implementation. Specifically, this method includes the following process:
[0128] Perform storage location weight calculation:
[0129] (3);
[0130] in, Indicates the first Seed kit sub-items in the first The storage location weight of each storage location. , and These are the weighting coefficients, and ; For the first The space utilization rate of a storage location is the ratio of the actual volume of the stored materials in that location to the total volume of that location. For the first The access frequency of a type of package item, that is, the number of times the item is taken out of the warehouse per unit time; For the first Seed kit sub-items in the first The access cost coefficient for each storage location is related to factors such as the distance from the storage location to the entrance / exit, the weight and size of the sub-item.
[0131] Define the objective function for inventory layout optimization, specifically including:
[0132] (4);
[0133] The constraints are as follows:
[0134] (5);
[0135] (6);
[0136] (7);
[0137] (8);
[0138] in, The number of types of sub-items in a kit; The number of storage locations; Let be the decision variable, and if the sub-item of the k-th type of kit is stored in the k-th type of kit... One storage location, then ,otherwise, ; For the first The volume of the sub-items in the package; For the first The objective function aims to maximize the total storage location weight, i.e. by reasonably arranging the storage locations of the sub-items, the storage combination (sub-item-location) with high weight is selected, so as to improve the storage utilization and access efficiency, and the constraint condition ensures that the volume of each storage location is not exceeded, and each sub-item is only stored in one location.
[0139] Specifically, the following implementation steps are provided:
[0140] The volume of each storage location is collected , the current space utilization , the volume of each sub-item of the complete set , the access frequency , and the access cost coefficient of each sub-item in different storage locations The access cost coefficient may be comprehensively evaluated according to factors such as the distance from the storage location to the entrance, the weight and size of the sub-item, etc.
[0141] According to the storage management target, the values of , and are set, for example, if more attention is paid to space utilization, the value of may be increased; if more attention is paid to access efficiency, the value of may be increased.
[0142] Substitute , , and , and into formula (3) to calculate ;
[0143] Substitute , , into formula (4) to (8), and use a linear programming algorithm to solve the model in the inventory layout optimization module of the ERP system to obtain the value of the decision variable , i.e. to determine the optimal storage location of each sub-item.
[0144] According to the solving result, the storage location of each sub-item of the complete set is adjusted in the warehouse. The storage location information of the sub-item is updated in the inventory management module of the ERP system, and the system generates an inventory layout diagram to guide the warehouse management personnel to carry and place the materials. At the same time, the adjusted storage utilization is recorded for subsequent evaluation of the optimization effect.
[0145] In the storage and use of the sub-item of the complete set, the loss may be caused by environmental factors (such as humidity, temperature), improper handling, long storage time, etc. For example, electrical components are prone to damage in humid environments; precision mechanical parts may be damaged in the handling process. Real-time monitoring of these factors can reduce unnecessary losses. Optionally, in other implementations, a real-time monitoring-based material loss warning method is also proposed, including the following processes:
[0146] The material loss warning index is calculated, including:
[0147] (9);
[0148] Among them, represents the material loss warning index of the th sub-item of the complete set at time; , , , are weight coefficients, and ; is the storage time loss factor of the th sub-item of the complete set at time, which is proportional to the storage time; is the storage environment humidity loss factor of the th sub-item of the complete set at time, the higher the humidity, the larger the factor; is the handling frequency loss factor of the th sub-item of the complete set at time, the more the handling frequency, the larger the factor; is the environmental temperature loss factor of the th sub-item of the complete set at time, and the temperature is too high or too low, which will increase the factor.
[0149] Install temperature and humidity sensors, cameras, RFID tags and other monitoring equipment in warehouses and production sites to collect real-time data such as storage time, environmental temperature and humidity, and handling frequency of the sub-item of the complete set. These data are transmitted to the real-time monitoring module of the ERP system through the network;
[0150] According to the characteristics of the sub-item of the complete set, the values of , , , are determined, for example, may be determined according to the ratio of storage time to shelf life; , may be determined according to the degree of deviation of temperature and humidity from the appropriate range; The number of times of handling and the impact strength of each handling can be determined;
[0151] According to the influence degree of different loss factors on the loss of materials, the values of , , , are set, for example, for the sub-items susceptible to humidity, the value of is increased; for the sub-items susceptible to damage due to handling, the value of is increased;
[0152] According to historical loss data and the importance of the sub-items, a loss warning threshold is set for each complete set of sub-items in the ERP system When , the system issues a loss warning.
[0153] When the system issues a loss warning, the warning information is displayed in the warning module of the ERP system, including the sub-item number, name, warning index, warning reason, etc. After receiving the warning information, the warehouse management personnel and production department personnel timely check and handle the corresponding sub-items. For example, dry treatment is performed on the damp electrical components; repair or replacement is performed on the collided mechanical parts; after the treatment is completed, the treatment result is recorded in the system, the state information of the sub-item is updated, and the loss warning index is recalculated until the warning is lifted.
[0154] The optimization of material allocation for production demand fluctuations ensures the reasonable allocation of materials in different production stages; the optimization of inventory layout improves the utilization efficiency of storage space; the real-time monitoring of material loss warning reduces the material loss rate. These three innovations work together to form an organic whole, which improves the level of complete set material management, reduces manufacturing costs, and shortens the manufacturing cycle.
[0155] Figure 2 A complete set of material management system is shown, comprising:
[0156] The association determining unit 201 is configured to: establish a bidirectional association index of complete sets and sub-items, and when a complete set procurement application is received, display the complete set to be procured and the contained sub-items according to the bidirectional association index;
[0157] The sub-item traceability code generating unit 202 is configured to: generate a delivery traceability code of the delivered sub-item according to the received procurement order delivery information;
[0158] The complete set taking unit 203 is configured to: according to the received complete set taking application, determine the sub-items of the complete set according to the bidirectional association index, and determine the complete set to be shipped out and update the complete set inventory according to the traceability codes of the determined sub-items and the approved taking application.
[0159] The sub-item taking unit 204 is configured to determine the sub-items to be shipped out and update the sub-item inventory according to the sub-item arrival traceability code and the approved taking application when receiving the sub-item taking application, and update the complete set inventory according to the bidirectional association index and the updated sub-item inventory;
[0160] The sub-item editing prompt unit 205 is configured to trigger association verification when the sub-item information is edited, and issue a prompt information to remind the user to adjust the quantity of the relevant sub-item if the quantity ratio between the sub-items exceeds the preset ratio threshold.
[0161] It can be understood that the above-mentioned units can be combined into one or several other units to constitute, or some of the units can be further split into a plurality of units with smaller functions to constitute, which can achieve the same operation without affecting the implementation of the technical effects of the embodiments of the present application. The above-mentioned units are divided based on logical functions, and in actual application, the functions of one unit can also be realized by multiple units, or the functions of multiple units can be realized by one unit. In other embodiments of the present application, the system can also include other units, and in actual application, these functions can also be realized by other units, and can be realized by multiple units in cooperation.
[0162] According to another embodiment of the present application, the system described in the embodiment can be constructed by running a computer program (including program code) capable of performing each step involved in the corresponding method of the present application on a general computing device such as a computer including processing elements and storage elements such as a Central Processing Unit (CPU), a Random Access Memory (RAM), a Read Only Memory (ROM), etc., the computer program can be recorded on a computer readable recording medium, and loaded into the above-mentioned computing device through the computer readable recording medium and run therein.
[0163] Figure 3 A computer device is shown, which includes a processor 301, a communication interface 302, and a computer readable storage medium 303. Wherein the processor 301, the communication interface 302 and the computer readable storage medium 303 can be connected through a bus or other means.
[0164] Wherein, the communication interface 302 is used for receiving and sending data, the computer readable storage medium 303 can be stored in the memory of the electronic device, the computer readable storage medium 303 is used for storing computer programs, the computer programs include program instructions, and the processor 301 is used for executing the program instructions stored in the computer readable storage medium 303.
[0165] The processor 301 is a computing core and control core of the electronic device, which is suitable for implementing one or more instructions, and is particularly suitable for loading and executing one or more instructions to implement a corresponding method flow or a corresponding function.
[0166] The processor 301 is configured to perform the following processes:
[0167] The bidirectional association index of the complete set and the sub-item is established, when the complete set procurement application is received, the complete set to be procured and the contained sub-item are associated and displayed according to the bidirectional association index;
[0168] According to the received procurement order arrival information, the arrival trace code of the arrived sub-item is generated;
[0169] According to the received complete set application for taking, the sub-item of the complete set is determined according to the bidirectional association index, the determined trace code of the sub-item and the approved application for taking are used to determine the complete set to be shipped and update the complete set inventory;
[0170] When the sub-item application for taking is received, the sub-item to be shipped is determined according to the arrival trace code of the sub-item and the approved application for taking, and the sub-item inventory is updated, and the complete set inventory is updated according to the bidirectional association index and the updated sub-item inventory;
[0171] When the sub-item information is edited, the association verification is triggered, if the quantity ratio between the sub-items exceeds the preset ratio threshold, a prompt information is sent to remind the user to adjust the quantity of the related sub-items.
[0172] The above only describes the preferred embodiments of the present application and is not used to limit the present application. For those skilled in the art, the present application can have various modifications and changes. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims
1. A complete set of material management and control methods, characterized in that, The method comprises the following processes: establishing a bidirectional association index of the complete sets and the sub-items, when a complete set procurement application is received, according to the bidirectional association index, the complete set to be procured and the contained sub-items are associated and displayed; generating a delivery trace code of the delivered sub-items according to the received procurement order delivery information; according to the received complete set application, determining the sub-items of the complete set according to the bidirectional association index, determining the complete set to be delivered according to the determined trace code of the sub-items and the approved application, and updating the inventory of the complete set; when a sub-item application is received, determining the sub-item to be delivered according to the delivery trace code of the sub-item and the approved application, and updating the inventory of the sub-item, and updating the inventory of the complete set according to the bidirectional association index and the updated inventory of the sub-item; when the sub-item information is edited, triggering an association check, if the quantity ratio between the sub-items exceeds a preset ratio threshold, a prompt information is sent to remind the user to adjust the quantity of the related sub-items; Collected through the ERP system Actual demand quantity of each component in the kit at each production stage Average demand throughout the entire production cycle Standard deviation of demand quantity In the Production phase demand urgency rating , No. Total duration of the production phase In the Initial inventory levels at the start of the production phase and maximum inventory capacity ; According to the first actual number of the sub-item of the complete set required in each production stage average number of the sub-item of the complete set required in the whole production cycle standard deviation of the number of the sub-item of the complete set required , the production demand fluctuation coefficient of the first sub-item of the complete set in the first production stage is calculated ; ; wherein, represents the production demand fluctuation coefficient of the sub-item of the complete set in the production stage; represents the actual demand quantity of the sub-item of the complete set in the production stage; represents the average demand quantity of the sub-item of the complete set in the entire production cycle; represents the demand quantity standard deviation of the sub-item of the complete set in the entire production cycle; Based on the production demand fluctuation coefficient Urgency of Need Score , No. Total duration of the production phase In the Initial inventory levels at the start of the production phase and maximum inventory capacity , obtained the Seed kit sub-items in the first Allocation weights in the production stage According to the allocated weight The size of each item determines the order of allocation in each production stage, with items having higher weights receiving priority in material allocation. material allocation weight calculation, including: ; wherein, represents the first set of items of the first production phase; , , is a weight coefficient, and .
2. The complete set material management method of claim 1, wherein, when the bidirectional association index of the complete set and the sub-items is established, the proportion weight of the sub-items in the complete set is recorded for checking the matching degree of the quantity of the sub-items and the overall demand of the complete set.
3. The complete set material management method of claim 1, wherein, when the procurement order is bound to the production node, the production node time window in the production plan module is called, the delivery date is set to be a preset number of days before the start date of the window, and the material storage inspection and allocation time is reserved by the preset number of days; when the sub-item information of the application is checked, the available inventory dynamic value of the sub-item is displayed, which is the current inventory minus the application quantity that has been audited but not delivered.
4. The complete set material management method of claim 1, wherein, when the delivery procedure is handled, if there is a difference between the actual delivery quantity and the application quantity, a difference association sheet is generated, the undelivered part is marked as to be replenished, and is associated to the corresponding procurement order; when the sub-item information is obtained, the deviation of the input value and the standard value is compared by calling the industry specification database, the standardization mapping code of the non-standard sub-item is generated, and the association search of the non-standard sub-item and the standard sub-item is realized when purchasing and applying for inquiry.
5. The complete set material management method of claim 1-4, wherein, the volume of each storage location, the current space utilization rate, the volume of each complete set sub-item, the access frequency and the access cost coefficient of each sub-item in different storage locations are collected; according to the current space utilization rate, the volume of each complete set sub-item and the access cost coefficient of each sub-item in different storage locations, the storage location weight is calculated; according to the storage location weight, the volume of each complete set sub-item, the volume of each storage location and the inventory layout optimization objective function, the linear programming algorithm is used to solve, and the best storage location of each sub-item is determined.
6. The complete set material management method of claim 1-4, wherein, According to the Sub-items of the kit Storage time loss factor at any moment Real-time storage of ambient humidity for the first Loss factor of a type of kit item, the first Sub-items of the kit The number of transport times and loss factor at time and the first Sub-items of the kit The environmental temperature loss factor at any given time is used to obtain the material loss early warning index. Based on historical loss data and the importance of each sub-item, set a loss warning threshold for each kit sub-item. ,when The system issued a damage warning.
7. The complete set material management method of claim 6, wherein, Material loss early warning index comprises: ; Wherein, represents the first kind of complete set of parts sub-item at the moment of material loss early warning index; , , , is a weight coefficient, and ; is the storage time loss factor of the first kind of complete set of parts sub-item at the moment; is the loss factor of the first kind of complete set of parts sub-item at the moment of storage environment humidity; is the carrying frequency loss factor of the first kind of complete set of parts sub-item at the moment; is the environmental temperature loss factor of the first kind of complete set of parts sub-item at the moment.
8. A kit management system, comprising: including: The association relationship determining unit is configured to establish a bidirectional association index of the complete set and the sub-item, and when a complete set procurement application is received, display the complete set to be procured and the contained sub-item according to the bidirectional association index; The sub-item traceability code generating unit is configured to generate a delivery traceability code of the delivered sub-item according to the received procurement order delivery information; The complete set taking unit is configured to determine the sub-item of the complete set according to the bidirectional association index according to the received complete set taking application, determine the complete set to be delivered according to the determined traceability code of the sub-item and the approved taking application, and update the complete set inventory; The sub-item taking unit is configured to determine the sub-item to be delivered according to the delivery traceability code of the sub-item and the approved taking application when a sub-item taking application is received, update the sub-item inventory, and update the complete set inventory according to the bidirectional association index and the updated sub-item inventory; The sub-item editing prompt unit is configured to trigger an association check when the sub-item information is edited, and if the quantity ratio between the sub-items exceeds a preset ratio threshold, prompt information is sent to remind the user to adjust the quantity of the related sub-item; Collected through the ERP system Actual demand quantity of each component in the kit at each production stage Average demand throughout the entire production cycle Standard deviation of demand quantity In the Production phase demand urgency rating , No. Total duration of the production phase In the Initial inventory levels at the start of the production phase and maximum inventory capacity ; According to the Actual demand quantity of each component in the kit at each production stage Average demand throughout the entire production cycle Standard deviation of demand quantity Calculate the first Seed kit sub-items in the first Production demand fluctuation coefficient during the production stage ; ; wherein, represents the th kit sub-item in the production phase; is the actual demand quantity of the th kit sub-item in the production phase; is the average demand quantity of the th kit sub-item in the entire production cycle; is the standard deviation of the demand quantity of the th kit sub-item in the entire production cycle; Based on the production demand fluctuation coefficient Urgency of Need Score , No. Total duration of the production phase In the Initial inventory levels at the start of the production phase and maximum inventory capacity , obtained the Seed kit sub-items in the first Allocation weights in the production stage According to the allocated weight The size of each item determines the order of allocation in each production stage, with items having higher weights receiving priority in material allocation. The material allocation weight calculation includes: ; wherein, represents the first set of items of the first production phase; , , is a weight coefficient, and .
9. A computer device, comprising: The processor and the computer readable storage medium; The processor is adapted to execute the computer program; The computer readable storage medium has a computer program stored therein, and the computer program is executed by the processor to realize the complete set material management method according to any one of claims 1 to 7.
Citation Information
Patent Citations
Product stock distribution method and device
CN101894322A
Ship construction suite management method and system, storage medium and equipment
CN115271597A