Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Finance Update
Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA October 26, 2011 (1) Monthly Investment Report (2) September 2011 Financials -- ----- rurtt 1 Commercial Paper $ Corporate Notes 8,662,069 Time Certificates 9 ,305 ,763 U. S . Treasuries Federal Agencies 29,316,611 Bankers' Acceptances LGIP/BOTC Total Portfolio: By Investment Types Corporate Notes 9% Time Certificates 9 % Federa l Agenci e s 29 % 53% ,------------ Investment Income Investments By County Function Fiscal Year 2011-12 Sep-11 I I Y-T·D General $1'00,459,468 $ 46,984 $ 157,077 0.00% 8.&2°4 9.2&% 0.00% I Total Investments $100,459,468 29.18% Total Investment Income 46,984 157,077 0.00·4 Less Fee : 5% of Invest. Income {2,349~ {7,854~ Investment Income· Net 44,635 $ 149,223\$ ' Category Maximums: U.S. Treasuries 100°4 ILGIP 100% ~Federal Agencies 75% Banker's Acceptances 2511f. Time Certificates 25% Commercial Paper 201lf. Corporate Notes 10% tlc~omparato s 3 Month Twas. ~ 0.02% 12 Month Treas. ~ 0.12% 3 Month C P ~ 0.11% Average Maturity In Days General ---636 Memorandum Date: October 13, 2011 To: Board of County Commissioners Erik Kropp, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find September 2011 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, 2011 Year to Date Actual Variance RESOURCES: Beg. Net Working Capital $ 7,300,000 $ Revenues Property Taxes 5,025,242 Gen. Rev. -excl. Taxes 595,580 Assessor 197,749 County Clerk 367,177 SOPTA 3,100 District Attorney 74,667 FinancelTax 48,475 Veterans 15,335 Property Management 24,050 Grant Projects 500 8,245,725 $ 945,725 389,590 (4,635,652) 1,200,165 604,585 212,455 14,706 343,754 (23,423) 4,081 981 23,039 (51,628) 68,824 20,349 225 (15,110) 27,550 3,500 500 0 100% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 113% 2% 50% 27% 23% 33% 8% 35% 0% 29% 25% a) b) c) c) d) c) $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 $ Variance $8,245,725 $ 945,725 20,550,967 450,000 2,382,321 790,996 1,468,707 12,398 298,669 193,900 61,341 96,200 2,000 Total Revenues 6,351,875 2,270,183 (4,081,692) 25% gOk 25,407,499 25,857,499 450,000 TOTAL RESOURCES 8,176,876 10,515,908 2,339,032 25% 32% 32,707,499 34,103,224 1,395,725 REQUIREMENTS: I Exp·%1 Expenditures Assessor 851,325 821,754 29,571 25% 24% 3,405,300 3,405,300 County Clerk 355,991 268,561 87,430 25% 19% 1,423,965 1,423,965 SOPTA 18,101 14,937 3,164 25% 21% 72,402 72,402 District Attorney 1,219,824 1,067,302 152,522 25% 22% 4,879,296 4,879,296 FinancelTax 203,412 188,557 14,855 25% 23% 813,648 813,648 Veterans 65,529 61,244 4,285 25% 23% 262,115 262,115 Property Management 64,416 62,460 1,956 25% 24% 257,664 257,664 Grant Projects 29,679 28,988 692 25% 24% 118,715 118,715 Non-Departmental 454,241 221,112 233,129 25% 12% 1,816,962 1,816,962 Contingency 1,681,681 1,681,681 25% nfa 6,726,722 6,726,722 4,944,199 2,734,914 2,209,285 25% 14% 19,776,789 13,050,067 6,726,722 Transfers Out 3,232,678 3,303.444 FO,766! 25% 26% 12,930,710 12,930,710 TOTAL REQUIREMENTS 8,176,877 6,038,358 2,138,519 25% 180/0 32,707,499 25,980,777 6,726,722 NET (Resources Requirements) 4,477,550 4,477,551 8,122,447 8,122,447 a) Current year property taxes will be collected beginning in October b) Includes annual payments: Tax on Electric Co-ops $489,027, PIL T $471,823 c) A & T Grant received quarterly d) DA revenue includes: $155,069 HIDTA Grant to be received later in fiscal year and $122,400 Discovery Fee received monthly (YTD actual includes two months of receipts) COMM JUSTICE-JUVENILE Statement of Financial Operating Data Three Months Ended September 30, 2011 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065-Court Assess. Discovery Fee Food Subsidy OVA Basic & Diversion Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous Program Fees MIP Diversion Fees Interest on Investments Leases Grants -Private Behavioral Health CFC Interfund Grant Gen Fund Grant-Crime Prev Year to Date Budget I Actual I Variance IFY % I Coli. % $1,101,374 $1,099,010 $ (2,364) 100% 100% 2,500 (2,500) 25% 0% 12,500 11,194 (1,306) 25% 22% 3,750 2,101 (1,649) 25% 14% 6,250 4,284 (1.966) 25% 17% 54,375 (54,375) 25% 0% a) 22.123 9,000 (13,123) 25% 10% b) 25 (25) 25% 0% 17,500 8,931 (8,569) 25% 13% c) 15 103 88 25% 172% d) 10 (10) 25% n/a 75 420 345 25% 140% d) 1.875 1,648 (227) 25% 22% 600 300 (300) 25% 13% e) 125 300 175 25% 60% 1,500 138 (1.362) 25% 2% 38,532 (38,532) 25% 0% f)g) 5.000 {5,OOOl 25% 0% g) Budget Year End Projection Variance $1,101,374 $1,099,010 $ (2,364) 10,000 10,000 50,000 50,000 15,000 15,000 25,000 25,000 217,498 355,730 138,232 88,490 88,490 100 100 70,000 70,000 60 200 140 40 40 300 825 525 7,500 7,500 2,400 1,200 (1,200) 500 500 6,000 6,000 154.128 134,620 (19,508) 20,000 20,000 Total Revenues 166,755 38,419 (128,336) 25% 6% 667,016 785,205 118,189 Transfers In-General Fund 1,330.365 1,330,365 25% 25% 5.321,459 5,321,459 TOTAL RESOURCES 2,598,494 2,467,794 (130,700) 25% 35% 7,089,849 7,205,674 115,825 REQUIREMENTS: 1 Exp. %1 Expenditures Community Justice-Juvenile Personal Services 1,277.267 1,221,792 55,475 25% 24% h) 5.109,069 5,054,069 55,000 Materials and Services 298,933 250,419 48,514 25% 21% a)f) 1,195,733 1.182,725 13,008 Capital Outlay 25 25 25% 0% 100 100 Transfers Out 12,600 12,600 25% 25% 50,400 50,400 Contingency 183,637 183,637 25% n/a 734,547 734,547 TOTAL REQUIREMENTS 1,772,462 1,484,811 287,651 25% 21% 7,089,849 6,287,194 802,655 NET (Resources -Requirements) 826,032 982,983 156,951 918,480 918,480 a) OVA Basic and Diversion funding increased after budget was submitted. Projections for revenue and expenditures adjusted accordingly. Payments received quarterly b) Billings outstanding -$10,800 c) Contract payments reimbursement requests submitted monthly. Received 1-2 months in arrears d) Revenues trending greater than anticipated -dependent on use of programs or services (MIP Diversion Fees, photocopies. etc) e) Citizen Review Board vacated. Revenue projected adjusted accordingly f) CCF (JCP) funding less than anticipated. Projections of revenue and expenditures adjusted accordingly g) Grants paid quarterly h) Actual for the year projected to be less than budgeted due to vacant positions SHERIFF -Fund 255 Statement of Financial Operating Data Three Months Ended September 30 , 2011 Year to Date Actual Variance VarianceRESOURC~S: Beg. Net WOliking Capital $ $ $ 100% n/a $ $ $ Revenues Law Enf Dist ' Countywide 5,521,2 05 4 ,288.823 (1,232 .382) 25% 19% * 22,084 ,821 19,603,961 (2,480 ,860) 25% 19% * 1 Total Revenrs 9,133,379 7,055,796 (2,077,583) 25% 19% 36,533,516 31,587,765 (4,945,751) TOTAL RESduRCES 9,133,379 7,055,796 (2,077,583) 25% 19% 36,533,516 31,587,765 (4,945,751) REQUIREr.,ENTS: Exp . %1 EXPENDITURES & TRANSFERS Sheriffs Division 624,125 617,381 6,744 25% 25% a) 2,496,498 2,583,942 (87,444) Civil 206,024 178,530 27,494 25% 22% 824,095 824,095 Automotive/Communications 405,552 223,503 182,049 25% 14% b) 1,622,207 1,622 .207 Investigationb/Evidence 433,555 393,494 40,061 25% 23% c) 1,734,218 1,685,549 48,669 patroIlCivil/C\omm Supp 1,977,926 1,915,888 62,038 25% 24% c) 7,911,704 7,841,716 69,988 Records 180,178 149,559 30,619 25% 21% 720,710 720,710 Adult Jail 2,610,948 2,217,808 393,140 25% 21% c) 10,443,790 10,333,479 110,311 Court Security 71,651 69,664 1,987 25% 24% 286,602 286,602 Emergency Services 46,406 43,835 2,571 25% 24% 185,625 185,625 Special Services Division 326,093 300,924 25,169 25% 23% 1,304,370 1.304,370 Regional W drk Center 754,617 694,068 60,549 25% 23% c) 3,018,466 2,969,718 48,748 Training Division 81,066 74,516 6,550 25% 23% 324,265 324,265 IOther Law Epforcement SVC5 158,064 158,320 (256) 25% 25% 632,256 632,256 Non-Depart~ental 18,308 18,308 25% 25% 73,231 73,231 Contingency 1,188,870 1 ,188,870 25% n/a 4 ,755,479 4,755,479 Transfers Out -DIS Fund 50,000 50,000 25% 0% 200,000 200,000 TOTAL REQ41REMENTS 9,133,383 7,055,798 2,077,585 25% 19% 36,533,516 31,587,765 4,945,751 NET (Resources -Requirements) * Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures a) Reclassifica\ion of open Personnel Assistant position to Operations Captain position at a higher salary b) Year to dat~ variance due to timing of transfer payment to Fund 245 for Communications System user fee c) Year to date variance due to open positions which will be filled based on funding and operational needs Fund 701 LED-Countywide Statement of Financial Operating Data Three Months Ended September 30 , 2011 Year to Date Budget I Actual I Variance I FY % I Coil. % RESOURCES: Beg. Net Working Capital $ 5,108,671 $ 6,090,734 $ 982,063 100% 119% $ 5,108,671 $ 6,090,734 $ 982,063 Tax Revenues -Current 3,576,710 (3,576,710) 25% 0% a) 14,306,841 14,627,128 320 ,287 Tax Revenues -Prior 125,250 286,159 160,909 25 % 57% 501,000 501 ,000 Federal Grants 8 ,800 (8 ,800) 25 % 0% 35,200 35 ,200 State Grant 12 ,119 (12 ,119) 25 % 0% 48,475 48,475 Transp. of State Wards 1 ,250 (1,250) 25% 0% 5,000 5,000 SB 1145 384,416 215 ,978 (168,438) 25% 14% b) 1,537,663 1,479,991 (57 ,672) Des. Cty Video Lottery Grant 1,250 (1,250) 25 % 0% 5,000 5,000 Des Cty Court Security 22,750 22,435 (315) 25 % 25% 91,000 91,000 Des Cty Juvenile Contract 1 ,045 (1,045) 25 % 0% 4,180 4 ,180 Title III Reimbursement 37 ,500 (37,500) 25 % 0% 150,000 150 ,000 Transport 250 (250) 25% 0% 1,000 1,000 DC Fair & Expo Center 956 (956) 25% 0% 3,825 3,825 Inmate Commissary Fees 1 ,650 2,319 669 25% 35% 6,600 6,600 Work Center Work Crews 12 ,500 6,675 (5,825) 25% 13% 50,000 50,000 Concealed Handgun Classes 875 1,050 175 25% 30% 3,500 3,500 Soc Sec Incentive-Fed 1,250 2 ,000 750 25 % 40 % 5,000 5 ,000 Miscellaneous 1,250 1,399 149 25 % 28 % 5,000 5 ,000 Oregon Mentors 3,750 2 ,300 (1,450) 25 % 15 % 15 ,000 15,000 Medical Services Reimb 4 ,000 3 ,187 (813) 25% 20% 16 ,000 16,000 Restitution 1,250 1,639 389 25 % 33% 5,000 5,000 Sheriff Fees 50,000 50,124 124 25 % 25 % 200,000 200 ,000 Interest 7 ,083 6,851 (232) 25 % 24% 28 ,333 28,333 Interest on Unsegregated 883 56 (827) 25% 2% 3,533 3,533 Sale of Reportable Assets 250 1,553 1,303 25% n/a 1,000 2,000 1,000 Total Revenues 4,269,037 620,013 p,649,024} 25% 4% 17,076,150 17,339,765 263,615 Year End Budget Projection Variance TOTAL RESOURCES 9,377,708 6,710,747 (2,666,961 ) 25% 30% 22,184,821 23,430,499 1,245,678 REQUIREMENTS: To : Fund 255 Departments Sheriffs Services Civil Auto/Comm Adult Jail Court Security Emergency Services Special Services Work Center Training Other (CODE, Forensic) Internal Services Transfer to Debt Service Contingency Total to Fund 255 585,423 206 ,024 151 ,753 2,610 ,948 71,651 46,406 226,703 754 ,617 49,490 158,064 9,172 50,000 600,956 5,521,205 579,097 178 ,530 83 ,633 2 ,217,808 69 ,664 43,835 209,205 694,068 45,491 158,320 9,172 4,288,824 6,325 27,494 68 ,121 393 ,140 1,987 2,571 17,497 60,549 3,999 (256) (0) 50,000 600,956 1,232 ,382 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% Exp . %1 25% 22% 14% 21% 24% 24% 23% 23% 23% 25% 25% 0% 0% • 2 ,341 ,690 824 ,095 607 ,014 10,443,790 286 ,602 185,625 906 ,811 3 ,018,466 197,961 632,256 36,689 200,000 2,403,823 22,084 ,821 2,423,712 824 ,095 607,014 10,333,479 286,602 185,625 906,811 2,969,718 197,961 632,256 36,689 200,000 19,603,961 (82 ,022) 110,311 48,748 2,403 ,823 2,480,860 Transfer to Reserve Fund (703) 25 ,000 100 ,000 (75 ,000) 25% 100% 100,000 100,000 Total Requirements 11 ,067,411 4 ,388 ,824 6,678 ,586 20% 22 ,184 ,821 19 ,703 ,961 2,480 ,860 Net (1,689,703) 2,321,923 4,011,626 3,726,538 3 ,726 ,538 • Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to LED #1 a) Current year property taxes will be collected beginning in October b) Reduction in State Community Corrections funding for custody of SB 1145 inmates Fund 702 LED Rural Statement of Financial Operating Data Three Months Ended September 30, 2011 Year to Date Year End I Actual Variance Variance RESOURCES: Beg. Net Working Capital $2,936,523 $3,004,533 $ 68,010 100% 102% $2,936,523 $3,004,533 $ 68,010 Revenues Tax Revenues -Current 1,837 ,030 (1,837 ,030) 25% o%a) 7,348 ,125 7,512,627 164,502 T ax Revenues -Prior 64,250 142,740 78 ,490 25% 56% 257,000 257,000 Federal Grants I 3,000 2,319 (681) 25% 19% 12,000 12,000 Federal Grants-BLM 6,250 3,377 (2,873) 25% n/a 25,000 25,000 US Fore f t Service 19,688 (19,688) 25% 0% 78,750 78,750 State Gr~nt 50,243 (50,243) 25% 0% 200 ,972 200,972 SB #1065 Court Assessment , 15,000 11,194 (3 ,806) 25% 19% 60,000 60,000 Marine Board License Fee 35 ,583 (35,583) 25% 0% 142,332 142 ,332 Des Cty General Fund Grant 144 ,036 (144,036) 25% 0% 576 ,144 576,144 Des Cty Transient Room Tax 518,464 518,464 25% 25% 2 ,073,856 2,073,856 City of Si sters 112,490 112,490 25% 25% 449,961 449,961 Des Cty lCDD Contract 13,592 13,592 25% 25% 54 ,366 54,366 Des Cty ISOlid Waste Contr 13,592 13,592 25 % 25% 54,366 54,366 Des Cty Clerk/Election 500 (500) 25% 0% 2,000 2,000 School !:Districts 20,000 (20,000) 25% 0% b ) 80,000 40,000 (40,000) Security l& Traffic Re imb 1,250 680 (570) 25% 14% 5,000 5 ,000 Seat Be ~ Program 3,000 2 ,155 (845) 25% 18% 12,000 12,000 Miscellaneous 2,500 1,472 (1,028) 25% 15% 10,000 10,000 Restituti p n 2,004 2 ,004 25% n/a 2,004 2 ,004 Sheriff F)ees 2,500 2,244 (256) 25% 22% 10,000 10 ,000 Court Fi~es & Fees 28 ,750 26 ,101 (2,649) 25% 23% 115,000 115,000 Impound Fees 1,750 1,200 (550) 25% 17% 7,000 7,000 Restituti bn -Street Crimes 125 (125) 25% 0% 500 500 Seizure/Forfeiture Interest I 2,500 1,324 3,222 1,324 722 25% 25 % n/a 32% 10,000 1,324 10,000 1,324 Interest on Unsegregated 450 28 (422) 25% 2% 1,800 1 ,800 Donatio ~s 2,515 2,515 25% n/a 2 ,515 2,515 Sale of Reportable Assets 1,500 2,305 805 25% 38% 6,000 6,000 Sale of Equip & Material I 5,000 6,916 1,916 25% 35% 20,000 20 ,000 Total Revenues 2,903,043 869,934 l2,033,109! 50% 7% 11,612,172 11,742,517 130,345 TOTAL RESOURCES 5,839,566 3,874,467 (1,965,099) 50% 27% 14,548,695 14,747,050 198,355 REQUIREMENTS: I Exp . %'1 To : Fund ~55 Departments Sheriffs Services 38,702 38,284 418 25% 25% 154,808 160,230 (5,422) Auto/Cornm 253,798 139,870 113,928 25% 14% 1 ,015,193 1,015,193 Investigations 433,555 393,494 40,061 25% 23% 1,734,218 1,685,549 48,669 Patrol 1,977 ,926 1,915,888 62,038 25% 24% 7 ,911,704 7,841 ,716 69,988 Records 180,178 149,559 30,619 25 % 21% 720,710 720 ,710 Special Services 99,390 91,719 7 ,671 25% 23% 397,559 397,559 Training ) 31,576 29 ,025 2 ,551 25% 23% 126,304 126,304 Internal rvices 9,136 9 ,136 25% 25% 36 ,542 36,542 587 14 Transfer to Reserve Fund (704) 25 ,000 100,000 (75,000) 25% 100% 100,000 100,000 Total Requirements 7 ,224 ,348 2,866,974 4,357,373 20% 14 ,548,695 12,083 ,804 2,464,891 Net (1,384 ,782} 1,007,493 2,392,275 2 ,663,246 2,663,246 • Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to LED #2 a) Current year property taxes will be collected beginning in October b) Reimbursement for SRO deputies will be less than planned from the Bend La Pine School District C PUBLIC HEALTH Statement of Financial Operating Data Three Months Ended September 30, 2011 Year to Date Actual Variance Variance RESOURCES: Beg. Net Working Capital $1,596,918 $ 1,702,129 $ 105,211 100% 107% $1,596,918 $1,702,129 $ 105,211 Revenues Medicare Reimbursement 150 70 (80) 25% 12% 600 600 State Grant 646,806 451,815 (194,991) 25% 17% a) 2,587,224 2,587,224 Child Dev & Rehab Center 6,152 (6,152) 25% 0% 24,607 24,607 State Miscellaneous 56,207 3,163 (53,044 ) 25% 1% 224,829 224,829 OMAP 130,963 174,798 43,835 25% 33% 523,850 523,850 Family Planning Exp Proj 130,000 82,328 (47,672) 25% 16% 520,000 520,000 Local Grants 11,250 12,483 1,233 25% 28% 45,000 45,000 Water Program-Base Fee 10,500 9,386 (1,114) 25% 22% 42,000 42,000 Contract Payments 25,000 25,000 25% nfa 25,000 25,000 Water Program-Field Work 13,954 1,680 (12,274) 25% 3% 55,817 55,817 H20 Sys Insp-Priv Wells 50 (50) 25% 0% 200 200 Miscellaneous 3,284 3,284 25% nfa 7,000 7,000 Patient Insurance Fees 33,845 27,594 (6,251 ) 25% 20% 135,380 135,380 Health DepUPatient Fees 29,693 24,241 (5,452) 25% 20% 118,770 118,770 Vital Records-Birth 7,650 10,635 2,985 25% 35% 30,600 30,600 Vital Records-Death 25,000 24,740 (260) 25% 25% 100,000 100,000 Environmental Health 176,088 57,334 (118,754) 25% 8% b} 704,350 704,350 Interest on Investments 3,000 2,084 (916) 25% 17% 12,000 12,000 Donations 6,508 8,384 1,876 25% 32% 26,030 26,030 Interfund Contract 49,597 (49,597) 25% 0% 198,387 198,387 Administrative Fee 3,764 3,764 25% 25% 15,056 15,056 Total Revenues 1,341,177 922,783 (418,394) 25% 17% 5,364,700 5,396,700 32,000 Transfers In-General Fund Transfers In-PH Res Fund Transfers In-Gen. Fund Other 579,441 7,500 16,275 579,441 16,275 (7,500) 25% 25% 25% 25% 0% 25% 2,317,765 30,000 65,100 2,317,765 30,000 65,100 TOTAL RESOURCES 3,541,311 3,220,628 (320,683) 25% 34% 9,374,483 9,511,694 137,211 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 1,535,082 466,595 50,000 71,500 220,444 1,480,423 463,102 71,500 54,659 3,493 50,000 220,444 1 Exp. %1 25% 24% 25% 25% 25% 0% 25% 25% 25% nfa 6,140,327 1,866,381 200,000 286,000 881,775 6,140,327 1,866,381 200,000 286,000 881,775 TOTAL REQUIREMENTS 2,343,621 2,015,025 328,596 25% 21% 9,374,483 8,492,708 881,775 NET (Resources -Requirements) 1,197,690 1,205,603 7,913 1,018,986 1,018,986 a) Monthly payments for some grants not yet processed by DHS. Anticipate receipts for these awards in October b) Line includes 1) Restaurant Fees (FY 2012 Budget=$450,000) and 2) Pool & Spa Fee (FY 2012 Budget=$11 0,000). These are due annually and collected in December and January BEHAVIORAL HEALTH Statement of Financial Operating Data Three Months Ended September 30, 2011 Vearto Date Year End Actual Variance Budget Projection Variance RESOURCeS: Beg. Net Working Capital $ 3,268,759 $ 3,108,163 $ (160,596) 100% 95% $3,268,759 $ 3,108,163 $ (160,596) Revenues Marriage Licenses 1,375 2,355 980 25% 43% 5,500 5,500 Divorce Filing Fees 33,250 45,808 12,558 25% 34% 133,000 133,000 Domestic Partnership Fee 25 20 (5) 25% 20% 100 100 Federal Grants 6,075 (6,075) 25% 0% 24,298 24.298 State Grants 1,327,586 1,999,174 671.588 25% 38% a) 5,310,343 6,878,686 1,568,343 State Miscellaneous 31,043 5,155 (25,888) 25% 4% 124,173 124,173 ABHA 905 905 25% n/a b) 20,000 20,000 Title 19 35,574 27,470 (8,104) 25% 19% 142,297 142,297 Liquor Revenue 26,250 25,024 (1,226) 25% 24% 105,000 105,000 School Districts 18,900 10,100 (8,800) 25% 13% 75,600 75,600 Miscellaneous 43,838 572 (43,266) 25% 0% 175,352 175,352 Patient Insurance Fees 28,425 23,111 (5,314) 25% 20% 113,700 113,700 Patient Fees 452 121 (331) 25% 7% 1,807 1,807 Interest on Investments 6,250 4,955 (1,295) 25% 20% 25,000 25,000 Rentals 3,275 2,250 (1,025) 25% 17% 13,100 13,100 Administrative Fee 1,107,422 1,077,422 (30,000) 25% 24% 4,429,689 4,429,689 Sheriff 5,000 (5,000) 25% 0% c) 20,000 (20,000) Interfund Contract-Gen Fund 31,750 {31,7502 25% 0% 127,000 127,000 Total Revenues 2,706,490 3,224,442 517,952 25% 30% 10,825,959 12,394,302 1,568,343 Transfers In-General Fund 315,879 315,879 25% 25% 1,263,515 1,263,515 Transfers In-OHP-CDO 67,851 67,851 25% 25% 271,402 271,402 Transfers In-Acute Care Svcs 63,129 63,129 25% 25% 252,515 252,515 Transfers In-ABHA 75,216 75,216 25% 25% 300,863 300,863 TOTAL RESOURCES 6,497,324 6,854.680 357.356 25% 42% 16,183.013 17,590,760 1,407,747 REQUIREMENTS: 1 Exp. %1 Expenditures Personal Services 2,385,682 2,297,827 87,855 25% 24% 9,542,729 9,542,729 Materials and Services 1,027,301 869,715 157,586 25% 21% 4,109,205 4,383,668 (274,463) Capital Outlay 100,000 18,814 81,186 25% 5% 400,000 400,000 Transfers Out 71,500 71,500 25% 25% 286,000 286,000 Contingency 461,270 461,270 25% nJa 1,845,079 1,845,079 TOTAL REQUIREMENTS 4,045,753 3,257,856 787,897 25% 20% 16,183,013 14,612.397 1,570,616 NET (Resources -Requirements) 2.451.571 3,596,824 1,145,253 2,978,363 2,978,363 a) Department of Human Services Grant projected at amended contract amount. Additional grant resources will be expended for Personnel and Materials & Services. Projection for Personnel has not yet been updated, pending BOCC approval to add positions. b) Revenue for Adult Mental Health Initiative clients, not included in original budget c) Funding for Mental Health Court from the Sheriff's Department eliminated COMMUNITY DEVELOPMENT Statement of Financial Operating Data Three Months Ended September 30, 2011 Year to Date l;~~" Budget I Actual I Variance I FY % I Coli. % I >i· Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital Revenues Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Prog Planning-Current Planning-Long Range $ 229,822 6,088 250 41,675 300,220 64,788 40,050 70,100 168,725 63,432 131,776 $ (98,046) 8,920 2,832 977 727 50,497 8,822 283,839 (16,381) 68,228 3,440 39,608 (442) 91,143 21,043 187,800 19,075 70,447 7,015 100% 25% 25% 25% 25% 25% 25% 25% 25% 25% 57%' $ 37%8) 98% b) 30%'a) 24%,a) 26% fa) 25% c) 33%.a) 28%:85 28%1,8) 229,822 24,350 1,000 166,700 1,200,880 259,150 160,200 280,400 674,900 253,726 $ 131,776 (98,046) 26,000 1,650 1,500 500 166,700 1,200,880 259,150 160,200 290,000 9,600 674,900 253,726 Total Revenues 755,328 801,459 46,131 25% 3,021,306 3,033,056 11,750 Trans In-GF Trans In-GF for Lng Rng Ping Trans In-Other TOTAL RESOURCES 157,407 123,840 25 1,266,422 157,407 123,840 1,214,482 {25) (51,940) 25% 25% 25% 25% 0% 28% 629,625 495,360 100 4,376,213 629,625 495,360 4,289,817 POOl (86,396) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site pgm Planning-Current Planning-Long Range Transfers Out (DIS Fund) Contingency 352,955 31,939 51,143 140,508 59,355 41,422 35,777 154,751 119,702 43,471 63,032 352,394 29,687 51,030 134,783 63,124 45,536 39,741 136,599 109,502 561 2,252 113 5,725 (3,769) (4,114) (3,964) 18,152 10,200 43,471 63,032 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% Exp.%l:; i 'Wi' 25%':····, 23%" 25%. 24% 27% d) 27%. d) 28% e) 1,411,818 127,755 204,570 562,032 237,420 165,689 143,108 619,002 478,806 173,885 252,128 1,411,818 127,755 204,570 562,032 237,420 165,689 143,108 619,002 478,806 173,885 252,128 TOTAL REQUIREMENTS 1,094,055 962,396 131,659 250/. 22% 4,376,213 4,124,085 252,128 NET (Resources Requirements) 172,367 252,086 79,719 165,732 165,732 Revenues Expenditures Net from Operations 801,459 962,396 p60,938} 3,021,306 4,376,213 (1,354,907) 3,033,056 4,124,085 (1,091,029) 11,750 252,128 263,878 a) Activity is seasonal b) GIS revenue is sporadic based on the frequency of customer requests c) Contract payments from Redmond and other jurisdictions typically lag one month behind service delivery d) Year to date actual includes payout to retired employee e) Extra Help expenses concentrated in the summer months ROAD Statement of Financial Operating Data Three Months Ended September 30, 2011 Year to Date Budget I Actual I Variance IFY % I Coli. % BudQet Year End Projection Variance RESOURCES: Beg. Net Working Capital $2,834,720 $ 3,417,158 $ 582,438 100% 121% $ 2,834,720 $ 3,417,158 $ 582,438 Revenues System Development Charge Federal Reimbursements Federal Grant 150,000 5,000 693 693 (150.000) (5,000) 25% 25% 25% n/a 0% n/a a) 600,000 20,000 2,000 600,000 20,000 2,000 Mineral Lease Royalties 10,000 3,924 (6,076) 25% 10% 40,000 40,000 Forest Receipts 327,791 (327,791) 25% 0% b) 1,311,162 1,311,162 State Miscellaneous 125,010 500,041 375,031 25% 100% c) 500,041 500,041 Motor Vehicle Revenue 2,835,000 2,490,417 (344,583) 25% 22% d) 11,340,000 10,440,000 (900,000) City of Bend 68,750 (68,750) 25% 0% e) 275,000 275,000 City of Redmond 87,500 (87,500) 25% 0% e) 350,000 350,000 City of Sisters 2,500 (2,500) 25% 0% e) 10,000 10,000 City of La Pine 2,500 (2,500) 25% 0% e) 10,000 10,000 Admin Recovery (SOC) 250 893 643 25% 89% 1,000 1,000 Miscellaneous 5,000 6,125 1.125 25% 31% 20,000 20,000 Road Vacations 250 500 250 25% 50% 1,000 1.000 Interest on Investments 5,000 3.958 (1.042) 25% 20% 20,000 20,000 Parking Fees 36 (36) 25% 0% 144 144 Interfund Contract 182,500 (182.500) 25% 0% f) 730,000 730,000 Equipment Repairs 50,000 45,483 (4,517) 25% 23% 200,000 200,000 Vehicle Repairs UD Construction Vegetation Management 22,500 2,500 17,875 (22,500) (2.500) (17,87S) 25% 25% 25% 0% 0% 0% f) f) 90,000 10,000 71,500 90,000 10,000 71,500 Forester 6,250 (6,250) 25% 0% f) 25,000 25,000 Car Washes 875 (875) 25% 0% 3,500 3,500 Sale of Equip &Material 158,250 116,607 (41,643) 25% 18% 633,000 633,000 Total Revenues 4,065,337 3,168,641 (896,698) 25% 19% 16,261,347 15,363,347 (898,OOO) Trans In • Solid Waste 71,443 71,443 25% 25% 285,773 285,773 Trans In· Transp SOC 62,500 62,500 25% 25% 250,000 250,000 Trans In-Road Imp Res 3,000 (3,000) 25% 0% 12,000 12,000 TOTAL RESOUR<:;ES 7,037,000 6,719,742 (317,258) 25% 36% 19,643,840 19,328,278 (315,562) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 1,403,831 2,543,169 309,173 150,000 504,788 1,363,770 4,682,168 21,936 40,061 (2,138,999) 287,237 150,000 504,788 1 Exp. %1 25% 24% 25% 46% 25% 2% 25% 0% 25% nJa g) 5,615,323 10,172,674 1,236,691 600,000 2,019,152 5,615,323 10,172,674 1,236,691 600,000 2,019,152 TOTAL REQUIREMENTS 4,910,961 6,067,874 (1,156.913) 25% 31% 19,643,840 17,624,688 2,019,152 NET (Resources Requirements) 2,126,039 651,868 (1,474,171) 1,703,590 1,703,590 a) Revenue will be received following completion of Cascade Lakes chip seal (October 2011) b) Received annually in January c) Annual payment received in August d) Revenues trending less than estimates provided by ODOT e) Billed upon completion of work f) Payments to be received in June 2012 from other Road Department funds g) Expenditures are seasonal and higher during summer. YTD includes $2.3 million paid to Knife River on the Full Depth Reclamation Project in South County ADULT PAROLE & PROBATION Statement of Financial Operating Data Three Months Ended September 30, 2011 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 Budget $ 560,000 54,338 1,075 7,730 3,250 713,914 6,000 1,025 42,500 50,000 2,250 12,500 12,500 18,708 925,790 84,573 Year to Date I Actual I Variance $ 634,125 $ 74,125 (54,338) (1,075) (7,730) 1,663 (1,587) 401,103 (312,811) 7,563 1,563 452 (573) 32,190 (10,310) 44,676 (5,324) 1,052 (1,198) 12,500 (12,500) (18,708) 501,199 (424,591) 84,573 IFY % I Coil. % 100% 113% 25% 0% 25% 0% 25% 0% 25% 13% 25% 14% 25% 32% 25% 11% 25% 19% 25% 22% 25% 12% 25% 25% 25% 0% 25% 0% 25% 14% 25% 25% a) b) c) d) d) e) e) Budget Year End Projection Variance $ 560,000 $ 634,125 $ 217,350 219,240 4,301 4,301 30,918 25,000 13,000 13,000 2,855,659 2,748,953 24,000 24,000 4,100 4,100 170,000 170,000 200,000 200,000 9,000 9,000 50,000 50,000 50,000 50,000 74,832 74,832 74,125 1,890 (5,918) (106,706) 3,703,160 3,592,426 (110,734) 338,292 338,292 TOTAL RESOURCES 1,570,363 1,219,897 (350,466) 25% 27% .. 4,601,452 4,564,843 (36,609) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 792,172 221,723 25 7,200 129,244 731,454 168,424 7,200 60,718 53,299 25 129,244 1 Exp. %1 25% 23% 25% 19% 25% 0% 25% 25% 25% nla 3,168,688 886,890 100 28,800 516,974 3,168,688 886,890 28,800 100 516,974 TOTAL REQUIREMENTS 1,150,364 907,078 243,286 25% 20% 4,601,452 4,084,378 517,074 NET (Resources -Requirements) 419,999 312,819 (107,180) 480,465 480,465 a) Annual allocation expected in October b) Annual allocation normally received in February c) State invoiced monthly. Payment from State expected in October d) Payments received quarterly; due to lower population and cost savings, revenue will be less than budgeted e) Interfund grant received quarterly. Payment expected in October CHILDREN &FAMILIES COMMISSION Statement of Financial Operating Data Three Months Ended September 30. 2011 RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV -Family Sup/Pres HealthyStart Medicaid Level 7 Services State Prevention Funds HealthyStart /R-S-G OCCF Grant Charges for Svcs-Misc Court Fines & Fees Interest on Investments Donations Interfund Grants Total Revenues Trans from General Fund Vearto Date Budget I Actual I Variance $ 467,111 $ 556,143 $ 89,032 74.872 9.832 23,750 64,496 6.125 77.960 136,301 2,000 19.500 1.250 30,219 446,305 24.136 86 27,223 814 5 22,969 75,233 (74.872) (9.832) (23.750) (64,496) 18,011 (77,960) (136,301) (1,914) 7,723 (436) 5 (7.250) (371,072) 68,240 68,241 Budget Year End Projection Variance $ 467,111 $ 556,143 $ 89,032 299.488 299.488 39.329 39.534 205 95.000 85.000 (10.000) 257.982 196.898 (61,084) 24,500 77,622 53.122 311,838 258,203 (53,635) 545,203 502,290 (42.913) 8,000 8.000 78,000 85,000 7,000 5,000 5,000 5 5 120.875 355,875 235,000 1,785,215 1,912,915 127,700 272,960 272,960 IFY % I Coil. % 100% 119% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 0% a) 0% alb) 0% a)c) 0% alb) 99% d) 0% alb) 0% alb) 1% 35% 16% nfa 19% 4°,4 25% e) f) Total Transfers In 68,240 68,241 25% 25% 272,960 272,960 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 981,656 151,280 421,745 25 58,272 631,322 699,617 142,022 85,099 227,121 (282,040) 9,258 336,646 25 58,272 404,201 25% 25% 25% 25% 25% 25% 28% 1 Exp. %1 23% 5% g) 0% nfa 9% 2,525,286 2,742,018 216,732 605,119 605,119 1,686,979 1,722,729 (35.750) 100 100 233,088 233,088 2,525,286 2,327,948 197,338 NET (Resources -Requirements) 350,334 472,496 122,161 414,070 414,070 a) Grant payments received normally within 60 days after the end of each quarter b) FY 12 and FY 131ntergovemmental Agreement finalized funding levels from OCCF. Community Schools grant included in year end projection at $9,484 c) Medicaid revenues reduced due to lower projections d) Youth Suicide Prevention grant increased by $5.000. Runawaylhomeless youth grant from DHS not budgeted for $48,122 e) Court fees projected to be higher than estimated in the original budget f) Two additional grants of $55,000 &$180,000 awarded g) Sub-grant expenditures paid quarterly SOLID WASTE Statement of Financial Operating Data Three Months Ended September 30, 2011 Year to Date Budget I Actual I Variance I FY % I Coli. % Budget Year End Proiection Variance 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 Total Revenues $1,092,508 5,500 50,000 215,000 328,500 1,000,000 18,250 6,250 1,875 7,500 1,632,875 $ 1,141,691 5,523 8,098 257,673 408,245 1,058,052 33,474 1,081 2,369 2,293 26,760 1,803,568 $ 49,183 23 (41,902) 42,673 79,745 58,052 15,224 (5,169) 494 2,293 19,260 170,693 100% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 105% 25% 4% a) 30% 31% 26% 46% b) 4%-C) 32% nfa d) $1,092,508 22,000 200,000 860,000 1,314,000 4,000,000 73,000 25,000 7,500 1 30,000 6,531,501 $ 1,141,691 22,000 200,000 860,000 1,314.000 4,000,000 73,000 25,000 7,500 10,394 30,000 6,541,894 $ 49,183 10,393 10,393 TOTAL RESOURCES 2,725,383 2,945,259 219,876 25% 7,624,009 7,683,585 59,576 REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out-Road Contingency 417,900 723,263 242,808 43,000 339,943 139,088 398,068 480,489 58,370 527,443 19,832 242,774 242,808 (15,370) (187,500) 139,088 25% 25% 25% 25% 25% 25% Exp. %1 24% 17% 0% f) 34% 39% g) nfa 1,671,598 2,893,052 971,233 172,000 1,359,773 556,353 1,671,598 2,893,052 971,233 172,000 1,359,773 556,353 TOTAL REQUIREMENTS 1,906,002 1,464,370 441,632 25% 19%·7,624,009 7,067,656 556,353 NET (Resources -Requirements) 819,381 1,480,889 661,508 615,929 615,929 a) Due April 15, 2012 b) Seasonal item-Fall and Spring c) Dependent on special clean-ups such as asbestos and contaminated soil d) Revenue from rent on Rickard Road property, not included in original budget e) Recycling markets are higher than expected. Often it can be seasonal 1) To be expended in November ($398,827) and May ($572,406) g) Transfers made quarterly 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 TOTAL RESOURCES AppropriationslExpenditures Direct Insurance Costs: GENERAL LIABILITY Settlement I Benefit Defense Professional Service Insurance Loss Prevention Repair I 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 I Benefit Defense Professional Service Insurance Loss Prevention Miscellaneous Total Workers' Compensation UNEMPLOYMENT -Settlement/Benefits Total Direct Insurance Costs Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET * Contingency is $2,305,693. RISK MANAGEMENT Statement of Financial Operating Data Three Months Ended September 30, 2011 Year to Date Budget I Actual I Variance I % of FY I % Coli. $2,100,000 $2,039,937 ($60,063) 100% 97%. 62,714 62,714 0 25% 25% 77,908 77,908 (0) 25% 25% 44,578 44,578 0 25% 25% 368,486 368,486 25% 25% 63,108 63,189 81 25% 25% 1,250 (1,250) 25% 0% 5,000 9,054 4,054 25% 45%· 375 595 220 25% 40% 13 (13) 25% 0% 4,500 770 (3,730) 25% 4% 3,750 3,094 (656) 25% 21% 13 {13} 25% 0% Budget YearEnd Projection Variance $2,100,000 $2,039,937 ($60,063) 250,855 250,855 311,633 311,633 178,310 178,310 1,473,944 1,473,944 252,433 252,433 5,000 5,000 20,000 20,000 1,500 1,500 50 50 18,000 18,000 15,000 15,000 50 50 631,694 630,388 (1,306) 25% 25% 2,526,775 2,526,775 2,731,694 2,670,325 (61,369, 25% 58% 4,626,775 4,566,712 (60,063) I % Exp. I 10,304 44,105 196 100 29,838 611 100,000 85,153 14,847 25% 21% 87,292 7,494 75,056 94,786 (19,730, 25% 32% 376 2,773 15,592 25,371 18,741 6,630 25% 180/0 228,662 134 54,720 8,714 14 200,000 292,243 (92,243' 25% 37% 621500 621500 25% 0% 462,927 490,924 (27,997) 25% 27% 73.589 41.929 25 115,544 69,393 34,097 103,490 4.196 7,832 25 12,054 25% 25% 25% 25% 24% 20% 0% 22% 1,800 580,271 2,151,423 1,800 596,214 2,074,111 f15,943) {77,313} 25% 25% 25% 26% • 400,000 400,000 300,223 280,000 20,223 101,485 98,000 3,485 800,000 820,000 (20,000) 250,000 250,000 1,851,708 1,848,000 3,708 294,357 167,717 100 462,174 294,357 167,717 462,074 100 100 7,200 2,321,082 7,200 2,317!274 3,808 2,305,693 2,249,438 f56,255} DESCHUTES COUNTY 911 Statement of Financial Operating Data Three Months Ended September 30,2011 Year to Date YearEnd Actual Variance Budget Projection Variance RESOURCES: Beg. Net Working Capital $6,400,000 $ 7,559,639 $ 1,159,639 100% 118% $6,400,000 $7,559,639 $ 1,159,639 Revenues Property Taxes -Current 1,495,943 (1,495,943) 25% 0% a) 5,983,773 6,117,731 133,958 Property Taxes -Prior 50,000 109,595 59,595 25% 55% 200,000 200,000 State Reimbursement 13,500 (13,500) 25% 0% b) 54,000 54,000 Telephone User Tax 187,500 (187,500) 25% 0% 750,000 750,000 Data Network Reimb. 6,800 (6,800) 25% 0% c) 27,200 27,200 Jefferson County 8,750 751 (7,999) 25% 2% 35,000 35,000 User Fee 13,000 (13,000) 25% 0% d) 52,000 52,000 Police RMS User Fees 49,750 (49,750) 25% 0% e) 199,000 199,000 Contract Payments 8,000 (8,000) 25% 0% c) 32,000 32,000 Miscellaneous 2,250 1,845 (405) 25% 21% 9,000 9,000 Interest 8,750 9,557 807 25% 27% 35,000 35,000 Interest on Unsegregated Tax 200 24 ~176~ 25% 3% 800 800 Total Revenues 1,844,443 121,772 (1,722,671) 25% 2% 7,377,773 7,511,731 133,958 TOTAL RESOURCES 8,244,443 7,681,411 (563,032) 25% 56% 13,777,773 15,071,370 1,293,597 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 1,060,209 489,339 218,250 125,000 1,551,646 951,480 429,354 94,731 500,000 108,729 59,985 123,519 (375,000) 1,551,646 25% 25% 25% 25% 25% % Exp·1 22% 22% 11% 100% n/a f) 4,240,834 1,957,356 873,000 500,000 6,206,583 4,240,834 1,957,356 873,000 500,000 6,206,583 TOTAL REQUIREMENTS 3,444,444 1,975,565 1,468,879 25% 14% 13,777,773 7,571,190 6,206,583 NET (Resources -Requirements) 4,799,999 5,705,846 905,847 7,500,180 7,500,180 a) Current year property taxes will be collected beginning in October b) GIS/MSAG monthly billings to Oregon Emergency Management; July and August payments not yet received c) Invoiced annually; invoices being mailed to User Agencies in October d) US Forest Service invoiced $2156.25 quarterly. Payment expected in November. Crooked River Ranch invoiced annually June 30th. Payment will not be received from Crooked River Ranch until FY 13 e) Fees expected to be billed out December or January f) Entire amount budgeted transferred to reserve fund in September Health Benefits Trust Statement of Financial Operating Data Three Months Ended September 30, 2011 RESOURCES Vearto Date Actual Variance Beg. Net Working Capital $15,500,000 $ 15,829,888 $ 329.888 100% 0 $15,500,000 $ 15,829,888 329,888 Revenues: Intemal Premium Charges 3,003,928 2.998,087 (5.841 ) 25% 25% 12,015,711 12,015,711 PIT Emp -Add'i Prem 12,500 7,549 (4,951 ) 25% 15% 50,000 50,000 Employee Prem Contribution 157,500 157,415 (85) 25% 25% 630,000 630,000 COIC 315,000 315,419 419 25% 25% 1,260,000 1,260,000 Retiree I COBRA Co-Pay 125,000 236,305 111.305 25% 47% 500,000 500,000 Fees for Clinic Services 200 200 25% n/a 200 200 Federal Payment * 150,431 150,431 25% nla 150,431 150,431 Prescription Rebates 27.975 27,975 25% nla 27,975 27,975 Interest 20,000 21,677 1,677 25% 27% 80.000 80,000 Total Revenues 3,633,928 3,915,059 281,132 25% 27% 14,535,711 14,714,318 178,607 TOTAL RESOURCES 19,133,928 19,744,948 611,020 92% 103% 30,035,711 30,544,206 508.495 REQUIREMENTS Expenditures: Personal Services Materials & Services 32,516 31,247 1,268 I Exp.o;.1 25% 24% 130,062 130,062 Claims Paid-MedicallRx Claims Paid-DentalNision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Other 3,118,571 465,993 0 87,500 37,500 80,000 12,500 13,750 40,580 2,745,425 453,622 (11,445) 87,543 70,788 78,916 12,156 12.946 44,359 373,146 12,371 11,445 (43) (33,288) 1,084 344 805 P,780! 25% 25% 25% 25% 25% 25% 25% 25% 25% 22% a) 24% a) nla 25% 47% 25% 24% 24% 27% 12,474,284 1,863,974 350,000 150,000 320,000 50,000 55,000 162,318 9,601,901 1,509,166 (11,445) 350,000 150,000 320,000 50,000 55,000 162,318 2,872,384 354,808 11,445 Total HBT • Dept 31 3,888,910 3,525,557 363,352 23% 15,555,638 12,317,002 3,238,636 Deschutes On-site Clinic Healthstat 239,300 124,316 114,984 25% 13% 957,200 957,200 Medications/Drugs 81,250 34,565 46,685 25% 11% 325,000 325,000 Equipment 1.000 1.000 25% 0% 4,000 4,000 Miscellaneous 2,113 5,919 (3,806! 25% 70% 8,450 8,450 Total DOC Capital Outlay Contingency 323,663 50 3,296,306 164,800 158,862 50 3.296,306 25% 25% nla n/a 1,294,650 200 13.185.223 1,294.650 - 200 13,185,223 TOTAL EXPEND/REQUIREMNTS 7,508,928 3,690,357 3.818,570 25% 12% 30,035,711 13,611,652 16,424,059 NET (Resources -Requirements) 11,625,000 16,054,590 4,429,590 16,932,554 16,932,554 * Early Retirement Reinsurance Program (ERRP). Federal program to help pay the cost of insuring retirees who are not yet Medicare eligible. a) Projection based on annualizing 14 weeks of daims paid. YTD actual is $227.686 per week. 10/12/2011 Deschutes County -Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Three Months Ended September 30,2011 Year to Date Budget 1 Actual 1 Variance 1FY % 1 Coil. % YearEnd Budget Projection Variance I RESOLIRCES: 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 $ 75,000 151,250 375 14,500 1,500 7,500 55,000 28,000 11,750 1,702 271,577 $ (40,601) 209,825 125 4,186 38,738 16,000 4,514 273,388 $ (115,601) 58,575 (250) (14,500) (1,500) (3,314) (16,262) (12,000) (11,750) 2.812 1,811 100% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% -54% 35% 8% 0% 0% 14% 18% 14% 0% n/a 25% $ 75,000 605,000 1,500 58,000 6,000 30,000 220,000 112,000 47,000 6,807 1,086,307 $ (40,601) 584,825 1,250 58,000 6,000 34,186 211,738 122,000 47,000 9.020 1,074,019 $ (115,601) (20,175) (250) 4,186 (8,262) 10,000 2,213 (12,288) Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Reserve Fund (617) Total Transfers In 42,500 6,436 20,700 55,000 25 124,661 42,501 6,435 20,700 69,636 (55,000) (25) (55,025) 25% 25% 25% 25% 25% 25% 25% 25% 0% 0% 170.000 25,744 82.800 220.000 100 498,644 170,000 25,744 82,800 220,000 498,544 ~100~ (100) TOTAL RESOURCES 471,238 302,423 (168,815) 25% 18% 1,659,951 1,531,962 (127,989) REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Total Expenditures 216,505 120,265 28,767 25 365,562 214,848 119,500 334,348 1,657 765 28,767 25 31,214 1 Exp. %1 25% 25% 25% 25% 25% 0% 25% 0% 866,018 481,060 115,068 100 1,462,246 864,385 494,577 115,068 1,474,030 1,633 (13,517) 100 (11,784) Transfers Out -Reserve Fund 2,500 2,500 25% 0% 10,000 10,000 Contingency 46,926 46,926 25% n/a 187,705 187,705 TOTAL REQUIREMENTS 414,988 334,348 80,640 25% 20% 1,659,951 1,484,030 175,921 NET (Resources· Requirements) 56,250 (31,925} (88,175} 47,932 47,932 I I I •.~ 1 'I 1 I « I i i i I I i J j i, i i lj I 1 ! .~ I j .~ l 1 rI:J. ~ U ~ 0 ~ ~ ~ ~ < ~ ~ ~ < U IZl::s 0.. 8 a:I U >. ...... c S U ..c: 1:: 0 Z • c c- 8 CIJ ..c: CIJ...... -5 CIJ a:l • .. ,~ II. RESOURCES: 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 Planning Interfund Charges Fees, Permits & SDCs Utilities Travel-Meals/Mileage Reimb Total Materials & Services Capital Outlay Land and Building Remodel Total Capital Outlay Contingency Total Expenditures Net Deschutes County North County Services Building Inception through September 30,2011 Received and Expended ACTUAL Encumbrances & Commitments Project to Date 1,402,013 25,000 600,000 709 2,027,722 1,402,013 25,000 600,000 709 2,027,722 a) b) 25,000 25,000 50,000 b) 416 416 726 726 26,142 51,142 1,402,013 230 1,402,243 1,402,013 230 1,402,243 a) 1,428,384 599,337 25,000 (25,OOO) 1,453,384 574,337 PROJECTION Project Budget 2,000,000 1,402,013 25,000 600,000 4,027,013 100,000 10,000 1,663 60,000 2,000 173,663 1,402,013 2,451,337 3,853,350 4,027,013 Projected 2,000,000 1,402,013 25,000 600,000 709 ~027,722 100,000 10,000 1,663 60,000 2,000 1,402,013 2,451,337 3,853,350 4,027,013 709 I Variance 709 709 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) 709 _".........,I'.""""_~__ .c~~~~"""""_....., . ____ ----~~~-~----~=-~ ... North County Services Building -Fund 462 ENCUMBRANCES AND COMMITMENTS Through September 30,2011 Vendor Description Commitment Amount Amount Paid Balance Due BLRB/GGL Architects Architectural Services 50,000 25,000 25,000 50,000 25,000 25,000 Deschutes County Bethlehem Inn (Fund 128) Three Months Ended September 30, 2011 Actual Bud~et I Projection I Variance RESOURCES: Beg. Net Working Capital $ (2,711,235) $ (2,716,581) $ (5,346) 100% 100% $ (2,711,235) $(2,716,581) $ (5,346) Revenues Grants -Private 700,457 (700,457) 25% 0% 2,801,827 -(2,801,827) Lease Payments 6,102 8,136 2,034 25% 33% * 24,408 24,408 Total Revenues 706,559 8,136 (698,423) 25% 0% 2,826,235 24,408 (2,801,827) TOTAL RESOURCES (2,004,676) (2,708,445) (703,769) 25% ·2355% 115,000 (2,692,173) (2,807,173) REQUIREMENTS: Exp·%1 Expenditures Debt Service: Interest Expense 3,750 3,806 (56) 25% 25% a) 15,000 15,000 Interest Payment 25,000 25,000 25% 0% 100,000 100,000 TOTAL REQUIREMENTS 28,750 3,806 24.944 25% 3% 115,000 15,000 100.000 NET (Resources -Requirements) (2.033,426) (2,712.251) (678,825) b) (2,707,173) (2,707,173) * October lease payment received September 29. a) Interest on September 2011 negative cash balance: $1,188.90. b) Inception through September 30,2011 Revenues -Lease Payments $ 32,544 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 226,883 Total expended 2,744,795 Net $ {2,712,251) Deschutes County -Solid Waste Area A Closure and Cell 5 Construction As of September 30, 2011 "Area A" "Cell 5" ~w Gapltal Landfill Closure Projects Fund Fund 611 613 Total IEngineering Contract I I G. Friesen Associates, Inc. Original Contract 241,869.00 182,516.00 424,385.00 I Change Orders: Change Order #1 (Note a) DEQ requirement for gas detection 19,656.00 19,656.00 Change Order #2 LFG well field management SOPs 21,500.00 21,500.00 Change Order #3 Storm sewer realignment. drainage, Area A thickness 34,316.00 33,431.00 67,747.00 Total Contract 317,341.00 215,947.00 533,288.00 Amount Paid Through June 30, 2011 (Final payment made December 2010) 317,341.00 215,947.00 533,288.00 Balance Due (Construction gontract I M A DeAtley Construction Inc Original Contract -@ estimated cu.yd. 2,097,140.50 3.290.779.98 5.387,920.48 Amended Contract -@ revised cu.yd. and damages 2.284,885.13 3.552,521.82 5,837,406.94 Change Orders: Change Order #1 Meet CEC requirements, increase to electrical panel, 45,095.00 45,095.00 Change Order #2 Storm sewer realignment due to refuse encountered 14,302.54 14.302.54 Change Order #3 Revise valve vaults for improved efficiencies 24,885.69 24,885.69 Change Order #4 Add'i cover material from what will be Cell 6 32,690.70 32,690.70 Change Order #5 Environmental controls building, pump station bulkheads 148,958.89 148,958.89 Change Order #6 Adjustment to pipe alignment to increase slope 1,332.00 1,332.00 Change Order #7 (not likely to occur) Change Order #8 Additional rock to be set aside for future needs 204,700.00 204,700.00 Change Order #9 Manhole covers below grade to meet Road Dept requirements 2,486.98 2,486.98 Change Order #10 Modular Block Wall instead of MSE Wall 5,167.76 5,167.76 Change Order #11 Upgrade of cables (pump and leachate) 2,200.00 2,200.00 Change Order #12 Leachate Line connection from Cell 5 to Cells 3 & 4 6,354.75 6,354.75 Change Order #13 Additional cover material due to settling 55,853.20 55,853.20 Change Order #14 Well modification, flow meter less LFG vaults 5,938.50 5,938.50 Damages (35,OOO.00) (35,000.00) Total Contract 2,422,374.74 3,929,998.22 6,352,372.95 Amount Paid Through June 30, 2011 2,343,073.99 3,798.516.46 6,141,590.45 July 1, 2011 through July 31, 2011 Balance Due 79,300.75 131,481.76 210,782.50 Total of Engineering and Construction Contracts: Original Contracts ... ~ )i, y 2,526,754.13 3,735,037.82 6,261,791.94 Change Orders and Damages \ \y 212,961.61 410.907.40 623,869.01 Total Contract 2,739,715.74 4.145.945.22 6,885,660.95 Amount Paid '\(j/ ;;:.:. 4,014 6,674,878.45Through Seplember 30, 2011 • J; > 0 2,660,414.99 1463.46 79,300.75 131,481.76 210,782.50 Balance Due J /1'/ ¥ Deschutes County General Support Services -SOCC Conference/Seminar, EducationlTraining and Travel Expenditures and SOCC -County College Expenditures FY 2012 -----...-'-----....------....--.,--.--.....----r---r----r------i------I BOCC Conference & Travel Sep YTD Total Ta_mmy B!I'!.~_______......__ _confl~~rn & Educ!fraini!1J;L 665 665 • ....L_.______ ....._______ Travel Meals 220 220 ._----_...._-_..... -..-----_...._-----.~ Accom modations 996 211 1,207 ---..... --_....._---- ....~. -----"~-.- ----~ Airfare _.. Mileag~!~imbursernE!!!L __ Ground Transport/Parking ,~---~--. ------_....._._--_._-.... Total Ban~y ... 1,661 ~Ian Un9~_r___.."" ..___._____. _goQ.fISem & ~duclT~~i,!ing __ 665 Travel Meals ----...--:------_... Accommodations 1,131--...------.-----.-~-.------ Airfare ~,~'!Cl9~ reim~rsem~~ __ Ground Transport/Parking -Total Un~e.!,_ ___.____ ,~-1,796~i~-" 1,796 Tony_DeBo,!~___,_ ~------------------. ~<!lf!Sem_~Educll"!.aining _ 665 665 Travel Meals Accommodations 908 908----"-_....-- Airfare ___ ~11~?9~ rei'!!~lJrsef'!1~Q!___ ... _____ _. ______ , 300 _,, ____ }09 Ground Transport 54 54 -TotaiOther ---,-------------1,573:---354 1,927 Total-BOCC Department ~--~--------------. _Conf7Sem&Ecf~JIraininQ:=-1,330 ,995 ~~...-.----~...----- ----... Travel Meals 220 220 ----_..._-----,._----------_..._------_.---, Accommodations ______ 1,'-904______ 211 3,245-_...._.-------_.....,_._--- Airfare _.... _-----_. -----------:-.. _~JlileClge R~!!1bur~~rrt.~_L ______, ____ 30Q______ !..!!~_ 1,094 _GrouQ_d Transp~_______ 54 150 204 _Total.:...I!QCC D_ep~~!"e!l! ______~~~~--_ 354.!..31~_;_'!,7_~9_ - ... ..~---- 14,750 45.8% I!Q~~~oun_ty ~~II~ge __ _ Public Information -~---~-~~... ...--.,. Office/Copier Supplies 120 120 Meeting Supplies -------... -,--,====~,~==~~-~====~. 9/30/2011 RV Park (Fund 601) Statement of Financial Operating Data Three Months Ended September 30,2011 RESOURCES: Beg. Net Working Capital $10,000 $ (28,100) $ (38,100) 100% nfa $10,000 $ (28,100) $ (38,100) Revenues RV Park Fees < 31 Days 44,625 84,949 40,324 25% 48% a) 178,500 178,500 RV Park Fees> 30 Days 1,850 1,300 (550) 25% 18% a) 7,400 7,400 Tent Space Rental 200 (200) 25% 0% 800 800 Washer / Dryer 398 708 310 25% 44% 1,593 1,593 Vending Machines 300 298 (2) 25% 25% 1,200 1,200 City of Redmond 1,000 (1,000) 25% 0% 4,000 4,000 Room Tax Collection Fee 25% nfa Interest on Investments 37 37 25% nfa 37 37 Cancellation Fees 1,060 1,060 25% nfa 1,060 1,060 Total Revenues 48,373 88,351 39,978 25% 46% 193,493 194,590 1,097 Transfers In-Fund 130 35,000 {35,000) 25% 0% 140,000 140,000 TOTAL RESOURCES 93,373 60,252 (33,121) 25% 18% 343,493 306,490 (37,003) REQUIREMENTS: Expenditures 1 Exp. %1 Materials & Services 21,431 29,774 (8,343) 25% 35% 85,722 85,722 Debt Service Contingency 3,736 3,736 25% 25% 0% nfa 242,829 14,942 242,829 14,942 TOTAL REQUIREMENTS 25,167 29,774 (4,607) 25% 9% 343,493 328,551 14,942 NET (Resources -Requirements) 68,206 30,477 (37,729) (22,061) (22,061) a) 2,695 RV spaces rented I Building Services - 620 Statement of Financial Operating Data Three Months Ended September 30, 2011 RESOURCES: Beg. Net Working Capital Revenues CleaninglMaintenance Insurance Reimbursement Utility Reimbursement Facilities Charge to State Miscellaneous Interest on Investments Interfund contract Building Svcs Indirect Chgs Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Transfer to Veh Reserve Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources -Requirements) Year to Date Budget I Actual JVariance IFY% J Coli. % $ 424,000 $ 529,500 $ 105,500 100% n/a 40,845 21,690 (19,156) 25% 13% 9,331 9,331 25% n/a 1,000 683 (317) 25% 17% 47,004 29,374 (17,630) 25% 16% 6 6 25% n/a 750 801 51 25% 27% 2,500 2,500 (0) 25% 25% 497,810 497,807 25% 25% Year End Bu(jget Projection Variance $ 424,000 163,380 4,000 188,016 3,000 10,000 1,991,229 $ 529,500 $ 105,500 163,380 4,000 188,016 7,000 10,000 1,991,229 4,000 589,909 562,191 ~27,715~ 25% 24% 2,359,625 2,363,625 4,000 1,013,909 1,091,692 77,785 25% 39% 2,783,625 2,893,125 109,500 420,171 1 Exp. %1 418,801 1,370 25% 25% 1,680.685 1,680,685 190,640 165,657 24,982 25% 22% 762,558 762,558 9,900 9,900 25% 25% 39,600 39,600 25 25 25% 0% 100 100 75,171 75,171 25% 0% 300,682 300,682 695,906 594,358 101,548 25% 21% 2,783,625 2,482.943 300,682 318,003 497,334 179,334 410,182 410,182 Admin Services -625 Statement of Financial Operating Data Three Months Ended September 30,2011 Year to Date YearEnd Budget I Actual I Variance IFY% I CoiL % Budget Projection Variance I RESOURCES: Beg. Net Working Capital $ 183,000 $ 158,276 $ (24,724) 100% nfa $ 183,000 $ 158,276 $ (24,724) Revenues Miscellaneous 20 20 25% nJa 20 20 Interest on Investments 240 240 25% nfa 240 240 Admin Dept Indirect Chgs 220,435 220,434 {O) 25% 25% 881,738 881,738 Total Revenues 220,435 220,694 260 25% 25% 881,738 881,998 260 Transfers In-General Fund 10,000 10,000 25% 25% 40,000 40,000 TOTAL RESOURCES 413,435 388,970 (24,464) 25% 35% 1,104,738 1,080,274 (24,464) REQUIREMENTS: Expenditures Personal Services Materials and Services Transfer to Veh Reserve Capital Outlay Contingency 215,317 27,162 900 25 32.780 372,805 20.880 900 (157,487) 6.282 25 32,780 I Exp. %1 25% 43% 25% 19% 25% 25% 25% 0% 25% 0% 861,269 108.648 3,600 100 131,121 861,269 108,648 3,600 100 131,121 TOTAL REQUIREMENTS 276,185 394,585 (118,400) 25% 36% 1,104,738 973,617 131,121 NET (Resources -Requirements) 137,250 ,5,614} 1142,864} 106,657 106,657 BOCC -628 Statement of Financial Operating Data Three Months Ended September 30, 2011 Year to Date Year End Budget I Actual I Variance IFY% I Coil. % Budget Projection Variance I RESOURCES: Beg. Net Working Capital $ 115,000 $ 114,142 $ (858) 100% n/a $ 115,000 $ 114,142 $ (858) Revenues Sale Map Photo or Copies 6 6 25% n1a I nterest on Investments 125 168 43 25% n1a 500 500 Admin Dept Indirect Chgs 90,205 90,205 1 25% 25% 360,820 360.820 TOTAL RESOURCES 205,330 204,521 (809) 25% 43% 476,320 475,462 (858) REQUIREMENTS: 1 Exp. %1 Expenditures Personal Services 84,416 84,374 42 25% 25% 337,664 337,664 Materials and Services 22,390 20,459 1,931 25% 23% 89,561 89.561 Capital Outlay 25 25 25% 0% 100 100 Contingency 12,249 12,249 25% 0% 48.995 48.995 TOTAL REQUIREMENTS 119,080 104,833 14,247 25% 22% 476,320 427,225 49,095 NET (Resources -Requirements) 86,250 99,688 13,438 48,237 48,237 I Finance· 630 Statement of Financial Operating Data Three Months Ended September 30, 2011 RESOURCES: Beg. Net Working Capital Revenues Investment Fee Photo copies IGA Contracts Interest on Investments Interfund Contracts Finance Dept Indirect Chgs Year to Date Budget I Actual I Variance IFY% I Coil. % $ 603,000 $ 788,522 $ 185,522 10,000 38 3,862 1,000 3,000 206,969 7,855 95 1,067 3,000 206,968 (2,145) 57 (3,862) 67 ~O! 100"10 nfa 25% 20% 25% 63% 25% 0% 25% 27% 25% 25% 25% 25% Year End Budget Projection Variance $ 603,000 40,000 150 15,446 4,000 12,000 827,874 $ 788,522 $ 185,522 40,000 95 15,446 4,000 12,000 827,874 (56) Total Revenues 224,868 218,985 (5,883) 25% 24% 899,470 899,415 (56) TOTAL RESOURCES 827,868 1,007,507 179.639 25% 67% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 226,283 68,726 2,500 78,109 212,282 100,575 14,001 (31,850) 2,500 78,109 I Exp·%1 25% 23% 25% 37010 25% 0% 25% 0% TOTAL REQUIREMENTS 375,618 312,857 62,760 25% 21% 1,502,470 1,687,936 185,466 905,131 274,902 10,000 312,437 905,131 274,902 10,000 312,437 1,502,470 1,180,033 322,437 NET (Resources· Requirements) 452,250 694,650 242,400 507,903 507,903 a) Will be paid in June 2011. I Legal-640 Statement of Financial Operating Data Three Months Ended September 30, 2011 RESOURCES: Beg. Net Working Capital Revenues Sale Map Photo or Copies Miscellaneous Interest on Investments Interfund Contract Legal Counsel Indirect Chgs Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources· Requirements) Year to Date YearEnd Budget I Actual I Variance IFY% I Coli. % Budget Projection Variance $ 148,500 $ 154,921 $ 6,421 100% nfa $ 148,500 $ 154,921 $ 6,421 75 123 48 25% 41% 300 300 250 (250) 25% 0% 1,000 1,000 375 264 (111 ) 25% 18% 1,500 1,500 2,375 (2,375) 25% 0% 9,500 9,500 188,658 188,658 0 25% 25% 754,632 754,632 191,733 189,044 (2,689) 340,233 343,966 3,733 187,880 11,161 25 29,793 166,520 6,165 21,360 4,995 25 29,793 228,858 172,685 56,173 111,375 171,281 59,906 25% 38% I Exp. %1 25% 22% 25% 14% 25% 0% 25% 0% 25% 19% 766,932 766,932 915,432 921,853 6,421 751,519 44,642 100 119,171 751,519 44,642 100 119,171 915,432 796,161 119,271 125,692 125,692 I Personnel· 650 Statement of Financial Operating Data Three Months Ended September 30. 2011 Year to Date Year End Budget I Actual I Variance IFY% I Coli. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 305,500 $ 360,650 $ 55,150 100% n/a $ 305,500 $ 360,650 $ 55,150 Revenues Miscellaneous 250 115 (135) 25% 11% a) 1,000 115 (885) Interest on Investments 750 548 (202) 25% 18% 3.000 3,000 Personnel Indirect Chgs 181,333 181,333 ° 25% 25% 725,330 725,330 Total Revenues 182,333 181,995 (338) 25% 250/0 729,330 728,445 (885) TOTAL RESOURCES 487,833 542,644 54,812 1,034,830 1,089,094 54,264 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 152.646 76,852 25 29.184 148,325 35,055 4,321 41,797 25 29,184 I Exp. %1 25% 24% 25% 11% 25% 0% 25% 0% 610.584 307,409 100 116,737 610.584 307,409 100 116,737 TOTAL REQUIREMENTS 258,708 183,380 75,327 25% 18% 1,034,830 917,993 116,837 NET (Resources -Requirements) 229,125 359,264 130,139 171,101 171,101 a) Manley Services Payment I Information Tech -660 Statement of Financial Operating Data Three Months Ended September 30,2011 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Interest on Investments Leases I T Indirect Chgs Total Revenue Transfers In-General Fund Year to Date Budget I Actual I Variance IFY% I Coli. % $ 513,000 1,000 5,250 505,811 $ 650,653 $ 137,653 50 983 8,201 505,811 50 (17) 2,951 100% nfa 25% n/a 25% 25% 25% 39% 25% 25% 512,061 515,045 2,984 25% 25% 16,500 16,500 25% 25% TOTAL RESOURCES 1,041,561 1,182,198 140,637 25% 45% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 457,041 129,521 25 70,225 428,929 102,908 28,111 26,613 25 70,225 1Exp. %1 25% 23% 25% 20% 25% 0% 25% 0% TOTAL REQUIREMENTS 656,811 531,837 124,974 25% 20% Year End Budget Projection Variance $ 513,000 $ 650,653 $ 137,653 4,000 21,000 2,023,245 50 4,000 21,000 2,023,245 50 2,048,245 2,048,295 66,000 66,000 2,627,245 2,764,948 137,703 1,828,162 518,085 100 280,898 1,828,162 518,085 100 280,898 2,627,245 2,346,247 280,998 NET (Resources -Requirements) 384,750 650,361 265,611 418,701 418,701 50 IT Reserve -661 Statement of Financial Operating Data Three Months Ended September 30,2011 Year to Date Budget I Actual J Variance JFY% I Coli. % Revised Year End Budget Projection Variance J RESOURCES: Beg. Net Working Capital $ 304,896 $ 340,594 $ 35,698 100% n/a $ 304,896 $ 340.594 $ 35,698 Revenues Interest 375 532 157 25% 35% 1,500 1,500 IT Reserve Charges 58,500 58,500 0 25% 25% 234,000 234,000 Total Revenue 58,875 59,032 157 25% 25% 235,500 235,500 TOTAL RESOURCES 363,771 399,626 35,855 25% 74% 540,396 576,094 35,698 REQUIREMENTS: I Exp.%l Expenditures Materials and Services 27,875 27,875 25% 0% b) 111,500 111,500 Capital Outlay 24,750 24,750 25% 0% b) 99,000 99,000 Res for Future Expenditure 82,474 82,474 25% 0% 329.896 329,896 TOTAL REQUIREMENTS 135,099 135,099 25% 0% 540,396 210,500 329,896 NET (Resources -Requirements) 228,672 399,626 170,954 365,594 365.594 a) From Solid Waste