CN115880020A - Method, device and storage medium for acquiring real demand in out-of-stock state - Google Patents
Method, device and storage medium for acquiring real demand in out-of-stock state Download PDFInfo
- Publication number
- CN115880020A CN115880020A CN202211479101.2A CN202211479101A CN115880020A CN 115880020 A CN115880020 A CN 115880020A CN 202211479101 A CN202211479101 A CN 202211479101A CN 115880020 A CN115880020 A CN 115880020A
- Authority
- CN
- China
- Prior art keywords
- time
- stock
- sales
- target commodity
- target
- 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
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The invention discloses a method for acquiring real requirements in a stock shortage state, which comprises the following steps: acquiring each specification of a target commodity in a preset historical time period T 1 Historical sales data within; determining a calculation time range of the actual demand of the target commodity according to the historical inventory condition of the target commodity; according to the time dimension T of the real demand in the calculation time range 2 Calculating each time dimension T separately 2 The real demand of the target commodity in the non-shortage state is the time dimension T of the target commodity 2 Divided by the total sales of each size in the time dimension T 2 Time T for no shortage of goods 2,s Calculating the ratio of the sales amount; the time dimension T 2 And each size in the time dimension T 2 Internal medicineTime of out of stock T 2,s The sales share ratio is calculated by historical sales volume data. The sales volume reduced by the method for acquiring the real demand in the out-of-stock state can acquire more accurate real demand, and provides important reference for the business of evaluating and recommending commodities by stores.
Description
Technical Field
The invention relates to the technical field of supply chain product selection, in particular to a method and a device for acquiring real requirements in a stock shortage state and a storage medium.
Background
In the field of supply chain selection, an important premise of evaluating commodities and recommending the commodities to stores is to obtain the demand of the commodities in the stores, but the demand of the commodities in the out-of-stock state cannot be accurately estimated through the sales volume, for example, if 100 units of commodities are required in a certain time period, but only 20 units of commodities are stored, the historical sales volume is only 20. Therefore, describing demand in terms of historical sales is inaccurate.
Therefore, in the process of recommending commodities to stores, the real requirements of each commodity in the target store in history need to be known, and a method for removing the influence of out-of-stock and accurately describing the historical requirements is urgently needed.
Removing the influence of out-of-stock and accurately describing the demand requires that the sale time of the commodity is firstly determined. The definition of the time to put the goods on or off the shelf in the related art depends on the date of the initial sales volume moving forward by a preset time length and the time of the last sales volume moving backward by a preset time length, respectively. The time of the very critical preset duration needs to be manually determined in different service scenes by a large amount of time consumed by experts with abundant service experience, and the time of inventory existence is not considered in the method, so that the time of putting commodities on and off shelves in stores cannot be accurately reflected.
Secondly, in the related technology, the sales of the goods in short of stock are directly compared and interpolated by adopting the sales of any short of stock date in the same month, the change trend of market demands is not considered, the situations of different short of stock states of different specifications/models/sizes of the same goods are not considered, and the situation of long time of the goods break in the time of getting on and off shelves is not considered.
Therefore, how to accurately describe historical requirements, remove the influence caused by shortage of goods, and consider a business scenario that multiple specifications/models/sizes exist under a commodity is a problem to be solved urgently at present.
In view of this, the present invention is specifically disclosed.
Disclosure of Invention
Aiming at the defects of the related technology, the invention determines the time of getting on and off the shelf based on the time of stock existence, and simultaneously considers the situations of different specifications and models and different out-of-stock states under the same commodity, in order to reflect the change trend of market demand and the loss of sales caused under the out-of-stock state in the filling link, the filling under the variable time dimension and the loss of sales caused under the out-of-stock state are considered, and simultaneously the thinking is also carried out on the situation that the time of breaking the goods is longer in the time of getting on and off the shelf, thereby providing a method for acquiring the real demand under the out-of-stock state, and particularly adopting the following technical scheme:
a method for acquiring real demand in a stock shortage state comprises the following steps:
acquiring each specification of a target commodity in a preset historical time period T 1 Historical sales data within;
determining a calculation time range of the actual demand of the target commodity according to the historical inventory condition of the target commodity;
according to the time dimension T of the real demand in the calculation time range 2 Calculating each time dimension T separately 2 The real demand of the target commodity in the non-shortage state is the time dimension T of the target commodity 2 Divided by the total sales of each size in the time dimension T 2 Time T for no shortage of goods 2,s Calculating the ratio of the sales amount;
the time dimension T 2 Total sales and each size in the time dimension T 2 Time T for no shortage of goods 2,s The share ratio of the sales is calculated by historical sales data.
As an optional implementation manner of the present invention, in the method for acquiring the actual demand of the target product in the out-of-stock state, a calculation formula of the actual demand of the target product in the out-of-stock state is as follows:
As an optional implementation manner of the present invention, in the method for acquiring a real demand in an out-of-stock state, the determining a calculation time range for calculating the real demand in the out-of-stock state of the target product based on the historical inventory condition of the target product includes:
determining a calculation time range of calculating a real demand of the out-of-stock state of the target commodity based on the main specification of the target commodity, wherein the main specification of the target commodity is set manually or each specification of the target commodity is set in a preset historical time period T 1 Historical sales data in the database is determined by calculating sales engagement.
As an optional embodiment of the present invention, the method for acquiring a real demand in an out-of-stock state according to the present invention, wherein the determining a calculation time range for calculating the real demand of the out-of-stock state of the target product based on the main specification of the target product includes:
calculating and determining k T metering time stocked time intervals in first continuous T metering time according to each main specification of the target commodity, wherein k is a set value, k is more than 0 and less than 1, and k T is an integer;
defining the first date stored in the time interval as the starting sale date, and if the target commodity has a plurality of main specifications, taking the earliest starting sale date in the main specifications as the starting sale date of the target commodity.
As an optional embodiment of the present invention, the method for acquiring a real demand in an out-of-stock state according to the present invention, wherein the determining a calculation time range for calculating the real demand of the out-of-stock state of the target product based on the main specification of the target product includes:
calculating and determining k T metering time stocked time intervals in the last T metering time aiming at each main specification of the target commodity, wherein k is a set value, k is more than 0 and less than 1, and k T is an integer;
defining the last stocked date in the time interval as the sale ending date, and if the target commodity has a plurality of main specifications, taking the latest sale ending date in the main specifications as the sale ending date of the target commodity;
and the time range between the starting sale date and the ending sale date of the target commodity is a calculation time range for calculating the real demand for the target commodity stock out state.
As an optional embodiment of the invention, the method for acquiring the real demand in the out-of-stock state of the invention is a method for acquiring the real demand in the out-of-stock state, wherein the main specification of the target commodity is determined by each specification of the target commodity in a preset historical time period T 1 The calculating the sales volume ratio determination of the historical sales volume data comprises:
aiming at each specification of target commodity according to the sales volume ratio m s Sorting from big to small;
selecting the sales volume ratio m s The first n specifications are used as the main specifications of the target commodity, wherein n is a set value.
As an optional embodiment of the present invention, a method for acquiring a real demand in a stock out state of the present invention includes:
the time dimension T 2 When partial main specifications of target commodities are out of stock in the internal memory, the sales volume of the out-of-stock specification is restored by using the sales volume of the out-of-stock specification, and the calculation method comprises the following steps: sales of target goods on the day (sales ratio m of out-of-stock specification) s1 The sales volume ratio m of the standard of no shortage s2 )。
As an optional embodiment of the present invention, a method for acquiring a real demand in a stock out state of the present invention includes:
the time dimension T 2 When all main specifications of target commodities are in short supply, the major measurement time from K measurement times before the short supply date to K measurement times after the short supply date is consideredFilling the sales volume of the backorder date by the daily average value of the sales at the period of no backorder, wherein K is a set value;
or by last year contemporaneous sales in the time dimension T 2 Percentage of this year this time dimension T 2 The sales of the backorder specification is calculated and filled.
The invention also provides a device for acquiring the real demand in the out-of-stock state, which comprises:
a historical sales data module for acquiring various specifications of the target commodity in a preset historical time period T 1 Historical sales data within;
the time range calculation module is used for determining the calculation time range of the actual demand of the target commodity due to the stock shortage state based on the historical stock condition of the target commodity;
a real demand calculation module for calculating a time dimension T of a real demand within the calculation time range 2 Calculating each time dimension T separately 2 The real demand of the target commodity in the non-shortage state is the time dimension T of the target commodity 2 Divided by the total sales of each size in the time dimension T 2 Time T for no shortage of goods 2,s The ratio of sales is calculated, and the time dimension T 2 Total sales and each size in the time dimension T 2 Time T for no shortage of goods 2,s The sales share ratio is calculated by historical sales volume data.
The present invention also provides an electronic device comprising a processor and a memory, the memory being configured to store a computer-executable program, wherein:
when the computer program is executed by the processor, the processor performs the method of acquiring real demand in a stock out state.
The invention also provides a computer readable storage medium storing a computer executable program, and when the computer executable program is executed, the method for acquiring the real demand in the out-of-stock state is realized.
Compared with the prior art, the invention has the beneficial effects that:
in the field of supply chain selection, an important premise of evaluating a commodity and recommending the commodity to a store is to obtain the quantity of the commodity demanded by the store, but the quantity of the commodity demanded in a stock shortage state cannot be estimated from the sales quantity, so that the sales quantity needs to be restored. When the reduction is considered, the time period of the commodity sold in the store needs to be determined, and the method for acquiring the real demand in the out-of-stock state determines the time period of the sale by observing the historical stock condition of the commodity in the store, so that the method is more reasonable and objective than the method for acquiring the real demand in the out-of-stock state by sales confirmation.
Next, when calculating the sales volume after the reduction, if the front-back interpolation method is not avoided from the viewpoint of the sales volume alone, the loss of sales cannot be sufficiently considered. The method for acquiring the real demand in the out-of-stock state fully considers the loss of sales, and the target commodity is in the time dimension T 2 Divided by the total sales of each size in the time dimension T 2 Time T for no shortage of goods 2,s The actual demand of the out-of-stock commodities is obtained through calculation of the ratio of sales, a reduction method of the commodities with different specifications is provided, and a practical smooth method of sales is provided for commodity evaluation and commodity recommendation to stores.
Therefore, according to the method for acquiring the real demand in the out-of-stock state, the sales volume after the reduction processing can acquire the real demand more accurately than that of the related technology, and an important reference is provided for the business of evaluating and recommending commodities by stores.
Description of the drawings:
FIG. 1 is a flowchart illustrating an exemplary method for acquiring real demand in a stock out condition according to an embodiment of the present invention;
FIG. 2 is an exemplary table of historical sales data for a method of acquiring real demand in a stock out condition according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. It is to be understood that the embodiments described are only a few embodiments of the present invention, and not all embodiments.
Thus, the following detailed description of the embodiments of the invention is not intended to limit the scope of the invention as claimed, but is merely representative of some embodiments of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the embodiments of the present invention and the features and technical solutions thereof may be combined with each other without conflict.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures.
In the description of the present invention, it should be noted that the terms "upper", "lower", and the like refer to orientations or positional relationships based on those shown in the drawings, or orientations or positional relationships that are conventionally arranged when the products of the present invention are used, or orientations or positional relationships that are conventionally understood by those skilled in the art, and such terms are used for convenience of description and simplification of the description, and do not refer to or imply that the devices or elements referred to must have a specific orientation, be constructed and operated in a specific orientation, and thus, should not be construed as limiting the present invention. Furthermore, the terms "first," "second," and the like are used merely to distinguish one description from another, and are not to be construed as indicating or implying relative importance.
Referring to fig. 1, a method for acquiring a real demand in a stock shortage state in this embodiment includes:
acquiring each specification of a target commodity in a preset historical time period T 1 Historical sales data within;
determining a calculation time range of the actual demand of the target commodity according to the historical inventory condition of the target commodity;
according to the time dimension T of the real demand in the calculation time range 2 Calculating each time dimension T separately 2 Lower target commodity no-shortage stateThe actual demand under the state is the time dimension T of the target commodity 2 Divided by the total sales of each size in the time dimension T 2 Time T for no shortage of goods 2,s Calculating the ratio of the sales amount;
the time dimension T 2 Total sales and each size in the time dimension T 2 Time T for no shortage of goods 2,s The sales share ratio is calculated by historical sales volume data.
In the field of supply chain selection, an important premise for evaluating commodities and recommending the commodities to stores is to obtain the demand of the commodities in the stores, but the demand of the commodities in a stock shortage state cannot be estimated through sales volume, so that the sales volume needs to be restored. In consideration of reduction, the time period of the sale of the commodity in the store needs to be determined, and the method for acquiring the real demand of the commodity in the out-of-stock state in the embodiment determines the sale time period by observing the historical stock condition of the commodity in the store, so that the method is more reasonable and objective than the method for acquiring the real demand of the commodity in the out-of-stock state by sales confirmation.
Next, when calculating the sales volume after the reduction, if the front-back interpolation method is not avoided from the viewpoint of the sales volume alone, the loss of sales cannot be sufficiently considered. The method for acquiring the real demand in the out-of-stock state fully considers the loss of sales, and the target commodity is in the time dimension T 2 Divided by the total sales of each size in the time dimension T 2 Time T for no shortage of goods 2,s The actual demand of the out-of-stock commodities is obtained through calculation of the ratio of sales, a reduction method of the commodities with different specifications is provided, and a practical smooth method of sales is provided for commodity evaluation and commodity recommendation to stores.
Therefore, according to the method for acquiring the real demand in the out-of-stock state, the sales volume after the reduction processing can acquire the real demand more accurately than that of the related technology, and an important reference is provided for the business of evaluating and recommending commodities by stores.
The commodities of the embodiment have different specifications, and the specifications are different for different commodities, for example, for the same category of commodities, the specifications can be sizes, or for clothes, shoes and the like commodities, the specifications can be sizes and the like.
Time dimension T of the present embodiment 2 Is the calculation of the next step sales reduction in the appropriate time dimension according to business needs, in an alternative embodiment time dimension T 2 Is a week or a month.
Specifically, in the method for acquiring the actual demand of the target product in the out-of-stock state of the embodiment, a calculation formula of the actual demand of the target product in the out-of-stock state is as follows:
The sales ratio m of each specification of the target product s The calculation specifically comprises the following steps: first, when the historical sales of a product are reduced, the specifications S (S ∈ S) under the category to which the product belongs and the specifications of the category for a certain period of time T are known 1 Total sales in m s For example: the size of a certain shirt commodity is [ M, L, XL, XXL ] under the category]The total sales volume ratio of each size in one month under the category is [0.2,0.3,0.4,0.1]。
In the method for acquiring the real demand in the out-of-stock state according to the embodiment, in the required time dimension, the real demand is restored based on the lost out-of-stock sales ratio, and the method specifically includes: first of all, the first step is to,determining the daily sales amount of the store based on the historical sales condition of the store to which the commodity belongs, and calculating T 2 The sales ratio P of the next day t (t∈T 2 ) (ii) a Next, each size is determined to be in the time range T 2 Time T for getting out of stock 2，s Then dividing the total sales volume of the goods by the ratio of sales of each size under the non-shortage time to obtain the required time range T 2 The actual demand in the no-back-out state.
In the method for acquiring the actual demand in the out-of-stock state, when the actual demand reduction of the out-of-stock commodity is considered, the time period of the commodity sold in the store needs to be determined, and the time period of the commodity sold in the store is determined by observing the historical stock condition of the commodity in the store. Specifically, the calculating time range for calculating the actual demand based on the target product stock status determined based on the historical stock condition of the target product in this embodiment includes:
determining a calculation time range of calculating a real demand of the out-of-stock state of the target commodity based on the main specification of the target commodity, wherein the main specification of the target commodity is set manually or each specification of the target commodity is set in a preset historical time period T 1 Historical sales data in the database is determined by calculating sales engagement.
Since there are multiple specifications under the target product, the present embodiment considers the stock condition of the main specification of the target product when determining the calculation time range.
Specifically, in the method for acquiring the real demand in the out-of-stock state according to the embodiment, the determining the calculation time range for calculating the real demand in the out-of-stock state of the target product based on the main specification of the target product includes:
calculating and determining k T metering time stocked time intervals in first continuous T metering time aiming at each main specification of the target commodity, wherein k is a set value, k is more than 0 and less than 1, k T is an integer, and optionally k is 1/2;
defining the first date stored in the time interval as the starting sale date, and if the target commodity has a plurality of main specifications, taking the earliest starting sale date in the main specifications as the starting sale date of the target commodity.
Calculating and determining k T metering time stocked time intervals in the last T metering time aiming at each main specification of the target commodity, wherein k is a set value, k is more than 0 and less than 1, k T is an integer, and optionally k is 1/2;
defining the last stored date in the time interval as the sale ending date, and if the target commodity has a plurality of main specifications, taking the latest sale ending date in the main specifications as the sale ending date of the target commodity;
and the time range between the starting sale date and the ending sale date of the target commodity is a calculation time range for calculating the real demand for the stock out state of the target commodity.
In the method for acquiring the actual demand in the out-of-stock state of the embodiment, the main specification of the target commodity can be specified manually, or the top n specifications can be specified according to the sales ratio determined by the business target. Specifically, the main specification of the target product in this embodiment is determined by each specification of the target product in a preset historical time period T 1 The calculating the sales volume ratio determination of the historical sales volume data comprises:
aiming at each specification of target commodity according to the sales volume ratio m s Sorting from big to small;
selecting the sales volume ratio m s The first n specifications are used as the main specifications of the target commodity, wherein n is a set value.
Referring to fig. 1, a specific example of a method for acquiring a real demand in a stock out state in this embodiment includes:
the method comprises the following steps of firstly, obtaining sales volume of each specification/size of the category based on the category of the commodity, and specifically comprises the following steps: first, when the historical sales of a certain product are restored, the specifications/sizes S (S ∈ S) of the class to which the product belongs and the specifications/sizes of the class for a certain period of time T are known 1 Total sales in m s For example: the size of a certain shirt commodity is [ M, L, XL, XXL ] under the category]The total sales volume ratio of each size in one month under the category is [0.2,0.3,0.4,0.1]。
Secondly, determining main specifications/sizes based on the sales volume ratios of the specifications/sizes in the categories, and specifically comprising the following steps: firstly, ranking the sales volume ratio of each specification/size from large to small, then determining the number of main specifications/sizes, wherein the number of main specifications/sizes can be manually specified, or the top n of the specifications/sizes can be specified according to the sales ratio determined by a business target, for example, taking the size with the highest sales ratio of the top 3 as the main specification/size, namely [ M, L, XL ].
Thirdly, determining a time range needing to be calculated based on the historical inventory condition and the main sale size/specification of the commodity, and specifically comprising the following steps:
time to start sales: calculating and determining the time of stock in T/2 days in the first continuous T days for each main specification/size, defining the date of stock in the first time as the sale starting date, and taking the earliest sale starting date in the main specifications/sizes as the sale starting date of the commodity if the commodity has a plurality of sizes/specifications;
the end of sale date: calculating and determining the time of stock in T/2 days in the last continuous T days for each main specification/size, defining the date of stock in the last continuous T days as the sale ending date, and taking the latest sale ending date in the main specifications/sizes as the sale ending date of the commodity if the commodity has a plurality of sizes/sizes;
the time range between the start sales date and the end sales date is the time range in which calculations need to be made.
Fourthly, determining a required time dimension T based on the time range needing to be calculated 2 The method mainly refers to calculation of next-step sales volume reduction in a proper time dimension according to service needs, and in an optional implementation mode, the calculation is weekly or monthly;
fifthly, under the required time dimension, the real demand is restored based on the sales ratio of the stock shortage loss, and the method specifically comprises the following steps:
first, based on the historical sales of the store to which the commodity belongs, the daily sales of the store is determined, and T is calculated 2 The sales ratio P of the next day t (t∈T 2 ) (ii) a Next, each size is determined to be in the time range T 2 Time T for getting out of stock 2，s Then dividing the total sales volume of the commodity by the sales ratio of each size under the non-shortage time to obtain the required time range T 2 True demand in the next non-out-of-stock condition:
such as: the stock data and sales data in four sizes of [ M, L, XL, XXL ] for a certain week determined in the time frame required for the calculation are shown in the table of FIG. 2:
four sizes [ M, L, XL, XXL]At T 1 Total sales in m s ＝[0.2，0.3，0.4，0.1](this can be obtained by dividing the sales volume of each size by the total sales volume in the time period, and the sales data for each specific size is not shown in the table, but the historical sales data for each size is counted during the sales of the goods, and is not shown in this example for simplification), then the time dimension T for each size can be obtained 2 The sales ratio in the time of no shortage is
The sales of the commodity after reduction in this week can be calculated as:
in addition, the sales ratios in the table of FIG. 2 are the current day sales versus the time dimension T 2 The ratio of total sales in, the time dimension T in the table of FIG. 2 2 For 7 days.
A method for acquiring a real demand in a stock shortage state in this embodiment;
1. when the time period needing to be restored is determined, the time for starting sales and the time for ending sales are respectively defined according to the inventory condition, and reasonable and objective judgment can be given after T is set.
2. The lost sales ratio at the time of stock shortage is taken into account when calculating the reduced sales on the selected time dimension, and the sales is reduced by the sales ratio at the time of no stock shortage.
3. Considering the reduction method of the commodities with different specifications and sizes, the method is characterized in that the sales volume of each size weighted by the sales volume of each size when the commodities are not out of stock accounts for the reduction of the commodity dimension by calculating the total sales volume of each size of the commodities.
The method for acquiring the real demand in the out-of-stock state in the embodiment further comprises the following steps:
the time dimension T 2 When part of main specifications of target commodities are out of stock, the sales volume of the out-of-stock specification is restored by using the sales volume of the out-of-stock specification, and the calculation method comprises the following steps: sales of target goods on the day (sales ratio m of out-of-stock specification) s1 The sales volume ratio m of the standard of no shortage s2 )。
The method for acquiring the real demand in the out-of-stock state in the embodiment further comprises the following steps:
the time dimension T 2 When all main specifications of target commodities are out of stock in the memory, filling the sales volume of the out-of-stock date by considering the daily average value of the main specifications sold in the period of no out-of-stock at K metering times before the out-of-stock date, wherein K is a set value;
or by last year contemporaneous sales in the time dimension T 2 The ratio of 2 The sales of the backorder specification is calculated and filled.
This embodiment provides a device of true demand under acquireing out of stock state simultaneously, includes:
a historical sales data module for acquiring various specifications of the target commodity in a preset historical time period T 1 Historical sales data within;
the time range calculation module is used for determining the calculation time range of the actual demand of the target commodity according to the historical stock condition of the target commodity;
a true demand calculation module to calculate true in said calculation time rangeTime dimension T of real demand 2 Calculating each time dimension T separately 2 The real demand of the target commodity in the non-shortage state is the time dimension T of the target commodity 2 Divided by the total sales of each size in the time dimension T 2 Time T for no shortage of goods 2,s The ratio of sales is calculated, and the time dimension T 2 Total sales and each size in the time dimension T 2 Time T for no shortage of goods 2,s The sales share ratio is calculated by historical sales volume data.
The device for acquiring the real demand in the out-of-stock state is characterized in that the calculation formula for calculating the real demand of the target commodity in the out-of-stock state by the real demand calculation module is as follows:
In this embodiment, the calculating time range of the time range calculating module for determining the actual demand of the target product based on the historical stock condition of the target product includes:
determining a calculation time range of calculating a real demand of the out-of-stock state of the target commodity based on the main specification of the target commodity, wherein the main specification of the target commodity is set manually or each specification of the target commodity is set in a preset historical time period T 1 Historical sales data in the system is determined by calculating the sales ratio。
In this embodiment, the time range calculation module determines a calculation time range of the actual demand calculated by the target product stock shortage state based on the main specification of the target product, and includes:
calculating and determining k T metering time stocked time intervals in first continuous T metering time according to each main specification of the target commodity, wherein k is a set value, k is more than 0 and less than 1, and k T is an integer;
and defining the date of the first stock under the time interval as the sale starting date, and if a plurality of main specifications are under the target commodity, taking the earliest sale starting date in the main specifications as the sale starting date of the target commodity.
In this embodiment, the time range calculation module determines a calculation time range of the actual demand calculated by the target product stock shortage state based on the main specification of the target product, and includes:
calculating and determining k T metering time stocked time intervals in the last T metering time aiming at each main specification of the target commodity, wherein k is a set value, k is more than 0 and less than 1, and k T is an integer;
defining the last stored date in the time interval as the sale ending date, and if the target commodity has a plurality of main specifications, taking the latest sale ending date in the main specifications as the sale ending date of the target commodity;
and the time range between the starting sale date and the ending sale date of the target commodity is a calculation time range for calculating the real demand for the stock out state of the target commodity.
In this embodiment, the main specification of the target product is determined by each specification of the target product in a preset historical time period T 1 The historical sales data in the system is determined by calculating sales share ratios including:
aiming at each specification of target goods, according to the sales volume ratio m s Sorting from big to small;
selecting the sales volume ratio m s The first n specifications are used as the main specifications of the target commodity, wherein n is a set value.
The device for acquiring real demand in the out-of-stock state comprises the out-of-stockA specification sales reduction module, which is used for reducing the out-of-stock specification sales in the time dimension T 2 When partial main specifications of target commodities are out of stock in the internal memory, the sales volume of the out-of-stock specification is restored by using the sales volume of the out-of-stock specification, and the calculation method comprises the following steps: sales of target goods on the day (sales ratio m of out-of-stock specification) s1 The sales volume ratio m of the standard of no shortage s2 )。
In the device for acquiring real demand in the out-of-stock state of the embodiment, the out-of-stock specification sales reduction module is in the time dimension T 2 When all main specifications of target commodities are out of stock in the memory, filling the sales volume of the out-of-stock date by considering the daily average value of the main specifications sold in the period of no out-of-stock at K metering times before the out-of-stock date, wherein K is a set value; or by last year contemporaneous sales in the time dimension T 2 Percentage of this year this time dimension T 2 The sales of the backorder specification is calculated and filled.
The present embodiment also provides a computer-readable storage medium, which stores a computer-executable program, and when the computer-executable program is executed, the method for acquiring the actual demand in the out-of-stock state is implemented.
The computer readable storage medium of the present embodiments may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable storage medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
The present embodiment further provides an electronic device, comprising a processor and a memory, wherein the memory is used for storing a computer executable program, and when the computer program is executed by the processor, the processor executes the method for acquiring the real demand in the out-of-stock state.
The electronic device is in the form of a general purpose computing device. The processor can be one or more and can work together. The invention does not exclude that the processing is distributed, i.e. the processors may be distributed over different physical devices. The electronic device of the present invention is not limited to a single entity, and may be a sum of a plurality of entity devices.
The memory stores a computer executable program, typically machine readable code. The computer readable program may be executed by the processor to enable an electronic device to perform the method of the invention, or at least some of the steps of the method.
The memory may include volatile memory, such as Random Access Memory (RAM) and/or cache memory, and may also be non-volatile memory, such as read-only memory (ROM).
It should be understood that elements or components not shown in the above examples may also be included in the electronic device of the present invention. For example, some electronic devices further include a display unit such as a display screen, and some electronic devices further include a human-computer interaction element such as a button, a keyboard, and the like. Electronic devices are considered to be covered by the present invention as long as the electronic devices are capable of executing a computer-readable program in a memory to implement the method of the present invention or at least a part of the steps of the method.
From the above description of the embodiments, those skilled in the art will readily appreciate that the present invention can be implemented by hardware capable of executing a specific computer program, such as the system of the present invention, and electronic processing units, servers, clients, mobile phones, control units, processors, etc. included in the system. The invention may also be implemented by computer software for performing the method of the invention, e.g. control software executed by a microprocessor, an electronic control unit, a client, a server, etc. It should be noted that the computer software for executing the method of the present invention is not limited to be executed by one or a specific hardware entity, and can also be realized in a distributed manner by non-specific hardware. For computer software, the software product may be stored in a computer readable storage medium (which may be a CD-ROM, a usb disk, a removable hard disk, etc.) or may be distributed over a network, as long as it enables the electronic device to perform the method according to the present invention.
The above embodiments are only used for illustrating the invention and not for limiting the technical solutions described in the invention, and although the present invention has been described in detail in the present specification with reference to the above embodiments, the present invention is not limited to the above embodiments, and therefore, any modification or equivalent replacement of the present invention is made; but all technical solutions and modifications thereof without departing from the spirit and scope of the present invention are encompassed in the claims of the present invention.
Claims (10)
1. A method for acquiring real demand in a stock shortage state is characterized by comprising the following steps:
acquiring each specification of a target commodity in a preset historical time period T 1 Historical sales data within;
determining a calculation time range of the actual demand of the target commodity according to the historical inventory condition of the target commodity;
in the calculation time range, according to the time dimension T of calculating the real demand 2 Respectively calculating each time dimension T 2 The real demand of the target commodity in the non-shortage state is the time dimension T of the target commodity 2 Divided by the total sales of each size in the time dimension T 2 Time T for no shortage of goods 2,s Calculating the ratio of the sales amount;
the time dimension T 2 Total sales and each size in the time dimension T 2 Time T for no shortage of goods 2,s The sales share ratio is calculated by historical sales volume data.
2. The method for acquiring the actual demand of the target commodity in the out-of-stock state according to claim 1, wherein the calculation formula of the actual demand of the target commodity in the out-of-stock state is as follows:
3. The method for acquiring the actual demand in the out-of-stock state as claimed in claim 1, wherein the determining the calculation time range for calculating the actual demand based on the out-of-stock state of the target product based on the historical inventory condition of the target product comprises:
determining a calculation time range of calculating a real demand of the out-of-stock state of the target commodity based on the main specification of the target commodity, wherein the main specification of the target commodity is set manually or each specification of the target commodity is set in a preset historical time period T 1 Historical sales data in the system is determined by calculating sales proportions.
4. The method for acquiring the actual demand in the out-of-stock state as claimed in claim 3, wherein the determining the calculation time range for calculating the actual demand based on the out-of-stock state of the target product based on the main specification of the target product comprises:
calculating and determining k T metering time stocked time intervals in first continuous T metering time according to each main specification of the target commodity, wherein k is a set value, k is more than 0 and less than 1, and k T is an integer;
defining the first date stored in the time interval as the starting sale date, and if the target commodity has a plurality of main specifications, taking the earliest starting sale date in the main specifications as the starting sale date of the target commodity.
5. The method for acquiring the actual demand in the out-of-stock state as claimed in claim 4, wherein the determining the calculation time range for calculating the actual demand based on the out-of-stock state of the target product based on the main specification of the target product comprises:
calculating and determining k T metering time stocked time intervals in the last T metering time aiming at each main specification of the target commodity, wherein k is a set value, k is more than 0 and less than 1, and k T is an integer;
defining the last stored date in the time interval as the sale ending date, and if the target commodity has a plurality of main specifications, taking the latest sale ending date in the main specifications as the sale ending date of the target commodity;
and the time range between the starting sale date and the ending sale date of the target commodity is a calculation time range for calculating the real demand for the stock out state of the target commodity.
6. The method for acquiring the actual demand in the out-of-stock state as claimed in claim 3, wherein the main specification of the target commodity is determined by each specification of the target commodity in a preset historical time period T 1 The calculating the sales volume ratio determination of the historical sales volume data comprises:
aiming at each specification of target goods, according to the sales volume ratio m s Sorting from big to small;
selecting the sales volume ratio m s The first n specifications are used as the main specifications of the target commodity, wherein n is a set value.
7. The method for acquiring the actual demand in the out-of-stock state as claimed in claim 1, comprising:
the time dimension T 2 Internal presence targetWhen part of main specifications of the commodities are out of stock, the sales volume of the out-of-stock specification is restored by using the sales volume of the out-of-stock specification, and the calculation method comprises the following steps: sales of target goods on the day (sales ratio m of out-of-stock specification) s1 The sales volume ratio m of the standard of no shortage s2 )。
8. The method for acquiring the actual demand in the out-of-stock state as claimed in claim 1, comprising:
the time dimension T 2 When all main specifications of target commodities are out of stock in the memory, filling the sales volume of the out-of-stock date by considering the daily average value of the main specifications sold in the period of no out-of-stock at K metering times before the out-of-stock date, wherein K is a set value;
or by last year contemporaneous sales in the time dimension T 2 The ratio of 2 The sales amount of the out-of-stock specification is calculated and filled.
9. An apparatus for obtaining actual demand in an out-of-stock condition, comprising:
a historical sales data module for acquiring various specifications of the target commodity in a preset historical time period T 1 Historical sales data within;
the time range calculation module is used for determining the calculation time range of the actual demand of the target commodity due to the stock shortage state based on the historical stock condition of the target commodity;
a real demand calculation module for calculating a time dimension T of a real demand within the calculation time range 2 Calculating each time dimension T separately 2 The real demand of the target commodity in the non-shortage state is the time dimension T of the target commodity 2 Divided by the total sales of each size in the time dimension T 2 Time T for no shortage of goods 2,s The ratio of sales is calculated, and the time dimension T 2 And each size in the time dimension T 2 Time T for no shortage of goods 2,s The sales share ratio is calculated by historical sales volume data.
10. A computer-readable storage medium storing a computer-executable program, wherein the computer-executable program, when executed, implements a method of acquiring a real demand in a backorder condition according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211479101.2A CN115880020A (en) | 2022-11-23 | 2022-11-23 | Method, device and storage medium for acquiring real demand in out-of-stock state |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211479101.2A CN115880020A (en) | 2022-11-23 | 2022-11-23 | Method, device and storage medium for acquiring real demand in out-of-stock state |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115880020A true CN115880020A (en) | 2023-03-31 |
Family
ID=85760760
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211479101.2A Pending CN115880020A (en) | 2022-11-23 | 2022-11-23 | Method, device and storage medium for acquiring real demand in out-of-stock state |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115880020A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116739655A (en) * | 2023-07-14 | 2023-09-12 | 上海朗晖慧科技术有限公司 | Intelligent supply chain management method and system based on big data |
-
2022
- 2022-11-23 CN CN202211479101.2A patent/CN115880020A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116739655A (en) * | 2023-07-14 | 2023-09-12 | 上海朗晖慧科技术有限公司 | Intelligent supply chain management method and system based on big data |
| CN116739655B (en) * | 2023-07-14 | 2024-04-02 | 上海朗晖慧科技术有限公司 | Intelligent supply chain management method and system based on big data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108364085A (en) | A kind of take-away distribution time prediction technique and device | |
| US9990597B2 (en) | System and method for forecast driven replenishment of merchandise | |
| CN109948829B (en) | Goods dispatching method based on multiple selling points, electronic equipment and storage medium | |
| CN112215546B (en) | Object page generation method, device, equipment and storage medium | |
| US20140258050A1 (en) | Store Feature Item Finder | |
| CN111815405B (en) | Commodity purchasing method based on artificial intelligence | |
| CN112053168A (en) | Material monitoring method and device, electronic equipment and storage medium | |
| US20220414579A1 (en) | Salesperson evaluation apparatus, salesperson evaluation method, and salesperson evaluation program | |
| CN107767092A (en) | Processing method, display method and device of commodity object information | |
| CN115880020A (en) | Method, device and storage medium for acquiring real demand in out-of-stock state | |
| CN114782024A (en) | Material purchasing plan generation method and device | |
| KR101858205B1 (en) | Food order method and server performing the same | |
| CN103679479A (en) | Method, system, server and client for data processing of business object | |
| US8768790B2 (en) | Product-family inventory replenishment system using a composite product mix framework | |
| CN109255710B (en) | Method, device and system for marking listing on market transaction software | |
| CN114219397A (en) | Inventory management method, device, equipment and storage medium | |
| CN116433154A (en) | Warehouse replenishment method and device, electronic equipment and storage medium | |
| CN115860643A (en) | Supply chain order management method, device and storage medium | |
| CN106952140B (en) | Distribution order processing method and device | |
| JP2011096108A (en) | System and program for supporting decision making for change of production plan | |
| US20180300980A1 (en) | Sales apparatus, control method, and storage medium | |
| US20080235054A1 (en) | Diabetic care products web shop with enhanced usability | |
| CN110009382B (en) | Data monitoring method, device and server for virtual commodity | |
| CN113762993A (en) | Data processing method, system, device, equipment and storage medium | |
| EP1357498A2 (en) | Stock planning method |
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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 1501, 15th Floor, Building 7, No.13 Huayuan Road, Haidian District, Beijing, 100088 Applicant after: Beijing Shushi yunchuang Technology Co.,Ltd. Address before: No. 805, Floor 8, Building A, Zhizhen Building, No. 7, Zhichun Road, Haidian District, Beijing, 100088 Applicant before: Beijing Shushi yunchuang Technology Co.,Ltd. |