HomeMy WebLinkAboutApproved Documents - 1/2/2018 FINANCE DEPT. STAFF ONLY
LINE ITEM USED ()/Q ,37 41,10 /j4(0
TRAVEL REQUEST FYX)/t BUDGETED /000
CITY OF WATERLOO EXPENDED YTD 0- °!
THIS REQUEST /,?j.5-°�
LEFT AFTER THIS az,
REQUEST lac,?6
DATE 2/1c./ /.2'097-/7
Original-Clerk/Finance Copy-Department
NAME(S) AND POSITION(S): DATE:
JB Bolger, golf manager 12/18/2017
NAME OF CLASS/ MEETING: DESTINATION: Altoona, Iowa
Iowa Turfgrass Conference and Tradeshow
DEPARTURE POINT
IF NOT WATERLOO:
DEPARTURE DATE: RETURN DATE: DATE(S) OF MEETING:
January 24, 2018 January 24, 2018 January 23-25, 2018
PURPOSE OF TRAVEL/TRAINING:
To keep up on new equipment and products.
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: x COST $
YES NO
METHOD OF TRAVEL:
X CITY VEHICLE PRIVATE VEHICLE
AIRFARE DEPARTING FROM:
ESTIMATE OF COST: BUDGET LINE ITEM: 010-37-4120-1346
LODGING TAXI X GRANT REIMBURSABLE
MEALS PARKING YES NO
135.00 REGISTRATION AIRFARE X REQUIRED CERTIFICATION
MILEAGE/FUEL MISC/TOLLS YES NO
TOTAL FOR ALL: $ 135.00 TOTAL: $ 135.00 PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE I APPROVE THIS TRAVEL REQUEST
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WAT _ 00
DE MENT HEAD MAYOR
7 718
DATE DATE
K:\Shared Goodies\Foiins\Travel Request Foiin January 2010
FINANCE DEPT. STAFF ONLY
LINE ITEM USED 010-11-1100-1346
TRAVEL REQUEST FY _2018_ BUDGETED Sie)QU
CITY OF WATERLOO EXPENDED YTD ,73(p902 w-
THIS REQUEST key()
LEFT AFTER THIS y�
REQUEST 7.3a 7
DATE nyvar /,
Original-Clerk/Finance Copy-Department
NAME(S) AND POSITION(S): DATE
P.O. Steven Thomas December 18, 2017
NAME OF CLASS I MEETING: DESTINATION: Johnston, Iowa
Iowa Law Enforcement Academy I.L.E.A. Course DEPARTURE POINT
IF NOT WATERLOO:
DEPARTURE DATE: Return Date: DATE(S) OF MEETING:
January 2nd, 2018 April 18th, 2018 January 2nd to April 18th 2018
PURPOSE OF TRAVEL:
Director Trelka is requesting authorization to send P.O. Steven Thomas to the Iowa Law Enforcement
Academy in Johnston, Iowa on January 2nd to April 18th, 2018. P.O. Thomas is a newly hired officer and is
required to attend I.L.E.A. course to become a state certified police officer. A city vehicle will be needed for this
travel/training.
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: x COST$
YES NO
METHOD OF TRAVEL:
x CITY VEHICLE PRIVATE VEHICLE
AIRFARE DEPARTING FROM:
ESTIMATE OF COST: BUDGET LINE ITEM:
$.00 LODGING .00 Parking x GRANT REIMBURSABLE
$1560.00 MEALS .00 Shuttle/taxi YES NO
$6240.00 REGISTRATION .00 AIRFARE x REQUIRED CERTIFICATION
$200.00 Fuel/mileage .00 Baggage fee YES NO
TOTAL FOR ALL: $ 8000.00 TOTAL: $ 8000.00 PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE I APPROVE THIS TRAVEL REQUEST
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
DEPARTMENT HEAD MAYOR
12 � � �a
�z/r 8
DATE DATE
Sent over 121117 FINANCE DEPT. STAFF ONLY
LINE ITEM USED (I/O /,2 /`00 13'1(o
TRAVEL REQUEST FYgLL BUDGETED "5"OO
CITY OF WATERLOO EXPENDED YTD ..Mg/°%
THIS REQUEST //D6-1
LEFT AFTER THIS
REQUEST /6 2/ Il
DATE 2/74.t /2''2-�77
NAME(S) AND POSITION(S): DATE:
Troy Luck and Two WFR Staff Members 12/11/17
NAME OF CLASS / MEETING: DESTINATION: East Dubuque, IL
Incident Command Blue Card Certification DEPARTURE POINT
IF NOT WATERLOO:
DEPARTURE DATE: RETURN DATE: DATE(S) OF MEETING:
02/22/18 02/25/18 02/22/18-02/25/18
PURPOSE OF TRAVEL:
Attend Incident Command Blue Card 3 day certification. The incident Command Certification Program is designed to first
instruct, train and then evaluate and certify Fire Department Officers who serve in the role of Incident Commanders that
supervise and manage emergency and hazard zone operations for every day, local NIMS Type 4 and Type 5 events.
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: x COST $
YES NO
METHOD OF TRAVEL:
x CITY VEHICLE PRIVATE VEHICLE
AIRFARE DEPARTING FROM:
ESTIMATE OF COST: BUDGET LINE ITEM: 010-12-1400-1346
$719.82 LODGING TAXI X GRANT REIMBURSABLE
$300.00 MEALS PARKING YES NO
$600.00 REGISTRATION AIRFARE X REQUIRED CERTIFICATION
$40.00 MILEAGE/FUEL MISC/TOLLS YES NO
TOTAL FOR ALL: $ $1,659.82 TOTAL: $ $553.27 PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE I APPROVE THIS TRAVEL REQUEST
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATEQLOO
IS
1 t1KA Q V
DEPARTMENT HEAD MAYOR
1 a
DATE DATE
FINANCE DEPT. STAFF ONLY
LINE ITEM USED ad Si tH 20 /3'4
TRAVEL REQUEST F40ig BUDGETED I Dev
CITY OF WATERLOO EXPENDED YTD J'
THIS REQUEST
LEFT AFTER THIS __
REQUEST y.3 U
DATE 7,7t✓ /?' -i1
Original-Clerk/Finance Copy-Department
NAME(S) AND POSITION(S): DATE:
Tom Klein, Brad VanderWerff, Bob Jorgensen, golf 12/20/2017
superintendents
NAME OF CLASS/ MEETING: DESTINATION: Altoona, Iowa
Iowa Turfgrass Conference and Tradeshow
DEPARTURE POINT
IF NOT WATERLOO:
DEPARTURE DATE: RETURN DATE: DATE(S) OF MEETING:
January 23, 2018 January 25, 2018 January 23-25, 2018
PURPOSE OF TRAVEL/TRAINING:
To keep up on new equipment and products. To attend Pesticide Applicator class to maintain license as required in this
job position.
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: x COST$
YES NO
METHOD OF TRAVEL:
X CITY VEHICLE PRIVATE VEHICLE
AIRFARE DEPARTING FROM:
ESTIMATE OF COST: BUDGET LINE ITEM: 010-37-4120-1346
LODGING TAXI X GRANT REIMBURSABLE
MEALS PARKING YES NO
525.00 REGISTRATION AIRFARE X REQUIRED CERTIFICATION
MILEAGE/FUEL MISC/TOLLS YES NO
195.00 Bob
TOTAL FOR ALL: $ 525.00 TOTAL: $ going 3 days PER PERSON
$165.00 each for Tom and Brad going Wed &Thurs
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE I APPROVE THIS TRAVEL REQUEST
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
DEPARTMENT HE MAYOR
DATE DATE
K:\Shared Goodies\Forms\Travel Request Form January 2010
City of Waterloo ) -�!
Expenditure Authorization Request Form \/0,6
The Finance Committee of the City Council is hereby requested to authorize the following
purchase or expenditure submitted by the Airport Department to expend
$ 9,903.00 plus est. shipping costs of $ to pay for or puchase
Airport general liability insurance for CY 2018.
This purchase or expenditure is being made because:
Liability insurance is necessary for risk management of airport operations.
x Bids or written quotes were taken on this purchase, as follows:
The City has bid Insurance and PDCM is currently the City's insurance agent.
PDCM has bid our insurance through several aviation insurance companies.
Bids or quotes were not taken on this purchase because:
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
X General Fund Road Use Tax Sewer Sanitation
Bonds Federal/other grants Other(specify)
This expenditure is to be coded to the following budget line-item:
010 29 7700 1364
(Fund - Department-Activity -Account Number) (Project Code)
y1°3
1°° -1DL�
in which the budgeted amount is $ 8,203.00C + I, ( t�
i
a d th c rrent available balance is $ 8,203.00 rI'la0 v �i703` otuvj�iv1404
Yett.e5fr
Re pe ull •tted,
/2//
(Sign ture D d or Designee) at (Signature Finance Dept. Review) Date
users\shared goodies\forms\PDCM-2018.xls(Oct 2004)
City Clerk Use Only
Finance Committee
Approval Date
City of Waterloo
Expenditure Pre-Authorization Request Form
The Finance Committee of the City Council is hereby requested to authorize the following
purchase or expenditure submitted by the Leisure Services Department to expend
$ 3,400.00 plus est. shipping costs of $ n/a to pay for or purchase
repair of leaking water main at Straub Fields located at Riverfront Sports Park.
This purchase or expenditure is being made because:
leak in water main at Straub Fields located at Riverfront Sports Park.
This fits Strategy 4.5 "Quality of Place"
Vendor selected for this purchase: Frickson Backhoe & Trucking
Bids or written quotes were taken on this purchase, as follows:
x Bids or quotes were not taken on this purchase because:
This was emergency repair with cost split between Leisure Services and
Waterloo Water Works.
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
General Fund Road Use Tax Sewer Sanitation
x Bonds Federal/other grants Other (specify)
This expenditure is to be coded to the following budget line-item:
413-37-4105-2168 and 414-37-4105-2168
(Fund - Department-Activity-Account Number) (Project Code)
/ ✓
in which the budgeted amount is $ 75,000/100,000
✓ ./
and the current available balance is $ 1,847.89/7,348.41 .0(118
Respectfully submitted,
� ~' /. /1/7 y%.44-ciai-c. GJ.� /,z-�)/1
(Signature Dept. Hea r Designee) Date (Signature Finance Dept. Review) Date
r
K:\shared goodies\forms\Pre-Authorization Straub Water Leak Repair.xls(Mar 2010)
City Clerk Use Only
Finance Committee a
Approval Date 2"/l U
City of Waterloo
Expenditure Pre-Authorization Request Form
The Finance Committee of the City Council is hereby requested to authorize the following
purchase or expenditure submitted by the Leisure Services Department to expend
$ 3,223.00 plus est. shipping costs of $ to pay for or purchase
Two replacement tracks on John Deere 333D Track Loader. This price includes parts,
labor, and disposal of worn out tracks.
This purchase or expenditure is being made because:
Tracks are worn out. This machine is used at a number of locations for snow removal
and machine will not be operable unless tracks are replaced.
Vendor selected for this purchase: Murphy Tractor& Equipment, Waterloo Iowa
n Bids or written quotes were taken on this purchase, as follows:
Murphy Tractor& Equipment, Waterloo, Iowa $3,223.00
P&K Midwest, Waterloo, Iowa $3,238.00
Bids or quotes were not taken on this purchase because:
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
X General Fund Road Use Tax Sewer Sanitation
Bonds n Federal/other grants Other(specify)
This expenditure is to be coded to the following budget line-item:
010-37-4100-1378
(Fund - Department-Activity-Account Number) (Project Code)
in which the budgeted amount is $ 12,616.00
and the current available balance is $ 6,844.90
Respectfully submitted,
z/27/Cl r r a/x latc:tatu,/ i2. i /'
(Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Pre-Auth 333D Replacment Tracks 2.xls(Mar 2010)
City Clerk Use Only
Finance Committee /
Approval Date 7 2 ! 18
City of Waterloo
Expenditure Pre-Authorization Request Form
The Finance Committee of the City Council is hereby requested to authorize the following
purchase or expenditure submitted by the Police Department to expend
$ 2,275.00 plus est. shipping costs of $ 0.00 to pay for or purchase
1 Year renewal of Fortigate firewall hardware for the Police Department
computer system
This purchase or expenditure is being made because:
Annual renewal of firewall hardware for Police Depoartment Computers
Vendor selected for this purchase: ACES
n Bids or written quotes were taken on this purchase, as follows:
n Bids or quotes were not taken on this purchase because:
Aces is a proprietary company to the Police Department computer system
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
I ^I General Fund n Road Use Tax n Sewer n Sanitation
n Bonds n Federal/other grants n Other(specify)
This expenditure is to be coded to the following budget line-item:
010-11-1105-1520
(Fund - Department-Activity-Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is $ 4333(0
Respectfully submitted,
64.111. _ I J f` (7 .i/AAIA.
(Signature Dept. Hea: • i�-signee) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization(Mar 2010)
CONSTRUCTION PROJECT BUDGET WORKSHEET
PAGE TWO
City Clerk Use Only
Finance Committee I/ /
Approval Date Project Name (from page one) Traffic Adaptive Signals on 218 &San Marnan and Fiber Optics Communications Upgrade
Department No. project will be budgeted under
Activity No. project will be budgeted under
:::C4/1° //
(Each column should only include amounts by fund)
runa:
Fund: _290_ _290 Fund: Fund:
� itp 1 (60 5TP d Total
REVENUES: �.i rit4 1,40 ilt4-G446-
3000 Cash on Hand r i /?oz /7X j2` 5,'P1't3 $ -
3112 Local Option Sales Tax
-
3350 Federal Grant 400,000.00 300,000.00 700,000.00
3357 Shared Program -County
-
3358 Shared Program -City
-
3360 Shared Program -State
-
3361 State Grant
-
3365 State RISE Grant
-
3368 EPA Grant
-
3377 EDA Grant
-
3720 Donations- Restricted
-
3750 Sale of Bonds 100,000.00 100,000.00
TOTALS $ 500,000.00 $ 300,000.00 $ - $ - $ 800,000.00
EXPENDITURES:
2103 Engineering &Consulting $ 40,000.00 $ 120,000.00 $ 160,000.00
2125 Traffic Control Equipment 460,000.00 180,000.00 640,000.00
2140 Land Acquisition
-
2144 Land Improvements
-
2146 Demolitions
-
2151 Building Construction
2156 Bikeway Construction
-
2162 Storm Sewers
-
2163 Sanitary Sewers
-
2164 Sidewalks
-
2165 Streets & Roadways
-
2199 Non-participating Misc -
TOTALS $ 500,000.00 $ 300,000.00 $ - $ - $ 800,000.00
• 1 7 ,Aix, (J .`uA /2 ;2X/7
'( gnature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Newof Project Budget Worksheet.xls\Page 2(Constr Proj) (Mar 2010)
PROJECT BUDGET WORKSHEET -ALL PROJECTS
PAGE ONE
Project Name Traffic Adaptive Signals on 218 & San Marnan and Fiber Optics Communications Upgrade
City Contract No. To be assign Dot-
_ Finance D -
Project Manager Mohammad Elahi Project No. '
Project Budget Total $ 800000 (500,000 + 300,000) Subproject-NO, _ _
1. How will this project be funded?
A. Federal Grant Yes x No CFDA# 20.205 % Paid by federal grant 80% & 100%
Grant Name ICAAP & STP Grant Agreement Number 2015-ICAAP-05
B. State Grant Yes No x % Paid by state grant
Grant Name Grant Agreement Number
C. City Match Source of Funding G.O. Bond % Paid by City 20% & 0%
D. Other Entities Yes No x % Paid by other entity
Name
Done None
2. Attach copies of any grant agreements that will fund the project (REQUIRED) ❑x ❑
Yes No
3. Does the project include the purchase of right of way or other real property? ❑ 0
If yes, will real property purchases be reimbursable under the grant? ❑
If yes, have you attached authorization to purchase real property to this document? ❑ ❑
4. Will this project include any non-participating expenses, such as:
A. Stormwater permit fees ❑ 0
B. Publication, or printing costs ❑ ❑
C. Others, list ❑
5. Does this project cover any regular full-time salaries or benefits? ❑ Q
If yes, employee/position to be covered.
6. Include a brief description of the project in the space below: (REQUIRED)
Traffic Adaptive Signal Control technology will be installed from W. 11th on 218 to San Marnan and on San Marnan from
218 to Hammond. It will include branches on Laporte Rd and Sarah Dr.
Traffic communications on 218 from W.6th to San Marnan on San Marnan to Kimball then to W 4th to 218 and back to
W. 6th will be upgraded to fiber optics.
Page 2 must be attached and signed.
K:\shared goodies\forms\Newof Project Budget Worksheet.xls\Page 1 All Projects (Mar 2010)
PROJECT BUDGET WORKSHEET- NON-CONSTRUCTION t J
PAGE TWO �^ ,f 2,/
/18
Project Name(from page one) IDOT Air Service Development FY18
Department No. project will be budgeted under 29 To be assigned e Finance Dept
Activity No. project will be budgeted under 7760/7700 Project No. . r
Subproject No. . '. IN DV
(Each column should only include amounts by fund)
Fund: Fund:
291 010 Fund: Fund:
Total
REVENUES:
3000 Cash on Hand $
3350 Federal Grant
3353 Federal U-Step Grant
3358 Shared Program -City
3360 Shared Program -State
-
3361 State Grant 28,000.00 28,000.00
3365 State RISE Grant
3720 Donations- Restricted
-
3750 Sale of Bonds
-
3800 Miscellaneous Revenue
-
3111 Hotel/Motel Tax -
TOTALS $ 28,000.00 $ - $ - $ - $ 28,000.00
EXPENDITURES:
1111 Salaries - Regular $ -
1112 Salaries - Part Time
-
1315 Education &Training
-
1345 Travel -Official City
-
1346 Travel - Prof Training
-
1319 Other Prof
-
1351 Advertising 28,000.00 7,000.00 35,000.00
TOTALS $ 28,000.00 $ 7,000.00 $ - $ - $ 35,000.00
/ 4 /27/y„
,4.4/44.191,L.) /.2
(Signature Dept. Vd
Date (Signature Finance Dept. Review) Date
users\michelle-w\forms\Project Budget Wkshts_IDOT Air Svc Dev FY18.xls\Page 2(Donat-non constr) (April 2003)
PROJECT BUDGET WORKSHEET -ALL PROJECTS
PAGE ONE
Project Name IDOT Air Service Development FY18
City Contract No. To be assigned by the Finance Dept
Project Manager Keith Kaspari Project No.
Project Budget Total $ 35,000.00 Subproject No.
1. How will this project be funded?
A. Federal Grant Yes No X CFDA# % Paid by federal grant
Grant Name
B. State Grant Yes I X I No % Paid by state grant 80.00%
Grant Name FY18 Air Service Development Program
C. City Match Source of Funding Airport Operations Budget % Paid by City 20.00%
D. Other Entities Yes No X % Paid by other entity
Name
Done None-
Attach copies of any grant agreements that will fund the project(REQUIRED) ❑ X "Should recv
this week.
Yes No
2. Does the project include the purchase of right of way or other real property? ❑ X
If yes, will real property purchases be reimbursable under the grant? ❑
Done None
If yes, attach authorization to purchase real property to this document. ❑ ❑
Yes None
3. Please indicate any non-participating expenses that you are aware will be incurred, such as:❑
A. Stormwater permit fees X
B. Publication, or printing costs X
C. Others, list ❑ X
4. Does this project cover any regular full-time salaries or benefits? X
If yes, employee/position to be covered.
5. Include a brief description of the project in the space below: (REQUIRED)
This is an agreement between the Waterloo Regional Airport and the Iowa Department of Transportation for Air Service
Sustainment funding. Pursuant to the terms of this agreement, the Iowa DOT agrees to provide authorized funding to help in
air service development activities to include: marketing to sustain and increase capture of existing Waterloo area demand
for passenger air service using television, radio and print advertising.
Page 2 must be attached and signed.
users\michelle-w\forms\Project Budget Wkshts_IDOT Air Svc Dev FY18.xls\Page 1 All Projects (Feb 2007)