The URL can be used to link to this page

Home My WebLink About159748 05/27/2008 CITY OF CARMEL, INDIANA VENDOR: 358807 Page 1 of 1 ONE CIVIC SQUARE INDIANA PUBLIC EMPLOYERS PLAN IN &ECK AMOUNT: $12,217.00 o CARMEL, INDIANA 46032 302 SOUTH REED ROAD PO Box 1247 CHECK NUMBER: 159748 KOKOMO IN 46903 -1247 CHECK DATE: 5/27/2008 DEPARTMENT ACCOU P O NU I NVOICE NUM AMOUNT DES 601 '5023990 13745 4,944.00 AUDIT 601 5023990 13813 7,273.00 AUDIT I, i f� Customer: Carmel, City of t i? Policy #0008 -0104 01/01/2008- 01/01/2009 Indiana Public Employers' Plan 13813 01/01/2008 Policy change Amend current term payrolls 7,273.00 7,273.00 Thank You Indiana Public Employers' Plan, Inc. (765)457 -9161 302 South Reed Road P.O. Box 1247 Kokomo, IN 46903 -1247 04/28/2008 Customer: Carmel, City of oil e Policy #0008 -0103 01/01/2007- 01/01/2008 Indiana Public Employers' Plan 13745 01/01/2007 Premium audit Premium audit for 07/08 year 6,592.00 IPEP Credit Premium audit for 07/08 year 1,648.00 4,944.00 Thank You Indiana Public Employers' Plan, Inc. (765)457 -916 e 302 South Reed Road P.O. Box 1247 Kokomo, IN 46903 -1247 04/17/2008 City of Carmel Water Utility 2008 Insurance Costs "Utilities" Auto Invoice Water Share of Jointly owned vehicles 51,629.77 49.85% 1,144.06 Sewer Share of Jointly owned vehicles 51,939.23 50.15% 1,150.94 103,569.00 2,295.00 Audit Invoice Water share of Utility vehicles 549,999.12 41.49% 353.49 Sewer share of Utility vehicles 775,634.85 58.51% 498.51 1,325,633.97 Auto 18,160.06 General Liability 76,291.00 Other: BPP 545.00 IM 702.00 95,698.06 Vehicle Budget of Bud Payment Audit 01.6560.03 7,500 54.17% 9,837.30 176.59 01.6560.05 4,000 28.89% 5,246.44 94.18 01.6560.07 1,800 13.00% 2,360.81 42.38 01.6560.08 545 3.94% 715.51 12.84 Total 13,845 100.00% 18,160.06 18,160.06 326.00 Gen. Liab. Budget of Bud Payment 01.6570.03 28,000 37.09% 28,296.33 01.6570.04 3,500 4.64% 3,539.90 01.6570.06 28,000 37.09% 28,296.33 01.6570.07 10,000 13.24% 10,100.93 01.6570.08 6,000 7.94% 6,057.51 Total 75,500 100.00% 76,291.00 76,291.00 Workman's Comp Budget of Bud Payment Audit 01.6580.03 15,500 45.48% 14,738 9,655.40 q -A 01.6580.06 15,500 45.48% 14,738 9,655.40 01.6580.07 2,405 7.06% 2,288 1,498.84 01.6580.08 675 1.98% 641 420.36 Total 34,080 100.00% 32,405 21,230 32,405 21,230.00 Other Budget of Bud Payment 12,217.00 01.6590.03 20,000 61.80% 770.65 12,217.00 01.6590.04 860 2.66% 33.17 01.6590.05 1,000 3.09% 38.53 01.6590.06 1,000 3.09% 38.53 01.6590.07 2,500 7.73% 96.39 01.6590.08 7,000 21.63% 269.73 Total 32,360 100.00% 1,247.00 1,247.00 Insurance Allocation.xls, Water 2008 5/20/2008, 8:45 AM A Page 1 of 1 Lamb, Barbara A From: Lamb, Barbara A Sent: Wednesday, April 30, 2008 6:15 PM To: Duffy, John M Cc: Lamb, Barbara A Subject: Worker's Compensation John, I hope you have some money left in your worker's comp account. I am going to send you two invoices, one for the 2007 audit ($4,944) and one for adjustments to the 2008 payroll estimate ($7,273), which I made after the 2007 audit. The total due is $12,217. In each case, the total due for the water and sewer utilities is actually less than the invoice; your totals have been partially offset by credits from other City departments. I have adjusted the actual water and sewer amounts proportionately to come up with the amount of the invoice. If you want to split it another way, that's fine with me. Actual amounts are in parentheses. I will include documentation with the invoices. I imagine there will be some questions, so give me a call at your convenience. 2007 Audit Water +9,336 +15,197) Sewer -4,392 7,149) Total Due +4,944 +8,048) 2008 Pa Ad Water +11,894 +14,055) Sewer -4,621 5,461) Total Due +7,273 +8,594) Barbara A. Lamb Director of Human Resources City of Carmel One Civic Square Carmel, IN 46032 Phone: 317 571 -2471 Fax: 317- 571 -2409 Email: blamb @carmel.in.gov 5/1/2008 2007 AUDIT Difference Rate Net Premium Water 630,742 3.13 10,816 Water Bldg (Reclass) 222,725 3.59 4,381 15,197 9,335 Sewer 460,229 3.65 -9,203 Sewer Bldg (Reclass) 104,459 3.59 2,055 -7,149 -4,392 8,048 8,048 4,944 Indiana Public Employers' Plan, Inc. Audit Comparison Member: City of Carmel Period: 1 -1- 2007/2008 Code Classification Estimate Actual Difference Percent 5506 Street 1,980,504.00 1,926,732.31 53,771.69 -2.72% 7520 Waterworks 1,799,225.00 2,429,966.81 630,741.81 35.06% 7580 Sewer 1,574,913.00 1,114,684.13 460,228.87 29.22% 7699 Firemen Medical 10,263,943.00 10,182,967.00 80,976.00 -0.79% 7725 Police Medical 6,196,458.00 6,283,573.10 87,115.10 1.41% 8380 Auto Service 97,329.00 95,113.45 2,215.55 -2.28% 8601 Surveyor 164,210.39 164,210.39 added 8810 Clerical Office Employees 7,111,513.00 5,685,875.74 1,425,637.26 20.05% 8810 Clerical Office Employees 542,345.00 542,345.00 100.00% 8820 Attorney 248,565.00 275,148.40 26,583.40 10.69% 8869 Child Day Care Center 1,482,633.00 1,334,098.79 148,534.21 10.02% 9015 Building NOC 99,000.00 473,954.35 374,954.35 378.74% 9102 jPark s NOC 1,669,845.00 1,551;086.80 118,758.20 -7.11% 9410 IMunicipal Employees NOC 1,053,147.00 1,261,507.19 208,360.19 19.78% TOTALS 34,119,420.00 32,778,918.46 1,340,501.54 -3.931% Indiana Public Employers' Plan, Inc. Audit Worksheet Member: City of Carmel Period: 1 -1- 2007/2008 Employee /Department Year 2007 Overtime Total Code Street Department 1,981,895.19 165,488.65 1,926,732.31 5506 Water Operating Fund 2,511,844.93 245,634.36 2,429,966.81 7520 Sewer Operating Fund 1,130,397.94 47,141.43 1,114,684.13 7580 Fire Department 10,480,637.40 893,011.20 10,182,967.00 7699 Police Department 6,462,950.98 538,133.63 6,283,573.10 7725 Police Department Mechanic 95,505.81 1,177.07 95,113.45 8380 City Engineer's Office Asst City Engineer 68,075.08 68,075.08 8601 I City Engineer's Office Dir City Engineer 96,135.31 96,135.31 8601 164,210.39 Board of Public Works 5,737.00 433.50 5,592.50 8810 City Court 397,002.44 2,382.52 396,208.27 8810 City Engineer's Office Clerical 79,429.22 79,429.22 8810 Clerk Treasurer's Office 372,038.76 2,681.62 371,144.89 8810 Common Council 105,963.31 105,963.31 8810 Communications Center 1,416,057.31 197,659.43 1,350,170.83 8810 Dept of Community Service Clerical 335,590.68 1,342.86 335,143.06 8810 Fire Department Clerical 225,190.42 225,190.42 8810 General Administration Census 268,534.14 268,534.14 8810 Generaa Administration Clerical 27,514.96 27,514.96 8810 Human Resources 170,098.31 204.52 170,030.14 8810 Information S stems 543,335.05 1,578.90 542,808.75 8810 Mayor's Office 501,559.65 4,112.21 500,188.91 8810 Parks Department Clerical 158,539.40 158,539.40 8810 Planning Commission 3,750.00 3,750.00 8810 Police Department Clerical 537,307.70 42,769.11 523,051.33 8810 Revenue Facilities Clerical 51,182.76 38.42 51,169.95 8810 School Enrichment Program Clerical 37,162.82 8.40 37,160.02 8810 Street Department Clerical 49,872.80 1,754.41 49,288.00 8810 Water Operating Fund Clerical 497,563.52 37,697.64 484,997.64 8810 5,685,875.74 Department of Law 275,298.32 449.77 275,148.40 8820 School Enrichment Program 1,337,568.89 10,410.31 1,334,098.79 8869 General Administration Facilities 72,441.05 2,811.05 71,504.03 9015 Revenue Facilities Custodial /Maintenance 75,719.58 1,361.51 75,265.74 9015 Sewer Operating Fund General Labor Jan /Maint 105,181.21 2,165.58 104,459.35 9 015 Water Operating Fund Jan /Maint 228,150.95 16,277.19 222,725.22 9015 473,954.35 Parks Department 700,374.10 16,647.69 694,824.87 9102 Revenue Facilities 866,707.50 31,336.72 856,261.93 9102 1,551,086.80 City Engineer's Office Assistant Director 58,233.52 58,233.52 9410 City Engineer's Office Inspectors 193,815.32 193,815.32 9410 City Engineer's Office Plan Review Coord 51,812.09 51,812.09 9410 City Engineer's Office Public Works Coord 36,339.14 36,339.14 9410 City Engineer's Office Stormwater Admin 53,153.55 53,153.55 9410 Department of Community Service 865,762.34 23,576.70 857,903.44 9410 Revenue Facilities Inspectors 1,810.00 1,810.00 9410 School Enrichment Pro Ins Stormwater Admin 8,440.13 8,440.13 9410 1,261,507.19 Net 2008 Rate Premium Dept Total Initial Est Difference Department Classification Payroll Administration Building Maintenance 106,000 2.84 1,580 Office Employees 848,000 0.21 935 2,515 2,584 -69 Board of Works Office Employees 12,800 0.21 14 14 68 -53 Clerk- Treasurer Office Employees 394,320 0.21 435 435 440 -5 Communications Office Employees 1,441,600 0.21 1,589 1,589 1,503 87 Community Services Municipal 911,600 2.13 10,194 Office Employees 360,400 0.21 397 10,591 7,389 3,203 Council Office Employees 113,420 0.21 125 125 127 -2 Court Office Employees 424,000 0.21 467 Police Officers 47,700 1.43 358 826 813 12 Engineer Municipal 418,700 2.13 4,682 Surveyor 238,500 0.50 626 Office Employees 84,800 0.21 93 5,402 6,458 -1,057 Fire Firefighters 10,880,900 2.59 147,953 Office Employees 239,560 0.21 264 148,217 150,449 -2,232 Law Law Office 296,800 0.14 218 218 196 22 Mayor Office Employees 534,240 0.21 589 589 486 103 Parks Parks 1,696,000 2.40 21,370 Child Day Care 1,420,400 0.66 4,922 Parks Building 84,800 2.84 1,264 Office Employees 318,000 0.21 351 27,906 28,781 -874 Police Police Officers 6,667,400 1.43 50,056 Auto Service Repair 103,880 2.39 1,303 Office Employees 567,100 0.21 625 51,984 51,864 121 Street Street Road 2,098,800 5.66 62,366 Office Employees 146,280 0.21 161 62,527 63,364 -837 Sewer Sewage Disposal 1,187,200 2.67 16,642 Sewer Building 116,600 2.67 1,634 Office Employees 498,200 0.21 549 18,825 24,286 -5,461 -4,621 Water Waterworks 2,581,100 3.14 42,550 Water Building 238,500 2.67 3,343 Office Employees 514,100 0.21 567 46,459 32,405 14,055 11,895 City Volunteers 260 260 0 260 TOTAL 35,591,700 378,484 378,484 371,212 7,273 7,273 Prescribed by State Board of Accounts City Form No. 201 (Rev 1995) r, ACCOUNTS PAYABLE VOUCHER CITY OF CARMEL An invoice or bill to be properly itemized must show, kind of service, where performed, dates of service rendered, by whom, rates per day, number of units, price per unit, etc. Payee 358807 INDIANA PUBLI EMPLOYERS PLAN INC Purchase Order No. 302 SOUTH REED ROAD PO BOX 1247 Terms KOKOMO, IN 46903 -1247 Due Date 5/21/2008 Invoice Invoice Description Date Number (or note attached invoice(s) or bill(s)) Amount 5/21/2008 052308 $12,217.00 hereby certify that the attached invoice(s), or bill(s) is (are) true and .orrect and I have audited same in accordance with IC 5- 11- 10 -1.6 Date Officer -VOUCHER 081910 WARRANT ALLOWED 358807 IN SUM OF INDIANA PUBLI EMPLOYERS PLAN IN 302 SOUTH REED ROAD PO BOX 1241 KO'.KOMO, IN 46903 -1247 Carmel Water Utility ON ACCOUNT OF APPROPRIATION FOR Board members PO INV ACCT AMOUNT Audit Trail Code 052308 01- 6580 -03 \64210 052308 01- 6580 -06 $9,65.5.,40 052308 01- 6580 -07 $1,49 8.84 052308 01- 6500 -08 $420,1 6 /D� Voucher Total $12,217.00 Cost distribution ledger classification if „claim paid under vehicle highway fund