A material requirements planning method, apparatus, and medium

Abstract

Embodiments of the present application disclose a material demand planning method, equipment and medium. A period type table is created, wherein the period type table at least includes a period type name and a period span; based on the period type table, a period span related attribute is added in a preset independent demand to obtain a reference independent demand; and based on the period type table, a period span related attribute is added in a preset material dictionary table to obtain a reference material dictionary table; data in the reference independent demand is compared with data in the reference material dictionary table for processing, so as to determine a current material demand plan based on a comparison processing result; wherein the period span in the preset independent demand is related to material production or procurement days, and the period span in the preset material dictionary is related to material preparation time in advance. The above method reduces the workload of the developer.

Description

Technical Field

[0001] This application relates to the field of manufacturing technology, and in particular to a material requirements planning method, equipment and medium. Background Technology

[0002] Material requirements planning (MRP) is a material planning and management method used in manufacturing to guide enterprise procurement and production. Enterprises decompose products into bills of materials (BOM) according to structural relationships, take each material as the planning object, take the product delivery date as the time base, and work backward from the procurement lead time of each material to formulate the material requirements plan.

[0003] Material Requirements Planning (MRP) is the core of Enterprise Resource Planning (ERP) software. MRP takes independent requirements as input, performs Bill of Materials (BOM) decomposition and available inventory calculations, and outputs a Material Requirements Plan. The relationships between independent requirements are the core of reflecting business differences. For example, the relationship between monthly plans and sales orders can be inclusive (the purpose of the monthly plan is to generate sales orders) or parallel (the monthly plan is a supply plan for core downstream customers, while sales orders are only for sporadic external orders). There are also relationships between plans of different period types (such as the relationship between monthly and weekly plans), and relationships between multiple plans for the same period in a rolling plan, etc.

[0004] Describing the relationships between independent demand plans has always been a challenge in MRP algorithms. The traditional solution is to have the system built in multiple planning strategies, such as production based entirely on forecasts, production to order, and production to stock. However, the traditional approach requires a large amount of built-in code, which brings a significant workload to developers. Summary of the Invention

[0005] This application provides a material requirements planning method, device, and medium to solve the following technical problem: How to describe the relationship between independent demand plans has always been a difficult point in MRP algorithms. The traditional solution is to have multiple planning strategies built into the system, such as production based entirely on forecasts, production based on orders, and production based on stock. However, the traditional approach requires a large amount of built-in code, which brings a large workload to developers.

[0006] The embodiments of this application adopt the following technical solutions:

[0007] This application provides a material requirements planning (MRP) method. The method includes: creating a period type table; wherein the period type table includes at least a period type name and a period span; based on the period type table, adding a period span-related attribute to a preset independent demand to obtain a reference independent demand; and based on the period type table, adding a period span-related attribute to a preset material dictionary table to obtain a reference material dictionary table; comparing the data in the reference independent demand with the data in the reference material dictionary table to determine the current MRP plan based on the comparison results; wherein the period span in the preset independent demand is related to the number of days for material production or procurement, and the period span in the preset material dictionary is related to the material preparation time in advance.

[0008] This application embodiment creates a period type table and associates it with pre-set independent demand and a pre-set material dictionary table. This ensures that both the independent demand and material dictionary tables used for MRP calculations have planned period types and period spans. The newly added period span allows determination of whether the current material requirements plan can be executed. This application embodiment introduces a simple integer period span field as a basic attribute of independent demand and materials into its period span material requirements planning algorithm. By comparing the size of the period span, the relationships between demand and demand, and between materials and demand, are determined, thereby assembling numerous planning strategy scenarios, improving the software's adaptability, and reducing code complexity and volume.

[0009] In one implementation of this application, the data in the reference independent demand is compared with the data in the reference material dictionary table to determine the current material demand plan based on the comparison results. Specifically, this includes: comparing the period span data in the reference independent demand with the period span data in the reference material dictionary; and comparing material demand order data at different levels; and determining the current material demand plan based on the period span data and the material demand order data at different levels.

[0010] In one implementation of this application, the current material requirement plan is determined based on the period span data and material requirement order data at different levels. Specifically, this includes: if the period span data in the reference independent requirement is greater than the period span data in the reference material dictionary, the current material requirement plan is determined to be unexecutable; if the upper-level material requirement order is unexecutable, all lower-level material requirement orders corresponding to the upper-level material requirement order are also unexecutable.

[0011] In one implementation of this application, based on the period type table, a period span-related attribute is added to the preset independent demand to obtain reference independent demand. Specifically, this includes: dividing the preset independent demand into forecast demand and order demand based on different data in the preset independent demand; setting the period span attribute for forecast demand and order demand respectively based on the period type table to obtain reference independent demand; wherein, forecast demand is related to the forecasted production plan in different periods, and order demand is related to the sales information in different periods.

[0012] In one implementation of this application, based on the period type table, period span attributes are set for both forecast-type and order-type requirements to obtain reference independent requirements. Specifically, this includes: when a requirement is determined to be forecast-type, determining the period type in the forecast-type requirement, associating the period type with the period type table to automatically assign a value to the period span in the forecast-type requirement; when a requirement is determined to be order-type, setting the period span in the order-type requirement to 0; and obtaining reference independent requirements based on the forecast-type requirements and the order-type requirements after attribute settings.

[0013] In one implementation of this application, the forecast-type demand includes at least one of the following attributes: material code, material name, planning period type, planning period, demand quantity, demand date, period span, and other attributes; the order-type demand includes at least one of the following attributes: material code, material name, sales quantity, and delivery date.

[0014] In one implementation of this application, based on the period type table, a period span-related attribute is added to the preset material dictionary table to obtain a reference material dictionary table. Specifically, this includes: determining the period type in the preset material dictionary table, associating the period type with the period type table, and automatically assigning values ​​to the period span in the preset material dictionary table.

[0015] In one implementation of this application, the reference material dictionary table includes at least one of the following: material code, material name, planning period type, and period span; the material name includes at least one of the following: finished product, semi-finished product, and raw material.

[0016] This application provides a material requirements planning (MRP) device, including: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to: create a period type table; wherein the period type table includes at least a period type name and a period span; based on the period type table, add a period span-related attribute to a preset independent demand to obtain a reference independent demand; and based on the period type table, add a period span-related attribute to a preset material dictionary table to obtain a reference material dictionary table; compare the data in the reference independent demand with the data in the reference material dictionary table to determine the current material requirements plan based on the comparison result; wherein the period span in the preset independent demand is related to the number of days for material production or procurement, and the period span in the preset material dictionary is related to the material advance preparation time.

[0017] This application provides a non-volatile computer storage medium storing computer-executable instructions, which are configured to: create a period type table; wherein the period type table includes at least a period type name and a period span; based on the period type table, add a period span-related attribute to a preset independent demand to obtain a reference independent demand; and based on the period type table, add a period span-related attribute to a preset material dictionary table to obtain a reference material dictionary table; compare the data in the reference independent demand with the data in the reference material dictionary table to determine the current material demand plan based on the comparison results; wherein the period span in the preset independent demand is related to the number of days for material production or procurement, and the period span in the preset material dictionary is related to the advance preparation time for materials.

[0018] The at least one technical solution adopted in this application embodiment can achieve the following beneficial effects: This application embodiment creates a period type table and associates this period type table with a preset independent demand and a preset material dictionary table, so that both the independent demand and the material dictionary table used for MRP calculation are set with planning period types and period spans. It is possible to determine whether the current material demand plan can be executed by using the newly added period span. In this application embodiment, the material demand planning algorithm for period span introduces a simple integer type period span field as a basic attribute of independent demand and materials. By comparing the size of the period span, the relationship between demand and demand, and the relationship between materials and demand, are determined, thereby assembling numerous planning strategy scenarios, improving the adaptability of the software, and reducing code complexity and code volume. Attached Figure Description

[0019] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0020] In the picture:

[0021] Figure 1 A flowchart of a material requirements planning method provided in this application embodiment;

[0022] Figure 2 This is a schematic diagram of the structure of a material requirements planning (MRP) device provided in an embodiment of this application. Detailed Implementation

[0023] This application provides a material requirements planning method, apparatus, and medium.

[0024] 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 with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. Based on the embodiments of this specification, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of this application.

[0025] Material requirements planning (MRP) is a material planning and management method used in manufacturing to guide enterprise procurement and production. Enterprises decompose products into bills of materials (BOMs) according to their structural relationships, take each material as the planning object, use the product delivery date as the time base, and work backward from the procurement lead time of each material to formulate the material requirements plan.

[0026] Material Requirements Planning (MRP) is the core of Enterprise Resource Planning (ERP) software. MRP takes independent requirements as input, performs Bill of Materials (BOM) decomposition and available inventory calculations, and outputs a Material Requirements Plan. The relationships between independent requirements are the core of reflecting business differences. For example, the relationship between monthly plans and sales orders can be inclusive (the purpose of the monthly plan is to generate sales orders) or parallel (the monthly plan is a supply plan for core downstream customers, while sales orders are only for sporadic external orders). There are also relationships between plans of different period types (such as the relationship between monthly and weekly plans), and relationships between multiple plans for the same period in a rolling plan, etc.

[0027] Describing the relationships between independent demand plans has always been a challenge in MRP algorithms. The traditional solution is to have the system built in multiple planning strategies, such as production based entirely on forecasts, production to order, and production to stock. However, the traditional approach requires a large amount of built-in code, which brings a significant workload to developers.

[0028] To address the aforementioned issues, this application provides a Material Requirements Planning (MRP) system, equipment, and media. By creating a period type table and associating it with pre-defined independent requirements and a pre-defined material dictionary table, both the independent requirements and material dictionary table used for MRP calculations are configured with planning period types and period spans. The newly added period span allows for determination of whether the current MRP plan can be executed. This application's MRP algorithm introduces a simple integer period span field as a basic attribute of independent requirements and materials. By comparing the size of the period span, the relationships between requirements and between materials and requirements are determined, thereby enabling the creation of numerous planning strategy scenarios, improving the software's adaptability, and reducing code complexity and volume.

[0029] The technical solutions proposed in the embodiments of this application will be described in detail below with reference to the accompanying drawings.

[0030] Figure 1 A flowchart illustrating a material requirements planning method provided in this application embodiment. Figure 1 As shown, the Material Requirements Planning (MRP) method includes the following steps:

[0031] S101. Create a period type table; the period type table must include at least the period type name and the period span.

[0032] In one embodiment of this application, Material Requirements Planning (MRP) is the core of Enterprise Resource Planning (ERP) software. MRP takes independent requirements as input, performs Bill of Materials (BOM) decomposition and available inventory calculation, and outputs a Material Requirements Plan. Independent requirements can be further divided into forecast-based requirements and order-based requirements. Forecast-based requirements are non-deterministic and generally correspond to various period forecast plans for the enterprise, such as annual, monthly, and weekly forecast plans, which are continuously rolling and overlapping. Order-based requirements are deterministic and generally refer to sales contracts signed by the enterprise, with clearly defined product types, quantities, and delivery dates. The period type is defined first.

[0033] First, create a period type table and implement the input / output functionality for period types. Its basic data structure information is shown in Table 1:

[0034]

[0035] Table 1

[0036] As shown in Table 1, the period type table includes a period type name, which can be a time period such as year, quarter, month, week, or day. The period type table also includes a period span, which can be the number of days corresponding to different period types. For example, the period span for a year is 365, and the period span for a month is 30.

[0037] S102. Based on the period type table, add period span related attributes to the preset independent requirements to obtain reference independent requirements.

[0038] In one embodiment of this application, based on different data in the preset independent demand, the preset independent demand is divided into forecast demand and order demand. Based on the period type table, the period span attribute is set for forecast demand and order demand respectively to obtain reference independent demand. Among them, forecast demand is related to the forecasted production plan in different periods, and order demand is related to the sales information in different periods.

[0039] Specifically, independent demand can be further divided into forecast demand and order demand. Forecast demand is non-deterministic demand, generally corresponding to various period forecast plans of an enterprise, such as annual forecast plans, monthly forecast plans, and weekly forecast plans, which are continuously rolling and overlapping. Order demand is deterministic demand, generally referring to sales contracts signed by an enterprise, with clearly defined product types, quantities, and delivery dates.

[0040] Based on the different independent demands, these demands are categorized into forecast demands and order demands. A period span attribute is then set for both forecast and order demands to obtain reference independent demands.

[0041] In one embodiment of this application, when a demand is determined to be a forecast demand, the period type within the forecast demand is determined, and the period type is associated with a period type table to automatically assign a value to the period span in the forecast demand. When a demand is determined to be an order demand, the period span in the order demand is determined to be 0. Based on the forecast demand with attribute settings and the order demand with attribute settings, a reference independent demand is obtained.

[0042] Specifically, when setting the period span attribute for forecast-type requirements, the period type and period span of the forecast-type requirement are determined, and the period type in the forecast-type requirement is associated with the period type table. Based on the period type in the forecast-type requirement, the corresponding period span value can be automatically assigned. Secondly, the period span in order-type requirements is always set to the minimum, i.e., the period span in order-type requirements is always 0. Basic information regarding adding period span-related attributes to independent requirements is shown in Table 2.

[0043]

[0044] Table 2

[0045] As shown in Table 2, the period span related attributes for independent demand increases include period type, which is associated with the period type table. Furthermore, the period span can be automatically assigned a value based on the associated period type table.

[0046] Furthermore, forecast-type demand must include at least one of the following attributes: material code, material name, planning period type, planning period, demand quantity, demand date, period span, and other attributes; order-type demand must include at least one of the following attributes: material code, material name, sales quantity, and delivery date.

[0047] S103. Based on the period type table, add period span-related attributes to the preset material dictionary table to obtain the reference material dictionary table. The period span in the preset independent demand is related to the number of days for material production or procurement, while the period span in the preset material dictionary is related to the material preparation time in advance.

[0048] In one embodiment of this application, the period type in the preset material dictionary table is determined, and the period type is associated with the period type table to automatically assign values ​​to the period span in the preset material dictionary table.

[0049] Furthermore, the reference material dictionary should include at least one of the following: material code, material name, planning period type, and period span. The material name should include at least one of the following: finished product, semi-finished product, or raw material.

[0050] Specifically, when adding period span-related attributes to the pre-defined material dictionary table, the added content includes period type and period span. The period type is associated with the period type table, and the period span can be automatically assigned a value based on the associated period type table.

[0051] It should be noted that the period span-related attributes added to the material dictionary have the same basic information as those in Table 2. This embodiment of the application will not elaborate further on this.

[0052] S104. Compare the data in the reference independent demand with the data in the reference material dictionary table to determine the current material demand plan based on the comparison results.

[0053] In one embodiment of this application, the period span data in the reference independent demand is compared with the period span data in the reference material dictionary; and material requirement order data at different levels are compared. Based on the period span data and the material requirement order data at different levels, the current material requirement plan is determined.

[0054] In one embodiment of this application, if the period span data in the reference independent demand is greater than the period span data in the reference material dictionary, the current material requirement plan is determined to be unexecutable. If the parent material requirement order is unexecutable, all subsequent child material requirement orders corresponding to that parent material requirement order are also unexecutable.

[0055] Specifically, MRP calculations parse the period span parameters of independent demand and the material dictionary to combine them to implement various planning strategy scenarios. A plan cannot be executed if the period span of the source independent demand is greater than the period span of the material dictionary. Here, the period span of the material dictionary is understood as the number of production or procurement days, and the period span of the source independent demand is understood as the number of days of advance preparation. For example, a product with a production cycle of 1 day does not need to be produced 30 days in advance.

[0056] Furthermore, when a higher-level material demand plan order is unfeasible, the resulting lower-level material demand plans are meaningless and will not be considered as projections. Only projected output will play a role in providing supply for other demands, reflecting the inclusion relationship between demands.

[0057] Secondly, the parsing rules for whether the period span is executable are consistent from the top-level independent demand to the material demand planning at each level of the BOM, and can be combined to realize various planning strategy scenarios.

[0058] This application illustrates the material requirements planning method through specific examples.

[0059] In one embodiment of this application, sales orders and forecast plans are determined from independent demand. The period span in the sales orders is treated as 0, and the period span in the forecast plans is obtained from the documents.

[0060] Specifically, Table 3 shows an example of period type representation:

[0061]

[0062] Table 3

[0063] As shown in Table 3, the period type names in the period type table can include year, quarter, month, and week, etc. Different period type names correspond to different period spans, which are related to the number of days corresponding to that period type.

[0064] Specifically, Table 4 shows examples of sales orders in independent demand:

[0065]

[0066] Table 4

[0067] As shown in Table 4, a sales order includes information such as material name, sales quantity, material code, and delivery date. The period span of a sales order is fixed at 0.

[0068] Specifically, Table 5 provides an example of a forecast plan for independent demand:

[0069]

[0070] Table 5

[0071] As shown in Table 5, the forecast plan includes information such as material code, material name, planning period type, planning period, required quantity, required date, and period span.

[0072] In one embodiment of this application, a material dictionary table is determined to participate in the calculation.

[0073] Specifically, Table 6 shows an example of a material dictionary representation:

[0074]

[0075] Table 6

[0076] As shown in Table 6, the material dictionary includes information such as material code, material name, planning period type, and period span. The material name may include information such as finished products, semi-finished products, and raw materials.

[0077] MRP calculations are performed based on independent demand tables, available inventory information, and BOM information to obtain the material requirements plan.

[0078] Specifically, Table 7 shows an example of a BOM representation:

[0079]

[0080] Table 7

[0081] As shown in Table 7, the BOM table includes parent item material code, child item material code, parent item quantity, and child item quantity information.

[0082] Table 8 shows examples of MRP calculations:

[0083]

[0084] Table 8

[0085] As shown in Table 8, finished products 0 days: indicates a short production cycle, which can be completed on the same day and is suitable for assembly to order; semi-finished products 7 days: indicates a production cycle of about one week, requiring 7 days of advance preparation; raw materials 30 days: indicates a procurement and delivery cycle of about one month, requiring 30 days of advance preparation.

[0086] Figure 2This is a schematic diagram of a material requirements planning (MRP) device provided as an embodiment of this application. Figure 2 As shown, the material requirements planning equipment includes:

[0087] At least one processor; and,

[0088] A memory communicatively connected to the at least one processor; wherein,

[0089] The memory stores instructions that can be executed by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to:

[0090] Create a period type table; wherein the period type table includes at least a period type name and a period span;

[0091] Based on the aforementioned period type table, a period span-related attribute is added to the preset independent requirements to obtain reference independent requirements; and

[0092] Based on the aforementioned period type table, period span related attributes are added to the preset material dictionary table to obtain a reference material dictionary table;

[0093] The data in the reference independent demand is compared with the data in the reference material dictionary table to determine the current material demand plan based on the comparison results.

[0094] The period span in the pre-set independent demand is related to the number of days for material production or procurement, and the period span in the pre-set material dictionary is related to the advance preparation time for materials.

[0095] This application embodiment also provides a non-volatile computer storage medium storing computer-executable instructions, the computer...

[0096] Executable instructions are set as follows:

[0097] Create a period type table; wherein the period type table includes at least a period type name and a period span;

[0098] Based on the aforementioned period type table, a period span-related attribute is added to the preset independent requirements to obtain reference independent requirements; and

[0099] Based on the aforementioned period type table, period span related attributes are added to the preset material dictionary table to obtain a reference material dictionary table;

[0100] The data in the reference independent demand is compared with the data in the reference material dictionary table to determine the current material demand plan based on the comparison results.

[0101] The period span in the pre-set independent demand is related to the number of days for material production or procurement, and the period span in the pre-set material dictionary is related to the advance preparation time for materials.

[0102] The various embodiments in this application are described in a progressive manner. Similar or identical parts between embodiments can be referred to mutually. Each embodiment focuses on describing the differences from other embodiments. In particular, the embodiments of apparatus, devices, and non-volatile computer storage media are basically similar to the method embodiments, so the descriptions are relatively simple; relevant parts can be referred to the descriptions of the method embodiments.

[0103] Those skilled in the art will understand that the embodiments of this specification can be provided as methods, systems, or computer program products. Therefore, the embodiments of this specification can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the embodiments of this specification can take the form of a computer program product implemented on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0104] This specification is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this specification. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create a machine for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0105] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0106] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0107] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0108] Memory may include non-persistent storage in computer-readable media, such as random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM. Memory is an example of computer-readable media.

[0109] Computer-readable media includes both permanent and non-permanent, removable and non-removable media that can store information using any method or technology. Information can be computer-readable instructions, data structures, modules of programs, or other data. Examples of computer storage media include, but are not limited to, phase-change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, CD-ROM, digital versatile optical disc (DVD) or other optical storage, magnetic tape, magnetic magnetic disk storage or other magnetic storage devices, or any other non-transferable medium that can be used to store information accessible by a computing device. As defined herein, computer-readable media does not include transient computer-readable media, such as modulated data signals and carrier waves.

[0110] The foregoing has described specific embodiments of this application. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims may be performed in a different order than that shown in the embodiments and may still achieve the desired results. Furthermore, the processes depicted in the drawings do not necessarily require the specific or sequential order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0111] The above description is merely an embodiment of this application and is not intended to limit this application. For those skilled in the art, various modifications and variations can be made to the embodiments of this application. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principle of the embodiments of this application should be included within the scope of the claims of this application.

Claims

1. A material requirements planning method, characterized in that, The method includes: Create a period type table; wherein the period type table includes at least a period type name and a period span; Based on the period type table, a period span-related attribute is added to the preset independent demand to obtain reference independent demand. Specifically, this includes: dividing the preset independent demand into forecast demand and order demand based on different data; setting the period span attribute for the forecast demand and the order demand respectively based on the period type table to obtain the reference independent demand; wherein, the forecast demand is related to the forecasted production plan within different periods, and the order demand is related to the sales information within different periods; setting the period span attribute for the forecast demand and the order demand respectively based on the period type table to obtain the reference independent demand specifically includes: when determined to be a forecast demand, determining the period type in the forecast demand, associating the period type with the period type table to automatically assign a value to the period span in the forecast demand; when determined to be an order demand, determining the period span in the order demand to be 0; obtaining the reference independent demand based on the forecast demand with the attribute settings and the order demand with the attribute settings; and Based on the period type table, a period span related attribute is added to the preset material dictionary table to obtain a reference material dictionary table. Specifically, this includes: determining the period type in the preset material dictionary table, associating the period type with the period type table, and automatically assigning values ​​to the period span in the preset material dictionary table. The data in the reference independent demand is compared with the data in the reference material dictionary table to determine the current material demand plan based on the comparison results. If the period span data in the reference independent demand is greater than the period span data in the reference material dictionary, the current material demand plan is determined to be unexecutable. The period span in the pre-set independent demand is related to the number of days for material production or procurement, and the period span in the pre-set material dictionary is related to the advance preparation time for materials.

2. The material requirements planning method according to claim 1, characterized in that, The step of comparing the data in the reference independent demand with the data in the reference material dictionary table to determine the current material demand plan based on the comparison results specifically includes: The period span data in the reference independent demand is compared with the period span data in the reference material dictionary; and Compare material requirement order data at different levels; Based on the aforementioned period span data and the material demand order data at different levels, the current material demand plan is determined.

3. The material requirements planning method according to claim 2, characterized in that, The determination of the current material requirements plan based on the period span data and the material requirements order data at different levels specifically includes: If a higher-level material requirement order is unexecutable, then all lower-level material requirement orders corresponding to that higher-level material requirement order are also unexecutable.

4. The material requirements planning method according to claim 1, characterized in that, The predicted demand shall include at least one of the following attributes: material code, material name, planning period type, planning period, demand quantity, demand date, period span, and other attributes. The order requirements must include at least one of the following: material code, material name, sales quantity, and delivery date.

5. The material requirements planning method according to claim 1, characterized in that, The reference material dictionary table shall include at least one of the following: material code, material name, planning period type, and period span; The material name shall include at least one of the following: finished product, semi-finished product, and raw material.

6. A material requirements planning (MRP) device, comprising: At least one processor; as well as, A memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to: Create a period type table; wherein the period type table includes at least a period type name and a period span; Based on the period type table, a period span-related attribute is added to the preset independent demand to obtain reference independent demand. Specifically, this includes: dividing the preset independent demand into forecast demand and order demand based on different data; setting the period span attribute for the forecast demand and the order demand respectively based on the period type table to obtain the reference independent demand; wherein, the forecast demand is related to the forecasted production plan within different periods, and the order demand is related to the sales information within different periods; setting the period span attribute for the forecast demand and the order demand respectively based on the period type table to obtain the reference independent demand specifically includes: when determined to be a forecast demand, determining the period type in the forecast demand, associating the period type with the period type table to automatically assign a value to the period span in the forecast demand; when determined to be an order demand, determining the period span in the order demand to be 0; obtaining the reference independent demand based on the forecast demand with the attribute settings and the order demand with the attribute settings; and Based on the period type table, a period span related attribute is added to the preset material dictionary table to obtain a reference material dictionary table. Specifically, this includes: determining the period type in the preset material dictionary table, associating the period type with the period type table, and automatically assigning values ​​to the period span in the preset material dictionary table. The data in the reference independent demand is compared with the data in the reference material dictionary table to determine the current material demand plan based on the comparison results. If the period span data in the reference independent demand is greater than the period span data in the reference material dictionary, the current material demand plan is determined to be unexecutable. The period span in the pre-set independent demand is related to the number of days for material production or procurement, and the period span in the pre-set material dictionary is related to the advance preparation time for materials.

7. A non-volatile computer storage medium storing computer-executable instructions, wherein the computer... Executable instructions are set as follows: During creation, a type table is created; where, The period type table shall include at least the period type name and the period span; Based on the period type table, a period span-related attribute is added to the preset independent demand to obtain reference independent demand. Specifically, this includes: dividing the preset independent demand into forecast demand and order demand based on different data; setting the period span attribute for the forecast demand and the order demand respectively based on the period type table to obtain the reference independent demand; wherein, the forecast demand is related to the forecasted production plan within different periods, and the order demand is related to the sales information within different periods; setting the period span attribute for the forecast demand and the order demand respectively based on the period type table to obtain the reference independent demand specifically includes: when determined to be a forecast demand, determining the period type in the forecast demand, associating the period type with the period type table to automatically assign a value to the period span in the forecast demand; when determined to be an order demand, determining the period span in the order demand to be 0; obtaining the reference independent demand based on the forecast demand with the attribute settings and the order demand with the attribute settings; and Based on the period type table, a period span related attribute is added to the preset material dictionary table to obtain a reference material dictionary table. Specifically, this includes: determining the period type in the preset material dictionary table, associating the period type with the period type table, and automatically assigning values ​​to the period span in the preset material dictionary table. The data in the reference independent demand is compared with the data in the reference material dictionary table to determine the current material demand plan based on the comparison results. If the period span data in the reference independent demand is greater than the period span data in the reference material dictionary, the current material demand plan is determined to be unexecutable. The period span in the pre-set independent demand is related to the number of days for material production or procurement, and the period span in the pre-set material dictionary is related to the advance preparation time for materials.

Images