Safety inventory alarm method for accessories

Abstract

The invention relates to the field of alarm, and discloses a safety inventory alarm method for accessories, which comprises the following steps: acquiring real-time accessory information of each accessory in a plurality of accessories; the inventory in-place total number of each accessory is compared with the alarm threshold value corresponding to each accessory, and if the inventory in-place total number of the accessories is smaller than the alarm threshold value corresponding to the corresponding accessories, inventory alarm information of the corresponding accessories is generated; and comparing the inventory in-place day number of the accessory with the preset validity period day number of the corresponding accessory, and if the inventory in-place day number of the accessory reaches the preset validity period day number of the corresponding accessory, generating immediate alarm information of the corresponding accessory. Therefore, the sufficiency of the inventory in-place total number of each accessory is realized, and adverse effects caused by inventory shortage are avoided.

Description

Technical Field

[0001] The invention relates to the field of alarms, and in particular to a safety inventory alarm method for accessories. Background Art

[0002] Safety stock alarm is a functional module integrated in the ERP (Enterprise Resource Planning) system or warehouse management software. It helps managers make timely adjustment decisions through real-time monitoring and early warning of spare parts inventory.

[0003] The following technical problems often occur during the operation of existing safety stock alarms:

[0004] First, the inventory strategy settings did not meet the actual market demand. Alarms were not issued until the inventory reached a dangerous level, resulting in low processing efficiency, inaccurate alarm information, and increased storage costs. It also led to inventory shortages due to the inability to take timely measures.

[0005] Second, unreasonable inventory strategy configuration parameters lead to inventory shortages, waste of resources, increased costs or capital occupation; when dealing with shortages and backlog crises, procurement plans do not match actual demand and sales strategies lack pertinence; market demand is constantly changing, and not changing relevant parameter values ​​makes it impossible to match the actual situation;

[0006] Third, when a large number of safety stock alarms are triggered, managers face priority conflicts when making decisions, resulting in uneven distribution of attention to spare parts processing and a decrease in overall inventory processing efficiency. Summary of the invention

[0007] The summary of the invention is used to introduce concepts in a brief form, which will be described in detail in the detailed implementation section below. The summary of the invention is not intended to identify the key features or essential features of the technical solution claimed for protection, nor is it intended to limit the scope of the technical solution claimed for protection.

[0008] The present invention proposes a safety inventory alarm method for accessories to solve one or more of the technical problems mentioned in the above background technology part.

[0009] The present invention provides a method for safe inventory alarm for accessories, comprising: obtaining real-time accessory information of each accessory among multiple accessories, the real-time accessory information including accessory name, accessory specification model, accessory code, cumulative inventory quantity, outbound quantity, preset advance alarm days and inventory days; calculating the cumulative inventory quantity and outbound quantity of each accessory among multiple accessories to obtain the total inventory of each accessory; obtaining historical sales data of each accessory among multiple accessories within a target time period, calculating the historical sales data of each accessory to obtain the daily average sales volume corresponding to each accessory; determining the inventory maintenance days corresponding to each accessory according to the daily average sales volume corresponding to each accessory and the preset minimum inventory quantity of the accessory; calculating the inventory maintenance days corresponding to each accessory and the preset advance alarm days to obtain the inventory alarm days corresponding to the alarm threshold of each accessory; calculating the inventory alarm days and daily average sales volume corresponding to the alarm threshold of each accessory Calculation is performed to obtain the alarm threshold corresponding to each accessory; the total number of inventory on hand of each accessory among multiple accessories is compared with the alarm threshold corresponding to each accessory; if the total number of inventory on hand of an accessory is less than the alarm threshold corresponding to the corresponding accessory, the inventory alarm information of the corresponding accessory is generated; the inventory alarm information includes the accessory name, accessory specification model, accessory code and inventory quantity; the accessory corresponding to the inventory alarm information is added to the first accessory group, and each accessory in the first accessory group corresponds to an inventory alarm information; the number of inventory on hand days of the accessory in each accessory is compared with the preset validity period days of the corresponding accessory; if the number of inventory on hand days of the accessory reaches the preset validity period days of the corresponding accessory, the expiration alarm information of the corresponding accessory is generated, and the expiration alarm information includes the accessory name, accessory specification model, accessory code, expiration days and expiration inventory quantity; the accessory corresponding to the expiration alarm information is added to the second accessory group, and each accessory in the second accessory group corresponds to an expiration alarm information.

[0010] Optionally, the preset advance warning days for each accessory and the preset minimum inventory quantity of each accessory corresponding to each accessory are determined by the following steps:

[0011] Calculate the historical total sales volume and sales days of each accessory to obtain the daily average sales volume of each accessory. The historical sales data includes the historical total sales volume, sales days and the purchaser information corresponding to each historical sales sub-sales volume in the historical total sales volume within the target time period. The purchaser information includes the purchaser name. The sales days are determined according to the target time period.

[0012] Acquire multiple historical replenishment order information corresponding to each of the multiple accessories, the historical replenishment order information includes an order placement time and an order receipt time, calculate the order placement time and the order receipt time in each historical replenishment order information corresponding to each accessory, determine the time interval between the order placement time and the receipt time corresponding to each historical replenishment order information corresponding to each accessory, and obtain multiple time intervals corresponding to the multiple historical replenishment order information corresponding to each accessory; calculate the multiple time intervals corresponding to each accessory, and determine the preset advance alarm days for each accessory;

[0013] The preset minimum inventory quantity of each accessory is determined by the average daily sales volume of each accessory and the preset advance warning days.

[0014] Optionally, each accessory in the first accessory group has a corresponding procurement plan, and the procurement plan corresponding to each accessory is determined by the following steps:

[0015] Determine each accessory in the first accessory group as an out-of-stock accessory to obtain an out-of-stock accessory group; obtain the purchase cost of each accessory in the multiple accessories; obtain a pre-configured first scoring table, the first scoring table includes multiple historical total sales volume intervals, scores corresponding to each historical total sales volume interval, multiple purchase cost intervals, and scores corresponding to each purchase cost interval; determine a first score corresponding to the historical total sales volume and a second score corresponding to the purchase cost of each out-of-stock accessory by querying the historical total sales volume and the purchase cost corresponding to each out-of-stock accessory in the first scoring table; configure weights for the first score corresponding to the historical total sales volume and the second score corresponding to the purchase cost respectively, and perform weighted summation of the first score corresponding to the historical total sales volume and the second score corresponding to the purchase cost of each out-of-stock accessory through the weights to determine the out-of-stock score corresponding to each out-of-stock accessory; divide the out-of-stock accessory group into three out-of-stock accessory subgroups according to the out-of-stock score corresponding to each out-of-stock accessory, the three out-of-stock accessory subgroups include a first out-of-stock accessory subgroup, a second out-of-stock accessory subgroup, and a third out-of-stock accessory subgroup, wherein each out-of-stock accessory subgroup corresponds to an out-of-stock score interval;

[0016] For each out-of-stock accessory in the first out-of-stock accessory subgroup, if the historical total sales volume of the out-of-stock accessory is greater than or equal to the preset total sales volume and the purchase cost is greater than or equal to the preset purchase cost, then generate the first purchase frequency and the first purchase batch of the corresponding out-of-stock accessory; if the historical total sales volume of the out-of-stock accessory is greater than the preset total sales volume and the purchase cost is less than the preset purchase cost, then generate the first purchase frequency and the second purchase batch of the corresponding out-of-stock accessory; if the historical total sales volume of the out-of-stock accessory is less than the preset total sales volume and the purchase cost is greater than the preset purchase cost, then generate the second purchase frequency and the first purchase batch of the corresponding out-of-stock accessory;

[0017] For each out-of-stock accessory in the second out-of-stock accessory subgroup, a second purchase frequency and a second purchase batch of the corresponding out-of-stock accessory are generated; for each out-of-stock accessory in the third out-of-stock accessory subgroup, a third purchase frequency and a third purchase batch of the corresponding out-of-stock accessory are generated; wherein, the first purchase frequency is greater than the second purchase frequency, the second purchase frequency is greater than the third purchase frequency, the first purchase batch is greater than the second purchase batch, and the second purchase batch is greater than the third purchase batch;

[0018] Generate a purchase plan for each out-of-stock accessory based on the purchase frequency and purchase batch corresponding to each out-of-stock accessory.

[0019] Optionally, each accessory in the second accessory group has a corresponding sales strategy, and the sales strategy corresponding to each accessory is determined by the following steps:

[0020] Determine each accessory in the second accessory group as an expiring accessory to obtain an expiring accessory group; add the expiring accessories in the expiring accessory group whose expiring inventory quantity is greater than the first preset expiring inventory quantity to the first expiring accessory group; add the expiring accessories in the expiring accessory group whose expiring inventory quantity is less than the first preset expiring inventory quantity and greater than the second preset expiring inventory quantity to the second expiring accessory group; add the expiring accessories in the expiring accessory group whose expiring inventory quantity is less than the second preset expiring inventory quantity to the third expiring accessory group;

[0021] Match the name and specification of each expiring accessory in the first expiring accessory group with the name and specification of each out-of-stock accessory in the out-of-stock accessory group, and each expiring accessory that is successfully matched corresponds to at least one out-of-stock accessory. Each expiring accessory and the corresponding at least one out-of-stock accessory form a candidate replacement accessory subgroup to obtain multiple candidate replacement accessory subgroups; add the expiring accessories that fail to match in the first expiring accessory group to the second expiring accessory group;

[0022] Obtain a pre-configured second scoring table, the second scoring table including multiple historical sales sub-sales volume intervals and a third score corresponding to each historical sales sub-sales volume interval, and obtain a scoring group corresponding to each out-of-stock accessory by querying the third score corresponding to each historical sales sub-sales volume corresponding to each out-of-stock accessory in the out-of-stock accessory group in the second scoring table, wherein each historical sales sub-sales volume of each out-of-stock accessory corresponds to a purchaser name, and each purchaser name of each out-of-stock accessory corresponds to a score;

[0023] Obtain three pre-established sales strategies, including a first sales strategy, a second sales strategy, and a third sales strategy; for each out-of-stock accessory in the candidate replacement accessory subgroup, select a corresponding sales strategy from the three pre-established sales strategies for each purchaser according to the score group corresponding to the out-of-stock accessory, and obtain a sales strategy corresponding to each purchaser when purchasing the expiring accessories in the candidate replacement accessory subgroup;

[0024] Match the expiring accessories corresponding to the purchase cost less than the preset purchase cost in the second expiring accessories group with the third sales strategy; determine the expiring accessories corresponding to the purchase cost greater than the preset purchase cost in the second expiring accessories group as alternative bundled accessories to obtain an alternative bundled accessories group; obtain the sales unit price of each accessory in the multiple accessories, obtain the fixed association collocation between the multiple accessories, and generate multiple sales packages according to the sales unit price of each accessory and the fixed association collocation between the multiple accessories;

[0025] For each near-expiring accessory in the third near-expiring accessories group, a corresponding trade-in sales strategy for each near-expiring accessory in the third near-expiring accessories group is generated.

[0026] Optionally, the alarm threshold corresponding to each accessory is adjusted by following the steps below:

[0027] Inputting historical sales data corresponding to each of the multiple accessories into a pre-trained deep learning network according to a specified time period to obtain a predicted accessory demand corresponding to each accessory; calculating the predicted accessory demand corresponding to each accessory and a preset advance alarm number of days to obtain a predicted accessory minimum inventory quantity corresponding to each accessory; for accessories among the multiple accessories whose predicted accessory minimum inventory quantity is greater than a preset accessory minimum inventory quantity of the corresponding accessories, increasing the preset accessory minimum inventory quantity of the corresponding accessories according to a first preset adjustment plan, and adjusting the alarm threshold of the corresponding accessories, wherein the first preset adjustment plan is determined according to the predicted accessory minimum inventory quantity corresponding to each accessory;

[0028] For an accessory among multiple accessories whose predicted minimum inventory quantity is less than the preset minimum inventory quantity of the corresponding accessory, the preset minimum inventory quantity of the corresponding accessory is reduced according to the second preset adjustment plan, and the alarm threshold of the corresponding accessory is adjusted, wherein the second preset adjustment plan is determined by the average daily sales volume corresponding to each accessory.

[0029] The present invention has the following beneficial effects:

[0030] 1. Improve the accuracy of data by obtaining real-time information about each accessory; determine the alarm threshold for each accessory based on the average daily sales volume, advance alarm days, and preset minimum inventory quantity of each accessory, thereby improving the accuracy and timeliness of the alarm threshold and the efficiency of dealing with out-of-stock situations; compare the total inventory of each accessory with the alarm threshold corresponding to each accessory to ensure the continuity and stability of the supply chain of each accessory; generate the corresponding expiration alarm information for accessories whose inventory days have reached the preset validity period of the corresponding accessories, which is conducive to timely discovering accessories with low inventory turnover rates and processing accessories with low inventory turnover rates, thereby improving inventory turnover rates and reducing storage costs;

[0031] 2. By calculating the preset advance alarm days and preset minimum inventory quantity of each accessory, out-of-stock demand can be solved in time; by analyzing the historical total sales volume and purchase cost corresponding to each out-of-stock accessory, it not only ensures the adequacy of inventory, but also solves the problems of inventory backlog and capital occupation; by generating different procurement plans for each out-of-stock accessory, it is conducive to more targeted solutions to procurement problems faced by out-of-stock; by formulating different strategies for expiring accessories with different expiring inventory quantities, each accessory can be handled more targetedly, reducing inventory backlogs while controlling costs; regularly adjust the alarm threshold corresponding to each accessory to ensure that the alarm threshold is always in line with the actual situation and has timeliness;

[0032] 3. Determine the importance score of each accessory through the attribute information and market positioning score of each accessory, which is conducive to improving the accuracy of calculating the importance score of each accessory; determine the corresponding inventory alarm type through the inventory problem of each accessory, making the alarm type more targeted; generate alarm prompt information of different priorities through different inventory alarm types corresponding to different accessories, ensure that high-priority accessories are given priority, and improve the processing efficiency of inventory alarms. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] The above and other features, advantages and aspects of the embodiments of the present invention will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the accompanying drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and that components and elements are not necessarily drawn to scale.

[0034] Figure 1 It is a flow chart of a safety inventory alarm method for accessories of the present invention. DETAILED DESCRIPTION

[0035] The present invention will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present invention are shown in the accompanying drawings, it should be understood that the present invention can be implemented in various forms and should not be construed as being limited to the embodiments set forth herein. On the contrary, these embodiments are provided to provide a more thorough and complete understanding of the present invention. It should be understood that the drawings and embodiments of the present invention are only for exemplary purposes and are not intended to limit the scope of protection of the present invention.

[0036] It should also be noted that, for ease of description, only the parts related to the invention are shown in the drawings. In the absence of conflict, the embodiments of the present invention and the features in the embodiments can be combined with each other.

[0037] It should be noted that the concepts such as "first" and "second" mentioned in the present invention are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0038] It should be noted that the modifications of "one" and "plurality" mentioned in the present invention are illustrative rather than restrictive, and those skilled in the art should understand that, unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0039] The names of the messages or information exchanged between multiple devices of the present invention are only for illustrative purposes, and are not used to limit the scope of these messages or information.

[0040] The present invention will be described in detail below with reference to the accompanying drawings and in conjunction with embodiments.

[0041] like Figure 1 FIG. 1 is a flow chart of a safety inventory alarm method for accessories according to the present invention, which specifically includes the following steps:

[0042] Step 101, obtaining real-time accessory information of each of the multiple accessories, the real-time accessory information including accessory name, accessory specification model, accessory code, cumulative inventory quantity, outbound quantity, preset advance alarm days and inventory days;

[0043] In some embodiments, the executor of the present invention may be a background server, which may obtain real-time accessory information of multiple accessories from an accessory management system. The real-time accessory information is the ability to instantly reflect the cumulative quantity added to the warehouse, the quantity shipped out of the warehouse, the preset advance alarm days and the inventory days corresponding to each specification and model of accessories. The accessory specification and model refers to the detailed parameters of the accessory (size, material, etc.). The accessory code is used to identify each accessory. The preset advance alarm days are the number of days in advance corresponding to the generation of inventory alarm information when the inventory quantity is less than the preset minimum inventory quantity of the accessory. The inventory days are the number of days from the start of warehousing to the inventory count date when there is no corresponding outbound record.

[0044] In some embodiments, the cumulative inventory quantity of each accessory is determined by the following steps: obtaining the inventory information of each accessory among multiple accessories before the inventory, the inventory information includes the first inventory quantity, the accessory name, the accessory specification model and the accessory code; taking the first inventory quantity of each accessory before the inventory as the beginning inventory quantity; obtaining the entry record of each accessory after the inventory, the entry record includes the entry time, the second entry quantity, the accessory name, the accessory specification model and the accessory code; verifying the inventory information and entry record of each accessory, if the verification is successful, then calculating the beginning inventory quantity and the second entry quantity of each accessory to obtain the cumulative inventory quantity of each accessory, and generating the updated inventory information of each accessory, the updated inventory information includes the accessory name, the accessory specification model, the accessory code and the cumulative inventory quantity. The first inventory quantity of each accessory is the inventory quantity before the inventory, and the second entry quantity of each accessory is the entry quantity of each accessory.

[0045] In some embodiments, the inventory information and storage records of each of the multiple accessories can be obtained from the accessories management system. Take graphics card 1.S as an example ("1" represents the specification model of the graphics card, and "S" represents the code of the graphics card). Assume that a batch of new graphics cards 1.S are stored on July 15, and the inventory quantity of 100 graphics cards 1.S on July 14 (the first inventory quantity is 100) is obtained as the beginning inventory quantity. During the inventory count on July 15, the second storage quantity of graphics cards 1.S in the storage record is 400, and the cumulative storage quantity of graphics cards 1.S is 500.

[0046] In some embodiments, the outbound quantity of each accessory is determined by the following steps: during the outbound process of each accessory, the corresponding accessory name, accessory specification model and accessory code of each accessory during the outbound process are collated with the accessory name, accessory specification model and accessory code in the updated inventory information of each accessory. If the collation is successful, a corresponding outbound record of each accessory is generated, and the outbound record includes the outbound time, outbound quantity, accessory name, accessory specification model and accessory code. In some embodiments, continuing to take graphics card 1.S as an example, during the outbound process of graphics card 1.S, when 150 pieces are outbound, the name, graphics card specification model and graphics card code of graphics card 1.S are collated with the graphics card name, graphics card specification model and graphics card code in the updated inventory information of graphics card 1.S, and the outbound record of graphics card 1.S is generated after one-to-one correspondence.

[0047] In some embodiments, the real-time accessory information includes the accessory name, accessory specification model, accessory code, cumulative inventory quantity, outbound quantity, preset advance warning days, and inventory days. Specifically, the accessory name that can be obtained can be a graphics card. The accessory code can be S. The accessory specification model can be 1. The cumulative inventory quantity can be 500. The outbound quantity can be 150. The preset advance warning days can be 20 days and the inventory days can be 500 days.

[0048] Step 102, calculate the cumulative quantity of each accessory in the warehouse and the quantity of each accessory out of the multiple accessories to obtain the total number of inventory in place for each accessory; obtain the historical sales data of each accessory in the multiple accessories within the target time period, calculate the historical sales data of each accessory to obtain the daily average sales volume corresponding to each accessory; determine the inventory maintenance days corresponding to each accessory according to the daily average sales volume corresponding to each accessory and the preset minimum inventory quantity of the accessory; calculate the inventory maintenance days corresponding to each accessory and the preset advance alarm days to obtain the inventory alarm days corresponding to the alarm threshold corresponding to each accessory; calculate the inventory alarm days and the daily average sales volume corresponding to the alarm threshold corresponding to each accessory to obtain the alarm threshold corresponding to each accessory; compare the total number of inventory in place for each accessory in the multiple accessories with the alarm threshold corresponding to each accessory, if the total number of inventory in place for the accessory is less than the alarm threshold corresponding to the corresponding accessory, generate inventory alarm information for the corresponding accessory; the inventory alarm information includes the accessory name, accessory specification model, accessory code and inventory quantity; add the accessory corresponding to the inventory alarm information to the first accessory group, and each accessory in the first accessory group corresponds to one inventory alarm information;

[0049] In some embodiments, the cumulative number of in-stock items and the number of out-stock items of each accessory in a plurality of accessories are subtracted to obtain the total number of in-stock items of each accessory. In some embodiments, the total number of in-stock items of each accessory is equal to the cumulative number of in-stock items minus the number of out-stock items. For example, the total number of in-stock items of graphics cards is 350 (500-150=350). The total number of in-stock items is the actual total number of in-stock items of each accessory. In some embodiments, taking graphics card 1.S as an example, the historical sales data of the memory of graphics card 1.S within the target time period (within 90 days) is obtained from the accessories management system. When the total historical sales within 90 days is 4500, the average daily sales of memory is equal to the total historical sales divided by the number of sales days. The average daily sales of memory is 50 (4500÷90=50). The average daily sales is the arithmetic mean of the daily sales within a time period. The inventory maintenance days corresponding to the graphics card 1.S is equal to the preset minimum inventory quantity of accessories divided by the average daily sales volume, so the inventory maintenance days corresponding to the graphics card 1.S is 20 days (1000÷50=20), and the inventory maintenance days are the number of days that the inventory can maintain normal operation. The inventory alarm days corresponding to the alarm threshold corresponding to the graphics card 1.S is equal to the inventory maintenance days corresponding to the graphics card 1.S plus the preset advance alarm days (assuming 30 days), so the inventory alarm days corresponding to the alarm threshold corresponding to the graphics card 1.S is 50 days (20+30=50), and the inventory alarm days are the inventory maintenance days corresponding to the alarm threshold. The alarm threshold corresponding to the graphics card 1.S is equal to the inventory alarm days corresponding to the alarm threshold corresponding to the graphics card 1.S (50 days) multiplied by the average daily sales volume, so the alarm threshold corresponding to the graphics card 1.S is 2500 (50×50=2500), and the alarm threshold is a specific value used to determine whether the total number of monitored accessories in stock has reached the condition that requires an alarm. If the total number of graphics card 1.S in stock is 2430, and the total number of graphics card 1.S in stock (2430) is less than the alarm threshold (2500) corresponding to graphics card 1.S, then the inventory alarm information corresponding to graphics card 1.S is generated, and the inventory alarm information includes the accessory name, accessory specification model, accessory code and inventory quantity. The inventory alarm information corresponding to graphics card 1.S may include the accessory name may be a graphics card, the accessory specification model may be 1, the accessory code may be S and the inventory quantity may be 2430. The inventory quantity in the inventory alarm information corresponding to each accessory is determined by the total number of inventory corresponding to each accessory. Graphics card 1.S is added to the first accessory group, and the first accessory group is the accessory group whose total number of accessories in stock is less than the alarm threshold of the corresponding accessories.

[0050] Step 103, compare the number of days in stock of each accessory with the preset validity period of the corresponding accessory. If the number of days in stock of the accessory reaches the preset validity period of the corresponding accessory, generate expiration alarm information of the corresponding accessory. The expiration alarm information includes the accessory name, accessory specification model, accessory code, expiration days and expiration inventory quantity. Add the accessory corresponding to the expiration alarm information to the second accessory group. Each accessory in the second accessory group corresponds to one expiration alarm information.

[0051] In some embodiments, assuming that the number of days in stock of wireless mouse 1.L is 1200 days, and the preset validity period corresponding to wireless mouse 1.L is 1199 days, then the number of days in stock of wireless mouse 1.L reaches the preset validity period of wireless mouse 1.L, and the expiration alarm information corresponding to wireless mouse 1.L is generated, and the expiration alarm information includes the name of the accessory, the specification model of the accessory, the accessory code, the number of days to expiration and the number of inventory to be expired. Specifically, the expiration alarm information of wireless mouse 1.L can be that the name of the accessory is wireless mouse, the specification model of the accessory is 1, the accessory code is L, the number of days to expiration is 1 day and the number of inventory to be expired is 700. Add wireless mouse 1.L to the second accessory group. The second accessory group is an accessory group whose number of days in stock of accessories reaches the preset validity period of the corresponding accessories, and the preset validity period is the number of days corresponding to the accessories that have been in stock for a long time and become unsalable accessories.

[0052] In some embodiments, real-time accessory information of each accessory is obtained to improve data accuracy; the alarm threshold corresponding to each accessory is determined by the average daily sales volume, advance alarm days and preset minimum inventory quantity of each accessory, thereby improving the accuracy and timeliness of the alarm threshold and improving the efficiency of dealing with out-of-stock situations; the total inventory of each accessory is compared with the alarm threshold corresponding to each accessory to ensure the continuity and stability of the supply chain of each accessory; accessories whose inventory days have reached the preset validity period of the corresponding accessory are generated with corresponding expiration alarm information, which is conducive to timely discovery of accessories with low inventory turnover rates and processing of accessories with low inventory turnover rates, thereby improving inventory turnover rates and reducing storage costs.

[0053] In some embodiments, in order to further solve the second technical problem described in the background technology section, namely, "unreasonable inventory strategy configuration parameters lead to inventory shortages, waste of resources, increased costs or capital occupation; when dealing with shortages and backlog crises, procurement plans do not match actual needs and sales strategies lack pertinence; market demand is constantly changing, and relevant parameter values ​​are not changed so that they cannot match actual conditions", in some embodiments of the present invention, the preset advance alarm days for each accessory and the preset minimum inventory quantity of each accessory corresponding to each accessory are determined by the following steps:

[0054] Step 1: Calculate the historical total sales volume and sales days of each accessory to obtain the daily average sales volume of each accessory. The historical sales data includes the historical total sales volume, sales days and the purchaser information corresponding to each historical sales sub-sales volume in the historical total sales volume within the target time period. The purchaser information includes the purchaser name. The sales days are determined according to the target time period.

[0055] Step 2: obtaining multiple historical replenishment order information corresponding to each of the multiple accessories, the historical replenishment order information including the order placing time and the order receipt time, calculating the order placing time and the order receipt time in each historical replenishment order information corresponding to each accessory, determining the time interval between the order placing time and the receipt time corresponding to each historical replenishment order information corresponding to each accessory, and obtaining multiple time intervals corresponding to the multiple historical replenishment order information corresponding to each accessory; calculating the multiple time intervals corresponding to each accessory, and determining the preset advance alarm days for each accessory;

[0056] Step three, determine the preset minimum inventory quantity of each accessory according to the daily average sales volume of each accessory and the preset advance warning days.

[0057] In some embodiments, the historical sales data includes the historical total sales volume, the number of sales days, and the purchaser information corresponding to each historical sales sub-sales volume in the historical total sales volume within a target time period; wherein, the target time period may be the past 50 days, the historical total sales volume within the target time period is the historical total sales volume in the past 50 days (e.g., 4,500 units), and the daily average sales volume of each accessory is equal to the historical total sales volume divided by the number of sales days, so the daily average sales volume of the accessory is 50 units (4,500 ÷ 90 = 50). The number of sales days is determined according to the target time period, for example, if the target time period is the past 50 days, then the number of sales days is 50 days. The purchaser information corresponding to each historical sales sub-sales volume in the historical total sales volume may be the purchasing user A corresponding to the historical sales sub-sales volume 1, the purchasing user B corresponding to the historical sales sub-sales volume 2, and the historical sales sub-sales volume is the sales volume of each purchasing user of each accessory.

[0058] In some embodiments, taking the accessory graphics card 1.S as an example, multiple historical replenishment order information of the graphics card 1.S is obtained from the accessory management system. The historical replenishment order information of the graphics card 1.S refers to the replenishment order information generated in the past due to the shortage of the graphics card 1.S to replenish the inventory quantity of the graphics card 1.S. The replenishment order information includes the order placement time and the receipt time. If the order placement time in the historical replenishment order information 1 of the graphics card 1.S is January 2020 and the order receipt time is April 2020, then the time interval between the order placement and the receipt of the graphics card 1.S is 3 months (90 days); if the order placement time in the historical replenishment order information 2 of the graphics card 1.S is May 2021 and the order receipt time is July 2021, then the time interval between the order placement and the receipt of the graphics card 1.S is 2 months (60 days), and the preset advance alarm days for the graphics card 1.S are 75 days ((90+60)÷2=75). The preset minimum inventory quantity of accessories refers to the minimum inventory quantity that accessories should be stored. If the inventory quantity is lower than this, there may be a shortage of inventory. The preset minimum inventory quantity of accessories is equal to the daily average sales volume of each accessory multiplied by the preset advance warning days of each accessory. The preset minimum inventory quantity of accessories for graphics card 1.S is 3750 (50×75=3750).

[0059] Each accessory in the first accessory group has a corresponding procurement plan, and the procurement plan corresponding to each accessory is determined by the following steps:

[0060] Step 1: Determine each accessory in the first accessory group as an out-of-stock accessory to obtain an out-of-stock accessory group; obtain the purchase cost of each accessory in the multiple accessories; obtain a pre-configured first scoring table, the first scoring table includes multiple historical total sales volume intervals, scores corresponding to each historical total sales volume interval, multiple purchase cost intervals, and scores corresponding to each purchase cost interval; determine a first score corresponding to the historical total sales volume and a second score corresponding to the purchase cost of each out-of-stock accessory by querying the historical total sales volume and the purchase cost corresponding to each out-of-stock accessory in the first scoring table; configure weights for the first score corresponding to the historical total sales volume and the second score corresponding to the purchase cost respectively, and perform weighted summation of the first score corresponding to the historical total sales volume and the second score corresponding to the purchase cost of each out-of-stock accessory through the weights to determine the out-of-stock score corresponding to each out-of-stock accessory; divide the out-of-stock accessory group into three out-of-stock accessory subgroups according to the out-of-stock score corresponding to each out-of-stock accessory, the three out-of-stock accessory subgroups include a first out-of-stock accessory subgroup, a second out-of-stock accessory subgroup, and a third out-of-stock accessory subgroup, wherein each out-of-stock accessory subgroup corresponds to an out-of-stock score interval;

[0061] Step 2: for each out-of-stock accessory in the first out-of-stock accessory subgroup, if the historical total sales volume of the out-of-stock accessory is greater than or equal to the preset total sales volume and the purchase cost is greater than or equal to the preset purchase cost, then generate the first purchase frequency and the first purchase batch of the corresponding out-of-stock accessory; if the historical total sales volume of the out-of-stock accessory is greater than the preset total sales volume and the purchase cost is less than the preset purchase cost, then generate the first purchase frequency and the second purchase batch of the corresponding out-of-stock accessory; if the historical total sales volume of the out-of-stock accessory is less than the preset total sales volume and the purchase cost is greater than the preset purchase cost, then generate the second purchase frequency and the first purchase batch of the corresponding out-of-stock accessory;

[0062] Step 3: for each out-of-stock accessory in the second out-of-stock accessory subgroup, a second purchase frequency and a second purchase batch of the corresponding out-of-stock accessory are generated; for each out-of-stock accessory in the third out-of-stock accessory subgroup, a third purchase frequency and a third purchase batch of the corresponding out-of-stock accessory are generated; wherein the first purchase frequency is greater than the second purchase frequency, the second purchase frequency is greater than the third purchase frequency, the first purchase batch is greater than the second purchase batch, and the second purchase batch is greater than the third purchase batch;

[0063] Step 4: Generate a purchase plan for each out-of-stock accessory based on the purchase frequency and purchase batch corresponding to each out-of-stock accessory.

[0064] In some embodiments, assuming that there is a graphics card 1.S in the first accessory group, the graphics card 1.S is determined to be an out-of-stock accessory, and the purchase cost of the graphics card 1.S is obtained from the accessory management database as RMB 3,000, where the purchase cost is all the expenses paid for the accessory during the procurement process. A pre-configured first scoring table is obtained from the accessory management database, the first score corresponds to the score of the historical total sales volume, the second score corresponds to the score of the purchase cost, and the first scoring table includes multiple historical total sales volume intervals, the score corresponding to each historical total sales volume interval, and multiple purchase cost intervals, with a score corresponding to each purchase cost interval. The total historical sales volume (assuming it is 4,500) and the purchase cost (3,000 yuan) of graphics card 1.S are queried in the first score table, and the first score corresponding to the total historical sales volume of graphics card 1.S is 89 points, and the second score corresponding to the purchase cost is 85 points. The weights of the first score corresponding to the total historical sales volume and the second score corresponding to the purchase cost are respectively configured. The weight of the first score corresponding to the total historical sales volume is 60%, and the weight of the second score corresponding to the purchase cost is 40%. Then the out-of-stock score corresponding to graphics card 1.S is 87.4 points (89×60%+85×40%=87.4). Assuming that the internal The out-of-stock score corresponding to storage 1.G is 70.5 points, the out-of-stock score corresponding to data cable 2.A is 50.7 points, the out-of-stock score range corresponding to the first out-of-stock accessory subgroup is 100 points-85 points (including 100 points and 85 points), the out-of-stock score range corresponding to the second out-of-stock accessory subgroup is 84 points-70 points (including 84 points and 70 points), the out-of-stock score range corresponding to the first out-of-stock accessory subgroup is 69 points-0 points (including 69 points and 0 points), the graphics card 1.S is divided into the first out-of-stock accessory subgroup, the memory 1.G is divided into the second out-of-stock accessory subgroup, and the data cable 2.A is divided into the third out-of-stock accessory subgroup.

[0065] In some embodiments, for the graphics card 1.S in the first out-of-stock accessory subgroup, if the total historical sales volume (4,500) of the graphics card 1.S is greater than the preset total sales volume (4,000) and the purchase cost (3,000 yuan) is greater than the preset purchase cost (2,500 yuan), then the first purchase frequency (once every ten days) and the first purchase batch (5,000) of the graphics card 1.S are generated, and the corresponding purchase plan for the graphics card 1.S is to purchase once every ten days, and the purchase quantity is 5,000. The purchase plan for accessories with high sales volume and high purchase cost is the first purchase frequency and the first purchase batch, which is conducive to improving inventory turnover and reducing purchase costs. The reason for the first purchase batch is that the purchase quantity of accessories with high purchase costs is large, and they can often enjoy the bulk discount provided by the supplier, thereby reducing the purchase cost. If the historical total sales volume (4200) of radiator 2.H is greater than the preset total sales volume (4000) and the purchase cost (2000) is less than the preset purchase cost (2500), the first purchase frequency (once every ten days) and the second purchase batch (3000) of the out-of-stock accessories are generated. The purchase plan for accessories with high sales volume is the first purchase frequency and the second purchase batch, which can avoid out-of-stock and reduce storage costs. If the historical total sales volume (1000) of CPU1.K is less than the preset total sales volume (4000) and the purchase cost (5800) is greater than the preset purchase cost (2500), the second purchase frequency (once a month) and the first purchase batch (5000) of the out-of-stock accessories are generated. The reason for setting the second purchase frequency and the first purchase batch for high purchase costs is that the purchase quantity of accessories with high purchase costs is large, and they can often enjoy the bulk discounts provided by suppliers, thereby reducing the purchase cost; low purchase frequency means fewer orders, thereby reducing the ordering cost, which includes the costs of order processing, transportation and receiving.

[0066] For the memory 1.G in the second out-of-stock accessory subgroup, the second purchase frequency (once a month) and the second purchase batch (3,000 pieces) of memory 1.G are generated; for the data cable 2.A in the third out-of-stock accessory subgroup, the third purchase frequency (once every two months) and the third purchase batch (1,000 pieces) of data cable 2.A are generated. The purchase frequency refers to the number of times a purchase is initiated within a certain period of time, and the purchase batch refers to the number of accessories ordered in a single purchase.

[0067] Each accessory in the second accessory group has a corresponding sales strategy, and the sales strategy corresponding to each accessory is determined by the following steps:

[0068] Step 1: determine each accessory in the second accessory group as an expiring accessory to obtain an expiring accessory group; add the expiring accessories in the expiring accessory group whose expiring inventory quantity is greater than the first preset expiring inventory quantity to the first expiring accessory group; add the expiring accessories in the expiring accessory group whose expiring inventory quantity is less than the first preset expiring inventory quantity and greater than the second preset expiring inventory quantity to the second expiring accessory group; add the expiring accessories in the expiring accessory group whose expiring inventory quantity is less than the second preset expiring inventory quantity to the third expiring accessory group;

[0069] Step 2: Match the accessory name, accessory specification model of each expiring accessory in the first expiring accessory group with the accessory name, accessory specification model of each out-of-stock accessory in the out-of-stock accessory group; each expiring accessory that is successfully matched corresponds to at least one out-of-stock accessory; each expiring accessory and the corresponding at least one out-of-stock accessory form a candidate replacement accessory subgroup, and obtain multiple candidate replacement accessory subgroups; add the expiring accessories that fail to match in the first expiring accessory group to the second expiring accessory group;

[0070] Step 3, obtaining a pre-configured second scoring table, the second scoring table including multiple historical sales sub-sales volume intervals and a third score corresponding to each historical sales sub-sales volume interval, and obtaining a scoring group corresponding to each out-of-stock accessory by querying the third score corresponding to each historical sales sub-sales volume corresponding to each out-of-stock accessory in the out-of-stock accessory group in the second scoring table, wherein each historical sales sub-sales volume of each out-of-stock accessory corresponds to a purchaser name, and each purchaser name of each out-of-stock accessory corresponds to a score;

[0071] Step 4: Obtain three pre-established sales strategies, which include a first sales strategy, a second sales strategy, and a third sales strategy; for each out-of-stock accessory in the candidate replacement accessory subgroup, select a corresponding sales strategy from the three pre-established sales strategies for each purchaser according to the score group corresponding to the out-of-stock accessory, and obtain a sales strategy corresponding to each purchaser when purchasing the expiring accessories in the candidate replacement accessory subgroup;

[0072] Step 5: Match the expiring accessories in the second expiring accessories group whose purchase cost is less than the preset purchase cost with the third sales strategy; determine the expiring accessories in the second expiring accessories group whose purchase cost is greater than the preset purchase cost as alternative bundled accessories to obtain an alternative bundled accessories group; obtain the sales unit price of each accessory in the multiple accessories, obtain the fixed associations between the multiple accessories, and generate multiple sales packages according to the sales unit price of each accessory and the fixed associations between the multiple accessories;

[0073] Step six: for each near-expiring accessory in the third near-expiring accessory group, generate a corresponding trade-in sales strategy for each near-expiring accessory in the third near-expiring accessory group.

[0074] In some embodiments, if the expiring accessory group includes a wireless mouse 1.L, a power supply 1.K, and a chassis 2.H, the wireless mouse 1.L, the power supply 1.K, and the chassis 2.H in the second accessory group are determined as expiring accessories. An expiring accessory is an accessory that has been in stock for a long time. The expiring inventory quantity refers to the number of accessories in the inventory whose number of days the accessories have been in stock has reached the preset validity period of the corresponding accessories. The expiring inventory quantity (620) of the wireless mouse 1.L is greater than the first preset expiring inventory quantity (500), and the wireless mouse 1.L is added to the first expiring accessory group. The expiring inventory quantity (450) of the power supply 1.K is less than the first preset expiring inventory quantity (500) and greater than the second preset expiring inventory quantity (300), and the power supply 1.K is added to the second expiring accessory group. The expiring inventory quantity (100) of the chassis 2.H is less than the second preset expiring inventory quantity (300), and the chassis 2.H is added to the third expiring accessory group.

[0075] In some embodiments, if the first expiring accessory group includes wireless mouse 1.L, graphics card 2.H, and router 1.G, and the out-of-stock accessory group includes wireless mouse 1.D, wireless mouse 1.F, graphics card 2.J, and router 2.D, then wireless mouse 1.L, wireless mouse 1.D, and wireless mouse 1.F form candidate replacement accessory subgroup 1, graphics card 2.H and graphics card 2.J form candidate replacement accessory subgroup 2, and router 1.G is added to the second expiring accessory group. A candidate replacement accessory subgroup refers to a group of accessories that can replace each other. For example, wireless mouse 1.L and wireless mouse 1.D may have the same name and the same accessory specifications and models, but due to different other parameters (such as different colors), the two have different encodings.

[0076] In some embodiments, a pre-configured second scoring table is obtained from the accessory sales background database, and the second scoring table includes multiple historical sales sub-sales intervals and the third score corresponding to each historical sales sub-sales interval. The third score is the score corresponding to the historical sales sub-sales interval. Assume that the wireless mouse 1.D corresponds to two historical sales sub-sales, namely, historical sales sub-sales 1 and historical sales sub-sales 2. On this basis, the third score corresponding to the historical sales sub-sales 1 corresponding to the wireless mouse 1.D is 85 points in the second scoring table, and the purchaser name corresponding to the historical sales sub-sales 1 corresponding to the wireless mouse 1.D is the purchaser A, so the purchaser A corresponding to the wireless mouse 1.D is 85 points. Similarly, the third score corresponding to the historical sales sub-sales 2 of the wireless mouse 1.D (the purchaser name is the purchaser B) is 72 points, so the purchaser B of the wireless mouse 1.D is 72 points. The third score corresponding to the historical sales sub-sales 1 corresponding to the wireless mouse 1.F (the purchaser name is the purchaser C) is 91 points, so the purchaser C of the wireless mouse 1.F is 91 points.

[0077] In some embodiments, three pre-established sales strategies are obtained from the accessory sales background database, and the first sales strategy is that when the corresponding score is greater than the first preset score (90 points), the discount is 50%. The second sales strategy is that when the corresponding score is less than the first preset score (90 points) and greater than the second preset score (70 points), the discount is 30%. The third sales strategy is that when the purchase cost is less than the preset purchase cost, the discount is 20%. The score group corresponding to the wireless mouse 1.F includes 91 points, and the wireless mouse 1.F has only one historical sales sub-sales volume 1. The score of the historical sales sub-sales volume 1 corresponding to the wireless mouse 1.F is 91 points, and 91 points is greater than the first preset score (90 points). The expiring accessory corresponding to the wireless mouse 1.F is the wireless mouse 1.L. Then, when the purchasing user C purchases the expiring accessory wireless mouse 1.L, the corresponding sales strategy is the first sales strategy (50% off). The score group corresponding to wireless mouse 1.D is (85 points, 72 points), among which (85 points, 72 points) correspond to the historical sales sub-sales volume 1 and historical sales sub-sales volume 2 of wireless mouse 1.D respectively, 85 points and 72 points are less than the first preset score (90 points) and greater than the second preset score (70 points), among which, the 85 points corresponding to wireless mouse 1.D (corresponding to purchasing user A), the 85 points corresponding to wireless mouse 1.D (corresponding to purchasing user B), the expiring accessory corresponding to wireless mouse 1.D is wireless mouse 1.L, and for purchasing user A and purchasing user B, the sales strategy for both of them to purchase the expiring accessory wireless mouse 1.L is the second sales strategy (70% off). By selecting expiring accessories with serious backlog (long inventory tenure and large inventory quantity), each expiring accessory with serious backlog is matched with the out-of-stock accessories group, and each selected expiring accessory is added to the candidate replacement accessories group, it is helpful to reduce inventory backlog and reduce the risk of out-of-stock; purchasing different accessories for different purchasing users and formulating different sales strategies are helpful to improve sales efficiency, reduce inventory backlogs, and ensure that costs are controlled while reducing inventory backlogs.

[0078] In some embodiments, for the expiring accessories router 1.G and headphone 1.K in the second expiring accessories group, if the purchase cost (580) of the headphone 1.K is less than the preset purchase cost (2500), the headphone 1.K is matched with the third sales strategy (80% off). The purchase cost (2800) of the router 1.G is greater than the preset purchase cost (2500), and the router 1.G is determined as an alternative bundled accessory. The sales unit price of the router 1.G is 3,500 yuan obtained from the accessory management background database, and the fixed associations between multiple accessories are obtained from the manufacturer's manual guide. The fixed associations between multiple accessories can be: computer host, keyboard, mouse, power cord, monitor, router. Each accessory with different sales unit prices is combined and matched to generate multiple sales packages, and the multiple sales packages include sales package 1 (basic package), sales package 2 (advanced package), and sales package 3 (high-end package). Sales Package 1 (basic package) can include computer host 1.0 (sales unit price is 800), keyboard 1.0 (sales unit price is 100), mouse 1.0 (sales unit price is 50), power cord 1.0 (sales unit price is 70), monitor 1.0 (sales unit price is 200), and router 1.G (the corresponding sales unit price of the package is 2800). Among them, each sales package includes at least one optional bundled accessory, and each sales package corresponds to a first total price. The first total price can be the total price of adding up the sales unit prices of all accessories in sales package 1. For example, the first total price of sales package 1 is 4020 yuan (800+100+50+70+200+2800=4020). The first total price corresponding to each sales package is less than the second total price of adding up the multiple sales unit prices corresponding to the multiple accessories corresponding to each sales package. The second total price is the total price of each accessory in the fixed associated combination without using the package. For example, the difference between the first total price and the second total price is mainly that the sales unit price of router 1.G in the sales package is different in the package and outside the package. Sales package 2 (advanced package) can include computer host 2.0 (sales unit price is 1200), keyboard 2.0 (sales unit price is 150), mouse 2.0 (sales unit price is 100), power cord 2.0 (sales unit price is 90), monitor 2.0 (sales unit price is 300), and router 1.G (the corresponding sales unit price of the package is 2500). Sales package 3 (high-end package) can include computer host 3.0 (sales unit price is 2000), keyboard 3.0 (sales unit price is 350), mouse 3.0 (sales unit price is 150), power cord 3.0 (sales unit price is 120), monitor 3.0 (sales unit price is 1000), and router 1.G (the corresponding sales unit price of the package is 2100). The corresponding sales unit price of router 1.G is different in different sales packages. Because selling high-end packages can obtain greater profits, setting the sales unit price of router 1.G to the lowest can attract users.If there are no alternative bundled accessories in the fixed association between multiple accessories, the alternative bundled accessories will be added to multiple sales packages.

[0079] In some embodiments, if the third group of expiring accessories includes but is not limited to monitor 2.0, a trade-in sales strategy is generated for monitor 2.0. The trade-in sales strategy for monitor 2.0 is that when a user purchases monitor 2.0, he or she only needs to return the old monitor 2.0 without paying any additional fees. Because the third group of expiring accessories includes accessories with a small amount of expiring inventory, trade-in can promote consumption, reduce inventory backlogs, and will not cause serious cost losses.

[0080] The alarm thresholds for each accessory are adjusted by following these steps:

[0081] Step 1: Inputting historical sales data corresponding to each of the multiple accessories into a pre-trained deep learning network according to a specified time period to obtain a predicted accessories demand corresponding to each accessory; calculating the predicted accessories demand corresponding to each accessory and a preset advance alarm number of days to obtain a predicted accessories minimum inventory quantity corresponding to each accessory; for accessories among the multiple accessories whose predicted accessories minimum inventory quantity is greater than a preset accessories minimum inventory quantity of the corresponding accessories, increasing the preset accessories minimum inventory quantity of the corresponding accessories according to a first preset adjustment plan, and adjusting the alarm threshold of the corresponding accessories, wherein the first preset adjustment plan is determined according to the predicted accessories minimum inventory quantity corresponding to each accessory;

[0082] Step two, for accessories among multiple accessories whose predicted minimum inventory quantity is less than the preset minimum inventory quantity of the corresponding accessories, reduce the preset minimum inventory quantity of the corresponding accessories according to the second preset adjustment plan, and adjust the alarm threshold of the corresponding accessories, wherein the second preset adjustment plan is determined by the average daily sales volume corresponding to each accessory.

[0083] In some embodiments, taking the accessories keyboard 2.0 and power cord 3.0 as examples, the historical sales data corresponding to the keyboard 2.0 and the power cord 3.0 are respectively input into the pre-trained deep learning network according to the specified time period (every two months), and the predicted accessory demand corresponding to the keyboard 2.0 (200 per day) and the predicted accessory demand corresponding to the power cord 3.0 (100 per day) are obtained. The pre-trained deep learning network is a network model obtained after sufficient training of a large number of historical sales data sets. The predicted accessory demand is the predicted daily demand quantity of the accessory. The predicted minimum inventory quantity of accessories corresponding to keyboard 2.0 is equal to the predicted demand for accessories (200) multiplied by the preset advance alarm days (assuming it is 20 days), so the predicted minimum inventory quantity of accessories corresponding to keyboard 2.0 is 4000 (200×20=4000). The predicted minimum inventory quantity of accessories for keyboard 2.0 of 4000 is greater than the preset minimum inventory quantity of accessories for keyboard 2.0 of 3000, so the preset minimum inventory quantity of accessories for keyboard 2.0 is increased to 4000. By using the above calculation formula for the alarm threshold corresponding to each accessory, the alarm threshold corresponding to keyboard 2.0 is 6000. According to the first preset adjustment plan, the preset minimum inventory quantity of accessories is increased to ensure that there is enough inventory to prevent inventory shortages.

[0084] In some embodiments, the predicted minimum inventory quantity of accessories corresponding to the power cord 3.0 is equal to the predicted demand for accessories (100) multiplied by the preset advance alarm days (assuming it is 20 days), then the predicted minimum inventory quantity of accessories corresponding to the power cord 3.0 is 2000 (100×20=2000), the predicted minimum inventory quantity of accessories of the power cord 3.0 of 2000 is less than the preset minimum inventory quantity of accessories of the power cord 3.0 of 3000, then the preset minimum inventory quantity of accessories corresponding to the power cord 3.0 is reduced, and the daily average sales volume corresponding to the power cord 3.0 is calculated by the historical sales data of the power cord 3.0, and the preset minimum inventory quantity of accessories corresponding to the power cord 3.0 is 130, then the preset minimum inventory quantity of accessories corresponding to the power cord 3.0 is 2600. The reasons for reducing the preset minimum inventory quantity of accessories according to the second preset adjustment plan are as follows: market demand is often volatile and it is difficult to fully predict the actual demand in the future; to prevent the risk of supply chain delivery delays and transportation delays.

[0085] In some embodiments, out-of-stock demands can be addressed in a timely manner by calculating the preset advance alarm days and the preset minimum inventory quantity of each accessory; by analyzing the historical total sales volume and purchase cost corresponding to each out-of-stock accessory, the adequacy of inventory is ensured and the problems of inventory backlog and capital occupation are solved; by generating different procurement plans for each out-of-stock accessory, it is helpful to solve the procurement problems faced by out-of-stock in a more targeted manner; by formulating different strategies for expiring accessories with different expiring inventory quantities, each accessory can be handled in a more targeted manner, reducing inventory backlogs while controlling costs; the alarm threshold corresponding to each accessory is adjusted regularly to ensure that the alarm threshold is always in line with the actual situation and is timely.

[0086] In some embodiments, in order to further solve the third technical problem described in the background technology section, that is, "when a large number of safety inventory alarms are triggered, managers face priority conflicts when making decisions, resulting in uneven distribution of attention to the processing of accessories and a decrease in the overall inventory processing efficiency", some embodiments of the present invention also include:

[0087] Step 1: Obtain attribute information and market positioning score of each of the multiple accessories, the attribute information including core performance, special functions, and sales price; and obtain the total operating time, number of repairs, and after-sales repair cost of each accessory; determine the overall performance index of each accessory based on the core performance and special functions of each accessory; calculate the number of repairs and total operating time of each accessory to obtain the average failure rate of each accessory; determine the cost-profit ratio of each accessory based on the sales price, purchase cost, and after-sales repair cost of each accessory; adjust the market positioning score based on the average failure rate and cost-profit ratio corresponding to each accessory to obtain the actual positioning score corresponding to each accessory; determine the importance score of each accessory based on the actual positioning score and overall performance index corresponding to each accessory;

[0088] In some embodiments, the attribute information and market positioning score of each accessory are obtained from the professional accessories database. The number of repairs, total operation time and after-sales repair cost of each accessory are obtained from the after-sales management system. The total operation time refers to the total cumulative operation time of the accessory from the time it was put into use to the current moment. The number of repairs refers to the total number of repair actions performed due to failure, damage or performance degradation during the total operation time. The after-sales repair cost is the relevant cost incurred by repairing accessories.

[0089] In some embodiments, the attribute information includes core performance, special features, and sales price; taking the out-of-stock graphics card MX as an example (MX is the model of the graphics card), the attribute information and market positioning score corresponding to the out-of-stock graphics card MX are processed to indirectly obtain the importance score of the in-stock graphics card MX. The attribute information of each accessory (graphics card MX) may be core performance, special features, and sales price. The core performance may include: a large number of stream processors, a large video memory capacity, a large video memory bit width, and a high acceleration frequency. Special features may include: ray tracing technology, deep learning super sampling, and silent design. The sales price is assumed to be 5,000 yuan. By using a weighted summation algorithm for the core performance and special features of each accessory, the overall performance index of each accessory is assumed to be 88%, where the overall performance index of each accessory is up to 100%.

[0090] In some embodiments, the average failure rate of each accessory is the number of repairs of each accessory divided by the total operating time multiplied by 100%. When the total operating time of the accessory (graphics card MX) is 10,000 hours and the number of repairs is 10 times within the total operating time of 10,000 hours, the average failure rate of the accessory is 10%. The average failure rate refers to the average frequency of accessory failures within the total operating time. The average failure rate is an important indicator for measuring the reliability of accessories. The cost-profit ratio is the ratio between profit and cost. Taking the graphics card MX as an example, when the sales price of the graphics card MX is 5,000 yuan, the purchase cost is 3,000 yuan, and the after-sales maintenance cost is 600 yuan, the cost-profit ratio of the graphics card MX is calculated as follows: First, the sales price of 5,000 is subtracted from the purchase cost of 3,000 to obtain a profit of 2,000, and then the purchase cost of 3,000 is added to the after-sales maintenance cost of 600 to obtain a cost of 3,600, and then the profit of 2,000 is divided by the cost of 3,600 and multiplied by 100%, and finally the cost-profit ratio of the graphics card MX is 56%. The actual positioning score corresponding to each accessory is the market positioning score multiplied by the average failure rate multiplied by the cost-profit ratio. The market positioning score of each accessory refers to the score obtained through feedback from multiple users on the market demand satisfaction of the accessory (including the function, performance, quality, price and other factors of the accessory). Due to the different user experiences of different users, the market positioning score of each accessory is relatively diverse, and the market positioning score needs to be adjusted by the average failure rate and cost-profit ratio of each accessory. The lower the average failure rate, the higher the reliability of the accessory. Therefore, the average failure rate of the graphics card MX is 90% (100%-10%), where 10% is the number of repairs divided by the total running time. The higher the cost-profit ratio, the stronger the profitability of the accessory. From the above calculation, it is known that the cost-profit ratio of the graphics card MX is 56%. When the market positioning score of the graphics card MX is 200 points (full score 300 points), the actual positioning score of the graphics card MX is 100.8 points (200×90%×56%=100.8). The importance score of each accessory is the actual positioning score multiplied by the overall performance index. Since the overall performance index of each accessory is a bonus item, 100% is added to the original overall performance index when calculating the importance score. For example, the overall performance index of graphics card MX is 88%. When calculating the importance score of graphics card MX, the overall performance index of graphics card MX is 188% (88% + 100% = 188%), then the importance score of graphics card MX is 189.504 points (100.8×188% = 189.504).

[0091] Step 2: obtaining multiple inventory problems of each of the multiple accessories, the inventory problems including out-of-stock, overstock and abnormal turnover rate; determining the alarm type corresponding to each of the multiple inventory problems according to the multiple inventory problems of each accessory, the alarm types including out-of-stock alarm, overstock alarm and abnormal turnover rate alarm;

[0092] Step 3: Obtain a pre-configured inventory alarm type score table, which includes different inventory alarm types and scores corresponding to each inventory alarm type; determine the score corresponding to each inventory alarm type by querying the inventory alarm type score table; configure weights for the importance score corresponding to each accessory and the score corresponding to the inventory alarm type, respectively, and perform weighted summation of the importance score corresponding to each accessory and the score corresponding to the inventory alarm type by weight, to obtain the total score of the inventory alarm type corresponding to each accessory;

[0093] Step 4: if the total score of the inventory alarm type corresponding to the accessory is greater than or equal to the first preset safety score, a first priority alarm prompt information is generated; if the total score of the inventory alarm type corresponding to the accessory is less than the first preset safety score and greater than the second preset safety score, a second priority alarm prompt information is generated; if the total score of the inventory alarm type corresponding to the accessory is less than the second preset safety score, a third priority alarm prompt information is generated; wherein the first priority alarm prompt information, the second priority alarm prompt information and the third priority alarm prompt information respectively include different color prompts and different urgency prompts;

[0094] Step 5: Send the first priority alarm prompt information, the second priority alarm prompt information and the third priority alarm prompt information to the inventory alarm processing terminal device, so that the processing personnel corresponding to the inventory alarm processing terminal device perform corresponding operations.

[0095] In some embodiments, the inventory problem of each accessory is obtained through the inventory information management software. A pre-configured inventory problem scoring table is obtained from the inventory information library, and the inventory problem scoring table includes different inventory problems and scores corresponding to each inventory problem. The inventory problems include out-of-stock, overstock, and abnormal turnover rate. The scores corresponding to the inventory problems are 90 points for out-of-stock, 80 points for overstock, and 60 points for abnormal turnover rate. A weight of 60% is configured for the score corresponding to the accessories, and a weight of 40% is configured for the score corresponding to the inventory problem. If the graphics card MX is out of stock, the total score of the graphics card MX is 149.7024 points (189.504×60%+90×40%=149.7024); similarly, assuming that the hard disk turnover rate is abnormal, the total score of the hard disk is 60 points; assuming that the memory is out of stock, the total score of the memory is 86 points; when the first preset safety score is 100 points, the graphics card MX is out of stock and generates a first priority alarm prompt information, the color prompt is red, and the urgency is high; if the second preset safety score is 80 points, a second priority alarm prompt information is generated for the memory out of stock, the color prompt is orange, and the urgency is medium level one; if the total score of 60 points for the abnormal hard disk turnover rate is less than the second preset safety score (80 points), a third priority alarm prompt information is generated, the color prompt is yellow, and the urgency is medium level two, where the medium level urgency level is higher than medium level two. The processing personnel corresponding to the inventory problem handling terminal equipment will focus on handling each accessory according to its corresponding priority and urgency. For example, when the graphics card MX is out of stock, the memory is out of stock, and the hard disk turnover rate is abnormal and alarm prompt information is generated at the same time, the graphics card MX out of stock is the first priority alarm prompt information, the color prompt is red, the urgency is high, and the inventory problem of the graphics card MX out of stock is handled first.

[0096] In some embodiments, the importance score of each accessory is determined through the attribute information and market positioning score of each accessory, which is conducive to improving the accuracy of calculating the importance score of each accessory; the corresponding inventory alarm type is determined by the inventory problem of each accessory, making the alarm type more targeted; different priority alarm prompt information is generated by different inventory alarm types corresponding to different accessories, ensuring that high-priority accessories are given priority processing, thereby improving the processing efficiency of inventory alarms.

[0097] The above descriptions are only some preferred embodiments of the present invention and the explanation of the technical principles used. Those skilled in the art should understand that the scope of the invention involved in the present invention is not limited to the technical solutions formed by the specific combination of the above technical features, but also should cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above inventive concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present invention (but not limited to) to form a technical solution.

Claims

1. A safety inventory alarm method for accessories, characterized in that: include: Acquire real-time accessory information of each of the multiple accessories, the real-time accessory information including accessory name, accessory specification model, accessory code, cumulative inventory quantity, inventory quantity, preset advance alarm days and inventory in-place days; Calculate the cumulative inventory quantity and outbound quantity of each of the multiple accessories to obtain the total inventory of each accessory; obtain the historical sales data of each of the multiple accessories within the target time period, calculate the historical sales data of each accessory, and obtain the daily average sales volume corresponding to each accessory; determine the inventory maintenance days corresponding to each accessory according to the daily average sales volume corresponding to each accessory and the preset minimum inventory quantity of the accessory; Calculate the inventory maintenance days corresponding to each accessory and the preset advance alarm days to obtain the inventory alarm days corresponding to the alarm threshold corresponding to each accessory; calculate the inventory alarm days corresponding to the alarm threshold corresponding to each accessory and the average daily sales volume to obtain the alarm threshold corresponding to each accessory; compare the total number of inventory in place of each accessory among the multiple accessories with the alarm threshold corresponding to each accessory, and if the total number of inventory in place of the accessory is less than the alarm threshold corresponding to the corresponding accessory, generate inventory alarm information of the corresponding accessory; the inventory alarm information includes the accessory name, accessory specification model, accessory code and inventory quantity; Adding the accessories corresponding to the inventory alarm information to a first accessories group, wherein each accessory in the first accessories group corresponds to one inventory alarm information; The number of days the accessories are in stock for each accessory is compared with the preset validity period of the corresponding accessory. If the number of days the accessories are in stock reaches the preset validity period of the corresponding accessory, the expiration alarm information of the corresponding accessory is generated. The expiration alarm information includes the accessory name, accessory specification model, accessory code, expiration days and expiration inventory quantity. The accessory corresponding to the expiration alarm information is added to the second accessory group. Each accessory in the second accessory group corresponds to one expiration alarm information.

2. The safety inventory alarm method for accessories according to claim 1, characterized in that: The preset advance warning days for each accessory and the preset minimum inventory quantity of each accessory corresponding to each accessory are determined by the following steps: Calculate the historical total sales volume and sales days of each accessory to obtain the daily average sales volume corresponding to each accessory, wherein the historical sales data includes the historical total sales volume, the sales days, and the purchaser information corresponding to each historical sales sub-sales volume in the historical total sales volume within the target time period, wherein the purchaser information includes the purchaser name, and the sales days are determined according to the target time period; Acquire multiple historical replenishment order information corresponding to each of the multiple accessories, the historical replenishment order information including an order placement time and an order receipt time, calculate the order placement time and the order receipt time in each historical replenishment order information corresponding to each accessory, determine the time interval between the order placement time and the receipt time corresponding to each historical replenishment order information corresponding to each accessory, and obtain multiple time intervals corresponding to the multiple historical replenishment order information corresponding to each accessory; calculate the multiple time intervals corresponding to each accessory to determine the preset advance alarm days for each accessory; The preset minimum inventory quantity of accessories corresponding to each accessory is determined by the average daily sales volume corresponding to each accessory and the preset advance warning days.

3. The safety inventory alarm method for accessories according to claim 2, characterized in that: Each accessory in the first accessory group has a corresponding procurement plan, and the procurement plan corresponding to each accessory is determined by the following steps: Determine each accessory in the first accessory group as an out-of-stock accessory to obtain an out-of-stock accessory group; obtain the purchase cost of each accessory in the multiple accessories; obtain a pre-configured first scoring table, the first scoring table includes multiple historical total sales volume intervals, scores corresponding to each historical total sales volume interval, multiple purchase cost intervals, and scores corresponding to each purchase cost interval; determine a first score corresponding to the historical total sales volume and a second score corresponding to the purchase cost of each out-of-stock accessory by querying the historical total sales volume and the purchase cost corresponding to each out-of-stock accessory in the first scoring table; configure weights for the first score corresponding to the historical total sales volume and the second score corresponding to the purchase cost respectively, and perform weighted summation of the first score corresponding to the historical total sales volume and the second score corresponding to the purchase cost of each out-of-stock accessory through the weights to determine the out-of-stock score corresponding to each out-of-stock accessory; divide the out-of-stock accessory group into three out-of-stock accessory subgroups according to the out-of-stock score corresponding to each out-of-stock accessory, the three out-of-stock accessory subgroups include a first out-of-stock accessory subgroup, a second out-of-stock accessory subgroup, and a third out-of-stock accessory subgroup, wherein each out-of-stock accessory subgroup corresponds to an out-of-stock score interval; For each out-of-stock accessory in the first out-of-stock accessory subgroup, if the total historical sales volume of the out-of-stock accessory is greater than or equal to the preset total sales volume and the purchase cost is greater than or equal to the preset purchase cost, then generate a first purchase frequency and a first purchase batch of the corresponding out-of-stock accessory; if the total historical sales volume of the out-of-stock accessory is greater than the preset total sales volume and the purchase cost is less than the preset purchase cost, then generate a first purchase frequency and a second purchase batch of the corresponding out-of-stock accessory; if the total historical sales volume of the out-of-stock accessory is less than the preset total sales volume and the purchase cost is greater than the preset purchase cost, then generate a second purchase frequency and a first purchase batch of the corresponding out-of-stock accessory; For each out-of-stock accessory in the second out-of-stock accessory subgroup, the second purchase frequency and the second purchase batch of the corresponding out-of-stock accessory are generated; for each out-of-stock accessory in the third out-of-stock accessory subgroup, the third purchase frequency and the third purchase batch of the corresponding out-of-stock accessory are generated; wherein the first purchase frequency is greater than the second purchase frequency, the second purchase frequency is greater than the third purchase frequency, the first purchase batch is greater than the second purchase batch, and the second purchase batch is greater than the third purchase batch; Generate a purchase plan for each out-of-stock accessory based on the purchase frequency and purchase batch corresponding to each out-of-stock accessory.

4. The safety inventory alarm method for accessories according to claim 3, characterized in that: Each accessory in the second accessory group has a corresponding sales strategy, and the sales strategy corresponding to each accessory is determined by the following steps: Determine each accessory in the second accessory group as an expiring accessory to obtain an expiring accessory group; add the expiring accessories in the expiring accessory group whose expiring inventory quantity is greater than the first preset expiring inventory quantity to the first expiring accessory group; Add the expiring accessories in the expiring accessories group whose expiring inventory quantity is less than the first preset expiring inventory quantity and greater than the second preset expiring inventory quantity to the second expiring accessories group; Adding the expiring accessories in the expiring accessories group whose expiring inventory quantity is less than the second preset expiring inventory quantity to a third expiring accessories group; Match the name and specification of each expiring accessory in the first expiring accessory group with the name and specification of each out-of-stock accessory in the out-of-stock accessory group, and each expiring accessory that is successfully matched corresponds to at least one out-of-stock accessory. Each expiring accessory and the corresponding at least one out-of-stock accessory form a candidate replacement accessory subgroup to obtain a plurality of candidate replacement accessory subgroups; add the expiring accessories that fail to match in the first expiring accessory group to the second expiring accessory group; Obtain a pre-configured second scoring table, the second scoring table including a plurality of historical sales sub-sales volume intervals and a third score corresponding to each historical sales sub-sales volume interval, and obtain a scoring group corresponding to each out-of-stock accessory by querying the third score corresponding to each historical sales sub-sales volume corresponding to each out-of-stock accessory in the out-of-stock accessory group in the second scoring table, wherein each historical sales sub-sales volume of each out-of-stock accessory corresponds to a purchaser name, and each purchaser name of each out-of-stock accessory corresponds to a score; Obtain three pre-established sales strategies, the three pre-established sales strategies including a first sales strategy, a second sales strategy, and a third sales strategy; for each out-of-stock accessory in the candidate replacement accessory subgroup, select a corresponding sales strategy from the three pre-established sales strategies for each purchaser according to the score group corresponding to the out-of-stock accessory, and obtain a sales strategy corresponding to each purchaser when purchasing the expiring accessory in the candidate replacement accessory subgroup; Matching the expiring accessories in the second expiring accessories group whose purchase cost is less than the preset purchase cost with the third sales strategy; determining the expiring accessories in the second expiring accessories group whose purchase cost is greater than the preset purchase cost as alternative bundled accessories to obtain an alternative bundled accessories group; obtaining the sales unit price of each of the multiple accessories, obtaining the fixed associated collocations between the multiple accessories, and generating multiple sales packages according to the sales unit price of each accessory and the fixed associated collocations between the multiple accessories; For each near-expiring accessory in the third near-expiring accessories group, a corresponding trade-in sales strategy for each near-expiring accessory in the third near-expiring accessories group is generated.

5. The safety inventory alarm method for accessories according to claim 4, characterized in that: The alarm threshold corresponding to each accessory is adjusted by the following steps: Inputting historical sales data corresponding to each of the plurality of accessories into a pre-trained deep learning network according to a specified time period to obtain a predicted accessory demand corresponding to each accessory; The predicted accessory demand and the preset advance alarm days corresponding to each accessory are calculated to obtain the predicted accessory minimum inventory quantity corresponding to each accessory; for an accessory among the multiple accessories whose predicted accessory minimum inventory quantity is greater than the preset accessory minimum inventory quantity of the corresponding accessory, the preset accessory minimum inventory quantity of the corresponding accessory is increased according to a first preset adjustment scheme, and the alarm threshold of the corresponding accessory is adjusted, wherein the first preset adjustment scheme is determined according to the predicted accessory minimum inventory quantity corresponding to each accessory; For accessories among the multiple accessories whose predicted minimum inventory quantity is less than the preset minimum inventory quantity of the corresponding accessories, the preset minimum inventory quantity of the corresponding accessories is reduced according to the second preset adjustment plan, and the alarm threshold of the corresponding accessories is adjusted, wherein the second preset adjustment plan is determined by the average daily sales volume corresponding to each accessory.

Images