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