03 Att 2 Pricing Matrix.xlsx
XLSX spreadsheet 407 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 the DIVER (Data Integration) environmental database management support contract with the National Oceanic and Atmospheric Administration (NOAA), Office of Response & Restoration. The document outlines the cost line items (CLINs) and labor categories for a base period plus four option years, with all values currently showing $0.00 as placeholder amounts pending contractor pricing submission.
The contract structure includes three pricing approaches across four task categories: Task 2.1 (Database Management) is priced on a Firm Fixed Price (FFP) basis with a monthly rate, while Tasks 2.2 and 2.3 (labor support) and Task 2.4 (Emergency Contingency) are priced on a Time & Materials (T&M) basis. The labor categories span seven positions for Task 2.1 (Database Management Coordinator, Programmer/Analyst, Technician, Spatial Database Manager, Statistician/Data Manager, Senior Scientist, and Project Manager/Administrator) with estimated annual hours ranging from 60 to 500 hours, and four labor categories for Tasks 2.2/2.3 with estimated hours of 50 to 150. The template includes columns for hourly rates, discount percentages, discounted rates, and extended costs. Internal communications indicate that the FFP rates were derived from prior T&M analysis based on the current contract, updated by a factor of 0.02, and that the emergency contingency CLIN was established as a separate funding mechanism to enable faster activation of resources on an as-needed basis rather than requiring funding modifications.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Sol_1305M226Q0065_Amd_0003.pdf | ||
| 03 Att 2 Pricing Matrix Amend 0003.xlsx | XLSX spreadsheet | |
| 03 DIVER RFQ Vendor QA.pdf | ||
| Sol_1305M226Q0065_Amd_0002.pdf | ||
| Sol_1305M226Q0065_Amd_0001 (1).pdf | ||
| 03 Att 1 PWS F.pdf | ||
| 03 Att 3 QASP.pdf | ||
| Sol_1305M226Q0065 (1).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 | |||
| 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 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 | |||
| 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 | |||
| 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
OY3
DIVER Data Integration OPTION YEAR THREE
Estimate of Project and Database Management for Firm Fixed Portion of contract
| Category | |||
| 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 OY3 Cost $0.00
OY4
DIVER Data Integration OPTION YEAR FOUR
Estimate of Project and Database Management for Firm Fixed Portion of contract
| Category | |||
| 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 OY4 Cost $0.00
File details come from the government source that posted it. Updated .