Method and system for calculating neat sets according to material attributes
By initializing, sorting and matching material information in work order scheduling, the problem of difficulty in generating reasonable set of solutions in the existing technology is solved, and the method of calculating material attributes is realized to maximize the meeting of production needs of the factory.
Patent Information
- Application Number
- CN202411902686.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-23
- Publication Date
- 2025-04-04
AI Technical Summary
It is difficult for the existing technology to generate relatively reasonable sets of solutions based on material purchase orders, brand and other information, when the work orders are scheduled to be calculated, it cannot meet the specific production needs of the factory.
Through the steps of order initialization, sorting, inventory query and data matching, the complete set is calculated based on the material properties. Specifically, it includes setting the priority of the production plan, sorting orders, querying inventory, matching data, and optimizing the complete set of solutions by checking missing items and optimal items.
The quantity of purchase orders on the work orders is reasonably allocated according to the material properties, and the quantity of work orders is maximized, and the production value is maximized.
Smart Images
Figure CN119761977A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of digital factories, and more particularly to a method and system for calculating complete sets according to material attributes. Background Art
[0002] Before actual production begins, the factory workshop needs to arrange a production plan, and then check whether the materials in the existing warehouse can meet the production plan.
[0003] At present, most of the methods for calculating material completeness are general ones. However, each factory has different business needs, which leads to the need to meet the factory's production plan based on the actual business scenario.
[0004] How to generate a relatively reasonable set of solutions when calculating the set of work order scheduling based on the purchase order, brand and other information of the material has become a research direction for technical personnel in this field. Summary of the invention
[0005] The purpose of the present invention is to provide a method for calculating the complete set according to material properties, in order to solve the technical problems existing in the background technology.
[0006] In order to achieve the above object, the present invention adopts the following technical solutions:
[0007] A method for calculating the complete set according to material attributes, comprising:
[0008] Order initialization;
[0009] Sort the initialized orders;
[0010] Check inventory;
[0011] Matching data.
[0012] In some embodiments, the order initialization includes:
[0013] Set the priority of the production plan according to business needs, where 1 has the highest priority, 2 is in the middle, and 3 is the next;
[0014] Classify by whether the purchase order and brand are specified.
[0015] In some embodiments, the classification according to whether a purchase order or brand is specified includes:
[0016] a. Those without specified purchase order and brand are classified as D.
[0017] b. Those that only specify the brand are classified as C.
[0018] c. Only the purchase order is specified, which is classified as B.
[0019] d. Those specified by both the purchase order and the brand are classified as A.
[0020] In some embodiments, the ordering of the initialized orders includes: directly adding the quantities corresponding to the same purchase order, the same material, and the same brand in the same combination to reduce the number of operations to be performed.
[0021] In some embodiments, querying the inventory includes:
[0022] Query the current inventory quantity based on purchase order, material code, and brand;
[0023] The inventory is grouped by warehouse and location code to count the total quantity of current materials;
[0024] Determine the number of query results. If the number is less than two, end the query directly. If the number is greater than two, continue to search for data with similar storage / production time, take the last digit, and re-sort them in the order of 1, 2, 3.
[0025] In some embodiments, the matching data includes:
[0026] First, query the inventory of complete machines according to the purchase order and brand, and split them one by one to meet the small quantity;
[0027] Match the relevant data according to the BOM head. If there are remaining materials after the whole machine is dismantled, match the remaining data according to the parts.
[0028] Query the bulk parts inventory according to the purchase order, material code, and brand, and match the corresponding bulk materials.
[0029] In some embodiments, the method further includes checking for missing items, wherein the checking for missing items includes the following steps:
[0030] 1) Record the current calculation results;
[0031] 2) Check the data that is not matched at present, and find whether there is data in D that meets B and C. If so, replace it; find whether there is a brand in B that can meet the data in C. If so, replace it; record the result of this replacement;
[0032] 3) Follow the result of step 1 again and check whether there is data in D that satisfies B and C. If so, replace it. Check whether there is a purchase order in C that satisfies the data in B. If so, replace it. Record the result of this replacement.
[0033] In some embodiments, the process further includes checking the optimal item, wherein the checking the optimal item includes the following steps:
[0034] The results obtained above are used to count the number of results that meet the second and third priorities, and the result with the largest number of matches is taken as the optimal solution.
[0035] This embodiment also provides a system for calculating a complete set according to material attributes, which is used to implement any of the methods described, including:
[0036] The order initialization module is used to initialize and arrange work orders according to business importance and classify their priorities;
[0037] The order sorting module is used to sort the initialized orders according to the priority rules;
[0038] The query module is used to query inventory information and match BOMs according to purchase orders and brands;
[0039] The matching module is used to match order data according to the query database.
[0040] Compared with the prior art, the present invention has the following beneficial effects:
[0041] This patented method rationally allocates the quantity of purchase orders on work orders by rearranging inventory based on material code, purchase order, brand, and WBS. It can maximize the complete set quantity of work orders and maximize production value. BRIEF DESCRIPTION OF THE DRAWINGS
[0042] Figure 1 , Material BOM structure diagram;
[0043] Figure 2 ,Warehouse inventory reordering flow chart;
[0044] Figure 3 , a complete set of calculation operation flow chart;
[0045] Figure 4 , the operation result replaces the schematic diagram. DETAILED DESCRIPTION
[0046] In order to make the purpose, technical solutions and advantages of the present application clearer, the technical solutions in the embodiments of the present application will be described in more detail below in conjunction with the drawings in the preferred embodiments of the present application. In the drawings, the same or similar reference numerals throughout represent the same or similar parts or parts with the same or similar functions. The described embodiments are part of the embodiments of the present application, not all of the embodiments. The embodiments described below with reference to the drawings are exemplary and are intended to be used to explain the present application, and should not be construed as limitations on the present application. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present application.
[0047] The embodiments of the present application are described in detail below with reference to the accompanying drawings.
[0048] In the description of this application, it should be noted that, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, or it can be an indirect connection through an intermediate medium, it can be the internal connection of two elements or the interaction relationship between two elements. For ordinary technicians in this field, the specific meanings of the above terms in this application can be understood according to specific circumstances.
[0049] In the description of the present application, it should be understood that the terms "upper", "lower", "front", "back", "vertical", "horizontal", "top", "bottom", "inside", "outside", etc., indicating orientations or positional relationships, are orientations or positional relationships based on the drawings, and are only for the convenience of describing the present application and simplifying the description, and do not indicate or imply that the referred device or element must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be understood as a limitation on the present application.
[0050] In addition, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, for example, a process, method, system, product, or display that includes a series of steps or elements is not necessarily limited to those steps or elements explicitly listed but may include other steps or elements not explicitly listed or inherent to such process, method, product, or display.
[0051] The following will be combined Figure 1 , a method for calculating the complete set according to the material properties involved in the embodiment of the present application is described in detail. It is worth noting that the following embodiments are only used to explain the present application and do not constitute a limitation on the present application.
[0052] Embodiment 1:
[0053] like Figure 1 and 3 As shown in the figure, a method for calculating the complete set based on material attributes is used. When calculating the complete set of a work order, this method uses an exhaustive method to generate multiple solutions due to different operation dimensions. Then, the optimal solution is found among these generated solutions. This achieves the maximum utilization value of resources. Specifically, it includes:
[0054] First, prioritize the work orders according to the importance of the business, and then group similar data according to the principle of data approximation. Data with specified purchase orders and brands are grouped into Group A, data with only specified purchase orders are grouped into Group B, data with only specified brands are grouped into Group C, and data with neither purchase orders nor brands are grouped into Group D. The grouping priorities are as follows: A>B, B=C, C>D. Query the inventory in turn to match the materials in the work order. After matching the BOM head (motherboard, chassis, network card) code of the whole machine, some loose parts materials may be generated. At this time, you can match whether there are other work orders required. After the matching of the whole machine type materials is completed, continue to match the loose parts type materials. During the matching process, try to match data with less usage, and need to satisfy as many work orders as possible. Record the quantity matched in each group as Sa, Sb, Sc, and Sd respectively.
[0055] After the whole machine order is met, continue to search for the inventory of spare parts that meet the requirements. Compared with the whole machine, the requirements for spare parts are not so strict and have a higher degree of freedom.
[0056] Warehouse locations are arranged in order from near to far and from low to high. According to the principle of first-in-first-out, when searching for inventory, it is necessary to determine whether the entry time of two adjacent data is similar. If so, the data with the smaller last digit of the location code needs to be prioritized.
[0057] After the above sequence is completed, it is necessary to count whether there is any unmatched data and record the statistical results. Then, based on this result, find whether there is data that meets the purchase order or specified brand from the data without specified purchase orders and brands, and then record the matching results respectively. Finally, find the optimal solution among these three statistical results.
[0058] This embodiment also provides a system for calculating a complete set according to material attributes, which is used to implement any of the methods described, including:
[0059] The order initialization module is used to initialize and arrange work orders according to business importance and classify their priorities;
[0060] The order sorting module is used to sort the initialized orders according to the priority rules;
[0061] The query module is used to query inventory information and match BOMs according to purchase orders and brands;
[0062] The matching module is used to match order data according to the query database.
[0063] The following is a specific example:
[0064] A method to calculate the complete set based on material properties. The steps are as follows:
[0065] 1. Initialization
[0066] 1. First, set the priority of the production plan according to business needs. 1 is the highest priority, 2 is in the middle, and 3 is the next.
[0067] 2. Classification by whether the purchase order is specified and brand
[0068] a. Those without specified purchase order and brand are classified as D.
[0069] b. Those that only specify the brand are classified as C.
[0070] c. Only the purchase order is specified, which is classified as B.
[0071] d. Those specified by both the purchase order and the brand are classified as A.
[0072] 2. Merger
[0073] According to the classification in the first step, the following combinations are formed: 1A, 1B, 1C, 1D, 2A, 2B, 2C, 2D, 3A, 3B, 3C, 3D. The data in the same combination may contain duplicate material data. It is necessary to perform a merge operation on the whole, that is, the quantities corresponding to the same purchase order, the same material, and the same brand are directly added together to reduce the number of operations to be performed.
[0074] 3. Check Inventory
[0075] Query the current inventory quantity based on purchase order, material code, and brand.
[0076] The inventory is grouped by warehouse and location code to count the total quantity of the current materials.
[0077] like Figure 2 .
[0078] Determine the number of query results. If the number is less than two, end the query directly. If the number is greater than two, continue to search for data with similar storage / production time. Among these similar storage locations, take the last digit and re-sort them in the order of 1, 2, 3.
[0079] 4. Matching Data
[0080] 1. First, query the inventory of the whole machine according to the purchase order, brand, etc., and split it up in turn to meet the small quantity.
[0081] 2. According to the BOM head of L6 (motherboard, chassis, network card), such as Figure 1 , match the relevant data, and then match the L10 related data. After the matching is completed, there are remaining materials removed from the whole machine, and the remaining data is matched according to the loose parts.
[0082] 3. Continue to process the next purchase order according to steps 1 and 2 until all the machine data has been processed.
[0083] 4. Query the spare parts inventory according to the purchase order, material code and brand, and match the corresponding spare parts materials.
[0084] 5. Continue to process the next bulk material according to step 4 until all the bulk material data has been processed.
[0085] 5. Check for missing items
[0086] like Figure 4 .
[0087] 1. Record the current calculation results.
[0088] 2. Check the data that is not matched at present, and find whether there is data in D that meets B and C. If so, replace it. Find whether there is a brand in B that can meet the data in C. If so, replace it. Record the result of this replacement.
[0089] 3. Based on the results of step 1, check if there is data in D that satisfies B and C. If so, replace it. Check if there is a purchase order in C that satisfies the data in B. If so, replace it. Record the results of this replacement.
[0090] For example, the purchase order number is HK240816001002, and the quantity required for the A202-LP-01 storage location is 100. However, among these 100, 20 are of Samsung brand and 30 are of Western Digital brand. These 50 can be taken out and matched again with materials with the specified brands of Samsung and Western Digital. The original purchase order has 50 missing materials, and it is necessary to continue to search from the separated brands, or to find out whether there is matching data in the inventory.
[0091] 6. Check the best option
[0092] The above three results are counted to meet the number of the second and third priorities, and the result with the largest number of matches is taken as the optimal solution. The production orders with the largest number of matches can meet the production needs of the production workshop.
[0093] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the protection scope of the present invention.
Claims
1. A method for calculating the complete set according to material attributes, characterized in that: include: Order initialization; Sort the initialized orders; Check inventory; Matching data.
2. A method for calculating the complete set according to material attributes according to claim 1, characterized in that: The order initialization includes: Set the priority of the production plan according to business needs, where 1 has the highest priority, 2 is in the middle, and 3 is the next; Classify by whether the purchase order and brand are specified.
3. A method for calculating the complete set according to material attributes according to claim 2, characterized in that: The classification according to whether the purchase order and brand are specified includes: a. Those without specified purchase order and brand are classified as D. b. Those that only specify the brand are classified as C. c. Only the purchase order is specified, which is classified as B. d. Those specified by both the purchase order and the brand are classified as A; The grouping priorities are as follows: A>B, B=C, C>D.
4. A method for calculating a complete set according to material attributes according to claim 1, characterized in that: The ordering of the initialized orders includes: directly adding the quantities corresponding to the same purchase order, the same material, and the same brand in the same combination to reduce the number to be calculated.
5. A method for calculating the complete set according to material attributes according to claim 1, characterized in that: The inventory query includes: Query the current inventory quantity based on purchase order, material code, and brand; The inventory is grouped by warehouse and location code to count the total quantity of current materials; Determine the number of query results. If the number is less than two, end the query directly. If the number is greater than two, continue to search for data with similar storage / production time, take the last digit, and re-sort them in the order of 1, 2, 3.
6. A method for calculating the complete set according to material attributes according to claim 1, characterized in that: The matching data includes: First, query the inventory of complete machines according to the purchase order and brand, and split them one by one to meet the small quantity; Match the relevant data according to the BOM head. If there are remaining materials after the whole machine is dismantled, match the remaining data according to the parts. Query the bulk parts inventory according to the purchase order, material code, and brand, and match the corresponding bulk materials.
7. A method for calculating the complete set according to material attributes according to claim 3, characterized in that: The method further includes checking for missing items, wherein the checking for missing items includes the following steps: 1) Record the current calculation results; 2) Check the data that is not matched at present, and find whether there is data in D that meets B and C. If so, replace it; find whether there is a brand in B that can meet the data in C. If so, replace it; record the result of this replacement; 3) Follow the result of step 1 again and check whether there is data in D that satisfies B and C. If so, replace it. Check whether there is a purchase order in C that satisfies the data in B. If so, replace it. Record the result of this replacement.
8. A method for calculating the complete set according to material attributes according to claim 3, characterized in that: The method further includes checking the optimal item, wherein the checking the optimal item includes the following steps: The results obtained above are used to count the number of results that meet the second and third priorities, and the result with the largest number of matches is taken as the optimal solution.
9. A system for calculating complete sets based on material properties, characterized in that: The method for implementing any one of claims 1 to 8 comprises: The order initialization module is used to initialize and arrange work orders according to business importance and classify their priorities; The order sorting module is used to sort the initialized orders according to the priority rules; The query module is used to query inventory information and match BOMs according to purchase orders and brands; The matching module is used to match order data according to the query database.