10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE:
1
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
FINANCIAL SUMMARY
ACCT NO#
--------- 2012-2013 ---------
ACCT NAME
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
REVENUE SUMMARY --------------TAXES
3,245,218.92
3,233,533.47
3,122,800.85
3,172,201.54
3,044,012.92
28,786.90
22,010.77
16,500.00
23,021.51
14,250.00
120,995.72
29,925.76
30,300.00
65,196.27
57,682.90
CHARGES FOR SERVICES
26,824.59
18,031.92
20,900.00
15,440.53
8,900.00
RENTS & LEASES
23,024.12
8,550.00
8,800.00
12,349.71
8,800.00
FINES & FORFEITS
132,112.20
207,529.95
150,850.00
244,635.69
200,850.00
MISCELLANEOUS REVENUE
125,928.90
66,377.92
95,425.00
172,479.23
96,930.00
OTHER FINANCING SOURCES
926,192.47
1,329,512.91
1,163,287.00
1,139,848.18
1,259,815.08
-------------
-------------
-------------
-------------
-------------
4,629,083.82
4,915,472.70
4,608,862.85
4,845,172.66
4,691,240.90
82,518.69
151,753.25
267,380.00
264,427.94
199,543.73
ADMINISTRATIVE SERVICES
175,816.59
119,772.60
88,360.00
100,775.69
149,231.91
COMMUNITY DEVELOPMENT
340,593.71
303,108.22
320,835.73
295,132.81
335,758.21
PARKS & RECREATION
470,612.02
440,371.46
489,200.20
395,027.08
416,932.42
66,402.60
65,622.22
66,230.00
64,471.39
68,881.08
805,583.38
914,159.90
950,809.00
847,107.68
1,014,179.17
1,132,938.75
1,169,909.69
1,131,235.00
1,162,936.96
1,260,240.62
74,478.04
78,650.47
98,885.00
72,435.00
93,368.31
MUNICIPAL COURT
107,559.56
77,055.12
105,848.00
107,345.91
139,423.12
PUBLIC WORKS
375,511.26
367,505.78
398,265.00
397,754.81
421,023.42
GOVERNMENTAL AFFAIRS
491,227.26
465,987.67
430,365.49
683,735.22
440,220.00
73,762.48
68,881.41
58,930.76
57,045.36
67,430.00
8,884.14
8,670.00
12,100.00
10,990.00
10,100.00
-------------
-------------
-------------
-------------
-------------
LICENSES & PERMITS INTERGOVERNMENTAL REVENUE
** TOTAL REVENUE **
EXPENDITURE SUMMARY ------------------CITY MANAGER
ECONOMIC DEVELOPMENT FIRE & EMERGENCY SERVICES POLICE EMERGENCY MANAGEMENT
PUBLIC LIBRARY CITY COUNCIL
** TOTAL EXPENDITURES **
REVENUES OVER/(UNDER) EXPENDITURES
4,205,888.48
4,231,447.79
4,418,444.18
4,459,185.85
4,616,331.99
=============
=============
=============
=============
=============
423,195.34
684,024.91
190,418.67
385,986.81
74,908.91
=============
=============
=============
=============
=============
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE:
2
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
REVENUES --------- 2012-2013 ---------
ACCT NO#
ACCT NAME
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
TAXES ----30001
CURRENT PROPERTY TAXES
1,873,166.21
1,615,408.36
1,697,300.85
1,717,592.54
1,609,512.92
______________
30002
DELINQUENT PROPERTY TAXES
53,692.60
98,244.45
30,000.00
37,091.14
35,000.00
______________
30003
PENALTY & INT DELINQUENT TA
18,577.40
50,547.52
12,000.00
12,504.63
15,000.00
______________
30006
FRANCHISE TAX
525,155.22
639,585.44
600,000.00
565,386.91
600,000.00
______________
30007
OCCUPATIONAL TAX-ALCOLHOL B
120.00
120.00
2,500.00
3,387.00
3,500.00
______________
30008
OCCUPATIONAL TAX-MOBILE HOM
0.00
0.00
1,000.00
200.00
1,000.00
______________
30009
SALES TAX
764,994.99
819,568.44
775,000.00
825,881.52
775,000.00
______________
30010
MIXED DRINK TAX
9,512.50
10,059.26
5,000.00
10,157.80
5,000.00
______________
-------------
-------------
-------------
-------------
-------------
3,245,218.92
3,233,533.47
3,122,800.85
3,172,201.54
3,044,012.92
TOTAL TAXES
LICENSES & PERMITS -----------------31001
BUILDING PERMITS
20,019.40
9,520.77
6,000.00
12,946.51
6,000.00
______________
31002
PLUMBING PERMITS
1,925.00
3,220.00
3,000.00
1,840.00
2,000.00
______________
31003
ELECTRICAL PERMITS
1,052.50
1,690.00
1,000.00
1,077.50
500.00
______________
31010
OTHER LICENSE & PERMITS
2,215.00
2,525.00
2,000.00
2,957.50
2,000.00
______________
31011
MECHANICAL CODE PERMIT
175.00
1,105.00
1,000.00
850.00
250.00
______________
31012
ALARM PERMITS
3,400.00
3,950.00
3,500.00
3,350.00
3,500.00
______________
-------------
-------------
-------------
-------------
-------------
28,786.90
22,010.77
16,500.00
23,021.51
14,250.00
TOTAL LICENSES & PERMITS
INTERGOVERNMENTAL REVENUES -------------------------32700
HUNT COUNTY FIRE REIMBURSEM
28,800.00
28,800.00
28,800.00
29,757.95
28,800.00
______________
32705
EMERGENCY MGMT REIMBURSEMEN
17,195.72
1,125.76
1,500.00
35,438.32
28,882.90
______________
32710
PARKS & WILDLIFE REIMBURSE
______________
TOTAL INTERGOVERNMENTAL REVENUES
75,000.00
0.00
0.00
0.00
0.00
-------------
-------------
-------------
-------------
-------------
120,995.72
29,925.76
30,300.00
65,196.27
57,682.90
CHARGES FOR SERVICES -------------------33002
ZONING & SUBDIVISION FEES
33010
CREDIT CARD FEES
33100
LIENS RELEASED
33302
WEED CLEANING/MOWING
200.00
0.00
600.00
400.00
600.00
______________
6,149.11
8,061.38
5,000.00
9,325.53
5,500.00
______________
0.00
284.73
300.00
470.00
300.00
______________
3,395.70
300.00
2,500.00
635.00
0.00
______________
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE:
3
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
REVENUES --------- 2012-2013 ---------
ACCT NO#
ACCT NAME
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________ 33350
RECYCLING FACILITIES
33400
ANIMAL CONTROL & SHELTER FE
33500
SWIMMING POOL FEES
100.00
0.00
0.00
0.00
______________
4,785.00
2,500.00
4,610.00
2,500.00
______________
12,949.78
4,500.81
10,000.00
0.00
0.00
______________
-------------
-------------
-------------
-------------
-------------
26,824.59
18,031.92
20,900.00
15,440.53
8,900.00
4,800.00
3,600.00
4,800.00
3,200.00
4,800.00
______________
TOTAL CHARGES FOR SERVICES
0.00 4,130.00
RENTS & LEASES -------------34003
POWER PLANT LEASE
34010
COBRA INSURANCE FEES
34100
OTHER RENTS OR LEASES
0.00
0.00
8.63
0.00
______________
4,950.00
4,000.00
9,141.08
4,000.00
______________
-------------
-------------
-------------
-------------
-------------
23,024.12
8,550.00
8,800.00
12,349.71
8,800.00
131,401.83
206,692.97
150,000.00
243,712.43
200,000.00
______________
40.00
25.00
100.00
12.50
100.00
______________
670.37
811.98
750.00
910.76
750.00
______________
-------------
-------------
-------------
-------------
-------------
132,112.20
207,529.95
150,850.00
244,635.69
200,850.00
11,992.84
26,158.26
6,000.00
15,459.35
9,000.00
______________
0.00
______________
TOTAL RENTS & LEASES
0.00 18,224.12
FINES & FORFEITS ---------------35001
COURT & PARKING FINES
35002
CHILD SAFETY FUND
35003
TIME PAYMENT LOCAL FEE
TOTAL FINES & FORFEITS
MISCELLANEOUS REVENUE --------------------37001
INTEREST EARNINGS
37002
CASH SHORT & OVER
37003
TRASH BAG SALES - TAXABLE
37005
TRASH BAG SALES - NON-TAXAB
37006
(
163.90)(
40.00)
0.00 (
69.91)
2,257.01
2,453.11
2,500.00
1,917.37
1,500.00
______________
8.66
0.00
0.00
189.00
0.00
______________
UTILITY LATE CHARGES
63,464.32
0.00
65,000.00
65,537.06
65,000.00
______________
37008
IRIS REVENUE
18,156.00
10,128.00
5,000.00
9,768.00
5,000.00
______________
37009
OTHER MISCELLANEOUS REVENUE
9,281.16
9,334.44
9,000.00
69,987.74
10,000.00
______________
37014
INTEREST EARNED-CITY FUND
20,076.47
17,767.37
7,500.00
9,611.48
6,000.00
______________
37016
INTEREST EARNED-UTILITY DEP
740.43
498.68
375.00
0.00
350.00
______________
37018
INTEREST EARNED-ECONOMIC DE
115.91
78.06
50.00
79.14
80.00
______________
-------------
-------------
-------------
-------------
-------------
125,928.90
66,377.92
95,425.00
172,479.23
96,930.00
TOTAL MISCELLANEOUS REVENUE
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE:
4
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
REVENUES --------- 2012-2013 ---------
ACCT NO#
ACCT NAME
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
OTHER FINANCING SOURCES ----------------------39000
IN LIEU OF TAXES - ALLIANCE
35,470.50
39,411.66
0.00
0.00
0.00
______________
39001
UTILITIES ADMIN. FEE TRANSF
440,825.00
480,900.00
480,900.00
480,900.00
480,900.00
______________
39002
STREET REPAIR REIMBURSEMENT
70,363.26
76,759.92
76,760.00
76,759.92
76,760.00
______________
39004
IN LIEU OF FRANCHISE TAXES
94,348.87
102,926.04
102,924.00
102,926.04
102,924.00
______________
39005
ADMINISTRATION FEE - C.E.D.
8,200.00
8,271.96
8,200.00
8,200.00
8,200.00
______________
39007
TAPEIT - EVIDENCE INV GRANT
600.00
0.00
0.00
0.00
0.00
______________
39008
DEPT HOMELAND SEC GRANT
3,475.00
0.00
0.00
0.00
0.00
______________
39011
DUE FROM HUNT CO - ANIMAL S
40,000.00
55,000.00
55,000.00
51,475.00
55,000.00
______________
39012
DUE FROM SAFER GRANT
53,750.00
157,727.00
183,750.00
117,889.00
183,750.00
______________
39019
DUE FROM AMR FOR RENT
4,500.00
5,500.00
6,000.00
5,000.00
6,000.00
______________
39020
DUE FROM HYDRO
101,222.00
153,961.00
184,753.00
158,290.00
260,000.00
______________
39022
DUE FROM WORKFORCE NETWORK
0.00
0.00
0.00
533.03
0.00
______________
39023
DUE FROM HOSPITAL DISTRICT
0.00
0.00
0.00
0.00
9,400.00
______________
39025
DUE FROM CEDC - DIRECTOR
73,437.84
64,827.52
65,000.00
96,405.20
68,881.08
______________
39027
PROCEEDS OF CAPITAL LEASES
0.00
80,000.00
0.00
0.00
0.00
______________
39028
DUE FROM CEDC-TOURISM DIREC
0.00
0.00
0.00
0.00
8,000.00
______________
39029
LIVE OAK SETTLEMENT
0.00
0.00
0.00
37,187.49
0.00
______________
39030
SALE OF EQUIPMENT
0.00
40,500.00
0.00
4,282.50
0.00
______________
39050
TRANSFER IN
0.00
63,727.81
0.00
0.00
0.00
______________
-------------
-------------
-------------
-------------
-------------
926,192.47
1,329,512.91
1,163,287.00
1,139,848.18
1,259,815.08
TOTAL OTHER FINANCING SOURCES
** TOTAL REVENUES **
4,629,083.82
4,915,472.70
4,608,862.85
4,845,172.66
4,691,240.90
=============
=============
=============
=============
=============
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE:
5
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - CITY MANAGER DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PERSONNEL SERVICES -----------------4-110-1001 SUPERVISION
0.00
64,693.79
127,900.00
116,290.06
87,000.00
______________
4-110-1002 CLERICAL
27,352.03
17,731.60
40,475.00
49,448.72
12,665.00
______________
4-110-1003 OPERATING
25,814.88
26,172.32
26,310.00
27,289.80
41,386.80
______________
0.00
167.66
0.00
0.00
0.00
______________
767.00
875.47
2,260.00
1,735.61
1,636.20
______________
10,621.49
11,265.59
23,220.00
24,634.09
17,267.01
______________
203.47
457.58
1,085.00
515.30
786.50
______________
4-110-1005 OVERTIME 4-110-1006 OTHER SALARIES 4-110-1014 MEDICAL & LIFE INSURANCE 4-110-1015 WORKER'S COMP 4-110-1016 TEXAS WORKFORCE COM
144.00
1,172.03
1,230.00
148.17
823.50
______________
4-110-1017 TEXAS MUNICIPAL RETIREMENT
4,778.04
9,486.98
17,660.00
17,364.40
13,541.09
______________
4-110-1018 FICA & MEDICARE
4,041.81
8,039.20
15,070.00
14,767.71
10,915.63
______________
-------------
-------------
-------------
-------------
-------------
73,722.72
140,062.22
255,210.00
252,193.86
186,021.73
TOTAL PERSONNEL SERVICES
SUPPLIES -------4-110-2007 GAS & OIL
2,275.62
2,975.92
2,500.00
2,759.04
2,500.00
-------------
-------------
-------------
-------------
-------------
2,275.62
2,975.92
2,500.00
2,759.04
2,500.00
4-110-5004 MOTOR VEHICLE MAINTENANCE
340.90
1,899.62
1,000.00
983.95
1,000.00
______________
4-110-5015 COPIER MAINTENANCE
396.00
432.00
420.00
444.00
420.00
______________
4-110-5020 COMPUTER MAINTENANCE
851.55
798.00
750.00
547.00
0.00
______________
-------------
-------------
-------------
-------------
-------------
1,588.45
3,129.62
2,170.00
1,974.95
1,420.00
2,422.49
2,163.76
2,500.00
2,423.10
2,500.00
______________
343.70
0.00
0.00
0.00
0.00
______________
1,248.71
1,045.18
4,000.00
4,089.99
2,000.00
______________
917.00
1,934.28
1,000.00
987.00
1,000.00
______________
0.00
0.00
0.00
0.00
4,102.00
______________
-------------
-------------
-------------
-------------
-------------
4,931.90
5,143.22
7,500.00
7,500.09
9,602.00
TOTAL SUPPLIES
______________
MAINTENANCE - EQUIPMENT -----------------------
TOTAL MAINTENANCE - EQUIPMENT
OTHER SERVICES & CHARGES -----------------------4-110-6007 TELEPHONE EXPENSE 4-110-6009 NEWSLETTER PRINTING EXP. 4-110-6026 TRAVEL-TRAINING 4-110-6055 MEMBERSHIP-DUES-PUBLICATION 4-110-6100 EQUIPMENT LEASE
TOTAL OTHER SERVICES & CHARGES
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE:
6
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - CITY MANAGER DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
MISCELLANEOUS EXPENSES ---------------------4-110-8005 PRIOR PERIOD ADJ
TOTAL MISCELLANEOUS EXPENSES
** DEPARTMENT TOTAL **
0.00
442.27
0.00
0.00
0.00
-------------
-------------
-------------
-------------
-------------
0.00
442.27
0.00
0.00
0.00
-------------
-------------
-------------
-------------
-------------
82,518.69
151,753.25
267,380.00
264,427.94
199,543.73
=============
=============
=============
=============
=============
______________
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE:
7
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - ADMINISTRATIVE SERVICES DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PERSONNEL SERVICES -----------------4-112-1001 SUPERVISION
116,410.06
89,159.65
50,375.00
70,796.33
49,040.00
______________
4-112-1002 CLERICAL
19,075.92
2,392.68
11,780.00
6,886.34
53,730.00
______________
4-112-1005 OVERTIME
0.00
7.50
0.00
10.22
0.00
______________
1,357.12
1,007.20
725.00
789.68
1,192.13
______________
12,661.75
8,507.90
9,745.00
6,162.61
21,367.63
______________
4-112-1015 WORKER'S COMP
474.81
442.74
350.00
325.60
573.04
______________
4-112-1016 TEXAS WORKFORCE COM
549.90
524.79
405.00
18.00
810.00
______________
4-112-1017 TEXAS MUNICIPAL RETIREMENT
12,344.96
8,581.04
5,970.00
7,245.46
9,866.01
______________
4-112-1018 FICA & MEDICARE
10,711.10
7,069.10
4,810.00
6,054.25
7,953.10
______________
-------------
-------------
-------------
-------------
-------------
173,585.62
117,692.60
84,160.00
98,288.49
144,531.91
-------------
-------------
-------------
-------------
-------------
4-112-6021 UTILITY POSTAGE
1,770.12
2,000.00
2,000.00
1,310.00
2,000.00
______________
4-112-6026 TRAVEL-TRAINING
300.85
0.00
500.00
877.20
2,500.00
______________ ______________
4-112-1006 OTHER SALARIES 4-112-1014 MEDICAL & LIFE INSURANCE
TOTAL PERSONNEL SERVICES
SUPPLIES --------
TOTAL
OTHER SERVICES & CHARGES ------------------------
4-112-6055 MEMBERSHIP-DUES-PUBLICATION
TOTAL OTHER SERVICES & CHARGES
160.00
80.00
200.00
300.00
200.00
-------------
-------------
-------------
-------------
-------------
2,230.97
2,080.00
2,700.00
2,487.20
4,700.00
0.00
0.00
1,500.00
0.00
0.00
-------------
-------------
-------------
-------------
-------------
CAPITAL OUTLAY - EQUIPMENT -------------------------5-112-0006 CAP PURCHASE-COMPUTERS
TOTAL CAPITAL OUTLAY - EQUIPMENT
** DEPARTMENT TOTAL **
0.00
0.00
1,500.00
0.00
0.00
-------------
-------------
-------------
-------------
-------------
175,816.59
119,772.60
88,360.00
100,775.69
149,231.91
=============
=============
=============
=============
=============
______________
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE:
8
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - COMMUNITY DEVELOPMENT DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PERSONNEL SERVICES -----------------4-115-1001 SUPERVISION
48,687.08
49,361.21
49,590.00
48,912.95
49,727.00
______________
4-115-1002 CLERICAL
23,088.91
18,060.63
11,780.00
15,880.43
12,665.00
______________
4-115-1003 OPERATING
131,315.29
90,798.37
95,275.00
95,560.85
96,735.00
______________
4-115-1005 OVERTIME
3,424.63
3,398.79
4,500.00
3,619.27
4,500.00
______________
4-115-1006 OTHER SALARIES
1,404.94
1,066.87
1,820.00
1,767.56
1,845.87
______________
36,897.59
24,165.85
29,115.00
24,618.80
27,600.11
______________
3,077.43
2,538.07
7,800.00
4,574.10
7,900.78
______________
4-115-1014 MEDICAL & LIFE INSURANCE 4-115-1015 WORKER'S COMP 4-115-1016 TEXAS WORKFORCE COM
504.00
1,285.85
1,485.00
71.16
1,485.00
______________
4-115-1017 TEXAS MUNICIPAL RETIREMENT
18,062.78
14,008.62
14,420.00
14,819.86
14,560.78
______________
4-115-1018 FICA & MEDICARE
15,426.65
11,510.66
12,470.00
12,241.99
12,658.67
______________
-------------
-------------
-------------
-------------
-------------
281,889.30
216,194.92
228,255.00
222,066.97
229,678.21
TOTAL PERSONNEL SERVICES
SUPPLIES -------4-115-2003 WEARING APPAREL
345.96
668.99
1,800.00
595.68
1,800.00
______________
4-115-2005 ANIMAL SHELTER SUPPLIES
7,504.14
7,607.04
9,000.00
6,483.44
9,000.00
______________
4-115-2007 GAS & OIL
4,479.47
6,755.41
6,000.00
9,704.96
6,000.00
______________
-------------
-------------
-------------
-------------
-------------
12,329.57
15,031.44
16,800.00
16,784.08
16,800.00
4-115-3012 DEMOLITION - PROPERTY
1,124.74
9,902.96
10,000.00
6,457.53
10,000.00
______________
4-115-3013 MOWING
6,603.00
8,971.88
0.00
1,169.57
1,000.00
______________
4-115-3030 ANIMAL SHELTER CLEANING
0.00
4,601.53
5,600.00
7,683.31
7,600.00
______________
4-115-3040 CONTRACT SERVICES
0.00
863.35
1,000.00
72.00
1,000.00
______________
4-115-3041 CONTRACT PLANNING SERVICES
0.00
750.00
750.00
54.00
750.00
______________
-------------
-------------
-------------
-------------
-------------
7,727.74
25,089.72
17,350.00
15,436.41
20,350.00
TOTAL SUPPLIES
PROFESSIONAL SERVICES ---------------------
TOTAL PROFESSIONAL SERVICES
MAINTENANCE - BUILDING ---------------------4-115-4005 ANIMAL SHELTER MAINTENANCE
TOTAL MAINTENANCE - BUILDING
1,649.41
1,775.29
3,450.00
1,349.99
3,450.00
-------------
-------------
-------------
-------------
-------------
1,649.41
1,775.29
3,450.00
1,349.99
3,450.00
______________
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE:
9
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - COMMUNITY DEVELOPMENT DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
MAINTENANCE - EQUIPMENT ----------------------4-115-5001 FURN/OFFICE EQUIP MTCE
0.00
362.14
250.00
644.17
250.00
______________
4-115-5002 MACHINE/IMPLEMENT MTCE
64.07
103.47
300.00
25.79
300.00
______________
3,038.63
2,286.95
2,500.00
1,893.17
2,500.00
______________
4-115-5006 BACKFLOW PROGRAM
0.00
0.00
0.00
0.00
1,500.00
______________
4-115-5008 RADIO MAINTENANCE
0.00
0.00
850.00
0.00
850.00
______________
4-115-5015 COPIER MAINTENANCE
2,051.91
2,636.11
2,130.73
2,271.00
2,130.00
______________
4-115-5020 COMPUTER MAINTENANCE
3,021.15
1,008.81
3,500.00
2,642.37
3,500.00
______________
0.00
0.00
0.00
0.00
9,000.00
______________
-------------
-------------
-------------
-------------
-------------
8,175.76
6,397.48
9,530.73
7,476.50
20,030.00
4-115-6007 TELEPHONE EXPENSE
6,503.64
5,504.09
6,000.00
5,585.17
6,000.00
______________
4-115-6026 TRAVEL-TRAINING
1,384.47
899.10
2,000.00
1,766.40
2,000.00
______________ ______________
4-115-5004 MOTOR VEHICLE MTCE
4-115-5021 COMPUTER SOFTWARE
TOTAL MAINTENANCE - EQUIPMENT
OTHER SERVICES & CHARGES ------------------------
4-115-6055 MEMBERSHIP-DUES-PUBLICATION
TOTAL OTHER SERVICES & CHARGES
988.32
1,421.47
1,500.00
709.75
1,500.00
-------------
-------------
-------------
-------------
-------------
8,876.43
7,824.66
9,500.00
8,061.32
9,500.00
653.72
605.77
1,000.00
721.37
1,000.00
______________
PUBLIC UTILITIES ---------------4-115-7001 GAS UTILITY 4-115-7002 ELECTRIC UTILITY
8,520.24
8,556.48
11,000.00
7,746.13
11,000.00
______________
4-115-7005 WATER UTILITY
400.86
918.54
1,000.00
671.29
1,000.00
______________
4-115-7006 WASTEWATER UTILITY
370.68
713.92
800.00
539.50
800.00
______________
-------------
-------------
-------------
-------------
-------------
9,945.50
10,794.71
13,800.00
9,678.29
13,800.00
10,000.00
20,000.00
22,150.00
10,000.00
22,150.00
______________
0.00
0.00
0.00
4,279.25
0.00
______________
-------------
-------------
-------------
-------------
-------------
TOTAL PUBLIC UTILITIES
MISCELLANEOUS EXPENSES ---------------------4-115-8034 TRANSFER TO AIRPORT FUND 4-115-8035 ANIMAL SHELTER-HUNT COUNTY
TOTAL MISCELLANEOUS EXPENSES
** DEPARTMENT TOTAL **
10,000.00
20,000.00
22,150.00
14,279.25
22,150.00
-------------
-------------
-------------
-------------
-------------
340,593.71
303,108.22
320,835.73
295,132.81
335,758.21
=============
=============
=============
=============
=============
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 10
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - PARKS & RECREATION DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PERSONNEL SERVICES -----------------4-116-1001 SUPERVISION
46,935.98
47,585.86
75,195.00
56,344.50
75,474.00
______________
4-116-1002 CLERICAL
21,120.13
28,827.30
29,340.00
28,939.90
29,477.00
______________
4-116-1003 OPERATING
129,517.30
113,642.81
91,365.00
89,921.96
91,136.00
______________
4-116-1004 EXTRA HELP
28,700.53
17,797.72
49,000.00
20,461.98
7,000.00
______________
4-116-1005 OVERTIME
7,752.35
11,715.11
15,000.00
15,314.32
15,000.00
______________
4-116-1006 OTHER SALARIES
1,981.14
990.36
2,275.00
1,176.55
2,274.61
______________
34,156.39
31,221.09
38,755.00
31,199.43
36,715.49
______________
8,742.90
9,273.25
14,145.00
8,718.00
11,570.96
______________
664.65
2,537.44
3,360.00
80.84
2,100.00
______________
4-116-1017 TEXAS MUNICIPAL RETIREMENT
17,013.60
16,379.71
18,365.00
16,757.79
18,281.50
______________
4-116-1018 FICA & MEDICARE
18,439.29
16,286.70
20,055.00
16,145.32
16,857.66
______________
-------------
-------------
-------------
-------------
-------------
315,024.26
296,257.35
356,855.00
285,060.59
305,887.22
4-116-1014 MEDICAL & LIFE INSURANCE 4-116-1015 WORKER'S COMP 4-116-1016 TEXAS WORKFORCE COM
TOTAL PERSONNEL SERVICES
SUPPLIES -------4-116-2001 OFFICE SUPPLIES
1,521.68
705.70
0.00
47.88
200.00
______________
4-116-2003 WEARING APPAREL
3,374.16
4,591.76
4,000.00
3,060.29
4,000.00
______________
16,514.53
16,654.62
13,000.00
14,688.00
13,000.00
______________
4-116-2008 MINOR TOOLS
1,472.03
1,299.20
2,000.00
1,608.02
2,000.00
______________
4-116-2009 JANITORIAL SUPPLIES
1,281.38
2,445.70
1,750.00
1,728.52
1,750.00
______________
10,840.55
8,590.59
8,500.00
2,784.32
2,000.00
______________ ______________
4-116-2007 GAS & OIL
4-116-2010 CHEMICAL/MEDICAL SUPPLIES 4-116-2012 RECREATIONAL SUPPLIES
TOTAL SUPPLIES
6,737.39
4,060.83
7,000.00
6,962.48
7,000.00
-------------
-------------
-------------
-------------
-------------
41,741.72
38,348.40
36,250.00
30,879.51
29,950.00
7,364.40
3,088.50
2,000.00
2,179.54
2,000.00
______________ ______________
MAINTENANCE - BUILDING ---------------------4-116-4001 BUILDING MAINTENANCE 4-116-4012 HEATING/COOLING MTCE
TOTAL MAINTENANCE - BUILDING
760.05
79.87
500.00
96.00
500.00
-------------
-------------
-------------
-------------
-------------
8,124.45
3,168.37
2,500.00
2,275.54
2,500.00
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 11
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - PARKS & RECREATION DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
MAINTENANCE - EQUIPMENT ----------------------4-116-5001 FURN/OFFICE EQUIP MTCE
11.05
0.00
0.00
0.00
0.00
______________
13,301.10
6,475.87
5,000.00
4,913.78
5,000.00
______________
4-116-5004 MOTOR VEHICLE MTCE
2,094.19
2,157.30
2,000.00
2,080.00
2,000.00
______________
4-116-5009 SWIMMING POOL MTCE
12,193.51
3,390.72
10,000.00
0.00
0.00
______________
4-116-5010 PARK LIGHTING MTCE
2,268.45
2,676.01
2,500.00
1,786.61
2,500.00
______________
25,040.81
19,354.43
18,000.00
16,552.75
18,000.00
______________
4-116-5015 COPIER MAINTENANCE
586.20
873.40
952.20
0.00
952.20
______________
4-116-5020 COMPUTER MAINTENANCE
499.00
825.00
825.00
0.00
825.00
______________
-------------
-------------
-------------
-------------
-------------
55,994.31
35,752.73
39,277.20
25,333.14
29,277.20
4-116-5002 MACHINE & IMPLEMENT MTCE
4-116-5011 PARK MAINTENANCE
TOTAL MAINTENANCE - EQUIPMENT
OTHER SERVICES & CHARGES -----------------------4-116-6007 TELEPHONE EXPENSE
4,548.55
3,961.19
5,000.00
4,038.59
5,000.00
______________
4-116-6008 INTERNET SERVICE
699.75
0.00
0.00
0.00
0.00
______________
4-116-6026 TRAVEL-TRAINING
35.94
189.12
500.00
318.73
500.00
______________
0.00
900.00
1,500.00
0.00
1,500.00
______________
230.00
235.00
300.00
259.00
300.00
______________
4-116-6100 EQUIPMENT LEASE
1,943.30
1,734.00
7,742.00
8,098.37
7,742.00
______________
4-116-6101 CYPRESS LEASE-TRUCK
3,240.93
4,565.12
4,276.00
4,275.96
4,276.00
______________
-------------
-------------
-------------
-------------
-------------
10,698.47
11,584.43
19,318.00
16,990.65
19,318.00
4-116-6027 PROGRAM TRANSPORTATION 4-116-6055 MEMBERSHIP-DUES-PUBLICATION
TOTAL OTHER SERVICES & CHARGES
PUBLIC UTILITIES ---------------4-116-7001 GAS UTILITY
504.70
3,680.49
3,000.00
3,077.03
3,000.00
______________
28,972.09
25,490.73
20,000.00
23,412.21
20,000.00
______________
4-116-7005 WATER UTILITY
8,343.90
17,829.75
10,000.00
6,657.96
5,000.00
______________
4-116-7006 WASTEWATER UTILITY
1,208.12
8,259.21
2,000.00
1,340.45
2,000.00
______________
-------------
-------------
-------------
-------------
-------------
39,028.81
55,260.18
35,000.00
34,487.65
30,000.00
-------------
-------------
-------------
-------------
-------------
-------------
-------------
-------------
-------------
-------------
4-116-7002 ELECTRIC UTILITY
TOTAL PUBLIC UTILITIES
CAPITAL OUTLAY - EQUIPMENT --------------------------
TOTAL
** DEPARTMENT TOTAL **
470,612.02
440,371.46
489,200.20
395,027.08
416,932.42
=============
=============
=============
=============
=============
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 12
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - ECONOMIC DEVELOPMENT DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PERSONNEL SERVICES -----------------4-117-1001 SUPERVISION
51,534.83
50,692.39
50,000.00
49,307.77
52,500.00
______________
0.00
480.60
580.00
576.96
609.00
______________
4,249.07
5,423.60
6,535.00
5,712.68
6,214.20
______________
4-117-1015 WORKER'S COMP
132.69
178.57
275.00
226.36
289.38
______________
4-117-1016 TEXAS WORKFORCE COM
130.15
261.00
270.00
9.00
270.00
______________
4-117-1017 TEXAS MUNICIPAL RETIREMENT
3,917.22
4,640.90
4,745.00
4,771.91
4,982.25
______________
4-117-1018 FICA & MEDICARE
4,073.51
3,821.71
3,825.00
3,825.56
4,016.25
______________
-------------
-------------
-------------
-------------
-------------
64,037.47
65,498.77
66,230.00
64,430.24
68,881.08
4-117-1006 OTHER SALARIES 4-117-1014 MEDICAL & LIFE INSURANCE
TOTAL PERSONNEL SERVICES
OTHER SERVICES & CHARGES -----------------------4-117-6007 TELEPHONE 4-117-6026 TRAVEL TRAINING
TOTAL OTHER SERVICES & CHARGES
** DEPARTMENT TOTAL **
407.06
123.45
0.00
41.15
0.00
______________
1,958.07
0.00
0.00
0.00
0.00
______________
-------------
-------------
-------------
-------------
-------------
2,365.13
123.45
0.00
41.15
0.00
-------------
-------------
-------------
-------------
-------------
66,402.60
65,622.22
66,230.00
64,471.39
68,881.08
=============
=============
=============
=============
=============
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 13
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - FIRE & EMERGENCY SERVICES DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PERSONNEL SERVICES -----------------4-121-1001 SUPERVISION
154,645.64
144,161.73
156,020.00
148,450.80
159,478.00
______________
4-121-1003 OPERATING
261,706.51
272,547.97
264,095.00
272,253.19
262,940.45
______________
4-121-1005 OVERTIME
8,268.97
3,728.01
15,000.00
1,910.27
15,000.00
______________
4-121-1006 OTHER SALARIES
3,430.72
3,989.64
4,840.00
3,425.81
4,900.05
______________
0.00
0.00
0.00
0.00
8,910.00
______________
4-121-1014 MEDICAL & LIFE INSURANCE
66,330.48
63,621.06
81,235.00
64,878.07
77,023.47
______________
4-121-1015 WORKER'S COMP
14,164.49
14,028.57
20,100.00
11,910.42
20,348.42
______________
4-121-1009 CERTIFICATION PAY
4-121-1016 TEXAS WORKFORCE COM
1,147.16
3,501.77
3,390.00
296.47
3,388.50
______________
4-121-1017 TEXAS MUNICIPAL RETIREMENT
37,995.20
37,416.30
41,470.00
36,946.08
41,976.03
______________
4-121-1018 FICA & MEDICARE
33,082.59
30,565.26
33,430.00
30,833.78
33,837.37
______________
-------------
-------------
-------------
-------------
-------------
580,771.76
573,560.31
619,580.00
570,904.89
627,802.29
4-121-2001 OFFICE SUPPLIES
1,463.42
1,532.37
1,500.00
1,279.14
1,500.00
______________
4-121-2002 BUNKER GEAR
3,781.28
5,565.17
5,000.00
3,938.61
5,000.00
______________
4-121-2003 WEARING APPAREL
5,510.35
4,731.10
6,000.00
5,640.82
6,000.00
______________
15,312.58
17,442.86
19,500.00
15,818.42
19,000.00
______________
4-121-2008 MINOR TOOLS
1,831.94
2,700.23
2,000.00
1,821.91
2,000.00
______________
4-121-2009 JANITORIAL SUPPLIES
1,218.71
1,542.62
2,000.00
1,705.15
2,000.00
______________
4-121-2010 CHEMICAL/MEDICAL SUPPLIES
4,655.91
4,932.79
5,000.00
4,516.02
5,000.00
______________
4-121-2013 TRAINING SUPPLIES
2,366.97
2,221.07
2,000.00
2,103.95
2,000.00
______________
421.34
495.00
500.00
309.97
500.00
______________
1,529.25
1,595.23
1,000.00
1,075.53
1,200.00
______________
-------------
-------------
-------------
-------------
-------------
38,091.75
42,758.44
44,500.00
38,209.52
44,200.00
4-121-3001 VOL FIRE DEPART CONTRIBUTIO
7,655.00
3,180.34
0.00
0.00
0.00
______________
4-121-3002 VOL FIRE RETIRE CONTRIBUTIO
12,600.00
6,600.00
18,600.00
17,050.00
18,000.00
______________
-------------
-------------
-------------
-------------
-------------
20,255.00
9,780.34
18,600.00
17,050.00
18,000.00
TOTAL PERSONNEL SERVICES
SUPPLIES --------
4-121-2007 GAS & OIL
4-121-2025 INVESTIGATIVE SUPPLIES 4-121-2030 PUBLIC FIRE EDUCATION
TOTAL SUPPLIES
PROFESSIONAL SERVICES ---------------------
TOTAL PROFESSIONAL SERVICES
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 14
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - FIRE & EMERGENCY SERVICES DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
MAINTENANCE - BUILDING ---------------------4-121-4020 FIRE HYDRANT MAINTENANCE
236.27
202.86
300.00
267.52
300.00
-------------
-------------
-------------
-------------
-------------
236.27
202.86
300.00
267.52
300.00
4,189.68
4,010.40
4,000.00
4,141.76
4,000.00
______________
4-121-5004 MOTOR VEHICLE MTCE
17,450.14
23,122.97
17,500.00
17,372.46
17,000.00
______________
4-121-5005 SCBA MAINTENANCE
11,797.13
12,364.11
12,000.00
11,383.40
12,000.00
______________
984.90
699.50
1,000.00
784.22
1,000.00
______________
0.00
0.00
2,130.00
1,902.15
2,130.00
______________
2,925.95
2,957.55
3,000.00
2,971.00
3,500.00
______________
4-121-5022 ISO TRAINING
712.39
661.30
0.00
0.00
0.00
______________
4-121-5025 PPE TESTING
820.31
603.28
750.00
361.85
750.00
______________
-------------
-------------
-------------
-------------
-------------
38,880.50
44,419.11
40,380.00
38,916.84
40,380.00
3,711.21
2,857.65
3,100.00
2,788.87
3,100.00
______________
0.00
0.00
0.00
0.00
29,500.00
______________
4-121-6010 SAFER GRANT - EDUCATIONAL R
3,625.00
29,497.36
30,216.00
15,488.32
20,216.00
______________
4-121-6011 SAFER GRANT-ON DUTY STIPEND
7,200.00
99,001.00
82,406.00
118,543.90
118,000.00
______________
0.00
1,995.00
2,197.00
2,930.00
2,197.00
______________
35.00
1,630.35
2,014.00
892.64
2,014.00
______________
9,376.15
20,792.56
58,600.00
3,556.05
38,600.00
______________
4-121-6015 SAFER GRANT-PHYSICALS
0.00
3,564.46
7,691.00
3,498.00
3,500.00
______________
4-121-6024 HOSPITAL DISTRICT
0.00
0.00
0.00
0.00
9,400.00
______________
4-121-6026 TRAVEL-TRAINING
6,983.75
6,515.50
7,000.00
4,913.96
7,000.00
______________
4-121-6055 MEMBERSHIP-DUES-PUBLICATION
1,089.00
1,241.30
1,000.00
527.00
1,000.00
______________
TOTAL MAINTENANCE - BUILDING
______________
MAINTENANCE - EQUIPMENT ----------------------4-121-5003 INSTRUMENTS/APPARATUS MTC
4-121-5008 RADIO MAINTENANCE 4-121-5015 COPIER MAINTENANCE 4-121-5020 COMPUTER MAINTENANCE
TOTAL MAINTENANCE - EQUIPMENT
OTHER SERVICES & CHARGES -----------------------4-121-6007 TELEPHONE EXPENSE 4-121-6009 SAFER GRANT - CITY SHARE
4-121-6012 SAFER GRANT-OTHER STIPENDS 4-121-6013 SAFER GRANT-CONTRACTS 4-121-6014 SAFER GRANT-TRAINING REIMB
4-121-6056 CERTIFICATE RENEWAL 4-121-6100 EQUIPMENT LEASE 4-121-6160 BANK LEASE-FIRE TRUCK
TOTAL OTHER SERVICES & CHARGES
819.00
1,377.50
1,500.00
1,339.00
1,800.00
______________
25,327.50
6,627.96
7,625.00
7,625.04
9,268.00
______________
0.00
0.00
0.00
0.00
19,301.88
______________
-------------
-------------
-------------
-------------
-------------
58,166.61
175,100.64
203,349.00
162,102.78
264,896.88
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 15
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - FIRE & EMERGENCY SERVICES DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PUBLIC UTILITIES ---------------4-121-7001 GAS UTILITY
3,222.31
440.13
4,500.00
390.44
2,000.00
______________
4-121-7002 ELECTRIC UTILITY
6,914.02
14,174.86
15,000.00
17,168.33
15,000.00
______________
4-121-7005 WATER UTILITY
610.38
1,367.64
800.00
1,072.31
800.00
______________
4-121-7006 WASTEWATER UTILITY
787.72
1,274.23
800.00
1,025.05
800.00
______________
-------------
-------------
-------------
-------------
-------------
11,534.43
17,256.86
21,100.00
19,656.13
18,600.00
4-121-8022 INT EXP - 2008 CO'S
22,647.06
11,081.34
0.00
0.00
0.00
______________
4-121-8023 PRIN PAY - 2008 CO'S
35,000.00
40,000.00
0.00
0.00
0.00
______________
-------------
-------------
-------------
-------------
-------------
57,647.06
51,081.34
0.00
0.00
0.00
TOTAL PUBLIC UTILITIES
MISCELLANEOUS EXPENSES ----------------------
TOTAL MISCELLANEOUS EXPENSES
CAPITAL OUTLAY - EQUIPMENT -------------------------5-121-0006 CAP PURCHASE - COMPUTERS
TOTAL CAPITAL OUTLAY - EQUIPMENT
** DEPARTMENT TOTAL **
0.00
0.00
3,000.00
0.00
0.00
-------------
-------------
-------------
-------------
-------------
0.00
0.00
3,000.00
0.00
0.00
-------------
-------------
-------------
-------------
-------------
805,583.38
914,159.90
950,809.00
847,107.68
1,014,179.17
=============
=============
=============
=============
=============
______________
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 16
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - POLICE DEPARTMENT EXPENDITURES
ACCT NO#
--------- 2012-2013 ---------
ACCT NAME
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PERSONNEL SERVICES -----------------4-122-1001 SUPERVISION
228,352.27
148,682.41
176,215.00
192,633.83
210,349.97
______________
4-122-1002 CLERICAL
116,987.26
122,367.23
117,575.00
95,759.28
127,687.00
______________
4-122-1003 OPERATING
305,385.72
327,133.70
300,240.00
335,855.68
313,937.60
______________
4-122-1005 OVERTIME
33,444.81
49,277.44
45,000.00
30,858.88
45,000.00
______________
3,808.36
3,644.07
6,890.00
3,930.59
7,562.90
______________
0.00
0.00
0.00
0.00
5,940.00
______________
111,963.16
94,841.40
128,525.00
104,111.96
128,000.06
______________
24,836.62
26,068.53
30,740.00
20,053.00
33,638.36
______________
1,702.42
6,442.84
5,670.00
584.54
5,940.00
______________
4-122-1017 TEXAS MUNICIPAL RETIREMENT
61,716.77
58,534.18
61,300.00
63,306.06
66,860.61
______________
4-122-1018 FICA & MEDICARE
52,476.94
46,630.75
49,415.00
48,270.64
53,897.12
______________
-------------
-------------
-------------
-------------
-------------
940,674.33
883,622.55
921,570.00
895,364.46
998,813.62
6,859.96
9,300.11
7,000.00
10,746.22
7,000.00
______________
0.00
350.00
350.00
130.76
350.00
______________
6,570.86
11,620.01
9,000.00
6,614.81
9,000.00
______________
57,614.23
58,421.60
60,000.00
58,165.08
60,000.00
______________
509.56
482.59
600.00
765.50
600.00
______________
20.70
727.23
500.00
1,530.60
500.00
______________
4-122-2013 TRAINING SUPPLIES
382.45
2,763.24
2,500.00
1,596.52
3,500.00
______________
4-122-2014 SUPPORT OF PRISONERS
341.26
902.09
900.00
1,322.64
900.00
______________
4,037.45
7,980.72
5,000.00
9,909.84
7,500.00
______________
1,169.77
1,000.00
263.75
1,000.00
______________
600.00
0.00
0.00
0.00
0.00
______________
-------------
-------------
-------------
-------------
-------------
76,283.03
93,717.36
86,850.00
91,045.72
90,350.00
4-122-3010 NARCOTICS INVESTIGATION
2,396.26
9,374.47
9,000.00
8,207.89
9,000.00
______________
4-122-3011 DRUG DOG EXPENSE
1,301.36
0.00
0.00
0.00
0.00
______________
-------------
-------------
-------------
-------------
-------------
3,697.62
9,374.47
9,000.00
8,207.89
9,000.00
4-122-1006 OTHER SALARIES 4-122-1009 CERTIFICATION PAY 4-122-1014 MEDICAL & LIFE INSURANCE 4-122-1015 WORKER'S COMP 4-122-1016 TEXAS WORKFORCE COM
TOTAL PERSONNEL SERVICES
SUPPLIES -------4-122-2001 OFFICE SUPPLIES 4-122-2002 PHOTOGRAPHIC SUPPLIES 4-122-2003 WEARING APPAREL 4-122-2007 GAS & OIL 4-122-2008 MINOR TOOLS 4-122-2009 JANITORIAL SUPPLIES
4-122-2025 INVESTIGATIVE SUPPLIES 4-122-2030 CRIME PREV. SUPPLIES 4-122-2036 TAPEIT-EVIDENCE INVENTORY
TOTAL SUPPLIES
(
653.44)
PROFESSIONAL SERVICES ---------------------
TOTAL PROFESSIONAL SERVICES
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 17
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - POLICE DEPARTMENT EXPENDITURES
ACCT NO#
--------- 2012-2013 ---------
ACCT NAME
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
MAINTENANCE - EQUIPMENT ----------------------4-122-5001 FURN/OFFICE EQUIP MTCE
540.93
500.00
6.49
500.00
______________
(
224.00)
0.00
0.00
0.00
0.00
______________
4-122-5003 INSTRUMENTS/APPARATUS MTC (
893.50)
0.00
0.00
0.00
0.00
______________
25,713.99
26,930.72
20,000.00
45,235.29
30,000.00
______________
500.00
2,035.00
500.00
575.00
500.00
______________
4-122-5015 COPIER MAINTENANCE
1,237.96
1,742.80
528.00
682.30
0.00
______________
4-122-5020 COMPUTER MAINTENANCE
9,449.98
10,434.86
10,000.00
13,725.66
14,000.00
______________
-------------
-------------
-------------
-------------
-------------
35,784.43
41,684.31
31,528.00
60,224.74
45,000.00
4-122-6007 TELEPHONE EXPENSE
7,720.24
6,826.81
6,500.00
6,798.53
6,500.00
______________
4-122-6008 INTERNET SERVICES
1,703.50
2,089.62
1,800.00
1,897.03
1,800.00
______________
4-122-6009 CELL PHONE STIPEND
2,870.00
2,952.40
3,000.00
3,035.00
3,000.00
______________
4-122-5002 USDA GRANT FOR A/V
0.00
4-122-5004 MOTOR VEHICLE MTCE 4-122-5008 RADIO MAINTENANCE
TOTAL MAINTENANCE - EQUIPMENT
OTHER SERVICES & CHARGES ------------------------
4-122-6025 STATE FUNDED TRAINING
225.00
0.00
0.00
0.00
0.00
______________
4-122-6026 TRAVEL-TRAINING
3,979.17
4,223.67
5,000.00
5,951.98
5,000.00
______________
4-122-6028 EOC/FEMA
2,214.41
0.00
0.00
0.00
0.00
______________
4-122-6055 MEMBERSHIP-DUES-PUBLICATION
1,219.00
1,725.36
1,500.00
462.00
1,500.00
______________
4-122-6100 EQUIPMENT LEASE
4,940.87
4,041.96
19,055.00
19,055.92
46,164.00
______________
4-122-6101 LEASE VEHICLES (CYPRESS BK)
18,850.37
17,628.93
19,232.00
19,231.56
3,205.00
______________
4-122-6102 Guaranty Bond - Lease Payme
0.00
0.00
0.00
31,100.68
28,708.00
______________
-------------
-------------
-------------
-------------
-------------
43,722.56
39,488.75
56,087.00
87,532.70
95,877.00
TOTAL OTHER SERVICES & CHARGES
PUBLIC UTILITIES ---------------4-122-7001 GAS UTILITY 4-122-7002 ELECTRIC UTILITY 4-122-7005 WATER UTILITY 4-122-7006 WASTEWATER UTILITY
TOTAL PUBLIC UTILITIES
4,832.43
3,077.66
5,000.00
4,137.19
5,000.00
______________
27,305.46
17,807.97
20,000.00
15,013.61
15,000.00
______________
234.91
585.66
600.00
730.05
600.00
______________ ______________
403.98
550.96
600.00
680.60
600.00
-------------
-------------
-------------
-------------
-------------
32,776.78
22,022.25
26,200.00
20,561.45
21,200.00
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 18
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - POLICE DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
MISCELLANEOUS EXPENSES ---------------------4-122-8034 TRANSFER TO ISF EQP SER FUN
TOTAL MISCELLANEOUS EXPENSES
0.00
80,000.00
0.00
0.00
0.00
-------------
-------------
-------------
-------------
-------------
0.00
80,000.00
0.00
0.00
0.00
-------------
-------------
-------------
-------------
-------------
-------------
-------------
-------------
-------------
-------------
CAPITAL OUTLAY - EQUIPMENT --------------------------
TOTAL
** DEPARTMENT TOTAL **
1,132,938.75
1,169,909.69
1,131,235.00
1,162,936.96
1,260,240.62
=============
=============
=============
=============
=============
______________
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 19
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - EMERGENCY MANAGEMENT DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PERSONNEL SERVICES -----------------4-123-1001 SUPERVISION
23,112.70
30,204.18
21,125.00
26,877.25
21,193.05
______________
4-123-1003 OPERATING
23,190.61
21,745.65
35,755.00
21,233.65
35,881.20
______________
4-123-1005 OVERTIME
838.13
223.83
2,000.00
112.20
0.00
______________
4-123-1006 OTHER SALARIES
281.24
272.94
660.00
0.00
662.06
______________
7,483.04
6,085.75
9,165.00
8,074.87
8,692.86
______________
845.54
0.00
2,095.00
1,100.00
2,022.43
______________
0.00
0.00
380.00
0.00
380.70
______________
4-123-1017 TEXAS MUNICIPAL RETIREMENT
4,210.64
4,417.44
5,650.00
4,613.06
5,479.18
______________
4-123-1018 FICA & MEDICARE
3,583.22
3,625.34
4,555.00
3,330.78
4,416.83
______________
-------------
-------------
-------------
-------------
-------------
63,545.12
66,575.13
81,385.00
65,341.81
78,728.31
4-123-1014 MEDICAL & LIVE INSURANCE 4-123-1015 WORKERS COMP 4-123-1016 TEXAS WORKFORCE COM
TOTAL PERSONNEL SERVICES
SUPPLIES -------4-123-2001 OFFICE SUPPLIES
2,149.02
3,094.17
3,000.00
80.81
2,000.00
-------------
-------------
-------------
-------------
-------------
2,149.02
3,094.17
3,000.00
80.81
2,000.00
13.30
701.26
1,000.00
400.00
500.00
______________
4-123-5020 COMPUTER/EQUIP MAINT
932.28
3,177.51
3,000.00
927.54
750.00
______________
4-123-5023 THREAT/WEATHER SOFTWARE
396.35
488.42
1,500.00
719.29
1,500.00
______________
-------------
-------------
-------------
-------------
-------------
1,341.93
4,367.19
5,500.00
2,046.83
2,750.00
4-123-6007 TELEPHONE EXPENSE
1,511.97
1,573.15
2,000.00
1,288.69
1,800.00
______________
4-123-6008 INTERNET SERVICES
0.00
0.00
0.00
213.22
0.00
______________
830.00
1,040.83
2,000.00
588.40
2,000.00
______________
4-123-6027 IRIS
3,000.00
0.00
3,000.00
875.24
3,000.00
______________
4-123-6055 MEMBERSHIPS/DUES/PUB
2,100.00
2,000.00
2,000.00
2,000.00
3,090.00
______________
-------------
-------------
-------------
-------------
-------------
7,441.97
4,613.98
9,000.00
4,965.55
9,890.00
-------------
-------------
-------------
-------------
-------------
TOTAL SUPPLIES
______________
MAINTENANCE - EQUIPMENT ----------------------4-123-5008 RADIO MAINTENANCE
TOTAL MAINTENANCE - EQUIPMENT
OTHER SERVICES & CHARGES ------------------------
4-123-6026 TRAVEL-TRAINING
TOTAL OTHER SERVICES & CHARGES
** DEPARTMENT TOTAL **
74,478.04
78,650.47
98,885.00
72,435.00
93,368.31
=============
=============
=============
=============
=============
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 20
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - MUNICIPAL COURT DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PERSONNEL SERVICES -----------------4-125-1001 SUPERVISION
34,999.90
35,484.51
35,000.00
35,415.29
35,000.00
______________
4-125-1002 CLERICAL
11,748.91
2,075.37
0.00
3,572.18
21,707.00
______________
4-125-1003 OPERATING
14,742.22
2,220.41
17,605.00
19,337.02
17,686.20
______________
4-125-1005 OVERTIME
1,553.94
2,269.17
1,000.00
7,297.30
1,000.00
______________
227.66
331.49
610.00
196.85
862.96
______________
11,422.85
8,799.55
10,360.00
9,094.12
15,903.52
______________
1,787.85
400.85
1,270.00
700.00
1,393.13
______________
4-125-1006 OTHER SALARIES 4-125-1014 MEDICAL & LIFE INSURANCE 4-125-1015 WORKER'S COMP 4-125-1016 TEXAS WORKFORCE COM
111.31
261.00
540.00
10.07
810.00
______________
4-125-1017 TEXAS MUNICIPAL RETIREMENT
4,463.68
3,749.75
5,145.00
5,338.29
7,236.71
______________
4-125-1018 FICA & MEDICARE
3,854.75
2,969.16
4,150.00
4,238.50
5,833.60
______________
-------------
-------------
-------------
-------------
-------------
84,913.07
58,561.26
75,680.00
85,199.62
107,433.12
TOTAL PERSONNEL SERVICES
SUPPLIES -------4-125-2003 WEARING APPAREL
TOTAL SUPPLIES
64.82
0.00
300.00
70.92
300.00
-------------
-------------
-------------
-------------
-------------
64.82
0.00
300.00
70.92
300.00
______________
PROFESSIONAL SERVICES --------------------4-125-3003 LEGAL SERVICES
TOTAL PROFESSIONAL SERVICES
6,309.42
6,000.00
6,000.00
3,992.75
6,000.00
-------------
-------------
-------------
-------------
-------------
______________
6,309.42
6,000.00
6,000.00
3,992.75
6,000.00
0.00
59.34
200.00
173.99
200.00
______________
MAINTENANCE - EQUIPMENT ----------------------4-125-5001 FURN/OFFICE EQUIP MTCE 4-125-5015 COPIER MAINTENANCE 4-125-5020 COMPUTER MAINTENANCE
TOTAL MAINTENANCE - EQUIPMENT
434.59
522.64
432.00
597.55
520.00
______________
1,487.02
1,762.72
1,850.00
5,642.88
1,000.00
______________
-------------
-------------
-------------
-------------
-------------
1,921.61
2,344.70
2,482.00
6,414.42
1,720.00
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 21
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - MUNICIPAL COURT DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
OTHER SERVICES & CHARGES -----------------------4-125-6007 TELEPHONE EXPENSE
3,700.24
3,485.87
5,000.00
3,483.35
5,000.00
______________
4-125-6008 INTERNET SERVICES
7,276.85
4,508.50
8,600.00
1,175.00
10,336.00
______________
4-125-6009 CELL PHONE STIPEND
550.00
600.00
600.00
600.00
600.00
______________
4-125-6018 JURY COSTS
336.00
0.00
300.00
0.00
300.00
______________
4-125-6019 INTERPRETER
112.87
35.00
500.00
385.00
500.00
______________
2,288.68
1,429.79
2,000.00
1,455.68
2,500.00
______________
86.00
90.00
100.00
54.00
200.00
______________
0.00
0.00
4,286.00
4,515.17
4,534.00
______________
-------------
-------------
-------------
-------------
-------------
4-125-6026 TRAVEL-TRAINING 4-125-6055 MEMBERSHIP-DUES-PUBLICATION 4-125-6100 EQUIPMENT LEASE
TOTAL OTHER SERVICES & CHARGES
** DEPARTMENT TOTAL **
14,350.64
10,149.16
21,386.00
11,668.20
23,970.00
-------------
-------------
-------------
-------------
-------------
107,559.56
77,055.12
105,848.00
107,345.91
139,423.12
=============
=============
=============
=============
=============
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 22
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - PUBLIC WORKS DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PERSONNEL SERVICES -----------------4-130-1001 SUPERVISION
16,261.44
16,486.60
16,530.00
16,587.04
17,387.12
______________
4-130-1002 CLERICAL
10,125.64
7,547.29
7,855.00
7,668.39
7,898.33
______________
4-130-1003 OPERATING
99,712.92
94,466.12
90,755.00
97,831.06
94,116.50
______________
4-130-1005 OVERTIME
6,803.93
6,976.98
6,500.00
8,854.37
6,500.00
______________
4-130-1006 OTHER SALARIES
1,217.36
1,290.78
1,335.00
888.10
1,385.06
______________
4-130-1014 MEDICAL & LIFE INSURANCE
24,540.81
19,683.91
26,890.00
18,180.46
25,487.16
______________
4-130-1015 WORKER'S COMP
11,308.44
10,844.45
14,150.00
9,233.00
14,673.18
______________
4-130-1016 TEXAS WORKFORCE COM
392.69
1,305.00
1,260.00
45.00
1,260.00
______________
4-130-1017 TEXAS MUNICIPAL RETIREMENT
11,658.27
11,415.49
11,670.00
12,616.42
12,079.54
______________
4-130-1018 FICA & MEDICARE
10,312.90
9,166.79
9,410.00
9,838.52
9,737.46
______________
-------------
-------------
-------------
-------------
-------------
192,334.40
179,183.41
186,355.00
181,742.36
190,524.35
TOTAL PERSONNEL SERVICES
SUPPLIES -------4-130-2001 OFFICE SUPPLIES
518.87
598.23
600.00
625.95
600.00
______________
4-130-2003 WEARING APPAREL
2,441.33
1,820.66
2,441.00
2,968.20
2,441.00
______________
151.47
0.00
150.00
147.45
150.00
______________
4-130-2006 DIESEL FUEL
8,645.15
5,229.67
5,000.00
15,691.80
8,000.00
______________
4-130-2007 GAS & OIL
9,787.48
11,845.62
11,000.00
10,259.52
11,000.00
______________
4-130-2008 MINOR TOOLS
4,681.02
2,352.09
2,400.00
2,765.79
2,400.00
______________
500.70
296.81
300.00
290.69
300.00
______________ ______________
4-130-2004 MEALS
4-130-2009 JANITORIAL SUPPLIES 4-130-2010 CHEMICAL/MEDICAL SUPPLIES
TOTAL SUPPLIES
3,604.39
2,474.40
2,600.00
662.80
2,600.00
-------------
-------------
-------------
-------------
-------------
30,330.41
24,617.48
24,491.00
33,412.20
27,491.00
1,800.24
2,588.38
3,000.00
3,012.57
3,000.00
______________
MAINTENANCE - BUILDING ---------------------4-130-4001 BUILDING MAINTENANCE 4-130-4006 STORM SEWER MAINTENANCE 4-130-4008 STREET & ALLEY MAINTENANCE 4-130-4009 SIGNAGE 4-130-4012 HEATING/COOLING MTCE 4-130-4019 STREET MAINTENANCE
TOTAL MAINTENANCE - BUILDING
2,768.42
2,725.67
12,500.00
10,462.22
12,500.00
______________
15,974.62
25,713.60
24,500.00
30,125.24
24,500.00
______________
1,658.17
4,483.83
5,000.00
1,061.42
5,000.00
______________
0.00
0.00
300.00
0.00
300.00
______________
75,704.42
86,921.95
85,500.00
85,500.47
100,000.00
______________
-------------
-------------
-------------
-------------
-------------
97,905.87
122,433.43
130,800.00
130,161.92
145,300.00
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 23
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - PUBLIC WORKS DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
MAINTENANCE - EQUIPMENT ----------------------4-130-5001 FURN/OFFICE EQUIP MTCE 4-130-5002 MACHINE & IMPLEMENT MTCE 4-130-5003 INSTURMENTS/APPARATUS MTCE 4-130-5004 MOTOR VEHICLE MTCE 4-130-5008 RADIO MAINTENANCE 4-130-5020 COMPUTER MAINTENANCE
TOTAL MAINTENANCE - EQUIPMENT
127.95
53.43
300.00
52.92
300.00
______________
16,234.84
17,292.85
26,000.00
24,637.67
26,000.00
______________
696.67
0.00
700.00
63.44
700.00
______________
6,801.74
4,208.65
7,000.00
6,512.88
7,000.00
______________
0.00
0.00
500.00
0.00
700.00
______________
1,800.00
900.00
1,000.00
900.00
1,900.00
______________
-------------
-------------
-------------
-------------
-------------
25,661.20
22,454.93
35,500.00
32,166.91
36,600.00
OTHER SERVICES & CHARGES -----------------------4-130-6007 TELEPHONE EXPENSE
2,914.17
2,496.03
3,000.00
2,581.57
3,000.00
______________
4-130-6010 HAZARDOUS WASTE DISPOSAL
770.32
75.39
1,000.00
80.12
1,000.00
______________
4-130-6026 TRAVEL-TRAINING
653.95
609.11
1,000.00
1,076.73
1,000.00
______________
4-130-6100 EQUIPMENT LEASE
10,417.62
10,215.00
11,115.00
11,112.00
11,112.00
______________
4-130-6101 CYPRESS LEASE - TRUCK
5,004.00
5,421.00
5,004.00
5,421.00
1,609.91
______________
4-130-6150 BANK LEASE-BACKHOE
9,519.32
0.00
0.00
0.00
0.00
______________
0.00
0.00
0.00
0.00
3,386.16
______________
-------------
-------------
-------------
-------------
-------------
4-130-6160 BANK LEASE-JET VAC TRUCK
TOTAL OTHER SERVICES & CHARGES
** DEPARTMENT TOTAL **
29,279.38
18,816.53
21,119.00
20,271.42
21,108.07
-------------
-------------
-------------
-------------
-------------
375,511.26
367,505.78
398,265.00
397,754.81
421,023.42
=============
=============
=============
=============
=============
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 24
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - GOVERNMENTAL AFFAIRS DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
SUPPLIES -------4-140-2001 OFFICE SUPPLIES
12,816.43
15,222.37
15,000.00
13,833.41
15,000.00
______________
767.85
2,428.49
2,000.00
3,279.47
2,000.00
______________
0.00
180.92
200.00
0.00
200.00
______________
-------------
-------------
-------------
-------------
-------------
13,584.28
17,831.78
17,200.00
17,112.88
17,200.00
4-140-2009 JANITORIAL SUPPLIES-CITY HA 4-140-2010 JANITORIAL EQUIPMENT
TOTAL SUPPLIES
PROFESSIONAL SERVICES --------------------4-140-3002 DELINQTAX ATTORNEY FEES
0.00
0.00
0.00
______________
4-140-3003 LEGAL SERVICES
33,200.04
33,320.04
33,200.00
23,235.90
33,200.00
______________
4-140-3004 AUDIT SERVICES
6,620.00
5,800.00
12,400.00
12,400.00
12,400.00
______________
4-140-3006 HEALTH SERVICES-IMMUNIZATIO
1,500.00
1,500.00
1,500.00
1,500.00
1,500.00
______________
44,591.15
45,383.75
45,175.00
44,968.88
45,175.00
______________
4-140-3008 EMPLOYEE PHYSICALS
2,268.00
4,693.96
2,500.00
2,893.00
2,500.00
______________
4-140-3011 SENIOR CENTER RESOURCES
7,500.00
0.00
7,500.00
7,500.00
5,000.00
______________
4-140-3012 CRISIS CENTER
1,000.00
0.00
0.00
0.00
0.00
______________
4-140-3018 TAX COLLECTION
3,581.68
3,584.75
4,000.00
3,625.78
3,795.00
______________
475.00
2,450.00
2,500.00
2,500.00
0.00
______________
0.00
0.00
2,221.00
0.00
4,000.00
______________
1,915.05
3,036.14
3,100.00
3,506.12
3,600.00
______________
4-140-3050 IRIS ANNUAL SERVICE
0.00
6,866.04
7,000.00
7,000.00
7,000.00
______________
4-140-3060 SALES TAX PENALTY
0.00
0.00
0.00
357.15
0.00
______________
-------------
-------------
-------------
-------------
-------------
102,650.92
106,634.68
121,096.00
108,784.92
118,170.00
4-140-3007 TAX APPRAISAL DISTRICT
4-140-3021 ACCT SERVICES 4-140-3022 CONTRACT ACCT SERVICES 4-140-3026 CODE OF ORDINANCE SUPPLEMEN
TOTAL PROFESSIONAL SERVICES
0.00 (
701.91)
MAINTENANCE - BUILDING ---------------------4-140-4001 BUILDING MAINT-CITY HALL
6,320.20
9,484.52
7,500.00
7,595.57
7,500.00
______________
4-140-4002 BUILDING MAINT-FIRE/POLICE
6,785.27
13,000.73
7,500.00
14,954.78
10,000.00
______________
-------------
-------------
-------------
-------------
-------------
13,105.47
22,485.25
15,000.00
22,550.35
17,500.00
TOTAL MAINTENANCE - BUILDING
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 25
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - GOVERNMENTAL AFFAIRS DEPARTMENT EXPENDITURES
ACCT NO#
--------- 2012-2013 ---------
ACCT NAME
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
MAINTENANCE - EQUIPMENT ----------------------4-140-5015 COPIER MAINTENANCE
3,269.98
4,149.90
2,944.49
3,977.15
3,800.00
______________
4-140-5020 COMPUTER MAINTENANCE
4,711.00
699.68
5,000.00
7,024.64
7,725.00
______________
0.00
807.99
1,000.00
788.90
1,000.00
______________
-------------
-------------
-------------
-------------
-------------
7,980.98
5,657.57
8,944.49
11,790.69
12,525.00
4-140-5021 PHONE SYSTEM MAINTENANCE
TOTAL MAINTENANCE - EQUIPMENT
OTHER SERVICES & CHARGES -----------------------4-140-6003 JANITORIAL SERVICE-CITY HAL
57.25
6,940.00
10,000.00
13,948.37
10,000.00
______________
37,572.05
44,978.61
45,000.00
47,000.00
45,000.00
______________
196.55
225.52
200.00
72.49
200.00
______________
4-140-6008 INTERNET
2,097.95
0.00
2,700.00
2,398.00
2,700.00
______________
4-140-6010 POSTAGE MACHINE
4,773.78
5,427.34
4,000.00
5,148.59
4,000.00
______________
4-140-6012 ELECTION EXPENSE
1,538.25
2,022.39
2,000.00
222.50
2,000.00
______________
4-140-6025 ADVERTISING EXPENSE
3,569.34
7,328.52
4,000.00
7,561.61
4,000.00
______________
4-140-6028 EMPLOYEE & PUBLIC RELATIONS
3,864.84
2,969.52
6,500.00
3,853.10
6,500.00
______________
4-140-6045 PURCHASE GARBAGE BAGS
2,400.00
3,576.00
3,700.00
3,576.00
3,700.00
______________
4-140-6075 CREDIT CARD FEES
0.00
0.00
0.00
12,100.99
5,200.00
______________
4-140-6200 CONTINGENCY FUND
40,482.62
42,947.33
40,000.00
133,925.29
40,000.00
______________
4-140-6201 IT CONSULTANT (J POST)
13,050.00
13,200.00
12,000.00
13,200.00
12,000.00
______________
4-140-6202 INSURANCE CONSULTANT FEE
24,000.00
24,000.00
24,000.00
24,000.00
24,000.00
______________
4-140-6205 TRANSFER TO CAP PROJECTS
110,821.17
35,786.48
0.00
4.02
0.00
______________
0.00
0.00
0.00
122,486.05
0.00
______________
1,200.00
1,200.00
1,200.00
1,200.00
1,200.00
______________
0.00
3,175.00
3,175.00
3,175.00
3,175.00
______________
-------------
-------------
-------------
-------------
-------------
245,623.80
193,776.71
158,475.00
393,872.01
163,675.00
4-140-6006 INSURANCE EXPENSE 4-140-6007 TELEPHONE
4-140-6207 TRANSFER 4-140-6210 WEB SITE CONSULTANT 4-140-6215 HUNT COUNTY HAZARDOUS WST
TOTAL OTHER SERVICES & CHARGES
PUBLIC UTILITIES ---------------4-140-7001 GAS UTILITY
2,548.53
1,909.97
3,000.00
2,500.36
3,000.00
______________
88,274.60
106,403.21
88,000.00
112,964.49
95,000.00
______________
4-140-7003 ELECTRIC UTILITY-CITY HALL
6,029.93
2,963.96
10,000.00
9,351.09
8,000.00
______________
4-140-7005 WATER UTILITY-CITY HALL
3,340.23
3,856.23
2,500.00
2,260.73
2,000.00
______________
136.87
100.88
150.00
83.00
150.00
______________
7,951.65
4,367.43
6,000.00
2,464.70
3,000.00
______________
-------------
-------------
-------------
-------------
-------------
4-140-7002 STREET LIGHTING
4-140-7006 WASTEWATER UTILITY-CITY HAL 4-140-7007 WATER UTIL -
TOTAL PUBLIC UTILITIES
** DEPARTMENT TOTAL **
LANDSCAPE
108,281.81
119,601.68
109,650.00
129,624.37
111,150.00
-------------
-------------
-------------
-------------
-------------
491,227.26
465,987.67
430,365.49
683,735.22
440,220.00
=============
=============
=============
=============
=============
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 26
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - PUBLIC LIBRARY DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PROFESSIONAL SERVICES --------------------4-150-3012 PUBLIC LIBRARY CONTRIBUTION
TOTAL PROFESSIONAL SERVICES
57,519.96
57,519.96
43,500.00
43,500.04
43,500.00
-------------
-------------
-------------
-------------
-------------
______________
57,519.96
57,519.96
43,500.00
43,500.04
43,500.00
2,188.68
1,163.20
2,000.00
3,184.49
2,000.00
______________
0.00
0.00
0.00
0.00
8,500.00
______________
1,637.25
0.00
1,200.00
1,200.00
1,200.00
______________
-------------
-------------
-------------
-------------
-------------
3,825.93
1,163.20
3,200.00
4,384.49
11,700.00
MAINTENANCE - BUILDING ---------------------4-150-4001 BUILDING MAINTENANCE 4-150-4002 BUILDING RENOVATION 4-150-4012 HEATING/COOLING MTCE
TOTAL MAINTENANCE - BUILDING
MAINTENANCE - EQUIPMENT ----------------------4-150-5015 COPIER MAINTENANCE
2,083.86
2,288.06
2,130.76
2,144.88
2,130.00
-------------
-------------
-------------
-------------
-------------
2,083.86
2,288.06
2,130.76
2,144.88
2,130.00
-------------
-------------
-------------
-------------
-------------
4-150-7001 GAS UTILITY
1,877.88
1,127.25
1,800.00
1,318.84
1,800.00
______________
4-150-7002 ELECTRIC UTILITY
8,289.03
6,584.22
8,000.00
5,539.71
8,000.00
______________
TOTAL MAINTENANCE - EQUIPMENT
______________
OTHER SERVICES & CHARGES ------------------------
TOTAL
PUBLIC UTILITIES ----------------
4-150-7005 WATER UTILITY
78.16
93.96
150.00
74.40
150.00
______________
4-150-7006 WASTEWATER UTILITY
87.66
104.76
150.00
83.00
150.00
______________
-------------
-------------
-------------
-------------
-------------
TOTAL PUBLIC UTILITIES
** DEPARTMENT TOTAL **
10,332.73
7,910.19
10,100.00
7,015.95
10,100.00
-------------
-------------
-------------
-------------
-------------
73,762.48
68,881.41
58,930.76
57,045.36
67,430.00
=============
=============
=============
=============
=============
10-23-2013 03:39 PM
C I T Y
O F
C O M M E R C E
PAGE: 27
PROPOSED BUDGET WORKSHEET 01 -GENERAL FUND
AS OF: SEPTEMBER 30TH, 2013
DEPARTMENT - CITY COUNCIL DEPARTMENT EXPENDITURES
ACCT NO#
ACCT NAME
--------- 2012-2013 ---------
PROPOSED
2010-2011
2011-2012
CURRENT
Y-T-D
2013-2014
BUDGET
ACTUAL
ACTUAL
BUDGET
ACTUAL
BUDGET
WORKSPACE
________________________________________________________________________________________________________________________________
PROFESSIONAL SERVICES --------------------4-160-3003 LEGAL SERVICES
4,800.00
4,900.00
5,000.00
3,292.75
5,000.00
-------------
-------------
-------------
-------------
-------------
4,800.00
4,900.00
5,000.00
3,292.75
5,000.00
4-160-6023 COUNCIL TRAVEL & CONFERENCE
350.00
1,305.00
4,500.00
5,232.25
2,500.00
______________
4-160-6028 EMPLOYEE & PUBLIC RELATIONS
1,137.14
0.00
0.00
0.00
0.00
______________
4-160-6055 MEMBERSHIP-DUES-PUBLICATION
2,597.00
2,465.00
2,600.00
2,465.00
2,600.00
______________
-------------
-------------
-------------
-------------
-------------
TOTAL PROFESSIONAL SERVICES
______________
OTHER SERVICES & CHARGES ------------------------
TOTAL OTHER SERVICES & CHARGES
** DEPARTMENT TOTAL **
** TOTAL EXPENDITURES **
4,084.14
3,770.00
7,100.00
7,697.25
5,100.00
-------------
-------------
-------------
-------------
-------------
8,884.14
8,670.00
12,100.00
10,990.00
10,100.00
=============
=============
=============
=============
=============
4,205,888.48
4,231,447.79
4,418,444.18
4,459,185.85
4,616,331.99
=============
=============
=============
=============
=============
*** END OF REPORT ***