The URL can be used to link to this page

Home My WebLink AboutTax-Finance UpdateMonthly Meeting with Board of Commissioners Finance Director/Treasurer AGE NDA June 27, 2011 (1) Monthly Investment Report (2) May 2011 Financials Memorandum Date: June 10, 2011 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find May 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 Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY % Coll. % Revised Year End $ Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 8,300,000 $ 9,677,699 $ 1,377,699 100% 117% $8,300,000 $9,677,699 $ 1,377,699 Revenues Property Taxes 18,852,167 21,251,135 2,398,968 92% 103% 20,566,000 21,251,135 685,135 Gen. Rev. - excl. Taxes 2,197,377 2,371,959 174,582 92% 99% a) 2,397,138 2,497,138 100,000 Assessor 729,383 799,720 70,337 92% 101% b) 795,690 799,720 4,030 County Clerk 1,118,988 1,315,682 196,694 92% 108% 1,220,714 1,380,344 159,630 BOPTA 11,365 13,077 1,712 92% 105% b) 12,398 13,077 679 District Attorney 287,925 188,763 (99,162) 92% 60% 314,100 270,300 (43,800) Finance/Tax 165,183 198,101 32,918 92% 110% b) 180,200 200,200 20,000 Veterans 62,211 50,658 (11,553) 92% 75% 67,866 67,866 Property Management 83,538 88,635 5,097 92% 97% 91,132 91,132 Grant Projects 1,833 1,833 0 92% 92% 2,000 2,000 Total Revenues 23,509,970 26,279,563 2,769,593 92% 102% 25,647,238 26,572,912 925,674 TOTAL RESOURCES 31,809,970 35,957,263 4,147,293 92% 106% 33,947,238 36,250,612 2,303,374 REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non -Departmental Contingency Exp. % 3,100,367 2,975,859 124,508 92% 88% 3,382,219 3,287,219 95,000 1,360,450 1,219,183 141,267 92% 82% 1,484,127 1,381,923 102,204 69,119 62,683 6,436 92% 83% 75,403 75,403 4,475,283 4,328,298 146,985 92% 89% 4,882,127 4,778,777 103,350 776,334 761,918 14,416 92% 90% 846,910 833,910 13,000 240,347 237,657 2,690 92% 91% 262,197 262,197 232,125 233,274 (1,149) 92% 92% 253,227 253,227 102,853 105,455 (2,602) 92% 94% 112,203 112,203 2,034,438 1,236,445 797,993 92% 56% 2,219,387 2,119,387 100,000 3,729,251 3,729,251 92% n/a 4,068,274 4,068,274 16,120,567 11,160,774 4,959,793 92% 63% 17,586,074 13,104,246 4,481,828 Transfers Out 14,425,734 14,446,413 (20,679) 92% 92% c) 15,737,164 15,737,164 TOTAL REQUIREMENTS 30,546,301 25,607,186 4,939,115 92% 77% 33,323,238 28,841,410 4,481,828 NET (Resources - Requirements) 1,263,669 10,350,077 9,086,408 d) 624,000 7,409,202 6,785,202 Beginning NWC per Approved Budget 7,300,000 a) YTD Actual includes annual payments: Federal in lieu of taxes - $471,913 and State tax on electric co-ops - $464,452. Justice Courts fines projected to be $90,000 more than budgeted, Interest projected to be $10,000 more that budgeted b) YTD Actual includes four quarterly payments of the A&T grant. c) Revised Budget and Year End Projection include $2,763,000 transfer of "one time resources". d) Appropriation transferred to Fund 575 - $610,000, to Fund 601 - $14,000 COMM JUSTICE -JUVENILE Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY % Coli. % Revised Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 987,000 $ 1,039,997 $ 52,997 100% 105% $ 987,000 $ 1,039,997 $ 52,997 Revenues Federal Grants 14,233 12,135 (2,098) 92% 78% a) 15,527 15,527 SB #1065 -Court Assess. 55,000 48,594 (6,406) 92% 81% b) 60,000 51,500 (8,500) Discovery Fee 14,667 11,083 (3,584) 92% 69% b) 16,000 12,500 (3,500) Food Subsidy 34,833 22,813 (12,020) 92% 60% b) 38,000 26,770 (11,230) OYA Basic & Diversion 311,672 182,135 (129,537) 92% 54% c) 340,006 266,358 (73,648) Inmate/Prisoner Housing 91,667 58,350 (33,317) 92% 58% d) 100,000 62,850 (37,150) Inmate Commissary Fees 92 144 52 92% 144% 100 170 70 Contract Payments 81,116 77,892 (3,224) 92% 88% 88,490 86,000 (2,490) Miscellaneous 275 70 (205) 92% 23% 300 100 (200) MIP Diversion Fees 917 245 (672) 92% 25% b) 1,000 267 (733) Interest on Investments 15,583 7,432 (8,151) 92% 44% 17,000 8,025 (8,975) Leases 2,200 2,200 92% 92% 2,400 2,400 Grants - Private 458 1,397 939 92% 279% 500 1,500 1,000 Behavioral Health 5,500 3,319 (2,181) 92% 55% b) 6,000 3,625 (2,375) CCF Interfund Grant 55,454 72,375 16,921 92% 120% e) 60,495 93,000 32,505 Gen Fund Grant -Crime Prev. 18,333 15,000 (3,333) 92% 75% 20,000 20,000 Total Revenues 702,000 515,184 (186,816) 92% 67% 765,818 650,592 (115,226) Transfers In -General Fund 5,081,253 5,081,253 - 92% 92% 5,543,186 5,543,186 TOTAL RESOURCES 6,770,253 6,636,434 (133,819) 92% 91% 7,296,004 7,233,775 (62,229) REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services 2,716,960 2,519,436 197,524 92% 85% f) 2,963,956 2,742,972 220,984 Materials and Services 1,099,896 981,448 118,448 92% 82% g) 1,199,886 1,070,670 129,216 Capital Outlay 92 92 92% 0% 100 100 Juvenile Resource Center Personal Services 2,122,179 1,968,728 153,451 92% 85% h) 2,315,104 2,140,222 174,882 Materials and Services 160,870 157,587 3,283 92% 90% 175,494 178,537 (3,043) Contingency 588,009 - 588,009 92% n/a 641,464 - 641,464 Exp. % TOTAL REQUIREMENTS 6,688,006 5,627,199 1,060,807 92% 77% 7,296,004 6,132,401 1,163,603 NET (Resources - Requirements) 82,247 1,009,235 926,988 - 1,101,374 1,101,374 Beginning NWC per Approved Budget 1,101,374 a) Fourth quarter Federal Grant reimbursement of $3,000 is expected in June b) Revenues trending less than projected due to reduction in use of services and lower juvenile populations c) OYA monies collected in Nov, Feb, May, and June - New reduction due to under -utilization of Maplestar treatment foster care - (population of kids in Maplestar less than anticipated in the original budget). Approximately $75,000 payment anticipated in June d) Revenue is generated when non -Deschutes juveniles utilize facility - less utilization than anticipated to date e) Additional funding from CCF allocated for Juvenile programs f) Personnel savings due to approximately 3.00 FTE unfilled g) DHS/BRS match payments and Maplestar contract payments are Tess than originally budgeted due to reduction in youth using the program h) Personnel savings due to less on-call and overtime for the detention facility 20,927.002 16,477,215 (4,449,787) 12,527,111 10,424,475 (2,102,636) SHERIFF - Fund 255 Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY Coll. % RESOURCES: Beg. Net Working Capital $ Revenues $ Law Enf Dist Countywide Law Enf Dist Rural Total Revenues TOTAL RESOURCES 100% nla Revised Year End Budget Projection Variance $ $ - $ 92% 72% 22,829,457 18,227,066 (4,602,391) 92% 76% 13,665,939 11,525,629 J2,140,310) 33,454,113 26,901,689 (6,552,424) 92% 74% 36,495,396 29,752,695 (6,742,701) 33,454,113 26,901,689 (6,552,424) 92% 74% 36,495,396 29,752,695 (6,742,701) REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 2,783,963 Civil 753,900 Automotive/Communications 1,515,283 Investigations/Evidence 1,513,226 Patrol/Civil/Comm Supp 7,347,680 Records 605,354 Adult Jail 9,033,625 Court Security 257,447 Emergency Services 159,904 Special Services Division 1,190,387 Regional Work Center 2,651,222 Training Division 302,500 Other Law Enforcement Svcs 547,174 Non -Departmental 259,433 Contingency 4,349,681 Transfer Out - Jail Remodel 91,667 Transfers Out- D/S Fund 91,667 2,769,121 715,911 1,320,837 1,354,930 7,087,465 564,503 7,987,944 247,167 156,282 1,012,042 2,431,877 231,857 545,655 276,100 100,000 60,539 14,842 37,989 194,446 158,296 260,215 40,851 1,045,681 10,280 3,622 178,345 219,345 70,643 1,519 (16,667) 4,349,681 (8,333) 31,128 TOTAL REQUIREMENTS 33,454,113 26,862,230 NET (Resources - Requirements) Beginning NWC per Approved Budget 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% Exp. % 91% a) 87% b) 80% c) 82% b) 88% b) b) 81% d) 88% 90% 78% 84% e) 70% f) 91% 98% n/a n/a 61% 85% 3,037,051 822,436 1,653,036 1,650,792 8,015,651 660,386 9,854,864 280,851 174,441 1,298,604 2,892,242 330,000 596,917 283,018 4,745,107 100,000 100,000 2,979,177 775,971 1,461,292 1,563,236 7,739,326 637,571 8,867,554 267,835 167,372 1,233,596 2,700,917 284,916 590,914 283,018 100,000 100,000 57,874 46,465 191,744 87,556 276,325 22,815 987,310 13,016 7,069 65,008 191,325 45,084 6,003 4,745,107 6,591,883 92% 74% 36,495,396 29,752,695 6,742,701 a) Less than planned M&S expenses for the year b) Delay in filling open positions will result in lower personnel expenditures for FY 2011 c) Payments for grant funded consulting contract will slip into FY 2012 d) Unfilled budgeted positions and no planned jail bed rental. In addition, the $350,000 for JMS software will be spent in FY 2012 e) Unfilled budgeted positions and lower material and service expenditures projected for FY 2011 f) Personnel expenses will be lower than planned due to employee transfers Total Requirements 20,927,002 10,437,953 4,489,048 RESOURCES: Beg. Net Working Capital 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 Sale of Reportable Assets Total Revenues TOTAL RESOURCES REQUIREMENTS: Department Sheriffs Services Civil Auto/Comm Adult Jail Court Security Emer Svcs Special Services Work Center Training Other (CODE, Forensic) Internal Services Transfer to Debt Service Transfer to Jail Remodel Transfer for Reserve Fund Contingency Fund 701 LED -Countywide Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY % Coll. % $4,722,862 13,615,795 588,500 32,083 44,435 4,583 1,810,105 4,583 87,083 137,500 $ 5,609,156 14,926,526 748,759 48,563 72,573 3,321 1,854,463 86,950 4,994 154,996 3,667 487 4,185 66,004 46,920 3,800 6,000 6,399 11,350 13,142 3,590 235,646 46,776 1,808 2,500 200 1,257 44,000 22,917 5,500 4,583 4,583 11,000 917 146,667 25,972 3,239 $ 886,294 1,310,731 160,259 16,480 28,138 (1,262) 44,358 (4,583) (133) 4,994 17,496 (3,180) 4,185 22,004 24,003 (1,700) 1,417 1,816 11,350 2,142 2,673 88,979 20,804 (1,431) 2,500 200 1,257 16, 597, 712 18,356,250 21,320,574 23,965,406 2,633,629 753,900 545,502 9,033,625 257,447 159,904 961,833 2,651,222 184,525 547,174 38,126 91,667 91,667 91,667 2,885,116 2,619,588 715,911 475,501 7,987,944 247,167 156,282 817,730 2,431,877 141,433 545,655 138,326 60,539 100,000 100% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 1,758,538 92% 2,644,832 92% 14,041 92% 37,989 92% 70,001 92% 1,045,681 92% 10,280 92% 3,622 92% 144,103 92% 219,345 92% 43,092 92% 1,519 92% (100,200) 92% 31,128 92% (8,333) 92% 91,667 92% 2,885,116 92% Net 393,572 7,527,453 7,133,881 Beginning NWC per Approved Budget a) Timing of reimbursements for the Emergency Planning Grant b) Funding reduction from Dept of Corrections c) Higher than planned inmate telephone use and commissary purchases d) Work Crew revenue from USFS was not planned e) Unplanned revenue for the "Children of Incarcerated Parents" program f) Revenue for concealed weapons permits and civil papers will exceed budget Budget _ Year End Projection Variance , 119% $ 4,722,862 $5,609,156 $ 886,294 100% 14,853,594 14,926,526 72,932 117% 642,000 748,759 106,759 139% 35,000 48,563 13,563 150% a) 48,475 72,573 24,098 66% 5,000 5,000 - 94%b) 1,974,660 1,854,463 (120,197) 0% 5,000 5,000 - 92% 95,000 95,000 - n/a 4,994 4,994 103% 150,000 154,996 4,996 12% 4,000 4,000 - n/a 4,185 4,185 138% c) 48,000 68,000 20,000 188% d) 25,000 50,000 25,000 63% 6,000 6,000 120% 5,000 6,000 1,000 128% 5,000 7,000 2,000 n/a e) 15,000 15,000 110% 12,000 18,000 6,000 359% 1,000 5,000 4,000 147% f) 160,000 250,000 90,000 165% 28,333 53,075 24,742 51% 3,533 3,533 n/a 2,500 2,500 n/a 200 200 n/a 1,257 1,257 101% 18,106, 595 18,414,664 308,069 105% 22,829,457 24,023,820 1,194,363 Exp. % 91% 87% 80% 81% 88% 90% 78% 84% 70% 91% 333% 61% 100% 0% 0% 2,873,050 822,436 595,093 9,854,864 280,851 174,441 1,049,272 2,892,242 201,300 596,917 41,592 100,000 100,000 100,000 3,147,399 2,818,301 54,749 775,971 46,465 526,065 69,028 8,867,554 987,310 267,835 13,016 167,372 7,069 996,746 52,526 2,700,917 191,325 173,799 27,501 590,914 6,003 41,592 - 100,000 100,000 100,000 - 3,147,399 72% 22,829,457 18,227,066 4,602,391 5,796,754 5,796,754 5,108,671 Fund 702 LED Rural Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY Coll. % RESOURCES: Beg. Net Working Capital $ 1,905,939 $ 2,498,487 $ 592,548 100% 1311/4 $ 1,905,939 $ 2,498,487 $ 592,548 Revenues Tax Revenues - Current 6,882,559 7,516,436 633,877 92% 100% 7,508,247 7,516,436 8,189 Tax Revenues - Prior 287,833 371,944 84,111 92% 118% 314,000 371,944 57,944 Federal Grants 1,833 13,326 11,493 92% 666°1°a) 2,000 13,326 11,326 Federal Grants-BLM 9,597 9,597 92% n/a - 10,000 10,000 US Forest Service 70,125 64,125 (6,000) 92% 84% 76,500 78,750 2,250 State Grant 171,997 89,238 (82,759) 92% 48% 187,633 187,633 SB #1065 Court Assessmi 61,417 48,594 (12,823) 92% 73% 67,000 50,000 (17,000) Marine Board License Fee 130,564 49,842 (80,722) 92% 35% bj 142,433 187,433 45,000 Des Cty General Fund Gr 643,828 - (643,828) 92% 0% c) 702,358 702,358 Des Cty Transient Room 1 1,785,339 1,785,339 - 92% 92% 1,947,642 1,947,642 City of Sisters 396,600 396,600 - 92% 92% 432,655 432,655 Des Cty Tax/Fin Contract 917 - (917) 92% 0% 1,000 1,000 Des Cty CDD Contract 49,836 49,836 - 92% 92% 54,366 54,366 Des Cty Solid Waste Cont 49,836 49,836 - 92% 92% 54,366 54,366 Des Cty Clerk/Election 1,833 1,249 (584) 92% 62% 2,000 2,000 School Districts 91,667 32,725 (58,942) 92% 33%d) 100,000 50,000 (50,000) Claims Reimbursement - 8,472 8,472 92% n/a 8,472 8,472 Security & Traffic Reimb 11,917 1,081 (10,836) 92% 8% 13,000 13,000 Seat Belt Program 5,500 6,275 775 92% 105% 6,000 6,275 275 Miscellaneous 9,167 9,419 252 92% 94% 10,000 10,000 Restitution 458 1,058 600 92% 212% 500 1,500 1,000 Sheriff Fees 9,167 9,160 (7) 92% 92% 10,000 10,000 Court Fines & Fees 77,917 121,631 43,714 92% 143%e) 85,000 132,000 47,000 Impound Fees 13,750 5,800 (7,950) 92% 39% 15,000 15,000 Restitution - Street Crimes 458 - (458) 92% 0% 500 500 Interest 9,167 18,860 9,693 92% 189% 10,000 20,000 10,000 Interest on Unsegregated 1,650 909 (741) 92% 51% 1,800 1,800 Donations - 12,200 12,200 92% n/a f) - 12,250 12,250 Sale of Reportable Assets 9,167 32,762 23,595 92% 328%g) 10,000 32,762 22,762 Sale of Equip & Material 5,500 3,570 (1,930) 92% 60% 6,000 10,000 4,000 Total Revenues 10,780,002 10,709,884 (70,118) 50% 91% 11,760,000 11,933,468 173,468 TOTAL RESOURCES 12,685,941 13,208,371 522,430 50% 97% 13,665,939 14,431,955 766,016 REQUIREMENTS: Department Sheriffs Services Auto/Comm Investigations Patrol Records Special Services Training Internal Services Transfer for Reserve Fund Contingency Total Requirements Net Exp. 150,334 149,533 801 92% 91% 164,001 160,876 3,125 969,781 845,336 124,445 92% 80% 1,057,943 935,227 122,716 1,513,226 1,354,930 158,296 92% 82% 1,650,792 1,563,236 87,556 7,347,680 7,087,465 260,215 92% 88% 8,015,651 7,739,326 276,325 605,354 564,503 40,851 92% 85% 660,386 637,571 22,815 228,554 194,312 34,242 92% 78% 249,332 236,850 12,482 117,975 90,424 27,551 92% 70% 128,700 111,117 17,583 37,974 137,774 - 92% 333% 41,426 41,426 91,667 - 91,667 92% 0% 100,000 100,000 1,464,566 1,464,566 92% 0% 1,597,708 - 1,597,708 12,527,111 10,424,277 2,102,834 76% 13,665,939 11,525,629 2,140,310 158,830 2,784,095 2,625,265 2,906,326 2,906,326 Beginning NWC per Approved Budget 2,936,523 a) Detective overtime reimbursements from HIDTA b) Contract increased for purchase of new boat. Payments will be received in Qtr 4 c) Grant will be received in June 2011 d) Less than planned revenue due to lower billing rates and hours worked e) Revenue from traffic tines will exceed budget f) Animal Rescue Facility donations g) Proceeds from sale of used patrol vehicles were higher than estimated Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 1,905,939 $ 2,498,487 $ 592,548 100% 1311/4 $ 1,905,939 $ 2,498,487 $ 592,548 Revenues Tax Revenues - Current 6,882,559 7,516,436 633,877 92% 100% 7,508,247 7,516,436 8,189 Tax Revenues - Prior 287,833 371,944 84,111 92% 118% 314,000 371,944 57,944 Federal Grants 1,833 13,326 11,493 92% 666°1°a) 2,000 13,326 11,326 Federal Grants-BLM 9,597 9,597 92% n/a - 10,000 10,000 US Forest Service 70,125 64,125 (6,000) 92% 84% 76,500 78,750 2,250 State Grant 171,997 89,238 (82,759) 92% 48% 187,633 187,633 SB #1065 Court Assessmi 61,417 48,594 (12,823) 92% 73% 67,000 50,000 (17,000) Marine Board License Fee 130,564 49,842 (80,722) 92% 35% bj 142,433 187,433 45,000 Des Cty General Fund Gr 643,828 - (643,828) 92% 0% c) 702,358 702,358 Des Cty Transient Room 1 1,785,339 1,785,339 - 92% 92% 1,947,642 1,947,642 City of Sisters 396,600 396,600 - 92% 92% 432,655 432,655 Des Cty Tax/Fin Contract 917 - (917) 92% 0% 1,000 1,000 Des Cty CDD Contract 49,836 49,836 - 92% 92% 54,366 54,366 Des Cty Solid Waste Cont 49,836 49,836 - 92% 92% 54,366 54,366 Des Cty Clerk/Election 1,833 1,249 (584) 92% 62% 2,000 2,000 School Districts 91,667 32,725 (58,942) 92% 33%d) 100,000 50,000 (50,000) Claims Reimbursement - 8,472 8,472 92% n/a 8,472 8,472 Security & Traffic Reimb 11,917 1,081 (10,836) 92% 8% 13,000 13,000 Seat Belt Program 5,500 6,275 775 92% 105% 6,000 6,275 275 Miscellaneous 9,167 9,419 252 92% 94% 10,000 10,000 Restitution 458 1,058 600 92% 212% 500 1,500 1,000 Sheriff Fees 9,167 9,160 (7) 92% 92% 10,000 10,000 Court Fines & Fees 77,917 121,631 43,714 92% 143%e) 85,000 132,000 47,000 Impound Fees 13,750 5,800 (7,950) 92% 39% 15,000 15,000 Restitution - Street Crimes 458 - (458) 92% 0% 500 500 Interest 9,167 18,860 9,693 92% 189% 10,000 20,000 10,000 Interest on Unsegregated 1,650 909 (741) 92% 51% 1,800 1,800 Donations - 12,200 12,200 92% n/a f) - 12,250 12,250 Sale of Reportable Assets 9,167 32,762 23,595 92% 328%g) 10,000 32,762 22,762 Sale of Equip & Material 5,500 3,570 (1,930) 92% 60% 6,000 10,000 4,000 Total Revenues 10,780,002 10,709,884 (70,118) 50% 91% 11,760,000 11,933,468 173,468 TOTAL RESOURCES 12,685,941 13,208,371 522,430 50% 97% 13,665,939 14,431,955 766,016 REQUIREMENTS: Department Sheriffs Services Auto/Comm Investigations Patrol Records Special Services Training Internal Services Transfer for Reserve Fund Contingency Total Requirements Net Exp. 150,334 149,533 801 92% 91% 164,001 160,876 3,125 969,781 845,336 124,445 92% 80% 1,057,943 935,227 122,716 1,513,226 1,354,930 158,296 92% 82% 1,650,792 1,563,236 87,556 7,347,680 7,087,465 260,215 92% 88% 8,015,651 7,739,326 276,325 605,354 564,503 40,851 92% 85% 660,386 637,571 22,815 228,554 194,312 34,242 92% 78% 249,332 236,850 12,482 117,975 90,424 27,551 92% 70% 128,700 111,117 17,583 37,974 137,774 - 92% 333% 41,426 41,426 91,667 - 91,667 92% 0% 100,000 100,000 1,464,566 1,464,566 92% 0% 1,597,708 - 1,597,708 12,527,111 10,424,277 2,102,834 76% 13,665,939 11,525,629 2,140,310 158,830 2,784,095 2,625,265 2,906,326 2,906,326 Beginning NWC per Approved Budget 2,936,523 a) Detective overtime reimbursements from HIDTA b) Contract increased for purchase of new boat. Payments will be received in Qtr 4 c) Grant will be received in June 2011 d) Less than planned revenue due to lower billing rates and hours worked e) Revenue from traffic tines will exceed budget f) Animal Rescue Facility donations g) Proceeds from sale of used patrol vehicles were higher than estimated PUBLIC HEALTH Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Revised Year to Date Budget Budget Actual Variance FY % Coll. % Revised Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 1,100,000 $ 1,615,306 $ 515,306 100% 147% $1,100,000 $1,615,306 $ 515,306 Revenues Medicare Reimbursement 7,333 147 (7,186) 92% 2% 8,000 200 (7,800) State Grant 2,303,562 2,427,905 124,343 92% 97% a) 2,512,977 2,613,704 100,727 Child Dev & Rehab Center 28,196 23,069 (5,127) 92% 75% 30,759 30,759 State Miscellaneous 201,571 216,906 15,335 92% 99% 219,896 269,334 49,438 OMAP 437,983 578,680 140,697 92% 121% 477,800 618,680 140,880 Title 19 927 927 92% n/a 1,000 1,000 Family Planning Exp Proj 453,750 434,612 (19,138) 92% 88% 495,000 520,000 25,000 Local Grants 59,583 103,769 44,186 92% 160% b) 65,000 113,773 48,773 Water Program -Base Fee 38,500 28,158 (10,342) 92% 67% 42,000 42,000 Water Program -Field Work 51,166 49,840 (1,326) 92% 89% 55,817 55,817 H2O Sys Insp-Priv Wells 183 (183) 92% 0% 200 200 Miscellaneous 386 386 92% n/a 400 400 Patient Insurance Fees 174,405 121,597 (52,808) 92% 64% c) 190,260 135,000 (55,260) Health Dept/Patient Fees 136,560 104,330 (32,230) 92% 70% c) 148,975 114,330 (34,645) Vital Records -Birth 33,000 30,395 (2,605) 92% 84% 36,000 31,000 (5,000) Vital Records -Death 89,833 96,485 6,652 92% 98% 98,000 97,000 (1,000) Environmental Health 630,071 704,797 74,726 92% 103% 687,350 730,000 42,650 Interest on Investments 15,492 10,337 (5,155) 92% 61% 16,900 11,200 (5,700) Donations 5,500 32,108 26,608 92% 535% d) 6,000 35,430 29,430 Interfund Contract 173,597 72,661 (100,936) 92% 38% 189,378 162,513 (26,865) Administrative Fee 24,750 24,750 92% 92% 27,000 27,000 Drug Court Byrne 4,157 4,157 92% n/a 4,157 4,157 Total Revenues 4,865,035 5,066,016 200,981 92% 95% 5,307,312 5,613,497 306,185 Transfers In -General Fund Transfers In -PH Res Fund Transfers In -Gen. Fund Other TOTAL RESOURCES 2,124,620 2,124,620 - 92% 92% 2,317,765 2,317,765 61,529 50,342 (11,187) 92% 75% 67,123 67,123 62,161 50,859 (11,302) 92% 75% 67,812 67,812 8,213,345 8,907,143 693,798 92% 101% 8,860,012 9,681,503 821,491 REQUIREMENTS: Expenditures Personal Services 5,369,065 Materials and Services 1,838,271 Capital Outlay 22,917 Transfers Out 137,500 Contingency 753,924 Exp. 5,287,708 81,357 92% 90% 5,857,162 5,790,000 1,785,764 52,507 92% 89% 2,005,387 1,970,226 5,432 17,485 92% 22% 25,000 10,000 112,500 25,000 92% 75% 150,000 150,000 753,924 92% n/a 822,463 67,162 35,161 15,000 822,463 TOTAL REQUIREMENTS 8,121,677 7,191,404 930,273 92% 81% 8,860,012 7,920,226 939,786 NET (Resources - Requirements) 91,668 1,715,739 1,624,071 - 1,761,277 1,761,277 Beginning NWC per Approved Budget 1,596,918 a) State grant through Revision #6, supplemental grant appropriation to be submitted b) Health Matters -local grant for Chronic Care Program is $17,000 & $21,000. Bioterrorism NACCHO grant $10,000 received in July c) In current economic environment, fewer patients with private insurance or self pay d) My Future My Choice donation carry over from FY10, in the amount of $25,880. $3,550 HIV sponsorship donation BEHAVIORAL HEALTH Statement of Financial Operating Data Eleven Months Ended May 31, 2011 RESOURCES: Beg. Net Working Capital $ 2,616,050 $ 2,651,262 $ 35,212 100% 101% $ 2,616,050 $ 2,651,262 $ 35,212 Revenues Marriage Licenses 5,042 4,480 (562) 92% 81% 5,500 5,500 Revised Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 2,616,050 $ 2,651,262 $ 35,212 100% 101% $ 2,616,050 $ 2,651,262 $ 35,212 Revenues Marriage Licenses 5,042 4,480 (562) 92% 81% 5,500 5,500 Revised Year End Budget Projection Variance Divorce Filing Fees 119,167 131,135 11,968 92% 101% 130,000 132,500 2,500 Domestic Partnership Fee 917 45 (872) 92% 5% 1,000 100 (900) Federal Grants 88,888 110,011 21,123 92% 113% a) 96,969 305,342 208,373 State Grants 6,019,944 5,810,286 (209,658) 92% 88% b) 6,567,212 6,293,958 (273,254) State Miscellaneous 135,825 103,549 (32,276) 92% 70% 148,173 148,173 ABHA 98,485 98,485 92% n/a 160,938 160,938 Title 19 275,848 173,917 (101,931) 92% 58% 300,925 200,000 (100,925) Liquor Revenue 96,617 103,544 6,927 92% 98% 105,400 105,400 - School Districts 64,167 81,540 17,373 92% 116% 70,000 82,000 12,000 Miscellaneous 15,492 36,079 20,587 92% 213% 16,900 40,000 23,100 Patient Insurance Fees 141,167 77,242 (63,925) 92% 50% 154,000 79,000 (75,000) Patient Fees 11,917 1,952 (9,965) 92% 15% 13,000 3,000 (10,000) Seizure/Forfeiture - 14,841 14,841 92% n/a 14,841 14,841 Interest on Investments 39,953 20,821 (19,132) 92% 48% 43,585 23,000 (20,585) Rentals 12,008 16,250 4,242 92% 124% 13,100 17,000 3,900 Interfund Contract -Gen. Fund 116,417 118,217 1,800 92% 93% a) 127,000 127,000 Comm. on Children & Fam 22,000 (22,000) 92% 0% c) 24,000 - (24,000) Administrative Fee 3,860,502 3,863,383 2,881 92% 92% 4,211,457 4,211,457 Total Revenues 11,025,871 10,765,777 (260,094) 92% 90% 12,028,221 11,949,209 (79,012) Transfers In -General Fund 1,206,479 1,206,479 - 92% 92% 1,316,158 1,316,158 Transfers In-OHP-CDO 91,665 91,665 92% 92% 100,000 100,000 Transfers In -Acute Care Svcs 335,186 335,186 92% 92% 365,657 365,657 Transfers In-ABHA 612,564 501,189 (111,375) 92% 75% 668,252 668,252 TOTAL RESOURCES 15,887,815 15,551,558 (336,257) 92% 91% 17,094,338 17,050,538 (43,800) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency Exp. % 8,559,057 8,164,569 394,488 92% 87% d) 9,337,153 8,905,000 432,153 4,836,563 3,769,366 1,067,197 92% 71% 5,276,251 4,200,000 1,076,251 702,167 211,400 490,767 92% 28% 766,000 450,000 316,000 144,067 112,500 31,567 92% 72% 157,164 150,000 7,164 1,427,956 1,427,956 92% n/a 1,557,770 1,557,770 TOTAL REQUIREMENTS 15,669,810 12,257,835 3,411,975 92% 72% 17,094,338 13,705,000 3,389,338 NET (Resources - Requirements) 218,005 3,293,723 3,075,718 - 3,345,538 3,345,538 Beginning NWC per Approved Budget 3,268,759 a) Received quarterly, in arrears b) Department of Human Services Grant projected at amended contract amount for FY 11 c) Child and Family prevention program eliminated d) Personnel expenditure projected to be less than budgeted due to unfilled positions RESOURCES: Beg. Net Working Capital Revenues Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Prog Planning -Current Planning -Long Range Total Revenues COMMUNITY DEVELOPMENT Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY % Coll. % $ 686,081 613,031 $ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050) 15,125 14,621 (504) 92% 89% 16,500 15,850 (650) 2,521 4,334 1,813 92% 158% a) 2,750 4,400 1,650 148,242 157,857 9,615 92% 98% 161,718 173,000 11,282 991,116 898,035 (93,081) 92% 83% b) 1,081,217 989,000 (92,217) 244,431 237,528 (6,903) 92% 89% 266,652 264,100 (2,552) 168,667 144,298 (24,369) 92% 78% c) 184,000 201,000 17,000 260,178 245,091 (15,087) 92% 86% 283,830 271,300 (12,530) 712,215 642,102 (70,113) 92% 83% d) 776,962 697,700 (79,262) 324,290 292,244 (32,046) 92% 83% e) 353,771 349,900 (3,871) 2,866,785 2,636,109 (230,676) 92% 84% 3,127,400 2,966,250 (161,150) Trans In -GF 232,272 232,272 - 92% 92% 253,387 253,387 Trans In -GF for Lng Rng Ping 473,000 473,000 - 92% 92% 516,000 516,000 TOTAL RESOURCES 4,258,138 3,954,412 (303,726) 92% 86% 4,582,868 4,348,668 (234,200) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations 1,285,530 Admin -GIS 198,124 Admin -Code Enforcement 169,338 Building Safety 458,636 Electrical 171,972 Contract Services 223,897 Env Health -On Site Pgm 212,672 Planning -Current 632,766 Planning -Long Range 451,391 Transfers Out (DIS Fund) 158,868 Contingency 237,770 Exp. % 1,266,188 19,342 92% 90% 1,402,396 1,372,000 30,396 156,878 41,246 92% 73% f) 216,135 158,312 57,823 169,670 (332) 92% 92% 184,732 182,607 2,125 451,314 7,322 92% 90% g) 500,330 479,817 20,513 164,655 7,317 92% 88% 187,606 179,400 8,206 206,762 17,135 92% 85% g) 244,251 225,066 19,185 197,170 15,502 92% 85% h) 232,006 214,300 17,706 582,343 50,423 92% 84% i) 690,290 630,200 60,090 463,301 (11,910) 92% 94% j) 492,427 523,682 (31,255) 173,310 (14,442) 92% 100% 173,310 173,310 - 237,770 92% n/a 259,385 259,385 TOTAL REQUIREMENTS 4,200,964 3,831,591 369,373 92% 84% 4,582,868 4,138,694 4.44,174 NET (Resources - Requirements) 57,174 122,821 65,647 209,974 209,974 Beginning NWC per Approved Budget 229,822 Revenues Expenditures Net from Operations 2,636,109 3,831,591 (1,195,482) 3,127,400 2,966,250 (161,150) 4,582,868 4,138,694 444,174 (1,455,468) (1,172,444) 283,024 a) Custom GIS work revenue sporadic. Includes webmaster work for Health Dept b) Year end projections reduced as at (east one major project (La Pine Biomass plant) has been delayed, but is expected next year c) City of Redmond receipts lag one month behind d) YTD business volume/revenue projected to be Tess than estimated e) Grant payments received irregularly f) Savings due to resignation of CDD webmaster, who will not be replaced g) Savings due to retirement of Building Inspector in January, who will not be replaced h) Savings due to retirement of EH Director, who will be replaced by an EH Specialist III i) Savings due to lower expenses associated with Hearings Officer, mailings, etc. j) Consultant expenditure higher than budgeted associated with timing of grant revenue received in FY 2010 Year End Budget Projection Variance $ 686,081 613,031 $ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050) 15,125 14,621 (504) 92% 89% 16,500 15,850 (650) 2,521 4,334 1,813 92% 158% a) 2,750 4,400 1,650 148,242 157,857 9,615 92% 98% 161,718 173,000 11,282 991,116 898,035 (93,081) 92% 83% b) 1,081,217 989,000 (92,217) 244,431 237,528 (6,903) 92% 89% 266,652 264,100 (2,552) 168,667 144,298 (24,369) 92% 78% c) 184,000 201,000 17,000 260,178 245,091 (15,087) 92% 86% 283,830 271,300 (12,530) 712,215 642,102 (70,113) 92% 83% d) 776,962 697,700 (79,262) 324,290 292,244 (32,046) 92% 83% e) 353,771 349,900 (3,871) 2,866,785 2,636,109 (230,676) 92% 84% 3,127,400 2,966,250 (161,150) Trans In -GF 232,272 232,272 - 92% 92% 253,387 253,387 Trans In -GF for Lng Rng Ping 473,000 473,000 - 92% 92% 516,000 516,000 TOTAL RESOURCES 4,258,138 3,954,412 (303,726) 92% 86% 4,582,868 4,348,668 (234,200) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations 1,285,530 Admin -GIS 198,124 Admin -Code Enforcement 169,338 Building Safety 458,636 Electrical 171,972 Contract Services 223,897 Env Health -On Site Pgm 212,672 Planning -Current 632,766 Planning -Long Range 451,391 Transfers Out (DIS Fund) 158,868 Contingency 237,770 Exp. % 1,266,188 19,342 92% 90% 1,402,396 1,372,000 30,396 156,878 41,246 92% 73% f) 216,135 158,312 57,823 169,670 (332) 92% 92% 184,732 182,607 2,125 451,314 7,322 92% 90% g) 500,330 479,817 20,513 164,655 7,317 92% 88% 187,606 179,400 8,206 206,762 17,135 92% 85% g) 244,251 225,066 19,185 197,170 15,502 92% 85% h) 232,006 214,300 17,706 582,343 50,423 92% 84% i) 690,290 630,200 60,090 463,301 (11,910) 92% 94% j) 492,427 523,682 (31,255) 173,310 (14,442) 92% 100% 173,310 173,310 - 237,770 92% n/a 259,385 259,385 TOTAL REQUIREMENTS 4,200,964 3,831,591 369,373 92% 84% 4,582,868 4,138,694 4.44,174 NET (Resources - Requirements) 57,174 122,821 65,647 209,974 209,974 Beginning NWC per Approved Budget 229,822 Revenues Expenditures Net from Operations 2,636,109 3,831,591 (1,195,482) 3,127,400 2,966,250 (161,150) 4,582,868 4,138,694 444,174 (1,455,468) (1,172,444) 283,024 a) Custom GIS work revenue sporadic. Includes webmaster work for Health Dept b) Year end projections reduced as at (east one major project (La Pine Biomass plant) has been delayed, but is expected next year c) City of Redmond receipts lag one month behind d) YTD business volume/revenue projected to be Tess than estimated e) Grant payments received irregularly f) Savings due to resignation of CDD webmaster, who will not be replaced g) Savings due to retirement of Building Inspector in January, who will not be replaced h) Savings due to retirement of EH Director, who will be replaced by an EH Specialist III i) Savings due to lower expenses associated with Hearings Officer, mailings, etc. j) Consultant expenditure higher than budgeted associated with timing of grant revenue received in FY 2010 ROAD Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 3,430,429 $ 3,419,603 $ (10,826) 100% 100% $ 3,430,429 $ 3,419,603 $ (10,826) Revenues Mineral Lease Royalties 18,333 153,454 135,121 92% 767% 20,000 155,000 135,000 Forest Receipts 2,050,583 2,237,091 186,508 92% 100% a) 2,237,000 2,237,091 91 State Miscellaneous 88,902 (88,902) 92% 0% b) 96,984 (96,984) Motor Vehicle Revenue 9,166,667 8,287,809 (878,858) 92% 83% c) 10,000,000 9,100,000 (900,000) City of Bend 252,083 215,049 (37,034) 92% 78% d) 275,000 375,000 100,000 City of Redmond 320,833 250,458 (70,375) 92% 72% d) 350,000 275,000 (75,000) City of Sisters 9,167 (9,167) 92% 0% d) 10,000 (10,000) City of La Pine 9,167 (9,167) 92% 0% d) 10,000 (10,000) Admin Recovery (SDC) 1,752 1,752 92% n/a 1,800 1,800 Miscellaneous 82,500 30,108 (52,392) 92% 33% 90,000 93,451 3,451 Road Vacations 917 1,000 83 92% 100% 1,000 1,000 Interest on Investments 36,667 20,764 (15,903) 92% 52% 40,000 24,000 (16,000) Other Bank/LGIP Interest 61 61 92% n/a - 62 62 Parking Fees 825 (825) 92% 0% 900 (900) Grants -Private 2,434 2,434 92% n/a - 2,434 2,434 Interfund Contract 687,500 (687,500) 92% 0% e) 750,000 700,000 (50,000) Equipment Repairs 229,167 192,272 (36,895) 92% 77% 250,000 200,000 (50,000) Vehicle Repairs 82,500 (82,500) 92% 0% 90,000 90,000 LID Construction 9,167 (9,167) 92% 0% e) 10,000 (10,000) Vegetation Management 32,083 (32,083) 92% 0% e) 35,000 35,000 Forester 22,917 (22,917) 92% 0% e) 25,000 25,000 Car Washes 2,750 3,464 714 92% 115% 3,000 4,000 1,000 Car Rental 458 462 4 92% 92% 500 462 (38) Sale of Equip & Material 553,208 588,214 35,006 92% 97% 603,500 659,439 55,939 Total Revenues 13,656,394 11,984,392 (1,672,002) 92% 80% 14,897,884 13,978,739 (919,145) Trans In - Solid Waste Trans In - Transp SDC Trans In -Road Imp Res TOTAL RESOURCES 267,428 183,333 11,037 218,805 (48,623) 92% 75% 150,000 (33,333) 92% 75% (11,037) 92% 0% 291,740 200,000 12,040 291,740 200,000 (12,040) 17,548,621 15,772,800 (1,742,488) 92% 93% 18,832,093 17,890,082 (942,011) REQUIREMENTS: Expenditures Personal Services 5,273,553 Materials and Services 8,681,771 Capital Outlay 1,074,050 Transfers Out 366,667 Contingency 1,866,711 TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. % 5,001,964 271,589 92% 87% 5,752,967 5,583,544 169,423 6,277,456 2,404,315 92% 66% 9,471,023 9,275,358 195,665 91,180 982,870 92% 8% f) 1,171,691 94,900 1,076,791 400,000 (33,333) 92% 100% 400,000 400,000 1,866,711 92% n/a 2,036,412 2,036,412 17,262,752 11,770,600 5,492,152 92% 63% 18,832,093 15,353,802 3,478,291 285,869 4,002,200 3,749,664 2,536,280 2,536,280 Beginning NWC per Approved Budget 2,834,720 a) Annual payment -January 2011 b) Received in June 2010 c) Even though gas taxes increased by 25% ($.06/gal.) effective January 2011 (revised State estimate); gas tax receipts will be less than estimated d) Billed upon completion of work e) Payment to be received in June 2011 from Funds 326, 328, 329, & 340 f) Budget includes $1,076,691 for 19th Street construction. Will be expended in future years Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 3,430,429 $ 3,419,603 $ (10,826) 100% 100% $ 3,430,429 $ 3,419,603 $ (10,826) Revenues Mineral Lease Royalties 18,333 153,454 135,121 92% 767% 20,000 155,000 135,000 Forest Receipts 2,050,583 2,237,091 186,508 92% 100% a) 2,237,000 2,237,091 91 State Miscellaneous 88,902 (88,902) 92% 0% b) 96,984 (96,984) Motor Vehicle Revenue 9,166,667 8,287,809 (878,858) 92% 83% c) 10,000,000 9,100,000 (900,000) City of Bend 252,083 215,049 (37,034) 92% 78% d) 275,000 375,000 100,000 City of Redmond 320,833 250,458 (70,375) 92% 72% d) 350,000 275,000 (75,000) City of Sisters 9,167 (9,167) 92% 0% d) 10,000 (10,000) City of La Pine 9,167 (9,167) 92% 0% d) 10,000 (10,000) Admin Recovery (SDC) 1,752 1,752 92% n/a 1,800 1,800 Miscellaneous 82,500 30,108 (52,392) 92% 33% 90,000 93,451 3,451 Road Vacations 917 1,000 83 92% 100% 1,000 1,000 Interest on Investments 36,667 20,764 (15,903) 92% 52% 40,000 24,000 (16,000) Other Bank/LGIP Interest 61 61 92% n/a - 62 62 Parking Fees 825 (825) 92% 0% 900 (900) Grants -Private 2,434 2,434 92% n/a - 2,434 2,434 Interfund Contract 687,500 (687,500) 92% 0% e) 750,000 700,000 (50,000) Equipment Repairs 229,167 192,272 (36,895) 92% 77% 250,000 200,000 (50,000) Vehicle Repairs 82,500 (82,500) 92% 0% 90,000 90,000 LID Construction 9,167 (9,167) 92% 0% e) 10,000 (10,000) Vegetation Management 32,083 (32,083) 92% 0% e) 35,000 35,000 Forester 22,917 (22,917) 92% 0% e) 25,000 25,000 Car Washes 2,750 3,464 714 92% 115% 3,000 4,000 1,000 Car Rental 458 462 4 92% 92% 500 462 (38) Sale of Equip & Material 553,208 588,214 35,006 92% 97% 603,500 659,439 55,939 Total Revenues 13,656,394 11,984,392 (1,672,002) 92% 80% 14,897,884 13,978,739 (919,145) Trans In - Solid Waste Trans In - Transp SDC Trans In -Road Imp Res TOTAL RESOURCES 267,428 183,333 11,037 218,805 (48,623) 92% 75% 150,000 (33,333) 92% 75% (11,037) 92% 0% 291,740 200,000 12,040 291,740 200,000 (12,040) 17,548,621 15,772,800 (1,742,488) 92% 93% 18,832,093 17,890,082 (942,011) REQUIREMENTS: Expenditures Personal Services 5,273,553 Materials and Services 8,681,771 Capital Outlay 1,074,050 Transfers Out 366,667 Contingency 1,866,711 TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. % 5,001,964 271,589 92% 87% 5,752,967 5,583,544 169,423 6,277,456 2,404,315 92% 66% 9,471,023 9,275,358 195,665 91,180 982,870 92% 8% f) 1,171,691 94,900 1,076,791 400,000 (33,333) 92% 100% 400,000 400,000 1,866,711 92% n/a 2,036,412 2,036,412 17,262,752 11,770,600 5,492,152 92% 63% 18,832,093 15,353,802 3,478,291 285,869 4,002,200 3,749,664 2,536,280 2,536,280 Beginning NWC per Approved Budget 2,834,720 a) Annual payment -January 2011 b) Received in June 2010 c) Even though gas taxes increased by 25% ($.06/gal.) effective January 2011 (revised State estimate); gas tax receipts will be less than estimated d) Billed upon completion of work e) Payment to be received in June 2011 from Funds 326, 328, 329, & 340 f) Budget includes $1,076,691 for 19th Street construction. Will be expended in future years ADULT PAROLE & PROBATION Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Revised Year End Budget Projection Variance Beg. Net Working Capital $ 616,371 $ 728,649 $ 112,278 100% 118% $ 616,371 $ 728,649 $ 112,278 Revenues DOC Measure 57 199,196 217,350 18,154 92% 100% 217,305 217,350 45 State Miscellaneous 3,943 4,301 358 92% 100% 4,301 4,301 Alternate Incarceration 28,342 30,918 2,576 92% 100% 30,918 30,918 State Subsidy 11,917 13,306 1,389 92% 102% 13,000 13,306 306 SB 1145 2,715,157 2,781,694 66,537 92% 94% 2,961,990 2,781,990 (180,000) Probation Work Crew Fees 34,833 22,612 (12,221) 92% 60% a) 38,000 25,610 (12,390) Miscellaneous 2,750 4,165 1,415 92% 139% b) 3,000 4,500 1,500 Electronic Monitoring Fee 155,833 148,469 (7,364) 92% 87% 170,000 166,000 (4,000) Probation Superv. Fees 192,500 187,946 (4,554) 92% 89% 210,000 199,000 (11,000) Interest on Investments 8,250 7,894 (356) 92% 88% 9,000 9,000 Interfund - Sheriff 45,833 45,833 - 92% 92% 50,000 50,000 Crime Prevention Grant 45,833 37,500 (8,333) 92% 75% c) 50,000 50,000 CFC -Domestic Violence 37,416 37,416 92% n/a d) - 56,124 56,124 Total Revenues Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 3,444,387 3,539,404 95,017 92% 94% 3,757,514 3,608,099 (149,415) 105,442 105,442 - 92% 92% 115,029 115,029 4,166,200 4,373,495 207,295 92% 97% 4,488,914 4,451,777 (37,137) Exp. % 2,908,819 2,733,975 174,844 92% 86% e) 3,173,257 2,966,580 206,677 819,751 737,285 82,466 92% 82% f) 894,274 864,274 30,000 92 92 92% 0% 100 100 386,176 386,176 92% n/a 421,283 421,283 TOTAL REQUIREMENTS 4,114,838 3,471,260 643,578 92% 77% 4,488,914 3,830,854 658,060 NET (Resources - Requirements) 51,362 902,235 850,873 620,923 620,923 Beginning NWC per Approved Budget 560,000 a) Increase in fee waivers from court due to economic conditions b) Larger number of offenders doing out of state and county transfers c) Payments received quarterly (Sept, Dec, Mar and June) d) Intensive Supervision DV grant (Federal grant) e) Personnel expenditure projected to be less than budgeted due to unfilled positions f) M57 treatment funds have been used less based on current population COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY % Coll. % Revised Budget Year End Projection _ Variance RESOURCES: Beg. Net Working Capital $ 562,762 $ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578 Revenues Federal Grants 366,820 355,788 (11,032) 92% 89% a) 400,167 413,268 13,101 Title IV - Family Sup/Pres 58,438 61,870 3,432 92% 97% 63,750 63,750 HealthyStart Medicaid 87,083 71,972 (15,111) 92% 76% 95,000 95,000 Level 7 Services 236,485 239,237 2,752 92% 93% 257,984 257,984 State Prevention Funds 13,292 7,532 (5,760) 92% 52% b) 14,500 17,000 2,500 HealthyStart /R -S -G 283,180 263,596 (19,584) 92% 85% c) 308,924 263,596 (45,328) OCCF Grant 553,963 542,003 (11,960) 92% 90% c) 604,323 549,044 (55,279) Charges for Svcs-Misc 7,333 3,597 (3,736) 92% 45% d) 8,000 5,000 (3,000) Court Fines & Fees 68,750 78,681 9,931 92% 105% e) 75,000 88,000 13,000 Interest on Investments 18,333 4,680 (13,653) 92% 23% f) 20,000 8,000 (12,000) Grants -Private 4,583 (4,583) 92% 0% g) 5,000 (5,000) Donations 3,857 3,857 92% n/a d) 3,857 3,857 Video Lottery 2,500 2,500 92% n/a d) - 2,500 2,500 Miscellaneous 237,008 85,058 (151,950) 92% 33% h) 258,554 118,500 (140,054) Total Revenues 1,935,268 1,720,371 (214,897) 92% 81% 2,111,202 1,885,499 (225,703) Trans from General Fund 260,639 260,639 - 92% 92% 284,333 284,333 Trans from GF -Other 22,917 18,750 (4,167) 92% 75% 25,000 25,000 Total Transfers In 283,556 279,389 (4,167) 92% 90% 309,333 309,333 TOTAL RESOURCES 2,781,586 2,635,100 (146,486) 92% 88% 2,983,297 2,830,172 (153,125) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 549,596 498,779 50,817 92% 83% i) 599,559 545,878 53,681 1,810,494 1,398,274 412,220 92% 71% c) 1,975,084 1,817,183 157,901 92 92 92% 0% 100 100 374,508 374,508 92% n/a 408,554 408,554 TOTAL REQUIREMENTS 2,734,690 1,897,053 837,637 92% 64% 2,983,297 2,363,061 620,236 NET (Resources - Requirements) 46,896 738,047 691,151 467,111 467,111 Beginning NWC per Approved Budget 467,111 a) Federal grants adjusted to projected actual b) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $9,924 grant received c) Governor's mandated State General Fund reductions in July & Sept 2010. Additional $19,900 grant received d) Community donations received for "Week of the Young Child" & building partner reimbursements adjusted to actual e) Mary's Place court fines greater than projected f) Interest revenue projected to be less than budgeted g) Youth conference donations will not be received h) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received i) Personnel costs will be less than budgeted due to open positions -increased due to .50 FTE working additional hours SOLID WASTE Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY % CoII. % Revised Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 392,509 $ 318,001 $ (74,508) 100% 81% $ 392,509 $ 318,001 $ (74,508) Revenues Miscellaneous 25,667 20,166 (5,501) 92% 72% 28,000 22,000 (6,000) Refunds/Reimbursements 15 15 92% n/a 15 15 Franchise 3% Fees 183,333 206,615 23,282 92% 103% 200,000 209,015 9,015 Commercial Disp. Fees 770,000 773,977 3,977 92% 92% 840,000 860,000 20,000 Private Disposal Fees 1,204,500 1,186,334 (18,166) 92% 90% 1,314,000 1,314,000 Franchise Disposal Fees 3,354,083 3,560,026 205,943 92% 97% 3,659,000 4,000,000 341,000 Yard Debris 66,917 73,260 6,343 92% 100% 73,000 75,000 2,000 Special Waste 22,917 41,631 18,714 92% 167% a) 25,000 44,000 19,000 Interest 11,458 7,999 (3,459) 92% 64% 12,500 8,850 (3,650) Leases 1 1 92% n/a 1 1 Sale of Carbon Credits 73,333 (73,333) 92% 0% b) 80,000 (80,000) Donations 3,240 3,240 92% n/a 3,240 3,240 Sale of Equip & Material 100 100 92% n/a c) 100 100 Recyclables 18,333 46,046 27,713 92% 230% d) 20,000 49,000 29,000 Total Revenues 5,730,541 5,919,410 188,869 92% 95% 6,251,500 6,585,221 333,721 TOTAL RESOURCES 6,123,050 6,237,411 114,361 92% 94% 6,644,009 6,903,222 259,213 REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out -Road Contingency Exp. % 1,498,400 1,490,149 8,251 92% 91% 1,634,618 1,631,569 3,049 2,627,010 2,221,925 405,085 92% 78% e) 2,865,829 2,771,678 94,151 889,227 970,066 (80,839) 92% 100% 970,066 970,066 135,667 84,545 51,122 92% 57% f) 148,000 145,661 2,339 267,428 218,805 48,623 92% 75% 291,740 291,740 672,610 672,610 92% n/a 733,756 733,756 TOTAL REQUIREMENTS 6,090,342 4,985,490 1,104,852 92% 75% 6,644,009 5,810,714 833,295 NET (Resources - Requirements) 32,708 1,251,921 1,219,213 1,092, 508 1,092, 508 Beginning NWC per Approved Budget 1,092,508 a) Bonneville Power did large clean-up of contaminated soil -unexpected revenue b) No market at this time. Not expected to market this fiscal year c) Minor revenue for sale of gate remotes d) Markets for recyclables varies throughout the year - usually declines during Winter e) Larger expenditures (i.e. grinding at $75,000) will be made in Spring f) Software purchase in process; also, $30,000 from contingency needed for safety covers for Knott Transfer Trailer Bays RESOURCES: Beginning Net Working Capital Revenues Inter -fund Charges: RISK MANAGEMENT Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance I % of FY _J % Coll. $2,500,000 $2,374,541 ($125,460) 100% 95% $2,500,000 $2,374,541 ($125,460) General Liability 307,847 307,847 0 92% 92% 335,833 335,833 Property Damage 269,517 269,517 (0) 92% 92% 294,019 294,019 Vehicle 167,484 167,484 (0) 92% 92% 182,710 182,710 Workers' Compensation 830,831 825,466 (5,365) 92% 91% 906,361 906,361 Unemployment 156,234 155,864 (370) 92% 91% 170,437 170,437 - Claims Reimb-Workers' Compensation 27,500 - (27,500) 92% 0% 30,000 30,000 - Claims Reimb-Gen Liab/Property 18,333 28,481 10,148 92% 142% 20,000 30,000 10,000 Process Fee-Events/Parades 1,375 2,010 635 92% 134% 1,500 2,200 700 Miscellaneous 1,833 - (1,833) 92% 0% 2,000 250 (1,750) Skid Car Training 20,167 15,538 (4,629) 92% 71% 22,000 17,000 (5,000) Interest on Investments 27,500 14,618 (12,882) 92% 49% 30,000 15,000 (15,000) TOTAL REVENUES 1,828,622 1,786,825 (41,797) 92% 90% 1,994,860 1,983,810 (11,050) TOTAL RESOURCES 4,328,622 4,161,366 (167,256) Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Repair / Replacement Total General Liability PROPERTY DAMAGE Insurance 153,414 Repair / Replacement 14,790 62,818 21,915 7,935 155,221 999 250 92% 93% 4,494,860 4,358,351 (136,510) Exp. 366,667 249,138 117,529 92% 62% 400,000 260,000 140,000 Total Property Damage 275,000 168,204 106,796 92% 56% 300,000 180,000 120,000 VEHICLE Professional Service 1,839 Insurance 390 Loss Prevention 14,968 Repair / Replacement 69,093 Total Vehicle 110,000 86,290 23,710 92% 72% 120,000 100,000 20,000 WORKERS' COMPENSATION Settlement / Benefit 586,180 Professional Service 6,250 Insurance 102,569 Loss Prevention 48,110 Miscellaneous 33,071 Total Workers' Compensation 595,833 776,181 (180,347) 92% 119% 650,000 829,181 (179,181) UNEMPLOYMENT - Settlement/Benefits 146,667 267,377 (120,710) 92% 167% 160,000 347,377 (187,377) Total Direct Insurance Costs 1,494,167 1,547,189 (53,023) 92% 95% 1,630,000 1,716,558 (86,558) Insurance Administration: Personal Services 265,332 266,858 (1,526) 92% 92% 289,453 289,453 Materials & Service 209,765 156,931 52,834 92% 69% 228,834 228,834 Capital Outlay 92 92 92% 0% 100 100 Total Insurance Administration 475,188 423,789 51,399 92% 82% 518,387 518,287 100 Contingency 2,150,934 - 2,150,934 92% n/a 2,346,473 2,346,473 TOTAL REQUIREMENTS 4,120,288 1,970,978 2,149,310 92% 44% 4,494,860 2,234,845 2,260,015 NET 208,333 2,190,388 1,982,054 2,123,506 2,123,506 Beginning NWC per Approved Budget 2,100,000 Year End Budget Projection Variance 100% 95% $2,500,000 $2,374,541 ($125,460) General Liability 307,847 307,847 0 92% 92% 335,833 335,833 Property Damage 269,517 269,517 (0) 92% 92% 294,019 294,019 Vehicle 167,484 167,484 (0) 92% 92% 182,710 182,710 Workers' Compensation 830,831 825,466 (5,365) 92% 91% 906,361 906,361 Unemployment 156,234 155,864 (370) 92% 91% 170,437 170,437 - Claims Reimb-Workers' Compensation 27,500 - (27,500) 92% 0% 30,000 30,000 - Claims Reimb-Gen Liab/Property 18,333 28,481 10,148 92% 142% 20,000 30,000 10,000 Process Fee-Events/Parades 1,375 2,010 635 92% 134% 1,500 2,200 700 Miscellaneous 1,833 - (1,833) 92% 0% 2,000 250 (1,750) Skid Car Training 20,167 15,538 (4,629) 92% 71% 22,000 17,000 (5,000) Interest on Investments 27,500 14,618 (12,882) 92% 49% 30,000 15,000 (15,000) TOTAL REVENUES 1,828,622 1,786,825 (41,797) 92% 90% 1,994,860 1,983,810 (11,050) TOTAL RESOURCES 4,328,622 4,161,366 (167,256) Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Repair / Replacement Total General Liability PROPERTY DAMAGE Insurance 153,414 Repair / Replacement 14,790 62,818 21,915 7,935 155,221 999 250 92% 93% 4,494,860 4,358,351 (136,510) Exp. 366,667 249,138 117,529 92% 62% 400,000 260,000 140,000 Total Property Damage 275,000 168,204 106,796 92% 56% 300,000 180,000 120,000 VEHICLE Professional Service 1,839 Insurance 390 Loss Prevention 14,968 Repair / Replacement 69,093 Total Vehicle 110,000 86,290 23,710 92% 72% 120,000 100,000 20,000 WORKERS' COMPENSATION Settlement / Benefit 586,180 Professional Service 6,250 Insurance 102,569 Loss Prevention 48,110 Miscellaneous 33,071 Total Workers' Compensation 595,833 776,181 (180,347) 92% 119% 650,000 829,181 (179,181) UNEMPLOYMENT - Settlement/Benefits 146,667 267,377 (120,710) 92% 167% 160,000 347,377 (187,377) Total Direct Insurance Costs 1,494,167 1,547,189 (53,023) 92% 95% 1,630,000 1,716,558 (86,558) Insurance Administration: Personal Services 265,332 266,858 (1,526) 92% 92% 289,453 289,453 Materials & Service 209,765 156,931 52,834 92% 69% 228,834 228,834 Capital Outlay 92 92 92% 0% 100 100 Total Insurance Administration 475,188 423,789 51,399 92% 82% 518,387 518,287 100 Contingency 2,150,934 - 2,150,934 92% n/a 2,346,473 2,346,473 TOTAL REQUIREMENTS 4,120,288 1,970,978 2,149,310 92% 44% 4,494,860 2,234,845 2,260,015 NET 208,333 2,190,388 1,982,054 2,123,506 2,123,506 Beginning NWC per Approved Budget 2,100,000 DESCHUTES COUNTY 911 Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance % of FY % Coll. Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital $5,861,335 $ 6,691,945 $ 830,610 100% 114% $5,861,335 $6,691,945 $ 830,610 Revenues Property Taxes - Current 5,827,819 6,240,614 412,795 92% 98% 6,357,621 6,357,621 Property Taxes - Prior 126,500 277,047 150,547 92% 201% 138,000 277,047 139,047 Federal Grants 434,500 265,193 (169,307) 92% 56% a) 474,000 332,336 (141,664) State Reimbursement 9,167 19,219 10,052 92% 192% b) 10,000 20,921 10,921 Telephone User Tax 504,167 642,765 138,598 92% 117% c) 550,000 642,765 92,765 Data Network Reimb. 11,000 26,672 15,672 92% 222% d) 12,000 26,672 14,672 Jefferson County 28,417 40,234 11,817 92% 130% 31,000 40,234 9,234 User Fee 45,833 52,338 6,505 92% 105% e) 50,000 52,340 2,340 COPS Reimbursements 27,500 (27,500) 92% 0% f) 30,000 (30,000) Contract Payments 64,167 32,134 (32,033) 92% 46% g) 70,000 32,134 (37,866) Miscellaneous 7,792 13,260 5,468 92% 156% 8,500 15,000 6,500 Interest 36,667 45,926 9,259 92% 115% 40,000 50,000 10,000 Interest on Unsegregated Tax 1,833 756 (1,077) 92% 38% 2,000 800 (1,200) Total Revenues 7,125,362 7,656,158 530,796 92% 98% 7,773,121 7,847,870 74,749 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 12,986,697 14,348,103 1,361,406 92% 105% 13,634,456 14,539,815 905,359 % Exp. 3,674,732 3,302,679 372,053 92% 82% 4,008,798 3,758,798 250,000 1,397,132 1,095,379 301,753 92% 72% 1,524,144 1,524,144 1,616,083 1,144,577 471,506 92% 65% 1,763,000 1,763,000 929,556 1,014,061 (84,505) 92% 100% 1,014,061 1,014,061 4,880,749 4,880,749 92% n/a 5,324,453 5,324,453 TOTAL REQUIREMENTS 12,498,252 6,556,696 5,941,556 92% 48% 13,634,456 8,060,003 5,574,453 NET (Resources - Requirements) 488,445 7,791,407 7,302,962 - 6,479,812 6,479,812 Beginning NWC per Approved Budget 6,400,000 a) CAD -to -CAD budgeted $314,000 of which $265,193 has been received. Expect to receive $39,485 more by June 30 ODOT project budgeted $160,000 which will not occur this fiscal year b) GIS/Mapping revenue underbudgeted c) Received quarterly (Nov, Feb, May and Aug) for fiscal year d) Annual billings to agencies underbudgeted. All payments have been received e) Crooked River Ranch paid annual fee of $45,869 f) Revenue not expected this fiscal year g) All payments have been received Health Benefits Trust Statement of Financial Operating Data Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY Coll.% Revised Budget Year End Projection Variance RESOURCES Beg. Net Working Capital $ 16,400,000 $ 16,988,140 $ 588,140 100% 104% $ 16,400,000 $ 16,988,140 588,140 Revenues: Internal Premium Charges 10,308,833 10,457,013 148,179 92% 93% a) 11,246,000 11,400,359 154,359 P/T Emp - Add'I Prem 45,833 42,187 (3,646) 92% 84% 50,000 45,000 (5,000) Employee Prem Contribution 458,333 448,345 (9,988) 92% 90% 500,000 485,000 (15,000) COIC 893,750 1,314,919 421,169 92% 135% 975,000 1,425,000 450,000 Retiree / COBRA Co -Pay 412,500 669,962 257,462 92% 149% 450,000 715,000 265,000 Federal Payments - 93,496 93,496 92% n/a 93,496 93,496 Prescription Rebates 94,970 94,970 92% n/a 94,970 94,970 Interest 91,667 101,643 9,977 92% 102% 100,000 109,000 9,000 Total Revenues 12,210,917 13,222,535 1,011,618 92% 99% 13,321,000 14,367,825 1,046,825 TOTAL RESOURCES 28,610,917 30,210,675 1,599,758 92% 102% 29,721,000 31,355,964 1,634,964 REQUIREMENTS Expenditures: Personal Services Materials & Services Claims Paid-Medical/Rx Claims Paid-DentalNision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Deschutes Onsite Clinic: Healthstat Equipment Remodel Miscellaneous Exp. 118,507 117,264 1,243 92% 91% 129,280 129,280 11,412,678 11,194,746.77 217,931 92% 90% b) 12,450,194 12,127,642 322,552 1,715,429 1,631,945.41 83,484 92% 87% b) 1,871,377 1,767,941 103,436 - (77,444) 77,444 92% n/a - (77,444) 77,444 302,500 307,618 (5,118) 92% 93% 330,000 335,000 (5,000) 68,750 124,832 (56,082) 92% 166% 75,000 124,832 (49,832) 275,000 275,842 (842) 92% 92°/u 300,000 300,000 36,667 39,737 (3,070) 92% 99% 40,000 43,000 (3,000) 46,750 47,103 (353) 92% 92% 51,000 51,000 210,393 180,591 29,803 92% 79% 229,520 229,520 13,292 32,114 (18,822) 92% 221% 14,500 32,114 (17,614) 111,467 123,907 (12,441) 92% 102% 121,600 123,907 (2,307) 56,742 43,912 12,829 92% 71% 61,900 61,900 Other 138,546 49,859 88,686 92% 33% 151,141 56,141 95,000 Total Materials & Services 14,388,213 13,974,765 413,448 92% 89% 15,696,232 15,175,554 520,678 Capital Outlay 100 - 100 92% 0% 100 - 100 Contingency 12,737,439 12,737,439 92% 0% 13,895,388 13,895,388 TOTAL REQUIREMENTS 27,244,258 14,092,028 13,152,230 92% 47% 29,721,000 15,304,834 14,416,166 NET (Resources - Requirements) 1,366,658 16,118,647 14,751,988 16,051,131 16,051,131 Beginning NWC per Approved Budget 15,500,000 a) Year End Projection is amount appropriated in operating departments' budgets. b) Projection based on annualizing 48 weeks of claims paid. YTD actual is an average of $265,609 per week. Deschutes County - Fair and Expo Center YTD -Budget Basis Commissioners Statement of Financial Operating Data Eleven Months Ended May 31, 2011 RESOURCES: Beg. Net Working Capital $ Receipts: Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Interfund Contract Miscellaneous Total Receipts Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Reserve Fund (617) Total Transfers In TOTAL RESOURCES 2,809 $ 6,590 $ 3,781 100% 235% 621,264 556,043 (65,220) 92% 82% 1,833 704 (1,130) 92% 35% 46,750 45,992 (759) 92% 90% 8,250 13,191 4,941 92% 147% 38,500 18,855 (19,645) 92% 45% 193,417 164,399 (29,017) 92% 78% 85,250 46,738 (38,513) 92% 50% 41,250 45,000 3,750 92% 100% 4,046 27,034 22,988 92% n/a 1,040,560 917,955 (122,604) 92% 81% 164,931 20,727 66,668 211,963 92 181,423 22,799 73,335 166,000 92% 92% 92% 92% (45,963) 92% (92) 92% 464,379 443,557 (46,054) Year End Budget Projection Variance $ 2,809 $ 6,590 $ 3,781 677,742 2,000 51,000 9,000 42,000 211,000 93,000 a) 45,000 4,414 92% 92% 72% b) 0% 598,043 871 45,992 13,191 44,855 178,399 116,738 45,000 27,434 (79,699) (1,129) (5,008) 4,191 2,855 (32,601) 23,738 23,020 1,135,156 197,919 24,873 80,000 231,232 100 1,070,523 (64,633) 197,919 24,873 80,000 166,000 (65,232) 100 534,124 468,892 (65,232) 1,507,748 1,368,102 (139,646) 92% 82% 1,672,089 1,546,005 (126,084) REQUIREMENTS: Expenditures: Personal Services 854,235 Materials and Services 528,628 Debt Service 105,933 Capital Outlay 92 792,501 491,756 115,561 61,735 36,872 (9,629) 92 Total Expenditures 1,488,888 Transfers Out - Reserve Fund 9,167 Contingency 34,694 92% 92% 92% 92% 1,399,818 89,069 9,167 92% 34,694 92% TOTAL REQUIREMENTS NET (Resources - Requirements) Beginning NWC per Approved Budget 1,532,748 1,399,818 132,930 92% (25,000) (31,716) (6,716) Exp. % 85% 931,893 85% c) 576,685 100% 115,563 0% 100 862,009 553,814 115,561 69,884 22,871 1.03 100 1,624,241 0% 10,000 n/a 37,848 84% 1,531,384 92,856 100 9,900 37,848 1,672,089 1,531,484 140,604 14,521 14,521 75,000 a) Interfund contract revenue is for park maintenance, from Fund 130 and will be received by year end. b) Cash flow from Fair 2010 was $65,000 less than budgeted c) Year to date amounts include costs associated with BMW and FMCA events and expenditures for HVAC repairs. An increase to the Materials & Services category will be made via resolution, when required. Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ Receipts: Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Interfund Contract Miscellaneous Total Receipts Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Reserve Fund (617) Total Transfers In TOTAL RESOURCES 2,809 $ 6,590 $ 3,781 100% 235% 621,264 556,043 (65,220) 92% 82% 1,833 704 (1,130) 92% 35% 46,750 45,992 (759) 92% 90% 8,250 13,191 4,941 92% 147% 38,500 18,855 (19,645) 92% 45% 193,417 164,399 (29,017) 92% 78% 85,250 46,738 (38,513) 92% 50% 41,250 45,000 3,750 92% 100% 4,046 27,034 22,988 92% n/a 1,040,560 917,955 (122,604) 92% 81% 164,931 20,727 66,668 211,963 92 181,423 22,799 73,335 166,000 92% 92% 92% 92% (45,963) 92% (92) 92% 464,379 443,557 (46,054) Year End Budget Projection Variance $ 2,809 $ 6,590 $ 3,781 677,742 2,000 51,000 9,000 42,000 211,000 93,000 a) 45,000 4,414 92% 92% 72% b) 0% 598,043 871 45,992 13,191 44,855 178,399 116,738 45,000 27,434 (79,699) (1,129) (5,008) 4,191 2,855 (32,601) 23,738 23,020 1,135,156 197,919 24,873 80,000 231,232 100 1,070,523 (64,633) 197,919 24,873 80,000 166,000 (65,232) 100 534,124 468,892 (65,232) 1,507,748 1,368,102 (139,646) 92% 82% 1,672,089 1,546,005 (126,084) REQUIREMENTS: Expenditures: Personal Services 854,235 Materials and Services 528,628 Debt Service 105,933 Capital Outlay 92 792,501 491,756 115,561 61,735 36,872 (9,629) 92 Total Expenditures 1,488,888 Transfers Out - Reserve Fund 9,167 Contingency 34,694 92% 92% 92% 92% 1,399,818 89,069 9,167 92% 34,694 92% TOTAL REQUIREMENTS NET (Resources - Requirements) Beginning NWC per Approved Budget 1,532,748 1,399,818 132,930 92% (25,000) (31,716) (6,716) Exp. % 85% 931,893 85% c) 576,685 100% 115,563 0% 100 862,009 553,814 115,561 69,884 22,871 1.03 100 1,624,241 0% 10,000 n/a 37,848 84% 1,531,384 92,856 100 9,900 37,848 1,672,089 1,531,484 140,604 14,521 14,521 75,000 a) Interfund contract revenue is for park maintenance, from Fund 130 and will be received by year end. b) Cash flow from Fair 2010 was $65,000 less than budgeted c) Year to date amounts include costs associated with BMW and FMCA events and expenditures for HVAC repairs. An increase to the Materials & Services category will be made via resolution, when required. eschutes ount Investment Income Fiscal Year 2010-11 G H } 1 >. CO $ 65,972 $ 815,550 Total Investment Income 65,972 815,550 Less Fee: 5% of Invest. Income (3,299) (40,778) Investment Income - Net $ 62,674 $ 774,773 11 Investments By County Function General $ 121,830,946 Total Investments $ 121,830,946 e a) e e �: ° ° e o ° e ° o� 0 O coCD M O O O O�Qi0f.40, O 03 03 CO CO L) U) V' CO O) r 0 ib n O C9 Ch C7 ( . Q) C 6) ti M Cf) b9 ON N CO a) op Y Q) m 0. z Vco cn o) O a) t N Q a) (13 a) E O U H 2 E e-a)�� UUI- O O ._ D� a) 0) W O r) T Prior Month ■ 0 o CD CD OS O x Average Maturity in Dap 0 o e at e atm O O CO to CO O O O O r- N N N r u)E 8 E CO CO N •V • d N CO a) RI C C U U a 0 7 a) y_�ZO NN IC:( ° Nmco--0 a�EaU• 0 li1-00 Total Portfolio: By Investment Types U .• x s Z r N TI a. 010-‘20. 0 o_ 0 0 '0 0L, 0 01 0 U U'- 0 0' O U O 5 oC C 000 ZZZ Z Z�Z Z Z Z ZIZ Z Z Z Z ZIZ Z Z Z Z Z N Z Z 8 m 5 r Z Z Z Q Z m m Z 160 r€CO1 0103 pp4 pN pS CC)) S pp81 S 1 0p (00 8O S 1 N V po V S Of N' (O K O S 00f 8O ppp (00 M 0pb ppb ppb 8O pp09 {0 �pappp (O S S 08 4 0 Tv J SOp' 1)f X S n u'1 S Q (MO_ N N g O c'f_ n_ O V_ N O O O O OD 0 S 1,2 ONO O. O N N M) N 0 N S 01 n O i N 0 0 0 N Q N O n N ), (V (n O v 0 O N O p M Q M M C C V N N M O M N M O N N N N V O M N N M O OIOICa �I 0�,0 O- rl0 r 0 Ni 1N O O O O O O .- NIO O O O 0 0 0 O N IN1N N N N NININ NIN NIN N N N r'N N 1N N (V (V NIN N N N r N r N N Market Value 0 0 2 0 . A T opp1888 S�G( B'888:888'888'�I(5888n1888818188880'; 8888845 I C]' S N n0 O S' � g (On0 B Sf 6666 fn V N M 00 t0+) N 0 O cn 0 (O 007 N 0 (0 C�)1 0.- (0 f') N- 0 N (0 00) 68 66 O 1 0p M 0 M (0 NIN 0 M 0 O 00 N O N N o n (D M n O I N N M N O 0 O O N M 7 M? N Q O 8 (per 8^ 8 v O 8 O O S O O O S S O O O S O O O S O r O O O S S S O r� S 01 O O;N ININ N N N NiN N NININ N N N N r N N IN N Ni NIN N NIN N N r NiN '8'88 8888BBN'888888888888888'°'8'8888888888S §§§§§§ §§§§eggs§§§§§ §§ § §.§ §§§ � n M o (novo rn v N u7 M o n (n gig 0 S glglg 0 g 5 A F S M v N v g 8 g 8:§ � `° §§§ E F§ Ai°' °'Ig O OO O N O N O O O 0 0 N N N r NIN N N N N N N N N. N N r N 1 N 1 312 0 J . O ce 2 a O .• :. %a i 2 C. I k I I 1 Li 1 1 1 1 1 1 1 1 1 1 1 1 1 IMeee'e44 R,8888 O r 0 o o �<�j (ii O ee e'eeeeeeeeeeeeemeleeeeee'eeee'ee 8 8 8 O O 8 8 0 8 8 6] M 0 O M N 8 O O (0 8 928187-88 0 8 0 (O 8 7- 8 8 0 0 (0 n Q) (0 (0 n O in N N ae�� (n 1 M M `a' o N o N (0 pppp N (O (0 0 n 0 (0 O n 47 r n l0 u7 iA O n (0 S (0 (0 (0 (0 N (C) a0 n n 0 00 M O 0101.- o,o r 10 O1 - d 0 0 0 0 Old r r O10 O O `-1O10 616 O O •� O 000000 ue7 en0 O •S7 C 41 r N O r 0 0 0 0 (0 0 8e a0 (0 N N S (0 (C) (0 ab IO d v (A OIO O Oo eeee 101- 0: 0 O O pn n 0 np 0) 0) M M n O (0 0) 0) 0) M O n 0 N M n Mao r l r r r l ..... N N (' Q 0 N 0 N O O O 0 O 0,01000,0000.2 (S'0 N n u.10 (o0 )tw') 47 (711, O 0 N 00 0) § n .' �- 80 (S n O N 0 (0 NN h 0 v On N Mort-- 0( . (NO (N [] • e Ol O 10 c 101010 000 PI M'.M M n n n m N N' N 1 N N N N N N N N N N N N N M :'l 0 0 M M M'' M .O 0 0 0 a O a. )1 a 0 0 0- 0` 0, 0 .- O) 8 a O O r r r N O r O O C (� M r �! N . 000 0aa a 0,0 `8 o 0 0 �lo 0 0 0 1 lolo o�� o,o 8 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'0 r r r r Ol0 .- 0b0l0 0 0 0 .I..... r r 0`)rn N N r.-rQonON oO N0O o(r�(po�rn(?i (?i 40Q rnQQ0 0 �0) 01040 o`la r` $�`) O r N N olM O_ N �1 O O ,M000 ▪ S�I0 r O 1 0000000,0 0 edR0101‹ 00�lQu.I, UIu_ 0a - u O1.S1U_11u(4-(L Lt.. 1- 0 LL ( LaL (IU t( 0101(aLIi-1t a(¢L LL1LLI1LL0 1-ILZ'LLa 1Z Z LL a)m lY d0aZ 0- 22 ZILL< 2LLLLZ 4-) 2 QIuCCQZI<Z> 'f�o9 n:[lina�y�MMW SMCCIOD W DWMD V)(n1(n2[n(n �(nM0. (nUIUUWU(n(n J O ((Se _. _.piH ($,S21'212 N ,1 -aj Q Z n n R}' n Q Z COMM 00) CM7 coli M M 0 S , M Rpo .. _ O M S 1 M MIM n D M 0 O 1J N m a 3133XWKU2 0 v 10) 0 0 v''0 0 0 vl 0000.00M00 _ M M (l 2" ap (p) M M M M (pp M 0) (+) M M M M (`7 M ( l i { Z 10 10 0 z0 ( 0 IQ IU Z ,U U a U , a�U Y U• m 10 U ;Lt. m m0' co a C C m O ' a Y C C 0 O�) amd U CL Y U U(0m 0Z m• �mmiZU 0 1LLU ` COI LL RI Y (0Y W at m UUY 05 W Y m ti mt0m dN' m N N � O >. A 8CO C '0NmhC A lL I N 0n 'cc cou.3. 71 (0 0' 0 I N 0 U LL C W LL L ,0 > `m0cou. acm�lcm�0 o,< E • U-1 E5U� ci ah . • Secure Treatment Facility . Bethlehem Inn . O U) c C _ L Ur C OL N o — U @ c'`) m'o. >' Q a) co co Z ca) L to .0 m Q) 0.O O L a) co (1) C 0 CJ) 0 PROJECTION a) U co co fo O U N N p) O7 a m n co O) d d O) r� N 0) CO 1.0 LO M N CD 0 0 O 0 O O C(7 N CD N CA Ci! CO CD O O O O T CO co co r-0)ncoN M qO O Ct) O CO 0) M CO N n M co co d CO CO CO n CD co- O t— d 1.6 co- n O d CO I+ n CO _N 0) c.-) d 0 0 O d co co n M CV n M 0) n N CO n CO CO 0 — CD CO CO M n CD M d d to O N. O t— N M N. lr) CO M CO O n 0 0 O 0 ' O Cn CO d O CC) O CO LO CO 0 O O N (0 (0 0) r -- CO CO CO CO 0) CO CO n M M O N- N CO 117 0 M O d O CD O CD d O CD O) -- r` o) d M N U) M M O n O co U7 O O d O CO N CD d O CD N CO N n N M M O O r-- tri `Cn 0) 0) M 0) co lr) Ir) h. 0) N LID U) O CD M 0 M 0 O 00) M CC) O 0 O J 1- H 0 U a) a) a 0 Encumbrances & Commitme Received and a) X W RESOURCES: n N Nr co to CO N �- Co n N NC CO to CO O N CD CA N CA CO co' EXPENDITURES: Materials & Services Nr CO r n CO _N 0) c. -)d 0 0 0) d CO CO n M N n M 0) � N OO r- CO CD O — CO CO CO M n CO CO- d d C6 — CO N O N M n 0) OO CO N 0) CO d 0 0 0) dOO CO n M 0) N. N CO n OO CO 0 CD CO CO CO CO. d d Cr) CO r- O •- N M n up O M O 0) N. 0 MCO O O O CO LO 0 CO 0 0 O (C u) to a) a) v U N O U O Z I) a) 0) c o U"oa O) m (1) .- �- N a a a) )) 0) co 7 E aaco o U co d LL w .` 'U C a) U E O U U Co CO N .0 CO O O •C O CO U C= CCo d t C® O O� O 0 C U .8) . 2 a) aa'i > c_ 0 s O 74 QwHo = Cii¢aDMO~ �z U Transfer Out O CD O O tri Total Expenditures a) O N >- O CI. D E c co cr) moN C1 O } E LL co L U O c d O -C Li U 7 O E>.a 2 u ts- a) C .n -a a) co N E o co O c a) a) a) Eco >, a) a) fO J y (I) 0)w 0 N O m 3 . a) -aa) U o.0 a) w Q) U N C = L (3 .o a) E �, (D • c 0 C N o u M - J (1) a) Q a?•p�Z U • d 11 0 N O) N• •a 0 • (9 O L 0) PROJECTION O H p) a) O) O j am RESOURCES: O N 0 O N O O N N (f) I"- (O N CD M (9 0) M N (D CD V N M CO N OO (D ,7 M 0) V' M N (D N CD N M M ,- 00 M (0 00 CO Co N V- CO M ri Total Resources EXPENDITURES: O N 0 — I- N (0 CO C") 0) O) 03 CD N 0) CO 0) 1- • 0) M CO 0 00 N O ,O O N c) — 0 0 N N(n N CO N N (0 co v. O (D 0 V- N CO N CO 0) 0) N CO 0- 0) 00 C) 0) r- to O) M co O) O N O" N O N (O — 0 0) 0) O (A N N c7 N in- ,- N t7 (") 0 03 0 0) 0 OO 0 0 O ' O ' 0 0 r- — N O O N (n N (A O O O 0 CD O' N CO N CO 0) O N CO 0- 0) CO M 0) I- N 0) CO 00 0) 03 N O N 0 N CD - 0 0) V- 0) 0 (NI of (f) I+ (0 r N M 0 CO 0 N CD N M 0) 0) N CD 0- O) 00 M 0) 0- N O) M 00 0) CO N 0 V- N 0 N (D — 0 0) 0) O N N N M N N h (0 N ,- N N a) 0 (1) 0 U Z c0 0 w co _U N a) 4(S 7 Zo U m �a ' � •0 13 c a) 0 m E rn °' V N 0)10 U 5 ..- `4), -E, .F.c. C 7 vi N c N a)ca) )- . aa))v•` co<W1-0_ C CLLQd n Minor Office Furniture O) 0) N N CO CO N 0 N CO (D N 0) M (0 CD 0 coLO N U U � O (1) ca > y Ta U ++ • 2 605 o ro w � 0 co r- el co ts. CV el 1.0 O CO00) 01 M M CO- M N `-- O c7 CO '4) M O I- (D CON O CO 0- CD M O M CO (() O O N CO M CV ti (D N N N Cr)00 0)) CO (f) N Cl) M M M O O O 01 O CO (O CO O CO CO 1() h O M M 0) M O CO M M M CO Cql 0 I- 0CO 0 CO CO ID 0 CO- M 0) C O O o M M M (o 4S O 7-0 0o C. M (C (n U 'O— c O LL FF- Total Expenditures M CD t� M CO 0 Z b) Balance in Fund will be transferred to Debt Service fund for the benefit of Deschutes County 911. O O C j N O U U a CO a ° z L L LL U co L3 °LL L C � N E CO N F- N U (n PROJECTION O CT O D_ aco� U C N CO .E c O c O W ots RESOURCES: CO M O M 0) ' CO O Cf) r` O N O O co O co M O co O co oO•‘-oICI Cf) O N (V N N. - 0 ` o O O 0 O O O O O O O O c1) COn eJ O ur 0 CO 0 CO M O M O C) Cf) O N N CO 1.0 N 0 0 N O O ro O O O N O O O O N O O O NY O O F- C > 0)Q) CO N O-0 C C U N LLJ > > U C C v) CD 0 O 1. c X y ll n. 0 m g Z C N C C N;35 10 co Ya ca J (n F- ° c F- EXPENDITURES: Materials & Services N O r- O) CO N O) O 0) 0 OD OD CO CO N- OD 1- ' CO CO N CO O TJ: M N OD N 0) M N ... ... ... CD r N 0 r` O) CO (V N N O) to OCf) O CD O) OD CD M CD N N- CO T M O M N O M N V' OD U) M Cf) M (V O) Co co O 0 0 0 M,- O 0 co O O O cD 0) O O 0) O O O ' M N O' O' N.: O) N Cf) OCD N N- co N O r` O) N N N N 0) Cl) CD CO OOD 1- r- M O M CO 0 CO N T- N 1 OD U) M Cl) M N 0) co co ,- O N O r` 0) N N N N O) U) 0 CO O) CO O) CO CO CO CD N r - N r- CO 0 CO N 0 CO N e- N d CD u) M Ct) M (V O) co co O OD OD CD CD116 co co CD N O l7) co 0) M ' CD N LO CO ('r) CO CD e - O CO N co O (V N CO OD M CD CO e - N 10 co M co. OD O) co CD N CD CO CD CD CV N Cf) CO M CD CD N CO1.0 C) CD CD L co E m U I CC E co O E N d co c 0 Z c CO 10 0) Cn u) .V CT C 0 3 .O (t) es °� :E) O H O O 0 To coy - ° u' civ ,112 C) N U • N a) A .0 N U c C cu C1 C d CD) .- ca OU . O` V N N N L '� '� o) c a cTri > °>.0 tel o c L 5 Q W W J d c LL d Q 5 2 I- L. ~ a 0 H~ 0 Transfer Out 0 M- O C O 0 M O Debt Service Fund co O O 0) N CD co N O O n O O 0 N O O O CO 0 O 1 l!) OD O fH UCU O ( a O O U C CO L c C6 NCO •- > CO C N CO •0 o) N, O CO fa9 N r c C C 0 S L C O (0 C U 0 O () E O 0 ° N O M Cn ° 00 a O N C f0 To u) CO , 0- c c O (1) M M O N co To O N N wO co co . V co a) NCD co N mo CI) XO 2 < o 0(fl c°� m(fl RESOURCES: Beg. Net Working Capital Revenues Grants - Private Lease Payments Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service: Interest Expense Interest Payment Deschutes County Bethlehem Inn (Fund 128) Eleven Months Ended May 31, 2011 Year to Date Budget Actual Variance FY Coll. % $ (2,725,000) $ 2,384,167 (2,722,510) $ 2,490 100% 100% $ (2,725,000) $ (2,722,510) $ 2,490 - (2,384,167) 83% 24,408 24,408 83% 0% 2,861,000 N/A 2,384,167 (340,833) 30,000 83,333 24,408 (2,384,167) 83% - (2,861,000) 24,408 24,408 1% 2,861,000 (2,698,102) (2,381,677) 83% -1984% 17,182 12,818 83% Exp. % - (2,861,000) 136,000 (2,722,510) (2,858,510) 48% a) 36,000 83,333 83% 0% TOTAL REQUIREMENTS 113,333 NET (Resources - Requirements) 17,182 96,152 83% 13% (454,167) (2,715,283) (2,285,525) a) Interest on May 2011 negative cash balance: $1,325.19 b) Inception through May 31, 2011 Revenues - Lease Payments $ 24,408 Expenditures: Land/Building (Amertitle) - July 2007 Hickman Williams City of Bend - May 2008 KN EX CO Kleinfelder Total expended on facility Interest on Negative Cash Balance Total expended 2,739,691 2,241,313 17,578 250,000 5,289 3,732 2,517,913 221,779 Net $ (2,715,283) b) 100,000 18,500 17,500 100,000 136,000 100,000 - (2,722,510) (2,758,510) Year End Budget Projection Variance 2,490 100% 100% $ (2,725,000) $ (2,722,510) $ 2,490 - (2,384,167) 83% 24,408 24,408 83% 0% 2,861,000 N/A 2,384,167 (340,833) 30,000 83,333 24,408 (2,384,167) 83% - (2,861,000) 24,408 24,408 1% 2,861,000 (2,698,102) (2,381,677) 83% -1984% 17,182 12,818 83% Exp. % - (2,861,000) 136,000 (2,722,510) (2,858,510) 48% a) 36,000 83,333 83% 0% TOTAL REQUIREMENTS 113,333 NET (Resources - Requirements) 17,182 96,152 83% 13% (454,167) (2,715,283) (2,285,525) a) Interest on May 2011 negative cash balance: $1,325.19 b) Inception through May 31, 2011 Revenues - Lease Payments $ 24,408 Expenditures: Land/Building (Amertitle) - July 2007 Hickman Williams City of Bend - May 2008 KN EX CO Kleinfelder Total expended on facility Interest on Negative Cash Balance Total expended 2,739,691 2,241,313 17,578 250,000 5,289 3,732 2,517,913 221,779 Net $ (2,715,283) b) 100,000 18,500 17,500 100,000 136,000 100,000 - (2,722,510) (2,758,510) Deschutes County Summary - Expenditures Compared to FY 2011 Budget FY 2011 Appropriations - M&S and Capital Outlay Expended to date in FY 2011 Remaining Appropriation Balance Due on Contracts Remaining Appropriation after contracts paid in full 39,040 641,135 680,174 FY 2011 Expenditures for other activities (a) 52,210 616,702 668,912 Remaining Appropriation after Contracts/Other (b) (13,170) 24,433 11,263 Additional Appropriation in Contingency and Reserve for Future Expenditures 274,011 551,196 825,207 "Area A" "Cell 5" Landfill Closure Fund 611 SW Capital Projects Fund _ 613 Total 817,210 436,648 2,578,638 3,395,848 1,806,022 2,242,670 380,562 772,616 1,153,178 341,522 131,482 473,004 a) Fund 611 FY 2011 Expenditures for other activities through April 30, 2011 are interfund loans totalling $52,210 for the Humane Society of Redmond. b) An appropriation transfer will be made prior to the end of the fiscal year. Engineering Contract G. Friesen Associates, Inc. Original Contract Change Orders: Change Order #1 (Note a) Change Order #2 Change Order #3 Total Contract Amount Paid Through June 30, 2010 July 1, 2010 through May 31, 2011 (Final payment made December 2010) Balance Due Deschutes County - Solid Waste Area A Closure and Cell 5 Construction As of May 31, 2011 DEQ requirement for gas detection LFG well field management SOPs Storm sewer realignment, drainage, Area A thickness Construction Contract M A DeAtley Construction Inc Original Contract - @ estimated cu.yd. Amended Contract - @ revised cu.yd. and damages Change Orders: Change Order #1 Meet CEC requirements, increase to electrical panel, Change Order #2 Storm sewer realignment due to refuse encountered Change Order #3 Revise valve vaults for improved efficiencies Change Order #4 Add'I cover material from what will be Cell 6 Change Order #5 Environmental controls building, pump station bulkheads Change Order #6 Adjustment to pipe alignment to increase slope 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 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 Change Order #14 Well modification, flow meter less LFG vaults Damages Total Contract Amount Paid Through June 30, 2010 July 1, 2010 through May 31, 2011 Balance Due Total of Engineering and Construction Contracts: Original Contracts Change Orders and Damages Total Contract Amount Paid Through June 30, 2010 July 1, 2010 through May 31, 2011 Balance Due "Area A" "Cell 5" Landfill Closure Fund 611 SW Capital Projects Fund 613 Total 241,869.00 182,516.00 424,385.00 19,656.00 21, 500.00 34, 316.00 33,431.00 19,656.00 21,500.00 67,747.00 317,341.00 215,947.00 533,288.00 254,413.44 62,927.56 153,904.42 62,042.58 408,317.86 124, 970.14 2,097,140.50 3,290,779.98 5,387,920.48 2,284,885.13 3,552,521.82 5,837,406.94 14,302.54 24,885.69 32,690.70 1,332.00 2,486.98 55,853.20 5,938.50 45,095.00 148,958.89 204, 700.00 5,167.76 2,200.00 6,354.75 (35,000.00) 45,095.00 14,302.54 24,885.69 32,690.70 148,958.89 1,332.00 204,700.00 2,486.98 5,167.76 2,200.00 6,354.75 55,853.20 5,938.50 (35,000.00) 2,422,374.74 3,929,998.22 6,352,372.95 1,707,132.00 2,054,537.51 3,761,669.51 373,720.63 1,743,978.95 2,117,699.58 341,522.11 131,481.76 473,003.86 2,526,754.13 3,735,037.82 6,261,791.94 212,961.61 410,907.40 623,869.01 2,739,715.74 4,145,945.22 6,885,660.95 1,961,545.44 2,208,441.93 4,169,987.37 436,648.19 1,806,021.53 2,242,669.72 341,522.11 131 ,481.75 473,003.86 Note: There will not likely be additional payments to M A DeAtley until Spring. The additional services are for landscaping and other weather sensitive activities. a) ca) Lu a) U � 0 F- m 9 C T N c a) 01 U C a C c I) o U n m O N o Co >- -8 L a• > LL N d a) 7 0 c ow 0 U ac) _c U E m cu cn N U C a) a) C O U a) C 0. .i w ip u) u) O r N F r CO 0 1- >- CCO o v O V VD N CO O (0 0 r (D' N O u) ' co a O ((7 V O'(0 (D O CO O (00) Lo N N.V 0) r'Nt N O N N r 'C) N 0 (D O to 0) co d) co `y V r N O u) c u) (c) u7 (0 N I."` 0 0) co ID CO U CO N Y) a) N O N CO ' c', (D U1 O z • (0 (D o (0 c) N 0) N C) N (7 V , V NI N. r O' O CO CO V7 O 0) • c7 N U1 (D V N 1. 0 N W V r N W V N N O CO N N r (c) r u) O O O i i i i co (NI V.W IV ()< M r • N V u7 r 0 NCD, n N ' c9 U1 O N u) U M V • N 0 n 0) LO u) (0 0 O N 0 01 (•) u7 N co W • O N O O N N (y i (D N N N c0 r N b N O N N u) O N N CI c' O co (0 c) H co co N N 0 0' e) 0 (D D 00 N u),W N'. N (+) r'O 1D' 1. O i W O (f) C) V sc V W co ,Lo W u-) V N V O N Is U1 CO W r (D r N 1- O N i "ct 10 V U1 c0 0 O' 1- 0) N u). CO 0) N U N 0) N N N u) 0) • co 0) u) CO ' ' IA u) N (D M O N W r M N O ' 0) o < O N O (t) N U1 N u) V N co Q1 u7 VPY) (f) V u) r Y) N N CO ID C) (D 1) ' u) CD rl I1) c) (h O u) O (c)' N N V (0 V ' V ' O N N N W 0 (f) N OD W (0 0 O c', 0) 0) 0) N O N (DIV N N 'D) N N r (D O O). 05•.6..., CC Y Nd p wC m ° N oa 0 c E am) 0 '' ' 0 U Da a 2 EG., I— m UOE� rnc Egct O.'�)O1- QEU1 '_ -Q< o m,r 1C 0 0 y LCA C C co m 0 0. m o, Q°° v E m c - oU N 0 N (o a`°i o 2 E 1 0 co 1— Q a: cu o. W O) O o a) N rn }. n LL CO o', 0 N. N `, LLLL d