1-Attachment A - Lewis Road MHRC Budget Template.xls

XLS spreadsheet 105 KB Posted

Attached to
Lewis Road Mental Health Rehabilitation Center (MHRC) RFP
Solicitation number
230328
Issued by
Ventura County, California

About this file

This is a budget template attachment for the Lewis Road Mental Health Rehabilitation Center (MHRC) Request for Proposals issued by Ventura County Behavioral Health, a division of the County of Ventura Health Care Agency in California. The RFP seeks qualified providers to design, develop, obtain licensure/certification for, and operate a 38-bed locked residential mental health rehabilitation center serving conserved adults aged 18 and older with serious mental illnesses and co-occurring disorders. The budget template provided was prepared by Dan Idell on October 22, 2015, and includes staffing projections across multiple fiscal periods beginning May 1, 2028, with operational phases extending through July 31, 2031. The budget structure encompasses a three-month start-up period (May 1, 2028 to July 1, 2028), a nine-month operational period (August 1, 2028 to July 31, 2029), and subsequent full 12-month fiscal years.

The salary and benefits schedules project staffing costs including a Program Director at 10% full-time equivalent and Licensed Clinicians at 20% full-time equivalent, with individual salary and benefits allocations of $1,500 and $500 for the Director and $3,200 and $400 for Clinicians respectively. The budget template includes sections for operating revenue from patient services, grants, contracts, and donations; direct operating expenses covering salaries, benefits, payroll taxes, rent, professional fees, supplies, insurance, and facility operations; and indirect expenditures capped at 15% of direct expenses. Start-up costs are projected to include IT equipment and services, recruitment, travel, corporate staff orientation, office supplies, WRAP and LEAP training programs, and staff positions for program leadership, nursing, clinical, rehabilitation, and social services. All financial projections in the submitted template currently show zero dollar amounts, indicating incomplete data entry by the proposing provider.

View the file

Other files

File Type Posted
6-MHRC RFP Final.docx DOCX document
2-MHRC Attachment B-Standard Provider Agreement.docx DOCX document
5-MHRC Attachment E-Non-Collusion Affidavit.docx DOCX document
3-MHRC Attachment C-Key Staff Listing Template.docx DOCX document
4-MHRC Attachment D-References.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 Start Up

Schedule 1Prepared by: Dan Idell
Provider Name: MHRC RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 1st Year (3 month period)
Year 1- May 1, 2028- July 1, 2028
BudgetBudget
TotalTotal PayrollVentura County BH MHRC 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 1st Year Operational

Schedule 1Prepared by: Dan Idell
Provider Name: MHRC RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 1st Year (9 month period)
Year 1- August 1, 2028- July 31, 2029
BudgetBudget
TotalTotal PayrollVentura County BH MHRC 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: MHRC RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 1st Year (12 month period)
Year 2- August 1, 2029 to July 31, 2030
ProjectionBudgetBudget
TotalTotal PayrollVentura County BH MHRC 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: MHRC RFP ProposalDate Prepared: 10/22/2015
Salary and Benefits Schedule 1st Year (12 month period)
Year 3-August 1, 2030 to July 31, 2031
ProjectionBudgetBudget
TotalTotal PayrollVentura County BH MHRC 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: MHRC RFP Proposal
REVENUEYear 1- October 1, 2025- June 30,2025Year 2- July 1 ,2026 to June 30, 2027Year 3- July 1, 2027 to June 30, 2028Total1st 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 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: MHRC RFP Proposal
3 Months Start-up period- July 1, 2025 to September 30, 2025.
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 .