The URL can be used to link to this page

Home My WebLink AboutAgenda Report - August 1, 2012 C-01AGENDA ITEM C &I CITY OF LODI COUNCIL COMMUNICATION TM AGENDA TITLE: Receive Register of Claims through July 12, 2012 in the Total Amount of $19,648,786.57. MEETING DATE: August 1,2012 PREPARED BY: Financial Services Manager RECOMMENDED ACTION: Receive the attached Register of Claims for $19,648,786.57 BACKGROUND INFORMATION: Attached is the Registerof Claims in the amount of $19,648,786.57 through 7/12/12. Also attached is Payroll in the amount of $2,343,763.82. FISCAL IMPACT: FUNDING AVAILABLE: RRP/rp Attachments Not applicable. As per attached report. RubA. Paiste, Financial Services Manager APPROVED: c A A , Konradt Bartlam, 1ty Manager - 1 06/26/12 Accounts Payable Page Council Report Date As of Fund Name Amount Thursday --------- ----- ------------------------------ ----------------- 06/14/12 00100 General Fund 1,117,212.48 00123 Info Systems Replacement Fund 130.00 00160 Electric Utility Fund 25,475.25 00164 Public Benefits Fund 104,232.61 00166 Solar Surcharge Fund 7,000.00 00170 Waste Water Utility Fund 61,629.37 00171 Waste Wtr Util-Capital Outlay 19,387.18 00180 Water Utility Fund 1,554,228.67 00181 Water Utility -Capital Outlay 122,222.31 00210 Library Fund 35,098.14 00234 Local Law Enforce Block Grant 2,623.45 00235 LPD -Public Safety Prog AB 1913 61.21 00260 Internal Service/Equip Maint 33,594.38 00270 Employee Benefits 454,476.51 00300 General Liabilities 843.41 00310 Worker's Comp Insurance 24,335.76 00321 Gas Tax -2105,2106,2107 9,091.65 00340 Comm Dev Special Rev Fund 1,629.34 00347 Parks, Rec & Cultural Services 32,900.75 00459 H U D 757.93 01211 Capital Outlay/General Fund 17,017.12 01212 Parks & Rec Capital 12,232.40 01250 Dial-a-Ride/Transportation 10,391.87 01251 Transit Capital 119,828.47 01410 Expendable Trust 5,991.42 Sum --------------- 3,772,391.68 00184 Water PCE-TCE-Settlements 84.00 00185 PCE/TCE Rate Abatement Fund 13,872.13 00190 Central Plume 30,326.27 Sum --------------- 44,282.40 Total --------------- Sum 3, 816, 674.08 - 1 06/26/12 - 1 07/23/12 Accounts Payable Page Council Report Date As of Fund Name Amount Thursday --------- ----- ------------------------------ ----------------- 07/12/12 00100 General Fund 2,332,685.04 00120 Vehicle Replacement Fund 137,483.07 00160 Electric Utility Fund 2,222,408.64 00161 Utility Outlay Reserve Fund 6,545,270.37 00164 Public Benefits Fund 16,202.61 00166 Solar Surcharge Fund 20,437.20 00170 Waste Water Utility Fund 47,256.82 00171 Waste Wtr Util-Capital Outlay 171,919.03 00172 Waste Water Capital Reserve 2,250.00 00180 Water Utility Fund 342,565.92 00181 Water Utility -Capital Outlay 2,728,600.61 00210 Library Fund 23,279.63 00230 Asset Seizure Fund 150.00 00234 Local Law Enforce Block Grant 181.41 00235 LPD -Public Safety Prog AB 1913 122.11 00260 Internal Service/Equip Maint 66,996.66 00270 Employee Benefits 497,216.89 00300 General Liabilities 78.00 00310 Worker's Comp Insurance 72,816.25 00320 Street Fund 1,655.00 00321 Gas Tax -2105,2106,2107 20,476.18 00325 Measure K Funds 24,859.30 00340 Comm Dev Special Rev Fund 1,009.33 00347 Parks, Rec & Cultural Services 51,181.90 00444 HUD -Federal Sustainable Comm 2,130.45 00447 First Time Homebuyers-FTHB 51.65 00459 H U D 13,670.06 00502 L&L Dist Z1 -Almond Estates 395.03 00503 L&L Dist Z2 -Century Meadows I 249.50 00506 L&L Dist Z5 -Legacy I,II,Kirst 665.32 00507 L&L Dist Z6 -The Villas 561.37 00509 L&L Dist Z8 -Vintage Oaks 207.91 01211 Capital Outlay/General Fund 109,185.34 01212 Parks & Rec Capital 68,572.90 01250 Dial-a-Ride/Transportation 238,455.16 01251 Transit Capital 2,279.59 01410 Expendable Trust 31,928.99 Sum --------------- 15,795,455.24 00184 Water PCE-TCE-Settlements 42.00 00190 Central Plume 10,943.59 00192 Busy Bee Plume 25,671.66 --------------- Sum 36, 657.25 Total --------------- Sum 15,832,112.49 - 1 07/23/12 Pay Per Co Payroll Date ---------- ------- ----- Regular 06/10/12 00100 00160 00161 00164 00170 00180 00210 00235 00260 00321 00340 00346 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 Recreation Fund Parks, Rec & Cultural Services Dial-a-Ride/Transportation Page - 1 Date - 06/26/12 Gross Pay ------------------ 670,331.14 139,477.54 6, 683.26 3,783.78 97,806.68 3,510.15 28,321.82 1,422.79 16,863.30 27,456.91 20,212.12 374.00 108,226.75 7,393.36 --------------- 1, 131, 8 63. 60 Pay Per Co Payroll Date ---------- ------- ----- Regular 07/08/12 00100 00160 00161 00164 00170 00180 00210 00235 00260 00321 00340 00346 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 Recreation Fund Parks, Rec & Cultural Services Dial-a-Ride/Transportation Page - 1 Date - 07/18/12 Gross Pay ------------------ 668,622.28 132,248.05 8,754.29 3,783.77 102,159.70 3, 677.20 27,825.05 915.03 16,926.76 29,474.59 22,018.81 204.00 116,563.32 7,393.36 --------------- 1,140,566.21 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. RandNoh , � OV dbAnyje-MV� ounce, Mayor U Ruby Pqyte, Financial Services Manager