HomeMy WebLinkAboutApproved Documents - 7/13/2020City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 3,581.49 plus est. shipping costs of $ to pay for or purchase
labor and materials to install new door release buttons @ 5 locations in Airport Terminal building
and replace failed power supply.
This purchase or expenditure is being made because:
existing door releases did not always function properly leaving personnel locked inside some
office areas.
Vendor selected for this purchase:
CEC of Hiawatha, IA
❑ Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
CEC is the local vendor of Lenel software and door access systems, which is what is
used for access control in the Airport Terminal.
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:
010-29-7700-1371
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
$ 114,005
$ 114,005
Keith Kaspari, Airport Director 7/7/2020 Michelle 111/ezdner 7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 9 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 8626 plus est. shipping costs of $ to pay for or purchase
12 month extended service contract for preventive maintenance, necessary
replacement parts and repair work for Tiba parking system.
This purchase or expenditure is being made because:
the 2 year maintenance agreement that was included in the parking lot project, completed
June - July 2018, expires on June 30th, 2020.
Vendor selected for this purchase:
Parking Inc of Des Moines, IA
�■ Bids or written quotes were taken on this purchase, as follows:
a written quote covering the terms of the service contract was received from
Parking Inc, the sole vendor of Tiba parking equipment in Iowa.
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 n Sewer n Sanitation
❑ Bonds ❑ Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
010-29-7700-1371
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Keith Kaspari
$ 114005
$ 114005
June 26, 2020 %✓ltchelle etdev
W7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 7 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
Convention Center Department to expend
$ 16,500.00 plus est. shipping costs of $ to pay for or purchase
Annual license fee and service agreement for Ungerboeck Event Booking and Managment
software.
This purchase or expenditure is being made because:
This system manages administrative tasks and event calendar for the venue.
Vendor selected for this purchase:
❑ Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
Sole Source of Ungerboeck software services.
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:
010-01-6860-1390
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Brendon Wagner, General Manager 7/1/2020
$ 2,779,493.00
$ 2,779,493.00
Michelle W eider
7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 15 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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 Engineering Department to expend
$ 5,455.00 plus est. shipping costs of $ N/A to pay for or purchase
Iowa Storm Water Education Partnership (ISWEP) annual membership dues
This purchase or expenditure is being made because:
ISWEP develops and provides outreach materials and trainings for MS4 communities
to help them meet their IDNR NPDES storm water permit requirements
Vendor selected for this purchase:
ISWEP
❑ Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
No other comparable vendors exist
Prior Committee Actions (Dates):
N/A
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) Storm Water
This expenditure is to be coded to the following budget line -item:
521-07-7830-1391
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Jamie Knutson 7/8/2020
$ 8,000.00
$ 8,000.00
M/chelle W eta er
7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 11 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 1,050.00 plus est. shipping costs of $ 145.00
Antibacterial wipes for gym/fitness equipment cleaning.
Department to expend
to pay for or purchase
This purchase or expenditure is being made because:
the SportsPlex uses these wipes to clean and disinfect the weight and cardio equipment
at the sportsplex
Vendor selected for this purchase:
Push Pedal Pull (Cedar Rapids IA)
❑ Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
Push Pedal Pull is the company where all weight and cardio equipment has been
purchased and they recommend using this product on the machines we have.
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:
010-37-4180 1541
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Paul Huting 07/07/2020
$ 27,500.00
$ 27,500.00
Michelle UV e/d'er
7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 21 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 1,475.00 plus est. shipping costs of $ to pay for or purchase
upgraded card access software
This purchase or expenditure is being made because:
went to Windows 10 and card/door software wouldn't work. Need to update.
Vendor selected for this purchase:
Hawkeye Alarm Signal Company
❑ Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
Hawkeye Alarm was the company that installed the system and needed to update
the software when Windows 10 was put on machines.
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:
010-37-4180 1371 37SPLX.OPER
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
$ 30,000
and the current available balance is $ 30,000
Respectfully submitted,
Paul Huting
7/6/2020 Michelle Weidner
7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 17 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 12,000
plus est. shipping costs of
Leisure Services
Department to expend
$ to pay for or purchase
Rental of portion of maintenance building space at 304 W 5th Street.
This will pay for month of August 2020 through July 2021. FY Budget 2021
This purchase or expenditure is being made because:
to store the equipment and maintenance operations for the downtown area
maintenance crew.
Vendor selected for this purchase:
JSA Development LLC
❑ Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
Facilities available for this purpose are limited in the downtown area.
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:
010-37-4110 1390
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Paul Huting
$ 13,000
$ 13,000
07/06/2020 Michelle 14/etAer 7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 19 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 15,696.00 plus est. shipping costs of $ 500.00 to pay for or purchase
One hundred forty four duty helmets with safety visors to replace end of life helmets.
This purchase or expenditure is being made because:
To replace end of life and outdated safety helmets that are issued to each full time and reserve
police officer.
Vendor selected for this purchase:
�■ Bids or written quotes were taken on this purchase, as follows:
Streicher's $16,396.00
Galls $20,014.56
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 n Sewer n Sanitation
❑ Bonds . Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
010-11-1150-1573($14,125.00) 010-11-1150-1512($2,071.00) 11GRT.Covid20/11TRIWPDF
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Dave Mohlis, Police Captain
$ $53,772.00/$25,000.00
$ $48,463.63/$25,000.00
07/6/2020 Michelle Wetdner 7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 27 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 18,000
plus est. shipping costs of
Police
$0
Department to expend
to pay for or purchase
Greykey software renewal for cellular telephone data retrieval system used for criminal
investigations.
This purchase or expenditure is being made because:
This is an annual software and support renewal for the cellular telephone extraction system.
Vendor selected for this purchase:
▪ Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
This renewal is proprietary to the system that is owned by the police department.
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:
010-11-1160-1512 11TRI. TRIF
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Dave Mohlis, Police Captain
$ 60,000
$ 60,000
Michelle Weidner
7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 25 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 19,450.00 plus est. shipping costs of $ 0 to pay for or purchase
Benchmark Analytics software service agreement with early intervention programming.
This purchase or expenditure is being made because:
This software is includes, use of force, internal affairs, training, officer profiles, performance
evaluations, and a First Sign early intervention system.
Vendor selected for this purchase:
Benchmark Analytics
❑ Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
Benchmark Analytics is proprietary to this type of software package that has five modules
for Police Department employee tracking.
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:
010-11-1160-1520 Racial Equality Fund 11PRO.RETRAIN
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
$ 52,000
$ 52,000
Respectfully submitted,
Dave Mohlis, Police Captain 07/06/2020 Michelle Wezdner
7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 23 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 2000.00 plus est. shipping costs of $ 200.00 to pay for or purchase
Purchase replacement Conex box for the Police training facility.
This purchase or expenditure is being made because:
The current box is rusted out on the bottom. The Conex box is used to store range equipment
and portable target systems.
Vendor selected for this purchase:
❑■ Bids or written quotes were taken on this purchase, as follows:
Cubez LLC., $2200.00
Conexwest, $3100.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
•
General Fund IT Road Use Tax n
Bonds ❑ Federal/other grants ❑
This expenditure is to be coded to the following
416-11-1100-2152 Training center improvements
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
(Project Code)
$ 2579.80
$ 2579.80
Respectfully submitted,
Dave Mohlis, Police Captain 07/08/20 Michelle Weidner
7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 29 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 23,900.00 plus est. shipping costs of $ 539.33 to pay for or purchase
Easton Aeration Basin replacement membranes
This purchase or expenditure is being made because:
Rebuilding of Aeration Basins - maintenance is part of our 4 year plan to rebuild the entire Easton Aeration System.
Service removes any inorganic solids for land application and replacing the diffuser membranes, for good operation and cost savings.
Vendor selected for this purchase:
VESSCO
❑ Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
VESSCO is sole provider for replacement membranes.
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:
520-14-5200-1372
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
$ 100,000.00
$ 100,000.00
Brian Bowman 7/8/2020 Michelle Weidner
7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 31 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 7614.10 plus est. shipping costs of $ 0
Hydrolic Pump and hose rental
Department to expend
to pay for or purchase
This purchase or expenditure is being made because:
Easton aeration basins need to be pumped down so staff can enter and perform required maintenance and
install replacement diffuser membranes. Pumps will also be used for required maintenance on Hawkeye lift station.
Vendor selected for this purchase:
Sunbelt Rentals
▪ Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
Sunbelt Rentals is sole provider for replacement membranes.
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:
520-14-5200-1372
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
$ 100,000.00
$ 100,000.00
Brian Bowman 7/8/2020 Michelle IA/etdner
7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 34 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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 Street Department to expend
$ 1,044.00 plus est. shipping costs of $ to pay for or purchase
1 - Professions 26" Diamond Concrete Blade
This purchase or expenditure is being made because:
To Saw concrete to be removed and replaced in street repair
Vendor selected for this purchase:
�■ Bids or written quotes were taken on this purchase, as follows:
Black Hawk Rental Waterloo, IA
$1,044.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 n Sewer n Sanitation
❑ Bonds ❑ Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
266-19-7100-1555
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Sandie Greco
$ 6,500.00
$ 6,500.00
7/7/2020 Michelle We�dnev 7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 37 of 215
City Clerk Use Only
Finance Committee
Approval Date 7/13/2020
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
$ 7,340.00 plus est. shipping costs of $ to pay for or purchase
4 - Autoscope Cameras and Interface Panels
This purchase or expenditure is being made because:
Replace 2 cameras at the 218 off ramp and San Marnan Drive. 2 Cameras in inventory.
(Only vendor to carry autoscope to replace current cameras that fail)
Vendor selected for this purchase:
�■ Bids or written quotes were taken on this purchase, as follows:
Traffic Control Corporation Ankeny, IA
$7,340.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 n Sewer n Sanitation
❑l Bonds ❑ Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
418-17-7161-2125
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is $ 96,500.00
and the current available balance is
Respectfully submitted,
Sandie Greco 7/7/2020
$ 7,726.17
Michelle W e/dner
7/13/2020
(Signature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010)
Page 39 of 215
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
Project Name
City Contract No.
Project Manager
Project Budget Total
IA Arts & Culture Emergency Relief Grant
Kent Shankle
$ 14,000.00
1. How will this project be funded?
To be assigned by the Finance Dept.
Project No. 26FED
Subproject No. CARES2
A. Federal Grant Yes x No CFDA # % Paid by federal grant
Grant Name Federal Pass thru grant award Grant Agreement Number
B. State Grant Yes x No % Paid by state grant
Grant Name Emergency Relief Fund Round Two Grant Agreement Numbe 202005-9430
C. City Match Source of Funding % Paid by City
D. Other Entities Yes No % Paid by other entity
Name
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
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.
6. Include a brief description of the project in the space below: (REQUIRED)
see attached Grant application information
Done None
❑x ❑
❑ ❑x
❑ ❑x
CI CI
❑ ❑x
❑ ❑x
❑ ❑x
❑ ❑x
Iowa Arts Emergency Relief Grant Humanities Award
received on 6/2/20 $14,000
To be used for general operating support due to lower anticipated revenues because of COVID-19
(salaries or utilities)
Page 2 must be attached and signed.
K:\shared goodies\forms\FY2020-Proj_Budg-IA_Dpt_C.Affairs-Relief_award_6-22-20_(1).xls\Page 1 All Projects (Mar 2010)
CONSTRUCTION PROJECT BUDGET WORKSHEET
PAGE TWO
Project Name (from page one)
City Clerk Use Only
Committee
Approval Date A/ 7/13/2020
Department No. project will be budgeted under
Activity No. project will be budgeted under
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: Fund: Fund: Fund:
Total
TOTALS $ $ $ $ $
2103 Engineering & Consulting
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 $
Michelle Meidner
7/13/2020
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\FY2020-Proj_Budg-IA_Dpt_C.Affairs-Relief_award_6-22-20_(1).xls\Page 2 (Constr Proj) (Mar 2010)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
City Clerk Use Only
Committee
Approval Date MIN 7/13/2020
Project Name (from page one) IA Arts & Culture Emergency Relief Grant
Department No. project will be budgeted under 26
Activity No. project will be budgeted under 4265
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
3373 Fed Pass Thru from Iowa
EXPENDITURES:
To be assigned by the Finance Dept.
Project No. 26FED
Subproject No. CARES2
(Each column should only include amounts by fund)
Fund:010 Fund: Fund: Fund:
Total
14,000.00 14,000.00
TOTALS $ 14,000.00 $ $ - $ $ 14,000.00
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
1390 Contractual Services
Salaries or Utilities-
$
14,000.00 14,000.00
TOTALS $ 14,000.00 $ $ $ - $ 14,000.00
Kent Shankle 6/22/20
Michelle l4/eidner
7/13/2020
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\FY2020-Proj_Budg-IA_Dpt_C.Affairs-Relief_award_6-22-20_(1).xls\Page 2 (Donat or NON-constr) (Mar 2010)
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
Project Name
City Contract No.
Project Manager
Project Budget Total
CFDNEIA-"DOLLAR DAYS" WITH THE PHELPS YOUTH PAVILLION
KENT SHANKLE/CRAIG LAUE
$ 5,000.00
1. How will this project be funded?
A. Federal Grant Yes No
Grant Name
CFDA #
B. State Grant Yes No
Grant Name
C. City Match Source of Funding
D. Other Entities Yes X No
Name
COMMUNITY FOUNDATION OF NE IOWA
To be assigned by the Finance Dept.
Project No. 26GFT.
Subproject No. CFDOLLAR
% Paid by federal grant
Grant Agreement Number
% Paid by state grant
Grant Agreement Number
% Paid by City
% Paid by other entity
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
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.
6. Include a brief description of the project in the space below: (REQUIRED)
SUPPORT OF PROGRAMMING FUNDS FOR THE PYP DOLLAR DAYS
Done None
❑X ❑
❑ 0
❑ ❑X
❑ ❑X
❑ 0
❑ ❑X
❑ ❑X
❑ ❑X
THESE GRANT FUNDS WILL HELP SUPPORT NOT RAISING THE FEES FOR DOLLAR DAY ADMISSION
SEE ATTACHED APPLICATION AND AWARD LETTER
Page 2 must be attached and signed.
K:\shared goodies\forms\FY2021-CFDNEIA-DOLLARDAYS_SUP_6-19-20_(3).xls\Page 1 All Projects (Mar 2010)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
City Clerk Use Only
Finance Committee
Approval Date
M/ 7/13/2020
Project Name (from page one) CFDNEIA-"DOLLAR DAYS" WITH THE PHELPS YOUTH PAVILLION
Department No. project will be budgeted under 26
Activity No. project will be budgeted under 4265
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. 26GFT-
Subproject No. CFDOLLAR
(Each column should only include amounts by fund)
Fund:010 Fund: Fund: Fund:
Total
5,000.00 5,000.00
TOTALS $ 5,000.00 $ $ - $ $ 5,000.00
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
1390 Contractual Services
1524 SUPPLIES
1350 EXHIBIT SUPP
1,667.00
1,666.00 1,666.00
1,667.00 1,667.00
TOTALS $ 5,000.00 $ $ $ $ 5,000.00
Kent Shankle 6/23/20
Michelle Weidner
7/13/2020
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\FY2021-CFDNEIA-DOLLARDAYS_SUP_6-19-20_(3).xls\Page 2 (Donat or NON-constr) (Mar 2010)
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
Project Name
City Contract No.
Project Manager
Project Budget Total
First Responders Fund
Captain Mohlis
$ 5,000.00
1. How will this project be funded?
A. Federal Grant Yes 11 No
Grant Name
CFDA #
B. State Grant Yes L� No
Grant Name
C. City Match Source of Funding
D. Other Entities Yes x No
Name
Waterloo Community Foundation
To be assigned by the Finance Dept.
Project No. 11 PRO
Subproject No. WCFFRF
% Paid by federal grant
Grant Agreement Number
% Paid by state grant
Grant Agreement Number
% Paid by City
% Paid by other entity
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
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
❑ ❑x
❑ ❑x
❑ ❑x
❑ ❑x
❑ ❑x
❑ ❑x
6. Include a brief description of the project in the space below: (REQUIRED)
Donations from the Waterloo Community Foundation will be used for expenses related to COVID-19 community outreach to
families, elderly and children.
Page 2 must be attached and signed.
K:\shared goodies\forms\First_Responders_Fund_Project_Budget_Worksheet (1).xls\Page 1 All Projects (Mar 2010)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
City Clerk Use Only
Finance Committee
Approval DateA114/ 7/13/2020
Project Name (from page one) First Responders Fund
Department No. project will be budgeted under 11
Activity No. project will be budgeted under 010 11 1160
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. 11 PRO
Subproject No. WCFFRF
(Each column should only include amounts by fund)
Fund:
1160 Fund: Fund: Fund:
Total
5,000.00 5,000.00
TOTALS $ 5,000.00 $ $ - $ $ 5,000.00
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
1390 Contractual Services
1325 Crime Prevention
5,000.00 5,000.00
TOTALS $ 5,000.00 $ $ $ - $ 5,000.00
Dave Mohlis, Police Captain 7/8/202C
Michelle W eidner
7/13/2020
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\First_Responders_ Fund_ Project_Budget_Worksheet (1).xls\Page 2 (Donat or NON-constr) (Mar 2010)
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
Project Name
City Contract No.
Project Manager
Project Budget Total
Waterloo Police Department Racial Equity Training
Captain Mohlis
$ 52,000.00
1. How will this project be funded?
A. Federal Grant Yes 11 No
Grant Name
CFDA #
B. State Grant Yes L� No
Grant Name
C. City Match Source of Funding
D. Other Entities Yes x No
Name
Waterloo Community Foundation
To be assigned by the Finance Dept.
Project No. 11 PRO
Subproject No. RETRAIN
% Paid by federal grant
Grant Agreement Number
% Paid by state grant
Grant Agreement Number
% Paid by City
% Paid by other entity
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
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
❑ ❑x
❑ ❑x
❑ ❑x
❑ ❑x
❑ ❑x
❑ ❑x
6. Include a brief description of the project in the space below: (REQUIRED)
Donations from the Waterloo Community Foundation will be used to cover officer training, focusing on racial equality, as well aE
early intervention software.
Page 2 must be attached and signed.
K:\shared goodies\forms\Racial_Equality_Training_Project_Budget-1.xls\Page 1 All Projects (Mar 2010)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
City Clerk Use Only
Committee
Approval Date xN 7/13/2020
Project Name (from page one) Waterloo Police Department Racial Equity Training
Department No. project will be budgeted under 11
Activity No. project will be budgeted under 010 11 1160
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. 11 PRO
Subproject No. RETRAIN
(Each column should only include amounts by fund)
Fund:
1160 Fund: Fund: Fund:
Total
52,000.00 52,000.00
TOTALS $ 52,000.00 $ $ $ $ 52,000.00
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
1390 Contractual Services
1520 Computer Software
32,550.00 32,550.00
19,450.00 19,450.00
TOTALS $ 52,000.00 $ $ - $ - $ 52,000.00
Dave Mohlis, Police Captain 07/08/20
Michelle Meidner
7/13/2020
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Racial_Equality_ Training_Project_Budget-1.xls\Page 2 (Donat or NON-constr) (Mar 2010)