Attachment 14a DSCS __ 20JAN2026 (v. 4.2)_Example.xlsx

XLSX spreadsheet 156 KB Posted

Attached to
Turn-key Detention Facilities
Solicitation number
70CDCR26R00000026
Issued by

About this file

This is a Detention Services Cost Statement (DSCS) template and instruction document for U.S. Immigration and Customs Enforcement (ICE) detention facility pricing proposals. The document serves as a mandatory cost submission tool for contractors bidding on new ICE detention contracts or requesting housing rate modifications. The DSCS is an Excel-based workbook (version 4.2, dated January 20, 2026) designed to provide a standardized framework for presenting pricing information and enabling ICE Contracting Officers to make fair and reasonable rate determinations in accordance with Federal Acquisition Regulations (FAR) and the Service Contract Act.

The template contains multiple tabs addressing distinct cost categories: a cover page summarizing outputs and facility information; staffing schedules for ordering years 1-5 including employee listings and benefits; expenses broken into six sections covering facility costs, contract services, medical staff, depreciation, cost of money, and one-time charges; and transportation sections detailing officer rates, subcontracts, mileage, vehicle charges, and staffing. Only green-highlighted cells are editable by preparers; all other fields are locked. ICE requires extensive supporting documentation to accompany the cost statement, including detailed basis of estimate, bed day rate analysis, general ledger expense listings, comprehensive payroll records, depreciation schedules, contracted services agreements, other direct cost documentation, and G&A expense support or DCAA-audited rates. This cost submission template directly supports the Turn-key Detention Facilities RFP (Solicitation No. 70CDCR26R00000026) for multiple detention facility requirements across Denver, Miami, Philadelphia, and Seattle areas under anticipated hybrid Firm-Fixed-Price and Labor-Hour IDIQ contracts.

View the file

Other files

File Type Posted
Attachment 02 A0001 - Turnkey Facility PWS (IHSC) (Requirement D-Seattle) (1).pdf PDF
Attachment 01b A0001- Facility-Specific Requirements (Requirement B_ Miami).pdf PDF
70CDCR26R00000026 A0003.pdf PDF
Attachment 15 A0001 Turn-key pricing.xlsx XLSX spreadsheet
Attachment 10b A0001- Anticipated Transportation Routes Requirement B (Miami).xlsx XLSX spreadsheet
Attachment 04 A0001- Solicitation Question Template_Responses.xlsx XLSX spreadsheet
Attachment 01 A0001 - Turnkey Facility PWS (Non-IHSC)(Requirements A- Denver_ B -Miami and C- Philadelphia).pdf PDF
Attachment 01a A0001- Facility-Specific Requirements (Requirement A_ Denver).pdf PDF
70CDCR26R00000026 A0002.pdf PDF
Attachment 15 Turn-key pricing.xlsx XLSX spreadsheet
70CDCR26R00000026 A0001.pdf PDF
Attachment 02 A0001 - Turnkey Facility PWS (IHSC) (Requirement D-Seattle).pdf PDF
Attachment 01 A0001 - Turnkey Facility PWS (Non-IHSC) (Requirements A- Denver B -Miami and C- Philadelphia).pdf PDF
Attachment 10a - Anticipated Transportation Routes Requirement A (Denver).xlsx XLSX spreadsheet
Attachment 10b - Anticipated Transportation Routes Requirement B (Miami).xlsx XLSX spreadsheet
Attachment 04 - Solicitation Question Template.xlsx XLSX spreadsheet
Attachment 01 - Turnkey Facility PWS (Non-IHSC) (Requirements A- Denver B -Miami and C- Philadelphia).pdf PDF
Attachment 05 - PREA Regulations_2026AUG_.pdf PDF
Attachment 10 - Transportation Requirements_2026AUG.pdf PDF
Attachment 07 - Combating Trafficking in Persons_2026AUG.pdf PDF
Attachment 06 - Detention-Transportation Template_2026AUG.xlsx XLSX spreadsheet
Attachment 14 DSCS __ 20JAN2026 (v. 4.2).xlsx XLSX spreadsheet
Attachment 10c1 - Enhanced Transport Requirements Requirement C (Philadelphia).pdf PDF
Attachment 09 - Physical Plant Requirements_2026AUG.docx DOCX document
Attachment 01b - Facility-Specific Requirements (Requirement B Miami).pdf PDF
Attachment 01a - Facility-Specific Requirements (Requirement A Denver).pdf PDF
Attachment 02b - Stationary Guards (Requirement D- Seattle).pdf PDF
Attachment 03 - QASP_PRS_NDS 2026_2026AUG.pdf PDF
Attachment 14b DSCS Handbook 2025 (v. 4.2).pdf PDF
Attachment 10c - Anticipated Transportation Routes Estimate Requirement C (Philadelphia).pdf PDF
Attachment 10d - Anticipated Transportation Routes Requirement D (Seattle).pdf PDF
Attachment 01c - Facility-Specific Requirements (Requirement C Philadelphia).pdf PDF
Attachment 12 - Medical Services for Non-IHSC Facilities 2026_7.16.26.pdf PDF
Attachment 02a - Facility-Specific Requirements (Requirement D - Seattle).pdf PDF
Attachment 13 - Title 29 Labor Standards_2026AUG.pdf PDF
70CDCR26R00000026.pdf PDF
Attachment 02 - Turnkey Facility PWS (IHSC) (Requirement D-Seattle).pdf PDF
Attachment 08 - Privacy Rec Mgmt Safeguarding Info_2026AUG.pdf PDF
Attachment 03a - QASP_PRS_PBNDS_2026AUG.pdf PDF
Attachment 16 - Procedural Guidance for Complying with NEPA.pdf PDF
Attachment 03b - Contract Discrepancy Report Template_2026AUG.pdf PDF
Attachment 11 - Virtual Attorney Visitation_2026AUG.pdf PDF
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

Intro

ICE: Detention Services Cost Statement (DSCS)
This Detention Services Cost Statement is mandatory for all applicants requesting a new detention contract or housing rate modification to complete this document in its entirety. This Excel document contains various tab that contain schedules that will assist ICE’s Contracting Officers with their fair and reasonable determinations and negotiations. The document will also assist detention facilities in developing a complete and supportable proposal. Please complete the green cells, as needed.
PURPOSE
The purpose of this document is to provide a clear and consistent framework for providing pricing information for ICE detention facilities. Criteria used to evaluate fixed per diem rates based on actual and allowable costs will be in accordance with the Federal Acquisition Regulations ("FAR") for contracts with private vendors. We recommend that personnel completing this document are well trained to ensure compliance with the applicable portions of the FAR and the Service Contract Act.
SCHEDULES TO BE COMPLETED
Only the GREEN highlighted field can be modified by the preparers. All other fields have been locked, and the password will not be provided to the preparers. The following is a listing of tabs or schedules included in this document and a brief overview of each:

(1) Cover Page - This includes a summary of the outputs from the various cost categories that are covered on the back tabs, as well as the basic information about the facility in order to identify it. Preparer must complete the G&A, profit percentages, and proposed pricing(s) in this sheet.

(2) Staffing - There are two parts in this tab, Staffing (Part 1) and Benefits (Part 2). Part 2 allows for all Benefits to be entered, as needed.

(2.1) Staffing - Provide list of employees for Ordering Years 1 through 5. Complete the green cells, as needed.

(3) Expenses - There are six sections, Section 1 - Facility Costs / Other Direct Costs, Section 2 - Contract Services, Section 3 - Medical Staff (includes dental and mental health), Section 4 - Depreciation Expense, Section 5 - Cost of Money, and Section 6 - One-time Charges.

(4) Transportation - There are five sections, Section 1 - Calculation of Total Transportation Price and listing of Transportaion Officer's Hourly rate and Overtime, Section 2 - Transportation Subcontracts, Section 3 - Vehicle Mileage, Section 4 - Itemized Vehicle Charge, Section 5 - Staffing and Benefits.

Supporting Documentation

As part of the definitization process, U.S. Immigration and Customs Enforcement (ICE) requests the following information to assist in reaching a fair and equitable negotiation agreement, and to ensure proper documentation and compliance with agency requirements:
Basis of Estimate (BOE) - The Basis of Estimate must include a detailed written explanation supporting each proposed cost. This explanation should describe what the cost covers, how it was calculated, and the assumptions, data sources, or methodologies used in its development. To fully support the estimates, provide all relevant documentation, including vendor invoices, historical cost information, and any additional materials used to develop the cost proposal.
Bed Day Rates - Provide a full expense analysis explaining how the minimum bed day rates and any additional rates were calculated. Supporting information must include the methodology, cost breakdown, and any data sources used in the analysis to establish the reasonableness and accuracy of the proposed rates.
Expense Listing - Submit a general ledger listing of all expenses proposed for the prior year (if the facility was operational) and the first two months of the current letter contract. The expense listing must be detailed enough to allow the Government to reconcile the general ledger entries with the expenses included in the proposal. Each entry should clearly link to the corresponding item in the proposal for transparency and verification purposes. Include the average number of daily beds being occupied for the periods provided.
Staffing Expenses / Payroll Information - Provide a comprehensive payroll summary for all non-guard staff covering the entire prior year (if the facility was operational) and the first two months of the current letter contract. This summary must reconcile with the labor categories and costs proposed. Each payroll report should include the employee’s name, job title (as listed in the DSCS), pay period start and end dates, pay date, and hours worked, itemized by regular, overtime, holiday, and total hours worked. Ensure that you reconcile, or map, the payroll records to the labor categories proposed.
Depreciation Expenses - A complete depreciation schedule must be submitted, detailing each asset’s description, cost basis, useful life, salvage value, and depreciation method (e.g., straight-line). Also include the annual depreciation amount and the portion of depreciation allocated to this contract. Provide the company’s formal accounting policy on depreciation to support the methodology used.
Contracted Services / Leases - Provide all agreements related to contracted services and leases, including those for facilities, equipment, or external vendors. Each agreement should clearly state the terms, associated costs, and the effective start date.
Other Direct Costs - Submit documentation for any other direct costs proposed. This includes the agreement outlining the cost, terms, and start date, as well as a detailed cost analysis demonstrating how the proposed amount was determined. This includes historical cost information that was used in developing the estimates.
General and Administrative (G&A) Expenses - To support the proposed G&A rate, submit relevant financial documentation or provide DCAA-audited rates. The documentation must clearly demonstrate how the G&A rate was determined and ensure it aligns with standard accounting practices. In addition to providing a supporting budget for the proposed G&A rate, include the prior fiscal year actual incurred G&A rate with detailed pool and base costs.

(1) Cover Page

Cover Page InstructionsVersion (4.2) 20JAN2026
>>>>> Version 4.2 supersedes all previous cost sheets <<<<<Date Prepared
>>> Please note that all previous cost sheets are obsolete and will not be accepted for processing <<<
Complete the green cells with the facility's identifying information and population data below to include G&A, profit rates, and proposed pricings. All white cells calculate automatically from other sheets.
A. Identifying Information
Facility NameABC CompanyStep 1
Contractor's Name (Operator)Sigma CorporationStep 2
Total Facility Size (Square Feet)120,000Step 3
B. Capacity
Total Capacity1200Step 4
ADP (Last Twelve Months)740Step 5
Current Population824Step 6
C. Time Frame (Fiscal Year)10/1/2024 - 09/30/2025Step 7
D. Financial InformationCost% of Contract
Staffing$ 5,610,512.0071.1%
Facility$ 1,137,500.0014.4%
Other Direct Costs$ 189,461.002.4%
Total Operating Costs$ 6,937,473.0087.9%
Depreciation$ 108,750.001.4%
Contracted Services$ 681,750.008.6%
Total Non-Operating Costs$ 790,500.0010.0%

Subtotal: $ 7,727,973.00

G&A 1.00% $ 77,279.73 1.0% Step 8

Total Costs $ 7,805,252.73

Profit on Operating Costs1.00%$ 70,147.530.9%Step 9
Profit on Non-Operating Costs2.00%$ 15,810.000.2%Step 10
Total Profit Margin$ 85,957.53

TOTAL CONTRACT VALUE $ 7,891,210.26 100.0%

Bed-Day Rate at Total Capacity$ 18.02Sample Entries
Bed-Day Rate ADP (Last Twelve Months)$ 29.22
Bed-Day Rate at Current Population$ 26.24FOCAlpha FacilityGMBravo FacilityNon FOC/GMCharlie Facility
Proposed Ordering Period Rates/Prices for Facility Operation Charge (FOC)/Guaranteed Minimum (GM) Awards
Monthly FOC ►Step 111-600$3,200,000.00
FOC Per Bed Rate / GM Tier I Bed Rate ►1-600$10.001-750$125.00
Tier II ►601-750$65.00751-900$110.00
Tier III ►751-850$28.00901-1000$65.00
Proposed Ordering Period Rate(s)/Price(s) for FOC/GM
Ordering Period 1 ►Please refer to the "Sample Entries" table on the right1-600$3,264,000.001-750$127.50
Ordering Period 2 ►1-600$3,329,280.001-750$130.05
Ordering Period 3 ►1-600$3,395,865.601-750$132.65
Ordering Period 4 ►1-600$3,463,782.911-750$135.30
Proposed Base Year Rate(s)/Price(s) - Non FOC/GM Awards
Tier I ►1-400$90.00
Tier II ►401-500$48.00
Tier III ►501+$19.00
One-Time Cost (Not Included in Bed Rate)$ 72,000.00
Transportation Costs (If Applicable)$ 613,141.25

&G ICE/ERO Contract Detention Facility (CDF) Detention and Transportation Services in the Detroit AOR Attachment 12 – DSCS

Sheet2

Detention OfficePrime/Sub
Select a Category
YesPrime ContractorFacility1Professional
NoSub ContractorOther Direct Costs2Event
Contracted services3Fixed Posts
DepreciationTransportation
5
7

(2) Staffing

Staffing Section Overview
There are two parts in this tab, Staffing (Part 1) and Benefits (Part 2). Part 2 allows for all Benefits to be entered, as needed.
Staffing (Part 1)Benefits (Part 2)
Complete all "green" field in each row and use only rows needed.Enter Benefit values below. "RATES BELOW ARE PER LABOR HOUR."

Detention Officer?

PositionsSCA or CBA (If Applicable)Yes or NoPercent Allocated to ICE ContractStraight Labor RateFully Burdened Rate (FBR)# of FTEs RequiredBase Hours (Annual)Total HoursTotal (Labor Cost)Total (FBR Cost)Overtime Hours RequiredOvertime (OT) RateTotal Overtime (OT) CostProposed Salary Cost (FBR + OT)H&WRetirementSocial SecurityMedicareFUTASUTAWorker's CompOther Benefits1Other Benefits2Other Benefits3Total
WardenNo75.0%$ 85.00$ 85.001.002080.001,560.00$ 132,600.00$ 132,600.00$ - 0$ 132,600.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$ - 0
Senior AccountantNo50.0%$ 65.00$ 65.001.002080.001,040.00$ 67,600.00$ 67,600.00$ - 0$ 67,600.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$ - 0
Detention Officer ISCA12345Yes100.0%$ 30.00$ 44.9550.002080.00104,000.00$ 3,120,000.00$ 4,674,800.00$ - 0$ 4,674,800.00$5.00$2.00$1.50$0.75$1.00$1.25$1.45$2.00$0.00$0.00$ 14.95
CounselorNo100.0%$ 35.00$ 48.952.002080.004,160.00$ 145,600.00$ 203,632.00$ - 0$ 203,632.00$5.00$2.00$1.00$0.75$1.00$1.25$1.45$1.00$0.50$0.00$ 13.95
Detention Officer IIYes50.0%$ 32.00$ 47.4510.002080.0010,400.00$ 332,800.00$ 493,480.0080.00$ 48.00$ 38,400.00$ 531,880.00$5.50$2.00$1.50$0.75$1.00$1.25$1.45$2.00$0.00$0.00$ 15.45
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
Total64.00121,160.00$ 3,798,600.00$ 5,572,112.0080.00$ 38,400.00$ 5,610,512.00

(2.1) Staffing OY1_OY5

Staffing Section Overview
Provide list of all employee positions, labor rates and SCA or CBA information for Ordering Years 1 through 5. Complete the green cells, as needed.

Please note, do not include increases that are already covered by the SCA wage determination requests as they will continue to occur on an annual basis. Other positions that are non-SCA/CBA should be included in the inflation/escalation of each ordering year.

PositionsOrdering Year 1Ordering Year 2Ordering Year 3Ordering Year 4Ordering Year 5
Straight Labor RateFully Burdened Rate (FBR)# of FTEs RequiredDOL WD SCA or CBA NumberStraight Labor RateFully Burdened Rate (FBR)# of FTEs RequiredDOL WD SCA or CBA NumberStraight Labor RateFully Burdened Rate (FBR)# of FTEs RequiredDOL WD SCA or CBA NumberStraight Labor RateFully Burdened Rate (FBR)# of FTEs RequiredDOL WD SCA or CBA NumberStraight Labor RateFully Burdened Rate (FBR)# of FTEs RequiredDOL WD SCA or CBA Number
Detention Officer$ 22.00$ 34.0010.02015-5999$ 23.50$ 36.0010.02015-5999$ 25.00$ 37.5010.02015-5999$ 27.00$ 39.7510.02015-5999$ 30.00$ 44.0010.02015-5999

Total 10.0 10.0 10.0 10.0 10.0

(3) Expenses

Expense Section Overview
There are six sections, Section 1 - Facility Costs / Other Direct Costs, Section 2 - Contract Services, Section 3 - Medical Staff (includes dental and mental health), Section 4 - Depreciation Expense, Section 5 - Cost of Money, and Section 6 - One-time Charges. Complete the green cells, as needed.
Section 1 - Facility Costs / Other Direct Costs
Complete the green cells, as needed. Complete the expense title (column B), proposed cost (column C), enter the percentage of cost to be allocated to this contract (column D), actual prior year cost (column F), and provide an explanation for any large increases (columns H&I).
Expense TitleProposed Costs Total CostsPercent allocated to ICE ContractProposed Amount Allocated to ICE ContractActual Prior Year Costs% changeExplanation (Reason for large increase in cost)
Building Lease or Rent$ 400,000.0050.00%$ 200,000.00$ 380,000.005.3%
Utilities$ 750,000.0075.00%$ 562,500.00$ 650,000.0015.4%Increase in natual gas prices
Food and Kitchen Supplies$ 500,000.0075.00%$ 375,000.00$ 490,000.002.0%
Medical Supplies$ 4,200.00100.00%$ 4,200.00$ 4,000.005.0%
Office Supplies/Postage$ 84,672.00100.00%$ 84,672.00$ 82,000.003.3%
Communications$ 64,589.00100.00%$ 64,589.00$ 61,000.005.9%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
$ - 00.00%$ - 0$ - 00.0%
Total Facility Costs / Other Direct Costs:$ 1,803,461.00$ 1,290,961.00$ 1,667,000.00
Section 2 - Contract ServicesSection 3 - Medical Staff (includes Dental and Mental Health)
Complete the green cells, as needed. Provide the costs for consultant and contract services to the extent that they benefit federal prisoners. Complete the expense title (column B), proposed cost (column C), enter the percent of costs to be allocated to this contract (column D),actual prior year cost (column F), and provide an explanation for any large increases (column H&I). If there is a Transportation subcontract, enter that information on the "4. Transportation" tab. For Medical (including dental and mental health), Contractor must complete Section 3 - Medical Staff.Complete the green cells, as needed. List all medical, dental and mental health staff, the number of positions, and annual salaries. Complete the position title such as "Nurse 1", "LPN", "Dentist" (column K), position count (column L), and the annual salary (column M).
Expense TitleProposed Costs Total CostsPercent allocated to ICE ContractProposed Amount Allocated to ICE ContractActual Prior Year Costs% changeExplanation (Reason for large increase in cost)PositionPosition CountAnnual SalaryTotal
Medical (including dental and mental health)$ 660,000.0080.00%$ 528,000.00$ - 00.0%Nurse III2.00$ 80,000.00$ 160,000.00
Legal Services/Contract Review$ 120,000.00100.00%$ 120,000.00$ - 00.0%Nurse I8.00$ 58,000.00$ 464,000.00
IT Support$ 45,000.0075.00%$ 33,750.00$ - 00.0%Medical Clerk1.00$ 36,000.00$ 36,000.00
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
$ - 00.00%$ - 0$ - 00.0%$ - 0$ - 0
Total Contract Services$ 825,000.00$ 681,750.00$ - 0Total Medical Staff11.00$ 660,000.00
Section 4 - Depreciation Expense
Complete the green cells, as needed. Provide the original value, salvage value, and useful life for any buildings or large equipment that are not leased and for which depreciation is charged. The depreciation will calculate automatically using the straight-line method. The depreciation expense will be automatically calculated using the straight-line method. Complete the asset description (column B), acquisition year (column C), purchase price (column D), salvage value (column E) and life of asset (column F) and percentage of costs to be allocated to the ICE contract (column H).
Asset DescriptionAcquisition YearPurchase PriceSalvage ValueLife of AssetAnnual depreciationPercent allocated to ICE ContractProposed Amount Allocated to ICE Contract
Building2,010$ 8,000,000.00$ 3,500,000.0040.00$ 112,500.0050.00%$ 56,250.00
Improvements2,022$ 1,800,000.00$ 750,000.0010.00$ 105,000.0050.00%$ 52,500.00
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
$ - 0$ - 0- 0$ - 00.00%$ - 0
Total Depreciation:$ 9,800,000.00$ 4,250,000.00$ 217,500.00$ 108,750.00
Section 5 - Cost of Money
Enter the outstanding loans for depreciable buildings, equipment, or repairs listed above. Per FAR section 31.205-10, the vendor is eligible for reimbursement of the cost of money on the current book value (defined as the remaining book value after depreciation expenses from all prior years are subtracted) at the rate released quarterly by the Treasury Department. While this amount is intended to cover interest or "cost of money" on capital expenditures, profit may not be applied to this amount. Therefore, this line item is excluded in the profit calculations.
Asset DescriptionOriginal ValueAnnual Depreciation ExpenseYears DepreciatedCurrent Book ValueCost of MoneyAnnual Interest Payments
Land Improvements$ 1,800,000.00$ 105,000.0010$ 750,000.004.80%$ 36,000.00
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Total Cost of Money:$ 1,800,000.00$ 105,000.00$ 750,000.00$ 36,000.00
Section 6 - One-time Charges
Enter each item into the green cells below. These are the one-time charges that will not be incorporated into the Total Contract Value or the Daily Bed Rate. They will be captured as one total on the Cover page as a One-Time Cost. Complete the expense title (column B), proposed cost (column C), and detail description (columns D-F).
Expense TitleProposed CostsDetailed Description
IT Upgrade$ 72,000.00Total System Upgrade

Total One-time Charges: $ 72,000.00

(4) Transportation

Transportation Proposed Price $ 613,141.25

Transportation Section Overview
There are five sections, Section 1 - Calculation of Total Transportation Price and listing of Transportation Officer's Hourly rate and Overtime, Section 2 - Transportation Subcontracts, Section 3 - Vehicle Mileage, Section 4 - Itemized Vehicle Charge, Section 5 - Staffing and Benefits.
Section 1 - Calculation of Total Transportation Price
1. Please apply the same rate of G&A and Profit as proposed on "Cover Page" Tab.
2. Enter the Transportation Officer's Fully Burdened Rate and Overtime below.
3. The Fully Burdened Rate should match the value in Column G, cells 74 through 85 referencing to the Transportation Officer's rate ONLY.
Total Transportation CostsMarkup on CostsTotal Price
Base spend on transportation$ 595,167.20$ 17,974.05$ 613,141.25
G&A1.00%$ 5,951.67
Profit on Operating Costs2.00%$ 12,022.38
Transportation Officer (Fully Burdened Rate)$ 46.95
Transportation Officer (FBR) Overtime Rate$ 56.00
Section 2 - Transportation Subcontracts / Instructions
Complete the vendor name (column B), proposed cost (column C), prior year cost (column D).
Vendor NameProposed CostPrior YearDifference% Change
$ - 00.0%
$ - 00.0%
$ - 00.0%
$ - 00.0%
$ - 00.0%
Total Subcontracts$ - 0$ - 0$ - 0
Section 3 - Vehicle Mileage / Instructions
Complete the vehicle type (column B), number of vehicles (column C), mileage per year (column D), and rate per mile (column E).
Vehicle TypeNumber of VehiclesAnnual MileageRate per MileAnnual Cost
15 PAX Van2.0120,000.0$ 0.720$ 172,800.00
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Total2.0120,000.0$ 172,800.00
Section 4 - Itemized Vehicle Charge / Instructions
Complete the vehicle type (column B), brief description (column C), cost per vehicle (column D) and number of vehicles (column E).
Itemized ListBrief DescriptionAnnual Cost per VehicleNumber of VehiclesAnnual Cost
Vehicle Lease8 PAX Van$ 8,800.002$ 17,600.00
Vehicle repairs/maintenanceMaintenance$ 2,400.002$ 4,800.00
Vehicle insuranceComprehensive$ 6,000.002$ 12,000.00
Fuel costsGas$ 4,800.002$ 9,600.00
Vehicle Depreciation$ -0
$ -0
$ -0
$ -0
$ -0
$ -0
Total$ 44,000.00
Section 5 - Staffing (Part 1)Section 5 - Benefits (Part 2)
Complete all "green" field in each row and use only rows needed.Enter Benefit values below. "RATES BELOW ARE PER LABOR HOUR."

Transportation Officer?

PositionsSCA or CBA (If Applicable)Yes or NoPercent Allocated to ICE ContractStraight Labor RateFully Burdened Rate (FBR)# of FTEs RequiredBase Hours (Annual)Total HoursTotal (Labor Cost)Total (FBR Cost)Overtime Hours RequiredOvertime (OT) RateTotal Overtime (OT) CostProposed Salary Cost (FBR + OT)H&WRetirementSocial SecurityMedicareFUTASUTAWorker's CompOther Benefits1Other Benefits2Other Benefits3Total
Transportation ManagerYes50.0%$ 42.00$ 55.951.002080.001,040.00$ 43,680.00$ 58,188.00$ - 0$ 58,188.00$5.00$1.50$1.50$0.75$1.00$1.00$1.20$2.00$0.00$0.00$ 13.95
Transportation OfficerSCA12345Yes80.0%$ 32.00$ 46.954.002080.006,656.00$ 212,992.00$ 312,499.2040.00$ 48.00$ 7,680.00$ 320,179.20$5.00$2.00$1.50$0.75$1.00$1.25$1.45$2.00$0.00$0.00$ 14.95
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0
Total5.007,696.00$ 256,672.00$ 370,687.2040.00$ 7,680.00$ 378,367.20

&G ICE/ERO Contract Detention Facility (CDF) Detention and Transportation Services in the Detroit AOR Attachment 12 – DSCS

ICE Analysis

Identifying Information
Facility NameABC Company
Contractor's Name (Operator)Sigma Corporation
Total Facility Size (Square Feet)120,000
Capacity
Total Capacity1200
FY20XX ADP740
Current Population824
Time Frame (Fiscal Year)10/1/2024 - 09/30/2025
Financial Information
Ratio (Detainee per Detention Officer)13.7
Detention Officers FTEs60.00
Total (Labor Cost)$ 3,798,600
Total (Benefits)$ 1,773,512
Total (FBR Cost)$ 5,572,112
Overtime (OT) Hours80
Overtime (OT) Cost$ 38,400
Proposed Salary Cost (FBR + OT)5,610,512
Total FTEs64.00
Facility
Building Lease or Rent$ 200,0002.5%$ 1.67Per Square Foot
Utilities$ 562,5007.1%$ 4.69Per Square Foot
Food and Kitchen Supplies$ 375,0004.8%$ 1.25Per Detainee/Day
Other Facility Costs$ 189,4612.4%$ 0.63Per Detainee/Day
Total Facility Costs$ 1,326,961
Contract Services
Medical (Including Dental and Mental Health)$ 528,0006.7%$ 640.78Per Detainee/Year
Other Contract Service Costs$ 153,7501.9%$ 186.59Per Detainee/Year
Total Contract Services$ 681,750

TOTAL CONTRACT VALUE $ 7,891,210

Bed-Day Rate at Total Capacity$ 18.0
Bed-Day Rate ADP (Last Twelve Months)$ 29.2
Bed-Day Rate at Current Population$ 26.2
Proposed Ordering Period Rates/Prices for Facility Operation Charge (FOC)/Guaranteed Minimum (GM) Awards
Monthly FOC ►0$0.00
FOC Per Bed Rate / GM Tier I Bed Rate ►0$0.00
Tier II ►0$0.00
Tier III ►0$0.00
Proposed Ordering Period Rate(s)/Price(s) for FOC/GM
Ordering Period 1 ►0$0.00
Ordering Period 2 ►0$0.00
Ordering Period 3 ►0$0.00
Ordering Period 4 ►0$0.00
Proposed Base Year Rate(s)/Price(s) - Non FOC/GM Awards
Tier I ►0$0.00
Tier II ►0$0.00
Tier III ►0$0.00
Total Profit Margin1.1%
One-Time Cost (Not Included in Bed Rate)$ 72,000
Transportation Costs (if applicable)$ 613,141
Transportation Officers5.00
Total Annual Mileage120,000

image1.jpeg

File details come from the government source that posted it. Updated .