Loading...
HomeMy WebLinkAboutAgenda Report - July 18, 2007 E-01AGENDA ITEM is% CITY OF LODI COUNCIL COMMUNICATION Im AGENDA TITLE: Receive Register of Claims Dated June 7, June 14, June 21, and June 28,2007 in the Total Amount of $9,003,184.65. MEETING DATE: July 18,2007 PREPARED BY: Financial Services Manager RECOMMENDED ACTION: Receive the attached Register of Claims for $9,003,184,65. BACKGROUND INFORMATION: Attached is the Register of Claims in the amount of $9,003,184.65 dated 6/07/07, 6/14/07, 6/21/07 and 6/28/07. Also attached is Payroll in the amount of $2,385,685.89, FISCAL IMPACT: n/a FUNDING AVAILABLE: RRPkp Attachments As per attached report. `i2. �°�.c ,c Rubyg. Paiste, Financial Services Manager APPROVED: n BWFKr6, City Manager Accounts Payable Council Report As of Fund Name Thursday --------- ----------------------------------- -- 06/07/07 00100 General Fund 00160 Electric Utility Fund 00164 Public Benefits Fund 00170 Waste Water Utility Fund 00171 Waste Wtr Util-Capital Outlay 00172 Waste Water Capital Reserve 00180 Water Utility Fund 00181 Water Utility -Capital Outlay 00182 IMF Water Facilities 00210 Library Fund 00235 LPD -Public Safety Prog AB 1913 00260 Internal Service/Equip Maint 00270 Employee Benefits 00300 General Liabilities 00321 Gas Tax 00329 TDA - Streets 00340 Comm Dev Special Rev Fund 01212 Parks & Rec Capital 01218 IMF General Facilities -Adm 01250 Dial-a-Ride/Transportation Sum Total for Week Sum Page Date Amount ------------ 336,497.68 8,518.27 433.76 874.12 55,727.10 1,694,413.96 425.26 766.10 247,388.62 5,099.69 6,122.93 15,815.80 394,389.26 25,018.83 4,596.33 5,533.80 23,939.94 8,065.27 26,208.41 551.10 2,860,386.23 --------------- 2,860,386.23 - 1 06/19/07 Total for Week Sum 1,196,716.37 Accounts Payable Page - 1 Council Report Date - 06/19/07 As of Fund Name Amount Thursday --------- ----- ------------------------------ -------------------- 06/14/07 00100 General Fund 677,422.56 00123 Info Systems Replacement Fund 86.24 00160 Electric Utility Fund 33,244.38 00161 Utility Outlay Reserve Fund 769.60 00164 Public Benefits Fund 1,672.50 00170 Waste Water Utility Fund 3,078.94 00172 Waste Water Capital Reserve 72,780.90 00173 IMF Wastewater Facilities 524.75 00180 Water Utility Fund 1,881.12 00182 IMF Water Facilities 351.27 00210 Library Fund 3,411.46 00235 LPD -Public Safety Prog AB 1913 1,185.25 00238 LPD -Federal Grants 59,630.76 00260 Internal Service/Equip Maint 13,207.58 00270 Employee Benefits 27,507.92 00300 General Liabilities 280.58 00310 Worker's Comp Insurance 835.16 00321 Gas Tax 7,362.29 00329 TDA - Streets 7,498.10 00340 Comm Dev Special Rev Fund 2,364.48 00501 Lcr Assessment 95-1 333.12 01211 Capital Outlay/General Fund 3,510.71 01218 IMF General Facilities -Adm 7,733.77 01250 Dial-a-Ride/Transportation 182,409.00 01410 Expendable Trust 87,549.93 Sum --------------- 1,196,632.37 00184 Water PCE-TCE-Settlements 84.00 Sum --------------- 84.00 --------------- Total for Week Sum 1,196,716.37 --------------- Sum 234,969.30 --------------- Total for Week Sum 1,377,148.34 Accounts Payable Page - 1 Council Report Date - 07/03/07 As of Fund Name Amount --------- ----------------------------------- Thursday -------------------- 06/21/07 00100 General Fund 474,010.47 00123 Info Systems Replacement Fund 3,730.96 00160 Electric Utility Fund 8,355.89 00164 Public Benefits Fund 2,167.45 00170 Waste Water Utility Fund 42,404.72 00171 Waste Wtr Util-Capital Outlay 261,506.52 00172 Waste Water Capital Reserve 301.78 00180 Water Utility Fund 5,175.91 00181 Water Utility -Capital Outlay 5,730.97 00210 Library Fund 13,375.75 00231 Auto Theft Prosecution Fund 6,440.00 00234 Local Law Enforce Block Grant 614.15 00260 Internal Service/Equip Maint 12,192.06 00270 Employee Benefits 6,433.91 00300 General Liabilities 33,641.60 00310 Worker's Comp Insurance 39,454.82 00321 Gas Tax 14,326.42 00325 Measure K Funds 24,497.28 00329 TDA - Streets 1,153.60 00340 Comm Dev Special Rev Fund 10,071.65 00457 Hud -2001/02 140.61 01250 Dial-a-Ride/Transportation 159,490.90 01410 Expendable Trust 16,961.62 Sum --------------- 1,142,179.04 00184 Water PCE-TCE-Settlements 234,895.30 00190 Central Plume 74.00 --------------- Sum 234,969.30 --------------- Total for Week Sum 1,377,148.34 Sum 64,998.15 --------------- Total for Week Sum 3,568,933.71 Accounts Payable Page - 1 Council Report Date - 07/03/07 As of Fund Name Amount --------- ----------------------------------- Thursday -------------------- 06/28/07 00100 General Fund 732,089.12 00123 Info Systems Replacement Fund 1,354.43 00160 Electric Utility Fund 2,659,030.50 00164 Public Benefits Fund 23,623.97 00170 Waste Water Utility Fund 11,481.74 00180 Water Utility Fund 6,239.98 00181 Water Utility -Capital Outlay 592.59 00182 IMF Water Facilities 57.12 00210 Library Fund 12,894.01 00234 Local Law Enforce Block Grant 179.38 00235 LPD -Public Safety AB 1913 2,907.82 00260 Internal Service/Equip Maint 13,988.47 00270 Employee Benefits 12,191.03 00300 General Liabilities 2,302.40 00310 Worker's Comp Insurance 150.00 00321 Gas Tax - 2105,2106,2107 2,782.70 00335 CALTRANS Imp. Program 663.00 00340 Comm Dev Special Rev Fund 924.41 01211 Capital Outlay/General Fund 1,945.93 01212 Parks & Rec Capital 817.76 01250 Dial-a-Ride/Transportation 5,951.40 01410 Expendable Trust 11,767.80 Sum --------------- 3,503,935.56 00184 Water PCE-TCE Settlements 23,803.32 00190 Central Plume 41,194.83 Sum 64,998.15 --------------- Total for Week Sum 3,568,933.71 Council Report for Payroll Page - 1 Date - 06/19/07 Pay Per Co Name Gross Payroll Date Pay ---------- ------- ------------------------------------------------------ Regular 06/03/07 00100 General Fund 00160 Electric Utility Fund 00164 Public Benefits Fund 00170 Waste Water Utility Fund 00180 Water Utility Fund 00210 Library Fund 00235 LPD -Public Safety Prog AB 1913 00260 Internal Service/Equip Maint 00321 Gas Tax 00340 Comm Dev Special Rev Fund 01250 Dial-a-Ride/Transportation 792,226.80 129,814.05 5,162.00 70,619.71 10,441.61 33,183.65 3,663.57 18,397.42 54,310.90 37,483.83 3,114.56 ------------- Pay Period Total: Sum 1, 158, 418.10 Council Report for Payroll Page - 1 Date - 07/03/07 Pay Per Co Name Gross Payroll Date ---------- ------- ----- ------------------------------ ------------------- Pay Regular 06/17/07 00100 General Fund 818,825.69 00160 Electric Utility Fund 133,533.67 00164 Public Benefits Fund 5,162.00 00170 Waste Water Utility Fund 69,842.00 00180 Water Utility Fund 9,354.64 00210 Library Fund 33,408.33 00235 LPD -Public Safety AB 1913 2,391.83 00260 Internal Service/Equip Maint 18,806.52 00321 Gas Tax - 2105,2106,2107 54,732.41 00340 Comm Dev Special Rev Fund 37,546.80 01250 Dial-a-Ride/Transportation 3,114.56 --------------- Pay Period Total: Sum 1, 186, 718.45 Retiree 07/31/07 00100 General Fund 40,549.34 --------------- Pay Period Total: Sum 40,549.34 I certify to the best of rr y knowledge that each claim prepared from the register listed above is accurate in amount and the regigter is listed accura eiy by fund. Randi7o , City C rk Bob lohnse. ayor i�►-�� Ruby Pai9Ce, Financial Services Manager ccountin Clerk