Engineering cost material automatic accounting system and method

Abstract

The invention discloses a project cost material automatic accounting system and method. The system comprises a data input unit, a data acquisition unit, a data transmission unit, a data storage unit, a data processing unit, an automatic accounting unit and a monitoring display unit. Wherein the data input unit is used for manually inputting the quantity of engineering materials by a worker and carrying out statistics to obtain a statistical value of the quantity of the materials; and the data acquisition unit is used for performing real-time acquisition on data information generated in the automatic accounting process of the engineering cost material. The invention belongs to the technical field of engineering management. Key data of engineering quantity, environment temperature, date and material unit price are collected in real time, the data are verified and abnormal alarm is performed through the intelligent analysis and judgment module, and once data abnormity or error is found, the system can immediately give an alarm to remind related personnel to process in time, so that the accuracy of the data is ensured.

Description

Technical Field

[0001] The present invention relates to the technical field of engineering management, and more specifically discloses an automatic accounting system and method for engineering cost materials. Background Art

[0002] In construction projects, material costs are a core component of project costs, and their accuracy and effectiveness are directly related to the project's economic benefits and cost control. However, traditional automated accounting relies on accurate data input. In practice, data entry errors are prone to occur due to human factors, including negligence, fatigue, lack of professional skills, or inadequate training. Failure to promptly review and correct erroneous data can easily lead to inaccurate accounting results. Summary of the Invention

[0003] Purpose of the invention: The purpose of the present invention is to solve the problem that traditional automatic accounting relies on accurate data input. In actual operation, due to human factors including: negligence, fatigue, lack of professional ability or inadequate training of data entry personnel, data input is prone to errors, and erroneous data is not reviewed and corrected in time, which can easily lead to errors in accounting results.

[0004] To solve the above technical problems, according to one aspect of the present invention, more specifically, an automatic accounting system for construction cost materials includes: a data input unit, a data acquisition unit, a data transmission unit, a data storage unit, a data processing unit, an automatic accounting unit, and a monitoring and display unit; wherein: Data input unit: used for staff to manually input the quantity of engineering materials and perform statistics to obtain the statistical value of the material quantity; Data acquisition unit: used for real-time collection of data information generated during the automatic accounting process of engineering cost materials; Data transmission unit: used for real-time transmission of information data collected by the data collection unit; Data storage unit: used to store the information data transmitted in real time by the data transmission unit; Data processing unit: used to process and analyze the information data stored in the data storage unit and obtain the processing and analysis results. At the same time, when the analysis result obtained by the analysis and judgment module is an abnormal result, an alarm is issued to the background terminal, and the obtained processing and analysis results are forwarded to the monitoring display unit; Automatic accounting unit: used to automatically calculate the material costs in the project cost; Monitoring and display unit: used to display the information data stored in the data storage unit, the analysis results of the data processing unit and the accounting results of the automatic accounting unit in real time on the terminal screen. At the same time, when the analysis result obtained by the analysis and judgment module is an abnormal result, the staff will be arranged to review and correct the data manually entered by the data input unit.

[0005] Furthermore, the data acquisition unit includes: an engineering quantity acquisition module, a temperature acquisition module, a date acquisition module and a unit price acquisition module; Engineering quantity collection module: used to collect the data information of engineering completion quantity in real time during the construction process; Temperature acquisition module: used to collect real-time ambient temperature data information of the construction area; Time collection module: used to collect working time data information in real time during the construction process; Unit price collection module: used to collect the unit price data of engineering materials used in the construction process in real time.

[0006] Furthermore, the data processing unit includes: a data acquisition module, an analysis and judgment module, an abnormality alarm module and a result forwarding module; Data acquisition module: used for real-time acquisition of information data stored in the data storage unit; Analysis and judgment module: used to analyze and judge the information data obtained by the data acquisition module, so as to obtain the results of the analysis and judgment; Abnormal alarm module: used to send an alarm to the terminal device when the result obtained by the analysis and judgment module is abnormal; Result forwarding module: used to forward the results analyzed and judged by the analysis and judgment module to the monitoring and display unit.

[0007] Furthermore, the monitoring and display unit includes: a data receiving module, a data display module and an active verification module; Data receiving module: used for receiving the information data stored in the data storage unit, the analysis results of the data processing unit and the accounting results of the automatic accounting unit in real time; Data display module: used to display the information data received by the data receiving module on the background terminal display screen; Active verification module: When the analysis result obtained by the analysis and judgment module is an abnormal result, it is used to arrange staff to review and correct the data manually entered by the data input unit.

[0008] Furthermore, the analysis and judgment module can obtain the project completion amount, the ambient temperature of the construction area, and the working time information data during the construction process from the data acquisition module, and obtain the standard material quantity through analysis of the above acquired data: in, is the standard material quantity, The number of days for actual construction work. For the The amount of work completed in a day, The material consumption quota, is the total number of days since the construction started. is the total construction period of the project, For the The average temperature of the construction area on that day, The most comfortable standard temperature for workers to work in. is the conversion factor.

[0009] Furthermore, the analysis and judgment module can obtain the project completion amount and the ambient temperature information data of the construction area during the construction process from the data acquisition module, and obtain the fluctuation coefficient of the material quantity through the above acquired data analysis: Furthermore, the statistical values ​​of the materials manually input by the staff through the data input unit are verified, if: This means that by counting the number of materials input by the staff, the statistical value of the number of materials is obtained for verification, and the statistical value is within a reasonable range, among which, is the fluctuation coefficient of material quantity, For The average amount of work completed within a day is For The minimum amount of work completed within a day, For The maximum amount of work completed within a day, The most comfortable standard temperature for workers to work in. For The minimum average temperature in the construction area within a day, For The maximum average temperature in the construction area within a day, is the minimum amount of material, is the maximum amount of material, is the standard material quantity, The quantity data of materials input by the staff is counted to obtain the statistical value of the material quantity.

[0010] Furthermore, the analysis and judgment module can obtain the working time and unit price information of the construction materials during the construction process from the data acquisition module, and analyze the obtained data to obtain the material cost: in, For material costs, To count the quantity data of materials input by staff and obtain the statistical value of the quantity of materials, is the unit price of materials on that day, is the correction coefficient of the material unit price, The number of days for actual construction work. For the The unit price of materials per day, For The highest unit price of materials within a day, For The lowest material unit price within a day, The total number of days in the past year, For the past year, The unit price of materials per day, The average unit price of materials in the past year.

[0011] According to another aspect of the present invention, a method for automatic accounting of construction cost materials is provided. The method is implemented based on the above-mentioned automatic accounting system for construction cost materials and specifically includes the following steps: S1. Data input: The staff manually inputs the quantity of materials for construction and counts the data to obtain the statistical value of the material quantity; S2. Data collection: Real-time collection of engineering quantity, ambient temperature, engineering time and material unit price data; S3. Data transmission: Transmit and store the collected data information, and analyze and judge the stored data to obtain the analysis results; S4. Analysis and judgment: If the analysis and judgment results are normal, the project material cost will be automatically calculated. If the analysis and judgment results are abnormal, personnel will be arranged to review and correct the manually entered material quantity data. S5. Monitoring and display: Manually input data, analysis and judgment, and engineering cost calculation results are displayed on the screen of the terminal device to facilitate user query and monitoring.

[0012] The beneficial effects of the automatic accounting system and method for construction cost materials disclosed herein are as follows: by collecting key data such as construction quantity, ambient temperature, date, and material unit price in real time, and verifying and announcing abnormalities through an intelligent analysis and judgment module, the system immediately issues an alarm upon detecting data anomalies or errors, prompting relevant personnel to promptly address them, thereby ensuring data accuracy. Simultaneously, by introducing correction coefficients for individual material units, the material unit price is corrected, further improving the accuracy and reliability of the accounting. Furthermore, the system is capable of real-time monitoring and display, allowing users to query and monitor accounting results at any time, thereby effectively improving the efficiency and level of construction cost management and reducing project cost risks. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] The present invention will be further described in detail below with reference to the accompanying drawings and specific implementation methods.

[0014] Figure 1 Schematic diagram of the system principle; Figure 2 Schematic diagram of the method flow chart. DETAILED DESCRIPTION

[0015] The present invention will be described in detail below with reference to the accompanying drawings and in combination with embodiments. It should be noted that, unless there is a conflict, the embodiments and features in the embodiments of the present application can be combined with each other.

[0016] According to one aspect of the present invention, Figure 1-2 As shown, a system and method for automatic accounting of construction cost materials are provided. First, the staff manually inputs the quantity of materials for construction, and the number of materials manually input by the staff is counted through the data input unit to obtain the statistical value of the material quantity.

[0017] Then, the engineering quantity collection module, temperature collection module, date collection module and unit price collection module are used to collect the engineering completion quantity, ambient temperature of the construction area, working hours and unit price data of the engineering materials used in the construction process in real time.

[0018] Then, the collected data is transmitted to the data storage unit in real time through the data transmission unit, and then the information data is obtained from the data storage unit through the data acquisition module in the data analysis unit. Further, the obtained information data is processed and analyzed by the analysis and judgment module and the analysis results are forwarded to the monitoring and display unit. When the analysis and judgment results of the analysis and judgment module show abnormal conditions, the abnormal alarm module will be triggered to alarm the terminal device.

[0019] Afterwards, the data receiving module in the monitoring and display unit can receive the information data stored in the data storage unit, the analysis results of the data processing unit and the accounting results of the automatic accounting unit in real time, and display the received information data on the terminal display screen through the data display module. At the same time, when the result analyzed by the analysis and judgment module is an abnormal result, the staff is arranged to review and correct the data manually entered by the data input unit and re-enter the data manually.

[0020] The analysis and judgment module can obtain the project completion volume, the ambient temperature of the construction area, and the working time information data during the construction process from the data acquisition module, and analyze the above data to obtain the standard material quantity: in, is the standard material quantity, The number of days for actual construction work. For the The amount of work completed in a day, The material consumption quota, The total number of days from the start of construction to the present, including actual construction days and rest days. is the total construction period of the project,

[0021] For the The average temperature of the construction area on that day, The most comfortable standard temperature for workers is 23℃. is the conversion coefficient, and its value is 0.85. During the data collection process, the actual number of days for construction Steel consumption quota , the total number of days since the construction started , the total construction period of the project , , , therefore, .

[0022] The analysis and judgment module can obtain the project completion volume and the ambient temperature information data of the construction area during the construction process from the data acquisition module, and analyze the above acquired data to obtain the fluctuation coefficient of the material quantity: Furthermore, the statistical values ​​of the materials manually input by the staff through the data input unit are verified, if: This means that by counting the number of materials input by the staff, the statistical value of the number of materials is obtained for verification, and the statistical value is within a reasonable range. , it means that by counting the number of materials input by the staff, the statistical value of the material quantity is obtained for verification. If the statistical value exceeds the reasonable range, the material quantity data information entered by the staff is incorrect, which will trigger the abnormal alarm module to alarm. At the same time, it will trigger the active verification module to arrange the staff to review and correct the data manually entered by the data input unit. Among them, is the fluctuation coefficient of material quantity, For The average amount of work completed within a day is For The minimum amount of work completed within a day, For The maximum amount of work completed within a day, The most comfortable standard temperature for workers to work in. For The minimum average temperature in the construction area within a day, For The maximum average temperature in the construction area within a day, is the minimum amount of material, is the maximum amount of material, is the standard material quantity, To collect statistics on the quantity of materials input by the staff, the statistical value of the quantity of materials is obtained. The average amount of work completed within a day ,exist The maximum and minimum quantities of work completed within a day are: 、 ,exist The maximum and minimum average temperatures in the construction area during the day are: 、 , therefore, , , , ,Through verification, the statistical values ​​are within a reasonable range.

[0023] The analysis and judgment module can obtain the working time and unit price information of engineering materials during the construction process from the data acquisition module, and analyze the above data to obtain the material cost: in, For material costs, To count the quantity data of materials input by staff and obtain the statistical value of the quantity of materials, is the unit price of materials on that day, is the correction coefficient of the material unit price, The number of days for actual construction work. For the The unit price of materials per day, For The highest unit price of materials within a day, For The lowest material unit price within a day, is the total number of days in the past year, For the past year, The unit price of materials per day, The average unit price of materials in the past year. It should be noted that industry associations or government departments will regularly release market price information for engineering materials. These prices are usually based on market research and statistical analysis, and are highly authoritative and of reference value. They can be used as the unit price of materials in this invention. ,exist The highest and lowest unit prices of steel products within a certain period of time are: 、 , the total number of days in the past year , , therefore, , the unit price of steel on that day , It should be noted that due to changes in market supply and demand, changes in material production costs, circulation links and material supply systems, material unit prices will fluctuate, which in turn will affect the accuracy of accounting. By correcting the material unit prices, the impact of material unit price fluctuations on accounting can be reduced and the accuracy of accounting can be improved.

[0024] The above-described embodiment merely represents one embodiment of the present invention. While the description is relatively specific and detailed, it should not be construed as limiting the scope of the present invention. It should be noted that a person skilled in the art may make various modifications and improvements without departing from the spirit of the present invention, and these modifications and improvements fall within the scope of protection of the present invention. Therefore, the scope of protection of the present invention shall be determined by the appended claims.

Claims

1. An automatic accounting system for construction cost materials, characterized in that: include: Data input unit, data acquisition unit, data transmission unit, data storage unit, data processing unit, automatic accounting unit and monitoring display unit; wherein: Data input unit: used for workers to manually input the quantity of engineering materials and perform statistics to obtain the statistical value of the material quantity; Data acquisition unit: used for real-time acquisition of data information generated during the automatic accounting process of engineering cost materials; Data transmission unit: used for real-time transmission of information data collected by the data collection unit; Data storage unit: used to store the information data transmitted in real time by the data transmission unit; Data processing unit: used to process and analyze the information data stored in the data storage unit and obtain the processing and analysis results. When the result obtained by the analysis and judgment module is an abnormal result, an alarm is issued to the background terminal, and the obtained processing and analysis results are forwarded to the monitoring display unit; Automatic accounting unit: used to automatically calculate the material costs in the project cost; Monitoring and display unit: used to display the information data stored in the data storage unit, the analysis results of the data processing unit and the accounting results of the automatic accounting unit in real time on the terminal screen. At the same time, when the analysis result obtained by the analysis and judgment module is an abnormal result, the staff is arranged to review and correct the data manually input by the data input unit.

2. The automatic accounting system for construction cost materials according to claim 1 is characterized by: The data collection unit includes: an engineering quantity collection module, a temperature collection module, a date collection module and a unit price collection module; Engineering quantity collection module: used to collect the data information of engineering completion quantity in real time during the construction process; Temperature collection module: used to collect environmental temperature data information of the construction area in real time; Time collection module: used to collect working time data information in real time during the construction process; Unit price collection module: used to collect the unit price data of engineering materials used in the construction process in real time.

3. The automatic accounting system for construction cost materials according to claim 2 is characterized by: The data processing unit includes: a data acquisition module, an analysis and judgment module, an abnormality alarm module and a result forwarding module; Data acquisition module: used for real-time acquisition of information data stored in the data storage unit; Analysis and judgment module: used to analyze and judge the information data obtained by the data acquisition module, so as to obtain the results of the analysis and judgment; Abnormal alarm module: used to send an alarm to the terminal device when the result obtained by the analysis and judgment module is abnormal; Result forwarding module: used to forward the results analyzed and judged by the analysis and judgment module to the monitoring and display unit.

4. The automatic accounting system for construction cost materials according to claim 3 is characterized by: The monitoring display unit includes: a data receiving module, a data display module and an active verification module; Data receiving module: used for receiving in real time the information data stored in the data storage unit, the analysis results of the data processing unit and the accounting result information of the automatic accounting unit; Data display module: used to display the information data received by the data receiving module on the background terminal display screen; Active verification module: when the result obtained by the analysis and judgment module is an abnormal result, it is used to arrange staff to review and correct the data manually input by the data input unit.

5. The automatic accounting system for construction cost materials according to claim 4 is characterized by: The analysis and judgment module can obtain the project completion amount, the ambient temperature of the construction area and the working time information data during the construction process from the data acquisition module, and obtain the standard material quantity through the above acquired data analysis: in, is the standard material quantity, is the number of days actually spent on construction. For the The amount of work completed in a day, The material consumption quota is is the total number of days since the construction started. is the total construction period of the project, For the The average temperature of the construction area on that day, The standard temperature that is most comfortable for workers to work is preset. is the conversion factor.

6. The automatic calculation system for construction cost materials according to claim 5 is characterized by: The analysis and judgment module can obtain the project completion amount and the ambient temperature information data of the construction area during the construction process from the data acquisition module, and obtain the fluctuation coefficient of the material quantity through the above acquired data analysis: Furthermore, the statistical values ​​of the materials manually input by the staff through the data input unit are verified, if: This means that by counting the number of materials input by the staff, the statistical value of the number of materials is verified and the statistical value is within a reasonable range, among which, is the fluctuation coefficient of material quantity, For The average amount of work completed within a day is For The minimum amount of work completed within a day. For The maximum amount of work completed within a day, The standard temperature that is most comfortable for workers to work is preset. For The minimum average temperature in the construction area within a day, For The maximum average temperature in the construction area within a day, is the minimum value of the material quantity, is the maximum amount of material, is the standard material quantity, The quantity data of materials input by the staff is counted to obtain the statistical value of the material quantity.

7. The automatic accounting system for construction cost materials according to claim 6 is characterized by: The analysis and judgment module can obtain the working time and unit price information data of the engineering materials during the engineering construction process from the data acquisition module, and obtain the material cost through the analysis of the above acquired data: in, For material costs, To count the quantity data of materials input by the staff and obtain the statistical value of the quantity of materials, is the unit price of materials on that day, is the correction factor of the material unit price, is the number of days actually spent on construction. For the The material price per day, For The highest material unit price within a day, For The lowest material unit price within a day, is the total number of days in the past year, For the past year, The material price per day, The average unit price of materials in the past year.

8. A method for automatically calculating construction cost materials, characterized in that: The method is implemented based on an automatic accounting system for construction cost materials according to any one of claims 1 to 7, and specifically comprises the following steps: S1. Data input: The staff manually inputs the quantity of materials for construction and counts the data to obtain the statistical value of the material quantity; S2. Data collection: real-time collection of engineering quantity, ambient temperature, engineering time and material unit price data information; S3, data transmission: transmit and store the collected data information, and analyze and judge the stored data to obtain the analysis results; S4. Analysis and judgment: When the analysis and judgment results are normal, the cost of engineering materials is further automatically calculated. When the analysis and judgment results are abnormal, personnel are arranged to review and correct the manually input material quantity data; S5. Monitoring and display: Manually input data, analysis and judgment, and engineering cost calculation results are displayed on the screen of the terminal device, which is convenient for users to query and monitor.

Images