07Attachment_J-5_JGASS__Labor__Pricing_Sheet_FINAL.xlsx
XLSX spreadsheet 46 KB Posted
- Attached to
- JGASS - Geospatial and Imagery Intelligence Analysts Federal contract opportunity
- Solicitation number
- H9222214R0013
- Issued by
- United States Special Operations Command
About this file
Attachment_J-5_JGASS__Labor__Pricing_Sheet_FINAL
View the file
Other files for this federal contract opportunity
Show all 26
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
Instruction Tab
| Step | Instruction | |||||
| 1 | The Offeror will only fill out the cells highlighted in yellow on the tabs highlighted in yellow | |||||
| 2 | Tab 4: The Offeror shall input its FFP Hourly Rates for the labor categories identified. These rates are for performance at the Site (either CONUS or OCONUS) | |||||
| 3 | On Tab 5: The Offeror shall input any applicable indirect rate for travel. IAW Section L the Government will input a travel base . | |||||
| 4 | On Tab 6: The Offeror shall input any ODC (such as DBA ) and the applicable indirect rates. | |||||
| 5 | After the Offeror has input all required information into this excel file, the Total Evaluated Price will be populated on Tab 1 | |||||
| Hours Assumptions for the Daily Rates | Weeks | Days Per Week | Total Days | Hours | total hours | |
| Regular (Non-shift) FTE | ||||||
| Starting Point: Full Year | 52 | 5 | 260 | 8 | 2080 | |
| Less: 10 Holidays plus 3 weeks sick/annual/admin leave | -5 | -5 | -25 | 8 | -200 | |
| CONUS Availability | 47 | 5 | 235 | 8 | 1880 |
| Shift and On-Call FTE | |||||
| Starting Point: Full Year | 52 | 5 | 260 | 9 | 2340 |
| Less: 10 Holidays plus 3 weeks sick/annual/admin leave | -5 | -5 | -25 | 8 | -200 |
| CONUS Availability | 47 | 5 | 235 | 9 | 2115 |
OCONUS, CONUS Deployment and Training Excercises 52 7 365 13 4745
1-TEP
| Description | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | |
| CLIN 0001 | CONUS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| CLIN 0002 | OCONUS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| CLIN 0004 | Travel | $ 500,000 | $ 500,000 | $ 500,000 | $ 500,000 | $ 500,000 | $ 2,500,000 |
| CLIN 0005 | ODC | $ 100,000 | $ 100,000 | $ 100,000 | $ 100,000 | $ 100,000 | $ 500,000 |
| CLIN 0006 | CDRLs | NA | NA | NA | NA | NA | NA |
Total Evaluated Price $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 3,000,000
2-CLIN 1 - CONUS
IAW Table 3.1 of SOW
| Working | Total Annual | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL | ||
| Labor Category | FTE | Hours | Hours | FFP Hourly Rate | FFP Hourly Rate | FFP Hourly Rate | FFP Hourly Rate | FFP Hourly Rate | Total FFP | Total FFP | Total FFP | Total FFP | Total FFP |
| Geospatial Intelligence Analyst (NC) | 14 | 2,115 | 29,610 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Geospatial Systems Specialist (NC) | 6 | 2,115 | 12,690 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Geospatial Systems Integrator (NVA) | 2 | 1,880 | 3,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Geospatial-Imagery Fusion Analyst (NVA) | 2 | 1,880 | 3,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Hyperspectral Imagery Scientist (NVA) | 1 | 1,880 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Hypespectral Analyst (NVA) | 1 | 1,880 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Imagery Analyst (Dam Neck VA) | 6 | 4,745 | 28,470 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Imagery Analyst (NC) | 111 | 2,115 | 234,765 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Project Manager/Deputy Project Manager (NC) | 2 | 1,880 | 3,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior Geospatial Systems Specialist (NC) | 2 | 2,115 | 4,230 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior GIS Administrator (NC) | 2 | 2,115 | 4,230 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior GIS Database Administrator (NC) | 2 | 1,880 | 3,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior GIS Integration Engineer (NC) | 4 | 1,880 | 7,520 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior Imagery Analyst (NC) | 35 | 2,115 | 74,025 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Three dimensional (3D) Physical Modeler (NC) | 1 | 1,880 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Subtotal | 191 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Total CONUS and OCONUS | 226 |
3-CLIN 2 - OCONUS
| IAW Table 3.1 of SOW | ||||||||||||||
| Working | Total Annual | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
| Labor Category - OCONUS | FTE | Hours | Hours | FFP Hourly Rate | FFP Hourly Rate | FFP Hourly Rate | FFP Hourly Rate | FFP Hourly Rate | Total FFP | Total FFP | Total FFP | Total FFP | Total FFP | TOTAL |
| Geospatial Intelligence Analyst | 8 | 4745 | 37960 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Geospatial Systems Specialist | 3 | 4745 | 14235 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Geospatial Systems Integrator | 0 | 4745 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Geospatial-Imagery Fusion Analyst | 0 | 4745 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Hyperspectral Imagery Scientist | 0 | 4745 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Hypespectral Analyst | 0 | 4745 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Imagery Analyst | 17 | 4745 | 80665 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Project Manager/Deputy Project Manager | 0 | 4745 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior Geospatial Systems Specialist | 0 | 4745 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior GIS Administrator | 1 | 4745 | 4745 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior GIS Database Administrator | 0 | 4745 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior GIS Integration Engineer | 1 | 4745 | 4745 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior Imagery Analyst | 5 | 4745 | 23725 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Three dimensional (3D) Physical Modeler | 0 | 4745 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subtotal | 35 | 166075 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
4-Hourly Rates
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||
| Labor Category | Contractor's Labor Category | CLIN | Location | FFP Hrly Rate | FFP Hrly Rate | FFP Hrly Rate | FFP Hrly Rate | FFP Hrly Rate |
| Geospatial Intelligence Analyst (NC) | 0001 | CONUS |
| Geospatial Systems Specialist (NC) | 0001 | CONUS |
| Geospatial Systems Integrator (NVA) | 0001 | CONUS |
| Geospatial-Imagery Fusion Analyst (NVA) | 0001 | CONUS |
| Hyperspectral Imagery Scientist (NVA) | 0001 | CONUS |
| Hypespectral Analyst (NVA) | 0001 | CONUS |
| Imagery Analyst (Dam Neck VA) | 0001 | CONUS |
| Imagery Analyst (NC) | 0001 | CONUS |
| Project Manager/Deputy Project Manager (NC) | 0001 | CONUS |
| Senior Geospatial Systems Specialist (NC) | 0001 | CONUS |
| Senior GIS Administrator (NC) | 0001 | CONUS |
| Senior GIS Database Administrator (NC) | 0001 | CONUS |
| Senior GIS Integration Engineer (NC) | 0001 | CONUS |
| Senior Imagery Analyst (NC) | 0001 | CONUS |
| Three dimensional (3D) Physical Modeler (NC) | 0001 | CONUS |
| Geospatial Intelligence Analyst | 0002 | OCONUS |
| Geospatial Systems Specialist | 0002 | OCONUS |
| Geospatial Systems Integrator | 0002 | OCONUS |
| Geospatial-Imagery Fusion Analyst | 0002 | OCONUS |
| Hyperspectral Imagery Scientist | 0002 | OCONUS |
| Hypespectral Analyst | 0002 | OCONUS |
| Imagery Analyst | 0002 | OCONUS |
| Project Manager/Deputy Project Manager | 0002 | OCONUS |
| Senior Geospatial Systems Specialist | 0002 | OCONUS |
| Senior GIS Administrator | 0002 | OCONUS |
| Senior GIS Database Administrator | 0002 | OCONUS |
| Senior GIS Integration Engineer | 0002 | OCONUS |
| Senior Imagery Analyst | 0002 | OCONUS |
| Three dimensional (3D) Physical Modeler | 0002 | OCONUS |
5-CLIN 3 - Travel
| CLIN - 4 Travel |
| No fee |
Travel Year 1 Year 2 Year 3 Year 4 Year 5 TOTAL
Gov't Estimated Direct Travel Costs $ 500,000.00 $ 500,000.00 $ 500,000.00 $ 500,000.00 $ 500,000.00 $ 2,500,000.00
| Indirect Rates:* |
| Handling % |
| G&A % |
Total Estimated Travel $ 500,000.00 $ 500,000.00 $ 500,000.00 $ 500,000.00 $ 500,000.00 $ 2,500,000.00
* Support for all indirect rates need to be provided
Spreadsheet assumes a Total Cost Input (TCI) base for the application of G&A. If Offeror's rate structure utlizes other than a TCI base for G&A, formula for Total Estimated Travel will require adjusment by the Offeror.
6-CLIN 4- ODC
CLIN 5 - Other Direct Costs
Other Direct Costs (ODC) Year 1 Year 2 Year 3 Year 4 Year 5 TOTAL
| Defense Base Act Insurance | $ - 0 | |||||
| Visa | $ - 0 | |||||
| Training | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 500,000.00 |
| $ - 0 | ||||||
| $ - 0 | ||||||
| $ - 0 | ||||||
| $ - 0 |
Total Proposed ODC $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 500,000.00
| Indirect Rates:* |
| Handling % |
| G&A % |
Total Estimated ODC $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 500,000.00
* Support for all indirect rates need to be provided
Spreadsheet assumes a Total Cost Input (TCI) base for the application of G&A. If Offeror's rate structure utlizes other than a TCI base for G&A, formula for ODC will require adjusment by the Offeror.
File details come from the government source that posted it.