Manufacturing enterprise MRP statistical method

The invention belongs to the technical field of production and manufacturing, and particularly relates to a manufacturing enterprise MRP statistical method. First, three data tables are created, namely, an MRP main table, a detailed table 1, and a detailed table 2. The detailed table 1 is used for storing requirements and operation of products, and the detailed table 2 is used for storing requirements and operation of raw materials. First, work order product shortage requirements and sales order requirements are imported to the detailed table 1; then, BOM decomposition operation is performed on the detailed table 1 to obtain a product requirement list; next, work order raw material shortage requirements and a raw material requirement list which is obtained through conversion of the product requirement list in the detailed table 1 are imported to the detailed table 2; and traversal operation is performed on the detailed tables to obtain a raw material requirement list.