2018-83-Minutes for Meeting January 31,2018 Recorded 3/9/2018Recorded in Deschutes County
Nancy Blankenship, County Clerk
Commissioners' Journal
CJ201 8-83
03/09/2018 4:35:25 PM
1111111111111111111111111111
For Recording Stamp Only
Deschutes County Board of Commissioners
1300 NW Wall St., Bend, OR 97703-1960
(541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org
MINUTES OF WORK SESSION
DESCHUTES COUNTY BOARD OF COMMISSIONERS
Allen Conference Room
Wednesday, January 31, 2018
Present were Commissioners Tammy Baney and Phil Henderson. Commissioner Anthony DeBone was
absent. Also present were Tom Anderson, County Administrator; Erik Kropp, Deputy County
Administrator; David Doyle, County Counsel; Christopher Ogren Administrative Intern; and Sharon Ross,
Board Executive Assistant. A citizen and no representatives of the media were in attendance.
CALL TO ORDER: Acting Chair Henderson opened the meeting at 1:29 p.m.
ACTION ITEMS
1. December 2017 Treasurer's Report and Financial Reports
Wayne Lowry, Finance Director presented the treasurer's report for December. The
portfolio balance is $189 million. The total investment portfolio was reviewed as of
December 31, 2017 as well as the portfolio details. The last investment advisory
meeting was held on January 18, 2018. Two vacancies have been posted for
membership on the Investment Advisory Committee. There are 62.25 staff vacancies
within the County departments. Mr. Lowry reported on property tax collections. Mr.
Lowry reviewed the schedule of financial operating data. Discussion held on costs
Minutes of Board of Commissioners' Work Session January 31, 2018 Page 1 of 5
associated with providing service in departments which will be included in budget
hearings.
2. MUNIS Project Update and Budget Adjustment Request
Mr. Lowry reported on the recent upgrades with software systems that began in March
2016 with the Tyler Technologies implementation of financials. Phase 2 of the software
updates began in January 2017 with the goal of migrating to NOVAtime for electronic
timekeeping. Currently the departments are submitting paper time sheets along with
the electronic timekeeping. The go -live date may be January 2019. Mr. Lowry noted
the continued discussions and challenges of moving the pay periods to bi-weekly.
Commissioner Henderson inquired why we would be looking at bi-weekly time periods
vs. monthly if it causes more money to the County and there is so much opposition.
Currently staff have to project the last week of the month for pay instead of actual
hours worked. Mr. Lowry explained there is only one payroll person for the entire
County and asked for consideration of adding another staff person. There is a
temporary staff person that had retired from the County last year but stayed on to help
with the MUNIS project through the month of April to assist with the payroll duties. The
Board is in favor of the request. This item will be included on a future Consent Agenda
at a Business Meeting.
OTHER ITEMS
• Land Donation Request
James Lewis, Project Management Specialist along with La Pine City Manager Cory
Misley and Ryan Culp of Sunriver La Pine Economic Development Board presented the
request from the City of La Pine for a land donation from the Deschutes County to
incentivize new business development. Mr. Culp reviewed the needs in the community
regarding new business start-up opportunities showing business preferences of leasing.
The land request is for a .58 acre in the industrial zoned lot in the Newberry Business
Park. Mr. Lewis reviewed the property donation process. Mr. Culp reviewed a chart
showing the industrial building incentivized least costs relative to predictions for that
parcel. The City of La Pine would serve as the land lord to the tenant. Commissioner
Henderson inquired on marijuana industries and if the City of La Pine would have the
option to not let this be another marijuana business. There are marijuana businesses
occupying the previously vacant commercial buildings. Discussion held on
Minutes of Board of Commissioners' Work Session January 31, 2018 Page 2 of 5
diversification needs for the industrial park and the hope for different business
opportunities. Commissioner Henderson is interested in trade sector businesses and
would like that type of opportunity if gifting land. The City would stress they are not
actively pursuing marijuana businesses in the city. Suggestion for a contingency the land
would not be used for the processing or production of marijuana. The Board is
supportive of the concept. County Administrator Anderson commented on the property
tax and leasing of the future development. The lease with the City would be for the
whole development and then the developer would sublease. Mr. Lewis explained a
deed would then come before the Board at a Business Meeting next week. Mr. Lewis
will review the concept of restrictions for lease of a marijuana business.
EXECUTIVE SESSION
At the time of 3:12 p.m., the Board went into Executive Session under ORS 192.660 (2) (e) Real
Property Negotiations. The Board came out of Executive Session at 3:21 p.m.
RECESS: A short break was taken at 3:22 p.m. and the meeting was reconvened at 3:27 pm.
OTHER ITEMS Continued:
• Radio System Update:
Steve Reinke, 9-1-1 Operations Director reported on a call received from the Bulletin
regarding the 911 radio system and public records request. Mr. Reinke reviewed the
history of the project. The major acceptance testing led us to believe there was enough
coverage to go live. Mr. Reinke noted the trouble tickets received were maintenance
tickets for equipment. The number one priority now is to install a temporary site in the
area that is experiencing coverage challenges.
Commissioner Henderson has requested County Counsel to review the contract with
Harris. Mr. Reinke has begun work with an engineering firm to be our agent to review
siting, performance, and processes. This includes a manager to run the technical
services side of the contract. Commissioner Baney inquired if the User Board are also
reviewing the choices of the professional services and technical expertise coming on to
ensure the strength of the partnership. County Counsel is reviewing the contract and
Minutes of Board of Commissioners' Work Session January 31, 2018 Page 3 of 5
also notes there may be technical failures as wefl. County Counsel notes we are still in
the warranty stage but there may also be issues with radio transmissions.
Commissioner Henderson noted Harris was also the one that recommended where the
tower sites were and should be responsible for the possible failure in any radio
transmissions. Work is being done to solve the trouble spots with radio transmissions.
Commissioner Baney inquired if we would have gone a different route did the other
options presented have any issues with operations elsewhere and asked Mr. Reinke to
review the operations in other counties. Our old system was at end of Iife and the need
for the new system was time sensitive.
The engineer' b description 15 being drafted for a full time staff person and is
warranted giventhe[bunh/ssize. This position wiIJ be due to a redistribution of FTE no
additional FTE but will be an additional cost, Commissioner Henderson feels that solving
the problem wifl be worth the money required. Mr. Reinke is hoping the recruitment
for the position could be posted within the week.
Harris Corporation will continue to go through the punch Iist. Commissioner Baney
requested formal check in points and daily briefings. Commissioner Henderson would
Jike to see an action ptan from Harris Corporation. Commissioner Baney suggested
communicating to Harris Corporation that the Operations Director was directed there
will be formal meeting with the governing body should this not be resolved by February
28. Commissioner Henderson also expects they provide a written action plan and
answer a Iist of questions. Commissioner Henderson suggests the communication to
Harris is to stress the issues be resolved and they need to meet with the Board on
February 28.
Commissioner Henderson commented on the Retreat held yesterday and giventhe
reporter's Twitter feed and the story in today's Bulletin he feels if conversations are
scrutinized he would prefer there are full day work sessions instead of retreats. He also
wished those staff in the room would have informed the Board of the Twitter feeds.
Commissioner Henderson feels it is hard to have conversations to share information
with the Board and if there may be a complete ban on discussions he was actually just
trying to Iearn more about what the Board needs to know. Commissioner Baney
commented she values Commissioner Henderson's background and feels the Board
should build on the communications they have. County Administrator Anderson
suggested a standing item on every work session agenda for discussions.
Commissioner Baney feels communications need to be a part of the team effort of the
Board.
Minutes of Board of Commissioners' Work Session January 31, 2018 Page 4 of 5
• Erik Kropp, Deputy County Administrator brought up a request to use the clubhouse for
a temporary shelter. The clubhouse is currently leased by Cascade Peer Support Group
and Sagewood is requesting to use the space for cold weather shelter. Commissioner
Henderson requested to tour the building. Commissioner Baney requested Mr. Kropp
find information from the City of Bend for the last five years of declaration of
emergency shelters. Commissioner Baney also requested to find the opinion of
Cascade Peer Support to see if they would be in favor.
ADJOURN: Being no further discussion, the meeting adjourned at 5:05 p.m.
DATED this Day of I-°
Board of Commissioners.
ATTEST:
R=cording Secretary
2018 for the Deschutes County
av),27)\--
Anthony DeBone, Chair
Philip G. He
derson, Vice Chair
Tammy Baney, Com'msioner
Minutes of Board of Commissioners' Work Session January 31, 2018 Page 5 of 5
Deschutes County Board of Commissioners
1300 NW Wall St, Bend, OR 97703
(541) 388-6570 — Fax (541) 385-3202 — https://www.deschutes.org/
WORK SESSION AGENDA
DESCHUTES COUNTY BOARD OF COMMISSIONERS,
1:30 PM, WEDNESDAY, JANUARY 31, 2018
Allen Conference Room - Deschutes Services Building, 2ND Floor — 1300 NW Wall Street — Bend
Pursuant to ORS 192.640, this agenda includes a list of the principal subjects anticipated to be addressed at the
meeting. This notice does not limit the ability of the Board to address additional subjects. Meetings are subject to
cancellation without notice. This meeting is open to the public and interested citizens are invited to attend.
Work Sessions allow the Board to discuss items in a less formal setting. Citizen comment is not allowed,
although it may be permitted at the Board's discretion. If allowed, citizen comments regarding matters that are or
have been the subject of a public hearing process will NOT be included in the official record of that hearing. Work
Sessions are not normally video or audio recorded, but written minutes are taken for the record.
CALL TO ORDER
ACTION ITEMS
1. December 2017 Treasurer's Report and Financial Reports - Wayne Lowry, Finance
Director/Treasurer
2. MUNIS Project Update and Budget Adjustment Request - Wayne Lowry, Finance
Director/Treasurer
EXECUTIVE SESSION
3. Executive Session under ORS 192.660 (2) (e) Real Property Negotiations
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.
Board of Commissioners Work Session Agenda
Wednesday, January 31, 2018 Page 1 of 2
OTHER ITEMS
These can be any items not included on the agenda that the Commissioners wish to discuss as part of
the meeting, pursuant to ORS 192.640.
ADJOURN
®®Deschutes County encourages persons with disabilities to participate in all programs and
® activities. To request this information in an alternate format please call (541) 617-4747.
FUTURE MEETINGS:
Additional meeting dates available at www.deschutes.oraimeetinacalendar
(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 Work Session Agenda Wednesday, January 31, 2018 Page 2 of 2
Work Session
(Please Print)
0)
E
to
z
Please return to BOCC Secretary.
TE
-< Deschutes County Board of Commissioners
1300 NW Wall St, Bend, OR 97703
(541) 388-6570 — Fax (541) 385-3202 — https://www.deschutes.org/
AGENDA REQUEST & STAFF REPORT
For Board of Commissioners Work Session of January 31, 2018
DATE: January 22, 2018
FROM: Wayne Lowry, Finance, 541-388-6559
TITLE OF AGENDA ITEM:
December 2017 Treasurer's Report and Financial Reports
RECOMMENDATION & ACTION REQUESTED:
Discussion of December 2017 Treasurer's Report and Selected Financial Reports
ATTENDANCE: Wayne Lowry, Finance Director/Treasurer
SUMMARY: Monthly Report
eschutes ount
201
otal Inv- meat 'orf olio s •
Investment Income
Investments By County Function
$ 189,145,135
0
CA 1- N
et O et
4-- A
cci a5
N 111
1 O
1
N 44.
N
�—
OO N t0 0)
cD CO_ PN O C C
N = C(0
V • 4.-
12 a
� C
u)
co
60) E
.- 0
U
Cfl y C
O (A
O a)
C
C
• p
E�
y 0
>
c u.
N
)-- J
Total Investments
Investment Income - Net
0
0 0 0 0 0 G
O NInv:is: O
O
Cl M CO
O O 0) O O N H
00et000A M
O O CD O O d' e-
0) 10 et O O Cn et
O MNOe-0)
N a0
O M CD 10 CO
tib
49
Total Investments
e-
0 0
Prior Year Comparison
Total Portfolio: By investment Types
O O O O O O O
O O Iii to O C4 10
O O ►� C4 tf) N N
r r
d
Q c O
U p z N
Term Minimums
o
0.
3
N
C
y N d
u_ Q M
Under 5 Years
Deschutes County Investments
Portfolio Management
Portfolio Details - Investments
December 31, 2017
Purchase Maturity Days To Ratings Coupon Par Market Book Call
CUSIP Security Broker Date Date Maturity SSP Moody's Rate YTM 365 Value Value Value Date
740189AK1 Precision Castparts Corp CASTLE 12/13/2016 1/15/2018 14 AA- A2 1.250 1 318 1,250,000 1,249,638 1.249,967
949748FG0 Wells Fargo Corporate Note CASTLE 12/9/2016 1/16/2018 15 A A2 1 500 1.601 2,000,000 1,999,780 1,999,917
94988.15,01 ,Wells Fargo Corporate Note CASTLE 1/29/2016 1/22/2018 21 • Aa2 1.650 1.580 1,000,000 999,800 1,000,040
92976WBH8 Wachovia Corp CASTLE 2/26/2016 211/2018 31 A A2 5.750 1.690 1,000,000 1,003,100 1,003,314
31771EAL5 FICO Strip CASTLE 2/24/2015 2/8/2018 38 1.252 1 318 1,260,000 1.258,072 1,258,334
31771EAL5 FICO Strip CASTLE 2/25/2015 2/8/2018 38 1.257 1.323 740.000 738,888 739,018
3134G8M71 Federal Home Loan Mtg Corp :CASTLE 2/26/2016 2/261120113 56 AA+ 1.050 1 050 3,000000 2,998,590 3,000,000
89114QSN9 Toronto Dominion Bank CASTLE 12/18/2017 3/31/2018 89 AA- Aa2 1.500 1.801 5,000,000 4,988,550 5,000,000
68607VA96 Oregon State Lottery DA DAV 6/13/2016 4/112018 90M AM2 1.353 0970 200.000 199,376 200,189
68607VA96 Oregon State Lottery DA DAV 11/2'1/2017 4/1/2018 90 AAA M2 1.353 1.500, 250,000 249,220 249,906
842434CO2 Southern CA Gas Co CASTLE 4/10/2017 4/15/2018 104,A+ Aa2 5.450 1 473 1,000,000 1,010,310 1,011,360
912828XA3 U S. Treasury PJ 1113012016 5/15/2018 134 AA+ Asa 1,000 1 000 2,000,000 1,997,180 2,000,000
9133661152 University of California _CASTLE 3121/2017 5/15/2018 134 M- Aa3 0,936 1 351 3,000,000 2.988,870 2,995,417 • •
3135GOXDO Federal National Mtg Assn CASTLE 1/4/2017 5121/2018 140 M+ Aea 1.000 1 250 500,000 498,925 500,000 2/21/2018
3130,08753 Federal Home Loan Bank VINISP 12/6/2016 5/30/2.018 149 M+ Aaa 1.000 1 141 1,500,000 1496,580 1500.000 • -
06050TMC3 Bank of America - Corporate N CASTLE 519/2017 615/2018 155'A+ Al 1,750 1 540 1,000,000 999,570 1,000.886 - -
3132XOLR0 Federal Agriculture Mtg Corp PJ 12/8/2016 6/8/2018 1.58 1.100 1 100. 2,000,000 1,996,860 2,000,000 - -
98385XAP1 XTO Energy Inc CASTLE 814/2015 6/15/2018 165'MA 'Aaa 5.500 1.500 1,000,000 1,016,620 1,017,768 - -
904121NC0 Umatilla School District PJ 5/7/2015 6/15/201$ 165,AAL 1 430 1.430 750,000' 747,983 750,000 - -
10592 Washington Federal CD 5/22/2017 6/22/2018 172 0 900 0.913 243,643 243,643 243,643 - -
168764A50 Chevron Corp CASTLE 4/1512016 6/24/20181
174 1/1/- Aa2 1,718 1.191 2,000,000 2,000,000, 2.004.982 5/24/2018
/687641/E0 Chevron Corp CASTLE 10/11/2016 6/24/2018, 174 M- Aa2 1.718 1.259 1,000.000 1.000.000 1,001,889 - -
939307HF4 Hillsboro SD Pension Bonds PJ 3/30/2015 6130/2018 160 Aa3 1.732 1 650 885,000 984,311 985,387 938429M46 Washington County SD Municipal PJ 9/6/2016 6/30/2018 180 Aa3 1 585 0.999 250,000 249,758 250,718 - -
84247PHT1J Southern CA Public Power Autho CASTLE 12/19/2017 7/1/2018 181 AA- 1.728 1,779 2,510,000 2,508,695 2,509,365 • -
3135GOL43 Federal National Mlg Assn CASTLE 12/13/20161 7/13/2018 193 Mr Asa 0.850 1.221 1,000,000 995,860 1,000,000 1/13/2018
88059EMT8 Tennessee Valley Authority ,DADAV 2/22/2016 7/15/2018 195', 1 021 1 065 500,000 494,895 497,234 - -
3133EGNU5 Federal Famt Credlt Bank CASTLE 8/1/2016 7/27/2018 207 AA+ Aaa 0.960 0960 1,000,000 995,960 1,000,000 • -
313459067 Federal Hlome Loan Mtg Corp CASTLE 7127)2016 7/27/2018 207 AA+ Aaa 1 050 1.050 3,000000, 2,989,770 3,000.000 1/27/2018
934876A50 Port of Newport OR Lease DA DAV 3/27/2017 8/1/2018 212 M 4.500 1450 610.000 618,815 620,703 - -
842400FJ7 Southern Cal Edison CASTLE 5/26/2017 8/15/2018, 226 A Aa3 5.500 1 520, 2,000,000 2,044,200 2,048,862 • -
65371AU2 Oceanside California Pension CASTLE 1/27/2017 8/15/2018 226 AA 2.298 1.551 1,850,000 1,855 495 1,858,466 -
544351KM0 Los Angeles Calif Go Ref Bds PJ 12/21/2016 9/1/2018 243, M2 1 210 1.209 1,000,000 995,730 1,000,000 - -
3134GAKF0 Federal Home Loan Mtg Corp CASTLE 10/18/2016 9/12/2018 254 AA+ Aaa 1 110 1 110 3,000,000 2,988,840 3,000,000 3/12/2018
3134G8UN7 Federal Home Loan Mtg Corp CASTLE 3/30/2016 9/28/2018 270 M+ Aaa 1 200 1 200 2,000,000 1,991,040 2,000,000 3/28/2018
3134G9YA9 Federal Home Loan Mtg Corp CASTLE 6128/2016 972.812018_ 270M+ Aaa 1.010 1.000 2,520,000 2,507,198 2,520,000 3/28/2018
3134GAND3 Federal Home Loan Mtg Corp CASTLE 9/28/2016 9728/2018 270 M+ Aaa 1050 1.050 4.000,000, 3,979.320 4000,000 - -
3133EFJP3 Federal Farm Credit Bank CASTLE 11/4/2016 10/15/2018 287 M+ 'Aaa 1 100 1 100 5,000,000 4,972,8501 5,000,000 - -
3136G2PZ4 Federal National Mtg Assn CASTLE 5/22/2017 10/29/2018 301 AM Aaa 1 190 1 340 5,000,000 4,975,450 5,000,000 1129/2018
912$28W08 U.S. Treasury CASTLE 1211/2015 10/31/2018 303 AAA Aaa 1.250, 1 223 1,000,000 996,020 1,000,222 • -
912828T83 U.S. Treasury CASTLE 12/14/2016 10/31/2018 303 AAA Aaa 0 750 1 155 3,000000 2.975,280 2,990,062 - -
31771KAJ6 FICO Strip CASTLE 9/28/2017 11/2/2018 305 1.469, 1 520 5,000,000 4,922,900 4.938,150
427542KX2 Hermiston OR DA DAV 9/21/2016 1211/2018 334 AA- 3.000 1.001 605,000 612.496 615,940
06050TME9 Bank of America - Corporate CASTLE 5/16/2017 12/7/2018 340 A+ Al 2.050 1 700 3,180.000 3,179,078 3,190,190
31771EAN1 FICO Strip CASTLE 11/3/2016 12/27/2018 360 0984 1025 1,000,000 981.750 990,160
912828A75 U S Treasury CASTLE 6/8/2015, 12/31/2018 364 AAA Aaa 1 500 1 324 1,000,000 996.840 1.001.704
3132XONJ6 Federal Agriculture Mtg Corp CASTLE 5/1/2017 1/23/2019 387 1.270 1 400 3,000.000 2,985,930 2,995,910
20271RAF7 Commonwealth DK Austr NY CASTLE 9/1812017 3/13/2019 436 M- Aa3 2 250 1.720 2,600,000 2,601,664 2,616,250
68607VS71 Oregon State Lottery CASTLE 4/5/2017, 4/1/2019 455 Aa2 1 602 1 581 1,000,000 987,290 1,000,264
-459058FC2 International Bonds for Recons CASTLE 12/15/2016 4/26/2019 480 AAA Aaa 1.250 1 500 2,000,000 1,982,240 2,000,000 - -
90331HMY6 US Bancorp CASTLE 12/22/2017 4/26/2019 480 M- Al 1.400 2000 1,000,000 992,170 992,217 3/26/2019
90520EAF8 MUFG Union Bank CASTLE 12/6/2017 5/6/2019 490 A A2 2.250 2.185 1,352,000 1,350,269 1,353,153 4/6/2010
064061'tBMO Bank of New York Mellon Corp CASTLE 11/15/2017 5/15/2019 499 A Al 5450 1 950 1,000,000 1,044,100 1,047,104 • -
250351FJ7 Deschutes County Ore Sch Dist PJ 8/16/2016 6/15/2019 530 AA1 1 360 1 360 245,000 241,609 245,000 - -
938429966 Washington County SD Municipal PJ 5/11/2017 6/15/2019 530 M+ Aa1 1.488 1 488 400,000 396,940 400,000 - -
3137EAB1 Federal Home Loan Mtg Corp CASTLE 7/20/2016 7/19/2019 564 AA+ Aaa 0.875 0.957 1,000,000 984,360 998,749 - -
13034PZD2 CALIFORNIA ST HOUSING FINAN,CAST LE 11/2/2017 8/1/2019 577 AA- Al 1 952 1 850 1,070,000 1,067.229 1,071,677 - -
3135G0N33 Federal National Mtg Assn CASTLE 8/18/2016 8/2/2019 578 AA. Aaa 0.875 1 000_ 1.000,000 983.970 998,047 • •
0640t11-1CW7 Bank of New York Melton Corp CASTLE 11/3/2016 9/1112019 618 A Al 2 300 1 537 1.675,000, 1,679,372 1,695,793 8/11/2019
48125LRJ3 JPMorgan Chase - Corporate N CASTLE 4/10/2017 9/23/2019 630 A+ Aa3 2.264 1.866 3,000,000 3,021.150 3,015,415 8/23/2019
48125LRG9 JPMorgan Chase - Corporate N CASTLE 6/2812017 9/23/2019 630 A+ Aa3 1.650 1.840 1,300,000 1,289,028 1,295,869 8/23/2019
313586RC5 Federal Nalronal MIg Assn CASTLE 12/412015, 10/9/2019 646 AA- 1 891 2.031 1.400,000 1,348,340 1,352495 • -
313586RC5 Federal National Mtg Assn CASTLE 3/17/2016 10/9/2019 646 AA- 1.665 1.774, 600,000 577,860 582.074 • -
313586RC5 Federal National Mtg Assn CASTLE 8/8/2016 10/9/2019 646 AA- 1 252 1 318 400,000 385,240 391.013 - -
313586RC5 Federal National Mtg Assn _CASTLE 11/22/2017, 10/9/2019_ 646 AA- 1 928 2.030 3,600,000_ 3,467,160 3,475,448 - -
76116FAA5 RFSCP STRIP PRIN CASTLE 9121/2017 10/15/2019_ 652 1.499 1 572 1,000,000 965,540 972,856- - -
313500R39 Federal National Mtg Assn CASTLE 11/10/2016 10/24/2019 661 AA+ Aaa 1 000 1.173, 2,000,000 1,967,380, 1,993,863 - -
912828F62 U S Treasury CASTLE 10/11/2016 10/31/2019 668 AAA Aaa 1 500 1.008 2,000.000 1,986.260 2,017,692, - -
'9612145118 Westpac CASTLE 8/30/2017 11/19/2019 6137 M- Aa3 4875 1826 2,000,000 2,096,6201 2,112,010 - -
5949181/60 Microsoft Corp CASTLE 8/8/2016 2/1212020_ 772.AAA _Aaa 1 850 1 298 1,000,0001 996.130 1,011,379 1/12/2020
13063CSQ4 California SI VINISP 9/21/2017 4/1/2020 821,M AA- Aa3 1800 1800 780,000' 774,392, 780,000 - •
3134GBNK4 Federal Home Loan Mtg Corp CASTLE _ 7/13/2017 5/29/2020 879 Aaa 1 625 1.671' 3,000,0001 2,971,560 2,997,069 5/29/2019
688053CK3 Oregon School Boards Assoc CASTLE 3/15/2017 6/30/2.020 911 AA- Aa2 2 063 2149 1.000,000, 939,260. 948,521. - -
569203MA7 Salem•Keizer School District CASTLE 7/26/2017 6/30/2020 911 iAa2 2 107 1 778. 2,310,000 2.298,658 2,328,284 - -
6860530H19 Oregon School Boards Assoc DA DAV 1112/2015 8/30/2020 911 M Aa2 5 373 2 050 875,000 939,068 943,898 - -
5860530119 Oregon School Boards Assoc CASTLE 6124/2016 6/301202.0 911 AA Aa2 5 373 1.570 500,000 536,610 545,842 - -
949746GM6 Wells Fargo Corporato Note PJ 1/19/2017 7/2272020 933 A A2 2 600 2.350 1,000,000 1,006,160 1,006.104 - -
940093925 Washington Linty Higher Ed PJ 1/19/2017 10/1/2020 1004 Aa2 5.930 1 970 400.000 438,444 441,800, - -
4922440V7 Kam Community College CASTLE 11/15/2018 11/1/2020 1035 AA- 2.893 1 800 500,000 507,875 514,878 • -
3134GBX56 Federal Home Loan Mtg Corp CASTLE 12/13/2017 11/24/2020 1058 M+ Aaa 2 250 2172 3,000,000 3,005,160 3,005,862 5/24/2018
31340$JH3 Federal Home Loan Mtg Corp CASTLE 12/27/2017 2)17/2021 1143 AA+ Aaa 1 000 2.547 2,000,000 1,997,820 1,998,694 2/17/2018
3136G4NN9 Federal National Mtg Assn CASTLE 1 10/18/2017, 5/24/2021 17.39 AA+ Aaa 2.000 2.000 1.080.000 1.071,878 1.080,000 2/24/2018
Local Govt Investment Pool 1.700 1 700 48.508,637 48,508,637 48,508,637 • -
Bank of the Cascades 1 700 1.700 5,845,856 5,845056 5,845,856 • •
Totals 189.145.135 188.733,311 189,323.513
Revenues
Property Taxes - Current
Property Taxes - Prior
Other General Revenues
Assessor
County Clerk
BOPTA
District Attorney
Tax Office
Veterans
Property Management
Total Revenues
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Medical Examiner
Tax Office
Veterans
Property Management
Non -Departmental
Total Expenditures
Transfers Out
Total Exp & Transfers
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
GENERAL FUND
Schedule of Financial Operating Data
FY 2017
Actual
$ 25,816,331
465,085
2,499,968
860,861
1,952,209
12,546
253,480
196,203
96,889
94,500
32,248,072
Year to Date July 1,
2017 through
December 31, 2017
(50% of the year)
Actual I of
Budget
24,807,389
331,923
2,198,724
472,582
857,397
7,139
14,330
120,777
40,556
8,500
28,859,317
3,993,958 2,068,976
1,684,783 630,487
65,175 33,624
6,095,393 3,113,166
146,817 51,722
785,346 406,611
403,775 214,296
247,568 126,717
1,268,363 525,255
14,691,178 7,170,853
17,856,310 8,578,632
32, 547,489 15,749,485.04
(299,416) 13,109,832
11,217,374 10,917,957 109%
$10,917,957 $ 24,027,790
94%
95%
94%
56%
45%
57%
8%
62%
25%
9%
89%
48%
35%
49%
46%
30%
48%
44%
46%
40%
45%
49%
47%
Budget
a) $ 26,296,000
350,000
b) 2,345,822
c) 848,867
1,896,945
c) 12,480
187,400
c) 196,200
162,223
97,000
32,392,937
4,291,041
d) 1,820,344
68,138
d) 6,701,724
172,184
849,312
492,630
276,097
1,328,089
15,999,559
17,445,890
33,445,449
(1,052,512)
10,000,000
$ 8,947,488
a) Historically, 92% of the current year taxes are received by the end of Dece
b) Includes $500,000 PILT. HB 3400 not incuded in budget. $365,655 receiv
Projected is YTD actual plus two more quarters at $76,991.
c) A & T Grant received quarterly. Q1 received July; Q2 received October
d) Projected to be less than budgeted due to YTD unfilled positions.
mbar.
FY 2018
Projected Variance
26,600,000 304,000
350,000
2,942,451 596,629
848,867
1,896,945
12,480
187,400
196,200
162,223
97,000
33,293,566 900,629
4,291,041
1,795,344
68,138
6,601,724
172,184
849,312
492,630
276,097
1,328,089
15,874,559
17,445,890
33,320,449
(26,883)
10,917,957
$ 10,891,074
25,000
100,000
125,000
125,000
1,025,629
917,957
$1,943,586
ed in October and $76,991 in December
Page 1
COMM JUSTICE -JUVENILE
Schedule of Financial Operating Data
FY 2017
Year to Date July 1,
2017 through
December 31, 2017
(50% of the year)
% of
Actual Actual Budget Budget
FY 2018
Projected I Variance
Revenues
OYA Basic & Diversion $ 355,586 $ 107,384 31% a) $ 346,046 $ 407,113 $ 61,067
ODE Juvenile Crime Prev 86,497 21,137 29% a) 71,982 91,379 19,397
Leases 84,121 43,096 51% b) 85,000 77,000 (8,000)
Inmate/Prisoner Housing 74,700 31,950 58% c) 55,000 60,000 5,000
DOC Unif Crime Fee/HB2712 36,045 17,747 48% 36,658 36,658
Food Subsidy 18,744 9,359 47% 20,000 20,000
Gen Fund -Crime Prevention 20,000 5,000 25% d) 20,000 20,000
Interest on Investments 17,512 9,588 64% 15,000 18,000 3,000
OJD Court Fac/Sec SB 1065 18,438 9,637 57% c) 17,000 21,600 4,600
Contract Payments 10,920 2,864 36% 8,000 8,000
Case Supervision Fee 5,964 3,278 55% c) 6,000 7,000 1,000
Miscellaneous 3,170 2,168 117% g) 1,850 3,000 1,150
Total Revenues 731,697 263,207 39% 682,536 769,750 87,214
Expenditures
Personnel Services 5,005,247 2,557,005 48% e) 5,313,863 5,100,000 213,863
Materials and Services 1,204,317 569,900 48% 1,198,996 1,198,996 -
Transfers Out-Veh Reserve 44,000 34,500 50% f) 69,000 69,000
Total Expenditures 6,253,564 3,161,405 48% 6,581,859 6,367,996 213,863
Revenues less Expenditures (5,521,867) (2,898,197) (5,899,323) (5,598,246) 301,077
Transfers In -General Fund 5,464,591 2,798,822 50% 5,597,643 5,597,643
Change in Fund Balance (57,276) (99,376) (301,680) (603) 301,077
Beginning Fund Balance 1,415,374 1,358,098 113% 1,200,000 1,358,098 158,098
Ending Fund Balance $ 1,358,098 $ 1,258,722 $ 898,320 $ 1,357,495 $ 459,175
a) Reimbursement payment received quarterly. 1st quarter received/requested. Grant was increased by
legislature subsequent to budget adoption
b) Less than budgeted lease revenue due to Rimrock Trails locating their outpatient office elsewhere.
c) Inmate housing trending at greater than budgeted
d) Internal grant funded quarterly
e) Projection decreased due to staff vacancies in Q1 and new hires who started at a lower salary
step range in beginning of fiscal year
f) Transfer to Reserve includes $25,000 to cover estimated costs of vehicle repair and maintenance.
g) Projection increased due to additional actual revenue received related to community service projects, vehicle auction, etc.
Page 2
Sheriff's Office and LEDs
Schedule of Financial Operating Data
FY 2017
Actual
Year to Date July 1,
2017 through
December 31, 2017
(50% of the year)
% of
Actual I Budget
FY 2018
Budget I Projected Variance
REVENUES
LED #1 Countywide
Property Taxes
Current Year $21,137,803 $20,791,087 94% a) $22,045,228 $22,350,000 $ 304,772
Prior Year 308,837 238,462 60% 400,000 400,000 -
Interest 110,368 55,601 70% 80,000 100,000 20,000
Total LED#1 Countywide 21,557,009 21,085,150 94% 22,525,228 22,850,000 324,772
LED #2 Rural
Property Taxes
Current Year 9,474,144 9,313,307 94% a) 9,916,642 10,014,000 97,358
Prior Year 141,704 108,092 58% 185,000 185,000
Interest 90,261 47,236 77% 61,300 90,000 28,700
Total LED #2 Rural 9,706,109 9,468,635 93% 10,162,942 10,289,000 126,058
Sheriff's Office Revenues 8,249,855 3,383,075 46% e) f) 7,386,585 7,444,585 58,000
Total Revenues 39,512,973 33,936,859 85% 40,074,755 40,563,585 508,830
EXPENDITURES
Sheriffs Services 2,386,420 1,358,713 51% b) 2,639,355 2,750,737 (111,382)
Civil/Special Units 1,117,489 723,764 52% b) 1,402,554 1,303,939 98,615
Automotive/Communications 2,601,537 969,705 39% 2,481,701 2,481,701
Detective 1,796,143 963,735 48% 1,995,351 1,995,351
Patrol 8,822,794 4,642,835 48% h) 9,724,673 9,715,876 8,797
Records 695,956 328,854 43% d) 761,258 806,258 (45,000)
Adult Jail 16,236,326 8,315,513 48% i) 17,488,887 17,609,682 (120,795)
Court Security 270,173 236,231 58% c) 410,659 392,161 18,498
Emergency Services 284,009 177,327 47% e) 379,092 387,092 (8,000)
Special Services 1,500,791 847,693 55% f) 1,543,848 1,611,348 (67,500)
Training 590,962 384,125 59% g) 654,646 667,246 (12,600)
Other Law Enforcement Services 904,547 414,180 44% c) 935,144 928,544 6,600
Crisis Stabilization Center - 26,412 5% 558,424 558,424
Non -Departmental 112,846 1,038 50% 2,077 2,077
Total Expenditures 37,319,993 19,390,126 47% j) 40,977,669 41,210,436 (232,767)
Revenues less Expenditures
Beginning Balance
Ending Balance
2,192,980 14,546,733 (902,914) (626,851) 276,063
11,225,692 13,418,672 121% 11,113,000 13,418,672 2,305,672
$13,418,672 $27,965,405 $10,210,086 $12,791,821 $2,581,735
a) Historically, 92% of the current year taxes are received by the end of December.
b) $25,000 contribution to suicide/substance abuse hotline. Open Civil Tech position in
Civil/Special Units division reclassified as HR Analyst in Sheriff Services division
c) Unfilled FTE. Overtime is expected to exceed budget.
d) Open Records Admin Supervisor position will be converted to a Sergeant position.
e) Projection includes $8,000 reimbursement for Solar Eclipse expenditures.
f) Grant of $50,000 for purchase of $67,500 boat.
g) Projection increased due to an unbudgeted rifle purchase.
h) Projection includes unfilled FTE, increase in overtime, increased expenditures related to new K-9,
and cost savings on web licensing. Anticipated overtime makes up 56% of adjusted projection expenditures.
i) Projection includes unfilled FTE, increase in overtime, increase in medical expenses for one inmate,
and increase in miscellaneous M&S expenditures. Temp medical director cost increased due to unfilled position.
Page 3
Revenues
State Grants
OHP Capitation
Administrative Fee
Environmental Health Fees
State - OMAP
Federal Grants
Patient Fees
Local Grants
Local Government payments
Title 19
State Shared -Family Planning
State Miscellaneous
Liquor Revenue
Divorce Filing Fees
Interfund Contract -Gen Fund
Vital Records
interest on Investments
Other
Total Revenues
Expenditures
Personnel Services
Materials and Services
Capital Outlay
Transfers Out
Total Expenditures
HEALTH SERVICES
Schedule of Financial Operating Data
FY 2017
Actual
$ 13,186,170
9,950,347
1,143,411
909,870
938,760
574,848
335,616
1,846,627
510,428
602,998
166,903
206,999
156,399
157,603
127,000
260,545
99,844
386,400
31,560,767
24,133,045
10,989,018
135,653
445,740
35,703,456
Revenues less Expenditures (4,142,689)
Transfers In -General Fund 4,684,193
Change in Fund Balance 541,504
Beginning Fund Balance 7,688,209
Ending Fund Balance $ 8,229,714
Year to Date July 1, 2017
through December 31,
2017 (50% of the year)
% of
Actual I Budget
$ 6,584,618
4,194,800
646,800
382,616
549,393
108,245
247,468
324,059
606,547
67,452
182,335
61,008
131,745
86,505
50,352
254,179
14,478,122
13,556,749
4,695,668
35,799
245,160
18,533,376
43%
38%
50%
40%
53%
17%
68%
34%
N/A
201%
34%
20%
40%
84%
0%
44%
35%
62%
42%
Budget
a) e) $ 15,419,737
b) 11,044,000
1,293,910
964,397
1,037, 735
650,866
364,370
957,457
c) 302,170
200,000
e) 934,753
151,000
157,603
127,000
198,000
145,000
413,083
34,361,081
47% d)
36%
4%
50%
43%
28,840,478
13,219,633
1,020,000
490,320
43,570,431
(4,055,254) (9,209,350)
2,292,096 50%
(1,763,157)
8,229,714 98%
$ 6,466,556
FY 2018
Projected Variance
$ 16,835,653
8,834,900
1,293,910
965,296
1,052,683
543,494
487,345
954,401
4,584,193
(4,625,157)
8,434,473
$ 3,809,316 $
$ 1,415,916
(2,209,100)
899
14,948
(107,372)
122,975
(3,056)
1,204,000 901,830
200,000
770,287 (164,466)
151,000 -
131,745 (25,858)
127,000 -
181,600 (16,400)
99,800 (45,200)
431,084 18,001
34,264,198 (96,883)
28,416,917 423,561
13,275,560 (55,927)
1,170,000 (150,000)
490,320
43,352,797 217,634
(9,088,599) 120,751
4,584,193
(4,504,406) 120,751
8,229,714 (204,759)
3,725,308 $ (84,008)
a) Collections from CCBHC exceeded the amount accrued at June 30, 2017. FY 17 revenue will be reported as FY 18 revenues.
b) Projection based on FY 2017 collections and anticipated withholdings for panel providers.
c) Title 19 revenue during the CCBHC demonstration project is projected to be reimbursed at a higher rate than previous years.
d) Projections based on YTD unfilled positions and forecasted unfilled positions during the remainder of the year.
e) Reclassification from State Grants to State Miscellaneous for presentation purposes. State Grant projection increased due to
higher than anticipated receipts from CCBHC wraparound payment. This offsets the reclassification to State Miscellaneous.
NOTE: Year-end projections for Health Service Programs are updated monthly. Projection amounts will fluctuate from month to month.
Page 4
Revenues
Admin -Operations
Admin -GIS
Admin -Code Enforcement
Building Safety
Electrical
Env Health -On Site Prog
Planning -Current
Planning -Long Range
Total Revenues
Expenditures (by division)
Admin -Operations
Admin -GIS
Admin -Code Enforcement
Building Safety
Electrical
Env Health -On Site Pgm
Planning -Current
Planning -Long Range
Total Expenditures
Revenues less Expenditures
Transfers InlOut
Out: CDD Reserve Funds
Net Transfers In/Out
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
FY 2017
COMMUNITY DEVELOPMENT
Schedule of Financial Operating Data
Year to Date July 1,
2017 through
December 31, 2017
(50% of the year)
% of
Actual • Actual I Budget
$ 110,639 $ 59,554 58%
230 - 0%
451,837 273,414 48%
2,903,075 1,449,945 49%
745,810 374,135 50%
678,469 350,884 52%
1,530,513 847,367 52%
577,420 280,489 41%
6,997,994 3,635,789 50%
1,750,586 966,659 46%
136,312 84,317 60%
357,992 204,209 46%
1,249,842 617,046 40%
320,568 154,857 39%
399,914 224,091 49%
1,179,944 641,087 43%
390,649 156,340 27%
5,785,808 3,048,606 43%
1,212,186 1 587,183
(1,375,000) (424,959) 52%
(1,375,000) (424,959)
_ (162,814) 162,224
2,330,492 2,167,678 132%
$2,167,678 $ 2,329,902
a) Projection decreased due to year to date unfilled positions.
b) Includes estimates for new FTE approved on 1/3/18
c) Includes adj for FTE budgeted in Current Planning and transferred to GIS.
a), b)
a), c)
a)
a), b)
a)
a), b), c)
a), b)
Revised
Budget
$ 102,042
150
565,544
2,948,636
743,927
680,460
1,614,855
682,919
7,338,533
2,117,813
141,439
448,238
1,524,982
398,758
456,234
1,479,295
569,088
7,135,847
202,686
FY 2018
Projected I Variance
$ 126,190
150
571,544
3,007,413
730,618
696,456
1,697,710
581,052
7,411,133
(823,610)
(823,610)
(620,924)
1,640,386
$1,019,462 $
$ 24,148
6,000
58,777
(13,309)
15,996
82,855
(101,867)
72,600
1,995,967 121,846
198,318 (56,879)
436,678 11,560
1,408,522 116,460
374,217 24,541
456,634 (400)
1,322,793 156,502
414,398 154,690
6,607,527 528,320
803,606 600,920
(823,610)
(823,610)
(20,004) 600,920
2,167,678 527,292
2,147,674 $1,128,212
Page 5
Revenues
Motor Vehicle Revenue
Federal - PILT Payment
Other Inter -fund Services
Federal Reimbursements
Cities-Bend/Red/Sis/La Pine
State Miscellaneous
Forest Receipts
Sale of Equip & Material
Mineral Lease Royalties
Assessment Payments (P&I)
Interest on Investments
Miscellaneous
Total Revenues
Expenditures
Personnel Services
Materials and Services
Capital Outlay
Total Expenditures
Revenues less Expenditure
Payment from Solid Waste
Transfers Out
Total Transfers
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
a) PILT payment received in
b) $3 million, appropriated in
s
ROAD
Schedule of Financial Operating Data
FY 2017
Actual
$ 12,930,670
1,323,365
1,065,930
488,114
593,969
381,533
273,353
183,312
87,079
112,444
50,391
17,490,159
Year to Date July 1,
2017 through
December 31, 2017
(50% of the year)
% of
Actual I Budget
$ 6,732,158
1,574,248
301,409
56,041
57,269
222,960
7,774
19,169
53,640
37,449
9,062,117
5,877,065 2,945,469
8,903,281 3,482,494
68,721 -
14,849,067 6,427,963
2,641,092 2,634,154
362,453
(9,067,643) (6,000,000)
(8,705,190) (6,000,000)
(6,064,098) (3,365,846)
14,840,939 8,776,841
$ 8,776,841 $ 5,410,995
51%
97% a)
20%
0%
8%
9%
0%
58%
4%
22%
60%
91%
46%
48%
25% b)
0%
32%
100%
100%
101%
Budget
$13,260,000
1,623,000
1,501,525
955,549
710,000
651,213
400,000
381,900
175,000
88,000
90,000
41,092
19,877,279
6,161,974
13,715,873
228,000
20,105,847
(228, 568)
FY 2018
Projected I Variance
$ 14,300,000 $ 1,040,000
1,574,248 (48,752)
1,501,525
955,549
710,000
651,213
400,000
381,900
175,000
88,000
90,000
41,092
20,868,527 991,248
(6,000,000)
(6,000,000)
(6,228,568)
8,684, 589
$ 2,456,021 $
July was less than budgeted.
FY 2018 for cost of overlays, will be expended in future periods.
6,133,974
10,715,873
228,000
17,077,847
3,790,680
28,000
3,000,000
3,028,000
4,019,248
(6,000,000)
(6,000,000)
(2,209,320) 4,019,248
8,776,841 92,252
6,567,521 $ 4,111,500
Page 6
Revenues
DOC Grant in Aid SB 1145
CJC Justice Reinvestment
DOC Measure 57
Electronic Monitoring Fee
Probation Superv. Fees
DOC -Family Sentence Alt
lnterfund - Sheriff
Gen Fund/Crime Prevention
DOJ/Arrest Grant
Alternate Incarceration
State Subsidy
Interest on Investments
Probation Work Crew Fees
State Miscellaneous
Miscellaneous
Total Revenues
ADULT PAROLE & PROBATION
Schedule of Financial Operating Data
Year to Date July 1,
2017 through
December 31, 2017
(50% of the year)
% of
Actual 1 Actual I Budget Budget
FY 2017
$ 3,650,168
845,836
240,315
133,292
209,708
110,797
50,000
50,000
46,736
29,985
16,367
28,990
5,958
1,256
5,419,408
$2,166,664 55% a) $3,940,708
844,831 121% b) 699,506
0% c) 234,315
63,289 37% 170,000
90,400 43% 210,000
114,683 N/A a)
25,000 50% 50,000
12,500 25% j) 50,000
11,684 106% 11,000
6,908 34% i) 20,035
8,168 52% a) 15,610
13,871 139% f) 10,000
748 12% d) 6,000
0% 4,300
7% 500
62% 5,421,974
37
3,358,783
Expenditures
Personnel Services 4,097,354 2,108,060
Materials and Services 1,509,684 629,458
Transfer to Veh Maint 22,000 22,000
Capital Outlay 15,986
Total Expenditures 5,645,023
47% e) 4,455,860
34% h) 1,843,865
50% 44,000
N/A g)
2,759,518 43% 6,343,725
Revenues Tess Expenditures (225,615)1 599,265
Transfers In -General Fund 451,189
Change in Fund Balance 225,574
Beginning Fund Balance 1,465,370
Ending Fund Balance $ 1,690,943
225,594
824,859
1,690,943
$ 2,515,803
FY 2018
Projected j Variance
$ 4,333,290 $ 392,582
844,831 145,325
233,900 (415)
155,000 (15,000)
210,000 -
115,683 115,683
50,000
50,000
11,684 684
6,908 (13,127)
16,337 727
25,000 15,000
2,000 (4,000)
4,300
500 -
6,059,433 637,459
4,350,000 105,860
1,500,000 343,865
44,000
24,902 (24,902)
5,918,902 424,823
(921,751) 140,531 1,062,282
50% 451,189 451,189
(470,562) 591,720
123% 1,375,000 1,690,943
$ 904,438 $ 2,282,664
1,062,282
315,943
$ 1,378,226
a) Projection increased due to additional revenue being granted by legislature after budget adoption.
b) Legislature increased grant subsequent to adoption of FY 2018 budget.
c) Annual payment expected January 2018. Projection decreased due to less than anticipated revenue
granted by legislature after budget adoption.
d) Projection decreased due to less than anticipated revenue related to restructuring fee reduction calculation to
better estimate ability to pay and to increase collections.
e) Projected to be less than appropriated due to vacancies.
f) Projection based on trending.
g) Projection increased due to unanticipated purchases related to security,
h) Projection decreased due to less than anticipated expenditure related to offender treatment contract payments
and data dashboard. Page 7
i) State prison transition program elimated.
j) General Fund grant received quarterly
SOLID WASTE
Schedule of Financial Operating Data
FY 2017
Year to Date July
1, 2017 through
December 31, 2017
(50% of the year)
FY 2018
o
of
Actual 1 Actual Budget Budget I Projected I Variance
Operating Revenues
Franchise Disposal Fees $ 5,459,396 $ 3,134,892 49% $ 6,391,644 $ 6,391,644 $
Private Disposal Fees 2,095,262 1,316,068 65% a) 2,012,522 2,012,522
Commercial Disp. Fees 1,729,096 993,400 57% a) 1,742,832 1,742,832
Franchise 3% Fees 254,304 25,125 10% b) 240,000 240,000
Yard Debris 171,470 114,975 68% a) 168,000 168,000
Recyclables 13,467 8,902 74% a) 12,000 12,000
Equip & Material 18,590 N/A
Special Waste 28,812 7,836 31% a) 25,000 25,000
Interest 31,959 9,833 49% 20,000 20,000
Leases 10,801 5,401 50% 10,801 10,801
Miscellaneous 59,241 33,770 96% 35,000 35,000
Total Operating Revenues 9,872,398 5,650,203 53% 10,657,799 10,657,799
Operating Expenditures
Personnel Services 2,049,320 1,077,068 47% 2,278,466 2,258,466 20,000
Materials and Services 4,334,705 2,022,634 41% 4,909,217 4,909,217
Capital Outlay 127,449 39,738 32% 125,000 125,000
Debt Service 858,512 310,982 36% c) 861,102 861,102
Total Operating Expenditures 7,369,985 3,450,422 42% 8,173,785 8,153,785 20,000
Operating Rev less Exp 2,502,412 2,199,781 2,484,014 2,504,014 20,000
Transfers Out
SW Capital & Equipment Reserve 3,075,000 2,565,000 99% 2,580,000 2,580,000
Total Transfers Out 3,075,000 2,565,000 99% 2,580,000 2,580,000 -
Change in Fund Balance (572,588) (365,219) (95,986) (75,986) 20,000
Beginning Fund Balance 1,810,265 1,237,677 201% 615,872 1,237,677 621,805
Ending Fund Balance $ 1,237,677 $ 872,458 $ 519,886 $ 1,161,691 $ 641,805
a) Fees are seasonal and are lower during the winter months.
b) Franchise fee payment is due on May 15, 2018.
c) Debt Service payments are made in November and May.
Page 8
Revenues
Inter -fund Charges:
General Liability
Property Damage
Vehicle
Workers' Compensation
Unemployment
Claims Reimb-Gen Liab/Property
Process Fee-Events/Parades
Miscellaneous
Skid Car Training
Interest on Investments
TOTAL REVENUES
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
Miscellaneous
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
Property Damage Charges
Settlement / Benefit
Insurance
Loss Prevention
Repair / Replacement
Total Property Damage
VEHICLE
Professional Service
Insurance
Loss Prevention
Miscellaneous
Repair / Replacement
Total Vehicle
WORKERS' COMPENSATION
Settlement / Benefit
Professional Service
Insurance
Loss Prevention
Miscellaneous
Total Workers' Compensation
UNEMPLOYMENT - Settlement/Benefits
Total Direct Insurance Costs
Insurance Administration:
Personnel Services
Materials & Srvc, Capital Out. & Tranfs.
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
RISK MANAGEMENT
Schedule of Financial Operating Data
FY 2017
Actual ■ Actual
Year to Date July 1, 2017
through December 31,
2017 (50% of the year)
of
Budget
931,319 $ 525,642
389,101 195,771
197,155 97,542
1,228,053 620,859
280,921 177,764
33,863 312,791
1,980 765
30 1,500
43,853 22,552
58,644 36,353
3,164,919 1,991,540
711,705 17,040
27,039 18,543
6,250 6,622
339,723 207,262
1,347
171
33,673 932
1,119,908 250,398
117
5,101 173,873
12,000
122,074 2,304
139,175 176,294
781
25,397
6,985
102,994
136,157
539,792
6,250
159,212
49,683
52,937
807,875
56,497
2,259,612
327,505
146,503
2,733,620
431,299
4,928,271
$ 5,359,570
FY 2018
Budget Projected Variance
50% $1,051,283 $ 1,051,283 $ -
50% 391,542 391,542 -
50% 195,085 195,085 -
50% 1,241,718 1,241,718 -
50% 354,609 354,609 -
1043% a) 30,000 320,000 290,000
43% 1,800 1,800
5000% 30 1,600 1,570
70% 32,000 32,000 -
49% 73,464 73,464 -
59% 3,371,531 3,663,101 291,570
31% 800,000 700,000 100,000
82% b) 215,000 504,199 (289,199)
5,101
694
37,806
43,601 44%
336,371
18,077
111,730
33,588
12,316
512,082
30,960
1,013,336
169,115
68,917
1,251,369
740,171
5,359,570
$ 6,099,741
100,000 100,000
57% 900,000 1,050,000 (150,000)
21% 150,000 100,000 50,000
47% 2,165,000 2,454,199 (289,199).
49% 345,627 345,627
30% 226,699 226,699 -
46% c) 2,737,326 3,026,525 (289,199)
634,205 636,576 2,371
109% 4,897,636 5,359,570 461,934
$5,531,841 5,996,146 464,305
a) Claims reimbursement includes insurance payment of $254,199 for Fair/Expo roof damage.
b) Projection includes expenditure is for the Fair/Expo roof replacement.
c) An appropriation transfer may be required.
Page 9
Revenues
Property Taxes - Current
Property Taxes - Prior
Property Taxes - Jefferson County
State Reimbursement
State Grant
Telephone User Tax
Data Network Reimb.
User Fee
Police RMS User Fees
Contract Payments
Miscellaneous
Interest
Total Revenues
DC 9-1-1 (Funds 705 and 707)
Schedule of Financial Operating Data
FY 2017
Actual
$ 7,496,065
109,702
32,518
869,734
276,510
865,111
86,263
58,981
326,030
130,756
3,562
105,258
10,360,491
Expenditures
Personnel Services 5,867,156
Materials and Services 3,254,372
Capital Outlay 4,941,447
Total Expenditures 14,062,974
Transfer In - Fund 710 400,000
Revenues less Expenditures
Year to Date July 1,
2017 through December
31, 2017 (50% of the
year)
% of
Actual Budget
FY 2018
Budget I Projected Variance
7,374,754 93% a) $ 7,926,725 $ 7,926,725 $
83,852 99% 85,000 85,000
29,330 89% a) 33,000 33,000
15,000 14% b) 110,000 15,000 (95,000)
N/A
223,749 25% c) 880,000
0% 55,000
54,786 61% 90,000
41,240 16% 250,119
4,253
40,882
7,867,846
3,442,068
1,904,269
1,213,445
6,559,782
343,779
(3,302,483)1 1,651,843
Beginning Fund Balance 10,563,485 7,261,001
Ending Fund Balance $ 7,261,001 $ 8,912,844
0% 193,000
16% 27,000
64% 64,000
81% 9,713,844
49% 7,070,919
62% b) 3,047,724
55% d) 2,210,000
12,328,643
43% 806,137
880,000
55,000
90,000
250,119
193,000
27,000
64,000
9,618,844 (95,000)
7,004,919 66,000
2,937,724 110,000
2,210,000
12,152,643 176,000
806,137
(1,808,662) (1,727,662) 81,000
110% 6,600,000 7,261,001 661,001
$ 4,791,338 $ 5,533,339 $ 742,001
a) Historically, 92% of the current year taxes are received by the end of December.
b) Four workstations will not be purchased as the State will not be providing the resources.
c) Q2 payment expected by the end of January.
d) Several capital project expenditures made during Q1.
Page 10
Revenues:
Internal Premium Charges
Part -Time Employee Premium
Employee Monthly Co -Pay
COIL
Retiree / COBRA Co -Pay
Prescription Rebates
Claims Reimbursements & Misc
Interest
Total Revenues
Expenditures:
Materials & Services
Admin & Wellness
Claims Paid -Medical
Claims Paid -Prescription
Claims Paid-DentalNision
Stop Loss Insurance Premium
State Assessments
Administration Fee (TPA)
Preferred Provider Fee
Other - Administration
Other- Wellness
Admin & Wellness
Deschutes On-site Clinic
Contracted Services
Medical Supplies
Other
Total DOC
Deschutes On-site Pharmacy
Contracted Services
Prescriptions
Other
Total Pharmacy
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
% of Exp covered by Revenues
Health Benefits Fund
Statement of Financial Operating Data
FY 2018 July 1, 2017 through December 31, 2017
FY 2017
Actual
$ 16,955,229
2,585
923,805
2,165, 312
1,202,895
52,995
82,361
168,140
21,553,322
13,016,901
977,260
2,141,054
366,633
6,269
461,375
91,904
221,307
174,028
17,456,731
953,281
72,219
45,308
1,070,808
382,900
1,728,845
34,083
2,145,828
20,673,366
879,955
14,502,622
$ 15,382,578
104.3%11
Actual
$ 8,786,849
1,334
460,575
924,068
616,105
33,958
22,922
100,319
10,946,130
6,856,397
686,005
969,630
216,950
235,772
43,017
82,462
63,239
9,153,471
393,229
38,417
14,991
446,637
122,886
737,986
44,520
905,393
10, 505, 501
440,629
15,382,578
$ 15,823,207
a) Year to Date Annualized
b) 12 -Month rolling average with 8% increase over prior year
104.2%I
I% of
Budget
FY 2018
Budget
Projection I $ Variance
52% a) 16,865,000 17,573,699 708,699
N/A a)2,668 2,668
50% a) 925,000 946,575 21,575
42% a) 2,224,000 1,848,136 (375,864)
51% a) 1,211,803 1,232,209 20,406
N/A 33,958 33,958
15% 150,000 150,000
48% a) 210,000200,638 (9,362)
51% 21,585,803 21,987,883 402,080
49% b) 14,088,936 13,333,475 755,462
64% b) 1,069,006 1,208,554 (139,548)
41% b) 2,342,057 2,167,389 174,668
51% 425,000 425,000
0% 6,600 6,600
51% 465,000 465,000
66% 65,000 65,000
38% 214,431 214,431 -
35% 178,900 178,900
49% 18,854,931 18,064,348 790,583
40% 975,000 975,000
45% 85,000 85,000
33% 45,943 45,943
40% 1,105,943 1,105,943
39% 312,000 312,000
43% a) 1,700,000 1,771,166
68% 65,418 65,418
44% 2,077,418 2,148,584
48% 22,038,292 21,318,875
(452,489) 669,008
103% 15,000,000 15,382,578
$ 14,547,511 $16,051,585
97.9%I 103.1%1
(71,166)
(71,166)
719,417
1,121,497
382,578
$ 1,504,074
Page 11
jrf 1/2/2018
Operating Revenues
Events Revenues
Storage
Camping at F & E
Horse Stall Rental
Food & Severege Activities, net
Annual County Fair (net)
Interfund Contract
Miscellaneous
Total Operating Revenues
Operating Expenditures, net of TRT:
General F & E Activities
Personnel Services
TRT Grant
Materials and Services
TRT Grant
Capital Outlay
Total Operating Exp, net of TRT
Other:
Park Acq/Dev (Fund 130)
Rights & Signage
Interest
Total Other
I Results of Operations
Transfers In / Out
Transfer In -General Fund
Transfer In -Room Tax - (Fund 160)
Trans In(Out)-Fair & Expo Reserve
Total Transfers In
Non -Operating Rev & Exp
Debt Service
Total Non -Operating Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
FAIR AND EXPO CENTER
Schedule of Financial Operating Data
Year to Date July 1, 2017 through December 31, 2017 (50% of the year)
FY 2017
Actual
538,512
66,879
21,148
34,953
119,129
440,000
30,000
14,198
1,264,818
940,667
(188,255)
812,908
(167,827)
1,397,493
30,000 _
116,130
1,789
147,919
15,244
250,000
25,744
(55,000)
220,744
Year to Date July 1, 2017
through December 31, 2017
(50% of the year)
Actual
$ 148,974
34,554
4,150
9,993
(20,982)
245,452
15,000
2,519
439,660
483,493
(105,074)
480,931
(118,833)
% of
Budget
27%
53%
21%
24%
-17% a)
57% b)
50% c)
34%
35%
46% d)
53%
39%
19%
0%
740,517 51%
15,000
14,600
364
29,964
(270,893)
100,000
12,872
(105,452)
7,420
FY 2018
Budget 1 Projected
544,000
65,000
20,000
41,000
120,695
430,626
30,000
7,500
1,258,821
1,050,695
(200,000)
1,223,563
(635,070)
15,000
1,454,188
Variance
$ 544,000 $
65,000
20,000
41,000 -
120,695
285,452 (145,174)
30,000
7,500
1,113,647 (145,174)
1,025,695 25,000
(200,000)
1,223,563
(635,070)
15,000
1,429,188 25,000
50% 30,000 30,000
12% 118,000 107,700 (10,300)
36% 1,000 1,000 -
20% 149,000 138,700 (10,300)
(46,367)(176,841) 130,474)1
50%
50%
100%
200,000
25,744
(105,452)
120,292
200,000
25,744
(105,452)
120,292
102,536 56,660 56% 101,824 101,824
102,536 56,660 56% 101,824 101,824
133,452
47,283
180,735
(320,133)
180,735 80%
(139,397)
(27,899)
225,000
$ 197,101 $
a) See "Food & Beverage Activities Schedule"
b) Revenues and Expenses for the annual County Fair are recorded in a separate fund and the available
net income is transferred to the Fair & Expo Center Fund
c) Reimbursement from RV Park for personnel expenditures recorded in F&E
d) Personnel projected to be less than budgeted due to open positions through December 31, 2017
(158,373) (130,474)
180,735 (44,265)
22,362 $ (174,739)
Page 12
0
0)
a
7
03
CO •Cr}
LL
O
0
O
0
0
(0
a)
>-
a) a)
U
a)
0
0
E
0
O
Z
0 —
O
< 0
CXO 'n
O
(7: U
i > >-
O U LL
C � Q
U o
W w
_c a CO
C N ro
o O
(3 (o-0
LL O
19
1-
1'-
1'-
4
T
O O o 0 0 0 0 o 0 0 O Uf) O 1.0 U
O
0 CO 0 0 O O CO 0 0 0 (() U) 0 0)
O ' O r OOO CO N O6 O O O ti n O (D
N N d' CO r- u co �! O -t 4 Lri co- 0) O
O O N co (D e- *- N co e- V N
N r r T
M h.. d' (o o (O CO 0) 0) o N co O
M M O (O gt "t d (C) N LO 00
CA e- 0) e- co. I-- O 0) 0)- (G O) O O
NMN M N ,-M CO ` M
(t1 CO CO t N
e - MO (t')
0) d' C)) st
0) CV 00 M
N N
3
N
49
15,086 $ 32,621
in e- CO 0) o
(O W 0) TY 0)
O Cc) CO I� T
N CP) (5 T (p
e- T
00 PI `ch
N CO et 0 CO CNO
M
N (0 N t` N N d (0 r
LO Cr) CO o ()) CO CO CO o
M 0N0 N CA T (P) 00 "et LO M CO LO h ti
V..
C(M CV Cr; (O (0 N tom- (O - r
(H
T C1'I- U) (O e 0 h - ' s o
O- - 07 co V� (Off CO Cr) N
E 0) N N� N '- co- O 0)
a
a)
(1) (a
(' 0) co 00 4 O co d o
I- N- 14) e- a- 6() N 0) CO CO 00
CO T N. O O 0() CO e- 0 O T (,rj
110 - 0 M N oi M O N ~ N ,c -.7
M
O)
Q v
(R
CO M 00 00)) (V o CO CO r1' OstCO
(00 O0) O - 0 M coOo0
O d' N N N v (4) 10 N
6.9
0)
M
N 1-(`M') 0
0 OCA O
e- 14) O
N N N N
� v
0)
ro
m
07
° o0
v
0
O
LL
:4) C 0c p
N
0c U O
U U
0 0 m d W
W G
Cost of F&B Percentage
N t() t() ((1
O N CO (()
00 (h e- M
M (n O d'
N Q N N
0)
y C0
0
O U
CL
0 O
L1
�a
C O 0 N
TO
W _rot O
12 0
Gross Profit Percentage
N N ((1
a ti
L() ' t()
a- T r-
e -
CO I
LOM 001 0)
N O
ti
(0
(O() 10
N Cr)
00
t-
t -
O
N
ti
T
40)
NCOa-M' O O
N N rM ��
1
40
O e- 0 O
N ti ((1
e- T M
e- v- v-
......
0p ' a0 N
V'
Q' O r 4 N
O T
Vi
co co N d' (0 0)
Cr) ' CO r-- d4' N 01
p r
e- T T
0 ,-
L0 N
M
N
h
N O4- CO
e- T
Total Expenses
0)
N
0)
Income (Loss) F&B Activity
Revenues
Court Fines & Fees
Interest on Investments
Total Revenues
Expenditures
Personnel Services
Materials and Services
Total Expenditures
Revenues Tess Expenditures
Transfers In -General Fund
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
a) Year to date annualized.
JUSTICE COURT
Schedule of Financial Operating Data
FY 2017
Actual
$ 545,628
1,348
546,976
467,419
153,817
621,236
(74,260)
25,000
(49,260)
161,702
$ 112,442
Year to Date July 1,
2017 through
December 31, 2017
(50% of the year)
%of
Actual Budget
Budget
FY 2018
Projected
Variance
281,947 53% a) $ 530,000 $ 563,895 $ 33,895
460 31% 1,500 1,500
282,407 53% 531,500 565,395 33,895
230,919
73,757
304,676
47%
52%
48%
(22,269)
35,000 50%
12,731
112,442 132%
$125,173
486,471
142,392
628,863
486,471
142,392
628,863
(97,363) (63,468) 33,895
70,000 70,000
(27,363) 6,532 33,895
85,000 112,442 27,442
$ 57,637 $ 118,974 $ 61,337
Page 14
Deschutes County
Room Taxes (Funds 160 and 170)
Budget and Actual - FY 2018
YTD December 2017
Fund 160 7% of TRT Fund 170 - 1% of TRT
Budget Actual Budget Actual
REVENUES
Room Taxes $ 5,880,000 $ 4,249,544 $ 840,000 $ 607,080
Interest 10,000 10,373 7,000 4,024
Total Revenues 5,890,000 4,259,916 847,000 611,104
EXPENDITURES
Administrative
Auditing Services 10,937
Temporary Help 7,064
Interfund Contract 48,238
ISF 32,287
Public Notices 2,669
Printing 1,881
Office Supplies 897
Postage 2,647
Total Administrative 106,620
847
24,119
16,144
735
41,845
Current Distributions
Sheriff's Office 3,151,787 1,575,894
Sunriver Service Dist 200,000
COVA - 6% 982,256 679,129
COVA - 1% 820,164 569,878
Grants
Third Party Grants
Inter -fund Grants
F&E Center -
Annual County Fair -
RV Park - -
Inter -fund Transfers
F&E Center 25,744 12,872
F&E Reserve Fund -
Total Distributions 5,179,951 2,837,773
Total Expenditures 5,286,571 2,879,618
Change in Balance 603,429 1,380,298
Beginning Balance 407,000 449,923
Ending Balance $ 1,010,429 $ 1,830,221
1,563
9,048
15,305
381
269
128
378
27,072
113
4,020
7,652
105
11,890
Combined - 8% TRT
Budget
% of
Actual Budget
$ 6,720,000 $ 4,856,624 72.3%
17,000 14,396 84.7%
6,737,000 4,871,020 72.3%
12,500
7,064 960
57,286 28,139
47,592 23,796
3,050 840
2,150
1,025 -
3,025
133,692 53,735
3,151, 787 1,575,894
200,000
982,256 679,129
820,164 569,878
8,000 - 8,000
839,242 223,907 839,242 223,907
70,000 101,384 70,000 101,384
70,000 26,027 70,000 26,027
- 25,744 12,872
245,978 122,989 245,978 122,989
1,225,220 482,307 6,405,171 3,320,080
1,252,292 494,197 6,538,863 3,373,815
(405,292) 116,907 198,137 1,497,205
405,292 467,133 812,292 917,056
$ - $ 584,040 $ 1,010,429 $ 2,414,261
Page 15
0
0
-< Deschutes County Board of Commissioners
1300 NW Wall St, Bend, OR 97703
(541) 388-6570 — Fax (541) 385-3202 — https://www.deschutes.org/
AGENDA REQUEST & STAFF REPORT
For Board of Commissioners Work Session of January 31, 2018
DATE: January 26, 2018
FROM: Wayne Lowry, Finance, 541-388-6559
TITLE OF AGENDA ITEM:
MUNIS Project Update and Budget Adjustment Request
RECOMMENDATION & ACTION REQUESTED:
Staff recommends the Board of County Commissioners approve an additional position in
Finance and direct staff to bring back a budget adjustment for FY 2018.
ATTENDANCE: Wayne Lowry, Finance Director
SUMMARY: See attached staff report
0:Q q
0)
v`: ° rte- i= =7
¢:mo
to
v
cu
U U
c C C "2 C 0)
Q) :c, a--. 'D _ LL Q _
to 0 Q N O a E O _C
co
a c 3 a iz E �>+ co
)I—
N N
a
c
= L2
1
0
Q Lw
r
c 0.
-t O 0
cn
o �. >, to 2 O O_
W CO -t C 0)O C U 0 O
= •E O a) co cn 0 co
(� O OU >+ V N �O .0
C 00-Q OUa'- �)C 0 0
O to = 12 "O X U N -c-c, Q Q (n
ca +� L cn Q
0 �Q� E_F®Q �0�� a� z�
ULE Ta
Q to E i LL
C m U O W U (o D C U
OQ coD��Q U�> -D
2 0 m Q
Fi
co
cn c U c Q N
0 p O Q m O CC
o E +n
N O V U m c C 2
N > J V N to I— (o O U
CC .c o._UF— E pm c�n(A
J
0CI 0) E °OU ,TZ
pQ 00
Software Project
The MUNIS Software project began with the selection of TYLER Technologies as the vendor in March,
2016. Phase 1 of the project was the implementation of the financial functions of the software. This
included purchasing, accounts payable, general ledger, pjectaccountin8,receivab|es,cashveceipts,
cash mgmt., fixed assets, budgeting, and financial reporting. After 10 months of preparation, testing
and training, all departments successfuLly went live with these functions on July 1, 2017.
Phase 2 of the project began in January 2017 with the goal of migrating to NOVAtime electronic time
keeping in October 2017 and to payroll and HR functions in January 2018.
Due to issues with negotiations to change the pay cycle and time reporting periods, phase 2 of the
MUNIS project has been rescheduled for January 2019. In October, 2017, we re -grouped and )aid out
the steps that will lead tocompletion ofthis phase ofthe project. They include the following:
1. Provide additional NOVAtime training and informational resources for staff in all departments
by mid-February 2018.
2. Complete the implementation of NOVAtime Timekeeping software and move away from paper
time sheets by March 31, 2018.
3. Continue meeting with bargaining units to negotiate MOU's to address any necessary language
changes.
4. Implement the Scheduler function for 24/7 operations to assist with scheduling staff to fill shifts
by June 30, 2018.
S. Renew efforts to setup, test and implement MUNIS payroll by January 1, 2019.
Electronic timekeeping in NOVAtime is expected to save departments the time involved in summarizing
their staff's paper timesheets on the monthly payroll summary each month. This savings could be
significant for Iarger departments. It is also expected to save about two days of manual time entry in
Finance each month. Human Resources and Payroll are expected to save time processing benefit
changes, employee changes and certain personnel actions as employees will be able to make their own
changes through the employee self-service function once MUNIS payroll and HR is fully implemented.
Finance Department Staffing
Staffing in the Finance Department has not changed in many years other than the addition of a limited
duration position to manage the MUNIS software project. The FY 2018 budget included that position
but only through January 2018. As we get further into Phase 2 of the MUNIS pject, we are realizing
the need for additional resources in the Finance payroll area. The County has operated through the
years with a single payroll dedicated resource in Finance. The payroll world has become more complex
and the number of County FTE's has grown by about 15% over the past ten years. We routinely use
overtime and additional hours from existing staff to complete our payroll each month. The prject has
brought us new work in the form of ongoing administration and maintenance of the NOVAtime
timekeeping software and eventually the MUNIS payroll system.
Budget Adjustment Request
We believe our costs for this project in FY 2018 will be greater than anticipated in the FY 2018 budget
partly due to rescheduling the implementation date and partly due to our realization that we will need
to add a staff resource to our payroll function in Finance. The cost of this additional position at the
Accounting Tech level is estimated at $30,000 for the balance of the fiscal year.
Due to the rescheduled go live date, we will also need temporary help through the balance of the fiscal
year to fully implement the NOVAtime software and move away from paper timesheets. The cost of this
change is estimated to be $40,000.
The total budget adjustment requested from Contingency is $70,000 for FY 2018 and includes the
addition of 1.0 FTE in the Finance department. If this proposal is approved, we will place a budget
adjustment resolution on an upcoming Board Agenda and will begin the recruitment process for the
new position.
Property Management
James Lewis, Property Manager
Location: 14 NW Kearney Street, Bend
Mailing: POBox 6085,Bend, Oregon 977OO
(541) 330-4686 Fax: (541) 317-3168
Auction Details: (541'3OS'1414
w/ww.deschutes.orepyctjPD
To: Deschutes County Board of Commissioner
From: James Lewis, Property Manager
Date: January 24, 2018
RE: Land cionation request from City of La Pine — !ndustrial Lot / Newberry Busirtess
Park
Hello Commissioners:
The attached letter from the City of La Pine, and accompanying aerial photo and map, describes a
request from the City of La Pine for a donation of a 0.58 acre Industrial zoned lot in the Newberry
Business Park (Lot 111 Newberry Business Park, Tax Map/Lot 221014AB00111). The Iotwill be utilized
for construction of an approximate 5,000 to 7,000 square foot industrial lease space building. The City is
intending to work with a private builder for construction, as well as sale of the property/building to that
builder. The City intends to lease the building back from the owner in order to provide a sublease at a
reduced lease rate (sub -market rate) to a new business in order to stimulate the local economy. The
intent is to incentivize a new business to locate in La Pine by providing a short term reduced lease rate to
allow such business to invest capital into the growth of the new/start-up business (i.e. equipment,
marketing, etc.) rather than rental space.
The Ietter submitted by the City is cursoryin its description of the idea described above. The City staif
(Cory MisleyCity Manage ) and EDCO/SLED staff (Ryan Culp, Sunriver/La Pine Area Director) will be in
attendance and are prepared to provide more detail at the work session. It is anticipatecl that they will be
provide a more detailed description of the overall proposal, the construction timelines, the leasing/funding
methods, and the County involvement,
Pursuant to the IGA with the City of La Pine (fall of 2014), the City is responsible for all sale/lease
negotiations for the County owned industrial properties in La Pine — as the owner, the County must still
sign all sale lease documents based on the City's negotiated terms. Post sale/lease, all revenue is split
equally (50% - 50%) between the County and City. In this instance, the City is requesting the donation of
the property to the City in entirety. This means that the County would be relinquishing the 50% revenue
from the property sale, The City has stated that the sale price of the subjecproperty would be $50, 530
($2.00 per square foot). Pursuant to the 2014 IGA, the City negotiated price is the value used for the
assumed direct financial impact to the County through a full donation of the property. In turn, the City
would receive the fuJi revenue from the sale ($50,530),and has stated that the revenue (especially the
additional 50% revenue gained via the County donation of the property - $25,265), will enable the City to
pay the market lease rate to the builder while receiving less than market rate rent from the new business.
Essentially, the County contribution will afford the City enough funds to subsidize the new business during
a defined period of business start-up (5 years).
The donation of the property to the City of La Pine is authorized pursuant to ORS 271.330.
This item will be presented and discussed at your work session (executive session — real property) on
January 31, 2018
Thank you, James
Deschutes County encourages persons with disabilities to participate in all programs and activities. If you need accommodationto
make participation in an event possibte or to request this information in an alternate format, please contact (541-330-4686.
1
NiA
1111111111111111111111 LA PINE
January 17, 2018
Mayor Dennis Scott
Councilor Sru Martinez Councilor I)oii1d Greiner
Councilor Craig Heaton Councilor Connie I3riese
CITY OF LA PINE
Board of Deschutes Courfty Commissioners
Deschutes Serv;ces Building
130ONVVWall Street, 2nd Floor
Bend, OR 97703
Subject: Land Request for Industriat Buitding in La Pine
Dear Commissioners:
16345 Sixth Stree--90Box 246V
La Pine, Oregon 97739
TEL (541)530t4}2 --FAX (541) 536-1462
The City of La Pine enthusiasticaUy writes this le#erhzmtimulab*mndencomrageeconomic
development in the La Pine industrial park. Over the past several years, we have observed
numerous small businesses wanting to locate in the industrial park but unable to do so due
to a lack of available building space. As you are aware, Deschutes County owns several
hundred acres of land in the industrial park that is marketed and managed through an !GA
with the City of La Pine. We are looking at new ways to utilize that asset for the shared goal.
Over the past couple of months, through the Sunriver/La Pine Economic Development
(SLED) Board, the potential for having a building (approximately 5,000-7,500 square feet)
constructed has been explored. The details and timing of that are still unknown; however,
there has been support from SLED and the La Pine City Council for finding ways to
generate activity in the industrial park through new, creative approaches — including the
construction of a building. We currently have one business that is very interested in leasing
space in this future building, arid expect that finding a second would not be difficult.
Unfortunately, developers have not come to La Pine to build industrial buildings. Given that
the tand is for economic development and job creation in South County and La Pine, we
hope to pursue this building development as a catalyst for development as we prove the
viability of La Pine. We are in exploratory conversations with developers about constructing
a buitding with the City leasing and then subteasing to the businesses. As we mentioned,
the details of those arrangements have not been identified. However, we know that a critical
piece of the puzzle is having the land available with the ability to leverage land quickly and
efficientty to encourage development.
Wohave identified O.58-onreparcel (Tdot221Oi4AB00111)onthe corner ofReed Road
and Hinkie Way that would serve the function of the buliding space, as well as a model for
future development in the business park. We request that Deschutes County partner by
The La Pine City Council in consultation from the SLED Board will be discussing this project
at length in the coming months. We look forward to continuing to work together to move,
start, and grow more traded -sector economic activity in La Pine and South County.
Sincerely,
Dennis Scott
Mayor