The URL can be used to link to this page

Home My WebLink About2012-04-23 Work Session Minutes Minutes of Board of Commissioners’ Work Session Monday, April 23, 2012 Page 1 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 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 expl ain 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 2 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 go od 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 3 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 1% 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. DATED this ?/!-Day of_-'--_--,f-/ 2012 for the ~______ Deschutes County Board ofCommissi~ Anthony DeBone, Chair Alan Unger, Vice Chair ATTEST: ~~ Recording Secretary Tammy aney, Com~issioner Minutes of Board of Commissioners' Work Session Monday, April 23, 2012 Page 4 of4 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 ojCommissioners' meeting rooms at 1300 NW Wall St., Bend. unless otherwise indicated. Ifyou 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 TIY. Please call (541) 388-6571 regarding alternative formats or for fooher 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. Dennis Smeage Executive Director Sunriver Area Chamber of Commerce Attachments 3 5:17 PM Sunriver Area Chamber of Commerce 04120/12 Accrual Basis Visitor Center Revenue and Expense July 1, 2011 through March 31, 2012 Income 400000 . Publications Advertising 405000 . Web Advertising 410000' Visitor Center Advertising 415000' Affinity Rebates 440000 . Service Fees 445000 . Grants &Contracts 450000 . Interest Income 455000 . Membership Dues 465000 . Miscellaneous Ineome 477000 . Special Event Sponsorships 490000 . Special Event Ticket Sales Totallneome Gross Profit Expense 600000 . Advertising Expense 602000 . Bank Fees 604000 . Dues and Subscriptions 608000 . Equipment Rental &Maintenance 610000' Food & Beverage 614100 . Insurance· Dir &Off 614200 . Insurance· General Liability 614300 . Insurance -Workers Comp 618000 . Postage &Shipping 620000 . Printing &Copying 622100' Professional Fees -Accounting 626000 . Rent 626100· Utilities 628100· Services -Compu Prog &Maint 628400 . ServiCes -Website Development 628500 . Services -Website Hosting 632100' Supplies· Office 634000' Telephone &Telecommunications 638100· Payroll Expenses -Empl Benef 638200 . Payroll Expen -Salaries 638300 . Payroll Expenses -Payroll Tax 638400 . Payroll Expenses -Hourly Total Expense Net Income Visitor Center Chamber Funding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 134.00 0.00 114.00 1,847.60 0.00 0.00 885.60 0.00 255.64 702.02 0.00 5.022.72 667.40 0.00 0.00 679.44 127.98 1.171.86 0.00 0.00 198.19 1.710.00 13,516.45 -13.516.45 Visitor Center County Funding 0.00 0.00 0.00 0.00 0.00 16,004.25 0.00 0.00 0.00 0.00 0.00 16,004.25 16,004.25 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 14,366.25 1,638.00 0.00 16,004.25 0.00 AI/Chamber YTD 1,600.00 3,465.00 1,800.00 885.06 30.00 16,004.25 18.76 25,507.50 11,235.00 2,700.00 125.00 63,370.57 63,370.57 268.00 486.11 164.00 2.757.64 1,880.96 744.00 1.107.00 242.35 569.08 1,468.49 1,494.50 6,278.40 828.03 180.00 1,093.62 1.341.00 914.14 1,464.81 1.440.00 22,800.00 2,992.10 1,710.00 52.224.23 11.146.34 Page 1 of1 5:17 PM Sunriver Area Chamber of Commerce 04120/12 Accrual Basis Visitor Center Revenue and Expense July 1, 2011 through June 30,2012 (projected) Income 400000 . Publications Advertising 405000 . Web Advertising 410000· Visitor Center Advertising 415000· Affinity Rebates 425000· Contributions & Gifts 440000 • Service Fees 445000· Grants & Contracts 450000 • Interest Income 455000 • Membership Dues 465000 • Miscellaneous Income 470000 • Raffle Sales 477000 • Special Event Sponsorships 490000 • Special Event Ticket Sales Total Income Gross Profit Expense 600000 . Advertising Expense 602000 • Bank Fees 604000 • Dues and Subscriptions 608000 • Equipment Rental & Maintenance 610000· Food & Beverage 612000· Grants to Other Organizations 614100' Insurance· Dir & Off 614200· Insurance· General Liability 614300' Insurance· Workers Comp 618000 . Postage & Shipping 620000 . Printing & Copying 622100 . Professional Fees· Accounting 624000 • Publications 626000 . Rent 626100 • Utilities 628100' Services· Compu Prog & Maint 628400 • Services· Website Development 628500 • Services· Website Hosting 632100' Supplies· Office 634000 . Telephone & Telecommunications 638100 . Payroll Expenses· Empl Benef 638200 • Payroll Expen • Salaries 638300 • Payroll Expenses· Payroll Tax 638400 • Payroll Expenses· Hourly Total Expense Net Income Visitor Center Chamber Funding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 134.00 0.00 114.00 2,600.00 0.00 0.00 885.60 0.00 360.00 972.72 0.00 6.959.48 924.75 0.00 0.00 996.93 195.00 1,623.73 0.00 0.00 198.19 1,710.00 17,674.41 Visitor Center County Funding 0.00 0.00 0.00 0.00 0.00 21.339.00 0.00 0.00 0.00 0.00 0.00 21,339.00 21,339.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 19.155.00 2.184.00 0.00 21,339.00 0.00 All Chamber Annual 2,400.00 6,390.00 2.400.00 1.056.00 1,740.00 36.00 26,339.00 48.00 26,005.00 750.00 555.00 1,600.00 10,225.00 79,544.00 79.544.00 6,223.00 586.00 329.00 3,020.24 5,500.00 2,425.00 744.00 1,107.00 245.00 775.00 1,676.00 1,759.00 1.150.00 8.784.00 1.047.00 200.00 1.995.00 1.788.00 880.00 1,956.00 1,920.00 28,800.00 3,741.76 1,740.00 78,391.00 1,153.00 Page 1 of 1 SUNRIVER AREA CHAMBER OF COMMERCE Visitor Center Statistics -July 1, 2011 through March 31, 2012 TOTAL Same Period Jul Aug Sep Oct Nov Dec Jan Feb Mar I JuI'U -....'U Last Year INQUIRIES Walk-in -Local Walk-in -Out of Area Walk-in -Out of State Walk-in -International Phone -Local Phone -Out of Area Phone -Out of State Phone -International 27 31 3 4 6 12 2 2 7 14 77 403 595 89 40 56 97 19 29 55 1;181 998 231 319 11 6 8 28 7 1 12 &21 292 3 29 2 - 3 2 2 a. 60 10 11 1 4 2 2 1 11 20 44 56 9 3 11 9 24 8 21 .III 270 12 7 5 6 7 17 5 11 1 ft. 31 1 -1 0 Email -Local 1 1 a 4 Email-Out of Area 8 2 2 1 2 2 1 1 1 20 42 Email -Out of State 4 1 5 2 1 4 8 4 1 10' 19 Email -International 0 0 ITOTAllNQUIRIES 743 1,051 124 65 95 173 68 61 101 2,481 1,813 VISITOR PACKET REQUESTS Local . O. 0 Out of Area 21 9 15 8 10 4 1 15 17 .* I 99 Out of State 48 41 33 17 40 10 31 55 37 .. 218 International 5 2 6 5 5 5 4 1 7 10 27 TOTAL VISITOR PKT REQUESTS 74 52 54 30 55 19 36 71 61 • 344 RELOCATION PKT REQUESTS 5 9 9 7 5 8 41 77 ITOTAl ALL PACKET REQUESTS 79 61 63 37 55 19 41 79 61 495 421 I~EB SITE VISITS I I 4,327 3,671 2,144 I 1,584 I 1,653 1,840 I 2,227 2,250 I 2,472 22,168 22,312 IINFO MATERIALS DISTRIBUTED (Inventoried & calculated as ofJune 30,2012) THE SUNRIVER AREA CHAMBER OF COMMERCE IS GOING MOBILE I Announcing the launch of our Chamber's new MOBILE WEB APP! We've invested in the NEWEST technology to put YOUR business in front ofthe 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 MOBILE WEB APP. 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 MOBILE WEB APp, 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 MOBILE WEB APP 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 WEB APP launches on February 1 st, 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 I I i I Commercial Paper $ Corporate Notes 12.963.439 Time Certificates 9,255,254 U. S. Treasuries Federal Agencies 17,134,233 Bankers' Acceptances LGIP/BOTC 88,162,110 Total Investments $ 127,515,036 Total Portfolio: By Investment Types Corporate Time Notes Certificates 10% 7% Federal Agencies 14% LGIP/BOTC 69% 0.00% 10.17% 7.26% 0.00% 13.44% 0.00% 69.14% 100.00% - Investments By County Function General $ 127,515 ,036 Total Investments $ 127,515,036 Total Investment Income Less Fee : 5% of Invest. Income Investment Income -Net Investment Income Fiscal Year 2011-12 Mar-12 I I Y-T-D $ 67 ,543 $ 643 ,931 -- 67,543 643,931 (3,377) (32,197 $ 64,165 $ 611,735 ' Category Maximums: U.S. Treasuries 100% ILGIP 100% ~Federal Agencies 75% Banker's Acceptances 25% Time Certificates 25% Commercial Paper 20% Corporate Notes 10% c t 3 Month T reas. ~ 0.07% 12 Month Treas. ~ 0.18% 3 Month C P ~ 0,18% Average Maturity in Days General ---628 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 GENERAL FUND Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End $ Actual Variance 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 FinancefT ax 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: 1 Exp. %1 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 FinancefT ax 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 12,442,405 e) 34,697 8,310,865 8,276,168 Beginning Net Working Capital per Proposed Budget 8,300,000 I 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 Year to Date Budget I Actual I Variance IFY% I Coil. % RESOURCES: Beg, Net Working Capital Revenues Federal Grants SB #1 065-Court Assess. Discovery Fee Food Subsidy OVA 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 $1,101,374 7,500 37,500 11,250 18,750 163,124 66,368 75 52,500 45 30 225 5,625 1,800 375 4,500 115,596 15,000 $1,099,010 $ (2,364) 100% 100% 4,267 (3,233) 75% 43% a) 36,803 (697) 75% 74% 9,880 (1,370) 75% 66% 16,312 (2,438) 75% 65% 181,704 18,580 75% 84% b) 46,150 (20,218) 75% 52% c) 220 145 75% 220% 72,334 19,834 75% 103% d) 301 256 75% 502% e) (30) 75% 0% 970 745 75% 323% e) 6,207 582 75% 83% 1,000 (800) 75% 42% f) 788 413 75% 158% 1,660 (2,840) 75% 28% g) 71,434 (44,162) 75% 46% h)i) 10,000 {5,000~ 75% 50% i) Budget Year End Projection Variance $1,101,374 $1,099,010 $ 10,000 10,000 50,000 50,000 15,000 15,000 25,000 25,000 217,498 355,730 88,490 60,000 100 250 70,000 100,000 60 400 40 40 300 1,200 7,500 8,400 2,400 1,200 500 850 6,000 2,200 154,128 134,620 20,000 20,000 (2,364) 138,232 (28,490) 150 30,000 340 900 900 (1,200) 350 (3,800) (19,508) Total Revenues 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 3,831,802 914,800 30,075 37,800 502,910 3,687,485 834,682 37,800 144,317 80,118 30,075 502,910 75% 75% 75% 75% 75% Exp. %1 72% j) 68% b)h) 0% 75% n/a 5,109,069 1,219,733 40,100 50,400 670,547 4,958,044 1,139,800 40,100 50,400 151,025 79,933 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,41 5 1 a) Federal Grant billing, reimbursed quarterly in arrears--$2,665 outstanding b) OVA 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 Page 2 i) Grants paid quarterly-$5,000 outstanding payment for General Fund Grant-Crime Prevention 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 Year to Date Actual Varial1ce RESOURCES: 8eg. Net Working Capital $ Revenues Law Enf Dist Co untywid e 16 ,563 ,6 16 ...-~- Total Revenues 27,400,137 TOTAL RESOURCES 27,400,137 REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 1,937,956 Civil 618,071 Automotive/Communications 1,216,655 Investigations/Evidence 1,300,664 Patrol/Civil/Comm Supp 6,003,528 Records 540,533 Adult Jail 7,879,895 Court Security 214,952 Emergency Services 139,219 Special Services Division 1,001,371 Regional Work Center 2 ,263,850 Training Division 243,1199 Other Law Enforcement Svcs 474,192 Non-Departmental 54,923 Contingency 3,361,131 Transfers Out -DIS Fund 150,000 $ $ 13,490,234 (3,073 ,382) 22,134,532 (5,265,605) 22,134,532 (5,265,605) 1,872,694 65,262 558 ,536 59,535 1,184,433 32,222 1,086,008 214,656 5,877,266 126,262 472,913 67,620 7 ,005 ,719 874,176 208,468 6 ,484 128,929 10,290 822,423 178,948 2 ,118,337 145,513 186,600 56,599 457,283 16,909 54,923 (0) 3,361,131 100,000 50,000 TOTAL REQUIREMENTS 27,400,139 22,134,532 5,265,607 NET (Resources· Requirements ) 100% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% n/a 61% 60% 61% * * 61% Exp. %1 72% a) 68% b) 73% c) 63% b) 73% d) 66% 67% e) 73% 69% 62% 70% b) 58% 72% 75% n/a 50% f) 61% Revised Year End Budget Projection Variance $ $ $ 18 ,799,678 ~--~--~~~~~~~~~~~ 30,641,554 36 ,533,516 30,641,554 (5,891,962) 2 ,583 ,941 2,552,941 31,000 824 ,095 748,995 75 ,100 1,622 ,207 1,693,1.07 (70,900) 1,734 ,218 1,520,664 213 ,554 8 ,004 .704 7,862,704 142 ,000 720 ,710 694 ,610 26 ,100 10 ,506 ,52 7 9,802 ,527 704 ,000 286 .602 275,402 11 ,200 185,625 175,525 10,100 1,335 ,16 1 1,307,161 28,000 3 ,018,466 2,835,366 183,100 324 ,26 5 285,165 39,100 632 ,256 614,156 18 ,100 73 ,231 73,231 4 ,481 ,508 4,481,508 200 ,000 200,000 36,533 .516 30,641,554 5.891,962 * 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 Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data N i ne Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital $5,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 % 99% 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 % 87 % 35 ,200 35,200 State Grant 36,356 37,701 1,345 75% 78 % 48,475 48,475 Transp. of State Wards SB 1145 Prisoner Housing Des. Cty Video lottery Grant 3 ,750 1,153,247 3,750 6,304 1,109,994 77,809 5 ,000 2 ,554 (43,253) 77,809 1,250 7 5% 75% 75% 75 % 126% 72% n/a 100% a) b) 5,000 1,537,663 5,000 7 ,000 1,479,991 78,087 5,000 2 ,000 (57,672) 78 ,087 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 III Reimbursement Transport Other 112,500 750 40,358 465 3 ,570 (72,142) (285) 3,570 75% 75% 75% 27% 46% n/a c) 150,000 1,000 150,000 1,000 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% 61% 50,000 50 ,000 Concealed Handgun Classes 2,625 3,225 600 75 % 92 % 3 ,500 3,500 Inmate Telephone Fee Soc Sec Incentive-Fed 36,000 3 ,750 69,069 7 ,200 33,069 3 ,450 75% 75% 144% 144% d) 48,000 5,000 84,000 9,000 36,000 4 ,000 Miscellaneous 3,750 6,854 3,104 75 % 137% 5 ,000 7,000 2,000 Oregon Mentors Debit Card Fee 11,250 6,039 158 (5,211 ) 158 75 % 75% 40% n/a 15,000 15,000 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 % 35 % 5 ,000 5,000 Sheriff Fees 150,000 170,154 20,154 75% 85% 200,000 200,000 Interest 21,250 37 ,357 16,107 75% 132% 28 ,333 42,000 13 ,667 Interest on Unsegregated 2,650 1,253 (1,397) 75 % 35% 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% 97% 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: 1 Exp . %1 Fund 255 Departments: Sheriffs Services 1,817,783 1,756,568 61 ,215 75% 72% 2,423,711 2,394,633 29,078 Civil 618,071 558,536 59,535 75% 68% 824,095 748 ,995 75 ,100 AutolComm 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% 69% 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% 70% 3 ,018 ,466 2,835,366 183,100 Training 148,470 113,918 34,553 75% 58% 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 DIS 150,000 100,000 50 ,000 75% 50% 200,000 200,000 Contingency 1,678,244 1 ,678,244 75% 0 % 2,237,659 2,237 ,659 T otal 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% 100% 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 Capital per Proposed Budget 4 ,507,3521 • 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 Page 4 c) Reimbursement requested semiannually in January and June d) Change to new vendor resulting in revenue increase e) Accounting change for Shop w ith a Cop donations Fund 702 LED Rural Statement of Financial Operating Data Nine Months Ended March 31,2012 Variance I FY % 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,1 25 7 ,426 ,095 77,970 T ax Revenues -Prior 192 ,750 297 ,833 105,083 75% 116% 257 ,000 31 2 ,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) 7 5% nfa 25,00 0 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 SB #1065 Court Assessment 45 ,000 36,803 (8 ,197) 75 % 6 1% 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 Cly 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,8 56 2 ,183,856 110 ,000 Des Cly Tax/Fin Contract 540 540 75 % 540 540 Cily of Sisters 337,471 337,471 (0) 75% 75 % 449,961 449,961 Des Cly CDD Contract 40 ,775 40,775 (1 ) 75 % 75 % 54,366 54 ,366 Des Cly Solid Waste Contr 40 ,775 40 ,775 (1 ) 75 % 75 % 54 ,366 54 ,366 Des Cly Clerk/Elect ion 1,500 (1 ,500) 75 % 0% 2 ,000 2,000 School Districts 60 ,000 12,317 (47 ,683) 75 % 15% d) 80,0 00 40 ,000 (40,000) Cla ims Reimbursement 2,750 2 ,750 75 % nla 2,750 2 ,750 Securily & 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,0 00 14,000 6 ,000 False Alarm Fees 1,500 1,400 (100) 75% 70% 2 ,000 2 ,000 Restitution 2 ,169 2 ,169 75% nla 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 % 8 1% 115,0 00 115,000 Impound Fees 5,250 3,400 (1,850) 75 % 49 % 7,000 7,000 Restitution -Street Crimes 375 (375) 75% 0% 500 500 Seizure/Forfeiture 1,324 1,324 75 % nfa 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 % nfa 7,000 7,000 Donations 10,155 10,155 75 % nfa 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 ,0 00 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: I Exp . % 1 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 ,1 93 1,059,563 (44 ,370) Investigations 1,300,664 1,086,008 214,655 75 % 63 % 1,734,2 18 1,52 0 ,664 213 ,554 Patrol 6 ,003 ,528 5,877,266 126,262 75 % 73% 8,004,7 04 7 ,86 2,704 142 ,000 Records 540 ,533 472,913 67,619 75 % 66% 720,71 0 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 11 1,075 15,230 Non Dept -ISF Charges 27,407 27,407 75 % 75% 36, 542 36,542 Continge ncy 1,682 ,887 1,682,887 75 % 0% 2,243,849 10 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 ,6 95 11 ,94 1,876 2 ,606 ,819 Net 734 ,133 4 ,232 ,316 3 ,498 ,183 2,88 5,721 2 ,885 ,721 Beginning Net Working Capital per Proposed Budget 2 ,859 ,915 1 • Payment to Sheriffs Fund adjusted monthly to equal actual expenditures aMributable to rural services . a) Reimbursement requested sem iannually 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 Actual Variance 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% alb) 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% nla 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 __~1~1=.2~9~2____~1~1=,2~9~2________~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 4.643.049 4,529.327 113.722 1.574,021 1,377.345 196.676 98.625 98,625 214,500 214,500 592,858 592,858 --~~~--------------~~~ I Exp.%1 75% 73% 75% 66% 75% 0% 75% 75% 75% nla 6,190,732 2,098,694 131,500 286,000 790,477 6,100,000 1,904,960 100.000 286,000 90,732 193,734 31,500 790,477 TOTAL REQUIREMENTS 7,123,053 6,121,172 1,001,881 75% 64% 9,497,403 8,390,960 1,106,443 NET (Resources -Requirements) 399,230 1,447,379 1,048,149 1.338,634 1,338,634 Beginning Net Working Capital per Proposed Budget 1,336,051 I 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,OOO) and 2) Pool & Spa Fee (FY 2012 Page 6 Budget=$110,000). These are due annually and collected primarily in December and January BEHAVIORAL HEALTH Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Actual Variance Variance RESOURCES: Beg. Net Working Capital $3,268,759 $ 3,108,163 $ (160,596) 100% 95% $3,268,759 $3,108,163 $ (160,596) Revenues Marriage Licenses 4,125 4,175 50 75% 76% 5,500 5,600 100 Divorce Filing Fees 99,750 112,736 12,986 75% 85% 133,000 150,000 17,000 Domestic Partnership Fee 75 65 (10) 75% 65% 100 100 Federal Grants 207,485 152,978 (54,507) 75% 55% 276,647 276,647 State Grants 5,223,152 5,776,880 553,728 75% 83% a) 6,964,202 7,566,736 602,534 State Miscellaneous 93,130 30,930 (62,200) 75% 25% b)c) 124,173 61,860 (62,313) ABHA 164,728 164,728 75% n/a d) 170,000 170,000 Title 19 211,723 87,572 (124,151) 75% 31% 282,297 177,300 (104,997) Liquor Revenue 78,750 82,505 3,755 75% 79% 105,000 141,500 36,500 School Districts 56,700 55,850 (850) 75% 74% 75,600 75,600 Miscellaneous 10,500 5,665 (4,835) 75% 40% 14,000 14,000 Patient Insurance Fees 85,275 145,179 59,904 75% 128% 113,700 170,000 56,300 Patient Fees 1,355 805 (550) 75% 45% 1,807 1,150 (657) Interest on Investments 18,750 19,288 538 75% 77% 25,000 26,700 1,700 Rentals 9,825 9,000 (825) 75% 69% b) 13,100 13,100 Donations 108 108 75% n/a 200 200 Administrative Fee 3,322,267 3,276,553 (45,714) 75% 74% 4,429,689 4,429,689 Sheriff 15,000 (15,000) 75% 0% e) 20,000 (20,000) Interfund Contract-Gen Fund 95,250 73,319 (21,931 ) 75% 58% b) 127,000 127,000 Comm. on Children & Fam 725 725 75% n/a 725 725 Total Revenues 9,533,112 9,999,061 465,949 75% 79% 12,710,815 13,407,907 697,092 Transfers In-General Fund Transfers In-OHP-CDO Transfers In-Acute Care Svcs Transfers In-ABHA 947,637 203,552 189,387 225,647 947,637 297,059 189,387 290,605 93,506 64,958 75% 75% 75% 75% 75% 109% 75% 97% f) 1,263,515 271,402 252,515 300,863 1,263,515 396,077 252,515 387,473 124,675. 86,610 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 14,368,094 7,821,140 4,335,562 311,250 214,500 868,451 14,831,912 7,065,818 3,995,972 106,533 214,500 463,817 755,322 339,590 204,717 868,451 75% 82% 1 Exp. %1 75% 68% 75% 69% 75% 26% 75% 75% 75% n/a 18,067,869 10,428,186 5,780,749 415,000 286,000 1,157,934 18,815,650 9,483,682 5,265,100 415,000 286,000 747,781 944,504 515,649 1,157,934 TOTAL REQUIREMENTS 13,550,903 11,382,823 2,168,081 75% 63% 18,067,869 15,449,782 2,618,087 NET (Resources -Requirements) 817,191 3,449,090 2,631,898 3,365,868 3,365,868 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 Sheriff's Department eliminated f) Transfer made quarterly 3,320,968 I Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Nine Months Ended March 31, 2012 Budget YearEnd Projection Variance Year to Date Budget I Actual I Variance I FY% I Coli. % 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 Trans In-GF Trans In-GF for Lng Rng Ping Trans In.other TOTAL RESOURCES REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Pgm Planning-Current Planning-Long Range Transfers Out (DIS Fund) Contingency 229,822 18,263 750 125,025 900,660 194,363 120,150 210,300 506,175 190,295 131,776 $ 20,357 1,531 129,909 732,551 167,520 62,467 204,672 409,665 178,132 (98,046) 2,094 781 4,884 (168,109) (26,843) (57,683) (5,628) (96,510) (12,163) 2,265,981 1,906,804 (359,177) 547,221 472,221 (75,000) 371,520 371,520 75 {75} 3,414,619 2,882,321 (532,298) 1,058,864 1,053,567 5,297 95,816 93,048 2,768 153,428 155,910 (2,482) 421,524 413,555 7,969 178,065 162.601 15,464 124,267 128,565 (4.298) 107,331 110,437 (3,106) 464,252 441,059 23,193 359.105 329,489 29,616 130,414 160,242 (29,828) 264,096 264,096 100% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 57% 84% 153% 78% 61% 65% 39% 73% 61% 70% 63% 65% 75% 0% 64% Exp·%1 75% 73% 76% 74% 68% 78% 77% 71% 69% 92% nla a) b) b) c) b) d) e) f} d) g) $ 229,822 $ 131,776 (98,046) 24,350 26,500 2,150 1,000 2,000 1,000 166,700 173,000 6,300 1,200,880 1,030,575 (170,305) 259,150 232,800 (26,350) 160,200 106,100 (54,100) 280,400 295,000 14,600 674,900 610,000 (64,900) 253,726 237,500 (16,226) 3,021,306 2,713,475 (307,831) 729,625 729,625 495,360 495,360 100 {1ool 4,476,213 4,070,236 (405,977) 1,411,818 1,403,590 8,228 127,755 123,990 3,765 204,570 210,679 (6.109) 562,032 551,447 10,585 237,420 230.040 7,380 165.689 171,713 (6,024) 143.108 144,862 (1,754) 619,002 608,794 10,208 478,806 452,033 26,773 173.885 173.885 352.128 352.128 TOTAL REQUIREMENTS 3,357,162 3,048,474 308,688 75% 68% 4,476,213 4,071,033 405,180 NET (Resources -Requirements) 57,457 (166,153) {223.610} (797) (797) Beginning Net Working Capital per Proposed Budget Revenues 1,906,804 Expenditures 3,048,474 Net from Operations (1,141,670) 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) Page 8 4,000 I 3,021,306 2,713,475 (307.831) 4,476,213 4,071,033 405.180 ~1 ,454,907} {1 ,357,558~ 97,349 ROAD Statement of Financial Operating Data Nine Months Ended March 31,2012 Year to Date Budget I Actual I Variance IFY % I Coil. % Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital $3,417,158 $ 3,417,158 $ o 100% 100% $ 3,417,158 $ 3,417,158 $ o Revenues System Development Charge 924 924 75% nfa 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% f) 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% nfa 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: 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% nfa 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 4,720,166 4,720,166 Beginning Net Working Capital per Proposed Budget 4,719,551 I 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 RESOURCES: Beg. Net Working Capital Revenues DOC Measure 57 State Miscellaneous Alternate Incarceration State Subsidy SB 1145 Probation Work Crew Fees Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Interest on Investments Interfund -Sheriff Crime Prevention Grant CFC-Domestic Violence Total Revenues Transfers In-General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS Year to Date Budget I Actual I Variance $ 560,000 $ 634,125 $ 74,125 163,013 3,226 23,189 9,750 2,141,743 18,000 3,075 127,500 150,000 6,750 37,500 37,500 56,124 2,777,370 219,240 4,301 10,370 2,061,417 16,450 1,880 94,061 141,285 4,517 37,500 12,500 37,416 2,640,936 56,227 1,075 (23,189) 620 (80,326) (1,550) (1,195) (33,439) (8,715) (2,233) 0 (25,000) (18,708) (136,434) 253,719 3,591,089 253,719 3,528,780 (62,309) 2,376,516 665,168 75 21,600 387.731 2,266.801 536,796 21,600 109,715 128.372 75 387,731 IFY % I Coil. % 100% 113% 75% 101% 75% 100% 75% 0% 75% 80% 75% 72% 75% 69% 75% 46% 75% 55% 75% 71% 75% 50% 75% 75% 75% 25% 75% 50% 75% 71% 75% 75% 75% 77% 1Exp. %1 75% 72% 75% 61% 75% 0% 75% 75% 75% nfa 3,451,090 2,825,197 625,893 75% 61% Budget YearEnd Projection Variance $ 560,000 $ 634,125 $ 74,125 a) 217,350 219,240 1,890 a) 4,301 4,301 b) 30,918 21,000 (9,918) c) 13,000 13,000 c) 2,855,659 2,748,953 (106,706) 24,000 21,180 (2,820) 4,100 2,100 (2,000) 170,000 125,446 (44,554) i 200,000 182,674 (17,326) I 9,000 9,000 f50,000 50,000 d) 50,000 50,000 d) 74,832 74,832 3,703,160 3,521,726 (181,434) 338,292 338,292 4,601,452 4,494,143 (107,309) e) f) 3,168,688 886,890 100 28,800 516,974 3,084,689 800.000 28,800 83,999 86,890 100 516,974 4,601,452 3,913,489 687,963 NET (Resources -Requirements) 139,999 703,583 563,584 580,654 580,654 570,000 IBeginning Net Working Capital per Proposed Budget 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 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 OCCFGrant Program Fees Charges for Svcs-Mise Court Fines & Fees Interest on Investments Donations Interfund Grants Total Revenues Trans from General Fund Budget $ 467,111 224,616 29,497 71,250 193,487 18,375 233,879 408,902 6,000 58,500 3,750 90,656 1,338,912 204,723 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date I Actual $ 556,143 192,200 30,155 19,205 154,986 79,801 193,653 383,499 2,913 1,161 67,642 3,267 71 240,822 1,369,375 204,723 I Variance $ 89,032 (32,416) 658 (52,045) (38,501) 61,426 (40,226) (25,403) 2,913 (4,839) 9,142 (483) 71 150,166 30,463 IFY % I Coli. % 100% 119% 75% 64% a) 75% 77% alb) 75% 20% a)c) 75% 60% alb) 75% 326% d) 75% 62% a)b) 75% 70% a)b) 75% nfa e) 75% 15% 75% 87% f) 75% 65% 75% nfa e) 75% 199% g) 75% 77% 75% 75% rEnd ction Variance $ 467,111 $ 556,143 $ 89,032 299,488 305,416 5,928 39,329 39,534 205 95,000 85,000 (10,000) 257,982 196,898 (61,084) 24,500 79,801 55,301 311,838 258,203 (53,635) 545,203 509,579 (35,624) 3,500 3,500 8,000 8,000 78,000 79,485 1,485 5,000 5,000 300 300 120,875 320,875 200,000 -----~~~~-----~~~-----~~~~ 1,785,215 1,891,591 106,376 272,960 272,960 Total Transfers In 204,723 204,723 75% 75% 272,960 272,960 TOTAL RESOURCES 2,010,746 2,130,241 119,495 75% 84% 2,525,286 2,720,694 195,408 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 453,839 1,265,234 75 174,816 439,405 858,877 14,434 406,357 75 174,816 I Exp.%1 75% 73% h) 75% 51% i) 75% 0% 75% nfa 605,119 1,686,979 100 233,088 574,945 1,631,476 100 30,174 55,503 233,088 TOTAL REQUIREMENTS 1,893,964 1,298,282 595,682 75% 510/0 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,9941 a) Grant payments received nomnally within 60 days after the end of each quarter b) FY 2012 and FY 20131ntergovemmental 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 SOLID WASTE Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Budget , I Actual I Variance I FY % I Coil. % Budget YearEnd Projection Variance RESOURCES: Beg. Net Working Capital $1,092,508 $ 1,141,691 $ 49,183 100% 105% $1,092,508 $ 1,141,691 $ 49,183 Revenues Miscellaneous 16,500 13,748 (2,752) 75% 62% 22,000 22,000 Franchise 3% Fees 150,000 87,602 (62,398) 75% 44% a) 200,000 200,000 Commercial Disp. Fees 645,000 635,655 (9,145) 75% 74% 860,000 860,000 Private Disposal Fees 985,500 947,209 (38,291) 75% 72% 1,314,000 1,314,000 Franchise Disposal Fees 3,000,000 2,945,198 (54,803) 75% 74% 4,000,000 4,000,000 Yard Debris 54,750 61,563 6,813 75% 84% b) 73,000 80,000 7,000 Special Waste 16,750 4,339 (14,411) 75% 17% c) 25,000 10,000 (15,000) Interest 5,625 6,024 2,399 75% 107% 7,500 9,500 2,000 Leases 1 7,694 7,693 75% nla d) 1 10,394 10,393 Donations 2,660 2,880 75% nla e) 2,860 2,880 Sale of Reportable Assets 16,494 16,494 75% nla f) 16,494 16,494 Recyclables 22,500 57,942 35,442 75% 193% g) 30,000 72,000 42,000 Total Revenues 4,898,626 4,788,546 (110,080) 75% 73% 6,531,501 6,597,268 65,767 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 5,991,134 1,253,699 2,169,789 728,425 129,000 214,330 300,000 187,500 318,000 417,265 5,930,238 1,195,874 1,879,533 396,626 160,800 214,330 200,000 250,000 212,000 (60,896) 57,825 290,256 329,599 (31,800) 0 100,000 (62,500) 106,000 417,265 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 78% Exp. %1 72% 65% 41% 93% 75% 50% 100% 50% nla h) i) 7,624,009 1,671,598 2,893,052 971,233 172,000 285,773 400,000 250,000 424,000 556,353 7,738,959 1,623,665 2,986,418 888,460 179,930 265,773 400,000 250,000 424,000 114,950 47,733 (93,366) 62,773 (7,930) 556,353 TOTAL REQUIREMENTS 5,718,008 4,511,363 1,206,645 75% 59% 7,624,009 7,038,446 585,563 NET (Resources -Requirements) 273,126 1,418,875 1,145,749 700,513 700,513 Beginning Net Working Capital per Proposed Budget 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 700,5131 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 Budget Year End Projection Variance RESOURCES: Beginning Net Working Capital Revenues Inter-fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Workers' Compensation Claims Reimb-Gen Liab/Property Process Fee-Events/Parades Miscellaneous Skid Car Training Interest on Investments Other Interest TOTAL REVENUES Transfers In-General Fund TOTAL RESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Repair I Replacement Total General Liability PROPERTY DAMAGE Insurance Repair / Replacement Total Property Damage VEHICLE Professional Service Insurance Loss Prevention Repair / Replacement Total Vehicle WORKERS' COMPENSATION Settlement / Benefit Insurance Loss Prevention Miscellaneous Total Workers' Compensation UNEMPLOYMENT -Settlement/Benefits Total Direct Insurance Costs Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET Beginning Net Working Capital per Proposed Budget • Contingency is $2,305,693. a) Expenditures are projected to exceed current appropriation. Appropriation transfer is pending. % Coil. $2,100,000 $2,039,937 ($60.063) 250.855 250.855 311,633 311,633 178.310 178,310 1,473,944 1,473.944 252,433 252,433 5.000 5,000 20.000 75,000 55,000 1.500 1,500 50 50 18.000 14,000 (4.000) 15.000 15,000 50 50 2,526.775 2,577,775 51.000 200,000 200,000 4,826.775 4,817,712 (9,063) 400,000 475,000 (75,000) 300,223 260,000 40,223 101,485 90,000 11,485 1,000,000 1,100,000 (100,000) 250,000 250,000 2,051,708 2.175,000 (123.292) 294,357 167.717 100 462,174 294,357 167,717 462,074 100 100 7,200 2,521,082 7,200 2,644,274 {123,192~ 2,305,693 2,173,438 {132,255) I 2,000,000 I Page 13 $2.100,000 188.141 233.725 133.733 1,105,458 189,325 3,750 15,000 1,125 38 13,500 11,250 38 1,895,081 150.000 $2,039,937 188.141 233,725 133,733 1.105,458 189,567 548 64,732 1.250 10.010 10,614 1,937,778 ($60,063) 0 0 (0) 0 242 (3,202) 49,732 125 (38) (3,490) (636) (38) 42,696 ~150,OOOl 100% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 97% 75% 75% 75% 75% 75% 11% 324% 83% 0% 56% 71% 0% 77% 0% 4,145,081 3,977,714 (167,367) 75% 82% I % Ex~. I 300,000 110.210 186,775 677 109,664 5,517 412,843 (112,843) 75% 103% a) 225,167 116.268 67,605 183.873 41,294 75% 61% 76,114 5 376 10,482 51,786 62.649 13.465 75% 620/0 750.000 761,308 96,063 39,065 21,772 918,207 (168,207) 75% 92% a) 187,500 115,474 72.026 75% 46% 1,538,781 1,693,046 (154,265) 75% 83% 220,768 125.788 75 346,631 195,417 103.863 299,280 25.351 21.924 75 47,350 75% 75% 75% 75% 66% 62% 0% 65% 5,400 1,890,812 5,400 1.997,726 ~106,914~ 75% 750/0 75% 79% 2,254,270 1,979,988 ~274,282} * DESCHUTES COUNTY 911 Statement of Financial Operating Data Nine Months Ended March 31,2012 Health Benefits Trust Statement of Financial Operating Data Nine Months Ended March 31. 2012 RESOURCES Beg. Net Working Capital $15,500,000 $ 15,829,888 $ 329,888 100% o $15,500,000 $15,829,888 329,888 Revenues: Intemal Premium Charges 9,011,783 9,053,638 41,855 75% 75% 12.015,711 12,015,711 prr Emp -Add'i Prem 37.500 23,336 (14,164) 75% 47% 50,000 50,000 Employee Prem Contribution 472,500 443,350 (29,150) 75% 70% 630,000 630.000 COIC 945,000 974,632 29,632 75% 77% 1,260,000 1,260,000 Retiree I COBRA Co-Pay 375,000 634,804 259,804 75% 127% 500,000 750,000 250,000 Fees for Clinic Services 200 200 75% n/a 200 200 Federal Payment (ERRP) 150,431 150,431 75% n/a' 150,431 150,431 Prescription Rebates 81.117 81.117 75% n/a 81.117 81,117 Interest ____~60~,~00~0~__~7~8~.9~4~5____~18~,~94~5~ 75% 99% 80,000 100,000 20,000 Total Revenues 10,901,783 11.440,454 538,671 75% 79% 14,535,711 15,037,459 501,748 TOTAL RESOURCES 26,401,783 27,270,342 868,559 92% 103% 30,035,711 30,867,348 831,637 REQUIREMENTS Expenditures: Personal Services 113,414 102,568 10.845 75% 68% 151,218 151,218 Materials & Services Claims Paid-MedicaVRx 9.355,713 9.051,531 304,183 75% 73% a) 12,474,284 11.993,354 480,931 Claims Paid-DentalNision 1.397.980 1,471,348 (73,367) 75% 79% a) 1,863,974 1.949,536 (85,562) Refunds (59,167) 59,167 75% nla (59,167) 59,167 Insurance Expense 262,500 264,746 (2,246) 75% 76% 350,000 350,000 State Assessments 112,500 155,263 (42.763) 75% 104% 150.000 155.263 (5.263) Administration Fee 240.000 238.077 1,923 75% 74% 320.000 320,000 PPO Fee 37.500 36,469 1,031 75% 73% 50.000 50,000 Health Impact 41,250 38,526 2,724 75% 70% 55,000 55,000 Other ___.:.:10::.::5:J.:,8:..:.7.:.2__.:.:10:::6.t.:,5;:::;5O~__..J.(6::.;7:..::8;L.) 75% 75% 141,162 141.162 Admin & Well ness 11,666,729 11,405,910 260,818 75% 73% 15,555,638 15,106,365 449,273 Deschutes On-site Clinic Healthstat 717.900 501,127 216.773 75% 52% 957,200 957.200 Medications/Drugs 243.750 110,585 133.165 75% 34% 325,000 325,000 Medical Supplies 2.250 21,878 (19,628) 75% 729% 3,000 30,000 (27,000) Equipment 3.000 150 2,850 75% 4% 4,000 4,000 Miscellaneous ______4"'.c;.08;;;.;8'--____...;8;.:;;.2;;.;;3;.;;.9____-->.(4..;.:•..;,.15;;..1;.L.) 75% 151 % 5,450 10.000 (4.550) Total DOC 970,988 641,978 329,010 75% 50% 1,294,650 1,326,200 (31,550) Deschutes On-site Pharmacy Remodeling Costs o 60.706 60,706 75% n/a 100,000 (100.000) Total Pharmacy 60,706 (60,706) 75"1. n/s 100,000 (100,000) Capital Outlay 150 150 75% n/a 200 Contingency 9.888.917 9.888,917 75% 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 14,500,000 I NET (Resources -Requirements) 3,761,587 15,161,749 11,297,594 Beginning Net Working Capital per Proposed Budget • Early Retirement Reinsurance Program (ERRP). Federal program to help pay the cost of insuring retirees who are nol yet Medicare eligible. a) PrOjection based on annualizing 40 weeks of claims paid. YTO actual is $261,593 per week. Page 15 200 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 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 Deschutes County -Fair and Expo Center TID-Budget Basis Commissioners Statement of Financial Operating Data Nine Months Ended March 31,2012 Vearto Date Budget (9/12 of I annual) I Actual I Variance IFY % IColi. % $ 75,000 $ (40,601) $ (115,601) 100% -54% 453,750 395,024 (58,726) 75% 65% 1,125 124 (1,001 ) 75% 8% 43,500 17,199 (26,302) 75% 30% 4,500 5,775 1,275 75% 96% 22.500 8,341 (14.159) 75% 28% 165,000 109.546 (55,454) 75% 50% 84.000 44.000 (40,000) 75% 39% 75% nla 35,250 1,500 (33,750) 75% 3% 5,105 9,965 4,859 75% nla 814,730 591,474 (223,259) 75% 54% 127,500 277,503 75% 163% 19,308 19,305 75% 75% 62,100 62,100 75% 75% 165,000 220,000 55,000 75% 100% 75 (75) 75% 0% 373,983 578,908 54,925 1,263,713 1,129,781 (133,933) 75% 68% ! ExP.%! 649,514 611,098 38,415 75% 71% 477,045 473,876 3,169 75% 75% 86,301 71,266 15,035 75% 62% 75 75 75% 0% 1,212,935 1,156,240 56,694 7,500 10,000 (2,500) 75% 100% 24,529 24,529 75% nla YearEnd Budget Projection $ 75,000 $ (40,601) 605,000 1,500 58,000 6,000 30.000 220.000 112,000 47,000 6,807 565,024 498 40,199 11,775 32,341 153,546 107.000 33,424 47.000 11.369 1,086,307 1,002,176 (84,131) 170,000 370,000 200,000 25,744 25,744 82,800 82,800 220,000 220,000 100 pOO~ 498,644 698,544 199,900 1,659,951 1,660,119 168 866,018 828,676 37,342 636,060 676,380 (40,320) 115,068 113,695 1,373.00 100 100 1,617,246 1,618,751 10,000 10,000 32,705 Variance I $ (115,601) (39,976) (1,002) (17,801 ) 5,775 2.341 (66,454) (5.000) 33,424 4,562 (1,505) 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 ...... CAPITAL PROJECTS • North County Campus • Bethlehem Inn ~:~~~~~lM'fi'~~"""~-'-'~W~y."""",-..-¥';,,,_,U1<'!I, '"'lit • ""~~~~'~~~""'I"'.>lI"~"~')o!'I""-!"~"" t ~" 4Ii, ;\i't,~~!",r,~", !!!IH jt!m!lJ!!iI!f~)IL~~ji(4"lll'lh*",* "1tO%'PMt!/lll _______________' • Deschutes County North County Services Building I nception through March 31, 2012 ACTUAL Received and Expended Encumbrances & Commitments Project to Date PROJECTION Project Budget Projected Variance FY 2013 Requested Budget RESOURCES: Beginning Net Working Capital Loan Proceeds, net of issuance co Resources from Fund 140 Resources from Fund 142 Transfer in Interest Revenue Total Resources 1,402,013 25,000 600,000 2,873 2,029,886 1,402,013 25,000 600,000 2,873 2,029,886 a) b) 2,000,000 1,402,013 25,000 600,000 4,027,013 3,400,000 1,402,013 25,000 600,000 2,873 5,429,886 1,400,000 2,873 1,402,873 300,000 3,400,000 100,000 10,000 3,810,000 EXPENDITURES: Materials &Services Architecture/Design Engineering Planning Interfund Charges Fees, Permits &SDCs Utilities Travel -Meals/Mileage Reimb Total Materials &Services 31,325 1,247 84 6,480 3 39,139 18,675 18,675 50,000 1,247 84 6,480 3 57,81!.. b) 100,000 10,000 1,663 60,000 2,000 173,663 100,000 10,000 1,663 60,000 2,000 3 173,666 ill (3) 25,000 75,000 11,639 75 ,000 10,000 196,639 Capital Outlay Land and Building Remodel Total Capital Outlay 1,402,013 230 1,402,243 1,402,013 230 1,402,243 a) 1,402,013 2,451,337 3 ,853,350 1,402,013 3,851,337 5,253,350 (1,400,000) (1 ,400,000) 3,300,000 3,300,000 Contingency Total Expenditures 1,441,382 18,675 1,460,057 4,027,013 5,427,016 (1,400,003) 313,361 3,810,000 Net 588,504 (18,675) 569,829 2,870 2,870 a) The building was purchased in FY 2011 with resources from Project Development and Debt Reserve -$1,402,013 b) $25,000 was paid to the architect in FY 2011 with resources from General County Projects Fund (Fund 142) ~ - North County Services Building -Fund 462 ENCUMBRANCES AND COMMITMENTS Through March 31, 2012 Vendor Description Commitment Amount Amount Paid Balance Due BLRB/GGL Architects Architectural Services 50,000 31,325 18,675 50,000 31,325 18,675 Deschutes County Bethlehem Inn (Fund 128) Nine Months Ended March 31,2012 Actual BUdget I Projection I Variance RESOLIRCES: 8eg. 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. %1 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) b) (2,709,173) (2,707,173) a) Interest on March 2012 negative cash balance: $1,346.47. b) Inception through March 31, 2012 Revenues -Lease Payments Expenditures: Land/Building (Amertitle) -July 2007 Hickman Williams City of Bend -May 2008 KN EX CO Kleinfelder Total expended on facility Interest on Negative Cash Balance Total expended Net $ 44,748 2,241,313 17,578 250,000 5,289 3,732 2,517,913 237,013 2,754,926 $ (2,710,178) Deschutes County General Support Services ~ SDCC Conference/Seminar, Educationrrraining and Travel Expenditures and SDCC ~ County College Expenditures FY2012 1----,---.--........-------:---r---.,.---.,.-- BOCC Conference & Travel I Jul I Aug I S I Nov I Dec I Jan I Feb I Mar IYTD Total .!!lmmy Baney ...~.._ ....... _~_--=-==--_._____...__~____--=-=::-c-i_ ......._ ....... ____---==__~_____ ..... _____.._ Conf/Sem & i::ducffraining _ _6-,6..::...5___~___~~.........____ ....:.3..:0_5::......:.....'__1:--::;5:-c-_--:-:-::-_---'-7-=--5~. _-___ .....: :-=--__1'-'-,0=-=6~0_j 220 -30 90 - -40 380 I"\I.AA,.IIIII IIUUdIlU' ,::, 996 211 429 .• -1.265 -84 2,985 Airfare - - - - -• - - - ~~~~;:~~~~:~~~=~'-a''''r--;--,''~:c-ng------__ -=-~::=---=-....-:-~:--=--=~-=-···::7=-=1:.;:~;~-=-·~=-=:-·=····=~~'----I-__ ___ ________ __ ..-..-~78 ~~__ ..= =--=:-=~:7==7:::-..,...--'.-::::.::::.~0~-9:---=-----c5~_2=9===2=--:_::..:.0==-4-=--=--.....-... Total Baney 1,661· 1,375 i 734 722 =--3=9~9----=1,870 204 702 7,665'---............ Accommodations 1,131 1,452 Airfare Mileage reimbul ::,"''''",rn .Ground TI<>"~l-'vl~Da_rkin_g ===--'--====::==--===-:=='---=== _-_-_-.... -__ Total Unger 1,796 • -I 627 45 • 75 30 45 2,617 =-===.::;=:;;=::::::========-.---.::::===-==-....-----~-----....--....---....-ITony DeBone ' ~~~f~:;s Ed~~.:..:.r=ai.:.:.ni.:.:.ng"'---______.__~65--:----:--~_···-=--~0=5====~.4;;5:~~~:-.. .......-_--~_·--_-=~-=35=-_-_--.3-::--:0"""'-.-_~-_---:--1--c-35=09~=-===1,=~-5=1~--I Accommodations 908--429 ! - - - --1,337 ~r~ . __________.___ -=--::-___• -----;-: ___, -- . 573_---:-.~__=___~--_;_:5:_:__0-623_ i Mileage reimbursement -300 _-_-.-__14....:6-"----_= ___163 138 412 104__ 1.264 ! G~~:--~~~s:6rt ---~----':::::::1,=::~=73==-==:3~:4:::4-,==~=-L;= ~80 -T-i==-=:4=5+1==1-:=:6===-3-1,;46 ~2 4~! 5,~ ~~ Total· BOCC-oepartment ' , canf/Sam & EdudTr-ai---ni-ng--1.995 ------C-9--CC 10~5~:-----_~ 685 15=-+-1---C--:-110-=-=-7-5_-_-_ 3.835 Travel Meals ---.--~--'----~----220----=----L---30 ---:::-9-=-0 - -199 539 ----c-------.-.-...... ..----.--c--=-=-c---~-- Accommodations __ ~.()~_ -'--------=2=-'1_1---'--1,179 ___• -------'-__-____1.g~!5 -84 5.774 Airfare - -- - - -573 -50 623 ----.c.......... . ....... ---~-----.....---~----~....... ;------c~-.----....... ~age Reimbursement -..::...30.::...c0'--'-____7-,,9-c-4+--__1_46 ~-6-7-7---472668 _616___~_ 4,355 Ground Transport -54 : 150 i - - - - -83 287--=-_............=-:::!-=---:-----=-- Total-BOCe: I:?epartment 5,029 354 1,375 I 2,240: 812 562 3,191 676 1,173 15,412 c--=:... FY 2012 B~dget 14,750 I=========:-~~===:====;;:.===:===========================.=......=.-.:=:.=.::--...:::==============-==----===============-=--=;::::::::;: Percent of Fyg012 Bu~gEltExpende~_ ____ _ _________ ....._._____..~.._______~_..~..._. 104.5% BOCC County College -Office/Copier Supplies ----····-----------120-----~---.-~5g+·--11--1-2-:-------------~26T Meeting Supplies ________...__-==-=-_-==-=-__-===5:..::..::,.56 __ _=-=.......=--=_===-=--=====2"7r~2=--1 ll =.....;8:.;;;.:;.29~1_==7=rI8=__8__==-=----...... 1:::: ! t=T~~~I~BOC~CC~ouml~ty~~~_==:-==::.==:167~5::]82~9!--·M=~7·····.·····--1~11--~12~----------------·~2~,373=1 i 4/1612012 RV Park (Fund 601) Statement of Financial Operating Data Nine Months Ended March 31 , 2012 RESOURCES: Beg. Net Working Capital Revenues $10,000 $ (28,100) $ (38,100) 100% nfa $10,000 $(28,100) $ (38,100) RV Park Fees < 31 Days RV Park Fees> 30 Days Tent Space Rental Washer I Dryer Vending Machines City of Redmond Room Tax Collection Fee Interest on Investments Cancellation Fees Total Revenues 133,875 5,550 600 1,195 900 3,000 145,120 97,196 3,250 745 298 33 1,073 102,595 (36 ,679) (2,300) (600) (450) (602) (3,000) 33 1,073 (42,525) 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 54% 44% 0% 47% 25% 0% n/a n/a n/a 53% a) a) 178,500 7,400 800 1,593 1,200 4,000 193,493 3,250 800 1,200 298 33 1,073 138,850 (46,304) (4,150) (393) (902) (4,000) 33 1,073 (54,643) Transfers In-Gen Fund Transfers In-Fund 130 105,000 110,000 5,000 75% 79% 110 ,000 140,000 110,000 140,000 TOTAL RESOURCES REQUIREMENTS: Expenditures Materials &Services Debt Service Contingency 260,120 64,292 159,825 93,707 184,495 73,252 159,825 (75,625) (8,960) 93,707 75% 41% I Exp _%1 75% 85% 75% 66% 75% n/a b) 453,493 85,722 242,829 124,942 360,750 85,722 242 ,829 (92,743) 124,942 TOTAL REQUIREMENTS 317,824 233,071 84,747 75% 51% 453,493 328,551 124,942 NET (Resources -Requirements) (57,704) (48,581 ) 9,122 32,199 32,199 Beginning Net Working Capital per Requested Budget I $ a) 3,139 RV spaces rented b) Debt service expended semi-annually -November and May _ Deschutes County RV Park (Fund 601) " Revenue and Occupancy Statistics FY 2012 with Comparison to FY 2009, 2010 and FY 2011 FY 2009 FY 2010 FY 2011 FY 2012 #of # of #ot # of RV Park Spaces % RV Park Spaces % RV Park Spaces % RV Park Spaces % Fees Rented Occupancy Fees Rented Occupancy Fees Rented Occupancy Fees Rented Occupancy (RV Park (RV Park (RV Park (RV Park Fees I Fees I Fees I Fees I l~?L_ $32 ) $32 ) ~32) Actual Received: July 15,352 480 14.60% 22,886 715 21.76% 40,832 1,276 38.83% 46,703 1,459 44.42% August 11,444 358 10.88% 11,474 359 10.91% 44,452 1,389 42.27% 26,006 813 24.73% September 9,096 284 8.94% 8,954 280 8.80% 17,013 532 16.72% 13,796 431 13.56% October 6,144 192 5.84% 10,984 343 10.45% 5.463 171 5.19% 7,361 230 7.00% November 1,632 51 1.60% 2.868 90 2.82% 3,823 119 3.76% 2,125 66 2.09% December 416 13 0.40% 224 7 0.21% 616 19 0.59% 320 10 0.30% January 608 19 0.58% 2,378 74 2.26% 1,704 53 1.62% 1,120 35 1.07% February 128 4 0.13% 2,058 64 2.17% 2,218 69 2.34% 352 11 0.36% March 4,468 140 4.25% 9,564 299 9.10% 5,879 184 5.59% 2,664 83 2.53% April 7,644 239 7.51% 8,192 256 8.05% 4,954 155 4.87% May 7,062 221 6.72% 7,342 229 6.98% 13,044 408 12.40% June 23,038 720 22.64% 20,358 636 20.01% 12,706 397 12.49% Year to Oate Actual 87,032 2,720 7.03% 107,282 3,353 8.67% 152,702 4,772 12.33% 100,446 3,139 10.77% 1) 106 spaces times 366 days = 38,796 annual spaces available. Budget of $178,500 assumes 5,219 spaces rented ($178,500 I $32 = 5,578) Budgeted occupancy rate is 14.38.% -budgeted spaces 1 total annual spaces available (5,5781 38,796) I RESOURCES: Beg. Net Working Capital Revenues Cleaning/Maintenance Insurance Reimbursement Utility Reimbursement Facilities Charge to State Miscellaneous Interest on Investments Interfund contract Interfund charges -other Building Svcs Indirect Chgs Building Services -620 Statement of Financial Operating Data Nine Months Ended March 31,2012 Year to Date Budget I Actual I Variance IFY% I Coil. % Year End Budget Projection Variance $ 424,000 $ 529,500 $ 105,500 163,380 163,380 9,331 9,331 4,000 4,000 188,016 188,016 4,415 4,415 3,000 4,000 1,000 10,000 10,000 1,125 1,125 1,991,229 1,991,229 $ 424,000 122,535 3,000 141,012 2,250 7,500 1,493,422 $ 529,500 $ 105,500 106,063 (16,472) 9,331 9,331 2,516 (484) 117,496 (23,516) 4,415 4,415 2,835 585 7,500 (0) 1,125 1,125 1,493,422 100% n/a 75% 65% 75% nfa 75% 63% 75% 62% 75% nfa 75% 95% 75% 75% 75% n/a 75% 75% Total Revenues 1,769,719 Transfers In 25,279 1,744,703 (25,016) 75% 74% (25,279) 75% nfa 2,359,625 33,705 2,375,496 33,705 6,540 TOTAL RESOURCES 2,218,998 REQUIREMENTS: 2,274,203 55,206 75% 81% 2,817,330 2,938,701 112,040 Expenditures Personal Services 1,260,514 1 Exp. %1 1,276,545 (16,031) 75% 76% 1,680,685 1,680,685 Materials and Services 571,919 574,158 (2,239) 75% 75% 762,558 762,558 Transfer to Veh Reserve 29,700 29,700 75% 75% 39,600 39,600 Capital Outlay 75 75 75% 0% 100 100 Contingency 250,790 250,790 75% 0% 334,387 334,387 TOTAL REQUIREMENTS 2,112,998 1,880,402 232,595 75% 67% 2,817,330 2,482,843 334,487 NET (Resources -Requirements) 106,000 393,801 287,801 Beginning NWC Per FY 2013 Proposed Budget 415,000 455,858 446,527 Admin Services -625 Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End Budget I Actual I Variance IFY% I Coil. % Budget Projection Variance I RESOURCES: Beg. Net Working Capital $ 183,000 $ 158,276 $ (24,724) 100% n/a $ 183,000 $ 158,276 $ (24,724) Revenues Miscellaneous 90 90 75% n/a 90 90 Interest on Investments 501 501 75% n/a 600 600 Admin Dept Indirect Chgs 661,304 661,303 !O) 75% 75% 881,738 881,738 Total Revenues 661,304 661,895 591 75% 75% 881,738 882,428 Transfers In-General Fund 147,838 30,000 ~117,838) 75% 15% 197,117 197,117 TOTAL RESOURCES 992,141 850,171 (141,970) 75% 67% 1,261,855 1,237,821 (24,034) REQUIREMENTS: Expenditures Personal Services Materials and Services Transfer to Veh Reserve Capital Outlay Contingency 645,952 81,486 2,700 75 216,179 739,516 69,250 2,700 (93,565) 12,236 75 216,179 1 Exp. %1 75% 86% 75% 64% 75% 75% 75% 0% 75% 0% a) 861,269 108,648 3,600 100 288,238 921,828 108,648 3,600 100 (60,559) 288,238 TOTAL REQUIREMENTS 946,391 811,466 134,925 75% 64% 1,261,855 1,034,176 227,679 NET (Resources Requirements) 45,750 38,705 (7,045) b) 203,645 203,645 Beginning NWC Per FY 2013 Proposed Budget 140,000 a) YTD actual includes payout to County Administrator. Projection is YTD Actual plus 3 months at March actual. new County Administrator. 690 eocc ·628 Statement of Financial Operating Data Nine Months Ended March 31,2012 RESOURCES: Beg. Net Working Capital Revenues Sale Map Photo or Copies Interest on Investments Admin Dept Indirect Chgs Total Revenues Transfers In-General Fund Year to Date Variance $ 115,000 $ 114,142 $ (858) 375 270,615 11 539 270,615 11 164 0 270,990 271,164 174 4,351 !4,351 ~ 100% 75% 75% 75% 75% 75% nfa n/a n/a 75% 75% n/a TOTAL RESOURCES 390,341 385,306 (5,034) 75% 80% REQUIREMENTS: I Exp·%1 Expenditures Personal Services 253,248 253,728 (480) 75% 75% Materials and Services 67,171 72.399 (5,228) 75% 81% Capital Outlay 75 75 75% 0% Contingency 41,097 41,097 75% 0% TOTAL REQUIREMENTS 361,591 326,127 35,464 75% 68% Budget $ 115,000 500 360,820 361,320 361,620 300 5.801 5,801 482,121 481,563 (558) 337,664 337,664 89.561 89,561 100 100 54,796 54,796 YearEnd Projection Variance I $ 114,142 $ (858) 800 360.820 300 482,121 427,225 54,896 NET (Resources· Requirements) 28,750 59,180 30,430 54,338 54,338 Beginning NWC Per FY 2013 Proposed Budget 60,000 Finance -630 Statement of Financial Operating Data Nine Months Ended March 31, 2012 Year to Date Year End Budget I Actual I Variance jFY% I Coli. % Budget Projection Variance I RESOURCES: Beg. Net Working Capital $ 603,000 $ 788,522 $ 185,522 100% nfa $ 603,000 $ 788,522 $ 185,522 Revenues Investment Fee 30,000 32,202 2,202 75% 81% 40,000 42,000 2,000 Photo copies 113 401 289 75% 267% 150 401 251 IGA Contracts 11,585 (11,585) 75% 0% 15,446 15,446 Interest on Investments 3,000 3,658 658 75% 91% 4,000 5,000 1,000 Interfund Contracts 9,000 9,000 75% 75% 12,000 12,000 Finance Dept Indirect Chgs 620,906 620,905 75% 75% 827,874 827,874 Total Revenues 674,603 666,166 (8,437) 75% 74% 899,470 902,721 3,251 Transfers In -Gen Fund 16,154 16,154 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 1,277,603 1,454,688 177,085 75% 96% I Exp. %1 678,848 635,883 42,965 75% 70% 206,177 205,035 1,142 75% 75% 7,500 7,500 75% 0% 246,443 246,443 75% 0% 1,138,968 . 840,918 298,050 75% 55% 1,518,624 1,707,397 188,773 905,131 865,131 40,000 274,902 274,902 10,000 10,000 328,591 328,591 1,518,624 1,140,033 378,591 NET (Resources Requirements) 138,635 613,770 475,135 567,364 567,364 Beginning NWC Per FY 2013 Proposed Budget 540,000 I Legal-640 Statement of Financial Operating Data Nine Months Ended March 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Sale Map Photo or Copies Miscellaneous Interest on Investments Interfund Contract Legal Counsel Indirect Chgs Year to Date Year End Budget I Actual I Variance IFY % I Coil. % Budget Projection Variance $ 148,500 $ 154,921 $ 6,421 100% nJa $ 148,500 $ 154,921 $ 6,421 225 123 (102) 75% 41% 300 300 750 6 (744) 75% 1% 1,000 1,000 1,125 1,041 (84) 75% 69% 1,500 1,500 7,125 (7,125) 75% 0% 9,500 9,500 565,974 565,974 0 75% 75% 754,632 754,632 Total Revenues 575,199 567,144 (8,055) 766,932 766,932 Transfers In -Gen Fund 10,809 10,809 TOTAL RESOURCES 723,699 722,065 (1,634) 75% 78% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 563,639 33.482 75 97,485 504,604 32,666 59,036 815 75 97,485 1 Exp. %1 75% 67% 75% 73% 75% 0% 75% 0% TOTAL REQUIREMENTS 694,681 537,270 157,411 75% 58% 926,241 932,662 6,421 751,519 44,642 100 129,980 751,519 44,642 100 129,980 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 I 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 TOTAL REQUIREMENTS NET (Resources -Requirements) Year to Date Budget I Actual I Variance IFY% I Coil. % $ 305,500 $ 360,650 $ 55,150 100% nJa 750 306 (444) 75% 31% 2,250 1,987 (263) 75% 66% 543,998 543,998 0 75% 75% 546,998 546,291 (707) 75% 75% 852,498 906,940 54,443 1 Exp. %1 457,938 230,557 75 96,900 446,098 128,413 11,840 102,144 75 96,900 75% 75% 75% 75% 73% 42% 0% 0% 785,470 574,511 210,959 75% 55% 67,028 332,429 265,402 Year End Budget Projection Variance $ 305,500 $ 360,650 $ 55,150 1,000 306 (694) 3,000 3,000 725,330 725,330 729,330 728,636 (694) 12,463 12,463 1,047,293 1,101,749 54,456 610,584 307,409 100 129,200 610,584 230,000 77,409 100 129,200 1,047,293 840,584 206,709 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 Year to Date Year End Budget I Actual I Variance IFY% I Coil. % Budget Projection Variance I RESOURCES: Beg. Net Working Capital $ 513,000 $ 650,653 $ 137,653 100% nfa $ 513,000 $ 650,653 $ 137,653 Revenues Miscellaneous 106 106 75% nfa 106 106 Interest on Investments 3,000 3,727 727 75% 93% 4,000 4,000 Leases 15,750 24,298 8,548 75% 116% 21,000 30,000 9,000 I T Indirect Chgs 1,517,434 1,517,434 !O} 75% 75% 2,023,245 2,023,245 Total Revenue 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% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 1,371,122 388,564 75 234,562 1,288,323 260,534 82,799 128,029 75 234,562 I Exp. %1 75% 70% 75% 50% 75% 0% 75% 0% TOTAL REQUIREMENTS 1.994,322 1,548,857 445,465 75% 58% 2,659,096 2,805,855 146,759 1,828,162 518,085 100 312,749 1,828,162 518,085 100 312,749 2,659,096 2,346,247 312,849 NET (Resources -Requirements) 128,250 696,860 568,610 459,608 459,608 Beginning NWC Per FY 2013 Proposed Budget 568,550 I IT Reserve· 661 Statement of Financial Operating Data Nine Months Ended March 31, 2012 RevisedYear to Date Year End Budget I Actual I Variance IFY% I Coli. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 304,896 $ 340,594 $ 35,698 100% n/a $ 304,896 $ 340,594 $ 35,698 Revenues Interest 1,125 2,084 959 75% 139% 1,500 2,750 1,250 Donations (Energy Trust) 5,140 5,140 75% nfa 5,140 5,140 IT Reserve Charges 175,500 175,500 ° 75% 75% 234,000 234,000 Total Revenue 176,625 182,724 6,099 75% 78% 235,500 241,890 6,390 TOTAL RESOURCES 481,521 523,318 41,797 75% 97% 540,396 582,484 42,088 REQUIREMENTS: I Exp. %1 Expenditures Materials and Services 83,625 38,919 44,706 75% 35% 111,500 111,500 Capital Outlay 74,250 43,848 30,402 75% 44% 99,000 99,000 Res for Future Expenditure 247,422 247,422 75% 0% 329,896 329,896 TOTAL REQUIREMENTS 405,297 82,767 322,530 75% 15% 540,396 210,500 329,896 I i NET (Resources -Requirements) 76,224 440,552 364,328 371,984 371,984 Beginning NWC Per FY 2013 Proposed Budget 365,593