Exhibit_B-1.1-1.5_Budget_Rate_Sheet_C5612676-D.xlsx
XLSX spreadsheet 57 KB Posted
- Attached to
- C5612676-D- Day Reporting Center (DRC)
- Solicitation number
- 0000035020
About this file
This document is a Budget Rate Sheet for a Day Reporting Center (DRC) contract issued by the California Department of Corrections and Rehabilitation, with solicitation number C5612676-D. The document covers budget planning for fiscal years 2025/26 through 2029/30, including three base years and two optional years. The budget rate sheets are designed for potential contractors to outline personnel costs, subcontractor expenses, operating costs, indirect costs, profits, and contingency funds for operating a Day Reporting Center.
The budget rate sheets require detailed financial planning, with contractors responsible for accounting for year-over-year salary adjustments, benefits, and cost of living increases. Bidders must provide a comprehensive justification statement explaining the basis for each cost breakdown, including personnel rates, subcontractor costs, and operating expenses. The documents emphasize that budgets submitted during the bid will be incorporated into the final contract, and subsequent alterations are not allowable. Specific required positions include a Program Director, Caseworker Supervisor, CBT Facilitator, Caseworker, Community Navigator, Job Developer, Certified AOD Counselor, and RRH Placement Coordinator, with each position expected to be fully dedicated to the project.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Invitation_for_Bid_C5612676-D.pdf |
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 Scope of Work requirements, potential risks, and contingencies in their pricing.
B-1.1 FY 25-26
| BUDGET RATE SHEET |
| DAY REPORTING CENTER |
| County: |
| Fiscal Year 2025/26 |
| July 1, 2025 - June 30, 2026 |
| Category | ||||||||||
| A. | PERSONNEL | |||||||||
| Number of Positions* | Monthly Salary Rate** | Hourly Rate** | % of Project Time*** | Number of Months or | ||||||
| Hours per Year | TOTAL**** | |||||||||
| Months | Hours | |||||||||
| ***** | REQUIRED POSITIONS: | |||||||||
| Program Director | 100% | |||||||||
| Caseworker Supervisor | 100% | |||||||||
| CBT Facilitator | ||||||||||
| Caseworker | ||||||||||
| Community Navigator | ||||||||||
| Job 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 | ||||||
| Business Name | Business Address | ||||||
| $ - 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 FEE | Percentage of Subtotal Annual Direct Expenses = | $ - 0 | ||||
| F. | OPERATING RESERVE/CONTINGENCY FUND | Percentage 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. Budgets submitted during the bid will be incorporated into the awarding contract and subsequent alterations are not allowable. | |||||||
| * | Respondents are responsible for ensuring positions listed meet the required ratios outlined in the Scope of Work. Bids 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 awarded. |
&11TBB
California Department of Corrections and Rehabilitation Budget Rate Sheet &11IFB Number C5612676-D Exhibit B-1.1
B-1.2 FY 26-27
| BUDGET RATE SHEET |
| DAY REPORTING CENTER |
| County: |
| Fiscal Year 2026/27 |
| July 1, 2026 - June 30, 2027 |
| Category | ||||||||||
| A. | PERSONNEL | |||||||||
| Number of Positions* | Monthly Salary Rate** | Hourly Rate** | % of Project Time*** | Number of Months or | ||||||
| Hours per Year | TOTAL**** | |||||||||
| Months | Hours | |||||||||
| ***** | REQUIRED POSITIONS: | |||||||||
| Program Director | 100% | |||||||||
| Caseworker Supervisor | 100% | |||||||||
| CBT Facilitator | ||||||||||
| Caseworker | ||||||||||
| Community Navigator | ||||||||||
| Job 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 | ||||||
| Business Name | Business Address | ||||||
| $ - 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 FEE | Percentage of Subtotal Annual Direct Expenses = | $ - 0 | ||||
| F. | OPERATING RESERVE/CONTINGENCY FUND | Percentage 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. Budgets submitted during the bid will be incorporated into the awarding contract and subsequent alterations are not allowable. | |||||||
| * | Respondents are responsible for ensuring positions listed meet the required ratios outlined in the Scope of Work. Bids 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 awarded. |
&11TBB
California Department of Corrections and Rehabilitation Budget Rate Sheet &11IFB Number C5612676-D Exhibit B-1.2
B-1.3 FY 27-28
| BUDGET RATE SHEET |
| DAY REPORTING CENTER |
| County: |
| Fiscal Year 2027/28 |
| July 1, 2027 - June 30, 2028 |
| Category | ||||||||||
| A. | PERSONNEL | |||||||||
| Number of Positions* | Monthly Salary Rate** | Hourly Rate** | % of Project Time*** | Number of Months or | ||||||
| Hours per Year | TOTAL**** | |||||||||
| Months | Hours | |||||||||
| ***** | REQUIRED POSITIONS: | |||||||||
| Program Director | 100% | |||||||||
| Caseworker Supervisor | 100% | |||||||||
| CBT Facilitator | ||||||||||
| Caseworker | ||||||||||
| Community Navigator | ||||||||||
| Job 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 | ||||||
| Business Name | Business Address | ||||||
| $ - 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 FEE | Percentage of Subtotal Annual Direct Expenses = | $ - 0 | ||||
| F. | OPERATING RESERVE/CONTINGENCY FUND | Percentage 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. Budgets submitted during the bid will be incorporated into the awarding contract and subsequent alterations are not allowable. | |||||||
| * | Respondents are responsible for ensuring positions listed meet the required ratios outlined in the Scope of Work. Bids 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 awarded. |
&11TBB
California Department of Corrections and Rehabilitation Budget Rate Sheet &11IFB Number C5612676-D Exhibit B-1.3
B-1.4 FY 28-29
| OPTIONAL YEAR |
| BUDGET RATE SHEET |
| DAY REPORTING CENTER |
| County: |
| Fiscal Year 2028/29 |
| July 1, 2028 - June 30, 2029 |
| Category | ||||||||||
| A. | PERSONNEL | |||||||||
| Number of Positions* | Monthly Salary Rate** | Hourly Rate** | % of Project Time*** | Number of Months or | ||||||
| Hours per Year | TOTAL**** | |||||||||
| Months | Hours | |||||||||
| ***** | REQUIRED POSITIONS: | |||||||||
| Program Director | 100% | |||||||||
| Caseworker Supervisor | 100% | |||||||||
| CBT Facilitator | ||||||||||
| Caseworker | ||||||||||
| Community Navigator | ||||||||||
| Job 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 | ||||||
| Business Name | Business Address | ||||||
| $ - 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 FEE | Percentage of Subtotal Annual Direct Expenses = | $ - 0 | ||||
| F. | OPERATING RESERVE/CONTINGENCY FUND | Percentage 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. Budgets submitted during the bid will be incorporated into the awarding contract and subsequent alterations are not allowable. | |||||||
| * | Respondents are responsible for ensuring positions listed meet the required ratios outlined in the Scope of Work. Bids 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 awarded. |
&11TBB
California Department of Corrections and Rehabilitation Budget Rate Sheet &11IFB Number C5612676-D Exhibit B-1.4
B-1.5 FY 29-30
| OPTIONAL YEAR |
| BUDGET RATE SHEET |
| DAY REPORTING CENTER |
| County: |
| Fiscal Year 2029/30 |
| July 1, 2029 - June 30, 2030 |
| Category | ||||||||||
| A. | PERSONNEL | |||||||||
| Number of Positions* | Monthly Salary Rate** | Hourly Rate** | % of Project Time*** | Number of Months or | ||||||
| Hours per Year | TOTAL**** | |||||||||
| Months | Hours | |||||||||
| ***** | REQUIRED POSITIONS: | |||||||||
| Program Director | 100% | |||||||||
| Caseworker Supervisor | 100% | |||||||||
| CBT Facilitator | ||||||||||
| Caseworker | ||||||||||
| Community Navigator | ||||||||||
| Job 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 | ||||||
| Business Name | Business Address | ||||||
| $ - 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 FEE | Percentage of Subtotal Annual Direct Expenses = | $ - 0 | ||||
| F. | OPERATING RESERVE/CONTINGENCY FUND | Percentage 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. Budgets submitted during the bid will be incorporated into the awarding contract and subsequent alterations are not allowable. | |||||||
| * | Respondents are responsible for ensuring positions listed meet the required ratios outlined in the Scope of Work. Bids 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 awarded. |
&11TBB
California Department of Corrections and Rehabilitation Budget Rate Sheet &11IFB Number C5612676-D Exhibit B-1.5
File details come from the government source that posted it. Updated .