Loading...
HomeMy WebLinkAboutSupplemental Attachments - 10.17.2022City of Waterloo Finance Committee Preliminary Draft Invoice Report For ctok er 17 2 22 pproval Finance Committee Accounts Payable Open Invoice Report Total As of Thursday, October 13, 2022 EFT Transactions Thursday Total Sales Tax 2,754,800.93 Add: Wellmark 2,676,495.25 78,305.68 201,875.04 2,956,675.97 Workers Compensation Issued by TPA Housing Authority Assistance EFT's Housing Authority Assistance EFT's Payroll 4,146.70 Bill Payment Total - Monday, October 17, 2022 2,960,822.67 Payment to Council members or related entities: City of Waterloo Finance Committee Preliminary Draft Invoice Report Finance Committee Accounts Payable Open Invoice Report Total As of Thursday, October o5, 2022 EFT Transactions Add: Wellmark Add: Wellmark 690,666.19 109,563.00 318,047.41 1,118,276.60 Workers Compensation Issued by TPA Housing Authority Assistance EFT's Housing Authority Assistance EFT's Payroll 1,920,574.12 Bill Payment Total - Monday, October to, 2022 3,038,850.72 Payment to Council. members or related entitles APPLICANT'S NAME: APPLICATION FOR VARIANCE TO NOISE ORDINANCE Ern 11\1 N\Y't APPLICANT'S ADDRESS: > I 0 it s V31) APPLICANT'S PHONE #: 515 - , }),-ou f 4 or' 31q- R 8350 ANTICJPATED DATE OF VARIANCE: NOW 1a /9` t at o i , •� . NAME OF EVENT; ► c iev 100 og ivy Nis hi TIMES OF DAY OF VARIANCE: r pm GEOGRAPHICAL LOCATION OF VARIANCE: R big ca rove turf ?ay C tO f. Hivi on Jo of pciyi( yoffiV t DISTANCEE br AC`I'I IT PO RE Ttii. 1ROPERTIES: PLEASE EXPLAIN THE EVENT REQUIRING THE VARIANCE ,AND BE SPECIFIC, INCLUDE GEOGRAPHICAL LOCATION, AND WHAT ACTUALLY WILL EXCEED THE NOISE ORDINANCE, SUCH AS A BAND PLAYING, PA SYSTEM, ETC, a wit timak19)) 410.tion of e Ali. ns II as a Mutt thlYttOrIc olovi . _w t actviiiCS w 111 Vi(firtirl f Y1 RroVAS afitvi A (Iran n p 011 1& intOt c {j c(1rV1QYY oaW pvvt E 9 ill 14. rinwav hum vic errs o‘mOV 0 p0 Pie 1 mg .. GI.Y 1ii, . i y Mkt 9 1"1 s S ' a t 1 1'S. " e r Cif VGLi . CITY COUNCIL ACTION: Nu APPROVAL: DENIAL: 10/17/2022 4A1 pplicant's gnatu !0iq11- Dte Police Dept. Recommendation APPROVAL: cP1/ DENIAL: DECIBEL LEVEL: '^%'G "Ai- FINANCE DEPT. STAFF ONLY LINE ITEM USED 224-32-5870-1346 TRAVEL REQUEST CITY OF WATERLOO FY 23 BUDGETED 5,500.00 EXPENDED YTD 0 THIS REQUEST 3,845.00 LEFT AFTER THIS REQUEST 1,655.00 DATE 9/29/2022 Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S): Angie Fordyce/Pam Mast/Rudy Jones DATE: 9/29/22 NAME OF CLASS / MEETING: National Community Development Association HOME Underwriting/ Subsidy Layering DESTINATION: DEPARTURE POINT IF NOT WATERLOO: Woodstock, Illinois DEPARTURE DATE: October 30, 2022 RETURN DATE: November 2, 2022 DATE(S) OF MEETING: October 31, 2022- November 2, 2022 PURPOSE OF TRAVEL/TRAINING: Advanced course focusing on HOME funds. This is a follow up to the HOME basic course with a more detailed look at actual HOME funded projects, Underwriting/Subsidy layering requirements for home buyer and rental development projects. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: x CITY VEHICLE AIRFARE PRIVATE VEHICLE DEPARTING FROM: Carnegie Annex ESTIMATE OF COST: 2075.00 420.00 1150.00 150.00 LODGING MEALS REGISTRATION MILEAGE/FUEL 50.00 TOTAL FOR ALL: $ 3845.00 TAXI PARKING AIRFARE MISC/TOLLS BUDGET LINE ITEM: 224 32 5870 1346 X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 1281.67 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Rudy D. Jones I APPROVE THIS TRAVEL REQUEST lfih +tafr DEPARTMENT HEAD MAYOR 9/30/2022 October 17, 2022 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 FINANCE DEPT. STAFF ONLY LINE ITEM USED 010-12-1400 1346 TRAVEL REQUEST CITY OF WATERLOO FY 23 BUDGETED 5,500.00 EXPENDED YTD 3,417.93 THIS REQUEST 1,350.00 LEFT AFTER THIS REQUEST 732.07 DATE 10-03-2022 Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S): Brock Weliver, Fire Marshal Jeremiah VanDyke, Fire Investigator DATE: 10-03-2022 NAME OF CLASS / MEETING: 2022 Fire Prevention & Building Safety Education Conference DESTINATION: DEPARTURE POINT IF NOT WATERLOO: Des Moines, Iowa DEPARTURE DATE: 11-01-2022 RETURN DATE: 11-03-2022 DATE(S) OF MEETING: 11 /01 /2022 - 11/03/2022 PURPOSE OF TRAVEL/TRAINING: Continuing Education & Iowa Fire Marshal's Association Meeting WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: 650.00 LODGING 100.00 MEALS 500.00 REGISTRATION 100.00 MILEAGE/FUEL TOTAL FOR ALL: $ 1,350.00 TAXI PARKING AIRFARE MISC/TOLLS BUDGET LINE ITEM: 010-12-1400 1346 X GRANT REIMBURSABLE YES NO X YES NO REQUIRED CERTIFICATION TOTAL: $ 675.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Pat Treloar I APPROVE THIS TRAVEL REQUEST �tlh cart DEPARTMENT HEAD MAYOR 10-03-2022 October 17, 2022 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 FINANCE DEPT. STAFF ONLY LINE ITEM USED 010-12-1415 1346 TRAVEL REQUEST CITY OF WATERLOO NOTE: Travel/Meals/Hotel is 1000/0 Northeast Iowa Response Group reimbursable. FY 23 BUDGETED 1,200.00 EXPENDED YTD 724.25 THIS REQUEST 465.00 LEFT AFTER THIS REQUEST 10.75 DATE 10-03-2022 Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S): David Jensson, Captain of Training Benjamin Lowe, FF/PM DATE: 10-03-2022 NAME OF CLASS / MEETING: 2022 Iowa HazMat Training Symposium DESTINATION: ,Johnston, Iowa DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: 09-29-2022 RETURN DATE: 09-30-2022 DATE(S) OF MEETING: September 29-30, 2022 PURPOSE OF TRAVEL/TRAINING: 2022 Iowa HazMat Training Symposium WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: CITY VEHICLE X PRIVATE VEHICLE AIRFARE DEPARTING FROM: Waterloo, Iowa ESTIMATE OF COST: 100.00 LODGING 40.00 MEALS 100.00 REGISTRATION 225.00 MILEAGE/FUEL TOTAL FOR ALL: $ 465.00 TAXI PARKING AIRFARE MISC/TOLLS BUDGET LINE ITEM: 010-12-1415 1346 X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 232.50 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Pat Treloar I APPROVE THIS TRAVEL REQUEST lfih +fax DEPARTMENT HEAD MAYOR 10-03-2022 October 17, 2022 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. STAFF ONLY �, . LINE ITEM USED 1€23/1 "-' FY BUDGETED EXPENDED YTb THIS REQUEST LEFT AFTER THIS REQUEST BATE Ori. inal - Clerk/Finance Co. - De • •rtment NAME(S) AND POSITION(S): Quentin Hart DATE: September 22, 2022 NAME OF CLASS / MEETING: Honeywell Meeting DESTINATION: Waterloo DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: RETURN DATE: DATE(S) OF MEETING: 9/22/22 PURPOSE OF TRAVEL/TRAINING: Meals for Small City Stragegic Planning kick-off. Costs divided between Public Works, MIS and Mayor's Office. -4 -13Y5- 3o,Danc�01aikwor a 4t Rpsi- 010- $387. 75 - rival C .O ¢ 55 7, e5 266-17-7120-1345 $387.75 -Q wVjliC Nivrt_5q-7 ‘ i g.-7 60 P 26 q . ap 010-01-8220-1346 $387.77- YVCiS t a --1,C� ,10 �' �'-7,q ) WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: YES NO COST $ METHOD OF TRAVEL: CITY VEHICLE PRIVATE VEHICLE AIRFARE DEPARTING FROM: ESTIMATE OF COST: LODGING TAXI I (403,a-1 MEALS PARKING REGISTRATION AIRFARE MILEAGE/FUEL MISC/TOLLS TOTAL FOR ALL: $ 1,163.27 BUDGET LINE ITEM: S.Q,Q CA„\0D . GRANT REIMBURSABLE YES NO REQUIRED CERTIFICATION YES NO TOTAL: $ PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO im-rd I APPROVE THIS TRAVEL REQUEST DEPARTMENT H - - D MAYOR DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 October 17, 2022 DATE Waterloo imm Convention vom Center City of Waterloo Wendy Bowman 715 Mulberry Waterloo, IA 50703 Invoice - Honeywell Meeting Account: Amount Due: 00001543 $1,163.27 City/Honeywell Meeting (6481) Department Summary Audio Visual Catering / Food Service Equipment Order Description Audio Visual Thursday September 22nd (09/22/2022 11.00 AM - 03:30 PM) 2968 Large AV Cart Video- 8'x8' Standard Tripod Screen Video- 3700 Lumen Projector Catering t Food, Service Beverage Service (09/22/2022 11:00 AM - 03:30 PM) 2969 Regular Coffee- 1.5 gal Coca Cola Soda (Misc Flavors)- 12 oz Cai All Day Water Service Lunch Buffet (09/22/2022 12:00 PM - 01:00 PM) 3000 Barbecue Pit Lunch Buffet w/Smoked Bee Tangy Cole Slaw Smoked Pulled Barbecue Chicken Barbecue Shredded Pork Slow -Smoked Beef Brisket Buttered Corn w/ Peppers & Onions Brown Sugar Baked Beans Cornbread & Whipped Honey Butter Fruit Cobbler w/ Whipped Cream Iced Tea Snack (09/22/2022 02:00 PM - 02:15 PM) 2970 Assorted Fresh Baked Cookies (1 dz) Equipment Thursday September 22nd (09/22/2022 11:00 AM - 03:30 PM) CBL310 $o.00 $953.50 $o.00 Start -End: Thu 09/22/2022 07:00 AM - 11:59 PM Tax Units 22.0000% 22.0000% 22.0000% 22.0000% 1.00 EA 1.00 EA 1.00 EA Rate $0.00/ EA 0.00 / EA 0.00/ EA Total For Audio Visual: 2.00 EA 30.00 EA 1.00 EA $40.00 / EA 2.00 / EA 45.00 / EA Total For Beverage Service: 29.00 EA $26.50 / EA 22.0000% 3.00 EA $0.00 / EA Total For Catering / Food Service: Page 1 of 2 Charges $0.00 0.00 0.00 $80.00 60.00 45.00 $185.00 $768.50 $0.00 $953.50 Invoice - Honeywell Meeting City/Honeywell Meeting (6481) Order Description Tax Equipment (Continued} 2968 Table- 6'x30" Aluminum Swirl Chair- Purple Banquet Easel Whiteboard Easel Table- 60" Round Start -End: Thu 09/22/2022 07:00 AM - 11:59 PM Units Rate Charges 4.00 EA 30.00 EA 2.00 EA $0.00 / EA 0.00/EA 0.00/EA 6.00 EA 0.00 / EA Total For Equipment: Total Services: Catering Management Charge, 953.50 @ 22.0000% Total Charges: $0.00 0.00 0.00 0.00 $0.00 $953.50 209.77 $1,163.27 Total Services: Total Taxes: Total Charges: Total Payments: Total Amount Due: CBL310 Page 2 of 2 $953.50 $209.77 $1,163.27 $0.00 $1,163.27 Waterloo Convention Center Event Resume Page 1 of 2 Created Date: 9/17/2022 Created Time: 9:14 pm Account: City of Waterloo Post As: City/Honeywell Meeting Address: 715 Mulberry Waterloo, IA 50703 Contact: Wendy Bowman Phone: (319) 291-4522 ext 3037 Email: wendy.bowman@waterloo-ia.org On -Site: Guarantee Due Date: Direct Bill: Tax Exempt: Y Sales Manager: Brendon Wagner Event Manager: Rhett Jones FOOD & BEVERAGE ARE SUBJECT TO A 22°/ SURCHARGE AND APPLICABLE SALES TAX Date T. Room Function Thu, Sep. 22, 22 11:00 AM - 03:30 PM Ballroom C Thursday September 22nd Thu, Sep. 22, 22 11:00 AM - 11:00 AM Ballroom C Thu, Sep. 22, 22 11:00 AM - 11:00 AM Ballroom C Room Set By 0 0 0 0 0 0 Client Arrives Thu, Sep. 22, 22 11:00 AM - 03:30 PM Ballroom C Thu, Sep. 22, 22 12:00 PM - 01:00 PM Ballroom C Thu, Sep. 22, 22 12:00 PM - 03:30 PM Ballroom C 0 0 0 Beverage Service 0 0 0 Lunch Buffet Meeting 0 0 0 0 0 0 Thu, Sep. 22, 22 02:00 PM - 02:15 PM Ballroom C Thu, Sep. 22, 22 03:30 PM - 03:30 PM Ballroom C Break Meeting Ends 0 0 0 0 0 0 Thu, Sep. 22, 22 05:00 PM - 05:00 PM Ballroom C Thu, Sep. 22, 22 02:00 PM - 02:15 PM Ballroom C Thu, Sep. 22, 22 02:00 PM - 02:15 PM Ballroom C Facility Lock Up 0 0 0 Refresh Beverages 0 0 0 Snack 0 0 0 Thursday S ttd 11:00 AM tt 0 PM Operations Equipment 4.0 Table- 6'x30" Aluminum Swirl 30.0 Chair- Purple Banquet 2.0 Easel Whiteboard Easel 6.0 Table- 60" Round Audio Visual Audio Visual 1.0 Large AV Cart 1.0 Video- 8'x8' Standard Tripod Screen 1.0 Video- 3700 Lumen Projector Beverage Service 11:00 AM to 03:3tt PM F&B Food All guarantee numbers are due by 5PM on the date listed in the Guarantee Due Date box at the top of this event resume. Should the guarantee not be received, the expected number will become the basis for all charges. Organization Authorized Signature Date Facility Representative Signature Date Waterloo Convention Center Event Resume Page 2 of 2 Created Date: 9/17/2022 Created Time: 9:14 om Account: City of Waterloo Post As: City/Honeywell Address- 715 Mulberry Meeting 50703 Contact: Wendy Bowman Phone: (319) 291-4522 ext 3037 Email: wendy.bowman@waterloo-ia.org On -Site: Waterloo, IA Guarantee Due Date: Direct Bill: Tax Exempt: Y Sales Manager: Brendon Wagner Event Manager: Rhett Jones Beverage Service 11:00 AM to 03:30 PM Ballroom C F&B Food (Continued) Catering / Food Service 2.0 Regular Coffee- 1.5 gal 30.0 Coca Cola Soda (Misc Flavors)- 12 oz Cans 1.0 All Day Water Service @ $40.00 EA @ $2.00 EA @ $45.00 EA Coffee and Sodas are billed on consumption based upon need of the event. Water pitcher and 2 glasses on each table. Additional pitchers available on beverage station for refilling. $80.00 $60.00 $45.00 Lunch Buffet 2:00F attrco F&B Food Catering / Food Service 29.0 Barbecue Pit Lunch Buffet w/Smoked Beef Brisket Tangy Cole Slaw Smoked Pulled Barbecue Chicken Barbecue Shredded Pork Slow -Smoked Beef Brisket Buttered Corn w/ Peppers & Onions Brown Sugar Baked Beans Cornbread & Whipped Honey Butter Fruit Cobbler w/ Whipped Cream Iced Tea @ $26.50 EA $768.50 Snack 02:00 PM 02i1 PI elm F&B Food Catering / Food Service 3.0 Assorted Fresh Baked Cookies (1 dz) All guarantee numbers are due by 5PM on the date listed in the Guarantee Due Date box at the top of this event resume. Should the guarantee not be received, the expected number will become the basis for all charges. Organization Authorized Signature Date Facility Representative Signature Date J /1 Bridgett Wood From: Brendon Wagner <Brendon.Wagner@oakviewgroup.com> Sent: Friday, October 14, 2022 3:15 PM To: Bridgett Wood Subject: RE: Invoice for Honeywell Meeting Attachments: C0001039_v00.pdf CAUTION: This email originated from outside the City of Waterloo email system. Do not click links or open unexpected attachments unless you recognize the sender and know the content is safe. Hi Bridgett, I highlighted the 2 areas that will show you it is not state tax, but it is the catering management charge. The City's account is set up as tax exempt so "State Tax" or "Sales Tax" does not ever show up on your invoices. Let me know if you have any questions. BRENDON WAGNER General Manager OVG 360 1 Waterloo Convention Center 200 W. 4th St. I Waterloo, IA 50701 0: (319) 291-0155 ext. 3860 From: Bridgett Wood <Bridgett.Wood@WATERLOO-IA.ORG> Sent: Friday, October 14, 2022 10:42 AM To: Brendon Wagner <Brendon.Wagner@oakviewgroup.com> Subject: Invoice for Honeywell Meeting Here is my email. Thanks, Bridgett Wood Fnance Manager City of Waterloo 715 Mulberry St Waterloo, IA 50703 Phone: 319-291-4323 PURSUANT TO IOWA CODE CHAPTER 22 E-MAIL COMMUNICATION TO AND FROM THIS ADDRESS MAY BE SUBJECT TO PUBLIC DISCLOSURE. 1