Material scheduling system for warehouse management
By combining enterprise order and production data to analyze material demand and formulate scientific replenishment strategies, the problems of insufficient material forecasting and excessive costs in the face of urgent orders in the warehouse management system have been solved, and accurate forecasting of material demand and cost control have been achieved.
Patent Information
- Application Number
- CN202410925002.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-11
- Publication Date
- 2024-11-12
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
Existing warehouse management systems are unable to accurately predict material demand when faced with urgent orders, resulting in excessive capital investment in the warehouse and material backlog. Furthermore, they fail to effectively consider production speed and price fluctuations, increasing the workload and costs for relevant personnel.
By combining enterprise order data and production data, we can analyze material demand, predict material demand in the next replenishment cycle, formulate scientific replenishment strategies, flexibly adjust warehouse safety storage levels, and avoid material backlog and excessive costs.
It enables accurate forecasting of material demand, reduces replenishment costs, avoids material stockpiling, reduces the workload of relevant personnel, lowers material purchase costs, and improves production efficiency.
Smart Images

Figure CN118940998A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of warehouse management, in particular to a material dispatching system for warehouse management. Background Art
[0002] Warehousing management is the management of warehouses and the materials stored in them, and the storage and safekeeping of goods through warehouses. "Warehouse" is also called a warehouse, which is a building and site for storing goods. It can be a house building, a large container, a cave or a specific site, etc., and has the function of storing and protecting goods; "Chu" means to store for use, which means to store, keep, and deliver for use. When it is applicable to tangible items, it is also called storage. "Warehousing" is the act of using a warehouse to store and store items that are not used in time. In short, warehousing is the act of storing items in a specific place.
[0003] Material warehouses can reduce the risks of delayed delivery by raw material suppliers and possible delays during transportation, prevent out-of-stock and ensure the stability and continuity of enterprise production; material warehouses can improve the flexibility and flexibility of timely delivery of urgent orders or special orders. This can improve customer satisfaction and maintain a certain market competitiveness; economical bulk purchases of materials can reduce the procurement costs of enterprises, and can reduce the risk of rising procurement costs due to price increases of materials to a certain extent. Therefore, general enterprises will store a certain amount of materials and regularly replenish the materials in the warehouse to meet production needs. In order to better manage the materials in the warehouse, people have developed a material scheduling system for warehouse management.
[0004] The existing application publication number is CN118014317B, and the Chinese invention patent named A Silicone Production Material Warehousing Control Management System and Method records that it includes a real-time status monitoring module, a consumption analysis module, a material scheduling and allocation module connected to the output end of the consumption analysis module, and also includes a distribution scheduling and control module. The consumption analysis module calculates the usage time and required material quantity of the remaining material quantity of the production step, so that the material scheduling and allocation module determines the replenishment equipment for allocating materials to the production area of the production step in the storage center, and thus constructs a distribution travel path to perform transportation distribution for the materials in short supply in the production step; and the distribution scheduling and control module performs a comprehensive comparison and judgment based on the loss time and usage time of material transportation according to the distribution travel path, so as to generate transportation distribution control for the replenishment equipment, so as to reasonably allocate and schedule the transportation machinery and materials in the storage center, and improve the uninterrupted operation of the production step.
[0005] However, according to the above contents and in combination with the prior art, the central idea of the solution recorded in the above patent is how to realize the analysis of raw materials for equipment production and how to realize the provision of stable supply for equipment production;
[0006] The above scheme has certain drawbacks when used. The scheme adopted by the above scheme is to feed materials according to the constant production speed of the equipment. However, in actual production, when urgent orders appear, the production speed and production time of the equipment will be adjusted. When adjusting the production speed and production time, the equipment demand is naturally clear. At this time, the most important thing is to ensure that the storage volume of materials in the warehouse is sufficient. Therefore, this method is based on a warehouse that can store sufficient materials for a long time, but in practice, this method requires a large amount of capital investment, which does not meet actual needs and does not meet people's usage requirements. For this reason, we have developed a material scheduling system for warehouse management. Summary of the invention
[0007] 1. Technical issues to be solved
[0008] In view of the deficiencies in the prior art, the present invention provides a material scheduling system for warehouse management, which fully combines the order data and production data of the enterprise, analyzes the enterprise's demand for various materials, and analyzes it in combination with the enterprise's daily production demand upper limit, thereby calculating the enterprise's actual demand for various materials in the next replenishment cycle. The overall calculation is relatively accurate, and can help the enterprise manage the replenishment of materials more scientifically, greatly reducing the capital investment in replenishment, and at the same time can effectively avoid the situation where too much material is purchased and causing serious material backlogs. There is no need to subsequently deal with the accumulated inventory materials at a low price, which can reduce the workload of relevant personnel, has good use effect, and has a good use prospect.
[0009] (II) Technical solution
[0010] To achieve the above objectives, the present invention is implemented through the following technical solutions:
[0011] A material dispatching system for warehouse management includes a data acquisition module, an analysis and processing module, a storage judgment unit and a solution generation module:
[0012] Data collection module, which obtains material data stored in the warehouse, order data within the next replenishment cycle, and production data;
[0013] An analysis and processing module, which includes a daily demand calculation unit, a production comparison unit and a total demand calculation unit;
[0014] The daily demand calculation unit analyzes the order data obtained in the next replenishment cycle, calculates the daily production demand Rxq of various materials, and feeds the calculated daily production demand Rxq back to the production comparison unit to determine whether the daily production demand Rxq exceeds the set daily production demand upper limit. The total demand calculation unit obtains the comparison result of the production comparison unit, and executes the corresponding calculation strategy according to the result to predict the quantity of all types of materials required for the next replenishment cycle;
[0015] The storage judgment unit obtains the data of the quantity of all types of materials required for the next replenishment cycle, and calculates the maximum total amount of a single type of material stored in the next supply cycle based on the data Hwzl max , the maximum value of the total amount of goods Hwzl max Compare with the set storage upper limit Szz of the material, and execute the corresponding replenishment strategy according to the comparison result;
[0016] The plan generation module obtains the replenishment strategies of all materials and aggregates all replenishment strategies to generate a replenishment plan.
[0017] Preferably, the material data includes the quantity of each material stored in the warehouse and the storage upper limit Szz of each material stored; the order data includes normal orders and expedited orders; an order with a total order time shorter than the material purchase cycle is an expedited order, and an order with a total order time longer than the material purchase cycle is a normal order; both normal orders and expedited orders include product completion time and product quantity; the production data includes the product qualification rate and the quantity of each material corresponding to the processing of each product.
[0018] Preferably, the calculation formula for the material daily production demand Rxq is as follows:
[0019]
[0020] In the formula, Rxq zc Rxq is the daily production demand of materials generated by normal orders. jj is the daily production demand of materials generated by urgent orders, α is the impact ratio of the change in daily production demand of materials caused by orders received in the next replenishment cycle, n is the number of normal orders, Ddxq i is the number of products in the i-th normal order, A i is the amount of material required to produce the product in the i-th normal order, Scsx i is the production time of the i-th normal order, Hgl i is the qualified rate of the i-th normal order product, B is the constant proportional coefficient, C is the predicted proportion of expedited orders in the next replenishment cycle, m is the number of expedited orders, Tsdd i is the number of products in the i-th rush order, D i Hgl′ is the amount of material required to produce the product in the i-th rush order. i is the qualified rate of the product for the i-th expedited order, Scsx′ i is the production time of the i-th urgent order, C>α>0, 25>B>20.
[0021] Preferably, the steps of the total demand calculation unit obtaining the comparison result of the production comparison unit and executing the corresponding calculation strategy according to the result are as follows:
[0022] If the daily production demand Rxq is less than or equal to the daily production demand upper limit Sc max , predict the quantity of all types of materials required for the next replenishment cycle based on the daily production demand Rxq;
[0023] If the daily production demand Rxq is greater than the daily production demand upper limit Sc max , according to the upper limit of daily production demand Sc max Forecast the quantity of all types of materials required for the next replenishment cycle.
[0024] Preferably, the formula for predicting the quantity of all types of materials required for the next replenishment cycle is as follows:
[0025]
[0026] Where Zxq is the predicted quantity of materials required for the next replenishment cycle, T is the replenishment cycle, and β is the average delivery time.
[0027] Preferably, the maximum total amount of a single type of material stored in the next delivery cycle is calculated as Hwzl max The formula is as follows:
[0028]
[0029] In the formula, Dqcc aq is the preset warehouse material storage volume based on the current material price, Dqwj is the current material price, θ is the impact ratio of the set material price fluctuation on the warehouse safety storage volume, η is the annual growth ratio of the material, is the average price of materials purchased in the previous year, Dqcc bz The price set is The safe storage capacity of the warehouse at that time.
[0030] Preferably, the corresponding replenishment strategy is executed according to the comparison result as follows:
[0031] If Hwzl max ≤Szz, normal replenishment, and calculate the required replenishment quantity;
[0032] If Hwzl max >Szz, calculate the required replenishment quantity, calculate the difference ratio between the replenishment quantity and the storage upper limit Szz, and then execute the corresponding replenishment strategy based on the difference ratio.
[0033] Preferably, the calculation formula for the replenishment quantity is as follows:
[0034] Bhl=Zxq+Dqcc aq -Dqcc
[0035] In the formula, Bhl is the replenishment quantity, and Dqcc is the total amount of materials currently stored in the warehouse;
[0036] The formula for calculating the difference ratio between the replenishment quantity and the storage upper limit Szz is as follows:
[0037]
[0038] Where Czbl is the difference ratio between the replenishment quantity and the storage upper limit.
[0039] Preferably, the corresponding replenishment strategy is executed according to the difference ratio as follows:
[0040] like Adjust the replenishment date so that the required replenishment quantity can be stored in the warehouse;
[0041] like Replenish goods in batches, replenish the goods for the first time, and calculate the date for the second replenishment;
[0042] like Increase the number of warehouses;
[0043] The calculation formula for the replenishment date is as follows:
[0044]
[0045] Where Bhrq is the best replenishment date, Dqrq is the current date, and ROUNDUP() is the round-up function.
[0046] Preferably, the replenishment plan identifies the item replenishment date and the item second replenishment date, and the corresponding order date is calculated according to the average delivery time.
[0047] (III) Beneficial effects
[0048] The present invention provides a material scheduling system for warehouse management, which has the following beneficial effects:
[0049] 1. The present invention records a material scheduling system for warehouse management, which fully combines the order data and production data of the enterprise, analyzes the enterprise's demand for various materials, and analyzes it in combination with the enterprise's daily production demand upper limit, thereby calculating the enterprise's actual demand for various materials in the next replenishment cycle. The overall calculation is relatively accurate, and can help the enterprise manage the replenishment of materials more scientifically, greatly reducing the capital investment in replenishment, and at the same time can effectively avoid the situation where too much material purchase leads to serious material backlog, without the need for subsequent low-price processing of accumulated inventory materials, can reduce the workload of relevant personnel, has good use effect, and has a good use prospect.
[0050] 2. The present invention records a material scheduling system for warehouse management, which establishes corresponding warehouse safety storage capacity according to material prices. When the price is low, the warehouse safety storage capacity is increased to replenish more materials. When the price is high, the warehouse safety storage capacity is reduced and less materials are replenished, which makes the replenishment of materials more flexible and greatly reduces the cost of material replenishment. At the same time, the replenishment strategy is combined with the enterprise's warehousing capacity for analysis to formulate a corresponding replenishment strategy, so that the replenishment quantity does not need to increase the number of warehouses within a certain range, effectively avoiding the workload caused by changes in the number and location of warehouses, and having good use effect and good use prospects. BRIEF DESCRIPTION OF THE DRAWINGS
[0051] Figure 1 The present invention is a flow chart of the use of a material scheduling system for warehouse management. DETAILED DESCRIPTION
[0052] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0053] Reasons for research
[0054] The material scheduling system for warehouse management of the present invention is mainly aimed at the scheme adopted by the existing system to feed materials according to the constant production speed of the equipment. However, in actual production, when an urgent order appears, the production speed and production time of the equipment will be adjusted. When adjusting the production speed and production time, the equipment demand is naturally clear. At this time, the most important thing is to ensure that the storage volume of materials in the warehouse is sufficient. Therefore, this method is based on a warehouse that can store sufficient materials for a long time. However, in practice, this method requires a large amount of capital investment, which does not meet actual needs;
[0055] There are also some systems that analyze the total demand through inventory and order data, and then calculate the replenishment quantity of materials based on inventory and safety stock. When actually purchasing, they do not consider factors such as production, warehousing and market price fluctuations. They adopt the most basic on-demand purchasing plan, which makes the overall price of materials purchased throughout the year relatively high, which makes the cost relatively high. Moreover, after the purchase, there is often a shortage of storage space, and it is necessary to adjust the warehouse layout or add new warehouses, which makes the workload relatively large and the cost greatly increased. At the same time, the process needs to be handled by relevant personnel. Therefore, the workload of relevant technical personnel is greatly increased, the processing efficiency of products is reduced, and the enthusiasm of relevant personnel is affected, and people's requirements are not met.
[0056] Design ideas
[0057] Most existing systems directly analyze order data without considering the situation of expedited orders in actual situations. There is a shortage of replenished materials, and in actual production, some materials may be scrapped due to the impact of the qualified rate. Therefore, each material needs to be analyzed separately.
[0058] Therefore, during the research and development process, the initial idea was to analyze each material separately, predict its ordinary orders and expedited orders, and then combine them to predict a more accurate material demand, which can effectively avoid the situation of insufficient material replenishment. Moreover, each material is analyzed separately, but the specific analysis process and analysis principles are the same. Therefore, the specific calculation is more convenient.
[0059] However, in the actual research and development process, it was found that although the above-mentioned plan makes the material control more precise, the market price fluctuates. Therefore, the price of purchasing materials each time is also different. Therefore, it is necessary to formulate a more reasonable material purchasing plan.
[0060] Therefore, in the middle stage of research and development, we analyzed the fluctuations in material prices and the normal cost input of the enterprise. After research, we found that the purchase is inversely proportional to the price, and in an exponential form, that is, the higher the price, the lower the purchase volume, and the lower the price, the higher the purchase volume. After comprehensive analysis, we developed a dynamic warehouse safety storage plan, which can reduce the cost of material purchases to a certain extent, and the overall investment cost is relatively low, which can meet the requirements of the enterprise.
[0061] However, in actual research and development, it was found that companies plan the space in the warehouse in the early stage of production, and the material storage capacity of the warehouse can meet the normal production needs, but usually cannot meet the full-power production (overtime) situation (companies usually set it up for cost considerations), and general product orders are cyclical. There are times when there are more orders for some products. At this time, there is a large demand for some materials. At this time, if they are stacked in the normal way, there may be a situation where materials cannot be put down. At this time, they are generally stacked in other material areas or in new warehouses. However, stacking in other material areas will cause trouble in material transportation or subsequent forgetting of materials, resulting in material backlogs, and the method of adding new warehouses will increase costs. Therefore, it does not meet people's requirements.
[0062] Therefore, in the later stage of research and development, the relationship between replenishment and warehousing is studied to achieve material replenishment at low cost without changing the original layout of the warehouse (without changing the layout, it is more convenient for relevant personnel to transport and retrieve goods, and the efficiency is relatively high), ensuring efficiency while keeping the cost low and the use effect good.
[0063] Study plan
[0064] The material dispatching system for warehouse management of the present invention is based on the existing enterprise management system, extracts warehouse data from the warehouse system in the enterprise management system, extracts order data from the order management system, and extracts production data from the quality management system.
[0065] The material dispatching system for warehouse management of the present invention is based on the existing enterprise management system, and includes a data acquisition module, an analysis and processing module, a storage judgment unit and a solution generation module:
[0066] Data collection module, which obtains material data stored in the warehouse, order data within the next replenishment cycle, and production data;
[0067] Material data is extracted from the warehousing system. Material data is part of the warehousing data. Material data includes the quantity of each material stored in the warehouse and the storage upper limit Szz of each material stored. Order data is extracted from the order management system. Order data includes normal orders and expedited orders. Orders with a total time limit lower than the material purchase cycle are expedited orders, and orders with a total time limit greater than the material purchase cycle are normal orders. Both normal orders and expedited orders include product completion time and product quantity. Production data is extracted from the quality management system. Production data includes the product qualification rate and the quantity of each material corresponding to the processing of each product.
[0068] The above data are directly obtained through the existing production enterprise's own management system, without the need to spend time on separate investigations. Therefore, the cost required to implement this system is relatively low.
[0069] An analysis and processing module, which includes a daily demand calculation unit, a production comparison unit and a total demand calculation unit;
[0070] The daily demand calculation unit analyzes the order data obtained in the next replenishment cycle, calculates the daily production demand Rxq of various materials, and feeds the calculated daily production demand Rxq back to the production comparison unit to determine whether the daily production demand Rxq exceeds the set daily production demand upper limit. The total demand calculation unit obtains the comparison result of the production comparison unit, and executes the corresponding calculation strategy according to the result to predict the quantity of all types of materials required for the next replenishment cycle;
[0071] The present invention records a material scheduling system for warehouse management, which fully combines the order data and production data of the enterprise, analyzes the demand of the enterprise for various materials, and analyzes it in combination with the upper limit of the daily production demand of the enterprise, so as to calculate the actual demand of the enterprise for various materials in the next replenishment cycle. The overall calculation is relatively accurate, and can help the enterprise to manage the replenishment of materials more scientifically, greatly reduce the capital investment in replenishment, and effectively avoid the situation of serious backlog of materials caused by excessive purchase of materials. There is no need to subsequently deal with the accumulated inventory materials at a low price, which can reduce the workload of relevant personnel, has good use effect, and has a good use prospect.
[0072] The calculation formula for the daily production demand Rxq of a material is as follows:
[0073]
[0074] In the formula, Rxq zc Rxq is the daily production demand of materials generated by normal orders. jj is the daily production demand of materials generated by urgent orders, α is the impact ratio of the change in daily production demand of materials caused by orders received in the next replenishment cycle, n is the number of normal orders, Ddxq i is the number of products in the i-th normal order, A i is the amount of material required to produce the product in the i-th normal order, Scsx i is the production time of the i-th normal order, Hgl i is the qualified rate of the i-th normal order product, B is the constant proportional coefficient, C is the predicted proportion of expedited orders in the next replenishment cycle, m is the number of expedited orders, Tsdd i is the number of products in the i-th rush order, D i Hgl′ is the amount of material required to produce the product in the i-th rush order. i is the qualified rate of the product for the i-th expedited order, Scsx′ i is the production efficiency of the i-th urgent order, C>α>0, 25>B>20. This data is for enterprises with normal development, start-up enterprises or enterprises with rapid development. The values of α and α are increased to facilitate subsequent processing.
[0075] is the amount of materials required for the i-th normal order per day, is the amount of materials required for the i-th expedited order every day. The total demand can be directly calculated based on the amount of materials required every day.
[0076] Since ordinary orders usually show periodic changes, while expedited orders have no regular pattern and mainly occur suddenly, if they are directly superimposed and calculated, the prediction effect will be very inaccurate.
[0077] In actual application, the commonly used solutions are to calculate the total demand directly through order data, but this does not take into account the actual situation at all. Most companies have a certain production ceiling, which is higher than normal, but cannot be fully produced when there are many orders. Therefore, the materials prepared at this stage are the upper limit of the production speed (if the materials are purchased according to the orders at this time, there will be material accumulation, which requires additional warehouse fees, and the cost of the materials invested this time will increase significantly, which does not meet the requirements of the company).
[0078] The main orders of an enterprise are ordinary orders, and some are expedited orders. The price of expedited orders is high, but there is generally no regularity, while the price of ordinary orders is low, and it basically presents a certain regularity, usually relatively constant, or fluctuates within a certain proportion. Generally, expedited orders account for 20% of ordinary orders, and expedited orders have high profits. Therefore, expedited orders are generally given priority, and ordinary orders are produced according to the previously formulated steps. In order to avoid insufficient materials for expedited orders, when expedited orders are lower than 20% of ordinary orders, the materials are calculated according to 20% of ordinary orders. When they exceed 20% of ordinary orders, the materials are replenished according to the order data and a certain proportion is added.
[0079] The value range of C is 5%-10%
[0080] Therefore, the method of calculating all orders cannot be used in actual calculations, as this method will often result in insufficient warehouse space.
[0081] This patent fully takes this situation into consideration and uses 20% of the daily material production demand for expedited orders as the dividing line. In actual use, 20% can be adjusted and replaced with other values based on actual orders.
[0082] The formula for predicting the quantity of all types of materials required for the next replenishment cycle is as follows:
[0083]
[0084] Where Zxq is the predicted quantity of materials required for the next replenishment cycle, T is the replenishment cycle, and β is the average delivery time.
[0085] The material demand for the entire replenishment cycle is calculated based on the calculated daily material production demand.
[0086] Because it is necessary to consider the consumption of materials during the delivery time and to ensure the safe storage of materials, the consumption of materials during the delivery time must also be added when calculating the material demand for the entire replenishment cycle.
[0087] For example, to produce a certain expedited order, the replenishment cycle is 30 days, 0.5 tons of materials are consumed every day, and the average replenishment transportation time is 6 days. Then the quantity of all types of materials required for the next replenishment cycle is Zxq = 0.5 × (30 + 6) = 18 tons.
[0088] The steps of the total demand calculation unit obtaining the comparison result of the production comparison unit and executing the corresponding calculation strategy according to the result are as follows:
[0089] If the daily production demand Rxq is less than or equal to the daily production demand upper limit Sc max , predict the quantity of all types of materials required for the next replenishment cycle based on the daily production demand Rxq;
[0090] If the daily production demand Rxq is greater than the daily production demand upper limit Sc max , according to the upper limit of daily production demand Sc max Forecast the quantity of all types of materials required for the next replenishment cycle.
[0091] The storage judgment unit obtains the data of the quantity of all types of materials required for the next replenishment cycle, and calculates the maximum total amount of a single type of material stored in the next supply cycle based on the data Hwzl max , the maximum value of the total amount of goods Hwzl max Compare with the set storage upper limit Szz of the material, and execute the corresponding replenishment strategy according to the comparison result;
[0092] Calculate the maximum total amount of a single type of material stored in the next delivery cycle Hwzl max The formula is as follows:
[0093]
[0094] In the formula, Dqcc aq is the preset warehouse material storage volume based on the current material price, Dqwj is the current material price, θ is the impact ratio of the set material price fluctuation on the warehouse safety storage volume, η is the annual growth ratio of the material, is the average price of materials purchased in the previous year, Dqcc bz The price set is The warehouse safety storage capacity at that time, K is the number of times the material was purchased in the previous year, Wlzl i is the price of the material purchased for the i-th time.
[0095] For example, the average price of materials purchased last year The current price is 12,000 yuan per ton, η is 5%, θ is 10, Dqcc bz is 10t, then calculate
[0096] HkDJ max Assuming that the order is placed today and the goods are delivered immediately, Hwzl max =18+7.96=25.96t.
[0097] Regardless of how much material is stored in the warehouse before, each purchase only needs to consider consumption and the warehouse's safe storage capacity. Therefore, the maximum total material volume has nothing to do with the current warehouse material storage volume.
[0098] The corresponding replenishment strategy is implemented according to the comparison results as follows:
[0099] If Hwzl max ≤Szz, normal replenishment, and calculate the required replenishment quantity. In this case, the current warehouse can store all materials, so there is no need to consider, and purchase directly;
[0100] If Hwzl max >Szz, calculate the required replenishment quantity, calculate the difference ratio between the replenishment quantity and the storage upper limit Szz, and then execute the corresponding replenishment strategy according to the difference ratio. In this case, the current warehouse cannot accommodate all materials and further analysis is required.
[0101] The formula for calculating the replenishment quantity is as follows:
[0102] Bhl=Zxq+Dqcc aq -Dqcc
[0103] In the formula, Bhl is the replenishment quantity, and Dqcc is the total amount of materials currently stored in the warehouse;
[0104] For example, Zxq+Dqcc aq It is 25.96t, and the total amount of materials stored in the front warehouse Dqcc is 10t, then the replenishment quantity Bhl = 25.96-10 = 15.96t.
[0105] For further analysis, it is necessary to further calculate the difference ratio;
[0106] The formula for calculating the difference ratio between the replenishment quantity and the storage upper limit Szz is as follows:
[0107]
[0108] Where Czbl is the difference ratio between the replenishment quantity and the storage upper limit.
[0109] The above method can directly calculate whether the replenishment quantity can be stored in the warehouse.
[0110] The corresponding replenishment strategy is implemented according to the difference ratio as follows:
[0111] like Adjust the replenishment date so that the required replenishment quantity can be stored in the warehouse;
[0112] The lowest bottom line is one-third of the warehouse's safe storage capacity. Any reduction in this amount may lead to accidents.
[0113] like Replenish goods in batches, replenish the goods for the first time, and calculate the date for the second replenishment;
[0114] because is the lowest bottom line, so the second replenishment can only be replenished The maximum amount of the first replenishment is Szz-Dqcc, and the maximum amount of the second replenishment is (The delivery cycle can also be considered. When the delivery cycle is considered, the first replenishment of goods is Szz-Dqcc+(β-2)×Sc max To avoid early delivery of goods, the maximum number of replenishments is two times.
[0115]
[0116] like Increase the number of warehouses;
[0117] In this case, multiple delivery orders and the management in the middle are rather troublesome, and the prices are almost the same. Therefore, choosing to add a warehouse is more efficient overall, requires less manpower, can be completed in one go, and has a good effect.
[0118] Warnings are issued in three situations: adjusting the replenishment date, replenishing in batches, and increasing the number of warehouses, helping relevant personnel to make corresponding plans. The overall efficiency is relatively good and the use effect is good.
[0119] The calculation formula for the replenishment date is as follows:
[0120]
[0121] Where Bhrq is the best replenishment date, Dqrq is the current date, and ROUNDUP() is the round-up function.
[0122] The situation involving replenishment is that there are too many orders. At this time, the normal situation is that the enterprise has already produced according to the upper limit of daily production demand.
[0123] If the warehouse is too small, there is a possibility that the production does not meet the upper limit of the daily production demand. max Just replace it with Rxq calculation.
[0124] In the previous calculation, Rxq is used to calculate the quantity of all types of materials required for the next replenishment cycle. Then Rxq is also used to calculate the replenishment date. Sc is used in the previous calculation. max The calculated forecast of the quantity of all types of materials required for the next replenishment cycle, then the replenishment date is also calculated using Sc max calculate.
[0125] The plan generation module obtains the replenishment strategies of all materials and aggregates all replenishment strategies to generate a replenishment plan.
[0126] The replenishment plan identifies the item replenishment date and the item second replenishment date, and calculates the corresponding order date based on the average delivery time. This can fully utilize the warehouse, minimize warehouse changes, reduce changes in warehouse layout, and significantly reduce the adaptation time for relevant personnel.
[0127] The replenishment plan identifies the demand corresponding to each order, and when the order changes, corresponding adjustments can be made to facilitate subsequent management.
[0128] It should be noted that the present invention records a material scheduling system for warehouse management, which establishes corresponding warehouse safety storage capacity according to material prices. When the price is low, the warehouse safety storage capacity is increased to replenish more materials. When the price is high, the warehouse safety storage capacity is lowered and less materials are replenished, thereby making the replenishment of materials more flexible and greatly reducing the cost of material replenishment. At the same time, the replenishment strategy is combined with the enterprise's warehousing capacity for analysis to formulate a corresponding replenishment strategy, so that the replenishment quantity does not need to increase the number of warehouses within a certain range, effectively avoiding the workload caused by changes in the number and location of warehouses, and having good use effect and good use prospects.
[0129] The above formula is a formula obtained by collecting a large amount of data and performing software simulation to obtain the most recent real situation. The preset parameters in the formula are set by technicians in this field according to actual conditions.
[0130] The above embodiments may be implemented in whole or in part by software, hardware, firmware or any other combination thereof. When implemented using software, the above embodiments may be implemented in whole or in part in the form of a computer program product. A person of ordinary skill in the art may appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein may be implemented in electronic hardware, or in a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution.
[0131] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, and may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0132] The above description is only a specific implementation manner of the present application, but the protection scope of the present application is not limited thereto. Any technician familiar with the technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application.
Claims
1. A material dispatching system for warehouse management, characterized in that: include: Data collection module, which obtains material data stored in the warehouse, order data within the next replenishment cycle, and production data; An analysis and processing module, which includes a daily demand calculation unit, a production comparison unit and a total demand calculation unit; The daily demand calculation unit analyzes the order data obtained in the next replenishment cycle, calculates the daily production demand Rxq of various materials, and feeds the calculated daily production demand Rxq back to the production comparison unit to determine whether the daily production demand Rxq exceeds the set daily production demand upper limit. The total demand calculation unit obtains the comparison result of the production comparison unit, and executes the corresponding calculation strategy according to the result to predict the quantity of all types of materials required for the next replenishment cycle; The storage judgment unit obtains the data of the quantity of all types of materials required for the next replenishment cycle, and calculates the maximum total amount of a single type of material stored in the next supply cycle based on the data Hwzl max , the maximum value of the total amount of goods Hwzl max Compare with the set storage upper limit Szz of the material, and execute the corresponding replenishment strategy according to the comparison result; The plan generation module obtains the replenishment strategies of all materials and aggregates all replenishment strategies to generate a replenishment plan.
2. A material dispatching system for warehouse management according to claim 1, characterized in that: The material data includes the quantity of each material stored in the warehouse and the storage upper limit Szz of each material stored. The order data includes normal orders and expedited orders. An expedited order is one whose total order time is lower than the material purchase cycle, and a normal order is one whose total order time is higher than the material purchase cycle. Both normal orders and expedited orders include product completion time and product quantity. Production data includes the product qualification rate and the quantity of each material corresponding to the processing of each product.
3. A material dispatching system for warehouse management according to claim 2, characterized in that: The calculation formula for the material daily production demand Rxq is as follows: In the formula, Rxq zc Rxq is the daily production demand of materials generated by normal orders. jj is the daily production demand of materials generated by urgent orders, α is the impact ratio of the change in daily production demand of materials caused by orders received in the next replenishment cycle, n is the number of normal orders, Ddxq i is the number of products in the i-th normal order, A i is the amount of material required to produce the product in the i-th normal order, Scsx i is the production time of the i-th normal order, Hgl i is the qualified rate of the i-th normal order product, B is the constant proportional coefficient, C is the predicted proportion of expedited orders in the next replenishment cycle, m is the number of expedited orders, Tsdd i is the number of products in the i-th rush order, D i Hgl′ is the amount of material required to produce the product in the i-th rush order. i is the qualified rate of the product for the i-th expedited order, Scsx′ i is the production time of the i-th urgent order, C>α>0, 25>B>20.
4. A material dispatching system for warehouse management according to claim 3, characterized in that: The steps of the total demand calculation unit obtaining the comparison result of the production comparison unit and executing the corresponding calculation strategy according to the result are as follows: If the daily production demand Rxq is less than or equal to the daily production demand upper limit Sc max , predict the quantity of all types of materials required for the next replenishment cycle based on the daily production demand Rxq; If the daily production demand Rxq is greater than the daily production demand upper limit Sc max , according to the upper limit of daily production demand Sc max Forecast the quantity of all types of materials required for the next replenishment cycle.
5. A material dispatching system for warehouse management according to claim 4, characterized in that: The formula for predicting the quantity of all types of materials required for the next replenishment cycle is as follows: Where Zxq is the predicted quantity of materials required for the next replenishment cycle, T is the replenishment cycle, and β is the average delivery time.
6. A material dispatching system for warehouse management according to claim 5, characterized in that: The maximum value Hwzl of the total amount of a single type of material stored in the next delivery cycle is calculated max The formula is as follows: In the formula, Dqcc aq is the preset warehouse material storage volume based on the current material price, Dqwj is the current material price, θ is the impact ratio of the set material price fluctuation on the warehouse safety storage volume, η is the annual growth ratio of the material, is the average price of materials purchased in the previous year, Dqcc bz The price set is The safe storage capacity of the warehouse at that time.
7. A material dispatching system for warehouse management according to claim 6, characterized in that: The corresponding replenishment strategy is implemented according to the comparison results as follows: If Hwzl max ≤Szz, normal replenishment, and calculate the required replenishment quantity; If Hwzl max >Szz, calculate the required replenishment quantity, calculate the difference ratio between the replenishment quantity and the storage upper limit Szz, and then execute the corresponding replenishment strategy based on the difference ratio.
8. A material dispatching system for warehouse management according to claim 7, characterized in that: The calculation formula for the replenishment quantity is as follows: Bhl=Zxq+Dqcc aq -Dqcc In the formula, Bhl is the replenishment quantity, and Dqcc is the total amount of materials currently stored in the warehouse; The formula for calculating the difference ratio between the replenishment quantity and the storage upper limit Szz is as follows: Where Czbl is the difference ratio between the replenishment quantity and the storage upper limit.
9. A material dispatching system for warehouse management according to claim 8, characterized in that: The corresponding replenishment strategy is implemented according to the difference ratio as follows: like Adjust the replenishment date so that the required replenishment quantity can be stored in the warehouse; like Replenish goods in batches, replenish the goods for the first time, and calculate the date for the second replenishment; like Increase the number of warehouses; The calculation formula for the replenishment date is as follows: Where Bhrq is the best replenishment date, Dqrq is the current date, and ROUNDUP() is the round-up function.
10. A material dispatching system for warehouse management according to claim 9, characterized in that: The replenishment plan identifies the item replenishment date and the item second replenishment date, and calculates the corresponding order date according to the average delivery time.
Citation Information
Patent Citations
Replenishment task information generation method and device, electronic equipment and storage medium
CN113837678A
Material management method and system
CN114266521A
Material processing method, device and system and computer readable storage medium
CN116187900A
Cross-warehouse inventory scheduling system
CN117875842A
Intelligent management and control warehouse management system for physical asset professional warehouse
CN117875852A
Cited By
Packaging bag material dispatching system
CN120156800A
A packaging bag material scheduling system
CN120156800B
Automobile wire harness production material intelligent matching and inventory management system
CN121146684A
