Full Text
CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 1 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget WATER UTILITY FUND DEPRECIATION 610-4020-990 DEPRECIATION 325,[PHONE REDACTED]-992 DEPREC ON CONTRIBUTED PLANT 133,000 Total DEPRECIATION: 458,000 TAXES 610-4080-990 TAXES 400,000 Total TAXES: 400,000 JOBBING REVENUES 610-4150-00 REVENUES FROM JOBBING 0 Total JOBBING REVENUES: 0 INTEREST & MISCELLANEOUS REV 610-4210-00 CONTRIBUTIONS IN AID OF CONST 0 610-4250-00 AMORTIZATION OF PSC LIABILITY 0 610-4290-00 INTEREST & DIVIDEND INCOME 0 610-4291-00 MISCELLANEOUS INCOME 0 Total INTEREST & MISCELLANEOUS REV: 0 WATER SALES REVENUE 610-4611-00 METERED SALES-RESIDENTIAL 0 610-4612-00 METERED SALES-COMMERCIAL 0 610-4613-00 METERED SALES-INDUSTRIAL 0 610-4620-00 PRIVATE FIRE PROTECTION 0 610-4630-00 PUBLIC FIRE PROTECTION 0 610-4640-00 OTHER SALES TO PUBLIC AUTHO 0 Total WATER SALES REVENUE: 0 ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 2 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget MISCELLANEOUS REVENUES (Cont.) 610-4701-00 FORFEITED DISCOUNTS 0 610-4710-00 MISC SERVICE REVENUE 0 610-4720-00 RENT FROM WATER PROPERTY 0 610-4740-00 OTHER OPERATING REVENUE 0 Total MISCELLANEOUS REVENUES: 0 SOURCE OF SUPPLY 610-6160-110 SALARIES-FULL-TIME 43,[PHONE REDACTED]-135 LONGEVITY 6,[PHONE REDACTED]-192 RETIREMENT 0 610-6160-193 FICA 0 610-6160-220 SUPPLIES & EXPENSES 11,[PHONE REDACTED]-410 MAINTENANCE 1,000 Total SOURCE OF SUPPLY: 62,271 PUMPING 610-6162-110 SALARIES-FULL-TIME 2,[PHONE REDACTED]-192 RETIREMENT 0 610-6162-193 FICA 0 610-6162-210 PURCHASED POWER 220,[PHONE REDACTED]-220 SUPPLIES & EXPENSES 1,[PHONE REDACTED]-410 MAINTENANCE 4,764 Total PUMPING: 228,309 WATER TREATMENT 610-6163-110 SALARIES-FULL-TIME 2,[PHONE REDACTED]-192 RETIREMENT 0 610-6163-193 FICA 0 610-6163-220 SUPPLIES & EXPENSES 15,[PHONE REDACTED]-230 CHEMICALS 25,[PHONE REDACTED]-410 MAINTENANCE 7,500 Total WATER TREATMENT: 49,500 TRANSMISSION & DISTRIBUTION 610-6164-110 SALARIES-FULL-TIME 181,[PHONE REDACTED]-192 RETIREMENT 0 ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 3 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget 610-6164-193 FICA 0 610-6164-220 SUPPLIES & EXPENSES 16,[PHONE REDACTED]-410 MAINT (DO NOT USE) 0 610-6164-411 MAINT - RESERVOIRS & STANDPIP 2,[PHONE REDACTED]-412 MAINT - MAINS 50,[PHONE REDACTED]-413 MAINT - SERVICES 6,[PHONE REDACTED]-414 MAINT - METERS 4,[PHONE REDACTED]-415 MAINT - HYDRANTS 15,000 Total TRANSMISSION & DISTRIBUTION: 276,918 CUSTOMER ACCOUNT EXPENSE 610-6190-110 SALARIES-FULL-TIME 30,[PHONE REDACTED]-130 ACCTG & CLTG LABOR 4,[PHONE REDACTED]-192 RETIREMENT 0 610-6190-193 FICA 0 610-6190-220 SUPPLIES & EXPENSES 10,342 Total CUSTOMER ACCOUNT EXPENSE: 45,946 ADMINISTRATIVE & GENERAL 610-6192-110 SALARIES-FULL-TIME 27,[PHONE REDACTED]-190 FRINGE BENEFITS-OTHER 0 610-6192-192 RETIREMENT 20,[PHONE REDACTED]-193 FICA 23,[PHONE REDACTED]-194 HEALTH INSURANCE 58,[PHONE REDACTED]-195 DENTAL INSURANCE 9,[PHONE REDACTED]-210 OFFICE SUPPLIES 5,[PHONE REDACTED]-222 PROPERTY INSURANCE 10,[PHONE REDACTED]-224 REGULATORY COMMISSION EXP 2,[PHONE REDACTED]-310 OUTSIDE SERVICES 40,[PHONE REDACTED]-320 TRANSPORTATION EXPENSES 32,[PHONE REDACTED]-410 MAINT - GENERAL PLANT 3,[PHONE REDACTED]-490 MISC GENERAL EXPENSES 15,[PHONE REDACTED]-990 GEN FUND COST RECOVERY 69,525 Total ADMINISTRATIVE & GENERAL: 315,727 INTEREST EXPENSE 610-6193-990 INTEREST ON DEBT TO MUNICIPA 0 Total INTEREST EXPENSE: 0 ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 4 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget OTHER EXPENSES 610-6195-998 TRANSFER TO DEBT FD 300 0 610-6195-999 TRANSFER OUT 0 Total OTHER EXPENSES: 0 WATER CAPITAL EXPENSES 610-6197-810 WELL REHAB & CONST (3140) 216,[PHONE REDACTED]-815 TRANSPORTATION EQUIP (3920) 81,[PHONE REDACTED]-820 WATER MAIN REPL (3430) 81,[PHONE REDACTED]-825 OTHER TRANSM & DIST (3490) 43,[PHONE REDACTED]-830 DIST RESERV & STANDPIPE (3420) 54,[PHONE REDACTED]-835 SCADA EQUIP (3971) 125,000 Total WATER CAPITAL EXPENSES: 600,200 WATER UTILITY FUND Revenue Total: 0 WATER UTILITY FUND Expenditure Total: 2,436,871 Total WATER UTILITY FUND: 2,436,871 ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 5 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget SEWER UTILITY FUND DEPRECIATION 620-4020-990 DEPRECIATION 275,000 Total DEPRECIATION: 275,000 TAXES 620-4080-990 TAXES 0 Total TAXES: 0 INTEREST & MISCELLANEOUS REV 620-4290-00 INTEREST & DIVIDEND INCOME 15,723- Total INTEREST & MISCELLANEOUS REV: 15,723- INTEREST ON DEBT 620-4300-990 INTEREST ON DEBT TO MUNICIPA 0 Total INTEREST ON DEBT: 0 AMORTIZATION 620-4380-990 AMORTIZATION OF BOND DISCOU 0 Total AMORTIZATION: 0 SEWER SALES REVENUE 620-4610-00 SEWERAGE SERVICE-RESIDENTIA 942,776- 620-4620-00 SEWERAGE SERVICE-COMMERCI 770,416- 620-4630-00 SEWERAGE SERVICE-INDUSTRIAL 164,960- 620-4640-00 REVENUES FROM PUBLIC AUTHO 36,516- ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 6 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget Total SEWER SALES REVENUE: 1,914,668- MISCELLANEOUS REVENUES 620-4820-00 FORFEITED DISCOUNTS 0 620-4850-00 MISCELLANEOUS OPERATING RE 0 Total MISCELLANEOUS REVENUES: 0 OPERATION EXPENSES 620-6282-110 SALARIES-FULL-TIME 27,[PHONE REDACTED]-135 LONGEVITY 4,[PHONE REDACTED]-192 RETIREMENT 0 620-6282-193 FICA 0 620-6282-220 SUPPLIES & EXPENSES 50,[PHONE REDACTED]-230 OTHER CHEMICALS FOR SEWERA [PHONE REDACTED]-320 TRANSPORTATION EXPENSES 20,[PHONE REDACTED]-330 MMSD FEES 1,550,[PHONE REDACTED]-420 POWER & FUEL - PUMPING 24,838 Total OPERATION EXPENSES: 1,677,626 MAINTENANCE EXPENSES 620-6283-110 SALARIES- FULL TIME 26,[PHONE REDACTED]-414 MAINT - METERS 3,[PHONE REDACTED]-415 MAINT - SEWAGE COLLECTION SY 25,[PHONE REDACTED]-416 MAINT - COLLECTION SYS PUMP E 15,[PHONE REDACTED]-417 MAINT - GEN PLANT STRUCT & EQ 3,000 Total MAINTENANCE EXPENSES: 72,986 CUSTOMER ACCOUNT EXPENSE 620-6284-110 METER READING LABOR 30,[PHONE REDACTED]-130 BILLING, COLLECT, ACCTG EXP 8,[PHONE REDACTED]-192 RETIREMENT 0 620-6284-193 FICA 0 Total CUSTOMER ACCOUNT EXPENSE: 38,000 ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 7 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget ADMINISTRATIVE & GENERAL 620-6285-110 SALARIES-FULL-TIME 70,[PHONE REDACTED]-190 FRINGE BENEFITS-OTHER 0 620-6285-192 RETIREMENT 22,[PHONE REDACTED]-193 FICA 13,[PHONE REDACTED]-194 HEALTH INSURANCE 33,[PHONE REDACTED]-195 DENTAL INSURANCE 5,[PHONE REDACTED]-210 OFFICE SUPPLIES 5,[PHONE REDACTED]-222 INSURANCE 0 620-6285-310 OUTSIDE SERVICES 7,[PHONE REDACTED]-490 MISC GENERAL EXPENSES 30,[PHONE REDACTED]-491 RENTS 12,[PHONE REDACTED]-990 GEN FUND COST RECOVERY 69,525 Total ADMINISTRATIVE & GENERAL: 269,386 OTHER EXPENSES 620-6286-998 TRANSFER TO DEBT FD 300 0 Total OTHER EXPENSES: 0 SEWER CAPITAL EXPENSES 620-6297-810 FORCE MAINS (3150) 750,[PHONE REDACTED]-815 MAIN REPL (3130) 162,000 Total SEWER CAPITAL EXPENSES: 912,000 SEWER UTILITY FUND Revenue Total: 1,930,391- SEWER UTILITY FUND Expenditure Total: 3,244,998 Total SEWER UTILITY FUND: 1,314,607 ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 8 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget GOLF COURSE FUND PUBLIC CHARGES FOR SERVICE 650-4630-00 GREENS FEES 972,581- 650-4632-00 MEMBERSHIPS 42,031- 650-4633-00 CART RENTAL 310,766- 650-4634-00 DRIVING RANGE 58,174- 650-4636-00 PLAYERS CARDS 0 650-4643-00 MISCELANEOUS REVENUE 3,000- 650-4645-00 SALES TAXES COLLECTED 76,260- Total PUBLIC CHARGES FOR SERVICE: 1,462,812- FOOD & BEVERAGE SALES 650-4736-00 FOOD INCOME 93,753- 650-4737-00 SNACK 13,186- 650-4738-00 LIQUOR 67,015- 650-4739-00 BEER 206,438- 650-4740-00 SODA 37,395- 650-4741-00 GOLF OUTING BEVERAGE 25,078- 650-4742-00 TOBACCO 0 650-4743-00 OTHER INCOME 0 650-4744-00 FOOD CART PAYMENT 0 650-4745-00 SALES TAXES COLLECTED 26,158- 650-4746-00 GOLF OUTING FOOD/SNACK 32,736- Total FOOD & BEVERAGE SALES: 501,759- OTHER INCOME 650-4832-01 TRANS/ADVANCE FROM GEN FD. 0 650-4832-03 CREDIT CARD REBATE PROGRAM 2,315- 650-4832-05 FOOD & OTHER REBATES 3,850- 650-4832-06 LAND SALE 0 Total OTHER INCOME: 6,165- REIMBURSEABLE INCOME 650-4935-00 TRANSFER IN 0 ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 9 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget Total REIMBURSEABLE INCOME: 0 FOOD & BEVERAGE EXPENSES 650-5541-221 FOOD COST 41,[PHONE REDACTED]-222 SNACK COST 6,[PHONE REDACTED]-223 LIQUOR COST 14,[PHONE REDACTED]-224 BEER COST 57,[PHONE REDACTED]-225 SODA COST 22,[PHONE REDACTED]-226 OTHER BEVERAGE COST 0 650-5541-227 TOBACCO COST 0 Total FOOD & BEVERAGE EXPENSES: 142,490 PRO SHOP 650-5543-110 SALARIES - FULL-TIME 128,[PHONE REDACTED]-120 PART TIME WAGES 97,[PHONE REDACTED]-135 LONGEVITY 2,[PHONE REDACTED]-190 FRINGE BENEFITS - PRO SHOP 0 650-5543-191 FRINGE BENEFITS PART TIME 0 650-5543-192 RETIREMENT 10,[PHONE REDACTED]-193 FICA 17,[PHONE REDACTED]-194 HEALTH INSURANCE 5,[PHONE REDACTED]-195 DENTAL INSURANCE [PHONE REDACTED]-199 EMPLOYEE HEALTH CONTRIB. 0 650-5543-229 PRO SHOP SUPPLIES 3,[PHONE REDACTED]-230 DRIVING RANGE SUPPLIES 5,[PHONE REDACTED]-420 GAS & OIL 15,[PHONE REDACTED]-441 CONFERENCES [PHONE REDACTED]-490 MISCELLANEOUS EXPENSE 2,[PHONE REDACTED]-492 CART RENTAL 12,[PHONE REDACTED]-493 GOLF OUTING EXPENSES 0 650-5543-494 CART LEASE PAYMENTS 40,[PHONE REDACTED]-495 CART ANNUAL MAINTENANCE 4,[PHONE REDACTED]-496 CART REPAIRS 3,[PHONE REDACTED]-520 HANDICAP EXPENSE 1,[PHONE REDACTED]-703 RESERVE 0 Total PRO SHOP: 350,609 CLUB HOUSE 650-5544-130 JANITORIAL SERVICES 1,[PHONE REDACTED]-145 UNEMPLOYMENT WAGES 8,[PHONE REDACTED]-220 SUPPLIES & MATERIALS 5,[PHONE REDACTED]-320 PEST CONTROL 280 ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 10 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget 650-5544-411 SHOP MAINTENANCE 0 650-5544-412 CLUB HOUSE MAINTENANCE 5,[PHONE REDACTED]-470 UTILITIES 51,[PHONE REDACTED]-510 SECURITY SYSTEM [PHONE REDACTED]-810 OTHER EQUIPMENT 0 Total CLUB HOUSE: 72,797 FOOD & BEVERAGE OTHER EXPENSES 650-5545-110 SALARIES - FOOD & BEVERAGE 31,[PHONE REDACTED]-111 SALARIES - FOOD & BEVERAGE L 61,[PHONE REDACTED]-135 LONGEVITY [PHONE REDACTED]-145 UNEMPLOYMENT WAGES 12,[PHONE REDACTED]-190 FRINGE BENEFITS - FOOD & BEVE 0 650-5545-192 RETIREMENT 3,[PHONE REDACTED]-193 FICA 8,[PHONE REDACTED]-194 HEALTH INSURANCE 14,[PHONE REDACTED]-195 DENTAL INSURANCE 2,[PHONE REDACTED]-199 EMPLOYEE HEALTH CONTRIB. 0 650-5545-222 FOOD & BEVERAGE SUPPLIES 8,[PHONE REDACTED]-310 OUTSIDE SERVICES 1,[PHONE REDACTED]-410 DO NOT USE 0 Total FOOD & BEVERAGE OTHER EXPENSES: 144,149 GROUNDS EXPENSES 650-5546-111 SALARIES - GOLF COURSE 259,[PHONE REDACTED]-120 PART TIME WAGES 82,[PHONE REDACTED]-135 LONGEVITY 5,[PHONE REDACTED]-145 UNEMPLOYMENT WAGES 1,[PHONE REDACTED]-190 FRINGE BENEFITS - GOLF COURS 0 650-5546-191 FRINGE BENEFITS PART TIME 0 650-5546-192 RETIREMENT 18,[PHONE REDACTED]-193 FICA 26,[PHONE REDACTED]-194 HEALTH INSURANCE 40,[PHONE REDACTED]-195 DENTAL INSURANCE 8,[PHONE REDACTED]-199 EMPLOYEE HEALTH CONTRIB. 0 650-5546-222 PARTS & TOOLS [PHONE REDACTED]-223 FERTILIZER & CHEMICALS 85,[PHONE REDACTED]-224 DIRT 16,[PHONE REDACTED]-274 GREENS & TEE SUPPLIES 6,[PHONE REDACTED]-275 SEED 1,[PHONE REDACTED]-276 DRAINAGE SUPPLIES 0 650-5546-277 IRRIGATION PARTS, EQUP, SUPL 3,[PHONE REDACTED]-278 TREES 1,[PHONE REDACTED]-279 OFFICE CLEANING SUPPLIES 1,[PHONE REDACTED]-370 GOOSE CONTROL SERVICES 0 650-5546-372 DEEP AERIFICATION SERVICES 2,000 ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 11 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget 650-5546-375 IRRIGATION CONTRACT 1,[PHONE REDACTED]-410 VEHICLE MAINTENANCE 0 650-5546-411 GROUNDS & GREEN MAINT [PHONE REDACTED]-412 GREEN EQUIPMENT REPAIR 32,[PHONE REDACTED]-420 GAS & OIL 22,[PHONE REDACTED]-440 TRAINING & DEVELOPMENT 1,[PHONE REDACTED]-450 UNIFORMS 1,[PHONE REDACTED]-491 EQUIPMENT RENTAL [PHONE REDACTED]-800 CAPITAL OUTLAY 114,965 Total GROUNDS EXPENSES: 738,177 ADMINISTRATION 650-5547-250 POSTAGE 57 650-5547-260 TELEPHONE 3,[PHONE REDACTED]-320 PROFESSIONAL SERVICES 0 650-5547-440 TRAINING 1,[PHONE REDACTED]-442 DUES 1,[PHONE REDACTED]-443 TRAVEL 0 650-5547-460 INSURANCE 0 650-5547-461 LICENSES [PHONE REDACTED]-521 ACCOUNTING & COMPUTERS 8,[PHONE REDACTED]-522 ADVERTISING 10,[PHONE REDACTED]-523 PRIOR YEARS EXPENSES 0 650-5547-990 OTHER EXPENSES 404 Total ADMINISTRATION: 25,123 DEBT EXPENSES 650-5548-701 PRINCIPAL 825,[PHONE REDACTED]-702 INTEREST 100,[PHONE REDACTED]-703 DEPRECIATION 115,[PHONE REDACTED]-704 SALES TAX - PD. 95,[PHONE REDACTED]-705 CREDIT CARD FEES 27,133 Total DEBT EXPENSES: 1,162,942 OTHER EXPENSES 650-5549-998 TRANSFER TO DEBT FD 300 0 650-5549-999 TRANSFER OUT 0 Total OTHER EXPENSES: 0 GOLF COURSE FUND Revenue Total: 1,970,736- GOLF COURSE FUND Expenditure Total: 2,636,287 ---PAGE BREAK--- CITY OF MIDDLETON 2015 FINAL/ADOPTED Page: 12 January 31, 2015 (01/15) Mar 16, 2015 07:36AM Account Final/Adopted Number Account Description Budget Total GOLF COURSE FUND: 665,551 Grand Totals: 4,417,029