Attachment_1_Pricing_Spreadsheet.xlsx
XLSX spreadsheet 21 KB Posted
- Solicitation number
- ID07180027
- Issued by
-
GSA Federal Acquisition Service
About this file
Pricing Spreadsheet
View the file
Other files
Show all 15
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
F-16 TSSC
| ID07180027 - Attachment 1 Pricing Spreadsheet | |
| Blue Cells = Vendor Input Required | |
| Green Cells = Government Suggested Labor Levels, Vendor May Change As Necessary to Create FFP, Total Solution Pricing | |
| Tan Cells = Autocalculated or Government Pre-Filled Data, No Vendor Input Required | |
| White Cells = Autocalculated or Government Pre-Filled Data, No Vendor Input Required |
| LABOR | |||||||||||||||||||||
| Base Year Hour Quantity | Base Year Labor Rate | Base Year Total | Option Year 1 Hour Quantity | Option Year 1 Labor Rate | Option Year 1 Total | Option Year 2 Hour Quantity | Option Year 2 Labor Rate | Option Year 2 Total | Option Year 3 Hour Quantity | Option Year 3 Labor Rate | Option Year 3 Total | Option Year 4 Hour Quantity | Option Year 4 Labor Rate | Option Year 4 Total | Base + All Option Year LaborTotal | ||||||
| CLIN (ANG FFP) | CLIN 0001 | CLIN 0001 | CLIN 0001 | CLIN 1001 | CLIN 1001 | CLIN 1001 | CLIN 2001 | CLIN 2001 | CLIN 2001 | CLIN 3001 | CLIN 3001 | CLIN 3001 | CLIN 4001 | CLIN 4001 | CLIN 4001 | ||||||
| TSSC Manager | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | |||||||||||
| Depot Manager | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | |||||||||||
| Configuration Manager | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | |||||||||||
| Logistics Support Lead | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | |||||||||||
| Admin Assistant / Data Manager | 0.00 | $ - 0 | 1040.00 | $ - 0 | 1040.00 | $ - 0 | 1040.00 | $ - 0 | 1040.00 | $ - 0 | |||||||||||
| Technical Writer | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | |||||||||||
| Help Desk | 2080.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | |||||||||||
| Hardware Engineer | 2080.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | |||||||||||
| Software Engineer | 2080.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | |||||||||||
| Cybersecurity | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | |||||||||||
| Scenario Generation Developer | 0.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | |||||||||||
| Facility Security Manager | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | |||||||||||
| COMS Technical Manager | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | |||||||||||
| COMS Personnel | 16640.00 | $ - 0 | 16640.00 | $ - 0 | 16640.00 | $ - 0 | 16640.00 | $ - 0 | 16640.00 | $ - 0 | |||||||||||
| Admin Assistant (Program Management Support) | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | 2080.00 | $ - 0 | |||||||||||
| Program Management | 2080.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | |||||||||||
| TOTAL | 21.00 | Base Year | $0.00 | 23.50 | Option Year 1 | $0.00 | 23.50 | Option Year 2 | $0.00 | 23.50 | Option Year 3 | $0.00 | 23.50 | Option Year 4 | $0.00 | ||||||
| CLIN (AFRC FFP) | CLIN 0002 | CLIN 0002 | CLIN 0002 | CLIN 1002 | CLIN 1002 | CLIN 1002 | CLIN 2002 | CLIN 2002 | CLIN 2002 | CLIN 3002 | CLIN 3002 | CLIN 3002 | CLIN 4002 | CLIN 4002 | CLIN 4002 | ||||||
| Courseware/ Instructor | 16640.00 | $ - 0 | 16640.00 | $ - 0 | 16640.00 | $ - 0 | 16640.00 | $ - 0 | 16640.00 | $ - 0 | |||||||||||
| Cybersecutiry | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | |||||||||||
| Field Service Engineer | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | |||||||||||
| Software Engineer | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | 4160.00 | $ - 0 | |||||||||||
| TOTAL | 14.00 | Base Year | $0.00 | 14.00 | Option Year 1 | $0.00 | 14.00 | Option Year 2 | $0.00 | 14.00 | Option Year 3 | $0.00 | 14.00 | Option Year 4 | $0.00 | ||||||
| CLIN (ANG T&M Labor Surge) | CLIN 0003 | CLIN 0003 | CLIN 0003 | CLIN 1003 | CLIN 1003 | CLIN 1003 | CLIN 2003 | CLIN 2003 | CLIN 2003 | CLIN 3003 | CLIN 3003 | CLIN 3003 | CLIN 4003 | CLIN 4003 | CLIN 4003 | ||||||
| COMS Personnel | 0.00 | $ - 0 | 10400.00 | $ - 0 | 10400.00 | $ - 0 | 10400.00 | $ - 0 | 10400.00 | $ - 0 | |||||||||||
| TOTAL | 0.00 | Base Year | $0.00 | 5.00 | Option Year 1 | $0.00 | 5.00 | Option Year 2 | $0.00 | 5.00 | Option Year 3 | $0.00 | 5.00 | Option Year 4 | $0.00 | ||||||
| LABOR TOTAL | 35.00 | $0.00 | 42.50 | $0.00 | 42.50 | $0.00 | 42.50 | $0.00 | 42.50 | $0.00 | $0.00 | ||||||||||
| OTHER DIRECT COSTS (ODCs) | |||||||||||||||||||||
| OTHER DIRECT COSTS [include materials/services per the PWS] | Anticipated ODC Value - Base Year | Base Year Total | Anticipated ODC Value - OY1 | OY1 Total | Anticipated ODC Value - OY2 | OY2 Total | Anticipated ODC Value - OY3 | OY2 Total | Anticipated ODC Value - OY4 | OY4 Total | Base + All Option Year ODC Total | ||||||||||
| CLIN (ANG) | 0004* | $1,050,000.00 | 1004* | $1,050,000.00 | 2004* | $1,050,000.00 | 3004* | $1,050,000.00 | 4004* | $1,050,000.00 | |||||||||||
| CLIN (AFRC) | 0005* | $100,000.00 | 1005* | $100,000.00 | 2005* | $100,000.00 | 3005* | $100,000.00 | 4005* | $100,000.00 | |||||||||||
| ODCs (NTE) * DO NOT ADJUST THESE FIGURES. SEE ADDITIONAL NOTE # 1 BELOW | $1,150,000.00 | $1,150,000.00 | $1,150,000.00 | $1,150,000.00 | $1,150,000.00 | $5,750,000.00 |
| TRAVEL | |||||||||||
| TRAVEL PERIOD OF PERFORMANCE | Anticipated Travel Value - Base Year | Base Year Total | Anticipated Travel Value - OY1 | OY1 Total | Anticipated Travel Value - OY1 | OY1 Total | Anticipated Travel Value - OY3 | OY3 Total | Anticipated Travel Value - OY4 | OY4 Total | Base + All Option Year Travel Total |
| CLIN (ANG) | 0006* | $88,000.00 | 1006* | $88,000.00 | 2006* | $88,000.00 | 3006* | $88,000.00 | 4006* | $88,000.00 | |
| CLIN (AFRC) | 0007* | $36,000.00 | 1007* | $36,000.00 | 2007* | $36,000.00 | 3007* | $36,000.00 | 4007* | $36,000.00 | |
| TRAVEL (NTE) * DO NOT ADJUST THESE FIGURES. | $124,000.00 | $124,000.00 | $124,000.00 | $124,000.00 | $124,000.00 | $620,000.00 | |||||
| 240 |
| TOTALS | |
| GRAND TOTAL PRICE ALL CLINS, ALL OPTION YEARS | $6,370,000.00 |
| NOTE # 1 PERTAINING TO ODC CLIN: |
| Any labor necessary for the oversight and management of the ODC material requirement should be included in labor CLIN pricing. |
File details come from the government source that posted it.