Currently, the competition in the project construction market is fierce. when bidding, construction enterprises must use the general budget software (such as the same hope software) to prepare the bidding quotation, and also compile the project's target cost based on the accumulated project cost data, the bottom line of the bidding quotation. The highway project budget quota has not been revised for many years, and many new technical processes have not introduced details, although there are additional quotas in various regions.
The establishment of a complete internal quota of the enterprise and the absence of auxiliary tools make it a very time-consuming task to compile the project cost.
Many construction enterprises and the Project Department authorize the project manager to operate the project by signing a contract. The Project Department also needs to determine the target cost (or post-bidding budget) recompile the project cost according to the actual construction scheme of the project, and test the estimated cost of the project from three perspectives (WBS, OBS, and CBS.
It is divided by WBS (work breakdown structure) to facilitate use with Schedule (P3, or project) and generate resource plans;
The cost objectives are divided into departments/teams by OBS (organizational structure decomposition) to implement cost management responsibilities;
The cost is divided into labor, materials, institutions, assistance, and management according to the cost breakdown structure of CBS, which facilitates comparison with budget and accounting cost accounting interfaces.
For more information, see the relevant appendix.
Project cost data warehouse design .rar
The content only involves the project cost plan. The accounting part is not included, but the interface is considered.
The MS project, P3 data organization method, also referred to the hope of the budget software, as well as their own development of the "Project Settlement System" and other software.
The next step is to design the database structure, plan to use SQL 2005 express as the local database, and use VB express for self-development.
Use professional controls to accelerate the development process,Key PointsUse: (The following controls are for personal trial only !)
1)Ilog GanttControl to display the WBS, tasks, and progress of the project. CurrentlyXpressquantumgridReplace;
Nicklee's middleware's "Gantt control" can also be used, but it is relatively simple and free. We are currently considering using it.
2)XpressquantumtreelistControl to represent the tree structure;
3)XpressquantumgridControl to represent the Grid Structure and display list;
XpressquantumprintingsystemAndReportPrint reports;
4)Farpoint. SpreadCome andExcelExchange data.