Supplier inventory management method and system
By calculating the target evaluation value and weighted average method, inventory management is optimized, and the problems of high inventory management costs and poor adaptability to demand changes in the existing technology are solved, and more accurate inventory volume and lower inventory costs are achieved.
Patent Information
- Application Number
- CN202411463430.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-21
- Publication Date
- 2024-11-15
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
The existing technology is difficult to effectively manage inventory, resulting in high inventory costs and difficult to adapt to changes in market demand, resulting in supply difficulties or inventory pressure.
By obtaining the historical daily sales volume and sales price of the target product, calculating the target evaluation value, determining the weight, and weighting the sales volume on multiple historical dates, obtaining the target inventory, and then managing inventory, considering the sales price to the sales volume Influence and optimize stocking volume.
It has achieved more accurate management of target commodity inventory, reduced stocking costs, improved supply capacity, and adapted to changes in market demand.
Smart Images

Figure CN118966980A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of inventory management, and in particular to a supplier inventory management method and system. Background Art
[0002] In the field of e-commerce, warehouses are used to circulate the goods being sold. For example, in order to shorten the delivery cycle of goods, the delivered goods are pre-placed in a warehouse in the city where the consumer is located. In order to reduce inventory costs while ensuring that the goods stored in the warehouse can be effectively supplied, the inventory of goods can be managed so that the inventory volume of goods is in line with market demand.
[0003] In order to achieve the management of the inventory of goods, a method for processing inventory data is provided in the relevant technology, for example, in the Chinese patent application document with publication number CN117592907A, including: obtaining historical inventory data, wherein the historical inventory data includes inventory data collected in at least one historical period; determining the demand index for each historical period based on the historical inventory data, wherein the demand index is used to characterize the average inventory demand for each historical period; predicting the inventory demand for the next period of the current period based on the demand index; determining the safety stock level based on the inventory demand and the required service level, wherein the service level is used to characterize the expected probability of meeting user needs, and the safety stock level is used to characterize the safety stock data required for the next period under the service level; adjusting the actual inventory data based on the safety stock level and the actual inventory level, wherein the actual inventory level is used to characterize the actual inventory data collected in the current period.
[0004] In the related art, the predicted inventory demand is obtained based on historical inventory data, but the historical inventory data may be difficult to adapt to the actual inventory demand. The cost of storing goods in the warehouse is high, making it difficult to achieve effective management of the inventory. Summary of the invention
[0005] In order to overcome the problem in related technologies that it is difficult to achieve effective management of inventory, the present application provides a supplier inventory management method and system.
[0006] According to a first aspect of an embodiment of the present application, a supplier inventory management method is provided, including: obtaining the historical daily sales volume and the historical sales price of a target commodity on a historical date; determining a target evaluation value of the target commodity on a historical date based on the historical daily sales volume and the historical sales price, the target evaluation value being used to characterize the degree of influence of the historical sales price of the target commodity on the historical date on the historical daily sales volume; determining a weight corresponding to the target commodity on the historical date based on the target evaluation value of the target commodity on the historical date, the weight being positively correlated with the target evaluation value; taking a weighted average of the historical daily sales volumes of the target commodity on multiple historical dates through the weight corresponding to the target commodity on the historical date to obtain a target stocking quantity of the target commodity on the target date; and managing the inventory of the target commodity in the target warehouse based on the target stocking quantity of the target commodity.
[0007] In this way, through the weight corresponding to the target commodity on the historical date, the historical daily sales volume of the target commodity on multiple historical dates is weighted averaged to obtain the target stocking quantity of the target commodity on the target date, and the inventory of the target commodity in the target warehouse is managed according to the target stocking quantity of the target commodity; because the weight is determined according to the target evaluation value of the target commodity on the historical date, and the target evaluation value is used to characterize the degree of influence of the historical sales price of the target commodity on the historical date on the historical daily sales volume, therefore, when managing the inventory of the target commodity, the degree of influence of the sales price on the sales volume is taken into account, which helps to determine a more accurate target stocking quantity for the target commodity, thereby achieving more effective management of the inventory of the target commodity.
[0008] Optionally, determining the target evaluation value of the target commodity on a historical date based on the historical daily sales volume and the historical sales price includes: determining, for a target historical date among multiple historical dates, the first percentile of the historical inventory of the target commodity on the target historical date among all historical inventory quantities, and the second percentile of the historical daily sales of the target commodity on the target historical date among all historical daily sales volumes; determining the third percentile of the historical sales price of the target commodity on the historical date among all historical sales prices; and determining the target evaluation value of the target commodity on the historical date based on the first percentile, the second percentile and the third percentile.
[0009] In this way, the first percentile, the second percentile and the third percentile respectively represent different information related to the sales information of the target product. Through the first percentile, the second percentile and the third percentile, the target evaluation value of the target product on the historical date can be determined, and the target evaluation value can be used to characterize the degree of influence of the sales price of the target product on the historical date on the historical daily sales volume.
[0010] Optionally, determining the target evaluation value of the target product on the historical date based on the first percentile, the second percentile and the third percentile includes: subtracting the first percentile from the second percentile and taking the absolute value to obtain a first calculation value; subtracting the first percentile from a first preset value to obtain a first difference, and subtracting the first difference from the third percentile and taking the absolute value to obtain a second calculation value; multiplying the first calculation value by the second operation to obtain a first multiplication value, and using the inverse of the exponential operation result of the first multiplication value as the first evaluation value, so as to determine the target evaluation value based on the first evaluation value.
[0011] In this way, the target evaluation value is determined based on the first calculation value and the second calculation value. The first calculation value can characterize the difference between sales volume and inventory quantity, and reflect the impact of sales price on sales volume from the side. The second calculation value can characterize the impact of sales price on inventory quantity. Therefore, the target evaluation value can better characterize the impact of sales price on sales volume, thereby providing a reference for the inventory of target products.
[0012] Optionally, determining the target evaluation value based on the first evaluation value includes: determining multiple first evaluation values corresponding to multiple other commodities on a historical date, wherein the other commodities are commodities in the target warehouse that are similar in commodity type to the target commodity; determining a first difference value between the target commodity and the other commodities in the corresponding first evaluation values, and determining a first sum of the multiple first difference values; adding the first sum and a second preset value to obtain a first sum value, and taking the ratio of the first evaluation value corresponding to the historical date to the first sum value as the target evaluation value corresponding to the historical date.
[0013] In this way, by using multiple first evaluation values corresponding to multiple commodities on historical dates, other commodities are commodities of similar commodity types to the target commodity, and the first evaluation values of other commodities can provide a better reference for the sales of the target commodity, so as to determine a more accurate target evaluation value.
[0014] Optionally, determining the target evaluation value based on the first evaluation value includes: obtaining a second difference value in historical daily sales volume between the target product on a historical date and other dates, and determining a second sum of multiple second difference values corresponding to multiple other dates; obtaining the maximum stock quantity and the minimum stock quantity among the historical stock quantities of the target product on multiple historical dates, determining a third difference value between the historical stock quantity and the maximum stock quantity of the target product on the historical date, and a fourth difference value between the historical stock quantity and the minimum stock quantity of the target product on the historical date; determining the smallest of the third difference value and the fourth difference value, and multiplying the smallest by the second sum to obtain a second multiplication value, so that the inverse of the exponential operation result of the second multiplication value is used as the target evaluation value.
[0015] In this way, the target evaluation value of the target commodity on the historical date can be determined based on the difference between the historical daily sales volume of the target commodity on the historical date and the historical daily sales volume on other dates. The historical daily sales volume on other dates can be used as a reference to determine a more accurate target evaluation value, so as to better characterize the degree of influence of the historical sales price of the target commodity on the historical date on the historical daily sales volume through the target evaluation value.
[0016] Optionally, determining the weight of the target product on the historical date based on the target evaluation value of the target product on the historical date includes: determining the third sum of multiple target evaluation values of the target product on multiple historical dates; and taking the ratio of the target evaluation value of the target product on the historical date to the third sum as the weight of the target product on the historical date.
[0017] In this way, a larger weight can be set for the historical daily sales volume corresponding to the historical date with a larger target evaluation value. The historical daily sales volume corresponding to the larger target evaluation value is more valuable for reference, which helps to obtain a more accurate target stocking quantity and facilitates inventory management for the target products.
[0018] Optionally, the inventory of the target commodity in the target warehouse is managed according to the target stocking quantity of the target commodity, including: obtaining the current inventory of the target commodity in the target warehouse; when the current inventory is less than the target stocking quantity, transferring a target quantity of the target commodity from other warehouses except the target warehouse to the target warehouse, the target quantity being determined based on the current inventory and the target stocking quantity.
[0019] According to a second aspect of an embodiment of the present application, a supplier inventory management system is provided, comprising: a processor and a memory, wherein the memory stores computer program instructions, and when the computer program instructions are executed by the processor, the steps of the supplier inventory management method provided in the first aspect of the present application are implemented.
[0020] The technical solution provided by the embodiments of the present application may include the following beneficial effects: by using the weights corresponding to the target commodities on historical dates, the historical daily sales volumes of the target commodities on multiple historical dates are weighted averaged to obtain the target stocking volume of the target commodities on the target date, and the inventory of the target commodities in the target warehouse is managed according to the target stocking volume of the target commodities; since the weights are determined according to the target evaluation values of the target commodities on historical dates, and the target evaluation values are used to characterize the degree of influence of the historical sales prices of the target commodities on historical dates on the historical daily sales volumes, the degree of influence of the sales prices on the sales volumes is taken into account when managing the inventory of the target commodities, which helps to determine a more accurate target stocking volume for the target commodities, thereby achieving more effective management of the inventory of the target commodities.
[0021] It should be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present application. BRIEF DESCRIPTION OF THE DRAWINGS
[0022] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.
[0023] Figure 1 is a flow chart of a supplier inventory management method according to an exemplary embodiment; Figure 2 The diagram is a schematic structural diagram of a supplier inventory management system according to an exemplary embodiment. DETAILED DESCRIPTION
[0024] Here, exemplary embodiments will be described in detail, and examples thereof are shown in the accompanying drawings. When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The implementations described in the following exemplary embodiments do not represent all implementations consistent with the present application.
[0025] First, the application scenario of the embodiment of the present application is briefly introduced. In the application scenario of the present application, in order to reduce the inventory pressure of goods while ensuring the supply of goods, the inventory of goods can be managed; however, in the related art, when managing the inventory of goods, the inventory of goods is managed by relying on the historical inventory of the goods.
[0026] For example, maintaining the inventory level of goods at the average level of the goods' historical inventory level. However, the market demand for goods may be different in different periods. Maintaining the inventory level of goods at the average level of historical inventory level may be difficult to adapt to the market demand for goods. When the market demand for goods increases, supply may become difficult. When the market demand for goods decreases, inventory pressure may increase, making it difficult to achieve effective management of commodity inventory.
[0027] In response to the above technical problems, an embodiment of the present application provides a supplier inventory management method and system, which uses the weights corresponding to the target products on historical dates to perform a weighted average of the historical daily sales volumes of the target products on multiple historical dates to obtain the target stocking quantity of the target products on the target date, and manages the inventory of the target products in the target warehouse according to the target stocking quantity of the target products. Since the weight is determined based on the target evaluation value of the target product on the historical date, and the target evaluation value is used to characterize the degree of influence of the historical sales price of the target product on the historical date on the historical daily sales volume, the degree of influence of the sales price on the sales volume is taken into account when managing the inventory of the target product, which helps to determine a more accurate target stocking quantity for the target product, thereby achieving more effective management of the inventory of the target product.
[0028] Figure 1 is a flow chart of a supplier inventory management method according to an exemplary embodiment. The supplier inventory management method provided in the embodiment of the present application can be applied to a terminal device for managing the inventory of goods, such as Figure 1 As shown, the method includes the following steps.
[0029] In step S101, the historical daily sales volume and historical sales price of the target commodity on the historical date are obtained.
[0030] The target commodity may be one of multiple commodities in the target warehouse; the sales price of the target commodity may also be different on the same day. In order to reflect the impact of the sales price on the sales volume of the target commodity, the historical sales price of the target commodity on the historical date may be the smallest of the sales prices on the historical date, or the historical sales price of the target commodity on the historical date may be the average of the sales prices on the historical date.
[0031] In one possible implementation, since the target warehouse is usually used to supply the target commodity to users in one or more regions, that is, the target warehouse may govern one or more regions, the historical daily sales volume of the target commodity may refer to the quantity of the target commodity sold to one or more regions under the jurisdiction of the target warehouse within the historical date.
[0032] In step S102, a target evaluation value of the target commodity on a historical date is determined based on the historical daily sales volume and the historical sales price.
[0033] The target evaluation value is used to characterize the degree of influence of the historical sales price of the target commodity on the historical date on the historical daily sales volume.
[0034] The sales volume of a product on a certain day is usually affected by the sales price of that day. For example, if the sales price of a product is reduced due to a promotion, the sales volume of the product may increase; conversely, if the sales price of a product increases, the sales volume of the product may decrease.
[0035] Through the historical sales prices and historical daily sales volumes of the goods on historical dates, it is possible to determine the degree to which the historical daily sales volumes of the target goods on historical dates are affected by the historical sales prices. For example, the larger the target evaluation value, the greater the degree to which the historical daily sales volumes of the target goods on historical dates are affected by the historical sales prices; conversely, the smaller the degree to which the historical daily sales volumes of the target goods on historical dates are affected by the historical sales prices.
[0036] The sales volume of a commodity will directly affect the inventory. The more the historical daily sales volume of a commodity within a historical date is affected by the historical sales price, the more the inventory reduction caused by the sale of the commodity will be affected by the historical sales price. On the contrary, the less the historical daily sales volume of a commodity within a historical date is affected by the historical sales price, the less the inventory reduction caused by the sale of the commodity will be affected by the historical sales price. Therefore, determining a target evaluation value that characterizes the degree of influence of the historical sales price of the target commodity on the historical date on the historical daily sales volume will help manage the inventory of the target commodity.
[0037] In step S103, the weight corresponding to the target product on the historical date is determined according to the target evaluation value of the target product on the historical date.
[0038] In the embodiment of the present application, the weight corresponding to the target commodity on the historical date is positively correlated with the target evaluation value of the target commodity on the historical date; wherein, the larger the target evaluation value of the target commodity on the historical date, the more likely the historical daily sales volume of the target commodity is to conform to the sales law, and the more reference value the historical daily sales volume of the target commodity has for warehouse stocking; on the contrary, the smaller the target evaluation value of the target commodity on the historical date, the less likely the historical daily sales volume of the target commodity is to conform to the sales law, and the less reference value the historical daily sales volume of the target commodity has for warehouse stocking.
[0039] In one embodiment, the weight of the target product on the historical date is determined based on the target evaluation value of the target product on the historical date, including: determining the third sum of multiple target evaluation values of the target product on multiple historical dates; and using the ratio of the target evaluation value of the target product on the historical date to the third sum as the weight of the target product on the historical date.
[0040] The ratio of the target evaluation value to the third total can reflect the degree to which the historical daily sales volume of the target commodity on the historical date is affected by the historical sales price, as well as the relationship between the degree to which the historical daily sales volume of the target commodity on other historical dates is affected by the historical sales price.
[0041] For example, the larger the ratio of the target evaluation value of the target commodity on the historical date to the third total, the greater the probability that the historical sales price of the target commodity on the historical date has a greater impact on the historical daily sales volume compared to the impact of the historical sales price of the target commodity on other historical dates on the historical daily sales volume, and the target commodity may be more in line with the rule that the sales volume of the commodity is affected by the sales price; therefore, a larger weight is set for the historical daily sales volume corresponding to the historical date with a larger target evaluation value, and the historical daily sales volume corresponding to a larger target evaluation value is more valuable for reference, which helps to obtain a more accurate target stocking quantity and facilitates inventory management for the target commodity.
[0042] In step S104, the target stock quantity of the target product on the target date is obtained by taking a weighted average of the historical daily sales volume of the target product on multiple historical dates according to the weight corresponding to the historical date.
[0043] For example, the historical daily sales volumes of the target product on multiple historical dates are A1, A2, A3, A4 and A5 respectively, and the weights of the target product on multiple historical dates are B1, B2, B3, B4 and B5 respectively. The inventory quantity of the target product on the target date may be equal to R=A1×B1+A2×B2+A3×B3+A4×B4+A5×B5, where R is the inventory quantity of the target product on the target date.
[0044] In step S105, the inventory of the target commodity in the target warehouse is managed according to the target stocking quantity of the target commodity.
[0045] When determining the target stocking quantity of the target commodity, compared with stocking according to the average of historical daily sales, since the target stocking quantity takes into account the impact of the selling price on the sales volume, the target stocking quantity can be closer to the actual demand for the target commodity, thereby reducing the stocking cost of the target commodity.
[0046] In one embodiment, the inventory of the target commodity in the target warehouse is managed according to the target stock quantity of the target commodity, including: obtaining the current inventory of the target commodity in the target warehouse; when the current inventory is less than the target stock quantity, transferring the target quantity of the target commodity from other warehouses except the target warehouse to the target warehouse, the target quantity is determined based on the current inventory and the target stock quantity.
[0047] For example, when the target stock quantity of the target commodity is 100 pieces, if the inventory of the target commodity in the target warehouse is 80 pieces, it means that there is a shortage of 20 pieces in the target warehouse, and it may be difficult to effectively supply the target commodity. The target commodity can be allocated to the target warehouse from other warehouses with surplus of the target commodity; this can not only reduce the inventory pressure of the target commodity in other warehouses with surplus, but also ensure the supply of the target commodity by the target warehouse.
[0048] When the current inventory quantity is less than the target stock quantity, the target quantity may be equal to the difference between the target stock quantity and the current inventory quantity.
[0049] Here, other warehouses with surplus refer to other warehouses whose inventory and target stocking quantity of the target product are greater than the preset quantity threshold. For example, the inventory of the target product in other warehouses is 120 pieces and the target stocking quantity is 40 pieces, and the preset quantity threshold may be 20 pieces. In this case, other warehouses have the ability to allocate the target product to the target warehouse.
[0050] Through the supplier inventory management method provided in the embodiment of the present application, the historical daily sales volumes of the target commodity on multiple historical dates are weighted averaged according to the weights corresponding to the target commodities on historical dates, the target stocking quantity of the target commodity on the target date is obtained, and the inventory of the target commodity in the target warehouse is managed according to the target stocking quantity of the target commodity; since the weight is determined according to the target evaluation value of the target commodity on the historical date, and the target evaluation value is used to characterize the degree of influence of the historical sales price of the target commodity on the historical date on the historical daily sales volume, the degree of influence of the sales price on the sales volume is taken into account when managing the inventory of the target commodity, which helps to determine a more accurate target stocking quantity for the target commodity, thereby achieving more effective management of the inventory of the target commodity.
[0051] In one embodiment, a target evaluation value of a target commodity on a historical date is determined based on historical daily sales volumes and historical sales prices, including: for a target historical date among multiple historical dates, determining the first percentile of a historical inventory of the target commodity on the target historical date among all historical inventory volumes, and the second percentile of a historical daily sales volume of the target commodity on the target historical date among all historical daily sales volumes; determining the third percentile of a historical sales price of the target commodity on the historical date among all historical sales prices; and determining the target evaluation value of the target commodity on the historical date based on the first percentile, the second percentile, and the third percentile.
[0052] Percentile is used to describe the relative position of a value in a data set in the overall data. Percentile means that a specific percentage of data values in the data set is lower than or equal to a certain value. For example, for a specific value corresponding to the 80th percentile in the data set, it means that 80% of the data in the data set are less than or equal to this specific value, and 20% of the data in the data set are greater than this specific value.
[0053] The percentile can be calculated, for example, by sorting the data in the data set in descending order to obtain a sorted sequence, determining the order of the values of the target data in the data set in the sorted sequence, and thus determining the percentile corresponding to the target data.
[0054] The first percentile can describe the ranking information of the target commodity's historical inventory on the target historical date among all historical inventory quantities; the second percentile can describe the ranking information of the target commodity's historical daily sales on the target historical date among all historical daily sales quantities; the third percentile can describe the third percentile of the target commodity's historical sales price on the historical date among all historical sales prices.
[0055] Since the sales volume of a commodity is usually affected by the sales price, the sales volume of a commodity is usually corresponding to the sales price of the commodity. For example, when the sales price of the same commodity is the lowest, the sales volume of the commodity is usually the highest. Conversely, when the sales price of a commodity is the highest, the sales volume of the commodity is usually the lowest. When the inventory of a commodity is the highest, there may be an inventory backlog, which usually corresponds to a lower sales price. Conversely, when the inventory of a commodity is the lowest, there may be an inventory shortage, and the corresponding sales price may also be higher.
[0056] In this way, the first percentile, the second percentile and the third percentile respectively represent different information related to the sales information of the target product. Through the first percentile, the second percentile and the third percentile, the target evaluation value of the target product on the historical date can be determined, and the target evaluation value can be used to characterize the degree of influence of the sales price of the target product on the historical date on the historical daily sales volume.
[0057] In one embodiment, the target evaluation value of the target product on the historical date is determined based on the first percentile, the second percentile and the third percentile, including: subtracting the first percentile from the second percentile and taking the absolute value to obtain a first calculation value; subtracting the first percentile from the first preset value to obtain a first difference, and subtracting the first difference from the third percentile and taking the absolute value to obtain a second calculation value; multiplying the first calculation value by the second operation to obtain a first multiplication value, and using the inverse of the exponential operation result of the first multiplication value as the first evaluation value, so as to determine the target evaluation value based on the first evaluation value.
[0058] The following uses an exemplary calculation formula as an example to explain the calculation process of the first evaluation value in the embodiment of the present application. ; Wherein, N is the target evaluation value of the target product on the historical date, F1 is the first percentile of the historical inventory of the target product on the historical date among all historical inventory, F2 is the second percentile of the historical sales volume of the target product on the historical date among all historical sales, t is the first preset value, and t can be, for example, 1, 2 or 3; F3 is the third percentile of the historical sales price of the target product on the historical date among all historical sales prices, exp is an exponential function with a natural constant as the base, To simplify the process of obtaining the target evaluation value, the first evaluation value may be used as the target evaluation value.
[0059] Here, since the stocking quantity of the target product usually corresponds to the sales volume of the target product, the more the sales volume of the target product, the larger the stocking quantity will be, and the sales volume and stocking quantity of the target product are affected by the sales price. The first percentile is subtracted from the second percentile and the absolute value is taken to obtain the first calculation value. The first calculation value can represent the difference between the sales volume and the stocking quantity of the target product on the historical date. The smaller the difference between the sales volume and the stocking quantity of the target product on the historical date, the more reference value the sales volume of the target product on the historical date has for the stocking of the target product.
[0060] A first difference is obtained by subtracting the first percentile from the first preset value, and a second calculation value is obtained by subtracting the first difference from the third percentile and taking the absolute value. The obtained second calculation value can represent the degree of influence of the sales price on the inventory quantity, or the second calculation value can represent the degree of influence of the inventory quantity on the sales price.
[0061] In this way, the target evaluation value is determined based on the first calculation value and the second calculation value. The first calculation value can characterize the difference between sales volume and inventory quantity, and reflect the impact of sales price on sales volume from the side. The second calculation value can characterize the impact of sales price on inventory quantity. Therefore, the target evaluation value can better characterize the impact of sales price on sales volume, thereby providing a reference for the inventory of target products.
[0062] In one embodiment, determining the target evaluation value based on the first evaluation value includes: determining multiple first evaluation values corresponding to multiple other commodities on a historical date, wherein the other commodities are commodities in a target warehouse that are similar in type to the target commodity; determining a first difference value between the target commodity and the other commodities in the corresponding first evaluation values, and determining a first sum of the multiple first difference values; adding the first sum and a second preset value to obtain a first sum value, and using the ratio of the first evaluation value corresponding to the historical date to the first sum value as the target evaluation value corresponding to the historical date.
[0063] The commodities in the target warehouse that are similar to the target commodity in type may be other commodities with the same commodity usage and product size as the target commodity. For example, when the target commodity is alcohol, alcohol with the same grade and type as the target commodity may be used as other commodities.
[0064] In this way, by using multiple first evaluation values corresponding to multiple commodities on historical dates, other commodities are commodities of similar commodity types to the target commodity, and the first evaluation values of other commodities can provide a better reference for the sales of the target commodity, so as to determine a more accurate target evaluation value.
[0065] The process of obtaining the first evaluation values of other commodities may refer to the process of obtaining the first evaluation value of the target commodity in the embodiment of the present application, and the embodiment of the present application will not be repeated here.
[0066] An exemplary calculation formula is used as an example to explain an exemplary calculation process of determining a target evaluation value according to a first evaluation value in an embodiment of the present application. , where M is the target evaluation value of the target product on the historical date, k is the second preset value, G is the number of types of other products, g is a positive integer less than or equal to G, N is the first evaluation value of the target product on the target date, P g is the first evaluation value of the g-th other commodity on the historical date, For the absolute value operation, the second preset value is used to avoid the situation where the denominator is 0 in the calculation formula of M, and k can be a positive number between 0 and 1.
[0067] In one embodiment, determining the target evaluation value based on the first evaluation value includes: obtaining a second difference value in historical daily sales between a previous historical date and a subsequent historical date among multiple historical dates, and determining a second sum of the multiple second difference values; obtaining the maximum stock quantity and the minimum stock quantity among the historical stock quantities of the target product on multiple historical dates, determining a third difference value between the historical stock quantity and the maximum stock quantity of the target product on the historical date, and a fourth difference value between the historical stock quantity and the minimum stock quantity of the target product on the historical date; determining the smallest of the third difference value and the fourth difference value, and multiplying the smallest by the second sum to obtain a second multiplication value, so that the inverse of the exponential operation result of the second multiplication value is used as the target evaluation value.
[0068] Taking a calculation formula as an example, another method for calculating the target evaluation value in the embodiment of the present application is explained below: ; Wherein, M is the target evaluation value of the target product on the target date in the embodiment of the present application, N is the first evaluation value of the target product on the target date, exp is an exponential function with a natural constant as the base, F is the smallest of the third difference value and the fourth difference value, Q is the number of other dates, and the other dates are other historical dates in the multiple historical dates; a is a positive integer less than Q; K a is the second difference value between the historical daily sales volume of the target product on the historical date and the ath other date. For example, the second difference value may be the absolute value of the difference between the historical daily sales volume of the target product on the historical date and the other dates.
[0069] The third difference value is the difference between the historical stock quantity and the maximum stock quantity of the target product on the historical date. For example, the third difference value may be the absolute value of the difference between the historical stock quantity and the maximum stock quantity of the target product on the historical date. The fourth difference value is the difference between the historical stock quantity and the minimum stock quantity of the target product on the historical date. For example, the fourth difference value may be the absolute value of the difference between the historical stock quantity and the minimum stock quantity of the target product on the historical date.
[0070] In this way, the target evaluation value of the target commodity on the historical date can be determined based on the difference between the historical daily sales volume of the target commodity on the historical date and the historical daily sales volume on other dates. The historical daily sales volume on other dates can be used as a reference to determine a more accurate target evaluation value, so as to better characterize the degree of influence of the historical sales price of the target commodity on the historical date on the historical daily sales volume through the target evaluation value.
[0071] Figure 2 FIG. 1 is a schematic diagram showing a structure of a supplier inventory management system according to an exemplary embodiment. Figure 2The supplier inventory management system 1000 includes: a processor 1100 and a memory 1200, wherein the memory 1200 stores computer program instructions, and when the computer program instructions are executed by the processor 1100, all or part of the steps of the supplier inventory management method in the present application are implemented.
[0072] It should be understood that the features of some embodiments of the various applications described herein may be combined with each other unless specifically stated otherwise.
[0073] Although terms such as "first", "second", and "third" may be used herein to describe various components, parts, regions, layers, or sections, these components, parts, regions, layers, or sections are not limited to these terms. Instead, these terms are only used to distinguish one component, part, region, layer, or section from another component, part, region, layer, or section. Therefore, without departing from the teachings of the examples described herein, the first component, part, region, layer, or section mentioned in the examples may also be referred to as the second component, part, region, layer, or section.
[0074] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include at least one of the features. In the description herein, the meaning of "plurality" is at least two, such as two, three, etc., unless otherwise clearly and specifically defined.
[0075] In addition, the word "exemplary" is used herein to mean serving as an example, instance, or diagram. Any aspect or design described herein as "exemplary" is not necessarily to be understood as being advantageous over other aspects or designs. Instead, the use of the word exemplary is intended to present concepts in a concrete manner. As used herein, the term "or" is intended to mean an inclusive "or" rather than an exclusive "or".
[0076] Likewise, although the present application has been shown and described with respect to one or more implementations, equivalent variations and modifications will occur to those skilled in the art upon reading and understanding this specification and the accompanying drawings. With particular regard to the various functions performed by the components (e.g., elements, resources, etc.) described above, unless otherwise noted, the terms used to describe such components are intended to correspond to any component (functionally equivalent) that performs the specific functions of the described components, even if not structurally equivalent to the disclosed structures.
[0077] Additionally, while particular features of the present application may have been disclosed with respect to only one of several implementations, such features may be combined with one or more other features of other implementations as may be desired and advantageous for any given or particular application.
[0078] Those skilled in the art will readily appreciate other embodiments of the present application after considering the specification and practicing the invention disclosed herein. The present application is intended to cover any modification, use or adaptation of the present application, which follows the general principles of the present application and includes common knowledge or customary technical means in the art that are not disclosed in the present application, and the specification and embodiments are only considered as exemplary.
[0079] It should be understood that the present application is not limited to the exact construction that has been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof.
Claims
1. A supplier inventory management method, characterized in that: include: Get the historical daily sales volume and historical sales price of the target product on historical dates; Determine a target evaluation value of the target commodity on the historical date according to the historical daily sales volume and the historical sales price, wherein the target evaluation value is used to characterize the degree of influence of the historical sales price of the target commodity on the historical date on the historical daily sales volume; Determine the weight of the target product on the historical date according to the target evaluation value of the target product on the historical date, wherein the weight is positively correlated with the target evaluation value; By taking the weight corresponding to the target product on the historical date, the target daily sales volume of the target product on multiple historical dates is weighted averaged to obtain the target stocking volume of the target product on the target date; Manage the inventory of the target goods in the target warehouse according to the target stocking quantity of the target goods.
2. The supplier inventory management method according to claim 1, characterized in that: The step of determining the target evaluation value of the target commodity on the historical date according to the historical daily sales volume and the historical sales price includes: For a target historical date among the multiple historical dates, determine the first percentile of the historical inventory quantity of the target product on the target historical date among all historical inventory quantities, and the second percentile of the historical daily sales quantity of the target product on the target historical date among all historical daily sales quantities; Determine the third percentile of the historical sales price of the target product on the historical date among all historical sales prices; A target evaluation value of the target product on a historical date is determined based on the first percentile, the second percentile, and the third percentile.
3. The supplier inventory management method according to claim 2, characterized in that: Determining the target evaluation value of the target product on the historical date according to the first percentile, the second percentile, and the third percentile includes: Subtract the first percentile from the second percentile and take the absolute value to obtain a first operation value; The first percentile is subtracted from the first preset value to obtain a first difference, and the first difference is subtracted from the third percentile and the absolute value is taken to obtain a second calculated value; The first operation value is multiplied by the second operation value to obtain a first multiplication value, and the reciprocal of the exponential operation result of the first multiplication value is used as a first evaluation value, so as to determine the target evaluation value according to the first evaluation value.
4. The supplier inventory management method according to claim 3, characterized in that: Determining the target evaluation value according to the first evaluation value includes: Determine a plurality of first evaluation values corresponding to a plurality of other commodities on a historical date, wherein the other commodities are commodities in a target warehouse that are similar in commodity type to the target commodity; Determine a first difference value between the target product and other products in the corresponding first evaluation values, and determine a first sum of multiple first difference values; The first sum is added to the second preset value to obtain a first sum value, and the ratio of the first evaluation value corresponding to the historical date to the first sum value is used as the target evaluation value corresponding to the historical date.
5. The supplier inventory management method according to claim 3, characterized in that: Determining the target evaluation value according to the first evaluation value includes: Obtaining a second difference value between the historical daily sales volume of the target product on the historical date and other dates, and determining a second sum of multiple second difference values corresponding to multiple other dates; Obtaining a maximum stock quantity and a minimum stock quantity of the target product among historical stock quantities on multiple historical dates, determining a third difference value between the historical stock quantity of the target product on the historical date and the maximum stock quantity, and a fourth difference value between the historical stock quantity of the target product on the historical date and the minimum stock quantity; The smallest one of the third difference value and the fourth difference value is determined, and the smallest one is multiplied by the second sum to obtain a second multiplication value, and the reciprocal of the exponential operation result of the second multiplication value is used as the target evaluation value.
6. The supplier inventory management method according to claim 1, characterized in that: Determining the weight corresponding to the target product on the historical date according to the target evaluation value of the target product on the historical date includes: Determining a third sum of multiple target evaluation values of the target product on multiple historical dates; The ratio of the target evaluation value of the target product on the historical date to the third sum is used as the weight corresponding to the target product on the historical date.
7. The supplier inventory management method according to claim 1, characterized in that: The managing the inventory of the target commodity in the target warehouse according to the target stocking quantity of the target commodity includes: Get the current inventory of the target product in the target warehouse; When the current inventory is less than the target stocking quantity, a target quantity of target goods is transferred from warehouses other than the target warehouse to the target warehouse, and the target quantity is determined based on the current inventory and the target stocking quantity.
8. A supplier inventory management system, characterized in that: include: A processor and a memory, wherein the memory stores computer program instructions, and when the computer program instructions are executed by the processor, the supplier inventory management method according to any one of claims 1 to 7 is implemented.
Citation Information
Patent Citations
Inventory data processing method and device, storage medium and electronic equipment
CN117592907A
Commodity sales prediction method and device, electronic equipment and readable storage medium
CN111652657A
Sales prediction method and device, storage medium and electronic equipment
CN113743985A
Warehouse replenishment method, device and equipment and computer readable medium
CN117557190A
KR20240117923A
