HomeMy WebLinkAboutApproved Documents - 3/7/2022City Clerk Use Only
Finance Committee
Approval Date 3/7/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 Bldg Maintenance Department to expend
$ 6,270.00 plus est. shipping costs of $ to pay for or purchase
This purchase or expenditure is being made because:
Update finish on inside of front and rear elevator cab doors with stainless steel finish at Five
Sullivan Brothers.
Vendor selected for this purchase:
Schumacher Elevator
n Bids or written quotes were taken on this purchase, as follows:
n Bids or quotes were not taken on this purchase because:
Schumacher is our current vendor.
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:
420-22-6860-2152
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Greg Ahlhelm - Building Official 2/23/2022
$ 1,730,000.00
$ 80,549.56
Tviic/tee& 7uz
3/7/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 3/7/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 City Clerk Department to expend
$ 8,620.00 plus est. shipping costs of $ N/A to pay for or purchase
Time Keeping Software
This purchase or expenditure is being made because:
Purchase made for time keeping software
Vendor selected for this purchase:
Midwest Automated Time Systems
n Bids or written quotes were taken on this purchase, as follows:
n Bids or quotes were not taken on this purchase because:
Renewing existing payroll software services provided by Midwest Automated Time Systems.
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-03-8400-1520
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Kelley Felchle, City Clerk
$ 154,500.00
$ 21,435.44
2/16/22 re,Pe k Neateh
3/7/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 3/7/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/Street Department to expend
$ 13,700.00 plus est. shipping costs of $ 725.00 to pay for or purchase
1 - John Deere 624K Rebuilt Front Axle PG200262 with required Core Exchange for 2009 Endloader
This purchase or expenditure is being made because:
Rebuild Front Axle on 2009 Endloader
Vendor selected for this purchase:
Truck Center Companies
Ti Bids or written quotes were taken on this purchase, as follows:
AMS Construction Parts Middleton, OH
$13,700.00
Cajun Equipment Parts
Baton Rouge, LA $20,500.00
Murphy Tractor
Waterloo, IA $27,495.12
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-7955-1571
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is $ 550,500.00
and the current available balance is $ 45,095.22
Respectfully submitted,
Sandie Greco 2/17/2022
PPS Zte iL
3/7/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 3/7/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
$ 101.99 per unit
plus est. shipping costs of
Leisure Services Department to expend
$ NA to pay for or purchase
portable handicap restrooms to be placed at various parks.
This purchase or expenditure is being made because:
The units are placed in various parks for the summer season. Approximately 12 units
are rented per month and vary relating to park activities. Price fixed @ $101.99
Vendor selected for this purchase:
Cooley Pumping (dba Paul's Potties) Grundy Center, IA
n Bids or written quotes were taken on this purchase, as follows:
Estimated expense for FY 2022 $2,500
Estimated expense for FY 2023 $2,907
IT Bids or quotes were not taken on this purchase because:
Vendor agreed to continue service at last year's pricing. No additional charges for
delivery or pickup.
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-37-4100 1390
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is $ 201,860.00 200,500.00
and the current available balance is $ 87,431.36 200,500.00
Respectfully submitted,
Paul Huting 2/18/2022�� zoh 3/7/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 3/7/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
$ 5,000.00 plus est. shipping costs of $ to pay for or purchase
One Cushman 800 Hauler utility vehicle.
This purchase or expenditure is being made because:
To replace Gates Golf Course Starter utility vehicle. A $5,500 trade allowance is being applied
to the transaction due to trading in a John Deere Gator.
Vendor selected for this purchase: Turfwerks of Johnston, Iowa
�■ Bids or written quotes were taken on this purchase, as follows:
Turfwerks, Cushman 800 Hauler, Johnston Iowa $5,000.00
P&K Midwest, Gator TS, Waterloo Iowa $8,967.89
P&K Midwest, Gator TX, Waterloo Iowa $9.915.89
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)
This expenditure is to be coded to the following budget line -item:
420-37-4120-2113, $5,000.00
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is $ 60,000.00
and the current available balance is
Respectfully submitted,
Paul Huting 2/16/2022
$ 4,793.70
3/7/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 3/7/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 Planning Department to expend
$ 8,000.00 plus est. shipping costs of $ 0.00 to pay for or purchase
Removal of shrubs, trees, and tree stumps on property at 300 Allen Street
This purchase or expenditure is being made because:
As a condition of the sale of property to Habitat for Humanity, who will rehab dwelling per recently approved DA, Habitat is requiring removal of trees,
which are in close proximity to the foundation/garage. If Habitat was not rehabbing the dwelling, City would have trees removed as part of the demo.
Vendor selected for this purchase:
Tree Pros
n Bids or written quotes were taken on this purchase, as follows:
Tree Pros - $8,000 (only bid received)
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)
This expenditure is to be coded to the following budget line -item:
420 08 5150 1396
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
Noel Anderson
$ 230,000.00
$ 209,316.96
2/23/22 e Nei ✓z
3/7/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 3/7/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
$ 18,127.09 plus est. shipping costs of $ 00 to pay for or purchase
Provide furnishings for new Sergeant office, new Officers Room and replacement
partition in Watch Commander Office. Materials and labor.
This purchase or expenditure is being made because:
Furnishings needed for department reonovations in the relocation and
reconfiguration of the sergeant office, officers room & a partition in watch command
Vendor selected for this purchase:
Storey Kenworthy
n Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
This is NCPA contract pricing through vendor Storey Kenworthy.
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 Police Dept. Improvements
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is $ 168,478.05
and the current available balance is $ 124,192.81
Respectfully submitted,
Lt. Aaron McClelland 2/11/22
Z ZO 5
3/7/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 3/7/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
$ 12,717.00 plus est. shipping costs of $ 00 to pay for or purchase
Painting in common areas, stairs/rails, halls, doors/frames, locker room, new officer
room, and corridors on all three floors.
This purchase or expenditure is being made because:
Painting has not been done in almost 20 years. The identified areas are dirty,
scuffed and damaged from years of wear & tear.
Vendor selected for this purchase: Michaels Painting
n Bids or written quotes were taken on this purchase, as follows:
Michaels Painting $12,717
Modern Painting $13,692
Personified Painting $17,145
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
419-11-1100-2152 Police Dept. 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
Respectfully submitted,
Lt McClelland 2/24/22
zoo
(Project Code)
$ 168,790.16
$ 129,355.85
3/7/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 3/7/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
$ 8,060.00 plus est. shipping costs of $ 236.60 to pay for or purchase
Lockers and benches
This purchase or expenditure is being made because:
Women's Locker room project/ Building renovations
Vendor selected for this purchase:
ULINE
n Bids or written quotes were taken on this purchase, as follows:
n Bids or quotes were not taken on this purchase because:
All online pricing for lockers similar were hundreds more per locker and not cost effective.
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 $ 168,478.05
and the current available balance is $ 132,489.41
Respectfully submitted,
Aaron McClelland, Police Lieutenat 2/10/2022
3/7/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 3/7/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
$ 7,842.00
plus est. shipping costs of
Department to expend
$ 125.00 to pay for or purchase
Lobe, seal and wear plate kits for Vogelsang primary sludge pumps.
This purchase or expenditure is being made because:
Primary sludge pumps are in need of replacement parts.
Vendor selected for this purchase: Zimmer & Francescon
n Bids or written quotes were taken on this purchase, as follows:
IT Bids or quotes were not taken on this purchase because:
Zimmer & Francescon is the sole provider for Vogelsang pumps within Iowa.
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 $ 400,000.00
and the current available balance is
Respectfully submitted,
Brian Bowman
2/10/22 O Hie.46efe. Nerfcah
$ 144,031.22
3/7/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 3/7/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 Street/Sewer Department to expend
$ 6,245.00 plus est. shipping costs of $ 545.00 to pay for or purchase
25 - Traffic Drums, Barrel Tire Rings and 50 - A -Frame Barricade Kits
This purchase or expenditure is being made because:
Safety equipment for street closures due to construction and maintenance.
Vendor selected for this purchase: Traffic Safety Warehouse
n Bids or written quotes were taken on this purchase, as follows:
Traffic Safety Warehouse Deerfield, IL.
$6,245.00
Traffic Safety Store
West Chester, PA $7,778.75
Grainger
Waterloo, IA $10,244.25
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:
266-19-7100-1577 $ 1,783.75 520-14-5200-1573 $5,006.25
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is $ 7,700.00 15,000.00
and the current available balance is $ 4,058.50 7.225.32
Respectfully submitted,
Sandie Greco 2/22/2022
w
3/7/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
Finance Committee approval required?
YES ® NO
If so, date approved: 3/7/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
37RST.YAMI
11,123.13
010 37 4105 1371
Bkdg Maint
37RST.YAMI
11,123.13
TOTAL
This amendment is being requested because:
$11,123.13
TOTAL
$11,123.13
To budget to use funds reeived in prior years for building repairs..
Prior Committee Actions (Dates):
Paul Huting 2/15/2022
zoo
3/7/2022
(Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date
Date Posted (Finance Dept.)
K:\users\shared goodies\forms\Waterloo.32139.1.Budget_Amend_YAMI_2022 (Apr 2003)
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
Project Name
City Contract No.
Project Manager
Project Budget Total
Convention Center 2nd Floor Impr; Plaza
Greg Ahlhelm
$ 820,000.00
1. How will this project be funded?
A. Federal Grant Yes No X CFDA #
Grant Name
B. State Grant
Grant Name
C. City Match
D. Other Entities Yes X No
Name
Yes No
Source of Funding GO Bonds
BHC Gaming Assn Grant
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
To be assigned by the Finance Dept.
Project No. 22FAC
Subproject No. CCGAME
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
❑ ❑
❑ ❑
❑ ❑x
❑ ❑x
❑ ❑x
❑ ❑x
6. Include a brief description of the project in the space below: (REQUIRED)
This project will fund a portion of the convention center improvements to the interior 2nd floor and the exterior plaza.
Page 2 must be attached and signed.
K:\shared goodies\forms\Waterloo.32055.1.Convention_Center_2nd_Floor_ Plaza_ Gaming_Project_Budget\Page 1 All Projects (Mar 2010)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
City Clerk Use Only
Finance Committee
Approval Date 3/7/2022
Project Name (from page one) Convention Center 2nd Floor, Plaza
Department No. project will be budgeted under 22
Activity No. project will be budgeted under 6860
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
3905 TIF Revenue
EXPENDITURES:
To be assigned by the Finance Dept.
Project No. 22FAC
Subproject No. CCGAME
(Each column should only include amounts by fund)
Fund: 426
Fund: Fund:
Fund: Total
820,000.00 820,000.00
TOTALS $ 820,000.00 $ $ - $ $ 820,000.00
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
1390 Contractual Services
2140 Land Purchase
1358 Econ Dev Grant
2152 Building Impr
2144 Land Impr
200,000.00 200,000.00
620,000.00 620,000.00
TOTALS $ 820,000.00 $
Michelle Weidner 2/9/2022
avl
$ $ 820,000.00
3/7/2022
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Waterloo.32055.1.Convention_Center_2nd_Floor_Plaza_Gaming_Project_Budget\Page 2 (Donat or NON-constr)
(Mar 2010)
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
Project Name Police Grant- State and Community Highway Safety Grant Task 70
City Contract No.
Project Manager
Project Budget Total
Captain Dave Mohlis
$ 50,300.00
1. How will this project be funded?
A. Federal Grant Yes
Grant Name
No
CFDA #
B. State Grant Yes
Grant Name
No
State and Community Highway Safety Grant
C. City Match Source of Funding
D. Other Entities Yes
Name
No
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
To be assigned by the Finance Dept.
Project No. 11GRT
Subproject No. IDCTK70
% Paid by federal grant
Grant Agreement Number
% Paid by state grant
100.00%
Grant Agreement Number PAP 22-402-MOPT
% 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.
6. Include a brief description of the project in the space below: (REQUIRED)
This grant will cover directed overtime enforcement, training related travel & two PBT's.
Done None
❑X ❑
Yes No
❑ ❑X
❑ ❑X
❑ ❑X
❑ ❑X
❑ ❑X
❑ ❑X
❑ ❑X
Page 2 must be attached and signed.
K:\shared goodies\forms\Waterloo.32210.1.Highway_Safety_Grant_Task_70_Project_Budget_Worksheet_(1)\Page 1 All Projects (Mar 2010)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
City Clerk Use Only
Finance Committee
Approval Date 3/7/2022
Project Name (from page one) Police Grant- State and Community Highway Safety Grant Task 70
Department No. project will be budgeted under 11
Activity No. project will be budgeted under 010 11 1150
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 for Iowa
EXPENDITURES:
To be assigned by the Finance Dept.
Project No. 11GRT
Subproject No. IDCTK70
(Each column should only include amounts by fund)
Fund: 1150 Fund: Fund: Fund:
Total
50,300.00 50,300.00
TOTALS $ 50,300.00 $ - $ - $ - $ 50,300.00
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
1390 Contractual Services
1125 Overtime
1563 In Car Video Camera
1573 Prelim Breath Analyzers
900.00 900.00
48,500.00 48,500.00
0.00
900.00 900.00
TOTALS $ 50,300.00 $ - $ $ $ 50,300.00
Capt. Dave Mohlis
(Signature Dept. Head)
2/18/2022 an,werk 3/7/2022
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Waterloo.32210.1.Highway_Safety_Grant_Task_70_Project_Budget_Worksheet_(1)\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
FY21 Bureau of Justice Assistance (JAG) 15PBJA-21-GG-01439-JAGX
Captain Dave Mohlis
$ 46,305.00
1. How will this project be funded?
A. Federal Grant Yes
Grant Name
B. State Grant
Grant Name
C. City Match
No
To be assigned by the Finance Dept.
Project No. 11GRT
Subproject No. JAG21
CFDA # 16.738 % Paid by federal grant 100.00%
FY21 Bureau of Justice Assistance (JAG)
Yes No
Source of Funding
D. Other Entities Yes
Name
No
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
Grant Agreement Number 15PBJA-21-GG-0143
% 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
❑ ❑X
❑ ❑X
❑ ❑X
❑ ❑X
❑ ❑X
❑X ❑
6. Include a brief description of the project in the space below: (REQUIRED)
Funds allocated by the 2021 Justice Assistance Grant will be used in a joint effort by the City of Waterloo, City of Cedar Falls
and Black Hawk County for law enforcement personnel costs for officers assigned to the Tri-County Drug Enforcement Task
Force which is a multi -jurisdictional task force responsible for investigation of drug related crime.
The funds will be used to supplement salary/benefits & overtime not funded through the Byrne Justice Assistance Grant.
Page 2 must be attached and signed.
K:\shared goodies\forms\Waterloo.32130.1.JAG_21_FY21_Project_Budget_Worksheet\Page 1 All Projects (Mar 2010)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
City Clerk Use Only
Finance Committee
Approval Date 3/7/2022
Project Name (from page one) FY21 Bureau of Justice Assistance (JAG) 15PBJA-21-GG-01439-JAGX
Department No. project will be budgeted under 11
Activity No. project will be budgeted under 010 11 1150
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:
010 11 1160
To be assigned by the Finance Dept.
Project No. 11GRT
Subproject No. JAG21
(Each column should only include amounts by fund)
Fund: 1150 Fund: 1160 Fund: Fund:
27,783.00
Total
18,522.00 46,305.00
TOTALS $ 27,783.00 $ 18,522.00 $ $ - $ 46,305.00
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
1390 Contractual Services
1302 Outside Agencies
27,783.00 $ 27,783.00
18,522.00 18,522.00
TOTALS $ 27,783.00 $ 18,522.00 $ $ $ 46,305.00
Dave Mohlis- Police Captain
(Signature Dept. Head)
2/18/2022
Date
3/7/2022
(Signature Finance Dept. Review) Date
K:\shared goodies\forms\Waterloo.32130.1.JAG_21_FY21_Project_Budget_Worksheet\Page 2 (Donat or NON-constr) (Mar 2010)
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
Project Name IDOT Commercial Service Vertical Infrastructure FY-22 Grant
City Contract No.
Project Manager
Project Budget Total
Keith Kaspari
$ 126,752.00
1. How will this project be funded?
A. Federal Grant Yes
Grant Name
No
CFDA #
B. State Grant Yes X No
Grant Name IDOT Commercial Service Vertical Infrastructure
C. City Match Source of Funding
D. Other Entities Yes
Name
To be assigned by the Finance Dept.
Project No. 29PRO
Subproject No. VI22
% Paid by federal grant
% Paid by state grant
% Paid by City
No X % Paid by other entity
Attach copies of any grant agreements that will fund the project (REQUIRED)
2. 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, attach authorization to purchase real property to this document.
3. Please indicate any non -participating expenses that you are aware will be incurred, such as:
A. Stormwater permit fees
B. Publication, or printing costs
C. Others, list
4. Does this project cover any regular full-time salaries or benefits?
If yes, employee/position to be covered.
100.00%
Done None
❑X
Yes No
❑ ❑X
❑ ❑
Done None
❑ ❑
Yes None
❑ ❑X
5. Include a brief description of the project in the space below: (REQUIRED)
The purpose of this agreement is for accomplishment of certain infrastructure improvements at the Waterloo Regional Airport,
indentified as: Hangar Rehabilitation, specifically Hangar 4 office area.
Page 2 must be attached and signed.
users\michelle-w\forms\Waterloo.32211.1.Project_Budget_Wkshts_IDOT_Vert_Infr_FY22\Page 1 All Projects (Feb 2007)
CONSTRUCTION PROJECT BUDGET WORKSHEET
PAGE TWO
Project Name (from page one) IDOT Commercial Service Vertical Infrastructure FY-22 Grant
Department No. project will be budgeted under 29
Activity No. project will be budgeted under 7760
REVENUES:
3000 Cash on Hand
3112 Local Option Sales Tax
3350 Federal Grant
3353 Federal U-Step Grant
3358 Shared Program - City
3360 Shared Program - State
3361 State Grant
3365 State RISE Grant
3368 EPA Grant
3377 EDA Grant
3750 Sale of Bonds
3800 Miscellaneous Revenue
EXPENDITURES:
To be assigned by the Finance Dept.
Project No. 29PRO
Subproject No. V122
(Each column should only include amounts by fund)
Fund: 291 Fund: Fund: Fund:
Total
126,752.00 126,752.00
TOTALS $ 126,752.00
$ $ 126,752.00
2103 Engineering & Consulting $ 37,500.00 $ 37,500.00
2125 Traffic Control Equipment
2140 Land Acquisition
2144 Land Improvements
2146 Demolitions
2156 Bikeway Construction
2161 Bridges
2162 Storm Sewers
2163 Sanitary Sewers
2164 Sidewalks
2165 Streets & Roadways
2199 Non -participating Misc
2169 Airport Improv 89,252.00 89,252.00
TOTALS $ 126,752.00 $ $ - $ - $ 126,752.00
Keith Kaspari 2/22/2022
irticAdt 7iOP h
3/7/2022
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
users\michelle-w\forms\Waterloo.32211.1.Project_Budget_Wkshts_IDOT_Vert_Infr_FY22\Page 2 (Constr Proj) (April 2003)
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
Project Name
City Contract No.
Project Manager
Project Budget Total
GRT KANE
Pat Treloar
$ 10,000.00
1. How will this project be funded?
A. Federal Grant Yes No CFDA #
Grant Name
B. State Grant Yes No L
Grant Name
C. City Match Source of Funding
D. Other Entities Yes X No
Name
Donation: James Kane
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
To be assigned by the Finance Dept.
Project No. 12GRT
Subproject No. KANE
% 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.
6. Include a brief description of the project in the space below: (REQUIRED)
Purchasing: -Meals for WFR personnel -Specialized equipment
100.00%
Done None
❑ ❑X
Yes No
❑ ❑X
❑ ❑
El El
❑ ❑X
❑ ❑
❑ ❑
Page 2 must be attached and signed.
K:\shared goodies\forms\Waterloo.32161.1.GRT_KANE_Project_Budget_Worksheet_(2)\Page 1 All Projects (Mar 2010)
CONSTRUCTION PROJECT BUDGET WORKSHEET
PAGE TWO
Project Name (from page one)
City Clerk Use Only
Finance Committee
Approval Date 3/7/2022
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 $
» w* eidteh
3/7/2022
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Waterloo.32161.1.GRT_KANE_Project_Budget_Worksheet_(2)\Page 2 (Constr Proj) (Mar 2010)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
City Clerk Use Only
Finance Committee
Approval Date 3/7/2022
Project Name (from page one) GRT KANE
Department No. project will be budgeted under 12
Activity No. project will be budgeted under 1412
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
3721 Private Donation
EXPENDITURES:
To be assigned by the Finance Dept.
Project No. 12GRT
Subproject No. KANE
(Each column should only include amounts by fund)
Fund: Fund: Fund: Fund:
Total
10,000.00 10,000.00
TOTALS $ 10,000.00 $ - $ $ - $ 10,000.00
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
1390 Contractual Services
2112 Firefighting Equipment
1394 Restaurant/Food Service
7,500.00 7,500.00
2,500.00 2,500.00
TOTALS $ 10,000.00 $ - $ $ - $ 10,000.00
Pat Treloar 01-27-2022
zu
3/7/2022
(Signature Dept. Head) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Waterloo.32161.1.GRT_KANE_Project_Budget_Worksheet_(2)\Page 2 (Donat or NON-constr) (Mar 2010)