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 1Prepared by: Dan Idell
Provider Name: Interim Recovery Housing RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 1st Year (12 month period)
Year 1- September 1st 2026- August 31, 2027
BudgetBudget
TotalTotal PayrollVentura County BH Interim Recovery Housing RFPVentura County BH Prog C
RefPositionHoursFTESalaryBenefitsTotal S&B%Total FTESalaryBenefits%Total FTEBillable FTESalaryBenefits
1Sample-- 0- 0-0%--
2Program Director-- 0- 0-10%1,500500
3Clinician - Licensed-- 0- 0-20%3,200400
4-- 0- 0-20%3,200400
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,9001,300
Total Should tie to Schedule 20
Variance (Error - PLS Correct)0

&L&Z&F

1-Salaries 2nd year

Schedule 1Prepared by: Dan Idell
Provider Name: Interim Recovery Housing RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 2ndYear (12 month period)
Year 2- September 1st 2027- August 31, 2028
ProjectionBudgetBudget
TotalTotal PayrollVentura County BH Interim Recovery Housing RFPVentura County BH Prog C
RefPositionHoursFTESalaryBenefitsTotal S&B%Total FTESalaryBenefits%Total FTEBillable FTESalaryBenefits
1Sample-- 0- 0-0%--
2Program Director-- 0- 0-10%1,500500
3Clinician - Licensed-- 0- 0-20%3,200400
4-- 0- 0-20%3,200400
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,9001,300
Total Should tie to Schedule 20
Variance (Error - PLS Correct)0

&L&Z&F

1-Salaries 3rd year

Schedule 1Prepared by: Dan Idell
Provider Name: Interim Recovery Housing RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 3rd Year (12 month period)
Year 3- September 1st 2028- August 31, 2029
ProjectionBudgetBudget
TotalTotal PayrollVentura County BH Interim Recovery Housing RFPVentura County BH Prog C
RefPositionHoursFTESalaryBenefitsTotal S&B%Total FTESalaryBenefits%Total FTEBillable FTESalaryBenefits
1Sample-- 0- 0-0%--
2Program Director-- 0- 0-10%1,500500
3Clinician - Licensed-- 0- 0-20%3,200400
4-- 0- 0-20%3,200400
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,9001,300
Total Should tie to Schedule 20
Variance (Error - PLS Correct)0

&L&Z&F

Budget

SCHEDULE 2
Prepared by:
Date Prepared:
Provider Name: Interim Recovery Housing RFP Proposal
REVENUEYear 1- September 1, 2026- August 31, 2027Year 2- September 1, 2027- August 31, 2028Year 3- September 1, 2028- August 31, 2029Total1st Year Budget -Detailed Explanation2nd Year Budget -Detailed Explanation3rd 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 3Provider Name: Interim Recovery Housing RFP Proposal
Y1Y2Y3
September 1, 2026 to August 31,2027September 1, 2027 to August 31,2028September 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 .