HomeMy WebLinkAboutTax-Finance UpdateMonthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
July 25, 2011
(1) Monthly Investment Report
(2) June 2011 Financials
'• eschut s Dunt A
- ...7d•lioAs0
Investment Income
Fiscal Year 2010-11
—
O
H
}
T
c
$ 58,881 $ 874,431
Total Investment Income 58,881 874,431
Less Fee: 5% of Invest. Income (2,944) (43,722)
Investment Income - Net s 55,937 $ 830,710
II Investments By County Function
General $ 115,991,795
Total Investments $ 115,991,795
`P at ` 4
O_ O O O_ O
O O 0 CI O
O T OD O O 4 O
01 CO CO A-
lA CO (l
' co O ' CO ' r
Y'—
CO N I fP,
) ,
CDM li) ..-
CV.
N c N
A- M,
fie
of
T
O!
Qf
47
T
T
Total Investments
0
O
0
c
L
0
0 0 e
'eFMO
NO OD CD
O Q
cr. o O
140 CH 00
1C1tico
Oc
L
0
co
0.
0
U
Average Maturity in Days
aZ 0 0 10 e o 0
0 0 r- 4) Y) 0 0
0 0 ►� N N N
T r
N CO
E U
ca la m
7, N • V yOy_ d t0 N
m -c c U m 4 O
2 7 d U !'=l� Z
N
a)H s� O U
rvi 13_ 0 C m E a
111_,WO m E 0 0
0 -1 u- CO - 0 0
Total Portfolio: By Investment Types
m
N
E
0
m
F2
N o
a o
a Z
U
UU.0 UU UU
21z z z1zz,z
01010110
jz z
U UUiU UIU
z 2i 2,z
m-� '. rlrl r- 1�
a 8 2 8Q. Q8 0i m ,6 051,6 Q8 , c••4 o o 18, �4 � � S i cd co' d � 8
c4.r� ..iui r -Ii a; Til �i uQi ui a!� aril �
s n ° a p a'r ai pp o„ cc; n N
3 � ' NI Qrn N I'I I � 0 `iV { r� Q' M th v 'p Q NN 01 {{`��_. o 0 0�.1 4,4
a m R O a oro O O. O N N O O O Q r 0 O N
NIN N LN N N; •fV 'NI NIrININ N,N "
0
TI
q
cio
RI cc
m
8
N.ry N
81881812 ago' 2!2.18'; 8 gl
§l§!§88SIg881"§1 1(��yy5'
88 1
8 0 Q .1818 81 NI
N N NIN N r N 0.-1 NiN
88185i88188818 4,2 81818 8 0818.18 8181$18.18. 8-18.'3 E818.1888,q
Q8. SS R o $ISYS g m N ' 1 �� $ {� ISS g mf :i v 581 D <q v1Qig!Qo
25§151r6§181ogog''o' oNgoj og188128f$g',BIgQ$8E1881 f 251
NI N N NjN (V N N LV N oil I oil rI N N. N NI NI iV N N N N N N ••••;N
I I I' / I
8 2!8 818 81818'8'8'8`8 818 8 8. 8 °�18 818 8 8 81818 8 8 81818 81
8RR8§§§NW§§.1§§§.g, �§ I I UM§§1§§1
55�� I � O V O Q 01 Q N 5� .- � 5� n'i 1� � ' {
V Ig25MaNa§ Ir881rS�. 25g25Z51o8m 15�$Z'_5125
N O N� O Ola
N1 N1N N NI N i-j(VIN N NIN (V N,N N (V (`a N � t M [V (V
88 pmt , r apOp e 8.�e l 8.e a 8.e ate* * e l s 8.e. �z apurae 8.e a� 8.e 8.e 8.e ael 8.e i 8.e.
f�O n1 �10.10� nl i 3.8.0 19- 200i§- 1,a�u�"i1(NO.i,�N.8 m(OVN-0
10 O O 0 01 O 01 - Old r O a O 010 010 al0 0 0 -'O.0 O O O OI.- 00
}
• * a 1r 1� et
I* ,g,!*
;8.oQWl4NpN Sf�e
e
2n8 §�'k2 `1$ ▪ N$ 811§N8108Nf M
ItiO.d tai O N r r N10 .- ID 014 O of OI OIN JOIN o O o
114,704,727.14
DV CO
Da 0 • ''0
d 0 a
C
m
I E
010 b
g18 m
E . o`c
Imlma R
1E Y °
0 4(-�'01 rn ,.,jr-� 0 rn obico'M o'1- 21810, j orlti IMIm (V� n • y'2
Al* NV' 10: VIY'] OIm1:Car 11l rzIA N N N re n I8O,I' P2Ir 0P. P O n..?,�IIA t� .12 r21P2 g Iv T
I^ 1- N,� N N NIN N C41N N �1 NI N1CV N N N_1 �'^ MjM M M M'MI� M O0 Y O
r1i103' `� v00op,r?Sirrv.�' • • c-1a_I .a:m`1 .�$ �1g.2 3mCf &>I°2,
.t...-1 N o .=,-..--.
o+ g g'E.i' _a r INI o Q 5�vv
13 ��}} 8.i' d r7 8 8 o I 8.'$'a '' : c� ,} vl s' 3 F;
�i o 8. o 0 0 8 0 0 D o { :a. o o,6, �I�Iold I 4 r 'm
0 01010 oid 0 0 o;8. 8l 9l8 0 0l j. o o 7Iololo o a o T'� ;I�
civ ti's h n oI...
o 2S `I :8. r o_ g n o gig a 'j' �Im u418. a 8.I+
E.'-': s` Ialj���a �Iala� -Igio 1�
8 0 o a o G5 -s-11'82 d. 1E a d a g, g o of alol ¢ K
UU
atl61 LLC 0 I U,U.'1<141Z 1u_l010 OIi 4 010 u<.I LQ.. I1 U -II- LL1,LL10'�0I0Q. LI- 0 -ILL 0IZ -iI-lalli
w z1 LL 0- -, z1zILL m do 8.,0 8. r s•la z z z LL a z LL Z
e 9.u0-0-lcnco'�ccC olD'mayr�,'.01mIO coIcoto 51 .0
_H°3. Fi~4.°-'n -. .. WljO MI011d'Ym7lado_.
-a• z , LL, c -,1 r, 1• =-1x. pdp �'n U' 4 Q N. , f�'
Q M co ` co. M' � Mj M M 8 8 �Mj C)
in 2 '.�i � cn c`7 .1_,i,.,1 ' � 1 Z 7, cn 1 7, M M I gi * NI c' g i'I 8
2
0
0 I8 V CJ
z U U 41
U sf. a U 1p
f_1I L!. --r°
c B1� �' ,VII
z U ro mIU u�0 i s I NI U
zu.ml ``
�Il al m 6 ti! al A cl li m �l u
Ll �m O fo m L m 'aim
b til
m WIN. a1 o� _�' Ull`1
co ml .1117m:m!mm1 ¢ E'o uml' maaglm¢'mlm W¢¢
> 0116 1 4U U1_i U 2 ..2 ° e t E .1 c», E 2 014 c 2 2
' 1_1 .II E1+,0-=LL10,Z o Elm EZ ESi12IozLL o m z z
LL DI} 0 LL LL u. LL FILL 0 �'m 7LLrLL 7iLL LLILL S LL LL;C7 C7 LL LL
a
m
0.10-11- 1i O
z < u.Iixiazl¢ 'zI>Iz r
d, col U.I U Urn'I Uiro co 0,, 0}
0
O
n
0
0
0
U iL. Uy u
U` ❑ cx,.
�0cnM I
2 N•[�Q 7 cyy MI
MIT IMi .Z.7)
IU. Q ,O
_-U'• w .0 ,X1
C•stlt -0 U
,�I m
4 WI
iU o m . C
H.9.03,0, �O. 1
wpT
1N
_m LI- -qUj • •
m11m d m Jimm 2Im1 m G
W
tiLL >0m w'0 m 0OIIII o T ILL (LIO 110 LL 0 -ILL LAA LL W
I
8ir 3.8
di; fila
WI
ni
8
g
Memorandum
Date: July 20, 2011
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find June 2011 financial reports for the following funds: General
(001), Community Justice — Juvenile (230), Sheriffs (255, 701, 702), Public Health
(259), Behavioral Health (275), Community Development (295), Road (325),
Community Justice — Adult (355), Commission on Children & Families (370-399),
Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675),
and Fair & Expo Center (618).
The projected information has been reviewed and updated, where appropriate, by the.
respective departments.
Cc: All Department Heads
RESOURCES:
Beg. Net Working Capital
Revenues
Property Taxes
Gen. Rev. - excl. Taxes
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Non -Departmental
Contingency
Transfers Out
TOTAL REQUIREMENTS
NET (Resources - Requirements)
GENERAL FUND
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Year to Date
Budget
Actual
Variance
FY
CoII. %
$ 8,300,000 $ 9,677,699
20,566,000
2,397,138
795,690
1,220,714
12,398
314,100
180,200
67,866
91,132
2,000
25,647,238
$ 1,377,699 100% 117%
21,419,761 853,761 100% 104%
2,491,745 94,607 100% 104%
826,610 30,920 100% 104%
1,507,272 286,558 100% 123%
13,077 679 100% 105%
209,868 (104,232) 100% 67%
198,257 18,057 100% 110%
67,544 (322) 100% 100%
96,146 5,014 100% 106%
2,000 - 100% 100%
26,832,280 1,185,042 100% 105%
33,947,238 36,509,979
2,562,741 100% 108%
3,382,219 3,244,647 137,572
1,484,127 1,313,225 170,902
75,403 66,610 8,793
4,882,127 4,773,245 108,882
856,910 815,991 40,919
274,837 265,442 9,395
261,227 254,471 6,756
117,203 114,967 2,236
2,293,337 1,836,466 456,871
4,582,684 4,582,684
18,210,074 12,685,066 5,525,008
15,737,164 15,727,164 10,000
33,947,238 28,412,230 5,535,008
8,097,750
8,097,750
Beginning NWC per Adopted Budget
7,300,000
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
Exp.
96%
88%
88%
98%
95%
97%
97%
98%
80%
n/a
850/0
100%
93%
COMM JUSTICE -JUVENILE
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
RESOURCES:
Beg. Net Working Capital
Revenues
Federal Grants
SB #1065 -Court Assess.
Discovery Fee
Food Subsidy
OYA Basic & Diversion
Inmate/Prisoner Housing
Inmate Commissary Fees
Contract Payments
Miscellaneous
MIP Diversion Fees
Interest on Investments
Leases
Grants - Private
Behavioral Health
CCF Interfund Grant
Gen Fund Grant -Crime Prev.
Total Revenues
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Budget
Actual
Variance
FY %
Coll. %
$ 987,000 $ 1,039,997 $ 52,997 100% 105%
15,527
60,000
16,000
38,000
340,006
100,000
100
88,490
300
1,000
17,000
2,400
500
6,000
60,495
20,000
765,818
5,543,186
7,296,004
12,135 (3,392) 100% 78% a)
53,697 (6,303) 100% 89% b)
12,441 (3,559) 100% 78% b)
27,583 (10,417) 100% 73% b)
182,135 (157,871) 100% 54% c)
75,300 (24,700) 100% 75% d)
154 54 100% 154%
88,350 (140) 100% 100%
70 (230) 100% 23%
295 (705) 100% 30% b)
8,009 (8,991) 100% 47%
2,400 100% 100%
1,697 1,197 100% 339%
3,319 (2,681) 100% 55% b)
72,375 11,880 100% 120% e)
15,000 (5,000) 100% 75%
554,961 (210,857) 100% 72%
5,543,186
100% 100%
7,138,144 (157,860) 100% 98%
Personal Services 2,963,956 2,746,604
Materials and Services 1,199,886 1,077,777
Capital Outlay 100
Juvenile Resource Center
Personal Services 2,315,104 2,147,293 167,811 100%
Materials and Services 175,494 175,880 (386) 100%
Contingency 641,464 641,464 100%
217,352 100%
122,109 100%
100 100%
Exp. To
93% f)
90% 9)
93% h)
100%
nla
TOTAL REQUIREMENTS 7,296,004 6,147,554 1,148,450 100% 64%
NET (Resources - Requirements) 990,590 990,590
Beginning NWC per Adopted Budget 1,101,374
a) Fourth quarter Federal Grant reimbursement of $3,000 is expected in June
b) Revenues trending less than projected due to reduction in use of services and lower juvenile populations
c) OYA monies collected in Nov, Feb, May, and June - New reduction due to under -utilization of Maplestar treatment foster care -
(population of kids in Maplestar less than anticipated in the original budget). Approximately $75,000 payment anticipated in June
d) Revenue is generated when non -Deschutes juveniles utilize facility - less utilization than anticipated to date
e) Additional funding from CCF allocated for Juvenile programs
f) Personnel savings due to approximately 3.00 FTE unfilled
g) DHS/BRS match payments and Maplestar contract payments are less than originally budgeted due to reduction
in youth using the program
h) Personnel savings due to less on-call and overtime for the detention facility
RESOURCES:
Beg. Net Working Capital
Revenues
Law Enf Dist Countywide
y Law EnfyDisf.•Rural .. ,
Total Revenues
SHERIFF - Fund 255
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY %
Coll.
22,829,457
13, 665,939
36,495,396
$ - $
18,138,940
11,428,545
29,567,485
TOTAL RESOURCES 36,495,396 29,567,485
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division 3,077,051
Civil 822,436
Automotive/Communications 1,653,036
Investigations/Evidence 1,650,792
Patrol/Civil/Comm Supp 8,015,651
Records 660,386
Adult Jail 9,854,864
Court Security 280,851
Emergency Services 179,441
Special Services Division 1,298,604
Regional Work Center 2,892,242
Training Division 330,000
Other Law Enforcement Svcs 611,917
Non -Departmental 283,018
Contingency 4,685,107
Transfer Out - Jail Remodel 100,000
Transfers Out - DIS Fund 100,000
(4,690,517)
(2,237;394)
(6,927,911)
100%
100%
100%
100%
(6,927,911) 100%
2,959,895 117,156 100%
780,646 41,790 100%
1,514,404 138,632 100%
1,482,795 167,997 100%
7,729,134 286,517 100%
622,378 38,008 100%
8,882,472 972,392 100%
272,025 8,826 100%
169,801 9,640 100%
1,154,169 144,435 100%
2,660,758 231,484 100%
261,945 68,055 100%
594,044 17,873 100%
283,018 100%
4,685,107 100%
100,000 100%
100,000 - 100%
TOTAL REQUIREMENTS 36,495,396 29,567,485
NET (Resources - Requirements)
Beginning NWC per Adopted Budget
nla
79%
84%
81%
81%
Exp,
6,927,911 100%
a) Less than planned M&S expenses for the year
b) Delay in filling open positions will result in lower personnel expenditures for FY 2011
c) Expenditures grant funded consulting contract will be made in FY 2012
d) Unfilled budgeted positions and no planned jail bed rental. $350,000 for JMS software
will be expended in FY 2012
e) Unfilled budgeted positions and lower material and service expenditures projected for FY 2011
f) Personnel expenses will be lower than planned due to employee transfers
96% a)
95% b)
92% c)
90% b)
96% b)
94% b)
90% d)
97%
95%
89%
92% e)
79% f)
97%
100%
nla
n/a
100%
81°/°
Fund 701 LED -Countywide
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY °/J Coll. %
RESOURCES:
Beg. Net Working Capital $4,722,862 $ 5,609,156 $ 886,294 100% 119%
Tax Revenues - Current 14,853,594 15,003,874 150,280 100% 101%
Tax Revenues - Prior 642,000 795,339 153,339 100% 124%
Federal Grants 35,00048,563 13,563 100% 139%
State Grant 48,475 72,573 24,098 100% 150%
Transp. of State Wards 5,000 3,321 (1,679) 100% 66%
SB 1145 1,974,660 1,854,463 (120,197) 100% 94%
Des. Cty Video Lottery Grant 5,000 5,000 100% 100%
Des Cty Court Security 95,000 94,855 (145) 100% 100%
Des Cty Juvenile Contract 4,994 4,994 100% n/a
Title 111 Reimbursement 150,000 154,996 4,996 100% 103%
Transport 4,000 487 (3,513) 100% 12%
DC Fair & Expo Center 5,260 5,280 100% n/a
Inmate Commissary Fees 48,000 75,217 27,217 100% 157%
Work Center Work Crews 25,000 49,725 24,725 100% 199%
Concealed Handgun Classes 6,000 4,125 (1,875) 100% 69%
Soc Sec Incentive -Fed 5,000 7,800 2,800 100% 156%
Miscellaneous 5,000 7,187 2,187 100% 144%
Oregon Mentors 14,750 14,750 100% n/a
Medical Services Reimb 12,000 19,094 7,094 100% 159%
Restitution 1,000 4,114 3,114 100% 411%
Sheriff Fees 160,000 257,255 97,255 100% 161%
Interest 28,333 50,285 21,952 100% 177%
Interest on Unsegregated 3,533 1,837 (1,696) 100% 52%
Rentals 2,500 2,500 100% n/a
Donations 200 200 100% n/a
Sale of Reportable Assets 1,257 1,257 100% n/a
Total Revenues 18,106,595 18,544,506 437,911 100% 102%
TOTAL RESOURCES 22,829,457 24,153,662 1,324,205 100% 106%
REQUIREMENTS:
Department
Sheriffs Services
Civil
Auto/Comm
Adult Jail
Court Security
Emer Svcs
Special Services
Work Center
Training
Other (CODE, Forensic)
Internal Services
Transfer to Debt Service
Transfer to Jail Remodel
Transfer for Reserve Fund
Contingency
Exp. %
2,910,890 2,800,061 110,830 100% 96%
822,436 780,646 41,790 100% 95%
595,093 545,186 49,907 100% 92%
9,854,864 8,882,472 972,392 100% 90%
280,851 272,025 8,826 100% 97%
179,441 169,801 9,640 100% 95%
1,049,272 932,569 116,703 100% 89%
2,892,242 2,660,758 231,484 100% 92%
201,300 159,787 41,513 100% 79%
611,917 594,044 17,873 100% 97%
41,592 141,792 (100,200) 100% 341%
100,000 100,000 - 100% 100%
100,000 100,000 - 100% 100%
100,000 100,000 100% 0%
3,089,559 3,089,559 100% 0%
TOTAL REQUIRMENTS 22,829,457 18,139,140 4,690,316 79%
Net
Beginning NWC per Adopted Budget 5,108,671
6,014,522 6,014,522
a) Timing of reimbursements for the Emergency Planning Grant
b) Funding reduction from Dept of Corrections
c) Higher than planned inmate telephone use and commissary purchases
d) Work Crew revenue from USFS was not planned
e) Unplanned revenue for the "Children of Incarcerated Parents" program
f) Revenue for concealed weapons permits and civil papers will exceed budget
Fund 702 LED Rural
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
RESOURCES:
Beg. Net Working Capital $ 1,905,939 $ 2,498,487 $ 592,548 100% 131%
Revenues
Tax Revenues - Current 7,508,247 7,555,396 47,149 100% 101%
Tax Revenues - Prior 314,000 394,765 80,765 100% 126%
Federal Grants 2,000 13,326 11,326 100% 666%
Federal Grants-BLM- 9,597 9,597 100% Na
US Forest Service 76,500 64,125 (12,375) 100% 84%
State Grant 187,633 89,238 (98,395) 100% 48%
SB #1065 Court Assessmt 67,000 53,697 (13,303) 100% 80%
Marine Board License Fee 142,433 49,842 (92,591) 100% 35%
Des Cty General Fund Grz 702,358 514,358 (188,000) 100% 73%
Des Cty Transient Room 1 1,947,642 2,135,642 188,000 100% 110%
City of Sisters 432,655 432,655 - 100% 100%
Des Cty Tax/Fin Contract 1,000 - (1,000) 100% 0%
Des Cty CDD Contract 54,366 54,366 - 100% 100%
Des Cty Solid Waste Cont 54,366 54,366 - 100% 100%
Des Cty Clerk/Election 2,000 1,249 (751) 100% 62%
School Districts 100,000 41,549 (58,451) 100°% 42%
Claims Reimbursement 8,472 8,472 100% Na
Security & Traffic Reimb 13,000 5,961 (7,039) t00% 46%
Seat Belt Program 6,000 7,025 1,025 100% 117%
Miscellaneous 10,000 9,671 (329) 100% 97%
Restitution 500 1,058 558 100% 212%
Sheriff Fees 10,000 10,048 48 100% 100%
Court Fines & Fees 85,000 131,817 46,817 100% 155%
Impound Fees 15,000 6,000 (9,000) 100% 40%
Restitution - Street Crimes 500 (500) 100% 0%
Interest 10,000 20,201 10,201 100% 202%
Interest on Unsegregated 1,800 924 (876) 100% 51%
Donations 12,250 12,250 100% Na
Sale of Reportable Assets 10,000 32,762 22,762 100% 328%
Sale of Equip & Material 6,000 3,570 (2,430) 100% 60%
Total Revenues 11,760,000 11,713,932 (46,068) 50% 100%
TOTAL RESOURCES 13,665,939 14,212,419 546,480 50% 104%
REQUIREMENTS:
Department
Sheriffs Services
Auto/Comm
Investigations
Patrol
Records
Special Services
Training
Internal Services
Transfer for Reserve Fund
Contingency
Exp. %
166,161 159,834 6,326 100% 96%
1,057,943 969,219 88,724 100% 92%
1,650,792 1,482,795 167,997 100% 90%
8,015,651 7,729,134 286,517 100% 96%
660,386 622,378 38,008 100% 94%
249,332 221,601 27,731 100% 89%
128,700 102,159 26,541 100% 79%
41,426 141,226 - 100°4 341%
100,000 100,000 100% 0%
1,595,548 1,595,548 100% 0%
1 i 7AL Edi fFipeNTS r 13:665;93 "' 7"1;428;345 37,594 - 84%
Net
2,784,074 2,784,074
Beginning NWC per Adopted Budget 2,936,523
a) Detective overtime reimbursements from HIDTA
b) Contract increased for purchase of new boat. Payments will be received in Qtr 4
c) Grant will be received in June 2011
d) Less than planned revenue due to lower billing rates and hours worked
e) Revenue tram traffic tines will exceed budget
f) Animal Rescue Facility donations
g) Proceeds from sale of used patrol vehicles were higher than estimated
PUBLIC HEALTH
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
RESOURCES:
Beg. Net Working Capital
Revenues
Medicare Reimbursement
State Grant
Child Dev & Rehab Center
State Miscellaneous
OMAP
Title 19
Family Planning Exp Proj
Local Grants
Water Program -Base Fee
Water Program -Field Work
H2O Sys Insp-Priv Wells
Miscellaneous
Patient Insurance Fees
Health Dept/Patient Fees
Vital Records -Birth
Vital Records -Death
Environmental Health
Interest on Investments
Donations
lnterfund Contract
Administrative Fee
Drug Court Byrne
Total Revenues
Transfers In -General Fund
Transfers In -PH Res Fund
Transfers In -Gen. Fund Other
TOTAL RESOURCES
Budget
Actual
Variance
FY
Coll.
$ 1,100,000 $ 1,615,306 $ 515,306 100% 147%
8,000 147
2,512,977 2,427,905
30,759 30,759
219,896 250,248
477,800 628,876
927
495,000 467,649
65,000 115,839
42,000 37,544
55,817 49,840
200
386
190,260 131,128
148,975 111,975
36,000 33,425
98,000 104,725
687,350 738,893
16,900 11,213
6,000 32,582
189,378 72,661
27,000 27,000
4,157
5,307,312
2,317,765
67,123
67,812
5,277,878
2,317,765
67,123
67,812
(7,853) 100% 2%
(85,072) 100% 97% a)
(0) 100% 100%
30,352 100% 114%
151,076 100% 132%
927 100% n/a
(27,351) 100% 94%
50,839 100% 178% b)
(4,456) 100% 89%
(5,977) 100% 89%
(200) 100% 0%
386 100% n/a
(59,132) 100% 69% c)
(37,000) 100% 75% c)
(2,575) 100% 93%
6,725 100% 107%
51,543 100% 107%
(5,687) 100% 66%
26,582 100% 543% d)
(116,717) 100% 38%
100% 100%
4,157 100% nla
(29,434) 100% 99%
- 100% 100%
- 100% 100%
- 100% 100%
8,860,012 9,345,885
REQUIREMENTS:
Expenditures
Personal Services 5,857,162
Materials and Services 2,037,387
Capital Outlay 25,000
Transfers Out 150,000
Contingency 790,463
TOTAL REQUIREMENTS
NET (Resources - Requirements)
5,778,024
2,064,780
5,432
150,000
485,873 100% 105%
Exp.
79,138 100% 99%
(27,393) 100% 103%
19,568 100% 22%
- 100% 100%
790,463 100% n/a
8,860,012 7,998,237
861,775 100% 90%
1,347,647
1,347,647
Beginning NWC per Adopted Budget
1,596,918
RESOURCES:
Beg. Net Working Capital
Revenues
Marriage Licenses
Divorce Filing Fees
Domestic Partnership Fee
Federal Grants
State Grants
State Miscellaneous
ABHA
Title 19
Liquor Revenue
School Districts
Miscellaneous
Patient Insurance Fees
Patient Fees
Seizure/Forfeiture
Interest on Investments
Rentals
Interfund Contract -Gen.
Comm. on Children & Fam
Administrative Fee
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
$ 2,616,050 $ 2,651,262
5,500
130,000
1,000
96,969
6,567,212
148,173
300,925
105,400
70,000
16,900
154,000
13,000
43,585
13,100
Fund 127,000
24,000
4,211,457
12,028,221
1,316,158
100,000
365,657
668,252
Total Revenues
Transfers In -General Fund
Transfers In-OHP-CDO
Transfers In -Acute Care Svcs
Transfers In-ABHA
TOTAL RESOURCES
5,245
143,501
45
232,483
6,491, 699
113,787
99,685
206,789
114,531
81,540
37,254
85,392
2,252
14,841
22,703
16,500
118,217
4,207,255
11,993,717
$ 35,212 100% 101%
(255)
13,501
(955)
135,514
(75, 513)
(34,386)
99,685
(94,136)
9,131
11,540
20,354
(68,608)
(10,748)
14,841
(20,882)
3,400
(8,783)
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
(24,000) 100%
(4,202) 100%
1,316,158
100,000
365,657
668,252
95%
110%
5%
240% a)
99% b)
77%
nla
69%
109%
116%
220%
55%
17%
n!a
52%
126%
93% a)
0% c)
100%
(34,505) 100% 100%
17,094,338 17, 095, 046
REQUIREMENTS:
Expenditures
Personal Services 9,337,153
Materials and Services 5,276,251
Capital Outlay 766,000
Transfers Out 157,164
Contingency 1,557,770
8,974,295
4,699,487
215,540
150,000
100%
100%
100%
100%
708 100%
362,858
576,764
550,460
7,164
1,557,770
TOTAL REQUIREMENTS 17,094,338
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
Exp. %
96% d)
89%
28%
95%
n/a
14,039,321 3,055,017 100% 82%
NET (Resources - Requirements) 3,055,724
3,055,724
Beginning NWC per Adopted Budget 3,268,759
a) Received quarterly, in arrears
b) Department of Human Services Grant projected at amended contract amount for FY 11
c) Child and Family prevention program eliminated
d) Personnel expenditure projected to be less than budgeted due to unfilled positions
Year to Date
Budget
Actual Variance
FY % Coil.
$ 2,616,050 $ 2,651,262
5,500
130,000
1,000
96,969
6,567,212
148,173
300,925
105,400
70,000
16,900
154,000
13,000
43,585
13,100
Fund 127,000
24,000
4,211,457
12,028,221
1,316,158
100,000
365,657
668,252
Total Revenues
Transfers In -General Fund
Transfers In-OHP-CDO
Transfers In -Acute Care Svcs
Transfers In-ABHA
TOTAL RESOURCES
5,245
143,501
45
232,483
6,491, 699
113,787
99,685
206,789
114,531
81,540
37,254
85,392
2,252
14,841
22,703
16,500
118,217
4,207,255
11,993,717
$ 35,212 100% 101%
(255)
13,501
(955)
135,514
(75, 513)
(34,386)
99,685
(94,136)
9,131
11,540
20,354
(68,608)
(10,748)
14,841
(20,882)
3,400
(8,783)
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
(24,000) 100%
(4,202) 100%
1,316,158
100,000
365,657
668,252
95%
110%
5%
240% a)
99% b)
77%
nla
69%
109%
116%
220%
55%
17%
n!a
52%
126%
93% a)
0% c)
100%
(34,505) 100% 100%
17,094,338 17, 095, 046
REQUIREMENTS:
Expenditures
Personal Services 9,337,153
Materials and Services 5,276,251
Capital Outlay 766,000
Transfers Out 157,164
Contingency 1,557,770
8,974,295
4,699,487
215,540
150,000
100%
100%
100%
100%
708 100%
362,858
576,764
550,460
7,164
1,557,770
TOTAL REQUIREMENTS 17,094,338
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
Exp. %
96% d)
89%
28%
95%
n/a
14,039,321 3,055,017 100% 82%
NET (Resources - Requirements) 3,055,724
3,055,724
Beginning NWC per Adopted Budget 3,268,759
a) Received quarterly, in arrears
b) Department of Human Services Grant projected at amended contract amount for FY 11
c) Child and Family prevention program eliminated
d) Personnel expenditure projected to be less than budgeted due to unfilled positions
RESOURCES:
Beg. Net Working Capital
Revenues
Admin -Operations
Admin-G1S
Admin -Code Enforcement
Building Safety
Electrical
Contract Services
Env Health -On Site Prog
Planning -Current
Planning -Long Range
Total Revenues
Trans In -GF
Trans 1n -GF for Lng Rng Ping
TOTAL RESOURCES
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY%
Coll.
$ 686,081
16,500
2,750
161,718
1,081,217
266,652
184,000
283,830
776,962
353,771
613,031 $ (73,050) 100% 89%
17,442
4,384
170,597
984,748
253,420
147,811
274,473
709,269
343,501
942
1,634
8,879
(96,469)
(13,232)
(36,189)
(9,357)
(67,693)
(10,270)
3,127,400
100%
100%
100%
100%
100%
100%
100%
100%
100%
106%
159% a)
105%
91% b)
95%
80% c)
97%
91% d)
97% e)
2,905,645 (221,755) 100% 93%
253,387 253,387
516,000 516,000
- 100% 100%
- 100% 100%
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin -Operations
Admin -GIS
Admin -Code Enforcement
Building Safety
Electrical
Contract Services
Env Health -On Site Pgm
Planning -Current
Planning -Long Range
Transfers Out (D/S Fund)
Contingency
4,582,868 4,288,063
1,402, 396
216,135
184,732
500,330
187,606
244,251
232,006
690,290
492,427
173,310
259,385
1,381,821
171,230
185,538
492,560
180,632
223,681
211,617
637,696
497,630
173,310
(294,805) 100% 94%
20,575
44,905
(806)
7,770
6,974
20,570
20,389
52,594
(5,203)
259,385
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
Exp. %
99%
79% f)
100%
98%
96%
92%
91%
92%
101%
100%
n/a
TOTAL REQUIREMENTS 4,582,868 4,155,715 427,153 100% 91%
NET (Resources -Requirements) 132,348 132,348
Beginning NWC per Adopted Budget 229,822
Revenues
Expenditures
Net from Operations
2,905,645
4,155,715
(1,250,070)
9)
9)
h)
1)
j)
a) Custom GIS work revenue sporadic. Includes webmaster work for Health Dept
b) Projections reduced, as at least one major project (La Pine Biomass plant) has been delayed,
but is expected to occur in FY 2012.
c) City of Redmond receipts lag one month behind
d) YTD business volume/revenue projected to be less than estimated
e) Grant payments received irregularly
f) Savings due to resignation of CDD webmaster, who will not be replaced
g) Savings due to retirement of Building Inspector in January, who will not be replaced
h) Savings due to retirement of EH Director, who will be replaced by an EH Specialist III
i) Savings due to lower expenses associated with Hearings Officer, mailings, etc.
j) Consultant expenditure higher than budgeted associated with timing of grant revenue received in FY 2010
ROAD
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance FY % CO.
RESOURCES:
Beg. Net Working Capital $ 3,430,429 $ 3,419,603 $ (10,826) 10O% 100%
Revenues
Mineral Lease Royalties 20,000 153,454 133,454 100% 767%
Forest Receipts 2,237,000 2,237,091 91 100% 100% a)
State Miscellaneous 96,984 - (96,984) 100% 0% b)
Motor Vehicle Revenue 10,000,000 9,043,509 (956,491) 100% 90% c)
City of Bend 275,000 322,324 47,324 100% 117% d)
City of Redmond 350,000 250,458 (99,542) 100% 72% d)
City of Sisters 10,000 - (10,000) 100% 0% d)
City of La Pine 10,000 - (10,000) 100% 0% d)
Admin Recovery (SDC) - 2,810 2,810 100% n/a
Miscellaneous 90,000 31,695 (58,305) 100% 35%
Road Vacations 1,000 1,000 100% 100%
Interest on Investments 40,000 22,699 (17,301) 100% 57%
Other Bank/LGIP Interest - 61 61 100% n/a
Parking Fees 900 - (900) 100% 0%
Grants -Private - 2,434 2,434 100% nla
Interfund Contract 750,000 (750,000) 100% 0% e)
Equipment Repairs 250,000 235,980 (14,020) 100% 94%
Vehicle Repairs 90,000 72,180 (17,820) 100% 80%
LID Construction 10,000 (10,000) 100% 0% e)
Vegetation Management 35,000 - (35,000) 100% 0% e)
Forester 25,000 (25,000) 100% 0% e)
Car Washes 3,000 4,496 1,496 100% 150%
Car Rental 500 948 448 100% 190%
Sale of Equip, Mat & Svcs 202,500 216,215 13,715 100% 107%
Interfund Fuel, etc. 401,000 549,736 148,736 100% 137%
Total Revenues 14,897,884 13,147,089 (1,750,795) 100% 88%
Trans In - Solid Waste 291,740 291,740 - 100% 100%
Trans In - Transp SDC 200,000 200,000 - 100% 100%
Trans In -Road Imp Res 12,040 - (12,040) 100% 0%
TOTAL RESOURCES 18,832,093 17,058,432 (1,773,661) 100% 100%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
Exp.
5,752,967 5,571,742 181,225 100% 97%
9,471,023 8,498,939 972,084 100% 90%
1,171,691 91,180 1,080,511 100% 8% 1)
400,000 400,000 100% 100%
2,036,412 - 2,036,412 100% n/a
TOTAL REQUIREMENTS 18,832,093 14,561,860 4,270,233 100% 77%
NET (Resources - Requirements) 2,496,572 2,496,572
Beginning NWC per Adopted Budget 2,834,720
a) Annual payment -January 2011
b) Received in June 2010
c) Even though gas taxes increased by 25% ($.06/gal.) effective January 2011 (revised State estimate);
gas tax receipts will be less than estimated
d) Billed upon completion of work
e) Payment to be received in June 2011 from Funds 326, 328, 329, & 340
f) Budget includes $1,076.691 for 19th Street construction. Will be expended in future years
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
RESOURCES:
Beg. Net Working Capital
Revenues
DOC Measure 57
State Miscellaneous
Alternate Incarceration
State Subsidy
SB 1145
Probation Work Crew Fees
Miscellaneous
Electronic Monitoring Fee
Probation Superv. Fees
Interest on Investments
lnterfund - Sheriff
Crime Prevention Grant
CFC -Domestic Violence
Total Revenues
Transfers In -General Fund
Budget
Actual
Variance
FY %
CoII. %
$ 616,371 $ 728,649 $ 112,278 100% 118%
217,305 217,350
4,301 4,301
30,918 30,918
13,000 13,306
2,961,990 2,781,694
38,000 24,792
3,000 4,321
170,000 158,186
210,000 203,591
9,000 8,314
50,000 50,000
50,000 37,500
37,416
45 100% 100%
100% 100%
100% 100%
306 100% 102%
(180, 296) 100% 94%
(13,209) 100% 65% a)
1,321 100% 144% b)
(11,814) 100% 93%
(6,409) 100%
(686) 100% 92%
- 100% 100%
97%
(12,500) 100%
37,416 100%
75% c)
n/a d)
3,757,514 3,571,689 (185,825) 100% 95%
115,029 115,029
- 100% 100%
TOTAL RESOURCES 4,488,914 4,415,367
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
3,173,257 2,973,970
894,274 834,424
100
421,283
(73,547) 100% 98%
Exp. %
199,287 100% 94% e)
59,850 100% 93% f)
100 100% 0%
421,283 100% n/a
TOTAL REQUIREMENTS 4,488,914 3,808,393 680,521 100%
NET (Resources - Requirements) 606,974 606,974
Beginning NWC per Adopted Budget 560,000
a) Increase in fee waivers from court due to economic conditions
b) Larger number of offenders doing out of state and county transfers
c) Payments received quarterly (Sept, Dec, Mar and June)
d) Intensive Supervision DV grant (Federal grant)
e) Personnel expenditure projected to be less than budgeted due to unfilled positions
f) M57 treatment funds have been used Less based on current population
85%
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget _
Actual
Variance
F`70,/c71 Coll. %
RESOURCES:
Beg. Net Working Capital $ 562,762 $ 635,340 $ 72,578 100% 113%
Revenues
Federal Grants 400,167 355,788 (44,379) 100% 89% a)
Title IV - Family Sup/Pres 63,750 61,870 (1,880) 100% 97%
HealthyStart Medicaid 95,000 71,972 (23,028) 100% 76%
Level 7 Services 257,984 239,237 (18,747) 100% 93%
State Prevention Funds 14,500 7,532 (6,968) 100% 52% b)
HealthyStart /R -S -G 308,924 263,596 (45,328) 100% 85% c)
OCCF Grant 604,323 542,003 (62,320) 100% 90% c)
Charges for Svcs-Misc 8,000 3,597 (4,403) 100% 45% d)
Court Fines & Fees 75,000 86,101 11,101 100% 115% e)
Interest on Investments 20,0005,044 (14,956) 100% 25% f)
Grants Private 5,000 (5,000) 100% 0% g)
Donations 4,357 4,357 100% n/a d)
Video Lottery 2,500 2,500 100% n/a d)
Miscellaneous 258,554 124,850 (133,704) 100% 48% h)
Total Revenues 2,111,202 1,768,447 (342,755) 100% 84%
Trans from General Fund 284,333 284,333
Trans from GF -Other 25,000 25,000
- 100% 100%
- 100% 100%
Total Transfers In 309,333 309,333
- 100% 100%
TOTAL RESOURCES 2,983,297 2,713,120 (270,177) 100% 91%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
599,559 544,038 55,521 100% 91% 1)
1,975,084 1,469,934 505,150 100% 74% c)
100 100 100% 0%
408,554 408,554 100% n/a
TOTAL REQUIREMENTS 2,983,297 2,013,972 969,325 100% 68%
NET (Resources - Requirements) 699,148 699,148
Beginning NWC per Adopted Budget 467,111
a) Federal grants adjusted to projected actual
b) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $9,924 grant received
c) Governor's mandated State General Fund reductions in July & Sept 2010. Additional $19,900 grant received
d) Community donations received for "Week of the Young Child" & building partner reimbursements adjusted to actual
e) Mary's Place court fines greater than projected
f) Interest revenue projected to be Less than budgeted
g) Youth conference donations will not be received
h) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received
i) Personnel costs will be less than budgeted due to open positions -increased due to .50 FTE working additional hours
SOLID WASTE
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
RESOURCES:
Beg. Net Working Capital $ 392,509
Revenues
Miscellaneous
Refunds/Reimbursements
Franchise 3% Fees
Commercial Disp. Fees
Private Disposal Fees
Franchise Disposal Fees
Yard Debris
Special Waste
Interest
Leases
Sale of Carbon Credits
Donations
Sale of Equip & Material
Recyclables
Total Revenues
TOTAL RESOURCES
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out -Road
Contingency
Actual
$ 318,001
Variance
FY %
Coll. %
$ (74,508) 100% 81%
28,000 22,269 (5,731) 100% 80%
- 15 15 100% n/a
200,000 209,430 9,430 100% 105%
840,000 859,359 19,359 100% 102%
1,314,000 1,321,254 7,254 100% 101%
3,659,000 3,891,476 232,476 100% 106%
73,000 85,014 12,014 100% 116%
25,000 41,919 16,919 100% 168% a)
12,500 8,668 (3,832) 100% 69%
1 1 100% n/a
80,000 (80,000) 100% 0% b)
- 3,240 3,240 100%
100 100 100%
20,000 51,992 31,992 100%
6,251,500 6,494,736 243,236 100%
6,644,009 6,812,737 168,728 100%
1,634,618 1,626,788 7,830 100%
2,865,829 2,606,625 259,204 100%
970,066 970,066 0 100%
148,000 127,332 20,668 100%
291,740 291,740 - 100% 100%
733,756 733,756 100% n/a
n/a
n/a c)
260% d)
104%
103%
Exp. %
100%
91% e)
100%
86% f)
TOTAL REQUIREMENTS 6,644,009 5,622,551 1,021,458 100% 85%
NET (Resources - Requirements) 1,190,186 1,190,186
Beginning NWC per Adopted Budget 1,092,508
a) Bonneville Power did Targe clean-up of contaminated soil -unexpected revenue
b) No market at this time. Not expected to market this fiscal year
c) Minor revenue for sale of gate remotes
d) Markets for recyclables varies throughout the year - usually declines during Winter
e) Larger expenditures (i.e. grinding at $75,000) will be made in Spring
f) Software purchase in process; also, $30,000 from contingency needed for
safety covers for Knott Transfer Trailer Bays
RISK MANAGEMENT
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
RESOURCES:
Beginning Net Working Capital
Revenues
Inter -fund Charges:
Budget
Actual
Variance
% of FY
Coll.
$2,500,000 $2,374,541 ($125,460) 100% 95%
General Liability 335,833 335,833 100% 100%
Property Damage 294,019 294,019 - 100% 100%
Vehicle 182,710 182,710 - 100% 100%
Workers' Compensation 906,361 905,974 (387) 100% 100%
Unemployment 170,437 172,348 1,911 100% 101%
Claims Reimb-Workers' Compensation 30,000 (30,000) 100% 0%
Claims Reimb-Gen Liab/Property 20,000 28,481 8,481 100% 142%
Process Fee-Events/Parades 1,500 2,115 615 100% 141%
Miscellaneous 2,000 (2,000) 100% 0%
Skid Car Training 22,000 15,818 (6,182) 100% 72%
Interest on Investments 30,000 15,685 (14,315) 100% 52%
TOTAL REVENUES 1,994,860 1,952,983 (41,877) 100% 98%
TOTAL RESOURCES 4,494,860 4,327,523 (167,337) 100% 96%
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
Exp.
62,818
104,314
7,935
155,221
726
250
400,000 331,264 68,736 100% 83%
Insurance 150,075
Repair / Replacement 14,790
Total Property Damage 300,000 164,865 135,135 100% 55%
VEHICLE
Professional Service 1,964
Insurance 390
Loss Prevention 15,244
Repair / Replacement 81,860
Total Vehicle 120,000 99,457 20,543 100% 83%
WORKERS' COMPENSATION
Settlement / Benefit 632,866
Professional Service 6,250
Insurance 112,172
Loss Prevention 57,803
Miscellaneous 44,275
Total Workers' Compensation 650,000 853,366 (203,366) 100% 131%
UNEMPLOYMENT - Settlement/Benefits 350,000 267,377 82,623 100% 76%
Total Direct Insurance Costs 1,820,000 1,716,329 103,671 100% 94%
Insurance Administration:
Personal Services 291,953 291,027 926 100% 100%
Materials & Service 228,834 186,635 42,199 100% 82%
Capital Outlay 100 100 100% 0%
Total Insurance Administration 520,887 477,663 43,224 100% 92%
Contingency 2,153,973 2,153,973 100% n/a
TOTAL REQUIREMENTS 4,494,860 2,193,992 2,300,868 100% 49%
NET 2,133, 531 2,133,531
Beginning NWC per Adopted Budget 2,100,000
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
RESOURCES:
Beg. Net Working Capital
Revenues
Property Taxes - Current
Property Taxes - Prior
Federal Grants
State Reimbursement
Telephone User Tax
Data Network Reimb.
Jefferson County
User Fee
COPS Reimbursements
Contract Payments
Miscellaneous
Interest
Interest on Unsegregated Tax
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
Budget
Actual
Variance
of FY
Coll.
$ 5,861,335 $
6,357,621
138,000
474,000
10,000
550,000
12,000
31,000
50,000
30,000
70,000
8,500
40,000
2,000
6,691,945 $ 830,610 100% 114%
6,272,640 (84,981) 100% 99%
293,583 155,583 100% 213%
265,193 (208,807) 100% 56% a)
22,193 12,193 100% 222% b)
642,765 92,765 100% 117% c)
26,672 14,672 100% 222% d)
41,292 10,292 100% 133%
52,338 2,338 100% 105% e)
(30,000) 100% 0% f)
32,134 (37,866) 100% 46% g)
14,070 5,570 100% 166%
49,558 9,558 100% 124%
768 (1,232) 100% 38%
7,773,121
7,713,206 (59,915) 100% 99%
13, 634,456 14,405,151
4,008,798
1,524,144
1,763,000
1,014,061
5,324,453
3,589,464
1,448,224
1,146, 628
942,836
770,695 100% 106%
Exp.
419,334 100% 90%
75,920 100% 95%
616,372 100% 65%
71,225 100% 93%
5,324,453 100% n/a
TOTAL REQUIREMENTS 13,634,456 7,127,151 6,507,305 100% 52%
NET (Resources - Requirements) 7,278,000 7,278,000
Beginning NWC per Adopted Budget 6,400,000
a) CAD -to -CAD budgeted $314,000 of which $265,193 has been received. Expect to receive $39,485
more by June 30 ODOT project budgeted $160,000 which will not occur this fiscal year
b) GIS/Mapping revenue underbudgeted
c) Received quarterly (Nov, Feb, May and Aug) for fiscal year
d) Annual billings to agencies underbudgeted. All payments have been received
e) Crooked River Ranch paid annual fee of $45,869
f) Revenue not expected this fiscal year
g) All payments have been received
Health Benefits Trust
Statement of Financial Operating Data
Twelve Months Ended June 30, 2011
PRELIMINARY (July 20, 2011)
Year to Date
RESOURCES
Beg. Net Working Capital
Revenues:
Internal Premium Charges
PIT Emp - Add'l Prem
Employee Prem Contribution
COIL
Retiree / COBRA Co -Pay
Federal Payments
Prescription Rebates
Interest
Total Revenues
TOTAL RESOURCES
REQUIREMENTS
Expenditures:
Personal Services
Materials & Services
Claims Paid-Medical/Rx
Claims Paid-DentalNision
Refunds
Insurance Expense
State Assessments
Administration Fee
PPO Fee
Health Impact
Deschutes Onsite Clinic:
Healthstat
Equipment
Remodel
Miscellaneous
Other
Total Materials & Services
Capital Outlay
Contingency
Budget
Actual
Variance
FY %
Coll. %
$ 16,400,000 $ 16,988,140 $ 588,140 100% 104%
11,246,000
50,000
500,000
975,000
450,000
100,000
11,407,042
45,695
488,710
1,418,895
732,526
93,496
94,970
109,027
161,042 100%
(4,305) 100%
(11,290) 100%
443,895 100%
282,526 100%
93,496 100%
94,970 100%
9,027 100%
13,321,000 14,390,360
29,721,000 31,378,500
129,280
1,069,360 100%
101%
91%
98%
146%
163%
n/a
n/a
109%
108%
1,657,500 92% 106%
Exp. %
127,664 1,616 100% 99%
12,450,194 12,306,832.23
1,871,377 1,785,072.26
(88,567)
330,000 335,724
75,000 124,832
300,000 302,510
40,000 43,738
51,000 51,472
229,520 220,633
14,500 32,368
121,600 123,907
61,900 53,195
151,141 51,982
143,362 100%
86,305 100%
88,567 100%
(5,724) 100%
(49,832) 100%
(2,510) 100%
(3,738) 100%
(472) 10o%
8,887 100%
(17,868) 100%
(2,307) 100%
8,705 100%
99,159 100%
15,696, 232
100
13,895,388
15,343,699
352,533 100%
100 100%
13,895,388 100%
TOTAL REQUIREMENTS 29,721,000
NET (Resources - Requirements)
Beginning NWC per Adopted Budget
a) Actual is an average of 5269,294 per week.
15,471,363
99% a)
95% a)
n/a
102%
166%
101%
109%
101%
96%
223%
102%
86%
34%
98%
0%
0%
14,249,638 100% 52%
15,907,138
15,907,138
Revised
Budget
Year End
Projection
Variance
$ 16,400,000 $ 16,988,140 588,140
11,246,000
50,000
500,000
975,000
450,000
100,000
11,407,042
45,695
488,710
1,418,895
732,526
93,496
94,970
109,027
161,042
(4,305)
(11,290)
443,895
282,526
93,496
94,970
9,027
13,321,000 14,390,360 1,069,360
29,721,000 31,378,500 1,657,500
129,280
12,450,194
1,871,377
330,000
75,000
300,000
40,000
51,000
229,520
14,500
121,600
61,900
151,141
127,664
12,306,832
1,785,072
(88,567)
335,724
124,832
302,510
43,738
51,472
220,633
32,368
123,907
53,195
51,982
1,616
143,362
86,305
88,567
(5,724)
(49,832)
(2,510)
(3,738)
(472)
8,887
(17, 868)
(2,307)
8,705
99,159
15,696, 232
100
13,895,388
29,721,000
15,343,699
352,533
100
13,895,388
15,471, 363 14,249, 638
15,907,138 15,907,138
15,500,000
Deschutes County - Fair and Expo Center
YTD -Budget Basis Commissioners
Statement of Financial Operating Data
Year Ended June 30, 2011
PRELIMINARY (July 20, 2011)
Budget
Actual
Variance
FY%
_Coll. %
RESOURCES:
Beg. Net Working Capital $ 2,809 $ 6,590
Receipts:
Special Events Revenues
Interest
Storage
Camping at F & E
Horse Stall Rental
Concession % - Food
Rights (Signage, etc.)
Interfund Contract
Miscellaneous
677,742
2,000
51,000
9,000
42,000
211,000
93,000
45,000
4,414
589,683
746
45,992
1,391
31,855
170,164
117,738
45,000
28,059
$ 3,781 100%
Total Receipts 1,135,156
Transfers In
General Fund (001) 197,919
Room Tax (160) 24,873
Welcome Center (170) 80,000
Annual County Fair (619) 231,232
Reserve Fund (617) 100
1,030,628
197,919
24,873
80,000
166,000
235%
(88,059) 100% 87%
(1,254) 100% 37%
(5,009) 100% 90%
(7,609) 100% 15%
(10,145) 100% 76%
(40,836) 100% 81%
24,738 100% 127%
- 100% 100%
23,645 100% n/a
(104,529) 100% 91%
(65,232)
(100)
Total Transfers In 534,124
TOTAL RESOURCES 1,672,089
REQUIREMENTS:
Expenditures:
Personal Services 931,893
Materials and Services 576,685
Debt Service 115,563
Capital Outlay 100
Total Expenditures 1,624,241
Transfers Out - Reserve Fund 10,000
Contingency 37,848
TOTAL REQUIREMENTS
NET (Resources - Requirements)
468,792
1,506,010
862,123
578,626
115,561
(65,332)
100%
100%
100%
100%
100%
100%
100%
100%
72%
0%
(166,079) 100% 90%
69,770 100%
(1,941) 100%
2 100%
100 100%
1,556,310
Exp.
93%
100%
100%
0%
67,931
10,000 100% 0%
37,848 100% n/a
1,672,089 1,556,310
115,779 100% 93%
(50,300) (50,300)
Beginning NWC per Adopted Budget 75,000
RESOURCES:
Beg. Net Working Capital
Revenues
Grants - Private
Lease Payments
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service:
Interest Expense
Interest Payment
Deschutes County
Bethlehem Inn (Fund 128)
Year Ended June 30, 2011
Budget
Actual
Variance
FY%
Coll.
$ (2,725,000) $
2,861,000
(2,722,510) $ 2,490 100% 100%
- (2,861,000) 100% 0%
24,408 24,408 100% NIA
2,861,000
136,000
24,408 (2,861,000) 100% 1%
(2,698,102) (2,858,510) 100% -1984%
Exp. %
36,000 18,479 17,521 100% 51% a)
100,000 - 100,000 100% 0%
TOTAL REQUIREMENTS 136,000
NET (Resources - Requirements)
18,479 117,521 100% 14%
(2,716,581) (2,740,989) b)
a) Interest on .June 2011 negative cash balance: $1,297.42
b) Inception through June 30, 2011
Revenues - Lease Payments
Expenditures:
Land/Building (Amertitle) - July 2007
Hickman Williams
City of Bend - May 2008
KN EX CO
Kleinfelder
Total expended on facility
Interest on Negative Cash Balance
Total expended
Net
$ 24,408
2,241,313
17,578
250,000
5,289
3,732
2,517,913
223,076
2,740,989
$ (2,716,581)
Deschutes County - Solid Waste
Area A Closure and Cell 5 Construction
As of June 30, 2011
PRELIMINARY (July 20, 2011)
Engineering Contract
G. Friesen Associates, Inc.
Original Contract
Change Orders:
Change Order #1 (Note a) DEQ requirement for gas detection
Change Order #2 LFG well field management SOPs
Change Order #3 Storm sewer realignment, drainage, Area A thickness
Total Contract
Amount Paid
Through June 30, 2010
July 1, 2010 through June 30, 2011 (Final payment made December 2010)
Balance Due
Construction Contract
M A DeAtley Construction Inc
Original Contract - @ estimated cu.yd.
Amended Contract - @ revised cu.yd. and damages
Change Orders:
Change Order #1 Meet CEC requirements, increase to electrical panel,
Change Order #2 Storm sewer realignment due to refuse encountered
Change Order #3 Revise valve vaults for improved efficiencies
Change Order #4 Add'I cover material from what will be Cell 6
Change Order #5 Environmental controls building, pump station bulkheads
Change Order #6 Adjustment to pipe alignment to increase slope
Change Order #7 (not likely to occur)
Change Order #8 Additional rock to be set aside for future needs
Change Order #9 Manhole covers below grade to meet Road Dept requirements
Change Order #10 Modular Block Wall instead of MSE Wall
Change Order #11 Upgrade of cables (pump and leachate)
Change Order #12 Leachate Line connection from Cell 5 to Cells 3 & 4
Change Order #13 Additional cover material due to settling
Change Order #14 Well modification, flow meter less LFG vaults
Damages
Total Contract
Amount Paid
Through June 30, 2010
July 1, 2010 through June 30, 2011
Balance Due
Total of Engineering and Construction Contracts:
Original Contracts
Change Orders and Damages
Total Contract
Amount Paid
Through June 30, 2010
July 1, 2010 through June 30, 2011
Balance Due
"Area A"
"Cell 5"
Landfill Closure
Fund 611
SW Capital
Projects Fund
613
Total
241,869.00 182,516.00 424,385.00
19,656.00
21,500.00
34, 316.00
33,431.00
19,656.00
21,500.00
67, 747.00
317,341.00 215,947.00 533,288.00
254,413 44
62,927.56
153,904.42
62,042.58
408,317.86
124, 970.14
2,097,140.50 3,290,779.98 5,387,920.48
2,284,885.13 3,552,521.82 5,837,406.94
14,302.54
24,885.69
32,690.70
1,332.00
2,486.98
55,853.20
5,938.50
45,095.00
148,958.89
204,700.00
5,167.76
2,200.00
6,354.75
(35,000.00)
45,095.00
14,302.54
24,885.69
32,690.70
148,958.89
1,332.00
204,700.00
2,486.98
5,167.76
2,200.00
6,354.75
55,853.20
5,938.50
(35,000.00)
2,422,374.74 3,929,998.22 6,352,372.95
1,707,132.00 2,054,537.51 3,761,669.51
373,720.63 1,743,978.95 2,117,699.58
341,522.11 131,481.76 473,003.86
2,526,754.13 3,735,037.82 6,261,791.94
212,961.61 410,907.40 623,869.01
2,739,715.74 4,145,945.22 6,885,660.95
1,961,545.44 2,208 441.93 4.1E:q.`I87.37
-3&,640 I r9 1 806.02:.53 2,242,669 72
3-.1, 522 11 131',481 T 5 473.003.86
Note: There will not likely be additional payments to M A DeAtley until Spring. The additional services are for landscaping and other weather sensitive
activities.
(p LLJ
a 1-7
C c
a C_
0
0
U)
0
c
C
a
C
O
U
W
U 1r
U 0-
0 O
m
Jun I YTD Total
0
fIS
`i
(4
a
0
0
Z
O
O.
0)
0)
}
17)
10
V
H
08
142
•
O
0
0
0
0
m
(0(n n n Chin
(') 0) CD (0
o(04 -nm
M Cr
O
O
O 0 f`) — n 0
r 0) m r N ('1
' N 47 CO r r 0.-
4-
�r CV.
(0 40 r 41.'
CO N I+ O
' (r)
O 47 ( - 0 I (D
c0 (O (0 m a) (n N
7 N V or r 1
N
(n O
(O 0)
' (O '
O40v nO
4LO N ' N CO
to O r- co n
n (n N O N
r c)
n a) to
O N (D
(') ' Q ' N '
O n 0
N n
O)
C Y
CL)
E
N N 0
W O a m7'
>.6 0 m E c c
E °- o 2 1- m
1p m E a
m vJ m E a 7 c (O
E a o m o 1-
EEUi-<<�C
(D
LO
N
(D
a0
(D
CD
v
01
0)
(0
1-
(n(n0)Cr)
n
O N N (0
r0 N (n
(0
• .
CO
N �_ CO
[] 7
N
LO
n 00 4-
N
(n in CO O
O 01 O Cr)
M (n
n co m
m r- r-
(0 n N n
(n n m r
N
0)
=
C Y
a
_ E a_
U N N
a c ° o
w -.0 � m
✓1 o E C Y
Q Q6 (9 4N a
E 0 0 2 H J
a E �� A
J p_ E m C
C g} U a 2 H
m
O
M
Lrl
N
0
N
v
m c0 v 0) 0 N
0 N 0) — (co
N
(n r- n N
(n (O (0
u7 CO
00
0
0 0 N '4)
(') CO 0-
c0 (0
co
41-
c0
c0 c0 N a)
O 6] n N
r) v m
O
01
0)
a
m
0)
C
0
1-
CO) N n
40 O
C)) ("1
(O (D
N N
CDN
(h 4)
O V 4r
<0 CO N
N
(n 0)
CD h
7
0
(i)
r
n N
0 N
CO
m
LO •
Lo
Lo
ler
(+)
(D
LO
04 co m a) 41-41-
7 N a)rn—
(n W N -'4i-
01 r (0 N m
cO (O
O 4
at
N
41 CD 4- 0) (D r-
4-
4- C (n (n (') N CD
N •-- 00 O N
[) u)
N (0 W n ' N
CO ID n
r ' CO 0)
O (C1 07 -Cr 4r ( O_
m c0 .11 O (0 (f1
N (0 r 1+
r N
4) 0)
O n
(D 0) 41-
0) �' CO '
•
4l n (O M
N cr. 00 CO
N CO ' O)
(0 N 4) V r-
00 Ch 10 N
v
ID v 47
0) r m
•
LO O 4)
N n 41 -
CO
(O '0 7 '
r CO (n
C') r` r-
(0 4r N r-
0- LO N
4)
4)
m
2r2i
c 7 0
0 0 0-
0 m E
U U a (d
m o
E a
E v oc
n o m w 7
N 0 t � O
« 2 07
n
N
C••4
e
h
m
O
N"
O)
n
C
Q)
e
a
m
G
U
U
0
1n
0
F
FY 2011 Budget
Percent of FY 201 1 Budget Expended
7 O (r)
n (n 4)
(U r O
r N
0-
0-
0
03
(Nf) N (0
CO m
0 O u)
(D 0) a)
v r') (0
r- 0) a) O
c0 N N
re -