The URL can be used to link to this page

2021-84-Minutes for Meeting February 22,2021 Recorded 3/11/2021UT E S COG2 o BOARD OF COMMISSIONERS 1300 NW Wall Street, Bend, Oregon (541 ) 388-6570 11 v Recorded in Deschutes County Nancy Blankenship, County Clerk CJ2021-84 Commissioners' Journal 03/ 11 /2021 9:11:29 AM 20II8IIIIIIIIIIIIIIIIIIIIIIII Barnes Sawyer Rooms Live Streamed Video Present were Commissioners Patti Adair, Anthony DeBone, and Phil Chang. Also present were Tom Anderson, County Administrator; David Doyle, County Counsel (via Zoom conference call); and Sharon Keith, BOCC Executive Assistant (via Zoom conference call). Attendance was limited in response to Governor's Virus orders. CALL TO ORDER: Chair DeBone called the meeting to order at 1:03 p.m. PLEDGE OF ALLEGIANCE ACTION ITEMS: 1. EDCO Annual Update EDCO representatives Roger Lee, Jon Stark, and Erin Chaiet were present at the meeting along with Brian Vierra and Don Myll via Zoom conference call. The annual update presentation is attached to the record. Agenda item change: Health Services agenda item 3 was given priority and placed at item 2 at this time. BOCC MEETING FEBRUARY 22, 2021 PAGE 1 OF 5 2. Consideration of Staffing Needs for COVID19 Incident Command Structure for Regional Vaccination Distribution and Recovery Efforts Health Services staff, Dr. George Conway, Nahad Sadr-Azodi, Janice Garceau, and Chris Weiler presented their request via Zoom conference call. Nine limited positions are being requested for staffing at the vaccination clinic. The staff reported the positions are expected to be funded 100% through FEMA. Commissioner Adair commented on the level of staffing that the department already has vacant. Commissioner DeBone explained the importance of documenting the staffing expenses under the FEMA reporting guidelines. Commissioner Chang expressed support and had concern of the department's capacity. The resolution will be considered on the BOCC meeting agenda of February 24, 2021. County Administrator Anderson noted if the FEMA funding does not come through for the positions, the general fund will need to cover the expenses. 3. Upper Deschutes Watershed Council Updates Community Development Department Will Groves and UDWC Executive Director Kris Knight presented via Zoom conference call. Mr. Groves explained he is the Deschutes County representative on the Upper Deschutes Watershed Council and noted the member appointments to be considered on the February 24 BOCC meeting. Mr. Knight presented an update and the presentation is attached to the record. 4. Storm Water Management and Underground Injection Controls Facilities Director Lee Randall was present at the meeting along with Abigail Black, Facilities intern (via Zoom conference call) to present the projects of the Facilities Department. A presentation was made on the Underground Injection Control project. Six years remain on the storm water DEQ permit. During rainstorms water is collected and tested within the first few hours of a storm. The findings have not shown any significant levels of concern. BOCC MEETING FEBRUARY 22, 2021 PAGE 2 OF 5 5. Deschutes County Treasurer and Finance Report for January 2021 Treasurer and Chief Financial Officer Greg Munn presented the report via Zoom conference call. Presentation is attached to the record. 6. Review of Leadership Bend Presentation Communications Director Whitney Hale presented a draft presentation for the virtual presentation for the Leadership Bend this Thursday, February 25. The Board prefers to meet in the Barnes Sawyer room for the use of the cameras and video equipment. After discussion, the Board decided it would be best to participate virtually via Zoom in their own offices so they did not have to wear face masks. Ms. Hale will be present via Zoom to advance through the slide presentation. 7. Legislative Priorities Communications Director Whitney Hale presented the item following the discussion at the Legislative Update Meeting of February 19. A letter of testimony in support of Certified Community Behavioral Health Clinic was presented for consideration. Ms. Hale presented the following bills for determination of Board's direction: HB 3123: Directs OHA to evaluate specified issues related to certified community behavioral health clinics and report findings and analysis to interim committees of legislative assembly by September 30, 2023. The Board expressed support of the letter presented. ADAIR: Move Board signature on letter of support for House Bill 3123 CHANG: Second VOTE: ADAIR: CHANG: DEBONE: Yes Yes Chair votes yes. Motion Carried BOCC MEETING FEBRUARY 22, 2021 PAGE 3 OF 5 SB 738: Prohibits assessment of civil penalty or fine for violation of state occupational or health measure if no disease outbreak of COVID19 occurred as a result of violation. Commissioner Adair expressed support. Commissioner Chang gave rationale for his opposition of the bill based on the risk of COVID spread commenting on businesses following and not following the Governor's guidelines and because we are not connecting COVID cases to bars and restaurants because we are not collecting the data. Commissioner DeBone recommends staying neutral. The Board will take the position on this bill of no position. SB: 741: Repeals sunset on and obsolete reporting requirement for Central Oregon Health Council. COHC has asked for support by the Commissioners on this bill. The Board expressed support. Ms. Hale will research further information on the bill. HB 2006: defines emergency shelter and requires local government to allow siting of qualifying emergency shelters by qualifying entities notwithstanding land use laws and regulations. County Administrator Anderson noted based on Deschutes County land use law if passed would require an amendment to the bill as currently written. The Board would support monitoring the bill at a priority 2. HB 5036: Appropriates moneys from general fund to Department of Veteran's affairs for certain biennial expenses. Commissioner Adair would support moving this bill to a priority 2. The Board expressed support. An additional list of current bills relative to Veterans were reviewed. Commissioner Adair requested to monitor HB 3003 as a priority 2 as well relative to granting higher property tax exemptions for disabled veterans. The Board expressed support. 8. Review Draft FY 22 Goals and Objectives Deputy County Administrator Erik Kropp presented the draft goals and objectives based on discussion at the Boards Planning Retreat of January 28, 2021. County Administrator Anderson noted the departments also use this document to draft their measurements and objectives. Commissioner Adair requested a revision. The Board requested a conversation with Timm BOCC MEETING FEBRUARY 22, 2021 PAGE 4 OF 5 Schimke, Solid Waste Operations Director regarding hours of operation of the landfill. OTHER ITEMS: • County Administrator Anderson reported on the vacancy on the local public safety coordinating council. Six applications were received through the recruitment process. The interview process will be held. • County Administrator Anderson noted one formal application was received for the COIC Tourism and Recreation. The Board will discuss this further on Wednesday February 24. EXECUTIVE SESSION: None presented ADJOURN: Being no further items to come before the Board, the meeting was adjourned at 4:34 p.m. DATED this Day of C'A 2021 for the Deschutes County Board of Commissioners. ATTEST: Ill�� Ili BOCC MEETING FEBRUARY 22, 2021 PAGE 5 OF 5 Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - www.deschutes.org BOCC MEETING AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:00 PM, MONDAY, FEBRUARY 22, 2021 Barnes Sawyer Rooms - Deschutes Services Center - 1300 NW Wall Street - Bend This meeting is open to the public, usually streamed live online and video recorded. To watch it online, visit www. deschutes. org/meetings. Pursuant to ORS 192.640, this agenda includes a list of the main topics that are anticipated to be considered or discussed. This notice does not limit the Boards ability to address other topics. Item start times are estimated and subject to change without notice. CALL TO ORDER MEETING FORMAT In response to the COVID-19 public health emergency, Oregon Governor Kate Brown issued Executive Order 20-16 (later enacted as part of HB 4212) directing government entities to utilize virtual meetings whenever possible and to take necessary measures to facilitate public participation in these virtual meetings. Since May 4, 2020, meetings and hearings of the Deschutes County Board of Commissioners have been conducted primarily in a virtual format. Attendance/Participation options include: Live Stream Video: Members of the public may still view the BOCC meetings/hearings in real time via the Public Meeting Portal at www.deschutes.org/meetings. In Person Attendance: Limited due to Virus restrictions. Please contact Sharon Keith at sharon.keith@deschutes.org prior to the meeting to request in person attendance. Citizen Input: Citizen Input is invited in order to provide the public with an opportunity to comment on any meeting topic that is not on the current agenda. Citizen Input is provided by submitting an email to: citizen input@deschutes.org or by leaving a voice message at 541-385-1734. Citizen input received before the start of the meeting will be included in the meeting record. Zoom Meeting Information: Staff and citizens that are presenting agenda items to the Board for consideration or who are planning to testify in a scheduled public hearing may participate via Zoom meeting. The Zoom meeting id and password will be included in either the public hearing materials or Board of Commissioners BOCC Meeting Agenda Monday, February 22, 2021 Page 1 of 3 through a meeting invite once your agenda item has been included on the agenda. Upon entering the Zoom meeting, you will automatically be placed on hold and in the waiting room. Once you are ready to present your agenda item, you will be unmuted and placed in the spotlight for your presentation. If you are providing testimony during a hearing, you will be placed in the waiting room until the time of testimony, staff will announce your name and unmute your connection to be invited for testimony. Detailed instructions will be included in the public hearing materials and will be announced at the outset of the public hearing. PLEDGE OF ALLEGIANCE ACTION ITEMS 1. EDCO Annual Update -Whitney Hale, Communications Director 2. Upper Deschutes Watershed Council Updates -William Groves, Senior Planner 3. Consideration of Staffing Needs for COVID-19 Incident Command Structure for Regional Vaccination Distribution and Recovery Efforts - Nahad Sadr-Azodi, Public Health Deputy Director 4. Storm Water Management and Underground Injection Controls - Lee Randall, Facilities Director 5. Deschutes County Treasurer and Finance Report for January 2021 - Greg Munn, Chief Financial Officer 6. Review of Leadership Bend Presentation -Whitney Hale, Communications Director 7. Legislative Priorities - Whitney Hale, Communications Director 8. Review Draft FY 22 Goals and Objectives -Erik Kropp, Deputy County Administrator OTHER ITEMS These can be any items not included on the agenda that the Commissioners wish to discuss as part of the meeting, pursuant to ORS 192.640. EXECUTIVE SESSION Board of Commissioners BOCC Meeting Agenda Monday, February 22, 2021 Page 2 of 3 At any time during the 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; ORS 192.660(2)(b), personnel issues, or other executive session categories. Executive sessions are closed to the public, however, with few exceptions and under specific guidelines, are open to the media. ADJOURN To watch this meeting on line, go to: www.deschutes.org/meetings meetings Please note that the video will not show up until recording begins. You can also view past meetings on video by selecting the date shown on the website calendar. Deschutes County encourages persons with disabilities to participate in all programs and activities. This event/location is accessible to people with disabilities. If you need accommodations to make participation possible, please call (541) 617-4747. FUTURE MEETINGS: Additional meeting dates available at www.deschutes.org/meetingcalendar (Please note: Meeting dates and times are subject to change. All meetings take place in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. If you have questions regarding a meeting, please call 388-6572.) Board of Commissioners BOCC Meeting Agenda Monday, February 22, 2021 Page 3 of 3 AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of February 22, 2021 DATE: February 5, 2021 FROM: Whitney Hale, Administrative Services, 541-330-4640 TITLE OF AGENDA ITEM: EDCO Annual Update BACKGROUND AND POLICY IMPLICATIONS: Roger Lee, CEO of Economic Development of Central Oregon, will provide EDCO's annual update to the Board. Founded in 1981, EDCO is a non-profit corporation supported by private and public members and stakeholders. Their mission is to create a diversified local economy and a strong base of middle-class jobs in Central Oregon. To do this, they focus on helping companies do the following: Move. Attract and guide outside employers through the relocation process as a resource for regional data, incentives, talent, site selection and more. Start. Mentor and advise scalable young companies from concept to exit on issues such as access to capital, critical expertise, and strategy. Grow. Partner with local traded -sector companies to help them grow and expand. FISCAL IMPLICATIONS: None ATTENDANCE: Roger Lee, CEO, Economic Development for Central Oregon HEARTLAND FORWARD In December, Heartland Forward published its Most Dynamic Metropolitans report comparing economic performance and vibrancy of 375 U.S. Metropolitan Statistical Areas (MSAs). The Bend -Redmond MSA (Deschutes County) came in at an impressive #12 this year, down seven spots from its #5 rank in its first study. The MSA was #7 among peer small metros. In addition to GDP, wage and job growth, this index specifically focuses on the proportion of total jobs coming from young businesses. EDCO's work is specifically called out in the report (page 68). In November, Global Trade Magazine highlighted small markets where there is concentrated critical mass of industry production or expertise — Small Powerhouses — !Niche Specialties Make These 20 Communities Stand Out. Bend was featured for its high number and output of craft brewing. USA TODAY An article entitled Career opportunities or retirement? ,Americans are flocking to these desirable destinations for both also ranked Bend #5 in the nation. Three of the top four remaining spots were taken by places in Florida. Impacts of COVID migrations from larger metros to smaller cities were also cited in this article. MOVE STAPT L.D, .. C., 0 oO, G R 0 W smartasst Smart Asset ranked the Top 10 counties in Oregon where property taxpayer dollars are spent most effectively. The Tri-county area took three of the top five spots. Measured in the analysis were effective property tax rates, several home value growth rates and school quality rankings. k. AdvisorSmith WalletHub again ranked Bend in its 2020 Fastest Growina Cities report, placing it at #2 of 515 surveyed, up one spot from last year. The report uses 17 factors of growth and decline over a seven- year period. Also during the quarter, AdvisorSmith ranked Bend as the #5 fastest growing midsize city in the U.S. between 2014-2019. International Business Times AdvisorSmith released its Fastest Growing Mid -Sized Cities in the U.S. report in June where Bend ranked #5 of 200 metros (100,000-250,000 pop.) between 2014-2019. Working from Home by Metro 14, 1 �" ®Benc1 10>_ S'� G t Pass®®vniYlanA x �Ih ®51®� a..., 4 = Medlan Mono 20," 3c" 40 W/ 60, Potential Work from Homy- Share State Economist Josh Lehner again highlighted Bend's status as national leader in this "work from home" article as a percentage of employment amidst COVID relocations from more densely populated metros to those less so. AREADEvEt pmm Faxtezt-Geowinq Mid-S)zo M.mkm, In February, this national periodical highlighted Bend in this chart and the advantages mid -sized markets offer employers from cost, talent base and supply chain perspectives. 3B8 py MILKEN INSTITUTE Now in its 21n year, this annual ranking of 201 small metros again recognized the Bend -Redmond MSA as the #1 place where "jobs are created and sustained" in the U.S. Our top ranking was further solidified relative to other metros. No other place has held the top spot for more than two years. # of Traded Sector Companies Moved to Central Oregon 9 17 0 25 2-yr. progress on 3-yr. goal MOVE CO- E.F-) START GROW DEALS2020 "MOVE' DONE DAYDREAM qqqq� +(P///aLTv,�0zl' . HQ MUS(GAl. PRp� UGTy y 4 •''•� COGNITIVE A SURPLUS 'ANN MOM— ►;J V©LANSI MANUFACTURING Some projects take time to develop. i3D Manufacturing's gradual relocation from the Columbia Gorge to Redmond provides a great example. REDI Sr. Director Jon Stark started working with the company's founders in 2015, only to have a portion of the operation (headquarters) move to available space in Bend. Perseverance and the trust of that relationship paid off as the company recently completed construction of its new manufacturing facility in Redmond that will also consolidate HQ offices that will bring an additional 15 jobs to the region. N Z Q J 0 >} UAV manufacturer and integrator Volansi's expansion to Bend and Prineville made national news, particularly within the industry. EDCO worked on the project over an 18-month period, hosting several site visits and providing research for the company to make an educated location decision. Fresh off a $50 million B- round capital raise, the firm expects to build up to 50 local employees over the next year and grow to as many as 150. For some businesses, COVID accelerated relocation strategies that were longer - range plans. That held true for the �PaTya�r founders of Smartypits, which moved both y HQ and manufacturing of its natural deodorant products from Southern California to Bend this fall. The company '`" •EE ^ now occupies an 8,000 sf light industrial space and expects to ramp up employment to 22 by next year. Major reasons for the husband -and -wife owners picking Bend included: superior lifestyle, local talent availability and a newly constructed industrial building. Barcelona -based software firm Algofy is in the marketing and data business, so it's only fitting that its hunt for a U.S. headquarters involved an extensive research project. Seven regions across the country made the short list, which led to site visits and then a six-month recruitment process by EDCO. In the end, Algofy founders were impressed by the friendly and collaborative business culture in our region, as well as the opportunity to grow the company in a dynamic regional economy. Inside the region, Redmond is the frontrunner for its offices. MOVE START EDCOG ROW 2020 'START" DONE DEALS "got* Dot" met0fiUs SHIFT, T 0 PUFFjN 12114k's S 0 U S Z E N R , " Iii 'I FA L L KRAHC 4w, �WSA 9 E P" ico V CAMPLION BLADERUNNER Rupie Investors $3,484,800 Engaged: New Payroll Added: Angel Created: Jobs 80 47 Events for Startup Companies Entrepreneurs Mentors Assisted: Conducted 0or Engaged: Supported: 352 ir 1 355 48 MOVE DCO START° GROW NATIONAL PRESS ON ENTREPRENEURSHIP (helping to secure/validate Top 10 ranking in the U.S.) In February, Entrepreneur highlighted research assembled by CloudKitchens, a startup Entrepreneur with investment from ex -Ober CEO that named Bend as the #2 "most entrepreneurial" city in the U.S. Data on the concentration of business owners as a percentage of total employment was taken from the U.S. Census Bureau. Research group AdvisorSmith published an article titled "Top Cities Where Americans Start the Most Businesses", where Bend was ranked in the Top 10 (#5) for mid -sized AdvisorSmiih cities. Bend also ranked #7 among cities of all sizes. The study results were based on the number of businesses formed on a per capita basis in 353 U.S. cities across all states and focused on businesses that employ at least one paid employee, which excludes entities like financial or real estate holding companies. sUAS s A combined recruitment effort by EDCO involving our Prineville and Bend offices and local the hus,t,ess of lanes public partners was successful in landing the Bay Area UAV startup Volansi. The location decision announcement created considerable media coverage including GeekWire, sUAS THE R O B OT R E PORE News and a host of other UAV industry periodicals. Volansi just raised a $50 million B- Round in September to help grow its fleet and deliver drone services to a host of private and public customers. In Q3 of 2019, we featured in this dashboard a TechCrunch article about Bend -based e ''re startup Dutchie. At that time, the co-founder brothers had raised $15 million from a set of high -profile investors. This quarter, Geekwire highlighted Dutchie's successful raise of a subsequent $35 million with participation from former Starbucks chairman, Howard °rechCrunch Schultz. Just three years old, the company now employs more than 100 people, its software processes more than 10% of all legal cannabis sales worldwide and it has raised a total of $53 million to date. Their ability to raise capital from across the country on this crunchbase scale is getting the region on the map as a place entrepreneurs can start and scale companies successfully — and capital -efficiently with world -class human talent. Crunch Sisters -based healthy foods company Laird Superfood made history by being the first "rang Central Oregon company in 20 years to go public, and with it, the bell" on the NYSE. The offering picked up press across a broad range of media including numerous Forbes interviews with owner/co-founder and big wave surfer celebrity Laird Hamilton and CEO/Co-Founder Paul Hodge. The IPO raised $58 million in addition to $42 million it had MarketWatch already raised from private investors in the preceding three years — all in a town of less than 3,000 residents. Bend startup Lora DiCarlo received a huge splash of national and international media Forbes attention (Fast Company, Rolling Stone, Vogue, DailyMail, Cosmopolitan, and many F�STCMPANY others) when it announced its partnership with English actress Cara Delevingne. The company is looking to disrupt the SexTech category with its advanced robotics that helped it win a coveted Consumer Electronics Show (CES) award for innovation in 2019. ` According to Forbes, the company now has $7.5 million in sales and a new funding round ``�/ �� I'll of $3 million led by Republic Labs and including new and existing investors like Romulus l Capital, VU fund, River Bend Capital, Gaingels, and Cara Delevingne. MOVE START GROW 'START" `" STORIES TO SHARE Dogs love to get treats when they've done something good, and dog owners want to train their dogs to be W/(F well-behaved. But the market problem Mark Shenfield set out to solve was to create a treat that did not leave owners pockets lined with crumbs and smelling like dog food. He's pioneered Pawket Treats, an all - natural dog treat using some the of the same technology and equipment used in pill production. These are REp� definitely not your mom's dog treats, resembling fine coinage, not a greasy morsel. Mark worked with EDCO Director Caprielle Lewis to get the company started in Sisters, but a newly -constructed light industrial complex in Bend lured him to set up a state-of-the-art manufacturing facility to help meet exploding demand. Since that decision was made, he's worked with Venture Catalyst Brian Vierra and Bend Area Director Don Myll on issues including enterprise zone tax incentives and early -stage capital. A year ago, Tim Schelhaas was a busy mechanical engineer for an industrial vacuum company supplying the semiconductor industry. Today, he and his wife are founder -owners of Top Dog Fabrication in Prineville. COVID significantly changed how work happened in his previous career so he took the opportunity to make his own "next job". Top Dog provides full -service manufacturing using metal (steel, aluminum, etc.), fiberglass, wood, glass, composites, and plastics. Additionally, the startup also has industrial powder coating capabilities and specializes in plasma cutting. The founders were referred to EDCO by a developer for incentive information and as a resource for everything community or business -related. Prineville/Crook County Director Kelsey Lucas helped them access enterprise zone incentives and got them connected to local media as well as other local businesses in the region. c It has been said in our communication throughout COVID, but we continue to be impressed and inspired by the ingenuity and decisiveness of our Central Oregon SHIFTbusinesses during this time of great uncertainty and concentrated disruption. One particularly memorable example is Bend software startup Shift, which launched as a bias training tool for the HR industry but pivoted to providing a virtual reality training suite for hospitals and clinics for hygiene, cleaning and engaging COVID-19 patients. They outsourced the virtual reality coding to another local company, Zero Transform, while at ccr oTG52f 11=c�PFr,. the same time doing an equity capital raise. The book on this "shift" is yet to be written but hats off to these business leaders for identifying both a needed public health tool and potential market opportunity. This past year, the pandemic pushed large segments of the population outdoors. If you tried to find ultralight food options this summer in preparation for a hiking or other backcountry outing, options were few — demand greatly outstripped supply. Co -Founder Julie, and her son Henry, saw the market opportunity and inspiration when she saw a lack of healthy options for outdoors activities where packing weight is an issue. The company's meals have been a huge hit and sales have taken off in 2020. EDCO helped the startup find FDA -approved commercial kitchen space for production and played a role in the company corralling financial capital for growth. Company Outreach 400 200 s 0 fa r 2018 2019 2020 Q1 MQ2 Q3 €z Q4 MOVE DCO� START GROW 2020'GROW'DONE DEALS • • F'n eI,% WAR TRIBE b m s <voh,,Uloc„«5 liil ®� E eNewal 0 PoL—X •w...�...�.-�-- c-L-. � FvEcsAFE it Monza Five Talent �'r''��,�►- =+� UISIBIBUIIBB Inc BR64NS BC4INETS KDE Direct Some business development projects span decades. Back in 2006, Brian's Cabinets owner Todd Hakala looked to Redmond for expansion and worked actively at the time with both the EDCO Bend office and REDI. The Great Recession upset those plans as the company's orders contracted dramatically when construction activity came to a halt. But by 2018, the company had again outgrown its space. Ultimately, mostly with the help of builder - developer Kevin Spencer and secondarily from EDCO and Bend Business Advocate Ben Hemson, a new 40,000 sf building was completed and occupied in the fourth quarter of 2020. For a more complete story, see this CBN article. %C m .,. Despite huge economic impacts to our nation, state and region, Z ! Redmond has continued to see brisk activity for both business recruitment and expansion of existing traded -sector companies. N One example of that activity was the groundbreaking for a new Q� 75,000 sf manufacturing building by BASX, which established its o 'headquarters in RedmondR m n i q ed o d just eight years ago following a 17 year attraction effort. Indeed, economic development takes time. This addition to the company's 120,000 sf plant and HQ offices will facilitate more than 15 well -paying jobs to the company's payroll. Look for the opportunities, we're told, Family -owned BMS Technologies had for even during an economic downturn. This years been searching for a new home to holds true for Sisters startup company grow its business. In 2016, the De Spaltro Josie's Best Gluten Free Mixes, whose family contacted EDCO about working with _O o sales were positively impacted by COVID- the City of Bend to acquire land at Juniper v 19. CEO/Founder Josette Johnson Ridge. The company successfully acquired N attributes this to more people shopping a lot and completed construction of a new, online and more people with extra time on their hands to bake. She even earned 45,000 sf building in 2020. EDCO also helped the company secure property tax a spot on Good Morning America at the exemptions offered by the Bend end of 2020 to talk about her success and Enterprise Zone. products. MOVE START EDCOGROW RDM Passenger Growth 900,000 800,000 1 :, 700.000 m 600.000 500.000 y c5 400,000 300,000 200,000 100,000 O ;. Q3 Q4Q1 Q2 Q3Q4 Q1.Q2 Q3Q4:Q1 Q2IQ3 Q4Q1.Q2 Q3 Q4 Q1 Q2'. 2015 2016 2017 2018 2019 2020 MRffimOND • Retained nearly all non-stop destinations (except Las Vegas, Chicago) • Added new service to San Jose • Retained new service to San Diego, Los Angeles • Progress made on future direct service to Dallas -Ft. Worth 4 Oregon trye Progress was slow in 2020 after ramping up capacity in March by adding two new Internship Coordinators, but the structure is in place to grow internship placements in 2021 and beyond. Larry Holeman Debbie Taylor John Charles MOVE E D_ START OR0W F f S, y p g iy New Industrial & Office Space 2018-20 Over the past three years we've been able to help catalyze 309,735 sf of new space for lease in Bend. Specifically, for all communities, these are buildings that have either been delivered to the market, are currently under construction or have been approved/are in the planning process. An additional 108,000 sf was built for owner -occupied buildings or additions over the period. In Redmond, work with developers has produced 325,970 sf new space for lease, nearly of which is light industrial. An additional 273,360 sf was built or is in process for owner -occupied buildings or additions. The combined nearly 600,000 sf represents a remarkable 36% of the community's entire existing inventory of 1,663,921 sf that has been built over the past 50 years. For years, Sisters has struggled with very low inventory of existing buildings available for lease. Over the past three year the community has added 60,404 sf new space for lease. An additional 132,718 sf was built or is in process for owner -occupied buildings or additions. Combined, these two figures are more than was built in the community over the previous decade. Prineville also added some new spec industrial space, 40,000 sf, all via one developer in Baldwin Industrial Park. Owner -occupied expansion added 15,600 sf new space, but this excludes the massive data center campus construction happening at both Facebook and Apple. An additional 233,000 sf of improved former wood products (Woodgrain Mill) also came on for multi -tenant occupancy, but since it was existing previously, was not included as "new". High Desert Industrial Park, Bend Red Barn Industrial Park, Redmond Live/Work Light Industrial Complex, Sisters Prineville Campus, Prineville \XvT E S CO o Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - Fax (541) 385-3202 - https://www.deschutes.org/ AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of February 22, 2021 DATE: February 11, 2021 FROM: Nahad Sadr-Azodi, Health Services, TITLE OF AGENDA ITEM: Consideration of Staffing Needs for COVID-19 Incident Command Structure for Regional Vaccination Distribution and Recovery Efforts RECOMMENDATION & ACTION REQUESTED: Staff request approval of additional positions to improve capacity and COVID-19 vaccination distribution. A Board Resolution relative to the requested positions will be brought to the February 24, 2021, Board of County Commissioners' meeting for consideration of approval. BACKGROUND AND POLICY IMPLICATIONS: In December, the County established an Incident Command Structure (ICS) staffed through Health Services, Sheriffs Office and Finance to respond quickly to rising COVID-19 numbers across the region as well as forthcoming vaccine distribution. Since that time, a mass vaccination center at the Fair and Expo Center was established in partnership with St. Charles Health Systems, a regional effort, which is essential to continuing to vaccinate our community. Over the next two to six weeks, several key roles in the ICS will phase out and return to their normal positions in the County. Health Services is not structured to support an unpredictable, protracted pandemic and tri-county vaccination effort while also maintaining its normal responsibilities. It is essential to our community's health to establish an ICS that is sustainable over several months (6.0 full-time equivalent (FTE) March 1-December 31, 2021; 1.0 FTE March 1, 2021- June 30, 2022; and 2.0 FTE March 1, 2021-September 30, 2023) that can be adjusted when necessary based on variables such as case rates, vaccine availability, distribution logistics, recovery efforts, staff changes, etc. To do so, we are requesting approval of the following key roles: 6.0 limited duration FTE March 1-December 31 2021 The following limited -duration positions will be externally recruited effective March 1, 2021 (the respective County classification is listed following each ICS role): • 1.0 FTE Incident Commander [Operations Officer] (Position will initially serve as Deputy Incident Commander working with Christopher Weiler until April 15, at which time Mr. Weiler will be demobilized from Incident Command.) • 1.0 FTE Vaccine & Testing Operations Section Chief [Health Services Supervisor] 1.0 FTE Logistics Chief [Health Services Supervisor] 1.0 FTE Operations Section Assistant [Administrative Support Technician] • 1.0 FTE Call Center Coordinator [Public Health Educator II] 1.0 FTE Medical Respite Coordinator [Public Health Nurse II] 1.0 limited duration FTE March 1. 2021 June 30, 2022 The following position will assist in recovery efforts: • 1.0 FTE COVID-19 Response & Recovery Operations Section Chief [Health Services Supervisor] 2.0 limited duration FTE March 1. 2021-September 30, 2023 Due to Behavioral Health's growth, managers maintain large spans of control, having between four and six supervisors reporting to them as well as their clinical teams and administrative supports. There is limited time outside of the direct activities of their specific program's work to focus on projects such as quality improvement. There is a need to maintain division -wide administrative and clinical oversight that focuses on such quality including, but not limited to, healthcare integration projects, access and referral processes, and clinical practice guidelines. In addition, two teams (Access and Medical) with agency -wide responsibility currently need manager oversight. There is not adequate manager capacity to assign these large teams to an existing manager. To address this, Health Services planned to submit a special request as part of the Fiscal Year (FY) 2022 budget process to add 1.0 FTE Behavioral Health Manager and 1.0 FTE Administrative Support Specialist. However, there is an immediate need to deploy these positions to the ICS. These positions would have the skill sets necessary to serve as Deputy Incident Commander (IC) and administrative support to the Deputy IC, and would do so through December 31, 2021. Following deployment, these staff will transition back to Health Services. It is anticipated that many of the recovery activities likely to occur later in deployment will be directly relevant to this manager's span of duties upon return, i.e., access, referral, integration and managing increased acuity and need across behavioral health services. Ongoing funding for the Behavioral Health Manager and Administrative Support Specialist positions, after Federal Emergency Management Agency (FEMA) reimbursement, will be through the Certified Community Behavioral Health Clinic (CCBHC) Demonstration Funds, which were approved for continuation through September 30, 2023, by the Federal government. The State approved General Funds to support the match through June 30, 2021. Health Services estimates receiving an anticipated $2 million in revenue during FY 2021. Funding The FEMA is supporting vaccination distribution at 100% federal cost share with expedited reimbursement through September 30, 2021. Eligible expenditures include medical and support staff not paid for by another funding source; and the County intends to submit a reimbursement request that would include the following positions through September, 2021. County General Funds (CGF) are requested to cover these positions should the County not be eligible for, nor receive, FEMA reimbursement prior to September 30, 2021. County General Funds are directly requested to cover 7.0 FTE limited duration positions following September 30, 2021; and CCBHC Demonstration Funds will cover the 2.0 FTE within Behavioral Health. Estimated expenses: LIMITED DURATION FTE COVID-191CS Operations Officer HS Supervisor - Vaccine & Testing HS Supervisor- Logistics Chief HS Supervisor- COVID Response & Recovery Admin Support Tech - Operations Assistant Public Health Educator II - Call Center Coordinator Public Health Nurse II - Medical Respite Coordinator TOTAL LIMITED DURATION FTE COVID-191CS, CCBHC BH Program Manager Admin Support Specialist TOTAL FEMA REIMBURSEMENT FEMA FEMA UNCOVERED UNCOVERED 1.0 48,657 38,482 38,482 1.0 39,449 31,241 31,241 1.0 39,449 31,241 31,241 - 1.0 39,449 31,241 31,241 62,483 1.0 24,679 19,396 19,396 - 1.0 33,819 26,685 39,282 1.0 35,202 27,768 40,869 7.0 260,704 206,054 231,752 62,483 FEMA FEMA CCBHC ONGOING CCBHC ONGOING 1.0 52,989 41,911 41,911 83,822 1.0 26,581 21,123 21,123 42,246 2.0 79,570 63,034 63,034 126,068 FISCAL IMPLICATIONS: Increase appropriation for FY 2021 Health Services Fund 274 (HS Operating Fund) by $340,274, approve the following positions: 0 6.0 limited duration FTE March 1 -December 31, 2021 0 1.0 FTE Operations Officer 0 2.0 FTE Health Services Supervisor 0 1.0 FTE Administrative Support Technician 0 1.0 FTE Public Health Educator II 0 1.0 FTE Public Health Nurse II • 1.0 limited duration FTE March 1, 2021-June 30, 2022 o 1.0 FTE Health Services Supervisor • 2.0 limited duration FTE March 1, 2021-September 30 2023 0 1.0 FTE Behavioral Health Manager 0 1.0 FTE Administrative Support Specialist ATTENDANCE: Nahad Sadr-Azodi, Public Health Director; Janice Garceau, Behavioral Health Director; Cheryl Smallman, Business Officer; Christopher Weiler, Operations Officer and Incident Commander; George A. Conway, Health Services Director - via Zoom ES COG Z o Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - Fax (541) 385-3202 - https://www.deschutes.org/ AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of February 22, 2021 DATE: FROM: William Groves, Community Development, 541-388-6518 TITLE OF AGENDA ITEM: Upper Deschutes Watershed Council Updates BACKGROUND on the Upper Deschutes Watershed Council and Committee Membership/Appointments Established and formed by: Bylaws March 4,1997; Amended November 8, 1999 & October 13, 2003. Membership and terms (as described by Bylaws): Article V. Board of Directors Section 1. Duties. The affairs of the corporation shall be managed by its Board of Directors. Section 3. Number. The number of board members may vary between a minimum of nine (9) and maximum of eighteen (18), the exact number of which shall be fixed from time to time by resolution of the Board. Section 4. Qualifications. Board members shall represent various areas, organizations, (interests), and land ownership groups found in the Deschutes County watershed and support the corporation's mission and bylaws. Section 5. Appointment. The initial Board of Directors has been, and subsequent Board Members shall be, appointed by the Deschutes County Board of Commissioners. The Board of Directors shall appoint a nominating committee to nominated candidates to fill vacancies on the Board, Nominations shall be submitted to the Deschutes County Board of Commissioners for appointment. Section 6. Term. The term of office for Board Members shall be three (3) years. A board member may be re- elected without limitation on the number of terms he/she may serve. The Board members shall be divided into three equal cohorts and the terms shall be staggered by class. One such cohort of Board members shall be appointed each year. Section 8. Vacancies. Vacancies on the Board of Directors and newly created Board positions will be filled as provided in Section 5 of this Article V. Purpose (as described by Bylaws): Article III. Purpose This corporation shall be organized and operated as Watershed Council as defined in ORS 541.350(7). Subject to the limitations stated in the Articles of Incorporation, the purpose of this corporation shall be to engage in any lawful activities, none of which are for profit, for which corporations may be organized under Chapter 65 of the Oregon Revised Statutes and Section 501(c)(3) of the Internal Revenue code of 1954 (or their corresponding future statutes). This corporation's primary purposed will be: A. To assist in addressing watershed management issues in the Deschutes River watershed, serve as an advisory body to established decision -making bodies, and provide a framework for promoting coordination and cooperation among key interests in the development and implementation of a watershed action plan. B. To foster better stewardship of the Deschutes River watershed resources, address issues in advance of resource degradation, and ensure sustainable watershed health, function and uses through the cooperative efforts of industry, conservation groups, natural resources agencies and residents, while improving the ecological, economic and community stability within Deschutes County. C. To encourage participation by agency representatives, including federal, tribal, state, and local agency staff representatives, as technical advisors to the corporation. D. To promote collaborative activities with partnering organizations including the Deschutes County Soil and Water Conservation District, Deschutes Basin Land Trust, Deschutes Resource Conservancy and other entities, in matters pertaining to the Deschutes County watershed. ATTENDANCE: Via Zoom: Will Groves, Senior Planner, Community Development Department and Kris Knight, Executive Director Upper Deschutes Watershed Council Tree Upstream Project We refer to our environmental education program as The Upstream Project. This is due to the fact that sometimes coor- dinating unique, hands-on, outdoor education activities can feel like swimming upstream. Certainly, this was the case in 2020 which has been a year like no other where COVID-19 caused schools to switch to remote learning. Our educators have adapted our programs to offer lessons as online videos that have been utilized by local teachers and parents this past year. All of our educational activities help support teachers to accom- plish educational targets while giving students positive ways to connect to nature. During this 2020-2021 school year, we are offering a combination of in -person learning opportunities for small groups of children to learn outside while also coordinating remote, real-time lessons with students and teachers and creat- ing more videos that can be used by parents and educators as school continues remotely in Central Oregon. Through art, writing, science, music, and outdoor exploration, we seek to connect youth to the natural world in order to inspire them to develop a sense of place, a sense of stewardship for our rivers and streams, and an inspired and empowered sense of self. Our restoration work, like many things this past year, was not spared from some of the challenges of 2020. Our Res- toration Program Manager, Mathias Perle, employed all his patience and persistence to keep projects moving forward. A stream habitat restoration project planned at Whychus Creek in Whychus Canyon was postponed because of un- certainties resulting from the COVID-19 pandemic. Another project to remove the last dam and fish passage barrier on Whychus Creek approximately 5 miles upstream from Sisters on U.S. Forest Service land started in early Sep- tember but was then shut down when catastrophic forest fires broke out in Oregon which prompted the U.S. Forest Service to shut down all activities on Forest Service land. Some work on this project, including installing an irrigation diversion fish screen and piping the irrigation canal was completed this Fall but the removal of the dam to restore fish passage was postponed until Summer 2021. Another irrigation diversion fish screen was installed this Fall on Lake Creek, a tributary to the Metolius River, with funding from UDWC. Five projects are now planned for restoration in the coming years and we are hopeful to finish implemen- tation of three of these project in 2021. Our monitoring work carried forward this past year with some creativity and resourcefulness from staff and vol- unteers, led by our Monitoring Program Manager, Lauren Mork. This spring with schools closed, Alyssa Grove, who typically is leading field trips with students as our Education Coordinator, stepped up and filled in to collect monitoring data that would normally be collected as part of a UDWC internship. While we were disappointed to not offer our nor- mal monitoring internship this year because of COVID-19, we were able to offer a short-term internship in July. We are thankful for Aspen Peterman who helped UDWC as an intern in July to collect data at Whychus Creek. In 2020, UDWC continued to collect temperature monitor- ing data, at 11 sites along Whychus Creek and 7 sites along the Deschutes River and Tumalo Creek, to better under- stand the temperatures in these rivers and creeks in rela- tionship to the needs of fish and other aquatic species as well as how stream temperatures are changing with stream flow restoration actions. In August, UDWC led an effort with volunteers and partners to collect rnacroinvertebrates at Cover: Monitoring work in Whychus Creek, Photo by Aspen Peterman Opposite: The Upstream Project, Photo by Marisa Chappell Hossick Top: Plainview Dam on Whychus Creek upstream of Sisters (to be removed 2021), Photo by Scott Wright, River Design Group Bottom: Restored section of Whychus Creek downstream of Sisters, Photo by Michael Wing, Oregon State University various locations along Whychus Creek to better understand the macroinvertebrate community and whether restored project sites have improved numbers of macroinvertebrates providing a food source for fish and aquatic species. Also this summer UDWC started work with a number of partners and experts to test methods for using drones to collect data on post -restoration stream habitat conditions, in combination with data from ground -based monitoring methodologies. This will help UDWC and others understand over time if there are more efficient and cost-effective ways to monitor effectiveness of stream restoration projects. Expenses ---------- State Grants $286,998.88 Non -Governmental Grants $261,059.10 Federal Grants $222,734.07 Deschutes County Grants $20,000.00 Donations $53,066.80 Other Revenue $74,569.16 Total $918,428.01 ODOM Education' $149,446.64 Restoration $417,253.94 Monitoring $132,921.04 Fundraising $59,234.92 Deschutes L General/Adi-ninistrative $168,344.43 —1 Donations 5.8% Fundraising GA-,,� County Grants 2.2% Total $927,200.97 'A significant poition Of funding for our education programming comes from individual contributions and community support. Michael Fisher Nancy Gilbert PRESIDENT Gena Goodman-Dav(d Pilz Campbell VICE PRESIDENT Jason Gritzner Bill Anthony Will Groves Carey Kraybill a SECRETARY/TREASURER Clan Kunkel Cris Converse Chuck Newport Shon Rae rc Joanne Richter Ted Wise Rick Wright Anonymous Donor Joanne Richter & Sara Wiener Nelson & Joanne Mathews Rynda Clark Mike & Kellee Taylor The Benevity Community Impact Fund Mike Buettner Ben & Maeve Perle The Robert G. Kirby Fund of Sun Country Tours Sarah Bradley & Bret Campbell Marie Sullre The Oregon Community Foundation Shon Rae Wylie Compton Nick Lelack Gayle Baker Kay Grady Gene Buccola Jason & Mandy Gritzner Cris Converse Ryan & Melanie Buccola Craig & Laura Horrell Jesse Drake C.E. Francis Living Trust Brian & Karen Meece Bonneville Environmental Foundation, Children's Forest of Loren Smith High Plateau LLC Ade & Gladys Pilz Central Oregon, Deschutes County, Deschutes River Conser- Central Oregon Irrigation District Mike Lattig Bruce Ronning vancy, First Interstate Bank, Oregon Watershed Enhancement City of Bend Ron & Sandra Linder Steven Shropshire Board, Felton Round Butte Fund, Portland General Electric, Rick & Chris Wright Paula Surwall Reser Family Foundation, Roundhouse Foundation, Tides Chuck & Debbie Newport Laurence Weinberg Foundation Chris & Carey Kraybill Natasha Bellis & David Pilz Bend Park and Recreation District Eric & Kolleen Miller Alan Holzman 900 Wall, AqUaglide, Ashland Hills Hotel & Suites, Atticus Tumalo Creek Kayak & Canoe Jack & Jan McGowan Tarm Macleod Hotel, Bend Elks, Bend Pet Express, Bendistillery, Branch Whole Foods Market Julie Amberg & Mathias Perle Sara Wyland & Barrel Designs, Bronwen Jewelry, Camp Sherman Store, Nancy Gilbert & John Stephenson Scott & Michelle Davis Jill Bazemore Central Oregon Locavore, Clearwater Gallery, El Sancho, Elk Bill & Tracey Anthony Michael Fisher Lisa Cena & An Halpern Lake Resort, Groove Yoga, Hayden Homes, Hood River Hotel, Rich & Janet Meganck Nicholas & Monica Allen Greg & Karen Davidge Jinsei Spa, Jordan Ramis PC, Mint Jewelry Co, Old Mill District, E.H. and M.E. Bowerman Advised Fund Greg & Janice Druian Beth Stewart Oregon Shakespeare Festival, Patagonia, Peter Hall ClearPine, Hoyt's Hardware & Building Supply Michelle Alvarado Genevieve Hubert Pine Mountain Sports, REI, Riff Cold Brew, Ruffwear, Seventh Cristy Lanfri Christine Ransom Lori Murphy Mountain Resort, Sunriver Brewing, Tetherow, The Fly Fisher's The Zoe Fund of The Oregon Kristi HaMich Network for Good Place, Three Creeks Brewing, Three Sisters Irrigation District, Community Foundation Ken Bierly Kris & Wendy Knight Tumalo Creek Kayak & Canoe, U.S. Forest Service, Walloo Films, Donors listed are from calendar year 2020 tip to the Reynolds McNair Maxwell Sabrina Lint Wanderlust Tours point this annual report was published in late 2020. m r' C rr".�kax.v i' ' 1 . y � Artw t} x f y hF G , jW! ,yq 'w"�Av��,� r �+Ion ki jAT a5✓ Z b�i7 Y 24 A`� F f t >. r f j _t mmu 5. Jo 4 nst t Al dal z .�C °' YA. f y W'��,�t'�` i x }� Y y" M Y� �, i°g� � z �� solid' -Awl NOW, .' MAW,6 ,� 7, i } u�i,�i �dtltlkK� h Rs��1 � • 'ti !'✓r � 1-.r h, 0 --h W :3 g: 67 < 2� C) 0 (C) 0 o- 0 --I o w c 0) 0 0 (D (D (D r-4. 0 1-4 (D 3 (C) ® n cn (D U) 0 W C: ctl 3 D- Z) 0- CD c 0 0- 0 C: 3 0 ® w c U) CD 0 Ci 0 wU. w (D U) U) D- CD0 :3 w (n cr -0 -0 0- 2- 3 w 0 -1 0 0 W cy- Co 0 0 w 6- C) 14. C: D 0 0 3 CD o 3 0 ® U) < r- 0 < 0 0. 0- 3 (D (D (D 0 10 (n (D DC (1) 0 Q CD ) cn c cr cr U Q) ) :3 a 0 0 0 (C) 3 G) -11 w C) (D (D 0. (D 0 U) (D 0 (D ul C) 0 0 --1 N =t 0 co QO (-) 0 :3 Q- 0- (D D 0 (D I CD (a 0 :3 -0 0 m 0 0- (D 0 0 0 -a (D w 0 Z) zr (D (D 0 (D U) 0 U) o Co --A® c --I- ZY CD D_ 0 0 (D U) 0 U) o (D (D C)7 (D f 2 � C: > --I m ;o m sv 0 T c z m 0 m 0 m m m 0 0 0 a 0 E m m 6mod 0) 6W (D a) =r 0 < (D 0 = (A M = W n > (D - 0 C) G) G) m= — cp 0 m< 0 < o (D Ln Ln 3 (D CL 0 rD rD m m 0 --h rD rD rD rD rD n r+ 0 rD rD 0 , —1 V) (D w :3 0 0 3 =3 :3 0) 0 r- m -t5 m 0 C 0 r) -0 — O'q (D -a rD =3 0 =; 0- C rD Lei (D (D =3 :3 O'Q O-Q — + (D (.n C) C) -n oq (D a) (In C) 0 " r.+ =r 0 rD 3 0 m m 0 rD w m rD rD -0 m -, rD CL 0 Ln 0 (D CL Ln r . + rak r•r+ =) OQ z 0 rD - 0 O-Q 0 * rD rD aj 0 W O'Q 0 —1 —1 rD 3 LA ;;o < rp rD ca- 0 M rp 0 M rD rD O En ;u Ln m3 n 00 0 0 m rD m 0-+ 3 rD 3 rD C 0- rD > C2- =) rD 3 Ln rD aq w 0 '< 3 rD ul rD rD rD --% rD 0 0 rD m rD 3 m (A rD 0 :3 aq 3 mrD CL rD rD 0 rD M -Is (D 'a 0 (n -0 M 0 M 0 0 n 0 3 CD 0 Dr-"- 3 * rij CD ST (n M 3 Zy a) zi 0 0 3 W a- w M ""' FD -6 0 0- 0 M (1) :T con cy- M. 0 0 cn M 0 U 0 61), (D 3 3 0 0 M 0 M 0 M (n M 2- 0Cp --1 0 0 Cep w 0 < M 0 0 0 M 9 0 0 CD 0 (D (D (D :3 U) D 6-A (D (D 0 (D 2. (D (D 0 m 0 � w (D (D 0 co o o o �o m a m c 41 O o -ti N Metollu_s Rivo�. H � o � Ti�P �Pf. Glo 00 o ch�� o mv� t; 1 i 0 0 a 0 0 0 < > C: 3 ;;: (D: a 0 (D (D 0 (n 0 tV (D U) M n (a CD _0 w (n cn 0 w 3 -a cn ooa.D u C: 14. o (n (n (n E" o- (D 0 ® 0 10. C: 2. cn 0 66/ (D m a) M (D 0 3 -a cn 0 =3 (n 0 (D cn (D cn 14- 0 -1 w = 0 (D CD CD C) FD U) in c a) w -n 0 M 0- 0- (D U) (n U) _0 F 0 < rW-I- 0(D --4, (D (D a (n (D w = N. U) (D 0 (D R 0 (D 0 0 0 --j oa(D o (D (D a- 0 0 w (D " 0 :3 (n 0 i0 C)- = -0 a) 0 m U) CL =3 (a D (n (n w (n 0 (D 3 0 w 0 0 0 I so n Lo 9 u x u AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of February 22, 2021 DATE: February 17, 2021 FROM: Lee Randall, Facilities, 541-617-4711 TITLE OF AGENDA ITEM: Storm Water Management and Underground Injection Controls RECOMMENDATION & ACTION REQUESTED: Presentation is informational only at this time BACKGROUND AND POLICY IMPLICATIONS: Deschutes County manages storm water runoff at County facilities and Right -of -Way under a 10-year permit issued by the Oregon Department of Environmental Quality in October of 2016.. Recently, the Facilities Department has undertaken a project to update the inventory of storm water control structures operated by the County for capital project planning purposes. As required by the permit, certain upgrades to non -compliant structures are required to be completed. This presentation is intended to provide background on the permit program and future projects to address permit requirements. There is no action requested of the Board at this time. FISCAL IMPLICATIONS: There are currently no fiscal implications, however, this presentation will provide information regarding possible future costs of upgrading and retrofitting storm water control structures. ATTENDANCE: Lee Randall, Facilities Director. Abigail Black, Facilities Department Intern To: Board of County Commissioners From: Lee Randall, Facilities Director Date: February 17, 2021 (for February 22, 2021 BOCC meeting) Re: Storm Water Management and Underground Injection Controls In October of 2016, the Oregon Department of Environmental Quality (DEQ) issued a 10-year permit to Deschutes County for Water Pollution Control Facilities (WPCF). This allows for the continued operation of existing Underground Injection Controls (UIC) to manage storm water runoff. The WPCF-UIC permit program is part of the implementation of the federal Safe Drinking Water Act by DEQ and applies to all entities that utilize UIC to manage storm water runoff. Deschutes County operates (84) UIC including dry wells and drill holes, and an additional (81) storm water structures such as catch basins. The WPCF permit includes requirements for maintenance and upgrades of these structures. Maintenance activities include parking lot sweeping, regular inspection and cleaning of structures, and annual testing of storm water for contaminants. This work is budgeted each year in the operating budgets of the Road Department, Fair and Expo, Facilities Department, and the Sheriffs Office for the sites or Right -of -Way that each maintains. Upgrades generally include the replacement or retrofit of storm water structures to ensure that they have sediment and oil -water separation controls that meet the compliance requirements of the permit. Over the last several years, this work has been identified in the Facilities Department capital projects binder presented annually to the Budget Committee. The upgrades or retrofits to existing non -compliant structures are to be completed by the expiration of the permit, October 31, 2026. To date, upgrades have been performed as part of larger parking lot projects. Currently, the Facilities Department has undertaken a project to update the inventory of all County storm water structures covered by the permit. The project will determine appropriate retrofits and upgrades to bring them into compliance and will include a five-year plan for the funding and completion of the upgrades. This funding plan will be a refined, detailed version of the cost projections outlined in the capital projects binder presented to the Budget Committee in previous years. 4 MA/ Kearney Avenue, Bend, Oregon 97703 1 P.O. Box 6005, Bend, OR 97708-6005 `Q1 (541)330-4686 @ wvn/w.deschutes.org Page 1 of 2 While the cost of maintaining existing structures is addressed in the operating budgets of County departments and the Sheriff's Office, the cost of upgrades and retrofits will likely be addressed through a request for a transfer of funds from the General County Reserve Fund 060 to the General County Projects Fund 070. There is no action requested of the Board at this time. Though the project is still underway, this memo and the presentation to the Board on February 22, 2021, seek to provide general background on the County's storm water program along with additional detail on the information compiled to date. Page 2 of 2 r+ S r CU �7 I 0 �w r m E 0 E !: 1„ f;. C') k"D ul, ul rD rill, 0 CD COO ("i (1), (D 13 (D rD CD X 0 c J �7 � i v A r 2 e IE �; : � ¥: � � � � � °\+ � � •� � � � _� � , � `\�� + °\ , \.� ®° . � � � � � � � � � � \ � � : � �� } . � �,�,� w »: y �, ` � � � � �� .:� � � � .\ � � : � v� . ¥: � : , � � ¥ � \ *° � \ \: �\ � : : � � � 4-J 4-J r > 0 CL 0 mom +j c E > 0 0 W r r >1 0 IA 01 el, GJ » . � T � — � � ¥> 1 r¥ � 4 : � ° , � \ � ~ ` y 0 ¥: \2 ¥< u u IA IA E � :. :, � \ \ / + a A 1= � y v e A "T1 0 a A 0 K '*J 8 �v(ES CO o Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - Fax (541) 385-3202 - https://www.deschutes.org/ AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of February 22, 2021 DATE: February 17, 2021 FROM: Greg Munn, Finance, 541-388-6559 TITLE OF AGENDA ITEM: Deschutes County Treasurer and Finance Report for January 2021 DATE: February 17, 2021 TO: Board of County Commissioners FROM: Greg Munn, Treasurer and Chief Financial Officer SUBJECT: Treasury and Finance Report —January 2021 Following is the unaudited monthly finance report for fiscal year to date January 31, 2021. Treasury and Investments • The portfolio balance at the end of January was $247M, a decrease of $5 million from last month and an increase of $13 million from last year. • Net investment income for the month is $187,086, approximately $15,000 less than last month and $205,000 less than last January. YTD earnings are $1.5 million (43%) less than last year's amount. • All portfolio category balances are within policy limits except callables at 25.1% on a policy limit of 25% which will be managed back under the limit. • The LGIP interest rate remains at 0.75%. No change during the month but expect it to decline in the future. • Average portfolio yield is 0.96% down from 1.01% last month. • The portfolio's weighted average time to maturity is at 1.93 years (vs 1.67 last month) as we are buying more investments with maturities in the 3-4 year maturity range. Portfolio Breakdown: Par Value by Investment Type Municipal Debt $ 36,115,000 14.6% Corporate Notes 52,953,000 21.5% Time Certificates - 0.0% U. S. Treasuries 15,000,000 6.1%, Federal Agencies 81,590,000 33.1% LGIP 50,984,846 20.7% First Interstate Bank 10,044,813 4.1% Total Investments $ 246,687,660 100.0% Total Portfolio: By Investment Types First Interstate Bank Municipal Debt 14.6 % 41% LGIP 20.7%,,s ' r i r'srl�Fl � I � � Corporate Notes i�� 21.5% Tme Certificates Federal oo % Agencies U. S. Treasuries 33.1 % 6.1 Portfolio by Broker $120 $110.8 o $100 $80 $60 $40 $18.6 $19.8 $24.1 $20 $3.5 $8.9 $_ DA Moreton Robert W Great Piper Castle Davidson Capital Baird & Pacific Sandler Oak Markets Co Securities Investment Income Jan-21 Y-T-D Total Investment Income 192,086 1,556,842 Less Fee: $5,000 per month (5,000) 35,000 Investment Income - Net 187,086 1,521,842 Prior Year Comparison Jan-20 392,195 2,648,530 Category Maximums: Yield Percentages U.S. Treasuries 100% LGIP ($51,177,000) 100% Federal Agencies 100% Banker's Acceptances 25% Time Certificates 50%u Municipal Debt 25% Co orate Debt 25% _ Current Month FIB/ LGIP 0.75% Investments 1.48% Average 0.96% Prior Month 0.76% 1.53% 1.01% Benchmarks 24 Month Trees. LGIP Rate 36 Month Treasury 0.11% 0.75% 0.17% —Weighted Ave Maturity Max 3.64 Years 1.93 Term Minimum Actual 0 to 30 Days 10%, Under 1 Year 25% Under 5 Years 100% 28.1% 44.5% 100.0% Other Policy Actual Corp Issuer 5% 2.7% Callable 25% 25.1% Credit W/A AA2 AA1 Investment Activity Purchases in Month $ [SaileslRedemptions 18,223,000 in Month $ 9,000,000 4.00% 3.50% 3.00% 2.50% 2.00% 1.50% 1.00% 0.50% 0.00% 300,000,000 250, 000,000 200, 000,000 150,000,000 100,000,000 50,000,000 24 Month Historic Investment Returns Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May.lune July Aug Sept Oct Nov Dec Jan -County Rete 2Year Treasury Rate Corporate Bond Rate -- LGIP Rete Three Year Portfolio Balance M m w w Co w w w M w m m m m M m m m M m M m 0 0 0 C. 0 0 0 0 0 0 0 0 c-{ 17, N N 71 1-1 IV r 1- 1- IV 1- 1V N N N N 1V N N N N N N N t6 R f0 O O v U O N v tti iz N O N U O N t6 v N CL N -5 N U O N o z o a ,. a o Z o 20,000,000 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 Five Year Maturity Distribution ■ As of 09.30.2( Deschutes County Investments Purahases made In Jan 2020 Pontfelie Mang-rd Purahases made In Jan 2021 PorHolle Details - Investments January 31, 2021 Purchase Maturity Days To Ratings Coupon Par Market Book Inv; - Inv Tt.- CUSIP Saoudty Broke Data `' ....Data .t Moturl - Mood; S&P/PI " Rah - YTM 3 " Value Value - Value 10725 MUN 73209MAC1 POMONA CALIF REDEV AGY Pi 11/22/2019 2/1/2021 0 A+ 3.406 1.800 1,300,000 1,300,000 1,300,000 10722 FAC 880591EL2 Tennessee Valley Authority CASTLE 11/5/2019 2/15/2021 14 All AA- 3.875 1.650 2,000,000 2,002,900 2,001,704 10740 TRC 912833LC2 U.S. Treasury CASTLE 12/13/2019 2/15/2021 14 All AA+ - 1.724 2,000,000 1,999,954 1,998,719 10739 TRC 912833LC2 U.S. Treasury CASTLE 12/11/2019 2/15/2021 14 Aaa AA. - 1.724 3,000,000 2,999,931 2,998,078 10687 VR2 89235TEV3 Toyota Mir Cred - Corp N CASTLE 1/9/2019 4/13/2021 71 At A+ 0504 2.218 2,000,000 2,001,161 1,998,939 10702 VR2 06051GFV6 Bank of America Corp CASTLE 5/31/2019 4/19/2021 77 A2 A- lmfi 3.170 1:050,000 1,053,176 1,052,456 10706 MUN 801577NR4 SANTA CLARA CNTY CALIF FING ,CASTLE 7/2/2019 5/1/2021 89 AA+ 2.050 2.263 1,095,000 1,099,106 1,094,956 10700 MCI 05051GEHB Bank of America Corp CASTLE 5/9/2019 5/13/2021 101 A2 A- 5.000 2.700 1,560,000 1580,869 1,569,829 10757 FAC 09247XAH4 Federal Home Loan Mtg Corp CASTLE 3/25/2020 5/24/2021 112 Aa3 AA- 4.250 2.658 2,000000 2:024,987 2,009,763 10741 TRC 9128286V7 U.S. Treasury CASTLE 12/13/2019 5/31/2021 119 Aaa 2.125 1.702 5,000,000 5,033,205 5,006,777 10692 MCI 695114CMII Pacific Corp CASTLE 2/22/2019 6/15/2021 134 Al A+ 3.850 2,850 2,000,000 2,008,921 2,006,402 10672 MCI 695114CMB Pacific Corp CASTLE 12/6/2018 6/15/2021 134 At A+ 3.850 3.351 830,000 833702 831,466 10667 MCI 695114CM8 Pacific Corp CASTLE 11/29/2018 6/15/2021 134 Al A+ 3.850 3.350 1,170,000 1,175:219 1, 172,068 10708 FAC 3133EKVC7 Federal Farm Credit Bank CASTLE 7/29/2019 7/19/2021 168 Aaa AA+ 1.875 1.875 3:000:000 3:025,518 3.000.000 10721 TRC 9128287F1 U.S. Treasury CASTLE 10/31/2019 7/31/2021 180 As 1.750 1.631 6000,000 5,041,015 5,002,861 10705 MUN 797398DK7 SAN DIEGO CNTY CALIF PENSIOI CASTLE 7/1/2019 8/15/2021 195 Aa2 AAA 5.835 2.000 2,000,000 2'059,180 2,040,252 10696 AFD 88059E4M3 Tennessee Valley Authority CASTLE 4/18/2019 9/15/2021 2265 Aaa AA+ 2.373 2.536 1,020,000 1,019,040 1:004,803 1DB48 MCI 45905UC36 International Bonds for Recons CASTLE 7/16/2018 9/28/2021 239 Aaa AAA 2,000 2.967 2,000:000 2:023:958 1:987.944 10731 MCI 94988J5TO Wells Fargo Corporate Note CASTLE 12/5/2019 10/22/2021 263 Aa2 A+ 3.625 t.950 2,000,000 2,043,210 2,023,725 10724 FAC 3130AFUYO Federal Home Loan Bank CASTLE 11/8/2019 11/19/2021 291 Aaa AA+ 1.625 1.711 3,000,000 3'036,490 2,997,979 10744 FAC 3130AHSR5 Federal Home Loan Bank CASTLE 12/20/2019 12/20/2021 322 Aaa AA, 1.625 1.680 3,000,000 3040,600 2,998,565 10732 MCI 46625HJD3 JPMorgan Chase - Corporate N Pi 12/6/2019 1/24/2022 357 A2 A- 4.500 2.010 2,000,000 2:083,552 2,047,545 10654 MCt 695114CP1 Pacific Corp CASTLE 9/25/2018 2/1/2022 355 Al A+ 2.950 3.320 700,000 714,276 697,561 10730 FAC 3133EKCYO Federal Farm Credit Bank CASTLE 11/29/2019 3/14/2022 406 Aaa AA+ 0.450 0.485 5,000,000 5,018,451 5,006,071 10726 FAG 3133EKCYO Federal Farm Credit Bank CASTLE 11/21/2019 3/14/2022 406 Aaa AA+ 0.450 0.668 5,000,000 5,018,451 5,005,484 10750 MCI 90520EAH4 MUFG Union Bank CASTLE 2/5/2020 4/1/2022 424 A3 A 3.150 1.811 1,000,000 1,030,823 1,015,240 10720 MCI 90520EAH4 MUFG Union Bank CASTLE 10/25/2019 4/1/2022 424 A3 A 3.150 2.038 2,000,000 2,061'646 2,025,190 10759 MCI 037833CP3 Apple Inc CASTLE 3/27/2020 5/11/2022 464 All AA- 0,603 1.777 1,000,000 1,004,378 986,682 10733 MCI 084664BT7 Berkshire Hathaway Inc MORETN 12/6/2019 5/15/2022 468 Aa2 AA 3.000 1,740 2,000,000 2,071709 2,031,658 10652 MUN 686053BQI Oregon School Boards Assoc MORETN 9/14/2018 6/30/2022 514 Aa2 AA 5.480 3.120 925,000 989:306 953,877 �10748 FAC 3133EKJ56 Federal Farm Credit Bank CASTLE': 1/31/2020 8/30/2022 575 Aaa i AA- 0400 0.378- 3,000ODD 3,012,656 3,007,940 10790 MUN 014365DQO ALDERWOOD WA WTR & WSTWI R W B 11/12/2020 12/1/2022 668 Aa2 AA- 1.000 0.500 200,000 202,254 201,818 10727 MCI 06051GEU9 Bank of America Corp CASTLE 11/25/2019 1/11/2023 79 A2 A- 3.300 2.120 2,000,000 2, 115,154 2,044,151 10813 MC 740189AGO Precision Castparts Corp CASTLE 12/17/2020 1/15/2023 713 A2 AA- 2.600 0.555 2,772,000 2,875,781 2,876,692 10760 MUN 736746XU7 PORTLAND OR URBAN RENEWAL PS 7/14/2020 6/15/2023 864 All 4.023 2.895 1,000,000 I'D13,370 1,025,457 10709 MUN 29270CNU5 Bonneville Power Atlministratio CASTLE 7/30/2019 7/1/2023 880 Aa2 AA- 5.803 2.125 1.000,000 1,128,670 1,084,842 10713 MCI 361582ADI Berkshire Hathaway Inc CASTLE 9/9/2019 7/15/2023 894 Aa3 AA 7.350 2.031 500,000 584,248 562,505 10769 FAC 3137EAEV7 Federal Home Loan Mtg Corp CASTLE 8/21/2020 8/24/2023 934 All AA- 0.250 0.284 5,000,000 S,OI1,227 4,995,853 10768 MUN 67232TBM6 OAKLAND CA REDEV SUCCESSO PS 8/21/2020 9/1/2023 942 AA- 3.125 0.602 2,600,000 2,656,175 2,661,257 10780 MUN 476453GRO JEROME IDAHO SCHOOL DISTRII.PS 10/13/2020 9/15/2023 956 All 5.000 0.479 200,000 224,054 223,516 10819 FAC 3133EMLEO Federal Farm Credit Bank PS 12/30/2020 9/22/2023 963 All AA + 0.190 0.190 2,000,000 2,000,079 2,000,000 10794 FAC 3137EAEZ8 Federal Home Loan Mtg Corp CASTLE 11/5/2020 11/6/2023 1008 AA+ 0.250 0.280 5,000,000 5,004,853 4:995:858 10802 MCI 459058JM6 International Bond. for Regions CASTLE 11/24/2020 11/24/2023 1026 Aaa AAA 0.250 0.320 2,000,000 2:000,911 1,995, 967 10789 MUN 014365DR8 ALDERWOOD WA WTR & WSTW7 R W B 11/12/2020 12/1/2023 1033 Aa2 AA+ 1.000 0.550 270,000 274,358 273,405 10923 MCI 06051GFBO Bank of America Corp CASTLE ::= 1/12/2021 1/22/2024 1085 A2 A- 4.125 0,522 2,000,000 22 08,174 2,212,431 f 10795 FAC 3134GWKD7 Federal Home Loan Mtg Corp DA DAV 11/9/2020 2/12/2024 1106 Aaa 0.430 0.430 1,205,000 1:205:011 1205 000 10829 MUN 68607VZ73 Oregon State Lottery PS 1/26/2021 4/1/2024 1155 Aa2 is AAA 2:505 0.390': 2,350,000 2,505,077 2,506,248 10761 FAC 3134GV6P8 Federal Home Loan Mtg Corp CASTLE 7/30/2020 4/15/2024 1169 Aaa 0.500 0.500 2,465,000 2,465,156 2,465,000 10807 MUN 179198JF4 CLACKAMAS SCHOOL DISTRICT DA DAV 12/3/2020 6/15/2024 1230 All 0.830 0.480 300,000 305,490 303,505 10777 MUN 179093KQ1 CLACKAMAS SCHOOL DISTRICT PS JO/1/2020 .11512.24 1230 As 0.613 0.613 500,000 501,985 500, 000 10815 MUN 625517MG9 MULTNOMAH COUNTY OR SCHO,R W B 12/30/2020 6/15/2024 1230 All AA+ 2.000 0.405 2,750,000 2,903,368 2,897,189 10809 MUN 736688MD1 Portland Community College PS 12/17/2020 611512.24 1230 Aa1 0.572 0.572 1,000,000 1,002,600 1,000,000 10776 MUN 568571CZ4 SILVER FALLS SO PS 9/17/2020 6/15/2024 1230 Aa1 0.550 0.550 1,900,000 1,906,726 1,900,000 10779 MUN 906429EE1 UNION CTY OR SCHOOL DISTRIC PS 10/8/2020 6/15/2024 1230 Aa1 0.675 0.675 490,000 492:960 490,000 10785 MUN 939307KV5 Washington County SO Municipal PS 10/28/2020 6/15/2024 1230 Aa1 0.590 0.584 1,500:000 1,507,320 1,500:000 10771 MUN 68583RCT7 OR ST COMMUNITY COLLEGE DI R W B 8/27/2020 6/30/2024 1245 Ali AA+ 5.650 0.600 90,000 105,193 105345 10782 MUN 584288ER1 MEDFORD OR REVENUE R W B 10/14/2020 7/15/2024 1260 AA 2.000 0.650 815,OOD 855,864 852:493 10828 FAC 3133EMNK4 Federal Farm Credit Bank DA DAV' i 1/22/2021 7/22/2024 I267 Aaa ; AA+ 0.310 0310 2,000 000 1,998,945 :.2,000.000 : 10811 MUN 68608USW7 Oregon State Lottery R W B 12/17/2020 8/1/2024 1277 Aa1 AA, 2.677 0.939 155,000 798,307 800,055 10812 MUN 68608USi09 Oregon State Lottery R W B 12/17/2020 8/1/2024 1277 Aa1 AA, 2.677 0.939 500,000 528, 555 529,838 10805 MUN 68609TZR2 Oregon State Lottery R W B 12/1/2020 811 t2024 1277 All AA+ 0.638 0.415 505,000 510101 608,909 10784 MUN 732098PE2 POMONA CALI UNI SCH DIST TAX PS 10/20/2020 8/1/2024 1277 Aa3 0.770 0.800 1,200,000 1,211,748 1,207,043 10786 MUN 835559GR9 SONOMA CCD PS 1 012 1,2020 8/1/2024 1277 Aa2 AA 2.061 0.600 1,200,000 1,258,152 1,260,569 10816 MCI 30231GBC5 XTO Energy Inc GPAC 12/21/2020 8/16/2024 1292 All AA 2.019 0.543 2,000,000 2,099,324 2,103,357 10810 MUN 73474TA136 MORROW PORT TRANS FAC R W B 12/14/2020 9/1/2024 1308 Aa2 3.221 0.420 1,750,000 1.924.895 1,924,082 10775 FAC 3134GWF84 Federal Home Loan Mfg Corp CASTLE 9/9/2020 9/9/2024 1316 All 0.480 0.480 1,000:000 1,000,018 1,000,000 10778 MUN 4511527CO IOAHO ST BOND BANK AUTH REV PS 10/8/2020 9/15/2024 1322 All 5.000 &610 1,000,000 1,181,940 1,156,876 10781 MUN 476453GSB JEROME IDAHO SCHOOL DISTRI(PS 10/13/2020 9/15/2024 1322 All 5.000 0.725 220,000 254,938 253,626 10808 MUN 13034AL57 CALIFORNIA INFRASTRUCTURE SGPAC 12/17/2020 10/1/2024 1338 AAA 0.645 0.684 1,000,000 1,007:230 1,000,000 10783 FAC 3133EMCNO Fetleral Farm Credit Bank CASTLE 10/1St 020 10/15/2024 1352 Aaa AA+ 0.400 0.440 2,000,000 2,000,000 1,997,052 10791 FAC 3134GW3W4 Federal Home Loan Mtg Corp CASTLE 10/30/2020 10/28/2024 1355 All 0.410 O 416 2,000,000 2,006,367 1.999 532 10823 M01 822582CC4 ROYAL DUTCH SHELL PLC CASTLE:. ; 1/7/2021 11/7/2024 1375 Aa2 ': AA- 2.000 0.543'. 1708,000 1790,097 '1,80Q642 10797 MCI 822582CC4 ROYAL DUTCH SHELL PLC GPAC 11/13/2020 ",7/2024 1375 Aa2 AA- 2.000 0.706 3:000,000 3:144,198 3,143 95 10799 FAG 3134GW7F7 Federal Home Loan Mtg Corp CASTLE 11/18/2020 11/18/2024 1386 Aaa 0.375 0.375 2,000,000 2,002,871 2,000:08 '90788 MUN 094365DS6 ALDERWOOD WA WTR & WSTWI R W B 11/12/2020 12/1/2024 1399 Aa2 AA. 1.000 0.650 935,000 952,148 947,347 10814 MCI 931142DV2 WALMART GPAC 12/17/2020 12/15/2024 1413 Aa2 AA 2.650 0.570 2'000,000 2, 157,550 2,159, 001 10820 FAC 3133EMLP5 Federal Farm Credit Bank PS 12/30/2020 12/23/2024 1421 Aaa AA+ 0.320 0.320 2,000,000 1,998,819 2,000,000 10806 MCI 037833DF4 Apple Inc GPAC 12/3/2020 1/13/2025 1442 All AA+ 2.750 0.639 2,000,000 2,160,700 2164,337 10821 FAC 3134GXKK9 Federal Home Loan Mtg Corp R W B < V 15/2021 1/16/2025 1444 All 0350 - 2,000,000 1,994,296 2:000,000 10826 MCI 46625HKC3 JPMorgan Chase -:Corporate N; CASTLEf'. 1/11/2021 1/23/2025 1452 A2 A 3125 0827:. 2000000 2,176,020 ;2,179,414: 10817 MCI 46625HKC3 JPMorgan Chase - Corporate N CASTLE 12/22/2020 1/23/2025 1452 A2 A- 3.125 0.806 2,000,000 2, 176:020 2, 181:108 10762 FAC 3136G4E74 Federal National Mtg Assn CASTLE 7/31/2020 1/29/2025 1458 Aaa 10.570 0.570 1,400,000 1,395,783 1:400,011 10792 FAC 3134GW5Q5 Federal home Loan Mtg Corp CASTLE 10/30/2020 1/29/2025 1458 Aaa 0.450 0 452 2,500000 2494 528 2499,765 10822 MCI 12572QAGO CME.GROUP GPAC i:.. 1/4/2021 3/15/2025 1503 Aa3 AA- 3000 0.649d 2,000:000 2:182,542 2,190,887; 10801 MCI 30231GBH4 XTO Energy Ine GPAC 11/19/2020 3/19/2025 1507 All AA 2.992 0.814 2,000,000 2'170,583 2,176,562 10800 MUN 98459LAAl YALE UNIVERSITY GPAC 11/18/2020 4/15/2025 1534 Aaa AAA 0.873 0.578 2000,000 2028455 2,024,426 10B24 MCI 166764BWO Chevron Corp CASTLE'': 1/7/2021 5/11/2026 1560 Aa2 AA 1.554 0.618. 2,000,000 2:063,898 2,078,9301 10818 MCI 166764BW9 Chevron Corp GPAC 12/28/2020 5/11/2025 1560 Aa2 AA 1.554 0647 1,663,000 1716,131 1,726513 10825 MUN 625506PX2 MULTNOMAH CO -REF TX13L ;: GPAC 1/21/2021 6/1/2025 1581 All AAA I.000 0.500'- 2,165 000 2,218670 "2,211:337" 10798 MUN 938429V61 Washington County SD Municipal PS 11/17/2020 6/15/2025 1595 As 0.912 0.645 350.000 355:649 354.021 10787 MUN 88675ABS4 TIGARD OR WTR SYS REVENUE PS 11/3/2020 8/1 /2025 1642 Aa3 AA 2.000 0.850 350,000 370,335 367,710 10764 FAC 3133EL3H5 Federal Farm Credit Bank MORETN 8/12/2020 8/12/2025 1653 Aaa AA+ 0.570 0.570 3,000,000 2988718 3,000,000 10766 FAC 3134GWND4 Federal Home Loan Mtg Corp CASTLE 8/14/2020 8/12/2025 1653 Aaa 0.600 0.610 2,000:000 1:984:355 1,999,093 '10763 FAC 3133EL3P7 Federal Farm Credit Bank R W B 8/12/2020 8/12/2025 1653 All AA+ 0.530 0.530 3,000,000 2,993,031 3,000,000 10767 FAC 3136G41-84 Federal National Mtg Assn CASTLE 8/18/2020 8/18/2025 1659 All AA+ 0.570 0.590 2,000,000 1,989,349 1,998,199 10774 FAC 3136G4N74 Fetleral National Mtg Assn R W 8 9/3/2020 8/21/2025 1662 Aaa AA+ 0.560 0.560 2,000,000 1,984,828 2,000.000 10772 FAC 3136G4N74 Fetleral National Mtg Assn R W B 8/27/2020 8/21/2025 1662 All AA+ 0.560 0,565 1,000,000 992,414 999, 771 r10765 FAC 3136G4N74 Federal National Mtg Assn MORETN 8/21/2020 8/21/2025 1662 Aaa AA+ 0.560 0.560 3,000,000 2,9797:241 3.000,000 10770 FAC 3136G4X24 Fetleral National Mtg Assn PS 8/28/2020 8/29/2025 1570 Aaa AA 0.600 0.600 1,000,000 999,916 t,000,000 10773 FAC 3136G4X24 Fetleral National Mtg Assn CASTLE 8/28/2020 8/29/2025 1670 Aaa AA+ 0.600 0.600 1,000,000 999,916 t,000:000 10793 FAC 3135GA2NO Federal National Mtg Assn R W B 11/4/2020 11/4/2025 1737 Aaa AA- 0.550 0.550 2,000,000 1996458 2,000,000 10795 FAC 3135GDBG3 Federal National Mtg Assn CASTLE 11/12/2020 11/7/2025 1740 Aaa AA+ 0.500 0.5753 2:000:000 2:003:478 1,993,155 10084 RR2 SYS10084 First Interstate 7/1/2006 - - 1 0.750 0.750 10044813 10,044,813 10,044813 10078 RRP SYS10078 Local Govt Investment Pool 7/1/2006 - - 1 0.750 0.750 50:984:846 50,984,846 50,984:846 246,687,660 250,710,624 260,119,667 PERS Update The Oregon Public Employee's Retirement Fund (OPERF) recently reported good news that the fund earned a return of 7.66% in 2020. This number is important because the OPERF is where Oregon's Public Employee's Retirement System (PERS) investments are held. One of the key assumptions built into the PERS retirement model is an assumed annual earnings rate of 7.2% meaning that, all other things being equal, investment returns below 7.2% will have upward pressure on future rates charged against our payroll budgets and returns above 7.2% will have the opposite effect and have downward pressure on future employer rates and budgets. PERS sets employer rates every two years. We are currently in the middle of that rate period which spans FY 2021 and 2022. While the positive 2020 performance doesn't have a direct impact on rates for the upcoming fiscal year, as they are already set, the returns combined with future 2021 returns of 7.2% or higher will continue to put downward pressure on projected future rates. Tax Department The Tax Department has created a new reporting process to save thousands of dollars in staff time. Working with our tax software provider, Ryan Dunning was able to develop a report that reduced the amount of time required to complete the Department of Revenue's Large Railcar annual report by nearly 40 hours. The old process involved printing and organizing 500 pages of forty individual rail car companies and 500 accounts and entering the data in a spreadsheet that eventually determined the distribution amounts to our taxing districts. The new process, which uses the software to organize and summarize the data, reduces the staff time to generate the information needed from 40 hours to 30 minutes and from 500 to 4 pieces of paper. Budget The soft start of the FY 2022 budget season begins this week with staffing cost projections completed and Munis being opened for departments to begin planning their budget for next year. Budget to Actuals Report General Fund: Revenue YTD in the General Fund is $40.5 million or 108% of budget, an increase of $7.8 million from last year which was at 91% of budget for the same time period. This increase in YTD revenue this year is due to property tax collections, unbudgeted CARES Act reimbursements and Clerk recording fees. Both the increase in property tax collections and Clerk recording fees are driven by low interest rates and refinances. Year to date there are 1,448 (1.3%) more tax accounts than last year and 1,207 more accounts that were paid in full by the November due date. Expenses YTD are $28.8 million and 72% of budget compared to $20.9 million and 56% of budget last year. The increase of $7.9 million this year is largely due to CARES Act expenditures. Cour Fund UJl - _...., Fun:; t.,.. J—, _ _ - Fxr4 rTcoci:. -_ - par_ Morthiy GL P.- 0 $9.7M (Blank) All Major Funds: Monthly Expenditures %of last Vear buduet Mon.hly Revenues.. 906 %of last veat boduet FY20 Projected Ending Woking Capital Approved FTE 110.96 PENN Sla (w On the attached pages you will find the Budget to Actuals Report for the County's major funds with actual revenue and expense data compared to budget through January 31, 2021. Position Control Summary July - June Percent Org Jul Aug Sep Oct Nov Dec Jan Unfilled Assessor Filled 33.26 33.26 33.26 33.26 33.26 33.26 33.26 Unfilled 2.00 2.00 2.00 2.00 2.00 2.00 2.00 5.67% Clerk Filled 8.48 8.48 8.48 8.48 8.48 8.48 9.48 Unfilled 1.00 1.00 1.00 1.00 1.00 1.00 - 9.04% BOPTA Filled 0.52 0.52 0.52 0.52 0.52 0.52 0.52 Unfilled - - - - - - - 0.00% DA Filled 53.10 53.80 52.80 51.80 52.40 51.20 52.20 Unfilled 1.00 0.40 1.40 2.40 1.80 3.00 2.00 3.16% Tax Filled 5.50 5.50 5.50 5.50 5.50 5.50 5.50 Unfilled - - - - - - - 0.00% Veterans' Filled 4.00 4.00 4.00 4.00 4.00 4.00 4.00 Unfilled - - - - - - - 0.00% Property Mngt Filled 2.00 2.00 2.00 2.00 2.00 2.00 2.00 Unfilled - - - - - - - 0.00% Total General Fund Filled 106.86 107.56 106.56 105.56 106.16 104.96 106.96 Unfilled 4.00 3.40 4.40 5.40 4.80 6.00 4.00 4.12% Justice Court Filled 4.60 4.60 4.60 4.60 4.60 4.60 4.60 Unfilled - - - - - - - 0.00% Community Justice Filled 46.90 46.90 45.90 45.90 45.90 45.90 44.90 Unfilled 1.00 1.00 2.00 2.00 2.00 2.00 3.00 3.88% Sheriff Filled 224.75 234.75 237.75 236.75 231.75 231.75 226.75 Unfilled 22.75 15.25 12.25 14.25 19.25 19.25 24.25 7.27% Health Srvcs Filled 304.55 312.25 319.78 323.98 318.21 316.18 310.98 Unfilled 38.25 31.55 24.02 17.82 23.89 31.92 37.12 8.49% CDD Filled 54.00 53.00 54.00 54.00 53.00 56.00 56.00 Unfilled 2.00 3.00 2.00 4.00 5.00 1.00 1.00 4.52% Road Filled 53.00 53.00 53.00 53.00 53.00 53.00 53.00 Unfilled 4.00 3.00 3.00 3.00 3.00 3.00 3.00 5.60% Adult P&P Filled 39.60 39.60 38.60 38.60 39.60 39.60 39.60 Unfilled 2.25 1.25 2.25 2.25 1.25 1.25 1.25 4.09% Solid Waste Filled 22.00 23.00 23.00 23.00 23.00 23.00 23.00 Unfilled 2.00 - - - - - - 1.23% 9-1-1 Filled 54.00 54.00 56.00 57.00 55.00 55.00 53.00 Unfilled 6.00 5.00 3.00 2.00 4.00 4.00 6.00 7.25% Victims Assistance Filled 8.00 8.00 8.00 8.00 8.00 8.00 7.00 Unfilled - - - - - - 1.00 1.79% GIS Dedicated Filled 2.30 2.30 2.30 2.30 2.30 2.30 2.30 Unfilled - - - - - - - 0.00% Fair & Expo Filled 10.91 10.91 10.91 10.91 10.91 10.91 10.91 Unfilled 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.82% Natural Resource Filled 2.00 2.00 2.00 2.00 2.00 2.00 2.00 Unfilled - - - - - - - 0.00% ISF - Facilities Filled 19.60 19.60 20.60 21.60 21.60 21.60 21.60 Unfilled 3.40 2.40 1.40 0.40 0.40 0.40 0.40 5.68% ISF - Admin Filled 7.75 7.75 7.75 7.75 7.75 7.75 7.75 Unfilled - - - - - - - 0.00% ISF - BOCC Filled 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Unfilled - - - - - - - 0.00% ISF - Finance Filled 8.00 8.00 9.00 9.00 9.00 9.00 9.00 Unfilled 1.00 1.00 - - - - - 3.17% ISF - Legal Filled 7.00 7.00 7.00 7.00 7.00 7.00 7.00 Unfilled - - - - - - - 0.00% ISF - HR Filled 8.00 8.00 8.00 8.00 8.00 8.00 8.00 Unfilled - - - - - - - 0.00% ISF - IT Filled 15.70 15.70 15.70 15.70 15.70 15.70 15.70 Unfilled - - - - - - - 0.00% ISF - Risk Filled 2.25 2.25 2.25 2.25 2.25 2.25 2.25 Unfilled - - - - - - - 0.00% Total., Filled 1,004.77 1,023.17 1,035.70 1,039.90 1,027.73 1,027.50 1,015.30 Unfilled 86.74 66.94 54.41 51.21 63.68 68.91 81.11 %Unfilled 7.95% 6.14% 4.99% 4.69% 5.83% 6.29% 7.40% 6.19% vT ES C- Budget to Actuals - Countywide Summary All Departments 58.3% FY21 YTD January 31, 2021 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % 001 - General Fund 35,797,833 37,514,589 105% ; 37,201,525 40,365,803 109% ; 44,668,401 120% ; 030 - Juvenile 856,930 826,150 96% ; 975,090 350,936 36% ; 977,140 100%: 160/170 - TRT 7,732,000 7,616,246 99% 6,916,358 7,415,801 107% ; 9,570,600 138% ; 220 - Justice Court 578,000 561,613 97% ; 489,850 259,003 53% ; 489,587 100%: 255 - Sheriffs Office 41,581,807 43,677,825 105% ; 43,449,298 40,053,517 92% ; 43,737,943 101% ; 274 - Health Services 36,132,298 32,892,266 91% 42,771,289 27,230,239 64% ; ; 45,941,162 107% ; 295 - CDD 8,468,820 8,043,542 95% ; 8,251,726 4,855,994 59% ; 8,601,826 104% ; 325 - Road ; 22,785,827 22,495,570 99% ; 20,681,110 13,541,787 65% 22,659,057 110% ; 355 - Adult P&P 5,775,278 6,570,946 114% ; 5,995,287 4,358,044 73% 6,033,890 101% ; 465 - Road CIP 2,142,893 2,145,706 100% ; 2,467,800 838,026 34% 2,514,668 102% ; 610 - Solid Waste 11,724,869 12,300,751 105% ; 12,077,592 7,466,308 62% ; 12,924,961 107% ; 615 - Fair & Expo 1,561,500 990,522 63% 1,466,050 570,446 39% ; 1,201,480 82% ; 616 - Annual County Fair 1,649,700 1,469,198 89% ; 52,000 84,229 162% ; 84,117 162% ; 617 - Fair & Expo Capital 16,000 21,189 132% ; 14,000 5,785 41% ; 10,400 74% ; Reserve t 618 - RV Park 437,700 445,454 102% ; 436,050 276,017 63% 397,119 91% ; 619 - RV Park Reserve 12,550 3,801 30% ; 1,100 5,109 464% ; 9,000 818% ; 670 - Risk Management 3,495,039 3,930,523 112% ; 3,263,646 2,007,725 62% 3,359,969 103% ; 675 - Health Benefits 22,318,433 22,490,985 101% ; 21,884,538 12,820,305 59% ; 21,991,853 100%: 705 - 911 10,563,350 11,280,682 107% ; 11,064,698 9,469,699 86% 11,366,516 103% ; 999 - Other ; 29,544,540 37,220,505 126% 34,108,295 19,222,983 56% 34,186,844 100% ; TOTAL RESOURCES 243,175,367 252,498,065 104% ; 253,567,302 191,197,757 75% ; 270,726,531 107% ; Fiscal Year 2020 Fiscal Year 2021 REQUIREMENTS Budget Actuals % Budget Actuals % Projection % 001 - General Fund 18,517,987 17,416,654 94% 19,253,406 16,936,669 88% ; 24,781,201 129% ; 030 - Juvenile 7,127,337 6,927,385 97% ; 7,390,349 4,112,915 56% 7,038,356 95% ; 160/170 - TRT 2,274,140 2,260,020 99% 2,419,872 2,240,780 93% ; 3,117,697 129% ; 220 - Justice Court 678,141 667,997 99% 683,508 380,079 56% 675,855 99% ; 255 - Sheriffs Office 44,685,809 44,783,763 100% ; 49,864,982 27,726,011 56% ; 49,220,875 99% ; 274 - Health Services 47,589,309 42,265,238 89% ; 51,861,200 26,778,060 52% ; 50,676,697 98% ; 295 - CDD 7,905,639 7,462,091 94% 8,474,142 4,593,754 54% ; ; 8,112,761 96% ; Q L0 U"A TES`O 2{ Budget to Actuals - Countywide Summary All Departments 58.3% FY21 YTD January 31, 2021 (unaudited) Year Complete 325 - Road 14,573,336 13,094,764 90% 14,513,205 6,627,543 46% 13,986,634 96% ; 355 - Adult P&P 6,669,491 6,428,151 96% 7,081,268 3,624,956 51% 6,704,509 95% ; 465 - Road CIP 13,835,913 5,824,653 42% 20,036,050 3,313,015 17% ; 19,713,269 98% ; 610 - Solid Waste 8,384,039 7,518,563 90% 8,853,213 4,098,406 46% ; 8,816,862 100% ; 615 - Fair & Expo 2,464,787 2,372,624 96% ; 2,070,371 1,083,933 52% 1,954,803 94% ; 616 - Annual County Fair 1,504,700 1,615,288 107% ; 127,000 92,854 73% ; 151,101 119% ; 617 - Fair & Expo Capital 1,362,775 424,931 31% ; 401,940 101,017 25% ; 401,940 100% ; Reserve 618 - RV Park 540,373 503,509 93% 543,902 333,173 61% ; 507,580 93% ; 619 - RV Park Reserve 100,000 8,335 8% 100,000 0% 20,000 20% 670 - Risk Management 4,132,295 2,440,263 59% ; 3,794,344 1,376,403 36% 3,659199 96% ; 675 - Health Benefits 24,115,011 22,953,057 95% 23,620,173 10,980,675 46% ; ; 22,516,653 95% ; 705 - 911 12,250,336 10,722,604 88% 12,576,839 6,465,206 51% ; 12,254,783 97% ; 999 - Other 70,540,907 52,841,578 75% ; 58,399,018 15,377,829 26% ; ; 58,210,887 100% ; TOTAL REQUIREMENTS ; 289,252,325 248,531,468 86% 292,064,782 136,243,279 47% ; 292,521,662 100% ; \)IEs ` Budget to Actuals - Countywide Summary Q 2� All Departments 58 3% FY21 YTD January 31, 2021 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 TRANSFERS Budget Actuals % Budget Actuals % Projection % 001 - General Fund (19,023,310) (18,917,801) 99% (20,308,890) (11,665,968) 57% ; (20,308,890) 100% ; 030 - Juvenile 5,874,465 5,874,465 100% ; 5,957,854 3,475,419 58% ; 5,957,854 100% ; 160/170 - TRT ; (4,433,128) (4,430,732) 100% ; (4,678,036) (2,584,936) 55% ; (4,759,084) 102% , 220 - Justice Court 107,235 62,552 58% 107,235 100% ; 255 - Sheriffs Office 3,119,936 3,120,245 100% ; 3,119,077 1,908,848 61% ; 3,119,077 100% ; 274 - Health Services 6,102,365 6,552,032 107% ; 8,026,313 3,296,511 41% 7,407,962 92% ; 295 - CDD (1,448,081) (1,111,631) 77% (55,480) (43,004) 78% (343,855) 620% ; 325 - Road (11,910,575) (11,910,575) 100% ; (6,683,218) (4,051,082) 61% (6,683,218) 100% ; 355 - Adult P&P 223,189 223,189 100% ; 187,496 109,377 58% ; 187,496 100% ; 465 - Road CIP 12,014,914 11,431,979 95% 7,517,657 2,632,137 35% ; 7,517,657 100% ; 610 - Solid Waste ; (3,296,192) (3,296,192) 100% ; (3,684,280) (1,844,551) 50% ; (3,684,280) 100% ; 615 - Fair & Expo 1,022,863 1,475,467 144% ; 494,967 433,713 88% 754,523 152% ; 616 - Annual County Fair (145,000) 0% ; 75,000 44,000 59% ; 75,000 100% ; 617 - Fair & Expo Capital (13,313) (13,313) 100% ; 253,158 147,674 58% 570,351 225% ; Reserve t 618 - RV Park (307,000) (307,000) 100% ; (436,628) (139,082) 32% ; (117,475) 27% ; 619 - RV Park Reserve 502,000 502,000 100% ; 621,628 310,814 50% 297,475 48% ; 670 - Risk Management (6,918) (6,918) 100% ; (3,500) (2,039) 58% ; ; (3,500) 100% ; 705 - 911 - - - 999 - Other 11,123,785 10,814,785 97% 9,078,924 7,909,617 87% 9,905,672 109% ; TOTAL TRANSFERS (600,000) - 0 (410,723) 0 0% ; Budget to Actuals - Countywide Summary L� OG All Departments 583% FY21 YTD January 31, 2021 (unaudited) Y C lete ENDING FUND BALANCE 001 - General Fund 030 - Juvenile 160/170 - TRT 220 - Justice Court 255 - Sheriffs Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 610 - Solid Waste 615 - Fair & Expo 616 - Annual County Fair 617 - Fair & Expo Capital Reserve ' Fiscal Year 2020 I Fiscal Year 2021 Budget Actuals % Budget Actuals Projection % 9,346,536 13,529,514 145% ; 9,739,629 25,292,679 13,107,823 135% ; 694,058 1,069,720 154% ; 616,595 783,159 966,358 157% ; 3,324,732 3,490,749 105% ; 3,530,844 6,080,835 5,184,568 147% ; 64,859 37,842 58% ; 57,804 (20,681) (41,191) -71% ; 14,732,933 18,832,967 128% ; 15,379,560 33,069,322 16,469,112 107% ; 4,766,157 7,817,166 164% ; 5,714,966 11,565,856 10,489,593 184% ; 1,097,104 1,253,356 114% ; 734,798 1,472,593 1,398,566 190% ; 2,303,905 4,217,071 183% ; 2,180,473 7,080,233 ; 6,206,276 285% ; 1,918,976 3,119,990 163% ; 1,816,329 3,962,454 2,636,866 145% ; 15,938,430 25,512,586 160% ; 13,103,814 25,669,733 15,831,642 121% ; 644,638 2,285,566 355% ; 719,918 3,808,918 2,709,385 376% ; 199,576 (1,199) -1% ; 255,550 (80,973) 1 0% ; (47,461) (12,086) (39,445) 726,169 999% ; 1,008,442 778,612 904,980 90% ; 618 - RV Park 150,327 227,936 E 152% ; 43,512 31,699 I E 1 0% ; 619 - RV Park Reserve 414,550 497,466 120% ; 1,012,728 813,389 783,941 77% ; 670 - Risk Management 5,455,826 8,676,750 159% ; 6,465,802 9,306,032 ; 8,374,020 130% ; 675 - Health Benefits 14,309,716 16,101,833 113% ; 13,588,094 17,941,463 15,577,033 115% ; 705 - 911 6,066,720 9,162,894 151% ; 6,829,277 12,167,387 8,274,627 121% ; 999 - Other 41,618,580 69,175,048 166% ; 50,516,183 80,931,965 ; 55,893,466 111% ; TOTAL FUND BALANCE 124% ; 123,047,623 185,685,964 151% ; 133,314,318 240,642,588 ; 164,727,622 �I E S` Budget to Actuals Report C, General Fund - Fund 001 FY21 YTD January 31, 2021 (unaudited) RESOURCES Property Taxes - Current Property Taxes - Prior Other General Revenues Assessor Clerk BOPTA District Attorney Tax Office Veterans Property Management TOTAL RESOURCES REQUIREMENTS Assessor Clerk BOPTA District Attorney Medical Examiner Tax Office Veterans Property Management Non -Departmental TOTAL REQUIREMENTS 58.3% Year Complete Fiscal Year 2020 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 29,046,840 29,310,769 101% 30,105,307 28,906,118 96% 30,267,217 101% 161,910- A 391,000 976,355 250% i 358,000 393,374 110% 394,300 110% , 36,300, 3,020,400 3,136,644 104% 2,550,871 7,921,422 311% 8,839,537 347% , 6,288,665; B 837,283 942,562 113% 836,713 779,777 93% 836,713 100%! - 1,615,280 2,242,070 139% 2,153,741 1,795,876 83% 3,153,741 146% ! 1,000,000 C 12,220 13,659 112% 12,220 11,702 96% 12,220 100% 383,806 333,772 87% 467,138 212,235 45% 447,138 96% E (20,000)! D 195,390 257,219 132% 419,927 292,150 70% 419,927 100% 175,614 175,614 100%! 175,608 39,733 23% 175,608 100%! E ! 120,000 125,925 105% ! 122,000 13,417 11% 122,000 100%! F 35,797,833 37,514,589 105% ; 37,201,525 40,365,803 109% ; 44,668,401 120% ; 7,466,876: Budget Actuals % Budget Actuals % 4,993,290 4,699,209 94% 5,237,507 2,849,433 54% < 2,049,501 1,640,426 80% 2,051,015 1,132,677 55% 77,950 72,369 93% 79,945 45,515 57% 1 1 7,873,159 7,606,702 f 97% 8,234,075 4,670,466 57% ! 235,542 197,772 84% 236,358 95,065 40% 865,307 860,973 99% 970,608 587,581 61% ! 589,551 i 525,956 t 89% 639,571 320,286 50% ! 306,985 301,829 r 98% 317,533 180,405 57% 1,526,702 1,511,418 99% 1,486,794 7,055,241 475% , 18,517,987 17,416,654 94% 19,253,406 16,936,669 88% ; Projection % $ Variance 4,918,780 94% ' 318,72T G 1,952,652 95% 98,363! H 79,945 100% k 8,248,300 100%! ! (14,225)!I 1 236,358 100% 973,517 100%! (2,909)! J 635,529 99% ! 4,042! K 322,954 102% ! (5,421)! L 7,413,166 499% (5,926,372)� M 24,781,201 129% ; (5,527,795); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 260,000 260,000 100% 260,000 151,664 58% 260,000 100% N Transfers Out (19,283,310) (19,177,801) 99% ! (20,568,890) (11,817,632) 57% (20,568,890) 100% TOTAL TRANSFERS (19,023,310) (18,917,801) 99% (20,308,890) (11,665,968) 57% ; (20,308,890) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 11,090,000 12,349,379 111% 12,100,400 13,529,514 112% , , 13,529,514 112% 1,429,114, Resources over Requirements 17,279,846 20,097,935 17,948,119 23,429,134 19,887,200 1,939,081 Net Transfers - In (Out) E (19,023,310) (18,917,801) ! (20,308,890) (11,665,968) 4 E (20,308,890) ! TOTAL FUND BALANCE $ 9,346,536 $ 13,529,514 145% ; $ 9,739,629 $ 25,292,679 260% ; ; $ 13,107,823 135% ; $3,368,194' Footnotes on following page A Current year taxes received primarily in November, February and May; actual 20-21 TAV is 5.40% compared to FY19-20 vs. 5.00% budgeted B PILT payment of $500,000 received in July 2020; interest projection based on current investment rate and anticipated cash balances; includes CARES Fund reimbursements C Projection based on YTD collections of Recording Fees D A vacancy in a grant funded position will reduce State Grant funds by $20K; Federal Grants cannot be drawn down until agency completes financial system upgrade which is estimated to be the end of November. E Oregon Dept. of Veteran's Affairs grant reimbursed quarterly F Interfund land -sale management revenue recorded at year-end G Projected Personnel savings based on FY21 average vacancy rate of 5.7% H Projected Personnel savings based on FY21 average vacancy rate of 9.0% 1 Projected Personnel overage based on FY21 spending to date J Projected Personnel overage based on FY21 spending to date K Projected Personnel savings based on FY21 savings to date L Projected Personnel overage based on FY21 spending to date M Budget adjustment for COVID-19 related contracts will be presented to the Board in Q1 of 2021 N Repayment to General Fund from Finance Reserves for ERP Implementation 0AES` 2{ Budget to Actuals Report Juvenile - Fund 030 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance OYA Basic & Diversion 442,601 387,814 88% 472,401 93,424 20% 472,401 100% A ODE Juvenile Crime Prev 1 91,379 82,125 90% 109,000 22,810 21% 109,000 100%, A Inmate/Prisoner Housing 80,000 96,600 121% 90,000 36,450 41% 80,000 89% (10,000)! B Gen Fund -Crime Prevention 20,000 20,000 100%, 89,500 89,500 100%. 89,500 100%, C Leases 86,400 97,061 112% 88,000 45,012 51% 88,000 100% DOC Unif Crime Fee/HB2712 I 35,000 49,339 i 141% = 49,339 12,335 I I 25% I I k 49,339 100% I 1 OJD Court Fac/Sec SB 1065 1 26,000 20,404 I 78% 26,000 7,177 28% 26,000 100%i Interest on Investments 1 31,000 26,491 85% 17,300 9,644 56% 17,400 101% = 10& D Food Subsidy 16,000 13,448 84% 12,000 5,673 47% E 10,000 83% (2,000)! Contract Payments 8,000 k 5,459 68% 81000 1,076 13% 2,000 25% (6,000)! E Miscellaneous 14,050 22,672 161% 7,550 26,057 345% , 30,000 397% 22,4W F Case Supervision Fee 1 6,500 4,736 73% 6,000 1,777 30% 3,500 58% (2,500)! E TOTAL RESOURCES 856,930 826,150 96% 975,090 350,936 36% 977,140 100% ; 2,050; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,797,927 5,650,045 97% 5,970,797 3,383,473 57% 5,770,917 97% 199,880 G Materials and Services 1,329,410 1,277,340 96% 1,387,552 699,555 50% 1,237,552 89% 150,000! H Capital Outlay - - 32,000 29,887 93% 29,887 93% 2,111 TOTAL REQUIREMENTS ; 7,127,337 6,927,385 97% 7,390,349 4,112,915 56% ; 7,038,356 95% ; 351,993: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 5,961,465 5,961,465 100% 6,034,966 3,520,401 58% 6,034,966 100% Transfers Out-Veh Reserve I (87,000) (87,000) 100% (77,112) (44,982) 58% (77,112) 100% TOTAL TRANSFERS 5,874,465 5,874,465 100% ; 5,957,854 3,475,419 58% 5,957,854 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,090,000 1,296,490 119% 1,074,000 1,069,720 100% 1,069,720 100% (4,280)� Resources over Requirements (6,270,407) (6,101,235) (6,415,259) (3,761,979) (6,061,216) 354,043! Net Transfers - In (Out) I 5,874,465 5,874,465 k 5,957,854 3,475,419 11 5,957,854 f 1 k TOTAL FUND BALANCE $ 694,058 $ 1,069,720 154% ; $ 616,595 $ 783,159 127% ; $ 966,358 157% ; $349,763: A Quarterly reimbursement based on actual expenses. Q1 payment has been submitted and approved by the State B Adjusted projection based on YTD revenue. COVID-19 is impacting other Counties use of detention. C On -time annual transfer received D Interest projection based on current investment rate and anticipated cash balances E Adjusted projection based on YTD revenue. Receiving less than budgeted due to COVID-19 impacts F Includes CARES Fund and State COVID related reimbursements G Projected Personnel savings based on FY21 average vacancy rate of 3.9% H Adjusted projection based on YTD expenses. COVID-19 has reduced M&S spending. �I E S Budget to Actuals Report TRT - Fund 160/170 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Room Taxes 7,670,000 7,527,492 98% 6,862,458 7,275,688 106% 9,400,000 137% 2,537,54Z A Interest ! 62,000 88,754 143% 53,900 40,113 74% 70,600 131% < 16,700 B State Miscellaneous ! 100,000 100,000 100,000 C TOTAL RESOURCES 7,732,000 7,616,246 99% 6,916,358 7,415,801 107% ; ; 9,570,600 138% ; 2,654,242: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance COVA 2,064,221 2,050,618 99% 1,838,805 1,826,340 99% 2,536,630 138% : (697,825): D Grants & Contributions 62,000 62,000 100%! 404,000 325,662 81% 404,000 100%, Interfund Contract ! 79,160 79,160 100% 114,481 66,781 58% 114,481 100%! E Interfund Charges 37,309 37,309 100% 35,861 20,919 58% 35,861 100%! Auditing Services 14,500 19,200 132% 11,500 - 0% 11,500 100% Software ! 10,350 - 0% 11,500 0% 11,500 100% Public Notices 1,600 1,694 106% , 1,600 1,078 67% 1,600 100% Office Supplies 3,000 741 25% 1,275 1 0% 1,275 100% Printing 2,000 642 32% 850 0% 850 100% Refunds & Adjustments 8,657 999% < TOTAL REQUIREMENTS 2,274,140 2,260,020 99% ; 2,419,872 2,240,780 93% 3,117,697 129% ; (697,825); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer Out - RV Park (35,000) (35,000) 100%: (20,000) (11,732) 59% (20,000) 100%, Transfer Out - Annual Fair ! (250,000) (250,000) 100%! (75,000) (44,000) 59% (75,000) 100%! Transfer Out - F&E Reserve ! (286,687) (286,687) 100% (253,158) (147,674) 58% (570,351) 225% (317,193)! F Transfer Out - F&E (as needed) (325,744) (323,348) 99% (275,744) (15,019) 5% (39,599) 14% 236,145, G Transfer Out - Health (406,646) (237,209) 58% t (406,646) 100%, H Transfer Out - F&E ! (383,910) (383,910) 100%! (495,701) (290,810) 59% (495,701) 100% Transfer Out - Sheriff ! (3,151,787) (3,151,787) 100% (3,151,787) (1,838,492) 58% (3,151,787) 100% TOTAL TRANSFERS (4,433,128) (4,430,732) 100% ; (4,678,036) (2,584,936) 55% ; (4,759,084) 102% ; (81,048); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,300,000 2,565,255 112% 3,712,394 3,490,749 94% _ 3,490,749 94% (221,645): Resources over Requirements 5,457,860 5,356,226 ? 4,496,486 5,175,022 6,452,903 1,956,417 Net Transfers - In (Out) ! (4,433,128) (4,430,732) d (4,678,036) (2,584,936) t k (4,759,084) ! (81,048) ! TOTAL FUND BALANCE $ 3,324,732 $ 3,490,749 105% ; $ 3,530,844 $ 6,080,835 172% ; $ 5,184,568 147% ; $1,653,724: A YTD 01.31.21 ahead of PY by 15.9%. Projection assumes a 1 % increase over PY for the remainder of the year. B Interest projection based on current investment rate and anticipated cash balances C Includes CARES Fund reimbursements D Payments to COVA based on a percent of TRT collections E Contracted services with the Finance Department for operating TRT program F The balance of the 1% F&E TRT is transferred to F&E reserves G $250K of budgeted transfers are to be transferred from unallocated TRT on an as needed basis H Transfer to Health Services is to fund COVID re -opening positions �I ES Budget to Actuals Report Justice Court - Fund 220 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Court Fines & Fees 575,000 556,877 97% 488,750 258,203 53% 488,750 100% A Interest on Investments F 3,000 1,706 57% 1,100 65 6% 100 9% (1,000): B Miscellaneous F 3,030 - 736 737 737! TOTAL RESOURCES 578,000 561,613 97% 489,850 259,003 53% ; 489,587 100% ; (263); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 516,868 522,054 101% 531,006 301,570 57% 523,353 99% 7,653: C Materials and Services F 161,273 145,944 90% ! 152,502 78,508 51% 152,502 100% < D TOTAL REQUIREMENTS 678,141 667,997 99% ; 683,508 380,079 56% 675,855 99% 7,653, TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund - - 107,235 62,552 58% 107,235 100% E TOTAL TRANSFERS - - 107,235 62,552 58% 107,235 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance F 165,000 144,227 87% I 144,227 37,842 26% I I 37,842 26% t (106,385): I Resources over Requirements I (100,141) (106,384) t (193,658) (121,075) :I (186,268) I 7,390, Net Transfers - In (Out) 4 - - d 107,235 62,552 t k 107,235 t t TOTAL FUND BALANCE $ 64,859 $ 37,842 58% $ 57,804 ($ 20,681) -36% ; ($ 41,191) -71% ; ($98,995); A The FY21 budget reflects lower revenue compared to FY20 because of HB4210. Revenue may be reduced further, but the impact won't be known until late 2020. B Interest projection based on current investment rate and anticipated cash balances C Projected Personnel savings based on FY21 savings to date D One time yearly software maintenance fee of $9,169 paid in July for entire fiscal year E Additional transfers may be needed because of lower Court Fines and Fees revenue 01Es ` . Budget to Actuals Report Sheriff's Office - Fund 255 FY21 YTD January 31, 2021 (unaudited) RESOURCES LED #1 Property Tax Current LED #2 Property Tax Current Sheriffs Office Revenues LED #1 Property Tax Prior LED #2 Property Tax Prior LED #2 Interest LED #1 Interest LED #2 Foreclosed Properties LED #1 Foreclosed Properties TOTAL RESOURCES REQUIREMENTS Sheriffs Services Civil/Special Units Automotive/Communications Detective Patrol Records Adult Jail Court Security Emergency Services Special Services Training Crisis Stabilization Center Other Law Enforcement Non - Departmental TOTAL REQUIREMENTS 58.3% Year Complete Fiscal Year 2020 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 26,293,470 26,496,529 101% 27,476,763 26,138,331 95% 27,569,562 100%, 92,799, A k 10,632,014 10,696,589 101% 11,092,307 10,553,012 95% 11,130,853 100%, 38,546, B t 3,922,323 4,914,406 125% 4,259,128 2,744,215 64% 4,270,428 100% 11,300! C k 312,000 761,642 244% 280,000 329,197 118% ! 368,000 131% 88,000 k 148,000 331,165 224% 120,000 136,236 114% 156,000 130% ! 36,000, k 136,000 160,208 118% 120,000 48,576 40% 79,500 66% (40,500)! C 138,000 287,276 208% ! k 101,100 103,952 103% it 163,600 162% ! t 62,500! C t k - 8,631 - 21,380 41,581,807 43,677,825 105% ; 43,449,298 40,053,517 92% 43,737,943 101% ; 288,645: Budget Actuals % Budget Actuals % 3,105,057 3,092,171 100% 3,864,843 2,134,948 55% t 1,232,158 1,171,260 95% 1,232,618 644,008 52% t 2,858,337 2,915,540 102% ! 3,312,477 1,446,603 44% ! t 2,303,072 2,217,577 96% 2,515,536 1,386,805 55% ! k 10,592,002 11,446,211 108% ! 12,336,227 7,519,409 61% ! k 1,004,600 833,934 83% ! 1,038,130 492,098 47% ! ! 18,379,998 17,929,047 98% ! 19,897,342 10,762,475 54% ! i 556,740 458,541 82% 490,401 284,298 58% k 402,734 603,381 150% ! 543,565 584,158 107% ! ! 1,601,871 1,747,792 109% ! 2,052,586 1,068,829 52% ! i 743,334 916,411 123% < 1,156,993 588,474 51% ! � t � 571,267 84,267 15% - - k 1,330,214 1,261,716 95% ! 1,328,675 812,979 61% ! k 4,425 105,917 999% ! 95,589 927 1% ! 44,685,809 44,783,763 100% ; 49,864,982 27,726,011 56% ; TRANSFERS Budget Actuals % Budget Actuals % Transfer In - TRT 1 3,151,787 3,151,787 100% 3,151,787 1,838,492 58% , Transfer In - General Fund k 240,249 240,249 100% ! 240,290 140,170 58% ! Transfers Out - Debt Service k (272,100) (271,791) 100% ! (273,000) (69,814) 26% ! TOTAL TRANSFERS 3,119,936 3,120,245 100% ; 3,119,077 1,908,848 61% ; Projection % $ Variance 3,801,257 98% 63,58& D 1,129,946 92% � 102,672! i i 3,130,586 95% 181,891! i 2,507,018 100%! 8,518! ! 12,849,487 104% ! (513,260)! 953,671 92% ! 84,459, t t 19,129,952 96% I 767,390! t 486,681 99% 3,720; i 725,246 133% ; r (181,681)� 1,887,587 92% ! 164,999! 1,151,846 100%! 5,147! ! 1,372,009 103% ! (43,334)! 95,589 100%! -! E 49,220,875 99% ; 644,107: Projection % $ Variance i 3,151,787 100%, r i 240,290 100% i f � (273,000) 100% 3,119,077 100% FUND BALANCE Budget Actuals % Budget Actuals % :projection % $ Variance Beginning Fund Balance 14,716,999 16,818,660 114% a 18,676,167 18,832,967 101% 18,832,967 101% 156,800: Resources over Requirements ! (3,104,002) (1,105,938) (6,415,684) 12,327,507 ! ! (5,482,932) ! 932,752, I t I I 4 1 Net Transfers - In (Out) 3,119,936 3,120,245 3,119,077 1,908,848 3,119,077 i I i k F i TOTAL FUND BALANCE $14,732,933 $ 18,832,967 128% ; $15,379,560 $ 33,069,322 215% ; $ 16,469,112 107% ; $1,089,552; A Current year taxes received primarily in November, February and May; actual 20-21 TAV is 5.40% compared to FY19-20 vs. 5.00% budgeted B Current year taxes received primarily in November, February and May; actual 20-21 TAV is 5.31% compared to FY19-20 vs. 5.00% budgeted C Interest projection based on current investment rate and anticipated cash balances D Divisions projected to be less than budget are related to hiring process being impacted by COVID. Divisions projected to be higher than budget are impacted by overtime related to fires as well as delays sending employees to Academy due to COVID. E Budgeted funds includes transfers from Funds 701 and 702 TES ` Budget to Actuals Report Health Services - Fund 274 FY21 YTD January 31, 2021 (unaudited) RESOURCES State Grant OHP Capitation Federal Grants Local Grants OHP Fee for Service State Miscellaneous State - OMAP Environmental Health Fees Other Patient Fees Title 19 Vital Records Divorce Filing Fees State Shared- Family Planning Interest on Investments Interfund Contract- Gen Fund Liquor Revenue CCBHC Grant TOTALRESOURCES 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 14,080,644 11,212,405 80% 14,354,315 8,098,038 56% 16,353,532 114% , 1,999,217, 7,242,430 8,094,701 112% 8,279,406 5,775,907 70% 8,402,211 101% t 122,805 i 3,277,616 2,798,690 85% 4,492,822 1,515,805 34% 4,260,115 95% t (232,707)! t 1,567,331 1,133,942 72% 4,190,263 3,764,265 90% 4,292,370 102% 102,10T t - - 3,265,627 2,220,161 68% 3,805,990 117% ! 540,363! 1,040,153 1,387,132 133% ! 3,006,014 1,946,758 65% k 3,114,184 104% ! 108,170 t 991,900 879,037 89% 1,162,507 647,945 56% 1,017,274 88% (145,233)! t 1,058,206 1,104,825 104% 1,091,652 864,460 79% 1,080,943 99% (10,709)! i 484,712 476,047 98% 965,971 800,075 83% 1,121,968 116% , 155,997 564,750 600,412 106% 672,995 260,046 39% 445,793 66% (227,202) t 4,862,726 4,071,759 84% 350,491 618,116 176% ! 1,059,627 302% 709,13& t 220,000 259,029 118% 237,296 142,863 60% t t 244,865 103% ! 7,569! t 173,030 173,030 100%! 173,030 173,030 100%! 173,030 100% t 120,000 191,912 160% 155,000 89,037 57% 152,635 98% (2,365)! t 171,000 233,116 136% 147,400 106,001 72% 190,125 129% 42,72& 127,000 127,000 100%! 127,000 127,000 100%! 127,000 100% 150,800 162,122 108% , 99,500 80,733 81% 99,500 100% (12,894) 999% 36,132,298 32,892,266 91% ; 42,771,289 27,230,239 64% 45,941,162 107% ; 3,169,873; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 33,186,830 32,041,791 97% 37,588,619 20,430,148 54% 36,553,762 97% 1,034,858; Materials and Services 13,707,479 10,223,447 75% 14,172,924 6,335,091 45% 14,052,115 99% 120,809 Capital Outlay 695,000 - 0% 99,667 12,820 13% 70,820 71% 28,847 Administration Allocation - - (10) - 0% _ - 0% (10) TOTAL REQUIREMENTS ; 47,589,309 42,265,238 89% 51,861,200 26,778,060 52% ; 50,676,697 98% ; 1,184,503; TRANSFERS Budget Actuals % Budget Actuals % Transfers In- General Fund 5,747,090 5,747,090 100%, 5,472,710 3,195,165 58% Transfers In- OHP Mental Health 548,601 998,268 182% ! 2,379,865 - 0% Transfers In - TRT t 406,646 237,209 58% i Transfers Out (193,326) (193,326) 100% (232,908) (135,863) 58% TOTAL TRANSFERS 6,102,365 6,552,032 107% ; 8,026,313 3,296,511 41% ; Projection % $ Variance 5,472,710 100% 1,761,514 74% (618,351): 406,646 100%, (232,908) 100% 7,407,962 92% ; (618,351); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 10,120,803 10,638,105 105% 6,778,564 7,817,166 115% 7,817,166 115% 1,038,602 Resources over Requirements (11,457,011) (9,372,971) (9,089,911) 452,179 (4,735,535) 4,354,376 Net Transfers - In (Out) 3 6,102,365 6,552,032 E 8,026,313 3,296,511 7,407,962 E t (618,351)! i 4 TOTAL FUND BALANCE $ 4,766,157 $ 7,817,166 164% ; $ 5,714,966 $11,565,856 202% ; $ 10,489,593 184% ; $4,774,627: �I ES Budget to Actuals Report Health Services - Admin - Fund 274 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Federal Grants 726,655 565,906 78% 896,971 341,352 38% 779,803 87% (117,167): A Interest on Investments 171,000 233,116 136% < 147,400 106,001 72% 190,125 129% ! 42,725! B Other 9,000 8,718 97% 14,391 4,895 34% 8,392 58% (5,999)! State Miscellaneous - 171,881 - 151,727 203,676 203,676 C CCBHC Grant - - TOTAL RESOURCES 906,655 979,620 108% ; 1,058,762 603,976 57% 1,181,996 112% ; 123,234: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,241,264 4,870,386 93% 5,574,456 2,886,897 52% 5,144,370 92% , 430,08& D Materials and Services 4,971,179 4,690,935 94% 4,983,063 2,884,599 58% 5,083,738 102% ! (100,675)! E Capital Outlay 5,000 - 0% Administration Allocation (9,308,295) (9,306,000) 100% (9,637,453) (2,360,180) 24% (9,633,283) 100%! (4,170)l TOTAL REQUIREMENTS ; 909,148 255,321 28% ; 920,066 3,411,316 371% ; ; 594,825 65% 325,241: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 40,000 39,997 100% Transfers Out (193,326) (193,326) 100% (232,908) (135,863) 58% (232,908) 100% TOTAL TRANSFERS (153,326) (153,329) 100% : (232,908) (135,863) 58% ; :, (232,908) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,660,832 2,748,263 103% 2,772,840 3,322,793 120% 3,322,793 120% 549,953 Resources over Requirements (2,493) 724,299 138,695 (2,807,341) 587,170 448,475! Net Transfers - In (Out) (153,326) (153,329) (232,908) (135,863) (232,908) TOTAL FUND BALANCE $ 2,505,013 $ 3,319,234 133% ; $ 2,678,627 $ 379,590 14% ; $ 3,677,056 137% ; $998,429: A Federal grants are reimbursed on a quarterly basis. B Interest projection based on current investment rate and anticipated cash balances C Includes CARES Fund reimbursements D Projected Personnel savings based on YTD Personnel expenditures E Increased expenditure is related to COVID-19 expenses, including contracts for community testing that are reimbursable through CARES 01ES Budget to Actuals Report L� �G Health Services - Behavioral Health - Fund 274 58.3% FY21 YTD January 31, 2021 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Grant 11,203,914 8,259,750 74% 10,348,047 5,532,109 53% 11,297,601 109% 949,554, A OHP Capitation 7,242,430 8,094,701 112% 8,279,406 5,775,907 70% 8,402,211 101% 122,805: B Federal Grants E 2,168,961 1,823,950 84% 3,298,243 1,112,737 34% 3,173,720 96% (124,523)! OHP Fee for Service E - - 3,265,627 2,220,161 68% 3,805,990 117% 540,363! C Local Grants E 994,331 487,025 49% 1,897,762 1,830,255 96% 2,167,894 114% ! 270,132! State Miscellaneous E 437,100 326,534 75% 1,468,455 662,646 45% 1,331,575 91% ! (136,880)! D Other 395,352 360,920 91% 927,605 782,469 84% i k 1,092,850 118% ! 165,245! E Patient Fees E 443,450 465,851 105% , 522,300 204,572 39% 350,662 67% (171,638)! F Title 19 E 4,862,726 4,071,759 84% 3 350,491 618,116 176% 1,059,627 302% 709,136 G State - OMAP E 131,900 174,354 132% i 210,287 97,904 47% 167,481 80% ! (42,806)! Divorce Filing Fees 173,030 173,030 100%, 173,030 173,030 100% 173,030 100% Interfund Contract- Gen Fund 127,000 127,000 100% 127,000 127,000 100%! 127,000 100% Liquor Revenue 150,800 E 162,122 108% E 99,500 80,733 81% E! 99,500 100% ! E CCBHC Grant - (12,894) 999% - - TOTAL RESOURCES 28,330,994 24,514,102 87% ; 30,967,753 19,217,640 62% ; 33,249,141 107% ; 2,281,389: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 6,978,412 6,963,580 100% 7,427,338 1,810,019 24% 7,424,984 100% 2,354; Personnel Services 20,174,804 19,576,382 97% 23,360,066 12,771,329 55% 22,943,693 98% 416,374, H Materials and Services 6,889,404 3,802,898 55% 5,656,017 1,955,354 35% 5,456,860 96% 199,157 Capital Outlay E 690,000 - 0% 99,667 0% 58,000 58% 41,66T TOTAL REQUIREMENTS ; 34,732,620 30,342,859 87% ; 36,543,088 16,536,701 45% 35,883,537 98% ; 659,551: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- OHP Mental Health 548,601 998,268 182% 2,298,179 - 0% 1,679,828 73% � (618,351)� 1 Transfers In- General Fund E 1,734,107 1,734,100 100% 2,036,117 1,187,725 58% F E 2,036,117 100% Transfers Out 0% - 0% TOTAL TRANSFERS 2,282,708 2,732,368 120% ; 4,334,296 1,187,725 27% ; 3,715,945 86% (618,351); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 6,122,347 6,673,256 109% 3,008,705 3,397,853 113% 3,397,853 113% 389,148, Resources over Requirements ! (6,401,626) (5,828,757) (5,575,335) 2,680,938 E (2,634,396) E 2,940,939, Net Transfers - In (Out) f 2,282,708 2,732,368 k 4,334,296 1,187,725 t! 3,715,945 E (618,351); 4 TOTAL FUND BALANCE $ 2,003,429 $ 3,576,867 179% ; $1,767,666 $ ?,266,516 411°fo ; ; $ 4,479,403 253% ; $2,711,737: A Includes $530K in carryforward State funds from FY20 for expenditure in second year of the biennium, as well as $282K in new State grant funding for culturally -relevant behavioral health services needed for COVID-19, and $325K from the Oregon Criminal Justice Commission grant above budget because of installment payments that will be carried forward into FY22. Reduction of $600K in December as part of participation in CCBHC continuation. OHP Reserves will offset loss of funds. B Includes FY20 withhold payment of $93K C Oregon Health Authority reports OHP membership increase for Deschutes County, which may result in additional services. Projections also include revenue from underpaid services in FY20 from PacificSource that are being corrected in FY21. D Projected reduction in local match for I/DD program due to vacancies. Includes CARES Fund reimbursements. E Decrease of $234,000 from budgeted interfund payment, which was related to a contract that will be paid directly by PacificSource in FY21 instead of by DCHS. F Fewer fees collected from insurance than budgeted, likely due to a decrease in patient private insurance plans and an increase in Oregon Health Plan (OHP) membership. G CCBHC enhanced rate for Title 19 approved through September 2023 H Projected Personnel savings based on YTD Personnel expenditures I Actual amount required for transfer -in will be determined at end of year. Current projection includes transfer to offset loss of funds as noted in Footnote A 1Es z< Budget to Actuals Report L ,C ) Health Services - Public Health - Fund 274 FY21 YTD January 31, 2021 (unaudited) RESOURCES State Grant Local Grants State Miscellaneous Environmental Health Fees State - OMAP Federal Grants Vital Records State Shared- Family Planning Patient Fees Other TOTAL RESOURCES 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 2,876,730 2,952,656 103% , 4,006,268 2,565,929 64% 5,055,930 126% , 1,049,66Z A ! 573,000 646,917 113% 2,292,501 1,934,010 84% 2,124,476 93% (168,025)! ! 603,053 888,717 147% < 1,537,559 1,132,384 74% 1,578,933 103% 41,374, B ! 1,058,206 1,104,825 104% 1,091,652 864,460 79% 1,080,943 99% (10,709)! ! 860,000 704,683 82% 952,220 550,041 58% 849,793 89% (102,427) ! 382,000 408,834 107% 297,609 61,716 21% 306,592 103% ! 8,983! ! 220,000 259,029 118% 237,296 142,863 60% 244,865 103% ! 7,569! 120,000 191,912 160% 155,000 89,037 57% 152,635 98% (2,365)� ! 121,300 134,562 111% < 150,695 55,474 37% 95,132 63% (55,563)! ! 80,360 106,409 132% , 23,975 12,710 53% 20,726 86% (3,249) 6,894,649 7,398,544 107% ; 10,744,775 7,408,623 69% ; 11,510,024 107% ; 765,250: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 2,329,883 2,342,420 101% 2,210,105 550,161 25% 2,208,299 100% 1,806; Personnel Services E 7,770,762 7,595,023 98% 8,654,097 4,771,922 55% F 8,465,699 98% 188,398, C Materials and Services 1,846,896 1,729,614 94% 3,533,844 1,495,139 42% F 3,511,517 99% 22,327! Capital Outlay E - - - 12,820 999% , 12,820 999% (12,820)! TOTAL REQUIREMENTS ; 11,947,541 11,667,057 98% 14,398,046 6,830,042 47% ; 14,198,335 99% 199,711; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 3,972,983 3,972,993 100% 3,436,593 2,007,440 58% 3,436,593 100%, Transfers In - TRT E - - 406,646 237,209 58% 406,646 100% Transfers In- OHP Mental Health 81,686 - 0% 81,686 100% TOTAL TRANSFERS 3,972,983 3,972,993 100% ; 3,924,925 2,244,649 57% ; 3,924,925 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,337,624 1,216,586 91% 997,019 1,096,520 110% 1,096,520 110%: 99,501: Resources over Requirements (5,052,892) (4,268,513) (3,653,271) 578,581 (2,688,310) 964,961, Net Transfers - In (Out) 3,972,983 3,972,993 3,924,925 ! ! 2,244,649 4 ! 3,924,925 4 E TOTAL FUND BALANCE $ 257,715 $ 921,065 357% ; $ 1,268,673 $ 3,919,750 309% ; ; $ 2,333,134 184% ; $1,064,461: A Includes $261,000 in unspent state funds from FY20 for expenditure in second year of the biennium. Additional 3-month funding from OHA anticipated to support contract tracing, investigations and vaccine distribution. B Includes projected CARES Fund reimbursements C Projected Personnel Services based on YTD Personnel expenditures ,31 E S ` Budget to Actuals Report Community Development - Fund 295 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 162,000 156,476 97% 137,450 77,285 56% 132,250 96% (5,200): A Code Enforcement 693,960 664,545 96% 722,028 400,861 56% 725,028 100% ! 3,000! B Building Safety 3,433,780 3,179,771 93% 3,362,450 1,943,877 58% 3,456,450 103% 94,000! B Electrical 809,500 797,458 99% 720,600 486,075 67% 861,400 120% 140,800! B Environmental On -Site 877,400 905,165 103% 867,700 539,264 62% 937,200 108% 69,500: B Current Planning 1,807,176 1,696,355 94% 1,738,304 1,007,707 58% E 1,767,304 102% ! 29,000! B Long Range Planning 685,004 643,772 94% 703,194 400,926 57% 722,194 103% 19,000! B TOTAL RESOURCES 8,468,820 8,043,542 95% ; 8,251,726 4,855,994 59% ; 8,601,826 104% ; 350,100: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 2,492,316 2,527,439 101% 2,818,748 1,589,645 56% 2,772,668 98% 46,080 C Code Enforcement 535,590 458,293 86% 568,320 302,479 53% 531,067 93% 37,253! C Building Safety 1,743,298 1,584,784 91% 1,867,662 995,857 53% 1,786,093 96% 81,569! C Electrical 462,183 452,842 98% 524,979 281,739 54% 502,754 96% 22,225! C Environmental On -Site 616,279 566,975 92% 634,452 365,294 58% 632,827 100% ! 1,625! Current Planning 1,501,588 1,415,434 94% 1,479,294 834,242 56% 1,441,546 97% 37,748! C Long Range Planning 554,385 456,323 82% 580,687 224,499 39% 445,806 77% 134,881! C TOTAL REQUIREMENTS 7,905,639 7,462,091 94% 8,474,142 4,593,754 54% 8,112,761 96% 361,381: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - General Fund 100,000 100,000 100% 100,000 102,082 102% 175,000 175% 75,00& D Transfers In - CDD Electrical - - 93,264 0% - 0% (93,264); E Reserve Transfers Out (85,695) (85,695) 100% , (100,518) (58,622) 58% (100,518) 100% , - Transfers Out - CDD Reserve (1,462,386) (1,125,936) 77% (148,226) (86,465) 58% (418,337) 282% (270,111)' F TOTAL TRANSFERS (1,448,081) (1,111,631) 77% (55,480) (43,004) 78% ; (343,855) 620% ; (288,375); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,982,004 1,783,536 90% 1,012,694 1,253,356 124% _ 1,253,356 124% 240,662; Resources over Requirements 563,181 581,451 (222,416) 262,240 489,065 711,481 Net Transfers - In (Out) ! (1,448,081) (1,111,631) (55,480) (43,004) ` (343,855) (288,375) TOTAL FUND BALANCE $ 1,097,104 $ 1,253,356 114% ; $ 734,798 $ 1,472,593 200% ; $ 1,398,566 190% ; $663,768: A Interest projection based on current investment rate and anticipated cash balances 8 Revenue collection is higher than anticipated C Projection reflects unfilled FTE D Transfer appropriated in the General Fund is $175K E Transfer no longer needed as revenues higher than anticipated F Transfer out projection increased as Building Safety and Electrical revenues are anticipated to be higher than budget ,31 ES Budget to Actuals Report Road - Fund 325 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Motor Vehicle Revenue 17,609,539 16,795,577 95% 14,810,507 9,508,291 64% 16,497,235 111% 1,686,72& A Federal - PILT Payment 1,510,450 2,310,002 153% 1,690,574 2,061,977 122% k 2,061,977 122% 371,403! B Federal Reimbursements ! 181,757 372,623 205% 1,325,874 1,093,866 83% 1,102,975 83% (222,899); C Other Inter -fund Services ! 1,156,581 1,070,000 93% 1,114,070 316,847 28% 1,114,070 100% Forest Receipts 915,000 709,742 78% 723,085 - 0% 723,085 100% Sale of Equip & Material 358,000 465,999 130% r 396,000 306,231 77% 396,000 100% Cities-Bend/Red/Sis/La Pine ! 660,000 421,344 64% 385,000 107,720 28% 560,000 145% 175,000! D Interest on Investments ! 246,000 174,141 71% 114,000 40,023 35% 70,500 62% (43,500): E Mineral Lease Royalties 60,000 ! 54,184 90% 60,000 46,434 77% 60,000 100%! Miscellaneous 57,500 76,388 133% 54,000 45,318 84% 54,000 100% Assessment Payments (P&I) 11,000 19,766 180% 8,000 8,864 111% 13,000 163% 5,000, F State Miscellaneous ! 20,000 25,805 129% - 6,215 6,215 6,215! G TOTAL RESOURCES 22,785,827 22,495,570 99% 20,681,110 13,541,787 65% ; 22,659,057 110% ; 1,977,947: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 6,447,671 6,284,546 97% 6,709,180 3,660,472 55% 6,365,903 95% 343,277, H Materials and Services ! 8,092,165 6,782,513 84% 7,753,525 2,961,066 38% 7,570,725 98% 182,800,1 Capital Outlay 33,500 27,706 83% 50,500 6,006 12% 50,006 99% 494! J TOTAL REQUIREMENTS 14,573,336 13,094,764 90% 14,513,205 6,627,543 46% :. 13,986,634 96% ; 526,571: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out (11,910,575) (11,910,575) 100%: (6,683,218) (4,051,082) 61% (6,683,218) 100% TOTAL TRANSFERS (11,910,575) (11,910,575) 100% ; (6,683,218) (4,051,082) 61% (6,683,218) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 6,001,989 6,726,840 112% 2,695,786 4,217,071 156% , 4,217,071 156% ; 1,521,285: Resources over Requirements 8,212,491 9,400,806 6,167,905 6,914,244 8,672,423 2,504,51& Net Transfers - In (Out) (11,910,575) (11,910,575) (6,683,218) (4,051,082) (6,683,218) TOTAL FUND BALANCE $ 2,303,905 $ 4,217,071 183% ; $ 2,180,473 $ 7,080,233 325% $ 6,206,276 285% ; $4,025,803: A Assumes 11.4% increase over budgeted revenue per mid -year trend B Updated based on most recent information from the State C Actual cost of Cascade Lakes Highway Chip Seal project D Unbudgeted request for road work by City of Redmond E Interest projection based on current investment rate and anticipated cash balances F Updated based on YTD actuals G COVID FMLA reimbursement H Projected Personnel savings based on FY21 average vacancy rate of 5.6% 1 Anticipated savings in travel and fuel due to COVID restrictions j Updated based on actual expenses to date \)TEs { Budget to Actuals Report C� ,.0& Adult P&P - Fund 355 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance DOC Grant in Aid SB 1145 4,353,626 4,621,782 106% 4,621,780 3,466,336 75% 4,621,780 100%, A CJC Justice Reinvestment 712,530 1,014,690 142% 797,504 391,752 49% 797,504 100% DOC Measure 57 236,142 239,005 101% - 239,005 264,005 110% , 264,005 110% , 25,001; B Probation Supervision Fees 160,000 183,688 115% 170,000 101,781 60% 170,000 100%, Interfund- Sheriff 50,000 55,000 110% 50,000 32,083 64% 50,000 100% Gen Fund/Crime Prevention 50,000 50,000 100% 50,000 50,000 100%, 50,000 100% C Interest on Investments 77,500 64,896 84% 37,700 30,600 81% 55,100 146% , 17,400, D State Subsidy 16,298 16,703 102% ! 16,298 - 0% 0% (16,298): E Electronic Monitoring Fee 2,000 20,182 999% 10,000 2,454 25% 5,000 50% (5,000)1 F Probation Work Crew Fees 2,000 1,923 96% 2,000 440 22% 500 25% (1,500)i G Miscellaneous 500 15,412 999% : 1,000 604 60% 1,000 100%! State Miscellaneous 22,986 17,988 19,000 19,000! H DOC-Family Sentence Alt 114,682 223,746 195% Oregon BOPPPS - 40,933 TOTAL RESOURCES 5,775,278 6,570,946 114% ; 5,995,287 4,358,044 73% ; 6,033,890 101% ; 38,603; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 4,809,644 4,753,486 99% 5,157,473 2,830,518 55% 4,980,714 97% 176,759� 1 Materials and Services 1,844,847 1,663,665 90% 1,923,795 794,439 41% E 1,723,795 90% 200,000, J Capital Outlay 15,000 11,000 73% TOTAL REQUIREMENTS ; 6,669,491 6,428,151 96% 7,081,268 3,624,956 51% 6,704,509 95% ; 376,759; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 285,189 285,189 100% 285,189 166,364 58% 285,189 100% Transfer to Vehicle Maint (62,000) (62,000) 100% (97,693) (56,987) 58% (97,693) 100% TOTAL TRANSFERS 223,189 223,189 100% ; 187,496 109,377 58% ; 187,496 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,590,000 2,754,005 106% 2,714,814 3,119,990 115% 3,119,990 115% 405,17& Resources over Requirements (894,213) 142,795 (1,085,981) 733,087 F (670,619) 415,362; Net Transfers - In (Out) 223,189 223,189 187,496 109,377 187,496 TOTAL FUND BALANCE 1 $ 1,918,976 $ 3,119,990 163% ; $ 1,816,329 $ 3,962,454 218% ; $ 2,636,866 145% ; $820,537: A State Dept. of Corrections Grant in Aid received quarterly B Received additional funding from state M57 fund to provide client housing and staff training C One-time annual transfer received D Interest projection based on current investment rate and anticipated cash balances E State Dept of Corrections gave notice that these funds have been eliminated for FY21 F Adjusted projection based on YTD revenue. In FY20 a contractor began providing EM directly; however, payments and garnishments from clients in which the County provided service directly continue to be recorded but it is anticipated that these will taper off. G Adjusted projection based on YTD revenue. Due to COVID-19, no community service crew has operated thus reducing fees. H Includes CARES Fund and State COVID related reimbursements I Projected Personnel savings based on FY21 average vacancy rate of 4.1 % j Adjusted projection based on YTD expenses. COVID-19 has reduced M&S spending. Q ,� TES `°2{ Budget to Actuals Report L, .. G Road CIP - Fund 465 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Miscellaneous 1,944,893 1,668,168 86% 2,258,100 648,618 29% 2,172,468 96% (85,632): A Interest on Investments 198,000 366,198 185% 209,700 189,408 90% 342,200 163% < 132,500 B Interfund Payment 111,340 TOTAL RESOURCES 2,142,893 2,145,706 100% ; 2,467,800 838,026 34% 2,514,668 102% ; 46,868: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 71,748 71,748 100% 158,465 92,438 58% 158,465 100% Capital Outlay 13,764,165 5,752,905 42% 19,877,585 3,220,577 16% 19,554,804 98% 322,781! TOTAL REQUIREMENTS ; 13,835,913 5,824,653 42% 20,036,050 3,313,015 17% ; 19,713,269 98% ; 322,781: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 12,014,914 11,431,979 95% 7,517,657 2,632,137 35% 7,517,657 100% TOTAL TRANSFERS ; 12,014,914 11,431,979 95% ; 7,517,657 2,632,137 35% ; 7,517,657 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 15,616,536 17,759,555 114% 23,154,407 25,512,586 110% 25,512,586 110% , 2,358,179, Resources over Requirements (11,693,020) (3,678,947) (17,568,250) (2,474,990) (17,198,601) 369,64% Net Transfers - In (Out) 12,014,914 t 11,431,979 I 7,517,657 2,632,137 f I E 7,517,657 t t TOTAL FUND BALANCE $15,938,430 $ 25,512,586 160% ; $ 13,103,814 $ 25,669,733 196% ; $ 15,831,642 121% ; $2,727,828: A Updated based on anticipated completion of eligible projects B Interest projection based on current investment rate and anticipated cash balances C Updated based on anticipated completion of projects in FY21 coming in under budget or delayed to FY22 011-S(- Budget to Actuals Report Road CIP (Fund 465) - Capital Outlay Summary by Project 58.3% FY21 YTD January 31, 2021 (unaudited) Year Completed Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance Tumalo Res Rd: OB Riley to Bailey Rd 247,342 - 0% Sisemore Bridge 632,174 181,118 29% - 404,245 583,991 144%1 1 619,732 153% _ (215,487). ARTS Project 180,746 0% (66,618) (66,618) 66,618, Terrebonne Refinement Plan 5,000,000 0% 5,000,000 100%: US 20 at Tumalo 300,000 0% S. Canal - "Six" Corners 900,000 1,008,108 112%1 C Avenue: Hwy 97 to 6th St Impry 300,000 369,705 123%' Paving Ward Road 598,269 715,504 120% S. Canal Helmholtz Way 800,000 852,853 107%- 7,376 7,376 (7,376). Tumalo Road Tumalo Place 769,521 245,995 32% 1,517,345 341,746 23% 1,231,735 81% 285,610' Old Bend Rdm/Tumalo Rd Inter 625,642 344,429 55% 1,350,782 1,129,730 84% 1,208,243 89% E 142,539. Spring River Bridge Parking Imp 12,122 NE Negus and 17TH 1,025,472 109,111 11% = 788,684 133,450 17% 1 797,628 101%- (8,944) Hunnel Rd: Loco Rd to Tumalo Rd 275,000 193,732 70% 794,229 146,188 18% 620,883 78% i 173,346, Cascade Lakes Hwy Bike Facilities 39,856 11,856 30% 1 32,740 32,740 (32,740), Transportation System Plan Update 250,000 253 0% 170,000 28,106 17% - 1 133,510 79% 36,490, Slurry Seal 2020 284,432 US 20 Ward Rd to Hamby 500,000 : 500,000 100% US 97 Bend North Corridor I5,000,000 0% 5,000,000 0% 5,000,000 100% t Gribbling Rd Bridge 60,000 0% 222,000 0% 50,000 23 172,000. Alfalfa Mkt Rd: Powell Butte Hwy = 300,000 919,940 307% Paving Fyrear Rd 300,000 0% 1,564,000 690 E 0% 1,806,970 116% (242,970), Paving of S. Century Dr 2,673 100,000 447,416 447% 447,416 447%1 (347,416), Terrebonne Wastewater Feasibility St. 858 50,000 43,486 87% 50,000 100%- Rickard Rd: Groff Rd to US 20 217 605,300 102,112 17% 439,310 73% 1 1165,990` Paving Powell Butte Hwy 651,000 457 0% 651,000 100% Smith Rock Way Bridge Replace 85,000 0% 85,000 100% Deschutes Mkt Rd/Hamehook Round 150,000 227 0% 75,000 509/6 75,0001 US 97: S. Century Dr to USFS Boundry 70,090 70,090 (70,090). Johnson Rd Curve Warning Signs 100,000 59,710 % - 60 - 59,710 60% 40,290 Speed Feedback Sign Installation 50,000 76,314 115M 76,314 153% (26,314), Guardrail Improvements 1 100,000 0% 1 100,000 83,367 83% 1 83,766 84% 16,234, Bend District Local Roads 500,000 0% 1 500,000 100% City of LaPine Local Roads 500,000 0% 500,000 0% 1 500,000 100% Sidewalk Ramp Improvements 75,000 0% 1 75,000 100% i Signage Improvements 60,144 0% 1 100,000 0% 0% 100,000 TOTAL $ 13,764,165 $5,752,905 42%; $ E 19,877,585 3,220,577 16%i . $ 19,554,805 98%i $ 322,7801 0-�E Budget to Actuals Report Solid Waste - Fund 610 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Franchise Disposal Fees 6,437,500 6,444,136 100%, 6,630,625 3,969,164 60% 6,865,417 104% , 234,792, A Private Disposal Fees 2,419,046 2,556,619 106% 2,491,617 1,702,994 68% 2,723,756 109% , 232,139� A Commercial Disp. Fee 2,252,225 2,429,879 108% ! 2,319,792 1,474,584 64% 2,588,731 112% ! 268,939! Franchise 3% Fees 265,000 297,352 112% 280,000 36,166 13% 280,000 100%! -! B Yard Debris 216,761 290,794 134% 216,761 180,844 83% 300,860 139% 84,099! C Miscellaneous 48,336 191,720 397% 88,096 41,738 47% 74,396 84% (13,700)! D Interest 59,000 49,256 83% 23,700 28,167 119% 50,800 214% ! 27,100 E Special Waste 15,000 28,830 192% 15,000 26,010 173% ! 29,000 193% ! 14,000 F Recyclables 12,000 12,163 101% 12,000 6,641 55% 12,000 100% Leases 1 1 100%! 1 - 0% 1 100% TOTAL RESOURCES 11,724,869 12,300,751 105% ; 12,077,592 7,466,308 62% ; 12,924,961 107% ; 847,369: REQUIREMENTS Budget Actuals I % Budget Actuals % Projection % $ Variance Personnel Services 2,538,776 2,393,257 94% 2,518,594 1,409,343 56% 2,482,243 99% , 36,351, G Materials and Services 4,927,163 4,251,937 86% 5,227,119 2,379,192 46% S 5,227,119 100%! H Capital Outlay 56,000 11,724 21% 162,500 - 0% 162,500 100% Debt Service 862,100 861,644 100%! 945,000 309,871 33% 945,000 100%! I TOTAL REQUIREMENTS 8,384,039 7,518,563 90% 8,853,213 4,098,406 46% ; 8,816,862 100% ; 36,351: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance SW Capital & Equipment (3,296,192) (3,296,192) 100% (3,684,280) (1,844,551) 50% (3,684,280) 100%, ; Reserve TOTAL TRANSFERS (3,296,192) (3,296,192) 100% ; (3,684,280) (1,844,551) 50% (3,684,280) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 600,000 799,570 133% 1,179,819 2,285,566 194% 2,285,566 194% , 1,105,74T J Resources over Requirements 3,340,830 4,782,188 3,224,379 3,367,902 4,108,099 883,720 Net Transfers - In (Out) (3,296,192) (3,296,192) (3,684,280) (1,844,551) (3,684,280) TOTAL FUND BALANCE $ 644,638 $ 2,285,566 355% ; $ 719,918 $ 3,808,918 529% ; $ 2,709,385 376% ; $1,989,467, A Total disposal fee projections reflect management's best estimate of revenues to be collected. Volumes are up 7% when comparing this fiscal YTD to the prior -year-to-date. B Annual fees due April 15, 2021; received the Wilderness Garbage monthly installments C Revenue is seasonal with higher utilization in the summer months. Volumes are up 6% when comparing this fiscal YTD to the prior -year-to-date. D FY20 includes the unbudgeted sale of a loader and 2 trailers, LED light incentives and royalty payments. The $13.7K for the 2 trailers was budgeted in FY21, but sold in late June. E Interest projection based on current investment rate and anticipated cash balances F Revenue source is unpredictable and dependent on special clean-up projects; recent large contaminated soil projects from cleaning up a power substation and routine cleaning of a decant facility G Personnel savings based on FY21 YTD average vacancy rate of 1.23% with factors for the recently filled open position (timing and rate); budget and projection includes a Time Management payout estimate for the Director's retirement. H M&S activities are expected to meet budget with pending services and repairs and delayed invoices I Principal and interest payments due in Nov and May for existing debt; budget includes an interest estimate for funding the Negus Transfer Station J An influx of disposal volume and postponement of costs in FY20, such as the waste characterization study, positively impacted the beginning fund balance. )I ES41 Budget to Actuals Report Fair & Expo - Fund 615 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Events Revenue 687,000 328,219 48% 625,000 269,718 43% 547,000 88% (78,000), A Food & Beverage 568,000 280,874 49% 548,500 66,090 12% 220,000 40% (328,500)! B Rights & Signage 120,000 114,100 95% 125,000 13,000 10% 111,000 89% (14,000)! C Storage 71,000 83,158 117% 75,000 38,161 51% 77,000 103% 2,000, D Horse Stall Rental 62,000 37,386 60% 52,000 665 1% 28,000 54% (24,000)! E Interfund Payment 30,000 143,956 480% , 30,000 180,612 602% , 213,000 710% 183,000, F Camping Fee 18,000 5,600 31% 12,500 0% 3,000 24% t (9,500)! G Miscellaneous ( 3,500 2,236 64% 250 1,879 752% , 1,880 752% 1,630 Interest ( 2,000 (5,006) -250% (2,200) 321 .15% 600 -27% 2,8W H TOTAL RESOURCES 1,561,500 990,522 63% 1,466,050 570,446 39% ; 1,201,480 82% (264,570); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 1,176,169 1,108,608 94% 840,704 582,221 69% 1,002,532 119% (161,828); 1 Personnel Services - F&B 157,430 158,556 101% 165,518 93,713 57% 160,871 97% 4,64T J Materials and Services 795,788 787,884 99% 702,149 306,061 44% - 585,000 83% 117,149, K Materials and Services - F&B 234,600 217,425 93% 257,600 42,968 17% 102,000 40% 155,600! L Debt Service 100,800 100,151 99% 104,400 58,969 56% 104,400 100% TOTAL REQUIREMENTS 2,464,787 2,372,624 96% ; 2,070,371 1,083,933 52% ; 1,954,803 94% 115,568; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Room Tax 383,910 383,910 100% � 250,000 290,810 116% , 495,701 198% � 245,701� M Transfers In - General Fund 200,000 200,000 100%: 200,000 116,670 58% 200,000 100%! Transfers In - Park Fund 30,000 30,000 100% 30,000 17,500 58% 30,000 100% Transfers In - Room Tax (as 25,744 323,348 999% i 25,744 15,019 58% ( 39,599 154% ! 13,855! N needed) Transfers In - County Fair 395,000 250,000 63% < Transfers In - F&E Capital - 300,000 ; Reserve Transfers Out (11,791) (11,791) 100%, (10,777) (6,286) 58% (10,777) 100%, TOTAL TRANSFERS 1,022,863 1,475,467 144% ; 494,967 433,713 88% ; 754,523 152% ; 259,556: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 80,000 (94,564) -118% 364,904 (1,199) 0% (1,199) 0% (366,103): Resources over Requirements (903,287) (1,382,102) (604,321) (513,487) (753,323) (149,002) Net Transfers - In (Out) 1,022,863 1,475,467 494,967 433,713 754,523 259,55& TOTAL FUND BALANCE $199,576 ($ 1,199) -1% $ 255,550 ($ 80,973) -32% ; ; $ 1 0% ; ($255,549); Footnotes on following page A Events revenue to date show an increase compared to PY YTD (FY20 YTD: $264,006) B F&B revenues severely impacted by gathering size limitations C Expected to be under budget due to COVID19 impacts D Increase in rate for FY21 E Reduced due to cancellations F Reimbursement from RV Park for personnel expenditures recorded in F&E. Includes interfund payment for 3.0 FTE whose cost will be absorbed by Roads through 02.28.21 G Reduced due to cancellations H Interest projection based on current investment rate and anticipated cash balances I Temporary reduction of employee hours to reduce expense; reassingment of employees to Roads being offset by Interfund Payments i Temporary reduction of employee hours to reduce expense; reassingment of employees to Roads being offset by Interfund Payments K Reduction from budget planned to offset event revenue loss L Reduction from budget planned to offset event revenue loss M Budgeted Transfer appropriations in the TRT Fund are greater than the Transfer -In budget in F&E N $250K of budgeted transfers in TRT are to be transferred on an as needed basis Budget to Actuals Report Annual County Fair - Fund 616 58 3% FY21 YTD January 31, 2021 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Grant Commercial Exhibitors Concessions and Catering Interest on Investments Fair Sponsorship Merchandise Sales Gate Receipts Carnival Livestock Entry Fees R/V Camping/Horse Stall Rental Concert Rodeo TOTALRESOURCES 52,000 53,167 102% = 52,000 53,167 102% 122,000 12,600 10% 25,400 t 1 1 425,000 V 466,503 110% 5,750 1 200 (166) -83% _ (88) 999% i1 37,500 19,108 51% - i 5,000 E 5,246 105% 560,000 � 561,460 100% E i 340,000 328,274 97% I i 1 7,000 4,731 68% E 1 26,000 i i 625 2% � E 50,000 12,000 24% 25,000 5,650 23% 1,649,700 1,469,198 89% 52,000 84,229 162% ; 53,167 102%; , � 1,167 25,400 1 25,400, A E I 5,750 I 51750= A (200) 999% f I (200)! B I 32,117: 84,117 162% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 164,638 157,448 96% 110,000 75,116 68% 133,101 121% (23,101)� C Materials and Services 1,340,062 1,457,840 109% 17,000 17,739 104% 18,000 106% (1,000) TOTAL REQUIREMENTS ; 1,504,700 1,615,288 107% ; 127,000 92,854 73% ; 151,101 119% ; (24,101); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - TRT 1% 250,000 250,000 100% 75,000 44,000 59% 75,000 100% Transfer Out - Fair & Expo 1 (395,000) (250,000) 63% TOTAL TRANSFERS (145,000) - 0% ; 75,000 44,000 59% ; 75,000 100%, FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 98,629 (47,461) (47,461) (47,461): Resources over Requirements 145,000 (146,090) E (75,000) (8,625) (66,984) i1 8,01& 1 � i Net Transfers - In (Out) ( (145,000) t 75,000 44,000 75,000 t t 4 ! TOTAL FUND BALANCE _ ($ 47,461) ($ 12,086) ($ 39,445) ; ($39,445); A Advanced deposits for Fair 2021 B Interest projection based on current investment rate and anticipated cash balances C Personnel projection includes the full furlough of one employee in December, January & February ` % Budget to Actuals Report Annual County Fair - Fund 616 CY21 YTD January 31, 2021 (unaudited) 2021 Fair 2020 Fair 2021 Projection RESOURCES Gate Receipts $ - $ - $ - Carnival - - - Commercial Exhibitors (5,800) ! 32,100 32,100 Livestock Entry Fees - - - R/V Camping/Horse Stall Rental - - - Merchandise Sales - - - Concessions and Catering - - - Fair Sponsorship (22,250) - - TOTAL FAIR REVENUES $ 28,050 $ 32,100 $ 32,100 OTHER RESOURCES State Grant 53,167 ' - 53,167 Interest 11 - - Miscellaneous - - - TOTAL RESOURCES $ 25,127 $ 32,100 $ 85,267 REQUIREMENTS Personnel 154,640 1,735 140,206 Materials & Services 85,216 ' - - TOTAL REQUIREMENTS $ 239,856 $ 1,735 $ 140,205 TRANSFERS Transfer In - TRT 1% 162,750 6,250 75,000 Transfer Out - Fair & Expo - - - TOTAL TRANSFERS $ 162,750 ; $ 6,250 $ 75,000 Net Fair $ (51,979) $ 36,615 $ 20,062 Beginning Fund Balance on Jan 1 $ 3,285 $ (48,694) $ (48,694) Ending Balance A Personnel reflects furlough plan that is estimated to be in place in Jan & Feb 2021 01ES `9& Budget to Actuals Report Fair & Expo Capital Reserve - Fund 617 58.3% FY21 YTD January 31, 2021 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 16,000 21,189 132% 14,000 5,785 41% 10,400 74% (3,600). A TOTAL RESOURCES 16,000 21,189 132% ; 14,000 5,785 41% ; ' 10,400 74% (3,600); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 345,000 243,985 71% 235,000 8,687 4% 235,000 100% B Capital Outlay 1,017,775 180,946 18% 166,940 92,330 55% 166,940 100% TOTAL REQUIREMENTS ; 1,362,775 424,931 31% 401,940 101,017 25% 401,940 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - TRT 1% 286,687 286,687 100% 253,158 147,674 58% 570,351 225% 317,193, C Transfers Out (300,000) (300,000) 100% TOTAL TRANSFERS (13,313) (13,313) 100% ; 253,158 147,674 58% ; 570,351 225% ; 317,193: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,360,088 1,143,224 84% 1,143,224 726,169 64% 726,169 64% _ (417,055), Resources over Requirements (1,346,775) (403,742) (387,940) (95,231) (391,540) (3,600) Net Transfers - In (Out) (13,313) (13,313) 253,158 147,674 570,351 317,191 TOTAL FUND BALANCE $ 726,169 999% ; $ 1,008,442 $ 778,612 77% $ 904,980 90% ; ($103,462); A Interest projection based on current investment rate and anticipated cash balances B Projection will be adjusted after information is received from Energy Trust regarding rebates C The balance of the 1 % F&E TRT is transferred to F&E reserves �I E S C.�� Budget to Actuals Report RV Park - Fund 618 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance RV Park Fees < 31 Days 405,200 412,954 102% , 400,200 260,379 65% 374,188 94% (26,012): A RV Park Fees > 30 Days 5,000 13,050 261% ! 12,000 9,056 75% 13,332 111% ! 1,332! Interest on Investments 12,000 10,746 90% 7,600 1,370 18% 2,700 36% (4,900)! B Cancellation Fees 5,000 5,271 105% 5,500 155 3% 155 3% (5,345)! C Washer / Dryer 4,000 5,913 148% ; 4,000 3,108 78% 4,618 115% 618! D Vending Machines 3,000 1,821 61% 3,000 571 19% 747 25% (2,253)! D Miscellaneous 2,000 2,332 117% 2,250 1,379 61% 1,379 61% (871) Good Sam Membership Fee 1,500 476 32% 1,500 - 0% - 0% (1,500)! E Good Sam Discounts - (7,109) 999% E TOTAL RESOURCES 437,700 445,454 102% ; 436,050 276,017 63% 397,119 91% (38,931); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 318,273 281,699 89% 321,402 170,368 53% 285,080 89% 36132Z F Debt Service 1 222,100 221,810 100% 222,500 162,805 73% 222,500 100% TOTAL REQUIREMENTS ; 540,373 503,509 93% 543,902 333,173 61% 507,580 93% 36,322; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Park Fund 160,000 160,000 100% 160,000 160,000 100% 160,000 100% Transfers In - TRT Fund 35,000 35,000 100% 25,000 11,732 47% 20,000 80% (5,000): G Transfer Out - RV Reserve (502,000) (502,000) 100% (621,628) (310,814) 50% (297,475) 48% 324,153, H TOTAL TRANSFERS (307,000) (307,000) 100% ; (436,628) (139,082) 32% ; (117,475) 27% 319,153, FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 560,000 592,992 106% 587,992 227,936 39% 227,936 39% (360,056); Resources over Requirements (102,673) (58,056) (107,852) (57,155) (110,461) (2,609) Net Transfers - In (Out) (307,000) (307,000) (436,628) (139,082) (117,475) F f 1 1 t 319,151 TOTAL FUND BALANCE $ 150,327 $ 227,936 152% ; $ 43,512 $ 31,699 73% - 0% ($43,512), A 7,698 RV spaces, 33.78% utilization YTD. Prior year comparable was 8,489 RV spaces, 36.23% utilization YTD B Interest projection based on current investment rate and anticipated cash balances C Cancellation Fees waived for FY21 due to COVID D Reduced due to reduction in space utilization E The Good Sam incentive program was discontinued during Fall 2019. F YTD expenses are higher than prior year due to earlier than usual marketing expense. Budget reductions planned to offset projected revenue reductions. G Budgeted Transfer appropriations in the TRT Fund are less than the Transfer -In budget in the RV Park Fund H Projected transfer reduced due to actual Beg Working Capital coming in lower than budget, as well as projected revenue reductions ,)I ES ` �{ Budget to Actuals Report RV Park Reserve - Fund 619 58.3% FY21 YTD January 31, 2021 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 12,550 3,801 30% 1,100 5,109 464% : 9,000 818% 7,900� A TOTAL RESOURCES 12,550 3,801 30% ; 1,100 5,109 464% ; ; 9,000 818% ; 7,900; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services - 6,641 999% Capital Outlay 100,000 1,694 2% 100,000 0% 20,000 20% 80,000!I B TOTAL REQUIREMENTS 100,000 8,335 8% 100,000 0% ; 20,000 20% 80,000: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - RV Park Ops 502,000 502,000 100% 621,628 310,814 50% 297,475 48% (324,153): C TOTAL TRANSFERS 502,000 502,000 100% ; 621,628 310,814 50% ; 297,475 48% ; (324,153); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 490,000 497,466 102% 497,466 102% , 7,46& Resources over Requirements (87,450) (4,534) (98,900) 5,109 (11,000) 87,900� Net Transfers - In (Out) 502,000 1 502,000 { 621,628 ! 310,814 1 f 297,475 ! (324,153)[ TOTAL FUND BALANCE $ 414,550 $ 497,466 120% ; $1,012,728 $ 813,389 80% ; $ 783,941 77% ($228,787); A Interest projection based on current investment rate and anticipated cash balances B It is anticipated that the full budgeted amount will not be spent. C Projected transfer reduced due to actual Beg Working Capital coming in lower than budget, as well as projected revenue reductions in the RV Fund ,)A E S`�� Budget to Actuals Report Risk Management - Fund 670 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,255,108 1,311,863 105% , 1,188,848 713,881 60% 1,188,848 100% General Liability 1,072,326 1,055,486 98% 990,628 561,867 57% 990,628 100% Property Damage 392,923 395,921 101% 373,698 217,903 58% 373,698 100% Unemployment 323,572 304,607 94% 323,572 297,263 92% 400,000 124%! 76,428! A Vehicle 195,580 203,005 104% 218,185 129,655 59% E 218,185 100% Interest on Investments 137,000 150,197 110% 87,200 68,463 79% 123,100 141% ! 35,900! B Claims Reimbursement 82,000 460,881 562% 50,000 18,333 37% 30,000 60% (20,000)! Skid Car Training 34,000 34,830 102% 30,000 270 1% 5,000 17% (25,000)! Process Fee- Events/ Parades 2,000 765 38% 1,500 90 6% 500 33% (1,000)! Loss Prevention 30 - 0% 10 - 0% f 10 100% Miscellaneous 500 12,967 999% 5 - 0% 30,000 999% 29,99& C TOTAL RESOURCES 3,495,039 3,930,523 112% ; 3,263,646 2,007,725 62% ; 3,359,969 103% ; 96,323: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,460,000 713,047 49% 1,560,000 480,469 31% 1,100,000 71% , 460,000; General Liability 1,400,000 311,666 22% 1,100,000 222,504 20% 1,200,000 109% ! (100,000)� D Insurance Administration 592,059 470,972 80% 584,104 219,180 38% 539,199 92% 44,90& E Property Damage 400,236 701,454 175% ! 200,240 304,082 152% 450,000 225% (249,760)! F Unemployment 130,000 63,289 49% r 200,000 65,218 33% 190,000 95% 10,000! Vehicle 150,000 179,835 120% 150,000 84,951 57% A 180,000 120% ; (30,000): TOTAL REQUIREMENTS 4,132,295 2,440,263 59% 3,794,344 1,376,403 36% 3,659,199 96% 135,145; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out - Vehicle Replace (6,918) (6,918) 100% (3,500) (2,039) 58% (3,500) 100% _ TOTAL TRANSFERS (6,918) (6,918) 100% ; (3,500) (2,039) 58% ; ; (3,500) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 6,100,000 7,193,407 118% 7,000,000 8,676,750 124% 8,676,750 124% 1,676,750 Resources over Requirements (637,256) 1,490,260 (530,698) 631,322 (299,230) 231,468 Net Transfers - In (Out) t (6,918) (6,918) E (3,500) (2,039) _ t i (3,500) E f TOTAL FUND BALANCE $ 5,455,826 $ 8,676,750 159% ; $ 6,465,802 $ 9,306,032 144% ; $ 8,374,020 130% ; $1,908,218: A Unemployment collected on first $25K of employee's salary in fiscal year 8 interest projection based on current investment rate and anticipated cash balances C FY20 includes $12,962 in State reimbursements for COVID related costs. D General Liability claims are difficult to budget and predict E Projected Personnel savings based on FY21 savings to date F YTD actuals includes Property Insurance Premium, which is an annual expenditure �I ES C Budget to Actuals Report Health Benefits . Fund 675 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Internal Premium Charges 17,411,292 17,841,713 102% , 17,831,938 10,790,331 61% 17,831,938 100% , COIC Premiums 1,967,021 1,670,202 85% 1,600,000 789,521 49% 1,574,688 98% (25,312) Retiree / COBRA Premiums t 1,433,000 1,023,556 71% t 1,035,000 335,543 32% 1,000,000 97% (35,000)! Employee Co -Pay 1,041,120 1,060,127 102% ! 1,031,400 676,741 66% 1,160,127 112% 128,727! Interest 346,000 334,654 97% 216,200 135,610 63% 245,100 113% 28,900! A Prescription Rebates 75,000 174,148 232% 90,000 91,487 102% 100,000 111% 10,000! Claims Reimbursement & Other 45,000 386,585 859% 80,000 1,073 1% 80,000 100% TOTAL RESOURCES 22,318,433 22,490,985 101% ; 21,884,538 12,820,305 59% 21,991,853 100% ; 107,315: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Health Benefits 20,550,836 18,763,095 91% 19,937,274 8,883,701 45% 18,833,754 94% 1,103,520, B Deschutes On -Site Pharmacy 2,242,104 2,952,787 132% 2,417,092 1,418,578 59% 2,417,092 100% ! B Deschutes On -Site Clinic t 1,141,691 1,084,574 95% 1,101,467 577,285 52% 1,101,467 100% B Wellness 180,380 152,600 85% 164,340 101,111 62% 164,340 100% ! B TOTAL REQUIREMENTS ; 24,115,011 22,953,057 95% 23,620,173 10,980,675 46% 22,516,653 95% ; 1,103,520: TOTAL':: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 16,106,294 16,563,905 103% , 15,323,729 16,101,833 105% 16,101,833 105% = 778,104E Resources over Requirements t (1,796,578) t (462,072) (1,735,635) � 1,839,630 �t (524,800) 1,210,835 t i Net Transfers - In (Out) - t - - - TOTAL FUND BALANCE $ 14,309,716 $ 16,101,833 113% ; $ 13,588,094 $ 17,941,463 132% ; ; $15,577,033 115% ; $1,988,939: A Interest projection based on current investment rate and anticipated cash balances B Amounts are paid 1 month in arrears; projection compared to historical costs for reasonableness; 12-month rolling average trending downward 91 E's Budget to Actuals Report 911 - Fund 705 and 710 FY21 YTD January 31, 2021 (unaudited) 58.3% Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Property Taxes - Current Yr 8,809,419 8,876,513 101% 9,113,459 8,757,079 96% 9,155,214 100%, 41,755; A Telephone User Tax 900,000 1,053,847 117% 1,106,750 340,292 31% 1,306,750 118% 200,000, B Police RMS User Fees 250,000 386,751 155% 250,000 105,460 42% 250,000 100% Contract Payments 51,300 71,929 140% , 157,252 26,500 17% 157,252 100% Interest 157,000 184,668 118% 90,400 71,680 79% 121,800 135% 31,400! C Property Taxes - Prior Yr 100,000 262,105 262% 90,000 107,557 120% 110,000 122% , 20,00& State Reimbursement 125,000 107,881 86% 83,000 3,000 4% 83,000 100%! D User Fee 73,680 135,243 184% 73,000 4,313 6% 73,000 100% Data Network Reimbursement 55,000 96,232 175% 55,000 - 0% 55,000 100% Property Taxes - Jefferson Co. 30,000 34,547 115% 33,637 34,109 101% 34,500 103% , 863 Miscellaneous 11,951 70,966 594% , 12,200 19,709 162% , 20,000 164% ! 7,800! TOTAL RESOURCES 10,563,350 11,280,682 107% ; 11,064,698 9,469,699 86% ; 11,366,516 103% ; 301,818: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 7,462,575 6,980,012 94% 7,620,458 4,202,492 55% 7,298,402 96% 322,056: E Materials and Services 3,387,761 3,072,800 91% 3,476,381 1,998,859 57% 3,476,381 100% Capital Outlay 1,400,000 669,792 48% 1,480,000 263,855 18% 1,480,000 100% TOTAL REQUIREMENTS 12,250,336 10,722,604 88% 12,576,839 6,465,206 51% 12,254,783 97% ; 322,056: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 400,000 400,000 100% 1,997,257 1,997,257 100% 1,997,257 100% Transfers Out (400,000) (400,000) 100% (1,997,257) (1,997,257) 100% (1,997,257) 100% t TOTAL TRANSFERS FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 7,753,706 8,604,816 111% 8,341,418 9,162,894 110% 9,162,894 110% , 821,47& Resources over Requirements (1,686,986) 558,079 (1,512,141) 3,004,493 (888,267) t 623,874! Net Transfers - In (Out) - 2 TOTAL FUND BALANCE $ 6,066,720 $ 9,162,894 151% ; $ 6,829,277 $12,167,387 178% ; $ 8,274,627 121% ; $1,445,350: A Current year taxes received primarily in November, February and May; actual 20-21 TAV is 5.40% compared to FY19-20 vs. 5.00% budgeted B Telephone maintenance reimbursements are received in a lump sum by early spring; anticipating an increase in telephone tax from the State that was not budgeted c Interest projection based on current investment rate and anticipated cash balances D State GIS reimbursements are received quarterly E Personnel savings based on FY21 YTD average vacancy rate of 7.3% E S CMG o c Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - Fax (541) 385-3202 - https://www.deschutes.org/ AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of February 22, 2021 DATE: February 8, 2021 FROM: Whitney Hale, Administrative Services, 541-330-4640 TITLE OF AGENDA ITEM: Review of Leadership Bend Presentation BACKGROUND AND POLICY IMPLICATIONS: Discussion about the Board's upcoming presentation to Leadership Bend on February 25. FISCAL IMPLICATIONS: None ATTENDANCE: Whitney Hale, Communications Director Agenda Introductions What to do coun ..,s oo? Association Oregon Counties OREGO N COUNTIES - VROVIDING VITAL- PUBLIC %S61ZV(MI The Board of com m ss o ne ofl County Policy , jectives, Budget Approva- PriontizationGoa'Is & 0 ' Legislative Role Modification of County CO)tm! 0 Land U se, Events, Addressing Grievances ,,'Clty Councoll" for Unincorporated County i ions Boards & Comm'sse Im ml?zvm!m BOARD WNP 'm County Services %0."'0MMUN1w'1PY SERVICES .......... "I'll", Community Development, Garbage and Recycling, Fair & Expo Center, Natural Resources, Transportation and Roads Behavioral Health, Public Health, Veterans' Services PUBLIC SAFETY 9-1 -1, Sheriff's office, District Attorney's Office, justice Court, Community Justice, Medical Examiner L I Ounty Serviaces I Partnersh'I'ps GENERAL GOVERNMEN' SERVICES Assessment its c ; n and Taxation, Voting and Elec i oiA lack ButteRanch, Deschutes ®� ®1® t �/� u�6ve� 4PARTNERSHIPS WITH LOCAL Bend, La Pine, Redmond a • ( Sisters {e,t-" COVID-19: Response and Vaccine Rollout FY 2022 Budget Planning Wildfire Mitigation 2021 Legislative Session Pr"orate' i i ies . 6 ` 3� l� �y�z`�©�� with � /`�` / \«�v� g us � r<®� �� a��, �G�vT F S CQG t.)Yl:I (),0I To: Oregon House Committee on Mental Health Re: Support for HB 3123 passage Dear Chair Sanchez and Members of the Committee, Deschutes County Health Services is one of twelve Oregon community mental health programs participating in the Certified Community Behavioral Health Clinic (CCBHC) federal demonstration program administered by the Substance Abuse and Mental Health Services Administration. CCBHC Demonstration funding was continued by Congress through September 30, 2023. In order to continue this model program and draw down the significant 4:1 federal match over the three year extension, Oregon must provide a state general fund match in the 21-23 biennium. The Deschutes County Board of County Commissioners strongly supports the passage of HB 3123 which will provide the state match and support CCBHCs to continue in Oregon. We believe the proposal represents an important investment that goes a long way toward maintaining key behavioral health infrastructure during a time when Oregonians will need these services more than ever. CCBHCs represent a forward thinking, proactive and fiscally viable approach to addressing chronic shortfalls in mental health and addiction services. Individuals with serious and complex mental health and substance use disorders often struggle with co-occurring addiction and chronic physical health concerns, which significantly shorten lifespan and contribute to increased homelessness, incarceration and use of emergency department and hospital resources. CCBHCs target this population for improved treatment of both their primary behavioral health and secondary physical health concerns. Intended results are to improve outcomes and reduce costs by preventing individuals from needing higher levels of care or entering other more costly systems. The federal demonstration prospective payment model has enhanced revenue, allowing CCBHCs to finance the infrastructure needed to provide these comprehensive services. Positive developments within the first two years of Deschutes' CCBHC project include: • Increased workforce, especially use of peer delivered and case management services • Increased access for un/under-insured individuals, such as veterans and older adults • Adding primary care at each service location resulting in increased coordination of care • Standard suicide risk assessment and universal safety planning for all clients to reduce suicide risk • Reductions in Emergency Department utilization and homelessness for those served 1300 NW Wall Street Bend, Oregon 97703 (541) 388-6572 board@deschutes.org @ www.deschutes.org • Statistically significant improvements in quality of life and effectiveness at dealing with problems • Enhanced ability to respond to COVID emergency due to employment of peers and case managers, enhanced overall staffing, integration with primary care partners Without this funding, Oregon will risk experiencing: Immediate workforce reduction in a behavioral health system already understaffed and undercompensated • Dismantling of the first statewide attempt to initiate behavioral health homes in 2019 • Loss of significant gains in improving access, expanding service array, and preventing higher cost care Re-established wait lists for services, closed or eliminated services, i.e., people turned away from care, losing access to medication assisted and other addiction treatment Please help maintain our CCBHCs' good progress as we await Congressional action in the fall. Thank you for your consideration, The Deschutes County Board of Commissioners Tony DeBone Phil Chang Patti Adair Chair Vice Chair Commissioner CC: Senators Lynn Findley, Tim Knopp, and Dennis Linthicum Representatives Daniel Bonham, Vikki Breese Iverson, Jason Kropf and Jack Zika \)DES CO Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - Fax (541) 385-3202 - https://www.deschutes.org/ AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of February 22, 2021 DATE: February 16, 2021 FROM: Erik Kropp, Administrative Services, 541-388-6584 TITLE OF AGENDA ITEM: Review Draft FY 22 Goals and Objectives RECOMMENDATION & ACTION REQUESTED: Board review of draft goals and objectives and make changes as deemed appropriate. BACKGROUND AND POLICY IMPLICATIONS: On January 28, 2021 the Board held a Planning Retreat. At the retreat, the Board reviewed the County's current goals and objectives and made updates and changes for FY 22. Staff will review these proposed changes with the Board before finalizing the FY 22 Goals and Objectives. Attached is a red -lined version of the FY 22 Goals and Objectives showing the changes as well as clean copy. The "red -lined" version shows changes in both red and blue colors (which reflects edits from two different staff members). Once the Board finalizes the FY 22 Goals and Objectives, staff will send the document, along with the individual "Commissioner Priorities" lists, to departments to will help departments prepare their FY 22 budgets and performance measures. FISCAL IMPLICATIONS: None. ATTENDANCE: Tom Anderson, Whitney Hale, and Erik Kropp � )I ES o BOARD OF COMMISSIONERS FY 2022 Goals and Objectives Mission Statement: Enhancing the lives of citizens by delivering quality services in a cost-effective manner. Safe Communities: Protect the community through planning, preparedness, and delivery of coordinated services. • Provide safe and secure communities through coordinated public safety and crisis management services. • Reduce crime and recidivism through prevention, intervention, supervision and enforcement. • Collaborate with partners to prepare for and respond to emergencies, natural hazards and disasters. Healthy People: Enhance and protect the health and well-being of communities and their residents. • Support and advance the health and safety of Deschutes Countys residents. • Promote well-being through behavioral health and community support programs. • Help to sustain natural resources and air and water quality in balance with other community needs. • Continue to support COVID-19 pandemic crisis_-re-c-eF,er},%an4-response and community health_ _ecov_ery, Economic Vitality: Promote policies and actions that sustain and stimulate economic vitality. • Support affordable and transitional housing options for vulnerable populations through availability of lands, project planning, and appropriate regulation. • Administer land use policies that promote livability and economic opportunity. • Maintain a safe, efficient and economically sustainable transportation system. • Partner with organizations and manage County assets to attract business development, tourism, and recreation. • Support regional economic recovery from the COVID pandemic. Service Delivery: Provide solution -oriented service that is cost-effective and efficient. • Ensure quality service delivery through the use of innovative technology and systems. • Support and promote Deschutes County Customer Service "Every Time" standards. • Promote community participation and engagement with County government. Preserve expand and enhance capital assets, t0 ctronnthen fiscal security, a ensure sufficient s_a_ce_�g;lr� fis;c�!-c.�a i� for operational needs. • Maintain strong fi_scalDractices to SUDJort short,. and long- terra county needs. • Provide collaborative internal support for County operations. ��v S ES CMG 2� BOARD OF COMMISSIONERS FY 2022 Goals and Objectives Mission Statement: Enhancing the lives of citizens by delivering quality services in a cost-effective manner. Safe Communities: Protect the community through planning, preparedness, and delivery of coordinated services. • Provide safe and secure communities through coordinated public safety and crisis management services. Reduce crime and recidivism through prevention, intervention, supervision and enforcement. Collaborate with partners to prepare for and respond to emergencies, natural hazards and disasters. Healthy People: Enhance and protect the health and well-being of communities and their residents. • Support and advance the health and safety of Deschutes County's residents. • Promote well-being through behavioral health and community support programs. • Help to sustain natural resources and air and water quality in balance with other community needs. • Continue to support COVID-19 pandemic crisis response and community health recovery. Economic Vitality: Promote policies and actions that sustain and stimulate economic vitality. • Support affordable and transitional housing options for vulnerable populations through availability of lands, project planning, and appropriate regulation. • Administer land use policies that promote livability and economic opportunity. • Maintain a safe, efficient and economically sustainable transportation system. • Partner with organizations and manage County assets to attract business development, tourism, and recreation. • Support regional economic recovery from the COVID pandemic. Service Delivery: Provide solution -oriented service that is cost-effective and efficient. • Ensure quality service delivery through the use of innovative technology and systems. • Support and promote Deschutes County Customer Service "Every Time" standards. • Promote community participation and engagement with County government. • Preserve, expand and enhance capital assets, to ensure sufficient space for operational needs. • Maintain strong fiscal practices to support short and long term county needs. • Provide collaborative internal support for County operations.