7-Montco Budget Template RFP 25-65.xlsx

XLSX spreadsheet 63 KB Posted

Attached to
Homeless Management Information System (HMIS) and Data Consultant
Solicitation number
25-65
Issued by
Montgomery County, Pennsylvania

About this file

This is a budget template submission form for Montgomery County agencies seeking funding for programs and services. The template is designed for agencies to submit comprehensive budget proposals across multiple expense categories and revenue streams. Agencies are required to complete detailed budget schedules covering staff and habilitation costs, room and board maintenance, property and equipment, transportation, residential adaptation, and agency indirect costs. Supporting documentation is required for wages and salaries, including separate schedules for direct service employees and indirect administrative staff. The template also includes detailed schedules for rent documentation, purchased treatment services, and program equipment, with agencies required to indicate cost participation eligibility and variance analysis of three percent or greater.

The budget template requires agencies to provide audited or actual data and projected financial information across three budget periods, with calculated gross and net fee-for-service rates per unit of service delivery (day, hour, session, or other specified unit). Agencies must document all revenue sources including Medical Assistance, liability payments, room and board income, third-party or private insurance, and other income, with the requested funding from Montgomery County calculated as total expenses less anticipated income. For agencies providing multiple programs, a cost allocation plan must be submitted explaining the methodology used to distribute indirect costs among various programs. The template includes specific account coding requirements aligned with standard chart of accounts classifications and requires documentation of property leases, purchases by related parties, and agency-owned properties with corresponding fair market value appraisals.

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

Budget

Budget Submission
Montgomery County
Agency Name:
Billing Address :Facility Address:
Program Name:
123456
Audited/ActualActual+ProjectedProjected
DESCRIPTIONA/CCOMMENTS
#
A . STAFF / HABILITATION
1) Wages and Salaries*111
2) Employer Match Taxes121
3) Retirement - Provider122
4) Insurance and Other123
5) Staff Development131
6) Purchased Personnel132
7) Habilitation Equipment345
8) Purchased Practitioner Service*361
9) Communications321
10) Accounting Fees132
11) Auditing Fees132
12) Legal Fees132
13) Advertising322
14) Communications321
15) Education Supplies and Equipment346
16) Other
SUB - TOTAL STAFF$0$0$0
Indicate VARIANCE of 3% (+/-)N/A
* include a supporting schedule
B . ROOM , BOARD MAINTENANCE
1) Rent / Mortage Payment *311
2) Utilities (water, gas, electric, sewer, oil)312
3) Insurance - Casuality Loss/ Property313
4) Housekeeping314
5) Library371
6) Office Supplies331
7) Medical Supplies341
8) Drugs342
9) Food343
10) Clothing344
11) Recreational Supplies347
12) Household Goods348
13) Other Expenses*373

SUB -TOTAL ROOM , BOARD $0 $0 $0

Indicate VARIANCE of 3% (+/-) N/A

C . Property (Furniture & Equipment)

1) Program Equipment412
2) Furniture413
3) Office Equipment415
4) Program Equipment Repair422
5) Furniture Repair423
6) Office Equipment Repair425

SUB - TOTAL Property $0 $0 $0

Indicate VARIANCE of 3% (+/-) N/A

D . TRANSPORTATION

1) Client Transportation352
2) Automobile Leased /Purchased*315
3) Automobile Insurance313
4) Automotive Repairs & Maintenance313
5) Staff Travel351
SUB - TOTAL TRANSPORTATION$0$0$0

Indicate VARIANCE of 3% (+/-) N/A

E . RESIDENTIAL ADAPTATION
1) Building Repairs421
2) Furniture & Equipment Repairs422
3) Building Adaptation - Minor421
4) Building Adaptation/Renovations424
5) Building Maintenance425
6) Interest Expense362
Sub-Total Residential$0$0$0

Indicate VARIANCE of 3% (+/-) N/A

F . AGENCY INDIRECT
1) Indirect Budget" F "
Admin Rate of Total ExpenseERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

TOTAL EXPENSES $0 $0 $0

Indicate VARIANCE of 3% (+/-) N/A

G . REVENUE/ ANTICIPATED INCOME
1) Medical Assistance530
2) Liability Payments570
3) Room & Board571
4) Third Party/ Private Insurance580
5) Interest Income
6) Other Income- Specify

TOTAL ANTICIPATED INCOME $0 $0 $0

Indicate VARIANCE of 3% (+/-) N/A

H . EXPENSES LESS INCOME $0 $0 $0

I . REQUESTED FROM Montgomery County $0 $0 $0

Fee For Service RateGross Rate :ERROR:#DIV/0!Per
Specify Unit : ( i. e. )
Day / Hour / Session / Etc.Net Rate :ERROR:#DIV/0!Per

Wages

Budget Submission
Montgomery County
Agency Name:
Billing Address :Facility Address:

Program Name:

WAGES AND SALARIES

Staffing TypeAgency Total SalaryEligible for Participation
(D) Direct

Hill, Synethia: Employees whose primary responsibilities involve providing services directly to program participants

TitleHoursFull TimeSalaryFull TimeSalary
(I) Indirect
Hill, Synethia: Employees who support the program but primary duties do not involve direct work with participants (e.g., administrative staff, finance, HR, upper management, consultants, etc...)PerAnnualto beAnnualto be
NameWeekRatePaidRatePaid

Total

Indirect Costs

Budget Submission
Montgomery County
Agency Name:
Billing Address :Facility Address:

Program Name:

" F " INDIRECT SERVICES BUDGET

ACCOUNTACCOUNT DESCRIPTIONAMOUNTREMARKS
#
A. PERSONNNEL COSTS
111ASalaries
121ASocial Security Contribution
122ARetirement
123AInsurance and Other Benefits
131AStaff Development
132APurchased Personnel Services
133AOther Personnel Expenses

SUBTOTAL

B. OPERATING COSTS
311ARent
312AUtilities
313AInsurance
314AHousekeeping
321ACommunications
331AOffice Supplies
351AStaff Travel
371ALibrary
372ADebt Service
373AOther Indirect Operating Expenses

SUBTOTAL

C. EQUIPMENT
411ABuilding and Land
412AOffice Equipment
415AMotor Vehicles
421ABuilding Repairs
422AEquipment Repairs
423AMotor Vehicle Repairs

SUBTOTAL

TOTALS

COST ALLOCATION PLAN :

If your agency provides more than one program , to which you allocate these indirect costs , please
provide an explanation of the method used to distribute these costs among the various programs.

RENT A

Budget Submission
Montgomery County
Agency Name:
Billing Address :Facility Address:

Program Name:

311 RENT Schedule A
Listing of Property Leased From An Unrelated Party
AmountFair
SiteLessorType OfFacilityAnnualCharged toRental
AddressName and AddressProgram#RentCountyAppraisal

RENT B

Budget Submission
Montgomery County
Agency Name:
Billing Address :Facility Address:

Program Name:

311 RENT Schedule B
Listing of Property Purchased By A Related Party
SiteRelated PartyAnnualAmountFair
AddressName and AddressType ofFacilityDate ofPurchaseDownLength ofPrincipalCharged toRental
Program#PurchasePricePaymentMortgageInterestCountyAppraisal

RENT C

Budget Submission
Montgomery County
Agency Name:
Billing Address :Facility Address:

Program Name:

311 RENT Schedule C
Listing of Property Purchased By Agency
SiteAgencyAnnualAmountFair
AddressName and AddressType ofFacilityDate ofPurchaseDownLength ofPrincipalCharged toRental
Program#PurchasePricePaymentMortgageInterestCountyAppraisal

Rents

Budget Submission
Montgomery County
Agency Name:
Billing Address :Facility Address:
Program Name:
311 RENT Schedule A
Listing of Property Leased From An Unrelated Party
AmountFair
SiteLessorType OfFacilityAnnualCharged toRental
AddressName and AddressProgram#RentalCountyAppraisal

Treatment

Budget Submission
Montgomery County
Agency Name:
Billing Address :Facility Address:

Program Name:

PURCHASED TREATMENT SERVICES

DefinitionNumberAmt. Eligible
TypeProvidersof Unitof Unitsfor DPW
(List Individually)Ratefor RateProvidedTotal CostParticipation

Total

Assets

Budget Submission
Montgomery County
Agency Name:
Billing Address :Facility Address:

Program Name:

PROGRAM EQUIPMENT

CostAmountAmount NotAmount
CenterQuantityDescription of ItemExpendedEligibleEligible
DPW Part.for DPW

TOTAL

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