Attachment 0004 Price Matrix - APT EA AND AWG SUSTAINMENT.xlsx
XLSX spreadsheet 32 KB Posted
- Solicitation number
- W519TC-25-R-0031
About this file
This is a pricing matrix template for solicitation W519TC-25-R-0031, which covers sustainment services for APT (Analytic Product Team), EA (Enterprise Analytics), and AWG (Analysis Working Group) teams. The template requires offerors to provide labor pricing across 17 labor categories spanning three primary work areas (AWG, APT, and EA), with positions including Product Leads, Data Engineers, Portfolio Managers, Technical Leads, and Business Intelligence roles at senior and journeyman levels.
The pricing structure includes a 12-month base period (15 Feb 2025 - 14 Feb 2026) and three 3-month option periods extending through 14 Nov 2026. The contract includes both Firm-Fixed-Price (FFP) labor CLINs and a Cost-Reimbursable (CR) travel CLIN with a total estimated value of $17,500 for travel across all periods. The template calculates Full-Time Equivalents (FTEs) based on 1,912 hours per year and requires staffing for approximately 189.42 total FTEs across all periods, representing 310,428 total labor hours.
View the file
Other files
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
Summary
| W519TC-25-R-0031 |
| AWG / APT / EA SUSTAINMENT - UWD |
| Offeror Summary Pricing |
| Matrix Updated: 13 January 2025 |
| Offeror/Company Name: |
| Cage Code: |
| UEI number: |
| Proposal Date: |
| Description | CLIN Type | CLIN | Base Year | Option Period 1 | Option Period 2 | Option Period 3 | Subtotal |
| Labor | FFP | X001AA-X003AG | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Travel (Government Surrogate) | CR | X004AA | $10,000.00 | $2,500.00 | $2,500.00 | $2,500.00 | $17,500.00 |
| Total Evaluated Price per Pop | $10,000.00 | $2,500.00 | $2,500.00 | $2,500.00 | |||
| Total Evaluated Price | $17,500.00 |
Labor
| Base Period | ||||||||||||||||||||||||
| 15 Feb 2025 - 14 Feb 2026 | Option Period 1 (3 months) | |||||||||||||||||||||||
| 15 Feb 2026 - 14 May 2026 | Option Period 2 (3 months) | |||||||||||||||||||||||
| 15 May 2026 - 14 Aug 2026 | Option Period 3 (3 months) | |||||||||||||||||||||||
| 15 Aug 2026 - 14 Nov 2026 | Total per Labor Category | |||||||||||||||||||||||
| CLIN | Labor Category | Level | Proposed Labor Category | Hours | FTE | Rate | Total | Hours | FTE | Rate | Total | Hours | FTE | Rate | Total | Hours | FTE | Rate | Total | Labor Hours | FTE | Total Price | ||
| AWG | X001AA | Product Lead | Senior | 3,425.00 | 1.79 | $ - 0 | $ - 0 | 856.25 | 0.45 | $ - 0 | $ - 0 | 856.25 | 0.45 | $ - 0 | $ - 0 | 856.25 | 0.45 | $ - 0 | $ - 0 | 5,137.50 | 3.13 | $ - 0 | ||
| X001AB | Senior Data Engineer | Senior | 2,957.00 | 1.55 | $ - 0 | $ - 0 | 739.25 | 0.39 | $ - 0 | $ - 0 | 739.25 | 0.39 | $ - 0 | $ - 0 | 739.25 | 0.39 | $ - 0 | $ - 0 | 4,435.50 | 2.71 | $ - 0 | |||
| X001AC | Data Visualization Developer | Journeyman | 3,230.00 | 1.69 | $ - 0 | $ - 0 | 807.50 | 0.42 | $ - 0 | $ - 0 | 807.50 | 0.42 | $ - 0 | $ - 0 | 807.50 | 0.42 | $ - 0 | $ - 0 | 4,845.00 | 2.96 | $ - 0 | |||
| APT | X002AA | Portfolio Manager | Senior | 3,250.00 | 1.70 | $ - 0 | $ - 0 | 812.50 | 0.42 | $ - 0 | $ - 0 | 812.50 | 0.42 | $ - 0 | $ - 0 | 812.50 | 0.42 | $ - 0 | $ - 0 | 4,875.00 | 2.97 | $ - 0 | ||
| X002AB | Project Manager | Senior | 3,250.00 | 1.70 | $ - 0 | $ - 0 | 812.50 | 0.42 | $ - 0 | $ - 0 | 812.50 | 0.42 | $ - 0 | $ - 0 | 812.50 | 0.42 | $ - 0 | $ - 0 | 4,875.00 | 2.97 | $ - 0 | |||
| X002AC | Operations Lead | Senior | 3,250.00 | 1.70 | $ - 0 | $ - 0 | 812.50 | 0.42 | $ - 0 | $ - 0 | 812.50 | 0.42 | $ - 0 | $ - 0 | 812.50 | 0.42 | $ - 0 | $ - 0 | 4,875.00 | 2.97 | $ - 0 | |||
| X002AD | Product Lead | Senior | 17,273.00 | 9.03 | $ - 0 | $ - 0 | 4,318.25 | 2.26 | $ - 0 | $ - 0 | 4,318.25 | 2.26 | $ - 0 | $ - 0 | 4,318.25 | 2.26 | $ - 0 | $ - 0 | 25,909.50 | 15.81 | $ - 0 | |||
| X002AE | Technical Lead | Senior | 19,502.00 | 10.20 | $ - 0 | $ - 0 | 4,875.50 | 2.55 | $ - 0 | $ - 0 | 4,875.50 | 2.55 | $ - 0 | $ - 0 | 4,875.50 | 2.55 | $ - 0 | $ - 0 | 29,253.00 | 17.85 | $ - 0 | |||
| X002AF | Business Intelligence | Journeyman | 48,756.00 | 25.50 | $ - 0 | $ - 0 | 12,189.00 | 6.38 | $ - 0 | $ - 0 | 12,189.00 | 6.38 | $ - 0 | $ - 0 | 12,189.00 | 6.38 | $ - 0 | $ - 0 | 73,134.00 | 44.63 | $ - 0 | |||
| X002AG | Data Engineer | Journeyman | 48,756.00 | 25.50 | $ - 0 | $ - 0 | 12,189.00 | 6.38 | $ - 0 | $ - 0 | 12,189.00 | 6.38 | $ - 0 | $ - 0 | 12,189.00 | 6.38 | $ - 0 | $ - 0 | 73,134.00 | 44.63 | $ - 0 | |||
| EA | X003AA | Portfolio Manager | Senior | 2,772.00 | 1.45 | $ - 0 | $ - 0 | 693.00 | 0.36 | $ - 0 | $ - 0 | 693.00 | 0.36 | $ - 0 | $ - 0 | 693.00 | 0.36 | $ - 0 | $ - 0 | 4,158.00 | 2.54 | $ - 0 | ||
| X003AB | Project Manager | Senior | 2,772.00 | 1.45 | $ - 0 | $ - 0 | 693.00 | 0.36 | $ - 0 | $ - 0 | 693.00 | 0.36 | $ - 0 | $ - 0 | 693.00 | 0.36 | $ - 0 | $ - 0 | 4,158.00 | 2.54 | $ - 0 | |||
| X003AC | Operations Lead | Senior | 2,772.00 | 1.45 | $ - 0 | $ - 0 | 693.00 | 0.36 | $ - 0 | $ - 0 | 693.00 | 0.36 | $ - 0 | $ - 0 | 693.00 | 0.36 | $ - 0 | $ - 0 | 4,158.00 | 2.54 | $ - 0 | |||
| X003AD | Product Lead | Senior | 8,317.00 | 4.35 | $ - 0 | $ - 0 | 2,079.25 | 1.09 | $ - 0 | $ - 0 | 2,079.25 | 1.09 | $ - 0 | $ - 0 | 2,079.25 | 1.09 | $ - 0 | $ - 0 | 12,475.50 | 7.61 | $ - 0 | |||
| X003AE | Technical Lead | Senior | 8,946.00 | 4.68 | $ - 0 | $ - 0 | 2,236.50 | 1.17 | $ - 0 | $ - 0 | 2,236.50 | 1.17 | $ - 0 | $ - 0 | 2,236.50 | 1.17 | $ - 0 | $ - 0 | 13,419.00 | 8.19 | $ - 0 | |||
| X003AF | Business Intelligence | Journeyman | 13,862.00 | 7.25 | $ - 0 | $ - 0 | 3,465.50 | 1.81 | $ - 0 | $ - 0 | 3,465.50 | 1.81 | $ - 0 | $ - 0 | 3,465.50 | 1.81 | $ - 0 | $ - 0 | 20,793.00 | 12.69 | $ - 0 | |||
| X003AG | Data Engineer | Journeyman | 13,862.00 | 7.25 | $ - 0 | $ - 0 | 3,465.50 | 1.81 | $ - 0 | $ - 0 | 3,465.50 | 1.81 | $ - 0 | $ - 0 | 3,465.50 | 1.81 | $ - 0 | $ - 0 | 20,793.00 | 12.69 | $ - 0 | |||
| Labor Total | 206,952.00 | 108.24 | $ - 0 | 51,738.00 | 27.06 | $ - 0 | 51,738.00 | 27.06 | $ - 0 | 51,738.00 | 27.06 | $ - 0 | 310,428.00 | 189.42 | $ - 0 |
| 1 FTE = | 1912 |
| All prices must be entered to two decimal places. |
File details come from the government source that posted it. Updated .