Loading...
2020-144-Minutes for Meeting March 23,2020 Recorded 4/21/2020• BOARD OF COMMISSIONERS 1300 NW Wall Street, Bend, Oregon (541) 388-6570 11:00 AM Recorded in Deschutes County CJ2020_144 Nancy Blankenship, County Clerk 04/21 /2020 11:55:29 AM Commissioners' Journal --w .xx � I III III 2020-144iinmuimm FOR RECORDING STAMP ONLY Barnes Sawyer Room Present were Commissioners Patti Adair, Anthony DeBone, and Phil Henderson. Also present were Tom Anderson, County Administrator; Erik Kropp, Deputy County Administrator; David Doyle, County Counsel; and Samantha Pepper, BOCC Administrative Assistant. Several citizens and several identified representatives of the media were in attendance. Attendance was limited in response to Governor's orders. CALL TO ORDER: Chair Adair called the meeting to order at 11:01 a.m. PLEDGE OF ALLEGIANCE CONSENT AGENDA: Before the Board was Consideration of Approval of the Consent Agenda. HENDERSON: Move Approval of Consent Agenda. DEBONE: Second VOTE: HENDERSON: Yes DEBONE: Yes BOCC MEETING MARCH 23, 2020 PAGE 1 OF 11 ADAIR: Chair votes yes. Motion Carried Consent Agenda Items: 1. Consideration of Board Signature of Document No. 2020-230, Hamby Road Deed of Dedication - Cynthia Smidt, Associate Planner 2. Consideration of Board Signature of Document No. 2020-231, Neff Road Deed of Dedication - Cynthia Smidt, Associate Planner 3. Consideration of Board Signature of Resolution No. 2020-016, Adopting the 2019 Oregon Fire Code for Deschutes Rural Fire District #2 - Amy Heverly, Assistant Legal Counsel ACTION ITEMS: PUBLIC HEARING: Annexation to River Forest Acres Road District and Consideration of Board Signature of Order No. 2020-009, Approving Mallard Drive Annexations into River Forest Acres Legal Counsel Dave Doyle introduces this annexation into the River Forest Acres Road District. Doyle notes that hearing is specific to the identified road district, and that due to uncertainty regarding public gatherings legal staff has advanced the hearing from Wednesday. The media was provided notice of the advancement and the road district and subject property owners are in attendance via conference call. Commissioner Adair opens the public hearing. Road district representatives respond to questions from Commissioners and states that there are 75 homes currently in the road district; this annexation will increase that number to 77 homes. Commissioner Adair closes the public hearing. HENDERSON: Move Approval of Board Signature of Order No. 2020-009. DEBONE: Second VOTE: HENDERSON: Yes DEBONE: Yes BOCC MEETING MARCH 23, 2020 PAGE 2 OF 11 ADAIR: Chair votes yes. Motion Carried S. Consideration of Proposed Grant Application: FY2020 Law Enforcement Mental Health and Wellness Act Program Grant Staff from the Sheriff's office were not present. Commissioner Henderson acknowledges that that the staff memo does a great job at providing information. Commissioner DeBone mentions that this helps meets our community and citizen's needs. Commissioner Adair voices her support of the application approval. HENDERSON: Move Approval of FY2020 Law Enforcement Mental Health and Wellness Act Program Grant application. DEBONE: Second Commissioner Henderson asks if this is a state or federal grant. Mr. Anderson will ask for more information from the Sheriff. VOTE: HENDERSON: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried 6. Consideration of Board Signature of Document No. 2020-225, a Revocable License Addendum for Neighbor Impact Warming Shelter Erik Kropp, Deputy County Administrator presents license addendum for the Neighbor Impact warming shelter. The shelter was due to close last week but organizers are needing to stay open a little longer based on COVID-19 pandemic. They have extended operations to April 16, 2020. They are at capacity almost every night with 48 people. According to organizers, it is a little hard to maintain staff during these challenging times. Commissioner Adair asked if the shelter has more funding available to operate past the April date. It is not believed that they do. County Sherriff is willing to extend the agreement. At this time, Commissioners support the shelter staying open longer. BOCC MEETING MARCH 23, 2020 PAGE 3 OF 11 HENDERSON: Move Approval of Board signature of Document No. 2020-225. DEBONE: Second VOTE: HENDERSON: DEBONE: ADAI R: COVID-19 UPDATE SITUATION UPDATE: Yes Yes Chair votes yes. Motion Carried Commissioner Adair mentions that during yesterday's phone conference with the Governor is was made clear that local leaders want essential industry to keep operating. Commissioner DeBone notes that many retail stores will have to close in response to Governor Kate Browns' Executive Order that was just released. DeBone notes that social distancing is very important. Dr. George Conway, Health Services Directorjoined the meeting to update County Commissioners and staff on the COVID-19 pandemic. Majority of the cases are male and half are 65 or older. Homelessness seems to be an issue. Social distancing is still very important. States are doing their best to roll out testing with what is available. There is now a halt for much commerce in and out of our economy according to the most recent emergency order from the Governor. Health professionals do want to advocate for more testing. Commissioner Adair asks if the 10 Deschutes County residents are in hospitals or where they are placed. Dr. Conway introduces the new Community Health Deputy Director, Dr. Nahad Sadr- Azodiand who officially begins work on April 1 st, 2020. Hillary Saraceno will remain on staff through the transition and until the current virus situation resolves. Commissioner Henderson speaks to creating a video to include county leaders providing information on COVID-19. Dr. Conway explains that this virus originally struck in China and then replicated fast into Italy due in part to long-standing trade and travel between the Wohan BOCC MEETING MARCH 23, 2020 PAGE 4 OF 11 region in China and Northern Italy. Dr. Conway indicated that it now appears that the virus was present, and undetected in Northern Italy as early as November. Testing remains a challenge. Citizens have to have several significant symptoms to be tested. It will be several weeks before testing is more widespread. The biggest importance right now is to locate testing swabs and kits and PPE (Personal Protection Equipment). Commissioner Henderson asks if there is anything Commissioners can do to advocate for more testing supplies. Dr. Conway adds that there is an international shortage of testing kits. Health providers do want to test everyone that is ill and then proceed from there. If not ill there is no capacity to be tested. Dr. Conway states that even 2,000 swabs would be beneficial to our local health system. Commissioner Adair mentions that testing for the flu is now standard. DCSO Sargent Nathan Garibay presents potential site clinic plans and ideas. Medical surge planning is the main focus of emergency management right now. The 30 ventilators that were requested have been ordered and should arrive the first part of April. Commissioner Henderson asks what the county's role in Surge Planning is. Sgt. Garibay states it includes locating and securing more sites like clinic rooms for placement of patients who may be sick. Lack of PPE still continues to be a big challenge fcr the hospitals and that ,s where the emergency team Is try ing to help the most. Commissioner Henderson also asked if Urgent Care Centers would be a good idea for Surge outlets. Sgt. Garibay states that the vulnerable population is receiving a good deal of focus right now. The goal is to minimize people to leaving their homes unless absolutely necessary. Dr. Conway mentions another important focus of getting school children meals and senior citizens access to medicine or other needs. The homeless population is also a focus group due to personal hygiene and sanitation issues. Commissioner Henderson asks what conversation they have had with School Districts around the region and suggests that buses could be used to deliver food for school children and senior citizens. Sgt. Garibay mentions that there are community members who want to use their resources to help others. The team is continually working with partners to use these unused resources to create resources. BOCC MEETING MARCH 23, 2020 PAGE 5 OF 11 Commissioner Adair emphasizes the importance of giving blood in this time of need. Dr. Conway asks for the Commissioners help with information and service gathering. In the next 24 hours they will have an idea what actual needs are for our most vulnerable people in the community. It is important for people to stay separated and set up social means to help everyone as a whole. He will give an update to the Board as soon as information is available. Commissioner DeBone acknowledges that there are many people out there that want to help. It is important to allow for help in a safe and healthy manner. Commissioner Adair mentions that a local physician has ordered testing from a US Supplier which is almost 6 weeks out. Dr. Conway stresses that supporting the public in basic essential needs will be part of best practices in this crisis. OREGON STATE GOVERNOR'S STAY AT HOME ORDER: Tom Anderson presents the Governor's Stay-at-home emergency order. It includes r r^. is .� c r.ocific to cm�ll �ii icineccec The nrrJor allnu�nic fnr continuation of r./I vV�.iwn> Jr.Jcl.���l. w .7� �a u.7�� .7.7 .7. �G v ul. v.7 IvI l.vI It II uv1I v essential services. Mr. Anderson informs the Commissioners that he has directed each county department to undertake an immediate assessment of essential functions/operations. Mr. Anderson will further communicate with department heads later today. Essential positions will remain working on site at this time so government business can go on. There are options for some employees to work remotely. An employee that is not an essential position and who cannot work remotely will be presented options re: leave and alternative work options with other county departments. Regarding the status of government buildings; decision for local facilities is with the local jurisdiction. Commissioner DeBone is supportive of closing the County buildings to public access at this time, but remaining available via phone, email and when necessary, in person appointments. Commissioner Henderson mentions that he went to the post office today and they were open. He also asks what a non -essential job is and if there is a concern to the public. He is unsure who is an essential employee or non -essential employee. BOCC MEETING MARCH 23, 2020 PAGE 6 OF 11 Mr. Anderson mentions that the Health Department has a number of its employees working remotely. Elected official offices have their own functions and needs and Mr. Anderson defers to each elected official as to how he/she plans to implement the most recent emergency order from the Governor. Mr. Anderson has requested that all departments indicate how they plan to continue business operations if the building was to be closed or restricted. Commissioner Adair and DeBone are generally supportive of closing the building to public access (due to public health/virus concerns). County staff will continue to assist the public via electronic and telephone options unless an in person appointment is needed. Mr. Anderson will implement closings/restrictions on a site -specific basis. RECESS: At the time of 1:32pm, the Board took a recess (projected until 1:42pm). RECONVENE: At the time of 1:44 pm, Chair Adair reconvened the meeting. CONTINUED: COVID-19 UPDATE BUSINESS ASSISTANCE: Whitney Hale, County Communications Director provides update on the Oregon small business assistance program. She mentions that information is posted on the Deschutes County webpage. Representatives from Business Oregon are working with the county to add additional business resources for our small business community. COMMUNICATION UPDATES: Ms. Hale states that the Sheriffs Office has offered to do a press conference with County Commissioners tomorrow. Commissioner Henderson and Commissioner Adair voice interest in taking part. BOCC MEETING MARCH 23, 2020 PAGE 7 OF 11 VACATION CAPS- EXTENSION OF DEADLINE: Mr. Anderson presents the Board with the idea that the vacation accrual deadline be pushed to the end of 2020 due to the coronavirus. The deadline is usually in April. This will afford employees additional time to spend down excess TML accrual. The Sheriff has requested this concession for his staff. Commissioner Henderson will follow up with the Sherriff to better understand the issue. OTHER ITEMS: Hiring Freeze- Tom Anderson recommends a hiring freeze for non -essential positions. Commissioners all in agreement. There can be special requests from departments if needed. Remote work -Joe Sadony states the high need for employees to tele-work during this health emergency. There are about 300 employees working remotely. It is continuing to be a work in progress to get technology up to speed to serve all these employees. Commissioner DeBone asks what is being offered to employees for devices and if any additional supplies are being purchased. Mr. Sadony adds that the needs vary between departments. They are dependent on what the departments own currently which is mainly laptops. There have not been many purchases. Commissioner Adair asks if there are ways to track employee productivity while working from home. Mr. Sadony can tell which devices are connected but does not have necessary software to track active work. Tom Anderson states that there is a guideline/ policy about to be in effect regarding these concerns. Employee Travel- Mr. Anderson mentions that the county is working on a policy for when an employee travels and then returns to work given the possible exposure to COVID-19. Future Meetings- Mr. Anderson asks the Board if they would like to continue with in -person Monday Board meetings or move meetings to virtual video. Ms. Hale adds that the Board can have a virtual meeting from the comfort of offices and there will be opportunity for public participation. For the Board meeting on March 25t" (which will proceed in light of latitude granted by Governor's Order relative to local government buildings) Commissioners Adair and Henderson expect to be present in the BS Conference room, along with the real time video/audio stream. Commissioner DeBone is supportive of a virtual meeting and plans to experiment and attend the meeting from his office. BOCC MEETING MARCH 23, 2020 PAGE 8 OF 11 Recycling- It was asked at a previous meeting if recycling at Knott Landfill would close during COVID-19. After talking with staff, Mr. Anderson states that it is hard to leave the garbage side of the landfill open and not the recycle side. No other landfill in the state is shutting down. Commissioners voice the importance for keeping the landfill open to receive waste and recycles. OTHER ITEMS: • Commissioner Henderson was asked if construction was effected by the Governor's orders. He did not believe so. • Commissioner Henderson mentions an email the Commissioners received regarding the county fair animal weight -in taking place soon. • Commissioner Henderson speaks about email from Roger Lee emphasizing how important manufacturing is in our economy. • Commissioner Adair reports that Deschutes Brewery has laid off 110 employees. • Commissioner Adair reminds Commissioners that legislative concepts and neg^fi inn el Iggosstionc chni 1I/d he sort to Conntnr Finley by tomorrow.I [I-_ VLatIVI I OLA t. u%J1 IJ 01 IV IA IIA "J mil. l 6w Jt.l Iu tVl ..1 - 6V... RECESS: At the time of 2:50 pm, the Board took a recess (projected until 3:00 pm). RECONVENE: At the time of 3:02 pm, Chair Adair reconvened the meeting. 7. Legislative Session Debrief Whitney Hale, County Communications Director and Nick Lelack, County Community Development Director present the Legislative Session Recap. There may be a special session in May due to the COVID-19 pandemic. Mr. Lelack presented information regarding possible sessions that might be held this week or next. Funding needs, public and citizen relief are the two main topics that will be on the agenda for this session. He mentions that planning decisions could change BOCC MEETING MARCH 23, 2020 PAGE 9 OF 11 given the time frame of official planning decisions. Commissioner Adair asks about ADU legislation. They suspect that is will happen but Mr. Lelack agreed to keep everyone advised. Ms. Hale asks for feedback on coordination during the last legislative session. Commissioners agreed that it went well. She also mentioned that the contract for PacWest is expiring. Commissioner Adair asks how long PacWest has been the County's lobbyists. Tom Anderson states since 2016. The contract term expired in 2018 but services and payment have continued subject to 30-day termination notice. The county could issue a RFP if that is the direction of the Board. Commissioner Henderson expressed opinion that the legislative sessions went well and all information was presented nicely. Commissioner DeBone agreed. 8. Treasurer and Finance Report Greg Munn presents the Treasurer and Finance Report through February 2020. Portfolio balance is $238 million dollars largely due to property tax collections. All county portfolio balances were within the proper limits. LGI rate went down and Will prnh ly rnr,tinun tr% rJn cn nng I ironcincr is mnving from faro_tn_farc to an VY111 probably \.Vl llll l C. l.V ..IV JV. V V Lll. l.11J 11 IJ I I IV V 111 11 I I face-to-face- e LV 1 ce- o a online platform but citizens are still welcome into the tax department. The fiscal year has started very strong but will most likely drop off by the end of the year. Mr. Munn mentions Fair Fund 615 is going to come down because of cancelled events due to COVID-19. Commissioner DeBone mentioned to the Fair Director that this slow time could be used to do maintenance around the fairgrounds instead of laying off employees. Commissioner Adair asked about uncollected marijuana tax money. Mr. Anderson states that they have not received anything for a few months from the state. Mr. Doyle adds that the county is in contact with the state DOJ/ DOR to ascertain whether litigation will be necessary. Mr. Doyle will send update to Commissioners. Commissioner Henderson asks about federal grants for health being held up due to the COVID-19 pandemic. Mr. Anderson mentions that there will be update soon regarding the health department budget. COMMISSIONER UPDATES: None presented. BOCC MEETING MARCH 23, 2020 PAGE 10 OF 11 EXECUTIVE SESSION: At the time of 4:02 p.m., The Board went into Executive Session under ORS 192.660 (2) (e) Real Property Negotiations. The Board came out of Executive Session at 4:03 p.m. [Matter was advanced by staff as precaution if BOCC meeting on March 25tn had been cancelled; matter continued to March 25tn ] HIM Being no further items to come before the Board, the meeting was adjourned at 4:04 pm. DATED this Day of 2020 for the Deschutes County Board of Commissioners. 1. PATTI A AI , CHAIR ANTHONYDEBONE, VICE CHAIR P ILIP G. NDERSON, COMMISSIONER BOCC MEETING MARCH 23, 2020 PAGE 11 OF 11 Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - www.deschutes.or BOCC MEETING AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 11:00 AM, MONDAY, MARCH 23, 2020 Barnes Sawyer Rooms - Deschutes Services Center - 1300 NW Wall Street - Bend This meeting is open to the public, and allows the Board to gather information and give direction to staff. Public comment is not normally accepted. Written minutes are taken for the record 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 Board's ability to address other topics. Meetings are subject to cancellation without notice. Item start times are estimated and subject to change without notice. CALL TO ORDER PLEDGE OF ALLEGIANCE CITIZEN INPUT CONSENT AGENDA Consideration of Board Signature of Document No. 2020-230, Hamby Road Deed of Dedication - Cynthia Smidt, Associate Planner 2. Consideration of Board Signature of Document No. 2020-231, Neff Road Deed of Dedication - Cynthia Smidt, Associate Planner 3. Consideration of Board Signature of Resolution No. 2020-016, Adopting the 2019 Oregon Fire Code for Deschutes Rural Fire District #2 - Amy Heverly, ACTION ITEMS Board of Commissioners BOCC Meeting Agenda Monday, March 23, 2020 Pagel of 3 4. PUBLIC HEARING: Annexation to River Forest Acres Road District and Consideration of Board Signature of Order No. 2020-009, Approving Mallard Drive Annexations into River Forest Acres - Pauline Word, Paralegal Add -On 5. 11:05 AM Consideration of Proposed Grant Application: FY2020 Law Enforcement Mental Health and Wellness Act Program Grant -Jennifer Hill, 6. 11:15 AM Consideration of Board Signature of Document No. 2020-225, a Revocable License Addendum for Neighbor Impact Warming Shelter - Deborah Cook, Administrative Assistant 7. 11:20 AM COVID-19 Update LUNCH RECESS 8. 1:00 PM Legislative Session Debrief - Whitney Hale, Communications Director 9. 1:45 PM Treasurer and Finance Report - Greg Munn, Chief Financial Officer COMMISSIONER'S UPDATES EXECUTIVE SESSION 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. 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. ADJOURN Board of Commissioners BOCC Meeting Agenda Monday, March 23, 2020 Page 2 of 3 To watch this meeting on line, go to: www.deschutes.org/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. gru®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, March 23, 2020 Page 3 of 3 Coronavirus Update Monday March 23, 2020 • Situation Update o George Conway • Governor's Stay at Home Order o Implementation discussion o Essential services o County Buildings • Business Assistance o General/Web page update • Communications Update • Vacation Caps o Extension of deadline • Other Issues o Hiring Freeze — non -essential o Remote Work Update o Temporary Leave Policy o Draft Travel/Return to Work Policy o Future BOCC meetings o Recycling - citizen response • BOCC — Other Items CMG � 2 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 March 23, 2020 DATE: March 19, 2020 FROM: Greg Munn, Finance, 541-388-6559 TITLE OF AGENDA ITEM: Treasurer and Finance Report MEMORANDUM DATE: March 25, 2020 TO: Board of County Commissioners FROM: Greg Munn, Acting County Treasurer and Chief Financial Officer SUBJECT: Treasury and Finance Report Following is the monthly finance report as of fiscal year to date February 29, 2020 (unaudited). Treasury and Investments • The portfolio balance at the end of February was $238M, an increase of $4 million from the last month, due primarily to second trimester property tax collections, and an increase of $26M (12%) from a year ago. • Net investment income for the month is $360,837, $31,358 less than last month and $39,599 less than February 2019. While the year to date net interest income is 13% more than the prior year, this difference is expected to narrow as the average portfolio return continues to decline (the difference was 17% last month). • All portfolio category balances are within maximum limits. • Average portfolio yield for the month is 2.20% which is down from last month's 2.26% (and 2.30% for December) reflecting lower return opportunities in the securities market. • The Local Government Investment Pool rate remains unchanged at 2.25% but was lowered to 2.00% on March 11. • The weiahted average time to maturity is 0.90 years whirh is a slight increase from last month's 0.85 average and reflects continued investments in short term options. Portfolio Breakdown: Par Value by `Investment Type Municipal Debt $ 15,510,000 6.5% Corporate Notes 57,090,000 23.9% Time Certificates - 0.0% U. S. Treasuries 16,000,000 6.7% Federal Agencies 94,465,000 39.6% LGIP 49,518,473 20.8% First Interstate Bank 5,839,223 2.4% Total Investments $ 238,422,696 100.0% Investment Income Feb-20 Y-T-D Total Investment Income 379,828 3,167,755 Less Fee: 5% of Inwst. Income (18,991) 158,388 Investment Income - Net 360,837 3,009,367 Prior Year Comparison Feb-19 400,436 2,657,694 Category Maximums: Yield Percentages Total Portfolio: By Investment Types U.S. Treasuries 100% Current Month Prior Month Firstlnterstate Bank 2 4 % Municipal Debt LGIP 6.5% 208% LGIP($50,400,000) Federal Agencies Bankers Acceptance Time Certificates 100% 100% 25% 50% FIB/LGIP Investments Averse 2.25% 2.18% 2.20% 2.25% 2.21% 2.26% Benchmarks Corporate 23s Municipal Debt Corporate Debt 25% 25% 24 Month Trees LGIP Rate 0.86% 2.25% Wei hted Ave Maturit 36 Month Treasury 0.85% Max 3.54 Years 0.90 Term Mininwm-,�— Actual Time Certificates 0 to 30 Days Under 1 Year 10% 25% 31.6% 64.0% Under 5 Years 100% 100.0% Federal Agencies 39.6% u. s. Treasuries 6 Other Policy Actual Corp Issuer 5% Callable 25% 4.2% 15.5% Credit W/A AA2 AA3 4.50% 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 Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb County Rate 2 Year Treasury Rate I Corporate Bond Rate � �>�LGIP Rate h h h h h h h h h h � 00 W 0� W 00 CO 00 CO CO W W 01 Ol Ql Ol Ol dl Ol Ol O'1 Ql Ol Ol O O 11 I 71 1-1 1-1 i-1 r-I rl N N 1 i 1ti N N T G b0 t? > U G ,a O N t0 N O- (6 7 -7i 7 N O O N f0 �U1 @ O- N 7 -7. N O O N t6 v a a o z O - <t 2 a n o z o 2¢ 2 a g o I o w Deschutes County Investments '. Purchases made in February 2019 Portfolio Management < Purchases made in February 2020 Portfolio Details - Investments February 29, 2020 Purchase Maturity Days To Ratings Coupon Par Market Book Inv#r Inv Tyr,-,, CUSIP Security Broke®' Date Date tl Matur I Mood SBPIFA Rats''. YfM34' Value Value Value 10673 MCI 89236TCFO Toyota Mtr Cred - Corp N CASTLE 12/12/2018 3/12/2020 11 Aa3 AA- 2.16 3.30067 2,000,000 2,000,240 1,999.316 10698 FAC 880591 EVO Tennessee Valley Authority CASTLE 4/25/2019 3/15/2020 14 Aaa 2.25 2.47396 3,000,000 3,000,960 2,999,742 10729 FAC 880591 EVO Tennessee Valley Authority CASTLE 11/29/2019 3/15/2020 14 Aaa 2.25 1.66043 5,000,000 5,001,600 5,001,208 10756 -:.AFD 912796TL3 -U.S. Treasury :.CASTLE 2/28/2020 " 3/19/2020 18 1.52 e1.56384 '.8,000,000 7,994,640 7,993,920 10655 TRC 912828J84 U.S. Treasury DA DAV 9/28/2018 3/31/2020 30 Aaa AA- 1,375 2.76 2,000,000 1,999,880 1,997,787 10606 MUN 13063CSQ4 California St VINISP 9/21/2017 4/1/2020 31 Aa3 AA- 1.8 1.79991 780,000 780,195 780,000 10695 MCI 06051GFN4 Bank of America Corp CASTLE 4/10/2019 4/21/2020 51 A2 A- 2.25 2.6737 1,600,000 1,501,020 1,499,134 10639 FAC 3137EAEM7 Federal Home Loan Mtg Corp CASTLE 4/19/2018 4/23/2020 53 Aaa AA+ 2.5 2.5112 2,000,000 2,002,840 1,999,968 10688 MCI 037833BE9 Apple Inc CASTLE 1/15/2019 5/6/2020 66 Aal AA+ 2.2046 2.40792 2,000,000 2,001,260 2,000,636 10746 AFD 912833KZ2 U.S. Treasury CASTLE 1/24/2020 5/15/2020 75 1.5643 1.57183 4,000,000 3,990,240 3,987,143 10597 FAC 3134GBNK4 Federal Home Loan Mtg Corp CASTLE 7/13/2017 5/29/2020 89 Aaa AA+ 1.625 1.67124 3,000,000 3,001,260 3,000,000 10664 MUN 7366881-02 Portland Community College PJ 11/27/2018 6/1/2020 92 Aal AA+ 3.126 3.126 515,000 517,302 515,000 10690 MCI 740189AL9 Precision Castparts Corp ` CASTLE 2/19/2019 :6/15/2020 106 A2 :' AA- 2.25 2.80011 1,000,000 1,001,430 998,447 10479 MUN 686053DH9 Oregon School Boards Assoc DA DAV 11/2/2015 6/30/2020 121 Aa2 AA 5.373 2.05005 875,000 886,463 884,120 10523 MUN 686053DH9 Oregon School Boards Assoc CASTLE 6/24/2016 6/30/2020 121 Aa2 AA 5.373 1.67009 500,000 506,550 506,068 10580 ACB 686053CK3 Oregon School Boards Assoc CASTLE 3/15/2017 6/30/2020 121 Aa2 A+ 2.0626 2.14874 1,000,000 995,010 993,162 10699 MUN 569203MA7 Salem-Keizer School District CASTLE 7/26/2017 6/30/2020 121 Aa2 2.107 1.77835 2,310,000 2,315,891 2,312,420 10715 AFD 76116FAD9 RFSCP STRIP PRIN MORETN 10/3/2019 7/15/2020 136 1.8011 1.85283 3,000,000 2,985,810 2,957,075 10572 MCI 94974BGM6 Wells Fargo Corporate Note PJ 1/19/2017 7/22/2020 143 A2 A- 2.6 2.35002 1,000,000 1,003,640 1,000.934 10691 ::MCI 94974BGM6 Wells Fargo Corporate Note CASTLE 2/22/2019 7/22/2020 143 A2 A- 2.6 2.9402 1,000,000 1,003,640 998,701: 10676 MCI 90331HNW9 U S Bank - Corp Note CASTLE 12/18/2018 7/24/2020 145 Al AA- 2.0509 2.6509 1,500,000 1,501,080 1,499,114 10680 FAC 313OA5777 Federal Home Loan Bank MORETN 12/21/2018 7/29/2020 150 Aaa AA+ 1.83 2.69091 2,000,000 2,004,860 1,993,112 10717 AFD 912803AU7 U.S. Treasury CASTLE 10/18/2019 8/15/2020 167 1.6379 1.68377 4,000,000 3,979,240 3,945,040 10742 MCI 89236TFK6 Toyota Mtr Cred - Corp N CASTLE 12/17/2019 8/21/2020 173 Aa3 AA- 2.0446 1.92219 3,000,000 3,001,830 3,001,714 10656 TRC 9128284Y3 U.S. Treasury MORETN 9/28/2018 8/31/2020 183 Aaa AA+ 2.625 2.81769 2,000,000 2,012,660 1,998,129 10633 MCI 053015AD5 AUTOMATIC DATA CASTLE 2/26/2018 9/15/2020 198 Aa3 AA 2.25 2.57022 2,710,000 2,720,461 2,705,498 10653 TRC 9128281-65 U.S. Treasury CASTLE 9/17/2018 9/30/2020 213 Aaa AA+ 1.375 2.75127 2,000,000 2,001,400 1,984,512 10573 MUN 940093R25 Washington Univ Higher Ed PJ 1/19/2017 10/1/2020 214 Aa3 A+ 5.93 1.97016 400,000 410.268 408,867 10629 MCI 45905U7J7 International Bonds for Recons CASTLE 2/9/2018 10/5/2020 218 Aaa AAA 2 2.47077 2,000,000 2,009,220 1,992,658 10659 MCI 45905U7J7 International Bonds for Recons CASTLE 10/26/2018 10/5/2020 218 Aaa AAA 2 3.07153 820,000 823,780 814,565 10703 MCI 45905U7J7 International Bonds for Recons CASTLE 6/26/2019 10/5/2020 218 Aaa AAA 2 1.99991 750,000 763,458 750,000 10657 AFD 76116FAE7 RFSCP STRIP PRIN CASTLE 10/4/2018 10/16/2020 228 2.764 2.95083 2,445,000 2,424,071 2,402,199 10714 MCI 46625HHU7 JPMorgan Chase - Corporate N CASTLE 9/20/2019 10/15/2020 228 A2 A- 4.25 2.05949 3,000,000 3,048,540 3,040,215 10747 AFD 76116FAE7 RFSCP STRIP PRIN CASTLE 1/29/2020 10/15/2020 228 1.6269 1.68812 5,000.000 4,957,200 4,948,481 10548 MUN 492244DV7 Kem Community College CASTLE 11/15/2016 11/1/2020 245 AA- 2.893 1.80006 500,000 505,060 503,501 10689 ::MUN I544587C30 LOS ANGELES MUNI IMP CASTLE 2/11/2019 .11/112020 245 '. AA- 3.146 2.87227 i.2,310,000 : 2,341,508 2,314,060: 10617 FAC 3134GBX56 Federal Home Loan Mtg Corp CASTLE 12/13/2017 11/24/2020 268 Aaa AA, 2.25 2.17233 3,000.000 3,021,600 3,000,000 10719 MCI 0605 iGEE5 Bank cf America Corp CASTLE 10/22/2019 1/5/2021 31.1 A2 ., 5.875 1.8832 2,000,000 2,071,440 2,066,304 10745 MCI 94988J5M5 Wells Fargo Corporate Note CASTLE 1/9/2020 1/15/2021 320 Aa2 A+ 2.1413 1.9249 3,000,000 3,006,480 3,006,452 10725 MUN 73209MAC1 POMONA CALIF REDEV AGY PJ 11/22/2019 2/1/2021 337 A+ 3,406 1.80021 1,300,000 1,325,350 1,318,830 10735 MCI 90331 HPA5 US Bancorp PJ 12/6/2019 2/4/2021 340 Al AA- 3 1.85045 2,000,000 2.025.420 2,020,920 10722 FAC 880591EL2 Tennessee Valley Authority CASTLE 11/5/2019 2/15/2021 351 Aaa AA+ 3.875 1.64993 2.000,000 2,053,040 2,041,878 10739 AFD 912833LC2 U.S. Treasury CASTLE 12/11/2019 2/15/2021 351 1.6475 1.69748 3,000,000 2,969,820 2,940,690 10740 AFD 912833LC2 U.S. Treasury CASTLE 12/13/2019 2/15/2021 351 1.6476 1.69757 2,000,000 1,979,880 1,960,640 10687 VR2 89236TEV3 Toyota Mtr Cred - Corp N CASTLE 1/9/2019 4/13/2021 408 Aa3 AA- 2.128 2,717 2000000 2002840 1993904.23 10702 VR2 06051GFV6 Bank of America Corp CASTLE 5/31/2019 44305 414 Aaa A- 3.2391 3.33397 1,050,000 1,065,614 1,063,205 10706 MUN 801577NR4 SANTA CLARA CNN CALIF FING CASTLE 7/2/2019 5/1/2021 426 AA+ 2.05 2.26338 1,095.000 1,104,570 1,094,791 10700 MCI 06051GEH8 Bank of America Corp CASTLE 5/9/2019 5/13/2021 438 A2 A- 5 2.70027 1,560,000 1,624,444 1,601,627 10741 TRC 9128286V7 U.S. Treasury CASTLE 12/13/2019 5/31/2021 456 2.125 1.70172 5,000,000 5,067,600 5,025,970 10728 MCI 46625HRT9 JPMorgan Chase - Corporate N CASTLE 11/29/2019 6/7/2021 463 A2 A- 2.4 1.92038 3,000.000 3,031,020 3,016,925 10738 MCI 46625HRT9 JPMorgan Chase - Corporate N DA DAV 12/10/2019 6/7/2021 463 A2 A- 2.4 1.95567 2,000,000 2,020.680 2,011,039 10667 MCI 695114CMB Pacific Corp CASTLE 11/29/2018 6/15/2021 471 Al A+ 3.85 3.35022 1,170,000 1,197,039 1,177,159 10672 MCI 695114CMB Pacific Corp CASTLE 12/6/2018 6/15/2021 471 Al A+ 3.85 3.35091 830,000 849,181 835,076 10692 :MCI 695114CM8 Pacific Corp CASTLE 2/22/2019 ,`6/15/2021 `; 471 Al A+ 3.85 2.85033 2,000,000 2,046,220 2,022,170: 10708 FAC 3133EKVC7 Federal Farm Credit Bank CASTLE 7/29/2019 7/19/2021 505 Aaa AA+ 1.875 1.87488 3,000,000 3,039,270 3,000,000 10721 TRC 9128287171 U.S. Treasury CASTLE 10/31/2019 7/31/2021 517 1.75 1.63127 5,000,000 5,053,300 5,008,217 10705 MUN 797398DK7 SAN DIEGO CNTY CALIF PENSIC CASTLE 7/1/2019 8/15/2021 532 AA2 AAA 5.835 2.00045 2,000,000 2,134,420 2,108,723 10737 FAC 313OA94N8 Federal Home Loan Bank CASTLE 12/9/2019 8/25/2021 542 Aaa AA+ 1.7 1.71436 5,000,000 6,003,400 4,998,916 10696 AFD 88059E4M3 Tennessee Valley Authority CASTLE 4/18/2019 9/15/2021 563 2.3733 2.53553 1,020,000 1,000,039 982,141 10648 MCI 45905UC36 International Bonds for Recons CASTLE 7/16/2018 9/28/2021 576 Aaa AAA 2 2.96688 2,000,000 1,941,400 1,971,158 10731 MCI 9498BJ5TO Wells Fargo Corporate Note CASTLE 12/5/2019 10/22/2021 600 Aa2 A+ 3.625 1.94977 2,000,000 2,065,860 2,053,723 10724 FAC 3130AHJYO Federal Home Loan Bank CASTLE 11/8/2019 11/19/2021 628 1.625 1.71093 3,000,000 3,035,040 2,995.663 10744 FAC 3130AHSR5 Federal Home Loan Bank CASTLE 12/20/2019 12/20/2021 659 1.625 1.68014 3,000,000 3,035,550 2,997,080 10732 MCI 46625HJD3 JPMorgan Chase - Corporate N PJ 12/6/2019 1/24/2022 694 A2 A- 4.5 2.01005 2,000,000 2,107,940 2,091.992 10654 MCI 695114CP1 Pacific Corp CASTLE 9/25/2018 2/1/2022 702 Al A+ 2.95 3,32016 700,000 718,634 695.326 10726 FAC 3133EKCYO Federal Farm Credit Bank CASTLE 11/21/2019 3/14/2022 743 Aaa AA+ 1.95 1.84902 5,000,000 5,022.250 5,008,800 10730 FAC 3133EKCYO Federal Farm Credit Bank CASTLE 11/29/2019 3/14/2022 743 Aaa AA+ 1.95 1.83828 5,000,000 5,022,250 5,009,742 10720 MCI 90520EAH4 MUFG Union Bank CASTLE 10/25/2019 4/1/2022 761 Aaa A 3.15 2.03755 2,000,000 2,062,740 2,044,983 '10750 '::MCI `<90520EAH4. MUFG Union Bank CASTLE 2/5/2020 4/1/2022 761 Aaa :" A 3.15.'1.81145 `:1,000,000 '. 1,031,370 1,027,214 '10749 .`FAC 3133ELLW2 Federal Farm Credit Bank DA DAV 215/2020 ' 5/5/2022 795 ' 1.61 1.62173 1,000,000 1,000,280 999,758 10733 MCI 084664BT7 Berkshire Hathaway Inc MORETN 12/6/2019 5/15/2022 805 Aa2 AA 3 1.74 2,000,000 2,068,480 2,054,173 10736 FAC 3133ELCH5 Federal Farm Credit Bank PJ 12/5/2019 6/2/2022 823 1.7 1.71644 2,000,000 2,002,100 1,999,277 10652 MUN 686053BQ1 Oregon School Boards Assoc MORETN 9/14/2018 6/30/2022 851 Aa2 AA 5.48 3.12 925,000 1,014,790 972,599 10748 FAC 3133EKJ56 Federal Farm Credit Bank CASTLE 1/31/2020 8/30/2022 912 Aaa AA+ 1.9 1.30349 3,000,000 3,010,380 3,012,574 10727 MCI 06051GEU9 Bank ofAmenca Corp CASTLE 11/25/2019 1/11/2023 1046 A2 A-1 3.3 2.12008 2,000,000 2,098,320 2,064,965 10751 FAC 3130AJ5Q8 S Federal Home Loan Bank `DA DAV 2/18/2020 :2/14/2023 ":1080 Aaa -. AA+ 1.75 1.74997 2,000,000 2,001.100-2,000,000 '10753 FAC ' 3135GO>09 Federal National Mtg Assn CASTLE 2124/2020 2/14/2023 "1080 Aaa AA+ 1.7 1.69993 :4,000,000 4,008,640 '4,000,000 10709 MUN 2927OCNU5 BonneVIle Power Administratio CASTLE 7/30/2019 7/1/2023 1217 Aal AA- 5.803 2.12492 1,000,000 1,147,500 1,117,023 10713 MCI 361582ADI Berkshire Hathaway Inc CASTLE 9/9/2019 7/15/2023 1231 Aa3 AA 7.35 2.03065 500,000 592,220 585,838 10754 ( FAC 3134GVEG9.Federal Home Loan Mtg Corp : R W B 2/28/2020 2/28/2024 c1459 1.625 1:1.625 :.4,000,000 , 4,003,880 4,000,000 10752 ` FAC 3135GOY23 Federal National Mtg Assn CASTLE 2/18/2020 2/18/2026 1815 AA+ 1.9 ' 1.9 ` '2,000,000 2,003,380 2,000,000 10078 RRP SYS 10078 Local GoA Imestment Pool 7/1/2006 - - 1 2.75 2.75 49,518,473 49.518,473 49,518,473 10084 RR2 SYS10084 First Interstate 7/1/2006 - - 1 2.75 2.75 5,839,223 5,839,223 5.839,223 238,422,696 240,028,971 239,081,605 Doe Licensing We've began taking dog license renewals through a new on-line system with the intent of moving to an automated process. Over 40 licenses have been renewed on-line already in five days since the first round of renewal notifications were sent. In the near future we will transition new license requests to on-line. This will provide an opportunity for our customers and staff to save time in this important public service. Tax Tax staff are now providing tax turnover statements on-line for our taxing districts. This eliminates the need to sort and distribute paper and email statements, saving staff time and provides our taxing districts the ability to retrieve current tax turnover statements faster and historic statements from our website. Budget to Actuals Report Revenue YTD in the General Fund is 94.5% of budget at $34 million, an increase of $2.4 million (7.7%) from last year which was at 92.8% of budget for the same time period last year. Expenses YTD are 62.5% of budget at $23.5 million compared to $21.8 million and 61.5% of budget last year. Expenses YTD are $1.4 million more (7.3%) than the same time period last year. County Wide Financial Dashboard 001 - General Fund 8 66.7% Year Complete Fund Select All ;Plank 00 i - G-n"M Fund 0 0 - Assmt Clerk.. UZU -Cede Al-ie... 039 - Ccn:rnmity ... 040 - Coa, t C gin... 950 - Ecanarn;< D... 050 070 Cou... 090 - P; ojec[ Dev... LU -Law Library 130 - Park Accluio - 73L - Pad: De -in. Monthly GL Penod $9.6M (Blank) Budget to Actuals Requirements Resources Beginning Working Capital Budget to Actuals by Category terp t;aL< ®B,Age. =;:: P,q ction $La�t A —AS ®GIrre IT'mar Actuals fv But, i2t �3a'lFM . )Pro [cbni 107.66 VAU,NT aO',� LED 90.2Y is 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 February 29, 2020. Position Control Summary July - June Percent Org Jul Aug Sep Oct Nov Dec January February Unfilled Assessor Filled 34.26 34.26 34.26 34.26 34.26 34.26 34.26 33.26 Unfilled 1.00 1.00 1.00 1.00 1.00 1.00 1.00 2.00 3.19% Clerk Filled 8.48 8.48 8.48 8.48 8.48 8.48 8.48 8.48 Unfilled - - - - - - - 0.00% BOPTA Filled 0.52 0.52 0.52 0.52 0.52 0.52 0.52 0.52 Unfilled - - - - - 0.00% DA Filled 49.95 49.95 49.95 51.95 50.95 51.75� 51.75 50.60 Unfilled 2.00 2.00 2.00 - 1.00 1.00 1.45 2.50 2.85% Tax Filled 4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50 Unfilled - - - - - - - 0.00% Veterans' Filled 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 Unfilled - - - - - - 0.00% PropertyMngt Filled 1.80 1.80 1.80 1.80 1.80 1.80 1.80 0.80 Unfilled - - 1.00 6.94% Total General Fund Filled 103.51 103.51 103.51 105.51 104.51 105.31 105.31 102.16 Unfilled 3.00 3.00 3.00 1.00 2.00 2.00 2.45 5.50 2.57% Justice Court Filled 4.60 4.60 4.60 4.60 3.60 3.60 4.60 4.60 Unfilled - - - - 1.00 1.00 - 5.43% Community Justice Filled 46.90 47.20 47.20 47.90 47.90 47.90 47.90 47.90 Unfilled 1.00 0.70 0.70 - - - - 0.63% Sheriff Filled 221.75 221.75 224.75 220.75 223.75 224.75 223.75 218.75 Unfilled 18.75 18.75 15.75 19.75 16.75 15.75 16.75 21.75 7.48% Health5rvcs Filled 284.55 286.65 291.20 293.95 291.95 293.30 294.10 293.35 Unfilled 20.35 18.25 18.70 16.95 18.75 17.40 17.05 17.80 5.87% COD Filled 53.00 54.00 54.00 56.00 55.00 55.00 56.00 55.00 Unfilled 3.00 2.00 2.00 2.00 3.00 3.00 2.00 3.00 4.37% Road Filled S5.00 55.00 56.00 55.00 54.00 55.00 55.00 54.00 Unfilled 1.00 1.00 1.00 2.00 1.00 1.00 2.00 2.01% Adult P&P Filled 37.85 38.55 39.55 38.85 38.85 39.85 39.85 39.60 Unfilled 2.00 1.30 0.30 1.00 1.00 - - 0.25 1.84% Solid Waste Filled 24.00 24.00 24.00 23.00 23.00 23.00 23.00 23.00 Unfilled 0.50 0.50 0.50 1.50 1.50 1.50 1.50 1.50 4.59% 9-1-1 Filled 55.52 53.53 56.53 56.53 56.53 55.53 53.00 53.00 Unfilled 4.48 6.48 3.48 3.48 3.48 4.48 7.00 7.00 8.31% Victims Assistance Filled 7.00 7.00 7.00 8.00 8.00 8.00 8.00 8.00 Unfilled 1.00 1.00 1.00 - - - - 4.69% GIS Dedicated Filled 1.30 1.30 1.30 2.30 2.30 2.30 2.30 2.30 Unfilled 1.00 1.00 1.00 - - - - - 16.30% Fair & Expo Filled 12.00 11.00 11.00 11.00 11.00 11.00 11.00 12.00 Unfilled - 1.00 1.00 1.00 1.00 1.00 1.00 - 6.25% Natural Resource Filled 1.00 1.00 1.00 1.00 1.00 1.00 2.00 2.00 Unfilled - - - 1.00 1.00 1.00 - - 23.08% ISF - Facilities Filled 19.00 19.00 19.00 19.00 19.00 20.00 20.00 20.00 Unfilled 6.00 6.00 6.00 6.00 6.00 5.00 5.00 5.00 22.50% ISF - Admin Filled 5.75 5.75 5.75 6.75 6.75 6.75 7.75 7.75 Unfilled 1.00 1.00 2.00 1.00 1.00 1.00 - - 11.67% ISF - BOCC Filled 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Unfilled - - - - - - - - 0.00% ISF- Finance Filled 10.00 10.00 10.00 10.00 10.00 10.00 9.00 10.00 Unfilled - - - - - - 1.00 1.25% ISF - legal Filled 6.00 6.00 7.00 7.00 7.00 7.00 7.00 7.00 Unfilled 1.00 1.00 - - - - - - 3.57% ISF - HR Filled 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 Unfilled - - - - - - - - 0.00% ISF - IT Filled 14.70 14.70 14.70 14.70 15.70 15.70 15.70 15.70 Unfilled 1.00 1.00 1.00 1.00 - - - - 3.18% ISF - Risk Filled 2.25 2.25 2.25 2.25 2.25 2.25 2.25 2.25 Unfilled 1.00 1.00 - - - - - 10.00% July - June Percent Jul Aug Sep Oct Nov Dec January February Unfilled Total: Filled 976.68 977.79 991.34 995.09 993.09 998.24 998.51 989.36 Unfilled 66.08 64.98 56.43 56.68 58.48 54.13 54.75 63.80 % Unfilled 6.34% 6.23% 5.39% 5.39% 5.56% 5.14% 5.20% 6.06% 5.66% �SEsC-�< 0 Budget to Actuals - Countywide Summary C� All Departments 66.7% FY20 YTD February 29, 2020 (unaudited) Year Complete Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % projection % 001 - General Fund 33,938,668 34,900,450 103% ; 35,779,922 33,918,691 95% ; 37,114,851 104% ; 030 - Juvenile 7863286 842,485 107% ; 856,930 482,883 56% 894,319 104% ; 160/170 - TRT 7,282,600 7,682,623 105% ; 7,732,000 6,811,435 88% 8,503,715 110% ; 220 - Justice Court 552,000 608,275 110% ; 578,000 378,812 66% 602,500 104% ; 255 - Sheriff's Office 39,225,869 40,517,859 103% ; 41,581,807 39,935,983 96% ; 42,558,394 102% ; 274 - Health Services ; 35,444,454 37,595,739 106% ; 35,498,170 21,640,782 61% ; 35,644,454 100% ; 295 - CDD 8,153,746 7,755,886 95% 8,468,820 5,076,552 60% 8,232,790 97% ; 325 - Road 22,876,423 23,035,209 101% ; 22,785,827 15,275,793 67% ; 23,271,418 102% ; 355 - Adult P&P 6,360,818 6,463,769 102% ; 5,775,278 4,742,223 82% 6,304,300 109% ; 465 - Road CIP 959,104 261,131 27% ; 2,142,893 1,419,066 66% ; 2,248,612 105% ; 610 - Solid Waste 11,868,613 11,504,244 97% ; 11,724,869 7,965,318 68% ; 11,820,073 101% ; 615 - Fair & Expo 1,499,100 1,589,820 106% ; 1,561,500 749,879 48% 1,416,000 91% ; 618 - RV Park 358,600 488,620 136% ; 437,700 320,617 73% 498,182 114% ; 670 - Risk Management 3,569,944 3,477,056 97% 3,495,039 2,853,647 82% ; 3,887,039 111% ; 675 - Health Benefits 21,411,563 22,699,675 106% ; 22,318,433 14,415,614 65% 21,849,823 98% ; 705 - 911 10,260,013 10,514,313 102% ; 10,563,350 9,534,474 90% 10,832,898 103% ; 999 - Other 363330,641 38,687,048 106% ; 31,222,790 24,599,196 79% 31,421,450 101% ; TOTAL RESOURCES 240,878,442 2489624,202 103% ; 242,523,328 190,120,965 78% 247,100,817 102%: Fiscal Year 2019 Fiscal Year 2020 REQUIREMENTS Budget Actuals % Budget Actuals % Projection % 001 - General Fund 17,486,029 16,406,076 94% 18,283,076 11,433,655 63% 17,996,608 98% ; 030 - Juvenile 7,040,903 6,638,892 94% 7,127,337 4,594,694 64% ; 7,010,494 98% ; 160/170 - TRT 2,335,678 2,233,953 96% 2,212,140 1,807,603 82% 2,407,140 109% ; 220 - Justice Court 658,081 652,039 99% ; 678,141 457,332 67% 663,778 98% ; 255 - Sheriffs Office 42,853,022 41,553,897 97% 44,685,809 29,608,617 66% ; 44,943,737 101% ; 274 - Health Services 44,974,364 42,441,390 94% 47,434,470 26,927,107 57% 44,725,546 94% ; 295 - CDD 7,726,157 7,331,793 95% 7,905,639 4,949,068 63% ; 7,485,003 95% ; 325 - Road 14,689,753 12,158,904 83% 14,573,336 7,802,725 54% ; 13,770,676 94% ; 355 - Adult P&P 6,505,128 6,208,673 95% 6,589,491 4,285,600 65% 6,566,680 100% ; 465 - Road CIP 8,309,501 5,484,366 66% ; 13,835,913 2,950,838 21% 7,245,847 52% ; L� O uTESCG-� Budget to Actuals h - Countywide Summary o All Departments 66.7% FY20 YTD February 29, 2020 (unaudited) Year Complete 610 - Solid Waste 8,310,720 7,643,635 92% ; 8,384,039 4,312,863 51% 8,121,843 97% ; 615 - Fair & Expo 2,688,885 2,789,095 104% ; 2,464,787 1,667,934 68% 2,590,249 105% ; 618 - RV Park 521,971 499,108 96% ; 540,373 353,776 65% 501,391 93% ; 670 - Risk Management 3,858,097 2,862,764 74% 4,132,295 1,826,394 44% 3,814,059 92% ; 675 - Health Benefits 23,144,255 21,211,086 92% ; 22,115,011 13,215,304 60% ; 23,405,885 106% ; 705 - 911 ; 13,379,064 10,570,113 79% 12,250,336 7,169,767 59% 11,765,045 96% ; 999 - Other 46,792,062 35,262,851 75% ; 60,808,382 23,964,592 39% ; 60,568,085 100% ; TOTAL REQUIREMENTS 251,273,671 221,948,635 88% 274,020,575 147,327,869 54% 263,582,066 96% ; Fiscal Year 2019 Fiscal Year 2020 TRANSFERS Budget Actuals % Budget Actuats % Projection % 001 - General Fund (18,077,559) (18,091,539) 100% ; (19,023,310) (11,921,496) 63% (19,023,310) 100% ; 030 - Juvenile 5,744,015 5,744,015 100% ; 5,874,465 3,930,804 67% 5,874,465 100%: 160/170 - TRT (4,649,866) (4,449,866) 96% (4,133,128) (2,596,140) 63% (4,133,128) 100%: 220 - Justice Court 30,000 30,000 100%- 255 - Sheriffs Office 2,981,253 2,981,254 100% ; 3,119,936 2,187,111 70% 3,119,936 100%: 274 - Health Services 6,177,535 6,179,204 100% ; 6,102,365 3,734,718 61% ; 5,866,442 96% ; L`J5-�uu n 62A\ (1,1.7L,VL4� /A A7n A7lfl ,1,1IV,11La An70/ IVL/0 /A AAO flOA\ ,I,YYV,VVIa /77A /\R7\ aILY,VVLa Cfl0/ JV/0 /A A26 076) �I,7LV,VIVa 99% JJ/Y 325 - Road (14,464,308) (14,464,308) 100% ; (11,910,575) (6,612,088) 56% ; ; (11,910,575) 100% ; 355 - Adult P&P 165,189 165,189 100% ; 223,189 159,120 71% 223,189 100% ; 465 - Road CIP 13,811,725 13,393,963 97% ; 12,014,914 5,298,487 44% ; 11,893,453 99% ; 610 - Solid Waste (4,688,023) (5,000,029) 107% ; (3,296,192) (1,616,182) 49% ; (3,296,192) 100% ; 615 - Fair & Expo 1,220,994 1,164,996 95% ; 1,022,863 601,548 59% 877,863 86%O ; 618 - RV Park 160,000 160,000 100% ; (307,000) (73,500) 24% (307,000) 100% ; 670 - Risk Management (3,168) (3,168) 100%: (6,918) (3,458) 50% (6,918) 100%: 705-911 - - - - 999 - Other 12,744,837 13,360,461 105% ; 11,767,472 7,635,108 65% ; 12,248,651 104% ; TOTAL TRANSFERS - - - - ; �- °Z Budget to Actuals - Countywide Summary o���, All Departments 66 7% FY20 YTD February 29, 2020 (unaudited) Year Complete Fiscal Year 2019 Fiscal Year 2020 ENDING FUND BALANCE Budget Actuals % Budget Actuals Projection % 001 - General Fund 9,265,080 12,349,379 133% ; 9,563,536 22,912,919 12,444,312 130% ; 030 - Juvenile 689,399 1,296,490 188% ; 694,058 1,115,483 1,054,780 152% ; 160/170 - TRT 2,261,401 2,565,255 113% ; 3,686,732 4,972,947 4,528,702 123% ; 220 - Justice Court 67,919 144,227 212% ; 64,859 65,706 82,949 128% ; 255 - Sheriff's Office 13,191,907 16,818,660 127% ; 14,732,933 29,333,137 ; 17,553,253 119% ; 274 - Health Services 3,850,339 10,638,105 276% ; 4,286,868 9,086,498 7,423,455 173% ; 295 - CDD 1,478,676 1,783,536 121% ; 1,097,104 1,186,988 1,104,447 101% ; 325 - Road 2,416,014 6,726,840 278% ; 2,303,905 7,587,820 4,317,007 187% ; 355 - Adult P&P 2,220,879 2,754,005 124% ; 1,998,976 3,369,749 2,714,814 136% ; 465 - Road CIP 14,148,365 17,759,555 126% ; 15,938,430 21,526,269 24,655,773 155% ; 610 - Solid Waste 600,000 799,570 133% ; 644,638 2,835,843 1,201,608 186% ; 615 - Fair & Expo 31,209 (94,564) -303%; 199,576 (411,071) ; (390,950) -196%; 618 - RV Park 315,629 592,992 188% ; 150,327 486,333 282,783 188% ; 670 - Risk Management 5,308,679 7,193,407 136% ; 5,455,826 8,217,203 7,259,469 133% ; 675 - Health Benefits 14,318,894 16,563,905 116% ; 16,309,716 17,764,216 15,007,843 92% ; 7n,; - Qi 1 5.505,949 8,604,816 156% ' 6,066,720 10,969,523 7,672,668 126% ; 999 - Other 58,869,933 75,223,189 128% ; 55,033,130 83,492,901 ; 58,325,204 106% ; TOTAL FUND BALANCE 134,540,271 181,719,367 135% ; 1385227,334 224,512,464 165,238,117 120% ; a ,o�`:�{ Budget to Actuals Report C� General Fund - Fund 001 FY20 YTD February 29, 2020 (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 TRANSFERS Transfers In Transfers Out TOTAL TRANSFERS 66.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance 27,318,385 27,774,133 102% , 29,046,840 28,169,487 97% 29,256,769 101% 209,929, A 389,000 433,798 112% 391,000 868,834 222% 950,000 243% 559,000! B 2,685,500 3,272,354 122% 3,020,400 2,250,316 75% 3,161,400 105% 141,000� C 870,658 823,127 95% 837,283 705,613 84% 837,283 100%, D 1,787,270 1,702,762 95% 1,597,369 1,398,906 88% 2,022,369 127% ! 425,000. E 12,700 12,119 95% 12,220 10,420 85% 12,220 100%: D 389,782 386,919 99% 383,806 216,662 56% 383,806 100% 198,950 206,292 104% 195,390 193,508 99% 195,390 100%: D 166,423 168,945 102% 175,614 89,307 51% 175,614 100%: - F 120,000 1209000 100% 120,000 15,638 13% 120,000 100%: G 33,938,668 34,900,450 103% ; 35,779,922 33,918,691 95% ; 37,114,851 104% ; 1,334,929: Budget Actuals % Budget Actuals % 4,802,452 4,530,558 94% 4,993,290 3,166,057 63% 1,854,397 1,598,764 86% 2,031,590 1,012,178 50% 73,125 69,565 95% 77,950 48,794 63% 7,372,932 6,993,244 95% 7,873,159 5,031,251 64% 173,129 160,296 93% 235,542 115,040 49% 872,020 779,330 89% t 846,307 591,527 70% 572,287 539,026 94% 589,551 350,761 59% 287,858 278,966 97% 281,985 220,127 78% 1,477,829 1,456,326 99% 1,353,702 897,921 66% 17,486,029 16,406,076 94% ; 18,283,076 11,433,655 63% ; Projection % $ Variance 4,864,959 97% 128,331, H 1,964,960 97% 66,630! H 77,497 99% 453- 7,746,459 98% 126,700! H 235,542 100%! - 851,607 101% (5,300)" 590,239 100% (688) 311,643 111% (29,658); 1 1,353,702 100%, 17,996,608 98% ; 286,463: Budget Actuals % Budget Actuals % Projection % $ Variance 326,122 289,065 89% 260,000 130,000 50% 260,000 100% J (18,403,681) (18,380,604) 100% (19,283,310) (12,051,496) 62% (19,283,310) 100% (18,077,559) (18,091,539) 100% ; (19,023,310) (11,921,496) 63% (19,023,310) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 10,890,000 11,946,544 110% 11,090,000 12,349,379 111% 12,349,379 111% 1,259,379� Resources over Requirements 16,452,639 18,494,374 17,496,846 22,485,036 19,118,243 1,621,39T Net Transfers - In (Out) ! (18,077,559) (18,091,539) (19,023,310) (11,921,496) (19,023,310) 04 TOTAL FUND BALANCE $ 9,265,080 $ 12,349,379 133% ; $ 9,563,536 $ 22,912,919 240% ; ; $ 12,444,312 130% ; $2,880,776: A Current year taxes received primarily in November, February and May; actual 19-20 TAV is a 5.36% increase compared to FY 18-19 vs. 5.5% budgeted; however, collection rate is projected to be 95.8% versus 95% budgeted. B TDS Baja deferred billing credits per ORS 305.286 in addition to settlement payment C PILT payment of $500,000 received in July. Includes $112,566 of Marijuana tax YTD; interest projection based on current investment rate and anticipated cash balances D A & T Grant received quarterly. Q1 - July; Q2 - October; Q3 - January; Q4 - April. E Recording fees are up 45% YTD compared to the prior year. F Oregon Dept. of Veteran's Affairs grant reimbursed quarterly. G Interfund land -sale management revenue recorded at year-end. H Savings related to FTE vacancies YTD and forecasted vacancy rates consistent with YTD experience. I Retirement payout not anticipated when the budget was developed j Repayment to General Fund from Finance Reserves for ERP Implementation o� CO Budget to Actuals Report Juvenile - Fund 030 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals %° Budget Actuals % Projection % $ Variance OYA Basic & Diversion 407,113 413,320 102% 442,601 189,167 43% 442,601 100% A ODE Juvenile Crime Prev 91,379 92,492 101% 91,379 42,120 46% 91,379 100% A Leases 85,000 87,311 103% 86,400 59,551 69% 95,000 110% 8,600! B Inmate/Prisoner Housing 70,000 97,200 139% 80,000 78,600 98% 110,000 138% 30,000, C DOC Unif Crime Fee/HB2712 35,000 43,681 125% 35,000 49,339 141% 49,339 141% 14,339 D Interest on Investments 25,000 31,318 125% 31,000 19,627 63% 29,000 94% (2,000)l E OJD Court Fac/Sec SB 1065 17,000 27,158 160% 26,000 15,236 59% 26,000 100% Gen Fund -Crime Prevention 20,000 20,000 100% 20,000 10,000 50% 20,000 100% A Food Subsidy 18,744 12,052 64% 16,000 9,159 57% 12,000 75% (4,000)! F Miscellaneous 2,050 4,603 225% 14,050 3,194 23% 6,000 43% (8,050)' G Contract Payments 8,000 7,269 91% 8,000 3,725 47% 8,000 100% H Case Supervision Fee 7,000 6,081 87% 6,500 3,166 49% 5,000 77% (1,500)" 1 TOTAL RESOURCES ; 786,286 842,485 107% ; 856,930 482,883 56% ; 894,319 104% ; 37,389: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,705,245 5,412,349 95% 5,797,927 3,752,670 65% 5,670,494 98% 127,431 J Materials and Services 1,327,658 1,218,976 92% 1,329,410 842,024 63% 1,340,000 101% (10,590)! K Capital Outlay 8,000 7,566 95% -' TOTAL REQUIREMENTS ; 7,040,903 6,638,892 94% 7,127,337 4,594,694 64% 7,010,494 98% 116,843: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 5,831,015 5,831,015 100% 5,961,465 3,974,304 67% 5,961,465 100% < Transfers Out-Veh Reserve (87,000) (87,000) 100% (87,000) (43,500) 50% (87,000) 100% TOTAL TRANSFERS 5,744,015 5,744,015 100% ; 5,874,465 3,930,804 67% 5,874,465 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,200,000 1,348,881 112% 1,090,000 1,296,490 119% 1,296,490 119% 206,490: Resources over Requirements (6,254,617) (5,796,407) (6,270,407) (4,111,811) (6,116,175) 154,232 Net Transfers - In (Out) E 5,744,015 5,744,015 E 5,874,465 3,930,804 t t 5,874,465 4 0! i TOTAL FUND BALANCE $ 689,399 $ 1,296,490 188% ; $ 694,058 $ 1,115,483 161% ; ; $ 1,054,780 152% ; $360,722: A Quarterly Reimbursement B Projection based on YTD actuals. Leased a second office to J Bar J Youth Service. C Out of county juvenile detention housing. Fluctuates in accordance with other county policy/usage. Current YTD trend higher than budgeted. D Annual payment received from State Dept. of Corrections based on new state formula higher than budgeted E Interest projection based on current investment rate and anticipated cash balances F Projection based on YTD actuals. Less than anticipated qualifying juvenile detention meals. G Anticipated grant revenue from youth substance abuse research study lower than budgeted due to project start-up delays. H Payments for community service crew projects. Fluctuates depending on community need/request. Current YTD trend lower than budgeted; however, it is anticipated this revenue will be close to budget. I Projection based on YTD actuals j Projected Personnel savings based on YTD average vacancy rate of 0.6% K Projected based on YTD actuals. Higher electricity costs are driving overage C� �G �I ES `�� Budget to Actuals Report o� TRT - Fund 1601170 66.7% FY20 YTD February 29, 2020 (unaudited) Year Complete Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Room Taxes 7,260,000 7,618,179 105% 7,670,000 6,747,383 88% 8,428,715 110% 758,715� A Interest 22,600 64,444 285% 62,000 64,053 103% 75,000 121% 13,000! B TOTAL RESOURCES 7,282,600 7,682,623 105% ; 7,732,000 6,811,435 88% 8,503,715 110% ; 771,715: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance COVA 1,946,668 2,067,761 106% 2,064,221 1,717,774 83% 2,259,221 109% (195,000), C Interfund Contract 59,121 59,121 100% 79,160 52,773 67% 79,160 100%! D Interfund Charges 39,087 39,087 100% 37,309 24,873 67% 37,309 100% Auditing Services 12,501 10,800 86% 14,500 4,200 29% 14,500 100% Software 60,000 51,533 86% 10,350 5,600 54% 10,350 100% - Office Supplies 4,000 1,589 40% 3,000 509 17% 3,000 100%, Printing 2,200 209 9% 2,000 642 32% 2,000 100%! - Public Notices 3,101 1,834 59% 1,600 1,232 77% 1,600 100%, Temporary Help 9,000 2,020 22% Sunriver Service Dist 200,000 - 0% i - TOTAL REQUIREMENTS 2,335,678 2,233,953 96% ; 2,212,140 1,807,603 82% 2,407,140 109% ; (195,000); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer Out - RV Park (35,000) (17,500) 50% (35,000) 100% Transfer Out - Annual Fair (150,000) (150,000) 100% (250,000) (125,000) 50% (250,000) 100% Transfer Out - F&E Reserve (830,083) (630,083) 76% (286,687) (143,342) 50% (286,687) 100% Transfer Out - F&E (517,996) (517,996) 100 ° (409,654) (209,1 "14) 51 ° (409,654) 100% Transfer Out - Sheriff (3,151,787) (3,151,787) 100% F (3,151,787) (2,101,184) 67% (3,151,787) 100% TOTAL TRANSFERS ; (4,649,866) (4,449,866) 96% (4,133,128) (2,596,140) 63% (4,133,128) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,964,345 1,566,452 80% 2,300,000 2,565,255 112% 2,565,255 112% 265,255: Resources over Requirements 4,946,922 5,448,669 5,519,860 5,003,832 6,096,575 576,715! Net Transfers - In (Out) (4,649,866) (4,449,866) ! (4,133,128) (2,596,140) ` (4,133,128) 0! TOTAL FUND BALANCE $ 2,261,401 $ 2,565,255 113% ; $ 3,686,732 $ 4,972,947 135% ; ; $ 4,528,702 123% ; $841,970, A Prior year collections YTD was 83% of budget, compared to current year collections YTD of 88% B Includes interest payments from delinquent tax collections. C COVA is estimated to receive -27.5% of TRT revenue collected above budgeted amounts D Contracted services with the Finance Department for operating TRT program. I ES Budget to Actuals Report Justice Court - Fund 220 66.7% FY20 YTD February 29, 2020 (unaudited) Year Complete Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Court Fines & Fees 550,000 605,344 110% 575,000 377,385 66% 600,000 104% 25,000; Interest on Investments 2,000 2,931 147% 3,000 1,427 48% 2,500 83% (500)- TOTAL RESOURCES 552,000 608,275 110% 578,000 378,812 66% 602,500 104% 24,500: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 508,650 508,098 100% 516,868 359,835 70% 522,505 101% (5,637); A Materials and Services 149,431 143,941 96% 161,273 97,497 60% 141,273 88% 20,000 B TOTAL REQUIREMENTS 658,081 652,039 99% 678,141 457,332 67% 663,778 98% 14,363: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 30,000 30,000 100% TOTAL TRANSFERS 30,000 30,000 100% FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 144,000 157,990 110% 165,000 144,227 87% 144,227 87% (20,774)' Resources over Requirements (106,081) (43,764) (100,141) (78,520) (61,278) 38,861 Net Transfers - In (Out) 30,000 30,000 0! TOTAL FUND BALANCE $67,919 $144,227 212% $64,859 $65,706 101% $82,949 128% $18,090 A Proiected Personnel overage attributed to payout for terminated employee. Position currently vacant B Projection based on actuals to date and estimated spending through June 30, 2020 �1 E' S Budget to Actuals Report c Sheriffs Office - Fund 255 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance LED #1 Property Tax Current 24,780,245 25,153,487 102% 26,293,470 25,479,248 97% 26,432,672 101% 139,202: A LED #2 Property Tax Current 10,027,098 10,171,051 101% 10,632,014 10,285,915 97% 10,670,810 100% 38,796! A Sheriff's Office Revenues E 3,675,026 4,153,450 113% 3,922,323 2,894,298 74% 3,994,912 102% 72,589! B LED #1 Property Tax Prior 312,000 326,275 105% 312,000 674,355 216% 738,000 237% 426,000! C LED #2 Property Tax Prior 166,500 157,143 94% 148,000 293,744 198% 330,000 223% 182,000! C LED #1 Interest E 145,000 288,269 199% 138,000 194,967 141% 250,000 181% 112,000; D LED #2 Interest 120,000 193,301 161% E 136,000 113,456 83% E� 142,000 104% E i 6,000, D � LED #1 Foreclosed Properties E - 53,322 E Ei i - i LED #2 Foreclosed Properties E 21,561 - TOTAL RESOURCES 39,225,869 40,517,859 103% ; 41,581,807 39,935,983 96% 42,558,394 102% ; 976,587: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Sheriffs Services 2,997,984 3,068,683 102% 3,105,057 1,942,405 63% 3,060,906 99% 44,151� E Civil/Special Units 1,181,695 1,149,677 97% 1,232,158 835,182 68% 1,220,279 99% 11,879! Automotive/Communications 2,644,785 2,532,545 96% 2,858,337 1,874,029 66% 2,921,653 102% (63,316)! Detective 2,033,077 2,044,686 101% 2,303,072 1,489,180 65% 2,240,313 97% 62,759! Patrol 10,003,952 10,040,921 100% 10,592,002 7,716,891 73% 11,281,282 107% (689,280)l F Records 881,182 892,837 101% 1,004,600 522,711 52% 892,857 89% 111,743 Adult Jail E 18,357,098 17,364,464 95% 18,379,998 11,914,647 65% 18,225,997 99% 154,001! Court Security 551,494 531,409 96% 556,740 303,046 54% 461,521 83% 95,219! Emergency Services 328,581 341,586 104% 402,734 302,453 75% 445,181 111% (42,447)� Special Services 1,520,623 1,451,124 95% 1,601,871 1,154,890 72% EE 1,631,652 102% � (29,781) E E Training � 667,647 874,923 ir 7roA•,,,.l,.,-A. 589,Q�23 79 f 867,094 117% i (123 ,7L0); Crisis Stabilization Center 559,308 82,308 15% 571,267 56,178 10% 335,201 59% 236,066, Other Law Enforcement E 1,017,266 1,070,404 105% 1,330,214 804,233 60% 1,255,376 94% 74,838 Non - Departmental E 108,329 108,329 100%! 4,425 102,950 999% 104,425 999% (100,000) TOTAL REQUIREMENTS ; 42,853,022 41,553,897 97% ; 44,685,809 29,608,617 66% , 44,943,737 101% ; (257,928); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - TRT 3,151,787 3,151,787 100% 3,151,787 2,101,184 67% 3,1519787 100% Transfer In - General Fund E 103,132 103,132 100% 240,249 160,160 67% 240,249 100% Transfers Out - Debt Service (273,666) (273,666) 100% (272,100) (74,233) 27% (272,100) 100% TOTAL TRANSFERS 2,981,253 2,981,254 100% ; 3,119,936 2,187,111 70% 3,119,936 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 13,837,807 14,873,445 107% 14,716,999 16,818,660 114% 16,818,660 114% 2,101,661� Resources over Requirements (3,627,153) (1,036,039) (3,104,002) 10,327,366 (2,385,343) 718,659! Net Transfers - In (Out) 2,981,253 ( 2,981,254 3,119,936 E 2,187,111 3,119,936 0� t E f ! TOTAL FUND BALANCE $ 13,191,907 $ 16,818,660 127% ; $ 14,732,933 $ 29,333,137 199% ; ; $ 17,553,253 119% ; $2,820,320' A While 19-20 TAV was 0.14% lower vs budget, the collection rate is estimated at 95.8% vs. 95.0% in the budget B Projected to exceed budget due to additional SB 395 Prisoner Housing funds in Adult Jail C TDS Baja deferred billing credits per ORS 305.286 in addition to settlement payment D Interest projection based on current investment rate and anticipated cash balances E Variances in most Divisions are from projections based on YTD personnel and positions that are unfilled or over -filled F Variance due to over hiring for open and soon -to -be open positions; up to 18-months of lead time is necessary for background and training. Though temporary, the forecast assumes the trend continues for the remainder of the year. �IES` 2{ Budget to Actuals Report Health Services - Fund 274 FY20 YTD February 29, 2020 (unaudited) RESOURCES State Grant OHP Capitation Title 19 Federal Grants Environmental Health Fees State Miscellaneous State - OMAP Local Grants Patient Fees Other Vital Records Divorce Filing Fees Interest on Investments Liquor Revenue Interfund Contract- Gen Fund State Shared- Family Planning CCBHC Grant TOTAL RESOURCES 66.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance 13,262,344 13,053,849 98% 14,080,644 8,168,804 58% 12,696,090 90% (1,384,554); f 8,652,200 8,142,094 94% 7,242,430 5,181,190 72% 7,967,629 110% 725,199 E 11345,100 3,069,162 228% 4,862,726 2,487,902 51% 4,454,365 92% (408,361) ( 990,189 1,311,567 132% 3,277,616 1,379,621 42% 3,018,237 92% (259,379) ( 1,169,600 1,076,036 92% 1,058,206 1,011,189 96% 1,173,000 111% 114,794 E 899,734 1,808,299 201% ! 1,040,153 221,540 21% 1,342,549 129%, 302,396 11147,168 1,108,622 97% 991,900 561,514 57% 880,997 89% (110,903) 1,208,623 1,025,508 85% 985,900 1,008,615 102% 1,829,373 186% 843,473 236,500 637,910 270% 564,750 442,664 78% 662,515 117% 97,765 f 422,593 477,834 113% 432,015 357,975 83% 541,924 125% 109,909 212,000 241,727 114% 220,000 170,350 77% 256,913 117% 36,913; ( 157,603 157,603 100% 173,030 173,030 100% 173,030 100% -1 135,000 218,767 162% 171,000 168,659 99% 252,989 148% 81,989! ( 151,000 166,372 110% 150,800 85,402 57% 112,744 75% (38,056) 127,000 127,000 100% 127,000 112,343 88% 127,000 100% 168,007 120,000 109,984 92% fi 155,099 129% I 35,099 I ( 5,327,800 E 4,805,382 90% 35,444,454 37,595,739 106% ; 35,498,170 21,640,782 61% ; 35,644,454 100% ; 146,284: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation Personnel Services f 31,702,065 29,780,257 94% 33,071,491 21,107,520 64% I 32,396,575 98% f 674,916; i ( Materials and Services i 3,v^33,299 A -1 ,YGJGJ,A An ( 9C.O 1.3 ,667 ,979 E 5,819,587 43% 11,504,971 84% 2,163,008, ( Capital Outlay 239,000 206,031 86% 695,000 - 0% 824,000 119% (129,000)! TOTAL REQUIREMENTS 44,974,364 42,441,390 94% ; 47,434,470 26,927,107 57% ; 44,725,546 94% 2,708,924: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 6,366,223 6,367,892 100% 5,747,090 3,831,380 67% 5,747,090 100% Transfers In- OHP Mental Health 548,601 0% 312,678 57% (235,923)! Transfers Out (188,688) (188,688) 100% (193,326) (96,662) 50% (193,326) 100% TOTAL TRANSFERS 6,177,535 6,179,204 100% ; 6,1023365 3,734,718 61% 5,866,442 96% ; (235,923); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 7,202,714 9,304,552 129% 10,120,803 10,638,105 105% 10,638,105 105% 517,302; Resources over Requirements (9,529,910) (4,845,651) (11,936,300) (5,286,325) (9,081,092) 2,855,208 Net Transfers - In (Out) f 6,177,535 6,179,204 d 6,102,365 3,734,718 E t 6 5,866,442 E (2353923) + TOTAL FUND BALANCE $ 3,850,339 $ 10,638,105 276% ; $ 4,286,868 $ 9,086,498 212% ; ; $ 7,423,455 173% ; $3,136,587: �IES`� Budget to Actuals Report Health Services - Admin - Fund 274 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Federal Grants 108,940 303,065 278% 726,655 401,675 55% 672,030 92% (54,625), A Interest on Investments 135,000 218,767 162% 171,000 168,659 99% 252,989 148% 81,989: B Other 9,000 16,192 180% 9,000 8,523 95% 12,784 142% 3,784 CCBHC Grant 946,400 876,190 93% TOTAL RESOURCES 1,199,340 1,414,215 118% ; 906,655 578,857 64% ; 937,803 103% ; 31,148: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,067,132 4,946,052 98% 5,241,264 3,252,659 62% 5,048,872 96% 192,392, C Materials and Services 4,600,091 4,688,516 102% 4,971,179 3,158,527 64% 4,959,102 100% 12,077! D Capital Outlay 5,000 - 0% 5,000 - 0% 5,000 100% Administration Allocation (8,327,487) (8,295,196) 100% (9,308,295) (6,204,000) 67% (9,289,585) 100% (18,710) TOTAL REQUIREMENTS 1,344,736 1,339,372 100% ; 909,148 207,186 23% ; 723,389 80% 185,759: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 40,000 26,662 67% 40,000 100% Transfers Out (188,688) (188,688) 100% (193,326) (96,662) 50% (193,326) 100% TOTAL TRANSFERS (188,688) (188,688) 100% ; (153,326) (70,000) 46% (153,326) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,642,514 2,862,108 108% 2,660,832 2,748,263 103% 2,748,263 103% 87,431 Resources over Requirements (145,396) 74,843 (2,493) 371,671 214,414 216,907; Net Transfers - In (Out) (188,688) (188,688) E (153,326) (70,000) E s (153,326) 0; TOTAL FUND BALANCE $ 2,308,430 $ 2,748,263 119% ; $ 2,505,013 $ 3,049,935 122% ; ; $ 2,809,351 112% ; $304,338: A CCBHC Expansion was originally budgeted in the "CCBHC" funding line; however, the grant through the US Department of Health and Human Services is a traditional grant and more appropriately placed in the "Federal Grants" line. A revised budget corrects this amount. Any continuation of CCBHC through the state will come through as a "CCBHC Grant" line item B Interest projection based on current investment rate and anticipated cash balances C Projected Personnel savings based on YTD Personnel expenditures D $86K projected to be expended on Crisis Stabilization Center costs over budget as well as $9K for May & June operating costs co Budget to Actuals Report C� Health Services - Behavioral Health - Fund 274 FY20 YTD February 29, 2020 (unaudited) RESOURCES State Grant OHP Capitation Title 19 Federal Grants Patient Fees State Miscellaneous Local Grants Other Divorce Filing Fees Liquor Revenue State - OMAP Interfund Contract- Gen Fund CCBHC Grant TOTAL RESOURCES 66.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance 10,187,361 9,796,391 96% 11,203,914 6,246,530 56% 9,606,603 86% (1,597,311); A 8,652,200 8,142,094 94% 7,242,430 5,181,190 72% 7,967,629 110% 725,199, B t 1,345,100 3,069,162 228% 4,862,726 2,487,902 51% 4,454,365 92% (408,361)! C 499,249 639,680 128% 2,168,961 797,619 37% 1,894,259 87% (274,702)! D t 236,500 515,196 218% 443,450 342,949 77% 520,364 117% 76,914 E 351,200 995,622 283% 437,100 904 0% 613,416 140% 176,316 F E 412,987 424,012 103% 412,900 194,770 47% 1,015,508 246% 602,608 G i 334,545 346,812 104% 342,655 246,946 72% 420,533 123% 77,878 i 157,603 157,603 100% 173,030 173,030 100% 173,030 100% i 151,000 166,372 110% 150,800 85,402 57% 112,744 75% (38,056)! t 131,900 270,591 205% 131,900 138,300 105% < 207,744 158% 75,844 t 127,000 127,000 100% 127,000 112,343 88% 127,000 100% 4,381,400 3,929,191 90% 26,968,045 28,579,727 106% ; 27,696,866 16,007,885 58% ; , 27,113,195 98% (583,671); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 6,253,121 6,248,556 100% 6,978,412 4,651,280 67% 6,978,412 100% , Personnel Services t 19,172,838 17,819,840 93% 20,059,465 12,958,274 65% _ 19,831,234 99% 228,231� H Materials and Services 6,509,514 5,549,421 85% 6,849,904 1,650,945 24% 4,409,982 64% 2,439,922! 1 Capital Outlay E 234,000 199,979 85% 6909000 0% 819,000 119% (129,000),l J TOTAL REQUIREMENTS ; 32,169,473 29,817,796 93% 34,577,781 19,260,499 56% 32,038,628 93% 2,539,153: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 2,282,708 2,282,580 100% 1,734,107 1,156,059 67% 1,734,107 100% Transfers In- OHP Mental Health 548,601 0% 312,678 57% (235,923); K TOTAL TRANSFERS 2,282,708 2,282,580 100% ; 2,282,708 1,156,059 51% ; 2,046,785 90% (235,923); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 3,976,398 5,628,746 142% 6,122,347 6,673,256 109% 6,673,256 109% 550,909: Resources over Requirements (5,201,428) (1,238,069) (6,880,915) (3,252,614) (4,925,433) 1,955,482! Net Transfers - In (Out) t 2,282,708 2,282,580 t 2,282,708 1,156,059 EE 2,046,785 E (235,923) t TOTAL FUND BALANCE $ 1,057,678 $ 6,673,256 631% ; $ 1,524,140 $ 4,576,701 300% ; $ 3,794,608 249% ; $2,270,468; A Budgeted funds was a pass -through from the Behavioral Health State IGA for residential treatment provides, which will be paid directly during an 18 -month contract. B The calendar year 2020 PacificSource contract went into effect February 1, 2020, and an estimated $255,000 is expected to be received during FY20 C There is less in Title 19 fees collected relative to budgeted expectations. D CCBHC Expansion was originally budgeted in the "CCBHC" funding line; however, the grant through the US Department of Health and Human Services is a traditional grant and more appropriately placed in the "Federal Grants" line. A revised budget corrects this amount. Any continuation of CCBHC through the state will come through as a "CCBHC Grant" line item. E There is an uptick in patient insurance fees collected relative to budgeted expectations. F Projection increased to be reflective of estimated Intellectual and Developmental Disabilities (I/DD) FY20 match amounts; actuals occur at year end G Central Oregon Health Council awarded DCHS $581,431 in one-time funds to expand hours at the Stabilization Center. Funds will be expended over the course of FY20 and FY21. As a result, $479,289 are placed in contingency for use during FY21. H Projected Personnel savings based on YTD Personnel expenditures I Reduction in Materials and Services primarily related to footnote A j Projected expenditures include DCHS contribution of $500,000 toward a North County Facility K Transfer in of Mental Health Reserve funds to be determined at year end JTES`� Budget to Actuals Report Health Services - Public Health - Fund 274 FY20 YTD February 29, 2020 (unaudited) RESOURCES State Grant Environmental Health Fees State - OMAP State Miscellaneous Local Grants Federal Grants Vital Records Patient Fees State Shared- Family Planning Other TOTALRESOURCES 66.7% Year Complete Fiscal Year 2019 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance 3,074,983 3,257,457 106% 2,876,730 1,922,273 67% 3,089,487 107% , 212,757; A i 1,169,600 1,076,036 92% 1,058,206 1,011,189 96% 1,173,000 111% 114,794 B i 1,015,268 838,031 83% 860,000 423,214 49% 673,253 78% (186,747) i 548,534 812,677 148% 603,053 220,637 37% 729,133 121% ! 126,080� C ! 795,636 601,497 76% 573,000 813,845 142% 813,865 142% 240,865! D 382,000 368,821 97% 382,000 180,327 47% 451,948 118% 69,948! ! 212,000 241,727 114% 220,000 170,350 77% 256,913 117% 36,913! ! 122,714 121,300 99,715 82% 142,151 117% 20,851! k 168,007 120,000 109,984 92% 155,099 129% 35,099! 79,048 114,830 145% 80,360 102,507 128% _ 108,607 135% 28,24T 7,277,069 7,601,797 104% ; 6,894,649 5,054,041 73% 7,593,456 110% ; 698,807; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 2,074,366 2,046,640 99% 2,329,883 1,552,720 67% 2,311,173 99% 18,710; Personnel Services k 7,462,095 7,014,365 94% 7,770,762 4,896,587 63% 7,516,469 97% 254,293, E Materials and Services ! 1,923,694 2,217,165 115% 1,846,896 1,010,115 55% 2,135,887 116% (288,991)l F Capital Outlay - 6,051 999% - TOTAL REQUIREMENTS 11,460,155 11,284,222 98% ; 11,947,541 7,459,423 62% 11,963,529 100% ; (15,988); TRANSFERS Budget Actuals % Budget Actuals % Projection % $Variance Transfers In- General Fund 4,083,515 4,085,312 100% 3,972,983 2,648,659 67% 3,972,983 100% TOTAL TRANSFERS 4,083,515 4,085,312 100% ; 3,972,983 2,648,659 67% ; 3,972,983 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 583,802 813,698 139% 1,337,624 1,216,586 91% 1,216,586 91% (121,038): Resources over Requirements (4,183,086) (3,682,425) (5,052,892) (2,405,382) (4,370,073) 682,84 Net Transfers - In (Out) k 4,083,515 4,085,312 k 3,972,983 2,648,659 ! 1 3,972,983 t 0! ! TOTAL FUND BALANCE $ 484,231 $ 1,216,586 251% ; $ 257,715 $ 1,459,863 566% ; $ 819,496 318% ; $561,781: A Public Health State IGA increased funds for Regional and Local Public Health Modernization B Fees were budgeted at an increase of 3%, but were adopted at an 8.5% rate increase C Payments are reimbursed on a quarterly basis, and include the Medicaid Administrative Claims payment for which is currently outstanding D Funds include the Diabetes Prevention Program, which was awarded for the calendar year 2020 E Projected Personnel savings based on YTD Personnel expenditures F Additional expenditures are related to notes A and D. Budget to Actuals Report Community Development - Fund 295 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 114,500 152,827 133% 162,000 91,805 57% 141,500 87% (20,500); A Code Enforcement d 664,291 635,453 96% 693,960 406,826 59% 693,960 100% Building Safety 3,312,714 3,075,409 93% 3,433,780 1,989,084 58% 3,350,950 98% (82,830); B Electrical 804,849 738,580 92% 809,500 475,460 59% 738,600 91% (70,900); B Environmental On -Site ! 782,984 819,608 105% 877,400 607,092 69% 887,000 101% 9,600 Current Planning 1,795,453 1,701,840 95% 1,807,176 1,103,679 61% 1,743,776 96% (63,400)' C Long Range Planning ! 678,955 632,170 93% 685,004 402,606 59% 677,004 99% (8,000), D TOTAL RESOURCES ; 8,153,746 7,755,886 95% ; 8,468,820 5,076,552 60% 8,232,790 97% ; (236,030); REQUIREMENTS Admin - Operations Code Enforcement Building Safety Electrical Environmental On -Site Current Planning Long Range Planning TOTAL REQUIREMENTS TRANSFERS Transfers In - General Fund Transfers Out Transfers Out - CDD Reserve TOTAL TRANSFERS Budget Actuals % Budget Actuals % 2,477,738 2,386,276 96% ' 2,492,316 1,668,155 67% ' ! 456,162 445,254 98% 535,590 312,669 58% ! 1,676,037 1,565,140 93% 1,743,298 1,041,487 60% r 445,433 439,104 99% 462,183 297,597 64% ! 612,596 547,203 89% 616,279 371,323 60% ! 11554,847 1,456,128 94% 1,501,588 945,034 63% 503,344 492,687 98% 554,385 312,802 56% 7,726,157 7,331,793 95% 7,905,639 4,949,068 63% ; Projection % $ Variance 2,460,143 99% 32,173, E 462,056 86% 73,534! E 1,618,137 � 93% 125,162! F � 446,335 r 97% ' 15,848' F 580,072 i 94% 36,207! F 1,448,088 � r 96% ' 53,500'i 470,173 � 85% 84,212'r G 7,485,003 95% 420,636: Budget Actuals % Budget Actuals % Projection % $ Variance 300,000 289,193 96% 100,000 50,000 50% 100,000 100% ' (79,945) (79,945) 1UU%u ' (85,695) (42,844) 509/6 ' ' (85,696) luuu o (1,372,679) (1,379,420) 100% (1,462,386) (731,188) 50% (1,441,180) 99% 21,20& (1,152,624) (1,170,172) 102% ; (1,448,081) (724,032) 50% (1,426,876) 99% 21,205: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,203,711 2,529,615 115% 1,982,004 1,783,536 90% 1,783,536 90% (198,468)' Resources over Requirements 427,589 424,093 563,181 127,484 747,787 184,606, Net Transfers - In (Out) (1,152,624) (1,170,172) (1,448,081) (724,032) (1,426,876) 21,205 TOTAL FUND BALANCE $ 1,478,676 $ 1,783,536 121% ; $ 1,097,104 $ 1,186,988 108% ; ; $ 1,104,447 101% ; $7,343: Note: Requirements projection decreased across divisions to reflect credits from the PERS Reserve Fund A Interest projection based on current investment rate and anticipated cash balances; projection decreased due to lower than expected volume B Projection decreased due to lower than expected volume C Change in accounting procedure for hearings officer deposits, which are held as a liability instead of recognized as revenue. Projection decreased due to lower than expected volume. D CLG Grant decreased to reflect anticipated actual amount E Overall, projection decreased due to year to date unfilled positions and increased to include unbudgeted health benefits trust F Overall, projection decreased due to year to date unfilled positions G Projection increased due to time management leave payout; CLG Grant decreased to reflect anticipated actual amount �I ES Budget to Actuals Report C� , Road - Fund 325 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Motor Vehicle Revenue 16,234,849 16,726,428 103% , 17,609,539 11,744,759 67% 17,609,539 100% Federal - PILT Payment 1,900,000 2,153,308 113% 1,510,450 2,310,002 153% 2,310,002 153% 799,552. A Other Inter -fund Services 1,044,353 1,096,023 105% 1,156,581 243,899 21% 1,095,581 95% (61,000): B Forest Receipts 963,410 801,125 83% 915,000 - 0% 761,069 83% (153,931)l C Cities-Bend/Red/Sis/La Pine 635,000 400,849 63% 660,000 153,780 23% 404,553 61% (255,447); D Sale of Equip & Material 365,000 327,920 90% 358,000 179,498 50% 349,835 98% (8,165); E Interest on Investments 150,000 220,062 147% 246,000 128,280 52% 193,000 78% (53,000), F Federal Reimbursements 544,000 363,910 67% 181,757 363,514 200% 363,514 200% 181,757� G Mineral Lease Royalties 175,000 69,422 40% 60,000 51,925 87% 60,000 100% Miscellaneous 45,000 118,699 264% 57,500 59,455 103% 79,000 137% 21,500! H State Miscellaneous 739,811 735,114 99% 20,000 34,325 172% 34,325 172% 14,325; 1 Assessment Payments (P&I) 80,000 22,350 28% 11,000 6,356 58% 11,000 100% TOTAL RESOURCES ; 22,876,423 23,035,209 101% ; 22,785,827 15,275,793 67% ; 23,271,418 102% ; 485,591: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 6,595,561 6,246,351 95% 6,447,671 4,192,414 65% 6,294,074 98% 153,597: J Materials and Services 8,094,192 5,912,553 73% 8,092,165 3,590,729 44% 7,444,186 92% 647,979; K Capital Outlay 33,500 19,582 58% 32,416 97% 11084, L TOTAL REQUIREMENTS 14,689,753 12,158,904 83% 14,573,336 7,802,725 54% 13,770,676 94% ; 802,660; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out (14,464,308) (14,464,308) 100% (11,910,575) (6,612,088) 56% (11,910,575) 100010 TOTAL TRANSFERS (14,464,308) (14,464,308) 100% ; (11,910,575) (6,612,088) 56% ; (11,910,575) 100% ; FUND BALANCE Budget Actuals % Budget Actua€s % Projection % $ Variance Beginning Fund Balance 8,693,653 10,314,842 119% 6,001,989 6,726,840 112% 6,726,840 112% 724,851; Resources over Requirements 8,186,670 10,876,306 8,212,491 7,473,068 9,500,742 1,288,251 Net Transfers - In (Out) i (14,464,308) (14,464,308) E (11,910,575) (6,612,088) t (11,910,575) 0; TOTAL FUND BALANCE $ 2,416,014 $ 6,726,840 278% ; $ 2,303,905 $ 7,587,820 329% ; $ 4,317,007 187% ; $2,013,102: A PILT payment received in July. Exceeded amounts as budgeted due to a decrease in Timber revenue B Decrease in vehicle repair revenue due to new vehicles in the fleet C Revised projection based on federal legislation and projections from AOC D Contracted work for City of Redmond will be completed in FY 21 instead of FY 20 E Anticipated decrease in sale of signs F Interest projection based on current investment rate and anticipated cash balances G A two-year federal project was completed in one year, so full amount of reimbursement was requested in year one. H Restitution receipts are higher than anticipated I Updated based on actual receipts j Projected Personnel savings based on YTD average vacancy rate of 2.0% K Contracted road services and on -call engineering anticipated to be less than budgeted due to lack of snow and emergency work. Aggregate & Asphalt anticipated to be less than budgeted due to City of Redmond work being pushed to FY 21. L Updated based on revised estimate �IES` Budget to Actuals Report Adult P&P - Fund 355 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance DOC Grant in Aid SB 1145 4,781,604 4,781,604 100% 4,353,626 3,466,336 80% 4,621,782 106% 268,15& A CJC Justice Reinvestment E 844,831 853,831 101% 712,530 528,980 74% 774,281 109% , 61,751; A DOC Measure 57 233,900 233,900 100%! 236,142 239,005 101% 239,005 101% 2,863, A Probation Supervision Fees E 210,000 191,536 91% 160,000 121,013 76% 180,000 113% 20,000! B DOC-Family Sentence Alt 114,683 114,683 100% 114,682 223,746 195% 230,000 201% , 115,318, C Interest on Investments E 40,000 77,778 194% 77,500 44,781 58% 70,000 90% (7,500); D Gen Fund/Crime Prevention 50,000 50,000 100% 50,000 25,000 50% 50,000 100% Interfund- Sheriff 50,000 51,034 102% 50,000 36,667 73% 50,000 100% State Subsidy 17,000 16,337 96% 16,298 12,527 77% 16,298 100% Probation Work Crew Fees E 4,000 2,800 70% 2,000 1,560 78% t E 2,000 100%! - Electronic Monitoring Fee 10,000 84,165 842% 2,000 14,753 738% < 18,000 900% ! 16,000, E Miscellaneous E 500 6,102 999% 500 11,202 999% 12,000 999%: 11,500! F Oregon BOPPPS � - 16,653 40,934 E 40,934, G E E State Miscellaneous 4,300 0% TOTAL RESOURCES 6,360,818 6,463,769 102% ; 5,775,278 4,742,223 82% 6,304,300 109% ; 529,022: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 4,656,363 4,522,266 97% 4,809,644 3,170,384 66% 4,771,833 99% 37,811, H Materials and Services 1,828,765 1,686,408 92% 1,764,847 1,105,215 63% 1,784,847 101% (20,000): 1 Capital Outlay E 20,000 - 0% 15,000 10,000 67% 10,000 67% 5,000: J TOTAL REQUIREMENTS ; 6,505,128 6,208,673 95% 6,589,491 4,285,600 65% 6,566,680 100% ; 22,811: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 285,189 285,189 100% 285,189 190,120 67% 285,189 100% Transfer to Vehicle Maint (120,000) (120,000) 100% (62,000) (31,000) 50% (62,000) 100% TOTAL TRANSFERS 165,189 165,189 100% ; 223,189 159,120 71% ; 223,189 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,200,000 2,333,720 106% 2,590,000 2,754,005 106% t 2,754,005 106% = 164,005� Resources over Requirements (144,310) 255,096 (814,213) 456,623 (262,380) 551,833! Net Transfers - In (Out) E 165,189 165,189 E f 223,189 159,120 E E 223,189 i 0! E TOTAL FUND BALANCE $ 2,220,879 $ 2,754,005 124% ; $ 1,998,976 $ 3,369,749 169% ; $ 2,714,814 136% ; $715,838: A State Dept. of Corrections and Criminal Justice Commission received more funding for dispersal than anticipated at time of budgeting B Projection based on YTD actuals C State Dept. of Corrections under allocated resources at the time of budgeting D Interest projection based on current investment rate and anticipated cash balances E Revenue from prior pretrial EM clients more than anticipated at time of budgeting due to account close-out offer in June -Aug 2019 and Dept. Revenue fees from closed/previous accounts. F Revenue includes miscellaneous refunds, staff uniform overage fees and payment from participants attending a Nov 2019/March 2020 training event hosted by Adult P&P G State makes one payment per biennium to conduct hearings for sanctioned offenders. Will receive both FY19 and FY21 biennial payments in FY20. H Projected Personnel savings based on YTD average vacancy rate of 1.8% less anticipated retirement vacation payouts I Projection based on YTD actuals. Higher than anticipated pass -through grant contributions (JRI), and emergency and transitional housing costs j Projection based on YTD actuals. DCSO auction vehicle was less expensive than budgeted. CO Budget to Actuals Report Road CIP - Fund 465 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 1 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Miscellaneous 853,104 0% 1,944,893 1,058,217 54% 1,777,052 91% (167,841), A Interest on Investments 106,000 261,131 246% 198,000 249,288 126% 360,000 182% 162,000! B Interfund Payment 111,560 111,560 111,560! C TOTAL RESOURCES 959,104 261,131 27% 2,142,893 1,419,066 66% 2,248,612 105%: 105,719: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 73,153 73,153 100% 71,748 47,832 67% 71,748 100% Capital Outlay 8,236,348 5,411,213 66% 13,764,165 2,903,006 21% 7,174,099 52% 6,590,066 D TOTAL REQUIREMENTS : 1 8,309,501 5,484,366 66% 13,835,913 2,950,838 21 % 7,245,847 52% 6,590,066: TRANSFERS Budget Actuals % Budget Actuals % Projection % Variance Transfers In 13,811,725 13,393,963 97% 12,014,914 5,298,487 44% 11,893,453 99% (121,461)' E TOTAL TRANSFERS 13,811,725 13,393,963 97% 12,014,914 5,298,487 44% 11,893,453 99% (121,461): FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 7,687,037 9,588,827 125% 15,616,536 17,759,555 114% 17,759,555 114% 2,143,019: Resources over Requirements (7,350,397) (5,223,236) (11,693,020) (1,531,772) (4,997,235) 6,695,785, Net Transfers - In (Out) 13,811,725 13,393,963 12,014,914 5,298,487 11,893,453 (121,461); TOTAL FUND BALANCE $ 14,148,365 $ 17,759,555 126%: $ 15,938,430 $ 21,526,269 135% $ 24,655,773 155% $8,717,343: A Updated based on reimbursable projects planned to be completed this fiscal year B Interest projection based on current investment rate and anticipated cash balances C Unbudgeted revenue to offset expenses for Spring River Road Improvements D Variance due to unanticipated project delays projected to advance FY 20 budgeted CIP project costs into FY 21, including $5M for US 97 Bend North Corridor project E Revised estimate based on SDC eligible projects anticipated to be completed in fiscal year Budget to Actuals, Report Road CIP (Fund 465) - Capital Outlay Summary by Project 66.7% FY20 YTD February 29, 2020 (unaudited) Year Completed Fiscal Year 2019 1 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance Burgess Road Day Road Inter. 900,106 658,203 73% 1 Deschutes Market Dale Road Inter. 1,500,000 1,285,822 86% Erickson Road Paving 468,544 Old Bend Redmond Highway Phase 11 3rd Street Drainage Extension 300,000 112,655 38% US 20 at Tumalo 300,000 1,100,000 367%;: 300,000 0% 1 0% 300,000. Paving Knott Rd 850,286 495,978 58% S. Canal Helmholtz Way 714,937 141,751 20% 800,000 37,463 5% 642,226 80% 1 157,77C S. Canal - "Six" Corners 798,699 537,724 67% I 900,000 1,001,308 111%1 1,007,432 112%; (107,432). Six Corners Irrigation Tumalo Road Tumalo Place 406,879 499123 12% 769,521 76,262 10% - 389,788 51% 379,733- Quail Road Improvements 100,000 100,000 100%t La Pine Guardrail Repair 40,099 C Avenue: Hwy 97 to 6th St Impry 180,746 359351 20% 1 300,000 369,705 123% 1 1 369,705 123% (69,705)- Solar Drive Bridge 1 60,000 709334 44% Old Bend Rdm/Tumalo Rd Inter 346,426 50,355 15% 625,642 76,042 12% 772,150 !; 123% (146,508)- Sisemore Bridge 220,000 100,596 46% 632,174 98,463 16% 675,503 107%' 43,329) Spring River Bridge Parking Imp 163,776 12,122 12,122 (112,1122) NE Negus and 17TH 360,000 221 0% 1 1,025,472 1,304 0% 180,000 18% 1 845,472- Paving Ward Road 339,810 681 0% 598,269 715,504 120%' 715,504 120% (117,235) Hunnel Rd: Loco Rd to Tumalo Rd 275,000 236 0% 1 75,000 27% 200,000 Cascade Lakes Hwy Bike Facilities 39,856 11,856 30% 11,856 30% 28,0001 Fyrear Rd US 20 to Stevens 300,000 - 0% 300,000 100% Alfalfa Mkt Rd: Powell Butte Hwy 300,000 709 0% 450,000 150%' (150,000) Bend District Local Roads 558,459 0% City of LaPine Local Roads 500,000 0% 0% % 500,000 US 97 Bend North Corridor 5,000,000 0% 0% 5,000,000 Tumalo Res Rd: OB Riley to Bailey Rd 247,342 0% 0% 247,342. US 20 Ward Rd to Hamby 500,000 500,000 100% 500,000 100%' Transportation System Plan Update 250,000 253 0% 805000 32% 170,000- Gribbling Rd Bridge 60,000 0% 30,000 50% 30,000- Slurry Sea] 2020 675 300,000 (300,000)- Paving of S. Century Dr 1- ,592 484,813 (484,813) Sisemore Rd Canal Piping Terrebonne Wastewater Feasibility St. 217 50,000 (50,000) Signage Improvements 100,000 0% 60,144 0% 28,000 47% 32,144 Guardrail Improvements 100,000 0% 100,000 0% 100,000 100% ARTS Project 180,746 0% 0% - 180,746 TOTAL CAPITAL OUTLAY $8,236,348 $ 5,411,213 66%!- $ 13,764,165 $2,903,709 21%: $7,174099 , 52%1 $ 6,590,066: �I ES`�{ Budget to Actuals Report Solid Waste - Fund 610 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Franchise Disposal Fees 6,497,676 6,356,636 98% 6,437,500 4,418,649 69% 6,437,500 100% Private Disposal Fees 2,709,370 2,379,061 88% 2,419,046 1,535,781 63% 2,419,046 100% Commercial Disp. Fee 2,042,050 2,060,523 101% 2,252,225 1,600,038 71% 2,252,225 100% Franchise 3% Fees 265,000 291,340 110% 265,000 37,919 14% 265,000 100% A Yard Debris 216,761 268,830 124% , 216,761 180,548 83% 216,761 100% B Interest 44,000 58,235 132% 59,000 29,251 50% 46,000 78% (13,000); C Miscellaneous 49,955 57,067 114% 48,336 142,121 294% 156,540 324% 108,204; D Special Waste 15,000 21,487 143% 15,000 12,987 87% 15,000 100% Recyclables 18,000 11,063 61% 12,000 8,025 67% 12,000 100% Leases 10,801 1 0% e 1 - 0% 1 100%! - TOTAL RESOURCES 11,868,613 11,504,244 97% ; 11,724,869 7,965,318 68% 11,820,073 101% ; 95,204: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 2,504,623 2,331,135 93% 2,538,776 1,574,143 62% 2,395,279 94% 143,497, E Materials and Services 4,772,159 4,341,881 91% 4,927,163 2,417,401 49% 4,852,740 98% 74,423! F Capital Outlay 173,000 109,681 63% 56,000 11,724 21% 11,724 21% 44,276 G Debt Service 860,938 860,937 100% 862,100 309,595 36% 862,100 100% H TOTAL REQUIREMENTS 8,310,720 7,643,635 92% 8,384,039 4,312,863 51% ; 8,121,843 97% ; 262,196; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance SW Capital & Equipment (4,688,023) (5,000,029) 107% (3,296,192) (1,616,182) 49% (3,296,192) 100% Rese .e TOTAL TRANSFERS (4,688,023) (5,000,029) 107% ; (3,296,192) (1,616,182) 49% ; (3,296,192) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,730,130 1,938,991 112% 600,000 799,570 133% 799,570 133% 199,570- Resources over Requirements 3,557,893 3,860,608 3,340,830 3,652,455 3,698,230 357,400! Net Transfers - In (Out) (4,688,023) (5,000,029) E (3,296,192) (1,616,182) (3,296,192) 0; TOTAL FUND BALANCE $ 600,000 $ 799,570 133% ; $ 644,638 $ 2,835,843 440% ; ; $ 1,201,608 186% ; $556,970: A Fees due April 15, 2020 B Revenue is seasonal with higher utilization in the summer months C Interest projection based on current investment rate and anticipated cash balances D Includes an unbudgeted sale of loader 7-279 for $95K, CEC LED light incentive and Taylor NW royalty payments E Projected Personnel savings based on YTD average vacancy rate of 4.6% F Projecting to be slightly less than budget and the waste characterization study and seasonal items such as mulching from the Fire Free events and bird control are anticipated later this fiscal year G FY19 extended the life of an existing vehicle and did not purchase a second pick-up; FY20 purchased the budgeted gas monitoring equipment and moved the fencing project to FY21 H Principal and interest payments due in Nov and May ES ` 2 Budget to Actuals Report Fair & Expo - Fund 615 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Events Revenue 655,000 615,300 94% 687,000 324,965 47% 602,000 88% (85,000); A Food & Beverage 540,000 629,875 117% 568,000 242,826 43% 530,000 93% (38,000), B Rights & Signage 105,000 115,650 110% 120,000 81,100 68% 96,000 80% (24,000) Storage 1 83,100 76,735 92% 71,000 38,468 54% 80,000 113% 9,000; Horse Stall Rental 1 57,000 71,855 126% 62,000 37,296 60% 61,000 98% (1,000) Interfund Payment 30,000 54,573 182% 30,000 20,000 67% E 30,000 100% -1 C Camping Fee 18,200 19,975 110% 18,000 5,600 31% 16,000 89% (2,000)! Miscellaneous 8,400 6,374 76% 3,500 2,236 64% 4,000 114% 500 Interest 1 2,400 (518) -22% 2,000 (2,613) -131% (3,000) -150%! (5,000)� TOTAL RESOURCES 1,499,100 1,589,820 106% ; 1,561,500 749,879 48% ; 1,416,000 91% ; (145,500); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 1,248,512 1,259,337 101% 1,176,169 737,538 63% 1,095,169 93% ' 81,000, D Personnel Services - F&B 149,296 149,947 100% 157,430 101,856 65% 147,180 93% 10,250! E Materials and Services 1 967,441 912,724 94% 795,788 594,986 75% 910,000 114% (114,212)! F Materials and Services - F&B 1 222,500 365,951 164% 234,600 178,264 76% 337,100 144% (102,500)! B Debt Service 1 101,136 101,136 100% = 100,800 55,290 55% 100,800 100% TOTAL REQUIREMENTS ; 2,688,885 2,789,095 104% ; 2,464,787 1,667,934 68% 2,590,249 105% ; (125,462), TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Room Tax 517,996 517,996 100% 409,654 209,114 51% 409,654 100% ' Transfers 111 - lil/Ullt�/ F411 ' A90 nno ' YI I "1 Ad -I nnn 1.13 VV 000/ YV /u ' 4nC nnn .Ia , Vv 250 nnn c.1 , vv vV le ' ' 63% 250 nnn 63% (145 000), G c.i , vv vV I� ' �.-.v,vv vlv Transfers In - General Fund 1 200,000 200,000 100% 200,000 133,328 67% 200,000 100% Transfers In - Park Fund 30,000 30,000 100% 30,000 15,000 50% 30,000 100% t Transfers Out 1 (11,791) (5,894) 50% (11,791) 100% TOTAL TRANSFERS 1,220,994 1,164,996 95% 1,022,863 601,548 59% ; , 877,863 86% ; (145,000); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance (60,285) 999% 80,000 (94,564) -118%; (94,564) -118%, (174,564), H Resources over Requirements (1,189,785) (1,199,275) (903,287) (918,055) (1,174,249) (270,962) Net Transfers - In (Out) a 1,220,994 1,164,996 a 1,022,863 601,548 11 877,863 1 (145,000) 1 TOTAL FUND BALANCE $ 31,209 ($ 94,564) -303%; $ 199,576 ($ 411,071) -206%; ; ($ 390,950) -196%; ($590,526); A Current year receipts are 47% of budget YTD; prior year receipts were 49.6% of budget at this point last year. Revenue projections down due to loss of/postponement of Endurocross and other events. B Net earnings from F&B activities YTD are $(37,294). Monthly fixed costs have a greater impact on earnings during off-season months. C Reimbursement from RV Park for personnel expenditures recorded in F&E. D Projected Personnel savings based on YTD average vacancy rate of 6.3% E Net earnings from F&B activities YTD are $(37,294). Monthly fixed costs have a greater impact on earnings during off-season months. Projected Personnel savings based on YTD average vacancy rate of 6.3% F Projected increase primarily driven by Utilities, R&M and Advertising G Net proceeds from the County Fair are recorded in a separate fund and transferred in at year-end (Final estimate of $250k) H Prior year losses, relative to budget, are compounded into the beginning working capital to start the fiscal year. o� JTES ` Budget to Actuals Report RV Park - Fund 618 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance RV Park Fees < 31 Days 340,200 458,331 135% 405,200 298,057 74% 463,372 114%- 58,172, A Interest on Investments E 4,400 12,255 279% 12,000 8,217 68% 13,000 108% ! 1,000! B RV Park Fees > 30 Days 5,000 11,600 232% 5,000 9,192 184% < 13,450 269% ! 8,450! Cancellation Fees ! 4,000 12,497 312% 5,000 4,426 89% 5,626 113% 626! Washer / Dryer 3,500 4,650 133% 4,000 4,190 105% , 5,063 127% , 1,063 Vending Machines 1,500 1,716 114% 3,000 1,627 54% 2,073 69% (927)[ Miscellaneous ! - 2,231 r 2,000 1,666 83% 2,356 118% 356 Good Sam Membership Fee i - 2,561 1,500 351 23% 351 23% (1,149); C Good Sam Discounts ! - (17,220) 999% (7,109) 999% (7,109) 999% (7,109)� C TOTAL RESOURCES 358,600 488,620 136% ; 437,700 320,617 73% 498,182 114% ; 60,482; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 298,870 276,007 92% 318,273 192,248 60% 279,291 88% 38,982; Debt Service ! 223,101 223,101 100% 222,100 161,528 73% 222,100 100% TOTAL REQUIREMENTS 521,971 499,108 96% ; 540,373 353,776 65% , 501,391 93% ; 38,982: 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 17,500 50% 35,000 100% Transfer Out - RV Reserve (502,000) (251,000) 50% (502,000) 100% TOTAL TRANSFERS 160,000 160,000 100% ; (307,000) (73,500) 24% , (307,000) 100% ; FUND BALANCE Budget Actuals % Budget Actuais % Projection % $ Variance Beginning Fund Balance 319,000 443,480 139% 560,000 592,992 106% 592,992 106% 32,992, Resources over Requirements E (163,371) (10,488) (102,673) (33,159) (3,209) 99,464 Net Transfers - In (Out) 160,000 160,000 (307,000) (73,500) (307,000) 0 TOTAL FUND BALANCE $ 315,629 $ 592,992 188% ; $ 150,327 $ 486,333 324% ; ; $ 282,783 188% ; $132,456: A 8,779 RV spaces, 34.08% utilization YTD. Prior year comparable was 8,085 RV spaces, 31.39% utilization YTD 8 Interest projection based on current investment rate and anticipated cash balances C The Good Sam incentive program was discontinued during Fall 2019. o,\)TEs` �< Budget to Actuals Report Risk Management - Fund 670 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,247,279 1,273,816 102% 1,255,108 874,101 70% 1,255,108 100%, - General Liability 1,063,675 1,063,675 100% 1,072,326 703,657 66% 1,072,326 100% Property Damage 394,291 394,291 100% 392,923 263,947 67% 392,923 100% Unemployment 280,921 297,540 106% 323,572 293,380 91% 323,572 100% A Vehicle 195,250 195,250 100%! 195,580 135,337 69% 195,580 100% Interest on Investments 85,000 148,890 175% 137,000 103,713 76% 161,000 118%: 24,000` B Claims Reimbursement 269,198 57,073 21% 82,000 446,882 545% 450,000 549% 368,000! Skid Car Training 32,000 44,910 140% 34,000 31,680 93% 34,000 100% Process Fee- Events/ Parades 1,800 1,575 88% 2,000 945 47% 2,000 100% Miscellaneous 500 5 1% 500 5 1% 500 100% Loss Prevention 30 30 100% 30 - 0% 30 100% TOTAL RESOURCES 3,569,944 3,477,056 97% 3,495,039 2,853,647 82% ; 3,887,039 111 % ; 392,000: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,360,000 1,013,256 75% F 1,460,000 529,782 36% 1,200,000 82% 260,000� General Liability 900,000 633,248 70% 1,400,000 216,359 15% 850,000 61% 550,000! C Insurance Administration 599,459 529,833 88% 592,059 312,118 53% 524,059 89% 68,000! D Property Damage 728,638 548,796 75% 400,236 . 648,279 162% 900,000 225% (499,764)�l E Vehicle 120,000 100,150 83% 150,000 94,244 63% 250,000 167% ! (100,000)! Unemployment 150,000 37,481 25% 130,000 25,612 20% 90,000 69% 40,000! F TOTAL REQUIREMENTS ; 3,858,097 2,862,764 74% 4,132,295 1,826,394 44% 3,814,059 92% ; 318,236: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out - Vehicle Replace (3,168) (3,168) 100% (6,918) (3,458) 50% (6,918) 100% - TOTAL TRANSFERS (3,168) (3,168) 100% ; (6,918) (3,458) 50% (6,918) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 5,600,000 6,582,283 118% 6,100,000 7,193,407 118% = 7,193,407 118% 1,093,407, Resources over Requirements (288,153) 614,292 (637,256) 1,027,254 72,980 710,236; Net Transfers - In (Out) r (3,168) (3,168) (6,918) (3,458) € (6,918) 0; TOTAL FUND BALANCE $ 5,308,679 $ 7,193,407 136% ; $ 5,455,826 $ 8,217,203 151% ; $ 7,259,469 133% ; $1,8033643: A Unemployment collected on first $25K of employee's salary in fiscal year B Interest projection based on current investment rate and anticipated cash balances C Claims are difficult to project, but General Liability claims are trending less than budget D Part of projected Personnel savings based on 1.00 vacant FTE in July and August, which has been transferred to Administrative Services E Majority of Fair/Expo roof replacement costs were expected in FY19, but significant portion incurred in FY20. F Fewer unemployment claims than anticipated. '�Es` Budget to Actuals Report Health Benefits - Fund 675 FY20 YTD February 29, 2020 (unaudited) 66.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Internal Premium Charges 17,054,563 18,051,440 106% 17,411,292 11,802,169 68% 17,703,254 102% 291,962; COIC Premiums 1,834,000 1,794,789 98% 1,967,021 962,104 49% 1,644,000 84% (323,021), A Retiree / COBRA Premiums 1,280,000 1,144,088 89% 1,433,000 635,637 44% 953,455 67% (479,545); B Employee Co -Pay 963,000 1,016,748 106% 1,041,120 682,570 66% 1,026,114 99% (15,006)- Interest 220,000 366,207 166% - 346,000 243,495 70% 383,000 111% 37,000 Prescription Rebates 60,000 148,847 248% 75,000 88,890 119% 95,000 127% 20,000 Claims Reimbursement & Other 177,557 45,000 750 2% 45,000 100% TOTAL RESOURCES 21,411,563 22,699,675 106% ; 22,318,433 14,415,614 65% 21,849,823 98% ; (468,610); REQUIREMENTS Budget Actuals % Budget ,Actuals % Projection % $ Variance Health Benefits 19,559,777 17,493,075 89% 18,550,836 10,717,692 58% 19,160,789 103% (609,953); C Deschutes On -Site Pharmacy 2,284,744 2,514,038 110% 2,242,104 1,722,584 77% 2,923,025 130% (680,921); C Deschutes On -Site Clinic 1,114,864 1,045,588 94% 1,141,691 661,386 58% 1,141,691 100% C Wellness 184,870 158,384 86% 180,380 113,641 63% 180,380 100% C TOTAL REQUIREMENTS 23,144,255 21,211,086 92% 22,115,011 13,215,304 60% ; 23,405,885 106% ; (1,290,874), FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 16,051,586 15,075,316 94% 16,106,294 16,563,905 103% 16,563,905 103% 457,611- Resources over Requirements (1,732,692) 1,488,590 203,422 1,200,310 (1,556,062) (1,759,484): Net Transfers - In (Out) - - 0; TOTAL FUND BALANCE : $ 14,318,894 $ 16,563,905 116% $ 16,3099716 $ 17,764,216 109% $ 15,007,843 92% 01,301,873); A Prior year monthly average was $149K, whereas YTD monthly average is $137K; COIC rates reduced by 5% at start of fiscal year Prior year monthly average was $95K, whereas YTD monthly average is $79K Amounts are paid 1 month in arrears; projection compared to historical costs for reasonableness ` Budget to Actuals Report o { 911 - Fund 705 FY20 YTD February 29, 2020 (unaudited) RESOURCES Property Taxes - Current Yr Telephone User Tax Police RMS User Fees Interest State Reimbursement Property Taxes - Prior Yr Data Network Reimbursement Contract Payments User Fee Property Taxes - Jefferson Co. Miscellaneous TOTALRESOURCES 66.7% Year Complete Fiscal Year 2019 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance 8,311,833 8,426,089 101% 8,809,419 8,536,546 97% 8,856,617 101% 47,198; A 890,000 955,187 107% 900,000 474,581 53% 900,000 100% B 300,680 335,192 111% 250,000 85,643 34% 250,000 100%! C 200,000 205,570 103% 157,000 128,810 82% i 198,000 126% ! 41,000! D 125,000 162,900 130% 125,000 18,000 14% 125,000 100%! -! E 110,000 108,419 99% 100,000 233,357 233% 255,000 255% ! 155,000! F 50,000 106,592 213% t 55,000 - 0% 55,000 100% 51,300 175 0% 51,300 10,083 20% 75,000 146% 23,700! C 180,000 141,980 79% 73,680 4,313 6% 73,680 100% -! C 30,000 33,453 112% 30,000 32,557 109% 32,650 109% 2,650! 11,200 38,757 346% 11,951 10,584 89% 11,951 100% 10,260,013 10,514,313 102% ; 10,563,350 9,534,474 90% 10,832,898 103% ; 269,548: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 7,646,307 6,743,116 88% 7,462,575 4,723,143 63% 6,977,284 93% 485,291, G Materials and Services 3,370,357 3,297,619 98% 3,387,761 2,259,156 67% 3,387,761 100% Capital Outlay 2,362,400 529,377 22% 1,400,000 187,468 13% 1,400,000 100% TOTAL REQUIREMENTS 13,379,064 10,570,113 79% 12,250,336 7,169,767 59% 11,765,045 96% 485,291: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 8,625,000 8,660,615 Inn% 7,753,706 8,604,816 111% 8,604,816 111% 851.10% Resources over Requirements (3,119,051) (55,800) (1,686,986) 2,364,707 (932,147) 754,839 i i Net Transfers - In (Out) - 0:i TOTAL FUND BALANCE $ 5,505,949 $ 8,604,816 156% ; $ 6,066,720 $ 10,969,523 181% ; ; $ 7,672,668 126% ; $1,605,948; A Actual 19-20 TAV is a 5.36% increase compared to FY 18-19 vs. 5.5% budgeted; however collection rate is projected to be 95.8% versus 95% B Telephone maintenance reimbursements are received in a lump sum by early spring C Majority of billings sent at the end of March, revenue expected in early May D Interest projection based on current investment rate and anticipated cash balances E State GIS reimbursements are received quarterly F TDS Baja deferred billing credits per ORS 305.286 in addition to settlement payment G Projected Personnel savings based on YTD average vacancy rate of 8.3% \)I E S CpGZ 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 March 23, 2020 DATE: March 17, 2020 FROM: Whitney Hale, Administrative Services, 541-330-4640 TITLE OF AGENDA ITEM: Legislative Session Debrief RECOMMENDATION & ACTION REQUESTED: Discuss 2020 legislative session in preparation for the 2021 session. Staff would like to discuss to 2020 legislative session and get commissioner feedback on session outcomes, logistics and potential improvements for next year's session. Staff would also like to get feedback from the commissioners whether they would like to renew thin rni intv'c ri irrinnt rnntrnrt fnr laniclativp and Inhhvinn-arvir.PS Date: March 16, 2020 To: Board of Commissioners From: Whitney Hale Subject: Legislative Session / County Legislative & Lobbying Services Legislative Session Debrief Staff would like to discuss the 2020 legislative session and get commissioner feedback on session outcomes, logistics and potential improvements for next year's session: - Meeting schedule o Agenda format o Legislator participation - Reports - AOC Collaboration - Staff updates - Advocacy letters/material - Specific legislative items o Follow-up for special session or 2021 session o Went right/went wrong Staff would also like to get feedback from the commissioners on if they would like to renew the County's current contract for legislative and lobbying services or if they are interested in initiating a new RFP process. The existing contract with Pac West has expired. Options: The County's legislative program can be managed in a variety of ways, including: • Renewing the current contract with Pac West. • Issuing a request for proposals soliciting interest from qualified firms to provide lobbyist and legislative services and enter into a new contract with the successful proposer. • Recruit and hire a County staff person to coordinate legislative activities and lobby on the County's behalf. Timeline: Preparation for the 2021 legislative session officially begins in September when pre -session requests for proposed legislation are due. To ensure that the County is ready and able to act by then, arrangements for lobbying and legislative services should be in place by mid -August. .µm .VI itit�fI4. e�7 L, { ,4.,ii Dear Community Partner, I would like to let you know the current status of Deschutes County Behavioral Health (DCBH) services and what we are doing to respond to the COVID-19 crisis. As we navigate this difficult circumstance, DCBH will need to balance our commitment to serving the most vulnerable with ensuring some measure of safety for our clients and staff. While finding that balance will at times be hard, we are committed to doing everything thing we can to ensure that our clients, staff and community have continued support as we face the challenges ahead. Social distancing is a high priority. We are taking steps to comply with this direction by moving many services to phone or video visits, decreasing meetings, and allowing staff to work remotely where possible. We will also continue to provide services to the community and take precautionary steps as follows: • Screening for COVID-19 risk is occurring at each location. Clients are being asked about travel and symptoms on the phone and in person at all locations. If they have positive answers they are encouraged to receive services by phone or wear a mask during their care. Access to services: o DCBH offices remain open for services with an abbreviated crew of staff working on site, and many others working from remote locations. Most services are now being provided via telephone or video options. Services that must be provided in person, such as injections and some crisis services are available. o limiting in -person visits. DCBH is asking that people conduct business with us over the phone rather than coming into the office whenever possible. Many employees are working remotely and have the ability to use telephone and user friendly video platforms such as Face Time, What's App and Skype to provide behavioral health services. You should be able to use the normal means to reach our offices and staff. a How to reach us: o For regular business, DCBH can still be reached at 541-322-7500. o For Crisis dial 541-322-7500 ext. 9 / (800) 875-7364. Other Efforts: While we work to continue providing behavioral health services as usual, we are also looking for ways to support our community through this crisis: o We have provided the attached talking points and guidance around attending to your mental health care to community partners. o We are reaching out to the emergency community response to provide behavioral health information, resources, talking points and positive messages as appropriate. I truly believe that communities are at their best during times of adversity. This is often when we see evidence of the best in us, kindness, flexibility, strength and inventiveness. I'm very proud to work with each of you and grateful for the quality of our community partnerships. It will be important to look for ways to support each other, extend grace and believe that everyone is doing their best in tough circumstances. Please reach out with questions. Remember that things are changing quickly, so you may rely on our website and Facebook page for updates. 2577 NE Courtney Drive, Bend, Oregon 97701 (541) 322-7500 �'ta healthservices@deschutes .org (D)www.deschutes.org/health Best regards and stay well, Janice Garceau, Behavioral Health Director Deschutes County Health Services (541) 322-7664 / Janice.garceau@deschutes.org 3118120 Dr. Wil Berry and Morgan Emerson helped draft the below talking points related to managing anxiety about COVID-19. They include a link to the DCHS COVID-19 webpage and an excellent resource for talking with children about what they may be hearing and seeing in the media. These are intended to support you as individuals and also your work with clients and community members who may be fearful and have questions. 1. Stories about COVID-19 on the Internet may be based on rumors and inaccurate information. You can look to Deschutes County Health Services for accurate information at: http://www.deschutes.org/covidl9 2. We know that for most people, COVID-19 is a mild illness that may cause symptoms such as fever, cough, and shortness of breath. 3. Constantly watching updates on the status of COVID-19 can increase anxiety —avoid this. 4. Recognize that feelings of anxiety and worry are normal and to be expected in a situation like this one. Acknowledge these feelings when they are present and remind yourself that they are normal. 5. Take care of yourself and make time to: get enough sleep, eat healthy, exercise, and talk to others. If COVID-19 is elevating anxiety, create a plan with a support person to develop tools to manage anxiety. 7. Take care of your own mental health. Consider your own internal strengths and remind yourself of who in your community you can go to for support. 8. Know when to get help. While being upset and worried is normal, there are times to get help. These include a persistent inability to sleep, increasing drug/alcohol use, an overwhelming sense of depression or panic, and an inability to take care of yourself or those who depend on you due to distress. Another sign you should urgently seek professional help is if you have any urges to harm yourself or anyone else. 9. Take steps to prepare. Even when there are some things out of our control, there are always things that we as individuals and communities have control over. One of the best ways to protect your own mental health in a crisis is to do the things you can to prepare and help for yourself and others. 10. Remember that there are things we can do that protect us from COVID-19 or other infectious diseases: 1. Wash your hands often 2. Avoid close contact with people who are sick. 3. Avoid touching your eyes, nose, and mouth. 4. Stay home when you are sick. 5. Cover your cough or sneeze with a tissue, then throw the tissue in the trash. 6. Clean and disinfect frequently touched objects and surfaces. 11. Consider the opportunity. While a crisis is a time of increased stress, it is also a time when people discover resilience in themselves and their communities. Be open to being surprised by your own strength and that of your neighbors and family. One day, your memories of a crisis may be painful, but they may also be a sense of pride and accomplishment. 12. If you have questions about talking to children about COVID-10, this is a good resource: Talking to Children About COVID-19 (Coronavirus): A Parent Resource • Take care of yourself. Get enough sleep, eat healthy, exercise, and talk to others. • Think about the ways that you are strong and remind yourself of who you can go to for support. • Remember that for most people, COVID-19 is a mild illness. • Get help when you need it. If you are drinking or using substances more, not able to sleep, not able to take care of yourself or others, or feel overwhelmed by sadness or fear, ask for help. • Get help right away if you have any urges to harm yourself or anyone else. • Call your doctor if you have fever, cough or shortness of breath. • Get facts about COVID-19 from sources you can trust, like Deschutes County Health Services or the Centers for Disease Control (CDC). THE CRISIS PHONE LINE IS AVAILABLE 24 HOURS A DAY AT (541) 322-7500 X9 OR BY CALLING (800) 875-7364 (TOLL FREE) HEALTH SERVICES WWWMESCHUTES.ORG/COVI Protect Yourself and Our Corn m u n 9 Wash your hands often with soap and water for at * If soap and water are not available, use a hand • Avoid touching your eyes, nose, and mouth. • Avoid close contact with people who are sick. • Put distance between yourself and other people if COVID-1 9 is spreading in your community. • Cover your mouth and nose with a tissue when you cough or sneeze or use the inside of your elbow. • Clean and disinfect frequently touched surfaces daily. • Stay home if you are sick, especially with fever, cough, or shortness of breath. • Call ahead toyour doctor if you need medical care. •Stay informed with reliable information from Deschutes County® www.deschutes.org/covidl 9 or CDC: www.coronavirus.gov HEALTH SERVICES I'D • Duerma to suficiente, coma sano, hags ejercicio y hable con otras personas. • Piensa en las formas en que fuerte y recuerda con quien puede it para obtener ayuda. • Recuerda que, para la mayoria de las personas, COVID-19 es una PnfermPdarl leve. • Obtenga ayuda cuando la necesite. Si esta' bebiendo o uuando sustancias de ma's, no puede dormir, no puede cuidarte a si mismo ni a los dema's, se sientes abrumado por la tristeza o el miedo, pida ayuda. • Obtenga ayuda de inmediato si tiene alguna necesidad de hacerse dano a usted mismo o a alguien ma's. • Llame a su medico si tiene fiebre, tos o dificultad para respirar. • Obtenga datos sobre COVID-19 de fuentes en que pueda confiar, como el Servicios de Salud del Condado de Deschutes o los Centros de Control de Enfermedades conocido por sus siglas en ingles (CDC). LA LINEA DE CRISIS ESTA DISPONIBLE LAS 24 HORAS AL DIA (541) 322-7500 EXT. 9, O PUEDES LLAMAR AL (800) 875-7364 SIN COSTO. ��zEs co C G HEALTH o SERVICES WWW.DESCHUTES.ORG/COVID19 i �.. 1 Ai v it s i s t E s ! i� c. • Lavese las manos con frecuencia con agua y jabon durante al menos 20 segundos. • Si no hay agua y jabon disponibles, use un desinfectante pars manos con al menos 60% de alcohol. • Evite tocarse los ojos, la nariz y la boca. • Evite el contacto cercano con personas enfermas. • Mantenga distancia entre usted y otras personas si COVID-19 se esta extendienao en su comuniaaa. • Cubrase la boca y la nariz con un panuelo cuando tosa o estornude o use la parte interna del codo. • Limpie y desinfecte las superficies que frecuentemente son tocadas diariamente. • Quedese en casa si esta enfermo, especialmente con fiebre, tos o dificultad para respirar. • Llame con anticipacion a su medico si necesita atencion medica. Mantengase informado con informacion confiable del Condado de Deschutes: www.deschutes.org/covidl9 o CDC: www.coronavirus.gov �`f 2HEALTH o SERVICES