4-APPENDIX F FY27 Budget Form.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
Intensive Case Management Services for Community Connections Supportive Housing
Solicitation number
RFP 31-26-EM
Issued by
Bernalillo County, New Mexico

About this file

This is a budget form for the Bernalillo County Behavioral Health Authority Division related to the Intensive Case Management Services for Community Connections Supportive Housing (CCSH) Program in New Mexico. The document provides detailed instructions and templates for organizations to submit their project budgets for FY2027, including comprehensive guidance on allowable direct and indirect costs. Direct costs encompass personnel expenses (salaries, wages, payroll taxes, and fringe benefits), operating costs (contractual services, supplies, utilities, equipment, travel, and direct assistance to beneficiaries), and equipment purchases. Indirect costs are capped at 10% of direct costs for administrative salaries and fringe benefits under Bernalillo County Behavioral Health Authority policy. The budget form requires organizations to detail all personnel positions with their full-time equivalent allocations, salaries, and justifications, along with itemized operating expenses with descriptions matching the approved contract.

The budget template establishes specific parameters for various cost categories, including a maximum benefit rate structure and constraints on certain expenses. Medicaid reimbursements must be entered as negative amounts to offset direct costs, and occupancy-related expenses (rent, utilities, and other) are limited to the proportion that contract revenue represents of the total agency revenue budget. Equipment purchases are restricted to items not exceeding $5,000 per unit for the consumable supplies category, with additional capital equipment requiring separate justification. The form requires detailed descriptions for all line items to ensure compliance with the allowable expenses outlined in the instructions. All positions and budget allocations must align with the terms of the approved contract with Bernalillo County.

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

Instructions

CET Budget Form 2021

Expenditure Category and Budget Form Instructions Overview Direct Costs: A direct cost is any cost that can be specifically identified with a particular Bernalillo County sponsored/funded project or program, or that can be directly assigned to such activities relatively easily and with a high degree of accuracy. Direct costs include, but are not limited to, salaries and wages, fringe benefits, contractual services, consumable supplies, telecommunications, equipment, duplicating/printing, transportation, insurance/bonds directly benefiting the sponsored/funded project or program

Indirect Costs No more than 10% is allowable for administrative salaries and fringe benefits.

Personnel Costs Salaries and Wages: Enter the amounts budgeted to pay salaries and wages for regular employees of the organization to carry out project-related activities and functions.

Payroll and Benefits: Enter the amounts budgeted to pay payroll taxes, and employee benefits such as health insurance. Payroll taxes should include legally mandated payroll taxes for regular employees of the organization, including FICA and unemployment insurance tax. The amounts budgeted must constitute an allocable percentage of salaries and wages.

Total Personnel Costs: Enter the sum of salaries, wages, payroll taxes, and employee benefits.

Operating Costs Contractual Services: Enter the amount budgeted to pay the costs of services provided to the project through contractual agreements with organizations and individuals (contract employees) who are not regular employees, with the exception of the costs for conducting annual or special audits.

Audit Costs: Enter the amount budgeted to pay the costs of conducting annual or special audits of the organization. The amount budgeted shall not exceed the proportion that the contract revenue is of the total agency revenue budget.

Consumable Supplies: Enter the amount budgeted to pay the costs of supplies and equipment utilized by the project which have a price which does not exceed $5,000 per unit. Supplies are expendable including office supplies, education and training supplies. Food is not an allowable expense in this category.

Telephone: Enter the amount budgeted to pay for the costs of project telephone services, including installation, local service, and long-distance tolls.

Postage and Shipping: Enter the amount budgeted for project postage and shipping.

Occupancy Rent: Enter the amount budgeted for space lease/rental costs allocable to the project. The amount budgeted shall not exceed the proportion that the contract revenue is of the total agency revenue budget.

Utilities: Enter the amount budgeted for the cost of project allocable electrical services, heating and cooling, sewer, water, and other utilities charged not otherwise included in rental or other charges for space. The amount budgeted shall not exceed the proportion that the contract revenue is of the total agency revenue budget.

Other: Enter the amount budgeted for other project allocable occupancy costs including the costs of security, janitorial services, elevator services, upkeep of grounds, leasehold improvements not exceeding $5,000, and related occupancy costs not otherwise included in rental or other charges for space.

Equipment Lease: Enter the amounts budgeted for the purchase or lease of equipment allocable to the project.

Equipment Maintenance: Enter the amount budgeted to maintain or repair existing agency equipment utilized in a funded project.

Printing and Publications: Enter the amount budgeted for the purchase and/or reproduction of project- printed materials, including the cost of photo-reproduction.

Travel Costs Local Travel: Enter the amount budgeted for the costs of project travel within Bernalillo County, including costs for mileage reimbursement and/or allocable operating and maintenance costs of agency owned or hired vehicles use to provide transportation to staff or clients within Bernalillo County. Per Diem for mileage cannot exceed the amount approved by the State

Conferences, Meetings, etc.: Enter the amount budgeted for the costs of registration and materials for staff, board, or clients attendance at meetings and conferences allocable to the funded project or for the costs of meetings conducted by the agency in connection with that contract.

Direct Assistance to Beneficiaries: Enter the costs budgeted for the payment of stipends, clothing, and other goods and services purchased directly on behalf of clients. This should be limited to a reasonable per client amount.

Membership Dues: Enter the amount budgeted to pay the costs of dues paid by the agency on behalf of staff, board members, or the agency itself to professional organization related to the purposes of the project. The amount budgeted shall not exceed the proportion that the contract revenue is of the total agency revenue budget.

Insurance: Enter the amount budgeted to pay the costs of insurance, including bonding, allocable to the project.

Total Operating Costs: Enter the sum of all line items under operating costs.

Total Direct Costs: Enter the sum of Total Personnel Costs and Total Operating Costs.

Indirect Costs: Enter the amounts budgeted to pay indirect costs for salaries and fringe benefits.

Total Project Expenses: Enter the sum of Total Direct Costs and Indirect Costs.

Budget Summary

Bernalillo County Behavioral Health Authority Division
BUDGET
Expense Summary Form
Agency Name:
Agency Contact:
Project Title:
Expenditure CategoryProject Total CostFY2027Total County FundingPercent of Project Total CostDetailed Description Descriptions must be complete.
Personnel Costs
Salaries & Wages0%
Payroll Taxes and Employee Benefits- 00%
Total Personnel Costs- 0- 0- 00%
Operating Costs * – Direct
Contractual Services- 00%
Audit Costs- 00%
Consumable Supplies- 00%
Telephone- 00%
Postage and Shipping- 00%
Occupancy- 00%
a. Rent- 00%
b. Utilities- 00%
c. Other- 00%
Equipment Lease- 00%
Equipment Maintenance- 00%
Printing & Publications- 00%
Travel - local only- 00%
Conferences, Meetings, Etc.- 00%
Direct Assistance to Beneficiaries- 00%
Membership Dues- 00%
Equipment, Land, Buildings- 00%
Insurance- 00%
Total Operating- 0- 0- 00%
Total Direct Costs (Personnel & Operating)- 0- 0- 00%
Medicaid Costs: **
Medicaid Reimbursements

Tamera Walden: Tamera Walden:

enter as a negative amount- 0
Indirect Costs = 10% or less of Direct Costs by BHI policy
Salary- 00%
Fringe- 00%
TOTAL Indirect Costs:- 0- 0- 00%
Total Project Expenses- 0- 0- 00%
*See Expenditure Category Instructions for Additional Information
**Medicaid reimbursement estimate for the program is required. The description must identify the line items to which the revenue is allocated.

Budget Detail Personnel

Bernalillo County
Behavioral Health Authority Division
Personnel Costs
1. Agency Name:0
2. Agency Contact:0
3. Project Title:0

Personnel costs: Use this form to justify all salaries, wages, payroll taxes and fringe benefits shown on the Request for Reimbursement Form. Add additional rows as necessary. All positions and allocations must match the approved contract.

FTE
on ProjectPosition TitlePosition Total SalaryFY2027Medicaid/Billing LeveragePosition Description
- 0
- 0

- 0

- 0
4. Salaries & Wages this Page- 0- 0- 0
5. Payroll Taxes and Employee Benefits *- 0- 0
6. Total Personnel Costs- 0- 0- 0
* Payroll Taxes include FICA, Unemployment Insurance, Workers Comp, Employee Benefits (health insurance, retirement, other)
Enter Benefit Rate:
(This rate may not be exceeded during the contract period, but amount requested may be less than this rate.)

Sheet1

IDCERROR:#REF!
25%ERROR:#REF!
TotalERROR:#REF!
Personnel- 0
25%- 0
Total- 0
ERROR:#REF!$ 461,715.21
ERROR:#REF!$ 46,171.52

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