ProjectONE Report to the 82nd Legislature
Appendix D: Sample Reports
Project Engineering Cost Report
Today TxDOT systems do not collect information at the level of detail needed to address several procurement-related recommendations in the Grant Thornton report and to comply with the legislative mandate to contract out 35 percent of the agency’s annual engineering services. This sample CAPPS report would provide apples-to-apples costs for both in-house and contracted/consultant engineering services throughout the life cycle of each project.
| <Project by District> | In house engineering | Consultant Engineering | |||||||
|---|---|---|---|---|---|---|---|---|---|
| Labor Cost | Indirect Expenses | Labor Hours | Average Cost Per Hour | Labor Cost | Hours | Indirect Expenses | Average Cost Per Hour | Estimated Project Cost | |
| PE | |||||||||
| CE | |||||||||
| Construction | |||||||||
| Totals | |||||||||
| <Statewide> | In house engineering | Consultant Engineering | |||||||
|---|---|---|---|---|---|---|---|---|---|
| Labor Cost | Indirect Expenses | Labor Hours | Average Cost Per Hour | Labor Cost | Hours | Indirect Expenses | Average Cost Per Hour | Estimated Project Cost | |
| PE | |||||||||
| CE | |||||||||
| Construction | |||||||||
| Totals | |||||||||
Project Cost Summary Report
This sample CAPPS report shows overall project costs by project phase and in total. It will track original estimates for expenses against actual expenses thereby enabling decision-makers to track progress against targets throughout the implementation process and allow for more timely course corrections and go/no-go decisions as recommended by the Grant Thornton report.
| Project | CSJ | Original Award Amount | Current Estimates | # of Change Orders | $ Value of Charge Orders | Current Construction Expenses | CFDA | Total ROW Costs | Total PE Costs | Total CE Costs | Total Construction Costs | Total Costs |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... |
| ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... |
| ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... |
| ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... | ..... |
Project Cost Detail Report
This report drills down into the information provided in the Project Cost Summary Report and would provide a more detailed and activity-based accounting of construction expenses from the right-of-way acquisition phase through the final construction phase. It would bring visibility to costs across the organization and provide information for agency management to use in making project-related decisions, thereby addressing another Grant Thornton recommendation.
Project Number Original Award Amount Current Estimate
| Phase | Function Codes | Row Costs | PE Costs | CE Costs | Construction Costs | Total Costs |
|---|---|---|---|---|---|---|
| ..... | 170-Bridge Design | ..... | ..... | ..... | ..... | ..... |
| ..... | 191-Toll Feasibility Studies | ..... | ..... | ..... | ..... | ..... |
| ..... | 320-Inspection of Work in Progress | ..... | ..... | ..... | ..... | ..... |
| ..... | 910-Sign Removal Operation Expense | ..... | ..... | ..... | ..... | ..... |