HomeMy WebLinkAboutUtiliy fund summaryUtility Fund
Program Summary
Fiscal Year 2010/2011
Revision
3
21. PR Increase
H.m Adopted ( Estimated Proposed
Actual Budget Budget, Budget
FY 08/09 } m FY 09/10 w FY 09/10 FY 10/11
;REVENUES & OTHER SOURCES
General Sales Tax
Charges for Services _ I 2,345,724E 2520,16 j 2,359,166 S 2,417166
Contnbutions m
Franchise Fees
Permits & Fees M
Intergovermental ;
? Fines & Forfeitures
s- Investment Earnings 7,858 € 3,600 i 5,350 # 1,600 'I
Misc Income 74,866 8,000 � 38,000 8,000 ;
;Total Revenues 1 2,428,448 2,531,766 2,402,516 1 2,426,766
Transfers In j
=Total Other Sources P 1
�it)T:ri% #�EifE1+11185 C3�t�Ei� ;SUtT1tCES .:. P � 428 4�$ � :... 2,�a31,766 t.� 2 4512,5 d t ... 420d�i Pt
vision 2,428,448.00 2,531,766.00 2,402,516.00 2,426,766.00
variance
EXPENDITURES & OTHER USES _
Payroll /Salaries �! 149,T44 ; 169 119 170,121
�____n._®.. _....
Payroll Related & Benefits i 47,041 55,165 55,942 -
- Supplies _ n 4,948 _H 7,717 1 7,667 66
7,7
._ _. W
Services 1,233,842w 1,415,544q 1,486,8921 486,749
Insurance 6,132 6,439 51714 1 5 886 1
Repair & Maintenance 81,278 83,400 95,500 ' 95,500
-Rent & Utilities 95 527 1 1 1 805 110,375 110,375
375
Debt 150,645 274,904 195,784 253,784
Capital Outlay E 68,971 59,000 59,000 59,0 00 ;
#( Economic Development Incentives I+ _
Capital Projects 20 497 605,000 360,000 j 248,9
.Total Expenditures 1,858,526 ; 2,788,093 2,546,995 2,267,881
Transfers Out - Payroll ( 227,292
Transfers Out t 42 5
Impact E 76 321 i 100 I 62,500 18,000
T{3TAi0
fX1'1"1Ti1Tt3RE5 CiTFtE USES T 934 76,321 847 142 500 62,500
245 292
B
E
l 1
vision 1,934,847 2,930,593 2,609,495 2,513,173
variance - - - -
t ....;.`:;.493 Gtit 3ss,827::20619)x �
:ES;F�f4lt15 �iVER�itI1�i8�� EP�AiTd1i�1RE,
REVENUES
vision link 2,426,766
External Description
Account Object
Department No
Description
Charge for Service
34,410
16
Water Revenue
1,800,000
Charge for Service
34,411
16
DS - Hillwood Service Area
54,000
Charge for Service
34,412
16
DS - Town Service Area Accts
54,000
Charge for Service
34,413
16
Waste Management
6,966
Charge for Service
34,420
16
Sewer Revenue - Westlake
440,000
Charge for Service
34,421
16
Sewer Revenue - Keller
1,200
Charge for Service
34,430
16
Water Tap Fees
10,000
Charge for Service
34,440
16
Sewer Tap Fees
6,000
Charge for Service
34,450
16
Fort Worth Impact fees
40,000
Charge for Service
34,470
16
Meter Repair & Replacement
5,000
Interest
36,110
16
Interest Income
1,600
Misc Income
36,200
16
Duct Bank Leases
0
Misc Income
36,201
16
TRA Wastewater Settle -Up
0
Misc Income
39,100
16
Insurance Refund /Equity Return
4,000
Misc Income
39,400
16
Misc Revenue
4,000
Fund 500
Utility Fund
EXPENSES
External Description Account Object Department No Description
vision link
Service
43,220
16 Water Utility Engineering
6,000
Service
43,250
16 Auditor
0
Service
43,310
16 Boyle & Lowry
0
Supplies
43,405
16 Computer Eqpmt /Software
0
Service
44,105
16 Water Purchases
3,000
Service
44,106
16 Water Service Charge
0
Service
44,110
16 Peak Payment
500
R &M
44,111
16 WaterTower Landscape R &M
0
R &M
44,112
16 Water Main R &M
0
R &M
44,113
16 Tower R &M
600
R &M
44,114
16 Sewer Main R &M
0
Service
44,115
16 TRA- Wastewater Treatment
70,000
R &M
44,116
16 Pump Station Landscape R &M
0
R &M
44,117
16 Lift Station R &M
500
R &M
44,118
16 Instrument R &M
0
R &M
44,119
16 Ground Storage Tank R &M
500
Service
44,120
16 South Iake- Wastewater Treatment
0
R &M
44,121
16 Generator R &M
400
Service
44,122
16 Testing- Water /Bacteria /Rgltry
0
R &M
44,123
16 Pump Station R &M
0
R &M
44,124
16 Duct Bank R &M
0
R &M
44,130
16 Meter Repair & Replacement
0
Service
44,135
16 Utility Billing
0
Supplies
44,211
16 Safety Supplies
0
Service
44,220
16 Line Location
0
Supplies
44,226
16 Misc Hand Tools
1,000
Supplies
44,227
16 Chemical Supplies
0
Service
44,310
16 Application Software Maint.
0
Service
44,312
16 Keller Waste Water
0
Rent & Utilities
44,410
10 Office Rent
0
Insurance
45,214
10 Insurance Automobile
23,000
Insurance
45,215
10 Insurance Property
35,000
Rent & Utilities
45,305
10 Telephone Service
0
Service
45,310
16 Mobile Phone
0
Rent & Utilities
45,315
10 Internet Expense
0
Service
45,325
16 Misc Rental /Lease
0
Service
45,805
16 Travel Airfare
0
Service
45,810
16 Travel Car Rental /Parking
0
Service
45,815
16 Travel Lodging
29,731
Service
45,820
16 Travel Meals
0
Service
45,830
16 Training /Seminars /Meetings
75,303
Supplies
46,105
16 Office Supplies
C
Service
46,115
16 Dues & Subscriptions
40,75C
Page 3 Of 12
vision link 2,264,253
External Description
Account Object
Department No Description
Supplies
46,120
16 Postage & Shipping
0
Service
46,125
16 Printing
54,000
Service
46,145
16 Courier Service
0
Supplies
46,190
16 Misc. Expense
54,000
Rent & Utilities
46,205
10 Water Service
0
Rent & Utilities
46,206
16 Water - Pump Station
0
Supplies
46,215
16 Vehicle Fuel
0
R &M
46,216
16 Vehicle R &M
0
Rent & Utilities
46,220
10 Electric Service
0
Rent & Utilities
46,221
16 Electric - Pump Station
0
Rent & Utilities
46,223
16 Electric - Lift Station
0
Rent & Utilities
46,225
10 Gas Service
0
Supplies
46,605
16 Uniforms
0
Capital Outlay
47,411
16 Mechanical Equipment
0
Capital Outlay
47,420
16 Water Meters /Equipment
0
Capital Outlay
47,421
16 Water Taps
0
Debt
48,806
16 IFA Debt Pymt to 4B
18,000
Debt
48,810
16 DS - Keller OHS Principal
227,292
Debt
48,811
16 DS - Keller OHS Interest
0
Debt
48,820
16 DS - Hillwood Service Area
0
Debt
48,821
16 DS - Town Service Area Accts
0
62,510
99 Transfer Out to GF
0
62,511
99 Payroll Transfer Out to GF
0
Adopted Budget
External Description Account Formatted Description Amount
Charge for Service
500- 34410 -16 -00
Water Revenue
(1,800,000.00)
Charge for Service
500- 34411 -16 -00
DS - Hillwood Service Area
(54,000.00)
Charge for Service
500 - 34412 -16 -00
DS - Town Service Area Accts
(54,000.00)
Charge for Service
500- 34413 -16 -00
Waste Management
(6,966.00)
Charge for Service
500 - 34420 -16 -00
Sewer Revenue - Westlake
(440,000.00)
Charge for Service
500 - 34421 -16 -00
Sewer Revenue - Keller
(1,200.00)
Charge for Service
500- 34430 -16 -00
Water Tap Fees
(10,000.00)
Charge for Service
500 - 34440 -16 -00
Sewer Tap Fees
(6,000.00)
Charge for Service
500- 34450 -16 -00
Fort Worth Impact fees
(40,000.00)
Charge for Service
500 - 34470 -16 -00
Meter Repair & Replacement
(5,000.00)
Interest
500 - 36110 -16 -00
Interest Income
(1,600.00)
Misc Income
500 - 39100 -10 -00
Insurance Refund /Equity Return
(4,000.00)
Misc Income
500 - 39400 -16 -00
Misc Revenue
(4,000.00)
Total Revenues
(2,426,766.00);
Transfers Out 500 - 62510 -99 -00 Transfer Out to GF 18,000.00
Transfers Out 500 - 62511 -99 -00 Payroll Transfer Out to GF 227,292.00
Total 'transfers Out 245,292.00
Project 500 - 16600 -00 -00 -00003 Bud -N1 Sewer Line Transfer 127,000.00
Project 500 - 16600 -00 -00 -00003 Bud -N1 Sewer Line Xfr I &I Rep 121,920.00
Total Capital Projects 248,820.00