The URL can be used to link to this page

2021-5-Minutes for Meeting December 21,2020 Recorded 1/6/2021�G�vTES ",0 BOARD OF COMMISSIONERS 1300 NW Wall Street, Bend, Oregon (541) 388-6570 i1 • Recorded in Deschutes County Nancy Blankenship, County Clerk CJ2021 _5 Commissioners' Journal 01 /06/2021 3:09:13 PM II'II 2021-5 Barnes Sawyer Rooms Live Streamed Video Present were Commissioners Patti Adair and Anthony DeBone. Commissioner Henderson was absent/excused. Also present were Tom Anderson, County Administrator; David Doyle, County Counsel (via Zoom conference call); and Samantha Pepper, BOCC Administrative Assistant (via Zoom conference call). Attendance was limited in response to Governor's Virus orders. CALL TO ORDER: Chair Adair called the meeting to order at 1:01 p.m. PLEDGE OF ALLEGIANCE ACTION ITEMS: 1. Discussion: Stevens Ranch/ Section 11 Administrator Anderson states that owner and developer of Stevens Ranch Gary Miller purchased the Section 11 property east of Bend. His legal representative Tia Lewis was available to present the planned development. Miller is hoping to submit a Master Plan to the City of Bend by the end of January 2021. Wilderness Way will be the main entrance. This project is going - to contribute over $22 million inSTC taxes to the City. This development includes 358 acres. There is concern over the amount of historical waste on BOCC MEETING DECEMBER 21, 2020 PAGE 1 OF 6 the property that will be trucked to Knott Landfill. Commissioner DeBone mentions that this would be an investment to the community. Ms. Lewis mentions that portions of the development project may be managed by a non-profit organization. Commissioner Adair asked Solid Waste Director Timm Schimke what the cost of the tonnage would be. For the first three pods the estimated cost would be around $1 million or more. There is estimated to be 15-25 thousand tons for the first three pods. Commissioner DeBone would like to set up a good relationship between the county and the developer but he does not see the county (and rate -payers at the landfill) partnering in this development. Mr. Anderson mentions that the waste will be coming to the Landfill whether they partner together or not. Commissioner Adair mentions that she is unsure with our current landfill status. Ms. Lewis goes on to say that there will be 2,000 livable units on the property. Commissioner DeBone would not be opposed to further exploring whether there is a viable outcome associated with reduced landfill fees as an incentive for additional affordable housing units. Discussion will continue to a future meeting. 2. COVID19 Update County Public Health Director Nahad Sadr- Azodi updates Commissioners on the latest pandemic statistics. He mention that several of the numbers have not been updated from last week as new numbers will come out in the next 24 hours from Oregon Health Authority. Commissioner DeBone asked how contact tracing is going. He also asked Health to remind/inform the community of the basics of COVID in the upcoming weeks. Mr. Sadr- Azodi reminds the public to choose their sources of information carefully. Restaurants and Brewery Letter of Support to Oregon Health Authority: Communication Director Whitney Hale states that a draft letter has been prepared in coordination with the County Environmental Health department. Environmental Health has reached out to OHA regarding the proposed changes to the guidelines. DEBONE: Move approval of Restaurants and Brewery Letter to OHA BOCC MEETING DECEMBER 21, 2020 PAGE 2 OF 6 ADAIR: Second VOTE: DEBONE: HENDERSON: ADAIR: Yes Absent Chair votes yes. Motion Carried 3. Consider Approval of a Federal Public transit Match to Support La Pine Public Transit Communications Director Whitney Hale states that the Commissioners review this application every two years for Cascade East. Video lottery funds are used from the county to provide the match for the City of La Pine. She asked if the county was still willing to be the applicant. Commissioner DeBone asked who else could be the applicant. With changes to the funding process, and access to STIF funds, the City could be. DEBONE: Move approval of Federal Public transit match and application submission for La Pine Public Transit ADAIR: Second VOTE: DEBONE: Yes HENDERSON: Absent ADAIR: Chair votes yes. Motion Carried 4. Consideration of Chair Signature of Document No. 2021-015 Amendment to Medcor Agreement Human Resource Director Kathleen Hinman explains the one-year extension amendment to the Medcor Agreement. DEBONE: Move approval of Chair signature of Document No. 2021- 015. ADAIR: Second BOCC MEETING DECEMBER 21, 2020 PAGE 3 OF 6 VOTE: DEBONE: HENDERSON ADAIR: Yes Absent Chair votes yes. Motion Carried 5. Consideration of Chair Signature of Document No. 2021-016, Amendment to Premise Health Agreement Human Resource Director Kathleen Hinman explains the one-year extension amendment to the Premise (pharmacy) Agreement. DEBONE: Move approval of Chair signature of Document No. 2021- 016. ADAIR: Second VOTE: DEBONE: HENDERSON: ADAI R: Yes Absent Chair votes yes. Motion Carried 6. Consideration of Board Acceptance of Central Oregon Health Council COVID-19 Relief Funds and Resolution No. 2020-072, Increasing Appropriations and FTE in Health Services Fund Health Services Business Manager Cheryl Smallman introduces Resolution No. 2020-072. Also joining her were Daniel Emerson, Janice Garceau and Nahad. Commissioner DeBone asks about QIM funds. Ms. Garceau states that it is a shift in adjusting the metrics at the state and local level. Mr. Sadr- Azodi briefly mentions the duties of the County Health Officer position. DEBONE: Move approval of Board signature of Resolution No. 2020- 072 and accepting COHC COVID19 Relief Funds. ADAIR: Second VOTE: DEBONE: Yes BOCC MEETING DECEMBER 21, 2020 PAGE 4 OF 6 HENDERSON: Absent ADAIR: Chair votes yes. Motion Carried 7. Deschutes County Treasurer and Finance Report for November 30, 2020 County Chief Financial Officer Greg Munn updates Commissioners on county financials for November 2020. 8. 2021 Arts & Culture Grant Follow- Up Administrative Analyst Laura Skundrick states that there was a calculation error last week when reviewing 2021 Arts & Culture Grants. She is back to go over the $3,000 that was over allocated. She will work with Finance to identify funds in Video Lottery or Transient Room Tax that could be utilized, with Board approval, to fund the $3,000 shortage. Commissioners agree to examine the Video Lottery and Transient Room Tax fund totals before making a final determination. OTHER ITEMS: Administrator Anderson mentions the support letter for the City of Bend's Turnkey Project. Commissioner Adair suggests minor edits to the first paragraph. DEBONE: Move approval of Support Letter to the City of Bend's Turnkey Project. ADAIR: Second VOTE: DEBONE: Yes HENDERSON: Absent ADAIR: Chair votes yes. Motion Carried BOCC MEETING DECEMBER 21, 2020 PAGE 5 OF 6 EXECUTIVE SESSION: The Board went into Executive Session at 3:13 p.m. under ORS 192.660 (2) (e) Real Property. The Board came out of Executive Session at 3:15 p.m. Information only. The Board went into Executive Session at 3:15 p.m. under ORS 192.660 (2) (d) Labor Negotiations. The Board came out of Executive Session at 3:32 p.m. Staff to proceed as discussed. f r° Being no further items to come before the Board, the meeting was adjourned at 3:32 p.m. OC91 DATED this Day of 1�uq—' 0 for the Deschutes County Board of Commissioners. TTI ADAIR, CHAIR PHILIP G. HENDERSON,COMMISSIONER r BOCC MEETING DECEMBER 21, 2020 PAGE 6 OF 6 i E S C00 Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - www.deschutes.org BOCC MEETING AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:00 PM, MONDAY, DECEMBER 21, 2020 Barnes Sawyer Rooms - Deschutes Services Center - 1300 NW Wall Street - Bend This meeting is open to the public, usually streamed live online and video recorded. To watch it online, visit www. deschutes. org/meetings. Pursuant to ORS 192.640, this agenda includes a list of the main topics that are anticipated to be considered or discussed. This notice does not limit the Board's ability to address other topics. Item start times are estimated and subject to change without notice. CALL TO ORDER MEETING FORMAT In response to the COVID-19 public health emergency, Oregon Governor Kate Brown issued Executive Order 20-16 (later enacted as part of HB 4212) directing government entities to utilize virtual meetings whenever possible and to take necessary measures to facilitate public participation in these virtual meetings. Since May 4, 2020, meetings and hearings of the Deschutes County Board of Commissioners have been conducted primarily in a virtual format. Attendance/Participation options include: Live Stream Video: Members of the public may still view the BOCC meetings/hearings in real time via the Public Meeting Portal at www.deschutes.org/meetin&s. In Person Attendance: Limited due to Virus restrictions. Please contact Sharon Keith at sharon.keith@deschutes.org prior to the meeting to request in person attendance. Citizen Input: Citizen Input is invited in order to provide the public with an opportunity to comment on any meeting topic that is not on the current agenda. Citizen Input is provided by submitting an email to: citizeninput@deschutes.org or by leaving a voice message at 541-385-1734. Citizen input received before the start of the meeting will be included in the meeting record. - -Zoom Meeting Information:__ Staff and__ citizens_ that are presenting_ agenda_ items to the Board for consideration or who are planning to testify in a scheduled public hearing may participate via Zoom meeting. The Zoom meeting id and password will be included in either the public hearing materials or Board of Commissioners BOCC Meeting Agenda Monday, December 21, 2020 Page 1 of 3 through a meeting invite once your agenda item has been included on the agenda. Upon entering the Zoom meeting, you will automatically be placed on hold and in the waiting room. Once you are ready to present your agenda item, you will be unmuted and placed in the spotlight for your presentation. If you are providing testimony during a hearing, you will be placed in the waiting room until the time of testimony, staff will announce your name and unmute your connection to be invited for testimony. Detailed instructions will be included in the public hearing materials and will be announced at the outset of the public hearing. PLEDGE OF ALLEGIANCE ACTION ITEMS 1. 1:00 PM Discussion: Stevens Ranch/Section 11, County Administrator Tom Anderson 2. 1:30 PM COVID19 Update 3. 1:40 PM Consider Approval of a Federal Public Transit Match to Support La Pine Public Transit - Whitney Hale, Communications Director 4. 1:55 PM Consideration of Chair Signature of Document No. 2021-015, Amendment to Medcor Agreement - Kathleen Hinman, Human Resources Director 5. 2:05 PM Consideration of Chair Signature of Document No. 2021-016, Amendment to Premise Health Agreement - Kathleen Hinman, Human Resources Director 6. 2:15 PM Consideration of Board Acceptance of Central Oregon Health Council COVID-19 Relief Funds and Resolution No. 2020-072, Increasing Appropriations and FTE in Health Services Fund - Dan Emerson, Budget Analyst 7. 2:25 PM Deschutes County Treasurer and Finance Report for November 30, 2020 - Greg Munn, Chief Financial Officer 8. 2:55 PM 2021 Arts & Culture Grant Follow -Up - Laura Skundrick, Administrative Analyst OTHER ITEMS Board of Commissioners BOCC Meeting Agenda Monday, December 21, 2020 Page 2 of 3 These can be any items not included on the agenda that the Commissioners wish to discuss as part of the meeting, pursuant to ORS 192.640. EXECUTIVE SESSION 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. Executive Session under ORS 192.660 (2) (d) Labor Negotiations and ORS 192.660 (2) (e) Real Property ADJOURN 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. n% kip 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.or /g 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, December 21, 2020 Page 3 of 3 LEGEND PROPERTY BOUNDARY APPROX, LOCALITY OF FACILITY 0 CAVE LOCATION A Q CP-2 CONTROL POINT APPROXIMATE EXTENT OF tn DEBRIS BASED ON PBS FIELD OBSERVATIONS AND NGA GEOPHYSICAl- co ASSESSMENT, 2008 an SURVEYED BY HHPR, 12/08 APPROXIMATE CUMULALITVE WASTE AREAS 18,6 ACRES I 1�. ui Development Information Site Area Tax Lot# 1812110000200 = 282,9 Acres Agency - Deschutes County, Oregon Nogg; 1. aria reap Inforrna66n Based on Boundary Pod'ropogrophtb Survey, 015 data oblainad (ttint besoiuta6 County & Microsott Bing Mips. Boundary and iopographlc aurvey provided by Sun Country dated 08/21/2020. ©OWL nay hotvenfied the amauty of this information, Legend Zoning FPS - Standard Density Residential Zoning RM - Medium Density Residential iL Zoning RH - High Density Residential zoning CG - Commercial General u Zoning CL 1 Commercial Limited zoning IG = Generai Industrial Existing Site property Lines Existing property Lines Urban Growth Boundary Future Bend City Limits Proposed Right -of -Way Proposed Shared -Use path McNe-r 6Yan I-.* re Singh Farnliy T"5ra1 dp€n &Apa7i—t 00iat6d Bunt€. fdRiex 0#11I&anal N6 tHiMirld'Af rand ik® Zoo AaeV S11d[E- uBN§ (Intl§ Unit§ unit§ unit§ 9f Standard RS 189 269 964 55 36 M§divn b-oy Io jd€nt;al RfA 29.6 24 466 pig), r nyR---rim nN log A r91 Cort=A 6enviil SG 29.9 4 J W 311986 torrircarc,if Lmifed U 11 24 184.136 Ccn€ral f1l"I iaf I6 07 1,of4,4-1B 761a1 UM AfBd 3623 7ot14 940demidl units 1,3§§ 904 §6 g6 2,395 rafdV Nvn-Nesfd€M1dl 5f 1,919,064 16fal OP4.90d(p It,5,� ' Ail Are.A Glc<s `-pq"cJ.lh, a[—t„u,n,.—oEa„'pace. M L R 12/15/2090 WWW. OOWL.COM 720 SW Washington Street #750 -Portland, Oregon 47205 g71=2M8441 Project 2122-14647-01 Steven's 306 _ b 300 Ranch S arE, 1N FEEL Contact: Read Stapleton AICP Master Plan Beni., Oregon f ig{1re.R-3. RQ@cly✓ay NefworR( a+)d Adjacent Mll��i �uon 7 iti +ii ty, Page 111 Aripvlub Ai i ij f �LYA jNqjphborbuod goof@ E 4, PrOP(ANi I ()�dvloy 0 0s S(ldions. Page 5 Development Information Site Area Tax Lot # 1812110000200 = 382.05 Acres A9encY - Deschutes County, Oregon Notae: 1. Base map information based on Bnendary and Topographic Survey. CIS data obtained Irom Descbctes Ccunry 8 P.1'KrosoR Bing Maps. Boucdary and Topographic Survey prosided by Sun Country dated 0&2712020. DOWL hes ncl vented theaauracy of lhis informaticn. Legend Zoning RS - Standard Density Residential Zoning RM - Medium Density Residential Zoning RH - High Density Residential Zoning CG - Commercial General Zoning CL - Commercial Limited Zoning IG - General Industrial �..�.- Potential Elementary School - - Existing Site Property Lines ---- Existing Property Lines MWA e WX Urban Growth Boundary Bend City Limits -----,•---- Existing Contours -2'Interval — Proposed 10' Paved Shared -Use Path Proposed 10' Soft Surface Trail �^ Proposed 6' Public Sidewalk £ Proposed 4' Public Open Space Trail — — — — Proposed 4' Private Open Space Trail Future Utility Pipeline Trail (By Others) COID Canal - Existing Informal Trail been kesfd-tW Noe•kesW. Val Al denfiel Nen-fiesfdeef$al teed tke San. Acres' Spaea Unff pot A— FAA $Jeffs Sf Standard Density k¢sidentiA RS 1534 3 7 1,074 Medium Gensiry Resift ntwf AM 21.6 19 17 40 I igh 0—ity Resldential RH 36.9 4.5 211 Of C.mmr'161 General CG 202 5.1 0.25 317,988 C..re-al Urrif2d CL 17 1.7 025 135,IM Genefal lnnu111111 IC 921 0.25 1,WJ,503 Utul All2.n 356.8 €lemeefary School 16.5 f5pre Spa e 208 20A T.fal lead Ate. 192.1 TofAI 11es1d.0041 UtI 2,214 Total Nan=k€sldanfia gr 1,§12,621 Total open Sp.e. 9.74 'All Ar,,s are Cross (C to/ufi9 of k6Wf ZONIIIe RAI I I l� 1 i�r� N i 300 SCALE Stevens Ranch D O W L Contact: Read Stapleton AICP Date: 12/09/2020 720 SW Washington Street, #750 Parks and Open Space Exhibit Po^land, Oregon -8641 p P Bend, Oregon Project 2122.14647.01 97,-zoo-064, : ID e4 ID ri All - m 40 µA � s iir y� s w w r1i fli U-) (lu a Ul 0 Ul 0 Url CD Ul CD CD CD CD CD (D 0 0 C:) 0 0 (D 0 0 0 0 C) 0 po 0 L/I r+ (D r+ 0 3 (D O 0 PO (D rD M. 0 (D -0 E3 =, 0 0 OJ a -0 L'I (D rD Z3- 77 ca. C: �i Ln 0 (D 19 O ov rCases Nm .�/ u-1 0 v o u o u ® LnCD � �? ca ® ® CD ® ® Q o � 'i rD p :3 hrD Qi CD- �. 9S?/ i O N fD /� fD S19 In Di Ln S 00 m S/� tA o0 Ln M •}' Sis' N w 0-0 nDi H 611 /61 O m � Q6 iI N Qj In (A Qj M �i 00 P!. v a > 1� ouo m 61 o 0 n Ul �/9 N tp/� 1S Ul m �V N 9 �9 Oo 1/ UJ 1� CD 0 � 9/ Q, .IO 6' /� -h a ® 00 00 cn V � -P I 11 O O O O O O O O O O O O O O O O O O O o I J N O N w O W Q0 W U'l Ln O m W O n i 0� < rD v v 2: v m I 3 m cu W 0 °LQ n coat Qv N rD O n � 0 0 rD n - O in rD o ,aq � No rt fD � rD 0CL v 0OD c c o0 rn n n rr (D t Q) 0 � D(A (D n rr r0 rr v :3 <CTrD ro0c- r* � r� (D�'o 0� ro (D -0 (A ;a0 c m N � —OOq °�^0 0-rt Q� Grob E < W o cn (D m rrt (D 't n � rt rD 0 0 v r < CT 00 C � 3 '0 0 `:� O0 < 0 o� (m V r r-r � 0 v It 3 n 0 c It � fl, v 0 CL c a 07 e-! M Q. rr M CA OrQ r 5' O 0 3 O rt M O O N \ W N a' M OJ flJ• r M 0' rr M Qa r4 M 0) p M 7 O O O O O N \ N Number of ELRs 1--� N W •P In Ol V 00 `/� 9,� O O O O O O O O O ID IM El S/ S/' 0 0. N P'F z � � 0S/16. m < 6/ 6i �16 � 0 i 119 �6.' �69 /S 9 / �19 0 9/� 1 1,17 O/ 5,10/ 1/ 1 11� st l7-771 �/1 0 C New case rate (Rolling 2-week period) v r+ rD �l%l H r� iIj tv W w 4�!- � u-r o =r S, 11 o ul 0 ® 0 cn ® 0 to CD ® ® � to � ® � cn 0 i O v — CD p N (A C -h �- O rD rr n =r r* fD O N 0) m :3 fD 0'Q X '; CD fD O Q O —h I �j IV iD fCrCr 07 m O� e-f 07 s w O o O ® ma - 0 ® n' 1 3:�-0 (D m C m m rD W m M m ® =3 m Ln rD 3 des c _ - --- - -- - 0) m � -o m -(D y G m ®- �- m -A m 3 m m 0— CrQ m O C Cu e' r r+ m (D Q. � (Ao n < 3 L O O v3 — (D aj r+ :3"S Q n (N N C O (D r+ n O- r+ mr-r O N a) m � fD OrU T� (D .a M M O� CL O h N G1 N m G a) Cr m cn Percent Positivity (Rolling 2-week period) F" tv -rh 0') 00 0 00 i� 0 m V 0 -�9 ® 0 ® n ® 3 (D (D (D � (D O O : un n O n O rr O -� (D n O ® \ m m C° O Ln < rD 3 O V)• < Or4 r+ rD w NJ 0 0 0 0 0 0 0 o po 6' 0 PO 0 PO 0 PO 19 PO �J O 3 ai r-F O i N 00 0 (D N n 7T O r-t (D V) n O c l< n N N N (D rD 7 ZT O N r=-r N CD Q O 0 O IR 0 N O 0 w O 0 -01 -P O 0 U'1 O 0 O IlP 00 O 0 < y- --- - -- --0 0 OR rn fcn O O O 0 c 93 0 c Er 6 rr U, 3 ct 0 0 0 C.) 0 < 0 < to 0 V) ■ 6 0 k \�\ \ CL 0 c CL o 4 0 A A CD W, Co Itics 0 �4 J- I - to(D o -ig 17, c-, (Ij 0 CL f.n IN- rn 'Av1 F S Co o Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - Fax (541) 385-3202 - https://www.deschutes.org/ AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of December 21, 2020 DATE: December 11, 2020 FROM: Whitney Hale, Administrative Services, 541-330-4640 TITLE OF AGENDA ITEM: Consider Approval of a Federal Public Transit Match to Support La Pine Public Transit BACKGROUND AND POLICY IMPLICATIONS: Every two years, the Oregon Department of Transportation (ODOT) makes funds available for grants to support local public transit services and projects. One source of funding for these grants is the Federal Transit Administration's (FTA) Section 5310 Program. In the past, Deschutes County has served as an applicant for Section 5310 grants, and then has passed the funding through to local transit providers through a sub -recipient service agreement. Deschutes County and Cascades East Transit (CET) have routinely secured Section 5310 funds to support public transit services in the La Pine area. Section 5310 funds require a 10.27% match against the total project cost and, during the 2017-19 and 2019-21 bienniums, the Board of Commissioners approved using $5, 000 in video lottery funds for this purpose. During 2017-19 and 2019-21, the City of La Pine also agreed to participate in making the match payment. CET has once again prepared a grant application on behalf of Deschutes County for public transit services in La Pine during the 2021-23 biennium (see attached). The application specifies a $10,000 match during the two-year grant period. This match funding would come from Statewide Transportation Improvement Fund (STIF) funds. Staff seeks Board approval to submit the grant application for public transit services in La Pine for the 2019-21 biennium. Project applications are due by Dec. 30. ATTENDANCE: Whitney Hale, Communications Director 12/11/2020 Section 5310 Subrecipient Application FY 2021-23 Section 5310 Subrecipient Oregon Department of Transportation Application FY 2 0 21 2 3 771r"_� Enhanced Mobility of Seniors and Individuals with Disabilities This application is a tool provided to Subrecipients who want to apply to their STF agencies for 5310 projects. Transit Agency Transit Agency Legal Name Deschutes County Transit Agency DBA Name (Optional) Agency Mailing Address (Street or PO Box) 1300 NW Wall Street Bend Oregon Agency Contact Name Whitney Hale Agency Contact Email Address * Whitney.Hale@deschutes.org Employer Identification Number (EIN) Urbanized Zone 93-6002292 Oregon Are you applying to a 5310 Agency or 5310 Small Urban Agency? 5310 Lead (STF) Agency Lead (STF) Agency Name * v 97703 Agency Contact Title * Public Information Officer Agency Contact Telephone No. (541) 330-4640 For the agencies applying for small urban, make sure to select the small urban designation from the drop -down. Lead (STF) Agency Contact Name * Lead (STF) Agency Contact Title * v v in https://www.cognitoforms.com/ODOT2/Section5310SubrecipientApplicationFY202123#4YX-Yldvnf77E27kDOdPidlgZHsK4agNugRGD1tamxA$* 1/6 12/11 /2020 Section 5310 Subrecipient Application FY 2021-23 Whitney Hale Lead (STF) Agency Contact Email Address Whitney.Hale@deschutes.org This email address will receive the completed 5310 subreciplent application. Public Information Officer Lead (STF) Agency Contact Telephone No. * (541) 330-4640 Select the type(s) of service that will be supported by this award. Select all that apply. See instructions for definitions. * Open to the general public at all times Open to the general public on a space -available basis ;i; Open only to seniors and individuals with disabilities Limited to defined clientele (e.g. residential home) Demand Response Deviated Route Are any FTA-funded buildings that your transit agency owns located in a flood zone? * IPri�7iornaa�iar� Gr<<3o��dplains Yes i No Risk Assessment Information Did your agency have any turnover of management or financial staff in the last two years? Yes No Does your agency have an accounting system that allows you to completely and accurately track the receipt and disbursement of funds related to the award? Yes M What type of accounting system does your agency use? Manual Automated Combined Does your agency have a system in place that will account for 100 percent of each employee's time? Yes Did your staff members attend required trainings and meetings during prior grant award cycles? Yes Was your agency audited by the Federal government in the past two years? (_ Yes hnps://www.cognitoforms.com/ODOT2/Section5310SubrecipientApplicaGonFY202123#4YX-Yldvnf77E27kDOdPidlgZHsK4agNugRGDItamxA$" 2/6 12/11/2020 Section 5310 Subrecipient Application FY 2021-23 No Did your agency stay on budget in the past two years? Yes No Transit Agency Projects Transit Agency Project 1 Project Name * Southern Deschutes County Purchased Public Transportation Services Project Selection * A. Purchased Service C. Vehicle Purchase _ E. Equipment, Signs and Amenities, Shelters Project Details B. Mobility Management D. Capitalized Vehicle Preventive Maintenance F. Facilities: Bus Barns and Other Buildings Select the project types that you wish to include in your application. Select all that apply. A. Purchased Service Project 1. Project Title Project Title * Southern Deschutes County Purchased Public Transportation Services 2. Explain how your project is planned, designed, and carried out to meet the special needs of seniors and individuals with disabilities when general public transit is either insufficient, inappropriate, or not available: Project Service Description * Public transportation service provider shall continue to serve the City of La Pine and designated portions of South Deschutes County through demand -response (Dial -A -Ride) transportation services, which are open to the general public. Dial -A -Ride provides first -and -last -mile connectivity to regional bus service and serves as an important curb -to -curb, accessible option for older adults and those who experience disabilities. The service area map on CET's webpage https:/Icascadeseasttransit.com/routes-schedules/all-cities/la-pine/, illustrates the current service boundaries. Dial -A -Ride service in La Pine currently operates Monday throuqh Friday from 3. Estimated number of unduplicated individuals 4. Estimated number of one-way rides this project (older adults and individuals with disabilities) this proposes to provide in the biennial grant period: https://www.cognitoforms.com/ODOT2/SectiDn5310SubrecipientApplicationFY202123#4YX-Yldvnf77E27kDOdPidlgZHsK4agNugRGDltamw4$' 3/6 12/11/2020 Section 5310 Subrecipient Application FY 2021-23 project proposes to support in the biennial grant period: 2o,ssa 83 S. Project cost and match information: Total Project Cost * Match Amount (Total Project Cost x 10.27%) Grant Amount 104,796 $10,762.55 $94,033.45 6. Describe the source of your local match funds in the field below (examples: funds from your budget, STF funds). If the matching funds are not available now, describe when they will be (examples: next fiscal year, month/year). Please be specific. Local Match Details * Deschutes County Statewide Transportation Improvement Funds 7.On what page is project listed in the Adopted Coordinated Plan? 37 For multiple pages use this box B. Date Coordinated Plan adopted: 11 /2/2018 2. Is this project part of a group of activities or projects that are dependant on each other (for example, a new transit service that requires capital and operating funds)? Yes No If Yes, Provide Details of Grouped Service Activities * The following fund sources are used by the current public transportation service provider to support public transportation for the Deschutes County: - COIC's 5311 grant - COIC's 5310 vehicle preventative maintenance grant - COIC's STIF D grant supporting Community Connector service - COIC's Deschutes County STF contract 10. Does your transit agency have an existing contract for transit? Yes No If yes, name the contractor. If no, describe how the transit agency will procure the service and name �...,+.��... * https://www.cognitoforms.com/ODOT2/Section5310SubrecipientApplicabonFY202123#4YX-Yldvnf77E27kDOdPidlgZHsK4agNugRGD1tamxA$* 4/6 12/11 /2020 Section 5310 Subrecipient Application FY 2021-23 Application Totals Total Project Costs $104,796.00 Central Oregon Intergovernmental Council, operating Cascades East Transit Submitting Your Application Total Match Amount $10,762.55 Total Grant Amount $94,033.45 • Click the "Save" button to save your work. A link to the application will appear that you can copy for future reference. Or, you can enter your email address to have the link emailed to you. • Attach any supporting documents using the "Upload" button or by dragging documents from your computer to the "drag files here" area. • Electronically sign your application by using the pen icon. Type your name in the "Printed Name" section. • Submit your application by using the "Submit Application" button. • IF YOU DO NOT RECEIVE AN EMAIL RESPONSE, PLEASE CONTACT US IMMEDIATELY AT 503-966-3300 OR [)QQ 1'1L,iREi10i;IIP!( �llD ,lAIAIE 0OKJ�. Supporting Documents (Optional) or drag files here. �1s 3's-4G can rt,(-�r �E� rd Inmi�n� se��iCtS pix, fi's"II _igned.1c 5.22 MB The person signing this form must have the legal authority to submit the application on behalf of the applicant. By electronically signing and submitting this form, the agency representative certifies that the information on the application is true and accurate to the best of their knowledge. Signature * J* Printed Name * https://www.cognitoforms.comlODOT2/Section5310SubrecipientAppiicationFY202123#4YX-Yldvnf77E27kDOdPidlgZHsK4agNugRGD1tamnA$" 5/6 12111 /2020 Section 5310 Subrecipient Application FY 2021-23 https://www.cognitoforms.com/ODOT2/Section5310SubrecipientApplicationFY202123#4YX-Yldvnf17E27kDOdPidlgZHsK4agNugRGD1tamxA$" 6/6 �01 ES C0 o c Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - Fax (541) 385-3202 - https://www.deschutes.org/ AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of December 21, 2020 DATE: December 15, 2020 FROM: Greg Munn, Finance, 541-388-6559 TITLE OF AGENDA ITEM: Deschutes County Treasurer and Finance Report for November 30, 2020 DATE: December 15, 2020 TO: Board of County Commissioners FROM: Greg Munn, Treasurer and Chief Financial Officer SUBJECT: Treasury and Finance Report — November 2020 Following is the unaudited monthly finance report for fiscal year to date November 30, 2020. Treasury and Investments • The portfolio balance at the end of November was $255M, an increase of $26 million from last month and an increase of $14 million from last year. • Net investment income for the month is $209,073, approximately $22,000 more than last month. Net earnings are approximately $195,000 less than November 2019. YTD earnings are $689,000 (37%) less than last year's amount. • All portfolio category balances are within policy limits except the Local Government Investment Pool which will be managed back under the limit as tax collections are distributed and invested. • The LGIP interest rate remains at 0.75%. No change during the month. • Average portfolio yield is 1.08% down from 1.19% last month. • The portfolio's weighted average time to maturity is at 1.36 years (vs 1.15 last month) as we are buying more investments with maturities in the 3-4 year maturity range. Portfolio Breakdown: Par Value by Investment Type Municipal Debt $ 25,790,000 10.1% Corporate Notes 41,900,000 16.4% Time Certificates - 0.0 % U. S. Treasuries 10,000,000 3.9% Federal Agencies 76,590,000 30.1% LGIP 86, 741, 959 34.0 % First Interstate Bank 13,848,190 5.4% Total Investments $ 254,870,150 100.0% Investment Income Nov-20 Y-T-D Total Investment Income 214,073 1,182,356 Less Fee: $5,000 per month (5,000) 25,000 Investment Income - Net 209,073 1,157,356 Prior Year Comparison Nov-19 431,306 1,846,202 Total Portfolio: By Investment Types Category Maximums: Yield Percentages U.S. Treasuries 100% Current Month Prior Month First Interstate Municipal Debt Bank 10.1 % LGIP ($51,177,000) 100% FIB/ LGIP 0.75% 0.75% 5 a i Federal Agencies 100% Investments 1.65% 1.79% LGIP Co porate Notes �;��_. 16.4% Banker's Acceptances 25% Average 1.08 % 1.19% 34.0% Time Certificates 50% Tme Municipal Debt 25% Benchmarks CerfiAcates Corporate Debt 25% 24 Month Treas. 0.16% 0.0% LGIP Rate 0.75% U. S. Treasuries Weighted Ave Matur' 36 Month Treasury 0.19% Federal 3.9 % Agencies Max 3.54 Years 1.36 Term Minimum 0 to 30 Days 10 % Under 1 Year 25% Actual 39.5% 59.9 % Portfolio by Broker Under 5 Years 100% 100.0% $120 $103.3 N s $100 Other Polic Actual Corp Issuer 5% 2.6% $60 Callable 25% 17.4% $40 $20 7 — CC,dit WIA AAZ _ AA1 $- em DA Moreton Great Robert W Piper Castle Investment Activity Davidson Capital Pacific Baird R Sandler Oak Purchases in Month $ 26,150,000 Markets Securities Co SaleslRedemptions in Month $ 5,810,000 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 Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr MayJune July Aug Sept Oct Nov — County Rate — 2 year Treasury Rate Corporate Bond Rate --- LGIP Rate Three Year Portfolio Balance n (b CO w w x w W Co W w M w M M M M M M M M M M M 0, O O O O O O O O O O O �y ry ci N iy ,-y f-1 c-1 �—I ri i—I rl ri a"i rho v Q- ro v o a"i m n m 5 aQi " o a�i r�o '� �- a�i o o a Q o z o¢ a o z o a ¢ z 20,000,000 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 As of 09.30.20 N As of 11.30.20 Deschutes County Investments Purchases made in November 2019 Portfolio Management Purchases made In November 2020 Portfolio Details - Investments November 30, 2020 Purchase Maturity Days To Ratings Coupon Par Market Book Inv; Inv Ty_•,. CUSIP Security Broke:' Date Date ,1 Maturi ' Illool.' &P11 - Rat, • YTM3 • Value - Value Value - 10719 MCI 06051GEE5 Bank of America Corp CASTLE 10/22/2019 1/5/2021 35 A2 A- 5.875 1.883 2,000,000 2,010,222 2,007,416 10758 MCI 89233P4S2 Toyota Mir Cred -CorpN Pi 3/25/2020 1/11/2021 41 Al A+ 4.250 2.796 2,000,000 2,008,682 2,003,164 10745 MCI 94988J5M5 Wells Fargo Corporate Note CASTLE 1/9/2020 1/15/2021 45 Aa2 A+ 0.547 1.221 3,000,000 3,000,970 3,000,907 10725 MUN 73209MAC1 POMONA CALIF REDEV AGY Pi 11/22/2019 2/1/2021 62 A+ 3,406 1.800 1,300,000 1,305,759 1,303,424 10735 MCI 90331HPA5 US Bancorp Pi 12/6/2019 2/4/2021 65 Al AA- 3.000 1.850 2,000,000 2,004,967 2,003,958 10722 FAC 860591EL2 Tennessee Valley Authority CASTLE 11/5/2019 2/15/2021 76 Asa AA+ 3.875 1.650 2,000,000 2,015,124 2,009,009 10739 TRC 912833LC2 U.S. Treasury CASTLE 12/11/2019 2/15/2021 76 Asa AA+ 0,000 1.724 3,000,000 2,999,196 2,989,566 10740 TRC 912833LC2 U.S. Treasury CASTLE 12/13/2019 2/15/2021 76 Aaa AA+ 0.000 1.724 2,000,000 1,999,464 1,993,043 10687 VR2 89236TEV3 Toyota Mir Cred - Corp N CASTLE 1/9/2019 4/13/2021 133 Al A+ 0.504 2.218 2,000,000 2,002,085 1,998,013 10702 VR2 06051GFV6 Bank of America Corp CASTLE 5/31/2019 4/19/2021 139 A2 A- 1.638 3.045 1,050,000 1,055,646 1.054,434 10706 MUN 801577NR4 SANTA CLARA CNN CALIF FING.CASTLE 7/2/2019 5/1/2021 151 AA+ 2.050 2.263 1,095,000 1,101,778 1,094,925 10700 MCI 06051GEH8 Bank of America Corp CASTLE 5/9/2019 5/13/2021 163 A2 A- 5.000 2.700 1,560,000 1,592,240 1,575,610 10757 MCI 09247XAW Federal Home Loan Mtg Corp CASTLE 3/25/2020 5/24/2021 174 Aa3 AA- 4.250 2.658 2,000,000 2,038,333 2,014,947 10741 TRC 9128286V7 U.S. Treasury CASTLE 12/13/2019 5/31/2021 181 Aaa 2.125 1,702 5,000,000 5,050,780 5,010,308 10667 MCI 695114CM8 Pacific Corp CASTLE 11/29/2018 6/15/2021 196 Al A+ 3.850 3.350 1,170,000 1,182,152 1,172,993 10672 MCI 695114CMB Pacific Corp CASTLE 12/6/2018 6/15/2021 196 Al A+ 3.850 3,351 830,000 838,621 832,122 10692 MCI 695114CM8 Pacific Corp CASTLE 2/22/2019 6/15/2021 196 Al A+ 3.850 2.850 2,000,000 2,020,773 2,009,269 10708 FAC 3133EKVC7 Federal Farm Credit Bank CASTLE 7/29/2019 7/19/2021 230 Asa AA+ 1.875 1.875 3,000,000 3,033,951 3,000,000 10721 TRC 91282871`1 U.S. Treasury CASTLE 10/31/2019 7/31/2021 242 Aaa 1.750 1.631 5,000,000 5,055,080 5,003,846 10705 MUN 797398DK7 SAN DIEGO CNTY CALIF PENSIOfCASTLE 7/1/2019 8/15/2021 257 Aa2 AAA 5.836 2.000 2,000,000 2,077,160 2,052,702 10696 AFD 88059E4M3 Tennessee Valley Authority CASTLE 4/18/2019 9/15/2021 288 Aaa AA+ 2.373 2.536 1,020,000 1,018,534 1,000,634 10648 MCI 45905UC36 International Bonds for Recons CASTLE 7/16/2018 9/28/2021 301 Aaa AAA 2.000 2.967 2,000,000 2,029,754 1,984,892 10731 MCI 94988J5T0 Wells Fargo Corporate Note CASTLE 12/5/2019 10/22/2021 325 Aa2 A+ 3.625 1.950 2,000,000 2,054,107 2,029,179 10724 FAC 3130AFUYO Federal Horne Loan Bank CASTLE 11/8/2019 11/19/2021 353 Aaa AA+ 1.625 1.711 3,000,000 3,044,160 2,997,558 10744 FAC 3130AHSR5 Federal Home Loan Banc CASTLE 12/20/2019 12/20/2021 384 Aaa AA+ 1.625 1.680 3,000.000 3,047,013 2,998,295 10732 MCI 46625HJD3 JPMorgan Chase - Corporate N Pi 12/6/2019 1/24/2022 419 A2 A- 4.500 2.010 2,000,000 2,095,440 2,055,626 10654 MCI 695114CP1 Pacific Corp CASTLE 9/25/2018 2/1/2022 427 Al A+ 2.950 3.320 700,000 716,642 697,155 10803 MUN 45201YT49 Eugene Power GPAC 11/24/2020 2/1/2022 427 Aa2 AA 2.750 0.470 1,410,000 1,443,741 1,447,349 10726 FAC 3133EKCYO Federal Farm Credit Bank CASTLE 11/21/2019 3/14/2022 468 Asa AA+ 1.950 1.849 5,000,000 5,019,576 5,005,105 10730 FAC 3133EKCYO Federal Farm Credit Banc CASTLE 11/29/2019 3/14/2022 468 Aaa AA+ 1.950 1.838 5,000,0D0 5,019,576 5,005,652 10720 MCI 90520EAF14 MUFG Union Bank CASTLE 10/25/2019 4/1/2022 486 A3 A 3.150 2.038 2,000,000 2,070,021 2,028,789 10750 MCI 90520EAF14 MUFG Union Banc CASTLE 2/5/2020 4/1/2022 486 A3 A 3.150 1.811 1,000,000 1,035,010 1,017,417 10759 MCI 037833CP3 Apple Inc CASTLE 3/27/2020 5/11/2022 526 Aal AA+ 0.603 1.777 1,000,000 1,004,499 984,945 10733 MCI 084664BT7 Berkshire Hathaway Inc MORETN 12/6/2019 5/15/2022 530 Aa2 AA 3.000 1.740 2,000,000 2,081,519 2,035,752 10652 MUN 686053BQ1 Oregon School Boards Assoc MORETN 9/14/2018 6/30/2022 576 Aa2 AA 5.480 3.120 925,000 996,826 957,281 10804 MUN 45201YT56 Eugene Power GPAC 11/24/2020 8/1/2022 608 Aa2 AA 2,850 0.500 1,430,0D0 1,481,094 1,485,692 10748 FAC 3133EKJ56 Federal Farm Credit Bank CASTLE 1/31/2020 8/30/2022 637 Aaa AA+ 0,400 0.378 3,000,000 3,010,643 3,008,796 10790 MUN 014365DOO ALDERWOOD WA WTR R & WSTWTR W B 11/12/2020 12/1/2022 730 Aa2 AA+ 1.000 0.600 200,000 202,126 201,986 10727 MCI 06051GEU9 Banc of America Corp CASTLE 11/25/2019 1/11/2023 771 A2 A- 3.300 2.120 2,000,000 2,120,875 2,047.935 10760 MUN 736746XU7 PORTLAND OR URBAN RENEWAL PS 7/14/2020 6/15/2023 926 Aal 4.023 2.895 1,000,000 1,018,910 1,027,246 10709 MUN 29270CNU5 Bonneville Power Adminstratio CASTLE 7/30/2019 7/1/2023 942 Aa2 AA- 5.803 2.125 1,000,000 1,135,540 1,090,693 10713 MCI 361582ADI Berkshire Hathaway Inc CASTLE 9/9/2019 7/15/2023 956 Aa3 AA 7.350 2.031 500,000 589,999 566,747 10769 FAC 3137EAEV7 Federal Home Loan Mtg Corp CASTLE 8/21/2020 8/24/2023 996 Asa AA+ 0.250 0.284 5,000,000 5,001,529 4,995,371 10768 MUN 67232TBM6 OAKLAND CA REDEV SUCCESSO PS 8/21/2020 9/1/2023 1004 AA- 3.125 0.602 2,500,000 2,662,000 2,671,661 10780 MUN 476453GRO JEROME IDAHO SCHOOL DISTRItPS 10/13/2020 9/15/2023 1018 Asa 5,000 0.479 200,000 225,048 225,010 10794 FAC 3137EAEZ8 Federal Home Loan Mtg Corp CASTLE 11/5/2020 11/6/2023 1070 AA+ 0.250 0.280 5,000,000 4,999,831 4,995,608 10802 MCI 459058JM6 International Bonds for Recons CASTLE 11/24/2020 11/24/2023 1088 Asa AAA 0.250 0.320 2,000,000 1,999,040 1,995,728 10789 MUN 014365DRB ALDERWOOD WA WTR & WSTWTR W B 11/12/2020 12/1/2023 1095 Aa2 AA+ 1.0D0 0.550 270,000 273,918 273,609 10795 FAC 3134GWKD7 Federal Home Loan Mtg Corp DA DAV 11/9/2020 2/12/2024 1168 Aaa 0.430 0.430 1,205,000 1,205,064 1,205,000 10761 FAC 3134GV6P8 Federal Home Loan Mtg Corp CASTLE 7/30/2020 4/15/2024 1231 Aaa 0.500 0.500 2,465,000 2,465,171 2,465,000 10776 MUN 568571 CZ4 SILVER FALLS SO PS 9/17/2020 6/15/2024 1292 Aal 0.550 0,550 1,900,000 1,900,855 1,900,000 10777 MUN 179093KOl CLACKAMAS SCHOOL DISTRICT PS 10/1/2020 6/15/2024 1292 Aal 0.613 0.613 500,000 500,455 500,000 10779 MUN 906429EE1 UNION CTY OR SCHOOL DISTRIC PS 10/8/2020 6/15/2024 1292 Aal 0.675 0.675 490,000 491,504 490,000 10785 MUN 939307KV5 Washington County SD Municipal PS 10/28/2020 6/15/2024 1292 Aal 0.590 0,584 1,500,000 1,502,775 1,500,000 10771 MCI 68583RCT7 OR ST COMMUNITY COLLEGE DI R W B 8/27/2020 6/30/2024 1307 Aal AA+ 5.660 0.600 90,000 105,605 106,095 10782 MUN 584288ER1 MEDFORD OR REVENUE R W B 10/14/2020 7/15/2024 1322 AA- 2.000 0.650 815,000 855,098 854,301 10784 MUN 732098PE2 POMONA CALI UNI SCH DIST TAX PS 10/20/2020 8/1/2024 1339 Aa3 0.770 0.600 1,200,000 1,208,412 1,207,379 10786 MUN 835569GR9 SONOMA CCD PS 10/21/2020 8/1/2024 1339 Aa2 AA 2.061 0.600 1,200,000 1,252,476 1,263,453 10775 FAC 3134GWF84 Federal Home Loan Mtg Corp CASTLE 9/9/2020 9/9/2024 1378 Aaa 0.480 0.480 1,000,000 1,000,038 1,000,000 10778 MUN 4511527CO IDAHO ST BOND BANK AUTH REV PS 10/8/2020 9/15/2024 1384 Aal 5.000 0.610 1,000,000 1,165,840 1,164,094 10781 MUN 476453GS8 JEROME IDAHO SCHOOL DISTRIcPS 10/13/2020 9/15/2024 1384 Aaa 5.000 0.725 220,000 255,765 255,068 10783 FAC 3133EMCW Federal Farm Credit Bank CASTLE 10/16/2020 10/15/2024 1414 Aaa AA+ 0.400 0.440 2,000,000 2,000,028 1,996,919 10791 FAC 3134GW3W4 Federal Home Loan Mtg Corp CASTLE 10/30/2020 10/28/2024 1427 Aaa 0,410 0.416 2,000,000 2,006,645 1,999,511 10797 MCI 822582CC4 ROYAL DUTCH SHELL PLC GPAC 11/13/2020 11/7/2024 1437 Aa2 AA- 2.000 0.706 3,000,0DD 3,159,066 3,150,356 '10799 FAC 3134GW7F7 Federal Home Loan Mtg Corp CASTLE 11/18/2020 11/18/2024 1448 Asa 0.375 0.375 2,0D0,000 2,002,604 2,000,000 10788 MUN 014365DS6 ALDERWOOD WA WTR & WSTWTR W B 11/12/2020 12/1/2024 1461 Aa2 AA+ 1.000 0.650 935,0D0 949,997 947,894 10762 FAC 3136G4E74 Federal National Mtg Assn CASTLE 7/31/2020 1/29/2025 1520 Aaa AA+ 0.570 0.570 1,400,000 1,392,857 1,400,000 10792 FAC 3134GW5Q5 Federal Home Loan Mtg Corp CASTLE 10/30/2020 1/29/2025 1520 Aaa 0.450 0.452 2,500,000 2,500,080 2,499,755 10801 MCI 30231GBM XTO Energy Inc GPAC 11/19/2020 3/19/2025 1569 Aal AA 2.992 0.814 2,000,000 2,182,418 2,183,682 10800 MUN 96459LAA1 YALE UNIVERSITY GPAC 11/18/2020 4/15/2025 1596 Aaa AAA 0.873 0.578 2,0D0,000 2,029,983 2,025,394 10798 MUN 938429V61 Washington County SD Municipal PS 11/17/2020 6/15/2025 1657 Aal 0.912 0.645 350,000 355,135 354,175 10787 MUN 88675ABS4 TIGARD OR WTR SYS REVENUE PS 11/312020 8/1/2025 1704 Aa3 AA 2.0D0 0.850 350,000 369,733 368,366 10763 FAC 3133EL3P7 Federal Farm Credit Banc R W B 8/12/2020 8/12/2025 1715 Aaa AA+ 0.530 0.530 3,000,000 2,988,128 3,000,000 10764 FAC 3133EL3H5 Federal Farm Credit Bank MORETN 8/12/2020 8/12/2025 1715 Aaa AA+ 0.570 0,570 3,000,000 2,988,010 3,000,000 10766 FAC 3134GWND4 Federal Home Loan Mtg Corp CASTLE 8/14/2020 8/12/2025 1715 Aaa 0.600 0.610 2,000,000 1,989,216 1,999,060 10767 FAC 3136G41-84 Federal National Mtg Assn CASTLE 8/18/2020 8/18/2025 1721 Aaa AA+ 0.570 0.590 2,000,000 1,991,666 1,998,133 10765 FAC 3136G4N74 Federal National Mtg Assn MORETN 8/21/2020 8/21/2025 1724 Asa AA+ 0.560 0.560 3,000,000 2,984,282 3,000,000 10772 FAC 3136G4N74 Federal National Mtg Assn R W B 8/27/2020 8/21/2025 1724 Asa AA+ 0.560 0.565 1,000,000 994,761 999,763 10774 FAC 3136G4N74 Federal National Mtg Assn R W B 9/3/2020 8/21/2025 1724 Aaa AA, 0.560 0.560 2,000,000 1,989,522 2,000,000 10770 FAC 3136G4X24 Federal National Mtg Assn PS 8/28/2020 8/29/2025 1732 Aaa AA+ 0.600 0.600 1,000,000 996,223 1,000,000 10773 FAC 3136G4X24 Federal National Mtg Assn CASTLE 8/28/2020 8/29/2025 1732 Asa AA+ 0.600 0.600 1,000,000 996,223 1,000,000 10793 FAC 3135GA2N0-- Federal National Mtg Assn - __.R W.B __ _11/4/2020_ 11/4/2025_ _.. 1799.Asa AA+... 0.550 0.550.. _2,000,0D0 2,000,748. 2,0D0,000 =10796 FAC 3135Q06GG.3 Federal National Mtn Assn CASTLE 11/12/2020 11/7/2025 1802 Aaa AA+ 0.500 0.573 2,000,000 2.000,811 1,992,916 _ 10078 RRP SYS10078 Local Govt Investment Pool 7/1/2006 - - _ 1 0.750 0.750 86,741,959 86,741,959 86,741,959 10084 RR2 SYS10084 First Interstate 7/1/2006 - - 1 0,750 0.750 13,848,190 13,848,190 13,848, 190 264,870,160 267,157,497 256,377,828 Budget to Actuals Report General Fund: Revenue YTD in the General Fund is $34.4 million or 92% of budget, an increase of $3.4 million from last year which was at 87% of budget for the same time period. This increase in YTD revenue this year is due to property tax collections and unbudgeted CARES Act reimbursements. Expenses YTD are $19.3 million and 48.5% of budget compared to $14.5 million and 38.7% of budget last year. The increase this year is due to CARES Act expenditures. Cour Fund iEiani:t � 130 Co.nmwrtv.- f2 -Lzv. i.ib�r..•v t �<; -nark Acac�ist ice_ - G:.:k De•,-e'.o.,. �!, Monthly GL P_. 0 j 5 £I $9.7M i t (Blank) ( All Major Funds: FY20 Pwp--�ted Ei dmq l,'or.<ini; Ca�;ital 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 November 30, 2020. Position Control Summary July - June Percent Org Jul Aug Sep Oct Nov Unfilled Assessor Filled 33.26 33.26 33.26 33.26 33.26 Unfilled 2.00 2.00 2.00 2.00 2.00 5.67% Clerk Filled 8.48 8.48 8.48 8.48 8.48 Unfilled 1.00 1.00 1.00 1.00 1.00 10.55% BOPTA Filled 0.52 0.52 0.52 0.52 0.52 Unfilled - - - - - 0.00% DA Filled 53.10 53.80 52.80 51.80 52.40 Unfilled 1.00 0.40 1.40 2.40 1.80 2.58% Tax Filled 5.50 5.50 5.50 5.50 5.50 Unfilled - - - - - 0.00% Veterans' Filled 4.00 4.00 4.00 4.00 4.00 Unfilled - - - - - 0.00% Property Mngt Filled 2.00 2.00 2.00 2.00 2.00 Unfilled - - - - - 0.00% Total General Fund Filled 106.86 107.56 106.56 105.56 106.16 Unfilled 4.00 3.40 4.40 5.40 4.80 3.97% Justice Court Filled 4.60 4.60 4.60 4.60 4.60 Unfilled - - - - - 0.00% Community Justice Filled 46.90 46.90 45.90 45.90 45.90 Unfilled 1.00 1.00 2.00 2.00 2.00 3.34% Sheriff Filled 224.75 234.75 237.75 236.75 231.75 Unfilled 22.75 15.25 12.25 14.25 19.25 6.70% Health Srvcs Filled 304.55 312.25 319.78 323.98 318.21 Unfilled 38.25 31.55 24.02 17.82 23.89 7.91% CDD Filled 54.00 53.00 54.00 54.00 53.00 Unfilled 2.00 3.00 2.00 4.00 5.00 5.63% Road Filled 53.00 53.00 53.00 53.00 53.00 Unfilled 4.00 3.00 3.00 3.00 3.00 5.69% Adult P&P Filled 39.60 39.60 38.60 38.60 39.60 Unfilled 2.25 1.25 2.25 2.25 1.25 4.51% Solid Waste Filled 22.00 23.00 23.00 23.00 23.00 Unfilled 2.00 - - - - 1.72% 9-1-1 Filled 54.00 54.00 56.00 57.00 55.00 Unfilled 6.00 5.00 3.00 2.00 4.00 6.76% Victims Assistance Filled 8.00 8.00 8.00 8.00 8.00 Unfilled - - - - - 0.00% GIS Dedicated Filled 2.30 2.30 2.30 2.30 2.30 Unfilled - - - - - 0.00% Fair & Expo Filled 10.91 10.91 10.91 10.91 10.91 Unfilled 0.09 0.09 0.09 0.09 0.09 0.82% Natural Resource Filled 2.00 2.00 2.00 2.00 2.00 Unfilled - - - - - 0.00% ISF - Facilities Filled 19.60 19.60 20.60 21.60 21.60 Unfilled 3.40 2.40 1.40 0.40 0.40 7.21% ISF - Admin Filled 7.75 7.75 7.75 7.75 7.75 Unfilled - - - - - 0.00% ISF - BOCC Filled 3.00 3.00 3.00 3.00 3.00 Unfilled - - - - 0.00910 ISF - Finance Filled 8.00 8.00 9.00 9.00 9.00 Unfilled 1.00 1.00 - - - 4.44% ISF - Legal Filled 7.00 7.00 7.00 7.00 7.00 Unfilled - - - - - 0.00% ISF - HR Filled 8.00 8.00 8.00 8.00 8.00 Unfilled - - - - - 0.00% ISF - IT Filled 15.70 15.70 15.70 15.70 15.70 Unfilled - - - - - 0.00% ISF - Risk Filled 2.25 2.25 2.25 2.25 2.25 Unfilled - 0.00% Total: Filled 1,004.77 1,023.17 1,035.70 1,039.90 1,027.73 Unfilled 86.74 66.94 54.41 51.21 63.68 %Unfilled 7.95% 6.14% 4.99% 4.69% 5.83% 5.92% Budget to Actuals - Countywide Summary All Departments 41.7% FY21 YTD November 30, 2020 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % 001 - General Fund 35,797,833 37,514,589 105% ; 37,201,525 34,284,812 92% 43,625,301 117% ; 030 - Juvenile 856,930 826,150 96% 975,090 272,513 28% 969,658 99% ; 160/170 - TRT 7,732,000 7,616,246 99% ; 6,916,358 6,255,311 90% ; 8,375,500 121% ; 220 - Justice Court 578,000 561,613 97% 489,850 185,478 38% 489,587 100% ; 255 - Sheriffs Office 41,581,807 43,677,825 105% ; 43,449,298 38,796,484 89% ; ; 43,606,543 100% ; 274 - Health Services 36,132,298 32,892,266 91% 39,453,933 18,342,028 46% ; ; 43,883,472 111% ; 295 - CDD 8,468,820 8,043,542 95% ; 8,251,726 3,555,121 43% ; 8,336,626 101% ; 325 - Road 22,785,827 22,495,570 99% ; 20,681,110 10,199,545 49% ; 21,522,997 104% ; 355 - Adult P&P 5,775,278 6,570,946 114% ; 5,995,287 3,114,889 52% ; 5,995,056 100%: 465 - Road CIP 2,142,893 2,145,706 100%: 2,467,800 154,070 6% ; 2,627,900 106% ; 610 - Solid Waste 11,724,869 12,300,751 105%: 12,077,592 5,414,820 45% ; 12,121,092 100%: 615 - Fair & Expo 1,561,500 990,522 63% ; 1,466,050 465,381 32% ; 1,171,474 80% ; 616 - Annual County Fair 1,649,700 1,469,198 89% ; 52,000 52,144 100%: 52,017 100% ; 617 - Fair & Expo Capital 16,000 21,189 132% ; 14,000 4,691 34% ; ; 12,000 86% ; Reserve s 618 - RV Park 437,700 445,454 102% ; 436,050 255,842 59% 393,590 90% ; 619 - RV Park Reserve 12,550 3,801 30% ; 1,100 3,959 360% 9,500 864% ; 670 - Risk Management 3,495,039 3,930,523 112% ; 3,263,646 1,508,520 46% ; 3,313,241 102% ; 675 - Health Benefits 22,318,433 22,490,985 101% ; 21,884,538 9,046,794 41% ; 21,982,833 100% ; 705 - 911 10,563,350 11,280,682 107% ; 11,064,698 9,283,863 84% 11,349,953 103% ; 999 - Other 29,544,540 37,220,505 126% ; 34,108,295 14,124,980 41% ; ; 34,165,136 100% ; TOTAL RESOURCES 243,175,367 252,498,065 104% ; 250,249,946 155,321,242 62% ; 264,003,475 105% ; Fiscal Year 2020 Fiscal Year 2021 REQUIREMENTS budget Actuals % Budget Actuals % Projection % 001 - General Fund 18,517,987 17,416,654 94% ; 19,253,406 10,699,714 56% ; 24,665,346 128% ; 030 - Juvenile 7,127,337 6,927,385 97% ; 7,390,349 2,916,634 39% 7,184,426 97% ; 160/170 - TRT 2,274,140 2,260,020 99% 2,419,872 1,832,312 76% ; 2,787,697 115% ; 220 - Justice Court 678,141 667,997 99% ; 683,508 272,941 40% ; 677,961 99% ; 255 - Sheriffs Office 44,685,809 44,783,763 100% ; 49,022,494 20,184,353 41% ; 48,500,794 99% ; 274--Health-Services-- ; 47589,309 --42,265;2238--89% ;- 49-,901,584 18,333,58-7- 37% --; -49,455,355 99% ;-- -- - 295 - CDD 7,905,639 7,462,091 94% 8,474,142 3,283,427 39% ; 8,311,509 98% ; o ��`_� Budget to Actuals - Countywide Summary All Departments 41.7% FY21 YTD November 30, 2020 (unaudited) Year Complete 325 - Road 14,573,336 13,094,764 90% 14,513,205 5,138,214 35% 14,188,375 98% ; 355 - Adult P&P 6,669,491 6,428,151 96% 7,081,268 2,588,194 37% ; 6,907,948 98% ; 465 - Road CIP 13,835,913 5,824,653 42% 20,036,050 2,560,368 13% ; 20,011,277 100% ; 610 - Solid Waste 8,384,039 7,518,563 90% 8,853,213 2,742,869 31% ; 8,821,828 100% ; 615 - Fair & Expo 2,464,787 2,372,624 96% 2,070,371 750,930 36% ; 1,955,403 94% ; 616 - Annual County Fair 1,504,700 1,615,288 107% ; 127,000 89,384 70% 154,928 122% ; 617 - Fair & Expo Capital 1,362,775 424,931 31% 401,940 89,256 22% ; 401,940 100% ; Reserve 618 - RV Park 540,373 503,509 93% 543,902 114,619 21% 511,044 94% ; 619 - RV Park Reserve 100,000 8,335 8% ; 100,000 0% ; 100,000 100% , 670 - Risk Management 4,132,295 2,440,263 59% ; 3,794,344 1,108,929 29% ; 4,041,217 107% ; 675 - Health Benefits 24,115,011 22,953,057 95% ; 23,620,173 6,954,314 29% ; ; 22,516,653 95% ; 705 - 911 12,250,336 10,722,604 88% 12,576,839 4,593,536 37% ; 12,250,395 97% 999 - Other 70,540,907 52,841,578 75% ; 58,399,018 11,115,440 19% ; 58,492,644 100% TOTAL REQUIREMENTS ; 289,252,325 248,531,468 86% ; 289,262,678 95,369,020 33% ; ; 291,936,741 101% ; Q�(\\)SEs co Budget to Actuals - Countywide Summary All Departments 41.7% FY21 YTD November 30, 2020 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 TRANSFERS Budget Actuals % Budget Actuals % Projection % 001 - General Fund (19,023,310) (18,917,801) 99% ; (20,308,890) (8,506,157) 42% ; (20,308,890) 100% ; 030 - Juvenile 5,874,465 5,874,465 100% ; 5,957,854 2,482,445 42% ; 5,957,854 100% ; 160/170 - TRT (4,433,128) (4,430,732) 100% ; (4,678,036) (1,846,914) 39% (4,639,689) 99% ; 220 - Justice Court - - 107,235 44,680 42% ; 107,235 100% ; 255 - Sheriffs Office 3,119,936 3,120,245 100% ; 3,119,077 1,276,796 41% ; 31119,077 100%: 274 - Health Services 6,102,365 6,552,032 107% ; 8,026,313 2,355,449 29% 7,217,141 90% ; 295 - CDD (1,448,081) (1,111,631) 77% (55,480) (30,720) 55% ; ; (54,561) 98% ; 325 - Road (11,910,575) (11,910,575) 100% ; (6,683,218) (1,418,945) 21% ; (6,683,218) 100%: 355 - Adult P&P 223,189 223,189 100% ; 187,496 78,129 42% ; 187,496 100%: 465 - Road CIP 12,014,914 11,431,979 95% 7,517,657 0% 7,517,657 100%: 610 - Solid Waste (3,296,192) (3,296,192) 100% ; (3,684,280) (927,537) 25% ; (3,684,280) 100%: 615 - Fair & Expo 1,022,863 1,475,467 144% ; 494,967 310,271 63% ; 785,128 159% ; 616 - Annual County Fair (145,000) 0% ; 75,000 31,500 42% 75,000 100%: 617 - Fair & Expo Capital (13,313) (13,313) 100% ; 253,158 105,482 42% 420,351 166% ; Reserve 618 - RV Park (307,000) (307,000) 100% ; (436,628) (222,414) 51% ; (110,484) 25% ; 619 - RV Park Reserve 502,000 502,000 100% ; 621,628 310,814 50% 290,484 47% ; 670 - Risk Management (6,918) (6,918) 100%: (3,500) (1,457) 42% ; (3,500) 100% ; 705 - 911 - - 999- Other 11,123,785 10,814,785 97% 9,078,924 5,958,578 66% ; 9,807,199 108% ; TOTALTRANSFERS (600,000) 0 (410,723) 0 - 0% � \)IES ` 0 Budget to Actuals - Countywide Summary Li All Departments 41.7% FY21 YTD November 30, 2020 (unaudited) Year Complete ENDING FUND BALANCE 001 - General Fund 030 - Juvenile 1601170 - TRT 220 - Justice Court 255 - Sheriff's Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 610 - Solid Waste 615 - Fair & Expo 616 - Annual County Fair 617 - Fair & Expo Capital Reserve 618 - RV Park 619 - RV Park Reserve 670 - Risk Management 675 - Health Benefits 705 - 911 999 - Other TOTAL FUND BALANCE Fiscal Year 2020 Fiscal Year 2021 Budget Actuals % Budget Actuals projection % 9,346,536 13,529,514 145% ; 9,739,629 28,608,454 12,180,578 125% ; 694,058 1,069,720 154% ; 616,595 908,044 812,806 132% ; 3,324,732 3,490,749 105% ; 3,530,844 6,066,835 4,438,863 126% ; 64,859 37,842 58% 57,804 (4,941) (43,297) -75% ; 14,732,933 18,832,967 128% ; 16,222,048 38,721,894 17,057,793 105% ; 4,766,157 7,817,166 164% ; 4,791,811 10,181,056 9,462,424 197% ; 1,097,104 1,253,356 114% ; 734,798 1,494,330 1,223,912 167% ; 2,303,905 4,217,071 183% ; 2,180,473 7,859,457 4,868,475 223% ; 1,918,976 3,119,990 163% ; 1,816,329 3,724,813 2,394,594 132% ; 15,938,430 25,512,586 160% ; 13,103,814 23,106,288 15,646,866 119% ; 644,638 2,285,566 355% ; 719,918 4,029,981 1,900,550 264% ; 199,576 (1,199) -1% 255,550 23,524 - 0% ; - (47,461) - (53,200) (75,372) ; - 726,169 999% ; 1,008,442 747,085 756,580 75% ; 150,327 227,936 152% ; 43,512 146,745 (2) 0% ; 414,550 497,466 120% ; 1,012,728 812,239 697,450 69% ; 5,455,826 8,676,750 159% ; 6,465,802 9,074,884 7,945,274 123% ; 14,309,716 16,101,833 113% ; 13,588,094 18,194,313 15,568,013 115% ; 6,066,720 9,162,894 151% ; 6,829,277 13,853,221 8,262,452 121% ; 41,618,580 69,175,048 166% ; 50,516,183 78,120,469 ; 55,491,528 110% ; 119% ; 123,047,623 185,685,964 151% ; 133,233,651 245,615,489 ; 158,589,488 ��.I ES ` Budget to Actuals Report .0 General Fund - Fund 001 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Property Taxes - Current 29,046,840 29,310,769 101% 30,105,307 28,599,151 95% 30,267,217 101% : 161,910: A Property Taxes - Prior 391,000 976,355 250% 358,000 338,944 95% 358,000 100% Other General Revenues 3,020,400 3,136,644 104% 2,550,871 3,140,392 123% 8,832,737 346% 6,281,865; B Assessor 837,283 942,562 113% 836,713 580,077 69% 836,713 100% Clerk 1,615,280 2,242,070 139% 2,153,741 1,240,801 58% 2,153,741 100% BOPTA 12,220 13,659 112% 12,220 8,990 74% 12,220 100% District Attorney 383,806 333,772 87% 467,138 103,194 22% 447,138 96% : (20,000)! C Tax Office 195,390 257,219 132% 419,927 224,948 54% 419,927 100% Veterans 175,614 175,614 100% 175,608 39,733 23% 175,608 100%! D Property Management 120,000 125,925 105% 122,000 8,583 7% 122,000 100%! ! E TOTAL RESOURCES 35,797,833 37,514,589 105% ; 37,201,525 34,284,812 92% ; 43,625,301 117% ; 6,423,776: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Assessor 4,993,290 4,699,209 94% 5,237,507 2,019,958 39% 4,939,304 94% 298,203; F Clerk 2,049,501 1,640,426 80% 2,051,015 861,240 42% 1,925,380 94% 125,63& G BOPTA 77,950 72,369 93% 79,945 33,335 42% _ 79,945 100% District Attorney 7,873,159 7,606,702 97% 8,234,075 3,246,931 39% 8,146,194 99% 87,881: H Medical Examiner 235,542 197,772 84% 236,358 67,423 29% 236,358 100% Tax Office 865,307 860,973 99% E 970,608 401,419 41% 970,608 100% Veterans 589,551 525,956 89% 639,571 222,447 35% 636,858 100% 2,713:1 Property Management 306,985 301,829 98% 317,533 127,986 40% 317,533 100% Non -Departmental 1,526,702 1,511,418 99% 1,486,794 3,718,974 250% 7,413,166 499% (5,926,372)! J TOTAL REQUIREMENTS 18,517,987 17,416,654 94% 19,253,406 10,699,714 56% ; 24,665,346 128%; (5,411,940); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 260,000 260,000 100% 260,000 108,332 42% 260,000 100% K Transfers Out (19,283,310) (19,177,801) 99% (20,568,890) (8,614,489) 42% (20,568,890) 100% TOTALTRANSFERS (19,023,310) (18,917,801) 99% (20,308,890) (8,506,157) 42% ; (20,308,890) 100% FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 11,090,000 12,349,379 111% , 12,100,400 13,529,514 112% , 13,529,514 112% , 1,429,114, Resources over Requirements 17,279,846 20,097,935 17,948,119 23,585,098 18,959,955 1,011,836 Net Transfers - In (Out) (19,023,310) (18,917,801) (20,308,890) (8,506,157) (20,308,890) TOTAL FUND BALANCE $ 9,346,536 $ 13,529,514 145% ; $ 9,739,629 $ 28,608,454 294% ; $ 12,180,578 125% ; $2,440,949: Footnotes on following page A Current year taxes received primarily in November, February and May; actual 20-21 TAV is 5.40% compared to FY19-20 vs. 5.00% budgeted B PILT payment of $500,000 received in July 2020; interest projection based on current investment rate and anticipated cash balances; includes CARES Fund reimbursements C A vacancy in a grant funded position will reduce State Grant funds by $20K; Federal Grants cannot be drawn down until agency completes financial system upgrade which is estimated to be the end of November. D Oregon Dept. of Veteran's Affairs grant reimbursed quarterly E Interfund land -sale management revenue recorded at year-end F Projected Personnel savings based on FY21 average vacancy rate of 5.7% G Projected Personnel savings based on FY21 average vacancy rate of 10.6% H Projected Personnel savings based on FY21 average vacancy rate of 2.6% I Projected Personnel savings based on FY21 savings to date i Budget adjustment for COVID-19 related contracts will be presented to the Board prior to the end of the calendar year K Repayment to General Fund from Finance Reserves for ERP Implementation ,)IES{ 0 Budget to Actuals Report L� Juvenile - Fund 030 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance OYA Basic & Diversion 442,601 387,814 88% 472,401 93,424 20% 472,401 100% A ODE Juvenile Crime Prev 91,379 82,125 90% 109,000 - 0% 109,000 100%, A Inmate/Prisoner Housing 80,000 96,600 121% 90,000 19,200 21% 80,000 89% ! (10,000)! B Gen Fund -Crime Prevention 20,000 20,000 100%! 89,500 89,500 100%! 89,500 100%! C Leases 86,400 97,061 112% 88,000 30,008 34% 88,000 100% DOC Unif Crime Fee/HB2712 35,000 49,339 141% < 49,339 12,335 25% 49,339 100% OJD Court Fac/Sec SB 1065 26,000 20,404 78% 26,000 4,910 19% 26,000 100% 1 Interest on Investments 31,000 26,491 85% 17,300 7,812 45% 18,700 108% 1,400! D Food Subsidy 16,000 13,448 84% 12,000 3,174 26% 10,000 83% (2,000)! Contract Payments 8,000 5,459 68% 8,000 499 6% 5,000 63% (3,000)! E Miscellaneous 14,050 22,672 161% 7,550 10,449 138% 16,718 221% ! 9,168! F Case Supervision Fee 6,500 4,736 73% 6,000 1,202 20% 5,000 83% (1,000)! E TOTALRESOURCES 856,930 826,150 96% ; 975,090 272,513 28% ; 969,658 99% (5,432); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,797,927 5,650,045 97% 5,970,797 2,403,181 40% 5,766,987 97% , 203,810; G Materials and Services 1,329,410 1,277,340 96% E 1,387,552 483,566 35% 1,387,552 100%' 4 Capital Outlay - - 32,000 29,887 93% 29,887 93% 2,113 TOTAL REQUIREMENTS ; 7,127,337 6,927,385 97% ; 7,390,349 2,916,634 39% ; 7,184,426 97% 205,923: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 5,961,465 5,961,465 100% = 6,034,966 2,514,575 42% 6,034,966 100% Transfers Out-Veh Reserve (87,000) (87,000) 100% ! (77,112) (32,130) 42% (77,112) 100% TOTALTRANSFERS 5,874,465 5,874,465 100% 5,957,854 2,482,445 42% 5,957,854 100% FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,090,000 1,296,490 119% 1,074,000 1,069,720 100% 1,069,720 100% (4,280); Resources over Requirements (6,270,407) (6,101,235) (6,415,259) (2,644,121) (6,214,768) 200,491 Net Transfers - In (Out) 5,874,465 5,874,465 5,957,854 2,482,445 5,957,854 TOTAL FUND BALANCE $ 694,058 $ 1,069,720 154% ; $ 616,595 $ 908,044 147% ; ; $ 812,805 132% ; $196,211: A Quarterly reimbursement based on actual expenses. Q1 payment has been submitted and approved by the State. B Adjusted projection based on YTD revenue. COVID-19 is impacting other Counties use of detention. C On -time annual transfer received D Interest projection based on current investment rate and anticipated cash balances E Adjusted projection based on YTD revenue. Receiving less than budgeted due to COVID-19 impacts F Includes CARES Fund reimbursements G Projected Personnel savings based on FY21 average vacancy rate of 3.3% 01 ES Budget to Actuals Report 0G TRT -Fund 160/170 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Room Taxes 7,670,000 7,527,492 98% 6,862,458 6,123,446 89% 8,200,000 119% 1,337,542; A Interest 62,000 88,754 143% 53,900 31,865 59% 75,500 140% 21,6W B State Miscellaneous - - t 100,000 100,000 100,000! C , r TOTALRESOURCES 7,732,000 7,616,246 99% 6,916,358 6,255,311 90% 8,375,500 121%; 1,459,142: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance COVA 2,064,221 2,050,618 99% 1,838,805 1,470,569 80% 2,206,630 120% : (367,825): A Grants & Contributions 62,000 62,000 100% 404,000 298,330 74% 404,000 100% Interfund Contract 79,160 79,160 100% 114,481 47,700 42% 114,481 100% ! -! D Interfund Charges 37,309 37,309 100% 35,861 14,942 42% 35,861 100% Software 10,350 - 0% 11,500 - 0% 11,500 100% Auditing Services 14,500 19,200 132% 11,500 - 0% ! 11,500 100% Public Notices 1,600 1,694 106% 1,600 770 48% 1,600 100% Office Supplies 3,000 741 25% 1,275 1 0% 1,275 100%, Printing 2,000 642 32% 850 0% 850 100% Refunds & Adjustments - 8,657 999% TOTAL REQUIREMENTS 2,274,140 2,260,020 99% 2,419,872 1,832,312 76% 2,787,697 115% ; (367,825); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer Out - RV Park (35,000) (35,000) 100% ; (20,000) (8,400) 42% (20,000) 100%, Transfer Out - Annual Fair t (250,000) (250,000) 100% (75,000) (31,500) 42% (75,000) 100% Transfer Out - F&E Reserve (286,687) (286,687) 100% (253,158) (105,482) 42% (420,351) 166% ! (167,193)! A Transfer Out - F&E (as needed) (325,744) (323,348) 99% (275,744) (10,729) 4% ? (70,204) 25% 205,54& E Transfer Out - Health S (406,646) (169,435) 42% 4 (406,646) 100% F Transfer Out - F&E (383,910) (383,910) 100% (495,701) (208,194) 42% (495,701) 100% Transfer Out - Sheriff (3,151,787) (3,151,787) 100%! (3,151,787) (1,313,174) 42% ! (3,151,787) 100% TOTALTRANSFERS (4,433,128) (4,430,732) 100% ; (4,678,036) (1,846,914) 39% (4,639,689) 99% 38,347; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,300,000 2,565,255 112% 3,712,394 3,490,749 94% 3,490,749 94% (221,645)' Resources over Requirements 5,457,860 5,356,226 4,496,486 4,422,999 $ 5,587,803 1,091,317 Net Transfers - In (Out) � (4,433,128) (4,430,732) � (4,678,036) (1,846,914) Ft (4,639,689) 38,34T � i TOTAL FUND BALANCE $ 3,324,732 $ 3,490,749 105% $ 3,530,844 $ 6,066,835 172% ; ; $ 4,438,863 126% ; $908,019: A Revised estimate based on FY21 collections at 95.4% of FY20 B Interest projection based on current investment rate and anticipated cash balances C Includes CARES Fund reimbursements D Contracted services with the Finance Department for operating TRT program E $250K of budgeted transfers are to be transferred on an as needed basis F Transfer to Health Services is to fund COVID re -opening positions , I , E I S (- 0 Budget to Actuals Report Justice Court - Fund 220 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete F- Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Court Fines & Fees 575,000 556,877 97% 488,750 184,687 38% 488,750 100% A Interest on Investments 3,000 1,706 57% 1,100 55 5% 100 9% (1,000)! B t Miscellaneous 3,030 - 736 737 73T TOTAL RESOURCES 578,000 561,613 97% 489,850 185,478 38% 489,587 100%: (263): REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 516,868 522,054 101% 531,006, 215,681 41% 525,459 99% 5,547: C Materials and Services 161,273 145,944 90% 152,502 57,260 38% 152,502 100%! D TOTAL REQUIREMENTS 678,141 667,997 99% 683,508 272,941 40% 677,961 99% 5,547: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 107,235 44,680 42% 107,235 100% -E TOTALTRANSFERS 107,235 44,680 42% 107,235 100%; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 165,000 144,227 87% 144,227 37,842 263% 37,842 26% (106,385), Resources over Requirements (100,141) (106,384) (193,658) (87,464) f (188,374) 5,284! Net Transfers - In (Out) - - 107,235 44,680 i 107,235 TOTAL FUND BALANCE $64,859 $37,842 58% $57,804 ($4,941) -9% ($43,297) -75% ($101,101): A The FY21 budget reflects lower revenue compared to FY20 because of HB421 0. Revenue may be reduced further, but the impact won't be known until late 2020. B Interest projection based on current investment rate and anticipated cash balances C Projected Personnel savings based on FY21 savings to date D One time yearly software maintenance fee of $9,169 paid in July for entire fiscal year E Additional transfers may be needed because of lower Court Fines and Fees revenue ,31 E ` � Budget to Actuals Report C ,> ;. 0G Sheriff's Office - Fund 255 FY21 YTD November 30, 2020 (unaudited) RESOURCES LED #1 Property Tax Current LED #2 Property Tax Current Sheriff's Office Revenues LED #1 Property Tax Prior LED #2 Property Tax Prior LED #2 Interest LED #1 Interest LED #2 Foreclosed Properties LED #1 Foreclosed Properties TOTALRESOURCES REQUIREMENTS Sheriff's Services Civil/Special Units Automotive/Communications Detective Patrol Records Adult Jail Court Security Emergency Services Special Services Training Crisis Stabilization Center Other Law Enforcement Non - Departmental TOTAL REQUIREMENTS 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 26,293,470 26,496,529 101% 27,476,763 25,863,206 94% 27,569,562 100% 92,799, A 10,632,014 10,696,589 101% 11,092,307 10,441,934 94% 11,130,853 100%: 38,546! B 3,922,323 4,914,406 125% 4,259,128 1,986,625 47% 4,270,228 100%: 11,100 C 312,000 761,642 244% 280,000 284,727 102% 285,000 102%! 5,000 148,000 331,165 224% 120,000 117,961 98% 120,000 100% 136,000 160,208 118% 120,000 34,136 28% 77,500 65% (42,500), C 138,000 � 287,276 208% , c 101,100 67,894 67% I I 153,400 152% , I 52,300, C I � 8,631 - - I I I I I 21,380 - - 41,581,807 43,677,825 105% ; 43,449,298 38,796,484 89% 43,606,543 100%, 157,245; Budget Actuals % Budget Actuals % 3,105,057 3,092,171 100% 3,864,843 1,547,454 40% 1,232,158 1,171,260 95% 1,232,618 464,600 38% 2,858,337 2,915,540 102% 3,312,477 1,012,610 31% 2,303,072 2,217,577 96% 2,515,536 996,227 40% � I 10,592,002 11,446,211 108% 12,336,227 5,551,053 45% 1,004,600 833,934 83% 1,038,130 349,272 34% 18,379,998 17,929,047 98% 19,897,342 7,703,826 39% I 556,740 458,541 82% 490,401 195,853 40% 402,734 603,381 150% 543,565 502,614 92% a 1,601,871 1,747,792 109% > 2,052,586 849,545 41% I I 743,334 916,411 123% 1,156,993 428,517 37% < 571,267 84,267 15% - - 1,330,214 1,261,716 95% 1,328,675 582,120 44% I 4,425 105,917 999% : (746,899) 662 0% 44,685,809 44,783,763 100% ; 49,022,494 20,184,353 41% ; TRANSFERS Budget Actuals % Budget Actuals % Transfer In - TRT 3,151,787 3,151,787 100% = 3,151,787 1,313,174 42% Transfer in - General Fund 240,249 240,249 100% 240,290 100,122 42% Transfers Out - Debt Service (272,100) (271,791) 100% (273,000) (136,500) 50% TOTALTRANSFERS 3,119,936 3,120,245 100% ; 3,119,077 1,276,796 41% ; Projection % $ Variance 3,812,620 99% � 52,221 D I I 1,129,369 92% 103,249� 3,132,926 95% 179,551 2,512,126 100%! 3,410 12,918,269 105% (582,042)� 948,064 91% 90,066! 19,153,416 96% r 743,926! I 468,224 95% 22,177!I 561,695 103% (18,130): ± 2,021,924 99% 30,662' 1,178,753 102% i I (21,760)! I 1,410,307 106% ! (81,632)! ! I (746,899) 100% i E 48,500,794 99% 521,700: Projection % $ Variance 3,151,787 100% 240,290 100%! (273,000) 100% 3,119,077 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 14,716,999 16,818,660 114% = 18,676,167 18,832,967 101% 18,832,967 101% 156,80& Resources over Requirements (3,104,002) (1,105,938) (5,573,196) 18,612,131 (4,894,251) 678,945! I Net Transfers - In (Out) 3,119,936 3,120,245 3,119,077 1,276,796 3,119,077 € p t I E ! TOTAL FUND BALANCE $ 14,732,933 $ 18,832,967 128% ; $ 16,222,048 $ 38,721,894 239% ; $ 17,057,793 105% ; $835,745: A Current year taxes received primarily in November, February and May; actual 20-21 TAV is 5.40% compared to FY19-20 vs. 5.00% budgeted B Current year taxes received primarily in November, February and May; actual 20-21 TAV is 5.31 % compared to FY19-20 vs. 5.00% budgeted C Interest projection based on current investment rate and anticipated cash balances D Divisions projected to be less than budget are related to hiring process being impacted by COVID. Divisions projected to be higher than budget are impacted_b_y_overtime-related -t2fires as well as delays_sending employees to Academy due to COVID. E Budgeted funds includes transfers from Funds 701 and 702 ,)I ES C,0 FINANCE ,)`E S Budget to Actuals Report Health Services - Fund 274 FY21 YTD November 30, 2020 (unaudited) RESOURCES State Grant OHP Capitation Federal Grants OHP Fee for Service State Miscellaneous Local Grants State - OMAP Environmental Health Fees Other Patient Fees Title 19 Vital Records Divorce Filing Fees State Shared- Family Planning Interest on Investments Interfund Contract- Gen Fund Liquor Revenue CCBHC Grant TOTALRESOURCES 41.7% Year Complete Fiscal Year 2020 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 14,080,644 11,212,405 80% 14,229,640 5,921,236 42% _ 15,228,765 107% , 999,124; 7,242,430 8,094,701 112% 8,279,406 4,134,909 50% 8,372,235 101% 92,829 k 3,277,616 2,798,690 85% 4,492,822 571,136 13% 4,404,345 98% (88,477) - - 3,265,627 1,596,065 49% 3,680,850 113% 415,223 1,040,153 1,387,132 133% 2,238,388 720,007 32% 3,048,418 136% : 810,030 1,567,331 1,133,942 72% 1,765,208 3,435,654 195% 3,939,629 223% 2,174,421 k 991,900 879,037 89% 1,162,507 447,258 38% i t 1,074,220 92% (88,287), k 1,058,206 1,104,825 104% 1,091,652 224,027 21% 1,101,842 101% ! 10,190! k 484,712 476,047 98% 965,971 295,928 31% 737,036 76% (228,935)! k 564,750 600,412 106% 672,995 172,158 26% 418,924 62% (254,071)! 4,862,726 4,071,759 84% 350,491 349,08.9 100% 826,706 236% 476,215! 220,000 259,029 118% 237,296 93,070 39% 270,619 114% ! 33,323! 173,030 173,030 100%! 173,030 173,030 100%! 173,030 100%! 120,000 191,912 160% 155,000 73,690 48% 176,855 114% , 21,855� 171,000 233,116 136% 147,400 84,791 58% 203,498 138% 56,098! 127,000 127,000 100% 127,000 - 0% 127,000 100% 150,800 162,122 108% 99,500 49,982 50% 99,500 100% k - (12,894) 999% - - i 36,132,298 32,892,266 91% 39,453,933 18,342,028 46% 43,883,472 111%; 4,429,539: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 33,186,830 32,041,791 97% 36,774,631 14,405,772 39% 35,864,774 98% � 909,857; Materials and Services 13,707,479 10,223,447 75% 13,027,296 3,927,815 30% 13,492,269 104% ! (464,973)� Capital Outlay 695,000 - 0% 99,667 0% 98,313 99% 1,354! Administration Allocation - - (10) 0% i 0% (10) TOTAL REQUIREMENTS 47,589,309 42,265,238 89% ; 49,901,584 18,333,587 37% ; 49,455,355 99% ; 446,229: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 5,747,090 5,747,090 100% 5,472,710 2,283,059 42% 5,472,710 100% , Transfers In- OHP Mental Health 548,601 998,268 182% 2,379,865 - 0% 1,570,693 66% (809,172)� Transfers In - TRT ! 406,646 169,435 42% 406,646 100% Transfers Out (193,326) (193,326) 100% (232,908) (97,045) 42% _ (232,908) 100% TOTALTRANSFERS 6,102,365 6,552,032 107% ; 8,026,313 2,355,449 29% ; 7,217,141 90% (809,172); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 10,120,803 10,638,105 105% 7,213,149 7,817,166 108% t 7,817,166 108% 604,01T Resources over Requirements (11,457,011) (9,372,971) (10,447,651) 8,441 (5,571,883) ! 4,875,76& Net Transfers - In (Out) 6,102,365 6,552,032 8,026,313 2,355,449 7,217,141 (809,172) 4 TOTAL FUND BALANCE , $ 4,766,157 $ 7,817,166 164% ; $ 4,791,811 $ 10,181,056 212% ; $ 9,462,424 197% ; $4,670,613: 31ES � Budget to Actuals Report Health Services - Admin - Fund 274 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Federal Grants 726,655 565,906 78% 784,126 144,463 18% 872,221 111% 88,096 A Interest on Investments 171,000 233,116 136% 147,400 84,791 58% 203,498 138% 56,098, B Other 9,000 8,718 97% 14,391 4,332 30% F 10,398 72% (3,993)! State Miscellaneous - 171,881 - 5,166 99,285 r 99,285! C � CCBHC Grant TOTAL RESOURCES 906,655 979,620 108% ; 945,917 238,753 25% ; 1,185,402 125% ; 239,486; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,241,264 4,870,386 93% 5,360,412 2,032,714 38% 4,958,024 92% 402,388 D Materials and Services 4,971,179 4,690,935 94% 4,968,341 1,959,772 39% 5,057,552 102% (89,211)� Capital Outlay 5,000 0% Administration Allocation (9,308,295) (9,306,000) 100% (9,627,992) (2,360,180) 25% (9,633,283) 100% 5,291! TOTAL REQUIREMENTS 909,148 255,321 28% 700,761 1,632,306 233% ; ; 382,293 55% 318,468; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 40,000 39,997 100% - - Transfers Out (193,326) (193,326) 100% (232,908) (97,045) 42% (232,908) 100% TOTALTRANSFERS (153,326) (153,329) 100% ; (232,908) (97,045) 42% (232,908) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,660,832 2,748,263 103% 2,772,840 3,322,793 120% 3,322,793 120% 549,951 Resources over Requirements 3 (2,493) 724,299 245,155 (1,393,553) 803,109 557,954! Net Transfers - In (Out) k (153,326) (153,329) (232,908) (97,045) (232,908) TOTAL FUND BALANCE $ 2,505,013 $ 3,319,234 133% ; $ 2,785,087 $ 1,832,196 66% ; $ 3,892,995 140% ; $1,107,908: A Federal grants are reimbursed on a quarterly basis. B Interest projection based on current investment rate and anticipated cash balances C Includes CARES Fund reimbursements D Projected Personnel savings based on YTD Personnel expenditures ,31Es { Budget to Actuals Report c� �G Health Services - Behavioral Health - Fund 274 41.7% FY21 YTD November 30, 2020 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ variance State Grant 11,203,914 8,259,750 74% 10,348,047 4,064,457 39% 11,039,586 107% , 691,539; A OHP Capitation 7,242,430 8,094,701 112% 8,279,406 4,134,909 50% 8,372,235 101% 92,829; B Federal Grants 2,168,961 1,823,950 84% 3,411,088 391,175 11% 3,298,243 97% (112,845)� OHP Fee for Service 3,265,627 1,596,065 49% 3,680,850 113% : 415,223! C State Miscellaneous 437,100 326,534 75% 1,468,455 570,051 39% 1,347,593 92% (120,862)! D Local Grants 994,331 487,025 49% 1,067,507 1,688,975 158% 2,052,354 192% 984,847; E Other 395,352 360,920 91% 927,605 280,274 30% 705,870 76% (221,735)� F Patient Fees 443,450 465,851 105% 522,300 130,207 25% 312,919 60% (209,381)! G Title 19 4,862,726 4,071,759 84% 350,491 349,088 100%! 826,706 236% 476,215! H State - OMAP 131,900 174,354 132% i 210,287 55,649 26% i 133,556 64% (76,731)! Divorce Filing Fees 173,030 173,030 100%! 173,030 173,030 100%! 173,030 100% Interfund Contract- Gen Fund 127,000 127,000 100% 127,000 - 0% 127,000 100% Liquor Revenue 150,800 162,122 108% 99,500 49,982 50% 99,500 100% CCBHC Grant - (12,894) 999% TOTALRESOURCES 28,330,994 24,514,102 87% 30,250,343 13,483,862 45% 32,169,443 106%; 1,919,100, REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ variance Administration Allocation 6,978,412 6,963,580 100% r 7,427,338 1,810,019 24% 7,424,984 100% = 2,354; Personnel Services 20,174,804 19,576,382 97% 23,281,788 8,989,140 39% ! 22,818,195 98% 463,594:1 Materials and Services 6,889,404 3,802,898 55% 5,699,701 1,183,334 21% 5,558,109 98% 141,591� J Capital Outlay 690,000 - 0% 99,667 - 0% 98,313 99% 1,354! TOTAL REQUIREMENTS 34,732,620 30,342,859 87% 36,508,494 11,982,493 33% ; 35,899,601 98% 608,893: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ variance Transfers In- OHP Mental Health 548,601 998,268 182% 2,298,179 0% _ 1,489,007 65% (809,172)� K Transfers In- General Fund 1,734,107 1,734,100 100% 2,036,117 848,379 42% 2,036,117 100%, Transfers Out - - 0% - 0% TOTALTRANSFERS ; 2,282,708 2,732,368 120% ; 4,334,296 848,379 20% 3,525,124 81% ; (809,172); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ variance Beginning Fund Balance 6,122,347 6,673,256 109% 3,146,977 3,397,853 108% _ 3,397,853 108% 250,876- Resources over Requirements (6,401,626) (5,828,757) (6,258,151) 1,501,368 (3,730,158) 2,527,993! Net Transfers - In (Out) 2,282,708 2,732,368 4,334,296 848,379 3,525,124 (809,172) t TOTAL FUND BALANCE $ 2,003,429 $ 3,576,867 179% ; $ 1,223,122 $ 5,747,600 470% ; $ 3,192,819 261% ; $1,969,697: Footnotes on following page A Includes $530K in carryforward State funds from FY20 for expenditure in second year of the biennium, as well as $282K in new State grant funding for culturally -relevant behavioral health services needed for COVID-19, and $325K from the Oregon Criminal Justice Commission grant above budget because of installment payments that will be carried forward into FY22. Reduction of $600K in December as part of participation in CCBHC continuation. OHP Reserves will offset loss of funds. B Includes FY20 withhold payment of $93K C Oregon Health Authority reports OHP membership increase for Deschutes County, which may result in additional services. Projections also include revenue from underpaid services in FY20 from PacificSource that are being corrected in FY21. D Projected reduction in local match for I/DD program due to vacancies. Includes CARES Fund reimbursements. E Projections include an early release of quality improvement metric (QIM) funds for COVID-19 efforts from Central Oregon Health Council (COHC). Expenses are not yet appropriated and are included in projections under Materials and Services, pending approval from the Board. Also includes carryforward of $246,000 from FY20 unspent Choice Model Funds. F Decrease of $234,000 from budgeted interfund payment, which was related to a contract that will be paid directly by PacificSource in FY21 instead of by DCHS. G Fewer fees collected from insurance than budgeted, likely due to a decrease in patient private insurance plans and an increase in Oregon Health Plan (OHP) membership. H CCBHC enhanced rate for Title 19 approved through December 2020 1 Projected Personnel savings based on YTD Personnel expenditures j Expenditures related to footnote E K Actual amount required for transfer -in will be determined at end of year. Current projection includes transfer to offset loss of funds as noted in Footnote A Es CBudget to Actuals Report Health Services - Public Health - Fund 274 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Grant 2,876,730 2,952,656 103% 3,881,593 1,856,780 48% _ 4,189,178 108% 307,58& A Environmental Health Fees 1,058,206 1,104,825 104% , 1,091,652 224,027 21% € 1,101,842 101% 10,190; State - OMAP 860,000 704,683 82% 952,220 391,610 41% 940,664 99% (11,556) State Miscellaneous 603,053 888,717 147% 769,933 144,790 19% 1,601,540 208% 831,607! B Local Grants 573,000 646,917 113% 697,701 1,746,679 250% 1,887,275 270% 1,189,574! Federal Grants 382,000 408,834 107% 297,609 35,497 12% 233,881 79% (63,727)! Vital Records 220,000 259,029 118% 237,296 93,070 39% 270,619 114% ! 33,323! State Shared- Family Planning 120,000 191,912 160% 155,000 73,690 48% 176,855 114% , 21,855i Patient Fees 121,300 134,562 111% ! 150,695 41,951 28% 106,005 70% (44,690)! Other 80,360 106,409 132% 23,975 11,321 47% t 20,768 87% (3,207)! TOTAL RESOURCES 6,894,649 7,398,544 107% ; 8,257,674 4,619,414 56% ; 10,528,627 128% ; 2,270,954: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 2,329,883 2,342,420 101% 2,200,644 550,161 25% 2,208,299 100% (7,655), Personnel Services 7,770,762 7,595,023 98% 8,132,431 3,383,918 42% F $ 8,088,555 99% 43,876! C Materials and Services 1,846,896 1,729,614 94% 2,359,254 784,710 33% 2,876,608 122% (517,354)! D TOTAL REQUIREMENTS 11,947,541 11,667,057 98% 12,692,329 4,718,789 37% ; 13,173,462 104%; (481,133); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 3,972,983 3,972,993 100% 3,436,593 1,434,680 42% 3,436,593 100%, Transfers In - TRT 406,646 169,435 42% 406,646 100%! Transfers In- OHP Mental Health 81,686 - 0% 81,686 100% TOTALTRANSFERS 3,972,983 3,972,993 100% ; 3,924,925 1,604,115 41% 3,924,925 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,337,624 1,216,586 91% 1,293,332 1,096,520 85% 1,096,520 85% (196,812): Resources over Requirements (5,052,892) (4,268,513) (4,434,655) (99,375) (2,644,834) 1,789,821, Net Transfers - In (Out) r 3,972,983 3,972,993 t F 3,924,925 1,604,115 s a s 3,924,925 t € TOTAL FUND BALANCE $ 257,715 $ 921,065 357% $ 783,602 $ 2,601,260 332% ; ; $ 2,376,610 303% ; $1,593,009: A Includes $261,000 in unspent state funds from FY20 for expenditure in second year of the biennium B As part of the funding mechanism for the approved state funding, Public Health is receiving a payment for each COVID case traced until state funding is expended. Current invoices to the state total $746,846. Public Health is developing an expenditure plan. Projected expenses are included under Materials and Services, pending approval from the Board. C Projected Personnel Services based on YTD Personnel expenditures D Expenditures related to footnote B �Ts Budget to Actuals Report Community Development - Fund 295 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 162,000 156,476 97% 137,450 56,260 41% 144,750 105% 7,3W A Code Enforcement 693,960 664,545 96% 722,028 301,210 42% 722,028 100% Building Safety 3,433,780 3,179,771 93% 3,362,450 1,457,423 43% 3,362,450 100% Electrical 809,500 797,458 99% 720,600 368,305 51% 772,600 107% 52,000! B Environmental On -Site 877,400 905,165 103% 867,700 382,217 44% 893,300 103% 25,600! B Current Planning 1,807,176 1,696,355 94% 1,738,304 679,903 39% 1,738,304 100% Long Range Planning 685,004 643,772 94% 703,194 309,804 44% 703,194 100% TOTAL RESOURCES 8,468,820 8,043,542 95% 8,251,726 3,555,121 43% 8,336,626 101% ; 84,900; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 2,492,316 2,527,439 101%, 2,818,748 1,159,655 41% 4 2,835,448 101% (16,700): Code Enforcement 535,590 458,293 86% 568,320 208,610 37% 546,967 96% 21,351 C Building Safety 1,743,298 1,584,784 91% 1,867,662 705,269 38% 1,845,502 99% 22,160, C Electrical 462,183 452,842 98% 524,979 200,226 38% 520,357 99% 4,622! C Environmental On -Site 616,279 566,975 92% 634,452 264,084 42% 645,502 102% (11,050) Current Planning 1,501,588 1,415,434 94% 1,479,294 594,161 40% 1,449,208 98% 30,086! C Long Range Planning 554,385 456,323 82% 580,687 151,423 26% 468,525 81% 112,162 C TOTAL REQUIREMENTS 7,905,639 7,462,091 94% 8,474,142 3,283,427 39% ; 8,311,509 98% ; 162,633: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - General Fund 100,000 100,000 100% 100,000 72,916 73% 3 175,000 175% 75,000, D Transfers In - CDD Electrical 93,264 - 0% 37,468 40% (55,796)! Reserve Transfers Out (85,695) (85,695) 100% (100,518) (41,876) 42% (100,518) 100% Transfers Out - CDD Reserve (1,462,386) (1,125,936) 77% (148,226) (61,761) 42% (166,511) 112% (18,285)! TOTALTRANSFERS (1,448,081) (1,111,631) 77% ; (55,480) (30,720) 55% ; (54,561) 98% 919; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,982,004 1,783,536 90% 1,012,694 1,253,356 124% 1,253,356 124% 240,662 Resources over Requirements 563,181 581,451 (222,416) 271,694 ! 25,117 247,533 Net Transfers - In (Out) � (1,448,081) (1,111,631) ? e (55,480) (30,720) tE (54,561) i 919 ; TOTAL FUND BALANCE $ 1,097,104 $ 1,253,356 114% ; $ 734,798 $ 1,494,330 203% ; ; $1,223,912 167% ; $489,114: A Interest projection based on current investment rate and anticipated cash balances B Revenue collection is higher than anticipated C Projection reflects unfilled FTE D Transfer appropriated in the General Fund is $175K Budget to Actuals Report Road - Fund 325 FY21 YTD November 30, 2020 (unaudited) RESOURCES Motor Vehicle Revenue Federal - PILT Payment Federal Reimbursements Other Inter -fund Services Forest Receipts Sale of Equip & Material Cities-Bend/Red/Sis/La Pine Interest on Investments Mineral Lease Royalties Miscellaneous Assessment Payments (P&I) State Miscellaneous TOTALRESOURCES REQUIREMENTS Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS TRANSFERS Transfers Out TOTALTRANSFERS 41.7% Year Complete Fiscal Year 2020 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 17,609,539 16,795,577 95% 14,810,507 6,409,148 43% 15,540,407 105% 729,900: A 1,510,450 2,310,002 153% 1,690,574 2,061,977 122% 2,061,977 122% 371,403! B 181,757 372,623 205% 1,325,874 1,102,975 83% 1,102,975 83% (222,899)! C 1,156,581 1,070,000 93% 1,114,070 147,665 13% 1,114,070 100% 915,000 709,742 78% 723,085 - 0% 723,085 100% 358,000 465,999 130% 396,000 258,629 65% 396,000 100% 660,000 421,344 64% 385,000 107,720 28% 385,000 100% 246,000 174,141 71% 114,000 31,360 28% F 75,300 66% ! (38,700)! D 60,000 54,184 90% 60,000 40,447 67% s 60,000 100% 57,500 76,388 133% 54,000 34,857 65% 54,000 100%, 11,000 19,766 180% 8,000 2,585 32% 8,000 100% 20,000 25,805 129% - 2,183 2,184 2,184! 22,785,827 22,495,570 99% 20,681,110 10,199,545 49% 21,522,997 104% ; 841,887: Budget Actuals % Budget Actuals % Projection % $ Variance 6,447,671 6,284,546 97% 6,709,180 2,621,464 39% 6,384,350 95% 324,830: E 8,092,165 6,782,513 84% 7,753,525 2,510,744 32% i 7,753,525 100% 33,500 27,706 83% 50,500 6,006 12% 50,500 100% 14,573,336 13,094,764 90% 14,513,205 5,138,214 35% ; 14,188,375 98% ; 324,830: Budget Actuals % Budget Actuals % Projection % $ Variance (11,910,575) (11,910,575) 100% _ (6,683,218) (1,418,945) 21% � (6,683,218) 100% (11,910,575) (11,910,575) 100% ; (6,683,218) (1,418,945) 21% (6,683,218) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 6,001,989 6,726,840 112% 2,695,786 4,217,071 156% 4,217,071 156% , 1,521,285, Resources over Requirements 8,212,491 9,400,806 6,167,905 5,061,331 7,334,622 1,166,717! Net Transfers - In (Out) (11,910,575) (11,910,575) (6,683,218) (1,418,945) (6,683,218) TOTAL FUND BALANCE $ 2,303,905 $ 4,217,071 183% $ 2,180,473 $ 7,859,457 360% $ 4,868,475 223% ; $2,688,002 A Updated based on YTD receipts B Updated based on most recent information from the State C Actual cost of Cascade Lakes Highway Chip Seal project D Interest projection based on current investment rate and anticipated cash balances E Projected Personnel savings based on FY21 average vacancy rate of 5.7% 01E �{ Budget to Actuals Report Adult P&P - Fund 355 FY21 YTD November 30, 2020 (unaudited) RESOURCES DOC Grant in Aid SB 1145 CJC Justice Reinvestment DOC Measure 57 Probation Supervision Fees Interfund- Sheriff Gen Fund/Crime Prevention Interest on Investments State Subsidy Electronic Monitoring Fee Probation Work Crew Fees Miscellaneous State Miscellaneous DOC-Family Sentence Alt Oregon BOPPPS TOTALRESOURCES REQUIREMENTS 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 4,353,626 i 4,621,782 106% , 4,621,780 2,310,891 50% 4,621,780 100% A 712,530 1,014,690 142% 797,504 391,752 49% 797,504 100% 236,142 i 239,005 101% 239,005 239,005 100% 239,005 100% B 160,000 183,688 115% � 170,000 72,320 43% � � 170,000 100% 50,000 55,000 110% 50,000 22,917 46% 50,000 100% 50,000 50,000 100% 50,000 50,000 100%, 50,000 100% C 77,500 64,896 84% f 37,700 25,026 66% 60,100 159% S 22,400! D 16,298 16,703 102% , 16,298 0% - 0% (16,298)! E 2,000 20,182 999% 10,000 2,198 22% 5,000 50% (5,000)! F 2,000 1,923 96% 2,000 280 14% 500 25% (1,500), G 500 i 15,412 999% � 1,000 335 33% � � 1,000 100%! - - 22,986 � - 167 � � 167 � 167, 114,682 223,746 195% - - 40,933 - - 5,775,278 6,570,946 114% ; 5,995,287 3,114,889 52% ; 5,995,056 100% ; (231); Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 4,809,644 4,753,486 99% 5,157,473 2,019,771 39% 4,984,153 97% 173,320; H Materials and Services 1,844,847 1,663,665 90% 1,923,795 568,423 30% 1,923,795 100% Capital Outlay 15,000 11,000 73% TOTAL REQUIREMENTS 6,669,491 6,428,151 96% ; 7,081,268 2,588,194 37% ; 6,907,948 98% ; 173,320, TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 285,189 285,189 100% 285,189 118,834 42% 285,189 100% i Transfer to Vehicle Maint (62,000) (62,000) 100% (97,693) (40,705) 42% (97,693) 100% TOTALTRANSFERS 223,189 223,189 100% ; 187,496 78,129 42% ; 187,496 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,590,000 2,754,005 106% 2,714,814 3,119,990 115% 3,119,990 115%, 405,17& Resources over Requirements (894,213) 142,795 (1,085,981) 526,695 (912,892) 173,089' Net Transfers - In (Out) 223,189 223,189 187,496 78,129 i 187,496 TOTAL FUND BALANCE $ 1,918,976 $ 3,119,990 163% ; $ 1,816,329 $ 3,724,813 205% ; $ 2,394,594 132% ; $578,265, A State Dept. of Corrections Grant in Aid received quarterly B State Measure 57 received in one annual payment C One-time annual transfer received D Interest projection based on current investment rate and anticipated cash balances E State Dept of Corrections gave notice that these funds have been eliminated for FY21 F Adjusted projection based on YTD revenue. In FY20 a contractor began providing EM directly; however, payments and garnishments from clients in which the County provided service directly continue to be recorded but it is anticipated that these will taper off. G Adjusted projection based on YTD revenue. Due to COVID-19, no community service crew has operated thus reducing fees. H Projected Personnel savings based on FY21 average vacancy rate of 4.5% 01E Budget to Actuals Report L� 0 Road CIP - Fund 465 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ variance State Miscellaneous 1,944,893 1,668,168 86% 2,258,100 - 0% 2,258,100 100% Interest on Investments 198,000 366,198 185% 209,700 154,070 73% 369,800 176% 160,100, A Interfund Payment - 111,340 TOTAL RESOURCES 2,142,893 2,145,706 100% ; 2,467,800 154,070 6% ; 2,627,900 106% ; 160,100: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ variance Materials and Services 71,748 71,748 100% 158,465 66,027 42% k 158,465 100% Capital Outlay 13,764,165 5,752,905 42% 19,877,585 2,494,341 13% 19,852,812 100% 24,773, TOTAL REQUIREMENTS 13,835,913 5,824,653 42% ; 20,036,050 2,560,368 13% 20,011,277 100%; 24,773; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ variance Transfers In 12,014,914 11,431,979 95% 7,517,657 0% 7,517,657 100%, TOTALTRANSFERS 12,014,914 11,431,979 95% ; 7,517,657 0% ; ; 7,517,657 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ variance Beginning Fund Balance 15,616,536 17,759,555 114% 23,154,407 25,512,586 110% 25,512,586 110% 2,358,179� Resources over Requirements (11,693,020) (3,678,947) (17,568,250) (2,406,299) E (17,383,377) 184,873 Net Transfers - In (Out) ? 12,014,914 11,431,979 7,517,657 - 7,517,657 TOTAL FUND BALANCE $ 15,938,430 $ 25,512,586 160% ; $ 13,103,814 $ 23,106,288 176% ; ; $ 15,646,866 119% ; $2,543,052: A Interest projection based on current investment rate and anticipated cash balances Budget to ActuaUs Report Road CUP (Fund 465) - Capital Outlay Summary by Project 41.7% FY21 YTO Novomber30. 2020 (unaudited) Year Completed Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance TvmawRes Rd: oeRiley mBailey nu Sisemomoridgo ARTS Project 180,746 TunnuonneRefinement Plan uaooa«Tvma|o ~~~~°° ^~ S.Canal -^om oomom oAvenue: Hwy ormnmat|mpm Paving Ward Road a.ounu|/Ho|mhv|�vvay -056 3-- ruma|oRoad /rvma/vPlace omaanonumn'umamnu/n�or 1,316,946 ''- 335836 Spring River Bridge Parking Imp 12,122 wEwoouoand 1rTH '~~~-'~ 1099111 ''~ HvnmmRu: Loco numTuma|oRo Cascade Lakes Hwy Bike Facilities """"" 11,856^^~ Transportation System Plan Update Slurry Seal e000 284,432 usuoWard numHamby onorBend North Corridor o,mminonuBridge Alfalfa Mkt Rd: Powell Butte Hwy Paving Fyremrnu Paving ma.Century o, Teneunnnovvuv�wo�,Foaoimn�St. "^" Rickard Rd: Groff nmmuuuo pavmgPowmneuooHwr 000 -`' - Smith Rock Way Bridge Replace Deschutes Mkt wmHamohooxRound uaors.Century ortouSraeuunury Johnsonnuounmvvuminou|nnv ^~�^^ ^^~ 40,540 Speed Feedback Sign Installation Guardrail Improvements Bend District Local Roads ' City mLapinoLocal Roads aiuowamnamp|mpmvomonm �-''' �''- ainnaoo/mpmvomonto `^ '-` `~ 100 TOTAL �I E� Budget to Actuals Report Solid Waste - Fund 610 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ variance Franchise Disposal Fees 6,437,500 6,444,136 100% 6,630,625 2,698,436 41% 6,630,625 100% A Private Disposal Fees 2,419,046 2,556,619 106% 2,491,617 1,302,811 52% 2,491,617 100%, A Commercial Disp. Fee 2,252,225 2,429,879 108% 2,319,792 1,143,595 49% E 2,319,792 100% Franchise 3% Fees 265,000 297,352 112% 3 280,000 26,342 9% ! 280,000 100%! B Yard Debris 216,761 290,794 134% , 216,761 159,626 74% 216,761 100% C Miscellaneous 48,336 191,720 397% 88,096 30,626 35% 88,096 100%! D Interest 59,000 49,256 83% 23,700 23,005 97% 55,200 233% 31,500, E Special Waste 15,000 28,830 192% 15,000 24,718 165% 27,000 180% 12,000 F Recyclables 12,000 12,163 101% 12,000 5,662 47% 12,000 100% Leases 1 1 100%! 1 0% 1 100% TOTAL RESOURCES 11,724,869 12,300,751 105% ; 12,077,592 5,414,820 45% 12,121,092 100% ; 43,500: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ variance Personnel Services 2,538,776 2,393,257 94% 2,518,594 1,006,758 40% 2,487,209 99% 31,385, G Materials and Services 4,927,163 4,251,937 86% 5,227,119 1,455,440 28% 5,227,119 100% H Capital Outlay 56,000 11,724 21% 162,500 0% 162,500 100% Debt Service 862,100 861,644 100% 945,000 280,671 30% 945,000 100% I TOTAL REQUIREMENTS 8,384,039 7,518,563 90% 8,853,213 2,742,869 31% 8,821,828 100%; 31,385, TRANSFERS Budget Actuals % Budget Actuals % Projection % $ variance SW Capital & Equipment (3,296,192) (3,296,192) 100% ; (3,684,280) (927,537) 25% (3,684,280) 100% Reserve TOTALTRANSFERS ; (3,296,192) (3,296,192) 100% ; (3,684,280) (927,537) 25% (3,684,280) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ variance Beginning Fund Balance 600,000 799,570 133% 1,179,819 2,285,566 194% 2,285,566 194% 1,105,747: J Resources over Requirements 3,340,830 4,782,188 3,224,379 2,671,951 3,299,264 74,885! Net Transfers - In (Out) € (3,296,192) (3,296,192) F (3,684,280) (927,537) r ! k (3,684,280) I ! TOTAL FUND BALANCE $ 644,638 $ 2,285,566 355% ; $ 719,918 $ 4,029,981 560% ; ; $ 1,900,550 264% ; $1,180,632: A Total disposal fee projections reflect management's best estimate of revenues to be collected. Disposal tons are typically higher in summer with reductions in winter. B Annual fees due April 15, 2021; received the Wilderness Garbage monthly installments C Revenue is seasonal with higher utilization in the summer months D FY20 includes the unbudgeted sale of a loader and 2 trailers, LED light incentives and royalty payments. The $13.7K for the 2 trailers was budgeted in FY21, but sold in late June. E Interest projection based on current investment rate and anticipated cash balances F Revenue source is unpredictable and dependent on special clean-up projects; recent large contaminated soil projects from cleaning up a power substation and routine cleaning of a decant facility G Personnel savings based on FY21 YTD average vacancy rate of 1.72% with factors for the recently filled open position (timing and rate); budget and projection includes a Time Management payout estimate for the Director's retirement. H M&S activities are expected to meet budget with pending services and repairs and delayed invoices I Principal and interest payments due in Nov and May for existing debt; budget includes an interest estimate for funding the Negus Transfer Station j An influx of disposal volume and postponement of costs in FY20, such as the waste characterization study, positively impacted the beginning fund balance. 01 ES9&1 Budget to Actuals Report Fair & Expo - Fund 615 FY21 YTD November 30, 2020 (unaudited) RESOURCES Events Revenue Food & Beverage Rights & Signage Storage Horse Stall Rental Interfund Payment Camping Fee Miscellaneous Interest TOTALRESOURCES REQUIREMENTS Personnel Services Personnel Services - F&B Materials and Services Materials and Services - F&B Debt Service TOTAL REQUIREMENTS 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 687,000 328,219 48% 625,000 224,506 36% 534,000 85% (91,000): A 568,000 280,874 49% 548,500 66,948 12% 222,000 40% (326,500)! B ! 120,000 114,100 95% 125,000 13,000 10% 111,000 89% (14,000)! C ! 71,000 83,158 117% 75,000 29,149 39% 87,000 116% ! 12,000! D i 62,000 37,386 60% 52,000 665 1% 15,000 29% (37,000) 30,000 143,956 480% 30,000 128,970 430% 188,000 627% 158,000, E ! 18,000 5,600 31% 12,500 0% 12,000 96% (500)! i 3,500 2,236 64% 250 1,874 750% , 1,874 750% 1,624 i 2,000 (5,006) -250%! (2,200) 268 .12% 600 -27% 2,80& F 1,561,500 990,522 63% 1,466,050 465,381 32% ; 1,171,474 80% (294,576); Budget Actuals % Budget Actuals % 1,176,169 1,108,608 94% 840,704 422,382 50% 157,430 158,556 101% 165,518 67,018 40% < 795,788 787,884 99% 702,149 211,406 30% 234,600 217,425 93% 257,600 45,378 18% 100,800 100,151 99% 104,400 4,745 5% 2,464,787 2,372,624 96% ; 2,070,371 750,930 36% ; TRANSFERS Budget Actuals % Budget Actuals % Transfers In - Room Tax 383,910 383,910 100%, 250,000 208,194 83% Transfers In - General Fund 200,000 200,000 100% 200,000 83,338 42% Transfers In - Park Fund i 30,000 30,000 100% 30,000 12,500 42% 3 Transfers In - Room Tax (as i 25,744 323,348 999% 25,744 10,729 42% f needed) Transfers In - County Fair 395,000 ! 250,000 63% 1 i Transfers In - F&E Capital - 300,000 ; Reserve Transfers Out (11,791) (11,791) 100% - (10,777) (4,490) 42% TOTALTRANSFERS 1,022,863 1,475,467 144% ; 494,967 310,271 63% ; Projection % $ Variance 1,007,132 120% , (166,428), G 160,871 97% 4,64T G 583,000 83% 119,149 H 100,000 39% 157,600! H 104,400 100% 1,955,403 94% ; 114,968; Projection % $ Variance 495,701 198% 245,701; 1 200,000 100% 30,000 100% 70,204 273% 44,460! J ! t (10,777) 100%: t 785,128 159% ; 290,161: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 80,000 (94,564) -118%, 364,904 (1,199) 0% (1,199) 0% (366,103): Resources over Requirements (903,287) (1,382,102) (604,321) (285,549) (783,929) (179,608) Net Transfers - In (Out) 1,022,863 1,475,467 494,967 310,271 785,128 290,161� TOTAL FUND BALANCE $ 199,576 ($ 1,199) -1% $ 255,550 $ 23,524 9% ; 0% ($255,550); Note: Resources to date show an increase compared to PY YTD A Events revenue severely impacted by gathering size limitations B F&B revenues severely impacted by gathering size limitations C Expected to be under budget due to COVID19 impacts D Increase in rate for FY21; filling faster than prior year E Reimbursement from RV Park for personnel expenditures recorded in F&E. Includes interfund payment for 3.0 FTE whose cost will be absorbed by Roads through 01.31.21. F Interest projection based on current investment rate and anticipated cash balances G Temporary reduction of employee hours to reduce expense H Reduction from budget planned to offset event revenue loss I Budgeted Transfer appropriations in the TRT Fund are greater than the Transfer -In budget in F&E J $250K of budgeted transfers in TRT are to be transferred on an as needed basis 01 ES �{ Budget to Actuals Report Annual County Fair - Fund 616 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Grant 52,000 53,167 102% 52,000 53,167 102% _ 53,167 102% 1,167: Commercial Exhibitors I 122,000 12,600 10% (950) 999% , (950) 999% (950)! Interest on Investments 200 (166) -83% (73) 999% , (200) 999% ! (200)! A Merchandise Sales I 5,000 5,246 105% , Fair Sponsorship 37,500 19,108 51% Concessions and Catering 1 425,000 466,503 110% I S i 1 I Gate Receipts I 560,000 561,460 100% I 1! I I Carnival 340,000 328,274 97% Livestock Entry Fees 7,000 4,731 68% RN Camping/Horse Stall Rental I 26,000 625 2% f t t 4 1 Concert 50,000 12,000 24% Rodeo I 25,000 5,650 23% TOTAL RESOURCES ; 1,649,700 1,469,198 89% ; 52,000 52,144 100% ; ; 52,017 100% ; 17; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 164,638 157,448 96% 110,000 71,645 65% 136,928 124% _ (26,928): B Materials and Services 1,340,062 1,457,840 109% 17,000 17,739 104% 18,000 106% (1,000)! TOTAL REQUIREMENTS ; 1,504,700 1,615,288 107% ; 127,000 89,384 70% 154,928 122% ; (27,928); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - TRT 1% 250,000 250,000 100% 75,000 31,500 42% 75,000 100% Transfer Out - Fair & Expo (395,000) (250,000) 63% TOTALTRANSFERS (145,000) - 0% ; 75,000 31,500 42% 75,000 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance - 98,629 (47,461) (47,461) (47,461), Resources over Requirements 145,000 (146,090) (75,000) (37,239) (102,911) (27,911) Net Transfers - In (Out) d (145,000) 1 75,000 31,500 ? 75,000 t 6 E C TOTAL FUND BALANCE ($ 47,461) ($ 53,200) ; , ($ 75,372) ; ($75,372); A Interest projection based on current investment rate and anticipated cash balances B Personnel projection includes the full furlough of one employee in December, January & February "'s` Budget to Actuals Report Annual County Fair - Fund 616 CY21 YTD November 30, 2020 (unaudited) 2020 Fair 2019 Fair 2020 Projection RESOURCES Gate Receipts $ 562,065 $ - $ - Carnival 328,274 ! - - Commercial Exhibitors 312,402 (5,800) (5,800) Livestock Entry Fees 4,731 - - R/V Camping/Horse Stall Rental 29,250 ' - - Merchandise Sales 5,246 - - Concessions and Catering 293,076 - - Fair Sponsorship 148,943 (22,250) (22,250) TOTAL FAIR REVENUES $ 1,683,988 " $ (28,050) $ (28,050) OTHER RESOURCES State Grant 53,167 53,167 53,167 Interest 204 19 19 Miscellaneous - - - TOTAL RESOURCES $ 1,737,358 ' $ 25,136 $ 25,136 REQUIREMENTS Personnel 155,215 152,905 156,531 Materials & Services 1,509,039 85,216 85,216 TOTAL REQUIREMENTS $ 1,664,255 $ 238,121 $ 241,746 TRANSFERS Transfer In - TRT 1% 200,000 156,500 162,750 Transfer Out - Fair & Expo (250,000) - - TOTAL TRANSFERS $ (50,000) ji $ 156,500 $ 162,750 Net Fair $ 23,104 $ (56,485) $ (53,860) Beginning Fund Balance on Jan 1 $ (19,819) $ 3,285 $ 3,285 Ending Balance $ 3,285 $ (53,202) $ (50,575 A Cash receipts for Fair 2020 were received in July -December of 2019, but refunded in 2C B , Projection includes furlough plan that is estimated to be in place through 02.28.21 C Ending balance including cash receipts received in July -December of 2019 would be ($22,525) for 2020 Projections �l ES Budget to Actuals Report Fair & Expo Capital Reserve Fund 617 41.7% FY21 YTD November 30, 2020 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 16,000 21,189 132% 14,000 4,691 34% 12,000 86% (2,000), A TOTALRESOURCES 16,000 21,189 132% 14,000 4,691 34% 12,000 86% (2,000): REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 345,000 243,985 71% 235,000 2,460 1% 235,000 100% Capital Outlay 1,017,775 180,946 18% 166,940 86,796 52% 166,940 100% TOTAL REQUIREMENTS 1,362,775 424,931 31% 401,940 89,256 22% 401,940 100% TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - TRT 1 % 286,687 286,687 100% 253,158 105,482 42% 420,351 166% 167,193, B Transfers Out (300,000) (300,000) 100% - - TOTAL TRANSFERS (13,313) (13,313) 100% 253,158 105,482 42% 420,351 166%167,193: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,360,088 1,143,224 84% 1,143,224 726,169 64% 726,169 64% (417,055): Resources over Requirements (1,346,775) (403,742) (387,940) (84,566) (389,940) (2,000): Net Transfers - In (Out) (13,313) (13,313) 253,158 105,482 420,351 167,193! TOTAL FUND BALANCE $726,169 999% $1,008,442 $747,085 74% $756,580 75% ($251,862): A Interest projection based on current investment rate and anticipated cash balances R Revised estimate based on FY21 TRT collections at 95.4% of FY20 ��S�� Budget to Actuals Report L� I C 0G RV Park - Fund 618 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance RV Park Fees < 31 Days 405,200 412,954 102% 400,200 246,201 62% 372,129 93% (28,071): A RV Park Fees > 30 Days 5,000 13,050 261% , 12,000 3,220 27% 11,050 92% (950)! Interest on Investments 12,000 10,746 90% ! 7,600 1,349 18% 3,200 42% (4,400)! B Cancellation Fees 5,000 5,271 105% ! 5,500 155 3% 155 3% (5,345)! C Washer / Dryer 4,000 5,913 148% ! 4,000 3,108 78% 5,060 127% 1,060! D Vending Machines 3,000 1,821 61% 3,000 565 19% 752 25% (2,248)! D Miscellaneous 2,000 2,332 117% f 2,250 1,244 55% 1,244 55% (1,006)! Good Sam Membership Fee 1,500 476 32% 1,500 - 0% 0% (1,500)! E Good Sam Discounts (7,109) 999% E - - E TOTAL RESOURCES 437,700 445,454 102% ; 436,050 255,842 59% 393,590 90% (42,460); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 318,273 281,699 89% 321,402 114,619 36% 288,544 90% 32,858: F Debt Service 222,100 221,810 100% 222,500 - 0% 222,500 100% f TOTAL REQUIREMENTS ; 540,373 503,509 93% 543,902 114,619 21% 511,044 94% 32,858: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Park Fund 160,000 160,000 100% 160,000 80,000 50% 160,000 100% Transfers In - TRT Fund 35,000 35,000 100%! 25,000 8,400 34% 20,000 80% (5,000)t G Transfer Out - RV Reserve (502,000) (502,000) 100% : (621,628) (310,814) 50% (290,484) 47% 331,144, H TOTALTRANSFERS (307,000) (307,000) 100% ; (436,628) (222,414) 51% (110,484) 25% ; 326,144; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 560,000 592,992 106% = 587,992 227,936 39% 227,936 39% (360,056): Resources over Requirements (102,673) (58,056) (107,852) 141,222 (117,454) (9,602) Net Transfers - In (Out) (307,000) (307,000) (436,628) (222,414) (110,484) 326,144� TOTAL FUND BALANCE $ 150,327 $ 227,936 152% ; $ 43,512 $ 146,745 337% ; ; ($ 2) 0% ($43,514); A 7,126 RV spaces, 43.94% utilization YTD. Prior year comparable was 7,925 RV spaces, 48.87% utilization YTD B Interest projection based on current investment rate and anticipated cash balances C Cancellation Fees waived for FY21 due to COVID D Reduced due to reduction in space utilization E The Good Sam incentive program was discontinued during Fall 2019. F YTD expenses are higher than prior year due to earlier than usual marketing expense. Budget reductions planned to offset projected revenue reductions. G Budgeted Transfer appropriations in the TRT Fund are less than the Transfer -In budget in the RV Park Fund H Projected transfer reduced due to actual Beg Working Capital coming in lower than budget, as well as projected revenue reductions �l E S (- Budget to Actuals Report RV Park Reserve - Fund 619 41.7% FY21 YTD November 30, 2020 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 1 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 12,550 3,801 30% 1,100 3,959 360% 9,500 864% 8,40& A TOTAL RESOURCES 12,550 3,801 30% 1,100 3,959 360% 9,500 864% 8,400, REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 6,641 999% Capital Outlay 100,000 1,694 2% 100,000 0% 100,000 100%: TOTAL REQUIREMENTS 100,000 8,335 8% 100,000 0% 100,000 100%: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - RV Park Ops 502,000 502,000 100% 621,628 310,814 50% 290,484 47% (331,144)� B TOTALTRANSFERS 502,000 502,000 100% 621,628 310,814 50% 290,484 47% (331,144): FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 490,000 497,466 102% 497,466 102% 7,466� Resources over Requirements (87,450) (4,534) (98,900) 3,959 (90,500) 8,400, Net Transfers - In (Out) 502,000 502,000 621,628 310,814 290,484 (331,144), TOTAL FUND BALANCE $414,550 $497,466 120%: $1,012,728 $ 812,239 80% $ 697,450 69% ($315,278): A Interest projection based on current investment rate and anticipated cash balances B Projected transfer reduced due to actual Beg Working Capital coming in lower than budget, as well as projected revenue reductions in the RV Fund ��E - S ` 0G Budget to Actuals Report Risk Management - Fund 670 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,255,108 1,311,863 105% , 1,188,848 509,910 43% 1,188,848 100% General Liability 1,072,326 1,055,486 98% 990,628 401,334 41% 990,628 100% Property Damage 392,923 395,921 101% , 373,698 155,645 42% 373,698 100% Unemployment 323,572 304,607 94% 323,572 281,820 87% 323,572 100% A Vehicle 195,580 203,005 104% : 218,185 92,611 42% 218,185 100% Interest on Investments 137,000 150,197 110% 87,200 55,334 63% 132,800 152% 45,600� B Claims Reimbursement 82,000 460,881 562% 50,000 11,866 24% 50,000 100% Skid Car Training 34,000 34,830 102% 30,000 - 0% 5,000 17% (25,000)! Process Fee= Events/ Parades 2,000 765 38% 1,500 0% 500 33% (1,000)! Loss Prevention 30 - 0% 10 0% 10 100% Miscellaneous 500 12,967 999% 5 0% 30,000 999% 29,995! C TOTAL RESOURCES ; 3,495,039 3,930,523 112% ; 3,263,646 1,508,520 46% ; 3,313,241 102% ; 49,595, REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,460,000 713,047 49% 1,560,000 372,292 24% 1,260,000 81% = 300,000, General Liability 1,400,000 311,666 22% 1,100,000 204,947 19% 1,400,000 127% ! (300,000)! D Insurance Administration 592,059 470,972 80% 584,104 139,811 24% 551,217 94% 32,887! E Property Damage 400,236 701,454 175% 200,240 284,906 142% < 450,000 225% (249,760)! F Unemployment 130,000 63,289 49% 200,000 33,414 17% 200,000 100% Vehicle 150,000 179,835 120% 150,000 73,559 49% 180,000 120% ! (30,000) TOTAL REQUIREMENTS ; 4,132,295 2,440,263 59% 3,794,344 1,108,929 29% ; 4,041,217 107% ; (246,873); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out - Vehicle Replace (6,918) (6,918) 100%, (3,500) (1,457) 42% (3,500) 100% TOTALTRANSFERS (6,918) (6,918) 100% ; (3,500) (1,457) 42% (3,500) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 6,100,000 7,193,407 118% 7,000,000 8,676,750 124% 8,676,750 124% 1,676,750� Resources over Requirements (637,256) 1,490,260 (530,698) 399,591 (727,976) (197,278); Net Transfers - In (Out) + (6,918) (6,918) S (3,500) (1,457) k 3 (3,500) [ I TOTAL FUND BALANCE $ 5,455,826 $ 8,676,750 159% ; $ 6,465,802 $ 9,074,884 140% ; ; $ 7,945,274 123% ; $1,479,472: 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 FY20 includes $12,962 in State reimbursements for COVID related costs. D General Liability claims are difficult to budget and predict E Projected Personnel savings based on FY21 savings to date F YTD actuals includes Property Insurance Premium, which is an annual expenditure o �IES ` . p& Budget to Actuals Report LZ . , Health Benefits - Fund 675 FY21 YTD November 30, 2020 (unaudited) RESOURCES Internal Premium Charges COIC Premiums Retiree / COBRA Premiums Employee Co -Pay Interest Prescription Rebates Claims Reimbursement & Other TOTALRESOURCES REQUIREMENTS Health Benefits Deschutes On -Site Pharmacy Deschutes On -Site Clinic Wellness TOTAL REQUIREMENTS 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 17,411,292 i 17,841,713 102% 17,831,938 7,674,171 43% 17,831,938 100% 1,967,021 1,670,202 85% � 1,600,000 525,372 33% � � 1,574,688 98% � (25,312)! i 1,433,000 i 1,023,556 71% � 1,035,000 226,603 22% � � 1,020,000 99% � (15,000)! 1,041,120 1,060,127 102% � 1,031,400 466,753 45% € � 1,120,207 109% � 88,807, 346,000 334,654 97% 216,200 110,831 51% 266,000 123% 49,800! A 75,000 174,148 232% 90,000 43,063 48% 90,000 100% 45,000 386,585 859% 80,000 - 0% 80,000 100% 22,318,433 22,490,985 101% ; 21,884,538 9,046,794 41% ; 21,982,833 100% ; 98,295: Budget Actuals % Budget Actuals % Projection % $ Variance 20,550,836 18,763,095 91% 19,937,274 6,056,812 30% 18,833,754 94% 1,103,520, B 2,242,104 2,952,787 132% 2,417,092 450,873 19% 2,417,092 100% B 1,141,691 i 1,084,574 95% 1,101,467 370,947 34% 1,101,467 100%! B 180,380 152,600 85% � 164,340 75,682 46% � t 164,340 100%! -! B 24,115,011 22,953,057 95% ; 23,620,173 6,954,314 29% 22,516,653 95% ; 1,103,520: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 16,106,294 16,563,905 103% 15,323,729 16,101,833 105% 16,101,833 105% 778,104; Resources over Requirements (1,796,578) (462,072) (1,735,635) 2,092,480 (533,820) 1,201,815 f Net Transfers - In (Out) t k E � TOTAL FUND BALANCE $ 14,309,716 $ 16,101,833 113% ; $13,588,094 $ 18,194,313 134% ; $ 15,568,013 115% ; $1,979,919: A Interest projection based on current investment rate and anticipated cash balances B Amounts are paid 1 month in arrears; projection compared to historical costs for reasonableness; 12-month rolling average trending downward ,31Es ` Budget to Actuals Report 911 - Fund 705 and 710 FY21 YTD November 30, 2020 (unaudited) 41.7% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Property Taxes - Current Yr 8,809,419 8,876,513 101% 9,113,459 8,665,153 95% 9,155,214 100% 41,75& A Telephone User Tax 900,000 1,053,847 117% 1,106,750 340,292 31% 1,306,750 118% ! 200,000 B Police RMS User Fees ! i 250,000 386,751 155% i 250,000 66,225 26% 250,000 100%! Contract Payments 51,300 71,929 140% 157,252 16,250 10% 157,252 100%, Interest E 157,000 184,668 118% 90,400 52,928 59% 123,900 137% 33,500! C Property Taxes - Prior Yr 100,000 262,105 262% 90,000 93,242 104% 100,000 111% , 10,00& State Reimbursement 125,000 107,881 86% 83,000 3,000 4% 83,000 100%, D User Fee 73,680 135,243 184% � 73,000 2,156 3% � 73,000 100% � Data Network Reimbursement 55,000 96,232 175% ! 55,000 0% 55,000 100%! Property Taxes - Jefferson Co. ! 30,000 34,547 115% ! 33,637 33,432 99% ! 33,637 100% Miscellaneous 11,951 ° 70,966 594 /° 12,200 11,184 92% � 12,200 100% � TOTAL RESOURCES 10,563,350 11,280,682 107% ; 11,064,698 9,283,863 84% ; 11,349,953 103% ; 285,255; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 7,462,575 6,980,012 94% 7,620,458 2,994,628 39% 7,294,014 96% 326,444: E Materials and Services 3,387,761 3,072,800 E 91% 3,476,381 1,335,053 38% t 3,476,381 100% Capital Outlay 1,400,000 669,792 48% 1,480,000 263,855 18% t 1,480,000 100%, - TOTAL REQUIREMENTS 12,250,336 10,722,604 88% 12,576,839 4,593,536 37% ; 12,250,395 97% ; 326,444: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 7,753,706 8,604,816 111%, 8,341,418 9,162,894 110% < 9,162,894 110% 821,47& ! Resources over Requirements (1,686,986) 558,079 (1,512,141) 4,690,327 (900,442) 611,699! � E ! E 1 1 Net Transfers - In (Out) i 6 k l F 4 TOTAL FUND BALANCE $ 6,066,720 $ 9,162,894 151% ; $ 6,829,277 $ 13,853,221 203% ; $ 8,262,452 121% ; $1,433,175: A Current year taxes received primarily in November, February and May; actual 20-21 TAV is 5.40% compared to FY19.20 vs. 5.00% budgeted B Telephone maintenance reimbursements are received in a lump sum by early spring; anticipating an increase in telephone tax from the State that was not budgeted c Interest projection based on current investment rate and anticipated cash balances D State GIS reimbursements are received quarterly E Personnel savings based on FY21 YTD average vacancy rate of 6.8% -� E S COG 41, 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 December 21, 2020 DATE: December 16, 2020 FROM: Laura Skundrick, Administrative Services, 541-330-4627 TITLE OF AGENDA ITEM: 2021 Arts & Culture Grant Follow -Up RECOMMENDATION & ACTION REQUESTED: Revisit 2021 Arts & Culture program grant allocation SUMMARY: The Deschutes County Arts & Culture Grant Program is dedicated to supporting art and cultural initiatives in Deschutes County. During the FY 2021 Video Lottery Fund allocation process, the Board dedicated $20,000 for this program and on Wednesday December 16th, evaluated requests from 11 applicants and determined awards. During that meeting, an error occurred when tracking awards and funds have been over -allocated by $3,000. On December 21, staff will return to correct the allocation. ATTENDANCE: Laura Skundrick, Administrative Analyst