The URL can be used to link to this page

Home My WebLink About2013-06-05 Work Session Minutes Minutes of Board of Commissioners’ Work Session Wednesday, June 5, 2013 Page 1 of 5 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 WEDNESDAY, JUNE 5, 2013 ___________________________ Present were Commissioners Alan Unger, Tammy Baney and Anthony DeBone. Also present were Tom Anderson, County Administrator; Erik Kropp, Deputy County Administrator; and, for a portion of the meeting, Nick Lelack and Peter Russell, Community Development; John Skidmore and Nick Arnis of the City of Bend; Marty Wynne, Finance; Susan Ross and Teresa Rozic, Property & Facilities; and Anna Johnson, Communications. No representatives of the media or other citizens were present. Chair Unger opened the meeting at 1:30 p.m. ___________________________ 1. Finance/Tax Update. Marty Wynne said rates and average return are about the same as previously discussed. Bond rates have risen dramatically, which is not good if you are trying to sell bonds. It is still within projected parameters. The economy is still in turmoil so it is hard to know what to expect. General Fund shows a forecast of above $10 million in revenue, with the variance being non-departmental. Most departments are close to budget for FY 2012-13. The budget was $9.5 million revenue. Commissioner Baney said that the State might be cutting payments, and that will impact next year. Mr. Anderson said that appropriation numbers from the State are not final, but there will be a loss in revenue primarily for Parole & Probation. Contingency can cover this short-term only. Minutes of Board of Commissioners’ Work Session Wednesday, June 5, 2013 Page 2 of 5 2. Discussion of Next Public Real Property Auction. She said there is a request from ODOT relating to property affected by the Parkway. ODOT purchased some property from the U.S. Forest Service in order to realign a street. The vacated strip actually belongs to the County. The County is being asked to give that property back to the U.S. Forest Service. The auction would happen this summer. The County took deeds on several properties, and the market is improving. There are thirteen properties to consider for auction. The group went into executive session under ORS 192.660(2)(c), real estate negotiations, at this time. 3. Other Items. Anna Johnson discussed ideas for the State of the County presentation. It will be the top ten, and she needs themes. They need to keep the audience engaged. One section would be budget, another goals and objectives, and another accomplishments/highlights. Mr. Anderson said there would be a stack of photos at each table, and the audience would pick one out and ask a relevant question. Tom Anderson was asked to act as Master of Ceremonies. He said he would prefer to talk about budget items; Chair Unger will M.C. ___________________________ Commissioner DeBone spoke about the conference involving eastern counties that he attended earlier in the week, where they discussed issues affecting central and eastern Oregon counties. ___________________________ John Skidmore of the City of Bend asked for a letter of support from the County for a TGM (transportation growth management) grant. They are applying for $150,000, which is the entire grant; and will work with partners for the balance of $100,000. They do not yet have all the particulars regarding the OSU campus siting. The grant is due next week. The project would involve OSU Cascades, the City, the County and Bend Metro Park and Recreation. Minutes of Board of Commissioners’ Work Session Wednesday, June 5, 2013 Page 3 of 5 The grant would address the area off Simpson and 14th Street that remains mostly vacant. As properties are rezoned, they bring out transportation impacts that require expansion of roundabouts and other changes. Mr. Anderson said the County was in the midst of applying for its own grant for the Deschutes River Woods community plan and other projects. Nick Arnis said that he spoke with a variety of partners, and they will reach out to the owners of larger parcels in the area as well. This may eliminate some of the logjam for the entitlement process. (He referred to a map of the area, a copy of which is attached for reference.) They do not want to preclude anything at this point. However, there will be some properties that need to be included. Mr. Anderson asked if they know what results they may have in getting the grant. Mr. Arnis stated that DLCD thought it was a viable project. Chair Unger said that other agencies in this region might also want grant funds, so they need to be asked if this is that important to Region 4. Commissioner Baney stated that perhaps they could offer support next year to another agency. Region 4 runs from the Columbia River to the California state line, down the middle of Oregon. Mr. Arnis said that the Governor’s Office encouraged them to go for this grant. Chair Unger stated that the County has a brownfields grant that could add value to the project, for the demolition landfill or any of the other properties in the area with potential brownfields issues. Mr. Arnis said they seem to be willing to be flexible with the scope of the project. The grant is due by June 14, and the award will occur in about a year. The whole amount is needed and more, but they feel fairly confident this project will be given a lot of consideration. Mr. Lelack said that the timeline for this application and the brownfields grant for the County are very similar, and they can look at the same areas. The brownfields grant is for three years, and they need to identify various sites. This could be focused to certain locations. Minutes of Board of Commissioners’ Work Session Wednesday, June 5, 2013 Page 4 of 5 Commissioner Baney asked if the City should be the lead applicant. She also asked if there is something that can be offered to other communities who are seeking smaller amounts. Mr. Arnis stated he could speak to the City Council about perception issues and how to mitigate those. Chair Unger said that he is interested in the project, but there has to be lasting value for the county’s property. Commissioner Baney stated they want to see this succeed, so she feels they should put off the Deschutes River Woods planning process.. Mr. Russell said that ideally, there will be grant funds to do the DRW process, but they can do much of it in house, it will just take longer. There biggest concerns are transportation improvements, dealing with the at-grade railroad crossing, better access to the river, and a transitional plan to become part of the City in the future. Chair Unger said it appears the Board is supportive and wants to be a viable partner. They can bring something to the table when the time is right. Commissioner Baney asked if other counties might support this as a regional improvement. She wants to avoid the perception that it is just a Bend application. Chair Unger said the regional solutions group has this as a priority, and there are representatives from a variety of entities on that committee. Being no further items addressed, the work session ended at 4:00 p.m. DATED this ~ Day of ~ 2013 for the Deschutes County Board of Commissioner: . ~b Alan Unger, Chair Tam~air ATTEST: Anthony DeBone, Commissioner ~~ Recording Secretary Minutes of Board of Commissioners' Work Session Wednesday, June 5, 2013 Page 5 of5 Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 -Fax (541) 385-3202 -www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., WEDNESDAY, JUNE 5,2013 1. Finance/Tax Update -Marty Wynne 2. Discussion of Next Public Real Property Auction -Teresa Rozic (some possibly in executive session) 3. Other Items PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to ORS 192.660(2) (e), real property negotiations; ORS 192.660(2) (h), litigation; ORS I 92.66O(2X 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 ofCommissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. lfyou 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) 3&&-6571 regarding alternative formats or for further information. Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA June 5, 2013 (1) Monthly Investment Report (2) April 2013 Financials I, ; 1 1 Deschutes County Investment Income Investments By County Function Fiscal Year 2012-13 Apr-13 I J Y-T-O General $ 127,428,857 $ 60,941 $ 605,196 -- Total Investments $ 127,428,857 Total Investment Income 60,941 605,196 Less Fee: 5% of Invest. Income {3,047~ {30,260~ Investment Income -Net 1$ 57,894 $ 574,936 Yield Percentages -~.~ Category Maximums: U.S. Treasuries 'ILGIP ~Federal Agencies 100% 100% 75% Banker's Acceptances 25% Time Certificates 25% Commercial Paper 20% Corporate Notes 10% BOTe I LGIP ~ 0.54% 0.53% Investments ~ 0.78% 0.78% Average ~ 0 .57% 0.57% c t(; t 3 Month Treas. ~ 0.05% 12 Month Treas . ~ 0.11% 3 MonthCP ~ 0.13% Commercial Paper Corporate Notes Time Certificates U. S. Treasuries Federal Agencies Bankers' Acceptances $ 12,426,607 7,233,921 LGIP/BOTC Total Investments Total Portfolio: By Investment Types Corporate Notes 10% Time Certificates 6% Federal Agencies 0% 0.00% 9 .75% 5.68% 0.00% 0.00% 0.00% LGIP/BOTC 84% Term Maximums: 0-18 Months 100%l- 19 -24 Months 30% Months to Maturity 18 Months 91% 24 Months 9% Memorandum Date: May 28, 2013 To: Board of County Commissioners Tom Anderson, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find April 2013 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 Ten Months Ended April 30, 2013 Year to Date $ Actual Variance Variance RESOURCES: Beg. Net Working Capital $ 8,700,000 $ 9,059,394 $ 359,394 100% 104% $8,700,000 $9,059,394 $ 359,394 Revenues Tax Revenues -Current 16.826.300 19,800,722 2.974,422 83% 98% 20,191,560 20,774,199 582,639 Tax Revenues -Prior 566.667 1,008,137 441,470 83% 148% 680,000 1,008,137 328,137 Gen. Rev. -excl. Taxes 1,989,443 2,312,829 323,386 83% 97% a) 2.387,331 2,687,331 300.000 Assessor 623,855 833,554 209,699 83% 111% b) 748,626 833,626 85,000 County Clerk 1,150,019 1,315,137 165,118 83% 95% 1,380,023 1,620,023 240,000 BOPTA 10,332 16,419 6,087 83% 132% b) 12,398 16,419 4,021 District Attorney 153,912 132,809 (21,103) 83% 72% 184,694 184,694 FinancelTax 165,750 248,736 82.986 83% 125% b) 198,900 288,736 89,836 Veterans 57,000 55,836 (1,164) 83% 82% c) 68,400 74,198 5,798 Property Management 82,703 78,537 (4,166) 83% 79% 99,244 99,244 Grant Projects 1,667 1,667 {O} 83% 83% 2,000 2,000 Total Revenues 21,627,648 25,804,382 4,176,734 83% 99% 25,953,176 27,588,607 1,635,431 TOTAL RESOURCES 30,327,648 34,863,776 4,536,128 83% 101% 34,653,176 36,648,001 1,994,825 REQUIREMENTS: I Exp. %1 Expenditures Assessor 2,973,127 2,832,496 140,631 83% 79% 3,567,752 3,467,752 100,000 County Clerk 1,223,032 1,058,555 164,477 83% 72% 1,467,638 1,361,638 106,000 BOPTA 60,321 50,394 9.927 83% 70% 72,385 72,385 District Attorney 4,395.556 4,162,435 233,121 83% 79% 5,274,667 5,074,667 200,000 FinancelTax 694,888 652,528 42,360 83% 78% 833,865 833,865 Veterans 217,493 207,635 9,858 83% 80% 260,992 260,992 Property Management 226,689 229,853 (3,164) 83% 84% 272,027 272,027 Grant Projects 101,958 102,262 (304) 83% 84% 122,349 122,349 Non-Departmental 1,428,893 813.555 615,338 83% 47010 d) 1,714,671 1,414,671 300,000 Contingency 5,045,440 5,045,440 83% n/a 6,054,528 6,054.528 16,367,397 10,109,713 6,257,684 83% 51% 19,640,874 12,880,346 6,760,528 Transfers Out 11,581,377 11,609,971 {28,594~ 83% 84% 13,897,652 13,897,652 TOTAL REQUIREMENTS 27,948,774 21,719,684 6,229,090 83% 65% 33,538,526 26,777,998 6,760,528 NET (Resources -Requirements) 2,378,875 13,144,093 10,765,219 e) 1,114,650 9,870,003 8,755,353 Beginning Net Working Capital per Proposed Budget 9,500,000 I a) Includes annual payments: PILT $730,983. FY 2012 PILT was $471,723 b) A & T Grant received quarterly. YTD includes four quarters -July, October, January and April c) State payment received quarterly. YTD includes three quarters. d) Budget includes $576,736 payment to LED#2. Will not be expended until June 2013 and is prOjected to be $300,000 less than budgeted due to available Transient Room Tax revenues e) Appropriation Transfers (authority to expend): County School Fund $360,000, Grant Fund $10,000 Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Ten Months Ended April 30, 2013 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065-Court Assess. Jail Funding HB #2712 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 CFC Interfund Grant Interfund Grant -Gen Fund Budget I $1,010,415 5,000 3,223 10,833 17,500 312,789 50,000 83 101,667 167 42 833 6,667 1,000 417 104,718 16,667 Year to Date Actual I Variance IFY% I CoiL % $ 995,051 $ (15,364) 100% 98% (5,000) 83% 0% a) 6,786 3,563 83% 175% b) 27,849 27,849 83% 60% b) 7,383 (3,451) 83% 57% 20,589 3,089 83% 98% c} 285,112 (27,677) 83% 76% d) 110,280 60,280 83% 184% c) 231 148 83% 231% 80,734 (20,933) 83% 66% e) 59 (108) 83% 29% (42) 83% 0% 275 (558) 83% 28% 5,241 (1,426) 83% 66% 1,100 100 83% 92% 1,424 1,007 83% 285% c) 91,856 (12,862) 83% 73% f) 15,000 (1,6671 83% 75% d) FY2013 Year End Budget Projection Variance $1,010,415 $ 995,051 $ (15,364) 6,000 6,000 3,867 7,000 3,133 46,133 37,000 (9,133) 13,000 9,800 (3,200) 21,000 28,000 7,000 375,347 375,347 60,000 140,000 80,000 100 250 150 122.000 100,000 (22,000) 200 100 (100) 50 (50) 1,000 375 (625) 8,000 6,250 (1,750) 1,200 1,200 500 1,500 1,000 125,661 125,661 20,000 20,000 Total Revenues 631,606 653,917 22,311 83% 81% 804,058 858,483 54,425 Transfers In-General Fund 4,453,770 4,453,770 83% 83% 5,344,523 5,344,523 TOTAL RESOURCES 6,095,791 6,102,738 6,947 83% 85% 7,158,996 7,198,057 39,061 REQUIREMENTS: Expenditures Community Justice-Juvenile Personnel Services Materials and Services Capital Outlay Transfers Out Contingency 4,229,181 994,967 83 42,000 699,599 4,099,576 875,587 37,800 129,605 119,380 83 4,200 699.599 1 Exp. %1 83% 81% 83% 73% 83% 0% 83% 75% 83% nfa g) g) h) 5,075,017 1,193,960 100 50,400 839,519 4,964,036 1,050,000 50,400 110,981 143,960 100 839.519 TOTAL REQUIREMENTS 5,965,830 5,012,963 952,867 83% 70% 7,158,996 6,064,436 1,094,560 NET (Resources -Requirements) 129,961 1,089,775 959,814 1,133,621 1.133.621 Beginning Net Working Capital per Proposed Budget 1,125,000 I a) Grant payment anticipated in last quarter, pending completion of project b) HB #2712 replaced SB #1065 effective January 1, 2012 c) Revenues trending higher than anticipated -$600 billing outstanding for inmate/prisoner housing d) Payments received quarterly e) Contract payment reimbursement request submitted monthly, received 1-2 months in arrears f) Grant payments are generated by program activity during the school year and are received quarterly in arrears g) Expenditures trending lower than anticipated. Currently 6.8 unfilled FTE; Eliminating 4.8 FTE h) Transfers out recorded quarterly Page 2 SHERIFF -Fund 255 Statement of Financial Operating Data Ten Months Ended April 30, 2013 Actual Variance Variance RESOURCES: Beg. Net Working Capital $ $ $ 100% nfa $ $ $ Year to Date 18,801 ,355 83% 69% • 18,928,451 (3 ,633,175 ) 83% 70% • Total Revenues 30,836,098 25,625,054 (5,211,044) 83% 69% 37,003,318 31,131,483 (5,871,835) TOTAL RESOURCES 30,836,098 25,625,054 ( 5,211,044) 83% 69% 37,003,318 31,131,483 (5,871,835) REQUIREMENTS: Exp. %1 EXPENDITURES & TRANSFERS Sheriffs Division 1,886,358 1,893,340 (6,982) 83% 84% 2,263,630 2,263,630 Civil 665,824 601,687 64,137 83% 75% a) 798,989 744,889 54,100 Automotive/Communications 1,506,208 1,535,222 (29,014) 83% 85% b) 1,807,450 1,812,450 (5 ,000) Investigations/Evidence 1,256,817 1,195,245 61,572 83% 79% a) 1,508,180 1,468 ,080 40 ,100 Patrol/Civil/Comm Supp 6,891,132 6,816,266 74,866 83% 82% a) 8 ,269,358 8,113,497 155,861 Records 598 ,014 576 ,396 21 ,618 83% 80% a) 717,617 677,517 40,100 Adult Jail 9,066,693 8,497,292 569,401 83% 78% c) 10,880,032 10,425,532 454,500 Court Security 252,501 249,271 3,230 83% 82% 303,001 302,901 100 Emergency Services 162,111 155,460 6,651 83% 80% 194,533 194,433 100 Special Services Division 1,121,698 984,990 136,708 83% 73% 1,346 ,037 1,328,069 17,968 Regional Work Center 2,219 ,232 2 ,110,653 108,579 83% 79% d) 2,663,078 2,522,978 140,100 Training Division 420,792 377,743 43,049 83% 75% 504,950 508,850 (3,900) Other Law Enforcement Svcs 536,253 560,446 (24,193) 83% 87% e) 643,504 683,404 (39 ,900) Non-Departmental 71,044 71,044 (0) 83% 83% 85,253 85,253 Contingency 4,181,422 4,181,422 83% nfa 5,017,706 5,017,706 TOTAL REQUIREMENTS 30,836,099 25,625,054 5,211,045 83% 69% 37,003,318 31,131,483 5,871,835 NET (Resources -Requirements) • Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures a) Projected variance due to Personnel expenditures projected to be less than budgeted due to open positions and overtime b) FY 2013 appropriated amount, $360,690 for payment Deschutes County Communication System Fund, expended in July 2012 c) Personnel budget was increased for the annual cost of six Correction Technicians . Technicians will be hired in March, resulting in projected difference between actual and budget of $428,000 . Also, $76,417 budgeted for Capital Outlay will not be expended d) Personnel and Materials & Services expenditures projected to be less than budgeted due to timing of filling positions and savings in the cost of inmates' meals e) Projected variance due to extra help and additional overtime for CHL, Street Crimes and CODE activities Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data Ten Months Ended April 30 , 2013 RESOURCES: Beg. Net Working Capital Tax Revenues -Current $4,507,352 12,821,450 $ 5,883,963 15,109,793 $ 1,376,611 2,288,343 100% 83% 131% 98 % a) $ 4,507,352 15,385,740 $5,883,963 15,642,467 $ 1,376,611 256 ,727 Tax Revenues -Prior 366,667 739,750 373,083 83% 168% 440,000 739,750 299,750 Federal Grants & Reimb 25,000 24,510 (490) 83% 82% b) 30,000 24 ,510 (5,490) State Grant 61 ,667 105,734 44 ,067 83% 143% c) 74,000 140,448 66,448 Jail Funding HB 2712 Transp. of State Wards SB 1145 4 ,167 1,233,326 27,849 3,289 1,479,991 27,849 (878) 246 ,665 83% 83% 83 % nJa 66% 100% d 5,000 1,479,991 46 ,133 5,000 1,479,991 46 ,133 0 Prisoner Housing Des. Cty Video Lottery Grant Grants 41 ,667 4,167 185,538 5,000 17,640 143,871 833 17,640 83% 83 % 83 % 371 % 100% nJa e) 50,000 5,000 185,538 5,000 17,640 135,538 17,640 Des Cty Court Security Des Cty Juvenile Contract Title III Reimbursement Transport Other 200,833 3,483 417 2 ,917 77,731 6,183 26,795 1,753 7,288 (123 ,103) 2 ,700 26,795 1,336 4,371 83% 83 % 83% 83% 83% 32 % 148% n/a 351% 208 % f) g) 241,000 4,180 500 3,500 116,597 8 ,000 39,916 1,820 7,288 (124,403) 3,820 39,916 1,320 3,788 DC Fair & Expo Center Inmate Commissary Fees Work Center Work Crews 3 ,333 8 ,333 41 ,667 756 17,368 34,007 (2,577) 9,035 (7,660) 83 % 83 % 83 % 19% 174% 68 % 4,000 10,000 50 ,000 4,000 19,823 50 ,000 9,823 Concealed Handgun Classes 2 ,917 7 ,075 4 ,158 83 % 202% 3 ,500 8 ,000 4,500 Inmate Telephone Fee 66,667 64 ,283 (2,384) 83% 80% 80,000 80,000 Soc Sec Incentive-Fed 4,167 11 ,400 7,233 83 % 228% 5 ,000 11,400 6 ,400 Miscellaneous 4,167 6 ,276 2,109 83 % 126% 5 ,000 6 ,628 1,628 Oregon Mentors Debit Card Fee 833 83 462 (833) 379 83 % 83% 0% 462 % 1,000 100 1,000 500 400 Medical Services Reimb 10,833 12,683 1,850 83% 98 % 13,000 13,000 Restitution 4,167 (4 ,167) 83% 0% 5,000 5,000 Sheriff Fees 208,333 247,394 39,061 83 % 99% 250,000 250,000 Interest 23 ,611 36 ,127 12,516 83 % 128% 28,333 39,666 11,333 Interest on Unsegregated 2,944 1,302 (1,642) 83% 37% 3 ,533 3,533 Grants 3,000 3,000 83 % nJa 3 ,000 3 ,000 Donations -"Shop with a Cop" 43,248 52,790 9 ,542 83 % 102% 51 ,897 52,790 893 Land Sale Revenue 3,309 3,309 83% n/a 3,309 3,309 Sale of Reportable Assets 4,167 574 (3,593) 83% 11 % 5,000 5,000 Total Revenues 15,195,231 18,317,650 3,122,419 83% 100% 18,234,274 19,016,746 782,472 TOTAL RESOURCES 19,702,583 24,201,612 4,499,029 83% 106% 22,741,626 24,900,709 2,159,083 REQUIREMENTS: I Exp. %1 Fund 255 Departments: Sheriffs Services 1,761 ,048 1,767,565 (6 ,518) 83% 84% 2 ,113,257 2 ,113,257 Civil 665,824 601 ,687 64 ,137 83% 75% 798,989 744 ,889 54,100 Auto/Comm 555,414 566,113 (10 ,699) 83% 85% 666,497 668,341 (1,844) Adult Jail 9,066 ,693 8,497,292 569,402 83% 78% 10,880,032 10,425,532 454 ,500 Court Security 252 ,501 249,271 3 ,230 83% 82% 303,001 302,901 100 Emergency Services 162,111 155,460 6,651 83% 80% 194,533 194,433 100 Special Services 776,147 681 ,554 94,593 83% 73% 931 ,377 918,944 12,433 Work Center 2,219,232 2,110,653 108,579 83% 79% 2,663,078 2,522,978 140,100 Training 257,230 230,914 26,316 83% 75% 308,676 311 ,060 (2 ,384) Other (CODE, Forensic) 536 ,253 560,446 (24 ,193) 83% 87% 643,504 683,404 (39,900) Non Dept -ISF Charges 35,593 35,593 (0) 83% 83% 42,712 42 ,712 Contingency 2,513,309 2 ,513,309 83% n/a 3 ,015,970 3,015,970 Total to Fund 255 18,801 ,355 15,456,549 3,344,806 22,561,626 18,928,451 3,633,175 Transfer to Reserve Fund (703) 83,333 100,000 (16,667) 83% 100% 100,000 100,000 Non Dept -Comm System Res 66 ,667 80,000 (13,333) 83% 100% 80,000 80,000 Total Requirements 18,951,355 15,636,549 3 ,314,805 83% 69% 22,741 ,626 19,108,451 3,633,175 Net 751 ,228 8,565,064 7,813,836 5,792,258 5 ,792,258 Beginning Net Working Capital per Proposed Budget a) Current year taxes due November, February and May b) Less than planned BOJ Criminal Alien Assistance (SCAAP) reimbursement c) Unplanned Homeland Security Grant for Engineering Communication System Study d) Unplanned changes at the State level in Circuit Court revenue distribution e) Reimbursement from the State will exceed plan due to higher number of SB 395 inmates f) Changes made at State level in distribution of Circuit Court revenue g) Approved carryover of prior year Title III funds • Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services 5,541,6991 Page 4 Fund 702 LED Rural Statement of Financial Operating Data Ten Months Ended April 30, 2013 RESOURCES: Beg. Net Working Capital $2.859.915 $3.244,571 $ 384.656 100% 113% $2.859.915 $3.244.571 $ 384,656 Revenues Tax Revenues -Current 6,291,667 7,356,206 1,064,539 83% 97% a) 7,550,000 7,615,538 65,538 Tax Revenues -Prior 191,667 366,542 174,875 83% 159% 230,000 366,542 136,542 Federal Grants & Reimb 12,500 35,037 22,537 83% 234% b) 15,000 35,037 20,037 Federal Grants-BlM 21,667 14,759 (6,908) 83% 57% 26,000 26,000 US Forest Service 62,500 59,063 (3,438) 83% 79% 75,000 75,000 Bureau of Reclamation 21,667 18,830 (2,838) 83% 72% 26,000 26,000 State Grant 157,662 205,740 48,078 83% 109% c) 189,194 262,800 73,606 S8 #1065 Court Assessment 45,833 6 ,786 (39,047) 83% 12% d) 55,000 6 ,786 (48,214) Marine 80ard License Fee 118,409 57 ,765 (60 ,644) 83% 41% 142,091 142,091 Des Cty General Fund Grant 480,613 (480,613) 83% 0% e) 576,735 576 ,735 Des Cty Transient Room Tax 1,727,721 1,727,721 (0) 83% 83% 2,073,265 2 ,073,265 Des Cty Tax Office Contract 417 540 123 83% 108% 500 540 40 Asset Forfeiture 11,760 11,760 83% nJa 11 ,760 11,760 City of Sisters 389,967 390,067 100 83% 83% 467,960 467,960 Des Cty CDD Contract 45,305 45,305 0 83% 83% 54,366 54,366 Des Cty Solid Waste Contr 45,305 45,305 0 83% 83% 54,366 54,366 Des Cty Clerk/Election 833 1,068 235 83% 107% 1,000 1,400 400 School Districts 33,333 31,742 (1,591) 83% 79% 40,000 40,000 Claims Reimbursement 860 860 83% nJa 860 860 Security & Traffic Reimb 4,167 (4,167) 83% 0% 5,000 5,000 Seat 8elt Program 8,333 4,410 (3,923) 83% 44% 10,000 10,000 Miscellaneous 5,000 9 ,298 4,298 83% 155% 6 ,000 10,000 4,000 False Alarm Fees 1,667 3,400 1,733 83% 170% 2 ,000 4,000 2,000 Restitution 4,167 1,324 (2 ,843) 83% 26% 5,000 5,000 Sheriff Fees 8,333 7,877 (456) 83% 79% 10,000 10,000 Court Fines & Fees 100,000 102,914 2,914 83% 86% 120,000 120,000 Impound Fees 3,333 3,726 393 83% 93% 4,000 4,000 Restitution -Street Crimes 417 (417) 83% 0% 500 500 Seizure/Forfeiture 833 140 (693) 83% 14% 1,000 1,000 Interest 8,333 17,229 8,896 83% 172% 10,000 17,500 7,500 Interest on Unsegregated 1,500 635 (865) 83% 35% 1,800 1,800 Grants-Private 6,500 6,500 83% nJa 6,500 6,500 Donations 9,120 9,120 83% nJa 9,120 9,120 Land Sale Revenue 1,611 1,611 83% n/a 1,611 1,611 Sale of Equip & Material 8,333 3,706 (4,627) 83% 37% 10,000 5,000 (5,000) Sale of Reportable Assets 33,333 12,167 (21,166) 83% 30% f) 40,000 20,000 (20,000) Total Revenues 724.338 50% 89% 11,801,777 12.068,077 266,300 1,108.993 50% 94% 14.661.692 15,312.648 650,956 1 Exp. %1 (464) 83% 84% 150,373 (18,315) 83% 85% 1,144,109 (3,156) 61,572 83% 79% 1,468,080 40,100 74,866 83% 82% 8,113,497 155,861 21 ,618 83% 80% 677,517 40,100 42 ,114 83% 73% 409,125 5,535 16,733 83% 75% 197,790 (1,516) (0) 83% 83% 42,541 1,668113 2 .001,736 Transfer to Reserve Fund (704) Non Dept -Comm System Res Total Requirements 83,333 100,000 (16,667) 83% ---:-",-,;.10:;:.;0;,-'~00=0:-----:-=-712=-,0;,-'o=-'o:-:o:--------=-:(~2~0'-::,0=0*0) 83% --.!1!:.2,c:;2;.!.1~8,~0~77~....:1~0:,.:,3::::8::::8:,.:,5::::0::::5~---=.1l!,8:!2~9l!'5~7....:.....1 83% 100% 1 00% 71 % 100,000 120,000 14,661,692 100,000 120,000 12,423,032 2,238,660 Net 476,654 3,415,217 2,938,564 2,889,616 2,889,616 Beginning Net Working Capital per Proposed Budget a) Current year taxes due November, February and May b) JAG grant for 800 MHz radios c) Homeland Security grant Communication System Engineering Study d) Changes made at State level in distribution of Circuit Court revenue e) Will be received June 2013 f) less than planned revenue from sale of surplus vehicles 2,620,213 I Page 5 • Payment to Sheriff's Fund adjusted monthly to equal actual expenditures attributable to rural services PUBLIC HEALTH Statement of Financial Operating Data Ten Months Ended April 30. 2013 Year to Date Actual Variance Variance RESOURCES: Beg. Net Working Capital $1,336,051 $ 1,327,199 $ (8,852) 100% 99% $1,336,051 $1,327,199 $ (8,852) Revenues Medicare Reimbursement 833 68 (766) 83% 7% 1.000 100 (900) Federal Grant 9.000 9.000 83% nfa 9.000 9.000 Federal Grant (ARRA) 166.667 212.500 45.833 83% 106% 200.000 212.500 12.500 State Grant 2,428.624 2.033.002 (395.622) 83% 70% 2.914.349 2.934.303 19.954 Child Dev & Rehab Center 33.008 20.039 (12.969) 83% 51% a) 39.609 39.609 State Miscellaneous 112.283 120.320 8.037 83% 89% a) 134.740 134.740 OMAP 522.990 446.863 (76.127) 83% 71% 627.588 608,494 (19.094) Title 19 293 (293) 83% nfa 352 (352) Family Planning Exp Proj 458.333 389.838 (68,495) 83% 71% 550.000 550.000 Local Grants 40.000 10.000 (30.000) 83% 21% 48.000 40.150 (7.850) Environmental Health-Water 76.833 51.678 (25.155) 83% 56% 92.200 92.200 Contract Payments 86.508 131.614 45.106 83% nfa 103.810 173,404 69.594 Miscellaneous 2.172 2.172 83% nfa 3.000 3.000 Patient Insurance Fees 161.000 184.249 23.249 83% 95% 193.200 193.200 Health DepUPatient Fees 85.917 78.338 (7.579) 83% 76% 103.100 85.000 (18.100) Vital Records-Birth 34.167 27.655 (6.512) 83% 67% 41.000 32.000 (9.000) Vital Records-Death 83.333 92.765 9,432 83% 93% 100.000 100.000 Environmental Health-Lic Fac 600.042 705.047 105.005 83% 98% b) 720.050 740.050 20.000 NSF Fee 30 30 83% nfa 30 30 Interest on Investments 10.000 5.059 (4.941) 83% 42% 12.000 5.800 (6.200) Grants-private 14.063 33.753 19.690 83% 200% 16.876 34.000 17.124 Donations 4,417 19.219 14.802 83% 363% 5.300 22.277 16.977 Interfund Contract 132.191 122.949 (9.242) 83% 78% 158.629 164.000 5.371 Administrative Fee ____.::.66.::.7~__~6:.:6~7____~(~0) 83% 83% 800 800 Total Revenues 5,052,169 4,696,824 (355,345) 83% 77% 6,062,603 6,174,657 112,054 Transfers In-General Fund 1.957.800 1.957.800 83% 83% 2.349.357 2.349.357 Transfers In-PH Res Fund 50.113 45.102 (5.011) 83% 75% 60.136 60.136 Transfers In-Gen. Fund Other __.::.54..;.!.:=2.::.50::......__4.:..:8:,,!..8::.:2:.:5=-----__(l.,;:5;!..,4;.:2:.::.L.5) 83% 75% 65.100 65.100 TOTAL RESOURCES 8,450,383 8,075,750 (374,633) 83% 82% 9,873,247 9,976,449 103,202 REQUIREMENTS: I EXP.%I Expenditures Personnel Services 5.378.921 5.274.067 104.854 83% 82% 6,454.705 6.325.000 129.705 Materials and Services 1.784.898 1.587,490 197,408 83% 74% 2.141.878 2.136.883 4.995 Capital Outlay 54.167 54.167 83% 0% c) 65.000 65.000 Transfers Out 131.000 117.900 13.100 83% 75% 157.200 157.200 Contingency 878.720 878.720 83% nfa 1.054,464 1.054,464 TOTAL REQUIREMENTS 8,227,706 6,979,457 1,248,249 83% 71% 9,873,247 8,619,083 1,254,164 NET (Resources -Requirements) 222,677 1,096,293 873,616 1,357,366 1,357,366 Beginning Net Working Capital per Proposed Budget 1,385,592 I a) Received quarterly in arrears b) Restaurant and Pool/Spa fees are due annually and received in Dec/Jan c) OCHIN System expenditure made in FY 2012 Page 6 BEHAVIORAL HEALTH Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date Actual Variance Variance RESOURCES: Beg. Net Working Capital $3,320,968 $ 3,113,095 $ (207,873) 100% 94% $3,320,968 $3,113,095 $ (207,873) Revenues Marriage Licenses 5,417 4,375 (1,042) 83% 67% 6,500 6.500 Divorce Filing Fees 133.333 102,496 (30.837) 83% 64% 160,000 125.056 (34.944) Domestic Partnership Fee 38 85 47 83% 189% 45 100 55 Federal Grants 210.291 124.784 (85.507) 83% 49% a) 252.349 252.349 Federal Grant (ARRA) 53,125 42,500 (10.625) 83% 67% 63.750 63,750 State Grants 6,496,333 6.186.752 (309.581) 83% 79% b) 7.795.599 7.883,477 87.878 State Miscellaneous 51.550 31,461 (20.089) 83% 51% 61.860 61,860 Adult Mental Health Initiative 166.667 229,038 62.371 83% 115% 200.000 230,000 30,000 Title 19 224.538 82.042 (142,496) 83% 30% 269.446 125.000 (144.446) Liquor Revenue 117.917 79,479 (38,438) 83% 56% 141,500 100,000 (41,500) School Districts 57,500 18,150 (39.350) 83% 26% c) 69,000 21,900 (47,100) Contract Payments 34 34 83% n/a 100 100 Miscellaneous 12.291 12,291 83% nla 12,500 12.500 Patient Insurance Fees 72.943 83.372 10,429 83% 95% 87,532 100,000 12.468 Patient Fees 792 1,265 473 83% 133% 950 1,500 550 Interest on Investments 20.833 16,791 (4,042) 83% 67% 25,000 20,500 (4.500) Rentals 15,417 12,625 (2,792) 83% 68% 18,500 18.500 Forfeitures 168 168 83% n/a 168 168 Administrative Fee 4,410,439 4,332,474 (77,965) 83% 82% 5,292,527 5,292,527 Interfund Contract-Gen Fund 105,833 78.084 {27,749l 83% 61% a) 127.000 127,000 Total Revenues 12,142,966 11,438,265 (704,701) 83% 78% 14,571,558 14,442,787 (128,771) Transfers In-General Fund Transfers In-OHP·CDO Transfers In·Acute Care Svcs Transfers In-ABHA 1,089,822 403,745 220,530 436,700 1,089,823 403,745 220,530 436,700 0 - 83% 83% 83% 83% 83% 83% 83% 83% 1,307,787 484,494 264,631 524,039 1,307,787 484,494 264,631 524,039 TOTAL RESOURCES 17,614,731 16,702,157 (912,574) 83% 82"10 20,473,477 20,136,833 (336,644) REQUIREMENTS: EXP.%l Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency 9.633.918 5.502,463 41,750 170,000 1.713,100 9.032,357 4,567,446 (33,417) 153,000 601,561 935,017 75,167 17.000 1,713.100 83% 83% 83% 83% 83% 78% 69% -67% 75% n/a 11,560,702 6,602,955 50.100 204,000 2.055,720 10.835,000 5,550,000 30.000 204.000 725.702 1.052.955 20,100 2.055,720 TOTAL REQUIREMENTS 17,061,231 13,719,385 3,341,846 83% 67% 20,473,477 16,619,000 3,854,477 NET (Resources Requirements) 553,500 2,982,772 2,429,271 3,517,833 3,517,833 Beginning Net Working Capital per Proposed Budget a) Received quarterly, in arrears b) Oregon HeaHh Authority grant projected at amended contract amount c) Contract for services to school districts terminated by mutual agreement 3,461,651 I Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date Budget I Actual I Variance I FY % I Coli. % RESOURCES: Beg. Net Working Capital $ 10,000 192,482 $ 182,482 100% 1925% $ 10,000 $ 192,482 182,482 Revenues Admin-Operations 18,408 24,915 6,507 83% 113% 22,090 24,483 2,393 Admin-GIS 1,042 543 (500) 83% 43% a) 1,250 1.000 (250) Admin-Code Enforcement 138,500 190,898 52.398 83% 115% 166.200 178,000 11,800 Building Safety 1.061,313 1,237,714 176,401 83% 97% 1,273,575 1,190,747 (82,828) Electrical 213,333 267,376 54,043 83% 104% 256,000 268,496 12,496 Contract Services 93,000 99,931 6,931 83% 90% 111,600 184,800 73,200 Env Health-On Site prog 260,809 260,710 (99) 83% 83% 312,971 283,140 (29,831) Planning-Current 531,125 602,149 71,024 83% 94% 637,350 613,255 (24,095) Planning-Long Range 188,684 271,529 82,845 83% 120% 226,421 266,897 40,476 FY2013 Year End Budget Projection Variance Total Revenues 2,506,214 2,955,765 449,551 83% 98% 3,007,457 3,010,818 3,361 Transfers In General Fund -Gen Ops 712,390 712,390 83% 83% 854,872 854,872 General Fund UR Planning 412,800 412,800 83% 83% 495,360 495,360 A&T Reserve (DIS assistance) 74,648 85,409 10,761 83% 95% 89,577 89,577 Other 83 {83~ 83% 0% 100 {100} TOTAL RESOURCES 3,716,135 4,358,848 642,711 83% 98GA. 4,457,366 4,643,109 185,743 REQUIREMENTS: Exp·%1 EXPENDITURES & TRANSFERS Admin-Operations 1,127,658 1,094,003 33,655 83% 81% b) 1.353,189 1,311,323 41.866 Admin-GIS 98,148 96,193 1,955 83% 82% 117.778 117.778 Admin-Code Enforcement 190,771 174,075 16,696 83% 76% b) 228,925 216,747 12,178 Building Safety 517,573 500,673 16,900 83% 81% 621,087 621,087 Electrical 169,359 165,696 3,663 83% 82% 203,231 203,231 Contract Services 118,121 128,988 (10,867) 83% 91% c) 141,745 141,745 Env Health-On Site Pgm 133,030 129,957 3,073 83% 81% 159,636 159,636 Planning-Current 535,263 483,105 52,158 83% 75% d) 642,315 634,887 7,428 Planning-Long Range 386,168 308,027 78,141 83% 66% d,e) 463,401 349,567 113,834 Transfers Out (DIS Fund) 149,296 170,818 (21,522) 83% 95% 179,155 179,155 Contingency 289,087 289,087 83% n/a 346,904 346,904 TOTAL REQUIREMENTS 3,714,474 3,251,535 462,939 83% 73% 4,457,366 3,935,156 522,210 NET (Resources· Requirements) 1,661 1,107,311 1,105,650 707,953 707,953 Beginning Net Working Capital per Proposed Budget 696,290 I Revenues Expenditures Net from Operations 2,955,765 3,251,535 {295,77O l 3,007,457 4,457,366 {1,449,9091 3,010,818 3,935,156 {924,338} 3,361 522,210 525,571 a) Revenue is sporadic throughout the year as GIS services are requested b) Reflects savings due to combined CDD & Planning Director pOSitions c) Additional costs incurred for on-call building safety and electrical staff due to increased business activity d) Reflects savings due to Planning Director's reduced allocation e) Reflects savings from retired employee through 6/30/13 Page 8 ROAD Statement of Financial Operating Data Ten Months Ended April 30, 2013 Vearto Date Budget 1 Actual 1 Variance 1FY % 1 Coil. % FY 2013 YearEnd Budget PrOjection Variance RESOURCES: Beg. Net Working Capital $4,719,551 $ 4,723,852 $ 4,301 100% 100% $4,719,551 $4,723,852 $ 4,301 Revenues System Development Charge 2,310 2,310 83% n/a 3,000 3,000 Federal Grant (ARRA) 5,833 7,335 1,502 83% 105% 7,000 7,335 335 Mineral Lease Royalties 33,333 139,156 105,823 83% 348% 40,000 145,000 105,000 Forest Receipts 330,688 1,265,121 934,433 83% 319% a) 396,826 1,265,121 868,295 State Grant 2,618 2,618 83% n/a 2,618 2,618 State Miscellaneous 451,908 542,290 90,382 83% 100% b) 542,290 542,290 Motor Vehicle Revenue 8,991,703 8,854,056 (137,647) 83% 82% c) 10,790,043 10,450,000 (340,043) City of Bend 20,833 (20,833) 83% 0% d) 25,000 309,350 284,350 City of Redmond 291,667 11,554 (280,113) 83% 3% d) 350,000 387,240 37,240 City of Sisters 8,333 1,008 (7,325) 83% 10% d) 10,000 2,000 (8,000) City of La Pine 8,333 10,000 1,667 83% 100% d) 10,000 10,000 Admin Recovery (SOC) 2,662 2,662 83% n/a 3,500 3,500 Miscellaneous 16,667 20,312 3,645 83% 102";1, 20,000 23,000 3,000 Road Vacations 833 (833) 83% 0% 1,000 500 (500) Interest on Investments 12,500 26,163 13,663 83% 174% 15,000 32,000 17,000 Grants-Private 1,948 1,948 83% n/a 1,948 1,948 Interfund Contract 575,000 (575,000) 83% 0% e) 690,000 590,000 (100,000) Equipment Repairs 183,333 172,254 (11,079) 83% 78% 220,000 185,000 (35,000) Vehicle Repairs 75,000 (75,000) 83% 0% e) 90,000 80,000 (10,000) LID Construction 8,333 (8,333) 83% 0% f) 10,000 (10,000) Vegetation Management 20,833 (20,833) 83% 0% e) 25,000 50,000 25,000 Forester 20,833 (20,833) 83% 0% e) 25,000 25,000 Car Washes 3,333 1,630 (1,703) 83% 41% 4,000 2,500 (1,500) Car Rental 833 852 19 83°;1, 85% 1,000 1,000 Sale of Equip & Material 603,000 688,297 85,297 83% 95% 723,600 823,851 100,251 Total Revenues 11,663,129 11,749,566 86,437 83% 84% 13,995,759 14,942,253 946,494 Trans In -Solid Waste 230,227 207,204 (23,023) 83% 75% g) 276,272 276,272 Trans In -Transp SOC 208,333 (208,333) 83% 0% f) 250,000 (250,000) Trans In-Road Imp Res 10,000 (10,000) 83% 0% f) 12,000 (12,000) TOTAL RESOURCES 16,831,240 16,680,622 57,715 83% 87% 19,253,582 19,942,377 688,795 REQUIREMENTS: I Exp·%1 Expenditures Personnel Services 4,471,002 4,456,788 14,214 83% 83% h) 5,365,202 5,327,941 37,261 Materials and Services 7,865,552 4,986,941 2,878,611 83% 53% i) 9,438,662 7,931,846 1,506,816 Capital Outlay 1,697,750 60,676 1,637,074 83% 3% j) 2,037,300 73,884 1,963,416 Transfers Out 229,167 275,000 (45,833) 83% 100% 275,000 275,000 Contingency 1,781,182 -1,781,182 83% n/a 2,137,418 -2,137,418 TOTAL REQUIREMENTS 16,044,653 9,779,405 6,265,248 83% 51% 19.253,582 13,608,671 5,644,911 NET (Resources Requirements) 786,587 6,901,217 6,322,963 6,333,706 6,333,706 Beginning Net Working Capital per Proposed Budget 6,014,3681 a) Payment received annually in January b) Payment received annually in October c) Actual receipts are lower than projections d) Billed upon completion of work e) Payments to be received in June 2013 from other Road Department funds f) No SOC qualifying projects in FY 2013; no resources will be transferred in from SOC fund g) Payments made quarterly h) Retro COLA raises for 701 members, early retirement and resignations Page 9 i) Expenditures are seasonal and higher during summer months j) CIP project reserve carry over FY 2014 ADULT PAROLE & PROBATION Statement of Financial Operating Data Ten Months Ended April 30, 2013 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 Sale of Equipment Crime Prevention Grant CFC-Domestic Violence Total Revenues Transfers In-General Fund Year to Date Budget 1 Actual I Variance $ 570,000 $ 630,226 $ 60,226 182,700 219,240 36,540 3,584 (3,584) 12,500 (12,500) 11,522 22,329 10,807 2,290,462 2,748,555 458,093 18,750 12,126 (6.625) 3,750 4,089 339 108,333 138,654 30,321 158,333 148,594 (9,739) 7,500 4,765 (2,735) 41,667 41,667 (0) 250 250 41,667 37,500 (4,167) 62,360 46,345 (16,015) 2,943,128 3,424,112 480,984 362,770 362,770 IFY % 100% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% I Coil. % 111% 100% 0% 0% 161% 100% 54% 91% 107% 78% 53% 83% n/a 75% 62% 97% 83% a) b) c) d) e) f) g) g) FY 2013 Year End Budget Projection Variance $ 570,000 $ 630,226 $ 219,240 219,240 4.301 4,301 15,000 13,826 22,329 2,748.556 2.748,556 22,500 14,180 4.500 4,500 130.000 160,000 190.000 178,000 9,000 5,717 50,000 50,000 250 50,000 50,000 74,832 74.832 60,226 (15.000) 8,503 (8,320) 30,000 (12,000) (3,283) 3,531,755 3,531,905 435,328 435,328 TOTAL RESOURCES 3,875,898 4,417,108 541,210 83% 97% 4,537,083 4,597,459 60,376 REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Contingency 2,576,076 741,406 83 463,338 2,447,801 682,512 128.275 58,894 83 463,338 ! ExP.%! 83% 79% 83% 77% 83% 0% 83% n/a 3,091,291 889,687 100 556,005 3,041,291· 889,687 50,000 100 556,005 TOTAL REQUIREMENTS 3,780,903 3,130,313 650,590 83% 69% 4,537,083 3,930,978 606,105 NET (Resources -Requirements) 94,995 1,286,795 1,191,800 666,481 666,481 Beginning Net Working Capital per Proposed Budget a) Payment received annually in September b) Annual allocation normally received by end of calendar year c) Funds are specific to a certain population, which has been smaller than expected d) Received a one time only $8.000 distribution in addition to Quarterly payments e) Present economy has resulted in clients working off fees rather than paying f) Increased use of Electronic Monitoring pre-trial in lieu of jail g) State/County invoiced quarteriy-3rd Quarter payment not yet received 707,953 1 Page 10 250 150 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date Actual Variance RESOURCES: Beg. Net Working Capital $ 511,994 Revenues Federal Grants 253.797 Title IV -Family Sup/Pres 32,944 HealthyStart Medicaid 70,833 Youth Investment 164,082 State Prevention Funds 40.102 HealthyStart /R-S-G 183,291 OCCF Grant 349.830 Charges for Svcs-Misc 6,667 Program Fees Court Fines & Fees 66.238 Interest on Investments 833 Grants, Private 1,667 Interfund Grants 267.395 $ 567,120 $ 55,126 192,261 28,545 62,745 154,986 58.870 164,961 296.149 3,781 4,765 61,674 3,117 247.718 (61.536) (4,399) (8,088) (9,096) 18,768 (18,330) (53.681) (2,886) 4,765 (4,564) 2,284 (1,667) {19,677} 100% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 111% 63% 72% 74% 79% 122% 75% 71% 47% nla 78% 312% nfa 77% a) a} b) a) c) d) Variance $ 511,994 $ 567,120 $ 55,126 304.556 39.533 85,000 196,898 48,122 219.951 419,796 8,000 79,485 1,000 2,000 320.874 251.856 39.533 85,000 196,897 65,270 219.951 391,940 6,500 4,885 75,034 5,000 350,374 (52,700) (1 ) 17.148 (27,856) (1.500) 4,885 (4,451 ) 4,000 (2,000) 29,500 Total Revenues 1,437,679 1,279,573 (158,106) 83% 74% 1,725,215 1,692,240 (32,975) Trans from General Fund Total Transfers In 230,000 230,000 230,000 230,000 83% 83% 83% 83% 275,984 275,984 275,984 275,984 TOTAL RESOURCES 2,179,673 2,076,693 (102,980) 83% 83% 2,513,193 2,535,344 22,151 REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Contingency 539,562 1.311,230 83 243,453 484,543 1.049,996 55,019 261,234 83 243,453 1 Exp. %1 83% 75% 83% 67% 83% 0% 83% nla e) 647,474 1,573,476 100 292,143 567,051 1,561.808 80,423 11,668 100 292,143 TOTAL REQUIREMENTS 2,094,328 1,534,539 559,789 83% 61% 2,513,193 2,128,859 384,334 NET (Resources -Requirements) 85,345 542,154 456,809 406,485 406,485 Beginning Net Working Capital per Proposed Budget a} Projection based on actual awarded amounts-Medicaid reimbursements increased b} Projection adjusted to actual-grant has ended, and all funds expended c} State reduced the Circuit Court fees d) Additional grant funds of $17,500 -A & 0 70 and $12,000 EUDL projected to be received e) Personnel expenditures projected to be less than appropriated. Open positions will not be filled 375,704 1 Page 11 SOLID WASTE Statement of Financial Operating Data Ten Months Ended April 30, 2013 Vearto Date Budget I Actual I Variance I FY % I Coli. % FY 2013 Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 700,513 $ 807,470 $ 106,957 100°;;' 115% $ 700,513 $ 807,470 $ 106,957 Revenues Miscellaneous 18,333 15,415 (2,918) 83% 70% 22,000 22,000 Franchise 3% Fees 166,667 203,851 37,184 83% 102% a) 200,000 203,851 3,851 Commercial Disp. Fees 716,667 794,117 77,450 83% 92% 860,000 940,000 80,000 Private Disposal Fees 1,095,000 1,092,007 (2,993) 83% 83% 1,314,000 1,290,000 (24,000) Franchise Disposal Fees 3,333,333 3,307,058 (26,275) 83% 83% 4,000,000 4,035,000 35,000 Yard Debris 60,833 83,009 22,176 83% 114% b) 73,000 85,000 12,000 Special Waste 20,833 68,634 47,801 83% 275% c) 25,000 70,000 45,000 Interest 6,250 6,725 475 83% 90% 7,500 8,000 500 Leases 9,000 9,001 1 83% 83% 10,801 10,801 Donations 1,680 1,680 83% nfa 1,680 1,680 Sale of Assets 1,451 1,451 83% nfa 1,451 1,451 Recyclables 37,500 35,911 ~1,589l 83% 80% 45,000 42,000 !3,OOO~ Total Revenues 5,464,416 5,618,859 154,442 83% 86% 6,557,301 6,709,783 152,482 TOTAL RESOURCES 6,164,929 6,426,329 261,400 83% 89% 7,257,814 7,517,254 259,440 REQUIREMENTS Expenditures Personnel Services Materials and Services Debt Service Capital Outlay Transfers Out Road Capital Reserve Contingency 1,444,434 2,491,094 788,928 69,167 230,227 525,000 499,329 1,381,825 2,109,834 405,589 74,310 207,204 630,000 62,609 381,260 383,339 (5,143) 23,023 (105,000) 499,329 83% 83% 83% 83% 83% 83% 83% EXP·%I 80% 71% d) 43% e) 90% 75% 100% f) nfa 1,733,321 2,989,313 946,713 83,000 276,272 630,000 599,195 1,707,324 3,050,954 946,713 80,336 276,272 630,000 25,997 (61,641 ) 2,664 599,195 TOTAL REQUIREMENTS 6,048,179 4,808,762 1,239,417 83% 66% 7,257,814 6,691,599 566,215 NET (Resources· Requirements) 116,750 1,617,567 1,500,817 825,655 825,655 Beginning Net Working Capital per Proposed Budget a) Due April 15, 2013-A11 payments have been received b) Seasonal item-Fall and Spring c) Dependent on special clean-ups such as asbestos and contaminated soil d) Purchasing will pick up as year progresses e) Semi-Annual: November and May f) All of FY 2013 budgeted transfer made because resources needed for Fund 613'5 capital projects 825,655 I Page 12 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 NSF Fee Interest on Investments Other Interest TOTAL REVENUES TOTAL RESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY 5201 Settlement f Benefit 5202 Defense 5203 Professional Service 5204 Insurance 5205 Loss Prevention 5206 Miscellaneous 5207 Repair I Replacement Total General Liability PROPERTY DAMAGE 5204 Insurance 5207 Repair I Replacement Total Property Damage VEHICLE 5203 Professional Service 5204 Insurance 5205 Loss Prevention 5207 Repair f Replacement Total Vehicle WORKERS' COMPENSATION 5201 Settlement I Benefit 5203 Professional Service 5204 Insurance 5205 Loss Prevention 5206 Miscellaneous Total Workers' Compensation 5201 UNEMPLOYMENT -Settlement/Benefits Total Direct Insurance Costs Insurance Administration: Personnel Services Materials & Service capital OuUay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET Beginning Net Working Capital per Proposed Budget a) Annual premium paid in July 2012 * Contingency is $2,149,038 RISK MANAGEMENT Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date Budget I Actual I Variance I% of FY I % Coli. $2,000,000 218,611 261,233 144,696 1.200.147 208,333 417 50,000 1,667 42 13,333 12,500 42 $2,240,791 218,611 261,233 144,696 1,200.147 208,461 32,207 705 37 20,540 30 9,984 $240,791 0 0 (0) 0 127 (417) (17.793) (962) (5) 7,207 30 (2.516) !42~ 100% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 83% 112% 83% 83% 83% 83% 83% 0% 54% 35% 74% 128% nfa 67% 0% 2,111,020 4,111,020 2,0961650 4,337,441 {14!370} 226,421 83°,4 83% 83% 96% I %Exp. I 250,000 372.053 43,971 59,896 148,035 8,744 45 200 632,943 (382,943) 830/0 211% a) 208,333 159,171 48.753 207,924 410 83% 83% a) 83,333 366 15,416 42.056 57,838 25,496 83% 58% 293,259 833,333 131,788 33,420 33,170 491,638 341,696 83% 49% a) 208,333 116,017 921317 83% 46% 1,583,333 1,506.359 76,975 83% 79% 256,580 140,825 83 397,488 6,000 1,986!822 2,124,198 252,795 101,854 354,650 5,400 11866,408 2,471,032 3,785 38,971 83 42,839 600 1201413 3461834 83% 83% 83% 83% 83% 83% 82% 60% 0% 74% 75% 78% * Budget Year End Projection Variance $2,000,000 $2,240,791 $240,791 262,333 262.333 313,480 313,480 173,635 173.635 1,440.176 1,440.176 250.000 250.000 500 500 60.000 60,000 2,000 2.000 50 50 16,000 22.000 6.000 60 60 15.000 12,000 (3.000) 50 50 2,533,224 21536,284 3,060 4,533,224 4,777,075 243,851 300,000 250,000 700,000 230,000 (400,000) 20,000 100,000 70,000 30,000 1,000,000 2501000 550,000 230 1000 450,000 20 1000 1,900,000 1.780,000 120.000 307,896 168,990 100 307,896 168,990 100 476,986 476,886 100 7,200 213841186 2,149,038 7,200 ;264j 086 2,512,989 1201100 383,951 I 21517 1479 I Page 13 DESCHUTES COUNTY 911 Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date Actual Variance Variance RESOURCES: Beg. Net Working Capital $8,000,000 $ 8,883,086 $ 883,086 100% 1110/0 $8,000,000 $8,883,086 $ 883,086 Revenues Property Taxes -Current 5,456,406 6,042,775 586,369 83% 92% a) 6,547,687 6,256,420 (291,267) Property Taxes -Prior 154,167 290,752 136,585 83% 157% 185,000 290,752 105,752 Federal Grants 200,000 (200,000) 83% 0% b} 240,000 240,000 State Reimbursement 30,000 24,674 (5,326) 83% 69% c) 36,000 36,000 Telephone User Tax 625,000 383,681 (241,319) 83% 51% 750,000 767,242 17,242 Data Network Reimb. 25,000 31,856 6,856 83% 106% d) 30,000 43,804 13,804 Jefferson County 25,000 29,210 4,210 83% 97% 30,000 31,262 1,262 User Fee 36,667 4,313 (32,354) 83% 10% e) 44,000 44,000 Police RMS User Fees 232,458 212,647 (19,811) 83% 76% f) 278,950 252,000 (26,950) Contract Payments 25,833 1,988 (23,845) 83% 6% g) 31,000 1,988 (29,012) Miscellaneous 7,500 8,683 1,183 83% 96% 9,000 9,000 Claims Reimbursement 46,760 46,760 83% n/a h) 46,760 46,760 Interest 33,333 44,619 11,286 83% 112% 40,000 50,000 10,000 Interest on Unsegregated Tax 500 522 22 83% 87% 600 600 Total Revenues 6,851,864 7,122,480 270,616 83% 87% 8,222,237 8,069,828 (152,409) TOTAL RESOURCES 14,851,864 16,005,566 1,153,702 83% 99% 16,222,237 16,952,914 730,677 REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out-Reserve Fund Contingency 3,617,075 1,708,502 468,333 416,667 7,307,954 3,267,811 1,443,631 71,814 500,000 349,264 264,871 396,519 (83,333) 7,307,954 83% 83% 83% 83% 83% % Exp·1 75% 70% 13% 100% n/a i) 4,340,490 2,050,202 562,000 500,000 8,769,545 4,000,000 2,050,202 562,000 500,000 340,490 8,769,545 TOTAL REQUIREMENTS NET (Resources -Requirements) 13,518,531 1,333,333 5,283,257 10,722,309 8,235,274 9,388,976 83% 33% 16,222,237 7,112,202 9,840,712 9,110,035 9,840,712 Beginning Net Working Capital per Proposed Budget 9,800,000 I a) Current year taxes due November, February and May b) ODOT Project-reimbursements expected to be received over the next 2-3 months c) Mar/Apr payments outstanding; ongoing monthly reimbursements from Office of Emergency Mgmt for MSAG/GIS maintenance d) Annual billings are arriving from Police/Fire agencies e) US Forest Service invoiced $2,156.25 quarterly. Crooked River Ranch billed annually end of June f) RMS -Projection reduced to reflect actuals & the $29,103 expected from agency billings g) Protection reduced to reflect $29K now included in Police RMS User Fees line item h) Reimbursement for faulty UPS -American Power Conversion i) Amount appropriated was transferred September 15, 2012 Page 14 Health Benefits Trust Statement of Financial Operating Data Ten Months Ended April 30, 2013 FY 2013 Budget Projection Variance RESOURCES Beg. Net Working Capital $13,800,000 $ 14,551,028 $ 751,028 100% 105% $ 13,800,000 $14,551,028 751,028 Revenues: Intemal Premium Charges 10,662,500 10,728,980 66,480 83% 84% 12,795,000 12,871,238 76,238 PIT Emp Add'i Prem 41,667 26,089 (15,598) 83% 52% 50,000 31,000 (19,000) Employee Prem Contribution 525,000 539,113 14,113 83% 86% 630,000 645,000 15,000 COIC 1,083,333 1,174,827 91,494 83% 90% 1,300,000 1,410,000 110,000 Retiree' COBRA Co-Pay 625,000 771,094 146,094 83% 103% 750,000 925,000 175,000 Medical Services Reimb 716 716 83% nla 716 716 Prescription Rebates 66.836 66,836 83% nla 66,836 66,836 Claims Reimbursements 50,493 50,493 83% nla 50,493 50,493 Vending Machines (Wellness Rebate) 371 371 83% nla 371 371 Interest 66.667 60,690 (5,977) 83% 76% SO,OOO 71,000 (9,000) Total Revenues 13,004,167 13,419,189 415,022 83% 86% 15.605.000 16,071,655 466.655 TOTAL RESOURCES 26,804,167 27,970,216 1,166,050 92% 104% 29,405,000 30.622,682 1,217,682 REQUIREMENTS Expenditures: Personnel Services (a" clepts) 167,310 170,055 (2,745) 83% 85% 200,772 200,772 Materials & Services Claims Paid-Medical 8,358,500 9,947,050 (1,588.550) 83% 99% a) 10,030,200 12,156,193 (2,125,993) Claims Paid-Prescription 1,603,000 866.105 716,895 83% 46% a) 1,923,600 1,058,245 865,355 Claims Paid-DentalNision 1,488,500 1,522,273 (33,773) 83% 85% a) 1,786,200 1,787,124 (924) Claims Refunds (116,427) 116,427 83% nla (116,427) 116,427 Insurance Premiums 291,667 280,559 11,108 83% 80% 350,000 350,000 State Assessments 133,333 194,510 (61.177) 83% 122% 160,000 194,510 (34,510) Administration Fee 266,667 278,074 (11,408) 83% 87% 320,000 333,674 (13,674) Preferred Provider Fee 41,667 42,325 (658) 83% 85% 50,000 50,785 (785) Health Impact 45.833 43,495 2,339 83% 79% 55,000 52,175 2,826 Refund -ERRP 58,552 (58,552) 83% nla b) 58,552 (58,552) Other -Administration 54,461 37,751 16,709 83% 58% 65,353 65,353 Other -Wenness 87,500 27,780 59,720 83% 26% 105,000 70,000 35,000 Admin & Wellness 12,371,128 13,202,046 (830,919) 83% 89% 14,845,353 16,060,184 (1.214,831) Deschutes On-site Clinic Contracted Services 570,000 682,887 (112,887) 83% 100% c) 684,000 786,719 (102,719) Medical Supplies 25,000 24,101 899 83% 80% 30,000 30,000 Equipment 833 2,170 (1,337) 83% 217% 1,000 2,170 (1,170) Other 17,861 35,399 (17,536) 83% 165% 21,433 36,000 (14,567) Total DOC 613,694 744,556 (130.862) 83% 101% 736,433 854,889 (118,456) Deschutes On-site Pharmacy Contracted Services 256,906 290,779 (33,874) 83% 94% c) 308,287 343,325 (35,036) Medication and Drugs 833,333 1,167,307 (333,974) 83% 117% c) 1,000,000 1,500,000 (500,000) Start Up Costs-Take Care 59,898 59,898 83% nla c) 59,898 (59,898) Other 13,799 14,840 (1,041) 83% nla 16,559 30,000 (13.M1) Total Pharmacy 1,104,038 1,532,825 (428,786) 83% n/a 1,324,846 1.933,223 (608.377) Contingency 10,247,997 10,247,997 83% nla 12,297,596 12,297,598 TOTAL EXPENDIREQUIREMNTS 23,400,128 15,649,482 8.854.685 83% 53% 29,405.000 19,049,068 10,355,932 NET (Resources -Requirements) 3,404.038 12,320,735 10,020.735 11.573.615 11,573,615 Page 15 I Deschutes County -Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Ten Months Ended April 30. 2013 Year to Date Budget (10/121 of annual) Actual I Variance I FY % 1 Coil. % Year End FY2013 -et Projection Variance RESOURCES: Beg. Net Working Capital $ 46,373 $ 35,055 $ (11,318) 100% 76% $ 46,373 $ 35,055 $ (11,318) Receipts: Special Events Revenues 506.315 300,307 (206.008) 83% 49% 607.578 404.307 (203.271) Interest 1.250 (109) (1.359) 83% -7% 1.500 141 (1.359) Storage 47.868 35.283 (12,585) 83% 61% 57,441 35.283 (22,158) Camping at F & E 5,000 7,100 2,100 83% 118% 6,000 10,100 4,100 Horse Stall Rental 25,000 21,445 (3,556) 83% 71% 30,000 39,445 9,445 Concession % -Food 158,333 126,230 (32,104) 83% 66% 190,000 159,230 (30.770) Rights (Signage. etc.) 79,167 35,338 (43,829) 83% 37% 95,000 91,338 (3.662) Interfund Contract 16,667 47,000 30,333 83% 235% 20.000 45,000 25,000 Miscellaneous 5.667 2.598 {3,069} 83% nla 6,800 5.298 ~1.502~ Total Receipts 845,266 575,192 (270,075) 83% 57% 1,014,319 790,142 (224,177) Transfers In General Fund (001) 141,667 258,333 83% 152% a) 170,000 320,000 150.000 Room Tax (160) 21,453 21,450 83% 83% 25,744 25,744 Welcome Center (170) 69,000 69,000 83% 83% 82,800 82,800 Reserve Fund (617) 50,000 50,000 83% nla 50,000 50,000 Annual County Fair (619) 220,216 245,000 24,784 83% 93% 264,259 245,000 {19,259} Total Transfers In 452,336 643,783 74,784 542,803 723,544 180,741 TOTAL RESOURCES 1,343,975 1,254,030 (89,945) 83% 78% 1,603,495 1,548,740 (54,755) REQUIREMENTS: I Exp·%1 Expenditures: Personnel Services 693,235 686,312 6,923 83% 83% 831,882 825,014 6,868 Materials and Services 421,853 443,481 (21,629) 83% 88% 506,223 549,089 (42,866) Debt Service 95.099 70,609 24,491 83% 62% 114,119 114,119 Capital Outlay 11.883 9,000 2,883 83% 63% 14,259 9,000 5.259 Total Expenditures 1,222,069 1,209,401 12,668 1,466,483 1,497,223 (30,740) Contingency 114.177 114,177 83% nfa 137,012 137,012 TOTAL REQUIREMENTS 1,336,246 1,209,401 126,844 83% 75% 1,603,495 1,497,223 106,272 NET (Resources. Requirements) 7,729 44,628 36,899 51,517 51,517 Beginning Net Working Capital per Proposed Budget 48,8271 a) $100,000 budgeted as Transfer GF to Reserve fund will instead be transferred to Operating Fund and an additional $50,000 will be transferred from the General Fund Page 16 • CAPITAL PROJECTS • North County Campus • Sisters Health Clinic • Bethlehem Inn • Deschutes County North County Services Building Inception through April 30, 2013 ACTUAL ProjectReceived or II Encumbrances II Project to Expended & Commitments Date Budget * Projected Variance RESOURCES: Beginning Net Working Capital Loan Proceeds, net of issuance costs Resources from Fund 140 Resources from Fund 142 Transfer In (Fund 142) Interest Revenue Total Resources EXPENDITURES: Materials &Services Arch itecture/Des ig n Engineering Internal Service Fund Charges Fees, Permits & SDCs Utilities Travel -Meals/Mileage Reimb Total Materials & Services Capital Outlay Land and Building Remodel Total Capital Outlay Contingency Total Expenditures Net 1,402,013 25,000 600,000 6,296 2,033,309 51,735 11,236 991 15,451 23 79,435 1,402,013 230 1,402,243 1,481,678 551,631 25,000 25,000 25,000 (25,000) 1,402,013 25,000 600,000 6,296 2,033,309 a } b) 76,735 11,236 991 15,451 23 b) 104,435 1,402,013 a) 230 1,402,243 1,506,678 526,631 3,400,000 1,402,013 25,000 700,000 13,740 5,540,753 325,000 75,000 13,150 75,000 20,000 508,150 1,402,013 3 ,300,000 4,702,013 313 ,513 5,523,676 17,077 3,400,000 1,402,013 25,000 700,000 13,740 ~540,753 325,000 75,000 13,150 75,000 20,000 23 508,173 1,402,013 3 ,300,000 4,702,013 5,210,186 330,567 ~23} ~23} 313,513 (23) 313,490 * The project budget is the consolidation of FY 2012 (actual and unexpended budget) and FY 2013 adopted budget a) The building was purchased in FY 2011 with resources from Project Development and Debt Reserve (Fund 140) -$1,402,013 b) $25,000 was paid to the architect in FY 2011 with resources from General County Projects Fund (Fund 142) .. RESOURCES: Beginning Net Working Capital Federal Grants Resources from Fund 142 Transfer in (Fund 142) Interest Revenue Total Resources EXPENDITURES: Materials &Services Architecture/Design Engineering Planning Surveying Interfund Charges Fees, Permits & SDCs Utilities Miscellaneous Project Costs Miscellaneous Admin Costs Total Materials & Services Capital Outlay New Construction Total Capital Outlay Contingency Total Expenditures Net Beg NWC Per FY 14 Requested Budget Deschutes County Sisters Health Clinic (Fund 464) Inception through April 30, 2013 ACTUAL Received and Expe!!ded Encumbrances & Commitments Project to Date 40,000 48,626 100,000 361 188,987 40,000 48,626 100,000 361 188,987 56,499 56,499 1,140 2,029 1,469 25,549 1,140 2,029 1,469 25,549 993 26 87,705 993 26 87,705 51,447 51,447 501,283 501,283 552,730 552,730 139,152 501,283 640,435 49,836 {501.283) (451,448) 50,000 PROJECTION Project Budget Projected 500,000 a) 48,626 100,000 648,626 a) 78,626 15,000 5,000 1,785 30,000 2,000 1,000 133,411 b) 515,215 51~215 648,626 500,000 48,626 100,000 361 648,987 78,626 15,000 5,000 2,029 1,785 30,000 2,000 993 1,000 136,433 552,730 552,730 689,163 (40,175) Variance 361 361 (2,029) (993) {3,022~ {37,515} (37,515) (40,537) (40,175) a) $48,626 paid to the architect in FY 2012 with resources from General County Projects Fund (Fund 142) b) Additional costs due to delay in the project have not yet been determined . Deschutes County Bethlehem Inn (Fund 128) Ten Months Ended April 30, 2013 Budget Actual Variance 1 Fy%1 Coil. %1 Budget Projection 1 Variance1 1 RESOURCES: Beg. Net Working Capital $(2,710,000) $(2,710,173) $ (173) 100% 100% $(2,710,000) $(2,710,173) $ (173) Revenues Grants -Private 83,827 (83,827) 83% 0% 100,592 (100,592) Lease Payments 20,340 22 ,374 2 ,034 83% 92% 24,408 24,408 Total Revenues 104,167 22,374 (81,793) 83% 18% 125,000 24,408 (100,592) Transfers In : Project Development (140) 1,375,000 -(1,375 ,000) 83% 0% 1 ,650 ,000 -(1 ,650,000) Gen Capital Res (143) 883,333 (883,333~ 83% 0% 1 ,060,000 -(1 ,060,000} TOTAL RESOURCES (347,500) (2,687,799) (2,340,299) 83% ·2150% 125,000 (2,685,765) (100,765) REQUIREMENTS: Exp . %1 Expenditures Debt Serv ice : Interest Expense 20,833 12,296 8,537 83% 49% a) 25 ,000 15,000 10 ,000 Interest Payment 83,333 83,333 83% 0% 100 ,000 100,000 TOTAL REQUIREMENTS 104,167 12,296 91,871 83% 10% 125,000 15,000 100,000 NET (Resources -Requirements) {451,667l {2,700,095l (2,248,428l b) {2,700,765l (l65l a) Interest on April 2013 negative cash balance: $1,200.21. b) Inception through April 30 , 2013 Revenues -Lease Payments $ 71,190 Expend itures : 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 253,372 Total expended 2,771,285 Net $(2 ,700,095) • --------------- Deschutes County General Support Services -BOee Conference/Seminar. EducationiTraining and Travel Expenditures and Boce -County College Expenditures FY2013 eocc Conference &Travel I Jul I Aug I Sep I Oct I Nov I Dec I Jan I Feb I Mar I Apr IYTD Total Tammy Baney ~--.-----: ______...... __~___::_=__ Conf/Sem & Educ!Training i 30 - -~~1:::;0~~_-_~__--:::675 _____._8_0 62-:::--5___-_"~_ _:_8_=_10::_l f-. Travel Meals - . __. 20 - -66 -82 -i -:2::-:4-.::-0___-___~4::-:0C""":84 Accommodations -127 - -119 -, 1.715 -1.961 Airfare - • --.----------.-.--~+---.~,----'-"632 ~?ng ~---'. ~30-:!:-··-~-.. --... -;9-,,--9:~,--"~--=-::-=---~~~~'_;C-"-:'---____ ~:: ====3=:.LC==~==:C=!'-"-i--===~:==:=-+-::="'::::--'-==-:,==:c='r==:C=~!:==--l Alan Unger F?-~=c:.~~---=--~c---.-~-.......-.--------.-................. --~----~-==---------"-"'-'--SO------=7=5-----:60":5:---·----::-:::c5::-1Conf/Sem & Educ!Training 65 305· -65 65Travel Meals------.-------,.....----.--. -~-.-.-.--- Accommodations -------.-------~ ..... ---.---4-2-9--429 ---~-.---------~----_... irfare a;~~~~b~u!i;rs~e~m~e~nt==~·~~ -~... -_---~---:-:-=------................. --::.---:-.----.:-----~--------_--.---.------c"CCcc--1 ~ __11? _____-___~_____~__'~.____'..... 11 2 Ground Transport/Parking _____----'==-==c......::==.=.:=----==='=--==='c=---=.=-~=='=--==.::=::::--==-::::::::::........::==.c=--==.==~=::=::-===-1 Total Unger 65 112 • 734· • 65 80 75 65 1,195 Tony DeBone Conf/Sem & Educ!Training 30 • 15 470 10· 35 580 100 . 1.240 Travel Meals - - - - -76 • - • -76 ~:m-o---d-:-a-:ti-on-s-------_-_-~-_ -_ -_ -_:~_-~_~...~ ...~: -__ .._.._ __ ___...~ ....~ __.-_--_-:_..-.... ==~~2--=-9~~~~_·· -=--=--=--=--=--=-~-=-~.-=-.-=--=-=-.~_-_-_ -_ -_-_-::-"-~-::-39==-=-~-~-.--~----~6::-:8---i -----~------c_---Mileage reimbursement ••• 471 -562 . 399 405 . 1.836 Ground Transport • - • • -19· , . . 19 .. ---------.-..."'=~-===:::.......::==;:=;:----=;=~--=~=~;:--===--==;===:=:;:--===::~-===---===:;:~.~ ~-T~o~ta~I=De=B~o=ne~~-----~-----~-.----~-_______1:51,369 __1=-O__~6~57__.............3=5:_1~1.,3~1·1~8__5~05___-__~3~.939~ Other Education/Conference - - • -. - - • 315 315 --------------~~------~.--.-----.----------1 1;=====::::::::::::::::;:==.-......----===--------....--...--------...-~Total -BOCC Department -_....... , ..;;;..;;;;---------:--;:---=;;;;::-_ ..,,:;;;:-_ ............. ----:-:;;::;;-_ ............._-•. _._-_._- I------:~:_:..:ra=-~:=~~-'-':n=ea~~'=:-sE;-d_u~_ra_i_ni_n~ ___ -_-=-=_=_=t_?~_---2-0 .15 _..2~~_.___ )~. ~-:-:1~:c-----·---6::.:.5=--+-i__:::.!3,.::-:~.:-:0:-l_~_~=:_~~~-..:.1'-0:;' Accommodations ___ ._._.._.. ___ . ____-_________ ._..._~____ 857 1.~__-_ -.......~~~..~..__71:.!C,-:::7:1c::5::----------------~~-=----=3'_;;.1c::5~7 Airfare - -- - - -632 • 632 . Mil9Cl9~'3:~l11bursement __... --------------:4-=96-=----1,260 683 562 557 --831 ~--:6737=---2::-:6::::2:+------=-5,~288~ Groun~TranspoL...__ .... ..-----35------=-··~~-=-.,. . 19 ---------..-~ -i 196 _. Total-BOCC Department 125 678 15 2,8~3 888 657 804 1,910 4,480 327 J~.!77 _ FY 2013 Budget _ ._:=-___m::::--=-_-50;::!__=--==_=:=-:=====================:====-=======1::=:5,;:2;: flercent of FY 2013 Bu~get Expended _______.... ___ ...._...._..______._. _______________._.__._. ____.____._.____-----'___--=-83=-c..::..8°'-"-lVO eocc County College Office/Copier Supplies ____.. ___ 85 85 Meeting Supplies 761 , i 2.441 --;;;;;--;--;-== ---.....-------------------.....................=.,=-----=-c~-=-=-----------.---------,-~-----...:.!·-·---::-=·-1 Total BOCC County College 846 -!ll!!! - - - . -2,526 c==-------,___-------.......--.. -------.-----------.--... ---------~.......................:---c------~-- NOTE: Above amounts indudeonly those expendituresp~!)~fo'_rc::.Pa.::.y<.:.m..:..e::.:.n:.::.:t.__;_;:___---;--- Additional conference and travel costs may have been incurred. but not processed for payment. 5/812013 City of Bend: Immediate Study Area TGM Grant 2013 .... '-••Study Area [:::=J Taxlots Zoning CL ME RL SM --Major Roads " River ..CC IG _ MR RM --Roads ~Parks -CG IL " RH RS + N o 0 .1 0.2 i iMiles Prepared by City of Bend GIS , May 2013