Loading...
HomeMy WebLinkAboutA-86 2001 BudgetORDINANCE # A86 AN ORDINANCE BUDGETING EXPEDITURES FOR THE OPERATING AND DEPRECIATING FUNDS FOR THE CARMEL WATER UTILITY WHEREAS, the Common Council of the City of Carmel, Indiana pursuant to I.C. 8-1.5-3-3, has ordained that the Carmel Board of Public Works and Safety administer the City of Carmel Water Utility; and WHEREAS, Ordinance D-362 charges the Carmel Board of Public Works and Safety with the administration of the Water Utility; and WHEREAS, the Board of Public Works and Safety is required by I.C. 8-1.5-3-3 (a) (6) with submitting a budget to the City Council; and WHEREAS, the Common Council of the City of Carmel is charged with the duty of reviewing and approving that budget; and W'HEREAS, the Common council for the City of Carmel is desirous of establishing a budget for the Utility fiar the year ending December 31,2001; NOW, THERFORE, BE IT ORDA1NIED by the Common Council of the City of Carmel, Indiana, that payment of expenses for the City of Carmel Water Utility Operating and Depreciation Funds for the fiscal year ending December 31, 2001, shall be paid from the following sums of money which are hereby budgeted and ordered set apart for that purpose: "Transfers from one control account to another and/or additional appropriations may be made by resolution of this Council at any regular public meeting" PASSED AND ADOPTED by the Common Council of the City of Carmel, Indiana this ~_Y'~ day of A,/Z~Yt,~Z:~t'- .2000. "'~Pres~mmo~nouncil ATTEST: Diana L. Co~r~urer . . -/,a Presented to the Mayor of the C~ty ofCarmel, lndmna th~soe. O~y of ~o,-,-d.c'.2000 at g.,..o/',,,, o'~ock. ATTEST: Diana L. Cordray, Clerk~asurer CITY OF CARMEL UTILITIES WATER UTILITY 2001 BUDGET 2001 Water Budget Operating Expenses 2217 Bond Principal Payable (Not in Total} 4030 Depreciation Expenses (Not in Total) 4080 - 4090 Taxes 4273 4280 6010 6040 6150 6180 6200 6310-6330 6350-6360 636x.08 6410 6500 6560-6590 6600 6670 6700 6750 Interest on Long Term Debt (Not in Total) Bond Issuance Write Off Expense (Not in Total) Salaries & Wages - Employees Employee Pensions & Benefits Purchased Power Chemicals Materials & Supplies Contractual Services - Professional Associates Contractual Services - Testing & Other Common Costs Rental of Building/Real Property Transportation Expenses Insurance (Non-Employee) Advertising Expense Regulatory Commission Expense - Other Bad Debt Expense (Not in Total) Miscellaneous Expenses GRAND TOTAL OPERATING EXPENSES 2240 & 4275 Lease Purchase Payments 3000 - 3480 2001 Water Depreciation GRAND TOTAL DEPRECIATION SPENDING GRAND TOTAL OPERATION & DEPRECIATION 255,000 792,000 228,768 244,626 10,908 924,264 214,268 257,000 255,285 145,600 40,000 101,073 239,872 45,000 22,015 36,711 565 4,500 4,000 13,000 2,527,921 6,645 268,000 274,645 2,802,566 10/25/2000 2001 Water Budget Acct No SOURCE OF SUPPI Y AND EXPENSES - MAINTENANCE { 02) Account Title 01.6180,02 618.2 Chemicals-Source of Supply- Maim. 1998-1,259 2000- 261 1999-261 (Polymer - Sequester) (Acid - Bleach) TOTAL CHEMICALS - SOURCE OF SUPPLY - MAINT. LAST BUDGET AMOUNT JUP OR (DOWN1 O 01.6200.02 620.2 Materials & Supplies- Source of Supply* Maint. 1998- 4,200 2000- 7,780 1999- 7,137 Materials for Maintenance of Wells & Springs: Well ProducTion Tests: (10 wells @ S90 each) Well Rig Supplies Routine Maintenance-Cleaning Drill Rig/Cieaning Maintenance of Supply Mains: Main Break (Well Lines) TOTAL MATERIALS & SUPPLIES - SOURCE OF SUPPLY - MAINT. 01,6360.02 636.2 Contractual Services - Other - Source of Supply - Majnt. 1998 - 2000 - 42E 1999 - TOTAL CONTRACTUAL SERVICES - OTHER - SOURCE OF SUPPLY - MAINT, AMOUNT2.000 °1 01.6750.02 675.2 Miscellaneous Expenses- Source of Supply- Maint. 1998- 350 2000- 493 1999-698 Well Drillere License Fee {Morris} IGWA Dues( Morris & John) Natl. GWA Dues (Morris} Miscellaneous TOTAL MISCELLANEOUS EXPENSES - SOURCE OF SUPPLY - MAINT. GRAND TOTAL SOURCE OF SUPPLY - MAINT. (.02) Account Budget 1,300 10,000 2,000 800 13,800 2001 Water Budget.xls 1 10/25/2000 2001 Water Budget WATER TREATMENT EXPENSES - OPERATIONS 01.6010.03 601.3 Salaries &Wages- Employees- Treatment- Oper. 1998- 220,046 2000- 259,848 1999- 238,072 2% 2% 9% 5% NAMI= % SPLIT PJLY D3[: Brandau, R 100% 52,359 1,047 Cowan. D 100% 38,836 777 Henslay. M 100% 48,218 4,822 Hoesman, D 100% 38,836 3,984 Lovell, R 100% 37,186 3,347 Wilbur, J 100% 39,586 1,979 Reimburse for unused sick pay (2% Salary) 5, 100 Holiday Pay 1,150 Summer Premium (12 wks @.50/hr.) 225 261,496 TOTAL SALARIES & WAGES - TREATMENT - OpER. LAST BUDGET AMOUNT {UP OR (DOWN) 11,866 01.6040.03 604.3 Employee Pensions & Benefit-Treatment-Oper. 1998- 41,838 2000- 54,993 1999-46,529 Matching 45? Benefits ( 4.25% - Design) (3% City Contrib.) PERF: Budgeted Labor (01.6010.03) x 2001 PERF Rate of 7.25% {Full time permanent employees cniy) % Supplied by Clerk's Office for 2001 Employee Insurance Health Ins. ( Inc. Per Human Res.) Life Short Term Disab. Education & Training Brandau, Cowan, Henslay, Hoesman, Lovell. Wilbur Operator School (6) x 75.00 Safety Video/Materials AWWA Conferences Wat. Ph. Certlf. Test * 6 L~ 30.00 Misc. Training (Rural Water,IN Water,IDEM Seminars, etc.) 15,856 6,025 20,108 28,799 245 680 29,724 3,325 Account Budget 277,352 TOTAL PENSIONS & BENEFITS - TREATMENT - OPER. LAST BUDGET AMOUNT IUP OR (DOWN) 4,656 59,182 2001 Water Budget.×ls 2 10/25/2000 2001 Water Budget WATER TREATMENT EXPENSES - OPERATIONS I 031 ICont'dl Acct. No, Account Title 01.6150.03 615.3 Purchased Power - Treatment - Oper, 1998 - 192.583 2000 - 239,275 1999 - 250,726 (See Back-Up Form) PSIENERGY 2001Projectionincludes 4% Growth Includes 30,000 (IWC) 210,000 IPALCO: 2001 Projection includes 4% Growth 40,000 INDIANA GAS: 2001 Projection includes 4% Growth and increase for rate 7,000 TOTAL PURCHASED POWER - TREATMENT - OPER. 01.6180.03 618.3 Chemicals - Treatment - Oper. 1998 - 232,938 1999 - 222,973 12,000 20O0- 223,616 (See back-up for projection details) (All projections include growth) Salt (Includes 4 % growth) Chl(~rine (Includes 4% growth) Fluoride (Includes 4% growth) HTH PoJymer Acid 234,000 3,335 14,000 650 1,000 TOTAL CHEMICALS - TREATMENT o OPER. 01.8200.03 620,3 Materials and Supplies-Treatment-Oper. 1998-10,993 2000-10.014 1999 * 12,225 INCLUDES: Charts, Supplies, Ace, Overalls, Pressure Gauges, Lab, Rain Coats, Boots, Comp. Equip & Supplies Safety Equipment. Scada System, Safety Signs, Desks, Office Furniture TOTAL MATERIALS & SUPPLIES - TREATMENT - OPER. Account Budget 257,000 253,985 12,000 2001 Water Budget.xls 3 10/25/2000 2001 Water Budget WATER TREATMFNT FXPENSES - OPFRATIONS I 031 {Cent'd) Acct, No, Account Title 01.6350.03 635.3 Contractual Services - Testing - Treatment - Oper. 1998- 0 2000- 4,955 1999-2043 IDEM - SDH Testing Distr. System Bact. Flowing Well Testing (12 Bacti & 1 Nitrate) SOC's Trihalomethanes VOC's TOTAL CONTRACTUAL SERVICES - TESTING · TREATMENT - OPER. Account Budget 9,000 01.6360.03 636.3 ContractualServices-Other-Treatment-Oper. 1998- 2,800 2000-12,390 1999-180 Fire Extinguisher 6 Pegors-Morris, Jeff, D.J., David, Rick, & Rob ( '~19 per.too.for all 6) New Pager For Dialer To Call PIt. 2 Phone (571-2642) PIt. 3 Phone (571-2633) Pit. 4 Phone (971-2460) Rt. 5 Phone (571-2639) PIt. 5 Phone (571-2658) Pit. 5 Phone (571-2659) Phone (RO4-6931 ) Mobile Phones:847-8034, 847-8032 & 650-3280 (~29 Basic Mo,) Uniform Rental; 5 Men @ 260/man HensIcy, Wilbur, Cowan, Hoesman & Lovell Safety Physicals (Pulm, Stress Test, TB X-rays, Hepatitls Immun.) USGS TOTAL CONTRACTUAL SERVICES - OTHER - TREATMENT - OPER. 01.6560.03 656.3 Insurance- Vehicle- Treatment- Oper. 1998-1,903 1999 -3,441 2000- 2,080 TOTAL INSURANCE VEHICLE - TREATMENT * OPER. 28,000 3,786 -- 2001 Water Budget.xls 4 10/25/2000 2001 Water Budget WATER TREATMENT EXPENSES - OPERATIONS I 031 ICont'd) Ac~t No. Account Title 01,6570.03 657.3 Insurance- GeneralLiability-Treatment- Oper. 1998 * 1,748 2000- 3,557 1999- 2,514 TOTAL INSURANCE - GENERAL LIABILITY - TREATMENT - OPEn. LAST BUDGET AMOUNT ~UP OR (DOWN) 1,235 01.6580.03 658.3 Insurance - Workman's Compensation - Treatment - Oper. 1999 - 1,835 2000 - 2.131 1999 - 1,876 TOTAL INSURANCE - WORKMEN'S COMP. - TREATMENT - OPEn. LAST BUDGET AMOUNT iUP OR (DOWN) 137 01.6590.03 659.3 Insurance - Other - Treatment - Oper. 1998 - 9,902 2000 - 7,143 1999 - 10,102 TOTAL INSURANCE - OTHER - TREATMENT - OPEn. 01.6750.03 675.3 Miscel}aneous Expenses - Treatment - Oper. 1998 ~ 1,866 2000- 0 1999-555 TOTAL MISCELLANEOUS EXPENSES - TREATMENT OPEn. LAST BUDGET AMOUNT JUP OR (DOWN} 0 GRAND TOTAL WTR. TREATMENT EXP. - OPERATION ( .03 ) oI 42,833 Account Budoet 4,000 2,200 11,119 0 917,624 -- 2001 Water Budget,xls 5 10/25/2000 2001 Water Budget WATER TREATMENT EXPENSES - MAINTENANCE 01.6010.04 601.4 Salaries & Wages-Employees-Treatment-Ma(nt. 1998 - 23,167 2000- 25,116 1999- 24,932 OVERTIME % 8% 01.6040.04 (604.4) NAME % SPLIT Schimmel, L. (S = #01.7010.04 an 50% #01.7012.05) Reimburse for unused sick pay (2% Salary} TOTAL SALARIES & WAGES - TREATMENT - MAINT. Employee Pensions & Benefits - Treatment - Maint. 1998 - 4,408 2000 - 5,819 1999 - 4,509 PAY 23,909 478 24,387 Matching 457 Benefits (4.25% - Design) (3% * City Contrib.) PERF: Budgeted Labor (01.6010.04) x 2001 PERF Rate of 7.25% (Full time permanent employees on[y) % Supplied by Clerk's Office for 2001 Employee Insurance Health Ins. {Inc. Per Human Res.) Life Short Term Disab. TOTAL PENSIONS & BENEFITS - TREATMENT - MAINT. 01,6200.04 620.4 Materials & Supplies - Treatment - Maint. 1998 - 30,787 2000 - 13,740 1999 - 11,108 Maint. Of Water Trtmt Equipment Hack saw Chlodnator Repair Parts Flyght Pumps, Waste Pumps(Imp, Lower Seal, Tool, etc,) Misc. Pump Supplies Power Tools and Hand Tools, Locator Maintenance of Power Production Equipre: Maintenance Diesel Generators @ $400 ea. (Pits. 2, 3, 5, GST) Maintenance of Pumping Equipment (3) PareD Valve Overhaul HSP, Meters, Pumps & Motors Maintenance of Struct. & Improv.: Water Plant Buildings Plant Landscapmg TOTAL MATERIALS & SUPPLIES - TREATMENT - MAINT. 1,913 1,913 1,300 1,907 2O 65 4,104 Account Budget 26,300 7,311 20,000 2001 Water Budget .×1 s 6 10/25/2000 2001 Water Budget Acct, WATE:R TRFATMENT EXPENSES - MAINTENANCE I 04l ICont'dl Account Title 01.6360.04 636.4 Contractual Services - Other - Treatment - Maint. 1998 - 3,682 2000 - 9,451 1999 -4,830 Multiguard-Fire & Burglar Alarm Plant # 2, 3, 4, 5 (Prev, Maint.) Ground Storage Tank (Prey, Maint.) Monthly Monitoring Centr. Station Inspect Plant Fire Extinguishers Misc. Contractual Service - Water Blasting TOTAL CONTRACTUAL SERVICES * OTHER - TREATMENT - MAINT. 01.6500.04 650.4 Transportation Expenses - Treatment - Maint. 1998 - 3,987 2000 - 4,999 1999 - 4,241 3B, 32C, 51A, 55, 61, 34 Gasoline Projected ~ 1.30 per gal. Repairs Misc. - (Tires & batteries for Tk #55 & Drilling Rig) (Dump Truck # 30 (Maint. & unl. gas) ) # 86 Tractor/Mower (Maint. & Diesl Fuel) Well Drilling Rig TOTAL TRANSPORTATION EXPENSES - TREATMENT - MAINT. 01.6570.04 657.4 Insurance - General Liability - Treatment - Maint. 1998 - 343 2000 * 707 1999 - 493 TOTAL INSURANCE - GENERAL LIABILITY - TREATMENT - MAINT. 258 01.6880.04 658.4 Insurance - Workman's Compensation - Treatment - Malnt. 1999 - 306 2000 - 247 1999 - 357 TOTAL INSURANCE - WORKMAN'S COMP. - TREATMENT - MAINT. 10,000 6,000 800 393 2001 Water Budget.xls 7 10/25/2000 2001 Water Budget WATER TREATMENT EXPFNSES - MAINTFNANCE ( 04} IConi'd) ~cct, No, Account Title 01,6690.04 659,4 Insurance - Other - Treatment - Maint. 1998 - 207 2000-182 1999 - 241 TOTAL INSURANCE - OTHER - TREATMENT - MAINT. GRAND TOTAL WATER TREATMENT EXPENSES - MAINT. (.04) ]UP DR (DOWN)AMOUNT 4.974 Account Budget 265 71.069 2001 Water Budget.xls 8 10/25/2Q00 2001 Water Budget TRANS. & DISTRIB. EXPENSES - OPERATION 01,6040.05 604.5 Employee Pensions & Benefits - Trans. & Dietrib. - Oper. 1898 - 5,418 2000 - 1,342 1999-1,432 Education & Training * Distr. TOTAL PENSIONS & BENEFITS - TRANS. & DISTRIB. - OPER. LAST BUDGET AMOUNT 3,500 UP OR (DOWN) 0 0.00% 01.6500.05 650.5 Transportation Expenses - Trans. & Distrib.- Oper. 1998 - 8,710 2000 -12,737 1999-10,008 Gasoline far Trucks 28, 44, 49, 52, 53, 81.85, 87, 91and new truck @$1 .30 per gal. Backhoe #13 - Diesel Mechanical Repair TOTAL TRANSPORTATION EXPENSES - TRANS. & DISTRIB. - OPER. 90 01.6560.05 656.5 Insurance-Vehicle-Trans. & Distrib.-Oper. 1998-1,186 2000-1,008 1999-1657 TOTAL INSURANCE - VEHICLE - TRANS. & DISTRIB. - OPER. 01.6590.05 659.5 Insurance- Other-Trans. & Distrib.-Oper. 1998 ~124 2000-100 TOTAL INSURANCE - OTHER - TRANS. & DISTRIB. - OPER, 0 01.6600.05 660.5 Advertising Expense- Trans. & Distrib.-Open 1998-0 2000-0 1999-0 AdveRising ~rbids TOTAL ADVERTISING EXPENSE - TRANS. & DtSTRIB. - OPER (100) 100 -100.00% GRAND TOTAL TRANS. & DISTRIB. - OPERATION (21,710) Account Budget 3,500 8,520 300 4,395 13,215 1,823 159 200 18,897 2001 Water Budget.xls 9 10/25/2000 2001 Water Budget TRANS & DISTRIB FXPENSES - MAINTENANCE (.06) Aeet. No, Aceount Title 01,6010.06 601.6 Salaries &Wages-Employees-Trans. &'Distrib.-Maint. 1998 - 269,131 2000- 327,017 1969-321,402 OVERTIME % NAME % SPLIT PAY 6% Bess, H. 100% 26,069 8% Bucksot, B. 100% 26,881 8% Caldwell. J. 100% 28,069 8% Cook, S. 100% 39,866 8% Hollander, G. 100% 36, 143 5% Pace, P. 100% 46,718 8% Ransford, B. 100% 29,237 5% Simpson, D. 100% 42,876 2% Spears, Jack 50% 16, 144 6% Whirlow, Sean 100% 25,313 2% Wilkev. E. (S#01.7010.02 50% 14,273 2% Willlares. P. (S#O1.7010.02) 50% 15,647 Reimburse for unused sick pay (2% Salary) 7.004 2% OT Holiday Pay 1,760 358,970 Tamp. As Needed 6,000 TOTAL SALARIES & WAGES - TRANS. & DiSTRIB. - MAINT. 9,937 01.6040.06 604.6 Employee Pensions & Benefits- Trans. & Distrib.- Maint. 1998- 45,260 2000- 70,426 1999- 59,383 Matching 457 Benefits (4.25% - Design.) (3 % City Contrib.) PERF: Budgeted Labor (01.6010.06) x 2001PERF rate of 7.26%(Fulltirne permanentemployees only) %Supplied by Clerk's Office for 2001 Employee Insurance Health Ins. (Inc. Per Human Res.) Life Short Term Disab. Safety Physicals:(Pulrn. Stress Tests, TB X-rays, Hepatitus Immun.) TOTAL PENSIONS & BENEFITS - TBANS. & DISTRIB. - MAINT. 1,684 2,160 2,245 3,189 2,336 2,339 2,144 363 286 313 36 21,413 1.090 27,578 56,944 428 825 1,200 61,397 Account Budget 365,363 90,065 " 2001 Water Budget,xls 10 10125/2000 2001 Water Budget TRANS & DISTRS. EXPENSES - MAINTFNANCF I 061 ICont'dl 01,6200.06 620.6 Materials & Supplies-Trans.& Distrib.* Maint. 1998-11,954 2000- 39,508 1999- 51.020 Storage Facilities Shep Supplies Meter Expenses - Maint. of Customer Installation Miscellaneous Expense: Supplies Winter Insul. Coverails & Safety Gear Misc. Shop Supplies Maintenance Structure - Shop Maint. of Distr. Tower & GST: General Maintenance Diesel Generator (Backup) Maint. of Transmission Mains Maintenance of Service Maintenance of Meters: Brass Expansion Connectors Maintenance of Hydrants & Valves Maintenance of Gem PIt, D,S. Equipre. Distribution System - Tools Office Supplies - Distribution TOTAL MATERIALS & SUPPLIES - TRANS. & DISTRIB. - MAINT. .6360,06 635.6 Contractual Services - Testing - Trans. & Distrib, - Maint. 1998 - 2,646 2000 - 2,342 1999 * 2,856 Bacteriological Botttes TOTAL CONTRACTUAL SERVICES - TESTING - TRANS. & DISTRIB. - MAINT. 500 1,600 2,o00 2,200 1,200 2,000 4,000 1,600 400 15,500 17,500 3,500 3,500 14,000 2.000 3,000 6,000 49,500 Account Budget 68,000 3,000 2001 Water Budget.xls 11 10/25/2000 2001 Water Budget TRANS & DISTRIR EXPENSES - MAINTENANCE ( 061 (Cont'd) O1.6360,06 636.6 ContractuaiServices- Other-Trans. & Dietrib.- Ma)nt. 1998- 2,646 2000-11,433 1999- 5.046 Uniform Rental for 8 + 1/2 (Spears) Men @ 260/yr. ea. (Cook, Simpson, Hollander, Bess, Ransford, Bucksot, Caldwell, Whirlow, Spears) INDIANA GAS (includes projected 30% increase) PSI ENERGY PHONE: (571-2640, 571-2643, 571-2648, 571-2653, 971-2658) Pagers - 8.5 ~ $3.75/mo Mobile Phone (416-3154 Plus 2) Radio & Roger Repair Harco Waterworks Contract Pest Control Best Way 5,500 850 383 400 815 1OO 225 TOTAL CONTRACTUAL SERVICES - OTHER - TRANS. & DISTRIB. - MAINT. 8.227 01.6670.06 657.6 Insurance - GeneralLiabillty-Trans, & Dietrib.-Maint. 1998-1,919 2000- 2,926 1999- 2,070 01.6580.06 658.6 01.6590.06 659.6 TOTAL INSURANCE - GENERAL LIABILITY - TRANS. & DIeTRIB. - MAINT. Insurance - Workman's Compensation - Trans. & Di~trib. - Maint. 1998 - 2,217 2000 - 2,540 1999 - 2,143 TOTAL INSURANCE - WORKMAN'S COMP. - TRANS. & DISTRIB. - MAINT. Insurance - Other - Trans. & Distrib. - Maint. 1998 - 207 2000 - 182 1999 - 241 TOTAL INSURANCE - OTHER - TRANS. & DISTRIB. - MAINT. GRAND TOTAL TRANS. & DISTRIBUTION - MAINT. (.06) 13,183 3,000 2,600 265 562,496 2001 Water Budget.xls 12 10/25/2000 2001 Water Budget Acct,~ 01.6010.07 5% 5% 3% 4% 4% 4% 601.7 01.6040.07 604.7 (4.25 % - Design.) (3% City Contrib.) CUSTOMER ACCOUNTS EXPENSES Account Title Salaries &Wages-Employees-CustomerAccounts 1998-112,601 2000 * 111,040 1999 -106,928 Billing Office: Split Evenly NAME %SPUT Gray 50% Gwaltney 50% Lindamood 50% Strasburger 90% Reimburse for unused sick pay (2% Salary) Holiday pay PAY 19,840 16,397 16,022 15,324 1.357 250 69.190 992 820 481 153 2,446 Meter Readers: Split Evenly Eads 50% 13.403 536 Greathouse 50% 14,619 985 Rigdon 60% 12.306 492 Reimbursefor unused sick pay (2%/employee) 807 41,135 1,613 TOTAL SALARIES & WAGES - CUSTOMER ACCOUNTS LAST BUDGET AMOUNT IUP OR )DOWN) 1,78E Employee Pensions & Benefits-CustomerAccount$ 1998-19,129 2000- 22,882 Matching 457 Benefits PERF: Budgeted Labor (01.6010.07) x 2001 PERF Rate of 7.25% (Ful~ time permanent employees only) % Supplied by Clerk's Office for 2001 Employee Insurance Health ins. (inc. Per Human Res.} Life Short Term Disab. Education & Training Gwaltney, Lindamood, Gray, Strasburger Meter Reader Trng.(NMRC, OSHA.Backflow) TOTAL PENSIONS & BENEFITS - CUSTOMER ACCOUNTS LAST BUDGET AMOUNT IUP OR (DOWN) 3,076 4,976 8,293 10,213 143 305 10.661 2,000 Account Budget 25,929 2001 Water Budget.xls 13 10/25/2000 2001 Water Budget CUSTOMER ACCOUNTS EXPENSES { 07~ ICont*d) Acct, # Account Title 01.6200.07 620.7 Materials & Supplies-Customer Accounts 1998- 39,468 2000- 35,138 1999- 40,640 Meter Reading Expenses Meter Reading Supplies Winter outerwear (Boots,Coat or Bibs, Gloves) Wrenches-3,Tubes, etc. Billing Office Expenses 40% = Bu~k Mailing, Postage & Prosort Fees 40% = Letter Postage & P.O. Box Fees 40% = General Billing & Office Supplies 40% = Printing of Bills 40% = All Computer Supplies 40% = inserts Projected WATER PORTION ( Includes additional Special Mailings) TOTAL MATERIALS & SUPPLIES - CUSTOMER ACCOUNTS 2,175 01.6360.07 636.7 Contractual Services - Other - Customer Accounts 199S-3754 2000-8691 1999- 5,226 Office Equipment Service 1/2 Maintenance on all equipment 1/2 Sensus - Maintenance 1/2 Software Support (Billing Computer) Mailing Service 3 Uniforms @ 260/¥r/man Cell Phone 01.6500.07 TOTAL CONTRACTUAL SERVICES - CUSTOMER ACCOUNTS 650.7 Transportation Expenses - Customer Accounts 1998 - 1,443 2000-1,553 1999 - 1,523 (See Master B.U. Form) For Vehicles: 42.42B, 55.89 Gasoline - Projected @ 1.30 Gal. TOTAL TRANSPORTATION EXPENSES - CUSTOMER ACCOUNTS 800 425 200 20O 1,625 2,400 2,100 750 3,000 4,500 780 360 35,600 13,890 2,500 2001 Water 5udget .xls 14 10/25/2000 2001 Water Budget CUSTOMFR ACCOUNTS FXPFNSFS 1.07 I ICont'dl 01.6660.07 666.7 Insurance - Vehicle - Customer Accounts 1998-65~ 2000-542 1999-892 01.6570.07 (657.7) TOTALINSURANCE-VEHICLE-CUSTOMER ACCOUNTS LAST BUDGET AMOUNT ~UP OR(DOWN) 0 Insurance-Genera[Liabilily-CustomerAccounts 1998-377 2000-555 1999-394 TOTAL iNSURANCE - GENERAL LIABILITY - CUSTOMER ACCOUNTS 01.6580.07 658.7 Insurance * Workman's Compensation - Customer Accounts 1998 - 535 2000 - 628 1999 - 536 TOTAL INSURANCE - WORKMAN'S COMP. - CUSTOMER ACCOUNTS 01.6590.07 659.7 Insurance ~ Other - Customer Accounts 1998 - 247 2000 - 200 1999 - 289 TOTAL INSURANCE - OTHER - CUSTOMER ACCOUNTS 00.6700.07 670,7 Bad Debt Expense - Customer Accounts 1998 -128 2000-1,190 1999-232 Uncollectable Expense (MEMO ONLY) Not included in totals From Billing Office Supervisor LAST BUDGET AMOUNT 2,400 UP OR (DOWN( 1,600 66.67% 4,000 AccnuntBudget 981 600 6S0 318 2001 Water Budget.xls 15 10/25f2000 2001 Water Budget CUSTI3MPR ACCOUNTS EXPENSFS /~s;ct. # Acaount Title 01.6750.07 67S.7 MiscellaneOus Expenses - Customer Accounts 1998 - 450 2000 - 10,178 1999 - 3,059 Water QualltV Rpt. (WATER ONLY) Layout, Prntg. Postage, Etc. TOTAL MISCELLANEOUS EXPENSES - CUSTOMER ACCOUNTS -- LAST BUDGET AMOUNT UP OR (DOWN) 1,500 GRAND TOTAL CUSTOMER ACCT. EXPENSE (.07) LAST BUDGET AMOUNT ( IUP OR (DOWN) .07) 7,362 { .07 t {Cont'dl 6,500 23,08% Account Budget 8,000 202.852 2001 Water Budget.xls 16 10/25/2000 2001 Water Budget ADMINISTRATIVF & GFNERAL EXPENSES I.O81 01.6010.08 601.8 Salaries &Wages-Administrative & General 1998-105,028 2000- 96,725 1999-103,498 OVERTIME % NAME % SPLIT PAY 3% Arnone 50% 20,913 O% Duffy (S-#O1.7010.08) 60% 34,364 2% Kempa (S-#01.7010.08) 50% 15,760 3% McManama 60% 24,889 3% Spearman 50% 18,392 Reimburse for unused sick pay (2% Salary) 2,286 116,604 01.6040.08 604.8 (4.25% - Design.) (3% City Contrib.) Temp, Help as Needed (UP TO 12,50 per hr, } 1/2 Split 50% 2,000 TOTAL SALARIES & WAGES* ADMINISTRATIVE AND GENERAL LAST BUDGET AMOUNT }UP OR(DOWN) 21,786 Employee Pensions & Benefits-Administrative and General 1998-12,111 2000-19,420 1999-13,787 Matching 457 Benefit PERF: Budgeted Labor (01.6010.08) x 2001 PERF Rate of 7.25% (Full time permanent employees only) % Supplied by Clerk's Office for 2001 Employee Insurance Health Ins. (Inc. Per Human Res.} Retires Health insurance Life Short Term Disab. Education & Training Arnone, Duff,/, Kempa, McManama, Spearman Util. Accountant ([CPA Prof. Education) AWWA Annual Conference · ( All Water ) Total Education & Training TOTAL PENSIONS & BENEFITS - ADMINISTRATIVE & GENERAL 627 315 747 552 2.241 3,240 8,616 8,802 2,260 250 5,000 120,845 28.281 2001 Water Budget.xls 17 10/25/2000 2001 Water Budget ADMINISTRATIVE & GFNERAL EXPFNSES { 08i { Cont'd ) 01.6200.08 620.8 Materials & Supplies - Administrative & General 1998 - 8,014 2000 - 9,063 1999 - 13,573 Supplies & Equipment & etc TOTAL MATERIALS & SUPPLIES - ADMINISTRATIVE & GENERAL LAST BUDGET AMOUNT iUP OR (DOWN) (2,500) 01.6310.08 631.8 Contractual Services - Engineering - Administrative & General 1998 - 18.933 2000 - 34,027 1999 - 41,918 TOTAL CONTRACTUAL SERVICES - ENGINEERING - ADMINISTRATIVE & GENERAL 01.6320.08 632.8 ContractuaiServices-Accounting-Administrative & General 1698 -7,364 2000-13,186 1999-13.561 Consultants - Crows Chizek TOTAL CONTRACTUAL SERVICES - ACCOUNTING - ADMINISTRATIVE & GENERAL 01.6330.08 633.8 Contractual Services - Legal - Administrative & General 1998 - 2,027 2000 - 11,634 1999 -10,966 Recadification of Ordinances Various Legal Expenses TOTAL CONTRACTUAL SERVICES - LEGAL - ADMINISTRATIVE & GENERAL Account Budoat 3,000 17,000 10,000 13,000 2001 Water Budget.xls 18 10/25/2000 2001 Water Budget ADMINISTRATIVE & GENERA[ FXPFNSES I 081 I Cont'd ) 01.6360.08 636.8 ContractualServices-Other-Administrative & General 1998-12,585 2000- 880 1999-3,666 Wide Area Network Blueprints Split with Sewer Waste Collection - PS, P2 Loc. (ONLY WATER) General Consulting, SCADA Split with Sewer (Netw., GIS, Etc.) Fax Machine Maint, Agreement (Adv. Bus.Conc.) (Split with Sewer) Xerox Maintenance - Model 5820 (Split with Sewer)(~15.66 Per Mo.) Phones & Voice Mail Repair Typewriters, Calculators & Computers Xerox Maintenance - Model DC 214 (BO)$(10.30 Per Mo) Spiit w Sewer Disaster Recovery - 2 Servers National City Bank (Bonds) (Per Util. Acct.) (Not in Total) TOTAL CONTRACTUAL SERVICES - OTHER - ADMINISTRATIVE & GENERAL 01.6361.08 636.81 5,924 Common Costs-Mayor's Office-Administrative & General 1998- 20,077 2000- 21,288 1999- 20,077 01.6362.08 636.82 TOTAL COMMON COSTS - MAYOR'S OFFICE - ADMINISTRATIVE & GENERAL Common Costs-Clerk's Of[ice-Administrative & General 1998- 65,386 2000-69,333 1999- 65,386 TOTAL COMMON COSTS - CLERK'S OFFICE - ADMINISTRATIVE & GENERAL A °uNT o 7o :1oo' /oi 01,6363.08 636.83 Common Costs - Engineer - Administrative & Genera{ 1998 - 14,460 2000-15,331 1999 - 14,460 TOTAL COMMON COSTS - ENGINEER - ADMINISTRATIVE & GENERAL 01.6364,08 636.84 Common Costs - BPW - Administrative & General 1998 - 33,604 2000 - 35,628 1999 - 33,604 TOTAL COMMON COSTS - BPW o ADMtNISTRATIVE& GENERAL 1,500 Account Budget 22,000 22,153 72,148 15,956 37,078 2001 Water Budget.xls 19 10/25/2000 2001 Water Budget ADMINISTRATIVE & GFNERAL EXPENSES ( 061 I Cont'd I Acct. # Account Title 01.636B.08 636.85 Common Costs - Council - Administrative & General 1998- 6,345 2000-6,732 1999- 6,345 TOTAL COMMON COSTS - COUNCIL - ADMINISTRATIVE & GENERAL 01.6366.08 636.06 Common Costs ~ Admlnist~ation - HR, MIS. GIS, Admin. - Administrative & General 1998 - 0 2000 - 39,679 1999 - 0 TOTAL COMMON COSTS - ADMINISTRATION - ADMINISTRATIVE & GENERAL O1.6367.08 636.87 Common Costs * Legal - Administrative & General 1998 - 0 2000 ~ 10,221 1999 - 0 TOTAL COMMONS COSTS * LEGAL * ADMINISTRATIVE & GENERAL LAST BUDGET (UP OR (DOWN)AMOUNT 0 01.6410.08 641.8 Rental of Building/Real Property - Administrative & General 1998 - 45,000 2000 - 60,446 1999 - 52,051 TOTAL RENTAL OF BUILDING/REAL PROPERTY - ADMINISTRATIVE & GENERAL 01.6500.08 650.8 Transportation Expenses - Administrative & General NEW 1998 - 0 2000 - 129 1999 - 0 (See Master B.U, Form) For Vehicle 1 GASOLINE - Projected @ 1.30 Gal. Repairs TOTAL TRANSPORTATION EXPENSES - ADMINISTRATIVE & GENERAL AM°uNT 30B °1 Account Budget 7,002 68,014 17,521 45,000 300 2001 Water Budget.xls 20 10/25/2000 2001 Water Budget ADMiNISTRATiVE & GENERAl EXI~ENSFS [ 081 I Cont'd ) 01,6960,08 656.8 NEW Insurance-Vehicle-Administrative & General 1998-0 2000-0 1999-0 TOTAL INSURANCE VEHICLE - ADMINISTRATIVE & GENERAL AMouNT 126 01.6570.08 657.8 Insuranee-GeneralLiability-Adminlstrative & Genere( 1998-69 2000-153 1999-99 TOTAL INSURANCE - GENERAL LIABILITY - ADMINISTRATIVE & GENERAL 01.6680.08 668.8 Insurance - Workman's Compensation - Administrative & General 1998 - 153 2000 - 219 1999-179 TOTAL INSURANCE - WORKMAN'S COMP - ADMINISTRATIVE & GENERAL 01.6590,08 669.8 Insurance-Other-AdminisTrative & General 1998 - 2,477 2000- 2.000 1999- 2,894 Employee Bending Included TOTAL tNSURANCE- OTHER - ADMINISTRATIVE & GENERAL 01.6600.08 660.8 Advertising Expense - Administrative & General 1998 - 268 2000 ~ 278 1999 - 412 Help Wanted Ads, Bid Advertising TOTAL ADVERTISING EXPENSE - ADMINISTRATIVE & GENERAL Account Budget 125 200 250 3,177 365 -- 2001 Water Budget.xis 21 10/25/2000 2001 Water Budget ADMINISTRATIVF & GENERAL EXPENSES hOB) I ConI'd ) 01.6670,08 667,8 RegularDry Commission Expense-Other-Administrative & General 1998 - 2,8?5 2000 - 1,995 1999-1,995 State Board of Accounts - Audit 2000 01.6750.08 TOTAL REGULATORY COMMISSION EXPENSE - ADMINISTRATIVE & GENERAL 675.8 Miscellaneous Expenses - Administrative & General 1998 - 1,676 2000 - 2.661 1999 - 2,661 G F O A-Memb. &Subscr. Split Evenly A W W A-Utilihv Membership (Duffy & Hensley) A W W A-Research Foundation iDEM Filing & Processing Fees-IDEM IRWA Membership Dues Indiana CPA Society Membership (McManama) Miscellaneous Expense TOTAL MISCELLANEOUS EXPENSES - ADMINISTRATIVE & GENERAL GRAND TOTAL ADMINISTRATION & GENERAL EXPENSE: 9,303 Account Budget 4,500 4,500 512.415 -- 2001 Water Bud get .xis 22 1 OJ25/2000 2001 Water Budget TAXES. BONDS INTEREST AND DEPRECIATION 10.2217.00 221.7 Bond Principal Payable (Not in Budget Total) See #Q0.4273.00 for interest 255,000 00,4030.00 403 Depreciation Expenses: 792,000 Not in Total - Per Util. Acct. 00,4080.11 408.11 Property TaxesiPaymentin Lieu ofTaxes} 1998- 96,900 2000- 98,035 1999 - 95,000 TOTAL PAYMENT IN LIEU OF TAXES 12,150 01.4080.12 408.12 PayrollTaxes 1998- 54,764 1999- 59,177 2000- 60,697 FICA: Budgeted Eligible Salaries 2001 -- Times: FICA RATE for 2001 = % Supplied By Clerk's Office for 2001 2001 FICA Unemployment Taxes (1 full benefits L~ 9,112/yr.) (Per Utility Accountant) 924,264 7.65% TOTAL PAYROLL TAXES (710) 00.4090.11 409.11 1998-31,980 1999- 37,146 2000-37,964 1.2% All Operating Revenues Except Hydrant Rentals Per Utility Accountant Projected Sales Less Annual Exclusion Tax Basis TOTAL GROSS INCOME TAXES ,400) 00.4273,00 427.3 Interest on Long Term Debt: Per Utility Accountant - Not included in Total - Paid by Sinking Fund Interest To Be Paid - 246.879 interest Expense - 244,626 70,706 8,112 3,134,600 1,000 3,133,600 Account Budget 112,350 78,818 37,600 2001 Water Budget.xls 23 10/25/2000 2001 Water Budget 00.4280.00 TAXES BONDS INTEREST ANt) DEPRECIATION ICont'dl 428 Bond Issuance Write Off Expense: 1998 - 10.909 2000 * 10,909 1999 * 10.908 (MEMO ONLY) 10,908 GRAND TOTAL TAXES & MISCELLANEOUS GRAND TOTAL WATER OPERATING EXPENSE: ORERAT,NG ,UNDTS.01 2..5;:;00 l GRAND TOTAL OPERATING EXPENSES 2001 $2,527,921 2000 $2,451,906 1999 $2.020,914 1998 $1,914,785 1997 Sl,791.615 228,769 2,527,921 -- 2001 Water Budget.xls 24 10/25/2000 2001 Water Budget Accz # 02.2240.00 224 02.4275.00 427.5 02.3040.50 02.3070.20 WATER DEPRECIATION Account Title 02.3200.30 320 Other Long Term Debt Wireless Equipment Lease Purchase Xerox Mod. 5820 (Adm.) - Lease/Purch. Xerox Mod. DC214 (Bill./Off.) - LeaselPurch. TOTAL OTHER LONG TERM DEBT 5,530 Interest - Other Wireless Equipment Lease Purchase Xerox Mod, 6820-(Adm.)Lease/Purch Xerox Mod. DC214-(Bill. Off.)Lease/Purch TOTAL INTEREST - OTHER 294 304 Structures andImprovements- General Plant 1998-0 2000-0 1999-0 Office Renovation 307Wells and Springs 1998-O 1999-O 2000-0 Meters for Weils RantEquipment: 1998- 6,590 1999-4333 2000-0 Plant 4 Softner Ctrls/Filter Ctrls Spare Pump Motor Plant Equipment Genral Replace Parco Valves, Plant 3 02.3330.40 333 Copper 1998-849 1999-1,907 2000 * 14,713 O2.3341,40 334.MI MeterInstallation: 1999 2,193 2000- 6,194 Valves, Yokes, Couplings & Repair Brass 45,000 2,500 4,000 15,000 5,474 488 176 348 117 42 Account Budget 6,138 507 2,500 7,50O 66,500 1,000 3,O00 2001 Water Budget.xls 25 10/25/2000 2001 Water Budget WATER DEPRECIATION ICont'd) 02.334M.40 334.M Meters: 1998-58,301 1999-111,633 Vehicle unit Includes New Meter Installations and Change Outs 02.336H.40 3B,HV Hydrant & VaNe Replacements: 1998-10,961 1999-19,952 2000-113,364 2000-10,792 Hydrant & Valve Replacement 02.3400.50 340 Adm. Office Equipment 1998 * 27,261 1999-29,649 2000- 34,585 Administrative Office: Office Equipment Computer Hardware GIS software Printer 02.3405.50 340.6 office Equipment: Distr. 1998- 2,708 1999 + 2,209 2000-3,803 Computer Hardware 02.3431.50 343,1 Tools:DISTRIBUTION SYSTEM 1998-4,213 1999- 8,105 2000 - 2,300 Air Compressor Miscellaneous 02.3440.50 344 Laboratory Equipment: 1998 o 2,082 1999-0 2000-0 Hach Portable Meter 02.3460.50 346 Communication Equipment 1998-0 1999 - 2,757 2000-5,602 Plant: 800 Frequency Radios GRAND TOTAL - WATER DEPRECIATION SPENDING ILAST BUDGET AMOUNT, DEPRECIATION FUND UP OR (DOWN) 31,524 Account Budget 163,000 4,000 10,000 2,500 4.000 1,000 3.000 274,645 2001 Water Budget.xls 26 10/25/2000 2001 Water Budget 2001 2000 1999 1998 1997 WATFR UTILITY COMPARISONS GRAND TOTAL OPERATION & DEPRECIATION GRAND TOTAL OPERATION & DEPRECIATION GRAND TOTAL OPERATION & DEPRECIATION GRAND TOTAL OPERATION & DEPRECIATION GRAND TOTAL OPERATION & DEPRECIATION $2,802,566 $2,695,027 $2,249.685 $2,047,341 OPERATION FXPENSES 2001 TOTAL OPERATING EXPENSE 2000 TOTAL OPERATING EXPENSE $2.627,921 $2,451,906 $76,015 2000 TO 2001 INCREASED 1999 TO 2000 iNCREASED 1998 TO 1999 INCREASED 1997 TO 1998 iNCREASED $76,015 $430,992 $106,739 17.58% 6.57% 6.87% DEPRECIATION SPENDING 2001 TOTAL DEPRECIATION 2000 TOTAL DEPRECIATION $274,645 $243,121 $31.524 2000 TO 2001INCREASED 1999 TO 2000INCREASED 1998 TO 1999 DECREASED 1997 TO 1998 DECREASED $3%524 $14,350 ($18.635) ($8,781) 12.97% 5.90% -7.66% -3.44% OPERATION & DEPRECIATION 2001 TOTAL OPERATION & DEPRECIATION 2000 TOTAL OPERATION & DEPRECIATION 1999 TOTAL OPERATION & DEPRECIATION 1998 TOTAL OPERATION & DEPRECIATION 1997 TOTAL OPERATION & OEpRECIATION 2000 TO 2001INCREASED 1999 TO 2000INCREASED 1998 TO 1999 INCREASED ~997 TO 1998 INCREASED $2,802,566 $2,695,027 $2,249,685 $2,047,341 $107,539 3.99% $445,342 19.80% $88,104 4.08% $114,240 5.58% ' 2001 Water Budget.xls 27 10/25/2000 2OO1 Water Budge! 2001 WATER pROJECTIONS 10/26/00 Water income: Computerized Sales Non-recurring Charges Sales for Resale Hydrant Rentals TOTAL iNCOME Less Required Transfer -Bond Interest & Princ. BEST BUDGET Interest Income MAXIMUM SAFE BUDGET Total Operating & Depreciation Budget Excess of Revenue Over Budget and Required Transfer $2,947,800 86,300 100,500 617,500 $3,752,100 501,879 $3,250,221 121,331 S3,371,552 2,802,566 $568,986 1012612000 2001 Water Budget WATER BUDGET FUNDABILITY Total Projected Operating Income Total 2001 Operating & Depreciation Budget 2001 Transfers to Bond & Interest Operating {Cash on Hand) (9/30/00) Depreciation (Cash on Hand) (9/30/00) Projected Cash on Hand 12/31/01 Operating and Depreciation Funds $3.752,100 2.802,566 501,879 $1,121,534 ~676,829 $2,246,018 The 2001 Operating and Depreciation Budget would be leas than available revenue. ESTIMATE OF INTEREST INCOME Balance on Hand (Projected Balance 1/1/01 ) Operating and Depreciation Funds Projected Ending Balance 12/31/01 Operating and Depreciation Funds Projected Average 2001 Balance Operating and Depreciation Funds Interest Income at rate of 6,0% $1,798,363 $2.246,018 ~2,022,191 ~121,331 10~26~2000