Attachment_4-Pricing_Sheet___Amendment__0001.xlsx

XLSX spreadsheet 46 KB Posted

Attached to
Unarmed Escort and Transportation Services for Unaccompanied Alien Children and Family Units
Solicitation number
70CDCR19R00000006_REVISED
Issued by

About this file

This document contains a pricing template for an unarmed escort and transportation services solicitation. The solicitation seeks pricing for transportation of unaccompanied alien children and family units between various hub locations. Offerors must provide fully burdened hourly rates for transportation specialists and various management labor categories to support air and ground transportation between McAllen, San Antonio, El Paso, and Phoenix hubs. Pricing is also required for facility leases, airline and rental car costs, charter flights, meals, incidentals, fuel, and surge support. The purpose of the detailed template is to provide a uniform pricing structure for evaluation.

View the file

Other files

Show all 18

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 Attachment 4, IDIQ Pricing Template

Please see RFP Section L, Price Quotation, for complete instructions.
In accordance with RFQ Section L, the offeror shall complete Attachment 4: Pricing Template of this RFP and return it with their price quote submission.

All pricing proposed increment prices will be used as the contract prices.

The following instructions shall be used in completing the "Proposed Price", "Labor Rates", and "Ground Transportation" tabs. Each Offeror must complete all the shaded "yellow" cells.

1. "Proposed Price" Tab: Input the rate proposed for facilities, sack lunches and the indirect rate, if applicable and in accordance with your indirect rate structure, for each year as noted by the "yellow" highlighted cells. The total information contained on the "Labor Rates" and "Ground Transportation" tabs will automatically populate this sheet. The sheet contains the total proposed price which will be used for determining best value.
The yellow shaded areas to be completed as needed.
2. "Labor Rates" Tab: Offerors must propose the hourly time and material rate for categories listed, for each contract year. The hourly time and material rate is inclusive of direct labor, benefits, the offeror's applicable burden (e.g. overhead , G&A) and profit. No cost incurred for the same purpose should be proposed as direct cost and as indirect cost, for example, facility expense in CLIN X001a-d should not be included in the time and material rate. The template does not apply escalation, offerors will enter a rate for each contract year. Note that proposed rates for SCA covered categories may not include escalation on direct labor and applicable health and welfare benefits, which will be adjusted in accordance with 52.222-43(b) - "The Contractor warrants that the prices in this contract do not include any allowance for any contingency to cover increased costs for which adjustment is provided under this clause."
The yellow shaded areas to be completed as needed.
3. "Ground Transportation" tab: For each CLIN, the Offeror must propose a rate per mile for Contractor Vehicles (owned or leased) used to conduct ground transportation events including vehicle leasing, insurance taxes and maintanance. No fuel cost is allowable under this CLIN. All other data on this sheet will self populate.
The yellow shaded areas to be completed as needed.

Proposed Price

Base PeriodOption Year 1Option Year 2Option Year 3Option Year 4Total Proposed Price
BASEOY1OY2OY3OY4CLIN DescriptionEvaluation QuantityProposed RateTotal PriceEvaluation QuantityProposed RateTotal PriceEvaluation QuantityProposed RateTotal PriceEvaluation QuantityProposed RateTotal PriceEvaluation QuantityProposed RateTotal Price
0001Set-up1$ - 0$ - 0$ - 0
0001a1001a2001a3001a4001aFacility - McAllenMonthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0$ - 0
0001b1001b2001b3001b4001bFacility - San AntonioMonthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0$ - 0
0001c1001c2001c3001c4001cFacility - El PasoMonthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0$ - 0
0001d1001d2001d3001d4001dFacility - PhoenixMonthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0Monthly$ - 0$ - 0$ - 0
00021002200230024002Guaranteed Minimum Air Escort HoursSee "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00$0.00
0002a1002a2002a3002a4002aAir Escort Hours Over the Guaranteed MinimumSee "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00$0.00
00031003200330034003Airline and Rental FareNANA$28,000,000.00NANA$29,000,000.00NANA$30,000,000.00NANA$32,000,000.00NANA$35,000,000.00$154,000,000.00
00041004200430044004Charter Flights and Charter BusesNANA$3,600,000.00NANA$3,800,000.00NANA$4,000,000.00NANA$4,300,000.00NANA$4,500,000.00$20,200,000.00
00051005200530054005Sack Lunches146,000.00$ - 0$0.00146,000.00$ - 0$0.00146,000.00$ - 0$0.00146,000.00$ - 0$0.00146,000.00$ - 0$0.00$0.00
00061006200630064006Per DiemNANA$2,000,000.00NANA$2,000,000.00NANA$2,000,000.00NANA$2,000,000.00NANA$2,000,000.00$10,000,000.00
00071007200730074007Incidentals for UAC and FAMUNANA$2,930,000.00NANA$2,930,000.00NANA$2,930,000.00NANA$2,930,000.00NANA$2,930,000.00$14,650,000.00
00081008200830084008Fuel ExpenditureNANA$2,495,000.00NANA$2,495,000.00NANA$2,495,000.00NANA$2,495,000.00NANA$2,495,000.00$12,475,000.00
00091009200930094009Guaranteed Minimum National Ground Transportation - HoursSee "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00$0.00
0009a1009a2009a3009a4009aNational Ground Transportation - Hours Over the Guaranteed MinimumSee "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00$0.00
00101010201030104010Guaranteed Minimum National Ground Transportation - MilesSee "Ground Transportation" Tab$0.00See "Ground Transportation" Tab$0.00See "Ground Transportation" Tab$0.00See "Ground Transportation" Tab$0.00See "Ground Transportation" Tab$0.00$0.00
0010a1010a2010a3010a4010aNational Ground Transportation - Miles Over the Guaranteed MinimumSee "Ground Transportation" Tab$0.00See "Ground Transportation" Tab$0.00See "Ground Transportation" Tab$0.00See "Ground Transportation" Tab$0.00See "Ground Transportation" Tab$0.00$0.00
00111111201130114011Management SupportSee "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00See "Labor Rates" Tab$0.00$0.00
00121012201230124012SurgeNANA$7,805,000.00NANA$8,045,000.00NANA$8,285,000.00NANA$8,745,000.00NANA$9,385,000.00$42,265,000.00
Indirect rate applied to all CLINS with evaluation quantity of "NA,"excluding surge$39,025,000.000.00%$0.00$40,225,000.000.00%$0.00$41,425,000.000.00%$0.00$43,725,000.000.00%$0.00$46,925,000.000.00%$0.00$0.00
Total Proposed Price:$ 46,830,000.00$ 48,270,000.00$ 49,710,000.00$ 52,470,000.00$ 56,310,000.00$ 253,590,000.00
The Government reserves the right to realign CLINs as required for support of the contract
The purpose of the pricing spreadsheet is to provide a uniform pricing template for evaluation purpose only. The estimated total number of hours provided are not contractual commitments and are not intended to represent actual expected experience of any given contractor. The estimated quantities were chosen based on actual experience and this is determinative of the price evaluation. There is no intent on the part of the Government to obligate fiscal year funds in the amount of such annual price

Labor Rates

Escalation: Proposed rates for SCA covered categories may not include escalation on direct labor and applicable health and welfare benefits, which will be adjusted in accordance with 52.222-43(b) - "The Contractor warrants that the prices in this contract do not include any allowance for any contingency to cover increased costs for which adjustment is provided under this clause.

CLIN X002 - Guaranteed Minimum Air Escort Hours
The Government reserves the right to realign CLIN hours between air and ground escort hours for support of the contract, so long as hours are consistent with the location.
Base PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Labor CategorySCA Covered Yes/NoRegularLocationEvaluation HoursProposed RateTotalProposed RateTotalProposed RateTotalProposed RateTotalProposed RateTotal
Transportation SpecialistYesRegularMcAllen120,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularSan Antonio81,220$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularEl Paso14,400$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularPhoenix33,600$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:$ - 0$ - 0$ - 0$ - 0$ - 0
CLIN X002a - Air Escort Hours Over the Guaranteed Minimum
The Government reserves the right to realign CLIN hours between air and ground escort hours for support of the contract, so long as hours are consistent with the location.
Base PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Labor CategorySCA Covered Yes/NoRegularLocationEvaluation HoursProposed RateTotalProposed RateTotalProposed RateTotalProposed RateTotalProposed RateTotal
Transportation SpecialistYesRegularMcAllen360,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularSan Antonio243,660$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularEl Paso43,200$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularPhoenix100,800$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:$ - 0$ - 0$ - 0$ - 0$ - 0
CLIN X009 - Guaranteed Minimum National Ground Transportation - Hours
The Government reserves the right to realign CLIN hours between air and ground escort hours for support of the contract, so long as hours are consistent with the location.
Base PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Labor CategorySCA Covered Yes/NoRegularLocationEvaluation HoursProposed RateTotalProposed RateTotalProposed RateTotalProposed RateTotalProposed RateTotal
Transportation SpecialistYesRegularMcAllen81,600$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularSan Antonio26,400$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularEl Paso7,680$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularPhoenix4,320$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:$ - 0$ - 0$ - 0$ - 0$ - 0
CLIN X009a - National Ground Transportation - Hours Over the Guaranteed Minimum
The Government reserves the right to realign CLIN hours between air and ground escort hours for support of the contract, so long as hours are consistent with the location.
Base PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Labor CategorySCA Covered Yes/NoRegularLocationEvaluation HoursProposed RateTotalProposed RateTotalProposed RateTotalProposed RateTotalProposed RateTotal
Transportation SpecialistYesRegularMcAllen244,800$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularSan Antonio79,200$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularEl Paso23,040$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation SpecialistYesRegularPhoenix12,960$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:$ - 0$ - 0$ - 0$ - 0$ - 0

CLIN X010 - Management Support

Base PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Labor CategorySCA Covered Yes/NoRegularLocationEvaluation HoursProposed RateTotalProposed RateTotalProposed RateTotalProposed RateTotalProposed RateTotal
Corporate Security OfficerNoRegularMcAllen1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation CoordinatorNoRegularMcAllen7,680$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation CoordinatorNoRegularEl Paso5,760$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transportation CoordinatorNoRegularPhoenix5,760$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Site ManagerNoRegularMcAllen1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Site ManagerNoRegularSan Antonio1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Site ManagerNoRegularEl Paso1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Site ManagerNoRegularPhoenix1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program ManagerNoRegular1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel AnalystNoRegularMcAllen38,400$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel AnalystNoRegularSan Antonio9,600$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Logistic SpecialistNoRegularPhoenix1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Logistic SpecialistNoRegularMcAllen1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Logistic SpecialistNoRegularSan Antonio1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Logistic SpecialistNoRegularEl Paso1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Training DirectorNoRegular1,920$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Administrative SupportYesRegularMcAllen11,520$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Administrative AssistantYesRegularMcAllen3,840$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Administrative AssistantYesRegularSan Antonio3,840$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Administrative AssistantYesRegularEl Paso3,840$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Administrative AssistantYesRegularPhoenix3,840$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:$ - 0$ - 0$ - 0$ - 0$ - 0

The purpose of the pricing spreadsheet is to provide a uniform pricing template for evaluation purpose only. The Governments estimated total number of hours provided are for evaluation purpose and based on historical estimates. The estimated total number of hours provided are NOT ceilings. The task orders will include a NTE number.

Ground Transportation

CLIN X010 - Guaranteed Minimum National Ground Transportation - Miles

Base PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Type of TransportationNumber of MilesPer Mile RateTotalPer Mile RateTotalPer Mile RateTotalPer Mile RateTotalPer Mile RateTotal
Sedan (4 passenger)1,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Van ( 15 passenger)76,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0

CLIN X010a - National Ground Transportation - Miles Over the Guaranteed Minimum

Base PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Type of TransportationNumber of MilesPer Mile RateTotalPer Mile RateTotalPer Mile RateTotalPer Mile RateTotalPer Mile RateTotal
Sedan (4 passenger)50,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Van ( 15 passenger)1,446,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
The purpose of the pricing spreadsheet is to provide a uniform pricing template for evaluation purpose only. The estimated total number of hours provided are not contractual commitments and are not intended to represent actual expected experience of any given contractor. The estimated quantities were chosen based on actual experience and this is determinative of the price evaluation. There is no intent on the part of the Government to obligate fiscal year funds in the amount of such annual price

CLIN DESCRIPTION

ATTACHMMENT 4
Contract Line Item Number (CLIN)CLIN DescriptionDetailed description of the CLINs
0001Set-upOne time fixed costs to set-up four (4) offices and transition costs
0001a-d, 1001a-d, 2001a-d, 3001a-d, 4001a-dFacilityCost of Facilities maintantance, (Reference Hub/Site Office in the Scope section of the Performance Work Statement.) Subclins identify the facility location. Proposed cost will be a monthly fixed rate.
0002, 1002, 2002, 3002, 4002,0002a, 1002a,2002a, 3002a, 4002aAir Escort HoursBillable time by Transportation Specialist during an Air transportation trip. Hourly labor rate inclusive of wage, overhead, G&A expenses and profit.Vendor may include other labor categories that support air transporation specialist during travel, such as travel analyst and administrative support specialist. Must provide justification.
0003, 1003, 2003, 3003, 4003Airline Fare and Car Rental FareCost for TS, UAC and or FAMU tickets and luggage. Cost for in-flight snack and meals provided in the terminal prior to flights for UAC and FAMU only. TS shall not bill meals under this CLIN (see per diem). Costs for car rental expenses from the airport to the designated ORR or family Residential facility. Travel voucher is submitted with receipts for reimbursement. A Not to Exceed (NTE) amounts will be stated in task orders.
0004, 1004, 2004, 3004, 4004Charter Flights and Charter BusesThe vendor will submit a receipt and get reimbursed for charter flight and bus cost, fuel, lease/rental, and broker costs. A Not to Exceed (NTE) amounts will be stated in task orders.
0005, 1005, 2005, 3005, 4005Sack LunchesFixed price per pre-ordered or pre-prepared meals provided to UAC and FAMUs. Other miscellaneous food, drinks and snacks that are purchased for UAC and FAMU during a trip are included in CLIN 0007 Incidentals for UACs and FAMUs
0006, 1006, 2006, 3006, 4006Per DiemThe use of Per Diem is only for TS during travel status. Per Diem, is approved by the COR, and will be reimbursed according to Federal Travel Regulations (FTR). This is mandated by GSA, no fee is included. A Not to Exceed (NTE) amounts will be stated in task orders.
0007, 1007, 2007, 3007, 4007Incidentals for UAC and FAMUIncludes any costs specifically for items provided to UACs and FAMU's such as snacks and water purchases during transportation trips. Costs also include clothing, personal hygiene supplies, emergency purchase of diapers,lodging and meals whenever applicable and medical expenses (hospitals, medication refills, labwork, etc.). Items shall be reimbursed at cost. A Not to Exceed (NTE) amounts will be stated in task orders.
0008, 1008, 2008, 3008, 4008Fuel ExpenditureIncludes the cost of fuel for vehicle usage in support of work performed under the contract, with reciepts. The vendor will submit a receipt and get reimbursed for fuel. A Not to Exceed (NTE) amounts will be stated in task orders.
0009, 1009,2009, 3009, 4009, 0009a, 1009a, 2009a, 3009a, 4009aNational Ground Transportation - HoursBlended hourly labor rate for transportation specialists for all the hubs inclusive of wage, overhead, G&A expenses, and profit.
0010, 1010,2010, 3010, 4010, 0010a, 1010a, 2010a, 3010a, 4010aNational Ground Transportation - MilesThis is a per mile cost for Contractor Vehicles ( owned or leased) used to conduct ground transportation events including vehicle leasing, insurance taxes and maintanance . No fuel cost is allowable under this CLIN.
0011, 1011, 2011, 3011, 4011Management SupportThis CLIN includes management labor costs directly related to this contract - corporate security officer, transportation coordinator, site manager, program manager, travel analyst, and administrative assistant, adminstrative support. Labor rates are fully burdened through profit.
0012, 1012, 2012, 3012, 4012SurgeSurge will be paid on a T&M basis and NTE is included per period. And may be used for increase staffing for additional hub locations on approval by the contracting officer.

Sheet1

Pick from ListPick from ListPick from ListPick from ListPick from List
Pick from ListPick from ListPick from ListLabor HourYes
Administrative SpecialistLevel IContractorFirm Fixed PriceNo
Applications DeveloperLevel 2Government
Applications Systems AnalystLevel 3
Business Case Specialist
Business Process Analyst
Capital Planning Specialist
Communications Engineer
Configuration Management Specialist
Data Architect
Database Specialist
Enterprise Architect
Exchange Specialist (Information Specialist)
Financial Analyst
Functional Analyst
Graphics Specialist
Help Desk Specialist
Information Assurance (IT Security Specialist)

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