Hydraulic engineering construction cost control system and method

Abstract

The invention relates to the technical field of project cost management, in particular to a hydraulic engineering construction cost control system and method, and the system comprises 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 evaluation module. According to the method, the material consumption rate is dynamically monitored, the construction progress and engineering quantity are combined to measure and calculate data, a consumption trend curve is established, the actual use condition is compared, the consumption rate deviation is accurately quantified, real-time evaluation of material use is achieved, the number of supply days is calculated in combination with inventory data, the replenishment period is matched, and the replenishment time is dynamically adjusted; the inventory level is optimized, fund occupation is reduced, the stability is evaluated according to the consumption fluctuation range, the maximum consumption fluctuation value is calculated, the demand is adjusted in combination with replenishment, the inventory early warning threshold value is dynamically corrected, the supply chain breakage risk is reduced, the adaptability of construction material management is improved, and the cost control accuracy is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of project cost management, and in particular to a water conservancy project construction cost control system and method. Background Art

[0002] The field of project cost management encompasses methods and systems for effectively controlling project costs during the construction process. The core of this technical area involves the dynamic monitoring and management of factors such as construction materials, labor, machinery and equipment, and construction progress to ensure projects progress smoothly within budget. Project cost management techniques typically utilize data collection, cost analysis, budgeting, and expense allocation to rationally allocate resources and control expenditures. This systematic approach encompasses cost estimation, cost control, and cost accounting. By analyzing and forecasting cost data in real time during the construction process, it improves capital efficiency and reduces unnecessary expenditures.

[0003] The water conservancy project construction cost control system refers to an information system that manages various cost factors during the construction process. This system primarily collects, calculates, and analyzes cost data for labor, materials, machinery usage, and other costs involved in water conservancy project construction. It also sets cost control targets and compares actual costs against budgeted costs. The system utilizes a bill of quantities-based cost accounting method to dynamically adjust expenses for each construction phase and analyzes construction cost trends based on historical data. By constructing a cost monitoring model, the system compares the costs of different construction plans and, taking into account the specificities of water conservancy project construction, categorizes and processes factors influencing costs, thereby achieving refined cost management.

[0004] Existing technologies rely on cost accounting and budgeting to manage construction expenses, but lack accurate tracking of real-time fluctuations in material consumption rates, making it difficult for inventory management to adapt to changing demand. Replenishment cycles rely on empirical judgment, making it difficult to adjust promptly when consumption rates fluctuate unexpectedly. This can lead to material shortages or backlogs, impacting construction progress and capital flow efficiency. A lack of quantitative analysis of material consumption stability makes it difficult to predict short-term usage changes. Fixed inventory warning thresholds are unable to adapt to dynamic construction needs, making it difficult to implement refined cost control. Summary of the Invention

[0005] The purpose of the present invention is to solve the shortcomings of the prior art and to propose a water conservancy project construction cost control system and method.

[0006] In order to achieve the above-mentioned purpose, the present invention adopts the following technical solution: A water conservancy project construction cost control system includes: The material consumption analysis module calculates the material consumption per unit time in multiple construction phases based on current construction progress data and engineering quantity measurement data, forming a consumption rate for each construction phase. Combined with the construction plan schedule, the module divides the time period and accumulates the theoretical consumption over multiple periods to obtain a theoretical consumption curve. Based on on-site material usage records, the module matches time nodes to extract actual consumption data, establishes an actual consumption curve, compares the two curves, and calculates the consumption rate deviation within the time interval. The inventory warning calculation module calls the consumption rate deviation and combines it with the real-time inventory data of the materials to calculate the time range in 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 uses the remaining supply days of the material and the inventory support period to determine whether the inventory is tight or surplus, and forms an inventory warning state; The replenishment trigger optimization module calls the inventory warning status, calculates the adjustment amount of early or delayed replenishment based on the current inventory level, and obtains the replenishment adjustment amount; The consumption stability assessment module calls the consumption rate deviation, matches the material consumption fluctuation range within the construction period, calculates the maximum consumption fluctuation value, forms a consumption stability index, and combines the replenishment adjustment amount to calculate the inventory warning threshold adjustment range to form a dynamic inventory threshold.

[0007] The consumption rate in the construction phase includes the consumption per unit time, the time period, and the theoretical consumption. The theoretical consumption curve includes the time node, actual consumption data, and the actual consumption curve. The consumption rate deviation is specifically the comparison result of the two curves and the difference in consumption rate within the time interval. The remaining supply days of materials include real-time inventory data, replenishment cycle data, and inventory support cycle. The inventory warning status includes inventory tension 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 the 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.

[0008] As a further solution of the present invention, the material consumption analysis module includes: The stage consumption rate calculation submodule calculates the unit time consumption of materials in multiple construction stages based on the current construction progress data and the engineering quantity measurement data. It matches the construction progress data of multiple construction stages with the measured engineering quantity data, calculates the consumption value per unit time of each stage, and aggregates the data of all construction stages to obtain the unit time consumption rate of multiple construction stages. The theoretical consumption curve construction submodule calls the unit time consumption rate of the multiple construction stages, combines the construction plan schedule, divides the time period, and performs cumulative calculation of the material consumption in multiple time periods using the formula: ; Calculate and obtain the cumulative consumption over multiple time periods to generate a theoretical consumption curve; in, Represents the theoretical consumption curve value, represents the consumption rate of the stage, Represents the length of the phase, represents the construction progress correction factor, Represents the construction plan consumption, Represents the actual consumption, represents the number of construction stages; The consumption rate deviation calculation submodule extracts the actual consumption data of on-site materials based on the theoretical consumption curve and matches the time nodes, compares the theoretical and actual consumption data, and calculates the consumption rate deviation.

[0009] As a further solution of the present invention, the inventory early warning calculation module includes: The consumption rate calculation submodule calls the material consumption rate deviation and calculates the actual material consumption rate per unit time in combination with real-time inventory data. The average material consumption rate is obtained by calculating the average consumption in multiple time periods. The inventory support period calculation submodule calculates the time range that the current inventory can support based on the average material consumption rate, using the formula: ; Calculate and obtain inventory to support the cycle; in, On behalf of the inventory can support the cycle, Represents the current inventory level, Representing the past The cumulative waste loss in a time period, represents the average consumption rate, Represents the consumption rate fluctuation value, Represents the difference between the maximum consumption rate and the average consumption rate, Represents the total number of monitoring cycles in the past.

[0010] As a further solution of the present invention, the dynamic inventory adjustment module includes: The inventory status determination submodule calls the remaining supply days of the material and the inventory support cycle, calculates the inventory balance ratio, determines whether the inventory status is in a tight or surplus state, and calculates and obtains the inventory status category; The inventory warning calculation submodule is based on the inventory status category and uses the formula: ; Calculate and obtain inventory warning index; in, Represents the inventory warning index, Represents the remaining supply days of the material, On behalf of the inventory can support the cycle, Representing the past The total inventory fluctuation within a time period, Represents the cumulative excess consumption, Represents the current inventory; The inventory warning generation submodule sets an inventory warning threshold based on the inventory warning index, determines the inventory warning level, and outputs the inventory warning status.

[0011] As a further solution of the present invention, the replenishment trigger optimization module includes: The inventory status adjustment submodule calls the inventory warning status, combines the current inventory level, determines whether the replenishment plan needs to be adjusted, and calculates the inventory adjustment requirements; The replenishment adjustment calculation submodule calculates the adjustment amount for early or delayed replenishment based on the inventory adjustment demand, using the formula: ; Calculate and obtain replenishment adjustment amount; in, represents the replenishment adjustment amount, On behalf of the inventory can support the cycle, Represents the remaining supply days of the material, represents the average consumption rate, Representing the past The cumulative replenishment quantity within a time period, Represents inventory fluctuation, Represents the current inventory level, Represents the total number of observation periods.

[0012] As a further solution of the present invention, the consumption stability evaluation 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 adopts the formula based on the maximum consumption fluctuation value: ; Operation to obtain consumption stability index; in, represents the consumption stability index, Represents the maximum consumption rate, represents the minimum consumption rate, Representing the past The accumulated abnormal consumption in a time period, Represents the total number of monitoring cycles, Represents the fluctuation range of consumption, represents the average consumption rate, represents excess consumption, Represents the construction period; The inventory threshold adjustment submodule calculates the inventory warning threshold adjustment range based on the consumption stability index and the replenishment adjustment amount, adjusts the inventory warning threshold, and generates a dynamic inventory threshold.

[0013] A water conservancy project construction cost control method is implemented based on the water conservancy project construction cost control system, comprising the following steps: S1: Obtain construction progress data, engineering quantity measurement data, and material usage data, calculate the material consumption per unit time in multiple construction stages, combine the construction plan schedule, divide the time period, accumulate the theoretical consumption of multiple periods, and obtain the theoretical material consumption curve. Match the time nodes to extract on-site material consumption data, calculate the actual material consumption change, and obtain the actual material consumption curve. Compare the consumption rate deviation between the two calculation time intervals to 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 the material, obtain the replenishment cycle data, calculate the time period that the inventory can maintain at 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 the current inventory level of the material, obtain the replenishment threshold adjustment parameter, calculate the adjustment amount of 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 a consumption stability index, combine the material replenishment adjustment amount, calculate the inventory warning threshold adjustment range, and obtain the dynamic inventory threshold.

[0014] Compared with the prior art, the advantages and positive effects of the present invention are: In this invention, by dynamically monitoring material consumption rates, combining construction progress with engineering quantity measurement data, establishing a consumption trend curve, and comparing actual usage, accurately quantifying consumption rate deviations, real-time material usage assessment is achieved. The supply days are calculated based on inventory data, and replenishment cycles are matched to dynamically adjust replenishment times, optimize inventory levels, and reduce capital utilization. Stability is assessed based on the consumption fluctuation range, the maximum consumption fluctuation value is calculated, and inventory warning thresholds are dynamically adjusted based on replenishment adjustment requirements, reducing the risk of supply chain disruptions, improving the adaptability of construction material management, and enhancing cost control accuracy. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 is a system flow chart of the present invention; Figure 2 This is a flow chart of the material consumption analysis module of the present invention; Figure 3 This is a flow chart of the inventory warning calculation module of the present invention; Figure 4 This is a flow chart of the dynamic inventory adjustment module of the present invention; Figure 5 This is the flow chart of the replenishment trigger optimization module of the present invention; Figure 6 This is a flow chart of the consumption stability evaluation module of the present invention. DETAILED DESCRIPTION

[0016] In order to make the purpose, technical solutions and advantages of the present invention more clearly understood, the present 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 only used to explain the present invention and are not intended to limit the present invention.

[0017] In the description of the present invention, it should be understood that the terms "length," "width," "up," "down," "front," "back," "left," "right," "vertical," "horizontal," "top," "bottom," "inside," "outside," and the like, indicating positions or relationships, are based on the positions or relationships shown in the accompanying drawings and are intended only to facilitate the description of the present invention and simplify the description. They do not indicate or imply that the devices or elements referred to must have a specific orientation, be constructed, or operate in a specific orientation. Therefore, they should not be construed as limiting the present invention. Furthermore, in the description of the present invention, "plurality" means two or more, unless otherwise expressly and specifically defined.

[0018] Example 1: Please refer to Figure 1 The present invention provides a technical solution: a water conservancy project construction cost control system comprising: The material consumption analysis module calculates the material consumption per unit time in multiple construction phases based on current construction progress data and engineering quantity measurement data, forming a consumption rate for each construction phase. Combined with the construction plan schedule, the module divides the time period and accumulates the theoretical consumption over multiple periods to obtain a theoretical consumption curve. Based on on-site material usage records, the module matches time nodes to extract actual consumption data, establishes an actual consumption curve, compares the two curves, and calculates the consumption rate deviation within the time interval. The inventory warning calculation module calls the consumption rate deviation and combines it with the real-time inventory data of the materials to calculate the time range in 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 uses the remaining supply days of the material and the inventory support period to determine whether the inventory is tight or surplus, and forms an inventory warning state; The replenishment trigger optimization module calls the inventory warning status, calculates the adjustment amount of early or delayed replenishment based on the current inventory level, and obtains the replenishment adjustment amount; The consumption stability assessment module calls the consumption rate deviation, matches the material consumption fluctuation range within the construction period, calculates the maximum consumption fluctuation value, forms a consumption stability index, and combines the replenishment adjustment amount to calculate the inventory warning threshold adjustment range to form a dynamic inventory threshold.

[0019] The consumption rate in the construction phase includes the consumption per unit time, the time period, and the theoretical consumption. The theoretical consumption curve includes the time node, actual consumption data, and the actual consumption curve. The consumption rate deviation is specifically the comparison result of the two curves and the difference in consumption rate within the time interval. The remaining supply days of materials include real-time inventory data, replenishment cycle data, and inventory support cycle. The inventory warning status includes inventory tension 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 the 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.

[0020] See also Figure 2 , the material consumption analysis module includes: The stage consumption rate calculation submodule calculates the unit time consumption of materials in multiple construction stages based on the current construction progress data and the engineering quantity measurement data. It matches the construction progress data of multiple construction stages with the measured engineering quantity data, calculates the consumption value per unit time of each stage, and aggregates the data of all construction stages to obtain the unit time consumption rate of multiple construction stages. First, read and analyze the progress data of the construction site. This data includes the progress of each construction stage, the time nodes of the construction tasks and the amount of work completed. At the same time, compare the engineering quantity measurement data to ensure that the construction plan corresponds to the actual engineering quantity data. For each construction stage, extract the start time, end time and corresponding engineering quantity information of its construction task, and calculate its construction quantity per unit time. For example, if the construction task of a certain stage is pouring concrete, assuming that the planned construction time for this stage is 10 days and the total construction volume is 500 cubic meters, then the unit time consumption is calculated as 500 / 10=50 Cubic meters / day. Subsequently, the unit time consumption rate is calculated for the material consumption in different construction stages. In the specific calculation process, the unit time consumption values of different stages are aggregated. For example, the steel bar usage in the first stage is 600 kg, and the time length is 5 days. The unit time consumption rate is 600 / 5=120 kg / day. The concrete consumption in the second stage is 500 cubic meters, and the time length is 10 days. The unit time consumption rate is 50 cubic meters / day. Finally, the consumption rates of all construction stages are aggregated to form the unit time consumption rate data of multiple construction stages, as shown in Table 1.

[0021] Table 1 Unit time consumption rate table of multiple construction stages ; As shown in Table 1, the unit time consumption rates for different construction phases have been calculated. By aggregating these data, the unit time consumption rates for multiple construction phases can be obtained, forming a complete construction consumption data set, which can be used to construct a theoretical consumption curve later.

[0022] The theoretical consumption curve construction submodule calls the unit time consumption rate of the multiple construction stages, combines the construction plan schedule, divides the time period, and performs cumulative calculation of the material consumption in multiple time periods using the formula: ; Calculate and obtain the cumulative consumption over multiple time periods to generate a theoretical consumption curve; in, Represents the theoretical consumption curve value, represents the consumption rate of the stage, Represents the length of the phase, represents the construction progress correction factor, Represents the construction plan consumption, Represents the actual consumption, represents the number of construction stages; 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 6 5-day cycles. In each cycle, calculate the total material consumption in that cycle based on the unit time consumption rate. Taking the first cycle as an example, assuming that it includes the first and second stages, the material consumption of this cycle is calculated as follows: the steel consumption in the first stage (5 days) is 120kg / day × 5 days = 600kg, and the concrete consumption in the second stage (5 days) is 50m3 / day × 5 days = 250m3. Then, perform cumulative calculations for all cycles and introduce the construction progress correction factor in the calculation process. , used to correct material consumption errors caused by construction progress deviations. For example, if the actual construction progress of a certain stage lags behind the planned progress by 10%, the correction factor Take 0.9 and calculate the revised consumption, for example, the planned consumption for a certain stage For 100m3, the actual consumption If the volume is 90m3, the revised calculation is , and finally adopt the formula: ; Substitute the data into the calculation, assuming =2, =120kg / day, =5 days, =50m3 / day, =5 days, =0.9, =0.95, =600kg, =580kg, =250m3, =240m3, calculated as follows: ; ; ; Finally, the theoretical consumption curve value is obtained =836.31.

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

[0024] The consumption rate deviation calculation submodule extracts the actual consumption data of on-site materials based on the theoretical consumption curve and matches the time nodes, compares the theoretical and actual consumption data, and calculates the consumption rate deviation.

[0025] First, establish a construction timeline and divide the construction period by day. For example, if the construction period is 30 days, record the actual material consumption of each construction stage every day, compare it with the theoretical consumption data, calculate the consumption rate deviation, and set a benchmark value. Assume that the benchmark deviation threshold is ±5%. If the actual consumption rate deviation exceeds this range, it is necessary to adjust the construction plan or replenish material supply. Take the concrete consumption in a certain construction stage as an example. The theoretical consumption rate is 50m3 / day, and the actual consumption rate is 45m3 / day. Calculate the deviation: ; ; Since the deviation of 10% exceeds the benchmark value of ±5%, it is necessary to adjust the construction progress or optimize the material supply. If the deviation is smaller, such as ±3%, it can be considered to be within the normal range, as shown in Table 2.

[0026] Table 2 Deviation table of consumption rate during construction phase ; As shown in Table 2, the consumption rate deviations in 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.

[0027] See also Figure 3 , the inventory warning calculation module includes: The consumption rate calculation submodule calls the material consumption rate deviation and calculates the actual material consumption rate per unit time in combination with real-time inventory data. The average material consumption rate is obtained by calculating the average consumption in multiple time periods. During the specific implementation process, material consumption data for a certain time period is first obtained, including used and lost materials. When calculating the deviation in material consumption rate, it is necessary to compare the consumption data at multiple time points to obtain the deviation at the current moment. 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, such as 1 hour or 24 hours, is first selected to calculate the net material consumption within that time period. This net consumption is obtained by subtracting the recycled amount from the used amount. At the same time, the hourly or daily consumption rate is calculated based on the current inventory data. 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 for each time interval is accumulated and averaged to obtain the average material consumption rate. In actual operation, for example, the daily material consumption rates of a factory over the past 7 days were 5.2, 4.8, 5.0, 5.1, 4.9, 5.3, and 5.2 tons / day, respectively. The average material consumption rate is calculated as follows: tons / day; Through this calculation process, it can be concluded that the current average material consumption rate is 5.07 tons / day.

[0028] The inventory support period calculation submodule calculates the time range that the current inventory can support based on the average material consumption rate, using the formula: ; Calculate and obtain inventory to support the cycle; in, On behalf of the inventory can support the cycle, Represents the current inventory level, Representing the past The cumulative waste loss in a time period, represents the average consumption rate, Represents the consumption rate fluctuation value, Represents the difference between the maximum consumption rate and the average consumption rate, Represents the total number of monitoring cycles in the past.

[0029] formula: ; During the specific execution process, first obtain the current inventory , this data can be provided in real time by the inventory management system. For example, if the current inventory of the factory is 100 tons, then the accumulated waste loss is calculated. , assuming that the waste losses in the past 7 days were 0.3, 0.4, 0.2, 0.5, 0.3, 0.4, and 0.3 tons respectively, then: ton; Then calculate the consumption rate fluctuation value , which represents the standard deviation of the consumption rate in each time period and the average consumption rate. Assuming that the calculated result is 0.2 tons / day, the maximum consumption rate is calculated at the same time. , assuming that in the past 30 days, the highest consumption rate was 5.5 tons / day, then: tons / day; Assume that the total number of monitoring cycles in the past is 30, then: tons / day; Substitute all parameters into the formula: sky; This calculation shows that at the current inventory level and consumption rate, the inventory can last for 18.24 days.

[0030] See also Figure 4 , the dynamic inventory adjustment module includes: The inventory status determination submodule calls the remaining supply days of the material and the inventory support cycle, calculates the inventory balance ratio, determines whether the inventory status is in a tight or surplus state, and calculates and obtains the inventory status category; First call the remaining supply days of the material and inventory can support the cycle , representing the estimated sustainable days under the current inventory status and the sustainable days under normal consumption. After calling these two parameters, the ratio calculation is performed, that is, the inventory balance ratio is calculated. , and use this as a basis to judge the degree of inventory tension or surplus. Specifically, if the ratio is lower than a certain set threshold , the inventory is judged to be in a tight state; if the ratio is higher than the set threshold , then the inventory is judged to be in surplus state, the threshold and It needs to be set based on historical data and industry experience. For example, a manufacturing company sets an inventory shortage threshold for key components. , that is, when the remaining days of inventory are less than 70% of the inventory support cycle, it is judged to be a tight state, and for the judgment of the surplus state, it may be set , that is, when the remaining days of inventory exceed 130% of the inventory support cycle, it is determined to be excess inventory. The key to setting a reasonable threshold is to combine the actual supply chain management situation of the enterprise, such as the stability of the production plan, the supplier's delivery cycle, etc. The calculation example is as follows: if the current remaining supply days of a material are days, and inventory can support the cycle days, the inventory balance ratio is: ; At this time, 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, , then the inventory is judged to be tight. If the calculated result is greater than 1.3, that is , then the inventory is determined to be surplus. This calculation process can be further refined to different industries. For example, the automobile manufacturing industry may set a stricter threshold for key chips, such as , while the consumer electronics industry may set a looser threshold, such as The result of the inventory status determination will be directly used for inventory warning calculation.

[0031] The inventory warning calculation submodule is based on the inventory status category and uses the formula: ; Calculate and obtain inventory warning index; in, Represents the inventory warning index, Represents the remaining supply days of the material, On behalf of the inventory can support the cycle, Representing the past The total inventory fluctuation within a time period, Represents the cumulative excess consumption, Represents the current inventory; formula: ; in, Represents the inventory warning index. The larger the value, the more obvious the inventory fluctuation is and the higher the warning level is. 、 are the remaining supply days of materials and the inventory support cycle respectively. The absolute value of the difference reflects the degree of deviation between the current inventory status and the normal level. Indicates excess inventory, otherwise it indicates tight inventory. Reflects the total inventory fluctuations in the past The impact of the time period, Represents the total historical inventory fluctuation. This value can be calculated using historical inventory data. For example, if the inventory fluctuations in the past three months were 100, 120, and 90 units, respectively, then: ; at the same time, Represents the cumulative excess consumption, that is, the inventory consumption that exceeds the forecast consumption. It can be calculated based on historical data. For example, if the forecast consumption is 500 units and the actual consumption is 600 units, then: ; Represents the current inventory. For example, if the current inventory is 800 units, then , assuming sky, Days, calculation: ; ; ; ; The threshold setting of inventory warning index needs to be combined with industry standards. For example, for key components, if That is, warning is needed. It is in a high warning state. The calculated value of 0.298 is lower than 0.5, so the warning is not triggered.

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

[0033] First, set the inventory warning threshold 、 、 To distinguish inventory risk levels, for example: ; The inventory warning levels are divided according to different thresholds, as shown in Table 3.

[0034] Table 3 Inventory warning level classification table ; As shown in Table 3, when The calculated value 0.298 is less than 0.3, and the inventory warning status is normal. , the inventory enters a low warning state. If Then enter the medium warning state, if The system will enter a high warning state. The warning information can be used to make decisions on inventory replenishment or adjustment strategies, and dynamically optimize based on actual conditions.

[0035] See also Figure 5 , the replenishment trigger optimization module includes: The inventory status adjustment submodule calls the inventory warning status, combines the current inventory level, determines whether the replenishment plan needs to be adjusted, and calculates the inventory adjustment requirements; First, take statistics on the current inventory level and record the existing inventory , and calculate inventory fluctuations The calculation method of inventory fluctuation can be the standard deviation of inventory levels in a certain period in the past. For example, if the inventory levels in the last 10 days are 500, 520, 480, 490, 510, 495, 505, 515, 500, and 510 respectively, then the standard deviation of inventory fluctuation can be calculated. , Secondly, calculate the inventory support cycle , by the average consumption rate If the consumption in the past 7 days is 50, 52, 48, 49, 51, 50, 50, the average consumption rate is Units / day, from which the inventory can be calculated to support the cycle If the current inventory ,but Days, at the same time, get the remaining supply days of the material , if the current order arrives in 3 days, that is God, then judge Whether the absolute value of exceeds the safety stock threshold, if the threshold is set to 5 days, then days, exceeds the threshold, and the replenishment plan needs to be adjusted. If the stock is less than or equal to the threshold, no adjustment is required. Finally, the inventory adjustment demand is calculated. If the safety threshold is exceeded, the replenishment quantity will be reduced. If it exceeds the safety threshold, the replenishment quantity will be increased.

[0036] The replenishment adjustment calculation submodule calculates the adjustment amount for early or delayed replenishment based on the inventory adjustment demand, using the formula: ; Calculate and obtain replenishment adjustment amount; in, represents the replenishment adjustment amount, On behalf of the inventory can support the cycle, Represents the remaining supply days of the material, represents the average consumption rate, Representing the past The cumulative replenishment quantity within a time period, Represents inventory fluctuation, Represents the current inventory level, Represents the total number of observation periods.

[0037] formula: ; First, obtain the absolute value of the inventory adjustment demand , as in the previous example , then calculate the inventory adjustment The molecular part of , assuming the past Cumulative replenishment quantity within days , then calculate the numerator: ; Then calculate the denominator, which is , assuming the total number of observation periods is Day, then: ; at the same time, , so the denominator is calculated as follows: ; Final calculation of replenishment adjustment: ; The result shows that based on the current inventory status and the replenishment plan adjustment requirements, the calculated replenishment adjustment amount is 201.1 units. The final replenishment adjustment amount can be determined by further combining the replenishment batch setting and rounding to the minimum replenishment unit.

[0038] See also Figure 6 , the consumption stability evaluation 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; First, obtain the material consumption rate for each time period during the construction period ,These data can be obtained through construction site sensors or manual statistics, and form a time series data set. Then, the consumption rate of all time periods is calculated to obtain the maximum consumption rate and minimum consumption rate , corresponding to the maximum and minimum material consumption respectively. For example, in a construction project, the hourly material consumption data is as follows: , we can get by calculation tons / hour, Tons / hour, then calculate the fluctuation range of material consumption during the construction period, which is determined by the difference between the maximum consumption rate and the minimum consumption rate, that is, Tons / hour, and then calculate the consumption change value based on the data of multiple time intervals. First, divide the construction period into multiple time periods, such as 5 days, and calculate the consumption change every day. Assuming that the daily consumption is Tons, the daily consumption change can be calculated ,like Tons, calculate all Then sum up to get the cumulative abnormal consumption Finally, the maximum consumption fluctuation value is determined by the superposition 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 consumption stability index calculation.

[0039] The consumption stability determination submodule adopts the formula based on the maximum consumption fluctuation value: ; Operation to obtain consumption stability index; in, represents the consumption stability index, Represents the maximum consumption rate, represents the minimum consumption rate, Representing the past The accumulated abnormal consumption in a time period, Represents the total number of monitoring cycles, Represents the fluctuation range of consumption, represents the average consumption rate, represents excess consumption, Represents the construction period; formula: ; First, determine the total number of monitoring cycles , assuming the construction period is 30 days and data is collected once a day, then , then calculate the consumption fluctuation range , which is the ratio of the maximum consumption rate to the average consumption rate. If the average consumption rate is 14 tons / hour, then , and then calculate the excess consumption If the actual excess consumption is 80 tons within the 30-day construction period, then tons, construction period Day, enter the formula: ; Calculate the values of each part, , , , the final calculation result is: ; This value can be used to determine the consumption stability level. Assume that the consumption stability index is graded as follows: : High stability- : Medium stability; : Low stability, in this case , indicating that the consumption process is in a low stability state.

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

[0041] First, set the initial inventory warning threshold , assuming the initial value is 500 tons, the replenishment adjustment amount Depending on the abnormal consumption replenishment demand during the construction period, assuming the replenishment adjustment amount is 80 tons, the inventory warning threshold adjustment range is Calculate as follows: ; Setting the adjustment factor , , substitute the data: ; Finally, the new inventory warning threshold is calculated as: ; That is, the adjusted inventory warning threshold is 598 tons, which can be used for dynamic inventory management to adapt to fluctuations in material consumption.

[0042] Table 4: Material consumption data during the construction period ; As shown in Table 4, the daily material consumption and its change value are used to calculate the cumulative abnormal consumption Tons, which is used to calculate the consumption stability index.

[0043] A water conservancy project construction cost control method is implemented based on the water conservancy project construction cost control system, comprising the following steps: S1: Obtain construction progress data, engineering quantity measurement data, and material usage data, calculate the material consumption per unit time in multiple construction stages, combine the construction plan schedule, divide the time period, accumulate the theoretical consumption of multiple periods, and obtain the theoretical material consumption curve. Match the time nodes to extract on-site material consumption data, calculate the actual material consumption change, and obtain the actual material consumption curve. Compare the consumption rate deviation between the two calculation time intervals to 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 the material, obtain the replenishment cycle data, calculate the time period that the inventory can maintain at 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 the current inventory level of the material, obtain the replenishment threshold adjustment parameter, calculate the adjustment amount of 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 a consumption stability index, combine the material replenishment adjustment amount, calculate the inventory warning threshold adjustment range, and obtain the dynamic inventory threshold.

[0044] The above are merely preferred embodiments of the present invention and do not limit the present invention in any other form. Any technician familiar with the profession may use the technical content disclosed above to change or modify it into an equivalent embodiment with equivalent changes and apply it to other fields. However, any simple modification, equivalent change and modification made to the above embodiment based on the technical essence of the present invention without departing from the content of the technical solution of the present invention shall still fall within the scope of protection of the technical solution of the present invention.

Claims

1. A water conservancy project construction cost control system, characterized in that: The system comprises: The material consumption analysis module calculates the material consumption per unit time of multiple construction stages based on the current construction progress data and engineering quantity measurement data, forms the consumption rate of the construction stage, divides the time period into periods according to the construction plan schedule, accumulates the theoretical consumption in multiple periods, and obtains the theoretical consumption curve. According to the on-site material usage records, the actual consumption data is extracted by matching the time nodes, and the actual consumption curve is established. The two curves are compared to calculate the consumption rate deviation within the time interval; The inventory warning calculation module calls the consumption rate deviation, combines the real-time inventory data of materials, calculates the time range that the current inventory can support construction, determines the remaining supply days of materials, matches the replenishment cycle data, and calculates the inventory support cycle under the current consumption rate; The dynamic inventory adjustment module calls the remaining supply days of the material and the inventory support cycle to determine the inventory shortage or surplus status and form an inventory warning status; The replenishment trigger optimization module calls the inventory warning status, calculates the adjustment amount of early or delayed replenishment in combination with the current inventory level, and obtains the replenishment adjustment amount; The consumption stability evaluation module calls the consumption rate deviation, matches the material consumption fluctuation range within the construction period, calculates the maximum consumption fluctuation value, forms a consumption stability index, and combines the replenishment adjustment amount to calculate the inventory warning threshold adjustment range to form a dynamic inventory threshold.

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

3. The water conservancy project construction cost control system according to claim 2 is characterized in that: The material consumption analysis module includes: The stage consumption rate calculation submodule calculates the unit time consumption of materials in multiple construction stages based on the current construction progress data and engineering quantity measurement data, matches the construction progress data of multiple construction stages with the measured engineering quantity data, calculates the consumption value per unit time of each stage, and aggregates the data of all construction stages to obtain the unit time consumption rate of multiple construction stages; The theoretical consumption curve construction submodule calls the unit time consumption rate of the multiple construction stages, combines the construction plan schedule, divides the time period, and performs cumulative calculation of the material consumption in multiple time periods, using the formula: ； Calculate and obtain the cumulative consumption over multiple time periods to generate a theoretical consumption curve; in, Represents the theoretical consumption curve value, represents the consumption rate of the stage, Represents the duration of the phase, represents the construction progress correction factor, Represents the construction plan consumption, represents the actual consumption, represents the number of construction stages; The consumption rate deviation calculation submodule extracts the actual consumption data of materials on site based on the theoretical consumption curve and matches the time nodes, compares the theoretical and actual consumption data, and calculates the consumption rate deviation.

4. The water conservancy project construction cost control system according to claim 3 is characterized in that: The inventory early warning calculation module includes: The consumption rate calculation submodule calls the material consumption rate deviation, combines the 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 in multiple time periods; The inventory support period calculation submodule calculates the time range that the current inventory can support based on the average material consumption rate, using the formula: ； Calculate and obtain inventory to support the cycle; in, It means that the inventory can support the cycle. Represents the current inventory quantity, Representing the past Cumulative waste loss in a time period, represents the average consumption rate, Represents the consumption rate fluctuation value, Represents the difference between the maximum consumption rate and the average consumption rate. Represents the total number of monitoring cycles in the past.

5. The water conservancy project construction cost control system according to claim 4, 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, calculates the inventory balance ratio, determines whether the inventory status is in a tight or surplus state, and calculates to obtain the inventory status category; The inventory warning calculation submodule is based on the inventory status category and uses the formula: ； Calculate and obtain the inventory warning index; in, Represents the inventory warning index, Represents the remaining supply days of the material. It means that the inventory can support the cycle. Representing the past The total inventory fluctuation within a time period, Represents the cumulative excess consumption, Represents the current inventory; The inventory warning generation submodule sets an inventory warning threshold based on the inventory warning index, determines the inventory warning level, and outputs the inventory warning status.

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

7. The water conservancy project construction cost control system according to claim 6, characterized in that: The consumption stability evaluation module comprises: 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 to obtain the maximum consumption fluctuation value; The consumption stability determination submodule adopts the formula based on the maximum consumption fluctuation value: ； Operation to obtain consumption stability index; in, represents the consumption stability index, represents the maximum consumption rate, represents the minimum consumption rate, Representing the past The accumulated abnormal consumption in a time period, Represents the total number of monitoring cycles, Represents the fluctuation range of consumption, represents the average consumption rate, represents excess consumption, Represents the construction period; The inventory threshold adjustment submodule calculates the inventory warning threshold adjustment range based on the consumption stability index and the replenishment adjustment amount, adjusts the inventory warning threshold, and generates a dynamic inventory threshold.

8. A method for controlling the construction cost of a water conservancy project, characterized in that: According to any one of claims 1 to 7, the water conservancy project construction cost control system is implemented. The following steps are involved: S1: Obtain construction progress data, engineering quantity measurement data and material usage data, calculate the material consumption per unit time in multiple construction stages, divide the time period into construction plan schedule, accumulate the theoretical consumption of multiple periods, obtain the theoretical material consumption curve, extract the on-site material consumption data by matching the time nodes, calculate the actual material consumption change, obtain the actual material consumption curve, compare the consumption rate deviation within the calculation time interval between the two, 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 the material, obtain the replenishment cycle data, calculate the time period that the inventory can maintain at 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: calling the inventory warning status, combining the current inventory level of the material, obtaining the replenishment threshold adjustment parameter, calculating the adjustment amount of early or delayed replenishment, and obtaining 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 a consumption stability index, combine the material replenishment adjustment amount, calculate the inventory warning threshold adjustment range, and obtain the dynamic inventory threshold.

Images