C5613137-D_-_Exhibit_B-1.1-1.5_-_Budget_Rate_Sheet.xlsx

XLSX spreadsheet 55 KB Posted

Attached to
C5613137-D - Day Reporting Center (DRC)
Solicitation number
0000037692
Issued by
Contra Costa County, Fresno County, Contra Costa Centre CDP, Fresno City, California

About this file

This is a Budget Rate Sheet document for the California Department of Corrections and Rehabilitation's Day Reporting Center (DRC) services procurement (IFB Number C5613137-D) for Contra Costa County and Fresno County. The budget rate sheets cover five fiscal years: FY 2026-27 through FY 2030-31, with the latter two years being optional renewal periods. The required staffing positions include a Program Director, Caseworker Supervisor, Cognitive Behavioral Therapy (CBT) Facilitator, Caseworkers, Community Navigator, Job/Career Developer, Certified Alcohol and Other Drug (AOD) Counselor, and Residential Rapid Rehousing (RRH) Placement Coordinator. Respondents must ensure their proposed positions meet the required staffing ratios outlined in the Scope of Work, and proposals that do not meet these ratio requirements may be subject to disqualification.

Bidders must complete detailed budget rate sheets detailing personnel costs, subcontractor/consultant costs, and operating costs, and must submit a comprehensive Justification Statement explaining the basis for each cost breakdown and the methodology used to calculate line items. The Justification Statement must address personnel salary calculations, subcontractor cost justification, operating cost derivations including material quantities and unit costs, and the rationale for indirect costs, profit/service fees, and operating reserve percentages. Contractors must account for year-over-year salary, benefits, and cost-of-living adjustments over the entire contract term, and agreed-upon budgets will be incorporated into the executed contract with no subsequent alterations permitted. All positions listed in the budget must be identified in the initial proposal, as positions cannot be added after contract execution and positions not listed cannot be billed to the DRC.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

In addition to the Budget Rate Sheets, bidders must provide a Justification Statement explaining the basis for each total provided in the cost breakdown. The Justification Statement should outline the approach and assumptions used to calculate the line items in each Category. Provided line items as an example:

• Personnel Costs: Provide an explanation of how the budgeted rate was calculated and the basis for salary estimates (e.g., historical data, prevailing wage rates, union rates, etc.).

• Subcontractor Costs: If applicable, explain how subcontractor bids were obtained and how subcontractor costs were factored into the overall pricing.

• Operating Costs: Specify how material quantities and unit costs were derived, including references to any suppliers, catalog pricing, or historical pricing data.

• Indirect Costs, Profits/Service Fee and Operating Reserve/Contingency Fund: Provide a rationale for the percentages used and explain any factors that influenced these figures (e.g., project complexity, risk factors).

The Justification Statement should be sufficiently detailed to demonstrate that the bidder has fully accounted for all Exhibit A, Scope of Work requirements, potential risks, and contingencies in their pricing.

TBB

California Department of Corrections and Rehabilitation Budget Rate Sheet Instructions IFB Number C5613137-D Exhibit B-1.1 - B-1.5

B-1.1 FY 26-27

BUDGET RATE SHEET
Day Reporting Center
County:
Fiscal Year 2026/2027
July 1, 2026 - June 30, 2027
Category
A.PERSONNELNumber of Positions*Monthly Salary Rate**Hourly Rate**% of Project Time***Number of Months or
Hours per YearTOTAL****
MonthsHours
*****REQUIRED POSITIONS:
Program Director
Caseworker Supervisor
CBT Faciltator
Caseworker
Community Navigator
Job/Career Developer
Certified AOD Counselor
RRH Placement Coordinator
OTHER PERSONNEL COSTS (BENEFITS, RETENTION ALLOWANCES, BILINGUAL PAY, OVERTIME, TEMPORARY HELP)$ - 0
(Budget Transfer Requests are only allowable within the Personnel Services Category)TOTAL PERSONNEL COSTS (A)$ - 0
B.SUBCONTRACTORS/CONSULTANT COSTS
Service Type
$ - 0
$ - 0
$ - 0
$ - 0
TOTAL SUBCONTRACTORS/CONSULTANT COSTS (B)$ - 0
C.OPERATING COSTS (Refer to Exhibit H, Line Item Budget Guide (LIBG) for allowable costs)TOTAL OPERATING COSTS (C)$ - 0
SUBTOTAL ANNUAL DIRECT EXPENSES (SUM OF A+C)$ - 0
D.TOTAL INDIRECT COSTS
(Refer to Exhibit H, Line Item Budget Guide (LIBG) for allowable costs)Percentage of Subtotal Annual Direct Expenses =%$ - 0
E.PROFITS/SERVICE FEEPercentage of Subtotal Annual Direct Expenses =%$ - 0
F.OPERATING RESERVE/CONTINGENCY FUNDPercentage of Subtotal Annual Direct Expenses =%$ - 0
TOTAL BUDGET FOR FISCAL YEAR (SUM OF A+B+C+D+E+F)$ - 0
The Contractor must refer to Exhibit H, Line Item Budget Guide (LIBG) for all items defined in this Budget Rate Sheet.
The Contractor MUST account for year-over-year salary, benefits and cost of living adjustments over the term of the Agreement. Agreed upon budgets will be incorporated into the contract and subsequent alterations are not allowable.
*Respondents are responsible for ensuring positions listed meet the required ratios outlined in the Scope of Work. Proposals submitted that do not meet the ratio requirements may be disqualified.
**Respondents are responsible for determining whether a position is salaried or hourly.
***Where not specified, Respondents are responsible for identifying the percentage of time the position will be dedicated to the DRC.
****Totals for positions shall be calculated by multiplying the Number of Positions by the Monthly Salary Rate by the Number of Months per Year or the Number of Positions by the Hourly Rate by the Number of Hours per Year.
*****Respondents are required to list every position needed to operate the DRC. Positions not listed cannot be billed to the DRC. Changes to positions cannot be made after the contract is executed.

&11TBB

Budget Rate Sheet &11IFB Number C5613137-D Exhibit B-1.1

B-1.2 FY 27-28

BUDGET RATE SHEET
Day Reporting Center
County:
Fiscal Year 2027/2028
July 1, 2027 - June 30, 2028
Category
A.PERSONNELNumber of Positions*Monthly Salary Rate**Hourly Rate**% of Project Time***Number of Months or
Hours per YearTOTAL****
MonthsHours
*****REQUIRED POSITIONS:
Program Director
Caseworker Supervisor
CBT Faciltator
Caseworker
Community Navigator
Job/Career Developer
Certified AOD Counselor
RRH Placement Coordinator
OTHER PERSONNEL COSTS (BENEFITS, RETENTION ALLOWANCES, BILINGUAL PAY, OVERTIME, TEMPORARY HELP)$ - 0
(Budget Transfer Requests are only allowable within the Personnel Services Category)TOTAL PERSONNEL COSTS (A)$ - 0
B.SUBCONTRACTORS/CONSULTANT COSTS
Service Type
$ - 0
$ - 0
$ - 0
$ - 0
TOTAL SUBCONTRACTORS/CONSULTANT COSTS (B)$ - 0
C.OPERATING COSTS (Refer to Exhibit H, Line Item Budget Guide (LIBG) for allowable costs)TOTAL OPERATING COSTS (C)$ - 0
SUBTOTAL ANNUAL DIRECT EXPENSES (SUM OF A+C)$ - 0
D.TOTAL INDIRECT COSTS
(Refer to Exhibit H, Line Item Budget Guide (LIBG) for allowable costs)Percentage of Subtotal Annual Direct Expenses =%$ - 0
E.PROFITS/SERVICE FEEPercentage of Subtotal Annual Direct Expenses =%$ - 0
F.OPERATING RESERVE/CONTINGENCY FUNDPercentage of Subtotal Annual Direct Expenses =%$ - 0
TOTAL BUDGET FOR FISCAL YEAR (SUM OF A+B+C+D+E+F)$ - 0
The Contractor must refer to Exhibit H, Line Item Budget Guide (LIBG) for all items defined in this Budget Rate Sheet.
The Contractor MUST account for year-over-year salary, benefits and cost of living adjustments over the term of the Agreement. Agreed upon budgets will be incorporated into the contract and subsequent alterations are not allowable.
*Respondents are responsible for ensuring positions listed meet the required ratios outlined in the Scope of Work. Proposals submitted that do not meet the ratio requirements may be disqualified.
**Respondents are responsible for determining whether a position is salaried or hourly.
***Where not specified, Respondents are responsible for identifying the percentage of time the position will be dedicated to the DRC.
****Totals for positions shall be calculated by multiplying the Number of Positions by the Monthly Salary Rate by the Number of Months per Year or the Number of Positions by the Hourly Rate by the Number of Hours per Year.
*****Respondents are required to list every position needed to operate the DRC. Positions not listed cannot be billed to the DRC. Changes to positions cannot be made after the contract is executed.

Budget Rate Sheet &11IFB Number C5613137-D Exhibit B-1.2

B-1.3 FY 28-29

BUDGET RATE SHEET
Day Reporting Center
County:
Fiscal Year 2028/2029
July 1, 2028 - June 30, 2029
Category
A.PERSONNELNumber of Positions*Monthly Salary Rate**Hourly Rate**% of Project Time***Number of Months or
Hours per YearTOTAL****
MonthsHours
*****REQUIRED POSITIONS:
Program Director
Caseworker Supervisor
CBT Faciltator
Caseworker
Community Navigator
Job/Career Developer
Certified AOD Counselor
RRH Placement Coordinator
OTHER PERSONNEL COSTS (BENEFITS, RETENTION ALLOWANCES, BILINGUAL PAY, OVERTIME, TEMPORARY HELP)$ - 0
(Budget Transfer Requests are only allowable within the Personnel Services Category)TOTAL PERSONNEL COSTS (A)$ - 0
B.SUBCONTRACTORS/CONSULTANT COSTS
Service Type
$ - 0
$ - 0
$ - 0
$ - 0
TOTAL SUBCONTRACTORS/CONSULTANT COSTS (B)$ - 0
C.OPERATING COSTS (Refer to Exhibit H, Line Item Budget Guide (LIBG) for allowable costs)TOTAL OPERATING COSTS (C)$ - 0
SUBTOTAL ANNUAL DIRECT EXPENSES (SUM OF A+C)$ - 0
D.TOTAL INDIRECT COSTS
(Refer to Exhibit H, Line Item Budget Guide (LIBG) for allowable costs)Percentage of Subtotal Annual Direct Expenses =%$ - 0
E.PROFITS/SERVICE FEEPercentage of Subtotal Annual Direct Expenses =%$ - 0
F.OPERATING RESERVE/CONTINGENCY FUNDPercentage of Subtotal Annual Direct Expenses =%$ - 0
TOTAL BUDGET FOR FISCAL YEAR (SUM OF A+B+C+D+E+F)$ - 0
The Contractor must refer to Exhibit H, Line Item Budget Guide (LIBG) for all items defined in this Budget Rate Sheet.
The Contractor MUST account for year-over-year salary, benefits and cost of living adjustments over the term of the Agreement. Agreed upon budgets will be incorporated into the contract and subsequent alterations are not allowable.
*Respondents are responsible for ensuring positions listed meet the required ratios outlined in the Scope of Work. Proposals submitted that do not meet the ratio requirements may be disqualified.
**Respondents are responsible for determining whether a position is salaried or hourly.
***Where not specified, Respondents are responsible for identifying the percentage of time the position will be dedicated to the DRC.
****Totals for positions shall be calculated by multiplying the Number of Positions by the Monthly Salary Rate by the Number of Months per Year or the Number of Positions by the Hourly Rate by the Number of Hours per Year.
*****Respondents are required to list every position needed to operate the DRC. Positions not listed cannot be billed to the DRC. Changes to positions cannot be made after the contract is executed.

Budget Rate Sheet &11IFB Number C5613137-D Exhibit B-1.3

B-1.4 Opt. FY 29-30

OPTIONAL YEAR
BUDGET RATE SHEET
Day Reporting Center
County:
Fiscal Year 2029/2030
July 1, 2029 - June 30, 2030
Category
A.PERSONNELNumber of Positions*Monthly Salary Rate**Hourly Rate**% of Project Time***Number of Months or
Hours per YearTOTAL****
MonthsHours
*****REQUIRED POSITIONS:
Program Director
Caseworker Supervisor
CBT Faciltator
Caseworker
Community Navigator
Job/Career Developer
Certified AOD Counselor
RRH Placement Coordinator
OTHER PERSONNEL COSTS (BENEFITS, RETENTION ALLOWANCES, BILINGUAL PAY, OVERTIME, TEMPORARY HELP)$ - 0
(Budget Transfer Requests are only allowable within the Personnel Services Category)TOTAL PERSONNEL COSTS (A)$ - 0
B.SUBCONTRACTORS/CONSULTANT COSTS
Service Type
$ - 0
$ - 0
$ - 0
$ - 0
TOTAL SUBCONTRACTORS/CONSULTANT COSTS (B)$ - 0
C.OPERATING COSTS (Refer to Exhibit H, Line Item Budget Guide (LIBG) for allowable costs)TOTAL OPERATING COSTS (C)$ - 0
SUBTOTAL ANNUAL DIRECT EXPENSES (SUM OF A+C)$ - 0
D.TOTAL INDIRECT COSTS
(Refer to Exhibit H, Line Item Budget Guide (LIBG) for allowable costs)Percentage of Subtotal Annual Direct Expenses =%$ - 0
E.PROFITS/SERVICE FEEPercentage of Subtotal Annual Direct Expenses =%$ - 0
F.OPERATING RESERVE/CONTINGENCY FUNDPercentage of Subtotal Annual Direct Expenses =%$ - 0
TOTAL BUDGET FOR FISCAL YEAR (SUM OF A+B+C+D+E+F)$ - 0
The Contractor must refer to Exhibit H, Line Item Budget Guide (LIBG) for all items defined in this Budget Rate Sheet.
The Contractor MUST account for year-over-year salary, benefits and cost of living adjustments over the term of the Agreement. Agreed upon budgets will be incorporated into the contract and subsequent alterations are not allowable.
*Respondents are responsible for ensuring positions listed meet the required ratios outlined in the Scope of Work. Proposals submitted that do not meet the ratio requirements may be disqualified.
**Respondents are responsible for determining whether a position is salaried or hourly.
***Where not specified, Respondents are responsible for identifying the percentage of time the position will be dedicated to the DRC.
****Totals for positions shall be calculated by multiplying the Number of Positions by the Monthly Salary Rate by the Number of Months per Year or the Number of Positions by the Hourly Rate by the Number of Hours per Year.
*****Respondents are required to list every position needed to operate the DRC. Positions not listed cannot be billed to the DRC. Changes to positions cannot be made after the contract is executed.

Budget Rate Sheet &11IFB Number C5613137-D Exhibit B-1.4

B-1.5 Opt. FY 30-31

OPTIONAL YEAR
BUDGET RATE SHEET
Day Reporting Center
County:
Fiscal Year 2030/2031
July 1, 2030 - June 30, 2031
Category
A.PERSONNELNumber of Positions*Monthly Salary Rate**Hourly Rate**% of Project Time***Number of Months or
Hours per YearTOTAL****
MonthsHours
*****REQUIRED POSITIONS:
Program Director
Caseworker Supervisor
CBT Faciltator
Caseworker
Community Navigator
Job/Career Developer
Certified AOD Counselor
RRH Placement Coordinator
OTHER PERSONNEL COSTS (BENEFITS, RETENTION ALLOWANCES, BILINGUAL PAY, OVERTIME, TEMPORARY HELP)$ - 0
(Budget Transfer Requests are only allowable within the Personnel Services Category)TOTAL PERSONNEL COSTS (A)$ - 0
B.SUBCONTRACTORS/CONSULTANT COSTS
Service Type
$ - 0
$ - 0
$ - 0
$ - 0
TOTAL SUBCONTRACTORS/CONSULTANT COSTS (B)$ - 0
C.OPERATING COSTS (Refer to Exhibit H, Line Item Budget Guide (LIBG) for allowable costs)TOTAL OPERATING COSTS (C)$ - 0
SUBTOTAL ANNUAL DIRECT EXPENSES (SUM OF A+C)$ - 0
D.TOTAL INDIRECT COSTS
(Refer to Exhibit H, Line Item Budget Guide (LIBG) for allowable costs)Percentage of Subtotal Annual Direct Expenses =%$ - 0
E.PROFITS/SERVICE FEEPercentage of Subtotal Annual Direct Expenses =%$ - 0
F.OPERATING RESERVE/CONTINGENCY FUNDPercentage of Subtotal Annual Direct Expenses =%$ - 0
TOTAL BUDGET FOR FISCAL YEAR (SUM OF A+B+C+D+E+F)$ - 0
The Contractor must refer to Exhibit H, Line Item Budget Guide (LIBG) for all items defined in this Budget Rate Sheet.
The Contractor MUST account for year-over-year salary, benefits and cost of living adjustments over the term of the Agreement. Agreed upon budgets will be incorporated into the contract and subsequent alterations are not allowable.
*Respondents are responsible for ensuring positions listed meet the required ratios outlined in the Scope of Work. Proposals submitted that do not meet the ratio requirements may be disqualified.
**Respondents are responsible for determining whether a position is salaried or hourly.
***Where not specified, Respondents are responsible for identifying the percentage of time the position will be dedicated to the DRC.
****Totals for positions shall be calculated by multiplying the Number of Positions by the Monthly Salary Rate by the Number of Months per Year or the Number of Positions by the Hourly Rate by the Number of Hours per Year.
*****Respondents are required to list every position needed to operate the DRC. Positions not listed cannot be billed to the DRC. Changes to positions cannot be made after the contract is executed.

Budget Rate Sheet &11IFB Number C5613137-D Exhibit B-1.5

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