|
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 21-22
<br />FY 22-23
<br />FY 23-24
<br />FY 24-25
<br />61000 Salaries Regular
<br />1,088,640
<br />1,324,076
<br />1,606,080
<br />2,012,780
<br />61010 Salaries Cash Out/Separation
<br />14,046
<br />0
<br />0
<br />2,170
<br />61020 Salaries Part -Time
<br />101,784
<br />109,915
<br />126,760
<br />125,570
<br />61040 Salaries Overtime
<br />361,659
<br />435,708
<br />370,000
<br />385,000
<br />61100 Retirement -Employer Normal Cost
<br />65,840
<br />74,768
<br />146,480
<br />192,080
<br />61102 Retirement- Employer Unfunded- Miscellaneous
<br />233,815
<br />173,343
<br />130,880
<br />254,510
<br />61110 Part -Time Retirement
<br />2,846
<br />2,900
<br />4,750
<br />4,710
<br />61120 Medicare Insurance
<br />21,534
<br />25,667
<br />25,080
<br />30,930
<br />61130 Health Insurance
<br />199,126
<br />239,926
<br />355,140
<br />465,130
<br />61170 Retiree Health Benefits
<br />929
<br />1,136
<br />1,420
<br />19,610
<br />61180 Worker Compensation Insurance
<br />63,590
<br />83,325
<br />68,450
<br />73,630
<br />2,153,809
<br />2,470,764
<br />2,835,040
<br />3,566,120
<br />SUBTOTAL SALARIES & BENEFITS
<br />62000 Utilities
<br />2,857,459
<br />3,002,952
<br />3,240,000
<br />3,240,000
<br />62010 Communications
<br />43,899
<br />56,551
<br />18,400
<br />22,510
<br />62120 Training, Transportation, Meetings
<br />15,775
<br />50,819
<br />66,400
<br />30,000
<br />62140 Membership, Subscription & Dues
<br />202,303
<br />215,194
<br />230,000
<br />75,000
<br />62300 Contract Services -Professional
<br />16,366,918
<br />17,617,001
<br />22,206,400
<br />20,332,000
<br />62320 Maintenance & Repair Buildings
<br />0
<br />0
<br />150,000
<br />0
<br />62321 Maintenance & Repair Improveme
<br />37,224
<br />0
<br />20,000
<br />20,000
<br />62322 Maintenance & Repair Machinery
<br />4,400
<br />8,405
<br />5,000
<br />5,000
<br />62500 Rent Payments
<br />0
<br />0
<br />464,800
<br />0
<br />19,527,976
<br />20,950,922
<br />26,401,000
<br />23,724,510
<br />SUBTOTAL CONTRACTUALS
<br />63001 Miscellaneous Operating Expenses
<br />10,007,148
<br />10,540,310
<br />9,824,350
<br />9,719,350
<br />63300 Gas & Diesel
<br />40,484
<br />53,922
<br />30,360
<br />30,360
<br />63302 Alternative Fuel -Propane
<br />0
<br />0
<br />0
<br />70,000
<br />10,047,632
<br />10,594,232
<br />9,854,710
<br />9,819,710
<br />SUBTOTAL COMMODITIES
<br />65010 Rental City Equipment
<br />113,300
<br />135,451
<br />133,590
<br />150,290
<br />65011 Equipment Replacement Charges
<br />105,908
<br />25,017
<br />64,070
<br />81,760
<br />65012 Accident Repair & Replacement
<br />4,775
<br />5,493
<br />540
<br />1,180
<br />65020 City Yard Rental
<br />0
<br />0
<br />0
<br />292,540
<br />65040 IT Maintenance Charge
<br />69,960
<br />85,610
<br />91,300
<br />119,070
<br />65055 Communications- Landlines
<br />0
<br />0
<br />0
<br />16,580
<br />65100 Insurance Charges
<br />168,150
<br />249,975
<br />197,100
<br />237,550
<br />65105 Benefits Overhead
<br />3,780
<br />15,276
<br />12,340
<br />15,050
<br />65210 Delivery Charges
<br />790
<br />0
<br />0
<br />0
<br />65240 Public Works Administrative Ch
<br />0
<br />0
<br />0
<br />19,670
<br />65400 Indirect Costs
<br />468,650
<br />574,506
<br />678,380
<br />959,880
<br />935,313
<br />1,091,328
<br />1,177,320
<br />1,893,570
<br />SUBTOTAL FIXED CHARGES
<br />66400 Machinery & Equipment
<br />70,949
<br />270,799
<br />0
<br />0
<br />66511 Computer Software Subscriptions
<br />0
<br />0
<br />0
<br />39,000
<br />70,949
<br />270,799
<br />0
<br />39,000
<br />SUBTOTAL CAPITAL
<br />67200 Principal -Leases
<br />0
<br />0
<br />10,920
<br />35,700
<br />67301 POB Principal -Mist
<br />0
<br />22,326
<br />7,660
<br />16,270
<br />67311 POB Interest- Misc
<br />33,195
<br />40,735
<br />40,720
<br />53,340
<br />33,195
<br />63,060
<br />59,300
<br />105,310
<br />SUBTOTAL DEBT SERVICE
<br />424
<br />
|