The URL can be used to link to this page

Home My WebLink AboutSupplemental Attachments - 8/29/2022City of Waterloo Finance Committee Preliminary Draft Invoice Report For a t 2 20 2 proval Finance Committee Accounts Payable Open Invoice Report Total As of Thursday, August 18, 2022 Add: Treasurer State of Iowa Add: Wellmark 791,272.71 1,836.59 243,424.59 18,900.00 1,055,433.89 Workers Compensation Issued by TPA Housing Authority Assistance EFT's Housing Authority Assistance EFT's Payroll 6,312.46 2,761.92 Bill Payment Total - Monday, August 22, 2022 1,064,508.27 Payment to Council members or related entities: City of Waterloo Finance Committee Preliminary Draft Invoice Report For gu t 29 2 22 p royal Finance Committee Accounts Payable Open Invoice Report Total As of Thursday, August 25, 2022 Thursday Total Bank Fees 1,187,587.32 Add:Wellmark Claims 1,181,551.57 6,035.75 156,566.26 1,344,153.58 Workers Compensation Issued by TPA Housing Authority Assistance EFT's Housing Authority Assistance EFT's Payroll 23,852.05 5,548.19 404,817.05 1,958,488.66 Bill Payment Total - Monday, August 29, 2022 3,736,859.53 Payment to Council members or related entities: P(a";hg ge-ss)ti aYlCihq 1 1 aodou-E Whitewater Potential Funding Sources $12,527,856 million project, 40/60 split - Game Plan State Other(local) 5,011,142 $ 7,516,714 Notes State Placemaking Gaming City -bonds (2025,2026) City-TIF ARPA (City) WDC Other Low Head Dam funds? EDA? Trail enhancement funds? $ 5,011,142 $900,000 $ 1,000,000 $ 500,000 $ 1,300,000 $ 4,200,000 $ 100,000 40% of total Based on Jim Miller email on Gaming commit and percentage to Waterloo Had an upper limit of $4.2 to $5.2 million not yet explored not yet explored not yet broken out for review $ 13,011,142 $ FINANCE DEPT. STAFF ONLY LINE ITEM USED 0102725051346 TRAVEL REOUEST FY 2023 BUDGETED 5700.00 EXPENDED YTD 2247.00 THIS REQUEST 220.00 LEFT AFTER THIS REQUEST 3233.00 DATE Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S):Abraham L. Funchess, Jr. DATE: —HRTS Director 08/05/2022 NAME OF CLASS / MEETING: DESTINATION: Waterloo, IA Iowa League of Cities Annual conference & Exhibit DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: September 28, 2022 RETURN DATE: September 30, 2022 DATE(S) OF MEETING: September 28-30, 2022 PURPOSE OF TRAVEL/TRAINING: To attend the Annual Conference & Exhibit of the Iowa League of Cities. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: CITY VEHICLE X PRIVATE VEHICLE AIRFARE DEPARTING FROM: ESTIMATE OF COST: LODGING TAXI MEALS PARKING 220.00 REGISTRATION AIRFARE MILEAGE/FUEL MISC/TOLLS TOTAL FOR ALL: $ 220.00 BUDGET LINE ITEM: 010-27-2505-1346 GRANT REIMBURSABLE YES NO YES NO TOTAL: $ 220.00 PER PERSON REQUIRED CERTIFICATION I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Abraham L. Funchess, Jr. I APPROVE THIS TRAVEL REQUEST fih 1-4,± DEPARTMENT HEAD MAYOR August 5, 2022 8/29/2022 DATE DATE K:AShared Goodies\Forms\Travel Request Form January 2010 FINANCE DEPT. STAFF ONLY LINE ITEM USED TRAVEL REQUEST CITY OF WATERLOO FY BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S): Rusty Zey, Ops Coord; Randy Shepard, Ops Spec; Troy Deeds, Ops Spec, + New Ops Spec (if hired by this date) DATE: August 5, 2022 NAME OF CLASS / MEETING: Live Air Craft Fire - Hot Burn Training DESTINATION: Eastern Iowa Airport DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: Sep 8, 2022 or Sep 9, 2022 RETURN DATE: Sep 8, 2022 or Sep 9, 2022 DATE(S) OF MEETING: Sep 8, 2022 and Sep 9, 2022 PURPOSE OF TRAVEL/TRAINING: Annual live fire training for all Airport Ops personnel assigned to Aircraft Rescue Fire Fighting is required by the FAA for compliance with Federal Aviation Regulation (FAR) Part 139. If new Ops Specialist(s) have been hired, they would be sent for observation both days. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE DEPARTING FROM: ALO PRIVATE VEHICLE ESTIMATE OF COST: LODGING TAXI MEALS PARKING approx $450 REGISTRATION AIRFARE MILEAGE/FUEL MISC/TOLLS TOTAL FOR ALL: $ 1,800 BUDGET LINE ITEM: 010 29 7700 1346 X GRANT REIMBURSABLE YES NO X YES NO TOTAL: $ 450 REQUIRED CERTIFICATION PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Keith Kaspari I APPROVE THIS TRAVEL REQUEST .QvvAtIv, +tart DEPARTMENT HEAD MAYOR 8/5/2022 8/29/2022 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 23 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 010-11-1100-1346 $123,416.00 $31,577.83 $11,500.00 $80,338.17 8/9/221 Copy - Department NAME(S) AND POSITION(S): Captain Robert Duncan DATE: 8/9/22 NAME OF CLASS / MEETING: Northwestern School of Police Staff and Command DESTINATION: Des Moines, Iowa DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: 9/19/22 to 1/20/23 RETURN DATE: 1/20/23 DATE(S) OF MEETING: 10 week school conducted in two week sessions PURPOSE OF TRAVEL/TRAINING: to attend a 10 week training hosted by Northwestern University, this class prepares law enforcement managers for senior command positions by combining academic principles with practical application. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE DEPARTING FROM: Waterloo PRIVATE VEHICLE ESTIMATE OF COST: $5,000.00 LODGING $2,000.00 MEALS $4,500.00 REGISTRATION MILEAGE/FUEL TOTAL FOR ALL: $ 11,500.00 TAXI PARKING AIRFARE MISC/TOLLS BUDGET LINE ITEM: X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 11,500.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Steve Bose, Lieutenant Training Unit I APPROVE THIS TRAVEL REQUEST DEPARTMENT HEAD MAYOR 8/9/22 DATE 8/29/2022 DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 FINANCE DEPT. STAFF ONLY LINE ITEM USED TRAVEL REQUEST CITY OF WATERLOO FY BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S): Julie Dawson, Director DATE: 08/29/2022 NAME OF CLASS / MEETING: Iowa League of Cities Annual Conference 2022 DESTINATION: DEPARTURE POINT IF NOT WATERLOO: Waterloo, IA DEPARTURE DATE: 09/28/2022 RETURN DATE: 09/30/2022 DATE(S) OF MEETING: 09/28 - 30/2022 PURPOSE OF TRAVEL/TRAINING: To attend the 2022 Iowa League of Cities Annual Conference and Exhibit WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: CITY VEHICLE X PRIVATE VEHICLE AIRFARE DEPARTING FROM: Waterloo, IA ESTIMATE OF COST: LODGING TAXI MEALS PARKING 390.00 REGISTRATION AIRFARE MILEAGE/FUEL MISC/TOLLS TOTAL FOR ALL: $ 390.00 BUDGET LINE ITEM: 283-13-5452 1346 X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 390.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Julie Dawson I APPROVE THIS TRAVEL REQUEST tZLVAtil, mart DEPARTMENT HEAD MAYOR 08/29/2022 8/29/2022 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 22 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 266-19-7200-1346 1,000,00 0.00 610.00 390.00 8/15/22 Copy - Department NAME(S) AND POSITION(S): Matt Boquist, Street Department Director DATE: August 15, 2022 NAME OF CLASS I MEETING: APWA (American Public Works Association) Fall Conference DEPARTURE DATE: October 5, 2022 DESTINATION: Sioux City, Iowa DEPARTURE POINT IF NOT WATERLOO: DATE(S) OF MEETING: October 5-7, 2022 RETURN DATE: October 7, 2022 PURPOSE OF TRAVEL/TRAINING: Attend workshops on planning and preparation in winter maintenance operations, what equipment is available and how to maintain it, innovations in technology and leadership. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: $200.00 LODGING $110.00 MEALS $200.00 REGISTRATION $/00.00 MILEAGE/FUEL TOTAL FOR ALL: $ 610.00 TAXI PARKING AIRFARE MISCITOLLS BUDGET LINE ITEM: GRANT REIMBURSABLE YES REQUIRED CERTIFICATION YES NO TOTAL: $ 610.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO PARTMENT HEAD August 15, 2022 I APPROVE THIS TRAVEL REQUEST lfih +ia� SPED MAYOR 8/29/2022 DATE DATE K:\Sliared Goodies\Forrs\Travel Request Form January 2010 FINANCE DEPT. STAFF ONLY LINE ITEM USED 010 08 5700 1345 TRAVEL REQUEST CITY OF WATERLOO FY _23_ BUDGETED $ 2,500 EXPENDED YTD 0 THIS REQUEST $ 1,320 LEFT AFTER THIS REQUEST $ 1,180 DATE 8-9-22 Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S): Noel Anderson, CP&D Director; Adrienne Miller & Tim Andera, ED Specialists; John Dornoff, Planner 11; Seth Hyberger & Lexi Blank, Planner I DATE: August 9, 2022 NAME OF CLASS / MEETING: Iowa League of Cities Annual Conference DESTINATION: Waterloo, IA DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: September 28, 2022 RETURN DATE: DATE(S) OF MEETING: September 30, 2022 September 28-30, 2022 PURPOSE OF TRAVEL/TRAINING: To attend the 2022 Annual Iowa League of Cities Conference & Exhibit WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: LODGING TAXI MEALS PARKING 220 REGISTRATION AIRFARE MILEAGE/FUEL MISC/TOLLS TOTAL FOR ALL: $ 1,320 BUDGET LINE ITEM: 010 08 5700 1345 X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 220 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO I APPROVE THIS TRAVEL REQUEST DEPARTMENT HEAD MAYOR June 14, 2022 8/29/2022 Ri!c%ared Goodies\Forms\Travel Request Form January 2010 DATE TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 22 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 010-18-7950-1346 800.00 0.00 510.00 290.00 8/15/22 Cop - be.artment NAME(S) AND POSITION(S): Rich Strange, Fleet Maintenance Director DATE: August 15, 2022 NAME OF CLASS I MEETING: APWA (American Public Works Association) Fall Conference DEPARTURE DATE: October 5, 2022 DESTINATION: Sioux City, Iowa DEPARTURE POINT IF NOT WATERLOO: DATE(S) OF MEETING: October 5-7, 2022 RETURN DATE: October 7, 2022 PURPOSE OF TRAVEL/TRAINING: Attend workshops on planning and preparation in winter maintenance operations, what equipment is available and how to maintain it, innovations in technology and leadership. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: $200.00 $110.00 $200.00 LODGING MEALS REGISTRATION MILEAGE/FUEL TOTAL FOR ALL: $ 510.00 TAXI PARKING AIRFARE MISCITOLLS BUDGET LINE ITEM: GRANT REIMBURSABLE YES YES NO TOTAL: $ 510.00 REQUIRED CERTIFICATION PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO August 15, 2022 DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 I APPROVE THIS TRAVEL REQUEST SICGNES MAYOR 8/29/2022 DATE TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. STAFF ONLY LINE ITEM USED 010-11-1160-134611PRO.Retrain FY 23 BUDGETED $24,000.00 EXPENDED YTD $0.00 THIS REQUEST $2,100.00 LEFT AFTER THIS REQUEST $2,100.00 DATE 8/9/22 Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S): Sergeants Erie, Gann, Ludwig, Monroe, Schuster, Zubak DATE: 8/9/22 NAME OF CLASS / MEETING: FBI- LEEDA Advanced Supervisor Liability Course 22-4A DESTINATION: DEPARTURE POINT IF NOT WATERLOO: Waterloo, Ia. DEPARTURE DATE: 7/11/22 RETURN DATE: 7/31/22 DATE(S) OF MEETING: 7/11-31/22 PURPOSE OF TRAVEL/TRAINING: The above listed officers will be attending the FBI LEEDA training course Advanced Supervisor Liability. This course is a must for newly promoted and current supervisors and cover topics such as constitutional policing through the training of proper supervision standards This is an online course and will not exceed $2,100.00. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: CITY VEHICLE PRIVATE VEHICLE AIRFARE DEPARTING FROM: ESTIMATE OF COST: 0.00 LODGING 0.00 MEALS $2,100.00 REGISTRATION 0.00 MILEAGE/FUEL TOTAL FOR ALL: $ 2100.00 TAXI PARKING AIRFARE MISC/TOLLS BUDGET LINE ITEM: 010-11-1160-1346 11PRO.Retrain X GRANT REIMBURSABLE YES NO x YES NO REQUIRED CERTIFICATION TOTAL: $ 350.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Steven Bose, Lieutenant Training Unit I APPROVE THIS TRAVEL REQUEST DL,ekstiv, hart DEPARTMENT HEAD MAYOR 8/9/22 8/29/2022 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010