Amendment 0001 Attachment J-1 Pricing Matrix.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Amendment 0001 - NTD Program Support
- Solicitation number
- 69319522R000002
About this file
This document contains a pricing matrix and labor categories for a solicitation seeking contractor support for the National Transit Database Program. The pricing matrix outlines firm fixed price and labor hour contract line item numbers for base, option year 1, and option year 2 for services including an annual module, monthly module, safety and security module, apportionment and non-Excel data products, annual review, reporting manuals and website content, program performance metrics reporting, and travel. Labor hour contract line items detail government estimated and contractor recommended hours and hourly rates for special projects, training provision, user acceptance testing and system requirements documentation, and written documents. The related federal contract opportunity provides additional details on solicitation number 69319522R000002 seeking proposals due May 17, 2022 to support budget and policy requirements for the National Transit Database Program through the Department of Transportation's Federal Transit Administration.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 69319522R000002 - SF30 Amendment 0001_Signed.pdf | ||
| Amendment 0001 - Attachment J-2 Past Performance Questionairre.docx | DOCX document | |
| Amendment 0001 - Request for Proposal No. 69319522R000002.pdf | ||
| Amendment 0001 Solicitation 69319522R000002- Questions received.xlsx | XLSX spreadsheet | |
| Attachment J-2 Past Performance Questionairre.docx | DOCX document | |
| Final RFP National Transit Database (NTD) - Program Support RFP.pdf | ||
| Attachment J-1 Pricing Matrix (1).xlsx | XLSX spreadsheet | |
| 69319522R000002 - SF33.pdf | ||
| Attachment J.3 - Resume Template.docx | DOCX document |
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
Sheet1
| Price Matrix | |||||
| Firm Fixed Price CLIN | Base Year | Option Year 1 | Option Year 2 | ||
| CLIN Description | CLIN | Reimbursement Type | Not To Exceed Amount | Not To Exceed Amount | Not To Exceed Amount |
| NTD Assistance | 0001, 0101, 0201 | Firm Fixed Price | |||
| Annual Module | 0002, 0102, 0202 | Firm Fixed Price | |||
| Monthly Module | 0003, 0103, 0203 | Firm Fixed Price | |||
| Safety and Security Module | 0004, 0104, 0204 | Firm Fixed Price | |||
| Apportionment and Certain Non-Excel Data Products | 0005, 0105, 0205 | Firm Fixed Price | |||
| Annual Review | 0006, 0106, 0206 | Firm Fixed Price | |||
| Reporting Manuals, Training Materials and Website Content | 0007, 0107, 0207 | Firm Fixed Price | |||
| Program Performance Metrics Reporting | 0008, 0108, 0208 | Firm Fixed Price | |||
| Travel* | 0009, 0109, 0209 | Cost Reimbursable | $42,014 | $42,644 | $43,284 |
| Transition | 0013, 0213 | Firm Fixed Price | $20,000 | $20,604.50 | |
| Staffing Plan | 0015, 0115, 0215 | Firm Fixed Price |
| Labor Hour CLIN | Base Year | Option Year 1 | Option Year 2 | ||
| CLIN Description | CLIN | Reimbursement Type | Total Cost Not To Exceed (Contractor Recommended) | Total Cost Not To Exceed (Contractor Recommended) | Total Cost Not To Exceed (Contractor Recommended) |
| Special Projects | 0010, 0110, 0210 | Labor Hours (detail in table below) | |||
| Training Provision | 0011, 0111, 0211 | Labor Hours (detail in table below) | |||
| User Accpetance Testing and System Requirements Documentation | 0012, 0112, 0212 | Labor Hours (detail in table below) | |||
| Written Documents | 014, 014, 024 | Labor Hours (detail in table below) |
Total Contract Cost (All CLINs) Base Year Option Year 1 Option Year 2
| Base Year Labor Hour CLIN Detail | |||||
| 0010: Special Projects | |||||
| Year | Base Year | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 204 | ||||
| Subject Matter Expert | 204 | ||||
| Data Analyst (Sr) | 204 | ||||
| Data Analyst (Jr) | 407 | ||||
| Database Architect I | 204 | ||||
| Total | 1222 |
| 0011: Training Provision | |||||
| Year | Base Year | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 13 | ||||
| Subject Matter Expert | 43 | ||||
| Trainer | 130 | ||||
| Total | 186 |
| 0012: User Accpetance Testing and System Requirements Documentation | |||||
| Year | Base Year | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 130 | ||||
| Database Architect I | 611 | ||||
| Senior Database Developer | 611 | ||||
| Data Analyst (Jr) | 1018 | ||||
| Total | 2370 |
| 0014: Written Documents | |||||
| Year | Base Year | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 67 | ||||
| Subject Matter Expert | 67 | ||||
| Data Analyst (Sr) | 134 | ||||
| Data Analyst (Jr) | 134 | ||||
| Editor | 407 | ||||
| Total | 811 |
| Option Year 1 Labor Hour CLIN Detail | |||||
| 0110: Special Projects | |||||
| Year | Option Year 1 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 188 | ||||
| Subject Matter Expert | 188 | ||||
| Data Analyst (Sr) | 188 | ||||
| Data Analyst (Jr) | 376 | ||||
| Database Architect I | 188 | ||||
| Total | 1128 |
| 0111: Training Provision | |||||
| Year | Option Year 1 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 12 | ||||
| Subject Matter Expert | 40 | ||||
| Trainer | 120 | ||||
| Total | 172 |
| 0112: User Accpetance Testing and System Requirements Documentation | |||||
| Year | Option Year 1 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 120 | ||||
| Database Architect I | 564 | ||||
| Senior Database Developer | 564 | ||||
| Data Analyst (Jr) | 940 | ||||
| Total | 2188 |
| 0114: Written Documents | |
| Year | |
| Labor Category | Govt Estimated Hours |
| Project Manager | 62 |
| Subject Matter Expert | 62 |
| Data Analyst (Sr) | 124 |
| Data Analyst (Jr) | 124 |
| Editor | 376 |
| Total | 748 |
| Option Year 2 Labor Hour CLIN Detail | |||||
| 0210: Special Projects | |||||
| Year | Option Year 2 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 188 | ||||
| Subject Matter Expert | 188 | ||||
| Data Analyst (Sr) | 188 | ||||
| Data Analyst (Jr) | 376 | ||||
| Database Architect I | 188 | ||||
| Total | 1128 |
| 0211: Training Provision | |||||
| Year | Option Year 2 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 12 | ||||
| Subject Matter Expert | 40 | ||||
| Trainer | 120 | ||||
| Total | 172 |
| 0212: User Accpetance Testing and System Requirements Documentation | |||||
| Year | Option Year 2 | ||||
| Labor Category | Govt Estimated Hours | Contractor Recommended Hours | Hourly Rate | Total Cost (Govt Hrs) | Total Cost (Contractor Recommended Hrs) |
| Project Manager | 120 | ||||
| Database Architect I | 564 | ||||
| Senior Database Developer | 564 | ||||
| Data Analyst (Jr) | 940 | ||||
| Total | 2188 |
| 0214: Written Documents | |
| Year | |
| Labor Category | Govt Estimated Hours |
| Project Manager | 62 |
| Subject Matter Expert | 62 |
| Data Analyst (Sr) | 124 |
| Data Analyst (Jr) | 124 |
| Editor | 376 |
| Total | 748 |
File details come from the government source that posted it. Updated .