HomeMy WebLinkAboutFinance UpdateMonthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
December 20, 2010
(1) Monthly Investment Report
(2) November 2010 Financials
• eschutes ount
Investment Income
Fiscal Year 2010-11
G
H
0
$ 79,198 $ 402,411
79,198 402,411
(3,960) (20,121)
Investment Income - Net $ 75,238 $ 382,290 I
4.
0
z
1 Investments By County Function
General $ 153,792,305
Total Investments $ 153,792,305
0.
w
>
c
'Js,
.0
4-
r.+
2
'ort 0 10 : rea ' QW! • • a u=
O
O
N
r • al Investment 'ort o lo s •
0
e e e e e e e
O v C1® O' 0 0 0
O 0 CA O M G
O CA CO O cc`iCD O
r
✓ CO
co • h
LC1 O
r r
E9
N co in
O CO
co a O V-
O N (0
CO 0)
cn
a)
0
N c
CL 0) N Na)
as
ca o a) - 0.
-- a)
0- O td rz c U
ca Q
U a) f 1—
a) ca a) Q
Nin 0
E o0I- as 43113
E a a) co m Y 0_
O O
O 0I—DLL• (0J
to
O
l'7
CA
t+f
N
N
Total Investments
.0 t
O
2
O
a
0 0 0
1.0
000
0 0 0
[� CO Cf)
r N N
O O
Average Maturity in Days
m
a)
c
a)
o e o e o e s
O O to in to 0 0
O O t+ N N N
r r
to rn
E 0
E 76 aa') 'V d a) ns a)
e0 • CD — C o O
03 Q r~ f0 Z
Z. «) < t.‘C-5 )
o y m U m
m
CD
. 0_ C a) c a
co (9 a) (0 0 O
0_) J tL CO H 0 U
Total Portfolio: By Investment Types
m
a)
N (0 C
N N Y o
V N
LL Q N m U
Prior month BOTC / LGIP rate was recalculated based on
weighted average.
■ ese utes Dunt A
arket Value
Original Cost
d (0
O. •wz is
U rt
7 0
O 10
01
51
6; g
y
M !D
01 �
2
01
ct
3
7
a
t0
U 010 Q1010 010 010 01U',U U'0 010 0 UIQ 0
z `zIz zlzlz zIz z z z z z z z z z z'z z z
r
UUIUc o zQ!-ern
z Z z m Z N z Z Z
N L<)
0) R
0- O O . O
MI
1 i
C
01
MON—CH O 00
0) (TI.O0 0) a0 N O V N O M O O O 0 ( (00 O O N O1 T1O N 0) O W O M 0 0 0
O O O O 00 O N <0 N P R P O M O O (O W (D O O N O O O N O O O; M 0i O 6
a0 O P O O( c 0 N V V 4 O 0) 0 0 0) W O O N O (O O O N O 0) O W 01 0 O
�_ N M O V *_ O r W O O 0) N M O O P O O W P O O O N) P O N; O O O' O O
P C) O M O M M N I (V 7 N c0 V O 0) P P 1 N W (O 0 1 0 P V N W P N O O I
0 V (0 0 0 V 0 0 N OI NrM N 0) N 0) —.- O N P M M M. - N O M W N O N N N
- 0I 0 0. 0 01 0 .- _ 0 0 0. .> _ 0 0 0 0.— O O N 0 0 0
N N N 1 N N N 0< N N N N N N N 1 N s V N N N 1 NIN 0<1 0<1 ('4 ('4 ('4 (V N!
W - o
WC
T 0
- 0.
O 00
N
0 0
O W
ON
ow
66
O O
N
<0(0 0 0 .-(0 0 0 0 <00 010
O 0) 0 0. OI O O O 1- O O O
W M O O— 0 0 0 I o P O o I O
0)1(0 W 1 C) O W W P
W W N C N OI O W N N M M M
CD 01 o P V O O M o 0 0 0 O O
O O O (01 M O O O O0, 0 0 0 0 0
000(0<00(00000000
(‚40 (‚4 (0 ('4 0 0 <00 ('4 0 <0
won' W - 0 0 .- O W O W O W
O W1 <0 O P 0 _O V V O N O_ W(0 O O O M 7 W (0 O N (0
O P O. O N N O P (O O O O O P O' M' O' O O O ('4 0) 0)0) 0)
4' W O1 .- 0 0 0 0 0 0 0 0 0 0 0 0 OI 0 0,- 0 .- OII W 0) 01
N 1N.N N N N N•N N N N N N N N1N
O W 0 0 0 W O O O 0', O w o 0 0 0 0 0 M• O O O O p, 0 0 0 O W 0 0 O'1
O P OIO O O O I O I O 0'O J O O O O O I O N'O O O O o�0 O I 0 0 4- 0 0 0
O P O1 O O P 0 0 0 0 0 0 0 0 0 0 0 0 O) O O o 0 0 0 0 0 0 0 0 0 0
O it) 0 V 01 1() R O O O V W W O 0 0 (0 O W N 0 0 0 O' 0 (01 0 0(0 0 0 0
0 i0 0(0 O 1 Q (1< 0 0 0 (0 MIP 0 0 0 0) O W P 0 0 0 0I 0 W 0 0 0
O M 010) O M 0) O O O P W P 0 0 0 C) O 4- V O O 0 0) O N 0 0 0 0 0
O 0) 0 0 0' 0) O. O O O) O 0) 0 0 o W O V 0 0 M 0 0) 0 o R O W 0 0 0
O O I. ,- 0 O O O 0 .-10 0 0 0 010 . 0 0 O W'— O. 0 .- O O O
c44- N N 4- 1N N 1 N 1 N N 1 N N 041N c41 04 N 1 N .-- 014)1 N1('1 N 1 N N
e e e e e e -9 -91e9 e e o - oto e eIe e e e e e e e e e e elele l
O (0 O N OI0 O W _W
O . W O M O 0) < O O (0 0) (V O O W W O (0 O P O O O M O M O W O O O N
- NIP P (V I— W W W M V.— N.— O W W W P O W 01 0 10(0 a7 P O (O O O O (D
N OIC O. I O
co.
0 0 0 0 0 O: 0 0 0 O. 0 0
0
N
e e e 0.
(on o' o vo)
M 100)0)
(4) 66,_1
• (4 e eIe e e e
oio0O000(nl0
r MIM ( 000 (0 0- n . o
O (0(0 000)0()
e e
coo
ocm
ti C1
0 o O o
O (n0(n
CO P P N
6466
o e'1
,S00-41
1
010
61'6°1
OW
00) (i
O
co
<00 O (A P N W P P 0 P 0) 0) M
.-(0 W W a0 c M M O O (0 N v M
O V' M (A O O O O to O V '0 O
R 4) ((0 (OM
(00) M W
('4 e
0) V P M
P P P M
P O IV
N V O Tr
OW
$153,792,304.90 1
152,682,640.83
N 0) M 0 O
N O O 0 p0
((0 V ti M
0
W P P M U)
<00) . I0 co'
10 44w4 co
a00 W (Nf)
•
ee o e
('1 0 0 0
Oaf h O O
O O - O O
0 0 0 0 '-
0 030 0 0 o P 0
0a0OM ci
O 6,6IO r 6O
C C
M- M 0) 0)) 0) N M MIMi P
(0 4) (01 W P 1 P P W P P P PP 1 O
N N
P P 0)1 .- O O W W O 0) 0) O W .- O) O O M P P
010 0 .- M. - N N O N N N O O N 0 0 0 0 0 N N 0 N
1 0 0 0 0 0 01010 0 0 0 0 010 (0 010 0. ,-.- O 0
0) 0) W
0 0 0
0 0)
MOM
0 .- O
rn
c
a) O-.
0 g 1rA • c
N N N N N N N N N N aclo i t 8 2
M O P O) D10) < E
N N O O ,00
al l0 'FV„
0 0 0 0 0 0 0 <- 1Q 0-O O
!-IJ 'm
00 00 0 0 0 0 010 0 1 0 01 0 0 0 0 0 0 0 0 0 l o O I O c 0 0
000-
O O O
0)
M
0 0) <00 0 4- C) P (0 1 O P N P P C) M, M P V 011 O) - 0) 0)
N N N N N '-1 N10 .- N 0)I O N1 N O N N 01 N1 O s - N 0 0 0
M O) N N ,- W M M O M C P P ." 0) 0) O) .- 01 O
0 0 - 0 0 010 010 0 0 010 0 0— 010 0
- 0I010 0,'
ad6y 0_01,1 p I m
❑
0_1030_4a
1"fl 0 7 m S
3137EAB W 8
U
n
Q
0
4
❑ V
Gi0i 0' '
c
O ❑ (mp c U m 0, Z x m 0
I (J
m m E 010 0) 0 > > 01m
COI
JI ImIQ 0 g ami m w; m1(.0 Y
(.) 2 g1Y CD, .c E dim c _.mlm m y1 01 an
CL J OJI C E 0 c J 7 >. U (A d U
E i E ml 0 a) o a)'2 0 a)! Li, L' E LL
D'.,LL,0Im 2I> 0 0 LL10)1(q,Y,LLID 5 D L.L.
Z 0 Z i d 0
O 1 0,1- 1-
I OI(Zi(p �1<0
0 0 1 0 Z Z 0 <1< < Q Z Q 0❑ Q Q❑ Q Z Q Z 0 0 0
I- 1- a 010 1- LLI LL LL a Ui LL Y- a LL a 1- a 0 L.L. U LLI LLI LL
m Z- LL it ,1Z Z LL CO 03 0- U Z <- LL Q' 1L
(na ❑a(00) M W (0ml(0I�MCI]
O O) N J W (MO (!' O W 1 O, colo
V N
, ecz}
,1_:,-,‹z
O 0> ? (00 M X M � oap
0 .3., M_ M 00)) ((4) C')) M 0)' ON) 0) .)- ('M 1 0) C)
N D1 M M_ W M M MI M
W MIM M Of OI M M M M M M MI M (o')
0 Z
z 0 ❑ 0
101' U 0_
tu
'v ❑ -0a U
`1 0 ((i 03 c 1
0 (n m
m m LL
'c U
O 2? 4) 1
,i 0 w LL
c c m 2 lc2 I201-1 cal U °.2 J Eat UI
LL U,LL I- u m L.L,1LL M,a,0,1.1_ 0, LL, LL LL,,
LL
(Z/7
010_
a
m
A
a)
U
H
O
m
Total Investments
IQ 0 a' LL m m "-) m Z> 1- a LL Q.a IZ IQIO
m m0 x I_C 1J a I� ti (/! w 3 co'U U LL )- 1-
Memorandum
Date: December 13, 2010
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find Novernber 2010 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
GENERAL FUND
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY %
CoII. %
RESOURCES:
Beg. Net Working Capital $ 8,300,000 $ 9,677,699 $ 1,377,699 100% 117% $8,300,000 $9,677,699 $ 1,377,699
Revenues
Property Taxes 8,569,167 18,219,159 9,649,992 42% 89% a) 20,566,000 20,566,000 -
Gen. Rev. - excl. Taxes 998,808 1,524,048 525,240 42% 64% b) 2,397,138 2,397,138
Assessor 331,538 436,584 105,046 42% 55% c) 795,690 795,690
County Clerk 508,631 653,615 144,984 42% 54% 1,220,714 1,220,714
BOPTA 5,166 843 (4,323) 42% 7% 12,398 12,398
District Attorney 130,875 66,843 (64,032) 42% 21% 314,100 314,100
Finance/Tax 75,083 116,227 41,144 42% 64% c) 180,200 180,200
Veterans 28,278 16,886 (11,392) 42% 25% 67,866 67,866
Property Management 37,972 42,566 4,594 42% 47% 91,132 91,132
Grant Projects 833 833 0 42% 42% 2,000 2,000
Total Revenues 10,686,351 21,077,604 10,391,253 42% 82% 25,647,238 25,647,238
TOTAL RESOURCES 18,986,351 30,755,304 11,768,953 42% 91% 33,947,238 35,324,937 1,377,699
REQUIREMENTS:
Expenditures
Assessor 1,409,258 1,307,586 101,672 42% 39% 3,382,219 3,382,219
County Clerk 618,386 573,713 44,673 42% 39% 1,484,127 1,484,127
BOPTA 31,418 23,785 7,633 42% 32% 75,403 75,403
District Attomey 2,034,220 1,938,942 95,278 42% 40% 4,882,127 4,882,127
Finance/Tax 352,879 364,572 (11,693) 42% 43% 846,910 846,910
Veterans 109,249 106,967 2,282 42% 41% 262,197 262,197
Property Management 105,511 104,948 563 42% 41% 253,227 253,227
Grant Projects 46,751 44,886 1,865 42% 40% 112,203 112,203
Non -Departmental 924,745 587,616 337,129 42% 26% 2,219,387 2,219,387
Contingency 2,852,198 2,852,198 42% n/a 6,845,274 6,845,274
8,484,615 5,053,017 3,431,598 42% 25% 20,363,074 13,517,800 6,845,274
Transfers Out 5,405,902 5,388,508 17,395 42% 42% 12,974,164 12,974,164
TOTAL REQUIREMENTS 13,890,517 10,441,524 3,448,993 42% 31% 33,337,238 26,491,964 6,845,274
NET (Resources - Requirements) 5,095,834 20,313,779 15,217,945 d) 610,000 8,832,973 8,222,973
Exp. %
a) Approximately 85% of the year's property taxes are collected by November 30, 2010.
b) YTD Actual includes annual payments: Federal in lieu of taxes - $471,913 and State tax on electric co-ops - $464,452.
c) YTD Actual includes A&T grant received quarterly in advance
d) Appropriation transferred to Fund 575 - $610,000
Year End
$
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 8,300,000 $ 9,677,699 $ 1,377,699 100% 117% $8,300,000 $9,677,699 $ 1,377,699
Revenues
Property Taxes 8,569,167 18,219,159 9,649,992 42% 89% a) 20,566,000 20,566,000 -
Gen. Rev. - excl. Taxes 998,808 1,524,048 525,240 42% 64% b) 2,397,138 2,397,138
Assessor 331,538 436,584 105,046 42% 55% c) 795,690 795,690
County Clerk 508,631 653,615 144,984 42% 54% 1,220,714 1,220,714
BOPTA 5,166 843 (4,323) 42% 7% 12,398 12,398
District Attorney 130,875 66,843 (64,032) 42% 21% 314,100 314,100
Finance/Tax 75,083 116,227 41,144 42% 64% c) 180,200 180,200
Veterans 28,278 16,886 (11,392) 42% 25% 67,866 67,866
Property Management 37,972 42,566 4,594 42% 47% 91,132 91,132
Grant Projects 833 833 0 42% 42% 2,000 2,000
Total Revenues 10,686,351 21,077,604 10,391,253 42% 82% 25,647,238 25,647,238
TOTAL RESOURCES 18,986,351 30,755,304 11,768,953 42% 91% 33,947,238 35,324,937 1,377,699
REQUIREMENTS:
Expenditures
Assessor 1,409,258 1,307,586 101,672 42% 39% 3,382,219 3,382,219
County Clerk 618,386 573,713 44,673 42% 39% 1,484,127 1,484,127
BOPTA 31,418 23,785 7,633 42% 32% 75,403 75,403
District Attomey 2,034,220 1,938,942 95,278 42% 40% 4,882,127 4,882,127
Finance/Tax 352,879 364,572 (11,693) 42% 43% 846,910 846,910
Veterans 109,249 106,967 2,282 42% 41% 262,197 262,197
Property Management 105,511 104,948 563 42% 41% 253,227 253,227
Grant Projects 46,751 44,886 1,865 42% 40% 112,203 112,203
Non -Departmental 924,745 587,616 337,129 42% 26% 2,219,387 2,219,387
Contingency 2,852,198 2,852,198 42% n/a 6,845,274 6,845,274
8,484,615 5,053,017 3,431,598 42% 25% 20,363,074 13,517,800 6,845,274
Transfers Out 5,405,902 5,388,508 17,395 42% 42% 12,974,164 12,974,164
TOTAL REQUIREMENTS 13,890,517 10,441,524 3,448,993 42% 31% 33,337,238 26,491,964 6,845,274
NET (Resources - Requirements) 5,095,834 20,313,779 15,217,945 d) 610,000 8,832,973 8,222,973
Exp. %
a) Approximately 85% of the year's property taxes are collected by November 30, 2010.
b) YTD Actual includes annual payments: Federal in lieu of taxes - $471,913 and State tax on electric co-ops - $464,452.
c) YTD Actual includes A&T grant received quarterly in advance
d) Appropriation transferred to Fund 575 - $610,000
COMM JUSTICE -JUVENILE
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY % 1 Coll. %
RESOURCES:
Revised
Year End
Budget
Projection
Variance
Beg. Net Working Capital $ 987,000 $ 1,039,997 $ 52,997 100% 105% $ 987,000 $ 1,039,997 $ 52,997
Revenues
Federal Grants 6,470 3,882 (2,588) 42%
SB #1065 -Court Assess. 25,000 21,539 (3,461) 42%
Discovery Fee 6,667 5,030 (1,637) 42%
Food Subsidy 15,833 10,970 (4,863) 42%
OYA Basic & Diversion 141,669 48,917 (92,752) 42%
Inmate/Prisoner Housing 41,667 18,900 (22,767) 42%
Inmate Commissary Fees 42 59 17 42%
Contract Payments 36,871 33,505 (3,366) 42%
Miscellaneous 125 52 (73) 42%
MIP Diversion Fees 417 50 (367) 42%
Interest on Investments 7,083 3,852 (3,231) 42%
Leases 1,000 1,000 42%
Grants - Private 208 317 109 42%
Health & Human Svcs Chg 2,500 2,075 (425) 42%
CCF Interfund Grant 25,206 24,125 (1,081) 42%
Gen Fund Grant -Crime Prev. 8,333 5,000 (3,333) 42%
Total Revenues 319,091 179,273 (139,818) 42%
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
25% a) 15,527 15,527
36% 60,000 57,500 (2,500)
31% 16,000 16,000
29% b) 38,000 37,000 (1,000)
14% c) 340,006 321,175 (18,831)
19% d) 100,000 92,000 (8,000)
59% 100 100
38% 88,490 70,000 (18,490)
17% 300 100 (200)
5% 1,000 300 (700)
23% 17,000 9,000 (8,000)
42% 2,400 2,400
63% 500 500
35% 6,000 6,000
40% b)e) 60,495 96,500 36,005
25% 20,000 20,000
23% 765,818 744,102 (21,716)
2,309,660 2,309,660 - 42% 42% 5,543,186 5,543,186
3,615,751 3,528,930 (86,821) 42% 48% 7,296,004 7,327,285 31,281
Exp. %
1,234,982 1,129,247 105,735 42% 38% f) 2,963,956 2,750,000 213,956
Materials and Services 499,953 421,287 78,666 42% 35% g) 1,199,886 1,100,000 99,886
Capital Outlay 42 - 42 42% 0% 100 100
Juvenile Resource Center
Personal Services 964,627 898,732 65,895 42% 39% h) 2,315,104 2,200,000 115,104
Materials and Services 73,123 72,396 727 42% 41% 175,494 167,000 8,494
Contingency 267,277 - 267,277 42% n/a 641,464 641,464
TOTAL REQUIREMENTS
NET (Resources - Requirements)
3,040,004 2,521,662 518,342 42%
35%
7,296,004 6,217,000 1,079,004
575,747 1,007,268 431,521 - 1,110,285 1,110,285
a) Second quarter Federal Grant anticipated in March
b) Reimbursements for food subsidy received approximately one month after monthly billings, CCF billed quarterly
c) OYA monies collected in Nov, Feb, May, and June - Reduction due to anticipated State funding cut
d) Revenue is generated when non -Deschutes juveniles utilize facility - $14,000 billing is currently outstanding
e) Additional funding from CCF allocated for Juvenile programs
f) Salary 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) Salary savings due to less on-call and overtime for the detention facility
SHERIFF - Fund 255
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll.
RESOURCES:
Beg. Net Working Capital $
Revenues
Law Enf Dist Countywide
Law Enf Dist Rural
Interest
Total Revenues
TOTAL RESOURCES
- $ 207,689 $ 207,689
9,512,274
5,694,141
15,206,415
100%
n/a
$ - $ 207,689 $ 207,689
8,046,528 (1,465,746) 42% 35% 22,829,457 21,363,711 (1,465,746)
5,136,923 (557,218) 42% 38% 13,665,939 13,108,720 (557,219)
6,623 6,623 42% n/a - 6,623 6,623
13,190,074 (2,016,341) 42% 36% 36,495,396 34,479,054 (2,016,342)
15,206,415 13,397,763 (1,808,652) 42% 37% 36,495,396 34,686,743 (1,808,653)
REQUIREMENTS:
EXPENDITURES 8 TRANSFERS
Sheriffs Division 1
Civil
Automotive/Communications
Investigations/Evidence
Patrol/Civil/Comm Supp 3
Records
Adult Jail 4
Court Security
Emergency Services
Special Services Division
Regional Work Center 1
Training Division
Other Law Enforcement Svcs
Non -Departmental
Contingency 2
Transfers Out - DIS Fund
TOTAL REQUIREMENTS
NET (Resources - Requirements)
,184,028
332,682
605,432
687,830
,261,938
275,161
,102,860
100,355
72,684
486,418
,198,434
137,500
248,715
117,924
,311,121
1,128,291
333,618
709,531
638,179
3,260,310
250,982
3,503,375
111,905
69,393
497,090
1,080,395
112,640
252,736
34,591
55,737
(936)
(104,099)
49,651
1,628
24,179
599,485
(11,550)
3,291
(10,672)
118,039
24,860
(4,021)
83,333
2,311,121
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
Exp. %
40% a)
42%
49% b)
39% b)
42% c)
38%
36% d)
46%
40%
43%
38% e)
34%
42%
12%
n/a
2,841,668
798,436
1,453,036
1,650,792
7,828,651
660,386
9,846,864
240,851
174,441
1,167,404
2,876,242
330,000
596,917
283,018
5,546,690
2,875,668 (34,000)
798,436 -
1,403,036 50,000
1,600,792 50,000
7,830,651 (2,000)
660,386 -
9,696,864 150,000
240,851
174,441
1,167,404
2,726,242 150,000
330,000
596,917
283,018
- 5,546,690
83,333 60,539 22,794 42% 30% 200,000 200,000
15,206,415 12,043, 574
3,162,841 42% 33% 36,495,396 30,584,706 5,910,690
1,354,189 1,354,188 - 4,102,037 4,102,037
a) Higher than budgeted employee vacation sell back
b) Delay in filling open positions will result in lower personnel expenditures for FY 2011
c) Projected savings due to open positions will be offset by unplanned purchase of additional patrol vehicles
d) Unfilled budgeted positions in Adult Jail resulting in lower personnel expenditures for FY 2011. Forecast includes $292,000
for jail bed rental
e) Unfilled budgeted positions and lower material and service expenditures projected for FY 2011
Year End
Budget
Projection
Variance
$ - $ 207,689 $ 207,689
8,046,528 (1,465,746) 42% 35% 22,829,457 21,363,711 (1,465,746)
5,136,923 (557,218) 42% 38% 13,665,939 13,108,720 (557,219)
6,623 6,623 42% n/a - 6,623 6,623
13,190,074 (2,016,341) 42% 36% 36,495,396 34,479,054 (2,016,342)
15,206,415 13,397,763 (1,808,652) 42% 37% 36,495,396 34,686,743 (1,808,653)
REQUIREMENTS:
EXPENDITURES 8 TRANSFERS
Sheriffs Division 1
Civil
Automotive/Communications
Investigations/Evidence
Patrol/Civil/Comm Supp 3
Records
Adult Jail 4
Court Security
Emergency Services
Special Services Division
Regional Work Center 1
Training Division
Other Law Enforcement Svcs
Non -Departmental
Contingency 2
Transfers Out - DIS Fund
TOTAL REQUIREMENTS
NET (Resources - Requirements)
,184,028
332,682
605,432
687,830
,261,938
275,161
,102,860
100,355
72,684
486,418
,198,434
137,500
248,715
117,924
,311,121
1,128,291
333,618
709,531
638,179
3,260,310
250,982
3,503,375
111,905
69,393
497,090
1,080,395
112,640
252,736
34,591
55,737
(936)
(104,099)
49,651
1,628
24,179
599,485
(11,550)
3,291
(10,672)
118,039
24,860
(4,021)
83,333
2,311,121
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
42%
Exp. %
40% a)
42%
49% b)
39% b)
42% c)
38%
36% d)
46%
40%
43%
38% e)
34%
42%
12%
n/a
2,841,668
798,436
1,453,036
1,650,792
7,828,651
660,386
9,846,864
240,851
174,441
1,167,404
2,876,242
330,000
596,917
283,018
5,546,690
2,875,668 (34,000)
798,436 -
1,403,036 50,000
1,600,792 50,000
7,830,651 (2,000)
660,386 -
9,696,864 150,000
240,851
174,441
1,167,404
2,726,242 150,000
330,000
596,917
283,018
- 5,546,690
83,333 60,539 22,794 42% 30% 200,000 200,000
15,206,415 12,043, 574
3,162,841 42% 33% 36,495,396 30,584,706 5,910,690
1,354,189 1,354,188 - 4,102,037 4,102,037
a) Higher than budgeted employee vacation sell back
b) Delay in filling open positions will result in lower personnel expenditures for FY 2011
c) Projected savings due to open positions will be offset by unplanned purchase of additional patrol vehicles
d) Unfilled budgeted positions in Adult Jail resulting in lower personnel expenditures for FY 2011. Forecast includes $292,000
for jail bed rental
e) Unfilled budgeted positions and lower material and service expenditures projected for FY 2011
RESOURCES:
Beg. Net Working Capital
Revenues
Tax Revenues - Current
Tax Revenues - Prior
Federal Grants
State Grant
Transp. of State Wards
SB 1145
Des. Cty Video Lottery Grant
Des Cty Court Security
Des Cty Juvenile Contract
Title III Reimbursement
Transport
DC Fair & Expo Center
Inmate Commissary Fees
Work Center Work Crews
Concealed Handgun Classes
Soc Sec Incentive -Fed
Miscellaneous
Oregon Mentors
Medical Services Reimb
Restitution
Sheriff Fees
Interest
Interest on Unsegregated
Rentals
Donations
Sale of Reportable Assets
Total Revenues
TOTAL RESOURCES
SHERIFF 701
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY%
Coll.
$ 4,722,862 $ 5,478,092 $ 755,230 100%
6,188,998
267,500
14,583
20,198
2,083
822,775
2,083
39,583
62,500
1,667
20,000
10,417
2,500
2,083
2,083
5,000
417
66,667
11,805
1,472
12,975,301 6,786,303 42%
489,337 221,837 42%
(14,583) 42%
37,037 16,839 42%
(2,083) 42%
987,330 164,555 42%
(2,083) 42%
39,523 (60) 42%
3,454 3,454 42%
59,492 (3,008) 42%
83 (1,584) 42%
3,825 3,825 42%
25,759 5,759 42%
36,180 25,763 42%
1,400 (1,100) 42%
4,000 1,917 42%
3,146 1,063 42%
4,120 4,120 42%
6,479 1,479 42%
3,203 2,786 42%
111,953 45,286 42%
11,117 (688) 42%
1,241 (231) 42%
2,500 2,500 42%
200 200 42%
1,257 1,257 42%
7,544,414
14,807,937 7,263,523 42%
12,267,276 20,286,029 8,018,753 42%
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 9,512,274
8,046,528 1,465,746 42%
TOTAL REQUIREMENTS 9,512,274 8,046,528 1,465,746 42%
NET (Resources - Requirements) 2,755,002 12,239,501 9,484,499
116% $ 4,722,862 $ 5,478,092 $ 755,230
87%
76%
0%
76%
0%
50%
0%
42%
n/a
40%
2%
n/a
54%
145%
23%
80%
63%
n/a
54%
320%
70%
39%
35%
n/a
n/a
n/a
82%
a) 14,853,594
642,000
b) 35,000
48,475
5,000
b) 1,974,660
5,000
95,000
b) 150,000
4,000
48,000
c) 25,000
6,000
5,000
5,000
12,000
1,000
d) 160,000
28,333
3,533
14,853,594 -
727,000 85,000
35,000
48,475
5,000
1,974,660
5,000
95,000 -
3,454 3,454
150,000 -
4,000 -
3,825 3,825
48,000
50,000 25,000
6,000
5,000
5,000
5,000 5,000
12,000 -
5,000 4,000
200,000 40,000
28,333
3,533
2,500 2,500
200 200
1,257 1,257
18,106, 595 18, 276, 831 170,236
89% 22,829,457 23,754,923 925,466
Exp. %
a) Approximately 85% of the year's property taxes are collected by November 30, 2010.
b) Timing of budget and receipt of payment
c) Contract revenue USFS
d) Actual revenue for concealed weapons permits and civil papers will exceed budget
e) Payment to Sheriffs Office adjusted to actual quarterly
35% e) 22,829,457 21,363,711 1,465,746
35% 22,829,457 21,363,711 1,465,746
- 2,391,212 2,391,212
Year End
Budget
Projection
Variance
116% $ 4,722,862 $ 5,478,092 $ 755,230
87%
76%
0%
76%
0%
50%
0%
42%
n/a
40%
2%
n/a
54%
145%
23%
80%
63%
n/a
54%
320%
70%
39%
35%
n/a
n/a
n/a
82%
a) 14,853,594
642,000
b) 35,000
48,475
5,000
b) 1,974,660
5,000
95,000
b) 150,000
4,000
48,000
c) 25,000
6,000
5,000
5,000
12,000
1,000
d) 160,000
28,333
3,533
14,853,594 -
727,000 85,000
35,000
48,475
5,000
1,974,660
5,000
95,000 -
3,454 3,454
150,000 -
4,000 -
3,825 3,825
48,000
50,000 25,000
6,000
5,000
5,000
5,000 5,000
12,000 -
5,000 4,000
200,000 40,000
28,333
3,533
2,500 2,500
200 200
1,257 1,257
18,106, 595 18, 276, 831 170,236
89% 22,829,457 23,754,923 925,466
Exp. %
a) Approximately 85% of the year's property taxes are collected by November 30, 2010.
b) Timing of budget and receipt of payment
c) Contract revenue USFS
d) Actual revenue for concealed weapons permits and civil papers will exceed budget
e) Payment to Sheriffs Office adjusted to actual quarterly
35% e) 22,829,457 21,363,711 1,465,746
35% 22,829,457 21,363,711 1,465,746
- 2,391,212 2,391,212
SHERIFF 702
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $1,905,939 $ 2,421,863 $ 515,924 100%
Revenues
Tax Revenues - Current 3,128,435 6,535,685
Tax Revenues - Prior 130,833 244,368
Federal Grants 833 4,916
Federal Grants-BLM 2,982
US Forest Service 31,875 44,625
State Grant 78,180 61,164
SB #1065 Court Assessment 27,917 21,539
Marine Board License Fee 59,347
Des Cty General Fund Grant 292,649
Des Cty Transient Room Tax 811,518 811,518
City of Sisters 180,273 180,273
Des Cty Tax/Fin Contract 417
Des Cry CDD Contract 22,653 22,653
Des Cty Solid Waste Contr 22,653 22,653
Des Cry Clerk/Election 833 675
School Districts 41,667 6,103
Security & Traffic Reimb 5,417 1,081
Seat Belt Program 2,500 3,075
Miscellaneous 4,167 6,707
Restitution 208
Sheriff Fees 4,167 3,920
Court Fines & Fees 35,417 53,327
Impound Fees 6,250 2,600
Restitution - Street Crimes 208
Interest 4,167 3,362
Interest on Unsegregated 750 623
Sale of Reportable Assets 4,167 21,318
Sale of Equip & Material 2,500 6,563
Total Revenues 4,900,001 8,061,730
TOTAL RESOURCES
127% 51,905,939
3,407,250 42% 87%
113,535 42% 78%
4,083 42% 246%
2,982 42% rt/a
12,750 42% 58%
(17,016) 42% 33%
(6,378) 42% 32%
(59,347) 42% 0%
(292,649) 42% 0%
42% 42%
42% 42%
(417) 42% 0%
42% 42%
42% 42%
(158) 42% 34%
(35,564) 42% 6%
(4,336) 42% 8%
575 42% 51%
2,540 42% 67%
(208) 42% 0%
(247) 42% 39%
17,910 42% 63%
(3,650) 42% 17%
(208) 42% 0%
(805) 42% 34%
(127) 42% 35%
17,151 42% 213%
4,063 42% 109%
3,161,729 42% 69%
6,805,940 10,483,592 3,677,652 42%
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 5,694,141
5,136,923 557,218 42%
TOTAL REQUIREMENTS 5,694,141 5,136,923 557,218 42%
NET (Resources - Requirements) 1,111,799 5,346,669 4,234,870
a) 7,508,247
314,000
b) 2,000
76,500
187,633
67,000
c) 142,433
d) 702,358
1,947,642
432,655
1,000
54,366
54,366
2,000
e) 100,000
13,000
6,000
10,000
500
10,000
85,000
15,000
500
10,000
1,800
f) 10,000
6,000
$2,421,863 $ 515,924
7,508,247
371,000
10,000
2,982
76,500
187,633
67,000
142,433
702,358
1,947,642
432,655
1,000
54,366
54,366
2,000
100,000
13,000
6,000
10,000
500
10,000
85,000
15,000
500
10,000
1,800
25,000
10,000
57,000
8,000
2,982
15,000
4,000
11,760,000
11,846,982 86,982
77% 13,665,939 14,268,845 602,906
Exp. %
a) Approximately 85% of the year's property taxes are collected by November 30, 2010.
b) Actual HIDTA overtime reimbursement higher than budgeted
c) Fees usually received Feb & June
d) Grant will be received June 2011
e) Most of this revenue received Feb -June
f) Proceeds from sale of used patrol vehicles were higher than estimated
g) Payment to Sheriffs Office adjusted to actual quarterly
38% g) 13,665,939 13,108,720 557,219
38% 13,665,939 13,108,720 557,219
- 1,160,125 1,160,125
Year End
Budget
Projection
Variance
127% 51,905,939
3,407,250 42% 87%
113,535 42% 78%
4,083 42% 246%
2,982 42% rt/a
12,750 42% 58%
(17,016) 42% 33%
(6,378) 42% 32%
(59,347) 42% 0%
(292,649) 42% 0%
42% 42%
42% 42%
(417) 42% 0%
42% 42%
42% 42%
(158) 42% 34%
(35,564) 42% 6%
(4,336) 42% 8%
575 42% 51%
2,540 42% 67%
(208) 42% 0%
(247) 42% 39%
17,910 42% 63%
(3,650) 42% 17%
(208) 42% 0%
(805) 42% 34%
(127) 42% 35%
17,151 42% 213%
4,063 42% 109%
3,161,729 42% 69%
6,805,940 10,483,592 3,677,652 42%
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 5,694,141
5,136,923 557,218 42%
TOTAL REQUIREMENTS 5,694,141 5,136,923 557,218 42%
NET (Resources - Requirements) 1,111,799 5,346,669 4,234,870
a) 7,508,247
314,000
b) 2,000
76,500
187,633
67,000
c) 142,433
d) 702,358
1,947,642
432,655
1,000
54,366
54,366
2,000
e) 100,000
13,000
6,000
10,000
500
10,000
85,000
15,000
500
10,000
1,800
f) 10,000
6,000
$2,421,863 $ 515,924
7,508,247
371,000
10,000
2,982
76,500
187,633
67,000
142,433
702,358
1,947,642
432,655
1,000
54,366
54,366
2,000
100,000
13,000
6,000
10,000
500
10,000
85,000
15,000
500
10,000
1,800
25,000
10,000
57,000
8,000
2,982
15,000
4,000
11,760,000
11,846,982 86,982
77% 13,665,939 14,268,845 602,906
Exp. %
a) Approximately 85% of the year's property taxes are collected by November 30, 2010.
b) Actual HIDTA overtime reimbursement higher than budgeted
c) Fees usually received Feb & June
d) Grant will be received June 2011
e) Most of this revenue received Feb -June
f) Proceeds from sale of used patrol vehicles were higher than estimated
g) Payment to Sheriffs Office adjusted to actual quarterly
38% g) 13,665,939 13,108,720 557,219
38% 13,665,939 13,108,720 557,219
- 1,160,125 1,160,125
PUBLIC HEALTH
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
Revised
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $1,100,000 $ 1,615,306 $ 515,306 100% 147% $1,100,000 $1,615,306 $ 515,306
Revenues
Medicare Reimbursement 3,333 92 (3,241) 42% 1% 8,000 200 (7,800)
State Grant 1,047,074 1,074,709 27,635 42% 43% 2,512,977 2,573,752 60,775
Child Dev & Rehab Center 12,816 (12,816) 42% 0% 30,759 30,759
State Miscellaneous 91,623 73,006 (18,617) 42% 33% 219,896 219,896
OMAP 199,083 201,838 2,755 42% 42% 477,800 477,800
Family Planning Exp Proj 206,250 180,188 (26,062) 42% 36% 495,000 535,000 40,000
Grants 27,083 65,605 38,522 42% 101% a) 65,000 113,773 48,773
Water Program -Base Fee 17,500 9,386 (8,114) 42% 22% 42,000 42,000
Water Program -Field Work 23,257 30,240 6,983 42% 54% 55,817 55,817
H2O Sys Insp-Priv Wells 83 (83) 42% 0% 200 200
Miscellaneous 28 28 42% n/a 201 201
Patient Insurance Fees 79,275 48,051 (31,224) 42% 25% 190,260 120,260 (70,000)
Health Dept/Patient Fees 62,073 41,737 (20,336) 42% 28% 148,975 100,975 (48,000)
Vital Records -Birth 15,000 12,805 (2,195) 42% 36% 36,000 30,000 (6,000)
Vital Records -Death 40,833 40,055 (778) 42% 41% 98,000 96,000 (2,000)
Environmental Health 286,396 71,867 (214,529) 42% 10% 687,350 687,350
Interest on Investments 7,042 4,856 (2,186) 42% 29% 16,900 12,758 (4,142)
Donations 2,500 30,677 28,177 42% 511% b) 6,000 35,430 29,430
Interfund Contract 78,908 17,092 (61,816) 42% 9% 189,378 162,513 (26,865)
Administrative Fee 11,250 11,250 - 42% 42% 27,000 27,000
Total Revenues 2,211,379 1,913,482 (297,897) 42% 36% 5,307,312 5,321,684 14,372
Transfers In -General Fund 965,735 965,735 - 42% 42% 2,317,765 2,317,765
Transfers In -PH Res Fund 27,968 (27,968) 42% 0% 67,123 67,123
Transfers In -Gen. Fund Other 28,255 16,953 (11,302) 42% 25% 67,812 67,812
TOTAL RESOURCES 4,333,337 4,511,476 178,139 42% 51% 8,860,012 9,389,690 529,678
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
Exp. %
2,475,397 2,331,958 143,439 42% 39% 5,940,953 5,669,859 271,094
835,578 764,769 70,809 42% 38% 2,005,387 1,835,446 169,941
10,417 5,432 4,985 42% 22% 25,000 25,000
62,500 37,500 25,000 42% 25% 150,000 150,000
307,780 307,780 42% n/a 738,672 738,672
TOTAL REQUIREMENTS 3,691,672
NET (Resources - Requirements)
3,139,659 552,013 42%
35%
8,860,012 7,680,305 1,179,707
641,665 1,371,817 730,152 - 1,709,385 1,709,385
a) Health Matters -local grant for Chronic Care Program is $17,000 & $21,000. Bioterrorism NACCHO grant $10,000 received in July
b) My Future My Choice donation carry over from FY10, in the amount of $25,880. $3550 HIV sponsorship donation
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
RESOURCES:
Beg. Net Working Capital $ 2,616,050 $ 2,651,262 $ 35,212 100% 101%
Revenues
Marriage Licenses 2,292 2,640
Divorce Filing Fees 54,167 55,260
Domestic Partnership Fee 417 25
Federal Grants 40,404 14,836
State Grants 2,205,776 2,344,805
State Miscellaneous 61,739 26,106
Title 19 125,385 44,913
Liquor Revenue 43,917 40,111
School Districts 29,167 20,440
Miscellaneous 7,042 18,212
Patient Insurance Fees 64,167 22,116
Patient Fees 5,417 670
Interest on Investments 18,160 10,307
Rentals 5,458 5,250
Interfund Contract -Gen. Fund 52,917 39,771
Comm. on Children & Fam 10,000
Administrative Fee 1,754,774 1,744,698
Total Revenues 4,481,199 4,390,160
Transfers In -General Fund 548,400 548,400
Transfers In-OHP-CDO 41,665 41,665
Transfers In -Acute Care Svcs 152,355 152,355
Transfers In-ABHA 278,438 167,063
Actual
Variance
FY%
CoII. %
348
1,093
(392)
(25,568)
139,029
(35,633)
(80,472)
(3,806)
(8,727)
11,170
(42,051)
(4,747)
(7,853)
(208)
(13,146)
(10,000)
(10,076)
(91,039)
(111,375)
TOTAL RESOURCES 8,118,107
REQUIREMENTS:
Expenditures
Personal Services 3,818,285
Materials and Services 1,667,875
Capital Outlay 308,333
Transfers Out 65,485
Contingency 732,100
Revised
Year End
Budget
Projection
Variance
$ 2,616,050 $ 2,651,262 $ 35,212
42% 48% 5,500 5,500
42% 43% 130,000 130,000
42% 3% 1,000 250 (750)
42% 15% a) 96,969 96,969 -
42% 44% b) 5,293,862 5,020,888 (272,974)
42% 18% 148,173 148,173
42% 15% 300,925 200,000 (100,925)
42% 38% 105,400 105,400
42% 29% 70,000 70,000
42% 108% 16,900 18,212 1,312
42% 14% 154,000 75,000 (79,000)
42% 5% 13,000 3,000 (10,000)
42% 24% 43,585 25,000 (18,585)
42% 40% 13,100 13,100
42% 31% a) 127,000 127,000
42% 0% c) 24,000 - (24,000)
42% 41% 4,211,457 4,211,457
42% 41% 10,754,871 10,249,949 (504,922)
42% 42% 1,316,158 1,316,158
42% 42% 100,000 100,000
42% 42% 365,657 365,657
42% 25% 668,252 668,252
7,950,905 (167,202) 42% 50% 15,820,988 15,351,278 (469,710)
Exp. %
3,630,680 187,605 42% 40% d) 9,163,883 8,713,883 450,000
1,312,451 355,424 42% 33% 4,002,901 3,502,901 500,000
308,333 42% 0% 740,000 740,000
37,500 27,985 42% 24% 157,164 157,164 -
732,100 42% n/a 1,757,040 1,757,040
TOTAL REQUIREMENTS 6,592,078 4,980,631 1,611,447 42% 31% 15,820,988 13,113,948 2,707,040
NET (Resources - Requirements) 1,526,029 2,970,274 1,444,245 - 2,237,330 2,237,330
a) Grant billing 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
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 686,081 613,031 $ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050)
Revenues
Admin -Operations 6,875 8,664 1,789 42% 53% 16,500 21,300 4,800
Admin -GIS 1,146 3,033 1,887 42% 110% a) 2,750 6,000 3,250
Admin -Code Enforcement 67,383 64,707 (2,676) 42% 40% 161,718 164,600 2,882
Building Safety 450,507 374,652 (75,855) 42% 35% b) 1,081,217 1,109,100 27,883
Electrical 111,105 113,366 2,261 42% 43% 266,652 269,600 2,948
Contract Services 76,667 63,476 (13,191) 42% 34% c) 184,000 168,300 (15,700)
Env Health -On Site Prog 118,263 125,116 6,853 42% 44% 283,830 288,400 4,570
Planning -Current 323,734 301,872 (21,862) 42% 39% d) 776,962 750,400 (26,562)
Planning -Long Range 147,405 105,242 (42,163) 42% 30% e) 353,771 348,600 (5,171)
Total Revenues
1,303,085 1,160,129 (142,956) 42% 37% 3,127,400 3,126,300 (1,100)
Trans In -GF 105,580 105,580 42% 42% 253,387 253,387
Trans In -GF for Lng Rng Ping 215,000 215,000 - 42% 42% 516,000 516,000 -
TOTAL RESOURCES 2,309,746 2,093,740 (216,006) 42% 46% 4,582,868 4,508,718 (74,150)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin -Operations 584,332 574,677 9,655 42% 41% 1,402,396 1,402,396
Admin -GIS 90,056 93,482 (3,426) 42% 43% f) 216,135 168,000 48,135
Admin -Code Enforcement 76,972 76,244 728 42% 41% 184,732 184,732
Building Safety 208,471 201,956 6,515 42% 40% 500,330 500,330
Electrical 78,169 74,157 4,012 42% 40% 187,606 187,606
Contract Services 101,771 99,327 2,444 42% 41% 244,251 244,251
Env Health -On Site Pgm 96,669 122,355 (25,686) 42% 53% g) 232,006 220,000 12,006
Planning -Current 287,621 257,777 29,844 42% 37% 690,290 690,290
Planning -Long Range 205,178 242,657 (37,479) 42% 49% h) 492,427 492,427
Transfers Out (D/S Fund) 72,213 145,000 (72,787) 42% 84% 173,310 173,310
Contingency 108,077 108,077 42% n/a 259,385 259,385
Exp. %
TOTAL REQUIREMENTS 1,909,529 1,887,632 21,897 42% 41% 4,582,868 4,263,342 319,526
NET (Resources - Requirements)
400,217 206,108 (194,109) 245,376 245,376
Revenues 1,160,129 3,127,400 3,126,300 (1,100)
Expenditures 1,887,632 4,582,868 4,263,342 319,526
Net from Operations (727,503) (1,455,468) (1,137,042) 318,426
a) Custom GIS work revenue sporadic
b) YTD revenue is low in relation to budget, it is expected that budget projections will be met, 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
d) YTD business volume/revenue less than expected
e) Grant payments received irregularly
f) Savings due to resignation of CDD webmaster, who will not be replaced
g) Includes $35,651 in time management payout to retired employee, to be made up by salary savings as position will remain unfilled
h) Approximately $51,000 in consultant expense was paid in a lump sum and will be reimbursed through grant revenue
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 686,081 613,031 $ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050)
Revenues
Admin -Operations 6,875 8,664 1,789 42% 53% 16,500 21,300 4,800
Admin -GIS 1,146 3,033 1,887 42% 110% a) 2,750 6,000 3,250
Admin -Code Enforcement 67,383 64,707 (2,676) 42% 40% 161,718 164,600 2,882
Building Safety 450,507 374,652 (75,855) 42% 35% b) 1,081,217 1,109,100 27,883
Electrical 111,105 113,366 2,261 42% 43% 266,652 269,600 2,948
Contract Services 76,667 63,476 (13,191) 42% 34% c) 184,000 168,300 (15,700)
Env Health -On Site Prog 118,263 125,116 6,853 42% 44% 283,830 288,400 4,570
Planning -Current 323,734 301,872 (21,862) 42% 39% d) 776,962 750,400 (26,562)
Planning -Long Range 147,405 105,242 (42,163) 42% 30% e) 353,771 348,600 (5,171)
Total Revenues
1,303,085 1,160,129 (142,956) 42% 37% 3,127,400 3,126,300 (1,100)
Trans In -GF 105,580 105,580 42% 42% 253,387 253,387
Trans In -GF for Lng Rng Ping 215,000 215,000 - 42% 42% 516,000 516,000 -
TOTAL RESOURCES 2,309,746 2,093,740 (216,006) 42% 46% 4,582,868 4,508,718 (74,150)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin -Operations 584,332 574,677 9,655 42% 41% 1,402,396 1,402,396
Admin -GIS 90,056 93,482 (3,426) 42% 43% f) 216,135 168,000 48,135
Admin -Code Enforcement 76,972 76,244 728 42% 41% 184,732 184,732
Building Safety 208,471 201,956 6,515 42% 40% 500,330 500,330
Electrical 78,169 74,157 4,012 42% 40% 187,606 187,606
Contract Services 101,771 99,327 2,444 42% 41% 244,251 244,251
Env Health -On Site Pgm 96,669 122,355 (25,686) 42% 53% g) 232,006 220,000 12,006
Planning -Current 287,621 257,777 29,844 42% 37% 690,290 690,290
Planning -Long Range 205,178 242,657 (37,479) 42% 49% h) 492,427 492,427
Transfers Out (D/S Fund) 72,213 145,000 (72,787) 42% 84% 173,310 173,310
Contingency 108,077 108,077 42% n/a 259,385 259,385
Exp. %
TOTAL REQUIREMENTS 1,909,529 1,887,632 21,897 42% 41% 4,582,868 4,263,342 319,526
NET (Resources - Requirements)
400,217 206,108 (194,109) 245,376 245,376
Revenues 1,160,129 3,127,400 3,126,300 (1,100)
Expenditures 1,887,632 4,582,868 4,263,342 319,526
Net from Operations (727,503) (1,455,468) (1,137,042) 318,426
a) Custom GIS work revenue sporadic
b) YTD revenue is low in relation to budget, it is expected that budget projections will be met, 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
d) YTD business volume/revenue less than expected
e) Grant payments received irregularly
f) Savings due to resignation of CDD webmaster, who will not be replaced
g) Includes $35,651 in time management payout to retired employee, to be made up by salary savings as position will remain unfilled
h) Approximately $51,000 in consultant expense was paid in a lump sum and will be reimbursed through grant revenue
ROAD
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $3,430,429 $ 3,419,603 $ (10,826) 100% 100% $ 3,430,429 $ 3,419,603 $ (10,826)
Revenues
Mineral Lease Royalties 8,333 5,108 (3,225) 42% 26% a) 20,000 5,108 (14,892)
Forest Receipts 932,083 (932,083) 42% 0% b) 2,237,000 2,237,000
State Miscellaneous 40,410 (40,410) 42% 0% 96,984 96,984
Motor Vehicle Revenue 4,166,667 3,538,563 (628,104) 42% 35% c) 10,000,000 9,850,000 (150,000)
City of Bend 114,583 215,049 100,466 42% 78% d) 275,000 275,000
City of Redmond 145,833 250,458 104,625 42% 72% d) 350,000 350,000
City of Sisters 4,167 (4,167) 42% 0% d) 10,000 10,000
City of La Pine 4,167 (4,167) 42% 0% d) 10,000 10,000
Admin Recovery (SDC) - 717 717 42% n/a 1,000 1,000
Miscellaneous 37,500 11,590 (25,910) 42% 13% 90,000 90,000 -
Road Vacations 417 500 83 42% 50% 1,000 1,000
Interest on Investments 16,667 9,729 (6,938) 42% 24% 40,000 40,000
Other Bank/LGIP Interest 61 61 42% n/a 100 100
Parking Fees 375 (375) 42% 0% 900 900 -
Grants -Private 2,434 2,434 42% n/a - 2,434 2,434
Interfund Contract 312,500 234 (312,266) 42% 0% e) 750,000 750,000 -
Equipment Repairs 104,167 61,631 (42,536) 42% 25% 250,000 250,000
Vehicle Repairs 37,500 (37,500) 42% 0% 90,000 90,000
LID Construction 4,167 (4,167) 42% 0% e) 10,000 10,000
Vegetation Management 14,583 (14,583) 42% 0% e) 35,000 35,000
Forester 10,417 - (10,417) 42% 0% e) 25,000 25,000
Car Washes 1,250 1,428 178 42% 48% 3,000 3,000
Car Rental 208 (208) 42% 0% 500 500
Sale of Equip & Material 251,458 182,860 (68,598) 42% 30% 603,500 603,500
Total Revenues 6,207,452 4,280,362 (1,927,090) 42% 29% 14,897,884 14,736,526 (161,358)
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
121,558 72,935 (48,623) 42% 25% 291,740 291,740
83,333 50,000 (33,333) 42% 25% 200,000 200,000
5,017 - (5,017) 42% 0% 12,040 12,040
9,847,789 7,822,900 (1,991,556) 42% 52% 18,832,093 18,659,909 (172,184)
Exp. %
2,397,070 2,240,788 156,282 42% 39% 5,752,967 5,752,967
3,946,260 4,207,812 (261,552) 42% 44% 9,471,023 9,471,023
488,205 488,205 42% 0% 1,171,691 1,171,691
166,667 166,667 42% 0% 400,000 400,000 -
848,505 848,505 42% n/a 2,036,412 - 2,036,412
TOTAL REQUIREMENTS 7,846,707 6,448,600 1,398,107 42% 34% 18,832,093 16,795,681 2,036,412
NET (Resources - Requirements)
2,001,082 1,374,300 (593,449) 1,864,228 1,864,228
a) Mineral lease payments discontinued under FY 2011 Continuing Resolution
b) Annual payment -January 2011
c) Gas tax will increase by 25% ($.06/gal.) effective January 2011 (revised State estimate)
d) Billed upon completion of work
e) Payment to be received in June 2011 from Funds 326, 328, 329, & 340
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $3,430,429 $ 3,419,603 $ (10,826) 100% 100% $ 3,430,429 $ 3,419,603 $ (10,826)
Revenues
Mineral Lease Royalties 8,333 5,108 (3,225) 42% 26% a) 20,000 5,108 (14,892)
Forest Receipts 932,083 (932,083) 42% 0% b) 2,237,000 2,237,000
State Miscellaneous 40,410 (40,410) 42% 0% 96,984 96,984
Motor Vehicle Revenue 4,166,667 3,538,563 (628,104) 42% 35% c) 10,000,000 9,850,000 (150,000)
City of Bend 114,583 215,049 100,466 42% 78% d) 275,000 275,000
City of Redmond 145,833 250,458 104,625 42% 72% d) 350,000 350,000
City of Sisters 4,167 (4,167) 42% 0% d) 10,000 10,000
City of La Pine 4,167 (4,167) 42% 0% d) 10,000 10,000
Admin Recovery (SDC) - 717 717 42% n/a 1,000 1,000
Miscellaneous 37,500 11,590 (25,910) 42% 13% 90,000 90,000 -
Road Vacations 417 500 83 42% 50% 1,000 1,000
Interest on Investments 16,667 9,729 (6,938) 42% 24% 40,000 40,000
Other Bank/LGIP Interest 61 61 42% n/a 100 100
Parking Fees 375 (375) 42% 0% 900 900 -
Grants -Private 2,434 2,434 42% n/a - 2,434 2,434
Interfund Contract 312,500 234 (312,266) 42% 0% e) 750,000 750,000 -
Equipment Repairs 104,167 61,631 (42,536) 42% 25% 250,000 250,000
Vehicle Repairs 37,500 (37,500) 42% 0% 90,000 90,000
LID Construction 4,167 (4,167) 42% 0% e) 10,000 10,000
Vegetation Management 14,583 (14,583) 42% 0% e) 35,000 35,000
Forester 10,417 - (10,417) 42% 0% e) 25,000 25,000
Car Washes 1,250 1,428 178 42% 48% 3,000 3,000
Car Rental 208 (208) 42% 0% 500 500
Sale of Equip & Material 251,458 182,860 (68,598) 42% 30% 603,500 603,500
Total Revenues 6,207,452 4,280,362 (1,927,090) 42% 29% 14,897,884 14,736,526 (161,358)
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
121,558 72,935 (48,623) 42% 25% 291,740 291,740
83,333 50,000 (33,333) 42% 25% 200,000 200,000
5,017 - (5,017) 42% 0% 12,040 12,040
9,847,789 7,822,900 (1,991,556) 42% 52% 18,832,093 18,659,909 (172,184)
Exp. %
2,397,070 2,240,788 156,282 42% 39% 5,752,967 5,752,967
3,946,260 4,207,812 (261,552) 42% 44% 9,471,023 9,471,023
488,205 488,205 42% 0% 1,171,691 1,171,691
166,667 166,667 42% 0% 400,000 400,000 -
848,505 848,505 42% n/a 2,036,412 - 2,036,412
TOTAL REQUIREMENTS 7,846,707 6,448,600 1,398,107 42% 34% 18,832,093 16,795,681 2,036,412
NET (Resources - Requirements)
2,001,082 1,374,300 (593,449) 1,864,228 1,864,228
a) Mineral lease payments discontinued under FY 2011 Continuing Resolution
b) Annual payment -January 2011
c) Gas tax will increase by 25% ($.06/gal.) effective January 2011 (revised State estimate)
d) Billed upon completion of work
e) Payment to be received in June 2011 from Funds 326, 328, 329, & 340
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY%
Coll.
Revised
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 616,371 $ 728,649 $ 112,278 100% 118% $ 616,371 $ 728,649 $ 112,278
Revenues
DOC Measure 57 90,544 217,350 126,806 42% 100% a) 217,305 217,350 45
State Miscellaneous 1,792 (1,792) 42% 0% b) 4,301 4,301
Alternate Incarceration 12,883 30,918 18,035 42% 100% a) 30,918 30,918
State Subsidy 5,417 6,653 1,236 42% 51 % c) 13,000 13,000
SB 1145 1,234,163 1,480,995 246,832 42% 50% d) 2,961,990 2,781,990 (180,000)
Probation Work Crew Fees 15,833 8,071 (7,762) 42% 21% e) 38,000 20,613 (17,387)
Miscellaneous 1,250 1,780 530 42% 59% 3,000 3,000
Electronic Monitoring Fee 70,833 66,108 (4,725) 42% 39% 170,000 170,000
Probation Superv. Fees 87,500 82,710 (4,790) 42% 39% 210,000 210,000
Interest on Investments 3,750 4,397 647 42% 49% 9,000 9,000
Interfund - Sheriff 20,833 20,833 42% 42% 50,000 50,000
Crime Prevention Grant 20,833 12,500 (8,333) 42% 25% 50,000 50,000
Total Revenues 1,565,631 1,932,315 366,684 42% 51% 3,757,514 3,560,172 (197,342)
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
47,930 47,930 - 42% 42% 115,029 115,029
2,229,932 2,708,894 478,962 42% 60% 4,488,914 4,403,850 (85,064)
Exp. %
1,322,190 1,233,383 88,807 42% 39% 3,173,257 3,173,257
372,614 299,963 72,651 42% 34% 894,274 894,274
42 - 42 42% 0% 100
175,535 175,535 42% n/a 421,283
100
421,283
TOTAL REQUIREMENTS 1,870,381 1,533,346 337,035 42% 34% 4,488,914 4,067,531 421,383
NET (Resources - Requirements) 359,551 1,175,548 815,997
a) Annual payment received in July
b) Payment from Parole Board for hearings not yet received
c) Receive payments quarterly
d) Anticipated funding cuts from Dept. of Corrections. Money above opt out
e) Increase in fee waivers from court due to economic conditions
336,319
336,319
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 562,762 $ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578
Revenues
Federal Grants 94,354 123,538 29,184 42% 55% a) 226,450 400,167 173,717
Title IV - Family Sup/Pres 26,563 37,556 10,993 42% 59% 63,750 63,750
HealthyStart Medicaid 39,583 26,212 (13,371) 42% 28% 95,000 95,000
Level 7 Services 107,493 112,094 4,601 42% 43% 257,984 257,984
State Prevention Funds 6,042 6,376 334 42% 44% b) 14,500 17,000 2,500
HealthyStart /R -S -G 128,718 134,805 6,087 42% 44% c) 308,924 263,596 (45,328)
OCCF Grant 251,801 290,050 38,249 42% 48% c) 604,323 544,501 (59,822)
Charges for Svcs-Misc 3,333 1,133 (2,200) 42% 14% 8,000 8,000 -
Court Fines & Fees 31,250 33,156 1,906 42% 44% 75,000 78,000 3,000
Interest on Investments 8,333 2,494 (5,839) 42% 12% d) 20,000 8,000 (12,000)
Grants -Private 2,083 (2,083) 42% 0% e) 5,000 (5,000)
Donations 157 157 42% n/a - 157 157
Miscellaneous 107,731 28,475 (79,256) 42% 11% f) 258,554 118,500 (140,054)
Total Revenues 807,284 796,046 (11,238) 42% 41% 1,937,485 1,854,655 (82,830)
Trans from General Fund 118,470 118,470 - 42% 42% 284,333 284,333
Trans from GF -Other 10,417 6,250 (4,167) 42% 25% 25,000 25,000
Total Transfers In 128,887 124,720 (4,167) 42% 40% 309,333 309,333
TOTAL RESOURCES 1,498,933 1,556,106 57,173 42% 55% 2,809,580 2,799,328 (10,252)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
249,816 211,259 38,557 42% 35% g) 599,559 543,424 56,135
750,570 479,325 271,245 42% 27% c) 1,801,367 1,831,739 (30,372)
42 42 42% 0% 100 100
170,231 170,231 42% n/a 408,554 408,554
TOTAL REQUIREMENTS 1,170,659 690,584 480,075 42% 25% 2,809,580 2,375,163 434,417
NET (Resources - Requirements) 328,274 865,522 537,248 424,165 424,165
a) Two additional Federal Grants will be received in FY 2011
b) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $14,500 grant received
c) Governor's mandated State General Fund reductions in July & Sept 2010. Additional $19,900 grant received
d) Interest revenue projected to be Tess than budgeted
e) Youth conference donations will not be received
f) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received
g) Personnel costs will be Tess than budgeted due to open positions
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 94,354 123,538 29,184 42% 55% a) 226,450 400,167 173,717
Title IV - Family Sup/Pres 26,563 37,556 10,993 42% 59% 63,750 63,750
HealthyStart Medicaid 39,583 26,212 (13,371) 42% 28% 95,000 95,000
Level 7 Services 107,493 112,094 4,601 42% 43% 257,984 257,984
State Prevention Funds 6,042 6,376 334 42% 44% b) 14,500 17,000 2,500
HealthyStart /R -S -G 128,718 134,805 6,087 42% 44% c) 308,924 263,596 (45,328)
OCCF Grant 251,801 290,050 38,249 42% 48% c) 604,323 544,501 (59,822)
Charges for Svcs-Misc 3,333 1,133 (2,200) 42% 14% 8,000 8,000 -
Court Fines & Fees 31,250 33,156 1,906 42% 44% 75,000 78,000 3,000
Interest on Investments 8,333 2,494 (5,839) 42% 12% d) 20,000 8,000 (12,000)
Grants -Private 2,083 (2,083) 42% 0% e) 5,000 (5,000)
Donations 157 157 42% n/a - 157 157
Miscellaneous 107,731 28,475 (79,256) 42% 11% f) 258,554 118,500 (140,054)
Total Revenues 807,284 796,046 (11,238) 42% 41% 1,937,485 1,854,655 (82,830)
Trans from General Fund 118,470 118,470 - 42% 42% 284,333 284,333
Trans from GF -Other 10,417 6,250 (4,167) 42% 25% 25,000 25,000
Total Transfers In 128,887 124,720 (4,167) 42% 40% 309,333 309,333
TOTAL RESOURCES 1,498,933 1,556,106 57,173 42% 55% 2,809,580 2,799,328 (10,252)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
249,816 211,259 38,557 42% 35% g) 599,559 543,424 56,135
750,570 479,325 271,245 42% 27% c) 1,801,367 1,831,739 (30,372)
42 42 42% 0% 100 100
170,231 170,231 42% n/a 408,554 408,554
TOTAL REQUIREMENTS 1,170,659 690,584 480,075 42% 25% 2,809,580 2,375,163 434,417
NET (Resources - Requirements) 328,274 865,522 537,248 424,165 424,165
a) Two additional Federal Grants will be received in FY 2011
b) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $14,500 grant received
c) Governor's mandated State General Fund reductions in July & Sept 2010. Additional $19,900 grant received
d) Interest revenue projected to be Tess than budgeted
e) Youth conference donations will not be received
f) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received
g) Personnel costs will be Tess than budgeted due to open positions
SOLID WASTE
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 392,509 $ 318,001 $ (74,508) 100% 81% $ 392,509 $ 318,001 $ (74,508)
Revenues
Miscellaneous 11,667 10,135 (1,532) 42% 36% 28,000 22,000 (6,000)
Franchise 3% Fees 83,333 13,943 (69,390) 42% 7% a) 200,000 200,000
Commercial Disp. Fees 350,000 391,218 41,218 42% 47% 840,000 840,000
Private Disposal Fees 547,500 618,828 71,328 42% 47% 1,314,000 1,314,000
Franchise Disposal Fees 1,524,583 1,754,475 229,892 42% 48% 3,659,000 3,659,000
Yard Debris 30,417 44,883 14,466 42% 61% b) 73,000 73,000
Special Waste 10,417 40,981 30,564 42% 164% c) 25,000 50,000 25,000
Interest 5,208 3,640 (1,568) 42% 29% 12,500 8,000 (4,500)
Sale of Carbon Credits 33,333 (33,333) 42% 0% d) 80,000 80,000
Recyclables 8,333 19,502 11,169 42% 98% e) 20,000 35,000 15,000
Total Revenues 2,604,791 2,897,605 292,814 42% 46% 6,251,500 6,281,000 29,500
TOTAL RESOURCES 2,997,300 3,215,606 218,306 42% 48% 6,644,009 6,599,001 (45,008)
REQUIREMENTS
Expenditures
Personal Services 666,716 673,755 (7,039) 42% 42% 1,600,118 1,600,118
Materials and Services 1,194,095 1,022,412 171,683 42% 36% f) 2,865,829 2,865,829
Debt Service 404,194 401,732 2,462 42% 41% 970,066 970,066
Capital Outlay 49,167 46,139 3,028 42% 39% g) 118,000 118,000
Transfers Out -Road 121,558 72,935 48,623 42% 25% h) 291,740 291,740
Contingency 332,607 332,607 42% n/a 798,256
Exp. %
798,256
TOTAL REQUIREMENTS 2,768,337 2,216,973 551,364 42% 33% 6,644,009 5,845,753 798,256
NET (Resources- Requirements) 228,963 998,633 769,670 753,248 753,248
a) Franchise fees are received in April. Wilderness Garbage pays monthly
b) Seasonal material - revenue will decrease in winter
c) Bonneville Power did large clean-up of contaminated soil -unexpected revenue
d) No market at this time
e) Markets for recyclables varies throughout the year - usually declines in the winter
f) Larger expenditures (i.e. grinding at $75,000) made intermittently during year
g) Will be expended by December 31, 2010
h) Transfers made quarterly
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 392,509 $ 318,001 $ (74,508) 100% 81% $ 392,509 $ 318,001 $ (74,508)
Revenues
Miscellaneous 11,667 10,135 (1,532) 42% 36% 28,000 22,000 (6,000)
Franchise 3% Fees 83,333 13,943 (69,390) 42% 7% a) 200,000 200,000
Commercial Disp. Fees 350,000 391,218 41,218 42% 47% 840,000 840,000
Private Disposal Fees 547,500 618,828 71,328 42% 47% 1,314,000 1,314,000
Franchise Disposal Fees 1,524,583 1,754,475 229,892 42% 48% 3,659,000 3,659,000
Yard Debris 30,417 44,883 14,466 42% 61% b) 73,000 73,000
Special Waste 10,417 40,981 30,564 42% 164% c) 25,000 50,000 25,000
Interest 5,208 3,640 (1,568) 42% 29% 12,500 8,000 (4,500)
Sale of Carbon Credits 33,333 (33,333) 42% 0% d) 80,000 80,000
Recyclables 8,333 19,502 11,169 42% 98% e) 20,000 35,000 15,000
Total Revenues 2,604,791 2,897,605 292,814 42% 46% 6,251,500 6,281,000 29,500
TOTAL RESOURCES 2,997,300 3,215,606 218,306 42% 48% 6,644,009 6,599,001 (45,008)
REQUIREMENTS
Expenditures
Personal Services 666,716 673,755 (7,039) 42% 42% 1,600,118 1,600,118
Materials and Services 1,194,095 1,022,412 171,683 42% 36% f) 2,865,829 2,865,829
Debt Service 404,194 401,732 2,462 42% 41% 970,066 970,066
Capital Outlay 49,167 46,139 3,028 42% 39% g) 118,000 118,000
Transfers Out -Road 121,558 72,935 48,623 42% 25% h) 291,740 291,740
Contingency 332,607 332,607 42% n/a 798,256
Exp. %
798,256
TOTAL REQUIREMENTS 2,768,337 2,216,973 551,364 42% 33% 6,644,009 5,845,753 798,256
NET (Resources- Requirements) 228,963 998,633 769,670 753,248 753,248
a) Franchise fees are received in April. Wilderness Garbage pays monthly
b) Seasonal material - revenue will decrease in winter
c) Bonneville Power did large clean-up of contaminated soil -unexpected revenue
d) No market at this time
e) Markets for recyclables varies throughout the year - usually declines in the winter
f) Larger expenditures (i.e. grinding at $75,000) made intermittently during year
g) Will be expended by December 31, 2010
h) Transfers made quarterly
RESOURCES:
Beginning Net Working Capital
Revenues
Inter -fund Charges:
RISK MANAGEMENT
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
% of FY
% CoII.
$2,500,000 $2,374,541 ($125,460) 100%
95% $2,500,000 $2,374,541 ($125,460)
General Liability 139,930 139,930 (0) 42% 42% 335,833 335,833
Property Damage 122,508 122,508 0 42% 42% 294,019 294,019
Vehicle 76,129 76,129 (0) 42% 42% 182,710 182,710
Workers' Compensation 377,650 375,212 (2,438) 42% 41% 906,361 906,361
Unemployment 71,015 70,847 (168) 42% 42% 170,437 170,437
Claims Reimb-Workers' Compensation 12,500 (12,500) 42% 0% 30,000 30,000
Claims Reimb-Gen Liab/Property 8,333 16,608 8,275 42% 83% 20,000 20,000
Process Fee-Events/Parades 625 700 75 42% 47% 1,500 1,500
Miscellaneous 833 (833) 42% 0% 2,000 2,000
Skid Car Training 9,167 5,110 (4,057) 42% 23% 22,000 22,000
Interest on Investments 12,500 7,969 (4,531) 42% 27% 30,000 30,000
TOTAL REVENUES 831,192 815,013 (16,179) 42% 41% 1,994,860 1,994,860
TOTAL RESOURCES 3,331,192 3,189,554 (141,638)
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
Repair/ Replacement
Total General Liability
PROPERTY DAMAGE
Insurance 153,414
Repair / Replacement 10,921
45,960
1,010
5,000
133,418
366
250
42% 71% 4,494,860 4,369,401 (125,460)
% Exp.
166,667 186,003 (19,336) 42% 47% 400,000 380,000 20,000
Total Property Damage 125,000 164,335 (39,335) 42% 55% 300,000 270,000 30,000
VEHICLE
Professional Service 1,599
Insurance 390
Loss Prevention 4,529
Repair / Replacement 20,859
Total Vehicle 50,000 27,376 22,624 42% 23% 120,000 100,000 20,000
WORKERS' COMPENSATION
Settlement / Benefit 260,597
Professional Service 5,000
Insurance 52,975
Loss Prevention 18,415
Miscellaneous 10,726
Total Workers' Compensation 270,833 347,713 (76,879) 42% 53% 650,000 750,000 (100,000)
UNEMPLOYMENT - Settlement/Benefits 66,667 98,778 (32,111) 42% 62% 160,000 320,000 (160,000)
Total Direct Insurance Costs 679,167 824,204 (145,038) 42% 51% 1,630,000 1,820,000 (190,000)
Insurance Administration:
Personal Services 120,605 118,805 1,800 42% 41% 289,453 289,453
Materials & Service 95,348 68,641 26,707 42% 30% 228,834 228,834 -
Capital Outlay 42 - 42 42% 0% 100 100
Total Insurance Administration 215,995 187,446 28,549 42% 36% 518,387 518,287 100
Contingency 977,697 - 977,697 42% n/a 2,346,473 2,346,473
TOTAL REQUIREMENTS 1,872,858 1,011,650 861,208 42% 23% 4,494,860 2,338,287 2,156,573
NET 1,458,333 2,177,904 719,570 - 2,031,114 2,031,114
Year End
Budget
Projection
Variance
95% $2,500,000 $2,374,541 ($125,460)
General Liability 139,930 139,930 (0) 42% 42% 335,833 335,833
Property Damage 122,508 122,508 0 42% 42% 294,019 294,019
Vehicle 76,129 76,129 (0) 42% 42% 182,710 182,710
Workers' Compensation 377,650 375,212 (2,438) 42% 41% 906,361 906,361
Unemployment 71,015 70,847 (168) 42% 42% 170,437 170,437
Claims Reimb-Workers' Compensation 12,500 (12,500) 42% 0% 30,000 30,000
Claims Reimb-Gen Liab/Property 8,333 16,608 8,275 42% 83% 20,000 20,000
Process Fee-Events/Parades 625 700 75 42% 47% 1,500 1,500
Miscellaneous 833 (833) 42% 0% 2,000 2,000
Skid Car Training 9,167 5,110 (4,057) 42% 23% 22,000 22,000
Interest on Investments 12,500 7,969 (4,531) 42% 27% 30,000 30,000
TOTAL REVENUES 831,192 815,013 (16,179) 42% 41% 1,994,860 1,994,860
TOTAL RESOURCES 3,331,192 3,189,554 (141,638)
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
Repair/ Replacement
Total General Liability
PROPERTY DAMAGE
Insurance 153,414
Repair / Replacement 10,921
45,960
1,010
5,000
133,418
366
250
42% 71% 4,494,860 4,369,401 (125,460)
% Exp.
166,667 186,003 (19,336) 42% 47% 400,000 380,000 20,000
Total Property Damage 125,000 164,335 (39,335) 42% 55% 300,000 270,000 30,000
VEHICLE
Professional Service 1,599
Insurance 390
Loss Prevention 4,529
Repair / Replacement 20,859
Total Vehicle 50,000 27,376 22,624 42% 23% 120,000 100,000 20,000
WORKERS' COMPENSATION
Settlement / Benefit 260,597
Professional Service 5,000
Insurance 52,975
Loss Prevention 18,415
Miscellaneous 10,726
Total Workers' Compensation 270,833 347,713 (76,879) 42% 53% 650,000 750,000 (100,000)
UNEMPLOYMENT - Settlement/Benefits 66,667 98,778 (32,111) 42% 62% 160,000 320,000 (160,000)
Total Direct Insurance Costs 679,167 824,204 (145,038) 42% 51% 1,630,000 1,820,000 (190,000)
Insurance Administration:
Personal Services 120,605 118,805 1,800 42% 41% 289,453 289,453
Materials & Service 95,348 68,641 26,707 42% 30% 228,834 228,834 -
Capital Outlay 42 - 42 42% 0% 100 100
Total Insurance Administration 215,995 187,446 28,549 42% 36% 518,387 518,287 100
Contingency 977,697 - 977,697 42% n/a 2,346,473 2,346,473
TOTAL REQUIREMENTS 1,872,858 1,011,650 861,208 42% 23% 4,494,860 2,338,287 2,156,573
NET 1,458,333 2,177,904 719,570 - 2,031,114 2,031,114
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Five Months Ended November 30, 2010
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 2,649,009 5,426,761 2,777,752 42% 85% a) 6,357,621 6,357,621
Property Taxes - Prior 57,500 187,415 129,915 42% 136% 138,000 187,415 49,415
Federal Grants 197,500 (197,500) 42% 0% b) 474,000 647,395 173,395
State Reimbursement 4,167 8,921 4,754 42% 89% 10,000 20,921 10,921
Telephone User Tax 229,167 216,782 (12,385) 42% 39% c) 550,000 550,000
Data Network Reimb. 5,000 1,528 (3,472) 42% 13% d) 12,000 12,000
Jefferson County 12,917 29,307 16,390 42% 95% 31,000 31,000
User Fee 20,833 45,869 25,036 42% 92% e) 50,000 45,869 (4,131)
COPS Reimbursements 12,500 (12,500) 42% 0% d) 30,000 30,000
Contract Payments 29,167 (29,167) 42% 0% d) 70,000 70,000
Miscellaneous 3,542 5,478 1,936 42% 64% 8,500 8,500
Interest 16,667 19,932 3,265 42% 50% 40,000 40,000
Interest on Unsegregated Tax 833 518 (315) 42% 26% 2,000 2,000
Total Revenues 3,238,802 5,942,511 2,703,709 42% 76% 7,773,121 8,002,721 229,600
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services 1,670,333 1,513,487 156,846 42% 38% 4,008,798 3,878,798 130,000
Materials and Services 635,060 547,224 87,836 42% 36% 1,524,144 1,524,144
Capital Outlay 234,583 79,163 155,420 42% 14% 563,000 563,000
Transfers Out 422,525 754,061 (331,536) 42% 74% f) 1,014,061 1,014,061
Contingency 2,718,522 2,718,522 42% n/a 6,524,453 6,524,453
9,100,137 12,634,456 3,534,319 42% 93% 13,634,456 14,694,666 1,060,210
% Exp.
TOTAL REQUIREMENTS 5,681,023 2,893,935 2,787,088 42% 21% 13,634,456 6,980,003 6,654,453
NET (Resources - Requirements) 3,419,114 9,740,521 6,321,407 - 7,714,663 7,714,663
a) Approximately 85% of the year's property taxes are collected by November 30, 2010.
b) Two grants 1) EOC - billed EOM $210,000 in December 2) CAD -to -CAD - billed EOM $79,163 in December
c) Received quarterly (Nov, Feb, May and Aug) for fiscal year
d) Yearly agency billings will be mailed out in December
e) Crooked River Ranch paid annual fee
f) Transfers made as requested. Transfer to New Facility Property Fund, $754,061, made 9/15/10 & Transfer to Reserve Fund, $260,000,
will be made in 3rd Qtr
Health Benefits Trust
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Revised
Budget
Year End
Projection
Variance
RESOURCES
Beg. Net Working Capital $ 16,400,000 $ 16,988,140 $ 588,140 100% 104% $16,400,000 $16,988,140 588,140
Revenues:
Internal Premium Charges 4,685,833 4,755,996 70,163 42% 42% a) 11,246,000 11,403,534 157,534
P/T Emp - Add'I Prem 20,833 17,216 (3,617) 42% 34% 50,000 40,000 (10,000)
Employee Prem Contribution 208,333 202,395 (5,938) 42% 40% 500,000 485,000 (15,000)
COIC 406,250 588,447 182,197 42% 60% 975,000 1,125,000 150,000
Retiree / COBRA Co -Pay 187,500 311,294 123,794 42% 69% 450,000 560,000 110,000
Prescription Rebates 46,718 46,718 42% n/a 46,718 46,718
Interest 41,667 54,243 12,576 42% 54% 100,000 130,000 30,000
Total Revenues 5,550,417 5,976,310 425,893 42% 45% 13,321,000 13,790,252 469,252
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
Workplace Clinic
Healthstat
Equipment
Remodel
Miscellaneous
Other
Total Materials & Services
Capital Outlay
Contingency
21,950,417 22,964,450 1,014,033 92% 77% 29,721,000 30,778,391 1,057,391
Exp. %
53,867 51,117 2,750 42% 40% 129,280 129,280
5,187,581 4,675,327 512,254 42% 38% b) 12,450,194 11,050,772 1,399,422
779,740 658,100 121,640 42% 35% b) 1,871,377 1,555,510 315,867
(28,250) 28,250 42% n/a (28,250) 28,250
137,500 140,762 (3,262) 42% 43% 330,000 330,000
31,250 62,429 (31,179) 42% 83% 75,000 75,000
125,000 123,796 1,204 42% 41% 300,000 300,000
16,667 16,540 127 42% 41% 40,000 40,000
21,250 21,165 85 42% 42% 51,000 51,000
95,633 31,490 64,143 42% n/a 229,520 229,520
6,042 6,042 42% n/a 14,500 14,500
41,667 12,159 29,508 42% n/a 100,000 100,000
31,417 406 31,010 42% n/a 75,400 75,400
62,975 18,300 44,675 42% 12% 151,141 151,141
6,536,722 5,732,225 804,497 42% 37% 15,688,132 13,944,593 1,743,539
100 100 42% 0% 100 100
5,793,120 5,793,120 42% 0% 13,903,488 13,903,488
TOTAL REQUIREMENTS 12,383,808 5,783,342 6,600,467 42% 19% 29,721,000 14,073,873 15,647,127
NET (Resources - Requirements)
9,566,608 17,181,108 7,614,500 - 16,704,518 16,704,518
a) Year End Projection is amount appropriated in operating departments' budgets.
b) Projection based on annualizing 22 weeks of claims paid. YTD actual is an average of $241,144 per week.
Deschutes County - Fair and Expo Center
YTD -Budget Basis Commissioners
Statement of Financial Operating Data
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
RESOURCES:
Beg. Net Working Capital $
Receipts:
Special Events Revenues
Interest
Storage
Camping at F & E
Horse Stall Rental
Concession °A) - Food
Rights (Signage, etc.)
Interfund Contract
Miscellaneous
Total Receipts
2,809 $ 6,590 $ 3,781 100% 235%
282,393 358,192 75,800 42%
833 554 (280) 42%
21,250 12,716 (8,535) 42%
3,750 440 (3,310) 42%
17,500 255 (17,245) 42%
87,917 99,722 11,805 42%
38,750 14,000 (24,750) 42%
18,750 - (18,750) 42%
1,839 12,303 10,464 42%
472,982 498,182 25,200 42%
Transfers In
General Fund (001) 82,466 82,466
Room Tax (160) 10,364 10,364.25
Welcome Center (170) 33,334 33,334
Annual County Fair (619) 96,347 100,000
Reserve Fund (617) 42
42%
42%
42%
3,653 42%
(42) 42%
Total Transfers In 222,552 226,164 3,612
53%
28%
25%
5%
1%
47%
15%
0%
n/a
44%
Year End
Budget
Projection
Variance
$ 2,809 $ 6,590 $ 3,781
a) 677,742
2,000
b) 51,000
9,000
42,000
a) 211,000
93,000
c) 45,000
4,414
697,192
1,721
31,716
9,440
38,255
189,722
94,000
45,000
16,179
19,450
(279)
(19,284)
440
(3,745)
(21,279)
1,000
11,765
1,135,156 1,123,225 (11,931)
42% 197,919
42% 24,873
42% 80,000
43% d) 231,232
0% 100
TOTAL RESOURCES 698,343 730,936 32,593 42% 44%
REQUIREMENTS:
Expenditures:
Personal Services
Materials and Services
Debt Service
Capital Outlay
Total Expenditures
Transfers Out - Reserve Fund
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
388,289 371,861 16,427
198,619 233,122 (34,504)
48,151 72,061 (23,909)
42 42
635,100 677,044
4,167 10,000
57,437
42%
42%
42%
42%
Exp. %
40%
49%
62%
0%
197,919
24,873
80,000
175,000 (56,232)
100
534,124 477,892 (56,232)
1,672,089 1,607,707 (64,382)
931,893
e) 476,685
115,563
100
915,465
525,189
115,563
16,428
(48,504)
1
100
(41,944) 1,524,241 1,556,217 (31,976)
(5,833) 42% 100% 10,000 10,000
57,437 42% n/a 137,848 137,848
696,704 687,044 9,660 42% 41% 1,672,089 1,566,217 105,872
1,639 43,892 42,252
41,490 41,490
a) Revenue unusually high in July and August due to BMW and FMCA events.
b) Most storage activity begins in October.
c) Interfund contract revenue is for park maintenance, from Fund 130
d) Cash flow from Fair 2010 is projected to be $57,000 less than budgeted
e) Year to date amounts include costs associated with BMW and FMCA events and expenditures for HVAC repairs.
cA
E-1
C..)
W
ti
0
a
a
a
<tE-1
EN -1.1
A't
Oh
•
Secure Treatment Facility
•
Bethlehem Inn
•
z
0
1-
0
W
O
d
H
J
1-
H
0
..
N
�
o
RESOURCES:
1-O)
0))O
TrN
N
Co
rs
CO
0)
00
09
Co
rs
CO
0)
CO
M
CO
Total Resources
CO O O N CA N CO VI if) N
CO CO M tO C7 O O VI 0 CO CO
NO 0) c.) co co
O) CO Lei CO tri O — CO t�
CO — M a)
t() r
CO
1C)
O
ti
"C)
I
o
u) V
a) t
U
w' o y u)
U z EL) a CI) c cu
✓ aS
m ..
�_ *u) u) a) L E > H a) O
CI) ' a) a) a) O > > 2 CO >
W V co w a W '. '` U .a `O «
0 m U E rn ca o as - a? E Rs
�•
Hoc cmc ca rntoO �g o a) a)
Zw C C C9 C a) U t_ us .N CO
�t vi a) = 0 0
L � O a) ip a) c �
I—
CL-2 2 c a) N 4) u) N 'CC w • 'C . - N L. 0
W�QWI- aCCWQanMO Uz0
Total Expenditures
0)
M
O
01
m
z
N 00.1N1- ti) (NI NOMNOL()1-(OO‘cf ‘cf NO(OON 01� 03 NOM(oQ)MO
0) cr ti 03 1- O I- N 0 CO LL) r) 0) cr M I,- M N I,. (O 4- VI (O 4- N CO N 03 (O 0) 0) 1— N C) N
O) (0 N- 0) M 0) I- 0) L!) 441 0) L[) 0 Ln 't 1—'t (0 (O LO h. CO cr Ln O I� (O Ln N N- 0 (O 0
1- N N 44 44 1- Ln , (o , O O (O M N O CON M CV) O Ln O N O N N (O O) (O M I -
(VO (0 N N CY) CO 1— N N 4- A A. 1- (V 1- 1- 1- 1-
CO
r)
Ln
Ln
N
CO co cco 07
O•cr fn O O 00 N
(O .. (o N
Z M 0106.-.:.. Q (O M
0
CN N _ O O)
W �. co N
LC) Efi O O M U O N Lvj
ti� a0 0 ��N �N_Ln O Ffl �crj00 O LM
0LL 2
o O _ > O EA .�
'5'WN r (O �069��N"O O��o MO
aOUM �o o (V N� w y y 00� �0o �0)�((0 0co
))
o .. ISN O O 0 0 4 p (O ,SEA CO
:-. u) to co p �O,(o Ea 'Tr c`� lao o�l�CD \Com O o� moe'
O.
E " O c 0 O 00 O to
C N (OO C o o 0) or O
1-
0 co > CN
O O(o� O CN
co
Oo, 6._,U y 3 y� 0 co -.y o(Oo(o O�4-o
V U p O(ootS N O N���(Oo��� a)�� c c_ O O CC N� CO^o o O tn�o U Oo(0
O Z? Ofra Ems, —12e 7 y� pN �CD O C N C- Oo G. c O Uo 000 O C)C(01 Oo�U(o y
d� O (o w a) _,c >`�o Es N p yo 'O_ E -C• p(.Z No !'00�� c.2 C(0
N co EA O y C C f/1 (o ," o p 0 U O U O 0-a) V) t (0 7 .� y (0 co (0
1-17 m Q V o >` CO CO O N CO p o O O p> y p U (o V) C y O t fp) O C O w
Oo co T C C O co C o CD 0)) (coo N `O p- 2 0 7 p) ` c O y 0 0 0 c CM U w C O N 11.3
(o .0 D V p 0 (o C y U d vi N m -7.:5 `).(7)Y O N N L 'N O s O N
�)• Z CD
CD
j N N �� V N C O L C cow
V t ` w V U O • j �.Q
N W U O y N N C ea O "- N C 0 co C p 3 U D C 'C U C
O f0 c - N N o b'=. w 4, c N T 0- C C.> .0 (0 O O N C I L p 0
�«3 � 0s g co 20 I- 0 7 c 3�0 .S w � 2 0 E m 3 �? x p...7 o rn
U O co c c T .c w w U Y d ci o U .� U U v m E U v U v Q v ci t
O v P = U O r •0 N y y y y O N O y y 0 .N 7 .N U
N
CD • - v'5 5.— co m:�5(.1)5 QO�Li.-2a220WF-CCO=22QW zOa
C E2<<<DrLL=O,N Cf) •ctLn1�OD0)1- LI) I-O0)4-NM�(0000)0 ''L()(OI� TO-
1. -
0U
Engineered Structures Inc
Total Engineered Structures, Inc.
Total Encumbrances & Commitments
(O
O
v
c
NJ
O
CO
y
c
7
LL
>, 0
O (Ni
>, 0.
O p
7 d M
O .0
8
U
a) v
cooE)E
>
0 Z
Cn v
CD C rn
m
(o O
L
r
U
a)
O
0
n
0
PROJECTION
-J
1-
H
0
U
c
O
U a)
a) �p
OO
0
tl)
U
c
23-
z 0
U
c
w
CA
C
a)
E
E
E
O
0
CXj
c
(o
U
41)
a)
O
c
a)
0.
w
RESOURCES:
Nr
N N
(D N ' O
M N. N --
CV N
0 0 N
M O O N
(0000
M (() M N-
O
C.0
N
0 N 0 0
0 CO 0 0
0 N 0 0
O N M LO-
U) r- M CO
N CO
M N
0 N
CO 0 N
COCO00
M CV) M N
N
M N
co
b
co
''e1
co
''e)
co'
N
(O
N
O
N
(O
(O
0 N
M 0 N
CO CO 0 0
CO. CX) M N
N M
M N
Total Resources
N oD (0 N 40 a0 O
M r- O) a0 co r- a00
O) N N (f) .— M
N CO CO O N (D N O (1) CO 0 O O
"cr 0)MO(00)(00(0 r- (NI
(n 0 CO CO CO O CO CD 0 N
(0'- (V ON r-'-tri'-'-(.O
CO (f) N 0) N 0)
N (n
0 CO
0 0)
O
� r
LO
N
0 0
0 O
0 0 0
' 0 0 0
OLO
CO
O O
N 0) CO O N (O N CO in co O N- CO
(n M , (D 0) CO CO CO r- O) N
(n 0) et 0) CO CO CO (L) et CO CO CO
C O N N 0)) (C) N CO
N
M
Cb
N 0 CO O N CO N CO LO CO 0 N- (n
(n M ,. co O) co CO co r- O) a0
(() O O) co CO 00 (n CO CD CO rs
(OO- ONt- -(f)— O)
CO N O) N
N .— (n
Cr;
0
O)
M
O)
(L)
O)
(L)
CO
CO
CV -
0) 0)
O
O
M
N
M
0
O
O
0
O
r O O
r " O '
(ti
N. O M (C)
co N
0)
40
(000000)
0 0 0 0 0 CO
CO et O O O co
O N- (O (C) ‘-
o
O M M N. N.
r- N M (1')
N
r- 0 0 0
La ' ' O O O
Off) MI.N
(f) CO (f)
M
0 N LO LO
CO ' CO O
06 137
N
M
N
N
0
CO
O
co
(0
Cs-
Cs -
CO
d
O
(0
Cs-
Cs -
LO
N
(l)
'1)
r -
co
CD
O)
'1)
CO
O
1�
N)
O)
CO
CO
N
CO
O
(6
O
O
O
to:
(1)
0 ' r- u).-
CO ONO O CA
�
O OO 'n
COO CO et M 4
N 4. K)
cn
a)
7 a)
v) X v
co
U c U C7ts m c
0Z E a) ey - E coo
c 0 U a, -« °� c N> 7
CO 0 y 0) :15 a) 4)> c a) CIS 2 0
U),a ao u)i rn ,tf as aEi v nO
W 0 c cn Q LL c v > x E co
cc z o c ani 0 E rn C� V C° 7) ate) C]. °a rn Cv
H .'� 2v v t•N ,,...=e. m� cw E m o oc�
G m e c c a 0).('5 - so O U a-) a) w O
dm 2 c iii. c aa) m m C�) ao) v m w e F-- `� a) c o c y Fo-
WCO �QwH d C CLLQa W 2 0 m
UZ OOULLH
Total Expenditures
CO
N
O
co
O
')
CO
N
O
CO
m
Z
PROJECTION
OCD
CD
t N
>. C
a M
LL
O
0
U _o
u) a) E
O a)
t O
(U �Z
!"
a) L
p v)
0 2
L
r H
O)
O
1-3
a
(0
O
d
CO
U
a)
E
O
WV
oes
RESOURCES:
� N �
CO CD Tr
CD N
CD
N
Tt O a—
M O
CD O O
L.6 r---
1.0
(C') O CD
N
M
O N
O CD N O
CO ti CD
1.6
N CD
M
M
CD CD O
M CO -
1.0
C MCD
N
M
� r r
CDCCDDO
M CO- I-
LO MCD
N
c�)
1 -
CO
CA
r
CO
N
10
ti
CO
10
N
ti
N
CO
N
ti
CO
0)
CO
C)
0)
CO
C)
CO
M
CA
CO
C'7
Total Resources
EXPENDITURES:
N O) CO O N CD N CO (f) CO CA
LO Cr) 1— CD CA CO CD CO cr COa)
Cr)1.0 cr CA CD CD co to Tr co M
CD COO O N N- it; (D
co N Cr)
N
(0 O
O Z 2
v) c 0 U w
(0 ) to cA '
U E
N 0) v) ea 7
U co w d (1
gV E 0
ea U c ca 0 "O U a) 'N
i$ - c.c13) ,E ma -c c O
C a) 0
of O V N c a) = a) > .4=-•_ C
m a) 0)
COa`w1-a = =u_aaD2
2,600,059.50
(o CO
c +.
a) 3
o E O
r
, 2 -O O` 0.
cc w _E U
C
O 0 ate) a) r
aa)(e-
cl—
ZDOc0
Total Expenditures
N
CO
CA
ti
10
d
Z
C/)
H
z
w
O
c N
�O O
)N
Z
d Cn CD
.o o
ro Z Z
O
r- <
CA
U
z
w
Amount Paid
Description
O
c
c
a)
Interior modular walls
Herman Miller
OI- COO -O I, CO COO NOO 0000 N O OD r to COIF M I-CA7 000 _O CO 00M
M CO M M CA r 0 CO CA Is ts N OCA 00 N M CA 7 7 0 r I� in N Is N N 7 M OCA N CO r Cn
CA CO_ M CA O Cn O O Cn r CO_ O r N M M 0 0 0 [T 00 r M 7 CA r N 7 7 N Is O O N O O
r N CO v 00 00r [T O [f r0 7� CO 7 0 00 N- C•1-‘- 00 N N- M N 1. N CO M F- N tri 00 N- M
I� M r r r rr r
O r
N
M
co to
O
to
M M N
16 M
to '1' O N O
EA
CV -
ca O r co o p O) 7 r. to
O 00 7 v0 0 c
O
CD M O N a) [T p o O O v O CA
Nef,
• Y O V o O E N O ea
c CO 7 O p p O o �v�CA o c O co Cf c0 a CV O
0c,a) o o ro UO O co YO co 3 0 o c 0 O C No o SR CA 'O • t O[T
v E .12 ...„7.
cN ��cvcE E.�� :zr�0 E CD cm',cn 000 Q) c
ea f7rO oM _
U
r v
co co
0 co T ( O to \ 0 Q 0 0 .5 p 0 0 CO) N 0 0-0 a) a) L O CA c .0.•
o w cj0 2° vc I-a)emU� m�Q'•DE'5Qpccaa))Cn " 3 c 13-
v V _ O of C v 0 Q. co 3-0-0-, co U to O 'a y C U co CO C y 0- L °5 U
7 Cn O N c 0 N O o• Co N O L (o f7 U U2 11 E CA U N c a)
7 N rno w U c' C C)2 CO 2 2 E co U aa)) 0 m ccw O C C U 2 c w 2 �`
�Uc3 �_ Uo)n
m- cots m o� o yr -0 co c�� To c, ,Ver- 2'
cPE m c c 02 mLL c o w �� o O
�y�yV�E�2 U�CD EU�m2 > 2.r;°8>�mm3axiotSm�oN�8 c
-w c �,E�, ci-a)m m ci ' (UOU U mU C
UO N ad v N4-Ymu)na<82QN88Le2 �d21-�j
CO
O
~
C O
N
_TW_
>+M
UJ
Cr) 2E
CL CD
cI) c s
aL- Cr)
0
ass
zI-
1
PROJECTION
0
0
.)
CU f0
O o
Encumbrances
& Commitments
RESOURCES:
O O a-
0
CO 0-3
O O
O O C3) 01
M O 1�
M O
N CO
N N
O
O CO
O ' C3)
M
CO
O
O
O
CO
00
01
ti
i)
m
c
Total Resources
EXPENDITURES:
Materials & Services
O O O
ti CO
CO O
- O O
• r 0)
O O O
N. 01 CO
CO'
� r M
- O CO
O CO
I� Cr)
CO CO
- M
CV LOA
O CO
ti 0)
CO Cr)
- M
CV 0
O
O
O
O
O
N
CO
8
O
Furniture & Fixtures
ti
N
co
co
c
W
U_
off$ C
E
0
O CA U
O c O
� �w
0
N L `)
Y
W • O LL
Cn 0
1) p
E W 10
ON
o. E E m 0
E Ecl) 75
>, T N > v) .o
_o p1 006 y:co
U
O C O c Y 5
1) 'C7 _co 7 O ` te+
coca
Total Expenditures
0)
z
Co Z
ow
c H o
7 M r-
M N
>,
0cc9
QD
O <
E
w
5 0 Z
Z 15
0E3co
z
'U
Z
W
Amount Paid
Description
CO '
ti
Radio Dispatch System
U
C
C
2
N
PROJECTION
U
ca
LL
U QJ
m p)
O "D
Encumbrances
& Commitments
RESOURCES:
(O M CO
UD 1:3)' (+) O CD
N: O O
co
0 co CO co
c) et CO
00%-0 a)
O O N O O
co 0 N
N n
0 0 0 0
0 0 0 0
O O O O
M O N O
10
1n n
O M CO M
M O M Nr CO
0 0 T- 0 0
1O 0 N 0 0
(D O N T-
'4' 0 C,) CO co
-
ti
0)
M
1A
O
N
O
O
O
1A
N
N
�0C)COco
M O M CO
00,-00)
O N O O
co O N
a y
U)
U
m
U
C
10
(0
y
tl) a.. --:-.,
O a
H
lii C >'
rnm
d m 7
C C
'D W >
u C c y m
O C
c m y m m
ca co mC C
-1(A HD C
Total Resources
T- C) M
O (O .— O
CO
N O M
O
M
7.1
(D O O) co N.— a) O M n (3)
0) CO O (D O) (D a 0 0 co
a) M O r- M o 0 O co CO N
OOCD- COOM1nMNn
N N N
T- T-
O O O co
(D O) O O
00C) ' MNO' O'
N: O) N O O (D N
(0
O)
C) COD 0 D
MT- C0 D '4 M O.—
M O n M N 0.C)(0 N
O0)(DCOOa-NM.— r -
CO N '— O
LO
CO N
n
O N
M (D 1f) O) N CO O O) N M N- O)
MCOf-.—(D1[) T- Cr)
COCr)
M
CO01 Nf-M� -a- CD
O) O) M CO O .- N M '- f-
f� N — 0
O
O)
O
N
M
M
0
O
n
O
1f)
C)
CO
(D
N
CO
CO
O)
M
O
N
CO
O)
CD
M
(D
T-
0
O
N
O
CO
O
N
CO
C)
CO
T-
M
(0
T-
M
M
M
st
00
0)
CO
TmM
(D
T-
O
O
N
O
CO
O
N
Co
C)
CO
T-
T-
co
-
T -
M
M
M
0
0
0
M
O)
0
0
O
M
O)
0)
N
O
N
(O
coco
0)
(O
0)
O
O
O
11)
N
N
0)
O
N
0)
co
y
Urn N E 0
lY v
m O E a) m >,
Z '7 N y Go r
0 p) to (1) • V 0 a) 3 C y
N 'y a) a) - vs Q LL m
U m 0) °� M is L.
w Z 0 m w a N'
IX a) m CRNa) U ' U
CN pO. Ip .O *-
C
Foes ii
E al -aa '( o 5 V O(%i a
0 y C 7 C -t y U Q` L
Z x
t ` m t ui >= c C m y w LL
W rn> if m m •c > w c h m_
o. -a) +— a) C "O w C H O C Q a+
�( 1CQ W WJE �LLD.Q�aF- 1p0 L. 0 m
W Z 0 V- H Z
O
M
CO
N
O
LO
� a)
' O
U) �
O O.
U L-
U O
C N
10•Q
m
tl)
N >
-o m
a3
O
O) m
O
M
Co 1 -3 -
Ni v
Eft
' '-
to a-
ll -0
C C
O
LL
C ..
0 0)
C U
7 >
U O
O w
O C
O �
O O
N U
MiT3 -a
-p
>
_oO O
n
O U
m C
7 of
a o
a)rn
U U
C ,
m -6
7
y M
- M
O cNi
0 Ef? N
U N
a)C
-C .2
y U CO(D
a) c, (.0
y N
U c 0
2<o
O O (0
CmN
m .Q
CA
L)
d
LL
a) (/)
Ow
2O
> I= o
O.e N
ce O M
NU
0 0
Z
Q
N co O
W Z
Z m
Q' O
m L
F-
-5
oZ
EW
co
0
(n
CD
0
C a)
N
CD
Amount Paid
Commitment
C
0
E
c
O
Q
0
co
a)
0
LO1.0
N
N LC)
O O
O O
O O
O I-
O
O
O
ti
N-
NLOv
O N CO
M N- CO
M N 'cr
O CO LO CO
LC) O ti M
M r N M
M N M L[)
N r
O 0 0 O O CO Q) CO co CO M N- N N r 0 Q)
LO CO O O co N- Q) CO CO O CO CO T' 0 Q) CO
M LL) O O O Q) 'V' 0) CO 0) CO CO CO O CO CO 0
M(0 CO O N- N O M N. r Q) N- Q)
N N Q) r CV r N CV N N r r
M
r
cr
co
ca
>, c
f0 0)
3 'y co 0
a) Y w p) '�
C Q
x0 3 L c o o= 0 E
O 0) 0 L c -
O c0 c0 o •- Y V a) C a) 0 a)
C c_ Y c c in _
o .13)C 00--2. > L
>, a) V O O
N 0 Jo
m 3 13 m C Q N o
v) v, y v v, o c > _o
U Q 0 N O O Q co O O O` 76 `
5 X a. 0 C - O C.f0 (Di) a) L - cp
a) a) L O o• U - n
CO N (n O a) U 3 N N8 'CI N
(13 rn a)
v10i c'nc(j S E cco 0'c-0 05>,ot 0.0 a).-
=
m
as s ` co m 5 y 0 c0 >, >,
L C N N 1% a) c0 C T Cn o E� >, Y N N
2•E •rnc m 8 5 c '-`2 Pa yQ m E co N$ io io
m C co n� o m scow. —>L? as —: 3 3
QCe WJ(n< 0u_0 um221—n.02(n(n(n
a
3
2 2 2 2 2
7 7 0 7 0
a)) a) a) 0 >.
a
0)'C
L L L 1E .c 0
N U
QQ QQ�(n
a) a) a) a)C
0 o o o p 0
00c 00c CO N „o,C
C C C C co 0
EL- d d d o< 2
O r
CV M LO CO f� O 4C4;
r r
a) a) a) a) a) a) a) a) a) a) a) a)
X00 0000000000
0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0)
m C C C C C C C C C C C C
cc, N c0 f0 00 00 00 N 00 CO 00 00
5--
j00 0000000000
r
d
N
r
CA
Q)
CO
N
CO
LOr
Total HSW Builders
Deschutes County
Bethlehem Inn (Fund 128)
Five Months Ended November 30, 2010
Year to Date
Budget
Actual
Variance
FY %
CoII. %
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
Total Revenues
1,192,083
1,192,083
- (1,192,083) 42% 0% 2,861,000 - (2,861,000)
- (1,192,083) 42% 0% 2,861,000 - (2,861,000)
TOTAL RESOURCES (1,532,917) (2,722,510) (1,189,593) 42% -2002% 136,000 (2,722,510) (2,858,510)
REQUIREMENTS:
Expenditures
Debt Service:
Negative Interest Revenue
Interest Payment
Exp. %
15,000 9,065 5,935 42% 25%
36,000 36,000
41,667 41,667 42% 0% a) 100,000 100,000
TOTAL REQUIREMENTS 56,667 9,065 47,602 42% 7%
NET (Resources - Requirements) (1,589,583) (2,731,575) (1,141,992)
a) November 2010 interest expense - $1,371.03
b) Recap of expenditures - inception through November, 2010
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 213,662
Total expended $ 2,731,575
136,000
100,000
b) - (2,722,510) (2,758,510)
Year End
Budget
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
Total Revenues
1,192,083
1,192,083
- (1,192,083) 42% 0% 2,861,000 - (2,861,000)
- (1,192,083) 42% 0% 2,861,000 - (2,861,000)
TOTAL RESOURCES (1,532,917) (2,722,510) (1,189,593) 42% -2002% 136,000 (2,722,510) (2,858,510)
REQUIREMENTS:
Expenditures
Debt Service:
Negative Interest Revenue
Interest Payment
Exp. %
15,000 9,065 5,935 42% 25%
36,000 36,000
41,667 41,667 42% 0% a) 100,000 100,000
TOTAL REQUIREMENTS 56,667 9,065 47,602 42% 7%
NET (Resources - Requirements) (1,589,583) (2,731,575) (1,141,992)
a) November 2010 interest expense - $1,371.03
b) Recap of expenditures - inception through November, 2010
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 213,662
Total expended $ 2,731,575
136,000
100,000
b) - (2,722,510) (2,758,510)
Engineering Contract
G. Friesen Associates, Inc.
Original Contract
Change Orders:
Change Order #1 (Note a)
Change Order #2
Change Order #3
Total Contract
Amount Paid
Through June 30, 2010
July 1, 2010 through November 30, 2010
Balance Due
Construction Contract
M A DeAtley Construction Inc
Original Contract
Change Orders:
Change Order #1
Change Order #2
Change Order #3
Change Order #4
Change Order #5
Change Order #6
Change Order #7 (not likely to occur)
Change Order #8
Change Order #9
Change Order #10
Change Order #11
Change Order #12
Change Order #13
Change Order #14
Total Contract
Amount Paid
Through June 30, 2010
July 1, 2010 through November 30, 2010
Balance Due
Deschutes County - Solid Waste
Area A Closure and Cell 5 Construction
As of November 30, 2010
DEO requirement for gas detection
LFG well field management SOPs
Storm sewer realignment, drainage, Area A thickness
"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.43 153,904.43 408,317.86
54,348.56 53,684.83 108,033.39
8,579.01
8,357.74 16,936.75
2,097,140.50 3,290,779.98 5,387,920.48
Meet CEC requirements, increase to electrical panel, 45,095.00 45,095.00
Storm sewer realignment due to refuse encountered 14,302.54 14,302.54
Revise valve vaults for improved efficiencies 24,885.69 24,885.69
Add'I cover material from what will be Cell 6 152,500.00 152,500.00 305,000.00
Environmental controls building, pump station bulkheads 148,958.89 148,958.89
Adjustment to pipe alignment to increase slope 1,332.00 1,332.00
Additional rock to be set aside for future needs - 225,000.00 225,000.00
Manhole covers below grade to meet Road Dept requirements 2,486.98 2,486.98
Modular Block Wall instead of MSE Wall 5,167.76 5,167.76
Upgrade of cables (pump and leachate) 3,200.00 3,200.00
Leachate Line connection from Cell 5 to Cells 3 & 4 6,354.75 6,354.75
Additional cover material due to settling 26,000.00 - 26,000.00
Well modification, flow meter less LFG vaults 5,350.00 5,350.00
2,323,997.71 3,877,056.38 6,201,054.09
Total of Engineering and Construction Contracts:
Original Contracts
Change Orders
Total Contract
Amount Paid
Through June 30, 2010
July 1, 2010 through November 30, 2010
Balance Due
1,707,132.00
316,813.18
300,052.53
2,054,537.51
1,413,843.52
408,675.35
3,761,669.51
1,730,656.70
708,727.88
2,339,009.50 3,473,295.98 5,812,305.48
302,329.21 619,707.40 922,036.61
2,641,338.71 4,093,003.38 6,734,342.09
1,961,545.43 2,208,441.94 4,169,987.37
371,1 61.74 1,467.528.35 1,838,690.09
306,631.54 41.7,033.09 725,664.63
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
"Area A"
"Cell 5"
Landfill
Closure
Fund 611
SW Capital
Projects Fund
613
Total
785,000
2,538,638 3,323,638
371,162 1,467,528 1,838,690
413,838 1,071,110 1,484,948
Balance Due on Contracts 308,632 417,033 725,665
Remaining Appropriation after contracts paid in full 105,207 654,077 759,283
FY 2011 Expenditures for other activities 32,210 428,649 460,859
Remaining Appropriation after Contracts/Other 72,997 225,427 298,424
Additional Appropriation in
Contingency and Reserve for Future Expenditures 306,221 551,196 857,417
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Travel Expenditures
and
BOCC - County College Expenditures
FY 2011
12/13/2010
BOCC Conference & Travel
Jul
Aug -
Sep
Oct
Nov YTD Total
Tammy Baney
-
-
-
Conf/Sem & Educ/Training
-
305
45
350
20
Travel Meals
20
-
-
-
Accommodations
-
-
77
-
-
429
-
506
Mileage reimbursement
240
255
-
495
Ground Transport/Parking
_ - 1
-
-
-
-
-
Total Baney
-
337
-
989
45
1,371
Dennis Luke
Conf/Sem & Educ/Training
-
-
-
305
-
305
Travel Meals
-
56
37
25
74
193
Accommodations
-
77
76
506
85
744
Mileage reimbursement
-
282
178
190
211 !
860
Ground Transport/Parking
-
17
-
-
-
17
Total Luke
-
432
292
1,025
370
2,119
Alan Unger
45
350
Conf/Sem & Educ/Training
-
-
-
-
305
198
Travel Meals
-
-
-
198
Accommodations
-
-
-
-
1,414
-
1,414
Airfare
1,133
-1-
-
372 .
-
1,133
372
Mileage reimbursement-
-
-
-
Ground Transport/Parking
-
-
-
29
-
29
Total Unger
1,133',
-
-
2,317
45 j
3,495
Tony DeBone
Conf/Sem & Educ/Training
-
-
-
-
350 !
350
Accommodations
-
-
-
536
-
536
Total Other
-
-
-
536
350 !
886
Total - BOCC Department
Conf/Sem & Educ/Training
-
-
-
610
395 j
1,355
Travel Meals
-
76
37 '
25
74
411
Accommodations
-
154
76
1,470
85
3,199
Airfare
-
-
-
-
-
1,133
Mileage Reimbursement
522
178
445
211 '
1,727
Ground Transport
_ -
17
-
-
-
46
Total - BOCC Department
-
769
292
2,550
765
7,871
FY 2011 Budget
19,600
Percent of FY 2011 Budget Expended40.2%
BOCC County College
Public Information
-
-
1,874
-
- 1
52150
1,874
Office/Copier Supplies
-
-
33
65
Meeting Supplies
-
-
295
930
828 +
2,053
8801
4,077
-
-
2,202
995
12/13/2010