WATER - Account Summary as of Nov 27, 2020

$ 128,437.29
Period
$ 566,658.77
Year-To-Date
$ 2,036,900.00
Budget
$ 1,470,241.23
Unexpended
Budget
Expenses
Account Summary
Account Name Account Period Year-to-Date Budget Unexpended Period at 39.89%
SALARIES AND WAGES 50-71-01 0.00 96,837.10 385,000.00 288,162.90 25.2
PART TIME WAGES 50-71-02 0.00 1,308.77 4,300.00 2,991.23 30.4
OVERTIME WAGES 50-71-03 0.00 7,589.59 53,000.00 45,410.41 14.3
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 0.00 129.73 500.00 370.27 25.9
MEDICAL INSURANCE 50-71-08 0.00 21,423.19 119,000.00 97,576.81 18.0
SOCIAL SECURITY (FICA) 50-71-09 0.00 7,828.40 34,000.00 26,171.60 23.0
WORKERS' COMPENSATION 50-71-10 0.00 6,084.66 10,700.00 4,615.34 56.9
OTHER EMP BENEFITS 50-71-11 0.00 0.00 0.00 0.00 0.0
RETIREMENT 50-71-12 0.00 12,630.68 53,500.00 40,869.32 23.6
OPEB Expense 50-71-13 0.00 0.00 0.00 0.00 0.0
SAFETY, DRUG TEST & PHYSICALS 50-71-14 0.00 0.00 200.00 200.00 0.0
EDUCATION AND TRAINING 50-71-15 0.00 159.94 2,000.00 1,840.06 8.0
UNIFORM ALLOWANCE 50-71-16 620.39 2,371.98 9,900.00 7,528.02 24.0
TRAVEL 50-71-17 0.00 0.00 4,500.00 4,500.00 0.0
DUES/SUBSCRIPTIONS/MEMBERSHIPS 50-71-18 80,231.52 80,759.81 245,000.00 164,240.19 33.0
CONTRACT LABOR 50-71-19 0.00 6,000.00 6,000.00 0.00 100.0
OTHER MATERIALS AND SUPPLIES 50-71-20 2,463.31 16,394.92 40,000.00 23,605.08 41.0
REPAIR/MAINTENANCE - EQUIPMENT 50-71-21 126.26 1,634.90 56,000.00 54,365.10 2.9
REPAIR/MAINTENANCE - BUILDING 50-71-22 11.56 104.15 2,000.00 1,895.85 5.2
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 37.97 30,000.00 29,962.03 0.1
LICENSES AND PERMITS 50-71-25 0.00 0.00 0.00 0.00 0.0
REPAIR/MAINTENANCE - VEHICLE 50-71-26 490.61 4,598.78 9,500.00 4,901.22 48.4
GASOLINE AND OIL 50-71-27 0.00 0.00 17,000.00 17,000.00 0.0
TELEPHONE 50-71-28 383.28 2,326.28 10,000.00 7,673.72 23.3
UTILITIES 50-71-29 14,331.54 60,429.78 250,000.00 189,570.22 24.2
OFFICE SUPPLIES 50-71-30 18.64 48.57 2,000.00 1,951.43 2.4
PRINTING 50-71-31 92.34 919.02 7,000.00 6,080.98 13.1
COMPUTER-TECHNICAL SUPPORT 50-71-32 160.17 4,384.55 16,000.00 11,615.45 27.4
ADVERTISING 50-71-33 0.00 38.07 800.00 761.93 4.8
ENGINEERING 50-71-34 0.00 0.00 40,000.00 40,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 11,302.80 69,000.00 57,697.20 16.4
PUBLIC RELATIONS 50-71-38 0.00 0.00 0.00 0.00 0.0
ON-LINE BILL PAY 50-71-39 0.00 583.34 22,000.00 21,416.66 2.7
INSURANCE & BONDS 50-71-40 24,336.76 48,508.04 177,000.00 128,491.96 27.4
LEGAL SERVICES 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 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 0.00 3,000.00 3,000.00 0.0
CHEMICALS 50-71-48 4,203.00 21,676.00 80,000.00 58,324.00 27.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 2,000.00 2,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 $ 128,437.29 $ 566,658.77 $ 2,036,900.00 $ 1,470,241.23 27.81 %
>