HomeMy WebLinkAbout4-25-11 Finance UpdateMonthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
April 25, 2011
(1) Monthly Investment Report
(2) March 2011 Financials
Investment Income
Fiscal Year 2010-11
9
$ 70,063 $ 685,200
70,063 685,200
(3,503) (34,260)
Investment Income - Net $ 66,560 $ 650,940 I
1-
A.}
1
CO
Investments By County Function
General $ 128,386,106
Total Investments $ 128,386,106
T TIT • T [R'IEi��►iFTafl [
• esc utes ount
- tment 'ortfoli• A 0
1
w
0
0 0 0 o e e O
O (!D O N O O•
O c' Coi O O P. O
M N
(O V' ti C`')
N IL) ' N ' 0
Ch N OA
Cr CO CO
N r N
r- y- cT CO
4)
m a)
a- O
mZ
2 0)
E o
Oit
O
0 0
Time Certificates
CO
Co
co
M
cc
N
W
Total Investments
1 o 0 0
d' co, 0)
4.0 COW
o v 0
■
e e e 1
Lo co A 1
ci O o
- u)
— 0) a,
DI
V ( 03r
b y Of
0 > >1
en = Q1
N
L
O
L
Q
E
O
0
0 0 0
C) O N
O N
O O O
Average Maturity in Days
oe e o o e o
00 to in .00 O
O
0 P. N N N x
r r
N
(1)
U
w c(0
m n
U' 0)
U
co Q d
N
c`0 5
-00 C
J U-
Time Certificates
0)
a(n
CO 0)
O
.3 Z
•U a)
N i6
E o
Otl
O
0 0
Total Portfolio: By Investment Types
M
E
U
z
0
U
w
YI
0
remnmirrri=
E
1-
•
U $
•
• G
2
O C
•
ro
A
Market Value
U
O
o •
•
T �
C
a
O •�
O z
0
o •
m �
0
O
2
0
7•e
•
L •
g G
edAj
Cusip Number
Investment Description
J J
000 ou 000 000 0&,0 0
Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z E Z Q Q Z Q Z Q N Q N Z Z
Q o 0 O O O O U O
0 N 0 0 hNOOQ N 0 r1 O 0 u') ON 00 0 0 N C 0 C 0 001 0 0 C 0 0 0 N C 0 0 �m-(mpp 0 O r) 0 0 0 0 0 0 00
• 0 O (0 LLQ% OQi N 0 O 0
n m 0 m n m 0 LL0 N O N N Q N 0 M 0 Q N O P N 0 03 0 0 0 0 0 0 0 uI N
0 (") N O N N 0 Q 0 m n n N 00 0 0 N Q N 0 N n �- Q O N •- 0 0
O 0 N 0
ON O O O O m N O 0 0 0 n O COO N N O N 0 0 0 0 0 0 0 0 0 O CO0 O NN O O O O O Q O
N N N CNN N N N N N N N N N N N N'- N N N (V ' N N N N N N N N N N
Q 0 0 0 N,- 0 0 0 0 0 0 0 0 0 0 N m n O O n 0 0 0 0 0 0 N 0 0 0 0 0 0 0 0 0 0 r1 m
NONNN - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 O O O O O O N 0 0 0 0 0 0 0 0 0 0 (7 CO
co
▪ O CO Q (NO N Q (0 0 0 0 0 N (O V O (7 0 N 0 O 0 CO m 00 (0 (QO O O Q N OOi CV CO 0 CO 0 0 O) 0 O) Q N O O N O
CO CD co
0_- 0 CO 0 0 0 CO 0 0 0 0 0 0 0 0 0 0,- O CO N O N 0 0 0 0 0 0,01,-001,-01,-0101010101.-
- N
m ,- 0 m 0r m N O0 ) 00) O) 0 m_- 0
N CNN N N N N N N N N N N N N N •- N N N N •- N •-
0 0 0 0 0 0 0 0 0 0 0 0 0 0 N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
i x0000 Ototp 0000c(�Qp0(((0p00000Cr 000c(�0pO(0(0p0000000000000000
Q 0 0 0 0 0 ( (7 n 0 0 0 m 0 m n 0 0 0 0 N 0 0 Q 0 0 0 0 0 0 0 0 Q n 0 0 0 0 0 0 0 0
e rn0000rn0 rno00m0vOQa0(�"•1vNa0°f 00Q 000,10
0,0(" 0,0000000 a0
O m •- 000,,-000000.-0,-0 N O C‘1000 0 0010,- O O.- 0.- 000 O O e- e-
N- N N •• N N N N N N N N N N N N' N N 0- 0 N N 0 N N N N N N
O n 0
Q O
n n 0 0
0 N n
(000
0, n0 oD
C6-
V n 00
0 ( 0
N N n
0 0 0
N O m
0 n (0
N Cr,
0
(0 N
m N O
n
F.:1, 0
CD N n
0 0 0
0) 0 m
O n 0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (7 0 m (0 O O(0 N O N 0 0 0 0 0 0 0 0 T 0 0
0 0 0 0 0 N 0 0 0 0 0 0 0 n m 0 0 0 n 0 0 N 0 0 0 r1 N 0 r) C) 0 (0 0 0 0 N O N 0 a0 (V 0 (O
0 0 M M Q-- Q) N' O (0 0 0 n O 0 (0 O O n 0,- n 0 0 0 0 0 0 0 n 0 O 0 O n 0 0 0 0 0 0 aO (• O
- o o o 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 o c
00 0 0 0 0 • 0 0 0 0 0 0 000000 0 0 0 0 0 0 0 0 0 0
00 00 ti n O (O (O n n N 0 r) 0 0 CV 0 0 0 0 0 0 n N. N N N CO 00 0
0 0 0 (0 0 000)00 0 0 00.4666666o
S 127,492,938.71
M
0
C
•
a E
N
•
'Ea a$=
H m a -
9
g o O
a CO
CO LO 0,- 0 LO 01 V u0') N V 0 0 (• no M 0 N 0 0 N 0 u0i (00 N N (o CO CO t00 (Oo co N CD N CO CO N N N CO E 7.C.
a O <s
o
N NNNN N N N N N (V N N N N N NCNINCNINN N (0 (0 •>
A C 0
(0OO pCV ONryOO("ryW0N NN00N 00000N N 0 0 N 0 0 0
01 '- 0 0 0 0 (0 O • (O U
Q N 0 0 (p(p n 0 0 m m m m 0 0 •- Nn n n7 > a U~
0000000000000 �---- 0`0`0COm COm COO m m m m m O O O O N
0 00000000000 00 a 00
m m m 0 m m 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 •- ' 0 •- 0, 0 0- 0 0 0 •- 0 0 0 0
0 0 0 .-00
CO O O n m 0) .- - M n o.- 0 n N r) n n n (7 (p O- 01 (7 M M 0 (7 n r) Q 01 0) Q(p 01 01 0, O
N O N N N 0- N (7 0 N N 0 0 N 0 0 0-,- N N 0 N 0- 0 0 0- N 0 0 0 0- (7 (7
m N N (7 co 0 0 Q N n n N N N N (7 ' N m O) O) N O O N r)
O 0 0 0 0 0 0 0 0 0 0- 0 0—— •- 0 0 0— 0 0 0 0 0 0 •- O'— 0 0
Z<0000a Z Z 0<<<<Z <0000<00«<<<<0<< z< z<<<<<00
U LL r r r 1-. LL c.7 c.7 r LL LL LL LL U LL r r r r LL r r LL LL LL LLLL LL r LL LL U LL U LL LL LL LL LL r r
Z Z>> r m Z LL LL Z Z LL CO CO d' LL U LL Z 3 0- ZZZ Z LL LL< Z LL Z LL Z< Z LL
cncncncoco na30a-coco ��U0m0va.DCOcoww30.M w co3anmLL'n=U
N N
3 0
,4
�i r)
J▪ < 0 r r • Q 0i <
• 3(0 LL 0 W a 0
(0 (7 n (7 O co cO N
f r) m co co M O- m
r) 0 0 n n el n 3
31398AZN5
3133XWKU2
3133XTHE9
X X
N N
MM
M M
(n (n
(n 0 n CO (n Q 0
N m 0 -) Y _) m>
• n << a <
03.-.-030030300
M M O CO COM M
r) n n () 0 r) c7) (7
Z
Z Q 0 Q 0
0 0 ' Ua 0 U o_ m U,
O N DY
0 C U
0C
C C Z U N co U U U 2 U mUZ Y Y m
0 a U 0 N m LL O m
NU T T'j U Cm m` o 0 Y 0 YC U y C NN fi
• co o m 0 N N N (nN N i
Memorandum
Date: April 14, 2011
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find March 2011 financial reports for the following funds: General
(001), Community Justice — Juvenile (230), Sheriff's (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
GENERAL FUND
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY
Coll. %,
RESOURCES:
Beg. Net Working Capital $ 8,300,000 $ 9,677,699
Revenues
Property Taxes 15,424,500
Gen. Rev. - excl. Taxes 1,797,854
Assessor 596,768
County Clerk 915,536
BOPTA 9,299
District Attorney 235,575
Finance/Tax 135,150
Veterans 50,900
Property Management 68,349
Grant Projects 1,500
$ 1,377,699
Revised
Year End
$
Budget
Projection
Variance
100% 117% $8,300,000 $9,677,699 $ 1,377,699
20,014,280 4,589,780 75% 97%
2,082,384 284,530 75% 87%
665,284 68,516 75% 84%
1,121,047 205,511 75% 92%
10,627 1,328 75% 86%
128,863 (106,712) 75% 41%
162,682 27,532 75% 90%
33,772 (17,128) 75% 50%
73,613 5,264 75% 81%
1,500 0 75% 75%
Total Revenues 19,235,431
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
FinanceiTax
Veterans
Property Management
Grant Projects
Non -Departmental
Contingency
24,294,052 5,058,621 75% 95%
27,535,431 33,971,752
2,536,664
1,113,095
56,552
3,661,595
635,183
196,648
189,920
84,152
1,664,540
3,783,956
13,922,305
Transfers Out 11,080,623
TOTAL REQUIREMENTS 25,002,928
NET (Resources - Requirements) 2,532,503
2,396,212
957,745
45,675
3,592,717
627,854
194,626
188,928
82,949
928,873
9,015,579
11,553,798
20,569,376
13,402,375
6,436,321 75% 100%
140,452
155,350
10,877
68,878
7,329
2,022
992
1,203
735,667
3,783,956
4,906,726
(473,175)
4,433,552
10,869,872
Exp.
75% 71%
75% 65%
75% 61%
75% 74%
75% 74%
75% 74%
75% 75%
75% 74%
75% 42%
75% n/a
75% 49%
75% 78%
75% 62%
20,566,000
a) 2,397,138
b) 795,690
1,220,714
b) 12,398
314,100
b) 180,200
67,866
91,132
2,000
20,996,770 430,770
2,497,138 100,000
795,690
1,530,344 309,630
12,398
270,300
200,200 20,000
67,866
91,132
2,000
(43,800)
25,647,238
26,463,838 816,600
33,947,238 36,141,537 2,194,299
3,382,219 3,287,219 95,000
1,484,127 1,381,923 102,204
75,403 75,403
4,882,127 4,778,777 103,350
846,910 833,910 13,000
262,197 262,197
253,227 253,227
112,203 112,203
2,219,387 2,119,387
5,045,274
18, 563,074 13,104, 246
c) 14,774,164 14,774,164
33,337,238 27,878,410 5,458,828
d) 610,000 8,263,127 7,653,127
100,000
5,045,274
5,458,828
Beginning NWC per Requested Budget 7,300,000
a) YTD Actual includes annual payments: Federal in lieu of taxes - $471,913 and State tax on electric co-ops - $464,452.
Justice Courts fines projected to be $90,000 more than budgeted, Interest projected to be $10,000 more that budgeted
b) YTD Actual includes three quarterly payments of the A&T grant.
c) Revised Budget and Year End Projection include $1.8 million transfer of 'one time resources".
d) Appropriation transferred to Fund 575 - $610,000
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
COMM JUSTICE -JUVENILE
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Budget
Year to Date
Actual
Variance
FY
Coll.
$ 987,000
11,645
45,000
12,000
28,500
255,005
75,000
75
66,368
225
750
12,750
1,800
375
4,500
45,371
15.000
Revised
Year End
Budget
Projection
Variance
$ 1,039,997 $ 52,997 100% 105% $ 987,000 $ 1,039,997 $ 52,997
574,364
7,985 (3,660) 75% 51% a)
37,489 (7,511) 75% 62%
9,859 (2,141) 75% 62%
20,355 (8,145) 75% 54% b)
103,769 (151,236) 75% 31% c)
48,900 (26,100) 75% 49% d)
128 53 75% 128%
69,544 3,176 75% 79%
70 (155) 75% 23%
170 (580) 75% 17%
6,263 (6,487) 75% 37%
1,800 - 75% 75%
327 (48) 75% 65%
3,319 (1,181) 75% 55%
48,250 2,879 75% 80% e)
10,000 (5,000) 75% 50%
368,228 (206,136) 75% 48%
Transfers In -General Fund 4,157,389 4,157,389
TOTAL RESOURCES 5,718,753 5,565,614
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
2,222,967
Materials and Services 899,915
Capital Outlay 75
Juvenile Resource Center
Personal Services 1,736,328
Materials and Services 131,621
Contingency 481,098
TOTAL REQUIREMENTS
2,052,447
773,543
1,603,280
127,481
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
15,527
57,500
16,000
27,150
266,358
80,000
170
70,000
100
300
9,000
2,400
500
6,000
96,500
20,000
(2,500)
(10,850)
(73,648)
(20,000)
70
(18,490)
(200)
(700)
(8,000)
36,005
765,818 667,505
750/0 75% 5,543,186 5,543,186
(153,139) 75% 76% 7,296,004 7,250,688
170,520 75%
126,372 75%
75 75%
Exp.
69% f)
64% g)
0%
133,048 75% 69% h)
4,140 75% 73%
481,098 75% n/a
2,963,956
1,199,886
100
2,315,104
175,494
641,464
2,725,000
1,073,000
(98,313)
(45,316)
238,956
126,886
100
2,184,314 130,790
167,000 8,494
641,464
5,472,004 4,556,751 915,253 75% 62% 7,296,004 6,149,314 1,146,690
NET (Resources - Requirements) 246,749 1,008,863
762,114 1,101,374 1,101,374
Beginning NWC per Requested Budget 1,101,374
a) Second quarter Federal Grant reimbursement of $7,000 is expected in April
b) Food subsidy revenues trending less than anticipated due to lower juvenile population, CCF billed quarterly
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)
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
E Law Enf Dist Rural
Total Revenues
TOTAL RESOURCES
SHERIFF - Fund 255
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY
Coll. %
$
17,122,093
10,249,454
27, 371, 547
$
100%
13,451,086 (3,671,007) 75%
8,533,030 (1,7,16,424) 75%
21,984,115 (5,387,432) 75%
n/a
59%
Revised
Year End
Budget
Projection
Variance
$ - $
22,829,457 18,775,050 (4,054,407)
62% 13,665,939 11,465,581 ; "(2,200,358)
60% 36,495,396 30,240,631 (6,254,765)
27,371,547 21,984,115 (5,387,432) 75% 60% 36,495,396 30,240,631 (6,254,765)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division 2,227,538
Civil 616,827
Automotive/Communications 1,089,777
Investigations/Evidence 1,238,094
Patrol/Civil/Comm Supp 5.985,488
Records 495.290
Adult Jail 7.391.148
Court Security 210.638
Emergency Services 130.831
Special Services Division 931,803
Regional Work Center 2,169,182
Training Division 247.500
Other Law Enforcement Svcs 447,688
Non -Departmental 212,264
Contingency 3,827,480
Transfer Out - Jail Remodel 75,000
Transfers Out - D/S Fund 75.000
2.410,660
599,324
1,146, 469
1.107,334
5.848, 851
456,315
6.467,851
201,252
124,252
808,601
1.971,266
180,239
438,899
62,264
100,000
60,539
(183,122)
17,503
(56,692)
130,760
136.637
38,975
923.297
9.386
6,579
123,202
197,916
67,261
8.789
150.000
3,827,480
(25, 000)
14,461
TOTAL REQUIREMENTS 27,371,548 21,984,115
NET (Resources - Requirements)
Beginning NWC per Requested Budget
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
750/0
75%
75%
Exp.
81% a)
b)
b)
67% b)
73% b)
69% b)
66% c)
72%
71%
65%
68% d)
55% e)
74%
22%
n/a
n/a
61%
73%
79%
2,970,051
822,436
1,453,036
1,650,792
7,980,651
660,386
9,854,864
280,851
174,441
1,242,404
2,892,242
330,000
596,917
283,018
5,103.307
100,000
100,000
3, 011,668
773,336
1,417,016
1,535,737
7,724,351
637,286
9,375,364
273,751
169,341
1,241,404
2,701,142
304,900
592,317
283,018
100,000
100,000
(41,617)
49,100
36,020
115,055
256.300
23.100
479,500
7.100
5,100
1.000
191.100
25,100
4.600
5.103, 307
5,387,433 75% 60% 36,495,396 30,240,631 6,254,765
a) Higher than budgeted employee vacation sell back and legal labor expenses. Appropriation transfer pending
b) Delay in filling open positions will result in lower personnel expenditures for FY 2011
c) Unfilled budgeted positions and less than planned jail bed rental. Forecast includes $73,000
for jail bed rental and $350.000 for JMS software in Qtr 4
d) Unfilled budgeted positions and lower material and service expenditures projected for FY 2011
e) Personnel expenses will be lower than planned due to employee transfers
Fund 701 LED -Countywide
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY %
Coll.
RESOURCES:
Beg. Net Working Capital $4,722,862
Tax Revenues - Current 11,140,196
Tax Revenues - Prior 481,500
Federal Grants 26,250
State Grant 36,356
Transp. of State Wards 3,750
SB 1145 1,480,995
Des. Cty Video Lottery Grant 3,750
Des Cty Court Security 71,250
Des Cty Juvenile Contract
Title III Reimbursement 112,500
Transport 3,000
DC Fair & Expo Center
Inmate Commissary Fees 36,000
Work Center Work Crews 18,750
Concealed Handgun Classes 4,500
Soc Sec Incentive -Fed 3,750
Miscellaneous 3,750
Oregon Mentors
Medical Services Reimb 9,000
Restitution 750
Sheriff Fees 120,000
Interest 21,250
Interest on Unsegregated 2,650
Rentals
Donations
Sale of Reportable Assets
Total Revenues
TOTAL RESOURCES
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
Total Requirements
$ 5,609,156
14,139,129
633,855
47,963
54,332
3,321
1,480,995
71,141
4,994
154,996
424
4,185
55,417
43,290
3,050
5,600
5,415
9,520
13,142
3,465
197,640
38,475
1,576
2,500
200
1,257
$ 886,294
2,998,933
152,355
21,713
17,976
(429)
(0)
(3,750)
(109)
4,994
42,496
(2,576)
4.185
19,417
24,540
(1,450)
1,850
1,665
9,520
4,142
2.715
77,640
17,225
(1,074)
2,500
200
1,257
13,579,947
18,302,809
16,975,882
22,585,038
2,107,251 2,280,484
616,827 599,324
392,320 412,729
7,391,148 6,467,851
210.638 201,252
130.831 124,252
752,897 653,349
2,169,182 1,971,266
150,975 109,946
447,688 438,899
31,194 31,194
75,000 60,539
75,000 100,000
75,000 -
2,496,143 -
100%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
750/0
75%
75%
Budget
Year End
Projection
Variance
119% $
95%
99%
137% a)
112%
66%
75% a)
0%
75%
n/a
103% a)
11%
n/a
115%
173% b)
51%
112%
108%
n/a
110%
347%
124% c)
136%
45%
n/a
n/a
n/a
4,722,862
14,853,594
642,000
35,000
48,475
5,000
1,974,660
5,000
95,000
150,000
4,000
48,000
25,000
6,000
5,000
5,000
12,000
1,000
160,000
28,333
3,533
$5,609,156 $ 886,294
14,853,594
727,000 85,000
47,963 12,963
71,627 23,152
5,000
1,854,660 (120,000)
5,000
95,000 -
4,994 4,994
154,996 4,996
4,000 -
4,185 4,185
68,000 20,000
50,000 25,000
6,000 -
5,600 600
5,415 415
15,000 15,000
18,000 6,000
5,000 4,000
220,000 60,000
53,075 24,742
3,533
2,500 2,500
200 200
1,257 1,257
3,395,935 94% 18,106,595 18,281,599 175,004
4,282,229 75% 99% 22,829,457 23,890,755 1,061,298
(173,233)
17,503
(20,409)
923,297
9,386
6,579
99,547
197,915
41,029
8,789
(0)
14,461
(25, 000)
75,000
2,496.143
Exp.
75% 81% 2,809,668 2,849,038 (39,370)
75% 73% 822,436 773,336 49,100
75% 79% 523,093 510,126 12,967
75% 66% 9,854,864 9,375,364 479,500
75% 72% 280,851 273,751 7,100
75% 71% 174,441 169,341 5,100
75% 65% 1,003,862 1,003,054 808
75% 68% 2,892,242 2,701,142 191,100
75% 55% 201,300 185,989 15,311
75% 74% 596,917 592,317 4,600
75% 75% 41,592 41,592
75% 61% 100,000 100,000
75% 100% 100,000 100,000
75% 0% 100,000 100,000
75% 0% 3,328,190 3,328,190
17,122,093 13,451,086 3,671,006 59% 22,829,457 18,775,050 4,054,407
Net 1.180,716
9,133,953 7,953,237 5,115,705 5,115,705
Beginning NWC per Requested Budget 5,108,671
a) Anticipated funding reduction from Dept. of Corrections
b) Work crew revenue from USFS is higher than anticipated
c) Actual revenue for concealed weapons permits and civil papers will exceed budget
Fund 702 LED Rural
Statement of Financial Operating Data
Nine Months Ended March 31. 2011
Year to Date
Budget T Actual
Variance
FY
Coll.
RESOURCES:
Beg. Net Working Capital $ 1,905,939 $ 2,498,487 $ 592,548 100% 131% $ 1,905,939 $ 2,498,487 $ 592,548
Revenues
Tax Revenues - Current 5.631,184 7,119,822 1.488,638 75% 95% 7,508,247 7.508.247 -
Tax Revenues - Prior 235,500 315,531 80,031 75% 100% 314,000 371,000 57,000
Federal Grants 1,500 13.326 11,826 75% 666%a; 2,000 13,326 11,326
Federal Grants-BLM - 7,608 7,608 75% n/a - 10,000 10,000
US Forest Service 57,375 64,125 6,750 75% 84% 76,500 78,750 2,250
State Grant 140,725 73.926 (66,799) 75% 39% 187,633 187,633 -
SB #1065 Court Assessmi 50.250 37,489 (12,761) 75% 56% 67,000 50,000 (17,000)
Marine Board License Fee 106,825 49.842 (56,983) 75% 35%b; 142,433 187.433 45,000
Des Cty General Fund Gr< 526,769 (526,769) 75% 0% c) 702,358 702,358 -
Des Cty Transient Room l 1.460,732 1,460,732 (1) 75% 75% 1.947,642 1,947,642
City of Sisters 324,491 324.491 0 75% 75% 432,655 432,655 -
Des Cty Tax/Fin Contract 750 (750) 75% 0% 1,000 1,000
Des Cty CDD Contract 40,775 40,775 (1) 75% 7501. 54,366 54,366
Des Cty Solid Waste Cont 40,775 40,775 (1) 75% 75% 54,366 54,366 -
Des Cty Clerk/Election 1,500 675 (825) 75% 34% 2,000 2,000
School Districts 75,000 32.725 (42,275) 75% 33% d; 100,000 50,000 (50,000)
Claims Reimbursement - 8,472 8,472 75% n/a 8,472 8,472
Security & Traffic Reimb 9,750 1,081 (8,669) 75% 8% 13,000 13,000
Seat Belt Program 4,500 5.000 500 75% 83% 6,000 6,000
Miscellaneous 7,500 7,751 251 75% 78% 10,000 10.000
Restitution 375 - (375) 750/ 0% 500 500
Sheriff Fees 7,500 7,444 (56) 75% 74% 10,000 10,000
Court Fines & Fees 63,750 92,501 28,751 75% 109% e) 85,000 120,000 35,000
Impound Fees 11,250 5,100 (6,150) 75°l° 34% 15,000 15,000
Restitution - Street Crimes 375 (375) 75% 0% 500 500
Interest 7.500 15.666 8,166 75% 157% 10,000 20,000 10,000
Interest on Unsegregated 1,350 792 (558) 75% 44% 1,800 1,800
Donations - 4,090 4,090 75% n/a - 5.000 55,000
Sale of Reportable Assets 7,500 32,762 25,262 75% 328% f) 10,000 32,762 22,762
Sale of Equip & Material 4,500 3.525 (975) 75% 59% 6,000 10,000 4,000
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Department
Sheriffs Services
Auto/Comm
Investigations
Patrol
Records
Special Services
Training
Internal Services
Transfer for Reserve
Contingency
Total Requirements
Net
8,820,001 9,766,025 946,024 50% 83% 11,760,000 11,903,810 143,810
10,725,940 12,264,513 1,538,573 50% 90% 13,665,939 14,402,297 736,358
Exp.
120,287 130,176 (9,889) 75% 81% 160,383 162.630 (2,247)
697,457 733,740 (36,283) 75% 79% 929,943 906,890 23,053
1,238,094 1,107,334 130,760 75% 67% 1,650,792 1,535,737 115,055
5,985,488 5,848,851 136,638 75% 73% 7,980,651 7,724.351 256,300
495,290 456,315 38,975 75% 69% 660,386 637,286 23,100
178,906 155,251 23,655 75% 65% 238,542 238,350 192
96,525 70,293 26,232 75% 55% 128,700 118,911 9,789
31,069 31,070 - 75% 75% 41,426 41.426
Fund 75,000 - 75,000 75° 0% 100,000 100,000
1.331,337 1,331,337 75% 0% 1.775,117 1,775,117
10,249,454 8,533,030 1,716,425 62% 13,665,939 11,465,581 2,200,358
476,486 3,731.483 3,254,997 - 2,936,716 2.936,716
Beginning NWC per Requested Budget 2,936,523
a) Actual HIDTA overtime reimbursement higher than budgeted
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 from traffic fines will exceed budget
f) Proceeds from sale of used patrol vehicles were higher than estimated
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 1,905,939 $ 2,498,487 $ 592,548 100% 131% $ 1,905,939 $ 2,498,487 $ 592,548
Revenues
Tax Revenues - Current 5.631,184 7,119,822 1.488,638 75% 95% 7,508,247 7.508.247 -
Tax Revenues - Prior 235,500 315,531 80,031 75% 100% 314,000 371,000 57,000
Federal Grants 1,500 13.326 11,826 75% 666%a; 2,000 13,326 11,326
Federal Grants-BLM - 7,608 7,608 75% n/a - 10,000 10,000
US Forest Service 57,375 64,125 6,750 75% 84% 76,500 78,750 2,250
State Grant 140,725 73.926 (66,799) 75% 39% 187,633 187,633 -
SB #1065 Court Assessmi 50.250 37,489 (12,761) 75% 56% 67,000 50,000 (17,000)
Marine Board License Fee 106,825 49.842 (56,983) 75% 35%b; 142,433 187.433 45,000
Des Cty General Fund Gr< 526,769 (526,769) 75% 0% c) 702,358 702,358 -
Des Cty Transient Room l 1.460,732 1,460,732 (1) 75% 75% 1.947,642 1,947,642
City of Sisters 324,491 324.491 0 75% 75% 432,655 432,655 -
Des Cty Tax/Fin Contract 750 (750) 75% 0% 1,000 1,000
Des Cty CDD Contract 40,775 40,775 (1) 75% 7501. 54,366 54,366
Des Cty Solid Waste Cont 40,775 40,775 (1) 75% 75% 54,366 54,366 -
Des Cty Clerk/Election 1,500 675 (825) 75% 34% 2,000 2,000
School Districts 75,000 32.725 (42,275) 75% 33% d; 100,000 50,000 (50,000)
Claims Reimbursement - 8,472 8,472 75% n/a 8,472 8,472
Security & Traffic Reimb 9,750 1,081 (8,669) 75% 8% 13,000 13,000
Seat Belt Program 4,500 5.000 500 75% 83% 6,000 6,000
Miscellaneous 7,500 7,751 251 75% 78% 10,000 10.000
Restitution 375 - (375) 750/ 0% 500 500
Sheriff Fees 7,500 7,444 (56) 75% 74% 10,000 10,000
Court Fines & Fees 63,750 92,501 28,751 75% 109% e) 85,000 120,000 35,000
Impound Fees 11,250 5,100 (6,150) 75°l° 34% 15,000 15,000
Restitution - Street Crimes 375 (375) 75% 0% 500 500
Interest 7.500 15.666 8,166 75% 157% 10,000 20,000 10,000
Interest on Unsegregated 1,350 792 (558) 75% 44% 1,800 1,800
Donations - 4,090 4,090 75% n/a - 5.000 55,000
Sale of Reportable Assets 7,500 32,762 25,262 75% 328% f) 10,000 32,762 22,762
Sale of Equip & Material 4,500 3.525 (975) 75% 59% 6,000 10,000 4,000
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Department
Sheriffs Services
Auto/Comm
Investigations
Patrol
Records
Special Services
Training
Internal Services
Transfer for Reserve
Contingency
Total Requirements
Net
8,820,001 9,766,025 946,024 50% 83% 11,760,000 11,903,810 143,810
10,725,940 12,264,513 1,538,573 50% 90% 13,665,939 14,402,297 736,358
Exp.
120,287 130,176 (9,889) 75% 81% 160,383 162.630 (2,247)
697,457 733,740 (36,283) 75% 79% 929,943 906,890 23,053
1,238,094 1,107,334 130,760 75% 67% 1,650,792 1,535,737 115,055
5,985,488 5,848,851 136,638 75% 73% 7,980,651 7,724.351 256,300
495,290 456,315 38,975 75% 69% 660,386 637,286 23,100
178,906 155,251 23,655 75% 65% 238,542 238,350 192
96,525 70,293 26,232 75% 55% 128,700 118,911 9,789
31,069 31,070 - 75% 75% 41,426 41.426
Fund 75,000 - 75,000 75° 0% 100,000 100,000
1.331,337 1,331,337 75% 0% 1.775,117 1,775,117
10,249,454 8,533,030 1,716,425 62% 13,665,939 11,465,581 2,200,358
476,486 3,731.483 3,254,997 - 2,936,716 2.936,716
Beginning NWC per Requested Budget 2,936,523
a) Actual HIDTA overtime reimbursement higher than budgeted
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 from traffic fines will exceed budget
f) Proceeds from sale of used patrol vehicles were higher than estimated
RESOURCES:
Beg. Net Working Capital
Revenues
PUBLIC HEALTH
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY
Coll. %
$1,100,000 $ 1,615,306 $ 515,306 100% 147%
Medicare Reimbursement 6,000
State Grant 1,884,733
Child Dev & Rehab Center 23,069
State Miscellaneous 164,922
OMAP 358,350
Title 19 -
Family Planning Exp Proj 371,250
Local Grants 48,750
Water Program -Base Fee 31,500
Water Program -Field Work 41,863
H2O Sys Insp-Priv Wells 150
Miscellaneous
Patient Insurance Fees 142,695
Health Dept/Patient Fees 111,731
Vital Records -Birth 27,000
Vital Records -Death 73,500
Environmental Health 515,513
Interest on Investments 12,675
Donations 4,500
Interfund Contract 142,034
Administrative Fee 20,250
Drug Court Byrne
Total Revenues 3,980,485
Transfers In -General Fund
Transfers In -PH Res Fund
Transfers In -Gen. Fund Other
TOTAL RESOURCES
1,738,325
50,342
50,859
147 (5,853) 75% 2%
1,738,287 (146,446) 75% 69% a)
15,379 (7,690) 75% 500/0
179,413 14,491 75% 82%
467,377 109,027 75% 98%
211 211 75% n/a
344,165 (27,085) 75% 700/0
84,340 35,590 75% 130%° b)
28,158 (3,342) 75% 67%
36,260 (5,603) 75% 65%
(150) 75% 0%
83 83 75% n/a
106,662 (36,033) 75% 56% c)
85,212 (26,519) 75% 57% c)
23,835 (3,165) 75% 66%
75,465 1,965 75% 77%
664,217 148,704 75% 97% d)
8,499 (4,176) 75% 50°
31,793 27,293 75% 530% e)
32,036 (109,998) 75% 17%
20,250 75% 75%
4,157 4,157 75% n/a
3,945,946 (34,539) 75% 74%
1,738,325
50,342
50,859
6,920,011 7,400,778
75% 750/0
75% 75%
75% 75%
480,767 75% 84%
REQUIREMENTS:
Expenditures
Personal Services 4,392,872 4,282,297 110,575 75%
Materials and Services 1,504,040 1,448,956 55,084 75%
Capital Outlay 18,750 5,432 13,318 75%
Transfers Out 112,500 112,500 75%
Contingency 616,847 616,847 75%
TOTAL REQUIREMENTS 6,645,009 5,849,185 795,824 75%
NET (Resources- Requirements) 275,002 1,551,593 1,276,591
Exp.
73%
72%
22%
75%
n/a
Revised
Budget
Year End
_ Protection
_ Variance
$1,100,000 $1,615,306 $ 515,306
8,000
2,512,977
30,759
219,896
477,800
495,000
65,000
42,000
55,817
200
190,260
148,975
36,000
98,000
687,350
16,900
6,000
189,378
27,000
200 (7,800)
2,613,704 100,727
30,759
269,334 49,438
520,000 42,200
300 300
520,000 25,000
113,773 48,773
42,000
55,817
200
200 200
135,000 (55,260)
103,500 (45,475)
30,000 (6,000)
96,000 (2,000)
687,350
11,200 (5,700)
35,430 29,430
162,513 (26,865)
27,000
4,157 4,157
5,307,312
2,317,765
67,123
67,812
5,458,437
2,317,765
67,123
67,812
151,125
8,860,012 9,526,443 666,431
5,857,162
2,005,387
25,000
150,000
822,463
5,784,000
1,970,226
25,000
150,000
73,162
35,161
822,463
66% 8,860,012 7,929,226 930,786
- 1,597,217 1,597,217
Beginning NWC per Requested Budget 1,596,918
a) State grant through Revision #4, supplemental grant appropriation to be submitted
b) Health Matters -local grant for Chronic Care Program is $17,000 & $21,000. Bioterrorism NACCHO grant 510,000 received in July
c) In current economic environment, fewer patients with private insurance or self pay
d) Environmental Health fees are due and collected primarily in January
e) My Future My Choice donation carry over from FY10, in the amount of $25,880. $3,550 HIV sponsorship donation
RESOURCES:
Beg. Net Working Capital
Revenues
Marriage Licenses
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Revised
Budget
Year End
Projection
Variance
$ 2,616,050 $ 2,651,262 $ 35,212 100% 101% $ 2,616,050 $ 2,651,262 $ 35,212
4,125
Divorce Filing Fees 97,500
Domestic Partnership Fee 750
Federal Grants 72,727
State Grants 4,925,409
State Miscellaneous 111,130
ABHA
Title 19 225,694
Liquor Revenue 79,050
School Districts 52,500
Miscellaneous 12,675
Patient Insurance Fees 115,500
Patient Fees 9,750
Seizure/Forfeiture
Interest on Investments 32,689
Rentals 9,825
Interfund Contract -Gen. Fund 95,250
Comm. on Children & Fam 18,000
Administrative Fee 3,158,593
Total Revenues
Transfers In -General Fund
Transfers In-OHP-CDO
Transfers In -Acute Care Svcs
Transfers In-ABHA
TOTAL RESOURCES
3,815
99,954
40
44,741
4,384,696
82,552
26,417
101,809
75,487
54,940
32,478
49,244
1,803
14,841
17,307
14,500
79,542
3,163,094
(310) 75% 69%
2,454 75% 77%
(710) 75% 4%
(27,986) 75% 46% a)
(540,713) 75% 67% b)
(28,578) 75% 56%
26,417 75% n/a
(123,885) 75% 34%
(3,563) 75% 72%
2,440 75% 78%
19,803 75% 192%
(66,256) 75% 32%
(7,947) 75% 14%
14,841 75% n/a
(15,382) 75% 40%
4,675 75% 111%
(15,708) 75% 63% a)
(18,000) 75% 0% c)
4,501 75% 75%
9,021,167 8,247,260
987,119
74,999
274,243
501,189
987,119
74,999
274,243
501,189
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
127,000
24,000
4,211,457
5,500
130,000
100
96,969
5,893,958
148,173
160,938
125,000
105,400
70,000
34,000
75,000
3,000
14,841
25,000
16,000
127,000
4,211,457
(900)
(673,254)
160,938
(175,925)
17,100
(79,000)
(10,000)
14,841
(18,585)
2,900
(24,000)
(773,907) 75% 69% 12,028,221 11,242,336 (785,885)
13,474, 767 12,736,072
REQUIREMENTS:
Expenditures
Personal Services 7,002,865
Materials and Services 3,957,188
Capital Outlay 574,500
Transfers Out 117,873
Contingency 1,168,328
6,635,329
2,901,571
159,403
112,500
75%
75%
75%
75%
(738,695) 75%
367,536
1,055,617
415,097
5,373
1,168,328
TOTAL REQUIREMENTS 12,820,754
75%
75%
75%
75%
75%
75%
75%
75%
75%
1,316,158
100,000
365,657
668,252
1,316,158
100,000
365,657
668,252
75% 17,094,338 16,343,665
Exp.
71% d)
55%
21%
72 %
n/a
9,808,803 3,011,951 75% 57%
NET (Resources - Requirements) 654,013
2,927,269 2,273,256
Beginning NWC per Requested Budget
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
9,337,153
5,276,251
766,000
157,164
1,557,770
8,850,000
3,600,000
450,000
150,000
(750,673)
487,153
1,676,251
316,000
7,164
1,557,770
17,094,338 13,050,000
- 3,293,665
4,044,338
3,293,665
3,268, 759
Year to Date
Budget
Actual Variance
FY % Cot. °I°
Revised
Budget
Year End
Projection
Variance
$ 2,616,050 $ 2,651,262 $ 35,212 100% 101% $ 2,616,050 $ 2,651,262 $ 35,212
4,125
Divorce Filing Fees 97,500
Domestic Partnership Fee 750
Federal Grants 72,727
State Grants 4,925,409
State Miscellaneous 111,130
ABHA
Title 19 225,694
Liquor Revenue 79,050
School Districts 52,500
Miscellaneous 12,675
Patient Insurance Fees 115,500
Patient Fees 9,750
Seizure/Forfeiture
Interest on Investments 32,689
Rentals 9,825
Interfund Contract -Gen. Fund 95,250
Comm. on Children & Fam 18,000
Administrative Fee 3,158,593
Total Revenues
Transfers In -General Fund
Transfers In-OHP-CDO
Transfers In -Acute Care Svcs
Transfers In-ABHA
TOTAL RESOURCES
3,815
99,954
40
44,741
4,384,696
82,552
26,417
101,809
75,487
54,940
32,478
49,244
1,803
14,841
17,307
14,500
79,542
3,163,094
(310) 75% 69%
2,454 75% 77%
(710) 75% 4%
(27,986) 75% 46% a)
(540,713) 75% 67% b)
(28,578) 75% 56%
26,417 75% n/a
(123,885) 75% 34%
(3,563) 75% 72%
2,440 75% 78%
19,803 75% 192%
(66,256) 75% 32%
(7,947) 75% 14%
14,841 75% n/a
(15,382) 75% 40%
4,675 75% 111%
(15,708) 75% 63% a)
(18,000) 75% 0% c)
4,501 75% 75%
9,021,167 8,247,260
987,119
74,999
274,243
501,189
987,119
74,999
274,243
501,189
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
127,000
24,000
4,211,457
5,500
130,000
100
96,969
5,893,958
148,173
160,938
125,000
105,400
70,000
34,000
75,000
3,000
14,841
25,000
16,000
127,000
4,211,457
(900)
(673,254)
160,938
(175,925)
17,100
(79,000)
(10,000)
14,841
(18,585)
2,900
(24,000)
(773,907) 75% 69% 12,028,221 11,242,336 (785,885)
13,474, 767 12,736,072
REQUIREMENTS:
Expenditures
Personal Services 7,002,865
Materials and Services 3,957,188
Capital Outlay 574,500
Transfers Out 117,873
Contingency 1,168,328
6,635,329
2,901,571
159,403
112,500
75%
75%
75%
75%
(738,695) 75%
367,536
1,055,617
415,097
5,373
1,168,328
TOTAL REQUIREMENTS 12,820,754
75%
75%
75%
75%
75%
75%
75%
75%
75%
1,316,158
100,000
365,657
668,252
1,316,158
100,000
365,657
668,252
75% 17,094,338 16,343,665
Exp.
71% d)
55%
21%
72 %
n/a
9,808,803 3,011,951 75% 57%
NET (Resources - Requirements) 654,013
2,927,269 2,273,256
Beginning NWC per Requested Budget
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
9,337,153
5,276,251
766,000
157,164
1,557,770
8,850,000
3,600,000
450,000
150,000
(750,673)
487,153
1,676,251
316,000
7,164
1,557,770
17,094,338 13,050,000
- 3,293,665
4,044,338
3,293,665
3,268, 759
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Bud•e
Actual
Variance
FY
Coll.0.
RESOURCES:
Beg. Net Working Capital $ 686,081 613,031
Revenues
Admin -Operations 12,375 11,869
Admin -GIS 2,063 4,229
Admin -Code Enforcement 121,289 112,118
Building Safety 810,913 645,040
Electrical 199,989 174,666
Contract Services 138,000 136,721
Env Health -On Site Prog 212,873 194,371
Planning -Current 582,722 512,728
Planning -Long Range 265,328 216,169
Total Revenues
Trans In -GF
Trans In -GF for Lng Rng Ping
TOTAL RESOURCES
$ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050)
(506)
2,166
(9,171)
(165,873)
(25,323)
(1,279)
(18,502)
(69,994)
(49,159)
75%
75%
75%
75%
75%
75%
750/0
750/0
75%
72%
154% a)
69%
60% b)
66%
74% c)
68%
66% d)
61% e)
2,345,552 2,007,911 (337,641) 75% 64%
190,040 190,040
387,000 387,000
- 75% 75%
- 75% 75%
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
3,608,673 3,197,982 (410,691) 75% 70%
1,051,797
162,101
138,549
375,248
140,705
183,188
174,005
517,718
369,320
129,983
194,539
1,037,727
132,466
138,212
374,407
131,670
171,451
168,564
464,836
383,132
145,000
14,070
29,635
337
841
9,035
11,737
5,441
52,882
(13,812)
(15,017)
194,539
TOTAL REQUIREMENTS 3,437,153
Exp.%
75% 74%
75% 61% f)
75% 75%
750/0 75% g)
750/0 70%
75% 70% g)
75% 73% h)
75% 67% i)
750/0 78% j)
75% 84%
75% n/a
16,500
2,750
161,718
1,081,217
266,652
184,000
283,830
776,962
353,771
15,800
4,400
163,900
1,005,800
240,700
235,200
280,400
706,300
327,600
(700)
1,650
2,182
(75,417)
(25.952)
51,200
(3,430)
(70,662)
(26,171)
3,127,400
253,387
516,000
2,980,100 (147,300)
253,387
516,000
4,582,868
1.402,396
216,135
184,732
500,330
187,606
244,251
232,006
690,290
492,427
173,310
259,385
4,362,518 (220,350)
1,391,651
158,312
182,607
479,817
183,756
225,066
183,725
631,208
523,682
173,310
10,745
57,823
2.125
20,513
3,850
19,185
48,281
59,082
(31,255)
259,385
3,147,466 289,687 75% 69% 4,582,868 4,133,134 449,734
NET (Resources - Requirements) 171,520
50,516 (121,004) 229,384 229,384
Beginning NWC per Requested Budget 229,822
Revenues
Expenditures
Net from Operations
2,007,911
3,147,466
(1,139,555)
3,127,400 2,980,100
4,582,868 4,133,134
(1,455,468) (1,153,034)
(147,300)
449,734
302,434
a) Custom GIS work revenue sporadic. Includes webmaster work for Health Dept
b) YTD revenue is low in relation to budget, it is expected that final revenue will be closer to budget projections, as several large projects
are expected to generate significant revenue later in the fiscal year ($200,000 Sunriver Aquatic Ctr, $50,000 La Pine biomass plant)
c) City of Redmond receipts lag one month behind. YTD is high due to new high school fee revenue and DNF project
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
Year End
Budget
Projection
Variance
$ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050)
(506)
2,166
(9,171)
(165,873)
(25,323)
(1,279)
(18,502)
(69,994)
(49,159)
75%
75%
75%
75%
75%
75%
750/0
750/0
75%
72%
154% a)
69%
60% b)
66%
74% c)
68%
66% d)
61% e)
2,345,552 2,007,911 (337,641) 75% 64%
190,040 190,040
387,000 387,000
- 75% 75%
- 75% 75%
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
3,608,673 3,197,982 (410,691) 75% 70%
1,051,797
162,101
138,549
375,248
140,705
183,188
174,005
517,718
369,320
129,983
194,539
1,037,727
132,466
138,212
374,407
131,670
171,451
168,564
464,836
383,132
145,000
14,070
29,635
337
841
9,035
11,737
5,441
52,882
(13,812)
(15,017)
194,539
TOTAL REQUIREMENTS 3,437,153
Exp.%
75% 74%
75% 61% f)
75% 75%
750/0 75% g)
750/0 70%
75% 70% g)
75% 73% h)
75% 67% i)
750/0 78% j)
75% 84%
75% n/a
16,500
2,750
161,718
1,081,217
266,652
184,000
283,830
776,962
353,771
15,800
4,400
163,900
1,005,800
240,700
235,200
280,400
706,300
327,600
(700)
1,650
2,182
(75,417)
(25.952)
51,200
(3,430)
(70,662)
(26,171)
3,127,400
253,387
516,000
2,980,100 (147,300)
253,387
516,000
4,582,868
1.402,396
216,135
184,732
500,330
187,606
244,251
232,006
690,290
492,427
173,310
259,385
4,362,518 (220,350)
1,391,651
158,312
182,607
479,817
183,756
225,066
183,725
631,208
523,682
173,310
10,745
57,823
2.125
20,513
3,850
19,185
48,281
59,082
(31,255)
259,385
3,147,466 289,687 75% 69% 4,582,868 4,133,134 449,734
NET (Resources - Requirements) 171,520
50,516 (121,004) 229,384 229,384
Beginning NWC per Requested Budget 229,822
Revenues
Expenditures
Net from Operations
2,007,911
3,147,466
(1,139,555)
3,127,400 2,980,100
4,582,868 4,133,134
(1,455,468) (1,153,034)
(147,300)
449,734
302,434
a) Custom GIS work revenue sporadic. Includes webmaster work for Health Dept
b) YTD revenue is low in relation to budget, it is expected that final revenue will be closer to budget projections, as several large projects
are expected to generate significant revenue later in the fiscal year ($200,000 Sunriver Aquatic Ctr, $50,000 La Pine biomass plant)
c) City of Redmond receipts lag one month behind. YTD is high due to new high school fee revenue and DNF project
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
RESOURCES:
Beg. Net Working Capital
Revenues
Mineral Lease Royalties
Forest Receipts
State Miscellaneous
Motor Vehicle Revenue
City of Bend
City of Redmond
City of Sisters
City of La Pine
Admin Recovery (SDC)
Miscellaneous
Road Vacations
Interest on Investments
Other Bank/LGIP Interest
Parking Fees
Grants -Private
Interfund Contract
Equipment Repairs
Vehicle Repairs
LID Construction
Vegetation Management
Forester
Car Washes
Car Rental
Sale of Equip & Material
Total Revenues
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
ROAD
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY%
Coll. %
$ 3,430,429 $ 3,419,603 $ (10,826) 100% 100%
15,000
1,677,750
72,738
7,500,000
206,250
262,500
7,500
7,500
67,500
750
30,000
675
562,500
187,500
67,500
7,500
26,250
18,750
2,250
375
452,625
$ 3,430,429 $ 3,419,603 $ (10,826)
36,412 21,412 75% 182% 20,000
2,237,091 559,341 75% 100% a) 2,237,000
(72,738) 75% 0% b) 96,984
6,470,569 (1,029,431) 75% 65% c) 10,000,000
215,049 8,799 75% 78% d) 275,000
250,458 (12,042) 75% 72% d) 350,000
(7,500) 750/0 0% d) 10,000
(7,500) 75% 0% d) 10,000
994 994 75% n/a -
23,545 (43,955) 75% 26% 90,000
500 (250) 75% 50% 1,000
16,636 (13,364) 75% 42% 40,000
61 61 75% n/a -
(675) 75% 0% 900
2,434 2,434 75% n/a -
234 (562,266) 75% 0% e) 750,000
133,824 (53,676) 75% 54% 250,000
(67,500) 75% 0% 90,000
(7,500) 75% 0% e) 10,000 (10,000)
(26,250) 75% 00/0 e) 35,000
(18,750) 75% 0% e) 25,000
2,366 116 75% 79% 3,000
(375) 75% 0% 500
451,520 (1,105) 75% 75% 603,500
9,841,693 (1,331,720) 75% 66% 14,897,884 13,802,888 (1,094,996)
11,173,413
218,805
150,000
9,030
40,000
2,237,091
9,000,000
375,000
350,000
1,000
93,451
500
20,000
62
2,434
700,000
190,000
90,000
35,000
25,000
3,500
639,850
20,000
91
(96,984)
(1,000,000)
100,000
(10,000)
(10,000)
1,000
3,451
(500)
(20,000)
62
(900)
2,434
(50,000)
(60,000)
500
(500)
36,350
218,805
150,000
- 75%
- 75%°
(9,030) 75%
TOTAL RESOURCES 14,981,677
REQUIREMENTS:
Expenditures
Personal Services 4,314,725
Materials and Services 7,103,267
Capital Outlay 878,768
Transfers Out 300,000
Contingency 1,527,309
TOTAL REQUIREMENTS
NET (Resources - Requirements)
75% 291,740 291,740 -
75% 200,000 200,000
0% 12,040 - (12,040)
13,630,101 (1,351,576) 75% 80%
4,060,015
5,373,461
66,362
254,710
1,729,806
812,406
300,000
1,527,309
75%
75%
75%
750/0
75%
Exp.
71%
57%
6% f)
0%
n/a
14,124,069 9,499,838 4,624,231 75% 50%
857,608 4,130,263 3,272,655
Beginning NWC per Requested Budget
18,832,093 17,714,231 (1,117,862)
5,752,967
9,471,023
1,171,691
400,000
2,036,412
5,611,278
9,153,463
95,000
400,000
141,689
317,560
1,076,691
2,036,412
18,832,093 15,259,741 3,572,352
2,454,490 2,454,490
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
Year End
Budget
Projection
Variance
$ 3,430,429 $ 3,419,603 $ (10,826)
36,412 21,412 75% 182% 20,000
2,237,091 559,341 75% 100% a) 2,237,000
(72,738) 75% 0% b) 96,984
6,470,569 (1,029,431) 75% 65% c) 10,000,000
215,049 8,799 75% 78% d) 275,000
250,458 (12,042) 75% 72% d) 350,000
(7,500) 750/0 0% d) 10,000
(7,500) 75% 0% d) 10,000
994 994 75% n/a -
23,545 (43,955) 75% 26% 90,000
500 (250) 75% 50% 1,000
16,636 (13,364) 75% 42% 40,000
61 61 75% n/a -
(675) 75% 0% 900
2,434 2,434 75% n/a -
234 (562,266) 75% 0% e) 750,000
133,824 (53,676) 75% 54% 250,000
(67,500) 75% 0% 90,000
(7,500) 75% 0% e) 10,000 (10,000)
(26,250) 75% 00/0 e) 35,000
(18,750) 75% 0% e) 25,000
2,366 116 75% 79% 3,000
(375) 75% 0% 500
451,520 (1,105) 75% 75% 603,500
9,841,693 (1,331,720) 75% 66% 14,897,884 13,802,888 (1,094,996)
11,173,413
218,805
150,000
9,030
40,000
2,237,091
9,000,000
375,000
350,000
1,000
93,451
500
20,000
62
2,434
700,000
190,000
90,000
35,000
25,000
3,500
639,850
20,000
91
(96,984)
(1,000,000)
100,000
(10,000)
(10,000)
1,000
3,451
(500)
(20,000)
62
(900)
2,434
(50,000)
(60,000)
500
(500)
36,350
218,805
150,000
- 75%
- 75%°
(9,030) 75%
TOTAL RESOURCES 14,981,677
REQUIREMENTS:
Expenditures
Personal Services 4,314,725
Materials and Services 7,103,267
Capital Outlay 878,768
Transfers Out 300,000
Contingency 1,527,309
TOTAL REQUIREMENTS
NET (Resources - Requirements)
75% 291,740 291,740 -
75% 200,000 200,000
0% 12,040 - (12,040)
13,630,101 (1,351,576) 75% 80%
4,060,015
5,373,461
66,362
254,710
1,729,806
812,406
300,000
1,527,309
75%
75%
75%
750/0
75%
Exp.
71%
57%
6% f)
0%
n/a
14,124,069 9,499,838 4,624,231 75% 50%
857,608 4,130,263 3,272,655
Beginning NWC per Requested Budget
18,832,093 17,714,231 (1,117,862)
5,752,967
9,471,023
1,171,691
400,000
2,036,412
5,611,278
9,153,463
95,000
400,000
141,689
317,560
1,076,691
2,036,412
18,832,093 15,259,741 3,572,352
2,454,490 2,454,490
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
RESOURCES:
Beg. Net Working Capital
Revenues
DOC Measure 57
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance ,FY % , Coll.
$ 616,371 $ 728,649 $ 112,278 100% 118%
162,979
State Miscellaneous 3,226
Alternate Incarceration 23,189
State Subsidy 9.750
SB 1145 2,221,492
Probation Work Crew Fees 28,500
Miscellaneous 2,250
Electronic Monitoring Fee 127,500
Probation Superv. Fees 157,500
Interest on Investments 6,750
Interfund - Sheriff 37,500
Crime Prevention Grant 37,500
CFC -Domestic Violence -
217,350
4,301
30,918
9,980
2,221,492
18,499
3,260
125,665
151,811
6,805
37,500
25,000
18,708
54,371 75% 100% a)
1,075 75% 100%
7,729 75% 100% a)
230 75% 77%
75% 75% b)
(10,001) 75% 49% c)
1,010 75% 109% d)
(1,835) 75% 74%
(5,689) 75% 72%
55 75% 76%
75% 75%
(12,500) 75% 50% e)
18,708 75% n/a f)
Total Revenues 2,818,136
Transfers In -General Fund
2,871,289
86,271 86,271
53,153 75% 76%
- 75% 75%
TOTAL RESOURCES 3,520,778 3,686,209
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
2,379,943
670,706
75
315,962
2,217,670
597,603
165,431 75% 82%
162,273 75%
73,103 75%
75 75%
315,962 75%
TOTAL REQUIREMENTS 3,366,686 2,815,273 551,413 75%
NET (Resources - Requirements)
154,092 870,936 716,844
Beginning NWC per Requested Budget
Exp. %
a) Annual payment received in July
b) Anticipated funding cuts from Dept. of Corrections. Money above opt out
c) Increase in fee waivers from court due to economic conditions
d) Larger number of offenders doing out of state and county transfers
e) Payments received quarterly (Sept, Dec, Mar and June)
f) Intensive Supervision DV grant (Federal grant)
g) Personnel expenditure projected to be less than budgeted due to unfilled positions
70% g)
67%
0%
n/a
63%
Revised
Year End
Budget
Projection
Variance
$ 616,371 $ 728,649 $ 112,278
217,305
4,301
30,918
13,000
2,961,990
38,000
3,000
170,000
210,000
9,000
50,000
50,000
217,350
4,301
30,918
13,000
2,781,990
20,613
4,000
166,000
199,000
9,000
50,000
50,000
56,124
45
(180,000)
(17,387)
1,000
(4,000)
(11,000)
3,757,514 3,602,296
115,029 115,029
56,124
(155,218)
4,488,914
3,173,257
894,274
100
421,283
4,445,974 (42,940)
2,966,580
894,274
206,677
100
421,283
4,488,914
3,860,854 628,060
585,120 585,120
560,000
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY % Coll.
Revised
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 562,762 $ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578
Revenues
Federal Grants 300,125 273,176 (26,949) 75% 68% a) 400,167 413,268 13,101
Title IV - Family Sup/Pres 47,813 49,319 1,506 75% 77% 63,750 63,750 -
HealthyStart Medicaid 71,250 71,972 722 75% 76% 95,000 95,000 -
Level 7 Services 193,488 214,798 21,310 75% 83% 257,984 257,984 -
State Prevention Funds 10,875 7,076 (3,799) 75% 49% b) 14,500 17,000 2,500
HealthyStart/R-S-G 231,693 134,805 (96,888) 75% 44% c) 308,924 263,596 (45,328)
OCCF Grant 453,242 376,943 (76,299) 75% 62% c) 604,323 549,044 (55,279)
Charges for Svcs-Misc 6,000 2,099 (3,901) 75% 26% d) 8,000 4,000 (4,000)
Court Fines & Fees 56,250 59,972 3,722 75% 80% 75,000 78,000 3,000
Interest on Investments 15,000 3,976 (11,024) 75% 20% e) 20,000 8,000 (12,000)
Grants -Private 3,750 (3,750) 75% 0% f) 5,000 (5,000)
Donations 2,357 2,357 75% n/a d) 2,857 2,857
Video Lottery 2,500 2,500 75% n/a d) 2,500 2,500
Miscellaneous 193,916 85,058 (108,858) 75% 33% g) 258,554 118,500 (140,054)
Total Revenues 1,583,402 1,284,051 (299,351) 75% 61% 2,111,202 1,873,499 (237,703)
Trans from General Fund
Trans from GF -Other
Total Transfers In
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
213,250 213,250
18,750 18,750
232,000 232,000
75% 75% 284,333 284,333
75% 75% 25,000 25,000
75% 75% 309,333 309,333
2,378,164 2,151,391 (226,773) 75% 72% 2,983,297 2,818,172 (165,125)
449,669 404,180 45,489 75% 67% h) 599,559 545,878 53,681
1,481,313 987,914 493,399 75% 50% c) 1,975,084 1,805,183 169,901
75 75 75% 0% 100 100
306,416 306,416 75% n/a 408,554 408,554
TOTAL REQUIREMENTS 2,237,473 1,392,094 845,379 75% 47% 2,983,297 2,351,061 632,236
NET (Resources - Requirements)
140,691 759,297 618,606
•
467,111 467,111
Beginning NWC per Requested 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 reduced
e) Interest revenue projected to be less than budgeted
f) Youth conference donations will not be received
g) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received
h) 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
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY %
Coll. 0/0
RESOURCES:
Beg. Net Working Capital $ 392,509 $ 318,001
Revenues
Miscellaneous 21,000
Refunds/Reimbursements -
Franchise 3% Fees 150,000
Commercial Disp. Fees 630,000
Private Disposal Fees 985,500
Franchise Disposal Fees 2,744,250
Yard Debris 54,750
Special Waste 18,750
Interest 9,375
Leases
Sale of Carbon Credits 60,000
Sale of Equip & Material - 100
Recyclables 15,000 32,505
15,976
15
87,525
629,265
955,134
2,994,794
56,442
41,251
6,295
1
Budget
Year End
Projection
Variance
$ (74,508) 100% 81% $ 392,509 $ 318,001 $ (74,508)
Total Revenues 4,688,625
TOTAL RESOURCES 5,081,134
4,819,303
5,137,304
(5,024) 75% 57% 28,000 22,000 (6,000)
15 75% n/a 15 15
(62,475) 75% 44% a) 200,000 200,000
(735) 750/0 75% 840,000 860,000 20,000
(30,366) 75% 73% 1,314,000 1,314,000
250,544 75% 82% 3,659,000 4,000,000 341,000
1,692 75% 77% b) 73,000 73,000 -
22,501 75% 165% c) 25,000 50,000 25,000
(3,080) 75% 50% 12,500 7,500 (5,000)
1 75% n/a 1 1
(60,000) 75% 0% d) 80,000 (80,000)
100 75% n/a e) 100 100
17,505 75% 163% f) 20,000 40,000 20,000
130,678 75% 77% 6,251,500 6,566,616 315,116
56,170 75% 77% 6,644,009 6,884,617 240,608
REQUIREMENTS
Expenditures
Personal Services 1,225,964 1,212,042 13,922 75%
Materials and Services 2,149,372 1,740,109 409,263 75%
Debt Service 727,550 401,732 325,818 75%
Capital Outlay 88,500 48,311 40,189 75%
Transfers Out -Road 218,805 218,805 - 75%
Contingency 572,817 572,817 75%
TOTAL REQUIREMENTS 4,983,008 3,620,999 1,362,009 75%
NET (Resources - Requirements) 98,126 1,516,305 1,418,179
Beginning NWC per Requested Budget
Exp. %
a) Franchise fees are received each April. Wilderness Garbage pays monthly
b) Seasonal material - revenue decreases during Winter
c) Bonneville Power did large clean-up of contaminated soil -unexpected revenue
d) No market at this time. Not expected to market this fiscal year
e) Minor revenue for sale of gate remotes
f) Markets for recyclables varies throughout the year - usually declines during Winter
g) Larger expenditures (i.e. grinding at $75,000) will be made in Spring
h) One item remaining -software being researched
74%
61% g)
41%
41% h)
75%
n/a
1,634,618 1,631,569
2,865,829 2,783,058
970,066 970,066
118,000 115,661
291,740 291,740
763,756 -
3,049
82,771
2,339
763,756
55% 6,644,009 5,792,094 851,915
1,092,523 1,092,523
1,092,508
RISK MANAGEMENT
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
T
Actual
Variance % of FY
Coll.
Budget
Year End
Projection
Variance
RESOURCES:
Beginning Net Working Capital 52,500,000 52,374,541 ($125,460) 100% 95% S2,500,000 $2,374,541 ($125,460)
Revenues
Inter -fund Charges:
General Liability 251,875 251,875 0 75% 75% 335,833 335,833
Property Damage 220,514 220,514 (0) 75% 75% 294,019 294,019
Vehicle 137,033 137,033 (0) 75% 750/0 182,710 182,710
Workers' Compensation 679,771 675,382 (4,389) 75% 75% 906,361 906,361
Unemployment 127,828 127,525 (303) 75% 75% 170,437 170,437
Claims Reimb-Workers' Compensation 22,500 (22,500) 75% 0% 30,000 30,000
Claims Reimb-Gen Liab/Property 15,000 27,450 12,450 75% 137% 20,000 30,000 10,000
Process Fee-Events/Parades 1,125 1,080 (45) 75% 72% 1,500 1,500
Miscellaneous 1,500 (1,500) 75% 0% 2,000 2,000
Skid Car Training 16,500 14,348 (2,152) 75% 65% 22,000 22,000
Interest on Investments 22,500 12,453 (10,047) 75% 42% 30,000 18,000 (12,000)
TOTAL REVENUES 1,496,146 1,467,660 (28,486) 75% 74% 1,994,860 1,992,860 (2,000)
TOTAL RESOURCES
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
3,996,146 3,842,201 (153,945) 75% 85% 4,494,860 4,367,401 (127,460)
Exp.
Settlement / Benefit 48,071
Defense 2,775
Professional Service 6,435
Insurance 155,924
Loss Prevention 726
Repair / Replacement 250
Total General Liability 300,000 214,181 85,819 75% 54% 400,000 300,000 100,000
PROPERTY DAMAGE
Insurance 153,414
Repair / Replacement 14,790
Total Property Damage 225,000 168,204 56,796 75% 56% 300,000 250,000 50,000
VEHICLE
Professional Service 1,839
Insurance 390
Loss Prevention 14,633
Repair / Replacement 52,027
Total Vehicle 90,000 68,888 21,112 75% 57% 120,000 100,000 20,000
WORKERS' COMPENSATION
Settlement / Benefit 498,964
Professional Service 6,250
Insurance 92,722
Loss Prevention 31,439
Miscellaneous 21,987
Total Workers' Compensation 487,500 651,362 (163,862) 75% 100% 650,000 800,000 (150,000)
UNEMPLOYMENT - SettlemenUBenefits 120,000 187,888 (67,888) 75% 117% 160,000 320,000 (160,000)
Total Direct Insurance Costs 1,222,500 1,290,524 (68,024) 75% 79% 1,630,000 1,770,000 (140,000)
Insurance Administration:
Personal Services 217,090 215,128 1,962 75% 74% 289,453 289,453
Materials & Service 171,626 129,115 42,511 75°/ 56% 228,834 228,834
Capital Outlay 75 - 75 75% 0% 100 - 100
Total Insurance Administration 388,790 344,243 44,547 75% 66% 518,387 518,287 100
Contingency 1,759.855 1,759,855 75% n/a 2,346,473 2,346,473
TOTAL REQUIREMENTS 3,371,145 1,634,767 1,736,378 75% 36% 4,494,860 2,288,287 2,206,573
NET 625,001 2,207,434 1,582,433 - 2,079,114 2,079,114
Beginning NWC per Requested Budget 2,100,000
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
% of FY
% Coll.
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 5,861,335 $ 6,691,945 $ 830,610 100% 114% $ 5,861,335 $ 6,691,945 $ 830,610
Revenues
Property Taxes - Current 4,768,216 5,911,848 1,143,632 75% 93% 6,357,621 6,357,621
Property Taxes - Prior 103,500 240,657 137,157 75% 174% 138,000 240,657 102,657
Federal Grants 355,500 191,378 (164,122) 75% 40% a) 474,000 474,000
State Reimbursement 7,500 12,439 4,939 75% 124% 10,000 20,921 10,921
Telephone User Tax 412,500 428,527 16,027 75% 78% b) 550,000 550,000 -
Data Network Reimb. 9,000 25,620 16,620 75% 214% c) 12,000 26,672 14,672
Jefferson County 23,250 35,388 12,138 75% 114% 31,000 35,388 4,388
User Fee 37,500 50,182 12,682 75% 100% d) 50,000 52,340 2,340
COPS Reimbursements 22,500 (22,500) 75% 0% e) 30,000 - (30,000)
Contract Payments 52,500 32,134 (20,366) 75% 46% 70,000 32,134 (37,866)
Miscellaneous 6,375 10,071 3,696 75% 118% 8,500 10,071 1,571
Interest 30,000 38,258 8,258 75% 96% 40,000 50,000 10,000
Interest on Unsegregated Tax 1,500 659 (841) 75% 33% 2,000 800 (1,200)
Total Revenues 5,829,841 6,977,161 1,147,320 75% 90% 7,773,121 7,850,604 77,483
TOTAL RESOURCES 11,691,176 13,669,106 1,977,930 75% 100% 13,634,456 14,542,549 908,093
REQUIREMENTS:
Expenditures
Personal Services 3,006,599 2,711,241 295,358 75% 68% 4,008,798 3,758,798 250,000
Materials and Services 1,143,108 907,742 235,366 75% 60% 1,524,144 1,524,144
Capital Outlay 1,322,250 1,030,913 291,337 75% 58% a) 1,763,000 1,763,000
Transfers Out 760,546 1,014,061 (253,515) 75% 100% 1,014,061 1,014,061
Contingency 3,993,340 3,993,340 75% n/a 5,324,453 5,324,453
% Exp.
TOTAL REQUIREMENTS 10,225,843 5,663,957 4,561,886 75% 42% 13,634,456 8,060,003 5,574,453
NET (Resources - Requirements) 1,465,333 8,005,149 6,539,816 - 6,482,546 6,482,546
Beginning NWC per Requested Budget 6,400,000
a) Federal Grant DHS/ODOT CAD Project $474,000 of which $60,000 is expected by early May
Capital Outlay: Software $35,000 CAD Project (funded by Fed Grant) $474,000, Network Upgrade $24,000, CAD Mapping Project
$30,000 ($120,000 expected by early May), Records Management System $1.2 million
b) Received quarterly (Nov, Feb, May and Aug) for fiscal year
c) Annual billings to agencies underbudgeted. One more payment of $1,052 is expected
d) Crooked River Ranch paid annual fee of $45,869. Expect one more US Forest Service payments of $2,156 by June 30
e) Revenue not expected this fiscal year
RESOURCES
Beg. Net Working Capital
Revenues:
Internal Premium Charges
P/T Emp - Addi 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-Dental/Vision
Refunds
Insurance Expense
State Assessments
Administration Fee
PPO Fee
Health Impact
Deschutes Onsite Clinic:
Healthstat
Equipment
Remodel
Miscellaneous
Health Benefits Trust
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
$ 16,400,000 $ 16,988,140 $ 588,140 100% 104%
8,434,500
37,500
375,000
731,250
337,500
75,000
8,556,952
34,012
366,445
1,076,592
541,449
93,496
69,944
86,100
Revised
Budget
Year End
Projection
Variance
$16,400,000 $16,988,140 588,140
122,452 75% 76% a) 11,246,000
(3,488) 75% 68% 50,000
(8,555) 75% 73% 500,000
345,342 75% 110% 975,000
203,949 75% 120% 450,000
93,496 75% n/a
69,944 75% n/a
11,100 75% 86% 100,000
Other
Total Materials & Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
9,990,750 10,824,990
11,400,359
43,000
485,000
1,400,000
700,000
93,496
69,944
114,000
154,359
(7,000)
(15,000)
425,000
250,000
93,496
69,944
14,000
834,239 75% 81% 13,321,000 14,305,799 984,799
26,390,750 27,813,129 1,422,379 92%
96,960 92,327
9,337,646 9,108,390.53
1,403,533 1,315,117.69
(65,433)
247,500 252,036
56,250 124,832
225,000 225,283
30,000 31,824
38,250 38,463
172,140
10,875
85,125
46,425
113,356
73,878
32,114
119,717
34,443
30,261
94% 29,721,000 31,293,939 1,572,939
Exp.
4,633 75% 71%
229,255
88,415
65,433
(4,536)
(68,582)
(283)
(1,824)
(213)
98,262
(21,239)
(34,592)
11,982
83,095
11,766,099
100
10,427,616
11,320,926
445,173
100
10,427,616
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
73% b)
70% b)
n/a
76%
166%
75%
80%
75%
32%
221%
105%
56%
20%
72%
0%
0%
129,280 129,280
12,450,194
1,871,377
330,000
75,000
300,000
40,000
51,000
229,520
14,500
113,500
61,900
151,141
12,144,521 305,673
1,753,490 117,887
(65,433) 65,433
330,000
124,832 (49,832)
300,000
40,000
51,000
229,520
32,114
119,717
61,900
56,141
(17,614)
(6,217)
95,000
15,688,132
100
13,903,488
15,177,802
510,330
100
13,903,488
22,290,775 11,413,253 10,877,522 75% 38% 29,721,000 15,307,082 14,413,918
NET (Resources - Requirements) 4,099,975 16,399,876 12,299,901
Beginning NWC per Requested Budget
15, 986, 857 15, 986, 857
a) Year End Projection is amount appropriated in operating departments' budgets.
b) Projection based on annualizing 39 weeks of claims paid. YTD actual is an average of $265,592 per week.
15,500,000
Year to Date
Budget
Actual Variance
FY % Coll.
$ 16,400,000 $ 16,988,140 $ 588,140 100% 104%
8,434,500
37,500
375,000
731,250
337,500
75,000
8,556,952
34,012
366,445
1,076,592
541,449
93,496
69,944
86,100
Revised
Budget
Year End
Projection
Variance
$16,400,000 $16,988,140 588,140
122,452 75% 76% a) 11,246,000
(3,488) 75% 68% 50,000
(8,555) 75% 73% 500,000
345,342 75% 110% 975,000
203,949 75% 120% 450,000
93,496 75% n/a
69,944 75% n/a
11,100 75% 86% 100,000
Other
Total Materials & Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
9,990,750 10,824,990
11,400,359
43,000
485,000
1,400,000
700,000
93,496
69,944
114,000
154,359
(7,000)
(15,000)
425,000
250,000
93,496
69,944
14,000
834,239 75% 81% 13,321,000 14,305,799 984,799
26,390,750 27,813,129 1,422,379 92%
96,960 92,327
9,337,646 9,108,390.53
1,403,533 1,315,117.69
(65,433)
247,500 252,036
56,250 124,832
225,000 225,283
30,000 31,824
38,250 38,463
172,140
10,875
85,125
46,425
113,356
73,878
32,114
119,717
34,443
30,261
94% 29,721,000 31,293,939 1,572,939
Exp.
4,633 75% 71%
229,255
88,415
65,433
(4,536)
(68,582)
(283)
(1,824)
(213)
98,262
(21,239)
(34,592)
11,982
83,095
11,766,099
100
10,427,616
11,320,926
445,173
100
10,427,616
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
75%
73% b)
70% b)
n/a
76%
166%
75%
80%
75%
32%
221%
105%
56%
20%
72%
0%
0%
129,280 129,280
12,450,194
1,871,377
330,000
75,000
300,000
40,000
51,000
229,520
14,500
113,500
61,900
151,141
12,144,521 305,673
1,753,490 117,887
(65,433) 65,433
330,000
124,832 (49,832)
300,000
40,000
51,000
229,520
32,114
119,717
61,900
56,141
(17,614)
(6,217)
95,000
15,688,132
100
13,903,488
15,177,802
510,330
100
13,903,488
22,290,775 11,413,253 10,877,522 75% 38% 29,721,000 15,307,082 14,413,918
NET (Resources - Requirements) 4,099,975 16,399,876 12,299,901
Beginning NWC per Requested Budget
15, 986, 857 15, 986, 857
a) Year End Projection is amount appropriated in operating departments' budgets.
b) Projection based on annualizing 39 weeks of claims paid. YTD actual is an average of $265,592 per week.
15,500,000
RESOURCES:
Beg. Net Working Capital
Receipts:
Special Events Revenues
Interest
Storage
Camping at F & E
Horse Stall Rental
Concession % - Food
Rights (Signage, etc.)
Interfund Contract
Miscellaneous
Total Receipts
Transfers In
General Fund (001)
Room Tax (160)
Welcome Center (170)
Annual County Fair (619)
Reserve Fund (617)
Total Transfers In
TOTAL RESOURCES
Deschutes County - Fair and Expo Center
YTD -Budget Basis Commissioners
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY
Coll.
$ 2,809 $ 6,590
$ 3,781 100%
235%
Year End
Budget
Projection
Variance
$ 2,809
$ 6,590 $ 3,781
508,307 485,711 (22,595) 75% 72% 677,742 638,711 (39,031)
1,500 633 (867) 75% 32% 2,000 1,133 (867)
38,250 22,677 (15,573) 75% 44% 51,000 39,677 (11,323)
6,750 3,312 (3,438) 75% 37% 9,000 9,312 312
31,500 2,040 (29,460) 75% 5% 42,000 36,040 (5,960)
158,250 150,263 (7,987) 75% 71% 211,000 186,262 (24,738)
69,750 41,738 (28,013) 75% 45% 93,000 116,738 23,738
33,750 (33,750) 75% 0% a) 45,000 45,000
3,311 26,018 22,708 75% n/a 4,414 27,218 22,804
851,367 732,391 (118,976) 75% 65% 1,135,156 1,100,092 (35,064)
148,438
18,654
60,001
173,424
75
148,438
18,654
60,001
166,000
75%
75%
75%
(7,424) 75%
(75) 75%
400,592 393,093
1,254,768 1,132,075
REQUIREMENTS:
Expenditures:
Personal Services 698,920
Materials and Services 357,514
Debt Service 86,672
Capital Outlay 75
636,537
412,872
72,061
(7,499)
(122,693) 75%
62,383
(55,358)
14,612
75
Total Expenditures 1,143,181 1,121,469 21,711
Transfers Out - Reserve Fund 7,500 10,000
Contingency 103,386 - 103,386 75% n/a
75%
75%
75%
75%
75%
75%
75%
72%
0%
197,919
24,873
80,000
b) 231,232
100
197,919
24,873
80,000
166,000
100
(65,232)
534,124 468,892 (65,232)
68% 1,672,089 1,575,574 (96,515)
Exp. %
68% 931,893
87% c) 476,685
62% 115,563
0% 100
(2,500) 75% 100%
858,112 73,781
546,042 (69,357)
115,563 -
100
1,524,241 1,519,717 4,524
10,000 10,000
137,848 - 137,848
TOTAL REQUIREMENTS 1,254,067 1,131,469 122,597 75% 68% 1,672,089 1,529,717 142,372
NET (Resources - Requirements) 701 605 (96)
Beginning Net Working Capital per Requested Budget
45,857 45,857
75,000
a) Interfund contract revenue is for park maintenance, from Fund 130 and will be received by year end.
b) Cash flow from Fair 2010 was S65,000 less than budgeted
c) Year to date amounts include costs associated with BMW and FMCA events and expenditures for HVAC repairs. An increase
to the Materials & Services category will be made via resolution, when required.
JD
c
•
Secure Treatment Facility
•
Bethlehem Inn
•
PROJECTION
-J
D
1-
U
Encumbrances
& Commitments
Received and
a)
c
a)
Q
X
RESOURCES:
(- (VO (D CO N- 6) (- i.13' N ,- M CO
O O)
N O Q c0 6) (0 c0 N N- CO N-
a) (- 00 N- N 1- CO O ,- CO co O co
O N. co- (D (O - O c0 O co-
,-
c M r O
N
N
- c)
Lo N
O
O O
O O
O O
O O
LO
N 1-
(.6
N-
N
LO N
N
O
1-
CO
M
(O
O
O
O
O
0)
M
1-
00
00
CO.
Total Resources
EXPENDITURES:
Materials & Services
M- N- (0 N Cr) co O (D
6) c0 c0 N- (0 N M
0) (- N c N- co(.0 O (0 (0 N -
C6 (S (D M 1.(7 M N. O
N M (-
O
CO (D
CO LC)
LO
(D V
O
O
O (l7 O
co O
O
N
V CO N (0 N 0) M V' O (0
O V' CO CO N- () N N- CO
0) (� N c0 r- co (0 O - (O (O r -
M (� (D co-- (n - 00 (. O
N M N-
U7
0)) V CO CO M N O CO O CO
O (� N CO N- CO (0 O ,- (D (0 N-
N M (-
U7
c)
M
(D
O)
CO
(D
O
Q)
CO
O
N
CO
CO
U7
1
N d
a)
(A 0 U d
U Z 2 a) U)
c O U _, -O
a) N
E > M c
v) v) a) ? (p O
a) a) � 06 7
U (9 N a 1: .0
c a) U E Q) U U (9 m N
(n o a) .E w c
U a) m-0 c a52 - O O S O
a) a) c .0 f9 r c N O (C U
QWHac cLL<cL 0 cZ
U
Transfer Out
O
N
c0
st
U7
M
M
O
O
00
00
05
M
N
U -CD-0 6-
M (0 73
U7 c
"° '° "° Q
CCX
7 7 7 W
LL LL LL
To
0
0)
z
Based on the architect's computation, this
O
O
N
0) ›-
U_ LL
a
M (c9 (D
"O O O
c O N
(9 O >-
CL N LL
} L
O LL a)
a O
a
(n c
(9 7
3 LL O
E }
Q) 2 LL
(9 ° N
(9 7
0- - E Tr
U) O ,,, c9 =
0 o0 Cl o
N ° T a) co
in c (9 J c
o ca Qa =a
m
ou)•`000
w
E \ u O U
o v) N
UCID m. (I)
O O a X
(1) a
c -° c
o a) o ,c
i
2a) a) LL
C c U
O L a) ' j N
(9 U E a) .O
f9 c N u) a
+r N 7 Z)
c - _a a) (U
c .E O
o 03 m
HrCCLL0
c U "°
O
CO
V'
• C
• CN
C L
C � r
o c')
U U L
(1) O U
O O (9
m m
CL)
`
o @ O
U L
CT)
PROJECTION
a)
U
C
0
O
H
U �
a) c)
• O
a m
C
c) a)
c a) 0
0
-'
D )
o
a
u) 0O
< 0
RESOURCES:
c) N CO CO
CO R 0 N -
c•) 1- CO- M
(n CO CO 0
V CO
Cc)
O N 0 N
O O O (D
O N O N
O N Lo -
Lo 1,- CO CO
N O O
R 1 (D
CO N CO CO
O V O
( ) N- CO M
(n N CO 0
N V CO
V (D
CO N CO CO
O V O
c) N— CO' M
(n CO CO 0
N V CO
0
U
a)
U
C
(6
0
U)
C
U
Q) C
a)
o O
CL
D a)
c 0
O a)
00 (L
a�
c
Total Resources
EXPENDITURES:
O N O- 1- N (D CO CO O) O) O
N O) CO V O) 1,- Nr O co co N
CO N O V O O N CO 0 0 (f)
N ,- (n N c•) N ((7 1- (D
O V O
O (D O N V (V CO N CO O) O) O
O 1� O) CO c') Cr) N- 1)) O) CO CO CO
CO N O V N O N O O) -4-
a;
O O (t7 N(.4 (h N ((7 1: O
N N
O CO
O O)
O 'Cr
O (f)
N
O 1- O O
O co O O
O O O
N O O ,--
N (f)
O
O
O
000 V N O N co 0)a)0
O 1� O) CO c•) O) N- (n o) co co co
CO N O V N O N O' O O) V
O) O (6 N N c•)(.4 ((7 O
M
O
O)
N
((7
c)
co
co
O
(t7
(f)
CO
CO
N
O)
c)
c)
co
co
(f)
(t7
(D N O) f -
Q) (n N
CO V CO a -
r) (n
O CO
O
r --
r--
-1-- (D
1,7
(n N
Off) CO
(n Q)
O c)
O M
cci
O O
O (D
ri ri
Based on the architect's computation, this
((7
N
N
N
CO
EA)
c)
C
O
p -0
C
o f� O
O CVo
CO O CO
N L
U • CO
- EA) (9
O 1- Cr) CO CO c) 1- U) 0) CO CO CO O CO C) '0 0 c)
CO N O V N O N O'- O O) R O CO co N. C
O) O (f) c.i. N CO' (.4 (f) N- O (f) O (D (D c9 • O
N' N V V CO 0 C) a 7 w L
c•) ((7 O co ,- cr) (/)
r) M p
a)
0 >
Oco ? U
N
O N C O E >-
c
c a N N
o (/) O C
CA E O -c U
cn m E o (a
a) -
U o o O c
U ---:-> U co o
O Z° a) -al u) c ° 1.0 E
C Q U O -o a) 0
v) c) U ., •N 4) ;2a)
To
0 U En
o N • a LL - •7. V U O L E T
(/) L a) co (0 U • C
a)
4) c O U m O ,U co m co N C O
m MC C ca m nO ° o oO(n O. .E a) o
c .c c (9 c o m O U � 1:3
x c c
• m > c= c r o m 3 v W • r@ (9
77)a) -2-45'''P._(1) m� F- a) c� m 1-L p •(-5,
m<un- a c c li<dJ2O mZcn m p a)
U F- 1- Z (0
c) Balance in Fund will be transferred to Debt Service fund for the benefit of Deschutes County 911.
Deschutes Cou
0)
C
0
U
T
0)
O
U
0)
N
U (..0
cn
L `
0
T2
L
U o)
(0 7
LL O
C L
0) I-
la (0
0
H
0
U
0)
(n
PROJECTION
co
C_
LL
U C
O 0)
O
d
CO
O
U
(0
(n
C C
U 4)
E
E
E
c U
W
RESOURCES:
cc) O
(p r) O O
' v- O
I: O N
O
N
V O c'') O V
C) O c'') O O
O O O
11) O N N v -
O 11) N
N r -
O O O 0
O O O O
O O O O
CO- O N O
119f) U0
(0
O M 0 -
M O M O O
O O O
11) O N N v -
(O 1() N
N r-
0
M
C
O
1f7
O
11'7
O
N
O
O
O
1f7
N
co
N
V O M 0 V O
CO O CO O O h
O O T O V 11)
11) O N N 1- O
(O 11) N u
I-
N
EXPENDITURES:
N V r- O) - r) O) O N O
O O Q) O V (O (O 0-
00 U0 v- 0- ' OD O N O O
V N N O N I- r) N
N V r- co r) N r) Q) N N co (9
O O Q) (9 co r) (p N (p
O u) v- r- c'') co co N O 00 N
OL.6r5r r5 v2 CNQ)
O c) O
O O O r) O O (p
O O O (p Q) O O Q)
O O O ' 00 N O ' O
I: Q) N 11) O u
O O . Q) (O Q) V (V) (p N (p
O 11) T- r- M O O N'- O M N
V O 11) C) C) C) N Q)
O co O
r- Q) N N (o co N N Q) (O
O O Q) (p Q) M (O N (O
O 11) I- M O O N v- O M N
V O 11) M M r) v N Q)
O M .- O
N
CO
O
O
r)
N
O
1)
r -
u)
LD l()
O (9
CO CO
CO CO
co
V
O
O
O
M
O
(9
O
O
O
M
O
(9
r)
Q)
0
0
0
r -
O
IL7
M
CO
N
O
1[Y
O
11'7
O
N
O
O
O
11.7
N
N
(D
CO
pS
11)
CO
ID
C
(nE a) 0)
V
U0) CC > _O
(n O E 0 Zr, T U
0 Z_ y la O
.V m ca O' a) 3
a) o) °, m c 2 y c LL c
(0 (D w d C V) •la _C w C •E w
o U1 C L (0 a) C E U
7 .0 4) U 0 c E 2 is m .O �% c 0 C C
is to aa)) amici c o) d m . (n o ' __ O ` ID
U O (n o
07 L .E• (0 c t V) .S •� p > :� in o to W
Z.
n- c c a)-- a) .0 w FO- '� 0 O FO- c H is
(0 <LL1 W J0 5 LLd<D2H DUH co 0 y
0 f- 1- Z
ui
(h
O
O
u)
- U
O
oa
O
U
O w
U
(0
7 (0
cn
(13
(D
C (n
(0 b
11) 0)
aCO
C O
O
N
(i) 1-
77 7
C C
O 7
LL.
C
O (n
U
0 O
U N
O
O
O
0 C
O 7
O
N U
M _D
(n O)
C >
O o
i
O 0)
O U
7 C
(0
coCL
O
U O
C U
O
(1) M
.� M CO
0 N co
w N
(O Ef) N
U _ N
+
_c C
O 0-
O
U
(n CO
(1) N
0) Q
cr O
0 cc
`O < O
a (9
O 7
(0 0
O
O
c
LL
a) cn
U w
a) f—
o 2
a
0
(U
a)0
Z
L Q
a)
0 W
U
Z
Q
ct
m
LL 2
c
Z
W
i0
4)
1-
a)
0
a)
(1)
a)
U
c a)
(0
(0 0
C12
Amount Paid
0
CI.
U
a)
0
O N-
O CO O N—
CO O
CO O O)
co
N
O O N N. O CO 0) CO 0) CO CO N. N N,— O O)
10 CO 0) O N. O) CO CO V O CO 10 V O 0) co
co O ,— Lti O Cr) V O) CO O) CO CO ) O CO 00 O
CM O O) (-- V N V O M V (� O) - (-- O
N CO O) ,— N N N N N —
•4--
CO
N
a)
CD
(0
>, c
co CD
cn (n c
a) Y a) .O
O c n. >^ c
0 a) = c
a) a) x3 L c O a) c0 E
O • (0 U •Y •• _ - N C) U a)
O -• 0)io c0' a)L o `
d >,� a) U 0 0
ED
• L (n - = >
CD c
a) , c0 a) U c 7_-
O
cn
(n U) V (n O ' C >
U a) V U) c0 a) d O Q U = a) U)
O - O
CD CD
` O O U ▪ •O V,- a) a) O d`
(n a) U) U E 0 c i0 (c_ (n �o c o • a)
(0 Cr) d c 7:0
'n c0 a) `
(0 c. c (n > O D ▪ O c (n - n. c
c (n •c ac(/) • c E (0 c, diTOL•a_
U c a) (0 7 (0 a) L - (0 c CO O •� T T
c
c a1) c c on_ = U Q E (o U aoi (o (o
QW J 0 < 0 • Li U D 2 I r 0_ 0 2 U) cn W
CD 4)
7 7
U U
a) a)
L
< Q
a) a)
U U
(0 (0
c c
c c
▪ 0
Pinnacle Architecture
T
a
c
a) N
O O —
7 `
i >, It It 4# • I▪ t It It It It It It - It It
°) .c a) a) a) a) m a) m m m m m a)
L .- 7 (/) 'D -o 'O 'O •o "O 'O •o 'o 'o 'O •o
Q
7 D 0 0 0 0 0 0 0 0 0 0 0 0
F-- = a) a) a) a) a) (1) m a) (1) a) m a)
a c c 5 a) co a) m co Q) o) o) co co co a)
0 0 0 m c c c c c c c c c c c c
(0 (n U)(0 (0 (0 (0 (0 (0 (0 (0 (0 (0 (0 (0
c c 5 L L L L L L L L L L L L
c (o o 0)00 0000000000
o_ 0 < 2
O
O
O
Total HSW Builders
Deschutes County
Bethlehem Inn (Fund 128)
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY
Coll. %
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ (2,725,000) $ (2,722,510) $ 2,490 100% 100% $ (2,725,000) $ (2,722,510) $ 2,490
Revenues
Grants - Private
Lease Payments
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service:
Interest Expense
Interest Payment
2,145,750 - (2,145,750) 75% 0% 2,861,000 - (2,861,000)
20,340 20,340 75% N/A 24,408 24,408
2,145,750 20,340 (2,145,750) 75% 1% 2,861,000 - (2,861,000)
(579,250) (2,702,170) (2,143,260) 75% -1987% 136,000 (2,722,510) (2,858,510)
Exp. %
27,000 14,532 12,468 75% 40% a) 36,000 20,000 16,000
75,000 75,000 75% 0% 100,000 100,000
TOTAL REQUIREMENTS 102,000 14,532 87,468 75% 11% 136,000 100,000
NET (Resources - Requirements) (681,250) (2,716,702) (2,055,792) b) - (2,722,510) (2,758,510)
a) Interest on March 2011 negative cash balance ( $2,732,974.83) = $1,398.98.
b) Innception through March 31, 2011
Revenues - Lease Payments $ 20,340
Expenditures:
Land/Building (Amertitle) - July 2007 2,241,313
Hickman Williams 17,578
City of Bend - May 2008 250,000
KN EX CO 5,289
Kleinfelder 3,732
Total expended on facility 2,517,913
Interest on Negative Cash Balance 219,129
Total expended 2,737,042
Net $ (2,716,702)
Deschutes County
Summary - Expenditures Compared to FY 2011 Budget
FY 2011 Appropriations - M&S and Capital Outlay
Expended to date in FY 2011
Remaining Appropriation
Balance Due on Contracts
Remaining Appropriation after contracts paid in full 39,040 601,135 640,174
FY 2011 Expenditures for other activities (a) 52,210 586,355 638,565
Remaining Appropriation after Contracts/Other (13,170) 14,780 1,610
Additional Appropriation in
Contingency and Reserve for Future Expenditures 274.011 551.196 825,207
"Area A"
"Cell 5"
Landfill
Closure
Fund 611
SW Capital
Projects Fund
613
Total
817,210 2,538,638
436,648 1,806,022
380,562 732,616
3,355,848
2,242,670
1,113,178
341,522 131,482 473,004
a) Fund 611 FY 2011 Expenditures for other activities through March 31, 2011 are
interfund loans totalling $52,210 for the Humane Society of Redmond.
An appropriation transfer will be made prior to the end of the fiscal year.
Deschutes County - Solid Waste
Area A Closure and Cell 5 Construction
As of March 31, 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 March 31, 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
Change Order #2
Change Order #3
Change Order #4
Change Order #5
Change Order #6
Meet CEC requirements, increase to electrical panel,
Storm sewer realignment due to refuse encountered
Revise valve vaults for improved efficiencies
Add! cover material from what will be Cell 6
Environmental controls building, pump station bulkheads
Adjustment to pipe alignment to increase slope
Change Order #7 (not likely to occur)
Change Order #8
Change Order #9
Change Order #10
Change Order #1 1
Change Order #12
Change Order #13
Change Order #14
Damages
Total Contract
Amount Paid
Through June 30, 2010
July 1, 2010 through March 31, 2011
Balance Due
Additional rock to be set aside for future needs
Manhole covers below grade to meet Road Dept requirements
Modular Block Wall instead of MSE Wall
Upgrade of cables (pump and leachate)
Leachate Line connection from Cell 5 to Cells 3 & 4
Additional cover material due to settling
Well modification, flow meter less LFG vaults
Total of Engineering and Construction Contracts:
Original Contracts
Change Orders and Damages
Total Contract
Amount Paid
Through June 30, 2010
July 1, 2010 through March 31, 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
2,422,374.74
45,095.00
148,958.89
204,700.00
5,167.76
2,200.00
6,354.75
(35,000.00)
3,929,998.22
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)
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,169,987.37
436,648.19 1,806,021.53 2,242,669.72
341,522.11 131,481.75 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.
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Travel Expenditures
and
BOCC - County College Expenditures
FY 2011
BOCC Conference & Travel
Tammy Baney
Conf/Sem & Educ/Training
Travel Meals
Accommodations
Mileage reimbursement
Ground Transport/Parking
Total Baney
Dennis Luke
Conf/Sem & Educ/Training_
Travel Meals
Accommodations
Mileage reimbursement
Ground Transport/Parking
Total Luke
Alan Unger
Conf/Sem & Educ/Training
Travel Meals
Accommodations
Airfare
Mileage reimbursement
Ground Transport/Parking
Total Unger
Tony DeBone
Conf/Sem & Educ/Training
Accommodations
Mileage reimbursement
Total Other
Total - BOCC Department
Conf/Sem & Educ/Training_
Travel Meals
Accommodations
Airfare
Mileage Reimbursement
Ground Transport
Total - BOCC Department
FY 2011 Budget
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb Mar YTD Total
305 45 75 150 46.5 15 1,055
20 - 150 55 - - 225
77 429 - 127 254 1,699 - 2,586
240
255 306 297 - 1,098
- - 27 60 - 87
337 989 45 685 816 2,164 15 5,051
56
77
282
17
432
- 305 - -
37 25 74 32 -
76 506 85 (214) -_
178 190 211 148 61
292 1,025 370 (34)
- - 305
225
529
1,069
17
- -- - 2,146
1,133
1,133
305
198
1,414
372
29
2,317
45 -
45 -
30 -
32
362
575 -
998
15 395
230
1,776
1,133
947
- - 29
15 4,509
536
350 -
- (107)
122
45 - 65 460
- - - 429
- 154 179 454
536 350 14 45 154 244 1,343
Percent of FY 2011 Budget Expended
- - 610 3.95 75 225 465 95 2,215
76 37 25 74 182 87 - - 680
154 76 1,470 85 (195) 616 1,699 - 5,320
- - - - - - - - 1,133
522 178 445 211 454 933 1.54 179 3,568
17 27 60 - -133
769 292 2,550 765 544 1,921 2,318 274 13,048
19,600
66.6%
BOCC County College
Public Information
Office/Copier Supplies
Meeting Supplies
1,874
33
295
65 52
930 828 -
2,202 995 880 -
1,874
150
2,053
4,077
4/5/2011
Building Services - 620
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY %
0011. %
RESOURCES:
Beg. Net Working Capital $ 310,000
Revenues
Cleaning/Maintenance 67,509
Utility Reimbursement 6,225
Facilities Charge to State 133,497
Miscellaneous
Interest on Investments 5,250
Grants -
Building Svcs Indirect Chgs 1,493,425
Total Revenues 1,705,906
Transfers In 58,444
Budget
Year End
Projection
Variance
$ 371,047 $ 61,047 100% nia $ 310,000 $ 371,047 $ 61,047
63,983
3,545
116,680
3,827
2,439
5,800
1,493,422
1,689,695
232,444
(3,526) 75% 71% 90,012 90,012
(2,680) 75% 43% 8,300 8,300
(16,817) 75% 66% 177,996 177,996
3,827 75% n/a 3,827
(2,811) 75% 35% 7,000 3,300
5,800 75% n/a 5,800
75% 75% 1,991,229 1,991,229
(16,208) 75% 74% 2,274,537 2,280,463
174,000 75% 298% 77,925 251,925
TOTAL RESOURCES 2,074,350
REQUIREMENTS:
Expenditures
Personal Services 1,245,152
Materials and Services 589,933
Capital Outlay 4,500
Contingency 157,262
3,827
(3,700)
5,800
5,926
174,000
2,293,186 218,839 75% 86% 2,662,462 2,903,435
1,243,162
604,670
Exp. °Ao
1,989 75% 75°fo
(14,737) 75% 77%
4,500 75% 0%
157,262 75% 0%
TOTAL REQUIREMENTS 1,996,847 1,847,832
NET (Resources - Requirements)
1,660,202
786,577
6,000
209,683
1,660,202
786,577
6,000
240,973
209,683
149,015 75% 69% 2,662,462 2,452,779
77,503
445,355 367,854
209,683
450,656
450,656
Beginning Net Working Capital per Requested Budget 424,000
Admin Services - 625
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 120,000 $ 70,480 $ (49,520) 100% n/a $ 120,000 $ 70,480 $ (49,520)
Revenues
Miscellaneous 46 46 75% n/a 46 46
Interest on Investments 578 704 126 75% 91% 770 770
Admin Dept Indirect Chgs 661,304 661,394 90 75% 75% 881,738 881,738
Total Revenues 661,881 662,143 262 75% 75% 882,508 882,554 46
Transfers In -General Fund 30,000 152,000 122,000 75% 380% 40,000 162,000 122,000
TOTAL RESOURCES 811,881 884,623 72,742 75% 85% 1,042,508 1,115,033 72,525
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
634,340 626,283 8,058 75% 74% 845,787 845,787
86,995 49,781 37,213 75% 43% 115,993 85,993 30,000
75 - 75 75% 0% 100 - 100
60,471 - 60,471 75% 0% 80,628 - 80,628
TOTAL REQUIREMENTS 781,881 676,064 105,817 75% 65% 1,042,508 931,780 110,728
NET (Resources - Requirements) 30,000
208,559 178,559
183,253 183,253
Beginning Net Working Capital per Requested Budget 183,000
RESOURCES:
Beg. Net Working Capital
Revenues
Sale Map Photo or Copies
Interest on Investments
Donations
Admin Dept Indirect Chgs
Total Revenues
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
NET (Resources- Requirements)
BOCC - 628
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Budget
Year End
Projection
Variance
$ 100,000 $ 95,210 $ (4,790) 100% nla $ 100,000 $ 95,210 $ (4,790)
113 40 (73) 75%
525 511 (14) 75%
1,453 1,453 75%
270,615 270,652 37 75%
271,253 272,656 1,404 75%
90,000 90,000 75% n/a
27% 150 150
73% 700 700
N/A 1,453
75% 360,820 360,820
75%
371,253 457,867 86,614 75%
253,158
72,673
75
20,347
249,341
80,597
3,817
(7,924)
75
20,347
75%
75%
75%
75%
99%
Exp. %
74%
83%
0%
0%
346,253 329,938 16,315 75% 71%
25,000 127,928 102,929
1,453
361,670 363,123
1,453
90,000 90,000
461,670
337,544
96,897
100
27,129
548,333 86,663
337,544
96,897
100
27,129
461,670 434,441
27,229
113,892 113,892
Beginning Net Working Capital per Requested Budget 115,000
RESOURCES:
Beg. Net Working Capital
Revenues
Investment Fee
Photo copies
COLES/CODE Contract
Interest on Investments
Interfund Contracts
Administrative Fee
Finance Dept Indirect Chgs
Total Revenues
Transfers In - General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Finance - 630
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Budget
Year End
Projection
Variance
$ 500,000 $ 573,333 $ 73,333 100% n/a $ 500,000 $ 573,333 $ 73,333
60,000
4,085
9,000
15,000
9,000
620,906
717,990
34,265
(25,735) 75%
178 178 75%
(4,085) 75%
(6,060) 75%
0 75%
75%
85 75%
(35,616) 75%
223,000 75%
2,940
15,000
9,000
620,990
682,374
223,000
43%
n/a
0%
25%
75%
75%
75%
71%
n/a
1,217,990 1,478,706 37,716 75% 101%
Exp. %
650,093 620,410 29,683 75% 72%
204,033 188,733 15,300 75% 69%
7,500 7,500 75% 0%
231,365 231,365 75% 0%
1,092,990 809,143 283,847 75% 56%
125,000 669,563 321,563
Beginning Net Working Capital per Requested Budget
a) Will be paid in June 2011.
80,000
5,446
12,000
20,000
12,000
827,874
45,000
178
5,446
4,000
20,000
12,000
827,874
(35,000)
178
(8,000)
957,320 914,498 (42,822)
223,000 223,000
1,457,320 1,710,830
866,790
272,044
10,000
308,486
866,790
272,044
30,510
10,000
308,486
1,457,320
1,138,834 318,486
571,996 348,996
603,000
Legal - 640
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 90,000 $ 128,128 $ 38,128 100% n/a $ 90,000 $ 128,128 $ 38,128
Revenues
Sale Map Photo or Copies 225 156 (69) 75% 52% 300 300
Miscellaneous 2,250 316 (1,934) 75% 11% 3,000 3,000
Interest on Investments 1,125 912 (213) 75% 61% 1,500 1,100 (400)
Interfund Contract 11,250 8,339 (2,911) 75% 56% 15,000 15,000
Legal Counsel Indirect Chgs 565,974 565,974 0 75% 75% 754,632 754,632
Total Revenues 580,824 575,698 (5,126) 774,432 774,032 (400)
Transfers In - General Fund 43,500 43,500 75% N/A - 43,500 43,500
TOTAL RESOURCES 670,824 747,326 33,002 75% 86% 864,432 945,660 37,728
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
561,268 538,280 22,988 75% 72% 748,357 748,357
36,356 28,455 7,901 75% 59% 48,475 48,475
75 - 75 75% 0% 100 100
50,625 50,625 75% 0% 67,500 67,500
TOTAL REQUIREMENTS 648,324 566,735 81,589 75% 66% 864,432 796,832 67,600
NET (Resources - Requirements) 22,500 180,592 114,592 - 148,828 105,328
Beginning Net Working Capital per Requested Budget 148,500
Information Tech - 660
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 435,000 $ 480,723 $ 45,723 100% n/a $ 435,000 $ 480,723 $ 45,723
Revenues
City of Redmond - 14,310 14,310 75% n/a 14,310 14,310
Miscellaneous 750 - (750) 75% 0% 1,000 1,000
Interest on Investments 4,500 2,853 (1,647) 75% 48°f° 6,000 3,800 (2,200)
Leases 15,750 20,020 4,270 75% n/a 21,000 21,000
I T Indirect Chgs 1,517,434 1,517,434 - 75% 75% 2,023,245 2,023,245
Total Revenue 1,538,434 1,554,617 16,183 75% 76% 2,051,245 2,063,355 12,110
Transfers In -General Fund 49,500 204,500 155,000 75% 310% 66,000 221,000 155,000
TOTAL RESOURCES 2,022,934 2,239,840 216,907 75% 88% 2,552,245 2,765,078 212,833
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
1,369,318 1,335,165 34,152 75% 73% 1,825,757 1,795,757 30,000
392,158 260,976 131,182 75% 50% 522,877 442,877 80,000
75 75 75% 0% 100 100
152,633 152,633 75% 0% 203,511 203,511
TOTAL REQUIREMENTS 1,914,184 1,596,141 318,042 75% 63% 2,552,245 2,238,634 313,611
NET (Resources - Requirements)
108,750 643,699 534,949
526,444 526,444
Beginning Net Working Capital per Requested Budget 513,000
IT Reserve - 661
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY %
Coll.
Revised
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 161,896 $ 212,360 $ 50,464 100% n/a $ 161,896 $ 212,360 $ 50,464
Revenues
Interest 1,500 1,370 (130) 75% 68% 2,000 1,500 (500)
Donations 10,500 10,500 75% n/a 10,500 10,500
Interfund Contract 3,400 3,400 75% n/a a) 3,400 3,400
IT Reserve Charges 175,500 175,500 75% 75% 234,000 234,000
Total Revenue 177,000 190,770 13,770 75% 81% 236,000 249,400 13,400
TOTAL RESOURCES 338,896
REQUIREMENTS:
Expenditures
Materials and Services
Capital Outlay
Res for Future Expenditure
403,129 64,233 75% 101% 397,896 461,760 63,864
Exp.
55,500 61,053 (5,553) 75% 83% b) 74,000 74,000
93,000 106,474 (13,474) 75% 86% b) 124,000 74,000 50,000
149,922 149,922 75% 0% 199,896 199,896
TOTAL REQUIREMENTS 298,422 167,527 130,895 75% 42% 397,896 148,000 249,896
NET (Resources - Requirements)
40,474 235,602 195,128
313,760 313,760
Beginning Net Working Capital per Requested Budget 304,896
a) From Solid Waste
Personnel - 650
Statement of Financial Operating Data
Nine Months Ended March 31, 2011
Year to Date
Budget
Actual
Variance
FY
Coll.
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 290,000 $ 351,450 $ 61,450 100% nla $ 290,000 $ 351,450 $ 61,450
Revenues
Miscellaneous 750 13,829 13,079 75% 1383% a) 1,000 13,829 12,829
Interest on Investments 4,500 2,121 (2,379) 75% 35% 6,000 3,000 (3,000)
Personnel Indirect Chgs 543,998 543,998 0 75% 75% 725,330 725,330
Total Revenues 549,248 559,948 10,700 75% 76% 732,330 742,159 9,829
Transfers In - General Fund 15,500 15,500 75% N/A 15,500 15,500
TOTAL RESOURCES 839,248 926,898 72,150 1,022,330 1,109,109 71,279
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Exp. %
450,806 437,323 13,483 75% 73% 601,074 601,074
255,117 102,779 152,338 75% 30% 340,156 200,156 140,000
75 75 75% 0% 100 - 100
60,750 60,750 75% 0% 81,000 81,000
766,748 540,102 226,646 75% 53% 1,022,330 801,230 221,100
72,500 386,796 298,796 307,879 292,379
Beginning Net Working Capital per Requested Budget 305,500
a) Manley Services Payment