Loading...
HomeMy WebLinkAbout2011-03-02 Work Session MinutesQ+' 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 MINUTES OF WORK SESSION DESCHLTTES COUNTY BOARD OF COMMISSIONERS WEDNESDAY, MARCH 2, 2011 Present were Commissioners Alan Unger and Tony DeBone; Commissioner Tammy Baney was out of the office. Also present were Dave Kanner, County Administrator; Erik Kropp, Deputy County Administrator; Marty Wynne, Finance; Dave Inbody, Assistant to the Administrator; Susan Ross and Teresa Rozic, Property & Facilities; and one other citizen. Vice Chair DeBone opened the meeting at 1:30 p.m. 1. Tax/Finance Update. Marty Wynne said that investments are still coming in higher than the investment pool, but it cannot last indefinitely. Regarding the General Fund, the second trimester is completed, taxing districts have gotten their distributions, and tax collections are known, so the forecast will be updated for next month. The County Clerk's revenue will go over budget at this point. Commissioner Unger asked why the District Attorney's numbers are not aligned. Mr. Wynn stated that those departments that cannot pay for themselves, such as the District Attorney, never have enough revenue for this. Dave Kanner said that a grant stream funds the D.A., and they bill against the grant. The budget numbers show 1/12 per month, but the expenditures do not come in that way. The report for the Sheriff's Office has been revised. Under the law enforcement districts, the expenditures as well as the revenue are now shown. Community Development revenue for the first seven months shows over $1 million less than expenditures. All of the special building projects are expected to come at or below budget. Minutes of Board of Commissioners' Work Session Wednesday, March 2, 2011 Page 1 of 5 Pages Susan Ross said that the OSP numbers will get larger and the 911 numbers will get lower; but for this project, it will balance out. The final numbers should be ready soon. Mr. Wynne stated that a check was received from the Bethlehem Inn for $14,000 for current and past rents. UNGER: Move approval of investment guidelines as presented. DEBONE: Second. VOTE: UNGER: Yes. DEBONE: Yes. 2. Request to Release Reversionary Interest on Property. Teresa Rozic said this involves a sliver of land that Bend Metro Park & Recreation wants to utilize. Ownership of the land changed between the private individual and Park & Recreation, and they wish to square up some residual land parcels. LINGER: Move preparation of a release of the reversionary clause. DEBONE: Second. VOTE: UNGER: Yes. DEBONE: Vice Chair votes yes. Ms. Rozic will prepare the appropriate documents. 3. Economic Development Grant Requests. Dave Inbody said that Commissioner Unger has $9,516 remaining in his discretionary economic development account; Commissioner DeBone has $13,500 remaining, and Commissioner Baney has $9,000 left. He had spoken with Commissioner Baney about today's requests and she gave him an idea of what she is willing to grant. • Neighbor Impact ($600) — Veterans support services grant application for consultant services. Mr. Inbody gave an overview of the request. The Commissioners agreed to grant $200 each. Minutes of Board of Commissioners' Work Session Wednesday, March 2, 2011 Page 2 of 5 Pages • Oregon High School Equestrian Teams, Inc ($3,000) — State championships. Commissioner Unger indicated he would grant $500. Commissioner Baney had indicated she would grant $500. Commissioner DeBone agreed to an additional $500. • Serendipity West Foundation ($1,500) — Challenge Day at Mountain View High School. Mr. Inbody said they are expecting several hundred youth to attend, along with a number of adults. Commissioner Unger stated that he attended one and found it was a worthwhile program. The Commissioners granted $500 each. • Nativity Lutheran Church ($2,000) — Backpacks in Bend. Amy Fraley, a representative of the group, explained the item. This has to do with children taking home non-perishable foods on the weekends, through the Bend -La Pine School District. FAN identifies the children and volunteers administer the program under national food guidelines. Commissioner Unger likes what FAN does and this program is a good one. Mr. Inbody said that Commissioner Baney might want to grant $1,000 and ask for a match through another agency. Ms. Fraley said these funds would be designated to the next school year. The need is growing and they are trying hard not to turn anyone down. Commissioner Unger would like to split the $2,000 request three ways. He said that cities look at things differently, and it is harder for them to find the funds to support nonprofits, especially those that are outside of the cities. Commissioner DeBone granted $1,000 and Commissioner Unger granted $500. Commissioner Baney will be asked as to whether she would grant the other $500. Commissioner Unger said that if she does not grant the entire $500, he would pick up the difference. • Deschutes County Children & Families Commission ($3,000) — Week of the Young Child 2011. Mr. Inbody explained the event and the request. Commissioner Baney has agreed to $500; Commissioners DeBone and Unger granted $1,000 each. Minutes of Board of Commissioners' Work Session Wednesday, March 2, 2011 Page 3 of 5 Pages • Tri -County High School Rodeo Club ($2,500) — Tri -County High School Rodeo. Commissioners DeBone and Unger granted $500 each. • Deschutes Public Library Foundation ($1,000) — A Novel Idea: Read Together. Mr. Inbody said this has to do with events to promote reading. Commissioners DeBone and Baney indicated they would contribute $500 each. • FAN Foundation ($500) — Luncheon Fundraiser. Mr. Inbody stated that the Board granted some funds for this event in December. He is not sure whether this request was sent in before the funds were granted. Commissioner Baney said she would grant the $500. Mr. Inbody will find out whether this request preceded the grant that was already awarded. • Volunteer Connect ($1,500) — Volunteer Connect Outreach. These funds would help the group to focus on expanding the program to cover various age groups and the Hispanic community. Commissioner Unger said that they help to connect volunteers with groups that need volunteer help. The Commissioners granted $500 each. 4. Update of Commissioners' Meetings and Schedules. Commissioner Unger said that he would like to get a letter of support signed regarding HB 2867, introduced by Gene Whisnant. It has to do with Deschutes River Mitigation and Conservation efforts. Commissioner DeBone agreed it is appropriate. DEBONE: Move signature of the letter. UNGER: Second. VOTE: UNGER: Yes. DEBONE: Vice Chair votes yes. 5. Other Items. Commissioner DeBone hopes to commit to a Thursday afternoon technology in schools program in La Pine. Minutes of Board of Commissioners' Work Session Wednesday, March 2, 2011 Page 4 of 5 Pages Erik Kropp said a letter of support has been requested from the City of Bend for Neighborhood Stabilization Program funding through HUD and the State. The City is working with COBA (Central Oregon Builders Association) to build LEED certified homes to add to the affordable housing inventory. LINGER: Move signature. DEBONE: Second. VOTE: UNGER: Yes. DEBONE: Vice Chair votes yes. The Board went into Executive Session, under ORS 192.660(2)(i) — Review of the performance of a public official. Being no further discussion, the meeting adjourned at 3:25 p.m. DATED this Day of !i, ctil Deschutes County Board of Commissioners. ATTEST: Recording Secretary 2011 for the Tammy Baney, Chair eqe/f. Anthony DeBone, Vice Chair Alan Unger, Commissioner Minutes of Board of Commissioners' Work Session Wednesday, March 2, 2011 Page 5 of 5 Pages 0 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., WEDNESDAY, MARCH 2, 2011 1. Tax/Finance Update — Marty Wynne 2. Request to Release Reversionary Interest on Property — Susan Ross 3. Economic Development Grant Requests: • Neighbor Impact ($600) — Veterans support services Grant Application Consultant Services • Oregon High School Equestrian Teams, Inc ($3,000) — State championships • Serendipity West Foundation ($1,500) — Challenge Day at Mountain View High School • Nativity Lutheran Church ($2,000) — Backpacks in Bend • Deschutes County Children & Families Commission ($3,000) — Week of the Young Child 2011 • Tri -County High School Rodeo Club ($2,500) — Tri -County High School Rodeo • Deschutes Public Library Foundation ($1,000) — A Novel Idea: Read Together • FAN Foundation ($500) — Luncheon Fundraiser • Volunteer Connect ($1,500) — Volunteer Connect Outreach 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), litigation; ORS 192.660(2)(d), labor negotiations; or ORS 192.660(2) (b), personnel issues. Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Benj 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. Wednesday, March 2, 2011 e-mail address AA97radak2Wik 14 Mailing Address City Zip Phone # Mt/1'2/1'414 ee/fril W-71-01 Z17 -7z7 9771L'/ yr V C W { Work Session (Please Print) Name AIV TY' 1 Pale # of Pages Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA March 2, 2011 (1) Monthly Investment Report (2) January 2011 Financials (3) Approval of revised Investment Policy Guidelines I eschutes ount ��-, -ortoioA • Investment Income Fiscal Year 2010-11 I 9 F- > c m $ 71,485 $ 547,170 Total Investment Income 71,485 547,170 Less Fee: 5% of Invest. Income (3,574) (27,358) Investment Income - Net $ 67,911 $ 519,811 1 Investments By County Function General $ 134,780,861 Total Investments $ 134,780,861 value at Maturit b A ort or • .' • i t e\ o o\ e 0 e 0- e at e n O N • eO co e0 v O O .‘1' O O r T P 11) 0) �7 0) O (CI ' M T Cr; C7 1j) r- 1.6 r- 0. - CO Q) �- a o m ip Z 0 .`fit Q) m a) U EE EQ) O O .E 0 F- CD CD O O f` Total Investments r 4c O 2 O CL o a o IDCOF- 000 0 0 0 N O O O ♦♦♦ u)cts cu fC H ~ = O 02 0 E N E M r M e e e e e e e 0 0 1A 10 10 O 0 0 0 0. N N N T to E °U) N •V 0. a) N QQ)) 1e •c c a o T 4) o 4y- m Z E"' ca < < t O O) Q)0 N @ co `L° a) U E o 0) ui a� .. G)Ea O O U li m F- U U Total Portfolio: By Investment Types d N O Original Cost _UI U_j0 ZIzi2 0!0000100001010'00000 ; zzzzzlzlzzz'zzz:zz.zzz"zz 22 0000 1000 0 .Ig0,0 01 ' zN 0 J C C; • 0 T 0' OI 8! 0 M UI0 7 0 Z 7 6 g 0 0 6 �I C 0 [r o N N N O O V N', 0 C) 0 01 (D 0 A 0 0I N N' 0I (0 0 V 01 A A O N I V A 1 0 A O I M' (01 0 0 0'' O' M co 0) 61 N if) OI N: O M O co u0 c0 (O O U) N V 0 V 0 0 O (0 (D O NH' 01 O (OI 0 M (D O O 01 0 O N (D N A 6 41 O M 0 0 6 co 6 O 6 N 0 0 6 0 O 010 6 N0 (0 O O M O6 O O C) 0)1 V 0 N V V V ', t() M O O 0 001 .- 0 0 N A O (0 V M 0 M 0 0 i0 17 N 1 0 0 0 N 0 0 0 0 0 0 70,7C010( 10 0 O 0 N M O N A r• 0 N N A 0 0 (0 n (D 0 0 A N M V A I O N O O O O O O N v) 0I(0(00019 N M V O 0 A A N N (0 O O �() N N V N {� V O N N A iD N O LD V V OI O N1 0 0 V M N 0 N M! (- o N A M V M M V V V N' N O M e0 N O N N N N, N V 777077010.077000!707070 N O OI N O O OI O 7 O 7 01 N OI 0 0 0, 01 7 N I N I N N N N ,NIN ' N N N N. N 10 (�: N N N r (‚40 (90 ('4.04 O (D V 01 0 0 M A 0 0 0 N 0, 0', 0 0 0 O' 0. V 0 0 0 0' A 0 0 0I N, 0 0 01 01 0I 01 0 0 0 V O N N O O O M (D OI O 0 N O' O 6 0 0 0 0 7 0 0 0 0 0 0 O O 0 0. O 0 O, 0 0 0 0 0 0 7 0 031 (6 O N O M- 1 0 O O 61 0 O O: 0 0 0. N O 0 616,6 O 6,6 N O O O' O� O O O O O N 01077 V.V.M 01 N 0' N NNN(0. V O N: (D' 7 0. N 10 N ,'V N I (0 M N 0 V M V V N (D N O A A V A (D N O. V (0 MIN A V V 0 0 (O 10 7 (0 7 10 J) A V 1 0 .-- 7 0 0) V N A N A M I iD M M I O 70010170 O I N O I O 0 M N 0 n N N I O' 0 V 0 (0D . V .7- M VO N 0 V 0 0 0 0 0 1 0.- 0 M 0 0 M 01 0 V 0:70,07700001000000001710 ('40 O N10 0 oIO r• 0 7 0- 0 0 0 0'0 7 N 7N N N,N N N NI(4, NIN N N N N N NI N' (9 IN N r N,.-17 7 7 7 V - (D N ,30(00 y7 00) 010101 0,07 0- (0 0(0 Vr cc; 0 .O V 0 (OD, bap 0 070 V O 10 (4 0- (D (D 0 N N N 0 10 0101.0 010 O o 0 0 0 0 0 010'10 0 M 0101010.0 01 0101 01 0 O o 0 1 0 0 010010 010 01 01 01 000,00000.0,000'0010N000000010.00000,0007000000 I 0 o r o 0 0 o 0& 0 0 0 6.616 0) 0 0 0 o 0 o 01 0 0 0 0 0 0 0 0 0 0. 0 0 0 0 0 0 0)000)10000 0): (D (0 0 0 0 (D 0 (D N 00000) 0 0 0 0 0 0 01 (0 0 0 00 0 0 0 0 0 0 (O O V (0 0 O 01 0 0 M A 0 0 0 0 0(0 A O O 0 0 N 0 0 0 0 LO O 0', N V A N 0 0 0 O 0 0I 0 O M 0 0 0 0' 0 A 0 A 0 0 0 M 0 0) 0 0 (C) 0 0) 0 0 01 0 0 0 0. N- O M 0 01 O O O O 0 0 f 0) 0 0 0 0 1 0 0100 0 0 0 0 00 0 V 0 V 01 M V N O V ' 10 0 0 0 0 0 0) 0, (D 0 0 0 0 0'0 o1rnl. 0110110 0101 0.01 O O 01 0 0 0. N O 0 N 0.101 0 0 ,'O O"0 0 01101 0 0 .-1 7710101177010_10.7100000070.70. N NIS N N F NI(V (VIN N N N N N. 101 N N N N IN NN NIN N N N N- 1��t !111NHi HL1J SHL . o a 0 00 ,, Q,- a 00 .,,, 4)0O 00 o a o 0 0 0001,001 001 0 • M' 0.VVo , (D I ,Oi) (OD O coil p', N O O ON ON 0 '0i 0 (9'1 00) 0 UO) 0! 10 N O M 0p Mtn H M 0 0 0 0 Lo p0 N N 7 0 OD ODI M' M V r N N 7 O (D (D. M A •O co co OI O A 6 (D. A. (D (0 (DI COl A O (O O, N (0 (D (D O. .- 0' Oil 7 7 7 O. 7 .- .- 0166 0 ,- O O '- ,-1 0 616 O' O O 616 0 O .-- 0; 0 O O 6161 0(D 00 V N (o 66 6 01 01 01 (0 0 (D A 6 7,417 M0'N Oel4 7,33 ▪ )4 o 0.°1•- a, 0 5134,780,861.18 $133,906,845.03 all a o 0( o 0� o o , 0 0.. 0 0. O 0D O . 0 0 0 0 O1 O O O O O O (D A O , O ,06161 0606066661 MO 66 A M M 'L00(0 N, A (V A 0D (0 0 0 vio 666 Io O6 6466661000' , N E CIC Y)1 Eac E 18 E 1 j I 21E , c.2 ,0 21 -1%--- O (D A N N0 V ( n A 0 A 0 0 M M A 100 0 0 (D1 0 0 N M N cO A' 0 N V A r N a y I> .c a 00 n u) N- 10 (0i ((i n 7 (VD (MD (N' N (fi M 0 M u) N ",D In '0 N (VD (MO n(0 N n' (p r r I N I r I(9 I9 n N N, E w!5 N WM,DLON O 6166 01,6 r NN N0N N N0 N 1N4N N N(N4IN N NIN N N N N`DIM 0000000 5, ;5, 0'400.-0.'h'0 '0 0107NN0NNNN0ON0000010100 1 O IU OONO�IN���NO� OOO.-M 01 '0 6 0 0106 6 0 0.0 O O 0,0 0 010 OI'-,� 0 6 0 6166 6 0 0 0 0'0;0I 0I 4 F 0 00 0000,00,00001001010000100000170107001010&7,001007 O 0 N o 01 nlrn rnl0 7 0, rv, (0.lm NNS. -N ON N��NO�NMONNOONOQNO �'N NO SIN O�NOOO© (\') r• M 0 N (� N 0, 0 M 0 0 V N 01 0 N, (J N N o'- 0) 0 0'- 0 O,, '- N 0 0 01 I 0.101 00 0 0 0 0 0 0 010 0 0 0 01010 0 0 0.0 0 0 00 � � � .- 0.I I 1 .161100 O.0'U]O',O,I- OILL;'0 U O LLIce z Z'>'>jH 0. Z LL LO°e 3 (J (oI(n1(nIcn•(0 Y ()] - 7 m E z 6 U 0 0. 0 N 0) 0 0) 11)E 0 M ry N M 0 0 M M M O .0 0. U 001 .1 ZY 00H - J10 M a z MMM 4 <l<1<.Z < 0 010 0,4 4 0 ❑I4 4 4 al4 Z 4 4 4 4 4 Z < OI LL W W1W:0 LL 1- 1-11- WILL LL f- HILL LL LL I LLI(JILL (JILL LL W W. W I -I IZ Zai 0.10] Ce 2 0 100_Z -, 1Z,W 'LLI LL Z ;Z ZLL M U.),W �(C[C[O 70 (n 21�15_71(0-� (.x 1 LL 0.fn 2 �I'(010 4 (0 W 21 • O O N I 0 4A n N HAI 0) V M 0 M (O (") O O O �' Y 2 IL fZQj Y J Z' M g a M V� N (D 9 XI " M (p X (.� A 00 <,"t01<<,<, 4i NN a0 (%1 1M6MIMa,6 MA MMM (0MM0MIMMMM N M M M MIM MIMM M M M M'M M° M M M ("i M 0 0 o 2 Y C mo Z m c cog U a 1 .Y0 0 �Z m, to 0 ?mIU C C NZU U 2U� • CIU N, mLL OiRU0w0o0(G U ml, NIG (0 CI003 • 0CNIW, • NW (09W.Y '' o� m>I>m co 0 m '--,6 0 0 OF0 0 0 1-1- 0C c- 0. L E 0 1IL.. L.., CIM m : N 0103 [011010 4 E „ am •.E ©"m m m 0)114 0 4 < <1ap < (O G J 7 7' TU (0 = g(� 01_1 U 2 CL G O.J J E a--,1101 0E2-0222 �IU 00101 oI oI 0 LL 0 E,u LL x LL o z o E 0 E.x x c) E x LL LL O z o z, o z z LL Z IUIO LL (0(0lt0,Y LL�D,� DILL1LL LL LL I- LL,01711ID'•LL LLId 7 LL,LL LLIx LLIOILL'O LLILL LL u_ Z 0 d U w 0i 0. 1 mem 0 S YIdld re co cnn`(CA17 m UIQ u -•I-11- _ Memorandum Date: February 16, 2011 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find January 2011 financial reports for the following funds: General (001), Community Justice — Juvenile (230), Sheriffs (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice — Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the. respective departments. Cc: All Department Heads GENERAL FUND Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Budget Actual Variance FY % Coll. % Revised Year End $ Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 8,300,000 $ 9,677,699 $ 1,377,699 100% 117% $8,300,000 $9,677,699 $ 1,377,699 Revenues Property Taxes 11,996,833 18,742,943 6,746,110 58% 91% 20,566,000 20,566,000 Gen. Rev. -excl. Taxes 1,398,331 1,870,449 472,118 58% 78% a) 2,397,138 2,397,138 Assessor 464,153 642,328 178,175 58% 81% b) 795,690 795,690 County Clerk 712,083 900,675 188,592 58% 74% 1,220,714 1,220,714 BOPTA 7,232 1,213 (6,019) 58% 10% 12,398 12,398 District Attorney 183,225 89,027 (94,198) 58% 28% 314,100 270,300 (43,800) Finance/Tax 105,117 159,682 54,565 58% 89% b) 180,200 180,200 Veterans 39,589 33,772 (5,817) 58% 50% 67,866 67,866 Property Management 53,160 58,591 5,431 58% 64% 91,132 91,132 Grant Projects 1,167 1,167 (0) 58% 58% 2,000 2,000 Total Revenues 14,960,890 22,499,848 7,538,958 58% 88% 25,647,238 25,603,438 (43,800) TOTAL RESOURCES 23,260,890 32,177,547 8,916,657 58% 95% 33,947,238 35,281,137 1,333,899 REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non -Departmental Contingency Exp. % 1,972,961 1,856,301 116,660 58% 55% 3,382,219 3,382,219 865,741 775,383 90,358 58% 52% 1,484,127 1,484,127 43,985 31,867 12,118 58% 42% 75,403 75,403 2,847,907 2,815,979 31,928 58% 58% 4,882,127 4,748,714 133,413 494,031 506,842 (12,811) 58% 60% 846,910 846,910 152,948 152,490 458 58% 58% 262,197 262,197 147,716 146,870 846 58% 58% 253,227 253,227 65,452 63,838 1,614 58% 57% 112,203 112,203 1,294,642 709,711 584,931 58% 32% 2,219,387 2,219,387 2,943,077 2,943,077 58% Na 5,045,274 5,045,274 10,828,460 7,059,281 3,769,179 58% 38% 18,563,074 13,384,387 5,178,687 Transfers Out 8,618,262 7,562,489 1,055,774 58% 51% c) 14,774,164 14,774,164 TOTAL REQUIREMENTS 19,446,722 14,621,769 4,824,953 58% 44% 33,337,238 28,158,551 5,178,687 NET (Resources - Requirements) 3,814,168 17,555,778 13,741,610 d) 610,000 7,122,586 6,512,586 a) YTD Actual includes annual payments: Federal in lieu of taxes - $471,913 and State tax on electric co-ops - $464,452. b) YTD Actual includes AMT grant received quarterly in advance c) Revised Budget and Year End Projection include $1.8 million transfer of "one time resources". d) Appropriation transferred to Fund 575 - $610,000 COMM JUSTICE -JUVENILE Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Revised Year End Budget Projection Variance Beg. Net Working Capital $ 987,000 $ 1,039,997 $ 52,997 100% 105% $ 987,000 $ 1,039,997 $ 52,997 Revenues Federal Grants SB #1065 -Court Assess. 9,057 3,882 (5,175) 58% 25% a) 15,527 15,527 35,000 28,941 (6,059) 58% 48% 60,000 57,500 (2,500) Discovery Fee 9,333 8,154 (1,179) 58% 51% 16,000 16,000 Food Subsidy 22,167 15,675 (6,492) 58% 41% b) 38,000 37,000 (1,000) OYA Basic & Diversion 198,337 48,917 (149,420) 58% 14% c) 340,006 324,264 (15,742) Inmate/Prisoner Housing 58,333 34,500 (23,833) 58% 35% d) 100,000 80,000 (20,000) Inmate Commissary Fees 58 65 7 58% 65% 100 100 Contract Payments 51,619 36,906 (14,713) 58% 42% 88,490 70,000 (18,490) Miscellaneous 175 52 (123) 58% 17% 300 100 (200) MIP Diversion Fees 583 100 (483) 58% 10% 1,000 300 (700) Interest on Investments 9,917 5,079 (4,838) 58% 30% 17,000 9,000 (8,000) Leases 1,400 1,300 (100) 58% 54% 2,400 2,400 Grants - Private 292 327 35 58% 65% 500 500 Health & Human Svcs Chg 3,500 3,319 (181) 58% 55% 6,000 6,000 CCF Interfund Grant 35,289 48,250 12,961 58% 80% b)e) 60,495 96,500 36,005 Gen Fund Grant -Crime Prev. 11,667 5,000 (6,667) 58% 25% 20,000 20,000 Total Revenues 446,727 240,467 (206,260) 58% 31% 765,818 735,191 (30,627) Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services 3,233,525 3,233,525 - 58% 58% 5,543,186 5,543,186 4,667,252 4,513,989 (153,263) 58% 62% 7,296,004 7,318,374 22,370 Exp. % 1,728,974 1,587,509 141,465 58% 54% f) 2,963,956 2,750,000 213,956 Materials and Services 699,934 588,420 111,514 58% 49% g) 1,199,886 1,100,000 99,886 Capital Outlay 58 58 58% 0% 100 100 Juvenile Resource Center Personal Services 1,350,477 1,237,161 113,316 58% 53% h) 2,315,104 2,200,000 115,104 Materials and Services 102,372 92,700 9,672 58% 53% 175,494 167,000 8,494 Contingency 374,187 374,187 58% n/a 641,464 641,464 TOTAL REQUIREMENTS 4,256,002 3,505,790 750,212 58% 48% 7,296,004 6,217,000 1,079,004 NET (Resources - Requirements) 411,250 1,008,199 596,949 - 1,101,374 1,101,374 a) Second quarter Federal Grant anticipated in March ($7,000 request for reimbursement recently submitted) b) Reimbursements for food subsidy received approximately one month after monthly billings, CCF billed quarterly c) OYA monies collected in Nov, Feb, May, and June - Reduction due to most current information from the State regarding cuts d) Revenue is generated when non -Deschutes juveniles utilize facility - less utilization than anticipated to date e) Additional funding from CCF allocated for Juvenile programs f) Salary savings due to approximately 3.00 FTE unfilled g) DHS/BRS match payments and Maplestar contract payments are less than originally budgeted due to reduction in youth using the program h) Salary savings due to less on-call and overtime for the detention facility Law Enf Dist Countywide 13,317,183 10,484,347 (2,832,836) Law Enf Dist Rural 7,971,798 6,614,369 (1,357,429) RESOURCES: Beg. Net Working Capital $ Revenues SHERIFF - Fund 255 Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Budget Actual Variance FY % Coll. % $ Total Revenues TOTAL RESOURCES 100% n/a $ 58% 46% 22,829,457 18,626,216 (4,203,="1) 58% 48% 13,665,939 11,538,490 (2,127,449) 21,288,981 17,098,716 (4,190,265) 58% 47% 36,495,396 30,164,706 (6,330,690) 21,288,981 17,098,716 (4,190,265) 58% 47% 36,495,396 30,164,706 (6,330,690) REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 1,657,640 1,866,245 (208,605) 58% 66% a) 2,841,668 2,891,668 (50,000) Civil 465,754 484,282 (18,528) 58% 61% 798,436 778,436 20,000 Automotive/Communications 847,604 929,267 (81,663) 58% 64% b) 1,453,036 1,403,036 50,000 Investigations/Evidence 962,962 876,157 86,805 58% 53% b) 1,650,792 1,535,792 115,000 Patrol/Civil/Comm Supp 4,566,713 4,486,782 79,931 58% 57% c) 7,828,651 7,805,651 23,000 Records 385,225 352,330 32,895 58% 53% 660,386 660,386 - Adult Jail 5,744,004 4,985,100 758,904 58% 51% 1) 9,846,864 9,400,864 446,000 Court Security 140,496 156,980 (16,484) 58% 65% 240,851 290,851 (50,000) Emergency Services 101,757 97,311 4,446 58% 56% 174,441 174,441 Special Services Division 680,986 636,621 44,365 58% 55% 1,167,404 1,167,404 Regional Work Center 1,677,808 1,525,248 152,560 58% 53% e) 2,876,242 2,676,242 200,000 Training Division 192,500 146,658 45,842 58% 44% 330,000 300,000 30,000 Other Law Enforcement Svcs 348,202 346,769 1,433 58% 58% 596,917 596,917 Non -Departmental 165,094 48,427 116,667 58% 17% 283,018 283,018 - Contingency 3,235,569 3,235,569 58% n/a 5,546,690 5,546,690 Transfer Out - Jail Remodel 58,333 100,000 (41,667) 58% n/a 100,000 100,000 Transfers Out - D/S Fund 58,333 60,539 (2,206) 58% 61% 100,000 100,000 Exp. % TOTAL REQUIREMENTS 21,288,981 17,098,716 4,190,265 58% 47% 36,495,396 30,164,706 6,330,690 NET (Resources - Requirements) a) Higher than budgeted employee vacation sell back and legal labor expenses b) Delay in filling open positions will result in lower personnel expenditures for FY 2011 c) Projected savings due to open positions will be offset by unplanned purchase of additional patrol vehicles d) Unfilled budgeted positions and less than planned jail bed rental. Forecast includes $146,000 for jail bed rental and $350,000 for JMS software e) Unfilled budgeted positions and lower material and service expenditures projected for FY 2011 Year End Budget Projection Variance n/a $ 58% 46% 22,829,457 18,626,216 (4,203,="1) 58% 48% 13,665,939 11,538,490 (2,127,449) 21,288,981 17,098,716 (4,190,265) 58% 47% 36,495,396 30,164,706 (6,330,690) 21,288,981 17,098,716 (4,190,265) 58% 47% 36,495,396 30,164,706 (6,330,690) REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 1,657,640 1,866,245 (208,605) 58% 66% a) 2,841,668 2,891,668 (50,000) Civil 465,754 484,282 (18,528) 58% 61% 798,436 778,436 20,000 Automotive/Communications 847,604 929,267 (81,663) 58% 64% b) 1,453,036 1,403,036 50,000 Investigations/Evidence 962,962 876,157 86,805 58% 53% b) 1,650,792 1,535,792 115,000 Patrol/Civil/Comm Supp 4,566,713 4,486,782 79,931 58% 57% c) 7,828,651 7,805,651 23,000 Records 385,225 352,330 32,895 58% 53% 660,386 660,386 - Adult Jail 5,744,004 4,985,100 758,904 58% 51% 1) 9,846,864 9,400,864 446,000 Court Security 140,496 156,980 (16,484) 58% 65% 240,851 290,851 (50,000) Emergency Services 101,757 97,311 4,446 58% 56% 174,441 174,441 Special Services Division 680,986 636,621 44,365 58% 55% 1,167,404 1,167,404 Regional Work Center 1,677,808 1,525,248 152,560 58% 53% e) 2,876,242 2,676,242 200,000 Training Division 192,500 146,658 45,842 58% 44% 330,000 300,000 30,000 Other Law Enforcement Svcs 348,202 346,769 1,433 58% 58% 596,917 596,917 Non -Departmental 165,094 48,427 116,667 58% 17% 283,018 283,018 - Contingency 3,235,569 3,235,569 58% n/a 5,546,690 5,546,690 Transfer Out - Jail Remodel 58,333 100,000 (41,667) 58% n/a 100,000 100,000 Transfers Out - D/S Fund 58,333 60,539 (2,206) 58% 61% 100,000 100,000 Exp. % TOTAL REQUIREMENTS 21,288,981 17,098,716 4,190,265 58% 47% 36,495,396 30,164,706 6,330,690 NET (Resources - Requirements) a) Higher than budgeted employee vacation sell back and legal labor expenses b) Delay in filling open positions will result in lower personnel expenditures for FY 2011 c) Projected savings due to open positions will be offset by unplanned purchase of additional patrol vehicles d) Unfilled budgeted positions and less than planned jail bed rental. Forecast includes $146,000 for jail bed rental and $350,000 for JMS software e) Unfilled budgeted positions and lower material and service expenditures projected for FY 2011 Fund 701 LED -Countywide Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Bud et Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $4,722,862 $ 5,609,156 $ 886,294 100% 119% $ 4,722,862 $ 5,609,156 $ 886,294 Tax Revenues - Current 8,664,597 13,272,644 4,608,047 58% 89% 14,853,594 14,853,594 - Tax Revenues - Prior 374,500 573,543 199,043 58% 89% 642,000 727,000 85,000 Federal Grants 20,417 46,415 25,998 58% 133%a) 35,000 46,415 11,415 State Grant 28,277 37,037 8,760 58% 76% 48,475 48,475 Transp. of State Wards 2,917 (2,917) 58% 0% 5,000 5,000 SB 1145 1,151,885 1,480,995 329,110 58% 75%a) 1,974,660 1,854,660 (120,000) Des. Cty Video Lottery Grant 2,917 (2,917) 58% 0% 5,000 5,000 Des Cty Court Security 55,417 55,332 (85) 58% 58% 95,000 95,000 Des Cty Juvenile Contract 3,454 3,454 58% n/a 3,454 3,454 Title III Reimbursement 87,500 59,492 (28,008) 58% 40%a) 150,000 150,000 Transport 2,333 424 (1,909) 58% 11% 4,000 4,000 DC Fair & Expo Center 3,825 3,825 58% n/a - 3,825 3,825 Inmate Commissary Fees 28,000 33,069 5,069 58% 69% 48,000 48,000 Work Center Work Crews 14,583 38,670 24,087 58% 155% b) 25,000 50,000 25,000 Concealed Handgun Classes 3,500 2,175 (1,325) 58% 36% 6,000 6,000 Soc Sec Incentive -Fed 2,917 4,800 1,883 58% 96% 5,000 5,000 Miscellaneous 2,917 3,463 546 58% 69% 5,000 5,000 Oregon Mentors 9,520 9,520 58% n/a - 10,000 10,000 Medical Services Reimb 7,000 11,721 4,721 58% 98% 12,000 12,000 Restitution 583 3,333 2,750 58% 333% 1,000 5,000 4,000 Sheriff Fees 93,333 145,489 52,156 58% 91%c) 160,000 200,000 40,000 Interest 16,528 28,004 11,476 58% 99% 28,333 28,333 Interest on Unsegregated 2,061 1,353 (708) 58% 38% 3,533 3,533 Rentals 2,500 2,500 58% n/a 2,500 2,500 Donations 200 200 58% n/a 200 200 Sale of Reportable Assets 1,257 1,257 58% n/a - 1,257 1,257 Total Revenues 10,562,182 15,818,715 5,256,533 58% 87% 18,106,595 18,173,246 66,651 TOTAL RESOURCES 15,285,044 21,427,871 6,142,827 58% 94% 22,829,457 23,782,402 952,945 REQUIREMENTS: Department Sheriffs Services Civil Auto/Comm Adult Jail Court Security Emer Svcs Special Services Work Center Training Other (CODE, Forensic) Internal Services Transfer to Debt Service Transfer to Jail Remodel Transfer for Reserve Fund Contingency Exp. % 1,568,127 1,765,468 (197,341) 58% 66% 2,688,218 2,735,518 (47,300) 465,754 484,282 (18,528) 58% 61% 798,436 778,436 20,000 305,138 334,536 (29,399) 58% 64% 523,093 505,093 18,000 5,744,004 4,985,100 758,904 58% 51% 9,846,864 9,400,864 446,000 140,496 156,980 (16,484) 58% 65% 240,851 290,851 (50,000) 101,757 97,311 4,446 58% 56% 174,441 174,441 550,236 514,390 35,847 58% 55% 943,262 943,262 - 1,677,808 1,525,248 152,560 58% 53% 2,876,242 2,676,242 200,000 117,425 89,461 27,964 58% 44% 201,300 183,000 18,300 348,202 346,769 1,433 58% 58% 596,917 596,917 - 24,262 24,262 0 58% 58% 41,592 41,592 58,333 60,539 (2,205) 58% 61% 100,000 100,000 58,333 100,000 (41,667) 58% 100% 100,000 100,000 58,333 - 58,333 58% 0% 100,000 100,000 - 2,098,974 - 2,098,974 58% 0% 3,598,241 3,598,241 Total Requirements 13,317,183 10,484,347 2,832,836 Net 46% 22,829,457 18,626,216 4,203,241 1,967,861 10,943,524 8,975,664 5,156,186 5,156,186 a) Anticipated funding reduction from Dept. of Corrections b) Contract revenue from USFS is higher than anticipated c) Actual revenue for concealed weapons permits and civil papers will exceed budget d) Payment to Sheriffs Office adjusted to actual quarterly Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $4,722,862 $ 5,609,156 $ 886,294 100% 119% $ 4,722,862 $ 5,609,156 $ 886,294 Tax Revenues - Current 8,664,597 13,272,644 4,608,047 58% 89% 14,853,594 14,853,594 - Tax Revenues - Prior 374,500 573,543 199,043 58% 89% 642,000 727,000 85,000 Federal Grants 20,417 46,415 25,998 58% 133%a) 35,000 46,415 11,415 State Grant 28,277 37,037 8,760 58% 76% 48,475 48,475 Transp. of State Wards 2,917 (2,917) 58% 0% 5,000 5,000 SB 1145 1,151,885 1,480,995 329,110 58% 75%a) 1,974,660 1,854,660 (120,000) Des. Cty Video Lottery Grant 2,917 (2,917) 58% 0% 5,000 5,000 Des Cty Court Security 55,417 55,332 (85) 58% 58% 95,000 95,000 Des Cty Juvenile Contract 3,454 3,454 58% n/a 3,454 3,454 Title III Reimbursement 87,500 59,492 (28,008) 58% 40%a) 150,000 150,000 Transport 2,333 424 (1,909) 58% 11% 4,000 4,000 DC Fair & Expo Center 3,825 3,825 58% n/a - 3,825 3,825 Inmate Commissary Fees 28,000 33,069 5,069 58% 69% 48,000 48,000 Work Center Work Crews 14,583 38,670 24,087 58% 155% b) 25,000 50,000 25,000 Concealed Handgun Classes 3,500 2,175 (1,325) 58% 36% 6,000 6,000 Soc Sec Incentive -Fed 2,917 4,800 1,883 58% 96% 5,000 5,000 Miscellaneous 2,917 3,463 546 58% 69% 5,000 5,000 Oregon Mentors 9,520 9,520 58% n/a - 10,000 10,000 Medical Services Reimb 7,000 11,721 4,721 58% 98% 12,000 12,000 Restitution 583 3,333 2,750 58% 333% 1,000 5,000 4,000 Sheriff Fees 93,333 145,489 52,156 58% 91%c) 160,000 200,000 40,000 Interest 16,528 28,004 11,476 58% 99% 28,333 28,333 Interest on Unsegregated 2,061 1,353 (708) 58% 38% 3,533 3,533 Rentals 2,500 2,500 58% n/a 2,500 2,500 Donations 200 200 58% n/a 200 200 Sale of Reportable Assets 1,257 1,257 58% n/a - 1,257 1,257 Total Revenues 10,562,182 15,818,715 5,256,533 58% 87% 18,106,595 18,173,246 66,651 TOTAL RESOURCES 15,285,044 21,427,871 6,142,827 58% 94% 22,829,457 23,782,402 952,945 REQUIREMENTS: Department Sheriffs Services Civil Auto/Comm Adult Jail Court Security Emer Svcs Special Services Work Center Training Other (CODE, Forensic) Internal Services Transfer to Debt Service Transfer to Jail Remodel Transfer for Reserve Fund Contingency Exp. % 1,568,127 1,765,468 (197,341) 58% 66% 2,688,218 2,735,518 (47,300) 465,754 484,282 (18,528) 58% 61% 798,436 778,436 20,000 305,138 334,536 (29,399) 58% 64% 523,093 505,093 18,000 5,744,004 4,985,100 758,904 58% 51% 9,846,864 9,400,864 446,000 140,496 156,980 (16,484) 58% 65% 240,851 290,851 (50,000) 101,757 97,311 4,446 58% 56% 174,441 174,441 550,236 514,390 35,847 58% 55% 943,262 943,262 - 1,677,808 1,525,248 152,560 58% 53% 2,876,242 2,676,242 200,000 117,425 89,461 27,964 58% 44% 201,300 183,000 18,300 348,202 346,769 1,433 58% 58% 596,917 596,917 - 24,262 24,262 0 58% 58% 41,592 41,592 58,333 60,539 (2,205) 58% 61% 100,000 100,000 58,333 100,000 (41,667) 58% 100% 100,000 100,000 58,333 - 58,333 58% 0% 100,000 100,000 - 2,098,974 - 2,098,974 58% 0% 3,598,241 3,598,241 Total Requirements 13,317,183 10,484,347 2,832,836 Net 46% 22,829,457 18,626,216 4,203,241 1,967,861 10,943,524 8,975,664 5,156,186 5,156,186 a) Anticipated funding reduction from Dept. of Corrections b) Contract revenue from USFS is higher than anticipated c) Actual revenue for concealed weapons permits and civil papers will exceed budget d) Payment to Sheriffs Office adjusted to actual quarterly Fund 702 LED Rural Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $1,905,939 Revenues Tax Revenues - Current 4,379,810 Tax Revenues - Prior 183,167 Federal Grants 1,167 Federal Grants-BLM US Forest Service 44,625 State Grant 109,453 SB #1065 Court Assessmi 39,083 Marine Board License Fee 83,086 Des Cty General Fund Gr 409,709 Des Cty Transient Room 1 1,136,125 City of Sisters 252,382 Des Cty Tax/Fin Contract 583 Des Cty CDD Contract 31,714 Des Cty Solid Waste Cont 31,714 Des Cty Clerk/Election 1,167 School Districts 58,333 Claims Reimbursement Security & Traffic Reimb Seat Belt Program Miscellaneous Restitution Sheriff Fees Court Fines & Fees Impound Fees Restitution - Street Crime: Interest Interest on Unsegregated Donations Sale of Reportable Assets 5,833 Sale of Equip & Material 3,500 7,583 3,500 5,833 292 5,833 49,583 8,750 292 5,833 1,050 Total Revenues TOTAL RESOURCES REQUIREMENTS: Department Sheriffs Services Auto/Comm Investigations Patrol Records Special Services Training Internal Services Transfer for Reserve Fund Contingency $ 2,498,487 $ 592,548 100% 6,685,457 285,955 7,162 5,981 44,625 61,164 28,941 1,136,125 252,382 31,714 31,714 675 6,103 8,472 1,081 4,050 7,969 5,730 68,609 3,800 11,307 680 4,075 26,914 2,354 2,305,647 102,788 5,995 5,981 (48,289) (10,142) (83,086) (409,709) (583) (492) (52,230) 8,472 (6,502) 550 2,136 (292) (103) 19,026 (4,950) (292) 5,474 (370) 4,075 21,081 (1,146) 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 6,860,000 8,723,039 1,863,039 50% 8,765,939 11,221,526 2,455,587 50% 89,513 542,467 962,962 4,566,713 385,225 130,749 75,075 24,165 58,333 1,136, 595 100,777 (11,265) 594,731 (52,264) 876,157 86,805 4,486,782 79,931 352,330 32,895 122,231 8,518 57,197 17,878 24,165 58,333 1,136,595 Total Requirements 7,971,798 6,614,369 1,357,429 Net 794,141 4,607,158 3,813,016 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% a) Actual HIDTA overtime reimbursement higher than budgeted b) Payments are received in Feb & June c) Grant will be received in June 2011 d) Most of this revenue is received in Quarters 3 & 4 e) Revenue from traffic fines will exceed budget f) Proceeds from sale of used patrol vehicles were higher than estimated g) Payment to Sheriffs Office adjusted to actual quarterly 131% $ 1,905,939 $ 2,498,487 $ 592,548 89% 7,508,247 91% 314,000 358% a) 2,000 n/a 58% 76,500 33% 187,633 43% 67,000 0% b) 142,433 0% c) 702,358 58% 1,947,642 58% 432,655 0% 1,000 58% 54,366 58% 54,366 34% 2,000 6% d) 100,000 n/a 8% 13,000 68% 6,000 80% 10,000 0% 500 57% 10,000 81 % e) 85,000 25% 15,000 0% 500 113% 10,000 38% 1,800 n/a - 269% f) 10,000 39% 6,000 7,508,247 371,000 10,000 10,000 76,500 187,633 67,000 142,433 702,358 1,947,642 432,655 1,000 54,366 54,366 2,000 100,000 8,472 13,000 6,000 10,000 500 10,000 120,000 15,000 500 11,307 1,800 5,000 30,000 10,000 57,000 8,000 10,000 8,472 35,000 1,307 1,307 20,000 4,000 74% 11,760,000 11,908,779 148,779 82% 13,665,939 14,407,266 Exp. % 66% 64% 53% 57% 53% 55% 44% 58% 0% 0% 153,450 929,943 1,650,792 7,828,651 660,386 224,142 128,700 41,426 100,000 1,948,449 741,327 156,150 (2,700) 897,943 32,000 1,535, 792 115,000 7,805,651 23,000 660,386 224,142 117,000 11,700 41,426 - 100,000 - 1,948,449 48% 13,665,939 11,538,490 2,127,449 2,868,776 2,868,776 Year End Budget Projection Variance 131% $ 1,905,939 $ 2,498,487 $ 592,548 89% 7,508,247 91% 314,000 358% a) 2,000 n/a 58% 76,500 33% 187,633 43% 67,000 0% b) 142,433 0% c) 702,358 58% 1,947,642 58% 432,655 0% 1,000 58% 54,366 58% 54,366 34% 2,000 6% d) 100,000 n/a 8% 13,000 68% 6,000 80% 10,000 0% 500 57% 10,000 81 % e) 85,000 25% 15,000 0% 500 113% 10,000 38% 1,800 n/a - 269% f) 10,000 39% 6,000 7,508,247 371,000 10,000 10,000 76,500 187,633 67,000 142,433 702,358 1,947,642 432,655 1,000 54,366 54,366 2,000 100,000 8,472 13,000 6,000 10,000 500 10,000 120,000 15,000 500 11,307 1,800 5,000 30,000 10,000 57,000 8,000 10,000 8,472 35,000 1,307 1,307 20,000 4,000 74% 11,760,000 11,908,779 148,779 82% 13,665,939 14,407,266 Exp. % 66% 64% 53% 57% 53% 55% 44% 58% 0% 0% 153,450 929,943 1,650,792 7,828,651 660,386 224,142 128,700 41,426 100,000 1,948,449 741,327 156,150 (2,700) 897,943 32,000 1,535, 792 115,000 7,805,651 23,000 660,386 224,142 117,000 11,700 41,426 - 100,000 - 1,948,449 48% 13,665,939 11,538,490 2,127,449 2,868,776 2,868,776 PUBLIC HEALTH Statement of Financial Operating Data Seven Months Ended January 31, 2011 Revised Year to Date Budget Budget Actual Variance FY % Coll. % Revised Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,100,000 $ 1,615,306 $ 515,306 100% 147% $1,100,000 $1,615,306 $ 515,306 Revenues Medicare Reimbursement 4,667 92 (4,575) 58% 1% 8,000 200 (7,800) State Grant 1,465,903 1,515,680 49,777 58% 60% a) 2,512,977 2,613,704 100,727 Child Dev & Rehab Center 17,943 7,690 (10,253) 58% 25% 30,759 30,759 State Miscellaneous 128,273 119,366 (8,907) 58% 54% 219,896 219,896 OMAP 278,717 327,998 49,281 58% 69% 477,800 477,800 Family Planning Exp Proj 288,750 263,515 (25,235) 58% 53% 495,000 520,000 25,000 Grants 37,917 74,698 36,781 58% 115% b) 65,000 113,773 48,773 Water Program -Base Fee 24,500 18,772 (5,728) 58% 45% 42,000 42,000 Water Program -Field Work 32,560 33,250 690 58% 60% 55,817 55,817 H2O Sys Insp-Priv Wells 117 - (117) 58% 0% 200 200 Miscellaneous 38 38 58% n/a 201 201 Patient Insurance Fees 110,985 86,299 (24,686) 58% 45% c) 190,260 120,260 (70,000) Health Dept/Patient Fees 86,902 61,628 (25,274) 58% 41% c) 148,975 100,975 (48,000) Vital Records -Birth 21,000 17,850 (3,150) 58% 50% 36,000 30,000 (6,000) Vital Records -Death 57,167 58,325 1,158 58% 60% 98,000 96,000 (2,000) Environmental Health 400,954 621,871 220,917 58% 90% d) 687,350 687,350 Interest on Investments 9,858 6,628 (3,230) 58% 39% 16,900 12,758 (4,142) Donations 3,500 31,422 27,922 58% 524% e) 6,000 35,430 29,430 Interfund Contract 110,471 17,092 (93,379) 58% 9% 189,378 162,513 (26,865) Administrative Fee 15,750 15,750 58% 58% 27,000 27,000 - Drug Court Byrne 4,157 4,157 58% n/a 4,157 4,157 Total Revenues 3,095,934 3,282,121 186,187 58% 62% 5,307,312 5,350,793 43,481 Transfers In -General Fund Transfers In -PH Res Fund Transfers In -Gen. Fund Other TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 1,352,030 39,155 39,557 1,352,030 33,562 33,906 - 58% 58% 2,317,765 2,317,765 (5,593) 58% 50% 67,123 67,123 (5,651) 58% 50% 67,812 67,812 5,626,676 6,316,925 690,249 58% 71% Exp. % 8,860,012 9,418,799 558,787 3,465,556 3,299,770 165,786 58% 56% 5,940,953 5,727,405 213,548 1,169,809 1,164,188 5,621 58% 58% 2,005,387 1,945,070 60,317 14,583 5,432 9,151 58% 22% 25,000 25,000 87,500 75,000 12,500 58% 50% 150,000 150,000 430,892 - 430,892 58% n/a 738,672 - 738,672 5,168,340 4,544,390 623,950 58% 51% 8,860,012 7,847,475 1,012,537 458,336 1,772,535 1,314,199 - 1,571,324 1,571,324 a) State grant through Revision #4, supplemental grant appropriation to be submitted b) Health Matters -local grant for Chronic Care Program is $17,000 & $21,000. Bioterrorism NACCHO grant $10,000 received in July c) Projection reflects fewer patients covered under private insurance and self pay reflects current economics d) Environmental Health fees are primarily due and collected in January e) My Future My Choice donation carry over from FY10, in the amount of $25,880. $3550 HIV sponsorship donation RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses BEHAVIORAL HEALTH Statement of Financial Operating Data Seven Months Ended January 31, 2011 $ 2,616,050 $ 2,651,262 $ 35,212 100% 101% 3,208 Divorce Filing Fees 75,833 Domestic Partnership Fee 583 Federal Grants 56,565 State Grants 3,478,610 State Miscellaneous 86,434 ABHA Title 19 Liquor Revenue School Districts Miscellaneous Patient Insurance Fees Patient Fees Interest on Investments Rentals Interfund Contract -Gen. Fund Comm. on Children & Fam Administrative Fee Total Revenues Transfers In -General Fund Transfers In-OHP-CDO Transfers In -Acute Care Svcs Transfers In-ABHA 175,540 61,483 40,833 9,858 89,833 7,583 25,425 7,642 74,083 14,000 2,456,683 6,664,196 767,759 58,333 213,300 389,814 3,190 78,715 30 20,660 3,511,279 56,921 16,546 73,851 64,324 34,240 27,323 38,363 1,187 13,862 10,375 39,771 2,432,440 6,423,077 767,759 58,333 213,300 334,126 (18) 2,882 (553) (35,905) 32,669 (29,513) 16,546 (101,689) 2,841 (6,593) 17,465 (51,470) (6,396) (11,563) 2,733 (34,312) (14,000) (24,243) (241,119) (55,688) TOTAL RESOURCES 10,709,452 REQUIREMENTS: Expenditures Personal Services 5,382,102 Materials and Services 2,725,550 Capital Outlay 446,833 Transfers Out 91,679 Contingency 973,270 10,447,857 (261,595) 5,134, 704 1,991,066 21,746 75,000 247,398 734,484 425,087 16,679 973,270 TOTAL REQUIREMENTS 9,619,434 7,222,516 2,396,918 NET (Resources - Requirements) 1,090,018 3,225,341 2,135,323 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 61% 3% 21% a) 59% b) 38% n/a 25% 61% 49% 162% 25% 9% 32% 79% 31% 0% 58% Revised Year to Date Budget Actual Variance FY %, Coll. % $ 2,616,050 $ 2,651,262 $ 35,212 100% 101% 3,208 Divorce Filing Fees 75,833 Domestic Partnership Fee 583 Federal Grants 56,565 State Grants 3,478,610 State Miscellaneous 86,434 ABHA Title 19 Liquor Revenue School Districts Miscellaneous Patient Insurance Fees Patient Fees Interest on Investments Rentals Interfund Contract -Gen. Fund Comm. on Children & Fam Administrative Fee Total Revenues Transfers In -General Fund Transfers In-OHP-CDO Transfers In -Acute Care Svcs Transfers In-ABHA 175,540 61,483 40,833 9,858 89,833 7,583 25,425 7,642 74,083 14,000 2,456,683 6,664,196 767,759 58,333 213,300 389,814 3,190 78,715 30 20,660 3,511,279 56,921 16,546 73,851 64,324 34,240 27,323 38,363 1,187 13,862 10,375 39,771 2,432,440 6,423,077 767,759 58,333 213,300 334,126 (18) 2,882 (553) (35,905) 32,669 (29,513) 16,546 (101,689) 2,841 (6,593) 17,465 (51,470) (6,396) (11,563) 2,733 (34,312) (14,000) (24,243) (241,119) (55,688) TOTAL RESOURCES 10,709,452 REQUIREMENTS: Expenditures Personal Services 5,382,102 Materials and Services 2,725,550 Capital Outlay 446,833 Transfers Out 91,679 Contingency 973,270 10,447,857 (261,595) 5,134, 704 1,991,066 21,746 75,000 247,398 734,484 425,087 16,679 973,270 TOTAL REQUIREMENTS 9,619,434 7,222,516 2,396,918 NET (Resources - Requirements) 1,090,018 3,225,341 2,135,323 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 61% 3% 21% a) 59% b) 38% n/a 25% 61% 49% 162% 25% 9% 32% 79% 31% 0% 58% Revised Year End Budget Projection Variance $ 2,616,050 $ 2,651,262 $ 35,212 5,500 130,000 1,000 96,969 5,963,332 148,173 300,925 105,400 70,000 16,900 154,000 13,000 43,585 13,100 a) 127,000 c) 24,000 4,211,457 4,211,457 58% 56% 11,424,341 11,040,207 (384,134) 5,500 130,000 250 (750) 96,969 5,775,358 (187,974) 148,173 - 20,000 20,000 200,000 (100,925) 105,400 70,000 34,000 17,100 75,000 (79,000) 3,000 (10,000) 25,000 (18,585) 13,100 127,000 (24,000) 58% 58% 1,316,158 58% 58% 100,000 58% 58% 365,657 58% 50% 668,252 1,316,158 100,000 365,657 668,252 58% 63% 16,490,458 16,141,536 (348,922) Exp. % 58% 56% d) 9,226,461 8,850,000 376,461 58% 43% 4,672,371 3,600,000 1,072,371 58% 3% 766,000 450,000 316,000 58% 48% 157,164 157,164 58% n/a 1,668,462 1,668,462 58% 44% 16,490,458 13,057,164 3,433,294 a) Grant billing received quarterly, in arrears b) Department of Human Services Grant projected at amended contract amount for FY 11 c) Child and Family prevention program eliminated d) Personnel expenditure projected to be Tess than budgeted due to unfilled positions - 3,084,372 3,084,372 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Budget Actual Variance FY °A) Coll. °A, RESOURCES: Beg. Net Working Capital $ 686,081 Revenues Admin -Operations 9,625 Admin -GIS 1,604 Admin -Code Enforcement 94,336 Building Safety 630,710 Electrical 155,547 Contract Services 107,333 Env Health -On Site Prog 165,568 Planning -Current 453,228 Planning -Long Range 206,366 613,031 $ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050) 10,029 4,134 88,480 489,526 143,262 124,076 154,751 372,476 141,652 404 2,530 (5,856) (141,184) (12,285) 16,743 (10,817) (80,752) (64,714) Total Revenues 1,824,317 Trans In -GF Trans In -GF for Lng Rng Ping TOTAL RESOURCES 58% 58% 58% 58% 58% 58% 58% 58% 58% 61% 150% a) 55% 45% b) 54% 67% c) 55% 48% d) 40% e) 16,500 2,750 161,718 1,081,217 266,652 184,000 283,830 776,962 353,771 15,000 6,400 164,800 1,039,100 251,800 189,800 268,400 680,200 328,600 (1,500) 3,650 3,082 (42,117) (14,852) 5,800 (15,430) (96,762) (25,171) 1,528,386 (295,931) 58% 49% 3,127,400 2,944,100 (183,300) 147,809 147,809 301,000 301,000 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Pgm Planning -Current Planning -Long Range Transfers Out (D/S Fund) Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Revenues Expenditures Net from Operations 2,959,207 2,590,226 818,064 126,079 107,760 291,859 109,437 142,480 135,337 402,669 287,249 101,098 151,308 809,221 112,789 106,999 297,919 103,112 140,894 145,018 359,505 321,714 145,000 - 58% - 58% (368,981) 58% 8,843 13,290 761 (6,060) 6,325 1,586 (9,681) 43,164 (34,465) (43,902) 151,308 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 253,387 253,387 58% 516,000 516,000 57% 4,582,868 4,326,518 (256,350) Exp. °A) 58% 52% 58% 60% 55% 58% 63% h) 52% 65% i) 84% n/a f) g) 1,402,396 216,135 184,732 500,330 187,606 244,251 232,006 690,290 492,427 173,310 259,385 1,402,396 168,000 184,732 475,200 25,130 187,606 244,251 220,000 12,006 690,290 492,427 173,310 48,135 259,385 2,673,340 2,542,172 131,168 58% 55% 4,582,868 4,238,212 344,656 285,867 48,054 (237,813) 88,306 88,306 1,528,386 2,542,172 (1,013,786) 3,127,400 2,944,100 (183,300) 4,582,868 4,238,212 344,656 (1,455,468) (1,294,112) 161,356 a) Custom GIS work revenue sporadic b) YTD revenue is low in relation to budget, it is expected that budget projections will be met, as several large projects are expected to generate significant revenue later in the fiscal year ($200,000 Sunriver Aquatic Ctr, $50,000 La Pine biomass plant) c) City of Redmond receipts lag one month behind. YTD is high due to new high school fee revenue d) YTD business volume/revenue less than expected e) Grant payments received irregularly f) Savings due to resignation of CDD webmaster, who will not be replaced g) Savings due to retirement of Building Inspector in January. Decision on replacement will be made at a later date h) Includes $35,651 in time management payout to retired employee, to be made up by salary savings as position will remain unfilled i) Approximately $51,000 in consultant expense was paid in a lump sum and will be reimbursed through grant revenue Year End Budget Projection Variance 613,031 $ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050) 10,029 4,134 88,480 489,526 143,262 124,076 154,751 372,476 141,652 404 2,530 (5,856) (141,184) (12,285) 16,743 (10,817) (80,752) (64,714) Total Revenues 1,824,317 Trans In -GF Trans In -GF for Lng Rng Ping TOTAL RESOURCES 58% 58% 58% 58% 58% 58% 58% 58% 58% 61% 150% a) 55% 45% b) 54% 67% c) 55% 48% d) 40% e) 16,500 2,750 161,718 1,081,217 266,652 184,000 283,830 776,962 353,771 15,000 6,400 164,800 1,039,100 251,800 189,800 268,400 680,200 328,600 (1,500) 3,650 3,082 (42,117) (14,852) 5,800 (15,430) (96,762) (25,171) 1,528,386 (295,931) 58% 49% 3,127,400 2,944,100 (183,300) 147,809 147,809 301,000 301,000 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Pgm Planning -Current Planning -Long Range Transfers Out (D/S Fund) Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Revenues Expenditures Net from Operations 2,959,207 2,590,226 818,064 126,079 107,760 291,859 109,437 142,480 135,337 402,669 287,249 101,098 151,308 809,221 112,789 106,999 297,919 103,112 140,894 145,018 359,505 321,714 145,000 - 58% - 58% (368,981) 58% 8,843 13,290 761 (6,060) 6,325 1,586 (9,681) 43,164 (34,465) (43,902) 151,308 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 253,387 253,387 58% 516,000 516,000 57% 4,582,868 4,326,518 (256,350) Exp. °A) 58% 52% 58% 60% 55% 58% 63% h) 52% 65% i) 84% n/a f) g) 1,402,396 216,135 184,732 500,330 187,606 244,251 232,006 690,290 492,427 173,310 259,385 1,402,396 168,000 184,732 475,200 25,130 187,606 244,251 220,000 12,006 690,290 492,427 173,310 48,135 259,385 2,673,340 2,542,172 131,168 58% 55% 4,582,868 4,238,212 344,656 285,867 48,054 (237,813) 88,306 88,306 1,528,386 2,542,172 (1,013,786) 3,127,400 2,944,100 (183,300) 4,582,868 4,238,212 344,656 (1,455,468) (1,294,112) 161,356 a) Custom GIS work revenue sporadic b) YTD revenue is low in relation to budget, it is expected that budget projections will be met, as several large projects are expected to generate significant revenue later in the fiscal year ($200,000 Sunriver Aquatic Ctr, $50,000 La Pine biomass plant) c) City of Redmond receipts lag one month behind. YTD is high due to new high school fee revenue d) YTD business volume/revenue less than expected e) Grant payments received irregularly f) Savings due to resignation of CDD webmaster, who will not be replaced g) Savings due to retirement of Building Inspector in January. Decision on replacement will be made at a later date h) Includes $35,651 in time management payout to retired employee, to be made up by salary savings as position will remain unfilled i) Approximately $51,000 in consultant expense was paid in a lump sum and will be reimbursed through grant revenue ROAD Statement of Financial Operating Data Seven Months Ended January 31, 2011 Budget Year to Date Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 3,430,429 $ 3,419,603 $ (10,826) 100% 100% $ 3,430,429 $ 3,419,603 $ (10,826) Revenues Mineral Lease Royalties 11,667 24,653 12,986 58% 123% 20,000 40,000 20,000 Forest Receipts 1,304,917 2,237,091 932,174 58% 100% a) 2,237,000 2,237,091 91 State Miscellaneous 56,574 (56,574) 58% 0% b) 96,984 (96,984) Motor Vehicle Revenue 5,833,333 4,991,218 (842,115) 58% 50% c) 10,000,000 9,400,000 (600,000) City of Bend 160,417 215,049 54,632 58% 78% d) 275,000 275,000 City of Redmond 204,167 250,458 46,291 58% 72% d) 350,000 350,000 City of Sisters 5,833 - (5,833) 58% 0% d) 10,000 10,000 City of La Pine 5,833 - (5,833) 58% 0% d) 10,000 10,000 - Admin Recovery(SDC) - 931 931 58% n/a - 1,000 1,000 Miscellaneous 52,500 18,786 (33,714) 58% 21% 90,000 90,000 Road Vacations 583 500 (83) 58% 50% 1,000 500 (500) Interest on Investments 23,333 12,442 (10,891) 58% 31% 40,000 20,000 (20,000) Other Bank/LGIP Interest - 61 61 58% n/a 62 62 Parking Fees 525 - (525) 58% 0% 900 900 - Grants -Private - 2,434 2,434 58% n/a 2,434 2,434 Interfund Contract 437,500 234 (437,266) 58% 0% e) 750,000 750,000 Equipment Repairs 145,833 107,956 (37,877) 58% 43% 250,000 190,000 (60,000) Vehicle Repairs 52,500 (52,500) 58% 0% 90,000 90,000 LID Construction 5,833 (5,833) 58% 0% e) 10,000 (10,000) Vegetation Management 20,417 (20,417) 58% 0% e) 35,000 35,000 Forester 14,583 - (14,583) 58% 0% e) 25,000 25,000 - Car Washes 1,750 2,282 532 58% 76% 3,000 3,500 500 Car Rental 292 (292) 58% 0% 500 (500) Sale of Equip & Material 352,042 257,391 (94,651) 58% 43% 603,500 639,850 36,350 Total Revenues 8,690,432 8,121,486 (568,946) 58% 55% 14,897,884 14,170,337 (727,547) Trans In - Solid Waste 170,182 145,870 (24,312) 58% 50% 291,740 291,740 Trans In - Transp SDC 116,667 100,000 (16,667) 58% 50% 200,000 200,000 Trans In -Road Imp Res 7,023 - (7,023) 58% 0% 12,040 12,040 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 12,414,733 11,786,959 (611,107) 58% 66% 18,832,093 18,093,720 (738,373) Exp. % 3,355,897 3,158,412 197,485 58% 55% 5,752,967 5,611,278 141,689 5,524,763 4,806,134 718,629 58% 51% 9,471,023 9,074,689 396,334 683,486 16,362 667,124 58% 1% f) 1,171,691 95,000 1,076,691 233,333 233,333 58% 0% 400,000 400,000 1,187,907 1,187,907 58% n/a 2,036,412 - 2,036,412 TOTAL REQUIREMENTS 10,985,386 7,980,908 3,004,478 58% 42% 18,832,093 15,180,967 3,651,126 NET (Resources - Requirements) 1,429,347 3,806,051 2,393,371 2,912,753 2,912,753 a) Annual payment -January 2011 b) Received in June 2010 c) Gas tax will increase by 25% ($.06/gal.) effective January 2011 (revised State estimate) d) Billed upon completion of work e) Payment to be received in June 2011 from Funds 326, 328, 329, & 340 f) $1,076,691 19th Street construction reserve Year End Budget _ Projection Variance RESOURCES: Beg. Net Working Capital $ 3,430,429 $ 3,419,603 $ (10,826) 100% 100% $ 3,430,429 $ 3,419,603 $ (10,826) Revenues Mineral Lease Royalties 11,667 24,653 12,986 58% 123% 20,000 40,000 20,000 Forest Receipts 1,304,917 2,237,091 932,174 58% 100% a) 2,237,000 2,237,091 91 State Miscellaneous 56,574 (56,574) 58% 0% b) 96,984 (96,984) Motor Vehicle Revenue 5,833,333 4,991,218 (842,115) 58% 50% c) 10,000,000 9,400,000 (600,000) City of Bend 160,417 215,049 54,632 58% 78% d) 275,000 275,000 City of Redmond 204,167 250,458 46,291 58% 72% d) 350,000 350,000 City of Sisters 5,833 - (5,833) 58% 0% d) 10,000 10,000 City of La Pine 5,833 - (5,833) 58% 0% d) 10,000 10,000 - Admin Recovery(SDC) - 931 931 58% n/a - 1,000 1,000 Miscellaneous 52,500 18,786 (33,714) 58% 21% 90,000 90,000 Road Vacations 583 500 (83) 58% 50% 1,000 500 (500) Interest on Investments 23,333 12,442 (10,891) 58% 31% 40,000 20,000 (20,000) Other Bank/LGIP Interest - 61 61 58% n/a 62 62 Parking Fees 525 - (525) 58% 0% 900 900 - Grants -Private - 2,434 2,434 58% n/a 2,434 2,434 Interfund Contract 437,500 234 (437,266) 58% 0% e) 750,000 750,000 Equipment Repairs 145,833 107,956 (37,877) 58% 43% 250,000 190,000 (60,000) Vehicle Repairs 52,500 (52,500) 58% 0% 90,000 90,000 LID Construction 5,833 (5,833) 58% 0% e) 10,000 (10,000) Vegetation Management 20,417 (20,417) 58% 0% e) 35,000 35,000 Forester 14,583 - (14,583) 58% 0% e) 25,000 25,000 - Car Washes 1,750 2,282 532 58% 76% 3,000 3,500 500 Car Rental 292 (292) 58% 0% 500 (500) Sale of Equip & Material 352,042 257,391 (94,651) 58% 43% 603,500 639,850 36,350 Total Revenues 8,690,432 8,121,486 (568,946) 58% 55% 14,897,884 14,170,337 (727,547) Trans In - Solid Waste 170,182 145,870 (24,312) 58% 50% 291,740 291,740 Trans In - Transp SDC 116,667 100,000 (16,667) 58% 50% 200,000 200,000 Trans In -Road Imp Res 7,023 - (7,023) 58% 0% 12,040 12,040 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 12,414,733 11,786,959 (611,107) 58% 66% 18,832,093 18,093,720 (738,373) Exp. % 3,355,897 3,158,412 197,485 58% 55% 5,752,967 5,611,278 141,689 5,524,763 4,806,134 718,629 58% 51% 9,471,023 9,074,689 396,334 683,486 16,362 667,124 58% 1% f) 1,171,691 95,000 1,076,691 233,333 233,333 58% 0% 400,000 400,000 1,187,907 1,187,907 58% n/a 2,036,412 - 2,036,412 TOTAL REQUIREMENTS 10,985,386 7,980,908 3,004,478 58% 42% 18,832,093 15,180,967 3,651,126 NET (Resources - Requirements) 1,429,347 3,806,051 2,393,371 2,912,753 2,912,753 a) Annual payment -January 2011 b) Received in June 2010 c) Gas tax will increase by 25% ($.06/gal.) effective January 2011 (revised State estimate) d) Billed upon completion of work e) Payment to be received in June 2011 from Funds 326, 328, 329, & 340 f) $1,076,691 19th Street construction reserve RESOURCES: Beg. Net Working Capital Revenues ADULT PAROLE & PROBATION Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Budget Actual Variance FY% Coll. Revised Budget Year End Projection Variance $ 616,371 $ 728,649 $ 112,278 100% 118% $ 616,371 $ 728,649 $ 112,278 DOC Measure 57 126,761 217,350 90,589 58% 100% a) 217,305 217,350 45 State Miscellaneous 2,509 (2,509) 58% 0% b) 4,301 4,301 Alternate Incarceration 18,036 30,918 12,882 58% 100% a) 30,918 30,918 State Subsidy 7,583 9,980 2,397 58% 77% 13,000 13,000 SB 1145 1,727,828 2,221,492 493,664 58% 75% c) 2,961,990 2,781,990 (180,000) Probation Work Crew Fees 22,167 13,425 (8,742) 58% 35% d) 38,000 20,613 (17,387) Miscellaneous 1,750 2,630 880 58% 88% e) 3,000 3,000 Electronic Monitoring Fee 99,167 95,611 (3,556) 58% 56% 170,000 160,000 (10,000) Probation Superv. Fees 122,500 113,897 (8,603) 58% 54% 210,000 192,000 (18,000) Interest on Investments 5,250 5,576 326 58% 62% 9,000 9,000 Interfund - Sheriff 29,167 29,167 - 58% 58% 50,000 50,000 Crime Prevention Grant 29,167 12,500 (16,667) 58% 25% f) 50,000 50,000 CFC -Domestic Violence 18,708 18,708 58% n/a g) 56,124 56,124 Total Revenues 2,191,885 2,771,254 579,369 58% 74% 3,757,514 3,588,296 (169,218) Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 67,100 67,100 - 58% 58% 115,029 115,029 2,875,356 3,567,003 691,647 58% 79% 4,488,914 4,431,974 (56,940) Exp. % 1,851,067 1,723,591 127,476 58% 54% h) 3,173,257 2,966,580 206,677 521,660 450,680 70,980 58% 50% 894,274 894,274 58 58 58% 0% 100 100 245,748 245,748 58% n/a 421,283 421,283 TOTAL REQUIREMENTS 2,618,533 2,174,271 444,262 58% 48% 4,488,914 3,860,854 628,060 NET (Resources - Requirements) 256,823 1,392,732 1,135,909 571,120 571,120 a) Annual payment received in July b) Payment from Parole Board for hearings not yet received c) Anticipated funding cuts from Dept. of Corrections. Money above opt out d) Increase in fee waivers from court due to economic conditions e) Increase in the number of offenders transferring out of County f) Quarterly payment not yet received g) Intensive Supervision DV grant (Federal grant) h) Personnel expenditure projected to be less than budgeted due to unfilled positions COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date , Budget Actual Variance FY % Coll. % Revised Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 562,762 $ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578 Revenues Federal Grants 233,431 225,922 (7,509) 58% 56% 400,167 400,167 Title IV - Family Sup/Pres 37,188 37,556 368 58% 59% 63,750 63,750 HealthyStart Medicaid 55,417 26,212 (29,205) 58% 28% 95,000 95,000 Level 7 Services 150,491 112,094 (38,397) 58% 43% 257,984 257,984 State Prevention Funds 8,458 6,696 (1,762) 58% 46% a) 14,500 17,000 2,500 HealthyStart /R -S -G 180,206 134,805 (45,401) 58% 44% b) 308,924 263,596 (45,328) OCCF Grant 352,522 290,050 (62,472) 58% 48% b) 604,323 549,044 (55,279) Charges for Svcs-Misc 4,667 1,907 (2,760) 58% 24% 8,000 8,000 Court Fines & Fees 43,750 47,229 3,479 58% 63% 75,000 78,000 3,000 Interest on Investments 11,667 3,367 (8,300) 58% 17% c) 20,000 8,000 (12,000) Grants -Private 2,917 (2,917) 58% 0% d) 5,000 (5,000) Donations 157 157 58% n/a 157 157 Miscellaneous 150,823 59,517 (91,306) 58% 23% e) 258,554 118,500 (140,0544 Total Revenues 1,231,537 945,512 (286,025) 58% 45% 2,111,202 1,859,198 (252,004) Trans from General Fund 165,861 165,861 - 58% 58% 284,333 284,333 Trans from GF -Other 14,583 12,500 (2,083) 58% 50% 25,000 25,000 Total Transfers In 180,444 178,361 (2,083) 58% 58% 309,333 309,333 in TOTAL RESOURCES 1,974,743 1,759,213 (215,530) 58% 59% 2,983,297 2,803,871 (179,426) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 349,743 315,801 33,942 58% 53% f) 599,559 525,226 74,333 1,152,132 913,322 238,810 58% 46% b) 1,975,084 1,799,758 175,326 58 58 58% 0% 100 100 238,323 238,323 58% n/a 408,554 408,554 TOTAL REQUIREMENTS 1,740,256 1,229,123 511,133 58% 41% 2,983,297 2,324,984 658,313 NET (Resources - Requirements) 234,487 530,090 295,603 478,887 478,887 a) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $14,500 grant received b) Governor's mandated State General Fund reductions in July & Sept 2010. Additional $19,900 grant received c) Interest revenue projected to be less than budgeted d) Youth conference donations will not be received e) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received f) Personnel costs will be fess than budgeted due to open positions SOLID WASTE Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 392,509 $ 318,001 $ (74,508) 100% 81% $ 392,509 $ 318,001 $ (74,508) Revenues Miscellaneous 16,333 13,257 (3,076) 58% 47% 28,000 22,000 (6,000) Franchise 3% Fees 116,667 18,875 (97,792) 58% 9% a) 200,000 200,000 Commercial Disp. Fees 490,000 518,009 28,009 58% 62% 840,000 860,000 20,000 Private Disposal Fees 766,500 787,306 20,806 58% 60% 1,314,000 1,324,000 10,000 Franchise Disposal Fees 2,134,417 2,378,260 243,843 58% 65% 3,659,000 4,000,000 341,000 Yard Debris 42,583 49,290 6,707 58% 68% b) 73,000 73,000 Special Waste 14,583 41,177 26,594 58% 165% c) 25,000 50,000 25,000 Interest 7,292 4,867 (2,425) 58% 39% 12,500 7,500 (5,000) Leases 1 1 58% n/a 1 1 Sale of Carbon Credits 46,667 (46,667) 58% 0% d) 80,000 (80,000) Sale of Equip & Material 100 100 58% n/a e) 100 100 Recyclables 11,667 27,871 16,204 58% 139% f) 20,000 38,000 18,000 Total Revenues 3,646,709 3,839,013 192,304 58% 61% 6,251,500 6,574,601 323,101 TOTAL RESOURCES 4,039,218 4,157,014 117,796 58% 63% 6,644,009 6,892,602 248,593 REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out -Road Contingency Exp. % 933,402 944,602 (11,200) 58% 59% g) 1,600,118 1,628,950 (28,832) 1,671,734 1,423,821 247,913 58% 50% h) 2,865,829 2,776,000 89,829 565,872 401,732 164,140 58% 41% 970,066 970,066 68,833 48,061 20,772 58% 41% i) 118,000 118,000 170,182 145,870 24,312 58% 50% 291,740 291,740 465,649 465,649 58% n/a 798,256 798,256 TOTAL REQUIREMENTS 3,875,672 2,964,086 911,586 58% 45% 6,644,009 5,784,756 859,253 NET (Resources - Requirements) 163,546 1,192,928 1,029,382 1,107,846 1,107,846 a) Franchise fees are received in April. Wilderness Garbage pays monthly b) Seasonal material - revenue will decrease in winter c) Bonneville Power did large clean-up of contaminated soil -unexpected revenue d) No market at this time. Not expected to market this fiscal year e) Minor revenue for sale of gate remotes f) Markets for recyclables varies throughout the year - usually declines in the winter g) Due to layoffs, more overtime incurred than expected. Appropriation transfer from contingency will be made prior to fiscal year end h) Larger expenditures (i.e. grinding at $75,000) made in spring i) One item remaining -software being researched Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 392,509 $ 318,001 $ (74,508) 100% 81% $ 392,509 $ 318,001 $ (74,508) Revenues Miscellaneous 16,333 13,257 (3,076) 58% 47% 28,000 22,000 (6,000) Franchise 3% Fees 116,667 18,875 (97,792) 58% 9% a) 200,000 200,000 Commercial Disp. Fees 490,000 518,009 28,009 58% 62% 840,000 860,000 20,000 Private Disposal Fees 766,500 787,306 20,806 58% 60% 1,314,000 1,324,000 10,000 Franchise Disposal Fees 2,134,417 2,378,260 243,843 58% 65% 3,659,000 4,000,000 341,000 Yard Debris 42,583 49,290 6,707 58% 68% b) 73,000 73,000 Special Waste 14,583 41,177 26,594 58% 165% c) 25,000 50,000 25,000 Interest 7,292 4,867 (2,425) 58% 39% 12,500 7,500 (5,000) Leases 1 1 58% n/a 1 1 Sale of Carbon Credits 46,667 (46,667) 58% 0% d) 80,000 (80,000) Sale of Equip & Material 100 100 58% n/a e) 100 100 Recyclables 11,667 27,871 16,204 58% 139% f) 20,000 38,000 18,000 Total Revenues 3,646,709 3,839,013 192,304 58% 61% 6,251,500 6,574,601 323,101 TOTAL RESOURCES 4,039,218 4,157,014 117,796 58% 63% 6,644,009 6,892,602 248,593 REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out -Road Contingency Exp. % 933,402 944,602 (11,200) 58% 59% g) 1,600,118 1,628,950 (28,832) 1,671,734 1,423,821 247,913 58% 50% h) 2,865,829 2,776,000 89,829 565,872 401,732 164,140 58% 41% 970,066 970,066 68,833 48,061 20,772 58% 41% i) 118,000 118,000 170,182 145,870 24,312 58% 50% 291,740 291,740 465,649 465,649 58% n/a 798,256 798,256 TOTAL REQUIREMENTS 3,875,672 2,964,086 911,586 58% 45% 6,644,009 5,784,756 859,253 NET (Resources - Requirements) 163,546 1,192,928 1,029,382 1,107,846 1,107,846 a) Franchise fees are received in April. Wilderness Garbage pays monthly b) Seasonal material - revenue will decrease in winter c) Bonneville Power did large clean-up of contaminated soil -unexpected revenue d) No market at this time. Not expected to market this fiscal year e) Minor revenue for sale of gate remotes f) Markets for recyclables varies throughout the year - usually declines in the winter g) Due to layoffs, more overtime incurred than expected. Appropriation transfer from contingency will be made prior to fiscal year end h) Larger expenditures (i.e. grinding at $75,000) made in spring i) One item remaining -software being researched RESOURCES: Beginning Net Working Capital Revenues Inter -fund Charges: RISK MANAGEMENT Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Budget Actual Variance % of FY % Coll. $2,500,000 $2,374,541 ($125,460) 100% 95% $2,500,000 $2,374,541 ($125,460) General Liability 195,902 195,902 0 58% 58% 335,833 335,833 Property Damage 171,511 171,511 (0) 58% 58% 294,019 294,019 Vehicle 106,581 106,581 0 58% 58% 182,710 182,710 Workers' Compensation 528,711 525,297 (3,414) 58% 58% 906,361 906,361 Unemployment 99,422 99,186 (236) 58% 58% 170,437 170,437 Claims Reimb-Workers' Compensation 17,500 (17,500) 58% 0% 30,000 30,000 - Claims Reimb-Gen Liab/Property 11,667 24,472 12,805 58% 122% 20,000 30,000 10,000 Process Fee-Events/Parades 875 770 (105) 58% 51% 1,500 1,500 - Miscellaneous 1,167 (1,167) 58% 0% 2,000 2,000 Skid Car Training 12,833 12,390 (443) 58% 56% 22,000 22,000 Interest on Investments 17,500 10,259 (7,241) 58% 34% 30,000 30,000 - TOTAL REVENUES 1,163,668 1,146,368 (17,300) 58% 57% 1,994,860 2,004,860 10,000 TOTAL RESOURCES 3,663,668 3,520,909 (142,759) Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Repair / Replacement Total General Liability PROPERTY DAMAGE Insurance 153,414 Repair / Replacement 11,027 46,633 2,775 6,435 133,418 366 250 58% 78% 4,494,860 4,379,401 (115,460) % Exp. 233,333 189,877 43,456 58% 47% 400,000 360,000 40,000 Total Property Damage 175,000 164,441 10,559 58% 55% 300,000 270,000 30,000 VEHICLE Professional Service 1,739 Insurance 390 Loss Prevention 10,464 Repair / Replacement 40,268 Total Vehicle 70,000 52,861 17,139 58% 44% 120,000 100,000 20,000 WORKERS' COMPENSATION Settlement / Benefit 393,082 Professional Service 6,250 Insurance 71,441 Loss Prevention 27,641 Miscellaneous 21,987 Total Workers' Compensation 379,167 520,401 (141,235) 58% 80% 650.000 780,000 (130,000) UNEMPLOYMENT - Settlement/Benefits 93,333 98,778 (5,444) 58% 62% 160,000 320,000 (160,000) Total Direct Insurance Costs 950,833 1,026,358 (75,525) 58% 63% 1,630,000 1,830,000 (200,000) Insurance Administration: Personal Services 168,848 166,790 2,058 58% 58% 289,453 289,453 Materials 8, Service 133,487 96,239 37,248 58% 42% 228,834 228,834 - Capital Outlay 58 - 58 58% 0% 100 100 Total Insurance Administration 302,392 263,029 39,364 58% 51% 518,387 518,287 100 Contingency 1,368,776 1,368,776 58% n/a 2,346,473 2,346,473 TOTAL REQUIREMENTS 2,622,002 1,289,387 1,332,615 58% 29% 4,494,860 2,348,287 2,146,573 NET 1,041,666 2,231,522 1,189,855 - 2,031,114 2,031,114 Year End Budget Projection Variance 95% $2,500,000 $2,374,541 ($125,460) General Liability 195,902 195,902 0 58% 58% 335,833 335,833 Property Damage 171,511 171,511 (0) 58% 58% 294,019 294,019 Vehicle 106,581 106,581 0 58% 58% 182,710 182,710 Workers' Compensation 528,711 525,297 (3,414) 58% 58% 906,361 906,361 Unemployment 99,422 99,186 (236) 58% 58% 170,437 170,437 Claims Reimb-Workers' Compensation 17,500 (17,500) 58% 0% 30,000 30,000 - Claims Reimb-Gen Liab/Property 11,667 24,472 12,805 58% 122% 20,000 30,000 10,000 Process Fee-Events/Parades 875 770 (105) 58% 51% 1,500 1,500 - Miscellaneous 1,167 (1,167) 58% 0% 2,000 2,000 Skid Car Training 12,833 12,390 (443) 58% 56% 22,000 22,000 Interest on Investments 17,500 10,259 (7,241) 58% 34% 30,000 30,000 - TOTAL REVENUES 1,163,668 1,146,368 (17,300) 58% 57% 1,994,860 2,004,860 10,000 TOTAL RESOURCES 3,663,668 3,520,909 (142,759) Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Repair / Replacement Total General Liability PROPERTY DAMAGE Insurance 153,414 Repair / Replacement 11,027 46,633 2,775 6,435 133,418 366 250 58% 78% 4,494,860 4,379,401 (115,460) % Exp. 233,333 189,877 43,456 58% 47% 400,000 360,000 40,000 Total Property Damage 175,000 164,441 10,559 58% 55% 300,000 270,000 30,000 VEHICLE Professional Service 1,739 Insurance 390 Loss Prevention 10,464 Repair / Replacement 40,268 Total Vehicle 70,000 52,861 17,139 58% 44% 120,000 100,000 20,000 WORKERS' COMPENSATION Settlement / Benefit 393,082 Professional Service 6,250 Insurance 71,441 Loss Prevention 27,641 Miscellaneous 21,987 Total Workers' Compensation 379,167 520,401 (141,235) 58% 80% 650.000 780,000 (130,000) UNEMPLOYMENT - Settlement/Benefits 93,333 98,778 (5,444) 58% 62% 160,000 320,000 (160,000) Total Direct Insurance Costs 950,833 1,026,358 (75,525) 58% 63% 1,630,000 1,830,000 (200,000) Insurance Administration: Personal Services 168,848 166,790 2,058 58% 58% 289,453 289,453 Materials 8, Service 133,487 96,239 37,248 58% 42% 228,834 228,834 - Capital Outlay 58 - 58 58% 0% 100 100 Total Insurance Administration 302,392 263,029 39,364 58% 51% 518,387 518,287 100 Contingency 1,368,776 1,368,776 58% n/a 2,346,473 2,346,473 TOTAL REQUIREMENTS 2,622,002 1,289,387 1,332,615 58% 29% 4,494,860 2,348,287 2,146,573 NET 1,041,666 2,231,522 1,189,855 - 2,031,114 2,031,114 DESCHUTES COUNTY 911 Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Budiget Actual Variance % of FY % CoII. Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital $5,861,335 $ 6,691,945 $ 830,610 100% 114% $5,861,335 $6,691,945 $ 830,610 Revenues Property Taxes - Current 3,708,612 5,550,900 1,842,288 58% 87% 6,357,621 6,357,621 Property Taxes - Prior 80,500 219,049 138,549 58% 159% 138,000 219,049 81,049 Federal Grants 276,500 (276,500) 58% 0% a) 474,000 474,000 State Reimbursement 5,833 11,163 5,330 58% 112% 10,000 20,921 10,921 Telephone User Tax 320,833 428,527 107,694 58% 78% b) 550,000 550,000 Data Network Reimb. 7,000 3,938 (3,062) 58% 33% c) 12,000 25,883 13,883 Jefferson County 18,083 29,779 11,696 58% 96% 31,000 31,000 User Fee 29,167 48,026 18,859 58% 96% d) 50,000 52,340 2,340 COPS Reimbursements 17,500 (17,500) 58% 0% e) 30,000 (30,000) Contract Payments 40,833 252 (40,581) 58% 0% 70,000 32,134 (37,866) Miscellaneous 4,958 6,971 2,013 58% 82% 8,500 9,000 500 Interest 23,333 29,649 6,316 58% 74% 40,000 40,000 Interest on Unsegregated Tax 1,167 565 (602) 58% 28% 2,000 2,000 Total Revenues 4,534,319 6,328,819 1,794,500 58% 81% 7,773,121 7,813,948 40,827 TOTAL RESOURCES 10,395,654 13,020,764 2,625,110 58% 95% 13,634,456 14,505,893 871,437 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency % Exp. 2,338,466 2,134,594 203,872 58% 53% 4,008,798 3,878,798 130,000 889,084 715,644 173,440 58% 47% 1,524,144 1,524,144 1,028,417 79,163 949,254 58% 4% a) 1,763,000 1,763,000 591,536 754,061 (162,525) 58% 74% f) 1,014,061 1,014,061 3,105,931 3,105,931 58% n/a 5,324,453 5,324,453 TOTAL REQUIREMENTS 7,953,434 3,683,462 4,269,972 58% 27% 13,634,456 8,180,003 5,454,453 NET (Resources - Requirements) 2,442,220 9,337,302 6,895,082 - 6,325,890 6,325,890 a) Federal Grant DHS/ODOT CAD Project $474K. Capital Outlay: Software $35K, CAD Project (funded by Fed Grant) $474K, Network Upgrade $24K, CAD Mapping Project $30K Records Management System $1.2 million. b) Received quarterly (Nov, Feb, May and Aug) for fiscal year c) Yearly agency billings have been mailed. Expect payments in February d) Crooked River Ranch paid annual fee of $45,869. Expect two more US Forest Service payments of $2,156 each e) Revenue not expected this fiscal year f) Transfers made as requested. Transfer to New Facility Property Fund, $754,061, made 9/15/10 & Transfer to Reserve Fund, $260,000, will be made in 3rd Qtr RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges Pff Emp - Add'I Prem Employee Prem Contribution COIL Retiree / COBRA Co -Pay Prescription Rebates Interest Total Revenues TOTAL. RESOURCES REQUIREMENTS Expenditures: Personal Services Materials & Services Claims Paid-Medical/Rx Claims Paid-DentalNision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Deschutes Onsite Clinic: Healthstat Equipment Remodel Miscellaneous Health Benefits Trust Statement of Financial Operating Data Seven Months Ended January31, 2011 Year to Date Budget Actual Variance FY Coll. % Revised Budget Year End _ Projection Variance $ 16,400,000 $ 16,988,140 $ 588,140 100% 104% $16,400,000 $16,988,140 588,140 6,560,167 29,167 291,667 568,750 262,500 58,333 6,668,327 108,160 26,505 (2,662) 284,195 (7,472) 836,423 267,673 435,603 173,103 46,718 46,718 70,767 12,434 7,770,583 8,368,538 597,955 58% 59% a) 11,246,000 11,403,534 157,534 58% 53% 50,000 40,000 (10,000) 58% 57% 500,000 485,000 (15,000) 58% 86% 975,000 1,275,000 300,000 58% 97% 450,000 650,000 200,000 58% nia 46,718 46,718 58% 71% 100,000 120,000 20,000 58% 63% 13,321,000 14,020,252 699,252 24,170,583 25,356,678 1,186,095 92% 85% 75,413 7,262,613 1,091,637 192,500 43,750 175,000 23,333 29,750 133,887 8,458 66,208 36,108 Other 88,166 Total Materials & Services 9,151,410 Capital Outlay Contingency TOTAL. REQUIREMENTS NET (Resources - Requirements) 71,732 7,153,499.97 1,014,693.01 (52,913) 196,399 62,429 174,280 23,903 29,814 100 8,110,368 31,490 1,172 47,795 2,282 26,299 8,711,145 Exp. % 3,682 58% 55% 109,113 76,944 52,913 (3,899) (18,679) 720 (570) (64) 102,397 7,286 18,413 33,826 61,866 440,266 100 8,110,368 58% 58% 58% 58% 58% 58% 58% 58% 57% b) 54% b) nia 60% 83% 58% 60% 58% 58% 14% 58% 8% 58% 42% 58% 4% 58% 17% 58% 56% 58% 0% 58% 0% 29,721,000 31,008,391 1,287,391 129,280 12,450,194 1,871,377 330,000 75,000 300,000 40,000 51,000 229,520 14,500 113,500 61,900 151,141 129,280 11,999,419 1,702,066 (52,913) 330,000 75,000 300,000 40,000 51,000 229,520 14,500 113,500 61,900 151,141 450,775 169,311 52,913 15,688,132 100 13,903,488 15,015,133 672,999 100 - 13,903,488 17,337,292 8,782,876 8,554,415 58% 30% 29,721,000 15,144,413 14,576,587 6,833,292 16,573,802 9,740,510 - 15,863,979 15,863,979 a) Year End Projection is amount appropriated in operating departments' budgets. b) Projection based on annualizing 31 weeks of claims paid. YTD actual is an average of $261,783 per week. Deschutes County - Fair and Expo Center YTD -Budget Basis Commissioners Statement of Financial Operating Data Seven Months Ended January 31, 2011 Year to Date Budget Actual Variance FY % Coll. % Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 2,809 $ 6,590 $ 3,781 100% 235% $ 2,809 $ 6,590 $ 3,781 Receipts: Special Events Revenues 395,350 379,438 (15,912) 58% 56% a) 677,742 633,438 (44,304) Interest 1,167 599 (568) 58% 30% 2,000 1,432 (568) Storage 29,750 14,387 (15,364) 58% 28% b) 51,000 31,387 (19,613) Camping at F & E 5,250 887 (4,363) 58% 10% 9,000 9,887 887 Horse Stall Rental 24,500 255 (24,245) 58% 1% 42,000 38,255 (3,745) Concession % - Food 123,083 109,476 (13,607) 58% 52% a) 211,000 185,476 (25,524) Rights (Signage, etc.) 54,250 41,738 (12,513) 58% 45% 93,000 116,738 23,738 Interfund Contract 26,250 (26,250) 58% 0% c) 45,000 45,000 Miscellaneous 2,575 12,944 10,370 58% n/a 4,414 15,482 11,068 Total Receipts 662,174 559,723 (102,451) 58% 49% 1,135,156 1,077,094 (58,062) Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Reserve Fund (617) Total Transfers In 115,453 115,453 0 58% 58% 197,919 197,919.25 0 14,509 14,509 (0) 58% 58% 24,873 24,872.75 (0) 46,667 46,667 0 58% 58% 80,000 80,000 - 134,885 166,000 31,115 58% 72% d) 231,232 166,000 (65,232) 58 - (58) 58% 0% 100 100 311,572 342,629 31,057 534,124 468,892 (65,232) TOTAL RESOURCES 976,556 908,942 (67,613) 58% 54% 1,672,089 1,552,576 (119,513) REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Total Expenditures Exp. % 543,604 512,173 31,432 58% 55% 931,893 881,462 50,431 278,066 326,609 (48,543) 58% 69% e) 476,685 539,227 (62,542) 67,412 72,061 (4,649) 58% 62% 115,563 115,563 58 - 58 58% 0% 100 - 100 889,141 910,842 (21,702) Transfers Out- Reserve Fund 5,833 10,000 (4,167) 58% 100% Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 1,524,241 1,536,252 (12,011) 10,000 10,000 80,411 80,411 58% n/a 137,848 137,848 975,385 920,842 54,543 58% 55% 1,672,089 1,546,252 125,837 1,170 (11,900) (13,070) - 6,325 6,324 a) Revenue unusually high in July and August due to BMW and FMCA events. b) Most storage activity begins in October. c) Interfund contract revenue is for park maintenance, from Fund 130 d) Cash flow from Fair 2010 is projected to be $57,000 less than budgeted e) Year to date amounts include costs associated with BMW and FMCA events and expenditures for HVAC repairs. ci) E -s ciw IN-: 0 P4 a• a -eEmi 'F'• Att Ca) Secure Treatment Facility Bethlehem Inn ti z 0 H U W O a. H c U m O • O c 73 c U m a) U � a) c > Q O x U W a) RESOURCES: 1' CO O O s— r-- 1- 1- M O O 1 O L N N (O N CO Qf N CO (O O O O O Of M (O Total Resources EXPENDITURES: Materials & Services O O 14) N (O 1— Cr) r— (O N' O' M 0 ' Cr) N 1- (OO I- (O 1.6 O co. O v (O(OOOONCOOMI` (O CO 1.0 M O er M O O Cr) er CO CO N O O M N O O CV CO (O • U') 1— Cr) O 14) r Cr) 14) O N- O O 0 LC) ' O O ' O ' ' N c.6 -4-- O(0 O' O 14) M O (O 1I) O N O N CO Cr) x— Cr) CO CO M 1.0 M O O Cr) 1' CO CO N O O cr Cr) N O CO N'— CO ▪ O CO tC) CO to O CO00- CD CO Cr) 0) 1 1 1 1 1 1 1 1 1 CO (0 O N O N CO Cr) M I-- CO CO CO M M O O M CO CO N O O er Cr) N O 1 O N CO O CO 14) CO 14) O '- co- co - Cr) M O O) O N O O O O O O 03 CO CO O O (O d' 1.0 O O 03 0 • O O0 (O . N 1 - N Cr) O O CV 0 (O O '4) N '4) d N N CO CO O 145 O M O 1 to C a) c E O > U U 2 a) e 6 co w _ O O N O U .� co 3 m c • Z O D U O) O O O O M N M N O '4 ) N M M O O '4 ) M N N (1) N 141 M O N O (O Csi O e - M O 0 O I- O CO 'f) N Cr) O v L.6 v- is 0 Ta 0. is U O 1- Total Expenditures 11 Z CO In F - v Z C • W N O a 0 U 1171 U Q U w a Z mca • CO� c o U EL! W 0 N O N N N Cn N N O ch N O cA ti co O 't N CO CO CO N'- Co ti CO N O M CD O)c') co �t O) v• ti CO ,- co N- N o Co c.c) c)) a) c.) N- c.) N N- co ,-cc) CD .- N CO N CO CD O) O) x- (NJ c-) N �t 0) (DtiO)c))0)tia)(00)(o0d'(nd's-d'(D(0(0 ti Co M -N L.0 0 '- (0 '-0CD0N N N ,-- cf) — (D — N o CO CD cc; N CO ocN c*) cc) CO c(7 ti CO ti o N N (D O) CD co) ti O N CD N N (') (D `-' — N N — — A. r• — — — N r- e- e- r• CO 0 �. M — N o (o co (3).0 N O O (`7 M-.,..„,, = CO ce) co Lo- (.4 _ O7 0) (17 o (1) N.: � 'NEA 0 OchV O N Crj ti (▪ D (3 cc) Lo r CO O c`- CD o C� NC Cco CO0�V L. O (ft. on 46 _.C7 L,.,3 - c3 OCD O)oo�- CON O °�RIMO%Ooo a� `- Cp co D) CDa �oOd� Nao(Di 8pofo�O� Ooho oO� (D U o, O�(D>94-4- Oc'O 73 cow cD�o CvOCD Co- 0r OC cit ur O) N O >.N U 3 O O�( fco ca �Ma) —p vO(D� o00pa)NCD Uo N ma �c7 OOoa_0 2 E(0c co c0E%ON a) p) O O (1) ea. o ON�Oc NC�> Opo ONo O '12 O O NJ ''CpCO 6,0 CN (D YY>o. co O . • c _ O < 0 N � p N (fl OCEI Co\D C O O> O N O U CO C O c (C N O U V co d - O o co .Y o c U m c o N m L o a m o rn o c o c ,o o c (15 m c N co ` . O p .o (D c N U • O > U c L c Y O) (� (4 c N O L 06 C a c a) (D N U N N N cr)fn o U (D •O a) O) N N N N- L N UCr • 'N - U U O ,co U N (p �y aa))in vYcca°IScr) o���wmc2^,as 1:{ (1) ooE �m�`)'u)��E� o▪ E E v c c U 3 .c ▪ >. . Y 3 -E 2U ami m Y c .Y o c a) 3 2 a) 06 .`,F) N .5 ° c U 00 0 c�� ,w � c w Y 0= (/) m� fa .u) o N C� '4 N .y o N N o (`o •`-U� •`u X u= u U U i3Uw m a,r5cn5QO�-t•a20w- F-CLO=M2<lil 0 N c C 2QQQM2LLD0 -N(') (01'-000)—00f. Co O) — CV C•')1- CO CO O)0— ')Cof` N ' co *k17 *k * *k *k *k It *k *k *k It *k *k *t *k *k It *k It It *k *k *k • *k *k *k �k * M. M. M. M. M. M. J OU Engineered Structures Inc A- U7 U7 Total Change Orders U7 cc) ti ti Total Engineered Structures, Inc. " cc) Co N Total Encumbrances & Commitments (O O a c ([1 0 (O N c 7 U r 0 O N O' o d M O `- U c co E d CD asap a) c (21 N m o a)CLt U a) 0 d f[1 0. f[I U rn PROJECTION a) U c (a ca O H. U (1) p) 'O a 0 7 m Encumbrances & Commitments Received and a a) c a) O. w RESOURCES: co O CO O' M O (C) M N O N 0 0 0 CO 0 0 O N 0 0 O N M (C7 (n tS M CD N CO M N et M O M M Tr 0 0 COOOt's M r M N N LO co- N co 0 CO M et 0 0 CO 0 0 1-- M r M N to to M N- N (n (,) N rn O U U c ca 0 cc AaC/1- -a U N o O a m oa a) mLL Transfer In -911 Fund 705 / 710 a) Total Resources EXPENDITURES: Materials & Services N 0) 00 0 M) (0 N N (0 r 00 r r COTr COM0) co • CO CO 't • (O (0A- 01- A- O) •N r N N Tr co- O) N r...m• .... ....v ........(O N_ CV 0) CO O_ N co N 00 (0 r co 0)Tr In co O) 00 LO u) O 0 (00 (O CO (0A C7 coTr vr ( OHO CO 00 v O N N (O O) N- co N O) r r - CV r (0 00) 000 00 000 O' O r.00...000 N- — N O O r O r o (D (0 N ([) ([) ([) N CO N 0) CO 0 N CO N CO (n r CO 0) ‘71- tO M r CO 0) CO CO CO r (0 O 0 (0 0) et 0) CO CO CO (A (C) CO (O c0 ONr- (OO N c0 N O) r 1. -- CV r (0 M O c0 c) OD OD M M (0 CO co N O) O C1.6r) O N N 0) CO 0 N (O N CO (n r CO O) ‘71- (n C) r CO 0) c0 (O c0 r (0 0) 0 (C) O O CO CO CO CO Tr 10 M (O (x O N F- (O O) N- CO N O) r N- N r (0 M_ O N_ O (O co 00 0) (O (0 (0 t� 000 Ir --n ' ' 0 0 0 ( (OA co M (N M t- In CO N (C) O ' c0 0 c0 (O N M v N r O CO co 0 CO N_ t0 (C7 (0 c0 O c0 co cc r ' t- (n N 10 O) N ([) t- (0 N CO O r 0 O CIC - N M ti co M 'coin N r 1n E.D. 7 N N X a1 a)cr, (? M 0 4.1m 0 Z E a) o cn N E (a c p U aE) w ail �) > 3 D) v) fn • a) c a) co O N N Drn ed 7 o) m o E 3 7 n_ 71-Sj c a) U O E a c U N a) n °� Om LI �`mcorna8a).c w o 2 �caEa�ocI rn ,c c c d ca) � O U m m -s. 0 c c c' m vi m •c s c a o 41 O o= 0- :12 ,c c U 'Orn y c CD 7 a) >`E U •C L C 0 .° 3 u) d) E` (Li O 2ca)o Na)a•ca)(o H a)c o7yH ¢wH 5 ¢ w O copZpOULi.H U Total Expenditures CD Z co >+ C C 7 LI - 0 U t CD N O 7 � La w co Q CI (0 U 0) PROJECTION O ) CU CU (0 OO a Encumbrances & Commitments Received and RESOURCES: M CO Co CO Cr)- O N LO O N Co O N Co O N LC) LO I's CO N CO M (0 CMO CO Cr)- r --- LO CO CO N M v�rn CO CO M A— 1, -- LO CO CO N M 0 U N U C CO 7 CA N O CU C CO N C CU (`0 O O (10 n 4) c m Li EXPENDITURES: O O O (O N N Cn F M M O co M CO A— CO O CC) Cf) O At co CO C7 (O on. N — N NCACOON(ONCOLO 0)O) (n M A— CO CA CO CO CO A— CO O CC) CA O CO CO 00 LO Cr) Cr) ( O N N 0)) (O N O O ' O O LOO N 0) CO Co N CO N CO LO A— 0) 0) (n M CO O CO CO CO A— CO O LO CA 0) CO CO 00 LO M Cr) CO CO O N ti - (O (O CO N 0) N 0) CO O N (O N CO LOA— 0) 0) LO Cr) A— CO O CO CO CO A— CO 0) LO O O CO (O CO L) M Cr) (O O Azi O N ti (O (O CO N 0) N LO LO (o ti CO 0) M M O CO 1) CO (O N 0) Cr) (D m CO (() At - Lo O) co CO CO O 1- 1- o 4— 0 0) cl CO CA Q) O co CO 0 N M co N a) a) V U —� •� 0 m NN iv O Cn (n _ a) N C > a) CO 3 U U) U) CU = C`5. (0 O CU CU tT 057 U (`0 V) a LL +• 1: U > r in L - N CU CU , E Q) U U cB 7 0 Q d CO(...,a) 0 c E 0 UN aro U CV Q •C v= w 0 C C O. CI) O U— �0 C .� C 7 (`0 C L ate. U N 0. _N r i U .O en c N 7�>= C L O w (n O a) L C CV (0 .. to N 73 C •— .. I— CU O C F- �Qw�a�EI�QaD 2O UZ O Total Expenditures H z W o2 co 1- C g N O £Z O Q d co C N W N CL o U Q r- CO CAS U Z w c N N Amount Paid c E C 0 E O U O c C Interior modular walls Herman Miller O O hCO O r-Oh(O CO ONOOOO N O CO_ LO CO h Oh 0)d OO_O MOM CO N N CO CO CO Co O) 0 CO O) h h N 0 0) CO Na, M d 0 d N- to N h N N d M 0 O) N CO . to M N- 0) O M Cr) d O) 0 O O 0 LO CO0 CV LO M O O o d 0 M d O) ,- N d d N h O 0 N 0 0 CO to to C- CV CO a0 C6 Cc CO N O h N r co" co" h M 0 tf) N CO M h O c N Cr) Cp O N �' 0 O N N r- r- r- N N- d CO O CO O) N N N CO 10 d CO 0) o U) Cdr) M N N Lei to co o CO N N45 co .4- o o .4- o-, ZH f, o O �O 00) c CV N O d O o O O O - O O F..- N b9 G r O O Ocli Oco CO69 C Oo A - d. -.O N E CO E09 N- o O d O O C) o `dM� v o C p O C N N O ,,,•- O r- O O -.4,.. y o O C ,O g� M i-HIfl m- NN �p00▪ co �o Ec)�myoo0 to,o O y.y atpw O. v-- C g O Com' y Qs 69 -ow- y d y V 3 O O D N O y •Q V 7 f/) f/) i N C °: E o >, ' co „O o O) y 0•0 o0 N L c0) O O O U G) G) y V U N CA C d .y. O o y N y o 3 C H y` y- y O O E •> C C1 N w 3 c - v. V 4- 0 o d C L a c j O'0 i= c V CO O C V ,C .0 u)) .-5O 0 05- U cv 7 U L U y •C 6 C L .O d E 'f0 N -g U N N V `r O C C V O N c N m-- w c m 2 cots -0 02 m 5 0, =:pp m m 77 Qc E•� E'° m a�ci amici m xLL ° g Ev o 2 o m y T c m Y E 3 E m m E m • c) u• _� co -2 v Q C) _a) cy) a d mU O y U- c V-- S- •y O<N N O M •y •y .a .y O X O .y .y CO - •y O X 'y 7 y V C C)� Q5• coilN 5 LL aOp 0 c) NMLL7 CO CO NO EN) NM Nd to coo NO CO' M(NN� CLL' M CCO Od¢ N CO d LO co �6 aaAaaaag OU M O O 69 O N O 99 Engineered Structures Inc Total Encumbrances & Commitments PROJECTION a) U Encumbrances & Commitments RESOURCES: O O er O O O 1.0 O O O O M O O O M O M O N CD N N O O 0 O O ' M O M M O M d N CD N N O N d CD O N O 1- O CD O CD Cr; 0) O CO CD 0 11.0 N O N '1' CO O N O O CO O CD M O O P CO CO 0 d 1A N N O O ti C 7 Transfer In -911 Total Resources EXPENDITURES: Materials & Services CO O CO L0 r (D O O O CO' CO - CO CD r CO r r CO O 0) LO ▪ N O O � � ✓ M O O CD O O O O O O O CO co co O r ▪ O oi ▪ N O O (1) 2 X (A LL CD °LS cu 3 off N m 2 H m Q L1 ` cu co ca 5 a) YC O O E L Eo p iB E 22~ coO ( U 0 O O O O O r -- N- 1.6 ti O CO I 0) (0 1 O r O I 0 O O O O O (D O O O 0 O O O 0 0 0 0 0 0 O O O r O O (D O co- O co co N r ti co CD r r M N r 0 O O O 0 0 0 0 0 0 0 O O O 0 0 0 0 0 0 O O O r 0 CO 0 0 co- 0 co M N r N' ti r co r .— co M N ,— x— COx— Furniture & Fixtures O ' Cr) ti CO M O 0) CO CO O LO (D N co co • O CO O (0 N 0) (D O O 0) (D O c' CO 0) O O M co O) co co O ti 11.0 11.0 CD CO M Total Expenditures 0) co Z oW c -o -2N U M ap 2Z.5 0<E w W 5Up u_ Z O Z Q rn U Z W U C (1) (C 7 Ts a m Amount Paid C a) E E O Q U C 0 O_ 0 N O O CO co co co O O) O) Radio Dispatch System N O O CO co co co O O) O) PROJECTION U c LL 0 on O 0 a co N a) U c E 0 U w C E E E O U c fa .a) U a) CD c CD 0- X w RESOURCES: M O CO CO O ' M O N r -- 03 -O et O M O (0 M O M O N 0 0 A O N O O N N CO O N N f- 0 0 0 0 0 0 0 0 0 0 0 O M O N O O r a- ( Q N t 0 M 0 co M O M O N 00, -ON O O N N CO O N N f- N O) O O N O O O Itf N N N t O M 0 co M O M O N 00, -ON. O O N N N N iA O U a) U c (a O cC a) a) U O c O J State Grant EXPENDITURES: Materials & Services 00000) 0 ,-N 0 - (0 0) N - co O f- ' co ' O M N O N O) M O) O co O O CO M M O M M M �C) O M tt O 0 0 M 0) M ti M (D O N (D O M O N a - O , O U EH O 0 0 0 0) M N,- V 0 CO 0) (O 0) r- r- h CO f,- 0 — CO 0) CO 0) 0 N LC) CO CO a- 00 0 0 O 0 f� M 0A- A- O O Nt N r- r- f- O) O 0- c5 (O O O M O M N O f- N Id: et 1-. Ncn U - M M (O ((0 O) CO o ° U N r r r C 13 7 f0 000 MA -0 O (0 0 00 00 -0 fa 000 (0 0) 0 O 0) O 00 00 c O O O ' MN 0 ' O' f N No OCOc a -p r- 0) N 0 0 (0 N 0 0 M 1n O a) r- — — M LO O CO 0) N 0) a) 0 0 M U N N N ( j `O co a v ER N N A- 13 13 et O 0 0) N O M et N CO 0) CO 0) r- r- ‘ - f• tD C 0) ,- 0 A- CO N Nt 0) M N O CO M O (h O C 7 CO 0 f� M O) 0'7 7 co -4- N CO f- f- M 0 u_ O (O O O M M, 0) f- M tt et 00 N C -- 03 M ,- 0 f- NI- et M O Cl N CO (O O) a) O U 0 y_ N Cl O f� (p (p M 0) N co M O O Z M ' f- O O ' 0) 0) 0 M N (O f- f- M M 0 05 tt V O 0 Oc M U 2 ER m 0) c > O 0 0. N O 0 0) N O M tt N co O) CO N a- l- M 0) .- 0 .— f� A— CO N Nt 0) VI Cl O CO N O O 0 CO O a) co CO.. N h M 0) 0 .- .- O Nt N O CO CO ' O) CD C 7 7 M O O M M 7 0) f� r. co (o (o 1n 7 0O M - O N LO LO 000 03 > H01 ✓ ._ a o a)N U 0 C ° 7 • O N M to M wa- c) O c c° 13 y y 6NR N u)E v 0 N N UN a) C + O Qz .j o CO • ate+ co .` 000 0) N� •U Q 0 • C y N tA� a) y 0 3 y a) DI 7 Tom LL i y N 0 w �`a d y3 a) a) • Q N ,- ° • cc 0 a) 0 0) !a ` ▪ .2 0 Cw mE S jm m °Q O U c �a o,.yu, v O U U aUCL C(C`C `> 3 R co oOW �c—CNNmQwwuaia<wJmF- �U o+s 0 0 I- I. Z m a O) t() I.L. 1 c H U W a`a)) I- I- o fx O C) a )p Z U Q O W -) O 0 L Z < o 5 co L cu u. c aU cw O 1 H I) U a) V) Amount Paid E E O E Q U c a U rn a) 0 O c to C) to P-- N N- N to O CO O N M to CO ' 00 O) M N c• O co to 1� 00 O to CO 1- M (O CO N to ti O M N M O) to N CO to 00 to CO N O O co 1-- O co O) (o 0) 03 CO 1- N N A- O 0) to CO D A- O N. 0) CO CO •sr O CO to � Q 0) OD CO to O tO to CA O CO CO CO CO to O CO CO O co- to O CA r- m N O M tr i- 0) r- 0) N CO CO - N, - N N N N,-,- N CO A- CA cn ca C tUC) a) -a) O c a .) a)_ x) a)3L C oa)Jc aCE w>+U 0)0 L 4 tU cu U Y w. C a) c O V a) C _w c U a) O _c• al rn to L ots ` w_. U • -o > to U O aCU ci • U) ° o c N • = a) c Ei -.E.to L3fa cuOaN c U a7 .� m�• '8 m c •c N T o rn O c t. m �, a a) c aa)) v is u) w m :� a) 0 w c O En_ � >, >, E E • c u) .� a 8 m c,. to 0 E r a) a) `•5 mta)0 ccrnP=v�iQa)Emt)�mm QCL WJ(/)< 0u.0 05MII-Q.0M(/)U)(/) Pinnacle Architecture Pinnacle Architecture m m 7 7 O 0 a) a) L L Q Q a) a) ( as C C C C Q. Q. a 2 ('j N CO to (O 1- CO CO - >, *k *k *k *k cr):rz' a)a) a) a) a) a) a) a) a) a) a) a) C Uy -o -o -o -o -o -o -o -o -o -o -o -o g a) . 00 0000000000 a) m a) a) a) a) a) a) a) a) c - c v)v) Q)ca) Q)Q)Q)0)0)0)Z7)0) ocno mC C m(ca(cammmmmmm N c L L .0 -CL L L L L L L L N 2 u)00 0000000000 U < 2 Total HSW Builders Deschutes County Bethlehem Inn (Fund 128) Seven Months Ended January 31, 2011 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ (2,725,000) $ (2,722,510) $ 2,490 100% 100% $ (2,725,000) $ (2,722,510) $ 2,490 Revenues Grants - Private Total Revenues 1,668,917 1,668,917 - (1,668,917) 58% - (1,668,917) 58% 0% 0% 2,861,000 2,861,000 - (2,861,000) - (2,861,000) TOTAL RESOURCES (1,056,083) (2,722,510) (1,666,427) 58% -2002% 136,000 (2,722,510) (2,858,510) REQUIREMENTS: Expenditures Debt Service: Interest Expense Interest Payment Exp. % 21,000 11,848 9,152 58% 33% a) 36,000 22,000 14,000 58,333 58,333 58% 0% 100,000 100,000 TOTAL REQUIREMENTS 79,333 11,848 67,485 58% 9% 136,000 100,000 NET (Resources - Requirements) (1,135,417) (2,734,358) (1,598,941) a) Interest on January 2011 negative cash balance ( $2,732,974.83) _ $1,382.96. b) Recap of expenditures - inception through January, 2011 Land/Building (Amertitle) - July 2007 $ 2,241,313 Hickman Williams 17,578 City of Bend - May 2008 250,000 KN EX CO 5,289 Kleinfelder 3,732 Total expended on facility 2,517,913 Interest on Negative Cash Balance 216,445 Total expended $ 2,734,358 b) - (2,722,510) (2,758,510) Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ (2,725,000) $ (2,722,510) $ 2,490 100% 100% $ (2,725,000) $ (2,722,510) $ 2,490 Revenues Grants - Private Total Revenues 1,668,917 1,668,917 - (1,668,917) 58% - (1,668,917) 58% 0% 0% 2,861,000 2,861,000 - (2,861,000) - (2,861,000) TOTAL RESOURCES (1,056,083) (2,722,510) (1,666,427) 58% -2002% 136,000 (2,722,510) (2,858,510) REQUIREMENTS: Expenditures Debt Service: Interest Expense Interest Payment Exp. % 21,000 11,848 9,152 58% 33% a) 36,000 22,000 14,000 58,333 58,333 58% 0% 100,000 100,000 TOTAL REQUIREMENTS 79,333 11,848 67,485 58% 9% 136,000 100,000 NET (Resources - Requirements) (1,135,417) (2,734,358) (1,598,941) a) Interest on January 2011 negative cash balance ( $2,732,974.83) _ $1,382.96. b) Recap of expenditures - inception through January, 2011 Land/Building (Amertitle) - July 2007 $ 2,241,313 Hickman Williams 17,578 City of Bend - May 2008 250,000 KN EX CO 5,289 Kleinfelder 3,732 Total expended on facility 2,517,913 Interest on Negative Cash Balance 216,445 Total expended $ 2,734,358 b) - (2,722,510) (2,758,510) Engineering Contract G. Friesen Associates, Inc. Original Contract Change Orders: Change Order 41 (Note a) Change Order 42 Change Order 43 Total Contract Amount Paid Through June 30, 2010 July 1, 2010 through January 31, 2011 Balance Due Construction Contract M A DeAtley Construction Inc Original Contract Change Orders: Change Order 41 Change Order 42 Change Order #3 Change Order 44 Change Order 45 Change Order 46 Change Order 47 (not likely to occur) Change Order 48 Change Order 49 Change Order 410 Change Order 411 Change Order 412 Change Order 413 Change Order 414 Total Contract Amount Paid Through June 30, 2010 July 1, 2010 through January 31, 2011 Balance Due Deschutes County - Solid Waste Area A Closure and Cell 5 Construction As of January 31, 2011 DEQ requirement for gas detection LFG well field management SOPs Storm sewer realignment, drainage, Area A thickness Meet CEC requirements, increase to electrical panel, Storm sewer realignment due to refuse encountered Revise valve vaults for improved efficiencies Add'I cover material from what will be Cell 6 Environmental controls building, pump station bulkheads Adjustment to pipe alignment to increase slope Additional rock to be set aside for future needs Manhole covers below grade to meet Road Dept requirements Modular Block Wall instead of MSE Wall Upgrade of cables (pump and leachate) Leachate Line connection from Cell 5 to Cells 3 & 4 Additional cover material due to settling Well modification, flow meter less LFG vaults Total of Engineering and Construction Contracts: Original Contracts Change Orders Total Contract Amount Paid Through June 30, 2010 July 1, 2010 through January 31, 2011 Balance Due "Area A" "Cell 5" Landfill Closure Fund 611 SW Capital Projects Fund 613 Total 241,869.00 182,516.00 424,385.00 19,656.00 21, 500.00 34, 316.00 33,431.00 19,656,00 21,500.00 67,747,00 317,341.00 215,947.00 533,288.00 254,413.44 153,904.42 408,317.86 62,927.56 62,042.58 124,970.14 2,097,140.50 3,290,779.98 5,387,920.48 14,302.54 24,885.69 152,500.00 1,332.00 2,486.98 26,000.00 5,350.00 2,323,997.71 1,707,132.00 373,720.63 243,145.08 2,339,009.50 302,329.21 2,641,338.71 1,961,545.44 436.648.19 243,145.08 45,095.00 152,500.00 148,958.89 225,000.00 5,167.76 3,200.00 6,354.75 3,877,056.38 2,054,537.51 1, 534, 748.19 287,770.68 3,473,295.98 619,707.40 4,093,003.38 2,208,441.93 1,596,790.77 287,770.68 45,095.00 14,302.54 24,885.69 305,000.00 148,958.89 1,332.00 225,000.00 2,486.98 5,167.76 3,200.00 6,354.75 26,000.00 5,350.00 6,201,054.09 3,761,669.51 1,908,468.82 530,915.76 5,812,305.48 922,036.61 6,734,342.09 4,169, 987.37 2,033,438.96 530,915.76 Note: There will not likely be additonal payments to M A DeAtley until Spring. The addtional services are for landscaping and other weather sensitive activities. Deschutes County Funds 611 and 613 FY 2011 Appropriations and Expenditures FY 2011 Appropriations M&S and Capital Outlay Contingency/Res for Future Total FY 2011 Appropriations Area A Closure & Cell 5 Expended to Date Less Expended in prior years Expended in FY 2011 Remaining FY 2011 Contract Total FY 2011 Expenditures Balance of FY 2011 Appropriation for Activities Other than Area A Closure / Cell 5 Other Activities Knott Equipment Building Interfund Loans Testing Services Internal Service Fund Charges Fund 611 Area A Closure Estimated Completion May 2011 Fund 613 CeII 5 Estimated Completion November 2010 785,000 306,221 1,091,221 436,648 65,486 371,162 243,145 614,307 476,914 32,210 Remaining Appropriation 444,704 2,538,638 551,196 3,089,834 1,596,791 129,262 1,467,528 287,771 1,755,299 1,334,535 421,426 3,624 3,599 905,886 Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Travel Expenditures and BOCC - County College Expenditures FY 2011 BOCC Conference & Travel Tammy Baney Conf/Sem & Educ/Training Travel Meals Accommodations Mileage reimbursement Ground Transport/Parking Total Baney Dennis Luke Jul Aug Sep Oct Nov Dec Jan YTD Total - 305 45 75 150 _ 575 20 -150 55 225 77 429- 127 254 887 240 255 - 306 297 1,098 - 27 60 87 337 989 45 685 816 2,872 Conf/Sem & Educ/Training Travel Meals Accommodations Mileage reimbursement Ground Transport/Parking Total Luke 305 - 305 56 37 25 74 32 225 77 76 506 ' 85 (214) 529 282 ` 178 190 211 148 61 1,069 17 - 17 432 292 1,025 370 (34) - 2,146 Alan Unger Conf/Sem & Educ/Train ing 305 !; 45 30 380 Travel Meals 198 - 32 230 Accommodations - 1,4.14 - 362 1,776 Airfare 1,133 - - - 1,133 Mileage reimbursement 372 - 575 947 Ground Transport/Parking 29 ' - - 29 Total Unger 1,133 2,317 45 998 4,494 Tony DeBone Conf/Sem & Educ/Training Accommodations Mileage reimbursement Total Other OP - - 350 45 395 536 - (107) -429 122 122 536 350 14 45 945 Total - BOCC Department Conf/Sem & Educ/Training 1 - 610 395 75 225 1,655 Travel Meals 76 37 25 ' 74 182 87 680 Accommodations _ _ 154 76 1,470 85 (195) 616 3,621 Airfare - 1- 1,133 Mileage Reimbursement 522 178 445 211 454 933 3,235 Ground Transport 17 ' - - 27 60 133 Total - BOCC Department 769 ? 292 2,550 765 544 1,921 10,456 FY 2011 Budget 19,600 Percent of FY 2011 Budget Expended 53.3% BOCC County College Public Information _ 1,874 - 1,874 Office/Copier Supplies 33 65 52 - 150 Meeting Supplies 295 930 828 - 2,053 2,202 995 880 - - 4,077 2/24/2011 Deschutes County Administrative Policy No. F-10 Effective Date: January 7, 2008 Revised Date: June 24, 2009 Revised Date: February 24, 2011 INVESTMENT POLICY GUIDELINES STATEMENT OF POLICY All Deschutes County investments must be made in accordance with State Law and in accordance with the Deschutes County Investment Policy. Investment policies must be approved by the State of Oregon Short -Term Fund Board. This policy was designed after the model investment policy recommended by the Oregon Short -Term Fund Board and incorporates State Law requirements and restrictions, and was approved by the Oregon Short -Term Fund Board. APPLICABILITY This policy applies to all Deschutes County investments. POLICY AND PROCEDURE The Deschutes County Treasurer is the portfolio manager. It is the policy of Deschutes County to invest public funds in a manner which will provide the maximum security while providing liquidity to meet the daily cash flow demands and receive the highest investment return while conforming to all State Statutes governing the investment of public funds and this Investment Policy. SCOPE: This investment policy applies to activities of Deschutes County with regard to investing the financial assets of all funds for which investment authorization has been given, including but not limited to the following funds: A. B. C. D. E. F. G. H. I. General Fund Special Revenue Funds Capital Project Funds Enterprise Funds Debt Service Funds Internal Service funds Unsegregated Tax Account County Service District Funds Trust and Agency Funds Funds held and invested by trustee or fiscal agents are excluded from these rules; however such funds are subject to the regulations established by the State of Oregon. Funds of Deschutes County will be invested in compliance with ORS 294 and other applicable statutes. Investments will be in accordance with this policy and any written administrative procedures. Investment of any tax-exempt borrowing proceeds and any debt service funds will comply with the "arbitrage" restrictions of Section 148 of the Internal Revenue Code of 1986. Cash will be co -mingled for investment opportunities. Other than bond proceeds or other unusual situations, the total of all funds ranges from $80,000,000 to $150,000,000 over the fiscal year. Policy #F -l0, Investment Policy Guidelines Page l of 7 Funds of other agencies, jurisdictions, district or entities for which the County Treasurer serves as custodian will not be invested without written authorization from their governing body, and the Deschutes Board of County Commissioners. OBJECTIVES: Deschutes County's Investment Objectives are: Preservation of capital and the protection of investment principal. Conformance with Federal, State and other legal requirements. Maintenance of sufficient liquidity to meet operating requirements. Diversification to avoid incurring unreasonable risks regarding specific security type or individual financial institutions. Attainment of a market rate of return throughout budgetary and economic cycles. DELEGATION OF AUTHORITY: The County Treasurer is designated as the Investment Officer for Deschutes County and is responsible for investment decisions and activities. The investment officer shall be responsible for all transactions undertaken and shall establish a system of controls to regulate the activities of subordinate officials. The administration of the cash management program is handled by the County Treasurer who is responsible to manage the day-to-day operations of the County's investment portfolio, place purchase orders and sell orders with dealers and financial institutions and prepare reports as required. INVESTMENT LIMITATIONS: Specific investment types shall not exceed the percentage of the total investment portfolio indicated below. All securities are also included on the list of "U.S. Government Agency Securities for Local Government Investments under ORS 294.035 and 294.040." This list is maintained by the Office of the Oregon State Treasurer. Securities issued by a single financial institution (Banker's Acceptance and Certificates of Deposit) will be limited to 30% of the total portfolio. SUITABLE AND AUTHORIZED INVESTMENTS The following investments will be permitted by this policy, ORS 294.035 and 294.810: • U.S. Treasury Obligation (bills, notes and bonds) • U.S. Government Agency Securities and Instruments of Government Sponsored Enterprises • Banker's Acceptances (BA's) from qualified institutions • State of Oregon Investment Pool Policy #F-10, Investment Policy Guidelines Page 2 of 7 • Certificates of Deposits (CD's) (Subject to ORS 295 collateralization) • Certificate of Deposit Account Registry Services (CDARS) • Repurchase Agreements • State and Local Government Securities • Corporate Indebtedness Note: These limits apply to the total portfolio at the time the Investments are purchased. PORTFOLIO DIVERSIFICATION Diversification will be sought within the following guidelines with the purpose of reduction of overall portfolio risk. The investments shall be diversified by investment type, issuer and maturity: U.S. Treasury US Government Agencies State of Oregon Investment Pool Certificates of Deposit Banker's Acceptances Commercial Paper & Corporate Notes State & Local Government Securities Repurchase Agreements 100% 75% 50% in any single government sponsored enterprise 100% or the maximum imposed by statute 25% of total portfolio 30% in any single qualified financial institution 25% of total portfolio 30% in any single qualified financial institution 20% of total portfolio 5% in any one corporation, subsidiaries or affiliates 25% of total portfolio 25% of total portfolio 10% in any single qualified financial institution Corporate Indebtedness 10% of total portfolio Maximum 18 month maturity Note: These limits apply to the total portfolio at the time the Investments are purchased. COMPETITIVE SELECTION OF BIDS OR OFFERS: Before the investment officer invests funds, competitive offers or bids will be sought from at least two institutions, or a decision to invest will be based on data received from at least two institutions. The most favorable offer or bid will be awarded the transaction. Policy #F-10, Investment Policy Guidelines Page 3 of 7 MATURITY SCHEDULING: To the extent possible, the County will attempt to match its investments with anticipated cash flow requirements. No investment security shall have a maturity of more than 18 months, with the exception that a maximum of 20% of the total portfolio may include investments beyond 18 months, but not more than 24 months. The investment portfolio operates on a policy of buying securities and holding them until their specified maturity date, but during certain market conditions when it becomes advantageous, the Portfolio Manager may sell securities prior to their maturity date. SAFEKEEPING AND COLLATERALIZATION: Investment securities purchased by the Portfolio Manager will be in safekeeping with the Bank's Investment Division Safekeeping Department. If it is felt necessary to safe keep with a third party, the Trust Department of the bank will be considered to be a third party for the purpose of safekeeping of securities purchased from that bank. Another permissible option would be to use a third party bank to provide safekeeping for all purchased securities. The purchase and sale of all securities will be on a payment versus delivery basis. The custodian shall issue a safekeeping receipt to the Treasurer listing the specific instrument, rate, maturity and other pertinent information. All other repurchase agreements shall require safekeeping and a master repurchase agreement. Deposit -type securities (i.e. certificates of deposit) shall be collateralized through the Collateral Pool Manager as required by ORS 295.015 for any amount exceeding FDIC coverage. Other investments will be held by the custodian as evidenced by safekeeping receipts. QUALIFIED INSTITUTIONS: The investment officer shall maintain a list of all authorized broker/dealers and financial institutions which are approved for investment purposes or investment dealings. Any firm is eligible to make an application to Deschutes County and upon due consideration and approval will be added to the list. Additions or deletions to the list will be made at the Portfolio Manager's discretion. At the request of Deschutes County, the firms performing investment services shall provide their most recent financial statements or Consolidated Report of Condition (call report) for review. Further, there should be in place, proof as to all the necessary credentials and licenses held by employees of the broker/dealers who will have contact with Deschutes County as specified by but not necessarily limited to the National Association of Securities Dealers (NASD), Securities and Exchange Commission (SEC), etc. Deschutes County shall conduct an annual evaluation of each firm's credit worthiness to determine if it should remain on the list. Securities broker/dealers not affiliated with a bank shall be required to have an office located in Oregon and/or be classified as reporting dealers affiliated with the Federal Reserve as primary dealers. PRUDENCE: The standard of prudence to be used by the County Treasurer in the context of managing the overall portfolio shall be the prudent investor rule, which states, "Investments shall be made with judgment and Policy #F-10, Investment Policy Guidelines Page 4 of 7 care, under circumstances then prevailing, which persons of prudence, discretion and intelligence exercises in the management of their own affairs, not for speculation, but for investment, considering the probable safety of their capital as well as the probable income to be derived." INDEMNITY CLAUSE: The County shall defend and indemnify the County Treasurer and staff from personal liability for losses that might occur pursuant to administering this investment policy as long as the County Treasurer and staff exercise prudence in accordance with this policy, and act within the boundaries of this Policy. ETHICS & CONFLICTS OF INTEREST: Officers and employees involved in the investment process shall refrain from personal business activity that could conflict with the proper execution and management of the investment program, or that could impair their ability to make impartial decisions. Employees and investment officials shall disclose any material interests in financial institutions with which they conduct business. They shall further disclose any personal financial/investment positions that could be related to the performance of the investment portfolio. Employees, officers and their families shall refrain from undertaking personal investment transactions with the same individual with whom business is conducted on behalf of the County. Officers and employees shall, at all times, comply with the State of Oregon Government Standards and Practices code of ethics set forth in ORS 244. PERFORMANCE EVALUATION: The performance of the County's portfolio shall be measured against the performance of the Oregon Local Government Investment pool, and the three-month and twelve-month Treasury Bills. ACCOUNTING METHOD: Deschutes County shall comply with all required legal provisions and Generally Accepted Accounting Principles (GAAP). The accounting principles are those contained in the pronouncements of authoritative bodies including but not necessarily limited to, the American Institute of Certified Public Accountants (AICPA); the Financial Accounting Standards Board (FASB); and the Government Accounting Standards Board (GASB). An investment fee of 5% of the total interest earned on all invested funds will be deducted and credited to the County Finance Internal Service Fund each month. After deducting the investment fee, interest earnings will be credited on a last day of each month to the funds from which the investment was made based on the average daily balance in the fund. INTERNAL CONTROLS The investment officer is responsible for establishing and maintaining an adequate internal structure designed to reasonably protect the assets of the County from loss, theft or misuse. The concept of reasonable assurance recognizes that (1) the cost of a control should not exceed the benefits likely to be derived and (2) the valuation of costs and benefits requires estimates and judgments by management. Accordingly, the investment officer shall establish a process for an annual independent review by an external auditor to assure compliance with policies and procedures. The internal controls shall address the following points: Policy #F-10, Investment Policy Guidelines Page 5 of 7 - Control of collusion. - Separation of transaction authority from accounting and record keeping. - Custodial safekeeping - Avoidance of physical delivery of securities whenever possible and address control requirements for physical delivery where necessary. - Clear delegation of authority to subordinate staff members. - Written confirmation of transactions for investments and wire transfers. - Compliance and oversight with investment parameters including diversification and maximum maturities. REPORTING REQUIREMENTS: The Deschutes County Treasurer will provide a monthly report to the County Commissioners and the County Administrator. This report will include but not necessarily be limited to: portfolio activity, individual securities held at the end of the reporting period, average weighted yield to maturity of portfolio on investments as compared to applicable benchmarks, and investments by maturity date. Additionally, in accordance with Generally Accepted Accounting Principles, investments are reported in the County's Comprehensive Annual Financial Report at market value. REVIEW: This policy shall be reviewed and modified, if appropriate, by the Deschutes County Board of Commissioners or if market changes warrant review. Annual readoption by the reviewing authority is required by ORS 294.135a. In addition an Investment Committee consisting of five members will meet and review any changes to this Policy. This committee will consist of one County Commissioner and four additional members with backgrounds such as a Banker, Security Broker, Controller/Chief Financial Officer, or Government Finance Manager. AUTHORIZED FINANCIAL INSTITUTIONS: BANKS Bank of America Bank of the Cascades Chase Bank Columbia State Bank Home Federal Bank Key Bank Policy #F -l0, Investment Policy Guidelines Page 6 of 7 OTHER Premier West Bank Sterling Savings Bank South Valley Bank & Trust Umpqua Bank Union Bank US Bank Wells Fargo CastleOak Securities, L.P. Oregon Local Government Investment Pool Piper Jaffray RBC Wealth Management Seattle -Northwest Securities Corporation UBS Financial Services Approved by the Deschutes County Board of Commissioners March 2, 2011. Dave Kanner County Administrator Policy #F-10, Investment Policy Guidelines Page 7 of 7 MEMORANDUM TO: Susan Ross FROM: Teresa Rozicam DATE: February 9, 2011 RE: Request to Release Reversionary Clause The buyer of property at 21700 Neff Rd, Bend, has asked the County to release its reversionary interest in a portion of the property. I recommend that the board consider granting this request. In 1977 Deschutes County conveyed approximately 120 acres to Bend Metro Park & Recreation District ("BMPR"). This land is at the corner of Neff and Hamby Roads, current site of Big Sky Park and other public buildings. The conveyance was granted "with the specific reservation that if this real property ceases to be used for a public use, it shall revert to the grantor." In 1992 BMPR conveyed some of that land to Robert Hartsten in a land exchange. According to the Boundary Survey for Property Line Adjustment, the purpose was to allow each owner to manage their respective properties without crossing the COID Lateral A-9. In exchange for 3.69 acres west of the canal, BMPR gave Hartsten an irregular shaped parcel (0.63 acres) west of the canal along the southern boundary of his property and a 114' strip (3.06 acres) along his northern boundary. See attached map. These two parcels still carry the reversionary clause. Successors to Hartsten filed a Minor Land Partition in 2003 to create 2 parcels. Parcel 1 is for sale; the buyer asks that the County release its interest. Although the 3.69 acres that went to Hartsten (now parts of taxlots 400 and 401) are not being used for public purposes, BMPR incorporated the 3.69 acres they received into the larger tract (now taxlot 200). I believe that Deschutes County can release its interest in portions of taxlots 400 and 401 because there was no loss of acreage in the 1992 land exchange and the land is being used for public purposes. inv 1771 11 / o 2, %a a O M O 0 O N al CN Cr � S 99'9Y9 "' --IN —, a -r 9£6 19'9Y1 / 11 11 /1 /1 11 11 /I ll // // // // II IV I/ n if l/ /1 1/ 71 1/ /1 /f7f/i 6Y'Z6f1 9Z•f6f1 N aC 1,1 0d C0 dl d r.-1,..,, O b M O+ OD,.OO n N M a •O (0 M GLV M• r, NN - ..c.,1". 1.1 �"� M NtnO �;n OM.Y/ M04 •, TNMN 1 L1" ]l i 7 04 0I 9'1'0501 °• o w 0 --s N N 0 0 01 {_I9.Olt 0 0' Of —00' 00 N 00'00Z M /ll u an Z 111 dill 33S DRAFT March 2, 2011 Rick Crager Interim Director Oregon Housing and Community Services 725 Summer Street NE, Suite B Salem, OR 97301-1266 Subject: Neighborhood Stabilization Program 3 Dear Mr. Crager: Deschutes County is very appreciative of the Neighborhood Stabilization Program funding that has been obligated to our region. As you know, we were one of the heaviest impacted areas in Oregon and the Northwest as a result of the housing foreclosure crisis. In partnership with the City of Bend, Oregon Housing and Community Services has helped to make a significant impact in our region. Not only has this program aided in reducing our available empty housing stock, but using local funds, Bend has initiated a program that created over 100 jobs in the construction industry. With more funding they can replicate this program. We strongly encourage continuation of funding programs in the majority of Deschutes County, including the City of Bend. The City of Bend's administration of this program has proven to be a successful model for purchasers, realtors and lenders. Bend is fully staffed and experienced in running this program. We believe the City of Bend is a critical partner and encourage reconsideration for their inclusion in the NSP III program. Target Area 8-1 City of Redmond GO gle maps Deschutes County NE ksol"re E Artttr Ave 313' 3 flr eirwno C:ty Z'ark p.; _refn z 7 4" cro2bini Goo* - Map data 02011 Google - Target Area B-2 City of Redmond Dotal' maps Deschutes County rk A 9wlo 8yod g 4.1 97 136 Redmond C 4 3 Glarer Ava Highland Ave R.au .:nh 1e.ar rff Y M Rd ©2011 Google - Map data 92011 Google - Target Area B-3 City of Redmond GOugle maps Deschutes County 1 'Al A44144 OP` r41 1-^.1 Fll C att SAN RairatkT k444 SVicS'alfrr.nAccc-k SVk aakr.:^ ay() kircti Atte C) Naar Pat P,InAcei LJ)Ici Saarts —04z1c F. di -e•e-y )(Newel. F 8 Spicmwori g City Park • sarnJonnson ety Park Redmcnci SW Glac at Ave CaliPar Rawil4k SWLrJAve Ai Pa k Cav Park BakIx Peck Pelacce 1.0.1,,nr Fcekt F ec1MAri Cry vec,..11441, cc. SW ararccolOs'31 02011 Googlo - Map data 02011 Goods d DjiiQA - Target Area B-4 City of Redmond Google maps Deschutes County emir" lid SW Coyote kit SVI''''vkast Air E:3 Jantr,d- GO CO, ©2011 Google - Map data ©2011 Google - I Target Area B-5 City of La Pine GougL maps Deschutes County Hasten tiff Waltle it di A a Target Area B-6 City of La Pine Go. gk maps Deschutes County Firs Cr ilAs1 trk OSn gongs ce 111 4 i.ners,e04 Cs Dawn Rd SGs.srn ' wrst 41 2 Cid V I Rd .1 T LwA Rd 414nif C( orep q0 Burgess Rri eirciry n a 3 vVritst /444 irmi Av. 9 "-:slykrJ iii Q liangift's H 1 .7 ;." 0 *2011 Googie - Map=iiata 02011 Google - Dear We are writing to offer our strong support for HB2867. This legislation would reauthorize the tremendously successful Deschutes Mitigation and Conservation Program. The program was established over more than a decade in a collaborative process that involves all of the interests in the basin. In just the past few years, the program has: o More than tripled flows in the middle Deschutes River. o Created an opportunity to collaboratively meet new water needs among users in the basin. o Set the stage for cooperative efforts on larger issues, such as the reintroduction of listed species in the basin. This is a successful program that has created a foundation for better environmental and better economic outcomes in our region. Our upper basin is unique in that surface and groundwater combine to support the flow of the lower basin. It solves one of the inherent issues in the existing statute by making the program permanent, thus giving greater certainty to users and allowing for permanent protection river flows and a reduction in unnecessary speculation. This is an important tool as we create a basin plan that supports agriculture, people and the environment. We strongly urge your support for this win-win legislation. Sincerely, "1St.R i SON