|
WATER REVENUE
<br />PUBLIC WORKS ACCOUNTING UNIT
<br />WATER UTY WTR PROD & SUPPLY 06017640
<br />Account
<br />ACTUAL
<br />ACTUAL
<br />ADOPTED
<br />PROPOSED
<br />Code LINE ITEM RESOURCES
<br />FY 19-20
<br />FY 20-21
<br />FY 21-22
<br />FY 22-23
<br />61000 Salaries Regular
<br />631,271
<br />725,835
<br />1,254,410
<br />1,401,560
<br />61010 Salaries Cash Out/Separation
<br />0
<br />12,556
<br />0
<br />0
<br />61020 Salaries Part -Time
<br />38,547
<br />56,442
<br />119,20C
<br />119,200
<br />61040 Salaries Overtime
<br />202,040
<br />246,263
<br />230,000
<br />370,000
<br />61100 Retirement -Employer Normal Cost
<br />26,851
<br />40,945
<br />104,320
<br />106,200
<br />61101 Retirement - Employer Unfunded
<br />162,367
<br />0
<br />0
<br />0
<br />61102 Retirement- Employer Unfunded- Miscellaneous
<br />0
<br />207,149
<br />222,240
<br />109,120
<br />61110 Part -Time Retirement
<br />1,445
<br />2,068
<br />4,500
<br />5,580
<br />61120 Medicare Insurance
<br />11,817
<br />14,373
<br />19,850
<br />22,450
<br />61130 Health Insurance
<br />98,389
<br />108,971
<br />305,080
<br />317,950
<br />61170 Retiree Health Benefits
<br />0
<br />176
<br />1,300
<br />1,330
<br />61180 Worker Compensation Insurance
<br />80,834
<br />67,860
<br />63,590
<br />46,880
<br />1,253,561
<br />1,482,638
<br />2,324,490
<br />2,500,270
<br />SUBTOTAL SALARIES & BENEFITS
<br />62000 Utilities
<br />2,026,676
<br />2,415,416
<br />2,990,000
<br />2,990,000
<br />62010 Communications
<br />48,673
<br />35,952
<br />52,200
<br />53,240
<br />62120 Training, Transportation, Meetings
<br />12,627
<br />11,937
<br />59,000
<br />59,400
<br />62140 Membership, Subscription & Dues
<br />153,697
<br />153,682
<br />260,000
<br />215,000
<br />62300 Contract Services -Professional
<br />14,112,338
<br />16,585,060
<br />20,526,200
<br />22,206,400
<br />62320 Maintenance & Repair Buildings
<br />33,462
<br />33,916
<br />50,000
<br />150,000
<br />62321 Maintenance & Repair Improveme
<br />0
<br />44,505
<br />20,000
<br />20,000
<br />62322 Maintenance & Repair Machinery
<br />1,260
<br />3,005
<br />15,000
<br />5,000
<br />62500 Rent Payments
<br />0
<br />0
<br />0
<br />464,800
<br />16,388,733
<br />19,283,473
<br />23,972,400
<br />26,163,840
<br />SUBTOTAL CONTRACTUALS
<br />63001 Miscellaneous Operating Expenses
<br />9,665,286
<br />9,903,436
<br />11,463,300
<br />10,824,350
<br />63300 Gas & Diesel
<br />31,158
<br />31,781
<br />30,360
<br />30,360
<br />9,696,444
<br />9,935,218
<br />11,493,660
<br />10,854,710
<br />SUBTOTAL COMMODITIES
<br />65010 Rental City Equipment
<br />91,783
<br />44,100
<br />85,200
<br />108,130
<br />65011 Equipment Replacement Charges
<br />89,512
<br />30,300
<br />80,620
<br />29,890
<br />65012 Accident Repair & Replacement
<br />3,660
<br />1,600
<br />4,800
<br />540
<br />65040 IT Maintenance Charge
<br />73,189
<br />73,190
<br />69,960
<br />85,610
<br />65100 Insurance Charges
<br />139,700
<br />177,810
<br />168,150
<br />141,070
<br />65105 Benefits Overhead
<br />0
<br />3,200
<br />3,780
<br />8,560
<br />65210 Delivery Charges
<br />786
<br />790
<br />790
<br />0
<br />65400 Indirect Costs
<br />93,312
<br />269,932
<br />363,100
<br />469,590
<br />491,943
<br />600,922
<br />776,400
<br />843,390
<br />SUBTOTAL FIXED CHARGES
<br />66400 Machinery & Equipment
<br />544,692
<br />299,477
<br />1,207,000
<br />1,440,000
<br />66510 Computer Software
<br />31
<br />0
<br />0
<br />0
<br />544,722
<br />299,477
<br />1,207,000
<br />1,440,000
<br />SUBTOTAL CAPITAL
<br />67200 Principal -Leases
<br />0
<br />0
<br />20,800
<br />20,800
<br />67301 POB Principal -Mist
<br />0
<br />0
<br />0
<br />22,330
<br />67311 POB Interest - Misc
<br />0
<br />0
<br />0
<br />40,760
<br />0
<br />0
<br />20,800
<br />83,890
<br />SUBTOTAL DEBT SERVICE
<br />489
<br />
|