HomeMy WebLinkAboutApproved Documents - 2/21/2022City Clerk Use Only
Finance Committee
Approval Date 2/21/2022
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 Airport Department to expend
$ 57,500 plus est. shipping costs of $ to pay for or purchase
FY-22 marketing plan for Waterloo Regional Airport, which includes SEM, Targeted Social Media
Services, Re -Messaging, Video, Creative Custom services & additional agency services.
This purchase or expenditure is being made because:
continues enhanced marketing plan for Waterloo Regional Airport and American Airlines. Plan
was approved by Air Service Working Group and IDOT for use of FY-22 IDOT Air Service Development Grant funds.
Vendor selected for this purchase:
Advance Aviation
n Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
The Airport Board and Air Service Working Group have been working with Advance Aviation
to help position ALO to come out of the pandemic as strong as possible. Advance was chosen
based on their work with 70 airport clients, after several Zoom presentations to both the Board and the ASWG.
Prior Committee Actions (Dates): Project Budget for grant was approved 1/18/22
Please check the following box(es) as appropriate to describe the funding for this expense:
General Fund IT Road Use Tax IT Sewer n Sanitation
ElBonds . Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
291-29-7760-1350 / 010-29-7700-1351 29PRO ADV22
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is $ 48,000.00 / 28,375.00
and the current available balance is $ 48,000.00 / 28,375.00
Respectfully submitted,
Keith D. Kaspari 1/28/2022
2/21/2022
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
City Clerk Use Only
Finance Committee
Approval Date 2/21/2022
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 Garage/Fire Department to expend
$ 13,688.11 plus est. shipping costs of $ 250.00 to pay for or purchase
Rebuild engine on 2016 Pierce Fire Truck
This purchase or expenditure is being made because:
To rebuild engine damaged by antifreeze corroding the cylinder lines.
Truck has 9,450 hours and 92,932 miles
Vendor selected for this purchase:
Truck Center Companies
n Bids or written quotes were taken on this purchase, as follows:
Truck Center Companies Waterloo, IA
$13,688.11
GTG Peterbilt
Waterloo, IA $35,874.58
MHC Kenworth
Waterloo, IA $18,223.38
IT 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:
General Fund IT Road Use Tax IT Sewer n Sanitation
ElBonds ❑ Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
010-18-1405-1571
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
$ 60,000.00
and the current available balance is $ 18,117.69
Respectfully submitted,
Sandie Greco
2/14/2022 11u4,11,70c 2/21/2022
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
City Clerk Use Only
Finance Committee
Approval Date 2/21/2022
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
$ 25,585 plus est. shipping costs of $ 1,400.00 to pay for or purchase
Approximately 210 trees as part of the Plant Waterloo program generously funded by the Young
Family foundation. Residents may purchase trees at a reduced rate of $20 per tree.
This purchase or expenditure is being made because:
To encourage Waterloo citizens to plant trees after losing so many ash trees in the community.
Vendor selected for this purchase:
multiple
�■ Bids or written quotes were taken on this purchase, as follows:
Bids were received from Jordan's Nursery, Tiedt Nursery & Wood Duck Trees Farms.
Trees will be purchased from each vendor listed based on meeting specs of the bid and
lowest prices for each species, and species availability.
n 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:
▪ General Fund IT Road Use Tax IT Sewer n Sanitation
❑ Bonds ❑ Federal/other grants . Other (specify) donation
This expenditure is to be coded to the following budget line -item:
010-37-41051536 37GFT.TREE 37GFT.TREE20 37RST.PS15, 37RST.PS16
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Paul Huting 2/3/2022
$ 20,287 240.00 29.50 6,341.88
$ 20,287 240.00 29.50 6,341.88
2/21/2022
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
City Clerk Use Only
Finance Committee
Approval Date 2/21/2022
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 MIS
$ 7,750
Department to expend
plus est. shipping costs of $ to pay for or purchase
Annual Fortigate firewall licensing, effective April 26th, 2022.
This purchase or expenditure is being made because:
The Fortigate Firewall is our first line of defense against hackers and malware. It is also
what employees use to connect remotely.
Vendor selected for this purchase:
n Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
CDW-G is our original vendor for the product and has detailed information about our
system and environment to effectively price this licensing.
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
▪ General Fund IT Road Use Tax IT Sewer n Sanitation
. Bonds ❑ Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
421-01-8225-2106
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
$ 75,000.00
and the current available balance is $ 67,116.42
Respectfully submitted,
Chris Youngblut 2/9/2022
2/21/2022
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
City Clerk Use Only
Finance Committee
Approval Date 2/21/2022
City of Waterloo
Expenditure Pre -Authorization Request Form
The Finance Committee of the City Council is hereby requested to authorize the following
Police Department to expend
to pay for or purchase
purchase or expenditure submitted by the
$ 23,096.00 plus est. shipping costs of
FY22 Ammunition Order
$ 00
This purchase or expenditure is being made because:
This is an FY 22 ammunition order based on a sealed bid process.
Vendor selected for this purchase:
Sunset Law Enforcement
�■ Bids or written quotes were taken on this purchase, as follows:
This is an FY22 ammunition order based on a sealed bid process. Sunset LE was the
2nd winning bid but the other distributor is unable to provide ammo for at least 12 months.
❑ Bids or quotes were not taken on this purchase because:
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to
General Fund ❑ Road Use Tax IT
Bonds ❑ Federal/other grants ❑
This expenditure is to be coded to the following
Police Dept. Ammunition 010-11-1100-1544
describe the funding for this expense:
Sewer ❑ Sanitation
Other (specify)
budget line -item:
(Fund - Department - Activity - Account Number)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Aaron McClelland, Police Lieutenat 2/9/2022
(Project Code)
$ 36,400.00
$ 28,586.50
2/21/2022
(Signature Dept. Head or Designee) Date (Signature Finance Dept. Review)
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Date
City Clerk Use Only
Finance Committee
Approval Date 2/21/2022
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,869.40 plus est. shipping costs of $ 00 to pay for or purchase
Daikin Mini Split heating/cooling system for renovation of new briefing / training room in basement of PD.
This purchase or expenditure is being made because:
This current room is not climate controlled to allow for regular occupancy by personnel and longterm
usage as a training/computer room.
Vendor selected for this purchase:
Johnstone Supply
�■ Bids or written quotes were taken on this purchase, as follows:
Johnstone Supply $2,869.40
Dennis Supply Company $2,760.96 plus $150 freight charge
IT 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:
▪ General Fund IT Road Use Tax IT Sewer n Sanitation
. Bonds ❑ Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
419-11-1100-2152
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Matt McGeough, Police Captain 10/412021
71e,: rr.7;0 ,,.
$ 204,000.00
$ 162,491.59
2/21/2022
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
City Clerk Use Only
Finance Committee
Approval Date 2/21/2022
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 Sewer Department to expend
$ 4,922.50 plus est. shipping costs of $ 0 to pay for or purchase
grinding and polishing of concrete floor in the WWTP Administration building.
This purchase or expenditure is being made because:
Floor in the Waste Water Treatment Plan Administration building is delaminating
and creating a safety hazard.
Vendor selected for this purchase: Even Quality Works
n Bids or written quotes were taken on this purchase, as follows:
Even Quality Works - $4,922.50
McRoberts Construction - $5,179.00
n 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:
▪ General Fund IT Road Use Tax n Sewer n Sanitation
❑ Bonds ❑ Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
520-14-5200 1371
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is $ 38,000.00
and the current available balance is $ 16,048.16
Respectfully submitted,
Matthew Hosford
2/8/22
2/21/2022
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
City Clerk Use Only
Finance Committee
Approval Date 2/21/2022
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 Traffic Operations Department to expend
$ 2,610.00 plus est. shipping costs of $ to pay for or purchase
100 - Sign Tubing - 2" X 12' - 14 gauge
This purchase or expenditure is being made because:
To replace damaged posts for street name and regulatory signs.
IDOT State Bid
Vendor selected for this purchase:
Iowa Department of Transportation
�■ Bids or written quotes were taken on this purchase, as follows:
Iowa Department of Transportation Ames, IA
$2,610.00
IT 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:
▪ General Fund IT Road Use Tax IT Sewer n Sanitation
❑ Bonds ❑ Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
266-17-7120-1577
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Sandie Greco 2/15/2022
nz«ti�m au«gr ,,
$ 11,000.00
$ 4,190.21
2/21/2022
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
City Clerk Use Only
Finance Committee
Approval Date 2/21/2022
City of Waterloo
Expenditure Pre -Authorization Request Form
The Finance Committee of the City Council is hereby requested to authorize the following
Traffic Operations Department to expend
$ 16,069.56 plus est. shipping costs of $ 250.00 to pay for or purchase
6 - 31 ft. Millerbernd Black Street Light Poles with 8 ft. arms and hardware
purchase or expenditure submitted by the
This purchase or expenditure is being made because:
To replace damaged and deteriorated street light poles in the downtown area.
Vendor selected for this purchase:
Crescent Electric
❑■ Bids or written quotes were taken on this purchase, as follows:
Crescent Electric Waterloo, IA
$16,069.56
Van Meter Supply Waterloo, IA
$18,480.00
n Bids or quotes were not taken on this purchase because:
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to
•
General Fund IT Road Use Tax IT
Bonds ❑ Federal/other grants ❑
This expenditure is to be coded to the following
420-17-7105-2129 & 421-17-7105-2129
describe the funding for this expense:
Sewer n Sanitation
Other (specify)
budget line -item:
(Fund - Department - Activity - Account Number)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Sandie Greco 2/7/2022
(Project Code)
$ 20,000.00
13,662.91
$ 5,740.50
13,662.91
2/21/2022
(Signature Dept. Head or Designee) Date (Signature Finance Dept. Review)
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Date
Completed forms should be routed directly to the Finance Dept.
FINANCE DEPT. ONLY
Finance Committee approval required?
YES Z NO
If so, date approved: 2/21/2022
City of Waterloo
Line -Item Budget Amendment Request Form
The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line -item budget
amendment for FYE 2022 submitted by the Leisure Services Department:
EXPENSES/REVENUE
DECREASE EXPENDITURES (INCREASE REVENUE)
INCREASE EXPENDITURES (DECREASE REVENUE)
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount
cash
20,287.00
010 37 4105 1536
trees
37GFT.TREE
20,287.00
cash
240.00
010 37 4105 1536
trees
i7GFT.TREE2
240.00
cash
29.50
010 37 4105 1536
trees
37RST.PS15
29.50
cash
6,341.88
010 37 4105 1536
trees
37RST.PS16
6,341.88
TOTAL
This amendment is being requested because:
$26,898.38
TOTAL
$26,898.38
to carry forward funds left in various tree project codes.We will be using some of the funds from the sale of trees.
The other projects are previous Plant Waterloo projects and Plant Some Shade project.
Prior Committee Actions (Dates):
Paul Huting 2/3/2022
2/21/2022
(Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date
Date Posted (Finance Dept.)
K:\users\shared goodies\forms\Waterloo.32113.1.Budget_Amend_Plant_Waterloo (Apr 2003)