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 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 % |