A material management system with financial attributes
By designing a material management system with financial attributes in mining enterprises, combining three-dimensional images and financial data, a warehouse management model with financial attributes is established, which solves the problem of missing financial attributes in traditional material management and realizes precise control of material management and efficiency improvement ensures the economic benefits of the enterprise.
Patent Information
- Application Number
- CN202411126684.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-16
- Publication Date
- 2024-11-15
- Estimated Expiration
- 2044-08-16
AI Technical Summary
The material management methods of traditional mining enterprises lack comprehensive consideration of financial attributes, which leads to the problem of precise control and efficiency improvement of material assets, lacks comprehensive tracking and accurate pricing of material flows, affecting the economic benefits of enterprises.
Design a material management system with financial attributes, including material data acquisition module, financial end and material management platform. Through the combination of three-dimensional image data and financial data, a real-time three-dimensional model of warehouse management with financial attributes is established to realize material type analysis , status analysis and data statistics to generate accurate financial data tables and procurement plans.
Through three-dimensional visualization, the financial attributes of materials are displayed, management accuracy and efficiency are improved, data integrity and accuracy are ensured, and enterprises can clearly understand the financial status of materials, carefully record material flow and value changes, and ensure cost accounting accuracy and production continuity.
Smart Images

Figure CN118644191B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of mining area material management, in particular to a material management system with financial attributes. Background Art
[0002] In the daily operations of mining enterprises, the management of materials such as production equipment and spare parts is particularly critical, which is related to the efficiency and cost control of enterprise operations. Traditional material management methods focus on material quantity control and logistical support, and there are few solutions that combine financial data with material data for management.
[0003] In traditional mining enterprise material management, material handling often lacks comprehensive consideration of financial attributes, resulting in difficulties in accurate control of material assets and efficiency improvement. Existing technologies fail to effectively integrate material management with financial management, lack comprehensive tracking and accurate pricing of material flows, resulting in low material management efficiency and inaccurate inventory cost control, which in turn affects the improvement of enterprise economic benefits. Therefore, a material management system with financial attributes is proposed to address the above problems. Summary of the invention
[0004] The purpose of the present invention is to provide a material management system with financial attributes to solve the problems raised in the above background technology.
[0005] To achieve the above object, the present invention provides the following technical solutions:
[0006] A material management system with financial attributes, including:
[0007] Material data collection module; the material data collection module includes a material entry registration module and a material exit registration module; the material entry registration module collects 3D image data and basic material data of the incoming materials, and the basic material data collection includes the material name, the material entry quantity and the material entry name, and obtains the material entry data; the material exit registration module collects data on the outgoing materials and obtains the material exit data;
[0008] Financial side: The financial side includes the material purchase plan module and the material account statistics module. The material purchase plan module determines the purchase items and purchase quantities of materials according to the material purchase plan. The material account statistics module registers materials according to the purchase items and purchase quantities, and obtains the financial account data of materials.
[0009] Material management platform; the material management platform includes material model building module, material type analysis module, material status analysis module and material data statistics module;
[0010] The material model building module performs 3D modeling of the material warehouse to obtain a 3D warehouse model, divides and marks areas on the 3D warehouse model, receives material warehousing data, extracts 3D image data of the material to establish a 3D material model, plans the storage area according to the 3D material model and the material quantity, and adds the material name and storage time after the area mark of the corresponding material storage area on the 3D warehouse model to obtain a real-time 3D warehouse management model;
[0011] The material type analysis module receives the real-time 3D model of warehouse management, and performs type analysis on the materials according to the material names added after the regional markings on the real-time 3D model of warehouse management combined with the financial account data, and divides the materials into three financial attributes: on-book materials, fixed asset materials, and off-book materials. The financial attributes of the materials are marked on the regional markings of the materials in the real-time 3D model of warehouse management, and the real-time 3D model of warehouse management with financial attributes is obtained;
[0012] The material status analysis module receives the material outbound data, determines the name, quantity, and outbound item of the outbound material, and updates the real-time three-dimensional warehouse management model with financial attributes based on the name, quantity, and outbound item of the outbound material.
[0013] The material data statistics module performs data statistics on the real-time three-dimensional warehouse management model with financial attributes at set time intervals, and arranges the statistical data of each time node according to the time axis to obtain the material usage data axis. The statistical data of any two time nodes on the material usage data axis are compared to determine the consumption of each material in the corresponding time interval between the two time nodes, determine the financial attributes of the consumed materials, and generate a financial data table based on the financial attributes of the consumed materials.
[0014] As a preferred solution, on-book materials are materials that have not been shipped out and whose costs have not been written off, fixed asset materials are materials that need to be depreciated and are used for a long time, and off-book materials are materials that have actually been shipped out and whose costs have been written off, but have not yet been used in production.
[0015] As a preferred solution, when constructing a three-dimensional model of a warehouse, design drawings of the warehouse are collected, and radar image data of the interior of the warehouse is collected using a drone equipped with a radar camera. The design drawings of the warehouse are digitized to extract size, shape and layout information. The radar image data of the interior of the warehouse is denoised and filtered. The position and shape of the internal structure of the warehouse are determined based on the size and layout information in the design drawings. The basic frame structure of the warehouse is created using three-dimensional modeling software. The preprocessed radar image data is matched and fused with the basic frame structure of the warehouse. The spatial information in the radar image is mapped to the initial frame through feature recognition technology to obtain a three-dimensional model of the warehouse.
[0016] As a preferred solution, when constructing a three-dimensional model of a material, the material warehousing data is received, the three-dimensional image data of the material is extracted, the three-dimensional image data is cleaned and optimized, noise, error points and redundant information are removed, and then the size, edge, contour and surface texture features in the three-dimensional image data are extracted. According to the edge and contour features, a basic three-dimensional model of the material is established, and the texture features are mapped to the surface of the basic three-dimensional model to obtain the three-dimensional model of the material.
[0017] As a preferred solution, when planning the storage area according to the material three-dimensional model and the material quantity, the dimensional data of the material three-dimensional model is collected to determine the maximum values of the length, width and height of the material three-dimensional model, and a rectangular simulation frame is generated according to the maximum values of the length, width and height of the material three-dimensional model. The volume of the rectangular simulation frame is calculated, and the stacking volume of the incoming materials is estimated according to the quantity of incoming materials and the volume of the rectangular simulation frame. Then, the remaining areas in the warehouse three-dimensional model are summarized, and the spatial volume of the remaining areas is calculated. The area closest to the estimated stacking volume of the incoming materials is selected, and the incoming materials are stored in the area, thereby completing the planning of the storage area when the materials are put into storage.
[0018] As a preferred solution, when generating a financial data table based on the financial attributes of consumable materials, the financial attributes of the consumable materials are first determined. When the financial attributes of the materials are on-book materials, the quantity and unit price of the consumable materials are counted, and the consumption cost is calculated based on the quantity and unit price of the consumable materials. The quantity, unit price and consumption cost of the consumable materials are counted to generate an on-book material statistics table; when the financial attributes of the materials are fixed asset materials, the purchase time of the corresponding materials is determined, the use time of the materials is calculated based on the real-time time for generating the financial data table, the depreciation amount of the corresponding materials is calculated based on the depreciation rate of the materials, and a depreciation cost table of the corresponding materials is generated; when the materials are off-book materials, the quantity of the consumable materials is counted.
[0019] As a preferred solution, the material accounting statistics module receives the material depreciation cost table and the in-account material statistics table, and records the costs consumed by the depreciation cost table and the in-account material statistics table.
[0020] As a preferred solution, the material procurement planning module receives the latest real-time three-dimensional warehouse management model with financial attributes, counts the remaining quantity of each material in the warehouse, generates a material consumption data table, and sets the minimum stock of each material. When the quantity of the material is lower than the minimum stock, an alarm is generated, and the material procurement planning module produces a procurement plan based on the alarm information.
[0021] It can be seen from the technical solution provided by the present invention that the material management system with financial attributes provided by the present invention has the following beneficial effects: by establishing a real-time three-dimensional warehouse management model with financial attributes, the financial attributes of materials in the warehouse are intuitively displayed in a three-dimensional visualized form, so that management personnel can understand the value distribution and asset status of materials at a glance, and provide an accurate data basis for the cost accounting of the enterprise. The material type analysis module accurately divides materials into three financial attributes: on-book materials, fixed asset materials, and off-book materials, so that the enterprise can clearly understand the financial status of various types of materials, and can finely record the flow and value changes of materials, thereby improving the accuracy and efficiency of inventory management; through the material data collection module, comprehensive data collection of material entry and exit is realized, including three-dimensional image data and basic data, ensuring the integrity and accuracy of the data; the material model establishment module plans the storage area according to the three-dimensional model and quantity of the material, and can make the best use of the warehouse space. The material procurement planning module and the material account statistics module on the financial side, combined with the data analysis of the material management platform, can provide accurate financial account data and financial attribute classification. By clearly dividing materials into on-book materials, fixed asset materials and off-book materials, it helps enterprises to accurately calculate costs and asset depreciation. The material procurement planning module can generate alarms and formulate procurement plans based on the remaining quantity of materials in the real-time 3D model of the warehouse, ensuring the continuity of the enterprise's production and avoiding production stagnation due to material shortages. BRIEF DESCRIPTION OF THE DRAWINGS
[0022] Figure 1 This is a schematic diagram of the overall structure of a material management system with financial attributes of the present invention. DETAILED DESCRIPTION
[0023] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention.
[0024] In order to better understand the above technical solution, the above technical solution will be described in detail below in conjunction with the accompanying drawings and specific implementation methods.
[0025] like Figure 1 As shown, an embodiment of the present invention provides a material management system with financial attributes, including a material data collection module, a financial terminal and a material management platform.
[0026] In this embodiment, the material data collection module includes a material inbound registration module and a material outbound registration module;
[0027] The material entry registration module collects 3D image data and basic material data of the incoming materials. The basic material data collection includes the material name, the quantity of the incoming materials and the name of the incoming materials, and obtains the incoming material data.
[0028] The material outbound registration module collects data on outbound materials and obtains material outbound data.
[0029] In this embodiment, the financial end includes a material purchase planning module and a material entry statistics module;
[0030] The material purchase plan module determines the purchase items and purchase quantities of materials according to the material purchase plan;
[0031] The material entry statistics module registers materials according to the purchase name and purchase quantity, and obtains the financial entry data of the materials;
[0032] In this embodiment, the material management platform includes a material model building module, a material type analysis module, a material status analysis module and a material data statistics module;
[0033] The material model building module performs 3D modeling of the material warehouse to obtain a 3D warehouse model, divides and marks areas on the 3D warehouse model, receives material entry data, extracts 3D image data of the material to establish a 3D material model, plans the storage area according to the 3D material model and the material quantity, and adds the material name and storage time after the area mark of the corresponding material storage area on the 3D warehouse model to obtain a real-time 3D warehouse management model, where:
[0034] When constructing a 3D warehouse model, the design drawings of the warehouse are collected. At the same time, a drone equipped with a radar camera is used to collect radar image data inside the warehouse. The design drawings of the warehouse are digitized to extract the size, shape and layout information. The radar image data inside the warehouse is denoised and filtered. According to the size and layout information in the design drawings, the position and shape of the internal structure of the warehouse are determined. The basic framework structure of the warehouse is created using 3D modeling software. The pre-processed radar image data is matched and integrated with the basic framework structure of the warehouse. The spatial information in the radar image is mapped to the initial framework through feature recognition technology to obtain a 3D warehouse model. The 3D warehouse model can clearly present the overall spatial structure of the warehouse, help enterprises plan material storage areas more reasonably, and provide a data basis for the storage of subsequent incoming materials.
[0035] When constructing the 3D model of the material, the material warehousing data is received, the 3D image data of the material is extracted, the 3D image data is cleaned and optimized, noise, error points and redundant information are removed, and the size, edge, contour and surface texture features in the 3D image data are extracted. The basic 3D model of the material is established according to the edge and contour features, and the texture features are mapped to the surface of the basic 3D model to obtain the 3D model of the material;
[0036] When planning the storage area according to the material three-dimensional model and the material quantity, the dimension data of the material three-dimensional model is collected to determine the maximum value of the length, width and height of the material three-dimensional model. A rectangular simulation frame is generated according to the maximum value of the length, width and height of the material three-dimensional model, and the volume of the rectangular simulation frame is calculated. The stacking volume of the incoming materials is estimated according to the quantity of incoming materials and the volume of the rectangular simulation frame. Then, the remaining areas in the warehouse three-dimensional model are summarized, and the spatial volume of the remaining areas is calculated. The area closest to the estimated stacking volume of the incoming materials is selected, and the incoming materials are stored in the area, completing the planning of the storage area when the materials are entered into the warehouse;
[0037] The material type analysis module receives the real-time 3D model of warehouse management, and performs type analysis on the materials according to the material names added after the regional markings on the real-time 3D model of warehouse management combined with the financial account data, and divides the materials into three financial attributes: on-book materials, fixed asset materials, and off-book materials. The financial attributes of the materials are marked on the regional markings of the materials in the real-time 3D model of warehouse management, and the real-time 3D model of warehouse management with financial attributes is obtained;
[0038] Furthermore, on-book materials are materials that have not been shipped out and whose costs have not been written off, fixed asset materials are materials that need to be depreciated and are used for a long time, and off-book materials are materials that have actually been shipped out and whose costs have been written off, but have not yet been used in production;
[0039] The material status analysis module receives the material outbound data, determines the name, quantity, and outbound item of the outbound material, and updates the real-time three-dimensional warehouse management model with financial attributes based on the name, quantity, and outbound item of the outbound material.
[0040] The material data statistics module performs data statistics on the real-time three-dimensional warehouse management model with financial attributes at the set time interval, and arranges the statistical data of each time node according to the time axis to obtain the material usage data axis, compares the statistical data of any two time nodes on the material usage data axis, determines the consumption of each material in the corresponding time interval between the two time nodes, determines the financial attributes of the consumed materials, and generates a financial data table based on the financial attributes of the consumed materials; among which:
[0041] When generating a financial data table based on the financial attributes of consumable materials, first determine the financial attributes of the consumable materials. When the financial attributes of the materials are on-book materials, count the quantity and unit price of the consumable materials, and calculate the consumption cost based on the quantity and unit price of the consumable materials. Then count the quantity, unit price and consumption cost of the consumable materials to generate an on-book material statistics table. When the financial attributes of the materials are fixed asset materials, determine the purchase time of the corresponding materials, calculate the use time of the materials based on the real time when the financial data table is generated, calculate the depreciation amount of the corresponding materials based on the depreciation rate of the materials, and generate a depreciation cost table for the corresponding materials. When the materials are off-book materials, count the quantity of the consumable materials.
[0042] In this embodiment, the material accounting statistics module receives the material depreciation cost table and the in-account material statistics table, and records the costs consumed by the depreciation cost table and the in-account material statistics table.
[0043] In this embodiment, the material procurement planning module receives the latest real-time three-dimensional warehouse management model with financial attributes, counts the remaining quantity of each material in the warehouse, generates a material consumption data table, and sets the minimum stock of each material. When the quantity of the material is lower than the minimum stock, an alarm is generated, and the material procurement planning module produces a procurement plan based on the alarm information.
[0044] The material management method will be further described in detail below in combination with the above system:
[0045] 1. Material data collection
[0046] The material entry registration module is used to collect 3D image data and basic material data of the incoming materials, where the basic material data includes the material name, the quantity of the incoming materials and the name of the incoming materials, and obtain the incoming material data;
[0047] The material outbound registration module is used to collect data on outbound materials and obtain material outbound data;
[0048] 2. Financial Operation
[0049] The material procurement plan module specifies the procurement items and quantities of materials according to the material procurement plan;
[0050] The material entry statistics module registers materials according to the purchase name and purchase quantity, and obtains the financial entry data of the materials;
[0051] 3. Material management platform processing
[0052] The material model building module performs three-dimensional modeling on the material warehouse to obtain a three-dimensional warehouse model;
[0053] Collect warehouse design drawings and use drones equipped with radar cameras to collect radar image data inside the warehouse;
[0054] Digitalize the warehouse design drawings to extract size, shape and layout information; perform denoising and filtering on the radar image data inside the warehouse;
[0055] Determine the location and shape of the warehouse's internal structure based on the dimensions and layout information in the design drawings, and use 3D modeling software to create the warehouse's basic framework structure;
[0056] The pre-processed radar image data is matched and fused with the basic frame structure of the warehouse. The spatial information in the radar image is mapped to the initial frame through feature recognition technology to obtain a three-dimensional warehouse model that can clearly present the overall spatial structure of the warehouse.
[0057] Divide and mark areas on the warehouse 3D model, receive material warehousing data, extract 3D image data of materials and establish 3D model of materials;
[0058] Receive material warehousing data, extract the 3D image data of the material, clean and optimize the 3D image data, and remove noise, error points and redundant information;
[0059] Extract the size, edge, contour and surface texture features from the 3D image data, establish a basic 3D model of the material based on the edge and contour features, map the texture features to the surface of the basic 3D model, and obtain a 3D model of the material;
[0060] Plan storage areas based on material 3D models and material quantities;
[0061] Collect dimensional data of the three-dimensional model of the material, determine the maximum values of the length, width and height of the three-dimensional model of the material, generate a rectangular simulation frame according to the maximum values of the length, width and height of the three-dimensional model of the material, and calculate the volume of the rectangular simulation frame;
[0062] Estimate the stacking volume of incoming materials based on the quantity of incoming materials and the volume of the rectangular simulation box, then summarize the remaining areas in the three-dimensional warehouse model, calculate the spatial volume of the remaining areas, select the area closest to the estimated stacking volume of incoming materials, and store the incoming materials in this area;
[0063] The material type analysis module receives the real-time 3D model of warehouse management, and performs type analysis on the materials according to the material names added after the regional markings on the real-time 3D model of warehouse management combined with the financial account data, and divides the materials into three financial attributes: on-book materials, fixed asset materials, and off-book materials. The financial attributes of the materials are marked on the regional markings of the materials in the real-time 3D model of warehouse management, and the real-time 3D model of warehouse management with financial attributes is obtained;
[0064] The material status analysis module receives the material outbound data, determines the name, quantity, and outbound item of the outbound material, and updates the real-time three-dimensional warehouse management model with financial attributes based on the name, quantity, and outbound item of the outbound material.
[0065] The material data statistics module performs data statistics on the real-time three-dimensional warehouse management model with financial attributes at the set time interval, and arranges the statistical data of each time node according to the time axis to obtain the material usage data axis, compares the statistical data of any two time nodes on the material usage data axis, determines the consumption of each material in the corresponding time interval between the two time nodes, determines the financial attributes of the consumed materials, and generates a financial data table based on the financial attributes of the consumed materials;
[0066] When the financial attribute of the material is an in-account material, the quantity and unit price of the consumed materials are counted, and the consumption cost is calculated based on the quantity and unit price of the consumed materials. The quantity, unit price and consumption cost of the consumed materials are counted to generate an in-account material statistics table;
[0067] When the financial attribute of the material is a fixed asset material, determine the purchase time of the corresponding material, calculate the use time of the material according to the real time of generating the financial data table, calculate the depreciation amount of the corresponding material according to the depreciation rate of the material, and generate the depreciation cost table of the corresponding material;
[0068] When the material is off-book, the quantity of consumed materials is counted;
[0069] 4. Financial Accounting and Procurement Plan
[0070] The material accounting statistics module receives the material depreciation cost table and the material statistics table in the account, and records the costs consumed by the depreciation cost table and the material statistics table in the account;
[0071] The material procurement planning module receives the latest real-time three-dimensional warehouse management model with financial attributes, counts the remaining quantity of each material in the warehouse, generates a material consumption data table, and sets the minimum holding quantity of each material. When the quantity of the material is lower than the minimum holding quantity, an alarm is generated, and the material procurement planning module produces a procurement plan based on the alarm information.
[0072] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.
Claims
1. A material management system with financial attributes, characterized by: include: Material data collection module; The material data collection module includes a material entry registration module and a material exit registration module; The material entry registration module collects three-dimensional image data and basic material data of the materials entering the warehouse, and the basic material data collection includes the material name, the quantity of materials entering the warehouse, and the name of the materials entering the warehouse, so as to obtain the material entry data; the material exit registration module collects data of the materials leaving the warehouse, so as to obtain the material exit data; Financial end; the financial end includes a material purchase plan module and a material account statistics module; the material purchase plan module determines the purchase name and purchase quantity of the material according to the material purchase plan; the material account statistics module registers the material according to the purchase name and purchase quantity of the material to obtain the financial account data of the material; Material management platform; the material management platform includes a material model building module, a material type analysis module, a material status analysis module and a material data statistics module; The material model building module performs three-dimensional modeling of the material warehouse to obtain a three-dimensional warehouse model, and divides and marks regions on the three-dimensional warehouse model, receives material warehousing data, extracts three-dimensional image data of the material to establish a three-dimensional material model, plans storage areas according to the three-dimensional material model and material quantity, and adds material names and storage times after the region marks corresponding to the material storage areas on the three-dimensional warehouse model to obtain a real-time three-dimensional model for warehouse management; The material type analysis module receives the real-time 3D model of warehouse management, and performs type analysis on the materials according to the material names added after the regional markings on the real-time 3D model of warehouse management combined with the financial account data, and divides the materials into three financial attributes: on-book materials, fixed asset materials, and off-book materials. The financial attributes of the materials are marked on the regional markings of the materials in the real-time 3D model of warehouse management, and the real-time 3D model of warehouse management with financial attributes is obtained; The material status analysis module receives the material outbound data, determines the name, quantity, and outbound item of the outbound material, and updates the real-time three-dimensional warehouse management model with financial attributes according to the name, quantity, and outbound item of the outbound material; The material data statistics module performs data statistics on the real-time three-dimensional warehouse management model with financial attributes at set time intervals, and arranges the statistical data of each time node according to the time axis to obtain the material usage data axis, compares the statistical data of any two time nodes on the material usage data axis, determines the consumption of each material in the time interval corresponding to the two time nodes, determines the financial attributes of the consumed materials, and generates a financial data table according to the financial attributes of the consumed materials; The on-book materials are materials that have not been shipped out and whose costs have not been written off, fixed asset materials are materials that need to be depreciated and are used for a long time, and off-book materials are materials that have actually been shipped out and whose costs have been written off, but have not yet been used in production; When constructing the three-dimensional model of the warehouse, the design drawings of the warehouse are collected, and at the same time, radar image data of the interior of the warehouse is collected by using a drone equipped with a radar camera, the design drawings of the warehouse are digitized, and the size, shape and layout information are extracted. The radar image data of the interior of the warehouse is denoised and filtered, and the position and shape of the internal structure of the warehouse are determined according to the size and layout information in the design drawings. The basic frame structure of the warehouse is created using three-dimensional modeling software, and the pre-processed radar image data is matched and fused with the basic frame structure of the warehouse. The spatial information in the radar image is mapped to the initial frame through feature recognition technology to obtain the three-dimensional model of the warehouse; When constructing the three-dimensional model of the material, the material storage data is received, the three-dimensional image data of the material is extracted, the three-dimensional image data is cleaned and optimized, noise, error points and redundant information are removed, and the size, edge, contour and surface texture features in the three-dimensional image data are extracted, and the basic three-dimensional model of the material is established according to the edge and contour features, and the texture features are mapped to the surface of the basic three-dimensional model to obtain the three-dimensional model of the material; When planning the storage area according to the material three-dimensional model and the material quantity, the dimension data of the material three-dimensional model is collected to determine the maximum value of the length, width and height of the material three-dimensional model. A rectangular simulation frame is generated according to the maximum value of the length, width and height of the material three-dimensional model, and the volume of the rectangular simulation frame is calculated. The stacking volume of the incoming materials is estimated according to the quantity of incoming materials and the volume of the rectangular simulation frame. Then, the remaining areas in the warehouse three-dimensional model are summarized, and the spatial volume of the remaining areas is calculated. The area closest to the estimated stacking volume of the incoming materials is selected, and the incoming materials are stored in the area, completing the planning of the storage area when the materials are entered into the warehouse; When generating a financial data table based on the financial attributes of consumable materials, first determine the financial attributes of the consumable materials. When the financial attributes of the materials are on-book materials, count the quantity and unit price of the consumable materials, and calculate the consumption cost based on the quantity and unit price of the consumable materials. Count the quantity, unit price and consumption cost of the consumable materials to generate an on-book material statistics table. When the financial attributes of the materials are fixed asset materials, determine the purchase time of the corresponding materials, calculate the use time of the materials based on the real time of generating the financial data table, calculate the depreciation amount of the corresponding materials based on the depreciation rate of the materials, and generate a depreciation cost table for the corresponding materials. When the materials are off-book materials, count the quantity of the consumable materials. The material accounting statistics module receives the material depreciation cost table and the material statistics table in the account, and records the cost consumed by the depreciation cost table and the material statistics table in the account; The material procurement planning module receives the latest real-time three-dimensional warehouse management model with financial attributes, counts the remaining quantity of each material in the warehouse, generates a material consumption data table, and sets the minimum stock of each material. When the quantity of the material is lower than the minimum stock, an alarm is generated, and the material procurement planning module produces a procurement plan based on the alarm information.
