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 (2)
Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA December 5,2011 (1) Monthly Investment Report (2) October 2011 Financials Commercial Paper Corporate Notes Time Certificates U. S. Treasuries Federal Agencies Bankers' Acceptances LGIP/BOTC Total Investments $ 8,684,347 9,305,763 27,294,111 57,912,956 $ 103.197.178 1 0.00% 8.42% 9.02% O.OO-fa 26.45-/0 O.OO-fa 56.120(, - Investments By County Function General $ 103,197,178 $ Investment Income Fiscal Year 2011-12 Oct-11 I I Y-T-D 151,472 $ 308,550 -- Total Investments $ 103,197,178 Total Investment Income Less Fee: 5% of Invest. Income Investment Income -Net 1$ 151,472 ~7,574~ 143,899 308,550 p5,427) $ 293,122 Total Portfolio: By Investment Types Corporate Notes 8% Time Certificates 9% Federal Agencies 27% 56% Category Maximums: cG tt, '-ILGIP 100% U.S. Treasuries 100"10 3 Month Treas. ~ 0.01% ~Federal Agencies 75% I 12 Month Treas. ~ 0.11 % Banker's Acceptances 25% 3 Month C P ~ 0.20% Time Certificates 25"10 Commercial Paper 20"10 Corporate Notes 10% Average Maturity in Days General ---640 Memorandum Date: November 14, 2011 To: Board of County Commissioners Erik Kropp, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find October 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 Four Months Ended October 31,2011 Year to Date $ Actual Variance Variance RESOURCES: Beg. Net Working Capital $ 7,300,000 $ 8,245,725 $ 945,725 100% 113% $7,300,000 $8,245,725 $ 945,725 Revenues Property Taxes 6,700,322 1,966,782 (4,733.540) 33% 10% a) 20,100,967 20,550,967 450,000 Gen. Rev. -excl. Taxes 794,107 1.321,568 527,461 33% 55% b) 2,382.321 2,382,321 Assessor 263.665 399,093 135,428 33% 50% c) 790,996 790,996 County Clerk 489,569 461,079 (28,490) 33% 31% 1,468,707 1,468,707 SOPTA 4,133 8,236 4,103 33% 66% c) 12,398 12,398 District Attorney 99,556 35,062 (64,494) 33% 12% d) 298,669 298,669 Finance/Tax 64,633 119,090 54,457 33% 61% c) 193,900 193,900 Veterans 20,447 300 (20.147) 33% 0% 61.341 61,341 Property Management 32,067 35,067 3,000 33% 36% 96,200 96,200 Grant Projects 667 667 33% 33% 2,000 2,000~O~ Total Revenues 8,469,166 4,346,942 (4,122,224) 33% 17% 25,407,499 25,857,499 450,000 TOTAL. RESOURCES 15,769,166 12,592,667 (3,176,499) 33% 39% 32,707,499 34,103,224 1,395,725 REQUIREMENTS: I Exp·%1 Expenditures Assessor 1,135,100 1,087,338 47,762 33% 32% 3,405,300 3,405,300 County Clerk 474,655 343,007 131,648 33% 24% 1,423,965 1,423,965 SOPTA 24,134 18,637 5,497 33% 26% 72,402 72,402 District Attorney 1,626,432 1,442,506 183,926 33% 30% 4,879,296 4,879,296 FinancelTax 271,216 251,201 20,015 33% 31% 813,648 813.648 Veterans 87.372 82,831 4,541 33% 32% 262,115 262,115 Property Management 85,888 83,800 2.088 33% 33% 257,664 257,664 Grant Projects 39,572 38,461 1,111 33% 32% 118,715 118,715 Non·Departmental 605,654 328,973 276,681 33% 18% 1,816,962 1,816,962 Contingency 2,242,241 2,242,241 33% n/a 6,726,722 6,726,722 • 6,592,264 3,676,755 2,915,509 33% 19% 19,776,789 13,050,067 6,726,722 Transfers Out 4,310,237 4,255,839 54,398 33% 33% 12,930.710 12,930,710 TOTAL. REQUIREMENTS 10,902,501 7,932,514 2,969,907 33% 24% 32,707,499 25,980,777 6,726,722 NET (Resources -Requirements) 4,866,_ 4,660,073 (206,592) 8,122,447 8,122,447 a) October is the first month current year property taxes are collected. b) Includes annual payments: Tax on Electric Co.ops $489,027, PILT $471,823 c) A & T Grant received quarterly·July, October, January & April 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 three months of receipts) RESOURCES: 8eg. Net Working Capital Revenues Federal Grants SB #1 065-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 Total Revenues Transfers In-General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Community Justice-Juvenile Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources· Requirements) COMM JUSTICE·JUVENILE Statement of Financial Operating Data Four Months Ended October 31. 2011 Budget Year End Projection Variance Vearto Date Budget I Actual I Variance IFY % I Coli. % $1,101,374 $1,099,010 $ (2,364) 100% 100% 3,333 (3,333) 33% 0% a) 16,667 15.603 (1.064) 33% 31% 5.000 3,663 (1,337) 33% 24% 8,333 6,418 (1.915) 33% 26% 72,499 94,675 22,176 33% 44% b) 29,497 19,800 (9,697) 33% 22% c) 33 (33) 33% 0% 23,333 20,506 (2,827) 33% 29% d) 20 169 149 33% 282% e) 13 (13) 33% n/a 100 600 500 33% 200% e) 2,500 3,316 816 33% 44% 800 500 (300) 33% 21% f) 167 300 133 33% 60% 2,000 138 (1,862) 33% 2% 51,376 33,655 (17,721) 33% 22% g)h) 6,667 5,000 (1,667) 33% 25% h) ----~~~----~~----~~~ 222,338 204,343 (17,995) 33% 31% 1,773,820 1,773,820 33% 33% 667,016 5,321,459 756,715 5,321,459 89,699 3,097,532 3,077,173 (20,359) 33°/, 43% I Exp·%1 7,089,849 7,177,184 87,335 1.703.023 1.636.088 66.935 33% 32% i) 5.109.069 5,054.069 55.000 398.578 347.164 51,414 33% 29% b)g) 1.195.733 1.182.725 13.008 33 33 33% 0% 100 100 16.800 12.600 4.200 33% 25% 50,400 50,400 244.849 244,849 33% nla 734,547 734.547 2,363,283 1,995,852 367,431 33% 28% 7,089,849 6,287,194 802,655 734,249 1,081,321 347,072 889,990 889,990 $1,101,374 $1,099,010 $ 10,000 10,000 50.000 50,000 15.000 15,000 25.000 25.000 217,498 355,730 88,490 60,000 100 100 70,000 70,000 60 200 40 40 300 825 7,500 7,500 2,400 1,200 500 500 6,000 6,000 154.128 134,620 20,000 20,000 (2,364) 138.232 (28,490) 140 525 (1.200) (19.508) a) Outstanding $2.100 Federal Grant billing. reimbursed quarterly in arrears b) OVA Basic and Diversion funding increased after budget was submitted. Projections for revenue and expenditures adjusted accordingly. Payments received quarterly c) Fees paid for housing for youth from other jurisdictions, need fluctuates and trending lower than anticipated. Billings outstanding -$2,700 d) Contract payments reimbursement requests submitted monthly. Received 1-2 months in arrears e) Revenues trending greater than anticipated -dependent on use of programs or services (MIP Diversion Fees, photocopies, etc) f) Citizen Review Board vacated. Revenue projected adjusted accordingly g) CCF (JCP) funding less than anticipated. Projections of revenue and expenditures adjusted accordingly h) Grants paid quarterly i) Actual for the year projected to be less than budgeted due to vacant poSitions SHERIFF -Fund 255 Statement of Financial Operating Data Four Months Ended October 31,2011 Year to Date Budget I Actual I Variance I FY % I Coli . % RESOURCES: Beg. Net Working Capital $ $ $ 100% "fa $ $ $ Revenues Revised Year End Budget Projection Variance Law Enf Dist C ou ntywide 7 ,36 1,607 5,89 9 ,8 10 (1,461 ,7 97 ) 33% 27% * 22,084 ,821 19 ,50 7,126 (2 ,577 ,695) 33% 28% * Total Revenues 12,177,839 TOTAL RESOURCES 12,177,839 REQUIREMENTS: EXPENDITURES & TRANSFERS 9,906,069 9,906,069 824,063 240,772 648,130 522,621 2,647,572 201 ,138 2,993 ,372 92,252 58,547 420 ,709 927,171 97,081 208,234 24,410 Sheriffs Division Civil Automotive/Communications Investigations/Evidence PatrollCivillComm Supp Records Adult Jail Court Security Emergency Services Special Services Division Regional Work Center Training Division Other Law Enforcement Svcs Non-Departmental Contingency Transfers Out -DIS Fund 832,166 274,698 540,736 578,073 2,637,235 240,237 3,481,263 95,534 61,875 434,790 1,006,155 108,088 210,752 24,410 1,585,160 66,667 (2,271,770) (2,271,770) 8,103 33,926 (107,394) 55,452 (10,337) 39 ,099 487 ,891 3,282 3,328 14,081 78,984 11,007 2,518 1,585,160 66,667 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 27% 27% Exp . %1 33% a) 29% b) 40% b) 30% c) 33% c) 28% 29% c ) 32% 32% 32% 31% c) 30% 33% 33% nfa 0% d) 36,533,516 36,533,516 2,496 ,498 824,095 1,622,207 1,734,218 7,911,704 720,710 10,443,790 286,602 185,625 1,304 ,370 3,018,466 324,265 632 ,256 73,231 4,755,479 200,000 31,439,971 31,439,971 2,583,942 784,095 1,622,207 1,657,814 7,818,492 720,710 10,284 ,725 286,602 185 ,625 1,304,370 2,961,637 324,265 632,256 73,231 200 ,000 (5,093,545) (5,093,545) (87,444) 40 ,000 76,404 93,212 159,065 56,829 4,755,479 TOTAL REQUIREMENTS 12,177,839 9,906,072 2,271,767 33% 27% 36,533,516 31,439,971 5,093,545 NET (Resources· Requirements) * Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures a) Reclassification of open Personnel Assistant position to Operations Captain position at a higher salary b) Year to date 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 d) Semi-annual transfer in November and May Fund 701 LED-Countywide Statement of Financial Operating Data Four Months Ended October 31,2011 Year to Date Actual Variance 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 4,768,947 1,069,850 (3 ,699,097) 33% 7% a) 14,306,841 14,627,128 320,287 Tax Revenues -Prior 167,000 361 ,982 194,982 33% 72% 501,000 501,000 Federal Grants 11 ,733 (11 ,733) 33% 0% 35,200 35,200 State Grant 16,158 (16 ,158) 33% 0% 48,475 48,475 Transp. of State Wards 1,667 3 ,240 1 ,573 33 % 65% 5,000 5 ,000 SB 1145 512,554 739,996 227,442 33% 48% b) 1,537,663 1,479,991 (57,672) Des . Cty Video Lottery Grant 1,667 (1 ,667) 33% 0% 5,000 5 ,000 Des Cty Court Security 30,333 29,913 (420) 33% 33% 91,000 91,000 Des Cty Juvenile Contract 1 ,393 2 ,219 826 33% 53% 4 ,180 4 ,180 Title III Reimbursement 50,000 (50,000) 33% 0% c) 150,000 150,000 Transport 333 (333) 33% 0% 1,000 1,000 DC Fair & Expo Center 1,275 (1,275) 33% 0% 3,825 3,825 Inmate Commissary Fees 2,200 3,349 1,149 33% 51% 6,600 6 ,600 Work Center Work Crews 16 ,667 14 ,685 (1 ,982) 33 % 29% 50 ,000 50,000 Concealed Handgun Classes 1,167 1 ,050 (117) 33% 30% 3 ,500 3 ,500 Soc Sec Incentive-Fed 1,667 2 ,200 533 33 % 44% 5,000 5,000 Miscellaneous 1,667 2,532 865 33% 51% 5,000 5 ,000 Oregon Mentors 5,000 2 ,300 (2,700) 33% 15 % 15,000 15,000 Medical Services Reimb 5 ,333 5 ,043 (290) 33% 32% 16,000 16,000 Restitution 1,667 1,717 50 33% 34% 5,000 5,000 Sheriff Fees 66,667 72 ,188 5 ,521 33% 36% 200 ,000 200,000 Interest 9,444 12,119 2,675 33% 43% 28,333 28,333 Interest on Unsegregated 1 ,178 175 (1,003) 33% 5% 3 ,533 3 ,533 Sale of Reportable Assets 333 1,553 1,220 33% n/a 1,000 2,000 1,000 Total Revenues 5,692,050 2,351,769 (3,340,281 ) 33% 14% 17,076,150 17,339,765 263,615 Budget Year End Projection Variance TOTAL RESOURCES 10,800,721 8,442,503 (2,358,218) 33% 38% 22,184,821 23,430,499 1,245,678 REQUIREMENTS: I Exp . %1 To: Fund 255 Departments Sheriffs Services 780 ,563 772,963 7 ,601 33% 33% 2 ,341,690 2,423,712 (82 ,022) Civil 274,698 240,772 33,926 33% 29% 824,095 784,095 40,000 Auto/Comm 202,338 242,524 (40,186) 33% 40% 607,014 607,014 Adult Jail 3,481 ,263 2,993,372 487,891 33% 29% 10,443,790 10,284,725 159,065 Court Security 95 ,534 92,252 3,282 33% 32% 286 ,602 286 ,602 Emergency Services 61 ,875 58,547 3,328 33% 32% 185,625 185,625 Special Services 302,270 292,481 9,789 33% 32% 906,811 906 ,811 Work Center 1,006,155 927 ,171 78 ,984 33% 31% 3,018,466 2 ,961,637 56 ,829 Training 65 ,987 59 ,267 6,720 33% 30% 197,961 197 ,961 Other (CODE , Forensic) 210 ,752 208 ,234 2,518 33% 33% 632,256 632,256 Internal Services 12,230 12,229 0 33% 33% 36,689 36 ,689 Transfer to Debt Service 66 ,667 66,667 33% 0% 200,000 200,000 Contingency 801,274 801,274 33% 0% .. 2,403,823 2,403,823 Total to Fund 255 7,361,607 5.899 ,812 1,461,795 22,084,821 19 ,507,126 2,577,695 Transfer to Reserve Fund (703) 33 ,333 100 ,000 (66,667) 33% 100% d) 100,000 100,000 Total Requirements 14,756 ,547 5,999,812 8,756,734 27% 22,184,821 19,607,126 2,577,695 Net (3 ,955 ,826) 2,442,691 6 ,398,517 3 ,823 ,373 3,823 ,373 * Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to LED #1 a) Approximately 85% of the property taxes are collected in October and November b) Reduction in State Community Corrections funding for custody of SB 1145 inmates c) Reimbursement requested semiannually in January and June d) Transfer made in September Fund 702 LED Rural Statement of Financial Operating Data Four Months Ended October 31,2011 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 2,449,375 540,021 (1,909,354) 33% 7% a) 7 ,348,125 7,512,627 164,502 Tax Revenues -Prior 85,667 180,667 95,000 33% 70% 257,000 257,000 Federal Grants 4,000 2,319 (1,681 ) 33% 19% 12,000 12,000 Federal Grants-BLM 8,333 3,377 (4,956) 33% nla 25,000 25,000 US Forest Service 26,250 19,688 (6,562) 33% 25% 78,750 78,750 State Grant 66,991 4,485 (62,506) 33% 2% 200,972 200,972 SB #1065 Court Assessment 20,000 15,603 (4,397) 33% 26% 60,000 60,000 Marine Board License Fee 47,444 (47,444) 33% 0% b) 142,332 142,332 Bureau of Reclamation 4,189 4,189 33% nla c) 20,000 20,000 Des Cty General Fund Grant 192,048 (192,048) 33% 0% 576,144 576,144 Des Cty Transient Room Tax 691,285 691,285 33% 33% 2 ,073,856 2,073 ,856 City of Sisters 149,987 149,987 33% 33% 449 ,961 449,961 Des Cty CDD Contract 18,122 18,122 33% 33% 54,366 54,366 Des Cty Solid Waste Contr 18,122 18,122 33% 33% 54,366 54,366 Des Cty Clerk/Election 667 (667) 33% 0% 2,000 2,000 School Districts 26,667 (26,667) 33% 0% d) 80,000 40,000 (40,000) Security & Traffic Reimb 1,667 680 (987) 33% 14% 5 ,000 5,000 Seat Belt Program 4 ,000 2,750 (1,250) 33% 23% 12,000 12,000 Miscellaneous 3,333 2,450 (883) 33% 25% 10,000 10,000 Restitution 2 ,054 2,054 33% nla 5,000 5,000 Sheriff Fees 3,333 2,920 (413) 33% 29% 10,000 10,000 Court Fines & Fees 38,333 34,251 (4,082) 33% 30% 115,000 115,000 Impound Fees 2,333 1,400 (933) 33% 20% 7,000 7,000 Restitution -Street Crimes 167 (167) 33% 0% 500 500 SeizurelForfeiture 1,324 1,324 33% nla 1,324 1,324 Interest 3,333 5,068 1,735 33% 51% 10,000 10,000 Interest on Unsegregated 600 88 (512) 33% 5% 1,800 1,800 Grants-Private 2,000 2,000 33% nla 2,000 2,000 Donations 2,515 2,515 33% nla 2,515 2,515 Sale of Reportable Assets 2,000 2,307 307 33% 38% 6,000 6 ,000 Sale of Equip & Material 6 ,667 6,916 249 33% 35% 20,000 20,000 Total Revenues 3,870,724 1,714,588 ~2,156,1361 50% 15% 11,612,172 11 1767,513 155,341 TOTAL RESOURCES 6,807,247 4,719,121 (2,088,126) 50% 32% 14,548,695 14,772,046 223,351 REQUIREMENTS: 1 Exp. %1 To: Fund 255 Departments Sheriffs Services 51,100 502 33% 33% 154,808 160,230 (5,422) Auto/Comm 405,606 (67,208) 33% 40% 1,015,193 1,015,193 Investigations 522,621 55,452 33% 30% 1,734,218 1,657,814 76,404 Patrol 2,647,572 (10,337) 33% 33% 7,911,704 7,818,492 93,212 Records 201,138 39,099 33% 28% 720 ,710 720,710 Special Services 128,228 4 ,292 33% 32% 397,559 397,559 Training 37,814 4,287 33% 30% 126,304 126,304 Internal Services 12,181 33% 33% 36,542 36,542 Contin enc 783,885 33% 0% 2,351,656 i1 Transfer to Reserve Fund (704) 33,333 100,000 (66,667) 33% 100% e) 100,000 100,000 Total Requirements 9,632,463 4,106,260 5,526,203 28% 14,548,695 12,032,845 2,515,850 Net (2,825,216) 612,861 3,438,078 2,739,201 2,739,201 • Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to LED #2 a) Approximately 85% of the property taxes are collected in october and November b) Reimbursement requested semiannually in January and June c) BOR patrol contract signed after budget adopted d) Reimbursement for SRO deputies will be less than planned from the Bend La Pine School District e) Transfer made in September I 1 .~ 1 I j I I ~ ~ 1 1 I t ll 1 .. PUBLIC HEALTH Statement of Financial Operating Data Four Months Ended October 31.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 200 70 (130) 33% 12% 600 600 State Grant Child Dev &Rehab Center State Miscellaneous 862,408 8,202 74.943 781.336 3,197 (81.072) (8,202) (71,746) 33% 33% 33% 30% 0% 1% a) 2,587.224 24.607 224,829 2,587,224 24,607 224,829 OMAP 174,617 219,520 44,903 33% 42% 523,850 523,850 Title 19 156 156 33% nla 300 300 Family Planning Exp Proj Local Grants 173,333 15,000 82,328 34,675 (91,005) 19.675 33% 33% 16% 77% 520,000 45,000 520,000 53,695 8,695 Water Program-Base Fee 14,000 9,386 (4,614) 33% 22% 42,000 42,000 Contract Payments 25,000 25,000 33% nla 25,000 25,000 Water Program-Field Worl< 18,606 14,295 (4,311 ) 33% 26% 55,817 55,817 H20 Sys Insp-Priv Wells 67 (67) 33% 0% 200 200 Miscellaneous 3,284 3,284 33% nfa 7,000 7,000 Patient Insurance Fees 45,127 50,142 5,015 33% 37% 135,380 135,380 Health Dept/Patient Fees 39,590 30,495 (9,095) 33% 26% 118,770 118,770 Vital Records-Birth 10,200 13,645 3,445 33% 45% 30,600 30,600 Vital Records-Death 33,333 33,285 (48) 33% 33% 100,000 100,000 Environmental Health 234,783 72,293 (162,490) 33% 10% b) 704,350 704,350 Interest on Investments 4,000 4,156 156 33% 35% 12,000 12,000 Donations 8,677 8,568 (109) 33% 33% 26,030 26,030 Interfund Contract 66,129 17.852 (48,277) 33% 9% a) 198.387 198,387 Administrative Fee 5,019 5,019 33% 33% 15.056 15,056 Total Revenues 1,788,234 1,408,702 (379,532) 33% 26% 5,364,700 5,405,695 40,995 Transfers In.-General Fund 772,588 772,588 33% 33% 2,317,765 2,317,765 Transfers In·PH Res Fund 10,000 (10,000) 33% 0% 30,000 30,000 Transfers In-Gen. Fund Other 21.700 16,275 !5,425~ 33% 25% 65,100 65,100 TOTAL RESOURCES 4,189,440 3,899,694 (289,746) 33% 42% 9,374,483 9,520,689 146,206 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 2,046,776 622,127 66,667 95,333 293,925 1,985.134 581,403 71,500 61,642 40,724 66,667 23.833 293,925 I EXP·%I 33% 32% 33% 31% 33% 0% 33% 25% 33% 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 3,124,828 2,638,037 486,791 33% 28% 9,374,483 8,492,708 881,775 NET (Resources -Requirements) 1,064,612 1,261,657 197,045 1,027,981 1,027,981 a) Billed quarterly. in arrears b) Line includes, among other items, 1) Restaurant Fees (FY 2012 Budget=$45O,OOO) and 2) Pool &Spa Fee (FY 2012 Budget=$110,OOO). These are due annually and collected in December and January BEHAVIORAL HEALTH Statement of Financial Operating Data Four Months Ended October 31,2011 Actual Variance Year to 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.833 2.730 897 33% 50% 5,500 8,000 2,500 Divorce Filing Fees 44,333 56,684 12,351 33% 43% 133,000 150,000 17,000 Domestic Partnership Fee 33 25 (8) 33% 25% 100 100 Federal Grants 8,099 (8,099) 33% 0% a) 24,298 24,298 State Grants 1,723,448 2,799,377 1.075,929 33% 54% b) 5,170,343 6,878,686 1,708,343 State Miscellaneous 41,391 10,310 (31,081) 33% 8% a) 124,173 124,173 ABHA 905 905 33% nla c) 20,000 20,000 Title 19 94,099 44.928 (49,171) 33% 16% 282,297 282,297 Liquor Revenue 35,000 37,039 2,039 33% 35% 105,000 105,000 School Districts 25,200 20.750 (4,450) 33% 27% 75,600 75,600 Miscellaneous 58,451 2,123 (56,328) 33% 1% 175,352 175,352 Patient Insurance Fees 37,900 28,589 (9,311 ) 33% 25% 113,700 113,700 Patient Fees 602 310 (292) 33% 17% 1.807 1,807 Interest on Investments 8,333 10,264 1,931 33% 41% 25,000 25,000 Rentals 4,367 3,625 (742) 33% 28% a) 13,100 13,100 Administrative Fee 1,476,563 1,436,563 (40,000) 33% 32% 4,429,689 4,429,689 Sheriff 6,667 (6,667) 33% 0% d) 20,000 (20,000) Interfund Contract-Gen Fund 42.333 37,287 (5,046) 33% 29% 127,000 127.000 Comm. on Children & Fam 725 725 33% nla 725 Total Revenues 3,608,652 4,492,234 883,582 33% 41 Gk 10,825,959 12,554,527 1,728,568 Transfers In-General Fund 421,172 421,172 33% 33% 1,263,515 1,263.515 Transfers In-OHP-CDO 90,467 90,468 33% 33% 271,402 271,402 Transfers In-Acute Care Svcs 84,172 84,172 33% 33% 252.515 252,515 Transfers In-ABHA 100,288 75,216 ~25,O721 33% 25% e) 300,863 300,863 TOTAL RESOURCES 7,573,510 8,271,425 697,914 33% 51% 16,183,013 17,750,985 1,567,972 REQUIREMENTS: I Exp. %1 Expenditures Personal Services 3,180,910 3,055,838 125,072 33% 32% 9,542,729 9,542,729 Materials and Services 1,369,735 1,538,345 (168,610) 33% 37% 4,109,205 4,383,668 (274,463) Capital Outlay 133,333 27,121 106,212 33% 7% 400,000 400,000 Transfers Out 95,333 71,500 23,833 33% 25% 286,000 286,000 Contingency 615,026 615,026 33% nla 1,845,079 1,845,079 TOTAL REQUIREMENTS 5,394,337 4,692,804 701,533 33% 2rk 16,183,013 14,612,397 1,570,616 NET (Resources Requirements) 2,179,173 3,578,621 1,399,447 3,138,588 3,138,588 a) Billed quarterly, in arrears b) 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. c) Revenue for Adult Mental Health Initiative clients, not included in original budget d) Funding for Mental Health Court from the Sheriffs Department eliminated e) Transfer made quarterly 725 500 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Four Months Ended October 31, 2011 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 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 Total Revenues Trans In·GF Trans In-GF for Lng Rng Ping Trans In-Other TOTAL RESOURCES Year to Date Budget I Actual I Variance $ 229,822 8,117 333 55,567 400,293 86,383 53,400 93,467 224,967 84,575 1,007,102 209,876 165,120 33 131,776 $ (98,046) 10,585 2,468 1,012 679 64,516 8,949 372,090 (28,203) 89,490 3,107 42,869 (10,531) 113,052 19,585 242,039 17,072 91,679 7,104 1,027,331 20,229 209,876 165,120 {33} 1,611,953 1,534,104 (77,849) I FY% I Coli. % 100% 57% 33% 43% 33% 101% 33% 39% 33% 31% 33% 35% 33% 27% 33% 40% 33% 36% 33% 36% 33% 34% 33% 33% 33% 33% 33% 0% 33% 35% 470,606 42,585 68,190 187,344 79,140 55,230 47,703 206,334 159,602 57,962 84,043 468,001 39,552 68,310 180,927 79,639 58,977 53,087 186,550 145,738 2,605 3,033 (120) 6,417 (499) (3,747) (5,384) 19,784 13,864 57,962 84,043 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% Exp·%1 33% 31% 33% 32% 34% 36% 37% 30% 30% 0% nfa TOTAL REQUIREMENTS 1,458,739 1,280,781 177,959 33% 29% a) b) a) a) a) c) a) a) a) d) d) e) f) $ 229,822 $ 131,776 24,350 27,000 1,000 1,500 166,700 170,000 1,200,880 1,175,000 259,150 262,000 160,200 160,200 280,400 300,000 674,900 685,000 253,726 260,000 3,021,306 629,625 495,360 100 4,376,213 1,411,818 127,755 204,570 562,032 237,420 165,689 143,108 619,002 478,806 173,885 252,128 3,040,700 629,625 495,360 4,297,461 1,411,818 127,755 204,570 562,032 237,420 165,689 145,000 610,000 450,000 173,885 4.376,213 4,088,169 (98,046) 2,650 3,300 (25,880) 2,850 19,600 10,100 6,274 19,394 {100} (78,752) (1,892) 9,002 28,806 252,128 288,044 NET (Resources -Requirements) 153,214 253,323 100,109 209,292 209.292 Revenues Expenditures Net from Operations 1,027,331 1,280,781 {253,449} 3,021,306 4,376,213 {1,354,907} 3,040,700 4,088,169 {1,047,469 l 19,394 288,044 307,438 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 f) Transfers made November ($160,242) &May ($13,643) ROAD Statement of Financial Operating Data Four Months Ended October 31, 2011 RESOURCES: Beg. Net Working Capital Revenues System Development Charge Federal Reimbursements Federal Grant Mineral Lease Royalties Forest Receipts State Miscellaneous Motor Vehicle Revenue City of Bend City of Redmond City of Sisters City of La Pine Admin Recovery (SOC) Miscellaneous Road Vacations Interest on Investments Parking Fees Intertund Contract Equipment Repairs Vehicle Repairs LID Construction Vegetation Management Forester Car Washes Sale of Equip & Material Total Revenues Trans In -Solid Waste Trans In -Transp SOC Trans In-Road Imp Rea TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources -Requirements) Vearto Date Actual I Variance IFY % I Coli. % $2.834.720 $ 200,000 6,667 13,333 437,054 166,680 3,780,000 91,667 116,667 3,333 3,333 333 6,667 333 6,667 48 243,333 66,667 30,000 3,333 23,833 8,333 1,167 211,000 3.417.158 $ 924 600,000 5,845 500,041 3,542,540 4,248 1,092 8,170 500 6,932 67,696 1,756 184,808 582,438 924 400,000 (6,667) (7,488) (437,054) 333,361 (237,460) (91,667) (112,419) (3,333) (3,333) 759 1,503 167 265 (48) (243,333) 1,029 (30,000) (3,333) (23,833) (8,333) 589 (26,192) 100% 121% 33% nla 33% 100% 33% nla 33% 15% 33% 0% 33% 100% 33% 31% 33% 0% 33% 1% 33% 0% 33% ()O~ 33% 109% 33% 41% 33% 50% 33% 35% 33% 0% 33% 0% 33% 34% 33% 0% 33% 0% 33% 0% 33% 0% 33% 50% 33% 29% 5,420,448 4.924,552 (495.896) 33% 30% 95,258 71,443 (23,815) 33% 25% 83,333 62,500 (20,833) 33% 25% 4,000 (4,000) 33% 0% Budget YearEnd Projection Variance $ 2,834,720 $ 3.417.158 $ 582.438 a) b) c) d) e) e) e) e) f) f) f) f) 600,000 20,000 40,000 1,311,162 500,041 11,340,000 275,000 350,000 10,000 10,000 1,000 20,000 1,000 20,000 144 730,000 200,000 90,000 10,000 71,SOO 25,000 3,500 633,000 16,261,347 2,000 600,000 20,000 40,000 1,311,162 500,041 10,440,000 275,000 350,000 10,000 10,000 2,500 20,000 1,000 20,000 144 730,000 200,000 90,000 10,000 71,500 25,000 3,500 633,000 15.364.147 2,000 (900,000) 1,500 (896.500) 285,773 250,000 12,000 285,773 250,000 12,000 19.643.840 19.329.778 (314.062) 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 19,643,840 17,624,688 2,019,152 1,705,090 1,705.090 8,437,759 1,871,774 3,390,891 412.230 200.000 673,051 8.475,653 1,821,768 5,122,552 21,936 58.727 SO,006 (1,731,661) 390.294 200,000 673,051 6.547.946 6,966,256 (418.310) 1,889,813 1,509,397 P59,583! 33% 43% I Exp·%1 33% 32% 33% 50% 33% 2% 33% 0% 33% n/a 33% 35% 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.5 million paid to Knife River on the Full Depth Reclamation Project in South County , \ ADULT PAROLE & PROBATION Statement of Financial Operating Data Four Months Ended October 31. 2011 RESOURCES: Beg. Net Working Capital Revenues DOC Measure 57 State Miscellaneous Altemate Incarceration State Subsidy SB 1145 Probation Work Crew Fees Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Interest on Investments Interfund -Sheriff Crime Prevention Grant CFC-Domestic Violence Total Revenues Transfers In-General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS Year to Date Budget I Actual I Variance IFY % I Coli. % $ 560,000 $ 634,125 $ 74,125 10011". 113% 72,450 1,434 10.306 4,333 951,885 8.000 1,367 56,667 66.667 3,000 16.667 16,667 24,944 1,234,387 6.913 1,374.278 9,325 632 45,620 61,244 2,082 16.667 18,708 1,535,469 (72,450) (1,434) (10,306) 2,580 422,393 1.325 (735) (11,047) (5,423) (918) (16.667) (6,236) 301,082 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 3311". 0% 0% 0% 53% 48% 39% 15% 27% 31% 23% 33% 0% 25% 41 8". a) b) c) d) d) e) e) 112,764 1,907,151 112,764 2,282,358 375,207 33% 33% 33% 50% ! Exp.%! 1,056,229 295,630 33 9,600 172,325 987,860 227,038 7,200 68,369 68,592 33 2,400 172,325 33% 33% 33% 33% 33% 31% 26% 0% 25% nla 1,533,817 1,222,098 311,719 33'-27% Budget Year End Projection Variance $ 560,000 $ 634,125 $ 74,125 217,350 219,240 1,890 4,301 4,301 30,918 25,000 (5,918) 13,000 13,000 2,855,659 2,748,953 (106,706) 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 3,703,160 3,592,426 (110,734) 338,292 338,292 4,601,452 4,564,843 (36,609) 3,168,688 886,890 100 28.800 516,974 3,168,688 886,890 28,800 100 516,974 4,601,452 4,084,378 517,074 NET (Resources -Requirements) 373,334 1,060,260 686,926 480,465 480,465 a) Annual allocation expected in December. Waiting for IGA. Plan has been approved b) Annual allocation normally received in February c) State invoiced quarterly. Payment from State expected in November d) Payments received quarterly. Forecasted population smaller than budgeted e) Interfund grant received quarterly. Payments have been requested CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Four Months Ended October 31. 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 OCCFGrant Program Fees Charges for Svcs-Misc Court Fines & Fees Interest on Investments Donations Interfund Grants Total Revenues Trans from General Fund Total Transfers In Vearto Date Budget I Actual I Variance IFY % I Coil. % Budget YearEnd 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) 200 200 8.000 8,000 78,000 85,000 7,000 5,000 5,000 300 300 120,875 355,875 235,000 1,785,215 1,913,410 128,195 272,960 272.960 272,960 272,_ $ 467,111 $ 556,143 $ 89,032 99.829 25,503 (74,326) 13,110 (13,110) 31,667 (31,667) 85,994 (85,994) 8,167 24,061 15,894 103,946 (103,946) 181,734 (181,734) 75 75 2,667 567 (2,100) 26,000 34.011 8,011 1,667 1,523 (144) 71 71 40,292 22.969 (17,323) --~~~----~~~--~~~ 595,073 108,780 (486,293) 90,987 90.988 -----~~~----~~~-------- 90,987 90,988 100% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 119% 9% a) 0% alb) 0% a)c) 0% alb) 98% d) 0% alb) 0% alb) n/a e) 7% 44% f) 30% n/a e) 19% g) 6% 33% 33% TOTAL RESOURCES 1,153,171 755.911 (397,261) 33% 30% 2,525,286 2,742,513 217,227 REQUIREMENTS: I Exp·%1 Expenditures Personal Services 201,706 190.851 10,855 33% 32% 605.119 605.119 Materials and Services 562.326 414,687 147,639 33% 25% h) 1,686,979 1,722.729 (35.750) Capital Outlay 33 33 33% 0% 100 100 Contingency 77,696 77.696 33% nfa 233,088 233.088 TOTAL REQUIREMENTS 841,761 605,538 236,223 33% 24% 2,525,286 2,327,948 197,338 NET (Resources -Requirements) 311,410 150.373 i161 ,038} 414,565 414,565 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. Runaway/homeless youth grant from DHS not budgeted for $48,122 e) Youth Suicide Prevention training donations & fees expected to be received f) Court fees projected to be higher than estimated in the original budget g) Two additional grants of $55,000 &$180,000 awarded h) Sub-grant expenditures paid quarterly SOLID WASTE Statement of Financial Operating Data Four Months Ended October 31, 2011 Year to Date Budget I Actual I Variance I FY % I CoiL % Budget Year End Projection 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 7,333 66.667 286.667 438,000 1,333,333 24.333 8,333 2,500 10,000 2,177,166 $ 1,141,691 7,216 10,837 322.192 519,631 1,394,412 41,889 1,723 4,633 2.293 37.005 2,341,831 $ 49,183 (117) (55,830) 35.525 81,631 61,079 17,556 (6.610) 2.133 2,293 27,005 164,665 100% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 105% 33% 5% a) 37% 40% 35% 57% b) 7% c) 62% nfa d) 123% e) 36% $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 60,000 6,571,894 $ 49,183 10,393 30.000 40,393 TOTAL RESOURCES 3,269,674 3,483,522 213,848 33°A. 46% 7,624,009 7,713,585 89,576 REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out-Road Transfers Out-Res Fund Contingency 557,199 964,351 323,744 57,333 95,258 358,000 185,451 530,092 733,553 58,370 71,443 456.000 27,107 230,798 323,744 (1,037) 23.815 (98,000) 185,451 33% 33% 33% 33% 33% 33% 33% Exp. %1 32% 25% 0% f) 34% 25% g) 42% nfa 1,671.598 2,893,052 971.233 172,000 285,773 1,074.000 556,353 1,671.598 2,893,052 971,233 172,000 285,773 1,074,000 556,353 TOTAL REQUIREMENTS 2,541,336 1,849,458 691,878 33% 24% 7,624,009 7,067,656 556,353 NET (Resources -Requirements) 728,338 1,634,064 905,726 645,929 645,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 f) To be expended in November ($398.827) and May ($572,406) g) Transfers made quarterty RESOURCES: Beginning NetWorking 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 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Repair I Replacement Total General Liability PROPERTY DAMAGE Insurance Repair I Replacement Total Property Damage VEHICLE Professional Service Insurance Loss Prevention Repair / Replacement Total Vehicle WORKERS' COMPENSATION Settlement / Benefit Insurance Loss Prevention Miscellaneous Total Workers' Compensation UNEMPLOYMENT· SettlementlBenefits Total Direct Insurance Costs Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET RISK MANAGEMENT Statement of Financial Operating Data Four Months Ended October 31,2011 Year to Date Budget I Actual I Variance I% of FY I % Coli. 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 2,526,n5 2,526,775 4,626,775 4,566,712 (60,063) 400,000 300,223 400,000 278,000 22,223 101,485 98,000 3,485 800,000 250,000 840,000 250,000 (40,000) 1,851,708 1.866.000 (14,292) 294,357 294,357 167,717 167,717 100 100 462,174 462,074 100 7,200 7,200 2,321,082 2,335,274 114,1921 .. 2,305,693 2,231,438 174,255} $2,100,000 83,618 103,878 59,437 491,315 84.144 1,667 6.667 500 17 6,000 5,000 17 $2,039,937 83,618 103,878 59,437 491.315 84,252 9,054 595 1,820 6,022 842,258 839,990 ($60,063) 0 0 (0) 0 108 (1,667) 2,387 95 (17) (4,180) 1,022 !17l (2,269) 100% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 97% 33% 33% 33% 33% 33% 0% 45% 40% 0% 10% 40% 0% 33% 2,942,258 2,879,927 (62,332) 33% 62% I % Ex!:!. I 133,333 106,812 102,111 196 106,914 5.517 321,550 (188,217) 33% 80% 100,074 115,975 7,494 123,469 (23,395) 33% 41% 33,828 376 2,972 19,404 22,753 11,076 33% 22% 266,667 366,415 64.668 9,013 10,735 450,831 (184,164) 33% 56'-. 83,333 83,333 33% 0% 617.236 918,603 (301.367) 33% 50% 98,119 55,906 33 154,058 90,396 47,072 137,468 7,723 8,833 33 16,590 33% 33% 33% 33% 31% 28% 0% 30% 2,400 773,694 1,800 1,057,871 600 (284,177) 33% 33% 25% 46% 2,168,564 1,822,056 ~346,508~ .. Contingency is $2,305,693. DESCHUTES COUNTY 911 Statement of Financial Operating Data Four Months Ended October 31,2011 Year to Date Actual Variance 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,994,591 444,094 (1,550,497) 33% 7% a) 5,983,773 6,117,731 133,958 Property Taxes· Prior 66,667 139,476 72,809 33% 70% 200,000 200,000 Federal Grants 92.958 92,958 33% n/a 203,958 203,958 State Reimbursement 18,000 4,698 (13.302) 33% 9% b) 54.000 54,000 Telephone User Tax 250,000 193.349 (56,651) 33% 26% 750,000 750,000 Data Network Reimb. 9.067 28,612 19.545 33% 105% c) 27,200 34.698 7,498 Jefferson County 11,667 871 (10,796) 33% 2% 35,000 35,000 User Fee 17.333 (17,333) 33% 0% d) 52,000 52,000 Police RMS User Fees 66,333 (66,333) 33% 0% e) 199,000 199,000 Contract Payments 10.667 18,808 8.141 33% 59% c) 32.000 33.061 1,061 Miscellaneous 3.000 3,190 190 33% 35% 9,000 9.000 Interest 11,667 18,189 6.522 33% 52% 35,000 35,000 Interest on Unsegregated Tax 267 73 p94~ 33% 9% 800 800 Total Revenues 2,459,259 944,318 (1,514,941) 33% 13% 7,377,773 7,724,248 346,475 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 8,859,259 1,413,611 652,452 291.000 166.667 2,068,861 8,503,957 1.265,887 517.911 117,572 500,000 (355,302) 147,724 134.541 173,428 (333.333) 2,068,861 33% 33% 33% 33% 33% 33% 62% % Exp·1 30% 26% 13% 100% n/a f) 13,777,773 4,240,834 1,957.356 873.000 500,000 6,206,583 15,283,887 4.240,834 1,957,356 873.000 500,000 1,506,114 6,206.583 TOTAL REQUIREMENTS 4,592,591 2,401,370 2,191,221 33% 17% 13,777,773 7,571,190 6,206,583 NET (Resources· Requirements) 4,266,668 6,102,587 1,835.919 7,712,697 7.712,697 a) Approximately 85% of the property taxes are collected in October and November b) GIS/MSAG monthly billings to Oregon Emergency Management; September and October payments not yet received c) Invoiced annually; majority of payments received 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 Four Months Ended October 31,2011 Year to Date Bu4get J Actual J Variance IFy%1 Coli. % YearEnd Budget Projection Variance J RESOURCES Beg. Net Working Capital $15,500,000 $ 15,829,888 $ 329,888 100% 0 $15,500,000 $15,829,888 329,888 Revenues: Internal Premium Charges 4,005,237 3,997,449 (7,788) 33% 33% 12,015,111 12,015,711 PfT Emp • Add'i Prem 16,667 10,121 (6,545) 33% 20% 50,000 50,000 Employee Prem Contribution 210,000 210,000 33% 33% 630,000 630,000 COIC Retiree 1COBRA Co-Pay 420,000 166,667 424,637 305,351 4,637 138,684 33% 34% 33% 61% 1,260,000 500,000 1,260,000 500,000 Fees for Clinic Services 200 200 33% nla 200 200 Federal Payment (ERRP) 150,431 150,431 33% nla· 150,431 150,431 Prescription Rebates 27,975 27,975 33% nfa 27.975 27,975 Interest 26,667 43,202 16,535 33% 54% 80,000 80,000 Total Revenues 4,845,237 5,169.367 324,130 33% 36% 14,535,711 14,714,318 178,607 TOTAL RESOURCES 20,345,237 20,999,256 654,019 92% 103% 30,035,711 30,544,206 508,495 REQUIREMENTS I Exp. %1 Expenditures: Person.l Services 43,354 41,663 1,691 33% 32% 130,062 130,062 MaterM/s & Services Claims Paid-MedicallRx 4,158,095 3,711,546 446,549 33% 30% a) 12,474.284 10,722,408 1,751,877 Claims Paid-DentalMsion 621,325 594,147 27,177 33% 32% a) 1,863,974 1,716,426 147,547 Refunds 0 (33,093) 33,093 33% nfa (33,093) 33.093 Insurance Expense 116,667 116,926 (259) 33% 33% 350,000 350,000 State Assessments 50,000 70,788 (20,788) 33% 47% 150,000 150.000 Administration Fee 106,667 104,885 1,782 33% 33% 320,000 320.000 PPOFee 16,667 16,190 477 33% 32% 50,000 50,000 Health Impact 18,333 17,187 1,146 33% 31% 55,000 55,000 Other 54,106 46,923 7,183 33% 29% 162,318 1621318 Total HBT -Dept 31 5,185,213 4,687,161 498,051 30% 15,555,638 13,623.121 1,932,517 Deschutes On-site Clinic Healthstat 319.067 185.246 133.820 33% 19% 957.200 957,200 MedicationsIDrugs 108,333 47,963 60,370 33% 15% 325,000 325,000 Equipment 1,333 150 1,183 33% 4% 4,000 4,000 Miscellaneous 2,817 10,588 !7,772} 33% 125% 8,450 8,450 Total DOC Capital Outlay Contingency 431,550 67 4,395.074 243.948 187,602 67 4,395,074 33% 33% nla nla 1,294,650 200 13,185.223 1,294,650 - 200 13,185,223 TOTAL EXPENDIREQUIREMNTS 10,011,904 4,931,109 5,080,795 33% 16% 30,035,711 14,917,771 15,117,940 NET (Resources -Requirements) 10,333,333 16,0681147 5,734,813 15,826,435 15,826.435 • 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 18 weeks of claims paid. YTD actual is $237,367 per week. 11/14/2011 YearEnd Budget Projection Variance I Deschutes County -Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Four Months Ended October 31,2011 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 MisceUaneous Total Receipts $ Budget I 75,000 $ 201,667 500 19,333 2,000 10,000 73,333 37,333 15,667 2,269 362,102 Year to Date Actual I Variance IFY %IColi. % (40,601) $ (115,601) 100% ·54% 248,785 245 6,832 4,186 45,031 16,000 4,681 325,760 47,119 33% 41% (255) 33% 16% (12,502) 33% 12% (2,000) 33% 0% (5,814) 33% 14% (28,302) 33% 20% (21,333) 33% 14% (15,667) 33% 0% 2,412 33% n/a (36,342) 33% 30% $ 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) 583,785 1,245 48,832 6,000 34,186 200,031 122,000 47,000 8,603 1,051,683 $ (115,601) (21,215) (255) (9,168) 4,186 (19,969) 10,000 1,796 (34,624) Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Reserve Fund (617) Total Transfers In 56,667 8,581 27,600 73,333 33 166,215 56,668 8,580 27,600 150,000 242,848 76,667 (33) 76,633 33% 33% 33% 33% 33% 33% 33% 33% 68% 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 603,317 528,007 (75,310) 33",4 32% 1,659,951 1,509,626 (150,325) REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Total Expenditures 288,673 160,353 38,356 33 487,415 284,668 169,056 453,724 4,005 (8,703) 38,356 33 33,691 I Exp·%1 33% 33% 33% 35% 33% 0% 33% 0% 866,018 481,060 115,068 100 1,462,246 862,046 504,058 115,068 1,481.171 3,972 (22,998) 100 (18.925) Transfers Out -Reserve Fund 3,333 10,000 (6,667) 33% 100% 10,000 10,000 Contingency 62,568 62,568 33% n/a 187,705 187,705 TOTAL REQUIREMENTS 553,317 463,724 89,593 33% 28% 1,659,951 1,491,171 168,780 NET (Resources· Requirements) 50,000 64,283 14,283 18,455 18,455 --- 00 u ~ ~ 0 ~ ~ ~ ~ < ~ ~ ~ < U 00 :::s 0.. E ro U .cs:: :::s 0 u ~ 1:: 0 Z • s::s::- E Q) ~ Q) ~ ..... Q) cr::l • Deschutes County North County Services Building Inception through October 31,2011 RESOURCES: Loan Proceeds, net of issuance costs Resources from Fund 140 Resources from Fund 142 Transfer in Interest Revenue Total Resources EXPENDITURES: Materials & Services Architectu re/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 Received and Expended 1,402,013 25,000 600,000 1,476 2,028,489 25,000 554 1,493 27,047 1,402,013 230 1,402,243 1,429,290 ACTUAL Encumbrances & Commitments 25,000 25,000 25,000 599,199 (25,000) Project to Date 1,402,013 25,000 600,000 1,476 2,028,489 a) b) 50,000 b) 554 1,493 52,047 1,402,013 a) 230 1,402,243 1,454,290 574,199 PROJECTION Project Budget Projected 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 2,000,000 1,402,013 25,000 600,000 1,476 4,028,489 100,000 10,000 1,663 60,000 2,000 173,663 1,402,013 2,451,337 3,853,350 4,027,013 1,476 Variance 1,476 1,476 1,476 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) W'§;:;-I,,-+1"' """'~"'''--";;,11,i!4!;;ML'ft1'$i\+iJ'l¥!tji''Jn;.fIi,.ljtijdiiji\!K*.!fi4iiN¢$V:3b,'IQ4i4iliWlOtlJ'i4i¢KiUi,Ff,t£. ~,~~N;*"'~'\!iM"""Iif¥II,0MC, ¥'1i\£4i,"IIf.II!,IIIP~I!l~I"!'IlII' %l.?Ji;r.:Wf4QA ;,4«iI,~$$l1\f1 ,I O,I~ il Ii I\"!M._W,,>A4; iU,fifiil)ilili!l,"'UJ '44# igz M#4U;4iitu North County Services Building -Fund 462 ENCUMBRANCES AND COMMITMENTS Through October 31,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 -""-..........----."""""'"'"""-~JI.~ ,,*59/ijA(k~~·~*,:;;,I{L.$iMt\i6&&lqtt, i"'3J41J!&li+I'!.'M;;:Pi"4)I.,,,' iJAt.N:,Nh!!IMI$¥iWlW:Pro.,iii+,i&di{W?*'".;;C,.i'I!i'*"ttlA ea, (,¥MU$l ,"MIl' ,¢i6/t4 *'* "R";;,,*" (,\. w;; fllNiJ(W ,II\¥ iI!l i!t9 QQiM.,hI..;tQf;:;U;:W,.\44iNi\'lftl!*n",",:;U':;;Fi4 ;;;; M!AH t.*" M? &\ 4. 41;, t,JA, ¥¥ ¥ ,41#.$ 1II!1l!!I1!II!!"I4, "I " Deschutes County Bethlehem Inn (Fund 128) Four Months Ended October 31.2011 Budget Actual 1 Variance 1 FY % 1 con. %1 Budget I Projection I Variance RESOURCES: 8eg. Net Working Capital $ (2,711,235) $ (2,716,581) $ (5,346) 100% 100% $(2,711,235) $(2,716,581) $ (5,346) Revenues Grants -Private 933,942 -(933,942) 33% 0% 2.801.827 -(2,801,827) Lease Payments 8,136 8,136 33% 33% 24,408 24.408 Total Revenues 942,078 8,136 (933,942) 33% 0% 2,826,235 24,408 (2,801,827) TOTAL RESOURCES (1,769,157) (2,708,445) (939,288) 33% ·2355% 115,000 (2,692,173) (2,807,173) REQUIREMENTS: Exp. %1 Expenditures Debt Service: Interest Expense 5,000 7,563 (2,563) 33% 50% a) 15,000 15,000 Interest Payment 33,333 33,333 33% 0% 100,000 100,000 TOTAL REQUIREMENTS 38,333 7,563 30,770 33% 7% 115,000 15,000 100,000 NET (Resources -Requirements) (1,807,490) (2,716,008) (908,518) b) ==========(=2=,7=07=,1=7=3=)=(=2,=70=7=,1=73=) a) Interest on October 2011 negative cash balance: $3,757.04 ($1,242.96 current interest, $2,514.08 deferred interest). b) Inception through October 31, 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 230,640 Total expended 2,748,552 Net $ (2,716,008) I Deschutes County General Support Services -BOCC Conference/Seminar, EducationlTraining and Travel Expenditures and BOCC -County College Expenditures FY 20.12 --....--.....--.-....---....~.....-----i---,..------r---...,.------I BOCC Conference & Travel Sep YTD Total .~---~~~~-~-~----~--~Tammy Baney i i ConflSem&EduC!TraiilmQ--·--,--·-6651"---: ------;--30.5 -. --970 .Ira"'~LMe~~=====_____=~~~·~=_=.-_---·----220-' ---. ~. 220 Accommodations 996 . 211 i429----1,635.....--....--------..-~ ----_... -_._.+-------.-~-...---.-----._.....- Airfare -i - Mileagereimbillse~ent~=.---~·-····-.____ ~~==____.~ j94~=~-::-====_··_794 Ground T ransportlParking , 150. i 150. ..---.----~--. I ._--To~_al_~E:S_..~_ne_y"':'-::~ ___...__~_.=:I_111i,66_1.i_____1IIi1,.37.5_·__7.34__.3,.7.70. Alan Unger COnfISem-&EdIJCifralnlng.===__~~§____.._~ ______..~____..____, 30.5 970. Travel Meals 2J53~734 . ----..---------.--------~-~" Tony DeBone • I _ Conf/S(;lm ~E-d_t!c[Tr(3inf~9==~:= 6~§~ --.-.-~=~.. _.~_~_-_--=__-+."__._-_-_..... -3-0.5-······ 970. i Travel Meals Accommodations I---c~----.------.--~-~.-----.--...~.-.--.--.--.---..-.-----.. Mileage reimbursemel1~___...~________ 30.0.. 146 446 Ground Transport 54 i---···-I-···--··--~ ~~~~~--==~-----.. 1,573 i 354 i . 880 2'm !otal.:J:S()CC Departmc~nt .___~_._____: ..______ .~__.____.___._____.._._._. Conf/~em &EduclTraining __ ~ 1,33(L __-=_. L__~g____ 2,910. Travel Meals 220. _~erC(;lnt o(FY 20g Budget Expended ___ 10./31/20.11 \ l