HomeMy WebLinkAboutApproved Documents - 8/29/2022City Clerk Use Only
Finance Committee8/29/2022
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 Department to expend
$ 4050.00 plus est. shipping costs of $ 0 to pay for or purchase
Installation services for three (3) power load systems on three (3) separate ambulances.
This purchase or expenditure is being made because:
Purchased power load systems cannot be utilized until installed. These systems support the
weight of the patient and cot as they are loaded into the ambulance reducing chance of back njury.
Vendor selected for this purchase:
GLS Service LLC
n Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
Only other installer was utilized in a previous install and corrections were needed after
that install at a later date. This installer was recommended by Manufacturer (Stryker).
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-12-1410 1551
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Jason Hernandez August 8, 2022
$ 175,000.00
$ 150,009.93
8/29/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
8/29/2022
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
$ 6,851.25
Leisure Services
Department to expend
plus est. shipping costs of $ to pay for or purchase
floor re coating of the gym and fitness studio at the Cedar Valley SportsPlex.
This purchase or expenditure is being made because:
the floors need to be re -coated yearly for proper maintenance of the floors.
Vendor selected for this purchase:
Capital Sanitary Supply (Cedar Falls, IA)
�■ Bids or written quotes were taken on this purchase, as follows:
Capital Sanitary Supply (Cedar Falls, IA) $6,851.25
Hillyard (Urbandale, IA) $8,200.00
Anderson Ladd, INC (Waukee, IA) - No Bid Returned
❑ 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
010-37-4180-1390 Other Contractual Services
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,
Paul Huting 08/10/2022
X, w
(Project Code)
$ 25,518.00
$ 24,009.96
8/29/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
8/29/2022
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
$ 17,892.66
plus est. shipping costs of
Leisure Services
$0
Replacement of 707 sqft of Locker room flooring at Young Arena.
Department to expend
to pay for or purchase
This purchase or expenditure is being made because:
Current flooring in the locker room area is worn and not providing adequate protection for players
skate blades.
Vendor selected for this purchase:
All American Arena Products, Albert Lea MN
�■ Bids or written quotes were taken on this purchase, as follows:
All American Arena Products, Albert Lea MN $17,892.66
Riley's Floors, Waterloo IA $22,189.09
D & W Floors, Cedar Falls IA $23,094.75
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:
322-37-4500-2152
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Paul Huting 08/11/2022
$ 90,000
$ 90,000
8/29/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
8/29/2022
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 Police Department to expend
$ 6,587.50 plus est. shipping costs of $ 0.00 to pay for or purchase
Salient Enterprise Licenses for new HWY 63 Camera Project to existing Ultra
servers with remaining software support.
This purchase or expenditure is being made because:
Replacing defective monitoring cameras and licensing for signalized intersecions
on Hwy 63from Conger St. to Donald St.
Vendor selected for this purchase: RC Sytems
n Bids or written quotes were taken on this purchase, as follows:
RCSystems
Waterloo, Iowa $6,587.50
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:
322-11-1100-2106
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is $ 125,000.00
and the current available balance is $ 27,130.63
Respectfully submitted,
Capt. Aaron McClelland 8/16/22
8/29/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
8/29/2022
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 Sewer(Gas Panel) Department to expend
$ 39,110.00 plus est. shipping costs of $ to pay for or purchase
Gas Detection Alarm control Panel
This purchase or expenditure is being made because:
needed repairs and Gas Monitoring at the WMS Lagoon Building
Vendor selected for this purchase:
Automatic Systems
n Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
Sole Provider
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-1571
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Brian Bowman
08/17/22
$ 400,000.00
$ 374,918.61
8/29/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
8/29/2022
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
$ 3,045.00 plus est. shipping costs of
A Greyline DFM 6.1 Meter for Lagoon
Sewer (Lagoon Meter)
$ 100.00
Department to expend
to pay for or purchase
This purchase or expenditure is being made because:
Meter needs to be replaced
Vendor selected for this purchase:
Heartland Controls
n Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
Heartland Controls is Sole Proprietor
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 1378
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
$ 60,000.00
and the current available balance is $ 58,881.44
Respectfully submitted,
Brian Bowman
08102022
XL, ?S
8/29/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
8/29/2022
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 Sewer (Trojan UV) Department to expend
$ 7,880.00 plus est. shipping costs of $ 200.00 to pay for or purchase
A Replacement Parts for Trojan UV
This purchase or expenditure is being made because:
Needs to be replaced
Vendor selected for this purchase:
MC2
n Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
MC2 is sole proprietor
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 1521
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
$ 75,000.00
and the current available balance is $ 64,950.14
Respectfully submitted,
Brian Bowman
08/11/2022
_Kim, Tali&
8/29/2022
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Completed forms should be routed directly to the Finance Dept.
FINANCE DEPT. ONLY
FinancxCommittee approval required?
YES NO —8/29/2022
If so, date approved:
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 2023 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
37RST.YAMI
4,511.89
010 37 4105 1371
Bkdg Maint
37RST.YAMI
4,511.89
TOTAL
This amendment is being requested because:
$4,511.89
TOTAL
$4,511.89
to carry forward the cash balance funds in the YAMI project and have funds available for building repairs.
Prior Committee Actions (Dates):
Paul Huting 08/08/2022
8/29/2022
(Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date
Date Posted (Finance Dept.)
K:\users\shared goodies\forms\Waterloo.34574.1.Budget_Amend_YAMI_2023 (Apr 2003)
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
Project Name
City Contract No.
Project Manager
Project Budget Total
Downtown Implementation FY23
Noel Anderson
$ 72,000.00
1. How will this project be funded?
A. Federal Grant Yes
Grant Name
No
CFDA #
B. State Grant Yes No
Grant Name
C. City Match
Source of Funding
D. Other Entities Yes No
Name
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
To be assigned by the Finance Dept.
Project No.
Subproject No.
% Paid by federal grant
Grant Agreement Number
% Paid by state grant
Grant Agreement Number
% Paid by City
% Paid by other entity
3. Does the project include the purchase of right of way or other real property?
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
B. Publication, or printing costs
C. Others, list
5. Does this project cover any regular full-time salaries or benefits?
If yes, employee/position to be covered.
Done None
❑ ❑x
Yes No
❑ ❑x
❑ ❑
El El
❑ ❑x
❑ ❑x
❑ ❑x
❑x
6. Include a brief description of the project in the space below: (REQUIRED)
Vandewalle & Associates will continue to provide professional services for implementation of the Riverfront Renaissance
Plan in downtown Waterloo
Page 2 must be attached and signed.
K:\shared goodies\forms\Waterloo.34595.1.Vandewalle_fy23_project_budget\Page 1 All Projects (Mar 2010)
CONSTRUCTION PROJECT BUDGET WORKSHEET
PAGE TWO
City Clerk Use Only
Finance Committee
8/29/2022
Approval Date
Project Name (from page one) Downtown Implementation FY23
Department No. project will be budgeted under 08
Activity No. project will be budgeted under 6270
REVENUES:
3000 Cash on Hand
3112 Local Option Sales Tax
3350 Federal Grant
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
EXPENDITURES:
To be assigned by the Finance Dept.
Project No.
Subproject No.
(Each column should only include amounts by fund)
Fund: 426 Fund: Fund: Fund:
$ 72,000.00
Total
$ 72,000.00
TOTALS $ 72,000.00 $ - $ $ - $ 72,000.00
2103 Engineering & Consulting $ 72,000.00 $ 72,000.00
2125 Traffic Control Equipment
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 $ 72,000.00 $ - $ $ - $ 72,000.00
8/29/2022
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Waterloo.34595.1.Vandewalle_fy23_project_budget\Page 2 (Constr Proj) (Mar 2010)
Completed forms should be routed directly to the Finance Dept.
FINANCE DEPT. ONLY
Finance Committee approval required?
YES X NO 8/29/2022
If so, date approved:
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 2023 submitted by the Police Department 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
010 11 1160 3603
TRI CO FORF
11TRI.TRIF
44,670.00
010 11 1160 1512
TRI CO FORF
11TRI.TRIF
44,670.00
010 11 1160 3600
Cash on Hand
11TRI.TRIF
25,330.00
010 11 1160 1512
TRI CO FORF
11TRI.TRIF
25,330.00
TOTAL
$70,000.00
TOTAL
$70,000.00
This amendment is being requested because:
This is to conform with the City's budget line item control policy. Using current & prior year's revenue to increase the FY23 expense line.
Aaron McClelland, Police Captain 8/16/2022
Prior Committee Actions (Dates):
8/29/2022
(Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date
Date Posted (Finance Dept.)
K:\users\shared goodies\forms\Waterloo.34636.1.Budget_Amendment_Tri_County_8-29-22 (Apr 2003)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
Project Name (from page one)
City Clerk Use Only
Finance Committee
8/29/2022
Approval Date
Department No. project will be budgeted under
Activity No. project will be budgeted under
REVENUES:
3000 Cash on Hand
3350 Federal Grant
3352 Federal HUD Grant
3354 Shared Program - Local
3357 Shared Program - County
3358 Shared Program - City
3360 Shared Program - State
3361 State Grant
3720 Donations - Restricted
3750 Sale of Bonds
EXPENDITURES:
To be assigned by the Finance Dept.
Project No.
Subproject No.
(Each column should only include amounts by fund)
Fund: Fund: Fund: Fund:
TOTALS $
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
1390 Contractual Services
TOTALS $
Total
8/29/2022
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Waterloo.34595.1.Vandewalle_fy23_project_budget\Page 2 (Donat or NON-constr) (Mar 2010)