1-Attachment A - Lewis Road MHRC Budget Template.xls
XLS spreadsheet 105 KB Posted
- 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 1 | Prepared by: Dan Idell | ||||||||||||||
| Provider Name: MHRC RFP Proposal | Date Prepared: 10/22/2015 | ||||||||||||||
| Salary and Benefits Schedule 1st Year (3 month period) | |||||||||||||||
| Year 1- May 1, 2028- July 1, 2028 | |||||||||||||||
| Budget | Budget | ||||||||||||||
| Total | Total Payroll | Ventura County BH MHRC 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 1st Year Operational
| Schedule 1 | Prepared by: Dan Idell | ||||||||||||||
| Provider Name: MHRC RFP Proposal | Date Prepared: 10/22/2015 | ||||||||||||||
| Salary and Benefits Schedule 1st Year (9 month period) | |||||||||||||||
| Year 1- August 1, 2028- July 31, 2029 | |||||||||||||||
| Budget | Budget | ||||||||||||||
| Total | Total Payroll | Ventura County BH MHRC 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 |
1-Salaries 2nd year
| Schedule 1 | Prepared by: Dan Idell | ||||||||||||||
| Provider Name: MHRC RFP Proposal | Date Prepared: 10/22/2015 | ||||||||||||||
| Salary and Benefits Schedule 1st Year (12 month period) | |||||||||||||||
| Year 2- August 1, 2029 to July 31, 2030 | |||||||||||||||
| Projection | Budget | Budget | |||||||||||||
| Total | Total Payroll | Ventura County BH MHRC 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: MHRC RFP Proposal | Date Prepared: 10/22/2015 | ||||||||||||||
| Salary and Benefits Schedule 1st Year (12 month period) | |||||||||||||||
| Year 3-August 1, 2030 to July 31, 2031 | |||||||||||||||
| Projection | Budget | Budget | |||||||||||||
| Total | Total Payroll | Ventura County BH MHRC 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: MHRC RFP Proposal | |||||||
| REVENUE | Year 1- October 1, 2025- June 30,2025 | Year 2- July 1 ,2026 to June 30, 2027 | Year 3- July 1, 2027 to June 30, 2028 | 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: MHRC RFP Proposal | ||
| 3 Months Start-up period- July 1, 2025 to September 30, 2025. | ||
| Start-up Costs and Items | ||
| Description of Items | Cost | Supporting 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 expenditures | 15% Indirect expenditures from direct expenses | |
| TOTAL | - 0 |
File details come from the government source that posted it. Updated .