Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2020-413-Minutes for Meeting November 25,2020 Recorded 12/17/2020
�6/, BOARD F p- <r COMMISSIONERS 1300 NW Wall Street, Bend, Oregon (541) 3 88-65 70 Recorded in Deschutes County C J2020.413 Nancy Blankenship, County Clerk Commissioners' Journal 12/17/2020 3:39:35 PM U � cFS � (�� (I'�IIII�I"III�I'I�IfI�IIII'I� 2020 413 o 10:00 AM Wednesday® November 25, 2020 BARNES & SAWYER ROOMS VIRTUAL MEETING PLATFORM Present were Commissioners Patti Adair, Anthony DeBone and Commissioner Phil Henderson. Also present were Tom Anderson, County Administrator; David Doyle, County Counsel (via Zoom conference call and in person); and Samantha Pepper, Board Administrative Assistant (via Zoom conference call). Attendance was limited due to Governor's Virus Orders. This meeting was audio and video recorded and can be accessed at the Deschutes County Meeting Portal website http://deschutescountyor.igm2.com/Citizens/Default.aspx CALL TO ORDER: Chair Adair called the meeting to order at 10:00 a.m. PLEDGE OF ALLEGIANCE CITIZEN INPUT: Citizen Input was received from the online citizen input line from Ragnar Hartman and Morgan Johnstone. CONSENT AGENDA: Before the Board was Consideration of Approval of the Consent Agenda. BOCC MEETING NOVEMBER 25, 2020 PAGE 1 OF 5 DEBONE: Move approval of Consent Agenda HENDERSON: Second VOTE: DEBONE: Yes HENDERSON: Yes ADAIR: Chair votes yes. Motion Carried 1.Consideration of Board Signature of Document 2020-619, a Lease Between Deschutes County and Genoa Healthcare, LLC. 2. Consideration of Board Signature of Document 2020-698, a Lease to Oregon State University (OSU) for Extension Services Office Space in the South County Services Building, Located at 51340 Highway 97, La Pine. 3. Consideration of Board Signature of Resolution 2020-073, Transferring Contingency and Extending FTE in Health Services Fund for the Drug Free Communities Grant. 4. Consideration of Resolution 2020-070 Reallocating Vacant FTE and Additionally Increasing FTE for a Public Health Nurse II Position 5. Consideration of Board Signature of Resolution No. 2020-071, Reclassifying a Peer Support Specialist to a Behavioral Health Technician and Extending the Position from 6/30/2021 to 6/30/2022 �_.__:J_.__i:_� _r r`L _:.� r:.-... .. /-. ..F I'1 .. ..-... ...-.+ nl.. -1n'ln -770 llun 44.1 cn1 r-n '17 a. k-onside atio I UI Ch I JI�I IdLUI C of Lj Document ICI IL IVV. GVGV-/GO, VI 1/1 it I J7 I VJ- I G 7. Minutes of the November 9 2020 BOCC Meeting ACTION ITEMS: 1. COVID Update Public Health Director Nahad Sadr- Azodi updates Commissioners on COVID19. Commissioner Henderson asks how many community members have been hospitalized over the age of 55. Mr. Sadr- Azodi mentions that St. Charles does have surge capacity plans in place if needed. Commissioner Adair and Commissioner Henderson mention that people want to help out the community in anyway they can. Behavioral Health Director Janice Garceau mentions that her department is asking for help for COVID response. She also adds that Health is trying to get all leadership roles filled to assist with volunteers for COVID. BOCC MEETING NOVEMBER 25, 2020 PAGE 2 OF 5 Commissioner DeBone dismissed himself from the meeting at 10:48 a.m., to participate in a Press Conference consisting of City and County representatives. Commissioner Adair reminds the community to get their flu shot and thanks all our health care workers. 2. CARES Act Funding Update Chief Financial Officer Greg Munn updates Commissioners on Cares Act allocation. The county has spent $6.4 million to date. Commissioner Adair mentioned that funding in the amount of $40,000 is likely coming back from Mosaic Medical because not all allocated funds were going to be used in a timely manner. $43,000 dollars is unallocated to date and can be granted as per Commissioners direction. Commissioner Adair mentions that two larger counties in the state received disproportionate funding for COVID assistance while Deschutes County received a smaller portion. Discussion will continue to next week. 3. Treasurer and Finance Report Chief Financial Officer Greg Munn overviews the October 2020 Finance report with Commissioners. Commissioner Adair thanked Mr. Munn for r. 4. Discussion regarding Upcoming Public Hearing on Housekeeping Amendments to Deschutes County Code Legal Counsel Dave Doyle explains the County Code Housekeeping Amendments. The county is moving to a different platform for hosting County Code so updating the code was needed. There was minimal red line revisions throughout. He mentions that Title 3 will be pulled out of the Code BOCC MEETING NOVEMBER 25, 2020 PAGE 3 OF 5 and become a standalone Human Resources document. The Public Hearing is scheduled for December 2na Commissioner DeBone re -joins the meeting 11:53 p.m. OTHER ITEMS: • Commissioner Henderson mentions the new Facilities Project Review Committee to review capital improvement construction projects. • Commissioner DeBone mentions that he was just on regional press conference for COVID holiday outreach. RECESS: At the time of 11:59 a.m. the Board took a recess and reconvened the meeting at 1:00 p.m. EXECUTIVE SESSION: At the time of 1:00 p.m. the Board went into Executive Session under ORS 192.660 (2) (e) Real Property. The Board came out of Executive Session at 1:11 p.m. Staff was directed to proceed as discussed. COVID19 Business Assistance Update Internal Auditor David Givans updates Commissioners on upcoming business assistance in conjunction with the additional $2.2M CRF funding that the County is slated to receive. He mentions the different criteria for funding amounts. Commissioner DeBone suggests starting the funding at $5,000 and go up. Commissioner Henderson asked if child care providers should be included. Commissioner DeBone asked to remove 501 (c) (3) and childcare from the criteria BOCC MEETING NOVEMBER 25, 2020 PAGE 4 OF 5 but to advocate for businesses which were shut down recently like bars and gyms. Mr. Givans estimates next week as a start date for taking applications for these funds. RECESS: At the time of 1:34 p.m. the Board took a recess to watch the Governors live Press Conference and reconvened the meeting at 2:13 p.m. EXECUTIVE SESSION: At the time of the Board went into Executive Session at 2:24 p.m. under ORS 192.660 (2) (a) Personal. The Board came out of Executive Session at 2:29 p.m. Staff was directed to proceed as discussed. further . . il� _ I..,.f..rl. +I- — D.. rr: i-k— m r�i-ir�rr rii�i irr���� �i- 7-7Q DNA Being I o luf ll er Items to come le IJCIVI C U IC 0001 u, a IC i i t=L11 is Vvas aujuui i icu uL L./ J I v1 DATED this qA Day of _ 2020 for the Deschutes County Board of Commissioners, s, ATTI AAIR, CHAIR 'I ti�'v �y�J '• _, BOCC MEETING NOVEMBER 25, 2020 PAGE 5 OF 5 Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - www.deschutes.org BOCC MEETING AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 10:00 AM, WEDNESDAY, NOVEMBER 25, 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.or /g 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 directing government entities to utilize virtual meetings whenever possible and to take necessary measures to facilitate public participation in these virtual meetings. Beginning on May 4, 2020, meetings and hearings of the Deschutes County Board of Commissioners will be conducted in a virtual format. Attendance/Participation options include: Live Stream Video: Members of the public may still view the BOCC meetings/hearings in real time via the Public Meeting Portal at www.deschutes.org/meetings. 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 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 Board of Commissioners BOCC Meeting Agenda Wednesday, November 25, 2020 Page 1 of 4 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 CITIZEN INPUT (for items not on this Agenda) [Note: Because COVID-19 restrictions may limit or preclude in person attendance, citizen input comments may be emailed to citizen input@deschutes.org or you may leave a brief voicemail at 541.385.1734. To be timely, citizen input must be received by 9:00am on the day of the meeting.] CONSENT AGENDA 1. Consideration of Board Signature of Document 2020-619, a Lease Between Deschutes County and Genoa Healthcare, LLC. 2. Consideration of Board Signature of Document 2020-698, a Lease to Oregon State I Iniyarcity /(1C1 1) fnr FutPncinn rarvira-, nffira Snare in the rntith C'nunty Servires Building, Located at 51340 Highway 97, La Pine. 3. Consideration of Board Signature of Resolution 2020-073, Transferring Contingency and Extending FTE in Health Services Fund for the Drug Free Communities Grant. 4. Consideration of Resolution 2020-070 Reallocating Vacant FTE and Additionally Increasing FTE for a Public Health Nurse II Position 5. Consideration of Board Signature of Resolution No. 2020-071, Reclassifying a Peer Support Specialist to a Behavioral Health Technician and Extending the Position from 6/30/2021 to 6/30/2022 6. Consideration of Chair Signature of Document No. 2020-728, OHA #159163-12 7. Minutes of the November 9 2020 BOCC Meeting ACTION ITEMS 8. 10:10 AM COVID19 Update Board of Commissioners BOCC Meeting Agenda Wednesday, November 25, 2020 Page 2 of 4 9. 10:40 AM CARES Act Funding Update 10. 11:00 AM Treasurer and Finance Report for October 31, 2020 -Greg Munn, Chief Financial Officer 11. 11:40 AM Discussion Regarding Upcoming Public Hearing on Housekeeping Amendments to Deschutes County Code - David Doyle, Legal Counsel LUNCH RECESS OTHER ITEMS These can be any items not included on the agenda that the Commissioners wish to discuss as part of the meeting, pursuant to ORS 192.640, EXECUTIVE SESSION 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. 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. 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. Board of Commissioners BOCC Meeting Agenda Wednesday, November 25, 2020 Page 3 of 4 FUTURE MEETINGS: Additional meeting dates available at www.deschutes.org/meetingcalendar (Please note: Meeting dates and times are subject to change. All meetings take place in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. If you have questions regarding a meeting, please call 388-6572.) Board of Commissioners BOCC Meeting Agenda Wednesday, November 25, 2020 Page 4 of 4 O U7 C)- v (D `C N S O 3 (D 0 as t" Ul O O =zz 0 — (D h E 3 O �v v 1 Z:T /10Ul o a, v �Q LA0 (D Cr n i v O 77 199 1� 07 4-1 O Q v rn 7 fV U'1 O O Cases Ul 0 0 0 0 1Q ul Q /11 CC) /1.g N �r 0 0 Ln /9 S co co Im S/�1G cn G/ 1Q6 0 N 61 i /Q Ln C 1�, co N Ili N UJ �n 0 cn 0 0 0 0 0 i i • • • • • i � � N N W W 4�!. -p Ui Ln O Ln O Ui O Ui O Ln O O O O O O O O O O O O N O N Q0 W 0 w 0 v' N o 4_11� un o 00 k.0 N 0 + � c m Z) D 7 v (D > — Q EF� CT c, FF W W 00 � � � � N O O O O O O O O O O O o N �o O 0 N W W 00 r+ C (D rt v LA 0 C (D C Ln Q zT r' 0 (D C C- l< X- 0 h r+ (D N r+ n O (D n r+ O O 0 r+ n, 0 r+ (D 3 O LA r+ (D n n r+ (CD (D 77 Ln L' O r+ (D rr n 0 M r+ m Q C rD r+ 0 r+ m Ln as O (D r+ i 1 0 Number of Tests G N N w O O O O O O O O O O o O o 1 LO /I1 u' 0000 rn NJ /1 N Ln Ln A w cA/�s cP/ Ln LD O 9 O`9/S 9/O _ w C N 9CD /-' 9 ® o 10/ O/IO 11 'I N � 1 10/ OLU �1 00 /`�1 1 0 1/1� � w rn / 17 1/1Q o 0 /NJ 11/ 1s NJ v O N N W -? Lrl Ol �! 00 lD O O O O O O O O O O O o 0 0 0 0 0 0 0 0 0 C New case rate (Rolling 2-week period) Ili 9 0 / 7 0 0 0 0 6 � f � }y \ / \ -0 \ 0 0 ƒ _ 2 0 0 z 3/ g / \ $ Cu D / / / 3 ) / \' D \ \ / ® ° A 0 ] n / » a' n CDn ƒ n ® _ 2 (D / \ \ / / 0 \' s 3 ] m , n g A / \ G / c w a � r+ a, a, O N O v Q Ln c (D n rt rt O n v O 0q (D rn cn Percent Positivity (Rolling 2-week period) N N N O I-, N w P Ul m v 00 CO O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 Ij w iO 0 4 O o o C° o' n � r ^ * �O T 2. ro (D (OD- :3 (D v' O !D N' r+ O O n Q < O v N 3 r+ (DD v rr 0-0 0q < 5 n Ln m v !D r+ n m O n (D O (D D N m -g N D O < m aj g o TI. Z3 h v n r+ � O Ili � Ql 00 O NJOl 00 O O` o PO --h (D 0 no 0 :E > > ZE > fD 0 0 Z3 C: -j 0 -0 --s (D --I rD V) -11 (D 0 (D w 0 =r n �< 0) U) rD m 0- r+- rD cu 0 0 3 3 < rD Q rD 0 CD 0 53 < 0 =3 CD (D CL rD 0- W .,J C < (D r+ (D rD CD 0 LA 0 CD 3 fp n- o l< 3 0 C o =3 UQ r+ ;y Ln (D cr = 0 < 0 c =- rD < < 0 C: rD 0- --1 0 0 (D 3 (n rD (A =3 3 (D 0 rD 0 (A rD rD < rD l< (D C: :y cr rD (D cu < 3 (A rD S --h 0- rD aq < (D _0 CD- rD rD m U) Ln (D (D 0- r"N ME, 0 W w R V CL O O mi Ln O N 0o C m N ID d ~ co L rni O coo m'', D1 N oo m oo o r-I O O I� ti m m co N DO1 m a €€m r`1� N N N h a co ti N 00 C 0 vla o ( r T u o c O0 c f N Dl 0o m r4 a C m ' F- rri �D oo O a N o N N r4 � � C m iD m w +;aost o 3w co N r4Q O^ to O z M 01 lD �. m A: 'C Do d n C m o a p; N M Q rl � aJ O W O 01 Lr) G i r°- O 0 V @ E O> -o C E H 7 @ to u 0 O @ 0.O 11 d 0 C C N �O B O N> m •@. w 4e u to v m ar o �' w y ai �' a'a.@ xi " c _ O O a/ 3 y N v N ai 4 Y 7 C a`O+ m I Y E c v lD @ C v) 3 ao m 3 ..a m o ti u v o o e = Go)v a o a)v o v v s 3 u v m 2, E v Ta o ® c o a m E v v m -o v o u o r E= a+ ° p E ^' a a a v° r v°� C b4 N w i H C C v N v v Y pU c vxL o 3 v c® o v o E o@ c t i >> u M 0 m u m o o v v 3 oco o v i ba rig r N o 'in o 3 w d w '3 ` N m 3 E v c a a> e-i V N ci N v N "C p N C O i n E ov+ O r o Q c 3@ N E -o E @ c c c c w® O "O c v v @ p U V 'N ®1 c bD bo O '^ w O a a i c In O In CL bq 0@ 1 N@ v 'E o v ®j o E® N V Y •� > wC .ba C C E N O c N @ v c .-I R u 23 @ a+ N u@@ c v E { d a, u= b E 3 c F v ° c 00 N M M1 fM1"I M1 _@ : -O CO v -p L U ll i E -o c m '� to -�E mCL to a a "O C t O a1 c u C> N L { @ O O C O ? @bo i >O 4(� E Lba 1 i C •� O d O N 1 ! O `o T3 O S 'm O H C u 3 N O al L @ 3 L m v o v 0 z .c n$ c— F u c m 3 'E a o v o o; o no o�@n > vo v > o u = o a o E 1 @ a/ v j C V pj o o o u n O E O c u aj c u a o p bb @ .. o a,v -Op a@ E +L' N 4C- a a0 'C O C m e N u a-,{ E o 3 ' o m u c =' a :E° a v g 5 o o O c a v1 b@p u c a v w a" @ @ og > v Y v m jn In .0 , a>i a � v -p E N C c a o io c o'I m v E o B v u v Z {ca :p a)pu m h m voi H aaj { bJ O O @ E z H W N = { O : a1 ` @ "- - Ol O p p L p p N u E o @ o E vi u uQ u v o ol c oo Ln N Z N L7 c c a u @ a— E a m j O v v 3 O cu OD r @ o r° o io c a 1 C O > to C O c c v v v l @ _ U C y yvj {Nn, � L ON Oon N O C' 5 m v Z� 'y C _0 v a m 'o u\ g o- o =o > L `c° L- m y L, bco o W. N @ O • u 1 O o/ U aa, y Y CDc a-, Y o. 2 O v @ 'C L Y y= c c bbn @ E E E v ac ° a oao' v EvE : �E"= o°c ai --E@ v v' g a O C C (u N N OU - a. C L O C C j h0 c 'a @ N O m c0 n O : rJ O O m c o !O C v C N 0 u m @ v m p -0 ai 1 E v O O T ib -O c 0 N � E v E O b0 N d v O 'O n'7 Q) N v L L E cl o N {mo > v N {fib O O a-{ O O c r m 3 m o_ -a z v Z- 0 O Ln ti O O C H O O O O O O O ', O M1 O _. i N N O In O S m u O � 1 E :3 n m c v v E b b@D ,u ,> v coO @ O @ c bco {n z v o ai u > o > o,. E v In c E I en Jaj n @ n a (7 S !.0 wl O O 00 . 0 00 0 00 C) O. C w N Ln 00 N Q1' a: rn mm W DL C) 0 C O'.0 C) 0 1+ ON w 16 ci; r1 Q D 0 N v .-i ti v ai N N L 01 x v C: u E � C mI O J tl0 a c o_'', rn x 0 U O C °@ `o 3 0 aco c E v V ar o Y L o c v a)L v N N. v. o-.� roj c, X. v m u .c 7 > > c U `� C bD C L L p 2 O N in Q O `D -O p C C U .° .3 N CD C, L nD U CY C = to N @ �i v=i C 7 C N" N Y X v* N C t O— ° ° > w V a w m O > N u 2, = h O C Y m n -C o > c a@ '3 O CU E v J o c v a v y> c >, c ai >, v, c a u L O O b0 in N O O O 'O m Y m Q O` u O O} N C N N y 'v ai Q ° 'N c .M ao -v° ° c °cD E ° ou E o 2 E; B N � u0 C C� 0� Y= ,D co:, V L a` o a ° ov E p° Y n °_ ¢ ncD � 3 v Q, a o a o° E x E>> o[ 3 3 Y v E o u E E c cc_D v aV a 0p n L p v° ` a m ° E Y o m v 3 > >mc " 3 0 m c o o N (a0 T O C N .> C 000 .0 N Y O Y O 'O N i O o L OJ C a 9 'O C N "O cL N E O 03 OJ ` •� Ll 0 0 N o fo O E ^� Y r' -° 3 v fO c� ` v r`o -° v o m ai ca a N V O o -, l>0 C u m v N> o u 0J Y 0J O- ` 'O N N O ° L 2 3 C -O U 0 w p N 0D .L.. �n "O O U C L O c> c o v v E a_ Y c c v '@ a p o E N I — Q N U .n 41 E O a1 a N E L N N Il ar Lai a E 43 E E a- v F°� `o u_ o° Q ti FS o ° c o v v° v v> u c u m E 3 w n o m 00 m 0 V 0 Ln kR oo n ti 0 C 0 0 C 0 0 u .-i 0 N D Y Y c a @ > �* MD x -00 C IIO a "O U � -p L c m m o o a > ° E v a 'Q In _m H bo 0 a o LQ 0 m > p N 00 00 L T 'O + v a = v o 0 o v -D -' > m --z v� x o -a o 0 o E \ E m Ol ° W N c N m E . o L u N j Q II p 'O l0 O aj G .0 O o E m v `° o 1 O c o = O C) O. v H L Q'Q -O Q C v a N 0 z O N C N 3 L M 0 r `a O>a y co ao -o a � c3 I 3co.> v-0 a c n Yo r c a a v v o 0) -OO 9xJ c e o f0 v v 16 O- 1 p W to Q i u N i C N U L ® O Q u L OJ t 1� CO t/f d OD > N p to c L �. 00 N a C C C a > c m s V" No n 0 o Q a (U a C E N =- Z C O pb N m .0 j O C O. �y : O N > co N a u ra O p N c Q c c u�i � c @ Q -o o 'N M c-,N in U @ LD .0 ✓ a N 4 N fl. N O- ON 0 M, 0 W 3 f0 u0 L o N c w ti n rc a 3 r aci m n oni r 00 cl m O O C O m 0 0 0 O m U N E O "O Y a, 0 A 0 3 O/ m a .. 3 f c� G1 N ON _ C O +L- N 1 ° ,D0 c o a '', o 0 3 toa ;l c Q 0 Y E �u x 0 0 , a O u N O O x 1 Q a > N N = a a O) a w N v T -o .O, a = O C 4! C x p N L+b C M @ (6 a G O. E �' a1 vl © w O O j O .. -o .- w 3 t6 O td N cr7 U N to 00 N O C O Q O N in u L a two = m cD O N o c-i no .-Na no c trait c a E 4^ f o d o O Oo E y c a -a)3 v7, t oco a u > a v o o® vi m O v— a N Q 6 C o N O O p s �O m ra�O E T',8� you o N c Q a c) ob = r0 N O c. aL.+ ® 47 0 OJ a o N p N N Sao io m m o> "o o oTo °° o ac <r o a °^ Q sn ti ti In n m of N N a-i In N I W Ln 0 0 n o O o O 0 C o 0 O C 0 O Ob O C N a m a)e v N _ 'now o N m > v ao m o � 0 a m c=o � a O o O c c +T+ aCo - O C o'� � o-EJ N N C +�,, C O A y L.., o vs O V O C V j 0 o 3 v o w c a u o m v E o 0 = u �2 2 U � O C 0 cL m@ Q o w> u a C N N O T l 'E -c is ar v O Y N 3 L T U a C C { O C L @ aJ O N N > E U ti 0u o O 0 o ti 0 C 0 O _ C J ..00 u1 U 0 m N Nj C C U C N i t? 'CW E Q m a > > 3 ao x c a ° L a O _ N Q7 tlC0 c > 3 3� � v o C 0 U LL O D Y C U Y O1 O .0 a 0 3 v C m NO b= O cC0 N N 3 a o� 7 a-)tl0 C L U O :. L O V Y 0 a O p N +L.., m N C 0 m Q C i s a� 3 0 y ) v mo. (u c a i � @ c is -C o '� a' n. t 01 .� y `$ '3 0 Q Q 4 O f0 px7 W O 8 -Cl O O .E O O CO UJ U i o o m O E i o a a o W a 0 o I u Q Q u� Q to 0 U O N v N �-1 N 9 a/ V1 t O a w cc NA i O MO o O a � C C LL O a U y N � Gl �^ 4+ 2 O 'a u to 'n O 0 u° 0 0 OCD , N ` C — Y T a) L O al _� O a O Y @ O _ N j 7 O l y C @ 3 0 ` v1 U @ Q i f6 J N LT O 9 a) C �'', u O 7 lfl C -O O L =- c C E a s N U O Oo ti Y tO u U CD (6 OD r "C m O U 0 m W vYi U N u L O C OD .2 '00 t lJ C V C U in a a) a-1 O @ C Y @ to , N U of 'L C N 'O @ N 'O L L N m E u O N to u a Y vi C C C �.' V O N cm N O w OD � -c 7 •E •Q c -0 c Ln v a@i 3 'a' tl0 u p a v tw C 7 N o Y N E L > v Y C u p O _ O lO u a1 D M W 0 Y C ^ 3 a Y Y u} 0 o`n u' E L= CO v v Y O n Q o .0 u ! a > o+ c •� u p a a a = a a c L C L E vmi. Q o N OD u c 3 3 E c v o a m .3 ^ v = o c o On fO „- Ln _ u o au, v X E o N a c �n a, a, Lip Oco On '^ s ai co aui O`D o o m :0 `° o` a: >; -0 a' u in c CO 0 m^ 3 o E m u @ o% o o a = m m o c 'm a h$ a .� =O = bD 'C b00 C m N O C O C '� vYNi N 2 o "O Q u m bC9 O V 3 .Q _ C ` N -C N �LF, O Q '� j v c 'v _ u - c E n 0 N o- y a N O a N s@+ m v� C bD O r l O O- -'^ c E a Y c\ C a Q `- a L C c w N C ''. v bD Q N Q1 d O C r0 !l. 41 u C N cD C E c m r° o.3 C) 0) 'EOa 0 C,L c m n d cc o awn m e =o u a+ C U— N! OD C— Oq N ut a) O v a ra a O O yuj W N vi LO Q al O U N vi eryi 0 'c N h L +; C N aJ @ O _ N a0+ X N •O+ '� 00 v w a`O-+ a v ` v E w c U N m a n> c v u v w u c a v c v U Q �^ c c v 3 o Y u m a o CO a o 0 c o a y do . a N u m m o a N O aEj Y OD ra .0 3 C �''. 1p Y `1 O u-C j- OD o a= U m v�f Q N U N r0 f0 U w C p_ y� Ou O al U, N N bD Q aJ Q a a v o U L >` m y 'v = o Q -i Cb o s ai c W C c v c c ro N o u? a 3 0 3 .-+ Q o 3 v} r u o O v W Of o m o`D N O ' d U O O C O 0 O 0 00 W N O O O Ln U m O O O O ID O O O O Ln LD O N O N �o' M M'n N al M r, ' rn M N W M' Ln n 7' m m m E o � m a •a m M �IU m W' C a N c c o o m m c E UIU O Ln N N rl > a1 O LF, aJ � L aJ C o a c a 3: v o YC ° o o E u a u � Y o c o_ O ON O a m N Ol 3 O bU N NC a a v m a a ' a N -O = C o O - N C) O S m 3 -00 w _T O a) O ( a a = C m p C N -0 a i w '0 C C C 9 > O Ow -00 � t3 C aC a a > w a ro a 3 C L f c c c w l Ow ro a w C J N ` > _ p - O u I aj _ w ( v 'ro > a i 3 L o 0 4 > L w -0 T ro _ Q 3 v w � c v c o N -0 — a m c Y E J " a; E 7 E r m Ou W 0 n N C) ti O C 0 N Q1 m 0 U w v '.. (U O v -o ''.. U N N C a i C 3 O ro a U'roEo d -O 3 00 Y d o fO _ U c >. U N wa O a C N a) o- N ro aj— n ro E op h � 3lu N = m? 3 •o c v c (u g _ Lo _ — — t a s 3 c 3 w pa a. w m 0 -O O O O X C 3 o oo C J ;O N E Ow m prop L ai O !� Y 2 v a w E~> N c@ o �' O a v iL-+ C C Oo. m N C v Q Z Y ro c v ac a 3 p —> c c a) = o'p o 0 m ro a7 'O O 'O m O u m' T o o J o f aco 3 g_ L 3 x c c a E c -o N L O Z In O N O aJ U O O O Y O- — w U '� E vpi u 3 om, v O= +- v c v ipco vv o 'ulu v ro a -ow-wo Q E n E U N O Q) v L O O C w L LLO (YO LL LL 3 2 c L E— N al H al C\ a) _> O —o3 o o o w o p o c a N 3' 00 Il Q. "u0 O : m •= Ql too =' d bp0 ` o N N = _ a,, c-1 C v U L 'D E a) "O tp or O O O -C N c-I C C u U '.. ci ro ti 'm (Cp Ou O (m 'a t O 00 cl a0 Ili O O o O o o ao o m o (n c c y E C m a c tr, '.. al o U O c V p z m aJ c ro ro U NU =o c ®I tw n E! v,!0 p d O'. al a o C b Y C v v bc0 x 0 v 0. v U -p X - alai ou @ p v L E O D 3 m O u O- T �- O v �6 -� Q .CO 'O N N O N p 0 0 Y 3 c Y N o m N uvi >, OJ Y N co,' O m N .O o o +^ o � .« c o o cy .0 L v b0 N N v 0 N 3 a o a .3: m o c 3 a E o O o 4:v "O v v O 2 C O G aL+ U u_ U o 9 0 o L o o. 0 0— u v u E p N p '� fO o m v v -Q --I .c v" d v — O c 'C � m N Ln c v U v C E> N Oc O ,Op o N L H V - b0 C cb ¢ c� u E v v v 'v ',c,: 6 O D L O O }j 3L., t u t o v v E Y o o o b o Y a ° o v n 'O fb O v c v a, o C� O ._ c b0 v a Y a E m o m.0 0 C 0 0 0 C 0 O N O O C 0 N W C O C_ c O o O O fb M R D O O O O 0 N v N N O C 0 Ln N 0 7 cab O o - U1 o u v m E Y N O U O C L ih O ". .> E Y o a o, v N .O d C a N a o-� o mr o 0 r o 3 T Y v 7 @ H t v 3 "O 11 p L m ,n O' T Q� U E ;° tl0 by Y yJ -o '� 'O O C r�o N m E v v o :� 3 s ° c11, S O a c o N M>° E v 3 v o„ bcD o �!, 72 LL v o �' O v, V M '" N N bD N N oun > Q fb v c a a)vi O a LL 1 E bD -o a): w 7 O v . = E O i 'T � O o_ !^ o. "�O > o v O fb Y b0 Q C o0 . � v O o m O v U C y O O. y C vvi 7 U L O w O N 3 L O w '� v O C U Y N C N o m N m O Of m d v `o 3 bn ¢ .p ,��, __ 4J v y N O ° ¢ p ° `o c � @ o a -o � 'o c c a w C (b N "O m v'.'. � ra v N Q '^ _ c0 v .� O U co v 4,1 O ` O` T •O V U o c-I L w v U 0 N i O U v O. u U "@6 d Y C c o U � Y NO 'O % O 'O Q tua c a w m o U N 0 t7 R L ¢ C N O j O N v N O 0 0 aT+ m N K -O v in U@ T tp N Cl U _C N o +T+ c N �' cm E H N Z —�- '` a= U ci = 3 ,�_ Y � C OJ L )p a (O > 1 `� C U N v N 7 T ., v v C-0 m N N bbn E L M N N C U @ O = T C E o Ni c N N E v N-0 v v u> v E a r T s a m°-� 3 r o j ` -0 CL rb v c@ O O v v 3 0 o z E v ,c E fl. v v E L O v o 7 O. ¢ -a _ o o m r u - 3^ m o M d b0 ko N c-I Icl M O o Q P P O C C H n V 0 r, W O1 c-I a C v E O. O N a, 0 .0 7 E c E O V ti � c c v a E Z' ai a > 0 c m O a O v u = u Y V fb ° x 3 a 3m a w -o E m v c° c n E a _ y CC m Z w E no O O O N E C N N N y N N 6 -° c O C O a " �Ul ES C0 NiC -[ Ct iV MU ITY EVELOPMEiN ►rk9, 4kyjIeI[7_\ ki IIII II If,I TO: Deschutes County Board of Commissioners Greg Munn, Chief Financial Officer FROM: Nick Lelack, AICP, Director Sherri Pinner, Sr. Management Analyst DATE: November 17, 2020 SUBJECT: CARES Act Reimbursement Request - Laptop Purchase 1. SUMMARY The purpose of this memorandum is to request reimbursement through CARES Act funding for laptops purchased for CDD staff to ensure continued operations in safe remote work spaces during the pandemic. It is understood the current CARES Act available funding is best allocated to community partners and County reimbursements. However, there is the possibility allocations will not be fully PxnanriPri by vPar Pnri anri arlrlitinnal PxnPnrliturPs may hP auu uthori�Pd to snnort essential County-1 ..-1-..--- -1 J-.... -..-, .....- --- - - . - ---r-..-..--.. -- ...-'I ---.-.-..-..------- rI- -' ---------- - - ---J services. Through the CARES Act, CDD has been reimbursed $23,416 with an additional $136 pending approval through the 6th reimbursement submission. Items purchased with these funds include sanitizer, face masks, sanitizing wipes, gloves, headsets and other minor items needed to safety operate during the pandemic. At the onset of the pandemic, many CDD staff were not equipped with portable tablets or laptops that had Virtual Private Network (VPN) capabilities. VPN connections are encrypted connections that allow staff to connect to network servers to securely access files and perform job duties from remote locations. In an effort to provide staff working remotely with VPN equipped laptops and to prepare for future emergencies requiring remote work, CDD purchased 39 Dell laptops for a total cost of $80,777. CDD is requesting consideration for all or a portion of the cost of laptops to be reimbursed through the CARES Act, providing funds are available at year end. 11. PROPOSAL CDD recommends: In the event there is CARES Act funding available at year end, include all ($80,777) or a portion of the cost of 39 laptops to the final CARES Act reimbursement submission. AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Wednesday Meeting of November 25, 2020 DATE: November 18, 2020 FROM: Greg Munn, Finance, 541-388-6559 TITLE OF AGENDA ITEM: Treasurer and Finance Report for October 31, 2020 DATE: November 18, 2020 TO: Board of County Commissioners FROM: Greg Munn, Treasurer and Chief Financial Officer SUBJECT: Treasury and Finance Report — October 2020 Following is the unaudited monthly finance report for fiscal year to date October 31, 2020. Treasury and Investments • The portfolio balance at the end of October was $229M, an increase of $44 million from last month and an increase of $3 million from last year. • Net investment income for the month is $187,165, approximately $9,000 less than last month. Net earnings are approximately $150,000 less than October 2019. YTD earnings are 2/3rds of 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 was reduced to 0.75% on October 21. • Average portfolio yield is 1.19% down from 1.52% last month. • The portfolio's weighted average time to maturity is at 1.15 years (vs 1.21 last month) as we are buying more .ub..,.,..,�..........:., +t.,. a n . +,,.IL investments witil maturities lUCJ in he J-A year maturity range. Portfolio Breakdown: Par Value by Investment Type Municipal Debt $ 21,655,000 9.4% Corporate Notes 34,900,000 15.2% Time Certificates - 0.0 % U. S. Treasuries 10,000,000 4.4% Federal Agencies 67,385,000 29.4% LGIP 60,498,007 26.4 % First Interstate Bank 34,732,739 15.2% Total investments $ 229,170,746 100.0% Total Portfolio: By Investment First Interstate Bank Municipal Debt 9.4 % 15.2 / _ Corporate Notes 15.2% Time LGIP 26.4%1 Certificates 0.0% U. S. Treasuries Agencies 29A% Investment Income Oct-20 Y-T-D Total Investment Income 192,165 959,717 Less Fee: $5,000 per month (5,000) 20,000 Investment Income - Net 187,165 939,717 Prior Year Comparison Oct-19 329,829 1,414,896 Category Maximums: Yield Percentages U.S. Treasuries 100% Current Month Prior Month LGIP ($51,177,000) 100% FIB/ LGIP 0.75% 1.00% Federal Agencies 100% Investments 1.79% 1.92% Banker's Acceptances 25% Average 1.19% 1.52% Time Certificates 50% Municipal Debt 25% T Benchmarks Corporate Debt 25% 24 Month Treas. 0.17% LGIP Rate 0.75% Weighted Ave Maturity 36 Month Treasury0.21% Max 3.54 Years 1.15 Term Minimum Actual 0 to 30 Days 10% 44.1% Under 1 Year 25% 65.5% Under 5 Years 100% 100.0% Other Policy Actual Corp Issuer 5% 2.9% Callable 25% 15.7% Credit W/A AA2 AA1 Investment Activity Purchases in Month $ 13,625,000 Sales/Redemptions in Month $ 19,415,000 4.50% 4.00 % 3.50% 3.00 % 2.50% 2.00% 1.50% 1.00% 0.50% 0.00% 24 Month Historic Investment Returns Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr MayJune July Aug Sept Oct —County Rate 2 year Treasury Rate - Corporate Bond Rate— LGIP Rate 300,000,000 250,000,000 200,000,000 150,000,000 100,000,000 50,000,000 y1\ y00 yrb y00 y00 yW y`b yo y� y0 ti� ti� ti� T IZ,'T LO \I�Q,tiO Five Year Maturity Ladder 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 L L As of 09.30.20 wAsoflO.31.20 Deschutes County Investments Purchases made in October2019 Portfolio Management Purchases made in October 2020 Portfolio Details - Investments October 31, 2020 Purchase Maturity Days To Ratings Coupon Par Market Book Inv p. Inv Ty ' CUSIP Security Broke Date Date :• I Maturi ' Noon; ' &P/F • Rah , YTM 3' - Value ''. Value Value 10548 MUN 492244DV7 Kern Community College CASTLE 11/15/2016 11/1/2020 0 AA- 2.893 1.8001 500,000 500,000 500,000 10689 MUN 544587C30 LOS ANGELES MUNI IMP CASTLE 2/11/2019 11/1/2020 0 AA- 3.146 2.8723 2,310,000 2,310,000 2,310,000 10617 FAC 3134GBX56 Federal Home Loan Mtg Corp CASTLE 12/13/2017 11/24/2020 23 Aaa AA+ 2.25 2.1723 3,000,000 3,003,905 3,000,000 10719 MCI "0605IGEE5 Bank of America Corp CASTLE 210/22/2019,`- 1/5/2021 65'A2 A- 5.875 ' 1.8832 -2,000,000 32,019,261 2,013,959' 10758 MCI 89233P4S2 Toyota Mtr Cred - Carp N Pi 3/25/2020 1/11/2021 71 Al A+ 4.25 2.7960 2,000,000 2,015,181 2,005,536 10745 MCI 94988J5M5 Wells Fargo Corporate Note CASTLE 1/9/2020 1/15/2021 75 Aa2 A+ 0.5469 1.2210 3,000,000 3,001,668 3,001,512 10725 MUN 73209MAC1 POMONA CALIF REDEV AGY Pi 11/22/2019 2/1/2021 92 A+ 3.406 1.8002 1,300,000 1,308,528 1,305,135 10735 MCI 90331HPA5 US Bancorp Pi 12/6/2019 2/4/2021 95 Al AA- 3 1.8505 2,000,000 2.009,534 2,005,843 10722 FAC 880591EL2 Tennessee Valley Authority CASTLE 11/5/2019 2/15/2021 106 Aaa AA- 3.875 1.6499 2,000,000 2,020,949 2,012,661 10739 TRC 912833LC2 U.S. Treasury CASTLE 12/11/2019 2/15/2021 106 Aaa AA+ 0 1.7239 3,000,000 2.998,938 2,985,447 10740 TRC 912833LC2 U.S. Treasury CASTLE 12/13/2019 2/15/2021 106 Aaa AA- 0 1.7240 2,000,000 1,999,292 1,990,297 10687 VR2 89236TEV3 Toyota Mtr Cred- Corp N CASTLE 1/9/2019 4/13/2021 163 Al A+ 0.5041 2.2175 2,000,000 2.002,292 1,997,565 10702 VR2 06051GFV6 Bank of America Corp CASTLE 5/31/2019 4/19/2021 169 A2 A- 1.6378 3.1702 1,050,000 1,056,565 1,055,390 10706 MUN 801577NR4 SANTA CLARA CNTY CALIF FING .CASTLE 7/2/2019 5/1/2021 181 AA+ 2.05 2.2634 1,095,000 1,102,961 1,094,910 10700 MCI 06051GEH8 Bank of America Corp CASTLE 5/9/2019 5/13/2021 193 A2 A- 5 2.7003 1,560,000 1,598,584 1,578,501 10757 MCI 09247XAFK Federal Home Loan Mtg Corp CASTLE 3/25/2020 5/24/2021 204 Aa3 AA- 4.25 2.6577 2,000,000 2,043,386 2,017,538 10741 TRC 9128286V7 U.S. Treasury CASTLE 12/13/2019 5/31/2021 211 Aaa 2.125 1.7017 5,000,000 5.057,420 5,012,017 10667 MCI 695114CM8 Pacific Corp CASTLE 11/29/2018 6/15/2021 226 Al A+ 3.85 3.3502 1,170,000 1,185,348 1,173,456 10672 MCI 695114CM8 Pacific Corp CASTLE 12/6/2018 6/15/2021 226 Al A+ 3.85 3.3509 830,000 840,888 832,450 10692 MCI 695114CM8 Pacific Corp CASTLE 2/22/2019 6/15/2021 226 Al A+ 3.85 2.8503 2,000,000 2,026,235 2,010,703 10708 FAC 3133EKVC7 Federal Farm Credit Bank CASTLE 7/29/2019 7/19/2021 260 Aaa AA+ 1.875 1.8749 3,000,000 3,037,460 3,000,000 10721 TRC 9128287F1 U.S. Treasury CASTLE 10/31/2019 7/31/2021 272 Aaa 1.75 '1.6313 5,000,000 5,060,155 '5,004,323 10705 MUN 797398DK7 SAN DIEGO CNTY CALIF PENSIOI CASTLE 7/1/2019 8/15/2021 287 Aa2 AAA 5.835 2.0005 2,000,000 2,085,600 2,058,926 10696 AFD 88059E4M3 Tennessee Valley Authority CASTLE 4/18/2019 9/15/2021 318 Aaa AA+ 2.3733 2.5355 1,020,000 1,017,110 998,616 10648 MCI 45905LJC36 International Bonds for Recons CASTLE 7/16/2018 9/28/2021 331 Aaa AAA 2 2.9669 2,000,000 2,000,000 1,983,366 10731 MCI 94988J5T0 Wells Fargo Corporate Note CASTLE 12/5/2019 10/22/2021 355 Aa2 A+ 3.625 1.9498 2,000,000 2,058,688 2,031,906 10724 FAC 3130AFUYO Federal Home Loan Bank CASTLE 11/8/2019 11/19/2021 383 Aaa AA+ 1.625 1.7109 3,000,000 3,047,019 2,997,347 10744 FAC 3130AHSR5 Federal Home Loan Bank CASTLE 12/20/2019 12/20/2021 414 Aaa AA+ 1.625 1.6801 3,000,000 3,050,713 2,998,160 10732 MCI 46625FUD3 JPMorgan Chase- Corporate N PJ 12/6/2019 1/24/2022 449 A2 A- 4.5 2.0101 2,000,000 2,102,715 2,059,667 10654 MCI 695114CP1 Pacific Corp CASTLE 9/25/2018 2/1/2022 457 Al A+ 2.95 3.3202 700,000 717,794 696,952 10726 FAC 3133EKCYO Federal Farm Credit Bank CASTLE 11/21/2019 3/14/2022 498 Aaa AA+ 1.95 1.8490 5,000,000 5,019,016 5,005,515 10730 FAC 3133EKCYO Federal Farm Credit Bank CASTLE 11/29/2019 3/14/2022 498 Aaa AA+ 1.95 1.8383 5,000,000 5,019,016 5,006,106 10720 MCI 90520EAFK MUFG Union Bank " CASTLE ' 10/25/2019 -4/1/2022 516 A3 A 3.15 2.0375 ' 2,000,000 2,072,595 2,030,588 10750 MCI 90520EAFK MUFG Union Bank CASTLE 2/5/2020 4/1/2022 516 A3 A 3.15 1.8114 1,000,000 1,036,297 1,018,505 10759 MCI 037833CP3 Apple Inc CASTLE 3/27/2020 5/11/2022 556 Aal AA+ 0.6025 1.7772 1,000,000 1,004,882 984,076 10733 MCI 084664BT7 Berkshire Hathaway Inc MORETN 12/6/2019 5/15/2022 560 Aa2 AA 3 1.7400 2,000,000 2,085,812 2,037,799 1na52 MiN 6R6n53BnI Oregon School boards Assoc MORETN 9/14/2018 6/30/2022 606 Aa2 AA 5.48 3.1200 925,000 999,731 958,983 10748 FAC 3133EKJ56 Federal Farm Credit Bank CASTLE 1/31/2020 8/30/2022 667 Aaa AA+ 0.4 0,3731 3,000,000 3,011,115 3,009,218 10727 MCI 06051GEU9 Bank of America Corp CASTLE 11/25/2019 1/11/2023 801 A2 A- 3.3 2.1201 2,000,000 2,120,347 2,049,828 10760 MUN 736746XU7 PORTLAND OR URBAN RENEWAL PS 7/14/2020 6/15/2023 956 Aal 4.023 2.8950 1,000,000 1,021,390 1,028,140 10709 MUN 29270CNU5 Bonneville Power Administratio CASTLE 7/30/2019 7/1/2023 972 Aa2 AA- 5.803 2.1249 1,000,000 1,138,140 1,093,619 10713 MCI 361582AD1 Berkshire Hathaway Inc CASTLE 9/9/2019 7/15/2023 986 Aa3 AA 7.35 2.0306 500,000 588,955 568,869 10769 FAC 3137EAEV7 Federal Home Loan Mtg Corp CASTLE 8/21/2020 8/24/2023 1026 Aaa AA+ 0.25 0.2841 5,000,000 4,999,473 4,995,230 10768 MUN 67232TBM6 OAKLAND CA REDEV SUCCESSOIPS 8/21/2020 9/1/2023 1034 AA- 3.125 0.6015 2,500,000 2,662,550 2,676,862 10780 MUN 476453GRO JEROME IDAHO SCHOOL DISTRIPS 10/13/2020 9/15/2023 1048 Aaa 5 0.4794 200,000 225,416 225,758 10761 FAC 3134GV6P8 Federal Home Loan Mtg Corp CASTLE 7/30/2020 4/15/2024 1261 Aaa 0.5 0.5000 2,465,000 2,452,929 2,465,000 10776 MUN 56857ICZ4 SILVER FALLS SO PS 9/17/2020 6/15/2024 1322 Aal 0.55 0.5500 1,900,000 1,894,623 1,900,000 10777 MUN 179093KQ1 CLACKAMAS SCHOOL DISTRICT PS 10/1/2020 6/15/2024 1322 Aal 0.613 0.6130 500,000 498,820 500,000 10779 MUN 906429EE1 UNION CTY OR SCHOOL DISTRICPS 10/8/2020 6/15/2024 1322 Aal 0.675 0.6750 490,000 490,103 490,000 10785 MUN 939307KV5 Washington County SO Municipal PS 10/28/2020 6/15/2024 1322 Aal 0.59 0.5841 1,500,000 1,497,900 1,500,000 10771 MCI 68583RCT7 OR ST COMMUNITY COLLEGE DI R W B 8/27/2020 6/30/2024 1337 Aal AA+ 5.66 0.6000 90.000 105,444 106,469 10782 MUN 584288ER1 MEDFORD OR REVENUE R W B 10/14/2020 7/15/2024 1352 AA- 2 0.6504 815,000 853,150 855,205 10784 MUN 732098PE2 POMONA CALI UNI SCH DIST TAXPS 10/20/2020 8/1/2024 1369 Aa3 -0.77 0.6002 1,200,000 1,204,464 1,207,547 10786 MUN 835569GR9 SONOMA CCD PS 10/21/2020 8/l/2024 1369 Aa2 AA 2.061 0.6002 1,200,000 1,249,404 1,264,895 10775 FAC 3134GWF84 Federal Home Loan Mtg Corp CASTLE 9/9/2020 9/9/2024 1408 Aaa 0.48 0.4800 1,000,000 993,512 1,000,000 10778 MUN 4511527CO IDAHO ST BOND BANK AUTH REVPS 10/8/2020 9/15/2024 1414 Aal 5 0.6103 1,000,000 1,165,410 1,167,703 10781 MUN 476453GS8 JEROME IDAHO SCHOOL DISTRIPS 10/13/2020 9/15/2024 1414 Aaa 5 0.7253 220,000 255,750 255,839 10783 FAC 3133EMCM Federal Farm Credit Bank CASTLE 10/16/2020 10/15/2024 1444 Aaa AA+ 0.4 0.4402 2,000,000 1,995,824 1,996,853 10791 FAC 3134GW3W4 Federal Home Loan Mtg Corp CASTLE 10/30/2020 10/28/2024 1457 Aaa 0.41 0.4163 2,000,000 1,997,421 1,999,500 10762 FAC 3136G4E74 Federal National Mtg Assn CASTLE 7/31/2020 1/29/2025 1550 Aaa AA+ 0.57 0.5700 1,400,000 1,391,262 1,400,000 10792 FAC 3134GW5Q5 Federal Home Loan Mtg Corp CASTLE 10/30/2020 1/29/2025 1550 Aaa 0.45 0.4524 2,500,000 2,495,909 2,499,750 10763 FAC 3133EL3P7 Federal Farm Credit Bank R W B 8/12/2020 8/12/2025 1745 Aaa AA+ 0.53 0.5300 3,000,000 2,984,407 3,000,000 10764 FAC 3133EL3H5 Federal Farm Credit Bank MORETN 8/12/2020 8/12/2025 1745 Aaa AA+ 0.57 0.5700 3,000,000 2,984,292 3,000,000 10766 FAC 3134GWND4 Federal Home Loan Mtg Corp CASTLE 8/14/2020 8/12/2025 1745 Aaa 0.6 0.6102 2,000,000 1,986,844 1,999,043 10767 FAC 3136G41-84 Federal National Mtg Assn CASTLE 8/18/2020 8/18/2025 1751 Aaa AA+ 0.57 0.5901 2,000,000 1,989,170 1,998,100 10765 FAC 3136G4N74 Federal National Mtg Assn MORETN 8/21/2020 8/21/2025 1754 Aaa AA+ 0.56 0.5600 3,000,000 2,980,483 3,000,000 10772 FAC 3136G4N74 Federal National Mtg Assn R W B 8/27/2020 8/21/2025 1754 Aaa AA+ 0.56 0.5651 1,000,000 993,494 999,759 10774 FAC 3136G4N74 Federal National Mtg Assn R W B 9/3/2020 8/21/2025 1754 Aaa AA+ 0.56 0.5600 2,000,000 1,986,989 2,000,000 10770 FAC 3136G4X24 Federal National Mtg Assn PS 8/28/2020 8/29/2025 1762 Aaa AA+ 0.6 0.6000 1,000,000 994,824 1,000,000 10773 FAC 3136G4X24 Federal National Mtg Assn CASTLE 8/28/2020 8/29/2025 1762 Aaa AA+ 0.6 0.6000 1,000,000 994,824 1,000,000 10078 RRP SYS10078 Local Govt Investment Pool 7/1/2006 - - 1 0.75 0.7500 60,498,007 60,498,007 60,498,007 10084 RR2 SYS10084 First interstate 7/1/2006 - - 1 0.75 0.7500 34,732,739 34,732,739 34,732,739 229,170,746 230,950,923 230,257,689 Budget to Actuals Report General Fund: Revenue YTD in the General Fund is $9.5 million or 25.5% of budget, an increase of $5.5 million from last year which was at 11% of budget for the same time period. This increase in YTD revenue this year is due to early property tax collections and CARES Act reimbursements. Expenses YTD are $14.4 million and 36.2% of budget compared to $11.1 million and 30% of budget last year. The increase this year is due to CARES Act expenditures. <t, County Wide Financial Dashboard F d ; Budget to Actuals t t M ,. Rebuiren _nts - R,S,,.Ir: kcg ning WofkinciCapGs rk )ZO - C,d, 4L3te_ is $14.4M $9.5M 36.2%� 25.5% Monthly Gt P... 0 4 $9.7M (Blank) All Major Funds: 7 of last vear budoet 001 - General Fund 33.3% 4 Year Complete Budq�;UF toil by t�goi; 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 October 31, 2020. Position Control Summary July - June Percent Org Jul Aug Sep Oct Unfilled Assessor Filled 33.26 33.26 33.26 33.26 Unfilled 2.00 2.00 2.00 2.00 5.67% Clerk Filled 8.48 8.48 8.48 8.48 Unfilled 1.00 1.00 1.00 1.00 10.55% BOPTA Filled 0.52 0.52 0.52 0.52 Unfilled - - - - 0.00% DA Filled 53.10 53.80 52.80 51.80 Unfilled 1.00 0.40 1.40 2.40 2.40% Tax Filled 5.50 5.50 5.50 5.50 Unfilled - - - - 0.00% Veterans' Filled 4.00 4.00 4.00 4.00 Unfilled - - - - 0,00% Property Mngt Filled 2.00 2.00 2.00 2.00 Unfilled 0.00% Total General Fund Filled 106.86 107.56 106.56 105.56 Unfilled 4.00 3.40 4.40 5.40 3.889/. Justice Court Filled 4.60 4.60 4.60 4.60 Unfilled - 0.009/. Community Justice Filled 46.90 46.90 45.90 45.90 Unfilled 1.00 1.00 2.00 2.00 3.13% Sheriff Filled 224.75 234.75 237.75 236.75 Unfilled 22.75 15.25 12.25 14.25 6.46% Health Srvcs Filled 304.55 312.25 319.78 323.98 Unfilled 38.25 31.55 24.02 17.82 8.14% CDD Filled 54.00 53.00 54.00 54.00 Unfilled 2.00 3.00 2.00 4.00 4.87% Road Filled 53.00 53.00 53.00 53.00 Unfilled 4.00 3.00 3.00 3.00 5.78% Adult P&P Filled 39.60 39.60 38.60 38.60 Unfilled 2.25 1.25 2.25 2.25 4.87% Solid Waste Filled 22.00 23.00 23.00 23.00 Unfilled 2.00 - - - 2.15% 9-1-1 Filled 54.00 54.00 56.00 57.00 Unfilled 6.00 5.00 3.00 2.00 6.75% Victims Assistance Filled 8.00 8.00 8.00 8.00 Unfilled - - - - 0.00% GIS Dedicated Filled 2.30 2.30 2.30 2.30 Unfilled - - - - 0.00% Fair & Expo Filled 10.91 10.91 10.91 10.91 Unfilled 0.09 0.09 0.09 0.09 0.829/o Natural Resource Filled 2.00 2.00 2.00 2.00 Unfilled - - - - 0.00% ISF - Facilities Filled 19.60 19.60 20.60 21.60 Unfilled 3.40 2.40 1.40 0.40 8.549/. ISF -Admin Filled 7.75 7.75 7.75 7.75 Unfilled - - - - 0.00% ISF -BO00 Filled 3.00 3.00 3.00 3.00 Unfilled - - - - 0.00% ISF- Finance Filled 8.00 8.00 9.00 9.00 Unfilled 1.00 1.00 - - 5.56% ISF - Legal Filled 7.00 7.00 7.00 7.00 Unfilled - - - 0.001% ISF - HR Filled 8.00 8.00 8.00 8.00 Unfilled - - - - 0.00•/ ISF - IT Filled 15.70 15.70 15.70 15.70 Unfilled - - - - 0.00% ISF - Risk Filled 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 Unfilled 86.74 66.94 54.41 51.21 %Unfilled 7.95% 6.141% 4.99% 4.69% 5.94% �ses� Budget to Actuals - Countywide Summary All Departments 33.3% FY21 YTD October 31, 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 9,460,908 25% ; 38,795,972 104% ; 030 - Juvenile 856,930 826,150 96% ; 975,090 147,434 15% ; 976,758 100% ; 160/170 - TRT 7,732,000 7,616,246 99% ; 6,916,358 5,385,982 78% 8,378,200 121% ; 220 - Justice Court 578,000 561,613 97% 489,850 154,169 31% 489,587 100% ; 255 - Sheriff's Office 41,581,807 43,677,825 105% ; 43,449,298 7,444,847 17% ; 43,590,243 100% ; 274 - Health Services ; 36,132,298 32,892,266 91% 39,452,296 15,165,960 38% ; ; 44,296,381 112% ; 295 - CDD 8,468,820 8,043,542 95% 8,251,726 2,808,131 34% ; 8,289,626 100%: 325 - Road 22,785,827 22,495,570 99% ; 20,681,110 8,220,819 40% 21,214,687 103% ; 355 - Adult P&P 55775,278 6,570,946 114% ; 5,995,287 3,232,176 54% 5,999,756 100% ; 465 - Road CIP 2,142,893 2,145,706 100%: 2,467,800 132,516 5% ; 2,655,600 108% ; 610 - Solid Waste 11,724,869 12,300,751 105% ; 12,077,592 4,536,574 38% ; 12,122,492 100% ; 615 - Fair & Expo 1,561,500 990,522 63% 1,466,050 417,996 29% 1,196,550 82% ; 616 - Annual County Fair 1,649,700 1,469,198 89% 52,000 52,145 100% ; 52,017 100% 617 - Fair & Expo Capital 16,000 21,189 132% ; 14,000 3,992 29% ; 12,000 86% ; Reserve 618 - RV Park 437,700 445,454 102% ; 436,050 238,711 55% ; 391,335 90% ; 619 - RV Park Reserve 12,550 3,801 30% 1,100 3,200 291% ; 9,600 873% ; 670 - Risk Management 3,495,039 3,930,523 112% ; 3,263,646 1,246,386 38% 3,325,941 102%: 675 - Health Benefits 22,318,433 22,490,985 101% ; 21,884,538 7,179,947 33% ; 21,998,864 101% ; 705 - 911 10,563,350 11,280,682 107% ; 11,064,698 1,504,515 14% ; 11,340,953 102% ; 999 - Other 29,544,540 37,220,505 126% 34,108,295 10,669,908 31% ; 34,165,136 100% ; TOTAL RESOURCES 243,175,367 252,498,065 104% ; 250,248,309 78,006,317 31% ; 259,301,697 104% ; 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 7,782,979 40% ; 20,792,848 108% ; 030 - Juvenile 7,127,337 6,927,385 97% ; 7,390,349 2,318,703 31% 7,185,120 97% ; 160/170 - TRT 2,274,140 2,260,020 99% 2,419,872 1,535,180 63% ; 2,787,697 115% ; 220 - Justice Court 678,141 667,997 99% 683,508 219,870 32% 688,374 101% ; 255 - Sheriffs Office 44,685,809 44,783,763 100% ; 49,022,494 16,089,124 33% 48,157,905 98% ; 274 - Health Services 47,589,309 42,265,238 89% ; 49,899,947 14,634,149 29% ; 50,799,527 102% ; 295 - CDD 7,905,639 7,462,091 94% 8,474,142 2,612,654 31% 8,363,009 99% ; �TEs` Budget to Actuals Countywide Summary All Departments FY21 YTD October 31, 2020 (unaudited) 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 REQUIREMENTS 33.3% Year Complete 14,573,336 13,094,764 90% ; 14,513,205 4,265,593 29% 14,194,768 98% ; 6,669,491 6,428,151 96% ; 7,081,268 2,033,295 29% 6,913,336 98% ; 13,835,913 5,824,653 42% 20,036,050 1,580,762 8% ; 20,011,277 100%: 8,384,039 7,518,563 90% 8,853,213 2,021,759 23% 8,825,309 100%: 2,464,787 2,372,624 96% 2,070,371 599,404 29% 1,969,642 95% ; 1,504,700 1,615,288 107% ; 127,000 71,012 56% 177,600 140% ; 1,362,775 424,931 31% 401,940 87,621 22% ; 401,940 100% ; 540,373 503,509 93% ; 543,902 99,445 18% 520,128 96% ; 100,000 8,335 8% 100,000 - 0% 100,000 100% ; 4,132,295 2,440,263 59% 3,794,344 991,056 26% 3,937,316 104% ; 24,115,011 22,953,057 95% 23,620,173 5,216,029 22% ; 22,516,653 95% ; 12,250,336 10,722,604 88% 12,576,839 3,638,782 29% 12,244,024 97% ; 70,540,907 52,841,578 75% 58,399,018 6,767,379 12% 58,492,644 100%: 289,252,325 248,531,468 86% 289,261,041 72,564,797 25% 289,079,118 100% ; �G �-T�S` Budget to Actuals - Countywide Summary o� All Departments 33.3% FY21 YTD October 31, 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) (6,544,548) 32% (20,308,890) 100% ; 030 - Juvenile 5,874,465 5,874,465 100% ; 5,957,854 1,985,958 33% 5,957,854 100% ; 160/170 - TRT (4,433,128) (4,430,732) 100% ; (4,678,036) (1,475,932) 32% ; (4,845,229) 104% ; 220 - Justice Court - - 107,235 35,744 33% ; 107,235 100%: 255 - Sheriff's Office 3,119,936 3,120,245 100% ; 3,119,077 1,130,613 36% ; 3,119,077 100%: 274 - Health Services 6,102,365 6,552,032 107% ; 8,026,313 1,822,370 23% 6,617,140 82% ; 295 - CDD (1,448,081) (1,111,631) 77% (55,480) (24,578) 44% (7,561) 14% ; 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 62,505 33% ; 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) (924,030) 25% ; (3,684,280) 100%: 615 - Fair & Expo 1,022,863 1,475,467 144% ; 494,967 233,564 47% ; ; 990,668 200% ; 616 - Annual County Fair (145,000) - 0% ; 75,000 37,222 50% ; 75,000 100% ; 617 - Fair & Expo Capital (13,313) (13,313) 100% ; 253,158 84,386 33% 420,351 166% ; Reserve 618 - RV Park (307,000) (307,000) 100% ; (436,628) (303,037) 69% ; (99,143) 23% ; 619 - RV Park Reserve 502,000 502,000 100% ; 621,628 310,814 50% ; 279,143 45% ; 670 - Risk Management (6,918) (6,918) 100% ; (3,500) (1,166) 33% ; (3,500) 100%: 705-911 - - " 999 - Other 11,123,785 10,814,785 97% ; 9,078,924 4,989,060 55% ; 10,360,200 114% ; TOTAL TRANSFERS ; (600,000) - 0 (410,723) - 0 - 0% E S� Budget to Actuals - Countywide Summary o All Departments 33.3% FY21 YTD October 31, 2020 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 ENDING FUND BALANCE Budget Actuals % Budget Actuals Projection % 001 - General Fund 9,346,536 13,529,514 145% ; 9,739,629 8,662,895 11,223,747 115% ; 030 - Juvenile 694,058 1,069,720 154% ; 616,595 884,409 819,212 133% ; 160/170 - TRT 3,324,732 3,490,749 105% ; 3,530,844 5,865,619 4,236,023 120% ; 220 - Justice Court 64,859 37,842 58% 57,804 7,884 (53,710) -93% ; 255 - Sheriff's Office 14,732,933 18,832,967 128% ; 16,222,048 11,319,303 17,384,382 107% ; 274 - Health Services 4,766,157 7,817,166 164% ; 4,791,811 10,171,347 7,931,160 166% ; 295 - CDD 1,097,104 1,253,356 114% ; 734,798 1,424,255 1,172,412 160% 325 - Road 2,303,905 4,217,071 183% ; 2,180,473 6,753,352 4,553,772 209% ; 355 - Adult P&P 1,918,976 3,119,990 163% ; 1,816,329 4,381,375 ; 2,393,906 132% ; 465 - Road CIP 15,938,430 25,512,586 160% ; 13,103,814 24,064,340 15,674,566 120% ; 610 - Solid Waste 644,638 2,285,566 355% ; 719,918 3,876,352 1,898,469 264% ; 615 - Fair & Expo 199,576 (1,199) -1% 255,550 50,957 216,377 85% ; 616 - Annual County Fair - (47,461) ; - (29,105) (98,044) ; 617 - Fair & Expo Capital - 726,169 999% ; 1,008,442 726,926 ; 756,580 75% ; Reserve 618 - RV Park 150,327 227,936 152% ; 43,512 64,165 - 0% ; 619 - RV Park Reserve 414,550 497,466 120% ; 1,012,728 811,480 686,209 68% ; 670 - Risk Management 5,455,826 8,676,750 159% ; 6,465,802 8,930,914 8,061,875 125% ; 675 - Health Benefits 14,309,716 16,101,833 113% ; 13,588,094 18,065,752 15,584,044 115% ; 705 - 911 6,066,720 9,162,894 151% ; 6,829,277 7,028,627 8,259,823 121% ; 999 - Other 41,618,580 69,175,048 166% ; 50,516,183 78,043,940 ; 56,044,529 111% ; TOTAL FUND BALANCE 191,104,787 118% ; 156,745,333 123,047,623 185,685,964 151% ; 133,233,651 o� \)-V ES`�{ Budget to Actuals Report c� .r 0 General Fund - Fund 001 FY21 YTD October 31, 2020 (unaudited) RESOURCES Property Taxes - Current Property Taxes - Prior Other General Revenues Assessor Clerk BOPTA District Attorney Tax Office Veterans Property Management TOTALRESOURCES REQUIREMENTS Assessor Clerk BOPTA District Attorney Medical Examiner Tax Office Veterans Property Management Non -Departmental TOTAL REQUIREMENTS TRANSFERS Transfers In Transfers Out TOTALTRANSFERS 33.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 29,046,840 29,310,769 101% 30,105,307 4,360,610 14% 30,267,217 101% 161,91& A 391,000 976,355 250% 358,000 283,804 79% 358,000 100% 3,020,400 3,136,644 104% 2,550,871 2,998,910 118% 4,003,408 157% ! 1,452,536 B 837,283 942,562 113% 836,713 574,728 69% 836,713 100% 1,615,280 2,242,070 139% 2,153,741 1,000,673 46% 2,153,741 100% 12,220 13,659 112% 12,220 8,990 74% 12,220 100% 383,806 333,772 87% 467,138 18,456 4% 447,138 96% ! (20,000)! C 195,390 257,219 132% 419,927 207,820 49% 419,927 100% 175,614 175,614 100% 175,608 - 0% 175,608 100%! D 120,000 125,925 105% 122,000 6,917 6% 122,000 100%! E 35,797,833 37,514,589 105% ; 37,201,525 9,460,908 25% 38,795,972 104% ; 1,594,447: Budget Actuals % Budget Actuals % 4,993,290 4,699,209 94% 5,237,507 1,617,271 31% 2,049,501 1,640,426 80% 2,051,015 595,663 29% 77,950 72,369 93% 79,945 27,828 35% 7,873,159 7,606,702 97% 8,234,075 2,622,874 32% 235,542 197,772 84% 236,358 52,924 22% 865,307 860,973 99% 970,608 322,662 33% 589,551 525,956 89% 639,571 177,474 28% 306,985 301,829 98% 317,533 101,094 32% 11526,702 1,511,418 99% 1,486,794 2,265,189 152% 18,517,987 17,416,654 94% ; 19,253,406 7,782,979 40% ; Projection % $ Variance 4,949,866 95% 287,641 F 1,928,946 94% 122,069! G 79,945 100% E � � 8,172,207 99% � 61,868! H r � 236,358 100% 970,608 100% 637,385 100%! 2,18& 1 317,533 100%, 3,500,000 235% (2,013,206); J 20,792,848 108% ; (1,539,442); Budget Actuals % Budget Actuals % Projection % $ Variance 260,000 260,000 100% 260,000 86,666 33% 260,000 100% K (19,283,310) (19,177,801) 99% (20,568,890) (6,631,214) 32% (20,568,890) 100% (19,023,310) (18,9179801) 99% ; (20,308,890) (6,544,548) 32% ; ; (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% F 13,529,514 112%: 1,429,114 Resources over Requirements 17,279,846 20,097,935 17,948,119 1,677,929 18,003,124 55,005� Net Transfers - In (Out) (19,023,310) (18,917,801) (20,308,890) (6,544,548) (20,308,890) TOTAL FUND BALANCE $ 9,346,536 $ 13,529,514 145% ; $ 9,739,629 $ 8,662,895 89% ; $ 11,223,747 115% ; $1,484,118: 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.4% 1 Projected Personnel savings based on FY21 savings to date J 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 Es` Budget to Actuals Report Juvenile - Fund 030 FY21 YTD October 31, 2020 (unaudited) RESOURCES OYA Basic & Diversion ODE Juvenile Crime Prev Inmate/Prisoner Housing Gen Fund -Crime Prevention Leases DOC Unif Crime Fee/HB2712 OJD Court Fac/Sec SB 1065 Interest on Investments Food Subsidy Contract Payments Miscellaneous Case Supervision Fee TOTALRESOURCES 33.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 442,601 387,814 88% 472,401 0% 472,401 100% A 91,379 82,125 90% 109,000 0% 109,000 100% A 80,000 96,600 121% 90,000 10,800 12% 80,000 89% (10,000)! B 20,000 20,000 100% 89,500 89,500 100%! 89,500 100%! C 86,400 97,061 112% 88,000 22,506 26% 88,000 100% 35,000 49,339 141% 49,339 - 0% 49,339 100% 26,000 20,404 78% 26,000 3,466 13% 26,000 100%! - 31,000 26,491 85% 17,300 6,605 38% 19,800 114% : 2,500! D 16,000 13,448 84% 12,000 2,427 20% 12,000 100% 8,000 5,459 68% 8,000 499 6% 8,000 100% 14,050 22,672 161% 7,550 10,429 138% 16,718 221% ! 9,168! E 6,500 4,736 73% 6,000 1,202 20% 6,000 100% 856,930 826,150 96% ; 975,090 147,434 15% 976,758 100%: 1,668; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 51797,927 5,650,045 97% 5,970,797 1,904,428 32% 5,757,681 96% 213,116 F Materials and Services 1,329,410 1,277,340 96% 1,387,552 384,388 28% a 1,397,552 101% (10,000)! 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,318,703 31% 7,185,120 97% 205,229: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 5,961,465 5,961,465 100% 6,U34,956 2,U71,bbz 33% b,U34,9bb 100°io Transfers Out-Veh Reserve (87,000) (87,000) 100% (77,112) (25,704) 33% (77,112) 100% TOTALTRANSFERS 5,874,465 5,874,465 100% ; 5,957,854 1,985,958 33% ; 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,171,269) (6,208,362) 206,89T Net Transfers - In (Out) 5,874,465 5,874,465 5,957,854 1,985,958 5,957,854 TOTAL FUND BALANCE $ 694,058 $ 1,069,720 154% ; $ 616,595 $ 884,409 143% ; $ 819,212 133% ; $202,617: 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 Includes CARES Fund reimbursements F Projected Personnel savings based on FY21 average vacancy rate of 3.1 % oh ` J�Es`,�� Budget to Actuals Report OG TRT - Fund 160/170 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year2020 1 Fiscal Year2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Room Taxes 7,670,000 7,527,492 98% 6,862,458 5,259,481 77% 8,200,000 119% : 1,337,542: A Interest 62,000 88,754 143% 53,900 26,501 49% 78,200 145% 24,300! B State Miscellaneous - - 100,000 100,000 100,000! C TOTALRESOURCES 7,732,000 7,616,246 99% 6,916,358 5,385,982 78% 8,378,200 121%; 1,461,842: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance COVA 2,064,221 2,050,618 99% 1,838,805 1,240,630 67% 2,206,630 120% (367,825); A Grants & Contributions 62,000 62,000 100% 404,000 243,666 60% 404,000 100% Interfund Contract " 79,160 79,160 100% 114,481 38,160 33% 114,481 100% D Interfund Charges 37,309 37,309 100% 4 35,861 11,954 33% t 35,861 100% Auditing Services 14,500 19,200 132% 11,500 - 0% 11,500 100% Software 10,350 - 0% 11,500 - 0% 4 11,500 1006% Public Notices 1,600 1,694 106% 1,600 770 48% 1,600 100% Office Supplies 3,000 741 25% 1,275 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,535,180 63% 2,787,697 115% ; (367,825); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer Out - RV Park (35,000) (35,000) 100% (20,000) (7,777) 39% (20,000) 100% - Transfer Out - Annual Fair (250,000) (250,000) 100% (75,000) (37,222) 50% (75,000) 100% } Transfer Out - F&E Reserve (286,687) (286,687) 100% (253,158) (84,386) 33% (420,351) 166% (167,1US), A Transfer Out - F&E (as needed) (325,744) (323,348) 99% (275,744) (8,584) 3% (59,367) 22% 216,377f E Transfer Out • Health - (406,646) (135,548) 33% (406,646) 100% F Transfer Out -F&E (383,910) (383,910) 100% (495,701) (151,900) 31% (495,701) 100% - Transfer Out - Sheriff (3,151,787) (3,151,787) 100% (3,151,787) (1,050,515) 33% (3,151,787) 100% TOTAL TRANSFERS (4,433,128) (4,430,732) 100% ; (4,678,036) (1,475,932) 32% (4,628,852) 99% 49,184: 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 3,850,802 5,590,503 1,094,017! Net Transfers - In (Out) (4,433,128) (4,430,732) (4,678,036) (1,475,932) (4,628,852) 49,184 TOTAL FUND BALANCE : $ 3,324,732 $ 3,490,749 105% ; $ 3,530,844 $ 5,865,619 166% ; ; $ 4,452,400 126% ; $921,556: 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 `�pTLS CQG �� _ FINANCE `°��� Budget to Actuals Report Justice Court - Fund 220 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Court Fines & Fees 575,000 556,877 97% 488,750 153,384 31% 488,750 100% A Interest on Investments 3,000 1,706 57% 1,100 48 4% 100 9% (1,000). B Miscellaneous - 3,030 - 736 737 737! TOTALRESOURCES 578,000 561,613 97% 489,850 154,169 31% 489,587 100%; (263); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 516,868 522,054 101% 531,006 172,117 32% 535,872 101% (4,866): C Materials and Services 161,273 145,944 90% 152,502 47,754 31% 152,502 100% - D TOTAL REQUIREMENTS 678,141 667,997 99% 683,508 219,870 32% ; 688,374 101%; (4,866); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund - 107,235 35,744 33% 107,235 100% E TOTALTRANSFERS 107,235 35,744 33% 107,235 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 165,000 144,227 87% 144,227 37,842 26% 37,842 26% (106,385)� Resources over Requirements (100,141) (106,384) (193,658) (65,702) (198,787) (5,129)! Net Transfers - In (Out) - - 107,235 35,744 107,235 - E TOTAL FUND BALANCE $ 64,859 $ 37,842 58% $ 57,804 $ 7,884 14% ($ 53,710) -93% ; ($111,514); A The FY21 budget reflects lower revenue compared to FY20 because of HB4210. Revenue may be reduced further, but the impact won't be known until late 2020. B Interest projection based on current investment rate and anticipated cash balances C Projected Personnel savings based on FY21 savings to date D One time yearly software maintenance fee of $9,169 paid in July for entire fiscal year E Additional transfers may be needed because of lower Court Fines and Fees revenue ` Budget to Actuals Report C� �G Sheriffs Office - Fund 255 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year2020 Fiscal Year2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance LED #1 Property Tax Current 26,293,470 26,496,529 101% 27,476,763 3,885,329 14% 27,569,562 100%, 92,799� A LED #2 Property Tax Current 10,632,014 10,696,589 101% 11,092,307 1,568,651 14% 11,130,853 100% ! 38,546! B Sheriff's Office Revenues 3,922,323 4,914,406 125% 4,259,128 1,581,247 37% 4,269,128 100%! 10,000! C LED #1 Property Tax Prior 312,000 761,642 244% 280,000 236,627 85% 280,000 100% LED #2 Property Tax Prior 148,000 331,165 224% 120,000 98,254 82% 120,000 100% LED #2 Interest 136,000 160,208 118% 120,000 26,179 22% 77,500 65% (42,500) C LED #1 Interest 138,000 287,276 208% = r 101,100 48,559 48% r i 143,200 142% , i 42,10& C r LED #1 Foreclosed Properties , - 21,380 r - - LED #2 Foreclosed Properties 8,631 - TOTAL RESOURCES 41,581,807 43,677,825 105% ; 43,449,298 7,444,847 17% ; 43,590,243 100% ; 140,945: 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 Budget Actuals % Budget Actuals % 3,105,057 3,092,171 100% 3,864,843 1,265,499 33% 1,232,158 1,171,260 95% 1,232,618 354,528 29% 2,858,337 2,915,540 102% 3,312,477 802,051 24% 2,303,072 2,217,577 96% 2,515,536 802,308 32% 10,592,002 11,446,211 108% 12,336,227 4,395,580 36% 1,004,600 833,934 83% 1,038,130 273,677 26% 18,379,998 17,929,047 98% 19,897,342 6,135,800 31% i 556,740 458,541 82% 490,401 157,721 32% 402,734 603,381 150% 543,565 4189156 77% 1,601,871 1,747,792 109% r 2,052,586 707,436 34% r 743,334 915,411 123% 1,15b,993 3M,544 26% 571,267 84,267 15% - - 1,330,214 1,261,716 95% 1,328,675 469,604 35% 4,425 105,917 999% (746,899) 530 0% 44,685,809 44,783,763 100% ; 49,022,494 16,084,435 33% ; Projection % $ Variance 3,829,872 99% 34,971 ; D 1,080,066 � 88% 152,55Z 3,159,353 r 95% � 153,124! 2,496,820 99% 18,716; 12,583,352 102% (247,125); 923,504 89% 114,626; 18,988,598 95% 908,744 470,106 96% 20,295 653,695 120% (110,130) 2,156,155 r 105% � (103,569), � 1,182,496 � -i02"io r (25,5u3); � 1,380,787 104% (52,112) (746,899) 100%, - E 48,157,905 98% ; 864,589; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - TRT 3,151,787 3,151,787 100% 3,151,787 1,050,515 33% 3,151,787 100% Transfer In - General Fund 240,249 240,249 100% 240,290 80,098 33% 240,290 100% - Transfers Out - Debt Service (272,100) (271,791) 100% (273,000) - 0% (273,000) 100% - TOTALTRANSFERS 3,119,936 3,120,245 100% ; 3,119,077 1,130,613 36% ; ; 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,800� Resources over Requirements (3,104,002) (1,105,938) (5,573,196) (8,639,588) (4,567,662) 1,005,534; Net Transfers - In (Out) 3,119,936 3,120,245 3,119,077 1,130,613 3,119,077 r E 7 1 t t TOTAL FUND BALANCE $ 14,732,933 $ 18,832,967 128% ; $ 16,222,048 $ 11,323,992 70% ; ; $ 17,384,382 107% ; $1,162,334: A Current year taxes received primarily in November, February and May; actual 20-21 TAV is 5.40% compared to FY19-20 vs. 5.00% budgeted B Current year taxes received primarily in November, February and May; actual 20-21 TAV is 5.31 % compared to FY19-20 vs. 5.00% budgeted C Interest projection based on current investment rate and anticipated cash balances D Divisions projected to be less than budget are related to hiring process being impacted by COVID. Divisions projected to be higher than budget are impacted by overtime related to fires as well as delays sending employees to Academy due to COVID. E Budgeted funds includes transfers from Funds 701 and 702 Budget to Actuals Report co Health Services - Fund 274 FY21 YTD October 31, 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 33.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 Ll Budget Actuals % Budget Actuals % Projection % $ Variance 14080,644 11,212,405 80% 14,228,003 4,898,185 34% 15,808,777 111% 1,580,774: 7:242,430 8,094,701 112% 8,279,406 3,271,174 40% 8,372,235 101% 92,829 3,277,616 2,798,690 85% 4,492,822 35,497 1% 4,404,294 98% (88,528)! 3,265,627 1,359,830 42% 4,079,489 125% 813,862! 1,040,153 1,387,132 133% 2,238,388 671,332 3U% 1,567,331 1,133,942 72% 1,765,208 3,360,592 190% 991,900 879,037 89% 1,162,507 376,489 32% 1,058,206 1,104,825 104% 1,091,652 81,496 7% 484,712 476,047 98% 965,971 236,107 24% 564,750 600,412 106% 672,995 142,677 21% 41862,726 4,071,759 84% 350,491 305,132 87% 220,000 259,029 118% 237,296 88,269 37% 173,030 173,030 100% 173,030 173,030 100% 120,000 191,912 160% 155,000 59,124 38% 171,000 233,116 136% , 147,400 71,584 49% 127,000 127,000 100%! 127,000 0% 150,800 162,122 108%, 99,500 34,894 35% - (12,894) 999% - 36,132,298 32,892,266 91% 39,452,296 15,165,960 38% ; 2,bk5b,9bt5 7LU% � 44/,06u, 4,068,240 230% 2,303,032! 1,130,065 97% (32,442) 1,092,357 100%, 705; 695,109 72% (270,862); 434,371 65% (2381624)� 469,392 134% , 118,901 264,432 111% 27,136; 173,030 100% 177,371 114% 22,371 214,753 146% ! 67,353; 127,000 100% F 99,500 100% 44,296,381 112% ; 4,844,085: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 33,186,830 32,041,791 97% 36,772,994 11,484,467 31% 35,288,148 96% 1,484,846; Materials and Services 13,707,479 10,223,447 75% 13,027,296 3,149,346 24% 15,4131,v66 1 1fi% (2,385,770); Capital Outlay 695,000 - 0% 99,667 0% 98,313 99% 1,354 Administration Allocation (10) 0% t - -3% (10y TOTAL REQUIREMENTS 47,589,309 42,265,238 89% ; 49,899,947 14,633,813 29% ; 50,799,527 102% ; (899,580); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 5,747,090 5,747,090 100% 5,472,710 1,764,458 32% 5,472,710 100% -' Transfers In- OHP Mental Health 548,601 998,268 182% 2,379,865 - 0% 4 970,692 41% (1,409,173)! Transfers In - TRT � - - 406,646 135,548 33% 406,646 100% -' Transfers Out (193,326) (193,326) 100% (232,908) (77,636) 33% (232,908) 100% TOTALTRANSFERS 6,102,365 6,552,032 107% ; 8,026,313 1,822,370 23% ; 6,617,140 82% (1,409,173); 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% 7,817,166 108% 604,017: Resources over Requirements (11,457,011) (9,372,971) (10,447,651) 532,147 (6,503,146) 3,944,505! Net Transfers - In (Out) � 6,102,365 6,552,032 p 8,026,313 1,822,370 F ( 6,617,140 (1,409,173) d k TOTAL FUND BALANCE $ 4,766,157 $ 7,817,166 164% ; $ 4,791,811 $ 10,171,683 212% ; ; $ 7,931,160 166% ; $3,139,349; �lES` Budget to Actuals Report Health Services - Admin - Fund 274 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Federal Grants 726,655 565,906 78% 784,126 - 0% 872,170 111% 88,044; A Interest on Investments 171,000 233,116 136% 147,400 71,584 49% 214,753 146% 67,353, B Other k 9,000 8,718 97% 14,391 4,116 29% 12,349 86% (2,042)! State Miscellaneous k - � 171,881 k - 5,166 F kk 49,388 i 49,388, C k CCBHC Grant - - -' TOTALRESOURCES 906,655 979,620 108% ; 945,917 80,866 9% 1,148,659 121% ; 202,742: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,241,264 4,870,386 93% 5,360,412 1,624,896 30% 5,017,491 94% 342,921; D Materials and Services k 4,971,179 4,690,935 94% 4,968,341 1,604,199 32% 5,063,062 102% (94,720) Capital Outlay 5,000 - 0% - - - Administration Allocation k (9,308,295) (9,306,000) 100% (9,627,992) (2,360,180) 25% $ (9,625,628) 100% (2,364) TOTAL REQUIREMENTS 909,148 255,321 28% 700,761 868,915 124% ; 454,925 65% ; 245,836: 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) (77,636) 33% (232,908) 100% TOTALTRANSFERS ; (153,326) (153,329) 100% ; (232,908) (77,636) 33% (232,908) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,660,832 2,748,263 103% 2,772,840 3,322,793 120% 3,322,793 120% 549,953 Resources over Requirements (2,493) 724,299 245,155 (788,049) 693,734 448,578 Net Transfers - In (Out) (153,326) (153,329) (232,908) (77,636) (232,908) TOTAL FUND BALANCE $ 2,505,013 $ 3,319,234 133% ; $ 2,785,087 $ 2,457,109 88% ; ; $ 3,783,619 136% ; $998,532: 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 C oh.lES Budget to Actuals Report o Health Services - Behavioral Health - Fund 274 FY21 YTD October 31, 2020 (unaudited) RESOURCES State Grant OHP Capitation Federal Grants OHP Fee for Service State Miscellaneous Local Grants Other Patient Fees Title 19 State - OMAP Divorce Filing Fees Interfund Contract- Gen Fund Liquor Revenue CCBHC Grant TOTALRESOURCES 33.3% Year Complete Fiscal Year 2020 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 11,203,914 8,259,750 74% 10,348,047 3,069,999 30% 11,624,695 112% 1,276,648 A 7,242,430 8,094,701 112% 8,279,406 3,271,174 40% 8,372,235 101% 92,829, B 2,168,961 1,823,950 84% 3,411,088 0% 3,298,243 97% (112,845) 3,265,627 1,359,830 42% 4,079,489 125% , 813,862 C 437,100 326,534 75% i 1,468,455 541,721 37% 1,085,954 74% (382,501): D 994,331 487,025 49% 1,067,507 1,610,913 151% 2,026,992 190% , 959,485, E 395,352 360,920 91% 927,605 224,953 24% 672,418 72% (255,187)! F 443,450 465,851 105% 522,300 108,365 21% 326,132 62% (196,168) G 4,862,726 4,071,759 84% 350,491 305,132 87% 469,392 134% , 118,901� H 131,900 174,354 132% 210,287 44,801 21% 134,201 64% ! (76,086)! 173,030 173,030 100% 173,030 173,030 100% 173,030 100% 127,000 127,000 100%! 127,000 - 0% 127,000 100%! - 150,800 162,122 108% 99,500 34,894 35% 99,500 100%! -° (12,894) 999% < - - -' 28,330,994 24,514,102 87% ; 30,250,343 10,744,812 36% 32,489,280 107% ; 2,238,937: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 6,978,412 6,963,580 100% 7,427,338 1,810,019 24% 7,424,984 100% 2,354= Personnel Services 20,174,804 19,576,382 97% 23,281,788 7,137,889 31% 22,817,618 98% 464,171� I Materials and Services 6,889,404 3,802,898 55% 5,699,701 904,994 16% 6,209,974 109% (510,274)! 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 9,852,901 27% 36,550,889 100% ; (42,395); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- OHP Mental Health 548,601 998,268 182% 2,298,179 0% 889,006 39% (1,409,173), Transfers In- General Fund 1,734,107 1,734,100 100% 2,036,117 678,706 33% 2,036,117 100% Transfers Out - - - - 0% - 0% TOTALTRANSFERS ; 2,282,708 2,732,368 120% ; 4,334,296 678,706 16% ; , 2,925,123 67% ; (1,409,173); 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,87& Resources over Requirements t (6,401,626) (5,828,757) (6,258,151) 891,911 (4,061,609) 2,196,54Z Net Transfers - In (Out) 2,282,708 2,732,368 4,334,296 678,706 2,925,123 (1,409,173) G TOTAL FUND BALANCE $ 2,003,429 $ 3,576,867 179% ; $ 1,223,122 $ 4,968,470 406% ; ; $ 2,261,367 185% ; $1,038,245: 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. g Includes FY20 withhold payment of $93K C Oregon Health Authority reports CHIP 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 November 2020 I 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 oh 01Es C Budget to Actuals Report L� 0G Health Services - Public Health - Fund 274 FY21 YTD October 31, 2020 (unaudited) RESOURCES State Grant Environmental Health Fees State - OMAP State Miscellaneous Local Grants Federal Grants Vital Records State Shared- Family Planning Patient Fees Other TOTALRESOURCES 33.3% Year Complete Fiscal Year2020 Fiscal Year2021 Budget Actuals % Budget Actuals % Projection % $ Variance 2,876,730 2,952,656 103% 3,879,956 1,828,186 47% 4,184,082 108% 304,126: A 1,058,206 1,104,825 104% < 1,091,652 81,496 7% 1,092,357 100%! 705! 860,000 704,683 82% 952,220 331,688 35% 995,863 105% ! 43,643! 603,053 888,717 147% 769,933 124,995 16% 1,550,626 201% ! 780,693: B 573,000 646,917 113% 697,701 1,749,679 251% 2,041,248 293% < 1,343,547: C 382,000 408,834 107% 297,609 35,497 12% 233,881 79% (63,727) 220,000 259,029 118% 237,296 88,269 37% 264,432 111% ! 27,136! 120,000 191,912 160% 155,000 59,124 38% 177,371 114% , 22,371 121,300 134,562 111% : 150,695 34,312 23% 108,239 72% (42,456)! 80,360 106,409 132% , 23,975 7,038 29% 10,342 43% (13,633)! 6,894,649 7,398,544 107% ; 8,256,037 4,340,282 53% 10,658,442 129% ; 2,402,406: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 2,329,883 2,342,420 101% 2,200,644 550,161 25% 2,200,644 100% Personnel Services 7,770,762 7,595,023 98% 8,130,794 2,721,682 33% 7,453,039 92% 677,755 D Materials and Services 1,846,896 1,729,614 94% 2,359,254 640,153 27% 4,140,030 175% (1,780,776)1 E TOTAL REQUIREMENTS ; 11,947,541 11,667,057 98% ; 12,690,692 3,911,997 31% 13,793,714 109% ; (1,103,022); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 3,972,983 3,972,993 100% 3,436,593 1,085,752 32% 3,436,593 100% Transfers In - TRT 406,646 135,548 33% 406,646 100% Transfers In- OHP Mental Health 81,686 - 0% 81,686 10u o TOTALTRANSFERS 3,972,983 3,972,993 100% ; 3,924,925 1,221,300 31% ; 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) 428,285 (3,135,271) 1,299,384; Net Transfers - In (Out) 3,972,983 3,972,993 3,924,925 1,221,300 3,924,925 TOTAL FUND BALANCE $ 257,715 $ 921,065 357% ; $ 783,602 $ 2,746,105 350% ; $ 1,886,173 241% ; $1,102,572 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 Projections include an estimated $1.3 million from Central Oregon Health Council (COHC) through a release of Quality Improvement Metric (QIM) funding; funds are to be used on efforts and impacted services related to COVID-19. Public Health is developing an expenditure plan. Expenses are not yet appropriated and are included in projections under Materials and Services, pending approval from the Board. D Projected Personnel Services based on YTD Personnel expenditures E Expenditures related to footnote B and C \31ES ` Budget to Actuals Report ye ` 9& Community Development - Fund 295 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year2020 1 Fiscal Year2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 162,000 156,476 97% 137,450 46,718 34% 144,750 105% , 7,300; A Code Enforcement 693,960 664,545 96% 722,028 226,205 31% 722,028 100% Building Safety 3,433,780 3,179,771 93% 3,362,450 1,130,744 34% 3,362,450 100%, Electrical 809,500 797,458 99% 720,600 286,398 40% 725,600 101% 5,000! Environmental On -Site 877,400 905,165 103% 867,700 337,265 39% 893,300 103% , 25,600 Current Planning 1,807,176 1,696,355 94% 1,738,304 548,393 32% 1,738,304 100% Long Range Planning 685,004 643,772 94% 703,194 232,407 33% 703,194 100%, - TOTALRESOURCES 8,468,820 8,043,542 95% 8,251,726 2,808,131 34% ; 82289,626 100% ; 37,900: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 2,492,316 2,527,439 101% 2,818,748 942,372 33% 2,835,448 101% (16,700): Code Enforcement 535,590 458,293 86% 568,320 162,683 29% t 543,467 96% 24,853! B Building Safety 1,743,298 1,584,784 91% t 1,867,662 556,309 30% ! 1,845,502 99% 22,160! B Electrical 462,183 452,842 98% 524,979 158,621 30% 520,357 99% 4,622! B Environmental On -Site 616,279 566,975 92% 634,452 208,761 33% 4 645,502 102% (11,050) Current Planning 1,501,588 1,415,434 94% 1,479,294 457,440 31% _ 1,449,208 98% 30,086 B Long Range Planning 554,385 456,323 82% 580,687 126,470 22% 523,525 90% 57,162! B TOTAL REQUIREMENTS 7,9052639 7,462,091 94% 8,474,142 2,612,654 31% ; 8,363,009 99% 111,133; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - General Fund 100,000 100,000 100% 100,000 58,333 58% F I 175,000 175% i 75,000: C i Transfers In - CDD Electrical - - I 93,264 - 0% 84,468 91% (Bjub); Reserve Transfers Out (85,695) (85,695) 100% (100,518) (33,503) 33% (100,518) 100% Transfers Out - CDD Reserve (1,462,386) (1,125,936) 77% (148,226) (493409) 33% (166,511) 112% � (18,285)� TOTALTRANSFERS ; (1,448,081) (1,111,631) 77% (55,480) (24,578) 44% ; (7,561) 14% ; 47,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) 195,476 (73,383) 149,033! Net Transfers - In (Out) (1,448,081) (1,111,631) (55,480) (24,578) t (7,561) 47,919 TOTAL FUND BALANCE : $ 1,097,104 $ 1,253,356 114% ; $ 734,798 $ 1,424,255 194% ; ; $ 1,172,412 160% ; $437,614: A Interest projection based on current investment rate and anticipated cash balances B Projection reflects unfilled FTE C Transfer appropriated in the General Fund is $175K v'(ES Cp G Budget to Actuals Report L�' ; Road - Fund 325 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Motor Vehicle Revenue 17,609,539 16,795,577 95% 14,810,507 5,004,460 34% 15,402,780 104% 592,271 A Federal - PILT Payment 11510,450 2,310,002 153% 1,690,574 2,061,977 122% 2,061,977 122% , 371,403. B Federal Reimbursements 181,757 372,623 205% 1,325,874 933,691 70% 933,692 70% (392,182)' C Other Inter -fund Services 1,156,581 1,070,000 93% 1,114,070 119,107 11% 1,114,070 100% Forest Receipts 915,000 709,742 78% 723,085 - 0% 723,085 100% Sale of Equip & Material 358,000 465,999 130% 396,000 40,935 10% 396,000 100%, Cities-Bend/Red/Sis/La Pine 660,000 421,344 64% 385,000 - 0% 385,000 100% Interest on Investments 246,000 174,141 71% 114,000 24,645 22% 73,900 65% (40,100); D Mineral Lease Royalties 60,000 54,184 90% 60,000 1,450 2% 60,000 100% Miscellaneous 57,500 76,388 133% , 54,000 30,199 56% ' 54,000 100% , Assessment Payments (P&I) 11,000 19,766 180% 8,000 2,170 27% 8,000 100%! State Miscellaneous 20,000 25,805 129% 2,183 2,184 2,184 TOTALRESOURCES 22,785,827 22,495,570 99% 20,681,110 8,220,819 40% 21,214,687 103% ; 533,577; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 6,447,671 6,284,546 97% 6,709,180 2,102,438 31% 6,390,743 95% 318,43T E Materials and Services 8,092,165 6,782,513 84% 7,753,525 2,157,149 28% 7,753,525 100% Capital Outlay 33,500 27,706 83% 50,500 6,006 12% 50,500 100% TOTAL REQUIREMENTS 14,573,336 13,094,764 90% 14,513,205 4,265,593 29% 14,194,768 98% 318,437: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out (11,910,575) (11,910,575) 100% (6,683,218) (1,418,945) 21 o (6,683,218) 100% TOTALTRANSFERS (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 3,955,226 7,019,919 852,014 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 $ 6,753,352 310% ; ; $ 4,553,772 209% ; $2,373,299: 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.8% �I ES Budget to Actuals Report Adult P&P - Fund 355 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance DOC Grant in Aid SB 1145 4,353,626 4,621,782 106% , 4,621,780 2,310,891 50% 4,621,780 100% A CJC Justice Reinvestment 1 712,530 1,014,690 142% 797,504 532,690 67% 797,504 100% DOC Measure 57 236,142 239,005 101% 239,005 239,005 100% 239,005 100%, B Probation Supervision Fees I 160,000 183,688 115% 170,000 57,980 34% 170,000 100% Interfund- Sheriff I 50,000 55,000 110% 50,000 18,333 37% 50,000 100% Gen Fund/Crime Prevention I 50,000 50,000 100% 50,000 50,000 100% 50,000 100% C Interest on Investments 77,500 64,896 84% 37,700 21,113 56% 63,300 168% 25,600! D State Subsidy 16,298 16,703 102% , 16,298 0% - 0% (16,298); E Electronic Monitoring Fee 2,000 20,182 999% 10,000 1,543 15% 5,000 50% (5,000); F Probation Work Crew Fees I 2,000 1,923 96% 2,000 120 6% 2,000 100% Miscellaneous 500 15,412 999% 1,000 335 33% 1,000 100% State Miscellaneous I - 22,986 - 167 167 167, DOC-Family Sentence Alt 114,682 223,746 195% ! - ? - Oregon BOPPPS - 40,933 - - - TOTALRESOURCES 5,775,278 6,570,946 114% ; 5,995,287 3,232,176 54% ; 5,999,756 100% ; 4,469; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 4,809,644 4,753,486 99% 5,157,473 1,625,850 32% 4,989,541 97% 167,932, G Materials and Services I 1,844,847 1,663,665 90% 1,923,795 407,445 21% l i 1,923,795 100% t I f Capital Outlay 15,000 11,000 73% - - - TOTAL REQUIREMENTS 6,669,491 6,428,151 96% 7,081,268 2,033,295 29% 6,913,336 98% 167,932, TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 285,189 285,189 100% 285,189 95,069 33% 285,189 100% Transfer to Vehicle Maint (62,000) (62,000) 100% (97,693) (32,564) 33% (97,693) 100% TOTALTRANSFERS 223,189 223,189 100% ; 187,496 62,505 33% 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,176 Resources over Requirements (894,213) 142,795 (1,085,981) 1,198,881 (913,580) 172,401 Net Transfers - In (Out) 223,189 223,189 i i 187,496 62,505 i t 187,496 i f TOTAL FUND BALANCE $ 1,918,976 $ 3,119,990 163% ; $ 1,816,329 $ 4,381,375 241% ; $ 2,393,906 132% ; $577,577: 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 Projected Personnel savings based on FY21 average vacancy rate of 4.9% o �IES`0 2� Budget to Actuals Report L�.. Road CIP - Fund 465 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year2020 1 Fiscal Year2021 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 132,516 63% 397,500 190% 187,800, A Interfund Payment - 111,340 - - - TOTAL RESOURCES 2,1422893 2,145,706 100% ; 2,467,800 132,516 5% ; 22655,600 108% ; 187,800: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 71,748 71,748 100% 158,465 52,822 33% _ 158,465 100% Capital Outlay 13,764,165 5,752,905 42% 19,877,585 1,527,941 8% 19,8529812 100% 24,773 TOTAL REQUIREMENTS ; 13,835,913 5,824,653 42% 20,036,050 1,580,762 8% ; 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) (1,448,246) i (17,355,677) ± 212,573 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 $ 24,064,340 184% ; $ 15,674,566 120% ; $2,570,752: A Interest projection based on current investment rate and anticipated cash balances I S Budget to AcAuaUs, Report u � Road CUP (Fund 465) - Capital Outlay Summary by Project 33.3% --*� FY21YTOOctober 31.282O(unauditad) Year Completed Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance TmnmoRes Rd: oaRiley mBailey nu Sisemmmoridgo 632,174 ARTS Project ronvuonnoRefinement Plan uSunatTvmam 300,000 a.Canal '^aix'oorno� """^^^ '~^^'^~''~'^ CAvenue: Hwy ormomsx|mpm Paving Ward Road s.Canal /Helmholtz Way Tuma|oRoad /Tuma|vPlace Old Bend numnuma|vnuInter Spring River Bridge Parking Imp 12,122 wswonvoand 1rrH '---'~ --~ 46,189, *unne|nu��000nmm�vma/onm 675,733 ^^~ 118,496, Cascade Lakes Hwy Bike Facilities Transportation System Plan Update Slurry Seal oouo 284,432 uSuoWard numHamby uao7Bend North Corridor nnuunnnnma,mno ^^^^^ ' ^'^ Alfalfa Mkt Rd: Powell Butte Hwy Paving prmo,nm Paving ma.Century o, - ~`'^ 100,000 447,416 --'~ roneuvnnaWastewater Feasibility St. Rickard Rd: Groff Rmmuuoo Paving Powell Butte Hwy Smith Rock Way Bridge Replace onvoou$mmmnu/HamohovxRound ' '~°,,~ ' ^~ uaorS.Century o,muaFSavvnory Johnson nuCurve Warning Signs Speed Feedback Sign Installation ovardmn/mpmvomemo Bend o/mnmLocal Roads ~^```^ '^`~ City ovLapmeLocal Roads Sidewalk Ramp Improvements 75,000 aiun000/mpmvvmonm TOTAL �IEs o � Budget to Actuals Report E Solid Waste- Fund 610 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Franchise Disposal Fees 6,437,500 6,444,136 100% 6,630,625 2,312,092 35% 6,630,625 100%, < A Private Disposal Fees 2,419,046 2,556,619 106% 2,491,617 1,065,868 43% 2,491,617 100%! A Commercial Disp. Fee 2,252,225 2,429,879 108% 2,319,792 930,959 40% 2,319,792 100% Franchise 3% Fees 265,000 297,352 112% , 280,000 21,222 8% 280,000 100% B Yard Debris 216,761 290,794 134% 2165761 132,121 61% 216,761 100%, C Miscellaneous 48,336 191,720 397% 88,096 26,180 30% 88,096 100%! D Interest 59,000 49,256 83% i 23,700 18,855 80% 56,600 239% , 32,900, E Special Waste 15,000 28,830 192% 15,000 24,714 165% < 27,000 180% 12,000, F Recyclables 12,000 12,163 101% 12,000 4,564 38% 12,000 100% Leases 1 1 100% 1 0% ! 1 100%, TOTALRESOURCES 11,724,869 12,300,751 105% ; 125077,592 4,536,574 38% 12,122,492 100% ; 44,900: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 2,538,776 2,393,257 94% 2,518,594 807,543 32% 2,490,690 99% 27,904, G Materials and Services 4,927,163 4,251,937 86% 5,227,119 1,214,216 23% 5,227,119 100% 1 H Capital Outlay 56,000 11,724 21% 1625500 - 0% 162,500 100% Debt Service 862,100 861,644 100% 945,000 - 0% 945,000 100%! 2 TOTAL REQUIREMENTS ; 8,384,039 7,518,563 90% 8,853,213 2,021,759 23% ; 8,825,309 100%; 27,904: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance SW Capital & Equipment (3,296,192) (3,296,192) 100% ; (3,684,280) (924,030) 25% (3,684,280) 100% Reserve TOTALTRANSFERS (3,296,192) (3,296,192) 100% ; (3,684,280) (924,030) 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,1 Resources over Requirements 3,340,830 4,782,188 3,224,379 2,514,816 3,297,183 72,804! Net Transfers - In (Out) (3,296,192) (3,296,192) (3,684,280) (924,030) (3,684,280) TOTALFUND BALANCE $ 644,638 $ 2,285,566 355% ; $ 719,918 $ 3,876,352 538% ; $ 1,898,469 264% ; $1,178,551: 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 2.15% 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 An influx of disposal volume and postponement of costs in FY20, such as the waste characterization study, positively impacted the beginning fund balance. C� 0 �1 E - S Budget to Actuals Report E' ` Fair & Expo - Fund 615 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Events Revenue 687,000 328,219 48% 625,000 212,145 34% 533,000 85% (92,000)� A Food & Beverage 568,000 280,874 49% 548,500 68,847 13% 268,000 49% (280,500)1 B Rights & Signage 120,000 114,100 95% 125,000 8,000 6% 106,000 85% (19,000)! C Storage 71,000 83,158 117% 75,000 19,501 26% 90,000 120% 15,000! D Horse Stall Rental 62,000 37,386 60% 52,000 665 1% 15,000 29% (37,000) Interfund Payment 30,000 143,956 480% 30,000 106,835 356% 170,000 567% 140,000� E Camping Fee 18,000 5,600 31% 122500 - 0% 12,000 96% (500) Miscellaneous 3,500 2,236 64% 250 1,874 750% ; 2,150 860% , 1,900, Interest 2,000 (5,006) -250% (2,200) 130 -6% 400 -18% 2,60& F TOTALRESOURCES 1,561,500 990,522 63% ; 1,466,050 417,996 29% ; 1,196,550 82% (269$00); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 1,176,169 1,108,608 94% 840,704 341,371 41% _ = 1,025,371 122% (184,667), G Personnel Services - F&B 157,430 158,556 101% 165,518 53,671 32% 160,871 97% 4,647! G Materials and Services 795,788 787,884 99% 702,149 166,686 24% 573,000 82% 129,149, H Materials and Services - F&B 234,600 217,425 93% 257,600 37,676 15% 106,000 41% 151,600! H Debt Service 100,800 100,151 99% 104,400 0% 104,400 100% TOTAL REQUIREMENTS 2,464,787 2,372,624 96% 2,070,371 599,404 29% ; 1,969,642 95% 100,729: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Room Tax 383,910 383,910 100%, 250,000 151,900 61% 495,701 198% : 245,701: 1 Transfers In - General Fund 200,000 200,000 100% 200,000 66,672 33% 200,000 100% Transfers In - Park Fund 30,000 30,000 100% 30,000 10,000 33% _ 30,000 100% Transfers In - Room Tax (as 25,744 323,348 999% i 25,744 8,584 33% 59,367 231% 33,623, J needed) ; Transfers In - County Fair 395,000 250,000 63% - - � Transfers In - F&E Capital 300,000 - Reserve Transfers Out (11,791) (11,791) 100% (10,777) (3,592) 33% (10,777) 100% TOTALTRANSFERS 1,022,863 1,475,467 144% ; 494,967 233,564 47% ; 774,291 156% ; 279,324: 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) (181,408) (773,092) (168,771); Net Transfers - In (Out) 1,022,863 1,475,467 494,967 233,564 774,291 279,324 TOTAL FUND BALANCE $ 199,576 ($ 1,199) -1% $ 255,550 $ 50,957 20% - 0% ; ($255,550); Footnotes on following page `'01 ES,E-0 ay FINANCE Note: Resources to date show an increase compared to PY YTD A Events revenue severely impacted by gathering size limitations; current year receipts are 34% of budget YTD; prior year receipts were 25% of budget at this point last year. 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 12.31.20. F Interest projection based on current investment rate and anticipated cash balances G Working with HR on staffing plan to reduce expense where possible 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 coG2 FINANCE 0�31 E SBudget to Actuals Report ` 0G Annual County Fair - Fund 616 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year2020 1 Fiscal Year2021 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 122,000 12,600 10% - (950) 999% (950) 999% (950) Interest on Investments 200 (166) -83% s (71) 999% (200) 999% (200), A Fair Sponsorship 37,500 19,108 51% - Merchandise Sales 5,000 5,246 105% - - - Concessions and Catering 425,000 466,503 110% i - Carnival 340,000 328,274 97% - Livestock Entry Fees 7,000 4,731 68% RN Camping/Horse Stall Rental 26,000 625 2% - - Gate Receipts 560,000 561,460 100% - Rodeo 25,000 5,650 23% - - Concert 50,000 12,000 24% - TOTAL RESOURCES 1,649,700 1,469,198 89% 52,000 52,145 100% ; 52,017 100% ; 17; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 164,638 157,448 96% 110,000 53,273 48% 159,600 145% _ (49,600); 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 71,012 56% 177,600 140% ; (50,600); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - TRT 1% 250,000 250,000 100% 75,000 37,222 50% 75,000 100% Transfer Out -Fair &Expo (395,000) (250,000) 63% - TOTALTRANSFERS (145,000) - 0% 75,000 37,222 50% ; 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) (18,866) (125,583) (50,583) Net Transfers - In (Out) E (145,000) i 75,000 37,222 75,000 Es t TOTAL FUND BALANCE _ ($ 47,461) ($ 29,105) ($ 98,044) ($98,044) A Interest projection based on current investment rate and anticipated cash balances 8 F&E is working with HR on a staffing plan to reduce expense where possible FINANCE Fs Budget to Actuals Report 6 Annual County Fair - Fund 616 CY21 YTD October 31, 2020 (unaudited) RESOURCES Gate Receipts Carnival Commercial Exhibitors Livestock Entry Fees RN Camping/Horse Stall Rental Merchandise Sales Concessions and Catering Fair Sponsorship TOTAL FAIR REVENUES OTHER RESOURCES State Grant Interest Miscellaneous TOTAL RESOURCES REQUIREMENTS Personnel Materials & Services TOTAL REQUIREMENTS TRANSFERS Transfer In - TRT 1 % Transfer Out - Fair & Expo TOTAL TRANSFERS Net Fair Beginning Fund Balance on Jan 1 Ending Balance 2020 Fair 2019 Fair 2020 Projection $ 562,065 $ - $ - 328,274 ! - - 312,402 (5,800) (5,800) 4,731 f - - 29,250 - - 5,246 ! - - 293,076 - - 148,943 (22,250) (22,250) $ 1,683,988 $ (28,050) $ (28,050) 53,167 53,167 53,167 204 21 21 c 7 w .,...z7 ,3..58 .... c 25 137 w �� a 25,137 w 155,215 134,533 161,133 1,509,039 : 85,216 85,216 $ 1,664,255 $ 219,749 $ 246,349 200,000 162,222 171,666 (250,000)' _ - - $ (50,000)' $ 162,222 $ 171,666 $ 23,104 $ (32,390) $ (49,545) $ (19,819) $ 3,285 $ 3,285 $ 3,285 $ (29,105) $ (46,261) A Cash receipts for Fair 2020 were received in July -December of 2019, but refunded in 2C B F&E is working with HR on a staffing plan to reduce expense where possible C Ending balance including cash receipts received in July -December of 2019 would be ($1,054.95) for 2020 Actuals and ($18,210.55) for 2020 Projections �I ES ` Budget to Actuals Report 0 Fair & Expo Capital Reserve - Fund 617 33.3% FY21 YTD October 31, 2020 (unaudited) Year Complete Fiscal Year2020 Fiscal Year2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 16,000 21,189 132% 14,000 3,992 29% 12,000 86% (2,000), A TOTALRESOURCES 16,000 21,189 132% ; 14,000 3,992 29% ; 12,000 86% ; (2,000); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 345,000 243,985 71% 235,000 825 0% 235,000 100% Capital Outlay E 1,017,775 180,946 18% 166,940 86,796 52% 166,940 100% TOTAL REQUIREMENTS 1,362,775 424,931 31% ; 401,940 87,621 22% 401,940 100%; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - TRT 1% 286,687 286,687 100% 253,158 84,386 33% 420,351 166% 167,193; B Transfers Out E (300,000) (300,000) 100% - - TOTALTRANSFERS (13,313) (13,313) 100% ; 253,158 84,386 33% 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) (83,629) f (389,940) (2,000)! Net Transfers - In (Out) (13,313) (13,313) 253,158 84,386 420,351 167,193, TOTAL FUND BALANCE $ 726,169 999% ; $ 1,008,442 $ 726,926 72% ; $ 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 �lEs�0 Budget to Actuals Report ALP, ' v G RV Park - Fund 618 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance RV Park Fees < 31 Days 405,200 412,954 102% 400,200 233,006 58% 369,108 92% (31,092); A RV Park Fees > 30 Days 5,000 13,050 261% 12,000 - 0% 11,745 98% (255) Interest on Investments 12,000 10,746 90% 7,600 1,210 16% 3,600 47% (4,000); 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 2,554 64% 4,731 118% 731 ; D Vending Machines 3,000 1,821 61% 3,000 542 18% i 752 25% (2,248); D Miscellaneous 2,000 2,332 117% 2,250 1,244 55% 1,244 55% (1,00% Good Sam Membership Fee 1,500 476 32% 1,500 - 0% 0% (1,500); E Good Sam Discounts - (7,109) 999% - - E TOTALRESOURCES 437,700 445,454 102% ; 436,050 238,711 55% ; 391,335 90% (44,715); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 318,273 281,699 89% 321,402 99,445 31% 297,628 93% 23,774: F Debt Service 222,100 221,810 100%! 222,500 - 0% 222,500 100% TOTAL REQUIREMENTS ; 540,373 503,509 93% 543,902 99,445 18% 520,128 96% ; 23,774: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Park Fund 160,000 160,000 100% 160,000 - 0% 160,000 100% Transfers In - TRT Fund 35,000 359000 100% 25,000 7,777 31% ? 20,000 80% (5,000); G Transfer Out - RV Reserve (502,000) (502,000) 100% (621,628) (310,814) If 50% (279,143) 45% ! 342,485, H TOTALTRANSFERS (307,000) (307,000) 100%: (436,628) (303,037) 69% ; (99,143) 23% ; 337,485; 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) 139,266 (128,793) (20,941); Net Transfers - In (Out) (307,000) (307,000) (436,628) (303,037) (99,143) 337,485 TOTAL FUND BALANCE $ 150,327 $ 227,936 152% ; $ 43,512 $ 64,165 147% ; ; - 0% ($43,512); A 6,657 RV spaces, 51.06% utilization YTD. Prior year comparable was 7,473 RV spaces, 57.32% 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 o� �I ES Co Budget to Actuals Report RV Park Reserve - Fund 619 33.3% FY21 YTD October 31, 2020 (unaudited) Year Complete Fiscal Year 2020 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 12,550 3,801 30% 1,100 3,200 291% < 9,600 873% 8,50& A TOTAL RESOURCES 12,550 3,801 30% 1,100 3,200 291% ; 9,600 873% ; 8,500; REQUIREMENTS Budget Actuais % Budget Actuals % Projection % $ Variance Materials and Services - 6,641 999% - - Capital Outlay t 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% 279,143 45% (342,485) B TOTALTRANSFERS ; 502,000 502,000 100% ; 621,628 310,814 50% 279,143 45% ; (342,485); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 490,000 497,466 102% 497,466 102% t 7,466- Resources over Requirements (87,450) (4,534) a (98,900) 3,200 (90,400) 8,500 Net Transfers - in (Out) 502,000 502,000 621,628 310,814 279,143 (342,485) i TOTAL FUND BALANCE $ 414,550 $ 497,466 120% ; $ 1,012,728 $ 811,480 80% ; $ 686,209 68% ($326,519); A Interest projection based on current investment rate and anticipated cash balances 8 Projected transfer reduced due to actual Beg Working Capital coming In lower than budget, as well as projected revenue tCuuouvits in the RV Fund a� �-�Es`� Budget to Actuals Report Risk Management - Fund 670 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,255,108 1,311,863 105% 1,188,848 407,771 34% 1,188,848 100%, General Liability 1,072,326 1,055,486 98% 990,628 321,067 32% 990,628 100% Property Damage 392,923 395,921 101% 373,698 124,516 33% 373,698 100% Unemployment 323,572 304,607 94% 323,572 260,256 80% 323,572 100% - A Vehicle 195,580 203,005 104% 218,185 74,089 34% 218,185 100% Interest on Investments 137,000 150,197 110% 87,200 46,822 54% 140,500 161% 53,300! 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% 10,000 33% (20,000)! Process Fee- Events/ Parades 2,000 765 38% 1,500 - 0% 500 33% (1,000); E Loss Prevention 30 - 0% 10 0% 10 100% Miscellaneous 500 12,967 999% 5 0% 30,000 999% = 29,995, C TOTALRESOURCES 3,495,039 3,930,523 112% ; 3,263,646 1,246,386 38% 3,325,941 102% ; 62,295: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,460,000 713,047 49% 1,560,000 331,812 21% 1,260,000 81% 300,000: General Liability 1,400,000 311,666 22% 1,100,000 198,016 18% 1,400,000 127% (300,000) D Insurance Administration 592,059 470,972 80% 584,104 102,967 18% 557,316 95% 26,788. E Property Damage 400,236 701,454 175% 200,240 276,074 138% 350,000 175% (149,760p F Unemployment 1303000 63,289 49% 200,000 33,414 17% E 200,000 100% -i Vehicle 150,000 179,835 120% 150,000 48,773 33% 170,000 113% _ (20,000) TOTAL REQUIREMENTS ; 4,132,295 2,440,263 59% ; 3,794,344 991,056 26% 3,937,316 104% ; (1423972); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out - Vehicle Replace (6,918) (6,918) 100% (3,500) (1,166) 33% (3,500) 100% TOTALTRANSFERS (6,918) (6,918) 100% ; (3,500) (1,166) 33% ; (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: r Resources over Requirements (637,256) 1,490,260 (530,698) 255,330 (611,375) (80,677)� Net Transfers - In (Out) (6,918) (6,918) (3,500) (1,166) _ (3,500) TOTAL FUND BALANCE $ 5,455,826 $ 8,676,750 159% ; $ 6,465,802 $ 8,930,914 138% ; $ 8,061,875 125% ; $1,596,073: 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 I ES` Budget to Actuals Report WA Health Benefits - Fund 675 FY21 YTD October 31, 2020 (unaudited) 33.3% Year Complete Fiscal Year2020 Fiscal Year2021 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Internal Premium Charges 17,411,292 17,841,713 102% 17,831,938 6,131,880 34% 17,831,938 100%: - COIC Premiums 1,967,021 1,670,202 85% 1,600,000 393,673 25% 1,574,688 98% (25,312)[ Retiree / COBRA Premiums 1,433,000 1,023,556 _ 71% 1,035,000 186,988 18% 1,020,000 99% (15,000) Employee Co -Pay 1,041,120 1,060,127 102% 1,031,400 373,046 36% 1,119,138 109% 87,73& Interest 346,000 334,654 97% 216,200 94,360 44% 283,100 131% 66,900, A Prescription Rebates 75,000 174,148 232% 90,000 - 0% 90,000 100% Claims Reimbursement & Other 45,000 386,585 859% 80,000 - 0% 80,000 100% - TOTALRESOURCES 22,318,433 22,490,985 101% ; 21,884,538 7,179,947 33% ; 21,998,864 101% ; 114,326: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Health Benefits 20,550,836 18,763,095 91% 19,937,274 4,461,095 22% 18,833,754 94% 1,103,520, B Deschutes On -Site Pharmacy 2,242,104 2,952,787 132% 2,417,092 447,853 19% 2,417,092 100% a B Deschutes On -Site Clinic 1,141,691 1,084,574 95% 1,101,467 243,612 22% 1,101,467 100% t B Wellness 180,380 152,600 85% 164,340 63,470 39% 164,340 100% B TOTAL REQUIREMENTS 24,115,011 22,953,057 95% 23,620,173 5,216,029 22% ; 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) 1,963,918 (517,789) 1,217,846 Net Transfers - In (Out) - - TOTAL FUND BALANCE a I4,309,71V6 c 16, "VI,0J0J0 14J�% W 3,588,094 WIt 18,065,752 133% cW 15,584,0444 115/ : $1 f 995 1 95n' 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 0,1s Budget to Actuals Report 911 - Fund 705 and 710 FY21 YTD October 31, 2020 (unaudited) RESOURCES Property Taxes - Current Yr Telephone User Tax Police RMS User Fees Contract Payments Interest Property Taxes - Prior Yr State Reimbursement User Fee Data Network Reimbursement Property Taxes - Jefferson Co. Miscellaneous TOTALRESOURCES 33.3% Year Complete Fiscal Year 2020 1 Fiscal Year 2021 Budget Actuals % Budget Actuals % Projection % $ Variance 8,809,419 8,876,513 101% 9,113,459 1,301,758 14% 9,155,214 100% 41,75$ A E 900,000 1,053,847 117% 1,106,750 - 0% 1,306,750 118% t 200,000! B i 250,000 386,751 155% 250,000 52,849 21% 250,000 100% - i 51,300 71,929 140% , 157,252 14,250 9% 157,252 100% E 157,000 184,668 118% 90,400 41,903 46% 124,900 138% 34,500! C 100,000 262,105 262% 90,000 77,658 86% 90,000 100% ! 125,000 107,881 86% 83,000 3,000 4% 83,000 100%, - D 73,680 135,243 184% 73,000 2,156 3% 73,000 100%! - ! 55,000 96,232 175% 55,000 - 0% 55,000 100% 30,000 34,547 115% 33,637 742 2% 33,637 100% 11,951 70,966 594% ; 12,200 10,199 84% 12,200 100% 10,563,350 11,280,682 107% ; 11,064,698 1,504,515 14% ; 11,340,953 102% ; 276,255; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 7,462,575 6,980,012 94% 7,620,458 2,393,343 31% 7,287,643 96% 332,815; E Materials and Services 3,387,761 3,072,800 91% 3,476,381 1,045,038 30% _ 3,476,381 100% Capital Outlay 1,400,000 669,792 48% 1,480,000 200,402 14% 1,480,000 100% TOTAL REQUIREMENTS 12,250,336 10,722,604 88% ; 12,576,839 3,638,782 29% ; ; 12,244,024 97% ; 332,815: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 7,753,706 856043816 111% , 8,341 418 9,162,894 110% 9,162,894 110% < 821,476: Resources over Requirements (1,686,986) 558,079 (1,512,141) � ! (2,134,267) (903,071) 609,070; E! i t Net Transfers - In (Out) - � E 4! E E TOTALFUND BALANCE $ 6,066,720 $ 9,162,894 151% ; $ 6,829,277 $ 7,028,627 103% ; ; $ 8,259,823 121% ; $1,430,546: 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% Deschutes County Emergency Business Grants Program The County will provide monies that are received from the State of Oregon (through a State allocation of monies) for the Deschutes County Emergency Business Grant Fund estimated to be $2.23 million. COIC will serve as the overall project manager and fiscal administrator for this program. Eligibility requirements 1) The business was adversely affected in either one of the following two ways: a) Businesses that were prohibited from operation as directed by recent Executive orders 20-12 or 20-65. b) The business can demonstrate a one -month decline in sales of 25% or more, incurred by the Covid-19 pandemic, between March 1, 2020 and November 30, 2020, as compared against the same period of time in 2019. 2) The business is headquartered in Oregon and has its principal operations in Oregon. 3) The business must be located and providing good/services in Deschutes County, Oregon. 4) If required by Oregon law to be registered with the Oregon Secretary of State to do business in Oregon, the business is so registered. 5) The business is either for -profit or an entity tax exempt under section 501(c)(3) of the Internal Revenue Code. The emergency business grants are NOT for: o Businesses that have closed and do not intend to reopen. o Passive real estate holding companies and others holding passive investments. o Non-profit entities that do not have federal 501(c) (3) status. o Businesses that experience a decline in revenues for reasons other than those caused by the Covid-19 pandemic (e.g. seasonal or cyclical business cycles). o Businesses that are delinquent on federal, state, or local taxes that were due on or before the date of application. o Businesses that do not comply with all federal, state, and local laws and regulations. o Businesses not headquartered and with principal operations in Oregon. Page 1 1 of 3 Additional criteria for evaluation Additional criteria for ranking submissions include (in no particular order of importance) Type of business. o hospitality industry, o businesses impacted by the recent freeze: ■ gyms and fitness organizations, ■ indoor recreational activities, ■ museums, ■ zoos, ■ gardens, ■ outdoor entertainment activities (identified in OHA guidance), ■ indoor pools, sports, sports facilities or athletic activities, o urban retail 0 501(c)(3) o Childcare 0 other small businesses, • Businesses majority owned by woman, black, indigenous, people of color, and tribal - owned businesses. • Allocation of monies will be geographically diverse within Deschutes County. • Funds required for keeping viable businesses operational. • Businesses should indicate the extent of any Covid business support funding they have received (such as through the Small Business Administration's Paycheck Protection Program (PPP); Economic Injury Disaster Loan Emergency Advance program (EIDL); or grants or loans from the County). • Gross revenues for the most recent 12 months. • Explanatory statements from business on why they need these funds. Anticipated funding ranges 0-5 employees o $2,500-$7,500, or 6-10 employees o $5,000 - $10,000, or 11-15 employees o $7,500 - $12,500, or 16-20 employees o $10,000 - $15,000, or Page 12 of 3 21- 25 employees o $12,500 - $17,500, or >25 employees o $15,000 - $20,000 The ranges are provided to allow for discretion of the committee based on the strength and number of applications. It is anticipated that not all applications will receive grants. Grant funding could be expanded at the discretion of the committee with sufficient funds. Application process Anticipate keeping application open for will be evaluated and ranked based on application per business. 72 hours (and including a weekend day). Grants information collected or provided. Only one Grant applications will be evaluated through a scoring matrixdeveloped by COIC and Deschutes County. COIC and a Deschutes County committee, including representatives from across the County and a Deschutes County BOCC designee will weigh criteria to stay within requirements of the State and County. The committee can utilize any information collected 'in the application. Applica"tions that are incomplete iplete or I lol I-r espol Isive Lai I be eliminated. Marketing plan. COIC will develop and observe the RFP application rules for establishing and performing a marketing plan which includes: • marketing to historically disadvantaged populations and other business owners; • marketing towards sole proprietorships; • marketing to businesses and non -profits; • marketing in English and Spanish; • marketing across Deschutes County; and • leveraging with other organizations to get the word out. Page 13 of 3