Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Finance Update
Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA September 26, 2011 (1) Monthly Investment Report (2) August 2011 Financials I I i I ,. Deschutes County Investments By County Function General $ 106,708,663 Total Investments -$ 106,708,663 Total Investment Income I Less Fee: 5% of Invest. Income Investment Income -Net Investment Income Fiscal Year 2011-12 Aug-11 I I Y-T-D $ 53,578 $ 110,093 -- 53,578 110,093 (2,679) (5,505) $ 50,899 $ 104,589 Commercial Paper $ Corporate Notes 8,662,069 Time Certificates 9,324,063 U. S. Treasuries Federal Agencies 39,514,998 Bankers' Acceptances LGIP/BOTC 49,207,532 $ 106.708.663 0.00-,4 8.12% 8.74-,4 0.00-/_ 37.03°,4 0.00% ~ 100.00-,4 Total Portfolio: By Investment Types Time Certificates Corporate 9% Notes 8% Federal Agencies 37% 46% rcategory Maximums: ~ U.S. Treasuries I LGIP 100-,4 100% Federal Agencies 75% Banker's Acceptances 25-,4 Time Certificates 25% Commercial Paper 20% Corporate Notes 10% (;c .tt 3 Month Tr e as. ~ 12 MOlltll Treas. ~ 3 Month C P ~ 0 .02 % 0 .10 % 0 .18 % Average MatuntY in ,Days General ---632 , I ,, t Memorandum j ~ Date: September 15, 2011 ! 1 To: Board of County Commissioners Erik Kropp, Interim County Administrator From: Marty Wynne, Finance Director I RE: Monthly Financial Reports 1 Attached please find August 2011 financial reports for the following funds: General (001), Community Justice -Juvenile (230), Sheriffs (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 f Statement of Financial Operating Data Two Months Ended August 31, 2011 1 \ I j RESOURCES: Actual Beg. Net Working Capital $ 7,300,000 $ 8,245,725 $ 945,725 100% 113% $7,300,000 $8,245,725 $ 945,725 13% 1 Revenues Property Taxes 3.350,161 281,515 (3,068,646) 17% 1% a) 20,100.967 20,100,967 0% Gen. Rev. -excl. Taxes 397,054 1,090,600 693,546 17% 46% b) 2,382,321 2,382,321 0% Assessor 131,833 186,159 54,326 17% 24% c) 790,996 790,996 0% I County Clerk 244,785 210,171 (34,615) 17% 14% 1,468,707 1,468,707 0% BOPTA 2,066 4,081 2,015 17% 33% c) 12,398 12,398 0% District Attorney 49,778 12,412 (37,366) 17% 4% 298,669 298,669 0% FinancefTax 32,317 61,741 29,424 17% 32% c) 193,900 193,900 0% Veterans 10,224 150 (10,074) 17% 0% 61,341 61,341 0% Property Management 16,033 20,033 4,000 17% 21% 96,200 96,200 0% Grant Projects 333 333 0 17% 17% 2,000 2,000 0% Total Revenues 4,234,584 1,867,196 (2,367,388) 17% 7% 25,407,499 25,407,499 0% TOTAL RESOURCES 11,534,584 10,112,921 (1 ,421 ,663} 17% 31% 32,707,499 33,653,224 945,725 3% REQUIREMENTS: I EXP·%I Expenditures Assessor 567,550 513,602 53,948 17% 15% 3,405,300 3,405,300 0% County Clerk 237,328 169,082 68.246 17% 12% 1,423.965 1,423.965 0% j BOPTA 12,067 11,302 765 17% 16% 72,402 72,402 0%i I j District Attorney 813,216 695,054 118,162 17% 14% 4,879,296 4.879,296 0% FinancefTax 135,608 100,684 34,924 17% 12% 813,648 813,648 0% Veterans 43,686 40,835 2,851 17% 16% 262.115 262.115 0% Property Management 42,944 40,766 2,178 17% 16% 257,664 257,664 0% Grant PrOjects 19,786 19,710 76 17% 17% 118.715 118,715 0% Non-Departmental 261,160 166,363 94,797 17% 11% 1,566,962 1,566,962 O°..{, Contingency 1,162,787 1,162,787 17% nla 6,976,722 6,976,722 100% 3,296,132 1,757,398 1,538,734 17% 9% 19,776,789 12,800,067 6,976,722 35% Transfers Out 2.155,118 1,904,790 250,328 17% 15% 12,930,710 12,930,710 0% TOTAL REQUIREMENTS 5,451,250 3,662,188 1,789,062 17% 11% 32,707,499 25,730,777 6,976,722 21% NET (Resources -Requirements) 6,083,334 6,450,733 367,399 7,922,447 7,922,447 a) Current year property taxes will be collected beginning in October b) Includes annual payments: Tax on Electric Co-ops $489,027, PIL T $471,823 c) A & T Grant received quarterly. 1 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Two Months Ended August 31, 2011 RESOURCES: Beg. 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 Year to Date Budget I Actual I Variance IFY% I Coli. % $1,101,374 1,667 8,333 2,500 4,167 36,250 14,748 17 11,667 10 7 50 1,250 400 83 1,000 25,688 3,333 $1,099,010 $ (2,364) 100% 100% (1,667) 17% 0% 6,591 (1,742) 17% 13% 2,101 (399) 17% 14% 2,326 (1,841) 17% 9% (36,250) 17% 0% a) 900 (13,848) 17% 1% b) (17) 17% 0% 1,450 (10,217) 17% 2% 177 167 17% 295% c) (7) 17% n/a 745 695 17% 248% c) 1,121 (129) 17% 15% 200 (200) 17% 8% d) 300 217 17% 60% 138 (862) 17% 2% (25,688) 17% 0% e) (3.333} 17% 0% Variance $1,101,374 10,000 50,000 15,000 25,000 217,498 88,490 100 70,000 60 40 300 7,500 2,400 500 6,000 154,128 20,000 $1,099,010 $ (2,364) 10,000 50,000 15,000 25,000 355,730 138,232 88,490 100 70,000 200 140 40 825 525 7,500 1,200 (1,200) 500 6,000 134,620 (19,508) 20.000 Total Revenues 111,170 16,049 (95,121) 17% 2% 667,016 785,205 118,189 Transfers In-General Fund 886,910 886,910 17% 17% 5.321,459 5,321,459 TOTAL RESOURCES 2,099,454 2,001,969 (97,485) 17% 28% 7,089,849 7,205,674 115,825 REQUIREMENTS: 1 Exp. %1 Expenditures Community Justice-Juvenile Personal Services 851,512 818,151 33,361 17% 16% 5,109,069 5,109,069 Materials and Services 199,289 156.018 43,271 17% 13% a)e) 1,195,733 1,182,725 13,008 Capital Outlay 17 17 17% 0% 100 100 Transfers Out 8,400 8,400 17% 0% 50,400 50,400 Contingency 122,425 122.425 17% n/a 734,547 734,547 TOTAL REQUIREMENTS 1,181,643 974,169 207,474 170/0 14% 7,089,849 6,342,194 747,655 NET (Resources -Requirements) 917,811 1.027,800 109,989 863,480 863,480 a) OVA Basic and Diversion funding increased after budget was submitted. Projections for revenue and expenditures adjusted accordingly b) Billings outstanding -$14,250 for July & August c) Revenues trending greater than antiCipated d) Citizen Review Board vacated. Revenue projected adjusted accordingly e) CCF (JCP) funding less than anticipated. Projections of revenue and expenditures adjusted accordingly SHERIFF -Fund 255 Statement of Financial Operating Data Two Months Ended August 31, 2011 Year to Date Actual Coli. % RESOURCES: Beg. Net Working Capital $ $ $ 100% nla $ $ $ 17% 13% 17% 13% Total Revenues 6,088,920 4,611,632 (1,477,288) 17% 13% 36,533,516 31,865,481 (4,668,035) TOTAL RESOURCES 6,088,920 4,611,632 (1,477,288) 17% 13% 36,533,516 31,865,481 (4,668,035) REQUIREMENTS: Exp. %1 EXPENDITURES & TRANSFERS Sheriffs Division 416,083 415,864 219 17% 17% 8) 2,496,498 2,583,942 (87,444) Civil 137,349 115,069 22,280 17% 14% 824,095 824,095 Automotive/Communications 244,439 89,735 154,704 17% 6% b) 1,466,632 1,622,207 (155,575) Investigations/Evidence 289,036 279,505 9,531 17% 16% 1,734,218 1,734,218 Patrol/Civil/Comm Supp 1,318,617 1,290,530 28,087 17% 16% 7,911,704 7,911,704 Records 120,118 96,953 23,165 17% 13% 720,710 720,710 Adult Jail 1,690,632 1,422,253 268,379 17% 14% c) 10,143,790 10,443,790 (300,000) Court Security 47,767 45,056 2,711 17% 16% 286,602 286,602 Emergency Services 30,938 28,913 2,025 17% 16% 185,625 185,625 Special Services Division 217,395 200,280 17,115 17% 15% 1,304,370 1,304,370 Regional Work Center 503,078 457,791 45,287 17% 15% 3,018,466 3,018,466 Training Division 54,044 48,292 5,752 17% 15% 324,265 324,265 Other Law Enforcement SVC5 105,376 109,184 (3,808) 17% 17% 632,256 632,256 Non-Departmental 12,205 12,205 17% 17% 73,231 73,231 Contingency 868,509 868,509 17% nla 5,211,054 5,211,054 Transfers Out -D/S Fund 33,333 33,333 17% 0% 200,000 200,000 TOTAL REQUIREMENTS 6,088,919 4,611,630 1,477,289 17% 13% 36,533,516 31,865,481 4,668,035 NET (Resources -Requirements) a) Reclassification open Personnel Assistant position to Operations Captain position b) Carryover of the Motorola communication system contract c) Carryover of the Jail Management Infonnation System Project 1 RESOURCES: Beg. Net Working Capital Tax Revenues -Current Tax Revenues -Prior Federal Grants State Grant Transp. of State Wards S81145 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 Sale of Reportable Assets Total Revenues Fund 701 LED-Countywide Statement of Financial Operating Data Two Months Ended August 31, 2011 Year to Date Budget $5,108,671 2,384,474 83,500 5,867 8,079 833 256,277 833 15,167 697 25,000 167 638 1,100 8,333 583 833 833 2,500 2,667 833 33,333 4,722 589 167 Budget YearEnd Projection Variance 5,108,671 $6,090,734 $ 982,063 14,306,841 14,306,841 501,000 501,000 35,200 35,200 48,475 48,475 5,000 5,000 1,537,663 1,479,991 (57,672) 5,000 5,000 91,000 91,000 4,180 4,180 150,000 150,000 1,000 1,000 3,825 3,825 6,600 6,600 50,000 50,000 3,500 3,500 5,000 5,000 5,000 5,000 15,000 15,000 16,000 16,000 5,000 5,000 200,000 200,000 28,333 28,333 3,533 3,533 1,000 1,000 I Actual I $ 6,090,734 205,267 215,978 14,957 1,276 2,835 625 800 934 1,900 1,676 1,636 36,255 5,310 45 $ 982,063 (2,384,474) 121,767 (5,867) (8,079) (833) (40,299) (833) (210) (697) (25,000) (167) (638) 176 (5,498) 42 (33) 101 (600) (991) 803 2,922 588 (544) ~1672 Variance I FY %I Coli. % 100% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 119% $ 0% 41% 0% 0% 0% 14%8) 0% 16% 0% 0% 0% 0% 19% 6% 18% 16% 19% 13% 10% 33% 18% 19% 1% n/a 2,846,025 497,309 ~2,348,716} 17% 3% 17,076,150 17,018,478 ~57,672} TOTAL RESOURCES 7,954,696 6,588,043 (1,366,653) 170k 30% 22,184,821 23,109,212 924,391 REQUIREMENTS: To: Fund 255 Departments Sheriffs Services Civil Auto/Comm Adult Jail Court Security Emergency Services Special Services Work Center Training Other (CODE, Forensic) Internal Services Transfer to Debt Service Contingency Total to Fund 255 390,282 137,349 91,467 1,690,632 47,767 30,938 151,135 503,078 32,993 105,376 6,115 33,333 460,340 3,680,804 390,076 115,069 33,578 1,422,253 45,056 28,913 139,237 457,791 29,482 109,184 6,115 2,776,753 205 22,280 57,889 268,379 2,711 2,025 11,899 45,287 3,512 (3,808) 0 33,333 460,340 904,050 1 Exp. %1 17% 17% 17% 14% 17% 6% 17% 14% 17% 16% 17% 16% 17% 15% 17% 15% 17% 15% 17% 17% 17% 17% 17% 0% 17% 0% 2,341,690 824,095 548,799 10,143,790 286,602 185,625 906,811 3,018,466 197,961 632,256 36,689 200,000 2,762,037 22,084,821 2,423,712 824,095 607,014 10,443,790 286,602 185,625 906,811 3,018,466 197,961 632,256 36,689 200,000 19,763,020 (82,022) (58,215) (300,000) 2,762,037 2,321,801 Transfer to Reserve Fund (703) 16,667 16,667 17% 0% 100,000 100,000 Total Requirements 7,378,274 2,776,753 4,601,519 13% 22,184,821 19,863,020 2,321,801 Net 576,422 3,811,290 3,234,867 3,246,192 3,246,192 a) Reduction in State Community Corrections funding for custody of S8 1145 inmates TOTAL RESOURCES REQUIREMENTS: To: Fund 255 Departments Sheriff'S Services AutofComm Investigations Patrol Records Special Services Training Internal Services 4,871,885 25,801 152,972 289,036 1,318,617 120,118 66,260 21,051 6,090 169 3,578,988 25,788 56,157 279,505 1,290,530 96,953 61,043 18.810 6,090 (1,292,897) 14 96,815 9,531 28,087 23,165 5,216 2,241 60% 26% I Exp·%1 17% 17% 17% 6% 17% 16% 17% 16% 17% 13% 17% 15% 17% 17% 14,548,695 154,808 917,833 1,734,218 7,911,704 720,710 397,559 126,304 36,542 7 14,566,348 160,230 1,015,193 1,734,218 7,911,704 720,710 397,559 126,304 36,542 17,653 (5,422) (97,360) Transfer to Reserve Fund (704) 16,667 16,667 17% 0% 100,000 100,000 Total Requirements 4,816,232 1,834,877 2,981,355 13% 14,548,695 12,202,461 2,346,234 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues -Current Tax Revenues -Prior Federal Grants Federal Grants-BLM US Forest Service State Grant SB #1065 Court Assessment Marine Board License Fee Des Cty General Fund Grant Des Cty Transient Room Tax City of Sisters Des Cty CDD Contract Des Cty Solid Waste Contr Des Cty Clerk/Election School Districts Security &Traffic Reimb Seat Belt Program Miscellaneous Restitution Sheriff Fees Court Fines &Fees Impound Fees Restitution -Street Crimes SeizurefF orfeiture Interest Interest on Unsegregated Donations Sale of Reportable Assets Sale of Equip &Material Total Revenues Fund 702 LED Rural Statement of Financial Operating Data Two Months Ended August 31, 2011 Vearlo Date Budget I Actual I Variance $2,936,523 $2,988,333 $ 51,810 1,224,687 (1,224,687) 42,833 102,318 59,485 2.000 927 (1,073) 4.167 3,377 (790) 17% nfa 13,125 (13,125) 17% 0% 33,495 (33,495) 17% 0% 10,000 6,591 (3,409) 17% 11% 23,722 (23,722) 17% 0% 96,024 (96,024) 17% 0% 345.643 345,643 17% 17% 74,994 74,994 17% 17% 9.061 9.061 17% 17% 9,061 9,061 17% 17% 333 (333) 17% 0% 13.333 (13,333) 17% 0% a) 833 680 (153) 17% 14% 2,000 1,385 (615) 17% 12% 1.667 1.071 (596) 17% 11% 2,004 2,004 17% nfa 1,667 1,724 57 17% 17% 19,167 17,408 (1,759) 17% 15% 1,167 800 (367) 17% 11% 83 (83) 17% 0% 1,324 1,324 17% nfa 1.667 2,460 793 17% 25% 300 22 (278) 17% 1% 2,515 2,515 17% n/a 1,000 374 (626) 17% 6% 3,333 6,916 3,583 17% 35% 1,935,362 590,655 {1,344,7071 60% 6% I FY % I Coli. % 100% 102% 17% 0% 17% 40% 17% 8% Budget Year End Projection Variance $2,936,523 $2,988,333 $ 51,810 7,348,125 7.348.125 257,000 257,000 12,000 12,000 25,000 25,000 78,750 78,750 200,972 200,972 60,000 60.000 142,332 142.332 576,144 576.144 2,073,856 2.073.856 449,961 449.961 54,366 54,366 54,366 54,366 2,000 2,000 80,000 40.000 (40.000) 5,000 5,000 12,000 12.000 10,000 10.000 2,004 2,004 10,000 10,000 115,000 115,000 7,000 7,000 500 500 1,324 1,324 10,000 10.000 1,800 1,800 2,515 2,515 6,000 6.000 20.000 20,000 11,612,172 11,578,015 {34,157} Net 55,653 1,744,111 1,688,458 2,363,886 2,363,886 a) By mutual agreement between the Sheriff'S Office and the School District, fewer SRO deputies will be at the schools PUBLIC HEALTH Statement of Financial Operating Data Two Months Ended August 31, 2011 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 100 70 (30) 17% 12% 600 600 State Grant 422,782 301,247 (121,535) 17% 12% 2,536,691 2,536,691 Child Dev & Rehab Center 4,101 (4,101) 17% 0% 24,607 24,607 State Miscellaneous 37,472 (37,472) 17% 0% 224,829 224,829 OMAP 87,308 147.387 60,079 17% 28% 523,850 523,850 Family Planning Exp Proj 86,667 38,218 (48,449) 17% 7% 520,000 520,000 Local Grants 7,500 10,000 2,500 17% 22% 45,000 45,000 Water Program-Base Fee 7,000 (7,000) 17% 0% 42,000 42,000 Contract Payments 25,000 25,000 17% nla 25,000 25,000 Water Program-Field Work 9,303 (9,303) 17% 0% 55,817 55,817 H20 Sys Insp-Priv Wells 33 (33) 17% 0% 200 200 Miscellaneous 60 60 17% nla 300 300 Patient Insurance Fees 22,563 19,197 (3,366) 17% 14% 135,380 135,380 Health DepUPatient Fees 19,795 16,138 (3,657) 17% 14% 118,770 118,770 Vital Records-Birth 5,100 7,830 2,730 17% 26% 30,600 30,600 Vital Records-Death 16,667 14,460 (2,207) 17% 14% 100,000 100,000 Environmental Health 117,392 41,664 (75,728) 17% 6% 704,350 704,350 Interest on Investments 2,000 1,417 (583) 17% 12% 12,000 12,000 Donations 4,338 8,045 3,707 17% 31% 26,030 26,030 Interfund Contract 33,065 (33,065) 17% 0% 198,387 198,387 Administrative Fee 2,509 2,509 17% 17% 15,056 15,056 Total Revenues 885,695 633,242 (252,453) 17% 12% 5,314,167 5,339,467 25,300 Transfers In-General Fund Transfers In-PH Res Fund Transfers In-Gen. Fund Other 386,294 5,000 10.850 386.294 (5.000) ~10,850~ 17% 17% 17% 17% 0% 0% 2.317,765 30,000 65,100 2,317,765 30,000 65,100 TOTAL RESOURCES 2,884,757 2,721,665 (163,092) 17% 29% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 1,035,825 302,641 33,333 25,000 134,525 982,408 234,250 53,417 68,391 33,333 25,000 134,525 I Exp.%l 17% 16% 17% 13% 17% 0% 17% 0% 17% n/a TOTAL REQUIREMENTS 1,531,324 1,216,658 314,666 17% 13% 9,323,950 9,454,461 130,511 6,214,951 1,815,848 200,000 286,000 807,151 6.214.951 1 ,815,848 200,000 286,000 807,151 9,323,950 8,516,799 807,151 NET (Resources -Requirements) 1,353,433 1,505,007 151,574 937,662 937,662 BEHAVIORAL HEAlTH Statement of Financial Operating Data Two Months Ended August 31, 2011 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Two Months Ended August 31. 2011 Year to Date Budget I Actual I Variance I FY % I Coil. % BudQet YearEnd Projection Variance RESOURCES: Beg. Net Working Capital Revenues Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Prog Planning-Current Planning-Long Range $ 229,822 4.058 167 27,783 200.147 43,192 26,700 46.733 112,483 42,288 136,681 6.587 702 38.644 215.028 52,429 23.357 67,497 102,133 53.020 $ (93,141) 2.529 535 10.861 14.881 9.237 (3.343) 20.764 (10.350) 10.732 100"10 17% 17% 17% 17% 17% 17% 17% 17% 17% 59% 27% 70% 23% 18% 20% 15% 24% 15% 21% a) b) a) a) a) c) a) a) $ 229,822 24,350 1.000 166,700 1.200.880 259.150 160.200 280,400 674,900 253.726 $ 136,681 24.350 1.500 166,700 1,200,880 259,150 160,200 280,400 674,900 253,726 (93,141) 500 Total Revenues 503,551 559,397 55,846 17% 19% 3,021,306 3,021,806 500 Trans In-GF Trans In-GF for Lng Rng Ping Trans In-Other TOTAL RESOURCES 104.938 82.560 17 920,888 104.938 82,560 883,576 (17) (37,312) 17% 17% 17% 17% 17% 17% 0% 20% 629.625 495,360 100 4,376,213 629,625 495,360 100 4,283,572 (92,641) 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 235,303 21,293 34.095 93.672 39.570 27,615 23.851 103.167 79.801 28.981 42.021 236,308 19,808 33.626 88,523 46,678 31,993 26.360 91.286 72.109 (1.005) 1,485 469 5.149 (7.108) (4.378) (2,509) 11.881 7.692 28.981 42.021 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% Exp. %1 17% 16% 16% 16% 20% 19% 18% 15% 15% 0% n1a d) d) e) 1,411,818 127.755 204.570 562.032 237,420 165.689 143,108 619.002 478,806 173.885 252,128 1,411.818 127.755 204.570 562.032 237,420 165,689 143,108 619.002 478.806 173.885 252.128 TOTAL REQUIREMENTS 729,369 646,691 82,679 17% 15"10 4,376,213 4,124,085 252,128 NET (Resources· Requirements) 191,519 236,886 45,367 159,487 159,487 Revenues Expenditures Net from OperatiOns 559.397 646.691 (87.294) 3,021.306 4.376,213 (1,354,907) 3.021,806 4.124,085 (1.102,279) 500 252,128 252,628 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 1 1 I 1 I1 ! I q 1 I 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 Park.ing Fees Interfund 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 Res TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources -Requirements) ROAD Statement of Financial Operating Data Two Months Ended August 31, 2011 Year to Date Budget I Actual I Variance IFY% I Coli. % $2,834,720 $ 3,417,158 $ 582,438 100% 121% 231 231 17% n/a 100,000 (100,000) 17% 0% 3,333 (3,333) 17% n/a 6,667 3,627 (3,040) 17% 9% 218,527 (218,527) 17% 0% 83,340 500,041 416,701 17% 100% 1,890,000 1,654,805 (235,195) 17% 15% 45,833 (45,833) 17% 0% 58,333 (58,333) 17% 0% 1,667 (1,667) 17% 0% 1,667 (1,667) 17% 0% 167 673 506 17% 67% 3,333 2,345 (988) 17% 12% 167 (167) 17% 0% 3,333 3,297 (36) 17% 16% 24 (24) 17% 0% 121,667 (121,667) 17% 0% 33,333 (33,333) 17% 0% 15,000 (15,000) 17% 0% 1,667 (1,667) 17% 0% 11,917 (11,917) 17% 0% 4,167 (4,167) 17% 0% 583 (583) 17% 0% 105,500 2,379 ~103,121l 17% 0% 2,710,225 2,167,398 (542,827) 17% 13% 47,629 (47,629) 17% 0% 41,667 (41,667) 17% 0% 2,000 (2,000) 17% 0% 5,636,241 5,584,556 (10,018) 170/0 29% 1 EXP.%l 935,887 884,659 51,228 17% 16% 1,695.446 2,340,376 (644,930) 17% 23% 206,115 21,152 184,963 17% 2% 100,000 100,000 17% 0% 336,525 336,525 17% n/a 3,273,973 3,246,187 27,786 17% 17% 2,362,268 2,338,369 17,768 a) Revenue will be received following completion of Cascade Lakes chip seal (October 2011) b) Annual payment-January 2012 c) Annual payment received in August d) Billed upon completion of work. e) Payments to be received in June 2012 from other Road Department funds Budget Year End Projection Variance $ 2,834,720 $ 3,417,158 $ 582,438 231 231 a) 600,000 600,000 20,000 20,000 40,000 40,000 b) 1,311,162 1,311,162 c) 500,041 500,041 11,340,000 11,340,000 d) 275,000 275,000 d) 350,000 350,000 d) 10,000 10,000 d) 10,000 10,000 1,000 1,000 20,000 20,000 1,000 1,000 20,000 20,000 144 144 e) 730,000 730,000 200,000 200,000 90,000 90,000 e) 10,000 10,000 e) 71,500 71,500 e) 25,000 25,000 3,500 3,500 633,000 633,000 16,261,347 16,261,578 285,773 285,773 250,000 250,000 12,000 12,000 19,643,840 20,226,509 582,669 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 2,601,821 2,601,821 231 ADULT PAROLE &PROBATION Statement of Financial Operating Data Two Months Ended August 31,2011 RESOURCES: Beg. Net Working Capital Revenues DOC Measure 57 State Miscellaneous Alternate Incarceration State Subsidy SB 1145 Probation Work Crew Fees Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Interest on Investments Interfund -Sheriff Crime Prevention Grant CFC-Domestic Violence Total Revenues Transfers In-General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency Year to Date Budget ! Actual ! Variance $ 560,000 $ 634,125 $ 74,125 36,225 717 5,153 2,167 475,942 4,000 683 28,333 33,333 1,500 8,333 8,333 12,472 1,663 401,103 5,608 320 20,466 30,126 805 8,333 (36,225) (717) (5,153) (504) (74,839) 1,608 (363) (7,867) (3,207) (695) (8,333) (12,472) 617,191 468,424 (148,767) 56,382 56,382 1,233,573 1,158,931 (74,642) 528,115 480,313 47,802 147,815 103,027 44,788 17 17 4,800 4,800 86,162 86,162 !FY % 1 Coil. % 100% 113% 17% 0% 17% 0% 17% 0% 17% 13% 17% 14% 17% 23% 17% 8% 17% 12% 17% 15% 17% 9% 17% 17% 17% 0% 17% 0% 17% 13% 17% 17% 17% 25% 1 Exp.%l 17% 15% 17% 12% 17% 0% 17% 0% 17% nfa a) b) c) d) e) e) Budget Year End Projection Variance $ 560,000 $ 634,125 $ 74,125 217,350 217,350 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 SO,OOO 50,000 SO,OOO 50,000 74,832 74,832 3,703,160 3,590,536 (112,624) 338,292 338,292 4,601,452 4,562,953 (38,499) 3,168,688 886,890 100 28,800 516,974 3,168,688 886,890 28,800 100 516,974 TOTAL REQUIREMENTS 766,909 583,340 183,569 17% 13% 4,601,452 4,084,378 517,074 NET (Resources -Requirements) 466,664 575,591 108,927 478,575 478,575 a) Annual allocation expected in September b) Annual allocation normally received in February c) State invoiced monthly. Payment of July and August invoices expected in September d) Payments received quarterly; due to lower population and cost savings, revenue will be less than budgeted e) Interfund grant received quarterly ~ J :1 I COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Two Months Ended August 31. 2011 Vearto Date RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV -Family Sup/Pres HealthyStart Medicaid level 7 Services DHS-Runaway Homeless State Prevention Funds HealthyStart /R-S-G OCCFGrant Charges for Svcs-Misc Court Fines & Fees Interest on Investments Donations Miscellaneous Total Revenues Budget $ 467,111 49,915 6.555 15.833 42,997 4,083 51.973 90,867 1,333 13.000 833 20.146 297,535 I $ Actual 556,143 20,472 588 5 22,969 44,034 I Variance IFY % I Coil. % $ 89,032 100% 119% (49.915) (6,555) (15.833) (42,997) (4,083) (51,973) (90,867) (1.333) 7,472 (245) 5 2,823 (253,501) 17% 0% 17% 0% 17% 0% 17% 0% 17% n/a 17% 0% 17% 0% 17% 0% 17% 0% 17% 26% 17% 12% 17% n/a 17% 19% 17% 2% a) b) a) c) d) a) a) e) f) Trans from General Fund Total Transfers In 45,493 45,493 45,494 45,494 17% 170/_ 17% 17% TOTAL RESOURCES 810,139 645,671 (164,469) 17% 26% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 100,853 281,163 17 38,848 92,183 29,593 8,670 251,570 17 38,848 1 Exp. %1 17% 15% 17% 2% 17% 0% 17% n/a TOTAL REQUIREMENTS 420,881 121,776 299,105 17% 5% NET (Resources -Requirements) 389,258 523,895 134,636 a) FY 12 and FY 13 Intergovernmental Agreement finalized funding levels from OCCF b) Medicaid revenues reduced due to lower projections c) Runaway/homeless youth grant from Department of Human Services d) Youth Suicide Prevention grant increased by $5.000 e) Court fees projected to be higher than estimated in the original budget f) Two additional grants of $55,000 & $180.000 awarded Budget Year End Projection Variance $ 467,111 $ 556,143 $ 299,488 299,488 39,329 39.534 95,000 85,000 257,982 196,898 48,122 24.500 29,500 311,838 258,203 545,203 492,806 8,000 8,000 78,000 85,000 5,000 5,000 5 120,875 355.875 89,032 205 (10,000) (61,084) 48,122 5,000 (53,635) (52,397) 7,000 5 235,000 1,785,215 1,903,431 118,216 272,960 272,960 272,960 272,960 2,525,286 2,732,534 605.119 1.686,979 100 233,088 605,119 1.713.245 100 2,525,286 2,318,464 207,248 (26.266) 233,088 206,822 414,070 414,070 SOLID WASTE Statement of Financial Operating Data Two Months Ended August 31,2011 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Franchise 3% Fees Commercial Disp. Fees Private Disposal Fees Franchise Disposal Fees Yard Debris Special Waste Interest Leases Recyclables Budget $1,092,508 3,667 33,333 143,333 219,000 666,667 12,167 4,167 1,250 5,000 Year to Date I Actual I Variance $ 1,141,691 $ 49,183 3,589 (78) 5,127 (28,206) 166,472 23,139 275,130 56,130 690,065 23,398 22,857 10,690 712 (3,455) 1,617 367 1,393 1,393 15,948 10,948 I FY %1 100% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% Coil. % 105% 16% 3% 19% 21% 17% 31% 3% 22% a) b) n/a c) 53% Budget Year End Projection Variance $1,092,508 $ 1,141,691 $ 49,183 22,000 22,000 200,000 200,000 860,000 860,000 1,314,000 1,314,000 4,000,000 4,000,000 73,000 73,000 25,000 25,000 7,500 7,500 1 10,394 10,393 30,000 30,000 Total Revenues 1,088,584 1,182,910 94,326 17% 18% 6,531,501 6,541,894 10,393 TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out-Road Contingency 2,181,092 278,600 482,175 161,872 28,667 226,629 92,726 2,324,601 264,353 203,459 143,509 14,247 278,716 161,872 28,667 226,629 92,726 17% 17% 17% 17% 17% 17% 17% 30% Exp·%1 16% 7% 0% 0% 0% n/a d) e) 7,624,009 1,671,598 2,893,052 971,233 172,000 1,359,773 556,353 7,683,585 1,671,598 2,893,052 971,233 172,000 1,359,773 59,576 556,353 TOTAL REQUIREMENTS 1,270,669 467,812 802,857 17% 6% 7,624,009 7,067,656 556,353 NET (Resources· Requirements) 910,423 1,856,789 946,366 615,929 615,929 a} Due April 15, 2012 b} Dependent on special clean-ups such as asbestos and contaminated soil c} Revenue from rent on Rickard Road property, not included in original budget d) To be expended in November ($398,827) and May ($572,406) e) Transfers made quarterly RISK MANAGEMENT Statement of Financial Operating Data Two Months Ended August 31, 2011 RESOURCES: Beginning Net Working Capital $2,100,000 $2,039,937 ($60,063) 100% 97% $2,100,000 $2,039,937 ($60,063) Revenues Inter-fund Charges: General liability 41,809 41,809 (0) 17% 17% 250,855 250,855 Property Damage 51,939 51,939 0 17% 17% 311,633 311,633 Vehicle 29,718 29,718 (0) 17% 17% 178,310 178,310 Workers' Compensation 245,657 245,657 (0) 17% 17% 1,473,944 1,473,944 Unemployment 42,072 42,126 54 17% 17% 252,433 252,433 Claims Reimb-Workers' Compensation 833 (833) 17% 0% 5,000 5,000 Claims Reimb-Gen liab/Property 3,333 3,091 (242) 17% 15% 20,000 20,000 Process Fee-Events/Parades 250 420 170 17% 28% 1,500 1,500 Miscellaneous 8 (8) 17% 0% 50 50 Skid Car Training 3,000 350 (2,650) 17% 2% 18,000 18,000 Interest on Investments 2,500 2,119 (381) 17% 14% 15,000 15,000 Other Interest 8 (8) 17% 0% 50 50 TOTAL REVENUES 421,129 417,229 (3,900) 17% 17% 2,526,775 2,526,775 TOTAL RESOURCES 2,521,129 2,457,166 (63,963) 17% 53% 4,626,775 4,566,712 (60,063) AppropriationslExpendltures I %Exp. I Direct Insurance Costs: GENERAL LIABILITY Settlement I Benefit 2,277 Defense 37,919 Professional Service Insurance 100 Loss Prevention 78 Repair I Replacement 611 Total General Liability 66,667 40,984 25,682 17% 10% 400,000 400,000 PROPERTY DAMAGE Insurance Repair I Replacement 379 Total Property Damage 50,037 379 49,659 17% 0% 300,223 300,223 VEHICLE Professional Service Insurance Loss Prevention Repair I Replacement 4,018 Total Vehicle 16,914 4,018 12,896 17% 4% 101,485 101,485 WORKERS' COMPENSATION Settlement I Benefit 114,052 Defense 134 Professional Service Insurance 54,720 Loss Prevention 7,862 Miscellaneous 14 Total Workers' Compensation 133,333 176,781 (43,448) 17% 22% 800,000 BOO,OOO UNEMPLOYMENT -SettiemenVBenefits 41,667 41,667 17% 0% 250,000 250,000 Total Direct Insurance Costs 308,618 222,162 86,456 17% 12% 1,851,708 1,851,708 Insurance Administration: Personal Services 49,060 48,391 669 17% 16% 294,357 294,357 Materials &Service 27,953 21,988 5,965 17% 13% 167,717 167,717 Capital Outlay 17 17 17% 0% 100 100 Total Insurance Administration 77,029 70,379 6,650 17% 15% 462,174 462,074 100 Transfers Out 1,200 1,200 17% 0% 7,200 7,200 Contingency 384,282 384,282 17% n/a 2,305,693 2,305,693 TOTAL REQUIREMENTS 771,129 292,541 478,588 17% 6% 4,626,n5 2,320,982 2,305,793 NET 1,750,000 2,164,625 414,625 2,245!730 2,245!730 DESCHUTES COUNTY 911 Statement of Financial Operating Data Two Months Ended August 31, 2011 Year to Date YearEnd Actual Variance Bud!ilet Projection Variance RESOURCES: Beg. Net Working Capital $6,400,000 $ 7,559,639 $ 1,159,639 100% 118% $6,400,000 $7,559,639 $ 1,159,639 Revenues Property Taxes -Current 997,296 (997,296) 17% 0% 5,983,773 5,983,773 Property Taxes -Prior 33,333 77,625 44,292 17% 39% 200,000 200,000 State Reimbursement 9,000 (9,000) 17% 0% a) 54,000 54,000 Telephone User Tax 125,000 (125,000) 17% 0% 750,000 750,000 Data Network Reimb. 4,533 (4,533) 17% 0% b) 27,200 27,200 Jefferson County 5,833 565 (5,268) 17% 2% 35,000 35,000 User Fee 8,667 (8,667) 17% 0% c) 52,000 52,000 Police RMS User Fees 33,167 (33,167) 17% 0% b) 199,000 199,000 Contract Payments 5,333 (5,333) 17% 0% b) 32,000 32,000 Miscellaneous 1,500 1,135 (365) 17% 13% 9,000 9,000 Interest 5,833 6,809 976 17% 19% 35,000 35,000 Interest on Unsegregated Tax 133 19 ~114~ 17% 2% 800 800 Total Revenues 1,229,628 86,153 (1,143,475) 17% 1% 7,377,773 7,377,773 TOTAL RESOURCES 7,629,628 7,645,792 16,164 17% 55% 13,777,773 14,937,412 1,159,639 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 706,806 326,226 85,833 83,333 1,094,097 648,150 343,872 5,928 58,656 (17,646) 79,905 83,333 1,094,097 17% 17% 17% 17% 17% % Exp·1 15% 18% 1% 0% nla 4,240,834 1,957,356 515,000 500,000 6,564,583 4,240,834 1,957,356 515,000 500,000 6,564,583 TOTAL REQUIREMENTS 2,296,295 997,950 1,298,345 17% 7% 13,777,773 7,213,190 6,564,583 NET (Resources -Requirements) 5,333,333 6,647,842 1,314,509 7,724,222 7,724,222 a) GIS/MSAG monthly billings to Oregon Emergency Management b) Invoiced annually in AugusVSeptember c) US Forest Service invoiced $2156.25 quarterly. Crooked River Ranch invoiced annually in June Health Benefits Trust Statement of Financial Operating Data Two Months Ended August 31, 2011 Year to Date Budget Actual Variance FY% IcolI.%i1 I Year End Budaet Projection Variance I 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 2,002.619 2,002,116 (502) 17% 17% 12,015,711 12,015,711 PfT Emp -Add'i Prem 8,333 4,976 (3,358) 17% 10% 50,000 50.000 Employee Prem Contribution 105,000 105,220 220 17% 17% 630,000 630.000 COIC 210,000 205,552 (4,448) 17% 16% 1,260,000 1,260,000 Retiree / COBRA Co-Pay 83,333 159,040 75,706 17% 32% 500,000 500,000 Fees for Clinic Services 200 200 17% nla 200 200 Interest 13.333 14.839 1,506 17% 19% 80,000 80,000 Total Revenues 2,422,619 2,491,943 69,324 17% 17% 14,535,711 14,535,911 200 TOTAL RESOURCES 17,922,619 18,321,831 399,213 92% 102% 30,035,711 30,365,799 330,088 REQUIREMENTS 1 Exp. %1 Expenditures: Personal Services 21.677 20,771 906 17% 16% 130,062 130,062 Materials & ServiCes Claims Paid-MedicallRx 2,079,047 1,610,216 468,832 17% 13% a) 12,474,284 9,303,468 3,170,817 Claims Paid-DentalNision 310,662 214,362 96,300 17% 12% a) 1,863,974 1,238,538 625,435 Refunds 0 (1,685) 1,685 17% nla (1.685) 1,685 Insurance Expense 58,333 57,600 733 17% 16% 350,000 350,000 State Assessments 25.000 70,788 (45.788) 17% 47% 150,000 150,000 Administration Fee 53,333 52,281 1,053 17% 16% 320,000 320,000 PPO Fee 8,333 7,886 448 17% 16% 50,000 50,000 Health Impact 9,167 8,623 543 17% 16% 55,000 55,000 Other 27,053 41,065 !14,012~ 17% 25% 162,318 162,318 Total HBT • Dept 31 2,592,606 2,081,907 510,700 13% 15,555,638 11,757,701 3,797,937 Deschutes On-site Clinic Healthstat 159,533 58,129 101,405 17% 6% 957,200 957,200 Medications/Drugs 54,167 1,422 52,745 17% 0% 325,000 325,000 Equipment 667 667 17% 0% 4,000 4,000 Miscellaneous 1,408 1,332 77 17% 16% 8,450 8,450 Total DOC Capital Outlay Contingency 215,775 33 2,197,537 60,882 164,893 33 2,197,537 17% 17% nla nla 1,294,650 200 13,185,223 1,294.650 - 200 13,185.223 TOTAL REQUIREMENTS 5,005,952 2,142,789 2,863,163 17% 7% 30,035,711 13.052,351 16,983,360 NET (Resources -RequIrements) 12.916,667 16,179.042 3.262,376 17.313,448 17.313,448 a) Projection based on annualizing 9 weeks of claims paid. YTD actual is $202,544 per week. 9/1312011 Deschutes County -Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Two Months Ended August 31,2011 YearEnd Budget Projection Variance I RESOURCES: Beg. Net Working Capital $ 75,000 $ (40,601) $ (115,601) 100% -54% $ 75,000 $ (40,601) $ (115,601) Receipts: Special Events Revenues 100,833 188,444 87,611 17% 31% 605,000 583,444 (21,556) Interest 250 60 (190) 17% 4% 1,500 1,310 (190) Storage 9,667 (9,667) 17% 0% 58,000 58,000 Camping at F & E 1,000 (1,000) 17% 0% 6,000 6,000 Horse Stall Rental 5,000 165 (4,835) 17% 1% 30,000 30,165 165 Concession % -Food 36,667 33,338 (3,329) 17% 15% 220,000 214,338 (5,662) Rights (Signage, etc.) 18,667 16,000 (2,667) 17% 14% 112,000 122,000 10,000 Interfund Contract 7,833 (7,833) 17% 0% 47,000 47,001 1 Miscellaneous 1,135 1,917 783 17% n/a 6,807 7,541 734 Total Receipts 181,051 239,924 58,873 17% 22% 1,086,307 1,069,799 (16,508) Transfers In General Fund (001) 28,333 28,334 17% 17% 170,000 170,000 Room Tax (160) 4,291 4,290 17% 17% 25,744 25,744 Welcome Center (170) 13,800 13,800 17% 17% 82,800 82,800 Annual County Fair (619) 36,667 (36,667) 17% 0% 220,000 220,000 Reserve Fund (617) 17 (17) 17% 0% 100 ~100~ Total Transfers In 83,107 46,424 (36,683) 498,644 498,544 (100) TOTAL RESOURCES 339,159 245,747 (93,411) 17% 15% 1,659,951 1,527,742 (132,209) REQUIREMENTS: Expenditures: Personal Services 144,336 144,397 (61 ) 17% 17% 866,018 866,095 (77) Materials and Services 80,177 95,755 (15,578) 17% 20% 481,060 510,906 (29,846) Debt Service 19,178 19,178 17% 0% 115,068 115,068 Capital Outlay 17 17 17% 0% 100 100 Total Expenditures 243,708 240,152 3,556 1,462,246 1,492,069 (29,823) Transfers Out· Reserve Fund 1,667 1,667 17% 0% 10,000 10,000 Contingency 31,284 31,284 17% n/a 187,705 187,705 TOTAL REQUIREMENTS 276,659 240,152 36,507 17% 140/0 1,659,951 1,502,069 157,882 NET (Resources -Requirements) 62,500 5,595 (56,905) 25,673 25,673 rJ'J u ~ ~ 0 ~ ~ ~ ~ < ~ ~ ~ < U rJJ ::1 0.. E ell U ».....c: ::1 0 u ...c: t:: 0 Z • c:c:- E Il.)...c: Il.)-...c:..... Il.) CO • RESOURCES: Loan Proceeds, net of issuance costs Resources from Fund 140 Resources from Fund 142 Transfer in Interest Revenue Total Resources EXPENDITURES: Materials & Services Arch itecture/Design Engineering Planning Interfund Charges Fees, Permits & SDCs Utilities Travel -Meals/Mileage Reimb Total Materials & Services Deschutes County North County Services Building Inception through August 31,2011 ACTUAL Received and Expended Encumbrances & Commitments Project to Date 1,402,013 25,000 600,000 446 2,027,459 1,402,013 25,000 600,000 446 2,027,459 25,000 25,000 50,000 277 442 25,719 25,000 277 442 50,719 Project Budget 2,000,000 a) 1,402,013 b) 25,000 600,000 4,027,013 b) 100,000 10,000 1,663 60,000 2,000 173,663 PROJECTION Projected 2,000,000 1,402,013 25,000 600,000 446 4,027,459 100,000 10,000 1,663 60,000 2,000 173,663 I Variance 446 446 Capital Outlay Land and Building Remodel 1,402,013 230 1,402,013 230 a) 1,402,013 2,451,337 1,402,013 2,451,337 Total Capital Outlay 1,402,243 1,402,243 3,853,350 3,853,350 Contingency Total Expenditures 1,427,962 25,000 1,452,962 4,027,013 4,027,013 Net 599,498 (25,000) 574,498 446 446- 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) Deschutes County Bethlehem Inn (Fund 128) Two Months Ended August 31, 2011 Bud~et Actual I Variance !FY% I COII.%! Bud~et I Projection IVariance 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 466,971 (466,971) 17% 0% 2,801,827 . (2,801,827) Lease Payments 4,068 6,102 2,034 17% 25% * 24,408 24,408 1 Total Revenues 471,039 6,102 (464,937) 17% 0% 2,826,235 24,408 (2,801,827)I I TOTAL RESOURCES (2,240,196) (2,710,479) (470,283) 17% ·2357% 115,000 (2,692,173) (2,807,173) REQUIREMENTS: Exp. %1 Expenditures Debt Service: I Interest Expense 2,500 2,617 (117) 17% 17% a) 15,000 15,000 Interest Payment 16,667 16,667 17% 0% 100,000 100,000 I TOTAL REQUIREMENTS 19,167 2,617 16,549 17% 2% 115,000 15,000 100,000 NET (Resources -Requirements) (2,259,3631 (2,713,096) {453,734~ b) (2,707,173) (2,707,173) • September lease payment received August 30. a) Interest on August 2011 negative cash balance: $1,293.38 b) Inception through August 31, 2011 Revenues -Lease Payments $ 30,510 Expenditures: Land/Building (Amertitie) -July 2007 2,241,313 Hickman Williams 17,578 City of Bend -May 2008 250,000 KN EXCO 5,289 Kleinfelder 3,732 Total expended on facility 2,517,913 Interest on Negative Cash Balance 225,694 Total expended 2,743,606 Net $ ~2,713,096) Deschutes County· Solid Waste Area A Closure and Cell 5 Construction As of August 31,2011 "AreaA" Landfill Closure Fund 611 p:ngineering Contract I G. Friesen Associates, Inc. Original Contract 241,869.00 Change Orders: Change Order #1 (Note a) DEQ requirement for gas detection 19,656.00 Change Order #2 LFG well field management SOPs 21,500.00 Change Order #3 Storm sewer realignment, drainage, Area A thickness 34,316.00 Total Contract 317,341.00 Amount Paid Through June 30, 2011 (Final payment made December 2010) 317,341.00 Balance Due Fonstruction Contract I M A DeAtley Construction Inc Original Contract· @ estimated cu.yd. 2,097,140.50 Amended Contract· @ revised cu.yd. and damages 2,284,885.13 Change Orders: Change Order #1 Meet CEC requirements, increase to electrical panel, Change Order #2 Storm sewer realignment due to refuse encountered 14,302.54 Change Order #3 Revise valve vaults for improved efficiencies 24,885.69 Change Order #4 Add'i cover material from what will be Cell 6 32,690.70 Change Order #5 Environmental controls building, pump station bulkheads Change Order #6 Adjustment to pipe alignment to increase slope 1,332.00 Change Order #7 (not likely to occur) Change Order #8 Additional rock to be set aside for future needs Change Order #9 Manhole covers below grade to meet Road Dept requirements 2,486.98 Change Order #10 Modular Block Wall instead of MSE Wall Change Order #11 Upgrade of cables (pump and leachate) Change Order #12 Leachate Line connection from Cell 5 to Cells 3 & 4 Change Order #13 Additional cover material due to settling 55,853.20 Change Order #14 Well modification, flow meter less LFG vaults 5,938.50 Damages Total Contract 2,422,374.74 Amount Paid Through June 30, 2011 2,343,073.99 July 1, 2011 through August 31, 2011 Balance Due 79,300.75 Total of Engineering and Construction Contracts: Original Contracts 2,526,754.13 Change Orders and Damages 212,961.61 Total Contract 2,739,715.74 Amount Paid Through August 31,2011 2,660,414.99 Balance Due 79,300.75 "Cell 5" SW Capital Projects Fund 613 Total 182,516.00 424,385.00 19,656.00 21,500.00 33,431.00 67,747.00 215,947.00 533,288.00 215,947.00 533,288.00 3,290,779.98 5,387,920.48 3,552,521.82 5,837,406.94 45,095.00 45,095.00 14,302.54 24,885.69 32,690.70 148,958.89 148,958.89 1,332.00 204,700.00 204,700.00 2,486.98 5,167.76 5,167.76 2,200.00 2,200.00 6,354.75 6,354.75 55,853.20 5,938.50 ~35,000.00) (35,000.00) 3,929,998.22 6,352,372.95 3,798,516.46 6,141,590.45 131,481.76 210,782.50 3,735,037.82 6,261,791.94 410,907.40 623,869.01 4,145,945.22 6,885,660.95 4,014,463.46 6,674,878.45 131,481.76 210,782.50 - ------------------- ___ Deschutes County General Support Services -BOCC Conference/Seminar, EducationlTraining and Travel Expenditures and BOCC -County College Expenditures FY 2012 ----.--.....-..------------. -.---;-----,-------r----i ~.Q_CC Confere'!~~__~!!_Ci~~~J Jul I Aug IYTD Total Tammy Baney _ __ Conf/S_~m & ~duc~~ain~rl.9. __ ... 665 665 Travel Meals Accommodations 996 996 -c----·-·-------------. ----..------------------. Airfare ~-----------------.------------------------_._-----_._. _ Mileage reimbursement Ground Transport/Parking r---=--------=-.=----------~-_!_~~I._B_a_ne_y__-_--=-:==--:::.:::~:--_:.-.:__.1.,6.6.1_____.1i1,6.6.1~ Alan Unger ______ __ Conf/Sem & EduclTrainin'g 665 665----=---.._------------------_._--.-._--_ .._-------..__. Travel Meals --- ---------------_... --------_. -.----~----------- Accommodations -- 1,131 -. 1,131------_.------------.---_._._-_.... _..._----------- ~~re - - Mileage reimbursement. Ground Transport/Parking ------------------_.. ---. ____~~l!r1..g~______ ___ _ 1,796 1,796 Iony DeBone ____________________________ _ __ Conf/Sem ~~sl':l~~~C!ining__ 665 665 Travel Meals Accommodations 908 908 ---------~--.--------_._ Airfare Mileage reimbursement 300 300 Ground Transport 54 54 .__._----_.--._--==--------=....:... ----=....:.. Total Other 1,573 354 1,927::=-..:=--=-===._---_._----_._._--::------:._-:.--:.-::.----_....... Iotal -BO_CC ,oepartm~"!!____________.___ .___.___._.______ _~onflS~1!I ~EduclT~Jrlin.£L___ _____ 1,33Q... __ 1,995 Travel Meals Accommodations 1,904 3,034 -_._-----------------------"---------------------------------- Airfare ~ _Mileage Reim}~ursem~_rlL___________ _ _ _ _ 300______ 300. Ground Transport 54 54 ----------------_._-- __Total-BOCC Department . ____3,234..___ 35~ ___5,3~ _~£Y-26-12BUdget-.-------·--------'~.~.~_= __-~-~~=~=__f4,750~ - . .---. ---.--.-----------------cc- Percent of FY 2012 Budget Expended 36,5%r------.---. . .--..-.-.-----.--------.------- _BO_C~ County College ________._________________ Public Information --------------_.. __.------_. __ . Office/Copier S...u2plies __________.____ ._. ______.. ________.__ ... _______ Meeting Supplies ----_._--_. _._-_..__._--------------== ---==----'--==== --------------...------------=-=,..-.--=== 9/2/2011