2.1.1-Attachment D Pricing Spreadsheet.xlsx
XLSX spreadsheet 36 KB Posted
- Attached to
- Private Office Space Rental/Workstations for ICE Personnel - Amendment 2 Federal contract opportunity
- Solicitation number
- 70CMSW26Q00000009
- Issued by
- Immigration and Customs Enforcement
About this file
This is a pricing spreadsheet template for a Request for Quote (RFQ) issued by the Department of Homeland Security, Immigration and Customs Enforcement (ICE), Office of Asset and Facilities Management. The solicitation number is 70CMSW26Q00000009, and the requirement is for private office space rental and workstations for ICE personnel across multiple locations nationwide.
The spreadsheet requires contractors to provide monthly pricing per full-time equivalent (FTE) for office space across 48 states, Puerto Rico, and various U.S. territories. The requirement includes 300+ personnel distributed across more than 100 specific cities, with FTE quantities ranging from 1 to 22 employees per location, with the largest concentrations in Houston, Texas (22 FTEs), San Diego, California (9 FTEs), and New York (9 FTEs). Contractors must fill in yellow-highlighted cells with monthly per-FTE rates; if unable to provide space at a listed location, the cell should remain blank with an explanation of alternative locations provided in notes. The pricing structure includes base monthly rates (organized by state CLIN numbers 0001-0043), a one-time activation fee (CLIN 0044), and any additional fees as separate CLINs (0045 and beyond). The spreadsheet calculates extended monthly prices, yearly prices, option periods, and an escalation percentage, culminating in a grand total. Contractors may also create sub-CLINs if pricing varies for different buildings or facilities within the same city, as demonstrated in the provided example for New Jersey locations.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 2.4.1-Amend 2 Attachment B Instructions to Offerors.pdf | ||
| 2.4.1-Amend 2 Office Space Q&A.pdf | ||
| 2.4.1-Amend 2 Attachment D Pricing Spreadsheet.xlsx | XLSX spreadsheet | |
| 2.4.1-Amend 2 70CMSW26Q00000009.pdf | ||
| 2.4.1-Amendment 1 Office Space Q&A.pdf | ||
| 2.1.1-70CMSW26Q00000009.pdf | ||
| 2.1.1-Attachment C Clauses.pdf | ||
| 2.1.1-Attachment B Instructions to Offerors.pdf | ||
| 2.1.1-Attachment A SOW.pdf | ||
| 2.1.1-Attachment E Prior Experience.pdf |
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
Instructions
| Instructions | |
| 1 | Fill in the monthly price for one FTE for each location in Column 'E' |
| 2 | If pricing is different for a group of FTEs within a single location (i.e., different building at different rates), create a new row underneath that location as a new subCLIN to list the different rate. See Example 1 for reference → |
| 3 | If your firm is unable to provide office space for a listed location, leave the price cell blank. If your firm is offering a location near an otherwise unavailable location, include a note about where the alternative location is in the area provided beneath the pricing table. |
| 4 | If there is a one time activation fee, list that in Column 'E' for CLIN 0044. If there is no activation fee, put '0' in Column 'E' for CLIN 0044. |
| 5 | If there are any additional fees, list them as subsequent CLINs (0045, 0046, etc.) and label what the fees are for. If there are no additional fees, list the price of CLIN 0045 as '0' |
| Example 1 | |||||||
| Old* | NJ | (New Jersey) | 0026 | ||||
| Mt. Laurel | 0026AA | 8 | $ 3.00 | $ 24.00 | $ 288.00 | ||
| Newark | 0026AB | 1 | $ 2.00 | $ 2.00 | $ 24.00 | ||
| New* | NJ | (New Jersey) | 0026 | ||||
| Mt. Laurel (Building 1) | 0026AA | 4 | $ 3.00 | $ 12.00 | $ 144.00 | ||
| Mt. Laurel (Building 2) | 0026AB | 3 | $ 4.00 | $ 12.00 | $ 144.00 | ||
| Mt. Laurel (Building 3) | 0026AC | 1 | $ 5.00 | $ 5.00 | $ 60.00 | ||
| Newark | 0026AD | 1 | $ 2.00 | $ 2.00 | $ 24.00 |
Pricing Spreadsheet
| Attachment D - Pricing Spreadsheet - RFQ 70CMSW26Q00000009 | |||||||
| Please ONLY fill in yellow cells | |||||||
| State | City | CLIN | Unit | FTE Price/Month | Extended Price/Month | Yearly Price | |
| AL | (Alabama) | 0001 | |||||
| Huntsville | 3 | $ - 0 | $ - 0 | ||||
| Montgomery | 2 | $ - 0 | $ - 0 | ||||
| AZ | (Arizona) | 0002 | |||||
| Casa Grande | 1 | $ - 0 | $ - 0 | ||||
| Chandler | 1 | $ - 0 | $ - 0 | ||||
| Concho | 1 | $ - 0 | $ - 0 | ||||
| Eloy | 1 | $ - 0 | $ - 0 | ||||
| Mesa | 1 | $ - 0 | $ - 0 | ||||
| Phoenix | 2 | $ - 0 | $ - 0 | ||||
| Scottsdale | 2 | $ - 0 | $ - 0 | ||||
| Tucson | 2 | $ - 0 | $ - 0 | ||||
| CA | (California) | 0003 | |||||
| Long Beach | 7 | $ - 0 | $ - 0 | ||||
| Morgan Hill | 3 | $ - 0 | $ - 0 | ||||
| Rocklin | 1 | $ - 0 | $ - 0 | ||||
| Sacramento | 4 | $ - 0 | $ - 0 | ||||
| San Bernadino | 4 | $ - 0 | $ - 0 | ||||
| San Diego | 9 | $ - 0 | $ - 0 | ||||
| San Francisco | 2 | $ - 0 | $ - 0 | ||||
| Santa Ana | 5 | $ - 0 | $ - 0 | ||||
| CO | (Colorado) | 0004 | |||||
| Colorado Springs | 12 | $ - 0 | $ - 0 | ||||
| CT | (Connecticut) | 0005 | |||||
| Hartford | 5 | $ - 0 | $ - 0 | ||||
| DE | (Delaware) | 0006 | |||||
| Wilmington | 1 | $ - 0 | $ - 0 | ||||
| FL | (Florida) | 0007 | |||||
| Bradenton | 1 | $ - 0 | $ - 0 | ||||
| Ft. Myers | 2 | $ - 0 | $ - 0 | ||||
| Gainesville | 3 | $ - 0 | $ - 0 | ||||
| Jacksonville | 4 | $ - 0 | $ - 0 | ||||
| Miami | 9 | $ - 0 | $ - 0 | ||||
| Niceville | 1 | $ - 0 | $ - 0 | ||||
| Orlando | 4 | $ - 0 | $ - 0 | ||||
| Sarasota | 1 | $ - 0 | $ - 0 | ||||
| Tampa | 5 | $ - 0 | $ - 0 | ||||
| West Palm Beach | 1 | $ - 0 | $ - 0 | ||||
| GA | (Georgia) | 0008 | |||||
| Atlanta | 10 | $ - 0 | $ - 0 | ||||
| East Point | 6 | $ - 0 | $ - 0 | ||||
| Leesburg | 1 | $ - 0 | $ - 0 | ||||
| HI | (Hawaii) | 0009 | |||||
| Honolulu | 1 | $ - 0 | $ - 0 | ||||
| IL | (Illinois) | 0010 | |||||
| Chicago | 2 | $ - 0 | $ - 0 | ||||
| Rock Island | 1 | $ - 0 | $ - 0 | ||||
| IN | (Indiana) | 0011 | |||||
| Indianapolis | 3 | $ - 0 | $ - 0 | ||||
| KS | (Kansas) | 0012 | |||||
| Kansas City | 1 | $ - 0 | $ - 0 | ||||
| Manhattan | 1 | $ - 0 | $ - 0 | ||||
| KY | (Kentucky) | 0013 | |||||
| Louisville | 3 | $ - 0 | $ - 0 | ||||
| LA | (Louisiana) | 0014 | |||||
| Baton Rouge | 4 | $ - 0 | $ - 0 | ||||
| MA | (Massachusetts) | 0015 | |||||
| Boston | 2 | $ - 0 | $ - 0 | ||||
| Burlington | 2 | $ - 0 | $ - 0 | ||||
| MD | (Maryland) | 0016 | |||||
| Baltimore | 11 | $ - 0 | $ - 0 | ||||
| Frederick | 3 | $ - 0 | $ - 0 | ||||
| ME | (Maine) | 0017 | |||||
| Caribou | 1 | $ - 0 | $ - 0 | ||||
| Portland | 2 | $ - 0 | $ - 0 | ||||
| Scarborough | 1 | $ - 0 | $ - 0 | ||||
| MI | (Michigan) | 0018 | |||||
| Grand Rapids | 3 | $ - 0 | $ - 0 | ||||
| MN | (Minnesota) | 0019 | |||||
| Fort Snelling | 1 | $ - 0 | $ - 0 | ||||
| MO | (Missouri) | 0020 | |||||
| Kansas City | 2 | $ - 0 | $ - 0 | ||||
| St. Louis | 4 | $ - 0 | $ - 0 | ||||
| MS | (Mississippi) | 0021 | |||||
| Gulfport | 2 | $ - 0 | $ - 0 | ||||
| Vicksburg | 1 | $ - 0 | $ - 0 | ||||
| MT | (Montana) | 0022 | |||||
| Savage | 1 | $ - 0 | $ - 0 | ||||
| NC | (North Carolina) | 0023 | |||||
| Cary | 9 | $ - 0 | $ - 0 | ||||
| Charlotte | 7 | $ - 0 | $ - 0 | ||||
| Raleigh | 2 | $ - 0 | $ - 0 | ||||
| NE | (Nebraska) | 0024 | |||||
| Omaha | 1 | $ - 0 | $ - 0 | ||||
| NH | (New Hampshire) | 0025 | |||||
| Manchester | 1 | $ - 0 | $ - 0 | ||||
| NJ | (New Jersey) | 0026 | |||||
| Mt. Laurel | 8 | $ - 0 | $ - 0 | ||||
| Newark | 1 | $ - 0 | $ - 0 | ||||
| NY | (New York) | 0027 | |||||
| New York | 9 | $ - 0 | $ - 0 | ||||
| OH | (Ohio) | 0028 | |||||
| Brooklyn Heights | 5 | $ - 0 | $ - 0 | ||||
| Westerville | 5 | $ - 0 | $ - 0 | ||||
| OR | (Oregon) | 0029 | |||||
| Portland | 2 | $ - 0 | $ - 0 | ||||
| Roseburg | 1 | $ - 0 | $ - 0 | ||||
| PA | (Pennsylvania) | 0030 | |||||
| Allentown | 7 | $ - 0 | $ - 0 | ||||
| Altoona | 3 | $ - 0 | $ - 0 | ||||
| PR | (Puerto Rico) | 0031 | |||||
| San Juan | 1 | $ - 0 | $ - 0 | ||||
| RI | (Rhode Island) | 0032 | |||||
| Crawford | 1 | $ - 0 | $ - 0 | ||||
| SC | (South Carolina) | 0033 | |||||
| Columbia | 6 | $ - 0 | $ - 0 | ||||
| Summerville | 3 | $ - 0 | $ - 0 | ||||
| SD | (South Dakota) | 0034 | |||||
| Hot Springs | 1 | $ - 0 | $ - 0 | ||||
| Mitchell | 1 | $ - 0 | $ - 0 | ||||
| TN | (Tennessee) | 0035 | |||||
| Knoxville | 4 | $ - 0 | $ - 0 | ||||
| Nashville | 3 | $ - 0 | $ - 0 | ||||
| TX | (Texas) | 0036 | |||||
| Austin | 6 | $ - 0 | $ - 0 | ||||
| Bryan | 9 | $ - 0 | $ - 0 | ||||
| El Paso | 2 | $ - 0 | $ - 0 | ||||
| Houston | 22 | $ - 0 | $ - 0 | ||||
| San Antonio | 10 | $ - 0 | $ - 0 | ||||
| UT | (Utah) | 0037 | |||||
| West Valley City | 3 | $ - 0 | $ - 0 | ||||
| VA | (Virginia) | 0038 | |||||
| Norfolk | 2 | $ - 0 | $ - 0 | ||||
| North Chesterfield | 9 | $ - 0 | $ - 0 | ||||
| VT | (Vermont) | 0039 | |||||
| Derby | 1 | $ - 0 | $ - 0 | ||||
| Williston | 5 | $ - 0 | $ - 0 | ||||
| WA | (Washington) | 0040 | |||||
| Seattle | 7 | $ - 0 | $ - 0 | ||||
| WI | (Wisconsin) | 0041 | |||||
| Maynes | 1 | $ - 0 | $ - 0 | ||||
| WV | (West Virginia) | 0042 | |||||
| Martinsburg | 1 | $ - 0 | |||||
| Milton | 1 | $ - 0 | $ - 0 | ||||
| WY | (Wyoming) | 0043 | |||||
| Casper | 1 | $ - 0 | $ - 0 | ||||
| Activation Fee (if applicable) | 0044 | 330 | $ - 0 | ||||
| Additional Fee (if applicable) | 0044 | 1 | $ - 0 | ||||
| Monthly Total → | $ - 0 | $ - 0 | Base Total | ||||
| Fill in Proposed Escalation (if applicable) | 0% | ||||||
| $ - 0 | Option Period 1 | ||||||
| $ - 0 | Option Period 2 | ||||||
| $ - 0 | 52.217-8 | ||||||
| $ - 0 | Grand total | ||||||
| Contractor Notes: |
State Totals
| State | Monthly Total | Yearly Total |
| AL | $ - 0 | $ - 0 |
| AZ | $ - 0 | $ - 0 |
| CA | $ - 0 | $ - 0 |
| CO | $ - 0 | $ - 0 |
| CT | $ - 0 | $ - 0 |
| DE | $ - 0 | $ - 0 |
| FL | $ - 0 | $ - 0 |
| GA | $ - 0 | $ - 0 |
| HI | $ - 0 | $ - 0 |
| IL | $ - 0 | $ - 0 |
| IN | $ - 0 | $ - 0 |
| KS | $ - 0 | $ - 0 |
| KY | $ - 0 | $ - 0 |
| LA | $ - 0 | $ - 0 |
| MA | $ - 0 | $ - 0 |
| MD | $ - 0 | $ - 0 |
| ME | $ - 0 | $ - 0 |
| MI | $ - 0 | $ - 0 |
| MN | $ - 0 | $ - 0 |
| MO | $ - 0 | $ - 0 |
| MS | $ - 0 | $ - 0 |
| MT | $ - 0 | $ - 0 |
| NC | $ - 0 | $ - 0 |
| NE | $ - 0 | $ - 0 |
| NH | $ - 0 | $ - 0 |
| NJ | $ - 0 | $ - 0 |
| NY | $ - 0 | $ - 0 |
| OH | $ - 0 | $ - 0 |
| OR | $ - 0 | $ - 0 |
| PA | $ - 0 | $ - 0 |
| PR | $ - 0 | $ - 0 |
| RI | $ - 0 | $ - 0 |
| SC | $ - 0 | $ - 0 |
| SD | $ - 0 | $ - 0 |
| TN | $ - 0 | $ - 0 |
| TX | $ - 0 | $ - 0 |
| UT | $ - 0 | $ - 0 |
| VA | $ - 0 | $ - 0 |
| VT | $ - 0 | $ - 0 |
| WA | $ - 0 | $ - 0 |
| WI | $ - 0 | $ - 0 |
| WV | $ - 0 | $ - 0 |
| WY | $ - 0 | $ - 0 |
File details come from the government source that posted it. Updated .