CN117078183A - Engineering project settlement system and method - Google Patents
Engineering project settlement system and method Download PDFInfo
- Publication number
- CN117078183A CN117078183A CN202310874162.7A CN202310874162A CN117078183A CN 117078183 A CN117078183 A CN 117078183A CN 202310874162 A CN202310874162 A CN 202310874162A CN 117078183 A CN117078183 A CN 117078183A
- Authority
- CN
- China
- Prior art keywords
- item
- total package
- project
- sub
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000010276 construction Methods 0.000 claims abstract description 171
- 238000005259 measurement Methods 0.000 claims abstract description 92
- 238000004519 manufacturing process Methods 0.000 claims abstract description 38
- 238000004364 calculation method Methods 0.000 claims description 59
- 238000007726 management method Methods 0.000 claims description 35
- 238000004806 packaging method and process Methods 0.000 claims description 35
- 238000010586 diagram Methods 0.000 claims description 20
- 238000010200 validation analysis Methods 0.000 claims description 17
- 238000012795 verification Methods 0.000 claims description 10
- 238000004458 analytical method Methods 0.000 claims description 6
- 238000013507 mapping Methods 0.000 claims description 5
- 238000013524 data verification Methods 0.000 claims description 4
- 238000000547 structure data Methods 0.000 claims description 3
- 230000008569 process Effects 0.000 abstract description 7
- 230000008520 organization Effects 0.000 abstract description 6
- 230000000875 corresponding effect Effects 0.000 description 12
- 230000002596 correlated effect Effects 0.000 description 5
- 239000000463 material Substances 0.000 description 2
- 229910052572 stoneware Inorganic materials 0.000 description 2
- 238000011144 upstream manufacturing Methods 0.000 description 2
- 238000009412 basement excavation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000009435 building construction Methods 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 239000002689 soil Substances 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0635—Risk analysis of enterprise or organisation activities
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/14—Payment architectures specially adapted for billing systems
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Accounting & Taxation (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Tourism & Hospitality (AREA)
- Development Economics (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses an engineering project settlement system and method, which relate to the technical field of constructional engineering, and realize that each list item of target cost measurement is directly related to one or more items of definition of a construction drawing budget by compiling an organization framework of the construction drawing budget of a total package project and an organization framework of the target cost measurement of the total package project; and in the process of inputting the standing item data, the data is checked, and in the management and control of the multi-subcontracting items, whether the settlement of each subcontracting item exceeds an expected management and control target or not can be finely controlled by each subcontracting cost item through a production value right-determining and subcontracting settlement mode, so that the problem of overdriving and overdriving during subcontracting settlement can be effectively solved.
Description
Technical Field
The application relates to the field of constructional engineering, in particular to an engineering project settlement system and method.
Background
In the field of constructional engineering, a total project often has a plurality of sub-packaging projects, which are generally accepted by a total packaging company in a unified way, and then the total packaging company distributes various sub-packaging projects in the total project to different sub-packaging companies for implementation. Therefore, the work content list of each subcontract is not exactly the same, and even when two subcontract companies receive the same kind of work content, the unit price, the engineering amount, and the amount of money may be different in the case where the list item names are the same as the work content. In addition, the construction drawing budgets of upstream projects are compiled from the perspective of project income, and are commonly set by a general package company and a project owner, so that the inventory of the construction drawing budgets of different projects is quite different; the target cost calculation is compiled from the perspective of project cost, is mainly set by a general package company (building company), and is more uniform than the inventory of the target cost calculation in terms of construction drawing budget.
At present, most of general package companies use Excel to settle accounts of projects, but because data of an upstream general project and data of a downstream subcontracting project are not directly related, inventory catalogues of a plurality of subcontracting contracts are inconsistent, project settlement data cannot be effectively managed, and thus, the phenomenon of superjunction and superpayment exists at the end of the projects, and huge losses are brought to construction companies.
In view of this, the present application has been made.
Disclosure of Invention
The application aims to provide an engineering project settlement system and method, which solve the problem that the existing method for settling engineering projects by Excel is easy to cause overdrinking.
The application is realized by the following technical scheme:
in one aspect, the application provides an engineering project settlement system, which comprises a total package standing module, a subcontract module, an output value confirming module and a subcontract settlement module;
the total package item module comprises a total package item input sub-module, a total package item association sub-module and a total package item verification module; the total package item entry submodule is used for entering a total package project construction drawing budget and a total package project target cost measurement and calculation; the budget of the total package project construction drawing and the target cost measurement of the total package project are of a multi-level directory structure; the total package item association sub-module is used for associating each item of the total package item target cost measurement with one or more items of the list of the total package item construction drawing budget to obtain a first association relationship; the general package item checking module is used for checking item data of each item of the general package item target cost measurement and calculation and each item of the general package item construction drawing budget based on the first association relation comparison analysis to obtain a first checking result; the first checking result comprises a normal state, a data error or management risk, and when the first checking result has the data error or the management risk, different prompt messages are generated;
the subcontracting module comprises a subcontracting entry sub-module, a subcontracting association sub-module and a subcontracting verification sub-module; the subcontract input submodule is used for inputting subcontracts, and each total package item comprises a plurality of subcontracts; each subcontracting has a corresponding subcontracting construction diagram budget, and the subcontracting construction diagram budget is a multi-level directory structure; the subcontracting correlation submodule is used for correlating each definition item of the subcontracting construction drawing budget with a list item for total package item target cost measurement and calculation to obtain a second correlation; the subcontracting checking submodule is used for checking standing data of each clearing item of the subcontracting construction drawing budget and each list item for total package target cost measurement based on the second association relation comparison analysis to obtain a second checking result; the second checking result comprises normal states, data errors or management risks, and when the second checking result has the data errors or the management risks, different prompt messages are generated;
the production value confirming module is used for inputting the current-period production value data and the confirming data of each clearing item in the total package project construction drawing budget period by period, automatically acquiring the current-period production value data and the confirming data of each clearing item in the total package project target cost measurement according to the first association relation established by the total package item association sub-module, simultaneously respectively calculating the accumulated production value data and the confirming data of each clearing item from start to current period in the total package project construction drawing budget and the total package target cost measurement, and carrying out data check to obtain a third data check result, wherein the third check result comprises a state normal, a data error or a management risk, and when the third data check result has the data error or the management risk, different prompting information is generated;
the subcontracting settlement module is used for entering the current production value of each clearing item in the subcontracting construction drawing budget under each subcontracting contract period by period, mapping step by step according to the association relation established by the total package item association sub-module and the subcontracting contract association sub-module, automatically acquiring the current production value data and the validation data of the total package item construction drawing calculation clearing item corresponding to each clearing item in the subcontracting construction drawing budget and the current production value data of the total package item target cost calculation clearing item, and the current production value data of the subcontracting construction drawing calculation clearing item of other subcontracting contracts associated to the same total package item target cost calculation clearing item, and carrying out data check to obtain a fourth data check result, wherein the fourth check result comprises a normal state, a data error or a management risk, and generating different prompt messages when the fourth check result has the data error or the management risk.
In one possible implementation manner, the total package item association submodule is further used for generating a list sub-item under the list item which cannot be associated with the total package item construction diagram budget when the list item of the total package item cost budget cannot be associated with the list item of the total package item construction diagram budget, and associating the list item for total package item target cost measurement with the list sub-item of the total package item construction diagram budget; the data estimation mode of the budget list sub-items of the total package project construction drawing is the same as the data estimation mode of the list items for the total package project target cost measurement.
In a possible implementation manner, the subcontracting correlation sub-module is further used for generating a list sub-item under the list item which cannot be correlated with the total package project target cost measurement when the subcontracting construction drawing budget cannot be correlated with the list item of the total package project target cost measurement, and correlating the list item of the subcontracting construction drawing budget with the list sub-item of the total package project target cost measurement; the data estimation mode of the total package project target cost measurement list sub-items is the same as the data estimation mode of the sub-package construction diagram calculation list items.
In one possible implementation manner, the multi-level directory structure data in each module can automatically summarize the data of the lower-level menu item to obtain the data of the upper-level menu item.
In a possible implementation manner, each module is further used for performing data verification on each list item, and when the verification result is that data errors or management risks exist, different prompt messages are generated.
In one possible implementation, each inventory item in the modules includes a corresponding inventory item number, inventory item name, workload, unit price, and price.
On the other hand, the application discloses an engineering project settlement method, which comprises the following steps of:
s1, project establishment is carried out;
s1.1, compiling a total package project construction drawing budget and a total package project target cost measurement and calculation; the budget of the total package project construction drawing and the target cost measurement of the total package project are of a multi-level directory structure;
s1.2, associating each clearing item for total package project target cost measurement with one or more clearing items of total package project construction drawing budget to obtain a first association relation;
s1.3, based on the first association relation established in the S1.2, carrying out data check on each clearing item for total package project target cost measurement and each clearing item for total package project construction drawing budget to obtain a first check result, and generating different prompt messages when the first check result has data errors or management risks;
s2, establishing a subcontracting contract;
s2.1, compiling a sub-packaging construction diagram budget which is a multi-level directory structure;
s2.2, associating each clearing item of the sub-packaging construction drawing budget with one or more list items for total package item target cost measurement and calculation to obtain a second association relation;
s2.3, based on the second association relation established in the S2.2, carrying out data check on each inventory item of the sub-packaging construction drawing budget and each inventory item of the total package target cost calculation to obtain a second check result, and generating different prompt information when the second check result has data errors or management risks;
s3, compiling current production value data and validation data of each list item in the total package project construction drawing budget according to the schedule, automatically acquiring the current production value data and validation data of each associated list item in the total package project target cost calculation according to the first association relation established in S1.2, simultaneously respectively calculating accumulated production value data and validation data of each list item from start-up to current in the total package project construction drawing budget and the total package target cost calculation, carrying out data check based on the data, and generating different prompt information when a check result has data errors or management risks;
s4, compiling current production value data of each definition item in the sub-packaging construction drawing budget according to the schedule, automatically obtaining current production value data and validation data of a total package project construction drawing budget definition item corresponding to each definition item in the sub-packaging construction drawing budget and a total package project target cost measurement list item according to the association relation established by S1.2 and S2.2 by step-by-step mapping, and performing data check based on the current production value data of the sub-packaging construction drawing budget list items of other sub-packaging contracts related to the same total package project target cost measurement definition item, and generating different prompting information when a check result has data errors or management risks.
In one possible embodiment, step S1.2 further comprises: when the list item of the total package project cost budget cannot be associated with the list item of the total package project construction drawing, adding a list sub-item under the list item of the total package project construction drawing budget which cannot be associated, and associating the list item of the total package project target cost measurement with the list sub-item of the total package project construction drawing budget; the data estimation mode of the budget list sub-items of the total package project construction drawing is the same as the data estimation mode of the list items for the total package project target cost measurement.
In one possible embodiment, step S2.2 further comprises: when the sub-packaging construction drawing budget cannot be associated with the list item of the total package item target cost budget, generating a list sub-item under the list item which cannot be associated with the total package item target cost measurement, and associating the list item of the sub-packaging construction drawing budget with the list sub-item of the total package item target cost measurement; the data estimation mode of the total package project target cost measurement list sub-items is the same as the data estimation mode of the sub-package construction diagram calculation list items.
In one possible embodiment, the method further comprises the steps of: compiling a total package project contract and basic information; the project contract and basic information includes contractor information, contract total, contract tax rate, project name, project address, project size, and project period;
the method further comprises the steps of: compiling subcontracting contract information; the subcontract information includes subcontract name, contractor information, work content, contract total, and contract tax rate.
Compared with the prior art, the application has the following advantages and beneficial effects: according to the application, on one hand, through compiling an organization framework of the total package project construction drawing budget and an organization framework of the total package project target cost calculation, each list item of the target cost calculation is directly related to one or more list items of the construction drawing budget, and under the condition that the list items with inconsistent data estimation modes cannot be related, list sub-items are added under the list items of the total package project construction drawing budget, so that the data estimation modes of the list sub-items are the same as the data estimation modes of the list items in the total package project target cost calculation, and the direct association is established; on the other hand, a one-to-one correspondence is established between the sub-package construction drawing budget and the total package project target cost measurement and calculation, so that in multi-sub-package project management and control, whether the settlement of each sub-package project exceeds the expected management and control target or not can be finely controlled by each sub-package cost term, and the problem of overdriving and overdriving during sub-package settlement can be effectively solved.
Drawings
In order to more clearly illustrate the technical solutions of the exemplary embodiments of the present application, the drawings that are needed in the examples will be briefly described below, it being understood that the following drawings only illustrate some examples of the present application and therefore should not be considered as limiting the scope, and that other related drawings may be obtained from these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic structural diagram of an engineering project settlement system according to an embodiment of the present application.
Fig. 2 is a flow chart of a method for settling an engineering project according to an embodiment of the present application.
Detailed Description
For the purpose of making apparent the objects, technical solutions and advantages of the present application, the present application will be further described in detail with reference to the following examples and the accompanying drawings, wherein the exemplary embodiments of the present application and the descriptions thereof are for illustrating the present application only and are not to be construed as limiting the present application.
Example 1
The project settlement system provided by the embodiment is based on the following background:
building construction projects, wherein building contents comprise 3 buildings, garden roads, garden greening, sponge cities and other subjects. In one aspect, a building company enters into a project total package with a project owner and compiles a total package project work sheet budget. The budget of the general package project construction drawing is organized according to income subjects such as No. 1 building, no. 2 building, no. 3 road, park greening, sponge city and the like. Meanwhile, the building company compiles the target cost measurement of the total package project. Objective cost measurement is organized according to cost subjects, including labor sub-divisions (e.g., earthmoving, stoneware, etc.) and specialty sub-divisions (e.g., fire, hydropower, doors and windows, etc.). On the other hand, construction companies sign subcontracts with subcontracts including labor subcontracts and specialty subcontracts. Each subcontracting may be performed by a plurality of subcontracting companies in common with a subcontracting effort, e.g. a labor subcontracting is performed by two labor subcontracting companies in common.
Based on the above project background, the present embodiment provides an engineering project settlement system as shown in fig. 1, which includes the following functional modules:
1. project information input module
The project information input module is used for inputting basic information and contract information of the project. The basic information of the project comprises a project name, a project address, a total building area, a project construction period, a project price and the like.
2. General package standing module
The total package item module comprises a total package item input sub-module, a total package item association sub-module and a total package item verification module.
And 2.1, a total package item entry submodule is used for entering a total package project construction drawing budget and a total package project target cost measurement and calculation. And the total package project construction drawing budget and the total package project target cost measurement are of a multi-level directory structure. For each item in the inventory, there is a unique serial number, 1,1.1,1.1.1,1.5.1, that can represent the cascading relationship, and contains information such as the inventory item code, inventory item name, engineering quantity, unit price, and price.
It should be noted that, the budget of the total package project construction drawing and the target cost of the total package project are all calculated by adopting a multi-level directory structure. For example, the primary catalog of the total package project work map budget contains 6 items of building number 1, building number 2, road number 3, campus road, campus greening, and sponge city, each item of the primary catalog may contain as a secondary catalog a plurality of items of cleaning of earthmoving, stoning, fire, hydropower, doors and windows, and so on. Similarly, the primary catalog for measuring and calculating the target cost of the total package project can comprise 2 items of the labor service sub-package and the professional sub-package, and the labor service can be respectively used as the items of the primary catalog and can also comprise secondary items of the earthwork, the stoneware and the like. The organization architecture of the professional sub-package is similar.
In addition, when the budget of the construction drawing of the total package project and the budget of the target total package project are input, the total item module is also used for inputting the workload, unit price and price of each final-stage item, and automatically calculating the price summary of the upper-stage catalogue according to the workload, unit price and price of the current item.
And 2.2, a total package item association sub-module is used for associating each item of the total package item target cost measurement with one or more list items of the total package item construction drawing budget to obtain a first association relation.
When associated, the following constraint check is performed:
1) If one listing of the total package project work drawing budget is associated with one listing of the total package project goal cost calculation, it cannot be associated with other total package project goal cost calculation listings.
2) If one listing of the total package project work drawing budget is associated with one listing of the total package project target cost calculation, any lower level listing of the total package project work drawing budget cannot be associated with other total package project target cost calculation listings.
3) If one listing of the total package project work drawing budget is associated with one listing of the total package project target cost calculation, any upper level listing of the total package project work drawing budget cannot be associated with other total package project target cost calculation listings.
When each clearing item for total package project target cost measurement is associated with the total package project construction drawing budget, the precise matching association can be carried out by using the sequence number of the clearing item, the encoding of the clearing item and the name of the clearing item, and fuzzy matching can also be carried out by using the name of the clearing item.
After the total package project construction drawing budget and the total package project target cost are input and calculated, the total package item association submodule correspondingly associates each clearing item of the total package project target cost calculation with one or more clearing items of the total package project construction drawing budget. For example, for the earthwork clearing items in the total package project objective cost calculation, the workload thereof comprises the earthwork workload of building No. 1, building No. 2 and building No. 3 in the total package project construction drawing budget, i.e. the workload of the earthwork clearing items in the total package project objective cost calculation is the sum of the workload of the 3 earthwork clearing items.
It should be noted that, in the association process, due to different estimation manners of data, the list items for calculating the target cost of the total package project may not be associated with the list items of the budget of the construction drawing of the total package project. For example, for a scaffold list item under a proprietary sub-package in total package project objective cost measurement, the workload and unit price are estimated according to building elevation, while for a scaffold list item in total package project construction drawing budget, the workload and unit price are estimated according to building area, and the workload and unit price are estimated differently, so that the workload and unit price cannot be correlated. In this regard, the total package item association submodule provided in this embodiment may perform a transformation process on data of a menu item of a total package project construction drawing budget, for example, correspondingly add a list sub-item under a scaffold list item of an original total package project construction drawing budget, and adopt an estimation mode of workload and unit price of the scaffold menu item in a total package project target cost measurement and calculation for the estimation mode of workload and unit price of the list sub-item, and ensure that the closing price is not greater than the closing price of a superordinate menu item. And after adding the list sub-items, directly associating the scaffold list items for total package project target cost measurement with the list sub-items corresponding to the scaffold of the total package project construction map budget.
The total package item association sub-module is further used for generating a list sub-item under the list item which cannot be associated with the total package item construction drawing budget when the list item of the total package item cost budget cannot be associated with the list item of the total package item construction drawing budget, and associating the list item calculated by the total package item target cost with the list sub-item of the total package item construction drawing budget. The data estimation mode of the list sub-items is the same as the data estimation mode of the list items for total package item target cost measurement.
And 2.3, a total package item checking module is used for checking item data of each item of the list item of the total package item construction drawing budget and each item of the list item of the total package item target cost calculation based on the first association relation comparison analysis, so as to obtain a first checking result. The first checking result comprises a normal state, a data error or management risk, and when the first checking result has the data error or the management risk, different prompt messages are generated.
Checking the overall package item stand: for each of the inventory item budgets of the total package project construction drawing and the objective cost measurement, the following comparison check is performed:
1) Total package project objective cost measures the sum of inventory project engineering quantity < all associated total package project construction map budget associated inventory item engineering quantity.
2) Total package item objective cost calculation clearing item sum of the value of all associated total package item construction drawing budget association clearing items.
3. Subcontracting module
The subcontract module comprises a subcontract entry sub-module, a subcontract association sub-module and a subcontract verification sub-module.
And 3.1, a subcontract input submodule is used for inputting subcontracts, and each total package item comprises a plurality of subcontracts. Each subcontracting has a corresponding subcontracting construction map budget, and the subcontracting construction map budget is a multi-level directory structure. The total package project goal cost measure may be apportioned by multiple subcontracting map budgets. The subcontracting construction drawing budget comprises a plurality of menu items, which are shown as a multi-level directory structure, and for each item in the list directory, a unique serial number capable of representing cascade relations, such as 1,1.1,1.1.1,1.5.1, and information such as menu item codes, list item names, engineering quantities, unit price, price and the like.
When the organization structure of the sub-packaging construction drawing budget is recorded, the workload, unit price and price of each clearing item are recorded simultaneously. It should be noted that the subcontract entry submodule performs data verification in the process of entering the workload, unit price and price of each clearing item. For example, the labor service subcontracting is completed by the subcontracting company a and the subcontracting company b respectively, and when the subcontracting construction drawing budget of the subcontracting company a is recorded, the subcontracting contract recording submodule checks whether the workload, unit price and closing price of each definition item exceed the workload, unit price and closing price of the corresponding definition item in the total package item target cost measurement. If the data is not passed, the subcontract entry submodule judges that the verification is not passed and gives out lifting information (such as highlighting), and meanwhile, limiting submission processing is carried out on the data which is not passed. Similarly, when the budget of the subcontracting construction drawing of the subcontracting company B is input, the subcontracting recording submodule checks according to the same data checking mode, but the workload and the price of the subcontracting company A are required to be deducted, so that the workload and the price of the two labor subcontracting are not more than the target cost measurement of the total package item.
And 3.2, a subcontract association submodule is used for associating each definition item of the subcontract construction drawing budget with a list item for total package item target cost measurement and calculation to obtain a second association relation.
The subcontracting correlation sub-module is also used for generating a list sub-item under the list item which cannot be correlated with the total package project target cost measurement when the subcontracting construction drawing budget cannot be correlated with the list item of the total package project target cost measurement, and correlating the list item of the subcontracting construction drawing budget with the list sub-item of the total package project target cost measurement. The data estimation mode of the total package project target cost measurement list sub-items is the same as the data estimation mode of the sub-package construction diagram calculation list items.
When associated, the following constraint check is performed:
1) If an inventory item of the total package item objective cost estimate is associated with an inventory item of the subcontracting construction drawing budget, it cannot be associated with other construction drawing budget inventory items of the subcontracting.
2) If a listing of the total package item objective cost estimate is associated with a listing of the subcontracting construction drawing budget, any subordinate listing of the total package item objective cost estimate cannot be associated with other construction drawing budget listings of the subcontracting.
3) If a listing of the total package project objective cost estimate is associated with a listing of the subcontracting construction drawing budget, any superordinate item of the total package project objective cost estimate cannot be associated with other construction drawing budget listings of the subcontracting.
When the sub-packaging construction drawing budget is associated with the total package project target cost measurement, the precise matching association can be carried out by using a serial number, a project code and a project name, and fuzzy matching can also be carried out by using the project name.
And 3.3, the subcontract checking sub-module is used for checking the standing data of each clearing item of the subcontract construction drawing budget and each list item for total package target cost measurement based on the second association relation comparison analysis, so as to obtain a second checking result. The second checking result comprises normal state, data error or management risk, and when the second checking result has the data error or the management risk, different prompt information is generated.
And (5) checking subpackage standing: for each inventory item of the subcontracting construction drawing budget, the following comparison check is performed:
1) The subcontracting construction diagram budget engineering quantity < (total package project target cost measures the engineering quantity of the associated definition item-the sum of engineering quantities associated with the same target cost measure definition item in other subcontracting construction diagram budgets).
2) The subcontracting construction drawing budget closing price < (total package project target cost measurement associated definition item-sum of closing prices associated to the same target cost measurement definition item in other subcontracting construction drawing budgets).
4. Yield value confirming module
The production value confirming module is used for inputting the current-period production value data and the confirming data of each clearing item in the total package project construction drawing budget period by period, automatically acquiring the current-period production value data and the confirming data of each clearing item in the total package project target cost measurement according to the first association relation established by the total package item association sub-module, simultaneously respectively calculating the accumulated production value data and the confirming data of each clearing item from start to current period in the total package project construction drawing budget and the total package target cost measurement, and carrying out data check to obtain a third data check result, wherein the third check result comprises a state normal, a data error or a management risk, and when the third data check result has the data error or the management risk, different prompt messages are generated.
Wherein, when the expected production value is the workload, unit price and price of each clearing item which is confirmed by the construction company, the validation data is the workload, unit price and price of each clearing item which is confirmed by the owner. And the yield value right confirming module is used for giving early warning or prompting according to the difference value of the current yield value and the right confirming data by comparing the current yield value with the right confirming data.
In the process of the yield value right determination, the yield value right determination module automatically calculates the workload and the price of each clearing item in the total package project target cost measurement according to the association relation established by the total package item association sub-module. For example, the earthwork clearing item under the labor sub-package in the total package project target cost calculation is 100m completed in building 1 of this month 3 Building No. 2 completes 50m 3 Building 3 completes 150m 3 Soil excavation in the whole total package project target cost measurement and calculationThe square workload is 300m 3 . The production value confirming module automatically calculates the accumulated workload and the price from the start to the current period according to the current period production value and the confirming data. And meanwhile, the data such as the uncollected amount and the like are obtained according to the collected money.
5. Subcontracting settlement module
The subcontracting settlement module is used for entering the current production value of each clearing item in the subcontracting construction drawing budget under each subcontracting contract period by period, mapping step by step according to the association relation established by the total package item association sub-module and the subcontracting contract association sub-module, automatically acquiring the current production value data and the validation data of the total package item construction drawing calculation clearing item corresponding to each clearing item in the subcontracting construction drawing budget and the current production value data of the total package item target cost calculation clearing item, and the current production value data of the subcontracting construction drawing calculation clearing item of other subcontracting contracts associated to the same total package item target cost calculation clearing item, and carrying out data check to obtain a fourth data check result, wherein the fourth check result comprises a normal state, a data error or a management risk, and generating different prompt messages when the fourth check result has the data error or the management risk.
For each item of the clearing, a plurality of comparison checks are performed:
1) The subcontracting construction drawing budget current period yield value < (the current period validation of the total package project target cost measurement associated definition item-the sum of current period yield values associated to the same target cost measurement definition item in other subcontracting construction drawing budgets).
2) The subcontracting construction drawing budget current period accumulated output value < (the current period accumulated right of the total package project target cost measuring and calculating associated definition item-the sum of current period accumulated output values associated with the same target cost measuring and calculating definition item in other subcontracting construction drawing budgets).
The subcontracting settlement module compares and analyzes the workload and the price of each list item in the total package project target cost calculation with the workload and the price of each list item in the subcontracting construction drawing budget according to the one-to-one correspondence between the subcontracting construction drawing budget and the total package project target cost calculation, and ensures that the workload and the price of each list item in the project construction drawing budget are not greater than the workload and the price of each list item in the total package project target cost calculation under the correspondence.
If multiple subcontracts together complete each type of subcontract, then for each cost subject it is necessary to ensure that the aggregate of all subcontracts on the subject's current project amount and the bid is no greater than the current target cost-measuring subject's project amount and bid.
In addition, in the sub-packet settlement process, various deductions of each sub-packet, such as material deduction, safety deduction, progress deduction, quality deduction and the like, can be recorded. And deducting the amount of deducted money of the sub-package according to the value of the current sub-package settlement metering and price to obtain the current settlement bill. The bill content comprises the entity non-tax-containing value, the value-added tax rate, the entity tax-containing value, various deductions and the current settlement amount. And according to the data of accumulated accounts payable, paid and unpaid from the current period to the current period.
Based on the project settlement system provided in this embodiment, it is to be further explained that:
1. the system is operated in a single machine environment, and information such as project contracts, construction drawing budgets, target cost measurement and calculation, subcontracting contracts, subcontracting construction drawing budgets, subcontracting settlement and the like is stored in a database.
2. The system is operated in a cloud environment, information such as project contracts, construction drawing budgets, target cost measurement and calculation, subcontracting contracts, subcontracting construction drawing budgets, subcontracting settlement and the like is stored in a cloud database, and information reporting, auditing and the like are executed at a client (comprising a browser client and an App client).
3. When the project stands, corresponding contents can be recorded by different roles, such as basic information is recorded by a project business manager, project deduction information is respectively recorded by an engineering part, a material part, a security monitoring part and a comprehensive part, and the recorded contents are approved by different posts. After approval, the statement is validated for the financial department to enter into the subcontracting payment process. The settlement approval can be set to be multi-level or multi-person approval, and the settlement bill is formally validated after all people complete the approval.
The multi-level catalog structure data in each module can automatically summarize the data of the lower-level menu item to obtain the data of the upper-level menu item. Each module is also used for carrying out data verification on each list item, and when the verification result is that data errors exist or management risks exist, different prompt messages are generated. Each inventory item in each module includes a corresponding workload, unit price, and price.
Example 2
Corresponding to embodiment 1, the present embodiment provides an engineering project settlement method, whose execution flow is shown in fig. 2, comprising the following steps:
s1, project standing is conducted.
S1.1, compiling a total package project construction drawing budget and calculating a total package project target cost. And the total package project construction drawing budget and the total package project target cost measurement are of a multi-level directory structure.
S1.2, associating each clearing item for total package project target cost measurement with one or more clearing items of total package project construction drawing budget to obtain a first association relation.
S1.3, based on the first association relation established in the S1.2, carrying out data check on each clearing item for total package project target cost measurement and each clearing item for total package project construction drawing budget to obtain a first check result, and generating different prompt messages when the first check result has data errors or management risks.
S2, establishing subcontract.
S2.1, compiling a sub-packaging construction diagram budget, wherein the sub-packaging construction diagram budget is of a multi-level directory structure.
S2.2, associating each list item of the sub-packaging construction drawing budget with one or more list items for total package item target cost measurement and calculation to obtain a second association relation.
S2.3, based on the second association relation established in the S2.2, carrying out data check on each inventory item of the sub-packaging construction drawing budget and each inventory item of the total package target cost calculation to obtain a second check result, and generating different prompt messages when the second check result has data errors or management risks.
S3, compiling current production value data and validation data of each list item in the total package project construction drawing budget according to the schedule, automatically acquiring the current production value data and validation data of each associated list item in the total package project target cost calculation according to the first association relation established in S1.2, simultaneously respectively calculating accumulated production value data and validation data of each list item from start-up to current in the total package project construction drawing budget and the total package target cost calculation, carrying out data check based on the data, and generating different prompt information when a check result has data errors or management risks.
S4, compiling current production value data of each definition item in the sub-packaging construction drawing budget according to the schedule, automatically obtaining current production value data and validation data of a total package project construction drawing budget definition item corresponding to each definition item in the sub-packaging construction drawing budget and a total package project target cost measurement list item according to the association relation established by S1.2 and S2.2 by step-by-step mapping, and performing data check based on the current production value data of the sub-packaging construction drawing budget list items of other sub-packaging contracts related to the same total package project target cost measurement definition item, and generating different prompting information when a check result has data errors or management risks.
Optionally, step S1.2 further includes: when the list item of the total package project cost budget cannot be associated with the list item of the total package project construction drawing, adding a list sub-item under the list item of the total package project construction drawing budget which cannot be associated, and associating the list item of the total package project target cost measurement with the list sub-item of the total package project construction drawing budget. The data estimation mode of the budget list sub-items of the total package project construction drawing is the same as the data estimation mode of the list items for the total package project target cost measurement.
Optionally, step S2.2 further includes: when the sub-packaging construction drawing budget cannot be associated with the list item of the total package item target cost budget, generating a list sub-item under the list item which cannot be associated with the total package item target cost measurement, and associating the list item of the sub-packaging construction drawing budget with the list sub-item of the total package item target cost measurement. The data estimation mode of the total package project target cost measurement list sub-items is the same as the data estimation mode of the sub-package construction diagram calculation list items.
Optionally, the method further comprises the following steps: and compiling the contract and basic information of the total package project. The project contract and base information includes contractor information, contract total, contract tax rate, project name, project address, project size, and project period. The method also comprises the following steps: subcontracting contract information is compiled. The subcontract information includes subcontract name, contractor information, work content, contract total, and contract tax rate.
The foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the application, and is not meant to limit the scope of the application, but to limit the application to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the application are intended to be included within the scope of the application.
Claims (10)
1. The project settlement system is characterized by comprising a total package standing module, a subcontracting module, an output value confirming module and a subcontracting settlement module;
the total package item module comprises a total package item input sub-module, a total package item association sub-module and a total package item verification module; the total package item entry submodule is used for entering a total package project construction drawing budget and a total package project target cost measurement and calculation; the budget of the total package project construction drawing and the target cost measurement of the total package project are of a multi-level directory structure; the total package item association sub-module is used for associating each item of the total package item target cost measurement with one or more items of the list of the total package item construction drawing budget to obtain a first association relationship; the general package item checking module is used for checking item data of each item of the general package item target cost measurement and calculation and each item of the general package item construction drawing budget based on the first association relation comparison analysis to obtain a first checking result; the first checking result comprises a normal state, a data error or management risk, and when the first checking result has the data error or the management risk, different prompt messages are generated;
the subcontracting module comprises a subcontracting entry sub-module, a subcontracting association sub-module and a subcontracting verification sub-module; the subcontract input submodule is used for inputting subcontracts, and each total package item comprises a plurality of subcontracts; each subcontracting has a corresponding subcontracting construction diagram budget, and the subcontracting construction diagram budget is a multi-level directory structure; the subcontracting correlation submodule is used for correlating each definition item of the subcontracting construction drawing budget with a list item for total package item target cost measurement and calculation to obtain a second correlation; the subcontracting checking submodule is used for checking standing data of each clearing item of the subcontracting construction drawing budget and each list item for total package target cost measurement based on the second association relation comparison analysis to obtain a second checking result; the second checking result comprises normal state, data error or management risk, and when the second checking result has the data error or the management risk, different prompt information is generated.
2. The project settlement system of claim 1, wherein the total package item association sub-module is further configured to, when the inventory item of the total package item cost budget cannot be associated with the inventory item of the total package item construction map, generate an inventory sub-item under the inventory item of the total package item construction map budget that cannot be associated, and associate the inventory item of the total package item objective cost calculation with the inventory sub-item of the total package item construction map budget; the data estimation mode of the list sub-items is the same as the data estimation mode of the list items for total package item target cost measurement.
3. The project settlement system of claim 1, wherein the subcontract association sub-module is further configured to, when the subcontract construction drawing budget cannot be associated with the inventory item of the total package project target cost budget, generate an inventory sub-item under the inventory item of the total package project target cost estimate that cannot be associated, and associate the inventory item of the subcontract construction drawing budget with the inventory sub-item of the total package project target cost estimate; the data estimation mode of the total package project target cost measurement list sub-items is the same as the data estimation mode of the sub-package construction diagram calculation list items.
4. The project settlement system of claim 1, wherein the multi-level directory structure data in each module can automatically collect the data of the lower level menu item to obtain the data of the upper level menu item.
5. The project settlement system of claim 1, wherein each module is further configured to perform data verification on each inventory item, and generate different prompt messages when the verification result indicates that there is a data error or management risk.
6. The project settlement system of claim 1, wherein each of the inventory items in the modules includes a corresponding inventory item number, inventory item name, workload, unit price, and price.
7. The engineering project settlement method is characterized by comprising the following steps of:
s1, project establishment is carried out;
s1.1, compiling a total package project construction drawing budget and a total package project target cost measurement and calculation; the budget of the total package project construction drawing and the target cost measurement of the total package project are of a multi-level directory structure;
s1.2, associating each clearing item for total package project target cost measurement with one or more clearing items of total package project construction drawing budget to obtain a first association relation;
s1.3, based on the first association relation established in the S1.2, carrying out data check on each clearing item for total package project target cost measurement and each clearing item for total package project construction drawing budget to obtain a first check result, and generating different prompt messages when the first check result has data errors or management risks;
s2, establishing a subcontracting contract;
s2.1, compiling a sub-packaging construction diagram budget which is a multi-level directory structure;
s2.2, associating each clearing item of the sub-packaging construction drawing budget with one or more list items for total package item target cost measurement and calculation to obtain a second association relation;
s2.3, based on the second association relation established in the S2.2, carrying out data check on each inventory item of the sub-packaging construction drawing budget and each inventory item of the total package target cost calculation to obtain a second check result, and generating different prompt information when the second check result has data errors or management risks;
s3, compiling current production value data and validation data of each list item in the total package project construction drawing budget according to the schedule, automatically acquiring the current production value data and validation data of each associated list item in the total package project target cost measurement according to the first association relation established in S1.2, simultaneously respectively calculating the accumulated production value data and validation data of each list item from start-up to current in the total package project construction drawing budget and the total package target cost measurement, and performing data check based on the data;
s4, compiling current production value data of each definition item in the sub-packaging construction drawing budget according to the schedule, automatically obtaining current production value data and validation data of a total package project construction drawing budget definition item and a total package project target cost measurement list item corresponding to each definition item in the sub-packaging construction drawing budget according to the association relation established by S1.2 and S2.2 by step-by-step mapping, and performing data check based on the current production value data and validation data of the sub-packaging construction drawing budget list item of other sub-packaging contracts related to the same total package project target cost measurement definition item.
8. The engineering project settlement method as claimed in claim 7, wherein the step S1.2 further comprises: when the list item of the total package project cost budget cannot be associated with the list item of the total package project construction drawing, adding a list sub-item under the list item of the total package project construction drawing budget which cannot be associated, and associating the list item of the total package project target cost measurement with the list sub-item of the total package project construction drawing budget; the data estimation mode of the budget list sub-items of the total package project construction drawing is the same as the data estimation mode of the list items for the total package project target cost measurement.
9. The engineering project settlement method as claimed in claim 7, wherein the step S2.2 further comprises: when the sub-packaging construction drawing budget cannot be associated with the list item of the total package item target cost budget, generating a list sub-item under the list item which cannot be associated with the total package item target cost measurement, and associating the list item of the sub-packaging construction drawing budget with the list sub-item of the total package item target cost measurement; the data estimation mode of the total package project target cost measurement list sub-items is the same as the data estimation mode of the sub-package construction diagram calculation list items.
10. The engineering project settlement method as set forth in claim 7, further comprising the steps of: compiling a total package project contract and basic information; the project contract and basic information includes contractor information, contract total, contract tax rate, project name, project address, project size, and project period;
the method also comprises the following steps: compiling subcontracting contract information; the subcontract information includes subcontract name, contractor information, work content, contract total, and contract tax rate.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310874162.7A CN117078183A (en) | 2023-07-17 | 2023-07-17 | Engineering project settlement system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310874162.7A CN117078183A (en) | 2023-07-17 | 2023-07-17 | Engineering project settlement system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117078183A true CN117078183A (en) | 2023-11-17 |
Family
ID=88710497
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310874162.7A Pending CN117078183A (en) | 2023-07-17 | 2023-07-17 | Engineering project settlement system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117078183A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117592762A (en) * | 2024-01-18 | 2024-02-23 | 中铁城建集团有限公司 | Cost analysis method and system based on project engineering dynamic data |
-
2023
- 2023-07-17 CN CN202310874162.7A patent/CN117078183A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117592762A (en) * | 2024-01-18 | 2024-02-23 | 中铁城建集团有限公司 | Cost analysis method and system based on project engineering dynamic data |
| CN117592762B (en) * | 2024-01-18 | 2024-04-05 | 中铁城建集团有限公司 | Cost analysis method and system based on project engineering dynamic data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Thomas et al. | Quantitative effects of construction changes on labor productivity | |
| Bhargava et al. | Three-stage least-squares analysis of time and cost overruns in construction contracts | |
| Serag et al. | Model for quantifying the impact of change orders on project cost for US roadwork construction | |
| CN102976176B (en) | Elevator installation and maintenance management system | |
| US20060129482A1 (en) | Methods and systems for managing real estate property | |
| CN109784689B (en) | Power grid infrastructure project report data processing method | |
| US10650359B2 (en) | Energy distribution and marketing backoffice system and method | |
| CN117078183A (en) | Engineering project settlement system and method | |
| CN113656505B (en) | Digitization of distributed project management system and method for synchronizing data thereof | |
| CN107909280A (en) | A kind of electricity power engineering managing and control system and its control method based on bill of quantities | |
| CN113868753B (en) | Intelligent metering method and device for building engineering, computing equipment and storage medium | |
| Lee et al. | Stochastic project financing analysis system for construction | |
| CN103020873A (en) | Automatic transferring method and system for electric system | |
| CN111681054A (en) | Intelligent pricing method for project cost list | |
| KR100712050B1 (en) | Management method for risk in construction using analysis of cash flow and apparatus threrof, and management method for risk in construction using analysis of portfolio and apparatus threrof using that | |
| CN108875981A (en) | A kind of information system and its application method that building maintenance fund is collected and used | |
| CN111210325B (en) | Rural collective three-data on-line supervision system | |
| Borges Jr et al. | Five project-duration control methods in time units: Case study of a linearly distributed planned value | |
| CN114529197A (en) | Data management method, system, terminal and storage medium for engineering cost | |
| JP2003186950A (en) | Construction work management device and method | |
| JP2002108988A (en) | Photovoltaic power generation system | |
| CN111091455B (en) | Integrated tax source management system for house, land and tax collection | |
| CN109345363A (en) | A kind of land value-added tax settlement auditing system and method | |
| CN114693424A (en) | Building industry asset big data collection and application | |
| CN113743911A (en) | Project total contract project cost management method based on information system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |