HomeMy WebLinkAboutSupplemental Attachments - 4/15/19Finance Committee Accounts Payable Open Invoice Report Total
As of Friday, April 12, 2019
EFT Transactions:
580,551.89
Add: Wellmark Weekly Claims 270,445.62
City of Waterloo
Finance Committee Preliminary Draft Invoice Report
iiiii April 15 2019 Approok 1
1
850,997.51
Workers Compensation Issued by TPA
Housing Authority Housing Assistance EFT's
Housing Authority Housing Assistance EFT's
Payroll
4,162.70
3,015.10
1,701,645.53
Bill Payment Total - Monday, April 15, 2019
2,559,820.84
lyment to Council members or related entities:
La [l L(J VR9
To: City Council Members
Re: Notice of Severance
Department
Lc I1 O Ri 9 fl � _) i19
CITY HALL 715 MULBERRY STREET 50703
Mayor's Office
Today's Date: 3/21/2019
Effective Date: 3/29/2019
Employment Date: 6/29/1987
Job Title/Classification Executive Secretary to the Mayor
This is to report that the employment of Michelle Westphal
with the City of Waterloo has been severed by reason of:
Reti red
Disability Related
❑ Resigned
❑ Termination
❑ Other
No ❑ Yes
In accordance with City Policy, it is requested to allow payment which consists of the following:
Comments: Last day worked 3/29/19. — (, .i__ c'- l k ()Le. (c, ei( Lt. .1 (1 c `(
L,, s "1 of 0( /)o J ave -L Cs. t•-•. A 50 5C «4 l CM t \ �� ` a ,�1 't__/. a Nov2- cL'' y`Givt•. 7
Po\ l:j
f 001::e �� �1U�Q.�moi_ C 1i� 2, h t.tL,ic•, CIS.(( 1'c.{ c J O p (0-1 t'.c1 c(_ ct'.r %2 Qt�-e✓C F eS
J J �"� v
&hd / o ( C€51- •1t nc1 t t P tc�A-0C-S SVtctcl, bcc +'� ed cry s ► cic c t cat J vctt
1, 4P V\ COJC rn Ck CC e c:l , Q Cl* a4 tag ipi--ki f -z' `< `i C f43
Approved by DULLAA,: vA Date y a/ 1 Ct pc Of c
4\fMkti cAnchQ
Human Resources
Date
Routing:
Original to Human Resources by Department
Human Resources will forward original to City Clerk (Copy in Personnel File)
Clerk's Office will forward copy of approved form to Department and Human Resources
Council Agenda Date: .L‘/ 1.s (C ❑ Accruals ❑Status 0-9
Updated 6/28/11
Benefits
Total Hours
(x) Hourly Rate
Total Payout
Vacation -Accrued
48
$ 26.40
$1,267.20
Vacation -Current
215.25
$ 26.40
$ 5,682.60
Usable Sick Leave
Frozen Sick Leave
0
Personal Hours
30.05
26.40
$ 793.32
Comp Time Pay
26.57
,$ 26.40
$ 701.45
Unscheduled Leave
Birthday
8
$ 26.40
$ 211.20
Total Payment
$ 8,655.77
Comments: Last day worked 3/29/19. — (, .i__ c'- l k ()Le. (c, ei( Lt. .1 (1 c `(
L,, s "1 of 0( /)o J ave -L Cs. t•-•. A 50 5C «4 l CM t \ �� ` a ,�1 't__/. a Nov2- cL'' y`Givt•. 7
Po\ l:j
f 001::e �� �1U�Q.�moi_ C 1i� 2, h t.tL,ic•, CIS.(( 1'c.{ c J O p (0-1 t'.c1 c(_ ct'.r %2 Qt�-e✓C F eS
J J �"� v
&hd / o ( C€51- •1t nc1 t t P tc�A-0C-S SVtctcl, bcc +'� ed cry s ► cic c t cat J vctt
1, 4P V\ COJC rn Ck CC e c:l , Q Cl* a4 tag ipi--ki f -z' `< `i C f43
Approved by DULLAA,: vA Date y a/ 1 Ct pc Of c
4\fMkti cAnchQ
Human Resources
Date
Routing:
Original to Human Resources by Department
Human Resources will forward original to City Clerk (Copy in Personnel File)
Clerk's Office will forward copy of approved form to Department and Human Resources
Council Agenda Date: .L‘/ 1.s (C ❑ Accruals ❑Status 0-9
Updated 6/28/11
Name:
ID :
Michelle Westphal
10151
Exceptions/Additional Time Edits
Day/Date Hours Code Hours/$
Saecial Instructions
2/12/2019
-2.00
Sick Current
2.00
Sick Storage
2/11/2019
-8.00
Sick Current
8.00
Sick
Storage
2/8/2019
-2.00
Sick Current
2.00
Sick Storage
1/22/2019
-3.00
Sick Current
3.00
Sick Storage
1/14/2019
-1.00
Sick
Current
1.00
Sick Storage
1/4/2019
-8.00
Sick Current
8.00
Sick Storage
Sunday
Prepared By:
Supervisor:
Nikki Fischels
Department:
4/12/2019
4/2/2019
Yes -- NF
Day/Date
Hours Code
Mayor's Office
Pay Date to process correction
Date submitted to HR
Entered in MSS?
Hours/$
Special Instructions
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Hours Code Totals
Sick Storage
Sick Current
Number of Hours
24.00
-24.00
Total Hours/$ 0
CITY OF WATERLOO, IOWA
FINAL PAYOUT
CITY HALL 715 MULBERRY STREET 50703
Today's Date: 4/1/2019
Effective Date: 3/29/2019
Employment Date: 4/30/2012
To: City Council Members
Re: Notice of Severance
Department CULTURAL & ARTS
Job Title/Classification DEVELOPMENT & MARKETING MANAGER
This is to report that the employment of
LAURA STAMMLER
with the City of Waterloo has been severed by reason of:
❑ Retired
Disability Related ❑ No ❑ Yes
Resigned
❑ Termination
❑ Other
In accordance with City Policy, it is requested to allow payment which consists of the following:
2020
2019
CASUAL
Comments:
LAST WORKING DAY IS ON 3/29/19
Approved by".
Human Resources
DateX ', / ( / 19
Date 1 t Ci
Routing:
Original to Human Resources by Department
Human Resources will forward original to City Clerk (Copy in Personnel File)
Clerk's Office will forward copy of approved form to Department and Human Resources
Council Agenda Date: �� 15 / 1 t ❑ Accruals ❑Status 0-9
Updated 6/28/11
Benefits
Total Hours
(x) Hourly Rate
Total Payout
Vacation -Accrued
30
$ 19.35_$
580.50
Vacation -Current
87
$ 19.35
$ 1,683.45
Usable Sick Leave
-7.25
$ 19.35
$ (140.29)
$ -
Frozen Sick Leave
0
$ 19.35
Personal Hours
0
$ 19.35
$ -
Comp :Time Pay
0.27
$ 19.35
$ 5.22
Unscheduled Leave
$ 19.35
$ -
Other Pay
$ 19.35
$ -
Total Payment
$ 2,128.89
LAST WORKING DAY IS ON 3/29/19
Approved by".
Human Resources
DateX ', / ( / 19
Date 1 t Ci
Routing:
Original to Human Resources by Department
Human Resources will forward original to City Clerk (Copy in Personnel File)
Clerk's Office will forward copy of approved form to Department and Human Resources
Council Agenda Date: �� 15 / 1 t ❑ Accruals ❑Status 0-9
Updated 6/28/11
II RAVEL REQUEST
CITY OF WATERLOO
NAME(S) AND POSITION(S):
Chris Youngblut (Technology Services Director)
NAME OF CLASS / MEETING:
Iowa Technology & Geospatial Conference
DEPARTURE DATE:
Tuesday, June 181h, 2019
FINANCE DEPT. STAFF ONLY
LINE ITEM USED
FY 2O/ `j BUDGETED
EXPENDED YTD
THIS REQUEST
LEFT AFTER THIS
REQUEST
DATE
Original - Clerk/Finance
0/0 ar 1"2ao vo
/SOU `�
86—
714e')
ov
/7b
lo -/y
Co • - be•artment
Tuesday, June 18th — Friday, June 21St, 2019
DESTINATION: West Des Moines, IA
DEPARTURE POINT
IF NOT WATERLOO:
RETURN DATE:
Friday, June 21st, 2019
DATE(S) OF MEETING:
Tuesday, June 18th — Friday June 21st
PURPOSE OF TRAVEL/TRAINING:
The conference is a joint effort between the Iowa Geographic Information Council and the Iowa Counties Information
Technology organization. There will be more than 50 hours of educational content over the course of the conference split
between two educational tracks — one dedicated to IT technologies and one track compressed of topics of interest to both
GIS and IT Personnel. We will also be presenting on the topic of implementing an Enterprise GIS.
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL:
X COST $
YES NO
METHOD OF TRAVEL:
X CITY VEHICLE
AIRFARE
DEPARTING FROM:
PRIVATE VEHICLE
ESTIMATE OF COST:
NTE$425.00 LODGING
NTE $105 MEALS
$325.00 REGISTRATION
MILEAGE/FUEL
TOTAL FOR ALL: $ NTE: $855
TAXI
PARKING
AIRFARE
MISC/TOLLS
BUDGET LINE ITEM: 010-01-8220-1346
X GRANT REIMBURSABLE
YES NO
X REQUIRED CERTIFICATION
YES NO
TOTAL: $ NTE $855.00 PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
DEPARTIIIIEN
o
DATE
K:\Shared Goodies\Forms\Travel Request Form January 2010
I APPROVE THIS TRAVEL REQUEST
.7-frclwatt
MAYOR
Hirhi
DATE
TRAVEL , REQU»i;ST
CITY OF WATERLOO
FINANCE DEPT. STAFF ONLY
LINE ITEM USED5 ' p -Pt *?Qo /3c/61
6000 gjs
FY a0/9 BUDGETED
EXPENDED YTD
THIS REQUEST
LEFT AFTER THIS
REQUEST
¥9311
/CO`'
DATE
1= yra l f
Original - Clerk/Finance Co. - Deportment
NAME(S) AND POSITION(S):
Brad Manahl
NAME OF CLASS / MEETING:
Waste Water Treatment -Grade 3/4
DEPARTURE DATE:
03/21/19
PURPOSE OF TRAVEL/TRAINING:
Education
DATE:
04/09/19
DESTINA/TION:
DEPARTURE POINT Cedar Rapids
IF NOT WATERLOO:
RETURN DATE:
03/21/19
DATE(S) OF MEETING:
03/21/19
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL:
x COST $
YES NO
METHOD OF TRAVEL:
CITY VEHICLE
AIRFARE
x
DEPARTING FROM:
PRIVATE VEHICLE
ESTIMATE OF COST:
LODGING
MEALS
150.00 REGISTRATION
MILEAGE/FUEL
TOTAL FOR ALL: $ 150.00
TAXI
PARKING
AIRFARE
MISC/TOLLS
0
BUDGET LINE ITEM: 520-14-5200-1346
x GRANT REIMBURSABLE
YES NO
x
YES NO
REQUIRED CERTIFICATION
TOTAL: $ 150.00
PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
DEPARTMENT H
I APPROVE THIS TRAVEL REQUEST
i
Lktuytztd,
MAYOR
DATE DATE
K:\Shared Goodies\Forms\Travel Request Form January 2010
Julianna Henrich
From:
Sent:
To:
Subject:
Sent from my iPhone
Begin forwarded message:
Brad Manahl <manahlb@gmail.com>
Tuesday, February 19, 2019 2:21 PM
Julianna Henrich
Fwd: Transaction Receipt for Kirkwood Community College
From: Kirkwood Community College <contactce a kirkwood.cdu>
Date: February 15, 2019 at 3:19:53 PM CST
To: manahlb@,gmail.com
Subject: Transaction Receipt for Kirkwood Community College
Reply -To: contactcenkirkwood.edu
Transaction Receipt
Kirkwood Community College
6301 Kirkwood Blvd SW , Cedar Rapids , IA 52404
Transaction Date 02/15/2019
Transaction ID 404373
Registration ID
Course/Class
Number
Student Name
(ID)
Class Name/Date(s)/Time/Item
Amor
603881
ETRC-2017
/99572
Manahl, Brad
(254269)
Wastewater Treatment - Grade 2
Schedule Information:
Instructional
Method
Dates
Class Days
Times
Location
Instructor(s)
ClassRoom
2/20/2019-2/20/2019
Weekly -
Wed
9:00 AM - 3:00 PM
Cedar Rapids,
Continuing
Training Center
1102
Kirkwood
Education
, Room:
Russell Royce
Class Cost
$125.
603882
ETRC-2032
/99673
Manahl, Brad
(254269)
Wastewater Treatment - Grades 3/4
Schedule Information:
Instructional
Method
Dates
Class Days
Times
Location
Instruetor(s)
ClassRoom
3/21/2019-3/21/2019
Weekly -
8:00 AM - 4:00 PM
Cedar Rapids,
Chad McCleary
Class Cost
$150.
Transaction
Amount
$275.
Payment Method Credit card Visa No. xxxxxxxxxxxx8575 $275.
Tax ID # 42-0924685
Thu
Kirkwood Continuing
Education Training
Center , Room: 1102
Class Cost
$150.
Transaction
Amount
$275.
Payment Method Credit card Visa No. xxxxxxxxxxxx8575 $275.
Tax ID # 42-0924685
TRAVEL REQL EST
TI
CITY OF WATERLOO
FINANCE DEPT. STAFF ONLY
LINE ITEM USED 6170 l# 5 2CI C /31g,
FY .206BUDGETED 6000 `1v
EXPENDED YTD COS? 1
THIS REQUEST /
LEFT AFTER THIS
REQUEST
DATE
Original - Clerk/Finance
71 v2-
Co ' - be ' artment
NAME(S) AND POSITION(S):
Brad Manahl
NAME OF CLASS / MEETING:
Waste Water Treatment -Grade 2
DEPARTURE DATE:
02/20/19
PURPOSE OF TRAVEL/TRAINING:
Education
DATE:
04/09/19
DESTINA/TION:
DEPARTURE POINT Cedar Rapids
IF NOT WATERLOO:
RETURN DATE:
02/20/19
DATE(S) OF MEETING:
02/20/19
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL:
YES
x COST $
NO
METHOD OF TRAVEL:
CITY VEHICLE
AIRFARE
x
DEPARTING FROM:
PRIVATE VEHICLE
ESTIMATE OF COST:
LODGING
MEALS
125.00 REGISTRATION
MILEAGE/FUEL
TOTAL FOR ALL: $ 125.00
TAXI
PARKING
AIRFARE
MISC/TOLLS
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
DEPARTMENT H
BUDGET LINE ITEM: 520-14-5200-1346
x GRANT REIMBURSABLE
YES NO
REQUIRED CERTIFICATION
YES NO
TOTAL: $ 125.00
PER PERSON
I APPROVE THIS TRAVEL REQUEST
lc_ stteC---14
MAYOR
k II 5— cA
DATE 1� DATE
K:\Shared Goodies\Forms\Travel Request Form January 2010
Julianna Henrich
From:
Sent:
To:
Subject:
Sent from my iPhone
Begin forwarded message:
Brad Manahl <manahlb@gmail.com>
Tuesday, February 19, 2019 2:21 PM
Julianna Henrich
Fwd: Transaction Receipt for Kirkwood Community College
From: Kirkwood Community College <contactee(i),kirkwood.edu>
Date: February 15, 2019 at 3:19:53 PM CST
To: manahlb(dgmail.com
Subject: Transaction Receipt for Kirkwood Community College
Reply -To: contactce@kirkwood.edu
Transaction Receipt
Kirkwood Community College
6301 Kirkwood Blvd SW , Cedar Rapids , IA 52404
Transaction Date 02/15/2019
Transaction ID 404373
Registration ID
Course/Class
Number
Student Name
(ID)
Class Name/Date(s)/Time/Item
Amot
603881
ETRC-2017
/99572
Manahl, Brad
(254269)
Wastewater Treatment - Grade 2
Schedule Information:
Instructional
Method
Dates
Class Days
Times
Location
Instructor(s)
ClassRoom
2/20/2019-2/20/2019
Weekly -
Wed
9.00 AM - 3:00 PM
Cedar
Continuing
Traning
1102
Rapids, Kirkwood
Education.
Center , Room:
Russell Royce
Class Cost
$125.
603882
ETRC-2032
/99673
Manahl, Brad
(254269)
Wastewater Treatment - Grades 3/4
Schedule Information:
Instructional
Method
Dates
Class Days
Times
Location
Instructor(s)
ClassRoom
3/21/2019-3/21/2019
Weekly -
8:00 AM - 4:00 PM
Cedar Rapids,
Chad McCleary
Class Cost
$150.
Transaction
Amount
$275.
Payment Method Credit card Visa No. xxxxxxxxxxxx8575 $275.
Tax ID # 42-0924685
Thu
Kirkwood Continuing
Education Training
Center , Room: 1102
Class Cost
$150.
Transaction
Amount
$275.
Payment Method Credit card Visa No. xxxxxxxxxxxx8575 $275.
Tax ID # 42-0924685