Method and device for generating spare part purchase list
By using the spare parts codes in the historical procurement list to generate a planned procurement list, the problems of wasted time and inefficiency caused by duplicate data input during the generation of spare parts procurement lists are solved, and more efficient procurement list generation is achieved.
Patent Information
- Application Number
- CN202411486184.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-23
- Publication Date
- 2025-02-28
AI Technical Summary
In the prior art, there are problems of wasted time resources and low production efficiency in the generation process of spare parts procurement lists, mainly due to the need to repeatedly input data.
Avoid duplicate data input by taking all spare parts codes that appear in multiple historical procurement lists as spare parts codes for the planned procurement list, and obtaining corresponding information based on these codes, calculating the quantity and total price of spare parts, avoiding duplicate data input.
It greatly improves the efficiency of generating spare parts procurement lists, reduces waste of time and resources, and improves production efficiency.
Smart Images
Figure CN119539695A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and in particular to a method and device for generating a spare parts purchase list. Background Art
[0002] The process of generating a conventional spare parts purchase list is as follows: Figure 1 As shown in the figure, most of the time is spent on inputting data, not processing the required system data. In the absence of special accidents, the overall change of spare parts procurement is actually not large. If the spare parts procurement list is regenerated every time, a lot of time resources will be wasted on repeated data input work, reducing production efficiency. Summary of the invention
[0003] The present invention provides a method and device for generating a spare parts purchase list, so as to solve the problems of time resource waste and low production efficiency existing in the prior art.
[0004] In a first aspect, the present invention provides a method for generating a spare parts purchase list, comprising:
[0005] All spare part codes appearing in multiple historical purchase lists are used as spare part codes of a planned purchase list, wherein the purchase list includes first information of each spare part, the first information includes spare part code, spare part quantity, spare part total price, and second information, the second information includes spare part name, specification model, spare part unit price, and spare part type, and the spare part is uniquely identified by the spare part code;
[0006] Acquire corresponding second information based on the spare part code, where the spare part code corresponds to the second information one by one;
[0007] The spare parts quantity of the jth spare part in the planned purchase list is calculated according to the following formula:
[0008]
[0009] in, is the number of spare parts of the hth type in the planned purchase list, w is the calculation weight, is the number of spare parts of the jth type of spare parts in a reference purchase list, wherein the reference purchase list belongs to the multiple historical purchase lists, is the average quantity of the jth spare part in the multiple historical purchase lists, is the standard deviation of the number of spare parts of the jth spare part in the multiple historical purchase lists, is the inventory of the jth spare part, is the number of spare parts under repair of the jth type, To round up to an integer;
[0010] The total price of the spare parts is obtained by multiplying the unit price of the spare parts by the quantity of the spare parts.
[0011] The above solution avoids the time loss caused by repetitive data input, greatly improves the efficiency of generating spare parts purchase lists, and further improves production efficiency.
[0012] Optionally, all spare parts in the purchase list are sorted according to the spare parts codes.
[0013] Optionally, the purchase list also includes a list overview, which includes the number of spare parts types, the total number of spare parts and the total amount of spare parts included in each spare part type.
[0014] In a second aspect, the present invention provides a device for generating a spare parts purchase list, comprising a setting module, a generating module and an adjusting module, wherein:
[0015] The setting module is used to set the basic information of the planned purchase list, including the list name, list year, calculation weight, reference year and submitter, the reference year is the year to which the reference purchase list belongs and is used to obtain the reference purchase list;
[0016] The generating module is used to generate the planned purchase list according to the calculated weight and the reference year, including:
[0017] All spare part codes appearing in multiple historical purchase lists are used as spare part codes of a planned purchase list, wherein the purchase list includes first information of each spare part, the first information includes spare part code, spare part quantity, spare part total price, and second information, the second information includes spare part name, specification model, spare part unit price, and spare part type, and the spare part is uniquely identified by the spare part code;
[0018] Acquire corresponding second information based on the spare part code, where the spare part code corresponds to the second information one by one;
[0019] The spare parts quantity of the jth spare part in the planned purchase list is calculated according to the following formula:
[0020]
[0021] in, is the number of spare parts of the hth type in the planned purchase list, w is the calculation weight, is the number of spare parts of the hth type of spare parts in a reference purchase list, wherein the reference purchase list belongs to the multiple historical purchase lists, is the average quantity of the hth type of spare parts in the multiple historical purchase lists, is the standard deviation of the number of spare parts of the hth type of spare part in the multiple historical purchase lists, is the inventory of the hth type of spare parts, is the number of spare parts under repair of the hth type, To round up to an integer;
[0022] Calculate the product of the spare parts unit price and the spare parts quantity to obtain the spare parts total price;
[0023] The adjustment module is used to add, delete and modify the planned purchase list.
[0024] Optionally, all spare parts in the purchase list are sorted according to the spare parts codes.
[0025] Optionally, the purchase list also includes a list overview, which includes the number of spare parts types, the total number of spare parts and the total amount of spare parts included in each spare part type.
[0026] Optionally, modifying the planned purchase list includes adding spare parts, deleting spare parts, modifying spare parts unit prices, and modifying spare parts quantities.
[0027] Optionally, it also includes a query module, which is used to query the purchase list according to the order number.
[0028] In a third aspect, the present invention provides a computing device, characterized in that it includes:
[0029] A memory for storing program instructions;
[0030] The processor is used to call the program instructions stored in the memory and execute any of the above methods according to the obtained program.
[0031] In a fourth aspect, the present invention provides a computer-readable non-volatile storage medium, characterized in that it includes computer-readable instructions, and when a computer reads and executes the computer-readable instructions, the computer executes any of the above methods. BRIEF DESCRIPTION OF THE DRAWINGS
[0032] Figure 1 A schematic diagram of a conventional spare parts purchase list generation process provided as the background technology of the present invention;
[0033] Figure 2 A schematic diagram of part of the information of a purchase list provided by an embodiment of the present invention;
[0034] Figure 3 A schematic diagram of information of a list overview provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0035] In order to make the purpose, technical scheme and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0036] An embodiment of the present invention provides a method for generating a spare parts purchase list, comprising:
[0037] S101, taking all spare part codes appearing in a plurality of historical purchase lists as spare part codes of a planned purchase list.
[0038] Specifically, the purchase list includes first information of each spare part, the first information includes spare part code, spare part quantity, total spare part price and second information, the second information includes spare part name, specification model, spare part unit price and spare part type, and the spare part is uniquely identified by the spare part code.
[0039] It should be noted that the historical purchase list is the purchase list of previous years that has been generated, and the planned purchase list is the purchase list of the current year to be generated. In actual production work, the purchase list is one year. In a possible implementation, the multiple historical purchase lists can be the historical purchase lists of the previous 5 years.
[0040] The spare part code is fixed and each spare part corresponds to a unique spare part code.
[0041] Figure 2 It shows part of the purchase list information, including spare part code, spare part name, specification model, spare part unit price (i.e. Figure 2 Unit price in), spare parts quantity (i.e. Figure 2 The quantity in) and the total price of spare parts (i.e. Figure 2 the total amount in ).
[0042] S102, acquiring corresponding second information based on the spare part code, where the spare part code corresponds to the second information one-to-one.
[0043] S103, calculating the spare parts quantity of the jth spare part in the planned purchase list according to the following formula:
[0044]
[0045] in, is the number of spare parts of the jth type in the planned purchase list, w is the calculation weight, is the number of spare parts of the jth type in the reference purchase list, where the reference purchase list belongs to multiple historical purchase lists, is the average number of spare parts of the jth spare part in multiple historical purchase lists, is the standard deviation of the number of spare parts of the jth type in multiple historical purchase lists, is the inventory of the jth spare part, is the number of spare parts under repair of the jth type, Round up to an integer.
[0046] When the calculated weight is equal to 0, the above formula is simplified to:
[0047]
[0048] The representative spare parts quantity is determined by multiple historical purchase lists, inventory quantities and repair numbers.
[0049] When the calculation weight is equal to 1, the above formula is simplified to:
[0050]
[0051] The spare parts quantity representing the j-th spare part is determined only by the spare parts quantity of the j-th spare part in the reference purchase list.
[0052] When the calculation weight is greater than 0 and less than 1, it means that the number of spare parts is determined by the reference purchase list, multiple historical purchase lists, inventory and the number of repairs. The calculation weight is usually set to 0.7.
[0053] S104, calculating the product of the spare parts unit price and the spare parts quantity to obtain the spare parts total price.
[0054] The above solution avoids the time loss caused by repetitive data input, greatly improves the efficiency of generating spare parts purchase lists, and further improves production efficiency.
[0055] In a possible implementation, all spare parts in the purchase list are sorted by spare part code.
[0056] In a possible implementation, the purchase list further includes a list overview, which includes the number of spare parts types, the total number of spare parts, and the total amount of spare parts included in each spare part type.
[0057] Different spare parts may belong to the same spare parts type. The total number of spare parts is the sum of the spare parts quantities of different spare parts under the same spare parts type, and the total amount of spare parts is the sum of the total spare parts prices of different spare parts under the same spare parts type.
[0058] Figure 3 Shows an overview of the inventory, including the type of spare parts (i.e. Figure 3 Types in), number of spare parts (i.e. Figure 3 Items in), total number of spare parts (i.e. Figure 3 of the parts) and the total amount of spare parts (i.e. Figure 3 the total amount in ).
[0059] Based on the same inventive concept, an embodiment of the present invention provides a device for generating a spare parts purchase list, including a setting module, a generating module and an adjusting module.
[0060] The setting module is used to set the basic information of the planned purchase list, including the list name, list year, calculation weight, reference year and submitter. The reference year is the year to which the reference purchase list belongs and is used to obtain the reference purchase list.
[0061] It should be noted that when the calculation weight is set to 0, the reference year can be omitted.
[0062] The generation module is used to generate a planned purchase list based on the calculation weights and reference years, including:
[0063] All spare part codes appearing in multiple historical purchase lists are used as spare part codes of the planned purchase list. The purchase list includes first information of each spare part, which includes spare part code, spare part quantity, and spare part total price, and second information, which includes spare part name, specification model, spare part unit price, and spare part type. The spare part is uniquely identified by the spare part code;
[0064] Acquire corresponding second information based on the spare part code, where the spare part code corresponds to the second information one by one;
[0065] Calculate the spare parts quantity of the jth spare part in the planned purchase list according to the following formula:
[0066]
[0067] in, is the number of spare parts of the jth type in the planned purchase list, w is the calculation weight, is the number of spare parts of the jth type in the reference purchase list, where the reference purchase list belongs to multiple historical purchase lists, is the average number of spare parts of the jth spare part in multiple historical purchase lists, is the standard deviation of the number of spare parts of the jth type in multiple historical purchase lists, is the inventory of the jth spare part, is the number of spare parts under repair of the jth type, To round up to an integer;
[0068] Calculate the product of the spare parts unit price and the spare parts quantity to get the total spare parts price.
[0069] In a possible implementation, all spare parts in the purchase list are sorted by spare part code.
[0070] In a possible implementation, the purchase list further includes a list overview, which includes the number of spare parts types, the total number of spare parts, and the total amount of spare parts included in each spare part type.
[0071] The adjustment module is used to add, delete and modify the planned purchase list.
[0072] In a possible implementation, modifying the planned purchase list includes adding spare parts, deleting spare parts, modifying spare parts unit prices, and modifying spare parts quantities.
[0073] Since modifying the unit price of a spare part will affect all subsequent purchase lists containing the spare part, it is generally not recommended to modify it.
[0074] In a possible implementation, an apparatus for generating a spare parts purchase list provided by an embodiment of the present invention further includes a query module, and the query module is used to query the purchase list according to the order number.
[0075] In a possible implementation, the order number is automatically generated when the purchase list is generated.
[0076] Based on the same inventive concept, an embodiment of the present invention provides a computing device, including:
[0077] A memory for storing program instructions;
[0078] The processor is used to call the program instructions stored in the memory and execute the above method according to the obtained program.
[0079] Based on the same inventive concept, an embodiment of the present invention provides a computer-readable non-volatile storage medium, characterized in that it includes computer-readable instructions, and when a computer reads and executes the computer-readable instructions, the computer executes the above method.
[0080] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.
[0081] The present application is described with reference to the flowcharts and / or block diagrams of the methods, apparatus (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of the processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0082] These computer program instructions may also be stored in a computer readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture including an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.
[0083] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.
[0084] Although the preferred embodiments of the present application have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications falling within the scope of the present application.
[0085] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.
Claims
1. A method for generating a spare parts purchase list, characterized in that: include: All spare part codes appearing in multiple historical purchase lists are used as spare part codes of a planned purchase list, wherein the purchase list includes first information of each spare part, the first information includes spare part code, spare part quantity, spare part total price, and second information, the second information includes spare part name, specification model, spare part unit price, and spare part type, and the spare part is uniquely identified by the spare part code; Acquire corresponding second information based on the spare part code, where the spare part code corresponds to the second information one by one; The spare parts quantity of the hth spare parts in the planned purchase list is calculated according to the following formula: in, is the number of spare parts of the hth type in the planned purchase list, w is the calculation weight, is the number of spare parts of the hth type of spare parts in a reference purchase list, wherein the reference purchase list belongs to the multiple historical purchase lists, is the average quantity of the hth type of spare parts in the multiple historical purchase lists, is the standard deviation of the number of spare parts of the hth type of spare part in the multiple historical purchase lists, is the inventory of the hth type of spare parts, is the number of spare parts under repair of the hth type, To round up to an integer; The total price of the spare parts is obtained by multiplying the unit price of the spare parts by the quantity of the spare parts.
2. The method according to claim 1, characterized in that: All spare parts in the purchase list are sorted according to the spare part codes.
3. The method according to claim 1, characterized in that: The purchase list also includes a list overview, which includes the number of spare parts types, the total number of spare parts and the total amount of spare parts contained in each spare part type.
4. A device for generating a spare parts purchase list, characterized in that: It includes setting module, generation module and adjustment module, among which: The setting module is used to set the basic information of the planned purchase list, including the list name, list year, calculation weight, reference year and submitter, the reference year is the year to which the reference purchase list belongs and is used to obtain the reference purchase list; The generating module is used to generate the planned purchase list according to the calculated weight and the reference year, including: All spare part codes appearing in multiple historical purchase lists are used as spare part codes of a planned purchase list, wherein the purchase list includes first information of each spare part, the first information includes spare part code, spare part quantity, spare part total price, and second information, the second information includes spare part name, specification model, spare part unit price, and spare part type, and the spare part is uniquely identified by the spare part code; Acquire corresponding second information based on the spare part code, where the spare part code corresponds to the second information one by one; The spare parts quantity of the hth spare parts in the planned purchase list is calculated according to the following formula: in, is the number of spare parts of the hth type in the planned purchase list, w is the calculation weight, is the number of spare parts of the jth type of spare parts in a reference purchase list, wherein the reference purchase list belongs to the multiple historical purchase lists, is the average quantity of the jth spare part in the multiple historical purchase lists, is the standard deviation of the number of spare parts of the jth spare part in the multiple historical purchase lists, is the inventory of the jth spare part, is the number of spare parts under repair of the jth type, To round up to an integer; Calculate the product of the spare parts unit price and the spare parts quantity to obtain the spare parts total price; The adjustment module is used to add, delete and modify the planned purchase list.
5. The device according to claim 4, characterized in that: All spare parts in the purchase list are sorted according to the spare part codes.
6. The device according to claim 4, characterized in that: The purchase list also includes a list overview, which includes the number of spare parts types, the total number of spare parts and the total amount of spare parts contained in each spare part type.
7. The device according to claim 4, characterized in that: The modification of the planned purchase list includes adding spare parts, deleting spare parts, modifying spare parts unit prices and modifying spare parts quantities.
8. The device according to claim 4, characterized in that: It also includes a query module, which is used to query the purchase list according to the order number.
9. A computing device, characterized in that include: A memory for storing program instructions; A processor is used to call the program instructions stored in the memory and execute the method as claimed in any one of claims 1 to 3 according to the obtained program.
10. A computer-readable non-volatile storage medium, characterized in that: The method comprises computer-readable instructions, and when a computer reads and executes the computer-readable instructions, the computer executes the method according to any one of claims 1 to 3.