CN108596544B - Inventory distribution method and device - Google Patents

Inventory distribution method and device Download PDF

Info

Publication number
CN108596544B
CN108596544B CN201810387269.8A CN201810387269A CN108596544B CN 108596544 B CN108596544 B CN 108596544B CN 201810387269 A CN201810387269 A CN 201810387269A CN 108596544 B CN108596544 B CN 108596544B
Authority
CN
China
Prior art keywords
sub
warehouses
target
target item
inventory
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201810387269.8A
Other languages
Chinese (zh)
Other versions
CN108596544A (en
Inventor
马东辉
黄新娥
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Rockwell Technology Co Ltd
Original Assignee
Beijing CHJ Automotive Information Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing CHJ Automotive Information Technology Co Ltd filed Critical Beijing CHJ Automotive Information Technology Co Ltd
Priority to CN201810387269.8A priority Critical patent/CN108596544B/en
Publication of CN108596544A publication Critical patent/CN108596544A/en
Application granted granted Critical
Publication of CN108596544B publication Critical patent/CN108596544B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

The invention discloses an inventory allocation method and device, wherein the method comprises the following steps: acquiring characteristic data of a target item of each of at least two sub-warehouses, wherein the characteristic data of the target item at least comprises the circulation rate and the safety stock of the target item; calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses according to the characteristic data of the target item of each of the at least two sub-warehouses; and allocating the stock for part or all of the at least two sub-warehouses according to the first replenishment quantity of the target articles of each of the at least two sub-warehouses. By the inventory allocation method, the accuracy of the quantity of the inventory allocated to each sub-warehouse can be improved, and the condition of overstock or shortage of the goods in the sub-warehouse can be reduced.

Description

Inventory distribution method and device
Technical Field
The present disclosure relates to the field of computers, and in particular, to a method and an apparatus for allocating inventory.
Background
With the development of economy, the commodities operated by the current merchants can be respectively stored in sub-warehouses located in different areas, so that the commodities can be rapidly circulated in the different areas.
However, in the prior art, each sub-warehouse actively requests replenishment to the main warehouse according to its own inventory condition, and the main warehouse allocates the inventory to each sub-warehouse according to the replenishment request of each sub-warehouse, that is, allocates the inventory of the main warehouse to each sub-warehouse. Because the main warehouse cannot know the inventory conditions of all the sub-warehouses in real time, the inventory distribution mode easily causes the condition that the main warehouse distributes too much inventory for part of the sub-warehouses and distributes less inventory for part of the sub-warehouses, thereby causing the problems that goods in part of the sub-warehouses are overstocked and the part of the sub-warehouses are short of goods.
Therefore, the existing inventory allocation mode has the problem that the amount of the distributed inventory is inaccurate when the inventory is allocated to the sub-warehouse.
Disclosure of Invention
The embodiment of the disclosure provides an inventory allocation method and an inventory allocation device, which are used for solving the problem that the quantity of the distributed inventory is inaccurate when the inventory is allocated to a sub-warehouse in the existing inventory allocation mode.
In a first aspect, an embodiment of the present disclosure provides an inventory allocation method, where the method includes:
acquiring characteristic data of a target item of each of at least two sub-warehouses, wherein the characteristic data of the target item at least comprises the circulation rate and the safety stock of the target item;
calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses according to the characteristic data of the target item of each of the at least two sub-warehouses;
and allocating the stock for part or all of the at least two sub-warehouses according to the first replenishment quantity of the target articles of each of the at least two sub-warehouses.
Optionally, the circulation rate of the target item is a ratio of the sales volume of the target item to the effective stock volume of the target item.
Optionally, the acquiring characteristic data of the target item of each of the at least two sub-warehouses includes:
respectively acquiring the sales volume and the effective inventory of the target object in each of the at least two sub-warehouses in a historical calculation period, and the sales volume and the effective inventory in the current calculation period;
and calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculation period according to the sales volume and the effective inventory quantity of the target item of each of the at least two sub-warehouses in the historical calculation period and the sales volume and the effective inventory quantity in the current calculation period.
Optionally, the calculating the circulation rate of the target item in each of the at least two sub-warehouses in the current calculation cycle according to the sales volume and the effective inventory amount of the target item in each of the at least two sub-warehouses in the historical calculation cycle, and the sales volume and the effective inventory amount in the current calculation cycle respectively includes:
using a formula
Figure BDA0001642543810000021
Calculating each sub warehouse of the at least two sub warehousesThe circulation rate of the target item in the current calculation period;
wherein i>=1,AiRepresenting the circulation rate of the target item in the ith calculation cycle, BjRepresents the sales volume of the target item in the jth calculation period, SjIndicating the effective inventory of the target item in the jth calculation cycle.
Optionally, the acquiring characteristic data of the target item of each of the at least two sub-warehouses includes:
acquiring the total sales volume of target articles in each of the at least two sub-warehouses and the safety stock in a historical calculation period, wherein the total sales volume of the target articles is the sum of the sales volumes of the target articles from a preset calculation period to a current calculation period;
and calculating the effective stock of the target article in each of the at least two sub-warehouses in the current calculation period according to the total sales volume of the target article in each of the at least two sub-warehouses and the safe stock in the historical calculation period.
Optionally, the calculating the safe inventory amount of the target item in each of the at least two sub-warehouses in the current calculation period according to the total sales volume of the target item in each of the at least two sub-warehouses and the safe inventory amount in the historical calculation period respectively includes:
using a formula
Figure BDA0001642543810000031
Calculating the safe inventory amount of the target articles of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,C0=C1,CiRepresenting the safe stock of the target item in the ith calculation cycle, Ci-1Indicating the safe inventory of the target item at the i-1 st calculation cycle,
Figure BDA0001642543810000032
representing the sum of said target itemsSales volume.
Optionally, the calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses according to the characteristic data of the target item of each of the at least two sub-warehouses respectively includes:
using the formula Hi=Ai*(Ci+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses; or
Using the formula Hi=Ai*(Ci-Si+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses;
wherein i>=1,HiRepresenting a first replenishment quantity, A, of said target item during an ith calculation cycleiRepresenting the circulation rate of the target item in the ith calculation cycle, CiIndicating the safe stock of the target item in the ith calculation cycle, YiIndicating the reserved inventory quantity, Z, of the target item during the ith calculation cycleiIndicating the in-transit inventory amount of the target item at the ith calculation cycle, SiIndicating the effective inventory of the target item in the ith calculation cycle.
Optionally, the allocating the inventory for some or all of the at least two sub-warehouses according to the first replenishment quantity of the target item of each of the at least two sub-warehouses includes:
under the condition that the sum of the first replenishment quantities of the target articles of all the sub-warehouses in the at least two sub-warehouses is smaller than or equal to the inventory quantity of the total warehouse, allocating inventory for each sub-warehouse in the at least two sub-warehouses according to the first replenishment quantity of each sub-warehouse in the at least two sub-warehouses;
when the sum of the first replenishment quantities of the target items of all the sub-warehouses in the at least two sub-warehouses is larger than the inventory quantity of the total warehouse, outputting prompt information, wherein the prompt information is used for prompting a user to modify the first replenishment quantities of the target items of the sub-warehouses in the at least two sub-warehouses;
receiving a second replenishment quantity of the target item of each of the at least two sub-warehouses after the modification of the user;
and allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
Optionally, after the receiving the user-modified second replenishment quantity of the target item in each of the at least two sub-warehouses, the method further includes:
judging whether the second replenishment quantity of the target articles in each of the at least two sub-warehouses is reasonable or not according to the first replenishment quantity of the target articles in each of the at least two sub-warehouses;
the allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses respectively comprises:
and under the condition that the second replenishment quantity of the target articles of each of the at least two sub-warehouses is determined to be reasonable, allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
In a second aspect, an embodiment of the present disclosure further provides an inventory allocation apparatus, where the apparatus includes:
the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring characteristic data of a target article of each of at least two sub-warehouses, and the characteristic data of the target article at least comprises the circulation rate and the safety stock of the target article;
the calculation module is used for calculating a first replenishment quantity of the target articles in each of the at least two sub-warehouses according to the characteristic data of the target articles in each of the at least two sub-warehouses;
and the distribution module is used for distributing inventory for part or all of the at least two sub-warehouses according to the first replenishment quantity of the target articles of each of the at least two sub-warehouses.
Optionally, the circulation rate of the target item is a ratio of the sales volume of the target item to the effective stock volume of the target item.
Optionally, the obtaining module includes:
the first obtaining unit is used for respectively obtaining the sales volume and the effective stock of the target object in each of the at least two sub-warehouses in the historical calculation period, and the sales volume and the effective stock in the current calculation period;
and the first calculating unit is used for calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculating period according to the sales volume and the effective inventory quantity of the target item of each of the at least two sub-warehouses in the historical calculating period and the sales volume and the effective inventory quantity in the current calculating period.
Optionally, the first computing unit is specifically configured to:
using a formula
Figure BDA0001642543810000051
Calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,AiRepresenting the circulation rate of the target item in the ith calculation cycle, BjRepresents the sales volume of the target item in the jth calculation period, SjIndicating the effective inventory of the target item in the jth calculation cycle.
Optionally, the obtaining module includes:
a second obtaining unit, configured to obtain a total sales volume of the target item and a safety stock in a historical calculation period of each of the at least two sub-warehouses, where the total sales volume of the target item is a sum of sales volumes of the target item from a preset calculation period to a current calculation period;
and the second calculating unit is used for calculating the effective stock of the target article in each of the at least two sub-warehouses in the current calculating period according to the total sales volume of the target article in each of the at least two sub-warehouses and the safe stock in the historical calculating period.
Optionally, the second computing unit is specifically configured to:
using a formula
Figure BDA0001642543810000061
Calculating the safe inventory amount of the target articles of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,C0=C1,CiRepresenting the safe stock of the target item in the ith calculation cycle, Ci-1Indicating the safe inventory of the target item at the i-1 st calculation cycle,
Figure BDA0001642543810000062
representing the total sales volume of the target item.
Optionally, the calculation module is specifically configured to:
using the formula Hi=Ai*(Ci+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses; or
Using the formula Hi=Ai*(Ci-Si+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses;
wherein i>=1,HiRepresenting a first replenishment quantity, A, of said target item during an ith calculation cycleiRepresenting the circulation rate of the target item in the ith calculation cycle, CiIndicating the safe stock of the target item in the ith calculation cycle, YiIndicating the reserved inventory quantity, Z, of the target item during the ith calculation cycleiIndicating the in-transit inventory amount of the target item at the ith calculation cycle, SiRepresents the aboveThe effective inventory of the target item at the ith calculation cycle.
Optionally, the allocating module includes:
the first allocation unit is used for allocating stock for each of the at least two sub-warehouses according to the first replenishment quantity of each of the at least two sub-warehouses respectively when the sum of the first replenishment quantities of the target articles of all the sub-warehouses in the at least two sub-warehouses is smaller than or equal to the stock quantity of the total warehouse;
the output unit is used for outputting prompt information under the condition that the sum of the first replenishment quantities of the target articles of all the sub-warehouses in the at least two sub-warehouses is larger than the inventory quantity of the total warehouse, wherein the prompt information is used for prompting a user to modify the first replenishment quantities of the target articles of the sub-warehouses in the at least two sub-warehouses;
the receiving unit is used for receiving the second replenishment quantity of the target items of each of the at least two sub-warehouses after the modification of the user;
and the second distribution unit is used for distributing the stock for each warehouse of the at least two warehouses according to the second replenishment quantity of the target articles of each warehouse of the at least two warehouses respectively.
Optionally, the apparatus further comprises:
the judging module is used for judging whether the second replenishment quantity of the target articles in each of the at least two sub-warehouses is reasonable or not according to the first replenishment quantity of the target articles in each of the at least two sub-warehouses after receiving the second replenishment quantity of the target articles in each of the at least two sub-warehouses modified by the user;
the second allocating unit is specifically configured to:
and under the condition that the second replenishment quantity of the target articles of each of the at least two sub-warehouses is determined to be reasonable, allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
In a third aspect, an embodiment of the present disclosure further provides an electronic device, which includes a processor, a memory, and a computer program stored on the memory and executable on the processor, where the computer program, when executed by the processor, implements the steps of the inventory allocation method described above.
In a fourth aspect, the disclosed embodiments also provide a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the inventory allocation method described above.
In the embodiment of the disclosure, the replenishment quantity calculated based on the characteristic data of the target object in each sub-warehouse is considered when the sub-warehouse is allocated with the inventory, so that the accuracy of the inventory quantity allocated to each sub-warehouse can be improved, and the condition of overstock or shortage of the inventory in the sub-warehouse can be reduced.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present disclosure, the drawings needed to be used in the description of the embodiments of the present disclosure will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present disclosure, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without inventive exercise.
FIG. 1 is a flow chart of an inventory allocation method provided by an embodiment of the present disclosure;
FIG. 2 is a flow chart of a method of inventory allocation provided by yet another embodiment of the present disclosure;
FIG. 3 is a schematic view of an inventory distribution device provided by an embodiment of the present disclosure;
FIG. 4 is a schematic view of an inventory dispensing device provided by an embodiment of the present disclosure;
FIG. 5 is a schematic view of an inventory distribution device provided by an embodiment of the present disclosure;
FIG. 6 is a schematic view of an inventory dispensing device provided by an embodiment of the present disclosure;
fig. 7 is a schematic view of an electronic device provided by an embodiment of the disclosure.
Detailed Description
The technical solutions in the embodiments of the present disclosure will be clearly and completely described below with reference to the drawings in the embodiments of the present disclosure, and it is obvious that the described embodiments are some, but not all embodiments of the present disclosure. All other embodiments, which can be derived by a person skilled in the art from the embodiments disclosed herein without making any creative effort, shall fall within the protection scope of the present disclosure.
The embodiment of the disclosure provides an inventory allocation method. Referring to fig. 1, fig. 1 is a flowchart of an inventory allocation method provided by an embodiment of the present disclosure, as shown in fig. 1, including the following steps:
step 101, obtaining characteristic data of a target item of each of at least two sub-warehouses, wherein the characteristic data of the target item at least comprises the circulation rate and the safety stock of the target item.
In the disclosed embodiments, the target item may be any item, such as a vehicle part. The above-mentioned safe stock quantity may also be referred to as safe stock quantity or insurance stock quantity, and refers to an insurance stock quantity (or buffer stock quantity) predicted for preventing uncertainty factors (such as a large number of sudden orders, sudden advance of delivery date, increase of temporary usage, delivery error, and other special reasons), and the safe stock quantity may be set by a user or calculated from a historical safe stock quantity and sales quantity. The circulation rate of the target item may be a ratio of a sales amount of the target item to an average stock amount of the target item, or a ratio of a sales volume of the target item to an effective stock amount of the target item; and so on.
And 102, calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses according to the characteristic data of the target item of each of the at least two sub-warehouses.
In the embodiment of the present disclosure, the replenishment quantity (i.e., the first replenishment quantity) of the target item of each warehouse may be calculated according to the characteristic data of the target item of each warehouse, for example, when there are warehouse a, warehouse b, and warehouse c, the first replenishment quantity of the target item of warehouse a is calculated according to the characteristic data of the target item of warehouse a, the first replenishment quantity of the target item of warehouse b is calculated according to the characteristic data of the target item of warehouse b, and the first replenishment quantity of the target item of warehouse c is calculated according to the characteristic data of the target item of warehouse c. In some embodiments, the first replenishment quantity may be a product of a circulation rate of the target item and a difference between a safe stock quantity and an effective stock quantity, or the first replenishment quantity may be a product of a circulation rate of the target item and a safe stock quantity, or the like.
103, distributing inventory for part or all of the at least two sub-warehouses according to the first replenishment quantity of the target articles of each sub-warehouse of the at least two sub-warehouses.
In the embodiment of the present disclosure, inventory may be allocated to some or all of the at least two warehouse divisions according to the first replenishment quantity of the target item in each of the at least two warehouse divisions, for example, if the sum of the first replenishment quantities of the target item in all of the at least two warehouse divisions is less than or equal to the inventory quantity of the total warehouse, inventory may be allocated to each of the at least two warehouse divisions according to the first replenishment quantity of the target item in each of the at least two warehouse divisions respectively; if the sum of the first replenishment quantities of the target items of all the partial warehouses of the at least two partial warehouses is larger than the inventory quantity of the total warehouse, the distribution proportion of each partial warehouse can be determined by combining the historical inventory distribution quantity of each partial warehouse and the first replenishment quantity, and the inventory can be distributed to each partial warehouse of the at least two partial warehouses according to the distribution proportion of each partial warehouse. It is understood that if the first replenishment quantity of a certain warehouse is 0, then no inventory may be allocated to the warehouse.
According to the inventory allocation method, the general warehouse can timely acquire the characteristic data (such as circulation rate, safety inventory and the like) of the target articles of each sub-warehouse, the replenishment quantity of the target articles of each sub-warehouse is calculated according to the characteristic data of the target articles of each sub-warehouse, the replenishment quantity of the target articles of each sub-warehouse can be comprehensively considered to allocate inventory for the sub-warehouses, the accuracy of the inventory quantity allocated to each sub-warehouse can be improved, and therefore the condition of overstock or shortage of the articles in the sub-warehouses can be reduced.
In some embodiments, the circulation rate of the target item is a ratio of sales of the target item and an effective inventory of the target item.
In the embodiment of the present disclosure, the sales volume of the target item may be a sales volume of the target product in one calculation cycle, or may be an average sales volume of the target product in a plurality of calculation cycles. The calculation period may be set according to actual requirements, for example, one calculation period per week, one calculation period per month, or the like. The effective inventory may be the current actual available inventory of the sub-warehouse.
In some embodiments, the step 101 of obtaining the characteristic data of the target item in each of the at least two sub-warehouses includes:
respectively acquiring the sales volume and the effective inventory of the target object in each of the at least two sub-warehouses in a historical calculation period, and the sales volume and the effective inventory in the current calculation period;
and calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculation period according to the sales volume and the effective inventory quantity of the target item of each of the at least two sub-warehouses in the historical calculation period and the sales volume and the effective inventory quantity in the current calculation period.
In the embodiment of the present disclosure, the historical calculation cycle may be one or at least two calculation cycles before the current calculation cycle. The calculation period may be set according to actual conditions, for example, one calculation period per week, one calculation period per month, or the like.
In some embodiments, a sum Bs of sales of the historical calculation period and sales of the current calculation period, and a sum Ss of effective inventory of the historical calculation period and effective inventory of the current calculation period may be calculated, respectively, and a ratio of Bs and Ss may be used as a circulation rate of the target item in the current calculation period, or a ratio a1 of sales of each historical calculation period and effective inventory, and a ratio a2 of sales of the current calculation period and effective inventory of the target item in the current calculation period may be calculated, respectively, and an average of a1 and a2 may be used as a circulation rate of the target item in the current calculation period. It should be noted that the ratio a1 may be plural.
According to the method and the device, the circulation rate of the target article is calculated by combining the sales volume and the effective stock in the historical calculation period and the current calculation period, the obtained circulation rate of the target article can be more fit with the actual situation, the accuracy of the stock quantity distributed to each warehouse can be further improved, and the condition of overstock or shortage of goods in the warehouse can be reduced.
In some embodiments, the calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculation period according to the sales volume and the effective inventory amount of the target item of each of the at least two sub-warehouses in the historical calculation period and the sales volume and the effective inventory amount in the current calculation period respectively comprises:
using a formula
Figure BDA0001642543810000121
Calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,AiRepresenting the circulation rate of the target item in the ith calculation cycle, BjRepresents the sales volume of the target item in the jth calculation period, SjIndicating the effective inventory of the target item in the jth calculation cycle.
In the embodiment of the present disclosure, the ith calculation cycle may be the current calculation cycle, that is, aiMay represent the throughput rate of the target item over the current calculation cycle. In practical applications, a starting calculation period, i.e. the first calculation period, i ═ 1 may be set, and the value of i may be increased by 1 every time a calculation period is added.
For example, when there are warehouse divisions a and warehouse divisions b, a formula may be employed
Figure BDA0001642543810000122
Calculating the circulation rate of the sub-warehouse a in the current calculation period, wherein AaiRepresenting the circulation rate of the target item in sub-warehouse a in the i-th calculation cycle, BajIndicating the sales volume of the target item in sub-warehouse a in the j-th calculation cycle, SajThe effective stock quantity of the target item of the sub-warehouse a in the j calculation period is represented; can adopt a formula
Figure BDA0001642543810000123
Calculating the flow rate of the sub-warehouse b in the current calculation period, wherein AbiRepresenting the circulation rate of the target item of sub-warehouse b in the i-th calculation cycle, BbjRepresenting the sales of the target item in sub-warehouse b in the jth calculation cycle, SbjRepresenting the effective inventory of the target item in sub-warehouse b at the j-th calculation cycle.
According to the embodiment of the disclosure, the average value of the ratio of the sales volume and the effective stock of the target object in all the historical calculation periods and the current calculation period is used as the circulation rate of the current calculation period, so that the obtained circulation rate of the target object can be more suitable for the actual situation, the accuracy of the stock quantity allocated to each warehouse can be further improved, and the condition of overstock or shortage of goods in the warehouse can be reduced.
In some embodiments, the step 101 of obtaining the characteristic data of the target item in each of the at least two sub-warehouses includes:
acquiring the total sales volume of target articles in each of the at least two sub-warehouses and the safety stock in a historical calculation period, wherein the total sales volume of the target articles is the sum of the sales volumes of the target articles from a preset calculation period to a current calculation period;
and calculating the effective stock of the target article in each of the at least two sub-warehouses in the current calculation period according to the total sales volume of the target article in each of the at least two sub-warehouses and the safe stock in the historical calculation period.
In the embodiment of the present disclosure, the preset calculation period may be a starting calculation period, or may be another preset calculation period, for example, a3 rd calculation period before a current calculation period. The historical computation cycle may be one or more computation cycles prior to the current computation cycle.
For example, the average value of the safe stock amounts of the target object in each historical calculation cycle may be calculated, and the safe stock amount of the target object in the current calculation cycle may be calculated according to the average value of the safe stock amounts and the total sales volume, or the safe stock amount of the target object in the current calculation cycle may be calculated according to the safe stock amount and the total sales volume of the target object in the previous calculation cycle of the current calculation cycle.
The embodiment of the disclosure calculates the safe stock of the target object in the current calculation period by combining the total sales volume of the target object and the safe stock in the historical calculation period, so that the obtained safe stock of the target object can be more suitable for the actual situation, the accuracy of the stock quantity allocated to each sub-warehouse can be further improved, and the condition of goods backlog or shortage in the sub-warehouse can be reduced.
In some embodiments, the calculating the safe inventory amount of the target item of each of the at least two sub-warehouses in the current calculation period according to the total sales volume of the target item of each of the at least two sub-warehouses and the safe inventory amount in the historical calculation period respectively comprises:
using a formula
Figure BDA0001642543810000141
Calculating the safe inventory amount of the target articles of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,C0=C1,CiRepresenting the safe stock of the target item in the ith calculation cycle, Ci-1Indicating the safe inventory of the target item at the i-1 st calculation cycle,
Figure BDA0001642543810000142
representing the total sales volume of the target item.
In the embodiment of the present disclosure, the ith calculation cycle may be the current calculation cycle, that is, CiMay represent the safe inventory of the target item over the current calculation cycle. In practical applications, a starting calculation period, i.e. the first calculation period, i ═ 1 may be set, and the value of i may be increased by 1 every time a calculation period is added.
For example, when there are warehouse divisions a and warehouse divisions b, a formula may be employed
Figure BDA0001642543810000143
Calculating the safe stock of the sub-warehouse a in the current calculation period, wherein CaiIndicating the safe stock quantity, Ca, of the target item of sub-warehouse a in the i-th calculation cyclei-1The safe stock quantity of the target item of the sub-warehouse a in the i-1 st calculation period,
Figure BDA0001642543810000144
represents the total sales volume of the target item of the sub-warehouse a; can adopt a formula
Figure BDA0001642543810000145
Calculating the safe stock of the sub-warehouse b in the current calculation period, wherein CbiCb representing the safe inventory of the target item in sub-warehouse b at the i-th calculation cyclei-1Indicating the safe stock of the target item of sub-warehouse b in the i-1 th calculation cycle, BbjIndicating the total sales volume of the target item of sub-warehouse b.
According to the safe stock of the target object in the current calculation period and the total sales volume in the previous calculation period of the current calculation period, the safe stock of the target object in the current calculation period can be calculated, the obtained safe stock of the target object can be more suitable for the actual situation, the accuracy of the stock quantity distributed to each warehouse can be further improved, and the condition of cargo overstock or shortage of the warehouse can be reduced.
In some embodiments, the calculating 102, that is, the first replenishment quantity of the target item of each of the at least two sub-warehouses according to the characteristic data of the target item of each of the at least two sub-warehouses, respectively, includes:
using the formula Hi=Ai*(Ci+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses; or
Using the formula Hi=Ai*(Ci-Si+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses;
wherein i>=1,HiRepresenting a first replenishment quantity, A, of said target item during an ith calculation cycleiRepresenting the circulation rate of the target item in the ith calculation cycle, CiIndicating the safe stock of the target item in the ith calculation cycle, YiIndicating the reserved inventory quantity, Z, of the target item during the ith calculation cycleiIndicating the in-transit inventory amount of the target item at the ith calculation cycle, SiIndicating the effective inventory of the target item in the ith calculation cycle.
In the embodiment of the present disclosure, the above-mentioned AiThe ratio of the sales volume of the target article in the current calculation period to the effective inventory can be used, and the circulation rate of the target article can also be calculated by adopting the calculation method. Ci may be a security stock of the target item preset by the user, or may be a security stock of the target item calculated by the calculation method. Y is aboveiMay represent the amount of reserve inventory of the target item for the current computing cycle, where reserve inventory may refer to the number of target items that have been sold by the sub-warehouse but have not yet been shipped. Z aboveiAn in-transit inventory of the target item over the current computing cycle may be represented, where the in-transit inventory may refer to a quantity of the target item that has been allocated or sent to the sub-warehouse, but has not yet reached the sub-warehouse.
In some embodiments, formula H is employedi=Ai*(Ci+Yi-Zi) In the case of calculating a first replenishment quantity of the target item for each of the at least two sub-warehouses,
Figure BDA0001642543810000151
Figure BDA0001642543810000161
in the formula Hi=Ai*(Ci-Si+Yi-Zi) Calculating a first replenishment quantity of the target item for each of the at least two sub-warehouses, wherein AiMay be a ratio of the sales volume of the target item in the current calculation cycle to the effective stock amount, and Ci may be a safe stock amount of the target item set in advance by the user.
The disclosed embodiment employs formula Hi=Ai*(Ci+Yi-Zi) Or formula Hi=Ai*(Ci-Si+Yi-Zi) The first replenishment quantity of the target articles in each of the at least two sub-warehouses is calculated, and the calculated replenishment quantity of the target articles in each sub-warehouse is more accurate due to the consideration of characteristic data such as circulation rate, safe stock, effective stock, reserved stock and in-transit stock of the target articles in each sub-warehouse, so that the accuracy of the stock quantity allocated to each sub-warehouse can be further improved, and the condition of cargo overstock or shortage of the sub-warehouse is reduced.
In some embodiments, the step 103 of allocating the inventory for some or all of the at least two sub-warehouses according to the first replenishment quantity of the target item of each of the at least two sub-warehouses includes:
under the condition that the sum of the first replenishment quantities of the target articles of all the sub-warehouses in the at least two sub-warehouses is smaller than or equal to the inventory quantity of the total warehouse, allocating inventory for each sub-warehouse in the at least two sub-warehouses according to the first replenishment quantity of each sub-warehouse in the at least two sub-warehouses;
when the sum of the first replenishment quantities of the target items of all the sub-warehouses in the at least two sub-warehouses is larger than the inventory quantity of the total warehouse, outputting prompt information, wherein the prompt information is used for prompting a user to modify the first replenishment quantities of the target items of the sub-warehouses in the at least two sub-warehouses;
receiving a second replenishment quantity of the target item of each of the at least two sub-warehouses after the modification of the user;
and allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
In the embodiment of the present disclosure, in a case that a sum of the first replenishment quantities of the target items of all the sub-warehouses in the at least two sub-warehouses is less than or equal to the inventory quantity of the total warehouse, the inventory may be allocated to each of the at least two sub-warehouses according to the first replenishment quantity of each of the at least two sub-warehouses, respectively. For example, there are warehouse divisions a, warehouse divisions b, and warehouse divisions c, where the first replenishment quantities of warehouse divisions a, warehouse divisions b, and warehouse divisions c are a1, b1, and c1, respectively, and the inventory quantity of the total warehouse is d1, then if a1+ b1+ c1 is less than or equal to d1, a1 inventory may be allocated to warehouse division a, b1 inventory may be allocated to warehouse division b, and c1 inventory may be allocated to warehouse division c.
When the sum of the first replenishment quantities of the target objects in all the sub-warehouses in the at least two sub-warehouses is greater than the inventory quantity of the total warehouse, because the inventory quantity of the total warehouse is not enough to be allocated to each sub-warehouse, the user can be prompted to modify the replenishment quantity (namely, the first replenishment quantity) of each sub-warehouse, for example, the first replenishment quantity of each sub-warehouse can be output and marked by a first preset color (for example, yellow, red and the like) to prompt the user to modify, or a prompt box can be output to prompt the user to modify, and the modified replenishment quantity (namely, the second replenishment quantity) of each sub-warehouse can be enabled to be less than or equal to the inventory quantity of the total warehouse by modifying the replenishment quantity of the sub-warehouses by the user.
It is understood that if the user does not modify the distribution of the replenishment items, the process may be ended, or the distribution ratio of each warehouse may be calculated according to the replenishment quantity of the target items in each warehouse, and the stock may be distributed to each warehouse according to the distribution ratio of each warehouse.
It is to be understood that, in a case that the sum of the first replenishment quantities of the target items in all the at least two sub-warehouses is less than or equal to the inventory quantity of the total warehouse, the user may also modify the replenishment quantity of each sub-warehouse, for example, after calculating the first replenishment quantities of the target items in all the at least two sub-warehouses, the first replenishment quantities of the target items in each sub-warehouse may be output for the user to view, and at this time, the user may modify the first replenishment quantities of the target items in each sub-warehouse according to actual needs.
In the embodiment of the disclosure, the user can adjust the replenishment quantity of the target articles in each sub-warehouse, and the flexibility of allocating the inventory for the sub-warehouses can be improved.
In some embodiments, after the receiving the user-modified second replenishment quantity of the target item for each of the at least two sub-warehouses, the method further comprises:
judging whether the second replenishment quantity of the target articles in each of the at least two sub-warehouses is reasonable or not according to the first replenishment quantity of the target articles in each of the at least two sub-warehouses;
the allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses respectively comprises:
and under the condition that the second replenishment quantity of the target articles of each of the at least two sub-warehouses is determined to be reasonable, allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
In the embodiment of the present disclosure, whether the second replenishment quantity of the target item of each sub-warehouse adjusted by the user is reasonable may be determined based on the first replenishment quantity of the target item of each sub-warehouse, for example, if a difference between the second replenishment quantity of the target item and the first replenishment quantity is smaller than a preset threshold, it is determined that the second replenishment quantity is reasonable, otherwise, it is determined that the second replenishment quantity is unreasonable.
In some embodiments, in a case that it is determined that the second replenishment quantity of the target item of each of the at least two sub-warehouses is reasonable, allocating an inventory for each of the at least two sub-warehouses according to the second replenishment quantity of the target item of each of the at least two sub-warehouses, respectively; under the condition that the second replenishment quantity of the target articles stored in the at least two warehouse divisions in the target warehouse is not reasonable, the second replenishment quantity of the target warehouse divisions can be identified by a second preset color, or a prompt box is output to prompt a user that the second replenishment quantity of the target warehouse divisions is not reasonable, and at the moment, the user can continuously adjust the replenishment quantity of the target warehouse divisions.
The embodiment of the disclosure judges whether the second replenishment quantity of the target object of each sub-warehouse adjusted by the user is reasonable or not based on the first replenishment quantity of the target object of each sub-warehouse, so that the replenishment quantity modified by the user can be more in line with the actual situation, and the accuracy of the stock quantity distributed to each sub-warehouse is improved.
The following describes embodiments of the present disclosure with reference to examples:
the following parameters can be preset in the embodiment of the disclosure:
first, the corresponding relationship between the warehouse and the warehouse, for example, the total warehouse a corresponds to the warehouse a1, the warehouse a2 and the warehouse a3, the total warehouse b corresponds to the warehouse b1, the warehouse b2, the warehouse b3 and the warehouse b4, and the total warehouse c corresponds to the warehouse c1, the warehouse c2 and the warehouse c 3.
And II, safe inventory of each sub-warehouse.
The safety stock may be calculated without providing it.
And thirdly, the type of replenishment and the delivery time.
Fourthly, early warning setting: and when the early warning is set to be effective, the early warning value is Ci, namely, when the effective inventory is less than the early warning value, the warning is carried out.
In practical applications, referring to fig. 2, the inventory allocation method may include the following steps:
step 201, creating a replenishment plan.
In this step, it may include selecting a replenishment plan data source, that is, selecting a total warehouse (that is, a central warehouse) and a warehouse covered by the total warehouse or a warehouse requiring replenishment.
In some embodiments, this step may also select computational logic, wherein the computational logic may include the formula H abovei=Ai*(Ci+Yi-Zi) Or formula Hi=Ai*(Ci-Si+Yi-Zi) So that the proposed replenishment quantity (i.e., the first replenishment quantity) of each of the selected sub-warehouses can be calculated according to the selected calculation logic.
Step 202, generating a replenishment plan.
In this step, the proposed replenishment quantity for each sub-warehouse may be calculated according to the selected replenishment plan data source and the selected calculation logic.
After obtaining the recommended replenishment quantity of each warehouse, the replenishment situations can be found to exist in three types:
in the first case, replenishment is possible, i.e. the inventory of the central warehouse is greater than or equal to the sum of the recommended replenishment quantities of the selected individual sub-warehouses.
In the second case, partial restocking, i.e. stock in the central warehouse < the sum of the proposed stocks in the selected individual sub-warehouses.
In the third case, replenishment is not required, i.e., the recommended replenishment quantity for each selected sub-warehouse is 0.
And step 203, adjusting the replenishment part.
In the embodiment of the present disclosure, the suggested replenishment quantities of the items (e.g., parts) belonging to different replenishment situations may be stored in different replenishment areas. In this step, data of three replenishment areas in the replenishment plan can be modified, and the data in the three replenishment areas can be mutually converted, for example, parts which do not need replenishment can be supplied to the replenishment area after the replenishment quantity is modified.
And step 204, confirming the replenishment plan.
And step 205, generating a replenishment bill.
After the replenishment plan is confirmed, the replenishment plan can be automatically converted into a replenishment bill. The replenishment order correlation logic may be as follows:
a) a restocking plan may generate one or more restocking orders. Replenishment orders may be generated for dimensions "sub-warehouse".
b) And only the articles (such as parts) in the 'restockable' area can be generated into a restocking bill, so that the condition that the central warehouse is in short stock and a restocking delivery bill is generated is avoided. That is, the items in the "partial restocking" area and the "no restocking needed" area in the restocking plan do not generate a restocking order.
c) The type of the replenishment order inherits the type of the replenishment plan, for example, if the replenishment plan is "urgent replenishment", the generated replenishment order is also "urgent replenishment".
In practical application, after a replenishment order is obtained, the replenishment order can be sent to the central warehouse for stock preparation, and meanwhile, stock preparation information can be sent to a mobile phone of a central warehouse manager.
In some embodiments, the replenishment pre-warning and automatic replenishment process may be performed, that is, when the inventory of the sub-warehouse is lower than the safety inventory, the system may generate a sub-warehouse replenishment pre-warning mechanism, and may send a replenishment pre-warning prompt to a preset terminal (e.g., a mobile phone) when the pre-warning mechanism is generated, after the replenishment is confirmed by the preset terminal or confirmed by the system pre-warning information, the system may automatically generate a replenishment plan, and if the replenishment is cancelled, the system may not automatically generate the replenishment plan, but the system may determine whether to remind again according to the system setting information.
According to the inventory allocation method provided by the embodiment of the disclosure, the inventory condition of each sub-warehouse can be known in time, and the sub-warehouses can be supplemented in time according to the data such as the circulation rate and the inventory attribute of the articles in each sub-warehouse, so that the safe inventory of each sub-warehouse is ensured, and the stock pressure and the stock shortage pressure of each sub-warehouse are reduced. In addition, a user can dynamically specify replenishment logic, the inventory allocation method provided by the embodiment of the disclosure can quickly count the quantity of replenishment needed by each warehouse according to the specified calculation logic and the condition of whether replenishment is needed, and the user can arbitrarily modify the calculated recommended replenishment quantity, but the inventory allocation method provided by the embodiment of the disclosure can judge whether the recommended quantity is reasonable according to the selected calculation logic in real time. In addition, the inventory allocation method provided by the embodiment of the disclosure also provides a replenishment early warning mechanism and an automatic replenishment mechanism.
Referring to fig. 3, fig. 3 is a structural diagram of an inventory dispensing device provided by an embodiment of the present disclosure. As shown in fig. 3, the inventory dispensing device 300 includes: an obtaining module 301, a calculating module 302 and an allocating module 303, wherein:
an obtaining module 301, configured to obtain feature data of a target item in each of at least two sub-warehouses, where the feature data of the target item at least includes a circulation rate and a security stock amount of the target item;
a calculating module 302, configured to calculate a first replenishment quantity of the target item in each of the at least two sub-warehouses according to the characteristic data of the target item in each of the at least two sub-warehouses, respectively;
the allocating module 303 is configured to allocate inventory to some or all of the at least two warehouse divisions according to the first replenishment quantity of the target item in each of the at least two warehouse divisions.
In some embodiments, the circulation rate of the target item is a ratio of sales of the target item and an effective inventory of the target item.
In some embodiments, referring to fig. 4, the obtaining module 301 comprises:
a first obtaining unit 3011, configured to obtain the sales volume and the effective inventory amount of the target item in each of the at least two sub-warehouses in the historical calculation period, and the sales volume and the effective inventory amount in the current calculation period, respectively;
a first calculating unit 3012, configured to calculate a circulation rate of the target item in each of the at least two sub-warehouses in the current calculating period according to the sales volume and the effective inventory amount of the target item in each of the at least two sub-warehouses in the historical calculating period, and the sales volume and the effective inventory amount in the current calculating period, respectively.
In some embodiments, the first computing unit 3012 is specifically configured to:
using a formula
Figure BDA0001642543810000211
Calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,AiRepresenting the circulation rate of the target item in the ith calculation cycle, BjRepresents the sales volume of the target item in the jth calculation period, SjIndicating the effective inventory of the target item in the jth calculation cycle.
In some embodiments, referring to fig. 5, the obtaining module 301 comprises:
a second obtaining unit 3013, configured to obtain a total sales volume of the target item and a safety stock volume in a historical calculation period of each of the at least two sub-warehouses, where the total sales volume of the target item is a sum of sales volumes of the target item from a preset calculation period to a current calculation period;
and a second calculating unit 3014, configured to calculate, according to the total sales volume of the target item in each of the at least two sub-warehouses and the safe inventory amount in the historical calculation period, an effective inventory amount of the target item in each of the at least two sub-warehouses in the current calculation period.
In some embodiments, the second computing unit 3014 is specifically configured to:
using a formula
Figure BDA0001642543810000221
Calculating the safe inventory amount of the target articles of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,C0=C1,CiRepresenting the safe stock of the target item in the ith calculation cycle, Ci-1Indicating the safe inventory of the target item at the i-1 st calculation cycle,
Figure BDA0001642543810000222
representing the total sales volume of the target item.
In some embodiments, the calculation module 302 is specifically configured to:
using the formula Hi=Ai*(Ci+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses; or
Using the formula Hi=Ai*(Ci-Si+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses;
wherein i>=1,HiRepresenting a first replenishment quantity, A, of said target item during an ith calculation cycleiRepresenting the circulation rate of the target item in the ith calculation cycle, CiIndicating the safe stock of the target item in the ith calculation cycle, YiIndicating the reserved inventory quantity, Z, of the target item during the ith calculation cycleiIndicating the in-transit inventory amount of the target item at the ith calculation cycle, SiIndicating the effective inventory of the target item in the ith calculation cycle.
In some embodiments, referring to fig. 6, the assignment module 303 comprises:
a first allocating unit 3031, configured to allocate inventory to each of the at least two sub-warehouses according to the first replenishment quantity of each of the at least two sub-warehouses, respectively, when a sum of the first replenishment quantities of the target items of all the sub-warehouses in the at least two sub-warehouses is less than or equal to the inventory quantity of the total warehouse;
an output unit 3032, configured to output a prompt message when a sum of the first replenishment quantities of the target items in all the at least two sub-warehouses is greater than the inventory quantity of the total warehouse, where the prompt message is used to prompt a user to modify the first replenishment quantity of the target item in the sub-warehouse of the at least two sub-warehouses;
a receiving unit 3033, configured to receive the user-modified second replenishment quantity of the target item in each of the at least two sub-warehouses;
a second allocating unit 3034, configured to allocate the inventory for each of the at least two sub-warehouses according to a second replenishment quantity of the target items of each of the at least two sub-warehouses, respectively.
In some embodiments, the apparatus further comprises:
the judging module is used for judging whether the second replenishment quantity of the target articles in each of the at least two sub-warehouses is reasonable or not according to the first replenishment quantity of the target articles in each of the at least two sub-warehouses after receiving the second replenishment quantity of the target articles in each of the at least two sub-warehouses modified by the user;
the second allocating unit 3034 is specifically configured to:
and under the condition that the second replenishment quantity of the target articles of each of the at least two sub-warehouses is determined to be reasonable, allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
The inventory allocation device 300 can implement the processes of the inventory allocation method according to the method embodiments of fig. 1 to fig. 2, and achieve the same effect to avoid repetition, which is not described herein again.
The inventory allocation device 300 of the embodiment of the present disclosure includes an obtaining module 301, configured to obtain characteristic data of a target item in each of at least two sub-warehouses, where the characteristic data of the target item at least includes a circulation rate and a safety stock amount of the target item; a calculating module 302, configured to calculate a first replenishment quantity of the target item in each of the at least two sub-warehouses according to the characteristic data of the target item in each of the at least two sub-warehouses, respectively; the allocating module 303 is configured to allocate inventory to some or all of the at least two sub-warehouses according to the first replenishment quantity of the target object in each of the at least two sub-warehouses, so that accuracy of the amount of inventory allocated to each sub-warehouse can be improved, and thus, the situation of overstock or shortage of the goods in the sub-warehouses can be reduced.
The embodiment of the present disclosure further provides an inventory allocation device, which includes a processor, a memory, and a computer program stored in the memory and capable of running on the processor, where the computer program, when executed by the processor, implements each process of the inventory allocation method according to any of the above method embodiments, and can achieve the same technical effect, and is not described herein again to avoid repetition.
The embodiments of the present disclosure further provide a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the computer program implements each process of the inventory allocation method, and can achieve the same technical effect, and in order to avoid repetition, details are not repeated here. The computer-readable storage medium may be a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk.
Referring to fig. 7, fig. 7 is a structural diagram of an electronic device provided in the implementation of the present disclosure, and as shown in fig. 7, an electronic device 700 includes: a processor 701, a memory 702 and a computer program stored on the memory 702 and executable on the processor, the various components in the electronic device 700 being coupled together by a bus interface 703, the computer program when executed by the processor 701 implementing the steps of:
acquiring characteristic data of a target item of each of at least two sub-warehouses, wherein the characteristic data of the target item at least comprises the circulation rate and the safety stock of the target item;
calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses according to the characteristic data of the target item of each of the at least two sub-warehouses;
and allocating the stock for part or all of the at least two sub-warehouses according to the first replenishment quantity of the target articles of each of the at least two sub-warehouses.
In some embodiments, the circulation rate of the target item is a ratio of sales of the target item and an effective inventory of the target item.
In some embodiments, the computer program when executed by the processor 701 is further configured to:
respectively acquiring the sales volume and the effective inventory of the target object in each of the at least two sub-warehouses in a historical calculation period, and the sales volume and the effective inventory in the current calculation period;
and calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculation period according to the sales volume and the effective inventory quantity of the target item of each of the at least two sub-warehouses in the historical calculation period and the sales volume and the effective inventory quantity in the current calculation period.
In some embodiments, the computer program when executed by the processor 701 is further configured to:
using a formula
Figure BDA0001642543810000251
Calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,AiRepresenting the circulation rate of the target item in the ith calculation cycle, BjRepresents the sales volume of the target item in the jth calculation period, SjIndicating the effective inventory of the target item in the jth calculation cycle.
In some embodiments, the computer program when executed by the processor 701 is further configured to:
acquiring the total sales volume of target articles in each of the at least two sub-warehouses and the safety stock in a historical calculation period, wherein the total sales volume of the target articles is the sum of the sales volumes of the target articles from a preset calculation period to a current calculation period;
and calculating the effective stock of the target article in each of the at least two sub-warehouses in the current calculation period according to the total sales volume of the target article in each of the at least two sub-warehouses and the safe stock in the historical calculation period.
In some embodiments, the computer program when executed by the processor 701 is further configured to:
using a formula
Figure BDA0001642543810000261
Calculating the safe inventory amount of the target articles of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,C0=C1,CiRepresenting the safe stock of the target item in the ith calculation cycle, Ci-1Indicating the safe inventory of the target item at the i-1 st calculation cycle,
Figure BDA0001642543810000262
representing the total sales volume of the target item.
In some embodiments, the computer program when executed by the processor 701 is further configured to:
using the formula Hi=Ai*(Ci+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses; or
Using the formula Hi=Ai*(Ci-Si+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses;
wherein i>=1,HiRepresenting a first replenishment quantity, A, of said target item during an ith calculation cycleiRepresenting the circulation rate of the target item in the ith calculation cycle, CiIndicating the safe stock of the target item in the ith calculation cycle, YiIndicating the reserved inventory quantity, Z, of the target item during the ith calculation cycleiIndicating the in-transit inventory amount of the target item at the ith calculation cycle, SiIndicating the effective inventory of the target item in the ith calculation cycle.
In some embodiments, the computer program when executed by the processor 701 is further configured to:
under the condition that the sum of the first replenishment quantities of the target articles of all the sub-warehouses in the at least two sub-warehouses is smaller than or equal to the inventory quantity of the total warehouse, allocating inventory for each sub-warehouse in the at least two sub-warehouses according to the first replenishment quantity of each sub-warehouse in the at least two sub-warehouses;
when the sum of the first replenishment quantities of the target items of all the sub-warehouses in the at least two sub-warehouses is larger than the inventory quantity of the total warehouse, outputting prompt information, wherein the prompt information is used for prompting a user to modify the first replenishment quantities of the target items of the sub-warehouses in the at least two sub-warehouses;
receiving a second replenishment quantity of the target item of each of the at least two sub-warehouses after the modification of the user;
and allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
In some embodiments, the computer program when executed by the processor 701 is further configured to:
after receiving the second replenishment quantity of the target items of each of the at least two sub-warehouses modified by the user, judging whether the second replenishment quantity of the target items of each of the at least two sub-warehouses is reasonable or not according to the first replenishment quantity of the target items of each of the at least two sub-warehouses respectively;
the allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses respectively comprises:
and under the condition that the second replenishment quantity of the target articles of each of the at least two sub-warehouses is determined to be reasonable, allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present disclosure.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiments of the present disclosure.
In addition, functional units in the embodiments of the present disclosure may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present disclosure may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present disclosure. And the aforementioned storage medium includes: various media capable of storing program codes, such as a U disk, a removable hard disk, a ROM, a RAM, a magnetic disk, or an optical disk.
The above description is only for the specific embodiments of the present disclosure, but the scope of the present disclosure is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present disclosure, and all the changes or substitutions should be covered within the scope of the present disclosure. Therefore, the protection scope of the present disclosure shall be subject to the protection scope of the claims.

Claims (14)

1. An inventory allocation method, comprising:
the method comprises the steps of obtaining characteristic data of a target article of each of at least two sub-warehouses, wherein the characteristic data of the target article at least comprise the circulation rate and the safety stock of the target article, and the circulation rate of the target article is the ratio of the sales volume of the target article to the effective stock of the target article;
calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses according to the characteristic data of the target item of each of the at least two sub-warehouses;
according to the first replenishment quantity of the target articles of each of the at least two sub-warehouses, allocating stock for part or all of the at least two sub-warehouses;
the acquiring of the characteristic data of the target object of each of the at least two sub-warehouses comprises:
respectively acquiring the sales volume and the effective inventory of the target object in each of the at least two sub-warehouses in a historical calculation period, and the sales volume and the effective inventory in the current calculation period;
calculating the circulation rate of the target item of each sub-warehouse of the at least two sub-warehouses in the current calculation period according to the sales volume and the effective inventory of the target item of each sub-warehouse of the at least two sub-warehouses in the historical calculation period and the sales volume and the effective inventory of the target item in the current calculation period; the calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses according to the characteristic data of the target item of each of the at least two sub-warehouses respectively comprises:
using the formula Hi=Ai*(Ci+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses; or
Using the formula Hi=Ai*(Ci-Si+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses;
wherein i>=1,HiRepresenting a first replenishment quantity, A, of said target item during an ith calculation cycleiRepresenting the circulation rate of the target item in the ith calculation cycle, CiIndicating the safe stock of the target item in the ith calculation cycle, YiIndicating the reserved inventory quantity, Z, of the target item during the ith calculation cycleiIndicating the in-transit inventory amount of the target item at the ith calculation cycle, SiIndicating the effective inventory of the target item in the ith calculation cycle;
the allocating the stock for some or all of the at least two sub-warehouses according to the first replenishment quantity of the target item of each of the at least two sub-warehouses comprises:
and if the sum of the first replenishment quantities of the target articles of all partial warehouses in the at least two sub-warehouses is larger than the inventory quantity of the total warehouse, determining the distribution proportion of each sub-warehouse according to the historical inventory distribution quantity and the first replenishment quantity of each sub-warehouse, and distributing inventory for each sub-warehouse in the at least two sub-warehouses according to the distribution proportion of each sub-warehouse.
2. The method according to claim 1, wherein the calculating the circulation rate of the target item in each of the at least two sub-warehouses in the current calculation period according to the sales volume and the effective inventory amount of the target item in each of the at least two sub-warehouses in the historical calculation period and the sales volume and the effective inventory amount in the current calculation period respectively comprises:
using a formula
Figure FDA0002473881780000021
Calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,AiRepresenting the circulation rate of the target item in the ith calculation cycle, BjRepresents the sales volume of the target item in the jth calculation period, SjIndicating that the target item is in the jth calculation weekThe effective inventory of the period.
3. The method of claim 1, wherein the obtaining characteristic data of the target item for each of the at least two sub-warehouses comprises:
acquiring the total sales volume of target articles in each of the at least two sub-warehouses and the safety stock in a historical calculation period, wherein the total sales volume of the target articles is the sum of the sales volumes of the target articles from a preset calculation period to a current calculation period;
and calculating the effective stock of the target article in each of the at least two sub-warehouses in the current calculation period according to the total sales volume of the target article in each of the at least two sub-warehouses and the safe stock in the historical calculation period.
4. The method according to claim 3, wherein the calculating the safe inventory amount of the target item of each of the at least two sub-warehouses in the current calculation period according to the total sales volume of the target item of each of the at least two sub-warehouses and the safe inventory amount in the historical calculation period respectively comprises:
using a formula
Figure FDA0002473881780000031
Calculating the safe inventory amount of the target articles of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,C0=C1,CiRepresenting the safe stock of the target item in the ith calculation cycle, Ci-1Indicating the safe inventory of the target item at the i-1 st calculation cycle,
Figure FDA0002473881780000032
representing the total sales volume of the target item.
5. The method according to any one of claims 1 to 4, wherein the allocating inventory for some or all of the at least two sub-warehouses according to the first replenishment quantity of the target item for each of the at least two sub-warehouses comprises:
under the condition that the sum of the first replenishment quantities of the target articles of all the sub-warehouses in the at least two sub-warehouses is smaller than or equal to the inventory quantity of the total warehouse, allocating inventory for each sub-warehouse in the at least two sub-warehouses according to the first replenishment quantity of each sub-warehouse in the at least two sub-warehouses;
when the sum of the first replenishment quantities of the target items of all the sub-warehouses in the at least two sub-warehouses is larger than the inventory quantity of the total warehouse, outputting prompt information, wherein the prompt information is used for prompting a user to modify the first replenishment quantities of the target items of the sub-warehouses in the at least two sub-warehouses;
receiving a second replenishment quantity of the target item of each of the at least two sub-warehouses after the modification of the user;
and allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
6. The method of claim 5, wherein after said receiving the user-modified second replenishment quantity for the target item for each of the at least two sub-warehouses, the method further comprises:
judging whether the second replenishment quantity of the target articles in each of the at least two sub-warehouses is reasonable or not according to the first replenishment quantity of the target articles in each of the at least two sub-warehouses;
the allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses respectively comprises:
and under the condition that the second replenishment quantity of the target articles of each of the at least two sub-warehouses is determined to be reasonable, allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
7. An inventory allocation device, comprising:
the system comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring characteristic data of a target article of each of at least two sub-warehouses, the characteristic data of the target article at least comprises the circulation rate and the safety stock of the target article, and the circulation rate of the target article is the ratio of the sales volume of the target article to the effective stock of the target article;
the calculation module is used for calculating a first replenishment quantity of the target articles in each of the at least two sub-warehouses according to the characteristic data of the target articles in each of the at least two sub-warehouses;
the distribution module is used for distributing inventory for part or all of the at least two sub-warehouses according to the first replenishment quantity of the target articles of each sub-warehouse of the at least two sub-warehouses;
the acquisition module includes:
the first obtaining unit is used for respectively obtaining the sales volume and the effective stock of the target object in each of the at least two sub-warehouses in the historical calculation period, and the sales volume and the effective stock in the current calculation period;
the first calculation unit is used for calculating the circulation rate of the target article in each of the at least two sub-warehouses in the current calculation period according to the sales volume and the effective inventory amount of the target article in each of the at least two sub-warehouses in the historical calculation period and the sales volume and the effective inventory amount in the current calculation period;
the calculation module is specifically configured to:
using the formula Hi=Ai*(Ci+Yi-Zi) Calculating each sub warehouse of the at least two sub warehousesA first restocking quantity of the target item of (1); or
Using the formula Hi=Ai*(Ci-Si+Yi-Zi) Calculating a first replenishment quantity of the target item of each of the at least two sub-warehouses;
wherein i>=1,HiRepresenting a first replenishment quantity, A, of said target item during an ith calculation cycleiRepresenting the circulation rate of the target item in the ith calculation cycle, CiIndicating the safe stock of the target item in the ith calculation cycle, YiIndicating the reserved inventory quantity, Z, of the target item during the ith calculation cycleiIndicating the in-transit inventory amount of the target item at the ith calculation cycle, SiIndicating the effective inventory of the target item in the ith calculation cycle;
the allocation module is specifically configured to:
and if the sum of the first replenishment quantities of the target articles of all partial warehouses in the at least two sub-warehouses is larger than the inventory quantity of the total warehouse, determining the distribution proportion of each sub-warehouse according to the historical inventory distribution quantity and the first replenishment quantity of each sub-warehouse, and distributing inventory for each sub-warehouse in the at least two sub-warehouses according to the distribution proportion of each sub-warehouse.
8. The apparatus according to claim 7, wherein the first computing unit is specifically configured to:
using a formula
Figure FDA0002473881780000061
Calculating the circulation rate of the target item of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,AiRepresenting the circulation rate of the target item in the ith calculation cycle, BjRepresents the sales volume of the target item in the jth calculation period, SjIndicating the effective inventory of the target item in the jth calculation cycle.
9. The apparatus of claim 7, wherein the obtaining module comprises:
a second obtaining unit, configured to obtain a total sales volume of the target item and a safety stock in a historical calculation period of each of the at least two sub-warehouses, where the total sales volume of the target item is a sum of sales volumes of the target item from a preset calculation period to a current calculation period;
and the second calculating unit is used for calculating the effective stock of the target article in each of the at least two sub-warehouses in the current calculating period according to the total sales volume of the target article in each of the at least two sub-warehouses and the safe stock in the historical calculating period.
10. The apparatus according to claim 9, wherein the second computing unit is specifically configured to:
using a formula
Figure FDA0002473881780000062
Calculating the safe inventory amount of the target articles of each of the at least two sub-warehouses in the current calculation period;
wherein i>=1,C0=C1,CiRepresenting the safe stock of the target item in the ith calculation cycle, Ci-1Indicating the safe inventory of the target item at the i-1 st calculation cycle,
Figure FDA0002473881780000063
representing the total sales volume of the target item.
11. The apparatus of any one of claims 7 to 10, wherein the assignment module comprises:
the first allocation unit is used for allocating stock for each of the at least two sub-warehouses according to the first replenishment quantity of each of the at least two sub-warehouses respectively when the sum of the first replenishment quantities of the target articles of all the sub-warehouses in the at least two sub-warehouses is smaller than or equal to the stock quantity of the total warehouse;
the output unit is used for outputting prompt information under the condition that the sum of the first replenishment quantities of the target articles of all the sub-warehouses in the at least two sub-warehouses is larger than the inventory quantity of the total warehouse, wherein the prompt information is used for prompting a user to modify the first replenishment quantities of the target articles of the sub-warehouses in the at least two sub-warehouses;
the receiving unit is used for receiving the second replenishment quantity of the target items of each of the at least two sub-warehouses after the modification of the user;
and the second distribution unit is used for distributing the stock for each warehouse of the at least two warehouses according to the second replenishment quantity of the target articles of each warehouse of the at least two warehouses respectively.
12. The apparatus of claim 11, further comprising:
the judging module is used for judging whether the second replenishment quantity of the target articles in each of the at least two sub-warehouses is reasonable or not according to the first replenishment quantity of the target articles in each of the at least two sub-warehouses after receiving the second replenishment quantity of the target articles in each of the at least two sub-warehouses modified by the user;
the second allocating unit is specifically configured to:
and under the condition that the second replenishment quantity of the target articles of each of the at least two sub-warehouses is determined to be reasonable, allocating the stock for each of the at least two sub-warehouses according to the second replenishment quantity of the target articles of each of the at least two sub-warehouses.
13. An electronic device comprising a processor, a memory and a computer program stored on the memory and executable on the processor, the computer program, when executed by the processor, implementing the steps of the inventory allocation method according to any one of claims 1 to 6.
14. A computer-readable storage medium, characterized in that a computer program is stored thereon, which computer program, when being executed by a processor, carries out the steps of the inventory allocation method according to any one of claims 1 to 6.
CN201810387269.8A 2018-04-26 2018-04-26 Inventory distribution method and device Active CN108596544B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810387269.8A CN108596544B (en) 2018-04-26 2018-04-26 Inventory distribution method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810387269.8A CN108596544B (en) 2018-04-26 2018-04-26 Inventory distribution method and device

Publications (2)

Publication Number Publication Date
CN108596544A CN108596544A (en) 2018-09-28
CN108596544B true CN108596544B (en) 2020-06-16

Family

ID=63610349

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810387269.8A Active CN108596544B (en) 2018-04-26 2018-04-26 Inventory distribution method and device

Country Status (1)

Country Link
CN (1) CN108596544B (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109697591A (en) * 2018-12-17 2019-04-30 北京三快在线科技有限公司 Method for inventory control, device, storage medium and server
CN113657823A (en) * 2021-07-20 2021-11-16 中国邮电器材集团有限公司 Automatic goods distribution method and device
CN113657822A (en) * 2021-07-20 2021-11-16 中国邮电器材集团有限公司 Method and device for distributing commodity quota
CN113822543A (en) * 2021-08-31 2021-12-21 北京沃东天骏信息技术有限公司 Resource quantity determination method and device, electronic equipment and storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102682374A (en) * 2012-05-22 2012-09-19 苏州奇可思信息科技有限公司 Product stock management system
CN104820913A (en) * 2015-04-24 2015-08-05 北京京东尚科信息技术有限公司 Replenishment method and apparatus
CN106529859A (en) * 2016-10-20 2017-03-22 浙江中烟工业有限责任公司 Control device of dynamic safety stock, and regulation and control method of safety stock

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20170140406A1 (en) * 2015-11-16 2017-05-18 Oracle International Corporation System and method for providing a multi-channel inventory allocation approach for retailers
CN107784463A (en) * 2016-08-26 2018-03-09 阿里巴巴集团控股有限公司 Inventory information processing method, system and equipment

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102682374A (en) * 2012-05-22 2012-09-19 苏州奇可思信息科技有限公司 Product stock management system
CN104820913A (en) * 2015-04-24 2015-08-05 北京京东尚科信息技术有限公司 Replenishment method and apparatus
CN106529859A (en) * 2016-10-20 2017-03-22 浙江中烟工业有限责任公司 Control device of dynamic safety stock, and regulation and control method of safety stock

Also Published As

Publication number Publication date
CN108596544A (en) 2018-09-28

Similar Documents

Publication Publication Date Title
CN108596544B (en) Inventory distribution method and device
JP6720331B2 (en) Distribution resource scheduling method, device and system
CN107963385B (en) Method and system for processing goods in logistics storage field
CN112001681B (en) Warehouse management method, device, platform and computer readable storage medium
Hajiaghaei-Keshteli et al. Determination of the economical policy of a three-echelon inventory system with (R, Q) ordering policy and information sharing
CN110633820B (en) Warehouse address recommendation method and device and computer readable storage medium
CN109426896A (en) A kind of method and device of determining region transport power state, electronic equipment
WO2022199383A1 (en) Article replenishment method and device, and storage medium
CN111047264B (en) Logistics task distribution method and device
CN110363476A (en) Warehousing allocation processing method and device
CN113762885B (en) Method, apparatus, device, storage medium and program product for determining replenishment quantity
CN111242524A (en) Method, system, equipment and storage medium for determining replenishment quantity of single article
CN108446777B (en) Storage space management method and related equipment
CN116433154A (en) Warehouse replenishment method and device, electronic equipment and storage medium
Kapalka et al. Retail inventory control with lost sales, service constraints, and fractional lead times
CN112712222A (en) Article scheduling method and system
Berling et al. Lead-time investigation and estimation in divergent supply chains
CN113743862A (en) Product target inventory determination method and system based on product classification
CN113450047A (en) Processing method and device for electronic replenishment equipment and electronic replenishment equipment
CN114358874A (en) Replenishment method and device and electronic equipment
CN115034709A (en) Inventory management method and device
CN115713200A (en) Method and device for processing inventory allocation, order processing and scheduling data
US20140136358A1 (en) Supplier quantity selection
CN114386908A (en) Transport capacity scheduling method and device, storage medium and equipment
CN108399117A (en) A kind of processor occupancy display methods and device

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
TR01 Transfer of patent right

Effective date of registration: 20211122

Address after: Room 103, building 1, yard 4, Hengxing Road, Gaoliying Town, Shunyi District, Beijing

Patentee after: Beijing Rockwell Technology Co.,Ltd.

Address before: Room 801, 8 / F, building 3, No.10 courtyard, Wangjing street, Chaoyang District, Beijing 100102

Patentee before: BEIJING CHJ AUTOMOTIVE TECHNOLOGY Co.,Ltd.

TR01 Transfer of patent right