WATER - Account Summary as of Jun 29, 2020

$ 141,648.02
Period
$ 1,212,144.99
Year-To-Date
$ 1,400,154.00
Budget
$ 188,009.01
Unexpended
Budget
Expenses
Account Summary
Account Name Account Period Year-to-Date Budget Unexpended Period at 99.04%
SALARIES AND WAGES 50-71-01 25,848.55 353,776.14 382,291.00 28,514.86 92.5
PART TIME WAGES 50-71-02 0.00 278.60 750.00 471.40 37.1
OVERTIME WAGES 50-71-03 4,525.24 41,692.13 60,000.00 18,307.87 69.5
INDUSTRIAL LEAVE WAGES 50-71-05 0.00 0.00 0.00 0.00 0.0
COMPENSATED ABSENCES 50-71-06 0.00 0.00 0.00 0.00 0.0
HEALTH EQUITY 50-71-07 44.46 519.91 1,000.00 480.09 52.0
MEDICAL INSURANCE 50-71-08 6,311.01 100,538.60 150,500.00 49,961.40 66.8
SOCIAL SECURITY (FICA) 50-71-09 2,231.97 29,898.49 34,054.00 4,155.51 87.8
WORKERS' COMPENSATION 50-71-10 803.12 10,955.27 12,866.00 1,910.73 85.1
OTHER EMP BENEFITS 50-71-11 0.00 19.67 96.00 76.33 20.5
RETIREMENT 50-71-12 3,670.41 47,491.65 46,393.00 (1,098.65) 102.4
SAFETY, DRUG TEST & PHYSICALS 50-71-14 0.00 35.00 100.00 65.00 35.0
EDUCATION AND TRAINING 50-71-15 50.87 657.94 1,000.00 342.06 65.8
UNIFORM ALLOWANCE 50-71-16 0.00 4,934.68 5,400.00 465.32 91.4
TRAVEL 50-71-17 0.00 0.00 2,500.00 2,500.00 0.0
DUES/SUBSCRIPTIONS/MEMBERSHIPS 50-71-18 55.50 100,694.13 110,000.00 9,305.87 91.5
CONTRACT LABOR 50-71-19 66.00 4,897.25 3,000.00 (1,897.25) 163.2
OTHER MATERIALS AND SUPPLIES 50-71-20 450.09 22,509.11 12,000.00 (10,509.11) 187.6
REPAIR/MAINTENANCE - EQUIPMENT 50-71-21 892.75 19,900.94 30,500.00 10,599.06 65.2
REPAIR/MAINTENANCE - BUILDING 50-71-22 0.00 883.93 1,000.00 116.07 88.4
REPAIR/MAINT-SIDEWALK/GROUNDS 50-71-23 35.35 35.35 500.00 464.65 7.1
REPAIR/MAINTENANCE - WATERLINE 50-71-24 0.00 0.00 8,000.00 8,000.00 0.0
LICENSES AND PERMITS 50-71-25 0.00 0.00 0.00 0.00 0.0
REPAIR/MAINTENANCE - VEHICLE 50-71-26 0.00 6,062.03 3,000.00 (3,062.03) 202.1
GASOLINE AND OIL 50-71-27 770.99 5,080.39 9,000.00 3,919.61 56.4
TELEPHONE 50-71-28 293.49 4,356.55 9,000.00 4,643.45 48.4
UTILITIES 50-71-29 346.83 125,931.51 140,000.00 14,068.49 90.0
OFFICE SUPPLIES 50-71-30 29.92 1,099.38 600.00 (499.38) 183.2
PRINTING 50-71-31 140.89 3,408.27 2,200.00 (1,208.27) 154.9
COMPUTER-TECHNICAL SUPPORT 50-71-32 231.98 9,251.60 8,000.00 (1,251.60) 115.6
ADVERTISING 50-71-33 0.00 946.44 0.00 (946.44) 0.0
ENGINEERING 50-71-34 2,880.00 33,159.26 17,500.00 (15,659.26) 189.5
LEGAL-SERVICES 50-71-35 0.00 1,087.50 12,000.00 10,912.50 9.1
ACCOUNTING & AUDITING 50-71-36 0.00 0.00 0.00 0.00 0.0
OTHER SERVICES 50-71-37 1,418.73 36,786.00 37,104.00 318.00 99.1
PUBLIC RELATIONS 50-71-38 0.00 0.00 0.00 0.00 0.0
ON-LINE BILL PAY 50-71-39 1,576.46 9,993.51 12,000.00 2,006.49 83.3
INSURANCE & BONDS 50-71-40 21,470.00 86,232.08 90,000.00 3,767.92 95.8
LEGAL FEES 50-71-41 0.00 0.00 0.00 0.00 0.0
BAD DEBT WRITE OFF 50-71-42 0.00 0.00 0.00 0.00 0.0
PROGRAM SUPPLIES 50-71-43 0.00 0.00 0.00 0.00 0.0
UNRESTRICTED CONTINGENCY 50-71-44 0.00 0.00 0.00 0.00 0.0
RESTRICTED CONTINGENCY 50-71-45 0.00 0.00 0.00 0.00 0.0
BANK FEES 50-71-46 0.00 0.00 0.00 0.00 0.0
PROFESSIONAL SERVICES 50-71-47 0.00 4,576.43 3,600.00 (976.43) 127.1
CHEMICALS 50-71-48 0.00 29,422.56 87,000.00 57,577.44 33.8
RENT - EQUIPMENT 50-71-50 0.00 0.00 0.00 0.00 0.0
PAYROLL PROCESSING 50-71-51 89.50 498.98 2,100.00 1,601.02 23.8
COMPUTER-TECHNICAL EQUIPMENT 50-71-52 0.00 600.24 0.00 (600.24) 0.0
CAPITAL IMPROVEMENTS 50-71-53 0.00 36,008.77 21,000.00 (15,008.77) 171.5
CAPITAL OUTLAY 50-71-54 0.00 0.00 0.00 0.00 0.0
CAPITAL OUTLAY - EQUIPMENT 50-71-55 0.00 0.00 0.00 0.00 0.0
CAPITAL OUTLAY - VEHICLES 50-71-56 0.00 0.00 0.00 0.00 0.0
WATER METERS REPLACE OLD 50-71-57 0.00 0.00 0.00 0.00 0.0
WATER METERS 50-71-58 0.00 0.00 0.00 0.00 0.0
WIFA SOLAR PRINCIPAL-2012 50-71-61 56,165.94 56,165.94 62,420.00 6,254.06 90.0
WIFA SOLAR INTEREST-2012 50-71-62 11,247.97 21,758.76 21,680.00 (78.76) 100.4
PRINCIPAL MESA WATER COMPANY 50-71-70 0.00 0.00 0.00 0.00 0.0
INTEREST - MESA WATER COMPANY 50-71-71 0.00 0.00 0.00 0.00 0.0
LOSS (GAIN) ON SALE OF ASSETS 50-71-72 0.00 0.00 0.00 0.00 0.0
DEPRECIATION 50-71-95 0.00 0.00 0.00 0.00 0.0
SALE OF ASSETS*GAIN/LOSS 50-71-96 0.00 0.00 0.00 0.00 0.0
Subtotals $ 141,648.02 $ 1,212,144.99 $ 1,400,154.00 $ 188,009.01 86.57 %
>