Loading...
HomeMy WebLinkAbout2009-03-30 Work Session MinutesDeschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS MONDAY, MARCH 30, 2009 Present were Commissioners Tammy Baney, Dennis R. Luke and Alan Unger. Also present were Dave Kanner, County Administrator; Erik Kropp, Deputy County Administrator; David Inbody, Assistant to the Administrator; Marty Wynne, Finance Department; Anna Johnson, Communications; media representative Hillary Borrud of The Bulletin and a reporter with KOHD TV News. No other citizens were present. Chair Baney opened the meeting at 1:30 p.m. 1. Finance Update. Marty Wynne gave the finance updates. (See attached documents.) The investment rate dropped to 1.3 %. The lowest was 1.27, which was the lowest in a 14 -year period. In that year, it was worse in Oregon than other places. This means that this is near to getting as close to low as it has ever been. The good news regarding the General Fund is the beginning net came in better than budget. There are some positive variances on the expense side. He is forecasting the year-end revenue total for the County Clerk upwards as things have improved in Clerk's Office. The Assessor's Office is not filling FTE positions and positions in the District Attorney's Office are not being filled either. When less money goes to the Sheriff's Office from room tax, it then comes from General Fund. Risk Management is up a little bit. The Health Benefits Trust came in higher than projected for March. It is hard to say what will happen the rest of the year. Fortunately, the departments can be charged 10% less next year. There is an individual stop loss and then there is the aggregate. Minutes of Board of Commissioners' Work Session Monday, March 30, 2009 Page 1 of 4 The County is the only self-insured entity east of the Cascades, and others compare their plan with the County's. The County has been very conservative. Dave Kanner said what is needed soon is a conversation about other organizations who are asking about joining the County's plan. 2. Budget Update. Mr. Kanner said in looking at the requirements vs. projected resources for next year, the County is actually $226,337 to the good. The problem comes in with Community Development. If they stay on a 36 -hour workweek, their negative balance is $1,093,091. If this is filled with General Fund money, there will be a negative number of $866,754; then when budgeting for a contingency, the CDD contingency should be $470,000. The total gap becomes $1,336,754. Commissioner Luke said it is important to point out it is not a General Fund gap, but a CDD gap. Mr. Kanner said the COLES Board has determined that $50,000 given to the District Attorney is not an allowable way to use funds. They will charge them $25,000 each year for two years. The County is able to increase capital in the General Fund, but would have to cover $753,754 next year. There are a couple of ways to deal with the gap, which Mr. Kanner explained. In Plan B, ASFCME agrees to a COLA freeze and the problems are basically solved. The Union thinks employees want to do something. The managers and supervisors will get a COLA freeze, no matter what. If AFSCME members do not go along with the freeze, then CDD will have to come up with $377,908 (through a 32 -hour workweek and cuts.) Other options will be 36 -hour workweeks, not filling positions as people leave, and once staff is down to a reasonable budget level, go back to 40 -hour workweek. There could be layoffs in some departments. It would be good to make a reduction in health benefits next year if possible. All budgets that were submitted assumed that everyone would get a COLA next year. Are the departments sustainable through 2011? If we get Plan B, they might be sustainable. It is expected that 2010-11 will be a tough year. Minutes of Board of Commissioners' Work Session Monday, March 30, 2009 Page 2 of 4 Commissioner Luke said at one time CDD was closed on Fridays. Mr. Kanner said the County is budgeting for the worse case scenario. It may not happen, but he would like to make the assumption based on today's figures. Commissioner Luke asked if this could be discussed next Wednesday afternoon. Mr. Kanner said it needs to get out to the departments now. They can do Plan A and then change it as they go forward. They do not have to make a decision today, but need to get the proposed budgets to the departments. 3. Discussion of Termination of Gang Intervention Services Agreement. Commissioner Baney said the Board needs to acknowledge a letter regarding a gang intervention services agreement to record with the Clerk's Office. LUKE: Move approval. UNGER: Second. VOTE: LUKE: Yes. UNGER: Yes. BANEY: Chair votes yes. 4. Update of Commissioners' Meetings and Schedules. Commissioner Baney said on Friday she will meet with a small group in Salem to talk about the Mental Health Bill. They asked about liability and accountability, and those items have not been worked out. They would like to put a project together that does not create liability and have it done by April 13. 5. Other Items. Commissioner Unger said the Transportation Plan shows shovel -ready land but cannot get business into Oregon. Commissioner Unger said Ryan Houston with the Upper Deschutes Watershed Council is asking the Board to sign a one-page letter to give to staff to encourage them to get on board and get back in President Obama's budget. The letter is in support for COID and Watershed groups. Minutes of Board of Commissioners' Work Session Monday, March 30, 2009 Page 3 of 4 Commissioner Luke said when he was in Salem he learned there was a Salmon Bill on the House floor having to do with gill netting. Mr. Kanner said Anna Johnson has a small amount for advertising to ask to go to Senator Wyden's website. Commissioner Baney said she read the KTVZ blog and requested that the Board read if first. It could bring more negative than positive. Erik Kropp said it might get to the wrong people on the blog. There was discussion about the issue of promoting recycling and the suggestion of no garbage cans in the offices. It will not be implemented until there is further discussion. There was some discussion on the Redmond Rod and Gun Club. Commissioner Baney said she needed some clarification on what they are asking. Mr. Kanner said he would see if they can come in Wednesday for the morning meeting and would then not need to attend a work session. Being no further items addressed, the meeting adjourned at 3:55 p.m. DATED this 30th Day of March 2009 for the Deschutes County Board of Commissioners. ATTEST: Recording Secretary Tammy B ., Chair Dennis R. Luke, Vice Chair aia/m- 6€14 Alan Unger, Comm si sioner Minutes of Board of Commissioners' Work Session 2009 Page 4 of 4 Monday, March 30, Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA March 30, 2009 (1) Monthly Investment Report (2) February Financials (3) Bond Issue Calendar r esc utes ou nt i 07 co N ota nvestmen Peg • _ •, Investment Income Fiscal Year 2008-09 0 I. 0, CD $ 261,318 $ 2,401,515 Total investment Income 261,318 2,401,515 Less Fee: 5% of Invest. Income (13.066) (120,076) Investment Income - Net I $ 248,252 $ 2,281,439 investments By County Function General $146,564,717 Total Investments $146,564,717 0 0 0 a o° o° O 040N6Is0� O O N O O O 1s: 142 C N O O r 4) U 43 c ca au a) m 5 a ri ❑ U 3 C U Z s~ c) ` Y -t 4) Q Q di 4) N N U E O~ 4) E EL a' mY UUILI: m 4J O ODOD (D U 1- 0 EL C0 -J ti ti IA Total Investments 10 0 0 0 0 M M (D I- CO N r N Average Maturity in Days N 40 4) au0 o o 0 0o a o O O 1...) N ia N E 4) 4 1) 3 g w a)co 4) en aC co 4 ® m it 5 0 y ~ CL a) .be O L� D j L.L.�m 1=0 a) O Z a) O 0 Total Portfolio: By Investment Types w aZ U Deschutes County U 0 0 0 0 C « E 0 i 0 .0 z 4.0 0 U 0 z U U U U 0 0 0 U 'U' U' 0 G0 z z z z z z 2 2;212 z U U U U 0 U U 0 I` 11 2 2 2 2 2 2 2 11111 I Oh > 00i moo U' U U U 0 a o ;J U U U 0 U U v c`( 2 2 2 10 2 2 Z 2 2 z 0 a o 0 0 0 0 O O 0 m M, m M O G h O M O M h h 10 N V O N m O 0 0 M 10 W V- N O l0 0 0 0 O .O O N W o- 0 M O 4 W O m 1 o O M N m 0 N M C V O N M 0 0 0 M W W M N O N O O. O 0 0 0 h LL] 0 a0' M O CO co 0 0 •0 O M V ch ui V O N W O O O co co W co M O m O 0 0 O O O N m M W M O O m cO (0 W h M m m v0 O1 W-1 O h N 0 0 0 h c0 0 10 0' O W O 10 O m O O O m N m m o o c6 M W ' N 0 O O N c0 10 W N V N O W O r w ( c0 N N W �. m O' O c0 O 0 01 . 4 O V 0 N 0 01 c0 •N V O m In V 0 N 0) N W 0 c0 60.-6.-6,-46.c46-6 - M M O 0 10 •p V 0 O M V r .m 0.0 N W u]. 0 0 0 O. ,7 W O O M h 0 W m N O M h W. 0 0 0 r .N r O O r r O r„ O N O r r r O 07 r 0 O r O G O N N• N1, N� N� NIi N• N N N N N �N� �� M N N N. N N CJ.. NI N V N ,:• •-. t+J ['J N f .II M ✓ N N O Oi m W o o d o 0 r N N o D!o o a O d o 0 (h0 N N M O N_ m m O O' O r. O h. O M V. V; m W N O h M N N O O r W N m 0 0 0 c0 V O O O r �' (") N N. r N N'. N NIN O o O M 0 0 0 d O O 0 0 0 O - 0 0 0 O'jj`W: M M OD N G C O Q O O O' c' : 0 0 0 0 0 0 0 0 0 0 O O O O I� M m 0 c1: 1 O 10 O O 0 0 MIO 0 0 0.0 N 0 0 0 0 0 0 0 0 N. M 10 'Y o( O 10 00 0 W 0 W m 0 W. O. 0 V' ` O N O 0 V W O O O W N m N M O cq O N V' O M N m. O V M N 0 O W W r 0 N. M 01 O 0 •J• m W O 41 0 011 V c0 V m V O 10 d N N r M 0100000 N h 10 O 0 0 0) W m o n 10 0 0,-0,N= 000)000.000)rrnrn0 n000 0q0 ,-00 00 N N r N N (� N r -.-c.c., N v N 7 -L L-1-) 1 f ! 1 I_ 004300.700•10000000300,70000000000000:0000000 0 0 0 0 ` 0 0 . 0 0 . : © 0 000010.0000000000OLO0(04 00N0041 0 O 04000000(0000000 W000O00000000000000 O000 c00 0 0 MWN 0 OWNa000V0010 W W 0 0 0 O O 0 0 0 0 0 0 0 0 0 W 0 N. 0 W 0) r CO. , 0 m' (') 0) 0 CO 0 0 0 0 0I 10 N CO (0 0 1 0; 10 0 0 0 0 0 0 0' c0 0 0 0. O 0 0 0 0 M 0 01 10 0 V' r N(0 O V' 0 O W 0 0 0 W W O p O m 666,664 O 0 0 0 O O N O CO N 0) 0) 10 0 (0 0 M(0 0 10 0 0 r4) 0' 0- 0 V V'0 0 0 0 0 0 0 0 N 0) 0 N 0 0 0 0 0 0I O 0 r 0) O) 0) r 0' 0) O 0 r W 0 o r 0 0 0I 0 0 0 0 0 0 m i0 1 0 O Q a o N N, N (V N r r N. r N N r 0 N N N N r N, .N V N V. I: o 2 o U 0 m E 'o! o OD 10 O othrai (lue d 0 2 0. U C O a 0 ❑ 0 d E N > to ti 0 O 0 W N v l0 4 0 Pl 8 .0 Im 17 0 to 0 8 0) 1 N�N N * o 0 0 le0 0 e, x 0 0 0 0 0 0 0 O O o m 0 O. 0 0 0 0 0 0 0 0 0 0 0 01 W N r..0 W •0 0 0 v W 0 1n 0 0 N W 10 101 W N 0 cO •O 0 (1) W 0 O N N O 00(1) ('40 ('110 10.J '0 (‚40 (1) 10 r N 0 • W 0) o o (0 0 O. M • Flo M 1W') 68.975.183 44 36,675,727 67 W) 0 O 0 (0 ( wiLri 00 c^0 ((00 M (0 10 0 W4.0 N N 38,011,347 93 38,011,347.93 $146,564,716.80 143.662.259.04 $143,742.942.56 N N O her Feb 09 - Oc 111 I al N co N co TCS nr o (uD (0 4 me, 6, 00 10) 0.01 fl coij, O,N ; Z G) N N M m V' c0 N W C) 10 m 0 m W V (O (0 W W 010 0) V c0 0 0 0 0 N W 0 m 0( W V(0 N N N M (00 0 (MO M O 0 0) (0 N (`0 ( 0 0) m 0) m 0)m 0r m m .0) 0• 0 00000o'a M r V 10 ` O N 0 ulro. r- r .0 0 1M 1 .0 0.0000 0}10.0010 0 10 m• W 0.0 1rc01 0 10 .m m h W m W O !0. 0'' !D 0 0 Q .o o l 0 !w] 01 0 0 0 0 0 O A- 0 o to o co .u) (a o lu) -4! a M r 01 o 0 p c: - D 0 (N•- 0 10 00 0J 0 a 0' O O• •O N (v a 000000000010010001000000:0000. 10100000000000 r r r r r ....... 0.'.00000 r0 .h „ W O h •0 O. N W N 0 r 0 4 r1 O r r r r N. - N O M„ O r N. G „„.00,N,-,0 00000000, (� N N M M. V m 0 0 N( W W r 0' 0 0 0 0 0 0 0 0 a' 0 '0 0 0 0 0 0 0 0- 0 , ¢ t4 16 Z L LL U F- 10 U U 1 U. 00.m ^iU)!. a LL Z 0 m u. Z 1 Z? Z - 3 (1)100'U Inma(4 p0 J 0 Y c m m LL E E 8 5526E0AL7 g U z U U) z U to m L0 0 LL m cam 0� 0 (NO (X') MMM Z 0 a lL c, ❑ U N. m a m 0 E jm m, 0 m m W m W 0) m m 0 0 0 0 0 0 0 0 0 0 o (0' m ( 0 r 1) 10 V• 0) r Ip1.0 N r N N 0_ 00W N ro 0 N (� 0 0 r 0 LL 4... Ida. O 1a4 U LL } Ie ° 2 0 E. LL. Q LL a m SIU M) M C M M x k x k M 2 W M ❑ U m •0) O 11) EOM m co _ ccd o WN WW 00 WW M' M r.71;; E ) LO } 01 LL co M ❑ ❑ 00 .mm Haim m 1h ❑ ai t ❑ 00'D - U 8 c0 ❑ N(ja E 0 (0 E 0 UU m ¢ lm w C, m, Q 14-04-„M„ x 0 0' 0 Q • C 0' C C, m: C O .c Z m E (0 0.d: 10 i(. Z 0 z 1 0 1 C m U cla .0 m l_— <OCCI,C-IMZ>W0.A4-<0.Z40 m 030.0-t a d' (0 40 0 0 m 0 U LL F 0 2 Ill 0 fu -J Bank of America 451 .0 10 N Memorandum Date: March 13, 2009 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find February 2009 financial reports for the following funds: General (001), Community Justice — Juvenile (230), Sheriffs (255, 701, 702), Health (259), Mental Health (275), Community Development (295), Road (325), Community Justice — Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 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 GENERAL FUND Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 6,050,000 $ 6,461,433 $ 411,433 100% 107% * $ 6,050,000 $ 6,461,433 $ 411,433 Revenues Property Taxes 12,947,667 18,335,731 5,388,064 67% 94% a) 19,421,500 19,455,711 34,211 Gen. Rev. - excl. Taxes 1,749,459 1,969,945 220,486 67% 75% b) 2,624,189 2,824,189 200,000 Assessor 574,193 758,891 184,698 67% 88% c) 861,290 1,011,290 150,000 County Clerk 1,143,741 811,009 (332,732) 67% 47% d) 1,715,612 1,265,945 (449,667) BOPTA 8,732 12,866 4,134 67% 98% c) 13,098 15,598 2,500 District Attorney 237,649 181,136 (56,513) 67% 51% 356,474 356,474 Finance/Tax 132,897 172,323 39,426 67% 86% c) 199,346 229,346 30,000 Veterans 46,667 53,591 6,924 67% 77% 70,000 70,000 - Property Management 68,053 68,061 8 67% 67% 102,080 102,080 Grant Projects 1,333 1,328 (5) 67% 66% 2,000 2,000 Total Revenues 16,910,391 22,364,881 5,454,490 67% 88% 25,365,589 25,332,633 (32,956) Revised Budget Year End Projection Variance TOTAL RESOURCES 22,960,391 28,826,314 5,865,923 67% 92% 31,415,589 31,794,066 378,477 REQUIREMENTS: Expenditures Assessor 2,436,061 2,210,235 225,826 67% 60% e) 3,654,092 3,454,092 200,000 County Clerk 1,032,887 988,307 44,580 67% 64% 1,549,330 1,492,390 56,940 BOPTA 41,215 34,216 6,999 67% 55% 61,823 61,823 District Attorney 3,210,175 3,009,555 200,620 67% 63% e) 4,815,262 4,603,902 211,360 Finance/Tax 526,027 515,188 10,839 67% 65% 789,040 757,750 31,290 Veterans 157,977 155,013 2,964 67% 65% 236,965 236,965 Property Management 169,621 164,337 5,284 67% 65% 254,431 254,431 Grant Projects 71,189 69,491 1,698 67% 65% 106,784 106,784 Non -Departmental 771,481 577,324 194,157 67% 50% 1,157,222 1,414,499 (257,277) Contingency 3,616,724 3,616,724 67% n/a f) 5,425,086 5,425,086 12,033,357 7,723,666 4,309,691 67% 43% 18,050,035 12,382,636 5,667,399 Transfers Out 8,812,059 8,761,236 50.823 67% 66% 13,218,088 13,218,088 TOTAL REQUIREMENTS 20,845,416 16,484,902 4,360,514 67% 53% 31,268,123 25,600,724 5,667,399 NET (Resources - Requirements) 2,114,975 12,341,412 10,226,437 ** 147,466 6,193,342 6,045,876 Exp. %I Beginning NWC per Requested Budget 6,050,000 * Beginning net working capital includes $3,160,000 due from Fund 457. Will be repaid with a FF&C debt issue. a) Current year taxes projected to be 91 % of levy. Prior year taxes estimated to be $360,000 more than estimated for FY 2009 budget. b) Additional PILT receipt from Federal government, liquor revenue exceeds estimate. c) A & T Grant (received quarterly) trending in excess of amount budgeted. d) Clerk's Office revenues are projected to be less than budgeted, based on eight months of actual activity. e) Expenditures will be Tess than appropriated due to open positions. f) The Contingency in the Original Budget was $5,905,383. The $480,297 net decrease is due to an appropriation transfer of (1) $10,615 to Personnel in Assessor ($4,818), Clerk ($5,217) and BOPTA ($580) Departments, (2) $147,466 Appropriation transfer to other funds, (3) $127,466 of appropriation transferred to Fund 115, (4) $200,000 to Transfers Out for CDD, (5) $15,328 Transfer In from Fund 170 and (6) $10,078 to Clerk's Capital Outlay. ** The net of $147,466 is due to transferring $127,466 of appropriation to the Crime Prevention Fund and $20,000 to Fund 145. COMM JUSTICE -JUVENILE Statement of Financial Operating Data Eight Months Ended February 28. 2009 Year to Date Budget J Actual 1 Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 1,090,000 Revenues Federal Grants State Miscellaneous SB #1065 -Court Assess. 42,667 Discovery Fee 10,667 Food Subsidy 26,000 Juvenile Crime Prevention 242,781 Inmate/Prisoner Housing 40,000 Inmate Commissary Fees 333 Contract Payments 229,131 Miscellaneous 200 MIP Diversion Fees 1,067 Interest on Investments 20,000 Leases 8,400 Grants - Private Crime Prevention Services Level 7 60,000 123,383 $ 1,161,149 $ 71,149 100% 107% $ 1,090,000 $ 1,161,149 $ 71,149 131,141 7,758 67% 71% a)c) 185,075 152,000 23,198 23,198 67% n/a a) 53,325 36,290 (6,377) 67% 57% 64,000 58,790 10,207 (460) 67% 64% 16,000 16,700 20,169 (5,831) 67% 52% b) 39,000 35,168 188,886 (53,895) 67% 52% c) 364,171 377,770 59,100 19,100 67% 99% 60,000 80,000 578 245 67% 116% 500 800 155,831 (73,300) 67% 45% d) 343,696 213,000 354 154 67% 118% 300 354 500 (567) 67% 31% 1,600 800 25,885 5,885 67% 86% 30,000 36,000 3,834 (4,566) 67% 30% e) 12,600 5,050 70 70 67% n/a 70 7,856 7,856 67% n/a 19,700 40,000 (20,000) 67% 44% c)f) _ 90,000 80,000 Total Revenues 804,629 Transfers In -General Fund 4,005,227 TOTAL RESOURCES 5,899,856 REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services 1,952,343 Materials and Services 1,095,907 Capital Outlay 67 Juvenile Resource Center Personal Services 1,929,583 Materials and Services 138,382 Capital Outlay 67 Contingency 420,173 703,899 (100,730) 67% 58% 1,206,942 1,129,527 4,005,226 (1) 67% 67% 6,007,840 5,960,507 5,870,275 (29,581) 67% 71% 8,304,782 8,251,184 1,936,792 948,746 15,551 147,161 67 Exp. % 67% 66% g) 2,928,514 67% 58% 1,643,861 67% 0% 100 1,666,488 263,095 67% 134,051 4,331 67% 67 67% 420,173 67% 58% g) 2,894,375 65% 207,573 0% 100 n/a 630,259 2,920,000 1,510,000 2,545,000 200,000 (33,075) 53,325 (5,210) 700 (3,832) 13,599 20,000 300 (130,696) 54 (800) 6,000 (7,550) 70 19,700 (10,000) (77,415) (47,333) (53,598) 8,514 133,861 100 349,375 7,573 100 630,259 TOTAL REQUIREMENTS 5,536,522 4,686,077 850,445 67% 56% 8,304,782 7,175,000 1,129,782 NET (Resources - Requirements) 363,334 1,184,198 820,864 1,076,184 1,076,184 Beginning NWC per Requested Budget 1,085,000 a) Projection of Federal Grants reduced for budgeted amount to be recorded in State Miscellaneous and increased for Federal Grant revenue for FY 07-08 requests paid in FY 08-09. b) Billing submitted monthly for reimbursement. Payments received to date cover July to January. c) Reimbursements requested quarterly. Juvenile Crime Prevention adjusted for increased amount of award. d) CEOJJC has placed the Administrative Analyst position on its payroll and assumed 100% responsibility for this position as of October 1st. Projection reduced by $34,000 due to the ending of reimbursements from CEOJJC to partially fund this position. DHS payments expected to be lower than budgeted due to a decrease in number of youth in program. DHS began using a new disbursement system in December delaying processing of payments. e) Lease revenue less than estimated in budget due to Rimrock and Interfaith moving out mid year. f) Budget for Level 7 revenues overestimated by $10,000. g) Personnel Services projection reduced due to unfilled budgeted positions. Year End Budget Projection Variance $ 1,161,149 $ 71,149 100% 107% $ 1,090,000 $ 1,161,149 $ 71,149 131,141 7,758 67% 71% a)c) 185,075 152,000 23,198 23,198 67% n/a a) 53,325 36,290 (6,377) 67% 57% 64,000 58,790 10,207 (460) 67% 64% 16,000 16,700 20,169 (5,831) 67% 52% b) 39,000 35,168 188,886 (53,895) 67% 52% c) 364,171 377,770 59,100 19,100 67% 99% 60,000 80,000 578 245 67% 116% 500 800 155,831 (73,300) 67% 45% d) 343,696 213,000 354 154 67% 118% 300 354 500 (567) 67% 31% 1,600 800 25,885 5,885 67% 86% 30,000 36,000 3,834 (4,566) 67% 30% e) 12,600 5,050 70 70 67% n/a 70 7,856 7,856 67% n/a 19,700 40,000 (20,000) 67% 44% c)f) _ 90,000 80,000 Total Revenues 804,629 Transfers In -General Fund 4,005,227 TOTAL RESOURCES 5,899,856 REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services 1,952,343 Materials and Services 1,095,907 Capital Outlay 67 Juvenile Resource Center Personal Services 1,929,583 Materials and Services 138,382 Capital Outlay 67 Contingency 420,173 703,899 (100,730) 67% 58% 1,206,942 1,129,527 4,005,226 (1) 67% 67% 6,007,840 5,960,507 5,870,275 (29,581) 67% 71% 8,304,782 8,251,184 1,936,792 948,746 15,551 147,161 67 Exp. % 67% 66% g) 2,928,514 67% 58% 1,643,861 67% 0% 100 1,666,488 263,095 67% 134,051 4,331 67% 67 67% 420,173 67% 58% g) 2,894,375 65% 207,573 0% 100 n/a 630,259 2,920,000 1,510,000 2,545,000 200,000 (33,075) 53,325 (5,210) 700 (3,832) 13,599 20,000 300 (130,696) 54 (800) 6,000 (7,550) 70 19,700 (10,000) (77,415) (47,333) (53,598) 8,514 133,861 100 349,375 7,573 100 630,259 TOTAL REQUIREMENTS 5,536,522 4,686,077 850,445 67% 56% 8,304,782 7,175,000 1,129,782 NET (Resources - Requirements) 363,334 1,184,198 820,864 1,076,184 1,076,184 Beginning NWC per Requested Budget 1,085,000 a) Projection of Federal Grants reduced for budgeted amount to be recorded in State Miscellaneous and increased for Federal Grant revenue for FY 07-08 requests paid in FY 08-09. b) Billing submitted monthly for reimbursement. Payments received to date cover July to January. c) Reimbursements requested quarterly. Juvenile Crime Prevention adjusted for increased amount of award. d) CEOJJC has placed the Administrative Analyst position on its payroll and assumed 100% responsibility for this position as of October 1st. Projection reduced by $34,000 due to the ending of reimbursements from CEOJJC to partially fund this position. DHS payments expected to be lower than budgeted due to a decrease in number of youth in program. DHS began using a new disbursement system in December delaying processing of payments. e) Lease revenue less than estimated in budget due to Rimrock and Interfaith moving out mid year. f) Budget for Level 7 revenues overestimated by $10,000. g) Personnel Services projection reduced due to unfilled budgeted positions. Sheriff - Fund 255 Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date RESOURCES: Beg. Net Working Capital $ Revenues Law Enf Dist Countywide Law Enf Dist Rural Interest Total Revenues TOTAL RESOURCES Budget Actual Variance 13,347,667 8,245,213 FY % J Coll. %J $ 138,600 $ 138,600 100% 11,664,391 (1,683,276) 67% 7,700,565 (544,648) 67% 32,873 32,873 67% 21,592,880 19,397,829 (2,195,051) 67% 21,592,880 19,536,429 (2,056,451) 67% REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 1,494,204 Civil 789,820 Automotive/Communications 871,644 Investigations/Evidence 1,140,534 Patrol/Civil/Comm Supp 5,198,631 Records 443,803 Adult Jail 6,575,005 Court Security 143,423 Emergency Services 116,949 Special Services Division 858,424 Regional Work Center 1,772,532 Training Division 161,853 Non -Departmental 29,150 Contingency 1,963,577 1,404,542 89,662 67% 724,020 65,800 67% 906,011 (34,367) 67% 1,073,831 66,703 67% 5,018,643 179,988 67% 447,728 (3,925) 67% 6,049,170 525,835 67% 133,369 10,054 67% 110,778 6,171 67% 912,810 (54,386) 67% 1,664,456 108,076 67% 146,621 15,232 67% 35,050 (5,900) 67% 1,963,577 67% Budget - Year End Projection Variance n/a $ $ 138,600 $ 138,600 58% a) 20,021,501 17,342,507 (2,678,994) 62% a) 12,367,820 11,000,347 (1,367,473) n/a 32,873 32,873 60% 32,389,321 28,375,727 (4,013,594) 60% 32,389,321 28,514,327 (3,874,994) Exp. % 63% b) 61% c) 69% d) 63% e) 64% f) 67% 61% g) 62% 63% 71% 63% h) 60% 80% n/a Transfers Out 33,333 25,000 8,333 67% 50% TOTAL REQUIREMENTS 21,592,882 18,652,029 2,940,853 67% 58% NET (Resources - Requirements) (2) 884,400 884,402 Beginning NWC per Requested Budget 2,241,306 1,184,729 1,307,464 1,710,801 7,797,946 665,705 9,862,507 215,135 175,424 1,287,636 2,658,798 242,780 43,725 2,945,365 2,196,306 1,144,729 1,277,364 1,626,801 7,497,946 665,605 9,262,507 215,035 175,324 1,286,034 2,658,798 242,680 43,725 50,000 50,000 45,000 40,000 30,100 84,000 300,000 100 600,000 100 100 1,602 100 2,945,365 32,389,321 28,342,854 4,046,467 171,473 171,473 RESOURCES: Beg. Net Working Capital Total Revenues SHERIFF -Expenditure Detail Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual 1 Variance 1 FY %I Coll. % Revised Budget Year End Projection Variance $ - $ 138,600 $ 138,600 100% n/a $ - $ 138,600 $ 138,600 21,592,880 19,397,829 (2,195,051) 67% 60% 32,389,321 28,375,727 (4,013,594) TOTAL RESOURCES 21,592,880 19,536,429 (2,056,451) 67% 60% 32,389,321 28,514,327 (3,874,994) REQUIREMENTS: Sheriffs Services Personnel 764,084 746,436 17,648 67% 65% 1,146,126 1,126,126 20,000 Materials & Services 548,453 542,322 6,131 67% 66% 822,680 822,680 Capital Outlay 181,667 115,784 65,883 67% 42% 272,500 247,500 25,000 Total Sheriff's Services 1,494,204 1,404,542 89,662 2,241,306 2,196,306 45,000 Civil Personnel 725,879 688,822 37,057 67% 63% 1,088,818 1,048,818 40,000 Materials & Services 42,786 35,198 7,588 67% 55% 64,179 64,179 Capital Outlay 21,155 - 21,155 67% 0% 31,732 31,732 - Total Civil 789,820 724,020 65,800 1,184,729 1,144,729 40,000 Automotive/Communications Personnel 256,966 219,968 36,998 67% 57% 385,449 355,449 30,000 Materials & Services 614,610 686,043 (71,433) 67% 74% 921,915 921,915 Capital Outlay 67 67 67% 0% 100 100 Total Automotive/Communications 871,643 906,011 (34,368) 1,307,464 1,277,364 30,100 I nvestigations/Evidence Personnel 954,346 913,785 40,561 67% 64% 1,431,519 1,401,519 30,000 Materials & Services 170,188 136,736 33,452 67% 54% 255,282 201,282 54,000 Capital Outlay 16,000 23,310 (7,310) 67% 97% 24,000 24,000 Total Investigations/Evidence 1,140,534 1,073,831 66,703 1,710,801 1,626,801 84,000 Patrol/Civil/Comm Support Personnel 4,611,038 4,316,617 294,421 67% 62% 6,916,557 6,616,557 300,000 Materials & Services 360,873 384,811 (23,938) 67% 71% 541,309 541,309 Capital Outlay 226,720 317,215 (90,495) 67% 93% 340,080 340,080 - Total Patrol/Civil/Comm Supp 5,198,631 5,018,643 179,988 7,797,946 7,497,946 300,000 Records Personnel 388,164 388,225 (61) 67% 67% 582,246 582,246 Materials & Services 55,573 59,503 (3,930) 67% 71% 83,359 83,359 Capital Outlay 67 67 67% 0% 100 100 Total Records 443,804 447,728 (3,924) 665,705 665,605 100 Adult Jail Personnel 5,010,927 4,632,298 378,629 67% 62% 7,516,390 7,116,390 400,000 Materials & Services 910,078 856,255 53,823 67% 63% 1,365,117 1,365,117 Capital Outlay 654,000 560,617 93,383 67% 57% 981,000 781,000 200,000 Total Adult Jail 6,575,005 6,049,170 525,835 9,862,507 9,262,507 600,000 Court Security Personnel 133,004 129,433 3,571 67% 65% 199,506 199,506 - Materials & Services 10,353 3,936 6,417 67% 25% 15,529 15,529 Capital Outlay 67 - 67 67% 0% 100 - 100 Total Transport/Court Security 143,424 133,369 10,055 215,135 215,035 100 Emergency Services Personnel 105,688 104,098 1,590 67% 66% 158,532 158,532 Materials & Services 11,195 6,680 4,515 67% 40% 16,792 16,792 Capital Outlay 67 67 67% 0% 100 100 Total Emergency Services 116,950 110,778 6,172 175,424 175,324 100 Special Services Personnel 544,375 524,312 20,063 67% 64% 816,563 816,563 Materials & Services 115,285 91,955 23,330 67% 53% 172,928 172,928 • Capital Outlay 198,763 296,543 (97,780) 67% 99% 298,145 296,543 1,602 Total Special Services 858,423 912,810 (54,387) 1,287,636 1,286,034 1,602 Regional Work Center Personnel 1,447,680 1,487,082 (39,402) 67% 68% 2,171,520 2,246,520 (75,000) Materials & Services 303,519 154,380 149,139 67% 34% 455,278 380,278 75,000 Capital Outlay 21,333 22,994 (1,661) 67% 72% 32,000 32,000 Total Regional Work Center 1,772,532 1,664,456 108,076 2,658,798 2,658,798 Training Personnel 128,927 121,494 7,433 67% 63% 193,391 193,391 Materials & Services 32,859 25,127 7,732 67% 51% 49,289 49,289 - Capital Outlay 67 67 67% 0% 100 100 Total Training 161,853 146,621 15,232 242,780 242,680 100 Non -Departmental Materials & Services 29,150 35,050 (5,900) 67% 80% 43,725 43,725 - Transfers Out 33,333 25,000 8,333 67% 50% 50,000 50,000 Contingency 1,963,577 - 1,963,577 67% n/a 2,945,365 2,945,365 Total Non -Departmental 2,026,060 60,050 1,966,010 3,039,090 93,725 2,945,365 Total Requirements 21,592,883 18,652,029 2,940,854 67% 58% 32,389,321 28,342,854 4,046,467 Exp. % NET (Resources - Requirements) (3) 884,400 884,403 171,473 171,473 Sheriff Notes Statement of Financial Operating Data Eight Months Ended February 28, 2009 a) IGA with Countywide & Rural Law Enforcement Districts, based on actual costs and payment, is adjusted to actual quarterly. Actual 1st and 2nd quarter expenditures were Tess than budgeted. Actual expenditures for FY 2009 are projected to be less than budgeted. b) Sheriffs Services Division year-to-date variance is due to timing of Capital Projects and one open position which has been filled. Expenditures for capital software will be Tess than planned for the year. c) Personnel expenditures in Civil will be less than budget by approximately $40,000 for the year due to unfilled budgeted positions. d) Automotive/Communications year-to-date variance is due to timing of budget and actual purchase of material and services for new car preparation. Personnel expenses for the year will be less than budgeted due to an open position which was filled in the 2nd quarter. e) Expenditures of $54,000 planned for Byrne Grant will not be incurred as the grant was not renewed. In addition, personnel expenditures will be $30,000 below plan due to unfilled open positions. f) Personnel expenditures in Patrol will be less than budget by approximately $300,000 for the year due to unfilled budgeted employee positions. g) Adult Jail year-to-date variance is due to delays in filling open positions. Capital expenditures for the jail control panel system project will be incurred later in the year and will be less than budgeted. The delays in hiring and lower capital expenditures will result in the Adult Jail expenditures at $600,000 less than budgeted. h) Work Center year-to-date variance due to timing of expenditures for inmate Addictions Treatment programs and other expenses related to inmate population. RESOURCES: Beg. Net Working Capital $2,560,294 $ 2,611,374 $ 51,080 67% n/a $ 2,560,294 $2,611,374 $ 51,080 Revenues Tax Revenues - Current 9,712,394 13,478,667 3,766,273 67% 93% a) 14,568,591 14,262,941 (305,650) Tax Revenues - Prior 179,635 443,407 263,772 67% 165% b) 269,452 524,846 255,394 Federal Grants 13,333 35,354 22,021 67% n/a 20,000 35,354 15,354 State Grant 30,104 52,476 22,372 67% 116% c) 45,156 69,000 23,844 Transp. of State Wards 3,333 (3,333) 67% 0% 5,000 5,000 - SB 1145 1,290,546 1,451,865 161,319 67% 75% d) 1,935,819 1,815,704 (120,115) Des Cty Court Security 86,000 85,736 (264) 67% 66% 129,000 129,000 - Des Cty Juvenile Contract 16,000 3,262 (12,738) 67% 14% e) 24,000 5,000 (19,000) Transport 10,892 10,892 67% n/a 15,000 15,000 Title III Reimbursement 75,000 75,000 67% n/a f) 150,000 150,000 DC Fair & Expo Center 5,415 5,415 67% n/a - 5,415 5,415 Local Gov't Pmts - 2,235 2,235 67% n/a 2,235 2,235 Inmate Commissary Fees 40,000 48,131 8,131 67% 80% 60,000 60,000 - Work Center Work Crews 100,000 22,605 (77,395) 67% 15% g) 150,000 35,820 (114,180) Concealed Handgun Classes 1,067 4,950 3,883 67% n/a 1,600 6,000 4,400 Soc Sec Incentive -Fed 2,667 5,800 3,133 67% 145% 4,000 6,000 2,000 Miscellaneous 333 1,441 1,108 67% 288% 500 4,026 3,526 Oregon Mentors 4,414 4,414 67% n/a 8,000 8,000 Medical Services Reimb 8,000 11,441 3,441 67% 95% 12,000 12,000 Restitution 700 265 (435) 67% 25% 1,050 1,050 Sheriff Fees 102,410 112,830 10,420 67% 73% 153,615 153,615 Interest 30,000 60,556 30,556 67% 135% 45,000 85,000 40,000 Interest on Unsegregated 2,400 6,245 3,845 67% 173% 3,600 10,600 7,000 Rentals 21,882 59,177 37,295 67% 180% h) 32,824 62,824 30,000 Donations 48 48 67% n/a 48 48 Total Revenues 11,640,804 15,982,212 4,341,408 67% 92% 17,461,207 17,464,478 3,271 Sheriff 701 Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance FY % ) Coll. % Budget Year End Projection Variance TOTAL RESOURCES 14,201,098 18,593,586 4,392,488 67% 93% 20,021,501 20,075,852 54,351 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 13,347,668 11,664,391 1,683,277 67% 58% i) 20,021,501 17,342,507 2,678,994 Exp. % TOTAL REQUIREMENTS 13,347,668 11,664,391 1,683,277 67% 58% 20,021,501 17,342,507 2,678,994 NET (Resources - Requirements) 853,430 6,929,195 6,075,765 - 2,733,345 2,733,345 Beginning NWC per Requested Budget 2,470,519 a) Historically, 85% of property tax receipts are collected through November. Projections based on data provided by Tax Office. b) Delinquent prior year taxes exceeded amounts estimated. c) Revised State funding allocation. d) Forecast reflects State Corrections reduction in 4th Qtr 1145 inmate housing payment. e) Expect less revenue for court security from the Juvenile Department. f) Title III revenue was not included in FY2009 budget due to uncertainty of Timber Payments renewal. g) Expect revenue to increase as work crews expand but work crew revenue will be less than budgeted due to economic down turn. h) Rental receipts from 911 not included in FY 2009 budget due to uncertainty of 911 levy passing. i) IGA with DCSO based on actual costs and payment is adjusted to actual each quarter. Actual expenditures for 1st and 2nd quarters were less than budgeted. Sheriff 702 Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance 1 FY % Coll. % RESOURCES: Beg. Net Working Capital $ 1,169,561 $ 1,178,512 $ 8,951 67% n/a $ 1,169,561 $ 1,178,512 $ 8,951 Revenues Tax Revenues - Current 4,731,223 6,593,478 1,862,255 67% 93% a) 7,096,836 6,961,631 (135,205) Tax Revenues - Prior 85,857 246,457 160,600 67% 191% b) 128,785 279,869 151,084 Federal Grants 19,000 13,892 (5,108) 67% 49% 28,500 28,500 US Forest Service 48,000 25,125 (22,875) 67% 35% 72,000 72,000 - State Grant 52,928 59,020 6,092 67% 74% 79,392 79,392 SB #1065 Court Assessment 44,667 36,290 (8,377) 67% 54% 67,000 67,000 Marine Board License Fee 65,963 50,014 (15,949) 67% 51% c) 98,944 137,527 38,583 Narcotic Task Force 73,333 27,500 (45,833) 67% 25% d) 110,000 27,500 (82,500) Des Cty General Fund Grnt 143,320 (143,320) 67% 0% e) 214,980 471,980 257,000 Des Cty Transient Room Tax 1,623,347 1,623,347 67% 67% 2,435,020 2,178,020 (257,000) Des Cty Other Grant 84,111 (84,111) 67% 0% f) 126,167 (126,167) City of Sisters 262,170 266,676 4,506 67% 68% 393,255 400,014 6,759 Des Cty Tax/Fin Contract 1,833 860 (973) 67% 31% 2,750 2,750 - Des Cty CDD Contract 36,243 31,712 (4,531) 67% 58% g) 54,365 33,978 (20,387) Des Cty Solid Waste Cntrt 36,243 40,772 4,529 67% 75% g) 54,365 74,752 20,387 Des Cty Clerk/Election 2,000 2,026 26 67% 68% 3,000 3,000 - Security & Traffic Reimb 17,333 1,316 (16,017) 67% 5% h) 26,000 13,000 (13,000) Seat Belt Program 4,000 5,150 1,150 67% 86% 6,000 6,000 - Miscellaneous 1,667 7,868 6,201 67% n/a 2,500 13,655 11,155 Sheriff Fees 3,333 4,332 999 67% n/a 5,000 5,000 Court Fines & Fees 56,667 75,172 18,505 67% 88% 85,000 85,000 Impound Fees 50,000 52,200 2,200 67% 70% 75,000 75,000 - Interest 20,000 18,438 (1,562) 67% 61% 30,000 30,000 Interest on Unsegregated 1,600 3,055 1,455 67% 127% 2,400 5,400 3,000 Grants - Private 6,000 6,000 67% n/a 6,000 6,000 Sale of Equip & Material 667 5,195 4,528 67% 520% 1,000 6,000 5,000 Total Revenues 7,465,505 9,195,896 1,730,391 67% 82% 11,198,259 11,062,968 (135,291) Budget Year End Projection Variance TOTAL RESOURCES 8,635,066 10,374,407 1,739,341 67% 84% 12,367,820 12,241,480 (126,340) REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 8,245,213 Exp. % 7,700,565 544,648 67% 62% g) 12,367,820 11,000,347 1,367,473 TOTAL REQUIREMENTS 8,245,213 7,700,565 544,648 67% 62% 12,367,820 11,000,347 1,367,473 NET (Resources - Requirements) 389,853 2,673,842 2,283,989 - 1,241,133 1,241,133 Beginning NWC per Requested Budget 1,287,473 a) Historically, 85% of property tax receipts are collected through November. Projections based on data provided by Tax Office. b) Delinquent prior year taxes exceeded amounts estimated. c) Marine Board contract higher than plan due to reimbursement of extra marine patrol. Reimbursements are received in Feb and June. d) Additional Byrne Grant revenue will not be received this year. e) Payment from Deschutes County (General Fund) will be made in June 2009. f) Court fines and fees collected by Justice Court will be less than expenses resulting in no transfer to Sheriffs Office (M. Wynne). g) Adjustment made in law enforcement service levels between CDD and Solid Waste. IGA with DCSO based on actual costs and payment is adjusted to actual each quarter. Actual expenditures for 1st and 2nd quarters were less than budgeted. h) Fewer events requiring patrol/traffic control services. HEALTH Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget l Actual Variance FY % Coll. % Revised Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 707,000 $ 972,436 $ 265,436 100% 138% $ 707,000 $ 972,436 $ 265,436 Revenues Medicare Reimbursement 2,667 1,548 (1,119) 67% 39% a) 4,000 4,000 State Grant 1,062,543 1,156,689 94,146 67% 73% b) 1,593,814 1,861,301 267,487 Child Dev & Rehab Center 23,158 16,701 (6,457) 67% 48% c) 34,737 34,737 State Miscellaneous 177,223 145,207 (32,016) 67% 55% 265,834 265,834 STARS Foundation 2,650 2,650 67% n/a - 2,650 2,650 OMAP 180,000 174,234 (5,766) 67% 65% 270,000 270,000 Family Planning Exp Proj 316,667 259,998 (56,669) 67% 55% d) 475,000 400,000 (75,000) Grants 20,008 20,008 67% n/a 20,008 20,008 Contract Payments/ESD 5,333 - (5,333) 67% 0% e) 8,000 8,000 Miscellaneous 904 904 67% n/a 904 904 Patient Insurance Fees 60,967 116,905 55,938 67% 128% f) 91,450 131,450 40,000 Health Dept/Patient Fees 148,333 105,514 (42,819) 67% 47% f) 222,500 182,500 (40,000) Vital Records -Birth 26,667 22,605 (4,062) 67% 57% 40,000 40,000 Vital Records -Death 62,667 69,745 7,078 67% 74% 94,000 94,000 Interest on Investments 25,333 18,431 (6,902) 67% 49% 38,000 28,000 (10,000) Donations 6,067 5,121 (946) 67% 56% 9,100 9,100 Interfund Contract 84,161 27,220 (56,941) 67% 22% g) 126,242 113,160 (13,082) Administrative Fee 18,000 18,000 67% 67% 27,000 27,000 Interfund Grant 10,713 10,713 67% n/a - 10,713 10,713 Total Revenues 2,199,786 2,172,193 (27,593) 67% 66% 3,299,677 3,503,357 203,680 Transfers In -Reserve Fund Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 16,667 - (16,667) 67% 0% 25,000 25,000 1,760,824 1,760,824 - 67% 67% 2,641,236 2,641,236 4,684,277 4,905,453 237,843 67% 74% 6,672,913 7,142,029 469,116 Exp. % 3,029,713 3,014,404 15,309 67% 66% 4,544,569 4,536,160 8,409 937,686 888,286 49,400 67% 63% b) 1,406,529 1,506,529 (100,000) 50,000 47,227 2,773 67% 63% 75,000 47,227 27,773 100,000 75,000 25,000 67% 50% 150,000 150,000 331.210 331,210 67% n/a 496.815 496,815 TOTAL REQUIREMENTS 4,448,609 4,024,917 423,692 67% 60% 6,672,913 6,239,916 432,997 NET (Resources - Requirements) 235,668 880,536 661.535 902,113 902,113 Beginning NWC per Requested Budget 900,000 a) Corrections required to DCHD Medicare status, application process. Most claims currently on hold. b) Projection includes revisions 1 - 8 to State Grant. Some of additional resources will be expended as M & S. c) Payments received quarterly during the October 08 through September 09 contract period. d) Payments are received one month in arrears. e) $4,000 received in March. f) Began billing private insurance for immunizations - budgeted to bill patients direct. g) Second quarter payment will be received in March. MENTAL HEALTH Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget RESOURCES: Beg. Net Working Capital $ 2,750,000 $ 2,695,308 $ (54,692) 100% 98% $ 2,750,000 $ 2,695,308 $ (54,692) Revenues Marriage Licenses 3,667 3,580 (87) 67% 65% 5,500 5,500 Divorce Filing Fees 83,333 78,071 (5,262) 67% 62% 125,000 125,000 Domestic Partnership Fee 1,333 85 (1,248) 67% n/a 2,000 200 (1,800) Federal Grants 160,995 29,229 (131,766) 67% 12% a)b) 241,492 229,184 (12,308) State Grants 3,611,419 3,581,834 (29,585) 67% 66% 5,417,129 5,393,386 (23,743) State Miscellaneous 119,811 96,068 (23,743) 67% 53% c) 179,716 179,716 Title 19 200,470 159,036 (41,434) 67% 53% 300,705 300,705 Liquor Revenue 70,667 71,626 959 67% 68% 106,000 106,000 - School Districts 66,667 41,400 (25,267) 67% 41% d) 100,000 70,000 (30,000) Contract Payments 7,020 7,020 67% n/a - 14,040 14,040 Miscellaneous 58,533 65,178 6,645 67% 74% 87,800 75,300 (12,500) Patient Insurance Fees 145,000 98,747 (46,253) 67% 45% 217,500 160,000 (57,500) Patient Fees 7,667 5,391 (2,276) 67% 47% 11,500 8,500 (3,000) Interest on Investments 48,667 58,375 9,708 67% 80% 73,000 88,000 15,000 Rentals 11,000 8,500 (2,500) 67% 52% 16,500 16,500 - Donations 6,667 100 (6,567) 67% 1% 10,000 3,500 (6,500) lnterfund Contract 2,080 7,724 5,644 67% 248% 3,120 8,764 5,644 Administrative Fee 1,931,200 1,917,571 (13,629) 67% 66% 2,896,800 2,876,800 (20,000) Crime Prevention Services 95,923 79,283 (16,640) 67% 55% b) 143,884 143,884 Actual Variance I FY % Coll. % Revised Year End Budget Projection Variance Total Revenues 6,625,099 6,308,818 (316,281) 67% 63% 9,937,646 9,804,979 (132,667) Transfers In -General Fund 1,033,933 1,033,933 - 67% 67% 1,550,899 1,550,899 Transfers In -Other 302,550 337,883 35,333 67% 74% 453,825 506,825 53,000 TOTAL RESOURCES 10,711,582 10,375,942 (335,640) 67% 71% 14,692,370 14,558,011 (134,359) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency Exp. %, 5,602,850 5,309,725 293,125 67% 63% e) 8,404,275 7,790,000 614,275 2,983,187 2,472,289 510,898 67% 55% 4,474,780 3,894,000 580,780 67 67 67% 0% 100 100 100,000 75,000 25,000 67% 50% 150,000 150,000 - 1,108,810 1,108,810 67% n/a 1,663,215 1,663.215 TOTAL REQUIREMENTS 9,794,914 7,857,014 1,937,900 67% 53% 14,692,370 11,834,000 2,858,370 NET (Resources - Requirements) 916,668 2,518,928 1,602,260 - 2,724,011 2,724,011 Beginning NWC per Requested Budget 2,725,000 a) Negative variance due to an adjustment for over -accrual of FY 2008 revenue. b) Grant billing paid quarterly, in arrears. Anticipated receipt of $27,692 in March 2009. c) State miscellaneous YTD actual variance due to historical 30-60 day delay in receiving payment. d) Services to school districts commence at start of school year and are billed monthly in arrears. e) Anticipated salary savings due to unfilled positions and reduce work schedule beginning March 1, 2009. COMMUNITY DEVELOPMENT Statement of Financial Operating Data Eight Months Ended February 28 2009 Year to Date Budget 1 Actual J Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ (2,777,224) $(2,667,071) $ 110,153 100% 96% $(2,777,224) $(2,667,071) 110,153 Revenues Admin -Operations 23,500 (9,898) (33,398) 67% -28% a) 35,250 (25,325) (60,575) Admin -GIS 3,333 1,411 (1,922) 67% 28% b) 5,000 2,075 (2,925) Admin -Code Enforcement 205,667 121,446 (84,221) 67% 39% c) 308,500 172,275 (136,225) Building Safety 1,147,800 595,968 (551,832) 67% 35% c) 1,721,700 785,575 (936,125) Electrical 303,417 163,542 (139,875) 67% 36% c) 455,125 225,100 (230,025) Contract Services 354,667 165,789 (188,878) 67% 31% d) 532,000 207,500 (324,500) Env Health -On Site Prog 486,467 168,907 (317,560) 67% 23% c) 729,700 239,600 (490,100) Env Health-Lic Facilities 456,767 586,428 129,661 67% 86% e) 685,150 652,850 (32,300) Env Health - Drinking H2O 51,311 52,556 1,245 67% 68% d) 76,967 89,871 12,904 Planning -Current 920,983 603,133 (317,850) 67% 44% c) 1,381,475 798,950 (582,525) Planning -Long Range 403.863 164,650 (239,213) 67% 27% c) 605,795 539,266 (66,529) Total Revenues 4,357,775 2,613,932 (1,743,843) 67% 40% 6,536,662 3,687,737 (2,848,925) Trans In -CDD Reserve 1,654,741 1,399,756 (254,985) 67% 56% 2,482,111 2,486,574 4,463 Trans In -CDD Bldg/Elec 1,505,150 1,144,255 (360,895) 67% 51% 2,257,725 2,366,145 108,420 Trans In -Gen Fund 133,333 133,333 0% n/a f) 0 200,000 200,000 Trans In -Newberry (297) 55,143 131,666 76,523 0% 159% g) 82,714 281,641 198,927 Trans In -Other 67 - (67) 0% 0% 100 (100) TOTAL RESOURCES 4,795,652 2,755,871 (2,039,781) 67% 32% 8,582,088 6,355,026 (2,227,062) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Division 1,432,133 Admin -GIS Division 176,501 Admin -Code Enforcement 163,956 Building Safety Division 722,467 Electrical Division 239,841 Contract Services 190,668 Env Health -On Site Pgm 229,031 Env Health-Lic Facilities 361,740 Env Health - Drinking H2O 58,705 EPA Grant 55,250 Planning -Current Division 726,636 Planning -Long Range Div 425,567 Transfers Out (D/S Fund) Contingency 822,231 Exp. % 1,336,381 95,752 67% 62% h) 2,148,200 1,940,221 207,979 155,180 21,321 67% 59% h) 264,751 239,508 25,243 146,147 17,809 67% 59% h) 245,934 217,008 28,926 691,284 31,183 67% 64% h) 1,083,700 941,467 142,233 205,861 33,980 67% 57% h) 359,761 287,465 72,296 193,496 (2,828) 67% 68% 286,002 297,105 (11,103) 193,338 35,693 67% 56% h) 343,547 310,689 32,858 339,169 22,571 67% 63% h) 542,610 502,416 40,194 53,251 5,454 67% 60% h) 88,057 82,615 5,442 47,016 8,234 67% 57% h) 82,875 85,276 (2,401) 666,987 59,649 67% 61% h) 1,089,954 925,463 164,491 308,900 116,667 67% 48% h) 638,351 614,121 24,230 150,000 86% 175,000 150,000 25,000 822,231 67% n/a 1,233,346 - 1,233,346 TOTAL REQUIREMENTS 5,604,726 4,487,010 1,267,716 67% 52% 8,582,088 6,593,354 1,988,734 NET (Resources - Requirements) (809,074) (1,731,139) (772,065) - (238,328) (238,328) Beginning NWC per Requested Budget (436,529) Revenues 2,613,932 3,687,737 Expenditures 4,487,010 6,593,354 Net from Operations (1,873,078) (2,905,617) a) Revenue is low in relation to budget due to reduced Addressing Fee, Road Access permits, and interest. b) Payments for custom GIS work are received as work is requested. c) Although revenue is seasonal based on development patterns, year end projections are estimated below budget. d) Revenue is received as clients are billed, usually lagging 1-2 months behind. Projected below budget (Contract Svcs). e) Revenue is received primarily in December through February after license renewal statements are mailed out. f) A transfer from the General Fund for long range planning. g) Funds to be transferred in from Fund 297. Amount includes FY 07-08 transfer. h) Year end figures adjusted downward to reflect anticipated personnel reduction and reduced work week (36 hours). Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ (2,777,224) $(2,667,071) $ 110,153 100% 96% $(2,777,224) $(2,667,071) 110,153 Revenues Admin -Operations 23,500 (9,898) (33,398) 67% -28% a) 35,250 (25,325) (60,575) Admin -GIS 3,333 1,411 (1,922) 67% 28% b) 5,000 2,075 (2,925) Admin -Code Enforcement 205,667 121,446 (84,221) 67% 39% c) 308,500 172,275 (136,225) Building Safety 1,147,800 595,968 (551,832) 67% 35% c) 1,721,700 785,575 (936,125) Electrical 303,417 163,542 (139,875) 67% 36% c) 455,125 225,100 (230,025) Contract Services 354,667 165,789 (188,878) 67% 31% d) 532,000 207,500 (324,500) Env Health -On Site Prog 486,467 168,907 (317,560) 67% 23% c) 729,700 239,600 (490,100) Env Health-Lic Facilities 456,767 586,428 129,661 67% 86% e) 685,150 652,850 (32,300) Env Health - Drinking H2O 51,311 52,556 1,245 67% 68% d) 76,967 89,871 12,904 Planning -Current 920,983 603,133 (317,850) 67% 44% c) 1,381,475 798,950 (582,525) Planning -Long Range 403.863 164,650 (239,213) 67% 27% c) 605,795 539,266 (66,529) Total Revenues 4,357,775 2,613,932 (1,743,843) 67% 40% 6,536,662 3,687,737 (2,848,925) Trans In -CDD Reserve 1,654,741 1,399,756 (254,985) 67% 56% 2,482,111 2,486,574 4,463 Trans In -CDD Bldg/Elec 1,505,150 1,144,255 (360,895) 67% 51% 2,257,725 2,366,145 108,420 Trans In -Gen Fund 133,333 133,333 0% n/a f) 0 200,000 200,000 Trans In -Newberry (297) 55,143 131,666 76,523 0% 159% g) 82,714 281,641 198,927 Trans In -Other 67 - (67) 0% 0% 100 (100) TOTAL RESOURCES 4,795,652 2,755,871 (2,039,781) 67% 32% 8,582,088 6,355,026 (2,227,062) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Division 1,432,133 Admin -GIS Division 176,501 Admin -Code Enforcement 163,956 Building Safety Division 722,467 Electrical Division 239,841 Contract Services 190,668 Env Health -On Site Pgm 229,031 Env Health-Lic Facilities 361,740 Env Health - Drinking H2O 58,705 EPA Grant 55,250 Planning -Current Division 726,636 Planning -Long Range Div 425,567 Transfers Out (D/S Fund) Contingency 822,231 Exp. % 1,336,381 95,752 67% 62% h) 2,148,200 1,940,221 207,979 155,180 21,321 67% 59% h) 264,751 239,508 25,243 146,147 17,809 67% 59% h) 245,934 217,008 28,926 691,284 31,183 67% 64% h) 1,083,700 941,467 142,233 205,861 33,980 67% 57% h) 359,761 287,465 72,296 193,496 (2,828) 67% 68% 286,002 297,105 (11,103) 193,338 35,693 67% 56% h) 343,547 310,689 32,858 339,169 22,571 67% 63% h) 542,610 502,416 40,194 53,251 5,454 67% 60% h) 88,057 82,615 5,442 47,016 8,234 67% 57% h) 82,875 85,276 (2,401) 666,987 59,649 67% 61% h) 1,089,954 925,463 164,491 308,900 116,667 67% 48% h) 638,351 614,121 24,230 150,000 86% 175,000 150,000 25,000 822,231 67% n/a 1,233,346 - 1,233,346 TOTAL REQUIREMENTS 5,604,726 4,487,010 1,267,716 67% 52% 8,582,088 6,593,354 1,988,734 NET (Resources - Requirements) (809,074) (1,731,139) (772,065) - (238,328) (238,328) Beginning NWC per Requested Budget (436,529) Revenues 2,613,932 3,687,737 Expenditures 4,487,010 6,593,354 Net from Operations (1,873,078) (2,905,617) a) Revenue is low in relation to budget due to reduced Addressing Fee, Road Access permits, and interest. b) Payments for custom GIS work are received as work is requested. c) Although revenue is seasonal based on development patterns, year end projections are estimated below budget. d) Revenue is received as clients are billed, usually lagging 1-2 months behind. Projected below budget (Contract Svcs). e) Revenue is received primarily in December through February after license renewal statements are mailed out. f) A transfer from the General Fund for long range planning. g) Funds to be transferred in from Fund 297. Amount includes FY 07-08 transfer. h) Year end figures adjusted downward to reflect anticipated personnel reduction and reduced work week (36 hours). ROAD Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $6,392,830 $ 6,392,830 $ 0 100% 100% $ 6,392,830 $ 6,392,830 $ 0 Revenues System Development Ch 13,333 1,386 (11,947) 67% 7% 20,000 1,500 (18,500) Mineral Lease Royalties 3,333 106,241 102,908 67% n/a h) 5,000 106,241 101,241 Forest Receipts 1,838,453 2,759,606 921,153 67% 100% a) 2,757,680 2,759,606 1,926 State Grant 1,126,204 1,689,307 563,103 67% 100% b) 1,689,306 1,689,307 1 State Miscellaneous - 5,758 5,758 67% n/a b) 344,113 344,113 Motor Vehicle Revenue 5,100,000 4,973,407 (126,593) 67% 65% 7,650,000 7,350,000 (300,000) City of Bend 166,667 206,121 39,454 67% 82% c) 250,000 215,000 (35,000) City of Redmond 266,667 11,781 (254,886) 67% 3% c) 400,000 250,000 (150,000) City of Sisters 33,333 - (33,333) 67% 0% c) 50,000 (50,000) City of La Pine 11,103 11,103 67% n/a c) - 11,103 11,103 Admin Recovery (SDC) 67% n/a - 350 350 Miscellaneous 26,667 22,288 (4,379) 67% 56% 40,000 30,500 (9,500) Road Vacations 667 500 (167) 67% 50% 1,000 1,000 Interest on Investments 83,333 138,034 54,701 67% 110% 125,000 160,000 35,000 Donations 1,627 2,684 1,057 67% 110% 2,440 2,684 244 Interfund Contract 580,000 - (580,000) 67% 0% d) 870,000 709,548 (160,452) Equipment Repairs 200,000 148,616 (51,384) 67% 50% e) 300,000 250,000 (50,000) Vehicle Repairs 66,667 (66,667) 67% 0% d) 100,000 90,000 (10,000) LID Construction 56,667 (56,667) 67% 0% d) 85,000 26,340 (58,660) Vegetation Management 63,333 (63,333) 67% 0% d) 95,000 46,090 (48,910) Inter -fund: Forester 14,667 (14,667) 67% 0% d) 22,000 22,000 Car Washes 2,333 1,514 (819) 67% n/a e) 3,500 2,300 (1,200) Sale of Eqp & Material 450,000 565,160 115,160 67% 84% e) 675,000 800,000 125,000 Sale of Public Lands 133 (133) 67% 0% 200 200 - Total Revenues 10,094,084 10,643,506 549,422 67% 70% 15,141,126 14,867,882 (273,244) Trans In - CDD 17,327 12,995 (4,332) 67% 50% 25,990 25,990 Trans In - Solid Waste 574,313 430,735 (143,578) 67% 50% f) 861,470 861,470 - Trans In -Road Imp Res 3,894 (3,894) 67% 0% 5,841 5,841 - Revised Budget Year End Projection Variance TOTAL RESOURCES 17,082,448 17,480,066 397,618 67% 76% 22,427,257 22,154,013 (273,244) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency Exp. % 3,751,381 3,644,888 106,493 67% 65% 5,627,071 5,506,148 120,923 7,389,195 4,044,290 3,344,905 67% 36% g) 11,083,793 8,985,120 2,098,673 2,433,333 251,612 2,181,721 67% 7% g) 3,650,000 2,480,000 1,170,000 200,000 200,000 67% 0% 300,000 300,000 1,177,595 1,177,595 67% n/a 1,766,393 1,766,393 TOTAL REQUIREMENTS 14,951,504 7,940,790 7,010,714 67% 35% 22,427,257 17,271,268 5,155,989 NET (Resources - Requirements) 2,130,944 9,539,276 7,408,332 - 4,882,745 4,882,745 Beginning NWC per Requested Budget a) Annual payment to be received in January 2009. b) Senate Bill 994 ODOT pmt 11/01/08 $1,230,565 balance STP due upon billing. c) Billing upon completion of work. d) Payment to be received in June 2009 from various funds. e) Billed to County departments monthly in arrears. f) Payment to be received quarterly from Solid Waste. g) Seasonal expense includes overlays to occur Spring 2009. h) Mineral lease income is unknown for future. 4,871,665 ADULT PAROLE & PROBATION Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 663,144 $ 700,907 $ 37,763 100% 106% $ 663,144 $ 700,907 $ 37,763 Revenues State Subsidy 21,927 State Miscellaneous SB 1145 1,935,963 Probation Work Crew Fees 22,667 Miscellaneous 3,333 Electronic Monitoring Fee 73,333 Probation Superv. Fees 166,667 Interest on Investments 18,777 Crime Prevention Services Drug Court - Byrne 33,333 Total Revenues 2,276,000 26,203 4,276 67% 80% a) 32,890 29,226 (3,664) 4,301 4,301 67% n/a g) 8,000 8,000 2,177,797 241,834 67% 75% b) 2,903,945 2,714,945 (189,000) 34,073 11,406 67% 100% d) 34,000 46,100 12,100 2,125 (1,208) 67% 43% 5,000 3,000 (2,000) 115,101 41,768 67% 105% c) 110,000 164,575 54,575 164,602 (2,065) 67% 66% 250,000 231,596 (18,404) 20,586 1,809 67% 73% 28,165 28,165 12,500 12,500 67% n/a 25,000 25,000 5,816 (27,517) 67% 12% f) 50,000 23,600 (26,400) 2,563,104 287,104 67% 75% 3,414,000 3,274,207 (139,793) Transfers In -General Fund 104,719 104,719 67% 67% 157,078 157,078 Transfers In -Video Lottery 70,667 70,667 - 67% 67% 106,000 106,000 Transfers In -Sheriff 33,333 25,000 (8,333) 67% 50% 50,000 50,000 TOTAL RESOURCES 3,147,863 3,464,397 316,534 67% 79% 4,390,222 4,288,192 (102,030) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 2,130,966 1,963,303 167,663 67% 61% 3,196,449 2,949,262 247,187 461,506 555,557 (94,051) 67% 80% e) 692,259 833,747 141,488 67 67 67% 0% 100 100 334,276 - 334,276 67% n/a 501,414 - 501,414 TOTAL REQUIREMENTS 2,926,815 2,518,860 407,955 67% 57% 4,390,222 3,783,009 890,189 NET (Resources - Requirements) 221,048 945,537 724,489 505,183 788,159 Beginning NWC per Requested Budget 497,892 a) Received two quarters of subsidy with one year's worth of AIP funds. b) Funding for two quarters received. c) Increased use of Electronic Monitoring Devices, in lieu of jail sanctions. Increased court requests for EMD's. d) New Community Service Specialist has increased efficiency of program thus service population being managed closer and has better collection rate e) Recent reorganization required building modifications for Redmond and Bend offices. f) Byrne grant hasn't released funds. Have requested payment again. g) New revenue from Parole Board to conduct Morrissey Hearings. The total amount should be about $8,000. Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 663,144 $ 700,907 $ 37,763 100% 106% $ 663,144 $ 700,907 $ 37,763 Revenues State Subsidy 21,927 State Miscellaneous SB 1145 1,935,963 Probation Work Crew Fees 22,667 Miscellaneous 3,333 Electronic Monitoring Fee 73,333 Probation Superv. Fees 166,667 Interest on Investments 18,777 Crime Prevention Services Drug Court - Byrne 33,333 Total Revenues 2,276,000 26,203 4,276 67% 80% a) 32,890 29,226 (3,664) 4,301 4,301 67% n/a g) 8,000 8,000 2,177,797 241,834 67% 75% b) 2,903,945 2,714,945 (189,000) 34,073 11,406 67% 100% d) 34,000 46,100 12,100 2,125 (1,208) 67% 43% 5,000 3,000 (2,000) 115,101 41,768 67% 105% c) 110,000 164,575 54,575 164,602 (2,065) 67% 66% 250,000 231,596 (18,404) 20,586 1,809 67% 73% 28,165 28,165 12,500 12,500 67% n/a 25,000 25,000 5,816 (27,517) 67% 12% f) 50,000 23,600 (26,400) 2,563,104 287,104 67% 75% 3,414,000 3,274,207 (139,793) Transfers In -General Fund 104,719 104,719 67% 67% 157,078 157,078 Transfers In -Video Lottery 70,667 70,667 - 67% 67% 106,000 106,000 Transfers In -Sheriff 33,333 25,000 (8,333) 67% 50% 50,000 50,000 TOTAL RESOURCES 3,147,863 3,464,397 316,534 67% 79% 4,390,222 4,288,192 (102,030) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 2,130,966 1,963,303 167,663 67% 61% 3,196,449 2,949,262 247,187 461,506 555,557 (94,051) 67% 80% e) 692,259 833,747 141,488 67 67 67% 0% 100 100 334,276 - 334,276 67% n/a 501,414 - 501,414 TOTAL REQUIREMENTS 2,926,815 2,518,860 407,955 67% 57% 4,390,222 3,783,009 890,189 NET (Resources - Requirements) 221,048 945,537 724,489 505,183 788,159 Beginning NWC per Requested Budget 497,892 a) Received two quarters of subsidy with one year's worth of AIP funds. b) Funding for two quarters received. c) Increased use of Electronic Monitoring Devices, in lieu of jail sanctions. Increased court requests for EMD's. d) New Community Service Specialist has increased efficiency of program thus service population being managed closer and has better collection rate e) Recent reorganization required building modifications for Redmond and Bend offices. f) Byrne grant hasn't released funds. Have requested payment again. g) New revenue from Parole Board to conduct Morrissey Hearings. The total amount should be about $8,000. COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 571,035 $ 532,187 $ (38,848) 100% 93% $ 571,035 $ 532,187 $ (38,848) Revenues Federal Grants 157,850 157,845 (5) 67% 67% a) 236,775 310,560 73,785 Title IV - Family Sup/Pres 25,101 27,178 2,077 67% 72% a) 37,652 40,982 3,330 HealthyStart Medicaid 86,667 23,655 (63,012) 67% 18% b) 130,000 95,000 (35,000) Child Care Block Grant 50,441 8,719 (41,722) 67% 12% a) 75,661 61,113 (14,548) Level 7 Services 116,795 155,303 38,508 67% 89% a) 175,193 201,546 26,353 Juvenile Crime Prevention 264,700 283,038 18,338 67% 71% a) 397,050 471,171 74,121 State Prevention Funds 91,667 125,624 33,957 67% 91% f)g) 137,500 187,499 49,999 HealthyStart /R -S -G 244,011 357,117 113,106 67% 98% b) 366,017 350,605 (15,412) OCCF Grant 492,863 779,986 287,123 67% 106% j) 739,295 861,508 122,213 Miscellaneous 5,333 6,728 1,395 67% 84% 8,000 8,000 Court Fines & Fees 16,000 41,266 25,266 67% 172% c)g) 24,000 75,000 51,000 Interest on Investments 16,667 23,199 6,532 67% 93% d) 25,000 40,000 15,000 Miscellaneous/Crime Prev - 26,755 26,755 67% n/a k) 82,733 82,733 Grants -Private 6,667 (6,667) 67% 0% e) 10,000 (10,000) Total Revenues 1,574,762 2,016,413 441,651 67% 85% 2,362,143 2,785,717 423,574 Budget Year End Projection Variance Trans from General Fund Trans from GF -Other Total Transfers In 234,197 234,197 - 67% 67% 351,295 351,295 4,594 3,446 (1,148) 67% 50% 6,891 6,891 238,791 237,643 (1,148) 67% 66% 358,186 358,186 TOTAL RESOURCES 2,384,588 2,786,243 401,655 67% 85% 3,291,364 3,676,090 384,726 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 378,761 328,419 50,342 67% 58% i) 568,142 478,750 89,392 1,522,275 1,301,575 220,700 67% 57% g)h) 2,283,412 2,572,697 (289,285) 67 - 67 67% 0% 100 100 - 293,140 - 293,140 67% n/a 439,710 439,710 TOTAL REQUIREMENTS 2,194,243 1,629,994 564,249 67% 50% 3,291,364 3,051,547 239,817 NET (Resources - Requirements) 190,345 1,156,249 965,904 624,543 624,543 Beginning NWC per Requested Budget 624,543 a) FY 2008 revenues received and reported in FY 2009. Final quarter to be received in FY 2010. b) Medicaid revenue projected to be Tess than budget. Refund due to OCCF because of statewide reduction. c) Circuit Court fees increased to Mary's Place. d) Interest revenue will exceed budget because monthly cash balance is higher than expected. e) Youth conference donations projected to be less. Conference cancelled. f) Safe & Drug Free Schools grant amount is $100,000 - budgeted at $50,000. g) $100,999 of additional resources (Safe & Drug Free Schools and Circuit Court fees). h) Increase in discretionary spending of $129,766. Addition of Crime Prevention grants. i) Personnel reduced due to open position, and new hires. j) OCCF grants and M&S increased by $147,000 Community Schools grant. Refund due to OCCF because of statewide reduction. k) Crime prevention fund transfers added to budget. SOLID WASTE Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 1,221,164 $ 1,254,853 $ 33,689 100% 103% $ 1,221,164 $ 1,254,853 $ 33,689 Revenues State Grant 30,667 (30,667) 67% 0% a) 46,000 46,000 Miscellaneous 23,333 19,063 (4,270) 67% 54% 35,000 30,000 (5,000) Refunds/Reimbursements - 15,938 15,938 67% N/A b) 15,938 15,938 Franchise 3% Fees 133,333 92,399 (40,934) 67% 46% c) 200,000 200,000 Commercial Disp. Fees 1,116,477 787,784 (328,693) 67% 47% d) 1,674,716 1,321,000 (353,716) Private Disposal Fees 1,045,143 879,608 (165,535) 67% 56% d) 1,567,714 1,421,000 (146,714) Franchise Disposal Fees 3,217,604 2,807,420 (410,184) 67% 58% d) 4,826,406 4,450,000 (376,406) Yard Debris 46,833 39,999 (6,834) 67% 57% 70,249 75,000 4,751 Special Waste 20,000 11,040 (8,960) 67% 37% e) 30,000 30,000 Interest 66,667 32,211 (34,456) 67% 32% 100,000 43,000 (57,000) Sale of Equip & Material 33,333 53,273 19,940 67% 107% f) 50,000 65,000 15,000 Total Revenues 5,733,390 4,738,735 (994,656) 67% 55% 8,600,085 7,696,938 (903,148) TOTAL RESOURCES 6,954,554 5,993,587 (960,967) 67% 61% 9,821,249 8,951,790 (869,459) REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency Exp. % 1,209,997 1,187,584 22,413 67% 65% 1,814,996 1,816,455 (1,459) 2,938,438 2,512,387 426,051 67% 57% g) 4,407,657 4,095,470 312,187 647,859 408,859 239,000 67% 42% 971,788 971,788 160,483 97,789 62,694 67% 41% h) 240,725 147,789 92,936 1,240,980 930,735 310,245 67% 50% i) 1,861,470 1,361,470 500,000 349,742 - 349,742 67% n/a 524,613 - 524,613 TOTAL REQUIREMENTS 6,547,499 5,137,354 1,410,145 67% 52% 9,821,249 8,392,972 1,428,277 NET (Resources - Requirements) 407,055 856,233 449,178 558,818 558,818 Beginning NWC per Requested Budget 558,818 a) Habitat for Humanity Project reimbursement funds - will request at project completion in June, 2009. b) Monies refunded from Cedar Creek landscaping contract. c) Franchise fees are due April 15, 2009. d) Downturn in self -haul disposal and curbside collection has caused less revenue in these areas. e) Unpredictable revenue from asbestos and contaminated soil clean-ups. f) Unexpected higher revenues on sale of recyclables; somewhat seasonal - will probably see drop in revenue over the winter. g) Some single, large budget items cause this number to fluctuate. h) Only $50,000 paving of access road remains to be done. i) Will not be transferring the balance. Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 1,221,164 $ 1,254,853 $ 33,689 100% 103% $ 1,221,164 $ 1,254,853 $ 33,689 Revenues State Grant 30,667 (30,667) 67% 0% a) 46,000 46,000 Miscellaneous 23,333 19,063 (4,270) 67% 54% 35,000 30,000 (5,000) Refunds/Reimbursements - 15,938 15,938 67% N/A b) 15,938 15,938 Franchise 3% Fees 133,333 92,399 (40,934) 67% 46% c) 200,000 200,000 Commercial Disp. Fees 1,116,477 787,784 (328,693) 67% 47% d) 1,674,716 1,321,000 (353,716) Private Disposal Fees 1,045,143 879,608 (165,535) 67% 56% d) 1,567,714 1,421,000 (146,714) Franchise Disposal Fees 3,217,604 2,807,420 (410,184) 67% 58% d) 4,826,406 4,450,000 (376,406) Yard Debris 46,833 39,999 (6,834) 67% 57% 70,249 75,000 4,751 Special Waste 20,000 11,040 (8,960) 67% 37% e) 30,000 30,000 Interest 66,667 32,211 (34,456) 67% 32% 100,000 43,000 (57,000) Sale of Equip & Material 33,333 53,273 19,940 67% 107% f) 50,000 65,000 15,000 Total Revenues 5,733,390 4,738,735 (994,656) 67% 55% 8,600,085 7,696,938 (903,148) TOTAL RESOURCES 6,954,554 5,993,587 (960,967) 67% 61% 9,821,249 8,951,790 (869,459) REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency Exp. % 1,209,997 1,187,584 22,413 67% 65% 1,814,996 1,816,455 (1,459) 2,938,438 2,512,387 426,051 67% 57% g) 4,407,657 4,095,470 312,187 647,859 408,859 239,000 67% 42% 971,788 971,788 160,483 97,789 62,694 67% 41% h) 240,725 147,789 92,936 1,240,980 930,735 310,245 67% 50% i) 1,861,470 1,361,470 500,000 349,742 - 349,742 67% n/a 524,613 - 524,613 TOTAL REQUIREMENTS 6,547,499 5,137,354 1,410,145 67% 52% 9,821,249 8,392,972 1,428,277 NET (Resources - Requirements) 407,055 856,233 449,178 558,818 558,818 Beginning NWC per Requested Budget 558,818 a) Habitat for Humanity Project reimbursement funds - will request at project completion in June, 2009. b) Monies refunded from Cedar Creek landscaping contract. c) Franchise fees are due April 15, 2009. d) Downturn in self -haul disposal and curbside collection has caused less revenue in these areas. e) Unpredictable revenue from asbestos and contaminated soil clean-ups. f) Unexpected higher revenues on sale of recyclables; somewhat seasonal - will probably see drop in revenue over the winter. g) Some single, large budget items cause this number to fluctuate. h) Only $50,000 paving of access road remains to be done. i) Will not be transferring the balance. RESOURCES: Beginning Net Working Capital Revenues Inter -fund Charges: Risk Management Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance ',/o of F' % Coll. $2,500,000 $2,549,708 $49,708 100% 102% Budget Year End Projection Variance $2,500,000 $2,549,708 $49,708 General Liability 267,940 267,936 (4) 67% 67% 401,910 401,910 Property Damage 190,863 190,864 1 67% 67% 286,294 286,294 Vehicle 119,559 119,230 (329) 67% 66% 179,338 179,338 Workers' Compensation 643,539 672,296 28,757 67% 70% 965,309 965,309 Unemployment 101,150 107,008 5,858 67% 71% 151,725 151,725 Claims Reimb-Workers' Compensation 2,000 29,554 27,554 67% 985% 3,000 29,554 26,554 Claims Reimb-Gen Liab/Property 13,333 81,186 67,853 67% 406% 20,000 90,000 70,000 Process Fee-Events/Parades 200 245 45 67% n/a 300 300 Miscellaneous 3,333 - (3,333) 67% 0% 5,000 5,000 Skid Car Training 16,667 13,650 (3,017) 67% 55% 25,000 25,000 Interest on Investments 33,333 51,642 18,309 67% 103% 50,000 62,000 12,000 TOTAL REVENUES 1,391,917 1,533,611 141,694 67% 73% 2,087,876 2,196,430 108,554 Transfers In -PERS Reserve 67 (67) 67% 0% 100 (100) TOTAL RESOURCES 3,891,984 4,083,319 191,335 67% 89% 4,587,976 4,746,138 158,162 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit 16,366 Defense 1,050 Miscellaneous 5 Professional Service 7,312 Insurance 148,552 Loss Prevention 204 Total General Liability 866,667 173,488 866,667 67% 13% a) 1,300,000 400,000 900,000 PROPERTY DAMAGE Insurance 149,933 Professional Service 48 Repair / Replacement 72,077 Total Property Damage 223,333 222,058 223,333 67% 66% 335,000 335,000 . VEHICLE Professional Service 942 Repair / Replacement 30,757 Insurance 471 Loss Prevention 8,208 Total Vehicle 106,667 40,379 106,667 67% 25% b) 160,000 80,000 80,000 WORKERS' COMPENSATION Settlement / Benefit 429,104 Professional Service 6,250 Insurance 24,845 Loss Prevention 7,142 Miscellaneous 22,588 Workers' Comp Losses 55,401 Total Workers' Compensation 476,667 545,330 476,667 67% 76% c) 715,000 815,000 (100,000) UNEMPLOYMENT - Settlement / Benefits 43,333 96,554 (53,221) 67% 149% d) 65,000 150,000 (85,000) Total Direct Insurance Costs 1,716.667 1,077,809 1,620,113 67% 42% 2,575,000 1,780,000 795,000 Insurance Administration: Personal Services 240,771 195,007 45,764 67% 54% 361,157 361,157 Materials & Service 128,003 95,024 32,979 67% 49% 192,004 192,004 - Capital Outlay 67 67 67% 0% 100 - 100 Total Insurance Administration 368,841 290,031 78,810 67% 52% 553,261 553,161 100 Contingency 973,143 - 973.143 67% n/a 1,459,715 1,459,715 TOTAL APPROPRIATIONS/EXPENDITURES 3,058,651 1,367,840 2,672,066 67% 30% 4,587,976 2,333,161 2,254,815 NET 833,333 2,715,479 2,863,400 2,412,977 2,412,977 % Exp. NWC per Requested Budget 2,491,977 a) Savings is based on lower than expected year-to-date expenditures; offset by last year actuals and insurance premium charge. b) Savings is based on lower than expected year-to-date expenditures. c) Year end projection is higher than budget due to settlement/closing of $140,000 claim and a $90,000 settlement. d) Year end projection is higher than budget due to CDD layoffs, increased unemployment claims, and a new law which extends the time period for unemployment. RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges P/T Emp - Add'I Prem Employee Prem Contribution COIL Retiree / COBRA Co -Pay Medical Services Reimb Prescription Rebates Interest Total Revenues TOTAL RESOURCES Health Benefits Trust Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance FY % Coll. % Revised Budget Year End Projection Variance $14,000,000 $14,862,418 $ 862,418 100% 106% $14,000,000 14,862,418 $ 862,418 8,318,200 8,479,758 161,558 67% 87,333 33,868 (53,465) 67% 239,911 229,740 (10,171) 67% 533,333 777,543 244,210 67% 266,667 411,439 144,772 67% 11,986 11,986 67% 17,440 17,440 67% 250.000 301,526 51,526 67% REQUIREMENTS Expenditures: Personal Services Materials & Services Conferences and Seminars Claims Paid-Medical/Rx Claims Paid-Dental/Vision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Printing Program Supplies Other Total Materials & Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 9,695,444 10,263,300 567,856 67% 23,695,444 25,125,718 68% a) 26% b) 64% 97% 103% 12,477,300 131,000 359,866 800,000 400,000 n/a n/a 80% 375,000 71% 14,543,166 15,285,096 741,930 12,719,804 51,000 339,866 1,120,000 600,000 11,986 17,440 425,000 242,504 (80,000) (20,000) 320,000 200,000 11,986 17,440 50,000 1,430,274 92% 88% Exp. % 28,543,166 30,147,514 1,604,348 75,810 72,196 3,614 67% 63% 113,715 113,715 2,000 1,410 590 67% 47% 3,000 3,000 7,861,767 6,374,650 1,487,116 67% 54% c) 11,792,650 9,470,909 2,321,741 1,072,745 1,057,224 15,521 67% 66% c) 1,609,117 1,570,733 38,384 (31,846) 31,846 67% n/a (31,846) 31,846 238,341 244,050 (5,710) 67% 68% 357,511 357,511 42,667 134,149 (91,482) 67% 210% d) 64,000 134,149 (70,149) 181,401 183,747 (2,346) 67% 68% 272,102 272,102 31,385 23,205 8,180 67% 49% 47,077 47,077 28,533 32,976 (4,442) 67% 77% 42,800 42,800 5,333 9,023 (3,690) 67% 113% 8,000 9,023 (1,023) 1,333 180 1,153 67% 9% 2,000 500 1,500 10,109 24,126 (14,017) 67% 159% 15,163 35,000 (19,837) 9,475,613 8,052,894 1,422,719 67% 57% 14,213,420 11,910,957 2,302,463 - 67% 0% 100 - 100 9,477,287 9,477,287 67% 0% 14,215,931 14,215,931 19,028,711 8,125,090 10,903,620 67% 28% 28,543,166 12,024,672 16,518,494 4,666,733 17,000,628 12,333,894 18,122,842 18,122,842 a) Projection is the amount budgeted for FY 2009, as amended, for HBT payments in the operating funds. b) Fewer part-time employees opting for plan available to full-time employees. c) Based on annualizing 35 weeks of claims paid; YTD average is $212,339 per week. d) State Assessment is paid in August and January. DESCHUTES COUNTY 911 Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance %of FYI %Coll. Revised Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital $2,393,117 $2,636,885 $ 243,768 100% 110% $2,393,117 $2,636,885 $ 243,768 Revenues Property Taxes - Current 3,984,699 5,574,971 1,590,272 67% 93% a) 5,977,048 5,899,414 (77,634) Property Taxes - Prior 37,767 89,843 52,076 67% 159% b) 56,650 112,022 55,372 State Reimbursement 14,667 18,710 4,043 67% 85% 22,000 22,000 - Telephone User Tax 536,726 647,294 110,568 67% 80% 805,089 805,089 Data Network Reimb. 22,667 25,128 2,461 67% 74% 34,000 33,164 (836) Jefferson County 14,657 32,041 17,384 67% 146% c) 21,985 32,041 10,056 User Fee 22,333 19,429 (2,904) 67% 58% 33,500 33,500 Contract Payments 46,667 58,983 12,316 67% 84% 70,000 70,000 Miscellaneous 5,500 9,156 3,656 67% 111% d) 8,250 9,156 906 Interest 33,333 76,072 42,739 67% 152% e) 50,000 100,000 50,000 Interest on Unsegregated Tax 867 2,499 1,632 67% 192% 1,300 2,499 1,199 Total Revenues 4,719,883 6,554,126 1,834,243 67% 93% 7,079,822 7,118,885 39,063 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency 7,113,000 9,191,012 2,078,012 67% 97% 9,472,939 9,755,770 282,831 % Exp. 2,485,350 2,247,980 237,370 67% 60% 3,728,025 3,728,025 590,819 481,480 109,339 67% 54% 886,229 886,229 160,000 160,000 67% 0% f) 240,000 107,022 132,978 88,000 88,000 67% 0% g) 132,000 132,000 86,667 - 86,667 67% 0% 130,000 130,000 2,904,457 2,904,457 67% n/a 4,356,685 - 4,356,685 TOTAL REQUIREMENTS 6,315,293 2,729,460 3,585,833 67% 29% 9,472,939 4,983,276 4,489,663 NET (Resources - Requirements) 797,707 6,461,552 5,663,845 - 4,772,494 4,772,494 Beginning NWC per Requested Budget 5,137,000 a) Historically, 85% of property tax receipts are collected through November. Projections based on data provided by Tax Office. b) Delinquent prior year taxes exceeded amounts estimated. c) Camp Sherman tax revenue. Revise year end projection to reflect previous 8 month history. d) Miscellaneous charges for CAD printouts/tapes revenue is higher than anticipated. e) Based on the first 8 months of actual, the interest for FY 2009 will be projected at $100,000. f) Payment required for FY 2009 on Deschutes County FF&C 2008A borrowing (construction of new building). az C � o� O ›- + t Q 4 cO 2 0. to 2 2 4_ A 0 4 01 A M1 ad 47 r 66x'1.7 6 No CO 0 00000 oA f1 o o co t•a 0r- r- cu • co 4.-. ' co CP e:1'!+ O v 4 4)600 ' 5vN1 a 41 OA V 4F w OA N 'V M1 0 kr 4 • {y {7 4) v .�. v 57 n ' N `R 0 pQ 0 (00 ••— 0 NCO 4] in CSF 0. 0 0 4 0 0 0 QUA 6 o O in 0 4 4 0 0 0 0 4 0 Cy O Q.© 6 0) 0 y7 04(0O0cp 0O004 o7CD 0 A� O(0 w 0O O 0d o 0 CD 0,q 2000 M(4 A 474AA r 4A40lO 4A4 to r94)4A CO Q o 4) QNn 0760 L°1 c0 in C4 4 (.4 P r< 4- co 4 4 611 N S•7 0 0 7- C0 0 COA CG3 6`V co r co M1 co, (0i ' M1 , 4J 4 CO r 0 c•7 0 0 6 C, o N M 1.7. Cs Ai 4' o CO - co 4 6 N 0) CD cV 04 LA el I. O Kl !+ a CV N r•. 4 <4 4 A 0of 0'� M M1 ri of. r+ 0.7 4`A v -i 0) +t1` sr r 4 a-- to co ,yr ca 47 V o as o No 4 II1 in 4 0.4 44 n o 44'S 0 0 0 640 o C•] 4 6 • 0 C+A ae(0g (0C°' N N tr) • 0 0 0 4 0 0 A 0 6 o O o 0 0 0.A 0 41 4 t4 44 4F �" M N r 4 n rA C0`� �.O ce -in 0 n r 4] N 0 0 ••u61 ' 0 4 •0 47 - N 4 4 in s� 0 0 0 0 0 C 4f A to 47 0 , 0 m 0 4 , tl] 4] r -v 4 4 0 Q 4 60 4 6 00 0 0 0b' 47 6' o O' • 0. ' 0 0 P O '4 [V el. s} 9' M 4' 4), Cn--'.4) C O 0 m ©0000ooe)p 4 0 0 o A D 0 0 046 000676+4 47 4A A' N o v e O 047 d 0 0 I77 O 441 1D n r7 L7 4i 4 N 4 4 r C9QcA 04 0 �' 0 1rA 4 v] 6'! CO T 00 CO r64) r-0 O M1 Nn f7Y C'4 0 4 410 et400 0 G yy` 4601 C£A v co C1A CO dA 647 OA a4 ems] q0 ' NCa61 0`M1" 00 401 4 W M1ONd�iM1 ` C4 c'V ' SS141 r A 60 QC0 0 v SG .- r (4 Oi 0 c4+`5 ^ 0 N [N n 0 4) O o r+ Of. 4! c+7 CT 0 r r 4 N [p 47 0 in 641 4 a CW Q2 0LO AN C^y e.. 4 ' oN LSV 671 ' LOT ' b .- v- c9. ' 4 M co - Cg 0 C•7 C(] CO CO [O I4) C4 WI N CnA 4 0] CO A 4) d o' q U a 41 [4'40 2 )4 •M •4 u"] " F 41 6 • u�tr +r'0 CO � 4-) n 44 CO CO 1M1mp T 1" co pp 0 CS1 O 0 p n o e7-• . 0. • • 0 v o • 4 0) 0• V r 8 0 Q i I 6 .-'4(46 0 aq v "� P7 u5 0 0 z e r0.1 04 0 el CO o 40 . . a) 4isi Co n co SO CD 04 `i' • ' v_ N OD CD CO 0 QR O v ' . CO 4 r 1F cciN I0 r- ". n C4 aS 6 CO -0 V 04 00 d r'' O e. R MCa MF V' AM o COO01 al C ti r". 43 vi en 4- M !+ co 4') o e2 r- - 0 4 ,- el --0 A CO cr; N' CO r r t 0 e 4Tr .44 c'7 ,4 00 0 n 4F ' C A 9 41 40 04 0 VQ' 177 r 610+_ M. N a0i ) 0 v f4 I 1 1.0 7.. 4 Q 4 ,Yr 41 4-A 4 04 C n 4 1-- • 00 ti ' A N ' ' CO J]pI� 3 fit), ' C') 7ta 1 X41 I 8 VD r- r- N A 6 0 ea O4 in +ni' 0 . 0 r I 0 4 Q 0 q in co0 m A N Q ` 6 M M r- Cat .� CtO'el G1 r 00 CD 0 Co 4 N 443) d C1) 0 0M1N 4) II II CO PF a Cr) u. N a) �A nA [ V)40.. WIY 0 m' + 4 11 a' cy. N u v cF C � yaro m as 8 2.2 li RESOURCES: Beg. Net Working Capital Receipts: Security & Traffic Reimb Miscellaneous Vending Machines Telephone Fees - Events Special Events Revenues Interest Parking Fees Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Interfund Contract Video Lottery Total Receipts Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency Deschutes County - Fair and Expo Center YTD -Budget Basis Statement of Financial Operating Data Eight Months Ended February 28, 2009 Year to Date Budget Actual Variance FY % Coll. % Year End Budget Projection Variance $ 150,000 $ 142,470 $ (7,530) 100% 95% $ 150,000 $ 142,470 $ (7,530) 20,000 4,096 9,820 298 700 256,848 2,236 3,000 2,000 389,000 5,328 36,000 2,000 6,000 138,500 35,000 10,000 16,211 1,260 1,743 92,621 47,000 646,828 432,832 468,026 365,177 1,264,854 940,479 564,000 516,976 73,990 45,000 67,000 121,808 534,132 376,797 73,990 67,000 (15,904) 67% 12% 35,000 19,096 (15,904) 9,820 67% 245% 4,000 13,820 9,820 (2,702) 67% 5% 6,000 3,298 (2,702) (1,300) 67% 14% 5,000 3,700 (1,300) (132,152) 67% 42% 610,000 477,848 (132,153) (3,092) 67% 28% 8,000 2,635 (5,365) - 67% 0% 4,000 4,000 (19,789) 67% 24% 67,000 47,211 (19,789) (740) 67% 8% 15,000 14,260 (740) (4,257) 67% 3% 55,000 50,743 (4,257) (45,879) 67% 33% 280,000 234,121 (45,879) 12,000 67% 49% 95,000 107,000 12,000 67% 0% 45,000 45,000 (10,000) 67% 0% 10,000 (10,000) (213,996) 67% 35% 1,239,000 1,022,731 (216,269) (102,850) 67% 58% 633,203 530,353 (102,850) (324,375) 67% 47% 2,022,203 1,695,554 (326,649) 29,868 67% 140,179 67% (0) 67% 45,000 67% 67% 121,808 67% TOTAL REQUIREMENTS 1,388,774 1,051,919 Exp. % 63% 49% 63% 0% 86% n/a 846,075 775,739 117,104 45,000 78,000 160,285 811,382 598,031 117,104 67,000 34,693 177,708 45,000 11,000 160,285 336,855 67% 52% 2,022,203 1,593,517 428,686 NET (Resources - Requirements) (123,920) (111,441) 12,479 Accrued Revenue (Accounts Receivable): Current Month Events 43,470 Prior Months 19,947 Total Accounts Receivable 63,417 102,037 102,037 Deposits Received for Future Events: FY 2009: March April May June FY 2010 August September October November December January February March May June FY 2011 & Beyond TOTAL 52,481 1 5,252 3,450 2,400 1,150 500 4,230 4,550 725 100 300 250 100 700 38,460 114,648 Deschutes County Fair and Expo Center Statement of Financial Operating Data February 2009 Budget Actual Variance RESOURCES: Beg. Net Working Capital Receipts: Security & Traffic Reimb 5,000 - (5,000) Miscellaneous 6,674 6,674 Vending Machines Telephone Fees - Events - 420 420 Special Events Revenues 52,000 36,755 (15,245) Interest 666 53 (613) Parking Fees Storage 2,000 888 (1,112) Camping at F & E - 1,260 1,260 Horse Stall Rental 2,000 1,155 (845) Concession % - Food 34,000 16,000 (18,000) Rights (Signage, etc.) Interfund Contract - - Video Lottery Total Receipts 95,666 63,205 (32,461) Transfer In: GF, TRT, Welcome Center Total Transfers TOTAL RESOURCES 95,666 63,205 (32,461) REQUIREMENTS: Expenditures: Personal Services 70,500 66,130 4,370 Materials and Services 64,622 52,338 12,284 Debt Service Capital Outlay Transfers Out - - Contingency TOTAL REQUIREMENTS 135,122 118,468 16,654 NET (Resources - Requirements) (39,456) (55,263) (15,807) Deschutes County Fair and Expo Center Accounts Receivable February 28, 2009 Current Month Globetrotters 14,631 High Desert Green Conference 3,461 USFS Training 2,485 Central OR High School Equestrian 6,894 Food & Beverage Estimate 16,000 Total Current Month 43,470 Prior Months: January, 2009 Food & Beverage (Received 3/2/09) 15,130 October, 2008 Hunter Jumpers 1,000 KRDM Dance 1,002 August, 2008 White Stallion Productions 2,000 April, 2006 NW Expo & Trade show 815 Total Prior Months 19,947 Total Accrued Revenue as of February 28, 2009 63,417 RESOURCES: Beg. Net Working Capital Revenues Grants - Private Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service (Negative Int Rev) TOTAL REQUIREMENTS Deschutes County Bethlehem Inn (Fund 128) February 28, 2009 Year to Date Budget Actual f Variance IFY % Coll. % $ (2,600,000) $ (2,619,549) $ (19,549) 100% 101% a) $ (2,600,000) $ (2,619,549) $ (19,549) - 17% 0% 2,700,000 2,700,000 - 17% 0% 2,700,000 2,700,000 (2,600,000) (2,619,549) (19,549) 17% -2620% 100,000 80,451 (19,549) Exp. % 51,658 (51.658) 17% 52% b) 100,000 95,000 5,000 51,658 (51,658) 17% 52% 100,000 95,000 5,000 NET (Resources - Requirements) (2,600,000) (2,671,207) (71,207) * (14,549) (14,549) a) The beginning working capital is $19,549 less than estimated for the FY 2009 budget. b) February interest expense was $4,738; average monthly interest is $6,457. Year End Budget Projection Variance $ (2,600,000) $ (2,619,549) $ (19,549) 100% 101% a) $ (2,600,000) $ (2,619,549) $ (19,549) - 17% 0% 2,700,000 2,700,000 - 17% 0% 2,700,000 2,700,000 (2,600,000) (2,619,549) (19,549) 17% -2620% 100,000 80,451 (19,549) Exp. % 51,658 (51.658) 17% 52% b) 100,000 95,000 5,000 51,658 (51,658) 17% 52% 100,000 95,000 5,000 NET (Resources - Requirements) (2,600,000) (2,671,207) (71,207) * (14,549) (14,549) a) The beginning working capital is $19,549 less than estimated for the FY 2009 budget. b) February interest expense was $4,738; average monthly interest is $6,457. Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Related Travel Expenditures FY 2009 Tammy Baney Conf/Sem & Educ/Training Travel Meals Jul Aug 1 Sep I Oct Nov Dec Jan Feb YTD Total Accommodations Airfare Mileage reimbursement 74 Ground Transport 2,300 314 - 40 530_ 3,184 - - 40 - - 40 238 - 363 600 278 117x_ 453 104 87 1,113 91 - - 24 - 115 Total Baney 74 2,391 830 117 880 144 617 5,052 Mike Daly Conf/Sem & Educ/Training - - 26 360 Travel Meals - 396 I 12 - 29 Accommodations - - 540 141 - Airfare 1 - 1 - - - _ Mileage reimbursement - 82242 4.20 331 18 Ground Transport - 441 -- - 15 Total Daly 522 26 ! 1,154 1 561 374 1 Dennis Luke Conf/Sem & Educ/Training 386 437 680 1,092 59 18 2,654 Travel Meals 26 219 1 - - i 25 260 70 575 66 25 25 141 Accommodations Airfare Mileage reimbursement Ground Transport 429 ' 98 15 , 98 98 738 85 , 137 246 , 239 228 1 248 279 1,461 Total Luke 85 163 895 362 308 n 631 472 ! 2,916 Alan Unger Conf/Sem & Educ/Training Travel Meals Accommodations Airfare Mileage reimbursement Ground Transport Total Unger BOCC Staff - 1 70 70 70 70 Conf/Sem & Educ/Training Travel Meals Accommodations Airfare Mileage reimbursement Ground Transport Total BOCC Staff 16 - 16 16 1 - 16 Total - BOCC Department Conf/Sem & Educ/Training Travel Meals Accommodations Airfare Mileage Reimbursement Ground Transport Total - BOCC Department FY 2009 Budget Percent Expended 1. 2,352 I 893 - - 1 3001 670 1 4,215 396 - 12 25 134 25 25 1 618 - 1 1,207 238 ' 378 98 i 98 ; 2,019 241 137 766 i 77.6. 1,011 386 I 365 3,682 44 91 - - 1 39, - - 174 681 2,580 2,879 1,039 , 1,563 ' 809 1,158 � d I 10,708 21,250 50.4% 3/5/2009 Deschutes County, OR Full Faith & Credit Obligations, Series 2009 SMTWTFmime S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 :: APRIL- :: SMTWTF S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Responsible Parties County Deschutes County BC K&L Gates FA Western Fin Grp OS Editor - NW Resources UW Piper Jaffray WG Working Group Date Task Description Responsible Parties Fri -Mar -13 Fri -Mar -13 Circulate numbers for POS Form 1 update to MDAC Mon -Mar -16 Circulate updated POS/send to Moody's Mon -Mar -16 UW to contact Assured Guaranty and provide analysis on insurance Wed -Mar -18 Circulate updated legal documents for POS UW FA FA UW BC Fri -Mar -20 Final comments on POS/legal docs/BPA WG Mon -Mar -23 Circulate final legal documents to include in POS , circulate draft Bond Purchase BC Agreeement (BPA) Mon -Mar -23 Receive rating FA Tue-Mar-24 Final typing of POS/ Distribute POS (include Treasury) FA/UW Mon -Mar -30 PRE -PRICE County/FA/UW Tue-Mar-31 PRICE , Sign BPA County/FA/UW Wed -Apr -1 Form 2 to MDAC; finalize OS FA Wed -Apr -1 Final OS to printer FA Thu -Apr -2 Distribute Final OS (include Treasury) FA Thu -Apr -9 CLOSING WG Updated 3/12/2009 Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, MARCH 30, 2009 1. Finance Update — Marty Wynne 2. Budget Update — Dave Kanner and Marty Wynne 3. Discussion of Termination of Gang Intervention Services Agreement 4. Update of Commissioners' Meetings and Schedules 5. Other Items PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to ORS 192.660(2) (e), real property negotiations; ORS 192.660(2) (h), pending or threatened litigation, or ORS 192.660(2) (b), personnel issues Meeting dates, times and discussion items are subject to change. ,rJll rneetings are conducted in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. If you have questions regarding a meeting, please call 388-6572. Deschutes County meeting locations are wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY. Please call (541) 388-6571 regarding alternative formats or for further information.