CN114781981A - Inventory determination method, device, electronic equipment and computer readable medium - Google Patents
Inventory determination method, device, electronic equipment and computer readable medium Download PDFInfo
- Publication number
- CN114781981A CN114781981A CN202210683333.3A CN202210683333A CN114781981A CN 114781981 A CN114781981 A CN 114781981A CN 202210683333 A CN202210683333 A CN 202210683333A CN 114781981 A CN114781981 A CN 114781981A
- Authority
- CN
- China
- Prior art keywords
- inventory
- target
- days
- turnaround
- warehouse
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/04—Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem"
Abstract
The embodiment of the disclosure discloses an inventory determination method, an inventory determination device, an electronic device and a computer readable medium. One specific implementation of the inventory determination method includes: generating a reference data set according to historical ex-warehouse data of the target object in a set time period; determining reference inventory turnover days of the target object in a set time period based on each reference data in the reference data set to obtain a plurality of reference inventory turnover days; selecting reference inventory turnover days from a plurality of reference inventory turnover days according to a target turnover threshold value, and taking the reference inventory turnover days as target inventory turnover days; and determining the value of the reference data corresponding to the target inventory turnover days as the target inventory of the target article. The embodiment relates to logistics warehousing technology, and can determine the target inventory level of the goods according to the historical ex-warehouse quantity of the goods without exceeding the historical ex-warehouse quantity. This makes the determination more reasonable. The inventory holding cost of the enterprise is reduced as much as possible while the customer demand is ensured.
Description
Technical Field
Embodiments of the present disclosure relate to the field of computer technologies, and in particular, to the field of warehousing inventory, and more particularly, to an inventory determination method, apparatus, electronic device, and computer-readable medium.
Background
In a supply chain consisting of a factory, a distributor and a consumer, in order to meet the demands of the consumer in time and improve the satisfaction of the consumer, the distributor usually needs to store a large amount of goods as inventory. Although storage inventory can respond quickly to consumer demand, some goods may become overstocked due to changes in market laws. And some of the goods may eventually even be disposed of at a base price.
That is, these goods that cannot be sold in a timely manner often result in extremely high holding and loss costs. In addition, these inventory items may also take up more storage space. Especially for low volume (intermittent) goods such as engines in the mechanical industry spare parts. It is generally expensive and takes a long time to get in order. Thus, for such goods that have significant low sales, long sales intervals, the dealer is required to predict a more reasonable inventory level.
Disclosure of Invention
This summary is provided to introduce a selection of concepts in a simplified form that are further described below in the detailed description. This summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used to limit the scope of the claimed subject matter. Some embodiments of the present disclosure propose inventory determination methods, apparatuses, electronic devices, and computer readable media to address one or more of the technical problems noted in the background section above.
In a first aspect, some embodiments of the present disclosure provide an inventory determination method, including: generating a reference data set according to historical ex-warehouse data of the target object in a set time period; determining reference inventory turnover days of the target object in a set time period based on each reference data in the reference data set to obtain a plurality of reference inventory turnover days; selecting reference inventory turnover days from a plurality of reference inventory turnover days according to a target turnover threshold value, and taking the reference inventory turnover days as target inventory turnover days; and determining the value of the reference data corresponding to the target inventory turnover days as the target inventory of the target article, and outputting the target inventory.
In some embodiments, determining a reference number of inventory turnaround days for the target item within the set time period based on each of the reference data in the reference data set comprises: determining the total inventory amount of the target object in a set time period by taking the reference data as the daily inventory amount of the target object; determining the total ex-warehouse quantity of the target object in a set time period according to the daily inventory and historical ex-warehouse data; and determining reference inventory turnover days of the target object in a set time period under the daily inventory based on the total inventory and the total ex-warehouse quantity.
In some embodiments, selecting a reference number of inventory turnaround days from a plurality of reference inventory turnaround days according to a target turnaround threshold comprises: for each reference inventory turnover number of days in the plurality of reference inventory turnover days, comparing the reference inventory turnover number of days to a target turnover threshold, and if less than or equal to the target turnover threshold, adding to the first set, and if greater than the target turnover threshold, adding to the second set; determining whether the first set is empty; in response to determining not to be empty, a reference inventory turnaround number of days is selected from the first set.
In some embodiments, selecting a reference number of inventory turnaround days from a plurality of reference number of inventory turnaround days according to a target turnaround threshold further comprises: in response to determining to be empty, a reference number of inventory turnaround days is selected from the second set.
In some embodiments, the method further comprises: determining whether to replenish the target object or not according to the comparison result of the inventory data of the target object and the target inventory; in response to determining to restock, a restock amount of the target item is determined, and restock information is generated.
In some embodiments, the inventory data includes stock in stock and acquired quantities; and determining the replenishment quantity of the target object, comprising: and determining the difference value between the target inventory and the current inventory and the acquired quantity as the replenishment quantity of the target object.
In some embodiments, generating the reference data set according to historical ex-warehouse data of the target item within a set time period comprises: selecting historical ex-warehouse quantity larger than a set value from the historical ex-warehouse data; and carrying out duplicate removal processing on the selected historical ex-warehouse quantity to obtain a reference data set.
In some embodiments, the target item is determined by: analyzing historical ex-warehouse data of the articles, and determining the ex-warehouse times and the total ex-warehouse quantity of the articles within a certain time; and determining the articles with the warehouse-out times smaller than the set times and the total warehouse-out amount smaller than the set warehouse-out amount as the target articles.
In a second aspect, some embodiments of the present disclosure provide an inventory determination device, including: the generating unit is configured to generate a reference data set according to historical ex-warehouse data of the target object in a set time period; a number-of-days determination unit configured to determine a reference inventory turnaround number of days of the target item within a set time period based on each reference data in the reference data set, resulting in a plurality of reference inventory turnaround days; a selecting unit configured to select a reference inventory turnaround number of days from a plurality of reference inventory turnaround days as a target inventory turnaround number of days according to a target turnaround threshold; a stock quantity determining unit configured to determine a value of the reference data corresponding to a target stock turnaround day as a target stock quantity of the target item, and output the target stock quantity.
In some embodiments, the number-of-days determination unit is further configured to determine a total inventory amount of the target item over the set period of time using the reference data as a daily inventory amount of the target item; determining the total ex-warehouse quantity of the target object in a set time period according to the daily inventory and historical ex-warehouse data; and determining reference inventory turnover days of the target object in a set time period under the daily inventory based on the total inventory and the total ex-warehouse quantity.
In some embodiments, the pick unit is further configured to compare, for each reference inventory turnover number of days in the plurality of reference inventory turnover days, the reference inventory turnover number of days to a target turnover threshold, and if less than or equal to the target turnover threshold, add to the first set, and if greater than the target turnover threshold, add to the second set; determining whether the first set is empty; in response to determining not to be empty, a reference inventory turnaround number of days is selected from the first set.
In some embodiments, the selecting unit is further configured to select a reference number of inventory turnaround days from the second set in response to determining to be empty.
In some embodiments, the apparatus further comprises a restocking determination unit configured to determine whether to restock the target item according to a result of comparison of the inventory data of the target item with the target inventory amount; in response to determining to restock, a restock amount of the target item is determined, and restock information is generated.
In some embodiments, the inventory data includes stock in stock and acquired quantities; and the replenishment determining unit is further configured to determine a difference between the target stock quantity and the stock quantity in stock, the acquired quantity, as the replenishment quantity of the target item.
In some embodiments, the generation unit is further configured to select a history ex-warehouse quantity greater than a set value from the history ex-warehouse data; and carrying out duplicate removal processing on the selected historical ex-warehouse quantity to obtain a reference data set.
In some embodiments, the apparatus further comprises a target item determination unit configured to analyze historical ex-warehouse data of the item, and determine the number of ex-warehouses and the total ex-warehouse quantity of the item within a certain time period; and determining the articles with the delivery times less than the set times and the total delivery amount less than the set delivery amount as target articles.
In a third aspect, some embodiments of the present disclosure provide an electronic device, comprising: one or more processors; a storage device, on which one or more programs are stored, which when executed by one or more processors cause the one or more processors to implement the method described in any implementation of the first aspect.
In a fourth aspect, some embodiments of the disclosure provide a computer readable medium on which a computer program is stored, wherein the program when executed by a processor implements the method described in any one of the implementations of the first aspect.
The above embodiments of the present disclosure have the following advantages: the inventory determination method of some embodiments of the present disclosure may determine a relatively reasonable inventory level, reducing inventory costs as much as possible. Specifically, one of the reasons for the high cost of ownership (inventory) is that: most of the existing inventory determination methods adopt machine learning model prediction. However, for low-sale (intermittent) goods, due to the characteristics of obvious low ex-warehouse quantity (sales quantity) and long ex-warehouse (sales) interval, less data can be used for model training, model learning is not easy, and the accuracy of the prediction result is influenced. In addition, each time a warehouse-out situation occurs, the model will tend to predict future warehouse-out quantities in an ascending trend. The results thus predicted are generally large, resulting in high inventory costs and taking up large warehouse space. In addition, long term backlog storage of items tends to increase the probability of damage or failure of the item. Based on this, the inventory determination method of some embodiments of the present disclosure may generate a reference data set from historical ex-warehouse data of the item, resulting in a plurality of reference inventory turnaround days. I.e. to determine the reference turnover days at each ex-warehouse quantity. And then, according to the target turnover threshold, selecting a suitable target reference turnover number of days from the target turnover threshold, and determining the value of the reference data corresponding to the suitable target turnover number of days as the target inventory of the target article. The inventory determination mode is more suitable for low-sales articles. The determined stock level usually does not exceed the historical ex-warehouse quantity, and the determination result is more reasonable. Thus, the inventory holding cost of enterprises can be reduced as much as possible while the requirement of customers is ensured. In addition, the storage space occupation can be reduced, and the quality of the stored articles can be ensured.
Drawings
The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numbers refer to the same or similar elements. It should be understood that the drawings are schematic and that elements and elements are not necessarily drawn to scale.
FIG. 1 is a schematic diagram of an application scenario of an inventory determination method according to some embodiments of the present disclosure;
FIG. 2 is a flow diagram of some embodiments of an inventory determination method according to the present disclosure;
FIG. 3 is a flow diagram of further embodiments of an inventory determination method according to the present disclosure;
FIG. 4 is a schematic block diagram of some embodiments of an inventory determination device according to the present disclosure;
FIG. 5 is a schematic structural diagram of an electronic device suitable for use in implementing some embodiments of the present disclosure.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it is to be understood that the disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete. It should be understood that the drawings and embodiments of the disclosure are for illustration purposes only and are not intended to limit the scope of the disclosure.
It should be noted that, for convenience of description, only the portions related to the related invention are shown in the drawings. The embodiments and features of the embodiments in the present disclosure may be combined with each other without conflict.
It should be noted that the terms "first", "second", and the like in the present disclosure are only used for distinguishing different devices, modules or units, and are not used for limiting the order or interdependence of the functions performed by the devices, modules or units.
It is noted that references to "a" or "an" in this disclosure are intended to be illustrative rather than limiting, and that those skilled in the art will appreciate that references to "one or more" are intended to be exemplary and not limiting unless the context clearly indicates otherwise.
The names of messages or information exchanged between devices in the embodiments of the present disclosure are for illustrative purposes only, and are not intended to limit the scope of the messages or information.
The present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
FIG. 1 is a schematic diagram of one application scenario of an inventory determination method of some embodiments of the present disclosure.
Here, the user (distributor) can use the terminal to record and store the circulation information (such as sales and purchase) of each item. In the application scenario of fig. 1, the computing device 101, upon receiving user input of flow information such as a filter, may count historical ex-warehouse (sales) data 102 of the filter over, for example, the past year. For example, the non-0 historical sales for 1 st to 31 st of the last year are [3, 5, 6, 6, 3, 5 ]. From these historical ex-warehouse data 102, a reference data set 103 may be generated, such as a non-duplicate historical sales amount may be taken as the reference data set [3, 5, 6 ]. Thereafter, the computing device 101 may determine a reference number of inventory turnaround days for the filter over the past year based on each reference data in the reference data set 103, resulting in a plurality of reference inventory turnaround days 104. For example, the number of turnaround days calculated from historical sales of 3 is 182.5; the number of turnaround days calculated from the historical sales of 5 was 114.06; the number of turnaround days calculated from historical sales of 6 was 78.21. Next, the computing device 101 may select a reference inventory turnaround number of days (e.g., 78.21 turnaround days) from the plurality of reference inventory turnaround days 104 as the target inventory turnaround number of days 105 based on the target turnaround threshold (e.g., 120 days). The computing device 101 may then determine the value of the reference data corresponding to the target inventory turnaround number 105, such as 6 for historical sales corresponding to turnaround number 78.21, as the target inventory amount 106 for the filter. Optionally, as shown in fig. 1, the computing device 101 may also output the determined target inventory amount 106. For example, it may be sent to a terminal used by the user for display, or may be stored in a data information table corresponding to the filter.
The computing device 101 may be hardware or software. When the computing device is hardware, it may be implemented as a distributed cluster composed of multiple servers or terminal devices, or may be implemented as a single server or a single terminal device. When the computing device is embodied as software, it may be installed in the hardware devices enumerated above. It may be implemented, for example, as multiple software or software modules to provide distributed services, or as a single software or software module. And is not particularly limited herein.
It should be understood that the number of computing devices in FIG. 1 is merely illustrative. There may be any number of computing devices, as implementation needs dictate.
With continued reference to fig. 2, a flow 200 of some embodiments of an inventory determination method according to the present disclosure is shown. The method comprises the following steps:
In some embodiments, an executing agent (e.g., a server) of the inventory determination method may generate the reference data set based on historical ex-warehouse data for the target item over a set period of time. The target article may be any article, such as an intermittent low-cost article, i.e., an article characterized by a relatively low single-time delivery and a relatively long delivery interval. The set time period may be any historical time period, such as the past month, quarter, year, or the like.
It will be appreciated that there is generally no reference value for data with a zero historical destage. Therefore, the execution subject can screen out data with a non-zero out-of-stock amount, and thus take the data as reference data. For example, the non-zero ex-warehouse volume for a filter in the last year is [3, 3, 5, 6, 6, 3 ]. The reference data set thus obtained may be [3, 3, 5, 6, 6, 3 ].
Optionally, the execution subject may perform statistical analysis on the filtered historical ex-warehouse data, and further select an ex-warehouse quantity with a repetition number greater than a set number. The selected ex-warehouse quantities can then be used as reference data to obtain a reference data set. For example, the executive may screen out the amount of ex-warehouse with a number of iterations greater than 1, thereby resulting in a reference data set [3, 6 ]. This can eliminate contingency, and thus obtain the warehouse-out quantity of the target object under the general condition, namely the normal warehouse-out quantity. It is helpful to improve the accuracy and reliability of the generated reference data set.
In some embodiments, to improve the comprehensiveness and diversity of data, the execution subject may select a historical warehouse-out amount greater than a set value (e.g., 0) from the historical warehouse-out data. Then, the selected historical ex-warehouse quantity can be subjected to de-duplication processing, so that a reference data set is obtained. For example, the non-zero ex-warehouse volume of a certain filter in the last year is [3, 5, 6, 6, 3, 5], and the reference data set obtained after deduplication processing is [3, 5, 6 ].
In some embodiments, the execution principal may receive an identification (e.g., SKU (Stock Keeping Unit) code) of the item sent by the user, and may determine the item indicated by the identification as the target item. Alternatively, the performing agent may determine the target item by: firstly, analyzing historical ex-warehouse data of each article, and determining the ex-warehouse times and the total ex-warehouse quantity of each article within a certain time; then, the articles whose number of times of delivery is less than the set number of times (e.g., 24 times) and whose total amount of delivery is less than the set amount of delivery (e.g., 50) may be determined as the target articles.
In some embodiments, based on each reference data in the reference data set, the executive body may determine a reference number of inventory turnaround days for the target item within a set time period, resulting in a plurality of reference inventory turnaround days. The set time period may be the set time period or an arbitrary time period within the set time period.
In some embodiments, for each reference datum in the reference dataset, first, the executive agent may determine the total inventory amount of the target item over a set period of time using the reference datum as the daily inventory amount of the target item. Then, according to the daily inventory and the historical ex-warehouse data, the total ex-warehouse quantity of the target object in the set time period can be determined. Then, based on the total inventory amount and the total amount of ex-warehouse, the reference inventory turnover days of the target item in the set time period under the daily inventory amount can be determined.
As an example, reference data set [3, 5, 6] is taken as an example. When the daily stock amount is 3, the total stock amount of the target item in one year is 365 × 3= 1095. And the non-zero ex-warehouse quantity of the target item in the last year is [3, 5, 6, 6, 3, 5], and then the total ex-warehouse quantity in the last year can be determined to be 3+3= 6. In this case, the reference inventory turnaround days is 1095 ÷ 6= 182.5. It will be appreciated that an item will only be delivered if the current delivery (sales) is less than or equal to the current inventory. It can be seen that if the daily stock is 3, and the customer needs 5 or 6, the goods will not be delivered. By analogy, when the daily stock is 5, the total stock in one year is 1825, and the total stock out is 16. The reference inventory turnover number at this time is 114.06. When the daily stock amount is 6, the total stock amount in one year is 2190, and the total stock discharge amount is 28. The reference inventory turnaround time at this time was 78.21.
Alternatively, first, the execution subject may determine an average value of each reference data in the reference data set. Then, reference data not greater than the average value may be selected from the reference data set as candidate reference data. Then, based on each candidate reference data, the executive agent may determine a reference inventory turnaround day for the target item within a set time period using the method described above.
Further, the executive body may also determine a reference inventory turnaround number of days of the target item within a set time period, in case of an average value, to join the plurality of reference inventory turnaround numbers of days. Here, the average value is usually a rounded value. The manner of rounding is not limited herein.
It will be appreciated that the items are not normally delivered immediately after delivery, and thus the total inventory may be higher. Thus, in some embodiments, when referring to the number of inventory turnaround days based on the total inventory amount and the total ex-warehouse amount, the executing agent may determine the product of the quotient of the two and the coefficient as the reference number of inventory turnaround days. The coefficient here may be a value greater than 0 and less than 1, for example, may be 0.9. In this way, the accuracy of the determination result of the number of turnaround days is improved.
And 203, selecting reference inventory turnover days from a plurality of reference inventory turnover days according to the target turnover threshold value to serve as the target inventory turnover days.
In some embodiments, the executive may select a reference inventory turnover number of days from a plurality of reference inventory turnover numbers of days as the target inventory turnover number of days, according to the target turnover threshold. Here, the target turnaround threshold may be set according to actual circumstances. And the manner of selection is not limiting. As an example, the executive may choose the reference inventory turnaround number of days that is closest to the target turnaround threshold. For example, if the target turnover threshold is 120, 114.06 may be selected as the target number of inventory turnover days from the three reference numbers of inventory turnover days 182.5, 114.06, and 78.21.
In some embodiments, for each reference inventory turnaround day of the plurality of reference inventory turnaround days, first, the executive may compare the reference inventory turnaround day to a target turnaround threshold. If the reference inventory turnaround number of days is less than or equal to a target turnaround threshold, then the reference inventory turnaround number of days is added to the first set. If the reference inventory turnaround number of days is greater than the target turnaround threshold, the reference inventory turnaround number of days may be added to the second set. Thereafter, the execution principal may determine whether the first set is empty. If it is determined not to be empty, a reference inventory turnaround time may be selected from the first set. If determined to be empty, a reference inventory turnaround number of days may be selected from the second set.
Here again, the manner of selection is not limiting. For example, the largest number of reference inventory turnaround days may be selected from the first set. For another example, the reference number of inventory turnaround days with the smallest value may be selected from the second set.
Optionally, in order to reduce the inventory cost and meet the user requirement as much as possible, the reference inventory turnover number of days with the maximum corresponding historical ex-warehouse quantity (reference data) value may be selected. I.e. to increase the satisfaction rate. The satisfaction rate here is usually a piece number satisfaction rate, and if the demand is 10 pieces and the stock is only 5 pieces, the satisfaction rate is 50%. As an example, the target turnover threshold is 120 and the plurality of reference inventory turnover days is 182.5, 114.06, 78.21. At this point, 114.06, 78.21 may be determined to be the first set and 182.5 to be the second set. Since there is data in the first set, i.e. it is not empty, it can be selected from the first set. And because 114.06 corresponds to a reference of 5 and 78.21 corresponds to a reference of 6. Thus, 78.21 may be determined as the target inventory turnaround days. For another example, if the target turnaround threshold is 70, then 182.5, 114.06, 78.21 may all be determined to be the second set. Since there is no data in the first set, it is empty. At which point it needs to be selected from the second set. In order to reduce the inventory cost as much as possible, the reference inventory turnover number of days with the smallest corresponding historical ex-warehouse quantity (reference data) value can be selected. I.e. 182.5 (corresponding to reference data of 3) is determined as the target inventory turnaround number of days.
And step 204, determining the value of the reference data corresponding to the target inventory turnover days as the target inventory quantity of the target article, and outputting the target inventory quantity.
In some embodiments, based on the target number of inventory turnaround days determined in step 203, the executive agent may determine a value of the reference data corresponding to the target number of inventory turnaround days as the target inventory quantity of the target item. As an example, for the above example, the executing entity may determine the reference data 6 as the target inventory amount of the target item, i.e., determine the target inventory level as 6. In addition, the execution principal may also output a target inventory amount of the target item. The output mode here is not limited. For example, the target inventory amount may be displayed, and may be sent to other electronic devices (e.g., a database or a terminal) for data storage or display, etc.
Some embodiments of the present disclosure provide an inventory determination method that may determine a target inventory level based on historical ex-warehouse data. And the target inventory level will generally not exceed the maximum of the historical shipment. Therefore, the requirement of the user can be met, and the inventory holding cost and the storage space of an enterprise can be reduced. Particularly for low pin items.
With continued reference to FIG. 3, a flow 300 of further embodiments of an inventory determination method according to the present disclosure is shown. The method comprises the following steps:
Step 302, based on each reference data in the reference data set, determining reference inventory turnover days of the target item in a set time period, obtaining a plurality of reference inventory turnover days.
And 303, selecting reference inventory turnover days from the reference inventory turnover days according to the target turnover threshold value to serve as the target inventory turnover days.
And step 304, determining the value of the reference data corresponding to the target inventory turnover days as the target inventory quantity of the target article, and outputting the target inventory quantity.
In some embodiments, the processes of step 301 to step 304 may refer to the related descriptions of step 201 to step 204 in the embodiment of fig. 2, and are not described herein again.
And 305, determining whether to replenish the target item according to the comparison result of the inventory data of the target item and the target inventory amount.
In some embodiments, based on the target inventory amount determined in step 304, the performing entity of the inventory determination method may determine whether to restock the target item. As an example, when a replenishment cycle is reached, such as a replenishment statistic being performed once per week, the executive may compare the inventory data of the target item with the target inventory amount. If the quantity is less than the target inventory quantity, the target article needs to be replenished. Otherwise, the replenishment is not needed.
In some embodiments, when determining that replenishment is required, the execution subject may determine the replenishment amount of the target item according to the inventory data and the target inventory amount. For example, the difference between the target stock quantity and the stock quantity may be determined as the replenishment quantity.
It will be appreciated that the inventory data may include not only stock-in-stock, but sometimes also acquired (i.e., in-transit or purchased). In this case, the replenishment quantity may be a difference between the target stock quantity and the stock quantity of the spot stock, the acquired quantity. I.e. the already obtained amount also needs to be removed.
Further, in the case where the replenishment quantity is determined, the execution subject may also generate replenishment information. The replenishment information can be used for representing replenishment of the target object. As an example, the replenishment information may include at least one of: identification information of the target item, the replenishment quantity, the acquisition unit name (or identification), the arrival time, and the like. Here, the execution body may transmit the replenishment information to a terminal device used by the user to make the user perform the purchase replenishment. Alternatively, the execution body may directly send the purchase order to the supplier of the target item, thereby forming a purchase order and realizing replenishment of the target item.
Some embodiments of the present disclosure provide inventory determination methods that further enrich and refine the replenishment process. The user can replenish the item according to the replenishment quantity determined by the user. The method does not depend on model prediction, and can provide more reasonable replenishment quantity. In this way, a guiding reference can be formed for the daily inventory management of the enterprise. It is possible to surely satisfy the customer's demand and to contribute to the reduction of the inventory holding cost.
With further reference to fig. 4, as an implementation of the methods illustrated in fig. 2 and 3 described above, the present disclosure provides some embodiments of an inventory determination device, which correspond to those illustrated in fig. 2 and 3, and which may be particularly applicable in various electronic devices.
As shown in fig. 4, the inventory determination device 400 of some embodiments may include: a generating unit 401 configured to generate a reference data set according to historical ex-warehouse data of the target item within a set time period; a number-of-days determination unit 402 configured to determine, based on each reference data in the reference data set, a reference inventory turnaround number of days of the target item within a set time period, resulting in a plurality of reference inventory turnaround days; a selecting unit 403 configured to select reference inventory turnaround days from a plurality of reference inventory turnaround days as target inventory turnaround days according to a target turnaround threshold; a stock quantity determining unit 404 configured to determine a value of the reference data corresponding to the target stock turnaround days as a target stock quantity of the target item, and output the target stock quantity.
In some embodiments, the number of days determining unit 402 may be further configured to determine a total inventory amount of the target item over a set period of time using the reference data as a daily inventory amount of the target item; determining the total ex-warehouse quantity of the target object in a set time period according to the daily inventory and historical ex-warehouse data; and determining reference inventory turnover days of the target object in a set time period under the daily inventory based on the total inventory and the total ex-warehouse quantity.
In some embodiments, the choosing unit 403 may be further configured to compare, for each reference inventory turnover number of days of a plurality of reference inventory turnover days, the reference inventory turnover number of days with a target turnover threshold, add to the first set if less than or equal to the target turnover threshold, and add to the second set if greater than the target turnover threshold; determining whether the first set is empty; in response to determining not to be empty, a reference inventory turnaround number of days is selected from the first set.
In some embodiments, the selecting unit 403 may be further configured to select a reference number of inventory turnaround days from the second set in response to determining to be empty.
In some embodiments, the apparatus 400 may further include a restocking determination unit (not shown in fig. 4) configured to determine whether to restock the target item according to a comparison result of the inventory data of the target item and the target inventory amount; in response to determining to restock, a restock amount of the target item is determined, and restock information is generated.
In some embodiments, the inventory data may include stock in stock and acquired quantities; and the replenishment determination unit may be further configured to determine a difference between the target stock quantity and the stock-in-stock quantity, the acquired quantity, as the replenishment quantity of the target item.
In some embodiments, the generating unit 401 may be further configured to select a history ex-warehouse quantity greater than a set value from the history ex-warehouse data; and carrying out duplicate removal processing on the selected historical ex-warehouse quantity to obtain a reference data set.
In some embodiments, the apparatus 400 may further include a target item determination unit (not shown in fig. 4) configured to analyze the historical ex-warehouse data of the items, determine the number of ex-warehouses and the total ex-warehouse quantity of the items within a certain time period; and determining the articles with the delivery times less than the set times and the total delivery amount less than the set delivery amount as target articles.
It will be appreciated that the units described in the apparatus 400 correspond to the various steps in the method described with reference to figures 2 and 3. Thus, the operations, features and advantages described above with respect to the method are also applicable to the apparatus 400 and the units included therein, and are not described herein again.
Referring now to fig. 5, a block diagram of an electronic device (e.g., a server) 500 suitable for use in implementing some embodiments of the present disclosure is shown. The electronic device shown in fig. 5 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.
As shown in fig. 5, electronic device 500 may include a processing means (e.g., central processing unit, graphics processor, etc.) 501 that may perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM) 502 or a program loaded from a storage means 508 into a Random Access Memory (RAM) 503. In the RAM 503, various programs and data necessary for the operation of the electronic apparatus 500 are also stored. The processing device 501, the ROM 502, and the RAM 503 are connected to each other through a bus 504. An input/output (I/O) interface 505 is also connected to bus 504.
Generally, the following devices may be connected to the I/O interface 505: input devices 506 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; output devices 507 including, for example, speakers, vibrators, and the like; storage devices 508 including, for example, magnetic tape, hard disk, etc.; and a communication device 509. The communication means 509 may allow the electronic device 500 to communicate with other devices wirelessly or by wire to exchange data. While fig. 5 illustrates an electronic device 500 having various means, it is to be understood that not all illustrated means are required to be implemented or provided. More or fewer devices may be alternatively implemented or provided. Each block shown in fig. 5 may represent one device or may represent multiple devices as desired.
In particular, according to some embodiments of the present disclosure, the processes described above with reference to the flow diagrams may be implemented as computer software programs. For example, some embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer-readable medium, the computer program comprising program code for performing the method illustrated by the flow chart. In some such embodiments, the computer program may be downloaded and installed from a network via the communication means 509, or installed from the storage means 508, or installed from the ROM 502. The computer program, when executed by the processing device 501, performs the above-described functions defined in the methods of some embodiments of the present disclosure.
It should be noted that the computer readable medium described in some embodiments of the present disclosure may be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In some embodiments of the disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In some embodiments of the present disclosure, however, a computer readable signal medium may include a propagated data signal with computer 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 signal medium may also be any computer readable medium that is not a computer 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 medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (radio frequency), etc., or any suitable combination of the foregoing.
In some embodiments, the clients, servers may communicate using any currently known or future developed network Protocol, such as HTTP (HyperText Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the Internet (e.g., the Internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed network.
The computer readable medium may be embodied in the electronic device; or may exist separately without being assembled into the electronic device. The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: generating a reference data set according to historical ex-warehouse data of the target object in a set time period; determining reference inventory turnover days of the target object in a set time period based on each reference data in the reference data set to obtain a plurality of reference inventory turnover days; selecting reference inventory turnover days from a plurality of reference inventory turnover days according to a target turnover threshold value, and taking the reference inventory turnover days as target inventory turnover days; and determining the value of the reference data corresponding to the target inventory turnover days as the target inventory quantity of the target article, and outputting the target inventory quantity.
Furthermore, computer program code for carrying out operations for embodiments of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems that perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in some embodiments of the present disclosure may be implemented by software or hardware. The described units may also be provided in a processor, and may be described as: a processor includes a generating unit, a number-of-days determining unit, a selecting unit, and an inventory amount determining unit. Where the names of these units do not in some cases constitute a limitation on the unit itself, for example, a generating unit may also be described as a "unit that generates a reference data set from historical ex-warehouse data for a target item over a set period of time".
The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), system on a chip (SOCs), Complex Programmable Logic Devices (CPLDs), and the like.
The foregoing description is only exemplary of the preferred embodiments of the disclosure and is illustrative of the principles of the technology employed. It will be appreciated by those skilled in the art that the scope of the invention in the embodiments of the present disclosure is not limited to the specific combination of the above-mentioned features, but also encompasses other embodiments in which any combination of the above-mentioned features or their equivalents is made without departing from the inventive concept as defined above. For example, the above features and (but not limited to) technical features with similar functions disclosed in the embodiments of the present disclosure are mutually replaced to form the technical solution.
Claims (11)
1. An inventory determination method, comprising:
generating a reference data set according to historical ex-warehouse data of the target object in a set time period;
determining reference inventory turnover days of the target object in the set time period based on each reference data in the reference data set to obtain a plurality of reference inventory turnover days;
selecting reference inventory turnover days from the reference inventory turnover days as target inventory turnover days according to a target turnover threshold;
and determining the value of the reference data corresponding to the target inventory turnover days as the target inventory of the target article, and outputting the target inventory.
2. The method of claim 1, wherein the determining a reference inventory turnaround number of days for the target item within the set time period based on each of the reference data sets comprises:
determining the total inventory quantity of the target item in the set time period by taking the reference data as the daily inventory quantity of the target item;
determining the total ex-warehouse quantity of the target object in the set time period according to the daily inventory and the historical ex-warehouse data;
and determining reference inventory turnover days of the target item in the set time period under the daily inventory quantity based on the inventory quantity and the total quantity of the delivered goods.
3. The method of claim 1, wherein the selecting a reference number of inventory turnaround days from the plurality of reference inventory turnaround days according to a target turnaround threshold comprises:
for each reference inventory turnaround day of the plurality of reference inventory turnaround days, comparing the reference inventory turnaround day of times to a target turnaround threshold, and if less than or equal to the target turnaround threshold, adding to a first set, and if greater than the target turnaround threshold, adding to a second set;
determining whether the first set is empty;
in response to determining not to be empty, a reference inventory turnaround number of days is selected from the first set.
4. The method of claim 3, wherein the selecting a reference number of inventory turnaround days from the plurality of reference inventory turnaround days according to a target turnaround threshold further comprises:
in response to determining to be empty, a reference number of inventory turnaround days is selected from the second set.
5. The method of claim 1, wherein the method further comprises:
determining whether to replenish the target object or not according to a comparison result of the inventory data of the target object and the target inventory amount;
in response to determining to restock, determining a restock amount of the target item, and generating restock information.
6. The method of claim 5, wherein the inventory data includes stock in stock and acquired quantities; and
the determining the replenishment quantity of the target item comprises:
and determining the difference value between the target inventory, the spot inventory and the obtained quantity as the replenishment quantity of the target object.
7. The method of claim 1, wherein the generating a reference data set from historical ex-warehouse data for the target item over a set period of time comprises:
selecting historical ex-warehouse quantity larger than a set value from the historical ex-warehouse data;
and carrying out duplicate removal processing on the selected historical ex-warehouse quantity to obtain a reference data set.
8. The method of any one of claims 1-7, wherein the target item is determined by:
analyzing historical ex-warehouse data of the articles, and determining the ex-warehouse times and the total ex-warehouse quantity of the articles within a certain time;
and determining the articles with the warehouse-out times smaller than the set times and the total warehouse-out amount smaller than the set warehouse-out amount as the target articles.
9. An inventory determination device, comprising:
the generating unit is configured to generate a reference data set according to historical ex-warehouse data of the target object in a set time period;
a number-of-days determination unit configured to determine a reference inventory turnaround number of days of the target item within the set time period based on each reference data in the reference data set, resulting in a plurality of reference inventory turnaround days;
a selecting unit configured to select a reference inventory turnover number of days from the plurality of reference inventory turnover numbers of days as a target inventory turnover number of days according to a target turnover threshold;
a stock quantity determining unit configured to determine a value of the reference data corresponding to the target stock turnaround days as a target stock quantity of the target item, and output the target stock quantity.
10. An electronic device, comprising:
one or more processors;
a storage device having one or more programs stored thereon,
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-8.
11. A computer-readable medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210683333.3A CN114781981A (en) | 2022-06-17 | 2022-06-17 | Inventory determination method, device, electronic equipment and computer readable medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210683333.3A CN114781981A (en) | 2022-06-17 | 2022-06-17 | Inventory determination method, device, electronic equipment and computer readable medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114781981A true CN114781981A (en) | 2022-07-22 |
Family
ID=82422125
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210683333.3A Pending CN114781981A (en) | 2022-06-17 | 2022-06-17 | Inventory determination method, device, electronic equipment and computer readable medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114781981A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170330001A1 (en) * | 2014-12-02 | 2017-11-16 | Nexess | Inventory system for objects contained in a space bounded by an enclosure as well as an inventory method implemented by such an inventory system |
| CN112529491A (en) * | 2020-10-26 | 2021-03-19 | 杉数科技(北京)有限公司 | Inventory management method and device |
| CN113780912A (en) * | 2020-09-21 | 2021-12-10 | 北京京东乾石科技有限公司 | Method and device for determining safety stock |
-
2022
- 2022-06-17 CN CN202210683333.3A patent/CN114781981A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170330001A1 (en) * | 2014-12-02 | 2017-11-16 | Nexess | Inventory system for objects contained in a space bounded by an enclosure as well as an inventory method implemented by such an inventory system |
| CN113780912A (en) * | 2020-09-21 | 2021-12-10 | 北京京东乾石科技有限公司 | Method and device for determining safety stock |
| CN112529491A (en) * | 2020-10-26 | 2021-03-19 | 杉数科技(北京)有限公司 | Inventory management method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112184348B (en) | Order data processing method, device, electronic equipment and medium | |
| US20160283881A1 (en) | System and method for forecast driven replenishment of merchandise | |
| CN112036802B (en) | Article replenishment information display method and device, electronic equipment and readable medium | |
| CN113095893A (en) | Method and device for determining sales of articles | |
| US20210224351A1 (en) | Method and system for optimizing an objective having discrete constraints | |
| CN113537861B (en) | Goods supplementing method and goods supplementing device | |
| CN111325587A (en) | Method and apparatus for generating information | |
| CN116109252A (en) | Warehouse replenishment management method and device, warehouse management system and storage medium | |
| CN112102043B (en) | Item recommendation page generation method and device, electronic equipment and readable medium | |
| CN110895761A (en) | Method and device for processing after-sale service application information | |
| CN112258104A (en) | Transfer information generation method, article transfer method, apparatus, device and medium | |
| US20130103456A1 (en) | Method, system and program storage device for production planning | |
| CN112862415B (en) | Transportation vehicle scheduling method and device, electronic equipment and computer readable medium | |
| US20050049909A1 (en) | Manufacturing units of an item in response to demand for the item projected from page-view data | |
| CN114781981A (en) | Inventory determination method, device, electronic equipment and computer readable medium | |
| CN105940418B (en) | System and method for managing additional calendar periods in retail | |
| CN113902383A (en) | Inventory processing method, device, equipment and storage medium based on e-commerce platform | |
| CN111932191A (en) | Shelf scheduling method and device, electronic equipment and computer readable medium | |
| CN110084541B (en) | Method and apparatus for predicting supplier delivery duration | |
| CN109902847B (en) | Method and device for predicting amount of orders in branch warehouse | |
| CN114444990A (en) | Product selection method for supply chain network front-end bin | |
| CN112183969A (en) | Payment equipment operation control method and device for supply order and electronic equipment | |
| CN113283829A (en) | Cost information determination method and device, electronic equipment and computer readable medium | |
| Alotaibi et al. | Queuing system for different classes of customers | |
| CN111047242B (en) | Inventory difference monitoring method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |