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