A hydraulic engineering construction cost control system and method

Abstract

This invention relates to the field of project cost management technology, specifically to a water conservancy engineering construction cost control system and method. The system includes: a material consumption analysis module, an inventory early warning calculation module, a dynamic inventory adjustment module, a replenishment trigger optimization module, and a consumption stability assessment module. In this invention, by dynamically monitoring the material consumption rate and combining it with construction progress and project quantity calculation data, a consumption trend curve is established. By comparing this curve with actual usage, the deviation in the consumption rate is accurately quantified, enabling real-time assessment of material usage. Supply days are calculated based on inventory data, and the replenishment cycle is matched to dynamically adjust the replenishment time, optimizing inventory levels, reducing capital occupation, assessing stability based on the consumption fluctuation range, calculating the maximum consumption fluctuation value, and dynamically correcting the inventory early warning threshold based on replenishment adjustment needs. This reduces the risk of supply chain disruption, improves the adaptability of construction material management, and enhances the accuracy of cost control.

Description

Technical Field

[0001] This invention relates to the field of project cost management technology, and in particular to a control system and method for construction cost of water conservancy projects. Background Technology

[0002] Project cost management technology encompasses methods and systems for effectively controlling costs during the construction process of engineering projects. The core of this technology involves the dynamic monitoring and management of factors such as engineering materials, labor, machinery and equipment, and construction progress to ensure the project progresses smoothly within budget. Project cost management technology typically achieves the rational allocation of various resources and expenditure control through data collection, cost analysis, budget preparation, and cost allocation. The systematic content of this technology includes multiple stages such as cost estimation, cost control, and cost accounting. By conducting real-time analysis and prediction of cost data during the construction process, it improves the efficiency of fund utilization and reduces unnecessary expenditures.

[0003] The water conservancy project construction cost control system is an information system that manages various cost elements during the construction of water conservancy projects. This system primarily covers the collection, calculation, and analysis of cost data such as labor costs, material costs, and machinery usage fees in water conservancy project construction. It compares actual costs with budgeted costs by setting cost control targets. The system employs a cost accounting method based on the bill of quantities, dynamically adjusting costs at each construction stage and analyzing construction cost trends using historical data. By constructing a cost monitoring model, the system compares the costs of different construction schemes and, considering the specific characteristics of water conservancy project construction, categorizes and processes factors affecting costs, thereby achieving refined cost management.

[0004] Existing technologies rely on cost accounting and budgeting to manage construction costs, but lack precise tracking of real-time fluctuations in material consumption rates, making inventory management difficult to adapt to changing demand. Replenishment cycles depend on experience-based judgment, making timely adjustments difficult when consumption rates fluctuate abnormally, potentially leading to material shortages or stockpiles, impacting construction progress and cash flow efficiency. The lack of quantitative analysis of material consumption stability makes it difficult to predict short-term usage changes, and fixed inventory warning thresholds cannot match dynamic construction needs, resulting in a lack of refined cost control. Summary of the Invention

[0005] The purpose of this invention is to address the shortcomings of existing technologies by proposing a water conservancy engineering construction cost control system and method.

[0006] To achieve the above objectives, the present invention adopts the following technical solution: a water conservancy project construction cost control system includes:

[0007] The material consumption analysis module calculates the material consumption per unit time in multiple construction stages based on the current construction progress data and the engineering quantity calculation data, forming the consumption rate of the construction stage. Combined with the construction plan schedule, it divides the time period, accumulates the theoretical consumption in multiple periods, and obtains the theoretical consumption curve. Based on the on-site material usage records, it matches the time nodes to extract the actual consumption data, establishes the actual consumption curve, compares the two curves, and calculates the consumption rate deviation in the time interval.

[0008] The inventory early warning calculation module calls the consumption rate deviation, combines it with the real-time inventory data of the materials, calculates the time range during which the current inventory can support construction, determines the remaining supply days of the materials, matches the replenishment cycle data, and calculates the inventory support period under the current consumption rate.

[0009] The dynamic inventory adjustment module calls the remaining supply days of materials and the inventory support cycle to determine whether the inventory is tight or surplus, and generates an inventory warning status.

[0010] The replenishment trigger optimization module calls the inventory warning status, combines it with the current inventory level, calculates the adjustment amount for early or delayed replenishment, and obtains the replenishment adjustment amount.

[0011] The consumption stability assessment module calls the consumption rate deviation amount, matches the material consumption fluctuation range within the construction period, calculates the maximum consumption fluctuation value, forms the consumption stability index, and combines it with the replenishment adjustment amount to calculate the adjustment range of the inventory warning threshold, forming a dynamic inventory threshold.

[0012] The consumption rate during the construction phase includes consumption per unit time, time period, and theoretical consumption. The theoretical consumption curve includes time nodes, actual consumption data, and actual consumption curve. The consumption rate deviation specifically includes the comparison result of two curves and the difference in consumption rate within a time interval. The remaining supply days of materials include real-time inventory data, replenishment cycle data, and inventory support period. The inventory warning status includes inventory shortage status, inventory surplus status, and inventory support time range. The replenishment adjustment amount includes early replenishment amount, delayed replenishment amount, and adjusted inventory level. The consumption stability index includes maximum consumption fluctuation value, consumption fluctuation range, and consumption rate deviation. The inventory warning threshold adjustment range includes replenishment adjustment amount, inventory warning status, and dynamic inventory threshold.

[0013] As a further aspect of the present invention, the material consumption analysis module includes:

[0014] The phase consumption rate calculation submodule calculates the unit time consumption of materials in multiple construction phases based on the current construction progress data and the engineering quantity calculation data. It matches the construction progress data of multiple construction phases with the calculated engineering quantity data, calculates the consumption value per unit time for each phase, and collects the data of all construction phases to obtain the unit time consumption rate of multiple construction phases.

[0015] The theoretical consumption curve construction submodule calls the unit time consumption rate of the multiple construction stages, combines it with the construction schedule, divides the time period, and accumulates the material consumption within multiple time periods using the following formula:

[0016] ;

[0017] The calculation obtains the cumulative consumption over multiple time periods and generates a theoretical consumption curve.

[0018] in, Represents the theoretical consumption curve value. The consumption rate of the representative stage. Represents the duration of a stage. Represents the construction progress correction factor. This represents the amount of material consumed in the construction plan. Represents actual consumption. Represents the number of construction stages;

[0019] The consumption rate deviation calculation submodule, based on the theoretical consumption curve, extracts actual material consumption data from the field at matching time points, compares the theoretical and actual consumption data, and calculates the consumption rate deviation.

[0020] As a further aspect of the present invention, the inventory early warning calculation module includes:

[0021] The consumption rate calculation submodule calls the material consumption rate deviation, combines it with real-time inventory data, calculates the actual material consumption rate per unit time, and obtains the average material consumption rate by calculating the average consumption over multiple time periods.

[0022] The inventory support period calculation submodule calculates the time range that the current inventory can support based on the average consumption rate of the material, using the following formula:

[0023] ;

[0024] The calculation determines the inventory support cycle;

[0025] in, This indicates that inventory can support the cycle. Represents the current inventory level. Representing the past The cumulative waste loss within a time period This represents the average consumption rate. This represents the fluctuation value of the consumption rate. This represents the difference between the maximum consumption rate and the average consumption rate. This represents the total number of past monitoring periods.

[0026] As a further aspect of the present invention, the dynamic inventory adjustment module includes:

[0027] The inventory status determination submodule calls the remaining supply days of the material and the inventory support period to calculate the inventory balance ratio, determine whether the inventory status is in a tight or surplus state, and calculate to obtain the inventory status category.

[0028] The inventory early warning calculation submodule uses the following formula based on the inventory status category:

[0029] ;

[0030] Calculate and obtain the inventory warning index;

[0031] in, Represents the inventory warning index. Represents the remaining supply days of materials. This indicates that inventory can support the cycle. Representing the past Total inventory fluctuations within a given time period This represents the cumulative excess consumption. Represents the current inventory level;

[0032] The inventory warning generation submodule sets the inventory warning threshold, determines the inventory warning level, and outputs the inventory warning status based on the inventory warning index.

[0033] As a further aspect of the present invention, the replenishment triggering optimization module includes:

[0034] The inventory status adjustment submodule calls the aforementioned inventory warning status, combines it with the current inventory level, determines whether the replenishment plan needs to be adjusted, and calculates and obtains the inventory adjustment requirements.

[0035] The replenishment adjustment calculation submodule calculates the adjustment amount for early or delayed replenishment based on the aforementioned inventory adjustment requirements, using the following formula:

[0036] ;

[0037] Calculate and obtain the replenishment adjustment quantity;

[0038] in, This represents the replenishment adjustment quantity. This indicates that inventory can support the cycle. Represents the remaining supply days of materials. This represents the average consumption rate. Representing the past The cumulative replenishment volume within a certain time period Represents inventory fluctuations. Represents the current inventory level. This represents the total number of observation periods.

[0039] As a further aspect of the present invention, the consumption stability assessment module includes:

[0040] The consumption fluctuation calculation submodule calls the consumption rate deviation, matches the material consumption fluctuation range within the construction period, calculates the consumption change value within multiple time intervals, compares the difference between the maximum and minimum consumption rates, and calculates the maximum consumption fluctuation value.

[0041] The consumption stability determination submodule uses the formula based on the maximum consumption fluctuation value:

[0042] ;

[0043] The stability index of computational consumption is obtained;

[0044] in, This represents the stability index of consumption. Represents the maximum consumption rate. Represents the minimum consumption rate. Representing the past The cumulative abnormal consumption within a time period. Represents the total number of monitoring periods. This represents the fluctuation range of consumption. This represents the average consumption rate. This represents excess consumption. Represents the construction period;

[0045] The inventory threshold adjustment submodule calculates the adjustment range of the inventory warning threshold based on the consumption stability index and the replenishment adjustment amount, adjusts the inventory warning threshold, and generates a dynamic inventory threshold.

[0046] A method for controlling the construction cost of water conservancy projects, wherein the method is implemented based on the aforementioned water conservancy project construction cost control system, and includes the following steps:

[0047] S1: Obtain construction progress data, engineering quantity calculation data and material usage data, calculate the material consumption per unit time in multiple construction stages, combine with the construction plan schedule, divide the time period, accumulate the theoretical consumption of multiple periods, obtain the theoretical material consumption curve, match the time node to extract the on-site material consumption data, calculate the actual material consumption change, obtain the actual material consumption curve, compare the consumption rate deviation between the two within the calculated time interval, and obtain the material consumption rate deviation value.

[0048] S2: Call the material consumption rate deviation value, obtain real-time inventory data, calculate the construction time range that the current inventory can support, obtain the remaining supply days of materials, obtain replenishment cycle data, calculate the time period that the inventory can maintain under the current consumption rate, and obtain the inventory support period.

[0049] S3: Call the inventory support period, obtain the material warning threshold, determine whether the inventory status is in a tight or surplus range, match the inventory safety benchmark, classify the inventory status, and obtain the inventory warning status.

[0050] S4: Call the inventory warning status, combine it with the current inventory level of the material, obtain the replenishment threshold adjustment parameter, calculate the adjustment amount for early or delayed replenishment, and obtain the material replenishment adjustment amount;

[0051] S5: Call the material consumption rate deviation value, match the material consumption fluctuation range within the construction period, calculate the maximum consumption fluctuation value, form the consumption stability index, combine the material replenishment adjustment amount, calculate the inventory warning threshold adjustment range, and obtain the dynamic inventory threshold.

[0052] Compared with the prior art, the advantages and positive effects of the present invention are as follows:

[0053] This invention dynamically monitors material consumption rates, combines construction progress and project quantity calculation data to establish a consumption trend curve, and compares it with actual usage to accurately quantify consumption rate deviations, achieving real-time assessment of material usage. It calculates supply days based on inventory data, matches replenishment cycles, dynamically adjusts replenishment times, optimizes inventory levels, and reduces capital occupation. It assesses stability based on consumption fluctuation ranges, calculates maximum consumption fluctuation values, and dynamically corrects inventory warning thresholds based on replenishment adjustment needs, reducing supply chain disruption risks, improving the adaptability of construction material management, and enhancing cost control accuracy. Attached Figure Description

[0054] Figure 1 This is a system flowchart of the present invention;

[0055] Figure 2 This is a flowchart of the material consumption analysis module of the present invention;

[0056] Figure 3This is a flowchart of the inventory early warning calculation module of the present invention;

[0057] Figure 4 This is a flowchart of the dynamic inventory adjustment module of the present invention;

[0058] Figure 5 This is a flowchart of the replenishment trigger optimization module of the present invention;

[0059] Figure 6 This is a flowchart of the stability assessment module of the present invention. Detailed Implementation

[0060] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the invention.

[0061] In the description of this invention, it should be understood that the terms "length," "width," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," and "outer," etc., indicating orientation or positional relationships, are based on the orientation or positional relationships shown in the accompanying drawings and are only for the convenience of describing the invention and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation, and therefore should not be construed as a limitation of the invention. Furthermore, in the description of this invention, "a plurality of" means two or more, unless otherwise explicitly specified.

[0062] Example 1: Please refer to Figure 1 The present invention provides a technical solution: a water conservancy project construction cost control system comprising:

[0063] The material consumption analysis module calculates the material consumption per unit time in multiple construction stages based on the current construction progress data and the engineering quantity calculation data, forming the consumption rate of the construction stage. Combined with the construction plan schedule, it divides the time period, accumulates the theoretical consumption in multiple periods, and obtains the theoretical consumption curve. Based on the on-site material usage records, it matches the time nodes to extract the actual consumption data, establishes the actual consumption curve, compares the two curves, and calculates the consumption rate deviation in the time interval.

[0064] The inventory early warning calculation module calls the consumption rate deviation, combines it with the real-time inventory data of the materials, calculates the time range during which the current inventory can support construction, determines the remaining supply days of the materials, matches the replenishment cycle data, and calculates the inventory support period under the current consumption rate.

[0065] The dynamic inventory adjustment module calls the remaining supply days of materials and the inventory support cycle to determine whether the inventory is tight or surplus, and generates an inventory warning status.

[0066] The replenishment trigger optimization module calls the inventory warning status, combines it with the current inventory level, calculates the adjustment amount for early or delayed replenishment, and obtains the replenishment adjustment amount.

[0067] The consumption stability assessment module calls the consumption rate deviation amount, matches the material consumption fluctuation range within the construction period, calculates the maximum consumption fluctuation value, forms the consumption stability index, and combines it with the replenishment adjustment amount to calculate the adjustment range of the inventory warning threshold, forming a dynamic inventory threshold.

[0068] The consumption rate during the construction phase includes consumption per unit time, time period, and theoretical consumption. The theoretical consumption curve includes time nodes, actual consumption data, and actual consumption curve. The consumption rate deviation specifically includes the comparison result of two curves and the difference in consumption rate within a time interval. The remaining supply days of materials include real-time inventory data, replenishment cycle data, and inventory support period. The inventory warning status includes inventory shortage status, inventory surplus status, and inventory support time range. The replenishment adjustment amount includes early replenishment amount, delayed replenishment amount, and adjusted inventory level. The consumption stability index includes maximum consumption fluctuation value, consumption fluctuation range, and consumption rate deviation. The inventory warning threshold adjustment range includes replenishment adjustment amount, inventory warning status, and dynamic inventory threshold.

[0069] Please see Figure 2 The material consumption analysis module includes:

[0070] The phase consumption rate calculation submodule calculates the unit time consumption of materials in multiple construction phases based on the current construction progress data and the engineering quantity calculation data. It matches the construction progress data of multiple construction phases with the calculated engineering quantity data, calculates the consumption value per unit time for each phase, and collects the data of all construction phases to obtain the unit time consumption rate of multiple construction phases.

[0071] First, the progress data from the construction site is read and analyzed. This data includes the progress of each construction stage, the time nodes of construction tasks, and the amount of work completed. Simultaneously, the project quantity calculation data is compared to ensure that the construction plan corresponds to the actual project quantity data. For each construction stage, the start time, end time, and corresponding project quantity information are extracted, and the construction quantity per unit time is calculated. For example, if the construction task of a certain stage is pouring concrete, assuming the planned construction time for this stage is 10 days and the total construction quantity is 500 cubic meters, then the consumption per unit time is calculated as 500 / 10 = 50. The consumption rate was calculated based on the material consumption at different construction stages. Specifically, the unit time consumption values ​​for different stages were aggregated. For example, if the steel reinforcement consumption in the first stage was 600 kg and the duration was 5 days, the unit time consumption rate would be 600 / 5 = 120 kg / day. If the concrete consumption in the second stage was 500 cubic meters and the duration was 10 days, the unit time consumption rate would be 50 cubic meters / day. Finally, the consumption rates for all construction stages were aggregated to form the unit time consumption rate data for multiple construction stages, as shown in Table 1.

[0072] Table 1. Consumption Rate per Unit Time for Multiple Construction Stages

[0073] ;

[0074] As shown in Table 1, the unit time consumption rate for different construction stages has been calculated. By collecting these data, the unit time consumption rate for multiple construction stages can be obtained, forming a complete construction consumption dataset, which can be used to construct theoretical consumption curves in the future.

[0075] The theoretical consumption curve construction submodule calls the unit time consumption rate of the multiple construction stages, combines it with the construction schedule, divides the time period, and accumulates the material consumption within multiple time periods using the following formula:

[0076] ;

[0077] The calculation obtains the cumulative consumption over multiple time periods and generates a theoretical consumption curve.

[0078] in, Represents the theoretical consumption curve value. The consumption rate of the representative stage. Represents the duration of a stage. Represents the construction progress correction factor. This represents the amount of material consumed in the construction plan. Represents actual consumption. Represents the number of construction stages;

[0079] First, determine the construction time cycle and divide the overall construction time into multiple time intervals. For example, a construction cycle of 30 days can be divided into six 5-day cycles. Within each cycle, calculate the total material consumption based on the consumption rate per unit time. Taking the first cycle as an example, assuming it includes the first and second stages, the material consumption for this cycle is calculated as follows: the steel reinforcement consumption for the first stage (5 days) is 120 kg / day × 5 days = 600 kg, and the concrete consumption for the second stage (5 days) is 50 m³ / day × 5 days = 250 m³. Then, accumulate the calculations for all cycles, and introduce a construction progress correction factor during the calculation process. This is used to correct material consumption errors caused by deviations in construction schedule. For example, if the actual construction progress at a certain stage is 10% behind the planned progress, then the correction factor is used. Take 0.9 and calculate the corrected consumption amount, such as the planned consumption amount for a certain period. For 100m³, the actual consumption If the volume is 90m³, then the corrected calculation is as follows: The final formula adopted is:

[0080] ;

[0081] Substitute the data into the calculation, and assume... =2, =120kg / day =5 days =50m³ / day =5 days =0.9, =0.95, =600kg, =580kg, =250m3, =240m³, calculated as follows:

[0082] ;

[0083] ;

[0084] ;

[0085] Finally, the theoretical consumption curve value was obtained. =836.31.

[0086] The calculation results show that, within the set construction period, based on the unit time consumption rate of each construction stage, the length of construction time, the construction progress correction factor, and the difference between planned and actual consumption, the theoretical consumption curve value is 836.31. This value represents the theoretical cumulative consumption of materials under the current construction schedule.

[0087] The consumption rate deviation calculation submodule, based on the theoretical consumption curve, extracts actual material consumption data from the field at matching time points, compares the theoretical and actual consumption data, and calculates the consumption rate deviation.

[0088] First, establish a construction timeline, dividing the construction period into days. For example, if the construction period is 30 days, record the actual material consumption for each construction stage daily and compare it with the theoretical consumption data to calculate the consumption rate deviation. Set a baseline value, assuming a baseline deviation threshold of ±5%. If the actual consumption rate deviation exceeds this range, the construction plan needs to be adjusted or the material supply needs to be supplemented. Taking concrete consumption in a certain construction stage as an example, the theoretical consumption rate is 50 m³ / day, and the actual consumption rate is 45 m³ / day. Calculate the deviation:

[0089] ;

[0090] ;

[0091] If the deviation is 10% and exceeds the benchmark value of ±5%, the construction schedule needs to be adjusted or the material supply needs to be optimized. If the deviation is small, such as ±3%, it can be considered to be within the normal range, as shown in Table 2.

[0092] Table 2 Deviation of Consumption Rate During Construction Phase

[0093] ;

[0094] As shown in Table 2, the consumption rate deviations at different construction stages have been calculated. For cases exceeding the benchmark value, corresponding adjustments need to be made to ensure the rational allocation of construction resources.

[0095] Please see Figure 3 The inventory early warning calculation module includes:

[0096] The consumption rate calculation submodule calls the material consumption rate deviation, combines it with real-time inventory data, calculates the actual material consumption rate per unit time, and obtains the average material consumption rate by calculating the average consumption over multiple time periods.

[0097] In the specific implementation process, the material consumption data for a certain period of time is first obtained, including used materials and consumed materials. When calculating the deviation of the material consumption rate, it is necessary to compare the consumption data at multiple time points to obtain the deviation at the current moment. The material consumption data can be collected by sensors in the production system or the inventory management system, while real-time inventory data is provided by the warehouse management system. When calculating the actual material consumption rate per unit time, a fixed time interval is first selected, such as 1 hour or 24 hours, and the net consumption of materials within that time period is calculated. This net consumption is obtained by subtracting the recovery from the usage. At the same time, combined with the current inventory data, the hourly or daily consumption rate is calculated. When calculating the average consumption over multiple time periods, an appropriate time window is first selected, such as the last 7 days, 30 days, or longer. The consumption rate data in each time interval are accumulated and averaged to obtain the average material consumption rate. In actual operation, for example, if a factory's daily material consumption rates for the past 7 days are 5.2, 4.8, 5.0, 5.1, 4.9, 5.3, and 5.2 tons / day, the average material consumption rate is calculated as follows:

[0098] tons / day;

[0099] Through this calculation process, the current average consumption rate of materials can be determined to be 5.07 tons / day.

[0100] The inventory support period calculation submodule calculates the time range that the current inventory can support based on the average consumption rate of the material, using the following formula:

[0101] ;

[0102] The calculation yields inventory that can support a certain period of time.

[0103] in, This indicates that inventory can support the cycle. Represents the current inventory level. Representing the past The cumulative waste loss within a time period This represents the average consumption rate. This represents the fluctuation value of the consumption rate. This represents the difference between the maximum consumption rate and the average consumption rate. This represents the total number of past monitoring periods.

[0104] formula:

[0105] ;

[0106] In the specific execution process, the current inventory level is first obtained. This data can be provided in real time by the inventory management system. For example, if the factory's current inventory is 100 tons, then the cumulative scrap loss can be calculated. Assuming the waste losses over the past 7 days were 0.3, 0.4, 0.2, 0.5, 0.3, 0.4, and 0.3 tons respectively, then:

[0107] ton;

[0108] Then calculate the consumption rate fluctuation value. This value represents the standard deviation of the consumption rate from the average consumption rate for each time period. Assuming its calculated result is 0.2 tons / day, the maximum consumption rate is also calculated. Assuming the highest consumption rate over the past 30 days was 5.5 tons / day, then:

[0109] tons / day;

[0110] Assuming the total number of past monitoring periods If the value is 30, then:

[0111] tons / day;

[0112] Substitute all parameters into the formula:

[0113] sky;

[0114] The calculation shows that, under the current inventory levels and consumption rates, the inventory can last for 18.24 days.

[0115] Please see Figure 4 The dynamic inventory adjustment module includes:

[0116] The inventory status determination submodule calls the remaining supply days of the material and the inventory support period to calculate the inventory balance ratio, determine whether the inventory status is in a tight or surplus state, and calculate to obtain the inventory status category.

[0117] First, retrieve the remaining supply days of the material. and inventory can support the cycle These represent the estimated number of days the inventory can last under the current inventory status and the estimated number of days it can last under normal consumption conditions, respectively. After calling these two parameters, a ratio is calculated, i.e., the inventory balance ratio. Based on this, the tightness or surplus of inventory is determined. Specifically, if the ratio is lower than a certain set threshold... If the ratio is higher than a set threshold, the inventory is considered to be in a state of shortage; If the inventory is in a surplus state, the threshold is considered to be met. and The settings should be based on historical data and industry experience. For example, a manufacturing company may set a shortage threshold for key components. In other words, when the remaining days of inventory are less than 70% of the inventory's lifespan, it is considered a tight situation. The determination of a surplus situation may be based on a different set threshold. In other words, when the remaining days of inventory exceed 130% of the inventory's sustainable period, it is considered overstocked. The key to setting a reasonable threshold lies in considering the company's actual supply chain management situation, such as the stability of production plans and supplier delivery cycles. A calculation example is as follows: if a material currently has a remaining supply of... Days, and inventory can support the cycle. If the inventory balance ratio is:

[0118] ;

[0119] At this point, since 0.8 is between 0.7 and 1.3, the inventory status is normal. If the calculated inventory balance ratio is less than 0.7, that is... If the calculated result is greater than 1.3, then the inventory is considered tight. If the inventory is sufficient, then it is determined that there is a surplus. This calculation process can be further refined for different industries. For example, the automotive manufacturing industry may have even stricter thresholds for the shortage of key chips. The consumer electronics industry may set more lenient thresholds, such as... The results of this inventory status determination will be directly used for inventory early warning calculations.

[0120] The inventory early warning calculation submodule uses the following formula based on the inventory status category:

[0121] ;

[0122] Calculate and obtain the inventory warning index;

[0123] in, Represents the inventory warning index. Represents the remaining supply days of materials. This indicates that inventory can support the cycle. Representing the past Total inventory fluctuations within a given time period This represents the cumulative excess consumption. Represents the current inventory level;

[0124] formula:

[0125] ;

[0126] in, This represents the inventory warning index; the higher the value, the more significant the inventory fluctuations, and the higher the warning level. , These are the remaining supply days of materials and the inventory's sustaining period, respectively. The absolute value of their difference reflects the degree of deviation between the current inventory status and the normal level. This indicates excess inventory, and conversely, a shortage of inventory. The denominator... Reflecting the total amount of inventory fluctuations in the past The impact of each time period, among which This represents the total historical inventory fluctuation. This value can be calculated using historical inventory data. For example, if the inventory fluctuation over the past three months was 100, 120, and 90 units respectively, then:

[0127] ;

[0128] at the same time, This represents the cumulative excess consumption, i.e., the amount of inventory consumed beyond the predicted consumption. It can be calculated using historical data. For example, if the predicted consumption is 500 units and the actual consumption is 600 units, then:

[0129] ;

[0130] This represents the current inventory level. For example, if the current inventory is 800 units, then... Assuming sky, Day, calculation:

[0131] ;

[0132] ;

[0133] ;

[0134] ;

[0135] The threshold setting for the inventory warning index needs to be combined with industry standards. For example, for key components, if... That is, early warning is needed, if This indicates a high alert status. The calculated value of 0.298 is lower than 0.5, therefore no alert was triggered.

[0136] The inventory warning generation submodule sets the inventory warning threshold, determines the inventory warning level, and outputs the inventory warning status based on the inventory warning index.

[0137] First, set an inventory warning threshold. , , To differentiate inventory risk levels, for example:

[0138] ;

[0139] Inventory warning levels are classified according to different thresholds, as shown in Table 3.

[0140] Table 3 Inventory Early Warning Level Classification Table

[0141] ;

[0142] As shown in Table 3, when The calculated value of 0.298 is less than 0.3, so the inventory warning status is normal. If the inventory enters a low alert state, then... Then it enters a medium-alert state. Then it enters a high-alert state. This alert information can be used to make decisions on inventory replenishment or adjustment strategies, and can be dynamically optimized based on the actual situation.

[0143] Please see Figure 5 The replenishment trigger optimization module includes:

[0144] The inventory status adjustment submodule calls the aforementioned inventory warning status, combines it with the current inventory level, determines whether the replenishment plan needs to be adjusted, and calculates and obtains the inventory adjustment requirements.

[0145] First, we need to statistically analyze the current inventory level and record the existing inventory quantity. Simultaneously calculate inventory fluctuation. Inventory volatility can be calculated as the standard deviation of inventory levels over a certain period. For example, if the inventory levels for the most recent 10 days are 500, 520, 480, 490, 510, 495, 505, 515, 500, and 510, then the standard deviation of inventory volatility can be calculated. Secondly, calculate the inventory's lifespan. By average consumption rate Based on the calculations, if the consumption over the past 7 days was 50, 52, 48, 49, 51, 50, 50, then the average consumption rate would be... Units per day; this is used to calculate the inventory's lifespan. If the current inventory level ,but At the same time, obtain the remaining supply days of materials. If the current order arrives in 3 days, that is Heaven, then judge Does the absolute value exceed the safety stock threshold? For example, if the threshold is set to 5 days, then... If the number of days exceeds the threshold, the replenishment plan needs to be adjusted. If the value is less than or equal to the threshold, no adjustment is needed. Finally, calculate the inventory adjustment requirement. If the quantity exceeds the safety threshold, reduce the replenishment quantity. If the quantity exceeds the safety threshold, the replenishment quantity will be increased.

[0146] The replenishment adjustment calculation submodule calculates the adjustment amount for early or delayed replenishment based on the aforementioned inventory adjustment requirements, using the following formula:

[0147] ;

[0148] Calculate and obtain the replenishment adjustment quantity;

[0149] in, This represents the replenishment adjustment quantity. This indicates that inventory can support the cycle. Represents the remaining supply days of materials. This represents the average consumption rate. Representing the past The cumulative replenishment volume within a certain time period Represents inventory fluctuations. Represents the current inventory level. This represents the total number of observation periods.

[0150] formula:

[0151] ;

[0152] First, obtain the absolute value of the inventory adjustment demand. As in the previous example Then calculate the inventory adjustment amount. The molecular part, namely Assuming the past Cumulative replenishment volume within the day Then calculate the numerator:

[0153] ;

[0154] Then calculate the denominator, i.e. Assuming the total number of observation periods Heaven, then:

[0155] ;

[0156] at the same time, Therefore, the denominator is calculated as follows:

[0157] ;

[0158] Final calculation of replenishment adjustment quantity:

[0159] ;

[0160] The results indicate that, based on the current inventory status and replenishment plan adjustment requirements, the calculated replenishment adjustment amount is 201.1 units. This amount can be further determined by combining the replenishment batch setting and rounding to the minimum replenishment unit.

[0161] Please see Figure 6 The consumption stability assessment module includes:

[0162] The consumption fluctuation calculation submodule calls the consumption rate deviation, matches the material consumption fluctuation range within the construction period, calculates the consumption change value within multiple time intervals, compares the difference between the maximum and minimum consumption rates, and calculates the maximum consumption fluctuation value.

[0163] First, obtain the material consumption rate for each time period within the construction cycle. These data can be obtained through sensors at the construction site or through manual statistics, forming a time-series dataset. Then, the consumption rate for all time periods is calculated to obtain the maximum consumption rate. and minimum consumption rate These correspond to the maximum and minimum material consumption, respectively. For example, in a construction project, the hourly material consumption data is as follows:

[0164] Through calculation, it can be obtained tons / hour The rate is calculated in tons per hour, followed by the calculation of the fluctuation range of material consumption during the construction period. This fluctuation range is determined by the difference between the maximum and minimum consumption rates. Tons / hour, and then calculate the consumption change value based on data from multiple time intervals. First, divide the construction period into multiple time periods, such as 5 days, and calculate the consumption change each day. Assume the daily consumption is as follows: If the value is in tons, then the daily consumption change can be calculated. ,like tons, calculate all in sequence Then sum them up to obtain the cumulative abnormal consumption. Ultimately, the maximum consumption fluctuation value is determined by the sum of the maximum and minimum rate differences calculated above and the consumption changes in each time period. In this example, the cumulative abnormal consumption is 50 tons, which can be used for the next step of calculating the consumption stability index.

[0165] The consumption stability determination submodule uses the formula based on the maximum consumption fluctuation value:

[0166] ;

[0167] The stability index of computational consumption is obtained;

[0168] in, This represents the stability index of consumption. Represents the maximum consumption rate. Represents the minimum consumption rate. Representing the past Cumulative abnormal consumption within a time period Represents the total number of monitoring periods. This represents the fluctuation range of consumption. This represents the average consumption rate. This represents excess consumption. Represents the construction period;

[0169] formula:

[0170] ;

[0171] First, determine the total number of monitoring periods. Assuming a construction period of 30 days and data collection once a day, then Next, calculate the fluctuation range of consumption. This value is the ratio of the maximum consumption rate to the average consumption rate. If the average consumption rate... If it is 14 tons / hour, then Then calculate the excess consumption. If the actual excess consumption is 80 tons within a 30-day construction period, then tons, construction period Let's substitute the formula:

[0172] ;

[0173] Calculate the values ​​of each part. , , The final calculation result is:

[0174] ;

[0175] This value can be used to determine the level of consumption stability. Assuming the consumption stability index is graded as follows:

[0176] High stability - Moderate stability;

[0177] Low stability, in this example This indicates that the consumption process is in a state of low stability.

[0178] The inventory threshold adjustment submodule calculates the adjustment range of the inventory warning threshold based on the consumption stability index and the replenishment adjustment amount, adjusts the inventory warning threshold, and generates a dynamic inventory threshold.

[0179] First, set the initial inventory warning threshold. Assuming an initial value of 500 tons, the replenishment adjustment amount Depending on the abnormal consumption and replenishment needs during construction, assuming a replenishment adjustment of 80 tons, the inventory warning threshold will be adjusted accordingly. Calculated as follows:

[0180] ;

[0181] Set adjustment coefficient , Substitute the data:

[0182] ;

[0183] Ultimately, the new inventory warning threshold is calculated as follows:

[0184] ;

[0185] The adjusted inventory warning threshold is 598 tons, which can be used for dynamic inventory management to adapt to fluctuations in material consumption.

[0186] Table 4: Material Consumption Data During the Construction Period

[0187] ;

[0188] As shown in Table 4, the daily material consumption and its changes are used to calculate the cumulative abnormal consumption. The value in tons is used to calculate the consumption stability index.

[0189] A method for controlling the construction cost of water conservancy projects, wherein the method is implemented based on the aforementioned water conservancy project construction cost control system, and includes the following steps:

[0190] S1: Obtain construction progress data, engineering quantity calculation data and material usage data, calculate the material consumption per unit time in multiple construction stages, combine with the construction plan schedule, divide the time period, accumulate the theoretical consumption of multiple periods, obtain the theoretical material consumption curve, match the time node to extract the on-site material consumption data, calculate the actual material consumption change, obtain the actual material consumption curve, compare the consumption rate deviation between the two within the calculated time interval, and obtain the material consumption rate deviation value.

[0191] S2: Call the material consumption rate deviation value, obtain real-time inventory data, calculate the construction time range that the current inventory can support, obtain the remaining supply days of materials, obtain replenishment cycle data, calculate the time period that the inventory can maintain under the current consumption rate, and obtain the inventory support period.

[0192] S3: Call the inventory support period, obtain the material warning threshold, determine whether the inventory status is in a tight or surplus range, match the inventory safety benchmark, classify the inventory status, and obtain the inventory warning status.

[0193] S4: Call the inventory warning status, combine it with the current inventory level of the material, obtain the replenishment threshold adjustment parameter, calculate the adjustment amount for early or delayed replenishment, and obtain the material replenishment adjustment amount;

[0194] S5: Call the material consumption rate deviation value, match the material consumption fluctuation range within the construction period, calculate the maximum consumption fluctuation value, form the consumption stability index, combine the material replenishment adjustment amount, calculate the inventory warning threshold adjustment range, and obtain the dynamic inventory threshold.

[0195] The above are merely preferred embodiments of the present invention and are not intended to limit the present invention in any other way. Any person skilled in the art may make changes or modifications to the above-disclosed technical content to create equivalent embodiments that can be applied to other fields. However, any simple modifications, equivalent changes, and modifications made to the above embodiments based on the technical essence of the present invention without departing from the scope of the present invention shall still fall within the protection scope of the present invention.

Claims

1. A construction cost control system for water conservancy projects, characterized in that, The system includes: The material consumption analysis module calculates the material consumption per unit time in multiple construction stages based on the current construction progress data and the engineering quantity calculation data, forming the consumption rate of the construction stage. Combined with the construction plan schedule, it divides the time period, accumulates the theoretical consumption in multiple periods, and obtains the theoretical consumption curve. Based on the on-site material usage records, it matches the time nodes to extract the actual consumption data, establishes the actual consumption curve, compares the two curves, and calculates the consumption rate deviation in the time interval. The material consumption analysis module includes: The phase consumption rate calculation submodule calculates the unit time consumption of materials in multiple construction phases based on the current construction progress data and the engineering quantity calculation data. It matches the construction progress data of multiple construction phases with the calculated engineering quantity data, calculates the consumption value per unit time for each phase, and collects the data of all construction phases to obtain the unit time consumption rate of multiple construction phases. The theoretical consumption curve construction submodule calls the unit time consumption rate of the multiple construction stages, combines it with the construction schedule, divides the time period, and accumulates the material consumption within multiple time periods using the following formula: ； The calculation obtains the cumulative consumption over multiple time periods and generates a theoretical consumption curve. in, Represents the theoretical consumption curve value. The rate of consumption at the representative stage. Represents the duration of a stage. Represents the construction progress correction factor. This represents the amount of material consumed in the construction plan. Represents actual consumption. Represents the number of construction stages; The consumption rate deviation calculation submodule, based on the theoretical consumption curve, extracts actual material consumption data from the field at matching time points, compares the theoretical and actual consumption data, and calculates the consumption rate deviation. The inventory early warning calculation module calls the consumption rate deviation, combines it with the real-time inventory data of the materials, calculates the time range during which the current inventory can support construction, determines the remaining supply days of the materials, matches the replenishment cycle data, and calculates the inventory support period under the current consumption rate. The dynamic inventory adjustment module calls the remaining supply days of materials and the inventory support cycle to determine whether the inventory is tight or surplus, and generates an inventory warning status. The replenishment trigger optimization module calls the inventory warning status, combines it with the current inventory level, calculates the adjustment amount for early or delayed replenishment, and obtains the replenishment adjustment amount. The consumption stability assessment module calls the consumption rate deviation amount, matches the material consumption fluctuation range within the construction period, calculates the maximum consumption fluctuation value, forms the consumption stability index, and combines it with the replenishment adjustment amount to calculate the adjustment range of the inventory warning threshold, forming a dynamic inventory threshold.

2. The water conservancy project construction cost control system according to claim 1, characterized in that, The consumption rate during the construction phase includes consumption per unit time, time period, and theoretical consumption. The theoretical consumption curve includes time nodes, actual consumption data, and actual consumption curve. The consumption rate deviation specifically includes the comparison result of two curves and the difference in consumption rate within a time interval. The remaining supply days of materials include real-time inventory data, replenishment cycle data, and inventory support period. The inventory warning status includes inventory shortage status, inventory surplus status, and inventory support time range. The replenishment adjustment amount includes early replenishment amount, delayed replenishment amount, and adjusted inventory level. The consumption stability index includes maximum consumption fluctuation value, consumption fluctuation range, and consumption rate deviation. The inventory warning threshold adjustment range includes replenishment adjustment amount, inventory warning status, and dynamic inventory threshold.

3. The water conservancy project construction cost control system according to claim 2, characterized in that, The inventory early warning calculation module includes: The consumption rate calculation submodule calls the consumption rate deviation amount, combines it with real-time inventory data, calculates the actual consumption rate of materials per unit time, and obtains the average consumption rate of materials by calculating the average consumption over multiple time periods. The inventory support period calculation submodule calculates the time range that the current inventory can support based on the average consumption rate of the material, using the following formula: ； The calculation determines the inventory support cycle; in, This indicates that inventory can support the cycle. Represents the current inventory level. This indicates that inventory can support the cycle. Represents the current inventory level. Representing the past The cumulative waste loss within a time period This represents the average consumption rate. This represents the fluctuation value of the consumption rate. This represents the difference between the maximum consumption rate and the average consumption rate. This represents the total number of past monitoring periods.

4. The water conservancy project construction cost control system according to claim 3, characterized in that, The dynamic inventory adjustment module includes: The inventory status determination submodule calls the remaining supply days of the material and the inventory support period to calculate the inventory balance ratio, determine whether the inventory status is in a tight or surplus state, and calculate to obtain the inventory status category. The inventory early warning calculation submodule uses the following formula based on the inventory status category: ； Calculate and obtain the inventory warning index; in, Represents the inventory warning index. Represents the remaining supply days of materials. This indicates that inventory can support the cycle. Representing the past Total inventory fluctuations within a given time period This represents the cumulative excess consumption. Represents the current inventory level; The inventory warning generation submodule sets the inventory warning threshold, determines the inventory warning level, and outputs the inventory warning status based on the inventory warning index.

5. The water conservancy project construction cost control system according to claim 4, characterized in that, The replenishment trigger optimization module includes: The inventory status adjustment submodule calls the aforementioned inventory warning status, combines it with the current inventory level, determines whether the replenishment plan needs to be adjusted, and calculates and obtains the inventory adjustment requirements. The replenishment adjustment calculation submodule calculates the adjustment amount for early or delayed replenishment based on the aforementioned inventory adjustment requirements, using the following formula: ； Calculate and obtain the replenishment adjustment quantity; in, This represents the replenishment adjustment quantity. This indicates that inventory can support the cycle. Represents the remaining supply days of materials. This represents the average consumption rate. Representing the past The cumulative replenishment volume within a certain time period Represents inventory fluctuations. Represents the current inventory level. This represents the total number of observation periods.

6. The water conservancy project construction cost control system according to claim 5, characterized in that, The consumption stability assessment module includes: The consumption fluctuation calculation submodule calls the consumption rate deviation, matches the material consumption fluctuation range within the construction period, calculates the consumption change value within multiple time intervals, compares the difference between the maximum and minimum consumption rates, and calculates the maximum consumption fluctuation value. The consumption stability determination submodule uses the formula based on the maximum consumption fluctuation value: ； The stability index of computational consumption is obtained; in, This represents the stability index of consumption. Represents the maximum consumption rate. Represents the minimum consumption rate. Representing the past Cumulative abnormal consumption within a time period Represents the total number of monitoring periods. This represents the fluctuation range of consumption. This represents the average consumption rate. This represents excess consumption. Represents the construction period; The inventory threshold adjustment submodule calculates the adjustment range of the inventory warning threshold based on the consumption stability index and the replenishment adjustment amount, adjusts the inventory warning threshold, and generates a dynamic inventory threshold.

7. A method for controlling construction costs in water conservancy projects, characterized in that, The water conservancy project construction cost control system according to any one of claims 1-6 shall be implemented. Includes the following steps: S1: Obtain construction progress data, engineering quantity calculation data and material usage data, calculate the material consumption per unit time in multiple construction stages, combine with the construction plan schedule, divide the time period, accumulate the theoretical consumption of multiple periods, obtain the theoretical material consumption curve, match the time node to extract the on-site material consumption data, calculate the actual material consumption change, obtain the actual material consumption curve, compare the consumption rate deviation between the two within the calculated time interval, and obtain the material consumption rate deviation value. S2: Call the material consumption rate deviation value, obtain real-time inventory data, calculate the construction time range that the current inventory can support, obtain the remaining supply days of materials, obtain replenishment cycle data, calculate the time period that the inventory can maintain under the current consumption rate, and obtain the inventory support period. S3: Call the inventory support period, obtain the material warning threshold, determine whether the inventory status is in a tight or surplus range, match the inventory safety benchmark, classify the inventory status, and obtain the inventory warning status. S4: Call the inventory warning status, combine it with the current inventory level of the material, obtain the replenishment threshold adjustment parameter, calculate the adjustment amount for early or delayed replenishment, and obtain the material replenishment adjustment amount; S5: Call the material consumption rate deviation value, match the material consumption fluctuation range within the construction period, calculate the maximum consumption fluctuation value, form the consumption stability index, combine the material replenishment adjustment amount, calculate the inventory warning threshold adjustment range, and obtain the dynamic inventory threshold.

Images