Attachment J-8 2024 PMO Firm Fixed Price Form - Final.xlsx
XLSX spreadsheet 63 KB Posted
- Solicitation number
- FTA_2024_PMO_0005
About this file
This document contains a labor rate template for a firm fixed price contract and information about an associated request for proposal from the Federal Transit Administration.
The labor rate template provides fully loaded hourly rates for 33 labor categories for each of the five years of the potential contract. Key personnel are identified along with their annual hours. No rates are populated however, as the template appears to be for contractors to populate with their own proposed rates. The associated RFP is for project management oversight services and indicates it is solicitation number FTA_2024_PMO_0005 from the Department of Transportation Federal Transit Administration, but no other details on required services, response date, or award information is provided.
View the file
Other files
Show all 28
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
1 - FFP Labor Rate - Revised
Attachment J-8: 2024 Maximum Labor Rate Calculation for Firm Fixed Price Task Orders
| Labor Category | Direct Labor Rate | Fringe Benefit Rates | Fringe Benefits | Overhead Rates | Overhead | G&A Rates | G&A | Profit Rates | Profit | Year I Fully Loaded Hourly Labor Rate | Year II*** Fully Loaded Hourly Labor Rate | Year III*** Fully Loaded Hourly Labor Rate | Year IV*** Fully Loaded Hourly Labor Rate | Year V*** Fully Loaded Hourly Labor Rate | Year I Hours | ||
| J | Year II Hours | ||||||||||||||||
| K | Year III Hours | ||||||||||||||||
| L | Year IV Hours | ||||||||||||||||
| M | Year V Hours | ||||||||||||||||
| N | 5-Year Sum of |
Total Hours (J thru N) O Year I Direct Cost (D*J) Q Year II Direct Cost (E*K) R Year III Direct Cost (F*L) S Year IV Direct Cost (G*M) T Year V Direct Cost (H*N) U 5-Year Sum of Total Direct Cost (P thru T) V
| L | |||||||||||||||||||||||||||
| 1 | Program Manager* | $ 50.00 | 15% | $ 7.50 | 95.00% | $ 54.63 | 5% | $ 5.61 | 9% | $ 10.60 | $ 128.33 | $ 132.18 | $ 136.14 | $ 140.23 | $ 144.43 | 2000 | 2000 | 2000 | 2000 | 2000 | 10000 | $256,654.13 | $264,353.75 | $272,284.36 | $280,452.89 | $288,866.48 | $ 1,362,612 |
| 2 | Task Order Manager I* | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2000 | 2000 | 2000 | 2000 | 2000 | 10000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 3 | Task Order Manager I* | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2000 | 2000 | 2000 | 2000 | 2000 | 10000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 4 | Task Order Manager II* | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2000 | 2000 | 2000 | 2000 | 2000 | 10000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 5 | Task Order Manager II* | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2000 | 2000 | 2000 | 2000 | 2000 | 10000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 6 | Systems Integr. Engr I | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1000 | 1000 | 1000 | 1000 | 1000 | 5000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 7 | Systems Integr. Engr II** | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1000 | 1000 | 1000 | 1000 | 1000 | 5000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 8 | Risk Assessment Mgr I | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1000 | 1000 | 1000 | 1000 | 1000 | 5000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 9 | Risk Assessment Mgr II** | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1000 | 1000 | 1000 | 1000 | 1000 | 5000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 10 | Civil/Environmental Engineer I | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1000 | 1000 | 1000 | 1000 | 1000 | 5000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 11 | Civil/Environmental Engineer II** | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1000 | 1000 | 1000 | 1000 | 1000 | 5000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 12 | QA/QC Manager** | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 400 | 400 | 400 | 400 | 400 | 2000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 13 | Systems Safety Manager | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 400 | 400 | 400 | 400 | 400 | 2000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 14 | Cost Estimation Manager | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 200 | 200 | 200 | 200 | 200 | 1000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 15 | Project Scheduling Manager | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 16 | Vehicle Engineer | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 17 | Real Estate Manager | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 18 | Contract Procurement Manager | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 200 | 200 | 200 | 200 | 200 | 1000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 19 | Transit Operations Manager | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 20 | Communications Engr I | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 21 | Communications Engr II | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 22 | Structural Engineer I | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 23 | Structural Engineer II** | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 24 | Buy America Expert I | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 25 | Buy America Expert II | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 26 | Mechanical Engineer | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 27 | Electrical Power Distribution Engineer I | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 28 | Electrical Power Distribution Engineer II | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 29 | Rail Transit Signal and Control Systems Engr I | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 30 | Rail Transit Signal and Control Systems Engr II | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 31 | Tunneling Engineer | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 300 | 300 | 300 | 300 | 300 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 32 | Technical Writer** | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 800 | 800 | 800 | 800 | 800 | 4000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| 33 | Clerical Support** | $ - 0 | 0% | $ - 0 | 0.00% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 800 | 800 | 800 | 800 | 800 | 4000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| L | |||||||||||||||||||||||||||
| * Key Personnel ** Mission Critical Personnel | |||||||||||||||||||||||||||
| *** Assumes a 3.7% Escalation Rate | |||||||||||||||||||||||||||
| Consultants | |||||||||||||||||||||||||||
| Clerical Support | $ 100.00 | 800 | 800 | 800 | 800 | 800 | 4000 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $ 400,000 | ||||||||||||||
| Clerical Support | $ 100.00 | 800 | 800 | 800 | 800 | 800 | 4000 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $ 400,000 | ||||||||||||||
| Clerical Support | $ 100.00 | 800 | 800 | 800 | 800 | 800 | 4000 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $ 400,000 | ||||||||||||||
| Clerical Support | $ 100.00 | 800 | 800 | 800 | 800 | 800 | 4000 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $ 400,000 | ||||||||||||||
| Clerical Support | $ 100.00 | 800 | 800 | 800 | 800 | 800 | 4000 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $ 400,000 | ||||||||||||||
| Clerical Support | $ 100.00 | 800 | 800 | 800 | 800 | 800 | 4000 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $ 400,000 | ||||||||||||||
| Clerical Support | $ 100.00 | 800 | 800 | 800 | 800 | 800 | 4000 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $80,000.00 | $ 400,000 | ||||||||||||||
| *- No escalation Rate for Consultants |
image1.jpeg image2.jpeg
File details come from the government source that posted it. Updated .