A method and system for constructing an annual capital planning calculation model for materials supplied to Class A of ultra-high voltage power projects

Abstract

The present invention discloses a method and system for constructing an annual capital plan calculation model for materials supplied by UHV power projects. The method comprises: collecting data through a data center; correcting and transforming the collected data; for unapproved projects, aggregating data according to the project tree, analyzing and mining the capital flow patterns of various materials of each type of individual project, generating data parameter templates and calculating the capital plan; for approved projects, based on the calculation logic of the annual capital plan calculation model, displaying the capital plan calculation results in layers and levels; the system comprises a data collection module, a data cleaning module, a capital plan calculation module and a calculation result display module. The annual capital plan calculation model for engineering materials of the present invention can realize real-time business linkage, automatic information capture, and dynamic data update, effectively improving the accuracy and compilation quality of the capital plan, and greatly improving the lean management level of engineering material funds.

Description

Technical Field

[0001] The present invention relates to a method for constructing a calculation model, and in particular to a method for constructing a calculation model for an annual capital plan of materials supplied to Class A of an ultra-high voltage power project and a system thereof. Background Art

[0002] Currently, the annual funding plan management and control model for UHV project supply materials is in urgent need of change. Firstly, the construction and management model of UHV projects is highly unique, and the preparation of annual funding plans for projects is multifaceted and involves multiple departments and processes, including contract signing, contract performance, and settlement. There is an urgent need to summarize experience in project material management, explore the inherent laws of material supply, and promote further improvement in work quality and efficiency. Secondly, the country has successively introduced a number of policies to optimize the business environment. To ensure timely payment of funds to small and medium-sized enterprises, the State Grid Corporation of China has increasingly demanded lean management and control of the use of funds for supply materials. The existing "manual calculation and offline compilation" model cannot meet the State Grid Corporation's requirements for annual plan accuracy. Therefore, it is urgent to upgrade information technology support and further enhance service guarantee capabilities.

[0003] The widespread application of new technologies such as big data and artificial intelligence has provided new technical means for unlocking the potential of enterprise data and supporting company development. However, the current annual funding plan preparation process relies solely on manual offline preparation and submission, resulting in low efficiency and hindering the improvement of work quality. Therefore, it is imperative to fully utilize the company's current mature technical means and business data to build an annual funding plan calculation model to provide effective support for annual funding plan management and control.

[0004] The Chinese patent application number 201911227183.X discloses a method and system for constructing an annual plan preparation model for new power grid infrastructure projects. This is the closest existing technology, but it does not build a contract cluster association at the project level. After the bidding for each new power grid infrastructure project is completed, a large number of contracts will be signed. The execution progress of the signing, change, performance, settlement and other links of different contracts are different. If cross-disciplinary collaboration is not carried out on the key business nodes of contract management, and data is not connected with development, finance, economics, law, infrastructure and other systems to create a project perspective "contract cluster management" construction, it will bring great uncertainty to the project milestone planning and scheduling and the prediction of the construction progress of new projects; secondly, historical experience data has not been deeply mined, and the data sources of the project milestone planning and scheduling model and the construction progress prediction model of the new project are mostly derived from the estimated time data, with relatively poor stability and accuracy. Summary of the Invention

[0005] Purpose of the invention: The purpose of the present invention is to provide a method and system for constructing an annual funding plan calculation model for materials supplied by UHV power projects.

[0006] Technical solution: The method for constructing an annual capital plan calculation model for materials supplied to UHV power projects according to the present invention comprises the following steps:

[0007] (1) Collect basic project information, project approval plans, project milestone plans from the infrastructure business management system, and contract signing, performance, and settlement data from the material business management system through the data center;

[0008] (2) Correct and transform the collected data to meet the requirements of data analysis;

[0009] (3) For unapproved projects, the contract signing, performance, and settlement data of the materials supplied by Party A under the historical projects are collected according to the project tree. The capital flow patterns of various materials and funds of each type of individual project are analyzed and mined. Data parameter templates are generated and the capital plan is calculated. For approved projects, the capital plan is calculated based on the contract signing, performance, and settlement data of the materials supplied by Party A.

[0010] (4) Based on the calculation logic of the annual capital plan calculation model, the capital plan calculation results are displayed layer by layer according to "material category / contract-single project-investor-project".

[0011] Furthermore, the basic information of the project in step (1) includes the project name, funding unit, construction period, single project, project type, and static investment amount information; the project approval plan includes the project approval date, the project milestone plan includes the project commissioning date, the contract signing data includes the contract legal number, effective date, project, supplier name, contract line item, goods name, quantity, and unit price; the contract performance data includes the supply plan number, contract line item, delivery quantity, and delivery date; and the contract settlement data includes the payment stage, application amount, and payment date.

[0012] Furthermore, the rules for correcting and transforming the collected data in step (2) are as follows: removing duplicate data - only obtaining the signing data of effective contracts - the settlement data of paid contracts - the corresponding material categories - the correction of payment stage names and the addition of empty values.

[0013] Furthermore, when the problem that the program cannot handle is encountered during the correction and conversion of the collected data in step (2), the abnormal situation is recorded and a corresponding report is generated. Manual processing is then performed accordingly according to the report, and the processing is continuously supplemented and improved based on processing experience.

[0014] Furthermore, the step (3) of calculating the unapproved project funding plan includes:

[0015] (3.1) Generate data parameter templates, using time series algorithms and big data technology to collect contract signing, performance, and settlement data for historical projects under the supply of materials to the project tree, analyze and mine the flow patterns of various materials and funds for each type of individual project, and automatically generate parameter values ​​in the data parameter templates;

[0016] (3.2) Calculation of funding plans for unapproved projects: Based on the project's estimated investment amount, estimated approval date, and estimated commissioning date, the corresponding project type's data parameter template is applied. The payment amount and payment time for each stage are calculated according to the material category dimension, and the annual and monthly funding demand plans for individual projects, funding units, and engineering project levels are summarized and calculated step by step.

[0017] Furthermore, the calculation formula for advance payment, progress payment, delivery payment, commissioning payment and warranty payment in step (3.2) is as follows:

[0018] Advance payment amount = estimated project investment × corresponding material category investment ratio × advance payment ratio;

[0019] Advance payment time = estimated project approval time + advance payment payment time interval;

[0020] Progress payment amount = estimated project investment × investment proportion of corresponding material category × progress payment ratio;

[0021] Progress payment time = estimated project approval time + progress payment time interval;

[0022] Amount of payment upon delivery = estimated project investment × investment proportion of corresponding material category × proportion of goods arriving in batches × proportion of payment upon delivery;

[0023] Time for payment upon receipt of payment = estimated time for project approval + time interval for payment upon receipt of payment in batches;

[0024] Amount of commissioning payment = estimated project investment × investment proportion of corresponding material category × commissioning payment ratio;

[0025] Payment time for commissioning payment = estimated commissioning time of the project + payment time interval for commissioning payment;

[0026] Warranty payment amount = estimated project investment × corresponding material category investment ratio × warranty payment ratio;

[0027] Warranty payment payment time = project expected commissioning time + warranty payment payment time interval.

[0028] Furthermore, the step (3) of calculating the approved project funding plan includes:

[0029] Based on the project and contract signing data, contract performance supply plan and contract settlement data, the payment amount and payment time of each stage are calculated according to the contract dimension, and the annual and monthly capital demand plans of individual projects, funding units and engineering project levels are calculated step by step according to the project tree.

[0030] Furthermore, the calculation formula for the advance payment, progress payment, delivery payment, commissioning payment and warranty payment in the approved project funding plan is as follows:

[0031] Advance payment amount = Contract amount × Advance payment ratio - Cumulative payment amount of the amount;

[0032] Advance payment payment time = the month following the month of preparation of the plan;

[0033] Progress payment amount = Contract amount × Progress payment ratio - Cumulative payment amount for that amount;

[0034] Progress payment time = the month following the month when the plan is prepared;

[0035] Amount of payment upon delivery = quantity of goods delivered in the supply plan × price excluding tax × (1 + tax rate) × payment ratio upon delivery – cumulative amount paid for the item;

[0036] Payment time upon arrival = arrival time in supply plan + n days;

[0037] Amount of commissioning payment = Contract amount × commissioning payment ratio - accumulative amount paid for the payment;

[0038] Payment time for commissioning payment = estimated commissioning time of the project + n days;

[0039] Warranty payment amount = Contract amount × Warranty payment ratio - Cumulative payment amount of the amount;

[0040] Warranty payment payment time = estimated project commissioning time + warranty period + n days;

[0041] If a letter of guarantee is issued in lieu of warranty payment, the payment time = the time it takes to complete the warranty document processing + n days.

[0042] Furthermore, the step (4) is divided into three levels, namely:

[0043] The first level is the auxiliary level. Unapproved projects display payment plans for each material category based on material categories. Approved projects display the arrival and payment plans for each material line in the contract based on contract material items.

[0044] The second level is the detailed level, which shows the payment plan for each payment according to the contract;

[0045] The third level is the summary level, which displays the annual funding plan report. The report is based on the project tree and displays the annual and monthly funding demand plans by project and funding unit.

[0046] The system for constructing an annual capital plan calculation model for materials supplied to Class A of a UHV power project according to the present invention comprises:

[0047] The data collection module is used to collect basic project information, project approval plans, project milestone plans from the infrastructure business management system, and contract signing, performance, and settlement data from the material business management system through the data center.

[0048] Data cleaning module, used to correct and transform the collected data to meet data analysis requirements;

[0049] The funding plan calculation module is used to collect the contract signing, performance, and settlement data of the supply materials contracts for unapproved projects according to the project tree. It analyzes and explores the capital flow patterns of various materials and funds for each individual project type, generates data parameter templates, and calculates the funding plan. For approved projects, the funding plan is calculated based on the contract signing, performance, and settlement data of the supply materials contracts signed for the project.

[0050] The calculation result display module is used to display the capital plan calculation results layer by layer according to "material category / contract-single project-funding unit-project" based on the calculation logic of the annual capital plan calculation model.

[0051] Beneficial effects: Compared with the existing technology, the present invention has the following significant advantages: Classified construction of annual capital plan calculation models for unapproved projects and approved projects. For unapproved projects, big data technology is used to analyze the existing historical data on various types of engineering construction, contract signing, and production performance settlement, and a calculation parameter template is generated. The unapproved project project data is brought in to automatically generate an annual capital plan, solving the problem that unapproved projects have no accurate contract data and material supply plan to support capital plan calculation; for approved projects, the project tree is used to automatically aggregate the contract signing and production performance settlement data under the project from the dimensions of project, funding unit, and single project, and automatically generate an annual capital plan according to the capital plan calculation logic; the annual capital plan calculation model for engineering materials realizes real-time business linkage, automatic information capture, and dynamic data update, effectively improving the accuracy of capital plans and the quality and efficiency of compilation, and greatly improving the lean management level of engineering material funds. BRIEF DESCRIPTION OF THE DRAWINGS

[0052] Figure 1 is a flow chart of the present invention;

[0053] Figure 2 A schematic diagram for grouping contract data by project tree;

[0054] Figure 3This is a schematic diagram of the calculation rules for unapproved project funding plans;

[0055] Figure 4 This is a schematic diagram of the calculation rules for the approved project funding plan;

[0056] Figure 5 This is a schematic diagram of the ECP system engineering list;

[0057] Figure 6 This is a diagram of the online functional structure of the annual funding plan for engineering materials. DETAILED DESCRIPTION

[0058] The technical solution of the present invention will be further described below with reference to the accompanying drawings.

[0059] like Figure 1 As shown, the present invention includes the following steps:

[0060] (1) Collect basic project information, project approval plans, project milestone plans in the infrastructure business management system, and contract signing, performance, and settlement data in the material business management system through the data middle platform; Collect basic project information, project approval plans, project milestone plans in the infrastructure business management system, and contract signing, performance, and settlement data in the material business management system through the data middle platform.

[0061] Basic project information includes project name, funding unit, construction period, individual project, project type, static investment amount, etc.; project approval plan includes project approval date; project milestone plan includes project commissioning date; contract signing data includes contract legal number, effective date, project, supplier name, contract line item, goods name, quantity, unit price, etc.; contract performance data includes supply plan number, contract line item, delivery quantity, delivery date, etc.; contract settlement data includes payment stage, application amount, payment date, etc.

[0062] (2) Correct and transform the collected data to meet the requirements of data analysis; the main data cleaning rules are: 1) remove duplicate data; 2) only obtain the signing data of effective contracts and the settlement data of paid contracts; 3) correspondence between material categories; 4) correct the name of the payment stage (advance payment / arrival payment / commissioning payment / warranty deposit) and fill in empty values, etc.

[0063] During the data cleaning process, when encountering problems that the program cannot handle, the abnormal situation will be recorded and a corresponding report will be generated. Manual processing will then be carried out according to the report, and the data cleaning rules will be continuously supplemented and improved based on processing experience.

[0064] (3) For unapproved projects, the contract signing, performance, and settlement data of the materials supplied by Party A under the historical projects are collected according to the project tree. The capital flow patterns of various materials and funds of each type of individual project are analyzed and mined. Data parameter templates are generated and the capital plan is calculated. For approved projects, the capital plan is calculated based on the contract signing, performance, and settlement data of the materials supplied by Party A.

[0065] (3.1) Estimation of unapproved project funding plans

[0066] (3.1.1) Generate data parameter template

[0067] Unapproved project supplies lack accurate contract data and material supply plans as support. According to the characteristics of the materials, the supplies are divided into 20 categories, and the capital plan calculation data parameter template is set according to the type of individual project. The example is shown in Table 1. Figure 2 As shown, by adopting time series algorithm and applying big data technology, the contract signing, performance and settlement data of supply materials under historical projects are collected according to the project tree, and the flow patterns of various materials and funds of each type of single project are analyzed and mined, and the parameter values ​​in the data parameter template are automatically generated.

[0068] Table 1: Example of data template for equipment A in a converter station of a certain voltage level

[0069]

[0070] (3.1.2) Estimation of unapproved project funding plans

[0071] Based on the estimated investment amount, estimated approval date, and estimated commissioning date of the project, apply the data parameter template of the corresponding project type, calculate the payment amount and payment time of each stage according to the material category dimension (the calculation rules are as follows), and summarize and calculate the annual and monthly capital demand plans for individual projects, funding units, and project levels step by step, such as Figure 3 shown.

[0072] 1) Advance payment

[0073] Payment amount = estimated project investment × corresponding material category investment ratio × advance payment ratio

[0074] Payment time = estimated project approval time + advance payment time interval

[0075] 2) Progress Payment

[0076] Payment amount = estimated project investment × corresponding material category investment ratio × progress payment ratio

[0077] Payment time = estimated project approval time + progress payment interval

[0078] 3) Payment upon receipt

[0079] Payment amount = estimated project investment × investment proportion of corresponding material category × proportion of goods arriving in batches × proportion of payment upon arrival

[0080] Payment time = estimated project approval time + payment time interval for instalments

[0081] 4) Operation fee

[0082] Payment amount = estimated project investment × corresponding material category investment ratio × commissioning payment ratio

[0083] Payment time = estimated project commissioning time + commissioning payment time interval

[0084] 5) Warranty payment

[0085] Payment amount = estimated project investment × corresponding material category investment ratio × warranty payment ratio

[0086] Payment time = estimated project commissioning time + warranty payment time interval

[0087] (3.2) Calculation of approved project funding plan

[0088] Based on data such as the project (estimated commissioning time), contract signing data (contract amount, contract line item price, quality assurance period), contract performance supply plan (arrival quantity and arrival time), and contract settlement data (paid amount), calculate the payment amount and payment time for each stage according to the contract dimension (the calculation rules are as follows), and summarize and calculate the annual and monthly capital demand plans for individual projects, funding units, and project levels according to the project tree, such as Figure 4 shown.

[0089] 1) Advance payment

[0090] Payment amount = contract amount × advance payment ratio - cumulative payment amount of the amount

[0091] Payment date = the month following the date of payment

[0092] 2) Progress Payment

[0093] Payment amount = Contract amount × Progress payment ratio - Total amount paid for the payment

[0094] Payment date = the month following the date of payment

[0095] 3) Payment upon receipt

[0096] Payment amount = quantity of goods arriving in the supply plan × unit price excluding tax × (1 + tax rate) × payment ratio for goods arriving – cumulative amount paid for the payment (only for the first batch of goods arriving)

[0097] Payment time = arrival time in supply plan + n days

[0098] 4) Operation fee

[0099] Payment amount = Contract amount × Payment ratio of commissioning payment - Cumulative amount paid for the payment

[0100] Payment time = estimated project commissioning time + n days

[0101] 5) Warranty payment

[0102] Payment amount = Contract amount × Warranty payment ratio - Cumulative amount paid for the payment

[0103] Payment time = estimated project commissioning time + warranty period + n days

[0104] If a letter of guarantee is issued in lieu of warranty payment, payment time = warranty document processing completion time + n days

[0105] (4) Based on the calculation logic of the annual capital plan calculation model, the capital plan calculation results are displayed layer by layer according to "material category / contract-single project-investor-project".

[0106] Based on the calculation logic of the annual capital plan calculation model, the capital plan calculation results are displayed layer by layer according to "material category / contract-single project-funding unit-project".

[0107] The first level is the auxiliary level. For unapproved projects, the payment plan for each type of material is displayed based on the material category. For approved projects, the batch arrival and payment plan for each line of contract materials are displayed based on the contract material items.

[0108] The second level is the detailed level, which shows the payment plan for each payment according to the contract.

[0109] The third level is the summary level, which displays the annual funding plan report. The report is based on the project tree and displays the annual and monthly funding demand plans by project and funding unit.

[0110] Example:

[0111] The annual fund planning and control process for materials supplied to UHV projects is roughly divided into six steps:

[0112] Step 1. Build a "project tree" and implement material classification management. For the contracts of approved projects, configure the "project tree" online through the State Grid Corporation's first-level e-commerce platform (hereinafter referred to as the ECP system), and collect material contracts by project, funding unit, single project and other dimensions, and implement classification research and management. Currently, 38 UHV "project trees" have been established in the ECP system, such as Figure 5 As shown, there are more than 6,000 corresponding material collection contracts.

[0113] Step 2. Establish data templates and mine historical data. Summarize historical data on project material management and create data templates based on individual projects and material categories. Classify the A-supplied materials required for UHV projects into 20 categories. This summarizes the investment, supply, and settlement patterns for each type of material, addressing the lack of contract data support for unapproved projects. For example, for a specific piece of equipment and material within a converter station at a certain voltage level, its estimated proportion of total investment, payment ratio for each material category, and supply plan are shown in Table 2. When compiling annual funding plans, the data template for the corresponding individual project can be applied as needed.

[0114] Table 2: Example of data template for equipment A in a converter station of a certain voltage level

[0115]

[0116] Step 3. Build calculation logic to accurately estimate funding needs. Based on the unique characteristics of UHV projects and following the principle of "classified design," we established separate calculation logic for annual funding plans for approved and unapproved projects. We set data parameters, clarified data sources, and accurately calculated funding needs. As shown in Table 3, the calculation model and related parameters have been validated in the management of annual funding plans for UHV projects and are continuously optimized and improved based on actual business practices.

[0117] Table 3: Engineering material fund planning calculation model parameters and logic settings

[0118]

[0119]

[0120] Step 4. Classify and estimate the demand for various materials and funds.

[0121] Step 5. Summarize and display the payment plan for each project.

[0122] Since the construction of the UHV project, State Grid Material Company has had experience in managing dozens of projects and more than 10,000 contracts, and the functions of the material contract management module of the ECP system headquarters have been maturely applied, and the online deployment of the annual capital plan calculation model has a reliable experience and data foundation. Therefore, based on the annual capital plan calculation model, State Grid Material Company applies the achievements of the State Grid Corporation's modern smart supply chain construction, deploys the calculation logic online, automatically captures basic data, and implements the classification and calculation of various material capital demand functions in the auxiliary layer according to the idea of ​​"penetrating layer by layer and summarizing level by level". At the detailed layer, it penetrates to view the payment plan of the contract dimension, and at the summary layer, it realizes the one-click generation of the annual capital plan report according to the project + funding unit dimension. The idea of ​​building the online function of the annual capital plan is shown in Table 4, and the data structure is as follows: Figure 6 shown.

[0123] Table 4: Ideas for building online functions for the annual funding plan for engineering materials

[0124]

[0125] Step 6. Generate annual funding plan report with one click.

[0126] The system for constructing an annual capital plan calculation model for materials supplied to Class A of a UHV power project according to the present invention comprises:

[0127] The data collection module is used to collect basic project information, project approval plans, project milestone plans from the infrastructure business management system, and contract signing, performance, and settlement data from the material business management system through the data center.

[0128] Data cleaning module, used to correct and transform the collected data to meet data analysis requirements;

[0129] The funding plan calculation module is used to collect the contract signing, performance, and settlement data of the supply materials contracts for unapproved projects according to the project tree. It analyzes and explores the capital flow patterns of various materials and funds for each individual project type, generates data parameter templates, and calculates the funding plan. For approved projects, the funding plan is calculated based on the contract signing, performance, and settlement data of the supply materials contracts signed for the project.

[0130] The calculation result display module is used to display the capital plan calculation results layer by layer according to "material category / contract-single project-investor-project" based on the calculation logic of the annual capital plan calculation model.

Claims

1. A method for constructing a calculation model for annual funding plan of materials supplied to UHV power projects, characterized in that: The steps include: (1) Collect basic project information, project approval plans, project milestone plans from the infrastructure business management system, and contract signing, performance, and settlement data from the material business management system through the data center; (2) Correct and transform the collected data to meet the requirements of data analysis; (3) For unapproved projects, the contract signing, performance, and settlement data of the materials supplied by Party A under the historical projects are collected according to the project tree. The capital flow patterns of various materials and funds of each type of individual project are analyzed and mined. Data parameter templates are generated and the capital plan is calculated. For approved projects, the capital plan is calculated based on the contract signing, performance, and settlement data of the materials supplied by Party A. (4) Based on the calculation logic of the annual capital plan calculation model, the capital plan calculation results are displayed layer by layer according to "material category / contract-single project-funding unit-project"; The step (3) of calculating the unapproved project funding plan includes: (3.1) Generate data parameter templates, using time series algorithms and big data technology to aggregate contract signing, performance, and settlement data for historical projects under supply contracts. Analyze and mine the material and capital flow patterns of each type of project, and automatically generate parameter values ​​in the data parameter templates. (3.2) Calculation of funding plans for unapproved projects: Based on the project's estimated investment amount, estimated approval date, and estimated commissioning date, the corresponding project type's data parameter template is applied. The payment amount and payment time for each stage are calculated according to the material category dimension, and the annual and monthly funding demand plans for individual projects, funding units, and engineering project levels are summarized and calculated step by step.

2. The method for constructing an annual capital plan calculation model for materials supplied by Class A to a UHV power project according to claim 1, characterized in that: The basic information of the project in step (1) includes the project name, funding unit, construction period, single project, project type, and static investment amount; the project approval plan includes the project approval date, the project milestone plan includes the project commissioning date, the contract signing data includes the contract legal number, effective date, project, supplier name, contract line item, goods name, quantity, and unit price; the contract performance data includes the supply plan number, contract line item, delivery quantity, and delivery date; and the contract settlement data includes the payment stage, application amount, and payment date.

3. The method for constructing an annual capital plan calculation model for materials supplied by UHV power project A according to claim 1 is characterized in that: The rules for correcting and transforming the collected data in step (2) are as follows: removing duplicate data - only obtaining the signing data of effective contracts - the settlement data of paid contracts - the corresponding material categories - the correction of payment stage names and the supplement of empty values.

4. The method for constructing an annual capital plan calculation model for materials supplied by Class A to a UHV power project according to claim 1, characterized in that: When the problem that the program cannot handle is encountered during the correction and conversion of the collected data in step (2), the abnormal situation is recorded and a corresponding report is generated. The corresponding processing is then performed manually according to the report, and it is continuously supplemented and improved based on processing experience.

5. The method for constructing an annual capital plan calculation model for materials supplied by Class A to a UHV power project according to claim 1, characterized in that: The calculation formula for advance payment, progress payment, delivery payment, commissioning payment and warranty payment in step (3.2) is as follows: Advance payment amount = estimated project investment × corresponding material category investment ratio × advance payment ratio; Advance payment time = estimated project approval time + advance payment payment time interval; Progress payment amount = estimated project investment × investment proportion of corresponding material category × progress payment ratio; Progress payment time = estimated project approval time + progress payment time interval; Amount of payment upon delivery = estimated project investment × investment proportion of corresponding material category × proportion of goods arriving in batches × proportion of payment upon delivery; Time for payment upon receipt of payment = estimated time for project approval + time interval for payment upon receipt of payment in batches; Amount of commissioning payment = estimated project investment × investment proportion of corresponding material category × commissioning payment ratio; Payment time for commissioning payment = estimated commissioning time of the project + payment time interval for commissioning payment; Warranty payment amount = estimated project investment × corresponding material category investment ratio × warranty payment ratio; Warranty payment payment time = project expected commissioning time + warranty payment payment time interval.

6. The method for constructing an annual capital plan calculation model for materials supplied by UHV power project A according to claim 1, characterized in that: The step (3) of calculating the approved project funding plan includes: Based on project and contract signing data, contract performance supply plans, and contract settlement data, the payment amount and payment time for each stage are calculated according to the contract dimension, and the annual and monthly funding demand plans for individual projects, funding units, and engineering project levels are summarized and calculated step by step according to the project tree.

7. The method for constructing an annual capital plan calculation model for materials supplied to Class A of a UHV power project according to claim 6, characterized in that: The calculation formula for the advance payment, progress payment, delivery payment, commissioning payment and warranty payment in the approved project funding plan is as follows: Advance payment amount = Contract amount × Advance payment ratio - Cumulative payment amount of the amount; Advance payment payment time = the month following the month of preparation of the plan; Progress payment amount = Contract amount × Progress payment ratio - Cumulative payment amount for that amount; Progress payment time = the month following the month when the plan is prepared; Amount of payment upon delivery = quantity of goods delivered in the supply plan × price excluding tax × (1 + tax rate) × payment ratio upon delivery – cumulative amount paid for the item; Payment time upon arrival = arrival time in supply plan + n days; Amount of commissioning payment = Contract amount × commissioning payment ratio - accumulative amount paid for the payment; Payment time for commissioning payment = estimated commissioning time of the project + n days; Warranty payment amount = Contract amount × Warranty payment ratio - Cumulative payment amount of the amount; Warranty payment payment time = estimated project commissioning time + warranty period + n days; If a letter of guarantee is issued in lieu of warranty payment, the payment time = the time it takes to complete the warranty document processing + n days.

8. The method for constructing an annual capital plan calculation model for materials supplied by Class A to a UHV power project according to claim 1, characterized in that: The step (4) is divided into three levels, namely: The first level is the auxiliary level. Unapproved projects display payment plans for each material category based on material categories. Approved projects display the arrival and payment plans for each material line in the contract based on contract material items. The second level is the detailed level, which shows the payment plan for each payment according to the contract; The third level is the summary level, which displays the annual funding plan report. The report is based on the project tree and displays the annual and monthly funding demand plans by project and funding unit.

9. A system for building an annual capital plan calculation model for materials supplied by UHV power projects, characterized in that: include: The data collection module is used to collect basic project information, project approval plans, project milestone plans from the infrastructure business management system, and contract signing, performance, and settlement data from the material business management system through the data center. Data cleaning module, used to correct and transform the collected data to meet data analysis requirements; The funding plan calculation module is used to collect the contract signing, performance, and settlement data of the supply materials contracts for unapproved projects according to the project tree. It analyzes and explores the capital flow patterns of various materials and funds for each individual project type, generates data parameter templates, and calculates the funding plan. For approved projects, the funding plan is calculated based on the contract signing, performance, and settlement data of the supply materials contracts signed for the project. The calculation result display module is used to display the calculation results of the annual capital plan calculation model in layers by "Material Category / Contract - Single Project - Sponsor - Project"; The calculation of funding plan for unapproved projects includes: (3.1) Generate data parameter templates, using time series algorithms and big data technology to aggregate contract signing, performance, and settlement data for historical projects under supply contracts. Analyze and mine the material and capital flow patterns of each type of project, and automatically generate parameter values ​​in the data parameter templates. (3.2) Calculation of funding plans for unapproved projects: Based on the project's estimated investment amount, estimated approval date, and estimated commissioning date, the corresponding project type's data parameter template is applied. The payment amount and payment time for each stage are calculated according to the material category dimension, and the annual and monthly funding demand plans for individual projects, funding units, and engineering project levels are summarized and calculated step by step.

Images