03 Att 2 Pricing Matrix Amend 0003.xlsx
XLSX spreadsheet 410 KB Posted
- Attached to
- Office of Response & Restoration Environmental Database Management Support Federal contract opportunity
- Solicitation number
- 1305M226Q0065
About this file
This is a pricing matrix template for Amendment 0003 to a NOAA contract for DIVER (Data Integration) database management support services. The document outlines contract line items (CLINs) structured across a base period and four option years, with all pricing currently shown as $0.00, indicating this is a template requiring completion.
The contract employs a hybrid pricing approach combining Firm Fixed Price (FFP) and Time & Materials (T&M) components. Task 2.1 covers Database Management on an FFP basis with estimated monthly labor requirements for Database Management Coordinators, Programmers/Analysts, Technicians, and Project Managers/Administrators. Tasks 2.2 and 2.3 are priced as T&M with estimated annual hours for seven labor categories including Database Management Coordinators, Programmers/Analysts, Technicians, Spatial Database Managers, Statisticians/Data Managers, Senior Scientists, and Project Managers/Administrators. Task 2.4 represents Emergency Contingency T&M with a Not-To-Exceed (NTE) limitation, covering similar labor categories with reduced hour estimates. The embedded email communications indicate that FFP rates were derived from prior T&M data and the current contract with a 0.02 multiplier, and that minimum monthly support amounts are required for database management, dataset review, and data template management updates. Labor rates display placeholder values with 0% discounts applied across all categories and periods.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Sol_1305M226Q0065_Amd_0003.pdf | ||
| 03 DIVER RFQ Vendor QA.pdf | ||
| Sol_1305M226Q0065_Amd_0002.pdf | ||
| Sol_1305M226Q0065_Amd_0001 (1).pdf | ||
| 03 Att 1 PWS F.pdf | ||
| Sol_1305M226Q0065 (1).pdf | ||
| 03 Att 2 Pricing Matrix.xlsx | XLSX spreadsheet | |
| 03 Att 3 QASP.pdf |
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
Pricing CLINs
| CLIN | CLIN Description | Total Extended Price |
| CLIN 0001 | Database Management (FFP) Task 2.1 | $0.00 |
| CLIN 4002 | Labor T&M Task 2.2 and 2.3 | $0.00 |
| CLIN 0003 | Emergency Contingency T&M NTE, Task 2.4 | $0.00 |
| Base Period Total Price | $0.00 | |
| CLIN 1001 | Database Management (FFP) Task 2.1 | $0.00 |
| CLIN 1002 | Labor T&M Task 2.2 and 2.3 | $0.00 |
| CLIN 1003 | Emergency Contingency T&M NTE, Task 2.4 | $0.00 |
| Option One Total Price | $0.00 | |
| CLIN 2001 | Database Management (FFP) Task 2.1 | $0.00 |
| CLIN 2002 | Labor T&M Task 2.2 and 2.3 | $0.00 |
| CLIN 2003 | Emergency Contingency T&M NTE, Task 2.4 | $0.00 |
| Option Two Total Price | $0.00 | |
| CLIN 3001 | Database Management (FFP) Task 2.1 | $0.00 |
| CLIN 3002 | Labor T&M Task 2.2 and 2.3 | $0.00 |
| CLIN 3003 | Emergency Contingency T&M NTE, Task 2.4 | $0.00 |
| Option Three Total Price | $0.00 | |
| CLIN 4001 | Database Management (FFP) Task 2.1 | $0.00 |
| CLIN 4002 | Labor T&M Task 2.2 and 2.3 | $0.00 |
| CLIN 4003 | Emergency Contingency T&M NTE, Task 2.4 | $0.00 |
| Option Four Total Price | $0.00 | |
| Total All Periods | $0.00 |
Base Year DIVER Data Integration BASE YEAR
Estimate of Project and Database Management for Firm Fixed Portion of contract
| Category | |||||
| Labor Category | Rate | Discount % | Discount Rate | Historical Hours | Base Year Cost |
| Database Management Coordinator | $ - 0 | 10 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 10 | $0.00 | ||
| Database Technician | $ - 0 | 10 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 10 | $0.00 | ||
| Task 2.1 Database Management (FFP)* | Monthly Price | Total | $0.00 |
| Labor Category | Rate | Discount % | Discount Rate | Gov. Est. Annual Hours | Base Year Cost |
| Database Management Coordinator | $ - 0 | 500 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 300 | $0.00 | ||
| Database Technician | $ - 0 | 300 | $0.00 | ||
| Spatial Database Manager | $ - 0 | 60 | $0.00 | ||
| Statistician/Data Manager | $ - 0 | 60 | $0.00 | ||
| Senior Scientist | $ - 0 | 60 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 200 | $0.00 | ||
| Tasks 2.2 and 2.3 Labor Subtotal (T&M): | Total | $0.00 |
| Labor Category | Rate | Discount % | Discount Rate | Gov. Est. Annual Hours | Base Year Cost |
| Database Management Coordinator | $ - 0 | 100 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 150 | $0.00 | ||
| Database Technician | $ - 0 | 100 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 50 | $0.00 | ||
| Task 2.4 Labor Subtotal (T&M): | Total | $0.00 |
Total Base Year Cost $0.00
@benjamin.shorr@noaa.gov What are these rates based off of?
Assigned to benjamin.shorr@noaa.gov
These rates were based on my Option Year 2 IGCE for the current contract; I've updated these rates to reflect the current contract x 0.02. @heather.l.coleman@noaa.gov Reassigned to heather.l.coleman@noaa.gov
@benjamin.shorr@noaa.gov Can this not be included in the above T&M? Does it have to be a separate CLIN? Since it is T&M, it can be funded on an as-needed but could potentially be quicker to "activate" if there is funding available instead of waiting on a funding mod.
Assigned to benjamin.shorr@noaa.gov
@heather.l.coleman@noaa.gov I'm happy to do this however you think best - however I don't know how I would include in T&M with unknown hours.
Reassigned to heather.l.coleman@noaa.gov
Either way there has to be basis, even if just an estimate. There is no mechanism that we can set an amount for anything other than travel/ODCs.
@benjamin.shorr@noaa.gov Where did this come from? What is the breakdown here?
Assigned to benjamin.shorr@noaa.gov
I will provide a breakdown of prior T&M that was used to derive this FFP based on AGO's prior directive to convert some of the T&M to FFP. Basically, there is a minimum amount of overall support needed per month for database management, dataset review and data template management and updates.
Great, that is perfect. thank you!
OY1
DIVER Data Integration OPTION YEAR ONE
Estimate of Project and Database Management for Firm Fixed Portion of contract
| Category | |||||
| Labor Category | Rate | Discount % | Discount Rate | Historical Hours | Option Year One Cost |
| Database Management Coordinator | $ - 0 | 10 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 10 | $0.00 | ||
| Database Technician | $ - 0 | 10 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 10 | $0.00 | ||
| Task 2.1 Database Management (FFP)* | Monthly Price | Total | $0.00 |
| Labor Category | Rate | Discount % | Discount Rate | Gov. Est. Annual Hours | Option Year One Cost |
| Database Management Coordinator | $ - 0 | 500 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 300 | $0.00 | ||
| Database Technician | $ - 0 | 300 | $0.00 | ||
| Spatial Database Manager | $ - 0 | 60 | $0.00 | ||
| Statistician/Data Manager | $ - 0 | 60 | $0.00 | ||
| Senior Scientist | $ - 0 | 60 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 200 | $0.00 | ||
| Tasks 2.2 and 2.3 Labor Subtotal (T&M): | Total | $0.00 |
| Labor Category | Rate | Discount % | Discount Rate | Gov. Est. Annual Hours | Option Year One Cost |
| Database Management Coordinator | $ - 0 | 100 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 150 | $0.00 | ||
| Database Technician | $ - 0 | 100 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 50 | $0.00 | ||
| Task 2.4 Labor Subtotal (T&M): | Total | $0.00 |
Total OY2 Cost $0.00
OY2
DIVER Data Integration OPTION YEAR TWO
Estimate of Project and Database Management for Firm Fixed Portion of contract
| Category | |||||
| Labor Category | Rate | Discount % | Discount Rate | Historical Hours | Option Year Two Cost |
| Database Management Coordinator | $ - 0 | 10 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 10 | $0.00 | ||
| Database Technician | $ - 0 | 10 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 10 | $0.00 | ||
| Task 2.1 Database Management (FFP)* | Monthly Price | Total | $0.00 |
| Labor Category | Rate | Discount % | Discount Rate | Gov. Est. Annual Hours | Option Year Two Cost |
| Database Management Coordinator | $ - 0 | 500 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 300 | $0.00 | ||
| Database Technician | $ - 0 | 300 | $0.00 | ||
| Spatial Database Manager | $ - 0 | 60 | $0.00 | ||
| Statistician/Data Manager | $ - 0 | 60 | $0.00 | ||
| Senior Scientist | $ - 0 | 60 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 200 | $0.00 | ||
| Tasks 2.2 and 2.3 Labor Subtotal (T&M): | Total | $0.00 |
| Labor Category | Rate | Discount % | Discount Rate | Gov. Est. Annual Hours | Option Year Two Cost |
| Database Management Coordinator | $ - 0 | 100 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 150 | $0.00 | ||
| Database Technician | $ - 0 | 100 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 50 | $0.00 | ||
| Task 2.4 Labor Subtotal (T&M): | Total | $0.00 |
Total OY2 Cost $0.00
OY3
DIVER Data Integration OPTION YEAR THREE
Estimate of Project and Database Management for Firm Fixed Portion of contract
| Category | |||||
| Labor Category | Rate | Discount % | Discount Rate | Historical Hours | Option Year Three Cost |
| Database Management Coordinator | $ - 0 | 10 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 10 | $0.00 | ||
| Database Technician | $ - 0 | 10 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 10 | $0.00 | ||
| Task 2.1 Database Management (FFP)* | Monthly Price | Total | $0.00 |
| Labor Category | Rate | Discount % | Discount Rate | Gov. Est. Annual Hours | Option Year Three Cost |
| Database Management Coordinator | $ - 0 | 500 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 300 | $0.00 | ||
| Database Technician | $ - 0 | 300 | $0.00 | ||
| Spatial Database Manager | $ - 0 | 60 | $0.00 | ||
| Statistician/Data Manager | $ - 0 | 60 | $0.00 | ||
| Senior Scientist | $ - 0 | 60 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 200 | $0.00 | ||
| Tasks 2.2 and 2.3 Labor Subtotal (T&M): | Total | $0.00 |
| Labor Category | Rate | Discount % | Discount Rate | Gov. Est. Annual Hours | Option Year Three Cost |
| Database Management Coordinator | $ - 0 | 100 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 150 | $0.00 | ||
| Database Technician | $ - 0 | 100 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 50 | $0.00 | ||
| Task 2.4 Labor Subtotal (T&M): | Total | $0.00 |
Total OY3 Cost $0.00
OY4
DIVER Data Integration OPTION YEAR FOUR
Estimate of Project and Database Management for Firm Fixed Portion of contract
| Category | |||||
| Labor Category | Rate | Discount % | Discount Rate | Historical Hours | Option Year Four Cost |
| Database Management Coordinator | $ - 0 | 10 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 10 | $0.00 | ||
| Database Technician | $ - 0 | 10 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 10 | $0.00 | ||
| Task 2.1 Database Management (FFP)* | Monthly Price | Total | $0.00 |
| Labor Category | Rate | Discount % | Discount Rate | Gov. Est. Annual Hours | Option Year Four Cost |
| Database Management Coordinator | $ - 0 | 500 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 300 | $0.00 | ||
| Database Technician | $ - 0 | 300 | $0.00 | ||
| Spatial Database Manager | $ - 0 | 60 | $0.00 | ||
| Statistician/Data Manager | $ - 0 | 60 | $0.00 | ||
| Senior Scientist | $ - 0 | 60 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 200 | $0.00 | ||
| Tasks 2.2 and 2.3 Labor Subtotal (T&M): | Total | $0.00 |
| Labor Category | Rate | Discount % | Discount Rate | Gov. Est. Annual Hours | Option Year Four Cost |
| Database Management Coordinator | $ - 0 | 100 | $0.00 | ||
| Database Programmer/Analyst | $ - 0 | 150 | $0.00 | ||
| Database Technician | $ - 0 | 100 | $0.00 | ||
| Project Manager/Administrator | $ - 0 | 50 | $0.00 | ||
| Task 2.4 Labor Subtotal (T&M): | Total | $0.00 |
Total OY4 Cost $0.00
File details come from the government source that posted it. Updated .