CN116433154A - Warehouse replenishment method and device, electronic equipment and storage medium - Google Patents
Warehouse replenishment method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN116433154A CN116433154A CN202310417640.1A CN202310417640A CN116433154A CN 116433154 A CN116433154 A CN 116433154A CN 202310417640 A CN202310417640 A CN 202310417640A CN 116433154 A CN116433154 A CN 116433154A
- Authority
- CN
- China
- Prior art keywords
- consumption
- replenishment
- target
- warehouse
- determining
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 39
- 238000012384 transportation and delivery Methods 0.000 claims abstract description 35
- 238000004364 calculation method Methods 0.000 claims description 42
- 238000004590 computer program Methods 0.000 claims description 7
- 238000013439 planning Methods 0.000 claims description 4
- 230000001502 supplementing effect Effects 0.000 abstract description 4
- 238000007726 management method Methods 0.000 abstract description 2
- 239000013589 supplement Substances 0.000 abstract 1
- 230000002354 daily effect Effects 0.000 description 52
- 238000010586 diagram Methods 0.000 description 8
- 238000004891 communication Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 6
- 230000003203 everyday effect Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000001419 dependent effect Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002441 reversible effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06312—Adjustment or analysis of established resource schedule, e.g. resource or task levelling, or dynamic rescheduling
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
Abstract
The embodiment of the invention provides a warehouse goods supplementing method, a warehouse goods supplementing device, electronic equipment and a storage medium, which relate to the technical field of warehouse management, wherein the method comprises the following steps: the method comprises the steps of obtaining replenishment plan information and warehouse status information, wherein the replenishment plan information comprises an order date, a delivery time length, an order period and daily arrival quantity, and the warehouse status information comprises initial inventory, historical consumption data, additional replenishment numbers and article display numbers. And determining a replenishment coverage period according to the order date, the delivery time and the order period, wherein the replenishment coverage period is the time interval of the goods reaching the warehouse after two continuous orders. And determining a target consumption according to the goods display number, the replenishment coverage period, the historical consumption data and the additional replenishment number, wherein the target consumption is the total number of the goods consumed in the replenishment coverage period. The restocking demand is determined based on the target consumption, daily arrival, initial inventory, and historical consumption data. The invention can more accurately supplement various cargoes in the warehouse.
Description
Technical Field
The invention relates to the technical field of warehouse management, in particular to a warehouse replenishment method, a warehouse replenishment device, electronic equipment and a storage medium.
Background
A large retailer typically has tens of warehouses, and a vast number of items need to be restocked daily. For this reason, retailers need to hire tens of restocking staff for restocking, and the labor cost is extremely high. Meanwhile, factors required for replenishment are very large, such as historical shipment volume of warehouse, current inventory condition, display information of warehouse shelves, supplier information, delivery cycle, etc. How to quickly, inexpensively and accurately calculate the restocking volume of each commodity is a problem for each merchant with so many commodities per day and with so many pieces of information that each commodity needs to be consulted.
Disclosure of Invention
The object of the invention includes, for example, providing a warehouse restocking method, a warehouse restocking device, an electronic device and a storage medium, which can at least partially solve the technical problems.
Embodiments of the invention may be implemented as follows:
in a first aspect, an embodiment of the present invention provides a method for restocking a warehouse, where the method includes:
acquiring replenishment plan information and warehouse status information, wherein the replenishment plan information comprises an order date, a delivery time, an order cycle and daily arrival quantity, and the warehouse status information comprises initial inventory, historical consumption data, additional replenishment numbers and goods display numbers;
determining a replenishment coverage period according to the order date, the delivery time length and the order period, wherein the replenishment coverage period is a time interval for an article to arrive at a warehouse after two continuous orders;
determining a target consumption amount according to the goods display number, the replenishment coverage period, the historical consumption data and the additional replenishment number, wherein the target consumption amount is the number of goods which are consumed together in the replenishment coverage period;
and determining a replenishment demand based on the target consumption amount, the daily arrival amount, the initial inventory, and the historical consumption data.
Optionally, the determining the replenishment coverage period according to the order date, the delivery time period and the order period includes:
determining an arrival date according to the order date and the delivery time;
determining a target order interval according to the order cycle, wherein the target order interval is the time length with the largest two continuous order date intervals in the order cycle;
the restocking coverage period is determined from the target order interval and the arrival date.
Optionally, the determining the target consumption according to the item display number, the restocking coverage period, the historical consumption data, and the additional restocking number includes:
determining a daily estimated consumption according to the historical consumption data;
determining a first target consumption according to the estimated daily consumption and the replenishment coverage period;
determining a second target consumption according to the estimated daily consumption and the additional replenishment quantity;
and determining the target consumption according to the first target consumption, the second target consumption and the goods display number.
Optionally, the determining the estimated daily consumption according to the historical consumption data includes:
acquiring the total consumption amount of goods in a warehouse in the past first preset time period;
predicting the total amount of goods consumption in a second preset duration in the future of the warehouse according to a prediction rule based on the total amount of goods consumption in the first preset duration;
and calculating an average value of the goods consumption in the second preset duration, and taking the average value of the goods consumption as the estimated daily consumption.
Optionally, the method further comprises:
acquiring the shelf life of the goods;
determining a target calculation rule of the target consumption according to the shelf life of the goods, wherein the target calculation rule comprises a first target calculation rule and a second target calculation rule;
if the shelf life of the goods is larger than a preset shelf life threshold value, determining the first target calculation rule as the target calculation rule;
and if the shelf life of the goods is smaller than or equal to the preset shelf life threshold value, determining the second target calculation rule as the target calculation rule.
Optionally, the method further comprises:
acquiring a commodity loss rate under the condition that the target calculation rule is determined to be the second target calculation rule;
and determining the target consumption according to the commodity consumption rate, the first target consumption, the second target consumption and the commodity display number based on the second target calculation rule.
Optionally, the determining the restocking demand based on the target consumption, the daily arrival amount, the initial inventory, and the historical consumption data includes:
determining a daily estimated consumption according to the historical consumption data;
determining a revised initial inventory of the warehouse at the arrival date according to the estimated daily consumption, the daily arrival amount and the initial inventory;
and calculating the difference between the target consumption and the corrected initial inventory to obtain the replenishment demand.
In a second aspect, an embodiment of the present invention provides a warehouse restocking device, including:
the system comprises a data acquisition unit, a storage unit and a storage unit, wherein the data acquisition unit is used for acquiring replenishment planning information and storage state information, the replenishment planning information comprises an order date, a delivery time, an order period and daily arrival quantity, and the storage state information comprises an initial inventory, historical consumption data, an additional replenishment number and an item display number;
the replenishment coverage period determining unit is used for determining replenishment coverage period according to the order date, the delivery time and the order period, wherein the replenishment coverage period is the time interval of the goods reaching the warehouse after two continuous orders;
a target consumption determining unit, configured to determine a target consumption according to the item display number, the replenishment coverage period, the historical consumption data, and the additional replenishment number, where the target consumption is a total number of items consumed in the replenishment coverage period;
and the replenishment demand determining unit is used for determining replenishment demand according to the target consumption amount, the daily arrival amount, the initial inventory and the historical consumption data.
In a third aspect, an embodiment of the present invention provides an electronic device, including: a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of any one of the methods described above when the program is executed.
In a fourth aspect, an embodiment of the present invention provides a computer readable storage medium, where the computer readable storage medium includes a computer program, where the computer program controls a server where the computer readable storage medium is located to implement the steps of any one of the methods described above.
The beneficial effects of the embodiment of the invention include, for example:
and finally determining the replenishment demand by acquiring a plurality of data in the replenishment plan information and the warehouse status information and considering the replenishment quantity of the goods from a plurality of aspects. The warehouse replenishment is more accurate and is closer to the actual situation of the user.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the embodiments will be briefly described below, it being understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and other related drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic diagram of an electronic device according to an embodiment of the present invention;
FIG. 2 is a flow chart of steps of a method for restocking a warehouse according to an embodiment of the present invention;
FIG. 3 is a flowchart of the substeps of determining a target consumption according to an embodiment of the present invention;
fig. 4 is a block diagram of a warehouse replenishment device according to an embodiment of the present invention.
Icon: 100-an electronic device; 110-memory; a 120-processor; 130-a communication module; 300-warehouse restocking device; 301-a data acquisition unit; 302-restocking coverage period determination unit; 303-a target consumption determination unit; 304-restocking demand determination unit.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments of the present invention. The components of the embodiments of the present invention generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations.
Thus, the following detailed description of the embodiments of the invention, as presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures.
Furthermore, the terms "first," "second," and the like, if any, are used merely for distinguishing between descriptions and not for indicating or implying a relative importance.
It should be noted that the features of the embodiments of the present invention may be combined with each other without conflict.
In the prior art, for replenishment of a warehouse, the following method is generally adopted:
1. setting a re-ordering point and a target stock for each goods by service personnel according to service experience, judging whether the stock on the same day is lower than the re-ordering point every day, if so, supplementing the stock, and supplementing the current stock to the target stock, namely: restocking quantity = target inventory-current inventory. Such an approach makes the restocking volume accuracy too much dependent on restocking personnel business level and it is also very difficult to set a reasonable "restocking point" and "target inventory" for each store. In addition, the method is too simple and rough in calculation mode of the replenishment quantity, and does not consider various factors such as commodity historical shipment conditions, warehouse display, delivery cycles and the like, so that the actual replenishment quantity can come in and go out from the actual demand quantity of the warehouse.
2. In one order cycle (for example, one week), an order number from monday to sunday is set for each article, and the corresponding allocation number is directly taken as the daily replenishment amount according to the day of the week. Such a method is applicable to only commodity replenishment of the daily class (shelf life less than one day) without considering inventory information at all. Moreover, the calculation of the replenishment quantity is completely dependent on manual configuration, and the automatic replenishment effect is basically not achieved.
Based on the above circumstances, embodiments of the present disclosure provide a method, an apparatus, an electronic device, and a storage medium for restocking a warehouse, which can effectively alleviate the above technical problems.
Please refer to fig. 1, which is a block schematic diagram of an electronic device 100 provided in the present application, where the electronic device 100 may be a device capable of performing data processing, and may implement the warehouse replenishment method provided in the embodiments of the present disclosure, so as to achieve an automatic replenishment effect. The electronic device 100 includes a memory 110, a processor 120, and a communication module 130. The memory 110, the processor 120, and the communication module 130. The components are directly or indirectly electrically connected with each other to realize data transmission or interaction. For example, the components may be electrically connected to each other via one or more communication buses or signal lines.
Wherein the memory 110 is used for storing programs or data. The Memory 110 may be, but is not limited to, random access Memory (Random Access Memory, RAM), read Only Memory (ROM), programmable Read Only Memory (Programmable Read-Only Memory, PROM), erasable Read Only Memory (Erasable Programmable Read-Only Memory, EPROM), electrically erasable Read Only Memory (Electric Erasable Programmable Read-Only Memory, EEPROM), etc.
The processor 120 is used to read/write data or programs stored in the memory and perform corresponding functions.
The communication module 130 is used for establishing communication connection between the server and other communication terminals through the network, and is used for receiving and transmitting data through the network.
It should be understood that the structure shown in fig. 1 is merely a schematic structural diagram of the electronic device 100, and that the electronic device 100 may further include more or fewer components than those shown in fig. 1, or have a different configuration than that shown in fig. 1, for example: the electronic device 100 may further include a data acquisition unit, a target consumption determination unit, and the like. The components shown in fig. 1 may be implemented in hardware, software, or a combination thereof. The electronic device 100 may be located in a computer or in some host computer in a warehouse system.
The embodiment of the invention provides a warehouse replenishment method, which comprises the following steps as shown in fig. 2:
step S110: and acquiring replenishment plan information and warehouse state information, wherein the replenishment plan information comprises an order date, a delivery time, an order cycle and daily arrival quantity, and the warehouse state information comprises initial inventory, historical consumption data, additional replenishment numbers and goods display numbers.
Step S120: and determining a replenishment coverage period according to the order date, the delivery time and the order period, wherein the replenishment coverage period is a time interval for an article to arrive at a warehouse after two continuous orders.
Step S130: and determining a target consumption according to the goods display number, the replenishment coverage period, the historical consumption data and the additional replenishment number, wherein the target consumption is the number of goods which are consumed together in the replenishment coverage period.
Step S140: and determining a replenishment demand based on the target consumption amount, the daily arrival amount, the initial inventory, and the historical consumption data.
When the warehouse needs to be restocked, firstly, the current various data are acquired, step S110 is executed, and the restocking plan information and the warehouse status information are acquired, wherein the restocking plan information comprises an order date, a delivery time, an order cycle and daily arrival amount, and the warehouse status information comprises an initial inventory, historical consumption data, an additional restocking number and a commodity display number.
The order date may be the date the order was submitted to the distributor, e.g., 2022, 9, 1; the delivery duration may be a delivery duration, for example, 2 days, for the dispenser to deliver the item to the customer's warehouse after it is ready; the order cycle may be a date of delivery of the dispenser to the user (or a date of delivery of the order form by the user) in each unit, for example, in units of week, monday, friday, and friday, the order cycle is monday, friday, and friday; the daily arrival amount may be the arrival amount of the last replenishment order received by the warehouse every day or the goods delivered by other orders after the delivery of the goods by the delivery manufacturer is started, for example, the arrival amount of the goods received by 2022 at 9 month 1 day is 5, the arrival amount of the goods received by 2022 at 9 month 2 day is 2, and then the daily arrival amounts are 5 and 2 respectively.
The initial inventory may be an inventory of the user's warehouse at the time of submitting the order; the historical consumption data may be a sales aggregate of the user over a period of time; the additional replenishment number can be a part of additional replenishment amount besides the daily sales and display quantity when the additional replenishment is carried out and the storage resource is redundant; the number of display items may be the number of items the user has placed on the shelves.
When restocking is required, the electronic device 100 acquires restocking plan information and warehouse status information, both of which include the above-described various data.
Step S120 is executed to determine a replenishment coverage period according to the order date, the delivery time period, and the order cycle, where the replenishment coverage period is a time interval for the article to reach the warehouse after two consecutive orders.
After the user submits the replenishment order to the distributor, the selling of the goods is not stopped, so that the selling of the goods in the user warehouse is continuously reduced, the goods in the warehouse are increased and consumed every day after the distributor sends the replenishment goods to the distributor, and the period is the sales time range covered by the current replenishment order, namely the replenishment coverage period.
The date the first lot was delivered to the customer's warehouse by the distributor may be determined based on the order date and the delivery time period. Taking the order cycle into account, the sales time range that can be covered after the order can be known. For example, the order date is 2022, 10, 11 (sunday), the delivery time is 3 days, and the order cycle is monday, sunday. Then the distributor sends the first lot to the customer warehouse on day 2022, 10 month 14 (friday), and the replenishment coverage period is 3 days, taking into account the order cycle.
Optionally, the determining the replenishment coverage period according to the order date, the delivery time period and the order period includes:
and determining the arrival date according to the order date and the delivery time.
And determining a target order interval according to the order cycle, wherein the target order interval is the time length with the largest two continuous order date intervals in the order cycle.
The restocking coverage period is determined from the target order interval and the arrival date.
The arrival date is the date the first lot of goods was delivered by the distributor, such as 2022, 10 month, 14 in the example above. To simplify the calculation scheme, a target order interval, i.e., the duration of the maximum of two consecutive order date intervals within an order cycle, may be set. A replenishment coverage period is then determined based on the target order interval and the arrival date.
For example, the order cycle is weekly, the target order interval is Max ((1+7) -1) =7, and the arrival date is 2022, 10 months, 14 days. The restocking coverage period is the period of time between day 14 of 10 of 2022 and day 21 of 10 of 2022.
After the replenishment coverage period is obtained, step S130 is executed to determine a target consumption amount according to the item display number, the replenishment coverage period, the historical consumption data, and the additional replenishment number, where the target consumption amount is a total number of items consumed in the replenishment coverage period.
In an alternative embodiment, future consumption of the good in the warehouse may be determined by historical consumption data, e.g., modeled from historical consumption data of the warehouse, and predicted by the model to obtain future daily consumption of the good in the warehouse. And then, the daily goods consumption in the warehouse is corresponding to the replenishment coverage period to obtain the total amount of the replenishment coverage future goods consumption, and the total amount of the replenishment coverage future goods consumption, the additional replenishment number and the goods display number are added to obtain the target consumption.
For example, the replenishment coverage period is 9 months 1 day to 9 months 4 days, future commodity consumption of the warehouse is predicted by the model, and commodity consumption of the warehouse from 9 months 1 day to 9 months 4 days is 5, 6, 2 and 1 respectively, the additional replenishment number is 4, and the commodity display number is 15. Then the target consumption is 5+6+2+1+4+15=33.
Optionally, the determining the target consumption according to the item display number, the replenishment coverage period, the historical consumption data and the additional replenishment number includes the following sub-steps as shown in fig. 3:
substep S310: and determining the estimated daily consumption according to the historical consumption data.
Sub-step S320: and determining a first target consumption according to the estimated daily consumption and the replenishment coverage period.
Sub-step S330: and determining a second target consumption according to the estimated daily consumption and the additional replenishment quantity.
Sub-step S340: and determining the target consumption according to the first target consumption, the second target consumption and the goods display number.
The daily commodity consumption in the warehouse in the future can be obtained by the above example. And then calculating the number of goods consumed in the replenishment coverage period as a first target consumption amount.
In an alternative real-time approach, the number of additional restocking may be determined by the number of days the user needs additional restocking and the estimated daily consumption. For example, the estimated daily consumption determined according to the historical consumption data is 5 and 1 respectively, the number of days for which additional replenishment is required is 2, and then the number of additional replenishment is 6, namely the second target consumption.
And adding the obtained first target consumption, second target consumption and the goods display number to obtain the target consumption.
For example, the replenishment coverage period is 3 days, the estimated daily consumption in the replenishment coverage period according to the model prediction is 4, 4 and 5, the number of additional replenishment is 2 days, the corresponding estimated daily consumption is 4 and 3, and the number of sales is 10. The first target consumption, 13, the second target consumption is 7, and the target consumption is 13+7+10=30.
Optionally, the determining the estimated daily consumption according to the historical consumption data includes:
and acquiring the total consumption amount of goods in the warehouse in the past first preset time period.
And predicting the total amount of the goods consumption in a second preset time period in the future of the warehouse according to a prediction rule based on the total amount of the goods consumption in the first preset time period.
And calculating an average value of the goods consumption in the second preset duration, and taking the average value of the goods consumption as the estimated daily consumption.
As another alternative, to simplify the calculation, determining the estimated daily consumption from the historical consumption data may be to obtain the total amount of the inventory item consumption over a period of time, average it, and then take the average as the estimated daily consumption.
For example, the first preset time period is 15 days, the second preset time period is 20 days, the historical consumption data is 60, and then the estimated daily consumption of the warehouse for 20 days in the future is predicted to be 4.
Optionally, the method further comprises:
and acquiring the shelf life of the goods. And determining a target calculation rule of the target consumption according to the shelf life of the goods, wherein the target calculation rule comprises a first target calculation rule and a second target calculation rule.
And if the shelf life of the goods is larger than a preset shelf life threshold value, determining the first target calculation rule as the target calculation rule.
And if the shelf life of the goods is smaller than or equal to the preset shelf life threshold value, determining the second target calculation rule as the target calculation rule.
In order to make the resulting restocking demand more accurate, the shelf life of the goods may be taken into account. Acquiring the shelf life of the goods preset by a user, judging whether the shelf life of the goods is longer than a certain time period (namely, a preset shelf life threshold value), and if so, calculating the target consumption by adopting a first target calculation rule; if not, a second target calculation rule is used to calculate the target consumption.
Generally, the shelf life of goods is classified into a short shelf life and a long shelf life, the long shelf life being more than 7 days and the short shelf life being 7 days or less, and thus, the preset shelf life threshold may be set to 7 days. Because the shelf life of the short-term goods is short, the expired goods can be counted when the target consumption is calculated, the quantity of the part of goods is added when the goods are restocked, and the calculation rule is used as a second target rule. For long-term security goods, the expired goods may not be considered in calculating the target consumption, and the calculation rule may be used as the first target rule.
Optionally, the method further comprises:
and acquiring the goods loss rate under the condition that the target calculation rule is determined to be the second target calculation rule.
And determining the target consumption according to the commodity consumption rate, the first target consumption, the second target consumption and the commodity display number based on the second target calculation rule.
As an alternative embodiment, in order to more easily obtain the expired item count, the user may pre-calculate the item wear rate (i.e., the expired item proportion) from historical item storage data. After the first target consumption and the second target consumption are obtained, adding the first target consumption and the second target consumption by adopting a second target calculation rule, and multiplying the sum of the first target consumption and the second target consumption by the goods loss rate to obtain the number of the goods which are outdated in the replenishment period. And then adding the first target consumption, the second target consumption, the goods display number and the goods number expired during the replenishment period to obtain the target consumption.
For example, if the shelf life of the goods is 3 days, the preset shelf life threshold is 7 days, the loss rate of the goods is 5%, the first target consumption is 20, the second target consumption is 5, and the display number of the goods is 2. Then, the target consumption is (20+5) ×5++20+5+2=28.25.
Step S140 is executed to determine a replenishment demand based on the target consumption amount, the daily arrival amount, the initial inventory, and the historical consumption data.
The target consumption amount is the amount of goods required to replenish the warehouse and maintain the next replenishment when the warehouse is empty, and the actual demand amount (i.e., replenishment demand amount) can be determined based on the target consumption amount, daily arrival amount, initial inventory, and historical consumption data together, taking into account the inventory originally present in the warehouse.
For example, a daily estimated consumption of the good is obtained from the historical consumption data, and an actual inventory of the warehouse when the first lot delivered by the dispenser arrives at the warehouse is calculated from the daily estimated consumption of the good, the initial inventory, and the daily arrival. And subtracting the actual stock of the warehouse when the first lot arrives at the warehouse from the target consumption to obtain the replenishment demand.
Optionally, the determining the restocking demand based on the target consumption, the daily arrival amount, the initial inventory, and the historical consumption data includes:
and determining the estimated daily consumption according to the historical consumption data.
And determining a corrected initial inventory of the warehouse at the arrival date according to the estimated daily consumption, the daily arrival quantity and the initial inventory.
And calculating the difference between the target consumption and the corrected initial inventory to obtain the replenishment demand.
According to any one of the modes provided in the embodiments of the present disclosure, the estimated daily consumption is determined according to the historical consumption data, and then the estimated daily consumption in the delivery time of the present delivery is subtracted from the initial inventory, i.e. the initial inventory is corrected. And subtracting the corrected initial inventory from the target consumption to obtain the replenishment demand.
For example, the estimated daily consumption is 5, the delivery time is 2 days, the daily arrival amount is 5 and 15, the initial stock is 20, and the target consumption is 45. Then, the initial inventory is revised to be 20+5+15-5-5=30 and the restocking demand is 45-30=15.
Based on the same inventive concept, as shown in fig. 4, an embodiment of the present invention provides a warehouse restocking device 300, where the warehouse restocking device 300 includes:
a data acquisition unit 301 configured to acquire replenishment plan information including an order date, a delivery time period, an order cycle, and a daily arrival amount, and warehouse status information including an initial inventory, historical consumption data, an additional replenishment number, and a number of goods display;
a replenishment coverage period determining unit 302, configured to determine a replenishment coverage period according to the order date, the delivery time period, and the order cycle, where the replenishment coverage period is a time interval for an article to reach a warehouse after two consecutive orders;
a target consumption determining unit 303, configured to determine a target consumption according to the item display number, the replenishment coverage period, the historical consumption data, and the additional replenishment number, where the target consumption is a total number of items consumed in the replenishment coverage period;
a restocking demand determining unit 304 for determining a restocking demand based on the target consumption, the daily arrival amount, the initial inventory, and the historical consumption data.
With respect to the warehouse restocking apparatus 300 described above, the specific functions of the various units have been described in detail in the embodiments of the warehouse restocking method provided in this specification, and will not be described in detail herein.
Based on the same inventive concept, the present description embodiments provide a computer-readable storage medium, on which a computer program is stored, which when executed by a processor, implements the steps of any one of the foregoing warehouse replenishment methods.
The invention at least comprises the following beneficial effects:
and finally determining the replenishment demand by acquiring a plurality of data in the replenishment plan information and the warehouse status information and considering the replenishment quantity of the goods from a plurality of aspects. The warehouse replenishment is more accurate and is closer to the actual situation of the user.
In the several embodiments provided in the present invention, it should be understood that the disclosed apparatus and method may be implemented in other manners. The apparatus embodiments described above are merely illustrative, for example, of the flowcharts and block diagrams in the figures that illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, functional modules in the embodiments of the present invention may be integrated together to form a single part, or each module may exist alone, or two or more modules may be integrated to form a single part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is merely illustrative of the present invention, and the present invention is not limited thereto, and any changes or substitutions easily contemplated by those skilled in the art within the scope of the present invention should be included in the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (10)
1. A warehouse restocking method, the method comprising:
acquiring replenishment plan information and warehouse status information, wherein the replenishment plan information comprises an order date, a delivery time, an order cycle and daily arrival quantity, and the warehouse status information comprises initial inventory, historical consumption data, additional replenishment numbers and goods display numbers;
determining a replenishment coverage period according to the order date, the delivery time length and the order period, wherein the replenishment coverage period is a time interval for an article to arrive at a warehouse after two continuous orders;
determining a target consumption amount according to the goods display number, the replenishment coverage period, the historical consumption data and the additional replenishment number, wherein the target consumption amount is the number of goods which are consumed together in the replenishment coverage period;
and determining a replenishment demand based on the target consumption amount, the daily arrival amount, the initial inventory, and the historical consumption data.
2. A warehouse restocking method as claimed in claim 1, wherein the determining a restocking coverage period from the order date, the delivery duration, the order period includes:
determining an arrival date according to the order date and the delivery time;
determining a target order interval according to the order cycle, wherein the target order interval is the time length with the largest two continuous order date intervals in the order cycle;
the restocking coverage period is determined from the target order interval and the arrival date.
3. The warehouse restocking method as claimed in claim 1, wherein the determining a target consumption based on the item display count, the restocking coverage period, the historical consumption data, and the additional restocking count includes:
determining a daily estimated consumption according to the historical consumption data;
determining a first target consumption according to the estimated daily consumption and the replenishment coverage period;
determining a second target consumption according to the estimated daily consumption and the additional replenishment quantity;
and determining the target consumption according to the first target consumption, the second target consumption and the goods display number.
4. A warehouse restocking method as claimed in claim 3, wherein the determining a daily estimated consumption from the historical consumption data includes:
acquiring the total consumption amount of goods in a warehouse in the past first preset time period;
predicting the total amount of goods consumption in a second preset duration in the future of the warehouse according to a prediction rule based on the total amount of goods consumption in the first preset duration;
and calculating an average value of the goods consumption in the second preset duration, and taking the average value of the goods consumption as the estimated daily consumption.
5. A warehouse restocking method as claimed in claim 3, wherein the method further comprises:
acquiring the shelf life of the goods;
determining a target calculation rule of the target consumption according to the shelf life of the goods, wherein the target calculation rule comprises a first target calculation rule and a second target calculation rule;
if the shelf life of the goods is larger than a preset shelf life threshold value, determining the first target calculation rule as the target calculation rule;
and if the shelf life of the goods is smaller than or equal to the preset shelf life threshold value, determining the second target calculation rule as the target calculation rule.
6. A warehouse restocking method as claimed in claim 5, wherein the method further comprises:
acquiring a commodity loss rate under the condition that the target calculation rule is determined to be the second target calculation rule;
and determining the target consumption according to the commodity consumption rate, the first target consumption, the second target consumption and the commodity display number based on the second target calculation rule.
7. A warehouse restocking method as claimed in claim 2, wherein the determining a restocking demand from the target consumption, the daily arrival, the initial inventory and the historical consumption data includes:
determining a daily estimated consumption according to the historical consumption data;
determining a revised initial inventory of the warehouse at the arrival date according to the estimated daily consumption, the daily arrival amount and the initial inventory;
and calculating the difference between the target consumption and the corrected initial inventory to obtain the replenishment demand.
8. A warehouse restocking device, characterized in that the warehouse restocking device comprises:
the system comprises a data acquisition unit, a storage unit and a storage unit, wherein the data acquisition unit is used for acquiring replenishment planning information and storage state information, the replenishment planning information comprises an order date, a delivery time, an order period and daily arrival quantity, and the storage state information comprises an initial inventory, historical consumption data, an additional replenishment number and an item display number;
the replenishment coverage period determining unit is used for determining replenishment coverage period according to the order date, the delivery time and the order period, wherein the replenishment coverage period is the time interval of the goods reaching the warehouse after two continuous orders;
a target consumption determining unit, configured to determine a target consumption according to the item display number, the replenishment coverage period, the historical consumption data, and the additional replenishment number, where the target consumption is a total number of items consumed in the replenishment coverage period;
and the replenishment demand determining unit is used for determining replenishment demand according to the target consumption amount, the daily arrival amount, the initial inventory and the historical consumption data.
9. An electronic device, comprising: memory, a processor and a computer program stored on the memory and executable on the processor, said processor implementing the steps of the method according to any one of claims 1 to 7 when said program is executed.
10. A computer readable storage medium, characterized in that the computer readable storage medium comprises a computer program which, when run, controls a server on which the computer readable storage medium resides to carry out the steps of the method according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310417640.1A CN116433154A (en) | 2023-04-14 | 2023-04-14 | Warehouse replenishment method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310417640.1A CN116433154A (en) | 2023-04-14 | 2023-04-14 | Warehouse replenishment method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116433154A true CN116433154A (en) | 2023-07-14 |
Family
ID=87090514
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310417640.1A Pending CN116433154A (en) | 2023-04-14 | 2023-04-14 | Warehouse replenishment method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116433154A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117291506A (en) * | 2023-11-24 | 2023-12-26 | 山东天振药业有限公司 | Raw material inventory data intelligent management system based on liquid veterinary drug production |
-
2023
- 2023-04-14 CN CN202310417640.1A patent/CN116433154A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117291506A (en) * | 2023-11-24 | 2023-12-26 | 山东天振药业有限公司 | Raw material inventory data intelligent management system based on liquid veterinary drug production |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10565549B2 (en) | System and method for managing retail products | |
| CN111340421A (en) | Purchasing method | |
| US6622056B1 (en) | Method and system for supply chain or supply network control | |
| US20110054982A1 (en) | Methods and systems for randomizing starting retail store inventory when determining distribution center and warehouse demand forecasts | |
| CN112001681B (en) | Warehouse management method, device, platform and computer readable storage medium | |
| US9990597B2 (en) | System and method for forecast driven replenishment of merchandise | |
| CA2976202A1 (en) | System and method for managing retail products | |
| CN116433154A (en) | Warehouse replenishment method and device, electronic equipment and storage medium | |
| CN109658010A (en) | The management method and device of food materials | |
| CN112053168A (en) | Material monitoring method and device, electronic equipment and storage medium | |
| CN113177763A (en) | Replenishment suggestion generation method and system and computer readable storage medium | |
| CN113469591A (en) | Inventory replenishment control method and device, electronic equipment and storage medium | |
| CN109544058A (en) | A kind of inventory's method for early warning, electronic equipment and storage medium | |
| Goedhart et al. | Inventory rationing and replenishment for an omni-channel retailer | |
| CN114240473A (en) | Sku-based intelligent replenishment method and system | |
| US20040034580A1 (en) | Merchandise control system | |
| Eksler et al. | An EOQ model for multiple products with varying degrees of substitutability | |
| JP2000306015A (en) | Device and method for managing rental article | |
| CN110570154A (en) | retail enterprise replenishment method | |
| CN111047241A (en) | Inventory management method, device and computer readable storage medium | |
| CN115880020A (en) | Method, device and storage medium for acquiring real demand in out-of-stock state | |
| CN113743862A (en) | Product target inventory determination method and system based on product classification | |
| Tai et al. | Recent advances on Markovian models for inventory research | |
| JP2005089060A (en) | Device and method for determining physical distribution base, and its program | |
| JP2002169860A (en) | Method and device for making production plan |
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 |