Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Approved Documents - 1/3/2023
City Clerk Use Only Finance Committee 1/3/2023 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 Engineering Department to expend $ 5,325.20 plus est. shipping costs of $ 0 to pay for or purchase Annual renewal of our design software. This purchase or expenditure is being made because: Software is used for road design, platting, sanitary sewer, storm sewer, water, projects. Used to design projects for numerous departments besides Engineering Vendor selected for this purchase: DLT n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: DLT is the only government provider of this software. 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) LOST This expenditure is to be coded to the following budget line -item: 205-07-7830-1520 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Jamie Knutson 11/28/2022 $ 8,000.00 $ 6,373.23 L 1 /3/2023 t LFC (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) OLT Price Quotation A rECW DATA COWAN', Quote: 5138104 Reference: 1744735 Date: 12/15/2022 Expires: 01/16/2023 Mr. Jamie Knutson Waterloo City of (IA) 715 Mulberry Street Waterloo, IA 50703 Phone: (319) 291-4312 Fax: (319) 291-4262 Email: jamie.knutson@waterloo-ia.org Ervin So DLT Solutions, LLC 2411 Dulles Corner Park Suite 800 Herndon, VA 20171 Phone: (703) 708-9688 Fax: (703) 708-9688 Email: ervin.so©dlt.com # DLT Part No. Contract Qty Unit Price Ext. Price 1 2 9701-1008733 OMIT 411 $1,232.55 Architecture Engineering & Construction Collection Government Single -user Annual Subscription Renewal Switched From Maintenance (Switched between May 2019 - May 2020 and Ongoing) PoP: 3/6/2023 through 3/5/2024 9971-30221 OM 1 $395.00 IMAGINiT Priority Support - up to 5 users PoP: 3/6/2023 through 3/5/2024 $4,930.20 $395.00 Total $5,325.20 Contract Number: OPEN MARKET DUNS #: 78-646-8199 Federal ID #: 54-1599882 CAGE Code: OSOH9 FOB: Destination Terms: Net 30 (On Approved Credit) DLT accepts VISA/MC/AMEX UNLESS CONTROLLED BY AN EXISTING RESELLER PARTNER AGREEMENT OR OTHER WRITTEN CONTRACTUAL AGREEMENT BETWEEN YOU AND DLT, THIS QUOTE AND ANY RESULTING AWARD OR ORDER IS SUBJECT TO THE TERMS AND CONDITIONS POSTED AT HTTPS://WWW.DLT.COM/PRODUCTS/CLIENT-COMMERCIAL-LICENSES. THESE TERMS CONTROL THE TERMS OF SALES AS WELL AS THE END USER'S USE OF THE PRODUCTS AND/OR SERVICES INCLUDED IN THIS QUOTE. BUYER IS DIRECTED TO INCORPORATE (BY REFERENCE) THIS QUOTE IN ANY RESULTING AWARD OR ORDER. THE TERMS AND CONDITIONS AT THE ABOVE LINK ARE THE ONLY CONTROLLING TERMS THAT WILL APPLY TO A RESULTING ORDER AND THE USE OF THE PRODUCTS AND/OR SERVICES INCLUDED IN THIS QUOTE. ANY ADDITIONAL OR INCONSISTENT TERMS ON BUYER'S ORDER THAT IN ANY WAY, MODIFY, ALTER OR NEGATE THE TERMS OF SALE OR THE MANUFACTURER'S END USER LICENSE AGREEMENT WILL NOT BE BINDING ON DLT OR ITS MANUFACTURERS AND SHALL NOT APPLY UNLESS SPECIFICALLY AGREED TO IN WRITING BY DLT AND THE MANUFACTURER. NO RETURNS ARE AUTHORIZED OF THE PRODUCTS AND/OR SERVICES INCLUDED IN THIS QUOTE. THE PRODUCTS AND/OR SERVICES INCLUDED IN THIS QUOTE ARE NONRECOURSE, NONCANCELLABLE, AND NON -RETURNABLE UNLESS EXPLICITLY AGREED TO IN WRITING BY DLT. DLT CONFIDENTIAL Page 1 of 2 ELT A rECWDATA COMPANY Price Quotation Quote: 5138104 Reference: 1744735 Date: 12/15/2022 Expires: 01/16/2023 PLEASE REMIT PAYMENT TO: ACH: DLT Solutions, LLC Bank of America ABA # 111000012 Acct # 4451063799 -OR- Mail: DLT Solutions, LLC P.O. Box 743359 Atlanta, GA 30374-3359 Customer orders subject to applicable sales tax. Documentation to be submitted to validate Invoice for payment: a. Authorized Services shall be invoiced with a corresponding time report for the period of performance identifying names, days, and hours worked. b. Authorized reimbursable expenses shall be invoiced with a detailed expense report, documented by copies of supporting receipts. c. Authorized Education or Training shall be invoiced with a Report identifying date and name of class completed, and where applicable the name of attendees. DLT CONFIDENTIAL Page 2 of 2 City Clerk Use Only Finance Committee 1/3/2023 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 Fire Department to expend $ NTE $90,000.00 plus est. shipping costs of $ to pay for or purchase Firefighter turnout gear This purchase or expenditure is being made because: We are are in need of a second set of fire gear for our personnel. This order will be for 32 sets of gear. Vendor selected for this purchase: Sandry Fire Supply n Bids or written quotes were taken on this purchase, as follows: Sandry-$2,799.96 per set Dinges-$3,510.00 per set 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-12-1400 2112 Firefighting Equip (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Troy Luck (Signature Dept. Head or Designee) $ 100,000 $ 100,000 12/20/22,� �'— 1/3/2023 4i cr_u Date (Signature Finance Dept. R iew) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee 1/3/2023 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 $ NTE 25,000.00 plus est. shipping costs of Opticom multimode phase selectors Fire Department to expend $ to pay for or purchase This purchase or expenditure is being made because: There are a number of intersections where the opticom system is not functioning. This system ensures the safety of emergency vehicle response through intersections. Vendor selected for this purchase: Traffic Control Corporation (TCC) Single Source n Bids or written quotes were taken on this purchase, as follows: TCC-Opticom 764-$3985.00-per selector TCC-Opticom 762-$3500.00-per selector 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 ElBonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 010-12-1400 2112 ($10,000) and 010-12-1410 2116 ($15,000) FF Equip/Med&Lab Equip (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Troy Luck $ 100,000/100,000 $ 100,000/100,000 12-21-22 ( 1/3/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Roview) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee 1/3/2023 Approval Date City of Waterloo Expenditure Pre -Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Leisure Services Department to expend $ 3,322.00 plus est. shipping costs of $ to pay for or purchase Advertising through Coloff Media for the Cedar Valley SportsPlex. This purchase or expenditure is being made because: being able to advertise with Coloff Media will help retain members and recruit new members. Vendor selected for this purchase: Coloff Media, Cedar Falls IA ❑ Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: Coloff Media runs the local radio stations in the Cedar Valley. 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 Bonds Sanitation Federal/other grants ❑ Other (specify) hotel motel funds This expenditure is to be coded to the following budget line -item: 010-37-41051351 $2,004.0 010-37-41801351 37HMT.SPLX23 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Paul Huting 12/19/2022 (Signature Dept. Head or Designee) $ 12,000.00 2,000.00 $ 2,004.00 1,925.00 0,0 MIA!!v 1/3/2023 SIGNED Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee 1/3/2023 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 $ 24,102.00 plus est. shipping costs of $ to pay for or purchase 26 SLS Level II ballistic vests, carriers and name plates to be worn by sworn Officers while on duty in uniform. This purchase or expenditure is being made because: This part of a Federal grant that covers fifty percent of the actual vest expenses. These are new purchases for new hires as well as existing Officers with expired vests. Vendor selected for this purchase: CCG Safety Gear n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: The police department has a five year bid with CCG who is the distibutor for SLS vests. 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: 010-11-1150-1579 11 GRT.VST20($8,255.00)/ 421-11-1100-2128($15,847.00) 010-11-1150-1579 11 GRT.VST20 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ $18,672.50/$35,000.00 and the current available balance is $ $16,819/$35,000 Respectfully submitted, Aaron McClelland, Police Lieutenat 12/22/2022 Tu.Tu.em Nit 1/3/2023 (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 1/3/2023 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 $ 9,246.25 plus est. shipping costs of $ 0 to pay for or purchase Renewal of annual maintenance agreement for Sheildware 1/1/23-6/30/23. This purchase or expenditure is being made because: this is an annual renewal that supports the Sheildware system that is used by the Police Department for data collection and State of Iowa mandated reports. Vendor selected for this purchase: Shield Technology Corporation n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: This system is what is used county wide and is proprietary to the Shield Technology Corporation. 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-11-1105-1520 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 110,355.00 and the current available balance is $ 80.853.28 Respectfully submitted, Aaron McClelland, Police Captain 12/11/22 [tiO4, SIGNED 1/3/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. kview) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee 1/3/2023 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 Fire Department to expend $ 24,393.00 plus est. shipping costs of $ 1,449.20 to pay for or purchase Hi fidelity medical simulation manikin for use in continuing medical education required for Emergency Medical Technician and Paramedic licensing. This purchase or expenditure is being made because: The current simulation manikin is nearly 10 years old. Vendor selected for this purchase: n Bids or written quotes were taken on this purchase, as follows: n Bids or quotes were not taken on this purchase because: There are no comparable products and very few producers of medical simulation manikins. 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-2116 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Jason Hernandez, Medical Supervisor 12/27/2022 $ 100,000 $ 100,000 T 1t (/V aaq o�cRaur� sI 1 /3/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) helping save lives Laerdal Medical Corporation 167 Myers Corners Road Wappingers Falls, NY 12590 Phone Order To: 877-LAERDAL Fax Order To (800) 227-1143 Email customerservice@laerdal.com CLIENT EXECUTIVE Ben Zajicek benjamin.zajicek@laerdal.com To prevent any delays in processing your purchase, please include your quote # when ordering. DATE: 11/4/2022 ATTN: Mr. Dave Meiser NRP EMS Training Officer +13192913507 dave.meiser@waterloo-ia.org BILL TO: 02533544 Waterloo Fire Rescue 425 East 3rd Street Waterloo IA 50703 QUOTE NUMBER: CREDIT TERMS: EXPIRATION DATE: SHIP TO Waterloo Fire Rescue Dave Meiser 425 East 3rd Street Waterloo IA 50703 Q-629152 CC 12/31/2022 QTY PRODUCT DESCRIPTION LIST PRICE UNIT PRICE EXTENDED PRICE 1 200-05050 MegaCode Kelly Advanced $10,000.00 $10,000.00 $10,000.00 (L) Includes Manikin (SimPad Capable), 6 Neck Skins 1 roll of Pants, Directions Criothyroid Carry for Case, Use Membrane 6 Chest Tape Tube Airway Modules, Lubricant, BP Cuff Jacket, and .1 204-30001 SimPad PLUS System (US) $2,016.00 $2,016.00 $2,016.00 Includes SimPad PLUS Remote Control, SimPad PLUS Link Box, AC Adapter, Battery, Headset & Microphone, Wrist Strap, Manikin Strap Ethernet Cable, Protective Sleeve, PLUS and software USB license Cable. required 204-50150 for operation. LLEAP for SimPad 1 204-50150 LLEAP Includes• for License SimPad Key PLUS providing access to Manual Mode, $2,895.00 $2,895.00 $2,895.00 Automatic Mode, and Log Viewer Application. 1 200- EDVT025-SL Nursing/MegaCode Designed to Manikin Virtual Orientation for for Site $960.00 $960.00 $960.00 promote a personalized experience a Training single organization Orientation towards is Laerdal's developed Virtual as a Instructor beginner be -Led level course and geared any user who will for the two-hour live responsible operating training simulator.This teach basic instructor feature sets -led and virtual start-up and will shut down you procedures. simulator 1 200-83050 MegaCode Kelly Installation $2,075.00 $2,075.00 $2,075.00 1 200- 05050PMB Laerdal Includes MegaCode 1 service Kelly Preventative (product returned Maintenance, to Laerdal), Return full to $1,003.00 $1,003.00 $1,003.00 refurbishment or replacement of consumables & pad sets, refurbishment of skin and/or veins on IV Arm, product cleaning, final test & inspection of manikin, document of findings and recommendation Page 1 of 3 QTY PRODUCT DESCRIPTION LIST PRICE UNIT PRICE EXTENDED PRICE $76.00 1 185-50450 Zoll ShockLink Training Adapter $76.00 $76.00 1 381500 MegaCode Trauma Module Set $2,684.00 $2,684.00 $2,684.00 (L) $2,684.00 1 381550 Bleeding Trauma Modules (L) Set of 4 $2,684.00 $2,684.00 $24,393.00 TOTAL: ITEM TOTAL : SHIPPING/HANDLING : LOGISTIC SURCHARGE° TAX : TOTAL: There are various payment options; please see bottom of your quote for further clarification. Appropriate Sales Tax will be added to invoice — Pricing and Availability are subject to change Shipping/Handling costs will be added to invoice By Accepting this Quote, the following terms are hereby incorporated into customer's order: $24,393.00 $1,449 20 $0.00 , . 18:r $27123:68 W t P roducts: Products that are currently on contract will be removed immediately if manufacturing or distribution of the product is discontinued. P ayment N et 30 Days for approved open accounts; CIA; Credit Cards accepted. Financing options now available — sample leasing payment terms follow. Lease term 24 months: USD 1,076.76 * Lease term 36 months: USD 717.84 * Lease term 48 months: USD 538.38 * * Quoted payments do not include Interest, Taxes, Maintenance, Cancellation fees or Insurance. Quotes are subject to credit approval and may change without notice. Warranty: One(1) year warranty on manufactured products and 90 day warranty on refurbished products Two(2) year parts replacement warranty with technical assistance by phone on all Hill -Rom refurbished products Delivery: Delivery of product to a specific location within your building, if requested is at an additional charge and not included in this quote Training/Education: Onsite and Virtual Education will expire one (1) year from date of purchase. Exceptions include: • Educational Pathway trainings will expire two (2) years from date of purchase. Five (5) or more Ed Path Training days will expire in five (5) years. Contracts/Technology Sustainment Program (TSP) Advanced Care & Maintenance Courses • • CANCELLATION or RESCHEDULING of EDUCATIONAL or TECHNICAL SERVICES WILL RESULT IN CANCELLATION/RESCHEDULING FEES 7 DAYS OR LESS: 100% of Course / Service Cost Page 2 of 3 8 DAYS to 2 WEEKS: 75% of Course / Service Cost 15 DAYS to 20 DAYS: 50% of Course / Service Cost 3 WEEKS or MORE: NO FEE Customer will be required to submit a new PO to reschedule a cancelled course / service. Confidential • Page 3of3 Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES ® NO 1/3/2023 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 Human Rights 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 27 2510 27FHAP 4,493.80 010 27 2505 1346 Travel Prof training 4,493.80 010 27 2505 3000 Cash on Hand 2,000.00 010 27 2505 1351 Advertising 2,000.00 TOTAL This amendment is being requested because: To Cover short falls $6,493.80 TOTAL $6,493.80 Prior Committee Actions (Dates): (Signature Dept. Head or Designee) Date T 'CM IY slefifo 1/3/2023 ( ignature Finance Dept. rteview) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Waterloo.35796.1.Budget_Amendment_Request_Form_DEC_2022 (Apr 2003) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name City Contract No. Project Manager Project Budget Total Pavement Rehabilitation 2023 Keith Kaspari $ 1,535,340.00 1. How will this project be funded? A. Federal Grant Yes X No To be assigned by the Finance Dept. Project No. Subproject No. CFDA # 20.106 % Paid by federal grant 90.00% Grant Name AIP 053 Pavement Rehabilitation 2023 B. State Grant Yes No Grant Name C. City Match Source of Funding PFC Revenue D. Other Entities Yes No Name 2. Attach copies of any grant agreements that will fund the project (REQUIRED) Grant Agreement Number 3-19-0094-053 % 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. 10.00% Done None ❑ ❑X Yes No ❑ ❑ ❑ ❑ ❑ ❑ ❑X ❑ ❑X ❑ ❑X ❑ ❑X 6. Include a brief description of the project in the space below: (REQUIRED) The project will rehabilitate pavements to include Runway 12/30 at its full length and width (except the area within the Runway 18/36 runway safety area), Taxiway E from Taxiway A to Runway 30, and Taxiway A East. Page 2 must be attached and signed. K:\shared goodies\forms\Waterloo.35854.1.Project_Budget_Worksheet_AIP_053_Pavement_Rehabilitation\Page 1 All Projects (Mar 2010) CONSTRUCTION PROJECT BUDGET WORKSHEET PAGE TWO City Clerk Use Only Finance Committee 1/3/2023 Approval Date Project Name (from page one) Pavement Rehabilitation 2023 Department No. project will be budgeted under 29 Activity No. project will be budgeted under 7750 / 7755 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 3456 PFC EXPENDITURES: To be assigned by the Finance Dept. Project No. Subproject No. (Each column should only include amounts by fund) Fund: Fund: 291 291 Fund: Fund: Total 1,381,806.00 1,381,806.00 153,534.00 153,534.00 TOTALS $ 1,381,806.00 $ 153,534.00 $ $ $ 1,535,340.00 2103 Engineering & Consulting $ 259,254.00 $ 28,806.00 $ 288,060.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 2169 Airport Improvements 1,122,552.00 124,728.00 1,247,280.00 1371 Bldg & Grounds Maint. TOTALS $ 1,381,806.00 $ 153,534.00 $ $ $ 1,535,340.00 Keith Kaspari 12/15/2022 T i N o, SIGNED 1/3/2023 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Waterloo.35854.1.Project_Budget_Worksheet_AIP_053_Pavement_Rehabilitation\Page 2 (Constr Proj) (Mar 2010) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name City Contract No. Project Manager Project Budget Total Reconstruct Taxiway A West Keith Kaspari $ 2,256,089.00 1. How will this project be funded? To be assigned by the Finance Dept. Project No. Subproject No. A. Federal Grant Yes X No CFDA # 20.106 % Paid by federal grant 90.00% Grant Name BIL-AIP 056 Reconstruct Taxiway A West Grant Agreement Number 3-19-0094-056-2023 B. State Grant Yes No X % Paid by state grant Grant Name Grant Agreement Number C. City Match Source of Funding PFC Revenue % Paid by City 10.00% D. Other Entities Yes No X % 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. Done None ❑ ❑X Yes No ❑ ❑ ❑ ❑ ❑ ❑ ❑X ❑ ❑X ❑ ❑X ❑ ❑X 6. Include a brief description of the project in the space below: (REQUIRED) This project will include a complete reconstruction of Taxiway A West, and include pavement markings, signage and lighting. Page 2 must be attached and signed. K:\shared goodies\forms\Waterloo.35858.1.Project_Budget_Worksheet_BIL-AIP_056_Reconstruct_Taxiway_A_West\Page 1 All Projects (Mar 2010) CONSTRUCTION PROJECT BUDGET WORKSHEET PAGE TWO City Clerk Use Only Finance Committee 1/3/2023 Approval Date Project Name (from page one) Reconstruct Taxiway A West Department No. project will be budgeted under 29 Activity No. project will be budgeted under 7750 / 7755 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 3456 PFC EXPENDITURES: To be assigned by the Finance Dept. Project No. Subproject No. (Each column should only include amounts by fund) Fund: Fund: 291 291 Fund: Fund: 2,030,480.00 Total 2,030,480.00 225,609.00 225,609.00 TOTALS $ 2,030,480.00 $ 225,609.00 $ $ $ 2,256,089.00 2103 Engineering & Consulting $ 406,969.00 $ 45,219.00 $ 452,188.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 2169 Airport Improvements 1,623,511.00 180,390.00 1,803,901.00 1371 Bldg & Grounds Maint. TOTALS $ 2,030,480.00 $ 225,609.00 $ $ $ 2,256,089.00 Keith Kaspari 12/15/2022 Nao, si 1/3/2023 (Signature Dept. Head) Date (Signature Finance Dept. Review) K:\shared goodies\forms\Waterloo.35858.1.Project_Budget_Worksheet_BIL-AIP_056_Reconstruct_Taxiway_A_West\Page 2 (Constr Proj) (Mar 2010) Date PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name City Contract No. Project Manager Project Budget Total Anti -Heroin Task Force -Grant #22 #22-Heroin-22 Chief Leibold $ 7,000.00 1. How will this project be funded? A. Federal Grant Yes Grant Name No CFDA # #16.710 B. State Grant Yes Grant Name C. City Match No Source of Funding None 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. Subproject No. % Paid by federal grant 100.00% Grant Agreement Number #22-Heroin-22 % 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 CI CI CI CI ❑ ❑X ❑ ❑X ❑ ❑X ❑ ❑X 6. Include a brief description of the project in the space below: (REQUIRED) Grant funds will cover heroin related overtime through the WPD's Tri-County Drug Task Force activities Page 2 must be attached and signed. K:\shared goodies\forms\Waterloo.35815.1.Heroin_Grant#22_FY2023_Project_Budget_Worksheet\Page 1 All Projects (Mar 2010) PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION PAGE TWO City Clerk Use Only Finance Committee 1/3/2023 Approval Date Project Name (from page one) Anti -Heroin Task Force- Grant#22 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 3373 Fed Pass thru for Iowa 3720 Donations - Restricted 3750 Sale of Bonds EXPENDITURES: 010 11 1150 To be assigned by the Finance Dept. Project No. Subproject No. (Each column should only include amounts by fund) Fund: 1150 Fund: 1160 Fund: Fund: 4,900.00 Total 2,100.00 7,000.00 TOTALS $ 4,900.00 $ 2,100.00 $ $ - $ 7,000.00 1111 Salaries - Regular 1112 Salaries - Part Time 1114 Overtime 1302 Outside Agencies 1315 Education & Training 1345 Travel - Official City 1346 Travel - Prof Training 1390 Contractual Services 4,900.00 4,900.00 2,100.00 2,100.00 TOTALS $ 4,900.00 $ 2,100.00 $ $ - $ 7,000.00 Joe Leibold, Police Captain (Signature Dept. Head) 12/14/2022 Nao, sIOF i 1/3/2023 Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Waterloo.35815.1.Heroin_Grant#22_FY2023_Project_Budget_Worksheet\Page 2 (Donat or NON-constr) (Mar 2010)