HomeMy WebLinkAboutFinance UpdateMonthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
September 29, 2010.
(1) Monthly Investment Report
(2) August 2010 Financials
Investment Income
Fiscal Year 2010-11
Aug -10 I Y -T -D
$ 84,478 $ 175,880
4,478 175,880
4,224) (8,794)
CO
CO
O
CO
1
141
Clst
0
Total Investment Income 8
Less Fee: 5% of Invest. Income
Investment Income - Net $ 8
Investments By County Function
General $ 108,413,832
Total Investments $ 108,413,832
Mkt-
I- ortfolio
kt-x
`ortfolio Breakdow
;ID eschutes vur�t�
O
N
CO
or 171• As •li
ro nv- t
0
cr)o ocr) o e O
CO
A N O
v-
CO0 OOLC)
1n N O ..
C10 tt N O CO
L(i O N O O)
Co co N O CO
CO h N- O O
c O co N
CL O
Z
u 0'E
m Es m
E o U
E 2- O
0 0 .E
0 U 1=
0
0
CI) va
(1) O
O •U
.0
o) a)
CO Cr) <L) H
1—ca �m
(n - Op c—
j LL m J
108,413,832
4)
Total Investments
r
0
2
L
O
a
O O e
CD N 01
c
vI
0
4-
L
E
0
V
■••
viclm
U
rr a+
C o e
02 0
2ND
C"i r Ch
Average Maturity in Days
Co
N
1()
0 0 0 0 00 0
O O 11) 1f) 1r) O O
O O h N N N
1
y 1n
E 0
3 c L
)
O O Q 1U
'<a Z
u) CD
112
g'
< a)0m
0 a m a) U
E0a) Q
C•o c
U : j0 O Cm 1— U U
Total Portfolio: By Investment Types
N
a1
E �
0
Next Call
Date
_U
Z
U _U Ui _U
z,ZZ Z
I
_UI _U _U
Z''.Z Z
U'_U
I Z
_U U
Z ZZ
_U
Z
_U _U,U
Z ZZ
U U VIII _U
ZZ ZZ
I
U _U _U
z Z Z
UIIU -A
ZIIZ^ N
O 00
1
_U U _U _U U �,
Z Z ZIZ1,z (
1 1QI
OOOOaa�OO
O O)O
''G -
C'N �i'V
1
•
O
,
Value of
Ir Investment At
Mattai
1,042,187.50
101 460.00
2,037,500.00
2,091 687.50
2,139 750.00
1,133 588.75
101 165.97
2,047,250.00
2,053,375.001'
2,000,000.00
103,406.94
2,141 180.56
100 942.921
2,103,196.67
2,023 822 22
102,047.50
2,042,544.44
2,034,947.22
2,022 250.00
2,198,333.33
0 0 (O
0 0'(D
OIO O
OI O co
O O N
N S T
.-O O
N N N
0
CO
col
c0
t-
t`
O
N
X 1 0 '-
CO O
(O''O
Oil
c O O
N. O N V
.-o O
N NIN
0'. CO .NICD
O'(C) N
O'I O'N
O'. O N
O 00
N a) to
co
O''-",O
N 0.1 0.1
(O'. O
O_ V O
O OI OI
0' CO', 0
to to co_
0p 6 0
(")1 coI O
O; 01
N -NII
I
54,344,486.99
50,105,823.13
3,963,521.67
0)
(�
MI
co
(+)'
V
O
IN
. N O
'', t tt
'', 6
(()-
co V
O co
co. co
O' rI
NO
'', N Co .0
V O oo
00'7
N 0,7
N CoCO
N 0 0
(10'. (D
n O'o
II N.N.(
$108,413,831.79
Market Value
101,420.00
2,002,500.00
2,008,760.00
2,011,480.00
1,057,224.00
100,856.11
2,009,080.00
2,040,736.11
1,995,600.00T
102,465.39
2,042,780.00
100,403.00 F
1,993,263.72
2,008,120 00
101,068.75
53,160,034.94
50,105,823.13
3,963,521.67
0)
6
O
2,019,133.33
2,015,716.67
2,006,880.00
2,092,500.00
2,010,222.22
2 006,88000
2,006,880.00
2,069,380.00
2,000,260.00
2,001,260.00
2,008,120.00
2,086,800.00
2,015,000.00
2,001,388.89
35,036.75
2,003,120.00
OI
(•)
a
N
O
I
Original Cost
1,029,090.00
100,000.00
2,001,482.18
2,063,360.00
2,047,936.00
1,071,609.00
100,000.00
2,008,820.00
2,000,000.00
1,993,057.78
100,000.00
2,109,640.00
} _
O
O
O
2,043,457.08
1,999,540.00
100,000.00
2,000,000.00
1,997,640.00
2,158,360.00
(:)
O
o'
6
O
N
2,083,960.00
2,000,000.00
2,007,600.00
2,000,000.00
2,141,869.23
2,004,720.00
2,000,000.00
SIS
0'I O,
O' 0
M,0
O
I N
53,394,901.27
50,105,823.13
3,963,521.67
0.712%
2.230%
1.150%
1.848%
0.816%
1.350%
1.178%
0.550%
0.800%
'O m
W
ar
m
N(()
t-
0
'7
e e
0 0
0 N
N' O
� .-
o
(h
3.000%
1.150%
1.216%
1.750%
S
0)
O
0
co
0
0
a
rn.o�(n
l
O' O CO
O, n, O
C' O t-
e
0
O
r,
0I
0 0
0 N.
O cD
— " O
l(
0
0
O
0
In
O
0
h
N
Commercial
Corporate N(
Time Certific
US Treasurie
Federal Ager
Bankers' Act
LGIP / BOTC
Coupon
Rate
a
O
CO
'M
ae
0 O'
(n' N.
N CO
I�'M
Io
O
r--(0
cO
VVI
o o
O' 0
O''I O
I (f)
I
o
0
0
09
'O
o
0
co
CO
O
5.500%
0.800%!
1.350%I
�e
OI
(n',
I-
O
I(0
O
fs
CO
(D
0la la
0' 0' 0
pp. 0' CO
0) 0 CO
(4 — o
a
0
CO
CO
O
o o Ilo
O O' O
t . 0', O
I- n
M,O —
a
0',
In:
1~'
OIO
o
O O
N', O
.- 0
—
e
O
I'4
N
Total Investment Instruments
Local Gov't Investment Pool
BOTC Money Market Pool
4-0
U
stments
8/31/2010
Discount _
Rate
N
L.
--
I
CD
W
}.1
I C N
Q
"i
N
C T
Z
0
V
o
co
M
CO
7 S
if)
N
CO (((0p CO
f- M.01
I
CO 10I co
.-101V
(p
(0
l� Ij I�
U
NI NI II
CO
V'
,
(M
CO
U 1 Ic
COL
CO' CO
Ij
I, co
(NO
U
•)
IroD
G
rNW^
V
Term
res
Matu
Date 1
09/10/10
09/11/10
10/14/10
10/20/10
10/21/10
r 12/07/10
01/07/11
01/09/11
01/11/11
01/31/11
03/15/11
O)
N
0
co (p, o
NCo- N
C O, (A
0 0".0
06/29/11
06/29/11
07/05/11
08/01/11
08/26/11
09/01/11
09/01/11
O
0
O
09/09/11
09/15/11
09/23/11
(A
O
0
10/25/11
11/23/11
01/07/12
01/27/12
05/17/12
Average
C
Purchase
Date
0
! 0
I O
CO
10
0)0)0)0)
0 0 0
VIS
0 0 0
0 0.010
0
ui
(n
11/25/08
12/07/09
06/10/09
07/09/09
O' 01 0
- 0 0
CB op o
.-', co N
0 0-
of of t-
O
_
o
N
o
a
O)., CO� 0)
O 0'. O
co o'• O
.- N I
D)
o'.- .-
12/29/09 _
12/29/09
01/11/10
01/11/10
06/23/10
03/01/10
03/17/10
L05/26/10_
03/31/10
03/15/10
12/09/09
0
In
O
0
o
0I 0_
n I (�
N N'
of 01.0
0
n
O
0
0
n
N
N.0
o
0'
n
'-
o!
o1
1
SII
Q '.0
JCR — J
-) mIZI>
".
I- d U- Q.d
Z Q O.
idRi
LQL
F
LI- I LI-
U
LL
1 LI-
O
m '� U
F
U LI- 1-
F
F LL
U
U
F LI-
LI-
LI- LI- LI-
LI-
U
LL 1, 1
1-
LI-
11"68
1"-'
'I
COLL
LL' 2
LLIZ
5',N
.1
m
LL'
0..
Dre
CL
m
Q''I LL'LL
mII= S
CL
U
ZI Z:>
NNN
F
N
m,Z
YlN
�
a
LL
a', �
D13-
Z
N
ZIZ''co
fnicn'i Ce
LL.
3'
col
Ce
mla
LL''D
U
m
u-
�II
Cusip Number
3133XRT83
3133XTHN9__
3133XSCT3
36962GS62
31331TKB6
3137EA8W8
36962GW59
3133XVDU2
31331JAL7
9033WAA6
C49746NJ6
31331JFT5
31331JFT5
3133XRY46
3128X9N89 .i
3133XUR96
31331JJP9
U89233RA7
31398AZN5J
Cc,
N
LLA
M
a
ment Description
Home Federal Bank - CD
FHLB
FHLB
General Elec - CN
FFCB
Umpqua Bank - CD
FHLMC
,Umpqua Bank - CD
Home Federal Bank - CD
Wachovia Corp - CN
Columbia State Bank - CD
General Elec - CN
FHLB
South Valley Bank - CD
(Sterling Savings Bank - CD
nk - CD
ank - CN
Wells Fargo CN
Umpqua Bank - CD
FFCB
FHLB
FHLMC
FHLB
TTota Motor Credit - CN
FNMA
Umpqua Bank - CD
Bank of the Cascades - CD
FNMA
D:
Bank of America
Bank of the Cascades I
Columbia River
Home Federal Bank
Key Bank
Liberty Bank
Piper Jaffray
RBC Dain Rauscher
Seattle NW Securities
South Valley Bank
Sterling Savings Bank
Umpqua Bank
Wells Fargo
Bankers' Acceptances
Commercial Paper
Corporate Notes
Federal Agencies
Time Certificates of De
US Treasuries
CD
J
Z
W
1/1
Y.
.
d
LL
1"--- a
I F
0
LL
0
LL
C 7)
JmI
c!
4.,f
Memorandum
Date: September 14, 2010
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find August 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) and Health Benefits Trust
(675), Fair & Expo Center (618).
The projected information has been reviewed and updated, where appropriate, by the
respective departments.
Cc: All Department Heads
RESOURCES:
Beg. Net Working Capital
Revenues
Property Taxes
Gen. Rev. - excl. Taxes
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Non -Departmental
Contingency
Transfers Out
TOTAL REQUIREMENTS
NET (Resources - Requirements)
GENERAL FUND
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
IY
CoII. %
$ 8,300,000 $ 9,677,699 $ 1,377,699 100% 117% $8,300,000 $9,677,699 $ 1,377,699
3,427,667 252,543 (3,175,124) 17% 1% a) 20,566,000 20,566,000
399,523 652,055 252,532 17% 27% b) 2,397,138 2,397,138
132,615 184,050 51,435 17% 23% c) 795,690 795,690
203,452 255,632 52,180 17% 21% 1,220,714 1,220,714
2,066 378 (1,688) 17% 3% 12,398 12,398
52,350 14,870 (37,480) 17% 5% 314,100 314,100
30,033 48,909 18,876 17% 27% c) 180,200 180,200
11,311 (11,311) 17% 0% 67,866 67,866
15,189 15,029 (160) 17% 16% 91,132 91,132
333 333 0 17% 17% 2,000 2,000
4,274,539 1,423,800 (2,850,739) 17% 6% 25,647,238 25,647,238
•
12,574,539 11,101,499 (1,473,040) 17% 33% 33,947,238 35,324,937 1,377,699
563,703
247,355
12,567
813,688
141,152
43,700
42,205
18,701
365,315
1,247,129
3,495,515
2,162,361
5,657,876
6,916,663
518,628
198,758
11,420
760,340
133,482
43,661
42,886
17,866
148,155
1,875,196
2,208,068
4,083,264
7,018,235
45,075
48,597
1,147
53,348
7,670
39
(681)
835
217,160
1,247,129
1,620,319
(45,707)
1,574,612
101,572
17%
17%
17%
Exp. %
a) Approximately 85% of the property taxes are collected in October and November
b) YTD Actual includes annual federal payment in lieu of taxes - $471,913
c) YTD Actual includes A&T grant received quarterly in advance
15%
13%
15%
16%
16%
17%
17%
16%
7%
n/a
9%
17%
12%
3,382,219
1,484,127
75,403
4,882,127
846,910
262,197
253,227
112,203
2,191,887
7,482,774
20,973,074
12,974,164
33,947,238
3,382,219
1,484,127
75,403
4,882,127
846,910
262,197
253,227
112,203
2,191,887
- 7,482,774
13,490,300 7,482,774
12,974,164
26,464,464 7,482,774
8,860,473 8,860,473
Year End
$
Budget
Projection
Variance
$ 8,300,000 $ 9,677,699 $ 1,377,699 100% 117% $8,300,000 $9,677,699 $ 1,377,699
3,427,667 252,543 (3,175,124) 17% 1% a) 20,566,000 20,566,000
399,523 652,055 252,532 17% 27% b) 2,397,138 2,397,138
132,615 184,050 51,435 17% 23% c) 795,690 795,690
203,452 255,632 52,180 17% 21% 1,220,714 1,220,714
2,066 378 (1,688) 17% 3% 12,398 12,398
52,350 14,870 (37,480) 17% 5% 314,100 314,100
30,033 48,909 18,876 17% 27% c) 180,200 180,200
11,311 (11,311) 17% 0% 67,866 67,866
15,189 15,029 (160) 17% 16% 91,132 91,132
333 333 0 17% 17% 2,000 2,000
4,274,539 1,423,800 (2,850,739) 17% 6% 25,647,238 25,647,238
•
12,574,539 11,101,499 (1,473,040) 17% 33% 33,947,238 35,324,937 1,377,699
563,703
247,355
12,567
813,688
141,152
43,700
42,205
18,701
365,315
1,247,129
3,495,515
2,162,361
5,657,876
6,916,663
518,628
198,758
11,420
760,340
133,482
43,661
42,886
17,866
148,155
1,875,196
2,208,068
4,083,264
7,018,235
45,075
48,597
1,147
53,348
7,670
39
(681)
835
217,160
1,247,129
1,620,319
(45,707)
1,574,612
101,572
17%
17%
17%
Exp. %
a) Approximately 85% of the property taxes are collected in October and November
b) YTD Actual includes annual federal payment in lieu of taxes - $471,913
c) YTD Actual includes A&T grant received quarterly in advance
15%
13%
15%
16%
16%
17%
17%
16%
7%
n/a
9%
17%
12%
3,382,219
1,484,127
75,403
4,882,127
846,910
262,197
253,227
112,203
2,191,887
7,482,774
20,973,074
12,974,164
33,947,238
3,382,219
1,484,127
75,403
4,882,127
846,910
262,197
253,227
112,203
2,191,887
- 7,482,774
13,490,300 7,482,774
12,974,164
26,464,464 7,482,774
8,860,473 8,860,473
COMM JUSTICE -JUVENILE
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
RESOURCES:
Beg. Net Working Capital $ 987,000 $ 1,039,997 $ 52,997 100% 105% $ 987,000 $ 1,039,997 $ 52,997
Revenues
Federal Grants 2,588 (2,588) 17% 0% a) 15,527 15,527
SB #1065 -Court Assess. 10,000 6,837 (3,163) 17% 11% 60,000 60,000
Discovery Fee 2,667 1,675 (992) 17% 10% 16,000 16,000
Food Subsidy 6,333 (6,333) 17% 0% 38,000 38,000
OYA Basic & Diversion 56,668 (56,668) 17% 0% a) 340,006 340,006
Inmate/Prisoner Housing 16,667 8,100 (8,567) 17% 8% 100,000 100,000
Inmate Commissary Fees 17 43 26 17% 43% 100 100
Contract Payments 14,748 (14,748) 17% 0% 88,490 88,490
Miscellaneous 50 20 (30) 17% 7% 300 300
MIP Diversion Fees 167 50 (117) 17% 5% 1,000 1,000
Interest on Investments 2,833 1,704 (1,129) 17% 10% 17,000 17,000
Leases 400 400 17% 17% 2,400 2,400
Grants - Private 83 219 136 17% 44% 500 500
Health & Human Svcs Chg 1,000 (1,000) 17% 0% 6,000 6,000
CCF Interfund Grant 10,083 (10,083) 17% 0% a)b) 60,495 96,500 36,005
Interfund Grant 3,333 (3,333) 17% 0% a) 20,000 20,000
Total Revenues 127,637 19,048 (108,589) 17% 2% 765,818 801,823 36,005
Transfers In -General Fund 923,864 923,864 - 17% 17% 5,543,186 5,543,186
TOTAL RESOURCES 2,038,501 1,982,909 (55,592) 17% 27% 7,296,004 7,385,006 89,002
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
Exp. %
493,993 449,701 44,292 17% 15% 2,963,956 2,963,956
Materials and Services 199,981 139,121 60,860 17% 12% 1,199,886 1,199,886
Capital Outlay 17 17 17% 0% 100 100
Juvenile Resource Center
Personal Services 389,244 369,256 19,988 17% 16% 2,335,462 2,335,462
Materials and Services 29,249 30,762 (1,513) 17% 18% c) 175,494 175,494
Contingency 103,518 103,518 17% n/a 621,106 - 621,106
TOTAL REQUIREMENTS 1,216,002 988,840 227,162 17% 14% 7,296,004 6,674,898 621,106
NET (Resources - Requirements) 822,499 994,069 171,570 710,108 710,108
a) Reimbursements received quarterly in arrears
b) Additional funding from CCF allocated for Juvenile programs
c) Negative variance due to a $10,000 annual subscription expended in July
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 2,588 (2,588) 17% 0% a) 15,527 15,527
SB #1065 -Court Assess. 10,000 6,837 (3,163) 17% 11% 60,000 60,000
Discovery Fee 2,667 1,675 (992) 17% 10% 16,000 16,000
Food Subsidy 6,333 (6,333) 17% 0% 38,000 38,000
OYA Basic & Diversion 56,668 (56,668) 17% 0% a) 340,006 340,006
Inmate/Prisoner Housing 16,667 8,100 (8,567) 17% 8% 100,000 100,000
Inmate Commissary Fees 17 43 26 17% 43% 100 100
Contract Payments 14,748 (14,748) 17% 0% 88,490 88,490
Miscellaneous 50 20 (30) 17% 7% 300 300
MIP Diversion Fees 167 50 (117) 17% 5% 1,000 1,000
Interest on Investments 2,833 1,704 (1,129) 17% 10% 17,000 17,000
Leases 400 400 17% 17% 2,400 2,400
Grants - Private 83 219 136 17% 44% 500 500
Health & Human Svcs Chg 1,000 (1,000) 17% 0% 6,000 6,000
CCF Interfund Grant 10,083 (10,083) 17% 0% a)b) 60,495 96,500 36,005
Interfund Grant 3,333 (3,333) 17% 0% a) 20,000 20,000
Total Revenues 127,637 19,048 (108,589) 17% 2% 765,818 801,823 36,005
Transfers In -General Fund 923,864 923,864 - 17% 17% 5,543,186 5,543,186
TOTAL RESOURCES 2,038,501 1,982,909 (55,592) 17% 27% 7,296,004 7,385,006 89,002
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
Exp. %
493,993 449,701 44,292 17% 15% 2,963,956 2,963,956
Materials and Services 199,981 139,121 60,860 17% 12% 1,199,886 1,199,886
Capital Outlay 17 17 17% 0% 100 100
Juvenile Resource Center
Personal Services 389,244 369,256 19,988 17% 16% 2,335,462 2,335,462
Materials and Services 29,249 30,762 (1,513) 17% 18% c) 175,494 175,494
Contingency 103,518 103,518 17% n/a 621,106 - 621,106
TOTAL REQUIREMENTS 1,216,002 988,840 227,162 17% 14% 7,296,004 6,674,898 621,106
NET (Resources - Requirements) 822,499 994,069 171,570 710,108 710,108
a) Reimbursements received quarterly in arrears
b) Additional funding from CCF allocated for Juvenile programs
c) Negative variance due to a $10,000 annual subscription expended in July
SHERIFF - Fund 255
Statement of Financial Operating Data
Two Months Ended August 31, 2010
rBudget
Year to Date
Actual
Variance
FY%
CoII. %
RESOURCES:
Beg. Net Working Capital $
Revenues
Law Enf Dist Countywide
Law Enf Dist Rural
Interest
3,804,910
2,277,657
$ 207,689 $ 207,689 100% n/a $ - $ 207,689 $ 207,689
3,804,910
2,277,657
- 2,658
Total Revenues 6,082,567 6,085,225
TOTAL RESOURCES 6,082,567
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division 467,611
Civil 133,073
Automotive/Communications 242,173
Investigations/Evidence 275,132
Patrol/Civil/Comm Supp 1,304,775
Records 110,064
Adult Jail 1,658,949
Court Security 40,142
Emergency Services 29,074
Special Services Division 189,567
Regional Work Center 461,569
Training Division 55,000
Other Law Enforcement Svcs 96,153
Non -Departmental 47,170
Contingency 938,781
Transfers Out - D/S Fund 33,333
17% 17%
- 17% 17%
2,658 17% n/a
2,658 17% 17%
22,829,457 22,829,457
13, 665, 939 13, 665,939
2,658
2,658
36,495,396 36,498,054 2,658
6,292,914 210,347 17% 17% 36,495,396 36,705,743 210,347
422,212
145,157
456,117
268,931
1,199,219
101,564
1,366,543
44,648
27,551
213,504
408,796
51,982
90,074
13,836
45,399
(12,084)
(213,944)
6,201
105,556
8,500
292,406
(4,506)
1,523
(23,937)
52,773
3,018
6,079
33,334
938,781
17%
17%
17%
17%
1 7%
1 7%
1 7%
17%
1 7%
1 7%
1 7%
17%
1 7%
1 7%
1 7%
Exp. %
1 5%
1 8%
31 %
1 6%
1 5%
1 5%
1 4%
1 9%
1 6%
1 9%
1 5%
1 6%
1 6%
5%
n/a
33,333 17% 0%
TOTAL REQUIREMENTS 6,082,566
NET (Resources - Requirements)
2,805,668
798,436
a) 1,453,036
1,650,792
7,828,651
660,386
9,953,695
240,851
174,441
1,137,404
2,769,411
330,000
576,917
283,018
5,632,690
2,805,668
798,436
1,453,036
1,650,792
7,828,651
660,386
9,953,695
240,851
174,441
1,137,404
2,769,411
330,000
576,917
283,018
- 5,632,690
200,000 200,000
4,810,134 1,272,432 17% 13% 36,495,396 30,862,706 5,632,690
1,482,780 1,482,779
a) Annual expenditure for Interagency Communications System was made in July
- 5,843,037 5,843,037
Year End
Budget
Projection
Variance
$ 207,689 $ 207,689 100% n/a $ - $ 207,689 $ 207,689
3,804,910
2,277,657
- 2,658
Total Revenues 6,082,567 6,085,225
TOTAL RESOURCES 6,082,567
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division 467,611
Civil 133,073
Automotive/Communications 242,173
Investigations/Evidence 275,132
Patrol/Civil/Comm Supp 1,304,775
Records 110,064
Adult Jail 1,658,949
Court Security 40,142
Emergency Services 29,074
Special Services Division 189,567
Regional Work Center 461,569
Training Division 55,000
Other Law Enforcement Svcs 96,153
Non -Departmental 47,170
Contingency 938,781
Transfers Out - D/S Fund 33,333
17% 17%
- 17% 17%
2,658 17% n/a
2,658 17% 17%
22,829,457 22,829,457
13, 665, 939 13, 665,939
2,658
2,658
36,495,396 36,498,054 2,658
6,292,914 210,347 17% 17% 36,495,396 36,705,743 210,347
422,212
145,157
456,117
268,931
1,199,219
101,564
1,366,543
44,648
27,551
213,504
408,796
51,982
90,074
13,836
45,399
(12,084)
(213,944)
6,201
105,556
8,500
292,406
(4,506)
1,523
(23,937)
52,773
3,018
6,079
33,334
938,781
17%
17%
17%
17%
1 7%
1 7%
1 7%
17%
1 7%
1 7%
1 7%
17%
1 7%
1 7%
1 7%
Exp. %
1 5%
1 8%
31 %
1 6%
1 5%
1 5%
1 4%
1 9%
1 6%
1 9%
1 5%
1 6%
1 6%
5%
n/a
33,333 17% 0%
TOTAL REQUIREMENTS 6,082,566
NET (Resources - Requirements)
2,805,668
798,436
a) 1,453,036
1,650,792
7,828,651
660,386
9,953,695
240,851
174,441
1,137,404
2,769,411
330,000
576,917
283,018
5,632,690
2,805,668
798,436
1,453,036
1,650,792
7,828,651
660,386
9,953,695
240,851
174,441
1,137,404
2,769,411
330,000
576,917
283,018
- 5,632,690
200,000 200,000
4,810,134 1,272,432 17% 13% 36,495,396 30,862,706 5,632,690
1,482,780 1,482,779
a) Annual expenditure for Interagency Communications System was made in July
- 5,843,037 5,843,037
SHERIFF 701
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $4,722,862 $ 5,478,092 $ 755,230 100%
Revenues
Tax Revenues - Current 2,475,599 (2,475,599) 17%
Tax Revenues - Prior 107,000 181,788 74,788 17%
Federal Grants 5,833 (5,833) 17%
State Grant 8,079 18,162 10,083 17%
Transp. of State Wards 833 (833) 17%
SB 1145 329,110 493,665 164,555 17%
Des. Cty Video Lottery Grant 833 (833) 17%
Des Cty Court Security 15,833 15,809 (24) 17%
Title 111 Reimbursement 25,000 (25,000) 17%
Transport 667 (667) 17%
DC Fair & Expo Center 2,925 2,925 17%
Inmate Commissary Fees 8,000 13,679 5,679 17%
Work Center Work Crews 4,167 4,050 (117) 17%
Concealed Handgun Classes 1,000 975 (25) 17%
Soc Sec Incentive -Fed 833 1,600 767 17%
Miscellaneous 833 1,673 840 17%
Oregon Mentors 2,120 2,120 17%
Medical Services Reimb 2,000 3,301 1,301 17%
Restitution 167 2,695 2,528 17%
Sheriff Fees 26,667 49,559 22,892 17%
Interest 4,722 6,010 1,288 17%
Interest on Unsegregated 589 68 (521) 17%
Donations 200 200 17%
Total Revenues 3,017,764 798,279 (2,219,485) 17%
TOTAL RESOURCES
116% $ 4,722,862
0%
28%
0%
37%
0%
25%
0%
17%
0%
0%
n/a
28%
16%
16%
32%
33%
n/a
28%
270%
31%
21%
2%
n/a
4%
a) 14,853,594
642,000
35,000
48,475
5,000
b) 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,478,092 $ 755,230
14,853,594
642,000
35,000
48,475
5,000
1,974,660
5,000
95,000
150,000
4,000
2,925
48,000
25,000
6,000
5,000
5,000
5,000
12,000
5,000
160,000
28,333
3,533
200
2,925
5,000
4,000
200
18,106,595
18,118,720 12,125
7,740,626 6,276,371 (1,464,256) 17% 27% 22,829,457 23,596,812 767,355
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 3,804,910 3,804,910
TOTAL REQUIREMENTS
- 17%
3,804,910 3,804,910
- 17%
NET (Resources - Requirements) 3,935,716 2,471,461 (1,464,256)
Exp. %
a) Approximately 85% of the property taxes are collected in October and November
b) Quarterly payments received in advance
17% 22,829,457 22,829,457
17% 22,829,457 22,829,457
767,355
767,355
Year End
Budget
Projection
Variance
116% $ 4,722,862
0%
28%
0%
37%
0%
25%
0%
17%
0%
0%
n/a
28%
16%
16%
32%
33%
n/a
28%
270%
31%
21%
2%
n/a
4%
a) 14,853,594
642,000
35,000
48,475
5,000
b) 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,478,092 $ 755,230
14,853,594
642,000
35,000
48,475
5,000
1,974,660
5,000
95,000
150,000
4,000
2,925
48,000
25,000
6,000
5,000
5,000
5,000
12,000
5,000
160,000
28,333
3,533
200
2,925
5,000
4,000
200
18,106,595
18,118,720 12,125
7,740,626 6,276,371 (1,464,256) 17% 27% 22,829,457 23,596,812 767,355
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 3,804,910 3,804,910
TOTAL REQUIREMENTS
- 17%
3,804,910 3,804,910
- 17%
NET (Resources - Requirements) 3,935,716 2,471,461 (1,464,256)
Exp. %
a) Approximately 85% of the property taxes are collected in October and November
b) Quarterly payments received in advance
17% 22,829,457 22,829,457
17% 22,829,457 22,829,457
767,355
767,355
RESOURCES:
Beg. Net Working Capital
Revenues
Tax Revenues - Current
Tax Revenues - Prior
Federal Grants
US Forest Service
State Grant
SB #1065 Court Assessment
Marine Board License Fee
Des Cty General Fund Grant
Des Cty Transient Room Tax
City of Sisters
Des Cty Tax/Fin Contract
Des Cty CDD Contract
Des Cty Solid Waste Contr
Des Cty Clerk/Election
School Districts
Security & Traffic Reimb
Seat Belt Program
Miscellaneous
Restitution
Sheriff Fees
Court Fines & Fees
Impound Fees
Restitution - Street Crimes
Interest
Interest on Unsegregated
Sale of Reportable Assets
Sale of Equip & Material
Total Revenues
TOTAL RESOURCES
SHERIFF 702
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
FY %
CoII. %
$ 1,905,939 $ 2,421,863
$ 515,924 100%
1,251,374 - (1,251,374) 17%
52,333 92,986 40,653 17%
333 (333) 17%
12,750 (12,750)
31,272 13,508 (17,764) 17%
11,167 6,837 (4,330) 17%
23,739 (23,739) 17%
117,060 (117,060) 17%
324,607 324,607 - 17%
72,109 72,109 - 17%
167 (167) 17%
9,061 9,061 - 17%
9,061 9,061 - 17%
333 (333) 17%
16,667 (16,667) 17%
2,167 1,081 (1,086) 17%
1,000 1,125 125 17%
1,667 4,000 2,333 17%
83 (83) 17%
1,667 1,596 (71) 17%
14,167 23,022 8,855 17%
2,500 1,100 (1,400) 17%
83 (83) 17%
1,667 2,081 414 17%
300 33 (267) 17%
1,667 14,904 13,237 17%
1,000 31 (969) 17%
17%
127% $ 1,905,939 $2,421,863 $ 515,924
0% a)
30%
0%
0%
7%
10%
0%
0%
17%
17%
0%
17%
17%
0%
0%
8%
19%
40%
0%
16%
27%
7%
0%
21%
2%
149% b)
1%
7,508,247
314,000
2,000
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
10,000
6,000
7,508,247
314,000
2,000
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
20,000 10,000
6,000
1,960,001 577,142 (1,382,859) 17% 5% 11,760,000 11,770,000 10,000
3,865,940 2,999,005 (866,935) 17% 22% 13,665,939 14,191,863 525,924
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 2,277,657
2,277,657
TOTAL REQUIREMENTS 2,277,657 2,277,657
NET (Resources - Requirements)
1,588,283 721,348 (866,935)
Exp. %
17% 17% 13,665,939 13,665,939
17% 17% 13,665,939 13,665,939
a) Approximately 85% of the property taxes are collected in October and November
b) Proceeds from sale of used patrol vehicles were higher than anticipated
525,924 525,924
Year End
Budget
Projection
Variance
127% $ 1,905,939 $2,421,863 $ 515,924
0% a)
30%
0%
0%
7%
10%
0%
0%
17%
17%
0%
17%
17%
0%
0%
8%
19%
40%
0%
16%
27%
7%
0%
21%
2%
149% b)
1%
7,508,247
314,000
2,000
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
10,000
6,000
7,508,247
314,000
2,000
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
20,000 10,000
6,000
1,960,001 577,142 (1,382,859) 17% 5% 11,760,000 11,770,000 10,000
3,865,940 2,999,005 (866,935) 17% 22% 13,665,939 14,191,863 525,924
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 2,277,657
2,277,657
TOTAL REQUIREMENTS 2,277,657 2,277,657
NET (Resources - Requirements)
1,588,283 721,348 (866,935)
Exp. %
17% 17% 13,665,939 13,665,939
17% 17% 13,665,939 13,665,939
a) Approximately 85% of the property taxes are collected in October and November
b) Proceeds from sale of used patrol vehicles were higher than anticipated
525,924 525,924
RESOURCES:
Beg. Net Working Capital
Revenues
PUBLIC HEALTH
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
$1,100,000 $ 1,615,306 $ 515,306 100% 147%
Revised
Year End
Budget
Projection
Variance
$1,100,000 $1,615,306 $ 515,306
Medicare Reimbursement 1,333 - (1,333) 17% 0% 8,000 8,000
State Grant 415,830 333,869 (81,961) 17% 13% 2,494,977 2,494,977
Child Dev & Rehab Center 5,127 (5,127) 17% 0% 30,759 30,759
State Miscellaneous 34,979 - (34,979) 17% 0% 209,875 209,875
OMAP 79,633 35,644 (43,989) 17% 7% 477,800 477,800
Family Planning Exp Proj 82,500 46,570 (35,930) 17% 9% 495,000 495,000
Grants 10,833 48,773 37,940 17% 75% a) 65,000 65,000
Water Program -Base Fee 7,000 (7,000) 17% 0% 42,000 42,000
Water Program -Field Work 9,303 9,660 357 17% 17% 55,817 55,817
H2O Sys Insp-Priv Wells 33 (33) 17% 0% 200 200
Miscellaneous 55 55 17% n/a 55 55
Patient Insurance Fees 31,710 15,885 (15,825) 17% 8% 190,260 190,260
Health Dept/Patient Fees 24,829 15,946 (8,883) 17% 11% 148,975 148,975
Vital Records -Birth 6,000 4,960 (1,040) 17% 14% 36,000 36,000
Vital Records -Death 16,333 18,105 1,772 17% 18% 98,000 98,000
Environmental Health 114,558 30,065 (84,493) 17% 4% 687,350 687,350
Interest on Investments 2,817 2,064 (753) 17% 12% 16,900 16,900
Donations 1,000 29,899 28,899 17% 498% b) 6,000 31,880 25,880
Interfund Contract 31,563 (31,563) 17% 0% 189,378 189,378
Administrative Fee 4,500 4,500 17% 17% 27,000 27,000
Total Revenues 879,881 595,995 (283,886) 17% 11% 5,279,291 5,305,226 25,935
Transfers In -General Fund 386,294 386,294 - 17% 17% 2,317,765 2,317,765
Transfers In -Other 11,187 (11,187) 17% 0% 67,123 67,123
Transfers In -Gen. Fund Other 11,302 (11,302) 17% 0% 67,812 67,812
TOTAL RESOURCES 2,388,664 2,597,595 208,931 17% 29% 8,831,991 9,373,232 541,241
REQUIREMENTS:
Expenditures
Personal Services 986,777
Materials and Services 333,127
Capital Outlay 4,167
Transfers Out 25,000
Contingency 122,928
Exp. %
901,017 85,760 17% 15% 5,920,663 5,920,663
261,863 71,264 17% 13% 1,998,763 1,998,763
- 4,167 17% 0% 25,000 25,000
25,000 17% 0% 150,000 150,000
122,928 17% n/a 737,565
737,565
TOTAL REQUIREMENTS 1,471,999 1,162,880 309,119 17% 13% 8,831,991 8,094,426 737,565
NET (Resources - Requirements)
916,665 1,434,715 518,050
- 1,278,806
1,278,806
a) Health Matters -local grant for Chronic Care Program is $17,000 & Bioterrorism NACCHO grant is $10,000 received in July
b) My Future My Choice donation carry over from FY10, in the amount of $25,880
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Two Months Ended August 31, 2010
RESOURCES:
Beg. Net Working Capital
Revenues
Marriage Licenses
Divorce Filing Fees
Domestic Partnership Fee
Federal Grants
State Grants
State Miscellaneous
Title 19
Liquor Revenue
School Districts
Miscellaneous
Patient Insurance Fees
Patient Fees
Interest on Investments
Rentals
Interfund Contract -Gen. Fund
Comm. on Children & Fam
Administrative Fee
Total Revenues
Transfers In -General Fund
Transfers In-OHP-CDO
Transfers In -Acute Care Svcs
Transfers In-ABHA
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
Year to Date
Budget
Actual
Variance
FY %
Coll. %
$ 2,616,050 $ 2,651,262 $ 35,212 100% 101%
917
21,667
167
16,162
882,310
24,696
50,154
17,567
11,667
2,817
25,667
2,167
7,264
2,183
21,167
4,000
660,191
1,560 643
21,222 (445)
5 (162)
(16,162)
771,616 (110,694)
(24,696)
14,223 (35,931)
(17,567)
6,640 (5,027)
1,119 (1,698)
5,513 (20,154)
367 (1,800)
4,498 (2,766)
1,625 (558)
(21,167)
(4,000)
646,024 (14,167)
1,750,763
219,360
16,666
60,942
111,375
17% 28%
17% 16%
17% 1%
17% 0%
17% 15%
17% 0%
17%
17% 0%
17%
17%
17% 4%
17% 3%
17% 10%
17% 12%
17% 0%
17% 0%
17% 16%
5%
9%
7%
Revised
Year End
Budget
Projection
Variance
$ 2,616,050 $ 2,651,262 $ 35,212
5,500
130,000
1,000
96,969
5,293,862
148,173
300,925
105,400
70,000
16,900
154,000
13,000
43,585
13,100
127,000
24,000
3,961,146
5,500
130,000
1,000
96,969
5,293,862
148,173
300,925
105,400
70,000
16,900
154,000
13,000
43,585
13,100
127,000
24,000
3,961,146
•
1,474,412 (276,351) 17% 14% 10,504,560 10,504,560
219,360
16,666
60,942
17% 17% 1,316,158 1,316,158
17% 17% 100,000 100,000
17% 17% 365,657 365,657
(111,375) 17% 0% 668,252 668,252
4,775,156 4,422,642 (352,514) 17% 28% 15,570,677 15,605,889 35,212
1,538,318
667,150
123,333
26,194
240,117
1,437,355
448,957
100,963
218,193
123,333
26,194
240,117
2,595,112
1,886,312 708,800
Exp.
17% 16% 9,229,909 9,229,909
17% 11% 4,002,901 4,002,901
17% 0% 740,000 740,000
17% 0% 157,164 157,164
17% n!a 1,440,703 1,440,703
17% 12% 15,570,677 14,129,974 1,440,703
NET (Resources - Requirements) 2,180,044 2,536,330 356,286 - 1,475,915 1,475,915
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
FY
Coll.
RESOURCES:
Beg. Net Working Capital $ 686,081
Revenues
Admin -Operations 2,750
Admin -GIS 458
Admin -Code Enforcement 26,953
Building Safety 180,203
Electrical 44,442
Contract Services 30,667
Env Health -On Site Prog 47,305
Planning -Current 129,494
Planning -Long Range 58,962
Budget
Year End
Projection
Variance
613,031 $ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050)
3,235 485
(458)
(774)
(13,234)
6,219
(4,429)
7,825
(7,012)
(24,099)
26,179
166,969
50,661
26,238
55,130
122,482
34,863
Total Revenues 521,234
Trans In -GF
Trans In -GF for Lng Rng Ping
TOTAL RESOURCES
17%
17%
17%
17%
17%
17%
17%
17%
17%
20%
0% a)
16%
15%
19%
14% b)
19%
16%
10% c)
16,500
2,750
161,718
1,081,217
266,652
184,000
283,830
776,962
353,771
16,500
2,500
161,718
1,081,217
266,652
184,000
283,830
776,962
353,771
(250)
485,757 (35,477) 17% 16% 3,127,400 3,127,150
42,232 42,232
86,000 86,000
- 17% 17% 253,387 253,387
- 17% 17% 516,000 516,000
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
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Revenues
Expenditures
Net from Operations
1,335,547 1,227,020
233,733
36,023
30,789
83,388
31,268
40,709
38,668
115,048
82,071
28,885
43,231
228,243
33,985
30,027
79,052
27,586
38,818
37,295
75,747
125,440
(250)
(108,527) 17% 27% 4,582,868 4,509,568 (73,300)
5,490
2,038
762
4,336
3,682
1,891
1,373
39,301
(43,369)
28,885
43,231
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
763,813 676,192 87,621 17%
571,734 550,828
(20,906)
485,757
676,192
(190,435)
Exp. %
16%
16%
16%
16%
15%
16%
16%
11%
25% d)
0%
n/a
1,402,396
216,135
184,732
500,330
187,606
244,251
232,006
690,290
492,427
173,310
259,385
1,402,396
216,135
184,732
500,330
187,606
244,251
232,006
690,290
492,427
173,310
259,385
15% 4,582,868 4,323,483 259,385
186,085 186,085
3,127,150
4,323,483
(1,196,333)
a) Custom GIS work revenue sporadic
b) City of Redmond receipts lag one month behind
c) Grant payments received irregularly
d) 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
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
FY %
CoII. %
RESOURCES:
Beg. Net Working Capital $ 3,430,429 $ 3,419,603 $ (10,826) 100% 100%
Revenues
Mineral Lease Royalties 3,333 3,090 (243) 17% 15% 20,000 20,000
Forest Receipts 372,833 (372,833) 17% 0% a) 2,237,000 2,237,000
State Miscellaneous 16,164 (16,164) 17% 0% 96,984 96,984
Motor Vehicle Revenue 1,666,667 1,275,302 (391,365) 17% 13% b) 10,000,000 10,000,000
City of Bend 45,833 (45,833) 17% 0% c) 275,000 275,000
City of Redmond 58,333 (58,333) 17% 0% c) 350,000 350,000
City of Sisters 1,667 (1,667) 17% 0% c) 10,000 10,000
City of La Pine 1,667 (1,667) 17% 0% c) 10,000 10,000
Admin Recovery (SDC) 446 446 17% n/a - 500 500
Miscellaneous 3,333 5,679 2,346 17% 28% 20,000 20,000
Road Vacations 167 500 333 17% 50% 1,000 1,000
Interest on Investments 6,667 5,268 (1,399) 17% 13% 40,000 40,000
Other Bank/LGIP Interest 59 59 17% n/a - 100 100
Parking Fees 150 (150) 17% 0% 900 900
Interfund Contract 125,000 (125,000) 17% 0% d) 750,000 750,000
Equipment Repairs 41,667 14,810 (26,857) 17% 6% 250,000 250,000
Vehicle Repairs 15,000 (15,000) 17% 0% 90,000 90,000
LID Construction 1,667 (1,667) 17% 0% d) 10,000 10,000
Vegetation Management 5,833 (5,833) 17% 0% d) 35,000 35,000
Forester 4,167 (4,167) 17% 0% d) 25,000 25,000
Car Washes 500 (500) 17% 0% 3,000 3,000
Car Rental 83 (83) 17% 0% 500 500
Sale of Equip & Material 100,583 36,548 (64,035) 17% 6% 603,500 603,500
$ 3,430,429 $ 3,419,603 $ (10,826)
Total Revenues 2,471,314 1,341,702 (1,129,612) 17% 9% 14,827,884 14,828,484 600
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
TOTAL RESOURCES
48,624
33,333
2,007
(48,624) 17% 0%
(33,333) 17% 0%
(2,007) 17% 0%
291,740
200,000
12,040
291,740
200,000
12,040
5,985,707 4,761,305 (1,191,069) 17% 32% 18,762,093 18,751,867 (10,226)
REQUIREMENTS:
Expenditures
Personal Services 958,828
Materials and Services 1,566,837
Capital Outlay 195,282
Transfers Out 66,667
Contingency 339,402
Exp. %
879,693 79,135 17% 15% 5,752,967 5,752,967
596,548 970,289 17% 6% 9,401,023 9,401,023
195,282 17% 0% 1,171,691 1,171,691
66,667 17% 0% 400,000 400,000
339,402 17% n/a 2,036,412
2,036,412
TOTAL REQUIREMENTS 3,127,016 1,476,241 1,650,775 17% 8% 18,762,093 16,725,681 2,036,412
NET (Resources - Requirements)
2,858,691 3,285,064 459,706 2,026,186 2,026,186
a) Annual payment -January 2011
b) Gas tax will increase by 25% ($.06/gal.) effective January 2011
c) Billed upon completion of work
d) Payment to be received in June 2011 from Funds 326, 328, 329, & 340
Year End
Budget
Projection
Variance
$ 3,430,429 $ 3,419,603 $ (10,826)
Total Revenues 2,471,314 1,341,702 (1,129,612) 17% 9% 14,827,884 14,828,484 600
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
TOTAL RESOURCES
48,624
33,333
2,007
(48,624) 17% 0%
(33,333) 17% 0%
(2,007) 17% 0%
291,740
200,000
12,040
291,740
200,000
12,040
5,985,707 4,761,305 (1,191,069) 17% 32% 18,762,093 18,751,867 (10,226)
REQUIREMENTS:
Expenditures
Personal Services 958,828
Materials and Services 1,566,837
Capital Outlay 195,282
Transfers Out 66,667
Contingency 339,402
Exp. %
879,693 79,135 17% 15% 5,752,967 5,752,967
596,548 970,289 17% 6% 9,401,023 9,401,023
195,282 17% 0% 1,171,691 1,171,691
66,667 17% 0% 400,000 400,000
339,402 17% n/a 2,036,412
2,036,412
TOTAL REQUIREMENTS 3,127,016 1,476,241 1,650,775 17% 8% 18,762,093 16,725,681 2,036,412
NET (Resources - Requirements)
2,858,691 3,285,064 459,706 2,026,186 2,026,186
a) Annual payment -January 2011
b) Gas tax will increase by 25% ($.06/gal.) effective January 2011
c) Billed upon completion of work
d) Payment to be received in June 2011 from Funds 326, 328, 329, & 340
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 616,371 $ 728,649 $ 112,278 100% 118% $ 616,371 $ 728,649 $ 112,278
Revenues
DOC Measure 57 36,218 217,350 181,132 17% 100% a) 217,305 217,350 45
State Miscellaneous 717 (717) 17% 0% 4,301 4,301
Alternate Incarceration 5,153 30,918 25,765 17% 100% a) 30,918 30,918
State Subsidy 2,167 3,327 1,160 17% 26% b) 13,000 13,000
SB 1145 493,665 740,497 246,832 17% 25% b) 2,961,990 2,961,990
Probation Work Crew Fees 6,333 3,745 (2,588) 17% 10% 38,000 38,000
Miscellaneous 500 1,100 600 17% 37% 3,000 3,000
Electronic Monitoring Fee 28,333 25,541 (2,792) 17% 15% 170,000 170,000
Probation Superv. Fees 35,000 39,873 4,873 17% 19% 210,000 210,000
Interest on Investments 1,500 2,051 551 17% 23% 9,000 9,000
Interfund - Sheriff 8,333 8,333 17% 17% 50,000 50,000
Crime Prevention Grant 8,333 (8,333) 17% 0% c) 50,000 50,000
Total Revenues 626,252 1,072,735 446,483 17% 29% 3,757,514 3,757,559 45
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
19,172 19,172
- 17% 17% 115,029 115,029
1,261,795 1,820,556 558,761 17% 41% 4,488,914 4,601,237 112,323
Exp. %
525,483 496,761 28,722 17% 16% 3,152,899 3,152,899
149,046 117,596 31,450 17% 13% 894,274 894,274
17 17 17% 0% 100 100
73,607 73,607 17% n/a 441,641
441,641
TOTAL REQUIREMENTS 748,153 614,357 133,796 17% 14% 4,488,914 4,047,273 441,641
NET (Resources - Requirements)
513,642 1,206,199 692,557 553,964 553,964
a) Annual payment received in July
b) Payment received quarterly in advance
c) 1st Quarter payment to be received in September and will be received monthly thereafter
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 36,218 217,350 181,132 17% 100% a) 217,305 217,350 45
State Miscellaneous 717 (717) 17% 0% 4,301 4,301
Alternate Incarceration 5,153 30,918 25,765 17% 100% a) 30,918 30,918
State Subsidy 2,167 3,327 1,160 17% 26% b) 13,000 13,000
SB 1145 493,665 740,497 246,832 17% 25% b) 2,961,990 2,961,990
Probation Work Crew Fees 6,333 3,745 (2,588) 17% 10% 38,000 38,000
Miscellaneous 500 1,100 600 17% 37% 3,000 3,000
Electronic Monitoring Fee 28,333 25,541 (2,792) 17% 15% 170,000 170,000
Probation Superv. Fees 35,000 39,873 4,873 17% 19% 210,000 210,000
Interest on Investments 1,500 2,051 551 17% 23% 9,000 9,000
Interfund - Sheriff 8,333 8,333 17% 17% 50,000 50,000
Crime Prevention Grant 8,333 (8,333) 17% 0% c) 50,000 50,000
Total Revenues 626,252 1,072,735 446,483 17% 29% 3,757,514 3,757,559 45
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
19,172 19,172
- 17% 17% 115,029 115,029
1,261,795 1,820,556 558,761 17% 41% 4,488,914 4,601,237 112,323
Exp. %
525,483 496,761 28,722 17% 16% 3,152,899 3,152,899
149,046 117,596 31,450 17% 13% 894,274 894,274
17 17 17% 0% 100 100
73,607 73,607 17% n/a 441,641
441,641
TOTAL REQUIREMENTS 748,153 614,357 133,796 17% 14% 4,488,914 4,047,273 441,641
NET (Resources - Requirements)
513,642 1,206,199 692,557 553,964 553,964
a) Annual payment received in July
b) Payment received quarterly in advance
c) 1st Quarter payment to be received in September and will be received monthly thereafter
COMM ON CHILDREN 8 FAMILIES
Statement of Financial Operating Data
Two Months Ended August 31, 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 37,742 (37,742) 17% 0% 226,450 $ 226,450
Title IV - Family Sup/Pres 10,625 (10,625) 17% 0% 63,750 $ 63,750
HealthyStart Medicaid 15,833 (15,833) 17% 0% 95,000 $ 95,000
Level 7 Services 42,997 (42,997) 17% 0% 257,984 $ 257,984
State Prevention Funds 2,417 (2,417) 17% 0% a) 14,500 $ 6,126 (8,374)
HealthyStart /R -S -G 51,487 (51,487) 17% 0% b) 308,924 $ 263,596 (45,328)
OCCF Grant 100,721 (100,721) 17% 0% b) 604,323 $ 543,283 (61,040)
Charges for Svcs-Misc 1,333 310 (1,023) 17% 4% 8,000 $ 8,000
Court Fines & Fees 12,500 12,733 233 17% 17% 75,000 $ 78,000 3,000
Interest on Investments 3,333 1,099 (2,234) 17% 5% c) 20,000 $ 8,000 (12,000)
Grants -Private 833 (833) 17% 0% 5,000 $ 5,000
Miscellaneous 43,092 28,475 (14,617) 17% 11% d) 258,554 $ 218,500 (40,054)
Total Revenues 322,913 42,617 (280,296) 17% 2% 1,937,485 1,773,689 (163,796)
Trans from General Fund
Trans from GF -Other
Total Transfers In
47,388 47,388 - 17% 17% 284,333 284,333
4,167 (4,167) 17% 0% 25,000 25,000
51,555 47,388 (4,167) 17% 15% 309,333 309,333
TOTAL RESOURCES 937,230 725,345 (211,885) 17% 26% 2,809,580 2,718,362 (91,218)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
99,927 82,590 17,337 17% 14% e) 599,559 543,424 56,135
300,228 35,218 265,010 17% 2% b) 1,801,367 1,712,406 88,961
17 17 17% 0% 100 100
68,092 68,092 17% n/a 408,554 - 408,554
TOTAL REQUIREMENTS 468,264 117,808 350,456 17% 4% 2,809,580 2,255,930 553,650
NET (Resources - Requirements) 468,966 607,537 138,571 462,432 462,432
a) FY 2011 Budget includes $8,374 which was received in FY 2010
b) Governor's mandated State General Fund reductions in July & Sept 2010
c) Interest revenue projected to be Tess than budgeted
d) LAUNCH grant will be reported in Public Health (Fund 259)
e) Personnel costs will be less 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 37,742 (37,742) 17% 0% 226,450 $ 226,450
Title IV - Family Sup/Pres 10,625 (10,625) 17% 0% 63,750 $ 63,750
HealthyStart Medicaid 15,833 (15,833) 17% 0% 95,000 $ 95,000
Level 7 Services 42,997 (42,997) 17% 0% 257,984 $ 257,984
State Prevention Funds 2,417 (2,417) 17% 0% a) 14,500 $ 6,126 (8,374)
HealthyStart /R -S -G 51,487 (51,487) 17% 0% b) 308,924 $ 263,596 (45,328)
OCCF Grant 100,721 (100,721) 17% 0% b) 604,323 $ 543,283 (61,040)
Charges for Svcs-Misc 1,333 310 (1,023) 17% 4% 8,000 $ 8,000
Court Fines & Fees 12,500 12,733 233 17% 17% 75,000 $ 78,000 3,000
Interest on Investments 3,333 1,099 (2,234) 17% 5% c) 20,000 $ 8,000 (12,000)
Grants -Private 833 (833) 17% 0% 5,000 $ 5,000
Miscellaneous 43,092 28,475 (14,617) 17% 11% d) 258,554 $ 218,500 (40,054)
Total Revenues 322,913 42,617 (280,296) 17% 2% 1,937,485 1,773,689 (163,796)
Trans from General Fund
Trans from GF -Other
Total Transfers In
47,388 47,388 - 17% 17% 284,333 284,333
4,167 (4,167) 17% 0% 25,000 25,000
51,555 47,388 (4,167) 17% 15% 309,333 309,333
TOTAL RESOURCES 937,230 725,345 (211,885) 17% 26% 2,809,580 2,718,362 (91,218)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
99,927 82,590 17,337 17% 14% e) 599,559 543,424 56,135
300,228 35,218 265,010 17% 2% b) 1,801,367 1,712,406 88,961
17 17 17% 0% 100 100
68,092 68,092 17% n/a 408,554 - 408,554
TOTAL REQUIREMENTS 468,264 117,808 350,456 17% 4% 2,809,580 2,255,930 553,650
NET (Resources - Requirements) 468,966 607,537 138,571 462,432 462,432
a) FY 2011 Budget includes $8,374 which was received in FY 2010
b) Governor's mandated State General Fund reductions in July & Sept 2010
c) Interest revenue projected to be Tess than budgeted
d) LAUNCH grant will be reported in Public Health (Fund 259)
e) Personnel costs will be less than budgeted due to open positions
SOLID WASTE
Statement of Financial Operating Data
Two Months Ended August 31, 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 4,667 4,730 63 17% 17% 28,000 28,000
Franchise 3% Fees 33,333 5,635 (27,698) 17% 3% a) 200,000 200,000
Commercial Disp. Fees 140,000 151,818 11,818 17% 18% 840,000 840,000
Private Disposal Fees 219,000 280,034 61,034 17% 21 % 1,314,000 1,314,000
Franchise Disposal Fees 609,833 700,301 90,468 17% 19% 3,659,000 3,659,000
Yard Debris 12,167 21,486 9,319 17% 29% b) 73,000 73,000
Special Waste 4,167 3,380 (787) 17% 14% 25,000 25,000
Interest 2,083 1,281 (802) 17% 10% 12,500 12,500
Sale of Carbon Credits 13,333 (13,333) 17% 0% c) 80,000 80,000
Recyclables 3,333 5,712 2,379 17% 29% d) 20,000 20,000
Total Revenues 1,041,916 1,174,377 132,461 17% 19% 6,251,500 6,251,500
TOTAL RESOURCES 1,434,425 1,492,378 57,953 17% 22% 6,644,009 6,569,501 (74,508)
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out -Road
Contingency
Exp. %
266,686 267,798 (1,112) 17% 17% 1,600,118 1,600,118
477,638 253,664 223,974 17% 9% e) 2,865,829 2,865,829
161,678 161,678 17% 0% f) 970,066 970,066
19,667 19,667 17% 0% g) 118,000 118,000
48,623 48,623 17% 0% h) 291,740 291,740
133,043 133,043 17% n/a 798,256
798,256
TOTAL REQUIREMENTS 1,107,335 521,462 585,873 17% 8% 6,644,009 5,845,753 798,256
NET (Resources - Requirements) 327,090 970,916 643,826 723,748 723,748
a) Franchise fees are received in April. Wilderness Garbage pays monthly
b) Seasonal material - revenue will decrease in winter
c) No market at this time
d) Markets for recyclables varies throughout the year - usually declines in the winter
e) Larger expenditures (i.e. grinding at $75,000) made intermittently during year
f) Due twice a year - November and May
g) Will be expended by end of December
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 4,667 4,730 63 17% 17% 28,000 28,000
Franchise 3% Fees 33,333 5,635 (27,698) 17% 3% a) 200,000 200,000
Commercial Disp. Fees 140,000 151,818 11,818 17% 18% 840,000 840,000
Private Disposal Fees 219,000 280,034 61,034 17% 21 % 1,314,000 1,314,000
Franchise Disposal Fees 609,833 700,301 90,468 17% 19% 3,659,000 3,659,000
Yard Debris 12,167 21,486 9,319 17% 29% b) 73,000 73,000
Special Waste 4,167 3,380 (787) 17% 14% 25,000 25,000
Interest 2,083 1,281 (802) 17% 10% 12,500 12,500
Sale of Carbon Credits 13,333 (13,333) 17% 0% c) 80,000 80,000
Recyclables 3,333 5,712 2,379 17% 29% d) 20,000 20,000
Total Revenues 1,041,916 1,174,377 132,461 17% 19% 6,251,500 6,251,500
TOTAL RESOURCES 1,434,425 1,492,378 57,953 17% 22% 6,644,009 6,569,501 (74,508)
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out -Road
Contingency
Exp. %
266,686 267,798 (1,112) 17% 17% 1,600,118 1,600,118
477,638 253,664 223,974 17% 9% e) 2,865,829 2,865,829
161,678 161,678 17% 0% f) 970,066 970,066
19,667 19,667 17% 0% g) 118,000 118,000
48,623 48,623 17% 0% h) 291,740 291,740
133,043 133,043 17% n/a 798,256
798,256
TOTAL REQUIREMENTS 1,107,335 521,462 585,873 17% 8% 6,644,009 5,845,753 798,256
NET (Resources - Requirements) 327,090 970,916 643,826 723,748 723,748
a) Franchise fees are received in April. Wilderness Garbage pays monthly
b) Seasonal material - revenue will decrease in winter
c) No market at this time
d) Markets for recyclables varies throughout the year - usually declines in the winter
e) Larger expenditures (i.e. grinding at $75,000) made intermittently during year
f) Due twice a year - November and May
g) Will be expended by end of December
h) Transfers made quarterly
RESOURCES:
Beginning Net Working Capital
Revenues
Inter -fund Charges:
RISK MANAGEMENT
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
% of FY
% Coll.
$2,500,000 $2,374,541 ($125,460)
100% 95% $2,500,000 $2,374,541 ($125,460)
General Liability 55,972 55,972 (0) 17% 17% 335,833 335,833
Property Damage 49,003 49,003 (0) 17% 17% 294,019 294,019
Vehicle 30,452 30,452 0 17% 17% 182,710 182,710
Workers' Compensation 151,060 150,085 (975) 17% 17% 906,361 906,361
Unemployment 28,406 28,339 (67) 17% 17% 170,437 170,437
Claims Reimb-Workers' Compensation 5,000 (5,000) 17% 0% 30,000 30,000
Claims Reimb-Gen Liab/Property 3,333 5,028 1,695 17% 25% 20,000 20,000
Process Fee-Events/Parades 250 560 310 17% 37% 1,500 1,500
Miscellaneous 333 (333) 17% 0% 2,000 2,000
Skid Car Training 3,667 910 (2,757) 17% 4% 22,000 22,000
Interest on Investments 5,000 3,667 (1,333) 17% 12% 30,000 30,000
TOTAL REVENUES 332,477 324,016 (8,461) 17% 16% 1,994,860 1,994,860
TOTAL RESOURCES
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Insurance
Total General Liability
PROPERTY DAMAGE
2,832,477 2,698,557 (133,920) 17% 60% 4,494,860 4,369,401 (125,460)
% Exp.
45,645
1,010
1,418
66,667 48,072 18,595 17% 12% 400,000 400,000
Insurance 1,255
Total Property Damage 50,000 1,255 48,745 17% 0% 300,000 300,000
VEHICLE
Professional Service 1,250
Insurance 390
Loss Prevention 317
Repair / Replacement 1,633
Total Vehicle 20,000 3,589 16,411 17% 3% 120,000 120,000
WORKERS' COMPENSATION
Settlement / Benefit 125,748
Insurance 46,424
Loss Prevention 7,518
Total Workers' Compensation 108,333 179,690 (71,357) 17% 28% 650,000 672,000 (22,000)
UNEMPLOYMENT - Settlement/Benefits 26,667 26,667 17% 0% 160,000 160,000
Total Direct Insurance Costs 271,667 232,606 39,060 17% 14% 1,630,000 1,652,000 (22,000)
Insurance Administration:
Personal Services 48,242 47,445 797 17% 16% 289,453 289,453
Materials & Service 38,139 27,374 10,765 17% 12% 228,834 228,834
Capital Outlay 17 - 17 17% 0% 100 100
Total Insurance Administration 86,398 74,819 11,579 17% 14% 518,387 518,387
Contingency 391,079 391,079 17% n/a 2,346,473 2,346,473
TOTAL REQUIREMENTS 749,143 307,425 441,718 17% 7% 4,494,860 2,170,387 2,324,473
NET 2,083,333 2,391,132 307,798 - 2,199,014 2,199,014
Year End
Budget
Projection
Variance
100% 95% $2,500,000 $2,374,541 ($125,460)
General Liability 55,972 55,972 (0) 17% 17% 335,833 335,833
Property Damage 49,003 49,003 (0) 17% 17% 294,019 294,019
Vehicle 30,452 30,452 0 17% 17% 182,710 182,710
Workers' Compensation 151,060 150,085 (975) 17% 17% 906,361 906,361
Unemployment 28,406 28,339 (67) 17% 17% 170,437 170,437
Claims Reimb-Workers' Compensation 5,000 (5,000) 17% 0% 30,000 30,000
Claims Reimb-Gen Liab/Property 3,333 5,028 1,695 17% 25% 20,000 20,000
Process Fee-Events/Parades 250 560 310 17% 37% 1,500 1,500
Miscellaneous 333 (333) 17% 0% 2,000 2,000
Skid Car Training 3,667 910 (2,757) 17% 4% 22,000 22,000
Interest on Investments 5,000 3,667 (1,333) 17% 12% 30,000 30,000
TOTAL REVENUES 332,477 324,016 (8,461) 17% 16% 1,994,860 1,994,860
TOTAL RESOURCES
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Insurance
Total General Liability
PROPERTY DAMAGE
2,832,477 2,698,557 (133,920) 17% 60% 4,494,860 4,369,401 (125,460)
% Exp.
45,645
1,010
1,418
66,667 48,072 18,595 17% 12% 400,000 400,000
Insurance 1,255
Total Property Damage 50,000 1,255 48,745 17% 0% 300,000 300,000
VEHICLE
Professional Service 1,250
Insurance 390
Loss Prevention 317
Repair / Replacement 1,633
Total Vehicle 20,000 3,589 16,411 17% 3% 120,000 120,000
WORKERS' COMPENSATION
Settlement / Benefit 125,748
Insurance 46,424
Loss Prevention 7,518
Total Workers' Compensation 108,333 179,690 (71,357) 17% 28% 650,000 672,000 (22,000)
UNEMPLOYMENT - Settlement/Benefits 26,667 26,667 17% 0% 160,000 160,000
Total Direct Insurance Costs 271,667 232,606 39,060 17% 14% 1,630,000 1,652,000 (22,000)
Insurance Administration:
Personal Services 48,242 47,445 797 17% 16% 289,453 289,453
Materials & Service 38,139 27,374 10,765 17% 12% 228,834 228,834
Capital Outlay 17 - 17 17% 0% 100 100
Total Insurance Administration 86,398 74,819 11,579 17% 14% 518,387 518,387
Contingency 391,079 391,079 17% n/a 2,346,473 2,346,473
TOTAL REQUIREMENTS 749,143 307,425 441,718 17% 7% 4,494,860 2,170,387 2,324,473
NET 2,083,333 2,391,132 307,798 - 2,199,014 2,199,014
RESOURCES:
Beg. Net Working Capital
Revenues
Property Taxes - Current
Property Taxes - Prior
Federal Grants
State Reimbursement
Telephone User Tax
Data Network Reimb.
Jefferson County
User Fee
COPS Reimbursements
Contract Payments
Miscellaneous
Interest
Interest on Unsegregated Tax
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
of FY
Coll.
Year End
Budget Projection
Variance
$5,861,335 $ 6,691,945 $ 830,610 100% 114% $5,861,335 $6,691,945 $ 830,610
1,059,604
23,000
79,000
1,667
91,667
2,000
5,167
8,333
5,000
11,667
1,417
6,667
333
(1,059,604) 17%
71,400 48,400 17%
(79,000) 17%
1,518 (149) 17%
(91,667) 17%
1,528 (472) 17%
331 (4,836) 17%
45,869 37,536 17%
(5,000) 17%
(11,667) 17%
1,270 (147) 17%
9,384 2,717 17%
28 (305) 17%
1,295,522
0% a) 6,357,621
52% 138,000
0% 474,000
15% 10,000
0% b) 550,000
13% 12,000
1% 31,000
92% c) 50,000
0% 30,000
0% 70,000
15% 8,500
23% 40,000
1% 2,000
6,357,621
138,000
474,000
10,000
550,000
12,000
31,000
50,000
30,000
70,000
8,500
40,000
2,000
131,328 (1,164,194) 17% 2% 7,773,121 7,773,121
7,156,857 6,823,273 (333,584) 17% 50% 13,634,456 14,465,066 830,610
668,133 587,729
254,024 210,407
93,833
169,010
1,087,409
% Exp.
80,404 17% 15% 4,008,798 4,008,798
43,617 17% 14% 1,524,144 1,524,144
93,833 17% 0% 563,000 563,000
169,010 17% 0% d) 1,014,061 1,014,061
1,087,409 17% n/a 6,524,453
- 6,524,453
TOTAL REQUIREMENTS 2,272,409 798,136 1,474,273 17% 6% 13,634,456 7,110,003 6,524,453
NET (Resources - Requirements) 4,884,448 6,025,137 1,140,689 - 7,355,063 7,355,063
a) Approximately 85% of the property taxes are collected in October and November
b) Received quarterly
c) Crooked River Ranch paid annual fee
d) Transfers made as requested to Reserve Fund ($260,000) and in September to New Facility Property Fund ($754,061)
Health Benefits Trust
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
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 1,874,333 1,900,589 26,256 17% 17% a) 11,246,000 11,403,534 157,534
P/T Emp - Add'I Prem 8,333 5,967 (2,366) 17% 12% 50,000 50,000
Employee Prem Contribution 83,333 80,385 (2,948) 17% 16% 500,000 500,000
COIC 162,500 221,516 59,016 17% 23% 975,000 975,000
Retiree / COBRA Co -Pay 75,000 147,193 72,193 17% 33% 450,000 450,000
Interest 16,667 24,046 7,380 17% 24% 100,000 100,000
Total Revenues 2,220,167 2,379,697 159,530 17% 18% 13,321,000 13,478,534 157,534
TOTAL RESOURCES 18,620,167 19,367,837 747,670 92% 65% 29,721,000 30,466,674 745,674
REQUIREMENTS
Expenditures:
Personal Services
Materials & Services
Conferences and Seminars
Claims Paid-Medical/Rx
Claims Paid-Dental/Vision
Refunds
Insurance Expense
State Assessments
Administration Fee
PPO Fee
Health Impact
Printing
Program Supplies
Workplace Clinic
Other
Total Materials & Services
Capital Outlay
Contingency
21,547 20,429
Exp. %
1,118 17% 16%
129,280 129,280
500 500 17% 0% 3,000 3,000
2,260,207 2,148,469 111,738 17% 16% b) 13,561,242 12,413,376 1,147,866
339,730 283,756 55,974 17% 14% b) 2,038,378 1,639,477 398,901
(9,191) 9,191 17% n/a (9,191) 9,191
55,000 59,052 (4,052) 17% 18% 330,000 330,000
12,500 12,500 17% n/a 75,000 75,000
50,000 49,709 291 17% 17% 300,000 300,000
6,667 6,547 120 17% 16% 40,000 40,000
8,500 8,462 38 17% 17% 51,000 51,000
1,667 561 1,106 17% 6% 10,000 10,000
16,667 1,680 14,987 17% 2% 100,000 100,000
295 (295) 17% n/a 295 (295)
6,357 4,146 2,211 17% 11% 38,141 38,141
2,757,794 2,553,485 204,309 17% 15% 16,546,761 14,988,098 1,558,663
100.00 100 17% 0% 100 100
2,174,143 2,174,143 17% 0% 13,044,859 13,044,859
TOTAL REQUIREMENTS 4,953,583 2,573,914 2,379,670 17% 9% 29,721,000 15,117,378 14,603,622
NET (Resources - Requirements) 13,666,583 16,793,923 3,127,340 - 15,349,295 15,349,295
a) Year End Projection is amount appropriated in operating departments' budgets.
b) Projection based on annualizing 9 weeks of claims paid. YTD actual is $269,226 per week.
9/13/2010
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
REQUIREMENTS:
Expenditures:
Personal Services
Materials and Services
Debt Service
Capital Outlay
Total Expenditures
Deschutes County - Fair and Expo Center
YTD -Budget Basis Commissioners
Statement of Financial Operating Data
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Year End
Budget
Projection
Variance
$ 2,809 $ 6,590 $ 3,781 100% 235% $ 2,809 $ 6,590 $ 3,781
112,957 238,267 125,310 17% 35% a) 677,742 766,008 88,266
333 296 (38) 17% 15% 2,000 1,963 (37)
8,500 - (8,500) 17% 0% b) 51,000 51,000 -
1,500 440 (1,060) 17% 5% 9,000 9,440 440
7,000 255 (6,745) 17% 1% 42,000 42,255 255
35,167 65,360 30,193 17% 31% a) 211,000 206,360 (4,640)
15,500 13,000 (2,500) 17% 14% 93,000 93,000
7,500 (7,500) 17% 0% c) 45,000 45,000
736 6,443 5,708 17% n/a 4,414 10,058 5,644
189,193 324,060 134,867 17% 29% 1,135,156 1,225,084 89,928
32,987 - (32,987) 17% 0% 197,919 197,919
4,146 - (4,146) 17% 0% 24,873 24,873
13,333 - (13,333) 17% 0% 80,000 80,000
38,539 - (38,539) 17% 0% 231,232 231,232
17 - (17) 17% 0% 100 100
89,021 -
(89,021) 534,124 534,124
281,022 330,650 49,628 17% 20% 1,672,089 1,765,798 93,709
Exp. %
155,316 159,920 (4,605) 17% 17% 931,893 936,497 (4,604)
79,448 68,815 10,633 17% 14% 476,685 480,053 (3,368)
19,261 19,261 17% 0% 115,563 115,563 -
17 17 17% 0% 100 100
254,040 228,735 25,305 1,524,241 1,532,113 (7,872)
Transfers Out - Reserve Fund 1,667 1,667 17% 0% 10,000 10,000
Contingency 22,975 22,975 17% n/a 137,848 137,848
TOTAL REQUIREMENTS 278,682 228,735 49,947 17% 14% 1,672,089 1,542,113 129,976
NET (Resources - Requirements) 2,341 101,915 99,574 223,685 223,685
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
CAPITAL PROJECTS
Secure Treatment Facility
•
Bethlehem Inn
■
O
(f)
LL
0
U
N
o -• r
C)
w
(n 0.
a) CO O)
LUQ
• U
0 ao 0
a) 2E
co
C
O
O)
m
0
a)
U
C
(o
co
0
w N
O 0
RESOURCES:
rnCO
C)
l() N
N
(0
ti co
N
I
N
N
O
U
a)
U
C
(o
N
N
O
O
C y
vi d
U
a)
U
m O
00
03 c
EXPENDITURES:
a) to N (0 O —
O' Cr) ' Cr) N ' CO CO CAD if
O (0 v (()O) O O
.-- CO ----
0) CO 0) 0
-
O(O0)0 N OA -(00 -
A- (n Cr) O 1-C) U) O Cr) N CO N-
CO 0) O Cr) N 1- U) CO CO A- N-
V CO O CO l( Cn .- O O
eh (f) — C) co
co (Of) co r- O co O O
(C)cr ' O 0) ' 0 (f) ' ' N
(0 O (1) O v- ,-
co to .- co O
O I� ONO N co co O
Cr) (f) Cr) (f) O Cr) N CO
co Cn 1- C) N co O ti
O (0 (f) (0 (f) 0)
U C) co
0)
O
1 1 1 1 1 1
N O N 1- Cr) CO O A-
0) 1-C) tf) 1'C) to O Cr) N CO I-
(ntiCn�C)N1- OOA-
C) O (O (n (O (n O O
Cr) CO
O
(0
N
co
ti
Cr)
N
ti
O
co
co
(0
O
co
co
co
c)
co
I�O O
▪ (000
(0 (.1. -
CO (O
N v N
COO (00 O
th
M
M
O
O
ti
(C)
N
N
u)
N a)
a)
U
V 1 (J)
d
8Z a)N) C
co coC ▪ U
7 = a)
a)•- ti N . ` > ) CO a)
', a) a) 0) 06 7 > C (0 •Q O
0 U Ca d LL d ? 0
c) m U E co E.
U cai oo ca '-' w E
°a U N N 0) D U O 'C O O C a) a)
O C s 'c 7 d N U 0. .-
.....
� 2 .0 a tp .-- m> '-.= ...7- 0 `0 0 ( 3 m c
a Qwt-a55u_<0_Di0~ vz0�0
ti
CO
0)
Cr)
(n
CO
O
CO
U)
N
Cr)
Cr)
O
co
r --
N
N
(0
N
Cr)
O
(0
O
co
co
O
O)
M
O
O f- M
O N (C)
(n
N O
tri e.
Total Expenditures
(0
v
Z
cw
M
a)
a
Q N
U
P ci
U o)
O W
O zq 0O
• LL Q
as 03
u
c • U
mW
0
Amount Paid
0
0.
0
v)
Cl)
0
1_
O
0
c
CD
0)
O
rn
O
CO O
M M N-
0) N
O N N
CO CO
� O
co O co
0))o O)
a)) CM7 N
i1•)
N 0000\10N--
0) •ctti COA-0tiN000InCe) O)•Mti MNtiOrCf) OA-N00N
0) CO I- O M O ti Q) O CA O O l!) .- co co l!•) a0 N. ) 0
A- N N 4 A- O A. CO A- ti O a0 O M N CO CO N M M o0 ui m cc ti
N O N N CO N N A- A- r- A- A- A-
0
Fi 0
cc o a) 0
O N0
cam') M = v
N = p)
Co- In l!) _
EA _ O O M U_ O N C6
M
CO O co ,- o M L N O
O ( O O0N>CA^�
d
O co Ef,aS,j 'd: "p N
CD CV v) 0 CA Eft
eft O° O\ N f� N• y y 0 3 0 0 o p
-00 0 0 �or-cc 0) ......i., o�(6(0
0 ` 00' .N O O O 0 'II oc L'""al co C O E 72 m
M o(0aiS_o 0 ETr���OM�� OU O") 00 0 O
o O O N p Cyp O c - a) C O U
Ef(6 O c
in C (� O uJ O - Ll31 O •�
v- �+ O N COO p C6 0 o 75
> V N U N
U \ (0 c c V C o vii coOvcoCQ d O m 0 C N 0) V y • O
N X (00 .` ,0 O O O O C L L- a "O C CC .� C O) "
v) O O a) v) y EC (C L O •N ` c 0
O c 0 .N N a) (n e U to C O ) a) L c y 0 co V O U a) Np O s w
• vi N v) (` (` °iS cco o v O N °_ v`p- c COCv -a N v 0
co c c o�S j j L o ,_ o c o o U -co CSC N S>,t)-F,0E E
a "cam 0 o a)U - rnm �•4 3Hrn�U'� c o
C X 0-7,,,C.
Q U ate) C C 'V >'. U Y a U `O Op U .0 U U C U 0 E
Owo N 0v"O•_ C . $= y (Cvd%.N ON N 0 to to O y 0
0)i� c � QQQ�2�>>(AD25QO2LL,2a.2UwHcC
a) E C O_NM O OO OtiOO,- NM
►- m co N M O O f� O N N N N N M CO M Cl
2715CI. CC ...7_c *kit ** k* **k*k*k* 4:t 4:k t4t4t k4t4t4t4t
O 0
O 0
a) a)
L
0 0
Q Q
Q Q
UU
Total Architect
Engineered Structures Inc
M
N
O
M
Total Change Orders
CO
ti
0
ti
N
O
N
N
O
U•)
Total Engineered Structures, Inc.
Total Encumbrances & Commitments
(O
O
c
Co
O
co
d•
c
U
a)�
w a N
C
O
d �
To
to a)
p
aL
c
corn
p
To L
CC
U
a)
d
CO
•a
m
U
rn
Deschutes Co
PROJECTION
0
U�)
a) Co
0
0
Received and
a)
c
a)
Q
X
w
RESOURCES:
CD '- A) 0)
I. CD CO CD
ti r O
M N 00 0
N CMO CD
M N
0 CO 0) 0
O N M O
d• CO O
O CA O 0
N C 00 CO
M N
C7
co — 0) O)
ti •c co co
N CD O) r -
c6 O 00 0
0 M is- CO
N M CD
Cr; 1-
0
U
m
U
c
Co
7
0
m
c
vi y
c
U C`0
d m
O aa,
LL.
Transfer In -911 Fund 705 / 710
m
m
c
Total Resources
EXPENDITURES:
0) (Y) COO0) 0)
0) ' d d• CO co
O •c N I.�F
C I
1- I's
N
M
O)
0) CO CO 0 N CO I-. 0 IO CO 0 CO
CO CA CO 0 CD CA CD 0 CO I's 0 d•
d• d• O CD CD 0 O d• I- O CA
d N O N N- d• N I-
I� LC) N 0) CD
N I�
0 CO 0 I's 0 0
O d0• ' O o' O O
O
CD 0 N 0
N
CA 0 00 O N CO I's CO 0 CO O
CA CO 1- CO 0 CA CO CO I' N
CA d_ 0) co co 0 0 N 0 (O
cO d N N O0) d N
N M
0 I 1 1 1 1 1 1
N
0 CO ON CO I's CO 0 CO 1- O
COCl 0)) CO _ CO00 CO CO 1') CO CO N.t's ' CO.
0 O d O N ti d' N
N N 0 M
0
O
CD
(-4
r -
CA
O)
N
d
ti
M
O
N
CO 0 0
N 0 0 0)
d 0 0
O I- CD 0
CD O M d•
0 0 0 I-- 0
0 0 0 0 CD 0
CO d: O O CA O
M I- CD 0 0
O M
CO N r- N CO.
N
O O O
O O
Lci tri
0 M N ((O
Cr;
0
M
0)
(O 0 0
.1- r-
N
O
N
CA
N
0)
0
O
O
0
0
M
(D
co
M
CO
M
0)
d•
Q)
M
M
0)
CO
to
m
z m
V
a) X to
U.-. u- '1
U otS 1,5 N
U Z a) N co E Co
a) y a) -"
Cn p) U '3 C� CD ` N > 3
- m m 0) H c E 3 c Q
•
mTo
a 0 m rna w'C v > x E;o
t aj d 7 p LL
to 3 U c •0' �o vi ate) o_od rn(o
'e i, ca) m ca U m N .. o c E �) o V
- c `a c �� ( 0 U 5U) a) a3 pc �o
�����mya�Ni�•`mtcH �mco��H
Qw125: c c �Qaw02 UzDOUu.i-
M
CO
N
M
(p
(p
N
CO
N
M
CO
(p
CO
CA
(p
CA
Total Expenditures
N
(o
N
N
N
N
CO
N
N
N
m
z
PROJECTION
0
F-
O
O
0 cti
0
G)
E
E
E
O
U
ccs
Received and
RESOURCES:
CO N nt
I` CO N
I`
CO
N
CO 0 'I'
N.
ti0N
C)U)tf)
'O O CO
N
cY)
0 N
O N O
O N to
t o I
CO
N CO
M
CO �f
N- CCOO N
tCjMcCp
N c')
cY)
COet
r- CSO N
O U)
N M
c)
CO
ti
't9
CO
Ce;
O
U
c.)
U
c
7
to
0
m
c
ui
v
O c
4)O 2 0
U y
O d1
R
m°LL _H
EXPENDITURES:
COY) COY) ti O O co CO ti
0 ' V ' nr CO U) ' ti Cr) '
O V v N IR N Cri
0 CO CO O N CO I- O U) CO U) 0
CY) a) CY) O C0 0 0 O CO ti N- 0
) 0(0 CO U)0 N-CDO
N 0 N N 0 r
N U) N 0 to
00) 000 00 0
0 - ' 0 '— ' 0 0 ' ' ' O
N- r— N O O
CO U) N U)
N
OtoCOCDNCOIsco to cotoF-
r-) 0 ch CO 0 0 CO CO ti ti F -
o
MN— 000tU)�t-cY)to
00 CV N N
N
cY)
N
'o to CO 0 N CO N- CO L) c0 to
M 0 CI CO 0 0 C0 c0 r-
cOI-Tr000 toU)CY)to
toc0ON(N0
N N 0 to
CO
CO
to
co
O
N
Cr)
cY)
cY)
t1)
ti
O
co
0
O
r-
03- O
ti
N O O
O
O I� CO
CO 0 C")
N
to00
co
M ti co-
o O Cr)
CO N
N
ti
ti
0
cY)
CO
N
cY)
ti
CO
ten-
0.1
ti
ti
0
N
ti
ti
to
0
to
cY)
co
O
to
N --
co 0
v v 'Nr)
C) CY) 0
tr
cc) NI N-
1- O
csi N' N
y
m
O V
(n 0U ai
C 0 C) D- c '7'0— N co N� c > y °�O
c
Q U)m a) v) 0• '.0• v rnd LL • v CD >2,
cnz -2 Eng U E 0 U U cc N' D 0.
co
O N cam. m O co
°� `m rn o a�•N E o c= -g U
m C O E 7 a C j) O 1, U U N O CCI
��'rnn�a- a)_ c 2�o �3Nnu)0
Z 0
Total Expenditures
d
Z
H
z
W
CO 1-
C o
p N
.) M
W Z
O <
d co
r Q
'a Z o
U<<
m
rn2
U
z
W
Amount Paid
c
0
CO 0
0
O 0
N O
to
d'to O
ti to
CO N 1-
M
In N t.
N
CO 0 CO 0
O c-
O O O) O
N fh Q)O
N N in
LCA Architects
LCA Architects
Total Architect
Interior modular walls
Herman Miller
to O CO O r O f� CO CO O N O O CO CO 1— N O •-• CO 1— 1— to CO N-
o-) COC�)C)Q)-OCO0)t-t-N0O)CONC)Q)44O toNt.
Q)
celC 0)0 to co_ co CO0 --NtnMOOD 4CO—MDQ)
•- r N CO CO (0 r- O O N CO CO N Q) f� N CO c`') f- M
f� C4) - r r - c O C0
O
N
Co to as
o N. N.
M MN N
1.0 to co
_CO
cei O 1.6O _ N O Eft
N CO N
CO O co o Onj Q) . O
o
O
�v 0 N a)? p\ O co c
� o , EA
N Eus0co--�c .
0 0p U n '�0
OaO' O0CN a....•O �cri o \ 2 to o
W8cnMCo� 9_o �NOO
0 E 27 CO o O N ea C CrIC WE O� ' � E c.N wO
y 0y . L UCO `_O Oa0. C O•tU
.cr `�N m a>�p
a 0 471
>y ca s o
NNU c".4 -E U w, " U .c 7 N y•. CE! o3
P2 viC CS L O p O 2 cv •7 cal 7 U N 7v
0
O`ON'00 C y ~O V
•wOU O 0 wV O w.- �_ E N-0 -O C E
0— c- - N a) pMv)va — O Vx 0
3 a)— U:- a) wwco5 <ci—QT-C7Utn2drnoWW
C Crn2< li-0DO1-cotncocp.rNMvinON.NMM
E5) as _
oUa*a*a**a*a*a*a*a*a*a*a*a*a*a*a*a*a*a*a*a*a*
Engineered Structures Inc
Total Change Orders
Total Engineered Structures, Inc.
Total Encumbrances & Commitments
PROJECTION
a)
U
c
N
O
F-
N
0)
O 0
CLm
O
U N
a) 00
•O
a
Encumbrances
& Commitments
Received and
0
a)
O
a)
a
x
w
RESOURCES:
co O li) lig
MOCOCOCO
co co r coco. ai
ICJ
N CO
CO N CO
T
O O A—
• a
cci o
CO Is N
O
O
O
N
0
O• 1
LL • LL m
c i
S ( O
mu'
m
' ai-
ler
EXPENDITURES:
N
M
CO
CO
U•)
CO -
c) O
O
O
O
c0
ActN
N
CO
N
LO
ArtN
CO
N
X
LL
CeS
� w
U
LL
(/)a)
;0
ca
O
a) •coC
c
AAct—
co
U•)
O
O
O
O
O
Total Materials & Services
0)
0)
1.6
11)
Act
O O r--- O 0 0 0 0 0 0 f� U)
O OO)O 000000 CA CO
O O CT O 0 0 0 0 0 0 0 Ci)
cri
�i) ll) 1.6O CA O '.0 O O
M O CO I. M co CO
N N ' O O
N
O O 0
O 0 0 0 0 0 0
O O O O O O O O O O
C�•) r O r O CO O� Cc) coO
N N
c
LL c
U N
cn
0
0 ▪ ac) 0
°. cco E w as>
2 t°E 20 > 2 3
3 • o u°) U ° E O
E x c 0 ° E E N
N .Li.x w, O LV to a) O C .�_.
N
'5 E 2. 7 p O fn °� °
z • a Co p c O a N
Qo ;• woii 8areaw5CI-
(13
0 � 1-
0
O
O
CO
O
Q)
O
CO
CO
N
ActN
A—
O
O
O
N
O
4
CA
Total Expenditures
Amount Paid
c
O
0
.c.. -
0
L0
co
a)
0
L
O
c
a)
>
0
M
0
Radio Dispatch System
in
0
0
M
co
co
(3)
(3)
Cr)
C
0
0
0
O
U
O O
>` O N
c o
0 u
y
N 0 7
Or ZT
� 7
>' Q
_ L
0 u
C. L
E~
0
2
H
2
U
0
C/)
PROJECTION
0
U
C
0
co
N 01
O 7
am
0
U,a)r
.0al
00
a.
rn rn
(1)c
U d
CC)
E
� E
U O
W 060
c
C
0
713
U
0
N
c
C
a)
0.
X
W
RESOURCES:
CO M
CO c') O
N: O N
00 .-
0 M 0 0
Cr) 0 Cn 0 0
0 0 •- 0 0
In O N Nco to O
N N. N
0 0 0 0
0 0 0 0
0 co O O
M O N O
(n (n r r
0
• O M O
C)0c 0 )
O O co. N
(f) ONO)
CO • N N
r
1 1 1 1 1
• 0 Cl) 0
MOM00)
O O O N
(f> O N CV O)
N f• N
CA
7
H
T
FT a)
0 7
C
>
rn 14-
rs
V)O 0
C c
c
H 0 C
O
0
N
Total Resources
CO 00 0 0) - 0) (0 CO
(f) O O f. ' 000 (0O ' N O0
O O co N O) M (n
CO 00 O 0) co N 0) 0 CO N 1-
V) CO 0— CO 0) (O Co on N co
(f) O O I. M O t—O O N f. N
I. 0) CO (0 In M In M N (C) M
N N N
r r
0 0 0 C0 O 0
O 0 0 CO 0) 0 0
0 0 0' M N O' N O.
• O) In 0 M N
CO
0)
O 00 O O) N 00 to 0) N 00 I.
CO 00 0 — CO 1.0 00 — M 1.0 N O
In O O I. C I. M O N I. N
N 0) (0 o6 (f) M
CO N —O
N. 0
(0 ' 1.0
00 M
co 00 co 0) N 00 to O) N 00 h
N 00 (n '— CO (0 00 M (n N O
0 QCN N.N. N
• 0)N 00(6OCV' M—(AM
N —0
O)
CO
M
O
0)
M
M
O
O
N.
O
0
(n
co
N
O
O
N
r C+) CMS)
N M M
00 0) 0)
CO r- r
N (1) (n
r r
co Ov o
of co
r (- N
N N
CO CO
M
0)
O
M
0)
0)
O
co
(0
0)
a
O
N
N
O
0)
M
co
0)
03
GI
M
(0
CA E o
_U a) c
0 ° Eaau) (a
C 0 U 7 0 a+73
0) 0) y CO - ▪ o• 7 C
N
▪ co Tyr a 5 C a' 7-+
c N 6O a a) a+ Q, +ti U
(0 O (7 > c
I-
0 aa) 0 g cca rn.�) v) °�- 0 tau 0(n O.
Z Ca • s C O c0 'C vi C N d O (+4 ti a) c W
X (o<W W -.1 0_ CL o < I-
Ci. - m •• "'
W z 0 Ih 1--' z Na
U
a)
O
a
4-
0
CC)
M >
M CO
to
CO
O 0
U
O 0
O 0
a)
U
a) -to
0 c
a 7
N v
N
U a)
U 7
CCO CD
0
7
4) >.
C
• 7
o
Oa
O 73
M
O
EH O.
y a)
C _
4-
4O U
O C
7
(6
> y
0 0
CI) y
U O
C U
C9 Q
7
y
Cif M �.
•- r M
O N
O N
U y +
C
c O N.CO
y U 0
0
O ) Co
y 2 N
cl) co0
0 cc 0
2<0
O O (O
c 0 co
co
CC)
C
LL
cfs1
N Z
C.)
>. g
N I— O
O m p
2 Na)
cc Oco
Z 7
L Q (7
N
O W Q
g O
LL j
cV
aZ
-• w
U
a)
c,)
Amount Paid
C
0
U
a)
0
0
v
C
a)
0 0
0 0
O ti
Architectural Services
Reimbursable expenses (not to exceed)
N
CC)
It)
CC)
0
O
0
'N00
rn L)
M M 0
CD -
0 000 '
CC) CD CA
M r CD
CrN
0 0 0 0 0 00 0) CD 0) 00 M
CC) CD 0 0 0 N. CA C') CD O
C') CC) O O CC) O) 0) CO 0) CO
tri O N Q) N N N
cc
as
N C
a)
c N Y c
0
p) a) .. �•
C
a `)v
O 0
co v
• a c
Z • c�°)o=
0
O U
n U c co
rn C N j� O • V N O
c u) _ C) w 65 a) Ca -al
_
C7) c a) U C c O) L
W —I cn < U LL D °
O a)
CD • CD
3w
U
Q Q
CD a)
CC CB
C C
C c
d d
a
O
CD
a
(0v v - if)
-12 v
CD
- — • a)
C 7
CD N N O O
O C)o m
as co CII C CC CN
c
C`a 2 ccr,• 00 0000
U Q 2
N
00
a)
C7
CD
CD
CA
Total HSW Builders
RESOURCES:
Beg. Net Working Capital
Revenues
Grants - Private
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service:
Negative Interest Revenue
Interest Payment
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Deschutes County
Bethlehem Inn (Fund 128)
Two Months Ended August 31, 2010
Year to Date
Budget
Actual
Variance
FY %
CoII. %
$ (2,725,000) $ (2,722,510) $
2,861,000
2,861,000
2,490 100% 100% $ (2,725,000) $ (2,722,510) $ 2,490
- (2,861,000) 8% 0% 2,861,000
- (2,861,000) 8% 0% 2,861,000
136,000 (2,722,510) (2,858,510) 8% -2002%
Exp. %
36,000 4,038 31,963 8% 11%
- 12,861,000)
- (2,861,000)
136,000 (2,722,510) (2,858,510)
36,000 36,000
100,000 100,000 8% 0% a) 100,000
136,000
4,038 131,963
- (2,726,547) (2,726,547)
a) August 2010 interest expense - $1,983.14.
b) Recap of expenditures - inception through August, 2010
Land/Building (Amertitle) - July 2007
Hickman Williams
City of Bend - May 2008
KN EX CO
Kleinfelder
Total expended on facility
Interest on Negative Cash Balance
Total expended
$ 2,241,313
17,578
250,000
5,289
3,732
2,517,913
208,635
$ 2,726,547
8%
3%
b)
100,000
136,000
- 100,000
- (2,722,510) (2,758,510)
Year End
Budget
Projection
Variance
2,490 100% 100% $ (2,725,000) $ (2,722,510) $ 2,490
- (2,861,000) 8% 0% 2,861,000
- (2,861,000) 8% 0% 2,861,000
136,000 (2,722,510) (2,858,510) 8% -2002%
Exp. %
36,000 4,038 31,963 8% 11%
- 12,861,000)
- (2,861,000)
136,000 (2,722,510) (2,858,510)
36,000 36,000
100,000 100,000 8% 0% a) 100,000
136,000
4,038 131,963
- (2,726,547) (2,726,547)
a) August 2010 interest expense - $1,983.14.
b) Recap of expenditures - inception through August, 2010
Land/Building (Amertitle) - July 2007
Hickman Williams
City of Bend - May 2008
KN EX CO
Kleinfelder
Total expended on facility
Interest on Negative Cash Balance
Total expended
$ 2,241,313
17,578
250,000
5,289
3,732
2,517,913
208,635
$ 2,726,547
8%
3%
b)
100,000
136,000
- 100,000
- (2,722,510) (2,758,510)
Deschutes County - Solid Waste
Area A Closure and Cell 5 Construction
As of August 31, 2010
"Area A"
"Cell 5"
Landfill
Closure Fund
611
SW Capital
Projects Fund
613
Total
Engineering Contract
G. Friesen Associates, Inc.
Original Contract
Change Orders:
Change Order #1 (Note a)
Total
Paid through August 31, 2010
Balance
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
Total
Paid through August 31, 2010
Balance
241,869.00
19,656.00
261,525.00
246,804.91
14,720.09
2,097,140.50
14, 302.54
24,885.69
152, 500.00
1,332.00
2,486.98
2,292,647.71
1,855,097.83
437,549.88
Total of Engineering & Construction Contracts
Original Contracts
Change Orders
Total
Paid through August 31, 2010
Balance
2,339,009.50
215,163.21
2,554,172.71
2,101,902.74
452,269.97
182,516.00
182,516.00
167,795.92
14,720.08
424, 385.00
19,656.00
444,041.00
414,600.83
29,440.17
3,290,779.98 5,387,920.48
45,094.00 45,094.00
14, 302.54
24,885.69
305,000.00
148,958.89
1,332.00
152,500.00
148,958.89
225,000.00 225,000.00
2,486.98
5,167.76 5,167.76
3,200.00 3,200.00
3,870,700.63 6,163,348.34
2,775,526.01 4,630,623.84
1,095,174.62 1,532,724.50
3,473,295.98
579,920.65
4,053,216.63
2, 943, 321.93
1,109,894.70
5,812,305.48
795,083.86
6,607,389.34
5,045,224.67
1,562,164.67
Notes:
a) Additional landfill gas investigation per DEQ as part of a requirement
to address offsite landfill gas migration.
b) Construction of Cell #5 began in FY 2008. Through June 30, 2009, $3,557,678
has been expended and reported as "Construction in Progress" on the County's
CAFR FYE June 30, 2009. Expenditures include payments to JAL Construction,
Taylor NW, KN EX Co, Jack Robinson & Sons.
c) To date in FY 2010, payment has been made to Central Electric Co-op:
$13,311 for the Closure of Area A and $20,822 for Cell 5.
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Related Travel Expenditures
FY 2011
9/20/2010
Jul _
Aug
YTD Total
Tammy Baney
_
Conf/Sem & Educ/Training -
-
-
Travel Meals -
20
20
Accommodations -
77
77
Mileage reimbursement -
240
240
Ground Transport/Parking -
-
-
Total Baney -
337
337
Dennis Luke
Conf/Sem & Educ/Training -
-
-
Travel Meals -
56
56
Accommodations -
77
77
Mileage reimbursement -
282
17
282
17
Ground Transport/Parking -
Total Luke -
432
432
Alan Unger
Conf/Sem & Educ/Training -
-
-
Travel Meals -
-
-
Accommodations -
-
-
Airfare 1,133
-
1,133
Mileage reimbursement -
-
-
Ground Transport/Parking -
-
-
Total Unger 1,133
, -
1,133
Other
Conf/Sem & Educ/Training -
-
-
Total Other -
-
-
Total - BOCC Department
Conf/Sem & Educ/Training -
-
-
Travel Meals -
76
76
Accommodations -
154
154
Airfare -
-
1,133
Mileage Reimbursement
522
522
Ground Transport -
17
17
Total - BOCC Department -
769
1,901
FY 2011 Budget
20,100
Percent of FY 2011 Budget Expended
9.5%
9/20/2010