Attachment_2_-_Pricing_Spreadsheet_1_.xlsx
XLSX spreadsheet 37 KB Posted
- Attached to
- HHS ORR Legal Services Federal contract opportunity
- Solicitation number
- 140D0422R0012
About this file
This document contains a pricing spreadsheet template for a federal contract to provide legal services to unaccompanied children. The template includes pricing for a base year and four option years by labor category and office location. Estimated case volumes are provided for each site annually. Labor categories include program directors, regional coordinators, administrative directors, planning analysts, and legal service providers. Pricing and case estimates are blank, indicating this is a template to be populated by an offeror. The related opportunity is for Solicitation 140D0422R0012 to provide HHS ORR Legal Services for the Department of Health and Human Services Administration for Children and Families Office of Refugee Resettlement.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment_1_SOO_Am1_0001.pdf | ||
| Attachment_5_QandA_0001.pdf | ||
| Sol_140D0422R0012_Amd_0001.pdf | ||
| Attachment_2_-_Pricing_Spreadsheet_-_Am1_0001.xlsx | XLSX spreadsheet | |
| RFP_140D0422R0012_Amendment_1_0001.pdf | ||
| RFP_140D0422R0012_1_.pdf | ||
| Sol_140D0422R0012.pdf | ||
| Attachment_4_-_HHS_Subcontracting_Plan_Template_1_.docx | DOCX document | |
| Attachment_3_-_Questions_Form_1_.docx | DOCX document | |
| Attachment_1_-_SOO_1_.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
Totals
| Labor | ODCs | Total | |
| Base Period | $0.00 | $0.00 | $0.00 |
| Option Period 1 | $0.00 | $0.00 | $0.00 |
| Option Period 2 | $0.00 | $0.00 | $0.00 |
| Option Period 3 | $0.00 | $0.00 | $0.00 |
| Option Period 4 | $0.00 | $0.00 | $0.00 |
| Total | $0.00 | $0.00 | $0.00 |
Estimated Cases Per Year
| Offices | Estimated Number of Cases (Base Year) | Estimated Number of Cases (Option Year 1) | Estimated Number of Cases (Option Year 2) | Estimated Number of Cases (Option Year 3) | Estimated Number of Cases (Option Year 4) |
| Chicago, IL | 120 | 122 | 124 | 126 | 129 |
| Harlingen, TX | 150 | 153 | 156 | 159 | 162 |
| Houston, TX | 90 | 92 | 94 | 96 | 98 |
| Los Angeles, CA | 65 | 66 | 67 | 68 | 69 |
| New York, NY/Newark, NJ | 110 | 112 | 114 | 116 | 118 |
| Phoenix, AZ | 100 | 102 | 104 | 106 | 108 |
| San Antonio, TX | 80 | 82 | 84 | 86 | 88 |
| Washington, D.C. | 60 | 61 | 62 | 63 | 64 |
| Miami, FL | 95 | 97 | 99 | 101 | 103 |
| Seattle, WA | 65 | 66 | 67 | 68 | 69 |
| Grand Rapids, MI | 65 | 66 | 67 | 68 | 69 |
| Total | 1,000 | 1,019 | 1,038 | 1,057 | 1,077 |
Base Period
| Base Period | ||||
| Labor Category | Number of Staff | Hours | Fully Burdened Labor Rate | Cost |
| Program Director | 1 | 2080 | $0.00 | |
| Regional Coordinators | 3 | 6240 | $0.00 | |
| Administrative Director | 7 | 14560 | $0.00 | |
| Planning Analyst - Chicago, IL | 1 | 2080 | $0.00 | |
| Planning Analyst - San Antonio | 1 | 2080 | $0.00 | |
| Planning Analyst - Washington, DC | 1 | 2080 | $0.00 | |
| Planning Analyst - Harligen | 3 | 6240 | $0.00 | |
| Planning Analyst - Houston | 1 | 2080 | $0.00 | |
| Planning Analyst - New York | 1 | 2080 | $0.00 | |
| Planning Analyst - Phoenix,AZ | 1 | 2080 | $0.00 | |
| Legal Service Providers - Phoenix, AZ | 22 | 45760 | $0.00 | |
| Legal Service Providers - Corpus Christi,TX | 5 | 10400 | $0.00 | |
| Legal Service Providers - El Paso | 7 | 14560 | $0.00 | |
| Legal Service Providers - Miami ,Fl | 7 | 14560 | $0.00 | |
| Legal Service Providers - Atlanta, GA | 1 | 2080 | $0.00 | |
| Legal Service Providers - Houston, TX | 18 | 37440 | $0.00 | |
| Legal Service Providers - Harlingen, TX | 42 | 87360 | $0.00 | |
| Legal Service Providers - Chicago, IL | 6 | 12480 | $0.00 | |
| Legal Service Providers - Los Angeles, CA | 4 | 8320 | $0.00 | |
| Legal Service Providers - Rockville, MD | 1 | 2080 | $0.00 | |
| Legal Service Providers - NY, NJ | 18 | 37440 | $0.00 | |
| Legal Service Providers - Portland, OR | 1 | 2080 | $0.00 | |
| Legal Service Providers - Philidephia,PA | 2 | 4160 | $0.00 | |
| Legal Service Providers - San Antonio, TX | 12 | 24960 | $0.00 | |
| Legal Service Providers - San Diego, CA | 2 | 4160 | $0.00 | |
| Legal Service Providers - San Fransico, CA | 2 | 4160 | $0.00 | |
| Legal Service Providers - Washington Dc, VA | 19 | 39520 | $0.00 | |
| Legal Service Providers - Seattle, WA | 1 | 2080 | $0.00 | |
| TOTAL LABOR | $0.00 |
| ODCs (Fully burdened with G&A) | |
| Travel | |
| Subcontracts/Consultants (i.e. Translation Services, COI Cases, medical/psych evals) | |
| Consultants/Case Stipends (Per Case) | |
| Materials | |
| Training/Background | |
| TOTAL ODCS | $0.00 |
| GRAND TOTAL | $0.00 |
Option Period 1
| Option Period 1 | ||||
| Labor Category | Number of Staff | Hours | Fully Burdened Labor Rate | Cost |
| Program Director | 1 | 2085.698630137 | $0.00 | |
| Regional Coordinators | 3 | 6257.095890411 | $0.00 | |
| Administrative Director | 7 | 14599.8904109589 | $0.00 | |
| Planning Analyst - Chicago, IL | 1 | 2085.698630137 | $0.00 | |
| Planning Analyst - San Antonio | 1 | 2085.698630137 | $0.00 | |
| Planning Analyst - Washington, DC | 1 | 2085.698630137 | $0.00 | |
| Planning Analyst - Harligen | 3 | 6257.095890411 | $0.00 | |
| Planning Analyst - Houston | 1 | 2085.698630137 | $0.00 | |
| Planning Analyst - New York | 1 | 2085.698630137 | $0.00 | |
| Planning Analyst - Phoenix,AZ | 1 | 2085.698630137 | $0.00 | |
| Legal Service Providers - Phoenix, AZ | 22 | 45885.3698630137 | $0.00 | |
| Legal Service Providers - Corpus Christi,TX | 5 | 10428.4931506849 | $0.00 | |
| Legal Service Providers - El Paso | 7 | 14599.8904109589 | $0.00 | |
| Legal Service Providers - Miami ,Fl | 7 | 14599.8904109589 | $0.00 | |
| Legal Service Providers - Atlanta, GA | 1 | 2085.698630137 | $0.00 | |
| Legal Service Providers - Houston, TX | 18 | 37542.5753424658 | $0.00 | |
| Legal Service Providers - Harlingen, TX | 42 | 87599.3424657534 | $0.00 | |
| Legal Service Providers - Chicago, IL | 6 | 12514.1917808219 | $0.00 | |
| Legal Service Providers - Los Angeles, CA | 4 | 8342.794520548 | $0.00 | |
| Legal Service Providers - Rockville, MD | 1 | 2085.698630137 | $0.00 | |
| Legal Service Providers - NY, NJ | 18 | 37542.5753424658 | $0.00 | |
| Legal Service Providers - Portland, OR | 1 | 2085.698630137 | $0.00 | |
| Legal Service Providers - Philidephia,PA | 2 | 4171.397260274 | $0.00 | |
| Legal Service Providers - San Antonio, TX | 12 | 25028.3835616438 | $0.00 | |
| Legal Service Providers - San Diego, CA | 2 | 4171.397260274 | $0.00 | |
| Legal Service Providers - San Fransico, CA | 2 | 4171.397260274 | $0.00 | |
| Legal Service Providers - Washington Dc, VA | 19 | 39628.2739726027 | $0.00 | |
| Legal Service Providers - Seattle, WA | 1 | 2085.698630137 | $0.00 | |
| TOTAL LABOR | $0.00 |
| ODCs (Fully burdened with G&A) | |
| Travel | |
| Subcontracts/Consultants (i.e. Translation Services, COI Cases, medical/psych evals) | |
| Consultants/Case Stipends (Per Case) | |
| Materials | |
| Training/Background | |
| TOTAL ODCS | $0.00 |
| GRAND TOTAL | $0.00 |
Option Period 2
| Option Period 2 | ||||
| Labor Category | Number of Staff | Hours | Fully Burdened Labor Rate | Cost |
| Program Director | 1 | 2080 | $0.00 | |
| Regional Coordinators | 3 | 6240 | $0.00 | |
| Administrative Director | 7 | 14560 | $0.00 | |
| Planning Analyst - Chicago, IL | 1 | 2080 | $0.00 | |
| Planning Analyst - San Antonio | 1 | 2080 | $0.00 | |
| Planning Analyst - Washington, DC | 1 | 2080 | $0.00 | |
| Planning Analyst - Harligen | 3 | 6240 | $0.00 | |
| Planning Analyst - Houston | 1 | 2080 | $0.00 | |
| Planning Analyst - New York | 1 | 2080 | $0.00 | |
| Planning Analyst - Phoenix,AZ | 1 | 2080 | $0.00 | |
| Legal Service Providers - Phoenix, AZ | 22 | 45760 | $0.00 | |
| Legal Service Providers - Corpus Christi,TX | 5 | 10400 | $0.00 | |
| Legal Service Providers - El Paso | 7 | 14560 | $0.00 | |
| Legal Service Providers - Miami ,Fl | 7 | 14560 | $0.00 | |
| Legal Service Providers - Atlanta, GA | 1 | 2080 | $0.00 | |
| Legal Service Providers - Houston, TX | 18 | 37440 | $0.00 | |
| Legal Service Providers - Harlingen, TX | 42 | 87360 | $0.00 | |
| Legal Service Providers - Chicago, IL | 6 | 12480 | $0.00 | |
| Legal Service Providers - Los Angeles, CA | 4 | 8320 | $0.00 | |
| Legal Service Providers - Rockville, MD | 1 | 2080 | $0.00 | |
| Legal Service Providers - NY, NJ | 18 | 37440 | $0.00 | |
| Legal Service Providers - Portland, OR | 1 | 2080 | $0.00 | |
| Legal Service Providers - Philidephia,PA | 2 | 4160 | $0.00 | |
| Legal Service Providers - San Antonio, TX | 12 | 24960 | $0.00 | |
| Legal Service Providers - San Diego, CA | 2 | 4160 | $0.00 | |
| Legal Service Providers - San Fransico, CA | 2 | 4160 | $0.00 | |
| Legal Service Providers - Washington Dc, VA | 19 | 39520 | $0.00 | |
| Legal Service Providers - Seattle, WA | 1 | 2080 | $0.00 | |
| TOTAL LABOR | $0.00 |
| ODCs (Fully burdened with G&A) | |
| Travel | |
| Subcontracts/Consultants (i.e. Translation Services, COI Cases, medical/psych evals) | |
| Consultants/Case Stipends (Per Case) | |
| Materials | |
| Training/Background | |
| TOTAL ODCS | $0.00 |
| GRAND TOTAL | $0.00 |
Option Period 3
| Option Period 3 | ||||
| Labor Category | Number of Staff | Hours | Fully Burdened Labor Rate | Cost |
| Program Director | 1 | 2080 | $0.00 | |
| Regional Coordinators | 3 | 6240 | $0.00 | |
| Administrative Director | 7 | 14560 | $0.00 | |
| Planning Analyst - Chicago, IL | 1 | 2080 | $0.00 | |
| Planning Analyst - San Antonio | 1 | 2080 | $0.00 | |
| Planning Analyst - Washington, DC | 1 | 2080 | $0.00 | |
| Planning Analyst - Harligen | 3 | 6240 | $0.00 | |
| Planning Analyst - Houston | 1 | 2080 | $0.00 | |
| Planning Analyst - New York | 1 | 2080 | $0.00 | |
| Planning Analyst - Phoenix,AZ | 1 | 2080 | $0.00 | |
| Legal Service Providers - Phoenix, AZ | 22 | 45760 | $0.00 | |
| Legal Service Providers - Corpus Christi,TX | 5 | 10400 | $0.00 | |
| Legal Service Providers - El Paso | 7 | 14560 | $0.00 | |
| Legal Service Providers - Miami ,Fl | 7 | 14560 | $0.00 | |
| Legal Service Providers - Atlanta, GA | 1 | 2080 | $0.00 | |
| Legal Service Providers - Houston, TX | 18 | 37440 | $0.00 | |
| Legal Service Providers - Harlingen, TX | 42 | 87360 | $0.00 | |
| Legal Service Providers - Chicago, IL | 6 | 12480 | $0.00 | |
| Legal Service Providers - Los Angeles, CA | 4 | 8320 | $0.00 | |
| Legal Service Providers - Rockville, MD | 1 | 2080 | $0.00 | |
| Legal Service Providers - NY, NJ | 18 | 37440 | $0.00 | |
| Legal Service Providers - Portland, OR | 1 | 2080 | $0.00 | |
| Legal Service Providers - Philidephia,PA | 2 | 4160 | $0.00 | |
| Legal Service Providers - San Antonio, TX | 12 | 24960 | $0.00 | |
| Legal Service Providers - San Diego, CA | 2 | 4160 | $0.00 | |
| Legal Service Providers - San Fransico, CA | 2 | 4160 | $0.00 | |
| Legal Service Providers - Washington Dc, VA | 19 | 39520 | $0.00 | |
| Legal Service Providers - Seattle, WA | 1 | 2080 | $0.00 | |
| TOTAL LABOR | $0.00 |
| ODCs (Fully burdened with G&A) | |
| Travel | |
| Subcontracts/Consultants (i.e. Translation Services, COI Cases, medical/psych evals) | |
| Consultants/Case Stipends (Per Case) | |
| Materials | |
| Training/Background | |
| TOTAL ODCS | $0.00 |
| GRAND TOTAL | $0.00 |
Option Period 4
| Option Period 4 | ||||
| Labor Category | Number of Staff | Hours | Fully Burdened Labor Rate | Cost |
| Program Director | 1 | 2080 | $0.00 | |
| Regional Coordinators | 3 | 6240 | $0.00 | |
| Administrative Director | 7 | 14560 | $0.00 | |
| Planning Analyst - Chicago, IL | 1 | 2080 | $0.00 | |
| Planning Analyst - San Antonio | 1 | 2080 | $0.00 | |
| Planning Analyst - Washington, DC | 1 | 2080 | $0.00 | |
| Planning Analyst - Harligen | 3 | 6240 | $0.00 | |
| Planning Analyst - Houston | 1 | 2080 | $0.00 | |
| Planning Analyst - New York | 1 | 2080 | $0.00 | |
| Planning Analyst - Phoenix,AZ | 1 | 2080 | $0.00 | |
| Legal Service Providers - Phoenix, AZ | 22 | 45760 | $0.00 | |
| Legal Service Providers - Corpus Christi,TX | 5 | 10400 | $0.00 | |
| Legal Service Providers - El Paso | 7 | 14560 | $0.00 | |
| Legal Service Providers - Miami ,Fl | 7 | 14560 | $0.00 | |
| Legal Service Providers - Atlanta, GA | 1 | 2080 | $0.00 | |
| Legal Service Providers - Houston, TX | 18 | 37440 | $0.00 | |
| Legal Service Providers - Harlingen, TX | 42 | 87360 | $0.00 | |
| Legal Service Providers - Chicago, IL | 6 | 12480 | $0.00 | |
| Legal Service Providers - Los Angeles, CA | 4 | 8320 | $0.00 | |
| Legal Service Providers - Rockville, MD | 1 | 2080 | $0.00 | |
| Legal Service Providers - NY, NJ | 18 | 37440 | $0.00 | |
| Legal Service Providers - Portland, OR | 1 | 2080 | $0.00 | |
| Legal Service Providers - Philidephia,PA | 2 | 4160 | $0.00 | |
| Legal Service Providers - San Antonio, TX | 12 | 24960 | $0.00 | |
| Legal Service Providers - San Diego, CA | 2 | 4160 | $0.00 | |
| Legal Service Providers - San Fransico, CA | 2 | 4160 | $0.00 | |
| Legal Service Providers - Washington Dc, VA | 19 | 39520 | $0.00 | |
| Legal Service Providers - Seattle, WA | 1 | 2080 | $0.00 | |
| TOTAL LABOR | $0.00 |
| ODCs (Fully burdened with G&A) | |
| Travel | |
| Subcontracts/Consultants (i.e. Translation Services, COI Cases, medical/psych evals) | |
| Consultants/Case Stipends (Per Case) | |
| Materials | |
| Training/Background | |
| TOTAL ODCS | $0.00 |
| GRAND TOTAL | $0.00 |
File details come from the government source that posted it. Updated .