The file's text, extracted by GovTribe without its formatting.
CLIN Breakdown
| Summary Definitions: |
| NOTE: After the 90-day Transition period in CLIN 0001, the base year CLINs 0002-0007 reflect the remaining 9 months of the base year and pro-rate the full year |
| quantities and costs detailed in this cost build-up at 75% of the annual totals. |
| 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, fuel, maintenance, management, |
| overhead/G&A, and profit to meet the requirements outlined in the PWS for 100,000 miles per month. Only miles that are driven with detainees on board |
| are included. |
| CLIN X003A/X003B: Is not to exceed 1,030,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 up to 1,030,000 miles per year. Only miles that are driven with detainees on board are included. All miles and hours requested by ERO |
| shall be billed against the CLIN X003A series, and all miles and hours requested by HSI shall be billed against the CLIN X003B series. |
| CLIN X004: Stationary and Delay Hours include additional wait time or delay, caused through no fault by the contractor, outside of the included 1 hour |
| start/stop/end wait period in CLIN X002 and X003. |
| CLIN X005A/X005B: Remote Post Guard Hours include labor hours outside of CLIN X002, CLIN X003, and CLIN X004 that are required to perform guard post duties for |
| medical runs, court trips, monitoring detainee hotel stays, etc. All miles and hours requested by ERO shall be billed against the CLIN X005A series, and all miles |
| and hours requested by HSI shall be billed against the CLIN X005B series. |
| CLIN X006: Per Diem and Hotel will only be considered for travel outside of the Texas counties in Attachment 1 or to adjoining states, HSI extended operations |
| or mass evacuations. All travel shall occur in accordance with the Federal Travel regulation (FTR) and approved in advance by the Contracting Officer Representative |
| (COR) or will not be reimbursed. |
| CLIN X007: Sack Lunches for detainees. |
| CLIN Breakdown | | | | | |
| | Rate | Quantity | Unit | Total |
| 0001 | Transition (90 days) | $ - 0 | 1 | EA | $ - 0 |
| 0002 | Guaranteed Minimum Miles & Guard Hours | $ - 0 | 9 | Months | $ - 0 |
| 0003A | Over GM Miles and Guard Hours - ERO | $ - 0 | 750,000 | Miles | $ - 0 |
| 0003B | Over GM Miles and Guard Hours - HSI | $ - 0 | 22,500 | Miles | $ - 0 |
| 0004 | Stationary and Delay Hours | $ - 0 | 32,400 | Hours | $ - 0 |
| 0005A | Remote Post Guard Hours - ERO | $ - 0 | 3,150 | Hours | $ - 0 |
| 0005B | Remote Post Guard Hours - HSI | $ - 0 | 3,825 | Hours | $ - 0 |
| 0006 | Per Diem | $ 37,500.00 | 1 | Lot | $ 37,500.00 NTE |
| 0007 | Sack Lunches | $ - 0 | 36,000 | EA | $ - 0 |
| Base Year | | | | | $ 37,500.00 |
| 1002 | Guaranteed Minimum Miles & Guard Hours | $ - 0 | 12 | Months | $ - 0 |
| 1003A | Over GM Miles and Guard Hours - ERO | $ - 0 | 1,000,000 | Miles | $ - 0 |
| 1003B | Over GM Miles and Guard Hours - HSI | $ - 0 | 30,000 | Miles | $ - 0 |
| 1004 | Stationary and Delay Hours | $ - 0 | 43,200 | Hours | $ - 0 |
| 1005A | Remote Post Guard Hours - ERO | $ - 0 | 4,200 | Hours | $ - 0 |
| 1005B | Remote Post Guard Hours - HSI | $ - 0 | 5,100 | Hours | $ - 0 |
| 1006 | Per Diem | $ 50,000.00 | 1 | Lot | $ 50,000.00 NTE |
| 1007 | Sack Lunches | $ - 0 | 48,000 | EA | $ - 0 |
| OY 1 | | | | | $ 50,000.00 |
| 2002 | Guaranteed Minimum Miles & Guard Hours | $ - 0 | 12 | Months | $ - 0 |
| 2003A | Over GM Miles and Guard Hours - ERO | $ - 0 | 1,000,000 | Miles | $ - 0 |
| 2003B | Over GM Miles and Guard Hours - HSI | $ - 0 | 30,000 | Miles | $ - 0 |
| 2004 | Stationary and Delay Hours | $ - 0 | 43,200 | Hours | $ - 0 |
| 2005A | Remote Post Guard Hours - ERO | $ - 0 | 4,200 | Hours | $ - 0 |
| 2005B | Remote Post Guard Hours - HSI | $ - 0 | 5,100 | Hours | $ - 0 |
| 2006 | Per Diem | $ 50,000.00 | 1 | Lot | $ 50,000.00 NTE |
| 2007 | Sack Lunches | $ - 0 | 48,000 | EA | $ - 0 |
| OY 2 | | | | | $ 50,000.00 |
| 3002 | Guaranteed Minimum Miles & Guard Hours | $ - 0 | 12 | Months | $ - 0 |
| 3003A | Over GM Miles and Guard Hours - ERO | $ - 0 | 1,000,000 | Miles | $ - 0 |
| 3003B | Over GM Miles and Guard Hours - HSI | $ - 0 | 30,000 | Miles | $ - 0 |
| 3004 | Stationary and Delay Hours | $ - 0 | 43,200 | Hours | $ - 0 |
| 3005A | Remote Post Guard Hours - ERO | $ - 0 | 4,200 | Hours | $ - 0 |
| 3005B | Remote Post Guard Hours - HSI | $ - 0 | 5,100 | Hours | $ - 0 |
| 3006 | Per Diem | $ 50,000.00 | 1 | Lot | $ 50,000.00 NTE |
| 3007 | Sack Lunches | $ - 0 | 48,000 | EA | $ - 0 |
| OY 3 | | | | | $ 50,000.00 |
| 4002 | Guaranteed Minimum Miles & Guard Hours | $ - 0 | 12 | Months | $ - 0 |
| 4003A | Over GM Miles and Guard Hours - ERO | $ - 0 | 1,000,000 | Miles | $ - 0 |
| 4003B | Over GM Miles and Guard Hours - HSI | $ - 0 | 30,000 | Miles | $ - 0 |
| 4004 | Stationary and Delay Hours | $ - 0 | 43,200 | Hours | $ - 0 |
| 4005A | Remote Post Guard Hours - ERO | $ - 0 | 4,200 | Hours | $ - 0 |
| 4005B | Remote Post Guard Hours - HSI | $ - 0 | 5,100 | Hours | $ - 0 |
| 4006 | Per Diem | $ 50,000.00 | 1 | Lot | $ 50,000.00 NTE |
| 4007 | Sack Lunches | $ - 0 | 48,000 | EA | $ - 0 |
| OY 4 | | | | | $ 50,000.00 |
Total Evaluated Price $ 237,500.00
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. 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. |
| Transition Item Description | Number of Units for Transition | Unit Description | Cost per Unit | Total Transition Costs | 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 | |
| | | Transition Costs | $ - 0 | |
| | | Transition G&A | $ - 0 | |
| | | Transition Profit | $ - 0 | |
| | | Transition Grand Total | $ - 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 100,000 miles per month. Do not include G&A or Profit. | | | | | | | | | | | | | | |
| | COMPLETION INSTRUCTIONS: | | | | | | | | | | | | | | |
| | 1. Enter an escalation percent for outyear increases in cell 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 a baseline fuel cost per gallon and the average MPG by vehicle type in Columns I and J. | | | | | | | | | | | | | | |
| | 8. Enter the estimated annual maintenance costs for each vehicle type in Column L. | | | | | | | | | | | | | | |
| | Columns M through R will calculate based on the entered values above. Do not enter information into these fields. | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | 0.00% | Yearly Escalation |
| | Asset Description | Number of Seats | Number of Assets | Est. Yearly Miles per Vehicle | Est. Total Yearly Miles | Monthly Lease Rate / Amortization per Vehicle | Yearly Lease / Amortization per Vehicle | Cost per Gallon | Average MPGs | Yearly Fuel Costs per Vehicle | Yearly Maintenance Costs per Vehicle | Total Yearly Costs per Vehicle | Grand Total Base Year | | |
| (9 Months) | Grand Total OY 1 | | | | | | | | | | | | | | | |
| (12 Months) | Grand Total OY 2 | | | | | | | | | | | | | | | |
| (12 Months) | Grand Total OY 3 | | | | | | | | | | | | | | | |
| (12 Months) | Grand Total 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 |
| Total 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 Miles | 900,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,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 100,000 miles per month. Do not include G&A or Profit. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | COMPLETION INSTRUCTIONS: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | 1. Enter an escalation percent for outyear increases in cell AI16. This will increase the 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), 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. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0.00% | Yearly Escalation | | |
| | Labor Price Buildup | | | | | Labor Rate | | | | | | | | | | | | | | | | Annual Hours | | | | | | | | | | Cost Basis | | | | | |
| | | | | | | Base Rate | Burdening | | | | | | | Taxes | | | | | Fully Burdened | Overtime | | Base | Non-Productive Hours | | | | Hours | Hours | Hours | Hours | Base | Overtime | Total | Total | Total | Total | Total |
| | Position Description | FTE Count | CBA or SCA? | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (Yes/No) | Detention Officer? (Yes/No) | Company | Labor Rate | H&W | Retirement | Other Benefit 1 | Other Benefit 2 | Other Benefit 3 | Other Charges | Total Benefits | FICA | FUTA | SUTA | Worker's Comp | Total Taxes | Fully Burdened Rate | OT Premium | OT Rate | Total | Holidays | Vacation | Sick | Training | Productive | Overtime | Total Billable Hours | Grand Total Billable Hours | Cost per FTE | Cost per FTE | Total Cost Base Year | | | | | | | | |
| (9 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 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 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 Total | $ - 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 Hours | 0 | 0 | 0 | 0 | 0 |
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). 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 G14. 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. |
| | | | | | | 0.00% | Yearly Escalation | | |
| | Facility Item Description | Number of Units | Unit Description | Cost per Unit | Total Cost Base Year | | | | |
| (9 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 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 0 | - 0 | - 0 | - 0 |
| | | | | | $ - 0 | - 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. 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 G13. This will increase costs by that percentage every year after the baseline. |
| 2. Input cost items in Column B (Ex. 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. |
| | | | | | | 0.00% | Yearly Escalation | | |
| | Other Costs Item Description | Number of Units | Unit | Cost per Unit | Total Cost Base Year | | | | |
| (9 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 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | Total 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 X003A,B - 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 100,000 miles per month. | | | | | | | | |
| | 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 E and L 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 1,030,000 miles per year, for which 1,000,000 miles will be attributable to CLIN X003A (ERO Above-GM Miles and Labor), and 30,000 miles will be attributable to CLIN X003B (HSI Above-GM Miles and Labor). | | | | | | | | |
| | COMPLETION INSTRUCTIONS: | | | | | | | | |
| | 1. Enter an escalation percent for outyear increases in cell O17. 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 a baseline fuel cost per gallon and the average MPG by vehicle type in Columns I and J. | | | | | | | | |
| | 8. Enter the estimated annual maintenance costs for each vehicle type in Column L. | | | | | | | | |
| | Columns M through R will calculate based on the entered values above. Do not enter information into these fields. | | | | | | | | |
| | | | | | | | | 0.00% | Yearly Escalation |
| | Asset Description | Number of Seats | Number of Assets | Est. Yearly Miles per Vehicle | Est. Total Yearly Miles | | | | |
| (Total 1,030,000 Miles) | Monthly Lease Rate / Amortization per Vehicle | Yearly Lease / Amortization per Vehicle | Cost per Gallon | Average MPGs | Yearly Fuel Costs per Vehicle | Yearly Maintenance Costs per Vehicle | Total Yearly Costs per Vehicle | Grand Total Base Year | | |
| (772,500 miles) | Grand Total OY 1 | | | | | | | | | |
| (1,030,000 miles) | Grand Total OY 2 | | | | | | | | | |
| (1,030,000 miles) | Grand Total OY 3 | | | | | | | | | |
| (1,030,000 miles) | Grand Total OY 4 | | | | | | | | | |
(1,030,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 |
| Total Over GM Asset Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Over GM Asset G&A | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Over GM Asset Profit | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Grand Total Over GM Assets | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
CLIN X003A,B - 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 1,030,000 miles per year above the 100,000 miles per month guaranteed | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | minimum, for which 1,000,000 miles will be attributable to CLIN X003A (ERO Above-GM Miles and Labor), and 30,000 miles will be attributable to CLIN X003B (HSI Above-GM Miles and Labor). Do not include G&A or Profit. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | COMPLETION INSTRUCTIONS: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | 1. Enter an escalation percent for outyear increases in cell AI17. This will increase the 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), 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. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0.00% | Yearly Escalation | | |
| | Labor Price Buildup | | | | Labor Rate | | | | | | | | | | | | | | | | Annual Hours | | | | | | | | | Cost Basis | | | | | |
| | | | | | Base Rate | Burdening | | | | | | | Taxes | | | | | Fully Burdened | Overtime | | Base | Non-Productive Hours | | | Hours | Overtime | Hours | Hours | Base | Overtime | Total | Total | Total | Total | Total |
| | Position Description | FTE Count | CBA or SCA? | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (Yes/No) | Detention Officer? | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (Yes/No) | Company | Labor Rate | H&W | Retirement | Other Benefit 1 | Other Benefit 2 | Other Benefit 3 | Other Charges | Total Benefits | FICA | FUTA | SUTA | Worker's Comp | Total Taxes | Fully Burdened Rate | OT Premium | OT Rate | Total | Holidays | Vacation | Sick | Training | Productive | Overtime | Total Billable Hours | | | | | | | | | | | |
| (Per FTE) | Grand Total Billable Hours | Cost per FTE | Cost per FTE | Total Cost Base Year | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (772,500 miles) | Total Cost OY1 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (1,030,000 miles) | Total Cost OY2 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (1,030,000 miles) | Total Cost OY3 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (1,030,000 miles) | Total Cost OY4 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
(1,030,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 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | | | $ - 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 Total | $ - 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 Hours | 0 | 0 | 0 | 0 | 0 |
CLIN X004- Station. Delay Hours
| | Stationary and Delay Hours Breakdown | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | Definition: Stationary and Delay Hours include additional wait time or delay, caused through no fault by the contractor, outside of the included 1 hour start/stop/end wait period in CLIN X002 and X003. Time | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | is recognized on a quarter-hourly basis. Do not include G&A or Profit. NOTE: Historical data indicates an annual requirement of 43,200 stationary and delay labor hours (3,600 hours per month x 12 months). | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | COMPLETION INSTRUCTIONS: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | 1. Enter an escalation percent for outyear increases in cell AI17. This will increase the 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), 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. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0.00% | Yearly Escalation | | |
| | Labor Price Buildup | | | | Labor Rate | | | | | | | | | | | | | | | | Annual Hours | | | | | | | | | Cost Basis | | | | | |
| | | | | | Base Rate | Burdening | | | | | | | Taxes | | | | | Fully Burdened | Overtime | | Base | Non-Productive Hours | | | Hours | Overtime | Hours | Hours | Base | Overtime | Total | Total | Total | Total | Total |
| | Position Description | FTE Count | CBA or SCA? | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (Yes/No) | Detention Officer? | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (Yes/No) | Company | Labor Rate | H&W | Retirement | Other Benefit 1 | Other Benefit 2 | Other Benefit 3 | Other Charges | Total Benefits | FICA | FUTA | SUTA | Worker's Comp | Total Taxes | Fully Burdened Rate | OT Premium | OT Rate | Total | Holidays | Vacation | Sick | Training | Productive | Overtime | Total Billable Hours | | | | | | | | | | | |
| (Per FTE) | Grand Total Billable Hours | Cost per FTE | Cost per FTE | Total Cost Base Year | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (32,400 hours) | Total Cost OY1 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (43,200 hours) | Total Cost OY2 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (43,200 hours) | Total Cost OY3 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (43,200 hours) | Total Cost OY4 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
(43,200 hours)
| $ - 0 | 0 | | | | | | |
| | Stationary and Delay Hours Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | Stationary and Delay Hours G&A | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | Stationary and Delay Hours Profit | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | Grand Total Stationary and Delay Hours | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | Total Billable Hours | 0 | 0 | 0 | 0 | 0 |
CLIN X005A,B- Remote Post Labor
| | Remote Post Guard Hours Breakdown | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | Definition: Remote Post Guard Hours include labor hours outside of CLIN X002, CLIN X003, and CLIN X004 that are required to perform guard post duties for medical runs, court trips, monitoring detainee hotel stays, etc. Time is recognized on a | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | quarter-hourly basis. Do not include G&A or Profit. NOTE: Historical data indicates an annual requirement of 9,300 remote post labor hours, for which 4,200 hours will be attributable to CLIN X005A (ERO Remote Post Guard Hours), and 5,100 hours | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | will be attributable to CLIN X005B (HSI Remote Post Guard Hours). | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | COMPLETION INSTRUCTIONS: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | 1. Enter an escalation percent for outyear increases in cell AI18. This will increase the 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), 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. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0.00% | Yearly Escalation | | |
| | Labor Price Buildup | | | | Labor Rate | | | | | | | | | | | | | | | | Annual Hours | | | | | | | | | Cost Basis | | | | | |
| | | | | | Base Rate | Burdening | | | | | | | Taxes | | | | | Fully Burdened | Overtime | | Base | Non-Productive Hours | | | Hours | Overtime | Hours | Hours | Base | Overtime | Total | Total | Total | Total | Total |
| | Position Description | FTE Count | CBA or SCA? | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (Yes/No) | Detention Officer? | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (Yes/No) | Company | Labor Rate | H&W | Retirement | Other Benefit 1 | Other Benefit 2 | Other Benefit 3 | Other Charges | Total Benefits | FICA | FUTA | SUTA | Worker's Comp | Total Taxes | Fully Burdened Rate | OT Premium | OT Rate | Total | Holidays | Vacation | Sick | Training | Productive | Overtime | Total Billable Hours | | | | | | | | | | | |
| (Per FTE) | Grand Total Billable Hours | Cost per FTE | Cost per FTE | Total Cost Base Year | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (6,975 hours) | Total Cost OY1 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (9,300 hours) | Total Cost OY2 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (9,300 hours) | Total Cost OY3 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (9,300 hours) | Total Cost OY4 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
(9,300 hours)
| $ - 0 | 0 | | | | | | |
| | Remote Post Guard Hours Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | Remote Post Guard Hours G&A | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | Remote Post Guard Hours Profit | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | Grand Total Remote Post Guard Hours | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | Total Billable Hours | 0 | 0 | 0 | 0 | 0 |
CLIN X007 - Sack Lunches
| Sack Lunches Breakdown |
| Definition: Sack Lunches. Do not include G&A or Profit. Note: Historical data indicates that approximately 48,000 sack lunches were required annually. |
| COMPLETION INSTRUCTIONS: |
| 1. Enter the description in Column B, the unit of measure (generally "Each") in Column D, and Cost per lunch in Column E. |
| 2. Enter an escalation percent for outyear increases in cell G8. This will increase sack lunch costs by that percentage every year after the baseline. |
| | | | | | | 0.00% | Yearly Escalation | | |
| | Sack Lunch Item Description | Number of Units | Unit | Cost per Unit | Total Cost Base Year | | | | |
| (36,000 lunches) | Total Cost OY1 | | | | | | | | | |
| (48,000 lunches) | Total Cost OY2 | | | | | | | | | |
| (48,000 lunches) | Total Cost OY3 | | | | | | | | | |
| (48,000 lunches) | Total Cost OY4 | | | | | | | | | |
| (48,000 lunches) | Comments (Explanation of Costs) | | | | | | | | | |
| | | 48,000 | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| | | | | Total Sack Lunches | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
This is the start of the file's text. The full file is on GovTribe.