1-Attachment A-Casa de Esperanza Budget Template.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
Casa de Esperanza Residential Services RFP
Solicitation number
233045
Issued by
Ventura County, California

About this file

This is a budget template and proposal document prepared by Casa de Esperanza for submission to Ventura County Behavioral Health (VCBH) in response to an RFP for residential services. The proposal outlines staffing and operational budgets across a three-year contract period beginning October 1, 2026. Casa de Esperanza proposes to operate a 24-hour social rehabilitation facility serving adults and transitional-age youth recovering from serious mental illness or co-occurring disorders, providing day rehabilitation services, specialty mental health services, and activities of daily living instruction in a supervised residential setting. The contract term is anticipated to be one year with the possibility of two additional one-year extensions. The staffing plan identifies key positions including a Program Director allocated at 10% FTE and Licensed Clinicians allocated at 20% FTE each, though the template shows incomplete data entry with minimal salary figures populated ($1,500 for Program Director, $3,200 for each Clinician position, with corresponding benefits amounts of $500 and $400 respectively).

The budget template demonstrates a phased implementation approach with a three-month startup period from October 1 through December 31, 2026, followed by operational periods covering January 1, 2027 through December 31, 2029. The document indicates that startup costs and operational expenses should be detailed across categories including IT equipment and services, recruitment, training, office supplies, and indirect expenditures capped at 15% of direct expenses. However, the submitted budget shows zero amounts across all revenue and expense line items for the operational years, indicating the document is an incomplete template rather than a finalized budget proposal. The template includes sections for detailed explanations of projections for salaries, benefits, professional contracted services, facility operations, and other significant expenses, suggesting the bidder was expected to provide comprehensive financial documentation supporting the proposed service delivery costs.

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

1-Salaries 1st year Start Up

Schedule 1Prepared by: Dan Idell
Provider Name: Casa de Esperanza RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 1st Year (3 month period)
Year 1- October 1, 2026- December 31, 2026
BudgetBudget
TotalTotal PayrollVentura County BH Casa de Esperanza 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

&Z&F

1-Salaries 1st Year Operational

Schedule 1Prepared by: Dan Idell
Provider Name: Casa de Esperanza RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 1st Year (9 month period)
Year 1- January 1, 2027- December 31, 2027
BudgetBudget
TotalTotal PayrollVentura County BH Casa de Esperanza 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

1-Salaries 2nd year

Schedule 1Prepared by: Dan Idell
Provider Name: Casa de Esperanza RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 1st Year (12 month period)
Year 2- January 1, 2028 to December 31, 2028
ProjectionBudgetBudget
TotalTotal PayrollVentura County BH Casa de Esperanza 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

&Z&F

1-Salaries 3rd year

Schedule 1Prepared by: Dan Idell
Provider Name: Casa de Esperanza RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 1st Year (12 month period)
Year 3-January 1, 2029 to December 31, 2029
ProjectionBudgetBudget
TotalTotal PayrollVentura County BH Casa de Esperanza 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

&Z&F

Budget

SCHEDULE 2
Prepared by:
Date Prepared:

Provider Name: Casa de Esperanza RFP Proposal

REVENUE Year 1- January 1, 2027- December 31,2027 Year 2- January 1, 2028- December 31,2028 Year 3- January 1, 2029- December 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 and Related Expenses$0
Benefits$0
Payroll Taxes$0
Rent$0
Debt Service/Mortgage Payments$0
Professional Contracted/Consultant Fees$0
Supplies$0
Insurance$0
Travel and Training$0
Licensing and Permits$0
General Administration$0
Facility Operation and Maintenance$0
Printing/Postage$0
Property Taxes/Local Fees$0
Technology (Computers and Other Equipment)$0
Telephone/Internet$0
Utilities$0
Other ()$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.

Start Up Costs

Prepared by:
Date Prepared:
Provider Name: Casa de Esperanza RFP Proposal
3 Months Start-up period- October 1, 2026 to December 31, 2026
Start-up Costs and Items
Description of ItemsCostSupporting Justification and Calculations
Amount ($)
IT Equipment and Services
Recruitment
Travel
Corporate Staff
Orientation-related expenses
Office Supplies
WRAP and LEAP training
Program Leadership Staff
Program Nursing, Clinicial, Rehab and Social Staff
Indirect expenditures15% Indirect expenditures from direct expenses

TOTAL - 0

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