1-Attachment A - Budget Template .xls
XLS spreadsheet 87 KB Posted
- Attached to
- Interim Recovery Housing RFP
- Solicitation number
- 230206
- Issued by
- Ventura County, California
About this file
This is a budget template for the Interim Recovery Housing RFP issued by Ventura County Behavioral Health (VCBH) in California. The template outlines a three-year salary and benefits schedule covering the contract period from September 1, 2026, through August 31, 2029. The proposed staffing structure includes a Program Director allocated at 10% full-time equivalent (FTE) with a salary of $1,500 and benefits of $500, and Licensed Clinicians allocated at 20% FTE each with salaries of $3,200 and benefits of $400. The budget template contains multiple schedules for detailed expense planning, including direct operational expenses such as drugs and medications, food and personal items, professional medical services, housekeeping and security contracts, vehicle expenses, utilities, equipment maintenance, office supplies, communications, and travel. The template also provides for indirect expenditures including salaries, benefits, accounting and audit services, and vehicle expenses, with a maximum indirect cost cap of 15% of direct expenses. Additionally, a census reporting schedule is included to track average daily census, monthly number of encounters, and average length of stay in billable hours across all three contract years.
The budget template contains multiple blank fields for bidders to complete with their proposed costs and revenue projections for each fiscal year. The revenue section allows providers to input patient service revenue, operating grants and contracts, contributions and fundraising income, donated goods and services, and other operating revenue. All expense categories and financial projections in the template were marked as $0 at the time of preparation on October 22, 2015, indicating this is a blank template awaiting completion by proposing organizations. The template was prepared by Dan Idell and requires detailed explanations for all revenue and expense projections, particularly for salary and benefits increases and significant service or supply costs such as leases and professional expenses.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 4-Attachment D-- References.docx | DOCX document | |
| 6-Interim Recovery Housing RFP Final.docx | DOCX document | |
| 5-Attachment E--Non-Collusion Affidavit.docx | DOCX document | |
| 3-Attachment C-- Key Staff Listing.docx | DOCX document | |
| 2-Attachment B -- Standard Contract.docx | DOCX document |
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
1-Salaries 1st year
| Schedule 1 | Prepared by: Dan Idell | ||||||||||||||
| Provider Name: Interim Recovery Housing RFP Proposal | Date Prepared: 10/22/2015 | ||||||||||||||
| Salary and Benefits Schedule 1st Year (12 month period) | |||||||||||||||
| Year 1- September 1st 2026- August 31, 2027 | |||||||||||||||
| Budget | Budget | ||||||||||||||
| Total | Total Payroll | Ventura County BH Interim Recovery Housing RFP | Ventura County BH Prog C | ||||||||||||
| Ref | Position | Hours | FTE | Salary | Benefits | Total S&B | % | Total FTE | Salary | Benefits | % | Total FTE | Billable FTE | Salary | Benefits |
| 1 | Sample | - | - 0 | - 0 | - | 0% | - | - | |||||||
| 2 | Program Director | - | - 0 | - 0 | - | 10% | 1,500 | 500 | |||||||
| 3 | Clinician - Licensed | - | - 0 | - 0 | - | 20% | 3,200 | 400 | |||||||
| 4 | - | - 0 | - 0 | - | 20% | 3,200 | 400 | ||||||||
| 5 | - | - 0 | - 0 | - | |||||||||||
| 6 | - | - 0 | - 0 | - | |||||||||||
| 7 | - | - 0 | - 0 | - | |||||||||||
| 8 | - | - 0 | - 0 | - | |||||||||||
| 9 | - | - 0 | - 0 | - | |||||||||||
| 10 | - | - 0 | - 0 | - | - | - | |||||||||
| 11 | - | - 0 | - 0 | - | - | - | |||||||||
| 12 | - | - 0 | - 0 | - | - | - | |||||||||
| 13 | - | - 0 | - 0 | - | - | - | |||||||||
| 14 | - | - 0 | - 0 | - | - | - | |||||||||
| 15 | - | - 0 | - 0 | - | - | - | |||||||||
| 16 | - | - 0 | - 0 | - | - | - | |||||||||
| 17 | - | - 0 | - 0 | - | - | - | |||||||||
| 18 | - 0 | - 0 | - | - | - | ||||||||||
| - | -0 | - | - | - 0 | - 0 | - 0 | - | - | 7,900 | 1,300 | |||||
| Total Should tie to Schedule 2 | 0 | ||||||||||||||
| Variance (Error - PLS Correct) | 0 |
&L&Z&F
1-Salaries 2nd year
| Schedule 1 | Prepared by: Dan Idell | ||||||||||||||
| Provider Name: Interim Recovery Housing RFP Proposal | Date Prepared: 10/22/2015 | ||||||||||||||
| Salary and Benefits Schedule 2ndYear (12 month period) | |||||||||||||||
| Year 2- September 1st 2027- August 31, 2028 | |||||||||||||||
| Projection | Budget | Budget | |||||||||||||
| Total | Total Payroll | Ventura County BH Interim Recovery Housing RFP | Ventura County BH Prog C | ||||||||||||
| Ref | Position | Hours | FTE | Salary | Benefits | Total S&B | % | Total FTE | Salary | Benefits | % | Total FTE | Billable FTE | Salary | Benefits |
| 1 | Sample | - | - 0 | - 0 | - | 0% | - | - | |||||||
| 2 | Program Director | - | - 0 | - 0 | - | 10% | 1,500 | 500 | |||||||
| 3 | Clinician - Licensed | - | - 0 | - 0 | - | 20% | 3,200 | 400 | |||||||
| 4 | - | - 0 | - 0 | - | 20% | 3,200 | 400 | ||||||||
| 5 | - | - 0 | - 0 | - | |||||||||||
| 6 | - | - 0 | - 0 | - | |||||||||||
| 7 | - | - 0 | - 0 | - | |||||||||||
| 8 | - | - 0 | - 0 | - | |||||||||||
| 9 | - | - 0 | - 0 | - | |||||||||||
| 10 | - | - 0 | - 0 | - | - | - | |||||||||
| 11 | - | - 0 | - 0 | - | - | - | |||||||||
| 12 | - | - 0 | - 0 | - | - | - | |||||||||
| 13 | - | - 0 | - 0 | - | - | - | |||||||||
| 14 | - | - 0 | - 0 | - | - | - | |||||||||
| 15 | - | - 0 | - 0 | - | - | - | |||||||||
| 16 | - | - 0 | - 0 | - | - | - | |||||||||
| 17 | - | - 0 | - 0 | - | - | - | |||||||||
| 18 | - 0 | - 0 | - | - | - | ||||||||||
| - | -0 | - | - | - 0 | - 0 | - 0 | - | - | 7,900 | 1,300 | |||||
| Total Should tie to Schedule 2 | 0 | ||||||||||||||
| Variance (Error - PLS Correct) | 0 |
&L&Z&F
1-Salaries 3rd year
| Schedule 1 | Prepared by: Dan Idell | ||||||||||||||
| Provider Name: Interim Recovery Housing RFP Proposal | Date Prepared: 10/22/2015 | ||||||||||||||
| Salary and Benefits Schedule 3rd Year (12 month period) | |||||||||||||||
| Year 3- September 1st 2028- August 31, 2029 | |||||||||||||||
| Projection | Budget | Budget | |||||||||||||
| Total | Total Payroll | Ventura County BH Interim Recovery Housing RFP | Ventura County BH Prog C | ||||||||||||
| Ref | Position | Hours | FTE | Salary | Benefits | Total S&B | % | Total FTE | Salary | Benefits | % | Total FTE | Billable FTE | Salary | Benefits |
| 1 | Sample | - | - 0 | - 0 | - | 0% | - | - | |||||||
| 2 | Program Director | - | - 0 | - 0 | - | 10% | 1,500 | 500 | |||||||
| 3 | Clinician - Licensed | - | - 0 | - 0 | - | 20% | 3,200 | 400 | |||||||
| 4 | - | - 0 | - 0 | - | 20% | 3,200 | 400 | ||||||||
| 5 | - | - 0 | - 0 | - | |||||||||||
| 6 | - | - 0 | - 0 | - | |||||||||||
| 7 | - | - 0 | - 0 | - | |||||||||||
| 8 | - | - 0 | - 0 | - | |||||||||||
| 9 | - | - 0 | - 0 | - | |||||||||||
| 10 | - | - 0 | - 0 | - | - | - | |||||||||
| 11 | - | - 0 | - 0 | - | - | - | |||||||||
| 12 | - | - 0 | - 0 | - | - | - | |||||||||
| 13 | - | - 0 | - 0 | - | - | - | |||||||||
| 14 | - | - 0 | - 0 | - | - | - | |||||||||
| 15 | - | - 0 | - 0 | - | - | - | |||||||||
| 16 | - | - 0 | - 0 | - | - | - | |||||||||
| 17 | - | - 0 | - 0 | - | - | - | |||||||||
| 18 | - 0 | - 0 | - | - | - | ||||||||||
| - | -0 | - | - | - 0 | - 0 | - 0 | - | - | 7,900 | 1,300 | |||||
| Total Should tie to Schedule 2 | 0 | ||||||||||||||
| Variance (Error - PLS Correct) | 0 |
&L&Z&F
Budget
| SCHEDULE 2 | |||||||
| Prepared by: | |||||||
| Date Prepared: | |||||||
| Provider Name: Interim Recovery Housing RFP Proposal | |||||||
| REVENUE | Year 1- September 1, 2026- August 31, 2027 | Year 2- September 1, 2027- August 31, 2028 | Year 3- September 1, 2028- August 31, 2029 | Total | 1st Year Budget -Detailed Explanation | 2nd Year Budget -Detailed Explanation | 3rd Year Budget -Detailed Explanation |
| Net Patient Service Revenue | $0 | ||||||
| Total Operating Grants and Contracts | |||||||
| Contributions/Fundraising Income | |||||||
| Donated Goods and Services | |||||||
| Net Assets Released from Restriction | |||||||
| Other Operating Revenue (Realignment/NCC) | $0 | $0 | $0 | $0 | |||
| Total Operating Revenue | $0 | $0 | $0 | $0 | |||
| EXPENSES | |||||||
| Salaries & Benefits | $0 | ||||||
| Salaries Wages | $0 | ||||||
| Benefits | $0 | ||||||
| Total Salarues & Benefits | $0 | $0 | $0 | $0 | |||
| Direct Operational Expenses | $0 | ||||||
| Drugs, Medication | $0 | ||||||
| Food, Personal | $0 | ||||||
| Professional Medical services | $0 | ||||||
| Registries | $0 | ||||||
| Recruitment Incentive | $0 | ||||||
| Housekeeping - Contract | $0 | ||||||
| Security - Contract | $0 | ||||||
| Vehicle Expenses | $0 | ||||||
| Utilities | $0 | ||||||
| Equipment Maintenance | $0 | ||||||
| Office Supplies | $0 | ||||||
| Communication | $0 | ||||||
| Travel/mileage | $0 | ||||||
| Other (Specify) | $0 | ||||||
| TOTAL DIRECT OPERATING EXPENSES | $0 | $0 | $0 | $0 | |||
| Indirect Expenditures: Paid By Provider | |||||||
| Salaries | $0 | ||||||
| Benefits | $0 | ||||||
| Accounting, Audit, and Legal | $0 | ||||||
| Vehicle Expense | $0 | ||||||
| Staff Expenses | $0 | ||||||
| Other Indirect Expenditures: | $0 | ||||||
| Total Indirect Expenditures | $0 | $0 | $0 | $0 | |||
| Total Expenditure | $0 | $0 | $0 | $0 | |||
| Notes: | |||||||
| 1) Area highlighted in green for data entry. | |||||||
| 2) Explain basis of projection for salaries & benefits and other significant services & supplies such as lease, other professional expenses, etc. | |||||||
| 3) Insert lines as needed. | |||||||
| 4)Maximum total Indirect expenses is 15% of direct expenses. |
Census Report
| SCHEDULE 3 | Provider Name: Interim Recovery Housing RFP Proposal | |||
| Y1 | Y2 | Y3 | ||
| September 1, 2026 to August 31,2027 | September 1, 2027 to August 31,2028 | September 1, 2028 to August 31,2029 | ||
| Average Daily Census | ||||
| Monthly Number of Encounters | ||||
| Average Length of Stay - Hours | ||||
| Billable - Hours |
File details come from the government source that posted it. Updated .