The URL can be used to link to this page

Home My WebLink AboutAgenda Report - September 19, 2012 C-01AGENDA ITEM C40' CITY OF LODI COUNCIL COMMUNICATION TM AGENDA TITLE: Receive Register of Claims through August 30, 2012 in the Total Amount of $12,309,433.41. MEETING DATE: September 19, 2012 PREPARED BY: Financial Services Manager RECOMMENDED ACTION: Receive the attached Register of Claims for $12,309,433.41. BACKGROUND INFORMATION: Attached is the Register of Claims in the amount of $12,309,433.41 through 8/30/12. Also attached is Payroll in the amount of $2,435,679.44. FISCAL IMPACT: FUNDING AVAILABLE: RRP/rp Attachments Not applicable. As per attached report. -YZ . 'V J Ruby �? Paiste, Financial Services Manager APPROVED: X �'-- vKonradt Bartlam, City Manager - 1 - 08/23/12 Accounts Payable Page Council Report Date As of Fund Name Amount Thursday --------- ----- ------------------------------ ----------------- 08/16/12 00100 General Fund 1,836,502.47 00160 Electric Utility Fund 2,862,499.58 00164 Public Benefits Fund 62,659.06 00166 Solar Surcharge Fund 78,161.31 00170 Waste Water Utility Fund 53,688.50 00171 Waste Wtr Util-Capital Outlay 111,330.68 00180 Water Utility Fund 16,175.53 00181 Water Utility -Capital Outlay 211,516.79 00210 Library Fund 3,880.32 00234 Local Law Enforce Block Grant 182.10 00235 LPD -Public Safety Prog AB 1913 61.22 00260 Internal Service/Equip Maint 56,587.56 00270 Employee Benefits 449,250.11 00300 General Liabilities 9,027.39 00301 Other Insurance 145,915.00 00310 Worker's Comp Insurance 366,873.71 00320 Street Fund 460.60 00321 Gas Tax -2105,2106,2107 16,849.81 00325 Measure K Funds 156,960.04 00330 RTIF County/COG 746.77 00338 IMF -Regional Transportation 5,077.54 00340 Comm Dev Special Rev Fund 916.46 00347 Parks, Rec & Cultural Services 39,374.96 00444 HUD -Federal Sustainable Comm 3,602.80 00459 H U D 115,517.79 00502 L&L Dist Z1 -Almond Estates 395.10 00503 L&L Dist Z2 -Century Meadows I 249.45 00506 L&L Dist Z5 -Legacy I,II,Kirst 665.35 00507 L&L Dist Z6 -The Villas 561.32 00509 L&L Dist Z8 -Vintage Oaks 207.91 01211 Capital Outlay/General Fund 208,131.37 01212 Parks & Rec Capital 5,415.00 01241 LTF-Pedestrian/Bike 10,391.04 01250 Dial-a-Ride/Transportation 42,811.45 01251 Transit Capital 1,897,746.54 01252 Transit -Prop. 1B 944,285.00 01410 Expendable Trust 99,548.33 Sum --------------- 9,814,225.96 00184 Water PCE-TCE-Settlements 336.00 00190 Central Plume 5,044.35 Sum --------------- 5,380.35 Total --------------- Sum 9, 819, 606.31 - 1 - 08/23/12 - 1 - 09/05/12 Accounts Payable Page Council Report Date As of Fund Name Amount Thursday --------- ----- ------------------------------ ----------------- 08/30/12 00100 General Fund 376,839.50 00123 Info Systems Replacement Fund 1,213.23 00160 Electric Utility Fund 84,150.24 00161 Utility Outlay Reserve Fund 97,036.74 00164 Public Benefits Fund 2,954.00 00170 Waste Water Utility Fund 25,102.79 00171 Waste Wtr Util-Capital Outlay 307,251.92 00172 Waste Water Capital Reserve 92,655.83 00180 Water Utility Fund 18,737.22 00181 Water Utility -Capital Outlay 1,263,199.67 00210 Library Fund 8,132.65 00230 Asset Seizure Fund 50.00 00260 Internal Service/Equip Maint 45,281.18 00270 Employee Benefits 22,625.59 00300 General Liabilities 1,111.90 00310 Worker's Comp Insurance 9,708.33 00321 Gas Tax -2105,2106,2107 14,533.04 00325 Measure K Funds 8,460.23 00329 TDA - Streets 8,885.00 00340 Comm Dev Special Rev Fund 2,112.84 00347 Parks, Rec & Cultural Services 38,270.38 00459 H U D 5,787.52 00502 L&L Dist Z1 -Almond Estates 352.80 00503 L&L Dist Z2 -Century Meadows I 309.49 00505 L&L Dist Z4 -Almond North 67.14 00506 L&L Dist Z5 -Legacy I,II,Kirst 506.79 00507 L&L Dist Z6 -The Villas 437.48 00509 L&L Dist Z8 -Vintage Oaks 201.42 00515 L&L Dist Z13 30.97 00517 L&L Dist Z15 -Guild Ave Indust. 29.90 01212 Parks & Rec Capital 4,945.90 01241 LTF-Pedestrian/Bike 898.40 01250 Dial-a-Ride/Transportation 4,805.77 01251 Transit Capital 1,691.94 01410 Expendable Trust 34,085.21 Sum --------------- 2,482,463.01 00185 PCE/TCE Rate Abatement Fund 1,518.00 00190 Central Plume 4,760.14 00192 Busy Bee Plume 1,085.95 --------------- Sum 7,364.09 Total --------------- Sum 2,489,827.10 - 1 - 09/05/12 Pay Per Co Payroll Date ---------- ------- ----- Regular 08/05/12 00100 00160 00161 00164 00170 00180 00210 00235 00260 00321 00340 00345 00347 01250 Pay Period Total: Sum Council Report for Payroll Name ------------------------------ General Fund Electric Utility Fund Utility Outlay Reserve Fund Public Benefits Fund Waste Water Utility Fund Water Utility Fund Library Fund LPD -Public Safety Prog AB 1913 Internal Service/Equip Maint Gas Tax -2105,2106,2107 Comm Dev Special Rev Fund Community Center Parks, Rec & Cultural Services Dial-a-Ride/Transportation Page - 1 Date - 08/23/12 Gross Pay ------------------ 694,302.93 129,083.47 10,004.92 3,783.78 102,594.09 4,144.43 28,430.42 1,330.47 16,874.81 29,354.92 20,360.50 74.06 123,667.61 7,393.36 --------------- 1,171,399.77 Pay Per Co Payroll Date ---------- ------- ----- Regular 08/19/12 00100 00160 00161 00164 00170 00180 00210 00235 00260 00321 00340 00345 00347 01250 Council Report for Payroll Name ------------------------------ General Fund Electric Utility Fund Utility Outlay Reserve Fund Public Benefits Fund Waste Water Utility Fund Water Utility Fund Library Fund LPD -Public Safety Prog AB 1913 Internal Service/Equip Maint Gas Tax -2105,2106,2107 Comm Dev Special Rev Fund Community Center Parks, Rec & Cultural Services Dial-a-Ride/Transportation Pay Period Total: Sum Retiree 09/30/12 00100 General Fund Pay Period Total: Sum Page - 1 Date - 09/05/12 Gross Pay ------------------ 699,571.38 135,573.68 10,004.90 3,783.78 99,703.18 10,125.12 28,763.89 830.88 15,230.20 28,864.05 23,157.37 59.24 127,567.10 7,393.36 --------------- 1,190,628.13 73,651.54 -------------- 73,651.54 I certify to the best of my knowledge that each claim prepared from the register listed above is accurate in amount and the register is listed accurately by fund. 42r— Randi Johl, City Clerk � f` no z,- nne Mounce, Mayor k-. ?At� 'YZ Ruby P te, Financial Services Manager Accounting Clerk