[go: up one dir, main page]

CN117010938A - Order quantity optimizing system, order quantity optimizing method, and recording medium - Google Patents

Order quantity optimizing system, order quantity optimizing method, and recording medium Download PDF

Info

Publication number
CN117010938A
CN117010938A CN202210462187.1A CN202210462187A CN117010938A CN 117010938 A CN117010938 A CN 117010938A CN 202210462187 A CN202210462187 A CN 202210462187A CN 117010938 A CN117010938 A CN 117010938A
Authority
CN
China
Prior art keywords
replenishment
demand
inventory
order
commodity
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202210462187.1A
Other languages
Chinese (zh)
Inventor
左滨
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hitachi Building Systems Co Ltd
Original Assignee
Hitachi Building Systems Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hitachi Building Systems Co Ltd filed Critical Hitachi Building Systems Co Ltd
Priority to CN202210462187.1A priority Critical patent/CN117010938A/en
Publication of CN117010938A publication Critical patent/CN117010938A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201Market modelling; Market analysis; Collecting market data
    • G06Q30/0202Market predictions or forecasting for commercial activities
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0633Managing shopping lists, e.g. compiling or processing purchase lists
    • G06Q30/0635Managing shopping lists, e.g. compiling or processing purchase lists replenishment orders; recurring orders

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Strategic Management (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Game Theory and Decision Science (AREA)
  • Data Mining & Analysis (AREA)
  • Human Resources & Organizations (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

本发明提供一种订单量优化系统、订单量优化方法以及记录介质。订单量优化系统具备:数据收集单元,收集与商品有关的业务数据的历史数据;需求预测单元,基于所述历史数据,对每种商品利用多个预测算法来预测未来需求量;以及预测算法选择单元,对于每种商品,利用过去给定期间内所述多个预测算法的需求预测历史值以及该给定期间内的需求实际值,计算所述多个预测算法中每个预测算法的预测精度,选择出预测精度最高的预测算法,并从所述需求预测单元获取所述预测精度最高的预测算法关于所述未来需求量的需求预测值。由此,能够迅速且准确地实现订单业务。

The invention provides an order quantity optimization system, an order quantity optimization method and a recording medium. The order quantity optimization system has: a data collection unit that collects historical data of business data related to commodities; a demand forecasting unit that uses multiple prediction algorithms for each commodity to predict future demand based on the historical data; and prediction algorithm selection A unit that, for each commodity, calculates the prediction accuracy of each of the plurality of prediction algorithms using the historical demand prediction values of the plurality of prediction algorithms in the past given period and the actual demand value in the given period. , select the prediction algorithm with the highest prediction accuracy, and obtain the demand prediction value of the prediction algorithm with the highest prediction accuracy regarding the future demand from the demand prediction unit. As a result, order business can be completed quickly and accurately.

Description

订单量优化系统、订单量优化方法以及记录介质Order volume optimization system, order volume optimization method and recording medium

技术领域Technical field

本发明涉及订单量优化系统、订单量优化方法以及记录介质。The invention relates to an order quantity optimization system, an order quantity optimization method and a recording medium.

背景技术Background technique

在生产制造、产品销售等各项业务中,需要进行多种物料、设备、产品等商品的采购,为了使采购的订单量与需求情况以及库存情况等相匹配,需要合理地制定订单计划。以往,通过现场的熟练者根据自身的经验来制定订单计划,包括商品种类的选定、订单量的确定、交货期的指定等,不仅需要耗费大量的人力和时间,还存在订单量与需求情况以及库存情况不匹配而影响生产销售的问题。因此,希望能够将制定订单计划的业务数字化,自动且准确地制定订单计划。In various businesses such as manufacturing and product sales, it is necessary to purchase a variety of materials, equipment, products and other commodities. In order to match the purchased order volume with demand and inventory conditions, order plans need to be formulated reasonably. In the past, skilled workers on site made order plans based on their own experience, including selecting product types, determining order quantities, specifying delivery dates, etc. This not only required a lot of manpower and time, but also involved order volume and demand. The situation and inventory situation do not match, which affects production and sales. Therefore, it is hoped that the business of making order plans can be digitized and order plans can be made automatically and accurately.

专利文献1提出了一种基于供应链需求的智能补货系统,该系统由需求预测模块、业务分析模块和智能补货模块构成。需求预测模块用于对每个商店、每个产品的需求进行预测。业务分析模块用于根据商品的相关信息和相关的销售目标,与需求预测的结果相应地进行需求分类。智能补货模块用于利用需求预测模块、业务分析模块的结果,与需求分类相应地自动生成库存补货计划。Patent Document 1 proposes an intelligent replenishment system based on supply chain demand. The system consists of a demand forecast module, a business analysis module and an intelligent replenishment module. The demand forecast module is used to predict demand for each store and each product. The business analysis module is used to classify demand according to the relevant information of the product and related sales targets, and in accordance with the results of demand forecasting. The intelligent replenishment module is used to use the results of the demand forecast module and business analysis module to automatically generate inventory replenishment plans corresponding to demand classification.

但是,在专利文献1的智能补货系统中存在如下问题。However, the intelligent replenishment system of Patent Document 1 has the following problems.

首先,在需求预测方面,专利文献1中仅笼统地提及一些预测算法,并未记载如何利用这些预测算法进行预测。在实际业务中,不同商品的特性不同,例如有的商品需求变动相对稳定,有的商品需求变动较大。对于需求变动较大的商品,即使采用机器学习或AI模型进行预测,往往预测精度也比较低。也就是说,虽然存在多种预测算法,但并没有适合于所有商品的预测算法。因此,存在难以对每种商品选择适合的预测算法的问题。First, in terms of demand forecasting, Patent Document 1 only briefly mentions some forecasting algorithms and does not describe how to use these forecasting algorithms for forecasting. In actual business, different commodities have different characteristics. For example, the demand for some commodities changes relatively steadily, while the demand for some commodities fluctuates greatly. For commodities with large demand changes, even if machine learning or AI models are used for prediction, the prediction accuracy is often relatively low. In other words, although there are many prediction algorithms, there is no prediction algorithm suitable for all commodities. Therefore, there is a problem that it is difficult to select an appropriate prediction algorithm for each commodity.

其次,在库存补货方面,专利文献1中采用的是预先为商品制定的固定的补货策略。在实际业务中,大多情况下各商品所需的库存量是实时变化的,因此若按照固定的补货策略进行补货,则存在不能满足实际的补货要求的问题。另外,通常,补货计划不能直接作为订单计划来实施,由于供应商方面存在产能限制,因此在补货计划与供应商的产能不匹配的情况下需要调整补货计划来制定最终的订单计划。在专利文献1中,仅涉及到补货计划,并未涉及订单计划,存在需要适当地对各种商品的补货计划进行调整的问题。Secondly, in terms of inventory replenishment, Patent Document 1 adopts a fixed replenishment strategy formulated in advance for the product. In actual business, in most cases the inventory required for each commodity changes in real time. Therefore, if replenishment is carried out according to a fixed replenishment strategy, there is a problem that the actual replenishment requirements cannot be met. In addition, usually, the replenishment plan cannot be implemented directly as an order plan because there are capacity constraints on the supplier. Therefore, if the replenishment plan does not match the supplier's production capacity, the replenishment plan needs to be adjusted to formulate the final order plan. Patent Document 1 only relates to the replenishment plan and does not relate to the order plan, and there is a problem that the replenishment plan of each product needs to be appropriately adjusted.

现有技术文献existing technical documents

专利文献1:CN110516998 APatent document 1: CN110516998 A

发明内容Contents of the invention

本发明为了解决上述问题而提出,其目的在于,提供一种能够迅速且准确地实现订单业务的订单量优化系统、订单量优化方法以及记录介质。The present invention is proposed to solve the above problems, and its purpose is to provide an order volume optimization system, an order volume optimization method, and a recording medium that can quickly and accurately implement order business.

用于解决课题的手段Means used to solve problems

为了实现上述目的,根据本发明的第一方面,提供了一种订单量优化系统,具备:数据收集单元,收集与商品有关的业务数据的历史数据;需求预测单元,基于所述历史数据,对每种商品利用多个预测算法来预测未来需求量;以及预测算法选择单元,对于每种商品,利用过去给定期间内所述多个预测算法的需求预测历史值以及该给定期间内的需求实际值,计算所述多个预测算法中每个预测算法的预测精度,选择出预测精度最高的预测算法,并从所述需求预测单元获取所述预测精度最高的预测算法关于所述未来需求量的需求预测值。In order to achieve the above object, according to the first aspect of the present invention, an order volume optimization system is provided, which is provided with: a data collection unit to collect historical data of business data related to commodities; a demand forecasting unit to predict and predict business data based on the historical data. each commodity utilizes multiple forecasting algorithms to predict future demand; and a forecasting algorithm selection unit that, for each commodity, forecasts historical values of demand using the multiple forecasting algorithms for a given period in the past and demand within the given period. Actual value, calculate the prediction accuracy of each prediction algorithm among the plurality of prediction algorithms, select the prediction algorithm with the highest prediction accuracy, and obtain the prediction algorithm with the highest prediction accuracy from the demand prediction unit about the future demand demand forecast value.

根据本发明的第二方面,提供了一种订单量优化系统,具备:数据收集单元,收集与商品有关的业务数据的历史数据;需求预测单元,基于所述历史数据,对每种商品的未来需求量进行预测;以及库存标准设定单元,对于每种商品,基于所述历史数据求出表示商品的重要度的需求特性指标,根据求出的需求特性指标以及从所述需求预测单元获取的需求预测值,设定多个级别的库存标准。According to a second aspect of the present invention, an order quantity optimization system is provided, which is provided with: a data collection unit that collects historical data of business data related to commodities; a demand forecasting unit that predicts the future of each commodity based on the historical data. Forecasting demand; and an inventory standard setting unit that, for each commodity, obtains a demand characteristic index indicating the importance of the commodity based on the historical data, and based on the obtained demand characteristic index and the demand prediction unit obtained from the demand prediction unit Demand forecast values set inventory standards at multiple levels.

根据本发明的第三方面,提供了一种订单量优化系统,具备:数据收集单元,收集与商品有关的业务数据的历史数据;需求预测单元,基于所述历史数据,对每种商品的未来需求量进行预测;库存量模拟单元,对于每种商品,根据当前库存量、订单剩余量以及从所述需求预测单元获取的需求预测值,对未来给定期间内的库存量变化进行模拟;以及补货计划生成单元,对于每种商品,根据从所述库存量模拟单元获取的所述未来给定期间内的最终单位期间的库存量,确定该商品当前需要补货的补货优先级以及多个档位的补货量,生成包括作为补货对象的所有商品的补货优先级以及多个档位的补货量在内的补货计划。According to a third aspect of the present invention, an order volume optimization system is provided, which is provided with: a data collection unit that collects historical data of business data related to commodities; a demand forecasting unit that predicts the future of each commodity based on the historical data. Demand is forecasted; an inventory simulation unit is configured to, for each commodity, simulate changes in inventory within a given period in the future based on the current inventory, remaining orders, and demand forecast values obtained from the demand forecasting unit; and The replenishment plan generation unit determines, for each commodity, the replenishment priority and quantity of the commodity that currently need to be replenished based on the inventory of the final unit period in the future given period obtained from the inventory simulation unit. The replenishment amount of each stall generates a replenishment plan including the replenishment priority of all products as replenishment objects and the replenishment amounts of multiple stalls.

根据本发明的第四方面,提供了一种订单量优化系统,具备:数据收集单元,收集与商品有关的业务数据的历史数据;需求预测单元,基于所述历史数据,对每种商品的未来需求量进行预测;补货计划生成单元,对于每种商品,根据所述需求预测单元的预测结果,生成包括作为补货对象的所有商品的补货量的补货计划;以及订单计划生成单元,对所述补货计划中的补货量进行调整,使得与供应商的产能匹配,将调整后的补货量作为订单量,生成包括所述所有商品的订单量的订单计划。According to a fourth aspect of the present invention, an order volume optimization system is provided, including: a data collection unit that collects historical data of business data related to commodities; a demand forecasting unit that predicts the future of each commodity based on the historical data. Demand quantity is forecasted; a replenishment plan generation unit generates, for each commodity, a replenishment plan including the replenishment quantity of all commodities as replenishment objects based on the prediction results of the demand prediction unit; and an order plan generation unit, The replenishment quantity in the replenishment plan is adjusted to match the supplier's production capacity, the adjusted replenishment quantity is used as the order quantity, and an order plan including the order quantity of all commodities is generated.

根据本发明的第五方面,提供了一种订单量优化方法,包括:数据收集步骤,收集与商品有关的业务数据的历史数据;需求预测步骤,基于所述历史数据,对每种商品利用多个预测算法来预测未来需求量;以及预测算法选择步骤,对于每种商品,利用过去给定期间内所述多个预测算法的需求预测历史值以及该给定期间内的需求实际值,计算所述多个预测算法中每个预测算法的预测精度,选择出预测精度最高的预测算法,并获取所述需求预测步骤中的所述预测精度最高的预测算法关于所述未来需求量的需求预测值。According to the fifth aspect of the present invention, an order volume optimization method is provided, including: a data collection step, which collects historical data of business data related to commodities; a demand forecasting step, which uses multiple data for each commodity based on the historical data. A forecasting algorithm is used to predict future demand; and a forecasting algorithm selection step, for each commodity, uses the historical demand forecast values of the multiple forecasting algorithms in the past given period and the actual demand value in the given period to calculate the The prediction accuracy of each prediction algorithm among the plurality of prediction algorithms is determined, the prediction algorithm with the highest prediction accuracy is selected, and the demand prediction value of the prediction algorithm with the highest prediction accuracy in the demand prediction step regarding the future demand is obtained. .

根据本发明的第六方面,提供了一种订单量优化方法,包括:数据收集步骤,收集与商品有关的业务数据的历史数据;需求预测步骤,基于所述历史数据,对每种商品的未来需求量进行预测;以及库存标准设定步骤,对于每种商品,基于所述历史数据求出表示商品的重要度的需求特性指标,根据求出的需求特性指标以及所述需求预测步骤中的需求预测值,设定多个级别的库存标准。According to the sixth aspect of the present invention, an order volume optimization method is provided, including: a data collection step to collect historical data of business data related to commodities; a demand forecasting step to predict the future of each commodity based on the historical data. Forecasting demand; and an inventory standard setting step, for each commodity, obtaining a demand characteristic index indicating the importance of the commodity based on the historical data, and based on the obtained demand characteristic index and the demand in the demand forecasting step Forecast values, setting inventory standards at multiple levels.

根据本发明的第七方面,提供了一种订单量优化方法,包括:数据收集步骤,收集与商品有关的业务数据的历史数据;需求预测步骤,基于所述历史数据,对每种商品的未来需求量进行预测;库存量模拟步骤,对于每种商品,根据当前库存量、订单剩余量以及所述需求预测步骤中的需求预测值,对未来给定期间内的库存量变化进行模拟;以及补货计划生成步骤,对于每种商品,根据所述库存量模拟步骤中的所述未来给定期间内的最终单位期间的库存量,确定该商品当前需要补货的补货优先级以及多个档位的补货量,生成包括作为补货对象的所有商品的补货优先级以及多个档位的补货量在内的补货计划。According to the seventh aspect of the present invention, an order quantity optimization method is provided, including: a data collection step to collect historical data of business data related to commodities; a demand forecasting step to predict the future of each commodity based on the historical data. Forecasting demand; an inventory simulation step, for each commodity, simulating changes in inventory within a given period in the future based on the current inventory, remaining orders, and the demand forecast value in the demand forecasting step; and supplementing In the inventory plan generation step, for each commodity, according to the inventory amount in the final unit period in the future given period in the inventory simulation step, determine the replenishment priority and multiple slots that the commodity currently needs to replenish. Based on the replenishment quantity of each position, a replenishment plan is generated including the replenishment priority of all products as replenishment objects and the replenishment quantity of multiple levels.

根据本发明的第八方面,提供了一种订单量优化方法,包括:数据收集步骤,收集与商品有关的业务数据的历史数据;需求预测步骤,基于所述历史数据,对每种商品的未来需求量进行预测;补货计划生成步骤,对于每种商品,根据所述需求预测步骤的预测结果,生成包括作为补货对象的所有商品的补货量的补货计划;以及订单计划生成步骤,对所述补货计划中的补货量进行调整,使得与供应商的产能匹配,将调整后的补货量作为订单量,生成包括所述所有商品的订单量的订单计划。According to an eighth aspect of the present invention, an order volume optimization method is provided, including: a data collection step, which collects historical data of business data related to commodities; and a demand forecasting step, which predicts the future of each commodity based on the historical data. Forecasting the demand quantity; a replenishment plan generating step, for each commodity, generating a replenishment plan including the replenishment quantities of all commodities as replenishment objects according to the prediction results of the demand forecasting step; and an order plan generating step, The replenishment quantity in the replenishment plan is adjusted to match the supplier's production capacity, the adjusted replenishment quantity is used as the order quantity, and an order plan including the order quantity of all commodities is generated.

根据本发明的第九方面,提供了一种计算机可读取的记录介质,存储有程序,其特征在于,所述程序用于使计算机执行上述订单量优化方法。According to a ninth aspect of the present invention, there is provided a computer-readable recording medium storing a program, wherein the program is used to cause a computer to execute the above order quantity optimization method.

发明效果Invention effect

根据本发明的订单量优化系统、订单量优化方法以及记录介质,能够不依赖于熟练者的经验而自动地执行订单业务,并且能够迅速且准确地实现订单业务。由此,能够提高库存管理的效率以及精度。由于能够恰当地管理库存,不会出现库存积压或者缺货的情况,因此能够防止库存积压导致的资金周转困难以及缺货导致的停产等风险。According to the order volume optimization system, the order volume optimization method and the recording medium of the present invention, the order business can be automatically executed without relying on the experience of a skilled person, and the order business can be realized quickly and accurately. This can improve the efficiency and accuracy of inventory management. Since inventory can be properly managed, there will be no overstocking or shortage of stock. Therefore, risks such as difficulties in capital turnover caused by inventory backlog and production shutdown caused by shortage can be prevented.

附图说明Description of the drawings

图1是表示本发明的订单量优化系统以及方法被应用的应用对象的一个例子的示意图。FIG. 1 is a schematic diagram showing an example of an application object to which the order quantity optimization system and method of the present invention are applied.

图2是表示本发明的第一实施方式的订单量优化系统的功能结构的框图。FIG. 2 is a block diagram showing the functional structure of the order quantity optimization system according to the first embodiment of the present invention.

图3是表示本发明的第一实施方式的订单量优化方法的流程图。FIG. 3 is a flowchart showing the order quantity optimization method according to the first embodiment of the present invention.

图4是表示本发明的第二实施方式的订单量优化系统的功能结构的框图。FIG. 4 is a block diagram showing the functional structure of the order quantity optimization system according to the second embodiment of the present invention.

图5是表示本发明的第二实施方式的基于ABC分析法进行分类的图。FIG. 5 is a diagram showing classification based on the ABC analysis method according to the second embodiment of the present invention.

图6是表示本发明的第三实施方式的订单量优化系统的功能结构的框图。6 is a block diagram showing the functional structure of the order quantity optimization system according to the third embodiment of the present invention.

图7是表示本发明的第四实施方式的订单量优化系统的功能结构的框图。7 is a block diagram showing the functional structure of the order quantity optimization system according to the fourth embodiment of the present invention.

图8是表示本发明的第五实施方式的订单量优化系统的功能结构的框图。FIG. 8 is a block diagram showing the functional structure of the order quantity optimization system according to the fifth embodiment of the present invention.

图9是表示本发明的第五实施方式的订单量优化方法的流程图。FIG. 9 is a flowchart showing an order quantity optimization method according to the fifth embodiment of the present invention.

图10是表示本发明的第六实施方式的订单量优化系统的功能结构的框图。FIG. 10 is a block diagram showing the functional structure of the order quantity optimization system according to the sixth embodiment of the present invention.

图11是表示本发明的第六实施方式的订单量优化方法的流程图。FIG. 11 is a flowchart showing an order quantity optimization method according to the sixth embodiment of the present invention.

图12是表示本发明的第七实施方式的订单量优化系统的功能结构的框图。FIG. 12 is a block diagram showing the functional structure of the order quantity optimization system according to the seventh embodiment of the present invention.

图13是表示本发明的第七实施方式的订单量优化方法的流程图。FIG. 13 is a flowchart showing an order quantity optimization method according to the seventh embodiment of the present invention.

具体实施方式Detailed ways

以下结合附图、实施方式及具体例子对本发明进行更详细的说明。其中,下述说明只是为了方便理解本发明而举出的例子,不用于限定本发明的范围。在具体实施方式中,装置和系统所具备的部件和单元可以根据实际情况变更、删减或追加,方法的步骤可以根据实际情况变更、删减、追加或改变顺序。对于各附图所示的相同或同等的部件、步骤等标注同一符号,并适当省略重复的说明。The present invention will be described in more detail below with reference to the drawings, embodiments and specific examples. However, the following description is merely an example to facilitate understanding of the present invention, and is not intended to limit the scope of the present invention. In the specific implementation, the components and units of the device and system can be changed, deleted or added according to the actual situation, and the steps of the method can be changed, deleted, added or changed in order according to the actual situation. The same or equivalent components, steps, etc. shown in the respective drawings are denoted by the same symbols, and repeated descriptions are appropriately omitted.

首先,说明本发明的订单量优化系统以及方法能够被应用的应用对象。图1是表示本发明的订单量优化系统以及方法被应用的应用对象的一个例子的示意图。在图1中,示出了工厂1、工厂2、工厂3这三个工厂,并且示出了供应商1、供应商2这两个供应商,但工厂和供应商的数量并不限定于此。First, the application objects to which the order volume optimization system and method of the present invention can be applied are explained. FIG. 1 is a schematic diagram showing an example of an application object to which the order quantity optimization system and method of the present invention are applied. In FIG. 1 , three factories, Factory 1, Factory 2, and Factory 3, and two suppliers, Supplier 1 and Supplier 2, are shown. However, the number of factories and suppliers is not limited to this. .

本发明的订单量优化系统以及方法例如可以应用在工厂1、工厂2、工厂3中,各工厂在进行生产活动时需要向各供应商采购商品。此外,例如,在供应商1需要向供应商2采购商品的情况下,也可以在供应商1中应用本发明的订单量优化系统以及方法。也就是说,本发明的订单量优化系统以及方法能够应用在需要采购商品的所有对象中。The order quantity optimization system and method of the present invention can be applied to, for example, factory 1, factory 2, and factory 3. Each factory needs to purchase goods from each supplier when carrying out production activities. In addition, for example, when supplier 1 needs to purchase goods from supplier 2, the order quantity optimization system and method of the present invention can also be applied to supplier 1. That is to say, the order quantity optimization system and method of the present invention can be applied to all objects that need to purchase goods.

在本发明中,“商品”表示采购的对象,可以是进行生产制造所使用的物料,也可以是生产设备等,“订单量”表示订单中的商品的采购数量。In the present invention, "commodity" represents the object of purchase, which may be materials used for manufacturing, or production equipment, etc., and "order quantity" represents the purchase quantity of the commodity in the order.

通过应用本发明的订单量优化系统以及方法,能够不依赖于熟练者的经验而自动地执行订单业务,并且能够迅速且准确地实现订单业务。由此,能够提高库存管理的效率以及精度。由于能够恰当地管理库存,不会出现库存积压或者缺货的情况,因此能够防止库存积压导致的资金周转困难以及缺货导致的停产等风险。By applying the order volume optimization system and method of the present invention, the order business can be automatically executed without relying on the experience of a skilled person, and the order business can be realized quickly and accurately. This can improve the efficiency and accuracy of inventory management. Since inventory can be properly managed, there will be no overstocking or shortage of stock. Therefore, risks such as difficulties in capital turnover caused by inventory backlog and production shutdown caused by shortage can be prevented.

(第一实施方式)(first embodiment)

图2是表示本发明的第一实施方式的订单量优化系统100的功能结构的框图。如图2所示,订单量优化系统100具备数据收集单元110、需求预测单元120、预测算法选择单元130以及存储器140,彼此之间通过总线150互相连接。FIG. 2 is a block diagram showing the functional structure of the order quantity optimization system 100 according to the first embodiment of the present invention. As shown in FIG. 2 , the order quantity optimization system 100 includes a data collection unit 110 , a demand prediction unit 120 , a prediction algorithm selection unit 130 and a memory 140 , which are connected to each other through a bus 150 .

<数据收集单元><data collection unit>

数据收集单元110收集与商品有关的业务数据的历史数据。如图2所示,数据收集单元110可以从存储器140收集历史数据,但并不限定于此,在历史数据保存于订单量优化系统100外部的存储器的情况下,从该外部的存储器获取历史数据即可。The data collection unit 110 collects historical data of business data related to merchandise. As shown in FIG. 2 , the data collection unit 110 can collect historical data from the memory 140 , but is not limited thereto. When the historical data is stored in a memory external to the order volume optimization system 100 , the historical data is obtained from the external memory. That’s it.

与商品有关的业务数据的历史数据例如包括出入库记录的历史数据、库存记录的历史数据、订单记录的历史数据等。Historical data of business data related to commodities includes, for example, historical data of incoming and outgoing records, historical data of inventory records, historical data of order records, etc.

表1中示出了出入库记录的历史数据的一个例子。在表1所示的例子中,出入库记录的历史数据包括出入库的日期、仓库ID、商品编号、表示是入库还是出库的分类、对应商品的数量和金额、订单编号、在订单中包括多个商品时标注的行号,当然也可以根据需要包括其他数据。通常,在需要使用某些商品时会生成相应的出库单,包括这些商品的商品编号、数量和金额等信息,管理系统根据该出库单中的信息进行出库记录。另外,在从供应商采购的商品到货时也存在相应的发货单,包括这些商品的商品编号、数量等信息,管理系统根据该发货单中的信息进行入库记录。Table 1 shows an example of historical data of inbound and outbound records. In the example shown in Table 1, the historical data of the inbound and outbound record includes the date of inbound and outbound warehouse, warehouse ID, product number, classification indicating whether it is inbound or outbound, the quantity and amount of the corresponding product, order number, and the order number. The line number marked when multiple products are included. Of course, other data can also be included as needed. Usually, when certain commodities need to be used, corresponding outbound orders will be generated, including information such as product numbers, quantities, and amounts of these commodities. The management system records outbound shipments based on the information in the outbound orders. In addition, when the goods purchased from suppliers arrive, there is also a corresponding invoice, including the product number, quantity and other information of these goods. The management system performs warehousing records based on the information in the invoice.

[表1][Table 1]

日期date 仓库IDWarehouse ID 商品编号Product Number 分类Classification 数量quantity 金额Amount 订单编号order number 行号Line number 2018/1/12018/1/1 LOC01LOC01 PT001PT001 入库Warehouse 3636 3636 PO-001PO-001 11 2018/1/12018/1/1 LOC01LOC01 PT001PT001 出库out of warehouse 22twenty two 22twenty two 2018/1/32018/1/3 LOC01LOC01 PT001PT001 入库Warehouse 3333 3333 PO-002PO-002 11

表2中示出了库存记录的历史数据的一个例子。在表2所示的例子中,库存记录的历史数据包括日期、仓库ID、商品编号、商品的数量和金额,当然也可以根据需要包括其他数据。通常,按照给定周期对库存的商品进行盘点,例如每天、每周或每个月进行一次盘点,生成包括进行盘点的日期、盘点的仓库ID、各仓库中保存的每种商品的编号、数量等的盘点结果,管理系统根据该盘点结果中的信息进行库存记录。另外,管理系统也可以根据按照给定周期对出入库流水进行结算的结果来进行库存记录。An example of historical data for inventory records is shown in Table 2. In the example shown in Table 2, the historical data of the inventory record includes date, warehouse ID, item number, quantity and amount of the item. Of course, other data can be included as needed. Usually, inventory of goods is carried out according to a given cycle, such as once a day, every week or every month, and the generated information includes the date of the count, the warehouse ID of the stocktake, the number and quantity of each commodity stored in each warehouse. Wait for the inventory results, and the management system will perform inventory records based on the information in the inventory results. In addition, the management system can also record inventory based on the results of settling the incoming and outgoing flows according to a given period.

[表2][Table 2]

日期date 仓库IDWarehouse ID 商品编号Product Number 数量quantity 金额Amount 2018/1/12018/1/1 LOC01LOC01 PT001PT001 4040 4040 2018/1/12018/1/1 LOC01LOC01 PT001PT001 3535 3535 2018/1/32018/1/3 LOC01LOC01 PT001PT001 5656 5656

表3中示出了订单记录的历史数据的一个例子。在表3所示的例子中,订单记录的历史数据包括仓库ID、订单编号、在订单中包括多个商品时标注的行号、供应商编号、商品编号、订单数量和金额、订单生成日、订单确认日、预定到货日、实际到货日、最近到货日、收货数量和金额,当然也可以根据需要包括其他数据。根据订单记录的历史数据,能够了解到过去的订单数量、哪些订单已经完结、哪些订单还有未到货的部分等信息。An example of historical data for order records is shown in Table 3. In the example shown in Table 3, the historical data of the order record includes warehouse ID, order number, line number marked when the order includes multiple items, supplier number, item number, order quantity and amount, order generation date, Order confirmation date, scheduled arrival date, actual arrival date, latest arrival date, receipt quantity and amount, and of course other data can be included as needed. Based on the historical data of order records, you can learn information such as the number of past orders, which orders have been completed, and which orders have not yet arrived.

[表3][table 3]

<需求预测单元><Demand Forecasting Unit>

需求预测单元120基于通过数据收集单元110收集到的与商品有关的业务数据的历史数据,对每种商品利用多个预测算法来预测未来需求量。The demand prediction unit 120 uses a plurality of prediction algorithms for each commodity to predict future demand based on historical data of business data related to the commodity collected by the data collection unit 110 .

预测算法采用公知的适当算法即可,在本实施方式中,采用四种时间序列分析算法,包括加权移动平均(Weighted Moving Average,以下也称为WMA)、指数平滑法(exponential smoothing,以下也称为EMA)、霍尔特-温特法(Holt-Winters method,以下也称为HoltWinters)、ARIMA法(Autoregressive integrated moving Average,以下也称为ARIMA)。The prediction algorithm can be a well-known appropriate algorithm. In this embodiment, four time series analysis algorithms are used, including weighted moving average (hereinafter also referred to as WMA) and exponential smoothing (hereinafter also referred to as WMA). (EMA), Holt-Winters method (Holt-Winters method, also referred to as HoltWinters below), ARIMA method (Autoregressive integrated moving Average, also referred to as ARIMA below).

在加权移动平均算法中,对各个时间序列数据赋予不同的权重来计算平均值。在指数平滑法中,对于观测值之中越新的数据设定越大的权重,对于越早的数据以指数函数的方式使权重越减少,并计算移动平均。在霍尔特-温特法中,在指数平滑化法中的时间序列的变动中追加趋势和季节波动,计算各个指数平滑结果的叠加作为期待值。利用了ARIMA法的模型组合了自回归模型(AR模型)、移动平均模型(MA模型)、整合模型(I模型)这三个模型,也被称为整合移动平均自回归模型,在时间序列数据存在周期性变化或趋势变化时,能够进行考虑了周期性变化或趋势变化的影响的预测。In the weighted moving average algorithm, different weights are given to each time series data to calculate the average. In the exponential smoothing method, the newer data among the observation values are given a larger weight, and the earlier data are reduced by an exponential function in a weighted manner, and a moving average is calculated. In the Holt-Winter method, trends and seasonal fluctuations are added to the time series changes in the exponential smoothing method, and the superposition of the respective exponential smoothing results is calculated as the expected value. The model using the ARIMA method combines three models: autoregressive model (AR model), moving average model (MA model), and integrated model (I model). It is also called an integrated moving average autoregressive model. In time series data When there is a cyclical change or trend change, predictions that take into account the impact of the cyclical change or trend change can be made.

需求预测单元120至少需要对商品的采购周期内的需求量进行预测。采购周期是指从订单下达至商品入库为止的期间,可以通过订单期间加上供应商的纳期来计算。例如,在订单期间为1个月、纳期为3个月的情况下,采购周期为4个月,需求预测单元120需要对未来4个月的需求量进行预测。The demand forecasting unit 120 at least needs to predict the demand within the purchase cycle of the product. The procurement cycle refers to the period from the placement of the order to the arrival of the goods, and can be calculated by adding the order period plus the supplier's delivery period. For example, when the order period is one month and the delivery period is three months, the procurement cycle is four months, and the demand forecasting unit 120 needs to predict the demand for the next four months.

<预测算法选择单元><Prediction algorithm selection unit>

预测算法选择单元130用于从需求预测单元120所采用的多个预测算法中,自动为每种商品选择出最优预测算法,并输出利用该最优预测算法进行预测的结果。The prediction algorithm selection unit 130 is configured to automatically select an optimal prediction algorithm for each commodity from a plurality of prediction algorithms used by the demand prediction unit 120, and output prediction results using the optimal prediction algorithm.

为此,预测算法选择单元130对于每种商品,利用过去给定期间内多个预测算法的需求预测历史值以及该给定期间内的需求实际值,计算每个预测算法的预测精度,并选择其中预测精度最高的预测算法作为该商品的最优预测算法,然后从需求预测单元120获取该最优预测算法关于该商品的未来需求量的预测结果,将该预测结果作为后续确定该商品的订单量的过程中使用的需求预测值。To this end, the forecast algorithm selection unit 130 calculates the forecast accuracy of each forecast algorithm for each commodity by using the demand forecast history values of multiple forecast algorithms in the past given period and the actual demand value in the given period, and selects Among them, the prediction algorithm with the highest prediction accuracy is used as the optimal prediction algorithm for the commodity, and then the prediction result of the optimal prediction algorithm regarding the future demand for the commodity is obtained from the demand prediction unit 120, and the prediction result is used as the subsequent order for determining the commodity. Demand forecast values used in the quantity process.

在计算预测算法的预测精度时,可以利用多个公知的预测精度评价指标(以下也称为精度指标)。在本实施方式中,利用了MAE(平均绝对误差)、RMSE(均方根误差)、MAPE(平均绝对百分比误差)这三个精度指标,计算方法分别如式(1)~(3)所示,When calculating the prediction accuracy of a prediction algorithm, multiple well-known prediction accuracy evaluation indexes (hereinafter also referred to as accuracy indexes) can be used. In this implementation, three accuracy indicators, MAE (Mean Absolute Error), RMSE (Root Mean Square Error), and MAPE (Mean Absolute Percent Error), are used. The calculation methods are as shown in Equations (1) to (3) respectively. ,

在式(1)~(3)中,表示过去给定期间内第i个单位期间的需求预测历史值,yi表示过去给定期间内第i个单位期间的需求实际值,n表示过去给定期间内的单位期间数,每个单位期间内有1个需求预测历史值和1个需求实际值。在此,设过去的给定期间为当前时间点之前的1个采购周期,例如,采购周期为4个月,单位期间为1个月,在该情况下,n为4。In formulas (1) to (3), represents the historical demand forecast value of the i-th unit period in the past given period, y i represents the actual demand value of the i-th unit period in the past given period, n represents the number of unit periods in the past given period, each unit There is 1 demand forecast historical value and 1 demand actual value during the period. Here, let the past given period be one procurement cycle before the current time point. For example, the procurement cycle is four months and the unit period is one month. In this case, n is 4.

在MAE、RMSE、MAPE这三个精度指标中,MAE、RMSE能够反映出预测值的误差大小,MAE、RMSE的数值越小,表示预测值的误差越小。MAPE能够反映出模型的误差大小,通过用100%减去MAPE的数值能够得到模型的精度,因此,MAPE的数值越小,表示模型的误差越小,精度越高。Among the three accuracy indicators of MAE, RMSE, and MAPE, MAE and RMSE can reflect the error of the predicted value. The smaller the values of MAE and RMSE, the smaller the error of the predicted value. MAPE can reflect the error size of the model. The accuracy of the model can be obtained by subtracting the value of MAPE from 100%. Therefore, the smaller the value of MAPE, the smaller the error and the higher the accuracy of the model.

下面,例如以商品编号为“PT001”的商品作为对象商品,说明预测算法选择单元130为该对象商品选择最优预测算法的过程的例子。The following describes an example of a process in which the prediction algorithm selection unit 130 selects an optimal prediction algorithm for the target product, taking the product with the product number "PT001" as the target product.

设当前时间点为2021年8月1日,采购周期为4个月,单位期间为1个月,当前时间点之前的1个采购周期为2021年4月至7月,在当前时间点能够得到如表4所示的该采购周期内的对象商品的需求实际值,表示该对象商品在此期间的实际消耗量。Assume that the current time point is August 1, 2021, the procurement cycle is 4 months, the unit period is 1 month, and the 1 procurement cycle before the current time point is from April to July 2021. At the current time point, it can be obtained The actual demand value of the target commodity during the procurement cycle as shown in Table 4 represents the actual consumption of the target commodity during this period.

[表4][Table 4]

仓库IDWarehouse ID 商品编号Product Number 4月April 5月May 6月June 7月July LOC01LOC01 PT001PT001 253253 235235 256256 251251

设需求预测单元120在2021年4月1日分别利用四种预测算法WMA、EMA、HoltWinters、ARIMA预测了对象商品的2021年4月至7月的需求量,得到如表5所示的预测结果。Assume that the demand forecasting unit 120 uses four forecasting algorithms WMA, EMA, HoltWinters, and ARIMA to predict the demand for the target commodity from April to July 2021 on April 1, 2021, and obtains the forecast results shown in Table 5. .

[表5][table 5]

执行日期execution date 预测算法Prediction algorithm 仓库IDWarehouse ID 商品编号Product Number 4月April 5月May 6月June 7月July 2021040120210401 WMAWMA LOC01LOC01 PT001PT001 217217 206206 228228 260260 2021040120210401 EMAEMA LOC01LOC01 PT001PT001 198198 190190 182182 235235 2021040120210401 HoltWintersHoltWinters LOC01LOC01 PT001PT001 237237 278278 269269 230230 2021040120210401 ARIMAARIMA LOC01LOC01 PT001PT001 243243 278278 284284 262262

如表5所示,对于每种预测算法,都得到了过去给定期间(4月至7月)内的需求预测历史值,从而可以利用该需求预测历史值以及表4所示的该期间内的需求实际值来评价每种预测算法的预测精度,选择出最优预测算法,具体过程包括如下步骤(a)、(b)、(c)。As shown in Table 5, for each forecasting algorithm, the historical value of demand forecast in the past given period (April to July) is obtained, so that the historical value of demand forecast can be used as well as the demand forecast value in this period as shown in Table 4. Use the actual value of demand to evaluate the prediction accuracy of each prediction algorithm and select the optimal prediction algorithm. The specific process includes the following steps (a), (b), and (c).

(a)计算各预测算法的精度指标(a) Calculate the accuracy index of each prediction algorithm

按照上述式(1)~(3)所示的计算方法,利用表4中的需求实际值(yi)以及表5中的需求预测历史值对每种预测算法计算出MAE、RMSE、MAPE这三个精度指标,将计算结果列于表6。According to the calculation method shown in the above formulas (1) to (3), the actual demand value ( yi ) in Table 4 and the demand forecast historical value in Table 5 are used The three accuracy indicators of MAE, RMSE, and MAPE are calculated for each prediction algorithm, and the calculation results are listed in Table 6.

[表6][Table 6]

执行日期execution date 预测算法Prediction algorithm 仓库IDWarehouse ID 商品编号Product Number MAEMAE RMSERMSE MAPEMAPE 2021040120210401 WMAWMA LOC01LOC01 PT001PT001 25.5025.50 27.4027.40 0.100.10 2021040120210401 EMAEMA LOC01LOC01 PT001PT001 47.5047.50 51.9251.92 0.190.19 2021040120210401 HoltWintersHoltWinters LOC01LOC01 PT001PT001 23.2523.25 26.0526.05 0.100.10 2021040120210401 ARIMAARIMA LOC01LOC01 PT001PT001 23.0023.00 26.7126.71 0.090.09

表6中示出的是针对2021年4月1日的预测结果计算出的精度指标。同样,可以将过去的给定期间设为2021年2月至5月、3月至6月等,分别得到不同时间的预测结果的精度指标。Shown in Table 6 are the accuracy indicators calculated for the forecast results on April 1, 2021. Similarly, the given period in the past can be set as February to May, March to June, etc. in 2021, and the accuracy indicators of the prediction results at different times can be obtained.

(b)计算精度指标的加权移动平均(b) Calculate the weighted moving average of the accuracy indicator

在仅利用一次的精度指标的计算结果对预测算法进行评价的情况下,由于存在偶然性因素,可能无法准确地进行评价。因此,为了提高评价的准确度,优选利用多次的精度指标的计算结果来进行评价,例如可以利用过去3个月、4个月或半年的精度指标的计算结果。When a prediction algorithm is evaluated using only one calculation result of the accuracy index, it may not be possible to accurately evaluate it due to the presence of chance factors. Therefore, in order to improve the accuracy of the evaluation, it is preferable to use the calculation results of the accuracy index multiple times for evaluation. For example, the calculation results of the accuracy index in the past three months, four months, or half a year can be used.

在该例子中,对于预测算法WMA,利用了表7所示的最近3个月的精度指标的计算结果,即,利用了针对2021年2月1日、2021年3月1日、2021年4月1日的预测结果计算出的精度指标。In this example, for the prediction algorithm WMA, the calculation results of the accuracy indicators for the last three months shown in Table 7 are used, that is, the calculation results for February 1, 2021, March 1, 2021, and April 2021 are used. The accuracy index calculated from the forecast results on the 1st of the month.

[表7][Table 7]

执行日期execution date 预测算法Prediction algorithm 仓库IDWarehouse ID 商品编号Product Number MAEMAE RMSERMSE MAPEMAPE 2021020120210201 WMAWMA LOC01LOC01 PT001PT001 15.8015.80 18.9818.98 0.080.08 2021030120210301 WMAWMA LOC01LOC01 PT001PT001 22.7822.78 23.5223.52 0.120.12 2021040120210401 WMAWMA LOC01LOC01 PT001PT001 25.5025.50 27.4027.40 0.100.10

并且,如式(4)所示,对于每个精度指标,将三次的计算结果进行加权移动平均,得到了各精度指标的加权移动平均值AVG_MAE、AVG_RMSE、AVG_MAPE。Moreover, as shown in equation (4), for each accuracy index, the three calculation results are weighted moving average, and the weighted moving average AVG_MAE, AVG_RMSE, and AVG_MAPE of each accuracy index are obtained.

在对多次的精度指标的计算结果计算加权移动平均值时,优选按照距离当前时间点越近的计算结果的权重越大的方式设定权重,由此能够进一步提高评价的准确度。例如,在式(4)中,对于2021年4月1日、2021年3月1日、2021年2月1日的精度指标的计算结果,分别赋予了3、2、1的权重。When calculating a weighted moving average of calculation results of multiple accuracy indexes, it is preferable to set the weight so that calculation results closer to the current time point have greater weight, thereby further improving the accuracy of the evaluation. For example, in equation (4), the calculation results of the accuracy index on April 1, 2021, March 1, 2021, and February 1, 2021 are given weights of 3, 2, and 1 respectively.

对于其他三种预测算法EMA、HoltWinters、ARIMA,同样地进行计算,分别得到每种预测算法的各精度指标的加权移动平均值AVG_MAE、AVG_RMSE、AVG_MAPE。For the other three prediction algorithms EMA, HoltWinters, and ARIMA, the same calculation is performed to obtain the weighted moving averages AVG_MAE, AVG_RMSE, and AVG_MAPE of each accuracy indicator of each prediction algorithm.

(c)选择最优预测算法(c) Select the optimal prediction algorithm

在当前时间点,将通过步骤(b)得到的每种预测算法的各精度指标的加权移动平均值按照从小到大的顺序排序。各精度指标的加权移动平均值越小,表示对应的预测算法的预测精度越高,因此,能够根据加权移动平均值来选出四种预测算法之中预测精度最高的预测算法,作为对象商品的最优预测算法。At the current point in time, sort the weighted moving averages of the accuracy indicators of each prediction algorithm obtained through step (b) in order from small to large. The smaller the weighted moving average of each accuracy indicator, the higher the prediction accuracy of the corresponding prediction algorithm. Therefore, the prediction algorithm with the highest prediction accuracy among the four prediction algorithms can be selected based on the weighted moving average as the target product. Optimal prediction algorithm.

在排序时,对AVG_MAE、AVG_RMSE、AVG_MAPE赋予优先级,使反映出预测值的误差大小的MAE、RMSE的加权移动平均值AVG_MAE、AVG_RMSE的优先级较高,使反映预测模型的精度的MAPE的加权移动平均值AVG_MAPE的优先级较低,例如设为按照AVG_MAE、AVG_RMSE、AVG_MAPE的顺序优先级依次降低。因此,在进行排序时,首先按照AVG_MAE从小到大的顺序排序,对于AVG_MAE的值相同的预测算法,按照AVG_RMSE从小到大的顺序排序,对于AVG_MAE、AVG_RMSE的值均相同的预测算法,按照AVG_MAPE从小到大的顺序排序。在该例子中,得到如表8所示的排序结果。When sorting, give priority to AVG_MAE, AVG_RMSE, and AVG_MAPE, so that the weighted moving averages AVG_MAE and AVG_RMSE, which reflect the error size of the prediction value, have higher priority, and make the weighting of MAPE, which reflects the accuracy of the prediction model, higher. The priority of the moving average AVG_MAPE is lower. For example, the priority is set to decrease in the order of AVG_MAE, AVG_RMSE, and AVG_MAPE. Therefore, when sorting, first sort according to the order of AVG_MAE from small to large. For prediction algorithms with the same AVG_MAE value, sort according to the order from small to large AVG_RMSE. For prediction algorithms with the same values of AVG_MAE and AVG_RMSE, sort according to the order of AVG_MAPE from small to large. Sort in order of largest. In this example, the sorting results shown in Table 8 are obtained.

[表8][Table 8]

执行日期execution date 预测算法Prediction algorithm AVG_MAEAVG_MAE AVG_RMSEAVG_RMSE AVG_MAPEAVG_MAPE 2021080120210801 WMAWMA 22.9822.98 24.7024.70 0.100.10 2021080120210801 EMAEMA 24.7324.73 25.8225.82 0.080.08 2021080120210801 HoltWintersHoltWinters 25.6225.62 27.3227.32 0.100.10 2021080120210801 ARIMAARIMA 32.4632.46 29.6729.67 0.130.13

如表8所示,四种预测算法中的WMA的AVG_MAE最小,表示对于对象商品而言,预测算法WMA的预测精度最高,因此选择预测算法WMA作为该对象商品的最优预测算法,输出该最优预测算法的预测结果。As shown in Table 8, among the four prediction algorithms, WMA has the smallest AVG_MAE, which means that for the target commodity, the prediction algorithm WMA has the highest prediction accuracy. Therefore, the prediction algorithm WMA is selected as the optimal prediction algorithm for the target commodity, and the optimal prediction algorithm is output. The prediction results of the optimal prediction algorithm.

通过上述步骤(a)、(b)、(c),对于商品编号为“PT001”的对象商品,选择出了最优预测算法。对于其他商品,执行同样的步骤来选择各自对应的最优预测算法即可。Through the above steps (a), (b), and (c), the optimal prediction algorithm is selected for the target product with the product number "PT001". For other products, just perform the same steps to select the corresponding optimal prediction algorithm.

<订单量优化方法><Order volume optimization method>

以下,利用图3说明本实施方式的订单量优化系统100所执行的订单量优化方法。图3是表示本实施方式的订单量优化方法的流程图。Hereinafter, the order quantity optimization method executed by the order quantity optimization system 100 of this embodiment will be described using FIG. 3 . FIG. 3 is a flowchart showing the order quantity optimization method according to this embodiment.

如图3所示,本实施方式的订单量优化方法包括数据收集步骤S110、需求预测步骤S120和预测算法选择步骤S130。As shown in Figure 3, the order quantity optimization method of this embodiment includes a data collection step S110, a demand prediction step S120, and a prediction algorithm selection step S130.

在步骤S110中,收集与商品有关的业务数据的历史数据。In step S110, historical data of business data related to the product is collected.

在步骤S120中,基于通过步骤S110收集到的与商品有关的业务数据的历史数据,对每种商品利用多个预测算法来预测未来需求量。In step S120, multiple prediction algorithms are used for each commodity to predict future demand based on the historical data of the business data related to the commodity collected in step S110.

在步骤S130中,对于每种商品,利用过去给定期间内所述多个预测算法的需求预测历史值以及该给定期间内的需求实际值,计算步骤S120中利用的每个预测算法的预测精度,并选择其中预测精度最高的预测算法作为该商品的最优预测算法,然后将步骤S110中的预测精度最高的预测算法的预测结果作为后续确定该商品的订单量的过程中使用的需求预测值。In step S130, for each commodity, the prediction of each prediction algorithm utilized in step S120 is calculated using the demand prediction history values of the multiple prediction algorithms in the past given period and the actual demand value in the given period. accuracy, and select the prediction algorithm with the highest prediction accuracy as the optimal prediction algorithm for the product, and then use the prediction result of the prediction algorithm with the highest prediction accuracy in step S110 as the demand forecast used in the subsequent process of determining the order quantity of the product. value.

根据本实施方式的订单量优化系统以及订单量优化方法,由于通过预测算法选择单元或步骤自动为每种商品选择出最优预测算法,将该最优预测算法的预测结果用于订单量的确定,因此能够不依赖于熟练者的经验而自动地执行订单业务,并且能够迅速且准确地实现订单业务。由此,能够提高库存管理的效率以及精度。由于能够恰当地管理库存,不会出现库存积压或者缺货的情况,因此能够防止库存积压导致的资金周转困难以及缺货导致的停产等风险。According to the order quantity optimization system and order quantity optimization method of this embodiment, the optimal prediction algorithm is automatically selected for each commodity through the prediction algorithm selection unit or step, and the prediction result of the optimal prediction algorithm is used to determine the order quantity. , so the order business can be automatically executed without relying on the experience of a skilled person, and the order business can be realized quickly and accurately. This can improve the efficiency and accuracy of inventory management. Because inventory can be properly managed, there will be no overstocking or out-of-stock situations, so it can prevent risks such as difficulties in capital turnover caused by overstocking and production shutdowns caused by out-of-stocks.

(第二实施方式)(Second Embodiment)

图4是表示本发明的第二实施方式的订单量优化系统100A的功能结构的框图。本实施方式的订单量优化系统100A相对于第一实施方式的订单量优化系统100的不同点在于,如图4所示,订单量优化系统100A还具备库存标准设定单元160,下面以该不同点为中心进行说明。FIG. 4 is a block diagram showing the functional structure of the order quantity optimization system 100A according to the second embodiment of the present invention. The difference between the order quantity optimization system 100A of this embodiment and the order quantity optimization system 100 of the first embodiment is that, as shown in FIG. 4 , the order quantity optimization system 100A also has an inventory standard setting unit 160. This difference will be used below. The point is centered.

为了恰当地管理库存,需要设定安全库存等库存标准。在专利文献1中,根据商品的实际消耗量设定了固定的库存标准。然而,在实际业务中,需要根据不同时期、需求情况等对库存标准进行实时调整,若如专利文献1那样采用固定的库存标准,则很可能出现库存积压或者缺货的情况。In order to properly manage inventory, inventory standards such as safety stock need to be set. In Patent Document 1, fixed inventory standards are set based on actual consumption of products. However, in actual business, inventory standards need to be adjusted in real time according to different periods, demand conditions, etc. If fixed inventory standards are used as in Patent Document 1, inventory overstock or shortages are likely to occur.

在本实施方式中,通过库存标准设定单元160动态地设定库存标准。下面,对库存标准设定单元160进行详细说明。In this embodiment, the inventory standard is dynamically set by the inventory standard setting unit 160 . Next, the inventory standard setting unit 160 will be described in detail.

<库存标准设定单元><Inventory standard setting unit>

库存标准设定单元160用于对每种商品动态地设定相应的库存标准。The inventory standard setting unit 160 is used to dynamically set corresponding inventory standards for each commodity.

库存标准的计算式如下面的式(5)~(7)所示。The calculation formula of the inventory standard is shown in the following formulas (5) to (7).

库存量=订单期间内的使用量+安全库存(5)Inventory quantity = usage quantity during the order period + safety stock (5)

其中,订单期间内的使用量为利用最优预测算法得到的该订单期间内的需求预测值,n为样本数据的个数,可以根据实际情况适当选择,Xi为样本数据,μ为样本数据的平均值,安全系数可根据缺货概率从表9中查出。缺货概率表示商品发生缺货的概率,为了降低缺货概率,需要提高安全系数来增大安全库存,因此,缺货概率越低,对应的安全系数越大。Among them, the usage within the order period is the demand forecast value within the order period obtained by using the optimal forecasting algorithm, n is the number of sample data, which can be appropriately selected according to the actual situation, Xi is the sample data, and μ is the sample data The average value of , the safety factor can be found from Table 9 according to the out-of-stock probability. The out-of-stock probability indicates the probability of a product being out-of-stock. In order to reduce the out-of-stock probability, the safety factor needs to be increased to increase the safety inventory. Therefore, the lower the out-of-stock probability, the greater the corresponding safety factor.

[表9][Table 9]

缺货概率Out of stock probability 30%30% 20%20% 15%15% 10%10% 5%5% 安全系数Safety factor 0.530.53 0.850.85 1.041.04 1.291.29 1.651.65

库存标准设定单元160对于每种商品,基于历史数据求出表示商品的重要度的需求特性指标,根据求出的需求特性指标以及从需求预测单元120获取的最优预测算法的需求预测值,设定多个级别的库存标准,在本实施方式中,设定最低库存量、推荐库存量和最高库存量。The inventory standard setting unit 160 calculates, for each product, a demand characteristic index indicating the importance of the product based on historical data, and based on the calculated demand characteristic index and the demand prediction value of the optimal prediction algorithm obtained from the demand forecasting unit 120, Set multiple levels of inventory standards. In this implementation, the minimum inventory, recommended inventory, and maximum inventory are set.

下面,例如以商品编号为“PT001”的商品作为对象商品,说明库存标准设定单元160对该商品设定库存标准的例子,具体设定过程包括如下步骤(a)、(b)、(c)、(d)。The following describes an example in which the inventory standard setting unit 160 sets the inventory standard for the product with the product number "PT001" as the target product. The specific setting process includes the following steps (a), (b), and (c). ), (d).

(a)求出需求特性指标(a) Find the demand characteristic index

在本实施方式中,需求特性指标包括需求概率和消耗量ABC分类。需求概率表示单位期间内产生对某商品的需求的概率,概率越高表示该商品越经常被使用。消耗量ABC分类是基于ABC分析法对某商品在过去给定期间内的消耗量进行分类,得出表示该商品的使用量的多少的分类结果。能够根据需求概率和消耗量ABC分类来区分商品的重要度,进而根据商品的重要度来分别设定适当的库存标准。In this embodiment, the demand characteristic indicators include demand probability and consumption ABC classification. Demand probability represents the probability of generating demand for a certain commodity within a unit period. The higher the probability, the more often the commodity is used. The consumption ABC classification is based on the ABC analysis method to classify the consumption of a certain commodity in a given period in the past, and obtain a classification result indicating the usage of the commodity. The importance of products can be distinguished based on demand probability and consumption ABC classification, and appropriate inventory standards can be set based on the importance of the products.

下面分别说明求出需求概率和消耗量ABC分类的方法。The methods for obtaining demand probability and consumption ABC classification are explained below.

·需求概率·Demand probability

根据商品的实际消耗情况,以给定时间例如天、周或者月为单位来求出需求概率。例如,如表10所示,对于商品编号为“PT001”的对象商品,以月为单位,设当前时间点为8月,获取到7月为止过去一年的消耗量数据,按每个月计算出该商品的消耗量合计值。接着,如表11所示,对于消耗量合计值大于0的月份,填入表示有消耗的数值“1”,对于消耗量合计值等于0的月份,填入表示没有消耗的数值“0”。然后,用一年之中有消耗的月数除以一年的月数来求出需求概率。在此,一年之中有消耗的月数为6,因此需求概率为6/12=0.5,表示在未来一年内有0.5的概率会产生对该商品的需求,概率越高表示该商品越经常被使用。Based on the actual consumption of the commodity, the demand probability is obtained in units of a given time, such as days, weeks, or months. For example, as shown in Table 10, for the target product with product number "PT001", in monthly units, assuming that the current time point is August, the consumption data for the past year to July is obtained, and calculated on a monthly basis. Get the total consumption value of this product. Next, as shown in Table 11, for months where the total consumption value is greater than 0, fill in the value "1" indicating consumption, and for months where the total consumption value is equal to 0, fill in the value "0" indicating no consumption. Then, divide the number of months in a year with consumption by the number of months in a year to find the demand probability. Here, the number of consumption months in a year is 6, so the demand probability is 6/12 = 0.5, which means there is a 0.5 probability that there will be demand for this product in the next year. The higher the probability, the more frequent the product is. used.

[表10][Table 10]

仓库IDWarehouse ID 商品编号Product Number 8月August 9月September 10月October 11月November 12月December 1月January 2月February 3月March 4月April 5月May 6月June 7月July LOC01LOC01 PT001PT001 1010 235235 00 00 5656 00 1212 00 00 00 168168 251251

[表11][Table 11]

仓库IDWarehouse ID 商品编号Product Number 8用8 use 9月September 10月October 11月November 12月December 1月January 2月February 3月March 4月April 5月May 6月June 7月July LOC01LOC01 PT001PT001 11 11 00 00 11 00 11 00 00 00 11 11

·消耗量ABC分类·ABC classification of consumption

图5是表示本实施方式的基于ABC分析法进行分类的图,横坐标表示商品编号,左边纵坐标表示商品的消耗量,右边纵坐标表示累计百分比。FIG. 5 is a diagram showing classification based on the ABC analysis method in this embodiment. The abscissa represents the product number, the left ordinate represents the consumption of the product, and the right ordinate represents the cumulative percentage.

首先,计算各商品过去一年的消耗量的合计值,按照合计值从大到小的顺序对各商品进行排序,如图5中排列的多个长方形所示。接着,计算各商品的消耗量占整体消耗量的百分比,并计算累计百分比,图5中的曲线表示累计百分比的数值变化。将累计百分比为0%~80%的范围内的商品划分为A类,将累计百分比为80%~90%的范围内的商品划分为B类,将累计百分比为90%~100%的范围内的商品划分为C类。在此,累计百分比范围以及分类的类别数可根据实际情况调整。First, calculate the total value of the consumption of each product in the past year, and sort each product in order from the largest to the smallest total value, as shown in the multiple rectangles arranged in Figure 5. Next, the consumption of each commodity is calculated as a percentage of the overall consumption, and the cumulative percentage is calculated. The curve in Figure 5 represents the numerical change of the cumulative percentage. Products with a cumulative percentage of 0% to 80% are classified as Category A, products with a cumulative percentage of 80% to 90% are classified as Category B, and products with a cumulative percentage of 90% to 100% are classified as Category B. The goods are classified into Category C. Here, the cumulative percentage range and the number of categories can be adjusted according to the actual situation.

在图5中,商品编号为001~006的商品为A类,商品编号为007~009的商品为B类,商品编号为010~015的商品为C类。A类商品的重要度最高,B类商品的重要度为中等,C类商品的重要度最低。In Figure 5, products with product numbers 001 to 006 are category A, products with product numbers 007 to 009 are category B, and products with product numbers 010 to 015 are category C. Category A products have the highest importance, Category B products have medium importance, and Category C products have the lowest importance.

根据需求概率的数值和消耗量ABC分类的分类结果,能够区分商品的重要度。例如,需求概率为0.8以上且分类结果为A类的商品是经常使用且使用量大的商品,将这样的商品设为重要商品,将其他商品设为非重要商品。在此,进行区分时采用的需求概率的阈值以及分类结果的类别并不限定于此,可以根据需要来变更。The importance of the product can be distinguished based on the numerical value of the demand probability and the classification result of the consumption ABC classification. For example, a product with a demand probability of 0.8 or more and a classification result of Class A is a product that is frequently used and used in large quantities. Such products are set as important products, and other products are set as unimportant products. Here, the threshold value of the demand probability used in the classification and the category of the classification result are not limited to these and can be changed as necessary.

(b)计算最低库存量(b) Calculate the minimum inventory quantity

最低库存量表示最低的库存保有量,库存标准设定单元160例如按下式计算最低库存量。The minimum inventory quantity indicates the minimum inventory holding quantity, and the inventory standard setting unit 160 calculates the minimum inventory quantity as follows, for example.

对于需求概率为0.8以上且分类结果为A类的重要商品:For important commodities with a demand probability of 0.8 or above and a classification result of Class A:

最低库存量=MAX(订单期间内的使用量+30%缺货概率对应的安全库存,最近6个月内的单月最大消耗量);Minimum inventory = MAX (usage during the order period + safety stock corresponding to 30% out-of-stock probability, maximum consumption in a single month in the last 6 months);

对于非重要商品:For non-essential items:

最低库存量=MAX(订单期间内的使用量+30%缺货概率对应的安全库存,最近6个月内的平均消耗量)。Minimum inventory = MAX (usage during the order period + safety stock corresponding to 30% out-of-stock probability, average consumption in the last 6 months).

在上式中,准备的库存量为“订单期间内的使用量+30%缺货概率对应的安全库存”,对于重要商品,选择准备的库存量与最近6个月内的单月最大消耗量之中的较大者作为最低库存量,对于非重要商品,选择准备的库存量与最近6个月内的平均消耗量之中的较大者作为最低库存量。由于最近6个月内的单月最大消耗量在平均消耗量以上,因此重要商品的最低库存量在非重要商品的最低库存量以上。In the above formula, the prepared inventory is "usage during the order period + safety stock corresponding to 30% out-of-stock probability". For important products, select the prepared inventory and the maximum monthly consumption in the last 6 months. The larger of them is used as the minimum inventory. For non-important products, the larger of the prepared inventory and the average consumption in the last 6 months is selected as the minimum inventory. Since the maximum monthly consumption in the last 6 months is above the average consumption, the minimum inventory of important commodities is above the minimum inventory of non-important commodities.

缺货概率越大则对应的安全库存越低,因此在计算最低库存量的上式中选择了较大的“30%”的缺货概率,但是并不限定于此,根据需要选择即可。另外,与准备的库存量进行比较的消耗量也可以根据需要进行设定。The greater the out-of-stock probability, the lower the corresponding safety stock. Therefore, a larger "30%" out-of-stock probability is selected in the above formula for calculating the minimum inventory amount, but it is not limited to this and can be selected as needed. In addition, the consumption amount compared with the prepared inventory amount can also be set as needed.

(c)计算推荐库存量(c) Calculate recommended inventory quantity

推荐库存量表示推荐的库存保有量,库存标准设定单元160按下式计算推荐库存量。The recommended inventory amount indicates the recommended inventory holding amount, and the inventory standard setting unit 160 calculates the recommended inventory amount according to the following formula.

对于需求概率为0.8以上且分类结果为A类的重要商品:For important commodities with a demand probability of 0.8 or above and a classification result of Class A:

推荐库存量=MAX(订单期间内的使用量+15%缺货概率对应的安全库存,最低库存量);Recommended inventory = MAX (usage during the order period + safety stock corresponding to 15% out-of-stock probability, minimum inventory);

对于非重要商品:For non-essential items:

推荐库存量=MAX(订单期间内的使用量+20%缺货概率对应的安全库存,最低库存量)。Recommended inventory = MAX (usage during the order period + safety stock corresponding to 20% out-of-stock probability, minimum inventory).

在上式中,对于重要商品,准备的库存量为“订单期间内的使用量+15%缺货概率对应的安全库存”,选择准备的库存量与最低库存量之中的较大者作为推荐库存量。对于非重要商品,准备的库存量为“订单期间内的使用量+20%缺货概率对应的安全库存”,选择准备的库存量与最低库存量之中的较大者作为推荐库存量。根据上式,能够确保推荐库存量在最低库存量以上。In the above formula, for important products, the inventory to be prepared is "the usage amount during the order period + the safety stock corresponding to the 15% out-of-stock probability", and the larger of the inventory to be prepared and the minimum inventory is selected as the recommendation inventory. For non-important products, the prepared inventory amount is "the usage amount during the order period + the safety stock corresponding to the 20% out-of-stock probability", and the larger of the prepared inventory amount and the minimum inventory amount is selected as the recommended inventory amount. According to the above formula, it is possible to ensure that the recommended inventory is above the minimum inventory.

缺货概率越小则对应的安全库存越高,因此重要商品的推荐库存量在非重要商品的推荐库存量以上。另外,在计算推荐库存量的上式中选择了“15%”、“20%”的缺货概率,也可以选择其他数值,但需要低于计算最低库存量时的缺货概率。The smaller the out-of-stock probability, the higher the corresponding safety stock. Therefore, the recommended inventory of important products is higher than the recommended inventory of non-important products. In addition, the out-of-stock probabilities of "15%" and "20%" were selected in the above formula for calculating the recommended inventory amount. You can also choose other values, but they need to be lower than the out-of-stock probability when calculating the minimum inventory amount.

(d)计算最高库存量(d) Calculate the maximum inventory quantity

最高库存量表示最高的库存保有量,库存标准设定单元160按下式计算最高库存量。The maximum inventory amount indicates the highest inventory holding amount, and the inventory standard setting unit 160 calculates the maximum inventory amount according to the following formula.

对于需求概率为0.8以上且分类结果为A类的重要商品:For important commodities with a demand probability of 0.8 or above and a classification result of Class A:

最高库存量=MAX(订单期间内的使用量+10%缺货概率对应的安全库存,推荐库存量);Maximum inventory = MAX (usage during the order period + safety stock corresponding to 10% out-of-stock probability, recommended inventory);

对于非重要商品:For non-essential items:

最高库存量=MAX(订单期间内的使用量+15%缺货概率对应的安全库存,推荐库存量)。Maximum inventory = MAX (usage during the order period + safety stock corresponding to 15% out-of-stock probability, recommended inventory).

在上式中,对于重要商品,准备的库存量为“订单期间内的使用量+10%缺货概率对应的安全库存”,选择准备的库存量与推荐库存量之中的较大者作为最高库存量。对于非重要商品,准备的库存量为“订单期间内的使用量+15%缺货概率对应的安全库存”,选择准备的库存量与推荐库存量之中的较大者作为最高库存量。根据上式,能够确保最高库存量在推荐库存量以上。In the above formula, for important products, the prepared inventory amount is "the usage amount during the order period + the safety stock corresponding to the 10% out-of-stock probability", and the larger of the prepared inventory amount and the recommended inventory amount is selected as the highest inventory. For non-important products, the prepared inventory amount is "the usage amount during the order period + the safety stock corresponding to the 15% out-of-stock probability", and the larger of the prepared inventory amount and the recommended inventory amount is selected as the maximum inventory amount. According to the above formula, it can be ensured that the maximum inventory level is above the recommended inventory level.

缺货概率越小则对应的安全库存越高,因此重要商品的最高库存量在非重要商品的最高库存量以上。另外,在计算最高库存量的上式中选择了“10%”、“15%”的缺货概率,也可以选择其他数值,但需要低于计算推荐库存量时的缺货概率。The smaller the out-of-stock probability is, the higher the corresponding safety stock is. Therefore, the maximum inventory of important commodities is higher than the maximum inventory of non-important commodities. In addition, the out-of-stock probabilities of "10%" and "15%" were selected in the above formula for calculating the maximum inventory amount. You can also choose other values, but they need to be lower than the out-of-stock probability when calculating the recommended inventory amount.

通过上述步骤(a)、(b)、(c)、(d),对于商品编号为“PT001”的对象商品,设定了最低库存量、推荐库存量和最高库存量这三个库存标准。并且,根据对象商品每个月最新的需求预测值,对库存标准进行更新,从而能够动态地调整库存标准。对于其他商品,执行同样的步骤来设定和调整库存标准即可。Through the above steps (a), (b), (c), and (d), three inventory standards are set for the target product with the product number "PT001": the minimum inventory quantity, the recommended inventory quantity, and the maximum inventory quantity. In addition, the inventory standard is updated based on the latest demand forecast value of the target product each month, so that the inventory standard can be dynamically adjusted. For other items, follow the same steps to set and adjust inventory standards.

根据本实施方式的订单量优化系统,由于通过库存标准设定单元自动为每种商品设定了动态的库存标准,将该库存标准用于订单量的确定,因此能够不依赖于熟练者的经验而自动地执行订单业务,并且能够迅速且准确地实现订单业务。由此,能够提高库存管理的效率以及精度。由于能够恰当地管理库存,不会出现库存积压或者缺货的情况,因此能够防止库存积压导致的资金周转困难以及缺货导致的停产等风险。According to the order quantity optimization system of this embodiment, the inventory standard setting unit automatically sets a dynamic inventory standard for each product and uses the inventory standard to determine the order quantity. Therefore, it is possible to do without relying on the experience of a skilled person. The order business can be automatically executed and the order business can be realized quickly and accurately. This can improve the efficiency and accuracy of inventory management. Since inventory can be properly managed, there will be no overstocking or shortage of stock. Therefore, risks such as difficulties in capital turnover caused by inventory backlog and production shutdown caused by shortage can be prevented.

(第三实施方式)(Third Embodiment)

图6是表示本发明的第三实施方式的订单量优化系统100B的功能结构的框图。本实施方式的订单量优化系统100B相对于第二实施方式的订单量优化系统100A的不同点在于,如图6所示,订单量优化系统100B还具备库存量模拟单元170和补货计划生成单元180,下面以该不同点为中心进行说明。FIG. 6 is a block diagram showing the functional structure of the order quantity optimization system 100B according to the third embodiment of the present invention. The difference between the order quantity optimization system 100B of this embodiment and the order quantity optimization system 100A of the second embodiment is that, as shown in FIG. 6 , the order quantity optimization system 100B further includes an inventory simulation unit 170 and a replenishment plan generation unit. 180, the following explanation will focus on this difference.

<库存量模拟单元><Inventory simulation unit>

库存量模拟单元170用于对每种商品的未来给定期间内的库存量变化进行模拟。The inventory simulation unit 170 is used to simulate changes in the inventory of each commodity in a given period in the future.

为此,库存量模拟单元170对于每种商品,根据当前库存量、订单剩余量以及从需求预测单元120获取的最优预测算法的需求预测值,对该商品未来给定期间内的库存量变化进行模拟。To this end, the inventory simulation unit 170, for each commodity, calculates the inventory change of the commodity within a given period in the future based on the current inventory, the remaining order quantity, and the demand prediction value of the optimal prediction algorithm obtained from the demand prediction unit 120. Perform simulation.

例如,以商品编号为“PT001”的商品作为对象商品,说明库存量模拟单元170对该商品的库存量变化进行模拟的例子。For example, an example in which the inventory quantity simulation unit 170 simulates changes in the inventory quantity of the product with the product number "PT001" as the target product will be described.

设当前时间点为2021年8月,采购周期为4个月,当前库存量和订单剩余量分别如表12所示,在该表中,当前库存量为300,未来4个月即8月、9月、10月、11月的订单剩余量分别为20、10、0、0,表示8月内的入库量为20,9月内的入库量为10,10月和11月没有入库。Assume that the current time point is August 2021, and the procurement cycle is 4 months. The current inventory and remaining orders are shown in Table 12 respectively. In this table, the current inventory is 300, and the next 4 months are August, The remaining orders in September, October, and November are 20, 10, 0, and 0 respectively, which means that the warehousing quantity in August is 20, the warehousing quantity in September is 10, and there is no warehousing quantity in October and November. Library.

[表12][Table 12]

从需求预测单元120获取的最优预测算法的未来4个月的消耗量的需求预测值如表13所示,在该表中,未来4个月即8月、9月、10月、11月的消耗量的需求预测值分别为165、132、0、60,表示预测8月的消耗量为165,预测9月的消耗量为132,预测10月没有消耗,预测11月的消耗量为60。The demand prediction values of consumption in the next four months obtained from the demand prediction unit 120 by the optimal prediction algorithm are shown in Table 13. In this table, the next four months are August, September, October, and November. The demand forecast values of consumption are 165, 132, 0, and 60 respectively, which means that the predicted consumption in August is 165, the predicted consumption in September is 132, the predicted consumption in October is no consumption, and the predicted consumption in November is 60 .

[表13][Table 13]

仓库IDWarehouse ID 商品编号Product Number 年月years 消耗量consumption LOC01LOC01 PT001PT001 202108202108 165165 LOC01LOC01 PT001PT001 202109202109 132132 LOC01LOC01 PT001PT001 202110202110 00 LOC01LOC01 PT001PT001 202111202111 6060

根据上述各项数据,模拟对象商品未来4个月的库存量变化的结果如表14所示。在8月,初始库存为当前时间点的当前库存(300),入库数为该月的订单剩余量(20),出库数为该月的需求预测值(165),对初始库存加上入库数再减去出库数(300+20-165),得到期末库存(8月末库存)为155。在9月,初始库存为8月的期末库存(155),入库数为该月的订单剩余量(10),出库数为该月的需求预测值(132),对初始库存加上入库数再减去出库数(155+10-132),得到期末库存(9月末库存)为33。同样地计算10月、11月的期末库存,11月的期末库存作为最终月的模拟库存量。Based on the above data, the results of the inventory changes of the simulated target commodities in the next four months are shown in Table 14. In August, the initial inventory is the current inventory at the current time point (300), the inbound quantity is the remaining order quantity for the month (20), the outbound quantity is the demand forecast value for the month (165), and the initial inventory is added Subtract the outgoing quantity from the incoming quantity (300+20-165), and the ending inventory (end-of-August inventory) is 155. In September, the initial inventory is August's ending inventory (155), the inbound quantity is the month's remaining orders (10), the outbound quantity is the month's demand forecast (132), and the incoming inventory is added to the initial inventory The inventory quantity is subtracted from the outbound quantity (155+10-132), and the ending inventory (end-of-September inventory) is 33. Calculate the ending inventory in October and November similarly, and use the ending inventory in November as the simulated inventory in the final month.

[表14][Table 14]

仓库IDWarehouse ID 商品编号Product Number 年月years 初始库存initial inventory 入库数Number of warehousing 出库数Number of shipments 期末库存Ending inventory LOC01LOC01 PT001PT001 202108202108 300300 2020 165165 155155 LOC01LOC01 PT001PT001 202109202109 155155 1010 132132 3333 LOC01LOC01 PT001PT001 202110202110 3333 00 00 3333 LOC01LOC01 PT001PT001 202111202111 3333 00 6060 -27-27

在表14中,11月的期末库存为负值(-27),表示若当前时间点不进行补货,则该商品在4个月之后会缺货,对于这样的商品,在后续制定补货计划时需要优先确保其补货量。因此,根据库存量模拟单元170对未来库存量变化进行模拟的结果,能够得知对商品进行补货的紧急度,可以对紧急度高的商品,优先进行补货,并确保其补货量,从而制定合理的补货计划。In Table 14, the ending inventory in November is negative (-27), which means that if replenishment is not carried out at the current time point, the product will be out of stock in 4 months. For such products, replenishment will be planned in the future. Priority needs to be given to ensuring replenishment when planning. Therefore, based on the results of the simulation of future inventory changes by the inventory simulation unit 170, the urgency of replenishing goods can be known, and the replenishment of goods with high urgency can be prioritized and the replenishment amount can be ensured. So as to formulate a reasonable replenishment plan.

<补货计划生成单元><Replenishment plan generation unit>

补货计划生成单元180用于自动制定包括所有补货对象的补货量等的补货计划。The replenishment plan generation unit 180 is used to automatically formulate a replenishment plan including the replenishment quantities of all replenishment objects.

为了制定更合理准确的补货计划,补货计划生成单元180对于每种商品,根据从库存量模拟单元170获取的最终月的模拟库存量,确定该商品当前需要补货的补货优先级以及多个档位的补货量,最终生成包括所有商品的补货优先级以及补货量在内的补货计划。由于根据库存量模拟单元170中的最终月的模拟库存量的大小,能够得知对商品进行补货的紧急度,可以对紧急度高的商品,赋予较高的补货优先级,并设定较高的补货量,从而制定合理的补货计划。In order to formulate a more reasonable and accurate replenishment plan, the replenishment plan generation unit 180 determines, for each commodity, the replenishment priority of the commodity that currently needs to be replenished based on the simulated inventory amount of the final month obtained from the inventory simulation unit 170. The replenishment quantities of multiple stalls will eventually generate a replenishment plan including the replenishment priorities and replenishment quantities of all commodities. Since the urgency of replenishing products can be known based on the size of the simulated inventory in the last month in the inventory simulation unit 170, products with high urgency can be assigned a higher replenishment priority and set Higher replenishment volume, thereby developing a reasonable replenishment plan.

优选地,补货计划生成单元180还利用需求特性指标来确定补货优先级以及各档位的补货量。由于需求特性指标反映出商品的重要度,可以对重要度高的商品,赋予较高的补货优先级,并设定较高的补货量,而对于重要度低的商品,赋予较低的补货优先级,并设定较低的补货量。由此,在库存量模拟结果的基础上,进一步利用需求特性指标来确定补货优先级以及各档位的补货量,能够制定更合理的补货计划。Preferably, the replenishment plan generation unit 180 also uses demand characteristic indicators to determine the replenishment priority and the replenishment amount of each gear. Since the demand characteristic index reflects the importance of the product, products with high importance can be given a higher replenishment priority and a higher replenishment quantity can be set, while products with low importance can be given a lower replenishment priority. Prioritize replenishment and set a lower replenishment quantity. Therefore, based on the inventory simulation results, demand characteristic indicators are further used to determine the replenishment priority and the replenishment volume of each gear, so that a more reasonable replenishment plan can be formulated.

下面,说明补货计划生成单元180利用库存量模拟结果和需求特性指标制定补货计划的例子,具体过程包括如下步骤(a)、(b)、(c)。Next, an example in which the replenishment plan generation unit 180 uses inventory simulation results and demand characteristic indicators to formulate a replenishment plan is described. The specific process includes the following steps (a), (b), and (c).

(a)确定补货优先级(a) Determine replenishment priority

补货计划生成单元180按照表15所示的方式来确定商品的补货优先级。在表15中,用“S”表示最终月的模拟库存量(以下也称为模拟库存量),用“其他”表示需求特性为“需求概率≥0.8且消耗量分类=A”以外的情况。The replenishment plan generation unit 180 determines the replenishment priority of the merchandise in the manner shown in Table 15. In Table 15, "S" represents the simulated inventory amount of the final month (hereinafter also referred to as simulated inventory amount), and "Other" represents the case where the demand characteristics are other than "demand probability ≥ 0.8 and consumption classification = A".

[表15][Table 15]

对于“S<0”的商品,最终月的模拟库存量为负值,补货紧急度为最紧急,若当前时间点不进行补货则该商品在最终月会缺货,因此无论对应的需求特性如何,均将该商品的优先级设定为“高”。For products with "S<0", the simulated inventory in the final month is negative, and the replenishment urgency is the most urgent. If replenishment is not performed at the current time point, the product will be out of stock in the final month, so regardless of the corresponding demand Regardless of the characteristics, the priority of this product is set to "High".

对于“0≤S<最低库存量”的商品,最终月的模拟库存量低于最低库存量,补货紧急度为紧急,若对应的需求特性为“需求概率≥0.8且消耗量分类=A”,则表示该商品为经常使用且使用量大的重要商品,因此将优先级设定为“高”,若对应的需求特性为“其他”,则表示该商品为非重要商品,因此将优先级设定为“中”。For products with "0≤S<minimum inventory", the simulated inventory in the final month is lower than the minimum inventory, and the replenishment urgency is urgent. If the corresponding demand characteristics are "demand probability ≥ 0.8 and consumption classification = A" , it means that the product is an important product that is frequently used and has a large usage volume, so the priority is set to "High". If the corresponding demand characteristic is "Other", it means that the product is a non-important product, so the priority is set to "High". Set to "Medium".

对于“最低库存量≤S<推荐库存量”的商品,最终月的模拟库存量在最低库存量以上且低于推荐库存量,补货紧急度为不太紧急,若对应的需求特性为“需求概率≥0.8且消耗量分类=A”,则表示该商品为重要商品,因此将优先级设定为“中”,若对应的需求特性为“其他”,则表示该商品为非重要商品,因此将优先级设定为“低”。For products with "minimum inventory ≤ S < recommended inventory", the simulated inventory in the final month is above the minimum inventory and lower than the recommended inventory, and the replenishment urgency is not too urgent. If the corresponding demand characteristic is "demand" Probability ≥ 0.8 and consumption classification = A", it means that the product is an important product, so the priority is set to "medium". If the corresponding demand characteristic is "other", it means that the product is a non-important product, so Set priority to "Low".

对于“推荐库存量≤S<最高库存量”的商品,最终月的模拟库存量在推荐库存量以上且低于最高库存量,补货紧急度为不紧急,若对应的需求特性为“需求概率≥0.8且消耗量分类=A”,则表示该商品为重要商品,因此将优先级设定为“低”。对于该商品为其他需求特性的情况,由于是非重要商品且最终月的模拟库存量高,因此不作为补货对象,未在表15中列出。For products with "recommended inventory ≤ S < maximum inventory", the simulated inventory in the final month is above the recommended inventory and lower than the maximum inventory, and the replenishment urgency is not urgent. If the corresponding demand characteristic is "demand probability ≥0.8 and consumption category=A", it means that the product is an important product, so the priority is set to "low". If the product has other demand characteristics, since it is a non-important product and the simulated inventory in the final month is high, it is not a replenishment object and is not listed in Table 15.

此外,对于“S≥最高库存量”的商品,最终月的模拟库存量在最高库存量以上,不作为补货对象,未在表15中列出。In addition, for products with "S ≥ maximum inventory", the simulated inventory in the final month is above the maximum inventory, so they are not subject to replenishment and are not listed in Table 15.

(b)确定多个档位的补货量(b) Determine the replenishment quantity of multiple stalls

补货计划生成单元180在对商品确定了补货优先级之后,按照表16所示的方式对该商品确定多个档位的补货量,包括必须补货量、推荐补货量、最大补货量。在表16中,同样用“S”表示最终月的模拟库存量,用“其他”表示需求特性为“需求概率≥0.8且消耗量分类=A”以外的情况。After determining the replenishment priority for the product, the replenishment plan generation unit 180 determines multiple levels of replenishment amounts for the product in the manner shown in Table 16, including the required replenishment amount, the recommended replenishment amount, and the maximum replenishment amount. Volume. In Table 16, "S" is also used to represent the simulated inventory amount in the final month, and "other" is used to represent situations other than "demand probability ≥ 0.8 and consumption classification = A".

[表16][Table 16]

需求特性demand characteristics 条件condition 必须must 推荐recommend 最大maximum 需求概率≥0.8且消耗量分类=ADemand probability ≥ 0.8 and consumption classification = A S<0S<0 最低库存量-sMinimum inventory quantity-s 推荐库存量-sRecommended inventory quantity-s 最高库存量-sMaximum inventory quantity-s 其他other S<0S<0 -S-S 最低库存量-sMinimum inventory quantity-s 推荐库存量-sRecommended inventory quantity-s 需求概率≥0.8且消耗量分类=ADemand probability ≥ 0.8 and consumption classification = A 0≤S<最低库存量0≤S<minimum inventory quantity 最低库存量-sMinimum inventory quantity-s 推荐库存量-SRecommended stock quantity-S 最高库存量-sMaximum inventory quantity-s 其他other 0≤S<最低库存量0≤S<minimum inventory quantity 00 最低库存量-SMinimum stock quantity-S 推荐库存量-sRecommended inventory quantity-s 需求概率≥0.8且消耗量分类=ADemand probability ≥ 0.8 and consumption classification = A 最低库存量≤S<推荐库存量Minimum inventory quantity ≤S<Recommended inventory quantity 00 推荐库存量-SRecommended stock quantity-S 最高库存量-sMaximum inventory quantity-s 其他other 最低库存量≤S<推荐库存量Minimum inventory quantity ≤S<Recommended inventory quantity 00 00 推荐库存量-sRecommended inventory quantity-s 需求概率≥0.8且消耗量分类=ADemand probability ≥ 0.8 and consumption classification = A 推荐库存量≤s<最高库存量Recommended inventory quantity ≤ s < maximum inventory quantity 00 00 最高库存量-SMaximum inventory quantity-S

对于“S<0”的商品,最终月的模拟库存量为负值,若当前时间点不进行补货则该商品在最终月会缺货,补货优先级最高,若对应的需求特性为“需求概率≥0.8且消耗量分类=A”,表示该商品为重要商品,因此,将必须补货量设为“最低库存量-S”,即补至最低库存量,将推荐补货量设为“推荐库存量-S”,即补至推荐库存量,将最高补货量设为“最高库存量-S”,即补至最高库存量。若该商品对应的需求特性为“其他”,表示该商品为非重要商品,因此,将必须补货量设为“-S”,即补充最终月会缺货的数量,将推荐补货量设为“最低库存量-S”,即补至最低库存量,将最高补货量设为“推荐库存量-S”,即补至推荐库存量。For products with "S<0", the simulated inventory in the final month is negative. If replenishment is not performed at the current time point, the product will be out of stock in the final month, and the replenishment priority will be the highest. If the corresponding demand characteristics are " "Demand probability ≥ 0.8 and consumption classification = A" means that the product is an important product. Therefore, the necessary replenishment quantity is set to "minimum inventory quantity-S", that is, the minimum inventory quantity is replenished, and the recommended replenishment quantity is set to "Recommended inventory quantity-S" means to replenish the recommended inventory quantity. Set the maximum replenishment quantity to "Maximum inventory quantity-S", that is to replenish the inventory quantity to the maximum quantity. If the corresponding demand characteristic of the product is "other", it means that the product is not an important product. Therefore, the necessary replenishment quantity is set to "-S", that is, the quantity that will be out of stock in the final month is replenished, and the recommended replenishment quantity is set to It is "minimum inventory quantity - S", that is, it is replenished to the minimum inventory quantity, and the maximum replenishment quantity is set to "recommended inventory quantity - S", that is, it is replenished to the recommended inventory quantity.

对于“0≤S<最低库存量”的商品,最终月的模拟库存量低于最低库存量,补货紧急度为紧急,若对应的需求特性为“需求概率≥0.8且消耗量分类=A”,表示该商品为重要商品,因此,将必须补货量设为“最低库存量-S”,即补至最低库存量,将推荐补货量设为“推荐库存量-S”,即补至推荐库存量,将最高补货量设为“最高库存量-S”,即补至最高库存量。若该商品对应的需求特性为“其他”,表示该商品为非重要商品,因此,将必须补货量设为“0”,将推荐补货量设为“最低库存量-S”,即补至最低库存量,将最高补货量设为“推荐库存量-S”,即补至推荐库存量。For products with "0≤S<minimum inventory", the simulated inventory in the final month is lower than the minimum inventory, and the replenishment urgency is urgent. If the corresponding demand characteristics are "demand probability ≥ 0.8 and consumption classification = A" , indicating that the product is an important product, therefore, the necessary replenishment quantity is set to "minimum inventory quantity-S", that is, the minimum inventory quantity is replenished, and the recommended replenishment quantity is set to "recommended inventory quantity-S", that is, the replenishment quantity is replenished to Recommended inventory quantity, set the maximum replenishment quantity to "Maximum inventory quantity-S", that is, replenish the inventory quantity to the maximum quantity. If the corresponding demand characteristic of the product is "other", it means that the product is not an important product. Therefore, the necessary replenishment quantity is set to "0" and the recommended replenishment quantity is set to "minimum inventory quantity-S", that is, the replenishment quantity is To the minimum inventory level, set the maximum replenishment amount to "recommended inventory level -S", that is, to replenish the inventory level to the recommended inventory level.

对于“最低库存量≤S<推荐库存量”的商品,由于最终月的模拟库存量在最低库存量以上,因此,必须补货量为“0”,若该商品对应的需求特性为“需求概率≥0.8且消耗量分类=A”,表示为重要商品,将推荐补货量设为“推荐库存量-S”,即补至推荐库存量,将最高补货量设为“最高库存量-S”,即补至最高库存量。若该商品对应的需求特性为“其他”,表示该商品为非重要商品,将推荐补货量设为“0”,将最高补货量设为“推荐库存量-S”,即补至推荐库存量。For products with "minimum inventory ≤ S < recommended inventory", since the simulated inventory in the final month is above the minimum inventory, the replenishment quantity must be "0". If the demand characteristic corresponding to the product is "demand probability" ≥0.8 and consumption classification=A", indicating that it is an important product, set the recommended replenishment amount to "recommended inventory amount-S", that is, replenish it to the recommended inventory amount, and set the maximum replenishment amount to "maximum inventory amount-S" ”, that is, replenish the inventory to the maximum level. If the corresponding demand characteristic of the product is "other", it means that the product is a non-important product, set the recommended replenishment quantity to "0", and set the maximum replenishment quantity to "recommended inventory quantity-S", that is, replenish it to the recommended level inventory.

对于“推荐库存量≤S<最高库存量”的商品,由于最终月的模拟库存量在推荐库存量以上,因此,必须补货量和推荐补货量均为“0”,若对应的需求特性为“需求概率≥0.8且消耗量分类=A”,表示该商品为重要商品,将最高补货量设为“最高库存量-S”,即补至最高库存量。对于该商品为其他需求特性的情况,由于是非重要商品且最终月的模拟库存量高,因此不作为补货对象,未在表16中列出。For products with "recommended inventory ≤ S < maximum inventory", since the simulated inventory in the final month is above the recommended inventory, both the required replenishment quantity and the recommended replenishment quantity are "0". If the corresponding demand characteristics "Demand probability ≥ 0.8 and consumption classification = A" means that the product is an important product, and the maximum replenishment amount is set to "maximum inventory - S", that is, the maximum inventory is replenished. If the product has other demand characteristics, since it is a non-important product and the simulated inventory in the final month is high, it is not a replenishment object and is not listed in Table 16.

此外,对于“S≥最高库存量”的商品,由于最终月的模拟库存量充分,不作为补货对象,未在表16中列出。In addition, for products with "S≥maximum inventory", since the simulated inventory in the final month is sufficient, they are not subject to replenishment and are not listed in Table 16.

例如,某商品对应的最低库存量、推荐库存量、最高库存量分别为100、150、200,并且需求概率为0.8,消耗量分类为A类。设当前时间为8月,采购周期为4个月,若该商品的11月(最终月)的模拟库存量为50,则属于“0≤S<最低库存量”且“需求概率≥0.8且消耗量分类=A”的情况。根据表15可知,该商品的补货优先级为“高”。根据表16可知,该商品的必须补货量为100-50=50、推荐补货量为150-50=100、最大补货量为200-50=150。For example, the minimum inventory, recommended inventory, and maximum inventory corresponding to a certain product are 100, 150, and 200 respectively, and the demand probability is 0.8, and the consumption is classified as category A. Assume that the current time is August and the procurement cycle is 4 months. If the simulated inventory of the product in November (the final month) is 50, it belongs to "0 ≤ S < minimum inventory" and "demand probability ≥ 0.8 and consumption Quantity classification=A”. According to Table 15, it can be seen that the replenishment priority of this product is "high". According to Table 16, it can be seen that the required replenishment quantity of this product is 100-50=50, the recommended replenishment quantity is 150-50=100, and the maximum replenishment quantity is 200-50=150.

若上述商品的11月的模拟库存量为120,则属于“最低库存量≤S<推荐库存量”且“需求概率≥0.8且消耗量分类=A”的情况。根据表15可知,该商品的补货优先级为“中”。根据表16可知,该商品的必须补货量为0、推荐补货量为150-120=30、最大补货量为200-120=80。If the simulated inventory of the above product in November is 120, it is a situation where "minimum inventory ≤ S < recommended inventory" and "demand probability ≥ 0.8 and consumption classification = A". According to Table 15, it can be seen that the replenishment priority of this product is "medium". According to Table 16, it can be seen that the required replenishment quantity of this product is 0, the recommended replenishment quantity is 150-120=30, and the maximum replenishment quantity is 200-120=80.

此外,表15和表16中划分各种情况时采用的阈值等可以根据需要适当变更。In addition, the thresholds used in classifying various situations in Table 15 and Table 16 can be appropriately changed as needed.

(c)制定补货计划(c) Develop a replenishment plan

通过上述步骤(a)、(b),能够对每个商品确定出补货优先级、必须补货量、推荐补货量和最大补货量。然后,补货计划生成单元180将作为补货对象的所有商品的补货优先级、必须补货量、推荐补货量和最大补货量包含在内,制定出补货计划。表17中示出了制定的补货计划的一个例子。Through the above steps (a) and (b), the replenishment priority, required replenishment amount, recommended replenishment amount and maximum replenishment amount can be determined for each product. Then, the replenishment plan generation unit 180 formulates a replenishment plan including the replenishment priorities, required replenishment amounts, recommended replenishment amounts, and maximum replenishment amounts of all products targeted for replenishment. An example of a developed replenishment plan is shown in Table 17.

[表17][Table 17]

根据本实施方式的订单量优化系统,由于通过库存量模拟单元自动对未来库存量变化进行了模拟,并通过补货计划生成单元至少利用库存量模拟结果自动制定了包括补货优先级以及多个档位的补货量的补货计划,因此能够不依赖于熟练者的经验而自动地执行订单业务,并且能够迅速且准确地实现订单业务。由此,能够提高库存管理的效率以及精度。由于能够恰当地管理库存,不会出现库存积压或者缺货的情况,因此能够防止库存积压导致的资金周转困难以及缺货导致的停产等风险。According to the order quantity optimization system of this embodiment, future inventory changes are automatically simulated through the inventory simulation unit, and the replenishment plan generation unit automatically formulates a plan including replenishment priorities and multiple The replenishment plan of the replenishment amount of the stall can automatically execute the order business without relying on the experience of skilled workers, and the order business can be completed quickly and accurately. This can improve the efficiency and accuracy of inventory management. Since inventory can be properly managed, there will be no overstocking or shortage of stock. Therefore, risks such as difficulties in capital turnover caused by inventory backlog and production shutdown caused by shortage can be prevented.

(第四实施方式)(Fourth Embodiment)

图7是表示本发明的第四实施方式的订单量优化系统100C的功能结构的框图。本实施方式的订单量优化系统100C相对于第三实施方式的订单量优化系统100B的不同点在于,如图7所示,订单量优化系统100C还具备订单计划生成单元190,下面以该不同点为中心进行说明。FIG. 7 is a block diagram showing the functional structure of the order quantity optimization system 100C according to the fourth embodiment of the present invention. The difference between the order quantity optimization system 100C of this embodiment and the order quantity optimization system 100B of the third embodiment is that, as shown in FIG. 7 , the order quantity optimization system 100C also has an order plan generation unit 190. This difference will be used below. Explain the center.

通常,补货计划不能直接作为订单计划来实施,由于供应商方面存在最大产能(在本发明中也简称为产能)的限制,因此在补货计划与供应商的产能不匹配的情况下需要调整补货计划来制定最终的订单计划。Usually, the replenishment plan cannot be implemented directly as an order plan. Since there is a limit on the maximum production capacity (also referred to as production capacity in this invention) on the supplier's side, adjustments need to be made when the replenishment plan does not match the supplier's production capacity. Replenishment plan to develop final order plan.

<订单计划生成单元><Order plan generation unit>

订单计划生成单元190用于在补货计划与供应商的产能不匹配的情况下调整补货计划来制定最终的订单计划。The order plan generation unit 190 is used to adjust the replenishment plan to formulate a final order plan when the replenishment plan does not match the supplier's production capacity.

补货计划与供应商的产能不匹配的情况包括两种情况。一种情况是补货总量超过供应商的产能的情况,在该情况下,需要减少一部分商品的补货量,使减少后的补货总量不超过供应商的产能。另一种情况是补货总量低于供应商的产能的情况,在该情况下,为了使供应商的产能得到充分的应用,需要增加一部分商品的补货量,使增加后的补货总量满足供应商的产能。There are two situations where the replenishment plan does not match the supplier's production capacity. One situation is when the total replenishment quantity exceeds the supplier's production capacity. In this case, it is necessary to reduce the replenishment quantity of some commodities so that the reduced total replenishment quantity does not exceed the supplier's production capacity. Another situation is when the total replenishment quantity is lower than the supplier's production capacity. In this case, in order to fully utilize the supplier's production capacity, it is necessary to increase the replenishment quantity of some commodities so that the increased replenishment total quantity The quantity meets the supplier’s production capacity.

在生成了补货计划之后,订单计划生成单元190分别计算补货计划中各档位的补货量的合计值,判断补货计划是否与供应商的产能匹配,在不匹配的情况下判断属于哪种情况。After generating the replenishment plan, the order plan generation unit 190 calculates the total value of the replenishment quantities of each gear in the replenishment plan, determines whether the replenishment plan matches the supplier's production capacity, and determines if it does not match. Which situation.

下面,分别对两种不匹配的情况进行说明。Below, the two mismatch situations are explained respectively.

A.补货总量超过产能A. The total replenishment quantity exceeds the production capacity

下面,以表18所示的补货总量超过供应商的产能的情况为例,说明订单计划生成单元190调整补货计划来制定最终的订单计划的过程。Next, taking the case where the total replenishment amount exceeds the supplier's production capacity shown in Table 18 as an example, the process of the order plan generation unit 190 adjusting the replenishment plan to formulate the final order plan is explained.

在表18中,当前时间点为2021年8月1日,该月的补货计划中必须补货量、推荐补货量、最大补货量各自的合计值分别为583、782、996。设该月的供应商的产能为700,在该情况下,推荐补货量和最大补货量的合计值(782、996)均超过了供应商的产能。因此,订单计划生成单元190判断补货计划与供应商的产能不匹配,属于补货总量超过供应商的产能的情况。该情况下进行调整的过程包括如下步骤(a)、(b)。In Table 18, the current time point is August 1, 2021, and the total values of the required replenishment volume, recommended replenishment volume, and maximum replenishment volume in the replenishment plan for that month are 583, 782, and 996 respectively. Assume that the supplier's production capacity in that month is 700. In this case, the total value of the recommended replenishment quantity and the maximum replenishment quantity (782, 996) exceeds the supplier's production capacity. Therefore, the order plan generation unit 190 determines that the replenishment plan does not match the supplier's production capacity, and the total replenishment amount exceeds the supplier's production capacity. The adjustment process in this case includes the following steps (a) and (b).

[表18][Table 18]

(a)确定调整基数(a) Determine the adjustment base

在补货总量超过供应商的产能而需要调整的情况下,需要从多个档位中选择将哪个档位的补货量作为调整基数。When the total replenishment quantity exceeds the supplier's production capacity and needs to be adjusted, it is necessary to select which replenishment quantity from multiple ranges will be used as the adjustment base.

在本实施方式中,若只有1个档位的补货总量超过供应商的产能,则将该档位的补货量作为调整基数,若有两个以上档位的补货总量超过供应商的产能,则选择其中的最低档位的补货量作为调整基数,即,选择其中超过产能的超出量最低的档位。In this implementation, if the total replenishment volume of only one stall exceeds the supplier's production capacity, the replenishment volume of that stall will be used as the adjustment base. If the total replenishment volume of more than two stalls exceeds the supply If the manufacturer's production capacity is determined, the replenishment volume of the lowest level among them will be selected as the adjustment base, that is, the level with the lowest excess amount exceeding the production capacity will be selected.

在表18所示的补货计划中,必须补货量的合计值(583)未超过供应商的产能(700),推荐补货量和最大补货量的合计值(782、996)均超过了供应商的产能。在该情况下,推荐补货量和最大补货量中的最低档位为推荐补货量,其合计值超过产能的超出量(782-700=82)低于最大补货量的合计值的超出量(996-700=296),因此选择推荐补货量作为调整基数,进行将推荐补货量的合计值(782)降低至产能(700)的调整。In the replenishment plan shown in Table 18, the total value of the required replenishment quantity (583) does not exceed the supplier's production capacity (700), and the total values of the recommended replenishment quantity and the maximum replenishment quantity (782, 996) exceed the supplier’s production capacity. In this case, the lowest level among the recommended replenishment quantity and the maximum replenishment quantity is the recommended replenishment quantity, and the total value exceeds the excess of the production capacity (782-700=82) and is lower than the total value of the maximum replenishment quantity. The amount is exceeded (996-700=296), so the recommended replenishment amount is selected as the adjustment base, and the adjustment is made to reduce the total value of the recommended replenishment amount (782) to the production capacity (700).

(b)调整补货量(b) Adjust replenishment quantity

在本实施方式中,根据补货优先级以及需求特性指标,对选择的调整基数进行调整。下面,根据补货优先级为“中”和“低”(以下称为中低优先级)的商品的补货总量是否在超出量以上,分两种情况进行说明。In this implementation, the selected adjustment base is adjusted based on the replenishment priority and demand characteristic indicators. Below, description will be given in two cases depending on whether the total replenishment amount of the products with replenishment priorities of "medium" and "low" (hereinafter referred to as medium-low priority) is more than the excess amount.

①中低补货优先级的商品的补货总量在超出量以上①The total replenishment quantity of goods with medium and low replenishment priority is above the excess quantity

在中低优先级的商品的补货总量在超出量以上的情况下,仅以中低优先级的商品作为对象进行调整即可,从这些中低优先级的商品的补货量中共计减去与超出量相等的量,无需对高优先级的商品的补货量进行调整。首先,将补货计划中的各行按照补货优先级以及需求特性指标从低到高的顺序排序,然后从第1行开始依次减少对应的补货量,直至减少后的补货总量为供应商的产能为止,也可以减少至更低的程度。表19示出了中低优先级的商品的补货总量在超出量以上的情况下进行调整的例子。If the total replenishment quantity of mid- and low-priority products exceeds the excess amount, only mid- and low-priority products can be adjusted, and the total replenishment quantity of these mid- and low-priority products will be reduced. The amount is equal to the excess amount, and there is no need to adjust the replenishment amount of high-priority items. First, sort the rows in the replenishment plan according to the replenishment priority and demand characteristic indicators from low to high, and then reduce the corresponding replenishment amount starting from row 1 until the reduced total replenishment amount is supply up to the manufacturer's production capacity, or it can be reduced to a lower level. Table 19 shows an example in which the total replenishment quantity of mid- and low-priority items is adjusted when the excess quantity exceeds the excess quantity.

[表19][Table 19]

在表19中,中低补货优先级的商品的补货总量是第1~6行的推荐补货量总和,为3+3+6+98+85+57=252,超出量是补货总量与产能之差,为782-700=82,即,中低补货优先级的商品的补货总量大于超出量。In Table 19, the total replenishment amount of goods with medium and low replenishment priority is the sum of the recommended replenishment amounts in rows 1 to 6, which is 3+3+6+98+85+57=252. The excess amount is the replenishment amount. The difference between the total quantity of goods and the production capacity is 782-700=82, that is, the total replenishment quantity of goods with medium and low replenishment priority is greater than the excess quantity.

并且,在表19中,补货优先级按照从低到高的顺序排序,在补货优先级相同的各行中,需求概率和消耗量ABC分类按照从低到高的顺序排序,因此,越靠上方的行对应于优先级越低且越不重要的商品,可以从第1行开始依次减少对应的推荐补货量。在将第1~3行的推荐补货量减为“0”后,超出量降至82-3-3-6=70,因此再将第4行的推荐补货量减少70即可,为98-70=28,从第5行之后的推荐补货量无需调整,至此完成了补货计划的调整。将调整后的结果作为订单量,在表19的最后1列示出,订单总量为700,与供应商的产能匹配。Moreover, in Table 19, the replenishment priority is sorted from low to high. In each row with the same replenishment priority, the demand probability and consumption ABC classification are sorted from low to high. Therefore, the closer the The upper rows correspond to lower-priority and less important products, and the corresponding recommended replenishment quantities can be reduced sequentially starting from row 1. After reducing the recommended replenishment amount in rows 1 to 3 to "0", the excess amount drops to 82-3-3-6 = 70, so then reduce the recommended replenishment amount in row 4 by 70, which is 98-70=28, the recommended replenishment quantity from line 5 onwards does not need to be adjusted, and the adjustment of the replenishment plan is completed. Taking the adjusted result as the order quantity, the last column of Table 19 shows that the total order quantity is 700, which matches the supplier's production capacity.

②中低补货优先级的商品的补货总量小于超出量②The total replenishment quantity of goods with medium and low replenishment priority is less than the excess quantity

在中低优先级的商品的补货总量小于超出量的情况下,仅以中低优先级的商品作为对象进行调整不足以抵消超出量,需要进一步对高优先级的商品的补货量进行调整。首先,同样按照补货优先级以及需求特性指标从低到高的顺序排序,将所有中低补货优先级的商品的补货量减为“0”,然后,在高补货优先级的商品中进行调整。在对高补货优先级的商品进行调整时,首先确保其中的推荐补货量低于阈值的商品的补货量,该阈值可以根据需要适当设定,其次确保其中的需求概率高且消耗量大的商品的补货量,对于除此之外的商品,按各自的补货量的比例来进行调整,使调整后得到的订单总量与供应商的产能匹配。表20、表21、表22示出了该情况下进行调整的例子。When the total replenishment quantity of mid- and low-priority commodities is less than the excess amount, adjusting only the mid- and low-priority commodities is not enough to offset the excess amount. It is necessary to further adjust the replenishment amount of high-priority commodities. Adjustment. First, sort the replenishment priority and demand characteristic indicators from low to high, and reduce the replenishment quantity of all products with medium and low replenishment priority to "0". Then, in the order of high replenishment priority, to make adjustments. When adjusting products with high replenishment priority, first ensure that the recommended replenishment amount is lower than the replenishment amount of the product. The threshold can be set appropriately as needed. Secondly, ensure that the demand probability is high and the consumption is high. The replenishment quantity of large commodities and other commodities will be adjusted according to the proportion of their respective replenishment quantities, so that the total order quantity obtained after adjustment matches the supplier's production capacity. Table 20, Table 21, and Table 22 show examples of adjustments in this case.

[表20][Table 20]

在此,为了说明中低优先级的商品的补货总量小于超出量的情况,将供应商的产能设为500。在表20中,中低补货优先级的商品的补货总量是第1~6行的推荐补货量总和,为3+3+6+98+85+57=252,超出量是补货总量与产能之差,为782-500=282,即,中低补货优先级的商品的补货总量小于超出量。Here, in order to illustrate that the total replenishment quantity of low- and medium-priority goods is less than the excess quantity, the supplier's production capacity is set to 500. In Table 20, the total replenishment amount of goods with medium and low replenishment priority is the sum of the recommended replenishment amounts in rows 1 to 6, which is 3+3+6+98+85+57=252. The excess amount is the replenishment amount. The difference between the total quantity of goods and the production capacity is 782-500=282, that is, the total replenishment quantity of goods with medium and low replenishment priority is less than the excess quantity.

在表20中,与表19同样,补货优先级按照从低到高的顺序排序,在补货优先级相同的各行中,需求概率和消耗量ABC分类按照从低到高的顺序排序,越靠上方的行对应于优先级越低且越不重要的商品。首先,将所有中低补货优先级的商品的补货量减为“0”,超出量降至282-252=30,需要进一步在高补货优先级的商品中进行调整,再减少30。In Table 20, the same as Table 19, the replenishment priority is sorted from low to high. In each row with the same replenishment priority, the demand probability and consumption ABC classification are sorted from low to high. The upper rows correspond to lower priority and less important items. First, reduce the replenishment quantity of all products with medium and low replenishment priority to "0", and the excess amount will be reduced to 282-252 = 30. Further adjustments need to be made for products with high replenishment priority, and then reduced by 30.

在对第7~13行的高补货优先级的商品进行调整时,首先,确保推荐补货量低于阈值的商品,设阈值为10,第7行的商品的推荐补货量(6)低于该阈值,因此不对该行的商品的推荐补货量进行调整,直接将其作为订单量。其次,确保需求概率高且消耗量大的商品,第12~13的商品的需求概率最高且消耗量ABC分类结果为最重要的A类,因此不对这些行的商品的推荐补货量进行调整,直接作为订单量。对于除此之外的第8~11行的商品,如表21所示,按各行的商品的推荐补货量的比例来进行调整。When adjusting the products with high replenishment priority in rows 7 to 13, first ensure that the recommended replenishment quantity is lower than the threshold, set the threshold to 10, and the recommended replenishment quantity of the product in row 7 (6) is lower than the threshold, therefore the recommended replenishment quantity of the item in this row is not adjusted and is directly used as the order quantity. Secondly, ensure the products with high demand probability and large consumption. The 12th to 13th products have the highest demand probability and the consumption ABC classification result is the most important category A. Therefore, the recommended replenishment quantity of the products in these rows will not be adjusted. Directly as the order quantity. For the other products in rows 8 to 11, as shown in Table 21, adjustments are made according to the proportion of the recommended replenishment quantity of the products in each row.

[表21][Table 21]

在表21中,对于第8~11行的商品,首先,计算各行相对于第8~11行的推荐补货量总和的比例,在此,第8~11行的推荐补货量总和为27+25+35+156=243,因此例如第8行的商品的比例为27/243≈0.11,然后,用各行的比例乘以当前需要减少的数量(30)得出各行的调整量,例如第8行的商品的调整量为0.11×30≈3,因此将该行商品的推荐补货量减3后的值作为订单量,为27-3=24,对于其他行进行同样的计算,得出各自的订单量,在表21的最后1列示出。In Table 21, for the products in rows 8 to 11, first, calculate the proportion of each row relative to the total recommended replenishment amount in rows 8 to 11. Here, the total recommended replenishment amount in rows 8 to 11 is 27 +25+35+156=243, so for example, the ratio of the goods in row 8 is 27/243≈0.11. Then, multiply the ratio of each row by the current quantity that needs to be reduced (30) to get the adjustment amount of each row, for example, the ratio of row 8 The adjustment amount of the 8 rows of products is 0.11×30≈3. Therefore, the recommended replenishment quantity of the row of products minus 3 is taken as the order quantity, which is 27-3=24. The same calculation is performed for other rows, and we get The respective order quantities are shown in the last column of Table 21.

在表21的例子中,由于计算比例时仅保留了小数点后两位,舍掉了之后的部分,出现了最终减去的数量为29而未达到30的情况,还需再减去1。在该情况下,例如,可以将各行中的最大推荐补货量减1,也可以将计算比例时舍掉的部分最大的行所对应的推荐补货量减1,还可以将任意1行的推荐补货量减1,采取适当的方法进行微调即可。在此,采用将最大推荐补货量减1的方式进行微调,即,将第11行的商品的推荐补货量调整为137-1=136。最终调整后的订单量在表22的最后1列示出,订单总量为500,与供应商的产能(该例子中为500)匹配。In the example in Table 21, since only the two decimal places are retained when calculating the proportion, the subsequent parts are discarded. As a result, the final subtracted quantity is 29 but does not reach 30, and another 1 needs to be subtracted. In this case, for example, you can decrement the maximum recommended replenishment quantity in each row by 1, you can also decrement the recommended replenishment quantity corresponding to the row with the largest part that is discarded when calculating the ratio, or you can decrement the recommended replenishment quantity of any row by 1. It is recommended to reduce the replenishment quantity by 1 and adopt appropriate methods to fine-tune it. Here, fine-tuning is performed by reducing the maximum recommended replenishment quantity by 1, that is, adjusting the recommended replenishment quantity of the product in row 11 to 137-1=136. The final adjusted order quantity is shown in the last column of Table 22, with a total order quantity of 500, matching the supplier's capacity (500 in this example).

[表22][Table 22]

B.补货总量低于产能B. The total replenishment quantity is lower than the production capacity

订单计划生成单元190分别计算补货计划中各档位的补货量的合计值,在各档位的补货量的合计值均低于供应商的产能的情况下,判断为补货总量不满足供应商的产能,为了使供应商的产能得到充分的应用,需要增加一部分商品的补货量。The order plan generation unit 190 calculates the total replenishment quantity of each gear in the replenishment plan. When the total replenishment quantity of each gear is lower than the supplier's production capacity, it determines that the total replenishment quantity is If the supplier's production capacity is not met, in order to fully utilize the supplier's production capacity, it is necessary to increase the replenishment volume of some commodities.

首先,将补货计划中各商品的最大补货量作为调整基数。然后,为了选择需要增加补货量的商品,将补货计划中的各行按照库存差量从大到小的顺序排列。库存差量的计算式如式(8)所示。First, the maximum replenishment quantity of each commodity in the replenishment plan is used as the adjustment base. Then, in order to select the items that need to be increased in replenishment, the rows in the replenishment plan are arranged in order from the largest to the smallest inventory difference. The calculation formula of inventory difference is shown in Equation (8).

库存差量=历史订单量-当前库存-预计入库量 (8)Inventory difference = historical order quantity - current inventory - estimated warehousing quantity (8)

例如,对于某商品,累计过去一年内的订单量为100,作为历史订单量,当前库存为20,本期预计入库量为10,则库存差量为100-20-10=70。库存差量表示未来会使用但库存中尚未准备的量,库存差量越大,在调整时可以增加得越多。因此,可以将补货计划按照库存差量从大到小的顺序排列,然后从第1行开始选择给定数量的行来按比例增加补货量。For example, for a certain product, the cumulative order quantity in the past year is 100. As the historical order quantity, the current inventory is 20, and the expected warehousing quantity in this period is 10, then the inventory difference is 100-20-10=70. The inventory difference represents the amount that will be used in the future but has not yet been prepared in inventory. The larger the inventory difference, the more it can be increased during adjustment. Therefore, you can arrange the replenishment plan in order from large to small inventory difference, and then select a given number of rows starting from row 1 to increase the replenishment amount proportionally.

下面,以表23为例,说明在补货总量低于供应商的产能的情况下订单计划生成单元190调整补货计划来制定最终的订单计划的过程。Below, Table 23 is used as an example to illustrate the process of the order plan generation unit 190 adjusting the replenishment plan to formulate the final order plan when the total replenishment quantity is lower than the supplier's production capacity.

[表23][Table 23]

在表23所示的例子中,当前时间点为2021年8月1日,设该月的补货计划中最大补货量的合计值为560,该月的供应商的产能为700,在该情况下,将最大补货量作为调整基数,需要调整的量为700-560=140。即,需要在补货计划中选择一部分商品,使这部分商品的最大补货量共计增加140,从而满足供应商的产能。In the example shown in Table 23, the current time point is August 1, 2021. Assume that the total value of the maximum replenishment quantity in the replenishment plan for that month is 560, and the supplier's production capacity for that month is 700. In this case, the maximum replenishment quantity is used as the adjustment base, and the amount that needs to be adjusted is 700-560=140. That is, it is necessary to select a part of the goods in the replenishment plan so that the maximum replenishment quantity of this part of the goods is increased by 140 in total to meet the supplier's production capacity.

首先,根据上面的式(8)计算补货计划中各行的库存差量,然后,按照库存差量从大到小的顺序排列,并且按照需求概率和消耗量ABC分类从高到低的顺序排序,选择给定数量的行的商品的补货量作为调整对象,按各自的补货量的比例来进行调整。First, calculate the inventory difference of each row in the replenishment plan according to the above formula (8), and then arrange the inventory difference in order from large to small, and sort according to the demand probability and consumption ABC classification from high to low. , select the replenishment quantity of the goods in a given quantity of rows as the adjustment object, and adjust according to the proportion of the respective replenishment quantity.

在表23中,示出了对排序后的第1~10行的商品的补货量进行调整的例子。首先,计算各行商品的补货量相对于第1~10行的补货量总和的比例,在此,第1~10行的补货量总和为9166,因此例如第1行的商品的比例为3109/9166≈0.34,然后,用各行商品的比例乘以当前需要增加的数量(140)得出各行商品的调整量,例如第1行的商品的调整量为0.34×140≈47,因此将该行商品的补货量增加47后的值作为订单量,为10+47=57,对于其他行进行同样的计算,得出各自的订单量,在表23的最后1列示出。第1~10行的商品的补货量共计增加了140,从而满足了供应商的产能。Table 23 shows an example of adjusting the replenishment amounts of the products in the 1st to 10th rows after sorting. First, calculate the proportion of the replenishment amount of each row of products relative to the total replenishment amount of rows 1 to 10. Here, the total replenishment amount of rows 1 to 10 is 9166, so for example, the proportion of the product in row 1 is 3109/9166≈0.34. Then, multiply the proportion of each row of goods by the current quantity that needs to be increased (140) to get the adjustment amount of each row of goods. For example, the adjustment amount of the goods in row 1 is 0.34×140≈47, so the adjustment amount is 0.34×140≈47. The value after adding 47 to the replenishment quantity of the row product is used as the order quantity, which is 10+47=57. The same calculation is performed for other rows to obtain the respective order quantities, which are shown in the last column of Table 23. The replenishment quantity of goods in rows 1 to 10 has increased by a total of 140, thus satisfying the supplier's production capacity.

根据本实施方式的订单量优化系统,由于通过订单计划生成单元自动对补货计划进行调整来制定与供应商的产能匹配的订单计划,因此能够不依赖于熟练者的经验而自动地执行订单业务,并且能够迅速且准确地实现订单业务。由此,能够提高库存管理的效率以及精度。由于能够恰当地管理库存,不会出现库存积压或者缺货的情况,因此能够防止库存积压导致的资金周转困难以及缺货导致的停产等风险。According to the order quantity optimization system of this embodiment, since the order plan generation unit automatically adjusts the replenishment plan to formulate an order plan that matches the supplier's production capacity, it is possible to automatically execute the order business without relying on the experience of a skilled person. , and can realize order business quickly and accurately. This can improve the efficiency and accuracy of inventory management. Since inventory can be properly managed, there will be no overstocking or shortage of stock. Therefore, risks such as difficulties in capital turnover caused by inventory backlog and production shutdown caused by shortage can be prevented.

(第五实施方式)(fifth embodiment)

图8是表示本发明的第五实施方式的订单量优化系统200的功能结构的框图。如图8所示,订单量优化系统200具备数据收集单元210、需求预测单元220、存储器240以及库存标准设定单元260,彼此之间通过总线250互相连接。FIG. 8 is a block diagram showing the functional structure of the order quantity optimization system 200 according to the fifth embodiment of the present invention. As shown in FIG. 8 , the order quantity optimization system 200 includes a data collection unit 210 , a demand forecast unit 220 , a memory 240 and an inventory standard setting unit 260 , which are connected to each other through a bus 250 .

数据收集单元210与第一实施方式的数据收集单元110同样,从存储器240收集与商品有关的业务数据的历史数据。Like the data collection unit 110 of the first embodiment, the data collection unit 210 collects historical data of business data related to products from the memory 240 .

需求预测单元220基于通过数据收集单元210收集到的历史数据,对每种商品的未来需求量进行预测,具体预测算法并不限定,采用公知的适当算法即可。The demand prediction unit 220 predicts the future demand of each commodity based on the historical data collected by the data collection unit 210. The specific prediction algorithm is not limited, and a known appropriate algorithm can be used.

库存标准设定单元260用于对每种商品动态地设定相应的库存标准,与第二实施方式的库存标准设定单元160同样,首先基于历史数据求出表示商品的重要度的需求特性指标,然后根据求出的需求特性指标以及从需求预测单元220获取的关于未来需求量的需求预测值来设定多个级别的库存标准。The inventory standard setting unit 260 is used to dynamically set corresponding inventory standards for each product. Like the inventory standard setting unit 160 of the second embodiment, it first obtains a demand characteristic index indicating the importance of the product based on historical data. , and then multiple levels of inventory standards are set based on the calculated demand characteristic index and the demand prediction value regarding future demand obtained from the demand prediction unit 220 .

图9是表示本实施方式的订单量优化方法的流程图。如图9所示,本实施方式的订单量优化方法包括数据收集步骤S210、需求预测步骤S220和库存标准设定步骤S230。FIG. 9 is a flowchart showing the order quantity optimization method according to this embodiment. As shown in Figure 9, the order quantity optimization method of this embodiment includes a data collection step S210, a demand forecasting step S220, and an inventory standard setting step S230.

在步骤S210中,收集与商品有关的业务数据的历史数据。In step S210, historical data of business data related to the product is collected.

在步骤S220中,基于通过步骤S210收集到的与商品有关的业务数据的历史数据,对每种商品的未来需求量进行预测。In step S220, the future demand of each commodity is predicted based on the historical data of the business data related to the commodity collected in step S210.

在步骤S230中,对于每种商品,基于历史数据求出表示商品的重要度的需求特性指标,根据求出的需求特性指标以及步骤S220中的关于未来需求量的需求预测值,设定多个级别的库存标准。In step S230, for each product, a demand characteristic index indicating the importance of the product is obtained based on historical data. Based on the obtained demand characteristic index and the demand prediction value regarding future demand in step S220, a plurality of Level inventory standards.

根据本实施方式的订单量优化系统以及订单量优化方法,由于通过库存标准设定单元或步骤自动为每种商品设定了动态的库存标准,将该库存标准用于订单量的确定,因此能够不依赖于熟练者的经验而自动地执行订单业务,并且能够迅速且准确地实现订单业务。由此,能够提高库存管理的效率以及精度。由于能够恰当地管理库存,不会出现库存积压或者缺货的情况,因此能够防止库存积压导致的资金周转困难以及缺货导致的停产等风险。According to the order quantity optimization system and the order quantity optimization method of this embodiment, dynamic inventory standards are automatically set for each commodity through the inventory standard setting unit or step, and the inventory standards are used to determine the order quantity. Therefore, it is possible to The order business is automatically executed without relying on the experience of a skilled person, and the order business can be realized quickly and accurately. This can improve the efficiency and accuracy of inventory management. Since inventory can be properly managed, there will be no overstocking or shortage of stock. Therefore, risks such as difficulties in capital turnover caused by inventory backlog and production shutdown caused by shortage can be prevented.

(第六实施方式)(Sixth Embodiment)

图10是表示本发明的第六实施方式的订单量优化系统300的功能结构的框图。如图10所示,订单量优化系统300具备数据收集单元310、需求预测单元320、存储器340、库存量模拟单元370和补货计划生成单元380,彼此之间通过总线350互相连接。FIG. 10 is a block diagram showing the functional structure of the order quantity optimization system 300 according to the sixth embodiment of the present invention. As shown in FIG. 10 , the order quantity optimization system 300 includes a data collection unit 310 , a demand forecast unit 320 , a memory 340 , an inventory simulation unit 370 and a replenishment plan generation unit 380 , which are connected to each other through a bus 350 .

数据收集单元310与第一实施方式的数据收集单元110同样,从存储器340收集与商品有关的业务数据的历史数据。Like the data collection unit 110 of the first embodiment, the data collection unit 310 collects historical data of business data related to products from the memory 340 .

需求预测单元320基于通过数据收集单元310收集到的历史数据,对每种商品的未来需求量进行预测,具体预测算法并不限定,采用公知的适当算法即可。The demand prediction unit 320 predicts the future demand for each commodity based on the historical data collected by the data collection unit 310. The specific prediction algorithm is not limited, and a known appropriate algorithm can be used.

库存量模拟单元370对于每种商品,根据当前库存量、订单剩余量以及从需求预测单元320获取的关于未来需求量的需求预测值,对未来给定期间内的库存量变化进行模拟。The inventory simulation unit 370 simulates changes in the inventory within a given period in the future for each commodity based on the current inventory, the remaining order quantity, and the demand prediction value regarding future demand obtained from the demand forecasting unit 320 .

补货计划生成单元380对于每种商品,根据从库存量模拟单元370获取的未来给定期间内的最终单位期间的库存量,确定该商品当前需要补货的补货优先级以及多个档位的补货量,生成包括作为补货对象的所有商品的补货优先级以及多个档位的补货量在内的补货计划。例如,补货计划生成单元380可以按照最终单位期间的库存量越少则补货优先级越高的方式设定补货优先级,并按照补货优先级越高则各档位的补货量越多的方式设定多个档位的补货量,具体设定方式并不限定,只要能够生成商品的补货优先级以及多个档位的补货量即可。For each commodity, the replenishment plan generation unit 380 determines the replenishment priority and multiple stalls of the commodity that currently need to be replenished based on the inventory amount of the final unit period in a given period in the future obtained from the inventory simulation unit 370 The replenishment amount is generated to generate a replenishment plan including the replenishment priority of all products as replenishment objects and the replenishment amount of multiple levels. For example, the replenishment plan generation unit 380 may set the replenishment priority in such a way that the smaller the inventory amount in the final unit period is, the higher the replenishment priority will be, and set the replenishment priority in each gear in such a way that the higher the replenishment priority is, the higher the replenishment priority will be. There are more ways to set the replenishment quantity of multiple stalls. The specific setting method is not limited, as long as it can generate the replenishment priority of the product and the replenishment quantity of multiple stalls.

图11是表示本实施方式的订单量优化方法的流程图。如图11所示,本实施方式的订单量优化方法包括数据收集步骤S310、需求预测步骤S320、库存量模拟步骤330和补货计划生成步骤S340。FIG. 11 is a flowchart showing the order quantity optimization method according to this embodiment. As shown in Figure 11, the order quantity optimization method of this embodiment includes a data collection step S310, a demand forecast step S320, an inventory simulation step 330, and a replenishment plan generation step S340.

在步骤S310中,收集与商品有关的业务数据的历史数据。In step S310, historical data of business data related to the product is collected.

在步骤S320中,基于通过步骤S310收集到的与商品有关的业务数据的历史数据,对每种商品的未来需求量进行预测。In step S320, the future demand of each commodity is predicted based on the historical data of the business data related to the commodity collected in step S310.

在步骤S330中,对于每种商品,根据当前库存量、订单剩余量以及步骤S320中的关于未来需求量的需求预测值,对未来给定期间内的库存量变化进行模拟。In step S330, for each commodity, the change in inventory in a given period in the future is simulated based on the current inventory, the remaining order quantity, and the demand prediction value about future demand in step S320.

在步骤S340中,对于每种商品,根据步骤S330中的未来给定期间内的最终单位期间的库存量,确定该商品当前需要补货的补货优先级以及多个档位的补货量,生成包括作为补货对象的所有商品的补货优先级以及多个档位的补货量在内的补货计划。In step S340, for each commodity, the replenishment priority of the commodity that currently needs to be replenished and the replenishment amounts of multiple stalls are determined based on the inventory amount of the final unit period in the future given period in step S330. Generate a replenishment plan that includes the replenishment priorities of all products as replenishment objects and the replenishment quantities of multiple levels.

根据本实施方式的订单量优化系统以及订单量优化方法,由于通过库存量模拟单元或步骤自动对未来库存量变化进行了模拟,并通过补货计划生成单元或步骤至少利用库存量模拟结果自动制定了包括补货优先级以及多个档位的补货量的补货计划,因此能够不依赖于熟练者的经验而自动地执行订单业务,并且能够迅速且准确地实现订单业务。由此,能够提高库存管理的效率以及精度。由于能够恰当地管理库存,不会出现库存积压或者缺货的情况,因此能够防止库存积压导致的资金周转困难以及缺货导致的停产等风险。According to the order quantity optimization system and the order quantity optimization method of this embodiment, future inventory changes are automatically simulated through the inventory simulation unit or step, and are automatically formulated through the replenishment plan generation unit or step using at least the inventory simulation results. The replenishment plan includes replenishment priorities and replenishment quantities of multiple levels, so order business can be automatically executed without relying on the experience of skilled personnel, and order business can be completed quickly and accurately. This can improve the efficiency and accuracy of inventory management. Since inventory can be properly managed, there will be no overstocking or shortage of stock. Therefore, risks such as difficulties in capital turnover caused by inventory backlog and production shutdown caused by shortage can be prevented.

(第七实施方式)(Seventh Embodiment)

图12是表示本发明的第七实施方式的订单量优化系统400的功能结构的框图。如图12所示,订单量优化系统400具备数据收集单元410、需求预测单元420、存储器440、补货计划生成单元480和订单计划生成单元490,彼此之间通过总线450互相连接。FIG. 12 is a block diagram showing the functional structure of the order quantity optimization system 400 according to the seventh embodiment of the present invention. As shown in FIG. 12 , the order quantity optimization system 400 includes a data collection unit 410 , a demand forecast unit 420 , a memory 440 , a replenishment plan generation unit 480 and an order plan generation unit 490 , which are connected to each other through a bus 450 .

数据收集单元410与第一实施方式的数据收集单元110同样,从存储器440收集与商品有关的业务数据的历史数据。Like the data collection unit 110 of the first embodiment, the data collection unit 410 collects historical data of business data related to products from the memory 440 .

需求预测单元420基于通过数据收集单元410收集到的历史数据,对每种商品的未来需求量进行预测,具体预测算法并不限定,采用公知的适当算法即可。The demand prediction unit 420 predicts the future demand for each commodity based on the historical data collected by the data collection unit 410. The specific prediction algorithm is not limited, and a known appropriate algorithm can be used.

补货计划生成单元480对于每种商品,根据需求预测单元420的预测结果,生成包括作为补货对象的所有商品的补货量的补货计划。例如,补货计划生成单元480可以将需求预测单元420的预测结果直接作为补货量,也可以进一步考虑当前库存来设定补货量,根据需要采用适当的方法生成补货计划即可。Replenishment plan generation unit 480 generates a replenishment plan including the replenishment amounts of all commodities targeted for replenishment, for each commodity, based on the prediction results of demand prediction unit 420 . For example, the replenishment plan generation unit 480 may directly use the prediction result of the demand forecast unit 420 as the replenishment amount, or may further consider the current inventory to set the replenishment amount, and use an appropriate method to generate the replenishment plan as needed.

订单计划生成单元490对补货计划中的补货量进行调整,使得与供应商的产能匹配,将调整后的补货量作为订单量,生成包括所有商品的订单量的订单计划。例如,订单计划生成单元490可以对补货量较高的多个商品的补货量进行调整,只要能够使调整后的订单量与供应商的产能匹配即可。The order plan generation unit 490 adjusts the replenishment quantity in the replenishment plan to match the supplier's production capacity, uses the adjusted replenishment quantity as the order quantity, and generates an order plan including the order quantity of all commodities. For example, the order plan generation unit 490 can adjust the replenishment quantities of multiple commodities with higher replenishment quantities, as long as the adjusted order quantity can match the supplier's production capacity.

图13是表示本实施方式的订单量优化方法的流程图。如图13所示,本实施方式的订单量优化方法包括数据收集步骤S410、需求预测步骤S420、补货计划生成步骤S430和订单计划生成步骤S440。FIG. 13 is a flowchart showing the order quantity optimization method according to this embodiment. As shown in Figure 13, the order quantity optimization method of this embodiment includes a data collection step S410, a demand forecasting step S420, a replenishment plan generating step S430 and an order plan generating step S440.

在步骤S410中,收集与商品有关的业务数据的历史数据。In step S410, historical data of business data related to the product is collected.

在步骤S420中,基于通过步骤S410收集到的与商品有关的业务数据的历史数据,对每种商品的未来需求量进行预测。In step S420, the future demand of each commodity is predicted based on the historical data of the business data related to the commodity collected in step S410.

在步骤S430中,对于每种商品,根据步骤S420的预测结果,生成包括作为补货对象的所有商品的补货量的补货计划。In step S430, for each commodity, a replenishment plan including the replenishment amounts of all commodities targeted for replenishment is generated based on the prediction results in step S420.

在步骤S440中,对补货计划中的补货量进行调整,使得与供应商的产能匹配,将调整后的补货量作为订单量,生成包括所有商品的订单量的订单计划。In step S440, the replenishment quantity in the replenishment plan is adjusted to match the supplier's production capacity, the adjusted replenishment quantity is used as the order quantity, and an order plan including the order quantity of all commodities is generated.

根据本实施方式的订单量优化系统以及订单量优化方法,由于通过订单计划生成单元或步骤自动对补货计划进行调整来制定与供应商的产能匹配的订单计划,因此能够不依赖于熟练者的经验而自动地执行订单业务,并且能够迅速且准确地实现订单业务。由此,能够提高库存管理的效率以及精度。由于能够恰当地管理库存,不会出现库存积压或者缺货的情况,因此能够防止库存积压导致的资金周转困难以及缺货导致的停产等风险。According to the order volume optimization system and the order volume optimization method of this embodiment, the replenishment plan is automatically adjusted by the order plan generation unit or step to formulate an order plan that matches the supplier's production capacity. Therefore, it is possible to do this without relying on the skill of a skilled person. Execute order business empirically and automatically, and be able to realize order business quickly and accurately. This can improve the efficiency and accuracy of inventory management. Because inventory can be properly managed, there will be no overstocking or out-of-stock situations, so it can prevent risks such as difficulties in capital turnover caused by overstocking and production shutdowns caused by out-of-stocks.

以上,结合本发明的最佳的实施方式示出了本发明,但是本领域的技术人员能够理解,在不脱离本发明的主旨的情况下,可以对本发明进行各种修改、替换和变更,进行这样的修改、替换和变更而得到的各技术方案也包括在本发明的范围内。The present invention has been described above with reference to the best embodiments of the present invention. However, those skilled in the art will understand that various modifications, substitutions and changes can be made to the present invention without departing from the gist of the present invention. Various technical solutions resulting from such modifications, substitutions and changes are also included in the scope of the present invention.

产业上的可利用性Industrial availability

本发明的订单量优化系统、订单量优化方法以及记录介质能够广泛应用于需要对订单量进行优化的各种设备中。The order quantity optimization system, order quantity optimization method and recording medium of the present invention can be widely used in various equipment that need to optimize order quantity.

Claims (22)

1.一种订单量优化系统,其特征在于,具备:1. An order volume optimization system, characterized by: 数据收集单元,收集与商品有关的业务数据的历史数据;The data collection unit collects historical data of business data related to products; 需求预测单元,基于所述历史数据,对每种商品利用多个预测算法来预测未来需求量;以及a demand forecasting unit that uses multiple forecasting algorithms for each commodity to predict future demand based on the historical data; and 预测算法选择单元,对于每种商品,利用过去给定期间内所述多个预测算法的需求预测历史值以及该给定期间内的需求实际值,计算所述多个预测算法中每个预测算法的预测精度,选择出预测精度最高的预测算法,并从所述需求预测单元获取所述预测精度最高的预测算法关于所述未来需求量的需求预测值。A forecast algorithm selection unit, for each commodity, calculates each of the multiple forecast algorithms using the historical demand forecast values of the multiple forecast algorithms within a given period in the past and the actual demand value within the given period. According to the prediction accuracy, the prediction algorithm with the highest prediction accuracy is selected, and the demand prediction value of the prediction algorithm with the highest prediction accuracy regarding the future demand is obtained from the demand prediction unit. 2.根据权利要求1所述的订单量优化系统,其特征在于,2. The order quantity optimization system according to claim 1, characterized in that, 所述预测算法选择单元对每个预测算法计算出多个预测精度评价指标,根据所述多个预测精度评价指标的加权移动平均值来选择预测精度最高的预测算法。The prediction algorithm selection unit calculates a plurality of prediction accuracy evaluation indicators for each prediction algorithm, and selects a prediction algorithm with the highest prediction accuracy based on a weighted moving average of the plurality of prediction accuracy evaluation indicators. 3.根据权利要求1或2所述的订单量优化系统,其特征在于,3. The order quantity optimization system according to claim 1 or 2, characterized in that, 所述订单量优化系统还具备:The order volume optimization system also has: 库存标准设定单元,对于每种商品,基于所述历史数据求出表示商品的重要度的需求特性指标,根据求出的需求特性指标以及从所述需求预测单元获取的所述需求预测值,设定多个级别的库存标准。The inventory standard setting unit calculates, for each product, a demand characteristic index indicating the importance of the product based on the historical data, and based on the calculated demand characteristic index and the demand prediction value obtained from the demand forecasting unit, Set inventory standards at multiple levels. 4.根据权利要求3所述的订单量优化系统,其特征在于,4. The order quantity optimization system according to claim 3, characterized in that, 所述需求特性指标包括需求概率和消耗量ABC分类,所述需求概率表示单位期间内产生对某商品的需求的概率,所述消耗量ABC分类表示基于ABC分析法对某商品在过去给定期间内的消耗量进行分类的结果。The demand characteristic indicators include demand probability and consumption ABC classification. The demand probability represents the probability of generating demand for a certain commodity within a unit period. The consumption ABC classification represents the analysis of a certain commodity in a given period in the past based on the ABC analysis method. The result of classifying the consumption within. 5.根据权利要求4所述的订单量优化系统,其特征在于,5. The order quantity optimization system according to claim 4, characterized in that, 所述库存标准设定单元将所述需求概率为给定值以上且所述消耗量ABC分类为给定类别以上的商品设为重要商品,将其他商品设为非重要商品,根据商品是否为重要商品来分别设定所述多个级别的库存标准。The inventory standard setting unit sets the commodities whose demand probability is above a given value and whose consumption ABC is classified into a given category or above as important commodities, and sets other commodities as non-important commodities, according to whether the commodities are important Commodities are used to set the inventory standards of the multiple levels respectively. 6.根据权利要求3所述的订单量优化系统,其特征在于,6. The order quantity optimization system according to claim 3, characterized in that, 所述订单量优化系统还具备:The order volume optimization system also has: 库存量模拟单元,对于每种商品,根据当前库存量、订单剩余量以及从所述需求预测单元获取的所述需求预测值,对未来给定期间内的库存量变化进行模拟。The inventory simulation unit simulates, for each commodity, changes in inventory within a given period in the future based on the current inventory, remaining orders, and the demand forecast value obtained from the demand forecast unit. 7.根据权利要求6所述的订单量优化系统,其特征在于,7. The order quantity optimization system according to claim 6, characterized in that, 所述订单量优化系统还具备:The order volume optimization system also has: 补货计划生成单元,对于每种商品,根据从所述库存量模拟单元获取的所述未来给定期间内的最终单位期间的库存量,确定该商品当前需要补货的补货优先级以及多个档位的补货量,生成包括作为补货对象的所有商品的补货优先级以及多个档位的补货量在内的补货计划。The replenishment plan generation unit determines, for each commodity, the replenishment priority and quantity of the commodity that currently need to be replenished based on the inventory of the final unit period in the future given period obtained from the inventory simulation unit. The replenishment amount of each stall generates a replenishment plan including the replenishment priority of all products as replenishment objects and the replenishment amounts of multiple stalls. 8.根据权利要求7所述的订单量优化系统,其特征在于,8. The order quantity optimization system according to claim 7, characterized in that, 所述补货计划生成单元按照所述最终单位期间的库存量越低则补货优先级越高且各档位的补货量越高的方式,确定补货优先级以及各档位的补货量。The replenishment plan generation unit determines the replenishment priority and the replenishment of each gear in such a way that the lower the inventory amount in the final unit period, the higher the replenishment priority and the higher the replenishment amount of each gear. quantity. 9.根据权利要求7或8所述的订单量优化系统,其特征在于,9. The order quantity optimization system according to claim 7 or 8, characterized in that, 所述补货计划生成单元还利用所述需求特性指标,按照所述需求特性指标表示的重要度越高则补货优先级越高且各档位的补货量越高的方式,确定补货优先级以及各档位的补货量。The replenishment plan generation unit also uses the demand characteristic index to determine replenishment in such a way that the higher the importance represented by the demand characteristic index, the higher the replenishment priority and the higher the replenishment amount of each gear. Priority and replenishment quantity of each gear. 10.根据权利要求7所述的订单量优化系统,其特征在于,10. The order quantity optimization system according to claim 7, characterized in that, 所述订单量优化系统还具备:The order volume optimization system also has: 订单计划生成单元,对所述补货计划中的补货量进行调整,使得与供应商的产能匹配,将调整后的补货量作为订单量,生成包括所述所有商品的订单量的订单计划。The order plan generation unit adjusts the replenishment quantity in the replenishment plan so as to match the supplier's production capacity, uses the adjusted replenishment quantity as the order quantity, and generates an order plan including the order quantity of all commodities. . 11.根据权利要求10所述的订单量优化系统,其特征在于,11. The order quantity optimization system according to claim 10, characterized in that, 所述订单计划生成单元计算所述补货计划中的各档位的补货量的合计值,若存在超过所述产能的合计值,则根据所述补货优先级以及所述需求特性指标,调整合计值超过所述产能的档位之中最低档位的补货量。The order plan generation unit calculates the total value of the replenishment quantity of each gear in the replenishment plan. If there is a total value that exceeds the production capacity, based on the replenishment priority and the demand characteristic indicator, Adjust the replenishment quantity of the lowest tier among the tiers whose total value exceeds the stated production capacity. 12.根据权利要求11所述的订单量优化系统,其特征在于,12. The order quantity optimization system according to claim 11, characterized in that, 所述订单计划生成单元在对所述最低档位的补货量进行调整时,计算补货优先级为给定级别以下的商品的补货量的总量,并将该总量与该档位的补货量的合计值超过所述产能的超出量进行比较,When adjusting the replenishment amount of the lowest gear, the order plan generation unit calculates the total replenishment amount of goods with a replenishment priority below a given level, and compares the total amount with the replenishment amount of the lowest gear. The total value of the replenishment quantity exceeds the excess amount of the production capacity, 在所述总量为所述超出量以上的情况下,所述订单计划生成单元从所述给定级别以下的商品的补货量中减少所述超出量,In the case where the total amount is more than the excess amount, the order plan generation unit reduces the excess amount from the replenishment amount of goods below the given level, 在所述总量低于所述超出量的情况下,所述订单计划生成单元将所述给定级别以下的商品的补货量均减为零,并对于补货优先级高于所述给定级别的商品中除了特定商品之外的商品,以按各自的补货量的比例来减少补货量的方式进行调整,所述特定商品包括补货量低于给定阈值的商品以及所述需求特性指标在给定指标以上的商品。When the total quantity is lower than the excess amount, the order plan generating unit reduces the replenishment quantity of the commodities below the given level to zero, and replenishes the items with a replenishment priority higher than the given level. Commodities at a certain level, except for specific commodities, are adjusted in a manner that reduces the replenishment volume in proportion to their respective replenishment volumes. The specific commodities include commodities whose replenishment volume is lower than a given threshold and the above-mentioned Products whose demand characteristics index is above a given index. 13.根据权利要求10所述的订单量优化系统,其特征在于,13. The order quantity optimization system according to claim 10, characterized in that, 所述订单计划生成单元计算所述补货计划中的各档位的补货量的合计值,若不存在超过所述产能的合计值,则根据库存差量以及所述需求特性指标,对最高档位的补货量进行调整,所述库存差量通过从历史订单量中减去当前库存以及预计入库量来求出。The order plan generating unit calculates the total value of the replenishment quantity of each gear in the replenishment plan. If there is no total value that exceeds the production capacity, the highest value is calculated based on the inventory difference and the demand characteristic indicator. The replenishment quantity of the stall is adjusted, and the inventory difference is calculated by subtracting the current inventory and the expected warehousing quantity from the historical order quantity. 14.根据权利要求13所述的订单量优化系统,其特征在于,14. The order quantity optimization system according to claim 13, characterized in that, 所述订单计划生成单元在对所述最高档位的补货量进行调整时,按照所述库存差量从大到小的顺序排序,从所述库存差量最大的商品起选择所述需求特性指标在给定指标以上的给定数量的商品,以按各自的库存差量的比例来增加补货量的方式进行调整。When adjusting the replenishment amount of the highest grade, the order plan generation unit sorts the inventory difference from large to small, and selects the demand characteristics from the product with the largest inventory difference. A given quantity of goods whose index is above a given index will be adjusted by increasing the replenishment amount in proportion to their respective inventory differences. 15.一种订单量优化系统,其特征在于,具备:15. An order volume optimization system, characterized by: 数据收集单元,收集与商品有关的业务数据的历史数据;The data collection unit collects historical data of business data related to products; 需求预测单元,基于所述历史数据,对每种商品的未来需求量进行预测;以及a demand forecasting unit that predicts future demand for each commodity based on the historical data; and 库存标准设定单元,对于每种商品,基于所述历史数据求出表示商品的重要度的需求特性指标,根据求出的需求特性指标以及从所述需求预测单元获取的关于所述未来需求量的需求预测值,设定多个级别的库存标准。The inventory standard setting unit calculates, for each product, a demand characteristic index indicating the importance of the product based on the historical data, and uses the obtained demand characteristic index and the future demand obtained from the demand forecasting unit demand forecast value and set multiple levels of inventory standards. 16.一种订单量优化系统,其特征在于,具备:16. An order volume optimization system, characterized by: 数据收集单元,收集与商品有关的业务数据的历史数据;The data collection unit collects historical data of business data related to products; 需求预测单元,基于所述历史数据,对每种商品的未来需求量进行预测;The demand forecasting unit predicts the future demand for each commodity based on the historical data; 库存量模拟单元,对于每种商品,根据当前库存量、订单剩余量以及从所述需求预测单元获取的关于所述未来需求量的需求预测值,对未来给定期间内的库存量变化进行模拟;以及An inventory simulation unit, for each commodity, simulates changes in inventory within a given period in the future based on the current inventory, remaining orders, and demand forecast values about the future demand obtained from the demand forecast unit. ;as well as 补货计划生成单元,对于每种商品,根据从所述库存量模拟单元获取的所述未来给定期间内的最终单位期间的库存量,确定该商品当前需要补货的补货优先级以及多个档位的补货量,生成包括作为补货对象的所有商品的补货优先级以及多个档位的补货量在内的补货计划。The replenishment plan generation unit determines, for each commodity, the replenishment priority and quantity of the commodity that currently need to be replenished based on the inventory of the final unit period in the future given period obtained from the inventory simulation unit. The replenishment amount of each stall generates a replenishment plan including the replenishment priority of all products as replenishment objects and the replenishment amounts of multiple stalls. 17.一种订单量优化系统,其特征在于,具备:17. An order volume optimization system, characterized by: 数据收集单元,收集与商品有关的业务数据的历史数据;The data collection unit collects historical data of business data related to products; 需求预测单元,基于所述历史数据,对每种商品的未来需求量进行预测;The demand forecasting unit predicts the future demand for each commodity based on the historical data; 补货计划生成单元,对于每种商品,根据所述需求预测单元的预测结果,生成包括作为补货对象的所有商品的补货量的补货计划;以及a replenishment plan generation unit that, for each commodity, generates a replenishment plan including the replenishment amounts of all commodities that are replenishment objects based on the prediction results of the demand prediction unit; and 订单计划生成单元,对所述补货计划中的补货量进行调整,使得与供应商的产能匹配,将调整后的补货量作为订单量,生成包括所述所有商品的订单量的订单计划。The order plan generation unit adjusts the replenishment quantity in the replenishment plan so as to match the supplier's production capacity, uses the adjusted replenishment quantity as the order quantity, and generates an order plan including the order quantity of all commodities. . 18.一种订单量优化方法,其特征在于,包括:18. An order quantity optimization method, characterized by including: 数据收集步骤,收集与商品有关的业务数据的历史数据;The data collection step collects historical data of business data related to the product; 需求预测步骤,基于所述历史数据,对每种商品利用多个预测算法来预测未来需求量;以及a demand forecasting step that uses multiple forecasting algorithms for each commodity to predict future demand based on the historical data; and 预测算法选择步骤,对于每种商品,利用过去给定期间内所述多个预测算法的需求预测历史值以及该给定期间内的需求实际值,计算所述多个预测算法中每个预测算法的预测精度,选择出预测精度最高的预测算法,并获取所述需求预测步骤中的所述预测精度最高的预测算法关于所述未来需求量的需求预测值。Forecast algorithm selection step: for each commodity, use the demand forecast history values of the multiple forecast algorithms in the past given period and the actual demand value in the given period to calculate each of the multiple forecast algorithms. According to the prediction accuracy, the prediction algorithm with the highest prediction accuracy is selected, and the demand prediction value of the prediction algorithm with the highest prediction accuracy in the demand prediction step regarding the future demand is obtained. 19.一种订单量优化方法,其特征在于,包括:19. An order quantity optimization method, characterized by including: 数据收集步骤,收集与商品有关的业务数据的历史数据;The data collection step collects historical data of business data related to the product; 需求预测步骤,基于所述历史数据,对每种商品的未来需求量进行预测;以及a demand forecasting step that predicts future demand for each commodity based on the historical data; and 库存标准设定步骤,对于每种商品,基于所述历史数据求出表示商品的重要度的需求特性指标,根据求出的需求特性指标以及所述需求预测步骤中的关于所述未来需求量的需求预测值,设定多个级别的库存标准。In the inventory standard setting step, for each product, a demand characteristic index indicating the importance of the product is obtained based on the historical data, and based on the obtained demand characteristic index and the future demand in the demand forecasting step Demand forecast values set inventory standards at multiple levels. 20.一种订单量优化方法,其特征在于,包括:20. An order volume optimization method, characterized by including: 数据收集步骤,收集与商品有关的业务数据的历史数据;The data collection step collects historical data of business data related to the product; 需求预测步骤,基于所述历史数据,对每种商品的未来需求量进行预测;The demand forecasting step predicts the future demand for each commodity based on the historical data; 库存量模拟步骤,对于每种商品,根据当前库存量、订单剩余量以及所述需求预测步骤中的关于所述未来需求量的需求预测值,对未来给定期间内的库存量变化进行模拟;以及An inventory simulation step, for each commodity, simulates changes in inventory within a given period in the future based on the current inventory, remaining orders, and the demand forecast value regarding the future demand in the demand forecast step; as well as 补货计划生成步骤,对于每种商品,根据所述库存量模拟步骤中的所述未来给定期间内的最终单位期间的库存量,确定该商品当前需要补货的补货优先级以及多个档位的补货量,生成包括作为补货对象的所有商品的补货优先级以及多个档位的补货量在内的补货计划。In the replenishment plan generation step, for each commodity, according to the inventory amount in the final unit period in the future given period in the inventory simulation step, determine the replenishment priority and multiple replenishment priorities of the commodity that currently need to be replenished. The replenishment amount of the stall generates a replenishment plan including the replenishment priority of all products as replenishment objects and the replenishment amount of multiple stalls. 21.一种订单量优化方法,其特征在于,包括:21. An order volume optimization method, characterized by including: 数据收集步骤,收集与商品有关的业务数据的历史数据;The data collection step collects historical data of business data related to the product; 需求预测步骤,基于所述历史数据,对每种商品的未来需求量进行预测;The demand forecasting step predicts the future demand for each commodity based on the historical data; 补货计划生成步骤,对于每种商品,根据所述需求预测步骤的预测结果,生成包括作为补货对象的所有商品的补货量的补货计划;以及a replenishment plan generation step that, for each commodity, generates a replenishment plan including the replenishment quantities of all commodities as replenishment objects based on the prediction results of the demand forecast step; and 订单计划生成步骤,对所述补货计划中的补货量进行调整,使得与供应商的产能匹配,将调整后的补货量作为订单量,生成包括所述所有商品的订单量的订单计划。The order plan generation step is to adjust the replenishment quantity in the replenishment plan so that it matches the supplier's production capacity, use the adjusted replenishment quantity as the order quantity, and generate an order plan including the order quantity of all the commodities. . 22.一种计算机可读取的记录介质,存储有程序,其特征在于,22. A computer-readable recording medium storing a program, characterized in that: 所述程序用于使计算机执行权利要求18至21的任一项所述的订单量优化方法。The program is used to cause the computer to execute the order quantity optimization method described in any one of claims 18 to 21.
CN202210462187.1A 2022-04-24 2022-04-24 Order quantity optimizing system, order quantity optimizing method, and recording medium Pending CN117010938A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210462187.1A CN117010938A (en) 2022-04-24 2022-04-24 Order quantity optimizing system, order quantity optimizing method, and recording medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210462187.1A CN117010938A (en) 2022-04-24 2022-04-24 Order quantity optimizing system, order quantity optimizing method, and recording medium

Publications (1)

Publication Number Publication Date
CN117010938A true CN117010938A (en) 2023-11-07

Family

ID=88574969

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210462187.1A Pending CN117010938A (en) 2022-04-24 2022-04-24 Order quantity optimizing system, order quantity optimizing method, and recording medium

Country Status (1)

Country Link
CN (1) CN117010938A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN118428668A (en) * 2024-05-08 2024-08-02 德致商成(广东)软件信息技术有限公司 Purchasing service management system and method based on big data
CN119494618A (en) * 2024-11-06 2025-02-21 北京惠宜选即时科技有限公司 Forward warehouse inventory management method based on e-commerce platform

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN118428668A (en) * 2024-05-08 2024-08-02 德致商成(广东)软件信息技术有限公司 Purchasing service management system and method based on big data
CN119494618A (en) * 2024-11-06 2025-02-21 北京惠宜选即时科技有限公司 Forward warehouse inventory management method based on e-commerce platform

Similar Documents

Publication Publication Date Title
CN109272276B (en) Inventory replenishment management method and device
JP7105336B2 (en) smart supply chain system
US7213007B2 (en) Method for forecasting using a genetic algorithm
US8515835B2 (en) Systems and methods for multi-echelon inventory planning with lateral transshipment
US7389249B2 (en) Automated supply management method for dynamically fulfilling a customer requested order
EP3561749A1 (en) Inventory management apparatus, inventory management method, and storage medium
US20080086392A1 (en) Managing distribution of constrained product inventory from a warehouse
US11580490B2 (en) Supply chain replenishment simulation
CN119151442A (en) A smart warehouse management method
CN117010938A (en) Order quantity optimizing system, order quantity optimizing method, and recording medium
CN115564359B (en) Method, apparatus and storage medium for predicting inventory of after-market spare parts of automobile
US20180260769A1 (en) Supply chain analytics tool
CN113469596A (en) Intelligent supply chain system and server platform
CN113469397A (en) Intelligent supply chain system and server platform
CN115375024A (en) Method and system for predicting and reminding purchasing based on bom material loss
CN112116134B (en) A logistics planning method and related device
WO2025195484A1 (en) Demand-driven restock order generation and restock plan scheduling method and system
CN120106742A (en) Logistics digital management system based on AI big model
CN118644185B (en) A real-time order processing method for supply chain platform
WO2022190596A1 (en) Information processing device, stock management system, information processing method, and program
CN113762842A (en) Warehouse scheduling method, server and system
JP2024152506A (en) Inventory management device, inventory management system, inventory management method, and program
JP2006331459A (en) Integrated management method for live sales
CN116151725A (en) Inventory replenishment method, computer readable storage medium, and terminal device
Shen et al. SUPPLYCHAIN PRODUCTION PLANNINGANDSCHEDULING COORDINATION USING DISCRETE EVENT SIMULATION

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication