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