Procurement price calculation method for engineering service project

Through the combination of hierarchical clustering and price calculation model, a reference system for procurement price standards for engineering service projects was constructed, which solved the problems of inconsistent sub-item calibers and lack of pricing basis, and improved the accuracy of procurement standardization and bid evaluation and price verification.

CN119067700APending Publication Date: 2024-12-03JIANGSU ELECTRIC POWER CO PURCHASING & DISTRIBUTION CENT +1
View PDF 0 Cites 2 Cited by

Patent Information

Application Number
CN202411260068.3
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-09-10
Publication Date
2024-12-03

AI Technical Summary

Technical Problem

During the bidding and procurement process of engineering service projects, due to the inconsistent quotation sub-items in the technical specifications, the lack of review standards and bid evaluation basis, it leads to difficulty in planning review and bid evaluation and price verification, and the cost cannot be accurately controlled.

Method used

Use hierarchical clustering method to classify projects, form similar project sets, extract and analyze historical quotation data, build price calculation models, establish standardized project sub-item database and fee collection standard table, establish a pricing basis update mechanism, and regularly update procurement references Price, build a complete procurement price standard reference system.

Benefits of technology

The level of procurement standardization and quality efficiency are improved, the scientificity and accuracy of bid evaluation and price verification are ensured, the problems of inconsistent sub-item caliber and lack of pricing basis are solved, and the precise control of procurement prices is achieved.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119067700A_ABST
    Figure CN119067700A_ABST
Patent Text Reader

Abstract

The invention relates to the field of engineering and project management, in particular to an engineering service project purchase price calculation method, which comprises the following steps of: collecting and analyzing technical specifications in the past three years, and classifying projects by adopting a hierarchical clustering method to form a similar project set; performing sub-item extraction and probability calculation on the amount quotation project to form a standardized project sub-item library; based on the project sub-item library, historical quotation data is extracted, a price calculation model is constructed, and the reference unit price of each sub-item is calculated; updating a technical specification book for discount proportion quotation items; extracting and sorting fee taking standards of national standards, industrial standards and enterprise standards; establishing an updating and maintaining mechanism based on pricing; updating the purchase reference price of each sub-item by adopting an iterative calculation method; and a complete engineering service project purchase price standard reference system is constructed. According to the invention, engineering service projects can be focused through the purchase price standard reference system, and the purchase standardization level and the purchase quality and efficiency are improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of engineering and project management, and in particular to a method for calculating the procurement price of an engineering service project. Background Art

[0002] In bidding and procurement activities, the technical specification, as an important document in the bidding process, plays a decisive role in the performance of the bidding contract. The technical specification specifies in detail the key contents such as the technical standards, scope of work, and technical requirements of the project, which directly affects the execution of the bidding contract and the successful implementation of the project.

[0003] At present, the quotation sub-item scope and granularity in the technical specifications compiled by various units of engineering service projects are inconsistent, and the review lacks audit standards and the bid evaluation lacks pricing basis, which makes plan review and bid evaluation and pricing difficult, and makes it impossible to accurately control construction costs. Summary of the invention

[0004] In order to solve the above technical problems, the present invention provides a method for calculating the procurement price of engineering service projects.

[0005] The present invention adopts the following technical solution: a method for calculating the procurement price of an engineering service project, the method comprising:

[0006] Collect and analyze technical specifications from the past three years, and use hierarchical clustering methods to classify projects into similar project sets, laying the foundation for subsequent price calculation and standardization;

[0007] Extract and calculate the probability of the quotation items, form a standardized project sub-item library, and provide basic data for price calculation;

[0008] Based on the project sub-item database, extract historical quotation data, build a price calculation model, and calculate the reference unit price of each sub-item;

[0009] For projects with discounted quotation ratios, update technical specifications;

[0010] Extract and organize the charging standards of national standards, industry standards and enterprise standards to form a standardized charging standard form;

[0011] Establish an update and maintenance mechanism for pricing basis to ensure timely update of technical specifications and charging standards;

[0012] Adopt iterative calculation method to regularly update the purchase reference price of each sub-item;

[0013] By solidifying technical specifications, project sub-item libraries, price calculation models, charging standards and update mechanisms, a complete reference system for procurement price standards for engineering service projects is established.

[0014] A method for calculating the procurement price of engineering service projects according to an embodiment of the present invention focuses on engineering service projects through the procurement price standard reference system, with the goal of improving the level of procurement standardization and procurement quality and efficiency. Based on historical bidding documents, cluster analysis is used to hierarchically decompose the projects to obtain a minimum set of project types. Based on similar projects, the technical specification template and project sub-items are solidified. Based on historical feasibility documents, a price calculation model is used to construct a procurement reference price for each sub-item, and regular iterative calculations are performed for rolling updates.

[0015] Furthermore, the steps of collecting and analyzing the technical specifications in the past three years and classifying the projects using the hierarchical clustering method specifically include:

[0016] Collect technical specifications from each unit over the past three years, and then use Python to write scripts to clean the collected data and remove invalid or duplicate data;

[0017] Using the hierarchical clustering algorithm, the projects are classified according to material codes, material subcategories, material descriptions and technical parameters to obtain a set of similar projects;

[0018] Hierarchical clustering was performed using Ward's method to maximize homogeneity within the cluster and heterogeneity between clusters;

[0019] The main features of the materials are extracted as input for clustering, and the main features include coding, sub-categories, descriptions, and technical parameters.

[0020] Furthermore, the steps of extracting and calculating the probability of the amount quotation items to form a standardized item sub-item library specifically include:

[0021] Go through the technical specifications, extract all project sub-items, and form a preliminary sub-item list;

[0022] Calculate the probability of occurrence of each sub-item in the past three years and use the weighted average method to set the weight;

[0023] Using an outlier detection algorithm to remove abnormal data, the outlier detection algorithm includes an IQR method;

[0024] The cleaned sub-item data is stored in the database to form a standardized project sub-item library.

[0025] Furthermore, the steps of extracting historical quotation data based on the project sub-item library and constructing a price estimation model specifically include:

[0026] Collect feasibility study documents from the past three years and extract historical quotation data for each item;

[0027] Use the box plot method to build a price estimation model and calculate the quote range value for each sub-item;

[0028] Use the box plot method to determine the statistics of each sub-item, including the median, quartiles, upper and lower whiskers, eliminate outliers, and calculate the quotation range;

[0029] Based on the box plot analysis results, determine the reference unit price of each sub-item and store it in the database.

[0030] Furthermore, for the discount ratio quotation project, the steps of updating the technical specification include:

[0031] Collect the quotation basis documents of the latest year and extract relevant data;

[0032] Update the solidified technical specification template according to the latest quotation basis document.

[0033] Furthermore, the steps of extracting and arranging the charging standards of national standards, industry standards and enterprise standards to form a standardized charging standard form specifically include:

[0034] Collect and organize fee standard documents of national standards, industry standards and enterprise standards;

[0035] According to the fee standard documents, relevant fee data is extracted and organized into a standardized fee standard form.

[0036] Furthermore, the steps of establishing an update and maintenance mechanism for pricing basis specifically include:

[0037] Design a file version management system to record the version information and implementation start and end time of each file;

[0038] Set up an automatic reminder function for file expiration so that files can be updated in time after they expire;

[0039] Regularly check and maintain pricing basis documents, and use the latest version of technical specifications and charging standards.

[0040] Furthermore, the step of regularly updating the purchase reference price of each sub-item by adopting the iterative calculation method specifically includes:

[0041] Regularly collect feasibility study documents of various projects and extract the latest quotation data;

[0042] Use the price estimation model to iteratively calculate the new data and update the reference price of each sub-item;

[0043] Adjust the parameters of the price estimation model based on new data to make the model more accurate;

[0044] Update the itemized reference prices in the database to make the price standards up-to-date.

[0045] Furthermore, the steps for constructing a complete reference system for procurement price standards for engineering service projects specifically include:

[0046] Formulate standardized technical specification templates to solidify the content and format of technical specifications;

[0047] Establish a standardized project sub-item database to make the sub-item data unified and standardized;

[0048] Build and regularly update the price calculation model to ensure the accuracy of the reference unit price;

[0049] Extract and organize the fee standards to form a standardized fee standard form;

[0050] Establish an update and maintenance mechanism for pricing basis and reference prices to ensure the long-term operation of the system. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0052] Figure 1 The present invention is a flowchart of a method for calculating the procurement price of an engineering service project.

[0053] Figure 2 A material coding classification hierarchy diagram for a method for calculating procurement prices for engineering service projects according to the present invention. DETAILED DESCRIPTION

[0054] Embodiments of the present invention are described in detail below, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the embodiments of the present invention, and should not be construed as limiting the present invention.

[0055] In the description of the embodiments of the present invention, it should be understood that the terms "length", "width", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside" and "outside" etc., indicating orientations or positional relationships, are based on the orientations or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the embodiments of the present invention and simplifying the description, and do not indicate or imply that the referred device or element must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be understood as a limitation on the present invention.

[0056] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of the features. In the description of the embodiments of the present invention, the meaning of "plurality" is two or more, unless otherwise clearly and specifically defined.

[0057] In the embodiments of the present invention, unless otherwise clearly specified and limited, the terms "installed", "connected", "connected", "fixed" and the like should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection or an indirect connection through an intermediate medium, it can be the internal connection of two elements or the interaction relationship between two elements. For ordinary technicians in this field, the specific meanings of the above terms in the embodiments of the present invention can be understood according to specific circumstances.

[0058] Embodiment 1

[0059] Reference Figure 1 The first embodiment of the present invention is a method for calculating the procurement price of an engineering service project, the method comprising:

[0060] S1: Collect and analyze technical specifications from the past three years, and use hierarchical clustering methods to classify projects into similar project sets, laying the foundation for subsequent price calculation and standardization;

[0061] Furthermore, the steps of collecting and analyzing the technical specifications in the past three years and classifying the projects using the hierarchical clustering method specifically include:

[0062] Technical specifications for the past three years were collected from various units to ensure the comprehensiveness and representativeness of the data.

[0063] Use Python to write scripts to clean the collected data, remove invalid or duplicate data, and ensure data accuracy.

[0064] A hierarchical clustering algorithm is used to classify items according to material codes, material subcategories, material descriptions, and technical parameters to obtain a set of similar items.

[0065] Ward's method was used for hierarchical clustering to maximize the homogeneity within the clusters and the heterogeneity between the clusters.

[0066] The main characteristics of the materials, such as codes, subcategories, descriptions, technical parameters, etc., are extracted as input for clustering.

[0067] Data cleaning: Improve the accuracy and consistency of data and lay the foundation for subsequent analysis.

[0068] Accurate classification: The hierarchical clustering method ensures the accuracy and scientificity of project classification, which is helpful for subsequent price measurement and standardization work.

[0069] S2: Extract and calculate the probability of the quotation items, form a standardized project sub-item library, and provide basic data for price calculation;

[0070] Furthermore, the steps of extracting and calculating the probability of the quotation items to form a standardized item sub-item library specifically include:

[0071] Calculate the probability of occurrence of each sub-item in the past three years, and use the weighted average method (45% in the previous year, 35% in the previous two years, and 20% in the previous three years) to set the weights.

[0072] Outlier removal: Use outlier detection algorithms (such as the IQR method) to remove abnormal data and ensure data reliability.

[0073] Establishment of project sub-item library: store the cleaned sub-item data into the database to form a standardized project sub-item library.

[0074] Data standardization: Form a standardized project sub-item database, unify sub-item data, and solve the problem of inconsistent sub-item calibers.

[0075] Scientifically calculate probability: Probability calculation based on historical data provides a scientific basis for price estimation.

[0076] S3: Based on the project sub-item database, extract historical quotation data, build a price calculation model, and calculate the reference unit price of each sub-item;

[0077] Furthermore, the steps of extracting historical quotation data based on the project sub-item library and constructing a price estimation model specifically include:

[0078] Collect feasibility study documents from the past three years and extract historical quotation data for each sub-item.

[0079] Use the box plot method to build a price estimation model and calculate the quotation range value for each sub-item.

[0080] The box plot method is used to determine the median, quartiles, upper and lower whiskers and other statistics for each sub-item, eliminate outliers, and calculate the quotation range.

[0081] Based on the box plot analysis results, determine the reference unit price of each sub-item and store it in the database.

[0082] Accurately calculate prices: Through the price calculation model, the reference unit price of each sub-item can be accurately calculated to provide a scientific price basis.

[0083] Eliminate outliers: The box plot analysis method effectively eliminates outliers and improves the accuracy and reliability of quotations.

[0084] Dynamically adjust prices: Dynamic adjustment mechanism of reference unit price to ensure the timeliness and rationality of price standards.

[0085] S4: For projects with discount ratio quotations, update the technical specifications to ensure the accuracy and timeliness of the quotation basis;

[0086] Furthermore, for the discount ratio quotation project, the steps of updating the technical specification include:

[0087] Collect the quotation basis files of the latest year and extract relevant data.

[0088] Update the solidified technical specification template according to the latest quotation basis document to ensure the timeliness and accuracy of the quotation basis.

[0089] S5: Extract and organize the charging standards of national standards, industry standards and enterprise standards to form a standardized charging standard table;

[0090] Furthermore, the steps of extracting and arranging the charging standards of national standards, industry standards and enterprise standards to form a standardized charging standard form specifically include:

[0091] Collect and organize charging standard documents of national standards, industry standards and enterprise standards.

[0092] According to the fee standard documents, relevant fee data is extracted and organized into a standardized fee standard form.

[0093] S6: Establish an update and maintenance mechanism for pricing basis to ensure timely update of technical specifications and charging standards;

[0094] Furthermore, the steps of establishing an update and maintenance mechanism for pricing basis specifically include:

[0095] Design a file version management system to record the version information and implementation start and end time of each file.

[0096] Set up automatic reminders for file expiration to ensure timely updates after files expire.

[0097] Regularly check and maintain pricing basis documents to ensure that the latest version of technical specifications and charging standards are used.

[0098] S7: Adopt an iterative calculation method to regularly update the purchase reference price of each sub-item to ensure the accuracy and timeliness of the price standard;

[0099] Furthermore, the step of regularly updating the purchase reference price of each sub-item by adopting the iterative calculation method specifically includes:

[0100] Regularly collect feasibility study documents for various projects and extract the latest quotation data.

[0101] Use the price estimation model to iteratively calculate the new data and update the reference price of each sub-item.

[0102] Adjust the parameters of the price estimation model according to the new data to ensure the accuracy of the model.

[0103] Update the itemized reference prices in the database to ensure the timeliness of price standards.

[0104] Dynamic price adjustment: Iterative calculation method ensures dynamic adjustment of reference price to reflect market changes

[0105] S8: Build a complete reference system for procurement price standards for engineering service projects by solidifying technical specifications, project sub-item database, price calculation model, charging standards and update mechanism;

[0106] Furthermore, the steps for constructing a complete reference system for procurement price standards for engineering service projects specifically include:

[0107] Develop standardized technical specification templates to solidify the content and format of technical specifications.

[0108] Establish a standardized project sub-item database to ensure the uniformity and standardization of sub-item data.

[0109] Build and regularly update price estimation models to ensure the accuracy of reference unit prices.

[0110] Extract and organize the fee standards to form a standardized fee standard form.

[0111] Establish an update and maintenance mechanism for pricing basis and reference prices to ensure the long-term operation of the system.

[0112] A method for calculating the procurement price of engineering service projects according to an embodiment of the present invention focuses on engineering service projects through the procurement price standard reference system, with the goal of improving the level of procurement standardization and procurement quality and efficiency. Based on historical bidding documents, cluster analysis is used to hierarchically decompose the projects to obtain a minimum set of project types. Based on similar projects, the technical specification template and project sub-items are solidified. Based on historical feasibility documents, a price calculation model is used to construct a procurement reference price for each sub-item, and regular iterative calculations are performed for rolling updates.

[0113] By building a standard reference system for engineering service procurement prices, we can provide more scientific and standardized support for the planning submission and bidding and procurement activities of such projects, solve the problem of difficulties in bid evaluation and pricing, improve the service level of procurement work, and further promote the innovative development of the supply chain.

[0114] Embodiment 2

[0115] The second embodiment of the present invention is based on the same inventive concept and is a specific implementation method of a method for calculating the procurement price of engineering service projects proposed by the present invention.

[0116] S1. Data collection and project classification

[0117] Collect technical specifications:

[0118] Technical specifications for the past three years were collected from various units to ensure the comprehensiveness and representativeness of the data.

[0119] Data format: Specifications are stored in PDF or Word format and aggregated into a central database.

[0120] Responsible: Data collection team, including project managers and data analysts.

[0121] Data cleaning:

[0122] Use Python to write scripts to clean the collected data, remove invalid or duplicate data, and ensure data accuracy.

[0123] Data cleaning methods: remove duplicates, fill in missing values, and standardize data formats.

[0124] Tools: Pandas library for data processing, RegularExpression for text matching and cleaning.

[0125] Hierarchical Clustering:

[0126] A hierarchical clustering algorithm is used to classify items according to material codes, material subcategories, material descriptions, and technical parameters to obtain a set of similar items.

[0127] Algorithm selection: Hierarchical clustering using Ward's method to maximize intra-class homogeneity and inter-class heterogeneity.

[0128] Feature extraction: Extract the main features of the material, such as coding, subcategories, descriptions, technical parameters, etc., as input for clustering.

[0129] Tools: Cluster analysis is performed using the hierarchical clustering module of the SciPy library.

[0130] Beneficial effects:

[0131] Improve the comprehensiveness and representativeness of data and ensure the reliability of analysis results.

[0132] Improve the accuracy and consistency of data and lay the foundation for subsequent analysis.

[0133] The hierarchical clustering method ensures the accuracy and scientificity of project classification, which is helpful for subsequent price measurement and standardization work.

[0134] S2: Construction of project sub-library

[0135] Extract project sub-items:

[0136] Go through the technical specification, extract all project sub-items, and form a preliminary sub-item list.

[0137] Data extraction tool: Use Python's BeautifulSoup library to parse document content and extract key sub-item information.

[0138] Probability calculation:

[0139] Calculate the probability of occurrence of each sub-item in the past three years, and use the weighted average method (45% in the previous year, 35% in the previous two years, and 20% in the previous three years) to set the weights.

[0140] Tools: Use NumPy library for probability calculation and weight setting.

[0141] Outlier removal:

[0142] Use outlier detection algorithms (such as the IQR method) to remove abnormal data and ensure data reliability.

[0143] Tools: Use Pandas library for IQR outlier detection and data removal.

[0144] Project sub-item library establishment:

[0145] The cleaned sub-item data is stored in the database to form a standardized project sub-item library.

[0146] Database selection: Use PostgreSQL database for data storage and management.

[0147] Beneficial effects:

[0148] Form a standardized project sub-item database, unify sub-item data, and solve the problem of inconsistent sub-item calibers.

[0149] Improve the reliability and accuracy of data by removing outliers.

[0150] Probability calculations based on historical data provide a scientific basis for price estimation.

[0151] S3: Price estimation model construction

[0152] Extract historical quotes:

[0153] Collect feasibility study documents from the past three years and extract historical quotation data for each sub-item.

[0154] Data extraction tool: Use Python's PDFMiner library to parse feasibility study files and extract historical quotation data.

[0155] Price calculation model:

[0156] Use the box plot method to build a price estimation model and calculate the quotation range value for each sub-item.

[0157] Box plot analysis: Use the Matplotlib library to draw box plots, determine the median, quartiles, upper and lower whiskers and other statistics for each sub-item, eliminate outliers, and calculate the quotation range.

[0158] Tools: Use SciPy and NumPy libraries for statistical analysis and model building.

[0159] Reference unit price determination:

[0160] Based on the box plot analysis results, determine the reference unit price of each sub-item and store it in the database.

[0161] Data storage: The reference unit price is stored in the PostgreSQL database and updated regularly.

[0162] Beneficial effects:

[0163] Through the price calculation model, the reference unit price of each sub-item can be accurately calculated to provide a scientific pricing basis.

[0164] The box plot analysis method can effectively eliminate outliers and improve the accuracy and reliability of quotations.

[0165] The dynamic adjustment mechanism of reference unit price ensures the timeliness and rationality of price standards.

[0166] S4: Discount ratio quotation arrangement

[0167] Quotation basis:

[0168] Collect the quotation basis files of the latest year and extract relevant data.

[0169] Data organization tool: Use Python's Pandas library to organize and analyze quotation data.

[0170] Update technical specifications:

[0171] Update the solidified technical specification template according to the latest quotation basis document to ensure the timeliness and accuracy of the quotation basis.

[0172] Tools: Update the technical specification template using Microsoft Word or LaTeX editor.

[0173] Beneficial effects:

[0174] Update technical specifications to ensure the accuracy and timeliness of quotation basis.

[0175] Improve the rationality of quotations: organize quotations based on the latest data to improve the rationality and scientificity of quotations.

[0176] S5: Fee Standards

[0177] Collection fee standards:

[0178] Collect and organize charging standard documents of national standards, industry standards and enterprise standards.

[0179] Data collection tools: Use Python's Scrapy library to automatically crawl relevant files from standard databases.

[0180] Form the fee standard form:

[0181] According to the fee standard documents, relevant fee data is extracted and organized into a standardized fee standard form.

[0182] Tools: Use the Pandas library to extract data and organize tables to generate standardized fee tables.

[0183] Beneficial effects:

[0184] Establish a standardized fee collection standard form to ensure uniformity and standardization of the fee collection basis.

[0185] Improve the accuracy and consistency of charging standards and provide a reliable basis for price calculation.

[0186] S6: Pricing basis update mechanism

[0187] File version management:

[0188] Design a file version management system to record the version information and implementation start and end time of each file.

[0189] Tools: Use Git or SVN for version control and record file version change history.

[0190] Automatic reminder function:

[0191] Set up automatic reminders for file expiration to ensure timely updates after files expire.

[0192] Tools: Use Python to write scripts and combine them with Cron scheduled tasks to implement automatic reminder functions.

[0193] Scheduled maintenance:

[0194] Regularly check and maintain pricing basis documents to ensure that the latest version of technical specifications and charging standards are used.

[0195] Maintenance tools: Use the backend management system developed using the Django framework to implement regular inspection and maintenance of files.

[0196] Beneficial effects:

[0197] File version management and automatic reminder functions ensure the timeliness and accuracy of data.

[0198] Regular maintenance mechanism improves update efficiency and ensures long-term operation of pricing basis.

[0199] S7: Purchase reference price iteration

[0200] Collect feasibility study documents:

[0201] Regularly collect feasibility study documents for various projects and extract the latest quotation data.

[0202] Data collection tools: Use Python’s PDFMiner library to parse feasibility study documents and extract the latest quotation data.

[0203] Iterative calculation:

[0204] Use the price estimation model to iteratively calculate the new data and update the reference price of each sub-item.

[0205] Model update: Adjust the parameters of the price estimation model based on new data to ensure the accuracy of the model.

[0206] Tools: Use NumPy and SciPy libraries for iterative calculations and model parameter tuning.

[0207] Price Update:

[0208] Update the itemized reference prices in the database to ensure the timeliness of price standards.

[0209] Database update: Use the SQLAlchemy library to interact with the PostgreSQL database to achieve regular updates of reference prices.

[0210] Beneficial effects:

[0211] The iterative calculation method ensures dynamic adjustment of the reference price to reflect market changes.

[0212] Calculate prices based on the latest data to improve the accuracy and timeliness of reference prices.

[0213] S8: Construction of procurement price standard reference system

[0214] Curing Technical Specifications:

[0215] Develop standardized technical specification templates to solidify the content and format of technical specifications.

[0216] Tools: Use Microsoft Word or LaTeX editor to write standardized technical specification templates.

[0217] Project sub-library:

[0218] Establish a standardized project sub-item database to ensure the uniformity and standardization of sub-item data.

[0219] Database selection: Use PostgreSQL database for data storage and management.

[0220] Price calculation model:

[0221] Build and regularly update price estimation models to ensure the accuracy of reference unit prices.

[0222] Model Building: Statistical analysis and model building are performed using NumPy and SciPy libraries.

[0223] Fee Standard:

[0224] Extract and organize the fee standards to form a standardized fee standard form.

[0225] Tools: Use the Pandas library for data extraction and table organization.

[0226] Update mechanism:

[0227] Establish an update and maintenance mechanism for pricing basis and reference prices to ensure the long-term operation of the system.

[0228] Maintenance tools: A backend management system developed using the Django framework to implement regular inspection and maintenance of files.

[0229] Beneficial effects:

[0230] Build a complete procurement price standard reference system to improve the standardization level of the procurement process.

[0231] The pricing mechanism based on data and models ensures the scientificity and rationality of procurement prices.

[0232] Update the maintenance mechanism to ensure the long-term operation of the system and continue to provide reliable procurement price standards.

[0233] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "examples", "specific examples", or "some examples" means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner.

[0234] Under the premise that no conflict occurs, those skilled in the art may freely combine and superimpose the above-mentioned additional technical features.

[0235] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for calculating the procurement price of engineering service projects. It is characterized in that The method comprises: Collect and analyze technical specifications from the past few years, use hierarchical clustering methods to classify projects and form a set of similar projects, laying the foundation for subsequent price calculation and standardization; Extract and calculate the probability of the quotation items, form a standardized project sub-item library, and provide basic data for price calculation; Based on the project sub-item database, extract historical quotation data, build a price calculation model, and calculate the reference unit price of each sub-item; For projects with discounted quotation ratios, update technical specifications; Extract and organize the charging standards of national standards, industry standards and enterprise standards to form a standardized charging standard form; Establish an update and maintenance mechanism for pricing basis to ensure timely update of technical specifications and charging standards; Adopt iterative calculation method to regularly update the purchase reference price of each sub-item; By solidifying technical specifications, project sub-item libraries, price calculation models, charging standards and update mechanisms, a complete reference system for procurement price standards for engineering service projects is established.

2. According to the method for calculating the procurement price of engineering service projects described in claim 1, It is characterized in that The steps of collecting and analyzing the technical specifications of the past few years and classifying the projects using the hierarchical clustering method include: Collect technical specifications from various units over the past few years, and then use Python to write scripts to clean the collected data and remove invalid or duplicate data; Using the hierarchical clustering algorithm, the projects are classified according to material codes, material subcategories, material descriptions and technical parameters to obtain a set of similar projects; Hierarchical clustering was performed using Ward's method to maximize homogeneity within the cluster and heterogeneity between clusters; The main features of the materials are extracted as input for clustering, and the main features include coding, sub-categories, descriptions, and technical parameters.

3. According to the method for calculating the procurement price of engineering service projects described in claim 1, It is characterized in that The steps of extracting and calculating the probability of the amount quotation items to form a standardized item sub-item library specifically include: Go through the technical specifications, extract all project sub-items, and form a preliminary sub-item list; Calculate the probability of occurrence of each sub-item in recent years and use the weighted average method to set the weight; Using an outlier detection algorithm to remove abnormal data, the outlier detection algorithm includes an IQR method; The cleaned sub-item data is stored in the database to form a standardized project sub-item library.

4. According to the method for calculating the procurement price of engineering service projects described in claim 1, It is characterized in that The steps of extracting historical quotation data based on the project sub-item library and constructing a price estimation model specifically include: Collect feasibility study documents from recent years and extract historical quotation data for each item; Use the box plot method to build a price estimation model and calculate the quote range value for each sub-item; Use the box plot method to determine the statistics of each sub-item, including the median, quartiles, upper and lower whiskers, eliminate outliers, and calculate the quotation range; Based on the box plot analysis results, determine the reference unit price of each sub-item and store it in the database.

5. According to claim 1, a method for calculating the procurement price of engineering service projects, It is characterized in that For the above-mentioned discount ratio quotation projects, the steps for updating the technical specifications include: Collect the quotation basis documents of the latest year and extract relevant data; Update the solidified technical specification template according to the latest quotation basis document.

6. According to claim 1, a method for calculating the procurement price of engineering service projects, It is characterized in that The steps of extracting and collating the charging standards of national standards, industry standards and enterprise standards to form a standardized charging standard form specifically include: Collect and organize fee standard documents of national standards, industry standards and enterprise standards; According to the fee standard documents, relevant fee data is extracted and organized into a standardized fee standard form.

7. According to claim 1, a method for calculating the procurement price of engineering service projects, It is characterized in that The steps of establishing the updating and maintaining mechanism for pricing basis specifically include: Design a file version management system to record the version information and implementation start and end time of each file; Set up an automatic reminder function for file expiration so that files can be updated in time after they expire; Regularly check and maintain pricing basis documents, and use the latest version of technical specifications and charging standards.

8. According to claim 1, a method for calculating the procurement price of engineering service projects, It is characterized in that The steps of regularly updating the purchase reference price of each sub-item by adopting the iterative calculation method specifically include: Regularly collect feasibility study documents of various projects and extract the latest quotation data; Use the price estimation model to iteratively calculate the new data and update the reference price of each sub-item; Adjust the parameters of the price estimation model based on new data to make the model more accurate; Update the itemized reference prices in the database to make the price standards up-to-date.

9. According to claim 1, a method for calculating the procurement price of engineering service projects, It is characterized in that The steps for constructing a complete reference system for procurement price standards for engineering service projects specifically include: Formulate standardized technical specification templates to solidify the content and format of technical specifications; Establish a standardized project sub-item database to make the sub-item data unified and standardized; Build and regularly update the price calculation model to ensure the accuracy of the reference unit price; Extract and organize the fee standards to form a standardized fee standard form; Establish an update and maintenance mechanism for pricing basis and reference prices to ensure the long-term operation of the system.

Citation Information

Cited By

  • Purchase project price limit automatic compilation method and system

    CN121684811A

  • An automatic method and system for preparing a procurement project price limit

    CN121684811B