WATER - Account Summary as of Mar 19, 2021

$ 171,354.57
Period
$ 919,533.04
Year-To-Date
$ 1,471,000.00
Budget
$ 551,466.96
Unexpended
Budget
Expenses
Account Summary
Account Name Account Period Year-to-Date Budget Unexpended Period at 71.10%
SALARIES AND WAGES 50-71-01 28,040.26 234,178.69 385,000.00 150,821.31 60.8
PART TIME WAGES 50-71-02 438.28 3,789.36 4,300.00 510.64 88.1
OVERTIME WAGES 50-71-03 2,169.44 18,572.14 53,000.00 34,427.86 35.0
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 84.00 482.95 500.00 17.05 96.6
MEDICAL INSURANCE 50-71-08 2,873.44 44,161.52 119,000.00 74,838.48 37.1
SOCIAL SECURITY (FICA) 50-71-09 2,161.02 20,022.41 34,000.00 13,977.59 58.9
WORKERS' COMPENSATION 50-71-10 2,893.70 11,839.12 10,700.00 (1,139.12) 110.6
OTHER EMP BENEFITS 50-71-11 0.00 0.00 0.00 0.00 0.0
RETIREMENT 50-71-12 3,675.97 31,143.93 53,500.00 22,356.07 58.2
OPEB Expense 50-71-13 0.00 0.00 0.00 0.00 0.0
SAFETY, DRUG TEST & PHYSICALS 50-71-14 0.00 16.00 100.00 84.00 16.0
EDUCATION AND TRAINING 50-71-15 35.90 544.86 1,000.00 455.14 54.5
UNIFORM ALLOWANCE 50-71-16 620.39 3,085.31 4,400.00 1,314.69 70.1
TRAVEL 50-71-17 0.00 0.00 2,500.00 2,500.00 0.0
DUES/SUBSCRIPTIONS/MEMBERSHIPS 50-71-18 80,231.52 81,204.23 110,000.00 28,795.77 73.8
CONTRACT LABOR 50-71-19 0.00 6,000.00 3,000.00 (3,000.00) 200.0
OTHER MATERIALS AND SUPPLIES 50-71-20 2,463.31 28,482.89 20,000.00 (8,482.89) 142.4
REPAIR/MAINTENANCE - EQUIPMENT 50-71-21 126.26 2,944.52 28,000.00 25,055.48 10.5
REPAIR/MAINTENANCE - BUILDING 50-71-22 11.56 147.50 1,000.00 852.50 14.8
REPAIR/MAINT-SIDEWALK/GROUNDS 50-71-23 0.00 0.00 0.00 0.00 0.0
REPAIR/MAINTENANCE - WATERLINE 50-71-24 0.00 155.36 15,000.00 14,844.64 1.0
LICENSES AND PERMITS 50-71-25 0.00 0.00 0.00 0.00 0.0
REPAIR/MAINTENANCE - VEHICLE 50-71-26 490.61 5,302.02 5,000.00 (302.02) 106.0
GASOLINE AND OIL 50-71-27 485.22 5,210.34 9,000.00 3,789.66 57.9
TELEPHONE 50-71-28 433.28 4,166.11 5,000.00 833.89 83.3
UTILITIES 50-71-29 14,331.54 107,938.21 125,000.00 17,061.79 86.4
OFFICE SUPPLIES 50-71-30 28.69 145.62 1,000.00 854.38 14.6
PRINTING 50-71-31 92.34 1,526.73 3,500.00 1,973.27 43.6
COMPUTER-TECHNICAL SUPPORT 50-71-32 160.17 4,958.98 8,000.00 3,041.02 62.0
ADVERTISING 50-71-33 0.00 414.91 500.00 85.09 83.0
ENGINEERING 50-71-34 0.00 0.00 20,000.00 20,000.00 0.0
LEGAL-SERVICES 50-71-35 0.00 0.00 0.00 0.00 0.0
ACCOUNTING & AUDITING 50-71-36 0.00 0.00 0.00 0.00 0.0
OTHER SERVICES 50-71-37 967.91 17,940.97 30,000.00 12,059.03 59.8
PUBLIC RELATIONS 50-71-38 0.00 0.00 0.00 0.00 0.0
ON-LINE BILL PAY 50-71-39 0.00 1,594.61 12,000.00 10,405.39 13.3
INSURANCE & BONDS 50-71-40 24,336.76 73,676.52 90,000.00 16,323.48 81.9
LEGAL SERVICES 50-71-41 0.00 0.00 0.00 0.00 0.0
BAD DEBT WRITE OFF 50-71-42 0.00 495.24 0.00 (495.24) 0.0
PROGRAM SUPPLIES 50-71-43 0.00 0.00 10,000.00 10,000.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 25,619.75 0.00 (25,619.75) 0.0
CHEMICALS 50-71-48 4,203.00 33,224.49 40,000.00 6,775.51 83.1
RENT - EQUIPMENT 50-71-50 0.00 0.00 0.00 0.00 0.0
PAYROLL PROCESSING 50-71-51 0.00 0.00 1,000.00 1,000.00 0.0
COMPUTER-TECHNICAL EQUIPMENT 50-71-52 0.00 0.00 1,000.00 1,000.00 0.0
CAPITAL IMPROVEMENTS 50-71-53 0.00 453.75 0.00 (453.75) 0.0
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 25,000.00 25,000.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
OFFICE & COMPUTER EQUIPMENT 50-71-59 0.00 0.00 0.00 0.00 0.0
C/O-LAY*O/OVER - 1,000 50-71-60 0.00 0.00 0.00 0.00 0.0
WIFA SOLAR PRINCIPAL-2012 50-71-61 0.00 57,640.30 64,000.00 6,359.70 90.1
WIFA SOLAR INTEREST-2012 50-71-62 0.00 10,510.79 20,000.00 9,489.21 52.6
MESA ORANGE GROVE WIFA-2016 50-71-64 0.00 28,062.20 29,000.00 937.80 96.8
MESA ORANGE GROVE INTEREST 50-71-65 0.00 3,626.69 7,000.00 3,373.31 51.8
WATER METER LOAN 920245-14 50-71-66 0.00 40,113.13 40,000.00 (113.13) 100.3
WATER METER INT-2014 50-71-67 0.00 10,140.89 20,000.00 9,859.11 50.7
PRINCIPAL MESA WATER COMPANY 50-71-70 0.00 0.00 30,000.00 30,000.00 0.0
INTEREST - MESA WATER COMPANY 50-71-71 0.00 0.00 30,000.00 30,000.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 $ 171,354.57 $ 919,533.04 $ 1,471,000.00 $ 551,466.96 62.51 %
>