Consultant_Firm_Staff-hour_Estimate.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- Comprehensive Aviation Planning Services State and local contract opportunity
- Solicitation number
- 25-042-RFP
- Issued by
- Kenton County, Kentucky
About this file
The document is a Consultant Firm Staff-hour Estimate spreadsheet for a specific project (PSA 1138, Task Order 32) related to East Climate Control DA and Feedwater Pump Replacement, prepared on January 3, 2018. The spreadsheet details labor allocation across various project phases including site investigation, system design/phasing, pump sizing/selection, technical specifications, construction administration, and document preparation. The estimated total labor hours are 124, with significant time dedicated to system design (24 hours) and involving multiple professional roles such as Project Manager, Senior Mechanical Engineer, Assistant Mechanical Engineer, and other specialized technical staff.
While the spreadsheet provides a detailed labor hour breakdown, it does not include specific pricing information or total project costs. The document appears to be an internal planning tool for resource allocation and project scoping, demonstrating the consulting firm's approach to managing a technical infrastructure replacement project. The staff-hour estimate suggests a comprehensive, multi-phase approach to the pump replacement project, with careful allocation of technical expertise across different project stages.
View the file
Other files for this state and local contract opportunity
Show all 19
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Blank Staff-hour estimate Table
| Firm Staff-hour Estimate |
| [Project] |
| [Task Order] |
| [Date] |
| [Company] Labor Estimate | Project Manager | Senior Mechanical Engineer | Assistant Mechanical Engineer | Assistant Project Manager | Senior Structural Engineer | Quality Control | Cost Estimator | Total | ||||||||||
| 0 | ||||||||||||||||||
| Scope 1 | 0 | |||||||||||||||||
| Scope 2 | 0 | |||||||||||||||||
| Scope 3 | 0 | |||||||||||||||||
| Scope 4 | 0 | |||||||||||||||||
| Scope 5 | 0 | |||||||||||||||||
| Scope 6 | 0 | |||||||||||||||||
| Scope 7 | 0 | |||||||||||||||||
| Scope 8 | 0 | |||||||||||||||||
| Scope 9 | 0 | |||||||||||||||||
| Scope 10 | 0 | |||||||||||||||||
| Scope 11 | 0 | |||||||||||||||||
| Scope 12 | 0 | |||||||||||||||||
| Scope 13 | 0 | |||||||||||||||||
| Scope 14 | 0 | |||||||||||||||||
| Scope 15 | 0 | |||||||||||||||||
| Scope 16 | 0 | |||||||||||||||||
| Scope 17 | 0 | |||||||||||||||||
| Scope 18 | 0 | |||||||||||||||||
| Scope 19 | 0 | |||||||||||||||||
| Scope 20 | 0 | |||||||||||||||||
| Scope 21 | 0 | |||||||||||||||||
| Scope 22 | 0 | |||||||||||||||||
| Scope 23 | 0 | |||||||||||||||||
| Scope 24 | 0 | |||||||||||||||||
| Scope 25 | 0 | |||||||||||||||||
| Scope 26 | 0 | |||||||||||||||||
| Scope 27 | 0 | |||||||||||||||||
| Scope 28 | 0 | |||||||||||||||||
| Scope 29 | 0 | |||||||||||||||||
| Scope 30 | 0 | |||||||||||||||||
| Scope 31 | 0 | |||||||||||||||||
| Scope 32 | 0 | |||||||||||||||||
| Scope 33 | 0 | |||||||||||||||||
| Scope 34 | 0 | |||||||||||||||||
| Scope 35 | 0 | |||||||||||||||||
| Total Labor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Example Sheet
| Firm Staff-hour Estimate |
| PSA 1138 |
| Task Order 32- East Climate Control DA and FW Pump Replacement |
| January 3, 2018 |
| Company Labor Estimate | Project Manager | Senior Mechanical Engineer | Assistant Mechanical Engineer | Assistant Project Manager | Senior Structural Engineer | Quality Control | Cost Estimator | Total | ||||||||||
| 0 | ||||||||||||||||||
| Site Investigation | 4 | 4 | 8 | |||||||||||||||
| System Design/Phasing | 8 | 16 | 24 | |||||||||||||||
| New DA & Pump Sizing / Selection | 8 | 8 | ||||||||||||||||
| Technical Specifications for Pumps / DA / Concrete | 8 | 4 | 2 | 14 | ||||||||||||||
| Condensate and Feedwater P&ID development | 8 | 8 | ||||||||||||||||
| Construction Administration | 4 | 16 | 20 | |||||||||||||||
| Issued for Construction Documents - DA & Pump Schedule, Flow Diagrams, and Specifications | 4 | 4 | ||||||||||||||||
| Cost Estimating | 2 | 4 | 6 | |||||||||||||||
| Quality Check & Comment Pick-up | 2 | 4 | 8 | 14 | ||||||||||||||
| 0 | ||||||||||||||||||
| Prebid & Precon Meetings | 6 | 6 | ||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| Overall PSA and subconsultant management | 6 | 6 | 12 | |||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| Total Labor | 6 | 52 | 46 | 6 | 2 | 8 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 124 |
File details come from the government source that posted it. Updated .