HomeMy WebLinkAboutRes 132 - Appropr Grant - Health FundDeschutes County Board of Commissioners
1300 NW Wall St., Suite 200, Bend, OR 97701-1960
(541) 388-6570 -Fax (541) 385-3202 -www.deschutes.org
AGENDA REQUEST & STAFF REPORT
For Board Business Meeting of November 21,2011
Please see directions for completing this document on the nextpage.
DATE: November 14, 2011
FROM: Marty Wynne Finance (541) 388-6559
TITLE OF AGENDA ITEM:
Consideration and signature of Resolution #2011-132, appropriating a new grant in the Public Health
Fund.
PUBLIC HEARING ON THIS DATE? NO
BACKGROUND AND POLICY IMPLICATIONS:
Consideration of Resolution #2011-132. The Public Health Department was awarded additional grant
funding in the amount of $107,040 to be used to implement a regional program with Jefferson and
Crook Counties for the Personal Responsibility Education Program. This program will provide youth
with the skills to have healthy, safe relationships and to reduce rates of teen pregnancy and sexually
transmitted infections in our community. Resources will be used to increase two Health Educator I
positions by a total of .90 FTE.
FISCAL IMPLICATIONS:
The County will receive an additional $107,040 from the State. This funding will provide additional
resources not included in the FY 2012 Adopted Budget and will be appropriated for Personnel,
Materials & Services and Contingency.
RECOMMENDATION & ACTION REQUESTED:
Approval and signature of Resolution #2011-132
ATTENDANCE: Marty Wynne
DISTRIBUTION OF DOCUMENTS:
Marty Wynne, Finance Department 388-6559
Scott Johnson, Behavioral Health 322-7502
Sherri Pinner, Behavioral Health 322-7509
I
1
REVIEWED
LEGAL COUNSEL
For Recording Stamp Only
BEFORE THE BOARD OF COUNTY COMMISSIONERS OF DESCHUTES COUNTY, OREGON
A Resolution Appropriating New Grant Funds *
to the Deschutes County 2011-2012 Budget RESOLUTION NO. 2011-132 *
*
WHEREAS, Deschutes County Public Health Department will receive new State grant revenue
totaling $107,040; and
WHEREAS, these new grant funds need to be appropriated; and
WHEREAS, ORS 294.326(2) allows the appropriation and expenditures of new grant funds
designated to specific purposes; now, therefore,
BE IT RESOLVED BY THE BOARD OF COUNTY COMMISSIONERS OF DESCHUTES
COUNTY, OREGON, as follows:
Section 1. That the following grants be budgeted:
Revenue
259-0000-334.12-00 State Grant $107,040
TOTAL REVENUE: $107,040
Section 2. That the following appropriations be made within the 2011-12 County Budget:
Expenditures
Personnel Services:
259-2000-441.16-22 Health Educator I (.90 FTE) $ 40,441
259-2000-441.21-10 Life/Long Term Disability $ 339
259-2000-441.21-50 Health/Dental Insurance $ 12,630
259-2000-441.22-01 FICA/Medicare $ 3,094
259-2000-441.23-01 PERS-Employee/Employer $ 5,221
259-2000-441.25-01 Unemployment Insurance $ 459
TOTAL PERSONNEL SERVICES $ 62,184
PAGE I OF2-RESOLUTION NO. 2011-132 (11121111)
Materials & Service:
259-2000-441.33-99
259-2000-441.53-11
259-2000-441.58-20
259-2000-441.58-30
259-2000-441.58-70
259-2000-441.61-22
259-2000-441.61-34
259-2000-441.61-70
Contracts
Data Lines
Meals
Accommodations
Mileage
Educational Supplies
General Supplies
Program Supplies
$ 28,890
$ 108
$ 1,848
$ 1,130
$ 3,137
$ 1,500
$ 1,100
$ 2.600
TOTAL MATERIALS & SERVICE $ 40,313
Contingency:
259-2000-501.97-01 Contingency $ 4,543
TOTAL EXPENDITURES $ 107,040
Section 2. That the Finance Director make the appropriate entries in the Deschutes County
Budget document to show the above appropriations.
DATED this _____ st day of November, 2011.
BOARD OF COUNTY COMMISSIONERS OF
DESCHUTES COUNTY, OREGON
TAMMY BANEY, Chair
ATTEST: ANTHONY DEBONE, Vice-Chair
Recording Secretary ALAN UNGER, Commissioner
PAGE 2 OF 2-RESOLUTION NO. 2011-132 (11/21111)
Deschutes County
Supplemental Budget
FY 2012
RESOURCES
Line Number
Item (HTE 14 digit code)
Project
Code Description
Current Budgeted
Amount To (From)
Revised
Budget
1 259-0000-334.12-00 HPREP State GoV!. Grants State Grant 2,603,104 107,040 2,710,144
-
TOTAL 2,603,104 101,040 2,110,1~
REQUIREMENTS
Line Number
(HTE 14 digit code)
2
Item
259·200Q.441.16-22
3
259·2000-441.21·10
4
259·2000-441,21·50
5
259-2000-441.22-01
6
259·200Q.441 .23-01
7
259·200Q.441.25-01
8
259·2000-441.33-99
9
259·2000-441.53·11
10
259-2000-441,58·20
11
259·200Q.441.58·30
12
259·2000-441.59-70
13
259·2000-441,61·22
14
259·2000-441.61·34
15
259·2000-441.61·70
16
259·2000-501.97·01
17
18
19
Project (Element·Object. e.g. Time Mgmt. Current Budgeted Revised
Code (Pers, M&S, Cap Out, Contingency) Temp Help, Computer Hardware) Amount To (From) Budget
HPREP Personnel Services Health Educator I (.90 fie) 7,968 40,441 48,409
HPREP Personnel Services Life/Long Term Disability 27,969 339 28,308
HPREP Personnel Services HealthlDental Insurance 993,700 12,630 1,008,330
HPREP Personnel Services FICAlMedicare 313,782 3,094 316,876
HPREP Personnel Services PERS • Employee/Employer 506,103 5,221 511,324
HPREP Personnel Services Unemployment Ins. 25,015 459 25,534
HPREP Materials and Services Contracts -28,890 28,890
HPREP Materials and Services Data Lines 5,100 108 5,206
HPREP Materials and Services Meals 6,830 1,848 8,678
HPREP Materials and Services Accomodations 27,750 1,130 28,880
HPREP Materials and Services Mileage 15,380 3,137 18,517
HPREP Materials and Services Educational Supplies 8,406 1,500 9,908
HPREP Materials and Services General Supplies . 1,100 1,100
HPREP Materials and Services Program Supplies 32,362 2,600 34,962
HAD Contingency Contingency 875,683 4,543 880,226
-
.
TOTAL 2,846,110 107,040 2,953,150
Category Description
PubliC Health has been awarded a five year Personal Responsibility Education Program grant for implementation of a regional program with Jefferson and Crook Counties.
This program provides youth with the skills to have healthy, safe relationships and to reduce rates of teen pregnancy and sexually transmitted infections in our community.
This FTE will be allocated to two staff, one a .60 and adding ,30 to a current employea, yet 10 be identified.
FTE will be hired in August 2011.
Fund:
Dept:
Requested by:
Date:
259
Health Services· Public Health
Beth Ragulne
81812011
Judi Hasse
From: Teri Maerki
Sent: Wednesday, November 09, 201110:10 AM
To: Judi Hasse
Subject: FW: PH budget resolution -PREP grant
Attachments: PH PREP grant by BR.xls
-----Original Message----
From: Beth Raguine
Sent: Monday, August 08, 201111:42 AM
To: Teri Maerki
Subject: RE: PH budget resolution -PREP grant
Yes, you are correct. I guess my brain decided to join Sherri on vacation. I hope this does not foretell a long week
around here!
Here is the revised revision.
Beth Raguine
Senior Accounting Technician
Deschutes County Health Services
2577 NE Courtney Dr.
Bend, OR 97701
541-322-7449
bethr@deschutes.org
-----Original Message----
From: Teri Maerki
Sent: Monday, August 08, 201111:33 AM
To: Beth Raguine
Subject: RE: PH budget resolution -PREP grant
Looks much better. However, take a look at the FICA and PERS current budget figures as I think they may be switched.
-----Original Message----
From: Beth Raguine
Sent: Monday, August 08, 201111:21 AM
To: Teri Maerki
Cc: Sherri Pinner
Subject: RE: PH budget resolution -PREP grant
Hi Teri,
Attached is the revised document you requested.
1
Per our conversation, , have added the current line item budget totals and corrected the formulas. It is my
understanding that this is a new service element to the state grant and will be a new project code this year. I will review
this with Sherri when she returns from vacation.
Beth Raguine
Senior Accounting Technician
Deschutes County Health Services
2577 NE Courtney Dr.
Bend, OR 97701
541-322-7449
bethr@deschutes.org
-----Original Message----
From: Teri Maerki
Sent: Monday, August 08, 2011 8:53 AM
To: Beth Raguine
Cc: lacy Nichols; Marty Wynne
Subject: FW: PH budget resolution -PREP grant
I sent this to Sherri and got her out of office message.
Are you able to fix the Excel file for the resolution she is requesting?
Teri
From: Teri Maerki
Sent: Monday, August 08, 2011 8:45 AM
To: Sherri Pinner
Subject: PH budget resolution -PREP grant
, happened to notice the Current Budgeted Amount column under Requirements is blank and will need to be filled in
with the current line item budget totals.
Also the Total formula in the Revised Budget column under requirements looks like it needs to be fixed as it only adds up
to $40,441.
Teri
-----Original Message----
From: Sherri Pinner
Sent: Friday, August OS, 2011 3:45 PM
To: Marty Wynne
Cc: lacy Nichols; Teri Maerki; Tracy I Scott
Subject: PH budget resolution -PREP grant
Attached please find a budget resolution requesting additional FTE in our public health division related to a newly
awarded five year grant.
2
Public Health has been awarded a Personal Responsibility Education Program grant for implementation of a regional
program with Jefferson and Crook Counties. This program provides youth with the skills to have healthy, safe
relationships and to reduce rates of teen pregnancy and sexually transmitted infections in our community.
Please let me know if you have any questions.
Sherri Pinner
Business/Operations Manager
Deschutes County Health Services Department
541-322-7509
541-322-7565 fax
Our mission: To promote and protect the health and safety of our community.
3