Establishment method and system for annual fund plan measurement and calculation model of ultrahigh-voltage electric power engineering first supply material
By constructing an annual fund plan calculation model in UHV projects, analyzing historical data using big data and time series algorithms, and generating data parameter templates, the uncertainty problem of unapproved project fund plan calculation is solved, and the UHV project A is realized Accurate calculation and efficient preparation of annual funding plans for supplies.
Patent Information
- Application Number
- CN202411487202.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-23
- Publication Date
- 2025-02-14
- Estimated Expiration
- 2044-10-23
AI Technical Summary
It is difficult to accurately calculate the annual funding plan for UHV supplies for UHV projects, especially in the lack of accurate contract data and material supply plan support in unapproved projects, resulting in uncertainty and inefficiency in the calculation of funding plans.
Through the data middle platform, data from the infrastructure business management system and material business management system are collected, data correction and transformation are carried out, big data technology and time series algorithms are used to analyze historical engineering data, generate data parameter templates, collect data according to the engineering tree, and automatically Generate annual funding plans. For approved projects, the project tree is used to automatically collect contract signing, performance and settlement data, and calculate the payment amount and time of the payment according to the contract dimension.
The calculation of the funding plan for unapproved and approved projects has been achieved, the accuracy and preparation efficiency of the funding plan has been improved, and the lean management level of project materials and funds has been enhanced.
Smart Images

Figure CN119443610A_ABST
Abstract
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 a UHV power project and a system thereof. Background Art
[0002] At present, the annual fund plan control work mode of UHV project supply materials is in urgent need of change. On the one hand, the construction and management mode of UHV projects is very special, and the annual fund plan preparation work of the project is multi-faceted and involves multiple departments and links such as contract signing, performance, and settlement. It is urgent to summarize the experience of project material management, explore the internal laws of material supply, and promote the further improvement of work quality and efficiency; on the other hand, the state has successively introduced a number of policies to optimize the business environment. In order to ensure the timely payment of funds for small and medium-sized enterprises, the State Grid Corporation of China has increased its lean control requirements for the use of funds for supply materials year by year. The original "manual calculation, offline preparation" model is difficult to meet the State Grid Corporation of China's requirements for the accuracy of the annual plan. It is urgent to upgrade the information support strength and further improve the service guarantee capability.
[0003] The widespread application of new technologies such as big data and artificial intelligence has provided new technical means for tapping the potential value of enterprise data and supporting the development of the company. However, the current annual capital plan preparation process only relies on manual offline preparation and submission, which has low work efficiency and affects the improvement of work quality. Therefore, it is urgent to make full use of the company's current mature technical means and business data to build an annual capital plan calculation model to provide effective support for annual capital plan management and control.
[0004] A Chinese patent with 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 the contract cluster association at the project level is not constructed. After the bidding of 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-professional 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 "contract cluster management" from a project perspective, 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 construction are mostly derived from the estimated time data, and the stability and accuracy are relatively poor. 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 UHV power project A-supply materials of 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 materials supplied by Party A under historical projects are collected according to the project tree, and the capital flow patterns of various materials of each type of single project are analyzed and mined to generate data parameter templates and calculate the capital plan; for approved projects, the capital plan is calculated based on the contract signing, performance, and settlement data of the signed contracts for 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, commodity name, quantity, and unit price; the contract performance data includes the supply plan number, contract line item, delivery quantity, and delivery date; 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 - corresponding material categories - correcting the names of payment stages and supplementing empty values.
[0013] Furthermore, when the step (2) encounters a problem that the program cannot handle during the correction and conversion of the collected data, the abnormal situation is recorded and a corresponding report is generated, and manual processing is performed accordingly according to the report, and it 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, use time series algorithms, apply big data technology, collect the contract signing, performance, and settlement data of the supply materials under historical projects according to the project tree, analyze and mine the capital flow rules of various types of materials for each single project type, and automatically generate parameter values in the data parameter template;
[0016] (3.2) Calculation of funding plans for unapproved projects: Based on the estimated investment amount, estimated approval date, and estimated commissioning date of the project, the data parameter template of the corresponding project type is applied to calculate the payment amount and payment time of each stage 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, operation payment and warranty payment in step (3.2) is as follows:
[0018] Amount of advance payment = estimated project investment × investment proportion of corresponding material category × advance payment ratio;
[0019] Advance payment time = estimated project approval time + advance payment time interval;
[0020] Progress payment amount = estimated project investment amount × corresponding material category investment ratio × 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 arrival = estimated time for project approval + time interval for payment upon arrival of goods in batches;
[0024] Amount of payment for commissioning = estimated project investment × investment proportion of corresponding material category × proportion of payment for commissioning;
[0025] Payment time for commissioning = estimated commissioning time of the project + time interval for payment of commissioning;
[0026] Warranty payment amount = estimated project investment amount × 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, 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 the single project, funding unit and engineering project level 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 time = the month following the month when the plan is prepared;
[0033] Progress payment amount = contract amount × progress payment ratio - the cumulative amount of payments made;
[0034] Progress payment time = the month following the month when the plan is prepared;
[0035] Amount of payment on delivery = quantity of goods delivered in the supply plan × unit price excluding tax × (1 + tax rate) × payment ratio on delivery – the accumulated amount of payment for this item;
[0036] Payment time upon delivery = arrival time in the supply plan + n days;
[0037] The payment amount of commissioning payment = contract amount × commissioning payment ratio - the accumulated payment amount of the payment;
[0038] Payment time for commissioning = 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 when the warranty document is processed + n days.
[0042] Furthermore, the step (4) is divided into three levels, namely:
[0043] 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 line 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 annual fund plan calculation model construction system for UHV power project A-supply materials of the present invention comprises:
[0047] The data collection module is used to 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 center;
[0048] Data cleaning module, used to correct and transform the collected data to meet the requirements of data analysis;
[0049] The funding plan calculation module is used to collect the contract signing, performance and settlement data of the Party A supply material contracts under the historical projects according to the project tree for unapproved projects, analyze and mine the capital flow rules of various materials of each single project type, generate data parameter templates and calculate the funding plan; for approved projects, the funding plan is calculated based on the contract signing, performance and settlement data of the Party A supply material contracts that have been signed;
[0050] The calculation result display module is used to display the calculation results of the capital plan in layers and levels according to "material category / contract-single project-investor-project" based on the calculation logic of the annual capital plan calculation model.
[0051] Beneficial effect: Compared with the prior art, the present invention has the following significant advantages: Classified construction of annual funding 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, generate a calculation parameter template, and bring in the unapproved project data to automatically generate an annual funding plan, solving the problem that unapproved projects have no accurate contract data and material supply plan to support funding plan calculation; for approved projects, the project tree is used to automatically collect 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 funding plan according to the funding plan calculation logic; the annual funding plan calculation model for engineering materials realizes real-time business linkage, automatic information capture, and dynamic data update, effectively improves the accuracy of funding plans and the quality and efficiency of compilation, and greatly improves 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 schematic diagram of the online functional structure of the annual funding plan for engineering materials. DETAILED DESCRIPTION
[0058] The technical solution of the present invention is further described below in conjunction with the accompanying drawings.
[0059] like Figure 1 As shown, the present invention comprises 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] The basic information of the project includes the project name, funding unit, construction period, single project, project type, static investment amount and other 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, unit price and other information; the contract performance data includes the supply plan number, contract line item, delivery quantity, delivery date and other information; the contract settlement data includes the payment stage, application amount, payment date and other information.
[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 names of payment stages (advance payment / arrival payment / operation payment / warranty deposit) and supplement empty values, etc.
[0063] In the process of data cleaning, when encountering problems that the program cannot handle, the abnormal situation will be recorded and a corresponding report will be generated. Manual processing will 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 materials supplied by Party A under historical projects are collected according to the project tree, and the capital flow patterns of various materials of each type of single project are analyzed and mined to generate data parameter templates and calculate the capital plan; for approved projects, the capital plan is calculated based on the contract signing, performance, and settlement data of the signed contracts for materials supplied by Party A;
[0065] (3.1) Calculation of funding plan for unapproved projects
[0066] (3.1.1) Generate data parameter template
[0067] The unapproved project Party A supplies lack accurate contract data and material supply plans as support. Party A supplies are divided into 20 categories according to their characteristics, and a capital plan calculation data parameter template is set according to the type of single project. An example is shown in Table 1. Figure 2 As shown, by adopting the time series algorithm and applying the big data technology, the contract signing, performance and settlement data of the Party A supply materials under the historical projects are collected according to the project tree, and the capital flow rules of various types of materials for each single project type 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 plan
[0071] According to the estimated investment amount, estimated approval date, and estimated commissioning date of the project, the data parameter template of the corresponding project type is applied, and the payment amount and payment time of each stage are calculated according to the material category dimension (the calculation rules are as follows), and the annual and monthly capital demand plans of the single project, funding unit, and project level are summarized and calculated step by step, such as Figure 3 shown.
[0072] 1) Advance payment
[0073] Payment amount = estimated project investment amount × 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 time interval
[0078] 3) Payment upon delivery
[0079] Payment amount = estimated project investment × corresponding material category investment ratio × batch arrival ratio × payment ratio
[0080] Payment time = estimated project approval time + payment time interval for batches of goods
[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 + payment time interval for commissioning
[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 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), contract settlement data (paid amount) and other data, calculate the payment amount and payment time of 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 the single project, funding unit, and project level according to the project tree, such as Figure 4 shown.
[0089] 1) Advance payment
[0090] Payment amount = contract amount × advance payment ratio - the total amount paid for the payment
[0091] Payment date = the month following the date of planning
[0092] 2) Progress Payment
[0093] Payment amount = contract amount × progress payment ratio - the total amount paid for the payment
[0094] Payment date = the month following the date of planning
[0095] 3) Payment upon delivery
[0096] Payment amount = the number of arrivals in the supply plan × the unit price excluding tax × (1 + tax rate) × the payment ratio of the arrival payment - the cumulative amount of payment for the payment (only the first batch of arrival payment)
[0097] Payment time = arrival time in supply plan + n days
[0098] 4) Operation fee
[0099] Payment amount = contract amount × payment ratio of commissioning payment - the total 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 - the total 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, the payment time = the time when the warranty document is issued + 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 estimation model, the capital plan estimation results are displayed layer by layer according to "material category / contract-single project-investment 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 UHV project A-supply materials is roughly divided into six steps:
[0112] Step 1. Build a "project tree" and implement classified material management. For the contracts of approved projects, the "project tree" is configured online through the State Grid Corporation's first-level e-commerce platform (hereinafter referred to as the ECP system), and material contracts are collected by project, funding unit, single project and other dimensions, and classified research and management are implemented. At present, 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 experience data. Summarize the historical experience data of engineering material management, establish data templates according to individual projects and material categories, divide the A-supplied materials required for UHV projects into 20 categories, summarize the investment, supply, and settlement rules of various types of materials, and solve the problem of lack of contract data support for unapproved projects. Taking a certain equipment material in a converter station of a certain voltage level as an example, its estimated proportion of total investment, payment ratio of each category of materials, and supply plan are shown in Table 2. When preparing the annual capital plan, you can choose to apply the data template of the corresponding individual project 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 the calculation logic and accurately calculate the funding needs. In combination with the characteristics of UHV projects, according to the principle of "classification design", we build the annual funding plan calculation logic for approved projects and unapproved projects respectively, set data parameters, clarify data sources, and accurately calculate the funding demand plan. As shown in Table 3, the calculation model and related parameters have been verified in the practice of annual funding plan management of UHV projects, and are continuously optimized and improved according to business actual conditions.
[0117] Table 3: Parameters and logic settings of the project material capital planning calculation model
[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 reliable experience and data foundation. Therefore, based on the annual capital plan calculation model, State Grid Material Company applies the achievements of 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 + investment 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 capital plan for construction materials
[0124]
[0125] Step 6. Generate annual funding plan report with one click.
[0126] The annual fund plan calculation model construction system for UHV power project A-supply materials of the present invention comprises:
[0127] The data collection module is used to 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 center;
[0128] Data cleaning module, used to correct and transform the collected data to meet the requirements of data analysis;
[0129] The funding plan calculation module is used to collect the contract signing, performance and settlement data of the Party A supply material contracts under the historical projects according to the project tree for unapproved projects, analyze and mine the capital flow rules of various materials of each single project type, generate data parameter templates and calculate the funding plan; for approved projects, the funding plan is calculated based on the contract signing, performance and settlement data of the Party A supply material contracts that have been signed;
[0130] The calculation result display module is used to display the calculation results of the capital plan in layers 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 an annual capital plan calculation model for materials supplied by UHV power engineering, 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 materials supplied by Party A under historical projects are collected according to the project tree, and the capital flow patterns of various materials of each type of single project are analyzed and mined to generate data parameter templates and calculate the capital plan; for approved projects, the capital plan is calculated based on the contract signing, performance, and settlement data of the signed contracts for 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-investor-project".
2. The method for constructing an annual capital plan calculation model for UHV power project A-supply materials according to claim 1 is 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 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, commodity name, quantity and unit price; the contract performance data includes the supply plan number, contract line item, delivery quantity and delivery date; 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 UHV power project A-supply materials according to claim 1 is characterized in that: The rules for modifying 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 correspondence of material categories - the modification of payment stage names and the supplementation of empty values.
4. The method for constructing an annual capital plan calculation model for materials supplied by UHV power engineering class A according to claim 1 is characterized in that: When the step (2) encounters a problem that the program cannot handle during the correction and conversion of the collected data, 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 UHV power project A according to claim 1 is characterized in that: The step (3) of calculating the unapproved project funding plan includes: (3.1) Generate data parameter templates, use time series algorithms, apply big data technology, collect the contract signing, performance, and settlement data of the supply materials under historical projects according to the project tree, analyze and mine the capital flow rules of various types of materials for each single project type, and automatically generate parameter values in the data parameter template; (3.2) Calculation of funding plans for unapproved projects: Based on the estimated investment amount, estimated approval date, and estimated commissioning date of the project, the data parameter template of the corresponding project type is applied to calculate the payment amount and payment time of each stage 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.
6. The method for constructing an annual capital plan calculation model for materials supplied by UHV power project A according to claim 5 is characterized in that: The calculation formula for advance payment, progress payment, delivery payment, operation payment and warranty payment in step (3.2) is as follows: Amount of advance payment = estimated project investment × investment proportion of corresponding material category × advance payment ratio; Advance payment time = estimated project approval time + advance payment time interval; Progress payment amount = estimated project investment amount × corresponding material category investment ratio × 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 arrival = estimated time for project approval + time interval for payment upon arrival of goods in batches; Amount of payment for commissioning = estimated project investment × investment proportion of corresponding material category × proportion of payment for commissioning; Payment time for commissioning = estimated commissioning time of the project + time interval for payment of commissioning; Warranty payment amount = estimated project investment amount × corresponding material category investment ratio × warranty payment ratio; Warranty payment payment time = project expected commissioning time + warranty payment payment time interval.
7. The method for constructing an annual capital plan calculation model for materials supplied by UHV power engineering class A according to claim 1 is characterized in that: The step (3) of calculating the approved project funding plan includes: Based on the project, 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 the single project, funding unit and engineering project level are summarized and calculated step by step according to the project tree.
8. The method for constructing an annual capital plan calculation model for UHV power project A-supply materials according to claim 7 is 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 time = the month following the month when the plan is prepared; Progress payment amount = contract amount × progress payment ratio - the cumulative amount of payments made; Progress payment time = the month following the month when the plan is prepared; Amount of payment on delivery = quantity of goods delivered in the supply plan × unit price excluding tax × (1 + tax rate) × payment ratio on delivery – the accumulated amount of payment for this item; Payment time upon delivery = arrival time in the supply plan + n days; The payment amount of commissioning payment = contract amount × commissioning payment ratio - the accumulated payment amount of the payment; Payment time for commissioning = 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 when the warranty document is processed + n days.
9. The method for constructing an annual capital plan calculation model for materials supplied by Class A in UHV power projects according to claim 1, characterized in that: The step (4) is divided into three levels, namely: 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 line 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.
10. A system for building a model for calculating the annual capital plan of materials supplied by UHV power engineering, characterized in that: include: The data collection module is used to 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 center; Data cleaning module, used to correct and transform the collected data to meet the requirements of data analysis; The funding plan calculation module is used to collect the contract signing, performance and settlement data of the Party A supply material contracts under the historical projects according to the project tree for unapproved projects, analyze and mine the capital flow rules of various materials of each single project type, generate data parameter templates and calculate the funding plan; for approved projects, the funding plan is calculated based on the contract signing, performance and settlement data of the Party A supply material contracts that have been signed; The calculation result display module is used to display the calculation results of the capital plan in layers and levels according to "material category / contract-single project-investor-project" based on the calculation logic of the annual capital plan calculation model.
Citation Information
Patent Citations
A method for allocating fund requirements of power grid engineering
CN109345053A
Electric power engineering project investment management system
CN109784681A
Method and system for constructing annual planning model of newly-opened power grid infrastructure project
CN110942204A
Three-rate-in-one-based power grid infrastructure main network project multi-dimensional collaborative management and control system
CN113837730A
Method for monitoring collaborative execution condition of investment plan and fund plan of power grid infrastructure project
CN114240044A