HomeMy WebLinkAboutFinance-Tax UpdateMonthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA August 29,2012 (1) Monthly Investment Report (2) July 2012 Financials (3) FY 2011-2012 Preliminary Financial Reports (4) Year End Working Capital ---- - - --------------------~ i Investments By County Function General $ 109,03.9,115 Commercial Paper $ 0.00% Corporate Notes 12,963,439 11 .•9% Time Certificates 9,250,175 '.48% I Total Investments $ 109,039,115 Federal Agencies 7,990,330 7.33% U. S. Treasuries 0.00% I Total Investment Income Bankers' Acceptances 0.00% I. Less Fee: 5% of Invest. Income LGI P/BOTC/UMPQUA ~ 1 Total Portfolio: By Investment Types Corporate Notes Time 12% Certificates 9% Federal Agencies 7% LGIPI BOTCI UMPQUA 72% Investment Income Fllcal Year 2012-13 Jul-12 LI Y-T-O $ 61,656 $ 61,656 -- 81,656 61,656 (3,083) (3,083) I Investment Incom.e -Net .$ 58,573 $ 58,573 Category Maximums: .U.S. Treasuries 100% '­I'LGIP 100% ""lFederal Agencies 75% Banker's Acceptances 25% I,Time Certificates 25% Commercial Paper 20% CO!Q9rate Notes 10·" Comparators 3 Month Trcas. • 0.11 % 12 Montll Treas. ~ 0 .16 '1u 3MonthCP • 0.18% Average Maturity in Days General ---640 Memorandum Date: August 22, 2012 To: Board of County Commissioners Erik Kropp, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find July 2012 financial reports for the following funds: General (001), Community Justice -Juvenile (230), Sheriff's (255, 701, 702), Public Health (259)' Behavioral Health (275), Community Development (295), Road (325), Community Justice -Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670)' 9-1-1 (705)' Health Benefits Trust (675)' and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERAL FUND Statement of Financial Operating Data One Month Ended July 31, 2012 Vearlo Date Budget I Actual I Variance IFY % I Coli. % RESOURCES: 8eg. NetWorking Capital $ 8,700,000 $9,050,168 $ 350,168 100% 104% $ 8,700,000 $ 9,050,168 $ 350,168 Revenues Current & Prior Taxes 1,739,763 186,431 (1,553,332) 8% 1% a) 20,877,160 20,877,160 Gen. Rev.· excl. Taxes 198,478 739.067 540.589 8% 31% b) 2,381,731 2,381,731 Assessor 62,386 202.220 139,834 8% 27% c) 748,626 748,626 County Clerk 115,002 124,494 9,492 8% 9% 1,380.023 1,380,023 BOPTA 1,033 4,117 3,084 8% 33% c) 12,398 12,398 District Attorney 15.391 1,370 (14,021) 8% 1% 184,694 184,694 FinancelTax 16,575 51,054 34,479 8% 26% c) 198,900 198,900 Veterans 5,700 75 (5,625) 8% 0% 68,400 68,400 Property Management 8,270 7,854 (416) 8% 8% 99,244 99,244 Grant Projects 167 167 8% 8% 2.000 2,000 Total Revenues 2,162,765 1,316,849 (845,916) 8% 5% 25.953.176 25,953,176 FY2013 Year End $ Budget Projection Variance TOTAL RESOURCES 10,862,765 10,367.017 (495,748) 8% 30% 34.653,176 35,003,344 350.168 REQUIREMENTS: I Exp. %1 Expenditures Assessor 295,102 263,295 31,807 8% 7% 3,541,227 3,541,227 County Clerk 122,303 87,527 34,776 8% 6% 1,467,638 1,467,638 BOPTA 6,032 3,793 2,239 8% 5% 72,385 72,385 District Attorney 439,556 409.580 29.976 8% 8% 5.274.667 5.274.667 FinancelTax 69,489 48.595 20.894 8% 6% 833,865 833.865 Veterans 21.749 16.957 4.792 8% 6% 260.992 260.992 Property Management 22.669 21.360 1,309 8% 8% 272,027 272,027 Grant Projects 10,196 9,754 442 8% 8% 122,349 122,349 Non-Departmental 132,056 82.257 49.799 8% 5% d) 1,584,671 1.584,671 Contingency 680,559 680.559 8% n/a 8,166.703 81166,703 1,799,711 943,118 856.593 8% 4% 21,596,524 13,429,821 8,166,703 Transfers Out 11088.054 1,087,548 506 8% 8% 13,056,652 13,056,652 TOTAL REQUIREMENTS NET (Resources -Requirements) 2,887,765 7,975,001 2,030,_ 8,336,351 857,099 361,351 8% 60/. 34,653,176 26,486,473 8,516,871 81166,703 8,516,871 a) Current year taxes not due until November b) Includes annual payments: PILT $730.983 c) A & T Grant received quarterly-July. October, January & April. d) Budget includes $576,736 payment to LED#2. Will not be expended until June 2013. Page 1 COMM JUSTICE..JUVENILE Statement of Financial Operating Data One Month Ended July 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1 06S-Court Assess. Discovery Fee Food Subsidy OY A Basic & Diversion Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous Program Fees MIP Diversion Fees Interest on Investments Leases Grants -Private CFC Interfund Grant Interfund Grant -Gen Fund Year to Date Budget I Actual I Variance IFY% LColi. % $1,010,415 500 4,167 1,083 1,750 31,279 5,000 8 10,167 17 4 83 667 100 42 10,472 1,667 $ 995,051 $ (15,364) (500) 1,343 (2,824) 770 (313) (1,750) (31,279) 5,520 520 (8) (10,167) (17) (4) 150 67 581 (86) 100 143 101 (10,472) p,667~ 100% 98% 8% 0% 8% 3% 8% 6% 8% 0% 8% 0% a) 8% 9% 8% 0% 8% 0% b) 8% 0% 8% 0% 8% 15% 8% 7% 8% 8% 8% 29% 8% 0% c) 8% 0% c) FY 2013 Year End Budget Projection Variance $1,010,415 $ 995,051 $ (15,364) 6,000 6,000 50,000 50,000 13,000 13,000 21,000 21,000 375,347 375,347 60,000 60,000 100 100 122,000 122,000 200 200 50 50 1,000 1,000 8,000 8,000 1,200 1,200 500 500 125,661 125,661 20,000 20,000 Total Revenues 67,006 8,607 (58,399) 8% 1% 804,058 804,058 Transfers In-General Fund 445,378 445,377 ~11 8% 8% 5,344,523 5,344,523 TOTAL RESOURCES 1,522,799 1,449,035 (73,764) 8% 20% 7,158,996 7,143,632 (15,364) REQUIREMENTS: I Exp. %1 Expenditures Community Justice-Juvenile Personal Services 422,918 427,565 (4,647) 8% 8% 5,075,017 5,075,017 Materials and Services 99,497 70,604 28,893 8% 6% 1,193,960 1,193,960 Capital Outlay 8 8 8% 0% 100 100 Transfers Out 4,200 4,200 8% 0% 50,400 50,400 Contingency 69,960 69,960 8% n/a 839,519 839,519 TOTAL REQUIREMENTS 596,583 498,169 98,414 8% 7% 7,158,996 6,319,477 839,519 NET (Resources -Requirements) 926,216 950,866 24,650 824,155 824,155 a) Payments received quarterly b) Contract payment reimbursement requests submitted monthly, receive 1-2 months in arrears c) Grants received quarterly Page 2 SHERIFF -Fund 255 Statement of Financial Operating Data One Month Ended July 31, 2012 RESOURCES: Year to Date Actual Variance FY 2013 Year End IBudQet Projection Variance Beg. Net Working Capital $ $ $ 100% n/a $ $ $ ..8% 7% ..8% 8% Total Revenues 3,083,610 2,706,883 (316,727) 8% 7% 37,003,318 31,432,623 (5,570,695) TOTAL RESOURCES 3,083,610 2,706,883 (376,727) 8% 7% 37,003,318 31,432,623 (5,570,695) REQUIREMENTS: Exp. %1 EXPENDITURES & TRANSFERS Sheriff's Division 188,636 222,271 (33,635) 8% 10% 2,263,630 2,263,530 100 Civil 66,582 52,068 14,514 8% 7% 798,989 798,889 100 Automotive/Communications 137,088 398,598 (261,510) 8% 24% 1,645,050 1,800,050 (155,000) Investigations/Evidence 125,682 134,574 (8,892) 8% 9% 1,508,180 1,508,080 100 Patrol/CivillComm Supp 689,113 653,509 35,604 8% 8% 8,269,358 8,269,358 Records 59,801 47,276 12,525 8% 7% 717,617 717,517 100 Adult Jail 861,839 738,556 123,283 8% 7% 10,342,072 10,342,072 Court Security 25,250 23,545 1,705 8% 8% 303,001 302,901 100 Emergency Services 16,211 16,063 148 8% 8% 194,533 194,433 100 Special Services Division 111,609 141,852 (30,243) 8% 11% 1,339,308 1,339,308 Regional Work Center 221,923 189,016 32,907 8% 7% 2,663,078 2,662,978 100 Training Division 42,079 29,339 12,740 8% 6% 504,950 504,850 100 Other Law Enforcement Svcs 53,625 53,111 514 8% 8% 643,504 643,404 100 Non-Departmental 7,104 7,104 8% 8% 85,253 85,253 Contingency 477,066 477,066 8% n/a 5,724,795 5,724,795 TOTAL REQUIREMENTS 3,083,608 2,706,882 376,726 8% 7% 37,003,318 31,432,623 5,570,695 NET (Resources -Requirements) .. Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data One Month Ended July 31,2012 Year to Date Actual Variance Variance RESOURCES: Beg. Net Working Capital $4,507,352 $ 5,863,246 $ 1,355,894 100% 130% $ 4,507,352 $5,863,246 $ 1,355,894 Tax Revenues -Current 1,282 ,145 (1 ,282,145) 8% 0% a) 15,385 ,740 15,385,740 Tax Revenues -Prior 36,667 137,505 100 ,838 8% 31% 440,000 440,000 Federal Grants & Reimb 2,500 (2 ,500) 8% 0% 30,000 30,000 State Grant 6,167 (6 ,1 67) 8% 0% 74 ,000 74 ,000 Transp . of State Wards 4 17 (417) 8% 0% 5,000 5,000 SB 1145 123 ,333 (123 ,333) 8% 0% 1,479,991 1,479,991 Prisoner Housing 4,167 (4 ,167) 8% 0% 50,000 50,000 Des . Cty Video Lottery Grant 417 (417) 8% 0% 5,000 5,000 Des Cly Court Security 20 ,083 20 ,009 (74) 8% 8% 241 ,000 24 1,000 Des Cly Juvenile Contract 348 (348) 8% 0% 4 ,180 4,180 Transport 42 (42) 8% 0% 500 500 Other 292 6,500 6 ,208 8% 186% 3,500 6,500 3,000 DC Fair & Expo Center 333 (333) 8% 0% 4 ,000 4 ,000 Inmate Commissary Fees 833 (833) 8% 0% 10 ,000 10,000 Work Center Work Crews 4,167 268 (3,899) 8% 1% 50,000 50,000 Concealed Handgun Classes 292 850 558 8% 24 % 3,500 3 ,500 Inmate Te lephone Fee 6,667 (6,667) 8% 0% 80 ,000 80,000 Soc Sec Incent ive-Fed 417 (417) 8% 0% 5,000 5 ,000 Miscellaneous 417 744 327 8% 15 % 5,000 5,000 Oregon Mentors 83 (83) 8% 0% 1,000 1,000 Debit Card Fee 8 39 31 8% 39% 100 100 Medical Services Reimb 1,083 (1,083) 8% 0% 13,000 13,000 Restitution 417 (417) 8% 0% 5,000 5,000 Sheriff Fees 20 ,833 21,587 754 8% 9% 250,000 250,000 Interest 2,361 3 ,183 822 8% 11 % 28,333 28 ,333 Interest on Unsegregated 294 31 (263) 8% 1% 3,533 3,533 Donations -"Shop with a Cop" 4,325 11,288 6,963 8% 22% 51,897 51,897 Sale of Reportab le Assets 417 !417) 8% 0% 5 ,000 5,000 Total Revenues 1,519,525 202,004 p,317,521 l 8% 1% 18,234,274 18,237,274 3,000 TOTAL RESOURCES 6,026,877 6,065,250 38,373 8% 27% 22,741,626 24,100,520 1,358,894 REQUIREMENTS: I Exp . %1 Fund 255 Departments : Sheriffs Services 176 ,105 207 ,506 (31,401 ) 8% 10% 2 ,113,257 2,113,164 93 Civil 66 ,582 52,068 14 ,514 8% 7% 798,989 798,889 100 AutofComm 50,551 146,983 (96,432) 8% 24% 606,612 663 ,768 (57 ,156) Adult Jail 861 ,839 738,556 123,283 8% 7% 10 ,342,072 10,342 ,072 Court Security 25 ,250 23,545 1,705 8% 8% 303,001 302 ,901 100 Emergency Services 16,211 16,063 148 8% 8% 194,533 194,433 100 SpeCial Services 77 ,227 98,153 (20 ,926) 8% 11% 926,721 926,721 Work Center 221,923 189,016 32,907 8% 7% 2,663 ,078 2,662,978 100 Training 25 ,723 17,935 7 ,788 8% 6% 308 ,676 308,615 61 Other (CODE, Forensic) 53,625 53,111 514 8% 8% 643 ,504 643,404 100 Non Dept -ISF Charges 3,559 3,559 0 8% 8% 42,712 42,712 Contingency 301,539 301,539 8% nfa 3 ,618,471 3,618,471 Total to Fund 255 1,880,136 1,546,495 333,641 22,561,626 18,999,656 3,561,970 Transfer to Reserve Fund (703) 8,333 8,333 8% 0% 100 ,000 100,000 Non Dept -Comm System Res 6,667 6 ,667 8% 0% 80,000 80,000 Total Requirements 1,895,136 1,546,495 348,640 8% 7% 22 ,741,626 19,179,656 3 ,561 ,970 Net 4,131 ,742 4.518,755 387,013 4,920 ,863 4,920 ,863 a) Current year taxes not due until November • Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services . Page 4 Fund 702 LED Rural Statement of Financial Operating Data One Month Ended July 31,2012 RESOURCES: Beg. Net Working Capital $2,859,915 $3,240,358 $ 380,443 100% 113% $2,859,915 $3,240,358 $ 380,443 Revenues Tax Revenues -Current 629,167 (629,167) 8% 0% a) 7,550,000 7,550,000 Tax Revenues -Prior 19,167 67,555 48,388 8% 29% 230,000 230,000 Federal Grants & Reimb 1,250 (1,250) 8% 0% 15 ,000 15,000 Federal Grants-BlM 2 ,1 67 (2,167) 8% 0% 26,000 26,000 US Forest Service 6 ,250 (6,250) 8% 0% 75,000 75,000 Bureau of Reclamation 2,167 (2,167) 8% 0% 26,000 26,000 State Grant 15,766 (15,766) 8% 0% 189,194 189,194 SB #1065 Court Assessment 4,583 1,343 (3,240) 8% 2% 55 ,000 55,000 Marine Board License Fee 11,841 (11,841) 8% 0% 142,091 142,091 Des Cty General Fund Grant 48,061 (48,061 ) 8% 0% 576,735 576,735 Des Cly Transient Room Tax 172,772 (172,772) 8% 0% 2,073,265 2,073,265 Des Cly Tax Office Contract 42 (42) 8% 0% 500 500 City of Sisters 38,997 38,997 8% 8% 467,960 467,960 Des Cly CDD Contract 4,531 4,531 8% 8% 54,366 54,366 Des Cty Solid Waste Contr 4,531 4,531 8% 8% 54,366 54,366 Des Cly Clerk/Election 83 (83) 8% 0% 1,000 1,000 School Districts 3,333 (3,333) 8% 0% 40 ,000 40,000 Securily & Traffic Reimb 417 (417) 8% 0% 5,000 5,000 Seat Belt Program 833 280 (553) 8% 3% 10,000 10 ,000 Miscellaneous 500 749 249 8% 12% 6 ,000 6,000 False Alarm Fees 167 (167) 8% 0% 2,000 2,000 Restitution 417 25 (392) 8% 1% 5,000 5,000 Sheriff Fees 833 538 (295) 8% 5% 10,000 10,000 Court Fines & Fees 10,000 10,224 224 8% 9% 120,000 120,000 Impound Fees 333 800 467 8% 20% 4,000 4,000 Restitution -Street Crimes 42 (42) 8% 0% 500 500 Seizure/Forfeiture 83 (83) 8% 0% 1,000 1,000 Interest 833 1,210 377 8% 12% 10,000 10,000 Interest on Unsegregated 150 16 (134) 8% 1% 1,800 1,800 Donations 2,500 2,500 8% n/a 2,500 2,500 Sale of Equip & Material 833 (833) 8% 0% 10,000 10,000 Sale of Reportable Assets 3,333 (3 ,333) 8% 0% 40,000 40,000 Total Revenues 983,482 133,299 ~850,183l SO-/. 1% 11,801,777 11,804,277 2,500 TOTAL RESOURCES 3,843,397 3,373,657 (469,740) 50% 23% 14,661,692 15,044,635 382,943 REQUIREMENTS: I Exp . %1 Fund 255 Departments: Sheriffs Services 12,531 14 ,765 (2,234) 8% 10% 150,373 150,366 7 Auto/Comm 86 ,536 251,615 (165,079) 8% 24% 1,038,438 1,136,282 (97,844) Investigations 125,682 134,574 (8,892) 8% 9% 1,508,180 1,508,080 100 Patrol 689,113 653,509 35,604 8% 8% 8 ,269,358 8,269,358 Records 59,801 47,276 12,525 8% 7% 717,617 717,517 100 Special Services 34,382 43,699 (9,317) 8% 11% 412,587 412,587 Training 16,356 11.404 4,952 8% 6% 196,274 196,235 39 Non Dept -ISF Charges 3,545 3,545 0 8% 8% 42,541 42,541 8% n/a 324 Transfer to Reserve Fund (704) Non Dept -Comm System Res Total Requirements 8,333 10,000 1,221,808 1,160,387 8,333 10,000 61,420 8% 8% 8% 0% 0% 8% 100,000 120,000 14,661 ,692 100,000 120,000 12,652,967 2,008,725 Net 2,621,589 2,213,270 (408,319) 2 ,391,669 2,391,669 a) Current year taxes not due until November Page 5 • Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services. PUBLIC HEALTH Statement of Financial Operating Data One Month Ended July 31, 2012 Variance Beg. Net Working Capital $1,336,051 $ $ 100% 99% $1,336,051 $1,327,199 $ (8,852) Revenues Medicare Reimbursement 83 (83) 8% 0% 1,000 1,000 Federal Grant 5,000 8% n/a 5,000 5,000 Federal Grant (ARRA) 16,667 8% 0% 200,000 200,000 State Grant 217,931 (21 8% 0% a) 2,615,168 168 Child Dev & Rehab Center 3,301 (3,301 ) 8% 0% 39,609 State Miscellaneous 8,469 (8,469) 8% 0% 101,630 OMAP 52,299 8% 4% 627,588 Title 19 29 (29) 8% n/a 352 352 Family Planning 45,833 8% 0% 550,000 550,000 Local Grants 14,160 (14,160) 8% 0% 169,920 169,920 Environmental Health-Water 7,683 8% 0% 92,200 Contract 10,000 10,000 8% n/a 10,000 10,000 Miscellaneous 700 700 8% n/a 700 Patient Insurance Fees 16,100 10,088 8% 5% Health Fees 8,592 6,288 8% 6% 103,100 103,100 Vital Records-Birth 3,417 2,160 8% 5% 41,000 41,000 Vital Records-Death 8,333 11,130 8% 11% 100,000 100,000 Environmental Health-Lie Fae 60,004 29,912 8% 4% 720,050 Interest on Investments 1,000 563 (437) 8% 5% 12,000 12,000 Donations 442 17,160 16,718 8% 324% 22,277 Interfund Contract 13,219 (13,219) 8% 0% Administrative Fee 8% 8% Total Revenues 477,629 115,839 (361,790) 8% 2% Transfers In-General fund 195,780 195,780 8% 8% 2,349,357 Transfers In-PH Res fund 5,011 8% 0% 60,136 Transfers In-Gen. Fund Other 8% 0% 65,100 TOTAL RESOURCES 2,019,896 1,638,818 (381,078) 8"/.. 17% 9,566,015 Personal Services 530,297 502,000 8% 8% 6,363,560 6,363,560 Materials and Services 159,768 90,936 8% 5% 1,917,220 1,917,220 Capital 5,417 5,417 8% 0% b) 65,000 65,000 Transfers Out 13,100 13,100 8% 0% 157,200 157,200 Contingency 8% n/a TOTAL REQUIREMENTS 795,183 592,936 202,247 8% 6% 9,542,190 8,437,980 1,104,210 NET (Resources -Requirements) for July will be received in August Outlay expense for the OCHIN System expended in FY 2012 700 6 BEHAVIORAL HEALTH Statement of Financial Operating Data One Month Ended July 31, 2012 Vearto Date Actual Variance Variance RESOURCES: Beg. Net Working Capital $3,320,968 $ 3,113,095 $ (207,873) 100% 94% $3,320,968 $3,113,095 $ (207,873) Revenues Marriage licenses 542 900 358 8% 14% 6,500 6,500 Divorce Filing Fees 13,333 10,468 (2,865) 8% 7% 160,000 160,000 Domestic Partnership Fee 4 30 26 8% 67% 45 45 Federal Grants 21,029 (21,029) 8% 0% 252,349 252,349 Federal Grant (ARRA) 5,313 (5,313) 8% 0% 63,750 63,750 State Grants 644,217 168,482 (475,735) 8% 2% 7,730,599 7,730,599 State Miscellaneous 5,155 (5,155) 8% 0% 61,860 61,860 Adult Mental Health Initiative 16,667 (16,667) 8% 0% 200,000 200,000 Title 19 22,454 14,514 (7,940) 8% 5% 269,446 269,446 liquor Revenue 11,792 (11,792) 8% 0% 141,500 141,500 School Districts 5,750 (5,750) 8% 0% 69,000 69,000 Miscellaneous 69 69 8% n/a 5,000 5,000 Patient Insurance Fees 7,294 8,881 1,587 8% 10% 87,532 87,532 Patient Fees 79 204 125 8% 21% 950 950 Interest on Investments 2,083 1,913 (170) 8% 8% 25,000 25,000 Rentals 1,542 375 (1,167) 8% 2% 18,500 18,500 Administrative Fee 441,044 431,044 (10,000) 8% 8% 5,292,527 5,292,527 Interfund Contract-Gen Fund 10,583 PO,583} 8% 0% 127,000 127,000 Total Revenues 1,208,881 636,880 (572,001) 8% 4% 14,506,558 14,511,558 5,000 Transfers In-General Fund Transfers In-OHP-CDO Transfers In-Acute Care Svcs Transfers In-ABHA 108,982 40,375 22,053 43,670 108,982 40,375 22,053 43,670 8% 8% 8% 8% 8% 8% 8% 8% 1,307,787 484,494 264,631 524,039 1,307,787 484,494 264,631 524,039 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 4,744,929 930,426 549,520 8 17,000 203,752 3,965,055 902,559 213,882 (779,874) 27,867 335,638 8 17,000 203,752 8% 19% I Exp. %1 8% 8% 8% 3% 8% 0% 8% 0% 8% n/a 20,408,477 11,165,114 6,594,235 100 204,000 2,445,028 20,205,604 11,165,114 6,594,235 204,000 (202,873) 100 2,445,028 TOTAL REQUIREMENTS 1,700,706 1,116,441 584,265 8% 5% 20,408,477 17,963,349 2,445,128 NET (Resources -Requirements) 3,044,223 2,848,614 {195,609! 2,242,255 2,242,255 Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data One Month Ended July 31, 2012 Year to Date Budget I Actual I Variance I FY% I Coil. % RESOURCES: Beg. Net Working Capital $ 10,000 Revenues Admin-Operations 1,841 Admin-GIS 104 Admin-Code Enforcement 13,850 Building Safety 106,131 Electrical 21,333 Contract Services 9,300 Env Health-On Site Prog 26,081 Planning-Current 53,113 Planning-Long Range 18,868 Total Revenues 250,621 Transfers In General Fund -Gen Ops 71,239 General Fund -UR Planning 41,280 A&T Reserve (DIS assistance) 7,465 Other 8 TOTAL RESOURCES 380,613 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations 112,766 Admin-GIS 9,815 Admin-Code Enforcement 19,077 Building Safety 51,757 Electrical 16,936 Contract Services 11,812 Env Health-On Site Pgm 13.303 Planning-Current 53.526 Planning-Long Range 38.617 Transfers Out (DIS Fund) 14,930 Contingency 28,909 FY 2013 Year End Budget Projection Variance $ 10,000 $ 192,982 182,982 22,090 22.090 1.250 1,250 166,200 166.200 1,273.575 1,273.575 256,000 256,000 111.600 111,600 312,971 312.971 637,350 637,350 226,421 226,421 3,007,457 854,872 495,360 89.577 100 4,457,366 3,007,457 854,872 495,360 89,577 4,640,248 POOl 182,882 1,353,189 117,778 228.925 621,087 203,231 141,745 159,636 642,315 463,401 179,155 346,904 4,457,366 1,353,189 117,778 228,925 621,087 203,231 141.745 159,636 642,315 463,401 179.155 4,110,462 346,904 346,904 192,982 $ 3,894 65 19,985 138,569 41,411 7,264 24,213 52,062 26,438 182,982 2,053 (39) 6,135 32,438 20,078 (2,036) (1,868) (1,051) 7,570 100% 8% 8% 8% 8% 8% 8% 8% 8% 8% 1930% 18% 5% 12% 11% 16% 7% 8% 8% 12% 313,901 63,280 8% 10% 71,239 41,280 619,402 (7,465) {81 238,789 8% 8% 8% 8% 8% 8% 8% 0% 0% 14% Exp. %1 115,159 9,205 17,520 51,739 15,361 11,411 11.174 46,595 36,393 (2,393) 610 1,557 18 1,575 401 2.129 6,931 2.224 14.930 28,909 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 9% 8% 8% 8% 8% 8% 7% 7% 8% 0% nla b) a) TOTAL REQUIREMENTS 371,448 314,557 56,891 8% 7% NET (Resources -Requirements) 9,165 304,845 295,680 529,786 529,786 Revenues Expenditures Net from Operations 313,901 314.557 (656} 3,007,457 4,457,366 (1,449,909) 3,007,457 4,110,462 (1,103,005) 346,904 346,904 a) GIS revenue is sporadic based on the frequency of customer requests b) Expenses are higher than YTD due to a large (budgeted) software license payment in July Page 8 ROAD Statement of Financial Operating Data One Month Ended July 31, 2012 Year to Date Budget I Actual J Variance !FY % !Coil. % FY 2013 YearEnd Budget Projection Variance RESOURCES: Beg. Net Working Capital $4,719,551 $ 4,940,444 $ 220,893 100% 105% $ 4,719,551 $ 4.940,444 $ 220.893 Revenues Federal Grant (ARRA) 583 (583) 8% 0% 7,000 7,000 Mineral Lease Royalties 3,333 (3,333) 8% 0% 40,000 40,000 Forest Receipts 33,069 (33,069) 8% 0% a) 396,826 396,826 State Miscellaneous 45,191 (45,191) 8% 0% 542,290 542,290 Motor Vehicle Revenue 899,170 880,851 (18,319) 8% 8% 10,790,043 10,790,043 City of Bend 2,083 (2,083) 8% 0% b) 25,000 25,000 City of Redmond 29,167 (29,167) 8% 0% b) 350,000 350,000 City of Sisters 833 (833) 8% 0% b) 10,000 10,000 City of La Pine 833 (833) 8% 0% b) 10,000 10,000 Admin Recovery (SOC) 388 388 8% n/a 1,000 1,000 Miscellaneous 1,667 125 (1,542) 8% 1% 20,000 20,000 Road Vacations 83 (83) 8% 0% 1,000 1,000 Interest on Investments 1,250 2,826 1,576 8% 19% 15,000 15,000 Interfund Contract 57,500 (57,500) 8% 0% c) 690,000 690,000 Equipment Repairs 18,333 (18,333) 8% 0% 220,000 220,000 Vehicle Repairs 7,500 (7,500) 8% 0% c) 90,000 90,000 LID Construction 833 (833) 8% 0% c) 10,000 10,000 Vegetation Management 2,083 (2,083) 8% 0% c) 25,000 25,000 Forester 2,083 (2,083) 8% 0°;'; c) 25,000 25,000 Car Washes 333 (333) 8% 0% 4,000 4,000 Car Rental 83 (83) 8% 0% 1,000 1.000 Sale of Equip & Material 60,300 594 (59,706) 8% 0% 723,600 723,600 Total Revenues 1,166,310 884,784 (281,526) 8% 6% 13,995,759 13,996,759 1,000 Trans In -Solid Waste 23,023 (23,023) 8% 0% 276,272 276,272 Trans In -Transp SOC 20,833 (20,833) 8% 0% 250,000 250,000 Trans In-Road Imp Res 1,000 (1,000) 8% 0% 12,000 12,000 TOTAL RESOURCES 5,930,717 5,825,228 (84,656) 8% 31% 19,253,582 19,475,475 221,893 REQUIREMENTS: !Exp.o/.I Expenditures Personal Services 447,100 443,710 3,390 8% 8% 5,365,202 5,365,202 Materials and Services 786,555 489,800 296,755 8% 5% 9,438,662 9.438,662 Capital Outlay 169,775 200 169,575 8% 0% 2,037,300 2,037,300 Transfers Out 22,917 22,917 8% 0% 275,000 275,000 Contingency 178,118 178,118 8% n/a 2,137.418 2,137,418 TOTAL REQUIREMENTS 1,604,465 933,710 670,755 8% 5% 19,253.582 17.116.164 2.137,418 NET (Resources· Requirements) 4.326,252 4,891,518 586,099 2,359,311 2,359,311 a) Payment received annually in January b) Billed upon completion of work c) Payments to be received in June 2013 from other Road Department funds Page 9 ADULT PAROLE & PROBATION Statement of Financial Operating Data One Month Ended July 31.2012 RESOURCES: Beg. Net Working Capital Revenues DOC Measure 57 State Miscellaneous Alternate Incarceration State Subsidy SB 1145 Probation Work Crew Fees Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Interest on Investments Interfund -Sheriff Crime Prevention Grant CFC-Domestic Violence Total Revenues Transfers In-General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS Year to Date Budget 1 Actual 1 Variance $ 570,000 $ 630,226 $ 60,226 18,270 358 1,250 1,152 229,045 1.875 375 10.833 15,833 750 4,167 4.167 6,236 294,311 2.180 342 12.959 14,351 337 4,167 34,336 (18,270) (358) (1,250) (1.152) (229,045) 305 (33) 2,126 (1,482) (413) (4,167) (6,236) (259,975) 36,277 900,588 36,277 700,839 (199,749) 257,608 72,891 8 47,584 243,060 46,254 14,548 26,637 8 47,584 lFY % 1 Coli. % 100% 111% 8% 0% 8% 0% 8% 0% 8% 0% 8% 0% 8% 10% 8% 8% 8% 10% 8% 8% 8% 4% 8% 8% 8% 0% 8% 0% 8% 1% 8% 8% 8% 15% I Exp. %1 8% 8% 8% 5% 8% 0% 8% nJa 378,091 289,314 88,777 8% 6% a) b) c) a) a) FY 2013 YearEnd Budget Projection Variance $ 570,000 $ 630,226 $ 60,226 219,240 219,240 4,301 4.301 15,000 15,000 13,826 13.826 2,748,556 2.748,556 22,500 22,500 4,500 4,500 130,000 130,000 190.000 190,000 9,000 9,000 50,000 50,000 50,000 50,000 74,832 74,832 3,531,755 3,531,755 435,328 435,328 4,537,083 4,597,309 60,226 3,091,291 3,091,291 874,687 874.687 100 100 571.005 571,005 4,537,083 3.965,978 571,105 NET (Resources. Requirements) 522,497 411,525 (110,972) 631.331 631,331 a) Contracts recently submitted, expecting payment mid-September b) Annual allocation normally received by end of calendar year c) State invoiced quarterly Page 10 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data One Month Ended July 31, 2012 Budget I Year to Date Actual I Variance !FY% ! Coil. % FY 13 Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 511,994 $ 574,985 $ 62,991 100'10 112.". $ 511,994 $ 574,985 $ 62,991 Revenues Federal Grants 16.620 (16,620) 8% 0% 199,441 199,441 Title IV -Family Sup/Pres 3,294 (3,294) 8% 0% 39,533 39.533 HealthyStart Medicaid 7,083 (7,083) 8% 0% 85,000 85,000 level 7 Services 16,408 (16,408) 8% 0% 196.898 196,898 State Prevention Funds 4,010 12,031 8,021 8% 25% 48,122 48.122 HealthyStart /R-S-G 18,329 (18,329) 8% 0% 219,951 219,951 OCCF Grant 34,983 (34.983) 8% 0% 419,796 419,796 Charges for Svcs-Misc 667 (667) 8% 0% 8.000 8,000 Court Fines & Fees 6,624 6.281 (343) 8% 8% 79,485 79.485 Interest on Investments 83 397 314 8% 40% 1,000 1,000 Grants. Private 167 (167) 8% nfa 2,000 2,000 Interfund Grants 26,740 ~26,740! 8% 0% 320.874 320.874 Total Revenues 135,008 18,709 (116,299) 8'10 1'10 1,620,100 1,620,100 Trans from General Fund 23,003 23,000 8% 8% 275.984 275,984 ~3l Total Transfers In 23,003 23,000 (3) 8'10 8% 275,984 275,984 TOTAL RESOURCES 670,005 616,694 (53.311) 8% 26'10 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 53,956 123,000 8 23,709 48,506 10,144 5,450 112,856 8 23.709 I Exp. %1 8% 7% 8% 1% 8% 0% 8% nfa TOTAL REQUIREMENTS 200,673 58,650 142,023 8% 2% 2,408,078 2,471,069 62.991 647,474 1,475.997 100 284,507 647,474 1,475,997 100 284,507 2,408,078 2,123,471 284,607 NET (Resources -Requirements) 469,332 558,044 88,712 347,598 347.598 Page 11 SOLID WASTE Statement of Financial Operating Data One Month Ended July 31,2012 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Franchise 3% Fees Commercial Disp. Fees Private Disposal Fees Franchise Disposal Fees Yard Debris Special Waste Interest Leases Recyclables Budget $ 700,513 1,833 16,667 71,667 109,500 333,333 6,083 2,083 625 900 3,750 Year to Date I Actual I Variance I FY % I Coli. % $ 807,470 $ 106,957 100'. 115% 1,683 (150) 8% 8% 2,500 (14,167) 8% 1% a) 81,917 10,250 8% 10% 142,596 33,096 8% 11% 354,960 21,627 8% 9% 12,096 6,013 8% 17% b) 534 (1,549) 8% 2% c) 629 4 8% 8% 1,800 900 8% 17% 6,467 2,717 8% 14% FY 2013 Year End Budget Projection Variance $ 700,513 $ 807,470 $ 106,957 22,000 22,000 200,000 200,000 860,000 860,000 1,314,000 1,314,000 4,000,000 4,000,000 73,000 73,000 25,000 25,000 7,500 7,500 10,801 10,801 45,000 45,000 Total Revenues 546,441 605,182 58,741 8% 9% 6,557,301 6,557,301 TOTAL RESOURCES 1,246,954 1,412,652 165,698 8% 19% 7,257,814 7,364,771 106,957 REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out-Road Trans Out-Capital Res Contingency 144,443 249,109 78,893 6,917 23,023 52,500 49.933 136,332 66,065 8,111 183,044 78,893 6,917 23,023 52,500 49,933 8% 8% 8% 8% 8% 8% 8% Exp. %1 8% 2% 0% 0% d) e) f) 0% g) 0% h) nla 1,733,321 2,989,313 946,713 83,000 276,272 630,000 599,195 1,733,321 2,989,313 946,713 83,000 276,272 630,000 599,195 TOTAL REQUIREMENTS 604,818 202,397 402,421 8% 3% 7,257,814 6,658,619 599,195 NET (Resources -Requirements) 642,136 1,210,255 568,119 706,152 706,152 a) Due April 15, 2013 b) Seasonal item-Fall and Spring c) Dependent on special clean-ups such as asbestos and contaminated soil d) Purchasing will pick up as year progresses e) To be expended in November and May f) In the process of contacting bidders g) Semi-annual payments in December and June h) As needed Page 12 RISK MANAGEMENT Statement of Financial Operating Data One Month Ended July 31, 2012 Budget I Year to Date Actual I Variance I % of FY I % Coil. Budget Year End Projection Variance RESOURCES: Beginning Net Working Capital Revenues Inter-fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Workers' Compensation Claims Reimb-Gen Liab/Property Process Fee-Events/Parades Miscellaneous Skid Car Training Interest on Investments Other Interest TOTAL REVENUES $2,000,000 21,861 26,123 14,470 120,015 20,833 42 5,000 167 4 1,333 1,250 4 211,102 $2,240,791 21,861 26,123 14,470 120,015 20,846 105 250 1,116 204,786 $240,791 (0) (0) 0 0 13 (42) (5,000) (62) (4) (1,083) (134) (4! i6,316~ 100% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 112'¥. 8% 8% 8% 8% 8% 0% 0% 5% 0% 2% 7% 0% 8'¥. $2,000,000 $2,240,791 262,333 262,333 313,480 313,480 173,635 173,635 1,440,176 1,440,176 250,000 250,000 500 500 60,000 60,000 2,000 2,000 50 50 16,000 16,000 15,000 15,000 50 50 2,533,224 2,533,224 $240,791 TOTAL RESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Repair I Replacement Total General Liability 2,211,102 25,000 2,445,577 135.600 763 136,363 234,474 (111,363) 8% 54% 1% Ex!!_ I 8% 45% a) 4,533,224 300,000 4,774,015 300,000 240,791 PROPERTY DAMAGE Insurance Repair I Replacement Total Property Damage 20,833 158,562 158,562 (137,729) 8% 63% a) 250,000 250,000 VEHICLE Professional Service Insurance Loss Prevention Repair I Replacement Total Vehicle 8,333 598 598 7,736 8% 1% 100,000 100,000 WORKERS' COMPENSATION Settlement I Benefit Professional Service Insurance Loss Prevention Miscellaneous Total Workers' Compensation 83,333 26.516 69,009 13,125 108,650 (25,316) 8'¥. 11% a) 1,000,000 1,000,000 UNEMPLOYMENT -SettlementlBenefits 20,833 20,833 8% 0% 250,000 250,000 Total Direct Insurance Costs 158,333 404,172 (245,839) 8% 21% 1,900,000 1,900,000 Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration 25,658 14,083 8 39,749 23,373 10,284 33,657 2,285 3,798 8 6,092 8% 8% 8% 8% 8% 6% 0% 7% 307,896 168,990 100 476,986 307,896 168,990 476,886 100 100 Transfers Out 600 600 8% 0% 7,200 7,200 TOTAL REQUIREMENTS 198,682 437,829 (239,147) 8'¥. 18% 2,384,186 2,384,086 100 NET 2,012,420 2,007,748 (4,673) • 2,149,038 2,389,929 240,891 a) Annual premium paid in July 2012 Page 13 • Contingency Is $2,149,038. DESCHUTES COUNTY 911 Statement of Financial Operating Data One Month Ended July 31, 2012 Year to Date Actual Variance Variance RESOURCES: 8eg. Net Working Capital $8,000,000 $ 8,874,091 $ 874,091 100% 111% $8,000,000 $8,874,091 $ 874,091 Revenues Property Taxes -Current 545,641 (545,641) 8% 0% a) 6,547,687 6,547,687 Property Taxes· Prior 15,417 53,031 37,614 8% 29% 185,000 185,000 Federal Grants 20,000 (20,000) 8% 0% 240,000 240,000 State Reimbursement 3,000 (3,000) 8% 0% 36,000 36,000 Telephone User Tax 62,500 (62,500) 8% 0% 750,000 750,000 Data Network Reimb. 2,500 (2,500) 8% 0% 30,000 30,000 .Iefferson County 2,500 (2,500) 8% 0% 30,000 30,000 User Fee 3,667 (3,667) 8% 0% 44,000 44,000 Police RMS User Fees 23,246 (23,246) 8% 0% 278,950 278,950 Contract Payments 2,583 (2,583) 8% 0% 31,000 31,000 Miscellaneous 750 565 (185) 8% 6% 9,000 9,000 Interest 3,333 4,467 1,134 8% 11% 40,000 40,000 Interest on Unsegregated Tax 50 13 p7~ 8% 2% 600 600 Total Revenues 685,187 58,076 (627,111) 8% 1% 8,222,237 8,222,237 TOTAL RESOURCES 8,685,187 REQUIREM ENTS: Expenditures Personal Services 358,900 Materials and Services 170,850 Capital Outlay 46,833 Transfers Out 41,667 Contingency 733,603 8,932,167 355,924 94,637 23,257 246,980 2,976 76,213 23,576 41,667 733,603 TOTAL REQUIREMENTS 1,351,853 473,818 878,035 NET (Resources -Requirements) 7,333,334 8,458,349 1,125,015 a) Current year taxes not due until November 8% 8% 8% 8% 8% 8% 8% 55% % Exp·1 8% 5% 4% 0% n/a 30/0 16,222,237 17,096,328 874,091 4,306,797 2,050,202 562,000 500,000 8,803,238 3,800,000 2,050,202 562,000 500,000 506,797 8,803,238 16,222,237 6,912,202 9,310,035 -10,184,126 10,184,126 Page 14 Health Benefits Trust Statement of Financial Operating Data One Month Ended July 31,2012 RESOURCES Beg. Net Working Capital $13,800,000 $14,518,223 $ 718,223 100% O· $ 13,800,000 $14,518,223 718,223 Rewnues: Internal Premium Charges 1,066,250 1,065,326 (924) 8% 8% 12.795,000 12,795,000 prr Emp -Add'i Prem 4,167 2,748 (1,418) 8% 5% 50,000 50.000 Employee Prem Contribution 52,500 52,585 85 8% 8% 630,000 630,000 COIC 108,333 115,031 6,698 8% 9% 1,300,000 1,300,000 Retiree I COBRA Co-Pay 62,500 73,290 10,790 8% 10% 750,000 750.000 Medical Services Reimb 323 323 8% nla 323 323 Interest 6,667 7,250 583 8% 9% 80,000 80,000 Total Rewnues 1,300,417 1,318,554 18,138 8% 15,805,000 15,805,323 323 TOTAL RESOURCES 15,100,417 15.834,m 734,380 92% 105% 29,405,000 30,123,548 718,548 REQUIREMENTS Expenditures: Penona/ Services (all depts) 16,731 16,064 667 8% 8% 200.772 200,772 Materials & Services Claims Paid-Medical/Rx 996,150 1,317,889 (321,739) 8% 11% a) 11,953,800 12.165,439 (211,639) Claims Paid-DentalNision 148,850 142,312 6,538 8% 8% a) 1,786,200 1,480,046 306,154 Refunds (5,534) 5,534 8% nla (5.534) 5,534 Insurance Premiums 29,167 29,911 (744) 8% 9% 350,000 350,000 State Assessments 13,333 13,333 8% 0% 160,000 160,000 Administration Fee 26,667 26,485 181 8% 8% 320,000 320,000 Preferred Provider Fee 4,167 4,107 60 8% 8% 50,000 50,000 Health Impact 4,583 4,318 265 8% 8% 55,000 55,000 Other -Administration 5,446 1,744 3.702 8% 3% 65,353 65,353 Other -Wellness 8,750 1,120 7,630 8% 1% 105,000 105,000 Admin &Wellness 1,237,113 1,522,353 (285,240) 11% 1O'Y. 14,845,353 14,745,304 100,049 Deschutes On-site Clinic Healthstat 57,000 57,000 8% 0% 684,000 684,000 Medical Supplies 2.500 532 1,968 8% 2% 30,000 30,000 Equipment 83 83 8% 0% 1,000 1.000 Miscellaneous 1,186 1,853 (66) 8% 9% 21,433 21,433 Total DOC 81,369 2,384 58,985 0% 738,433 738,433 Deschutes On-site Pharmacy Contracted Services 25,691 25,691 8% 0% 308,281 308,287 Medication and Drugs 83,333 83,333 8% 0% 1,000,000 1,000,000 Miscellaneous 1,380 1,380 (0) 8% nla 16,559 16,559 Total Pharmacy 110,404 1,380 109,024 nla 1,324,846 1,324,846 Capital Outlay 8 8 8% nla 100 100 Contingency 1,024,191 1,024,191 8% nla 12,297,496 12,297,496 TOTAL EXPENDIREQUIREMNTS 2,340,013 1,542,181 908,235 S% 29,405,000 17,007,355 12,397,645 NET (Resources -Requirements) 12, 760,404 14,292,595 1,642,595 13,116,191 13,116,191 * Additional FY 2012 Revenues and Expenditures could be recorded. This will result in a change to Beginning Net Working Capital. a) Projection based on annualizing 5 weeks of claims paid. YTD actual is an average of $290,934 per week Page 15 Deschutes County· Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data One Month Ended July 31, 2012 Vearto Date Budget (1112 ofl annual) I Actual I Variance IFY % ICoil. % Year End FY2013 Variance IBudget Projection RESOURCES: Beg. Net Working Capital $ 46,373 $ 35,055 $ (11,318) 100% 76% $ 46,373 $ 35,055 $ (11,318) Receipts: Special Events Revenues 50,632 15,949 (34,683) 8% 3% 607,578 599,527 (8,051 ) Interest Storage 125 4,787 33 (92) (4,787) 8% 8% 2% 0% 1,500 57,441 1,408 57,441 (92) Camping at F & E Horse Stall Rental 500 2,500 16,262 (500) 13,762 8% 8% 0% 54% 6,000 30,000 6,000 46,262 16,262 Concession % -Food Rights (Signage, etc.) Interfund Contract 15,833 7,917 1,667 2,483 16,000 200 (13,350) 8,083 (1,467) 8% 8% 8% 1% 17% 1% 190,000 95,000 20,000 189,483 95,000 20,000 (517) Miscellaneous 567 6 {561) 8% n/a 6,800 6,806 6 Total Receipts 84,527 50,932 (33,594) 8% 5% 1,014,319 1,021,926 7,607 Transfers In General Fund (001) 14,167 14,167 8% 8% 170,000 170,000 Room Tax (160) 2,145 2,145 8% 8% 25,744 25,744 Welcome Center (170) 6,900 6,900 8% 8% 82,800 82,800 Annual County Fair (619) 22,022 ~22,022} 8% 0% 264,259 264,259 Total Transfers In 45,234 23,212 {22,022) 542,803 542,803 TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Total Expenditures Contingency 176,133 69,324 42,185 9,510 1,188 109,199 66,828 26,744 (66,934) 2,496 15,441 9,510 1,188 122,207 93,572 28,635 11,418 11,418 8% 8% 8% 8% 8% 8% 7% I Exp. %1 8% 5% 0% 0% n/a 1,603,495 1,599,784 (3,711) 831,882 829,392 2,490 506,223 511,882 (5,659) 114,119 114,119 14,259 14,259 1,466,483 1,469,652 (3,169) 137,012 137,012 TOTAL REQUIREMENTS 133,625 93,572 40,052 8% 6% 1,603,495 1,469,652 133,843 NET (Resources -Requirements) 42,509 15,627 (26,8821 130,132 130,132 Page 16 00 u ~ ~ 0 ~ ~ ~ ~ < ~ ~ ~ < U r;r, ;:s 0.. a u ~ ~ ....... c ;:s 0 u ..s:= 1:: 0 z • c c ....... a (I) ..s:= ..s:=-(I) ....... (I) co • Deschutes County North County Services Building Inception through July 31, 2012 RESOURCES: Beginning Net Working Capital Loan Proceeds, net of issuance costs Resources from Fund 140 Resources from Fund 142 Transfer in Interest Revenue Total Re.ource. EXPENDITURES: Materials &Services Architecture/Design Engineering Planning Interfund Charges Fees , Permits & SDCs Utilities Travel· Meals/Mileage Reimb Total Materlall & Services Capital Outlay Land and Building Remodel Total Capital Outlay Contingency Total Expenditures Net Project to Date I 1,402,013 25,000 600,000 4,036 2,031,041 47,092 2,620 534 10,097 3 2,908 60,346 2,908 1,402,013 230 1,402,243 1,462,588 2,908 568,461 (2,908) 1,402,013 25,000 600,000 4,036 2,031,049 a) b) 50,000 b) 2,620 534 10,097 3 63,254 1,402,013 a) 230 1,402,243 1,465,497 565,552 L Budget· I Projected I I Variance 3,400,000 3,400,000 1,402,013 1,402,013 25,000 25,000 700,000 700,000 13,740 13,740 5,540,753 5,540,753 325 ,000 325,000 75,000 75,000 13,150 13,150 75 ,000 75,000 20,000 20,000 3 {3~ 508,150 508,153 ~3~ 1,402,013 1,402,013 3,300,000 3,300,000 4,702,013 4,702,013 313,513 313,513 5,523,676 5,210,166 (3) 17,077 330,587 313,510 • The project budget is the consolidation of FY 2012 (actual and unexpended budget) and FY 2013 adopted budget a) The building was purchased in FY 2011 with resources from Project Development and Debt Reserve· $1,402,013 b) $25,000 was paid to the architect. in FY 2011 with resources from General County Projects Fund (Fund 142) I Deschutes County Bethlehem Inn (Fund 128) One Month Ended July 31, 2012 Budget Actual Variance IFy%1 Coli. oJ Budget I Projection I Variance RESOURCES: Beg. Net Working Capital $(2,710,000) $(2,710,173) $ (173) 100"/0 100% $(2,710,000) $(2,710,173) $ (173) Revenues Grants -Private 8,383 (8,383) S% 0% 100,592 100,592 Lease Payments 2,034 4,068 2,034 S% 17% 24,408 24,408 Total Revenues 10,417 4,0. (6,349) 8% 3% 125,000 125,000 Transfers In: Project Development (140) 137,500 (137,500) S% 0% 1,650,000 1,650,000 Gen Capital Res (143) 88,333 ~88,333~ S% 0% 1,060,000 1,060,000 TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service: Interest Expense Interest Payment (2.473,750) 2,083 8,333 (2,706.105) 1,406 (232,355) 677 8,333 8% S% S% -2165% Exp·%1 6% 0% a) 125,000 25,000 100,000 124,827 17,000 100,000 (173) 8,000 TOTAL REQUIREMENTS 10,417 1,406 9,010 88;' 125,000 117,000 NET (Resources· Requirements) (2,484,167) (2,707,511) (223,345) b)=============7,=~=7======(1=73=) a) Interest on July 2012 negative cash balance: $1,4063.45.. b) Inception through July 31, 2012 Revenues -Lease Payments $ 52,884 Expenditures: Land/Building (Amertitle) -July 2007 2,241,313 Hickman Williams 17,578 City of Bend -May 2008 250,000 KN EX CO 5,289 Kleinfelder 3,732 Total expended on facility 2,517,913 Interest on Negative Cash Balance 242,483 Total expended 2,760,395 Net $(2,707,511) Deschutes County General Support Services -SOCC Conference/Seminar, EducationlTraining and Travel Expenditures and SOCC -County College Expenditures FY 2013 ____ [1:30ccconterence~&~II"!I'I~7~~-+---"""-YT-D-T-o-ta-l1 !Tammy Baney r-g~~f/Sem & EduclTr·aTnTr19~ 30 30 Travel Meals Accommodations Airfare Mileage reimbursement Ground Transport/Parking ....... -....... ------~ 30~!~!~I Baney__"_"" Alan Unger ____ ~ ._."~_~ Conf/Sem & EduclTraining . 65 65Travel Meals -----" --~---"-,--~~-~-~-~- Accommodations Airfare -----:--:-­ Mileage reimbursemeil~L Ground Transport/Parking .................--.----.---~-~~~- Total Unger 65 65 I======~'===.---~-~-~--~~==.----~ Tony DeBone Conf/Sem & EduclTraining 30 30 ---~-~-~----- Travel Meals Accommodations re _ge reimburse!!l_~nt round Transport Total Other 30 Total-BOCC Department 125 Travel Meals Accom modations Airfare Conf/Sem & Educ!Trainin.9 __ --=--:--:---­ Mileage Reimburs~'!l~I1!_ Ground Transport ______~~--.....,...."..",..._\ Total -BOCC Department 125 125 FY 2013 Budget 14,750 -----~~-- .. _Percent of F.Y~~l~-'~ludI!et Expende~_ 0.8% BOCC Coun!Y_~~lIeg~_ ~ _Qf!i~COpie~~lJ_ppli~~_ Meeting Supplies 8/9/2012 GENERAL FUND Statement of Financial Operating Data Year Ended June 30,2012 (PRELIMINARY AS OF 8/21/2012) Year to Date Final Budget I Actual I Variance IFY % I Coil. % RESOURCES: Beg. Net Working Capital Revenues Property Taxes Gen. Rev.-exd.Taxes Assessor County Clerk BOPTA District Attorney FinanceIT ax Veterans Property Management Grant Projects $ 7,300,000 $ 20,100,967 2,382,321 790,996 1,468,707 12,398 298,669 193,900 61,341 96.200 2,000 8,245,725 21,506,937 2,439,103 781,874 1,463,090 14,788 325,968 211,650 69,574 96,200 2,000 $ 945,725 1,405,970 56,782 (9,122) (5.617) 2,390 27,299 17,750 8,233 - - 100% 113% 100% 107% 100% 102% 100% 99% 100% 100% 100% 119% 100% 109% 100% 109% 100% 113% 100% 100% 100% 100% Total Revenues 25,407,499 26,911,184 1,503,685 100Of. 106% TOTAL RESOURCES 32,707,499 35,156,909 2,449,410 100% 107% REQUIREMENTS: I Exp. %1 Expenditures Assessor 3,405,300 3,296,722 108,578 100% 97% County Clerk 1,423,965 1,142,435 281,530 100% 80% BOPTA 72,402 62,668 9,734 100% 87% District Attomey 4,879,296 4,663,981 215,315 100% 96% FinancelTax 813,648 768,469 45.179 100% 94% Veterans 267,415 255,677 11,738 100% 96% Property Management 262,214 258,528 3,686 100% 99% Grant Projects 118,715 118,480 235 100% 100% Non-Departmental 1,816,962 1,561.172 255,790 100% 86% Contingency 5,165,880 5,165,880 100% nfa 18,225,797 12,128.131 6,097,666 100% 67% Transfers Out 13,978,610 13,978,610 -100% 100% TOTAL REQUIREMENTS 32,204,407 NET (Resources -Requirements) 503,093 Beg NWC per FY 2013 Budget 26, 106,741 9,050,168 8,700,000 I 6,097,666 8,547,076 100% 81% Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Year Ended June 30,2012 (PRELIMINARY AS OF 8/21/2012) Year to Date Final Budget I Actual I Variance IFY % I Coil. % RESOURCES: Beg. Net Working Capital $ 1,101,374 $1,099,010 $ (2,364) 100·,4 100·/. Revenues Federal Grants 10,000 9,676 (324) 100% 97% SB #1 065-Court Assess. 50,000 52,957 2,957 100% 106% Discovery Fee 15,000 13,628 (1,372) 100% 91% Food Subsidy 25,000 25.157 157 100% 101% OYA Basic & Diversion 217,498 342,512 125,014 100% 157% Inmate/Prisoner Housing 88,490 76,320 (12,170) 100% 86% Inmate Commissary Fees 100 220 120 100% 220% Contract Payments 70,000 106,017 36,017 100% 151% Miscellaneous 60 359 299 100% 599% Program Fees 40 (40) 100% 0% MIP Diversion Fees 300 1,065 765 100% 355% Interest on Investments 7,500 7,986 486 100% 106% leases 2,400 1,200 (1,200) 100% 50% Grants -Private 500 934 434 100% 187% Behavioral Health 6,000 2,905 (3,095) 100% 48% CFC Interfund Grant 154,128 149,852 (4,276) 100% 97% Gen Fund Grant.crime Prev 20,000 20,000 -100% 100% Total Revenues 667,016 810,789 143,773 100% 122% Transfers In-General Fund 5,321,459 5,321,459 -100% 100% TOTAL RESOURCES 7,089,849 7,231,258 141,409 100'Y. 102'Y. REQUIREMENTS: Expenditures Community Justice-Juvenile I Exp·%1 Personal Services 5,109,069 4,958,175 150,894 100% 97% Materials and Services 1,219,733 1,204,632 15,101 100% 99% Capital Outlay Transfers Out Contingency 40,100 50,400 670,547 23,000 50,400 17,100 - 670,547 100% 100% 100% 57% 100% n/a TOTAL REQUIREMENTS 7,089,849 6,236,206 853,643 100'Y. 88% NET (Resources -Requirements) 995,051 995,051 Beg NWC per FY 2013 Budget 1,010,4151 Page 2 SHERIFF -Fund 255 Statement of Financial Operating Data Year Ended June 30, 2012 (PRELIMINARY AS OF 8/21/2012) Year to Date Final Budget 1 Actual 1 Variance 1 Fy%l Coil. % RESOURCES: Beg. Net Working Capital $ $ $ 100% nfa 100% 84% 100% 81% Total Revenues 36,533,516 30,177,303 (6,356,213) 100% 83% TOTAL RESOURCES 36,533,516 30,177,303 (6,356,213) 100% 83% REQUIREMENTS: Exp. %1 EXPENDITURES & TRANSFERS Sheriffs Division 2,583,941 2,473,759 110,182 100% 96% Civil 824,095 746,004 78,091 100% 91% Automotive/Com m unications 1,709,925 1,568,717 141,208 100% 92% Investigations/Evidence 1,734,218 1,527,082 207,136 100% 88% PatrollCivillComm Supp 8,004,704 7,853,027 151,677 100% 98% Records 720,710 686,502 34,208 100% 95% Adult Jail 10,506,527 9,680,930 825,597 100% 92% Court Security 286,602 275,256 11,346 100% 96% Emergency Services 192,925 175,658 17,267 100% 91% Special Services Division 1,335,161 1,153,546 181,615 100% 86% Regional Work Center 3,018,466 2,887,831 130,635 100% 96% Training Division 324,265 266,759 57,506 100% 82% Other Law Enforcement Svcs 632,256 609,000 23,256 100% 96% Non-Departmental 73,231 73,231 100% 100% Contingency 4,386,490 4,386,490 100% nfa Transfers Out -DIS Fund 200,000 200,000 100% 100% TOTAL REQUIREMENTS 36,533,516 30,177,303 6,356,213 100% 83% NET (Resources -Requirements) Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data Year Ended June 30 , 2012 (PR Date Variance Coli. % RESOURCES: Beg. Net Working Capital $ 5,108,671 $ 6,090,734 $ 982,063 100% 119% Tax Revenues ~ Current 14,306,841 15,070,363 763,522 100% 105% Tax Revenues -Prior 501,000 747,899 246,899 100% 149% Federal Grants & Reimb 35,200 30 ,784 (4,416) 100% 87% State Grant 48 ,475 56 ,577 8,102 100% 117% Transp. of State Wards 5,000 6 ,304 1,304 100% 126% SB 1145 1,537,663 1,479,991 (57,672) 100% 96% Prisoner Housing 224,535 224,535 100% n/a Des. Cty Video Lottery Grant 5,000 5,000 -100% 100% Des Cty Court Security 91,000 89,739 (1,261 ) 100% 99% Des Cty Juvenile Contract 4 ,180 12,768 8,588 100% 305% Title III Reimbursement 150,000 110,084 (39,916) 100% 73% Transport 1,000 2,183 1,183 100% 218% Other 4,971 4,971 100% n/a DC Fair & Expo Center 3,825 1,796 (2,030) 100% 47% Inmate Commissary Fees 6,600 16,866 10,266 100% 256% Work Center Work Crews 50,000 55,002 5,002 100% 110% Concealed Handgun Classes 3,500 3,650 150 100% 104% Inmate Telephone Fee 48 ,000 105,100 57,100 100% 219% Soc Sec Incentive-Fed 5,000 9,600 4,600 100% 192% Miscellaneous 5,000 8,871 3,871 100% 177% Oregon Mentors 15,000 9,039 (5,961 ) 100% 60% Debit Card Fee 287 287 100% n/a Medical Services Reimb 16,000 14,710 (1 ,290) 100% 92% Restitution 5 ,000 1,747 (3,253) 100% 35% Sheriff Fees 200,000 228,754 28 ,754 100% 114% Interest 28 ,333 49,323 20,990 100% 174% Interest on Unsegregated 3,533 1,525 (2 ,008) 100% 43% Donations -·Shop with a Cop· 734 734 100% n/a Donations 250 250 100% n/a Sale of Reportable Assets 1,000 7,599 6,599 100% n/a Total Revenues 17,076,150 18,3561050 1,279,900 100"1. 107% TOTAL RESOURCES 22,184,821 24,446,784 2,261,963 100% 110% REQUIREMENTS: 1 Exp. %1 Fund 255 Departments: Sheriffs Services 2,423,711 2,320,362 103,349 100% 96% Civil 824,095 746,004 78 ,091 100% 91% Auto/Comm 639,837 586,998 52 ,839 100% 92% Adult Jail 10 ,506,527 9 ,680 ,930 825 ,597 100% 92% Court Security 286 ,602 275,256 11,346 100% 96% Emergency Services 192,925 175,658 17 ,267 100% 91% Special Services 928,217 801,957 126,261 100% 86% Work Center 3,018,466 2 ,887,831 130,635 100% 96% Training 197,961 162,854 35,107 100% 82% Other (CODE, Forensic) 632,256 609,000 23,256 100% 96% Non Dept -ISF Charges 36,689 36 ,689 100% 100% Non Dept -Jamison DIS 200,000 200,000 100% 100% Contingency 2,197 ,536 2,197 ,536 100% 0% Total to Fund 255 22,084,821 18,483,539 3,601,282 Transfer to Reserve Fund (703) 100,000 100,000 100% 100% Total Requirements 22,184,821 18,583.539 3,601 ,,281 100% 84% Net 5,863,246 5,863,246 Page 4 Beg NWC per FY 2013 Budget 4,507,352 1 Fund 702 LED Rural Statement of Financial Operating Data Year Ended June 30, 2012 (PRE RESOURCES: Beg. Net Working Capital $2,936,523 $3,004,533 $ 68,010 100% 102% Revenues Tax Revenues -Current 7,348,125 7,578,675 230,550 100% 103% Tax Revenues -Prior 257,000 371,487 114,487 100% 145% Federal Grants & Reimb 12,000 32,343 20,343 100% 270% Federal Grants-BLM 25,000 23,510 (1,490) 100% n/a US Forest Service 78,750 59,063 (19,688) 100% 75% State Grant 200,972 175,720 (25 ,252) 100% 87% SB #1065 Court Assessment 60,000 52,957 (7,043) 100% 88% Marine Board license Fee 142,332 125,136 (17,196) 100% 88% Bureau of Reclama1ion 28,871 28,871 100% n/a Des Cly General Fund Grant 576,144 434,144 (142,000) 100% 75% Des Cty Transient Room Tax 2,073,856 2,215,856 142,000 100% 107% Des Cly TaxJFin Contract 540 540 100% City of Sisters 449,961 449,961 100% 100% Des Cly COD Contract 54,366 54,366 100% 100% Des Cly Solid Waste Contr 54,366 54,366 100% 100% Des Cly Clerk/Election 2,000 595 (1,406) 100% 30% School Districts 80,000 35,545 (44.455) 100% 44% Claims Reimbursement 24,719 24,719 100% n/a Security & Traffic Reimb 5,000 7,675 2 ,675 100% 153% Seat Belt Program 12,000 7,595 (4,405) 100% 63% Miscellaneous 8,000 4,018 (3,982) 100% 50% False Alarm Fees 2,000 1,500 (500) 100% 75% Restitution 2 ,239 2,239 100% nla Sheriff Fees 10,000 9,895 (105) 100% 99% Court Fines & Fees 115,000 136,084 21 ,084 100% 118% Impound Fees 7,000 4,900 (2,100) 100% 70% Restitution -Street Crimes 500 13,365 12,865 100% 2673% Seizure/Forfeiture 1,324 1,324 100% n/a Interest 10,000 22,877 12,877 100% 229% Interest on Unsegregated 1,800 769 (1,031) 100% 43% Grants-Private 7,000 7,000 100% n/a Donations 13,755 13,755 100% n/a Sale of Equip & Material 6 ,000 12,253 6,253 100% 204% Sale of Reportable Assets 20 ,000 66,490 46,490 100% 332% Total Revenues 11,6121172 12,029,590 417,418 50% 104% TOTAL RESOURCES 14,548,695 15,034,123 485,428 50% 103% REQUIREMENTS: Fund 255 Departments: Sheriffs Services Auto/Comm Investigations Patrol Records Special Services Training Non Dept -ISF Charges Conti 160,230 1 ,070,088 1,734,218 8,004,704 720,710 406,944 126,304 36,542 954 153,398 981,719 1,527,082 7,853,027 686,502 351,589 103,905 36,542 6,832 88,369 207,136 151 ,677 34,208 55,354 22,399 100% 100% 100% 100% 100% 100% 100% 100% 100 % Exp. %1 96% 92% 88% 98% 95% 86% 82% 100% 0% Transfer to Reserve Fund (704) 100,000 100,000 100% 100% Total Requirements 14,548,695 11 ,793,765 2,754,930 100% 81% Net 3,240 ,358 3 ,240,358 Page 5 Beg NWC per FY 2013 Budget 2,859,9151 PUBLIC HEALTH Statement of Financial Operating Data Year Ended June 30, 2012 (PR Variance Coli. % RESOURCES: Beg. Net Working Capital S 1,596,918 S 1,702,129 S 105,211 100% 107% Revenues Medicare Reimbursement 600 814 214 100% 136% State Grant 2.710.144 2,654,460 (55.684) 100% 98% Child Dev & Rehab Center 24.607 37,401 12.794 100% 152% State Miscellaneous 224.829 240,288 15,459 100% 107% OMAP 523,850 602,733 78.883 100% 115% TitJe 19 352 352 100% nfa Family Planning Exp Proj 520.000 521,744 1,744 100% 100% Local Grants 45.000 120.930 75,930 100% 269% Water Program-Base Fee 42.000 37,544 (4,456) 100% 89% Contract Payments 65.376 65,376 100% nfa Water Program-Field Work 55.817 50,555 (5.262) 100% 91% H20 Sys Insp-Priv Wells 200 (200) 100% 0% Miscellaneous 4,529 4.529 100% nfa Patient Insurance Fees 135.380 178,556 43.176 100% 132% Health Dept/Patient Fees 118,770 101,505 (17.265) 100% 85% Vital Records-Birth 30,600 36,530 5.930 100% 119% Vital Records-Death 100,000 101,745 1.745 100% 102% Environmental Health 704.350 764,027 59.677 100% 108% NSF Fee 60 60 100% nfa Interest on Investments 12,000 10,169 (1.831) 100% 85% Donations 26,030 14,626 (11,404) 100% 56% Interfund Contract 198.387 182,914 (15,473) 100% 92% Administrative Fee 15.056 15.056 -100% 100% Total Revenues 5,487,620 5,741,915 254,295 100% 105% Transfer.sln~enaraIFund 2.317,765 2,317,765 -100% 100% Transfers In-PH Res Fund 30,000 30,000 -100% 100% Transfers In-Gen. Fund Other 65.100 65,100 -100% 100% TOTAL RESOURCES 9,497,403 9,856,908 359,505 100% 104% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfer.s Out Contingency 6,190,732 2.098.694 131,500 286,000 790,477 6,101,477 2,048,445 93.788 286,000 89,255 50.249 37,712 - 790,477 I EXP.%I 100% 99% 100% 98% 100% 71% 100% 100% 100% nfa TOTAL REQUIREMENTS 9,497.403 8,529,710 967,693 100-/. 90% NET (Resources -Requirements) 1,327,199 1.327.199 Page 6 Beg NWC per FY 2013 Budget 1,336,051 I BEHAVIORAL HEALTH Statement of Financial Operating Data Year Ended June 30,2012 (PRELIMINARY AS OF 8/21/2012) Year to Date Actual Variance RESOURCES: Beg. Net Working Capital $ 3,268,759 $ 3,108,163 $ (160,596) 100% 95% Revenues Marriage Licenses 5,500 5,775 275 100% 105% Divorce Filing Fees 133,000 144,427 11,427 100% 109% Domestic Partnership Fee 100 75 (25) 100% 75% Federal Grants 276,647 268,784 (7,863) 100% 97% State Grants 6,964,202 7,822,336 858,134 100% 112% State Miscellaneous 124,173 63,452 (60,721) 100% 51% ABHA 164,728 164,728 100% nfa Title 19 282,297 223,654 (58,643) 100% 79% Liquor Revenue 105,000 137,168 32,168 100% 131% School Districts 75,600 87,200 11,600 100% 115% Miscellaneous 14,000 8,571 (5,429) 100% 61% Patient Insurance Fees 113,700 201,869 88,169 100% 178% Patient Fees 1,807 1,026 (781) 100% 57% Interest on Investments 25,000 25,179 179 100% 101% Rentals 13,100 17,375 4,275 100% 133% Donations 108 108 100% nfa Administrative Fee 4,429,689 4,390,059 (39,630) 100% 99% Sheriff 20,000 (20,000) 100% 0% Forfeitures 12,825 12,825 100% nfa Interfund Contract-Gen Fund 127,000 127,000 -100% 100% Comm. on Children & Fam 1,450 1,450 100% nfa Total Revenues 12,710,815 13,703,061 992,246 100% 108% Transfers In-General Fund 1,263,515 1,263,515 -100% 100% Transfers In-OHP-CDO 271,402 396,077 124,674 100% 146% Transfers In-Acute Care SVC8 252,515 252,515 -100% 100% Transfers In-ABHA 300,863 387,473 86,610 100% 129% TOTAL RESOURCES 18,067,869 19,110,804 1,042,934 100% 106% REQUIREMENTS: I Exp. %1 Expenditures Personal Services 10,428,186 9,566,359 861,827 100% 92% Materials and Services 5,805,749 5,975,457 (169,708) 100% 103% Capital Outlay 390,000 169,892 220,108 100% 44% Transfers Out 286,000 286,000 -100% 100% Contingency 1,157,934 1,157,934 100% nfa TOTAL REQUIREMENTS 18,067,869 15,997,709 2,070,160 100% 89% NET (Resources -Requirements) 3,113,095 3,113,094 Beg NWC per FY 2013 Budget 3,320.9681 Page 7 I COMMUNITY DEVELOPMENT Statement of Financial Operating Data Year Ended June 30, 2012 (PRELIMINARY AS OF 8/21/2012) RESOURCES: Beg. Nat Working Capital $ 229,822 131,776 $ (98.046) 100% 57'. Revenues Admin-Operations 24,350 27,689 3,339 100% 114% Admin-GIS 1,000 1,721 721 100% 172% Admin-Code Enforcement 166,700 180,096 13,396 100% 108% Building Safety 1,200,880 1,063,788 (137,092) 100% 89% Electrical 259,150 236,706 (22,444) 100% 91% Contract Services 160,200 135,053 (25,147) 100% 84% Env Health-On Site Prog 280,400 312,500 32,100 100% 111% Planning-Current 674,900 555,131 (119,769) 100% 82% Planning-Long Range 253,726 251,366 (2,360) 100% 99% Year to Date Final Budget I Actual I Variance I FY% I Coli. % Total Revenues 3,021,306 2,764,051 (257,255) 100% 91% Trans In-GF 729,625 849,625 120,000 100% 116% Trans In.oF for Lng Rng Ping 495,360 495,360 -100% 100% Trans In..other 100 ~100! 100% 0% TOTAL RESOURCES 4,476,213 4,240,812 (235,401) 100% 95% REQUIREMENTS: EXP·%I EXPENDITURES & TRANSFERS Admin-Operations 1,411,818 1,400,848 10,970 100% 99% Admin-GIS 127.755 122,676 5,079 100% 96% Admin-Code Enforcement 204,570 210,021 (5,451) 100% 103% Building Safety 562,032 554,966 7,066 100% 99% Electrical 261,450 214,298 47,152 100% 82% Contract Services 165,689 170,523 (4,834) 100% 103% Env Health-On Site Pgm 143,108 153,457 (10.349) 100% 107% Planning-Current 619,002 594,812 24,190 100% 96% Planning-Long Range 478.806 452,343 26,463 100% 94% Transfers Out (DIS Fund) 173,885 173,885 -100% 100% Contingency 328,098 328,098 100% n/a TOTAL REQUIREMENTS 4,476,213 4,047,830 428.383 100% 90·k NET (Resources· Requirements) 192,982 192,982 Beg NWC per FY 2013 Budget 10,000 I Page 8 ROAD Statement of Financial Operating Data Year Ended June 30, 2012 Vearto Date Actual Variance Coil. % RESOURCES: Beg. Net Working Capital $ 3,417,158 $ 3.417,158 $ 0 100% 100% Revenues System Development Charge 1,617 1,617 100% nfa Federal Reimbursements 600,000 600,000 -100% 100% Federal Grant (ARRA) 20,000 20,000 -100% 100% Mineral Lease Royalties 40,000 143,712 103,712 100% 359% Forest Receipts 1,311,162 1,322,661 11,499 100% 101% State Grant 849,110 849,110 100% n/a State Miscellaneous 500,041 502,659 2,618 100% 101% Motor Vehicle Revenue 11,340,000 10,409,094 (930,906) 100% 92% City of Bend 275,000 30,783 (244,217) 100% 11% City of Redmond 350,000 322,507 (27,493) 100% 92% City of Sisters 10,000 1,135 (8,865) 100% 11% City of La Pine 10,000 (10,000) 100% 0% Admin Recovery (SOC) 1,000 2,439 1,439 100% 244% Miscellaneous 20,000 40,841 20,841 100% 204% Road Vacations 1,000 2,000 1,000 100% 200% Interest on Investments 20,000 20,488 488 100% 102% Parking Fees 144 (144) 100% 0% Interfund Contract 730,000 673,014 (56,986) 100% 92% Equipment Repairs 200,000 278,684 78,684 100% 139% Vehicle Repairs 90,000 77,560 (12,440) 100% 86% LID Construction 10,000 (10,000) 100% 0% Vegetation Management 71,500 60,667 (10,833) 100% 85% Forester 25,000 28,991 3,991 100% 116% Car Washes 3,500 5,162 1,662 100% 147% Car Rental 1,020 1,020 100% nla Sale of Equip & Material 633,000 979,884 346,884 100% 155% Total Revenues 16,261,347 16,374,028 112,681 10004 101-4 Trans In -Solid Waste 285,773 285,773 -100% 100% Trans In -Transp SOC 250,000 250,000 -100% 100% Trans In-Road Imp Res 12,000 (12,000) 100% 0% TOTAL RESOURCES 20,226,278 20,326.959 100,681 100% 100% REQUIREMENTS: I Exp·%1 Expenditures Personal Services 5,615,323 5,344,597 270,726 100% 95% Materials and Services 10,755,112 9,366,630 1,388,482 100% 87% Capital Outlay 1,236,691 75,288 1,161,403 100% 6% Transfers Out 600,000 600,000 -100% 100% Contingency 2,019,152 2,019,152 100% nla TOTAL REQUIREMENTS 20.226,278 15,386,515 4,839,763 100% 76% NET (Resources -Requirements) 4,940,444 4,940,444 Page 9 Beg NWC per FV 2013 Budget 4,719,551 I ADULT PAROLE & PROBATION Statement of Financial Operating Data Year Ended June 30, 2012 (PRELIMINARY AS OF 8/21/2012) I j i Year to Date Final Budget I Actual I Variance IFY% I Coli. % RESOURCES: Beg. Net Working Capital $ 560,000 $ 634,125 $ 74,125 100"0 113°/. Revenues I DOC Measure 57 217,350 219,240 1,890 100% 101% State Miscellaneous 4,301 4,301 -100% 100% I Alternate Incarceration 30,918 (30,918) 100% 0% State Subsidy 13,000 13,826 826 100% 106% SB 1145 2,855,659 2,748,556 (107,103) 100% 96% i Probation Work Crew Fees 24,000 19,120 (4,880) 100% 80% Miscellaneous 4,100 2,882 (1,218) 100% 70% I Electronic Monitoring Fee 170,000 133,523 (36,477) 100% 79% Probation Superv. Fees 200,000 185,864 (14,136) 100% 93% Interest on Investments 9,000 6,161 (2,839) 100% 68% 1 Interfund -Sheriff 50,000 50,000 -100% 100% Crime Prevention Grant 50,000 50,000 -100% 100% CFC-Domestic Violence 74,832 74,834 2 100% 100% Total Revenues 3,703,160 3,508,307 (194,853) 100·/0 95% Transfers In·General Fund 338,292 338,292 -100% 100% TOTAL RESOURCES 4,601,452 4,480,725 (120,727) 100% 97". REQUIREMENTS: I Exp·%1 Expenditures Personal Services 3,168,688 3,053,235 115,453 100% 96% Materials and Services 886,890 768,464 118,426 100% 87% Capital Outlay 100 100 100% 0% Transfers Out 28,800 28,800 -100% 100% Contingency 516,974 516,974 100% n/aI I l TOTAL REQUIREMENTS 4,601,452 3,850,499 750,953 100% 84% NET (Resources -Requirements) 630,226 630,226i Beg NWC per FY 2013 Budget 570,000 I Page 10 I I CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Year Ended June 30, 2012 (PRELIMINARY AS OF 8/21/2012) Year to Date Budget 1 Actual I Variance JFY% J Coli. % RESOURCES: Beg. Net Working Capital $ 467,111 $ 556,143 $ 89,032 100% 119% Revenues Federal Grants 299,488 290.393 (9.095) 100% 97% Title IV -Family Sup/Pres 39,329 39,534 205 100% 101% HealthyStart Medicaid 95,000 64,197 (30,803) 100% 68% Level 7 Services 257,982 196,898 (61,084) 100% 76% State Prevention Funds 24,500 92,301 67,801 100% 377% HealthyStart /R-S-G 311,838 258,203 (53,635) 100% 83% OCCF Grant 545,203 509,825 (35,378) 100% 94% Program Fees 5,813 5,813 100% n/a Charges for Svcs-Misc 8,000 2,887 (5,113) 100% 36% Court Fines &Fees 78,000 86,656 8,656 100% 111% Interest on Investments 5,000 4.517 (483) 100% 90% Donations 71 71 100% n/a Interfund Grants 120,875 320,874 199,999 100% 265% Total Revenues 1,785,215 1,872,169 86,954 100% 105% Trans from General Fund 272,964 272,960 100% 100% ~4~ Total Transfers In 272,964 272,960 (4) 100% 100% TOTAL RESOURCES 2,525,290 2,701,272 175,982 100% 107% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 605,119 1,686,979 100 233,088 590.181 1,536,106 14.938 150,873 100 233,088 I EXP·%I 100% 98% 100% 91% 100% 0% 100% n/a TOTAL REQUIREMENTS 2,525,286 2,126,287 398,999 100% 84% NET (Resources -Requirements) 4 574,985 574,981 Beg NWC per FY 2013 Budget 511,9941 Page 11 SOLID WASTE Statement of Financial Operating Data Year Ended June 30, 2012 (PRELIMINARY AS OF 8/2112012) Year to Date Final Budget I Actual I Variance I FY% I Coil. % RESOURCES: Beg. Net Working Capital $ 1,092,508 $ 1,141.691 $ 49,183 100% 105% Revenues Miscellaneous 22,000 19,405 (2,595) 100% 88% Franchise 3% Fees 200,000 209,954 9,954 100% 105% Commercial Disp. Fees 860,000 871,580 11,580 100% 101% Private Disposal Fees 1,314,000 1,319,273 5,273 100% 100% Franchise Disposal Fees 4,000,000 3,881,491 (118,509) 100% 97% Yard Debris 73,000 92,652 19,652 100% 127% Special Waste 25,000 5,752 (19,248) 100% 23% Interest 7,500 10,430 2,930 100% 139% Leases 1 9,494 9,493 100% n/a Donations 2,880 2,880 100% n/a Sale of Reportable Assets 16,494 16,494 100% n/a Recydables 30,000 78,473 48,473 100% 262% Bond Issuance 5,034,300 5,044,437 10,137 100% 100% Premium 158,434 148,507 ~9,927~ 100% 94% Total Revenues 11,724,235 11,710,820 (13,415) 100% 100·/. TOTAL RESOURCES 12,816,743 12,852,511 35,768 100·"{' 100% REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out-Road Trans Out.Post Closure Trans Out-Equip Reserve Trans Out·Capital Res Contingency 1,671,598 3,086,472 6,075,547 202,000 285,773 400,000 250,000 424,000 421,353 1,605,396 2,913,661 5,992,804 173,407 285,773 400,000 250,000 424,000 66,202 172,811 82,743 28,593 421,353 100% 100% 100% 100% 100% 100% 100% 100% 100% 96% 94% 99% 86% 100% 100% 100% 100% n/a TOTAL REQUIREMENTS 12,816,743 12,045,041 771,702 100% 94°" NET (Resources -Requirements) 807,470 807,470 Beg NWC per FY 2013 Budget 700,5131 Page 12 RISK MANAGEMENT Statement of Financial Operating Data Year Ended June 30, 2012 (PRELlMINA % Coli. RESOURCES: Beginning Net Working Capital $2,100,000 $2,039,937 ($60,063) 100°.4 97°.4 Revenues Inter-fund Charges: General Liability 250,855 250,855 100% 100% Property Damage 311,633 311,633 100% 100% Vehicle 178,310 178,310 100% 100% Workers' Compensation 1,473,944 1,477,736 3,792 100% 100% Unemployment 252,433 254,862 2,429 100% 101% Claims Reimb-Workers' Compensation 5,000 548 (4,452) 100% 11% Claims Reimb-Gen LiablProperty 20,000 65,338 45,338 100% 327% Process Fee-Events/Parades 1,500 2,295 795 100% 153% Miscellaneous 50 (50) 100% 0% Skid Car Training 18.000 14,140 (3,860) 100% 79% Interest on Investments 15,000 13,844 (1,156) 100% 92% Other Interest 50 (50) 100% 0% TOTAL REVENUES 2,526,775 2,569,562 42,787 100% 102% Transfers In-General Fund 200,000 200,000 100% 100% TOTAL RESOURCES 4,826,775 4,809,498 (17,277) 100% 100% Appropriations/Expenditures I %Exp. I Direct Insurance Costs: GENERAl LIABILITY 5201 Settlement / Benefit 123,280 5202 Defense 218,523 5203 Professional Service 11,750 5204 Insurance 131.691 5205 Loss Prevention 6,506 5207 Repair I Replacement 5.517 Total General Liability 475,000 497,268 (22,268) 100% 105% PROPERTY DAMAGE 5204 Insurance 116,418 5207 Repair I Replacement 71,292 Total Property Damage 300,000 187,710 112,290 100% 63% VEHICLE 5203 Professional Service 157 5204 Insurance 376 5205 Loss Prevention 17,252 5207 Repair I Replacement 84,146 Total Vehicle 100,000 101,932 (1,932) 100% 102% WORKERS' COMPENSATION 5201 Settlement I Benefit 939,522 5203 Professional Service 5,000 5204 Insurance 108,993 5205 Loss Prevention 49,204 5206 Miscellaneous 44,357 Total Workers' Compensation 1,200,000 1,147,075 52,925 100°.4 96"0 5201 UNEMPLOYMENT -SettlementiBenefits 250,000 215,051 34,949 100% 86% Total Direct Insurance Costs 2,325,000 2.149,035 175,965 100% 92% Insurance Administration: Personal Services 294,357 274,762 19,595 100% 93% Materials & Service 169,425 137,711 31,714 100% 81% Capital Outlay 100 100 100% 0% Total Insurance Administration 463,882 412,472 51,410 100% 8g<l1o Transfers Out 7,200 7,200 100% 100% TOTAL REQUIREMENTS 2,796,082 2,568,708 227,374 100% 92% NET 2,030,693 2.240,791 210,098 Page 13 Beg NWC per FY 2013 Budget 2,000,000 I DESCHUTES COUNTY 911 Statement of Financial Operating Data Year Ended June 30, 2012 (PRELIMINARY AS OF 8/21/2012) RESOURCES: Year to Date Actual Variance Beg. Net Working Capital $ 6,400,000 $ 7,559,639 $ 1,159,639 100% 118% Revenues Property Taxes -Current 5,983,773 6,253,780 270,007 100% 105% Property Taxes -Prior 200,000 288,923 88,923 100% 144% Federal Grants 184,578 184,578 100% nla State Reimbursement 54,000 29,717 (24,283) 100% 55% Telephone User Tax 750,000 774,298 24,298 100% 103% Grant -Sunriver Serv Dist 22,500 22,500 100% nla Data Network Reimb. 27,200 34,698 7,498 100% 128% Jefferson County 35,000 29,809 (5,191 ) 100% 85% User Fee 52,000 8,625 (43,375) 100% 17% Police RMS User Fees 199,000 209,196 10,196 100% 105% Contract Payments 32,000 33,061 1,061 100% 103% Miscellaneous 9,000 10,712 1,712 100% 119% Contracted Training 4,943 4,943 100% nla Interest 35,000 54,780 19,780 100% 157% Interest on Unsegregated Tax 800 633 (167) 100% 79% Donations 750 750 100% n/a Total Revenues 7,377,773 7,941,002 563,229 100% 108% TOTAl RESOURCES 13,777,773 15,500,641 1,722,868 100% 113% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 4,240,834 1,927,356 1,134,620 500,000 5,974.963 3,824,724 1,750,150 551,676 500,000 416,110 177,206 582.944 5.974,963 100% 100% 100% 100% 100% % Exp·1 90% 91% 49% 100% n/a TOTAl REQUIREMENTS 13,777,773 6,626,550 7,151,223 100% 48% NET (Resources Requirements) 8,874,091 8,874,091 Beg NWC per FY 2013 Budget 8,000,000 I Page 14 Health Benefits Trust Statement of Financial Operating Data Year Ended June 30, 2012 (PRELIMINARY AS OF 8121/2012) Actual RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges prr Emp -Add'i Prem Employee Prem Contribution COIC Retiree 1 COBRA Co-Pay Fees for Clinic Services Federal Payment (ERRP) Prescription Rebates Claims Reimbursements Vending Machines (Wellness Rebate) Interest S 15.500.000 S 12,015,711 50,000 630,000 1,260,000 500,000 80,000 15.829.888 S 12,070,571 30,821 602,405 1,230,390 835,024 200 150,431 127,342 654,056 111 99,992 329.888 54,860 (19,179) (27,595) (29,610) 335,024 200 150,431 127,342 654,056 111 19,992 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 0 100% 62% 96% 98% 167% nfa nJa nJa nfa nfa 125% Total Revenues 14.535.711 15.801.341 1.265,633 100% 109% TOTAL RESOURCES 30,035,711 31.631.233 1.595,522 92% 105% REQUIREMENTS ! EXP.%! Expenditures: Personal Services 151,218 142.448 8,770 100% 94% IIIltterlais &Services Claims Paid-Medical/Rx 13,518,284 12,954,554 563,730 100% 96% Claims Paid-DentallVision 2,019,974 1,912,285 107,689 100% 95% Refunds (149,503) 149,503 100% nla Insurance Expense 350,000 355,451 (5,451 ) 100% 102% State Assessments 150,000 155,263 (5,263) 100% 104% Administration Fee 320,000 318,485 1,515 100% 100% PPOFee 50,000 48,922 1,078 100% 98% Health Impact 55,000 51,621 3,380 100% 94% Other -Administration 62,318 113,432 (51,114) 100% 182% Other -Wellness 78,844 28,852 49,992 100% 37% Admin &Wellnes. 16,755.638 15.931,810 823,828 100% 95% Deschutes On-site Clinic Healthstat 957,200 736,901 220,299 100% 77% MedicationsiOrugsIVacc 325,000 141,871 183,129 100% 44% Medical Supplies 3,000 23,888 (20,888) 100% 796% Equipment 4,000 150 3.850 100% 4% Miscellaneous 5,450 10,795 (5,345} 100% 198% Total DOC 1.2M•• 913,604 381,046 100% 71% Deschutes On-site Pharmacy Medications/DrugsIVacc 115.439 (115.439, 100% nJa Remodeling Costs 152,157 (152,157} 100% nla Total Pharmacy Capital Outlay Contingency 200 11,985,223 267,596 (267.596) 200 11,985,223 100% 100% 100% nJa nfa nla TOTAL EXPENDtREQUIREMNTS 30,035.711 17,113.010 12,931,471 100% 57% NET (Resources· Requirements) 14.518.223 14.526.993 Beg NWC per FY 2013 Budget 13,800.000 I Page 15 Deschutes County -Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Year Ended June 30, 2012 (PRELIMINARY AS OF 8/21/2012) Year to Date Budget I Actual I Variance IFY % IColi. % RESOURCES: Beg. Net Working Capital $ 75,000 $ (40,601) S (115,601) 100"1. -54% Receipts: Special Events Revenues 605,000 530,870 (74,130) 100% 88% Interest 1,500 158 (1,342) 100% 11% Storage 58,000 37,015 (20,985) 100% 64% Camping at F & E 6,000 19,240 13,240 100% 321% Horse Stall Rental 30,000 27,116 (2,885) 100% 90% Concession % -Food 220,000 141,940 (78,060) 100% 65% Rights (Signage, etc.) 112,000 124,000 12,000 100% 111% Grants 33,424 33,424 100% nfa Interfund Contract 47,000 47,000 -100% 100% Miscellaneous 6,807 10,491 3,684 100% nfa Total Receipts 1,086,307 971,254 (115,053) 100% 89% Transfers In General Fund (001 ) 170,000 370,000 100% 218% Room Tax (160) 25,744 25,744 100% 100% Welcome Center (170) 82,800 82,800 100% 100% Annual County Fair (619) 220,000 220,000 -100% 100% Reserve Fund (617) 100 100,000 99,900 100% Total Transfers In 498,644 798,544 99,900 GF Appropriation Transfer 97,295 TOTAL RESOURCES 1,757,246 1,729,197 (28,049) 100% 98% REQUIREMENTS: 1 Exp. %1 Expenditures: Personal Services 846,018 819,339 26,679 100% 97% Materials and Services 786,060 751,109 34,951 100% 102% Debt Service 115,068 113,695 1,373 100% 99% Capital Outlay 100 100 100% 0% Total Expenditures 1,747,246 1,684,142 63,104 Transfers Out -Reserve Fund' 10,000 10,000 -100% 100% Contingency -100% nfa TOTAL REQUIREMENTS 1,757,246 1,694,142 63,104 100% 99% NET (Resources -Requirements) 35,055 35,055 Beg NWC per FY 2013 Budget 46,373 1 Page 16 i Deschutes County and CSDs Comparison of Actual and Budgeted Beginning Net Working Capital July 1, 2012 PRELIMINARY, as of 8/10/2012· Additional FY 2012 Revenues and Expenditures WILL BE recorded Contingency, Reserve for Future Exp & Fund # BUDGETED ACTUAL $ Difference % Difference UnappropriatedFund Name I, 1 811012012 I I Deschutes County and CSDs Comparison of Actual and Budgeted Beginning Net Working Capital July 1. 2012 PRELIMINARY, as of 8/10/2012· Additional FY 2012 Revenues and Expenditures WILL BE recorded Contingency. Reserve for Future Exp & Fund # Fund Name BUDGETED ACTUAL $ Difference % Difference Unappropriated PROJECT FUNDS -~142-Genelin5ountYProjects -~-1 ,406.-060----t.770~480__ 370~480--2ifS"%­1.605,036 462 North CoSvc-suiiding­-300,000-­570.090 2io;090 ­ . 90.0% -313.513 ... 613 -SOiidWaSte Cap Projects--~---1.279,463 .. -1.469.073--189.610 -­-. --14~8"10 -223.839 143 General Capital Reserve 1.711.000---1.71 f.395 ~---395--' -­-0.0% --­-222,281 ~O--[ocallmpr District -------~.. -­169,872 ---_--169.~-'~-­.. --(26,-­. 0.0% ----:!3J'i.?~_ -457-Jamison7.:Cq & Remodel - ­-~---590,000­-540.764 (49.236) --·8,3%--­ 4.E>3 __£a_mells imel"()"emE!.ri!--~7.s:6.000 __ -~_-629Z~0 __(I?Q.2~0)~ -·16JJ:~~~=_}!2,7~~ DEBT SERVICE FUNDS -500-Fairgrounds OS ---~ 250.066------:ff3.431 ... --63~431-~-.... 25.4'*,------10-0.-000 560-­-PUbiiCSafety 05--' -3f3]OO·········~-·-~:371.950 -58.950'­_18:~% ~_ 150.000 -­731 Bend Library OS­-145.000 169,379 24.379 16_8% -58.206 -575PERS DIS ...... J3t1JQ<[=---'-98.83~_ - -11.833 13.6% ---87,000 -524---Li52007 (BOTe) 7.851-7.85f----N/A'­48,277 --5:25-LID 2009 (BOTC)---­. -­--5.955-' ---5.955 -­-N/A ---------zz.725 -751--sunriveriJbraryOS­__ ~i§,()6o_-,~ -17,368 -----2~308 --15.4% ----~ 8,000 -530 COD Bldg OS 13,000 -~15.237­-----2.237 -­-jzj%____=_ 12.60Q 539 Full Faith & Credit 2008 -121.000-----122:s9if--~-f;S9C)· -.--. 1.3% 535 Full Faith & Credit 2003 45.000----46]18-­1,318 -·----2.9% ---32,413 ... 541--'FliliF8.lih&Credit. 201() -­168.000-­169.238-T238 ~-----(fio/~--190.868 -536­Full Faith & Credit200S---­~ 3,600 . --4.146 ---­-546-~--15.2%-'-3.200 40--HHS/BJCCDS ------­--. 8,500 . ----8,930-----430--­5.1%-­8.050 38 Full Faith & Credit 2007 ~~Ooo ---...­.. ~_-'.273,287-~@~!1.3)__ ---=8!~--=~-~.?§a.oOO .. ---­--­..... ~~,-,-.-~------.-.. -~--------,,---------------~--. RESERVE FUNDS 611 La::':'nd~fi'"'II=-=C::-lo-s-ur~e -----~--9H.158 973~73-1-~ 62,5~--6.9%---340,158 614 Solid Waste Equip Res 101.429-~-149,766 48.337 ...... 47.7%:---W3.324 140-'· ~··Development ---......~--~2,953,581······-~·2:996~····· 43.333 ··-T.5%.-~-=~4381687 703 LED County Capital Reserve "'-~-;a54--_321 ,O~_1.177 ....._~ 0.4%_ ....~. .612' Landfill Postclosure 512,203 512,707 504 0.1%514,203 135 .. PERS Reserve ..-.~,-_....­11,390,000 ---11~,390A9'1'---~""""-0.00/0 -­9,664.000 721­ExtenSion4-HBld9Res---~-277,150­--­277,593--~-443---0.2% ~,800 -114-A&T ReserVe---~=_~ 535,00() .. 535,351· --~--6:1%· -346.923 -710-Des Co 9~Equip Res 1.800,000 1 ,800.170 -~17O;--------O:O%--2.304,000 335~dlmprovementRes--~-----T2.i84-----12.19O 6 ....... 0.0%--------:ro:284 --261-~bepartment Reserve 427,135 426,754(381)-----::0:1%-·-370.139 -~704 LED Rural CapjuiiReserve-·f,162.351 ·-----T.f6'1.777 ... (574):-­--­0.0% --­--.­ 111---COurt Technology Reserve ____~. __ !ii.107 ~-51,010=----(697f---~-:.~-_~_51. 707 ~:countYWide Trans SOC . 455,790 454,125 (1.665). -0.4% , 583.290 -617 Fair&ExpoCenlerReserVe~---650.082-----554.744 -~(95.338r--·14~-578.082 ._ 256 -Communication Sy~fR~~.. _~-=_.... ~__... ..--____~___ --NlA.--. ___ ?01.000 Total 7.167,585 ' 75.638,473 811012012