CN111325490A - Replenishment method and device - Google Patents
Replenishment method and device Download PDFInfo
- Publication number
- CN111325490A CN111325490A CN201811531470.5A CN201811531470A CN111325490A CN 111325490 A CN111325490 A CN 111325490A CN 201811531470 A CN201811531470 A CN 201811531470A CN 111325490 A CN111325490 A CN 111325490A
- Authority
- CN
- China
- Prior art keywords
- sku
- replenishment
- sales
- cost
- stock
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 21
- 230000001186 cumulative effect Effects 0.000 claims abstract description 25
- 238000004364 calculation method Methods 0.000 claims description 12
- 238000013480 data collection Methods 0.000 claims description 3
- 230000010354 integration Effects 0.000 claims description 3
- 230000006870 function Effects 0.000 description 23
- 230000006399 behavior Effects 0.000 description 4
- 230000003068 static effect Effects 0.000 description 2
- 238000009825 accumulation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000005315 distribution function Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 238000012417 linear regression Methods 0.000 description 1
- 238000010801 machine learning Methods 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 230000001960 triggered 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
Landscapes
- Business, Economics & Management (AREA)
- Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a replenishment method and a replenishment device, wherein the replenishment method comprises the following steps: collecting inventory data, historical sales and replenishment period of SKUs; giving different weights to historical sales according to the time sequence, and calculating a sales cumulative density function of the SKU in the next replenishment period; according to the accumulated density function of the sales volume of the SKU in the next replenishment period, calculating the corresponding holding volume of the SKU when the expected value of the inventory cost is minimum based on a preset constraint condition; and comparing the stock data of the SKU with the holding quantity to obtain the replenishment quantity, so that the stock data of the SKU is not less than the holding quantity, and the shortage cost and the inventory cost of the SKU are comprehensively considered, so that the holding quantity calculated by a model is optimal on the total cost of the warehouse, and the inventory management can be scientifically and systematically performed on the warehouse.
Description
Technical Field
The invention relates to the field of inventory management, in particular to a replenishment method and device.
Background
With the rise of online shopping, the demand for perfecting the mechanism and technology of the corresponding logistics and supply chain is more and more urgent. The warehouse management is in a critical position of the supply chain, and the inventory management directly influences the commodity order satisfaction rate, the warehouse inventory management cost and the like.
For the determination of the replenishment point R in the prior art solution,
the static inventory (the holding capacity R) is simply specified according to the average value and the variance of the sales volume of the SKU history, and the sales volume of each SKU fluctuates greatly, so that the scheme cannot adapt to the variation trend of the sales volume, and the holding capacity R is prone to being inaccurate to obtain;
and secondly, predicting the sales volume of the sku by using a machine learning method so as to determine a lower replenishment limit (a holding volume R), wherein the sales volume of the sku is comprehensively influenced by various complex factors, so that the prediction error is large, and the lower replenishment limit of the scheme only considers the stock shortage cost (the temporary replenishment cost is paid because of the temporary replenishment behavior generated by the stock shortage, and the temporary replenishment cost is generally greater than the conventional replenishment cost) and does not consider the inventory cost.
The shortage cost of the Shunfeng warehouse can not be directly measured by the market price of sku, which represents the labor work cost of temporary replenishment after shortage, so the shortage cost considered by the replenishment model is difficult to estimate.
The following technical problems exist in the estimation of the labor work cost:
1. the lower limit of replenishment cannot capture the change of sku sales in real time, so that the order satisfaction rate is low on certain days;
2. the lower limit of the replenishment model cannot comprehensively consider inventory cost and backorder cost;
3. the warehouse stock shortage cost considered by the replenishment model is difficult to estimate, the stock shortage cost cannot be directly measured by the market price or the cost of the sku, and the manual cost of temporary replenishment can be selected to replace the stock shortage cost, however, two difficulties exist in estimating the value: the sku with temporary replenishment is few on the one hand, the temporary replenishment manpower of all skus in the warehouse cannot be directly calculated, and on the other hand, the temporary replenishment manpower is difficult to convert into a specific money cost.
Disclosure of Invention
In order to solve the above technical problems, an object of the present invention is to provide a replenishment method and apparatus.
According to an aspect of the present invention, there is provided a restocking method including:
collecting inventory data, historical sales and replenishment period of SKUs;
giving different weights to historical sales according to the time sequence, and calculating a sales cumulative density function of the SKU in the next replenishment period;
according to the accumulated density function of the sales volume of the SKU in the next replenishment period, calculating the corresponding holding volume R of the SKU when the expected value of the inventory cost is minimum based on a preset constraint condition;
and comparing the stock data of the SKU with the holding quantity R to obtain the replenishment quantity, so that the stock data of the SKU is not less than the holding quantity R.
Further, calculating a cumulative density function of sales of the SKU in the next replenishment cycle by giving different weights to historical sales according to the time sequence, comprising:
giving a weight from small to large to the historical sales data of the SKU based on the time sequence;
accumulating and removing the weight of the historical sales, and integrating into a sales distribution queue according to the sales sequence: r1, r2 … … rn;
calculating the probability of each sales occurrence to form a numerical distribution data set, and obtaining the cumulative density function of historical sales by the weighted sum of each sales and its probability product
Further, according to the accumulated density function of the sales volume of the SKU in the next replenishment period, calculating the corresponding holding volume R of the SKU when the expected value of the inventory cost is minimum based on a preset constraint condition, and including:
calculating the unit stock shortage cost k of the SKU and collecting the unit inventory cost h of the SKU;
according to the unit gapCalculating the stock cost and the unit stock cost of each historical sales volume of the SKU in the cumulative density function respectivelyThe following stock cost expectation values: TC (r1), TC (r2) … …, TC (rn), and the condition that the preset constraint condition TC (rn-1) is more than or equal to K/K + h is more than or equal to TC (rn) is met;
the output rn is the hold R for the SKU.
Further, calculating the unit stock out cost of the SKU comprises:
randomly selecting the maximum temporary replenishment quantity in the SKU unit time from the inventory data and the historical sales quantity data;
fitting a linear model regression model according to the SKU maximum temporary replenishment quantity, the volume, the weight and the category, and estimating the maximum temporary replenishment quantity in other SKUs in unit time;
and calculating the unit stock shortage cost of the SKU based on the human cost according to the maximum temporary replenishment quantity of the SKU in unit time.
Further, the inventory cost expected value is an inventory cost or stock out cost of the SKU;
and/or
The replenishment cycle comprises at least one of: day, n days, week, month, year;
and/or
The inventory data includes at least one of: stock quantity, volume, weight, stock space volume and temporary replenishment data of the SKU.
According to another aspect of the present invention, there is provided a restocking apparatus including:
the data acquisition module is configured for acquiring stock data, historical sales and replenishment periods of SKUs;
the sales forecasting module is configured for giving different weights to historical sales according to the time sequence and calculating a sales cumulative density function of the SKU in the next replenishment period;
the calculation module is configured for calculating the corresponding cargo holding quantity R of the SKU when the expected value of the inventory cost is minimum according to the accumulated density function of the sales quantity of the SKU in the next replenishment period based on a preset constraint condition;
and comparing the stock data of the SKU with the holding quantity R to obtain the replenishment quantity, so that the stock data of the SKU is not less than the holding quantity R.
Further, the calculation module comprises:
the weight distribution unit is configured for giving weights from small to large to the historical sales data of the SKU based on the time sequence;
and the integration unit is configured for accumulating and de-duplicating the historical sales and integrating the historical sales into a sales distribution queue according to the sales sequence: r1, r2 … … rn;
the first calculation unit: calculating the probability of each sales occurrence to form a numerical distribution data set, and calculating the weighted sum of each sales and its probability product to obtain the cumulative density function of historical sales
Further, a data collection module configured to collect a unit inventory cost for the SKU;
the calculation module further comprises:
the second calculation unit is used for calculating and calculating the unit stock shortage cost k of the SKU and collecting the unit stock inventory cost h of the SKU;
calculating the cumulative density function of each historical sales volume of the SKU according to the unit stock shortage cost and the unit stock inventory costThe following stock cost expectation values: TC (r1), TC (r2) … …, TC (rn), and the condition that the preset constraint condition TC (rn-1) is more than or equal to K/K + h is more than or equal to TC (rn) is met;
the output rn is the hold R for the SKU.
Further, calculating the unit stock out cost of the SKU comprises:
randomly selecting the maximum temporary replenishment quantity in the unit time of a SKU from the inventory data and the historical sales data;
fitting a linear model regression model according to the SKU maximum temporary replenishment quantity, the volume, the weight and the category, and estimating the maximum temporary replenishment quantity in other SKUs in unit time;
according to the maximum temporary replenishment quantity in the SKU unit time,
calculating a unit out-of-stock cost for the SKU based on human cost.
Further, the inventory cost expected value is an inventory cost or stock out cost of the SKU;
and/or
The replenishment cycle comprises at least one of: day, n days, week, month, year;
and/or
The inventory data includes at least one of: stock quantity, volume, weight, stock space volume and temporary replenishment data of the SKU.
According to another aspect of the invention, there is provided an apparatus comprising
One or more processors;
a memory for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method of any of the above.
According to another aspect of the invention, there is provided a computer readable storage medium storing a computer program which, when executed by a processor, implements a method as defined in any one of the above.
Compared with the prior art, the invention has the following beneficial effects:
1. according to the replenishment method disclosed by the invention, the corresponding holding quantity R of the SKU when the expected value of the inventory cost is minimum is calculated based on the preset constraint condition, and the stock cost comprehensively considers the stock shortage cost and the inventory cost of SKU, so that the holding quantity R calculated by a model is optimal on the total cost of a warehouse, and the inventory management can be scientifically and systematically carried out on the warehouse.
2. According to the replenishment device disclosed by the invention, the sales forecasting module gives different weights to data points according to the sales date, so that the holding quantity R can capture the change trend of the sales, and the inventory management can be scientifically and systematically carried out on the warehouse.
Drawings
FIG. 1 is a flow chart of the present invention.
Detailed Description
In order to better understand the technical scheme of the invention, the invention is further explained by combining the specific embodiment and the attached drawings of the specification.
Example 1:
the replenishment device of this embodiment includes:
a data collection module configured to collect stock data, historical sales, replenishment cycles, and unit inventory costs for SKUs; the inventory data includes at least one of: stock quantity, volume, weight, stock space volume and temporary replenishment data of the SKU.
The sales forecasting module is configured for giving different weights to historical sales according to the time sequence and calculating a sales cumulative density function of the SKU in the next replenishment period; the replenishment cycle comprises at least one of: day, n days, week, month, year. Specifically, the sales prediction module comprises:
the frequency allocation unit is configured to assign different weights to the historical sales data of the SKU based on time sequence;
the weight distribution unit is configured for giving weights from small to large to the historical sales data of the SKU based on the time sequence;
and the integration unit is configured for accumulating and de-duplicating the historical sales and integrating the historical sales into a sales distribution queue according to the sales sequence: r1, r2 … … rn;
the first calculation unit: calculating the probability of each sales occurrence to form a numerical distribution data set, and calculating the weighted sum of each sales and its probability product to obtain the cumulative density function of historical sales
The second calculation unit is used for calculating and calculating the unit stock shortage cost k of the SKU and collecting the unit stock inventory cost h of the SKU;
calculating the cumulative density function of each historical sales volume of the SKU according to the unit stock shortage cost and the unit stock inventory costThe following stock cost expectation values: TC (r1), TC (r2) … …, TC (rn), and the condition that the preset constraint condition TC (rn-1) is more than or equal to K/K + h is more than or equal to TC (rn) is met;
the output rn is the hold R for the SKU.
Further, calculating the unit stock out cost of the SKU comprises: randomly selecting the maximum temporary replenishment quantity in the unit time of a SKU from the inventory data and the historical sales data;
fitting a linear model regression model according to the SKU maximum temporary replenishment quantity, the volume, the weight and the category, and estimating the maximum temporary replenishment quantity in other SKUs in unit time;
according to the maximum temporary replenishment quantity in the SKU unit time,
calculating a unit out-of-stock cost for the SKU based on human cost.
The replenishment method corresponding to the replenishment device in the embodiment comprises the following steps:
s1: collecting inventory data, historical sales and replenishment cycles for SKUs, the inventory data including at least one of: stock quantity, volume, weight, stock space volume and temporary replenishment data of the SKU; the replenishment cycle is as follows: days, n days, weeks, months and years, and the replenishment period is the time period from one replenishment to the next replenishment.
S2: giving different weights to historical sales according to the time sequence, and calculating a cumulative density function of sales of the SKU in the next replenishment period, wherein the cumulative density function specifically comprises the following steps:
s2-1: giving weights from small to large to historical sales data of the SKU based on time sequence, and in order to consider real-time performance of sales change, the more recent sales weight is larger, and through discretization processing of a cumulative distribution function of the historical sales data, errors caused by inaccurate distribution fitting of the historical data are avoided, so that the solution of the child-reporting model is more accurate;
s2-2: accumulating and removing the weight of the historical sales, and integrating into a sales distribution queue according to the sales sequence: r1, r2 … … rn;
s2-3: calculating the probability of each sales occurrence to form a numerical distribution data set, and obtaining the cumulative density function of historical sales by the weighted sum of each sales and its probability product
S3: calculating the corresponding inventory quantity R of the SKU when the expected value of the inventory cost is minimum according to the accumulated density function of the sales quantity of the SKU in the next replenishment period based on preset constraint conditions, wherein the method comprises the following steps:
s3-1: calculating the unit stock shortage cost k of the SKU and collecting the unit inventory cost h of the SKU; calculating a unit out-of-stock cost k for the SKU, comprising:
s3-1-1: randomly selecting the maximum temporary replenishment quantity in the unit time of a SKU from the inventory data and the historical sales data;
s3-1-2: fitting a linear model regression model according to the SKU maximum temporary replenishment quantity, the volume, the weight and the category to estimate the maximum temporary replenishment quantity in other SKU unit time,
s3-1-3: calculating the unit stock shortage cost of the SKU based on the human cost according to the maximum temporary replenishment quantity of the SKU in unit time;
s3-2: calculating the cumulative density function of each historical sales volume of the SKU according to the unit stock shortage cost and the unit stock inventory costThe following stock cost expectation values: TC (r1), TC (r2) … …, TC (rn), and the condition that the preset constraint condition TC (rn-1) is more than or equal to K/K + h is more than or equal to TC (rn) is met;
the output rn is the hold R for the SKU.
And comparing the stock data of the SKU with the holding quantity R to obtain the replenishment quantity, so that the stock data of the SKU is not less than the holding quantity R.
The inventory R is calculated for all SKUs in the warehouse in turn, so that the overall replenishment cost of the warehouse is minimized.
The replenishment method is further described by way of example below:
step 1: data acquisition: collecting inventory data and historical sales data (sales data in a certain time, in this embodiment, sales data of nearly 60 days) of all SKUs in the warehouse, wherein the replenishment cycle is day;
the cost per unit of inventory for the SKU is obtained from the rate table for each SKU by storing information with the warehouse (which may also be obtained by communicating with warehouse personnel).
Step 2: sales data processing
Discretizing the probability density distribution of the historical sales, and integrating the probability density distribution into a sales distribution queue according to the sales change real-time property and the sales sequence (from small to large): r1, r2 … … rn;
weighting discrete sales distribution, wherein the sales weight is inversely proportional to the time sequence, the sales weight of the more recent sales is larger, the sales weight of the latest day is 60, the sales weight of the farthest day is 1, the replenishment period is day, the probability p (rn) of each sales occurrence is calculated, and a numerical distribution data set { r 1: count 1; r 2: count 2; … …. rn: countn; }
And 3, step 3: calculating out the cost of goods shortage
When an order of a sku is out of stock, a temporary replenishment behavior is triggered, namely after a certain time, warehouse staff can acquire the sku from a storage area and replenish the sku to a picking area, and due to the fact that the out-of-stock cost cannot be directly measured by the market price or the cost of the sku in the scene, the manual cost of temporary replenishment is selected for replacing the sku, and the specific processing method is as follows:
(1) screening out the SKU temporary replenishment behavior from the inventory data, and selecting a SKU (recorded as SKU)i) And (5) temporary replenishment with the largest replenishment quantity.
(2) Fitting linear regression model
Suppose QiThe SKUiAmount of temporary restocking
Fitting Linear model regression model Qi=a1*Vi+a2*Wi+a3*Typei
Wherein, ViThe SKUiVolume, WiThe SKUiWeight, TypeiThe SKUiA category.
(3) Predicting Q of all skus in warehouse by using linear model regression modeli(default a for each SKU1、a2、a3Same), according to Q in said SKU unit of timeiCalculating the unit stock out cost of the SKU based on human cost, and estimating Q according to the modeliAccording to the reciprocal ratios, if the replenishment quantity of the replenishment staff to SKU1 is 8 and the replenishment quantity of SKU2 is 2 within one day, the replenishment cost of SKU1 is 1/4 of SKU2, the emergency replenishment cost of SKU1 and SKU2 can be finally obtained according to the wages of the replenishment staff in one day, and the emergency replenishment cost of all SKUs, namely the final stock shortage cost k of each SKU, can be obtained by analogy in turn. I.e. Q, under the condition that the working capacity of the replenishment personnel is constantiThe higher the temporary restocking cost, the lower the temporary restocking cost representing 1 such sku per restocking. In specific application, the labor cost can be analyzed from the wages of the replenishment staff in one day, the unit stock shortage cost k of sku1 and sku2 can be obtained according to the one-day replenishment capacity of the replenishment staff, and the unit stock shortage cost k of all skus can be obtained by analogy.
And 3, step 3: calculating the inventory R of said SKU
Assuming r is the expected sales volume on the day, taking the sales volume distribution queue from the SKU; and R is the today holding quantity R, namely the optimal replenishment point.
Should stock be prepared today, i.e. the best replenishment point
k is unit cost of goods shortage
h is unit inventory cost
If the stock quantity of the SKU exceeds the expected sales volume interval (r)<R), product occupancy into the warehouse results in inventory costs:
if the stock quantity of the SKU is smaller than the expected sales volume interval (R is larger than R), temporary replenishment needs to be carried out, and the stock cost is generated:
in summary, the expected inventory cost TC (R) for a replenishment cycle is:
the objective function is Min (TC (R)), and the cumulative density function of each historical sales volume of the SKU is calculated according to the unit stock shortage cost and the unit stock costThe following stock cost expectation values: TC (r1), TC (r2) … … TC (rn), which satisfies the following three constraints: K/K + h is more than or equal to TC (rn-1) and less than or equal to TC (rn); the output rn is the hold R for the SKU.
And comparing the stock data of the SKU with the holding quantity R to obtain the replenishment quantity, so that the stock data of the SKU is not less than the holding quantity R.
The inventory R is calculated for all SKUs in the warehouse in turn, so that the overall replenishment cost of the warehouse is minimized.
According to the method, a probability accumulation function of the sales volume is changed, the sales volume interval changes along with time change, and change information considering the sales volume is captured through the weight of the historical sales volume value, so that the optimal goods holding quantity R of the SKU changes every day instead of the traditional static goods holding quantity R, and only the sum of the goods holding quantities R of the SKU is smaller than the upper limit of the inventory of a warehouse, and finally, the improved newsstand model is applied to a plurality of regular replenishment behaviors.
The device of the embodiment can scientifically and systematically perform inventory management on the warehouse by executing the replenishment method through the processor.
The readable storage medium of the embodiment stores the replenishment method implemented when being executed by the processor, so that the replenishment device is convenient to use and popularize.
The above description is only a preferred embodiment of the application and is illustrative of the principles of the technology employed. It will be appreciated by a person skilled in the art that the scope of the invention as referred to in the present application is not limited to the embodiments with a specific combination of the above-mentioned features, but also covers other embodiments with any combination of the above-mentioned features or their equivalents without departing from the inventive concept. For example, the features described above have similar functions to (but are not limited to) those disclosed in this application.
Claims (10)
1. A method of restocking, comprising:
collecting inventory data, historical sales and replenishment period of SKUs;
giving different weights to historical sales according to the time sequence, and calculating a sales cumulative density function of the SKU in the next replenishment period;
according to the accumulated density function of the sales volume of the SKU in the next replenishment period, calculating the corresponding holding volume R of the SKU when the expected value of the inventory cost is minimum based on a preset constraint condition;
and comparing the stock data of the SKU with the holding quantity R to obtain the replenishment quantity, so that the stock data of the SKU is not less than the holding quantity R.
2. The replenishment method of claim 1, wherein calculating the cumulative density function of sales of the SKU for the next replenishment cycle based on different weights assigned to historical sales in chronological order comprises:
giving a weight from small to large to the historical sales data of the SKU based on the time sequence;
accumulating and removing the weight of the historical sales, and integrating into a sales distribution queue according to the sales sequence: r1, r2 … … rn;
3. The replenishment method according to claim 2, wherein calculating the holding quantity R of the SKU corresponding to the smallest expected value of the stock cost based on a preset constraint according to the accumulated density function of the sales quantity of the SKU in the next replenishment period comprises:
calculating the unit stock shortage cost k of the SKU and collecting the unit inventory cost h of the SKU;
calculating the cumulative density function of each historical sales volume of the SKU according to the unit stock shortage cost and the unit stock inventory costThe following stock cost expectation values: TC (r1), TC (r2) … …, TC (rn), and the condition that the preset constraint condition TC (rn-1) is more than or equal to k/k + h is more than or equal to TC (rn) is met;
the output rn is the hold R for the SKU.
4. A method of restocking according to claim 3, wherein calculating the unit out-of-stock cost for the SKU comprises:
randomly selecting the maximum temporary replenishment quantity in the SKU unit time from the inventory data and the historical sales quantity data;
fitting a linear model regression model according to the SKU maximum temporary replenishment quantity, the volume, the weight and the category, and estimating the maximum temporary replenishment quantity in other SKUs in unit time;
and calculating the unit stock shortage cost of the SKU based on the human cost according to the maximum temporary replenishment quantity of the SKU in unit time.
5. A restocking method according to claims 1 to 4,
the inventory cost expected value is an inventory cost or stock out cost for the SKU;
and/or
The replenishment cycle comprises at least one of: day, n days, week, month, year;
and/or
The inventory data includes at least one of: stock quantity, volume, weight, stock space volume and temporary replenishment data of the SKU.
6. A replenishment device, comprising:
the data acquisition module is configured for acquiring stock data, historical sales and replenishment periods of SKUs;
the sales forecasting module is configured for giving different weights to historical sales according to the time sequence and calculating a sales cumulative density function of the SKU in the next replenishment period;
the calculation module is configured for calculating the corresponding cargo holding quantity R of the SKU when the expected value of the inventory cost is minimum according to the accumulated density function of the sales quantity of the SKU in the next replenishment period based on preset constraint conditions;
and comparing the stock data of the SKU with the holding quantity R to obtain the replenishment quantity, so that the stock data of the SKU is not less than the holding quantity R.
7. The replenishment device according to claim 6, wherein the calculation module comprises:
the weight distribution unit is configured for giving weights from small to large to the historical sales data of the SKU based on the time sequence;
and the integration unit is configured for accumulating and de-duplicating the historical sales and integrating the historical sales into a sales distribution queue according to the sales sequence: r1, r2 … … rn;
8. A restocking device according to claim 7,
a data collection module further configured to collect a unit inventory cost of the SKU;
the calculation module further comprises:
the second calculation unit is used for calculating and calculating the unit stock shortage cost k of the SKU and collecting the unit stock inventory cost h of the SKU;
calculating the cumulative density function of each historical sales volume of the SKU according to the unit stock shortage cost and the unit stock inventory costThe following stock cost expectation values: TC (r1), TC (r2) … …, TC (rn), and the condition that the preset constraint condition TC (rn-1) is more than or equal to k/k + h is more than or equal to TC (rn) is met;
the output rn is the hold R for the SKU.
9. The replenishment device according to claim 8, wherein calculating the unit backorder cost of the SKU comprises:
randomly selecting the maximum temporary replenishment quantity in the unit time of a SKU from the inventory data and the historical sales data;
fitting a linear model regression model according to the SKU maximum temporary replenishment quantity, the volume, the weight and the category, and estimating the maximum temporary replenishment quantity in other SKUs in unit time;
according to the maximum temporary replenishment quantity in the SKU unit time,
calculating a unit out-of-stock cost for the SKU based on human cost.
10. A replenishment device according to claims 6-9 wherein the inventory cost expected value is the cost of stock or stock out of stock of the SKU;
and/or
The replenishment cycle comprises at least one of: day, n days, week, month, year;
and/or
The inventory data includes at least one of: stock quantity, volume, weight, stock space volume and temporary replenishment data of the SKU.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811531470.5A CN111325490B (en) | 2018-12-14 | 2018-12-14 | Goods supplementing method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811531470.5A CN111325490B (en) | 2018-12-14 | 2018-12-14 | Goods supplementing method and device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN111325490A true CN111325490A (en) | 2020-06-23 |
CN111325490B CN111325490B (en) | 2024-04-16 |
Family
ID=71167262
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811531470.5A Active CN111325490B (en) | 2018-12-14 | 2018-12-14 | Goods supplementing method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111325490B (en) |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113128932A (en) * | 2021-04-16 | 2021-07-16 | 北京京东振世信息技术有限公司 | Warehouse stock processing method and device, storage medium and electronic equipment |
CN113592153A (en) * | 2021-07-07 | 2021-11-02 | 杉数科技(北京)有限公司 | Goods distribution method, device, medium and computer equipment |
CN113743733A (en) * | 2021-08-06 | 2021-12-03 | 杉数科技(北京)有限公司 | Replenishment method and system |
CN113887771A (en) * | 2020-07-02 | 2022-01-04 | 上海顺如丰来技术有限公司 | Service level optimization method and device, computer equipment and storage medium |
CN113887772A (en) * | 2020-07-02 | 2022-01-04 | 上海顺如丰来技术有限公司 | Order cycle optimization method, order cycle optimization device, computer equipment and storage medium |
CN113919764A (en) * | 2020-07-07 | 2022-01-11 | 上海顺如丰来技术有限公司 | Method and device for determining in-bin replenishment quantity, computer equipment and storage medium |
CN113935672A (en) * | 2020-07-13 | 2022-01-14 | 上海顺如丰来技术有限公司 | Automatic replenishment method and device, computer equipment and storage medium |
CN113947341A (en) * | 2020-07-17 | 2022-01-18 | 上海顺如丰来技术有限公司 | Supply chain replenishment method and device, computer equipment and storage medium |
CN114048931A (en) * | 2022-01-13 | 2022-02-15 | 北京京东振世信息技术有限公司 | Replenishment information generation method and device, electronic equipment and computer readable medium |
CN115630899A (en) * | 2022-11-01 | 2023-01-20 | 中国外运股份有限公司 | Multi-platform inventory optimization method and system |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104732287A (en) * | 2013-12-19 | 2015-06-24 | 广州市地下铁道总公司 | Stock control method based on optimum replenishment period of spare part |
CN106971249A (en) * | 2017-05-05 | 2017-07-21 | 北京挖玖电子商务有限公司 | A kind of Method for Sales Forecast and replenishing method |
CN107226311A (en) * | 2017-07-14 | 2017-10-03 | 李双玉 | The equipment that replenishes and transportation system |
CN108280538A (en) * | 2018-01-05 | 2018-07-13 | 广西师范学院 | Based on distributed logistics inventory's optimization method under cloud computing environment |
-
2018
- 2018-12-14 CN CN201811531470.5A patent/CN111325490B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104732287A (en) * | 2013-12-19 | 2015-06-24 | 广州市地下铁道总公司 | Stock control method based on optimum replenishment period of spare part |
CN106971249A (en) * | 2017-05-05 | 2017-07-21 | 北京挖玖电子商务有限公司 | A kind of Method for Sales Forecast and replenishing method |
CN107226311A (en) * | 2017-07-14 | 2017-10-03 | 李双玉 | The equipment that replenishes and transportation system |
CN108280538A (en) * | 2018-01-05 | 2018-07-13 | 广西师范学院 | Based on distributed logistics inventory's optimization method under cloud computing environment |
Non-Patent Citations (1)
Title |
---|
王东林: ""供应链环境下G公司成品空调的库存策略研究"", no. 1, pages 24 - 41 * |
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113887771A (en) * | 2020-07-02 | 2022-01-04 | 上海顺如丰来技术有限公司 | Service level optimization method and device, computer equipment and storage medium |
CN113887772A (en) * | 2020-07-02 | 2022-01-04 | 上海顺如丰来技术有限公司 | Order cycle optimization method, order cycle optimization device, computer equipment and storage medium |
CN113919764A (en) * | 2020-07-07 | 2022-01-11 | 上海顺如丰来技术有限公司 | Method and device for determining in-bin replenishment quantity, computer equipment and storage medium |
CN113935672A (en) * | 2020-07-13 | 2022-01-14 | 上海顺如丰来技术有限公司 | Automatic replenishment method and device, computer equipment and storage medium |
CN113947341A (en) * | 2020-07-17 | 2022-01-18 | 上海顺如丰来技术有限公司 | Supply chain replenishment method and device, computer equipment and storage medium |
CN113128932A (en) * | 2021-04-16 | 2021-07-16 | 北京京东振世信息技术有限公司 | Warehouse stock processing method and device, storage medium and electronic equipment |
CN113128932B (en) * | 2021-04-16 | 2024-04-16 | 北京京东振世信息技术有限公司 | Warehouse stock processing method and device, storage medium and electronic equipment |
CN113592153A (en) * | 2021-07-07 | 2021-11-02 | 杉数科技(北京)有限公司 | Goods distribution method, device, medium and computer equipment |
CN113592153B (en) * | 2021-07-07 | 2022-06-17 | 杉数科技(北京)有限公司 | Goods distribution method, device, medium and computer equipment |
CN113743733A (en) * | 2021-08-06 | 2021-12-03 | 杉数科技(北京)有限公司 | Replenishment method and system |
CN114048931A (en) * | 2022-01-13 | 2022-02-15 | 北京京东振世信息技术有限公司 | Replenishment information generation method and device, electronic equipment and computer readable medium |
CN115630899A (en) * | 2022-11-01 | 2023-01-20 | 中国外运股份有限公司 | Multi-platform inventory optimization method and system |
CN115630899B (en) * | 2022-11-01 | 2023-08-11 | 中国外运股份有限公司 | Multi-platform inventory optimization method and system |
Also Published As
Publication number | Publication date |
---|---|
CN111325490B (en) | 2024-04-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN111325490B (en) | Goods supplementing method and device | |
US8036925B2 (en) | System and method to manage assets of healthcare facility | |
CN108256898B (en) | Product sales prediction method, system and storage medium | |
Kobbacy et al. | Forecasting for inventory management of service parts | |
CN111133460B (en) | Optimization of demand prediction parameters | |
US20230069403A1 (en) | Method and system for generating ensemble demand forecasts | |
US11170391B2 (en) | Method and system for validating ensemble demand forecasts | |
US20030101087A1 (en) | Lease rent optimizer revenue management system | |
CN111242524A (en) | Method, system, equipment and storage medium for determining replenishment quantity of single article | |
US20200104771A1 (en) | Optimized Selection of Demand Forecast Parameters | |
JP2019049965A (en) | System and method for automatic ordering of product | |
CN109272268B (en) | Electric power material ex-warehouse quantity calculation method and system | |
Wagner | Demand planning | |
CN115115315A (en) | E-commerce commodity inventory quantity dynamic reminding management system based on cloud computing | |
CN113191795A (en) | Commodity display quantity estimation method, commodity display quantity estimation device, commodity display quantity estimation equipment and storage medium | |
JP5031715B2 (en) | Product demand forecasting system, product sales volume adjustment system | |
CN113191794A (en) | Commodity sales condition statistical method, device, equipment and storage medium | |
WO2020086872A1 (en) | Method and system for generating ensemble demand forecasts | |
JP2007526531A (en) | System, method and computer program for determining learning curve values and modeling corresponding profitability and cost of goods | |
US20210142348A1 (en) | Multi-layered system for heterogeneous pricing decisions by continuously learning market and hotel dynamics | |
Leachman | The engineering management of speed | |
US20210073840A1 (en) | Multi-layered system for heterogeneous pricing decisions by continuously learning market and hotel dynamics | |
Inaba | Inventory management of short lifecycle slow moving items: a case study | |
Argon et al. | Analysis of an inventory system under backorder correlated deterministic demand and geometric supply process | |
US20150324702A1 (en) | Predictive pattern profile process |
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 |