HomeMy WebLinkAboutAgenda Report - July 20, 2022 C-01CITY OF
L
sir 1 t
CALIFORNIA
AGENDA ITEM C-01
COUNCIL COMMUNICATION
AGENDA TITLE: Receive Register of Claims for May 27, 2022 through June 30, 2022 in the Total Amount
of $17,716,040.66
MEETING DATE: July 20, 2022
PREPARED BY: Internal Services Director
RECOMMENDED ACTION: Receive the attached Register of Claims for $17,716,040.66.
BACKGROUND INFORMATION: Attached is the Register of Claims in the amount of $17,716,040.66 for May
27, 2022 through June 30, 2022. Also attached is Payroll in the amount of
$1,797,636.02 through May 29, 2022, $1,840,858.31 through June 12,
2022 and $1,866,694.99 through June 26, 2022. This report covers five
weeks of claims and three pay periods.
FISCAL IMPACT:
FUNDING AVAILABLE
Not applicable.
As per attached report.
Andrew Keys
Deputy City Manager/Internal Services Director
APPROVED: , s< tier(Jul5, 202214:56 PDT)
Stephen Schwabauer, City Manager
AP Council Report Summary
5/z7/2022-6/30/2022
Fund
100
General Fund
103
Measure L
104
American Rescue Plan
120
Library Fund
140
Expendable Trust
200
Parks Rec & Cultural Services
205
State Grants
213
LPD -Public Safety Prog AB 1913
214
LPD -OTS Grants
270
Comm Dev Special Rev Fund
301
Gas Tax -2105 2106 2107
303
Measure K Funds
305
TDA - Streets
331
LTF-Pedestrian/Bike
350
H U D
355
GRANTS COMM. IMPR
431
Capital Outlay/General Fund
432
Parks & Rec Capital
437
IMF Parks & Rec Facilities
500
Electric Utility Fund
501
Utility Outlay Reserve Fund
504
Public Benefits Fund
505
IMF EU Substation & Trans Syst
508
Environmental Compliance
530
Waste Water Utility Fund
531
Waste Wtr Util-Capital Outlay
560
Water Utility Fund
561
Water Utility -Capital Outlay
565
PCE/TCE Rate Abatement Fund
590
Central Plume
591
Southern Plume
593
Northern Plume
594
South Central Western Plume
600
Dial-a-Ride/Transportation
601
Transit Capital
Amount
$4,745,204.91
$40,056.85
$100,000.00
$90,129.21
$499,773.76
$84,304.97
$421,077.88
$21,635.01
$126.90
$73,580.30
$136,467.90
$2,539.25
$4,009.93
$8,856.50
$7,532.26
$60,327.50
$53,325.31
$220,432.93
$8,784.16
$5,817,499.86
$645,539.02
$269,411.38
$168,778.47
$147,243.00
$276,991.28
$379,577.73
$1,832,333.70
$184,023.99
$11,968.04
$7,491.65
$1,316.60
$460.81
$789.96
$246,670.34
$132.75
City of Lodi Live v2020.3 7/5/2022 8:23:51 AM
Fund
Fund Title
Amount
605
Prop.1 B State of Good Repair
$1,393.92
641
Equipment replacement
$9,647.79
642
IT replacement
$27,320.27
643
Vehicle replacement PD
$33,756.36
650
Internal Service/Equip Maint
$159,244.66
655
Employee Benefits
$866,539.05
660
General Liabilities
$4,307.88
665
Worker's Comp Insurance
$40,128.90
801
L&L Dist Z1 -Almond Estates
$5,307.72
Total
$17,716,040.66
City of Lodi Live v2020.3 7/5/2022 8:23:51 AM
Council Report: Payroll
Pay Period: 5/29/2022
City of Lodi Live v2020.3 6/20/2022 7:28:52 AM
xescription
..
100
General Fund
$872,818.46
103
Measure L
$166,202.91
120
Library Fund
$20,570.45
200
Parks Rec & Cultural Services
$137,631.07
214
LPD -OTS Grants
$2,251.37
219
LPD -ABC Grant
$1,253.82
270
Comm Dev Special Rev Fund
$41,664.15
301
Gas Tax -2105 2106 2107
$41,964.93
500
Electric Utility Fund
$274,588.73
501
Utility Outlay Reserve Fund
$28,227.29
505
IMF EU Substation & Trans Syst
$1,156.92
530
Waste Water Utility Fund
$150,778.07
560
Water Utility Fund
$26,027.45
600
Dial-a-Ride/Transportation
$8,905.72
650
Internal Service/Equip Maint
$23,594.68
City of Lodi Live v2020.3 6/20/2022 7:28:52 AM
100
103
120
200
206
214
270
301
500
501
530
560
600
650
655
Council Report: Payrol
Pay Period: 6/12/2022
General Fund
Measure L
Library Fund
Parks Rec & Cultural Services
Misc Grants
LPD -OTS Grants
Comm Dev Special Rev Fund
Gas Tax -2105 2106 2107
Electric Utility Fund
Utility Outlay Reserve Fund
Waste Water Utility Fund
Water Utility Fund
Dial-a-Ride/Transportation
Internal Service/Equip Maint
Employee Benefits
$862,996.29
$167,004.56
$20,413.23
$149,816.72
$290.52
$6,985.76
$41,852.07
$40,601.20
$272,079.67
$39,971.12
$168,024.13
$31,121.51
$8,905.72
$23,369.26
$7,426.55
City of Lodi Live v2020.3 6/20/2022 7:30:30 AM
Council Report: Payroll
Pay Period: 6/26/2022
Fund
-,===ME
'Description
100
General Fund
$903,025.24
103
Measure L
$156,488.60
120
Library Fund
$21,331.01
200
Parks Rec & Cultural Services
$149,968.28
206
Misc Grants
$864.84
219
LPD -ABC Grant
$992.64
270
Comm Dev Special Rev Fund
$41,462.19
301
Gas Tax -2105 2106 2107
$62,175.47
500
Electric Utility Fund
$274,568.86
501
Utility Outlay Reserve Fund
$42,817.64
530
Waste Water Utility Fund
$155,743.69
560
Water Utility Fund
$29,240.82
600
Dial-a-Ride/Transportation
$8,905.72
650
internal Service/Equip Maint
$19,109.99
report Tc
City of Lodi Live v2020.3 7/5/2022 8:29:11 AM