agenda - thursday, september 14, 2017
TRANSCRIPT
Board of Riley County
Commissioners Regular Meeting
Agenda
September 14, 2017
115 North 4th Street Manhattan, KS 66502
www.rileycountyks.gov
Cindy Kabriel 785-565-6200
Commission Chambers 8:30 AM
District 1 – Ben Wilson, Member District 2 – Marvin Rodriguez, Vice Chair District 3 - Ronald Wells, Chair
Board of Riley County Commissioners Page 1
8:30 AM Call to Order
Pledge of Allegiance
Public Comment
1. Public Comments
Commission Comments
2. Commission Comments
Business Meeting
3. CIP Authorization and Purchase Approval Form - EMS IT Equipment
4. Shared Leave Donation Form(s)
5. Discuss Joint City/County/County Meeting Agenda
6. Approve payroll/accounts payables (when completed)
Review Minutes
7. Board of Riley County Commissioners - Regular Meeting - Sep 11,
2017 8:30 AM
Review Tentative Agenda
8. Tentative Agenda
Press Conference Topics
9. Discuss Press Conference
9:00 AM Clancy Holeman, Counselor/Director of Administrative Services
10. Administrative Work Session
9:20 AM Break
9:30 AM Shilo Heger, Treasurer
11. August 2017 Revenue Reporting - Riley County Treasurer
9:45 AM Doug Schmitt, Assistant Fire Chief
12. Purchase Authorization for Water Line to Ogden Fire Station
Agenda Board of Riley County Commissioners September 14, 2017
Board of Riley County Commissioners Page 2
10:00 AM Jennifer Green, Health Department Director
13. September 2017- Health Department Staff Report
10:30 AM Budget and Planning Committee
14. Monthly Cash Flow Reports for August
10:50 AM Gregory Vahrenberg, Piper Jaffray & Co.
15. 2017 Riley County Preliminary Refinancing Analysis
Adjournment
Announcement
The Northeast Kansas County Officials Meeting will be held at 8:00
a.m. Friday, September 15th at the Johnson County Arts and Heritage
Center, 8788 Metcalf Avenue, Overland Park, Kansas.
In order to comply with provisions of the Americans with Disabilities Act (ADA), Riley County will make
reasonable efforts to accommodate the needs of persons with disabilities. Please contact the Division of Human
Resources at (785) 537-6303 (voice and TTY) for assistance.
Updated: 9/11/2017 9:56 AM by Tami Robison Page 1
COUNTY CLERK & ELECTIONS Budget
Rich Vargo
County Clerk
110 Courthouse Plaza
Manhattan, KS 66502
Phone: 785-565-6200
COMMISSION AGENDA REPORT
FROM: Tami Robison, Budget & Finance Officer
MEETING: September 14, 2017
SUBJECT: CIP Authorization and Purchase Approval Form - EMS IT Equipment
PRESENTER: Tami Robison, Budget & Finance Officer
Signature requested for CIP Authorization and Purchase Approval Forms for EMS/Ambulance
IT Equipment approved from CIP funds on September 11, 2017.
POSSIBLE MOTION(S)
Move to approve
Move to deny
Move to modify
Move to table
No action required.
The Board agreed by consensus to
Enclosures: EMS CIP project (PDF)
3
Packet Pg. 3
3.a
Packet Pg. 4
Att
ach
men
t: E
MS
CIP
pro
ject
(59
47 :
CIP
Au
tho
riza
tio
n &
Pu
rch
ase
Ap
pro
val F
orm
-EM
S IT
Eq
uip
)
Updated: 9/12/2017 12:46 PM by Cindy Volanti Page 1
COUNTY CLERK & ELECTIONS Personnel
Rich Vargo
County Clerk
110 Courthouse Plaza
Manhattan, KS 66502
Phone: 785-565-6200
COMMISSION AGENDA REPORT
FROM: Cindy Volanti, Human Resource Manager/Deputy Clerk
MEETING: September 14, 2017
SUBJECT: Shared Leave Donation Form(s)
PRESENTER: Cindy Volanti, Human Resource Manager/Deputy Clerk
POSSIBLE MOTION(S)
Move to approve the Shared Leave Donation Form(s).
Enclosures:
4
Packet Pg. 5
Joint City/County/County Meeting:
(at city offices)
Topics for Agenda: (September 21st)
5.a
Packet Pg. 6
Att
ach
men
t: t
op
ic f
orm
fo
r Jo
int
Cit
y/C
ou
nty
/Co
un
ty M
eeti
ng
(49
41 :
Jo
int
Cit
y/C
ou
nty
/Co
un
ty A
gen
da
Mee
tin
g In
form
atio
n)
Board of Riley County
Commissioners Regular Meeting
TENTATIVE Agenda
September 18, 2017
115 North 4th Street Manhattan, KS 66502
www.rileycountyks.gov
Cindy Kabriel 785-565-6200
Commission Chambers 8:30 AM
District 1 – Ben Wilson, Member District 2 – Marvin Rodriguez, Vice Chair District 3 - Ronald Wells, Chair
Board of Riley County Commissioners Page 1
8:30 AM Call to Order
Pledge of Allegiance
Public Comment
Commission Comments
Business Meeting
1. Discuss Intergovernmental Luncheon
Review Minutes
Review Tentative Agenda
Press Conference Topics
9:00 AM Lyle Butler, Manhattan Area Chamber of Commerce
2. Economic development update
9:15 AM David Adams, EMS/Ambulance Director
3. Staff update
9:30 AM Press Conference
10:00 AM Break
10:10 AM Clancy Holeman, Counselor/Director of Administrative Services
4. Administrative Work Session
10:30 AM Leon Hobson, Public Works Director/County Engineer
5. Project update
10:45 AM Monty Wedel, Planning/Special Projects Director
6. JLUS Work Session
8.a
Packet Pg. 7
Att
ach
men
t: 0
9-18
-17
ten
tati
ve a
gen
da
(55
66 :
Ten
tati
ve A
gen
da)
TENTATIVE Agenda Board of Riley County Commissioners September 18, 2017
Board of Riley County Commissioners Page 2
12:00 PM Law Enforcement Agency Meeting
Adjournment
In order to comply with provisions of the Americans with Disabilities Act (ADA), Riley County will make
reasonable efforts to accommodate the needs of persons with disabilities. Please contact the Division of Human
Resources at (785) 537-6303 (voice and TTY) for assistance.
8.a
Packet Pg. 8
Att
ach
men
t: 0
9-18
-17
ten
tati
ve a
gen
da
(55
66 :
Ten
tati
ve A
gen
da)
Board of Riley County
Commissioners Regular Meeting
TENTATIVE Agenda
September 21, 2017
115 North 4th Street Manhattan, KS 66502
www.rileycountyks.gov
Cindy Kabriel 785-565-6200
Commission Chambers 9:00 AM
District 1 – Ben Wilson, Member District 2 – Marvin Rodriguez, Vice Chair District 3 - Ronald Wells, Chair
Board of Riley County Commissioners Page 1
9:00 AM Call to Order
Pledge of Allegiance
Public Comment
Commission Comments
Business Meeting
Review Minutes
Review Tentative Agenda
Press Conference Topics
9:15 AM Debbie Regester, Register of Deeds
1. Staff update
9:30 AM Clancy Holeman, Counselor/Director of Administrative Services
2. Administrative Work Session
9:50 AM Break
10:00 AM Jennifer Wilson, County Extension Director
3. Staff update
10:15 AM Brad Schoen, RCPD Director
4. RCPD update
10:30 AM Pat Collins, Emergency Management Director
5. Staff update
10:45 AM Ray Greer, Consultant
6. Joint Land Use Study Final Report
8.b
Packet Pg. 9
Att
ach
men
t: 0
9-21
-17
ten
tati
ve a
gen
da
(55
66 :
Ten
tati
ve A
gen
da)
TENTATIVE Agenda Board of Riley County Commissioners September 21, 2017
Board of Riley County Commissioners Page 2
11:30 AM Gary Stith, Flint Hills Regional Council Director
7. Flint Hills Regional Council update
11:45 AM Lunch
4:00 PM Joint City/County/County Meeting (at city offices)
Adjournment
Announcement
Good Morning Manhattan will be held today 7:15-8:30 a.m. at the
Manhattan Country Club.
In order to comply with provisions of the Americans with Disabilities Act (ADA), Riley County will make
reasonable efforts to accommodate the needs of persons with disabilities. Please contact the Division of Human
Resources at (785) 537-6303 (voice and TTY) for assistance.
8.b
Packet Pg. 10
Att
ach
men
t: 0
9-21
-17
ten
tati
ve a
gen
da
(55
66 :
Ten
tati
ve A
gen
da)
Updated: 9/7/2017 11:24 AM by Shilo Heger Page 1
COUNTY TREASURER'S OFFICE Staff Update
Shilo Heger
Treasurer
110 Courthouse Plaza
Manhattan, KS 66502
Phone: 785-537-6320
MEMORANDUM
FROM: Shilo Heger
MEETING: September 14, 2017
SUBJECT: August 2017 Revenue Reporting - Riley County Treasurer
PRESENTER: Shilo Heger
Enclosures: August 2017 Financial Reporting (PDF)
11
Packet Pg. 11
Riley County Balance Sheet
August 31, 2017
Assets Liabilities/Fund Balances
Kansas State Bank 19,601,235.80 County General 11,759,359.36
Riley State Bank 114,650.13 Health Department 2,015,748.98
Leonardville State Bank 5,000.00 Capital Improvements Fund 6,160,252.02
Cash on Hand 92,065.12 Economic Development 181,197.69
ICS Account 3,500,000.00 RCPD Levy/Inmate Medical 1,562,470.57
CD/CDARS 16,000,000.00 Bond & Interest 107,719.11
Road & Bridge Capital Projects 4,996,433.34
Landfill Closure 57,902.79
County Building 179,406.39
County Auction 97,965.50
Solid Waste 737,395.37
Emergency Management 849,812.84
Fire District #1 745,282.30
Register of Deeds Tech Fund 94,722.64
Clerk Tech Fund 46,852.99
Treasurer Tech Fund 21,668.78
Motor Vehicle Operations 51,539.99
RCPD Operations 2,411,961.27
District Court-Technology 99,518.43
Museum Bequest 6,582.25
War Memorial Fund 9,620.07
Miscellaneous 27,894.36
Community Corrections 326,915.52
JJA Prevention Teen Court Adult Services
Juvenile Intake Case Manager Juvenile Service Special Alcohol
County Attorney 2,084.55
Special Prosecutor Trust PATF
Benefit Districts 726,627.13
University Park Moehlman Bottoms Deep Creek
Carson Sewer Valleywood Lakeside Heights
Hunters Island Terra Heights Konza
Mertz/McGehee Drainage
Funds to be Distributed 263,584.23
City Funds Wildlife & Parks School Funds
Township Funds Special Assessments State Funds
Cemetery Funds
Tax Holding Funds 5,772,432.58
Commercial Vehicle Fees 16/20M Truck Taxes Advance Tax
Recreational Vehicle Tax Current Ad Valorem Tax Sales Tax Coll
Motor Vehicle Tax Delinquent PP Tax Driver's License
Motor Vehicle Registrations Delinquent RL Tax Veh Rental Excise
TOTAL ASSETS 39,312,951.05$ TOTAL LIABILITIES & FUND BAL 39,312,951.05
Prepared by Shilo Heger 09/07/2017
11.a
Packet Pg. 12
Att
ach
men
t: A
ug
ust
201
7 F
inan
cial
Rep
ort
ing
(59
42 :
Sep
tem
ber
201
7 T
reas
ure
r's
Rep
ort
)
Investments and Interest
August 31, 2017
Investments & Year to Date Interest
Checking Year to Date 2016
Bank CDs Savings Interest Interest
KS State Bank $8,700,000.00 $23,101,235.80 $206,458.22
KS State Bank - ICS Account $0.00 $0.00 $931.29
Riley State Bank $1,000,000.00 $114,650.13 $4,484.36
Leonardville State Bank $0.00 $5,000.00 $12.50
Sunflower $0.00 $0.00 $0.00
UMB $0.00 $0.00 $0.00
Landmark National Bank $0.00 $0.00 $0.00
Intrust $1,700,000.00 $0.00 $0.00
Capitol Federal $0.00 $0.00 $0.00
Community 1st National Bank $4,000,000.00 $0.00 $27,861.18
United Bank $600,000.00 $0.00 $0.00
Municiple Investment Pool $0.00 $0.00 $0.00
Total $16,000,000.00 $23,220,885.93 $239,747.55 $184,259.13
Cash & Transfer items $92,065.12
Total on Deposit $39,312,951.05
2017 2016
Interest Transfers
Capital Improvements #145 $19,441.12 $9,534.56
Emergency 911 #148 $3,627.43 $1,574.49
Reg of Deeds Technology #106 $397.24 $149.70
Clerk Technology #107 $182.05 $57.05
Treasurer Technology #108 $94.78 $26.92
Total Transfers $23,742.62 $11,342.72
Net Interest to County General $216,004.93 $172,916.41
Budget 140,000.00$ $100,000.00
% Collected 154.29% 172.92%
% Over(Under Budget) 87.62%
Interest rate on active checking account 1.03%
Interest rate on one year investments 1.52%
Prepared by Shilo Heger 09/07/2017
11.a
Packet Pg. 13
Att
ach
men
t: A
ug
ust
201
7 F
inan
cial
Rep
ort
ing
(59
42 :
Sep
tem
ber
201
7 T
reas
ure
r's
Rep
ort
)
General Fund Revenue Detail
Through August 31, 2017
August Year To Date
Actual Budget Actual Budget Variance
Motor Vehicle
Motor Vehicle 0.00 0.00 861,329.34 851,776.25 9,553.09
Vehicle Rental Excise 0.00 0.00 15,065.13 14,845.00 220.13
Recreational Vehicle 0.00 0.00 7,796.91 7,673.00 123.91
Commercial Vehicles 0.00 0.00 78,066.07 74,739.00 3,327.07
Ad Valorem
RL/Oil/PP 0.00 0.00 18,187,301.79 18,148,358.00 38,943.79
Intangible 0.00 0.00 248,876.53 189,048.00 59,828.53
16/20 M Trucks 0.00 0.00 11,725.91 13,985.00 -2,259.09
Watercraft 0.00 0.00 7,571.43 8,564.00 -992.57
Delinquent Tax 0.00 0.00 188,444.74 0.00 188,444.74
Sales Tax 149,020.49 133,333.33 1,146,027.68 1,066,666.67 79,361.01
Payment In Lieu of Tax 0.00 36,192.00 17,500.00 18,692.00
City/County Highway 0.00 889,944.54 769,000.00 120,944.54
Interest/Penalties 17,077.86 10,416.67 127,373.56 83,333.33 44,040.23
Investment Interest 33,833.71 11,666.67 216,004.93 93,333.33 122,671.60
Mortgage Registration Fees 37,504.99 12,500.00 291,366.23 100,000.00 191,366.23
Recording Fees 31,854.00 20,833.33 247,939.00 166,666.67 81,272.33
Hertiage Trust Fund 3,100.00 0.00 23,355.00 0.00 23,355.00
Juvenile Supervision Fees 25.00 25.00 750.00 200.00 550.00
Diversion Fees 12,445.68 5,666.67 45,623.95 45,333.33 290.62
Franchise Fees 0.00 0.00 30,922.51 32,442.75 -1,520.24
Miscellaneous 3,210.04 0.00 51,703.00 0.00 51,703.00
Departments
Clerk 369.75 291.67 3,252.20 2,333.33 918.87
Register of Deeds 1,735.00 3,083.33 17,577.75 24,666.67 -7,088.92
Treasurer 347.50 583.33 2,186.31 4,666.67 -2,480.36
Clerk of the District Court 2,810.45 2,916.67 34,485.06 23,333.33 11,151.73
Emergency Management 0.00 2,500.00 6,474.00 20,000.00 -13,526.00
Coroner 1,746.00 0.00 10,457.46 0.00 10,457.46
Fair 4,748.00 2,500.00 21,419.50 20,000.00 1,419.50
Museum 0.00 0.00 22,630.14 0.00 22,630.14
Election 28.40 166.67 2,058.93 1,333.33 725.60
Appraiser 1,389.12 1,083.33 4,630.78 8,666.67 -4,035.89
Planning & Development 1,760.00 2,500.00 28,749.00 20,000.00 8,749.00
Information Systems 0.61 0.00 17,634.18 0.00 17,634.18
Public Works 53,761.96 35,833.33 367,737.31 286,666.67 81,070.64
Noxious Weed 18,524.05 12,500.00 105,730.36 100,000.00 5,730.36
Total Before Transfers 375,292.61 258,400.00 23,358,403.23 22,195,131.00 1,163,272.23
Transfers In 9,698.10 0.00 35,417.99 0.00 35,417.99
Total After Transfers 384,990.71 258,400.00 23,393,821.22 22,195,131.00 1,198,690.22
Over/Under Budget Before Transfers 45.24% 5.24%
Over/Under Budget After Transfers 48.99% 5.40%
Prepared by Shilo Heger
09/07/2017
11.a
Packet Pg. 14
Att
ach
men
t: A
ug
ust
201
7 F
inan
cial
Rep
ort
ing
(59
42 :
Sep
tem
ber
201
7 T
reas
ure
r's
Rep
ort
)
2017 General Fund Revenue
Year To DateAugust Year To Date
Actual Budget Actual Budget
% of Budget
Collected
Motor Vehicle
Motor Vehicle 0.00 0.00 861,329.34 1,607,125.00 53.59%
Vehicle Rental Excise 0.00 0.00 15,065.13 29,690.00 50.74%
Recreational Vehicle 0.00 0.00 7,796.91 15,047.00 51.82%
Commercial Vehicles 0.00 0.00 78,066.07 74,739.00 104.45%
Ad Valorem
RL/Oil/PP 0.00 0.00 18,187,301.79 19,103,535.00 95.20%
Intangible 0.00 0.00 248,876.53 194,895.00 127.70%
16/20 M Trucks 0.00 0.00 11,725.91 14,418.00 81.33%
Watercraft 0.00 0.00 7,571.43 8,829.00 85.76%
Delinquent Tax 0.00 0.00 188,444.74 0.00 0.00%
Sales Tax 149,020.49 133,333.33 1,146,027.68 1,600,000.00 71.63%
Payment In Lieu of Tax 0.00 36,192.00 35,000.00 103.41%
City/County Highway 0.00 889,944.54 1,026,082.00 86.73%
Interest/Penalties 17,077.86 10,416.67 127,373.56 125,000.00 101.90%
Investment Interest 33,833.71 11,666.67 216,004.93 140,000.00 154.29%
Mortgage Registration Fees 37,504.99 12,500.00 291,366.23 150,000.00 194.24%
Recording Fees 31,854.00 20,833.33 247,939.00 250,000.00 99.18%
Hertiage Trust Fund 3,100.00 0.00 23,355.00 0.00 0.00%
Juvenile Supervision Fees 25.00 25.00 750.00 300.00 250.00%
Diversion Fees 12,445.68 5,666.67 45,623.95 68,000.00 67.09%
Franchise Fees 0.00 0.00 30,922.51 43,257.00 71.49%
Miscellaneous 3,210.04 0.00 51,703.00 0.00 0.00%
Departments
Clerk 369.75 291.67 3,252.20 3,500.00 92.92%
Register of Deeds 1,735.00 3,083.33 17,577.75 37,000.00 47.51%
Treasurer 347.50 583.33 2,186.31 7,000.00 31.23%
Clerk of the District Court 2,810.45 2,916.67 34,485.06 35,000.00 98.53%
Emergency Management 0.00 2,500.00 6,474.00 30,000.00 21.58%
Coroner 1,746.00 0.00 10,457.46 0.00 0.00%
Fair 4,748.00 2,500.00 21,419.50 30,000.00 71.40%
Museum 0.00 0.00 22,630.14 0.00 0.00%
Election 28.40 166.67 2,058.93 2,000.00 102.95%
Appraiser 1,389.12 1,083.33 4,630.78 13,000.00 35.62%
Planning & Development 1,760.00 2,500.00 28,749.00 30,000.00 95.83%
Information Systems 0.61 0.00 17,634.18 0.00 0.00%
Public Works 53,761.96 35,833.33 367,737.31 430,000.00 85.52%
Noxious Weed 18,524.05 12,500.00 105,730.36 150,000.00 70.49%
Total Before Transfers 375,292.61 258,400.00 23,358,403.23 25,253,417.00 92.50%
Transfers In 9,698.10 0.00 35,417.99 0.00 0.00%
Total After Transfers 384,990.71 258,400.00 23,393,821.22 25,253,417.00 92.64%
Over/Under Budget Before Transfers 45.24%
Over/Under Budget After Transfers 48.99%
August = 66.67% of the Budget
Prepared by Shilo Heger 09/07/2017
11.a
Packet Pg. 15
Att
ach
men
t: A
ug
ust
201
7 F
inan
cial
Rep
ort
ing
(59
42 :
Sep
tem
ber
201
7 T
reas
ure
r's
Rep
ort
)
Sales Tax Received
August 31, 2017
County General Road & Bridge Cap Fund
2016 2017 2016 2017
Prior Year
Variance Total Collected 2016 Budget
% Over
Budget
January (Nov Sales) 144,138.52 145,701.24 144,138.52 145,701.24 1.08% 291,402.48 266,666.66 9.28%
February (Dec sales) 177,218.45 170,690.79 177,218.44 170,690.79 -3.68% 341,381.58 266,666.66 28.02%
March (Jan sales) 117,555.02 122,172.87 117,555.01 122,172.86 3.93% 244,345.73 266,666.66 -8.37%
April (Feb sales) 134,507.52 136,253.62 134,507.51 136,253.62 1.30% 272,507.24 266,666.66 2.19%
May (Mar sales) 158,869.37 149,024.25 158,869.37 149,024.25 -6.20% 298,048.50 266,666.67 11.77%
June (Apr sales) 140,944.73 136,969.00 140,944.72 136,969.00 -2.82% 273,938.00 266,666.67 2.73%
July (May sales) 144,794.61 136,195.42 144,794.61 136,195.41 -5.94% 272,390.83 266,666.67 2.15%
August (June sales) 149,435.68 149,020.49 149,435.68 149,020.48 -0.28% 298,040.97 266,666.67 11.77%
September (July sales) 147,533.93 147,533.93 -100.00% 0.00 266,666.67 -100.00%
October (Aug sales) 151,012.53 151,012.53 -100.00% 0.00 266,666.67 -100.00%
November (Sept sales) 171,783.23 171,783.23 -100.00% 0.00 266,666.67 -100.00%
December (Oct sales) 151,970.54 151,970.54 -100.00% 0.00 266,666.67 -100.00%
Year to Date $1,789,764.13 $1,146,027.68 $1,789,764.09 $1,146,027.65 -35.97% $2,292,055.33 $3,200,000.00 -28.37%
2016 2017
Sales Tax Collected $3,579,528.22 $2,292,055.33
Budget $3,200,000.00 $3,200,000.00
% of Budget Collected 111.86% 71.63%
% Over Budget 11.86% 4.96%
Prepared by Shilo Heger 09/07/2017
11.a
Packet Pg. 16
Att
ach
men
t: A
ug
ust
201
7 F
inan
cial
Rep
ort
ing
(59
42 :
Sep
tem
ber
201
7 T
reas
ure
r's
Rep
ort
)
Year to Date Sales tax down by 1.37% compared to August 2016
Sales tax up by 9.55% compared to July 2017
11.a
Packet Pg. 17
Att
ach
men
t: A
ug
ust
201
7 F
inan
cial
Rep
ort
ing
(59
42 :
Sep
tem
ber
201
7 T
reas
ure
r's
Rep
ort
)
Updated: 9/12/2017 12:31 PM by Doug Schmitt Page 1
EMERGENCY MANAGEMENT Purchase
Pat Collins
Emergency Management
Director
115 North 4th Street
Manhattan, KS 66502
Phone: 785-537-6333
COMMISSION AGENDA REPORT
FROM: Patrick R Collins, Fire Chief
MEETING: September 14, 2017
SUBJECT: Purchase Authorization for Water Line to Ogden Fire Station
PRESENTER: Doug Schmitt, Asst. Fire Chief
BACKGROUND
As we prepare to build the new fire station in Ogden we have requested Free Water
and Sewer from the City of Ogden municipal utilities. The City Council has
agreed to provide us with these utilities if we provide the connecting service lines.
The city also agreed to provide the fire hydrant and install the water line if we
supplied the piping. The city provided two quotes from the suppliers that they
normally purchase from. The attached quote from Municipal Supply Inc was
lower than Salina Supply by close to $3000. We just received the Right of Way
permit from KDOT and the city would like to expedite this project as the supplier
has the pipe in stock and they feel the price will go up based on the recent and
upcoming natural disasters. The city of Ogden has the seasonal personnel to
perform this installation at this time.
FISCAL IMPACT
The fiscal impact on the fire district would be $8570 for the pipe on the attached
quote. The city is accepting the fiscal responsibility for the Fire Hydrant and all the
installation costs. This purchase will be outside the USDA loan project.
RECOMMENDATION(S)
Staff recommends that this purchase be authorized using funds from the fire
district operating budget 183-183.
12
Packet Pg. 18
Action Item (ID # 5944) Meeting of September 14, 2017
Updated: 9/12/2017 12:31 PM by Doug Schmitt Page 2
POSSIBLE MOTION(S)
Move to approve the purchase authorization form for the purchase of water line for
the Ogden Fire Station from Municipal Supply Inc.
Move to deny
Move to modify
Move to table
No action required.
The Board agreed by consensus to
12
Packet Pg. 19
Action Item (ID # 5944) Meeting of September 14, 2017
Updated: 9/12/2017 12:31 PM by Doug Schmitt Page 3
12
Packet Pg. 20
Action Item (ID # 5944) Meeting of September 14, 2017
Updated: 9/12/2017 12:31 PM by Doug Schmitt Page 4
Enclosures: Ogden Waterline Invoice (PDF)
Ogden Waterline PA (PDF)
12
Packet Pg. 21
Updated: 9/12/2017 4:11 PM by Cindy Kabriel Page 1
HEALTH DEPARTMENT Personnel
Jennifer Green
Health Department
Director
2030 Tecumseh Rd
Manhattan, KS 66502
Phone: 785-776-4779
COMMISSION AGENDA REPORT
FROM: Jennifer Green
MEETING: September 14, 2017
SUBJECT: September 2017- Health Department Staff Report
PRESENTER: Jennifer Green
AGENDA
A. Review of RCHD August 2017 Budget to Actual Comparison of Revenues and
Expense (66.7% Of year*) (See attachment)
EXPENSES
Child care Licensing: Geary County not included in the budget
Emergency Preparedness: Bugapalloza and the spending of special ebola/communicable
disease funds that were not budgeted for the current year and end of grant cycle
Smart Start/ECBG/RR: timing of expenses (end of grant cycle)
Wildcat Region PHEP: timing of expenes (end of grant cycle)
B. Community Partners Meeting: October 12th, 3:30pm-5pm. We will provide an
update on our strategic planning process, our efforts toward PHAB accreditation, and get
feedback from the public about how else we can better engage the public. Invitations will
be sent out on September 13th.
C. Okt-Flu-Ber Fest: Family friendly flu shot clinic. October 26th, 1:30-7pm at Riley
County Health Department (Family Child and Resource Center). Free pumpkins with
each flu shot. Ft. Riley Public Health will be onsite to administer shots for Tricare
13
Packet Pg. 24
Action Item (ID # 5945) Meeting of September 14, 2017
Updated: 9/12/2017 4:11 PM by Cindy Kabriel Page 2
families. We are encouraging families to complete their paperwork in advance to a quick
check-in. Paperwork is available online
http://www.rileycountyks.gov/CivicAlerts.aspx?AID=824
As we gear up for flu season, we are asking the public to call and make an appointment for
services. This will increase efficiency in the client and decrease wait time for clients. The
public can call 785-776-4770 ext 7600 for an appointment.
D. Hiring: Currently conducting interviews for the Maternal and Child Health Public Health
Nurse
E. EMR Demos: We have completed 5 EMR demonstrations scheduled with vendors
through the month of August. We are working with the other counties (Johnson,
Wyandotte, Shawnee, Lawrence-Douglas) to begin an RFP process. We anticipate
selecting a vendor and purchasing by the end of 2018 (June 30).
F. Strategic Planning and Accreditation Update
In progress
Workforce Development Plan (Fall 2017)
Branding Strategy (Fall 2017)
Community Health Improvement Plan (Fall 2017)
Health Promotion and Disease Prevention Plan (Fall 2017)
Community Partners Day - October 12th
Reviewing Domans 1-4 (of 12) of the PHAB Measures and Standards.
Quality Improvement Staff Professional Devleopment (September 12)
G. Out of State Travel Request: Jennifer Green- Hudson Symposium, Oklahoma City
FISCAL IMPACT
In 2015 Jennifer Green was selected to be a Leslie and Cliff Hudson Fellow at the University of
Oklahoma Health Sciences Center. Tuesday, September 19, 2017 the Hudson Symposium will
be held at the University of Oklahoma College of Public Health in Oklahoma City, Oklahoma.
The guest speaker will be Alfred Sommer, Dean Emeritus, Johns Hopkins Bloomberg School of
Public Health. In addition, a former Hudson Fellow Jennifer has been asked to speak on a panel
about our current work in public health at Riley County Health Department. (See attached flyer
and intinerary).
13
Packet Pg. 25
Action Item (ID # 5945) Meeting of September 14, 2017
Updated: 9/12/2017 4:11 PM by Cindy Kabriel Page 3
The Hudson symposium presents an opportunity for Jennifer to speak about the public health of
initiatives of Riley County Health Department. In addition, the symposium is an opportunity to
network and learn best practices from other public health professionals.
The projected expense is $565.29. This trip round trip mileage, lodging, and meals. Lodging
and meals have been already paid by the University of Oklahoma Health Sciences Center. I will
drive my own personal vehicle. Mileage will be reimbursed.
Mileage: $407
Lodging: 316.59 (2 nights)
Meals: $0 (provided at the symposium and reception)
I recommend that the board move to approve my travel request.
POSSIBLE MOTION(S) Move to approve
Move to deny
Move to modify
Move to table
No action required.
The Board agreed by consensus to
G. Out of State Travel Request: Daniel Perez- Ft. Lauderdale, Florida
Background
Healthy Babies are Worth the Wait (HBWW) is an initiative created by March of
Dimes and Johnson & Johnson in an attempt to eliminate preventable preterm
births. HBWW interventions include consumer and professional education, public
health interventions that augment existing public health services, and clinical
interventions in prenatal and pre-/interconception periods. The goals of HBWW
are:
To decrease preterm births by providing resources to increase knowledge about
factors that cause preterm birth.
To change the attitudes and behaviors of providers and consumers in order to
impact community-specific risk factors.
To implement strategies to prevent preterm births.
FISCAL IMPACT
13
Packet Pg. 26
Action Item (ID # 5945) Meeting of September 14, 2017
Updated: 9/12/2017 4:11 PM by Cindy Kabriel Page 4
The conference will take place on October 12-13 in Ft. Lauderdale Florida. I will
be flying out of our local Manhattan Regional Airport on Thursday October 12th
and returning on October 14th
Cost of flight will be $850.40
Cost of Hotel will be $358
Cost of food will not exceed $78
Total cost: $1327.40
Flight and Hotel paid for by HBWW*
Actual cost: $78
POSSIBLE MOTION(S)
I recommend that the board move to approve my travel request.
Enclosures: 2017 budget to actual (PDF)
2017 Okt-FLU-ber Fest 2017 Full (PUB)
Hudson Symposium Invite (JPG)
out of state travel packet jgreen (PDF)
out of state travel d perez (PDF)
13
Packet Pg. 27
BUDGETED BEG. CASH BAL. $380,232.00 January 1, 2017- August 31, 2017
ACTUAL BEG. CASH BAL. $1,046,472.55
Total Total
Budget Actuals
Revenues Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual
Grants 1,973,194.00 1,590,088.23 50,939.00 51,437.08 648,441.00 473,132.00 75,000.00 50,861.00 88,852.00 141,339.00 103,649.00 16,674.00 12,850.00 105,246.00 79,641.00 212,000.00 159,000.00 657,727.00 551,796.54 51,198.00 38,354.00 10,000.00 - 28,769.00 31,376.61
Client Fees 111,000.00 64,220.74 - - 200.00 11,000.00 8,564.50 33,000.00 17,924.71 58,000.00 31,196.57 1,000.00 1,870.00 - - - 8,000.00 4,464.96 - - -
Medicaid 34,650.00 27,484.24 - - - 11,250.00 9,881.41 18,000.00 12,610.89 5,000.00 4,358.29 - - - 400.00 633.65 - - -
Insurance 300,000.00 218,181.80 - - - 35,000.00 26,264.80 250,000.00 179,771.33 1,000.00 1,532.52 - - - 14,000.00 10,613.15 - - -
Transfer from General 1,154,526.00 1,154,526.00 1,154,526.00 1,154,526.00 - - - - - - - - - - - - - - - -
Miscellaneous 31,860.00 37,986.53 31,860.00 28,102.71 - - 1,600.00 - - 216.29 - - - 10.00 - 1,226.27 - 113.27 - 6,717.99 -
TOTALS 3,605,230.00 3,167,487.54 1,186,386.00 1,182,628.71 50,939.00 51,437.08 648,441.00 474,932.00 - 75,000.00 61,861.00 97,416.50 220,589.00 157,936.21 342,674.00 236,428.79 112,246.00 87,401.81 212,000.00 159,010.00 657,727.00 553,022.81 73,598.00 54,179.03 10,000.00 6,717.99 28,769.00 31,376.61
% of Budget Received 87.86% 99.68% 100.98% 73.24% 157.48% 71.60% 69.00% 77.87% 75.00% 84.08% 73.61% 67.18% 109.06%
Expenses Total Budget Total Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual
Total Personnel 2,602,541.00 1,518,265.23 361,431.00 181,901.38 65,633.00 39,660.17 591,411.00 340,122.65 - - 69,813.00 77,749.02 327,517.00 173,085.20 155,439.00 90,139.67 169,419.00 94,188.24 417,711.00 249,081.07 259,680.00 165,573.20 184,487.00 106,433.31 - - - 331.32
Total Contract 762,725.00 451,509.58 168,030.00 52,375.20 4,400.00 4,644.08 32,030.00 11,997.43 - 151.00 4,375.00 4,118.83 25,150.00 15,355.83 9,450.00 3,221.26 4,580.00 1,663.26 49,930.00 36,261.31 431,530.00 308,621.67 20,000.00 8,740.44 - 502.19 13,250.00 3,857.08
Total Commodities 441,294.00 202,072.47 8,750.00 1,290.42 2,000.00 13,032.49 25,000.00 14,136.57 - - 750.00 599.55 70,600.00 27,042.88 266,425.00 81,615.05 300.00 684.96 5,150.00 3,049.75 32,500.00 38,789.40 4,300.00 4,439.24 10,000.00 1,768.60 15,519.00 15,623.56
Capital 178,902.00 26,363.83 178,902.00 10,690.05 7,265.06 78.54 204.10 62.34 183.96 251.81 - 7,627.97
TOTALS 3,985,462.00 2,198,211.11 717,113.00 246,257.05 72,033.00 64,601.80 648,441.00 366,256.65 - 151.00 74,938.00 82,467.40 423,267.00 215,562.45 431,314.00 175,180.08 174,299.00 96,536.46 472,791.00 288,454.47 723,710.00 513,168.23 208,787.00 119,864.80 10,000.00 2,270.79 28,769.00 27,439.93
% of Budget Spent 55.16% 34.34% 89.68% 56.48% 110.05% 50.93% 40.62% 55.39% 61.01% 70.91% 57.41% 22.71% 95.38%
BALANCE:
EXCESS/(DEF.) BUDGET 469,273.00 (21,094.00) - (13,077.00) (202,678.00) (88,640.00) (62,053.00) (260,791.00) (65,983.00) (135,189.00) - -
EXCESS/(DEF.) ACTUAL 936,371.66 (13,164.72) 108,675.35 74,849.00 14,949.10 (57,626.24) 61,248.71 (9,134.65) (129,444.47) 39,854.58 (65,685.77) 4,447.20 3,936.68
ENDING CASH BAL. 2,015,748.98
Wildcat Region PHEP
66.7% of year
MCH Healthy Families Contract Smart Start/ECBG State Formula March of Dimes
RILEY COUNTY HEALTH DEPARTMENT
2017 Budget to Actual Comparison of Revenues and Expenses
General Emergency Preparedness WIC Kansas Health Foundation Child Care Licensing Family Planning Immunization Action Plan
13.a
Packet Pg. 28
Att
ach
men
t: 2
017
bu
dg
et t
o a
ctu
al (
5945
: S
epte
mb
er 2
017
Hea
lth
Dep
artm
ent
Mo
nth
ly B
ud
get
Rev
iew
Okt-FLU-ber Fest
Thursday, October 26th
1:30pm– 7:00pm
*Vaccine registration closes at 6pm
Riley County Health Department Campus
2101 Claflin Rd, Manhattan KS
Visit our website and complete your registration paperwork in advance for a
speedy check in!
The CDC recommends a yearly vaccine as the first and most important step in protecting not only you, but
also your loved ones against flu viruses. For more information on this event call the Health Department at
(785) 776-4779; for additional flu related information visit www.cdc.gov/flu/
Kids Games
& Books
Healthy Snacks
FREE Pumpkin
with Flu Shot
Face Painting
Join the Riley County Health Department for a family
friendly and fun flu shot clinic
MUCH MORE!
13.b
Packet Pg. 29
Att
ach
men
t: 2
017
Okt
-FL
U-b
er F
est
2017
Fu
ll (
5945
: S
epte
mb
er 2
017
Hea
lth
Dep
artm
ent
Mo
nth
ly B
ud
get
Rev
iew
an
d R
epo
rt t
o t
he
Bo
ard
of
13.d
Packet Pg. 31
Att
ach
men
t: o
ut
of
stat
e tr
avel
pac
ket
jgre
en (
5945
: S
epte
mb
er 2
017
Hea
lth
Dep
artm
ent
Mo
nth
ly B
ud
get
Rev
iew
an
d R
epo
rt t
o t
he
Bo
ard
of
Hea
lth
)
13.d
Packet Pg. 32
Att
ach
men
t: o
ut
of
stat
e tr
avel
pac
ket
jgre
en (
5945
: S
epte
mb
er 2
017
Hea
lth
Dep
artm
ent
Mo
nth
ly B
ud
get
Rev
iew
an
d R
epo
rt t
o t
he
Bo
ard
of
Hea
lth
)
13.d
Packet Pg. 33
Att
ach
men
t: o
ut
of
stat
e tr
avel
pac
ket
jgre
en (
5945
: S
epte
mb
er 2
017
Hea
lth
Dep
artm
ent
Mo
nth
ly B
ud
get
Rev
iew
an
d R
epo
rt t
o t
he
Bo
ard
of
Hea
lth
)
13.d
Packet Pg. 34
Att
ach
men
t: o
ut
of
stat
e tr
avel
pac
ket
jgre
en (
5945
: S
epte
mb
er 2
017
Hea
lth
Dep
artm
ent
Mo
nth
ly B
ud
get
Rev
iew
an
d R
epo
rt t
o t
he
Bo
ard
of
Hea
lth
)
13.d
Packet Pg. 35
Att
ach
men
t: o
ut
of
stat
e tr
avel
pac
ket
jgre
en (
5945
: S
epte
mb
er 2
017
Hea
lth
Dep
artm
ent
Mo
nth
ly B
ud
get
Rev
iew
an
d R
epo
rt t
o t
he
Bo
ard
of
Hea
lth
)
13.d
Packet Pg. 36
Att
ach
men
t: o
ut
of
stat
e tr
avel
pac
ket
jgre
en (
5945
: S
epte
mb
er 2
017
Hea
lth
Dep
artm
ent
Mo
nth
ly B
ud
get
Rev
iew
an
d R
epo
rt t
o t
he
Bo
ard
of
Hea
lth
)
13.d
Packet Pg. 37
Att
ach
men
t: o
ut
of
stat
e tr
avel
pac
ket
jgre
en (
5945
: S
epte
mb
er 2
017
Hea
lth
Dep
artm
ent
Mo
nth
ly B
ud
get
Rev
iew
an
d R
epo
rt t
o t
he
Bo
ard
of
Hea
lth
)
13.e
Packet Pg. 38
Att
ach
men
t: o
ut
of
stat
e tr
avel
d p
erez
(59
45 :
Sep
tem
ber
201
7 H
ealt
h D
epar
tmen
t M
on
thly
Bu
dg
et R
evie
w a
nd
Rep
ort
to
th
e B
oar
d o
f H
ealt
h)
Updated: 9/5/2017 12:19 PM by Tami Robison Page 1
COUNTY CLERK & ELECTIONS Budget
Rich Vargo
County Clerk
110 Courthouse Plaza
Manhattan, KS 66502
Phone: 785-565-6200
MEMORANDUM
FROM: Tami Robison, Budget & Finance Officer
MEETING: September 14, 2017
SUBJECT: Monthly Cash Flow Reports for August
PRESENTER: Tami Robison, Budget & Finance Officer
August Cash Flow Reports for the Capital Improvement Fund, Building Fund, Economic
Development Fund and Road & Bridge 1/2 Cent Sales Tax Fund.
Enclosures: cash flow reports 2017 2 (PDF)
14
Packet Pg. 39
$23,226 $13,723 $11,896 -$
$1,000,000 $3,158,472 Budgeted Rev. $1,008,900
$6,362,049 $6,171,216 % of Budgeted Rev. 417.02%
PROJECT #
Project
Code PROJECTS
PROJECT
ESTIMATE
PRIOR
EXPENDITURES
AMOUNT FOR
2017 1st Qtr Totals 2nd Qtr Totals Jul '17 Aug '17 Sep '17 3rd Qtr Totals
EXPENDITURES
IN 2017
EXPENDITURES
TO DATE
EST PROJECT
BALANCE
CLERK:
16-16CK001 Scanner-Model DS850 High Speed Digital $120,000 $0 $120,000 $0 $0 $0 $0 $0 $120,000
17-17CK001 Office Furniture Replacement $18,700 $0 $18,379 $0 $18,379 $0 $18,379 $18,379 $0
17-17CK002 Construct Private Office Walls $20,000 $0 $20,000 $0 $0 $0 $0 $0 $20,000
05-06CK002 200 Election System Upgrade $377,789 $345,831 $0 $0 $0 $0 $0 $345,831 $0
CLERK TOTALS $536,489 $345,831 $158,379 $0 $18,379 $0 $0 $0 $0 $18,379 $364,210
PUBLIC WORKS:
05-05PW011 64 Repair Courthouse Plaza Pavers $9,000 $5,094 $3,907 $0 $0 $0 $0 $5,094 $3,907
13-13PW005 Design cost for 2 culverts $35,000 $0 $35,000 $0 $0 $0 $0 $0 $35,000
13-13PW009 Motor Grader Lease Payment (2013 10yrs) $560,923 $165,181 $55,060 $0 $0 $55,060 $55,060 $55,060 $220,242 $0
14-14PW004 Design cost for 1 culvert $35,000 $0 $35,000 $0 $0 $0 $0 $0 $35,000
14-14PW006 71 Replace CICO exercise trail $20,000 $10,045 $9,955 $0 $0 $0 $0 $10,045 $9,955
14-14PW013 71 Asphalt Path Replacement at CICO $111,545 $51,706 $59,839 $0 $0 $0 $0 $51,706 $59,839
15-15PW006 Randolph Community Park (PW) (2017 $24K exp) $36,000 $0 $36,000 $0 $0 $0 $0 $0 $36,000
15-15PW005 320 Remove Stormwater from Sanitary Sewer-Salt Bldg Ext $290,000 $136,922 $160,091 $0 $368 $129,364 $5,575 $134,939 $135,306 $272,229 $24,785
16-16LEC001 55 Jail Intercom System $210,000 $106,546 $0 $0 $0 $0 $0 $106,546 $0
16-16PK002 Fairgrounds ADAWalkway $30,000 $0 $30,000 $0 $0 $0 $0 $0 $30,000
16-16PK003 Parking lot for CICO Playground $18,000 $0 $18,000 $0 $0 $0 $0 $0 $18,000
16-16PK004 Street & Parking Lot Development at Fairmont $45,000 $0 $45,000 $0 $0 $0 $0 $0 $45,000
16-16PK005 Asphalt Path Replacement in CICO Park $20,000 $0 $20,000 $0 $0 $0 $0 $0 $20,000
16-16PW006 447 Fancy Creek Bridge $516,992 $407,268 $109,724 $109,724 $0 $0 $109,724 $516,992 $0
16-16PW007 1/2T 4x4 Ext. Cab Pickup $28,000 $0 $24,764 $0 $24,764 $0 $24,764 $24,764 $0
16-16-PW008 3/4T 4x4 Ext. Cab Pickup $28,000 $0 $28,739 $28,739 $0 $0 $28,739 $28,739 $0
16-16PW009 3/4T 4x4 Ext. Cab Pickup $28,000 $0 $28,739 $28,739 $0 $0 $28,739 $28,739 $0
16-16PW003 Replace Health Dept Roof $33,000 $0 $33,000 $0 $0 $0 $0 $0 $33,000
16-16-PW010 One Ton Service Truck $100,000 $0 $100,000 $0 $42,610 $14,324 $14,324 $56,934 $56,934 $43,066
16-16PW012 Construct Equipment Storage Bldg at Winkler $40,000 $0 $40,000 $0 $0 $0 $0 $0 $40,000
17-17PW001 Fairmont Shelter House (PW trx) (2017 exp) $13,000 $0 $13,000 $0 $0 $0 $0 $0 $13,000
17-17PW002 New Roof on Museum $30,000 $0 $30,000 $0 $0 $0 $0 $0 $30,000
17-17PW003 Remodel 5 Rooms FCRC $38,000 $0 $38,000 $0 $0 $0 $0 $0 $38,000
17-17PW004 3/4T 4x4 Truck $29,628 $0 $29,628 $0 $0 $0 $0 $0 $29,628
17-17PW005 40-60 KW Generator $28,000 $0 $28,000 $0 $0 $0 $0 $0 $28,000
17-17PW006 Backhoe $185,000 $0 $185,000 $0 $0 $0 $0 $0 $185,000
PUBLIC WORKS TOTALS $2,518,088 $882,763 $1,196,446 $167,202 $67,742 $198,748 $5,575 $0 $204,323 $439,267 $1,322,030
BOCC:
14-14BOCC001 89 Courthouse Security($25,000 RCPD)/Waterproofing $574,627 $531,805 $42,822 $114 $12,486 $1,672 $454 $2,126 $14,725 $546,531 $28,096
BOCC TOTALS $574,627 $531,805 $42,822 $114 $12,486 $1,672 $454 $0 $2,126 $14,725 $546,531
EMERGENCY MNGT SERVICE
13-13AM001 302 Design of the EMS Facility Enhancement $100,000 $9,500 $90,500 $0 $0 $0 $0 $9,500 $90,500
15-15AM001 Ambulance (2) (2017 Lease Purchase) $485,472 $101,540 $101,540 $0 $101,540 $0 $101,540 $203,080 $0
16-16AM002 SUV Replacement $38,000 $0 $35,605 $35,605 $0 $0 $35,605 $35,605 $0
EMERGENCY MNGT SERVICE TOTALS $623,472 $111,040 $227,645 $35,605 $101,540 $0 $0 $0 $0 $137,145 $248,185
INFORMATION TECHNOLOGY
17-17IT001 Ambulance Bldg Network/Server $25,000 $0 $25,000 $0 $0 $2,309 $4,935 $7,244 $7,244 $7,244 $17,756
17-17IT002 10GB Network Backbone $50,000 $0 $50,000 $0 $0 $50,000
INFORMATION TECHNOLOGY TOTALS $75,000 $0 $75,000 $0 $0 $2,309 $4,935 $0 $7,244 $7,244 $7,244
PLANNING & DEVELOPMENT
17-17PD001 Planning/Permitting Software $50,000 $0 $50,000 $0 $0 $0 $0 $0 $50,000
PLANNING & DEVELOPMENT TOTALS $50,000 $0 $50,000 $0 $0 $0 $0 $0 $0 $0 $0
2017 Riley County CIP Cash Flow AnalysisREVENUE
TRANSFERS/REIMB
BEG UNENCUMBERED CASH (Budget $2,042,835)
14.a
Packet Pg. 40
Att
ach
men
t: c
ash
flo
w r
epo
rts
2017
2 (
5928
: M
on
thly
Cas
h F
low
Rep
ort
s)
2017 Riley County CIP Cash Flow Analysis
PROJECT #
Project
Code PROJECTS
PROJECT
ESTIMATE
PRIOR
EXPENDITURES
AMOUNT FOR
2017 1st Qtr Totals 2nd Qtr Totals Jul '17 Aug '17 Sep '17 3rd Qtr Totals
EXPENDITURES
IN 2017
EXPENDITURES
TO DATE
EST PROJECT
BALANCE
NOXIOUS WEED
16-16NW002 Wood Chipper $60,000 $0 $60,000 $0 $0 $0 $0 $0 $60,000
16-16NW003 1.5T Spray Truck & Sprayer $75,000 $0 $75,000 $0 $20,199 $0 $20,199 $20,199 $54,801
NOXIOUS WEED TOTALS $135,000 $0 $135,000 $0 $20,199 $0 $0 $0 $0 $20,199 $20,199
EMERGENCY MANAGEMENT
16-16EM001 Generator for Top of the World $40,000 $40,000 $0 $0 $0 $0 $0 $40,000
16-16EM002 Standby/Backup Generator Pottorf Hall $40,000 $0 $40,000 $0 $0 $0 $0 $0 $40,000
EMERGENCY MANAGEMENT TOTALS $80,000 $0 $80,000 $0 $0 $0 $0 $0 $0 $0 $0
Transfer to B&I 2010-B G.O. Bond payment (15 yr. term) $202,169 $202,169 $0 $0 $202,169 $202,169 $0
TOTAL EXPENDITURES $405,090 $220,346 $202,729 $10,964 $0 $213,693 $839,128 $2,710,568 $1,328,333
CURRENT CASH BALANCE $3,410,200 $6,362,049 $6,171,216 $6,160,252
Completed Projects
Projects On-Hold
Beginning Unencumbered Cash $2,792,064
Current 2017 Revenue $4,207,316
Minus Actual Expenditures in 2017 $839,128
Current Cash Balance $6,160,252 2017 CIP Budget $3,051,735 Expended % of Year
Minus Dedicated Funds (Est Project Balance Column) $1,328,333 Expenditures-to-date, 2017 Budget $839,128 27.50% 66.67%
Projected Unrestricted 2017 Cash $4,831,919 (Incl. Ambulance/Fair Reserve) $65,233 Remaining Budget Authority for 2017 $2,212,607
Breakout of Ambulance Capital Reserve funds: Beginning Cash $157,020
(Included in the above cash)
Revenue/Transfers $0
Minus Actual Expenditures in 2017 $137,145
Current Cash Balance $19,875
Minus Dedicated Funds $0
Projected Unrestricted 2017 Cash $19,875
Unrestricted 2017 Cash w/out Fair & EMS Reserves $4,746,812 (Includes $500,000 CIP Reserve)
Budget Authority Summary
Riley County 2017 CIP
14.a
Packet Pg. 41
Att
ach
men
t: c
ash
flo
w r
epo
rts
2017
2 (
5928
: M
on
thly
Cas
h F
low
Rep
ort
s)
Jan $202,169
Feb $35,605
Mar $167,316
Apr $162,529
May $29,737
Jun $28,080
Jul $202,729
Budget -$3,051,735
Aug $10,964
$0
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
$3,000,000
$3,500,000
Total Spent Total Budget
Capital Improvement Fund
Jan Feb Mar Apr May Jun Jul Aug
14.a
Packet Pg. 42
Att
ach
men
t: c
ash
flo
w r
epo
rts
2017
2 (
5928
: M
on
thly
Cas
h F
low
Rep
ort
s)
Budgeted Rev. $380,000
% of Budgeted Rev. 92.43%
MONTH Jan '17 Feb '17 Mar '17 Apr '17 May '17 Jun '17 Jul '17 Aug '17 Sept '17 Oct '17 Nov '17 Dec '17 TOTAL
REVENUE $199,750 $20 $9,609 $0 $141,846 $10 $0 $0 $351,236
TRANSFERS
BEG UNENCUMBERED CASH (Budget $0) $75,183 $274,933 $261,252 $159,646 $145,115 $237,004 $209,785 $185,885
TOTAL EXPENDITURES $0 $13,701 $111,215 $14,531 $49,957 $27,229 $23,900 $6,479 $247,012
CURRENT CASH BALANCE $274,933 $261,252 $159,646 $145,115 $237,004 $209,785 $185,885 $179,406
2017 Budget $380,000 Expended % of Year
Expenditures-to-date, 2017 Budget $247,012 65.00% 66.67%
Remaining Budget Authority for 2017 $132,988
Riley County 2017 County Building
Budget Authority Summary
2017 RILEY COUNTY BUILDING FUND CASH FLOW ANALYSIS
14.a
Packet Pg. 43
Att
ach
men
t: c
ash
flo
w r
epo
rts
2017
2 (
5928
: M
on
thly
Cas
h F
low
Rep
ort
s)
Jan-$0Feb-$13,701
Mar-$111,215
Budget -$380,000
Apr-$14,531
May-$49,957
Jun-$27,229
Jul-$23,900
Aug-$6,479
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
TOTAL SPENT TOTAL BUDGET
County Building Fund
Jan Feb Mar Apr May Jun Jul Aug
14.a
Packet Pg. 44
Att
ach
men
t: c
ash
flo
w r
epo
rts
2017
2 (
5928
: M
on
thly
Cas
h F
low
Rep
ort
s)
MONTH Jan '17 Feb '17 Mar '17 Apr '17 May '17 Jun '17 Jul '17 Aug '17 Sept '17 Oct '17 Nov '17 Dec '17 Budgeted Rev. $360,000
REVENUE % of Budg. Rev. 100.00%
TRANSFERS $360,000
BEG UNENCUMBERED CASH (Budget $43,809) $145,084 $407,655 $257,655 $254,030 $245,840 $237,565 $226,590 $185,098
PROJECTS:
PROJECT
ESTIMATE
2017 BUDGETED
AMOUNT
2017
EXPENDITURES
ESTIMATED
BALANCE
APPROPRIATIONS:
Chamber of Commerce $40,000 $40,000 $20,000 $20,000 $40,000 $0
Downtown Manhattan, Inc. $3,000 $3,000 $1,500 $1,500 $3,000 $0
Flint Hills Veterans Coalition $800 $800 $400 $400 $800 $0
Flint Hills Regional Transit Admin $9,540 $9,540 $4,770 $4,770 $9,540 $0
Friends of Peace Mem. Auditorium $15,000 $15,000 $7,500 $7,500 $15,000 $0
Governor's Military Council $4,500 $4,500 $2,250 $2,250 $4,500 $0
Aggieville Business Assoc. $2,000 $2,000 $1,000 $1,000 $2,000 $0
Riley Co. General Eco Devo $74,922 $74,922 $0 $74,922
MEMBERSHIPS:
FHMPO Contribution $4,265 $4,265 $2,628 $523 $3,151 $1,114
FHRC Contribution $7,598 $0 $7,598 $7,598 $0
CONTRACTS:
Auto Lane Development(2024) $6,057 $6,057 $6,057 $6,057 $0
K18 Ramp Contribution $150,000 $150,000 $150,000 $150,000 $0
DEBT OBLIGATIONS:
Konza Water Debt Payment transfer $43,725 $43,725 $43,725 $43,725 $0
PROJECTS:
Project studies, design, engineer, etc. $50,000 $50,000 $0 $50,000
Re-write of Zoning&Subdivision
Regulations $103,810 $0 $3,625 $8,190 $8,275 $10,975 $3,550 $3,900 $38,515 $65,295
TOTAL EXPENDITURES $97,428 $150,000 $3,625 $8,190 $8,275 $10,975 $41,493 $3,900 $323,886 $191,331
CURRENT CASH BALANCE $407,655 $257,655 $254,030 $245,840 $237,565 $226,590 $185,098 $181,198
Completed Projects
Beginning Unencumbered Cash $145,084
Current 2017 Revenue $360,000
Minus Actual Expenditures in 2017 $323,886
Current Cash Balance $181,198 2017 Budget $403,809 Expended % of Year
Minus Dedicated Funds (Est. Balance Column) $191,331 Expenditures-to-date, 2017 Budget $323,886 80.21% 66.67%
Projected Unrestricted 2017 Cash -$10,133 Remaining Budget Authority for 2017 $79,923
Budget Authority Summary
Riley County 2017 Economic Development
2017 RILEY COUNTY ECONOMIC DEVELOPMENT FUND CASH FLOW ANALYSIS
14.a
Packet Pg. 45
Att
ach
men
t: c
ash
flo
w r
epo
rts
2017
2 (
5928
: M
on
thly
Cas
h F
low
Rep
ort
s)
Jan $97,428
Feb $150,000
Mar $3,625
Apr $8,190
May $8,275
Jun $10,975
Jul $41,493
Budget -$403,809
Aug $3,900
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
Total Spent Total Budget
Economic Development Fund
Jan Feb Mar Apr May Jun Jul Aug
14.a
Packet Pg. 46
Att
ach
men
t: c
ash
flo
w r
epo
rts
2017
2 (
5928
: M
on
thly
Cas
h F
low
Rep
ort
s)
2017 Riley County Road Bridge 1/2 Cent Sales Tax Fund Cash Flow Analysis
REVENUE $438,565 $422,247 $136,195 149,020.48$ Budgeted Rev. $1,600,000
Fund-Dept. REIMBURSEMENTS % of Budgeted Rev. 71.63%
157-158 $5,064,452 $4,973,021
Project
Code PROJECTS
PROJECT
ESTIMATE
PRIOR
EXPENDITURES
AMOUNT FOR 2017-
ESTIMATED 1st Qtr Totals 2nd Qtr Totals Jul '17 Aug '17 Sept '17
EXPENDITURES
IN 2017
EXPENDITURES
TO DATE
EST PROJECT
BALANCE
CULVERTS
437 Casement Drainage Outlet Structure $298,852 $298,852 $0 $0 $0 $0 $298,852 $0
442 West 54th Avenue $124,000 $25,344 $54,000 $0 $0 $0 $25,344 $98,656
310 Frog Holler $160,218 $160,218 $0 $0 $0 $0 $160,218 $0
440 Green Randolph Road $260,819 $260,819 $0 $0 $0 $0 $260,819 $0
441 N 52nd Street $139,894 $139,894 $0 $0 $0 $0 $139,894 $0
Sherman Road $83,000 $0 $12,000 $0 $0 $0 $0 $83,000
Flat Rock Road $113,500 $0 $0 $0 $0 $0 $0 $113,500
Vinton School Road $182,000 $0 $50,000 $0 $0 $0 $0 $182,000
Parallel Road $117,000 $0 $0 $0 $0 $0 $0 $117,000
Kitten Creek Road $148,000 $0 $50,000 $0 $0 $0 $0 $148,000
Peach Grove Road $104,000 $0 $50,000 $0 $0 $0 $0 $104,000
Fancy Creek Road I.2/6.3 $93,000 $0 $15,000 $0 $0 $0 $0 $93,000
Union Road $125,000 $0 $0 $0 $0 $0 $0 $125,000
BRIDGES
435 West 40th Bridge $349,501 $349,501 $0 $0 $0 $0 $349,501 $0
439 Daniels Drive $252,631 $252,631 $0 $0 $0 $0 $252,631 $0
425 Green Randolph $1,089,402 $771,018 $318,384 $99,768 $172,840 $45,776 $1,747 $320,131 $1,091,148 -$1,747
Fancy Creek F.5/5.9 $1,231,800 $0 $115,000 $0 $0 $0 $0 $1,231,800
Fancy Creek K.0/6.2 $653,800 $0 $0 $0 $0 $0 $0 $653,800
443 S. 32nd Street $160,743 $160,743 $0 $0 $0 $0 $160,743 $0
444 Parallel $208,990 $208,990 $0 $0 $0 $0 $208,990 $0
Rose Hill $654,200 $0 $0 $0 $0 $0 $0 $654,200
447 Fancy Creek E.2/5.6 $929,211 $687,307 $143,007 $48,100 $276,654 $154,886 $296 $479,936 $1,167,243 -$238,032
Anderson Avenue $1,050,000 $0 $115,000 $0 $0 $0 $0 $1,050,000
Stockdale Park $927,400 $0 $115,000 $0 $0 $0 $0 $927,400
Senn $454,500 $0 $0 $0 $0 $0 $0 $454,500
Bodaville $657,900 $0 $0 $0 $0 $0 $0 $657,900
448 Denison (Marlatt to City Limits) $3,951,470 $411,490 $735,000 $30,836 $51,200 $26,929 $123,566 $232,530 $644,020 $3,307,450
431 McDowell Creek Road (North End) $3,000,000 $515,848 $0 $0 $0 $0 $515,848 $2,484,152
OVERLAY
412 Anderson Ave. $470,000 $470,000 $0 $0 $0 $0 $470,000 $0
Welsh Road $175,000 $0 $175,000 $0 $0 $36 $36 $36 $174,964
414 Mill Cove/W. 59th $200,000 $200,000 $0 $0 $0 $0 $200,000 $0
Tabor Valley Road $410,928 $0 $0 $0 $0 $0 $0 $410,928
Kansas Ave/Crooked Creek $425,617 $0 $0 $0 $0 $0 $0 $425,617
Barton Road $509,418 $0 $0 $0 $0 $0 $0 $509,418
438 Fancy Creek Road $450,000 $450,000 $0 $0 $0 $0 $450,000 $0
University Park Road $259,910 $0 $0 $0 $0 $0 $0 $259,910
Tuttle Cove Road $512,622 $0 $0 $0 $0 $0 $0 $512,622
Barnes/Casement Road $386,690 $0 $0 $0 $0 $0 $0 $386,690
Scenic Drive $151,324 $151,324 $0 $0 $0 $0 $151,324 $0
TOTAL EXPENDITURES $178,704 $500,694 $227,627 $125,608 $0 $1,032,633 $6,546,612 $14,925,728
CURRENT CASH BALANCE $5,142,900 $5,064,452 $4,973,021 $4,996,433
Completed Projects
RECONSTRUCT
BEG UNENCUMBERED CASH (Budget $2,844,221)
14.a
Packet Pg. 47
Att
ach
men
t: c
ash
flo
w r
epo
rts
2017
2 (
5928
: M
on
thly
Cas
h F
low
Rep
ort
s)
2017 Riley County Road Bridge 1/2 Cent Sales Tax Fund Cash Flow Analysis
Beginning Unencumbered Cash 4,883,039$
Current 2017 Revenue 1,146,028$
Minus Actual Expenditures in 2017 1,032,633$
Current Cash Balance 4,996,433$ 2017 Budget $4,444,221 Expended % of Year
Remaining 2017 Projected Revenue 602,993$ Expenditures-to-date, 2017 Budget $1,032,633 23.24% 66.67%
Minus Dedicated Funds (Est.-Project Balance for Year) 1,078,187$
Projected Unrestricted 2017 Cash 4,521,239$ Remaining Budget Authority for 2017 $3,411,588
Riley Co. 2017 Road/Bridge 1/2 Cent Sales Tax
Budget Authority Summary
14.a
Packet Pg. 48
Att
ach
men
t: c
ash
flo
w r
epo
rts
2017
2 (
5928
: M
on
thly
Cas
h F
low
Rep
ort
s)
Jan $51,558
Feb $0
Mar $127,146
Apr $32,716
May $356,850
Jun $111,129
Jul $227,627
Budget -$4,444,221
Aug $125,608
$0
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
$3,000,000
$3,500,000
$4,000,000
$4,500,000
$5,000,000
Total Spent Total Budget
Road & Bridge 1/2 Cent Sales Tax Fund
Jan Feb Mar Apr May Jun Jul Aug
14.a
Packet Pg. 49
Att
ach
men
t: c
ash
flo
w r
epo
rts
2017
2 (
5928
: M
on
thly
Cas
h F
low
Rep
ort
s)
Updated: 8/30/2017 8:17 AM by Tami Robison Page 1
COUNTY CLERK & ELECTIONS Bond
Rich Vargo
County Clerk
110 Courthouse Plaza
Manhattan, KS 66502
Phone: 785-565-6200
MEMORANDUM
FROM: Tami Robison, Budget & Finance Officer
MEETING: September 14, 2017
SUBJECT: 2017 Riley County Preliminary Refinancing Analysis
PRESENTER: Greg Vahrenberg, Piper Jaffray & Co.
Because of the cost-savings potential, the Budget and Planning Committee requested Riley
County’s Financial Advisor, Greg Vahrenberg of Piper Jaffray & Co., to present preliminary
information for the Commission's consideration in supporting the refinancing of the 2009, 2010
and 2010B General Obligation Refunding Bonds.
Enclosures: Riley Co Preliminary Refinancing Analysis 08.15.2017 (PDF)
15
Packet Pg. 50
August 15, 2017
0
Preliminary Refinancing Analysis Presented to the:
Greg Vahrenberg Managing Director Tel: +1 913 345-3374 Email: [email protected]
0
15.a
Packet Pg. 51
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
PIPER JAFFRAY
Important Disclaimers
The information contained herein includes hypothetical interest rate savings for a potential refunding if interest rates in today’s market were applied to your existing debt structure. Interest rates used herein are hypothetical and take into consideration conditions in today’s market and other factual information such as your credit rating, geographic location and market sector. Interest rates described herein should not be viewed as rates that Piper Jaffray expects to achieve for you should we be selected to act as your underwriter or placement agent. Information about interest rates and terms for SLGs is based on current publically available information and treasury or agency rates for open-market escrows are based on current market interest rates for these types of credits and should not be seen as costs or rates that Piper Jaffray could achieve for you should we be selected to act as your underwriter or placement agent. More particularized information and analysis may be provided after you have engaged Piper Jaffray as an underwriter or placement agent or under certain other exceptions as describe in the Section 15B of the Exchange Act.
Piper Jaffray is providing the information contained herein for discussion purposes only in anticipation of being engaged to serve as underwriter or placement agent. Piper Jaffray seeks to serve as an underwriter or a placement agent and not as a financial advisor or municipal advisor. In providing the information contained herein, Piper Jaffray is not recommending an action to you and the information provided herein is not intended to be and should not be construed as a “recommendation” or “advice” within the meaning of Section 15B of the Securities Exchange Act of 1934. Piper Jaffray is not acting as an advisor to you and does not owe a fiduciary duty pursuant to Section 15B of the Exchange Act or under any state law to you with respect to the information and material contained in this communication. As an underwriter or placement agent, Piper Jaffray’s primary role is to purchase or arrange for the placement of securities with a view to distribution in an arm’s-length commercial transaction, is acting for its own interests and has financial and other interests that differ from your interests. You should discuss any information and material contained in this communication with any and all internal or external advisors and experts that you deem appropriate before acting on this information or material.
15.a
Packet Pg. 52
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
OUTSTANDING BONDS
15.a
Packet Pg. 53
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
Aug 15, 2017 12:52 pm Prepared by Piper Jaffray & Co.
SUMMARY OF BONDS REFUNDED
Riley County, KansasGeneral Obligation Refunding Bonds
Series 2017 (Issue Summary)-Preliminary, BQ-
Maturity Interest Par Call CallBond Date Rate Amount Date Price
2009:TERM02 09/01/2019 5.900% 20,000.00 11/01/2017 100.000
2010:TERM02 09/01/2020 3.375% 85,000.00 11/01/2017 100.000
2010B:TERM 09/01/2020 3.375% 470,000.00 11/01/2017 100.000TERM02 09/01/2025 4.125% 1,040,000.00 11/01/2017 100.000
1,510,000.00
1,615,000.00
15.a
Packet Pg. 54
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
REFINANCING ANALYSIS
15.a
Packet Pg. 55
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
Aug 15, 2017 12:52 pm Prepared by Piper Jaffray & Co.
SAVINGS
Riley County, KansasGeneral Obligation Refunding Bonds
Series 2017 (Issue Summary)-Preliminary, BQ-
Present ValuePrior Refunding to 11/01/2017
Date Debt Service Debt Service Savings @ 1.5406029%
09/01/2018 72,811.26 64,500.00 8,311.26 8,324.3309/01/2019 342,221.26 326,650.00 15,571.26 15,197.5609/01/2020 337,518.76 318,250.00 19,268.76 18,501.4709/01/2021 277,900.00 259,850.00 18,050.00 17,066.1409/01/2022 278,206.26 262,950.00 15,256.26 14,202.2309/01/2023 203,100.00 185,750.00 17,350.00 15,890.1409/01/2024 200,675.00 185,650.00 15,025.00 13,546.5509/01/2025 203,043.76 185,400.00 17,643.76 15,654.23
1,915,476.30 1,789,000.00 126,476.30 118,382.63
Savings Summary
PV of savings from cash flow 118,382.63Plus: Refunding funds on hand 6,008.90
Net PV Savings 124,391.53
15.a
Packet Pg. 56
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
Aug 15, 2017 12:52 pm Prepared by Piper Jaffray & Co.
SUMMARY OF REFUNDING RESULTS
Riley County, KansasGeneral Obligation Refunding Bonds
Series 2017 (Issue Summary)-Preliminary, BQ-
Refund Series Refund Series Refund Series2009 2010 2010-B Total
Dated Date 11/01/2017 11/01/2017 11/01/2017 11/01/2017Delivery Date 11/01/2017 11/01/2017 11/01/2017 11/01/2017Arbitrage Yield 1.540603% 1.540603% 1.540603% 1.540603%Escrow YieldValue of Negative Arbitrage
Bond Par Amount 25,000.00 85,000.00 1,470,000.00 1,580,000.00True Interest Cost 1.892953% 1.586494% 1.774719% 1.769761%Net Interest Cost 1.911568% 1.618606% 1.836414% 1.830467%Average Coupon 3.000000% 3.000000% 3.000000% 3.000000%Average Life 1.233 2.363 4.582 4.409
Par amount of refunded bonds 20,000.00 85,000.00 1,510,000.00 1,615,000.00Average coupon of refunded bonds 5.900000% 3.375000% 4.007440% 3.996890%Average life of refunded bonds 1.333 2.363 4.655 4.493
PV of prior debt 21,340.81 89,078.29 1,685,240.97 1,795,660.08Net PV Savings 561.36 1,894.31 121,935.85 124,391.52Percentage savings of refunded bonds 2.806800% 2.228600% 8.075222% 7.702261%Percentage savings of refunding bonds 2.245440% 2.228600% 8.294956% 7.872881%
15.a
Packet Pg. 57
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
Aug 15, 2017 12:52 pm Prepared by Piper Jaffray & Co.
SOURCES AND USES OF FUNDS
Riley County, KansasGeneral Obligation Refunding Bonds
Series 2017 (Issue Summary)-Preliminary, BQ-
Dated Date 11/01/2017Delivery Date 11/01/2017
Refund Series Refund Series Refund SeriesSources: 2009 2010 2010-B Total
Bond Proceeds:Par Amount 25,000.00 85,000.00 1,470,000.00 1,580,000.00Premium 585.60 3,624.30 93,067.55 97,277.45
25,585.60 88,624.30 1,563,067.55 1,677,277.45
Refund Series Refund Series Refund SeriesUses: 2009 2010 2010-B Total
Refunding Escrow Deposits:Cash Deposit 20,196.67 85,478.13 1,519,793.75 1,625,468.55
Cost of Issuance:Cost of Issuance 474.68 1,613.92 27,911.40 30,000.00
Underwriter's Discount:($10 / 1000) 250.00 850.00 14,700.00 15,800.00
Other Uses of Funds:Additional Proceeds 4,664.25 682.25 662.40 6,008.90
25,585.60 88,624.30 1,563,067.55 1,677,277.45
15.a
Packet Pg. 58
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
Aug 15, 2017 12:52 pm Prepared by Piper Jaffray & Co.
BOND DEBT SERVICE
Riley County, KansasGeneral Obligation Refunding Bonds
Series 2017 (Issue Summary)-Preliminary, BQ-
AnnualPeriod Debt DebtEnding Principal Coupon Interest Service Service
03/01/2018 15,800 15,80009/01/2018 25,000 3.000% 23,700 48,700 64,50003/01/2019 23,325 23,32509/01/2019 280,000 3.000% 23,325 303,325 326,65003/01/2020 19,125 19,12509/01/2020 280,000 3.000% 19,125 299,125 318,25003/01/2021 14,925 14,92509/01/2021 230,000 3.000% 14,925 244,925 259,85003/01/2022 11,475 11,47509/01/2022 240,000 3.000% 11,475 251,475 262,95003/01/2023 7,875 7,87509/01/2023 170,000 3.000% 7,875 177,875 185,75003/01/2024 5,325 5,32509/01/2024 175,000 3.000% 5,325 180,325 185,65003/01/2025 2,700 2,70009/01/2025 180,000 3.000% 2,700 182,700 185,400
1,580,000 209,000 1,789,000 1,789,000
15.a
Packet Pg. 59
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
Aug 15, 2017 12:52 pm Prepared by Piper Jaffray & Co.
BOND PRICING
Riley County, KansasGeneral Obligation Refunding Bonds
Series 2017 (Issue Summary)-Preliminary, BQ-
Maturity PremiumBond Component Date Amount Rate Yield Price (-Discount) Principal Cost
Serial Bond:09/01/2018 25,000 3.000% 1.050% 101.612 403.00 25,403.0009/01/2019 280,000 3.000% 1.100% 103.438 9,626.40 289,626.4009/01/2020 280,000 3.000% 1.200% 104.998 13,994.40 293,994.4009/01/2021 230,000 3.000% 1.300% 106.335 14,570.50 244,570.5009/01/2022 240,000 3.000% 1.400% 107.451 17,882.40 257,882.4009/01/2023 170,000 3.000% 1.550% 108.056 13,695.20 183,695.2009/01/2024 175,000 3.000% 1.800% 107.681 13,441.75 188,441.7509/01/2025 180,000 3.000% 1.950% 107.591 13,663.80 193,663.80
1,580,000 97,277.45 1,677,277.45
Dated Date 11/01/2017Delivery Date 11/01/2017First Coupon 03/01/2018
Par Amount 1,580,000.00Premium 97,277.45
Production 1,677,277.45 106.156801%Underwriter's Discount -15,800.00 -1.000000%
Purchase Price 1,661,477.45 105.156801%Accrued Interest
Net Proceeds 1,661,477.45
15.a
Packet Pg. 60
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
Aug 15, 2017 12:52 pm Prepared by Piper Jaffray & Co.
BOND SUMMARY STATISTICS
Riley County, KansasGeneral Obligation Refunding Bonds
Series 2017 (Issue Summary)-Preliminary, BQ-
Dated Date 11/01/2017Delivery Date 11/01/2017Last Maturity 09/01/2025
Arbitrage Yield 1.540603%True Interest Cost (TIC) 1.769761%Net Interest Cost (NIC) 1.830467%All-In TIC 2.213168%Average Coupon 3.000000%
Average Life (years) 4.409Weighted Average Maturity (years) 4.439Duration of Issue (years) 4.160
Par Amount 1,580,000.00Bond Proceeds 1,677,277.45Total Interest 209,000.00Net Interest 127,522.55Bond Years from Dated Date 6,966,666.67Bond Years from Delivery Date 6,966,666.67Total Debt Service 1,789,000.00Maximum Annual Debt Service 326,650.00Average Annual Debt Service 228,382.98
Underwriter's Fees (per $1000) Average Takedown Other Fee 10.000000
Total Underwriter's Discount 10.000000
Bid Price 105.156801
Par Average AverageBond Component Value Price Coupon Life
Serial Bond 1,580,000.00 106.157 3.000% 4.409
1,580,000.00 4.409
All-In ArbitrageTIC TIC Yield
Par Value 1,580,000.00 1,580,000.00 1,580,000.00 + Accrued Interest + Premium (Discount) 97,277.45 97,277.45 97,277.45 - Underwriter's Discount -15,800.00 -15,800.00 - Cost of Issuance Expense -30,000.00 - Other Amounts
Target Value 1,661,477.45 1,631,477.45 1,677,277.45
Target Date 11/01/2017 11/01/2017 11/01/2017Yield 1.769761% 2.213168% 1.540603%
15.a
Packet Pg. 61
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
Cumulative Savings From Prior
Bond Refinancings
15.a
Packet Pg. 62
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)
Riley County, KansasSavings from Bond Refinancings2005 - Present
PV SavingsSavings at Bond Yield
Series 2005 107,019.33 86,849.62 Series 2010-B 65,645.83 60,596.22 Series 2013 64,778.33 60,979.23
Total 237,443.49 208,425.07
15.a
Packet Pg. 63
Att
ach
men
t: R
iley
Co
Pre
limin
ary
Ref
inan
cin
g A
nal
ysis
08.
15.2
017
(58
95 :
201
7 P
relim
inar
y R
efin
anci
ng
An
alys
is)