Attachment 6a -BAL Pricing Template.xlsx

XLSX spreadsheet 171 KB Posted

Attached to
Multi - AOR Armed Guard Transportation Services
Solicitation number
70CDCR26R00000018_S
Issued by

About this file

This is a pricing template for the Baltimore (BAL) Area of Responsibility under the Multi-AOR Armed Guard Transportation Services contract for U.S. Immigration and Customs Enforcement (ICE). The template establishes a cost structure across seven Contract Line Items (CLINs) covering a transition period and four option years, with a total evaluated price of $2,916,666.68.

CLIN 0001 addresses one-time transition costs (90 days) estimated at $333,333.34. CLINs 0002-0007 represent the base year costs (8 months) with CLIN 0002 covering guaranteed minimum transportation services for 360,000 miles per year and associated guard hours; CLIN 0003 addressing above-guaranteed-minimum mileage (155,000 miles annually) and labor; CLIN 0004 covering outside-primary-routes transportation services; CLIN 0005 for stationary guard post duties unrelated to transportation; CLIN 0006 for actual fuel costs reimbursement (not to exceed $266,666.67); and CLIN 0007 for federal travel regulation-compliant travel expenses (not to exceed $66,666.67). Option years 1-4 maintain similar structures with 12-month periods and proportionately increased quantities. The pricing template requires detailed cost build-ups for assets (vehicles, leases, maintenance), labor (position descriptions, hourly rates, benefits, taxes, overtime), facilities, and other operational costs, with escalation percentages applied to out-year costs. Contractors must exclude G&A and profit from base cost calculations and apply separate percentages for G&A and profit margins by cost category and contract year. The template includes completion instructions for entering specific cost items, asset information, labor details, and facility requirements to support detainee transportation operations across the Baltimore AOR.

View the file

Other files

File Type Posted
A0005_Attachment 1 - Performance Work Statement.pdf PDF
A0005_70CDCR26R00000018 - RFP.pdf PDF
A0004_70CDCR26R00000018 - RFP.pdf PDF
A0003_7e - WAS Trans Route.xlsx XLSX spreadsheet
A0003_70CDCR26R00000018 - RFP.pdf PDF
A0001_Q and_A.xlsx XLSX spreadsheet
A0002_70CDCR26R00000018 - RFP.pdf PDF
A0001 6b-BOS Pricing Template.xlsx XLSX spreadsheet
A0001 6e-WAS Pricing Template.xlsx XLSX spreadsheet
A0001 6d-NYC Pricing Template.xlsx XLSX spreadsheet
A0001_7a - BAL Trans Route.xlsx XLSX spreadsheet
A0001_7b - BOS Trans Route.xlsx XLSX spreadsheet
A0001 6a-BAL Pricing Template.xlsx XLSX spreadsheet
A0001_70CDCR26R00000018 - RFP.pdf PDF
A0001_Attachment 1 - Performance Work Statement.pdf PDF
A0001 6c-NEW Pricing Template.xlsx XLSX spreadsheet
A0001_Attachment 10 - Seniority List.xlsx XLSX spreadsheet
Attachment 1 - Performance Work Statement.pdf PDF
Attachment 5b - Wage Determination_BOS.pdf PDF
Attachment 5e - Wage Determination_WAS.pdf PDF
Attachment 6e -WAS Pricing Template.xlsx XLSX spreadsheet
Attachment 7c - NEW Trans Route.xlsx XLSX spreadsheet
Attachment 9 - Demonstrated Experience (Factor 1).docx DOCX document
Attachment 6b -BOS Pricing Template.xlsx XLSX spreadsheet
Attachment 6c -NEW Pricing Template.xlsx XLSX spreadsheet
Attachment 6d -NYC Pricing Template.xlsx XLSX spreadsheet
Attachment 7a - BAL Trans Route.xlsx XLSX spreadsheet
Attachment 7b - BOS Trans Route.xlsx XLSX spreadsheet
Attachment 7d - NYC Trans Route.xlsx XLSX spreadsheet
Attachment 7e - WAS Trans Route.xlsx XLSX spreadsheet
Attachment 2 - Quality Assurance Surveillance Plan (QASP).pdf PDF
Attachment 3 - G391.xlsx XLSX spreadsheet
Attachment 4 - ASSET PROTECTION NJ ICE CBA.pdf PDF
Attachment 5d - Wage Determination_NYC.pdf PDF
Attachment 8 - Past Performance Questionnaire.docx DOCX document
70CDCR26R00000018 - RFP.pdf PDF
Attachment 5a - Wage Determination_BAL.pdf PDF
Attachment 5c - Wage Determination_NEW.pdf PDF
Show all 38

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

CLIN Breakdown

Summary Definitions:
NOTE: After the 120-day Transition period in CLIN 0001, the base year CLINs 0002-0007 reflect the remaining 8 months of the base year and pro-rate the full year quantities and costs detailed in this cost build-up at two-thirds of the annual totals.
NOTE: Rates in Column D are rounded to the nearest cent ($0.01). Total amounts in column H reflect Rate x Quantity = Total.
CLIN 0001: Transition costs include costs required to transition from the incumbent contractor to the new contractor in order to start-up activities.
CLIN X002: Represents all contractor personnel hours (including standing/processing time), vehicle costs, facilities costs, maintenance, management, overhead/G&A, and profit for transportation inside the AOR, as well as frequent routes originating or
terminating outside the AOR as designated by the COR for 360,000 miles per year. Only miles that are driven with aliens on board are included.
CLIN X003: Is estimated at 155,000 miles per year above the GM, and represents a fully burdened mileage rate that includes both above-GM mileage and above-GM labor costs. Only miles that are driven with aliens on board are included.
CLIN X004: Represents a fully burdened mileage rate that includes all contractor personnel hours (including standing/processing time), vehicle costs, fuel, maintenance, management, overhead/G&A, and profit for transportation outside the AOR with the
exception of frequent routes as designated by the COR for CLIN X002. Any mileage associated with this CLIN does not count towards CLIN X002: Guaranteed Minimum Miles and Guard Hours. Only miles that are driven with aliens on board are included.
CLIN X005: Stationary Guard Hours include labor hours outside of CLINs X002, X003, and X004 that are required to perform guard post duties for medical runs, court trips, monitoring detainee hotel stays, etc. and additional wait time or delay, caused through
no fault by the contractor, outside of the included 1 hour start/stop/end wait period in CLINs X002, X003, and X004.
CLIN X006: Fuel costs will be treated as direct/actual reimbursable under GSA schedule ordering procedures. The Government will reimburse the quoter's approved actual direct fuel costs, with no indirect or other mark-ups. The quoter must provide
fuel receipts in order to receive reimbursement.
CLIN X007: All travel shall occur in accordance with the Federal Travel regulation (FTR) and be approved in advance by the Contracting Officer Representative (COR) or will not be reimbursed.
CLIN BreakdownEstimatedMaximum
Base YearRateUnitTotalQuantityTotalQuantityTotal
0001Transition (90 days)$ - 0EA$ - 01$ - 01$ - 0
$ 333,333.34$ 333,333.34$ 416,666.68
0002Guaranteed Minimum Miles & Guard Hours - Primary Routes$ - 0Months$ - 08$ - 08$ - 0
0003Over GM Miles & Guard Hours$ - 0Miles$ - 0103,333$ - 0206,667$ - 0
0004Outside Primary Routes - Miles & Guard Hours$ - 0Miles$ - 066,667$ - 0100,000$ - 0
0005Stationary Delay Hours$ - 0Hours$ - 08,000$ - 016,000$ - 0
0006Fuel$ 266,666.67Lot$ 266,666.67 NTE1$ 266,666.67 NTE1$ 333,333.34 NTE
0007Per Diem$ 66,666.67Lot$ 66,666.67 NTE1$ 66,666.67 NTE1$ 83,333.34 NTE
OY 1$ 500,000.00$ 500,000.00$ 625,000.00
1002Guaranteed Minimum Miles & Guard Hours - Primary Routes$ - 0Months$ - 012$ - 012$ - 0
1003Over GM Miles & Guard Hours$ - 0Miles$ - 0155,000$ - 0310,000$ - 0
1004Outside Primary Routes - Miles & Guard Hours$ - 0Miles$ - 0100,000$ - 0150,000$ - 0
1005Stationary Guard Hours$ - 0Hours$ - 012,000$ - 024,000$ - 0
1006Fuel$ 400,000.00Lot$ 400,000.00 NTE1$ 400,000.00 NTE1$ 500,000.00 NTE
1007Per Diem$ 100,000.00Lot$ 100,000.00 NTE1$ 100,000.00 NTE1$ 125,000.00 NTE
OY 2$ 500,000.00$ 500,000.00$ 625,000.00
2002Guaranteed Minimum Miles & Guard Hours - Primary Routes$ - 0Months$ - 012$ - 012$ - 0
2003Over GM Miles & Guard Hours$ - 0Miles$ - 0155,000$ - 0310,000$ - 0
2004Outside Primary Routes - Miles & Guard Hours$ - 0Miles$ - 0100,000$ - 0150,000$ - 0
2005Stationary Guard Hours$ - 0Hours$ - 012,000$ - 024,000$ - 0
2006Fuel$ 400,000.00Lot$ 400,000.00 NTE1$ 400,000.00 NTE1$ 500,000.00 NTE
2007Per Diem$ 100,000.00Lot$ 100,000.00 NTE1$ 100,000.00 NTE1$ 125,000.00 NTE
OY 3$ 500,000.00$ 500,000.00$ 625,000.00
3002Guaranteed Minimum Miles & Guard Hours - Primary Routes$ - 0Months$ - 012$ - 012$ - 0
3003Over GM Miles & Guard Hours$ - 0Miles$ - 0155,000$ - 0310,000$ - 0
3004Outside Primary Routes - Miles & Guard Hours$ - 0Miles$ - 0100,000$ - 0150,000$ - 0
3005Stationary Guard Hours$ - 0Hours$ - 012,000$ - 024,000$ - 0
3006Fuel$ 400,000.00Lot$ 400,000.00 NTE1$ 400,000.00 NTE1$ 500,000.00 NTE
3007Per Diem$ 100,000.00Lot$ 100,000.00 NTE1$ 100,000.00 NTE1$ 125,000.00 NTE
OY 4$ 500,000.00$ 500,000.00$ 625,000.00
4002Guaranteed Minimum Miles & Guard Hours - Primary Routes$ - 0Months$ - 012$ - 012$ - 0
4003Over GM Miles & Guard Hours$ - 0Miles$ - 0155,000$ - 0310,000$ - 0
4004Outside Primary Routes - Miles & Guard Hours$ - 0Miles$ - 0100,000$ - 0150,000$ - 0
4005Stationary Guard Hours$ - 0Hours$ - 012,000$ - 024,000$ - 0
4006Fuel$ 400,000.00Lot$ 400,000.00 NTE1$ 400,000.00 NTE1$ 500,000.00 NTE
4007Per Diem$ 100,000.00Lot$ 100,000.00 NTE1$ 100,000.00 NTE1$ 125,000.00 NTE

Total Evaluated Price $ 2,333,333.34 $ 2,333,333.34 $ 2,916,666.68

CLIN 0001 - Transition

Transition Breakdown
Definition: Transition costs include those costs required to transition from the incumbent contractor to the new contractor in order to start-up activities.
Transition costs are one time only, and typically should not recur. Complete any transition costs associated with start-up activities for BAL.
Do not include G&A or Profit.
COMPLETION INSTRUCTIONS. The fields are free form text that allow you to enter specific costs as needed. There is no drop down selection to choose from.
1. Input cost items in Column B (Ex. Vehicle purchases, facility startup, etc..)
2. Enter the total units in Column C. If a single lump sum cost, enter 1
3. Enter the unit description in Column D (each, facilities, vans, annually, etc.)
4. Enter the cost per each unit of the item in Column E.
5. Add any comments to provide additional detail or explanation to the cost items in Column G.
Column F will calculate based on the entered values above. Do not enter information into this field.
CLIN 0001: Transition
Transition Item DescriptionNumber of Units for TransitionUnit DescriptionCost per UnitTotal Transition CostsComments (Explanation of Costs)
$ - 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
$ - 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
Transition Costs$ - 0
Transition G&A$ - 0
Transition Profit$ - 0
Grand Total Transition$ - 0

CLIN X002 - Assets

Assets Breakdown
Definition: Asset costs are a build up of the annual costs associated with operating and maintaining vehicles to support the guaranteed minimum of 360,000 miles
per year. Complete all costs associated with assets for BAL. Do not include G&A or Profit.
COMPLETION INSTRUCTIONS:
1. Enter an escalation percent for outyear increases in cell L14-O14. This will increase the asset costs by that percentage every year after the baseline.
2. Enter the asset description in Column B. (Specify whether van, sedan, bus, etc.)
3. Enter the total number of seats available for the asset in Column C.Annual GM Miles360,000
4. Enter the number of assets of each type in Column D.
5. Input the estimated yearly miles per single vehicle in Column E; Column F will calculate the estimated yearly based on Column D and E.
6. Input the monthly lease or payment amount per vehicle type in Column G.
7. Enter the estimated annual maintenance costs for each vehicle type in Column I.
Columns J through O will calculate based on the entered values above. Do not enter information into these fields.
Yearly Escalation0.00%0.00%0.00%0.00%
CLIN X002: GM Assets- 0
Asset DescriptionNumber of SeatsNumber of AssetsEst. Yearly Miles per VehicleEst. Total Yearly Miles (Column Total Must Equal Annual GM Miles [Cell K8])Monthly Lease Rate / Amortization per VehicleYearly Lease / Amortization per VehicleYearly Maintenance Costs per VehicleTotal Yearly Costs per VehicleTotal Cost Base Year
(8 Months)Total Cost OY 1
(12 Months)Total Cost OY 2
(12 Months)Total Cost OY 3
(12 Months)Total Cost OY 4

(12 Months)

- 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
- 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
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
Asset Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Total Asset G&A$ - 0$ - 0$ - 0$ - 0$ - 0
Total Asset Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total Assets$ - 0$ - 0$ - 0$ - 0$ - 0
Total Miles240,000360,000360,000360,000360,000
Cost per Mile$ - 0$ - 0$ - 0$ - 0$ - 0

CLIN X002 - Labor

Labor Breakdown
Definition: Labor costs include those costs that relate directly to the number of personnel required to support the guaranteed minimum of 360,000 miles per year. Complete all costs associated with labor for BAL. Do not include G&A or Profit.
COMPLETION INSTRUCTIONS:
1. Enter an escalation percent for outyear increases in cell AI16-AL16. This will increase the (non-CBA/SCA) labor costs by that percentage every year after the baseline.
2. Enter the position description in Column B. (Transportation Officer, Supervisor, Project Manager, etc.)
3. In Columns C through E, enter the total number of FTEs needed for each position type, whether that position is under a Collective Bargaining Agreement (CBA) or SCA ("Yes" removes outyear escalations), and if that position is a Detention Officer.
4. Enter the company that will employ the FTE in Column F. This can be a subcontractor.
5. Enter the base labor hourly rate In Column G. This is typically the SCA wage determination from the DOL for the position description.
6. In columns H through M, enter the hourly Health and Wellness (H&W), retirement benefits, and other costs as needed per position. Directly re-label any "Other Benefits" columns being used. Column N will calculate based on the values entered.
7. In columns O through R, enter the relevant tax burden for each position type. Columns S and T will calculate based on the values entered.
8. Enter the overtime premium percent for each position in Column U. The OT Premium is the percentage added on to the fully burdened labor rate, expressed as a decimal (for time and a half, enter .5 in Column U).
9. Enter the total annual hours expected for each FTE in column W (typically 2080). In Columns X through AA enter total non productive hours (leave, training, etc.). Column AB will calculate based on inputs.
10. In Column AC enter estimate of annual overtime hours by FTE.
Columns AD through AL will calculate based on the entered values above. Do not enter information into these fields.
Yearly Escalation0.00%0.00%0.00%0.00%
CLIN X002: GM Labor
Labor Price BuildupLabor RateAnnual HoursCost Basis
Base RateBurdeningTaxesFully BurdenedOvertimeTotalNon-Productive HoursProductiveOvertimeTotal HoursBaseOvertimeTotalTotalTotalTotalTotal
Position DescriptionFTE CountCBA or SCA?
(Yes/No)Detention Officer?
(Yes/No)CompanyLabor RateH&WRetirementOther Benefit 1Other Benefit 2Other Benefit 3Other ChargesTotal BenefitsFICAFUTASUTAWorker's CompTotal TaxesFully Burdened RateOT PremiumOT RateTotal HoursHolidaysVacationSickTrainingProductive HoursOvertime HoursTotal Billable Hours
(Per FTE)Grand Total Billable HoursCost per FTECost per FTETotal Cost Base Year
(8 Months)Total Cost OY1
(12 Months)Total Cost OY2
(12 Months)Total Cost OY3
(12 Months)Total Cost OY4

(12 Months)

$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Labor G&A$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Total Billable Hours00000

CLIN X002 - Facilities

Facilities Breakdown
Definition: Facility costs include those costs required to operate facilities in order to directly support transportation of detainees under this contract
(e.g. lease costs, electricity, computers, phones). Complete all costs associated with facilities for BAL. Do not include G&A or Profit.
Costs should reflect one year's worth of facilities operation.
COMPLETION INSTRUCTIONS:
1. Enter an escalation percent for outyear increases in cell G15-J15. This will increase facilities costs by that percentage every year after the baseline.
2. Enter the facility item description in Column B. (Lease, electric, etc.)
3. Enter the total units in Column C. If an annual cost, enter 1. For monthly costs use 12 months.
4. Enter the unit description in Column D (months, year, beds, etc.)
5. Enter the cost per each unit of the item in Column E.
6. Add any comments to provide additional detail or explanation to the cost items in Column K.
Columns F through J will calculate based on the entered values above. Do not enter information into these fields.
Yearly Escalation0.00%0.00%0.00%0.00%
CLIN X002: Facilities
Facility Item DescriptionNumber of UnitsUnit DescriptionCost per UnitTotal Cost Base Year
(8 Months)Total Cost OY1
(12 Months)Total Cost OY2
(12 Months)Total Cost OY3
(12 Months)Total Cost OY4
(12 Months)Comments (Explanation of Costs)
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 0- 0- 0- 0- 0
$ - 0- 0- 0- 0- 0
$ - 0- 0- 0- 0- 0
Facilities Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Facilities G&A$ - 0$ - 0$ - 0$ - 0$ - 0
Facilities Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total Facilities$ - 0$ - 0$ - 0$ - 0$ - 0

CLIN X002 - Other Costs

Other Costs Breakdown
Definition: Other Costs are additional annual costs related to operating this contract that do not fall into a labor, facilities, asset, or transition category (e.g. uniforms, training programs).
Complete all other costs associated with BAL. Do not include G&A or Profit.
COMPLETION INSTRUCTIONS. The fields are free form text that allow you to enter specific costs as needed. There is no drop down selection to choose from.
1. Enter an escalation percent for outyear increases in cell G14-J14. This will increase costs by that percentage every year after the baseline.
2. Input cost items in Column B (e.g. uniforms, etc.)
3. Enter the total number of units in Column C. If a single lump sum cost, enter 1.
4. Enter the unit description in Column D (each, annually, etc.).
4. Enter the cost per each unit of the item in Column E.
5. Add any comments to provide additional detail or explanation to the cost items in Column K.
Columns F through J will calculate based on the entered values above. Do not enter information into these fields.
Yearly Escalation0.00%0.00%0.00%0.00%
CLIN X002: Other Costs
Other Costs Item DescriptionNumber of UnitsUnitCost per UnitTotal Cost Base Year
(8 Months)Total Cost OY1
(12 Months)Total Cost OY2
(12 Months)Total Cost OY3
(12 Months)Total Cost OY4
(12 Months)Comments (Explanation of Costs)
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
Other Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Other Costs G&A$ - 0$ - 0$ - 0$ - 0$ - 0
Other Costs Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total Other Costs$ - 0$ - 0$ - 0$ - 0$ - 0

CLIN X003 - Over GM Labor

Over GM Labor Breakdown
Definition: Over GM Labor costs include those costs that relate directly to the number of additional personnel required in excess of CLIN X002 staffing levels to provide an additional estimated 155,000 miles per year above the 360,000 miles per year guaranteed minimum.
Do not include G&A or Profit.
COMPLETION INSTRUCTIONS:
1. Enter an escalation percent for outyear increases in cell AI17-AL17. This will increase the (non-CBA/SCA) labor costs by that percentage every year after the baseline.
2. Enter the position description in Column B. (Transportation Officer, Supervisor, Project Manager, etc.)
3. In Columns C through E, enter the total number of FTEs needed for each position type, whether that position is under a Collective Bargaining Agreement (CBA) or SCA ("Yes" removes outyear escalations), and if that position is a Detention Officer.
4. Enter the company that will employ the FTE in Column F. Can be a subcontractor.
5. Enter the base labor hourly rate In Column G. This is typically the SCA wage determination from the DOL for the position description.
6. In columns H through M, enter the hourly Health and Wellness (H&W), retirement benefits, and other costs as needed per position. Directly re-label any "Other Benefits" columns being used. Column N will calculate based on the values entered.
7. In columns O through R, enter the relevant tax burden for each position type. Columns S and T will calculate based on the values entered.
8. Enter the overtime premium percent for each position in Column U. The OT Premium is the percentage added on to the fully burdened labor rate, expressed as a decimal. (for time and a half, enter .5 in Column U).
9. Enter the total annual hours expected for each FTE in column W (typically 2080). In Columns X through AA enter total non productive hours (leave, training, etc.). Column AB will calculate based on inputs.
10. In Column AC enter estimate of annual overtime hours by FTE.
Columns AD through AL will calculate based on the entered values above. Do not enter information into these fields.
Yearly Escalation0.00%0.00%0.00%0.00%
CLIN X003: Over GM Labor
Labor Price BuildupLabor RateAnnual HoursCost Basis
Base RateBurdeningTaxesFully BurdenedOvertimeTotalNon-Productive HoursProductiveOvertimeTotal HoursBaseOvertimeTotalTotalTotalTotalTotal
Position DescriptionFTE CountCBA or SCA?
(Yes/No)Detention Officer?
(Yes/No)CompanyLabor RateH&WRetirementOther Benefit 1Other Benefit 2Other Benefit 3Other ChargesTotal BenefitsFICAFUTASUTAWorker's CompTotal TaxesFully Burdened RateOT PremiumOT RateTotal HoursHolidaysVacationSickTrainingProductive HoursOvertime HoursTotal Billable Hours
(Per FTE)Grand Total Billable HoursCost per FTECost per FTETotal Cost Base Year
(103,333 miles)Total Cost OY1
(155,000 miles)Total Cost OY2
(155,000 miles)Total Cost OY3
(155,000 miles)Total Cost OY4

(155,000 miles)

$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
Over GM Labor Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Over GM Labor G&A$ - 0$ - 0$ - 0$ - 0$ - 0
Over GM Labor Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total Over GM Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Total Billable Hours00000

CLIN X003 - Over GM Assets

Over GM Assets Breakdown
Definition: Over GM Asset costs are a build up of the yearly costs associated with operating and maintaining vehicles to support any mileage above the guaranteed minimum mileage of 360,000 miles per year. For existing
vehicles that are required to support mileage above the guaranteed minimum, simply copy the information entered in the "Assets" tab into this tab and adjust Columns D and E appropriately to reflect additional mileage
requirements. Do not include additional Monthly Lease Costs for existing vehicles. Do not include G&A or Profit. Note: Estimated Total Yearly Miles above the guaranteed minimum in Column F shall sum to 155,000 miles per year.
COMPLETION INSTRUCTIONS:
1. Enter an escalation percent for outyear increases in cell L16-O16. This will increase the asset costs by that percentage every year after the baseline.
2. Enter the asset description in Column B. (Specify whether van, sedan, bus, etc.)Annual Over GM Miles155,000
3. Enter the total number of seats available for the asset in Column C.
4. Enter the number of assets of each type in Column D.
5. Input the estimated yearly miles per single vehicle in Column E; Column F will calculate the estimated yearly based on Column D and E.
6. Input the monthly lease or payment amount per vehicle type in Column G.
7. Enter the estimated annual maintenance costs for each vehicle type in Column I.
Columns J through O will calculate based on the entered values above. Do not enter information into these fields.
Yearly Escalation0.00%0.00%0.00%0.00%
CLIN X003: Over GM Assets- 0
Asset DescriptionNumber of SeatsNumber of AssetsEst. Yearly Miles per VehicleEst. Total Yearly Miles
(Column Total Must Equal Annual Over GM Miles [Cell M8])Monthly Lease Rate / Amortization per VehicleYearly Lease / Amortization per VehicleYearly Maintenance Costs per VehicleTotal Yearly Costs per VehicleTotal Cost Base Year
(103,333 miles)Total Cost OY 1
(155,000 miles)Total Cost OY 2
(155,000 miles)Total Cost OY 3
(155,000 miles)Total Cost OY 4

(155,000 miles)

- 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
- 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
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
Over GM Asset Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Over GM Asset G&A$ - 0$ - 0$ - 0$ - 0$ - 0
Over GM Asset Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total Over GM Assets$ - 0$ - 0$ - 0$ - 0$ - 0

CLIN X004-Outside Routes Labor

Outside Primary Routes Labor Breakdown
Definition: Outside Primary Routes Labor costs include those costs that relate directly to the number of additional personnel required in excess of CLIN X002 staffing levels to provide transportation services outside the AOR with the exception of frequent routes as designated by the COR for CLIN X002.
COMPLETION INSTRUCTIONS:
1. Enter an escalation percent for outyear increases in cell AI16-AL16. This will increase the (non-CBA/SCA) labor costs by that percentage every year after the baseline.
2. Enter the position description in Column B. (Transportation Officer, Supervisor, Project Manager, etc.)
3. In Columns C through E, enter the total number of FTEs needed for each position type, whether that position is under a Collective Bargaining Agreement (CBA) or SCA ("Yes" removes outyear escalations), and if that position is a Detention Officer.
4. Enter the company that will employ the FTE in Column F. Can be a subcontractor.
5. Enter the base labor hourly rate In Column G. This is typically the SCA wage determination from the DOL for the position description.
6. In columns H through M, enter the hourly Health and Wellness (H&W), retirement benefits, and other costs as needed per position. Directly re-label any "Other Benefits" columns being used. Column N will calculate based on the values entered.
7. In columns O through R, enter the relevant tax burden for each position type. Columns S and T will calculate based on the values entered.
8. Enter the overtime premium percent for each position in Column U. The OT Premium is the percentage added on to the fully burdened labor rate, expressed as a decimal. (for time and a half, enter .5 in Column U).
9. Enter the total annual hours expected for each FTE in column W (typically 2080). In Columns X through AA enter total non productive hours (leave, training, etc.). Column AB will calculate based on inputs.
10. In Column AC enter estimate of annual overtime hours by FTE.
Columns AD through AL will calculate based on the entered values above. Do not enter information into these fields.
Yearly Escalation0.00%0.00%0.00%0.00%
CLIN X004: Outside Primary Routes Labor
Labor Price BuildupLabor RateAnnual HoursCost Basis
Base RateBurdeningTaxesFully BurdenedOvertimeTotalNon-Productive HoursProductiveOvertimeTotal HoursBaseOvertimeTotalTotalTotalTotalTotal
Position DescriptionFTE CountCBA or SCA?
(Yes/No)Detention Officer?
(Yes/No)CompanyLabor RateH&WRetirementOther Benefit 1Other Benefit 2Other Benefit 3Other ChargesTotal BenefitsFICAFUTASUTAWorker's CompTotal TaxesFully Burdened RateOT PremiumOT RateTotal HoursHolidaysVacationSickTrainingProductive HoursOvertime HoursTotal Billable Hours
(Per FTE)Grand Total Billable HoursCost per FTECost per FTETotal Cost Base Year
(66,667 miles)Total Cost OY1
(100,000 miles)Total Cost OY2
(100,000 miles)Total Cost OY3
(100,000 miles)Total Cost OY4

(100,000 miles)

$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 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
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
Outside Primary Routes Labor Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Outside Primary Routes Labor G&A$ - 0$ - 0$ - 0$ - 0$ - 0
Outside Primary Routes Labor Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total Outside Primary Routes Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Total Billable Hours00000

CLIN X004-Outside Routes Assets

Outside Primary Routes Assets Breakdown
Definition: Outside Primary Routes Asset costs are a build up of the yearly costs associated with operating and maintaining vehicles to support transportation services outside the AOR with the exception of frequent routes as designated by the COR for CLIN X002.
COMPLETION INSTRUCTIONS:
1. Enter an escalation percent for outyear increases in cell L14-O14. This will increase the asset costs by that percentage every year after the baseline.
2. Enter the asset description in Column B. (Specify whether van, sedan, bus, etc.)
3. Enter the total number of seats available for the asset in Column C.
4. Enter the number of assets of each type in Column D.
5. Input the estimated yearly miles per single vehicle in Column E; Column F will calculate the estimated yearly based on Column D and E.
6. Input the monthly lease or payment amount per vehicle type in Column G.
7. Enter the estimated annual maintenance costs for each vehicle type in Column I.
Columns J through O will calculate based on the entered values above. Do not enter information into these fields.
Yearly Escalation0.00%0.00%0.00%0.00%Annual Outside Primary Routes Miles100,000
CLIN X004: Outside Primary Routes Assets- 0
Asset DescriptionNumber of SeatsNumber of AssetsEst. Yearly Miles per VehicleEst. Total Yearly Miles
(Column Total Must Equal Annual Miles [Cell S14])Monthly Lease Rate / Amortization per VehicleYearly Lease / Amortization per VehicleYearly Maintenance Costs per VehicleTotal Yearly Costs per VehicleTotal Cost Base Year
(66,667 miles)Total Cost OY 1
(100,000 miles)Total Cost OY 2
(100,000 miles)Total Cost OY 3
(100,000 miles)Total Cost OY 4

(100,000 miles)

- 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
- 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
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
Outside Primary Routes Asset Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Outside Primary Routes Asset G&A$ - 0$ - 0$ - 0$ - 0$ - 0
Outside Primary Routes Asset Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total Outside Primary Routes Assets$ - 0$ - 0$ - 0$ - 0$ - 0

CLIN X005-Station. Guard Hours

Stationary Guard Hours Breakdown
Definition: Stationary Guard Hours include labor hours outside of CLINs X002, X003, and X004 that are required to perform guard post duties for medical runs, court trips, monitoring detainee hotel stays, etc. and additional wait time or delay, caused through
no fault by the contractor, outside of the included 1 hour start/stop/end wait period in CLINs X002, X003 and X004. Time is recognized on a quarter-hourly basis.
Do not include G&A or Profit. NOTE: Historical data indicates an annual requirement of approximately 12,000 stationary labor hours for BAL.
COMPLETION INSTRUCTIONS:
1. Enter an escalation percent for outyear increases in cell AI18-AL18. This will increase the (non-CBA/SCA) labor costs by that percentage every year after the baseline.
2. Enter the position description in Column B. (Transportation Officer, etc.)
3. In Columns D through E, enter whether that position is under a Collective Bargaining Agreement (CBA) or SCA ("Yes" removes outyear escalations), and if that position is a Detention Officer. Column C will calculate based on the inputs from steps 5 and 9.
4. Enter the company that will employ the FTE in Column F. Can be a subcontractor.
5. Enter the base labor hourly rate In Column G. This is typically the SCA wage determination from the DOL for the position description.
6. In columns H through M, enter the hourly Health and Wellness (H&W), retirement benefits, and other costs as needed per position. Directly re-label any "Other Benefits" columns being used. Column N will calculate based on the values entered.
7. In columns O through R, enter the relevant tax burden for each position type. Columns S and T will calculate based on the values entered.
8. Enter the overtime premium percent for each position in Column U. Enter as a decimal as the overtime percentage only. (for time and a half, enter .5 in Column U).
9. Enter the total annual hours expected for each FTE in column W (typically 2080). In Columns X through AA enter total non productive hours (leave, training, etc.). Column AB will calculate based on inputs.
10. In Column AC enter estimate of annual overtime hours by FTE.
Columns AD through AL will calculate based on the entered values above. Do not enter information into these fields.
Yearly Escalation0.00%0.00%0.00%0.00%
CLIN X005: Stationary Guard Hours
Labor Price BuildupLabor RateAnnual HoursCost Basis
Base RateBurdeningTaxesFully BurdenedOvertimeTotalNon-Productive HoursProductiveOvertimeTotal HoursBaseOvertimeTotalTotalTotalTotalTotal
Position DescriptionFTE CountCBA or SCA?
(Yes/No)Detention Officer?
(Yes/No)CompanyLabor RateH&WRetirementOther Benefit 1Other Benefit 2Other Benefit 3Other ChargesTotal BenefitsFICAFUTASUTAWorker's CompTotal TaxesFully Burdened RateOT PremiumOT RateTotal HoursHolidaysVacationSickTrainingProductive HoursOvertime HoursTotal Billable Hours
(Per FTE)Grand Total Billable HoursCost per FTECost per FTETotal Cost Base Year
(8,000 hours)Total Cost OY1
(12,000 hours)Total Cost OY2
(12,000 hours)Total Cost OY3
(12,000 hours)Total Cost OY4

(12,000 hours)

$ - 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
$ - 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
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Stationary Guard Hours Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Stationary Guard Hours G&A$ - 0$ - 0$ - 0$ - 0$ - 0
Stationary Guard Hours Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total Stationary Guard Hours$ - 0$ - 0$ - 0$ - 0$ - 0
Total Billable Hours00000

G&A and Profit

Input G&A expense as a percentage of the total cost for each category (including all other indirect costs as a "wrap" rate) .
Input profit margin for each category of costs.
G&A
Base Year (%)OY1 (%)OY2 (%)OY3 (%)OY4 (%)
CLIN X001 - Transition----
CLIN X002 - Assets
CLIN X002 - Labor
CLIN X002 - Facilities
CLIN X002 - Other Costs
CLIN X003 - Over GM Assets
CLIN X003 - Over GM Labor
CLIN X004- Outside Primary Routes Labor
CLIN X004- Outside Primary Routes Assets
CLIN X005 - Stationary Guard Hours
Profit
Base Year (%)OY1 (%)OY2 (%)OY3 (%)OY4 (%)
CLIN X001 - Transition----
CLIN X002 - Assets
CLIN X002 - Labor
CLIN X002 - Facilities
CLIN X002 - Other Costs
CLIN X003 - Over GM Assets
CLIN X003 - Over GM Labor
CLIN X004- Outside Primary Routes Labor
CLIN X004- Outside Primary Routes Assets
CLIN X005 - Stationary Guard Hours

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