Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Finance Update
Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA February 23, 2015 (1) Monthly Investment Report -January 2015 (2) January 2015 Financials Municipal Debt $ 5,420,000 3.51% Corporate Notes 36 ,224,000 23.43% Time Certificates 2 ,780,000 1.80% U. S . Treasuries 7,000 ,000 4.53% Federal Agencies 51,930,000 33.59% LGIP/BOTC 51,253,798 33 .15% Total Investments $ 154.607.798 100.00% I Total Portfolio: By Investment Types Municipal Debt 3.5% Corporate Notes 23 .4% Time LGI Certificates 33 .2% 1.8% U. S. Treasuries 4.5% Federal Agencies 33.6% Category Maximums: U.S. Treasuries 100% LGIP 100% Federal Agencies 75% Banker's Acceptances 25% Time Certificates 50% Municipal Debt 25% Corporate Debt 25% Term Minimums 0-30 days 10% Under 1 Year 25% Under 5 Years 100% Investments By County Function General $ 154,607,798 $ Investment Income Fiscal Year 2014-15 Jan-15 I I Y-T-O 107,690 $ 583,444 -- Total Investments $ 154 ,607,798 Total Investment Income Less Fee: 5% of Invest. Income Investment Income -Net 1$ 107,690 (5,385) 102,306 583,444 (29 ,172) $ 554,272 Yield Percentages -~.~BOTe I LGIP ~ 0.50 % 0.50% Investments ~ 0 .80 % 0.81% Average ~ 0.71 % 0.73% C oniDa rat • 24 Month Treas. ~ 0.48% LG IP Rate ~ 0.50% 36 Month Tre asu~ 0.77% Months to Maturity o to 30 Da y s 62.65% Under 1 Year 42.58% Under 5 Years 100.00% DeSChutH County Investments ............_... __...___ Portfoll.,lo\anagemel1l._._ Portfolio Details -Investments ..........~--------- Januaty 31, 2015 CUSIP __ ..__ .~_.__ .._ Purchase.. _Matillity .J>ays To .... _~I1!rlgs Coupon Par _. ___ Markfit__._ Boo!__~Cl1~ Broker Date Date Maturity Moodys S&P ~te'-riM 365 Value Value Value Date 4001154309 Colum~_Stl!leB_a_nkCD ___._ 41112013 3/30../:1.0..15 .._.....?!___ ~5Q__ 0..152 . ......!.00,000 __ 100,000~...!!lQ,,,-000'-'-___-I 273-150017-5 _~...I'I.'Ja"ey Ba"!.kc;Ll.___ ____.. 512'?'-2.013 5/20../20..15 108____ .().74!3.Jl:258...2.(j(),000 _..~.o.!2<lO__ . 200,000 UMp;)7200257Q UITI~ua Bank __6/7/2014 ..SI"7~()I~_. . ...126 .........0..400_.Q"~()s._._~Q,tl()()_~2.4Q,()()() 240,000 :-c:-:=--. General EIllCIlic.:~0.rf>O~Ej.N .C~S:r~~~_ll_71_2D_l~_ 61~3~Q~/2~Q~ .. .149 AA+ Al •.2,37L 0...865 . ___Generlll§lecI.!ic-CorlJOrate N CASTLE 1/10../2014 6/30/2Q1~._. 149 AA+ A1.....__~.:..:..:...'-•... :.:.:--'-_ .•_~_____,....lJITI~..II_~~k . ___7/9/2~ 7/912Q!.~ . ..I~._.__._._().~(J()_ 0...507 2,OOQ,Q_()(). 2,000,000 2,()()(),~()-=-- 91159HGX2;US Bancorp 2~§"T_~1:.__ 4/2120..14 m71~.1.5 ,.. 176 ~~1. .?i~_ 0...501_. ....!,!~Q!!l.()() 1,191,800 1,~.91,19~ ___-I 91159HGX2~_lJ S Bank...:2~'!l.f\lote CASTLE 312612014 __7127/?()~~ . __ I26..:.A+ . __ _.~L 2.450..__(l,500 •... 1,57~,tl.~___1.!.~~1,.!itl!,924 - - 45906KDG76 Intemational Bonds for Recons ~STL,.E ._!2119/2Q1i...._~11/2D~__. . _ 212.AP0_..A:IIIl... __.():!4~_. ..<l.i~!.._I,.22Q,QOO 1,216,218 1,216,818 - - 86459DAB2 ,Morgan Hill Rede".-.l'L ....__ . CASTLE 1011/2014 9/1/20..15 212 AA_. , . ...!120.. ~4~Q_ 75Q,000 __!52,153 . 752,921 ~-- 0(l<l159B~~kofNova§.£:OI~ ___,__CASTLE ._,4/3/2014 10../9/2,<:115 250 A+ __ .Aa.2__. 0...750 0..,621_ _54.Q,~__ 541,264 540,478 U~ __ Tennes~et!Valley A:.lIt~~rity __ CASTL~.,~4/2QI4 ...!1!!,2Ql~.J.7~3~___ .. __O:~:M-------"~47 418,QOOi!~,428 __~ 416,625 ..... General Eledric:_~o!P9rat.!..N CAl)TL£,.Z'24/2O,14. 11/912Ql~ .. _28..tAA+ Al?-.2~().5QQ •. 2,QQQ,()(J()._2,Q28,5OO t 2,0..26,902 - 7~g718DS5 __.!:.~er 8. G!imble CASTL£.......!P~2Q1~~/!5/2D15 287AA-AA3_180Jl~_ Q~~. .J.,Q()(),(J()Q 1,Q~,250~g,~. 532457AN8 .. _.E~LJ.I~ 8.~~_ . ~ .......2ASTLE ~412Q!!..1/11201.6 . 3~.,4.I>,-.~Ag.__ . 6.570.. Q,50Ql.4()8,QQo.. ... 1.t..4~6,8621,~85,887..; :...:_ ()~67QBG2 ___. .AeI'1lSl!i~el:!_at.l'l..away Inc... CASTLE 313/20..14 2111120..16. __ 375 .~._Aa2__ ...Jl:8 QQ . Q5()Q ..1,()QO,OOQ___1~3,550 1,'::.00::..:3",,064=-,~'____~ 17275RAC6 ._CiscoSyst.8I11!ln.9._._.~ CASTLE 2127/20..14 2/2212QI6.~_ 386 AA-. __~!..__5~.Q. 0...550.. .!-!'4,OOQ !,973,884, 1,971,503· ___ 0(l<l()6HCG?<l............Bank of N~York M,eilon C()rp~ ..~ASTLE _~~~?()...!!....~412QI6 . .t\!._~_. (j,.?QQ 0..,681 1,0..00,000 1,0..0..1,190 1,000,20..5 2/3/20..16 3133.234F6 .~_Federal.t:'~!Ile Loan Bank ~ CASTLE_61212014 4/1512Ql~.__ ..E.s_,4.I>,.!......~_ Q7!2_()~()Q '6SO,OOO-'~=1:l~(),468 651,340 Royal Bank of Canada CASTLE 11/19/20..14 4119120..16 443 AAAa3 2,875 0..,650.. 1,500,000 1,540..,530.. 1,540,348 Johnson 8. Johnson ·----·-------cASTLE 117120..14511512016:. :469 ~. ~Aa~=1j.50. '0.620.. . 1,529,000..1,563,341-1,558,883 -_"_.. --Federal Home Loan Mtg,.£orp .... DADAV 12110..120..14 512712016 . 4~AA+ Aaa 0..500 0...521 .2,0..00,000 2,000..,420.. 1,999,797 2127/20..15 Lewis 8. Clark Bank ·············-·-1218t20~8i2016 493 1.000-. 1.0..14 240..,000 ~240,000~,000 r VVeils Fargo Corporate Note -:-=.~:-VINISP=.21201£0..1.4 6115120..16 50..0.. A+ A2 3,676 0...750 '1;000.0001,0..39,630 I,Q39,727! Weils Fargo Corporate NotEl__ CASTLE lQI212Q146i1512016 --50..0.. A+ A2.:_~~,S76._:::::o:aro-· 1,0..00,000 1,0..39,630 1,038,142 . .....YY.eii.sF!i!'90 Corporat,e Note-CASTlE 12112120..14 sii5tio~n50Q -A--:;:---·A2 3,676 0..,860.. 1,000,000 1,0..39,630 1,0..38,310.. , Oregon School Boards A~~(JC CAsTCE-31712D14 6/3012(J16'515~ Aa2 -----0:000······· 0..,999 3,000,000 2,966,490 2,958,325 FederaINational.MtJj.}\ssn __~S}\l')TLE 10../1612014 7115120..16' ~----.-. 0...354 0..,365·'-1,693,000 1,679,168 1,684,189· ~~,--_.-;T::=en=ne;:::ss?,-ee:::;:-v~a!~/I,!1ihority CASTLE lQ/~ 7/15/2Q1if 530 ~~~__0490_ 0...50..72,000,000 1,983,620.. 1,985,567 ~:-----_.. RoyalEllink of gllnaaa___~_ CASTLE 1112612014 "772D/2016'--S35AAAa3~... 0...800 1,630,000 1,687,001 1,665,609 E~=::::----Berkshire Hathaway In~ Wells Fargo CO.!}lflrate Note DADAV 121912014 7i20i201S~~A+"A2"----I,fooo834-~1000000 1 006450 1006064 ........__ ~ireasury __ ~____~ MBS·· 6/19/2014 7/31/2016· 546 AA-Aaa ··_·--1:"500 0.548 1,000,000 1,017,420 1,014,127; M -~ __..f.ASTLE 1219/2014~01S--561 AA'--A!i2'. -2-:-200 ------O:S90-2,i:liJO,6OO~4i(460 ..... 2,046,112 - E?-::::=__-=Fed"",e"-,ra71:-:Ho",m!!e,-.=Loall~ MBS W/2Q14 81261201S--si2AA+ Aaa'·O.580-O:S29 2,000..,0..00 1,996,400 1,998,457· 2126/2015 E::-.:-=::::,:::::=-__ Federal Home Loan Mig Corp CASTI,i:: . ..J1i~gD14 8126120..16 572AA+ Aaa 0.570.. 'iJ:54O 3,000..,0..0..0.. 2,999,310 3,0..0..1,188 8126120..15 Federal National ~tg Assn PJ 315/20..14 911512Q16~592AA+-Aaa --0,778-0:8'12 672,000 666,375 663,398 Federal Farm Credit Bank CASTLE 5/231201'4' 9/26120..16 60..3 AA+ Aaa 0...690 0...686 3,,000,000 3,000..,060.. 3,000,212 - E=~~---'='Federal FamiCred~' CASTLE 1018/20..14 9/26/20..16 . 603 ,AA+-Aaa--~O:SOO--·-Q.690-2,000,000 2,000..,040.. 2,000,000· - Federal HomeLOan'Bank CASTLE7i1712014 , 9/28120..16 605' AA+ Aaa 1.125 --0..,728. 2,000,000 2,011,600.. 2,009,502 9/2812015~~~=;::----;;F:='ed'?er"-'al Home Loan Bank-,._. MBS 10../2812014 1oi2~" 635 M-:':-Aaa 0...700 0,S5~1 '750,000 750..,428750,451,10/28/2015 ~~:::-;:~__.. U,S. Treasury __ . ____:":='CAsTLE 12127120..13·10../31120..16 ... .. '638AA+~Aaa---1:000 0.72.'[" T,OOO,OOo 1,0..10..,470.. -1,004,7Q1:~ Federal Farm Credit Bank PJ 12110/2014 11/14/2016 ·-'852M;······ Aaa 0.600 ~ 'O~648 -~~ 2,000,000 2,001,320 ·········1,998,295 - 'BarikOt America -Corporate--CASTLE§/I312Q14 11114/2016 652 A A2 .. 1.125 _ I,Q50'~0;000 1,903,496 1,902,495 ____ ~ Federal Farm Credit Bank ,CASTLE 12/17/20..13 1217/2016 _j75~AA+ Aaa 0..,8750.722-2,100,0..00 2,114,049 2,106,130 - • ~;;:~~;;::--_"_'BankofNovaScotia ... 'CASTLE' 61912014-12113120..16 681 A+~1.'fOO--Q.910· 1,80..0..,0..00 1,807,2721,806,289 - -' _~........__·Fed;;ni(NSiioiial MlgAsSnPJ~=-'3/6/20..14' 12119/2Q16-68CAl\+~~~a:·'~~ 0...788-2,000,0002,0..00,560.. 2,000,460.., 2/19/?O15 __ -'-~Jl~of New York Mellon Corp CASTLE 4123120..14 111!!gtl!?:..__71.§.:~,!:. _ ~~~'L~ClQ.... 1.067--2,000,000 2,0..57,080.. 2,051,3721 1211812016 =~_-,-U,S. TreasuryC;/I,l')TLE 111612Q1.LJ.~!!2()17 ~~.....!...._.A,all. 0.875 0:844-2:000,000.. 2,0..15,000' . 2,001,232 i -~-_~. F--'-==-'='-=---Private Expt Fdg PJ 11120120..14_ 2I151g()17 _~~___._ . 1.375 0..,799 3,000",0().0... 3,0..42,750 3,0..34,849 ! I-------'--'--=--'-_=--'-.Bank of Nova Scotia CASTLE 511/2014 3/17/2()17'.....__ ..!~~a2 0...80..0.. 0..,90..6 1,0..00,000 1,0..0..8,490 997,782· 3/17/20..16 F~eral Home Loan Mig Corp PJ 12110..120..14 3~()~.JI3!..~-..A:.aa 1.000 . .!:()ClQt ...2,(J,()Q,000 2,002,480.. 2,000,000, 3/30/20..15 MBS 121812014 417120..17 796 AA+ Aaa 1.000 1,001 2,000,000.. 2,001,720.. 2,000,000 417/20..15 WF 1117120144/30../2017 ''''619 AAA .Aaa 0...875 0..,956' '2,000,000.. 2,014,68Qi;996,691 -CASTLE -T"6/24/20..14 51512Q178'24AA+....~Ai1-~IQ57 ~2.000;OOQ 2,0..15, leO 1,999,684 PJ 10../7/20..14 511612Qli"8'35TAA+'-Aaa 2:000 1127 3,0..00,000.. 3;057,630 3,0..53,897 611612016 -_ CASTi]:'---m972614'5116/2Q17 835 AA-AA3 1.125 1.150 2,12,?,000_.2,135,774 2,123,781 3136FPYB7 VINISP 217120..14 5/23/2017 842 AA+ Aaa 2.0..50.. 0..,8851,460..,0..00 1,500..,6461,498,644, 31359MEL3 Federal National Mig Assn " ..19f'STLE 12123120..13 611/2017 851 AA+ Aaa 1.0..61 1.115 1,0..00,000 984,930.. 974,910..: 313,59Mi::L3L.FederaINationaIMlg.A,ssn 'CASTLE 1/24/2014 611120..17 851 AA-'Aaa~. 1.081 1,136-~050,000 1,0..34,177 1,0=-,23~,1-,,64=--___-I 31771CS97 FICO Strip CASTLE, 121912014-....S/SI2Q17· '''856'-Aaa 1.0..19 1.0..651,028,0..00 1,()()8,Q77, 1,003,090 29270CYZ2-'-Sonneville Power Adminislratio CASTLE ~ 4124/2014 7/1/2Qli· .'881M--=--Aal 1]97 ....... 1,171 670..,000 671,903 670..,422 ~~~[t~=~'SOU1hemCAPu~jcPOwer Autho CAsn.ESii712.Q14.:_71112Q1.7. . ··.B L.AA 11.,Q18Q ',QDQOOD',OOooQQ-~ 97,'9990 ", 165 ~~-.8 · ····.:..-=-==1T4S··· l······!...1 9 1-'0..' -~:..:.:..9998',954 2828TM2 ;U.S. Treasury _____._ CAST~E: _,.jl{1012014,~@~~Q1L 942 .AAA .Aaa 0625--6 _ 998 98 13'3a3JB8 ,Federal Home Loan Bank ,vINISP 12126120..13 9/27/20..17 969AA+-~,~aa 1,000..1:250 1.0..00,000.. 1,004,290 993,53;:;:2::-1'---==:=. 3136GOC74' 'FedElI!INaijoOafMtgp'S'~~~: ":::=YI~isp= 2/3/2OEIgii1fi1'7::::-~.--::'969 AA·L ,Aaa 1.000--6.9i3~~050,OOQ 1,052,8251,O51,558! 9/2712015 313OA1ZK7 Federal Home Loan Bank MBS 5128/20..14 11128120..17 10..31 AA+ Aaa 0..,750-0.750:1,000..,0..00" 1,0..00,250 "1.000,000 -= 3tnlKAD90 FICO Strip ..... -DADAV 1211Q/2QI4__.11130/2()rt-::::':-1.Q~~.--· HAaa -~1,2Q5-'i,267 2,000,0..00.. 1,94"'8,820""·1,930,829 - 88059FAZ4 Tennessee Valley Authority. CASTLE 11/?!/2QI41_21.15/2Q1I.___ .J.Q48.AA+ . '--~H"'I-:288----1,059,000 1,0..27,114 I,O~--"-- 3136G1AU3-Federal National Mtg/l,!;sll __ VINISP_I212312QI3_~/3.()/2_Q~~ __.1094 J'!'.+=-=O,700":::1.:.4~(j"~]':QOO,000-995,0..20-990,247· 4130/2015 3135GOVU4 Federal Nati()lIal Mig Assn VINISP 1124120..14 4/3@11l_Jl§.LAA+ Aaa 1,125 1,540.. 1,0..00,000 1,0..0..1,040.. 987,286 41312015 313QA25R3 ,Federal Home Loan Bank MBS 6119120..14 6119/20..18 1234 AA+ Aaa'· 1.000 -102S--'2,QOO,000-ul02;OI'lO 1,998,308, 3119/2015 313SG1SBQ federal Nati()llal Mig Assn .YI.NISP_ 1/21/20..14 12/27/2()1~8~~i42~!AA+_.Aaa __():!!iO 1820.. 1,0..00,000..-~l,OOD,96Q 976,8683127/20..15 ........•-~~--~ :Loca'Govt~nvestment Pool __........_________~_ .....q.,SOO _O~~~_ 4~!~~~~..,. 45,601,650 45,601,650 ..H'" .~._Jl,5OO 0...500 5,652,149 5,652,149 5,652,149 154,607,799 155,289532· 155,0..32163' Memorandum Date: February 13, 2015 To: Board of County Commissioners Tom Anderson, County Administrator From: Wayne Lowry, Finance Director RE: Monthly Financial Reports Attached please find January 2015 financial reports for the following funds: General (001), Community Justice -Juvenile (230), Sheriff's (255, 701, 702). Public Health (259), Behavioral Health (275), Community Development (295), Road (325). Community Justice -Adult (355), Early Learning Hub (370), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), Fair & Expo Center (618), and Justice Court (123). 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 Revenues Property Taxes -Current Property Taxes -Prior Other General Revenues Assessor County Clerk BOPTA District Attorney Tax Office Veterans Property Management Grant Projects Total Revenues Expenditures Assessor County Clerk BOPTA District Attorney Tax Office Veterans Property Management Grant Projects Non-Departmental Total Expenditures Transfers Out Total Exp & Transfers Change in Fund Balance Beginning Fund Balance Ending Fund Balance July 1, 2014 through January 31, 2015 FY 2014 (58% of Fiscal Year) I %of Actual Actual Budget 21,906,239 21,246,822 93% 704,120 442,142 77% 2,116,386 1,671,522 74% 875,381 655,955 75% 1,276,019 835,453 71% 16,097 10,934 68% 226,973 126,603 69% 236,278 174,368 78% 80,787 44,084 43% 91,900 14,000 56% 2,000 -nla 27,532,179 25,221,883 90% 3,559,750 2,139,166 56% 1,293,531 825,907 54% 59,895 35,726 50% 5,382,874 3,078,344 53% 796,232 497,005 57% 292,672 181,385 51% 248,054 151,672 59% 130,054 -nla 1,432,177 578,040 51% 13,195,239 7,487,246 54% 16,327,584 8,254,250 55% 29,522,823 15,741,496 54% (1,990,644) 9,480,387 10,371,843 8,381,199 109% $ 8,381,199 $ 17,861,586 a) b) c) c) d) c) Budget 22,736,401 576,500 2,247,299 876,137 1,181,190 16,117 182,612 222,199 101,986 25,000 28,165,441 29,059,041 893,600 3,793,770 3,793,770 1,536,210 1,536,210 70,777 70,777 5,835,377 5,661,127 174,250 877,907 877,907 354,989 354,989 258,569 258,569 1,139,696 1,139,696 13,867,295 13,693,045 174,250 15,116,394 15,116,394 28,983,689 (818,248) 7,692,433 $ 6,874,185 FY2015 I Projection 23,236,401 486,500 2,317,299 876,137 1,481,190 16,117 296,212 222,199 101,986 25,000 I $ Variance 500,000 (90,000) 70,000 300,000 113,600 28,809,439 174,250 249,602 1,067,850 8,381,199 688,766 $ 8,630,801 $1,756,616 a) Current year taxes received beginning in October b) PIL T received in July -$500,000 c) YTD Actual includes two quarters of A & T Grant d) Federal and State grant and Charges for Services in excess of amounts included in the budget Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data FY 2014 Actual Revenues OVA Basic &Diversion 322,574 State Grant Inmate/Prisoner Housing 47,550 Jail Funding HB #2712 36,311 Food Subsidy 23,988 Interfund Grant -Gen Fund 20,000 Interest on Investments 7,611 Leases 5,200 SB #1 065-Court Assess. 17,335 Contract Payments 7,415 Discovery Fee 1,870 Case Supervision Fee Federal Grants 9,434 CFC Interfund Grant 125,429 Miscellaneous 909 Total Revenues 625,626 Expenditures Personnel Services 4,887,572 Materials and Services 1,035,701 Capital Outlay Transfers Out 3,660 Total Expenditures 5,926,933 Revenues less Expenditures (5,301,306) Transfers In-General Fund 5,368,346 Change in Fund Balance 67,040 Beginning Fund Balance 1,177,566 Ending Fund Balance $ 1,244,605 July 1,2014 through January 31, 2015 (58% of Fiscal Year) I %of Actual Budget 92,410 26% a) 36,653 40% b) 54,900 137% c) 27,170 74% a) 7,993 33% d) 5,000 25% a) 5,328 76% e) 5,400 nfa f) 13,636 227% g) 5,232 116% h) -0% i) 3,762 nfa j) 1,205 nla k) -nla 670 65% FY 2015 Budget I Projection I $ Variance 359,149 359,149 91,379 121,002 29,623 40,000 75,000 35,000 36,568 36,568 24,000 14,400 (9,600) 20,000 20,000 7,000 8,700 1,700 7,500 7,500 6,000 24,000 18,000 4,500 6,240 1,740 3,800 (3,800) 6,000 6,000 1,205 1,205 1,025 1,025 $ a) Payments received quarterly. Quarter 2 has been billed b) Additional grant awards. Payments received quarterly. Quarter 2 has been billed c) Increase in projection due to out-of-County detention revenue. $9,000 expected for January billings d) Decrease in projection due to detention population numbers e) Projection based on annualizing year to date f) Sub-lease of space to Rimrock not included in FY 2015 budget g) State payment will exceed the amount estimated for FY 2015 budget h) Increased projection due to more than anticipated revenue for community service projects i) Agreement with District Attorney's Office no longer in effect j) Policy, requiring supervision fees, not anticipated at the time the FY 2015 budget was prepared. Projection based on annualizing year to date 259,358 44% 593,421 680,789 87,368 2,924,532 57% e) 5,146,491 5,092,377 54,114 579,530 57% e) 1,021,392 960,000 61,392 -0% 1,100 1,100 1,830 50% 3,660 3,660 3,505,892 57% 6,172,643 6,056,037 116,606 (3,246,534) (5,579,222) (5,375,248) 203,974 3,131,534 58% 5,368,346 5,368,346 (115,000) (210,876) (6,902) 203,974 1,244,605 100% 1,250,000 1,244,605 (5, 3951 1.129.605 $1,039,124 $1,237,704 $ 198,580 k) Increased projection due to receipt of FY 2014 funds in FY 2015 Page 2 SHERIFF -Consolidated Statement of Financial Operating Data FY 2014 Actual Revenues (Funds 701 & 702) Law Enf Dist Countywide 20,624,082 Law Enf Dist Rural 12,526,331 Total Revenues 33,150,413 Expenditures (Fund 255) Sheriffs Services 2,308,182 Civil/Special Units 1,132,029 Automotive/Communications 1,701,586 Investigations/Evidence 1,418,744 Patrol 8,247,222 Records 761,260 Adult Jail 14,277,113 Court Security 294,563 Emergency Services 194,888 Special Services 1,352,528 Training 506,938 Other Law Enforcement Svcs 801,895 Non-Departmental 81,701 Total Expenditures 33,078,650 Revenues less Expenditures 71,763 DC Comm Syst Reserve 200,000 Transfer to Reserve Funds 200,000 Change in Fund Balance (328,237) Beginning Fund Balance 9,553.793 Ending Fund Balance $ 9,225,556 July 1, 2014 through January 31,2015 (58% of Fiscal Year) Actual 1% of Budget 18,777,446 10,732,432 29,509,877 1,435,578 734,713 987,829 918,191 4,965,187 425,999 8,865,285 178,235 305,016 865.567 286,262 458,221 42,469 92% 84% 89% 58% a} 62% 52% 56% b) 57% c) 53% c) 58% d) 59% 171% e) 52% 52% 57% c) 58% Budget 20,365,842 12,751.766 33,117,608 2,467.673 1,192.980 1.886,365 1.627.803 8.705.700 798.805 15,214,157 302,867 177,852 1,655,424 551,318 806,044 72,813 FY 2015 I Projection I $ Variance 21,139,189 773,347 12,895,796 144,030 34,034,985 917,377 2.588,498 (120,825) 1.172.880 20,100 1.886,265 100 1.674.203 (46,400) 8,550,700 155,000 769,705 29,100 15,280,157 (66,000) 302,767 100 385,315 (207,463) 1,655,424 551,218 100 800,207 5.837 72,813 20,468,552 58% 35,459,801 35,690,152 (230,351) 9,041,326 (2,342,193) (1,655,167) 687,026 200,000 200.000 100% 100% 200,000 200.000 200,000 200.000 8,641,326 (2.742.193) (2,055.167) 687.026 9,225.556 120% 7,658.937 9,225,556 1.566.619 $ 17,866,881 $4,916,744 $7,170,389 $2,253,645 a) Unplanned repair of Administration Building roof for $120,825 expected to be completed by year end b) Position filled at higher step and investigative funds ("buy money") for Street Crimes Unit will be more than planned c) Due to unfilled positions, personnel expenditures will be less than budgeted d) Savings from unfilled positions will be offset by higher overtime and unplanned jail maintenance expenses e) Homeland Security Grant for Communications equipment was awarded in September. Expenditures offset by grant revenue in Fund 701 Page 3-A SHERIFF· Fund 255 Statement of Financial Operating Data FY2014 Actual Revenues (Fund 255) Law Enf Dist Countywide 20,817,324 Law Enf Dist Rural 12,278,716 Total Revenues 33,096,040 Expenditures (Fund 255) Sheriff's Services 2,308,182 Civil/Special Units 1,132,029 Automotive/Com munications 1,701,586 Investigations/Evidence 1,418,744 Patrol 8,247,222 Records 761,260 Adult Jail 14,277,113 Court Security 294,563 Emergency Services 194,888 Special Services 1,352,528 Training 506,938 Other Law Enforcement Svcs 801,895 Non-Departmental 81,701 Total Expenditures 33,078,650 Revenues less Expenditures $ 17,390 July 1,2014 through January 31, 2015 (58% of Fiscal Year) Actual I Budget FY2015 Budget I Projection L $ Variance 13,092,124 51% 25,428,019 22,476,660 (2,951,359) 7,376,428 49% 14,948,526 13,213,492 (1,735,034) 20,468,552 51% 40,376,545 35,690,152 (4,686,393) 1,435,578 58% a) 2,467,673 2,588,498 (120,825) 734,713 62% 1,192,980 1,172,880 20,100 987,829 52% 1,886,365 1,886,265 100 918,191 56% b) 1,627,803 1,674,203 (46,400) 4,965,187 57% c) 8,705,700 8,550,700 155,000 425,999 53% c) 798,805 769,705 29,100 8,865,285 58% d) 15,214,157 15,280,157 (66,000) 178,235 59% 302,867 302,767 100 305,016 171% e) 177,852 385,315 (207,463) 865,567 52% 1,655,424 1,655,424 286,262 52% 551,318 551,218 100 458,221 57% c) 806,044 800,207 5,837 42,469 58% 72,813 72,813 20,468,552 58% 35,459,801 35,690,152 (230,351) . $4,916,744 $ $ (4,916,744~ a) Unplanned repair of Administration Building roof for $120,825 expected to be completed by year end b) Position filled at higher step and investigative funds ("buy money") for Street Crimes Unit will be more than planned c) Due to unfilled pOSitions, personnel expenditures will be less than budgeted d) Savings from unfilled positions will be offset by higher overtime and unplanned jail maintenance expenses e) Homeland Security Grant for Communications equipment was awarded in September. Expenditures offset by grant revenue in Fund 701 Page 3-B SHERIFF -Expenditure Detail Statement of Financial Operating Data July 1, 2014 through January 31, 2015 (58% of Fiscal Year) FY2014 Actual Actual I % of Budget Expenditures Sheriff's Services Personnel 1,342,795 FY 2015 Budget I Projection I $ Variance 836,543 58% 1,431,828 1,431,828 Materials & Services 965,387 599,035 59% 1,020,745 1,141,570 (120,825) Capital OuUay -0% 15,100 15,100 Total Sheriffs Services 2,308,182 1,435,578 58% 2,467,673 2,588,498 (120,825) Civil/Special Units Personnel 1,027,640 636,766 59% 1,073,870 1,053,870 20,000 Materials & Services 104,389 97,947 82% 119,010 119,010 Capital Outlay -0% 100 100 Total Civil/Special Units 1,132,029 734,713 62% 1,192,980 1,172,880 20,100 Automotive/Communications Personnel 400,169 231,978 58% 399,334 399,334 Materials & Services 1,265,667 755,851 51% 1,486,931 1,486,931 Capital Outlay 35,750 -0% 100 100 Total Automotive/Communications 1,701,586 987,829 52% 1,886,365 1,886,265 100 I nvestigationsiEvidence Personnel 1,277,983 825,648 56% 1,470,106 1,494,106 (24,000) Materials & Services 140,761 92,543 59% 157,597 180,097 (22,500) Capital Outlay -0% 100 100 TotallnvestigationsiEvidence 1,418,744 918,191 56% 1,627,803 1,674,203 (46,400) Patrol Personnel 7,450,178 4,377,205 57% 7,728,332 7,608,332 120,000 Materials & Services 547,770 329,512 52% 636,868 601,868 35,000 Capital OuUay 249,274 258,470 76% 340,500 340,500 Total Patrol 8,247,222 4,965,187 57% 8,705,700 8,550,700 155,000 Records Personnel 659,297 404,102 58% 692,244 667,244 25,000 Materials & Services 101,963 21,897 21% 106,461 102,461 4,000 Capital OuUay 0% 100 100 Total Records 761,260 425,999 53% 798,805 769,705 29,100 Adult Jail Personnel 11,899,534 7,312,804 58% 12,675,178 12,675,178 Materials & Services 2,069,651 1,255,397 62% 2,039,314 2,078,314 (39,000) Capital OuUay 63,176 33,434 160°,(, 20,900 47,900 (27,000) Transfer Out -Jail (D/S & Cap Proj) 244,752 263,649 55% 478,765 478,765 Total Adult Jail 14,277,113 8,865,285 58% 15,214,157 15,280,157 (66,000) Court Security Personnel 284,173 171,770 59% 292,715 292,715 Materials &Services 10,390 6,465 64% 10,052 10,052 Capital Outlay -0% 100 100 Total Court Security 294,563 178,235 59% 302,867 302,767 100 Emergency Services Personnel 169,170 83,826 57% 147,942 147,942 Materials & Services 25,718 221,190 742% 29,810 237,373 (207,563) Capital Outlay -0% 100 100 Total Emergency Services 194,888 305,016 171% 177,852 385,315 (207,463) Special Services Personnel 1,152,258 718,709 56% 1,273,721 1,273,721 Materials &Services 183,769 82,111 37% 223,703 223,703 Capital Outlay 16,500 64,747 41% 158,000 158,000 Total Special Services 1,352,528 865,567 52% 1,655,424 1,655,424 Training Personnel 385,634 228,599 55% 416,955 416,955 Materials & Services 121,303 57,663 43% 134,263 134,263 Capital Outlay -0% 100 100 Total Training 506,938 286,262 52% 551,318 551,218 100 Other Law Enforcement Services Personnel 731,122 388,582 54% 717,594 706,594 11,000 Materials &Services 70,773 57,335 71% 81,310 81,310 Capital Outlay 12,303 172% 7,140 12,303 (5,163) Total Other Law Enforcement Svcs 801,895 458,221 57% 806,044 800,207 5,837 Non-Departmental Materials &Services 81,701 42,469 58% 72,813 72,813 Total Non-Departmental 81,701 42,469 58% 72,813 72,813 Total Expenditures $ 33,078,650 $20,468,552 58% $35,459,801 $35,690,152 $ ,230,351&pay 4 LED #1 • Countywide Statement of Financial Operating Data Revenues Tax Revenues -Current Tax Revenues -Prior SB 1145 Sheriff Fees Concealed Handgun License Jail Funding HB 3194 Jail Funding HB 2712 State Grant Prisoner Housing Inmate Telephone Fee Federal Grants Work Center Work Crews Contracts with Des County Inmate Commissary Fees Interest Donations-"Shop with a Cop" Miscellaneous Total Operating Revenues EXPENDITURES & TRANSFE DC Sheriffs Office DC Comm Systems Reserve Transfer to Reserve Fund Total Expenditures Change in Fund Balance Beginning Fund Balance Ending Fund Balance July 1, 2014 through January 31, 2015 (58% of Fiscal FY 2014 Year) Actual Actual 1% of Budget 16,698,208 16,202,777 94% a) 532,040 318,552 88% 1,630,823 1,221,762 75% b) 365,577 214,219 102% c) -93,196 62% 107,806 107,805 100% 36,311 27,170 59% 85,781 226,813 266% d) 329,918 110,534 138% e) 83,297 20,673 26% f) 20,897 10,072 50% g) 69,723 24,346 49% 475,815 49,138 81% h) 32,480 18,916 76% 50,563 30,524 76% 38,361 66,268 102% 66,441 34,681 54% 20,624,082 18,777,446 920/0 RS 20,817,324 13,092,124 52% 80,000 80,000 100% 100,000 100,000 100% 20,997,283 13,272,124 52% (373,200) 5,505,322 6,507,110 6,133,909 117% $ 6,133,909 $ 11,639,231 FY 2015 Budget L Projection I $ Variance 17,292,244 17,642,244 350,000 360,700 360,700 1,628,947 1,628,947 210,000 315,000 105,000 150,000 150,000 107,806 107,806 46,143 46,143 85,370 292,933 207,563 80,000 220,000 140,000 80,000 35,000 (45,000) 20,000 10,072 (9,928) 50,000 50,000 60,632 85,286 24,654 25,000 25,000 40,000 40,000 65,000 66,058 1,058 64,000 64,000 20,365,842 21,139,189 773,347 25,207,970 80,000 100,000 22,476,660 80,000 100,000 2,731,310 25,387,970 22,656,660 2,731,310 (5,022,128) (1,517,471) 3,504,657 5,242,177 6,133,909 891,732 $ 220,049 $ 4,616,439 $4,396,390 a) Current year taxes received beginning in October b) 1 st Qtr & 2nd quarter payments received in October c) Fees from distressed property sales and civil papers projected to exceed budget due to continued higher volume d) Homeland Security Grant for communications equipment awarded in September e) S8 395 inmate reimbursement revenue is projected to exceed budget due to number of repeat DUll inmates f) Inmate telephone fees will be less due to changes in commission fees on interstate calls g) Inmate State Criminal Alien Assistance Program (SCAAP) grant revenue received in Qtr 1 and was less than planned h) Transfer from Fund 240 for Court Security will be higher than planned Page 5 LED #2 -Rural 702 Statement of Financial Operating Data FY 2014 Actual Revenues Tax Revenues -Current 7,988,657 Tax Revenues -Prior 262,227 Des Cty Transient Room Tax 2,838,797 City of Sisters 486,678 Marine Board License Fee 155,221 State Grant 124,246 Court Fines & Fees 135,023 Contracts with Des County 119,984 US Forest Service 101,375 School Districts 65,088 Federal Grants 84,285 Bureau of Reclamation 24,023 Interest 21,715 SB #1065 Court Assessment 17,435 Federal Grants-BlM 16,213 Donations &Grants -Private 12,030 Miscellaneous 73,333 Total Revenues 12,526,331 EXPENDITURES & TRANSFERS DC Sheriffs Office 12,278,716 DC Comm Systems Reserve 120,000 Transfer to Reserve Fund 100,000 Total Expenditures 12,498,716 Change in Fund Balance 27,614 Beginning Fund Balance 3,046,683 Ending Fund Balance $ 3,074,297 July 1, 2014 through January 31,2015 (58% of Fiscal Year) 1% of BudgetActual 7,724,157 93% a) 155,101 92% 2,184,504 75% 305,088 58% 50,319 30% 33,021 25% b) 72,733 56% 71,147 58% 22,625 30% 22,799 41% c) 15,334 37% d) -0% c) 15,567 74% 13,636 91% -0% e) 17,030 nfa 29,370 43% Budget 8,272,852 169,000 2,920,654 523,010 169,000 130,600 130,000 121,650 76,500 55,000 42,000 27,000 21,000 15,000 10,000 68,500 FY 2015 I Projection I $ Variance 8,422,852 150,000 169,000 2,920,654 523,010 169,000 108,600 (22,000) 130,000 121,650 76,500 55,000 42,000 27,000 21,000 24,000 9,000 (10,000) 17,030 17,030 68,500 $ a) Current year taxes received beginning in October b) DUll overtime grant reimbursements will be less than planned c) Quarterly billing in arrears, service levels in future quarters will be higher d) Justice Assistance Grant not yet received e) BlM notified DCSO that contract would not be renewed after FY 2015 Budget was adopted 10,732,432 84% 12,751,766 12,895,796 144,030 7,376,428 120,000 100,000 49% 100% 100% 14,948,526 120,000 100,000 13,213,492 120,000 100,000 1,735,034 7,596,428 50% 15,168,526 13,433,492 1,735,034 3,136,004 (2,416,760) (537,696) 1,879,064 3,074,297 127% 2,416,760 3,074,297 657,537 6,210,301 $ $ 2,536,601 $2,536,601 Page 6 PUBLIC HEALTH Statement of Financial Operating Data Revenues State Grant Environmental Health-Lic Fac OMAP Family Planning Exp Proj Interfund Grants &Contract Grants (Intergvt. Pvt. & Local) Patient Insurance Fees State Miscellaneous Federal Payments Vital Records-Death Health DepUPatient Fees Contract Payments Vital Records-Birth Child Dev & Rehab Center Interest on Investments Grants &Donations Miscellaneous Total Revenues Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Total Expenditures Revenues less Expenditures Transfers In-General Fund Transfers In-PH Res Fund Transfers In-Gen. Fund Other Total Transfers In Change in Fund Balance Beginning Fund Balance Ending Fund Balance FY 2014 July 1. 2014 through January 31.2015 (58% of Fiscal Year) Actual Actual I %of Budget 2.878,140 1.799.854 56% 767.248 679,527 87% 812,441 564,940 86% 400,900 121,455 22% 95,011 476,645 386% 139,171 6,496 2% 232,968 67,293 34% 229,520 32.265 20% 161.576 84,468 56% 100.535 73,375 73% 80,653 27,302 34% 92,637 7,538 11% 36.655 20.995 51% 52,433 6.764 17% 9,077 7,774 130% 38,192 49,987 3332% 10,135 6,137,293 23,269 831% 4,049,947 63% 6,457,193 3,828,220 56% 2,043,710 1,164,796 53% -20,000 99% 157,320 8,658,223 (2,520,930) 82,320 50% 5,095,337 56% (1,045,389) 2.701,475 1,575,861 58% 33,000 -nla 65,100 2,799,575 278,645 32,550 50% 1,608,411 58% 563,022 $ 1,273,934 1,552,578 1,552,578 99% $ 2,115,600 FY 2015 Budget I Projection I$ Variance a) b) a) a)c) a) a) c) a) d) 3,202,798 3,330,846 128,048 779,450 779,450 655,250 1,015,358 360,108 550,000 230,000 (320,000) 123,618 476,976 353,358 269,678 97,696 (171,982) 196,400 152,462 (43,938) 162,352 150,336 (12,016) 150,335 171,491 21,156 100,000 100,000 80,216 49,150 (31,066) 69,291 8,000 (61,291) 41,000 41,000 39,609 30,759 (8,850) 6,000 13,000 7,000 1,500 50,000 48,500 2,800 25,000 22,200 6,430,297 6,721,524 291,227 6,794,032 2,189,982 20,200 164,640 6,650,491 2,584,740 20,000 164,640 143,541 (394,758) 200 9,168,854 9,419,871 (251,017) (2,738,557) (2,698,347) 40,210 2,701,475 2,701,475 65,100 65,100 2,766,575 2,766,575 28,018 1,570,821 68,228 1,552,578 40,210 {18,243~ $ 1,598,839 $ 1,620,806 $ 21,967 a) Grants and contracts projected at amended contract amounts b) Majority of fees are due annually and collected in December &January c} Received quarterly. in arrears d) M &S increased to reflect amended grants and contracts. Appropriation will be increased as necessary Page 7 Revenues Administrative Fee State Grants OHP Capitation Federal Grants Patient Fees Title 19 Liquor Revenue Divorce Filing Fees Interfund Contract-Gen Fund School Districts Federal Grant (ARRA) Interest on Investments Rentals Marriage Licenses Local Grants Claims Reimbursement State Miscellaneous Justice Reinvestment HB3194 Miscellaneous Total Revenues Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Total Expenditures Revenues less Expenditures Transfers In-General Fund Transfers In-Acute Care Svcs Total Transfers In Change in Fund Balance Beginning Fund Balance Ending Fund Balance BEHAVIORAL HEALTH Statement of Financial Operating Data JUly 1, 2U14 through January 31, 2015 (58% FY2014 of Fiscal Year) I %of Actual Actual Budget 8,260,932 6,529,617 58% 7,801,239 4,811,536 50% 469,069 116,401 30% 184,980 71,664 35% 219,846 114,825 57% 246,484 163,021 90% 142,665 73,637 49% 129,788 74,945 53% 127,000 36,412 29% 6,952 -0% 63,750 -0% 21,190 19,199 98% 16,000 1,750 9% 6,540 4,160 64% 52,891 734,985 nla 12,918 -n/a 31,820 15,900 n/a 120,000 -nJa 28,157 7,820 147% 17,942,221 12,775,872 60% 12,415,866 8,208,981 53% 6,738,744 3,535,641 40% --0% 204,900 102,450 50% 19,359,510 11,847,072 48% (1,417,289) 928,800 1,377,302 803,425 58% 293,593 109,430 58% 1,670,895 912,855 58% 253,606 1,841,654 2,671,137 2,924,742 88% $2,924,742 $4,766,397 FY2015 Budget I Projection I $ Variance a) b) c) 11,210,767 9,589,680 390,000 204,849 201,610 180,300 151,000 140,600 127,000 65,000 34,000 19,500 18,800 6,500 11,210,767 7,706,176 436,046 201,879 175,472 186,279 151,000 140,600 127,000 31,200 18,800 7,800 748,081 15,900 (1,883,504) 46,046 (2,970) (26,138) 5,979 (65,000) (34,000) 11,700 1,300 748,081 15,900 5,318 8,000 2,682 22,344,924 21,165,000 (1,179,924) 15,467,644 8,938,569 100 204,900 14,150,000 7,394,499 216,902 1,317,644 1,544,070 100 {12,002l 24,611,213 21,761,401 2,849,812 (2,266,289) (596,401) 1,669,888 1,377,302 187,594 1,377,302 187,594 1,564,896 1,564,896 (701,393) 968,495 1,669,888 3,313,248 2,924,742 {388,506~ $2,611,855 $3,893,237 $ 1,281,382 a) Oregon Health Authority grant projected at amended contract amount b) Contract not executed c) Grant payments received in FY 2014 will be reported as FY 2015 revenue Page 8 COMMUNITY DEVELOPMENT Statement of Financial Operating Data FY2014 Actual Revenues Admin-Operations 40,102 Admin-GIS 2,944 Admin-Code Enforcement 261,188 Building Safety 1,748,911 Electrical 408,194 Contract Services 264,039 Env Health-On Site Prog 448,367 Planning-Current 917,674 Planning-Long Range 440,222 Total Revenues 4,531,641 Expenditures Admin-Operations 1,590,779 Admin-GIS 123,751 Admin-Code Enforcement 275,521 Building Safety 688,035 Electrical 217,271 Contract Services 220,779 Env Health-On Site Pgm 181,831 Planning-Current 666,180 Planning-Long Range 425,323 Transfers Out (DIS Fund) 179,035 Total Expenditures 4,568,505 Revenues less Expenditures (36,864) Transfers In/Out In: General Fund -LlR Planning 495,360 Out: A & T Reserve Out: COO Reserve Funds - Net Transfers In/Out 495,360 Change in Fund Balance 458,496 Beginning Fund Balance 1,578,705 Ending Fund Balance $2,037,201 July 1, 2014 through January 31 , 2015 (58% of Fiscal Year) Actual I %of Budget Budget FY2015 I Projection I $ Variance 29,142 57% a) 51,225 42,900 (8,325) 655 26% 2,500 2,500 169,667 62% 273,000 308,000 35,000 1,146,767 71% 1,616,713 1,889,364 272,651 244,943 59% 418,506 415,660 (2,846) 174,027 82% 211,500 257,500 46,000 242,031 55% 437,358 430,300 (7,058) 647,470 72% 902,876 1,100,050 197,174 310,273 55% 560,658 621,736 61,078 2,964,977 66% 4,474,336 5,068,010 593,674 950,248 63% 1,500,181 1,500,181 71,298 55% 129,011 129,011 166,529 56% 297,852 297,852 450,346 55% b) 822,664 831,759 (9,095) 135,954 58% 234,152 238,883 (4,731) 161,754 57% 281,699 273,435 8,264 121,104 44% c) 274,228 250,879 23,349 428,774 61% d) 706,730 797,081 (90,351) 255,261 40% e) 646,018 673,131 (27,113) 170,698 98% 173,673 170,698 2,975 2,911,966 57% 5,066,208 5,162,910 (96,702) 53,011 (591,872) (94,900) 690,376 83,385 (90,360) - (6,975) 46,036 2,037,201 $2,083,237 50% 100% 0% 128% 166,770 (90,360) {687,470! {611,060) (1,202,932) 1,589,113 $ 386,181 166,770 (90,360) {687,470} (611,060} (705,960) 2,037,201 $1,331,241 $ 496,972 448,088 945,060 a) Reduction is due to vacant tenant space (projected at $20,000; no current tenant) b) $22,000 for Building Division portion of Fee Study &Financial Plan and $7,500 for vehicle printers c) $5,000 for Environmental Health portion of Fee Study &Financial Plan d) Payout for retiree, fee study, and filling vacant associate planner position e) Fee study Note: Materials &Services appropriations for items b through e will be increased as necessary. Page 9 ROAD Statement of Financial Operating Data July 1, 2014 through January 31, 2015 (58% of Fiscal Year) FY2014 I %ot Actual Actual Budget FY2015 Budget I Projection I $ Variance Revenues Motor Vehicle Revenue 11,300,058 Forest Receipts 1,259,367 Federal -PIL T Payment 1,064,365 Other Inter-fund Services 850,395 Cities-Bend/Redmond/Sisters 1,097,444 State Miscellaneous 595,804 Sale of Equip & Material 275,086 Assessment Payments (P&I) 15,058 Mineral Lease Royalties 206,097 Interest on Investments 49,562 Miscellaneous 117,069 Total Revenues 16,830,304 Expenditures Personnel Services 5,313,126 Materials and Services 8,051,744 Debt Service - Capital Outlay 121,455 Transfers Out 450,000 Total Expenditures 13,936,325 Revenues less Expenditures 2,893,978 Trans In -Solid Waste 282,148 Trans In -Transp SDC - Trans In-Road Imp Res - Total Transfers In 282,148 Change in Fund Balance 3,176,126 Beginning Fund Balance 6,846,576 Ending Fund Balance $ 10,022,703 6,647,774 59% a) 11,220,000 11,220,000 130 0% b) 1,140,950 250,000 (890,950) 1,250,809 123% c) 1,020,000 1,250,809 230,809 146,480 15% d) 971,700 1,002,478 30,778 83,423 10% e) 804,200 894,711 90,511 602,237 100% 602,629 602,629 202,318 75% 271,000 282,199 11,199 100,607 45% 225,840 210,000 (15,840) 34,666 25% 140,000 206,097 66,097 40,382 126% 32,000 55,000 23,000 29,409 115% 25,500 46,177 20,677 9,138,236 56% 16,453,819 16,020,100 (433,719) 3,253,477 3,938,953 106,554 1,305,777 600,000 59% f) 37% 91% g) 15% h) 100% 5,555,695 10,622,604 117,000 8,875,507 600,000 5,575,566 9,984,536 106,554 2,459,464 600,000 (19,871 ) 638,068 10,446 6,416,043 9,204,761 36% 25,770,806 18,726,120 7,044,686 (66,525) (9,316,987) (2,706,020) 6,610,967 149,078 - - 50% i) O%j)k) 0% I) 298,156 2,000,000 1,000 298,156 1,000,000 12,405 (1,000,000) 11,405 149,078 60/.. 2,299,156 1,310,561 (988,595) 82,553 (7,017,831 ) (1,395,459) 5,622,372 10,022,703 112% 8,954,332 10,022,703 1,068,371 $10,105,256 $ 1,936,501 $8,627,244 $6,690,743 a) Per Year-to-date State Highway Fund Revenue Model b) Projection is based on lack of authorization of funding the Federal "Secure Rural Schools" Act payments. c) PIL T payment received July 2014 d) Inter-fund service billed at year end e) Billed and collected upon completion of work f) Projection includes expenditures for unforeseen/unbudgeted retirements g) Final payments of two LID loans made in July 2014 h) Budget includes reserve funds for 5 year CIP i) Transfers made quarterly j) Transfer In -June 2015 k) Revised cash-flow estimate for CIP Projects extending into FY 16 I) Closing out fund 335 Page 10 ADULT PAROLE & PROBATION Statement of Financial Operating Data Revenues SB 1145 DOC Measure 57 Electronic Monitoring Fee Probation Superv. Fees Interfund -Sheriff Crime Prevention Grant CFC-Domestic Violence State Subsidy Alternate Incarceration Interest on Investments Probation Work Crew Fees State Miscellaneous Leases Claims Reimbursement Justice Reinvest HB3194 Miscellaneous Total Revenues Expenditures Personnel Services Materials and Services Capital Outlay Total Expenditures Revenues less Expenditures Transfers In-General Fund Change in Fund Balance Beginning Fund Balance Ending Fund Balance July 1, 2014 through January 31, 2015 FY2014 (58% of Fiscal Year) I %of Actual Actual Budget 3,028,672 2,268,987 75% 220,788 217,845 99% 235,642 119,568 54% 208,461 114,739 60% 50,000 29,169 58% 50,000 12,500 25% 70,242 17,560 37% 14,677 11,220 74% 17,725 15,509 103% 7,807 5,094 83% 9,137 6,684 135% 4,142 -0% 1,323 -0% 6,997 -nfa 458,143 -nfa 671 835 167% 4,384,428 2,819,710 73% 3,343,789 2,056,275 57% 1,107,365 568,353 49% --0% 4,451,154 2,624,628 55% (66,726) 195,083 451,189 263,193 58% 384,463 458,276 747,520 1,131,982 110% $ 1,131,982 $ 1,590,258 FY2015 Budget 1Projection I 3,025,187 3,025,187 a) 220,788 217,845 220,000 204,000 190,000 198,000 50,000 50,000 b) 50,000 50,000 b} 47,996 47,996 15,158 15,158 c) 15,000 20,000 6,150 6,150 d) 4,950 7,500 e} 4,301 4,301 1,500 1,500 500 900 3,851,530 3,848,537 3,623,526 3,623,526 1,148,766 1,148,766 100 4,772,392 4,772,292 (920,862) (923,755) 451,189 451,189 (469,673) (472,566) 1,030,824 1,131,982 $ Variance (2,943) (16,000) 8,000 5,000 2,550 (2,993) (2,893) (2,893) 101,158 $ 561,151 $ 659,416 $ 98,265 a) Annual payment received in July b) Interfund grants. Received when invoiced c) Invoiced quarterly. Greater utilization d) One time payment from back-owing offender e) Annual payment expected in February Page 11 400 100 100 EARLY LEARNING HUB Statement of Financial Operating Data FY 2014 Note 1 Actual Revenues Federal Grants 258,463 Title IV -Family Sup/Pres 21,994 HealthyStart Medicaid 60,561 Youth Investment 124,493 State Grant 55,185 HealthyStart /R-S-G 249,125 OCCF Grant 132,326 Charges for Svcs-Misc 4,138 Program Fees 4,710 Miscellaneous Court Fines &Fees 77,873 Interest on Investments 2,868 Donations 50 Private Grant 130 Sale of Assets 450 Interfund Grants 329,624 Total Revenues 1,321,991 Expenditures Personnel Services 501,770 Materials and Services 1,402,021 Total Expenditures 1,903,791 Revenues less Expenditures (581,800) Transfers In General Fund 278,739 General Fund -Other 89,350 Total Transfers In 368,089 Change in Fund Balance (213,711) Beginning Fund Balance 548,572 Ending Fund Balance $ 334,861 July 1, 2014 through January 31, 2015 (58% of Fiscal Year) I % of FY 2015 Actual Budget Budget Projection $ Variance 119,425 51% 232,218 232,125 (93) -0% a) 21,994 (21,994) 23,223 39% 60,000 60,000 -n/a -n/a 146,035 49% a) 295,190 292,086 (3,104) -0% a) 39,499 37,500 (1,999) -n/a -n/a 4,074 204% 2,000 2,000 44,967 58% 77,086 77,086 1,421 57% 2,500 2,500 -n/a -n/a -n/a 7.260 100% 7,260 7,260 346,405 47% 737,747 710,557 (27,190) 149,615 58% 258,410 258,410 429,420 49% b) 877,110 854,347 22,763 579,036 51% 1,135,520 1,112,757 22,763 (232,631) (397,773) (402,200) (4,427) 147,168 44,675 58% 50% 252,288 89,350 252,288 89,350 191,843 56% 341,638 341,638 (40,788) (56,135) (60,562) (4,427) 334,861 105% 318,121 334,861 16,740 $ 261,986 $ 274,299 $ 12,313$ 294,073 Note 1: Through June 30, 2014 activity included Children &Families Commission a) Grants projected at amended contract amount b) M & S increase related to amended grant contracts Page 12 SOLID WASTE Statement of Financial Operating Data July 1,2014 through January 31, 2015 FY2014 (58% of Fiscal Year) Actual Actual Budget I %of 4,209,029 2,717,817 62% 1,518,056 933,009 60% 1,076,538 753,883 70% 210,053 88,906 98,410 68,055 74% 33,345 22,639 50% 40,873 7,611 30% 11,028 9,945 99% 10,801 6,301 58% 21,508 7,229,641 15,743 79% 4,623,908 1,777,663 1,079,390 56% 3,214,375 1,641,751 48% 930,157 381,624 25,895 5,948,091 1,281,550 282,148 70,471 31% 3,173,236 49% 1,450,672 149,078 545,000 827,148 454,402 550,000 36% 699,078 38% 751,594 1,224,767 $ 1,679,169 1,679,169 118% $2,430,763 FY 2015 Budget I Projection I $ Variance Operating Revenues Franchise Disposal Fees 4,413,809 4,600,000 186,191 Private Disposal Fees 1,550,430 1,570,000 19,570 Commercial Disp. Fees 1,082,144 1,200,000 117,856 Franchise 3% Fees 42% a) 210,000 220,000 10,000 Yard Debris 92,000 104,000 12,000 Recyclables 45,000 45,000 Special Waste b) 25,000 15,000 (10,000) Interest 10,000 12,000 2,000 Leases 10,801 10,801 Miscellaneous 20,000 25,000 5,000 Total Operating Revenues 62% c) 7,459,184 7,801,801 342,617 Operating Expenditures Personnel Services 1,936,555 1,887,195 49,360 Materials and Services 3,435,926 3,306,819 129,107 Debt Service 41% d) 929,794 929,794 Capital Outlay 227,000 224,523 2,477 Total Operating Expenditures 6,529,275 6,348,331 180,944 Operating Rev less Exp 929,909 1,453,470 523,561 Transfers Out Road 50% e) 298,156 298,156 SW Capital &Equipment Reserve f) 1,525,000 2,225,000 {700,000~ Total Transfers Out 1,823,156 2,523,156 (700,OOO~ Change in Fund Balance (893,247) (1,069,686) (176,439) Beginning Fund Balance 1,428,003 1,679,169 251,166 Ending Fund Balance $ 534,756 $ 609,483 $ 74,727 a) Payments due April 15th b) Unpredictable revenue c) Revenues fluctuate with the weather/seasons d) Payments made November and May e) Transfer made quarterly f) Transfer made as resources required in reserve funds. Appropriation to increase appropriation is pending. Page 13 RISK MANAGEMENT Statement of Financial Operating Data Revenues Inter-fund Charges: General Liability FY 2014 July 1,2014 through January 31, 2015 (58% of Fiscal Year) Actual Actual 1% of Budget 272,823 221,543 58% 326,526 228,844 58% 164,150 103,572 58% 1,520,352 911,015 58% 318,566 187,838 59% 139,123 31,264 156% 1,400 530 41% 14 -0% 27,540 23,310 97% 15,567 2,786,061 12,663 84% 1,720,579 60% 268,561 37,078 49,872 5,001 33,139 10,720 161,994 165,361 4,659 11,508 5,619 64 4,531 528,374 166,668 4,974 234,706 59% 178,556 211,158 377,826 875 19,980 198,536 79% 236 205 19 22,021 11,801 69,276 92,377 478,204 34,908 46,964 39% 463,959 5,000 5,000 155,474 114,968 44,261 34,815 52,488 735,427 102,324 1,836,329 26,861 645,603 108% 25,969 13% b 1,151,777 73% 324,005 175,469 53% 146,109 2,306,443 77,603 39% 1,404,849 67% c 479,618 315,730 2,631,057 3,110,676 101% $3,110,676 $3,426,406 379,793 379,793 Property Damage 392,304 392,304 Vehicle 177,550 177,550 1,561,804 1,561,804Workers' Compensation Unemployment 317,000 317,000 Claims Reimb-Gen Liab/Property 20,000 40,000 20,000 Process Fee-Events/Parades 1,300 1,300 Miscellaneous 110 110 Skid Car Training 24,000 24,000 I nterest on Investments 15,050 15,050 2,888,911 2,908,911 20,000TOTAL REVENUES Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance a) Loss Prevention Miscellaneous Repair / Replacement Total General Liability 400,000 440,000 (40,000) PROPERTY DAMAGE Insurance a) Repair / Replacement Total Property Damage 250,000 250,000 VEHICLE Professional Service Insurance Loss Prevention Repair / Replacement Total Vehicle 120,000 110,000 10,000 WORKERS' COMPENSATION Settlement / Benefit Professional Service Insurance a Loss Prevention Miscellaneous Total Workers' Compensation 600,000 880,000 {280,OOO} 200,000 150,000 50,000UNEMPLOYMENT -Settlement/Benefits 1,570,000 1,830,000 {260,OOO}Total Direct Insurance Costs Insurance Administration: Personnel Services 330,406 330,406 199,140 199,140Materials & Srvc, Capital Out. & Tranfs. 2,099,546 2,359,546 (260,000)Total Expenditures 789,365 549,365 (240,000)Change in Fund Balance 3,074,957 3,110,676 35,719Beginning Fund Balance * $ 3,864,322 $ 3,660,041 $ (204,281)Ending Fund Balance FY 2015 Budget 1 Projection I $ Variance a) Annual premiums paid in July b) Payments made quarterly c) Appropriation for Materials & Services will be increased when required. Page 14 DESCHUTES COUNTY 9·1·1 Statement of Financial Operating Data FY 2014 Actual Revenues Property Taxes -Current 6,258,760 Property Taxes -Prior 203,163 Federal Grants 46,514 State Reimbursement 41,813 Telephone User Tax 756,775 Data Network Reimb. 43,943 Jefferson County 29,758 User Fee 53,229 Police RMS User Fees 236,717 Contract Payments 39,075 Miscellaneous 45,553 Claims Reimbursement 29,857 Interest 40,303 Total Revenues 7,825,460 Expenditures Personnel Services 4,420,333 Materials and Services 1,996,805 Capital Outlay 66,498 Total Expenditures 6,483,636 Revenues less Expenditures 1,341,824 Transfers Out -Reserve Fund 7,800,000 Change in Fund Balance (6,458,176) Beginning Fund Balance 10,398,030 Ending Fund Balance $ 3,939,854 $ 6,341,667 a) Current year taxes received beginning in October b) Reimbursement grant. No eligible expenditures made yet in FY 2015 c) Quarterly payments d) Annual billing in December July 1, 2014 through January 31, 2015 (58% of Fiscal Year) FY2015 I %of Budget I Projection I$ VarianceActual Budget 6,131,061 95% a) 6,482,015 6,682,015 200,000 119,265 86% 138,000 138,000 -0% b) 150,000 150,000 22,602 63% 36,000 36,000 194,794 26% c) 750,000 750,000 -0% d) 30,000 30,000 27,680 92% 30,000 30,000 48,067 107% d) 45,000 48,067 3,067 20,179 7% d) 295,788 295,788 -0% d) 11,000 11,000 11,359 126% 9,000 11,360 2,360 -n/a 17,775 58% 30,600 30,600 6,592,782 82% 8,007,403 8,212,830 205,427 2,726,716 1,232,442 231,811 48% 59% 66% 5,634,438 2,077,868 350,000 5,074,438 2,077,868 350,000 560,000 4,190,970 52% 8,062,306 7,502,306 560,000 2,401,813 (54,903) 710,524 765,427 -nfa 2,401,813 (54,903) 710,524 765,427 3,939,854 116% 3,410,000 3,939,854 529,854 $ 3,355,097 $4,650,378 $1,295,281 Page 15 Health Benefits Trust Statement of Financial Operating Data Revenues: Internal Premium Charges Part-Time Employee Premium Employee Monthly Co-Pay COIC Retiree I COBRA Co-Pay Prescription Rebates Claims Reimbursements & Misc Interest Total Revenues Expenditures: Personnel Services (all depts) Materials & Services Admin &Wenness Claims Paid-Medical Claims Paid-Prescription Claims Paid-DentalNision Claims Refunds Stop Loss Insurance Premium State Assessments Administration Fee (EMBS) Preferred Provider Fee Other -Administration Other -Wellness Admin &Well ness Deschutes On-site Clinic Contracted Services Medical Supplies Other Total DOC Deschutes On-site Phannacy Contracted Services Prescriptions Other Total Pharmacy Total Expenditures Change in Fund Balance Beginning Fund Balance Ending Fund Balance $ $ FY2014 July 1, 2014 Actual through January %of 31,2015 (58% of Budget Fiscal Year) 14,485,502 $ 9,328,177 60% a) 16,955 10,502 53% b) 813,125 503,970 62% b) 1,595,847 1,071,543 64% b) 1.061,986 638.313 51% b) 154,981 94,328 86% 2,419 169 0% 67,057 49,767 69% 18.197,871 11,696,769 60"10 129,509 71,631 49% 11,633,134 7,479,568 60% c) 657.550 680,729 96% c) 1.731,608 1,080,324 58% c) (182,448) (256,719) nla 275,052 188,142 47% 67,753 129,841 60% 333,188 238,951 70% 49,712 23,049 40% 42,969 25,504 57% 117,775 94,954 48% 14,726,294 9,684,343 59% 850,209 437,258 46% 54,806 32,395 93% 27,016 11,403 18% 932,031 481,056 46% 314,801 123,233 400~ 1,588,726 641,365 38% d) 13,250 7,696 58% 1,916,777 772,294 38"10 17,704,610 11,009,322 56"10 493,261 687,447 11,967,822 12,461,082 108% 12,461,082 $ 13,148,529 FY 2015 FY2015 Budget $15,517,000 20,000 810,000 1,670,000 1,260,000 110,000 50,000 72,000 19,509,000 144,917 12,552,108 709,494 1,868,398 - 400,000 215,000 343,000 57,200 44,642 195,970 16,385,812 943,500 35,000 61,777 1,040,277 306,000 1,696,000 13,321 2,015,321 19,586,327 (77,327) 11,585,710 $11,508,383 FY2015 $ Variance Projection $15,993,270 $ 476,270 18,004 (1,996) 863,949 53,949 1,836,931 166,931 1,094,250 (165,750) 110,000 - 50,000 - 85,000 13,000 20,051,404 542,404 144,917 - 12,393,258 158,850 1,024,082 (314,588) 1,815,507 52,891 (256,719) 256,719 350,000 50,000 227,597 (12,597) 410,000 (67,000) 40,000 17,200 44,642 - 195,970 - 16,244,337 141,475 943,500 - 70,000 (35,000) 61,777 - 1,075,277 (35,000) 306,000 - 1,539,276 156,724 13,321 - 1,858,597 156,724 19,323,128 263,199 728,275 805,602 12,461,082 875,372 $13,189,357 $1,680,974 1% of Exp covered by Revenues 102.8% 106.2% 99.6% 103.8%1 a) Projection is amount budgeted as HeaHhlDentallnsurance expenditures in the operating funds b) Year to Date annualized c) Average of YTO annualized and 12 month rolling average Page 16 d) YTD Actual-July through November. Projection is YTO Annualized FAIR AND EXPO CENTER Statement of Financial Operating Data Through January 31, 2015 FY2015 Budget I Projection I $ Variance Operating Revenues Events Revenues $ 458,147 $ 255,233 40.8% $ $ $ (105,789) Storage 35,590 20,052 44.6% 4,052 215 1.3% 11,411 100.0% b) 11,411 11,411 200,000 100.0% c) 200,000 244,000 44,000 137 115.7% 7,900 10,136 2,236 1,708 49.9% 1,025,911 949,126 (76,785) 540,531 58.4% 926,183 890,531 35.652 319.099 62.8% 508.386 558,457 (50,071) 859,631 59.9% 1,434,569 1,448,988 (14,419) 212.919 58.3% 365,000 365,000 65,541 60.4% 108,544 110,770 2,226 nla 327 nla 327 327 280 nla 280 280 63.0% 80,000 109,438 29,438 59.5% 553,544 585,815 32,271 60.8% 112,213 112,213 0.0% 100 100 60.8% 112,313 112,213 100 9.0% 292.333 288,850 (3,483) 9.1% 288,850 288,850 3,483 {3,483} 36.056 (26,260) (62,317) -0.4% 87.000 {345~ {87,345 l $ 123,056 $ (26,606) $ (149,662) Camping at F & E 22,866 Horse Stall Rental 52,084 Concession % -Food 97,917 Annual County Fair (net) 205,000 Miscellaneous Total Operating Revenues Operating Expenditures: General F & E Activities Personnel Services 895,582 Materials and Services 657,882 Total Operating Expenditures 1,553,464 Non-Operating Revenues Transfer-General Fund 374,186 Transfer-Room Tax -(Fund 160) 262.900 Transfer-Fair & Expo Reserve 100,000 Interest 409 Grants 176,289 Rights & Signage 000 Total Non-Operating Revenues Non-Operating Expenditures Debt Service Capital Outlay Total Non-Operating Expenditures TRT - 1 % for Marketing Revenues (Fund 170) Less: Expenditures Net TRT 1% for Marketing Change in Fund Balance Beginning Fund Balance Ending Fund Balance a) See "Food & Beverage Activities Schedule" b) July and August Contract with Premier Services c) Revenues and Expenses for the annual County Fair are recorded in a separate fund and the available net income is transferred to the Fair & Expo Center Fund Page 17 Deschutes County Food and Beverage Activities September 1, 2014 through January 31, 2015 Revenues Direct Costs Beginning Inventory Purchases (Food/Bev/Paper/Chemicals) Less: Ending Inventory Cost of Food & Beverage Event Expenses Labor Total Direct Costs Gross Profit Expenses/Expenditures Personnel Other Materials &Services Total Expenses/Expenditures Income -Food &Beverages Activities FY 2014 September October November December $ 17,350 $ 12,678 $ 29,005 $ 4,683 $ --17,899 17,773 1,048 19,302 7,538 1,350 -{17,899) (17,773) (18,199) 1,048 1,403 7,664 924 --225 948 2,334 2,651 4 1803 1,203 3,382 4,054 12,693 3,075 13,968 8,625 16,312 1,608 8,520 8,742 8,742 8,742 1,895 244 277 639 10,415 8,986 9,019 9,381 $ 3,554 $ (361) $ 7,293 $ (7,773) $ 13,390 $ ~,236 $ 21,992 $ 2,340 Percentage Year to of January Date Revenues 33,550 $ 97,266 18,199 - 7,521 36,759 ~16,755) {16,755) 8,965 20,003 20.6% 142 1,315 1.4% 5,784 16,775 17.2% 14,890 38,093 39.2% 18,659 59,173 60.8% 8,742 43,487 -3,055 8,742 46,542 $ 9,917 $ 12,630 $ 7,202 $ 47,160 Page 18 '¥l"'F J.Il')i",~""$I¥$it4E P fi'f!'iPI!l'tP, ; i,. l:'l!Il'JiIJi i\f¥4!QA ¥ ; i; ;*.. (. $,,2$, \Q. g; ,At jUM.l$Y!§ ,pWlfhi\$¥9WW04SA,«R4I SAP. 44;;;: '*. 4. . $ U 4 JUSTICE COURT Statement of Financial Operating Data .. FY2014 Actual Revenues Court Fines & Fees 425,632 State Miscellaneous - Interest on Investments 653 Total Revenues 426,285 Expenditures Personnel Services 407,456 Materials and Services 183,148 Total Expenditures 590,605 Revenues less Expenditures (164,319) Transfers In-General Fund 140,819 Change in Fund Balance (23,500) Beginning Fund Balance 153,818 Ending Fund Balance $ 130,317 July 1, 2014 through January 31,2015 (58% of Fiscal Year) I %of Actual Budget FY2015 Budget I Projection I $ Variance 204,353 45% a) 450,000 443,838 (6,162) -0% 600 600 309 38% 815 815 204,662 45% 451,415 445,253 (6,162) 247,376 94,919 59% 57% b) 416,045 166,093 416,045 140,177 25,916 342,295 59% 582,138 556,222 25,916 (137,633) (130,723) (110,969) 19,754 43,400 58% 74,398 74,398 (94,233) (56,325) (36,571) 19,754 130,317 121% 107,621 130,317 22,696 $ 36,085 $ 51,296 $ 93,746 $ 42,450 a) Historically, largest portion of revenue collected in Spring months b) $25,000 in software maintenance paid out in July Page 19 CAPITAL PROJECTS • Campus Improvement • North County Campus Deschutes County .. Campus Improvement (Fund 463) Inception through January 31, 2015 Received and Committed or Expended Projected Total RESOURCES: Transfer in (Note A) $ 796,617 $ $ 796,617 Transfer in -General Fund 150,000 150,000 Transfer in -General County Projects (142) 700,000 700,000 Oregon judicial Dept Payment 20,000 20,000 Interest Revenue 9,843 400 10,243 Total Resources 1,676,459 400 1,676,859 EXPENDITURES: Basement Jail/Boiler Demolition JB1 168,109 168,109 Basement Public File View JB2 141,862 141,862 1 st Floor Public File View JB3 117,980 117,980 1 st Floor Restrooms/Hasllnger Court JB4 401,231 401,231 1 st Floor DeHoogiBagley Court/Jury Room JB5 81,702 81,702 Accounting Area Open Workspace JB6 40,257 40,257 Courthouse DA Offices JB7 34,348 34,348 Hearing Room Justice Bldg 21Basement Phases 1/2 JB8 393,990 289,182 683,173 "Stone Building" 720 720 Internal Service Fund Charges 7,477 7,477 Total Materials & Services 1,387,677 289,182 1,676,859 Revenues less Expenditures $ 288,782 $ (288,782) Notes: A. Remaining proceeds from the FF&C borrowing for the OSP/911 Building. Completed Projects JRF 211212015 Deschutes County North County Services Building Inception through January 31,2015 l -~ l I i .~ i Projected RESOURCES: Rental 500 Expended from Fund 142 for Design Center 1,427,013 Transfers in: Fund 140 for Unger Remodel 152,461 627,668 Fund 142 ( FY 2012) 600.000 Fund 140 for Antler Building (P & I) 151.736 Interest Revenue 9.313 Total Resources $ 2,341,023 $ 627,668 EXPENDITURES: Design Center -Hwy 97 Land & Building 1,402,013 Architecture/Design 47,092 Utilities 25,328 1.000 Fees. Permits &SDCs 323 Other 4,113 Total Design Center 1,478.869 1.000 Antler Building Land &Building 601.200 Building Improvements 42,364 Personal Property 27.016 Interest 2.827 Other 928 Total Antler Building 674.334 Unger Building Remodel Remodel Contstruction 600.000 Architecture/Design 45.561 19.000 Relocation Costs 17,979 9,200 Fees & Permits 620 19.380 Utilities 801 2.199 Furniture. Fixtures &Equipment 6,404 43.596 Other 12.843 Total Unger Building Remodel 84.208 693.374 Other Internal Service Fund Charges 33,102 Evergreen School 3,803 500 1,427.013 a) 500 1,427,013 780.129 600.000 151.736 9.313 $2,968,691 b) 780,129 600,000 151.736 9.313 $2,968,691 1,402.013 47.092 26.328 323 4,113 1,479.869 1,402.013 47.092 26,328 323 4.113 1,479,869 601.200 42.364 27,016 2.827 928 674.334 601,200 42.364 27,016 2.827 928 674.334 600.000 64.561 27.179 20,000 3.000 50.000 12,843 777.583 600,000 64,561 27.179 20,000 3.000 50.000 12,843 777.583 33.102 3.803 33.102 3.803 Total Expenditures 2,274,316 694,374 2,968,691 2,968,691 Net $ 66,707 $ (66,707) $ a) The property was purchased in FY 2011 with resources from Fund 142 -General County Projects. Also. $25.000 was paid to the architect from Fund 142 in FY 2011. b) The resources for the Unger remodel will be providced by Fund 140. c) The costs incurred through June 30. 20015 for alternate facilities for Justice Court and Parole & Probation will paid paid from Fund 462.