Methods, devices, equipment, and media for obtaining hourly rates for construction machinery

By constructing a master data table for equipment, a sub-table for key components, and a sub-table for operating parameters, the system achieves real-time synchronization and unified management of multi-source parameters for construction machinery hourly rates. It automatically matches depreciation and repair cost models, solving the problems of data fragmentation and manual selection bias in the calculation of construction machinery hourly rates, and generating accurate and traceable hourly rate results.

CN123071084APending Publication Date: 2026-11-10POWERCHINA ZHONGNAN ENG
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202611594606.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2026-10-15
Publication Date
2026-11-10

AI Technical Summary

Technical Problem

In existing technologies, the calculation of construction machinery hourly rates relies on manual selection, and the fragmented data from multiple sources makes it difficult to adapt to modern digital cost management of engineering projects. This results in biased selection of calculation models and low efficiency. Furthermore, component maintenance data is separated from equipment quota data, leading to incomplete calculation basis and difficulty in tracing the source.

Method used

By constructing a master data table for equipment, a sub-table for key components, and a sub-table for operating parameters, real-time synchronization and unified management of multi-source parameters are achieved based on equipment coding. The sub-table for preset calculation rules is used to automatically match the target depreciation cost model and repair cost model, generating accurate and traceable hourly cost results.

Benefits of technology

It achieves real-time synchronization and unified management of multi-source parameters, solves the data silo problem, improves computing efficiency, generates accurate and traceable hourly fee results, and avoids the bias caused by manual selection.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN123071084A_ABST
    Figure CN123071084A_ABST
Patent Text Reader

Abstract

This application discloses a method, apparatus, equipment, and medium for obtaining hourly rates for construction machinery, relating to the field of data processing technology. The method includes constructing a master data table for the target construction equipment, a sub-table for key components, and a sub-table for operating parameters. The master data table includes equipment category, asset attributes, and technical characteristics. Based on the equipment category, asset attributes, and technical characteristics, a target depreciation cost model and a target repair cost model for the target construction equipment are obtained through a sub-table of preset calculation rules. Based on the master data table, the sub-table for key components, and the sub-table for operating parameters, the hourly rate is obtained through the target repair cost model and the target depreciation cost model. This application enables unified management of multi-source parameters and accurate matching of depreciation cost models and repair cost models, ultimately generating accurate and traceable hourly rates.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to a method, apparatus, equipment and medium for obtaining hourly rates for construction machinery. Background Technology

[0002] The hourly rate of construction machinery is a core technical and economic indicator for the preparation of budget estimates for hydropower, municipal, and transportation projects. Its calculation accuracy directly determines the accuracy of the project cost documents.

[0003] In existing technologies, the multi-source data required for hourly cost calculation is scattered across heterogeneous systems such as ERP, equipment management systems, and cost estimation software, with varying data formats and update frequencies. As engineering construction scales up and equipment becomes larger and more specialized, existing technologies suffer from drawbacks such as reliance on manual selection of calculation models, fragmentation of component maintenance data from equipment quota data, and reliance on file-level import / export between systems. These shortcomings make them inadequate for meeting the technical requirements of modern digital cost management in engineering projects. Based on the above problems, there is an urgent need for a method, device, equipment, medium and product for obtaining construction machinery hourly rates that can integrate multi-source system parameters. Summary of the Invention

[0004] The purpose of this application is to provide a method, device, equipment and medium for obtaining hourly rates of construction machinery, which can realize real-time synchronization and unified management of multi-source parameters, as well as intelligent matching of depreciation cost model and repair cost model, and finally generate accurate and traceable hourly rate results.

[0005] To achieve the above objectives, this application provides the following solution: Firstly, this application provides a method for obtaining hourly rates for construction machinery, including: Construct a master data table, a key component sub-table, and a working condition parameter sub-table for the target construction equipment; wherein, the master data table, the key component sub-table, and the working condition parameter sub-table all include equipment codes and are interconnected according to the equipment codes, and the master data table also includes equipment category, asset attributes, and technical characteristics; Based on the equipment code, the equipment category, asset attribute, and technical characteristics of the target construction equipment in the equipment master data table are obtained. Then, based on the equipment category, asset attribute, and technical characteristics, a target depreciation cost model and a target repair cost model for the target construction equipment are obtained through a preset calculation rule sub-table. The preset calculation rule sub-table indicates the mapping relationship between the equipment category, asset attribute, technical characteristics, and the preset depreciation cost model and preset repair cost model. The target depreciation cost model is one item in the preset depreciation cost model, and the target repair cost model is one item in the preset repair cost model. Based on the equipment master data table, the key component sub-table, and the operating condition parameter sub-table, the hourly rate is obtained through the target repair cost model and the target depreciation cost model; wherein, the hourly rate includes depreciation cost and repair cost.

[0006] Optionally, the hourly rate may also include one or more of the following: installation and dismantling costs, on-board labor costs, and power and fuel costs; The equipment master data table also includes equipment name, specifications, manufacturer, purchase date, equipment budget price, residual value rate, service life in machine hours, economic service life in machine hours, annual discount rate, depreciation period, expected return on capital, financial recovery period of equipment investment, repair rate, cost of one major repair and number of major repairs per service life in machine hours, recurring repair cost coefficient, installation and dismantling rate, cost of one installation and dismantling, average number of installations and dismantlings per year, daily equipment maintenance cost, rated power and rated hourly productivity of equipment, and identification of large machinery equipment; The key component sub-table also includes component code, component name, component purchase cost, interval workload, component rated hourly productivity, and component category code; The working condition parameter sub-table also includes load factor, fuel type, annual working hours, current actual workload, quota on-machine man-hours, labor budget unit price, quota power fuel consumption and power fuel budget unit price; The process of obtaining hourly rates based on the equipment master data table, the key component sub-table, and the operating condition parameter sub-table through the target repair cost model and the target depreciation cost model includes: Based on the target depreciation model, the depreciation expense is obtained from the equipment master data table, the key component sub-table, and the operating condition parameter sub-table. Based on the target repair cost model, the repair cost is obtained from the equipment master data table and the key component sub-table; Determine whether the hourly rate includes the installation and dismantling fee based on the identification of the large machinery equipment. If it is determined that the hourly rate includes the installation and dismantling fee, obtain the installation and dismantling fee based on the installation and dismantling fee model selected by the user. The on-board labor cost and power / fuel cost are obtained from the equipment master data table and the operating condition parameter sub-table. The hourly rate data package is generated and encapsulated based on depreciation costs, repair costs, installation and dismantling costs, on-board labor costs, and power and fuel costs, and then provided to external parties through a predefined interface.

[0007] Optionally, the equipment category includes one of earthmoving machinery, concrete machinery, tunnel boring machine, hoisting machinery, transportation machinery, sand and gravel processing machinery, and foundation treatment machinery; the asset attribute includes owner-purchased or contractor-purchased; the technical characteristics include one of long-cycle low-intensity, short-cycle high-intensity, and workload-obsolete type. The preset depreciation models include the workload depreciation model, the financial payback period depreciation model, the economic life time model, and the dynamic depreciation model that considers the cost of capital. The preset repair cost model includes the workload method, the percentage of basic depreciation cost method, and the itemized calculation method of shift cost; The preset calculation rule sub-table is used to identify the mapping relationship between the feature identifier and the corresponding preset depreciation cost model and the preset repair cost model; Based on the equipment category, asset attributes, and technical characteristics, the target depreciation cost model and target repair cost model of the target construction equipment are obtained through a preset calculation rule sub-table, including: The feature identifier is determined based on the equipment category, the asset attribute, and the technical characteristics. The preset depreciation model corresponding to the feature identifier is used as the target depreciation model according to the preset calculation rule sub-table. The preset repair cost model corresponding to the feature identifier is used as the target repair cost model according to the preset calculation rule sub-table. If the target repair cost model is one of the basic depreciation cost ratio method and the shift cost itemization method, determine whether the preset conditions are met. If the preset conditions are met, update the target repair cost model to the workload method. The preset conditions are: the purchase cost of the component, the interval workload, and the rated hourly productivity of the component are all recorded, and the component category code is a functional wear part.

[0008] Optionally, the preset depreciation model includes a workload depreciation model, a financial payback period depreciation model, an economic life time model, and a dynamic depreciation model that considers the cost of capital. The process of obtaining depreciation costs based on the target depreciation cost model, according to the equipment master data table, key component sub-table, and operating condition parameter sub-table, includes: If the target depreciation model is the workload depreciation model, the equipment budget price, residual value rate, useful life in machine hours, and rated hourly productivity are obtained from the equipment master data table. The actual workload for the current period is obtained from the operating condition parameter sub-table. The rated total workload is obtained by multiplying the useful life in machine hours and the rated hourly productivity. The depreciation expense is then obtained using the following formula based on the rated total workload, equipment budget price, residual value rate, and useful life in machine hours: Depreciation expense = Equipment budget price × (1 - residual value rate) × actual workload in the current period ÷ rated total workload; If the target depreciation model is a dynamic depreciation model that considers the cost of capital, the annual discount rate, depreciation period, equipment budget price, residual value rate, and useful life in hours are obtained from the equipment master data table. The depreciation expense is then calculated using the following formula based on the annual discount rate, depreciation period, equipment budget price, residual value rate, and useful life in hours: Time value factor = 1 + annual discount rate × (depreciation period + 1) / 2 Depreciation expense = Equipment budget price × (1 - residual value rate) × time value factor ÷ useful life in hours; Specifically, if the target depreciation model is a financial payback period depreciation model, the equipment budget price, residual value rate, financial payback period for equipment investment, and expected return on capital are obtained from the equipment master data table, and the annual working hours are obtained from the operating condition parameter sub-table; the depreciation expense is then calculated according to the following formula based on the equipment budget price, residual value rate, financial payback period for equipment investment, and annual working hours: Depreciation expense = Budgeted equipment price × (1 - Residual value rate) × (1 + i) m ×i / [(1+i) m -1]÷Tn; Where i is the expected rate of return on capital, m is the financial payback period for equipment investment, and Tn is the annual working hours.

[0009] Specifically, if the target depreciation model is an economic life-hour model, the equipment budget price, residual value rate, and economic life-hour are obtained from the equipment master data table, and the depreciation expense is obtained based on the equipment budget price and residual value rate. Depreciation expense = Equipment budget price × (1 - residual value rate) ÷ economic life in machine hours.

[0010] Optionally, the large machinery equipment identification is used to indicate that the target construction equipment is either small machinery equipment or large machinery equipment; determining whether the hourly rate includes the installation and dismantling fee based on the large machinery equipment identification includes: If the large machinery equipment identification indicates that the target construction equipment is a small machinery equipment, then the hourly rate is determined to include the installation and dismantling fee. If the large machinery equipment identification indicates that the target construction equipment is large machinery equipment, then the hourly rate does not include the installation and dismantling fee.

[0011] Optionally, the preset repair cost model includes the workload method, the percentage of basic depreciation cost method, and the itemized calculation method of shift cost; Based on the target repair cost model, the repair cost is obtained from the equipment master data table and the key component sub-table, including: If the target repair cost model is based on the percentage of basic depreciation, the repair cost rate is obtained from the equipment master data table, and the repair cost is obtained according to the following formula based on the depreciation cost and the repair cost rate: Repair cost = Depreciation cost × Repair rate; Specifically, if the target repair cost model is a breakdown calculation method based on machine-hour costs, the following factors are obtained from the equipment master data table: lifespan hour cost per major repair, number of major repairs, lifespan hours, and regular repair cost coefficient. The repair cost is then calculated using the following formula based on these factors: Major repair cost = Cost of one major repair per service life (in machine hours) × Number of major repairs ÷ Service life (in machine hours); Routine repair costs = Major repair costs × Routine repair cost coefficient; Repair costs = Major repair costs + Regular repair costs; If the target repair cost model is the workload method, obtain the interval workload and the rated hourly productivity of the component based on the key component sub-table, and obtain the equivalent life hours of the component based on the interval workload and the rated hourly productivity of the component. Obtain the component purchase cost from the key component sub-table, and obtain the single-component hourly amortization cost of the key component by the ratio of the component purchase cost to the component's equivalent life hourly rate; The daily equipment maintenance cost is obtained from the equipment master data table, and the repair cost is obtained from the sum of the single-component hourly amortization cost and the daily equipment maintenance cost for each of the key components. Optionally, the on-board labor costs and power / fuel costs are obtained based on the equipment master data table and the operating condition parameter sub-table; including: The labor category and the corresponding on-machine labor hours and the labor budget unit price are obtained according to the working condition parameter sub-table; for each labor category, the sub-on-machine labor cost of the labor category is obtained by multiplying the on-machine labor hours and the labor budget unit price, and the on-machine labor cost is obtained by summing all the sub-on-machine labor costs; The rated power is obtained from the equipment master data table, and the fuel type is obtained from the operating condition parameter sub-table. For each fuel type, if the fuel type is electricity, the sub-fuel cost for that fuel type is obtained by multiplying the rated power, the load factor, and the budgeted unit price of the fuel. If the fuel type is diesel or gasoline, the sub-fuel cost for that fuel type is obtained by multiplying the quota fuel consumption and the budgeted unit price of the fuel. The total fuel cost is obtained by summing all the sub-fuel costs.

[0012] Optionally, the installation and dismantling cost model includes an installation and dismantling cost model based on the depreciation percentage method, an installation and dismantling cost model based on the workload method, and an installation and dismantling cost model based on a custom formula method; the installation and dismantling cost is obtained according to the installation and dismantling cost model selected by the user, including: If the installation and dismantling cost model is the installation and dismantling cost model based on the proportion of depreciation cost, the installation and dismantling cost rate is obtained according to the equipment master data table, and the installation and dismantling cost is obtained by multiplying the depreciation cost and the installation and dismantling cost rate. If the installation and dismantling cost model is the workload-based installation and dismantling cost model, the annual work hours are obtained from the working condition parameter sub-table, the single installation and dismantling cost and the average annual number of installations and dismantlings are obtained from the equipment master data table, and the installation and dismantling cost is obtained by multiplying the single installation and dismantling cost and the average annual number of installations and dismantlings by the ratio of the annual work hours; if the installation and dismantling cost model is the user-defined formula-based installation and dismantling cost model, the user-inputted custom expression is read and calculated to obtain the installation and dismantling cost; if the target construction equipment is large construction machinery, the installation and dismantling cost is not included in the work hour cost.

[0013] Secondly, this application provides a device for obtaining hourly rates for construction machinery, comprising: The parameter construction module is used to construct the equipment master data table, key component sub-table, and operating condition parameter sub-table for the target construction equipment. The equipment master data table, key component sub-table, and operating condition parameter sub-table all include equipment codes and are interconnected based on the equipment codes. The equipment master data table also includes equipment category, asset attributes, and technical characteristics. The model mapping module is used to obtain the equipment category, asset attribute, and technical characteristics of the target construction equipment in the equipment master data table based on the equipment code, and to obtain the target depreciation cost model and target repair cost model of the target construction equipment through a preset calculation rule sub-table based on the equipment category, asset attribute, and technical characteristics; wherein, the preset calculation rule sub-table is used to indicate the mapping relationship between the equipment category, asset attribute, technical characteristics and the preset depreciation cost model and the preset repair cost model, and the target depreciation cost model is one of the preset depreciation cost models, and the target repair cost model is one of the preset repair cost models; The data processing module is used to obtain the hourly rate based on the equipment master data table, the key component sub-table, and the operating condition parameter sub-table through the target repair cost model and the target depreciation cost model; wherein the hourly rate includes depreciation cost and repair cost.

[0014] Thirdly, this application provides a computer device, including: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the steps of the construction machinery hourly rate acquisition method described in any one of the above.

[0015] Fourthly, this application provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the construction machinery hourly rate acquisition method described above.

[0016] Fifthly, this application provides a computer program product, including a computer program that, when executed by a processor, implements the steps of the construction machinery hourly rate acquisition method described above.

[0017] According to the specific embodiments provided in this application, the following technical effects are disclosed: This application provides a method, apparatus, equipment, and medium for obtaining hourly rates for construction machinery. By constructing a master data table for equipment, a sub-table for key components, and a sub-table for operating parameters with equipment codes as the primary key, it solves the problems of data silos and difficulties in association caused by data fragmentation in multi-source heterogeneous systems in the prior art, and realizes real-time synchronization and unified management of multi-source parameters. By obtaining equipment category, asset attributes, and technical characteristics based on equipment codes and automatically matching target depreciation cost models and target repair cost models through preset calculation rule sub-tables, it solves the problems of selection bias and inefficiency caused by manual selection of calculation models in the prior art, and realizes intelligent matching of depreciation cost models and repair cost models. By calculating depreciation costs and repair costs based on the above data tables and through target models, it solves the problems of incomplete calculation basis and difficulty in traceability caused by the fragmentation of component maintenance data and quota data and the reliance on file-level import and export between systems, and finally generates accurate and traceable hourly rate results. Attached Figure Description

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

[0019] Figure 1 A flowchart illustrating a method for obtaining hourly rates for construction machinery, provided as an embodiment of this application; Figure 2 A flowchart illustrating a method for obtaining hourly rates for construction machinery, provided as another embodiment of this application; Figure 3 A schematic diagram of the functional modules of a construction machinery hourly rate acquisition device provided in an embodiment of this application; Figure 4 This is a schematic diagram of the structure of a computer device provided in an embodiment of this application. Detailed Implementation

[0020] The technical solutions of 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 application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0021] It should be noted that the terms "first," "second," "third," "fourth," etc. (if present) in the specification, claims, and accompanying drawings of this invention are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein.

[0022] It should be noted that "at the time of..." in the embodiments of this application can be either at the instant when a certain situation occurs, or for a period of time after the occurrence of a certain situation. The embodiments of this application do not make specific limitations on this.

[0023] To make the above-mentioned objectives, features and advantages of this application more apparent and understandable, the application will be further described in detail below with reference to the accompanying drawings and specific embodiments.

[0024] This application provides a method for obtaining hourly rates for construction machinery. In one exemplary embodiment, such as... Figure 1 As shown, this method is executed by a computer device, specifically by a terminal or server alone, or by both a terminal and a server. It includes the following steps 101-103: Step 101: Construct the equipment master data table, key component sub-table, and operating condition parameter sub-table for the target construction equipment; wherein, the equipment master data table, key component sub-table, and operating condition parameter sub-table all include equipment codes and are related to each other according to the equipment codes. The equipment master data table also includes equipment category, asset attributes, and technical characteristics. Specifically, a target construction equipment includes an equipment master data table, one or more key component sub-tables, and a working condition parameter sub-table; Specifically, considering that the target construction equipment includes one or more key components, each key component corresponds to a key component sub-table; Specifically, the above data can be obtained by accessing different systems such as Enterprise Resource Planning (ERP) systems, Enterprise Asset Management (EAM) systems, Internet of Things (IoT) platforms, and external pricing databases.

[0025] Step 102: Based on the equipment code, obtain the equipment category, asset attribute, and technical characteristics of the target construction equipment from the equipment master data table. Based on the equipment category, asset attribute, and technical characteristics, obtain the target depreciation cost model and target repair cost model of the target construction equipment through the preset calculation rule sub-table. The preset calculation rule sub-table is used to indicate the mapping relationship between the equipment category, asset attribute, technical characteristics, and the preset depreciation cost model and the preset repair cost model. The target depreciation cost model is one item in the preset depreciation cost model, and the target repair cost model is one item in the preset repair cost model. Specifically, the preset calculation rule sub-table is a rule mapping table, which is used to associate the mapping relationship between equipment category, asset attribute, technical characteristics and preset depreciation cost model and preset repair cost model. According to the mapping relationship in this step, the corresponding calculation module can be routed to perform calculation.

[0026] Step 103: Based on the equipment master data table, key component sub-table, and operating condition parameter sub-table, obtain the hourly rate through the target repair cost model and the target depreciation cost model; wherein, the hourly rate includes depreciation cost and repair cost; Specifically, the hourly rate also includes installation and dismantling fees and Category II fees, which include onboard labor costs and power and fuel costs. Furthermore, hourly rate quota data packages can be generated and encapsulated based on depreciation costs, repair costs, installation and dismantling costs, on-site labor costs, and power and fuel costs, and then provided externally through predefined interfaces. The hourly rate quota data package also includes basic data such as equipment name, specifications, manufacturer, and purchase date.

[0027] In another exemplary embodiment, such as Figure 2 As shown, a method for obtaining hourly rates for construction machinery is provided, including steps 201 to 207. Wherein: Step 201: Construct the equipment master data table, key component sub-table, and operating condition parameter sub-table for the target construction equipment; wherein, the equipment master data table, key component sub-table, and operating condition parameter sub-table all include equipment codes and are interconnected according to the equipment codes; the equipment master data table also includes equipment category, asset attributes, and technical characteristics; Specifically, the equipment master data table includes: equipment code, equipment name, specifications, manufacturer, purchase date, equipment budget price, residual value rate, service life in machine hours, economic service life in machine hours, annual discount rate, depreciation period, expected return on capital, financial recovery period of equipment investment, repair rate, cost of one major repair and number of major repairs per service life in machine hours, recurring repair cost coefficient, installation and dismantling rate, cost of one installation and dismantling, average number of installations and dismantlings per year, daily equipment maintenance cost, equipment category, asset attributes, technical characteristics, rated power and rated hourly productivity of equipment, and identification of large machinery equipment; Furthermore, the equipment categories include earthmoving machinery, concrete machinery, tunnel boring machines, hoisting machinery, transportation machinery, sand and gravel processing machinery, foundation treatment machinery, and other types. Asset attributes include those acquired by the owner or those acquired by the contractor; Technical characteristics distinguish working conditions such as long-cycle low-intensity, short-cycle high-intensity, and workload-related scrapping.

[0028] The key component sub-table includes fields such as: equipment code, component code, component name, component purchase cost, interval workload, component rated hourly productivity, and component category code.

[0029] Specifically, the large machinery equipment label is used to indicate that the target construction equipment is either small machinery equipment or large machinery equipment; Specifically, within the same equipment category, large and small equipment coexist (e.g., earthmoving machinery includes both large drilling rigs and small loaders). Large construction machinery typically refers to equipment that, due to its heavy weight, exceeding size limits, or complex structure, cannot be moved as a whole upon arrival at the site and requires transport by means of vehicles, either as a whole or in parts, and necessitates the use of auxiliary lifting machinery and facilities for installation and dismantling. According to industry standard practice, the installation, dismantling, and entry / exit costs for this type of equipment are calculated separately and not included in the machine hourly rate. Examples include concrete mixing plants, cable cranes, tower cranes, tunnel boring machines, and large drilling rigs. Equipment that can be moved as a whole or towed as a whole, and whose installation and dismantling are simple, is classified as small or medium-sized construction machinery, and its installation and dismantling costs are included in the machine hourly rate. The identification of large machinery equipment is determined by the user when entering the equipment master data, based on current industry standard regulations and the actual method of entry and exit.

[0030] Among them, the component category code is one of the functional wear parts and structural parts; Specifically, key components refer to components that play a decisive role in the normal operation of equipment and whose replacement cycle is directly related to the workload, including but not limited to: drill bits, drill rods, and impactors of hydraulic crawler drilling rigs; cutterheads, cutting tools, and screw conveyors of tunnel boring machines; conveying cylinders, spectacle plates, and cutting rings of concrete pump trucks; mixing blades and liners of mixing plants; and belts and rollers of tower conveyors.

[0031] Specifically, the working condition parameter sub-table includes one or more of the following fields: equipment code, labor category, fuel type, load factor, annual working hours, current actual workload, quota on-machine labor hours, labor budget unit price, quota power and fuel consumption, and power and fuel budget unit price. Specifically, the labor category refers to the job level of the workers on the machine. Each labor category has a corresponding quota of on-machine labor hours and a budgeted unit price for labor. According to the regulations of the hydropower industry, workers are generally divided into four categories: senior skilled workers, skilled workers, semi-skilled workers, and general workers. General workers generally cannot perform on-machine operations, so the labor categories for on-machine workers are divided into three categories: senior skilled workers, skilled workers, and semi-skilled workers.

[0032] Specifically, the fuel type includes one or more of electricity, diesel, and gasoline; if the fuel type is electricity, the fuel type includes the corresponding load factor and the budgeted unit price of the fuel; if the fuel type is diesel or gasoline, the fuel type includes the corresponding quota fuel consumption and the budgeted unit price of the fuel.

[0033] The load factor refers to the ratio of the average load of the construction machinery to its rated load under working conditions, and is used to calculate the power and fuel consumption.

[0034] Step 202: Based on the equipment code, obtain the equipment category, asset attribute, and technical characteristics of the target construction equipment from the equipment master data table. Based on the equipment category, asset attribute, and technical characteristics, obtain the target depreciation cost model and target repair cost model of the target construction equipment through a preset calculation rule sub-table. The preset calculation rule sub-table is used to indicate the mapping relationship between the equipment category, asset attribute, technical characteristics, and the preset depreciation cost model and the preset repair cost model. The target depreciation cost model is one item in the preset depreciation cost model, and the target repair cost model is one item in the preset repair cost model. As one embodiment, some of the preset calculation rule sub-tables are shown in Table 1.

[0035] Specifically, the pre-defined depreciation models include the workload depreciation model, the financial payback period depreciation model, the economic life time model, and the dynamic depreciation model that takes into account the cost of capital. Specifically, the pre-set repair cost models include the workload method, the percentage method based on basic depreciation, and the itemized calculation method based on shift costs; More preferably, if the target repair cost model is one of the basic depreciation cost percentage method and the shift cost itemized calculation method, determine whether the preset conditions are met. If the preset conditions are met, modify the target repair cost model to the workload method. The preset conditions are: confirm that the component purchase cost, interval workload, and component rated hourly productivity are all recorded, and the component category code is functional wear part.

[0036] Furthermore, if the preset conditions are not met, the original method should be followed.

[0037] As another embodiment, feature tags are obtained based on the equipment master data table, which retrieves equipment category, asset attributes, and technical characteristics; a preset calculation rule sub-table is used to indicate the mapping relationship between feature tags and preset depreciation cost model and preset repair cost model; Specifically, the feature label is a unique identifier, which can be replaced by a preset unique symbol, and is used to associate the preset depreciation cost model and preset repair cost model corresponding to the preset calculation rule sub-table; For example: If the equipment category is tunnel boring machine, the asset attribute is contractor purchase, and the technical characteristic is workload scrapping type, the corresponding feature label is determined as the first feature label, the preset depreciation model corresponding to the first feature label is the workload depreciation model, and the preset repair cost model corresponding to the first feature label is the workload method. If the equipment category is concrete machinery, the asset attribute is owner-purchased, and the technical characteristics are long cycle and low strength, the corresponding feature label is determined to be the second feature label. The preset depreciation model corresponding to the second feature label is the financial payback period method depreciation model, and the preset repair cost model corresponding to the second feature label is the units-of-production method. If the equipment category is lifting machinery, the asset attribute is contractor purchase, and the technical characteristics are short cycle and high strength, the corresponding feature label is determined to be the third feature label. The preset depreciation expense model corresponding to the third feature label is the economic life hour model, and the preset repair expense model corresponding to the third feature label is the percentage method of basic depreciation expense. If the equipment category is earthmoving machinery, the asset attribute is owner-purchased, and the technical characteristics are long cycle and low intensity, the corresponding feature label is determined to be the fourth feature label. The preset depreciation expense model corresponding to the fourth feature label is the dynamic depreciation expense model that takes into account the cost of capital. The preset repair expense model corresponding to the fourth feature label is the percentage method of basic depreciation expense. If the equipment category is transportation machinery, the asset attribute is contractor purchase, and the technical characteristics are short cycle and high strength, the corresponding feature label is determined to be the fifth feature label. The preset depreciation expense model corresponding to the fifth feature label is the economic life hour model, and the preset repair expense model corresponding to the fifth feature label is the percentage method of basic depreciation expense. If the equipment category is sand and gravel processing machinery, the asset attribute is owner-purchased, and the technical characteristics are long cycle and low intensity, the corresponding feature label is determined to be the sixth feature label. The preset depreciation expense model corresponding to the sixth feature label is the dynamic depreciation expense model that takes into account the cost of capital. The preset repair expense model corresponding to the sixth feature label is the percentage method of basic depreciation expense. If the equipment category is basic processing machinery, the asset attribute is contractor purchase, and the technical characteristics are short cycle and high intensity, the corresponding feature label is determined to be the seventh feature label. The preset depreciation expense model corresponding to the seventh feature label is the dynamic depreciation expense model that takes into account the cost of capital. The preset repair expense model corresponding to the seventh feature label is the percentage method of basic depreciation expense. If the equipment category is earthmoving machinery, the asset attribute is contractor purchase, and the technical characteristics are short cycle and high strength, the corresponding feature label is determined to be the eighth feature label. The preset depreciation expense model corresponding to the eighth feature label is the dynamic depreciation expense model that takes into account the cost of capital. The preset repair expense model corresponding to the eighth feature label is the percentage method of basic depreciation expense. If the equipment category is lifting machinery, the asset attribute is owner-purchased, and the technical characteristics are long cycle and low strength, the corresponding feature label is determined to be the ninth feature label. The preset depreciation model corresponding to the ninth feature label is the dynamic depreciation model that takes into account the cost of capital. The preset repair cost model corresponding to the ninth feature label is the itemized calculation method of shift cost. Step 203: Based on the target depreciation expense model, obtain the depreciation expense from the equipment master data table, key component sub-table, and operating condition parameter sub-table.

[0038] Specifically, the pre-defined depreciation models include the workload depreciation model, the financial payback period depreciation model, the economic life time model, and the dynamic depreciation model that takes into account the cost of capital. Specifically, if the target depreciation model is a dynamic depreciation model that considers the cost of capital; obtain the annual discount rate, depreciation period, equipment budget price, residual value rate, and useful life in hours from the equipment master data table; and then calculate the depreciation expense using the following formula based on the annual discount rate, depreciation period, equipment budget price, residual value rate, and useful life in hours: Time value factor = 1 + annual discount rate × (depreciation period + 1) / 2 Depreciation = Budgeted equipment price × (1 - Residual value rate) × Time value factor / useful life (unit hours) Specifically, if the target depreciation model is the financial payback period method, obtain the equipment budget price, residual value rate, financial payback period for equipment investment, and expected return on capital from the equipment master data table, and obtain the annual working hours from the operating condition parameter sub-table; then, calculate the depreciation expense using the following formula based on the equipment budget price, residual value rate, financial payback period for equipment investment, and annual working hours: Depreciation expense = Budgeted equipment price × (1 - Residual value rate) × (1 + i) m ×i / [(1+i) m -1]×1 / Tn Where i is the expected rate of return on capital, m is the financial payback period for equipment investment, and Tn is the annual working hours.

[0039] Specifically, if the target depreciation model is an economic life-hour model, the equipment budget price, residual value rate, and economic life-hour are obtained from the equipment master data table, and the depreciation expense is obtained based on the equipment budget price and residual value rate. Depreciation expense = Budgeted equipment price × (1 - Residual value rate) ÷ Economic life in machine hours; Among them, economic life time is obtained through the principle of minimizing the annual equivalent total cost.

[0040] Specifically, if the target depreciation model is a workload-based depreciation model, the equipment budget price, residual value rate, useful life (in hours), and rated hourly productivity are obtained from the equipment master data table. The actual workload for the current period is obtained from the operating condition parameter sub-table. The rated total workload is obtained by multiplying the useful life (in hours) and the rated hourly productivity. The depreciation expense is then calculated based on the rated total workload, equipment budget price, residual value rate, and useful life (in hours). Rated total workload = rated hourly productivity of equipment × service life in machine hours.

[0041] Depreciation expense = Equipment budget price × (1 - residual value rate) × actual workload in the current period ÷ rated total workload; Step 204: Obtain the repair cost based on the target repair cost model using the equipment master data table and the key component sub-table; Specifically, the preset repair cost models include the workload method, the percentage of basic depreciation cost method, and the itemized calculation method of shift costs. The target repair cost model is one of the preset repair cost models.

[0042] Specifically, if the target repair cost model is based on the percentage of basic depreciation, the repair cost rate is obtained from the equipment master data table, and the repair cost is obtained based on the depreciation cost and the repair cost rate. Repair cost = Depreciation cost × Repair rate; Specifically, if the target repair cost model is a breakdown of costs per shift, the following are calculated based on the equipment master data table: cost per major repair per machine-hour, number of major repairs, service life per machine-hour, and coefficient for routine repair costs. The repair cost is then calculated using these factors. Specific formulas include: Major repair cost = Cost of one major repair per service life (in machine hours) × Number of major repairs ÷ Service life (in machine hours); Routine repair costs = Major repair costs × Routine repair cost coefficient; Repair costs = Major repair costs + Regular repair costs; The coefficient for recurring repair costs is determined based on the corresponding industry's construction machinery shift cost quota and the market price during the compilation period, and is set in the equipment master data table.

[0043] Specifically, the workload method calculates equipment-level repair costs by automatically fusing and aggregating key component workload and lifespan data into an algorithm. If the target repair cost model is the workload method, the specific steps are as follows: Step 301: Obtain the interval workload and rated hourly productivity of the component based on the key component sub-table, and obtain the equivalent lifespan of the component in machine hours based on the interval workload and rated hourly productivity of the component. Component equivalent life hours = Interval workload ÷ Component rated hourly productivity Specifically, this step involves converting the component-level workload dimension into an equivalent time dimension; Step 302: Obtain the component purchase cost based on the component sub-table, and obtain the single component hourly amortization cost of the key component based on the component equivalent life hour and the component purchase cost; Single component hourly amortization cost = component purchase cost ÷ component equivalent life hourly; Step 303: Obtain the daily equipment maintenance fee based on the equipment master data table; obtain the repair fee based on the single-component hourly amortization fee of each key component and the daily equipment maintenance fee; Repair cost = Σ (amortization cost per unit hour) + routine equipment maintenance cost; Step 205: Determine whether the hourly rate includes installation and dismantling fees based on the identification of the large machinery and equipment. If it is determined that the hourly rate includes installation and dismantling fees, obtain the installation and dismantling fees based on the installation and dismantling fee model selected by the user. Specifically, the installation and dismantling costs of small mechanical equipment are part of the daily operating cost and are listed in parallel with the repair costs; the installation and dismantling costs of large mechanical equipment belong to other cost items and are not listed in the daily operating cost.

[0044] Specifically, if the large machinery equipment sign indicates that the target construction equipment is small machinery equipment, the hourly rate should include installation and dismantling fees. If the target construction equipment indicated by the large machinery equipment sign is large machinery equipment, the hourly rate will not include installation and dismantling costs.

[0045] The installation and dismantling cost models selected by the user include those based on a percentage of depreciation, those based on workload, and those based on a custom formula. If the hourly rate includes installation and dismantling costs, the installation and dismantling costs are obtained using the following method: If the installation and dismantling cost model is based on the depreciation ratio method, the installation and dismantling cost rate is obtained from the equipment master data table, and the installation and dismantling cost is obtained by multiplying the depreciation cost by the installation and dismantling cost rate. Installation and dismantling cost = Depreciation cost × Installation and dismantling cost rate; If the installation and dismantling cost model is based on the workload method, when obtaining the annual worktable from the working condition parameter sub-table, the installation and dismantling cost per instance and the average number of installation and dismantling operations per year are obtained from the equipment master data table. The installation and dismantling cost is then calculated by dividing the product of the installation and dismantling cost per instance and the average number of installation and dismantling operations per year by the annual worktable time. The specific formula is as follows: Installation and dismantling cost = cost of one installation and dismantling × average number of installations and dismantlings per year ÷ annual work hours; The calculations are performed by obtaining the installation and dismantling cost and the average number of installations and dismantlings per year from the equipment master data table, and the annual work hours from the working condition parameter sub-table.

[0046] If the installation and dismantling fee model is based on a custom formula, the user-inputted custom expression is read to calculate the installation and dismantling fee.

[0047] Step 206: Obtain the on-board labor cost and power / fuel cost based on the equipment master data table and the operating condition parameter sub-table; Specifically, onboard labor costs and power and fuel costs are classified as two categories of expenses, which are two items within the hourly rate.

[0048] Specifically, the on-machine labor hours and budgeted unit price for each labor category are obtained from the working condition parameter sub-table; for each labor category, the on-machine labor cost for that labor category is obtained by multiplying the on-machine labor hours and the budgeted unit price for labor, and the on-machine labor cost is obtained by summing all the on-machine labor costs. Specifically, the rated power is obtained from the equipment master data table, and the load factor, fuel type, standard fuel consumption, and budgeted fuel unit price are obtained from the operating condition parameter sub-table. For each fuel type, if the fuel type is electricity, the sub-fuel cost is obtained by multiplying the rated power, load factor, and budgeted fuel unit price. If the fuel type is diesel or gasoline, the sub-fuel cost is obtained by multiplying the standard fuel consumption and budgeted fuel unit price. The total fuel cost is then obtained by summing all sub-fuel costs.

[0049] Step 207: Generate a fixed data package for hourly rates based on depreciation, repair, installation and dismantling, on-board labor, and power and fuel costs, encapsulate it, and provide it to the outside world through a predefined interface.

[0050] As one example, as shown in Table 2, the hourly rate quota data includes equipment code, equipment name, specifications, cost package, depreciation, repair cost, installation and dismantling cost, on-machine labor cost, power and fuel cost, total hourly rate, metadata, depreciation model identifier, repair model identifier, installation and dismantling cost model identifier, calculation date, and data version number.

[0051] Specifically, the corresponding quota data packets are encapsulated into standard format entries, and through predefined application programming interfaces or dynamic link libraries, they respond to the call requests of external budgeting software, thereby achieving seamless transmission and embedding of quota data.

[0052] The interfaces include the following two types: The first type is a RESTful API interface. Based on the HTTP / HTTPS protocol, the request method is POST, the request Uniform Resource Locator is / api / v1 / equipment-rate, and the request body parameter is the device code; the response format is a standard data format, including a fixed data packet and a Hypertext Transfer Protocol status code.

[0053] The second type is the DLL dynamic link library interface. The exported function is named GetEquipmentRate. The input parameter is a device encoding string, and the output parameter is a pointer to a standard-format quota data packet structure. The calling convention supports stdcall and cdecl, and it is compatible with 32-bit and 64-bit host programs.

[0054] Example 1: Hydraulic crawler drilling rig ROC D7 Execute step 201, parameter acquisition: Enter the equipment master data for ROC D7 in the system parameter construction module: Equipment code is ROC-D7-001, equipment category is earthmoving machinery, asset attribute is owner-purchased, technical characteristics are long cycle and low strength, budget price is 3,069,400 yuan, residual value rate is 5%, repair cost rate is 60.15%, service life is 17,600 hours, annual discount rate is 6.14%, depreciation period is 10 years, rated power is 168kW, and the large machinery equipment is identified as yes.

[0055] Operating Parameters Sub-Table Data: Annual working hours: 1760 hours; fuel type: diesel; quota of skilled workers' working hours on the machine: 1.4 hours; budgeted unit price of skilled workers: 25.07 yuan / hour; quota of power fuel consumption: 26.04 kg; budgeted unit price of power fuel: 8.73 yuan / kg.

[0056] In step 202, the system automatically matches mapping rules to the dynamic depreciation expense model that considers capital costs and the repair expense model based on the equipment category (earthwork machinery), asset attribute (owner-purchased), and technical characteristics (long cycle, low intensity).

[0057] Perform step 203 to obtain the depreciation expense: Load the dynamic depreciation model and calculate the time value factor: Time value factor = 1 + [0.0614 × (10 + 1)] ÷ 2 = 1.34 Depreciation cost = [3069400 × (1-5%) × 1.34] ÷ 17600 = 221.63 yuan / unit-hour.

[0058] Step 204 is executed. Due to missing data in the key component sub-table, the basic depreciation percentage method model is directly loaded. The calculation yields: Repair cost = 221.63 × 60.15% = 133.31 yuan / unit-hour.

[0059] Perform steps 205-206 to obtain the installation / disassembly fee and Category II fee: Hydraulic crawler drilling rigs are large construction equipment. Their installation and dismantling costs are included in the company's management fees and are not calculated in the machine hourly rate.

[0060] Of the two categories of expenses, the on-board labor cost is 1.4 man-hours × 25.07 yuan / man-hour = 35.10 yuan / machine-hour, and the diesel consumption cost is 26.04 kg × 8.73 yuan / kg = 227.32 yuan / machine-hour.

[0061] Execute step 207, summarizing and encapsulating the quota data packet and making interface calls: Total hourly rate: 221.63 + 133.31 + 35.10 + 227.32 = 617.36 yuan / hour.

[0062] The system generates a standard format quota data package, which includes basic equipment information, details of Class I expenses, details of Class II expenses, and total hourly rate. In the metadata, the depreciation expense model is identified as "dynamic depreciation expense model considering capital costs", and the repair expense model is identified as "the percentage method of basic depreciation expense".

[0063] When a user compiles unit prices in the accompanying cost estimation software and needs to call the ROC D7 hourly rate quota, they can send a POST request via API. The system will then directly transmit the encapsulated quota data package and embed it into the cost estimation file.

[0064] Example 2: 4×3m concrete mixing plant 3 Execute step 201, parameter acquisition: Enter the following data for the mixing plant owner: Equipment code is MIX-4×3-001, equipment category is concrete machinery, asset attribute is owner-purchased, technical characteristics are long cycle and low strength, budget price is 7,416,000 yuan, residual value rate is 3%, expected return on capital is 8%, financial payback period is 10 years, daily equipment maintenance cost is 167.16 yuan / unit hour, rated power is 350kW, and it is identified as a large-scale machinery equipment.

[0065] The data in the related key component sub-tables is as follows: Mixer: Part code MIX-4×3-JBJ-001, part purchase cost 2 million yuan (500,000 yuan per unit, 4 units in total), interval workload 984,200 m. 3 The rated hourly production rate of the component is 120m. 3 / h.

[0066] Operating Parameters Sub-Table Data: Annual average working hours 1250h, fuel type is electricity, load factor 0.8, semi-skilled worker hours 2.8 hours, skilled worker hours 2.8 hours, senior skilled worker hours 1.4 hours, budgeted unit price for semi-skilled workers 20.96 yuan / hour, budgeted unit price for skilled workers 25.07 yuan / hour, budgeted unit price for senior skilled workers 31.64 yuan / hour, budgeted unit price for power fuel 0.671 yuan / kW·h.

[0067] In step 202, the system automatically matches mapping rules to the financial payback period depreciation model and the quantity-based repair cost model based on the equipment category (concrete machinery), asset attribute (owner-purchased), and technical characteristics (long cycle, low strength).

[0068] Perform step 203 to obtain the depreciation expense: According to the target depreciation expense model, the depreciation expense = [7416000×(1-3%)×(1+0.08)^10×0.08]÷[(1+0.08)^10-1]÷1250 = 857.64 yuan / unit-hour.

[0069] Execute step 204, calculate and aggregate repair costs. The equivalent life of the mixer components in machine hours is 984200 ÷ 120 = 8201.67 hours, and the hourly amortization cost is 2000000 ÷ 8201.67 = 243.84 yuan / hour.

[0070] Routine equipment maintenance costs are retrieved from the equipment master data table (based on analysis of the equipment's historical maintenance records: For a certain project's concrete production system, the total cost of spare parts and maintenance during the statistical period was 4.1673 million yuan, and the production of concrete was 2.9923 million cubic meters). 3 The maintenance fee is 1.393 yuan / m². 3 Based on a rated production rate of 120 m³ / h, the cost is calculated to be 1.393 × 120 = 167.16 yuan / h.

[0071] Repair cost = 243.84 + 167.16 = 411.00 yuan / unit-hour.

[0072] Perform steps 205-206 to obtain the installation / disassembly fee and Category II fee: Concrete mixing plants are large construction equipment, and their installation and dismantling costs are included in the company's management fees, but are not calculated in the hourly rate.

[0073] For the second category of expenses, the onboard labor cost is calculated by multiplying the labor consumption amount determined by industry quotas by the current labor budget unit price at the project location: Onboard labor cost = 1.4 × 31.64 + 2.8 × 25.07 + 2.8 × 20.96 = 173.18 yuan / machine hour.

[0074] The fuel cost is calculated based on the equipment's rated power of 350kW, a load factor of 0.8, and the current electricity price. Power fuel cost = 350 × 0.8 × 0.671 = 187.88 yuan / hour.

[0075] Execute step 207, summarizing and encapsulating the quota data packet and making interface calls: Based on the above calculations, the total costs are: depreciation of 857.64 yuan, repair costs of 411.00 yuan, and second-class costs of 361.06 yuan, forming a complete hourly rate data package.

[0076] The system generates a standard-format quota data package, which includes basic equipment information, details of Category I expenses, details of Category II expenses, and total hourly rate. The depreciation model in the metadata is identified as "Financial Recovery Period Method Depreciation Model," and the repair cost model is identified as "Units-Based Method."

[0077] When preparing the unit price for concrete pouring, a certain hydropower project budgeting software needs to call the hourly rate quota for the mixing plant in this example. The software calls the system interface via an HTTP POST request.

[0078] After verifying the token, the system returns a standard-format quota data packet, as shown in Table 3. The cost estimation software directly parses the response data and embeds it into the current cost file, requiring no manual intervention throughout the process.

[0079] This application provides a method for obtaining hourly rates for construction machinery, which has the following technical advantages: By constructing a master data table for equipment, a sub-table for key components, a sub-table for operating parameters, and a sub-table for preset calculation rules, and establishing primary and foreign key relationships with equipment codes as the primary key, this invention incorporates multi-source heterogeneous data scattered across different information systems into a unified structured storage framework. This technical solution solves the technical problem of the lack of an automatic association mechanism between equipment parameters, component maintenance data, and calculation rules in existing technologies. It enables dynamic calculation models to efficiently and accurately obtain complete input, significantly improving calculation preparation efficiency compared to traditional manual collection and organization methods, and fundamentally eliminating calculation deviations caused by inconsistent data sources.

[0080] This invention achieves automatic routing and loading of depreciation and repair cost calculation models through the linkage of a three-element tag group of equipment category, asset attribute, and technical characteristics with a mapping rule engine. The system can automatically match the optimal calculation path based on the inherent characteristics of the equipment without manual intervention, solving the technical problems of hard-coded calculation models, manual selection, and logical errors caused by mismatched applicable conditions in existing technologies. This significantly enhances the system's adaptability and scalability to different types of equipment with different purchase attributes and operating conditions.

[0081] This invention establishes a unified mapping relationship between component-level workload data and equipment-level hourly data by introducing the equivalent lifespan of components as an intermediate conversion dimension, and realizes the automatic aggregation of hourly amortization costs for single components across multiple components. This technical solution overcomes the structural data gap between component maintenance data and equipment quota data due to different dimensions in existing technologies.

[0082] This invention encapsulates the hourly rate quota data package into a standard format and publishes it externally through a RESTful API and a DLL dynamic link library. This solves the technical problems of data format conflicts, version inconsistencies, and transmission delays caused by the reliance on file-level import and export between budget software and hourly rate calculation systems in the prior art. It realizes the direct, seamless, and automated embedding of construction machinery hourly rate quota data into the external cost document preparation process, significantly improving the overall efficiency and data consistency of engineering cost document preparation.

[0083] Based on the same inventive concept, this application also provides a construction machinery hourly rate acquisition device for implementing the above-mentioned construction machinery hourly rate acquisition method. The solution provided by this device is similar to the solution described in the above-described method. Therefore, the specific limitations of one or more construction machinery hourly rate acquisition device embodiments provided below can be found in the limitations of the construction machinery hourly rate acquisition method described above, and will not be repeated here.

[0084] In one exemplary embodiment, such as Figure 3 As shown, a device for obtaining hourly rates for construction machinery is provided, comprising: The parameter construction module is used to construct the equipment master data table, key component sub-table, and operating condition parameter sub-table for the target construction equipment. Among them, the equipment master data table, key component sub-table, and operating condition parameter sub-table all include equipment codes and are interconnected based on the equipment codes. The equipment master data table also includes equipment category, asset attributes, and technical characteristics. The model mapping module is used to obtain the equipment category, asset attributes, and technical characteristics of the target construction equipment from the equipment master data table based on the equipment code. Based on the equipment category, asset attributes, and technical characteristics, it obtains the target depreciation cost model and target repair cost model of the target construction equipment through a preset calculation rule sub-table. The preset calculation rule sub-table indicates the mapping relationship between the equipment category, asset attributes, technical characteristics, and the preset depreciation cost model and preset repair cost model. The target depreciation cost model is one item in the preset depreciation cost model, and the target repair cost model is one item in the preset repair cost model. The data processing module is used to obtain the hourly rate based on the equipment master data table, key component sub-table, and operating condition parameter sub-table through the target repair cost model and the target depreciation cost model; whereby the hourly rate includes depreciation cost and repair cost.

[0085] In one exemplary embodiment, a computer device is provided, which may be a server or a terminal, and its internal structure diagram may be as follows. Figure 4 As shown, the computer device includes a processor, memory, input / output (I / O) interfaces, and a communication interface. The processor, memory, and I / O interfaces are connected via a system bus, and the communication interface is also connected to the system bus via the I / O interfaces. The processor provides computational and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and a database. The internal memory provides the environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The database stores data. The I / O interfaces are used for exchanging information between the processor and external devices. The communication interface is used for communicating with external terminals via a network. When the computer program is executed by the processor, it implements a method for obtaining hourly rates for construction machinery.

[0086] Those skilled in the art will understand that Figure 4 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0087] In one exemplary embodiment, a computer device is also provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps in the above-described method embodiments.

[0088] In one exemplary embodiment, a computer-readable storage medium is provided storing a computer program that, when executed by a processor, implements the steps in the above-described method embodiments.

[0089] In one exemplary embodiment, a computer program product is provided, including a computer program that, when executed by a processor, implements the steps in the above-described method embodiments.

[0090] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, data stored, data displayed, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of the relevant data must comply with relevant regulations.

[0091] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium. When executed, the computer program can include the processes of the embodiments of the above methods. Any references to memory, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM).

[0092] The databases involved in the embodiments provided in this application may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this application may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.

[0093] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0094] This document uses specific examples to illustrate the principles and implementation methods of this application. The descriptions of the embodiments above are only for the purpose of helping to understand the methods and core ideas of this application. At the same time, those skilled in the art will recognize that, based on the ideas of this application, there will be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be construed as a limitation of this application.

Claims

1. A method for obtaining hourly rates for construction machinery, characterized in that, The method for obtaining the hourly rate for construction machinery includes: Construct a master data table, a key component sub-table, and a working condition parameter sub-table for the target construction equipment; wherein, the master data table, the key component sub-table, and the working condition parameter sub-table all include equipment codes and are interconnected according to the equipment codes, and the master data table also includes equipment category, asset attributes, and technical characteristics; Based on the equipment code, the equipment category, asset attribute, and technical characteristics of the target construction equipment in the equipment master data table are obtained. Then, based on the equipment category, asset attribute, and technical characteristics, a target depreciation cost model and a target repair cost model for the target construction equipment are obtained through a preset calculation rule sub-table. The preset calculation rule sub-table indicates the mapping relationship between the equipment category, asset attribute, technical characteristics, and the preset depreciation cost model and preset repair cost model. The target depreciation cost model is one item in the preset depreciation cost model, and the target repair cost model is one item in the preset repair cost model. Based on the equipment master data table, the key component sub-table, and the operating condition parameter sub-table, the hourly rate is obtained through the target repair cost model and the target depreciation cost model; wherein, the hourly rate includes depreciation cost and repair cost.

2. The method for obtaining construction machinery hourly rates according to claim 1, characterized in that, The hourly rate also includes one or more of the following: installation and dismantling fees, on-board labor costs, and power and fuel costs; The equipment master data table also includes equipment name, specifications, manufacturer, purchase date, equipment budget price, residual value rate, service life in machine hours, economic service life in machine hours, annual discount rate, depreciation period, expected return on capital, financial recovery period of equipment investment, repair rate, cost of one major repair and number of major repairs per service life in machine hours, recurring repair cost coefficient, installation and dismantling rate, cost of one installation and dismantling, average number of installations and dismantlings per year, daily equipment maintenance cost, rated power and rated hourly productivity of equipment, and identification of large machinery equipment; The key component sub-table also includes component code, component name, component purchase cost, interval workload, component rated hourly productivity, and component category code; The working condition parameter sub-table also includes labor category, load factor, fuel type, annual working hours, current actual workload, quota on-machine labor hours, labor budget unit price, quota power and fuel consumption, and power and fuel budget unit price; The process of obtaining hourly rates based on the equipment master data table, the key component sub-table, and the operating condition parameter sub-table through the target repair cost model and the target depreciation cost model includes: Based on the target depreciation model, the depreciation expense is obtained from the equipment master data table, the key component sub-table, and the operating condition parameter sub-table. Based on the target repair cost model, the repair cost is obtained from the equipment master data table and the key component sub-table; Determine whether the hourly rate includes the installation and dismantling fee based on the identification of the large machinery equipment. If it is determined that the hourly rate includes the installation and dismantling fee, obtain the installation and dismantling fee based on the installation and dismantling fee model selected by the user. The on-board labor cost and power / fuel cost are obtained from the equipment master data table and the operating condition parameter sub-table. The hourly rate data package is generated and encapsulated based on depreciation costs, repair costs, installation and dismantling costs, on-board labor costs, and power and fuel costs, and then provided to external parties through a predefined interface.

3. The method for obtaining construction machinery hourly rates according to claim 1, characterized in that, The equipment category includes one of the following: earthmoving machinery, concrete machinery, tunnel boring machine, hoisting machinery, transportation machinery, sand and gravel processing machinery, and foundation treatment machinery; the asset attribute includes owner-purchased or contractor-purchased; the technical characteristics include one of the following: long-cycle low-intensity, short-cycle high-intensity, and workload-limited type. The preset depreciation models include the workload depreciation model, the financial payback period depreciation model, the economic life time model, and the dynamic depreciation model that considers the cost of capital. The preset repair cost model includes the workload method, the percentage of basic depreciation cost method, and the itemized calculation method of shift cost; The preset calculation rule sub-table is used to identify the mapping relationship between the feature identifier and the corresponding preset depreciation cost model and the preset repair cost model; Based on the equipment category, asset attributes, and technical characteristics, the target depreciation cost model and target repair cost model of the target construction equipment are obtained through a preset calculation rule sub-table, including: The feature identifier is determined based on the equipment category, the asset attribute, and the technical characteristics. The preset depreciation model corresponding to the feature identifier is used as the target depreciation model according to the preset calculation rule sub-table. The preset repair cost model corresponding to the feature identifier is used as the target repair cost model according to the preset calculation rule sub-table. If the target repair cost model is one of the basic depreciation cost ratio method and the shift cost itemization method, determine whether the preset conditions are met. If the preset conditions are met, update the target repair cost model to the workload method. The preset conditions are: the purchase cost of the component, the interval workload, and the rated hourly productivity of the component are all recorded, and the component category code is a functional wear part.

4. The method for obtaining construction machinery hourly rates according to claim 2, characterized in that, The preset depreciation models include the workload depreciation model, the financial payback period depreciation model, the economic life time model, and the dynamic depreciation model that considers the cost of capital. The process of obtaining depreciation costs based on the target depreciation cost model, according to the equipment master data table, key component sub-table, and operating condition parameter sub-table, includes: If the target depreciation model is the workload depreciation model, the equipment budget price, residual value rate, useful life in machine hours, and rated hourly productivity are obtained from the equipment master data table. The actual workload for the current period is obtained from the operating condition parameter sub-table. The rated total workload is obtained by multiplying the useful life in machine hours and the rated hourly productivity. The depreciation expense is then obtained using the following formula based on the rated total workload, equipment budget price, residual value rate, and useful life in machine hours: Depreciation expense = Equipment budget price × (1 - residual value rate) × actual workload in the current period ÷ rated total workload; If the target depreciation model is a dynamic depreciation model that considers the cost of capital, the annual discount rate, depreciation period, equipment budget price, residual value rate, and useful life in hours are obtained from the equipment master data table. The depreciation expense is then calculated using the following formula based on the annual discount rate, depreciation period, equipment budget price, residual value rate, and useful life in hours: Time value factor = 1 + annual discount rate × (depreciation period + 1) / 2 Depreciation expense = Equipment budget price × (1 - residual value rate) × time value factor ÷ useful life in hours; Specifically, if the target depreciation model is a financial payback period depreciation model, the equipment budget price, residual value rate, financial payback period for equipment investment, and expected return on capital are obtained from the equipment master data table, and the annual working hours are obtained from the operating condition parameter sub-table; the depreciation expense is then calculated according to the following formula based on the equipment budget price, residual value rate, financial payback period for equipment investment, and annual working hours: Depreciation expense = Budgeted equipment price × (1 - Residual value rate) × (1 + i) m ×i / [(1+i) m -1]÷Tn; Where i is the expected rate of return on capital, m is the financial payback period for equipment investment, and Tn is the annual working hours; Specifically, if the target depreciation model is an economic life-hour model, the equipment budget price, residual value rate, and economic life-hour are obtained from the equipment master data table, and the depreciation expense is obtained based on the equipment budget price and residual value rate. Depreciation expense = Equipment budget price × (1 - residual value rate) ÷ economic life in machine hours.

5. The method for obtaining construction machinery hourly rates according to claim 2, characterized in that, The large machinery equipment identification is used to indicate that the target construction equipment is either a small machinery equipment or a large machinery equipment. Determining whether the hourly rate includes the installation and dismantling fee based on the identification of the large machinery equipment includes: If the large machinery equipment identification indicates that the target construction equipment is the small machinery equipment, then the hourly rate is determined to include the installation and dismantling fee; If the large machinery equipment identifier indicates that the target construction equipment is the large machinery equipment, then the hourly rate does not include the installation and dismantling fee.

6. The method for obtaining hourly rates for construction machinery according to claim 2, characterized in that, The preset repair cost model includes the workload method, the percentage of basic depreciation cost method, and the itemized calculation method of shift cost; Based on the target repair cost model, the repair cost is obtained from the equipment master data table and the key component sub-table, including: If the target repair cost model is based on the percentage of basic depreciation, the repair cost rate is obtained from the equipment master data table, and the repair cost is obtained according to the following formula based on the depreciation cost and the repair cost rate: Repair cost = Depreciation cost × Repair rate; Specifically, if the target repair cost model is a breakdown calculation method based on machine-hour costs, the following factors are obtained from the equipment master data table: lifespan hour cost per major repair, number of major repairs, lifespan hours, and regular repair cost coefficient. The repair cost is then calculated using the following formula based on these factors: Major repair cost = Cost of one major repair per service life (in machine hours) × Number of major repairs ÷ Service life (in machine hours); Routine repair costs = Major repair costs × Routine repair cost coefficient; Repair costs = Major repair costs + Regular repair costs; If the target repair cost model is the workload method, obtain the interval workload and the rated hourly productivity of the component based on the key component sub-table, and obtain the equivalent life hours of the component based on the interval workload and the rated hourly productivity of the component. Obtain the component purchase cost from the key component sub-table, and obtain the single-component hourly amortization cost of the key component by the ratio of the component purchase cost to the component's equivalent life hourly rate; The daily equipment maintenance cost is obtained from the equipment master data table, and the repair cost is obtained from the sum of the single-component hourly amortization cost and the daily equipment maintenance cost for each of the key components.

7. The method for obtaining construction machinery hourly rates according to claim 2, characterized in that, Based on the equipment master data table and the operating condition parameter sub-table, the on-board labor cost and power / fuel cost are obtained, including: The labor category and the corresponding on-machine labor hours and the labor budget unit price are obtained according to the working condition parameter sub-table; for each labor category, the sub-on-machine labor cost of the labor category is obtained by multiplying the on-machine labor hours and the labor budget unit price, and the on-machine labor cost is obtained by summing all the sub-on-machine labor costs; The rated power is obtained from the equipment master data table, and the fuel type is obtained from the operating condition parameter sub-table. For each fuel type, if the fuel type is electricity, the sub-fuel cost for that fuel type is obtained by multiplying the rated power, the load factor, and the budgeted unit price of the fuel. If the fuel type is diesel or gasoline, the sub-fuel cost for that fuel type is obtained by multiplying the quota fuel consumption and the budgeted unit price of the fuel. The total fuel cost is obtained by summing all the sub-fuel costs.

8. The method for obtaining construction machinery hourly rates according to claim 2, characterized in that, The installation and dismantling cost models include an installation and dismantling cost model based on the depreciation ratio method, an installation and dismantling cost model based on the workload method, and an installation and dismantling cost model based on the custom formula method. The installation and dismantling fee is obtained based on the installation and dismantling fee model selected by the user, including: If the installation and dismantling cost model is the installation and dismantling cost model based on the proportion of depreciation cost, the installation and dismantling cost rate is obtained according to the equipment master data table, and the installation and dismantling cost is obtained by multiplying the depreciation cost and the installation and dismantling cost rate. If the installation and dismantling cost model is the installation and dismantling cost model based on the workload method, when the annual worktable is obtained according to the working condition parameter sub-table, the installation and dismantling cost per instance and the average number of installation and dismantling times per year are obtained according to the equipment master data table, and the installation and dismantling cost is obtained according to the ratio of the product of the installation and dismantling cost per instance and the average number of installation and dismantling times per year to the annual worktable. If the installation and dismantling fee model is an installation and dismantling fee model based on a custom formula method, the user-inputted custom expression is read and the installation and dismantling fee is calculated.

9. A device for obtaining hourly rates for construction machinery, characterized in that, The construction machinery hourly rate acquisition device includes: The parameter construction module is used to construct the equipment master data table, key component sub-table, and operating condition parameter sub-table for the target construction equipment. The equipment master data table, key component sub-table, and operating condition parameter sub-table all include equipment codes and are interconnected based on the equipment codes. The equipment master data table also includes equipment category, asset attributes, and technical characteristics. The model mapping module is used to obtain the equipment category, asset attribute, and technical characteristics of the target construction equipment in the equipment master data table based on the equipment code, and to obtain the target depreciation cost model and target repair cost model of the target construction equipment through a preset calculation rule sub-table based on the equipment category, asset attribute, and technical characteristics; wherein, the preset calculation rule sub-table is used to indicate the mapping relationship between the equipment category, asset attribute, technical characteristics and the preset depreciation cost model and the preset repair cost model, and the target depreciation cost model is one of the preset depreciation cost models, and the target repair cost model is one of the preset repair cost models; The data processing module is used to obtain the hourly rate based on the equipment master data table, the key component sub-table, and the operating condition parameter sub-table through the target repair cost model and the target depreciation cost model; wherein the hourly rate includes depreciation cost and repair cost.

10. A computer device, comprising: A memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that the processor executes the computer program to implement the steps of the method for obtaining construction machinery hourly rates according to any one of claims 1-8.