Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Tax-Finance Update
Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA November 5, 2012 (1) Monthly Investment Report (2) September 2012 Financials Commercial Paper Corporate Notes Time Certificates U. S. Treasuries Federal Agencies Bankers' Acceptances LGIP/BOTC $ 0.00% 12,963,439 12.45% 7,236,401 6.95% 3,941,893 Total Portfolio; By Investment Types TimeCorporate CertificatesNotes 7%12% Federal Agencies 4% LGIP/BOTC 77% Investments By County Function General $ 104,137,565 Total Investments $ 104,137,565 Total Investment Income Less Fee: 5% of Invest. Income Lnvestment Income -Net Investment Income Fiscal Year 2012-13 Sep-12 I I Y-T-D I $ 55,766 $ 175,243 -- J 55,766 175,243 (2, 788l (8, 762 l 1$ 52,978 $ 166,481 ! Category Maximums; U.S . Treasuries 100°/. LGIP 100"'. Federal Agencies 75%~ , Banker's Acceptances 25% Time Certificates 25% Commercial Paper 20% Co~orate Notes 10-/. c t 3 Month T reas. ~ 0.10% 12 Month Treas. ~ 0.17% 3MonthCP ~ 0. 12% Averag~M.turt!y In Day. General ---647 731 05/01/13 527 05/20/11 I 05/20/13 731 =-H-ci~~~~~~; I ~~~~~~~; ~~; 10/26111 I 08/01/13 09/19/12 12/05/11 ~ ~,,----"-----.-- 07/09/12 3.550% 5:500%[ 1.1§!j% 1.300% 0.650% 0.500% 2,0~!,34(),00 1_~(),0_00.00 100,000.0!L ... 1.8!l1,70~'.oo . 2, 124,000~OO .2QO,QOO·OO ~,O()g,OOO.OO . 2,000.000~09 2 Market Value 2,120,202.78 N/C N/C N/C -~--. N/C 141,563.53 j N/C 101,786.89: N/C..----.... , ·t--··-~ __!..!l25,492....~~Q I· 1f\J£C 2,158,888.89 i N/C .20~,~1~'!.4 i ..~N/C .. 2,O~.E>,397~? • N/C 2.015,194.441· N/Cr t .. L.,u~,\J~\J:':I\J'i +....<"!,201 ~Q81·33 .."'ILC 1 00,005,00!+ ..~......1.....0()'.~...f)~.... 08......i.. "r.~tIIC141,336.11 ; N/C 2,019,825.00~ .' NlC ~,016-,":00.()()J ! 241,946.67 : 242~io,.Qor 24,141,732.77 75,618,840.77 0.00% 12.45% 6.95% 0.00%...........,.. + ..._-- 3.79% 0.00% 76.82% . 100.00% Memorandum Date: October 15, 2012 To: Board of County Commissioners Erik Kropp, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find September 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 Three Months Ended September 30, 2012 Year to Date Year End $ Actual Variance Variance RESOURCES: Beg. Net Working Capital $ 8,700,000 Revenues Current & Prior Taxes 5,219,290 Gen. Rev .• excl. Taxes 595,433 Assessor 187,157 County Clerk 345,006 BOPTA 3,100 District Attorney 46,174 Finance/Tax 49,725 Veterans 17,100 Property Management 24,811 Grant Projects 500 $ 9,059,394 573,212 1,435,249 207,167 404,354 4,117 24,228 82,321 225 23,561 500 $ 359,394 100% (4,646,078) 25% 839,816 25% 20,010 25% 59,348 25% 1,017 25% (21,946) 25% 32,596 25% (16,875) 25% (1,250) 25% ° 25% 1040/. 3% 60% 28% 29% 33% 13% 41% 0% 24% 25% 11% 34% a) b) c) c) c) d) $8,700,000 20,877,160 2,381,731 748,626 1,380,023 12,398 184,694 198,900 68,400 99,244 2,000 $ 9,059,394 $ 359,394 20,877,160 2,381,731 748,626 1,380,023 12,398 184,694 198,900 68,400 99,244 2,000 Total Revenues 6,488,296 2,754,935 (3,733,361) 25% 25,953,176 25,953,176 TOTAL RESOURCES 15,188,296 11,814,329 (3,373,967) 25% 34,653,176 35,012,570 359,394 REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non-Departmental Contingency Transfers Out TOTAL REQUIREMENTS NET (Resources -Requirements) 885,307 366,910 18,096 1,318,667 208,466 65,248 68,007 30,587 406,168 1,941,676 5,309,132 3,264,163 8,573,295 6,615,002 823,380 302,317 15,717 1,218,065 213,370 58,597 66,280 29,393 209,718 2,936.837 3,302,949 6,239,786 5,574,543 61,927 64,593 2,379 100,602 (4,904) 6,651 1,727 1,194 196,450 1,941,676 2,372,295 (38,786l 2,333,509 (1,040,458) I Exp. %1 25% 23% 25% 21% 25% 22% 25% 23% 25% 26% 25% 22% 25% 24% 25% 24% 25% 13% 25% nfa 25% 14% 25% 25% 25% 18% e) f) 3,541,227 1,467,638 72,385 5,274,667 833,865 260,992 272,027 122,349 1,624,671 7,766,703 21,236,524 13,056,652 34,293,176 360,000 3,541,227 1,467,638 . 72,385 5,274,667 833,865 260,992 272,027 122,349 1,624,671 13,469,821 13,056,652 26,5261473 8,486,097 7,766,703 7,766,703 7,766,703 8,126,097 a) Current year taxes not due until November b) Includes annual payments: PIL T $730,983 c) A &T Grant received quarterly-July, October, January & April d) State payment received quarterly e) Budget includes $576,736 payment to LED#2. Will not be expended until June 2013 f) Appropriation Transfers (authority to expend): County School Fund $360,000 Page 1 I f t f ! I \ l COMM JUSTICE-JUVENILE Statement of Financial Operating Data Three Months Ended September 30,2012 BudQet I Year to Date Actual I Variance IFY% I Coil. % FY 2013 YearEnd BudQet Projection Variance RESOURCES: 8eg. Net Working Capital $1,010,415 $ 995,051 $ (15,364) 100% 98% $1,010,415 $ 995,051 $ (15,364) Revenues Federal Grants 1,500 (1,500) 25% 0% a) 6,000 6,000 SB #1 065-Court Assess. 12,500 5,335 (7,165) 25% 11% 50,000 50,000 Discovery Fee 3,250 1,810 (1,440) 25% 14% 13,000 13,000 Food Subsidy 5,250 4,086 (1,164) 25% 19% 21,000 21,000 OY A Basic & Diversion 93,837 (93,837) 25% 0% b) 375,347 375,347 Inmate/Prisoner Housing 15,000 23,400 8,400 25% 39% c) 60,000 85,000 25,000 Inmate Commissary Fees 25 (25) 25% 0% 100 100 Contract Payments 30,500 4,607 (25,894) 25% 4% d) 122,000 122,000 Miscellaneous 50 (50) 25% 0% 200 200 Program Fees 13 (13) 25% 0% 50 50 MIP Diversion Fees 250 225 (25) 25% 23% 1,000 1,000 Interest on Investments 2,000 1,696 (304) 25% 21% 8,000 8,000 Leases 300 300 25% 25% 1,200 1,200 Grants -Private 125 719 594 25% 144% c) 500 1,100 600 CFC Interfund Grant 31,415 (31,415) 25% 0% a) 125,661 125,661 Interfund Grant -Gen Fund 5,000 ~5,000~ 25% 0% a) 20,000 20,000 Total Revenues 201,015 42,177 (158,838) 25% 5% 804,058 829,658 25,600 Transfers In-General Fund 1,336,131 1,336,131 25% 25% 5,344,523 5,344,523 TOTAL RESOURCES 2,547,561 2,373,359 (174,202) 25% 33% 7,158,996 7,169,232 10,236 REQUIREMENTS: Expenditures Community Justice-Juvenile Personnel Services 1,268,754 1,241,174 27,580 1 Exp. %1 25% 24% 5,075,017 5,075,017 Materials and Services Capital Outlay Transfers Out Contingency 298,490 25 12,600 209,880 243,416 12,600 55,074 25 209,880 25% 25% 25% 25% 20% 0% 25% n/a 1,193,960 100 50,400 839,519 1,193,960 100 50,400 839,519 TOTAL REQUIREMENTS 1,789,749 1,497,190 292,559 25% 21% 7,158,996 6,319,477 839,519 NET (Resources -Requirements) 757,812 876,169 118,357 849,755 849,755 a) Grants received quarterly b) Payments received quarterly c) Revenues trending higher than anticipated d) Contract payment reimbursement requests submitted monthly, receive 1-2 months in arrears Page 2 SHERIFF -Fund 255 Statement of Financial Operating Data Three Months Ended September 30,2012 RESOURCES: Year to Date Actual Variance Variance $ $ 9,250,830 7,618,037 (1,632,793) 9,250,830 7,618,037 (1,632,793) 565,908 596,267 (30,359) 199,747 164,180 35,567 450,156 621,047 (170,891) 377,045 367,734 9,311 2,067,340 1,929,814 137,526 179,404 147,333 32,071 2,585,518 2,416,248 169,270 75,750 76,072 (322) 48,633 46,778 1,855 336,509 341,746 (5,237) 665,770 628,446 37,324 126,238 101,260 24,978 160,876 159,800 1,076 21,313 21,313 (0) 1,390,623 1,390,623 Beg. Net Working Capital $ Total Revenues TOT AL RESOURCES REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division Civil Automotive/Communications I nvestigations/E vidence Patrol/Civil/Comm Supp Records Adult Jail Court Security Emergency Services Special Services Division Regional Work Center Training Division Other Law Enforcement Svcs Non-Departmental Contingency TOTAL REQUIREMENTS 9,250,830 7,618,037 1,632,793 NET (Resources -Requirements) 100% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% n/a $ $ 20% " 22,56 1,626 18,956,193 21% " 21% 21% Exp. %1 26% 21% 34% a) 24% 23% b) 21% 23% b) 25% 24% 25% 24% 20% 25% 25% n/a 21% 37,003,318 31,344,452 37,003,318 31,344,452 2,263,630 2,263,530 798,989 798,889 1,800,625 1,805,150 1,508,180 1,508,080 8,269,358 8,219,358 717,617 717,517 10,342,072 10,292,072 303,001 302,901 194,533 194,433 1,346,037 1,346,037 2,663,078 2,662,978 504,950 504,850 643,504 643,404 85,253 85,253 5,562,491 37,003,318 31,344,452 $ (3,605,433) (5,658,866) (5,658,866) 100 100 (4,525) 100 50,000 100 50,000 100 100 100 100 100 5,562,491 5,658,866 " Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures a) FY 2013 appropriated amount, $360,690 for payment Deschutes County Communication System Fund expended in July 2012 b) Projected variance due to delays in filling open positions Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data Three Months Ended September 30 , 2012 Actual Variance Variance RESOURCES: Beg. Net Working Capital $4,507,352 $ 5,883,963 $ 1,376,611 100% 131% $ 4,507 ,352 $5,883,963 $ 1,376,611 Tax Revenues -Current 3 ,846,435 (3 ,846,435) 25 % 0% a) 15 ,385 ,740 15 ,385,740 Tax Revenues -Prior 110 ,000 420,234 310,234 25 % 96 % 440 ,000 440,000 Federal Grants & Reimb 7 ,500 (7,500) 25 % 0% 30 ,000 30,000 State Grant 18,500 9 ,019 (9 ,4 81 ) 25 % 12% 74,000 74 ,000 Transp. of State Wards 1,250 (1,250) 25 % 0% 5 ,000 5,000 SB 1145 369,998 369,998 (0) 25 % 25 % 1,479,991 1,479,99 1 Prisoner Housing 12 ,500 (12,500) 25 % 0% 50 ,000 50,000 Des . Cty Video Lottery Grant 1,250 5,000 3 ,750 25 % 100% 5 ,000 5 ,000 Des Cty Court Security 60 ,250 60 ,028 (222) 25 % 25 % 24 1,000 241 ,000 Des Cty Juvenile Contract 1,045 (1,045) 25 % 0% 4,180 4 ,180 Title III Reimbursement 25 % nfa b) 39,916 39,9 16 Transport 125 486 361 25 % 97 % 500 500 Other 875 6 ,500 5,625 25 % 186% 3 ,500 6,500 3 ,000 DC Fair & Expo Center 1,000 756 (244) 25 % 19% 4 ,000 4,000 Inmate Commissary Fees 2 ,500 1,518 (982) 25% 15% 10,000 10 ,000 Work Center Work Crews 12 ,500 6 ,965 (5 ,535) 25 % 14% 50 ,000 50 ,000 Concealed Handgun Classes 875 1,650 775 25 % 47 % 3 ,500 3,500 Inmate Telephone Fee 20 ,000 5 ,710 (14 ,290) 25 % 7% 80 ,000 80 ,000 Soc Sec Incentive-Fed 1,250 4 ,000 2,750 25 % 80 % 5,000 5 ,000 Miscellaneous 1,250 1,745 495 25 % 35 % 5 ,000 5,000 Oregon Mentors 250 (250) 25 % 0% 1,000 1,000 Debit Card Fee 25 109 84 25 % 109% 100 200 100 Medical Services Reimb 3,250 259 (2,991 ) 25 % 2% 13,000 13,000 Restitution 1,250 (1 ,250) 25 % 0% 5,000 5,000 Sheriff Fees 62,500 58,382 (4,118) 25 % 23 % 250 ,000 250 ,000 Interest 7 ,083 7 ,095 12 25 % 25 % 28 ,333 28,333 Interest on Unsegregated 883 106 (777) 25 % 3% 3 ,533 3,533 Donations -"Shop with a Cop" 12 ,974 11,288 (1 ,686) 25 % 22 % 51 ,897 51 ,897 Sale of Reportable Assets 1,250 (1 ,250) 25 % 0% 5 ,000 5 ,000 Year to Date Total Revenues 4,558 ,568 970,848 (3,587 720} 25% 5% 18,234,274 18,277,290 43 ,016 z TOTAL RESOURCES 9 ,065,920 6,854,810 (2,211 ,110) 25% 30% 22,741 ,626 24,161,253 1,419,627 REQUIREMENTS: Fund 255 Departments : Sheriff's Services Civil AutolComm Adult Jail Court Security Emergency Services Special Services Work Center Training Ot her (CODE, Forensic) Non Dept -ISF Charges Contingency Total to Fund 255 528 ,314 199,747 165,995 2 ,585,518 75 ,750 48,633 232 ,844 665 ,770 77 ,169 160,876 10 ,678 889,112 5 ,640.407 556 ,657 164 ,180 229 ,011 2,416 ,248 76,072 46 ,778 236,467 628,446 61 ,900 159,800 10,678 4.586,238 (28 ,343) 35 ,567 (63,0 16) 169,270 (322) 1,855 (3,623) 37 ,324 15,269 1,076 (0) 889,112 1,054.169 1 Exp. %1 25% 26% 25% 21% 25% 34% 25% 23% 25% 25% 25% 24% 25% 25% 25% 24% 25% 20% 25% 25% 25% 25% 25% nla 2, 113,257 798 ,989 663 ,980 10 ,342 ,072 303,001 194,533 931,377 2 ,663,078 308 ,676 643 ,504 42 ,712 3,556,447 22.561.626 2,113,164 798,889 665,649 10 ,292 ,072 302 ,901 194,433 931 ,377 2,662,978 308,615 643,404 42,712 18,956.193 93 100 (1 ,669) 50 ,000 100 100 100 61 100 3,556,447 3,605,433 Transfer to Reserve Fund (703) Non Dept -Comm System Res Total Requirements 25,000 20,000 5 ,685,407 4,586 ,238 25 ,000 20 ,000 1,099,168 25% 25% 25% 0% 0% 20% 100,000 80 ,000 22 ,741 ,626 100.000 80,000 19,136,193 3,605,433 Net 3 ,380 ,514 2 ,268,573 (1 ,111 ,94 1) 5 ,025,059 5,025 ,059 a) Current year taxes not due until November b) Approved carryover of prior year Title III funds • Payment to Sheriffs Fund adjusted monthly to equa l actual expenditures attributable to countywide services . Page 4 Fund 702 LED Rural Statement of Financial Operating Data Three Months Ended September 30, 2012 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues -Current Tax Revenues -Prior Federal Grants & Reimb Federal Grants-BlM US Forest Service Bureau of Reclamation State Grant SB #1065 Court Assessment Marine Board License Fee Des Cty General Fund Grant Des Cty Transient Room Tax Des Cty Tax Office Contract City of Sisters Des Cty CDD Contract Des Cty Solid Waste Contr Des Cty Clerk/Election School Districts Security & Traffic Reimb Seat Belt Program Miscellaneous False Alarm Fees Restitution Sheriff Fees Court Fines & Fees Impound Fees Restitution -Street Crimes Seizure/Forfeiture Interest Interest on Unsegregated Grants-Private Donations Sale of Equip & Material Sale of Reportable Assets $ 2,859,915 1,887,500 57,500 3,750 6,500 18,750 6,500 47,299 13,750 35,523 144,184 518,316 125 116,990 13,592 13,592 250 10,000 1,250 2,500 1,500 500 1,250 2,500 30,000 1,000 125 250 2,500 450 2,500 10,000 $3,244,571 207,659 24,751 5,335 518,316 116,990 13,592 13,592 1,330 3,577 1,200 45 3,068 28,258 1,800 3,281 53 1,500 2,500 432 $ 384,656 100% (1,887,500) 25% 150,159 25% (3,750) 25% (6,500) 25% (18,750) 25% (6,500) 25% (22,548) 25% (8,415) 25% (35,523) 25% (144 ,184) 25% 0 25% (125) 25% 0 25% 25% 25% (250) 25% (10,000) 25% (1 ,250) 25% (1,170) 25% 2,077 25% 700 25% (1,205) 25% 568 25% (1,742) 25% 800 25% (125) 25% (250) 25% 781 25% (397) 25% 1,500 25% 2,500 25% (2 ,068) 25% (10,000) 25% 113% 0% 90% 0% 0% 0% 0% 13% 10% 0% 0% 25% 0% 25% 25% 25% 0% 0% 0% 13% 60% 60% 1% 31% 24% 45% 0% 0% 33% 3% nla n/a 4% 0% a) $ 2,859,915 7,550,000 230,000 15,000 26 ,000 75,000 26,000 189,194 55,000 142,091 576,735 2,073,265 500 467,960 54,366 54,366 1,000 40,000 5,000 10,000 6,000 2,000 5,000 10 ,000 120,000 4,000 500 1,000 10,000 1,800 10,000 40,000 $3,244,571 7,550,000 230,000 15,000 26,000 75,000 26 ,000 189,194 55,000 142,091 576,735 2,073,265 500 467,960 54,366 54,366 1,000 40,000 5,000 10,000 6,000 2,000 5,000 10,000 120,000 4,000 500 1,000 10,000 1,800 1,500 2,500 10,000 40,000 $ 384,656 1,500 2,500 Total Revenues 2,950!446 947,278 l2,O03,1671 50% 8% 11,801,777 11!805,777 4,000 TOTAL RESOURCES REQUIREMENTS: Fund 255 Departments: Sheriffs Services Auto/Comm Investigations Patrol Records Special Services Training Non Dept -ISF Charges Co ntingency 5,810,361 37,593 284,161 377,045 2 ,067,340 179,404 103,665 49,069 10,635 501 ,511 4,191,848 39,610 392 ,036 367,734 1,929,814 147,333 105,278 39,360 10,635 (1,618,512) (2,017) (107,875) 9,311 137,526 32,071 (1 ,613) 9,709 (0) 501 511 50% 29% I Exp. %1 25% 26% 25% 34% 25% 24% 25% 23% 25% 21% 25% 25% 25% 20% 25% 25% 25% n/a 14,661,692 15,050,348 150,366 1,139,501 1 ,508,080 8,219,358 717,517 414,660 196,235 42,541 388,656 7 (2,856) 100 50,000 100 39 Transfer to Reserve Fund (704) Non Dept -Comm System Res Total Requirements Net 25,000 30,000 3,665,423 2 ,144,938 a) Current year taxes not due until November 3,031,800 1,160,049 25,000 30,000 633,623 (984,889) 25% 25% 25% 0% 0% 21% 100,000 120,000 14 ,661,692 100,000 120,000 12,608,259 2,442,089 2,053,433 2,442,089 Page 5 • Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services. PUBLIC HEALTH Statement of Financial Operating Data Three Months Ended September 30,2012 Year to Date Actual Variance RESOURCES: Beg. Net Working Capital $1,336,051 $ 1,327,199 $ (8,852) 100% 99% $1,336,051 $1,327,199 $ (8,852) Revenues Medicare Reimbursement 250 (250) 25% 0% 1,000 1,000 ! Federal Grant 5,000 5,000 25% n/a 5,000 5,000 I,Federal Grant (ARRA) 50,000 (50,000) 25% 0% 200,000 200,000 ,f State Grant 704,142 (704,142) 25% 0% a) 2,816,567 2,934,303 117,736 IChild Dev & Rehab Center 9,902 (9,902) 25% 0% b) 39,609 39,609 j State Miscellaneous 33,685 7,298 (26,387) 25% 5% b) 134,740 134,740 OMAP 156,897 76,512 (80,385) 25% 12% 627,588 627,588 t Title 19 88 (88) 25% n/a 352 352 Family Planning Exp Proj 137,500 30,481 (107,019) 25% 6% 550,000 550,000 Local Grants 37,953 (37,953) 25% 0% b) 151,810 161,810 10,000 Environmental Health-Water 23,050 10,856 (12,194) 25% 12% 92,200 92,200 I Contract Payments 10,644 10,644 25% n/a 15,000 15,000 Miscellaneous 1,539 1,539 25% n/a 3,000 3,000 IPatient Insurance Fees 48,300 27,341 (20,959) 25% 14% 193,200 193,200 I Health Dept/Patient Fees 25,775 20,038 (5,737) 25% 19% 103,100 103,100 Vital Records-Birth 10,250 9,750 (500) 25% 24% 41,000 41,000 t Vital Records-Death 25,000 26,775 1,775 25% 27% 100,000 100,000 Environmental Health-Lic F ac 180,013 70,331 (109,682) 25% 10% c) 720,050 720,050 Interest on Investments 3,000 1,378 (1,622) 25% 11% 12,000 12,000 Donations 1,325 17,416 16,091 25% 329% 5,300 22,277 16.977 lI nterfund Contract 39,657 (39,657) 25% 0% 158,629 158,629 I Administrative Fee 200 200 0 25% 25% 800 800 Total Revenues 1,486,987 315,560 (1,171,427) 25% 5% 5,947,945 6,115,658 167,713 f Transfers In-General Fund 587,340 587,340 25% 25% 2.349,357 2,349,357 I Transfers In-PH Res Fund 15,034 15,034 25% 25% 60,136 60,136 t I i Transfers In-Gen. Fund Other 16,275 16,275 25% 25% 65,100 65,100 TOTAL RESOURCES 3,441,687 2,261,408 (1,180,279) 25% 23% 9,758,589 9,917,450 158,861 f,REQUIREMENTS: I Exp. %1 Expenditures J Personnel Services 1,599,006 1,519,540 79,466 25% 24% 6,396,024 6,396,024 [ Materials and Services 517,864 454,162 63,702 25% 22% d) 2,071,456 2,136,883 (65,427) Capital Outlay 16,250 16,250 25% 0% e) 65,000 65,000 Transfers Out 39,300 39,300 25% 25% 157,200 157,200 Contingency 267,227 267,227 25% n/a 1,068,909 1,068,909 TOTAL REQUIREMENTS 2,439,647 2,013,001 426,646 25% 21% 9,758,589 8,690,107 1,068,482 I I NET (Resources Requirements) 1,002,040 248,406 F53,6341 1,227,343 1,227,343 a) State grant for July will be received in October. Payment is pending until after the grant award is executed ~ b) Received quarterly in arrears , ~ c) Restaurant and Pool/Spa fees are due annually and received in Dec/Jan d) Projection includes grant related expenditures. Appropriation will be increased e) OCHIN System expenditure made in FY 2012 Page 6 BEHAVIORAL HEALTH Statement of Financial Operating Data Three Months Ended September 30,2012 Year to 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 1,625 2,395 770 25% 37% 6,500 6,500 Divorce Filing Fees 40,000 31,068 (8,933) 25% 19% 160,000 125,056 (34,944) Domestic Partnership Fee 11 35 24 25% 78% 45 100 55 Federal Grants 63,087 (63,087) 25% 0% a) 252,349 252,349 Federal Grant (ARRA) 15,938 (15,938) 25% 0% 63,750 63,750 State Grants 1,932,650 2,094,466 161,816 25% 27% b) 7,730,599 7,883,477 152,878 State Miscellaneous 15,465 10,841 (4,624) 25% 18% 61,860 61,860 Adult Mental Health Initiative 50,000 (50,000) 25% 0% 200,000 200,000 Title 19 67,362 29,011 (38,351) 25% 11% 269,446 269,446 Liquor Revenue 35,375 23,854 (11,521 ) 25% 17% 141,500 141,500 School Districts 17,250 (17,250) 25% 0% 69,000 69,000 Contract Payments 34 34 25% n/a 1,000 1,000 Miscellaneous 3,631 3,631 25% n/a 5,000 5,000 Patient Insurance Fees 21,883 32,502 10,619 25% 37% 87,532 87,532 Patient Fees 238 355 117 25% 37% 950 950 Interest on Investments 6,250 5,286 (964) 25% 21% 25,000 25,000 Rentals 4,625 2,500 (2,125) 25% 14% 18,500 18,500 Administrative Fee 1,323,132 1,293,132 (30,000) 25% 24% 5,292,527 5,292,527 Interfund Contract-Gen Fund 31,750 P1,750} 25% 0% a) 127,000 127,000 Total Revenues 3,626,641 3,529,110 (97,531) 25% 24% 14,506,558 14,630,547 123,989 Transfers In-General Fund 326,947 326,947 25% 25% 1,307,787 1,307,787 Transfers In-OHP·CDO Transfers In-Acute Care Svcs 121,124 66,159 121,124 66,159 25% 25% 25% 25% 484,494 264,631 484,494 264,631 f Transfers In·ABHA 131,010 131,010 -25% 25% 524,039 524,039 TOTAL RESOURCES 7,592,848 7,287,444 (305,404) 25% 36% 20,408,477 20,324,593 (83,884) REQUIREMENTS: Exp·%i ! ~ Expenditures Personnel Services 2,811,872 2,700,629 111,243 25% 24% c) 11,247,487 11,266,327 (18,840) i i Materials and Services Capital Outlay Transfers Out Contingency 1,648,559 25 51,000 590,664 1,089,881 51,000 558,678 25 590,664 25% 25% 25% 25% 17% 0% 25% n/a 6,594,235 100 204,000 2,362,655 6,594,235 204,000 100 2,362,655 I I t TOTAL REQUIREMENTS 5,102,120 3,841,510 1,260,610 25% 19% 20,408,477 18,064,562 2,343,915 NET (Resources -Requirements) 2,490,728 3,445,934 955,205 2,260,031 2,260,031 a) Received quarterly, in arrears ! ib) Oregon Health Authority grant projected at amended contract amount ~. c) "On-Calt" forecasted to exceed amount budgeted. Appropriation will be increased t. ,I , ~- I ~ ! Page 7 f ! t I 1 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Three Months Ended September 30,2012 Year to Date Budget I Actual I Variance I FY% I Coil. % RESOURCES: Beg. Net Working Capital $ 10,000 192,482 $ 182,482 100% 1925% $ 10,000 $ 192,482 182,482 Revenues Admin-Operations 5,523 9,017 3,494 25% 41% 22,090 22,090 Admin-GIS 313 290 (23) 25% 23% a) 1,250 1,250 Admin-Code Enforcement 41,550 56,376 14,826 25% 34% 166,200 166,200 Building Safety 318,394 359,253 40,859 25% 28% 1,273,575 1,273,575 Electrical 64,000 90,130 26,130 25% 35% 256,000 256,000 Contract Services 27,900 22,617 (5,283) 25% 20% b) 111,600 111,600 Env Health-On Site Prog 78,243 77,671 (572) 25% 25% 312,971 312,971 Planning-Current 159,338 173,611 14,273 25% 27% 637,350 637,350 Planning-Long Range 56,605 77,124 20,519 25% 34% 226,421 226,421 Total Revenues 751,866 866,090 114,224 25°4 29% 3,007,457 3,007,457 Transfers In General Fund -Gen Ops 213,717 213,717 25% 25% 854,872 854,872 General Fund UR Planning 123,840 123,840 25% 25% 495,360 495,360 A&T Reserve (DIS assistance) 22,394 (22,394) 25% 0% 89,577 89,577 Other 25 (25) 25% 0% 100 pOO~ TOTAL RESOURCES 1,121,842 1,396,129 274,287 25% 31% 4,457,366 4,639,748 182,382 REQUIREMENTS: Exp. %1 EXPENDITURES & TRANSFERS Admin-Operations 338,297 337,876 421 25% 25% 1,353,189 1,353,189 Admin-GIS 29,445 28,932 513 25% 25% 117,778 117,778 Admin-Code Enforcement 57,231 53,947 3,284 25% 24% 228,925 228,925 Building Safety 155.272 151,409 3,863 25% 24% 621,087 621,087 Electrical 50.808 47,732 3,076 25% 23% 203,231 203,231 Contract Services 35,436 34,647 789 25% 24% 141,745 141,745 Env Health-On Site Pgm 39,909 38,031 1,878 25% 24% 159,636 159,636 Planning-Current 160,579 143.642 16,937 25% 22% 642,315 642,315 Planning-Long Range 115,850 120,616 (4,766) 25% 26% c) 463,401 390,000 73,401 Transfers Out (DIS Fund) 44,789 44,789 25% 0% 179,155 179,155 Contingency 86,726 86,726 25% nla 346,904 346,904 TOTAL REQUIREMENTS 1,114,342 956,832 157,510 25% 21% 4,457,366 4,037,061 420,305 NET (Resources Requirements) 7,500 439,298 431,798 602,687 602,687 FY 2013 YearEnd Budget Projection Variance Revenues 866,090 Expenditures 956,832 Net from Operations (90,742) a) Revenue is sporadic throughout the year as GIS services are requested b) Revenue typically lags 1-2 months behind due to billing cycles 3,007,457 3,007,457 4,457,366 4,037,061 420,305 {1,449,909) {1,029,6041 420,305 c) YTD Personnel expenditures exceeds budget to date due to payout of retired employee; however, year end projection will be less than anticipated as pOSition will not be filled Page 8 ROAD Statement of Financial Operating Data Three Months Ended September 30,2012 Year to Date Budget I Actual I Variance IFY% I Coli. % FY2013 Year End Budget Projection Variance RESOURCES: 8eg. Net Working Capital $4,719.551 $ 4,723,852 $ 4,301 100% 100% $ 4,719,551 $ 4,723,852 $ 4,301 Revenues System Development Charge 924 924 25% nla 1,200 1,200 Federal Grant (ARRA) 1,750 (1,750) 25% 0% 7,000 7,000 Mineral Lease Royalties 10,000 5,726 (4,274) 25% 14% 40,000 40,000 Forest Receipts 99,207 (99,207) 25% 0% a) 396,826 396,826 State Miscellaneous 135,573 (135,573) 25% 0% b) 542,290 542,290 Motor Vehicle Revenue 2,697,511 2,509,537 (187,974) 25% 23% 10,790,043 10,790,043 City of Bend 6,250 (6,250) 25% 0% c) 25,000 25,000 City of Redmond 87,500 10,807 (76,693) 25% 3% c) 350,000 350,000 City of Sisters 2,500 (2,500) 25% 0% c) 10,000 10,000 City of La Pine 2,500 (2,500) 25% 0% c) 10,000 10,000 Admin Recovery (SOC) 838 838 25% nla 1,000 1,000 Miscellaneous 5,000 3,654 (1,346) 25% 18% 20,600 20,000 Road Vacations 250 (250) 25% 0% 1,000 1,000 Interest on Investments 3,750 7,455 3,705 25% 50% 15,000 15,000 Interfund Contract 172,500 (172,500) 25% 0% d) 690,000 690,000 Equipment Repairs 55,000 41,599 (13,401) 25% 19% 220,000 220,000 Vehicle Repairs 22,500 (22,500) 25% 0% d) 90,000 90,000 LID Construction 2,500 (2,500) 25% 0% d) 10,000 10,000 Vegetation Management 6,250 (6,250) 25% 0% d) 25,000 25,000 Forester 6,250 (6,250) 25% 0% d) 25,000 25,000 Car Washes 1,000 (1,000) 25% 0% 4,000 4,000 Car Rental 250 (250) 25% 0% 1,000 1,000 Sale of Equip & Material 180,900 157,301 ~23,599~ 25% 22% 723,600 723,600 Total Revenues 3,498,941 2,737,842 (761,099) 25% 20% 13,995,759 13,997,959 2,200 Trans In -Solid Waste 69,068 69,068 25% 25% e) 276,272 276,272 Trans In -Transp SDC 62,500 62,500 25% 25% e) 250,000 250,000 Trans In-Road Imp Res 3,000 (3,000) 25% 0% d) 12,000 12,000 TOTAL RESOURCES 8,353,060 7,593,262 (759,798) 25% 43% 19,253,582 19,260,083 6,501 REQUIREMENTS: 1 Exp. %1 Expenditures Personnel Services 1,341,301 1,329,420 11,881 25% 25% 5,365,202 5,365,202 Materials and Services 2,359,666 2,459,042 (99,376) 25% 26% f) 9,438,662 9,438,662 I Capital Outlay 509,325 6,684 502,641 25% 0% 2,037,300 2,037,300 Transfers Out 68,750 68,750 25% 0% 275,000 275,000 Contingency 534,355 534,355 25% nla 2,137,418 2,137,418 I f TOTAL REQUIREMENTS 4,813,397 3,795,146 1,018,251 25% 20% 19,253,582 17,116,164 2,137,418 t NET (Resources -Requirements) 3,539,663 3,798,116 258,453 2,143,919 2,143,919 r I,a) Payment received annually in January • b) Payment expected in November ! tc) Billed upon completion of work t d) Payments to be received in June 2013 from other Road Department funds t te) Payments made quarterly Page 9 I f) Expenditures are seasonal and higher during summer months I I i ADULT PAROLE & PROBATION Statement of Financial Operating Data Three Months Ended September 30. 2012 RESOURCES: Beg. Net Working CapRa I 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 Personnel Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS Year to Date Budget l Actual I Variance $ 570,000 $ 630,226 $ 60,226 54,810 1.075 3.750 3,457 687,139 5,625 1,125 32,500 47,500 2.250 12.500 12.500 18,708 219,240 3,457 687.139 3.908 591 37,368 43,756 1,223 12,500 164,430 (1.075) (3,750) (0) (0) (1,718) (534) 4.868 (3,744) (1.027) 0 (12,500) (18,708) 882,939 1,009,181 126,242 108.831 108,831 IFY % I Coli. % 100% 111'. 25% 100% 25% 0% 25% 0% 25% 25% 25% 25% 25% 17% 25% 13% 25% 29% 25% 23% 25% 14% 25% 25% 25% 0% 25% 0% 25% 29% 25% 25% 1,561,770 1,748,238 186,468 25% 39% I Exp. %1 772,823 729.978 42,846 25% 24% 222,422 177,671 44,751 25% 20% 25 25 25% 0% 139,001 139.001 25% n/a 1,134,271 907,649 226,622 25°1. 20'1'. a) b) c) c) c) FY 2013 YearEnd Budget Projection Variance $ 570,000 $ 630,226 $ 60,226 219,240 4,301 15,000 13,826 2,748.556 22,500 4.500 130,000 190,000 9,000 50.000 50,000 74,832 3,531,755 219,240 4.301 15.000 13,826 2,748,556 22,500 4,500 130,000 190.000 9.000 50,000 50,000 74,832 3,531,755 435,328 435,328 4,537,083 4,597,309 60,226 3.091,291 889.687 100 556,005 3.091,291 889,687 100 556,005 4,537,083 3,980,978 556,105 NET (Resources -Requirements) 427,499 840,589 413,090 616,331 616,331 a) Payment received annually in September b) Annual allocation normally received by end of calendar year c) State/County invoiced quarterly Page 10 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Three Months Ended September 30,2012 Year to Date Budget I Actual I Variance IFY% I Coil. % RESOURCES: Beg. Net Working Capital $ 511,994 $ 574,985 $ 62,991 100% 1120/. Revenues Federal Grants 49,860 (49,860) 25% 0% Title IV -Family Sup/Pres 9,883 (9,883) 25% 0% HealthyStart Medicaid 21,250 21,456 206 25% 25% Level 7 Services 49,225 (49,225) 25% 0% State Prevention Funds 12,031 12,031 (0) 25% 25% HealthyStart /R-S-G 54,988 54,987 (1 ) 25% 25% OCCF Grant 104,949 97,985 (6,964) 25% 23% Program Fees 2,112 2,112 25% n/a Charges for Svcs-Misc 2,000 50 (1.950) 25% 1% Court Fines &Fees 19,871 18,817 (1,054) 25% 24% Interest on Investments 250 990 740 25% 99% Grants, Private 500 (500) 25% nfa Interfund Grants 80.219 45,000 P5,219 l 25% 14% Total Revenues 405,026 253,427 (151,599) 25% 16% Trans from General Fund 69,000 69,000 25% 25% Total Transfers In 69,000 69,000 25% 25% TOTAL RESOURCES 986,020 897,413 (88,607) 25% 37% REQUIREMENTS: I Exp. %1 Expenditures Personnel Services 161,869 150,187 11,682 25% 23% Materials and Services 368,999 48,100 320,899 25% 3% Capital Outlay 25 25 25% 0% Contingency 71,127 71,127 25% n/a TOTAL REQUIREMENTS 602,020 198,287 403,733 25% 8% NET (Resources -Requirements) 384,000 699,125 315,125 a) New Federal grants of $112,427 was awarded while $50,000 STOP grant denied b) Additional GLS grant funds of $3,500 awarded c) State reduced the Circuit Court fees FY 13 I Year End Budget Projection Variance $ 511,994 $ 574,985 $ 62,991 a) a) b) a) c) d) 199,441 39,533 85,000 196,898 48,122 219,951 419,796 8,000 79,485 1.000 2.000 320,874 1,620,100 259,168 39,533 60,000 196,898 58,022 219,951 391,940 3,500 4.000 75.034 5,000 350,374 1,663,420 59,727 (25,000) 9,900 (27,856) 3,500 (4.000) (4,451) 4.000 (2,000) 29,500 43,320 275,984 275,984 275,984 275,984 2,408,078 2,514,389 106,311 e) f) 647,474 1,475,997 100 284,507 601,397 1,545,250 46,077 (69,253) 100 284,507 2,408,078 2,146,647 261,431 367,742 367,742 I I t ,~ t rd) Additional grant funds of $17,500 - A &070 and $12,000 EUDL projected to be received t e) Personnel expenditures projected to be less than appropriated. Open position, due to retirement, will not be filled f) M &S projected to be greater than Originally budgeted due to new Federal grant awarded. Appropriation transfer will be requested I Page 11 I I I t SOLID WASTE Statement of Financial Operating Data Three Months Ended September 30,2012 Year to Date Budget I Actual I Variance I FY % I Coil. % FY 2013 Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 700,513 $ 807,470 $ 106,957 100% 115% $ 700,513 $ 807,470 $ 106,957 Revenues Miscellaneous 5,500 5,236 (264) 25% 24% 22,000 22,000 Franchise 3% Fees 50,000 8,556 (41,444) 25% 4% a) 200,000 200,000 Commercial Disp. Fees 215,000 257,263 42,263 25% 30% 860,000 860,000 Private Disposal Fees 328,500 409,154 80,654 25% 31% 1,314,000 1,314,000 Franchise Disposal Fees 1,000,000 1,086,591 86,591 25% 27% 4,000,000 4,000,000 Yard Debris 18,250 38,103 19,853 25% 52% b) 73,000 73,000 Special Waste 6,250 4,453 (1,797) 25% 18% c) 25,000 25,000 Interest 1,875 2,170 295 25% 29% 7,500 7,500 Leases 2,700 3,600 900 25% 33% 10,801 10,801 Recyclables 11,250 15,128 3,878 25% 34% 45,000 45,000 Total Revenues 1,639,325 1,830,255 190,930 25% 28% 6,557,301 6,557,301 TOTAL RESOURCES 2,339,838 2,637,725 297,887 25% 36% 7,257,814 7,364,771 106,957 REQUIREMENTS Expenditures Personnel Services Materials and Services Debt Service Capital Outlay Transfers Out-Road Trans Out-Capital Res Contingency 433,330 747,328 236.678 20.750 69,068 157.500 149,799 414,013 490,685 69,068 315,000 19,317 256,643 236,678 20,750 (157,500) 149,799 25% 25% 25% 25% 25% 25% 25% Exp·%1 24% 16% d) 0% e) 0% f) 25% g) 50% h) n/a 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 1,814,453 1,288,766 525.687 25% 18% 7,257,814 6,658,619 599,195 NET (Resources -Requirements) 525,385 1,348,959 823,574 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) Semi-Annual: November and May f) In the process of contacting bidders g) Quarterly h) One half of appropriation transferred in September. Balance will be transferred by June 30, 2013 Page 12 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 NSF Fee Interest on Investments Other Interest TOTAL REVENUES TOTAL RESOURCES Appropriations/Expenditures 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 Damage VEHICLE Professional Service Insurance Loss Prevention Repair I Replacement Total Vehicle WORKERS' COMPENSATION Settlement / Benefit Professional Service Insurance Loss Prevention Miscellaneous Total Workers' Compensation UNEMPLOYMENT -Settlement/Benefits Total Direct Insurance Costs Insurance Administration: Personnel Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET a) Annual premium paid in July 2012 * Contingency is $2,149,038. RISK MANAGEMENT Statement of Financial Operating Data Three Months Ended September 30,2012 Year to Date Budget I Actual I Variance I % of FY I % Coil, $2,000,000 $2,240,791 $240,791 100% 112% $2,000,000 65,583 65,583 0 25% 25% 262,333 78,370 78,370 0 25% 25% 313,480 43,409 43,409 (0) 25% 25% 173,635 360,044 360,044 0 25% 25% 1,440,176 62,500 62,538 38 25% 25% 250,000 125 (125) 25% 0% 500 15,000 923 (14,077) 25% 2% 60,000 500 145 (355) 25% 7% 2,000 13 35 23 25% 70% 50 4,000 960 (3,040) 25% 6% 16,000 30 30 25% n/a 3,750 3,253 (497) 25% 22% 15,000 13 ~13l 25% 0% 50 633,306 615,290 ~18,016) 25% 24% 2,533,224 2,533,254 30 2,633,306 2,856,081 222,775 25% 63% 4,533,224 I% Exe· I 349,080 19,933 2,604 135,600 a) 5,439 45 75,000 512,702 (437,702) 25% 171% 300,000 158,508 a) 5,315 62,500 163,823 (101,323) 25% 66% 250,000 366 668 2,917 25,000 3,952 21,048 25'0 4% 100,000 72,058 69,009 a) 16,248 250,000 157,315 92,685 25% 16% 1,000,000 62,500 62,500 25% 0% 250,000 $2,240,791 $240,791 262,333 313,480 173,635 1,440,176 250,000 500 60,000 2,000 50 16,000 30 30 15,000 50 475,000 837,792 (362,792) 25% 44% 1,900,000 2,390,000 (490,000) I76,974 70,106 6,868 25% 23% 307,896 307,896 i 42,248 30,093 12,155 25% 18% 168,990 168,990 i t 25 25 25% 0% 100 100 119,247 100,199 19,048 25% 21% 476,986 476,886 100 1,800 1,800 25% 25% 7,200 7,200 596,047 939,791 p43,744~ 25% 39% 2,384,186 2,874,086 1489 ,900} 2,037,260 1,916,290 112O,969} * 2,149,038 1,899,959 1249,0791 ,Page 13 t 4,774,045 240,821 SOO,OOO (500,000) 250,000 •~ f, 100,000 t r t I'1,000,000 240,000 10,000 1 l DESCHUTES COUNTY 911 Statement of Financial Operating Data Three Months Ended September 30, 2012 Year to Date Actual Variance Variance RESOURCES: 8eg. Net Working Capital $8,000,000 $ 8,883,086 $ 883,086 100% 111% $8,000,000 $8,883,086 $ 883,086 Revenues Property Taxes -Current 1,636,922 (1,636,922) 25% 0% a) 6,547,687 6,547,687 Property Taxes -Prior 46,250 164,600 118,350 25% 89% 185,000 185,000 Federal Grants 60,000 (60,000) 25% 0% b) 240,000 240,000 State Reimbursement 9,000 (9,000) 25% 0% c) 36,000 36,000 Telephone User Tax 187,500 (187,500) 25% 0% 750,000 750,000 Data Network Reimb. 7,500 (7,500) 25% 0% d) 30,000 30,000 Jefferson County 7,500 526 (6,974) 25% 2% 30,000 30,000 User Fee 11,000 (11,000) 25% 0% e) 44,000 44,000 Police RMS User Fees 69,738 (69,738) 25% 0% d) 278,950 278,950 Contract Payments 7,750 (7,750) 25% 0% d) 31,000 31,000 Miscellaneous 2,250 1,970 (280) 25% 22% 9,000 9,000 Interest 10,000 12,493 2,493 25% 31% 40,000 40,000 Interest on Unsegregated Tax 150 44 ~106l 25% 7% 600 600 Total Revenues 2,055,560 179,634 (1,875,926) 25% 2% 8,222,237 8,222,237 TOTAL RESOURCES REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out-Reserve Fund Contingency TOTAL REQUIREMENTS 10,055,560 1,085,123 512,551 140,500 125,000 2,192,386 9,062,719 993,296 475,554 500,000 (992,841) 91,827 36,997 140,500 (375,000) 2,192,386 4,055,560 1,968,850 2,086,710 25% 25% 25% 25% 25% 25% 25% 56% % Exp·1 23% 23% 0% 100% f) nfa 12% 16,222,237 17,105,323 883,086 4,340,490 2,050,202 562,000 500,000 8,769,545 3,800,000 2,050,202 562,000 500,000 540,490 8,769,545 16,222,237 6,912,202 9,310,035 NET (Resources -Requirements) 6,000,000 7,093,869 1,093,869 -10,193,121 10,193,121 a) Current year taxes not due until November b) ODOT Project-reimbursements expected to be received over the next 3-4 months c) July & August bills have been mailed; ongoing monthly reimbursements from Office of Emergency Mgmt for MSAGfGIS maintenance d) Annual billings to Police/Fire agencies to be mailed in December e) US Forest Service invoiced $2,156.25 quarterly. Crooked River Ranch billed annually end of June f) Amount appropriated was transferred September 15, 2012 Page 14 Health Benefits Trust Statement of Financial Operating Data Three Months Ended September 30. 2012 FY 2013 Budget Projection Variance RESOURCES Beg. Net Working Capital $13,800,000 $14,551,028 $ 751,028 100% 105% $ 13,800,000 $14,551,028 751,028 Revenues: Internal Premium Charges 3,198.750 3,200.520 1,770 25% 25% 12,795,000 12,795,000 prr Emp -Add'i Prem 12.500 8.343 (4,157) 25% 17% 50,000 50,000 Employee Prem Contribution 157,500 158,210 710 25% 25% 630,000 630,000 COIC 325,000 345,094 20,094 25% 27% 1.300,000 1.300,000 Retiree I COBRA Co-Pay 187.500 241,469 53,969 25% 32% 750,000 750,000 Medical Services Reimb 323 323 25% nla 323 323 Federal Payment (ERRP) 25% nla • Prescription Rebates nla Claims Reimbursements 58.757 58.757 25% nla 58,757 58,757 Vending Machines (Wellness Rebate) 25% nla Interest 20,000 21,099 1.099 25% 26% 80,000 80,000 Total Revenues 3.901,250 4,033,815 132.565 25% 26% 15,605.000 15.664,081 59,081 TOTAL RESOURCES 17,701,250 18,584,842 883.592 92'1'. 105% 29,405,000 30,215,108 810.108 REQUIREMENTS Expenditures: Personnel Services (all depts) 50,193 48,341 1,852 25% 240/0 200,772 200,772 Materials & Services Claims Paid-Medical 2,507,550 2,851.119 (343,569) 25% 28% a) 10,030,200 11,404,475 (1,374,275) Claims Paid-Prescription 480,900 338,593 142,307 25% 18% a) 1,923,600 1,354,373 569,227 Claims Paid-DentalNiSion 446,550 416,305 30,245 25% 23% a) 1,786,200 1,665.218 120,982 Claims Refunds (11,309) 11,309 25% nla (11,309) 11,309 Insurance Premiums 87,500 85,288 2,212 25% 24% 350,000 350,000 State Assessments 40,000 89,329 (49,329) 25% 56% 160,000 160,000 Administration Fee 80,000 81,910 (1.910) 25% 26% 320,000 320,000 Preferred Provider Fee 12.500 12,541 (41 ) 25% 25% 50,000 50,000 Health Impact 13.750 12,963 788 25% 24% 55,000 55,000 Refund -ERRP 58,552 (58,552) 25% nla b) 58,552 (58,552) Other -Administration 16.338 6,882 9,457 25% 11% 65,353 65,353 Other -Wellness 26.250 5,088 21,162 25% 5% 105,000 105,000 Admin & Wellness 3,711,338 3,947,258 (235.920) 25% 27% 14.845,353 15.576,661 (731,308) Deschutes On-site Clinic Healthstat 171,000 160,841 10,159 25% 24% c) 684,000 684,000 Medical Supplies 7,500 4,529 2,971 25% 15% 30,000 30,000 Equipment 250 250 25% 0% 1.000 1.000 Other 5,358 18,304 (12,946) 25% 85% 21,433 21,433 Total DOC 184,108 183.674 434 25% 25% 736.433 736,433 Deschutes On-site Pharmacy Contracted Services 77,072 79.934 (2,862) 25% 26% c) 308,287 308,287 Medication and Drugs 250,000 296,316 (46.316) 25% 30% c) 1,000,000 1,000,000 Start Up Costs-Take Care 59,898 59,898 25% nla c) 59,898 (59,898) Other 4,140 4,249 (109) 25% nla 16.559 16,559 I Total Pharmacy 331.212 440.397 (109.185) 25'Y. nla 1.324.846 1,384,744 (59,898) Capital Outlay 25 25 25% nla 100 100 Contingency 3,074,374 3,074,374 25% nla 12,297,496 12.297,496 I tTOTAL EXPEND/REQUIREMNTS 7,020,039 4,619,670 2,731.580 25% 16% 29.405.000 17,898,610 11,506,390 f NET (Resources -Requirements) 10,681,212 13,965,172 3,615,172 12.316,498 12,316,498 i IRevenues less Expenditures (585,856) (2.234.529)1 l I l a) Projection based on annualizing 13 weeks of claims paid. YTD actual is $250.470 per week b) Disallowance of Early Retiree Reinsurance Program items (Reported as revenue in FY 2012) c) YTD Actual include estimates: September Healthstat. July through September Take Care Admin, August through September "ingredient" costs and Start up costs (prior year). These items had nol been paid as of September 30, 2012 Page 15 I Deschutes County -Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Three Months Ended September 30, 2012 RESOURCES: Beg. Net Working Capital Receipts: Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % -Food Rights (Signage, etc.) Interfund Contract Miscellaneous Total Receipts Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Total Transfers In Year to Date Budget (3/12 of I annual) Actual I Variance IFY % ICoil. % $ 46,373 $ 35,055 $ (11,318) 151,895 68,253 (83,642) 375 84 (291) 14,360 (14,360) 1,500 (1,500) 7,500 16,262 8,762 47,500 20,500 (27,OOO) 23,750 16,000 (7,750) 5,000 600 (4,400) 1,700 121 P,579} 100% 76% 25% 11% 25% 6% 25% 0% 25% 0% 25% 54% 25% 11% 25% 17% 25% 3% 25% n/a 253,580 121,820 (131,759) 25% 12% 42,500 42,501 25% 25% 6,436 6,435 25% 25% 20,700 20,700 25% 25% 66,065 150,000 83,935 25% 57% 135,701 219,636 83,935 FY 2013 Budget $ 46,373 607,578 1,500 57,441 6,000 30,000 190,000 95,000 20,000 6,800 1,014,319 1,010,464 (3,855) 170,000 170,000 25,744 25,744 82,800 82,800 264,259 264,259 542,803 542,803 Year End Projection $ 35,055 580,831 1,210 57,441 6,000 46,262 197,500 95,000 20,000 6,221 Variance $ (11,318) (26,747) (290) 16,262 7,500 (579) TOTAL RESOURCES 435,654 376,511 (59,142) 25% 23% 1,603,495 1,588,322 (15,173) REQUIREMENTS: 1 Exp. %1 Expenditures: Personnel Services 207,971 203,828 4,143 25% 25% 831,882 827,756 4,126 Materials and Services 126,556 115,987 10,569 25% 23% 506,223 516,785 (10,562) Debt Service 28,530 28,530 25% 0% 114,119 114,119 Capital Outlay 3,565 9,000 (5,435) 25% 63% 14,259 14,259 Total Expenditures 366,621 328,815 37,806 1,466,483 1,472,919 (6,436) Contingency 34,253 34,253 25% n/a 137,012 137,012 TOTAL REQUIREMENTS 400,874 328,815 72,059 25% 21% 1,603,495 1,472,919 130,576 NET (Resources -Requirements) 34,780 47,696 12,916 115,403 115,403 Page 16 rJl u ~ ~ ,.., 0 ~ ~ ~ < ~ ~ ~ < U r:/:l::s 0.. 8 C':S U >s=::s 0 u "€ 0 z • :::::: 1--1 5 ..c:: 0,).. -5 0,) ~ • I ( I i I f I f I• ! I J I t i t i t f F t , ~ • 11 ... - Deschutes County North County Services Building Inception through September 30, 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 Resources EXPENDITURES: Materials & Services Architecture/Design Engineering Interfund Charges Fees, Permits & SDCs Utilities Travel -Meals/Mileage Reimb Total Materials & Services 1,402,013 25,000 600,000 4,604 2,031,617 47,610 4,535 534 10,981 3 63,663 ACTUAL Encumbrances & Commitments 25,000 25,000 Project to Date 1,402 ,013 25,000 600,000 4 ,604 ...,b031,617 72,610 4,535 534 10,981 3 I I Budaet * I I Proiected I I Variance 3,400,000 a) 1,402 ,013 b) 25,000 700,000 13,740 5,540,753 b) 325,000 75,000 13,150 75,000 20,000 3,400,000 1,402 ,013 25,000 700,000 13,740 5,540,753 325,000 75,000 13,150 75,000 20,000 3 (3~ 88,663 508,150 508,153 (3~ Capital Outlay Land and Building Remodel Total Capital Outlay 1,402,013 230 1,402,243 1,402,013 230 1,402 ,243 a) 1,402,013 3,300,000 4,702 ,013 1,402,013 3,300,000 4,702,013 Contingency Total Expenditures 1,465,906 25,000 1,490,906 313 ,513 5,523,676 5,210,166 313 ,513 (3) Net 565,712 (25,000) 540,712 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) __ "-7"",,'-''''~''''C:'~'''~'''''''''.""'-''''''''''~·~---.m,,,,_,,,w,'.'_"0<,,,,",,""""""'<N"""-_~~_'''''''''''''_''1'''''''''''''''':'''''''~___'~~~;"""~"'~4__,........_"",,,,,~",_,'''''''''''''~_~·_·_'_""'0>1:._~~ ",,,V'<~_.~_,,,,_",_~,,,.~",,,,,,,,_",,,,,,,-,,",_-,,-,,,_,,,,,,,,,,-,,__,,,,,,,,,,,, __-~--."~---~"-"'=-""""~"""'",-,--"~",,,-~~,,,-,,,,,--- .-~.-' North County Services Building -Fund 462 ENCUMBRANCES AND COMMITMENTS Through September 30, 2012 Vendor .... Descrj~n Commitment Amount Amount Paid Balance Due BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects Design Programming Construction Documents Evergreen School Assessment-Estimate Design Phase Design Development Phase Schematic Design Phase Planning -Redmond Parking Total Fee Reimburseable Expenses Total Payments to Architects 25,000 25,000 13,750 63,750 25,000 13,750 720 3,745 3,570 300 47,085 525 47,610 25,000 25,000 25,000 Deschutes County Bethlehem Inn (Fund 128) Three Months Ended September 30,2012 BUd£!et Actual Variance IFY%I Coli. %1 Bud£!et I Projection I Variance I RESOURCES: Beg. Net Working Capital $ (2,710,000) $(2,710,173) $ (173) 100% 100% $(2,710,000) $(2,710,173) $ (173) Revenues Grants -Private 25,148 (25,148) 25% 0% 100,592 (100,592) Lease Payments 6,102 6,102 25% 25% 24,408 24,408 Total Revenues Transfers In: Project Development (140) Gen Capital Res (143) TOTAL RESOURCES 31,250 412,500 265,000 (2,001,250) 6,102 (2,704,071) (25,148) (412,500) ~265,000~ (702,821) 25% 25% 25% 25% 5% 0% 0% -2163% 125,000 1,650,000 1,060,000 125,000 24,408 - - (2,685,765) (100,592) (1,650,000) ~1,060,000~ (100,765) REQUIREMENTS: Expenditures Debt Service: Interest Expense Interest Payment 6,250 25,000 4,115 2,135 25,000 25% 25% Exp·%1 16% 0% a) 25,000 100,000 16,500 8,500 100,000 TOTAL REQUIREMENTS 31,250 4,115 27,135 25% 3% 125,000 16,500 100,000 NET (Resources -Requirements) {2,032,500} {2,708,186~ {675,686} b) ,2,702,265} F651 a) Interest on September 2012 negative cash balance: $1,350.49. b) Inception through September 30,2012 Revenues -Lease Payments Expenditures: Land/Building (Amertitle) -July 2007 Hickman Williams City of Bend -May 2008 KN EX CO Kleinfelder Total expended on facility Interest on Negative Cash Balance Total expended Net $ 54,918 2,241,313 17,578 250,000 5,289 3,732 2,517,913 245,192 2,763,104 $(2,708,186) Deschutes County General Support Services -SOCC Conference/Seminar, Educationrrraining and Travel Expenditures and SOCC -County College Expenditures FY 2013 BOCC Conference & Travel YTD Total Tal'l'lmy Ba.!'~__ _ -~----~--~~~--~~----------~ Conf/S~_m &E~l:Icrrra~rlirl~t Travel Meals Accommodations are ------~-~-.. ileage reimbur~~rnen!~~_ Ground Transport/Parking ~-"-......-.--~-- ~~_~~!'Il~ .~ A~~,!gei ___~_~__ ~.onf/S~m & E~uc£!~a!rliI1JL_~_~ Travel Meals Accommodations Airfare Mileage reirnbursernen~______~~~_~ Ground Transport/Parking 1 384 -35~··· === 30 566 65 112 30 20 127 384 35 596 65 112 177f-__T~._o_t~lJnger __ ~_ 65 112 , ---~------. .. ~... ~---~ ==~=...----------.Tony DeBone yonf/Sem &E.~I.l~lTra!rling 15 45 Travel Meals Accommodations .---...... -.--~....---~~.. . Airfare .-........~ -~...~.--.--~-.. . ..._. ~ -_ .... . . _Mileage reimbur~~rn~~rlt~~__ .. Ground Transport Total Other 30 15 45 ----~.~--~--~=~~:~:~--=----------....TC?t!,l-BO~~ De~.!,~.,!!en.!. ____... Conf/SElm & Educrr~ai~rlg_ .._~___ J~~_~_~~_.__ . ___ ..._.~1~.5_. __..~.~ 140 ---~.~--- I Meals 20 Accommodations 1 .........~~~-~------~ Airfare ----.--~,.-...~--~~--.---.. _Mileage Reimburs~f"l'lElnt Ground Transport IC?!C!I~~O~C-Depal!~~~ .... -~~~--...--------~......-~~-------.t=Y 201 ~Budget_~__~~ BOCC ~5>un~_Col~~ae ____ /Copier Supplies Meeifng-Supplies--~--'~ . Total BOCC County College 35 . 125 678 15 85 761 846 20 127 35 818 15,250 . -------~..- 5.4% 85 761 846 f\iQIE: Ab~ve al'l'l~lJBts in~!udEl()I'!I.Yt~ose expen_<!itu!Els processed_for pa~l'I'IeB~~_ Additional conference and travel costs rna have been incurred, but not et aid. 10/1/2012 RESOURCES: Beg. Net Working Capital $ 415,000 Revenues Cleaning/Maintenance 49,393 Insurance Reimbursement Utility Reimbursement 750 Facilities Charge to State 47,484 Miscellaneous Interest on Investments 750 Interfund contract 2,500 Misc Bldg Svcs ISF Charges 537,034 Building Services -620 Statement of Financial Operating Data Three Months Ended September 30,2012 Year to Date Budget I Actual I Variance IFY% I Coli. % $ 455,993 $ 40,993 100% n/a 30,447 9,331 858 29,584 7 772 2,500 SO 537,030 (18,946) 9,331 108 (17,900) 7 22 SO 25% 25% 25% 25% 25% 25% 25% 25% 25% 15% n/a 29% 16% nJa 26% 25% n/a 25% Total Revenues 637,910 610,579 (27,328) 25% 24% TOTAL RESOURCES 1,052,910 REQUIREMENTS: Expenditures Personal Services 457,138 Materials and Services 192,OSO Transfer to Veh Reserve 9,900 Capital Outlay 25 Contingency 82,544 1,066,572 13,666 25% 36% 1 Exp. %1 452,696 206,117 9,900 4,442 (14,067) 25 82,544 25% 25% 25% 25% 25% 25% 27% 25% 0% 0% TOTAL REQUIREMENTS 741,657 668,713 72,944 25% 23% NET (Resources -Requirements) 311,253 397,860 86,610 Budget 415,000 197,570 Projection $ 455,993 197,570 $ Variance I 40,993 Ii !• 3,000 189,934 9,331 3,000 189,934 9,331 3,000 10,000 3,000 10,000 50 50 2,148,122 2,551,626 2,148,122 2,561,007 SO 2,966,626 3,017,000 41,043 1,828,551 1,828,551 768,200 768,200 39,600 39,600 100 100 330,175 330,175 2,966,626 2,636,451 330,175 380,549 371,218 $ YearEnd , I , I•t l t I II ! I ! I t I I, l J RESOURCES: Beg. Net Working Capital Revenues Sale of Photo Copies Miscellaneous Interest on Investments ISF Charges Total Revenues Transfers In-General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Transfer to Veh Reserve Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources -Requirements) Admin Services· 625 Statement of Financial Operating Data Three Months Ended September 30.2012 Year to Date Budget I Actual I Variance IFY% I Co". % $ 140,000 $ 207,208 $ 67,208 100% n/a 125 232,471 398 6 401 232,471 398 6 276 25% 25% 25% 25% n/a n/a n/a 25% 232,596 233,275 679 25% 25% 10.000 10.000 25% 25% 382,596 450,483 67,887 25% 41% ! EXP.%! 215,453 27,651 900 25 33.568 172,641 19,594 900 42,812 8,057 25 33,568 25% 25% 25% 25% 25% 20% 18% 25% 0% 0% 277.596 193.135 84,461 25% 17% 105.000 257,348 152,348 Year End Budget Projection Variance I $ 140,000 $ 207,208 $ 67,208 398 398 6 6 500 1.500 1.000 929.885 929.885 930,385 931,788 1,403 40.000 40,000 1,110,385 1,178,996 68,611 I 861.810 861,810 110,604 110,604 3,600 3,600 100 100 134,271 134,271 1.110,385 976,114 134,271 202,882 202,882 I RESOURCES: Beg. Net Working Capital Revenues Sale Map Photo or Copies Interest on Investments ISF Charges TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources· Requirements) BOCC·628 Statement of Financial Operating Data Three Months Ended September 30,2012 Year to Date Budget ! Actual I Variance !FY% ! Coil. % $ 60,000 $ 37.907 $ (22,093) 100% nfa 5 5 25% n/a 125 86 (39) 25% n/a 107,970 107,970 25% 25% 168,095 145,968 (22,127) 25% 30% I Exp·%1 86,030 86,055 (25) 25% 25% 22,317 19,499 2,818 25% 22% 25 25 25% 0% 14,723 14,723 25% 0% 123,095 105,554 17,541 25% 21% 45,000 40,414 ~4,586) YearEnd Budget Projection Variance $ 60,000 $ 37.907 $ (22,093) 5 5 500 350 (150) 431,879 431.879 492.379 470,141 (22,238) 344,119 89,268 100 58,892 492,379 344,119 89,268 433,387 100 58,892 58,992 I 36,754 36,754 t f t Finance -630 Statement of Financial Operating Data Three Months Ended September 30, 2012 Year to Date Year End RESOURCES: Beg. Net Working Capital Revenues Investment Fee IGA Contracts Interest on Investments lnterfund Contracts ISF Charges Total Revenues Budget I Actual I Variance IFY% I Coli. % $ 540,000 $ 583,527 $ 43,527 100% nfa 8,000 8,764 764 25% 27% 3,862 5,446 1,585 25% 35% 1,000 873 {127} 25% 22% 3,000 3,000 25% 25% 240,608 240,608 25% 25% 256,469 258,691 2.221 25% 25% Budget Projection Variance I $ 540,000 $ 583,527 $ 43.527 32,000 15,446 4,000 12,000 962,431 32,000 15,446 4,000 12,000 962,431 1,025,877 1,025,877 TOTAL RESOURCES 796,469 842,218 45,748 25% 54% 1,565,877 1,609,404 43,527 REQUIREM ENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 263,198 64,840 750 62,682 230,437 83,823 32,761 (18,983) 750 62,682 I Exp·%1 25% 22% 25% 32% 25% 0% 25% 0% a) 1,052,792 259,358 3,000 250,727 1,052,792 259,358 3,000 250,727 TOTAL REQUIREMENTS 391,469 314,260 77,209 25% 20% 1,565,877 1,312,150 253,727 NET (Resources -Requirements) 405,000 527,958 122,958 297,254 297,254 a) Includes payment of annual contract $52,762 I Legal-640 Statement of Financial Operating Data Three Months Ended September 30,2012 Year to Date Year End Budget I Actual I Variance IFY% l Coil. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 150,000 $ 188,093 $ 38,093 100% n/a $ 150,000 $ 188,093 $ 38,093 Revenues Sale Map Photo or Copies 75 71 (5) 25% 24% 300 300 Miscellaneous 250 (250) 25% 0% 1,000 1,000 Interest on Investments 250 328 78 25% 33% 1,000 1,000 Interfund Contract 1,000 (1,000) 25% 0% 4,000 4,000 ISF Charges 192,260 192,260 25% 25% 769,038 769,038 Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources -Requirements) 193,835 192,658 (1,176) 343,835 380,751 36,917 197,383 9,301 25 24.626 190,696 8,207 6,686 1,094 25 24,626 231.335 198,903 32,431 112,500 181,848 69,348 25% 41% I Exp. %1 25% 24% 25% 22% 25% 0% 25% 0% 25% 21% 775,338 775,338 925,338 963,431 38,093 789,531 37.203 100 98,504 789.531 37,203 100 98,504 925,338 826,734 98,604 136,697 136,697 Personnel-650 Statement of Financial Operating Data Three Months Ended September 30,2012 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Interest on Investments ISF Charges Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources· Requirements) a) Manley Services Payment Year to Date Budget I Actual I Variance IFY % I Coli. % $ 290,000 $ 327,178 $ 37,178 100% nfa 250 35 (215) 25% 4% a) 750 535 (215) 25% 18% 200,157 200,157 25% 25% 201,157 200,727 (430) 25% 25% 491,157 527,905 36,748 I Exp.%1 170,161 75,592 25 27,878 155,618 59,890 14,543 15,702 25 27,878 25% 25% 25% 25% 23% 20% 0% 0% 273,657 215,508 58,149 25% 20% 217,500 312,397 94,897 Budget $ 290,000 1,000 3,000 800,626 804,626 802,761 (1,865) 1,094,626 1,129,939 35,313 680.644 680,644 302.369 302,369 100 100 111,513 111,513 1,094,626 983,013 111,613 146,926 146,926 I r l I I Year End Projection $ 327,178 35 2,100 800.626 I Variance I $ 37,178 I f (965) (900) I f t f J I I, , Information Tech -660 Statement of Financial Operating Data Three Months Ended September 30,2012 Year to Date Year End Budget / Actual / Variance /FY% / CoiL % BudQet Projection Variance / RESOURCES: Beg. Net Working Capital $ 568,550 $ 731,330 $ 162,780 100% nfa $ 568,550 $ 731,330 $ 162,780 Revenues Interest on Investments 1,000 1,149 149 25% 29% 4,000 4,000 Inter/Ether/Date/Phone 6,750 10,106 3,356 25% 37% 27,000 27,000 ISF Charges 523,211 523,211 25% 25% 2,092,844 2,092,844 Total Revenue 530,961 534,466 3,505 25% 25% 2,123,844 2,123,844 Transfers In-General Fund 16,500 16.500 25% 25% 66,000 66,000 TOTAL RESOURCES 1,116,011 1,282,296 166,285 25% 46% REQUIREMENTS: 1 Exp. %1 Expenditures Personal Services 484,210 474,378 9,832 25% 24% Materials and Services 130,789 138.707 (7,918) 25% 27% Capital Outlay 25 25 25% 0% Contingency 74.574 74.574 25% 0% TOTAL REQUIREMENTS 689,599 613,086 76,513 250/0 22% 2,758,394 2,921,174 162,780 1.936,841 1,936.841 523.156 523,156 100 100 298.297 298,297 2,758,394 2,459,997 298,397 NET (Resouroes -Requirements) 426,413 669,210 242,798 461,177 461,177 I IT Reserve -661 Statement of Financial Operating Data Three Months Ended September 30,2012 Total Revenue 25% 25% 235,500 236,800 1,300 TOTAL RESOURCES REQUIREMENTS: 25% 90% 601,093 716,996 115,903 Expenditures Materials and Services 1 Exp. %1 25% 11% b} 76,600 76,600 Capital Outlay 25% 64% b} 145,000 145,000 Res for Future Expenditure 25% 0% 379,493 379,493 TOTAL REQUIREMENTS 150,273 101,873 48,400 25% 17% 601,093 221,600 379,493 NET (Resources Requirements) 274,195 437,546 163,351 495,396 495.396 RESOURCES: Beg. Net Working Capital Revenues Interest ISF Charges Bud et Actual $ 365,593 $ 480,196 $ 114,603 375 723 348 58,500 58,500 58,875 59,223 348 424,468 539,419 114,951 19,150 8,597 10,553 36,250 93,276 (57,026) 94,873 94,873 100% n/a 25% 48% 25% 25% FY 2013 Budget $ 365,593 1,500 234,000 YearEnd Projection $ 480,196 2,800 234,000 Variance $ 114,603 1,300 a} From Solid Waste