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 March 16, 2015 (1) Monthly Investment Report -February 2015 (2) February 2015 Financials Investment Income Investments By County Function Fiscal Year 2014-15 Feb-15 I I Y-T-O General $ 160,442,462 $ 97,362 $ 680,807 -- Total Investments $ 160,442,462 Total Investment Income 97,362 680,807 Less Fee: 5% of Invest. Income (4,868) (34,040) Investment Income -Net $ 92,494 $ 646;767 $Municipal Debt 3.38% Corporate Notes 21.33% Time Certificates 1.73% U. S. Treasuries 4.99% Federal Agencies 33.61% LGIP/BOTC 34.96% Total Investments 100.00% Total Portfolio: By Investment Types Municipal Debt Corporate 3.4% Notes 21.3% Time Certificates LGI 1.7% u. s. Treasuries 5.0% 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% Yield Percentages -~.~BOTe I LGIP ~ 0.50% 0.50% Investments ~ 0.82% 0.80% Average ~ 0.72% 0.71% Comoarat 24iV1onth Treas. ~ 0.63% LGIP Rate ~ 0.50% 36 Month Treasu~ 1.01 % Months to Maturity oto 30 Days 35.02% Under 1 Year 44.59% Under 5 Years 100.00% ----- -- ----------- -- Deschutes County Investments I Portfolio Management I --r-------! ,Portfolio Details -Investments Februa ry 28, 2015 Purchase Maturity Days To Ratings Coupon Par Market Book Call ~ jSecurity Broker Date Date Maturity Moodys S&P Rate YTM 365 Value Value Value Date 4001154309 ;Columbia Siale Bank CO 41112013 313012015 29 0 ,150 0152 100,000 100 ,000 100,000 ' 273-1 50017-5 'Soulh Valley Bank CD 512012013 512012015 80 0,748 0758 -10_ 0 ,000 , 200,000 200,000 UMP972002570 'Umpq~a Bank 61712014 61712015 98 0.400 0.406 240,000 240,000 240 ,000 3692G5F7 36962G5F7 SYS10316 91159HGX2 91 159HGX2 45906KOG76 86459DAB2 064159BA3 88059EGU2 742718055 532457AN8 084670BG2 17275RAC6 06406HCG20 3133734F6 78oo8K5Vl 478160AYO 3134G4WC85 120022332 949746QU8 949746QU8 949746QU8 686053CF4 3 1359YBY2 88059EMP6 78008TLB8 94974BFL9 912828QXl 084670BB3 3134G56B6 3134G5GE9 31 359YLS4 313OA1C08 3130A3B45 912828RM4 3133EEBU3 060SOTLRI 3133EC'M12 0641 59 0Al 3136G1XP9 06406HCA5 91282BSC5 742651DN9 0641590Z6 3134G5K87 3134G4Z76 912828550 3135GOZ08 89236TBH7 3136FPYB7 31359MEL3 31359MEL37 31771CS97 29270CYZ2 84247PHS3 912828TM2 313383JB8 3136GOC 74 313OA1ZK? 31771KA090 88059FAZ4 3136G1AU3 I~',~'~ 3135GOVU4 3130A25R3 3136G16BO f- General Electric -Corporate N CASTLE 911712013 613012015 121 AA+ AI 2,375 0,865 1,400,000 1,409,030 1,406,918 _._- General Electric -Corporate N CASTLE 111012014 , 613012015 121 AA+ Al 2,375 0,501 545,000 548,515 548,360 .~-~----- Umpqua B~n! 71912013 71912015 130 0 ,500 0,507 2,000,000 2,000 ,000 2,000 ,000 , _._.--, US Bancor ~ ,CASTLE 41212014 712712015 148 A+ Al ~ 2 ,450 ' 0 ,501 1 1,180,000 1,190,1 36 1,189,285 , U 5 Bank -Corp Note CASTLE 3126/2014 7127/2015 148 A+ Al 2.450 0.500 1,573,000 1,586,512 1,585 ,381 --_.._. International Bonds for Recons 'CASTLE 12119/2014 9/112015 184 AM Aaa 0 ,443 0.457 1,220 ,000 1,216 ,572 1,217 ,238 ' - , Morgan Hill Redev-B CASTLE 10/1/2014 9/112015 184 ,AA-1.120 0 .450 750,000 . 7'?..!.,,~45 752 ,504 - Bank of Nova Scotia CASTLE 4/3/2014 1019/2015 222 i A+ Aa2 0,750 , 0 ,621 540,000 540,837 540,420 -- ITennessee Valley Aulhority CASTLE 12/4/2014 11/112015 245 0.434 0 ,447 418,000 416,529 416,766 ._._ _ .._ -->- , ---.. --Procter & Gamble 'CASTLE 1216/2013 11115/2015 259 ,AA-AA3 1.800 0 ,430 1,000 ,000 1,009 ,2 60 1,009,615 Eli Lilly & ~o . CASTLE 3/241201 4 11 112016 306 AA-A2 6,570 : 0 .500 1,408,000 1,478,442 1,478 ,80 ~-.- Berkshire Halhaway Inc CASTLE 3/312014 ' 211112016 347 ,AA Aa2 0 .800 , 0,500 1,000,000 , 1,003,020 1,002 ,815 1 Cisco Systems Inc ,CASTLE 212712014 2/2212016 358 AA-Al 5,500 0 ,550 , 1,874 ,000 , 1,964,964 1,963,825 ' -Bank of New York Mellon Corp ,CASTLE 41412014 3/4/2016 369 'A+ Al 0 ,700 0 .681 1 1,000,000 1,001,580 1,000,189 2/3/2 016 Federal Home Loan Bank I CASTL§ 51212014 4!.15/~0_16 411 AA+ Aaa 0.772 0,600 650,000 650,455 651,248------'r--:' Royal Bank of Canada ,CASTLE 1111912014 4/19/2016 415'AA-Aa3 2,875 0,650 1,500,000 1,537 ,035 1,537 ,584 , - ' Johnson & Johnson \CASTLE 1/7/2014 5/15/2016 441 AM Aaa 2,150 0 ,620 1,529,000 1,560,390 1,556,951 Federal Home Loan Mtg Corp OA OAV ' 12/10/2014 5127/2016 453:AA~. Aaa 0 ,500 ' 0 ,521 1 2,000,000 , 1,998,820 2000,000 : 5/2772015 Lewis-& Clark Bank 12/8/2014 61812016 465 1:000'-1.014 240,000 , 240,000 240 ,000 Wells Fargo Corporat"eNote VINISP 2/2012014 6/15/20 16 472'A+ A2 3.676 0 :750 i~ooo,ooo , 1,037,380 1,037 ,3 14 Wells Fargo Core2 rate No te CASTLE 10/2120'14 6/151 20 16 472 A+ A2 3.676 0 .870 1,000,000 1,037,380 ! 1,035 ,826 Wells Fargo CO':Eora te Note CASTLE 1211212014 6/15/20 16 472 A+ A2 3.676 0 ,860 1,000,000 1,037,380 1 ,0~5 ,984 Oregon School Boards Assoc CASTLE 3/71201 4 6130/2016 Aa2 0 ,000 0 .999 3 ,000 ,000 2,965,320 2,960 ,591 - CA5JU! ..7MZIDIl. 117J20JJ ~~ AU -0.800 LI5W J'..IIUU"tO '1UT1m'l1i Federal National Mtg Assn CASTLE 101 16/2014 7/1512016 502 0 .354 0 .365 1,693 ,000 1,677,441 1,684 ,654 - Tennessee Vallel Authoritl CASTLE 10/29i2014 7/f5iio16--50T 0.490 0.507 2,000 ,000 1,981 ,480 1,986 ,330 Royal Bank of Canada CASTLE 11126/2014 7/20/2016 507 AA-Aa3 2.300 0,800 ' 1,630,000 1,664,833 1,663,589 , Wells Fargo Corporate Note OAOAV 121912014 7/20/2016 507A';-A2 1,250 0 ,834-,-.!,Q00,OOO 1,005,760 1,005 ,720 U ,S. Treasury MBS 61 19/2014 713 112016 5 18 AA-Aaa 1,500 0 ,548 ' 1,000,000 1,014,840 1,0 13,402 Berkshire Hath awiIY, lnc CASTLE 12/912014 8/1 5/2016 533 AA Aa2 2,200 0,690 ' 2,000,000 , 2,042,280 2,043,615 Federal Home Loan Mtg Core MBS 71712014 8126/20 16 544 AA+ Aaa 0,580 0 ,629 , 2,000,000 1,992,320 1 998539 5/26/2015 Federal Home Loan Mtg Corp. CASTLE 121212 014 8126/20 16 544 AA+ Aaa 0 ,570 0,540 3,000 ,000 2,998 ,590 3,001 ,014 812 6/2015 _'CA8I'U!: ~lD ·AA. ABa OMO '0.840 ' 2.OlIO.wu ·1IIII2U18 Federal National Mtg Assn IPJ 3/5/2014 9/15/20 16 564 AA,+ Aaa 0,778 0 ,812 672,000 665,549 663 ,805 - Federal Home Loan Bank 1 CASTLE 711712014 9/28/2016 577'AA+ Aaa 1,125 m 2,000,000' 2,010,180 2,008 ,299 ! 9/28/2015 Federal Home Loan Bank ,MBS 10/2812014 10/28/2016 607 AA+ Aaa 0 ,700 0 ,659 750,000 . 749 ,273 ' 750 ,400 10128/2015---->- U,S , Treasury CASTLE 1212712013 10/31/2016 610 AA+ Aaa 1 ,000~' 1,000,000 ' 1,008,050 1 1,004,495 - Federal Fann Credit Bank PJ ,12/10/2014 11/14/2016 624AA+ Asa 0 ,600 0 ,648 , 2,000,000 , 1,997,400 , 1,998 ,375 - Bank of America -Corporal e CASTLE 5113/2014 11114/2016 624 ,A A2 1.125 1,050 1,900,000 1.902 ,109 1,902 ,379 - ~atfltatn5 111'141i1!D'16 ~A ;Q 1.1211 2:wv..uuu .. ""111Federal Fann Cred it Bank CASTlE 12/17120 13 121712016 647 AA+ ;Aa a 0 ,875 0 ,722 ' 2,1 00,000' 2,108,106 2,105,854 - Bank Of Nova Scotia CASTLE 61912014 12/13/2016 ' 653 A+ As2 1.100 0.9 10 1 1,800 ,000 1 1,804,338 , 1,806 ,008 ' - Federal National Mtg Assn PJ 31612014 1211912016 659 AA+ Aaa 0,800 0 ,788 ' 2,000,000 ' 2,000,340 , 2,000,439 5/1912015 Bank o! New York Melton ~ CASTLE 412312014 111712017 688 A+ Al 2.400 1,067 2,000 ,000 , 2,051,020 ' 2,049 ,189 ' 1211812016 U,S, Treasury I CASTLE 111612014 113112017 702 'AA+ Aaa 0,875 0.844 2,000,000 ' 2,010,460 2,001 ,185 : Private Expt Fdg PJ 1112012014 211512017 717 1.375 ~ 0,799 3,000,000 ' 3,034,710 3,033,425 , Bank of Nova Scotia CASTlE 511/2014 3117/2017 747 A+ Aa2 O,BOO 0,906 1,000,000. 987,980 997 ,869 3/1712016 Federal Home Loan Mtg Corp PJ 1211012014 3/30/2017 760 AA+ Aaa 1,000 1,000 , 2,000,000 , 2,001,220 , 2 ,OOO,000~~13 Federal Home Loan Mtg Corp MBS 121812014 4/7/201 7 768,AA+ Aaa 1,000 1,001 2,000,000, 2,000,720 2,000,000 4nt2015 U,S, Treasury WF 1/1712014 4130/2017 791 AM Aaa 0,875 0 .95O i 2,000,000 1 2,007,500' 1,996,804 , - Federal National Mtg Assn IPJ 101712014 5/1612017' 807AA+ Aaa 2,000 1,127 ' 3,000,000 . 3,053,310 ' 3,050,419 ' 5/16/2016 Toyota Mtr Cred -Corp N ICASTLE 7/29/2014 5/16/2017 1 807AA-AA3 1,125 1.1 SO 2,125,000 2,135,923, 2,123,826 : !Federal National Mtg Assn .I VINISP 2/7/2014 1 512312017 814 AA+ Aaa 2,OSO 0 ,885 , 1,460,000 1,499,916 ' 1 497,2SO - Federal National MIg Assn CASTLE ' 1212312013 1 61112017 , 823 AA+ Aaa 1.061 1,115 ' 1,000,000 , 980,370 ; 975 ,736 - 1 Federal National Mtg Assn CASTLE 112412014 6/112017 , 823 AA-Aaa 1.081 1.136 1,050,000 ' 1,029,389 1,024 ,047 -------_. -1 I FICO Stri~ CASTLE 121912014 6/6/201 ? 828 Aaa 1":0i9 ~065--1Q.~8,OOO . 1,006,299 1 1,003,905 ' - I Bonneville Power Ad ministratio CASTLE 4/24 /2014 7/112017 , 853 AA-Aal 1,197 1,171 670,000 , 670,918 , 670,407 - ISouthern CA Public Power Autho CASTLE 61171201 4 7/1/2017 ' 853 :AA-1,145 1.180 , 1,000,000 1 996,690 999,194 - U,S. Treasury CASTLE 9110/2014 1,000,000 , 994,380 : 989,282 U.S . l-.rv -CASTI:E ~5 :~~~ ~. ~~, ' UXJO.OOO '~ wa.1J8 ~ Federal Home Loan Bank I VINISP 12/2612013 9127/2017 ' 941 AA+ Aaa 1.000 1250 1,000,000 1 999,350 , 993,735 - Federal National Mtg Assn VIN ISP 21312014 912712017 : 941 AA+ Aaa 1.000 1 0 ,943 ' 1 1,050,000 1,051,764 , 1,05 1,510 912712015 Federal Home Loan Bank MBS 5128/2014 11 /28 /2017 ' 1003 AA.+ Asa 0 ,750 1 0 ,750 1 ,000,OOO ~ 1,000,400 1,000,000 FICO Strip OAOAV 121 10120 14 11 /3012017 ' 1005 Aaa 1,205 1.267 ; 2,000,000 1 1,937,900 1,932,704 1 - Tennessee Valley Authority 'CASTLE 1112112014 1211512017 1020 'AA+ 1.205 1,268 ' 1,059,000 1,021,522 1,022,833 1 Federal National Mtg Assn IVINISP 1212312013 113012018 1066 AA+ 07001 1.420' 1,000,000' 989,380 990 ,519 413012015 -'075 1.252 1318 1,260,000iIiM.:;w:;. ~~:'=~:-1075 ~40.000 '~~:1 ~fsr 1323 '~~= :: Federal National Mtg Assn IVINISP 112412014 41312018 , 112 9 1AA+ 'Aaa 1.125 1,540 1,000000 996 ,390 1 987,620 41312015 Federal Home Loan Bank IMBS 6119/201 4 611912018 ' 1206 AA+ 'Aaa 1,000 1.026 2 ,000,000 ' 2,000 ,740 ) 1,998,350 1 3/1912015 Federal National Mtg Assn VINISP 112112014 1212712018 ' 1397'AA+ Aaa 0 .750 1,820 1,000,000 ' 995,280 1 977,361 312712015 Local Govt Investment Pool O,SOO O.SOO 51 ,629 ,004 , 51,629,004 51 ,629,004, - Bank of the Cascades 0 .500 1 0,500 4,459,459, 4.459,459 4,459,459 - , 160,442,463' 160,806,834 ; 160,719,501 , Memorandum Date: March 12,2015 To: Board of County Commissioners Tom Anderson, County Administrator From: Wayne Lowry, Finance Director RE: Monthly Financial Reports Attached please find February 2015 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), 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 July 1, 2014 through February 28, 2015 (67% of Fiscal Year) FY 2014 FY2015 I %of Actual BudgetActual Budget I Projection I $ Variance Revenues Property Taxes -Current 21,906,239 22,092,839 97% a) Property Taxes -Prior 704,120 484,350 84% Other General Revenues 2,116,386 1,683,761 75% b) Assessor 875,381 661,887 76% c) County Clerk 1,276,019 946,798 80% BOPTA 16,097 10,934 68% c) District Attorney 226,973 154,875 85% d) Tax Office 236,278 176,237 79% c) Veterans 80,787 44,084 43% Property Management 91,900 16,000 64% Grant Projects 2,000 -nla Total Revenues 27,532,179 26,271,766 93% Expenditures Assessor 3,559.750 2,443,048 64% County Clerk 1,293,531 921,160 60% BOPTA 59,895 40,675 57% District Attorney 5,382,874 3,503,764 60% Tax Office 796,232 549,800 63% Veterans 292,672 205,339 58% Property Management 248,054 173,084 67% Grant Projects 130,054 16 nla Non-Departmental 1,432,177 652,856 57% 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 3,793,770 1,536,210 70,777 5,835,377 877,907 354,989 258,569 - 1,139,696 23,236,401 500,000 486,500 (90,000) 2,317,299 70,000 876,137 1,481,190 300,000 16,117 296,212 113,600 222,199 101,986 25,000 -- 29,059,041 893,600 3,793,770 - 1,536,210 - 70,777 - 5,585,377 250,000 877,907 - 354,989 - 258,569 - -- 1,139,696 - Total Expenditures 13,195,239 8,489,741 61% 13,867,295 13,617,295 250,000 Transfers Out 16,327,584 10,624,966 70% 15,116,394 15,116,394 - Total Exp & Transfers 29,522,823 19,114,707 66% 28,983,689 28,733,689 250,000 Change in Fund Balance (1 ,990,644) 7,157,059 (818,248) 325,352 1,143,600 Beginning Fund Balance 10,371,843 8,381,199 109% 7,692,433 8,381,199 688,766 Ending Fund Balance $ 8,381,199 $ 15,538,258 $ 6,874,185 $ 8,706,551 $1,832,366 I Beginning Net Working Capital· Requested Budget $ 8,630,800 a) Current year taxes received beginning in October b) PIL T received in July -$500,000 c) YTD Actual includes three 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 #1065-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 February 28, 2015 (67% of Fiscal Year) I %of Actual Budget 195,375 54% a) 36,653 40% b) 59,400 149% c) 27,170 74% a) 7,993 33% d) 5,000 25% a) 6,107 87% e) 6,100 nfa f) 13,636 227% g) 6,373 142% h) -0% i) 4,212 nfa j) 1,205 nfa k) -nfa 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 15,500 (8,500) 20,000 20,000 7,000 8,700 1,700 -8,500 8,500 6,000 24,000 18,000 4,500 8,000 3,500 3,800 -(3,800) -6,000 6,000 -1,205 1,205 1,025 1,025 369,893 62% 593,421 684,649 91,228 3,335,570 668,832 - 1,830 65% e) 65% e) 0% 50% 5,146,491 1,021,392 1,100 3,660 5,018,809 1,000,910 - 3,660 127,682 20,482 1,100 - 4,006,231 65% 6,172,643 6,023,379 149,264 (3,636,339) (5,579,222) (5,338,730) 240,492 3,578,896 67% 5,368,346 5,368,346 - (57,443) (210,876) 29,616 240,492 1,244,605 100% 1,250,000 1,244,605 {5 ,395} $ 1,187,163 $1,039,124 $1,274,222 $ 235,098 I Beginning Net Working Capital -Requested Budget $1,271,324 a) Payments received quarterly. b) Additional grant awards. Payments received quarterly. Quarter 2 has been billed c) Increase in projection due to out-of-County detention revenue. 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 Page 2 k) Increased projection due to receipt of FY 2014 funds in FY 2015 SHERIFF -Consolidated Statement of Financial Operating Data FY2014 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 February 28, 2015 (67% of Fiscal Year) Actual 1% of Budget FY 2015 Budget I Projection I $ Variance 19,520,335 96% 20,365,842 21,171,189 805,347 11,387,614 89% 12,751,766 12,907,796 156,030 30,907,949 93% 33,117,608 34,078,985 961,377 1,633,697 66% a) 2,467,673 2,518,866 (51,193) 831,619 70% 1,192,980 1,172,880 20,100 1,074,240 57% 1,886,365 1,886,265 100 1,056,282 65% b) 1,627,803 1,665,801 (37,998) 5,643,376 65% c) 8,705,700 8,538,675 167,025 480,079 60% c) 798,805 769,705 29,100 10,077,232 66% d) 15,214,157 15,174,409 39,748 202,526 67% 302,867 302,767 100 318,324 179% e) 177,852 385,315 (207,463) 973,334 59% 1,655,424 1,655,424 - 319,996 58% 551,318 551,218 100 517,842 64% 806,044 808,120 (2,076) 48,536 67% 72,813 72,813 - 23,177,084 65% 35,459,801 35,502,258 (42,457) 7,730,865 (2,342,193) (1,423,273) 918,920 200,000 100% 200,000 200,000 - 200,000 100% 200,000 200,000 - 7,330,865 (2,742,193) (1,823,273) 918,920 9,225,556 120% 7,658,937 9,225,556 1,566,619 $16,556,421 $4,916,744 $ 7,402,283 $2,485,539 I Beginning Net Working Capital -Requested Budget $ 7,153,040 a) Unplanned repair of Administration Building roof for $66,000 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 Communication equipment was awarded in September. Expenditures for this equipment is offset by grant revenue in Fund 701 Page 3-A I SHERIFF· Fund 255 Statement of Financial Operating Data Revenues (Fund 255) Law Enf Dist Countywide Law Enf Dist Rural Total Revenues Expenditures (Fund 255) Sheritrs Services Civil/Special Units Automotive/Communications Investigations/Evidence Patrol Records Adult Jail Court Security Emergency Services Special Services Training Other Law Enforcement Svcs Non-Departmental Total Expenditures Revenues less Expenditures July 1,2014 through February 28,2015 (67% FY 2014 of Fiscal Year) Actual Actual I Budget 20,817,324 14,820,450 58% 12,278,716 8,356,633 56% 33,096,040 23,177,084 57% FY 2015 Budget I Projection I $ Variance 25,428,019 22,358,329 (3,069,690) 14,948,526 13,143,929 {1,804,597) 40,376,545 35,502,258 (4,874,287) 2,308,182 1,633,697 66% a) 2,467,673 2,518,866 (51,193) 1,132,029 831,619 70% 1,192,980 1,172,880 20,100 1,701,586 1,074,240 57% 1,886,365 1,886,265 100 1,418,744 1,056,282 65% b) 1,627,803 1,665,801 (37,998) 8,247,222 5,643,376 65% c) 8,705,700 8,538,675 167,025 761,260 480,079 60% c) 798,805 769,705 29,100 14,277,113 10,077,232 66% d) 15,214,157 15,174,409 39,748 294,563 202,526 67% 302,867 302,767 100 194,888 318,324 179% e) 177,852 385,315 (207,463) 1,352,528 973,334 59% 1,655,424 1,655,424 506,938 319,996 58% 551,318 551,218 100 801,895 517,842 64% 806,044 808,120 (2,076) 81,701 48,536 67% 72,813 72,813 33,078,650 23,177,084 65% 35,459,801 35,502,258 (42,457) $ 17,390 . $ 4,916,744 $ ${4,916,744~ a) Unplanned repair of Administration Building roof for $66,000 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 Communication equipment was awarded in September. Expenditures for this equipment is offset by grant revenue in Fund 701 Page 3-B Expenditures Sheriffs Services Personnel Materials &Services Capital Outlay Total Sheriffs Services Civil/Special Units Personnel Materials &Services Capital Outlay Total Civil/Special Units Automotive/Communications Personnel Materials & Services Capital Outlay Total Automotive/Communications Investigations/Evidence Personnel Materials & ServiCes Capital Outlay Total InvestigationslEvidence Patrol Personnel Materials & Services Capital Outlay Total Patrol Records Personnel Materials &Services Capital Outlay Total Records Adult Jail Personnel Materials & Services Capital Outlay Transfer Out -Jail (D/S & Cap Proj) Total Adult Jail Court Security Personnel Materials &Services Capital Outlay Total Court Security Emergency Services Personnel Materials & Services Capital Outlay Total Emergency Services Special Services Personnel Materials &Services Capital Outlay Total Special Services Training Personnel Materials &Services Capital Outlay Total Training Other Law Enforcement Services Personnel Materials & Services Capital Outlay Total Other Law Enforcement Svcs Non-Departmental Materials & Services Total Non-Departmental Total Expenditures $ SHERIFF -Expenditure Detail Statement of Financial Operating Data July 1, 2014 through February 28, 2015 (67% of Fiscal Year) FY 2014 FY2015 Actual I %of BudgetActual Budget I Projection I $ Variance 1,342,795 956,213 67% 965,387 677,484 66% -0%- 1,633,697 66%2,308,182 1,027,640 725,072 68% 104,389 106,546 90% --0% 831,619 70%1,132,029 400,169 265,089 66% 809,151 54%1,265,667 35,750 0% 1,701,586 1,074,240 57% 948,132 64%1,277,983 140,761 108,150 69"10 -0%- 1,056,282 65%1,418,744 7,450,178 4,987,293 65% 547,770 370,908 58% 249,274 285,175 84% 8,247,222 5,643,376 65% 453,260 65%659,297 26,819 25%101,963 -0%- 480,079 60%761,260 8,349,998 66%11,899,534 1,406,996 69% 63,176 2,069,651 56,588 271% 244,752 263,649 55% 14,277,113 10,077,232 66% 284,173 195,573 67% 10,390 6,953 69"10 -0%- 202,526 67%294,563 95,913 65%169,170 222,411 746%25,718 -0%- 194,888 318,324 179% 804,068 63% 183,769 1,152,258 102,142 46% 67,124 42%16,500 1,352,528 973,334 59"";' 259,041 62%385,634 60,956 45%121,303 -0%- 319,996 58%506,938 446,223 62% 70,773 731,122 59,316 73% 12,303 172%- 517,842 64%801,895 48,536 67%81,701 48,536 67%81,701 33,078,650 $23,177,084 65% 1,431,828 1,431,828 1,020,745 1,071,938 (51,193) 15.100 15,100 2,467,673 2,518,866 (51,193) 1,073,870 1,053,870 20,000 119,010 119,010 100 100 1,192,980 1,172,880 20,100 399.334 399,334 1,486,931 1,486,931 100 100 1,886,365 1,886,265 100 1,470,106 1,485,704 (15,598) 157.597 180,097 (22,500) 100 100 1,627,803 1,665,801 (37,998) 7,728,332 7,562,710 165,622 636,868 628,665 8,203 340,500 347,300 (6,800) 8,705,700 8,538,675 167,025 692,244 667,244 25,000 106,461 102,461 4,000 100 100 798,805 769,705 29,100 12,675,178 12.584,476 90,702 2,039,314 2,078,314 (39,000) 20,900 56,588 (35,688) 478,765 455,031 23,734 15,214,157 15,174,409 39,748 292,715 292,715 10,052 10,052 100 100 302,867 302,767 100 147,942 147,942 29,810 237,373 (207,563) 100 100 177,852 385,315 (207,463) 1,273,721 1,273,721 223,703 223,703 158,000 158,000 1,655,424 1,655,424 416,955 416,955 134,263 134.263 100 100 551,318 551,218 100 717.594 714,507 3,087 81,310 81,310 7,140 12,303 (5,163) 806,044 808,120 (2,076) 72,813 72,813 72,813 72,813 535,459,801 $ 35,502,258 $ ~42.457L Pag 4 LED #1 • Countywide Statement of Financial Operating Data FY 2014 Actual 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 & TRANSFERS DC Sheriff's Office DC Comm Systems Reserve Transfer to Reserve Fund July 1, 2014 through February 28, 2015 (67% of Fiscal Year) Actual 1% of Budget FY2015 Budget I 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 37,000 12,000 40,000 60,000 20,000 65,000 66,058 1,058 64,000 64,000 20,365,842 21,171,189 805,347 25,207,970 22,358,329 2,849,641 80,000 80,000 - 100,000 100,000 - 25,387,970 22,538,329 2,849,641 (5,022,128) (1,367,140) 3,654,988 5,242,177 6,133,909 891,732 $ 220,049 $4,766,769 $4,546,720 $4,616,439 16,698,208 532,040 1,630,823 365,577 - 107,806 36,311 85,781 329,918 83,297 20,897 69,723 475,815 32,480 50,563 38,361 66,441 16,838,891 348,935 1,221,762 236,303 106,171 107,805 27,170 247,375 110,534 24,956 10,072 24,346 49,257 22,644 37,383 66,268 40,462 97% a) 97% 75% b) 113% c) 71% 100% 59% 290% d) 138% e) 31% f) 50% g) 49% 8Wo h) 91% i) 93% 102% 63% 20,624,082 19,520,335 96% 20,817,324 80,000 100,000 14,820,450 80,000 100,000 59% 100% 100% 15,000,450 59%Total Expenditures 20,997,283 4,519,884Change in Fund Balance (373,200) 6,133,909 117%Beginning Fund Balance 6,507,110 $ 10,653,794 I Beginning Net Working Capital -Requested Budget Ending Fund Balance $ 6,133,909 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) SB 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 (SCMP) grant revenue received in Qtr 1 and was less than planned h) Transfer from Fund 240 for Court Security will be higher than planned j) Higher than antiCipated inmate population Page 5 I LED #2 -Rural 702 Statement of Financial Operating Data 1 i 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 Sheriff's 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 February 28, 2015 (67% of Fiscal Year) Actual I% of Budget 11,387,614 89% 12,751,766 12,907.796 156,030 8,356,633 56% 14,948,526 13,143.929 1,804,597 120,000 100% 120,000 120,000 - 100,000 100% 100,000 100,000 - 8.576,633 57% 15,168,526 13,363,929 1,804,597 2,810,981 (2,416,760) (456,133) 1,960,627 3,074,297 127% 2,416,760 3,074,297 657,537 $ 5,885,278 $ -$2,618,165 $2,618,165 8,027,404 169,889 2,396,129 348,672 56,914 51,661 82,811 81,159 45,250 22,799 22,294 - 19,432 13,636 - 17,030 32,535 97% a) 101 % 82% 67% 34% 40% b) 64% 67% 59% 41% c) 53% d) 0% c) 93% 91% 0% e) nla 47% FY 2015 Budget I Projection I $ Variance 8,272,852 8,422,852 150,000 169,000 169,000 2,920,654 2,920,654 523,010 523,010 169,000 169,000 130,600 108,600 (22,000) 130,000 130,000 121,650 121,650 76,500 76,500 55,000 55,000 42,000 42,000 27,000 27,000 21,000 33,000 12,000 15,000 24,000 9,000 10,000 -(10,000) -17,030 17,030 68,500 68,500 .I Beglnmng Net Working CapItal -Requested Budget $2,536.601 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 Page 6 -- PUBLIC HEALTH Statement of Financial Operating Data July 1,2014 through February 28, 2015 FY 2014 (67% of Fiscal Year) Actual Actual Budget I %of 2,878,140 2,112,943 66% 767,248 708,112 91% 812,441 643,184 98% 400,900 137,658 25% 95,011 476,712 386% 139,171 6,496 2% 232,968 77,569 39% 229,520 34,447 161,576 103,092 69% 100,535 84,215 84% 80,653 31,610 39% 92,637 7,538 11% 36,655 25,065 61% 52,433 12,916 33% 9,077 9,132 152% 38,192 51,356 3424% 10,135 6,137,293 30.720 1097% 4,552,765 71% 6,457.193 4,363.573 64% 2.043.710 1,322.208 60% -20,000 99% 157,320 8,658,223 (2,520,930) 82.320 50% 5,788,101 63% (1,235,336) 2,701,475 1,800,984 67% 33,000 -nla 65,100 2,799,575 278.645 32,550 50% 1,833,534 66% 598.198 1.273.934 $ 1,552,578 1,552.578 99% $ 2,150,776 FY2015 Budget I Projection I$ Variance Revenues State Grant a) 3,202,798 3,330,846 128,048 Environmental Health-Lic Fac b) 779,450 779,450 OMAP 655,250 1,015,358 360,108 550,000 230,000 (320,000)Family Planning Exp Proj a) 123,618 645,557 521,939 Grants (Intergvt, Pvt, & Local) Interfund Grants & Contract 269,678 97,696 (171,982) 196,400 152,462 (43,938)Patient Insurance Fees 21% a)c) 162,352 150,336 (12,016) Federal Payments State Miscellaneous a) 150,335 171,491 21,156 Vital Records-Death 100,000 100,000 80,216 49,150 (31,066)Health Dept/Patient Fees a) 69,291 8.000 (61,291) Vital Records-Birth Contract Payments 41.000 41.000 c) 39,609 30.759 (8,850) Interest on Investments Child Dev & Rehab Center 6.000 13,000 7,000 a) 1.500 52.000 50,500 Miscellaneous Grants & Donations 2.800 31,000 28.200 6,430,297 6,898,105 467,808Total Revenues Expenditures Personnel Services 6.794,032 6,650,491 143,541 d) 2,189,982 2,584,740 (394,758) Capital Outlay Materials and Services 20,200 20,000 200 164.640 164,640 Transfers Out 9,168,854 9,419,871 (251,017)Total Expenditures (2,738,557) (2,521,766) 216,791Revenues less Expenditures 2,701,475 2.701,475 Transfers In-General Fund Transfers In-PH Res Fund - 65,100 65,100 Transfers In-Gen. Fund Other 2,766,575 2,766,575 Total Transfers In 28,018 244,809 216,791Change in Fund Balance 1,570.821 1.552,578 ,18.243}Beginning Fund Balance $ 1,598,839 $ 1,797,387 $ 198,548Ending Fund Balance .I Begmmng Net Workmg Capital -Requested Budget $ 1,789,387 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 FY 2015 Budget I Projection I $ Variance 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, 2014 through February 28, 2015 (67% of Fiscal Year) FY 2014 I %of Actual Actual Budget 8,260,932 7,453,848 7,801,239 5,356,080 469,069 220,270 184,980 95,574 219,846 125,809 246,484 190,317 142,665 73,637 129,788 85,652 127,000 36,412 6,952 - 63,750 - 21,190 22,431 16,000 2,000 6,540 4,495 52,891 734,985 12,918 - 31,820 19,100 120,000 - 28,157 37,378 17,942,221 14,457,987 12,415,866 9,421,943 6,738,744 4,028,705 -- 204,900 102,450 19,359,510 13,553,098 (1,417,289) 904,889 1,377,302 918,200 293,593 125,063 1,670,895 1,043,263 1,948,151253,606 2,671,137 2,924,742 $2,924,742 $4,872,894 I Beginning Net Working Capital -Requested Budget 66% 11,210,767 56% a} 9,589,680 56% 390,000 47% 204,849 62% 201,610 106% 180,300 49% 151,000 61% 140,600 29% 127,000 0% b} 65,000 0% 34,000 115% 19,500 11% 18,800 69% 6,500 n/a c} n/a n/a n/a 703% 5,318 11,210,767 - 7,706,176 (1,883,504) 436,046 46,046 201,879 (2,970) 175,472 (26,138) 200,000 19,700 151,000 - 140,600 - 127,000 - -(65,OOO) -(34,OOO) 31,200 11,700 18,800 - 7,800 1,300 748,081 748,081 -- 19,100 19,100 -- 42,000 36,682 68% 22,344,924 21,215,921 (1,129,003) 61% 15,467,644 14,200,000 1,267,644 45% 8,938,569 7,394,499 1,544,070 0% 100 -100 50% 204,900 216,902 ~12,O02~ 55% 24,611,213 21,811,401 2,799,812 (2,266,289) (595,480) 1,670,809 67% 1,377,302 1,377,302 - 67% 187,594 187,594 - 67% 1,564,896 1,564,896 88% (701,393) 3,313,248 $2,611,855 969,416 2,924,742 $ 3,894,158 1,670,809 ~388,506~ $ 1,282,303 $ 3,893,237 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 Revenues Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Prog Planning-Current Planning-Long Range Total Revenues Expenditures Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Pgm Planning-Current Planning-Long Range Transfers Out (DIS Fund) Total Expenditures Revenues less Expenditures Transfers In/Out In: General Fund -LlR Planning Out: A & T Reserve Out: COO Reserve Funds Net Transfers In/Out Change in Fund Balance Beginning Fund Balance Ending Fund Balance July 1, 2014 through February 28, 2015 FY 2014 (67% of Fiscal Year) I % of Actual Actual Budget 40,102 33,269 65% 2,944 1,275 51% 261,188 193,499 71% 1,748,911 1,302,092 81% 408,194 276,130 66% 264,039 200,490 95% 448,367 274,133 63% 917,674 724,700 80% 440,222 345,711 62% 4,531,641 3,351,300 75% 1,590,779 1,068,542 71% 123,751 81,781 63% 275,521 196,234 66% 688,035 506,274 62% 217,271 152,628 65% 220,779 186,106 66% 181,831 139,176 51% 666,180 485,756 63% 425,323 285,017 49% 179,035 170,698 98% 4,568,505 3,272,214 65% (36,864) 79,086 495,360 111,180 67% (90,360) 100% --0% 495,360 20,820 458,496 99,906 1,578,705 2,037,201 128% $2,037,201 $ 2,137,107 FY 2015 Budget I Projection I $ Variance a) 51,225 42,900 (8,325) 2,500 2,500 273,000 320,000 47,000 1,616,713 1,995,500 378,787 418,506 415,660 (2,846) 211,500 265,000 53,500 437,358 430,300 (7,058) 902,876 1,175,050 272,174 560,658 621,736 61,078 4,474,336 5,268,646 794,310 1,500,181 1,500,181 129,011 129,011 297,852 297,852 b) 822,664 831,759 (9,095) 234,152 238,883 (4,731 ) 281,699 273,435 8,264 c) 274,228 250,879 23,349 d) 766,687 797,081 (30,394) 586,061 625,000 (38,939) 173,673 170,698 2,975 5,066,208 5,114,779 (48,571) (591,872) 153,867 842,881 166,770 166,770 (90,360) (90,360) {687,470} (687,470} (611,060) (611,060) (1,202,932) (457,193) 745,739 1,589,113 2,037,201 448,088 $ 386,181 $1,580,008 $ 1,193,827 I Beginning Net Working Capital -Requested Budget e) $ 947,292 a) Reduction is due to lower than projected rent for tenants 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) FY 2016 Requested Budget was prepared prior to knowing February actual activity. It may be necessary to increase the FY 2016 budget prior to adoption Note: Materials & Services appropriations for items b through d w!ll be increased as necessary Page 9 ROAD Statement of Financial Operating Data July 1, 2014 through February 28, 2015 (67% of Fiscal Year) FY2014 I Ufo ot Actual Actual Budget FY 2015 Budget I PrOjection I $ Variance Revenues Motor Vehicle Revenue 11,300,058 Forest Receipts 1,259,367 Federal-PILT 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 7,766,885 69% a) 11,220,000 11,220,000 373,840 33% b) 1,140,950 373,841 (767,109) 1,250,809 123% c) 1,020,000 1,250,809 230,809 167,195 17% d) 971,700 897,745 (73,955) 83,423 10% e) 804,200 940,212 136,012 602,237 100% 602,629 602,629 208,634 77% 271,000 422,199 151,199 110,091 49% 225,840 210,000 (15,840) 34,980 25% 140,000 206,097 66,097 46,600 146% 32,000 55,000 23,000 32,020 126% 25,500 46,177 20,677 10,676,716 65% 16,453,819 16,224,709 (229,110) 3,692,937 4,137,487 106,554 1,530,257 600,000 66% f) 39% 91% g) 17% h) 100% 5,555,695 10,622,604 117,000 8,875,507 600,000 5,584,404 9,385,240 106,554 2,459,464 600,000 (28,709) 1,237,364 10,446 6,416,043 10,067,235 39% 25,770,806 18,135,662 7,635,144 609,481 (9,316,987) (1,910,953) 7,406,034 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 6% 2,299,156 1,310,561 (988,595) 758,559 (7,017,831 ) (600,392) 6,417,439 10,022,703 112% 8,954,332 10,022,703 1,068,371 $10,781,261 $ 1,936,501 $9,422,311 $7,485,810 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 FY 2014 Actual Revenues SB 1145 3,028,672 DOC Measure 57 220,788 Electronic Monitoring Fee 235,642 Probation Superv. Fees 208,461 Interfund -Sheriff 50,000 Crime Prevention Grant 50,000 CFC-Domestic Violence 70,242 State Subsidy 14,677 Alternate Incarceration 17,725 Interest on Investments 7,807 Probation Work Crew Fees 9,137 State Miscellaneous 4,142 Leases 1,323 Claims Reimbursement 6,997 Justice Reinvest HB3194 458,143 Miscellaneous 671 Total Revenues 4,384,428 Expenditures Personnel Services 3,343,789 Materials and Services 1,107,365 Capital Outlay - Total Expenditures 4,451,154 Revenues less Expenditures (66,726) Transfers In-General Fund 451,189 Change in Fund Balance 384,463 Beginning Fund Balance 747,520 Ending Fund Balance $ 1,131,982 July 1, 2014 through February 28, 2015 (67% of Fiscal Year) I % of Actual Budget FY 2015 Budget I Projection I $ Variance 2,268,987 217,845 135,652 132,251 33,336 12,500 29,244 11,220 15,509 6,019 6,978 - - - - 835 75% 99% a) 62% 70% 67% 25% b) 61% b) 74% 103% c) 98% 141% d) 0% e) 0% nfa nfa 167% 3,025,187 220,788 220,000 190,000 50,000 50,000 47,996 15,158 15,000 6,150 4,950 4,301 1,500 - - 500 3,025,187 217,845 204,000 198,000 50,000 50,000 47,996 15,158 20,000 6,150 7,500 4,141 1,500 - - 900 - (2,943) (16,000) 8,000 - - - - 5,000 - 2,550 (160) - - - 2,870,376 75% 3,851,530 3,848,377 (3,153) 2,369,457 65% 3,623,526 3,623,526 - 650,879 57% 1,148,766 1,148,766 - -0% 100 -100 3,020,337 63% 4,772,392 4,772,292 100 (149,961) (920,862) (923,915) (3,053) 300,792 67% 451,189 451,189 - 150,831 (469,673) (472,726) (3,053) 1,131,982 110% 1,030,824 1,131,982 101,158 $ 1,282,814 $ 561,151 $ 659,256 $ 98,105 I Begmmng Net Workmg Capital -Requested Budget $ 662,516 a) Annual payment received in July b) Interfund grants. Received when invoiced. Still waiting for response on Crime Prevention Grant c) Invoiced quarterly. Greater utilization d) One time payment from back-owing offender e) Annual payment will be received in March Page 11 400 EARLY LEARNING HUB Statement of Financial Operating Data July 1, 2014 through FY 2014 February 28, 2015 Note 1 (67% of Fiscal Year) Actual Ac FY 2015 Projection $ Variance Revenues Federal Grants 258,463 119,425 51% 232,218 232,125 (93) Title IV -Family Sup/Pres 21,994 0% a) 21,994 (21,994) HealthyStart Medicaid 60,561 41,421 69% 60,000 60,000 Youth Investment 124,493 nfa nfa HealthyStart /R-S-G 249,125 State Grant 55,185 146,035 49% a) 295,190 292,086 (3,104) OCCF Grant 132,326 0% a) 39,499 37,500 (1,999) Charges for Svcs-Misc 4,138 nfa Program Fees 4,710 nfa Miscellaneous 4,074 204% 2,000 2,000 Court Fines & Fees 77,873 51,391 67% 77,086 77,086 Interest on Investments 2,868 1,613 65% 2,500 2,500 Donations 50 nfa Private Grant 130 nfa Sale of Assets 450 nfa Interfund Grants 329,624 7,260 100% 7,260 7,260 371,218 50% 737,747 710,557 (27,190)Total Revenues 1,321,991 Expenditures 171,857 67% 258,410 258,410 Materials and Services 1,402,021 Personnel Services 501,770 463,733 53% b) 877,110 854,347 22,763 635,590 56% 1,135,520 1,112,757 22,763Total Expenditures 1,903,791 (264,372) (397,773) (402,200) (4,427) Transfers In Revenues less Expenditures (581,800) 168,192 67% 252,288 252,288 General Fund -Other 89,350 General Fund 278,739 44,675 50% 89,350 89,350 212,867 62% 341,638 341,638Total Transfers In 368,089 (51,505) (56,135) (60,562) (4,427)Change in Fund Balance (213,711) 334,861 105% 318,121 334,861 16,740Beginning Fund Balance 548,572 $ 283,357 $ 261,986 $ 274,299 $ 12,313 I Beginning Net Working Capital -Requested Budget i 274,299 Ending Fund Balance $ 334,861 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 February 28, 2015 (67% of Fiscal Year) FY 2015 FY 2014 I %of Budget l Projection I $ VarianceActual BudgetActual Operating Revenues Franchise Disposal Fees 4,209,029 Private Disposal Fees 1,518,056 Commercial Disp. Fees 1,076,538 Franchise 3% Fees 210,053 Yard Debris 98,410 Recyclables 33,345 Special Waste 40,873 Interest 11,028 Leases 10,801 Miscellaneous 21,508 Total Operating Revenues 7,229,641 Operating Expenditures Personnel Services 1,777,663 Materials and Services 3,214,375 Debt Service 930,157 Capital Outlay 25,895 Total Operating Expenditures 5,948,091 Operating Rev less Exp 1,281,550 Transfers Out Road 282,148 SW Capital & Equipment Reserve 545,000 Total Transfers Out 827,148 Change in Fund Balance 454,402 Beginning Fund Balance 1,224,767 Ending Fund Balance $ 1,679,169 3,083,256 70% 4,413,809 4,600,000 186,191 1,047,836 68% 1,550,430 1,570,000 19,570 847,533 78% 1,082,144 1,200,000 117,856 91,844 44% a) 210,000 220,000 10,000 74,328 81% 92,000 104,000 12,000 23,401 52% b) 45,000 45,000 16,150 65% 25,000 25,000 11,281 113% 10,000 15,000 5,000 7,201 67% 10,801 10,801 17,848 89% 20,000 25,000 5,000 5,220,678 70% c) 7,459,184 7,814,801 355,617 1,235,230 64% 1,936,555 1,887,195 49,360 1,894,332 55% 3,435,926 3,283,101 152,825 381,624 41% d) 929,794 929,794 92,717 41% 227,000 224,523 2,477 3,603,903 55% 6,529,275 6,324,613 204,662 1,616,775 929,909 1,490,188 560,279 149,078 50% e) 298,156 298,156 - 1,250,000 82% f) 1,525,000 2,225,000 {700,OOOl 1,399,078 77% 1,823,156 2.523,156 {700,OOO} 217,697 (893,247) (1,032,968) (139,721) 1,679,169 118% 1,428,003 1,679,169 251,166 $1,896,866 $ 534.756 $ 646,201 $ 111,445 .I Beginnmg Net Working Capital -Requested Budget $ 646,922 a) Payments due April 15th b) Recycling market prices are low and unpredictable at this time 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 • • I j RISK MANAGEMENT Statement of Financial Operating Oata FY2014 July 1, 2014 through February 28,2015 (67% of Fiscal Year) Actual Actual 1% of Budget 272,823 253,192 67% 326,526 261,536 67% 164,150 118,368 67% 1,520,352 1,041,160 67% 318,566 214.672 68% 139,123 31,274 156% 1,400 845 65% 14 -0% 27,540 24,120 101% 15,567 2,786,061 14,694 98% 1,959,861 68% 268,561 44,478 49,872 5,758 33,139 13.441 161,994 165,361 4,659 11,508 5,619 64 4,531 528,374 166,668 211,158 377,826 875 4,974 245,584 61% 178,556 19,980 198,536 79% 236 205 21,300 22,021 11,900 69,276 92,377 478,204 37,535 70,971 59% 551,455 5,000 5,000 155,474 114,968 44,261 35,180 52,488 735,427 102,324 1,836,329 324,005 146,109 2,306,443 479,618 2,631,057 $3,110,676 26,861 733,464 122% 66,857 33% 1,315,411 84% 201,181 61% 87.951 44% 1,604,542 76% 355.319 3,110,676 101% $3,465,995 b) c) FY 2015 Budget I Projection I $ Variance Revenues Inter-fund Charges: General Uability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Gen Uab/Property Process Fee-Events/Parades. Miscellaneous Skid car Training Interest on Investments TOTAL REVENUES Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Miscellaneous Repair / Replacement Total General Liability PROPERTY DAMAGE Insurance Repair I Replacement Total Property Oamage VEHICLE Professional Service Insurance Loss Prevention Repair / Replacement Total Vehicle WORKERS' COMPENSATION Settlement I Benefit Professional Service Insurance Loss Prevention Miscellaneous Total Workers' Compensation UNEMPLOYMENT -Settlement/Benefits Total Direct Insurance Costs Insurance Administration: Personnel Services Materials & Srvc, Capital Out. & Tranfs. Total Expenditures Change in Fund Balance Beginning Fund Balance Ending Fund Balance , ,I Begmnlng Net Working CapItal· Requested Budget a) a) a) 379,793 379,793 392,304 392,304 177.550 177,550 1,561,804 1,561,804 317,000 317,000 20,000 40,000 20,000 1,300 1,300 110 110 24,000 27,000 3.000 15,050 15,500 450 2,888,911 2,912,361 23,450 400,000 500,000 (100,000~ 250,000 250,000 120,000 110,000 10,000 600,000 900,000 (300,OOO~ 200,000 120.000 80,000 1,570,000 1,880,000 {310,OOO) 330,406 330,406 199,140 199,140 2,099,546 2,409,546 {310,000} 789.365 502,815 (286,550) 3,074,957 3,110,676 35,719 $ 3,864,322 $ 3,613,491 $ (25O,831~ $ 3,200,000 • a) Annual premiums paid in July b) Payments made quarterly Page 14c) Appropriation for Materials & Services will be increased when required - - DESCHUTES COUNTY 9-1-1 Statement of Financial Operating Data July 1, 2014 through February 28, 2015 (67% of Fiscal Year) FY 2014 I %of Actual BudgetActual Revenues Property Taxes -Current 6,258,760 6,371,687 98% a) Property Taxes -Prior 203,163 130,570 95% Federal Grants 46,514 -0% b)e) State Reim bursement 41,813 26,367 73% Telephone User Tax 756,775 379,737 51% c) Data Network Reimb. 43,943 -0% d) Jefferson County 29,758 27,898 93% User Fee 53,229 50,223 112% d) Police RMS User Fees 236,717 24,095 8% d) Contract Payments 39,075 -0% d) Miscellaneous 45,553 11,979 133% Claims Reimbursement 29,857 -nfa Interest 40,303 21,605 71% FY 2015 Budget I Projection I $ Variance Total Revenues 7,825,460 7,044,161 88% Expenditures Personnel Services Materials and Services Capital Outlay 4,420,333 1,996,805 66,498 3,138,226 1,340,397 234,798 56% 65% 67% e) 6,482,015 138,000 150,000 36,000 750,000 30,000 30,000 45,000 295,788 11,000 9,000 - 30,600 8,007,403 5,634,438 2,077,868 350,000 6,682,015 200,000 138,000 50,000 (100,000) 36,000 750,000 30,000 30,000 53,000 8,000 295,788 11,000 13,000 4,000 30,600 - 8,119,403 112,000 5,016,373 618,065 2,077,868 - 250,000 100,000 Total Expenditures 6,483,636 4,713,422 58% 8,062,306 7,344,241 718,065 Revenues less Expenditures 1,341,824 2,330,740 (54,903) 775,162 830,065 Transfers Out -Reserve Fund 7,800,000 - Change in Fund Balance (6,458,176) 2,330,740 Beginning Fund Balance 10,398,030 3,939,854 Ending Fund Balance $ 3,939,854 $ 6,270,594 .I Beginning Net Working Capital -Requested Budget nfa 116% $ - (54,903) 3,410,000 3,355,097 - 775,162 3,939,854 $4,715,016 $4,650,000 - 830.065 529,854 $1,359,919 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 -awaiting payments e) $100,000 of the budgeted CAD to CAD is a pass through between ODOT and Hood River County. Neither the revenue nor the expenditure will be reported as DC 9-1-1 FY 2015 activity Page 15 Health Benefits Trust Statement of Financial Operating Data Revenues: Internal Premium Charges Part-Time Employee Premium Employee Monthly Co-Pay calc Retiree I COBRA Co-Pay Prescription Rebates Claims Reimbursements &Misc Interest Total Revenues Expenditures: Personnel Services (all depts) Materials & Services Admin &Wellness 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 -Wenness Admin & Wellness Deschutes On-site Clinic Contracted Services Medical Supplies Other Total DOC Deschutes On-site Pharmacy Contracted Services Prescriptions Other Total Pharmacy Total Expenditures Change in Fund Balance Beginning Fund Balance Ending Fund Balance $ $ FY 2014 July 1, 2014 Actual through February %of 28,2015 (67% of Budget Fiscal Year) 14,485,502 $ 10,661,194 69% a) 16,955 11,538 58% b) 813,125 576,786 71% b) 1,595,847 1,228,359 74% b) 1,061,986 725,570 58% b) 154,981 110,814 101% 2,419 306 1% 67,057 57,185 79% 18,197,871 13,371,752 69% 129,509 81,767 56% 11,633,134 8,125,124 65% c) 657,550 856,880 121% c) 1,731,608 1,232,220 66% c) (182,448) (276,619) n/a 275,052 215,499 54% 67,753 227,597 106% 333,188 273,819 80% 49,712 26,159 46% 42,969 28,811 65% 117,775 106,566 54% 14,726,294 10,816,056 66% 850,209 504,041 53% 54,806 37,317 107% 27,016 14,038 23% 932,031 555,397 53% 314,801 145,565 48% 1,588,726 755,545 45% d) 13,250 8,874 67% 1,916,777 909,984 45% 17,704,610 12,363,203 63% 493,261 1,008,548 11,967,822 12,461,082 108% 12,461,082 $ 13,469,630 FY 2015 FY2015 FY2015 Budget Projection $15,517,000 $15,993,270 20,000 17,307 810,000 865,179 1,670,000 1,842,539 1,260,000 1,088,355 110,000 110,814 50,000 306 72.000 85,000 19,509,000 20,002,769 144,917 144,917 12,552,108 12,060,413 709,494 1,156,920 1,868,398 1,822,495 -(276,619) 400,000 350,000 215,000 227,597 343,000 410,000 57,200 40,000 44,842 44,642 195,970 195,970 16,385,812 16,031,418 943,500 943,500 35,000 70,000 61,777 50,000 1,040,277 1,063,500 306,000 306,000 1,696,000 1,511,089 13,321 13,321 2,015,321 1,830,410 19,586,327 19,070,245 (77,327) 932,524 11,585,710 12,461,082 $11,508,383 $13,393,606 $ Variance $ 476,270 (2,693) 55,179 172,539 (171,645) 814 (49,694) 13,000 493,769 - 491,694 (447,426) 45,904 276,619 50,000 (12,597) (67,000) 17,200 - - 354,394 - (35,000) 11,777 (23,223) 184,911 - 184,911 516,082 1,009,851 875,372 $1,885,223 I % of Exp covered by Revenues 102.8% 108.2% 99.6% 104.9%1 I Beginning Net Working Capital. Requested Budget $13,190,000 a) Projection is amount budgeted as HealthlDentallnsurance expenditures in the operating funds b) Year to Date annualized c) Average of YTD annualized and 12 month rolling average Page 16 d) YTD Actual-July through December. Projection is YTD Annualized 75 FAIR AND EXPO CENTER Statement of Financial Operating Data Through February 28, 2015 Operating Revenues Events Revenues Storage Camping at F & E Horse Stall Rental Concession % -Food Annual County Fair (net) Miscellaneous Total Operating Revenues Operating Expenditures: General F & E Activities Personnel Services i),~:~~'HA\_~~ir:;c';i;'s(_ Materials and Services $ FY 2015 -Year to Date (67% FY 2014 of Year $ 45.4% 48.0% 14.3% 122.0% 120.7% 58.9% 895,582 610,462 65.9% 71.8% 68.0% Budget $ 926,183 FY 2015 $ 890,462 $ $ Variance (104,137) 5,587 44,000 2,436 (67,363) 35,721 508,386 562,264 (53,878) 1,434,569 1,368,338 66,231 Non-Operating Revenues Transfer-General Fund 374,186 243,336 Park Acq/Dev (Fund 130) Transfer-Room Tax -(Fund 160) Transfer-Fair & Expo Reserve Interest Grants Rights & Signage 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 262,900 100,000 409 176,289 72,000 985,784 74,586 336 280 94,938 413,476 112,974 176,289 289,263 68,281 68,281 14,980 (14,980) 39,102 39,102 $ 6,328 (6,673) (345) $ (26,515) (345) (26,860) 66.7% 68.7% n/a n/a n/a 118.7% 74.7% 60.8% 0.0% 60.8% 13.4% 13.5% -0.4% e) 365,000 108,544 365,000 29,000 110,770 29,000 2,226 80,000 336 280 113,938 336 280 33,938 553,544 619,324 65,780 112,213 112,213 100 100 112,313 112,213 100 292,333 288,850 (3,483) 288,850 288,850 3,483 {3,4831 $ 36,056 87,000 123,056 $ 97,321 {345} 96,976 $ 61,265 {87,345~ (26,0811 I §eglnnlng Rwe per J!V ~ln~ ~equestea i!luaget I ~Do,DDD I 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 d) :P~:~dKutes'~Jl';hlE:Wfil~foeMtltRV~fI(~;:'\~ e) Budgeted transfer from Fund 130 for Fund 601 will be transferred to Fund 618 instead for Center Circle Park. Page 17 --------~--~ Deschutes County Food and Beverage Activities September 1, 2014 through February 28, 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 FY2014 September October November December January February Year to Date Percentage of Revenues $ 17,350 - 1,048 - 1,048 - 2,334 3,382 13,968 8,520 1,895 10,415 $ 3,554 $ 13,390 $ 12,678 - 19,302 (17,899) 1,403 - 2,651 4,054 8,625 8,742 244 8,986 $ (361) $ 2,236 $ 29,005 17,899 7,538 (17,773) 7,664 225 4,803 12,693 16,312 8,742 277 9,019 $ 7,293 $ 21,992 $ 4,683 17,773 1,350 P8,199) 924 948 1,203 3,075 1,608 8,742 1,121 9,863 $ (8,255) $ 2,340 $ 33,550 18,199 7,521 (16,755) 8,965 142 5,784 14,890 18,659 8,742 (482) 8,260 $ 10,400 $ 7,202 $ 33,907 16,755 8,304 (18,536) 6,524 704 3,462 10,690 23,217 8,742 482 9,224 $ 13,993 $ 8,202 131,173.17 - 45,062.49 {18,535.65) 26,526.84 2,018.96 20,237.47 48,783.27 82,389.90 52,229.45 3,537.15 55,766.60 26,623.30 55,362.52 20.2% 1.5% 15.4% 37.2% 62.8% Page 18 JUSTICE COURT Statement of Financial Operating Data FY 2014 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 February 28, 2015 (67% of Fiscal Year) I % of Actual Budget FY 2015 Budget I Projection I $ Variance 232,287 52% a) 450,000 443,838 (6,162) -0% 600 600 - 335 41% 815 815 - 232,622 52% 451,415 445,253 (6,162) 284,678 106,673 68% 64% b) 416,045 166,093 416,045 140,177 - 25,916 391,351 67% 582,138 556,222 25,916 (158,729) (130,723) (110,969) 19,754 49,600 67% 74,398 74,398 (109,129) (56,325) (36,571 ) 19,754 130,317 121% 107,621 130,317 22,696 $ 21,189 $ 51,296 $ 93,746 $ 42,450 .I Beginning Net Workmg Capital -Requested Budget 93,800 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 February 28, 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 10,020 300 10,320 Total Resources 1,676,637 300 1,676,937 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/Haslinger Court JB4 401,231 401,231 1st Floor DeHoog/Bagley 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 400,464 282,787 683,251 "Stone Building" 720 720 Internal Service Fund Charges 7,477 7,477 Total Materials & Services 1,394,150 282,787 1,676,937 Revenues less Expenditures $ 282,487 $ {282,487) Notes: A. Remaining proceeds from the FF&C borrowing for the OSP/911 Building. Completed Projects JRF 31212015 Deschutes County North County Services Building Inception through February 28, 2015 Projected RESOURCES: Rental Expended from Fund 142 for Design Center Transfers in: Fund 140 for Unger Remodel Fund 142 ( FY 2012) Fund 140 for Antler Building (P & I) Interest Revenue Total Resources EXPENDITURES: Design Center -Hwy 97 Land & Building Architecture/Design Utilities Fees, Permits & SDCs Other Total Design Center Antler Building Land & Building Building Improvements Personal Property Interest Other Total Antler Building Unger Building Remodel Remodel Construction-Griffen Constr. Architecture/Design Relocation Costs Fees & Permits Utilities Furniture, Fixtures & Equipment Other Total Unger Building Remodel Other Internal Service Fund Charges Evergreen School 500 1,427,013 152,461 600,000 151,736 9,323 $ 2,341,033 1,402,013 47,092 25,610 323 4,142 1,479,179 601,200 42,364 27,016 2,827 928 674,334 11,477 45,561 17,979 620 1,386 6,404 13,961 97,388 33,102 3,803 613,558 $ 613,558 1,000 1,000 572,995 19,000 9,200 19,380 1,614 43,596 665,785 500 1,427,013 a) 500 1,427,013 766,019 600,000 151,736 9,323 $ 2,954,591 b) 766,019 600,000 151,736 9,323 $2,954,591 1,402,013 47,092 26,610 323 4,142 1,480,179 1,402,013 47,092 26,610 323 4,142 1,480,179 601,200 42,364 27,016 2,827 928 674,334 601,200 42,364 27,016 2,827 928 674,334 584,472 64,561 27,179 20,000 3,000 50,000 13,961 763,173 584,472 64,561 27,179 20,000 3,000 50,000 13,961 763,173 33,102 3,803 33,102 3,803 Total Expenditures 2,287,807 666,785 2,954,591 2,954,591 Net $ 53,227 $ (53,227) 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.