Loading...
2005-1226-Minutes for Meeting May 25,2005 Recorded 11/1/2005DESCHUTES COUNTY OFFICIAL NANCY BLANKENSHIP, COUNTY COMMISSIONERS' JOURNAL 11111)[212d CLERKDS w 20WO 626 1110112005 01:30:37 PM DESCHUTES COUNTY CLERK CERTIFICATE PAGE This page must be included if document is re-recorded. Do Not remove from original document. Es C o { Deschutes County Board of Commissioners 1130 NW Harriman St., Bend, OR 97701-1947 (541) 388-6570 - Fax (541) 388-4752 - wwvc,.deschutes.orc MINUTES OF DEPARTMENT UPDATE — FINANCE/TAX DEPARTMENT DESCHUTES COUNTY BOARD OF COMMISSIONERS WEDNESDAY, MAY 259 2005 Commissioners' Conference Room - Administration Building - 1300 NW Wall St.., Bend Present was Commissioner Dennis R. Luke, Tom De Wolf and Michael Al Daly. Also present were Mike Maier, County Administrator; and Marty Wynne, Finance/Tax. No representatives of the media or other citizens were present. The meeting began at 9: 00 a.m., and a copy of the agenda is attached for reference. Regarding irrigation district water on the Brosterhous Road property, the Board took action after a brief discussion. DALY: Move that the irrigation water be returned. LUKE: Second. VOTE: LUKE: Yes. DALY: Yes. DEWOLF: Chair votes yes. The meeting adjourned at 9:45 a.m. DATED this 25th Day of May 2005 for the Deschutes County Board of Commissioners. Tom DeWolf, Commissioner ATTEST: Dennis R. Luke, C mmissioner Recording Secretary Board of Commissioners' Monthly Meeting Finance Director/Treasurer AGENDA May 25, 2005 (1) Monthly Financial Reports (2) Monthly Investment Report Memorandum Date: May 11, 2005 To: Board of County Commissioners Mike Maier, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find April 2005 financial reports for the following funds: General (001), Community Justice — Juvenile (230), Sheriff's (255), Health (259), Mental Health (275), Community Development (295), Road (325), Community Justice — Adult (355), Commission on. Children & Families (370-399), Solid Waste! (610), Health Benefits Trust Fund (675) and 9-1-1 (705). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads r � , RESOURCES: Beg. Net Working Capital Revenues Property Taxes Gen. Rev. - excl. Taxes Assessor County Clerk BOPTA Board of County Comm. District Attorney Finance/Tax Veterans Property Management Surveyor Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Assessor County Clerk BOPTA BOCC District Attorney Finance/Tax Veterans Property Management Surveyor Non -Departmental Contingency Transfers Out TOTAL REQUIREMENTS Appropriation Transfers NET (Resources - Requirements) GENERALFUND Statement of Financial Operating Data Ten Months Ended April 30, 2005 Year to Date Revised Year End $ Revised Bud Actual IVariance FY % Coll. % Budget Projection Variance Variance $4,700,000 $4,994,433 $ 294,433 100% 106% $4,700,000 $4,994,433 $ 294,433 6% 11,912,500 14,003,607 2,091,107 83% 98% 14,295,000 14,700,000 405,000 3% 1,392,148 1,589,055 196,907 83% 95% 1,670,578 1,670,578 - 0% 853,993 1,056,179 202,186 83% 103% 1,024,792 1,124,792 100,000 10% 1,154,583 1,818,211 663,628 83% 131% 1,385,500 2,185,500 800,000 58% 11,655 15,081 3,426 83% 108% 13,986 13,986 - 0q° - 202 202 83% n/a - 202 202 n/a 274,008 243,468 (30,540) 83% 74% 328,810 268,810 (60,000) -18% 181,208 235,627 54,419 83% 108% 217,450 247,450 30,000 14% 8,167 7,554 (613) 83% 77% 9,800 c1,800 - 0% 55,250 70,789 15,539 83% 107% 66,300 66,300 - 0% 155,833 188,767 32,934 83% 101% 187,000 190,000 3,000 2% 15,999,345 19,228,540 3,229,195 83% 100% -'. 19,199,216 20,477,418 1,278,202 7% 20,699,345 24,222,973 3,523,628 83% 101% 2,823,399 2,734,517 88,882 985,039 893,777 91,262 42,814 36,126 6,688 479,468 476,767 2,701 2,827,478 2,626,373 201,105 659,304 621,883 37,421 126,473 115,280 11,193 118,531 98,789 19,742 136,613 114,831 21,782 679,283 635,479 43,804 1,526,191 - 1,526,191 10,404,593 8,353,822 2,050,771 8,667,875 8,015,441 652,434 19,072,468 16,369,263 2,703,205 1,626,877 7,853,710 6,226,833 Beginning NWC per FY 05-06 Proposed Budget 23,899,216 25,471,851 1,572,635 83% 81% � 3,388,079 3,248,079 140,000 83% 76% 1,182,047 1,182,047 - 83% 70% 51,377 51,377 - 83% 83%': 575,361 575,361 - 83% 77% ; : 3,392,973 3,212,973 180,000 83% 79% 791,165 771,165 20,000 83% 76% ', 151,767 151,767 - 83% 69% ', 142,237 142,237 - 83% 70% 163,936 163.936 - 83% 78% : ' '' 815,140 815,140 - 83% n/a a) . 1,831,429 - 1,831,429 83% 67% 12,485,511 10,314,082 2,171,429 83% 77% 10,401,450 10,401,450 - 83% 72% ,- 22,886,961 20,715,532 2,171,429 b) 1,012,255 4,756,319 3,744,064 a) The Contingency in the Adopted budget was $2,252,265. The reduction of $420,836 is due to (1) transferring $323,001 of appropriation to other funds, (2) transferring appropriation to 'Transfers Out": Adult P & P - $22,300, CCF - $4,000, Victims Assistance - $46,935, Juvenile - $10,000 and Legal - $10,000, and (3) transferring appropriation to Finance/Tax - $4,600 b) The Unappropriated Ending Fund Balance in the Adopted Budget was $700,000. The increase of $312,255 is clue to transferring appropriation to (1) Adult P&P - $71,255, (2) CDD COPs Debt Service - $215,000, (3) Legal - $10,000, (4) County School Fund - $6,000 7% 4% 0% 0% 0% 5% 3% 0% 0% 0% 0% 100% 17% 0% 9% RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065 -Court Assess. Discovery Fee Food Subsidy Juvenile Crime Prevention Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous MIP Diversion Fees Interest on Investments Leases Total Revenues COMM JUSTICE -JUVENILE Statement of Financial Operating Data Ten Months Ended April 30, 2005 Year to Date Budget Actual I Variance FY % I Coil. 0/j $ 314,190 $ 199,202 $ (114,988) 100% 154,830 112,406 (42,424) 32,782 37,657 4,875 3,365 5,002 1,637 27,833 33,590 5,757 191,616 196,217 4,601 41,667 73,672 32,005 1,250 2,200 950 323,294 242,364 (80,930) 83,333 83,472 139 1,198 2,092 894 3,542 5,142 1,600 29,058 28,078 (980) 893,768 821,892 (71,876) 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% Transfers In -General Fund 4,090,866 4,092,533 1,667 83% Transfers In -Sheriff 43,750 39,375 (4,375) 83% TOTAL RESOURCES 5,342,574 5,153,002 (185,197) 83% REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services Materials and Services Capital Outlay Juvenile Resource Center Personal Services Materials and Services Contingency ear n Budget Projection Variance n/a a) $ 314,190 $ 199,202 $(114,988) 60% b). 185,796 154,808 (30,988) 96% 152,779 83% 39,338 42,146 2,808 124% 83 83% 4,038 6,488 2,450 101% ''c)' 33,400 42,033 8,633 85% d)`.`. 229,939 261,622 31,683 147% e); 50,000 85,000 35,000 147% f) 1,500 3,250 1,750 62% g),' 387,953 385,146 (2,807) 83% h)' 100,000 107,089 7,089 146% f) 1,437 2,500 1,063 121% f)" 4,250 6,432 2,182 81% 34,870 33,032 (1,838) 77% ;:; 1,072,521 1,129,546 57,025 4,909,039 52,500 6,348,250 4,909,039 - 52,500 - 6,290,287 (57,963) 1,837,214 1,795,951 41,263 83% 81 2,204,657 2,204,657 1,240,852 1,088,073 152,779 83% 73% j).. ;, 1,489,022 1,489,022 83 - 83 83% 0% `.` ,: 100 100 1,880,570 1,879,223 1,347 168,912 181,096 (12,184) 162,578 - 162,578 83% 83% 83% TOTAL REQUIREMENTS 5,290,209 4,944,343 345,866 83% NET (Resources - Requirements) 52,365 208,659 160,669 83%,,,ik; 89% :I) n/a 78% 2,256,684 2,281,122 202,694 207,694 195,093 - (24,438) (5,000) 195,093 6,348,250 13,182,595 165,655 107,692 107,692 Beginning NWC per FY 05-06 Proposed Budget 107,218= C a) Actual 'Beginning Net Working Capital' less than budgeted due to FY 03-04 expenditures related to employee reclass & temporary help greater than projected and a change to an interfund contract. b) Sex Offender Grant reduced by $20,542 due to projected extension to 12/31/05; JAI BG reduced by $10,446. c) Food Subsidy Revenues exceeding projections due to increased participation in Snack/Commodities Program. d) JCP costs reimbursed quarterly for Maplestar, a treatment foster care provider. Quarterly Reimbursements are $65,406. e) $83,572 Billed through 4/30/05. f) Year End Projections revised accordingly. g) Behavioral Rehabilitation Services billing through April totals $273,146, 1 % more than projected at 10 Months into the Fiscal Year. h) Level 7 funding reimbursed quarterly. Each quarter reimbursement is approx. $24,299. Revised YE projection to include Trillium Reimbursement for Aramark Food Expenses. Trillium obtained its own contract on 1/27/05. i) Additional $10,000 authorized by BOCC for JCJ Flex Funds j) Actual Expenditures to date do not include Accrued Liability for BRS WellSpring Program in the amount of $80,898. k) Resource Center On -Call is trending over budget due to turnover in both FT/PT, Employees, Additional Training, and Extended Vacations by FT Personnel. 1) Food and Medication Costs trending higher due to steady increase in the Average Daily Population in the Resource Center. SHERIFF Rev Detail Statement of Financial Operating Data Ten Months Ended April 30, 2005 Year to Date End RESOURCES: Budget Actual Variance FY % Coll. % Bud etro' TYear ectionj Variance Beg. Net Working Capital $1,028,628 $1,028,628 $ - 100% 100% $1,028,628 $1,028,628 $ - Revenues Tax Revenues- Current 9,958,348 11,968,749 2,010,401 83% 100% 11,950,018 12,550,018 600,000 Tax Revenues - Prior 338,833 281,704 (57,129) 83% 69% 406,600 306,600 (100,000) Federal Grants 56,250 89,603 33,353 83% 133% '' 67,500 .99,603 22,103 U.S. Forest Service 60,000 30,000 (30,000) 83% 42% 72,000 '72,000 - State Grant 96,290 66,557 (29,733) 83% 58% a) 115,548 94,192 (21,356) SB #1065 -Court Assess. 35,417 37,657 2,240 83% 89% 42,500 42,500 - Marine Board Lic. Fee 70,833 32,612 (38,221) 83% 38% b)+` 85,000 85,000 - Narcotic Task Force Grt. 91,667 110,000 18,333 83% 100% 110,000 1110,000 - Transp. of State Wards 2,500 3,172 672 83% 106% `. 3,000 5,000 2,000 SB 1145 1,083,106 1,170,158 87,052 83% 90% C) 1,299,727 1,560,212 260,485 City of Sisters 272,742 272,742 - 83% 83% 327,290 327,290 - Security & Traffic Reimb 100,167 19,848 (80,319) 83% 17% d)', 120,200 70,200 (50,000) Seat Belt Program 2,917 5,525 2,608 83% 158% 3,500 6,000 2,500 Inmate/Prisoner Housing 833 2,362 1,529 83% 236% 1,000 5,000 4,000 Contract Payments 14,347 - (14,347) 83% 0% e) 17,216 - (17,216) Inmate Commissary Fees 41,667 56,220 14,553 83% 112% 50,000 (36,000 16,000 Soc Sec Incentive -Fed 2,500 2,400 (100) 83% 80%,''" 3,000 3,000 - Miscellaneous 18,500 15,485 (3,015) 83% 70% 22,200 22,200 - Medical Services Reimb 10,000 12,216 2,216 83% 102% . ,° 12,000 15,000 3,000 Restitution 4,167 2,316 (1,851) 83% 46% 51000 5,000 - Sheriff Fees 122,500 96,606 (25,894) 83% 66% 147,000 147,000 - Court Fines and Fees 194,167 103,956 (90,211) 83% 45% f) 233,000 125,000 (108,000) Impound Fees 61,667 75,672 14,005 83% 102% 74,000 85,000 11,000 Interest 25,179 45,874 20,695 83% 152% 30,215 60,000 29,785 Interest on Unsegregated 2,078 4,545 2,467 83% 182% 2,493 6,000 3,507 Rentals 36,111 36,622 511 83% 85% 43,333 43,333 - Interfund Contract 351,855 243,742 (108,113) 83% 58% g) 422,226 322,226 (100,000) Transport Reimbursements 4,167 1,628 (2,539) 83% 33% 5,000 5,000 - Sale of Eqp & Material - 6,155 6,155 83% n/a - 6,155 6,155 Total Revenues 13,058,808 14,794,126 1,735,318 83% 94% 15,670,566 16,234,529 563,963 Transfers In 2,208,333 1,738,043 (470,290) 83% 66% 2,650,000 2,650,000 - TOTAL RESOURCES 16,295,769 17,560,797 1,265,028 83% 91% 19,349,194 19,913,157 563,963 REQUIREMENTS: exp °i° EXPENDITURES & TRANSFERS Sheriffs Division 1,029,883 1,095,438 (65,555) 83% 89% h), 1,235,859 1,361,538 (125,679) Automotive/Communications 729,320 792,992 (63,672) 83% 91°i° IJ,? 875,184 978,025 (102,841) Investigations/Evidence 1,333,895 1,388,534 (54,639) 83% 87% :j)a 1,600,674 1,665,116 (64,442) Patrol/Civil/Comm Supp 5,556,995 5,279,944 277,051 83% 79% k).' 6,668,394 6,435,783 232,611 Records 503,948 464,140 39,808 83% 77% I), 604,738 574,411 30,327 Adult Jail 5,312,803 5,017,352 295,451 83% 79% m) 6,375,364 6,129,989 245,375 Transport/Court Security 146,545 124,169 22,376 83% 71% n 175,854 151,999 23,855 Emergency Services 88,184 81,426 6,758 83% 77%. . ` 105,821 101,492 4,329 Special Services Division 347,943 328,207 19,736 83% 79% 417,532 425,756 (8,224) Training Division 125,223 144,363 (19,140) 83% 96%,o) 150,268 191,428 (41,160) Contingency 732,505 - 732,505 83% 0% 879,006 - 879,006 Transfers Out 217,083 247,375 (30,292) 83% 95% 260,500 260,500 - TOTAL REQUIREMENTS 16,124,327 14,963,940 1,160,387 83% 77% . 19,349,194 18,276,037 1,073,157 NET(Resources- Requirements) 171,442 2,596,857 2,425,415 - 1,63'7,120 1,637,120 Beginning NWC per FY 05-06 Proposed Budget E1,63'7,1201' Sheriff Notes Statement of Financial Operating Data Ten Months Ended April 30, 2005 a) Due to funding reductions at the Federal level the Local Law Enforcement Block Grant will be $21,356 less that budgeted. Year to Date variance due to timing of Emergency Planning Grant reimbursement. b) Marine Board billing is completed semi-annually in January and July. c) Reduction to Community Corrections funding has been fully restored statewide. Year End Projection revised to $1,560,212. d) US Forest Service reimbursement for fire overtime has not been required to date. Forecast has been reduced by $50,000. e) Other Mug Shot system users are paying maintenance directly to the vendors. f) Revenue not as high as anticipated due to personnel changes on traffic team. Revenue expected to increase as traffic team is fully staffed. Court Fines & Fees will be below budget by $108,000 at year end due to traffic team staffing shortages. g) Title II/III reimbursements are estimated to be $100,000 less than planned and will be unspent funds will carry over to next fiscal year. h) Year end projections included IT consultant for $68,800, additional bullet proof vests for $21,850 and productivity tools (PC's and office furniture) funded from contingency and savings in other areas. 1) Fuel costs (gasoline) is expected to be above plan by $10,000. Other expenditures for auto repair equipment, new car preparation and mobile communications equipment was funded with savings in other Divsions. j) Year end projections include Street Crimes unit startup costs and additional computer forensic equipment. k) Year end projections included $100,000 for additional patrol vehicles which are funded from savings due to delays in filling open positions in other Divisions. 1) Year end projections includes labor savings and spending less than planned for supplies and purchased services. m) Year end projections includes savings from delays in filling open positions partially offset by the the jail parking lot expansion project for $63,000 and new productivity tools (PC's and office furniture) n) Year end projections includes savings from delays in filling open positions and spending less than planned for office supplies. o) Contingency spending for safety equipment (training mats) and range improvements results in above plan spending in the Traning Division. i RESOURCES: Beg. Net Working Capital Revenues Medicare Reimbursement State Grant Child Dev & Rehab Center State Miscellaneous STARS Foundation OMAP Family Planning Exp Proj School Districts Contract Payments/ESD Miscellaneous Patient Insurance Fees Health Dept/Patient Fees Vital Records -Birth Vital Records -Death Interest on Investments Donations Interfund Contract Administrative Fee Total Revenues HEALTH Statement of Financial Operating Data Ten Months Ended April 30, 2005 Year to Date Year End Budet ActualVariance I FY % Coll. % Budget Projection Variance $ 663,322 $ 844,015 $ 180,693 100% 2,500 - (2,500) 1,084,148 954,613 (129,535) 26,492 24,321 (2,171) 109,508 91,614 (17,894) 4,500 2,612 (1,888) 144,792 171,917 27,125 380,833 296,204 (84,629) 8,667 15,739 7,072 54,229 37,879 (16,350) - 5,703 5,703 41,600 47,727 6,127 107,708 109,904 2,196 13,750 22,960 9,210 51,875 67,620 15,745 7,833 15,006 7,173 10,458 8,950 (1,508) 49,675 39,308 (10,367) - 6,000 6,000 2,098,568 1,918,077 (180,491) 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 127% 0% a)`,' 73% 77% 70% 48% 99% 65% b)' 151% 58% n/a 96% 85% '. 139% C),r 109% G) M 160% 71% 66% is n/a Y'.. 76% 'i Transfers In -General Fund 1,907,843 1,907,842 (1) 83% 83% TOTAL RESOURCES 4,669,733 4,669,934 201 83% 85% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS 2,855,396 2,689,676 165,720 83% 975,088 944,879 30,209 83% 58,824 49,474 9,350 83% 125,000 112,500 12,500 83% 294,872 - 294,872 83% 4,309,180 3,796,529 512,651 83% NET (Resources - Requirements) 360,553 873,405 512,852 Beginning NWC per FY 05-06 Proposed Budget ` Unappropriated Ending Fund Balance 663,322 $ 844,015 $ 180,693 3,000 1,300,978 31,790 131,410 5,400 173,750 457,000 10,400 65,075 49,920 129,250 16,500 62,250 9,400 12,550 59,610 2,518,283 1,318,523 31,790 121,300 5,400 193,000 349,000 18,000 65,075 5,703 52,000 129,611 26,000 75,000 17,000 9,700 52,410 7,200 2,476,712 2,289,411 2,289,411 5,471,016 5,610,138 (3,000) 17,545 (10,110) 19,250 (108,000) 7,600 2,080 361 9,500 12,750 7,600 (2,850) (7,200) 7,200 (47,274) 133,419 78% e);,3,426,475 3,253,600 172,875 81% 1,170,106 1,246,200 (76,094) 70% a)!- 70,589 49,600 20,989 75% 150,000 150,000 - n/a 353,846 - 353,846 73%- 5,171,016 4,699,400 471,616 300,000 910,738 605,035 C ; 908,990.= a) Medicare fees are collected as part of Patient Insurance Fees. b) Collection for patient fees lag one month. Family Planning reimbursements no longer include STD visits, which impacted revenue significantly. c) Increases in vital record fee rates, combined with the impact of population increases has resulted in higher vital record fees. MENTAL HEALTH Statement of Financial Operating Data Ten Months Ended April 30, 2005 r a) Beginning Net Working Capital higher than projected primarily due to $170,000 of restricted funds in the balance. These funds must be spent this fiscal year or be returned to the State. b) Mental Health has been running an average vacancy rate of 5-6 FTE for 2004/05. c) Revenues generated by billings to other government agencies. Billings and payments lag behind normal schedule the first 9 months of fiscal year. Full amount budgeted expected to be received. d) Grant for $25,000 approved subsequent to 2004/05 budget adoption. e) Non -OHP client revenues have been very high for fiscal year 2004/05. Adjustments are reflected in the 2005/06 budget. f) School District contracts are paid at the end of their first quarter. Mental Health services to the schools begins in September and billing commences at the end of October. Will typically always be 1 or 2 payments behind. g) Growth of cash balance, due to new revenues and a reduced work week for most staff, has contributed to higher interest earnings than expected. h) Result of conscious decision to direct more ABHA funds to this area of need. i) Not spending about $105,000 set aside as a type of contingency for possible cost over -runs at Sage View. Year to Date Year End RESOURCES: Budget Actual Variance FY % Coll. % Budget Projection Variance Beg. Net Working Capital $1,402,580 $ 1,634,080 $ 231,500 100% 117% a);;;, $1,402,580 $1,634,080 $ 231,500 Revenues Marriage Licenses 4,583 4,220 (363) 83% 77% 5,500 5,137 (363) Divorce Filing Fees 83,333 91,207 7,874 83% 91% 100,000 107,874 7,874 Federal Grants 82,842 - (82,842) 83% 0% c) , 99,410 99,410 - State Grants 7,097,136 7,176,621 79,485 83% 84% , 8,516,563 8,584,804 68,241 State Miscellaneous 341,406 278,823 (62,583) 83% 68% _c) 409,687 409,687 - ABHA-Inpatient 107,658 117,393 9,735 83% 91% 129,189 129,189 - Title 19 95,538 242,524 146,986 83% 212% e) 114,645 261,632 146,987 Liquor Revenue 71,667 61,530 (10,137) 83% 72% 86,000 86,000 - ABHA Client Support Funds 12,500 25,000 12,500 83% 167% h) .' 15,000 30,000 15,000 School Districts 202,500 87,150 (115,350) 83% 36% f), 243,000 243,000 - Mental Health Jail Comp 6,367 6,000 (367) 83% 79% 7,640 7,273 (367) Miscellaneous 38,125 50,765 12,640 83% 111% d)' 45,750 70,750 25,000 Patient Insurance Fees 108,298 182,726 74,428 83% 141% e) 129,957 204,386 74,429 Patient Fees 13,684 12,263 (1,421) 83% 75% 16,421 14,716 (1,705) Interest on Investments 25,000 46,533 21,533 83% 155% g) y 30,000 55,840 25,840 Rentals 13,333 13,378 45 83% 84% 16,000 16,000 - Donation - 100 100 83% n/a . a' - 100 100 Interfund Contracts 47,423 43,440 (3,983) 83% 76% � ' w 56,907 62,024 5,117 Administrative Fee 2,052,519 2,040,857 (11,662) 83% 83% 2,463,023 2,463,023 - Total Revenues 10,403,912 10,480,530 76,618 83% 84% -; 12,484,692 12,850,845 366,153 Transfers In -General Fund 783,935 783,935 - 83% 83% - ' 940,722 940,722 - Transfers In -Other 333,333 333,333 - 83% 83% .`: 400,000 400,000 - TOTAL RESOURCES 12,923,760 13,231,878 308,118 83% 87% 15,227,994 15,825,647 597,653 REQUIREMENTS: Exp % Expenditures , Personal Services 4,855,598 4,588,501 267,097 83% 79% b) { 5,826,717 5,559,501 267,216 Materials and Services 6,295,645 6,090,391 205,254 83% 81% i) °_ 7,554,774 7,428,895 125,879 Capital Outlay 8,333 - 8,333 83% 0% 10,000 5,000 5,000 Transfers Out 125,000 112,500 12,500 83% 75% 150,000 150,000 - Contingency 1,405,419 - 1,405,419 83% n/a 1,686,503 - 1,686,503 TOTAL REQUIREMENTS 12,689,995 10,791,392 1,898,603 83% 71% 15,227,994 '13,143,396 2,084,598 NET (Resources - Requirements) 233,765 2,440,486 2,206,721 - 2,682,251 2,682,251 Beginning NWC per FY 05-06 Proposed Budget r,.7,�q: �y :� a) Beginning Net Working Capital higher than projected primarily due to $170,000 of restricted funds in the balance. These funds must be spent this fiscal year or be returned to the State. b) Mental Health has been running an average vacancy rate of 5-6 FTE for 2004/05. c) Revenues generated by billings to other government agencies. Billings and payments lag behind normal schedule the first 9 months of fiscal year. Full amount budgeted expected to be received. d) Grant for $25,000 approved subsequent to 2004/05 budget adoption. e) Non -OHP client revenues have been very high for fiscal year 2004/05. Adjustments are reflected in the 2005/06 budget. f) School District contracts are paid at the end of their first quarter. Mental Health services to the schools begins in September and billing commences at the end of October. Will typically always be 1 or 2 payments behind. g) Growth of cash balance, due to new revenues and a reduced work week for most staff, has contributed to higher interest earnings than expected. h) Result of conscious decision to direct more ABHA funds to this area of need. i) Not spending about $105,000 set aside as a type of contingency for possible cost over -runs at Sage View. COMMUNITY DEVELOPMENT Statement of Financial Operating Data Ten Months Ended April 30, 2005 RESOURCES: Budget Variance Total Revenues 4,900,168 Year to Date 820,443 83% 97%_ Year End 6,886,740 1,006,538 Budget Actual Variance FY % Coll. % 0% Projection - (100) Trans In -CDD Bldg/Elec - - - 83% 0% 200 - Beg. Net Working Capital $ 1,135,377 $ 1,135,377 - 100% n/a 98% $1,135,377 $1,135,377 - Revenues REQUIREMENTS: Exp. Admin -Operations 29,333 100,948 71,615 83% 287% a),:' 35,200 117,000 81,800 Admin -GIS 10,833 10,461 (372) 83% 80% 80%,'. 13,000 12,550 (450) Admin -Code Enforcement 203,625 239,199 35,574 83% 98% b) 244,350 287,000 42,650 Building Safety 1,597,738 1,775,842 178,104 83% 93% b) 1,917,285 2,131,000 213,715 Electrical 418,542 469,457 50,915 83% 93% b)- 502,250 563,000 60,750 Contract Services 502,183 832,353 330,170 83% 138% b) 602,620 1,040,000 437,380 Env Health -On Site Prog 581,683 609,072 27,389 83% 87% 81% 698,020 731,000 32,980 Env Health-Lic Facilities 320,313 406,724 86,411 83% 106% c)- 384,375 413,000 28,625 Env Health -Grant 98,333 50,170 (48,163) 83% 43%' d•);- 118,000 105,500 (12,500) Env Health - Drinking H2O 33,475 45,690 12,215 83% 114% e):' 40,170 45,690 5,520 Planning -Current 711,604 797,380 85,776 83% 93% b),'853,925 957,000 103,075 Planning -Long Range 392,506 383,315 (9,191) 83% 81% 82% 471,007 484,000 12,993 Budget Variance Total Revenues 4,900,168 5,720,611 820,443 83% 97%_ 5,880,202 6,886,740 1,006,538 Trans In -CDD Reserve - - - 83% 0% 100 - (100) Trans In -CDD Bldg/Elec - - - 83% 0% 200 - (200) TOTAL RESOURCES 6,035,545 6,855,988 820,443 83% 98% 7,015,879 8,022,117 1,006,238 REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Admin -Operations Division 2,558,880 2,454,713 104,167 83% 80%,'. 3,070,656 2,762,000 308,656 Admin -GIS Division 140,586 138,764 1,822 83% 82%,:.' 168,703 168,000 703 Admin -Code Enforcement 126,703 128,433 (1,730) 83% 84% 152,044 158,000 (5,956) Building Safety Division 770,336 762,239 8,097 83% 82% 924,403 893,000 31,403 Electrical Division 281,127 301,832 (20,705) 83% 89%, f)f) 337,352 351,500 (14,148) Contract Services 293,769 287,263 6,506 83% 81% 352,523 340,000 12,523 Env Health -On Site Pgm 311,102 288,884 22,218 83% 77% 373,322 372,000 1,322 Env Health-Lic Facilities 259,998 246,007 13,991 83% 79% 311,997 311,000 997 Env Health -Grant Division 79,601 42,131 37,470 83% 44% e) 95,521 84,000 11,521 Env Health - Drinking H2O 36,529 35,847 682 83% 82% 43,835 44,000 (165) Planning -Current Division 650,096 641,319 8,777 83% 82% 780,115 774,000 6,115 Planning -Long Range Div 337,840 363,458 (25,618) 83% 90% g)' 405,408 438,000 (32,592) TOTAL REQUIREMENTS 5,846,567 5,690,890 155,677 83% 81%, 7,015,879 6,695,500 320,379 NET(Resources- Requirements) 188,978 1,165,098 976,120 - 1,326,617 1,326,617 Beginning NWC per FY 05-06 Proposed Budget 1 66:053M I F,4 a) Increased amount is due to 1) revenue associated with a new addressing services contract with the City of Redmond, 2) Higher than expected fund balance which generated additional interest earnings, and 3) Road access permits higher than expected. b) Seasonal volume -permit volume higher in warmer months. Year-end totals projected to be higher than expected. c) Licensed Facility revenue is primarily received in January/February after license renewal notices are issued. d) EPA grant bills typically lag behind billing 2-3 months, although revenue/expense will be lower than budgeted. e) Revenue is received in lump payments --year end estimate has been modified based on experience. f) Expenses high due to use of part time extra help to meet demand. g) Expenses high due primarily to expenses tied to previously received grant funds (tree thinning). RESOURCES: Beg. Net Working Capital Revenues Forest Receipts Federal Mineral Leases Motor Vehicle Revenue City of Bend City of Redmond City of Sisters Miscellaneous Fees Miscellaneous Road Vacations Interest on Investments Interfund Bldg Rentals Donations Equipment Repairs Vehicle Repairs LID Construction Vegetation Management Sale of Eqp & Material Sale of Public Lands Total Revenues ROAD Statement of Financial Operating Data Ten Months Ended April 30, 2005 Year to Date Year End Budget Actual I Variance FY % I Coll. % Budget Projection Variance $ 4,992,257 $ 5,475,344 $ 483,087 100% 110% $ 4,992,257 $ 5,475,344 $ 483,087 2,466,667 2,967,469 500,802 83% 100% : a) 2,960,000 2,967,469 7,469 - 2,177 2,177 83% n/a 46,958 2,177 2,177 5,833,333 6,215,047 381,714 83% 89% 7,000,000 7,200,000 200,000 41,667 70,255 28,588 83% 141% . b) 50,000 80,000 30,000 166,667 261,511 94,844 83% 131%` .b) ;, 200,000 380,000 180,000 - 39,998 39,998 83% n/a 39,998 39,998 26,667 - (26,667) 83% 0% 32,000 - (32,000) 26,667 55,691 29,024 83% 174% 32,000 60,000 28,000 1,667 1,500 (167) 83% 75%;` 2,000 2,000 - 50,000 105,834 55,834 83% 176% 60,000 120,000 60,000 12,500 19,590 7,090 83% 131% 15,000 23,508 8,508 2,000 2,684 684 83% x; 112% 2,400' 2,684 284 166,667 179,349 12,682 83% 90%,', c Y 200,000 200,000 - 58,333 - (58,333) 83% 0% d). ` 70,000 78,000 8,000 83,333 - (83,333) 83% 0% ej 100,000 45,000 (55,000) 25,000 6,423 (18,577) 83% 21%',� 30,000 15,000 (15,000) 204,167 228,338 24,171 83% 93% ° cf 245,000 245,000 - 417 443 26 83% 89%,"7-, 500 443 (57) 9,165,752 10,156,309 990,557 83% 92% 10,998,900 11,461,279 462,379 Transfers In -Road Imprvmt 290,000 290,000 - 83% 67% fl Expenditures TOTAL RESOURCES 14,448,009 15,921,653 1,473,644 83% REQUIREMENTS: 4,272,702 4,214,985 57,717 67% fl Expenditures 6,680,790 (367,809) 1%)',, 4,125,760 Personal Services 3,560,585 3,513,627 46,958 83% Materials and Services 5,260,818 4,204,659 1,056,159 83% Capital Outlay 3,438,133 58,398 3,379,735 83% Transfers Out 725,000 870,000 (145,000) 83% Contingency 583,095 - 583,095 83% TOTAL REQUIREMENTS 13,567,631 8,646,684 4,920,947 NET (Resources - Requirements) 880,378 7,274,969 6,394,591 Beginning NWC per FY 05-06 Proposed Budget 83% 100%.>;; 290,000 290,000 - 89%` 16,281,157 17,226,623 945,466 Exp. 82% 4,272,702 4,214,985 57,717 67% fl 6,312,981 6,680,790 (367,809) 1%)',, 4,125,760 611,500 3,514,260 100%: 870,000 870,000 - n/a 699,714 - 699,714 53% 16,281,157 12,377,275 3,903,882 - 4,849,348 4,849,348 a) Forest Receipts, received in December, exceeded amount estimated in FY 04-05 Budget. b) Bills are issued on completion of work. Revenue is higher than anticipated. c) County departments billed monthly in arrears. d) Revenue to be received in June 2005 from 340 fund. e) Revenue to be received in June 2005 from 430 fund. f) Gas prices and asphalt prices have increased substantially. g) Capital projects to be paid at completion. ADULT PAROLE & PROBATION Statement of Financial Operating Data Ten Months Ended April 30, 2005 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 1,749,936 1,650,596 99,340 83% 434,734 438,843 (4,109) 83% 83 - 83 83% 53,988 - 53,988 83% 2,238,741 2,089,439 149,302 83% 80,716 204,594 123,878 Beginning NWC per FY 05-06 Requested Budget j Year to Date 79% ', -,' 2,099,923 Revised Year End 84% RESOURCES: Budget Actual Variance FY % Coll. - Budget Proection Variance Beg. Net Working Capital $ 413,036 $ 424,448 $ 11,412 l00% 103% 164,709 $ 413,036 $ 424,448 $ 11,412 Revenues 254,643 254,643 ~200;000 State Grant 1,488,094 1,430,193 (57,901) 83% 80% a) 1,785,713 1,906,924 121,211 State Miscellaneous 9,439 10,006 567 83% 88%- 11,327 11,327 Probation Work Crew Fees 9,883 27,616 17,733 83% 233% b),' 11,859 29,000 17,141 Alcohol and Drug Treatment 667 604 (63) 83% 76% 800 800 Miscellaneous 7,583 11,362 3,779 83% 125%. c); 9,100 12,000 2,900 Electronic Monitoring Fee 152,500 92,180 (60,320) 83% 50% ',d). 183,000 108,000 (75,000) Probation Superv. Fees 145,833 180,329 34,496 83% 103%,': 175,000 185,000 10,000 Cognitive Program - 70 70 83% n/a - 70 Sex Offender Treatment Fees 1,667 424 (1,243) 83% 21%, 'd)'" 2,000 600 70 (1,400) Day Reporting Fees 2,500 430 (2,070) 83% 14% `d):' 3,000 500 (2,500) Interest on Investments 3,000 8,671 5,671 83% 241% 3,600 10,000 6,400 Leases 11,000 12,900 1,900 83% 98% ,' 13,200 15,000 1,800 Rentals 3,000 1,245 (1,755) 83% 35% e) 3,600 1,500 (2,100) Interfund Contract 71,255 71,255 - 83% 100%'f) - 71,255 71,255 Total Revenues 1,906,421 1,847,285 (59,136) 83% 81%, � "' 2,273,454 2,351,976 78,522 Transfers In -General Fund - 22,300 22,300 83% n/a _ 22,300 22,300 TOTAL RESOURCES 2,319,457 2,294,033 (25,424) 83% 85% �`"; 2,686,490 2,776,424 89,934 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 1,749,936 1,650,596 99,340 83% 434,734 438,843 (4,109) 83% 83 - 83 83% 53,988 - 53,988 83% 2,238,741 2,089,439 149,302 83% 80,716 204,594 123,878 Beginning NWC per FY 05-06 Requested Budget j $8.9 million restored statewide to community corrections resulting in an approximate $300,000 increase for Deschutes County to be divided between Parole and Probation and the Sheriffs Office. More offenders than anticipated being assigned work crew/community service. Unexpected vehicle sale. Revenue lower than anticipated. Revenue lower than anticipated. Full amount budgeted may still be received. Appropriation Transfer from General Fund was required to allow for the expenditure of the un -budgeted resource received from Risk Management related to general liability settlement. 79% ', -,' 2,099,923 2,000,000 99,923 84% 521,681 521,681 - 0% 100 100 - n/a 64,786 - 64,786 78% 2,686,490 2,521,781 164,709 - 254,643 254,643 ~200;000 $8.9 million restored statewide to community corrections resulting in an approximate $300,000 increase for Deschutes County to be divided between Parole and Probation and the Sheriffs Office. More offenders than anticipated being assigned work crew/community service. Unexpected vehicle sale. Revenue lower than anticipated. Revenue lower than anticipated. Full amount budgeted may still be received. Appropriation Transfer from General Fund was required to allow for the expenditure of the un -budgeted resource received from Risk Management related to general liability settlement. RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Child Care Block Grant Level 7 Services Juvenile Crime Prevention State Prevention Funds HealthyStart /R -S -G OCCF Grant Lottery Grant Sale Map Photo or Copies Miscellaneous Interest on Investments Grants -Private Total Revenues Comm. on Children & Families Statement of Financial Operating Data Ten Months Ended April 30, 2005 Year to Date Year End Budget Actual I Variance I FY % Coll. % Budget Projection Variance $ 519,640 $ 642,357 $ 122,717 100% 121,422 80,000 (41,422) 29,662 35,594 5,932 166,667 149,745 (16,922) 44,494 28,362 (16,132) 146,276 175,533 29,257 283,925 237,457 (46,468) 65,113 59,101 (6,012) 187,612 130,582 (57,030) 292,949 339,520 46,571 - 6,234 6,234 - 2,403 2,403 14,167 17,848 3,681 10,000 16,149 6,149 16,385 7,800 (8,585) 1,378,672 1,286,328 (92,344) 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% n/ 83% 83% 83% 83% 124% z $ 55% 100% 75% 53% 100% 70% 76% 58% a) 97% `b)'_ a n/a 105% `: 17,000 135% 12,000 40% 191662 1,654,404 519,640 $ 642,357 $ 122,717 145,706 35,594 200,000 53,393 175,531 340,710 78,135 225,134 351,539 145,706 35,594 200,000 53,393 175,533 340,710 78,135 130,582 339,520 6,234 2,403 18,000 21,000 7,800 1,554,610 2 (94,552) (12,019) 6,234 2,403 1,000 9,000 (11,862) (99,794) Trans from General Fund 333,333 337,334 4,001 83% 84% 400,000 400,000 - Trans from Other 147,083 132,375 (14,708) 83% 75%, 176,500 176,500 - Total Transfers In 480,416 469,709 (10,707) 83% 81% ; <`k 576,500 576,500 - TOTAL RESOURCES 83% 87% 2,378,728 2,398,394 19,666 2,750,544 2,773,467 22,923 REQUIREMENTS: Exp Expenditures Personal Services 336,462 331,826 4,636 83% 82% c) 403,754 402,995 759 Materials and Services 1,680,898 1,361,551 319,347 83% 68% d:)'- 2,017,077 1,801,102 215,975 Capital Outlay 7,083 4,546 2,537 83% 53% 8,500 8,500 - Contingency 267,678 - 267,678 83% n/a 321,213 - 321,213 TOTAL REQUIREMENTS 2,292,121 1,697,923 594,198 83% 62%, 2,750,544 2,212,597 537,947 NET (Resources - Requirements) 86,607 700,471 613,864 - 560,870 560,870 Beginning NWC per FY 05-06 Requested Budget 560;870' a) Second year of biennium for HealthyStart general funds are being reduced for Federal Medicaid match. b) Crisis Nursery funds reduced in second year of biennium. c) Personnel projection increased due to Director position being filled. d) Materials & Services projection reduced by $110,000 for Medicaid match. RESOURCES: Beg. Net Working Capital Revenues State Grant Miscellaneous Franchise 3% Fees Commercial Disp. Fees Private Disposal Fees Franchise Disposal Fees Yard Debris Special Waste Interest Sale of Equip & Material Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS SOLID WASTE Statement of Financial Operating Data Ten Months Ended April 30, 2005 Year to Date Year End Budget Actual Variance I FY % Coll. % Budget Projection Variance $1,142,974 $ 1,665,740 $ 522,766 100% 146% $1,142,974 $ 1,665,740 $ 522,766 44,250 - (44,250) 83% 0% a) 53,100 28,100 (25,000) 19,167 20,283 1,116 83% 88% 23,000 24,000 1,000 100,000 159,414 59,414 83% 133% b) 120,000 159,414 39,414 666,667 827,857 161,190 83% 103% g), 800,000 1,000,000 200,000 1,312,500 1,420,994 108,494 83% 90% 1,575,000 1,723,000 148,000 3,208,333 3,233,629 25,296 83% 84% 3,850,000 3,950,000 100,000 20,833 34,257 13,424 83% 137% c)' 25,000 40,000 15,000 20,833 52,449 31,616 83% 210% d),y 25,000 55,000 30,000 25,000 41,035 16,035 83% 137% t 30,000 44,000 14,000 12,500 49,830 37,330 83% 332% e)' 15,000 52,000 37,000 5,430,083 .5,839,748 409,665 83% 90% 6,516,100 7,075,514 559,414 6,573,057 7,505,488 932,431 83% 98% 7,659,074 8,741,254 1,082,180 1,105,869 1,102,570 3,299 83% 83% 1,327,043 1,324,531 2,512 2,623,723 1,979,788 643,935 83% 63% f) 3,148,468 2,678,869 469,599 381,028 381,028 - 83% 100% 381,028 381,028 - 103,542 119,491 (15,949) 83% 96% 124,250 124,402 (152) 1,750,000 1,225,000 525,000 83% 58% g), 2,100,000 2,850,000 (750,000) 481,904 - 481,904 83% n/a 578,285 - 578,285 6,446,066 4,807,877 1,638,189 83% 63% 7,659,074 7,358,830 300,244 NET (Resources - Requirements) 126,991 2,697,611 2,570,620 - 1,382,424 1,382,424 Beginning NWC per FY 05-06 Proposed Budget V., 4,17A n•in- a) Grant monies generally received after projects are completed. b) Franchise revenues are up due to continued growth in County. c) Seasonal revenues. d) Local clean up projects unanticipated. e) High return on sale of recylables at present time. f) Many larger expenditures in M&S have not been done i.e. engineering, and special waste events. g) Deficit to made up by an appropriations transfer from contingency and excess M & S. RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges P/T Emp - Add'I Prem Employee Prem Contribution COIC Retiree / COBRA Co -Pay Medical Service Reimb Interest Prescription Rebates Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures: Personal Services Materials & Services Conferences and Seminars Claims Paid-Medical/Rx Claims Paid-Dental/Vision Insurance Expense State Assessments Administrators West PPO Fee Printing Program Expense/Supplies Refunds Other Total Materials & Services Capital Outlay Trans Out -Insurance Fund Contingency TOTAL REQUIREMENTS Health Benefits Trust Statement of Financial April 2005 Revised Year End Budget Actual Variance I FY %Coll. % Budget ProjectionVariance 632,041 658,737 26,696 13,045 11,768 (1,277) 24,333 26,285 1,952 48,963 99,430 50,467 34,300 33,111 (1,189) 0 - 587,556 2,333 9,812 7,479 - 2,578 2,578 755,015 841,721 86,706 755,015 841,721 86,706 $ 3,057,642 $ 3,057,642 8% 9% 7,584,487 7,684,487 100,000 8% 8% 156,545 156,545 - 8% 9% 292,000 292,000 - 8% 17% 587,556 587,556 - 8% 8% 411,601 411,601 - 8% n/a - 50,000 50,000 8% 35% 28,000 78,000 50,000 8% n/a - 20,859 20,859 8% 9% 9,060,189 9,281,048 220,859 8% 7% 12,117,831 12,338,690 220,859 9,245 9,623 (378) 8% 250 280 (30) 8% 597,015 614,259 (17,244) 8% 99,007 - 99,007 8% 25,368 26,529 (1,161) 8% 2,656 - 2,656 8% 13,599 14,298 (699) 8% 2,517 2,488 29 8% 1,894 137 1,757 8% 325 - 325 8% - 35,252 (35,252) 83% 906 1,201 (295) 8% 743,537 694,444 49,093 8% 8 - 8 8% 420,000 - 420,000 108% 222,030 - 222,030 (18,759) 974,820 704,067 270,753 8% NET (Resources - Requirements) (219,805) 137,654 357,459 110,935 110,935 - 9%1"_'-_"'_-",,3,000 3,000 - >,. 9% a)b} 7,164,174 5,619,143 1,545,031 0%'a)b)j 1,188,082 1,083,739 104,343 9%1" 304,419 304,419 - 0%.:c)n z 31,874 34,901 (3,027) 9% 163,188 163,188 - 8% 30,200 30,200 - 1% 22,728 22,728 - 0% 3,898 3,898 - n/a,d);. - 35,252 (35,252) 11% 10,876 29,635 (18,759) 8%> 8,922,439 7,330,103 1,592,336 0% 100 100 - 0% d): 420,000 420,000 - 2,664,357 - 2,664,357 6% 12,117,831 7,861,138 4,256,693 - 4,477,552 4,477,552 a) Year End Projection: 43 weeks of claims annualized equals $5,619,143 for Medical/Rx and $1,083,739 for Dental/Vision. b) Revised Budget of $8,352,256: $7,164,174 Aggregate Stop -Loss ($1.0 million limit) for medical & pharmacy drugs; $1,188,082 budget for dental and vision claims. c) State Assessments: August=$13,966.64; January=$20,934.15 d) Repayment of reserves, plus accrued interest, to COIC and Insurance Fund. RESOURCES: DESCHUTES COUNTY 911 Statement of Financial Operating Data Ten Months Ended April 30, 2005 Year to Date Year End Budget Actual Variance I % of FY % Coll. Budget Projection Variance Beg. Net Working Capital $ 600,000 $1,230,708 $ 630,708 Revenues Property Taxes - Current 2,333,333 2,753,635 420,302 Property Taxes - Prior 50,000 66,793 16,793 State Reimbursement 2,500 17,311 14,811 Telephone User Tax 433,333 302,276 (131,057) Data Network Reimb. 20,833 27,437 6,604 Jefferson County 16,667 27,637 10,970 Alarm Monitoring Fees 5,000 6,960 1,960 User Fee 16,667 6,497 (10,170) Miscellaneous 3,750 5,922 2,172 Interest 8,333 29,278 20,945 Interest on Unsegregated Tax 583 1,051 468 Total Revenues 2,890,999 3,244,797 353,798 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS 3,490,999 4,475,505 984,506 1,975,130 1,822,652 152,478 444,867 468,034 (23,167) 413,961 302,548 111,413 108,333 - 108,333 448,709 - 448,709 3,391,000 2,593,234 797,766 NET (Resources - Requirements) 99,999 1,882,271 1,782,272 Beginning NWC per FY 05-06 Proposed Budget 100% 205% 2,370,156 $ 600,000 $1,230,708 $ 630,708 83% 98% ".' 2,800,000 2,897,190 97,190 83% 111% 193,753 60,000 75,286 15,286 83% 577%,3,000 83% n/a 18,500 15,500 83% 58% a)". 520,000 600,000 80,000 83% 110% - 25,000 28,000 3,000 83% 138% . 20,000 28,000 8,000 83% 116% ._ 6,000 6,960 960 83% 32% 20,000 6,497 (13,503) 83% 132%3$ 4,500 6,100 1,600 83% 2930% 10,000 31,000 21,000 83% 150%f 700 1,051 351 83% 94% 3,469,200 3,698,584 229,384 83% r 110% 4,069,200 4,929,292 860,092 83% 77% -"," 2,370,156 2,180,250 189,906 83% 88% 533,841) 533,840 - 83% 61%, 496,753 303,000 193,753 83% 0% 130,000 130,000 - 83% n/a 538,451 - 538,451 83% 64% 4,069,200 3,147,090 922,110 - 1,782,202 1,782,202 a) Distribution of telephone tax occurs quarterly. Actual to Date does not include 3rd and 4th quarter. 3 LL L 10 N O cc U N o O o O m Q O O L W I m Np o L ILN N N Oo X. -"7p W o 1 T Q IQQ� N 4 ~ Z t�Q O aNi 0)LU U �O 0 T d L o O t o M 0 N O n O V O M ■ 0 7 Ito!O oo VIN iO) et OI 10IV N 0'� 0 co 00 M C N M O H O M ' N O't0 I10 V 0 Qf I ItA N INTO O l l' QO N op NICO N N I� v M V App SIM iO M I 000 �r-!a0 O to M IOD O opO I L. ' , ' O tJN1 NI i O .N... �V OIaOV �o0VIOOM'V ItOI V'IN OI10 V1oD1510 N COIN Ni(O!�i�i I I C'! L,)! :1117 O M I H co C C l(J O+ d N U M I�IN co 'D O O r OIM SIC' � � t��t01 I t�I TI O M oD I'- O O O ' '.M p 7 O N I cO N Lo l- N In ao uD In 'O I V I LL'i I Qi O 10 O M O O O I� Q a OI 1 V Ni M co 'oOIO V VI IMI CO CO V V c l- m it i� IO I ISI I�^I iv �I I cu vl la t0 O O O 0 0 0 0 0 42), o 0 0 0 O O O O O O O O O O O O O O O O O O O O V O O 10 m O V O V V 0 n O N V- n O OD O ONp OOO p 'j M t0 V N In r M 1(j V T V'M O M MLL O O N % m /N o0 7 N O I� � V i O O0 0 0 0 0 0 010 N n O 0 0 0 0 ` V 0 0 0 t Na) N 0) p COp0 N c O t0 ' M In O O - O O M tj! 10 t` ' M I CO)CD t0 O LQ N 04O O ' ' INf! t0 O n oD M 0) C\1 N C\1 o7 I to h I N c0'1 co f- I O r ], O O O O O M V O O O O N O n Co M 10 ' U7 l0 ' V ' N m O M O I co M N V n V 11J (NO N LL N' N 01 O3 V -O' O V 00 O-:''_ti10 '.�V.V N y�j O' t0 lq: O O.-0,hr ll7 c.OOO0D W - U O .� N O 0 10L' ' V V' V tD [D �. 'OD 4 co _Q (1) C N K = 0 0 L� 00 M In N O O. C6 In ti ca V N .. co ��.�, V Oa N M M �e c ,� Cl) O co V O O O N M ..:., O 7 ._ ,. = C2N N V h 0 0 100 V O O O O ' V N o0 LO co V 0I �' t� pOp ao co O Cl) O 2 Q V 00 N O co 0 N M M N N LO oN0 10 tN�f Cl) co O o oo O t0 00 O N 01 n 1N an0 (00_ ' O 7 ' V 11) N -- LLOD I� IN0 opo p O CN4 O ca LO 07 .- V .-- O -00eM- N N .- ^ C" N ti co c A O N OO tD n 0 0 O M O O C-4 N O 0 N M to IM ' .0 N N MC'i V a M N C -4 O N LL tD tOD LO pN N O m 0 0 fD N to 0 W h 0 O 1(7 O o0 OD Of 00 O N O N M c07 V 1( W W o00 ' 1 1 1N0 O r.- 0 0 V O O M M N N N co m t0 U 1m M N 10 M 7 tq tNp mo r- o co 0 o o 0 O V O Q7 � 0) Orn m N 00 C) O E ER m on lf1 N Lq � O 10 M 1� 12J O ' co N U 0 M N N c0 co 1� 10 t+/ N In n ID N N M M L N 0 0 0 0 N l0 O N cn O V n 0 V N V N O O U7 r N 0 W N Lo 01 N 00 O L .— c0 M 10 N 10 ' V O o0 O tD N 10 ' 0 ' V t0 > OV lt) CV M r u N O N N 0 O co lm M m Z O�OONMnO V O� M O1 M l0 M M O ee�� c00 N to N t0 O M O M tq LO LON 1 N•--�NN�� N IN 1pO O N N M 7 Cl) V c Oc' tC0 co o 0 0 14 N O t o M 0 N O n O V O M 00 O 10 N 0 7 0'� 0 co 00 M Q O V 04 >,(p) O N ' " m coo OOi N V (0 C � N m LLL C - CLm y N M N O N 1 N N at U N w > `o aci N O N N LL N N LL C N C LL Li LL O OD M N ' O N O co m INn N cn oD n N O 0 N r N O t0 cow N r d 7 V _ � c 0 CL W N I 7 U x Im LU C N C co�c p 00 oo 1- Lf o' LOO co n .De y O w N O aLL Ca d CZ co N c In 0 wLL �'2 Fn `f'NU) to RESOURCES: Beg. Net Working Capital Receipts: Events Telephone Fees - Events Parking Fees Storage RV / Camping Horse Stall Rental Concession % - Food Vending Machines Interfund Contract Rights (Signage, etc.) Grants Miscellaneous Interest Total Receipts Deschutes County - Fair and Expo Center YTD -Budget Basis Statement of Financial Operating Data Ten Months Ended April 30, 2005 Year to Date Year End Budget Actual Variance FY %EBudget Projection Variance 1, 140,800 $ 138,098 $ (2,702) 100% 506,590 483,904 (22,686) 83% 15,000 21,740 6,740 83% 72,900 30,941 (41,959) 83% 52,000 54,277 2,277 83% 2,200 4,554 2,354 83% 1,000 1,658 658 83% 184,477 219,541 35,064 83% 1,400 - (1,400) 83% 25,000 16,800 (8,200) 83% 83% 25,300 30,296 4,996 83% 3,750 7,414 3,664 83% 4,100 4,425 325 83% 893,717 875,550 (18,167) 83% Transfer from General Fund 225,000 225,000° Transfer from Annual County Fair 191,000 191,000 83/° Total Transfers 83% 416,000 416,000 _ 83% TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 98% 1 $ 140,801) $ 138,098 $ (2,702) 77% : 631,000 608,314 (22,686) 136% +? 16,000 22,740 6,740 36% `" 87,000 45,041 (41,959) 104% `: ' 52,000 54,278 2,278 114% 4,000 6,354 2,354 n/a 2,000 2,658 658 102% :.- 215,000 250,064 35,064 0% ' 1,400 700 (700) 0% 32,000 32,000 37% 45,000 46,800 1,800 100% - 30,355 35,355 5,000 165% 4,500 8,164 3,664 89% 5,000 5,325 325 78%,.,, 1,125,255 1,117,793 (7,462) 75% 300,000 300,000 _ 100% 191,000 191,000 _ 85%1..491,000 491,000 _ 1,450,517 1,429,648 (20,869) 83% 81% ' 1,757,055 1,746,891 (10,164) 595,000 566,660 28,340 83% 79%,; 714,240 627,750 512,695 115,055 83% 68% .r 753,494 43,133 45,970 43,133 44,775 83% 100% ` 43,133 91,006 91,006 1,195 83% n/a'r 45,970 49,181 8,400 - 83% 100% 91,006 - - - 83% n/a . ' 109,212 1,402,859 1,258,269 144,590 83% 47,658 171,379 123.721 Beginning NWC per FY 05-06 Requested Budget Deposits Received for Future Events: 2005: May June July August September October November December Beyond TOTAL 685,700 28,540 685,138 68,356 43,133 44,775 1,195 91,006 _ - 109,212 72% "m 1,757,055 1,549,752 207,303 197,139 197,139 125,000;' Accrued Revenue (Accounts Receivable): 10,508 April 2005 Events 15,197 March 2005 Events 46,169 26,850 February 2005 Events 1,628 5,200 1,384 1,560 Total Accounts Receivable 2,900 49,181 8,400 600 ----13_787 85,002 Deschutes County Fair and Expo Center Statement of Financial Operating Data April 2005 Transfer from General Fund Transfer from Annual County Fair Total Transfers _ TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 111,255 149,163 37,908 59,510 62,775 Budget Actual Varianc� RESOURCES: 8,540 (11,030) 35,418 Beg. Net Working Capital $ _ $ _ $ Receipts: Events 65,450 84,183 18,733 Telephone Fees - Events 1,000 420 (580) Parking Fees 7,200 2,000 (5,200) Storage 18,900 28,028 9,128 RV / Camping 500 744 244 Horse Stall Rental 500 570 70 Concession % - Food 14,400 30,000 15,600 Vending Machines _ _ _ Interfund Contract _ Rights (Signage, etc.) _ - _ Grants 2,530 2,530 - Miscellaneous 375 229 (146) Interest 400 459 59 Total Receipts 111,255 149,163 37,908 Transfer from General Fund Transfer from Annual County Fair Total Transfers _ TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 111,255 149,163 37,908 59,510 62,775 62,957 50,788 (3,44.7) 11,987 122,285 113,745 8,540 (11,030) 35,418 46,448 MEMORANDUM To: See Distribution From: Jeanine Faria RE: Remodel Projects Fund Date: May 24, 2005 Here is the statement for Fund 452 - Remodel Projects Fund from inception through ,April 30, 2005 This statement is complete for the actual transactions that have occurred through April and includes encumbrances, commitments and contracts known as of today's date. During April, 2005, the "Additional Resources Required" increased by $9,604. Following are the details of this change: Additional Resources Required for Projects, March 31, 2005 $ (39,214) Interest earned on cash balances in April 2005 2,318 Increases (Decreases) to Encumbrances, Commitments & Expenditures: Family Services Plumbing contract in excess of February estimate (7,618) Permits for Day Care (4,304) Additional Resources Required for Projects $ (48,818) Additional Resources Available (Required) by Project: Courthouse Technology $ (15,442) Justice Center 70,119 Road/Surveyor (496) Family Services (additional resources required from Fund 442) (102,999) $ (48.818) Distribution: Mike Daly Tom De Wolf Dennis Luke Mike Maier Mark Pilliod Susan Ross Marty Wynne a C6 C ELo c O O a N O U o O N N . c s °a CL . O 0-0 O Q ElCD w M M - M N O � N . i i � i i I I I i . O) -zT O O O (O :; CO N L ap L Cl) N O to I- co O O r- O Ci r CD ti O O O U fl- O) co co 0 0 O co M 00 L N O) O L.f) O `- Cl) r p p 6) O O � O O co- LO M Le i� CO O Ui U N N O > to LO 0 r N.:t v 0 N (D r• v 00 tO �! M - V1' Zoe CM CL o00-@ M M O N LO O O h U') 00 N n O m O O N m O N O (D O �t O M O O - N I* ap L Cl) N O to d U O Ln N m N O M N O LO 'IT V' (D T O V O N 00 V' D) Cl) O) Cl) O) h ti O O O U fl- O) T D N cl O cor T O) O L.f) O M Cl) r p p 6) O O LO M Cl) 00 oc 00 O Ui U N N O > to LO 0 M N `' ti V T O to to d 00 tO �! M - V1' Zoe CM CL o00-@ �t V1"a O r mai coco - j - E >c QO 4)ot{ LL M M co: of O C N ~ C y C (n U '� 7� 2 O cOzs V a Ll O Q) (/) N y- C r W y 4. D O Q m O Q) " -0 O J F- Q 0 0) O- a) 6 U LL (n O F- .• 0 7 7 0 0 Q F- m LLLU W ll O O O m 0 0 O O O LU I` O 00 O O N O O N O O O zt O I- p (D O O O O O Z LO N N N O Cl) O 0) LO 'IT (D O) O N Il_ O O 7 T p O) 04 00 D7 Cl) a) M I,- O Lo (D NR 3 6 I -p0 OM! cr (fl O ti Lf) O V ti Cl) O O 00 O) Cl) � M CO CD N r Cl)M N O) U Cl) M NT N -- T Ln 01 M M M Co 3 N LD O r- to Cl) O 00 O O f` O) O N O (D O to 0) M O O ' NN LO M N O LP) ti LO N m N O N m O LO �� O et O D) N M rt O m D) M M LO 1-- O O O M O I- r Cl) N cl O r d7 p( O O O O V ti O r O lq' O O O Ln M Q) M M -ti (D r Cl) N r T T O co l!) M M (D M T I:i � Cl) et O r- U') CD O T LL) O O N LO O M N r Lf) ti 0 N m N O N w O) LO � IT (p 00 T (D O n H c p d d U LO LO (D - O O Ocei6a N 0) O r U tT r - O(6 LOM V7 P.cli O i I� O O O O It O T r r O et r 0 M M N y N r- r Cl) et O r- U') M O N O O h O O N O O O LO co 00 N LO O M N r Lf) ti 0 N m N O N w O) LO � IT (p 00 T (D O n H c p d d U � O et O N CO er CO O m O O Ocei6a N 0) O r U tT r - O(6 LOM V7 P.cli O i f`O It O T r r Cl) IT M 00 d N Cl) M M N y c !A (� .O O U , U Ui U N N O > to LO 0 N r- N N co co co O O O T T co LD T- oo r- (Ntn O O r r- co LD O O N M T- a) O +L O O O O 0) Cl) w ECL CL 0) _O •_ Ln O_ 0) OJ _.) W Q c a U O O E E L L w O �O LL O -j LL O 0) vUi U O ) .L.. U C ' Co �O N c QCD c M CD 0) O n a a)> O O Na) co 0 C o. n el). U) d N O) (O c E c E (0 04 d. i N U E U U UO` c w N N 0)CL 7 S °) = m E O O D L aO U O (D L — 0 U a U 7 0) .o a co aZi o L m O 7 O O w a) ccc 0 H M c N O O O) >.x Co O N L X C p 7 N dO L co (MD w O co d �? O b9 O L L 0) a 0 N O CCl) N O Ln L N L.L.LLL .0 0 CD L Ew E � 0 C (n O N T LO c c C L N i Co a) O) N C C (O Co E ED H c m U U c °)o c w a)�• O 0 O 7 a d O o a ULn N > N 61).61).'p -O o C\lcd O O 7� 7 c� a s C m m O dN O O =00) 0 .L- O m LO -0 CL N L •7 L (0 QCLUF-mF-O (0 .n U 'a O a C O n H c p d d U U N dU C Z L Q. i. O A T N y c !A (� .O O U , U Ui U N N O > to LO 0 v 0 N () °� a) to to d d w c U E 0 O 'a O m _0 U) V1' Zoe CM CL o00-@ (Li EELL�>,�v V1"a 0 W N mai coco - j Z�ca N `L ma)OIJ E >c QO 4)ot{ LL co: of O C N ~ C y C (n U '� 7� 2 O cOzs V a O Q) (/) N y- C r W y 4. D O Q m O Q) " -0 O J F- Q 0 0) O- a) 6 U LL (n O F- .• 0 7 7 0 0 Q F- m LLLU W (c9 rx J S F`- LU U 0 °> F-- Z a) O +L O O O O 0) Cl) w ECL CL 0) _O •_ Ln O_ 0) OJ _.) W Q c a U O O E E L L w O �O LL O -j LL O 0) vUi U O ) .L.. U C ' Co �O N c QCD c M CD 0) O n a a)> O O Na) co 0 C o. n el). U) d N O) (O c E c E (0 04 d. i N U E U U UO` c w N N 0)CL 7 S °) = m E O O D L aO U O (D L — 0 U a U 7 0) .o a co aZi o L m O 7 O O w a) ccc 0 H M c N O O O) >.x Co O N L X C p 7 N dO L co (MD w O co d �? O b9 O L L 0) a 0 N O CCl) N O Ln L N L.L.LLL .0 0 CD L Ew E � 0 C (n O N T LO c c C L N i Co a) O) N C C (O Co E ED H c m U U c °)o c w a)�• O 0 O 7 a d O o a ULn N > N 61).61).'p -O o C\lcd O O 7� 7 c� a s C m m O dN O O =00) 0 .L- O m LO -0 CL N L •7 L (0 QCLUF-mF-O (0 .n U 'a O 2 C w 0 E m k CL / ■ k 0 S o k %x 0 0� o/ co C o_ / 0 k 0\ƒ J m E\ q@ c- 0 7 =r — 0=- te n � 7 0 2 Z m e 2 c _CL / _� � a a _e ]k° ® � o m o o= q0 2 2 2 2 / � / ? / / COm f 0 X m m R E �n CD % k® 3- a .< « 0)� w C j m m .. 0 CD / F ) / k CD / ƒ cn ■ 0 / o #�_ § o � Co / / J 0 m c / ® / 00 ?wo %a 2lz 2 CD / k k il CD $ 0 k 2k�$E� C) / $ ] cn # CD / � w- g — m7 7 -4 -4 :-4 C) p, -4-4 -4N)-7a 5 u 5 J u o=# o = //.d o c o a« o o _.. 2 o o e w o & w- g A/ k \2k — m7 7 -4 -4 ll C) p, -4-4 1�1 4 u - J k k //.d K?///R # / k\ / 00 ?wo %a 2lz - / k k il �0,� \omCA) 2k�$E� C) / $ cn # / � 4 o -4pP) m m o u u o a a o $.K/ \E/q// A/ k \2k 4 d \ w % IWNIto / 0 O c ��ƒE //2/ 31�E /220 C:) Q o 0 N) 2 CD _ 0 2 n = /Oce 0 G . � �\ p, -4-4 o N) N3 cn 4 u o u J o o a a o 0 //.d K?///R # / 00 2lz - / k k il 4 \omCA) C) / $ # # / 4 d \ w % IWNIto / 0 O c ��ƒE //2/ 31�E /220 C:) Q o 0 N) 2 CD _ 0 2 n = /Oce 0 G . � J W 0 (n 2 o O U W O .O 0' N a W co CD _ Z Q L O w a (n E U p DSU rn a H N (D U C (u L Z c 0 U � W c9 O w z O) .O 7 m U N •O r` a Ln co O Lo o m to O L6 M fl- co IT d• LO O O O O O to M I� O r OVOLo I- O O CO) r O 00 O O O O O r O e - O 00 O 00 O 00 O 00 Ln N O t` N CO 00 N N ,It LO O M co O O to M r- O — O 4 O N r CO O 00 N N co � O �O co O r (D V, O . . I I I I I I I rn o m o O rn V co —p) W D N U — L Co a >CO O x NLL R L O C W CD en Cf) U O U C CL >3 Il- O O 0) M M O O ti O M O Cb Ili n d' Z O W` O U 0 Oin > O w, 0 0— O 0) O>> r r N O M. to yam -jF =a�� aGo m cu U o d F W 0) O O O r CO N O r M CD O mo O O Q7 ca O O M M O d r (0 CO Il- O rl- IT r O M cY CO N M r I� LLQ O U') O r O ~ O O CO O V r CO O O O Lo Oco O a) N Lf) r r� "q 't 't I ti N N N N O- O_ O O r M N O r M CD O r O O O O O I� O M O V r co O O ti V O T- O M cr CO N M r 1� o �r 00 (O m O 00 O O CO d O a r 00 U -i 00 d M t[) M Ln r r r r N't W r- 7 N M cY r Lo CO U N N N C (6 cn N CD CD r 00 N O CO CO CO Lf) 0 0 m O O O 0 N Ln Il- M M O I- r CO Cf) I- O ti M N r M� O N M r I-- r Ln O LO O N O N O O d• O q r O O O O L6 C) U) N Ln r r r CY) LOd' I- E M d' LO N N N O U O ' co o co Lo o U O ro cf) M M M O 'a L!V CND w(NO Ln Ln Lo Lo p m N a O 0 O r 0p N O O M Co LO MI M M LD >O N Lo tl- M M O Il r (D L(7 r r h 00 p r M d• CO N M r f- r N N LO Lo Q O N O O d• O I •- O I_ r- M r C N LO r r r I� r-- Q1cu N M 00 00 r w N C LL E O L 4 O O C O LO �\ LQ N (D 0) (D C) O y� d Z O C U) Vi O m •� CO O O U_ 0) :, "O CO O U N Ucn O -0 4) 0) to H 'aO 0 0) N V co —p) W D N U — L Co a >CO O x NLL R L O C M O en Cf) U �. Zj W U C CL >3 .ca - O F O U) N N N O O U N C,6 N O O O O O (0 (O O N �_ Q) a c Lv K Z O W` O U 0 Oin > O w, 0 0— O 0) O>> N :_ ... 0 0 W y CL yam -jF =a�� aGo m cu U o d F W I- Z Z -I CD 0 O o Cl) _ k c°-0 =� o m>_ m o D m a 0 y d M W OP a v0, �' CD n =o g CDcn= CD CO m CL d -° A. ��:nv cy 51 go 4�1 °' '� �, 3 f° v i m m m W O O _�� x'00_2 N c CD y � N N n N C. O O O 90 n O (B O C) N CD O i (n w = CD z y W W O W 00 W CD N (p v Cin I o W W O W O W i N N 00co coo Cn -1 W N W U1 O v V co O Cn N O � 1 M W CO W co O W N N co co W OP CA CO Cn W N co~� i co CSO m X o m Z �v C c X cn C) CDti CO Cn 00 I IN e 0 ni d CD C: CD O c m rl CL U) m U) co -4 CA v 00 W O N V -4 CA L-4 0) A � O W W O O O O w co Cn �l 00 W �l CA 4 -• OJ O N W CA W N O � O V — CA X 0 c ;u O C 0 N 0 D < O =r CD CD w O H O ;u 0 O M (� m C) n O 0 m r .1 A O CA Cn W N W 00 OWO V O A. 4�1 Cn Cn V O N co (n W O �I � W Cn �! O W O Cn O O O O O N CD O i 00 W co W W W 00 W co Cn co _ Cn O O W N W (p Cp A co co W Cn Cn -I O N co Ui (D W O O W M V O W (D Cn O W W W O N CO O W W CD � 1 N 00 co Cb N W W W m X o m Z �v C c X cn C) CDti CO Cn 00 I IN e 0 ni d CD C: CD O c m rl CL U) m U) co -4 CA v 00 W O N V -4 CA L-4 0) A � O W W O O O O w co Cn �l 00 W �l CA 4 -• OJ O N W CA W N O � O V — CA X 0 c ;u O C 0 N 0 D < O =r CD CD w O H O ;u 0 O M (� m C) n O 0 m r J W n O mi O N X N CL W M � U — t o Q ti W o D fn _J Q M Q LL CO M N O O I i I I I M 00 C' O o O�t Or- LO N c L O LO — N I- O N O co ct m r 7 ti " L O LC) O O CO 0:> M CO T N �O (4� U y V Z Cm LLL 0�UIi0U�� `- N CO CO T CO r CO O O M LO ' ' M ti O O O In O - LL) I� N O N 0) � 0 m LM O O LCA O O O m V' V' N C0 co LC) O 0) d O ti— LO N S O T `- rl N m d <- N I- O N O Cb O O 00 O O MO O N Ln Q N O O C N h to W N N C N C) E ' ' W 7 7 .0 0) O Q J C_ N r OM N C 00 LOC) I LC) 0) LO O O M LO O N N d1 ti N ct L6 O ti r T Lo od CD M V- LC) � M O T C0 — O 000) O ' co ' N f` O O f0 O 't LO ti N O N C� � CO O O O CD O t t N N � O I- � LO N S O T M N M — O N I- O N C) 00 O O CO O O M M a:J �- N O W N ' 0) LO P- cfl rn M O V- (0 00 O LO ' M CD ' N ti O O CO LC) d 't LO J- N O M O G O (0 0) N m m� �p N N O LCA 0) 0) N � O I- — LLQ CO O T M N O r- N ti O N •-- 00 O CO 00 CA O M Cl) N O 1 O O ti co co LO co r to N N ' - CO LA co Co 0) O T O M V T ..r co N O LOC) Doo VN' LO O L6 cr�N Co LA co N LO O 0 co V CA O W � to ti rn C ce r T T LO LO ) IV N Ll T 01 N N N C o U c L O LL _ N O O 7 ti " L O � d N N �O (4� U y V Z Cm LLL 0�UIi0U�� p Z C COCO m LM h N 'F U U �tS U O N Ln Q N O O C N h to W N N C L LO LL C) E y Vi "C7 C) L W 7 7 .0 0) O Q J C_ N r U a) C Ki U U) La U� v ) d La ii 0rn d1 c O "O cn C 5 Lo od CD L a (0 L 0 N Q) CU U N t4 O N Cra a w a 0 a) Q m aa) -'o 0 J F- C¢ 0 0 (D o Cr) O LL F- a- a:J �F- W 1 O O ti co co LO co r to N N ' - CO LA co Co 0) O T O M V T ..r co N O LOC) Doo VN' LO O L6 cr�N Co LA co N LO O 0 co V CA O W � to ti rn C ce r T T LO LO ) IV N Ll T 01 N N N o U c L U LL _ N O O 7 ti " L O N �O (4� j= w LL La N m Z Cm LLL 0�UIi0U�� m LM U 1 O O ti co co LO co r to N N ' - CO LA co Co 0) O T O M V T ..r co N O LOC) Doo VN' LO O L6 cr�N Co LA co N LO O 0 co V CA O W � to ti rn C ce r T T LO LO ) IV N Ll T 01 N Z -i m v x m �n W ,� com 5 D� v m — lu"eco n°) k o d ca a N Q 7 O. C-- O Z 0 o c CD obi C: CD V y =� c� o m 0 ju C-) cn QO C c m nn Go m 3� 0IM 3 0 0CD 2 m CD � co 0 CD CDy G O (8 y c 7 (D (n 0 n (D I N co v � 00 i 00 O m O(D cn i OC OD c rn CD cc i D i co CD 0 CD m (D cn i co Q D CD CD m CD ul O CID C, I I I I IN co N co 0 w i O .a N 1 00 0 N 00 _0 cn Z7 cn n X 0 O CD y ._„ D � ch 0 m c o Z � n m o. o C) 0 CD cnc�'`� r- 0 z G) co 0 0 I co co Q � 1 0CDO i 1 co 1 1 (] 1 I m co 1 � 00 i 00 O m O(D cn i OC OD c rn CD cc i D i co CD 0 CD m (D cn i co Q D CD CD m CD ul O CID C, I I I I IN co N co 0 w i O .a N 1 00 0 N 00 _0 cn Z7 cn n X 0 O CD y ._„ D � ch 0 m c o Z � n m o. o C) 0 CD cnc�'`� r- 0 z G) f � ' r- ' 0 0 0(0 CO O O O CO � 0) <p co p O O N CO O �p O O 00 O O Cl O O O O N 00 O O � C0 O LO O T � �t cD M O CO M O O T tp 00 O T C) O O lf) M LO IL 00 E E O O CO ti 00 O 00 O O O T LO r— N m N T N T p C5 00 �- L Ci NO p T N 00 CC> Ln N r r- W M Q M Ln N M 00O L C T T U 0) O O IL E E U E- C o N m p>'j o (a O O O W L C U -C L N U L 2 O InO> L 0) 0) U . Q O C V O p 3 U) C: U> 0 U tp otj 00 p U N �0 �� 00 O O O U L w0 L- N �_ O � 0) Loo U c E UO ° E _7 _N 0 s •>a �L=aW2�%�n>UU- ch 7� i < Q- Z M ,-, O O L •U _ N N O O i i i O O O N O N O Q) L L L L L L L L 0) 0) 0) 0) L L L L VJ O Q C •� U N N N U U U U U U U U CII U U U U W o O O O C c O , >, >, >, >. 0) cnUU OUQ U 000000000000 LIQ m h U a) z W LO c _ E W N E L *.E M V c y 0 O O >,Q c� U � a cap E o U �a< cu >0 75 o n3 a U- cnCD E 0= U L E U c L Z = E a 0 cu S V C "" d V .o 0 i= co 0) '► O �, Z > C N v Z L Y _W c N ca - ♦�� v! � c 06 o °tS _E . h y� •�, Y� _ y O N licJ ca UWYF--Q0 >Y Fes- 21- LM m � o U Q c� E-- AAEMORANDUM To: See Distribution From: Jeanine Faria RE: Courthouse Remodel Project Date: May 24, 2005 Attached is the first monthly report prepared for the Courthouse Remodel Project. Projections will be updated as the project proceeds. Distribution: Mike Daly Tom De Wolf Dennis Luke Mike Maier Mark Pilliod Susan Ross Marty Wynne F- C) U W O C J O W 00 U N O o y 2 M CU W i Q W cn C) o �Oa 2 F- ry n O U O 7 m O (0 a N .O U N O O O M O O O M M N O OO CO O O N ;p O O O O (7 O ' ' O' O) O ' M CD to M O O a0 O O r 00 � N M 00 cM T O CG o0 LO N d rl- t` co N T T r U O O O M M 0 O O 00 O 00 O O N 00 N r L� 0 0 CO M y U y p) U p 0 0 0 0 0 T O 00 0) r, CG N N N V O= M� y 'i O O x wy O O O O O Cl) M 00 It et co 00 O O O O O 0 O O O N d Oti0)O U y y L L y G) It T T N �ti U U) U Q) O U g W V O O NM O a to cn N 00 N U) 0 h W Cl) p cLCo m 4? O T T CO T V CO +- T r X W a z LL UmmLL T T r O O O O O 0 0 O O O O O O O O T O T r O O O O CO O ' M �} OLri Lri C5 L15 C5 Lri LO N M M N M T r T T 0) r O M O M M M ' O O O O O (0 N 00 00 t[) O M ' O OCM - r O O 0 C) 000 coc O O O ti O O Lf) L!i O (fl O cM C5 O V lA N co T r- O N LI- O P- CNG, T T N T t Cn I 0 M' O� C) C) 00 CD 0) �tiNN M O LO 00 L LO N T M I of T T r r C) M M T ti 00 LQ O M VN_ CMO ' ' O M OMO OTO [f N co O 0) °° c T a0 rn st M r r T r d Z y N a C N y U O O U L2 m Cm m o O Q :t --0- O E cu U N U L > O ' O Q � U Q O � L 0 y O y � LO _N C) w N =p _ N O C N Q M U) (0 c CD O LLL _E a o O o•� LL O `~ - O C y N E O Q C CDN N y N w -0 co d U O Q O O C C QED � Li u v E a in wO N (6 O C L C (D « N o io .� E O C (V CT in cu y W C W - N O) O L O >r O U •� O O • C: N y O O C O O � d0=3 Ef3 d4 Q F- Q co .Q U -0 y y O U C U Q O d comms =3 Q OU U 0 C N Y O y r+ C y U y p) U 0 3 O OC a LL J.A VN W N N N V O= M� y 'i O O x wy �LU . O Z c`o w � a .�i a 0)- U d 0F= Ix w N U y y L L y G) �_ N �ti U U) U Q) O U g W V O O Q. O a to cn o W v) C: (D i U) 0 c: � N _� O C 0 O W Cl) p cLCo m 4? O a) cu Q I- ~ 4= ~ +- w w-��-H �h X W a z LL UmmLL F0 d Z y N a C N y U O O U L2 m Cm m o O Q :t --0- O E cu U N U L > O ' O Q � U Q O � L 0 y O y � LO _N C) w N =p _ N O C N Q M U) (0 c CD O LLL _E a o O o•� LL O `~ - O C y N E O Q C CDN N y N w -0 co d U O Q O O C C QED � Li u v E a in wO N (6 O C L C (D « N o io .� E O C (V CT in cu y W C W - N O) O L O >r O U •� O O • C: N y O O C O O � d0=3 Ef3 d4 Q F- Q co .Q U -0 -I -i -I -i cn -q -I -i -I -I T 0 0 0 0 0 0 0 0 0 0 G, W 00 00 m m 0) 00 0o a, CS CS CD CD 6CD n� �pppD n CD pp 00 CD Z 0 -iv Os CD CD CD to ,-. = 0) C CD tsa c) C� C� CSD 0 rt m CD p, CD 333 tll 7 7 m (D 33 0 co .0 S1 d a. Cn CD 7 O 0- d O Q 0 O O O CD O 0 CD CD N 0 O' O co D CD Cnn -0 c U" m 0 -no0 0 O m 3 o• 3. cn m o to v CD 0 0 cn to m (a CD 3 CD mo m m m n 0 m co < _ 90 in m 3 D C7 m CD 3 CD 0 m z K O CO ai Z °ft c Z N C) m ' m w M. Z 0 O p m (7 — cn � a m cn z cn - - co 03 m m m m m m m m O O Q S1 m m m m Uf V N -� —� N Cn N W N N C) Uf .P W Uf O M Cif O Uf 0) OM co w W O O Uf O O O 0 C) 0 P A. CA O O —1 O O O O O CO N N co O C) co O O O O O O m z K O CO ai Z °ft c Z N C) m ' m w M. Z 0 O p m (7 — cn � a m cn z cn - - co 03 m m m m m m m m O O Q S1 m m m m to O to Cn m CD S?o S?o 90 9090 90 CCD fD cn cn cn cn m -n 3 =3 m m m m X• X• O O < < < C C2 t1 m CD n n n n• m m m m y cn m z K O CO ai Z °ft c Z N C) m ' m w M. Z 0 O p m (7 — cn � a m cn z cn � R R R R G R S 0 0 0 0 0 0 0 0 0 0 0 0 0 6 o 6 o a w 6 o o o 0 0 0 0 00 to 0 0 0 , o o CN w- CN N o o CN 222 ww& E 64 � ( 7 f � d - � \ 0 Co CA) IM �ƒ R d0 � t k § ° 7 in CO E 5% 0 0/E�-' U) =S Q Q o k 2 7 D 2 2 ;= m o Q a n@ 5 4 4 2 q C4 CD # f R Vi < U) k 9 OD K - k 0 leOf _ - It n o . m _ 2 f M ° k $ ® ® ■ E@- E ©w f 2 � \ 5ƒI�� m �$ > o , MNS ICL n c - U.) Lo LO le 2q C�C4 CL « m _ c CII E co ¢ G kg 6 0E7z LL.�§�� �/E r0 QE/� �OA sU-/ 2 k E >2±£ > ¥ m - 0 2 0 � R R R R G R S 0 0 0 0 0 0 0 0 0 0 0 0 0 6 o 6 o a w 6 o o o 0 0 0 0 00 to 0 0 0 , o o CN w- CN N o o CN 222 ww& E 64 � ( 7 f � d - � \ 0 Co CA) IM �ƒ R d0 � t k § ° 7 in CO E 5% 0 0/E�-' U) =S Q Q o k 2 7 D 2 2 ;= m o Q a n@ 5 4 4 2 � kkkkk0 $�@§ : p # f ■ 72,N.72 < U) . 2 3 t � kk kk mEo , coo C14 mo - It n o . m _ 2 f M ° a- cc § (Dko� /k ©2 < o E@- E ©w f 2 v/ 5ƒI�� � R R R R G R S 0 0 0 0 0 0 0 0 0 0 0 0 0 6 o 6 o a w 6 o o o 0 0 0 0 00 to 0 0 0 , o o CN w- CN N o o CN 222 ww& E 64 � ( 7 f � d - � \ 0 Co CA) IM �ƒ R d0 � t k § ° 7 in CO E 5% 0 0/E�-' U) =S Q Q o k 2 7 D 2 2 ;= m o Q a n@ 5 4 4 aaa4a@ ooeLaLO0 oot-NNC4 E 2 _ $�@§ 0 # f ■ < U) � 2 3 t � 2 mEo e \ f (D aaa4a@ ooeLaLO0 oot-NNC4 E 2 /_ $�@§ %» uma� < U) ` 0& 2 3 t � d5gfmF-U mEo W 4) v v9R W l0 N l0 -0 R n R na (O dl R a R a l6 v n W n t0 n to a m fl 10 a to m y n l0 a l0 o to d a l6 16 R W R R l0 \ \ \ a W R @ N l0 a R 16 Q5 N n l0 l0 l0 10 16 l6 N a l0 n 1� l0 l0 l0 a l6 R 10 s l0 t6 a l0 R l0 a l0 R R n R h o l9 o U U U t�.� U U U U U U U U U U U .0 ./6 U U U U U Of O O W C C 0 C 0 C 0 C 0 C 0 U C O C O C O U C 0 C 0 C 0 C 0 C 0 C 0 U (� C O C p C p U C C C U U C (� C C C V n O O O O U Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z O Z ;.. ; C Z O Z O Z 0 Z 0 Z 0 Z r M 0 t0 CD O O O o 0 0 0 0 N n 0 0 0 0 o n M M M O r V 0 m O m O N O O to Co O co O N (7 co Cl) r M O n 0 0 0 0 0 0 0 0 0 N N O O O O O O M M M O r V 0 M O N O N O O m N m O M V ° y m M O O h M C-1 n 0 0 0 0 0 0 0 0 0 0 0 0 0 (O 0 O (V N 1- O to m O O 0 n 0 0 0 M 0 pi M ch tp n N O 0 (O w V V O O w tp O o 6 to O O d tO O V n O 0 V M r n O 0 N/ O O t0 N CD O co c(1 n m cc O [0 M O C O O O O N cc m C N to C( r CO O V V V CO N t0 r t0 o n to m N O O N v Cl! W co O ri V o O pi V to r tj') 0 O 0 O 0 O to o C) to V M O (O to N O f� m n (D c0 o O m co N m v m n cD to m of n m m N 0) O of M o N ofto r 0 to 0 Cl) m 1n M pi O v m 0 co O 000 O m m m O D. r C C 0 O O O O o 0 O r O r O O V O O (7 O O O O O O r r r r r r O m M tp O l0 r V' LO C r N N N N N N N N N N N N N N r N N N N N N N N N N N N N N m O N M r O O t0 0 N CN m O M O M to 00 0 o M M o 0 o 0 O 0 o 0 n to. r r 0 o 0 0 0 C)o O O 0 0 0 0 0 O 10 O 0 O o O 0 O 0 o 0 o to o m 0 O 0 0 0 0 0 0 0 0 0 0 OOOOO 0 0 0 0 0 m o co N o m O N °' m O LL') O M O O O O O 0 0 0 0 0 0 0 (V n 0 0 0 o CU m 0 0 0 0 0 0 0 0 0 0 0 CV n 0 O n d to O m M N 0 0 0 0 0 0 0 r O N M V O CO V' O n to ao n O 0 q 0 0 0 cc N n N O V M O O O O N N M r W M V' V V N O O O O O O O O pp O O O p4 U O O m N n t0 0 m I` (? 0 M n w co M co O 0 U) O� O lr t0 n m (O m N' (o 1` tp O o O n tD m c0 O O co m n 0 N O O O O O O V O M VO o Oo J O O O O r O O C 01 m m m co m 0 r 0 O 0 r o O m 0) N V m m m m 0 O 0 O (D m m m n m O m m 0 0 0 0 0 0 o O O r o m 0 O m n m m (O C0,64 N (� r N N r r N N N r r N N r r N N N N N N co t7 m 00 M N W N C N ♦ N D- W 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ue o o e o o� 0 0 oe o e o 0 0 0 o e e e e N N�- C V U 'O �W 0 O 0 n N 0) 0 V 0 V' 0 O 0 m 10 O O M O O (O O o N 0 O 0 10 0 M 0 n 0 M 0 0 0 U') 0 O 0 to 0 O 0 0 M O 0 (D 0 o M N 0 Go co 0 to 0 O 0 to 0 N 0 O to n H h O a O O r O N� r L a O j y W m M 0 0 0 n N N r n 0 0) n OO (D M q Oo O o 0 0 N M 10 N to M V N o O n o M h OO W 00 O U E (4 r N r r M M M r M r r N N N N CM M CM M M M N m M M M M V N N M M N N N N 00 E W~ W C Q. O 0 UH7U-LTIJF 0 0 a v e o 0 0 o o > o 0 0 0 o O m 00 O O O O O O O t0 0 0 0 -D 0 0 0 !O O O O O O to 69 A r n M r n O n O to r V N O to N O n r O O M n O0 N O O M n O N N M n m r to N M to N M co M M o M M O O V n M M y) C p W V W (W] C N .0 m 0 E a °o W o 1 o m 0 w O O N LL7 n M n n n co O m V M to 10 M (A t0 N CO O (o O m co m W t0 m 0 0 0 O n 0 M y W j W Q W Z M to t0 to r r V t0 R (n V in R r C r M r C 10 M N to 0 V N V 10 M M R t0 V 10 V 10 (D M n 10 v 10 n to M to 10 to O V to u '7 ton N CO m [T t0 M n M n N n M n N� r W W ; C LY to 0 00U)Intot0tototo 0 0 0 0 0 0 0 o Q o o n(ntotoLOLOU') 0 0 o O o 0 0 0 (D(D(DCD(D(D(D(o(D(D(D(D(D(o(Dn o 0 0 0 0 0 0 0 0 IR o 0 0 0 o c ° p g Cl) 7 W r r M r to N O O C� r tO O m O m r m r N`` O ao O r O [O N N V N N O m O O n O t0 O N m M �- M CC, N n O N 0 W E� n n n(Onmmmrnmm000rr(1 Q Q Q Q O = o n(O(O(OnnnODmmor�(V Q �V �V �V S ;= u F F d g o 0 0 0 0 0 0 0 0 0 o r r o 0 0 0 0 0 0 o O O o o r r o Q F 0 m • H N M O Cl) O t0 M O V 0 M 0 to 0 (c0 0 '7 0 to "t OO V V O V O V O V O V to O V O V O V O M M O O R O t0 O to O to O n O n O 0 O V O V V O to O W L M M O m N to M M 0 0 W m O m O_ V 0 O O W (� V m 11 1, r co aD (h O ` Q O Q O N M (V N r N O V' r V O M e M O N r V r V N V' (� N to r O W Q N O N Q m O N r` N r IL rOro00000000oro000� �0000000ro--- o Qd'LL 2>M Od mUUJNN� FVFLL� 9d& O LL Q LL LL LL LL LL LL QQ p 0 LL LL LL U LL U U U LL LL LL LLL LLL LLL LLL LL U.LL F- H�9 LLLL (A M 0) 0) m U m 0 0 m 0 J 0 0� �j M U m m d LL0 HO OD t0 2 O(D n2I-X M t0 (D20Z N M m n 1-UvO0 W M V V X M m m co to O. U m � (Hy d X 2 W N X V LL X jxx( rn ;U`Q OY� (7 X U F- m � 1U� Qy J -J 2 X uQ7 7 E X 10 M M 7C X u- O X m W M i( V z O M M M c0 N M M M M M cn M M M M M M t0 N M M M M M M M cvMj M M M Cl) M M m M ch M M M _M (O M ('7 M ch M M M M _M M M M M M W tO �r (� 41 to Y o W '�q U N 7 W R 0. W� a D c 0 U D > LL m m ca (I tgVill RV 16 LL £ E m V m V xU E� L:n�ca c �Y0 p_Rca)Q v �_ W U >tCaIn cLRL �vmLin C Emc E� o EVE c `5LL E E V W m c c?E oo°�pviRw E N mEFvs Eocnwm "ci a CU AR W m Q UUJWW-J>> FU7LLm d QQ U ._ = �a p mro�mm 7w E m� OJDNrN �mm $e!9 ; m w 11 y gm c cmml�m W Ccp --TTT1 IZL L=i�m�l=imU�l=i.UZ.L=iL=imUmL=iL=il=iL=L�I=iL=i lei L=iZi L=L I=i m L=i c000UJ U- J m F