EOQ algorithm-based material order quantity measuring and calculating method and system

Abstract

The invention discloses an EOQ algorithm-based material order quantity measuring and calculating method and system. The method comprises the steps of constructing a white list transaction fact table wide table; according to the white list transaction fact table wide table, the stock amount, the daily average sales amount and the safe replenishment amount of the materials are obtained through a preset function; according to the daily average sales volume, obtaining the locked order volume of the material; according to the order locking amount, the stock amount, the daily average sales amount and the safe storage replenishment amount, combining with an improved EOQ algorithm formula, calculating the order placing amount of the material; according to the method, the order placing amount of the daily required material is measured and calculated by obtaining the key data of the material and combining the related intelligent algorithm, so that the order placing amount is automatically calculated, and more accurate data is provided; the system has the same beneficial effects.

Description

Technical Field

[0001] The present application relates to the field of electronic information technology, and in particular to a material order quantity calculation method and system based on an EOQ algorithm. Background Art

[0002] In the early days of the company's development, the daily order volume of various materials required was calculated manually offline through Excel. When the company was small, manual Excel calculations could meet the current situation. However, as the company grew larger and larger, the number of stores and the number of various materials increased rapidly. The offline manual Excel calculation method could no longer meet the needs of the company's development. The output data could not support the needs of various departments, and offline calculations required a lot of manpower. In view of this, providing a material order quantity calculation method and system based on EOQ algorithm for automatically calculating the order quantity is a technical problem that needs to be solved urgently by those skilled in the art. Summary of the invention

[0003] In order to solve the above technical problems, the purpose of the present invention is to provide a material order quantity calculation method and system based on the EOQ algorithm, which obtains the key data of the materials and combines relevant intelligent algorithms to calculate the order quantity of the materials required daily, so as to realize automatic calculation of the order quantity and provide more accurate data.

[0004] The first object of the present invention is to provide a material order quantity calculation method based on EOQ algorithm; The technical solution provided by the present invention is as follows: A material order quantity calculation method based on EOQ algorithm includes the following steps: Construct a wide table of whitelist transaction fact tables; According to the whitelist transaction fact table wide table, the inventory quantity, average daily sales volume and safe stock replenishment quantity of the material are obtained through a preset function; Obtain the locked order quantity of the material according to the average daily sales volume; The material order quantity is calculated based on the locked order quantity, the inventory quantity, the average daily sales volume and the safe storage replenishment quantity in combination with the improved EOQ algorithm formula.

[0005] Preferably, the construction of a wide whitelist transaction fact table specifically includes: The whitelist transaction fact table wide table is generated by associating the mapping dimension table of the dim combination product sku with the ods table; The whitelist transaction fact table wide table includes: daily sales calculation type field, safety stock order field, production cycle field, safety inventory days field, production order safety days and production coefficient field.

[0006] Preferably, the method of obtaining the locked order quantity, inventory quantity, daily average sales volume and safe storage replenishment quantity of the material through a preset function according to the whitelist transaction fact table wide table specifically includes: The inventory of the material is calculated according to the whitelist transaction fact table wide table through the EOQ_STOCK_UDF function.

[0007] Preferably, the method of obtaining the locked order quantity, inventory quantity, daily average sales volume and safe storage replenishment quantity of the material through a preset function according to the whitelist transaction fact table wide table specifically includes: The average daily sales volume of the material is calculated according to the wide table of the whitelist transaction fact table through the DAY_AVG_UDF function.

[0008] Preferably, the method of obtaining the locked order quantity, inventory quantity, daily average sales volume and safe storage replenishment quantity of the material through a preset function according to the whitelist transaction fact table wide table specifically includes: Obtain the number of days required for safe inventory replenishment according to the safe inventory days field in the wide table of the whitelist transaction fact table; The safe stock replenishment quantity is obtained according to the average daily sales volume and the number of days required for safe stock replenishment.

[0009] Preferably, obtaining the locked order quantity of the material according to the average daily sales volume specifically includes: The locked order quantity is obtained according to the average daily sales volume and the number of days for stocking.

[0010] Preferably, the material order quantity is calculated based on the locked order quantity, the inventory quantity, the average daily sales volume and the safe storage replenishment quantity in combination with an improved EOQ algorithm formula, specifically including: Input the locked order quantity, the inventory quantity, the average daily sales volume and the safe stock replenishment quantity into the EOQ_WATERMARK_UDF1 function to calculate the material order quantity.

[0011] The second object of the present invention is to provide a material order quantity calculation system based on EOQ algorithm; The technical solution provided by the present invention is as follows: A material order quantity calculation system based on EOQ algorithm, comprising: a construction module, a first acquisition module, a second acquisition module and a calculation module; The construction module is used to construct a wide table of whitelist transaction fact tables; The first acquisition module is used to obtain the inventory quantity, average daily sales volume and safe stock replenishment quantity of the material through a preset function according to the wide table of the whitelist transaction fact table; The second acquisition module is used to acquire the locked order quantity of the material according to the average daily sales volume; The calculation module is used to calculate the material order quantity based on the locked order quantity, the inventory quantity, the average daily sales volume and the safe storage replenishment quantity in combination with the improved EOQ algorithm formula.

[0012] The third object of the present invention is to provide an electronic device; The technical solution provided by the present invention is as follows: An electronic device, comprising: at least one processor; and A memory communicatively connected to the at least one processor, the memory storing a computer program executable by the at least one processor, the computer program being executed by the at least one processor so that the at least one processor can execute the steps of a material order quantity calculation method based on an EOQ algorithm.

[0013] A fourth object of the present invention is to provide a computer readable storage medium; The technical solution provided by the present invention is as follows: A computer-readable storage medium is used to store a computer program, and the computer program is used to enable a computer to execute the steps of a material order quantity calculation method based on an EOQ algorithm.

[0014] The present invention provides a material order quantity calculation method based on the EOQ algorithm, comprising the steps of: constructing a wide table of a whitelist transaction fact table; obtaining the inventory quantity, average daily sales volume and safe stock replenishment quantity of the material through a preset function according to the wide table of the whitelist transaction fact table; obtaining the locked order quantity of the material according to the average daily sales volume; calculating the material order quantity according to the locked order quantity, the inventory quantity, the average daily sales volume and the safe stock replenishment quantity in combination with an improved EOQ algorithm formula; the method obtains key data of the material in combination with relevant intelligent algorithms to calculate the order quantity of the material required daily, so as to realize automatic calculation of the order quantity, thereby providing more accurate data.

[0015] The present invention also provides a material order quantity calculation system based on the EOQ algorithm. Since the system and the material order quantity calculation method based on the EOQ algorithm solve the same technical problem and belong to the same technical concept, they should have the same beneficial effects and will not be described in detail here. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0017] Figure 1 This is a flow chart of a material order quantity calculation method based on EOQ algorithm in an embodiment of the present invention; Figure 2 A flow chart of calculating the safe storage replenishment quantity in an embodiment of the present invention; Figure 3 It is a structural schematic diagram of a material order quantity calculation system based on EOQ algorithm in an embodiment of the present invention; Figure 4 The figure is a schematic diagram of the structure of an electronic device in an embodiment of the present invention. DETAILED DESCRIPTION

[0018] In order to enable those skilled in the art to better understand the technical solutions in this application, the technical solutions in the embodiments of this application will be clearly and completely described below. Obviously, the described embodiments are only part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0019] It should be noted that when an element is referred to as being "fixed on" or "set on" another element, it can be directly on the other element or indirectly set on the other element; when an element is referred to as being "connected to" another element, it can be directly connected to the other element or indirectly connected to the other element.

[0020] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Therefore, a feature defined as "first" or "second" may explicitly or implicitly include one or more of the features. In the description of this application, "multiple" and "several" mean two or more, unless otherwise clearly and specifically defined.

[0021] It should be noted that the structures, proportions, sizes, etc. illustrated in the drawings of this specification are only used to match the contents disclosed in the specification for people familiar with this technology to understand and read, and are not used to limit the conditions under which this application can be implemented. Therefore, they have no substantive technical significance. Any structural modification, change in proportional relationship or adjustment of size should still fall within the scope of the technical content disclosed in this application without affecting the effects and purposes that can be achieved by this application.

[0022] like Figure 1 As shown, an embodiment of the present invention provides a material order quantity calculation method based on an EOQ algorithm, comprising the following steps: S1. Build a wide table of whitelist transaction fact tables; S2. Obtain the inventory, average daily sales, and safe storage replenishment of the material through a preset function according to the whitelist transaction fact table wide table; S3. Obtain the locked order quantity of the material according to the average daily sales volume; S4. Calculate the material order quantity based on the locked order quantity, the inventory quantity, the average daily sales volume and the safe stock replenishment quantity in combination with the improved EOQ algorithm formula.

[0023] In step S1 to step S4, by constructing a wide table of the whitelist transaction fact table, and obtaining the inventory, average daily sales, and safe storage replenishment of the material according to the preset function; then obtaining the locked order quantity of the material according to the average daily sales; then calculating the material order quantity according to the locked order quantity, inventory, average daily sales, and safe storage replenishment combined with the improved EOQ algorithm formula; by obtaining the key data of the material and combining the relevant intelligent algorithm to calculate the order quantity of the material required daily, the order quantity can be automatically calculated to provide more accurate data; the EOQ algorithm in this embodiment is an economic order quantity (EOQ) algorithm, which balances the purchase cost and the storage cost accounting to achieve the optimal order quantity with the lowest total inventory cost; the economic order quantity (EOQ) is a fixed order quantity model, which can be used to determine the quantity of an enterprise's order (purchased or self-made) at one time. When an enterprise orders according to the economic order quantity, the sum of the ordering cost and the storage cost can be minimized.

[0024] Preferably, the construction of a wide whitelist transaction fact table specifically includes: The whitelist transaction fact table wide table is generated by associating the mapping dimension table of the dim combination product sku with the ods table; The whitelist transaction fact table wide table includes: daily sales calculation type field, safety stock order field, production cycle field, safety inventory days field, production order safety days and production coefficient field.

[0025] In actual application, a whitelist transaction fact table wide table (dwd_sc_eoq_white_list_df) containing multiple fields, namely the sku material configuration table, is generated by associating a dim combination product sku mapping dimension table and three ods tables; this whitelist transaction fact table wide table composed of many fields will play an important role in providing calculation parameters in subsequent calculations. The whitelist transaction fact table wide table in this embodiment includes a material code field (Sku_code), a material name field (sku_name), a combination product code field (main_sku_code), a combination product name field (main_sku_name), a combination product identification field (substitute_flag), a combination product trigger order identification field (trigger_sku_flag), and a daily sales calculation type field (sku_type). e), province field (province), supplier type field (supplier_type), order type field (order_type), lt_LT factor field, safety stock number field (safe_stock_days), commodity business category field (sku_operate_type), LTL performance duration field (package_performance_duration), LTL MOQ order quantity field (package_moq), warehouse code field (warehouse_code), whether to allocate material identification field (allot_flag), production cycle field (production_cycle), production factor field (production_factor), production order safety days field (mo_safe_days).

[0026] Preferably, the method of obtaining the locked order quantity, inventory quantity, daily average sales volume and safe storage replenishment quantity of the material through a preset function according to the whitelist transaction fact table wide table specifically includes: The inventory of the material is calculated according to the whitelist transaction fact table wide table through the EOQ_STOCK_UDF function.

[0027] In actual application, the inventory of materials is calculated based on the wide table of whitelist transaction facts through the EOQ_STOCK_UDF function (EOQ inventory calculation function), combined with the warehouse available inventory table (dwd_sc_material_warehouse_stock_df), the purchase in transit table (dwd_sc_purchase_sub_order_df), the inter-warehouse transfer in transit table (dwd_sc_warehouse_allot_sub_order_df) and the outsourcing transfer in transit table (dwd_sc_entrust_allot_sub_order_wide_df).

[0028] Among them, the custom EOQ_STOCK_UDF function (EOQ inventory calculation function) designed when calculating the available inventory is used for inventory calculation. The input parameter of the EOQ_STOCK_UDF function (EOQ inventory calculation function) is a MAP type data structure. The key value of the data is the custom expression name, and the value value is the real numerical value brought into the calculation. Finally, the Aviator class is called in the custom EOQ_STOCK_UDF function (EOQ inventory calculation function) and the execute method of Expression is called to calculate and output according to the pre-defined calculation formula. If there are multiple calculation formulas, the UDF function will put the indicators produced by all these calculation formulas in the Json string for output.

[0029] It should be noted that inventory, nominally, refers to the inventory of goods in the warehouse that can be ordered by stores; however, in this embodiment, inventory = warehouse available inventory + in-transit inventory; and available inventory and in-transit inventory are two different indicators and two sets of calculation logic. Available inventory is divided into two sets of calculation and statistical rules for holidays and non-holidays. Flexible configuration is considered in the design here. Different calculation rules are selected in the form of configuration files (similar to pluggable) to meet the business side's calculation of warehouse available inventory with different logic in different scenarios; in-transit inventory refers to the number of materials that the purchaser has ordered and the supplier has shipped. This indicator does not involve multi-scenario calculations. Each purchase and shipment will be recorded in detail in the DWD layer transaction fact table, and can be obtained based on a DWS light summary table.

[0030] Preferably, the method of obtaining the locked order quantity, inventory quantity, daily average sales volume and safe storage replenishment quantity of the material through a preset function according to the whitelist transaction fact table wide table specifically includes: The average daily sales volume of the material is calculated according to the wide table of the whitelist transaction fact table through the DAY_AVG_UDF function.

[0031] In actual application, the average daily sales volume of materials is calculated based on the whitelist transaction fact wide table through the DAY_AVG_UDF function (EOQ daily sales calculation function), combined with the store material real sales deduction table (dws_sc_sku_sale_route_summary_di), the store sku material real outbound table (dws_sc_warehouse_in_out_task_summary_di), the beverage daily sales exclusion material table (dim_eoq_day_avg_qty_remove_sku_df), the surrounding daily sales exclusion sku material table (dim_eoq_day_avg_qty_remove_side_sku_df), the outbound group order table (dws_sc_eoq_outbound_group_order_qty_df) and the deduction group order table (dws_sc_eoq_exclude_group_order_qty_1d).

[0032] The daily average sales volume calculation in this embodiment is to calculate the average sales volume of each material in the past 7 days. According to the parameter information of each material in the wide table of the whitelist transaction fact table, the custom DAY_AVG_UDF function (EOQ daily sales calculation function) will receive different parameter information of each material, and substitute it into the formula for calculation according to the expression matching rules set in advance. For example, when calculating the daily average, the 'numerator' 7-day summary sales volume, some materials need to take the summary outbound data, some need to take the real sales data of the store, some need to take the maximum value of the outbound or sales of the material, and some need to take the average value of the outbound and sales of the material, etc. As a result, the detailed parameters calculated for each material will also be output in a Json string, which is convenient for subsequent problem data troubleshooting. The downstream can also write Sql to parse the Json string to extract the desired data for data output or report display of the relevant ads result table; the UDF function in this embodiment is implemented based on a jar package engine Aviator, which is a high-performance, lightweight Java engine for dynamic expression evaluation.

[0033] It should be noted that there is a separate calculation logic for the average daily sales of new products. Specifically, starting from the date of the new product, the actual daily sales on the first day are taken, (D1+D2) / 2 on the second day, (D1+D2+D3) / 3 on the third day.... and so on, until the 7th day, when the normal daily sales calculation logic is restored.

[0034] Preferably, the method of obtaining the locked order quantity, inventory quantity, daily average sales volume and safe storage replenishment quantity of the material through a preset function according to the whitelist transaction fact table wide table specifically includes: Obtain the number of days required for safe inventory replenishment according to the safe inventory days field in the wide table of the whitelist transaction fact table; The safe stock replenishment quantity is obtained according to the average daily sales volume and the number of days required for safe stock replenishment.

[0035] In actual use, the safe stock replenishment quantity is actually an adjustment of the safe stock days field (safe_stock_days) value corresponding to the order material in the wide table of the whitelist transaction fact table. The safe stock days field (safe_stock_days) is operated according to different needs; the purpose is to increase the warehouse inventory to cope with dates that may not be convenient to place orders, such as weekends and holidays; this type of stocking is different from locking orders. Locking orders are orders for goods to be used on a certain day in the future to be stored in the warehouse in advance. The stocking quantity of locked orders is accurately calculated by humans based on future usage through relevant prediction algorithms, while the safe stock replenishment quantity is obtained by multiplying the average sales in the past 7 days and the number of days required for safe stock replenishment, only to avoid triggering EOQ orders during these days of replenishment; such as Figure 2 The figure shows a logical process for supplementary safety deposits. In actual operation, a more refined supplementary safety deposit calculation may be made based on the material configuration information in the wide table of the whitelist transaction fact table. For example, on Wednesday, 4 days of safety deposits must be added to the prepaid materials, while only 3 days are added to the non-prepaid materials.

[0036] Preferably, obtaining the locked order quantity of the material according to the average daily sales volume specifically includes: The locked order quantity is obtained according to the average daily sales volume and the number of days for stocking.

[0037] In actual use, the order lock quantity is calculated based on the average daily sales volume and inventory preparation days of the material. The specific calculation formula is:

[0038] Among them, the average daily sales volume Q of materials has another set of sales estimation methods, which is based on the sales of similar products in history. If it is a new product, it also needs to be combined with historical new forecasts. A daily sales value is comprehensively estimated by various related calculation tags. It is also divided into different products such as beverages and peripherals and multiplied by different coefficients; the preparation days D is divided into material production cycle, material logistics cycle and material safety inventory days, which are calculated based on the order type field (order_type) in the wide table of the above-mentioned whitelist transaction fact table; if it is an "extended fulfillment cycle" type material, the preparation days D = logistics fulfillment cycle LT + procurement safety inventory days + production cycle mo_LT; if it is an ordinary material, the preparation days D = logistics fulfillment cycle LT + procurement safety inventory days; usually, the material safety inventory days are also added when calculating the locked order quantity to prevent out-of-stock due to other uncontrollable reasons. In addition, the safety storage days of different materials can be different.

[0039] The fulfillment cycle in this embodiment refers to the time from the manufacturer to the company's warehouse. The fulfillment cycle of each large warehouse for the same material may be different (for example, LT=3 for the first warehouse and LT=4 for the second warehouse).

[0040] It should be noted that the average daily sales volume Q of materials will be used in different places, and the calculation will also be different. For example, some sku materials are to take the total outbound data of the preset time, while some sku materials are to take the actual sales data of the store. In some complex scenarios, the average daily sales volume Q of the material will also be multiplied by a "coefficient" to enlarge or reduce it.

[0041] Preferably, the material order quantity is calculated based on the locked order quantity, the inventory quantity, the average daily sales volume and the safe storage replenishment quantity in combination with an improved EOQ algorithm formula, specifically including: Input the locked order quantity, the inventory quantity, the average daily sales volume and the safe stock replenishment quantity into the EOQ_WATERMARK_UDF1 function to calculate the material order quantity.

[0042] In actual application, the locked order quantity, inventory quantity, average daily sales volume and safe storage replenishment quantity are input into the EOQ_WATERMARK_UDF1 function (EOQ total order detail calculation function) to calculate the daily material order quantity. The specific calculation formula for the daily material order quantity is:

[0043] Among them, Q represents the average daily sales volume; SD represents the locked order quantity; LT represents the fulfillment time; lt represents the fulfillment time coefficient; S represents the safety stock days; s represents the supplementary safety stock days; KC represents inventory; specifically, the safety stock level can be obtained through Q*(LT+S+s)+SD; the additional order quantity can be obtained through Q*LT*lt; It should be noted that the order quantity formula for holidays is different from the order quantity formula for daily materials. The order quantity formula for holidays is: (1) EOQ flat sales model inventory calculation logic: Assume there are K activities at the same time, among which the reserved inventory of activity N (N is 1, 2, 3...K) for:

[0044] in, is the estimated shipment volume for the i-th day, input manually by an external user; Then, the calculation formula for EOQ inventory is:

[0045] Each activity is an independent "holiday" model, which reserves the quantity in a reserved manner (only the quantity of the fulfillment time LT is reserved), and then the remaining quantity is used for the sales volume calculation of the EOQ flat sales model.

[0046] (2) EOQ flat sales model sales volume calculation logic: Activity N (N can be 1, 2, 3, ... K) Sales volume on the Mth day: Take out the number of coupons written off for the corresponding activity, get the corresponding material written off quantity, and calculate the corresponding material consumption by disassembling the BOM And the actual consumption of the material on the Mth day , and then calculate the flat sales consumption on the Mth day , among which, the sales consumption The calculation formula is:

[0047] Finally, according to the flat sales consumption Calculate the break-even sales volume on the Mth day, where the EOQ break-even sales volume calculation formula on the Mth day is:

[0048] The above-mentioned formula for total holiday sales can ensure that the order volume on that day is sufficient for all stores when there is a sudden surge in orders during holidays, avoiding a backlog of goods in the warehouse and a significant increase in inventory.

[0049] like Figure 3 As shown, an embodiment of the present invention provides a material order quantity calculation system based on an EOQ algorithm, comprising: a construction module, a first acquisition module, a second acquisition module and a calculation module; The construction module is used to construct a wide table of whitelist transaction fact tables; The first acquisition module is used to obtain the inventory quantity, average daily sales volume and safe stock replenishment quantity of the material through a preset function according to the wide table of the whitelist transaction fact table; The second acquisition module is used to acquire the locked order quantity of the material according to the average daily sales volume; The calculation module is used to calculate the material order quantity based on the locked order quantity, the inventory quantity, the average daily sales volume and the safe storage replenishment quantity in combination with the improved EOQ algorithm formula.

[0050] In the actual application process, a construction module, a first acquisition module, a second acquisition module and a calculation module are set in the material order quantity calculation system based on the EOQ algorithm; wherein, the first acquisition module is connected with the construction module and the second acquisition module respectively; the second acquisition module is connected with the calculation module; a wide table of the whitelist transaction fact table is constructed through the construction module, and the wide table of the whitelist transaction fact table is transmitted to the first acquisition module; the first acquisition module obtains the inventory quantity, average daily sales volume and safe storage replenishment quantity of the material according to the wide table of the whitelist transaction fact table through a preset function, and transmits the inventory quantity, average daily sales volume and safe storage replenishment quantity of the material to the second acquisition module and the calculation module; the second acquisition module obtains the locked order quantity of the material according to the average daily sales volume, and transmits the search order quantity to the calculation module; the calculation module calculates the material order quantity according to the locked order quantity, inventory quantity, average daily sales volume and safe storage replenishment quantity in combination with the improved EOQ algorithm formula; this system obtains the key data of the material and combines the relevant intelligent algorithm to calculate the order quantity of the materials required daily, so as to realize automatic calculation of the order quantity, thereby providing more accurate data.

[0051] Furthermore, the present application also discloses an electronic device. Figure 4 This is a structural diagram of an electronic device 20 according to an exemplary embodiment. The content in the diagram cannot be regarded as any limitation on the scope of use of the present application.

[0052] Figure 4 A schematic diagram of the structure of an electronic device 20 provided in an embodiment of the present application. The electronic device 20 may specifically include: at least one processor 21, at least one memory 22, a power supply 23, a communication interface 24, an input / output interface 25, and a communication bus 26. The memory 22 is used to store a computer program, which is loaded and executed by the processor 21 to implement the relevant steps in the material order quantity calculation method based on the EOQ algorithm disclosed in any of the aforementioned embodiments. In addition, the electronic device 20 in this embodiment may specifically be an electronic computer.

[0053] In this embodiment, the power supply 23 is used to provide working voltage for each hardware device on the electronic device 20; the communication interface 24 can create a data transmission channel between the electronic device 20 and the external device, and the communication protocol it follows is any communication protocol that can be applied to the technical solution of the present application, and is not specifically limited here; the input and output interface 25 is used to obtain external input data or output data to the outside world, and its specific interface type can be selected according to specific application needs and is not specifically limited here.

[0054] In addition, the memory 22, as a carrier for storing resources, can be a read-only memory, a random access memory, a disk or an optical disk, etc. The resources stored thereon may include an operating system 221, a computer program 222 and data 223, etc. The storage method can be temporary storage or permanent storage.

[0055] Among them, the operating system 221 is used to manage and control the hardware devices and computer programs 222 on the electronic device 20 to realize the operation and processing of the data 223 in the memory 22 by the processor 21, which can be Windows Server, Netware, Unix, Linux, etc. In addition to including a computer program that can be used to complete the material order quantity calculation method based on the EOQ algorithm performed by the electronic device 20 disclosed in any of the aforementioned embodiments, the computer program 222 can further include a computer program that can be used to complete other specific tasks. In addition to including data transmitted from an external device received by the material order quantity calculation device based on the EOQ algorithm, the data 223 can also include data collected by its own input and output interface 25, etc.

[0056] The steps of the method or algorithm described in conjunction with the embodiments disclosed herein may be implemented directly using hardware, a software module executed by a processor, or a combination of the two. The software module may be placed in a random access memory (RAM), a memory, a read-only memory (ROM), an electrically programmable ROM, an electrically erasable programmable ROM, a register, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.

[0057] Furthermore, the present application also discloses a computer-readable storage medium for storing a computer program; wherein, when the computer program is executed by a processor, the aforementioned disclosed material order quantity calculation method based on the EOQ algorithm is implemented. The specific steps of the method can be referred to the corresponding contents disclosed in the aforementioned embodiments, and will not be repeated here.

[0058] It should be understood that the use of "method", "device", "unit" and / or "module" in this application is only a method for distinguishing different components, elements, parts, portions or assemblies at different levels. However, if other words can achieve the same purpose, the word can be replaced by other expressions.

[0059] As shown in this application and claims, unless the context clearly indicates an exception, the words "a", "an", "a kind" and / or "the" do not refer to the singular, but also include the plural. Generally speaking, the terms "include" and "comprise" only indicate the inclusion of clearly identified steps and elements, and these steps and elements do not constitute an exclusive list. The method or device may also include other steps or elements. The elements defined by the sentence "includes a..." do not exclude the existence of other identical elements in the process, method, commodity or device that includes the elements.

[0060] In the following, the terms "first" and "second" are used for descriptive purposes only and are not to be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of the features.

[0061] If a flow chart is used in the present application, the flow chart is used to illustrate the operations performed by the system according to the embodiment of the present application. It should be understood that the preceding or following operations are not necessarily performed accurately in order. On the contrary, each step can be processed in reverse order or simultaneously. At the same time, other operations can also be added to these processes, or a certain step or several steps of operations can be removed from these processes.

[0062] The above description of the disclosed embodiments enables those skilled in the art to implement or use the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A material order quantity calculation method based on EOQ algorithm, characterized in that: The steps include: Construct a wide table of whitelist transaction fact tables; According to the whitelist transaction fact table wide table, the inventory quantity, average daily sales volume and safe stock replenishment quantity of the material are obtained through a preset function; Obtain the locked order quantity of the material according to the average daily sales volume; The material order quantity is calculated based on the locked order quantity, the inventory quantity, the average daily sales volume and the safe storage replenishment quantity in combination with the improved EOQ algorithm formula.

2. The material order quantity calculation method based on EOQ algorithm according to claim 1 is characterized in that: The construction of the whitelist transaction fact table wide table specifically includes: The whitelist transaction fact table wide table is generated by associating the mapping dimension table of the dim combination product sku with the ods table; The whitelist transaction fact table wide table includes: daily sales calculation type field, safety stock order field, production cycle field, safety inventory days field, production order safety days and production coefficient field.

3. The material order quantity calculation method based on EOQ algorithm according to claim 1 is characterized in that: The method of obtaining the locked order quantity, inventory quantity, daily average sales volume and safe stock replenishment quantity of the material through a preset function according to the whitelist transaction fact table wide table specifically includes: The inventory of the material is calculated according to the whitelist transaction fact table wide table through the EOQ_STOCK_UDF function.

4. The material order quantity calculation method based on EOQ algorithm according to claim 1 is characterized in that: The method of obtaining the locked order quantity, inventory quantity, daily average sales volume and safe stock replenishment quantity of the material through a preset function according to the whitelist transaction fact table wide table specifically includes: The average daily sales volume of the material is calculated according to the wide table of the whitelist transaction fact table through the DAY_AVG_UDF function.

5. The material order quantity calculation method based on EOQ algorithm according to claim 4 is characterized in that: The method of obtaining the locked order quantity, inventory quantity, daily average sales volume and safe stock replenishment quantity of the material through a preset function according to the whitelist transaction fact table wide table specifically includes: Obtain the number of days required for safe inventory replenishment according to the safe inventory days field in the wide table of the whitelist transaction fact table; The safe stock replenishment quantity is obtained according to the average daily sales volume and the number of days required for safe stock replenishment.

6. The material order quantity calculation method based on EOQ algorithm according to claim 4 is characterized in that: The obtaining of the locked order quantity of the material according to the average daily sales volume specifically includes: The locked order quantity is obtained according to the average daily sales volume and the number of days for stocking.

7. The material order quantity calculation method based on EOQ algorithm according to claim 1 is characterized in that: The material order quantity is calculated based on the locked order quantity, the inventory quantity, the average daily sales volume and the safe storage replenishment quantity in combination with the improved EOQ algorithm formula, specifically including: Input the locked order quantity, the inventory quantity, the average daily sales volume and the safe stock replenishment quantity into the EOQ_WATERMARK_UDF1 function to calculate the material order quantity.

8. A material order quantity calculation system based on EOQ algorithm, characterized in that: include: A construction module, a first acquisition module, a second acquisition module and a measurement module; The construction module is used to construct a wide table of whitelist transaction fact tables; The first acquisition module is used to obtain the inventory quantity, average daily sales volume and safe stock replenishment quantity of the material through a preset function according to the wide table of the whitelist transaction fact table; The second acquisition module is used to acquire the locked order quantity of the material according to the average daily sales volume; The calculation module is used to calculate the material order quantity based on the locked order quantity, the inventory quantity, the average daily sales volume and the safe storage replenishment quantity in combination with the improved EOQ algorithm formula.

9. An electronic device, characterized in that: include: at least one processor; as well as A memory communicatively connected to the at least one processor, the memory storing a computer program executable by the at least one processor, the computer program being executed by the at least one processor so that the at least one processor can execute the method of any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The storage medium is used to store a computer program, and the computer program is used to enable a computer to execute the method according to any one of claims 1 to 7.

Images