The URL can be used to link to this page

2012-1589-Minutes for Meeting April 23,2012 Recorded 5/7/2012DESCHUTES COUNTY OFFICIAL RECORDS rr p NANCY BLANKEN MMISSIONERSSHJOURNALNTY CLERK y~ 10i1•1~89 CO 051011101102; 14;44 PM 111111111111110111111111 2012-is8O Do not remove this page from original document. Deschutes County Clerk Certificate Page L.. -I. 62 o 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 DESCHUTES COUNTY BOARD OF COMMISSIONERS MONDAY, APRIL 23, 2012 Present were Commissioners Anthony DeBone and Alan Unger; Commissioner Tammy Baney was out of the office. Also present were David Inbody, Assistant to the Administrator; Marty Wynne, Finance Department; Hillary Borrud of The Bulletin, and two other citizens. Chair DeBone opened the meeting at 1:30 p.m. 1. Update: Sunriver Area Chamber of Commerce. Dennis Smeage and Robert Bennington of the Sunriver Chamber of Commerce came before the Board and went over a packet of information at this time, including financials. Some of their funding goes towards the Visitors' Center. Other information detailed the number of visitor inquiries and other daily activities. The Visitors' Guide has just been printed as well. Mr. Smeage stated that since he came on board in 2007, they have moved to a smaller, more efficient but more visible space. They utilize one staff person and volunteers during the peak season and holidays. They had about a 33% increase in inquiries over the previous year; they are still down from five or six years ago, but at least are going in the right direction. Sunriver Magazine goes out to 30,000 people, and it is meant to cover the region, and Oregon as a whole, capturing people at the border or before they come to Oregon. The magazines are placed in hotel rooms, major airports and visitor centers statewide. Mr. Bennington explained that they have been working on a special project that is now coming to fruition. He has been asked to explain the importance of the Sunriver Area Chamber. A survey was sent to all Chamber members to try to gauge what they feel is most important. Response was good and they received ideas on what the members want to see happen. The business community came together and got consensus on a marketing campaign and other aspects. Minutes of Board of Commissioners' Work Session Monday, April 23, 2012 Page 1 of 4 The community had been somewhat divided on this whole issue for a while. He has been involved for several years, and is happy to see some things come into play. Chair DeBone asked how many members they have. He was told it is about 170. When times were good, there were about twice as many. They anticipate getting more local support in the future as businesses do better. One problem has been a lack of direct marketing for the Sunriver area. This is where the Visit Bend and COVA come into play. Sunriver does not get a lot of attention as an entity, however. Commissioner Unger stated they have not discussed this situation much as a Board. Commissioner Baney is on the COVA Board and is involved in trying to get the groups working towards common goals. They want to be sure at least the proper conversations are happening. He said that the questions are how long will the dollars last and where they should be spent. Sunriver representatives should make sure the right questions are being asked from their perspective. Chair DeBone feels that COVA is taking a strong stance. If they are to be the regional representative, they can make a Central Oregon statement. Bend is a big player, as is Sunriver. There are specific entry points into the region: La Pine, Redmond and Sisters, and those need to be considered. Commissioner Unger feels that the COVA Board should address this and solicit information from the other groups. It would be good to know what the breakdown is and who is investing in what. COVA could be a voice for others, but there needs to be equity. Mr. Bennington asked how this affects the Board's decision, continuing funding to Sunriver Chamber as it has been in the past. Chair DeBone feels it is well justified especially since Sunriver is truly in the County. Commissioner Unger does not want to see changes at this time. As discussions happen, changes can be made as justified, but the County needs to let the groups work this out. Mr. Smeage indicated that the Chamber is making use of technology concerning their website, applications and other ways to make it easy for people to access information before arrival and once in the area. Minutes of Board of Commissioners' Work Session Monday, April 23, 2012 Page 2 of 4 2. Finance/Tax Update. Chair DeBone asked Marty Wynne about how transient room tax dollars are collected and tracked. Mr. Wynne stated that there is probably no law involved. There are two funds, the 6% and I% factors. The room taxes are 7% outside the cities, plus a separate State fee. There was an agreement that the Sheriff would get $2,670,000 fixed. There is not enough in the 6% fund for that. Therefore, 80% of the 6% goes to the Sheriff. The rest is made up from the General Fund. As the room tax amount climbs, less comes out of the General Fund. If you come to the point where 80% is more than the fixed amount, the Board needs to make a decision. Mr. Wynne said that the exact amounts are on a need to know basis as proprietary to each resort. Mr. Wynne said there were a lot of changes from the previous report. Regarding investments, the pool is now 60 basis points, an increase from 0.60 to 0.67. There is a projection at year-end of coming in about on target. The line transfers out seem to be the same, but are actually $900,000 more due to transfers to Community Development and other funds due to some departments needing an infusion. Community Development numbers will likely be flat for next year. Risk Management costs have gone up. The RV Park received a transfer as well. The other major transfer was to Administrative Services. 3. Other Items. The Board went into Executive Session, called under ORS 192.660(2)(e), Real Property Negotiations. Being no further discussion, the meeting adjourned at 3:45 p.m. Minutes of Board of Commissioners' Work Session Monday, April 23, 2012 Page 3 of 4 DATED this Day of 2012 for the Deschutes County Board of Commissioners. ATTEST: 614tl~ Recording Secretary Anthony DeBone, Chair ~Z, U-4,~ Alan Unger, Vice Chair Tammy aney, Com issioner Minutes of Board of Commissioners' Work Session Monday, April 23, 2012 Page 4 of 4 Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, APRIL 23, 2012 1. Update: Sunriver Area Chamber of Commerce 2. Finance/Tax Update - Marty Wynne 3. Other Items Executive Session, called under ORS 192.660(2)(e), Real Property Negotiations 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., Bend, unless otherwise indicated. If you have questions regarding a meeting, please call 388-6572. Deschutes County meeting locations are wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY. Please call (541) 388-6571 regarding alternative formats or for further information. MID-YEAR REPORT & 2012-13 FUNDING REQUEST TO DESCHUTES COUNTY BOARD OF COMMISSIONERS April 23, 2012 On July 1, 2011, the Sunriver Area Chamber of Commerce continued receiving funds from Deschutes County to subsidize its visitor center operation. The support for fiscal year 2011-2012 consists of $21,339 from transient lodging tax monies and represents 55% of the total annual cost of operating the Sunriver visitor center. Current Operations Highlights of the visitor center's current operations are as follows: Location - Building #13 in The Village at Sunriver (north end) Hours of operation - > Off season - 8 hours/day, 4 days/week > Peak season (July & August, holiday weeks & weekends) - 6 to 8 hours/day, 7 days/week Staffing - > Off season - paid staff > Peak season - paid staff supplemented by trained volunteers, as follows: • July & August - 14 volunteers at 165 hours • Thanksgiving week - 6 volunteers at 18 hours • Christmas week - 7 volunteers at 21 hours • Spring Break - 4 volunteers at 21 hours Activity during the period July 1, 2010 to March 31, 2011 - > 2,976 visitor inquiries and information packet requests processed as compared to 2,234 during the same period last year (33% increase). > 20,895 copies of 2011-12 Sunriver Magazine distributed during the period July 1, 2011 to March 31, 2012. 30,000 copies of the 2012-2013 edition are currently being distributed statewide, as follows: • 9 State Welcome Centers, including PDX • Redmond Airport • Chambers of Commerce and visitor centers statewide • All commercially rented lodging units in Sunriver • 6,000 Pacific Crest Sports Festival participants • Sunriver area businesses • Digital edition appears on Travel Oregon's web site. > Web site -22,168 visits to our web site during the period, as compared to 22,312 last year. • Digital edition of the Magazine appears on the site. • Implemented a mobile web app, enabling Smartphone users to access the web site's business directory. Community support - > Sunriver Owners Association - Provided logistical support for the annual Sunriver Sunfest Wine Festival at Fort Rock Park. > The Village at Sunriver - Continued to provide the Chamber with office space at a discounted rate. Village management is represented on the Chamber's Board of Directors. > Sunriver Resort - Subsidized the annual Swings for Strings golf tournament which draws participants from around the state. Provided free meeting space for Chamber events. > Specialized Events - Partnered with the Chamber to host the annual Sunriver Sunfest Wine Festival. This event draws thousands of visitors from across the Northwest. Going Forward Sunriver-specific marketing campaign - Six major stakeholders including the Chamber, Sunriver Resort, JA Marketing (Sunriver Country Store & Marketplace), and three vacation rental companies contributed a total of $20,500 to fund a Sunriver-specific billboard advertising campaign in the Portland market. Utilizing the theme "Sunriver. Find Your Adventure," the billboards will advertise Sunriver as a summer vacation destination and will appear in high traffic locations during the months of May and June 2012. Operations in Fiscal Year 2012-2013 The Chamber intends to enhance its visitor center operations and marketing efforts during the next year as follows: Staffing - Recruit and train additional volunteers to to serve as visitor center hosts throughout the year. Information materials - Acquire and/or develop new materials to meet the information needs of visitors. Sunriver Magazine - Increase circulation to 35,000 and expand distribution to additional markets in Washington State. Web site - Continue to review, update and enhance content of the web site. Utilize locally-produced video clips to more effectively market Sunriver as a vacation destination. Community support - Act as a catalyst for the development of additional events to draw visitors to Sunriver. 2 Sunriver-specific marketing campaign - Acquire additional stakeholders to invest in the program and provide the funds necessary to expand the campaign in duration and geographical coverage. The goal is to raise a minimum of $50,000 for the campaign in 2013. The anticipated theme will be "Rediscover Sunriver" and will focus on Sunriver's newest amenities, including the new SHARC. Request for Funding The Sunriver Area Chamber of Commerce respectfully requests that Deschutes County continue its support of our visitor center and marketing efforts at the level of $21,339 for fiscal year 2012-2013. These funds will be used for visitor center staffing and volunteer management. The Sunriver Area Chamber of Commerce wishes to express its deep appreciation to the County Board of Commissioners for helping us continue our services to Sunriver visitors and for supporting our efforts to market Sunriver as a vacation destination. We sincerely thank you for your continued funding of our visitor center operations and we look forward to keeping you informed of our progress in providing this important service. Sincerely, C "I Dennis Smeage Executive Director Sunriver Area Chamber of Commerce Attachments 5:17 PM Sunriver Area Chamber of Commerce 04/20/12 Accrual Basis Visitor Center Revenue and Expense July 1, 2011 through June 30, 2012 (projected) Visitor Center Visitor Center All Chamber Chamber Funding County Funding Annual Income 400000 • Publications Advertising 0.00 0.00 2,400.00 405000 - Web Advertising 0.00 0.00 6,390.00 410000 • Visitor Center Advertising 0.00 0.00 2,400.00 415000 - Affinity Rebates 0.00 0.00 1,056.00 425000- Contributions & Gifts 1,740.00 440000 • Service Fees 0.00 0.00 36.00 445000 - Grants & Contracts 0.00 21,339.00 26,339.00 450000 - Interest Income 0.00 0.00 48.00 466000. Membership Dues 0.00 0.00 26,005.00 465000 • Miscellaneous Income 0.00 0.00 750.00 470000 - Raffle Sales 555.00 477000 - Special Event Sponsorships 0.00 0.00 1,600.00 490000 • Special Event Ticket Sales 0.00 0.00 10,225.00 Total Income 0.00 21,339.00 79,544.00 Gross Profit 0.00 21,339.00 79,544.00 Expense 600000 • Advertising Expense 134.00 0.00 6,223.00 602000 - Bank Fees 0.00 0.00 586.00 604000 - Dues and Subscriptions 114.00 0.00 329.00 608000 • Equipment Rental & Maintenance 2,600.00 0.00 3,020.24 610000 - Food & Beverage 0.00 0.00 5,500.00 612000 - Grants to Other Organizations 2,425.00 614100 - Insurance - Dir & Off 0.00 0.00 744.00 614200 - Insurance - General Liability 885.60 0.00 1,107.00 614300 • Insurance - Workers Comp 0.00 0.00 245.00 618000 - Postage & Shipping 360.00 0.00 775.00 620000 - Printing & Copying 972.72 0.00 1,676.00 622100 - Professional Fees -Accounting 0.00 0.00 1,759.00 624000 - Publications 1,150.00 626000 - Rent 6,959.48 0.00 8,784.00 626100 - Utilities 924.75 0.00 1,047.00 628100 • Services - Compu Prog & Maint 0.00 0.00 200.00 628400 • Services - Website Development 0.00 0.00 1,995.00 628500 - Services - Website Hosting 996.93 0.00 1,788.00 632100 • Supplies - Office 195.00 0.00 880.00 634000 • Telephone & Telecommunications 1,623.73 0.00 1,956.00 638100 - Payroll Expenses - Empl Benef 0.00 0.00 1,920.00 638200 - Payroll Expen - Salaries 0.00 19,155.00 28,800.00 638300 • Payroll Expenses - Payroll Tax 198.19 2,184.00 3,741.76 638400 • Payroll Expenses - Hourly 1,710.00 0.00 1,740.00 Total Expense 17,674.41 21,339.00 78,391.00 Net Income -17,674.41 0.00 1,153.00 Page 1 of 1 5:17 PM Sunriver Area Chamber of Commerce 04/20/12 Accrual Basis Visitor Center Revenue and Expense July 1, 2011 through March 31, 2012 Visitor Center Visitor Center All Chamber Chamber Funding County Funding YTD Income 400000 - Publications Advertising 0.00 0.00 1,600.00 405000 • Web Advertising 0.00 0.00 3,465.00 410000 - Visitor Center Advertising 0.00 0.00 1,800.00 415000 - Affinity Rebates 0.00 0.00 885.06 440000 • Service Fees 0.00 0.00 30.00 445000 • Grants & Contracts 0.00 16,004.25 16,004.25 450000• Interest Income 0.00 0.00 18.76 455000. Membership Dues 0.00 0.00 25,507.50 465000 • Miscellaneous Income 0.00 0.00 11,235.00 477000 - Special Event Sponsorships 0.00 0.00 2,700.00 490000 - Special Event Ticket Sales 0.00 0.00 125.00 Total Income 0.00 16,004.25 63,370.57 Gross Profit 0.00 16,004.25 63,370.57 Expense 600000 • Advertising Expense 134.00 0.00 268.00 602000 - Bank Fees 0.00 0.00 486.11 604000 - Dues and Subscriptions 114.00 0.00 164.00 608000 - Equipment Rental & Maintenance 1,847.60 0.00 2,757.64 610000 - Food & Beverage 0.00 0.00 1,880.96 614100 • Insurance - Dir & Off 0.00 0.00 744.00 614200 - Insurance - General Liability 885.60 0.00 1,107.00 614300 • Insurance - Workers Comp 0.00 0.00 242.35 618000 • Postage & Shipping 255.64 0.00 569.08 620000 • Printing & Copying 702.02 0.00 1,468.49 622100 - Professional Fees -Accounting 0.00 0.00 1,494.50 626000- Rent 5,022.72 0.00 6,278.40 626100 • Utilities 667.40 0.00 828.03 628100 • Services - Compu Prog & Maint 0.00 0.00 180.00 628400 • Services - Website Development 0.00 0.00 1,093.62 628500 - Services - Website Hosting 679.44 0.00 1,341.00 632100 - Supplies - Office 127.98 0.00 914.14 634000 • Telephone & Telecommunications 1,171.86 0.00 1,464.81 638100 - Payroll Expenses - Empl Benef 0.00 0.00 1,440.00 638200 • Payroll Expen - Salaries 0.00 14,366.25 22,800.00 638300 - Payroll Expenses - Payroll Tax 198.19 1,638.00 2,992.10 638400 - Payroll Expenses - Hourly 1,710.00 0.00 1,710.00 Total Expense 13,516.45 16,004.25 52,224.23 Net Income -13,516.45 0.00 11,146.34 Page 1 of 1 N ei O N M t v L m t W V O CC L. W t L ~ O N V LA. O >W co L G N _V V ~ co a y W L cr- a GC y W V L oc o Z H ~ 1~ ~ N O N ~ M O I, , N ~ O O~i N N (>rf n~ N N Ln to I~ Ln "I N ci N ri ri ri ~ O r4 M lD LD N N N Ol N ri N N 00 ri r-1 ri %--I d r-I ko 1n r-I Ln Ln r-l V--1 1" 00 0) r- O Ln N N N rri 1~ N N lJ ) ri oo w 00 T-1 M M L!1 1 n N N N, l N N O M rNi Qr~ 1 00 N M ri N d' M r~i V ° 0 Ln 0) rq 0) r-4 00 1 O Q t.0 LLn 00 N ri m 1 LL 1 LL! M ~ C3 li lD N ri M tD r-I N 00 Ln men I~ m L00n i U 03 'a r v O M 00 ri a-4 0) Ln N Ln N r-I M l0 Ln Ql lMD N C r~ M cn H " N ri 1-1 Ln Ln ^ N ri p O1 N Q1 l~D^ LA M r•I M N N M 0 L--tt ri 00 M N V-4 00 Ln I* 1 ) N Ln ~ W H ~ W - - ~ H LA M W W ' C m oC (1) 4- r_ N C O W Ix d 2: LLI cc F: H . 41 N m O Q Ln +1 m O LA 4- 4- Q n a Q N W F~ d Y W oC iY Y V in F N J Q L O O c0 i -70 Q) a o o o o L D_ v m 0 Z a _ H > W H° 0 0 p 0 ° u a W 0 0 o O O c z Q c N O o, o O> a o J J Q W F- H _-c c c c c Y Y J f OC Q O 4- Q U L O O O ~ Q H O C C C C Y Y C N m cC t0 O O O O cu co ro m E E E E O u N H H 0 0 w h" o W 3 LL. Z t ? D_ D_ D_ d w w w w I- > 0 0 I- f- THE SUNRIVER AREA CHAMBER OF COMMERCE IS GOING MOBILEI Announcing the launch of our Chamber's new MOBILE WEB APP! We've invested in the NEWEST technology to put YOUR business in front of the rapidly growing number of Smartphone and mobile Internet users WORLDWIDE! • 1 IN 2 AMERICANS OWN A SMARTPHONE & THE NUMBER IS CLIMBING RAPIDLY! • BY NEXT YEAR, THERE WILL BE MORE SMARTPHONES IN USE IN THE U.S. THAN ANY OTHER TYPE! • BY 2015, 2.7 BILLION PEOPLE WILL BE USING MOBILE DEVICES TO ACCESS THE INTERNET! How do people find your business on the Internet? It's easy with our new CHAMBER MOB/LEWEBAPP. They simply download the app FREE from our Chamber web site and then "click" they're into our on line business directory to view your custom listing, download your discount coupons and promotions, and browse local events. All on their Smartphones! With our MOB/LEWEBAPP, locals and visitors alike will find your business, get a detailed map & driving directions, read about your products and services, view photos and videos, and contact you - all from the convenience of their Smartphones! REMEMBER, SMARTPHONE USERS DOWNLOAD OUR MOB/LEWEBAPP FOR FREE! What's your cost for this exciting new marketing tool? ABSOLUTELY NOTHING! It's part of your membership in the Sunriver Area Chamber of Commerce. The Sunriver Area Chamber's new MOBILE WEBAPP launches on February 1st, 2012. And there's nothing for you to do to immediately reap the benefits of this NEWEST technology. Just sit back, relax, and serve all those new customers coming into your door! Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA April 23, 2012 (1) Monthly Investment Report (2) March 2012 Financials (3) Quarterly Reports M p M CA to M M ~ ~ E r t 0 t D C } N C d 69, 69 > E O M r = N ti M ~ (p tD t0 !Sf 64 fi? M M O O Lo O_ N O L to 0 h h 04 04 O 0 3 ~ E Z U. 0 0 > c O N O V = e VVU) C m ~ N Qj d d E LL N = E 1 ii (n to 4 U) (D > 0 J = NJ d > _ C7 0 e° e e° e° O O ~ t0 O ~ O ~ O O N O O~ ~ C~rzC; C~ O r M ~ M ~ M M ~ Co Lo 0 O N 1- r to N ti co t. r r W N If- ell 140 y U fl-~yu~a)f6 c f6 -0 N 'V a d ~ p (C C U m Q 0 E o U ~ (D m = E CL (D D c a 0 0 .E a> m C~ O UU1-7LL mJ H 0 O = to 2 f6 CU C N e e e e e e e O O O O r r to O w O O h N N N V- E v 7 E to C= Q O. M AR (D X a a o v 2 a> _ ~6 Z Q ° r ` w 0 ~ Co F- U J E O O LL m 1- U U N d Ua aOi aci v a+ ~ E N N E o > ~ ~ C ~ U m N O LOU o\o - o 0 Z U v U F O m , 0. d co J O H U w U U U U N U U U V U T o ^ e e o e e O 0 U U U U U U U U U U U N Q .Q r r C O t0 O O O 2 Z Z Z Z Z Z Z Z Z Z Z Z Z Z V Z Z Z Z Z Z Z Co > o o ° is o c) o n o Z v rr " E r m ~ a+ O (D V' O) n CO n 10 ~t V CO M 00 (D O n O n C0 M M 0) CO n co Cl) U~ 0) 0 n 0 V) M CO V V N N V V M M r r Cl O 0 O 0 O o 0 CO O LO 00 r O rn N v O LO O Cl) O? r O O Q C O v M CO C) O) V' V 0O V W co O O CO N O) M 0 W 0 N 0 M 0 O CO CO N N 0 M W M n n o V 0 M Co 0 m 0 O 0 O O D U') N O CO O C» M co Cl) M Cc) M co CA O N M m n C0 N n V O M N r N O oc N Lq n cc v_ cc N M r O c O V C a N O q V N N r 0 o 7 3 N ' V 't V N N co N n M N O CO n o v m 0 N '7 O M CO N co CO Lo O CO N CO O N N C0 O N N CO V I n 00 C - M CO CO CO V CO N CO t r U) N O N C C O O O r r N O r r r 0 0 r N O O N r 0 0 0 M CO C O mC) O N r r b > N N r N N N N N N N N r N N N N N N N M co r- 0) N N O) n co N C r 0 0 n O o O o o m O o o o n 0 0 O O v CO 0 o 0 0 0 0 CC) 00 CO co m O O CO O O O O O M O O O O r CO O O O V n CO O O O O O N O O r 0 O V 0 0 0 0 0 0 0 0 0 0 r 0 O N O O N CO O CO O O O n 00 t, mo O W M N O) w w O M N CO V W m 0 N V co O O v O O 00 M O O O V CO CO r M M r M V r O) c l! OO O 0 V: N O M V N cc O V: V M N CO y,• N V M 0o CO M o n O M V O O O m O N O N M O 00 O O N V n It m V O V O O o 0 0 V 0 M n V' 0 0 0 0 0 O N V' m O O P, ' OD P~ ` N O N O O O O O r O 0 0 0 r r 0 W r N O O r r 0 O O CO Cl ) CO CO Co N N r N N N N N N N N r N N N N r N N M 00 co O N N 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 O W r O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 O O 0 0 0 0 0 O 0 O 0 O 0 CO r co 0 CO 0 r r N p o 0 0 0 0 0 0 0 0 0 0 4 0 0 o O v o 0 . 0 0 0 0 0 0' o M 00 00 U O O v N O O O O O V co M 0 O 0 O 0 O 0 V 00 CO CO r v M 0 O 0 O w N 0 n 0 0 0 0 0 0 0 0 0 It 0 O 0 O 0 CO 0 O O O O O N N ' m C C V V N o V o O Cn O v o O o O V ui O M 10 n 6) o V' CT 0 v 0 n 0 v N o 0 o 0 CT 0 co CO e V CD O rn O o O 0 It n 1- co M N N O N O O O O C r r r O O r r 0 00 r N O O r r C CA C CO CO CO C N N r N N N N N N N N r N N N N N r N Cl) co r- 0) N aUj O A) a G) a y 0 0 0 0 \o 0 0 0 0 \o 0 \o 0 \ 0 0 e e 0 0 0 O 0 O 0 C O c O 0 M 0 O o V' \ e 0 e 0 o Of • {p • z O O a C ~ " F- •p q 0 CO 0 n 0 O O CO co N M 0 O It 0 O 0 LO 0 O 0 O 0 0 O 0 m0 0 co CO N 0 CO 0) CO O 0 0 0 . 0 n 0 N O to O N w ` 'a N N m C 0) n CO r n CO CO CO (0 00 O o N O CC) CO n n r M CO CO r V D to V Cn n CO O CO £ O U y a N ~ } O O r 0 0 0 0 0 0 r r 0 0 0 0 r r 0 0 r C 0 0 0 O O 0 0 E o O H O ' y C d O O E u) O 0 J F • U U F D Li o 0 0 R 0 0 0 0 0 0 0 0 0 0 0 0 o 0 C 0 o 0 o C 0 0 0 0 0 0 0 C O d to n O O CO N C. O O Cn O U) O O O CO O ,q O CO O O O O O LO V O O G ~ M O to O n N W V Co m0 m0 n U0 O b y O N O r CO N CO ~ C. co CO M O O C U d a+ C) ' E O a o c N p v ~ ` O M to C N C d d r•+ C~ ♦a M C O O eo C o o 00 M 00 n 00 O N (O n a M W n 0 0 b u) Q D t6 ~ v CO CO CO n CO V CO CO O CO n CO f0 M n CA 0 N n N co O V n n a~ C' n N CO n n 0 co M n M n M n M n N 'a N C N N N N N N N N N N N M M M M Cl! M M M M M m co M v V' j O O r W O O M O ;37 _ M \ M M M _ O v CO O _ \ tC) t~ v h C r 10 O O O r r r N O r O r O r M CM O r O N N 0 0 O N r N 0 ~ C ~ E R CO CO Ll. Ll. L- co co M M O C D 1 v It LO M C0 n CO N N CO M > +i O 0 0 0 o 0 o o 0 o r r o o o O C) o 0 0 0 0 0 r r 0 O 'Q F~- o 0 N 0 0 O r r 0 0 0 r r N r r N N_ L w r- M _ co O r M \ M 00 Oo \ O CV 00 r O W CO i0 1~ r 2 C 0 N 0 N 0 N \ r N N M O N O M r M O N O N V O N M M M z• Cd N V N r N CO N M O N O O N N N r M N M p IL r O O O O O O r r O r O O O o r O O O r r o O Q m U m Q V X V LL x m Y 7 a a m m z w > w H m d ~ LL ~ Q m a. t) Z t) Q LL p H F ad (1 m LL O o U U U U m a : U c F o U ~ LL I-- LL LL F u LL LL LL IlDp9 D U) D Z D U C U p U) Z) tZ co CL l (n U) _ = U U c U U) CD 04 w } O (0 Y x r U tot ~ Q x v U ' C1 D S O Z X n N N N ~ CL Ce) M ~ M to ~ 0) rj M 7 M M M M C'7 C. j M M 0)) co M o ) N n ) 0) N M co M N V O ) M O O U U ) U U D V U Z V U N ~ N : y C0 C Y t m C O O O p U 1 O O U N ( Up . m N U y N O N N N U - Y CL B CL . a Y C U Y C .O /4 Y C N N U w m m 7 O C4 m 0 C y a .0.• U N N V Y 0 Y C O U l4 f0 f0 . Y C C C6 "O C f0 D O C co O U U O 14 X !A T N > C o) C6 O Z C O V C N (D U U U C6 C U U U C6 m 3 Y C m U m Q w N N y Y W k C Z cc fn m 0 Q w Q r 7 N D m co LL U v ` m LL Z N y O U w - O a LL C O m 0 > m> m 1 (D m6 O CO C C N C l4 C N O U O U N U N O CD O U T O , C CU C CO O f0 U) y C y C (D m E O O E m > . N E o U m .L... O c a y Y C E E O N N F d E co m m m m 'O LL ~ W - W - W - -0 ~ X w m0 > - j O ~ m m m ~ p to m O m CO U 0 U 0 = 0 Y p a •C a m w w cn o cn 0 in E D 0 ~ m m 0 U 0 U 0 LL E p N ~ ca ~ U C m mL m ; - Q N O c LL Z d m _ E Co CO (D 4) ° c c c E U > U ti m m W e H C E _ E = LL = E E 0 - 0 0 ' 0 0 E 0 0 LL OO O .O. E O O Z = = ( 9 W m ~ U- a ~ LL LL LL D M: U C7 C7 = 0 LL a. 5. f/) 0) D U- .U- U- J co H Memorandum Date: April 16, 2012 To: Board of County Commissioners Erik Kropp, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find March 2012 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 GENERALFUND Statement of Financial Operating Data Nine Months Ended March 31, 2012 f Year to Date Revised Year End $ L Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 7,300,000 $ 8,245,725 $ 945,725 100% 113% $7,300,000 $8,245,725 $ 945,725 Revenues Property Taxes 15,075,725 19,885,864 4,810,139 75% 99% 20,100,967 20,828,228 727,261 Gen. Rev. - excl. Taxes 1,786,741 2,126,577 339,836 75% 89% a) 2,382,321 2,382,321 - Assessor 593,247 616,220 22,973 75% 78% b) 790,996 790,996 - County Clerk 1,101,530 1,062,414 (39,116) 75% 72% 1,468,707 1,412,207 (56,500) BOPTA 9,299 11,773 2,474 75% 95% b) 12,398 12,398 - District Attorney 224,002 186,825 (37,177) 75% 63% c) 298,669 325,676 27,007 Finance/Tax 145,425 167,801 22,376 75% 87% b) 193,900 193,900 - Veterans 46,006 35,012 (10,994) 75% 57% 61,341 64,351 3,010 Property Management 72,150 72,650 500 75% 76% 96,200 96,200 - Grant Projects 1,500 1,500 0 75% 75% 2,000 2,000 - Total Revenues 19,055,625 24,166,635 5,111,010 75% 95% 25,407,499 26,108,277 700,778 TOTAL RESOURCES 26,355,625 32,412,360 6,056,735 75% 99% 32,707,499 34,354,002 1,646,503 REQUIREMENTS: Exp. Expenditures Assessor 2,553,975 2,436,255 117,720 75% 72% 3,405,300 3,283,300 122,000 County Clerk 1,067,974 776,761 291,213 75% 55% 1,423,965 1,183,965 240,000 BOPTA 54,302 43,199 11,103 75% 60% 72,402 72,402 - District Attorney 3,659,472 3,357,865 301,607 75% 69% 4,879,296 4,511,771 367,525 Finance/Tax 610,236 575,462 34,774 75% 71% 813,648 799,648 14,000 Veterans 196,586 189,480 7,106 75% 72% 262,115 260,100 2,015 Property Management 193,248 193,105 143 75% 75% 257,664 257,664 - Grant Projects 89,036 86,372 2,664 75% 73% 118,715 118,715 - Non-Departmental 1,362,722 738,802 623,920 75% 41% d) 1,816,962 1,696,962 120,000 Contingency 4,323,094 4,323,094 75% n/a e) 5,764,125 - 5,764,125 14,110,645 8,397,301 5,713,344 75% 45% 18,814,192 12,184,527 6,629,665 Transfers Out 10,393,958 9,721,632 672,326 75% 70% 13,858,610 13,858,610 - TOTAL REQUIREMENTS 24,504,603 18,118,933 6,385,670 75% 55% 32,672,802 26,043,137 6,629,665 NET (Resources - Requirements) 1,851,023 14,293,427 129442,405 e) 34,697 8,310,865 8,276,168 Beginning Net Working Cap ital per Propos ed Budget 8,300,000 a) Includes annual payments: Tax on Electric Co-ops $489,027, PILT $471,823 b) A & T Grant received quarterly-July, October, January & April c) DA revenue includes: $155,069 HIDTA Grant to be received later in fiscal year and $122,400 Discovery Fee received monthly (YTD actual includes three months of receipts) d) Budget includes $576,144 for payment to LED #2. This payment normally made annually in June and is projected to be $110,000 less than budgeted. e) Appropriation (authority to spend) transferred to Fund 165 $34,697. Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065-Court Assess. Discovery Fee Food Subsidy OYA Basic & Diversion Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous Program Fees MIP Diversion Fees Interest on Investments Leases Grants - Private Behavioral Health CFC Interfund Grant Gen Fund Grant-Crime Prev Total Revenues Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $1,101,374 $ 1,099,010 $ (2,364) 100% 100% $1,101,374 $1,099,010 $ (2,364) 7,500 4,267 (3,233) 75% 43% a) 10,000 10,000 - 37,500 36,803 (697) 75% 74% 50,000 50,000 - 11,250 9,880 (1,370) 75% 66% 15,000 15,000 - 18,750 16,312 (2,438) 75% 65% 25,000 25,000 - 163,124 181,704 18,580 75% 84% b) 217,498 355,730 138,232 66,368 46,150 (20,218) 75% 52% c) 88,490 60,000, (28,490) 75 220 145 75% 220% 100 250 150 52,500 72,334 19,834 75% 103% d) 70,000 100,000 30,000 45 301 256 75% 502% e) 60 400 340 30 - (30) 75% 0% 40 40 - 225 970 745 75% 323% e) 300 1,200 900 5,625 6,207 582 75% 83% 7,500 8,400 900 1,800 1,000 (800) 75% 42% f) 2,400 1,200 (1,200) 375 788 413 75% 158% 500 850 350 4,500 1,660 (2,840) 75% 28% g) 6,000 2,200 (3,800) 115,596 71,434 (44,162) 75% 46% h)i) 154,128 134,620 (19,508) 15,000 10,000 (5,000) 75% 50% i) 20,000 20,000 - 500,263 460,030 (40,233) 75% 69% 667,016 784,890 117,874 Transfers In-General Fund 3,991,095 3,991,095 - 75% 75% 5,321,459 5,321,459 - TOTAL RESOURCES 5,592,732 5,550,135 (42,597) 75% 78% 7,089,849 7,205,359 115,510 REQUIREMENTS: Expenditures Community Justice-Juvenile Personal Services Materials and Services Capital Outlay Transfers Out Contingency C.xp. 3,831,802 3,687,485 144,317 75% 72% j) 5,109,069 4,958,044 151,025 914,800 834,682 80,118 75% 68% b)h) 1,219,733 1,139,800 79,933 30,075 - 30,075 75% 0% 40,100 40,100 - 37,800 37,800 - 75% 75% 50,400 50,400 - 502,910 - 502,910 75% n/a 670,547 - 670,547 TOTAL REQUIREMENTS 5,317,387 4,559,967 757,420 75% 64% 7,089,849 6,188,344 901,505 NET (Resources - Requirements) 275,345 990,168 714,823 - 1,017,015 1,017,015 Beginning Net Working Capital per Proposed Budget 1,010,415 a) Federal Grant billing, reimbursed quarterly in arrears--$2,665 outstanding b) OYA Basic and Diversion funding increased after budget was submitted. Projections for revenue and expenditures adjusted accordingly. Payments received quarterly--$85,278 billing submitted c) Fees paid for housing for youth from other jurisdictions, need fluctuates and trending lower than anticipated Billings outstanding - $9,000 d) Contract payments reimbursement requests submitted monthly. Received 1-2 months in arrears, trending higher than anticipated e) Revenues trending greater than anticipated - dependent on use of programs or services (MIP Diversion Fees, photocopies, etc) f) Citizen Review Board vacated. Revenue projected adjusted accordingly g) Due to change in practice, Behavioral Health's referrals for functional family therapy have decreased h) CFC (JCP) funding less than anticipated. Projections of revenue and expenditures adjusted accordingly i) Grants paid quarterly-$5,000 outstanding payment for General Fund Grant-Crime Prevention Page 2 j) Actual for the year projected to be less than budgeted due to vacant positions SHERIFF - Fund 255 Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital $ - $ - $ - Revenues Law Enf Dist Countywide 16,563,616 13,490,234 (3,073,382) Total Revenues 27,400,137 22,134,532 (5,265,605) 100% n/a $ - $ - $ 75% 61% * 22,084,821 18,799,678 (3,285,143) 75% 60% 75% 61% 36,533,516 30,641,554 (5,891,962) TOTAL RESOURCES 27,400,137 22,134,532 (5,265,605) 75% 61% 36,533,516 30,641,554 (5,891,962) REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Sheriffs Division 1,937,956 1,872,694 65,262 75% 72% a) 2,583,941 2,552,941 31,000 Civil 618,071 558,536 59,535 75% 68% b) 824,095 748,995 75,100 Automotive/Communications 1,216,655 1,184,433 32,222 75% 73% c) 1,622,207 1,693,107 (70,900) Investigations/Evidence 1,300,664 1,086,008 214,656 75% 63% b) 1,734,218 1,520,664 213,554 Patrol/Civil/Comm Supp 6,003,528 5,877,266 126,262 75% 73% d) 8,004,704 7,862,704 142,000 Records 540,533 472,913 67,620 75% 66% 720,710 694,610 26,100 Adult Jail 7,879,895 7,005,719 874,176 75% 67% e) 10,506,527 9,802,527 704,000 Court Security 214,952 208,468 6,484 75% 73% 286,602 275,402 11,200 Emergency Services 139,219 128,929 10,290 75% 69% 185,625 175,525 10,100 Special Services Division 1,001,371 822,423 178,948 75% 62% 1,335,161 1,307,161 28,000 Regional Work Center 2,263,850 2,118,337 145,513 75% 70% b) 3,018,466 2,835,366 183,100 Training Division 243,199 186,600 56,599 75% 58% 324,265 285,165 39,100 Other Law Enforcement Svcs 474,192 457,283 16,909 75% 72% 632,256 614,156 18,100 Non-Departmental 54,923 54,923 (0) 75% 75% 73,231 73,231 - Contingency 3,361,131 - 3,361,131 75% n/a 4,481,508 - 4,481,508 Transfers Out - D/S Fund 150,000 100,000 50,000 75% 50% f) 200,000 200,000 - TOTAL REQUIREMENTS 27,400,139 22,134,532 5,265,607 75% 61% 36,533,516 30,641,554 5,891,962 NET (Resources - Requirements) - - - - - * Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures a) Less than planned software maintenance expenditures b) Less than planned personnel expenditures due to open positions which may not be filled c) Fuel expenses will exceed amount budgeted. Appropriation transfer is pending. d) Less than budgeted personnel expenditures due to open positions. Partially offset by unbudgeted purchase of mobile data terminals e) Less than budgeted expenditures due to open positions, jail bed rental expenses, and jail management software costs f) Semi-annual transfer in November and May I Year to Date Revised Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $6,108,671 $ 6,090,734 $ 982,063 100% 119% $ 5,108,671 $6,090,734 $ 982,063 Tax Revenues - Current 10,730,131 14,169,706 3,439,575 75% s9% 14,306,841 14,711,329 404,488 Tax Revenues - Prior 375,750 597,439 221,689 75% 119% 501,000 600,917 99,917 Federal Grants & Reimb 26,400 30,784 4,384 75% &7% 35,200 35,200 - State Grant 36,356 37,701 1,345 75% 78% 48,475 48,475 - Transp. of State Wards 3,750 6,304 2,554 75% 126% 5,000 7,000 2,000 SB 1145 1,153,247 1,109,994 (43,253) 75% 72% a) 1,537,663 1,479,991 (57,672) Prisoner Housing - 77,809 77,809 75% n/a b) - 78,087 78,087 Des. Cty Video Lottery Grant 3,750 5,000 1,250 75% 1C0% 5,000 5,000 - Des Cty Court Security 68,250 67,304 (946) 75% 74% 91,000 91,000 - Des Cty Juvenile Contract 3,135 3,224 89 75% 77% 4,180 4,180 - Title 111 Reimbursement 112,500 40,358 (72,142) 75% 27% c) 150,000 150,000 - Transport 750 465 (285) 75% 46% 1,000 1,000 - Other - 3,570 3,570 75% n/a - 3,570 3,570 DC Fair & Expo Center 2,869 - (2,869) 75% 0% 3,825 3,825 - Inmate Commissary Fees 4,950 10,905 5,955 75% 165% 6,600 14,000 7,400 Work Center Work Crews 37,500 30,360 (7,140) 75% E1% 50,000 50,000 - Concealed Handgun Classes 2,625 3,225 600 75% S2% 3,500 3,500 - Inmate Telephone Fee 36,000 69,069 33,069 75% 144% d) 48,000 84,000 36,000 Soc Sec Incentive-Fed 3,750 7,200 3,450 75% 144% 5,000 9,000 4,000 Miscellaneous 3,750 6,854 3,104 75% 127% 5,000 7,000 2,000 Oregon Mentors 11,250 6,039 (5,211) 75% 40% 15,000 15,000 - Debit Card Fee - 158 158 75% n/a - 200 200 Medical Services Reimb 12,000 9,197 (2,803) 75% 57% 16,000 16,000 - Restitution 3,750 1,747 (2,003) 75% 25% 5,000 5,000 - Sheriff Fees 150,000 170,154 20,154 75% E5% 200,000 200,000 - Interest 21,250 37,357 16,107 75% 122% 28,333 42,000 13,667 Interest on Unsegregated 2,650 1,253 (1,397) 75% 85% 3,533 3,533 - Donations - "Shop with a Cop" - 12,022 12,022 75% n/a e) - 12,022 12,022 Donations - 250 250 75% n/a - 250 250 Sale of Reportable Assets 750 7,449 6,699 75% n/a 1,000 7,500 6,500 Total Revenues 12,807,113 16,522,896 3,715,783 75% S7% 17,076,150 17,688,579 612,429 TOTAL RESOURCES 17,915,784 22,613,630 4,697,846 75% 102% 22,184,821 23,779,313 1,594,492 REQUIREMENTS: Exp. Fund 255 Departments: Sheriffs Services 1,817,783 1,756,568 61,215 75% 7.2% 2,423,711 2,394,633 29,078 Civil 618,071 558,536 59,535 75% 63% 824,095 748,995 75,100 Auto/Comm 455,260 443,203 12,057 75% 73% 607,014 633,544 (26,530) Adult Jail 7,879,895 7,005,719 874,176 75% 67% ' 10,506,527 9,802,527 704,000 Court Security 214,952 208,468 6,484 75% 73% 286,602 275,402 11,200 Emergency Services 139,219 128,929 10,290 75% 63% 185,625 175,525 10,100 Special Services 696,163 571,757 124,406 75% 62% 928,217 908,751 19,466 Work Center 2,263,850 2,118,337 145,513 75% 73% 3,018,466 2,835,366 183,100 Training 148,470 113,918 34,553 75% 55% 197,961 174,090 23,870 Other (CODE, Forensic) 474,192 457,283 16,909 75% 72% 632,256 614,156 18,100 Non Dept - ISF Charges 27,517 27,517 (0) 75% 75% 36,689 36,689 - Non Dept - Jamison D/S 150,000 100,000 50,000 75% 53% 200,000 200,000 - Contingency 1,678,244 - 1,678,244 75% 3% 2,237,659 - 2,237,659 Total to Fund 255 16,563,616 13,490,234 3,073,382 22,084,821 18,799,678 3,285,143 Transfer to Reserve Fund (703) 75,000 100,000 (25,000) 75% 103% 100,000 100,000 - Total Requirements 16,638,616 13,590,234 3,048,381 75% 61% 22,184,821 18,899,678 3,285,143 Net 1,277,168 9,023,396 7,746,228 - 4,879,635 4,879,635 Beginning Net Working Capita l per Proposed Budget 4,507,352 " Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services. a) Reduction in State Community Corrections funding for custody of SB 1145 inmates b) Prisoner housing reimbursement SB 395 c) Reimbursement requested semiannually in January and June Page 4 d) Change to new vendor resulting in revenue increase e) Accounting change for Shop with a Cop donations Fund 702 LED Rural Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End T I I Budget Actual Variance FY % Coll. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $2,936,523 $3,004,533 $ 68,010 100% 102% $2,936,523 $3,004,533 $ 68,010 Revenues Tax Revenues - Current 5,511,094 7,151,033 1,639,939 75% 97% 7,348,125 7,426,095 77,970 Tax Revenues - Prior 192,750 297,833 105,083 75% 116% 257,000 312,953 55,953 Federal Grants & Reimb 9,000 11,377 2,377 75% 95% 12,000 12,000 - Federal Grants-BLM 18,750 17,285 (1,465) 75% n/a 25,000 25,000 - US Forest Service 59,063 39,375 (19,688) 75% 50% 78,750 78,750 - State Grant 150,729 100,563 (50,166) 75% 50% 200,972 200,972 - SIB #1065 Court Assessment 45,000 36,803 (8,197) 75% 61% 60,000 60,000 - Marine Board License Fee 106,749 73,663 (33,086) 75% 52% a) 142,332 142,332 - Bureau of Reclamation - 20,117 20,117 75% n/a b) - 26,000 26,000 Des Cty General Fund Grant 432,108 - (432,108) 75% 0% c) 576,144 466,144 (110,000) Des Cty Transient Room Tax 1,555,392 1,555,392 (0) 75% 75% 2,073,856 2,183,856 110,000 Des Cty Tax/Fin Contract - 540 540 75% - 540 540 City of Sisters 337,471 337,471 (0) 75% 75% 449,961 449,961 - Des Cty CDD Contract 40,775 40,775 (1) 75% 75% 54,366 54,366 - Des Cty Solid Waste Contr 40,775 40,775 (1) 75% 75% 54,366 54,366 - Des Cty Clerk/Election 1,500 - (1,500) 75% 0% 2,000 2,000 - School Districts 60,000 12,317 (47,683) 75% 15% d) 80,000 40,000 (40,000) Claims Reimbursement - 2,750 2,750 75% n/a - 2,750 2,750 Security & Traffic Reimb 3,750 680 (3,070) 75% 14% 5,000 5,000 - Seat Belt Program 9,000 6,335 (2,665) 75% 53% 12,000 12,000 - Miscellaneous 6,000 12,103 6,103 75% 151% 8,000 14,000 6,000 False Alarm Fees 1,500 1,400 (100) 75% 70% 2,000 2,000 - Restitution - 2,169 2,169 75% n/a - 5,000 5,000 Sheriff Fees 7,500 7,353 (147) 75% 74% 10,000 10,000 - Court Fines & Fees 86,250 93,570 7,320 75% 81% 115,000 115,000 - Impound Fees 5,250 3,400 (1,850) 75% 49% 7,000 7,000 - Restitution - Street Crimes 375 - (375) 75% o% 500 500 - Seizure/Forfeiture - 1,324 1,324 75% n/a - 1,324 1,324 Interest 7,500 17,186 9,686 75% 172% 10,000 20,000 10,000 Interest on Unsegregated 1,350 632 (718) 75% 35% 1,800 1,000 (800) Grants-Private - 7,000 7,000 75% n/a - 7,000 7,000 Donations - 10,155 10,155 75% n/a - 10,155 10,155 Sale of Equip & Material 4,500 11,580 7,080 75% 193% 6,000 15,000 9,000 Sale of Reportable Assets 15,000 59,128 44,128 75% 296% e) 20,000 60,000 40,000 Total Revenues 8,709,131 9,972,082 1,262,951 50% 86% 11,612,172 11,823,064 210,892 TOTAL RESOURCES 11,645,654 12,976,614 1,330,960 50% 89% 14,548,695 14,827,597 278,902 REQUIREMENTS: Exp. % Fund 255 Departments: Sheriffs Services 120,173 116,126 4,047 75% 72% 160,230 158,308 1,922 Auto/Comm 761,395 741,230 20,165 75% 73% 1,015,193 1,059,563 (44,370) Investigations 1,300,664 1,086,008 214,655 75% 63% 1,734,218 1,520,664 213,554 Patrol 6,003,528 5,877,266 126,262 75% 73% 8,004,704 7,862,704 142,000 Records 540,533 472,913 67,619 75% 66% 720,710 694,610 26,100 Special Services 305,208 250,666 54,542 75% 62% 406,944 398,410 8,534 Training 94,728 72,683 22,046 75% 58% 126,304 111,075 15,230 Non Dept - ISF Charges 27,407 27,407 - 75% 75% 36,542 36,542 - Contingency 1,682,887 - 1,682,887 75% 0% 2,243,849 - 2,243,849 Transfer to Reserve Fund (704) 75,000 100,000 (25,000) 75% 100% 100,000 100,000 - Total Requirements 10,911,521 8,744,299 2,167,223 75% 60% 14,548,695 11,941,876 2,606,819 Net 734,133 4,232,316 3,498,183 - 2,885,721 2,885,721 Beginning Net Working Capital per Proposed Budget 2,859,915 Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services. a) Reimbursement requested semiannually in January and June b) BOR patrol contract signed after budget adopted c) Received annually in June Page 5 d) Reimbursement for SRO deputies will be less than planned from the Bend La Pine School District e) Proceeds for sale of used patrol vehicles higher than planned PUBLIC HEALTH Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,596,918 $ 1,702,129 $ 105,211 100% 107% $1,596,918 $1,702,129 $ 105,211 Revenues Medicare Reimbursement 450 740 290 75% 123% 600 800 200 Federal Grants - 5,000 5,000 75% n/a - 5,000 5,000 State Grant 2,032,608 1,880,116 (152,492) 75% 69% 2,710,144 2,729,165 19,021 Child Dev & Rehab Center 18,455 15,379 (3,076) 75% 63% 24,607 30,759 6,152 State Miscellaneous 168,622 79,396 (89,226) 75% 35% a)b) 224,829 127,000 (97,829) OMAP 392,888 436,511 43,623 75% 83% 523,850 582,000 58,150 Title 19 - 352 352 75% n/a - 500 500 Family Planning Exp Proj 390,000 354,044 (35,956) 75% 68% 520,000 532,000 12,000 Local Grants 33,750 87,458 53,708 75% 194% 45,000 118,448 73,448 Water Program-Base Fee 31,500 28,158 (3,342) 75% 67% a) 42,000 42,000 - Contract Payments - 25,000 25,000 75% n/a - 25,000 25,000 Water Program-Field Work 41,863 26,195 (15,668) 75% 47% a) 55,817 55,817 - H20 Sys Insp-Priv Wells 150 - (150) 75% 0% 200 200 - Miscellaneous - 4,129 4,129 75% n/a - 7,000 7,000 Patient Insurance Fees 101,535 134,146 32,611 75% 99% 135,380 170,000 34,620 Health Dept/Patient Fees 89,078 78,564 (10,514) 75% 66% 118,770 118,610 (160) Vital Records-Birth 22,950 29,565 6,615 75% 97% 30,600 35,000 4,400 Vital Records-Death 75,000 76,565 1,565 75% 77% 100,000 100,000 - Environmental Health 528,263 693,027 164,764 75% 98% c) 704,350 735,185 30,835 NSF Fee - 60 60 75% n/a - 60 60 Interest on Investments 9,000 7,814 (1,186) 75% 65% 12,000 10,000 (2,000) Donations 19,523 9,524 (9,999) 75% 37% 26,030 15,000 (11,030) Interfund Contract 148,790 73,739 (75,051) 75% 37% a) 198,387 160,000 (38,387) Administrative Fee 11,292 11,292 0 75% 75% 15,056 15,056 - Total Revenues 4,115,717 4,056,775 (58,942) 75% 74% 5,487,620 5,614,600 126,980 Transfers In-General Fund 1,738,323 1,738,323 - 75% 75% 2,317,765 2,317,765 - Transfers In-PH Res Fund 22,500 22,500 - 75% 75% 30,000 30,000 - Transfers In-Gen. Fund Other 48,825 48,825 - 75% 75% 65,100 65,100 - TOTAL RESOURCES 7,522,283 7,568,551 46,268 75% 80% 9,497,403 9,729,594 232,191 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) CEXp. 4,643,049 4,529,327 113,722 75% 73% 6,190,732 6,100,000 90,732 1,574,021 1,377,345 196,676 75% 66% 2,098,694 1,904,960 193,734 98,625 - 98,625 75% 0% 131,500 100,000 31,500 214,500 214,500 - 75% 75% 286,000 286,000 - 592,858 - 592,858 75% n/a 790,477 - 790,477 7,123,053 6,121,172 1;001,881 75% 64% 399,230 1,447,379 1,048,149 Beginning Net Working Capital per Proposed Budget 9,497,403 8,390,960 1,106,443 - 1,338,634 1,338,634 1,336,051 a) Received quarterly, in arrears b) Elimination of the State self sufficiency program c) Line includes, among other items, 1) Restaurant Fees (FY 2012 Budget=$450,000) and 2) Pool & Spa Fee (FY 2012 Budget=$110,000). These are due annually and collected primarily in December and January Page 6 BEHAVIORAL HEALTH Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Domestic Partnership Fee Federal Grants State Grants State Miscellaneous ABHA Title 19 Liquor Revenue School Districts Miscellaneous Patient Insurance Fees Patient Fees Interest on Investments Rentals Donations Administrative Fee Sheriff Interfund Contract-Gen Fund Comm. on Children & Fam Year to Date Budget Actual Variance FY % Coll. $ 3,268,759 $ 3,108,163 $ (160,596) 100% 95% 4,125 4,175 50 75% 76% 5,500 5,600 100 99,750 112,736 12,986 75% 85% 133,000 150,000 17,000 75 65 (10) 75% 65% 100 100 - 207,485 152,978 (54,507) 75% 55% 276,647 276,647 - 5,223,152 5,776,880 553,728 75% 83% a) 6,964,202 7,566,736 602,534 93,130 30,930 (62,200) 75% 25% b)c) 124,173 61,860 (62,313) - 164,728 164,728, 75% n/a d) - 170,000 170,000 211,723 87,572 (124,151) 75% 31% 282,297 177,300 (104,997) 78,750 82,505 3,755 75% 79% 105,000 141,500 36,500 56,700 55,850 (850) 75% 74% 75,600 75,600 - 10,500 5,665 (4,835) 75% 40% 14,000 14,000 - 85,275 145,179 59,904 75% 128% 113,700 170,000 56,300 1,355 805 (550) 75% 45% 1,807 1,150 (657) 18,750 19,288 538 75% 77% 25,000 26,700 1,700 9,825 9,000 (825) 75% 69% b) 13,100 13,100 - - 108 108 75% n/a - 200 200 3,322,267 3,276,553 (45,714) 75% 74% 4,429,689 4,429,689 - 15,000 - (15,000) 75% 0% e) 20,000 - (20,000) 95,250 73,319 (21,931) 75% 58% b) 127,000 127,000 - - 725 725 75% n/a - 725 725 Revised Year End Budget Projection Variance $ 3,268,759 $ 3,108,163 $ (160,596) Total Revenues 9,533,112 9,999,061 465,949 75% 79% 12,710,815 13,407,907 697,092 Transfers In-General Fund 947,637 947,637 - 75% 75% 1,263,515 1,263,515 - Transfers In-OHP-CDO 203,552 297,059 93,506 75% 109% 271,402 396,077 124,675, Transfers In-Acute Care Svcs 189,387 189,387 - 75% 75% 2521515 252,515 - Transfers In-ABHA 225,647 290,605 64,958 75% 97% 9 300,863 387,473 86,610 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 14,368,094 14,831,912 463,817 75% 82% Exp. 7,821,140 7,065,818 755,322 75% 68% 4,335,562 3,995,972 339,590 75% 69% 311,250 106,533 204,717 75% 26% 214,500 214,500 - 75% 75% 868,451 - 868,451 75% n/a 18,067,869 18,815,650 747,781 10,428,186 9,483,682 944,504 5,780,749 5,265,100 515,649 415,000 415,000 - 286,000 286,000 - 1,157,934 - 1,157,934 18,067,869 15,449,782 2,618,087 - 3,365,868 3,365,868 13,550,903 11,382,823 2,168,081 75% 63% 817,191 3,449,090 2,631,898 Beginning Net Working Capital per Proposed Budget a) Department of Human Services Grant projected at amended contract amount b) Received quarterly, in arrears c) Elimination of State contract for Temporary Assistance for Needy Families (TANF) program d) Revenue for Adult Mental Health Initiative clients, not included in original budget e) Funding for Mental Health Court from the Sheriffs Department eliminated f) Transfer made quarterly 3,320,968 Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Prog Planning-Current Planning-Long Range Total Revenues Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 229,822 131,776 $ (98,046) 100% 57% $ 229,822 $ 131,776 (98,046) 18,263 20,357 2,094 75% 84% 24,350 26,500 2,150 750 1,531 781 75% 153% a) 1,000 2,000 1,000 125,025 129,909 4,884 75% 78% 166,700 173,000 6,300 900,660 732,551 (168,109) 75% 61% b) 1,200,880 1,030,575 (170,305) 194,363 167,520 (26,843) 75% 65% b) 259,150 232,800 (26,350) 120,150 62,467 (57,683) 75% 39% c) 160,200 106,100 (54,100) 210,300 204,672 (5,628) 75% 73% 280,400 295,000 14,600 506,175 409,665 (96,510) 75% 61% b) 674,900 610,000 (64,900) 190,295 178,132 (12,163) 75% 70% d) 253,726 237,500 (16,226) 2,265,981 1,906,804 (359,177) 75% 63% 3,021,306 2,713,475 (307,831) Trans In-GF 547,221 472,221 (75,000) 75% 65% 729,625 729,625 - Trans In-GF for Lng Rng Ping 371,520 371,520 - 75% 75% 495,360 495,360 - Trans In-Other 75 - (75) 75% 0% 100 - (100) TOTAL RESOURCES 3,414,619 2,882,321 (532,298) 75% 64% 4,476,213 4,070,236 (405,977) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations 1,058,864 1,053,56.7 5,297 Admin-GIS 95,816 93,048 2,768 Admin-Code Enforcement 153,428 155,91() (2,482) Building Safety 421,524 413,555 7,969 Electrical 178,065 162,601 15,464 Contract Services 124,267 128,565 (4,298) Env Health-On Site Pgm 107,331 110,43.7 (3,106) Planning-Current 464,252 441,059 23,193 Planning-Long Range 359,105 329,489 29,616 Transfers Out (D/S Fund) 130,414 160,24:2 (29,828) Contingency 264,096 - 264,096 CEXp. 75% 75% 1,411,818 1,403,590 8,228 75% 73% 127,755 123,990 3,765 75% 76% 204,570 210,679 (6,109) 75% 74% 562,032 551,447 10,585 75% 68% 237,420 230,040 7,380 75% 78% e) 165,689 171,713 (6,024) 75% 77% f) 143,108 144,862 (1,754) 75% 71% 619,002 608,794 10,208 75% 69% d) 478,806 452,033 26,773 75% 92% g) 173,885 173,885 - 75% n/a 352,128 - 352,128 TOTAL REQUIREMENTS 3,357,162 3,048,474 308,688 75% 68% NET (Resources - Requirements) 57,457 (166,153) (223,610) Beginning Net Working Capital per Proposed Budget Revenues 1,906,804 Expenditures 3,048,474 Net from Operations __~1,141,6721 a) GIS revenue is sporadic based on the frequency of customer requests b) Fall activity less than anticipated c) Contract payments from Redmond are currently on hold pending finalization of a new contract d) As Tumalo area wetland inventory grant will not be received, budgeted expenses will not occur e) Year to date actual includes payout to retired employee f) Extra Help expenditures occur primarily in the summer months g) Transfers recorded November ($160,242) & May ($13,643) 4,476,213 4,071,033 405,180 (797) (797) 4,000 3,021,306 2,713,475 (307,831) 4,476,213 4,071,033 405,180 (1,454,907) (1,357,558) 97,349 Page 8 ROAD Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $3,417,158 $ 3,417,158 $ 0 100% 100% $ 3,417,158 $ 3,417,158 $ 0 Revenues System Development Charge - 924 924 75% n/a - 924 924 Federal Reimbursements 450,000 600,000 150,000 75% 100% a) 600,000 600,000 - Federal Grant (ARRA) 15,000 20,000 5,000 75% 100% b) 20,000 20,000 - Mineral Lease Royalties 30,000 135,006 105,006 75% 338% c) 40,000 140,000 100,000 Forest Receipts 983,372 1,322,661 339,289 75% 101% d) 1,311,162 1,322,661 11,499 State Miscellaneous 375,031 500,041 125,010 75% 100% e) 500,041 1,365,151 865,110 Motor Vehicle Revenue 8,505,000 7,847,319 (657,681) 75% 69% 0 11,340,000 10,810,307 (529,693) City of Bend 206,250 29,941 (176,309) 75% 11% g) 275,000 29,941 (245,059) City of Redmond 262,500 4,248 (258,252) 75% 1% g) 350,000 350,000 City of Sisters 7,500 - (7,500) 75% 0% g) 10,000 - (10,000) City of La Pine 7,500 - (7,500) 75% 0% g) 10,000 - (10,000) Admin Recovery (SDC) 750 1,991 1,241 75% 199% 1,000 2,000 1,000 Miscellaneous 15,000 26,615 11,615 75% 133% 20,000 26,615 6,615 Road Vacations 750 1,000 250 75% 100% 1,000 1,000 - Interest on Investments 15,000 14,340 (660) 75% 72% 20,000 17,000 (3,000) Parking Fees 108 - (108) 75% 0% 144 144 - Interfund Contract 547,500 - (547,500) 75% 0% h) 730,000 746,579 16,579 Equipment Repairs 150,000 179,699 29,699 75% 90% 200,000 220,000 20,000 Vehicle Repairs 67,500 - (67,500) 75% 0% 90,000 78,800 (11,200) LID Construction 7,500 - (7,500) 75% 0% h) 10,000 - (10,000) Vegetation Management 53,625 - (53,625) 75% 0% h) 71,500 40,175 (31,325) Forester 18,750 - (18,750) 75% 0% h) 25,000 25,000 - Car Washes 2,625 3,060 435 75% 87% 3,500 4,000 500 Car Rental - 758 758 75% n/a - 1,000 1,000 Sale of Equip & Material 474,750 683,749 208,999 75% 108% 633,000 780,477 147,477 Total Revenues 12,196,011 11,371,351 (824,660) 75% 70% 16,261,347 16,581,774 320,427 Trans In - Solid Waste 214,330 214,330 (0) 75% 75% 285,773 285,773 - Trans In - Transp SDC 187,500 187,500 - 75% 75% 250,000 250,000 Trans In-Road Imp Res 9,000 - (9,000) 75% 0% 12,000 - (12,000) TOTAL RESOURCES 16,023,999 15,190,339 (833,660) 75% 79% 20,226,278 20,534,705 308,427 REQUIREMENTS: EE 9 Expenditures Personal Services 4,211,492 4,011,655 199,837 75% 71% 5,615,323 5,351,168 264,155 Materials and Services 8,066,334 6,682,856 1,383,478 75% 62% i) 10,755,112 9,777,435 977,677 Capital Outlay 927,518 25,288 902,230 75% 2% j) 1,236,691 85,936 1,150,755 Transfers Out 450,000 600,000 (150,000) 75% 100% 600,000 600,000 - Contingency 1,514,364 - 1,514,364 75% n/a 2,019,152 - 2,019,152 TOTAL REQUIREMENTS 15,169,708 11,319,799 3,849,909 75% 56% 20,226,278 15,814,539 4,411,739 NET (Resources - Requirements) 854,291 3,870,540 3,016,249 Beginning Net Working Capital per Proposed Budget - 4,720,166 4,720,166 4,719,551 a) Revenue received in November at completion of the Cascade Lakes chip seal project b) Payment received in December c) Mineral leases higher than anticipated d) Received annually in January e) Annual payment received in August, plus payments from FY 2010 & 2011 previously reserved for 19th St expected to be received in FY 2012 f) Revenues trending less than estimates provided by ODOT g) Billed upon completion of work h) Payments to be received in June 2012 from other Road Department funds i) Expenditures are seasonal and higher during summer. YTD includes $2.5 million paid to Knife River on the Page 9 Full Depth Reclamation Project in South County j) Budget includes $1,096,691 for future projects that will not be expended in FY 2012 ADULT PAROLE & PROBATION Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End Budget Actual Variance FY % Cc ll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 560,000 $ 634,125 $ 74,125 100% 113% $ 560,000 $ 634,125 $ 74,125 Revenues DOC Measure 57 163,013 219,240 56,227 75% 101% a) 217,350 219,240 1,890 State Miscellaneous 3,226 4,301 1,075 75% 100% a) 4,301 4,301 - Alternate Incarceration 23,189 - (23,189) 75% 0% b) 30,918 21,000 (9,918) State Subsidy 9,750 10,370' 620 75% 80% c) 13,000 13,000 - SB 1145 2,141,743 2,061,417 (80,326) 75% 72% c) 2,855,659 2,748,953 (106,706) Probation Work Crew Fees 18,000 16,450 (1,550) 75% 69% 24,000 21,180 (2,820) Miscellaneous 3,075 1,880 (1,195) 75% 46% 4,100 2,100 (2,000) Electronic Monitoring Fee 127,500 94,061 (33,439) 75% 55% 170,000 125,446 (44,554) Probation Superv. Fees 150,000 141,285 (8,715) 75% 71% 200,000 182,674 (17,326) Interest on Investments 6,750 4,517 (2,233) 75% 50% 9,000 9,000 - Interfund - Sheriff 37,500 37,500 0 75% 75% 50,000 50,000 - Crime Prevention Grant 37,500 12,500 (25,000) 75% 25% d) 50,000 50,000 - CFC-Domestic Violence 56,124 37,416 (18,708) 75% 50% d) 74,832 74,832 - Total Revenues 2,777,370 2,640,936 (136,434) 75% 71% 3,703,160 3,521,726 (181,434) Transfers In-General Fund 253,719 253,719 - 75% 75% 338,292 338,292 - TOTAL RESOURCES 3,591,089 3,528,780 (62,309) 75% 77% 4,601,452 4,494,143 (107,309) REQUIREMENTS: Cp. Expenditures Personal Services 2,376,516 2,266,801 109,715 75% 72% e) 3,168,688 3,084,689 83,999 Materials and Services 665,168 536,796 128,372 75% 61% f) 886,890 800,000 86,890 Capital Outlay 75 - 75 75% 0% 100 - 100 Transfers Out 21,600 21,600 - 75% 75% 28,800 28,800 - Contingency 387,731 - 387,731 75% n/a 516,974 - 516,974 TOTAL REQUIREMENTS 3,451,090 2,825,19-7 625,893 75% 61% 4,601,452 3,913,489 687,963 NET (Resources - Requirements) 139,999 703,583 563,584 - 580,654 580,654 Beginning Net Working Capital per Proposed Budget 570,000 a) Annual allocation received in January b) State invoiced quarterly. Payment from State pending-$4,095 c) State invoiced quarterly. Payments received from State at beginning of quarter d) Interfund grant received quarterly. Payments have been requested e) Less than planned expenditures due to open positions f) Less than planned expenditures due to Measure 57 tax amount Page 10 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Level 7 Services State Prevention Funds HealthyStart /R-S-G OCCF Grant Program Fees Charges for Svcs-Misc Court Fines & Fees Interest on Investments Donations Interfund Grants Total Revenues Year to Date I Budget Actual Variance FY % Coll. % $ 467,111 $ 556,143 $ 89,032 100% 119% 224,616 192,200 (32,416) 29,497 30,155 658 71,250 19,205 (52,045) 193,487 154,986 (38,501) 18,375 79,801 61,426 233,879 193,653 (40,226) 408,902 383,499 (25,403) - 2,913 2,913 6,000 1,161 (4,839) 58,500 67,642 9,142 3,750 3,267 (483) - 71 71 90,656 240,822 150,166 1,338,912 1,369,375 30,463 Trans from General Fund 204,723 204,723 - 75% 75% 272,960 272,960 - Total Transfers In 204,723 204,723 - 75% 75% 272,960 272,960 - TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 2,010,746 2,130,241 119,495 75% 84% F_. Year End Budget Projection Variance $ 467,111 $ 556,143 $ 89,032 75% 64% a) 299,488 305,416 5,928 75% 77% a)b) 39,329 39,534 205 75% 20% a)c) 95,000 85,000 (10,000) 75% 60% a)b) 257,982 196,898 (61,084) 75% 326% d) 24,500 79,801 55,301 75% 62% a)b) 311,838 258,203 (53,635) 75% 70% a)b) 545,203 509,579 (35,624) 75% n/a e) - 3,500 3,500 75% 15% 8,000 8,000 - 75% 87% f) 78,000 79,485 1,485 75% 65% 5,000 5,000 - 75% n/a e) - 300 300 75% 199% g) 120,875 320,875 200,000 75% 77% 1,785,215 1,891,591 106,376 Exp. 2,525,286 2,720,694 195,408 453,839 439,405 14,434 75% 73% h) 605,119 574,945 30,174 1,265,234 858,877 406,357 75% 51 % i) 1,686,979 1,631,476 55,503 75 - 75 75% 0% 100 100 - 174,816 - 174,816 75% n/a 233,088 233,088 TOTAL REQUIREMENTS 1,893,964 1,298,282 595,682 75% 51% 2,525,286 2,206,521 318,765 NET (Resources - Requirements) 116,782 831,959 715,177 - 514,173 514,173 Beginning Net Working Capital per Proposed Budget 511,994 a) Grant payments received normally within 60 days after the end of each quarter b) FY 2012 and FY 2013 Intergovernmental Agreement finalized funding levels from OCCF. Community Schools grant included in year-end projection at $9,484. Additional Casey Foundation grant of $11,214 received c) Medicaid revenues reduced due to lower projections d) Youth Suicide Prevention grant increased by $5,000. Runaway/homeless youth grant from DHS not budgeted for $48,122 e) Youth Suicide Prevention training donations & fees expected to be received f) Court fees projected to be higher than estimated in the original budget g) Two additional grants of $55,000 & $180,000 awarded. $55,000 received in last fiscal year, $20,000 grant from OHP expected h) Personnel costs lower due to part-time Early Childhood Specialist; eliminated the extra help allocation of $5,000 i) Sub-grant expenditures paid quarterly. Federal grant amount increased and SPF-SIG grant expenditures added $21,214 in expenditures added, remaining $10,000 for staff expenses Page 11 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Franchise 3% Fees Commercial Disp. Fees Private Disposal Fees Franchise Disposal Fees Yard Debris Special Waste Interest Leases Donations Sale of Reportable Assets Recyclables Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out-Road Trans Out-Post Closure Trans Out-Equip Reserve Trans Out-Capital Res Contingency TOTAL REQUIREMENTS SOLID WASTE Statement of Financial Operating Data Nine Months Ended March 31, 201:2 Year to Date Year End Budget Actual Variance FY % Coll. I. Budget Projection Variance $ 1,092,508 $ 1,141,691 $ 49,183 100% '105% $ 1,092,508 $ 1,141,691 $ 49,183 16,500 13,748 (2,752) 75% 62% 22,000 22,000 - 150,000 87,602 (62,398) 75% 44% a) 200,000 200,000 - 645,000 635,855 (9,145) 75% 74% 860,000 860,000 - 985,500 947,209 (38,291) 75% 72% 1,314,000 1,314,000 - 3,000,000 2,945,198 (54,803) 75% 74% 4,000,000 4,000,000 - 54,750 61,563 6,813 75% 84% b) 73,000 80,000 7,000 18,750 4,339 (14,411) 75% 17% c) 25,000 10,000 (15,000) 5,625 8,024 2,399 75% '107% 7,500 9,500 2,000 1 7,694 7,693 75% n/a d) 1 10,394 10,393 - 2,880 2,880 75% n/a e) - 2,880 2,880 - 16,494 16,494 75% n/a f) - 16,494 16,494 22,500 57,942 35,442 75% '93% g) 30,000 72,000 42,000 4,898,626 4,788,546 (110,080) 75% 73% 6,531,501 6,597,268 65,767 5,991,134 5,930,238 (60,896) 75% 78% 7,624,009 7,738,959 114,950 Ccp. 1,253,699 1,195,874 57,825 75% 72% 2,169,789 1,879,533 290,256 75% 65% 728,425 398,826 329,599 75% 41% h) 129,000 160,800 (31,800) 75% 93% 214,330 214,330 0 75% 75% 300,000 200,000 100,000 75% 50% 187,500 250,000 (62,500) 75% 100% i) 318,000 212,000 106,000 75% 50% 417,265 - 417,265 75% n/a 5,718,008 4,511,363 1,206,645 75% 59% NET (Resources - Requirements) 273,126 1,418,875 1,145,749 Beginning Net Working Capital per Proposed Budget 1,671,598 1,623,865 47,733 2,893,052 2,986,418 (93,366) 971,233 888,460 82;773 172,000 179,930 (7,930) 285,773 285,773 - 400,000 400,000 - 250,000 250,000 - 424,000 424,000 - 556,353 556,353 7,624,009 7,038,446 585,563 700,513 700,513 700,513 a) Due April 15, 2012 b) Seasonal item-Fall and Spring c) Dependent on special clean-ups such as asbestos and contaminated soil d) Revenue from rent on Rickard Road property, not included in original budget e) Incentive for energy efficient lighting upgrade in Knott Transfer Station building f) Sold glass crusher at auction g) Recycling markets are higher than expected. Often it can be seasonal Page 12 h) To be expended in November ($398,827) and May ($489,633). Will be less than budgeted due to refunding of FF&C 2003 debt. i) Budgeted amount transferred in September RISK MANAGEMENT Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End Budget Actual Variance % of FY % Coll. Budget Projection Variance RESOURCES: Beginning Net Working Capital $2,100,000 $2,039,937 ($60,063) Revenues Inter-fund Charges: General Liability 188,141 188,141 0 Property Damage 233,725 233,725 0 Vehicle 133,733 133,733 (0) Workers' Compensation 1,105,458 1,105,458 0 Unemployment 189,325 189,567 242 Claims Reimb-Workers' Compensation 3,750 548 (3,202) Claims Reimb-Gen Liab/Property 15,000 64,732 49,732 Process Fee-Events/Parades 1,125 1,250 125 Miscellaneous 38 - (38) Skid Car Training 13,500 10,010 (3,490) Interest on Investments 11,250 10,614 (636) Other Interest 38 - (38) TOTAL REVENUES 1,895,081 1,937,778 42,696 Transfers In-General Fund 150,000 - (150,000) TOTAL RESOURCES 4,145,081 3,977,714 (167,367) Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit 110,210 Defense 186,775 Professional Service 677 Insurance 109,664 Repair / Replacement 5,517 Total General Liability 300,000 412,843 (112,843) PROPERTY DAMAGE Insurance 116,268 Repair / Replacement 67,605 Total Property Damage 225,167 183,873 41,294 VEHICLE Professional Service 5 Insurance 376 Loss Prevention 10,482 Repair / Replacement 51,786 Total Vehicle 76,114 62,649 13,465 WORKERS' COMPENSATION Settlement / Benefit 761,308 Insurance 96,063 Loss Prevention 39,065 Miscellaneous 21,772 Total Workers' Compensation 750,000 918,207 (168,207) UNEMPLOYMENT - Settlement/Benefits 187,500 115,474 72,026 Total Direct Insurance Costs Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET 1,538,781 1,693,046 (154,265) 220,768 195,417 25,351 125,788 103,863 21,924 75 - 75 346,631 299,280 47,350 5,400 5,400 - 1,890,812 1,997,726 (106,914) 2,254,270 1,979,988 (274,282) Beginning Net Working Capital per Proposed Budget * Contingency is $2,305,693. 100%a 97% $2,100,000 $2,039,937 ($60,063) 75% 75% 250,855 250,855 - 75% 75% 311,633 311,633 - 75% 75% '178,310 178,310 - 75% 75% 1,473,944 1,473,944 - 75% 75% 252,433 252,433 - 75% 11% 5,000 5,000 - 75% 324% 20,000 75,000 55,000 75% 83% 1,500 1,500 - 75% 0% 50 50 - 75% 56% 18,000 14,000 (4,000) 75% 71% 15,000 15,000 - 75% 0% 50 50 - 75% 77% 2„526,775 2,577,775 51,000 75% 0% 200,000 200,000 - 75% 82% 4,826,775 4,817,712 (9,063) % Ex p.. 75% 103% a) 400,000 475,000 (75,000) 75% 61% 300,223 260,000 40,223 75% 62% 101,485 90,000 11,485 75% 92% a) 1,000,000 1,100,000 (100,000) 75% 46% 250,000 250,000 - 75% 83% 2,051,708 2,175,000 (123,292) 75% 66% 294,357 294,357 - 75% 62% 167,717 167,717 - 75% 0% 100 - 100 75% 65% 462,174 462,074 100 75% 75% 7,200 7,200 - 75% 79%, 2,521,082 2,644,274 (123,192) * 2,305,693 2,173,438 (132,255) 2,000,000 Page 13 a) Expenditures are projected to exceed current appropriation. Appropriation transfer is pending. DESCHUTES COUNTY 911 Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Revised Year End Budget Actual Variance % of FY _ % Coll. _ Budget Projection Variance RESOURCES: Beg. Net Working Capital $6,400,000 $ 7,559,639 $ 1,159,639 100% 118% $6,400,000 $7,559,639 $ 1,159,639 Revenues Property Taxes - Current 4,487,830 5,881,136 1,393,306 75% 98% 5,983,773 6,100,289 116,516 Property Taxes - Prior 150,000 231,135 81,135 75% 116% 200,000 254,005 54,005 Federal Grants - 184,578 184,578 75% n/a - 203,958 203,958 State Reimbursement 40,500 10,836 (29,664) 75% 20% a) 54,000 27,000 (27,000) Telephone User Tax 562,500 381,366 (181,134) 75% 51% 750,000 750,000 - Grant - Sunriver Serv Dist - 22,500 22,500 75% n/a - 22,500 22,500 Data Network Reimb. 20,400 34,698 14,298 75% 128% b) 27,200 34,698 7,498 Jefferson County 26,250 27,797 1,547 75% 79% 35,000 35,000 - User Fee 39,000 4,313 (34,688) 75% 8% c) 52,000 52,000 - Police RMS User Fees 149,250 - (149,250) 75% 0% d) 199,000 199,000 - Contract Payments 24,000 33,061 9,061 75% 103% b) 32,000 33,061 1,061 Miscellaneous 6,750 8,807 2,057 75% 98% 9,000 9,000 - Interest 26,250 41,149 14,899 75% 118% 35,000 55,000 20,000 Interest on Unsegregated Tax 600 520 (80) 75% 65% 800 800 - Donations - 750 750 75% n/a - 750 750 Total Revenues 5,533,330 6,862,644 1,329,314 75% 93% 7,377,773 7,777,061 399,288 TOTAL RESOURCES 11,933,330 14,422,283 2,488,953 75% 105% 13,777,773 15,336,700 1,558,927 REQUIREMENTS: % Exp. Expenditures Personal Services 3,180,626 2,841,339 339,287 75% 67% 4,240,834 3,800,000 440,834 Materials and Services 1,445,517 1,242,724 202,793 75% 64% 1,927,356 1,927,356 - Capital Outlay 850,965 492,031 358,934 75% 43% 1,134,620 1,134,620 - Transfers Out 375,000 500,000 (125,000) 75% 100% e) 500,000 500,000 - Contingency 4,481,222 - 4,481,222 75% n/a 5,974,963 - 5,974,963 TOTAL REQUIREMENTS 10,333,330 5,076,094 5,257,236 75% 37% 13,777,773 7,361,976 6,415,797 NET (Resources - Requirements) 1,600,000 9,346,189 7,746,189 - 7,974,724 7,974,724 Beginning Net Working Capital per Proposed Budget 8,000,000 a) GIS/MSAG monthly billings to Oregon Emergency Management-projected revenue overestimated. Projection revised to $27,000 Payments have been received through January; February and March have been billed out b) Invoiced annually; all expected revenues received c) US Forest Service invoiced $2156.25 quarterly. Crooked River Ranch invoiced annually June 30th. Payment will not be received from Crooked River Ranch until FY 2013 d) Fees expected to be billed in April or May e) Entire amount budgeted transferred to reserve fund in September Page 14 Health Benefits Trust Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges P/T Emp - Add'I Prem Employee Prem Contribution COIC Retiree / COBRA Co-Pay Fees for Clinic Services Federal Payment (ERRP) Prescription Rebates Interest Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures: Personal Services Materials & Services Claims Paid-Medical/Rx Claims Paid-Dental/Vision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Other Admin & Wellness Deschutes On-site Clinic Healthstat Medications/Drugs Medical Supplies Equipment Miscellaneous Total DOC Deschutes On-site Pharmacy Remodeling Costs Total Pharmacy Capital Outlay Contingency Year to Date Revised Year End Budget Actual Variance FY % Coll. % -Budget Projection Variance $15,500,000 $ 15,829,888 $ 329,888 100% 0 $15,500,000 $15,829,888 329,888 9,011,783 9,053,638 41,855 75% 75% 12,015,711 12,015,711 37,500 23,336 (14,164) 75% 47% 50,000 50,000 472,500 443,350 (29,150) 75% 70% 630,000 630,000 945,000 974,632 29,632 75% 77% 1,260,000 1,260,000 - 375,000 634,804 259,804 75% 127% 500,000 750,000 250,000 200 200 75% n/a - 200 200 150,431 150,431 75% rile ' - 150,431 150,431 - 81,117 81,117 75% n/a - 81,117 81,117 60,000 78,945 18,945 75% 99% 80,000 100,000 20,000 10,901,783 11,440,454 538,671 75% 79% 14,535,711 15,037,459 501,748 26,401,783 27,270,342 868,559 92% 103% 30,035,711 30,867,348 831,637 Exp. 113,414 102,568 10,845 75% 68% 151,218 151,218 - 9,355,713 9,051,531 304,183 75% 73% a) 12,474,284 11,993,354 480,931 1,397,980 1,471,348 (73,367) 75% 79% a) 1,863,974 1,949,536 (85,562) - (59,167) 59,167 75% n/a - (59,167) 59,167 262,500 264,746 (2,246) 75% 76% 350,000 350,000 - 112,500 155,263 (42,763) 75% 104% 150,000 155,263 (5,263) 240,000 238,077 1,923 75% 74% 320,000 320,000 37,500 36,469 1,031 75% 73°% 50,000 50,000 41,250 38,526 2,724 75% 70% 55,000 55,000 105,872 106,550 (678) 75% 75% 141,162 141,162 - 11,666,729 11,405,910 260,818 75% 73% 15,555,638 15,106,365 449,273 717,900 501,127 216,773 75% 52% 957,200 957,200 - 243,750 110,585 133,165 75% 34% 325,000 325,000 - 2,250 21,878 (19,628) 75% 729% 3,000 30,000 (27,000) 3,000 150 2,850 75% 4% 4,000 4,000 4,088 8,239 (4,151) 75% 151% 5,450 10,000 (4,550) 970,988 641,978 329,010 75% 50% 1,294,650 1,326,200 (31,550) 0 60,706 60,706 75% 60,706 (60,706) 75% 150 150 75% 9,888,917 - 9,888,917 75% n/a - 100,000 (100,000) nla - 100,000 (100,000) n/a 200 - 200 n/a 13,185,223 - 13,185,223 TOTAL EXPEND/REQUIREMNTS 22,640,197 12,108,594 10,429,035 75% 40% 30,035,711 16,532,565 13,503,146 NET (Resources - Requirements) 3,761,587 15,161,749 11,297,594 - 14,334,782 14,334,782 Beginning Net Working Capital per Proposed Budget 14,500,000 Early Retirement Reinsurance Program (ERRP). Federal program to help pay the cost of insuring retirees who are not yet Medicare eligible. a) Projection based on annualizing 40 weeks of claims paid. YTD actual is $261,593 per week. Page 15 Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital Receipts: Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Grants Interfund Contract Miscellaneous Total Receipts Year to Date Year End Budget (9/12 of annual) Actual Variance FY % Coll. % Budget Proiection Variance $ 75,000 $ (40,601) $ (115,601) 100% -54% $ 75,000 $ (40,601) $ (115,601) Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Reserve Fund (617) Total Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Total Expenditures Transfers Out - Reserve Fund Contingency 453,750 395,024 (58,726) 75% 65% 605,000 565,024 (39,976) 1,125 124 (1,001) 75% 8% 1,500 498 (1,002) 43,500 17,199 (26,302) 75% 30% 58,000 40,199 (17,801) 4,500 5,775 1,275 75% 96% 6,000 11,775 5,775 22,500 8,341 (14,159) 75% 28% 30,000 32,341 2,341 165,000 109,546 (55,454) 75% 50% 220,000 153,546 (66,454) 84,000 44,000 (40,000) 75% 39% 112,000 107,000 (5,000) - - 75% n/a - 33,424 33,424 35,250 1,500 (33,750) 75% 3% 47,000 47,000 - 5,105 9,965 4,859 75% n/a 6,807 11,369 4,562 814,730 591,474 (223,259) 75% 54% 1,086,307 1,002,176 (84,131) 127,500 277,503 - 75% 163% 170,000 370,000 200,000 19,308 19,305 - 75% 75% 25,744 25,744 - 62,100 62,100 - 75% 75% 82,800 82,800 - 165,000 220,000 55,000 75% 100% 220,000 220,000 - 75 - (75) 75% 0% 100 - (100) 373,983 578,908 54,925 498,644 698,544 199,900 1,263,713 1,129,781 (133,933) 75% 68% 1,659,951 1,660,119 168 Exp. 649,514 611,098 38,415 75% 71% 866,018 828,676 37,342 477,045 473,876 3,169 75% 75% 636,060 676,380 (40,320) 86,301 71,266 15,035 75% 62% 115,068 113,695 1,373.00 75 - 75 75% 0% 100 - 100 1,212,935 1,156,240 56,694 1,617,246 1,618,751 (1,505) 7,500 10,000 (2,500) 75% 100% 24,529 L24,529 75% n/a 10,000 10,000 - 32,705 - 32,705 TOTAL REQUIREMENTS 1,244,963 1,166,240 78,723 75% 70% 1,659,951 1,628,751 31,200 NET (Resources - Requirements) 18,750 (36,460) (55,210) - 31,368 31,368 Beginning Net Working Capital per Proposed Budget 46,373 Page 16 H v w 0 a a a H a v Q, U 0 0 z 0 a~ a~ a~ 00 00 0 0a 0)o0 rn C o r o 00 00 0 00 co CO m 0 0 cc 10 00 00 o Oo co o0 co 0 o co o ' 00 00 0 Trim .=trio co 0 0 "i o Or OO N1- rf~r CA M O c V Go c O Crl ~ r7 I"'I I I "'I")I I"' N_ C O N C Co L N O V v•2~ ca t co rn ~ T 3 O G) O c U o r a o V z O co co t- a ti~ OO O O 0 GD ' ' ' ' ' ' ' O O ' O GD N O O O N O O r r r r r O co O O co w 00 ch O o co co co 1- O w O O r C O I- GO 0 0 (000 co r M to r r~ co COCCact GD 00 ' cOOO c0 Oq ' O GD r ON W) ONGA 00 rON M Nrco I%. N 0 O O N O N O r co r- O ~ N C4 N v co 0 O c+i r 1A r cli & N V N ~ r 'C G) C 0 co00 CO) 00 MOO M cM1-0 0) ZLL O r 0 Cl r a O co a 0 0 r CV) Lc) r v 0000 ' O 00 ' 1000 ' c0 Ococo ' O ' y ONOO r- 00 O CD C4 c7 P 04 rc7 0 0 0 1%. N G) C a' O O O N O N Ov CO O r r t 0 • r Go O ..LL N r tt r C %i Q cc m .0 N . O ` mn Co 00 co co O I~IT o cMIT co0co w T- 001-Go O vGo CD r T- CV) V N N G) ' CCCGOGD O N 'I Go ONN ' O co - NN o r t0 O O M CL 0 ONO t o O w w o o U v_ co o v_ v_ Q o r N r r r w m ` a) m CD O O N ~ (D (c C t o E co co co w o a w r r r r E a) o ` rn U ~ O L h co 00c7w U') I-erO cn0 mCco N IV 3 r00 1-GD ' N otCD00 m rM V C O ' V) O to r L CCC GO GD U) 0 M O N M V- N v r co r NN O 0 O . ..r 3N O N N m M G D V co q yr v d;, rd) r N r r r p U. N C ~ w LL O ~ Em a V V a' Z N f0 41 L y O N L C -v qq N N m 4) c V O C C h p) N t0 c p to Y n 0 to ~ „ 3 C a a N IA bi C) 4) p) R 0 3 d ~ m ui = o - 32 rn wz C c Gam)o in R C v3 0)).E U co O N rn c o 0 > 1- ca U ~ N d V G) m O IX s O V V m 0 G) G) rn C C a y - /0 10 la ~ C X 7 L O N iv C d r- z E 42 to N _ a O G W L _ G7 p) N N O` co p t a +N c 4) Q p ) m 0 i- C: o !a N H W 0 v c K m¢w aSLL ~ ~ m~~ U c m Ix m -Aw ~H wZ U F- 2 tom m o N N G) p 3 O L LL 4) co w r- CD 0 N CD ~ ~Z W LL F- N O o0N U M co 0 t L W < C~ W c Z 0 CO F- D U o Z Z w LO N M f`9 O O O O Deschutes County Bethlehem Inn (Fund 128) Nine Months Ended March 31, 2012 I Budget Actual Variance FY % Coll. % I Budget I Projection I Variance I RESOURCES: Beg. Net Working Capital $ (2,711,235) $ (2,716,581) $ (5,346) 100% 100% $ (2,711,235) $ (2,716,581) $ (5,346) Revenues Grants - Private 1,867,885 - (1,867,885) 67% 0% 2,801,827 - (2,801,827) Lease Payments 16,272 20,340 4,068 67% 83% 24,408 24,408 - Total Revenues 1,884,157 20,340 (1,863,817) 67% 1% 2,826,235 24,408 (2,801,827) TOTAL RESOURCES (827,078) (2,696,241) (1,869,163) 67% -2345% 115,000 (2,692,173) (2,807,173) REQUIREMENTS: Exp. Expenditures Debt Service: Interest Expense 10,000 13,937 (3,937) 67% 93% a) 15,000 17,000 (2,000) Interest Payment 66,667 - 66,667 67% 0% 100,000 - 100,000 TOTAL REQUIREMENTS 76,667 13,937 62,730 67% 12% 115,000 17,000 100,000 NET (Resources - Requirements) (903,745) (2,710,178) (1,806,433) a) Interest on March 2012 negative cash bal ance: $1,346.47. b) Inception through March 31, 2012 Revenues - Lease Payments $ 44,748 Expenditures: 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 237,013 Total expended 2,754,926 Net $ (2,710,178) b) - (2,709,173) (2,707,173) I Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Travel Expenditures and BOCC - County College Expenditures FY 2012 I ( ! I i i I BOCC Conference & Travel Jul Aug Sep Oct Nov Dec Jan Feb Mar YTD Total Tammy Baney j I Conf/Sera & Educ/Training 665 - - 305 15 - 75 - j - 1,060 Travel Meals - - j 220 - 30 90 - - 40 380 Accommodations 996 - 211 429 - - j 1,265 j - 84 j 2,985 Airfare - - - - - - - - - - Mileage reimbursement - j - 794 - 677 309 1 529 j 204 578 ! 3,090 Ground Transport/Parking - - 150 - - - - - - 150 Total Baney 1,661 1 - 1,375 734 j 722 399 1,870 204 j 702 j 7,665 Alan Unger Conf/Sera & Educ/Training 665 - - ! 305 45 - 75 1 30 j 45 1,165 Travel Meals - - - - - - j - - - - Accommodations 1,131 - - 3221 - - - - - 1,452 Airfare - - - j - - - - - - - Mileage reimbursement Ground Transport/Parking j - - - ! - - - - i - - - Total Unger 1,796 - - 627 45 - 75 30 45 j 2,617 Tony DeBone Conf/Sem & Educ/Training 665 - - 305 45 - 535 30 30 1,610 Travel Meals - - - - - - - - 159: 159 Accommodations 908 - - 429 - - - - - 1,337 Airfare - - - - - - 573 - 501 623 Mileage reimbursement - 300 j - 146 - 163 ! 138 412 104 1 1,264 Ground Transport - 54 - - - - - - 83 137 Total Other 1,573 354 - 880 45 163 1,246 442 j 426 5,130 Total - BOCC Department j Conf/Sem & Educ/Training 1,995 - j - 915 105 - 685 60 75 3,835 Travel Meals 220 - 30 90 - - 199 539 Accommodations 3,034 - j 211 1,179 - _ - 1,265 j - 84 j 5,774 Airfare - - - - - - 573 - 50 623 Mileage Reimbursement - 300 794 146 677 472 668 616 682 4,355 Ground Transport - 54 150 - - I - - - 83 287 Total - BOCC Department 5,029 354 1,375 2,240 812 562 j 3,191 676 1,173 i 15,412 FY 2012 Budget j 14,750 Percent of FY 2012 Budget Expended 104.5% I i I i ! I I BOCC County College ( j Office/Copier Supplies - - 120 - 59 11 12 - - 201 Meeting Supplies - - 556 829 788 1 - - - - 2,172 Total BOCC County College - - 675 829 847 11 12 - - 2,373 I 4/16/2012 i RESOURCES: Beg. Net Working Capital Revenues RV Park Fees < 31 Days RV Park Fees > 30 Days Tent Space Rental Washer / Dryer Vending Machines City of Redmond Room Tax Collection Fee Interest on Investments Cancellation Fees Total Revenues Transfers In-Gen Fund Transfers In-Fund 130 TOTAL RESOURCES REQUIREMENTS: Expenditures Materials & Services Debt Service Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) RV Park (Fund 601) Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Budget Actual Variance FY % Coll. $10,000 $ (28,100) $ (38,100) 100% 133,875 97,196 (36,679) 5,550 3,250 (2,300) 600 - (600) 1,195 745 (450) 900 298 (602) 3,000 - (3,000) - 33 33 - 1,073 1,073 145,120 102,595 (42,525) 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% n/a 54% a) 44% a) 0% 47% 25% 0% n/a n/a n/a 53% 105,000 110,000 5,000 75% 79% 260,120 184,495 (75,625) 75% 41% Exp. Year End [Budget l Projection Variance $10,000 $ (28,100) $ (38,100) 178,500 (46,304) 7,400 3,250 (4,150) 800 800 - 1,593 1,200 (393) 1,200 298 (902) 4,000 - (4,000) - 33 33 - 1,073 1,073 193,493 138,850 (54,643) 110,000 110,000 - 140,000 140,000 - 453,493 360,750 (92,743) 64,292 73,252 (8,960) 75% 85% 85,722 85,722 - 159,825 159,825 - 75% 66% b) 242,829 242,829 - 93,707 - 93,707 75% n/a 124,942 - 124,942 317,824 233,077 84,747 75% 51% (57,704) (48,581) 9,122 Beginning Net Working Capital per Requested Budget 453,493 328,551 124,942 32,199 32,199 a) 3,139 RV spaces rented b) Debt service expended semi-annually - November and May. r O N } LL C (OD V N O O N Y U O CC C O N L CU > CL 7 LL ~ U O c 0 c O C (n U CU a L > U ~ .3 N O N } LL ~ ti 10 0 0 (M O r- m cM LO ~ ,qt vMI- NOrON O IT N r V M M r O 0 O LO r M (A LO r MM 0 r M r M M ~co vN r M(OCDrLO OON14' co C)C)M0NN(V U) (D Iq i,- OIl- MrMrfM(D d' CD(OMf-NrN O V N r O V- 0 0 0 0 0 0 0 0 0 0 0 0 0 MIl- NOmd)N~0)1- 00)M 00 N I, r I'- LA to M LO O 113: d' M 00 N (D 0 M O r N U') qqr N N N M qj' r r r T (D O N r O O M M tt LO a0 r- N I,- 00 M ti r r LO (D M L() O M 1, N c vi r r r r M 1- N N m m m (0 ~ 00 m d' q' O N M U') r 0 N r O r I- LO T 0 Cl 00 IqT OI;r w 01,- N 00 O O 1- 6 Vt I~ Ln (6 r N LLB V (M N N ~ ~ r r r O r 0 0 0 0 0 0 0 0 0 0 0 0 0 (0 r 0 0 N r O ti O LO 00 r r - r.- O 00 IRt 00 N N r r C) 0) 0 (O r0000NONN000(0006 N r r N LO M O M O I- 'T ~ O CO m O M r LO 00 'T M r- co O LO N M O I- M N M N N N (0 M M (D V~ qq 00 qT 00 00 'IT N N w N 00 I- Ln w 0 N rl- LO (0 O It U') 00 M qq O 0 00 N M O LO r M M N N r 00 O N N N O w~ O 1• N r N O T- 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 O O g v 0 0 M CO LO r C14 N 19t CO) (D 00 W 00 (O It LO r N LO r- CO O ~000Lnr000~I~CDNh r N O 00 T N r M O O O r 0 0 M Lf) M 0 LO r r ICT cM N N N 'Rt C) N r r N N I- f` N N'It (0 'V N O M M 00 T N O N LO It M It M r O N O CD M M Mlzr O r 0 14' (D r (D O O O Ln O t0 P- ti M 1~: r r N co 3 ~ d V Q Z d v 4) a) a) 0 a) M ~ ea O E 0 - E E a, +O+ 3 . 0 m O U a) O a) 3~~ C ca _T~~ p C O Q ~Qwo z 0 LL W O (0 0 r. C m ~ c (d LO a) ~ II ca O N ~O m M fH Ln . O m 00 h a I- Ln r a) c ~ a O N i N O U M 00 (D M II N -q- O ~ N O co oo Tr M N W O LD N 00 M O U C O N Q ~ E a) Co U Co N 00 O f0 N Ln > 0. C6 a) n a) cor OV O a o CO (n Building Services - 620 Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 424,000 $ 529,500 $ 105,500 Revenues Cleaning/Maintenance 122,535 106,063 (16,472) Insurance Reimbursement - 9,331 9,331 Utility Reimbursement 3,000 2,516 (484) Facilities Charge to State 141,012 117,496 (23,516) Miscellaneous - 4,415 4,415 Interest on Investments 2,250 2,835 585 Interfund contract 7,500 7,500 (0) Interfund charges - other - 1,125 1,125 Building Svcs Indirect Chgs 1,493,422 1,493,422 - Total Revenues 1,769,719 1,744,703 (25,016) Transfers In 25,279 - (25,279) TOTAL RESOURCES 2,218,998 2,274,203 55,206 REQUIREMENTS: Expenditures Personal Services Materials and Services Transfer to Veh Reserve Capital Outlay Contingency 100% n/a $ 424,000 $ 529,500 $ 105,500 75% 65% 163,380 163,380 - 75% n/a - 9,331 9,331 75% 63% 4,000 4,000 - 75% 62% 188,016 188,016 - 75% n/a - 4,415 4,415 75% 95% 3,000 4,000 1,000 75% 75% 10,000 10,000 - 75% n/a - 1,125 1,125 75% 75% 1,991,229 1,991,229 - 75% 74% 2,359,625 2,375,496 6,540 75% n/a 33,705 33,705 - 75% 81% 2,817,330 2,938,701 112,040 Exp. 1,260,514 1,276,545 (16,031) 75% 76% 1,680,685 1,680,685 - 571,919 574,158 (2,239) 75% 75% 762,558 762,558 - 29,700 29,700 - 75% 75% 39,600 39,600 - 75 - 75 75% 0% 100 - 100 250,790 - 250,790 75% 0% 334,387 - 334,387 TOTAL REQUIREMENTS 2,112,998 1,880,402 232,595 75% 67% NET (Resources - Requirements) 106,000 393,801 287,801 Beginning NWC Per FY 2013 Proposed Budget 2,817,330 2,482,843 334,487 - 455,858 446,527 415,000 Admin Services - 625 Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 183,000 $ 158,276 $ (24,724) 100% Revenues Miscellaneous - 90 90 75% Interest on Investments - 501 501 75% Admin Dept Indirect Chgs 661,304 661,303 (0) 75% Total Revenues 661,304 661,895 591 75% Transfers In-General Fund 147,838 30,000 (117,838) 75% TOTAL RESOURCES 992,141 850,171 (141,970) 75% REQUIREMENTS: Expenditures Personal Services Materials and Services Transfer to Veh Reserve Capital Outlay Contingency TOTAL REQUIREMENTS n/a $ 183,000 $ 158,276 $ (24,724) n/a - 90 90 n/a - 600 600 75% 881,738 881,738 - 75% 881,738 882,428 690 15% 197,117 197,117 - 67% 1,261,855 1,237,821 (24,034) Exp. 645,952 739,516 (93,565) 75% 86% a) 861,269 921,828 (60,559) 81,486 69,250 12,236 75% 64% 108,648 108,648 - 2,700 2,700 - 75% 75% 3,600 3,600 - 75 - 75 75% 0% 100 100 - 216,179 - 216,179 75% 0% 288,238 - 288,238 946,391 811,466 134,925 75% 64% NET (Resources - Requirements) 45,750 38,705 (7,045) Beginning NWC Per FY 2013 Proposed Budget 1,261,855 1,034,176 227,679 b) - 203,645 203,645 140,000 a) YTD actual includes payout to County Administrator. Projection is YTD Actual plus 3 months at March actual. new County Administrator. BOCC - 628 Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 115,000 $ 114,142 $ (858) 100% n/a $ 115,000 $ 114,142 $ (858) Revenues Sale Map Photo or Copies - 11 11 75% n/a - - - Interest on Investments 375 539 164 75% n/a 500 800 300 Admin Dept Indirect Chgs 270,615 270,615 0 75% 75% 360,820 360,820 - Total Revenues 270,990 271,164 174 75% 75% 361,320 361,620 300 Transfers In-General Fund 4,351 - (4,351) 75% n/a 5,801 5,801 - TOTAL RESOURCES 390,341 385,306 (5,034) 75% 80% 482,121 481,563 (558) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS Exp. 253,248 253,728 (480) 75% 75% 337,664 337,664 - 67,171 72,399 (5,228) 75% 81% 89,561 89,561 - 75 - 75 75% 0% 100 - 100 41,097 - 41,097 75% 0% 54,796 - 54,796 361,591 326,127 35,464 75% 68% 482,121 427,225 54,896 - 54,338 54,338 60,000 NET (Resources - Requirements) 28,750 59,180 30,430 Beginning NWC Per FY 2013 Proposed Budget Finance - 630 Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital $ 603,000 $ 788,522 $ 185,522 100% n/a Revenues Investment Fee 30,000 32,202 2,202 75% 81% Photo copies 113 401 289 75% 267% IGA Contracts 11,585 - (11,585) 75% 0% Interest on Investments 3,000 3,658 658 75% 91% Interfund Contracts 9,000 9,000 - 75% 75% Finance Dept Indirect Chgs 620,906 620,905 - 75% 75% Total Revenues 674,603 666,166 (8,437) 75% 74% Transfers In - Gen Fund TOTAL RESOURCES 1,277,603 1,454,688 177,085 75% 96% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance Exp. $ 603,000 $ 788,522 $ 185,522 40,000 42,000 2,000 150 401 251 15,446 15,446 - 4,000 5,000 1,000 12,000 12,000 - 827,874 827,874 - 899,470 902,721 3,251 16,154 16,154 - 1,518,624 1,707,397 188,773 678,848 635,883 42,965 75% 70% 905,131 865,131 40,000 206,177 205,035 1,142 75% 75% 274,902 274,902 - 7,500 - 7,500 75% 0% 10,000 - 10,000 246,443 - 246,443 75% 0% 328,591 - 328,591 TOTAL REQUIREMENTS 1,138,968 - 840,918 298,050 75% 55% NET (Resources - Requirements) 138,635 613,770 475,135 Beginning NWC Per FY 2013 Proposed Budget 1,518,624 1,140,033 378,591 567,364 567,364 540,000 Legal-640 Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 148,500 $ 154,921 $ 6,421 100% nla Revenues Sale Map Photo or Copies 225 123 (102) 75% 41% Miscellaneous 750 6 (744) 75% 1% Interest on Investments 1,125 1,041 (84) 75% 69% Interfund Contract 7,125 - (7,125) 75% 0% Legal Counsel Indirect Chgs 565,974 565,974 0 75% 75% Total Revenues 575,199 567,144 (8,055) Transfers In - Gen Fund TOTAL RESOURCES 723,699 722,065 (1,634) 75% 78% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS Exp. $ 148,500 $ 154,921 $ 6,421 300 300 - 1,000 1,000 - 1,500 1,500 - 9,500 9,500 - 754,632 754,632 - 766,932 766,932 - 10,809 10,809 - 926,241 932,662 6,421 563,639 504,604 59,036 75% 67% 751,519 751,519 - 33,482 32,666 815 75% 73% 44,642 44,642 - 75 - 75 75% 0% 100 - 100 97,485 - 97,485 75% 0% 129,980 - 129,980 694,681 537,270 157,411 75% 58% 926,241 796,161 130,080 NET (Resources - Requirements) 29,018 184,796 155,777 - 136,501 136,501 Beginning NWC Per FY 2013 Proposed Budget 150,000 Personnel - 650 Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Interest on Investments Personnel Indirect Chgs Total Revenues Transfers In - Gen Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 305,500 $ 360,650 $ 55,150 100% nla $ 305,500 $ 360,650 $ 55,150 750 306 (444) 75% 31% 1,000 306 (694) 2,250 1,987 (263) 75% 66% 3,000 3,000 - 543,998 543,998 0 75% 75% 725,330 725,330 - 546,998 546,291 (707) 75% 75% 729,330 728,636 (694) 12,463 12,463 - 852,498 906,940 54,443 1,047,293 1,101,749 54,456 Exp. 457,938 446,098 11,840 75% 73% 610,584 610,584 - 230,557 128,413 102,144 75% 42% 307,409 230,000 77,409 75 - 75 75% 0% 100 - 100 96,900 - 96,900 75% 0% 129,200 - 129,200 TOTAL REQUIREMENTS 785,470 574,511 210,959 75% 55% 1,047,293 840,584 206,709 NET (Resources - Requirements) 67,028 332,429 265,402 - 261,165 261,165 Beginning NWC Per FY 2013 Proposed Budget 290,000 Information Tech - 660 Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Interest on Investments Leases I T Indirect Chgs Total Revenue Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 513,000 $ 650,653 $ 137,653 100% n/a $ 513,000 $ 650,653 $ 137,653 - 106 106 75% n/a - 106 106 3,000 3,727 727 75% 93% 4,000 4,000 - 15,750 24,298 8,548 75% 116% 21,000 30,000 9,000 1,517,434 1,517,434 (0) 75% 75% 2,023,245 2,023,245 - 1,536,184 1,545,565 9,381 75% 75% 2,048,245 2,057,351 9,106 Transfers In-General Fund 73,388 49,500 (23,888) 75% 51% 97,851 97,851 - TOTAL RESOURCES 2,122,572 2,245,717 123,145 75% 84% 2,659,096 2,805,855 146,759 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. 1,371,122 1,288,323 82,799 75% 70% 1,828,162 1,828,162 - 388,564 260,534 128,029 75% 50% 518,085 518,085 - 75 - 75 75% 0% 100 - 100 234,562 - 234,562 75% 0% 312,749 - 312,749 TOTAL REQUIREMENTS 1,994,322 1,548,857 445,465 75% 58% NET (Resources - Requirements) 128,250 696,860 568,610 Beginning NWC Per FY 2013 Proposed Budget 2,659,096 2,346,247 312,849 459,608 459,608 568,550 IT Reserve - 661 Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Interest Donations (Energy Trust) IT Reserve Charges Total Revenue Year to Date Revised Year End Budget Actual Variance W% C011. % Budget Projection Variance $ 304,896 $ 340,594 $ 35,698 100% n/a $ 304,896 $ 340,594 $ 35,698 1,125 2,084 959 75% 139% 1,500 2,750 1,250 - 5,140 5,140 75% n/a - 5,140 5,140 175,500 175,500 0 75% 75% 234,000 234,000 - 176,625 182,724 6,099 75% 78% 235,500 241,890 6,390 TOTAL RESOURCES 481,521 523,318 41,797 75% 97% REQUIREMENTS: Exp. Expenditures Materials and Services 83,625 38,919 44,706 75% 35% Capital Outlay 74,250 43,848 30,402 75% 44% Res for Future Expenditure 247,422 - 247,422 75% 0% TOTAL REQUIREMENTS 405,297 82,767 322,530 75% 15% NET (Resources - Requirements) 76,224 440,552 364,328 Beginning NWC Per FY 2013 Proposed Budget 540,396 582,484 42,088 111,500 99,000 329,896 111,500 - 99,000 - - 329,896 540,396 210,500 329,896 - 371,984 371,984 365,593