Dynamic inventory checking method and device, electronic equipment and storage medium

Abstract

The invention relates to a dynamic inventory checking method and device, electronic equipment and a storage medium. The dynamic inventory checking method comprises the following steps: obtaining an in-out frequency Fi of a target cargo i and calculating a frequency weight fi; the total value Vi of the target goods i is obtained, and the total value weight vi is calculated; obtaining the remaining shelf life Si of the target goods i and calculating the shelf life weight si; calculating a checking period Ti of the target goods i according to the frequency weight fi, the total value weight vi and the shelf life weight si; and the target goods i periodically perform the inventory task according to the inventory period Ti of the target goods i. According to different characteristics of each kind of goods, the inventory cycle and the priority of the goods are calculated, and different inventory strategies are generated for each kind of goods, so that each kind of goods can have a corresponding inventory cycle according to own characteristics. Compared with a traditional fixed inventory cycle mode, the method can enable the inventory of the goods to be more accurate, improves the inventory efficiency, and does not cause the waste of resources.

Description

Technical Field

[0001] The present invention relates to the technical field of inventory management, and in particular to a dynamic inventory counting method, device, electronic equipment and storage medium. Background Art

[0002] In the warehouse management system, inventory is an important part of inventory management. It can understand the real inventory of goods and correct inventory deviations in time. The existing inventory of goods often adopts a fixed inventory cycle, such as regular full inventory, blind inventory and other methods. In particular, regular full inventory means that all goods are counted in a fixed period. Because each product has different characteristics, such as the frequency of entering and leaving the warehouse, the value of the goods, the shelf life of the goods, etc. At this time, if the same inventory cycle is used, for some goods, the inventory is too frequent, resulting in a waste of resources and an unnecessary increase in the workload of warehouse managers. For other goods, the inventory cycle is too long, and it is impossible to understand the real inventory and status of the goods in time, and it is impossible to warn of insufficient inventory in time, which will affect production efficiency. Summary of the invention

[0003] Based on this, it is necessary to provide a dynamic inventory counting method, device, electronic equipment and storage medium that can dynamically adjust the inventory counting cycle and priority according to the frequency, value, shelf life and other characteristics of the goods, in order to improve the level of intelligence in warehouse management.

[0004] A dynamic inventory counting method comprises the following steps:

[0005] Get the in-and-out frequency F of target goods i i And calculate the frequency weight f i , and its calculation formula is:

[0006]

[0007] In the formula, F max and F min They are the in / out frequency of the goods with the highest in / out frequency and the in / out frequency of the goods with the lowest in / out frequency;

[0008] Get the total value V of target goods i i And calculate the total value weight v i , and its calculation formula is:

[0009]

[0010] Where V max and V minThey are the total value of the goods with the largest total value and the total value of the goods with the smallest total value;

[0011] Get the remaining shelf life S of the target product i i And calculate the warranty period weight s i , and its calculation formula is:

[0012]

[0013] In the formula, S max and S min They are the remaining shelf life of the goods with the longest remaining shelf life and the remaining shelf life of the goods with the shortest remaining shelf life;

[0014] According to the frequency weight f i , total value weight v i and warranty option weights i Calculate the inventory cycle T of target goods i i , and its calculation formula is:

[0015]

[0016] In the formula, t represents the period scaling factor, α, β, γ represent the weight coefficients, and α+β+γ=1;

[0017] According to the inventory cycle T i , periodically perform inventory tasks on the target goods i.

[0018] As a preferred example, the in / out frequency F i , total value weight v i and remaining shelf life S i Exported from the intelligent warehouse management system or enterprise management system.

[0019] As a preferred example, the dynamic inventory counting method further comprises the following steps: calculating the priority P of each type of goods i ; If the inventory time of different goods is the same, the priority P i Goods with high priority are counted first; the priority calculation formula is:

[0020]

[0021] In the formula, δ i Indicates the business impact coefficient.

[0022] As a preferred example, if the target product has no shelf life, the shelf life will be re-s i Set to a custom constant.

[0023] As a preferred example, the dynamic inventory counting method further includes the following steps: setting a statistical cycle; collecting the in-and-out frequency F of the target goods i after each statistical cycle arrives; i 、Total value V i and remaining shelf life S i ; Recalculate the inventory cycle of goods based on the newly collected data.

[0024] As a preferred example, the dynamic inventory counting method further includes the following steps: recording the inventory quantity of goods after each inventory counting cycle, and comparing the inventory quantity of goods with the actual inventory quantity; if the two are inconsistent, recording the inventory difference and notifying the warehouse manager.

[0025] As a preferred example, the dynamic inventory counting method further includes the following steps: dynamically adjusting the cycle scaling factor, weight factor and business impact factor according to the inventory counting effect, inventory counting efficiency, inventory counting accuracy and inventory data.

[0026] A dynamic inventory counting device adopts the above-mentioned dynamic inventory counting method; the dynamic inventory counting device comprises:

[0027] The weight module is used to obtain the frequency of goods entering and leaving, the total value and the remaining shelf life, and calculate the corresponding frequency weight, total value weight and remaining shelf life weight;

[0028] The inventory counting cycle module is used to calculate the inventory counting cycle according to the frequency weight, the total value weight and the remaining shelf life weight, and determine the inventory counting time of the corresponding goods according to the inventory counting cycle;

[0029] The priority module is used to calculate the priorities of different goods and sort them according to their priorities. Goods with higher priorities will be counted first at the same inventory time.

[0030] An electronic device comprises a memory and a processor, wherein the memory stores program instructions, and when the processor runs the program instructions, the steps in the dynamic inventory counting method as described above are executed.

[0031] A computer-readable storage medium stores computer program instructions, and when the computer program instructions are executed by a processor, the steps in the dynamic inventory counting method as described above are executed.

[0032] The beneficial effects of the present invention are:

[0033] 1. The present invention calculates the inventory cycle and priority of each product according to its different characteristics, and generates different inventory strategies for each product accordingly, so that each product can have a corresponding inventory cycle according to its own characteristics. Compared with the traditional fixed inventory cycle method, the inventory of goods can be more accurate, which not only improves the inventory efficiency, but also does not cause waste of resources.

[0034] 2. After the inventory of goods is completed, the present invention can correct the inventory results in time and notify the warehouse manager; at the same time, it also introduces a feedback mechanism to evaluate the actual inventory efficiency, inventory results and accuracy, and timely adjust the weight coefficient, cycle scaling coefficient and business impact coefficient, so that the inventory effect reaches the best state. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 It is a flowchart of the dynamic inventory counting method;

[0036] Figure 2 It is a structural diagram of a dynamic inventory counting device. DETAILED DESCRIPTION

[0037] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of 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.

[0038] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which the present invention belongs. The terms used herein in the specification of the present invention are only for the purpose of describing specific embodiments and are not intended to limit the present invention. The term "or / and" used herein includes any and all combinations of one or more of the related listed items.

[0039] The present invention provides a dynamic inventory counting method based on the characteristics of goods. Figure 1 As shown, the method mainly includes the following steps: extracting data such as the frequency of goods entering and exiting, total value, and remaining shelf life; calculating the inventory cycle of each type of goods; calculating the priority of each type of goods; producing an inventory strategy for each type of goods based on the inventory cycle and priority; calculating the inventory results to achieve inventory warning; evaluating the inventory results, and timely adjusting the algorithm parameters of the inventory cycle and priority so that the inventory effect tends to reach the optimal state. Specifically, the characteristics of the target goods i are extracted from the intelligent warehouse management system (WMS) or enterprise management system (ERP). The characteristics include the frequency of entry and exit F i 、Total value Vi and remaining shelf life S i Among them, the frequency of entry and exit is the number of times the goods enter and exit the warehouse per unit time; the total value is the unit price of the goods multiplied by the average inventory of the goods; and the remaining shelf life is the remaining days of the goods' shelf life.

[0040] For different types of goods, the inventory counting cycle is calculated using a weight-based inventory counting cycle calculation formula. The inventory counting cycle calculation formula is:

[0041]

[0042] Where i represents the target cargo number; T i represents the inventory cycle of target goods i; t represents the cycle scaling factor, which can be set according to the actual situation and is 1 by default; α, β, γ represent weight coefficients, which can also be set according to the actual situation and must satisfy α+β+γ=1. i 、v i 、s i They represent frequency weight, total value weight and shelf life weight respectively.

[0043] According to the inventory cycle calculation formula, we only need to get the frequency weight f i , total value weight v i and warranty option weights i The value of can be used to get the inventory counting cycle of different types of goods. Among them, the frequency weight f i By the in and out frequency F i The calculation formula is:

[0044]

[0045] In the formula, F max and F min They are the frequency of goods entering and exiting the warehouse with the highest frequency and the frequency of goods entering and exiting the warehouse with the lowest frequency.

[0046] Total value weight v i By total value V i The calculation formula is:

[0047]

[0048] Where V max and V min They are the total value of the goods with the largest total value and the total value of the goods with the smallest total value in the warehouse respectively.

[0049] Shelf Option Weight i The remaining shelf life S iCalculated. Considering that the shorter the shelf life, the more frequent the inventory needs to be, the inverse relationship can be used. i The calculation formula is:

[0050]

[0051] In the formula, S max and S min They are the remaining shelf life of the goods with the longest remaining shelf life and the remaining shelf life of the goods with the shortest remaining shelf life in the warehouse. It should be noted that some goods, such as mechanical parts, tables and chairs, have a very long shelf life or are considered to have no shelf life. i Set to a custom constant. This constant can generally be set to the remaining shelf life S i When the shelf life is about 3 years, the weight of the shelf life is s i The value of .

[0052] The time when the goods enter the warehouse is known. Then, the inventory cycle of each type of goods is obtained through the above method, so that the specific inventory time of each type of goods can be known. Since the inventory cycles of different goods are different, two or more goods may arrive at a certain inventory time at the same time during the inventory process. At this time, it is necessary to compare which goods have a higher priority. For this purpose, it is necessary to calculate the priority P of each type of goods. i The priority calculation formula in this embodiment is:

[0053]

[0054] In the formula, δ i Indicates the business impact coefficient. The business impact coefficient can be set according to the importance of the goods in production, sales or supply chain, and can also be adjusted later according to actual conditions. Calculate the priority P of each product i After that, in the same inventory time, the priority P i The goods with higher priority will be counted first. When the goods are counted, the counts of other goods will be postponed (it will not affect the count cycle). During the current count, there may be multiple goods waiting for count. The next count will also be based on the priority P. i Queue in an orderly manner.

[0055] After the above steps, the inventory cycle and inventory time of each product have been determined. It is worth mentioning that for the collection of characteristic data of each product, you can set the data within a certain time period to be counted. It is necessary to make the time period for collecting data for each product consistent, for example, use data from a certain week or a certain day. A statistical cycle must also be set. The characteristic data of each product is collected once at the arrival of each statistical cycle, and the new inventory cycle of the product is recalculated based on the newly collected characteristic data, thereby forming a dynamic inventory counting task.

[0056] In addition, inventory correction and early warning are required after the inventory task. The purpose of inventory counting is to grasp the actual inventory quantity of each type of goods. Therefore, it is necessary to record the remaining shelf life of the goods while recording the inventory quantity of the goods, and compare the inventory quantity of the goods with the actual inventory quantity (the actual inventory quantity can be obtained by manual investigation, or other inventory data sources, or it can be calculated by adding and subtracting the goods deposited and taken out data from the last inventory). When the inventory quantity of the goods is inconsistent with the actual inventory quantity or the remaining shelf life reaches the set threshold, the warehouse administrator is notified for processing by any one of email, SMS, WeChat, sound and light alarm, WMS or ERP pop-up window, or a combination of two or more.

[0057] In order to further optimize the duration of each inventory counting cycle, the dynamic inventory counting method can also introduce a feedback mechanism. The inventory counting cycle and priority calculated by the dynamic inventory counting method are applied in actual inventory management. The inventory counting effect and inventory data can be regularly tested, and the weight coefficient, cycle scaling coefficient, and business impact coefficient can be dynamically adjusted in different inventory counting cycles according to actual conditions. The effectiveness of the inventory counting method is evaluated based on the efficiency and accuracy of the inventory counting, and it is continuously optimized to achieve the best inventory counting effect.

[0058] In one embodiment, there are three kinds of goods in the warehouse: bread, mineral water, and paper cups. Take the calculation of the inventory cycle of bread as an example. First, calculate the frequency weight of bread: taking days as the statistical period, the frequency of bread entering and leaving today is 10 times. Among all the goods in the warehouse, the one with the highest frequency of entering and leaving is mineral water, which has an entry and exit frequency of 100 times. The one with the lowest frequency of entering and leaving is paper cups, which has an entry and exit frequency of 2 times. Therefore, the frequency weight of bread is (10-2) / (100-2).

[0059] Calculate the total value weight of bread: Bread costs 10 yuan per bag, there are 100 bags in total, and its total value is 1000 yuan. Mineral water costs 2 yuan per bottle, there are 1000 bottles in total, and its maximum total value is 2000 yuan. Paper cups cost 1 yuan per piece, there are 100 pieces in total, and its minimum total value is 100 yuan. Therefore, the total value weight of bread is (1000-100) / (2000-100).

[0060] Calculate the shelf life weight of bread: Since the production date and shelf life of each bread may be different, there are two ways to calculate the remaining shelf life: one is to find the average remaining shelf life of all breads; the other is to treat the bread of the same batch (the same batch means that the bread is produced in the same batch, and its production date and shelf life are similar) as one kind of goods, and the bread of another batch as another kind of goods. It is known that the remaining shelf life of bread is 100 days. The remaining shelf life of mineral water is the shortest, which is 50 days. The remaining shelf life of paper cups is the longest, which is 200 days. Therefore, the shelf life weight of bread is (200-100) / (200-50).

[0061] After rounding, the frequency weight of bread is 0.08, the total value weight is 0.47, and the shelf life weight is 0.67. And taking α=0.3, β=0.3, γ=0.4, then αf i +βv i +γs i =0.3*0.08+0.3*0.47+0.4*0.67=0.024+0.141+0.268=0.433. If t is 1, the inventory cycle of bread is 1 / 0.433≈2.3 days. If the inventory cycle is realized by a scheduled task, the inventory task will be performed after 2.3*24*60=3321 minutes. t can be selected as 10 or other values ​​according to the actual situation of warehouse management time.

[0062] In another embodiment, a dynamic inventory counting device is also proposed, which adopts the dynamic inventory counting method as described above. Figure 2 As shown, the dynamic inventory counting device includes a weight module, an inventory counting cycle module and a priority module. The weight module is used to obtain the frequency of entry and exit, total value and remaining shelf life of the goods, and calculate the corresponding frequency weight, total value weight and remaining shelf life weight. The inventory counting cycle module is used to calculate the inventory counting cycle according to the frequency weight, total value weight and remaining shelf life weight, and determine the inventory counting time of the corresponding goods according to the inventory counting cycle. The priority module is used to calculate the priority of different goods, and sort them according to the priority level, and the goods with high priority in the same inventory counting time will be counted first.

[0063] In another embodiment, an electronic device is provided. The electronic device includes a memory and a processor. The memory stores program instructions. When the processor runs the program instructions, the steps in the above-mentioned dynamic inventory counting method are executed. Specifically, the electronic device can be an electronic device with logic computing functions such as a personal computer, a tablet computer, a smart phone, a personal digital assistant, etc.

[0064] If the above-mentioned dynamic inventory counting method is implemented in the form of a software function module and sold or used as an independent product, it can be stored in a computer-readable storage medium. Therefore, one of the embodiments also provides a readable storage medium, in which computer program instructions are stored. When the computer program instructions are read and run by a processor, the steps in the dynamic inventory counting method are executed. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or the part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, RanDom Access Memory), disk or optical disk and other media that can store program codes.

[0065] The technical features of the above-described embodiments may be arbitrarily combined. To make the description concise, not all possible combinations of the technical features in the above-described embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0066] The above-mentioned embodiments only express several implementation methods of the present invention, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for ordinary technicians in this field, several variations and improvements can be made without departing from the concept of the present invention, and these all belong to the protection scope of the present invention. Therefore, the protection scope of the patent of the present invention shall be subject to the attached claims.

Claims

1. A dynamic inventory counting method, characterized in that: It includes the following steps: Get the in-and-out frequency F of target goods i i And calculate the frequency weight f i , and its calculation formula is: In the formula, F max and F min They are the in / out frequency of the goods with the highest in / out frequency and the in / out frequency of the goods with the lowest in / out frequency; Get the total value V of target goods i i And calculate the total value weight v i , and its calculation formula is: Where V max and V min They are the total value of the goods with the largest total value and the total value of the goods with the smallest total value; Get the remaining shelf life S of the target product i i And calculate the warranty period weight s i , and its calculation formula is: In the formula, S max and S min They are the remaining shelf life of the goods with the longest remaining shelf life and the remaining shelf life of the goods with the shortest remaining shelf life; According to the frequency weight f i , total value weight v i and warranty option weights i Calculate the inventory cycle T of target goods i i , and its calculation formula is: In the formula, t represents the period scaling factor, α, β, γ represent the weight coefficients, and α+β+γ=1; According to the inventory cycle T i , periodically perform inventory tasks on the target goods i.

2. The dynamic inventory counting method according to claim 1, characterized in that: The in and out frequency F i , total value weight v i and remaining shelf life S i Exported from the intelligent warehouse management system or enterprise management system.

3. The dynamic inventory counting method according to claim 1, characterized in that: The dynamic inventory counting method further comprises the following steps: calculating the priority P of each commodity i ; If the inventory time of different goods is the same, the priority P i Goods with high priority are counted first; the priority calculation formula is: In the formula, δ i Indicates the business impact coefficient.

4. The dynamic inventory counting method according to claim 3 is characterized in that: The dynamic inventory counting method also includes the following steps: dynamically adjusting the cycle scaling factor, weight factor and business impact factor according to the inventory counting effect, inventory counting efficiency, inventory counting accuracy and inventory data.

5. The dynamic inventory counting method according to claim 1, characterized in that: The dynamic inventory counting method further comprises the following steps: setting a statistical cycle; collecting the in-and-out frequency F of the target goods i after each statistical cycle arrives; i 、Total value V i and remaining shelf life S i ; Recalculate the inventory cycle of goods based on the newly collected data.

6. The dynamic inventory counting method according to claim 1, characterized in that: The dynamic inventory counting method also includes the following steps: recording the inventory quantity of goods after each inventory counting cycle, and comparing the inventory quantity of goods with the actual inventory quantity; if the two are inconsistent, recording the inventory difference and notifying the warehouse manager.

7. The dynamic inventory counting method according to claim 1, characterized in that: If the target product has no shelf life, the shelf life option will be reset. i Set to a custom constant.

8. A dynamic inventory counting device, characterized in that: It adopts the dynamic inventory counting method as described in any one of claims 1 to 7; The dynamic inventory counting device comprises: The weight module is used to obtain the frequency of goods entering and leaving, the total value and the remaining shelf life, and calculate the corresponding frequency weight, total value weight and remaining shelf life weight; The inventory counting cycle module is used to calculate the inventory counting cycle according to the frequency weight, the total value weight and the remaining shelf life weight, and determine the inventory counting time of the corresponding goods according to the inventory counting cycle; The priority module is used to calculate the priorities of different goods and sort them according to their priorities. Goods with higher priorities will be counted first at the same inventory time.

9. An electronic device, characterized in that: It includes a memory and a processor, wherein the memory stores program instructions, and when the processor runs the program instructions, the steps in the dynamic inventory counting method according to any one of claims 1 to 7 are executed.

10. A computer-readable storage medium, characterized in that: The readable storage medium stores computer program instructions, and when the computer program instructions are executed by a processor, the steps of the dynamic inventory counting method according to any one of claims 1 to 7 are executed.

Images