Loading...
HomeMy WebLinkAboutFinancial Operating Data Nov 2009GENERAL FUND Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 6,050,000 Revenues Property Taxes 8,259,520 Gen. Rev. - excl. Taxes 1,217,276 Assessor 341,960 County Clerk 434,655 BOPTA 5,746 District Attorney 138,667 Finance/Tax 77,937 Veterans 29,247 Property Management 36,020 Grant Projects 835 $ 6,775,995 17,836,783 1,695,196 425,341 591,466 8,208 110,585 111,770 33,936 36,020 835 $ 725,995 9,577,263 477,920 83,381 156,811 2,462 (28,082) 33,833 4,689 Total Revenues 10,541,863 20,850,141 10,308,278 TOTAL RESOURCES 16,591,863 REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non -Departmental Contingency 1,371,096 608,627 24,878 1,911,360 311,030 94,042 99,869 44,030 672,086 2,539,464 7,676,482 Transfers Out 5,386,213 TOTAL REQUIREMENTS 13,062,695 NET (Resources - Requirements) 3,529,168 Budget Year End Projection Variance 100% 112% $6,050,000 $6,775,995 $ 725,995 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 27,626,136 11,034,273 42% 1,276,311 507,166 21,504 1,835,444 315,116 93,068 97,441 42,264 299,472 4,487,786 5,344,540 9,832,326 17,793,810 94,785 101,461 3,374 75,916 (4,086) 974 2,428 1,766 372,614 2,539,464 3,188,696 41,673 3,230,369 14,264,642 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 90% 58% 52% 57% 60% 33% 60% 48% 42% 42% 82% a) 19,822,847 b) 2,921,462 c) 820,704 d) 1,043,171 c) 13,791 332,800 c) 187,049 70,192 86,450 2,000 25,300,466 20,674,385 851,538 2,921,462 820,704 1,193,171 150,000 13,791 332,800 187,049 70,192 86,450 2,000 26,302,004 1,001,538 88% 31,350,466 33,077,999 1,727,533 Exp.`f 39% 35% 36% 40% 42% 41% 41% 40% 19% 0% 24% 41% 31% 3,290,631 1,460,704 59,708 4,587,263 e) 746,471 225,701 239,685 105,673 1,613,006 6,094,713 18,423,555 12,926,911 31,350,466 a) Projection based on actual collections through November 30, 2009 b) Includes annual PILT payment of $467,230. c) Includes 2 quarters of A & T Grant: Assessor -$415,093, Tax -$97,761 and BOPTA -$8,208. d) Significant foreclosure and refinancing recordings. e) Year to date includes expenditures paid annually. 3,290,631 1,460,704 59,708 4,587,263 746,471 225,701 239,685 105,673 1,493,006 12,208,842 12,926,911 25,135,753 7,942,246 120,000 6,094,713 6,214,713 6,214,713 7,942,246 RESOURCES: COMM JUSTICE -JUVENILE Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance JFY % Coll. ° Beg. Net Working Capital $1,085,000 $ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041 Revenues Federal Grants 13,240 21,145 7,905 42% 67% a) 31,775 52,994 21,219 SB #1065 -Court Assess. 25,000 21,707 (3,293) 42% 36% 60,000 60,000 Discovery Fee 6,667 6,223 (444) 42% 39% 16,000 16,000 Food Subsidy 12,500 8,490 (4,010) 42% 28% b) 30,000 30,000 OYA Basic & Diversion 138,521 67,655 (70,866) 42% 20% c) 332,450 340,076 7,626 Inmate/Prisoner Housing 25,000 52,950 27,950 42% 88% d) 60,000 120,000 60,000 Inmate Commissary Fees 333 6 (327) 42% 1% 800 100 (700) Contract Payments 86,725 21,791 (64,934) 42% 10% e) 208,141 80,000 (128,141) Miscellaneous 125 20 (105) 42% 7% 300 300 MIP Diversion Fees 417 175 (242) 42% 18% 1,000 500 (500) Interest on Investments 5,417 8,523 3,106, 42% 66% 13,000 18,000 5,000 Leases 1,020 1,000 (20) 42% 41% 2,448 2,448 Grants - Private 612 612 42% n/a 612 612 CCF Interfund Grant 28,333 16,024 (12,309) 42% 24% f) 68,000 54,495 (13,505) Crime Pry Svcs lnterfnd Grnt 8,333 5,521 (2,812) 42% 28% f) 20,000 20,000 Total Revenues 351,631 231,842 (119,789) 42% 27% 843,914 795,525 (48,389) Transfers In -General Fund 2,309,661 2,309,660 (1) 42% 42% 5,543,186 5,543,186 TOTAL RESOURCES 3,746,292 3,741,543 (4,749) 42% 50% 7,472,100 7,538,752 66,652 REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services Exp. % 1,179,230 1,165,712 13,518 42% 41% 2,830,152 2,830,152 Materials and Services 550,874 433,180 117,694 42% 33% g) 1,322,097 1,272,097 50,000 Capital Outlay 42 - 42 42% 0% 100 100 Juvenile Resource Center Personal Services 1,055,064 952,435 102,629 42% 38% 2,532,154 2,532,154 - Materials and Services 77,043 85,553 (8,510) 42% 46% h) 184,903 184,903 Capital Outlay 42 42 42% 0% 100 100 Contingency 251,081 251,081 42% n/a 602,594 602,594 TOTAL REQUIREMENTS 3,113,376 2,636,880 476,496 42% 35% 7,472,100 6,819,406 652,694 NET (Resources - Requirements) 632,916 1,104,663 471,747 719,346 719,346 a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly. b) Food Subsidy receipts reflect payments for July -September. October payment expected to be received in December. c) OYA Basic and Diversion first quarter payment received in November. Payments are based on reimbursement requests for actual expenditures in prior quarter. Department anticipates projected amount to be received in full by end of fiscal year. d) Utilization of housing for juveniles by Crook County projected to exceed original estimates. e) YTD BRS revenue for July -September. Projection reduced to reflect actual youth count at less than half of original estimate. f) First quarter payments received in November. g) Positive variance a result of accruals during July of June expenses for utilities, supplies, and contract payments. h) Negative variance due to an annual subscription payment, one time appliance purchase, and special needs of youth in detention. Year End Budget Projection Variance Beg. Net Working Capital $1,085,000 $ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041 Revenues Federal Grants 13,240 21,145 7,905 42% 67% a) 31,775 52,994 21,219 SB #1065 -Court Assess. 25,000 21,707 (3,293) 42% 36% 60,000 60,000 Discovery Fee 6,667 6,223 (444) 42% 39% 16,000 16,000 Food Subsidy 12,500 8,490 (4,010) 42% 28% b) 30,000 30,000 OYA Basic & Diversion 138,521 67,655 (70,866) 42% 20% c) 332,450 340,076 7,626 Inmate/Prisoner Housing 25,000 52,950 27,950 42% 88% d) 60,000 120,000 60,000 Inmate Commissary Fees 333 6 (327) 42% 1% 800 100 (700) Contract Payments 86,725 21,791 (64,934) 42% 10% e) 208,141 80,000 (128,141) Miscellaneous 125 20 (105) 42% 7% 300 300 MIP Diversion Fees 417 175 (242) 42% 18% 1,000 500 (500) Interest on Investments 5,417 8,523 3,106, 42% 66% 13,000 18,000 5,000 Leases 1,020 1,000 (20) 42% 41% 2,448 2,448 Grants - Private 612 612 42% n/a 612 612 CCF Interfund Grant 28,333 16,024 (12,309) 42% 24% f) 68,000 54,495 (13,505) Crime Pry Svcs lnterfnd Grnt 8,333 5,521 (2,812) 42% 28% f) 20,000 20,000 Total Revenues 351,631 231,842 (119,789) 42% 27% 843,914 795,525 (48,389) Transfers In -General Fund 2,309,661 2,309,660 (1) 42% 42% 5,543,186 5,543,186 TOTAL RESOURCES 3,746,292 3,741,543 (4,749) 42% 50% 7,472,100 7,538,752 66,652 REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services Exp. % 1,179,230 1,165,712 13,518 42% 41% 2,830,152 2,830,152 Materials and Services 550,874 433,180 117,694 42% 33% g) 1,322,097 1,272,097 50,000 Capital Outlay 42 - 42 42% 0% 100 100 Juvenile Resource Center Personal Services 1,055,064 952,435 102,629 42% 38% 2,532,154 2,532,154 - Materials and Services 77,043 85,553 (8,510) 42% 46% h) 184,903 184,903 Capital Outlay 42 42 42% 0% 100 100 Contingency 251,081 251,081 42% n/a 602,594 602,594 TOTAL REQUIREMENTS 3,113,376 2,636,880 476,496 42% 35% 7,472,100 6,819,406 652,694 NET (Resources - Requirements) 632,916 1,104,663 471,747 719,346 719,346 a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly. b) Food Subsidy receipts reflect payments for July -September. October payment expected to be received in December. c) OYA Basic and Diversion first quarter payment received in November. Payments are based on reimbursement requests for actual expenditures in prior quarter. Department anticipates projected amount to be received in full by end of fiscal year. d) Utilization of housing for juveniles by Crook County projected to exceed original estimates. e) YTD BRS revenue for July -September. Projection reduced to reflect actual youth count at less than half of original estimate. f) First quarter payments received in November. g) Positive variance a result of accruals during July of June expenses for utilities, supplies, and contract payments. h) Negative variance due to an annual subscription payment, one time appliance purchase, and special needs of youth in detention. RESOURCES: Beg. Net Working Capital Revenues Law Enf Dist Countywide Law Enf Dist Rural Interest Total Revenues SHERIFF - Fund 255 Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual $ 8,434,557 5,298,884 $ 183,677 7,348,864 4,784,749 13,515 Variance FY % Coll. % $ 183,677 100% (1,085,693) (514,135) 13,515 13,733,441 TOTAL RESOURCES 13,733,441 REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division Civil Automotive/Communications Investigations/Evidence Patrol/Civil/Comm Supp Records Adult Jail Court Security Emergency Services Special Services Division Regional Work Center Training Division Other Law Enforcement Svcs Non -Departmental Contingency Transfers Out 817,162 302,900 582,452 700,970 3,155,240 267,651 3,789,546 89,962 78,363 461,954 1,140,768 125,022 219,876 192,935 1,604,475 12,147,128 12,330,805 847,086 291,653 638,424 630,940 2,958,812 241,192 3,329,437 80,207 67,173 488,016 959,510 114,721 236,085 26,270 204,167 122,500 nla $ $ 183,677 $ 183,677 42% 36% a) 20,242,936 17,363,761 (2,879,175) 42% 38% a) 12,717,322 11,220,156 (1,497,166) 42% n/a - 35,000 35,000 (1,586,313) 42% 37% 32,960,258 28,618,917 (4,341,341) (1,402,636) 42% 37% 32,960,258 28,802,594 (4,157,664) (29,924) 11,247 (55,972) 70,030 196,428 26,459 460,109 9,755 11,190 (26,062) 181,258 10,301 (16,209) 166,665 1,604,475 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% l Exp. °i:, 43% 40% 46% b) 38% 39% c) 38% 37% C) 37% 36% 44% 35% c) 38% 45% 6% n/a 81,667 42% 25% TOTAL REQUIREMENTS 13,733,443 11,032,026 1,961,188 726,961 1,397,884 1,682,327 7,572,575 642,363 9,094,909 215,908 188,071 1,108,690 2,737,842 300,053 527,702 463,044 3,850,741 1,961,088 100 726,961 1,397,884 1,682,327 - 7,397,575 175,000 642,263 100 8,844,909 250,000 215,808 100 188,071 1,108,690 2,587,742 150,100 299,953 100 527,602 100 463,044 - - 3,850,741 490,000 490,000 2,701,417 42% 33% 32,960,258 28,533,917 4,426,341 NET (Resources - Requirements) (2) 1,298,779 1,298,781 268,677 268,677 a) Revenue from LED's based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. b) Year to date actual includes annual amount ($260,405) of transfer to Fund 245 Communications System. c) Unfilled open positions resulting in less than planned personnel expenses. Year End Budget Projection Variance nla $ $ 183,677 $ 183,677 42% 36% a) 20,242,936 17,363,761 (2,879,175) 42% 38% a) 12,717,322 11,220,156 (1,497,166) 42% n/a - 35,000 35,000 (1,586,313) 42% 37% 32,960,258 28,618,917 (4,341,341) (1,402,636) 42% 37% 32,960,258 28,802,594 (4,157,664) (29,924) 11,247 (55,972) 70,030 196,428 26,459 460,109 9,755 11,190 (26,062) 181,258 10,301 (16,209) 166,665 1,604,475 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% l Exp. °i:, 43% 40% 46% b) 38% 39% c) 38% 37% C) 37% 36% 44% 35% c) 38% 45% 6% n/a 81,667 42% 25% TOTAL REQUIREMENTS 13,733,443 11,032,026 1,961,188 726,961 1,397,884 1,682,327 7,572,575 642,363 9,094,909 215,908 188,071 1,108,690 2,737,842 300,053 527,702 463,044 3,850,741 1,961,088 100 726,961 1,397,884 1,682,327 - 7,397,575 175,000 642,263 100 8,844,909 250,000 215,808 100 188,071 1,108,690 2,587,742 150,100 299,953 100 527,602 100 463,044 - - 3,850,741 490,000 490,000 2,701,417 42% 33% 32,960,258 28,533,917 4,426,341 NET (Resources - Requirements) (2) 1,298,779 1,298,781 268,677 268,677 a) Revenue from LED's based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. b) Year to date actual includes annual amount ($260,405) of transfer to Fund 245 Communications System. c) Unfilled open positions resulting in less than planned personnel expenses. RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants State Grant Transp. of State Wards SB 1145 Des. Cty Video Lottery Grant Des Cty Court Security Des Cty Juvenile Contract Title III Reimbursement Transport DC Fair & Expo Center Inmate Commissary Fees Work Center Work Crews Concealed Handgun Classes Soc Sec Incentive -Fed Miscellaneous Oregon Mentors Medical Services Reimb Restitution Sheriff Fees Interest Interest on Unsegregated Rentals Donations Total Revenues TOTAL RESOURCES SHERIFF 701 Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance FY % Coll. % $ 2,470,519 $ 3,343,461 $ 872,942 42% n/a $ 2,470,519 $ 3,343,461 $ 872,942 6,174, 876 208,333 14,583 18,815 2,083 717,163 2,083 53,750 1,250 62,500 833 25,000 17,688 2,500 2,083 1,667 2,083 5,000 438 66,667 11,805 1,472 12,499 7,405,171 13,036,802 6,861,926 42% 88% a) 14,819,703 14,981,411 161,708 542,370 334,037 42% 108% a) 500,000 727,128 227,128 102,868 88,285 42% 294% 35,000 35,000 - 36,920 18,105 42% 82% 45,156 45,156 - (2,083) 42% 0% 5,000 5,000 987,330 270,167 42% 57% b) 1,721,192 1,935,336 214,144 5,000 2,917 42% n/a 5,000 5,000 - 53,563 (187) 42% 42% 129,000 129,000 - (1,250) 42% 0% 3,000 3,000 - (62,500) 42% n/a 150,000 150,000 - 2,182 1,349 42% n/a 2,000 4,000 2,000 2,100 2,100 42% n/a 3,000 3,000 14,785 (10,215) 42% 25% 60,000 60,000 19,590 1,902 42% 46% 42,450 42,450 - 3,125 625 42% 52% 6,000 6,000 - 5,400 3,317 42% 108% 5,000 10,000 5,000 886 (781) 42% 22% 4,000 4,000 1,902 (181) 42% n/a 5,000 5,000 - 2,668 (2,332) 42% 22% 12,000 12,000 729 291 42% 69% 1,050 1,050 84,811 18,144 42% 53% 160,000 160,000 9,086 (2,719) 42% 32% 28,333 28,333 - 2,419 947 42% 68% 3,533 3,533 - 51,236 38,737 42% 171% c) 30,000 67,236 37,236 50 50 42% n/a 50 50 14,965,822 7,560,651 42% 84% 17,772,417 18,422,683 650,266 9,875,690 18,309,283 8,433,593 42% 90% 20,242,936 21,766,144 1,523,208 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 8,434,558 Exp. % 7,348,864 1,085,694 42% 36% d) 20,242,936 17,363,761 2,879,175 TOTAL REQUIREMENTS 8,434,558 7,348,864 1,085,694 42% 36% 20,242,936 17,363,761 2,879,175 NET (Resources - Requirements) 1,441,132 10,960,419 9,519,287 4,402,383 4,402,383 a) Projections based on actual collections through November 30, 2009. b) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget. c) FBI relocation from Sheriffs Office has been delayed resulting in 5 months of additional rental revenue. d) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. Year End Budget Projection Variance $ 2,470,519 $ 3,343,461 $ 872,942 42% n/a $ 2,470,519 $ 3,343,461 $ 872,942 6,174, 876 208,333 14,583 18,815 2,083 717,163 2,083 53,750 1,250 62,500 833 25,000 17,688 2,500 2,083 1,667 2,083 5,000 438 66,667 11,805 1,472 12,499 7,405,171 13,036,802 6,861,926 42% 88% a) 14,819,703 14,981,411 161,708 542,370 334,037 42% 108% a) 500,000 727,128 227,128 102,868 88,285 42% 294% 35,000 35,000 - 36,920 18,105 42% 82% 45,156 45,156 - (2,083) 42% 0% 5,000 5,000 987,330 270,167 42% 57% b) 1,721,192 1,935,336 214,144 5,000 2,917 42% n/a 5,000 5,000 - 53,563 (187) 42% 42% 129,000 129,000 - (1,250) 42% 0% 3,000 3,000 - (62,500) 42% n/a 150,000 150,000 - 2,182 1,349 42% n/a 2,000 4,000 2,000 2,100 2,100 42% n/a 3,000 3,000 14,785 (10,215) 42% 25% 60,000 60,000 19,590 1,902 42% 46% 42,450 42,450 - 3,125 625 42% 52% 6,000 6,000 - 5,400 3,317 42% 108% 5,000 10,000 5,000 886 (781) 42% 22% 4,000 4,000 1,902 (181) 42% n/a 5,000 5,000 - 2,668 (2,332) 42% 22% 12,000 12,000 729 291 42% 69% 1,050 1,050 84,811 18,144 42% 53% 160,000 160,000 9,086 (2,719) 42% 32% 28,333 28,333 - 2,419 947 42% 68% 3,533 3,533 - 51,236 38,737 42% 171% c) 30,000 67,236 37,236 50 50 42% n/a 50 50 14,965,822 7,560,651 42% 84% 17,772,417 18,422,683 650,266 9,875,690 18,309,283 8,433,593 42% 90% 20,242,936 21,766,144 1,523,208 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 8,434,558 Exp. % 7,348,864 1,085,694 42% 36% d) 20,242,936 17,363,761 2,879,175 TOTAL REQUIREMENTS 8,434,558 7,348,864 1,085,694 42% 36% 20,242,936 17,363,761 2,879,175 NET (Resources - Requirements) 1,441,132 10,960,419 9,519,287 4,402,383 4,402,383 a) Projections based on actual collections through November 30, 2009. b) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget. c) FBI relocation from Sheriffs Office has been delayed resulting in 5 months of additional rental revenue. d) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants US Forest Service State Grant SB #1065 Court Assessment Marine Board License Fee Des Cty General Fund Grnt Des Cty Transient Room Tax City of Sisters Des Cty Tax/Fin Contract Des Cty CDD Contract Des Cty Solid Waste Contr Des Cty Clerk/Election School Districts Security & Traffic Reimb Seat Belt Program Miscellaneous Sheriff Fees Court Fines & Fees Impound Fees Restitution - Street Crimes Seizure/Forfeiture Interest Interest on Unsegregated Sale of Reportable Assets Sale of Equip & Material Total Revenues TOTAL RESOURCES SHERIFF 702 Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance FY % Coll. % $1,287,473 $ 1,433,708 3,016,542 6,386,937 99,583 275,977 833 55,506 31,875 12,750 78,180 73,592 27,917 21,707 51,862 - 359,651 10,000 744,515 744,515 175,006 173,340 417 1,405 11,326 11,326 33,978 33,978 833 663 41,667 - 5,417 2,871 2,500 3,850 4,167 5,486 2,083 5,245 35,417 49,351 31,250 6,900 500 1,122 4,167 429 750 1,185 6,779 2,500 10,495 4,762,436 7,895,909 $ 146,235 42% 3,370,395 42% 176,394 42% 54,673 42% (19,125) 42% (4,588) 42% (6,210) 42% (51,862) 42% (349,651) 42% 42% (1,666) 42% 988 42% 42% 42% (170) 42% (41,667) 42% (2,546) 42% 1,350 42% 1,319 42% 3,162 42% 13,934 42% (24,350) 42% 500 42% 1,122 42% (3,738) 42% 435 42% 6,779 42% 7,995 42% 3,133,473 42% nfa $1,287,473 $1,433,708 $ 146,235 88% a) 7,239,702 7,339,633 99,931 115% a) 239,000 370,961 131,961 2775% b) 2,000 55,506 53,506 17% 76,500 76,500 39% 187,633 187,633 - 32% 67,000 67,000 0% 124,468 124,468 1% 863,163 863,163 - 42% 1,786,837 1,786,837 41% c) 420,015 416,016 (3,999) 141% 1,000 1,405 405 42% 27,183 27,183 42% 81,548 81,548 33% 2,000 2,000 n/a 100,000 100,000 22% 13,000 13,000 64% 6,000 6,000 55% 10,000 10,000 105% 5,000 10,000 5,000 58% 85,000 85,000 9% 75,000 75,000 n/a 500 500 n/a - 2,500 2,500 4% 10,000 10,000 66% 1,800 1,800 - n/a 10,000 10,000 175% 6,000 12,000 6,000 69% 11,429,849 11,735,653 305,804 6,049,909 9,329,617 3,279,708 42% 73% 12,717,322 13,169,361 452,039 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 5,298,884 4,784,749 Exp. % 514,135 42% 38% d) 12,717,322 11,220,156 1,497,166 TOTAL REQUIREMENTS 5,298,884 4,784,749 514,135 42% 38% 12,717,322 11,220,156 1,497,166 NET (Resources - Requirements) 751,025 4,544,868 3,793,843 - 1,949,205 1,949,205 a) Projections based on actual collections through November 30, 2009 b) Unplanned JAG grant received and higher than planned HIDTA reimbursements. c) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget. d) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. Year End Budget Projection Variance nfa $1,287,473 $1,433,708 $ 146,235 88% a) 7,239,702 7,339,633 99,931 115% a) 239,000 370,961 131,961 2775% b) 2,000 55,506 53,506 17% 76,500 76,500 39% 187,633 187,633 - 32% 67,000 67,000 0% 124,468 124,468 1% 863,163 863,163 - 42% 1,786,837 1,786,837 41% c) 420,015 416,016 (3,999) 141% 1,000 1,405 405 42% 27,183 27,183 42% 81,548 81,548 33% 2,000 2,000 n/a 100,000 100,000 22% 13,000 13,000 64% 6,000 6,000 55% 10,000 10,000 105% 5,000 10,000 5,000 58% 85,000 85,000 9% 75,000 75,000 n/a 500 500 n/a - 2,500 2,500 4% 10,000 10,000 66% 1,800 1,800 - n/a 10,000 10,000 175% 6,000 12,000 6,000 69% 11,429,849 11,735,653 305,804 6,049,909 9,329,617 3,279,708 42% 73% 12,717,322 13,169,361 452,039 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 5,298,884 4,784,749 Exp. % 514,135 42% 38% d) 12,717,322 11,220,156 1,497,166 TOTAL REQUIREMENTS 5,298,884 4,784,749 514,135 42% 38% 12,717,322 11,220,156 1,497,166 NET (Resources - Requirements) 751,025 4,544,868 3,793,843 - 1,949,205 1,949,205 a) Projections based on actual collections through November 30, 2009 b) Unplanned JAG grant received and higher than planned HIDTA reimbursements. c) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget. d) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. RESOURCES: Beg. Net Working Capital Revenues Medicare Reimbursement State Grant Child Dev & Rehab Center State Miscellaneous OMAP Family Planning Exp Proj Grants FY 2008-2009 Miscellaneous Patient Insurance Fees Health Dept/Patient Fees Vital Records -Birth Vital Records -Death Interest on Investments Donations Interfund Contract Administrative Fee Total Revenues Transfers In -Reserve Fund Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) PUBLIC HEALTH Statement of Financial Operating Data Five Months Ended November 30, 2009 Revised Budget Year End Projection Variance $ 900,000 $ 1,120,355 $ 220,355 100% 124% $ 900,000 $1,120,355 $ 220,355 1,667 1,012,470 14,474 88,850 126,250 197,917 55,750 63,396 15,000 40,833 15,833 3,667 54,906 11,250 23 701,723 7,690 78,021 165,762 183,759 22,254 4,568 2,314 58,747 53,463 13,005 37,485 7,541 2,642 29,649 11,250 (1,644) 42% (310,747) 42% (6,784) 42% (10,829) 42% 39,512 42% (14,158) 42% 22,254 42% 4,568 42% 2,314 42% 2,997 42% (9,933) 42% (1,995) 42% (3,348) 42% (8,292) 42% (1,025) 42% (25,257) 42% 42% 1,702,263 1,379,896 (322,367) 42% 10,417 965.735 965,735 (10,417) 42% - 42% 3,578,415 3,465,986 (102,012) 42% 1,857,615 735,221 15,376 62,500 382,702 1,731,057 575,719 37,500 126,558 159,502 15,376 25,000 382.702 42% 42% 42% 42% 42% 1% 4,000 4,000 29% a) 2,429,928 2,790,881 360,953 22% 34,737 34,737 - 37% 213,240 213,240 55% 303,000 303,000 39% b) 475,000 475,000 - n/a c) 22,254 22,254 n/a 4,568 4,568 n/a - 2,314 2,314 44% 133,800 133,800 35% 152,150 152,150 36% 36,000 36,000 38% 98,000 98,000 20% 38,000 38,000 - 30% 8,800 8,800 22% 131,774 131,774 42% 27.000 27,000 34% 4,085,429 4,475,518 390,089 0% 42% 47% Exp. % 39% a) 33% a) 0% 25% n/a 25,000 2,317,765 7,328,194 4,458,276 1,764,531 36,902 150,000 918,485 25,000 - 2,317,765 - 7,938,638 610,444 4,539,942 2,064,915 36,902 150,000 (81,666) (300,384) 918,485 3,053,414 2,344,276 709,138 42% 32% 7,328,194 6,791,759 536,435 525,001 1,121,710 607,126 1,146, 879 1.146, 879 a) State Grant projection adjusted to actual FY 2010 contract, includes Rev. 1 - 4. Grant appropriation for revisions in process. b) Payments are received one month in arrears. c) Grants for HIV and Chronic Care were not included in FY 2010 budget. Year to Date Budget Actual Variance FY % Coll. % Revised Budget Year End Projection Variance $ 900,000 $ 1,120,355 $ 220,355 100% 124% $ 900,000 $1,120,355 $ 220,355 1,667 1,012,470 14,474 88,850 126,250 197,917 55,750 63,396 15,000 40,833 15,833 3,667 54,906 11,250 23 701,723 7,690 78,021 165,762 183,759 22,254 4,568 2,314 58,747 53,463 13,005 37,485 7,541 2,642 29,649 11,250 (1,644) 42% (310,747) 42% (6,784) 42% (10,829) 42% 39,512 42% (14,158) 42% 22,254 42% 4,568 42% 2,314 42% 2,997 42% (9,933) 42% (1,995) 42% (3,348) 42% (8,292) 42% (1,025) 42% (25,257) 42% 42% 1,702,263 1,379,896 (322,367) 42% 10,417 965.735 965,735 (10,417) 42% - 42% 3,578,415 3,465,986 (102,012) 42% 1,857,615 735,221 15,376 62,500 382,702 1,731,057 575,719 37,500 126,558 159,502 15,376 25,000 382.702 42% 42% 42% 42% 42% 1% 4,000 4,000 29% a) 2,429,928 2,790,881 360,953 22% 34,737 34,737 - 37% 213,240 213,240 55% 303,000 303,000 39% b) 475,000 475,000 - n/a c) 22,254 22,254 n/a 4,568 4,568 n/a - 2,314 2,314 44% 133,800 133,800 35% 152,150 152,150 36% 36,000 36,000 38% 98,000 98,000 20% 38,000 38,000 - 30% 8,800 8,800 22% 131,774 131,774 42% 27.000 27,000 34% 4,085,429 4,475,518 390,089 0% 42% 47% Exp. % 39% a) 33% a) 0% 25% n/a 25,000 2,317,765 7,328,194 4,458,276 1,764,531 36,902 150,000 918,485 25,000 - 2,317,765 - 7,938,638 610,444 4,539,942 2,064,915 36,902 150,000 (81,666) (300,384) 918,485 3,053,414 2,344,276 709,138 42% 32% 7,328,194 6,791,759 536,435 525,001 1,121,710 607,126 1,146, 879 1.146, 879 a) State Grant projection adjusted to actual FY 2010 contract, includes Rev. 1 - 4. Grant appropriation for revisions in process. b) Payments are received one month in arrears. c) Grants for HIV and Chronic Care were not included in FY 2010 budget. RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Domestic Partnership Fee Federal Grants State Grants State Miscellaneous Title 19 Liquor Revenue School Districts Miscellaneous Patient Insurance Fees Patient Fees Seizure/Forfeiture Interest on Investments Rentals Donations Interfund Contract Administrative Fee Comm. on Children & Fam Crime Prevention Services Total Revenues Transfers In -General Fund Transfers In -Other BEHAVIORAL HEALTH Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual I Variance FY % I Coll. % Revised Year End Budget Projection Variance $ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004) 2,292 52,083 833 41,591 2,198,786 76,965 125,294 44,167 29,167 17,000 103,125 4,792 13,333 6,875 1,250 1,300 1,264,564 9,167 52,917 2,675 55,437 60 25,253 2,206,626 27,067 53 53,321 40,500 10,202 51,717 1,640 13,129 19,571 3,500 7,000 1,249,121 383 3,354 (773) (16,338) 7,840 (49,898) (125,241) 9,154 11,333 (6,798) (51,408) (3,152) 13,129 6,238 (3,375) 5,750 (1,300) (15,443) (9,167) 38,260 (14,657) 4,045,501 548,399 106,515 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 49% 44% 3% 25% a) 42% b) 15% 0% c) 50% 58% 25% 21% 14% n/a 61% 21% 233% 0% 41% 0% 30% a) 3,805,132 (240,369) 42% 39% TOTAL RESOURCES 7,425,415 REQUIREMENTS: Expenditures Personal Services 3,294,033 Materials and Services 1,688,964 Capital Outlay 33,333 Transfers Out 62,500 Contingency 757,000 5,500 125,000 2,000 99,819 5,277,086 184,716 300,705 106,000 70,000 40,800 247,500 11,500 32,000 16,500 3,000 3,120 3,034,954 22,000 127,000 5,500 - 125,000 - 2,000 99,819 5,351,224 74,138 184,716 300,705 106,000 88,800 18,800 40,800 - 247,500 11,500 13,129 13,129 45,000 13,000 16,500 7,000 4,000 3,120 3,031,954 127,000 (3,000) (22,000) 9,709,200 9,807,267 98,067 548,400 1 42% 42% 1,316,158 1,316,158 151,305 44,790 42% 59% 255,636 363,129 107,493 7,094,833 (330,582) 42% 51% 14,005,994 14,076,550 70,556 2,942,636 351,397 42% 1,279,737 409,227 42% 33,333 42% 37,500 25,000 42% 757,000 42% n/a Exp. % 37% d) 32% 0% 25% TOTAL REQUIREMENTS 5,835,830 NET (Resources - Requirements) 1,589,585 7,905,680 7,890,661 15,019 4,053,514 4,053,514 80,000 80,000 - 150,000 150,000 1,816,800 1,816,800 4,259,873 1,575,957 42% 30% 14,005,994 12,174,175 1,831,819 2,834,960 1,245,375 a) Grant billing received quarterly, in arrears. b) Dept of Human Services Grant projected at amended contract amount for FY 2010. c) Delay in payment due to problems with the State MMIS software system. d) 10% reduction in hours through 12/31/09. 1,902,375 1,902,375 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 413,471 $ 629,659 $ 216,188 100% 152% $ 413,471 $ 629,659 216,188 Revenues Admin -Operations 1,521 8,222 6,701 42% 225% a) 3,650 14,000 10,350 Admin -GIS 865 5,345 4,480 42% 258% b) 2,075 41,300 39,225 Admin -Code Enforcement 78,938 69,906 (9,032) 42% 37% c) 189,450 166,700 (22,750) Building Safety 406,156 384,238 (21,918) 42% 39% c) 974,775 925,648 (49,127) Electrical 116,875 115,591 (1,284) 42% 41% c) 280,500 266,600 (13,900) Contract Services 106,458 35,181 (71,277) 42% 14% d) 255,500 89,700 (165,800) Env Health -On Site Prog 122,021 100,457 (21,565) 42% 34% c) 292,850 242,900 (49,950) Env Health-Lic Facilities 287,698 71,952 (215,746) 42% 10% e) 690,475 690,475 Env Health - Drinking H2O 39,713 34,646 (5,067) 42% 36% f) 95,311 95,311 Planning -Current 410,063 249,210 (160,853) 42% 25% g) 984,150 653,000 (331,150) Planning -Long Range 178,708 173,901 (4,807) 42% 41% c) 428,900 318,800 (110,100) Total Revenues 1,749,016 1,248,647 (500,369) 42% 30% 4,197,636 3,504,434 (693,202) Trans In -GF 506,928 506,929 1 0% n/a 1,216,627 1,216,627 Trans In -GF for Lng Rng Ping 125,000 75,000 (50,000) 0% n/a 300,000 300,000 Trans In -Other 42 - (42) 0% 0% 100 (100) TOTAL RESOURCES 2,794,457 2,460,235 (334,222) 42% 40% 6,127,834 5,650,720 (477,114) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations 711,713 Admin -GIS 89,836 Admin -Code Enforcement 75,404 Building Safety 302,144 Electrical 86,133 Contract Services 110,325 Env Health -On Site Pgm 100,286 Env Health-Lic Facilities 206,644 Env Health - Drinking H2O 33,583 Planning -Current 337,410 Planning -Long Range 229,928 Transfers Out (D/S Fund) 74,025 Contingency 195,833 Exp. % 697,088 14,625 42% 41% 1,708,112 1,708,112 84,686 5,150 42% 39% 215,606 215,606 73,736 1,668 42% 41% 180,969 180,969 288,412 13,732 42% 40% h) 725,145 698,080 85,723 410 42% 41% h) 206,719 193,187 105,063 5,262 42% 40% h) 264,781 260,270 95,546 4,740 42% 40% 240,687 240,687 204,954 1,690 42% 41% 495,946 495,946 35,492 (1,909) 42% 44% 80,598 80,598 325,802 11,608 42% 40% 809,783 809,783 174,476 55,452 42% 32% 551,828 551,828 74,025 0% 42% 177,660 177,660 195,833 42% n/a 470,000 27,065 13,532 4,511 470,000 TOTAL REQUIREMENTS 2,553,264 2,245,003 308,261 42% 37% 6,127,834 5,612,726 515,108 NET (Resources - Requirements) 241„193 215,232 (25,961) 37,994 37,994 Revenues 1,248,647 3,504,434 Expenditures 2,245,003 5,612,726 Net from Operations (996,356) (2,108,292) a) Revenues are higher than budgeted due to interest earnings on positive fund balance. b) Custom GIS work revenue sporadic. Includes $37,175 reimbursement from IT -Web Programmer. c) Projections are below budget due to recent volume downturns. d) Significant drop-off in City of Redmond work. e) Revenue is received primarily in December through February following mailing of license renewal statements. f) Payments from State DHS are received irregularly. g) Significant slowdown in land use applications. h) Reflects the retirement of the Building Safety Director in November. Year End Budget Projection Variance Total Revenues 1,749,016 1,248,647 (500,369) 42% 30% 4,197,636 3,504,434 (693,202) Trans In -GF 506,928 506,929 1 0% n/a 1,216,627 1,216,627 Trans In -GF for Lng Rng Ping 125,000 75,000 (50,000) 0% n/a 300,000 300,000 Trans In -Other 42 - (42) 0% 0% 100 (100) TOTAL RESOURCES 2,794,457 2,460,235 (334,222) 42% 40% 6,127,834 5,650,720 (477,114) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations 711,713 Admin -GIS 89,836 Admin -Code Enforcement 75,404 Building Safety 302,144 Electrical 86,133 Contract Services 110,325 Env Health -On Site Pgm 100,286 Env Health-Lic Facilities 206,644 Env Health - Drinking H2O 33,583 Planning -Current 337,410 Planning -Long Range 229,928 Transfers Out (D/S Fund) 74,025 Contingency 195,833 Exp. % 697,088 14,625 42% 41% 1,708,112 1,708,112 84,686 5,150 42% 39% 215,606 215,606 73,736 1,668 42% 41% 180,969 180,969 288,412 13,732 42% 40% h) 725,145 698,080 85,723 410 42% 41% h) 206,719 193,187 105,063 5,262 42% 40% h) 264,781 260,270 95,546 4,740 42% 40% 240,687 240,687 204,954 1,690 42% 41% 495,946 495,946 35,492 (1,909) 42% 44% 80,598 80,598 325,802 11,608 42% 40% 809,783 809,783 174,476 55,452 42% 32% 551,828 551,828 74,025 0% 42% 177,660 177,660 195,833 42% n/a 470,000 27,065 13,532 4,511 470,000 TOTAL REQUIREMENTS 2,553,264 2,245,003 308,261 42% 37% 6,127,834 5,612,726 515,108 NET (Resources - Requirements) 241„193 215,232 (25,961) 37,994 37,994 Revenues 1,248,647 3,504,434 Expenditures 2,245,003 5,612,726 Net from Operations (996,356) (2,108,292) a) Revenues are higher than budgeted due to interest earnings on positive fund balance. b) Custom GIS work revenue sporadic. Includes $37,175 reimbursement from IT -Web Programmer. c) Projections are below budget due to recent volume downturns. d) Significant drop-off in City of Redmond work. e) Revenue is received primarily in December through February following mailing of license renewal statements. f) Payments from State DHS are received irregularly. g) Significant slowdown in land use applications. h) Reflects the retirement of the Building Safety Director in November. RESOURCES: Beg. Net Working Capital Revenues Federal Reimbursements System Development Chrg Mineral Lease Royalties Forest Receipts State Grant Motor Vehicle Revenue City of Bend City of Redmond City of Sisters City of La Pine Admin Recovery (SDC) Miscellaneous Road Vacations Interest on Investments Other Bank/LGIP Interest Interfund Contract Equipment Repairs Vehicle Repairs Vegetation Management Inter -fund: Forester Car Washes Car Rental Sale of Eqp & Material Total Revenues Trans In - CDD Trans In - Solid Waste Trans In - Transp SDC Trans In -Road Imp Res ROAD Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance FY % Coll. %, $ 4,871,665 204,167 4,167 1,034,167 173,115 3,333,333 93,750 104,167 4,167 4,167 208 54,167 417 20,833 291,667 114,583 37,500 14,583 9,167 1,042 333,333 $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984 231 10,543 3,074,641 250,085 316,603 684 9,966 24,057 873 107,503 1,342 356 302,080 (204,167) 231 6,376 (1,034,167) (173,115) (258,692) 156,335 212,436 (4,167) (4,167) 476 (44,201) (417) 3,224 873 (291,667) (7,080) (37,500) (14,583) (9,167) 300 356 (31,253) 5,832,700 7,579 295,236 31,250 4,167 4,098,964 (1,733,736) 177,142 18,750 TOTAL RESOURCES 11,011,347 REQUIREMENTS: Expenditures Personal Services 2,360,572 Materials and Services 3,805,504 Capital Outlay 1,125,000 Transfers Out 166,667 Contingency 743,048 TOTAL REQUIREMENTS (7,579) (118,094) (12,500) (4,167) 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 0% n/a 105% 0% a) 0% 38% 111% b) 127% b) 0% b) n/a b) n/a 8% 0% 48% n/a 0% c) 39% 0% 0% 0% 54% n/a 38% 29% c) c) c) 0% 25% d) 25% d) 0% c) 490,000 490,000 925 25,000 2,482,000 415,477 8,000,000 275,000 350,000 10,000 10,000 1,500 130,000 1,000 50,000 1,500 700,000 275,000 90,000 35,000 22,000 2,500 1,000 800,000 800,000 10,000 2,482,000 415,477 8,000,000 225,000 250,000 10,000 10,000 500 130,000 1,000 50,000 700,000 275,000 90,000 35,000 22,000 2,500 925 15,000 50,000 100,000 1,000 1,500 1,000 13,998,477 14,167,902 169,425 18,190 708,567 75,000 10,000 18,190 708,567 75,000 10,000 9,186,505 (1,843,592) 42% 56% 19,681,899 19,871,308 189,409 2,198,544 4,548,846 815,918 162,028 (743,342) 309,082 166,667 743,048 8,200,791 42% 42% 42% 42% 42% Exp. % 39% 50% e) 30% 0% n/a 5,665,373 9,133,210 2,700,000 400,000 1,783,316 5,665,373 9,133,210 2,700,000 400,000 1,783,316 7,563,308 637,483 42% 38% 19,681,899 17,898,583 1,783,316 NET (Resources - Requirements) 2,810,556 1,623,197 (1,206,109) a) Annual payment anticipated to be received in December 09. b) Billed upon completion of work. c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430. d) Transfer made quarterly. e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays 1,972,725 1,972,725 Year End Budget Projection Variance $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984 231 10,543 3,074,641 250,085 316,603 684 9,966 24,057 873 107,503 1,342 356 302,080 (204,167) 231 6,376 (1,034,167) (173,115) (258,692) 156,335 212,436 (4,167) (4,167) 476 (44,201) (417) 3,224 873 (291,667) (7,080) (37,500) (14,583) (9,167) 300 356 (31,253) 5,832,700 7,579 295,236 31,250 4,167 4,098,964 (1,733,736) 177,142 18,750 TOTAL RESOURCES 11,011,347 REQUIREMENTS: Expenditures Personal Services 2,360,572 Materials and Services 3,805,504 Capital Outlay 1,125,000 Transfers Out 166,667 Contingency 743,048 TOTAL REQUIREMENTS (7,579) (118,094) (12,500) (4,167) 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 0% n/a 105% 0% a) 0% 38% 111% b) 127% b) 0% b) n/a b) n/a 8% 0% 48% n/a 0% c) 39% 0% 0% 0% 54% n/a 38% 29% c) c) c) 0% 25% d) 25% d) 0% c) 490,000 490,000 925 25,000 2,482,000 415,477 8,000,000 275,000 350,000 10,000 10,000 1,500 130,000 1,000 50,000 1,500 700,000 275,000 90,000 35,000 22,000 2,500 1,000 800,000 800,000 10,000 2,482,000 415,477 8,000,000 225,000 250,000 10,000 10,000 500 130,000 1,000 50,000 700,000 275,000 90,000 35,000 22,000 2,500 925 15,000 50,000 100,000 1,000 1,500 1,000 13,998,477 14,167,902 169,425 18,190 708,567 75,000 10,000 18,190 708,567 75,000 10,000 9,186,505 (1,843,592) 42% 56% 19,681,899 19,871,308 189,409 2,198,544 4,548,846 815,918 162,028 (743,342) 309,082 166,667 743,048 8,200,791 42% 42% 42% 42% 42% Exp. % 39% 50% e) 30% 0% n/a 5,665,373 9,133,210 2,700,000 400,000 1,783,316 5,665,373 9,133,210 2,700,000 400,000 1,783,316 7,563,308 637,483 42% 38% 19,681,899 17,898,583 1,783,316 NET (Resources - Requirements) 2,810,556 1,623,197 (1,206,109) a) Annual payment anticipated to be received in December 09. b) Billed upon completion of work. c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430. d) Transfer made quarterly. e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays 1,972,725 1,972,725 ADULT PAROLE & PROBATION Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 467,892 $ 487,674 $ 19,782 100% 104% $ 467,892 $ 487,674 $ 19,782 Revenues State Miscellaneous 3,333 - (3,333) 42% 0% a) 8,000 4,301 (3,699) State Subsidy 12,292 6,653 (5,639) 42% 23% b) 29,500 29,500 SB 1145 1,183,302 1,480,995 297,693 42% 52% c) 2,839,925 2,961,990 122,065 Probation Work Crew Fees 16,667 15,292 (1,375) 42% 38% d) 40,000 40,000 Miscellaneous 1,250 1,905 655 42% 64% 3,000 3,000 Electronic Monitoring Fee 66,667 76,087 9,420 42% 48% 160,000 160,000 - Probation Superv. Fees 91,667 93,453 1,786 42% 42% 220,000 220,000 - Interest on Investments 3,750 5,578 1,828 42% 62% 9,000 9,000 - Interfund - Sheriff 20,833 25,000 4,167 42% 50% 50,000 50,000 - Crime Prevention Services 20,833 12,500 (8,333) 42% 25% e) 50,000 50,000 Total Revenues 1,420,594 1,717,463 296,869 42% 50% 3,409,425 3,527,791 118,366 Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 47,929 47,930 1 42% 42% 115.029 115,029 1,936,415 2,253,067 316,652 42% 56% 3,992,346 4,130,494 138,148 Exp. % 1,191,136 1,147,958 43,178 42% 40% 2,858,726 2,858,726 293,384 285,634 7,750 42% 41% 704,121 704,121 42 42 42% 0% 100 178,916 178,916 42% n/a 429,399 100 429,399 TOTAL REQUIREMENTS 1,663,478 1,433,592 229,886 42% 36% 3,992,346 3,562,847 429,499 NET (Resources - Requirements) 272,937 819,475 546,538 567,647 567,647 a) 1st quarter hearings officer revenue not yet received. The $8,000 is for the biennium. Actual for FY 2010 will be $4,301. b) Waiting for disbursement of AIP funds. c) Received second quarter funds for periods Oct -Dec. d) Courts have been waiving sign up fees for community service. e) Payments made quarterly. Year End Budget Projection Variance Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 47,929 47,930 1 42% 42% 115.029 115,029 1,936,415 2,253,067 316,652 42% 56% 3,992,346 4,130,494 138,148 Exp. % 1,191,136 1,147,958 43,178 42% 40% 2,858,726 2,858,726 293,384 285,634 7,750 42% 41% 704,121 704,121 42 42 42% 0% 100 178,916 178,916 42% n/a 429,399 100 429,399 TOTAL REQUIREMENTS 1,663,478 1,433,592 229,886 42% 36% 3,992,346 3,562,847 429,499 NET (Resources - Requirements) 272,937 819,475 546,538 567,647 567,647 a) 1st quarter hearings officer revenue not yet received. The $8,000 is for the biennium. Actual for FY 2010 will be $4,301. b) Waiting for disbursement of AIP funds. c) Received second quarter funds for periods Oct -Dec. d) Courts have been waiving sign up fees for community service. e) Payments made quarterly. COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 624,543 Revenues Federal Grants 93,750 Title IV - Family Sup/Pres 15,688 HealthyStart Medicaid 39,583 Child Care Block Grant 33,865 Level 7 Services 72,997 HealthyStart /R -S -G 128,157 OCCF Grant 255,855 Local Government Grants Charges for Svcs-Misc 3,333 Court Fines & Fees 31,250 Interest on Investments 12,500 Grants -Private 833 Interfund Grants 78,125 Crime Prevention Services 30,979 $ 668,626 $ 44,083 63,717 76,820 253,327 7,849 1,254 33,262 4,420 40,000 10,683 (30,033) (15,688) (39,583) (33,865) (72,997) (51,337) (2,528) 7,849 (2,079) 2,012 (8,080) (833) (38,125) (20,296) Total Revenues 796,915 491,332 (305,583) Trans from General Fund 118,472 118,472 Total Transfers In 118,472 118,472 TOTAL RESOURCES 1,539,930 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Budget Year End Projection Variance 100% 107% $ 624,543 $ 668,626 $ 44,083 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 28% 0% 0% 0% 0% 25% 41% n/a 16% 44% 15% 0% 21% 14% 26% 42% 42% 42% 42% 1,278,430 (261,500) 42% d) a) a) a) a) a) e) c) 225,000 37,652 95,000 81,275 175,193 307,577 614,052 8,000 75,000 30,000 2,000 187,500 74,350 367,600 14,907 95,000 257,982 308,924 498,383 7,849 8,000 70,000 30,000 2,000 187,500 74,350 142,600 (22,745) (81,275) 82,789 1,347 (115,669) 7,849 (5,000) 1,912,599 1,922,495 284,333 284,333 9,896 284,333 284,333 45% 2,821,475 2,875,454 53,979 Exp, % 224,991 211,652 13,339 42% 39% b) 739,601 411,401 328,200 42% 23% a,d,e) 42 - 42 42% 0% 210,981 - 210,981 42% n/a TOTAL REQUIREMENTS 1,175,615 623,053 552,562 42% 22% NET (Resources- Requirements) 364,315 655,377 291,062 a) Revenue projections based on final legislative allocations. b) Personnel projection reduced due to two positions open in 1st quarter. c) Court fees reduced for FY 2010. d) New federal grant for the Family Access Network awarded. e) Regional project contributions from Crook & Jefferson counties. 539,978 1,775,043 100 506,354 526,639 1,791,449 13,339 (16,406) 100 506,354 2,821,475 2,318,088 503,387 557,366 557,366 SOLID WASTE Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 338,611 $ 466,325 Revenues State Grant Miscellaneous 12,500 Franchise 3% Fees 83,333 Commercial Disp. Fees 581,833 Private Disposal Fees 642,208 Franchise Disposal Fees 1,976,458 Yard Debris 31,250 Special Waste 12,500 Interest 5,833 Sale of Equip & Material 14,583 $ 127,714 100% 138% $ 338,611 $ 466,325 $ 127,714 37,850 37,850 42% 10,723 (1,777) 42% 14,025 (69,308) 42% 403,038 (178,795) 42% 631,744 (10,464) 42% 1,709,610 (266,848) 42% 38,203 6,953 42% 13,947 1,447 42% 7,148 1,315 42% 14,647 64 42% Total Revenues 3,360,498 TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) n/a a) 36% 30,000 b) 200,000 c) 1,396,400 1,541,300 d) 4,743,500 75,000 30,000 14,000 35,000 7% 29% 41% 36% 51% 46% 51% 42% 2,880,935 (479,563) 42% 36% 37,850 30,000 200,000 1,396,400 1,541,300 4,743,500 75,000 30,000 14,000 35,000 37,850 8,065,200 8,103,050 37,850 3,699,109 3,347,260 (351,849) 42% 40% 8,403,811 8,569,375 165,564 734,824 1,561,773 403,652 62,083 599,903 139,353 699,139 1,238,068 405,019 25,850 177,142 35,685 323,705 (1,367) 36,233 422,761 139,353 42% 42% 42% 42% 42% 42% Exp. % 40% 33% 42% 17% 12% n/a 1,763,578 e) 3,748,254 968,765 f) 149,000 1,439,767 334,447 1,763,578 3,748,254 968,765 149,000 1,439,767 334,447 3,501,588 2,545,218 956,370 42% 30% 8,403,811 8,069,364 334,447 197,521 802,042 604,521 500,011 500,011 a) Was due last fiscal year but received in 09-10. b) Due April 15, 2010. c) This is largely construction waste and has not picked back up as yet. d) Rate increase to go into effect January 1, 2010. e) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the FY. f) Capital item purchases are spread out throughout the fiscal year. Year End Budget Projection Variance $ 127,714 100% 138% $ 338,611 $ 466,325 $ 127,714 37,850 37,850 42% 10,723 (1,777) 42% 14,025 (69,308) 42% 403,038 (178,795) 42% 631,744 (10,464) 42% 1,709,610 (266,848) 42% 38,203 6,953 42% 13,947 1,447 42% 7,148 1,315 42% 14,647 64 42% Total Revenues 3,360,498 TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) n/a a) 36% 30,000 b) 200,000 c) 1,396,400 1,541,300 d) 4,743,500 75,000 30,000 14,000 35,000 7% 29% 41% 36% 51% 46% 51% 42% 2,880,935 (479,563) 42% 36% 37,850 30,000 200,000 1,396,400 1,541,300 4,743,500 75,000 30,000 14,000 35,000 37,850 8,065,200 8,103,050 37,850 3,699,109 3,347,260 (351,849) 42% 40% 8,403,811 8,569,375 165,564 734,824 1,561,773 403,652 62,083 599,903 139,353 699,139 1,238,068 405,019 25,850 177,142 35,685 323,705 (1,367) 36,233 422,761 139,353 42% 42% 42% 42% 42% 42% Exp. % 40% 33% 42% 17% 12% n/a 1,763,578 e) 3,748,254 968,765 f) 149,000 1,439,767 334,447 1,763,578 3,748,254 968,765 149,000 1,439,767 334,447 3,501,588 2,545,218 956,370 42% 30% 8,403,811 8,069,364 334,447 197,521 802,042 604,521 500,011 500,011 a) Was due last fiscal year but received in 09-10. b) Due April 15, 2010. c) This is largely construction waste and has not picked back up as yet. d) Rate increase to go into effect January 1, 2010. e) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the FY. f) Capital item purchases are spread out throughout the fiscal year. 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 TOTAL REVENUES RISK MANAGEMENT Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance % of FY % Coll. $2,491,977 $2,669,291 $177,314 100% 107% $2,491,977 $2,669,291 $177,314 190,402 190,393 (9) 42% 42% 456,964 456,964 119,289 119,210 (79) 42% 42% 286,294 286,294 76,748 76,748 0 42% 42% 184,195 184,195 356,606 356,600 (6) 42% 42% 855,854 855,854 66,746 66,751 5 42% 42% 160,191 160,191 10,417 - (10,417) 42% 0% 25,000 25,000 - 4,167 72,483 68,316 42% 725% 10,000 78,000 68,000 375 525 150 42% 58% 900 900 - 1,667 (23) (1,690) 42% -1% 4,000 4,000 9,167 3,500 (5,667) 42% 16% 22,000 22,000 12,500 17,450 4,950 42% 58% 30,000 30,000 848,083 903,637 55,554 42% 44% 2,035,398 2,103,398 68,000 Transfers In -PERS Reserve 42 - (42) 42% 0% 100 (100) TOTAL RESOURCES 3,340,101 3,572,928 232,827 42% 79% 4,527,475 4,772,689 245,214 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Insurance Loss Prevention Repair / Replacement Total General Liability PROPERTY DAMAGE % Exp. 31,206 974 139,418 a) 13 2,499 152,130 174,110 (21,980) 42% 48% 365,112 370,000 (4,888) Insurance 135,996 a) Repair / Replacement 104,830 b) Total Property Damage 125,000 240,826 (115,826) 42% 80% 300,000 350,000 (50,000) VEHICLE Professional Service 883 Insurance 411 Loss Prevention 4,866 Repair / Replacement 29,503 Total Vehicle 50,000 35,662 14,338 42% 30% 120,000 112,000 8,000 WORKERS' COMPENSATION Settlement / Benefit 196,965 Insurance 72,921 Loss Prevention 5,239 Miscellaneous 10,678 Total Workers' Compensation 258,333 285,803 (27,470) 42% 46% 620,000 630,000 (10,000) UNEMPLOYMENT - Settlement/Benefits 58,333 _ 101,687 43,354) 42% 73% c) 140,000 200,000 (60,000) Total Direct Insurance Costs 643,797 838,089 (194,292) 42% 54% 1,545,112 1,662,000 (116,888) Insurance Administration: Personal Services 114,181 112,445 1,736 42% 41% 274,034 274,034 Materials & Service 102,705 75,820 26,885 42% 31% 246,493 246,493 Capital Outlay 42 42 42% 0% 100 100 Total Insurance Administration 216,928 188,265 28,663 42% 36% 520,627 520,527 100 Contingency 1,025.723 1,025.723 42% n/a 2,461,736 2,461,736 TOTAL REQUIREMENTS 1,886,448 1,026,354 860,094 42% 23% 4,527,475 2,182,527 2,344,948 NET 1,453,653 2,546,574 1,092,921 - 2,590,162 2,590,162 a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen Liab and $135,996 for Property Damage, expended in October. b) Expenditures in property damage is offset by claims reimbursement revenue. c) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD and Health Services. Year End Budget Projection Variance $2,491,977 $2,669,291 $177,314 100% 107% $2,491,977 $2,669,291 $177,314 190,402 190,393 (9) 42% 42% 456,964 456,964 119,289 119,210 (79) 42% 42% 286,294 286,294 76,748 76,748 0 42% 42% 184,195 184,195 356,606 356,600 (6) 42% 42% 855,854 855,854 66,746 66,751 5 42% 42% 160,191 160,191 10,417 - (10,417) 42% 0% 25,000 25,000 - 4,167 72,483 68,316 42% 725% 10,000 78,000 68,000 375 525 150 42% 58% 900 900 - 1,667 (23) (1,690) 42% -1% 4,000 4,000 9,167 3,500 (5,667) 42% 16% 22,000 22,000 12,500 17,450 4,950 42% 58% 30,000 30,000 848,083 903,637 55,554 42% 44% 2,035,398 2,103,398 68,000 Transfers In -PERS Reserve 42 - (42) 42% 0% 100 (100) TOTAL RESOURCES 3,340,101 3,572,928 232,827 42% 79% 4,527,475 4,772,689 245,214 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Insurance Loss Prevention Repair / Replacement Total General Liability PROPERTY DAMAGE % Exp. 31,206 974 139,418 a) 13 2,499 152,130 174,110 (21,980) 42% 48% 365,112 370,000 (4,888) Insurance 135,996 a) Repair / Replacement 104,830 b) Total Property Damage 125,000 240,826 (115,826) 42% 80% 300,000 350,000 (50,000) VEHICLE Professional Service 883 Insurance 411 Loss Prevention 4,866 Repair / Replacement 29,503 Total Vehicle 50,000 35,662 14,338 42% 30% 120,000 112,000 8,000 WORKERS' COMPENSATION Settlement / Benefit 196,965 Insurance 72,921 Loss Prevention 5,239 Miscellaneous 10,678 Total Workers' Compensation 258,333 285,803 (27,470) 42% 46% 620,000 630,000 (10,000) UNEMPLOYMENT - Settlement/Benefits 58,333 _ 101,687 43,354) 42% 73% c) 140,000 200,000 (60,000) Total Direct Insurance Costs 643,797 838,089 (194,292) 42% 54% 1,545,112 1,662,000 (116,888) Insurance Administration: Personal Services 114,181 112,445 1,736 42% 41% 274,034 274,034 Materials & Service 102,705 75,820 26,885 42% 31% 246,493 246,493 Capital Outlay 42 42 42% 0% 100 100 Total Insurance Administration 216,928 188,265 28,663 42% 36% 520,627 520,527 100 Contingency 1,025.723 1,025.723 42% n/a 2,461,736 2,461,736 TOTAL REQUIREMENTS 1,886,448 1,026,354 860,094 42% 23% 4,527,475 2,182,527 2,344,948 NET 1,453,653 2,546,574 1,092,921 - 2,590,162 2,590,162 a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen Liab and $135,996 for Property Damage, expended in October. b) Expenditures in property damage is offset by claims reimbursement revenue. c) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD and Health Services. DESCHUTES COUNTY 911 Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance % of FY Coll. Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital $5,137,000 $ 5,611,168 $ 474,168 100% 109% $5,137,000 $5,611,168 $ 474,168 Revenues Property Taxes - Current 2,554,493 5,402,810 2,848,317 42% 88% a) 6,130,782 6,208,795 78,013 Property Taxes - Prior 41,667 197,095 155,428 42% 197% a) 100,000 270,275 170,275 State Reimbursement 10,208 2,460 (7,748) 42% 10% b) 24,500 6,000 (18,500) Telephone User Tax 223,333 206,538 (16,795) 42% 39% 536,000 536,000 - Data Network Reimb. 14,167 26,032 11,865 42% 77% c) 34,000 27,880 (6,120) Jefferson County 11,667 11,008 (659) 42% 39% 28,000 28,000 User Fee 25,208 49,637 24,429 42% 82% d) 60,500 60,500 Contract Payments 29,167 23,978 (5,189) 42% 34% e) 70,000 26,000 (44,000) Miscellaneous 3,542 3,809 267 42% 45% 8,500 8,500 Interest 15,000 34,371 19,371 42% 95% 36,000 36,000 Interest on Unsegregated Tax 1,563 1,002 (561) 42% 27% 3,750 3,750 - Total Revenues 2,930,015 5,958,740 3,028,725 42% 85% 7,032,032 7,211,700 179,668 Transfers In -Other 42 (42) 42% 0% 100 - (100) TOTAL RESOURCES 8,067,015 11,569,908 3,502,893 42% 95% 12,169,132 12,822,868 653,736 REQUIREMENTS: Expenditures Personal Services 1,590,120 1,425,158 164,962 42% 37% 3,816,287 3,816,287 Materials and Services 537,301 403,439 133,862 42% 31% 1,289,522 1,289,522 Capital Outlay 72,917 13,830 59,087 42% 8% 175,000 175,000 Transfers Out 807,891 - 807,891 42% 0% 1,938,939 1,938,939 Contingency 2,062,243 - 2,062,243 42% n/a 4,949,384 - 4,949,384 % D Exp. TOTAL REQUIREMENTS 5,070,472 1,842,427 3,228,045 42% 15% 12,169,132 7,219,748 4,949,384 NET (Resources - Requirements) 2,996,543 9,727,481 6,730,938 - 5,603,120 5,603,120 a) Projections based on actual collections through November 30, 2009 b) Less activity being performed. c) Annual billings. d) Quarterly billing. e) Less contract activity with law enforcement agencies. Health Benefits Trust Statement of Financial Operating Data Five Months Ended November 30, 2009 Year to Date Budget Actual Variance FY % Coll. % Revised Budget * Year End Projection Variance RESOURCES Beg. Net Working Capital $17,894,797 $ 17,894,797 $ (0) 100% 100% $17,894,797 $17,894,797 $ (0) Revenues: Internal Premium Charges 4,366,667 4,367,753 1,086 42% 42% a) 10,480,000 10,480,275 275 P/T Emp - Add'I Prem 22,917 18,717 (4,200) 42% 34% 55,000 55,000 - Employee Prem Contribution 137,500 141,470 3,970 42% 43% 330,000 330,000 COIC 416,667 455,225 38,559 42% 46% 1,000,000 1,000,000 Retiree / COBRA Co -Pay 208,333 246,938 38,605 42% 49% 500,000 500,000 Prescription Rebates 12,389 12,389 42% n/a 12,389 12,389 Interest 93,750 109,608 15,858 42% 49% 225,000 225,000 Total Revenues 5,245,833 5,352,100 106,267 42% 43% 12,590,000 12,602,664 12,664 TOTAL RESOURCES REQUIREMENTS Expenditures: Personal Services Materials & Services Conferences and Seminars Claims Paid-Medical/Rx Claims Paid-DentalNision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Printing Program Supplies Other Total Materials & Services Capital Outlay Contingency 23,140,630 23,246,897 106,267 92% 76% 30,484,797 30,497,461 12,664 Exp. % 45,540 43,228 2,312 42% 40% 109,297 109,297 1,250 505 745 42% 17% 3,000 3,000 5,936,490 4,819,692 1,116,798 42% 34% b) 14,247,576 11,391,999 2,855,577 759,167 636,037 123,130 42% 35% b) 1,822,000 1,503,359 318,641 (37,565) 37,565 42% n/a (37,565) 37,565 155,225 154,923 302 42% 42% 372,540 372,540 4,792 68,989 (64,197) 42% n/a c) 11,500 11,500 - 121,985 120,234 1,751 42% 41% 292,764 292,764 - 34,020 15,543 18,477 42% 19% 81,648 81,648 20,655 20,676 (21) 42% 42% 49,572 49,572 4,167 393 3,774 42% 4% 10,000 10,000 41,667 1,239 40,428 42% 1% 100,000 100,000 - 12,108 14,125 (2,018) 42% 49% 29,059 29,059 - 7,091,525 5,814,791 1,276,733 42% 34% 17,019,659 13,807,877 3,211,782 42% 0% 100 100 5,564,892 5,564,892 42% 0% 13,355,741 13,355.741 TOTAL REQUIREMENTS 12,701,957 5,858,019 6,843,938 42% 19% 30,484,797 13,917,174 16,567,623 NET (Resources - Requirements) * 10,438,673 17,388,878 6,950,205 - 16,580,287 16,580,287 * Proposed revisions to FY 2010 original budget a) Amount budgeted to be transferred from operating funds for FY 2010. b) Projection based on annualizing 22 weeks of claims paid. YTD actual is $246,280 per week. c) Zurich to reimburse County $57,490 (5/6ths) of the $68,989 payment made in July for the July through December assessment.