Processing method for inventory allocation and order consolidation of chip multilayer ceramic capacitors
By synchronizing the data of ERP and WMS systems, a reasonable work order is generated, which solves the problem of unreasonable production planning and inventory allocation of chip multi-layer ceramic capacitors, and realizes full utilization of inventory and rapid delivery of orders, avoiding resource waste and Stock backlog.
Patent Information
- Application Number
- CN202111158768.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-09-30
- Publication Date
- 2024-11-08
- Estimated Expiration
- 2041-09-30
AI Technical Summary
In the prior art, the production planning and inventory allocation of chip multi-layer ceramic capacitors rely on manual experience, resulting in unreasonable production planning, insufficient inventory utilization, and difficulty in completing orders in a short time, which is prone to problems of inventory backlog and resource waste.
By synchronizing sales order and inventory data in ERP and WMS systems, order and inventory information are extracted, and the semi-finished part number, finished part number, capacity value, tolerance, electrical performance parameters and electroplating end requirements are compared to generate secondary work Orders, compile and bring work orders, screen work orders, deducted goods details and one-time work orders to achieve reasonable allocation of sales orders and inventory products and combined production.
It realizes full utilization of inventory, avoids inventory backlog and resource waste, ensures that customer orders are completed in a short time, avoids property losses caused by default, and is conducive to the production and manufacturing of MLCC.
Smart Images

Figure CN113869867B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of chip-type multilayer ceramic capacitor processing, and in particular to a processing method for chip-type multilayer ceramic capacitor inventory allocation and order consolidation. Background Art
[0002] Electronic components are an indispensable part of the circuit and are the key to the normal operation of the circuit. They are highly used and in great demand. Therefore, their rational production has become the focus of industry attention.
[0003] As an electronic component, MLCC (chip multilayer ceramic capacitor) belongs to the mixed manufacturing industry. Its manufacturing is mainly based on production according to orders, while taking into account the replenishment of inventory. However, due to its large variety and long production process, the company's inventory and production plan basically rely on manual experience to allocate, which is not only time-consuming and labor-intensive, but also prone to errors, resulting in unreasonable production plans and inventory allocation, which makes it difficult to complete orders in a short period of time, unable to fully utilize production capacity, and difficult to ensure timely delivery of customer orders. At the same time, it is also prone to inventory backlogs, resulting in waste of resources, which is not conducive to the production and manufacturing of the above-mentioned electronic components. Summary of the invention
[0004] In view of the above-mentioned problems existing in the prior art, the present invention aims to provide a processing method for inventory allocation and order consolidation of chip multilayer ceramic capacitors, synchronize the sales orders and inventory data in the existing ERP (enterprise information management system) and WMS (warehouse management system) systems, extract the order product information of the corresponding products in the sales order and the inventory product information in the inventory data, and compare the semi-finished product part number, finished product part number, capacitance, tolerance, electrical performance parameters and electroplating terminal requirements, etc., generate secondary work orders, taping work orders, screening work orders, out-of-stock details orders and primary work orders, reasonably realize the allocation of sales orders and inventory products and the consolidation production of out-of-stock details orders of each sales order, which can not only make full use of the inventory, but also complete the order and deliver it to the customer in a short time, avoiding the waste of resources caused by inventory backlog, and facilitating the production of MLCC.
[0005] The specific technical solutions are as follows:
[0006] The processing method of chip multilayer ceramic capacitor inventory allocation and order consolidation includes the following steps:
[0007] Step S1, access existing data;
[0008] Synchronize the sales order information in the company's existing ERP system, extract the order product information of the corresponding product in the sales order, and at the same time, extract the inventory product information of the corresponding product in the inventory data in the WMS system. In addition, both the order product information and the inventory product information include the semi-finished product part number, finished product part number, tolerance, capacitance value and electroplating terminal requirements;
[0009] Step S2, generating a secondary work order;
[0010] Match the order product information extracted from the sales order with the inventory product information, and directly produce the products that fully match the two according to the processing flow card. At this time, generate a secondary work order;
[0011] Step S3, generating a taping work order;
[0012] Match the extracted order product information with the inventory product information. If the finished product part numbers match, the tolerances are consistent, or the tolerance accuracy is high, then the subsequent processing is directly carried out according to the processing flow card. At this time, a taping work order is generated;
[0013] Step S4, generating a screening work order;
[0014] Match the extracted order product information with the inventory product information. If the finished product part numbers do not match or the tolerances do not match, but there is overlap in the electrical performance parameters of the two, perform electrical performance screening to select products that meet the shipping requirements and perform subsequent processing according to the processing flow card. At this time, generate a screening work order;
[0015] Step S5, generating a detailed list of goods out of stock;
[0016] The quantity of products in the sales order is divided by the quantity of products in the secondary work order, the taping work order, and the screening work order generated in steps S2, S3, and S4, respectively, to obtain the quantity of missing products, and a detailed list of out-of-stock products is generated;
[0017] Step S6, generating a work order;
[0018] According to the out-of-stock details list generated in step S5, the products in the out-of-stock details lists in different sales orders are compared, the semi-finished product part numbers of the products in each out-of-stock details list are compared, and the out-of-stock details lists with the same semi-finished product part numbers are selected for combined production. At this time, a work order is generated.
[0019] In the above-mentioned processing method for chip multilayer ceramic capacitor inventory allocation and order consolidation, the electrical performance screening in step S4 is performed using Keysight Technologies equipment.
[0020] In the above-mentioned chip multilayer ceramic capacitor inventory allocation and order consolidation processing method, there are crossovers in the electrical performance parameters, and there are overlapping parts in the tolerance parameters.
[0021] In the above-mentioned chip multilayer ceramic capacitor inventory allocation and order consolidation processing method, in step S6, if the corresponding finished product part numbers are also consistent, a direct production work order is generated, and subsequent production is carried out directly according to the processing flow card.
[0022] The above-mentioned chip multilayer ceramic capacitor inventory allocation and order consolidation processing method, wherein, in step S6, if the corresponding finished product part numbers are inconsistent, the capacitance values are consistent, the tolerances are inconsistent, but the electroplating end requirements are consistent, it is necessary to perform electrical performance screening, and select the products that meet the respective shipping requirements respectively, and assign them to different screening work orders, and carry out subsequent production according to the requirements of each screening work order, and obtain a number of test splitting work orders.
[0023] The above-mentioned chip-type multilayer ceramic capacitor inventory allocation and order consolidation processing method, wherein, in step S6, if the corresponding finished product part numbers are inconsistent and the electroplating end requirements are also inconsistent, it is necessary to split the work orders in the electroplating station, and each split work order is subjected to electroplating processing and subsequent production according to the processing flow card to generate a number of electroplating split work orders.
[0024] The positive effects of the above technical solution are:
[0025] The above-mentioned processing method for inventory allocation and order consolidation of chip-type multilayer ceramic capacitors matches the sales order information and inventory data information in the existing ERP system and WMS system, extracts the order product information and inventory product information of the corresponding products in the sales order and inventory data information, and compares the parameters such as semi-finished product part number, finished product part number, capacitance, tolerance, electrical performance parameters and electroplating terminal requirements in the order product information and the inventory product information to obtain the secondary work order, the taping work order, the screening work order and the primary work order, and reasonably realizes the allocation of sales orders and inventory products and the consolidation production of the out-of-stock details of each sales order, thereby realizing the full utilization of inventory products, avoiding inventory backlogs, and preventing waste of resources. At the same time, it can ensure that customer orders are completed in a short time, avoid property losses caused by breach of contract, and be beneficial to the production and manufacturing of MLCC. BRIEF DESCRIPTION OF THE DRAWINGS
[0026] Figure 1 A flowchart of an embodiment of a method for processing chip multilayer ceramic capacitor inventory allocation and order consolidation of the present invention;
[0027] Figure 2 The present invention is a flowchart of an order consolidation method that is preferably implemented. DETAILED DESCRIPTION
[0028] In order to make the technical means, creative features, objectives and effects of the present invention easier to understand, the following embodiments are combined with the attached Figure 1 To Attachment Figure 2 The technical solution provided by the present invention is described in detail, but the following content is not intended to limit the present invention.
[0029] Figure 1 The flowchart of the embodiment of the processing method of chip multilayer ceramic capacitor inventory allocation and order consolidation of the present invention. Figure 1 As shown, the processing method for chip multilayer ceramic capacitor inventory allocation and order consolidation provided in this embodiment includes the following steps:
[0030] Step S1, access existing data;
[0031] Synchronize the sales order information in the company's existing ERP system, extract the order product information of the corresponding products in the sales order, and at the same time, extract the inventory product information of the corresponding products in the inventory data in the WMS system. In addition, both the order product information and the inventory product information include the semi-finished product part number, finished product part number, tolerance, capacitance value and electroplating terminal requirements.
[0032] Step S2, generating a secondary work order;
[0033] Match the order product information extracted from the sales order with the inventory product information, and directly carry out subsequent production of products that fully match the two according to the processing flow card. At this time, generate a secondary work order to realize the direct use of inventory products, which can not only reduce inventory products, avoid inventory accumulation and waste of resources, but also ensure that customer orders are completed in a short time.
[0034] Step S3, generating a taping work order;
[0035] The extracted order product information is matched with the inventory product information. If the finished product part numbers match, the tolerances are consistent, or the tolerance accuracy is high, the subsequent processing is directly carried out according to the processing flow card. At this time, a taping work order is generated, which realizes the further utilization of the inventory products and also utilizes the products that meet the shipment requirements. It can also reduce inventory and shorten the time to complete customer orders.
[0036] Step S4, generating a screening work order;
[0037] The extracted order product information is matched with the inventory product information. If the finished product part numbers do not match or the tolerances do not match, but there is overlap in the electrical performance parameters of the two, electrical performance screening is performed to select products that meet the shipment requirements and perform subsequent processing according to the processing flow card. At this time, a screening work order is generated, which also realizes the further utilization of inventory products and provides conditions for fully utilizing inventory and shortening order delivery time.
[0038] Step S5, generating a detailed list of goods out of stock;
[0039] The number of products in the sales order is divided by the number of products in the secondary work order, the taping work order, and the screening work order generated in steps S2, S3, and S4, respectively, to obtain the number of missing products, and a detailed list of out-of-stock products is generated. That is, a detailed list of out-of-stock products is generated only when the sales order still has missing quantities after the inventory products have been utilized. This not only realizes the full utilization of the existing inventory products, but also reduces the number of products in the sales order that need to be completely reprocessed, thereby providing conditions for ensuring that customer orders are completed in a short time.
[0040] Step S6, generating a work order;
[0041] According to the out-of-stock details list generated in step S5, the products in the out-of-stock details list in different sales orders are compared, the semi-finished product part numbers of the products in each out-of-stock details list are compared, and the out-of-stock details lists with the same semi-finished product part numbers are selected for combined production. At this time, a work order is generated once, that is, after each sales order has fully utilized the inventory products and at least two sales orders still have missing product quantities, the semi-finished product part numbers of the at least two orders will be compared. If they are consistent, they will be produced together, thereby further shortening the order completion time and ensuring that customer orders can be completed in a short time.
[0042] It is worth pointing out that the above-mentioned secondary work order refers to the processing order of the semi-finished product that has been processed through some processes and then continues to be processed through the subsequent processes, while the primary work order refers to the processing order that is completely processed from the initial process to the final process. The taping work order refers to the processing order from the taping process to the final process in the secondary work order. The screening work order refers to the processing order that has the screening process added to the secondary work order and is processed from the screening process to the final process.
[0043] More specifically, the equipment used for electrical performance screening in step S4 is Keysight Technologies equipment, which can be purchased directly on the market and is easy to implement.
[0044] More specifically, the overlap in electrical performance parameters means that the capacitance and tolerance parameters of the products overlap.
[0045] Figure 2 The flowchart of order consolidation which is preferably implemented in the present invention is shown in FIG. Figure 1 and Figure 2 As shown, when at least two different sales orders with out-of-stock details are combined for production, the semi-finished product part numbers of the corresponding products of at least two out-of-stock details produced by the combined order are consistent, but the finished product part numbers of the corresponding products may be consistent or inconsistent. Therefore, it is necessary to determine whether the finished product part numbers of the corresponding products are consistent to ensure that the products corresponding to each sales order meet the order requirements. The specific comparison is as follows:
[0046] If the finished product part numbers of the corresponding products are also the same, a direct production work order is generated, and subsequent processing is directly performed according to the processing flow card, that is, the entire processing process of the out-of-stock details of different sales orders can be combined for production without distinguishing the processing;
[0047] In addition to the above-mentioned situations where the orders can be directly combined for production, if the finished product part numbers of the corresponding products are inconsistent, the capacitance values are consistent, the tolerances are inconsistent, but the electroplating terminal requirements are consistent, it is necessary to screen the electrical performance, and select the products that meet the respective delivery requirements, and assign them to different screening work orders. Subsequent production is carried out according to the requirements of each screening work order, and several test splitting work orders are obtained. That is, after the electrical performance screening, the products that meet the respective delivery requirements are screened. The work order splitting is realized here, and the screened products with different electrical properties are subsequently processed separately. Therefore, after the electrical performance screening, subsequent production needs to be carried out according to their respective screening work orders. It is worth pointing out that the screening work order described here may be the same as or different from the screening work order in the above step S4, depending on the specific requirements of the products corresponding to the respective corresponding sales orders.
[0048] In addition to the above-mentioned situations where orders can be directly combined for production and production screening work orders after electrical performance screening, if the corresponding finished product part numbers are inconsistent and the electroplating end requirements are also inconsistent, the work orders need to be split in the electroplating station. At this time, each split work order is electroplated and subsequently produced according to the processing flow card to generate several electroplating split work orders, which ensures the uniqueness of the products corresponding to each sales order and meets the shipping requirements of the products corresponding to each sales order.
[0049] The processing method for inventory allocation and order consolidation of chip-type multilayer ceramic capacitors provided in this embodiment, through step S1, access to existing data; step S2, generate a secondary work order; step S3, generate a taping work order; step S4, generate a screening work order; step S5, generate a backlog detail list and step S6, generate a primary work order, match the sales order and inventory data, thereby forming a secondary work order, a taping work order, a screening work order, a backlog detail list and a primary work order corresponding to the backlog detail list, realize the reasonable allocation of sales orders and inventory products and the combined production of the backlog detail lists of each sales order, thereby realizing the full utilization of inventory products, not only avoiding the problem of preventing resource waste caused by inventory backlogs, but also ensuring that customer orders are completed in a short time, avoiding property losses caused by breach of contract, and facilitating the production of MLCC.
[0050] The above are only preferred embodiments of the present invention, and are not intended to limit the implementation methods and protection scope of the present invention. Those skilled in the art should be aware that all solutions obtained by equivalent substitutions and obvious changes made using the description and illustrations of the present invention should be included in the protection scope of the present invention.
Claims
1. The processing method of chip multilayer ceramic capacitor inventory allocation and order consolidation includes the following steps: Step S1, access existing data; Synchronize the sales order information in the company's existing ERP system, extract the order product information of the corresponding product in the sales order, and at the same time, extract the inventory product information of the corresponding product in the inventory data in the WMS system, and both the order product information and the inventory product information include the semi-finished product part number, finished product part number, tolerance, capacitance value and electroplating terminal requirements; Step S2, generating a secondary work order; The order product information extracted from the sales order is matched with the inventory product information, and the products that completely match the order product information are directly produced according to the processing flow card, and at this time, a secondary work order is generated; Step S3, generating a taping work order; The extracted order product information is matched with the inventory product information. If the finished product part numbers match, the tolerances are consistent or the tolerance precision is high, subsequent processing is directly performed according to the processing flow card. At this time, a taping work order is generated; Step S4, generating a screening work order; The extracted order product information is matched with the inventory product information. If the finished product part numbers are inconsistent and the tolerances are inconsistent, but there is overlap in the electrical performance parameters of the two, electrical performance screening is performed to screen out products that meet the shipping requirements, and subsequent processing is performed according to the processing flow card. At this time, a screening work order is generated; the overlap in the electrical performance parameters is the overlap of the capacitance value and the tolerance parameter; Step S5, generating a detailed list of goods out of stock; The quantity of products in the sales order is divided by the quantity of products in the secondary work order, the braiding work order and the screening work order generated in steps S2, S3 and S4, respectively, to obtain the quantity of missing products, and generate a detailed list of out-of-stock products; Step S6, generating a work order; According to the out-of-stock details list generated in step S5, the products of the out-of-stock details list in different sales orders are compared, and the semi-finished product part numbers of the products in each out-of-stock details list are compared, and the out-of-stock details list with the same semi-finished product part number is selected for combined production. At this time, a work order is generated; if the corresponding finished product part numbers are also consistent, a direct production work order is generated, and subsequent production is carried out directly according to the processing flow card; if the corresponding finished product part numbers are inconsistent, the capacitance values are consistent, the tolerances are inconsistent, but the electroplating terminal requirements are consistent, it is necessary to screen the electrical properties, select the products that meet the respective shipping requirements, and assign them to different screening work orders, and carry out subsequent production according to the requirements of each screening work order, and obtain a number of test split work orders; if the corresponding finished product part numbers are inconsistent, and the electroplating terminal requirements are also inconsistent, it is necessary to split the work orders in the electroplating station, and the split work orders are electroplated and subsequently produced according to the processing flow card to generate a number of electroplating split work orders.
