Attachment 06 - Detention-Transportation Template_2026AUG.xlsx
XLSX spreadsheet 296 KB Posted
- Attached to
- Turn-key Detention Facilities
- Solicitation number
- 70CDCR26R00000026
- Issued by
-
Immigration and Customs Enforcement
About this file
This is a detention and transportation pricing template in Excel format for the Turn-key Detention Facilities RFP (Solicitation No. 70CDCR26R00000026) issued by the Department of Homeland Security's Immigration and Customs Enforcement (ICE), Office of Acquisition Management, Detention Compliance and Removals.
The template is designed for offerors to submit pricing for detention facility operations and transportation services across four separate requirements: Denver Area of Responsibility, Miami Area of Responsibility, Philadelphia Area of Responsibility, and Seattle Area of Responsibility. The anticipated contract vehicles are hybrid Firm-Fixed-Price and Labor-Hour Indefinite Delivery/Indefinite Quantity (IDIQ) contracts, each with a 120-month ordering period inclusive of a 60-day transition period and potential six-month extension options. Contractors will be required to provide comprehensive turnkey detention facility services including secure custody, care, supervision, and safekeeping of ICE detainees operating 24 hours per day, 7 days per week, 365 days per year. Requirements A, B, and C are for Non-IHSC-staffed facilities, while Requirement D is for an IHSC-staffed facility. The Government anticipates making separate single-award contracts for each requirement, with evaluation and awards conducted individually.
View the file
Other files
Show all 42
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
Instructions
| Detention-Transportation Template | ||
| Instructions: Vendors billing ICE for bed space and/or transportation will populate the Detention-Transportation Template and send the populated template to CORs and the ERO RPA Team (ERORPA@ice.dhs.gov). The corresponding Quick Reference Guide (QRG) provides additional instructions on template population. Please find the terms used in this sheet defined below. | ||
| Tab | Field | Definition |
| Summary | AOR | The Area of Responsibility field indicates which of the 25 field offices has geographical jurisdiction over this detention facility or transportation vendor |
| Summary | Detention Facility or Transportation Vendor | The name of the detention facility or transportation vendor |
| Summary | Prime Contractor | The name of the prime contractor |
| Summary | Street Address | The address of the detention facility or transportation vendor |
| Summary | City/State/Zip | The City, State, and Zip Code the detention facility or transportation vendor is in |
| Summary | Detention Location Code | A specific code for your detention location. If transportation only, enter vendor name (also referred to as "DETLOC") |
| Summary | Point of Contact | The point of contact for the invoice |
| Summary | E-mail Address | The above POC’s e-mail address |
| Summary | Contract Number | The contract number associated with the detention facility or transportation vendor |
| Summary | UEI | Unique Entity Identifier number |
| Summary | TIN | Tax ID Number |
| Summary | COR | The contracting officer representative associated with the detention facility or transportation vendor |
| Summary | COR Email Address | The email address for the contracting officer representative associated with the detention facility |
| Summary | ACOR | The alternate contracting officer representative associated with the detention facility or transportation vendor |
| Summary | Invoice Start | The beginning date of the period for which you are invoicing |
| Summary | Invoice End | The ending date of the period for which you are invoicing |
| Summary | Date Range | The amount of days within the invoice period (i.e. 09/01/2019-09/30/2019 = 30) |
| Summary | Invoice Number | The number identifying this specific invoice |
| Summary | Invoice Date | The date of submission of the invoice |
| Summary | Bed Space Guaranteed Minimum Table | If applicable to the contract, fill out the Contract Line Item Number, Bed Days, and Rate that was guaranteed |
| Summary | Bed Space Rate Breakdown Table | For all non-guaranteed bed space use, fill out the Contract Line Item Number, Bed Days, and Rate, and Cost by pricing tier (if tiered pricing is applicable) |
| Summary | Transportation Table | This table summarizes information from the (1) Detainees Transported, (2) Missions and (3) Additional Mission Expenses tabs to identify a Total Transportation Cost |
(a) Total Regular and Overtime Office Cost (auto-calculated)
(b) Cost Per Mile for Bus and Sedan/SUV/Van
(c) Current Billing Period Total Miles - Indicating the total miles being billed on the Missions tab
(d) Total Mileage Cost - The total miles being billed multiplied times the applicable rates
(e) Guaranteed Minimum Cost
(f) Indicate if contract calculates Guaranteed Minimum miles on an annual basis
(g) If yes, enter the Total Miles previously billed within the current agreement POP
(h) Total Additional Mission Expenses (auto-calculated)
(i) Fixed Fee (if applicable)
(j) Total Transportation Cost (auto-calculated)
| Summary | Other Monthly Expenses Table | If applicable to the contract, fill in any field to include additional expenses that may have been part of the mission and should be accounted for in the invoice total |
| Summary | Notes | Fill out any notes you would like to include in this text box |
| Bed Space | First Name | Detainee First Name |
| Bed Space | Last Name | Detainee Last Name |
| Bed Space | Alien # | The individual alien identification number |
| Bed Space | Book In Date | The date the specific detainee was booked into the detention facility |
| Bed Space | Book Out Date | The date the specific detainee was booked out of the detention facility, if applicable. Leave blank if detainee remains at the facility |
| Bed Space | Total Man Days | The amount of billed days for each detainee during the invoice date range |
| Daily Man Day Count | Confirmation | If applicable to the contract, select "Yes" from the drop down menu in order to complete the Daily Man Day Count tab |
| Daily Man Day Count | Day of Month | The individual day within a month |
| Daily Man Day Count | Total Count | The total number of bed days being billed by day |
| Daily Man Day Count | Guaranteed Minimum | The total number of bed days that are guaranteed on a daily basis |
| Daily Man Day Count | Tier | The total number of bed days being billed at that tier |
| Daily Man Day Count | Match Status | The match status table compares the total man days on the Bed Space tab to the total man days on the Daily Man Day Count tab to determine a match |
| Detainees Transported | First Name | Detainee First Name |
| Detainees Transported | Last Name | Detainee Last Name |
| Detainees Transported | Alien # | The individual alien identification number |
| Detainees Transported | Mission # | The number identifying each mission in its entirety. Mission Types and nomenclature listed below: |
Trips with Detainees: For example, if 10 detainees are transported from A to B with 3 stops for detainee pickups there should be one unique mission number. This alphanumeric number should consist of [Detention Location] + [Calendar Year] + [5 Digit Sequential Counter that resets annually]. Example: DETLOC202000001 Travel Trip: TRAVEL + [5 Digit Sequential Counter that resets annually] Stationary Guard: STATIONARYGD + Calendar Year + MMDD. Example: STATIONARYGD20200101 Mail Run: MAIL + [5 Digit Sequential Counter that resets annually] MAIL00001 Dispatcher: DISPATCHERYEARMMDD Transportation Manager: TRANSMGRYEARMMDD Administrative Cost: ADMIN + [5 Digit Sequential Counter that resets annually] For example: ADMIN00001 Missions Mission # The number identifying each mission in its entirety. Mission Types and nomenclature listed below:
Trips with Detainees: For example, if 10 detainees are transported from A to B with 3 stops for detainee pickups there should be one unique mission number. This alphanumeric number should consist of [Detention Location] + [Calendar Year] + [5 Digit Sequential Counter that resets annually]. Example: DETLOC202000001 Travel Trip: TRAVEL + [5 Digit Sequential Counter that resets annually] Stationary Guard: STATIONARYGD + Calendar Year + MMDD. Example: STATIONARYGD20200101 Mail Run: MAIL + [5 Digit Sequential Counter that resets annually] MAIL00001 Dispatcher: DISPATCHERYEARMMDD Transportation Manager: TRANSMGRYEARMMDD Administrative Cost: ADMIN + [5 Digit Sequential Counter that resets annually] For example: ADMIN00001
| Missions | CLIN | The contract line item number associated with the cost; list all CLINS applicable to that mission separated by a comma; i.e. 001,002 |
| Missions | Sub-Office | The Sub-Office that contracted the mission |
| Missions | Mission Date | The date the mission occurred |
| Missions | Officer Billable Regular Hours | The amount of regular Officer billable hours used |
| Missions | Officer Regular Rate | The rate assigned per the contract for Officer Billable Regular Hours |
| Missions | Officer Billable Overtime Hours | The amount of overtime Officer billable hours used |
| Missions | Officer Overtime Rate | The rate assigned per the contract for Officer Billable Overtime Hours |
| Missions | Start Odometer | The starting number of miles on the odometer |
| Missions | End Odometer | The ending number of miles on the odometer |
| Missions | Total Miles | The total amount of miles of the mission |
| Missions | Vehicle Number | The number identifying the vehicle used |
| Missions | Vehicle Owner | Answer “ICE” to indicate whether a government vehicle was used for this mission or "Contractor" for any other vehicle used. If an ICE vehicle is used, the mileage is still required to be populated, but will not be included in the calculation of cost |
| Missions | Vehicle Type | The type of vehicle used for the mission; options are bus, car, van, and sedan |
| Missions | Provider | The name of the company that provided the movement (subcontractor, prime contractor, or ICE if applicable). |
| Missions | Movement Type | Air Removal - Ground transportation of aliens to an airport for final removal via air |
Air Transfer - Transporting aliens in custody to or from an airport for domestic transfers Land Removal - Ground transportation of aliens to their country of origin for final removal (e.g., busing or walking aliens into Mexico) Legal - Transporting of aliens for legal appointments (i.e. court, lawyer or consulate visits) Medical - Transporting detainees to a hospital or clinic for medical reasons Ambulatory - Chasing an ambulance Pick Up - Apprehension of an alien from a non-ICE location. (e.g., pick up from jail / prison) Release - Transporting aliens that have been released from custody to a U.S. domestic location (i.e. bus terminal) Transfer - Transporting detainees in ICE custody from one facility to another Stationary Duty - Time spent performing detention related guard duties (e.g. front gate guard duty, facility patrols, interview escorts, detainee in/out processing, and other guard duties including remote post duties such as in-patient medical stays) Other - Transportation for a reason other than moving aliens (e.g. vehicle maintenance, file transfers)
| Missions | Contract Officers | Number of contract staff participating in the mission’s transportation team |
| Missions | ICE Officers | Number of ICE employees participating in the mission’s transportation team |
| Missions | Male | Number of adult males transported |
| Missions | Female | Number of adult females transported |
| Missions | Juvenile | Number of juvenile aliens transported |
| Missions | Family Unit | Yes/No if a family unit was transported |
| Missions | Start Location | Location where the trip began |
| Missions | Start Departure Time | The time (HH:MM) when the vehicle left the start location |
| Missions | Start Pick Up | The number of aliens in the vehicle at the time of departure |
| Missions | Stop 1-10 Location | Location where the stop occurred |
| Missions | Stop 1-10 Odometer | Odometer reading from the vehicle after arriving at the stop location |
| Missions | Stop 1-10 Arrival Time | The time (HH:MM) when the vehicle arrived at the stop location |
| Missions | Stop 1-10 Departure Time | The time (HH:MM) when the vehicle left the stop location |
| Missions | Stop 1-10 Pick Up | The number of aliens that were picked up at the stop location |
| Missions | Stop 1-10 Drop Off | The number of aliens that were dropped off at the stop location |
| Missions | End Location | Location where the trip ended |
| Missions | End Time | The time (HH:MM) when the vehicle arrived at the end location |
| Missions | End Drop Off | The number of aliens dropped off at the time of arrival at the end location |
| Missions | Comments | Any comments regarding the trip that are relevant to the invoice or trip details |
| Additional Expenses | Mission # | The number identifying each mission in its entirety. Mission Types and nomenclature listed below: |
Trips with Detainees: For example, if 10 detainees are transported from A to B with 3 stops for detainee pickups there should be one unique mission number. This alphanumeric number should consist of [Detention Location] + [Calendar Year] + [5 Digit Sequential Counter that resets annually]. Example: DETLOC202000001 Travel Trip: TRAVEL + [5 Digit Sequential Counter that resets annually] Stationary Guard: STATIONARYGD + Calendar Year + MMDD. Example: STATIONARYGD20200101 Mail Run: MAIL + [5 Digit Sequential Counter that resets annually] MAIL00001 Dispatcher: DISPATCHERYEARMMDD Transportation Manager: TRANSMGRYEARMMDD Administrative Cost: ADMIN + [5 Digit Sequential Counter that resets annually] For example: ADMIN00001
| Additional Expenses | County | The county in which the hotel expenses occurred |
| Additional Expenses | State (dropdown) | The state in which the hotel expenses occurred |
| Additional Expenses | Toll Expense | Tolls incurred on the mission |
| Additional Expenses | Hotel Expense | Hotel charges incurred on the mission |
| Additional Expenses | M&IE | Meals and Incidental Expenses incurred on the mission |
| Additional Expenses | Price Per Gallon | The cost of each gallon purchased |
| Additional Expenses | # of Gallons | The amount of fuel consumed on the mission |
| Additional Expenses | First/Last Day of Travel (Y or N) | Indicate with a Y or N if this is the first or last travel day to appropriately calculate GSA rate |
| Additional Expenses | Hotel Taxes | Only if a state does not allow the tax-exempt file, enter the amount of the hotel allocated to taxes |
| Other Monthly Expenses | Expense Type | If applicable to the contract enter the expense type within the appropriate section of the table. Please notes for any additional expenses not listed you have the option to add them into the "Other Miscellaneous Expenses" section |
| Other Monthly Expenses | CLIN | The contract line item number associated with the cost; list all CLINS applicable to that mission separated by a comma; i.e. 001,002 |
| Other Monthly Expenses | Description | Provide any additional information to clarify the expense type |
| Other Monthly Expenses | Cost Per Item | The amount encountered for the expense |
Summary Detention-Transportation Template Version: 04.09.2025
Summary Report
| Vendor Reference Information | Invoice Information | |
| AOR: | Invoice Start: | |
| Detention Facility or Transportation Vendor: | Invoice End: | |
| Prime Contractor: | Date Range: | 1 |
| Street Address: | Invoice Number: | |
| City/State/Zip: | Invoice Date: | |
| Detention Location Code: | ||
| Point of Contact: | ||
| E-mail Address: | ||
| Contract Number/Task Order #: | ||
| UEI: | ||
| TIN: | ||
| COR: | ||
| COR Email Address: | ||
| ACOR: |
| Detention | Transportation | ||||
| Detention Rate Breakdown | Man Days | Rate | Cost | Total Regular Officer Cost: | $ - 0 |
| Fixed Fee (if applicable): | Total Overtime Officer Cost: | $ - 0 | |||
| Guaranteed Minimum: | $ - 0 | Cost Per Mile (Bus): | N/A |
Sweeney, Laura (CTR): Enter N/A if not allowable per your contract Tier 1: $ - 0 Cost Per Mile (Sedan/SUV/Van): N/A Sweeney, Laura (CTR): Enter N/A if not allowable per your contract
| Tier 2: | $ - 0 | Current Billing Period Total Miles: | ||
| Tier 3: | $ - 0 | Total Mileage Cost: | $ - 0 | |
| Tier 4: | $ - 0 | Guaranteed Minimum Cost: | $ - 0 | |
| Tier 5: | $ - 0 | Does contract calculate GM miles annually? | No | |
| Total Bed Space Cost | 0 | $ - 0 | *Total Miles previously billed in current agreement: |
Sweeney, Laura (CTR): If cell is green, please populate miles Total Additional Mission Expenses: $ - 0 Sweeney, Laura (CTR): This includes anything from Additional Mission Expenses tab: Fuel, M&IE, Hotels
| Fixed Fee: | $ - 0 |
| Total Transportation Cost: | $ - 0 |
| *Only applies to contracts with Annual Mileage Requirements; Amount should include total miles previously billed within the current Period of Performance |
| Other Monthly Expenses | Notes | |
| Detainee Work Program | $ - 0 |
Sweeney, Laura (CTR): Enter N/A or leave blank if not allowable per your contract Sack Lunches $ - 0 Sweeney, Laura (CTR): Enter N/A or leave blank if not allowable per your contract Language Services $ - 0 Sweeney, Laura (CTR): Enter N/A or leave blank if not allowable per your contract Standard Phone Call Minutes $ - 0 Sweeney, Laura (CTR): Enter N/A or leave blank if not allowable per your contract Rental Space or Renovation Costs $ - 0 Sweeney, Laura (CTR): Enter N/A or leave blank if not allowable per your contract Detainee Mail Services $ - 0 Sweeney, Laura (CTR): Enter N/A or leave blank if not allowable per your contract Detainee Clothing Costs $ - 0 Sweeney, Laura (CTR): Enter N/A or leave blank if not allowable per your contract COVID-19 Costs $ - 0 Sweeney, Laura (CTR): Enter N/A or leave blank if not allowable per your contract Other Miscellaneous Expenses $ - 0 Sweeney, Laura (CTR): Enter N/A or leave blank if not allowable per your contract
| Sweeney, Laura (CTR): Enter N/A if not allowable per your contract | Other Monthly Expenses Total: | $0.00 | ||
| Invoice Total | $0.00 |
Bed Space First Name Last Name Alien # Book In Date Book Out Date Total Man Days
Daily Man Day Count This table MUST be completed if the facility's contract stipulates daily counts for bed days.
If your facility's contract does not specify a daily rate, DO NOT populate this table.
In order to complete the Daily Man Day Count table below, please select YES from the drop down to confirm. No TRUE No
Day of Month Total Count Guaranteed Minimum Tier 1 Tier 2 Tier 3 Tier 4 Tier 5 Match Status Match Sweeney, Laura (CTR): If your contract does not require daily counts, you can disregard this status
| 1 | Bed Space Tab | 0 | |||||||
| 2 | Daily Man Day Count Tab | 0 | |||||||
| 3 | |||||||||
| 4 | |||||||||
| 5 | |||||||||
| 6 | |||||||||
| 7 | |||||||||
| 8 | |||||||||
| 9 | |||||||||
| 10 | |||||||||
| 11 | |||||||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 | |||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 | |||||||||
| 21 | |||||||||
| 22 | |||||||||
| 23 | |||||||||
| 24 | |||||||||
| 25 | |||||||||
| 26 | |||||||||
| 27 | |||||||||
| 28 | |||||||||
| 29 | |||||||||
| 30 | |||||||||
| 31 | |||||||||
| Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Detainees Transported First Name Last Name Alien # Mission #
Missions
| Use start and end fields for starting and end location information. Stops should only be used for stops made between the starting and end location. | |||||||||||||||||||||||||||||||||||||||||||||||||
| Supporting Documentation | Movement | Total Aliens Moved | Start | Stop 1 | Stop 1 | Stop 2 | Stop 2 | Stop 3 | Stop 3 | Stop 4 | Stop 4 | Stop 5 | |||||||||||||||||||||||||||||||||||||
| Mission # | CLIN | Sub-Office | Mission Date | Officer Billable Regular Hours | Officer Regular Rate | Officer Billable Overtime Hours | Officer Overtime Rate | Start Odometer | End Odometer | Total Miles | Vehicle Number | Vehicle Owner | Vehicle Type | Provider | Movement Type | Contract Officers | ICE Officers | Male | Female | Juvenile | Family Unit | Start Location | Start Departure Time | Start Pick Up | Stop 1 Location | Stop 1 Odometer | Stop 1 Arrival Time | Stop 1 Departure Time | Stop 1 Pick Up | Stop 1 Drop Off | Stop 2 Location | Stop 2 Odometer | Stop 2 Arrival Time | Stop 2 Departure Time | Stop 2 Pick Up | Stop 2 Drop Off | Stop 3 Location | Stop 3 Odometer | Stop 3 Arrival Time | Stop 3 Departure Time | Stop 3 Pick Up | Stop 3 Drop Off | Stop 4 Location | Stop 4 Odometer | Stop 4 Arrival Time | Stop 4 Departure Time | Stop 4 Pick Up | Stop 4 Drop Off | Stop 5 Location |
Additional Mission Expenses
| Optional | |||||||||
| Mission # | Destination | State | Toll Expense | Hotel Expense | M&IE | Price Per Gallon | # of Gallons | First/Last Day of Travel (Y or N) | Hotel Taxes |
Other Monthly Expenses Capture any other monthly expenses associated with the invoice submitted to ICE. If the expense is not captured below, add expense and description to table below, "Other Miscellaneous Expenses".
| Expense Type | CLIN | ||||
| Sweeney, Laura (CTR): Enter CLIN as applicable | Description | Cost Per Item | Total | ||
| Detainee Work Program | CLIN | Number of Days Worked | Cost | Total | |
| $ 1.00 | $ - 0 |
| Sack Lunches | CLIN | Number of Sack Lunches | Cost | Total |
| $ - 0 |
| Language Services | CLIN | Number of Detainees Provided Service | Cost | Total |
| $ - 0 |
| Standard Phone Call Minutes | CLIN | Minutes | Cost | Total |
| $ - 0 |
| Rental Space or Renovation Costs | CLIN | Description | Total |
| Detainee Mail Services | CLIN | Number of Packages | Total |
Detainee Clothing Costs CLIN Units/Description Total
| COVID-19 Costs | CLIN | Units/Description | Total |
| COVID PPE | |||
| COVID Phone (500 minutes) | |||
| (Other COVID Cost) | |||
| Total COVID-19 Costs | $ - 0 |
| Other Miscellaneous Expenses | CLIN | Units/Description | Cost | Total |
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| Other Miscellaneous Expenses Total | $ - 0 |
Data Validation
| AOR | Vehicle Type | Vehicle Owner | Annual Miles | First/Last Day | States | Movement Type | DTT Type |
| ATL | Bus | Contractor | Yes | Y | AL | Transfer | |
| BAL | Van | ICE | No | N | AK | Legal | |
| BOS | SUV | AZ | Medical | ||||
| BUF | Sedan | AR | Ambulatory | ||||
| CHI | CA | Air Transfer | |||||
| DAL | CO | Air Removal | |||||
| DEN | CT | Land Removal | |||||
| DET | DE | Pick Up | |||||
| ELP | FL | Release | |||||
| HLG | GA | Stationary Duty | |||||
| HOU | HI | Other | |||||
| HRL | ID | ||||||
| LOS | IL | ||||||
| MIA | IN | ||||||
| NEW | IA | ||||||
| NOL | KS | ||||||
| NYC | KY | ||||||
| PHI | LA | ||||||
| PHO | ME | ||||||
| SEA | MD | ||||||
| SFR | MA | ||||||
| SLC | MI | ||||||
| SNA | MN | ||||||
| SND | MS | ||||||
| SPM | MO | ||||||
| WAS | MT | ||||||
| NE | |||||||
| NV | |||||||
| NH | |||||||
| NJ | |||||||
| NM | |||||||
| NY | |||||||
| NC | |||||||
| ND | |||||||
| OH | |||||||
| OK | |||||||
| OR | |||||||
| PA | |||||||
| RI | |||||||
| SC | |||||||
| SD | |||||||
| TN | |||||||
| TX | |||||||
| UT | |||||||
| VT | |||||||
| VA | |||||||
| WA | |||||||
| WV | |||||||
| WI | |||||||
| WY |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .