HomeMy WebLinkAboutCity Council-Agenda Packets-8/3/2007-- City of Colleyville ColleyvilleaTexas76034
(8'17) 503-1000
"'"~`~~ Agenda www.colleyville.com
City Council
CITY COUNCIL BUDGET WORKSESSION
AGENDA
CITY HALL - EXECUTIVE CONFERENCE ROOM
AUGUST 3-4, 2006
AUGUST 3, 2006 - 6:00 p.m.
1. Call to Order
2. Review of the 2007 Budget Calendar
3. Presentation and Discussion of the 2006 Budget Projections
4. Review and Discussion of the FY2007 Budget
5. Adjournment
AUGUST 4, 2006 -12:00 p.m.
1. Call to Order
2. Review and Discussion of the FY2007 Budget
3. Adjournment
I hereby certify the above agenda was posted on the bulletin boards at City Hall on Friday, July
28, 2006 by 5:00 p.
<~~_~~
~~~
Cynthia Singleton, TRMC, CMC
City Secretary
Any matter on this agenda may, at the discretion of the governing body, be opened for public
comment and discussion.
If you plan to attend this public meeting and have a disability that requires special
accommodations, please advise the City Secretary at least 48 hours in advance at
817.503.1133, and reasonable accommodations will be made to assist you.
Ciry of Cofleyvilfe Page ! Printed on 7/28/2006
City of Colleyville 2006-2007 Budget Worksession -Page 2 of 71
City of Colleyville
Council Budget Worksession
The
here
Review of Budget
Calendar
City of Colleyville 2006-2007 Budget Worksession -Page 3 of 71
MEMORANDUM
Date: July 28, 2006
From: Terry Leake, Finance Directo
To: Mayor and City Council
Subject: Tax Rate Adoption Meetings
The adoption of Senate Bill 18 in the most recent regular legislative session brought forth a
number of changes in the procedures a municipality must follow in adopting a tax rate.
There is now a requirement for two public hearing to be held before a tax rate can be
adopted if the proposed tax rate is higher than the effective tax rate. For FY 2007, the
City's effective tax rate is $.3388 and the proposed tax rate is $.3474 (see attached
worksheet). To meet the meeting notification requirements and publish the required quarter
page ad notices, the first of the public hearings will need to be held on one of the following
days: Tuesday, August 29t", Wednesday, August 30t", or Thursday, August 31St. At this
public hearing the only item on the agenda is a public hearing to provide citizen comments
on the tax rate. The second public hearing on the tax rate, before its adoption, will be held
as a part of the first reading of the ordinance on the tax rate adoption.
At the meeting to adopt the tax rate, the new legislation requires the following:
"The vote on the ordinance, resolution, or order setting a tax rate that exceeds the effective
tax rate must be a record vote A motion to adopt an ordinance, resolution, or order setting
a tax rate that exceeds the effective tax rate must be made in the following form: "I move
that property taxes be increased by the adoption of a tax rate of (specify tax rate)." If the
ordinance, resolution, or order sets a tax rate that, if applied to the total taxable value, will
impose an amount of taxes to fund maintenance and operation expenditures of the taxing
unit that exceeds the amount of taxes imposed for that purpose in the preceding year, the
taxing unit must:
(1) include in the ordinance, resolution, or order in type larger than the type used in any
other portion of the document:
~~
(A) the following statement: THIS TAX RATE WILL RAISE MORE TAXES FOR
MAINTENANCE AND OPERATIONS THAN LAST YEAR'S TAX RATE."; and
(B) if the tax rate exceeds the effective maintenance and operations rate, the following
statement: "THE TAX RATE WILL RAISE TAXES FOR MAINTENANCE AND
OPERATIONS ON A $100,000 HOME BY APPROXIMATELY $(Insert amount)"
Attachments:
Tax Rate Adoption Planning Calendar
Effective Tax Rate Worksheet
City of Colleyville 2006-2007 Budget Worksession -Page 4 of 71
TAX RATE ADOPTION PLANNING CALENDAR
REQUIRED DATE ACTION
TUES JULY 25 CERTIFICATION OF TAX ROLL BY TARRANT APPRAISAL DISTRICT
WED AUGUST 2 PRESENTATION OF TAX ROLL/EFFECTIVE TAX RATE TO CITY COUNCIL
THURS AUGUST 3 CITY COUNCIL BUDGET WORKSESSION
FRI AUGUST 4
MON AUGUST 7 PUBLICATION OF EFFECTIVE TAX RATE
CITY COUNCIL MEETING TO DISCUSS TAX RATE; IF PROPOSED TAX
RATE IS GREATER THAN EFFECTIVE RATE, TAKE A RECORD VOTE BY
TUES AUGUST 15 RESOLUTION AND SCHEDULE A PUBLIC HEARING
NOTICE OF PUBLIC HEARING ON TAX INCREASE QUARTER PAGE AD
TUES AUGUST 22 PUBLISHED AT LEAST SEVEN (7) DAYS BEFORE PUBLIC HEARING
TUES AUGUST 29 OR
WED AUGUST 30 OR
THURS AUGUST 31 PUBLIC HEARING ON TAX INCREASE (CAN BE SCHEDULED ON ONE OF THESE DAYS)
SECOND PUBLIC HEARING; SCHEDULE AND ANNOUNCE MEETING TO
TUES SEPTEMBER 5 ADOPT TAX RATE ON SEPTEMBER 19
NOTICE OF VOTE ON TAX INCREASE QUARTER PAGE AD PUBLISHED AT
TUES SEPTEMBER 12 LEAST SEVEN (7) DAYS BEFORE PUBLIC HEARING
TUES SEPTEMBER 19 MEETING TO ADOPT TAX RATE
City of Colleyville 2006-2007 Budget Worksession -Page 5 of 71
FY 2007 EFFECTIVE TAX RATE INFORMATION
TAX RATE
2007 PROPOSED TAX RATE $ 0.347400
2007 EFFECTIVE TAX RATE $ 0.338817
2007 PROPOSED OPERATING TAX RATE $ 0.278730
2007 EFFECTIVE OPERATING TAX RATE $ 0.266758
2007 CALCULATED DEBT TAX RATE $ 0.068670
2007 ROLLBACK TAX RATE $ 0.356768
City of Colleyville 2006-2007 Budget Worksession -Page 6 of 71
Presentation of FY2006
Budget Projection
City of Colleyville 2006-2007 Budget Worksession -Page 7 of 71
GENERAL FUND PROJECTION OF YEAR END FUND BALANCE - FY 2006
PROJECTED
FY 2008
Beginning Unreserved Fund Balance - 10/1 $ 6,850,731
Total Revenues $ 15,395,156
Use of Available Cash $ 200,000
Total Expenditures $ (14,936,142)
Ending Unreserved Fund Balance - 9/30 $ 7,309,745
Net Increasel(Decrease) to Fund Balance $ 259,014
GENERAL FUND REVENUES
AD VALOREM TAXES $ 7,550,760
FRANCHISE TAXES 1,886,687
SALES TAXES 2,222,237
LICENSES AND PERMITS 1,528,336
FINES 624,700
CHARGES FOR SERVICES 749,386
INTERGOVERNMENTAL 77,565
MISCELLANEOUS REVENUES 423,128
USE OF AVAILABLE CASH 200,000
TRANSFERS-IN 532,357
TOTAL GENERAL FUND REVENUES $ 15,595,156
GENERAL FUND EXPENDITURES
City Council/City Secretary $ 508,295
Ciry Manager's Office 631,924
Legal Counsel 103,323
Communications 144,709
Finance 482,769
Municipal Court 243,630
Building Services 247,898
Information Services 169,848
Community Development 261,357
Building Inspections 311,744
Economic Development 166,280
Engineering 475,021
Police 3,352,077
Fire 3,202,334
Parks 1,175,444
Recreation 289,046
Library 505,819
Colleyville Center 343,276
Streets and Drainage 1,606,457
Fleet Maintenance 187,188
Capital Equipment Reserve 155,840
Merit Adjustment 371, 863
TOTAL GENERAL FUND EXPENDITURES $ 14,936,142
City of Colleyville 2006-2007 Budget Worksession -Page 8 of 71
Fiscal Year End 2006 Enhancements
REQUESTED
DEPARTMENT ITEM AMOUNT
Fire Department New Fire Hose $2,900
Fire Department Positive Pressure Fan $1,650
Fire Department Ventilation Saws (2) $1,200
Fire Department Portable Generator/Light Unit $1,325
Fire Department Cardiac Monitors $79,612
Fire Department Replacement of 1999 Ford Explorer $35,000
Fire Department Adjustable Folding Ladders (4) $1,700
Parks Department Park Administration Building Repairs $2,000
Parks Department Replace Locking Mechanisms at City Park $4,500
Parks Department Power Washer $1,500
Police Department Portable Radar Units (2) $3,100
TOTAL $134,487
*All items were requested by
respective departments in their
FY07 base budgets or BAF's.
City of Colleyville 2006-2007 Budget Worksession -Page 9 of 71
Review and Discussion
of the FY2007 Budget
City of Colleyville 2006-2007 Budget Worksession -Page 10 of 71
~ ~~~~ ~
Executive Summary
FY 2006 - 2007 Budget Message
The Combined Annual Operating Budget is balanced and a sustainable expense plan
Fiscal Year 2007. This budget meets the City Council priorities for service improvements
identified during the April 13, 2006 mid year budget update and the June 12 and 13, 2006
budget planning work session.
Being named 40~h "Best Places to Live" by Money Magazine in 2005 is something the
Council, citizens and employees are proud of. Regional magazines consistently rank
Colleyville in the top cities to reside. Overall revenues and effective fiscal expense
management continue to be strong for the city. Each of these indicators is positive for
Colleyville's continued success
All projections for the national, state and local economy show signs of continued growth
and strength. As a city located in the heart of the vibrant DFW metroplex, the local
economy, fueled by both residential and commercial construction, continues to steam
ahead. Continued residential growth will sustain retail and commercial development which
traditionally follow residential rooftops. While augmenting overall revenue growth, retail
development for Colleyville will be secondary to managing a strong residential tax base for
a reliable and long term source of revenue.
Aligning Resources to Community and Organizational Needs
Having an annual budget is a means to communicate about the municipal services we
provide, the quality of those services and the value of those services to our customers. In
companion to their respective expense plans for the ensuing year, Department Managers
have prepared performance measures as a part of the budget that describe their core
annul service activities for this next year.
The accompanying budget has been formulated by reflecting on the Council strategic
vision of being a model city with attention to being an efficient and attractive neighborhood-
orientated community sensitive to its history, resources and residents. Preparing an
expense plan allows the Council to steer the course toward this strategic vision in aligning
municipal resources with community needs, in keeping with the Government Finance
Officers Association of the United States and Canada (GFOA), by:
^ Describing the policy priorities of the City,
^ Determining the City's services and capital projects required to address the policy
priorities by establishing a financial plan,
^ Serving as a guide to the operations of City services, and
City of Colleyville 2006-2007 Budget Worksession -Page 11 of 71
^ Providing the communication vehicle depicting service performance measures and
fiscal controls to permit evaluation of and adjustments to the City's performance.
The budget allows the Council to align municipal resources to our changing needs. In
preparing the budget, attention was given to accomplishing seven broad goals developed
as part of the June 2006 budget planning discussion, which included:
~ Economic Development
•l Public Works
+~ Public Safety
~ Fiscallntegrity
,4 Recognition of Paid and Volunteer Resources
~ Community Relations
>•- Leiscrre Services
This budget addresses these goals by funding major projects, adding staff and setting
programs in place that will enhance the quality of life for Colleyville residents. These goals
and our continuing need to ensure that everything we do is sustainable in the long run
have guided the development of this budget. Adherence to these goals is extremely
important as the City continues to grow. It is our intent to continue to provide the level of
service that our residents have come to expect.
The Annual Budget in Brief
Every year the budget development process begins with an assessment of our revenue
base. Next, the proposed expenditure plan for services and capital projects is prepared by
the Department Managers under the direction of the City Manager. Those departments
seeking changes to their base budgets or service levels are required to submit a
supplemental request (known as Budget Adjustment Form") to the City Manager for each
change. As you can imagine, there are many more departmental needs than we have
funding available.
The total combined City revenue for all Funds is estimated to be $32,038,823 million in FY
2007 offsetting a combined total expenditure proposed for the various Funds of
$31,212,935. The proposed budget is not without its issues as we must deal with higher
costs for competitive salaries, health care, fuel, and utilities. In meeting these challenges,
there is no call for increasing the property tax rate or the utility billing rates.
City of Colleyville 2006-2007 Budget Worksession -Page 12 of 71
Developing the budget requires attention to growth in citizen service needs, inevitable
overhead adjustments, and the size (and scale) of our direct casts increasing as we get
larger. Price increases for utilities, fuel and other commodities have strained department
budgets in the past year and are expected to continue during the upcoming year.
Additionally, increases in employee retirement contributions, health insurance, and wage
adjustments will absorb a sizeable amount of expected revenue growth.
Reserve Fund
The General and Utility Funds will maintain a minimum restricted reserve (undesignated
fund balance) in accordance with the Council's adopted Financial Principles. The reserve
earns interest, smoothes cash flow and is ready for unanticipated expenditures or
emergencies. As anon-recurring revenue source, beginning fund balances are used to
fund capital or other non-recurring expenses.
Conclusion
As you review the budget, attention is directed to the combination of resources we are
applying for street maintenance, the emphasis on customer service, our commitment to
employee compensation and the provision of employee tools, equipment and training to
allow them to better serve the public.
The FY 2007 Annual Budget has been posted on the City website for citizen accessibility.
A community town hall meeting will be held on August 12, 2006 allowing an opportunity for
citizens to provide comments on service needs for the upcoming fiscal year. Citizens are
encouraged to review the Budget and if they have any questions or need additional
information to contact Stephen Seidel, Budget and Administrative Manager, at 817-503-
1112 or by a-mail at seidels~ci.colleyville.tx.us.
Appreciation goes to the Council for their community leadership and strong financial
acumen. An acknowledgement goes to the Department Managers and staffs for their work
City of Colleyville 2006-2007 Budget Worksession -Page 13 of 71
in preparing the departmental budgets and performance measures. A special thank you is
extended to the Budget Team staff including Terry Leake (Finance Director), Kelly Cooper
(Human Resource Manager) and Stephen Seidel (Budget and Administrative Services
Manager) for their efforts in building this municipal budget.
City of Colleyville 2006-2007 Budget Worksession -Page 14 of 71
FY2007 De armental BAF Re nests
REQUESTED
DEPARTMENT REQUEST AMOUNT FUNDED
FUNDED BAF's
PERSONNEL
Information Services Desktop Support Specialist $42,566 Yes/FY07
Police New police officer position $63,998 Yes/FY07
Police New police officer position $63,998 Yes/FY07
Police 1 FT PSA position $37,354 Yes/FY07
Parks Parks Maintenance Worker 534,731 Yes/FY07
Library Circ/Tech Services Library Assistant (PT) $18,978 Yes/FY07
Building Services Building Maintenance Tech I $61,400 Yes/FY07'
`
Building Inspection Code Enforcement Officer $32,635 Yes/FY07
`Reallocation of existing personnel
PROGRAMS OR ENHANCEMENTS
Building Inspection Building Permit Software $70,000 Yes/FY07
Parks 8leacherlscorekeeperstend shade cloth replaceme $40,000 Yes/FY07
Parks Kidsville playground repair and renovation $10,000 Yes/CEDC
Parks Playground safety signs at City Park, Woodbriar $6,000 Yes(CEDC
Parks Field maintenance entry improvements $11,500 Yes/CEDC
Fire Driveway Extenstion in rear entry of Station 3 $10,000 Yes/Capital Projects Fund
EQUIPMENTICAPITAL
Fire Cardiact Monitors w/ Waveform Capnogrpahy $79,612 Yes/FYE06
Fire Replacement vehicle for 1999 Ford Explorer $35,000 Yes/FYE06
Information Services Quantu DLT S4 Tape Drive $5,250 Yes/FY07
Engineering Digital Archiving System $20,000 YeslFY07
Fire Set of hydraulic rescue tools $30,202 YesFY07
Library Automated material checkout $30,000 Yes/FY07
Parks Picnic tables $6,000 Yes/CEDC
NON-FUNDED BAF's
PERSONNEL
Library Technical Services Librarian (FT) $52,560 No
Engineering Intern $20,000 No
Parks Parks Crew Leader 544,192 No
Parks Irrigation Maintenance Worker 534,731 No
Fire Deputy Chief of Operations $161,227 No
Recreation Recreation Aide $10,710 No
Recreation Athletic Coordinator $57,011 No
Recreation Senior Center Supervisor $62,389 No
PROGRAMS OR ENHANCEMENTS
Parks City Park entry planting bed renovations $35,000 No
Parks Uniform park signage $150,000 No
Fire Firefighter Development Program $54,500 No
EQUIPMENTICAPITAL
Recreation Pickup Truck $22,800 No
Parks Utility vehicle replacement $9,100 No
Fire Replacement vehicle for 1991 Ford Pickup $33,350 No
Fire Off-Road/Trail Patient Vehicle $10 000 No
City of Colleyville 2006-2007 Budget Worksession -Page 15 of 71
FY06-07 Agency Funding Requests
2006 2007 2007
AGENCY BUDGETED REQUEST RECOMMENDED
Arts Council of Northeast Tarrant County $7,100 $10,000 $7,100
Alliance for Children $3,500 $3,927 $3,500
Safe Haven, Tarrant County'' $1,000 $1,000 $1,000
Project Graduation (CHHS/GHS/KHS)"' $2,200 $2,000 $2,200
Meals on Wheels $10,000 $10,000 $10,000
Mental Health, Mental Retardation of Tarrant County $1,000 $1,000 $1,000
GRACE $1,200 $1,500 $1,200
Special Needs Assistance Partners (SNAP) $1,000 $4,800 $1,000
Colleyville Area Chamber of Commerce $0 $7,050 $5,000
TOTAL $32,000
"Formerly Women's Haven of Tarrant County and
Women's Shelter (the agencies merged). FY06
Budget allocated $500 per agency.
**Keller High School Project Graduation did not
submit a request for FY07.
City of Colleyville 2006-2007 Budget Worksession -Page 16 of 71
FY 2007 REVENUE ESTIMATE
GENERAL FUND
AD VALOREM TAXES
5101-CURRENT TAXES
5102-DELINQUENT TAXES
5103-PENALTY & INTEREST
TOTAL AD VALOREM TAXES
FRANCHISE TAXES
FY 04 FY 05 FY 06 FY 06 FY 07
ACTUAL ACTUAL BUDGET PROJECTED PROPOSED
6,929,327 7,349,837 7,440,760 7,440,760 8,015,166
73,920 66,474 65,000 65,000 65,000
63,390 65,566 45,000 45,000
°--°----°-------- -°- 45,000
•-----°•----------
--°-------------------- ----
7,066,637 -------------------- ----
7,481,877 -------------------- ----
7,550,760 7,550,760 8,125,166
5207-TXU ELECTRIC 765,142 775,974 814,003 841,672 892,263
5202-TRI-COUNTY ELECTRIC 57,513 69,654 76,000 85,963 95,000
5203-ATMOS GAS 253,519 235,814 200,000 334,347 270,000
5204-SOUTHWESTERN BELL 105,715 107,824 107,165 111,500 114,000
5205-VERIZON/OTHERS 57,325 54,623 60,600 57,000 59,500
5206-GARBAGE/RECYCLING 96,844 99,153 99,000 100,250 101,400
5207-CABLE TV 122,021 140,995 135,000 155,955 161,000
TOTAL FRANCHISE TAXES 1,458,079 1,484,037 1,491,768 1,686,687 1,693,163
SALES TAX
5301-1%SALESTgX 1,749,874 1,968,639 1,927,661 2,145,817 2,210,191
5302-MIXED BEVERAGE TAX 37,296 53,974 63,000 76,420 80,000
TOTAL SALES TAX 1,787,170 2,022,613 1,990,661 2,222,237 2,290,191
LICENSES & PERMITS
5411-BUILDING 962,702 887,041 850,000 1,004,887 1,006,396
5412-PLUMBING 173,262 125,244 105,919 121,503 122,064
5413-MECHANICAL 0 40,264 40,000 58,830 59,230
5414-ELECTRICAL 108,149 95,167 91,000 99,917 102,158
5416-CITY LICENSE 59,330 55,775 55,000 57,349 57,273
5417-BUILDING PLAN REVIEW FEE 169,150 125,360 150,000 155,000 155,839
5418-NEW BUSINESS 2,820 3,666 3,000 3,000 3,384
5419-ANIMAL 1,824 1,907 2,000 1,700 1,750
5420-SIGN PERMITS 8,585 5,555 7,500 6,900 6,650
5421-FENCE PERMITS 7,640 7,800 7,000 7,250 7,500
5423-FIRE PERMIT FEES 12,050 11,550 9,000 12,000 12,000
TOTAL LICENSES & PERMITS 1,505,512 1,359,329 1,320,419 1,528,336 1,534,244
FINES
5611-FINES 477,595 458,098 650,000 575,000 565,000
5612-FINES-ALARMS 1,400 1,450 35,000 30,500 35,000
5630-LIBRARY FINES 10,547 17,982 14,500 19,200 20,400
TOTAL FINES 489,542.
Clty 477,530 699,500 624,700 620,400
of Colleyville 2006-2007 Budget Worksession -Page 17 of 71
FY 2007 REVENUE ESTIMATE
GENERAL FUND
CHARGES FOR SERVICES
5511-PLANNING AND ZONING
5512-PLAT FEE
5514-BOARD OF ADJUSTMENT
5711-SALE OF MATERIAL
5712-WEED MOWING
5718-ANIMAL IMPOUNDMENT FEE
5721-AMBULANCE
5722-RECREATION PROGRAM
5811-ENGINEERING & INSPECTION
5812-CHGS & REIMBURSEMENTS
5845-LOT DRAINAGE INSP FEE
5855-FIELD USE CHARGE
5873-COLLEYVILLE CENTER FEES
5874-NON-RESIDENT FEE
5875-LIBRARY BLGD RENTAL
TOTAL CHARGES FOR SERVICE
INTERGOVERNMENTALREVENUE
5828-DARE OFFICER REIMB
TOTAL INTERGOVERNMENTALREVENUE
MISCELLANEOUS REVENUE
FY 04 FY 05 FY 06 FY 06 FY 07
ACTUAL ACTUAL BUDGET PROJECTED PROPOSED
13,350 11,077 11,059 11,892 11,939
20,832 21,982 15,000 21,777 21,799
1,625 1,800 1,500 1,500 2,000
1,839 2,500 2,000 3,000 2,891
3,222 2,005 3,740 1,417 1,954
2,185 4,715 2,889 3,480 3,350
113,935 119,361 190,000 211,955 216,000
150, 923 138,650 134,695 134, 695 137,625
113,596 94,064 100,000 100,835 80,000
6,783 7,002 6,000 3,500 3,500
36,875 31,250 28,625 32,750 30,625
24,120 21,535 21,760 21,000 21,760
195,223 193,971 183,000 187,000 190,000
18, 380 14, 270 18, 530 14, 500 14, 500
125 250 300 85
------°------°- ---° 100
-------------------
------------------------ -----
703,013 ------------------- -----
664,432 ------------------- --°-
719,098 --
749,386 738,043
70,355 73,872 77,565 77,565 81,443
---------- ------------------------ ------------------------ ----------°------°---- -----------------------
70,355 73,872 77,565 77,565 81,443
5714-SALE OF SURPLUS PROPERTY 11,600 0 10,000 22,903 10,000
5716-INTEREST INCOME 107,912 193,398 276,250 281,000 382,500
5719-MISCELLANEOUS 25,368 47,707 53,000 42,000 45,000
5832-ANTENNA LEASE 62,126 82,324 56,500 68,275 68,275
5866-CELEBRATE CV CONT 8,100 8,950 0 8,950 0
5790-USE OF AVAILABLE CASH 0 0
-------- --- 200,000
-------------------- ---- 200,000
--°°------------° ---- 145,250
-----------------
--
TOTAL MISC REVENUE ---------°----------- ----
215,106 ------------
332,379 595,750 623,128 651,025
TRANSFERS IN
5872-T-FER FROM UTILITY FD 473,366 464,393 491,025 532,357 544,701
5873-T-FER FROM CAPITAL PROJECTS 0 0 0 0 0
TOTAL TRANSFERS IN 473,366 464,393 491,025 532,357 544,701
TOTAL GENERAL FUND REVENUES 13,768,780 14,360,462 14,936,546 15,595,156 16,278,376
City of Colleyville 2006-2007 Budget Worksession -Page 18 of 71
FY 2007 REVENUE ESTIMATE FY 04 FY OS FY 06 FY 06 FY 07
ACTUAL ACTUAL BUDGET PROJECTED PROPOSED
UTILITY FUND
OPERATING REVENUES
5817-WATER SALES 5,732,210 6,935,045 6,967,199 7,189,600 7,152,284
5818-SEWER SALES 2,007,678 1,937,571 2,111,144 1,888,750 2,173,056
5821-SEWER INSTALLATION 39,400 34,700 16,000 35,000 22,900
5822-WATER iNSTALLATiON 68,418 62,635 44,800 56,000 44,800
5827-ENGINEERING 8 DEV 70,649 42,213 35,000 40,000 35,000
5829-SEWER TIE-ON CHARGES 21,408 12,064 10,000 12,000 5,000
5833-PENALTIES 140,211 144,905 181,567 173,566 153,730
5839-MISCELLANEOUS REVENUE 13,685 14,448 9,300 13,500 10,000
TOTAL OPERATING REVENUE 8,093,659 9,183,581 9,375,010 9,408,416 9,596,770
NON-OPERATING REVENUE
5716-INTEREST INCOME 209,189 251,060 285,000 268,750 300,000
TOTAL NON-OPERATING REVENUE 209,189 251,D80 285,000 268,750 300,000
TOTAL INCOME 8,302,848 9,434,661 9,660,010 9,677,166 9,896,770
City of Colleyville 2006-2007 Budget Worksession -Page 19 of 71
FY 2007 REVENUE ESTIMATE FY 04 FY 05 FY 06 FY 06 FY 07
ACTUAL ACTUAL BUDGET PROJECTED PROPOSED
DRAINAGE UTILITY FUND
OPERATING REVENUES
5942-DRAINAGE FEES 643,986 663,925 798,000 798,000 825,636
5833-PENALTIES 9,953 10,610 13,965 13,965 14,449
TOTAL OPERATING REVENUE 653,939 674,535 811,965 811,965 840,085
NON-OPERATING REVENUE
5825-INTEREST INCOME 16,283 19,079 22,000 29,880 31,500
TOTAL NON-OPERATING REVENUE 16,283 19,079 22,000 29,880 31,500
TOTAL INCOME 670,222 693,614 833,965 841,845 871,585
City of Colleyville 2006-2007 Budget Worksession -Page 20 of 71
CO h N O N M CO CD N N O Q) h V ~Y CD CO 0 0 a7 0 N
h O~ O N N O V~ N M M d7 N O O ~l 0 0 00 ~t O N
J 6? O~ N O O CO O O rt CO l(') N O O) N 00 N~ to CO ~ O ti
Q 00 O r CO O) a7 M A N CCU h N 00 CD N O M h V tf) h
O C O h d' ~ O O O h M CO N ~t d7 lI') ~t a0 M o0 CD ~ In M h
to M r l1) ~ ~ Ln u7 N C'7 CO M h N e- M r N r lD N N r N
H M M r r ~
6H
~ O 00 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 O O
J ~ O M O N
F- ~ M ~ d0'
h O h~ O M M GO O N N M O h h 00 O CO
~ O t0 O CO LCi ~ CO 1~ h O h O c0 M CD h O tf)
(D N r 0 0 O h l(') ~ r M U') CO O r In O CO r N
h (D h 0 CD 00 (fl O M O h~ O to O In 0 0
r r N 7 00 ~~~ In d r r r ~'
C9 J In N d' O N M N M O O ~ O '7 O~ O M [t O O h
Q Q Cp Cp d7 N lf') N CO d' O O m r D) N lf) h N N M N
CO O CO M ti c0 ~ M 6~ N O h r h 0 0 0 O M ~ h
(j~ ~ W ~t 1~ O CO d7 CO N h CO ~ O M (O N V' 6] M [D (O f~ (D
U V ~ N tt ~~ O N M N COD dam' CD N N M 00 ~ r' r N O
W Q~ r r r
N 0. O N
O V
Q d J O N 00 OD CD 00 O to M W O M CD R H O O CD
W W ~~ COO O W M V h 00 In O N d' h h M N 0) r
r~ N O C/i V Ln O O O N~ 01 h
~- Z Cp ~ ~j ~~ ~fJ M 0 0 0 M M N 00 M M M h ~-
J O O N N V N N C O CO N O r h~ ~t O CD ~
d' N r r N ~' V N~ r O In r N r N r ~
Q ~ N M
V W
N a
LL' avo~nrnMD~rhvh~hcDrncDOOmMCOCOO N
N V' 07 O CD N N N M h~~ d' O h M N (D O V C d'
I.,, Q Q) h N N h M M O M M O V d' O t~ N CO r O O M 0 ~
W r r CO 00 N M CfJ ~ ~ N N I.C) CD Q1 ~ M M h h a7 ~ O
F- M CD O CO O O h CD O to h 0 00 '~? V ~ O h~ O lf7 M
W O CD M r lC) [f r In V N N M r CD N r M N r M N r r ~
F- M M r r ~
~ ~
O Q~ 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0
~ Q = O h
~ W V O
(n '~ N O O O h h O) M t(] h N N h d7 O O r d1 0 0
J CO ~ O~ Cf) V 00 h O W M d1 M d1 N O d1
F- Q W ~n~Dmr~r rnc~r~rnr~m~ocov_ D)r cD~n
~ V a oco~ri~v NvCOaoOOO'»chn~~`t ao~ri o~
cn d r h '- r
~ w ~
w `n
m J r Q1 O O M M d7 h CO N O r CD CO h h O rf O 00
',,,,, 0 Q N M N r O N CD CD d7 O h In N N M N O d7 Q)
00 W M '~ N M ~_ d~ O? cD N O r~ N N Q) O N h
Z ~ = N r d' COO ~ M CC7 CD h W 00 d1 t(7 N ~ h ~ ~ O
W m U V h N M to M O 00 M N ~ Ntt ~ N N N 0~ M r N h
M r r
~ W ~ ~
a ~ o `~
Q a U J R ~f') N N to M tf) O h 0 r O M M 07 O tf) O O h
W O r h N Q) O h O V O M O O In CD
Z ~A N CO r M N M Ln N 40 ~ lC) tC) O CO h 0 ~
Z O O r (~ d' O 00 h I.n r d) ~ CD ~ CD h M
O d' O N M M O O N d' CO h M r f~ V O (D O
y In N r ~- M C M N Ln M Ln O r N r r
~ N N
W
a
~ a>
~
~ c
N
O
ro E ~
C d fn
a
~
O
U
~ ~_
~' ~
U N U C
~
~ ;~'
~ > m O
c °' ~ 'C ~ ~ Z ~
c '
a
~
~
i
U a
i ~ U
N ~
_ ~
~ ~
C i o o
~
a
n
U U N U C N C 6
Y
'
C U rr ~
C .~ C
O ~C ~ ~' (p '(Q O ~ '~ w
`
~ p
O ~ 0 0 0 7 0 0 0 3 (6 O
~ 7 U `
C N
o m w o ii ~ .
-~ C
~ w ~vro f~ 6'DI~G~~~~D~2B(k~ PA~~n~/t~a
N
D7
7
CD
U
c
.~
O
a>
C
3
0
U
U
r
0
}
0
21 of 71
ti
O
o.
N'
Q
W
J
a
a
F
'W
V
O
m
F-
Z
W
G
1...
Q
a
w
v
rncNOGOm~o°ocCOO ti
J r-vin r.oco M
Ia- ~ N O O V N O M
0 N d' O •-- to W M M
~ O O
7' 000
g ~~
I- ~ N
~ N
O (O O
V V O'~
to h O
O ~ ~
M M
UIIo ~ ~
W ~ M ~
> I 1 ~n
W
r o
~f7 O M
r (O ~
O ~ O
r N M
N to V ~ ~ O M Of
O~ tf) N N O M ~Y
CD f~ CO 01 O O I~ O
N O O r ~!7 M
O ~ ~ O ~ ~ ~
~ O
~ O O Q
g
0
~ ~~o
w u, ~ ,n
J r ~ CV
d M ~
a
U~Iti rn Oa
Lll O CO M
m
~~I ~
a~~
o~nv
v ~ v
v o r~
00 00 M
r r M
C
E
>.
a
roa
C •U `
r
7
~ C N
U1 ~ Q. C
O t -O ~
~ O o N
m
c ~ o m E
mo~~?a ~
T T._ N ~a
~- C > C a
f-
O
~~~F-gym ~
City of Colleyville 2006-2007 Budget Worksession -Page 22 of 71
o~ o u~ o
00 0 0 ~
r~oti o
d" o rS v
m o
>-
Q
J
F-
r
d
u. ~
J O
W ~ fn ~
O U U N
a Q~
ti ~
o a O N
N U
~ Z
u' 07 M O M O ~
~00 O
O
~
F
W C
O
J
f" OOCOO i0 t~0
W
= O ~ r' ~
F...
~
a J ~, O
~g
~ ~ aj
N U Q
~ `Q W r
N
W
t9 }
~ -~ ~">
a4'. ~
~
~ U ~
m
Z N
~
J o
~ ~
W W
H U V
~ O ~ ~
Q Q z~
a
U
W
Z N
O M
rn
rn
«- c
N o
~m
iv ~
c ~
~ - c
Z a~i c >
~ >,EtY
I- ~ ~ ~ ~' N
Q' ~ ~ ~ d m J
Q
C_ +_ ~ -p C Q
W ~ ~ ~ ~ ~ H
p ~~JCO~ O
City of Colleyville 2006-2007 Budget Worksession -Page 23 of 71
~noooo~noooo 00
Op In r ~ O O ~ O CU
M N
~
h
O
J CO
~' ~ N
~ ~
r tD O ~t M
G
N Q r N
~ ~
~
Q
W ~
}
J
Q
~ U
o cn o
~D o 0 00 ~n o 0 0
p V- E- N O I~ 00 N N r 0
~ OJ lD r f~ O O V' O
W (NOOMN ~'ti N~
N ~ r r to O d
W a Q ' r
>- O a
J d m
U p'
N
ti
'
~ ) O M~ O M
0 0 0 r L(
M 1~ O N O N N O N
~
W p J ' ~ N
0 M~ ~
~
C
a d
r
N l
- ~ N
cn a o
~'
r
~ a
~ V
~ ooor~noM~o
N M 0
M
~ Z Lq
O O~
N
W W
~
CND M ~ ~ ~ ~' N ~
~
W a Q
0
(7 -
^ p m
a .
m w
^ :
H
Z
W
~ a ~
g
~ .
`~ o
W , m m o.m a~
X
m~ ~
~ m c
O
F' rn O a~
-° ~ ~ o `
w ~ N
~ c cn a~
W a~ ~ ~ ~ ~ ~ cn ~
a
'
J
:023 m m
0
.~?
A N
0 ~ ~ V~~
~
W
N j
Q
'C7C7C7UC7U ~ rn ~
f- V (DOOrN~t.C Q
O O O
m
W O O O
~ N W F.
"O O O O O O
r r r N N C~ Q d Q
0
City of Colleyville 2006-2007 Budget Worksession -Page 24 of 71
?uxeleea 1?eig~Eo~eada~~xce~rtlo.~al r~co~e
FY 2006 - 2007 Budget Message
Honorable Mayor and City Council;
I am pleased to present the FY 2007 Combined Annual Operating Budget for the City of
Colleyville. This budget represents a continued commitment to prudent fiscal management
while enhancing services to improve the quality of life and meet expressed needs in the
community.
Introduction
While this budget does not fund all departmental requests, it meets the Council priorities
for service improvements identified during the April 13, 2006 mid year budget review and
the June 12 and 13, 2006 budget planning worksession.
This budget supports, among other efforts: public safety, code enforcement services,
public works, parks and recreation, library and utility services. The FY 2007 Budget has
been formulated by reflecting on a philosophy of:
~: Providing solid governmental services centered with a focus on quality;
;; Valuing our employees;
;: Remaining fiscally sound;
:i Pursuing opportunities to partner with other public providers; and
:: Effectively allocating resources to meet citizen needs.
Accounting Integritx
The budget is balanced and prepared in accordance with State law, the Colleyville City
Charter and the budget policies. The budget has been prepared in accordance to
provisions outlined within the Governmental Accounting Standards Board (GASB)
"Statement No. 34, Basic Financial Statements -and Management's Discussion and
Analysis -for State and Local Governments" (GASB 34).
The accounts of the City are organized on the basis of funds or account groups, each of
which is considered to be a separate accounting entity. All funds are budgeted and
accounted for on a Generally Accepted Accounting Practice (GAAP) basis for purposes of
financial statement presentation. The Governmental Fund types use a financial resources
measurement focus and are accounted and budgeted for using the modified accrual basis
of accounting. Under the modified accrual basis, revenues are recorded when susceptible
to accrual, i.e., both measurable and available. Available means collectible within the
current period or soon enough thereafter to be used to pay liabilities of the current period.
Expenditures represent a decrease in net financial resources and, other than interest on
City of Colleyville 2006-2007 Budget Worksession -Page 25 of 71
general long-term debt, are recorded when the fund liability is incurred, if measurable.
Interest on general long-term debt is recorded when due.
Governmental fund types are those through which most governmental functions of the City
are financed. The acquisition, use, and balances of the City's expendable financial
resources and the related liabilities (except those accounted for in the Proprietary and
Fiduciary fund types) are accounted for through Governmental Fund types.
The Proprietary Fund types are accounted and budgeted for on a cost of services or
"capital maintenance" measurement focus, using the accrual basis of accounting.
Proprietary fund types operate in a manner similar to private business. The City utilizes
only the enterprise fund type. Under the accrual basis of accounting, revenues are
recognized when earned and expenses are recognized when incurred. For purposes of
this budget presentation, depreciation is not displayed and capital expenditures and bond
principal payments are shown as uses of funds.
Goals for the Budget
In preparing the budget, the primary budget goal is to achieve identified objectives that
maintain and improve City services for the citizens. During the June 12 and 13 budget
planning session, the Council identified seven organizational objectives used as the
cornerstone in the development of the budget. Work initiatives having a direct fiscal
impact in the preparation of the budget include:
,L To make Colleyville more prosperous through economic development efforts
towards a balance between commercial and housing components of the overall tax
base with a focus on promoting the city as a place for unique and boutique retailers
offering the city as a destination place.
^ Increased dedicated resources for new business development
• Creation of strategic & tactical plans for SH26 redevelopment and
development of the Precinct Line corridor
• Continuation of promotional advertising with trade publications and
attendance to national and regional trade shows.
~ To have an infrastructure system properly maintained and funded providing
effective management meeting citizens service demands and expectations with
special attention towards enhancement of the maintenance and reconstruction of
streets.
• Continued funding and partnership with Tarrant County for street
improvements
• Preparing a traffic calming study
^ Improved traffic enforcement with school zone speed signs
~ To provide efficient and user-friendly services that maintains the city as a safe,
secure, clean and attractive community for family and business.
• Recruitment of quality police and fire personnel for vacancies
^ Hiring of two patrol officers and a warrant officer
City of Colleyville 2006-2007 Budget Worksession -Page 26 of 71
• Enhanced traffic enforcement for city streets with additional patrol
officers
^ Increased training in technical fields and supervisory activities
^ Replacement of an ambulance by lease-purchase
To bring the financial picture into balance by identifying expenses and revenues that
sustain city growth and support service levels, while maintaining strong fiscal
accountability and financial stewardship.
^ Hiring of a Utility accountant
• Initiating a staff evaluation for new financial software package
^ Review funding requirements for the City's TMRS obligation as
impacted by retiring employees
~I. Effectively utilize and promote Colleyville's paid and volunteer human resources.
^ Implementation of the Workforce Development Program
^ Continuation of volunteer appreciation events for Board and
Commission members
~ To have a progressive city that values citizen involvement/communicafion and
strong community organization relationships.
• Communication improvements throughout the City including broadcast
and web cast of all Council meetings
^ Utilize an envelope mailing system for utility bills to offer customers
information on various City services and programs
~ Develop, expand, and promote leisure activity opportunities for the citizens.
• Hiring of a maintenance employee
^ Maintenance of shade covers for ball fields
The Budget Challenge
The continuation of sound financial and operational philosophies has guided the
development of the budget for the upcoming year. By its very nature, the preparation of
any budget is the allocation of scarce resources. There will always be more needs than
available funds. With this recognition, the preparation of the FY 2007 Budget includes:
^ Operational costs being scrutinized carefully to ensure the necessity of each
expenditure in the context of the current service delivery and financial environment;
^ Programs being evaluated for potential adjustment where associated activities may
have declined;
^ Appropriate fund balances being maintained; and
^ Quality of service delivery for basic services, and secondarily of popular programs,
being a high priority for continuation and/or expansion.
Future budget expectations
In reviewing the expense plan for the coming fiscal year, the Council will want to give
consideration to several emerging areas of expenses to be addressed in succeeding
budgets. The proposed FY 2007 Budget was able to avoid these costs due to completion
deadlines and managing program services.
City of Colleyville 2006-2007 Budget Worksession -Page 27 of 71
Remodeling of the recently acquired building for a new Senior Center is anticipated to be
complete in the fall of 2006. With the opening of the new facility, minimal budget impact
has been anticipated for FY 2007 given that funding currently exists for a similar facility
where services will be transferred to the new site. Operating hours are scheduled for only
twenty hours per week for FY 2007. Recognizing the viability and popularity of the new
facility, it is anticipated that the FY 2008 Budget will need an adjustment of $93,000 for
extended operating hours and programs. The projected FY 2008 funding to operate and
maintain the Senior Center for a full weekly service includes:
• Personnel cost- $58,000 (Senior Center Supervisor)
• Contractual services- $30,300
• Supplies- $4,700.
McPherson Park (Phase I) is scheduled to open in late Summer 2007. Phase I includes
approximately 16 acres of the 27 acre park. Projected FY 2008 funding to operate and
maintain McPherson Park will be approximately $130,000. A breakdown of these costs
include
• Personnel cost- $30,000 (Parks Maintenance worker)
• Contractual services- $53,100
• Supplies- $1,900
• Capital outlay- $45,000 for a truck and utility vehicle.
As a component of the FY 2007 Budget, staff will be preparing a comprehensive staffing
study. This special study should be complete by the third quarter of the fiscal year to
enable the Council evaluation of operational needs. Identified staffing needs will be
incorporated into the five year budget forecast for future Council consideration and
evaluation.
The Library Department initiated an update to their strategic plan during this current fiscal
year and is scheduled to be complete by spring 2007. The update will in part evaluate and
recommend utilization of the second floor area of the library. While no anticipated budget
impact has been identified at this time, it is reasonable to anticipate additional staff and
programs being proposed to assist in the implementation of the strategic plan update.
Managing efficient services
An ongoing means of funding City operations is to aggressively look at other area
governments to maximize economy of scale for cost savings. As with past years, part of
the budget approach is to embrace the concept of partnering with other governmental
units, with the guiding principal that it should meet the BEE test (beneficial, economical
and efficient) for Colleyville.
The projected budget proposes to contract for services with other governments in the
following areas:
City of Colleyville 2006-2007 Budget Worksession -Page 28 of 71
Street Overlay:
To maximize street maintenance, the City will continue partnering with Tarrant
County. The County has phenomenal street overlay capabilities and has shown a
strong interest in assisting our maintenance program.
Elections:
The City will continue to contract with the Tarrant County Elections Administration
Department to conduct local elections. The efficiency and expertise provided by the
County enhances the quality of the electoral process available to the citizenry.
Building Maintenance:
We will continue to contract with Tarrant County for janitorial support services for
the Colleyville Justice Center, the Colleyville Public Library and the Colleyville City
Hall.
Public Safety:
Continued participation with the Metroport Teen Court is funded jointly with the
cities of Colleyville and Southlake. Funding is also provided to meet the contractual
obligations of the Bedford Response Area. The City proposes to continue a
partnership with the GCISD and KISD for partial funding of School Resource &
DARE officers.
Regional Transportation:
The expense plan continues funding with the Trinity Railway Express (TRE) for
residents' participation with the regional mass transit authority.
GCISD:
We will continue to focus work efforts with the District for printing, tax collection
services and use of recreational facilities to maximize our operating budget.
Economic Development:
Continuation in partnering with the North Central Texas Council of Governments
(NCTCOG) hosting a website offering property information in support of our
economic development efforts. City infrastructure information, mappings and
property information is provided on the site. Contracting services for GIS related
mapping information for aerial photography with the NCTCOG for public works and
economic development will be continued for the seventh year.
Revenues
The development of the FY 2007 budget started with an evaluation of available revenues.
A few points in assessing revenue opportunities were:
Conservative sales tax growth of 3% provided by new retail starts
Increase in investment earnings to 4.5%
Anticipating 245 housing starts in FY 2007 compared to 229 budgeted for FY
2006.
Franchise utility revenue increase of 13.5% for the increased cost of energy.
City of Colleyville 2006-2007 Budget Worksession -Page 29 of 71
Property Tax Revenues
A major budgetary observation in preparing any governmental budget is setting the
property tax rate. Once the roll is received in late July, the tax rate is determined based on
both the debt rate needed to pay for the City's bonded indebtedness and funds needed for
maintenance and operation funding in the General Fund. Consistent with the last thirteen
years, there is no proposed adjustment to the property tax rate for this next year.
The main source of income for the City is property taxes, which account for 50% of our
total revenue. The Tarrant Appraisal District has rendered Colleyville's property valuations
for FY 2007 at $3,062,340,646, which includes the TIF District valuation of $157,692,034.
This is 4.2% higher overall than last year's TIF District valuation and 208% from base year
1998.
Focusing attention for home ownership of citizens aged 65 and over, the City Council
approved in 2004 the Senior Property Tax Freeze and increased the Over 65 Property Tax
Exemption to $65,000. Property tax revenues may be adversely affected in future years if
state legislative efforts are successful in decreasing the current 10% cap on residential
appraisal growth. Growth caps of 3% and 5% for local government property appraisals
have been discussed.
Tarrant County witnessed a 9% growth in overall valuation growth compared to
Colleyville's 7%. While general public sentiment is that there may be "runaway"
reappraisal growth, a review of the data actually reveals that new construction growth
historically has outpaced reappraisal growth for Colleyville. The increase for existing
Colleyville residential valuation was only 2.5% for the upcoming budget year. Even more
important to the tax payer is that the share of Colleyville's overlapping tax burden has been
declining in recent years. The City's share of the citizen's tax rate burden with the other
taxing entities has declined from 14.2% in 1996 to 12.9% in 2006. Conservative fiscal
policy by the Council and an attention by staff in fiscal management have augmented this
success. A review of the three components of the tax base reveals that the substantial
portion of the roll is provided by residential properties.
Appraised Property Values
O Vacant Land
^Commercial
^ Residential
As submitted, the FY 2007 Budget provides for a property tax rate of $0.3474 per $100
value to support a projected property tax roll of $$3,062,340,646. This tax rate is the
lowest of each of the peer benchmark cities with a range on the low side of $0.015 to a
high of $0.223. The tax rate is comprised of Operation and Maintenance of $.27873 and
City of Colleyville 2006-2007 Budget Worksession -Page 30 of 71
1995 2000 2001 2002 2003 2004 2005 2006 2007
an Interest and Sinking rate of $.06867. The latter component provides funding for
retirement of the annual debt obligations.
Budget
Year Average
Propert Value Property
Tax Rate Property Tax '
Payment
2006 $338,001 $0.3474 $1,174.22
_
2007 $352,915 $0.3474 $1,226.03
As noted in the preceding table, the rate will adjust the typical homeowner's tax bill 4.4%
compared to the FY 2006 tax billing. The average homeowner will see a property tax
payment adjustment of $51.81 to support city services, which equates to $.14 per day.
Principally driving the increase in average property value between FY 2006 and FY 2007
was higher permit values for new home construction.
Sales Tax Revenue
The second major financial consideration that guides the development of the budget is the
growth of sales tax revenues. The City collects a total of 2% sales tax: 1% for General
Fund and the remaining 1 % allocated for two'/2 cent special purpose districts.
All projections of sales tax revenues are very conservative because of the volatility of this
revenue source, which is dependent on the economy. The mandated sales tax holiday in
August implemented by the State Legislature on certain retail goods has some negative
effect on retail sales, but that impact cannot be directly measured.
In FY 2005, the City Council entered into three separate economic development incentive
agreements providing for a portion of sales tax generated to be shared with respective
economic development prospects for the Colleyville Town Center. Only the City's general
1 % sales tax is allocated to these three performance based incentive agreements as a
baseline for incentives. Starting with the FY 2007 Budget, an expense item has been
provided in the Economic Development Department budget to account for the payment of
the incentives. The FY 2007 Budget provides $152,500 towards this year's incentive
obligation. A special fund has been established for the net present value of the combined
incentive agreements as previously discussed by the Council with funding being provided
by the allocation of $1,080,000 from excess cash balance of the General Fund, as
previously discussed with the Council.
It is anticipated that the contracted service provider for refuse and recycling services (IESI)
will be filling a rate adjustment request with the City during the later part of this summer.
The service provided has not received a rate adjustment during the term of the contract
and is preparing a submittal. The forecasted revenue schedule does not account for the
marginal impact generated by the rate adjustment, dependent on Council action, for refuse
franchise revenues due to its limited revenue enhancement.
Expenditures
In developing the
Council priorities.
budget, we once again focused resources on vital core services and
Departmental budgets were evaluated for appropriate adjustments
City of Colleyville 2006-2007 Budget Worksession -Page 31 of 71
based on historical expenses and anticipation of spending needs for the coming year.
Continuing the City's commitment to innovation, self-improvement, accountability and open
communication, City Staff has further integrated the role performance measurement plays
in managing the City's operations and in determining Staff's success in meeting City
Council's goals.
The following illustration shows where the City will spend the tax dollar for FY 2007. For
example, public safety expenses and programs represent 43% of the total City property tax
levy payment.
Public Works $ 0.12
Engineering /Bldg. Insp. $ 0.06
Finance /Court $ 0.04
Community / Eco. Dev $ 0.03
Comp Plan $ 0.03
FY2007 Enhancements
• Vehicle replacement - $19,160
This will be the third year to implement a scheduled vehicle replacement program.
In preparing the FY 2007 Budget, an additional $19,160 has been included for the
purchase of more fuel efficient vehicles and the Fire Department's scheduled
ambulance replacement with the first lease payment occurring in early 2008.
Technology
Building Codes - $70,000
Funding is provided for the purchase of building permit software to allow online
automated application and issuance of construction permits. Staff will be able to
synchronize with the main database when physically connected to the network or
via a wireless carrier service. The software will also help building inspectors
Fire $ 0.20
Community Services x.160
General Management $ 0.12
City of Colleyville 2006-2007 Budget Worksession -Page 32 of 71
track non-compliant items found during inspections. When the on-site review is
complete, a final inspection report is prepared. The software allows the building
department to publish permits to the web allowing the inspectors work to begin
without re-keying any information from paper forms. Using a web-based
technology, the Building Department can incorporate external parties into the
plan review process. A five year replacement for the software purchase is
proposed to be funded by a modest adjustment to the building permit fee
schedule.
Facilities -Equipment
Parks - $40,000
The General Fund budget provides funding from FY06 additional cash balance
from operations which was added to the General Fund's unrestricted Fund
Balance. Funding from this source provides for the replacement of the bleacher
and scoreboard shade cloth at City Park for $40,000.
Fire Station - $30,200
The Department operates two hydraulic rescue tools (Jaws of Life) for
emergency extraction of individuals for vehicles. Due to age and inability to
acquire replacement parts, $30,200 is provided for replacement in the budget.
Library - $30,000
Continuing the commitment to utilizing technology to minimize staff needs, the
budget provides $30,000 for the purchase of an enhanced automated material
check out computer. The equipment will allow patrons to pay any associated
fees or fines when checking out material. The current equipment does not have
a pay feature thus limiting patron use. The General Fund budget provides
funding from FY06 additional cash balance from operations which was added to
the General Fund's unrestricted Fund Balance.
Information Technology - $5,250
The $5,250 funding for the purchase of a network wide tape drive back up is
proposed to be provided by the General Fund budget from FY2006 additional
cash balance from operations which was added to the General Fund's
unrestricted Fund Balance.
Staffing
Police - $205,483
To address needed staffing for law enforcement operations, funding is provided
for the hiring of three additional police officers. Two of the positions will be for
patrol while a third is for warrant collection activities. Staffing costs for the
warrant officer is anticipated to be offset from increased warrant feel collections.
A fourth civilian position is provided for a full time public safety assistant. The
implementation of these positions will allow patrol officers to better concentrate
time in the field by minimizing workload at the station.
Information Technology - $45,584
City of Colleyville 2006-2007 Budget Worksession -Page 33 of 71
A desk-top computer technician is provided to assist better management of the
City's technology investment. Adding the position will additionally address
computer technology needs in the Library Department.
Parks Department - $36,642
The FY 2007 Budget provides funding for a park maintenance worker to assist
with maintenance programming for parks.
Library Department - $18,978
Funding fora part-time library clerk is provided to assist the Department
providing patron assistance locating materials.
Street Maintenance - $150,000
The FY 2007 Budget allocates an additional $150,000 towards overall street
maintenance. This increase is needed to offset rising cost of oil from the current
fiscal year related to asphalt purchases.
Library - $68,000
Consistent with previous budgets, the FY 2007 Budget allocates funding from
the Voluntary Library Fund, subject to a recommendation of the Colleyville
Public Library Board for materials purchase.
Fuel Cast Adjustments (all departments) - $19,507
Continued world events and the instability in the Middle East have in part caused
price increases in gas and oil. To account for these uncontrolled increases,
additional is budgeted for FY 2007 for fleet operations.
Building Utility Costs fall departments) - $59,938
The FY 2007 Budget reflects increases for utility costs for servicing the related
city facilities and street lighting.
COMPENSATION AND BENEFITS (all Funds)
Maintaining an investment in staff is an important component in the development of the FY
2007 Budget. The Budget includes funding fora 5% salary merit adjustment. Funding a
merit program at this rate will enable the City to offer employees a merit adjustment range
of 2% to 7%. The Budget provides funding to bring all employees to the minimum of the
new pay range. Also provided is our strong attention in employee benefits with
continuation in funding employee dependent insurance at 75% to maintain our overall
competitive position with the peer cities.
This 5% merit adjustment will cost the General Fund $478,500, the Drainage Fund
$26,895 and the Utility Fund $107,164, inclusive of retirement and taxes. The 65
employees who are "maxed out" will receive a one time payment either by cash or paid
into a City approved deferred compensation plan.
Addressing merit evaluations being moved from a calendar to anniversary date, there is a
one time funding for pay equalization for those employees receiving a merit adjustment
during later portions of the year. The cost is $85,000 for the General Fund.
City of Colleyville 2006-2007 Budget Worksession - °.~ge 34 of 71
The total cost for the insurance program is $1,632,888 for the FY 2007 Budget. This
amount includes health, dental, life, long-term disability, COBRA and flexible spending
account administration and the wellness program. Of this amount, $1,318,175 is funded
through the General Fund. Citywide, the annual health insurance premium for employee
only per month is $435.88 and dependent/family insurance will be $1,320.72 per month
this year. The dependent premium is split with the City paying 75% ($1,098.94 per month)
and the employee paying 25% ($221.78 per month).
In addition, the City participates at the premium level in the Texas Municipal Retirement
System (TMRS). Under this system, the City matches the employee retirement
contribution at a 2 to 1 ratio. The City is at the maximum contribution rate and annually
provides updated service credit adjustments to maximize the employee retirement
potential. Funding for participation in the TMRS program is $829,866 (11.71% of pay) for
the General Fund.
The City also provides workers' compensation coverage through the Texas Municipal
League (TML) for all employees. Staff has worked diligently to control costs by
participation in a citywide safety program. This program meets on a monthly basis to
review trends, address safety issues and coordinate safety training and awareness efforts.
This program has proven effective by lowering premiums over the last two years. This
year the City received an increase of 14.62% or $27,310 in the General Fund due to recent
legislation which expands coverage of firefighter personnel. This increase includes an
adjustment of the City's experience modifier to 0.88%.
Focusing on efforts to reduce employee health and workers compensation claims, the City
implemented in FY 2005 a wellness program, Fit and Well in Colleyville. This is voluntary
program that encourages employees to evaluate overall health and work towards
improvement. Due to this program we have seen individual employee results including
weight reduction, decrease in prescription medication, increased physical activity and
nutrition. The program offers a variety of elements such as on-line health assessments,
individual coaching for improvement, seminars, challenges and disease management.
Employee participation earns credits towards three different incentive levels and
depending on the level reached this year will affect the possible incentive next year. The
long-term goal is to minimize premium increases through improved health and wellness of
our employees. The FY 2007 Budget funds $13,094 towards the cost for this program.
Implementing the first year of the Workfoce Development Program (WDP) will be a major
focus of work by staff. The WDP is a multi-prong initiative driving results in succession
planning, staff development and compensation management. Early successes with these
efforts have been recognized nationally by the Innovations Group and regionally by the
Texas Municipal League. Staff served as a featured speaker for a national training
session on succession planning hosted by the Innovations Group this past July. The
Texas Municipal League has selected Colleyville as winner of its statewide municipal
excellence award for management innovations to be awarded at its annual conference this
October.
City of Colleyville 2006-2007 Budget Worksession -Page 35 of 71
During the June Council budget work session, staff was directed to develop an
organizational staffing study. The objective of the study is to identify probable staffing
needs. Funding for the project is anticipated to not exceed $30,000 with a concentration of
staff resources allocated to minimize costs.
UTILITY FUND BUDGET
The Utility Fund is a proprietary fund structured and operated as a stand-alone business or
enterprise. For budgeting purposes, the Fund segregates the operating expenses and
debt service in an accounting fashion similar to the General Fund. In accordance with
Generally Accepted Accounting Principles (GAAP), this Fund uses a full accrual basis of
accounting that combines the accounting of long-term assets and liabilities with operating
expenses and revenues. As a stand-alone Enterprise Fund, the Utility Fund pays its share
of overhead costs as a reimbursement to the General Fund. The Fund also makes a
franchise fee payment to the General Fund of 2%.
Continuation of the hot, dry weather will have a detrimental impact on the ability of the City
to provide water to residents as the regional water system is stressed. Accordingly, staff is
developing a water conservation program to enhance public education on outdoor watering
needs. Educational materials and seminars have been prepared as part of the budget. As
further research is complete, staff will be presenting a broader customer interaction
program for Council consideration.
Revenues
Combined Utility Fund revenues total $9,896,770. Water sales account for 71 % of this
amount and sewer revenues account for 22%. Interest, tap fees and miscellaneous
revenues make up the remainder. Utility rates were increased in FY 2001 and 2006 for a
portion of the scheduled $5 million for State Highway 26 utility relocation improvements
(estimated construction in June 2008). Debt will be issued early in FY 2008. Increases
for water and wastewater services provided by the Trinity River Authority (TRA) were able
to be absorbed within anticipated revenues but there may be a required rate adjustment to
offset these rate increases in the FY 2008 Budget.
Meeting bond covenant requirements, the rate structure provides fora 1.5 times coverage
factor. Capital programming for the Fund directed by the City Council in FY 2005 provides
for the maintenance of a 180-day working capital reserve.
Expenditures
Utility Fund expenditures total $9,337,375 for the FY 2007 Budget. The largest
component, 51 %, of the Fund covers the contractual obligation for water and wastewater
to the Trinity River Authority. As part of the program to repair and rehabilitate the utility
system, the budget continues funding the annual meter replacement program at a cost of
$30,000. The following are significant adjustments proposed for the FY 2007 Budget.
City of Colleyville 2006-2007 Budget Worksession -Page 36 of 71
• Staffing - $66,943
Funding for an accountant is provided in the Utility Billing Department. The adding
of this new position will greatly expand and enhance the capabilities of the Finance
Department in managing the day to day financial operations of the Utility Fund.
• Facilities and Equipment - $20,000
Continuing to manage the growing volume of plans, the Utilities Department plans
to purchase (over five years) contracted services for the electronic archiving of
documents at $20,000 per year. The funding for the purchase of this service is
proposed to be provided by prior year excess fund balance from the Utility Fund.
• Utility Bill Mailer - $70,000
To facilitate greater flexibility in offering citizen information, the Utility Billing
Department will begin mailing monthly utility bills by envelope. This style of billing
will accommodate the City an ability to additionally provide to customers information
on various City services and programs.
• Fuel Cost Adjustments - $10,345
Consistent with the General Fund, the Utility Fund FY 2007 Budget is increased to
account for price increases in gas and oil.
• Electric Utility Costs - $11,785
The FY 2007 Budget reflects an increase for electrical costs for servicing the related
city facilities and utility pumping operations.
The following illustrates the distribution of expenses for the Utility Fund.
,~,,
Debt Service _ ~1=~-~.
Transfers ~l 9t~ '':
Billing i 5%
Administration = - 2%
Compensation
1%
City of Colleyville 2006-2007 Budget Worksession -Page 37 of 71
DEBT SERVICE FUND
The City budgets for debt service in two separate Funds -utility and tax supported debt
service. The Utility Fund's times coverage ratio of 1.20 is effectively met with a projected
1.50 ratio for FY 2007 with the rate structure. With the successful passage of the 2005
General Obligation Bond Election, the City will issue related debt in 2008. Scheduling of
the sale of the debt is planned to not impact the debt portion of the property tax rate until
the FY2008 Budget. Current projections are that the sale of this debt will require an
adjustment of the debt tax rate.
The City's bond ratings are further evidence of Colleyville's financial strength. In 2002, the
City received an upgrade in its General Obligation bond rating from Standard and Poor's
from "AA" to "AA+. Avery strong tax base growth coupled with a low tax rate, strong
financial performance and substantial cash balances are the primary reasons for the bond
rating.
The Waterworks and Sewer System and separately the Drainage System revenue bonds
also received a rating upgrade in 2003 and 2004 respectively. Standard and Poor's
upgraded the Waterworks and Sewer System revenue bonds from "AA" to "AA+" and
upgraded the Drainage System revenue bonds from "A" to "AA-". Reasons for the
upgrades include strong financial operations, growth in service area, adequate water and
sewer treatment capacity to meet future demands, and moderate debt ratio with
manageable future borrowing plans. A credit ranking for outstanding debt means the City's
bonds are considered to be of superior investment quality, meaning lower interest
payments. With a population of only 21,750, Colleyville is in a peer of only five other
Texas cities (average population of 200,000) with this magnitude of bond rating.
The Colleyville Economic Development Corporation's rating by Standard & Poor's on its
outstanding debt was increased from "A--" to "AA" during FY 2006. The increase in the
rating was based upon a strong debt service reserve and improved maximum annual debt
service coverage due to greater sales tax revenue.
STORMWATER DRAINAGE UTILITY FUND
In 1993, the City Council adopted a monthly fee to assess against residential and
commercial utility billing accounts for stormwater management. The stormwater Drainage
Utility Fund covers operation and maintenance of the City's drainage system and
addresses federally mandated requirements for stormwater systems.
This fund is designated to help the Public Works Department maintain streets, sewers and
drainage ditches to manage runoff from commercial and residential development. A
Drainage Department was previously established to account for related personnel and
operating costs.
The Fund receives $825,636 annually from the collection of the monthly fee. Annual debt
payments for the outstanding bonds comprise $263,705. The remaining funds are
allocated for six staff positions and $171,846 for miscellaneous projects. This will be the
third year budget that began annualized funding of a lease payment of $14,789 for the
acquisition of related equipment. The drainage bonds require a coverage ratio of 1.20
City of Colleyville 2006-2007 Budget Worksession -Page 38 of 71
times annual bonded debt service, approximately $316,446 annually. Using the cash
generated from the prior year's coverage ratio enables the fund to acquire this equipment
and future replacement equipment using multi-year leases.
SPECIAL DISTRICTS
The Council continues to be innovative in evaluating financing options for various City
programs. Programs implemented, to date, include:
~ Colleyville Tax Increment Financing District:
The Tax Increment Reinvestment Zone (TIRZ) District was created in 1998. The
primary goal of the District is to encourage quality commercial development in the City.
The District boundaries predominately occupy property located along State Highway
26, comprising 633 acres of land area. Incremental values subsequent to January
1998 are taxed at the City's adopted property tax rate. However, the ad valorem
revenues are utilized within the District rather than being allocated to the City's overall
budget. Overlapping taxing entities, including Tarrant County, Tarrant County College
District, Tarrant County Hospital District and the Grapevine-Colleyville Independent
School District participate at varying levels in the District by assigning their ad valorem
tax dollars.
The incremental value for tax year 2006 is $157,692,034, an increase of 4.2% over the
valuation for tax year 2005. The base value for the District was $75,821,735 in 1998.
The FY 2007 debt service payment is $1,540,620 for bonds issued for District projects.
Additionally, expenditures are anticipated for payment to the Villages at Colleyville and
The Town Center at Colleyville for developer infrastructure as a result of Board and
City Council incentified approved projects.
Initial planning projections provided that the anticipated property valuation for the
District would be $184,991,735 for FY 2007. Based on property evaluations provided
by the TAD, the actual valuation for the District will actually be $233,517,769. This is a
26.2% increase over the 1998 projection.
~ Colleyville Crime Control and Prevention District:
The primary goal of the District is to fund public safety facilities. The District was
created by voter approval in 1999, with oversight of funds assigned to the Board of
Directors composed of the City Council. State law provides that a District's life is
limited to five years, unless voters continue the District by approval of a referendum. In
September 2003, Colleyville voters approved continuation of the District for an
additional 20 years.
Expected revenue from the special purpose sales tax, use of funds generated from
prior years coverage ratio and related interest income for the FY 2007 Budget is
$1,042,956. The budget provides funding for the annual debt for the Colleyville Justice
Center, compensation for a police officer, annual acquisition of four police vehicles,
Teen Court, and in-car mobile digital video systems with total expenditures of
$834,652.
City of Colleyville 2006-2007 Budget Worksession -Page 39 of 71
~ Colleyville Economic Development Corporation:
Authority for the Corporation is provided by State statute as a 4B Corporation. The
0.05% sales and use tax approved by the voters in August 1996 has been an important
resource in our capital improvement program for community related facilities. Expected
revenue from the special purpose sales tax, use of funds generated from prior years
coverage ratio and related interest income for the FY 2007 Budget is $1,511,413. The
CEDC Board will meet in September to approve the FY 2007 Budget. Funding
provided by this special sales tax historically has been allocated to community
development initiatives (i.e. parks, libraries, city hall, etc.). Consistent with state law,
some moneys will likely be allocated by the Board of Directors for economic
development efforts for festival and marketing efforts.
The budget provides funding for the following items by allocation of prior year excess
cash balance:
'!~i Kidsville playground repair and renovation $10,000
'~ Playground safety signs $6,000
'sr Field Maintenance entry improvements $11,500
'!~ Picnic tables $6,000
NATIONAL RECOGNITION
The city received a Distinguished Budget Presentation Award from the GFOA for its FY
2006 Budget. In order to receive this award, a governmental unit must publish a budget
document that meets program criteria as a policy document, as an operations guide, as a
financial plan, and as a communications device.
The Budget Presentation Award is valid for a period of one year only. It has been an
honor for the City to have received this award for twelve years running and a testament to
the professional expertise that Terry Leake, Finance Director, provides for the citizens. I
believe the 2007 budget continues to meet the program criteria, and this budget will be
submitted to the GFOA to determine its eligibility for continued receipt of the award.
SUMMARY
This budget was delivered to the City Council on July 28, 2006. The Council scheduled a
worksession for August 3 and 4, 2006, and afollow-up worksession on August 17 and 18,
2006, if needed, to review the FY2007 Budget. A citizen budget education day is
scheduled for August 12, 2006.
In keeping with our continued effort to broaden communication with the public concerning
the City's finances and budget process, the FY 2007 Budget can be reviewed via the City
website at www.Colleyville.com. In addition, the Executive Summary provides citizens
information pertaining to the budget in summarized form. A public copy has been filed with
the City Secretary. A reference copy of the budget is available in the Colleyville Public
Library.
City of Colleyville 2006-2007 Budget Worksession -Page 40 of 71
Approval of a proposal to set the tax is scheduled for August 15, 2006. A public hearing
for the FY2007 Budget is scheduled for September 5, 2006, with adoption of the budget on
September 19, 2006. Printing of the budget will be completed by January 5, 2007.
The development of the FY2007 Budget was a challenge considering the demands for
services exceed available resources and need for staffing improvements. There is some
comfort in knowing that the peer cities are experiencing similar, and in some cases
greater, budget challenges. City staff continues to review and evaluate internal operations
for opportunities to reduce and improve the provision of funded services.
This service plan provides a good foundation for future budgets. We have focused on
what we expect to achieve in FY2007 and how we can continue moving forward. I am
particularly pleased with the level of commitment in implementing a sustainable budget
philosophy from the Council and staff.
Each Department Head looked within their departments for innovative and cost saving
approaches for the delivery of services. In addition, appreciation goes to members of the
Budget Team. Finance Director Terry Leake, Human Resources Director Kelly Cooper,
and Budget and Administrative Services Manager Stephen Seidel are due a tremendous
debt of gratitude. Colleyville is lucky to have all of these employees as a part of the
Management TEAM.
Colleyville is fortunate to have a uniquely talented and passionate community that is
extremely active. Strong citizen participation is welcomed and encouraged. Clearly, the
citizens speak out on the type and expected level of services. The administrative desire is
to continue this path and provide a climate that fosters unity within the varied faces of the
community through involvement and input to our organizational efforts.
As the City Council considers the FY 2007 Budget, one important question answered in
the proposed budget is our focus on the future. Customer service will be at the forefront,
and the City will continue to retain and attract staff that will be committed to the
organizational values that emphasizes a strong customer service philosophy. The staff
remains focused and committed to providing efficient and cost-effective services and
programs to the citizens. Sound fiscal planning will continue to be on the forefront as we
move into the new fiscal year. Through these conservative and focused efforts, the City
will be able to continue to provide quality services to our citizens.
Over the years, the City Council has gone about the business of developing a quality
community, in part by the development of annual budgets. Colleyville is deserving of being
named best in Texas and 40th in the nation for "Best Places to Live" for 2005 by Money
Magazine. The FY 2007 Budget continues that practice.
The development and preparation of the budget can best be summarized with a view that
the financial picture of the City is very positive, and the focus is on the future. This budget
lays the groundwork for a strong structure to carry on the duties and responsibilities of the
government. I appreciate your devoting the time to discuss the opportunities in this service
City of Colleyville 2006-2007 Budget Worksession -Page 41 of 71
plan during the worksessions. Through this process, we will reach consensus on the
direction to take the City in the future
Sincerely,
Bill Lindley
City Manager
Attachment
• FY 2007 Combined Annual Operating Budget
City of Colleyville 2006-2007 Budget Worksession -Page 42 of 71
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Cily Manager's Office 001-11
FY2006 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2006 YTD Department Proposed Adopted
Descri lion Actual Actual Bud et as of 6130 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
408,792
393,910
410,276
334,779
481,937
380,613
6102 TEMP HELP 0 5,650 0
0 1,657
1
455 0
0 0
506
6139 OVERTIME
6141 FICA EXPENSES 0
26,728 336
26,159 31,539 ,
22,665 37,140 29,272
6142 GROUP HEALTH INS 39,164 46,579 54,575 45,052 63,546 38,202
6143 WORKER'S COMP 1,231 1,079 1,233 983 1,456
945 1,343
350
1
6145 UNEMPCOMP 1,449
387
51 i77
387
50 810
49,088 2,006
41,349 55,902 ,
43,861
6146 RETIREMENT
6148 LONGEVITY PAY ,
2,225 ,
1,753 1,993 1,993 3,556 1,523
0
SUBTOTAL 530,977 526,029 549,514 451,938 644,482 496,670
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
6,100
6,250
7,199
4,539
7,199
5,143
6204 TRAVEL 5,690 8,726 11,764 2,580 14,528 11,028
350
6206 TRAINING 654 1,918 1,930 1,438 2,030 0
6207 PRE-EMPLOYMENT 44 12,694 0 2,034
653 0
945 398
2
6208 ORG DEVELOPMENT
S 818
301
4 606
533
3 945
973
3 4,372 4,242 ,
3,290
6209 DUES & SUBSCRIPTION , , , 134 0
6225 COMPUTER SERVICES 22,490
050
25 0
074
1 0
13
000 24,130 17,650 0
6226 MISC CONTRACT SVCS , , , 0 500 0
6231 LEGAL ADS
6238 UTILITIES 0
14,818 484
15,325 500
14,787 14,037 14,787 12,068
6240 CELL PHONES 3,034 4,843 3,720 1,646 2,280
88 2,280
388
6
6241 TELEPHONE 6,521 8,293 6,388 5,862 6,3 ,
0
6245 EQUIP RENTAL
6246 OFFICE EQUIP MAINT 0
3,447 0
4,247 0
4,505 1,862
3,010 0
3,620 1,620
6264 MODULAR BUILDING 592 0 0 0 0
0 0
0
6285 BLDG MAINT & SUPPL 136 0 0 0
397 310 100
6293 COMMITTEE EXPENSE 118 0
57 310
800
2 4
734 3,880 0
6294 COUNCIL EXPENSES 0 , , 0 0
6299 MISCELLANEOUS 0
813
93 145
68
195 0
71,821 83
71,511 78,359 44,665 0
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
3,352
4,412
2,604
2,461
2,604
1,854
6302 POSTAGE 1,357 927 2,050 1,721
922 2,050
438
3 850
26
3
6303 OPERATING SUPPLIES 2,305 3,209 3,438 3, , 0
,
6305 UNIFORMS 0
820 0
792 0
379
1 0
2,287 0
1.379
623
6308 PRINTING
6312 COMPUTER SUPPLIES 1,093 923 ,
1,118 781 1,118 1,053
6323 COUNCIL SUPPLIES 0
927
8 0
262
10 0
10,589 0
11,171 0
10,589 4,380
7,641 0
SUBTOTAL , ,
CAPITAL OUTLAY
0
0
0
6630 OFFICE EQUIPIFURNITURE 0 0 0 0
6635 COMPUTER EQUIPMENT 0 0 0 0 0
0 0 0
SUBTOTAL 0 0 0 0
TOTAL 633,716 604,486 631,924 534,619 733,430 548,976 0
City of Colleyville 2006-2007 Budget Worksession -Page 43 of 71
~iz~~zoos
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Building Inspection 001-12
FY2008 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2008 YTD Department Proposed Adopted
)escri tion Actual Actual Bud et as of 6130 Re nest Bud et Bud et
PERSONNEL
6101 SALARIES
160,676
145,157
189,280
116,487
193,357
194,022
0
0
6102 TEMP HELP 32,534
251
4 34,797
492
3 0
003
3 27,995
2,507 0
4,203 0
3,220 0
6139 OVERTIME
6141 FICA EXPENSES ,
12,244 ,
10,895 ,
14,865 8,720 15,274 15,200 0
0
6142 GROUP HEALTH INS 28,327 29,250 45,479 27,773 45,479
411
1 47,753
532
1 0
6143 WORKER'S COMP 1,428 1,193 1,371 1,093 ,
675 ,
350
1 0
6145 UNEMP COMP 980
360
21 108
19
529 675
23,594 1,306
14,098 23,375 ,
23,262 0
6146 RETIREMENT
6148 LONGEVITY PAY ,
965 ,
1,005 2,028 1,270 2,098 1,453 0
0
SUBTOTAL 262,766 245,426 280,295 201,249 285,872 287,792
CONTRACTUALSVCS
6203 INSURANCE SHARE
2,184
2,219
2,535
1,617
2,535
2,535
0
0
6204 TRAVEL 703 391 1,000 735
775 1,528
610
1 1,470
400
1
6206 TRAINING 1,415 1,196 1,550 ,
0 ,
0 0
6207 PRE EMPLOYMENT 0 915 0
787 185
457 787 1,988 0
6208 ORG DEVELOPMENT
NS 620
791
1 651
470 1,065 372 1,065 1,065 0
6209 DUES & SUBSCRIPTIO
ES ,
950
1 950
1 1,950 1,950 2,010 0
6225 COMPUTER SERVIC ,
815
4 ,
193
4 4,025 4,002 4,025 4,551 0
6238 UTILITIES
6240 CELL PHONES ,
2,981 ,
2,656 2,760 1,341 3,680 3,680 0
6241 TELEPHONE 2,697 2,787 2,939 1,985 2,939 2,930 0
6245 EQUIP RENTAL 0 0 0 0 0
0
0
D
6246 OFFICE EQUIP MAINT 0
699 0
030
1 0
000
1 0
1,646 1,000 1,000 0
6261 VEHICLE MAINT
6262 GAS AND OIL 2,266 ,
2,045 ,
2,388 2,252 3,300 3,600 0
6264 MODULAR BUILDING 2,169 0 0 D 0
0
0
0
6285 BLDG MAINT & SUPPL
E 0
154
1 0
345
2 0
2,840 0
742 2,840 2,840 0
6286 MOWING EXPENS ,
443
25 ,
849
22 24,839 18,059 27,319 27,068 0
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
1,191
1,371
1,095
969
1,203
1,095
0
0
6302 POSTAGE 787 632 1,000 473
838 800
075
1 700
750 0
6303 OPERATING SUPPLIES 487 624 1,075 148 ,
720 170
1 0
6305 UNIFORMS 606 375
753 540
627
1 228 1,627 ,
1,000 0
6308 PRINTING
6312 COMPUTER SUPPLIES 1,650
1,067 823 ,
665 583 665 665 0
0
6313 SMALL TOOLS 144 705 158 41
0 227
600 227
600 0
6326 SAFETY EQP/SUPPLIES 120
052
6 170
453
5 450
610
6 3,279 6,917 6,207 0
SUBTOTAL , , ,
CAPITAL OUTLAY
0
0
D
70,000
0
6635 COMPUTER EQUIP 0 0 0 0 0
6645 OPERATING EQUIP 0 0 0 0
0 0 000
70 0
SUBTOTAL 0 0 0 ,
TOTAL 294,261 273,728 311,744 222,587 320,108 391,067 0
7nn2oos City of Colleyville 2006-2007 Budget Worksession -Page 44 of 71
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Economic Development 001-13
FY2006 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2006 YTD Department Proposed Adopted
Description Actual Actual Bud et as of 6/30 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
30,319
93,923
94,378
71,949
94,378
94,378
6141 FICA EXPENSES 2,319 7,251
011 6,853
096
9 4,898
074
7 6,865
096
9 6,865
9,551
6142 GROUP HEALTH INS 1,238 6, ,
273 ,
218 ,
274 322
6143 WORKER'S COMP 188 212
27 135 270 135 270
6145 UNEMP COMP
6146 RETIREMENT 207
3,660 12,330 10,877 9,053 11,067 11,067
6148 LONGEVITY 0
37
932 0
753
119 0
121,612 0
93,462 155
121,970 155
122,608
SUBTOTAL , ,
CONTRACTUAL SERVICES
0
0
380
239
380
380
6203 INSURANCE
6204 TRAVEL 3,523 5,195 5,510 2,614 6,320 6,320
6206 TRAINING 0 444 4,305 1,349 4,775 4,775
0
6207 PRE- EMPLOYMENT 1,567 0 0 0
91 0
157 399
6208 ORG DEVELOPMENT 158
454 110
740
3 157
2
355 2,786 2,655 2,655
6209 DUES&SUBSCR , ,
0 0 0 0
6225 COMPUTER SERVICES
6226 MISC CONTRACTUAL SVS 3,247
65,500 1,430
5,501 4,509 3,766 4,509 4,509
6236 ADVERTISING 0 17,939 17,794 14,548 21,000
671 17,750
759
6238 UTILITIES 0
0 0
864 671
900 0
0 900 900
6240 CELL PHONES
6241 TELEPHONE 287 332 2,247 243 2,247 2,247
6264 MODULAR BUILDING 0 0 0 0 0
0 0
0
6285 BLDG MAINT & SUPPLIES 0 0 0 0 0 0
6299 MISCELLANEOUS 4,674
79
410 0
556
35 0
38,828 0
25,637 43,614 40,694
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
588
644
500
507
111
750
700
3
750
200
2
6302 POSTAGE 1
34 477
70 1,200
750
1 560 ,
3,050 ,
2,050
6303 OPERATING SUPPLIES 0 864 ,
2
000 625 2,500 2,000
6308 PRINTING
6312 COMPUTER SUPPLIES 198 1,733 ,
240 170 100
6360 MINOR OPERATING OUTLAY
3,060
3,414
0
0
150 0
150
6399 MISCELLANEOUS 0
881
3 0
7
201 150
5,840 70
2,043 10,250 7,150
SUBTOTAL , ,
CAPITAL OUTLAY
0
0
0
0
0 0
6635 COMPUTER EQUIPMENT 0 0 0
6645 OPERATING EQUIPMENT 0 0 0 0 0 0
SUBTOTAL 0 0 0
TOTAL 121,223 162,511 166,280 121,142 175,834 170,452
City of Colleyville 2006-2007 Budget Worksession -Page 45 of 71
0
0
0
0
0
7~znzoos
City of Colleyville, Texas
FY2007 General Fund Budgot
Departmental Expense Summary
Department: Acct:
City Secretary's Office 001-14
FY2007 FY2007 CM FY2007
FY2004 FY2005 FY2006 Adopted FY2006 YTD Department Proposed Adopted
iescri lion Actual Actual Bud et as of 6130 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
96,268
97,868
97,955
72,800
102,887
102,887
6141 FICA EXPENSES 7,471
844 7,554
414
17 7,562
192
18 5,398
635
13 7,950
18,192 7,950
19,101
6142 GROUP HEALTH INS
' 8,
295 ,
258 ,
301 ,
240 317 373
S COMP
6143 WORKER 469 59 270 540 270 540
6145 UNEMP COMP
6146 RETIREMENT 12,402 12,814 12,002 9,242 12,167 12,167
6148 LONGEVITY 570
319
126 660
136,627 890
137,172 890
102,746 1,040
142,823 1,040
144,058 0
SUBTOTAL ,
CONTRACTUAL SVCS
6203 INSURANCE
8,174
8,525
9,658
6,080
57
9,658
599
6
9,658
431
16
6204 TRAVEL 235
314
1 1,781
158
3 5,800
2,500 447 ,
3,065 ,
2,900
6206 TRAINING , , 0 0 0 0
6207 PRE EMPLOYMENT 36 0
220 315 183 315 799
6208 ORG DEVELOPMENT 282
011
9 11
870 8,968 5,348 8,968 8,968
6209 DUES&SUBSCR , ,
0 0 0 0 0
6213 TUITION REIMBURSEMENT 0
955
5 40
293 705
8 4,816 8,705 7,245
6215 ELECTION EXPENSES
6225 COMPUTER SERVICES ,
5,566 ,
5,146 ,
6,218 0 8,618 7,000
6226 MlSC CONTRACTUAL SVS 7,055 8,549 33,500 24,536
612 36,000
000
6 46,500
6
250
6231 LEGAL ADS 11,907
961
8 15,744
856
4 6,000
6,350 1,
2,800 ,
6,350 ,
6,350
6237 CODIFICATION
6238 UTILITIES ,
24,972 ,
28,023 26,900 26,749 26,900 30,429
6240 CELL PHONES 0
198
3 0
720
3 100
2,922 0
2,429 100
2,922 0
2,922
6241 TELEPHONE
6245 EQUIPMENT RENTAL ,
21,582 ,
23.942 24,202 15,395 24,202 22,690
6246 OFFICE EQUIP MAINT
0
0
0
0 0
0 0
0
6264 MODULAR BUILDING 651 0 0 0 0 0
6284 EQUIP MAINTENANCE 0 0 0 0 0 0
6285 BLDG MAINT&SUPPL 0
880 0
591
2 0
200
3 0
360 3,200 2,450
6293 COMMITTEE EXPENSE
6294 COUNCIL EXPENSES 2,440 ,
8,360 ,
8,105 1,182 12,505 9,755
6295 SPECIAL PROJ/CONTRIB. 16,197
670
4 8,453
439
6 0
973
205 0
31,103 0
205,973 0
205,973
6298 COUNCIL DISCRETIONARY ,
086
133 ,
781
669 ,
359,416 123,096 370,080 386,320 0
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
1,882
3,288
1,020
438
965
539
1,020
539
2
6302 POSTAGE
P
IES 2,167
853
3 2,362
197
5 2,539
4,410 952
2,969 2,
8,760 ,
5,160
L
6303 OPERATING SUP
6308 PRINTING ,
2,126 ,
2,881 2,738 444 1,563 1,563
6312 COMPUTER SUPPLIES 799 359 1,000 40 2,500
0 620
6330 EQUIP/FURNITURE UNDER $500 0 0 0 0 0 0
6360 MINOR OPERATING OUTLAY 0
827
10 1,163
251
15 0
11,707 0
4,843 16,327 10,907 0
SUBTOTAL , ,
CAPITAL OUTLAY
0
0
0
0
0 0
6620 BUILDINGS 0 0 0 0
6630 OFFICE EQUIPIFURNITURE 0 0 0 0
6635 COMPUTER EQUIPMENT 16,898 0 0 9,236 0 0 0
SUBTOTAL 16,898 0 0 9,236
TOTAL 267,130 333,547 508,295 239,921 529,230 541,285 0
City of Colleyville 2006-2007 Budget Worksession -Page 46 of 71
„z„z~~,,,
City of Coileyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Finance 001-15
FY2006 FY2007 FY2007 CM
FY2004 FY2005 Adopted FY2006 YTD Department Proposed FY2007 Adopted
Descri lion Actual Actual Bud et as of 6130 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
217,436
238,457
242,789
149,298
198,714
198,714
6139 OVERTIME 283
16
224 209
17
660 475
18,862 168
10,645 487
15,511 487
15,731
6141 FICA EXPENSES
6142 GROUP HEALTH INS ,
31,327 ,
37,993 36,383 23,413 36,383 38,202
6143 WORKER'S COMP 685 634 752 600 618
540 738
810
6145 UNEMP COMP 1,035
28
253 108
31
491 540
29
938 810
19,415 23,739 24,074
6146 RETIREMENT
6148 LONGEVITY PAY ,
2,938 ,
3,023 ,
3,293 3,293 3,563 3,563
6152 ACCRUED LEAVE PAY 0 0 1,293
4
325 1,248
890
208 2,867
422
282 2,867
285,186 0
SUBTOTAL 298,180 329,574 ,
33 , ,
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
4,733
4,849
5,567
3,526
5,567
5,567
500
1
6204 TRAVEL 1,085 1,823 1,140 708
37 220
2
595 ,
2,595
6206 TRAINING 1,580 1,892 2,515 ,
0 0
6207 PRE-EMPLOYMENT 73 0
441 0
630 61
515 630 1,199
6208 ORG DEVELOPMENT
N 496
1
277 1
288 625
1 585 1,170 1,170
S
6209 DUES &SUBSCRIPTIO ,
15
313 ,
723
14 ,
12,872 13,385 13,385 13,385
6221 AUDIT
6222 TAX COLLECTIONIASSESSING ,
86,162 ,
84,440 90,636 80,989 94,224 104,524
6225 COMPUTER SERVICES 4,562 4,557 5,683 233 5,683 5,683
175
6231 LEGAL ADS
R
ES 216
504
5 85
4
408 475
701
6 123
2,758 175
6,853 6,853
G
6233 BANK SERVICE CHA ,
936
3 ,
596
2 ,
330
3 2,468 3,330 3,767
6238 UTILITIES , , , 0 0 0
6240 CELLULAR PHONE 645
342
3 0
858
2 0
919
2 1,927 2,919 '2,919
6241 TELEPHONE ,
0 ,
200 ,
200 0 415 415
6246 OFFICE EQUIP MAINT
0
0 0
6285 BLDG MAINT & SUPPL 0
922
128 0
159
124 0
134,293 107,315 137,166 149,752 0
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
1,930
2,408
1,956
882
2,016
2,016
4
250
6302 POSTAGE 2,565 2,101 3,000 2,979
1
103 3,300
422
1 ,
1,422
6303 OPERATING SUPPLIES 622
121
4 1,289
206
2 1,055
4,335 ,
1,112 ,
4,990 4,896
6308 PRINTING
6312 COMPUTER SUPPLIES ,
2,057 ,
3,011 3,805 516 3,880 3,500
0
6360 MINOR OPERATING OUTLAY 0
495
11 5,752
765
16 0
151
14 0
6,592 5,704
21,312 16,084 0
SUBTOTAL , , ,
CAPITAL OUTLAY
6630 OFFICE EQUIP/FURNITURE
0
0
0
0
0
0
0
6635 COMPUTER EQUIP 0 0 0 0 0
0 0 0
SUBTOTAL 0 0 0 0
TOTAL 438,598 470,498 482,769 322,797 440,900 451,022 0
City of Colleyville 2006-2007 Budget Worksession -Page 47 of 71
7!27/2006
City of Colleyville, Texas
FY2006 General Fund Budget
Departmental Expense Summary
Department: Acct:
Legal 001-16
FY2006 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2006 YTD Department Proposed Adopted
Descri tlon Actual Actual Bud et as of 6130 Re uest Bud et Bud et
CONTRACTUAL SERVICES
6216 LEGAL SERVICES 93,448 83,285 103,323 56,921 106,823 106,823
TOTAL 93,448 83,285 103,323 56,921 106,823 106,823
City of Colleyville 2006-2007 Budget Worksession -Page 48 of 71
~;2~izoos
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Library 001-17
Descri tion
FY2004
Actual
FY2005
Actual FYZ006
Adopted
Bud et
FY2006 YTD
as of O6/30 FY2007
Department
Re uest FY2007 CM
Proposed
Bud et
FY2007 Adopted
Bud et
PERSONNEL
6101 SALARIES
231,778
280,218
308,371
212,890
299,976
315,353
6102 TEMP HELP 4,759
779
17 11,114
284
21 3,987
603
23 4,898
16,141 4,739
22,997 7,005
24,173
6141 FICA EXPENSES
6142 GROUP HEALTH INS ,
13,728 ,
18,967 ,
36,756 21,526 36,756 38,594
6143 WORKER'S COMP 741 750 961
350
1 766
362
2 937
350
1 1,158
2,970
6145 UNEMP COMP 1,578
063
25 873
353
26 ,
25,095 ,
19,167 ,
25,300 25,300
6146 RETIREMENT ,
180 , 170 170 635 635
6148 LONGEVITY PAY 607
295 359,558 400,293 277,920 392,690 415,188 0
SUBTOTAL ,
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
6,809
6.976
8,044
5,064
8,044
0
8,044
3
200
6204 TRAVEL 0 1,839 1,400 1,313
390 3,20
650 ,
650
6206 TRAINING 0 0
526 650
0 195 0 0
6207 PRE-EMPLOYMENT 228
682 606 102
1 544 1,102 2,798
6208 ORG DEVELOPMENT 480 695 ,
985 800 1,025 1,025
6209 DUES 8 SUBSCRIPTIONS
6225 COMPUTER SERVICES 14,302 12,801 13,993 13,626 18,843 15,468
6226 MISC CONTRACTUAL SVCS 928 7,898 10,314 9,398 12,261 12,260
6231 LEGAL ADS
6238 UTILITIES 0
35,722 0
47,781 0
39,736 0
39,514 0
39,736
44,950
6240 CELL PHONES 0
4
200 0
372
4 0
3,696 0
3,430 0
3,696 0
3,696
6241 TELEPHONE
6246 OFFICE EQUIP MAINT ,
1,083 ,
1,722 1,649 1,310 1,666
3 30,370
462 0
122
SUBTOTAL 64,435 65,214 81,569 75,584 90,22 ,
SUPPLIES
6301 OFFICE SUPPLIES
3,828
4,762
4,000
1,619
4,000
3
4,000
113
3
6302 POSTAGE
IES 1,111
526
14 1,264
384
5 2,782
601
5 2,098
5,204 3,11
5,845 ,
5,845
6303 OPERATING SUPPL ,
65 ,
112 ,
2
100 487 2,100 500
6308 PRINTING
6312 COMPUTER SUPPLIES 992 8,172 ,
9,474 1,193 9,470
8 8,500
958 0
21
SUBTOTAL 20,522 19,694 23,957 10,601 24,52 ,
CAPITAL OUTLAY
0
0
0
0
30,000
6630 OFFICE EQUIPIFURNITURE 0 0 0 30,000 0
SUBTOTAL 0 0 0
TOTAL 380,564 464,466 505,819 364,105 507,441 589,608 0
City of Colleyville 2006-2007 Budget Worksession -Page 49 of 71
nz~izoos
City of Cotleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Engineering 001-18
FY2006 FY2007 FY2007 CM
FY2004 FY2005 Adopted FY2006 YTD Department Proposed FY2007 Adopted
Descrl tion Actual Actual Bud et as of 6f30 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
225,923
280,655
278,959
211,720
283,263
301,522
6102 TEMP HELP 1,452
849
6 1,653
498
6 0
9,169 0
2,421 0
9,169 0
4,585
6139 OVERTIME
6141 FICA EXPENSES ,
17,791 ,
21,868 22,413 16,048 22,906 23,907
6142 GROUP HEALTH INS 21.172 31,168 45,479 28,472 45,479
1
200 47,753
438
1
6143 WORKER'S COMP 1,176 1,018 1,180 941 ,
675 ,
350
1
6145 UNEMP COMP 828
531
30 135
37
835 675
35,575 1,347
27,535 35,056 ,
36,587
6146 RETIREMENT
6148 LONGEVITY PAY ,
2,153 ,
2,690 3,021 2,458 2,818 2,818
6152 ACCRUED LEAVE PAY 98
305 292
775 146
4D4 423,540
SUBTOTAL 309 511 385,320 3
, , ,
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
2,733
2,800
3,221
2,035
3,220
3 g00
6204 TRAVEL 806
320 1,174
843 0
2
000 0
2,042
3,310
2,810
6206 TRAINING
6207 PRE-EMPLOYMENT 1,262 57 ,
0 1,449 0 0
6208 ORG DEVELOPMENT 770 651 787 457
755 787
007
3 1,198
00
3
6209 DUES & SUBSCRIPTIONS 803 1,576 2,074 ,
0 0
,
6219 TESTING SERVICES
6223 ENGINEERING SERVICES 1,154
47,918 0
13,880 750
3,200 0
2,850 3,200 3,200
6225 COMPUTER SERVICES 3,348 70 D 0 0 0
6226 MISC CONTRACTUAL SVCS 0 98 0 0
0 0
6231 LEGAL ADS 710 0
278 496
529 0
413 529 529
6235 FILING FEE
6238 UTILITIES 222
7,533 8,246 10,018 7,871 10,018 11,333
6240 CELL PHONES 3,708 4,126 3,192 1,844
81 2,160
275
3 2,160
275
3
6241 TELEPHONE 2,922 3,448 3,275 2,5 .
0 ,
0
6245 EQUIPMENT RENTAL 0 0 0 0 0 0
6246 OFFICE EQUIP MAINT 0
525 0
687 0
1
150 0
124 1,560 1,560
6261 VEHICLE MAINTENANCE 186
3 4
050 ,
775
4 2,935 4250 4250
6262 GAS AND OIL , , ,
0 0
6264 MODULAR BUILDING 5,194 0
0 0
6281 COMMUNICATION MAINT 0 0 0 0 0
6285 BLDG MAINT & SUPPL 0
111
83 0
984
41 0
35,467 0
25,356 0
35,317 37,343
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
1,013
1,451
1,571
1,061
1,571
0
1,571
1
000
6302 POSTAGE 1,061 731
118
2 1,000
430
2 1,114
241
1 1,00
3,800 ,
2,000
6303 OPERATING SUPPLIES 2,129 , , ,
0 390 454
6305 UNIFORMS 88 235
463 390
498 163 498 498
6308 PRINTING
6312 COMPUTER SUPPLIES 611
725 704 1,400 1,631 10,300 7,400
310
6313 SMALL TOOLS 146 384 310 47
542 310
850 52
6326 SAFETY EQUIP & SUPPLIES 253 276 850
0 0
6360 MINOR OPERATING OUTLAY 0 0
100
28 800
000
32 984
529
33 32,000 35,000
6388 SIDEWALK CONSTRUCTION 92,585
613
98 .
461
34 ,
41,249 ,
40,312 50,719 48,758
SUBTOTAL , ,
CAPITAL OUTLAY
0
0
0
0 0
6630 OFFICE EQUIPlFURNITURE 0 0 0
6635 COMPUTER EQUIP 0 0 0 0 0 0
6645 OPERATING EQUIP 0 0 0 0 0 0
SUBTOTAL 0 0 0 0
TOTAL 491,236 461,765 475,021 358,443 490,182 509,641
7~z~~zooe City of Colleyville 2006-2007 Budget Worksession -Page 50 of 71
City of Colieyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Community Development 001-19
FY2006 FY2007 FY2007 CM
FY20D4 FY2005 Adopted FY2006 YTD Department Proposed FY2007 Adopted
Descri lion Actual Actual Bud et as of 6130 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
159,799
174,144
163,519
129,405
173,170
173,170
6102 TEMP HELP 72
0 0
993
1 0
800 0
1,754 0
2,000 0
2,061
6139 OVERTIME
6141 FICA EXPENSES 12,864 ,
13,399 12,732 9,901 13,467 13,471
6142 GROUP HEALTH INS 11,170 13,998 27,287 12,251 27,287 28.652
632
6143 WORKER'S COMP 537 490 508 405
810 537
405 810
6145 UNEMP COMP 798
269
22 263
011
23 405
209
20 16,566 20,609 20,616
6146 RETIREMENT
6148 LONGEVITY PAY ,
2,220 ,
1,118 ,
2,116 653 863 863
SUBTOTAL 209,729 228,416 227,576 171,745 238,338 240,275
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
2,846
2,915
3,362
2,116
3,362
3,362
6204 TRAVEL 1,579
18 0
861
3 0
050
3 58
1,734 0
3,350 0
2,500
6206 TRAINING , , 0 0 D
6207 PRE EMPLOYMENT 30 81 0
472 400 472 1.195
6208 ORG DEVELOPMENT
TIONS 720
1
768 551
1
335 1
902 1,379 1,940 1,940
6209 DUES & SUBSCRIP , , , 0
6213 TUITION REIMBURSEMENT 0 0 1,500 0
6225 COMPUTER SERVICES 500 0 0 0 0
0
0
6226 MISC CONTRACTUAL SVCS 29,908 1,553 0 0
1 1
000 000
1
6231 LEGAL ADS 1,766 3,027
4 1,450
1
750 40
-32 ,
000
2 ,
1,750
6235 FILING FEE 369 88 , ,
0 0
6236 ADVERTISING 0
6
905 0
617
7 0
7,312 0
7,271 7,312 8,272
6238 UTILITIES
6241 TELEPHONE ,
2,980 ,
1,807 2,735 1,375 2,735 2,735
6245 EQUIPMENT RENTAL 2,224 1,909 2,083 1,562 2.383 2,083
650
6246 OFFICE EQUIP MAINT 206 815 930 597 930 0
6261 VEHICLE MAINTENANCE 0 0 0 0 0
C
6262 GAS AND OIL 0 0 0 31 0
0 0
6264 MODULAR BUILDING 3,590 0 0 D
964 802 1,500
6282 COMMISSION EXPENSES 131 389 452 0
6285 BLDG MAINT & SUPPLIES 0
38 0
745
26 0
26
998 0
17,856 D
26,293 26,998
SUBTOTAL 55,5 , ,
SUPPLIES
6301 OFFICE SUPPLIES
1,434
1,872
1,800
760
1,550
1,550
6302 POSTAGE 1,501 886 1,250 719 1,050
300
2 1,050
2
300
6303 OPERATING SUPPLIES 4,422 3,067 2,050 2,255 , ,
0
6305 UNIFORMS 0
696 0
443 D
681 D
607 0
681 681
6308 PRINTING
6312 COMPUTER SUPPLIES 932 798 1,002 913 1,002 1,000
6360 MINOR OPERATING OUTLAY 6,642 0 0
6
783 0
254
5 0
583
6
6,583
SUBTOTAL 15,627 7,067 , , ,
CAPITAL OUTLAY
6635 COMPUTER EQUIPMENT
0
0
D
0
0
0 0
0
SUBTOTAL 0 0 0 0
TOTAL 280,894 262,228 261,357 194,856 271,214 273,856
0
0
0
0
0
0
7nnzooa City of Colleyville 2006-2007 Budget Worksession -Page 51 of 71
City of Colleyville, Texas
FY2007 General Fund Budget
Departme ntal Expense Summary
Department: Acct:
Fire 001-22
FY2006 FY2007 FY2007 CM
FY2004 FY2005 Adopted F Y2006 YTD Department Proposed FY2007
Descri lion Actual Actual Bud et as of 6130 Re uest Bud et Bu
PERSONNEL
6101 SALARIES
1,543,614
1,540,382
1,645,796
1,158,263
1,672,261
1,654,187
6139 OVERTIME 94,127 88,631 81,017 81,144
50 95,702
144
045 87,002
841
141
6141 FICA EXPENSES 125,886
779
273 126,516
789
285 139,671
308,884 92,7
234.107 ,
308,884 ,
324,328
6142 GROUP HEALTH INS
6143 WORKER'S COMP ,
43,045 ,
37,712 44,697 35,646 45,766 56,076
6145 UNEMP COMP 6,417
221
855 1,299
679
224 4,590
221,693 9,180
160,401 4,590
220,446 9,180
217,073
6146 RETIREMENT
6147 INCENTIVE PAY ,
14,925 ,
10,600 12,900 9,925 14,400 14,400
6148 LONGEVITY PAY 20,018 22,420 21,649 21,278
0 24,197
960
57 23,912
960
57
6149 HOLIDAY PAY
AY 50,132
180
11 52,084
348
13 56,448
7,952 10,415 ,
15,480 ,
13,724
6152 ACCRUED LEAVE P ,
977
2
404 ,
403,459
2 2,545,297 1,813,108 2,603,731 2,599,683
SUBTOTAL ,
, ,
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
28,174
31,576
36,413
22,923
36,413
2
36,413
020
3
6204 TRAVEL 620
868
1 564
5
465 3,160
11,100 1,783
10,449 5,1
0
15,625 ,
13,525
6206 TRAINING
6207 PRE-EMPLOYMENT ,
1,763 ,
1,076 1,000 1,562 2,600 1,500
6208 ORG DEVELOPMENT 4,986 4,011 4,880 4,480 4,880
15
122 13,590
15
122
6209 DUES & SUBSCRIPTIONS 7,900 9,206 11,556 12,446 ,
480
1 ,
480
1
6213 TUITION REIMBURSEMENT 495 464 3,960
1 677
184
6 ,
230
19 ,
9,135
6225 COMPUTER SERVICES 24,451
17 15,832
468
265 13,45
171
278 ,
376
262 ,
294,206 294,200
6226 MISC CONTRACTUAL SVCS 257,7 , , ,
0 $0
6231 LEGAL ADVERTISING 0
644
1 290
381
1 0
150
3 683 3,850 2,150
6232 FIRE EQUIP TESTING ,
576
14 ,
459
16 ,
24,471 16,232 24,471 27,681
6238 UTILITIES
6240 CELL PHONES ,
3,519 ,
9,078 9,798 5,849 12,402 9,798
6241 TELEPHONE 10,509 11,655 13,300 7,205
250 13,784
4
041 13,272
447
3
6245 EQUIPMENT RENTAL 4,249 4,228 3,854 2, ,
450 ,
0
6246 OFFICE EQUIP MAINT
6261 VEHICLE MAINTENANCE 0
30,951 0
62,490 100
55,800 0
49,874 66,300 66,300
6262 GAS AND OIL 12,652 19,690 25,179 17,559
300
8 29,500
10
790 29,149
10,790
6264 MODULAR BUILDING 11,620
544 10,790
883
22 10,790
476
18 ,
13,759 ,
22,834 20,138
6281 COMMUNICATION MAINT 23,
376 ,
785
4 ,
474
3 449
3 10,300 7,096
6284 EQUIPMENT MAINT
6285 BLDG MAINT & SUPPL 10,
17,401 ,
15,437 ,
16,732 ,
13,809 23,950 14,750
6287 PROPERTY MAINT 0 0 292 40 200
0 200
0
6295 SPECIAL PROJlCONTRIB
ONS 0
299
6 3,000
849
6 0
555
8 0
11,262 11,232 13,047
6297 PHYSICALSlVACCINATI , , , 0 0 0
6299 MISCELLANEOUS 0
314
475 225
901
522 0
557,662 473,152 628,780 605,809
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
1,178
1,427
2,235
769
2,335
0
1,585
1
150
6302 POSTAGE
IES 724
383
9 876
477
17 547
10,810 410
7,905 1,15
13,135 ,
9,585
6303 OPERATING SUPPL ,
739 ,
1
024 500
1 1,160 2,150 2,150
6304 CHEMICALS
6305 UNIFORMS 17,996 ,
19,603 ,
22,243 19,844 29,254 20,190
6306 FIRE PREVENTION 383 1,164 1,000 1,084
496 2,000
100
1 2,000
1
100
6308 PRINTING 967 504 1,000 0 ,
9
100 ,
5,000
6310 EOC OPERATING SUPPLIES
6311 EMERG MED SUPPLIES 0
17,834 0
18,198 0
18,640 12,103 ,
20,935 19,561
6312 COMPUTER SUPPLIES 4,523 11,023 2,640 1,354 3,452
575
8 3,102
1
900
6313 SMALL TOOLS 1,763 3,972 2,500
00 1,658
221
1 ,
750
1 ,
1,750
6326 SAFETYEQP/SUPPLIES
IVE 840
16
775 383
289
15 1,5
24,360 ,
16,328 ,
17,505 17,500
)
6331 GEAR (PROTECT , , 270
2 0
6360 MINOR OPERATING OUTLAY 17,860 42,147
3
088 0
975
88 ,
602
66 112,441 86,578
SUBTOTAL 90,965 ,
13 , ,
CAPITAL OUTLAY
6610 LAND
0
2,000
0
0
0 0
0
6620 BUILDINGS 0 0 0 0 0
0
0
6635 COMPUTER EQUIPMENT 0 0 0 0
City of Colleyville 2006-2007 Budget Worksession -Page 52 of 71
~rznzoos
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department:
Fire
Acct:
001-22
FY2006 FY2007 FY2007 CM
FY2004 FY2005 Adopted FY2006 YTD Department Proposed FY2007 Adopted
Descri lion Actual Actual Bud et as of 6130 Re uest Bud et Bud et
6640 COMMUNICATION EQUIP
6645 OPERATING EQUIP
6650 MOTOR VEHICLES
SUBTOTAL
TOTAL
53,943 0 0 0
39,875 0 10,400 14,336
0 0 0 0
93,818 2,000 1 D,400 14,336
3,065,075 3,061,449 3,202,334 2,367,198
0 0
18,350 45,352
0 0
18,350 45,352
3,363,302 3,337,422
~iz7/zoos City of Colleyville 2006-2007 Budget Worksession -Page 53 of 71
City of Colleyville, Texas
FY2006 General Fund Budget
Departmental Expense Summary
Department: Acct:
Police 001-23
FY2006 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2006 YTD Department Proposed Adopted
Descri lion Actual Actual Bud et as of 6130 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
1,786,955
1,784,984
1,901,689
1,357,938
1,893,265
2,084,543
6139 OVERTIME 55,881 62,369 70,508 56,797 70,508
832
156 95,504
872
172
6141 FICA EXPENSES 140,514
76 141,147
806
299 157,104
831
363 108,027
717
255 ,
381,774 ,
408,937
6142 GROUP HEALTH INS
6143 WORKER'S COMP 265,9
60,313 ,
52,758 ,
52,220 ,
41,646 52,380 66,661
6145 UNE~4P COMP
T 8,632
178
245 1,275
948
249 5,670
249,364 11,704
183,831 5,670
237,029 12,690
261,577
6146 RETIREMEN
6147 INCENTIVE PAY ,
33,130 ,
33,891 36,000 23,102 34,800 33,300
6148 LONGEVITY PAY 28,000 30,530 33,699
755 31,358
361
10 34,389
189
15 32,346
12,128
6152 ACCRUED LEAVE PAY 9,525
104
634
2 9,409
118
2
666 11,
2,661,840 ,
2,080,480 ,
2,881,836 3,180,558
SUBTOTAL ,
, ,
,
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
37,522
39,528
45,158
28,725
45,158
45,158
6204 TRAVEL 407
020
7 1,064
092
6 3,200
9,580 461
9,368 3,200
10,990 3,300
10,990
6206 TRAINING
6207 PRE-EMPLOYMENT ,
13,283 ,
11,373 1,825 1,518 1,825 1,825
6208 ORG DEVELOPMENT 5,753 5,928 6,297 4,472
12 6,297
096
2 16,787
096
2
6209 DUES & SUBSCRIPTIONS 1,542
298 2,297
188
4 2,786
10
000 2,5
4
845 ,
10,000 ,
10,000
6210 TECHNICAL & SCIENTIFIC 4,
8
100 ,
100
8 ,
8,500 ,
6,643 9,450 9,450
6224 VET SERVICES
6225 COMPUTER SERVICES ,
34,902 ,
45,451 37,206 35,501 33,906 33,906
6226 MISCCONTRACTUALSVCS 1,890 1,208 2,142 481
228
7 2,592
464
6 2,392
464
6
6227 MAINT AGREEMENT 23,625 29,453
464 6,399
000
3 ,
903
2 ,
475
6 ,
3,475
6229 COMMUNITY RELATIONS 1,889
1 3,
785
5 ,
985
4 ,
422
3 ,
4,985 4,985
6230 DARE OFFICER EXPENSES 5,15 , , ,
0 0 0
6231 LEGAL ADS
6238 UTIIiTIES 0
85,354 0
90,475 0
95.940 88,156 95,940 107,453
6240 CELL PHONES 4,021 4,482 3,900
298
30 4,502
27
382 4,260
298
30 4,260
30,263
6241 TELEPHONE
6243 SCHOOL CROSS GUARD 28,822
28,174 35,889
29,210 ,
38,075 ,
29,716 ,
40,000 40,000
6245 EQUIPMENT RENTAL 1,210 1,210 714
423 807
2
815 887
116
4 887
6,116
6246 OFFICE EQUIP MAINT 6,673 13,167
11 5,
508
3 ,
674
1 ,
608
3 3,608
6249 JAIL COST
6261 VEHICLE MAINTENANCE 2,864
20,618 2,5
19,583 ,
17,202 ,
12,919 ,
15,625 15,625
6262 GAS AND OIL 42,880 54,123 63,386
11 45,821
040
17 92,216
460
26 67,421
27,524
6281 COMMUNICATION MAINT 23,244 26,895
03 26,0
300
2 ,
3
500 ,
000
4 4,000
6284 EQUIPMENT MAINT (5,175) 3,8 , , ,
0 0
6285 BLDG MAINT & SUPPL 0 3,899 0 96 0 0
6295 SPECIAL PROJ/CONTRIB 3,200 0 0 0
98 435 1 11
6297 PHYSICALS/VACCINATIONS 45 0 435
0 0
6299 MISCELLANEOUS
SUBTOTAL 12
387,324 18
449,194 0
428,270 396
343,002 461,283 459,095
SUPPLIES
6301 OFFICE SUPPLIES
1,099
2,559
1,294
1,261
1,469
095
2
1,469
095
2
6302 POSTAGE
LIES 518
094
3 1,087
765
28 1,095
2,959 1,432
2,627 ,
5,104 ,
5,104
6303 OPERATING SUPP
6305 UNIFORMS ,
12,024 ,
12,432 15,100 12,301 17,423 16,523
6308 PRINTING 482 1,319 2,496 1,239
576 2,153
138
6 1,693
138
6
6312 COMPUTER SUPPLIES 6,909 7,080 5,168 3, ,
860 ,
860
6315 ANIMAL CONTROL
PLIES 575
905
1 1,008
10
303 1,360
2,310 1,040
2,159 5,882 5,882
6321 FIRE ARMS SUP
6322 CID SUPPLIES ,
1,903 ,
1,726 1,785 203 1,640 1,640
6326 SAFETY EQP/SUPPLIES 690 887 1,200 1,621 1,775 1,770
6360 MINOR OPERATING OUTLAY 6,656
3 27,070
94
236 0
767
34 525
984
27 0
44,539
43,179
SUBTOTAL 35,85 , , ,
CAPITAL OUTLAY
6635 COMPUTER EQUIPMENT
0
0
0
0
2,000
0
C
6640 COMMUNICA~ON EQUIP 0 0 6,500 6,416 1,770
City of COlleyville 2006-2007 Budget Worksession -Page 54 of 71
7rz~tzooe
City of Colleyville, Texas
FY2006 General Fund Budget
Departmental Expense Summary
Department:
Police
Acct:
001-23
FY2006 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2006 YTD Department Proposed Adopted
Descri tion Actual Actual Bud et as of 6/30 Re uest Bud et Bud et
6645 OPERATING EOUIP 0 6,793 700
6650 MOTOR VEHICLES 91,467 0 0
SUBTOTAL 91,467 6,793 7,200
TOTAL 3,148,747 3,216,341 3,352,077
0 3,100
100 0
6,516 6,870
2,457,982 3,394,528 3,682,832
City of Colleyville 2006-2007 Budget Worksession -Page 55 of 71
~~z7izoos
City of Cotieyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Parks Maintenance 001-32
FY2006 FY20D7 FY2007 CM
FY2004 FY2005 Amended FY2006 YTD Department Proposed FY2007 Adopted
Descri lion Actual Actual. Bud et as of 6130 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
363,908
363,878
376,750
263,275
380,891
409,743
6139 OVERTIME 8,069 13,322 12,528 9,039 16,736
30
516 11,429
432
32
6141 FICA EXPENSES 27,937 28,201
076
1 29,871
91
020 20,095
53
159 ,
91
020 ,
104,542
6142 GROUP HEALTH INS 57,338
1
017 7
,
643
9 ,
260
11 ,
980
8 ,
11,431 13,973
6143 WORKER'S COMP 1
,
687
2 ,
446 ,
1
485 ,
3,006 1,485 3,240
6145 UNEMP COMP
6146 RETIREMENT ,
46,312 47,938 ,
47,412 33,248 45,564 46,760
6148 LONGEVITY PAY 890 1,215 1,185 980 1,280
0 1,380
401
1
6152 ACCRUED LEAVE PAY 0
158
518 0
535,719 0
571,511 0
391,782 578,923 ,
623,499
SUBTOTAL ,
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
3,973
4,071
4,686
2,957
350
4,686
450
2
4,686
050
2
6204 TRAVEL 1,604
112
3 2,910
964
8 2,150
8.323 8,528 ,
8,223 ,
7,023
6206 TRAINING
6207 PRE-EMPLOYMENT ,
338 ,
523 0 2,150 0
53 0
197
4
6208 ORG DEVELOPMENT 1,475 1,267 1,653 1,022
5 1,6
950
1 ,
1
95
6209 DUES & SUBSCRIPTIONS 1,625 1,934 1,785 1,23 ,
0 ,
0
6223 ENGINEERING SERVICES 1,650 5,353 D X0438 996 996
6225 COMPUTER SERVICES
S 3,331
161
331 2,163
214
226 996
000
280 830
123,684 380,068 294,547
6226 MISC CONTRACTUAL SVC , , ,
0 821
1 300 0
6231 LEGAL ADS 596
841
81 2,381
94
683 126,224 ,
89,662 140,224 138,776
6238 UTILITIES
6240 CELL PHONES ,
2,402 ,
2,853 2,304 2,365 2,364 2,364
6241 TELEPHONE 9.681 8,663 13,590 5,853
5 16,852
725
9 15,883
7
880
6245 EQUIPMENT RENTAL 5,276 6,777 8,300
700 4,17
1
807 ,
400
4 ,
4,400
6261 VEHICLE MAINTENANCE 2,213 2,992
082
10 2,
11
525 ,
603
7 ,
17,000 11,525
6262 GAS AND OIL
6281 COMMUNICATION MAINT 6,339
13,269 ,
6,740 ,
5,733 ,
4,317 5,733 6,177
6282 COMMISSION EXPENSES 197 6
12 102
825
6 97
188
6 102
10,400 100
10,400
6284 EQUIPMENT MAINT.
UPPL 7,221
31
466 8,5
134
20 ,
20,365 ,
14,348 51,899 21,725
6285 BLDG MAINT & S
6287 PROPERTY MAINT ,
64,086 ,
64,537 60,790 43,851 72,790 69,040
6295 SPEC PROJ/CONTRIB S,OOD 284 0 0 0
0 10,000
0
6299 MISCELLANEOUS 0
027
408 0
044
482 0
558,051 0
343,281 731,815 613,719
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
2,679
1,644
2,300
1,597
2,450
2,300
200
6302 POSTAGE
6303 OPERATING SUPPLIES 84
11,452 3,012
16.530 120
12,000 499
8,230 200
13,500 13,500
6304 CHEMICALS 4,769 8,187 8,000 4,993
1 10,500
078
3 8,500
547
2
6305 UNIFORMS 1,940 1,948 2,547 87
38 ,
570 ,
570
6308 PRINTING
6309 LANDSCAPE 190
12,797 505
6,709 570
13,075 2,025 15,075 13,075
6312 COMPUTER SUPPLIES 654 1,375 500 677 850
000
5 850
4
250
6313 SMALL TOOLS 3,938 4,864 4,250 1,212 ,
0 ,
0
6324 REPAIR AND MAINT
6326 SAFETY SUPPLIES 0
1,577 0
1,445 0
2,520 0
1,477 2,720 2,520
6360 MINOR OPERATING OUTLAY
3,591
0
219
46
0
45
882
2,OD0
618
23
0
53,943 0
48,312
SUBTOTAL 43,672 , , ,
CAPITAL OUTLAY
6615 LAND IMPROVEMENTS
396,441
0
0
D
0 0
0
6620 BUILDINGS 6,082 4,790 0 0
0 0
0 40,000
6625 IMPROV OTHER THAN BLDG 0 92,854 0 0
6645 OPERATING EQUIPMENT 52,887 29,679 0 5,284 0 0
6650 MOTOR VEHICLES 0 0 D
0 0
284
5 0
0 40,000
SUBTOTAL 455,410 127,323 ,
TOTAL 1,425,267 1,191,306 1,175,444 764,164 1,364,681 1,325,530
City of Colleyville 2006-2007 Budget Worksession -Page 56 of 71
7/27/2006
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Streets 001-33
FY2006 FY2007 FY2007 CM
FY2004 FY2005 Amended FY2006 YTD Department Proposed FY2007 Adopted
nocc~inrlnn __Actual Actual Bud et as of 6f30 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
355,304
356,892
384,738
248,238
362,495
4
356,500
234
1
6135 STANDBY 616
6
667 1,002
8,187 1,234
10,378 690
6,217 1,23
10,378 ,
10,378
6139 OVERTIME
6141 FICA EXPENSES ,
28,008 28,073 31,934 19.886 29,546
8 28.752
104
925
6142 GROUP HEALTH INS 63,089 73,295 99,929 58,231
02 90,95
333
35 ,
657
38
6143 WORKER'S COMP 40,869 33,665 38,122
1
485 30,4
622
2 ,
350
1 ,
1,350
6145 UNEMP COMP 2,072
47
834 249
207
49 ,
50,688 ,
33,183 ,
45,217 44,001
6146 RETIREMENT ,
895
7 ,
105
8 16,265 6,610 7,294 6.064
6148 LONGEVITY PAY
Y , ,
6152 ACCRUED LEAVE PA 555 397 562,517 639,599 410,987 585 467 593,523
SUBTOTAL
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
17,223
15,317
15,435
9,717
15,435
15,435
250
6204 TRAVEL 48
50 0
246 250
1,000 0
964 250
1,000 1,000
6206 TRAINING 538 500 398 306 398 398
6207 PRE-EMPLOYMENT 1
589 1
152 1,574 1,512 1,574 3,997
6208 ORG DEVELOPMENT ,
190 ,
120 400 60 400 400
6209 DUES & SUBSCRIPTIONS 008
2 403 628 241 628 1,000
6225 COMPUTER SERVICES , 21 0 199
6 0 6,000
6226 MISC CONTRACTUAL SVCS 13,148 232,5 ,
241 423 423
6231 LEGAL ADS 1,203
634 182
643 423
1,737 1,045 1,737 2,021
6238 UTILITIES 0 0 0 0 0
6239 INSPECTION TESTING 476
1
905 245
2 2,220 1,687 2,220 2,220
6240 CELL PHONES ,
264
2 ,
186
2 2,012 1,435 2,012 2,007
6241 TELEPHONE
6242 STREET LIGHTING ,
126,493 ,
141,903 161,327 132,223 161,327 178,557
6245 EQUIPMENT RENTAL 1,041 809 935
0 919
700
5 935
7
500 935
7,500
6261 VEHICLE MAINTENANCE 12,943 8,626 7,90
032 ,
340
18 ,
24
000 27,922
6262 GAS AND OIL 11,425
97 14,936
605
3 18,
870
3 ,
518
2 ,
3,870 4,129
6281 COMMUNICATION MAINT 5,6 .
0 ,
1
475 ,
72 1,475 1,000
6283 SAFETY SERVICES 1,156
788
6 766
4 ,
200
6 6,256 8,500 8,500
6284 EQUIPMENT MAINT
6285 BLDG MAINT & SUPPL ,
2,184 ,
2,131 ,
2,710 2,351 2,710 2,200
6287 PROPERTY MAINT 315 337 600 9 600
0 300
0
6299 MISCELLANEOUS 0
317
209 32
658
432 0
229,126 33
191,829 236,994 266,194
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
872
529
950
493
950
150
950
150
6303 OPERATING SUPPLIES 0
291
6 3,854
405
8 150
512
7 9
2,397 7,512 7,512
6305 UNIFORMS , ,
95 ,
220 0 220 170
6308 PRINTING 65
225 0 300 91 300 200
6312 COMPUTER SUPPLIES 1
035 690 1,400 130 1,400 1,400
6313 SMALL TOOLS
6316 STREET MAINT SUPPLIES ,
36,178 30,568 54,950 44,667 54,950
000
20 54,950
000
20
6317 STREET CONTROL SIGNS 12,884 18,943 20,000
00 13,063
344
583 ,
000
650 ,
800,000
6319 STREET RESURFACING 583,963 324,415
966 650,0
2
250 ,
506
1 ,
2,250 2.250
6326 SAFETY EQP/SUPPLIES 2,209 5, , ,
0 0
6327 MOSQUITO CONTROL 481 0 0 0 0 0
6360 MINOR OPERATING OUTLAY 11,702 0 0 0 0 0
6388 SIDEWALK CONSTRUCTION 0
904
655 0
464
393 0
737,732 0
645,700 737,732 887.582
SUBTOTAL , ,
CAPITAL OUTLAY
6615 LAND IMPROVEMENTS
0
0
0
0 0
0 0
0
6620 BUILDINGS 0 10,266 0 130
0 6,000 0
6625 IMPROVEMENTS STREET LIGHTS 0 0
6635 COMPUTER EQUIPMENT 0 0 0 0 0 0
6640 COMMUNICATION EQUIP 0 0 0 0 0 0
6645 OPERATING EQUIP 0 111,315 0 0 0 0
6650 MOTOR VEHICLES 0 145,964 0 0
130 000
6 0
SUBTOTAL 0 267,545 0 ,
TOTAL 1,420,618 1,656,184 1,606,457 1,248,647 1, 566,193 1,747,299
City of COlleyville 2006-2007 Budget Worksession -Page 57 of 71
zrz7rzoos
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Recreation 001-34
FY2006 FY2007 FY2007 CM
FY2004 FY2005 Adopted FY2006 YTD Department Proposed FY2007 Adopted
Descri lion Actual Actual Bud et as of 6130 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
78,471
78,386
79,394
61,055
77,688
77,688
6141 FICA EXPENSES 5,772 5,790 6,120 4,660 5,943 5,943
6142 GROUP HEALTH INS 15,657 16,076 18,192 9,976 18,192 19,101
6143 WORKER'S COMP 238 209 244 195 237 279
6145 UNEMP COMP 414 69 270 830 270 540
6146 RETIREMENT 10,089 10,274 9,713 7,793 9,095 9,095
6148 LONGEVITY PAY 280 680 600 600 0 0
SUBTOTAL 110,921 111,484 114,533 85,108 111,425 112,646
CONTRACTUAL SERVICES
6204 TRAVEL 487 637 500 0 500 500
6206 TRAINING 2,327 4,483 4,930 2,580 6,770 4,085
6207 PREEMPLOYMENT 0 133 0 828 0 0
6208 ORG DEVELOPMENT 298 220 315 183 315 799
6209 DUES & SUBSCRIPTIONS 725 445 755 460 1,030 885
6213 TUITION REIMBURSEMENT 6,647 0 0 0 0 0
6225 COMPUTER SERVICES 9,503 3,646 4,227 3,448 4,839 4,089
6226 MISCCONTRACTUALSVCS 0 5,455 3,130 908 3,130 3,130
6240 CELL PHONES 494 559 714 486 1,800 1,200
6245 EQUIPMENT RENTAL 1,965 1,784 1,691 1,241 6,830 6,830
6246 OFFICE EQUIP MAINTENANCE 0 0 0 0 155 65
6257 PROGRAM INSTRUCTORS 106,959 87,661 108,454 75,503 100,327 100,327
6284 EQUIP MAINTENANCE 0 0 0 0 474 0
6295 SPECIAL PROJlCONTRIB 24,768 17,768 700 434 800 800
SUBTOTAL 154,173 122,791 125,416 86,069 126,970 122,710
SUPPLIES
6301 OFFICE SUPPLIES 1,821 1,294 1,800 1,142 2,985 1,800
6302 POSTAGE 5,730 6,807 5,510 4,583 5,820 5,820
6303 OPERATING SUPPLIES 2,722 1,785 1,662 795 2,970 2,612
6305 UNIFORMS 0 0 250 209 500 260
6307 REC PROGRAM SUPPLIES 9,473 10,270 11,500 12,314 19,699 17,064
6308 PRINTING 16,526 19,109 24,615 7,087 25,615 24,615
6312 COMPUTER SUPPLIES 810 767 760 483 1,500 900
6328 RECREATION EQUIP 2,539 2,639 3,000 369 5,240 2,600
SUBTOTAL 39,620 42,672 49,097 26,982 64,329 55,671
CAPITAL OUTLAY
6635 COMPUTER EQUIP 9,490 0 0 0 11,337 0
SUBTOTAL 9,490 0 0 0 11,337 0
TOTAL 314,203 276,946 289,046 198,159 314,061 291,027
City of Colleyville 2006-2007 Budget Worksession -Page 58 of 71
0
0
0
0
0
7!28/2006
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department:
Communications
Acct:
001-36
Descri Lion
FY2004
Actual
FY2005
Actual FY2006
Adopted
Bud et
FY2006 YTD
as of 6130 FY2007
Department
Re uest FY2007 CM
Proposed
Bud et FY2007
Adopted
Bud et
PERSONNEL
6101 SALARIES
50,405
48,658
56,264
40,513
75
57,678
412
4
57,678
4
412
6141 FICA EXPENSES 3,650 3,591 4,304
96 2,9
234
6 ,
096
9 ,
9,551
6142 GROUP HEALTH INS 10,989 8,018 9,0 ,
137 ,
176 207
6143 WORKER'S COMP 153 145
46 172
135 278 135 270
6145 UNEMP COMP 207
482
6 337
6 6,832 5,087 6,753 6,753
6146 RETIREMENT , ,
55 0 0 0 0
6148 LONGEVITY PAY 195
081
72 2
67
050 76,803 55,223 78,250 78,871
SUBTOTAL , ,
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
322
330
380
239
320
380
300
3
380
3,300
6204 TRAVEL 1,011 323
0 1,800
1
300 179 ,
1,100 1,10
6206 TRAINING 400 ,
0
69
0 0
6207 PRE-EMPLOYMENT 0 67 157 91 157 400
6208 ORG DEVELOPMENT 124 110
375 865 170 1,045 870
6209 DUES & SUBSCRIPTIONS 450 0 134 4
599 D
6225 COfv1PUTER SERVICES 0
0 0
4
400 309
3 21,643 ,
5,209 4,809
6226 MISC CONTRACTUAL SVCS , , 0 0 0
6236 ADVERTISING 0
602 0
699 0
671 667 671 759
6238 UTILITIES 599 466 516 666 600 600
6240 CELL PHONES 879
1 350 2,247 243 2,247 2,247
6241 TELEPHONE ,
946
5 646
6 5.320 0 B,ODO 10,000
6256 NEWSLETTER , ,
0 0 0
6264 MODULAR BUILDING 548
D 0 0
6285 BLDG MAINT & SUPPL 0 0
0 0
722
5 4
236 8'150 9,560
6288 HISTORIC PRESERVATION 0 , '
D
0 0
6293 COMMITTEE EXPENSE 0
881
11 D
13,766 0
22,287 26,657 35,458 34,025
SUBTOTAL ,
SUPPLIES
6301 OFFICE SUPPLIES
368
150
450
179
2
450
17
200
450
200
1
6302 POSTAGE 2,855
4 3,502
86 5,460
600
1 1,27
776
1 ,
2,100 ,
1,100
6303 OPERATING SUPPLIES 16 80 ,
1
460 ,
128 1,600 960
6308 PRINTING
6312 COMPUTER SUPPLIES 323
248 310 ,
1,551 777 1,306
8 1,200
098
35
6336 CELEBRATE COLLEYVILLE 51,322 37,042 35,098 33,063 35,09
0 0
,
6399 MISCELLANEOUS 5,752
61
031 5,591
762
46 0
45,619 0
37.194
57,754
40,008
SUBTOTAL , ,
CAPITAL OUTLAY
0
0
0
0 0 D
6630 OFFICE EQUIPIFURNITURE
0
0
0 0
SUBTOTAL 0 0
TOTAL 144,993 127,577 144,709 121,074 171,462 152,904
City of Colleyville 2006-2007 Budget Worksession -Page 59 of 71
0
0
0
0
0
~rznzoor,
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department:
Collewille Center
a~~t:
001-37
FY2007 FY2007 CM
Description _ FY2004
Actual FY2005
Actual FY2006 Adopted
Bud et FY200fi YTD
as of 6/30 Department
Re uest Proposed
Bud et FY2007 Adopted
Bud et
PERSONNEL
6101 SALARIES
171,696
170,752
174,365
121,018
171,324
171,324
0
6102 TEMP HELP 1,132 607 2,450
4 2,198
2
923 2,450
215
4 2,45
4,215
6139 OVERTIME 4,118
13
290 4,438
236
13 2
3.6
13,963 ,
9,630 ,
13,732 13,732
6141 FICA EXPENSES
6142 GROUP HEALTH INS ,
20,441 ,
22,799 27,536 15,448 27,536 28,913
6143 WORKER'S COMP 2,483 2,111 2,290
80 1,826
391
1 2,356
080
1 2,677
2,160
6145 UNEMP COMP 1,163
17
808 176
448
18 1,0
17,220 ,
12,667 ,
16,085 16,085
6146 RETIREMENT , ,
6148 LONGEVITY PAY 507
233 234 359 244 609 169,163 240 293 243 071
SUBTOTAL ,
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
4,017
4,064
4,686
2,950
4
4,686
153
3
4,686
550
2
6204 TRAVEL 1,573 1,821 2,725 74
0 ,
419 ,
419
6206 TRAINING 10 636
124 419
100 181 100 100
6207 PRE-EMPLOYMENT 0 496 787 440 787 1,799
6208 ORG DEVELOPMENT 608 400 400 425 400 400
6209 DUES & SUBSCRIPTIONS 400 05 1
628 074
1 1,628 1,628
6225 COMPUTER SERVICES 2,261 1,6 ,
300 ,
26 30 30
6226 MISC CONTRACTUAL SVCS 600 30 0 0
6231 LEGAL ADS 0
391
3 0
905
5 0
6,665 0
4,532
6,665
8,665
6236 ADVERTISING ,
24
018 ,
687
25 28,112 22,611 28,112 31.800
6238 UTILITIES ,
211 ,
183 179 0 179 179
6240 CELL PHONES 889
6 308
6 7,394 4,750 7,394 7,394
6241 TELEPHONE
6245 EQUIP RENTAL ,
3,367 ,
2,404 2,380 1,593 2,380 2
6261 VEHICLE MAINTENANCE
2
1,754
500
185
0
0 500
150
6262 GAS AND OIL
6285 BLDG MAINT & SUPPL 0
18,829 157
20.524 212
25,000 109
13,781 25,740 25,000
6287 PROPERTY MAINTENANCE 1,379 0 2,750 650 2,750 2,000
6299 MISCELLANEOUS 0
555
67 0
72
098 0
84,237
54,057
84,693
89,950
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
1,355
963
755
1,048
44
755
600
1 755
1
600
6302 POSTAGE 235
12 323
164
6 1,600
700
6 1
5.292 ,
8,200 ,
8,200
6303 OPERATING SUPPLIES 4,9 , ,
599 258 599 599
6305 UNIFORMS 578
2
630 671
654
1 2,600 327 2,600 2,600
6308 PRINTING ,
0 ,
0 200 0 200 100
6309 LANDSCAPE
6312 COMPUTER SUPPLIES 175 1.037 1,876 122 1,800 1,276
50
6313 SMALL TOOLS 0 0 100 0 100
0 0
6360 MINOR OPERATING OUTLAY 0
84 1,161
974
11 0
430
14 0
7,191 15,854 15,180
SUBTOTAL 9,8 , ,
CAPITAL OUTLAY
0
0
0 0 0
6635 COMPUTER EQUIPMENT 0 0 0 0
SUBTOTAL 0 0 0
TOTAL 310,946 318,431 343,276 230,411 340,840 348,201
City of Colleyville 2006-2007 Budget Worksession -Page 60 of 71
0
0
0
0
0
~n7rzoos
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department:
Human Resources Acct:
00139
FY2006 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2006 YTD Department Proposed Adopted
Actual Actual Bud et as of 6130 Re uest Bud et Budget
Descri lion
PERSONNEL 101,324 101,324
6101 SALARIES 7 898 7,898
6141 FICA EXPENSES 18,067 19,102
6142 GROUP HEALTH INS 371 371
6143 WORKER'S COMP 540 540
6145 UNEMP COMP 12,086 12,086
6146 RETIREMENT 1,913 1,913
6148 LONGEVITY PAY
0 0 0 142,199
143,234
SUBTOTAL 0
CONTRACTUAL SERVICES 2,056 2,056
6203 INSURANCE SHARE 1,200 1,200
6204 TRAVEL 1,310 1,310
6206 TRAINING 0 0
6207 PRE-EMPLOYMENT 696 799
6208 ORG DEVELOPMENT gg7 967
6209 DUES & SUBSCRIPTIONS 0 0
6225 COMPUTER SERVICES p 30,000
6226 MISC CONTRACTUALSVCS 0 0
6236 ADVERTISING 4,013 4,494
6238 UTILITIES p 0
6240 CELL PHONES 2,247 2,247
6241 TELEPHONE 0 0
6256 NEWSLETTER 0 0
6285 BLDG MAINT & SUPPL 0 0
6293 COMMITTEE EXPENSE
0 0 12,489
43,073
SUBTOTAL 0 0
SUPPLIES 160 160
6301 OFFICE SUPPLIES 200 200
6302 POSTAGE 177 177
6303 OPERATING SUPPLIES 0 0
6308 PRINTING
0
0
6312 COMPUTER SUPPLIES 0 0
6399 MISCELLANEOUS
0 0 537
537
SUBTOTAL 0 0
CAPITAL OUTLAY 0 0
6630 OFFICE EQUIPIFURNITURE p
0 0
SUBTOTAL 0 0 0
0 0 0 0 155,225 186,844
TOTAL
City of Colleyville 2006-2007 Budget Worksession -Page 61 of 71
0
0
0
0
0
111712 0 0 6
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Municipal Court 001-41
FY2006 FY2007 FY2007 CM
Descri tion FY2004
Actual FY2005
Actual Adopted
Bud et FY2006 YTD
as of 6130 Department
Re uest Proposed
Bud et FY2007 Adopted
Bud et
PERSONNEL
6101 SALARIES
96,144
103,625
104,978
75,584
20
050
109,691
290
41
109,691
740
40
6126 MUNICIPAL JUDGE 35,520 33,490 41,290 , 0
, 0
,
6127 ATTORNEY 0 0 0
0 0
90
0
0
6139 OVERTIME
6141 FICA EXPENSES 287
6,875 48
7,475 8,136 5,370 8,519 8,519
6142 GROUP HEALTH INS 18,328 29,027 27,287 25,383 27,287 28,652
400
6143 WORKER'S COMP 330 278 324 258
810 340
405 810
6145 UNEMP COMP 714
461
12 195
629
13 405
12,915 9,669 13,038 13,038
6146 RETIREMENT
6148 LONGEVITY PAY ,
1,005 ,
1,230 1,380 1,380 1,675 1,675
0
SUBTOTAL 171,665 188,998 196,715 138,594 202,245 203,525
CONTRACTUAL SERVICES
6203 INSURANCE SHARE
191
195
217
237
217
350
1
217
1
350
6206 TRAINING 467 875 1,150 676 ,
0 ,
0
6207 PRE-EMPLOYMENT 1,946 0 0 0
274 472 1,199
6208 ORG DEVELOPMENT 372 331 472 0 100 100
6209 DUES & SUBSCRIPTIONS 145 0
522 153
1
080 192 1,080 840
6211 JURY FEE/MISC 390 , 0 84 84
6225 COMPUTER SERVICES 8,770 0 84 0 360 360
6226 MISC CONTRACTUAL SVS 0
234
12 0
963
9 0
10,592 9,714 10,592 11,863
6238 UTILITIES
6241 TELEPHONE ,
3,055 ,
18 2,864 617 2,267 2,267
6246 OFFICE EQUIP MAINT 0 0 312 198 344
0 344
0
6285 BLDG MAINT & SUPPL 2,238
500
18 0
215
21 0
21,000 0
21,215 22,000 0
6290 TEEN COURT , , 0 0 0 0
6299 MISCELLANEOUS 0
307
48 171
291
33 37,924 33,122 38,866 18,624 0
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
234
650
450
995
48
1
709
450
115
2
450
2,115
6302 POSTAGE
ES 1,592
530
2 1,278
397
4 1,
2,318 ,
355 ,
2,124 2,124
6303 OPERATING SUPPLI ,
879
3 ,
825
2 3,478 230 3,828 3,478
6308 PRINTING
6312 COMPUTER SUPPLIES ,
1,078 ,
2,621 750 90 1,900 1,900
6360 MINOR OPERATING OUTLAY 2,885 2,094 0
91 0
2
432 0
417
10 0
10,067 0
SUBTOTAL 12,199 13,865 8,9 , ,
CAPITAL OUTLAY
6630 OFFICE EQUIP/FURNITURE
0
0
0
0
0
0
0
0
6635 COMPUTER EQUIPMENT 0 0 0 0 0 0 0
SUBTOTAL 0 0 0 0
TOTAL 232,172 236,154 243,630 174,148 251,528 232,216 0
City of Colleyville 2006-2007 Budget Worksession -Page 62 of 71
7/27/2006
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Fleet Maintenance 001-51
FY2007 FY2007 CM
Descri lion FY2004
Actual FY2005
Actual FY2006 Adopted
Bud et FY2006 YTD
as of 6/30 Department
Re nest Proposed
Bud et FY2007 Adopted
Bud et
PERSONNEL
6101 SALARIES
106,024
107,137
107,266
79,609
107,739
107,739
6139 OVERTIME 131
649 247
032
8 2,426
620
8 458
166
6 2,427
8,675 1,072
8,571
6141 FICA EXPENSES
6142 GROUP HEALTH INS 7,
22,835 ,
22,667 ,
27,287 ,
17,723 27,287 28,652
6143 WORKER'S COMP 3,707 3,142 3,422 2,729 3,443
405 3,838
810
6145 UNEMP COMP
6146 RETIREMENT 642
13,952 81
14,358 405
13,682 810
10,553 13,276 13,117
6148 LONGEVITY 2,415 2,595 2,991 2,930 3,231
960 3,231
960
6150 TOOL ALLOWANCE 498
157
854 480
158
738 960
167,059 701
121,680 167,443 167,990
SUBTOTAL , ,
CONTRACTUALSVCS
6203 INSURANCE
1,586
1,625
1,874
1,180
1,874
1,874
6206 TRAINING
6207 PRE EMPLOYMENT 0
148 0
120 0
120 0
50 0
120 0
120
6208 ORG DEVELOPMENT 522 808 472
1
00 393
1
512 472
1
500 1,199
1,500
6209 DUES AND SUBSCRIPTIONS 1,500 1,500 ,5 .
373 ,
1
079 690
6225 COMPUTER SERVICES
AINT 1,036
448
3 531
761
4 1,079
883
3 1,728 ,
3,883 3,883
.
6228 PROFESSIONAL M ,
886 ,
064
1 ,
1
405 1,028 1,405 1,589
6238 UTILITIES
6241 TELEPHONE 585 ,
392 ,
356 258 356 354
6245 EQUIPMENT RENTAL 0
124 46
375 0
204 26
307 0
1,000 0
1,000
6261 VEHICLE MAINTENANCE 693 175
1 329
1 1,108 2,000 1,729
6262 GAS AND OIL
6281 COMMUNICATION MAINT 1,048 ,
1,020 .
907 720 907 811
117
6283 SAFETY EQUIP /SERVICES 0 0 117 0 117
175 175
6284 EQUIP MAINTENANCE 0
597 0
1
026 175
079
1 0
332 1,079 1,079
6285 BLDG MAINT&SUPPL ,
0 ,
500 0 500 200
6287 PROPERTY MAINTENANCE 0
173
12 442
14 15,000 9,016 16,467 16,320
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
99
32
100
27
100
100
150
6303 OPERATING SUPPLIES 430
1
807 62
2
429 150
1,879 65
785 150
1,879 1,879
6305 UNIFORMS
6312 COMPUTER SUPPLES ,
45 ,
0 100 74 100 100
6313 SMALL TOOLS 499 310 600 173
341 3,214
550
1 1,149
550
1
6318 SHOP SUPPLIES 642 1,038 1,550 38 ,
750 ,
750
6326 SAFETY EQUIP/SUPPLIES 612 448 750 0 0
6360 MINOR OPERATING OUTLAY 5,331 4,970
289
9 0
5
129 0
1
503 7,743 5,678
SUBTOTAL 9,465 , , ,
CAPITAL OUTLAY
0
0
0 0
6645 OPERATING EQUIPMENT 0 5,883 0 0
SUBTOTAL 0 5,883 0 0
TOTAL 179,492 168,352 187,188 132,199 191,653 189,988
City of Colleyville 2006-2007 Budget Worksession -Page 63 of 71
City of Colleyville, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department:
Merit Pool
Acct:
001-55
FY2006 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2006 YTD Department Proposed Adopted
Descri lion Bud eted Bud eted Bud et as of 6130 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
TOTAL
135.940 256,158 371,863
135,940 256,158 371,863
0 563,500 563,500 0
0 563,500 563,500 0
135,940 256,158 371,863
0 563,500 563,500 0
~aeizoos City of Colleyville 2006-2007 Budget Worksession -Page 64 of 71
Clty of Colleyvllle, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department: Acct:
Building Services 001-57
FY2006 FY2007 FY2007 CM
FY2004 FY2005 Adopted FY2006YTD Department Proposed
CONTRACTUAL SERVICES
6226 MISC CONTRACTUAL SERVICES
42,815
44,254
40,750
50,147
41,032
41,032
Q
6227 MAINTENANCE AGREEMENT 0 184 0 0 0
75 0
75
0
6262 GAS&OIL 0
0 0
2 75
300 0
60 300 300 0
6284 EQUPIMENT MAINT
6285 BLDG MAINT&SUPPL 128,304 120,114 196,173 75,336 199,201 196,173 0
0
SUBTOTAL 171,119 164,554 237,298 125,543 240,608 237,580
SUPPLIES
6301 OFFICE SUPPLIES
0
0
100
0
100
100
0
0
0
6302 POSTAGE
6303 OPERATING SUPPLIES 0
6,209 35
4,671 0
10,500 0
4,300 0
9,800 9,800 0
0
6313 SMALL TOOLS 0
209
6 369
075
5 500
11,100 0
4,300 200
10,100 200
10,100 0
SUBTOTAL , ,
TOTAL 177,328 169,629 248,398 129,843 250,708 247,680 0
lizlizoos City of Colleyville 2006-2007 Budget Worksession -Page 65 of 71
City of Colleyvflle, Texas
FY2007 General Fund Budget
Departmental Expense Summary
Department:
Infnrmntinn .RANICP.A
Acct:
001-59
FY2000 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2006 YTD Department Proposed Adopted
~scri lion Actual Actual Bud et as of 6130 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
0
29,878
41,829
33,699
47,790
77,633
6139 OVERTIME
6141 FICA EXPENSES 0
0 286
2,148 0
3,200 0
2,245 0
3,665 0
5,948
6142 GROUP HEALTH INS 0 8,409 9,096 9,540 9,096
146 18,522
279
6143 WORKER'S COMP 0 63
55 128
135 102
335 135 540
6145 UNEMP COMP
6146 RETIREMENT 0
0 3;881 5,079 3,947 5,175 8,669
6148 LONGEVITY 0
0 0
720
44 0
59,467 0
49,868 125
66,132 125
111,716
SUBTOTAL ,
CONTRACTUALSVCS
0
0
380
239
380
380
6203 INSURANCE 0 0 0 1,372 2,370 2,145
6204 TRAVEL
6206 TRAINING 0 4,826 5,700 2,934 12,100 10,500
6207 PRE-EMPLOYMENT 0 345 0 57
28 0
157 0
400
6208 ORG DEVELOPMENT 0 0
0 157
50 45 375 225
6209 DUES & SUBSCR
6225 COMPUTER SERVICES 0
0 22,505 22,728 10,734 25,728 25,168
6226 MISC CONTRACTUAL SERVICES 0 0 0 0
435 0
671 4,628
759
6238 UTILITIES 0
0 43
0 671
840 2,366 2,235 1,548
6240 CELL PHONE
6241 TELEPHONE 0 6,181 274 255 274 274
6245 EQUIPMENT RENTAL 0
0 191
248
14 0
991
47 0
10,548 500
50,700 0
50,700
6246 OFFICE EQUIP MAINT 0 ,
48
340 ,
791
78 29,013 95,490 96,727
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
0
3,088
0
195
0
882
0
1 71
6312 COMPUTER SUPPLIES 0 4,843 882 33
0 0
6313 SMALL TOOLS
6360 MINOR OPERATING OUTLAY 0
0 226
47,154 0
30,708 806
32,213 49,435 39,146
6399 MISCELLANEOUS 0
0 517
827
55 0
31,590 0
33,246 0
50,317 0
40,856
SUBTOTAL ,
CAPITAL OUTLAY
6635 COMPUTER EQUIPMENT
0
13,483
0
0
0
0
5,250
250
5
SUBTOTAL 0 13,483 0 0 ,
TOTAL 0 162,370 169,848 112,127 211,939 254,549
City of Colleyville 2006-2007 Budget Worksession -Page 66 of 71
0
0
0
0
0
7;z7~zooe
City of Colleyville, Texas
FY2007 Utility Fund Budget
Departmental Expense Summary
Department: Acct:
Utility Administration 002-11
FY2006 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2006 YTD Department Proposed Adopted
„___.~....,.., Actual Actual Budget (as of 6130) Request Budget Budget
PERSONNEL
6101 SALARIES
130,171
131,602
130,910
98,227
135,230
135,230
716
6139 OVERTIME 0
249
10 420
390
10 716
10,649 578
7,947 716
11,030 11,030
6141 FICA EXPENSES
6142 GROUP HEALTH INS ,
15,675 ,
17,443 18,254 13,654 18,254 19,166
517
6143 WORKER'S COMP 425 372
81 424
405 338
736 439
405 810
6145 UNEMP COMP
6146 RETIREMENT 623
15,955 16,464 15,465 12,268 15,452 15,452
6147 INCENTIVE PAY 0
740
3 0
830
3 0
3,920 0
3,920 0
4,575 0
4,575
6148 LONGEVITY
6152 ACCRUED LEAVE PAY , , 512 621
189 157
191
SUBTOTAL 180,358 184,192 184,404 141, , ,
CONTRACTUAL SERVICES
601
1
640
1
1,891
1,190
1,891
1,891
6203 INSURANCE ,
0 ,
0 500 0 500 0
6204 TRAVEL 0 0 700 0 700 1,200
6206 TRAINING
6207 PRE-EMPLOYMENT 146 120 120 0 120
394 120
832
3
6208 ORG DEVELOPMENT 310 276
768 394
550 348
585 650 ,
650
6209 DUES&SUBSCR 130
112
1 36 2,000 21 2,000 3,000
6225 COMPUTER SERVICES , 15 150 164 150 170
6238 UTILITIES 14
462 633 600 487 700 700
6240 CELL PHONES 13 14 100 10 100 5
6241 TELEPHONE 0 0 0 0 0
6245 EQUIPMENT RENTAL 1,171
486 888 640 566 640 640
6246 OFFICE EQUIP MAINT 0 750 0 500 500
6261 VEHICLE MAINTENANCE 0 0 450 62 450 450
6262 GAS AND OIL
6281 COMMUNICATION MAINT 445
535 521 553 359 553 589
6287 PROPERTY MAINTENANCE 0 16
926 350
748
9 0
792
3 350
9,698 350
14,097
SUBTOTAL 6,426 4, , ,
SUPPLIES
6301 OFFICE SUPPLIES
528
224
500
232
500
500
70
6302 POSTAGE
6303 OPERATING SUPPLIES 8
633 11
204 70
650 8
118 70
650 650
6308 PRINTING 44 0 100 0 100
0 100
5,000
6310 EOC OPERATING SUPPLIES 220 0 220 220
6312 COMPUTER SUPPLIES 254
467
1 0
439 1,540 357 1,540 6,540
SUBTOTAL ,
CAPITAL OUTLAY
0
0
0 0
6630 OFFICE EQUIPMENT / FURNITUI 0 0 0 0 0
SUBTOTAL 0 0 0
TOTAL 188,251 189,557 195,692 145,661 201,000 211,794
City of Colleyville 2006-2007 Budget Worksession -Page 67 of 71
0
0
0
0
0
7/17104 11:45 AM
City of Coiteyville, Texas
FY2007 Utility Fund Budget
Departmental Expense Summary
Department: Acct:
Utility Billing 002-20
FY2006 FY2007 FY2007 CM FY2007
FY2004 FY2005 Adopted FY2006 YTD Department Proposed Adopted
,,,._,,.;,,.:,,,, Actual Actual Budget (as of 6/30) Request Budget Budget
PERSONNEL
6101 SALARIES
100,708
106,834
119,153
84,734
123,181
0
172,459
757
3
6139 OVERTIME 2,734
752
7 717
961
7 5,250
697
9 386
6,320 5,25
10,019 ,
13,674
6141 FICA EXPENSES
6142 GROUP HEALTH INS ,
22,561 ,
23,941 ,
27,287 17,696 27,287 37,623
6143 WORKER'S COMP 343 305 477 380
957 490
540 718
350
1
6145 UNEMP COMP 621
437
13 105
14
029 540
15,392 10,352 13,980 ,
19,574
6146 RETIREMENT
6148 LONGEVITY ,
1,995 ,
2,305 2,355 2,355 2,535
82 2,535
690 0
251
SUBTOTAL 150,151 156,196 180,151 123,181 183,2 ,
CONTRACTUAL SERVICES
714
1
756
1
2,009
1,279
2,009
2,009
6203 INSURANCE ,
0 ,
0 460 0 460 1,260
6206 TRAINING 0 762 0 0 0 0
6207 PRE EMPLOYMENT 372 331 472 274 472 4,232
6208 ORG DEVELOPMENT 0 235 0 235 235
6209 DUES&SUBSCR 0
187
18 992
16 18,850 17,780 18,850 18,850
6221 AUDIT
6225 COMPUTER SERVICES ,
15,162 ,
9,648 8,870 0
0 8,870
75
000 8,870
000
70
6226 MISC CONTRACTUAL SERVICE
6233 BANK SERVICE CHARGES 0
20,070 0
11,981 0
21,275 7,557 ,
22,275 ,
22,275
6238 UTILITIES 3,936 3,998
30 3,846
423
2 3,816
611 3,846
2
423 4,351
2,423
6241 TELEPHONE 2,215
435 7
350 ,
185 550 ,
385 385
6246 OFFICE EQUIP MAINT 521 503 359 503 539
6281 COMMUNICATION MAINT 535
6285 BLDG MAINT&SUPPL 625
62 069
47 64,913 32,226 141,113 138,526 0
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
535
585
1,129
245
1,341
11
899
611
27
6302 POSTAGE 22,034 21,886 24,761 15,457 27,6
846 ,
846
6303 OPERATING SUPPLIES 1,657
2
827 592
692
3 786
4,590 720
1,271 5,067 4,590
6308 PRINTING
6312 COMPUTER SUPPLIES ,
3,313 ,
2,045 4,445 973 5,817 3,800
6360 MINOR OPERATING OUTLAY 0
365
30 2,773
573
31 0
35,711 0
18,665 0
40,682
37,746 0
SUBTOTAL , ,
CAPITAL OUTLAY
6630 OFFICE EQUIPMENT/FURNITURI
0
0
0
0
1,500
1,500
0
6635 COMPUTER EQUIPMENT 0 0 0 0 0
0 0
6640 COMMUNICATION EQUIPMENT 0 0 0 0
0 500
1 500 0
1
SUBTOTAL 0 0 0 , ,
TOTAL 243,141 234,838 280,775 174,071 366,577 429,462 0
City of Colleyville 2006-2007 Budget Worksession -Page 68 of 71
7/17/Q4 11:45 AM
Department: Acct:
Utility Operations 002-61
FY2004
Actual
City of Colleyville, Texas
FY2007 Utility Fund Budget
Departmental Expense Summary
FY2006 FY2007
FY2005 Adopted FY2006 YTD Department
FY2007 CM
Proposed FY2007 Adopted
PERSONNEL
6101 SALARIES
710,466
713,934
828,841
593,884
859,742
29
864,068
12
729
6135 STANDBY PAY 9,348
0
329 11,029
47
314 12,729
883
54 8,512
34,448 12,7
54,883 ,
54,883
6139 OVERTIME
6141 FICA EXPENSES ,
6
58,403 ,
58,267 ,
70,443 47,985 72,669
59 73,200
852
209
6142 GROUP HEALTH INS 129,687 159,382 199,859
537
31 138,090
151
25 199,8
364
32 ,
36,651
6143 WORKER'S COMP 46,517 39.642
642 ,
2
970 ,
081
6 ,
2,970 5,940
6145 UNEMP COMP 4,593
100
993 159
103 ,
111,811 ,
82,786 111,518 112,025
6146 RETIREMENT
6147 INCENTIVE PAY ,
5,280 ,
4,935 4,500 4,535 4,500
4 4,500
284
16
6148 LONGEVITY 12,343 13,740 15,469 15,300 16,28 ,
6152 ACCRUED LEAVE PAY 194
142
1 365
1
156 1,337,441 961 267 1,372,117 1,394,531
SUBTOTAL ,
, ,
,
CONTRACTUAL SERVICES
327
28
437
25
29,333
18,466
29,333
29,333
6203 INSURANCE ,
119 ,
686 1,500 1,069 2,300 600
6204 TRAVEL
6206 TRAINING 445 3,567 4,000 2,112 5,990 5,800
918
6207 PRE EMPLOYMENT 1,026 694
144
2 918
149
3 400
281
2 918
3,149 11,626
6208 ORG DEVELOPMENT 3,604
954
2 ,
016
3 ,
3,500 ,
2,650 4,026 3,500
6209 DUES & SUBSCR
6223 ENGINEERING SERVICES ,
71,808 ,
48,053 7,500 3,537 9,500
150 7,500
150
3
6225 COMPUTER SERVICES 6,072 19,267 6,929
00 4,280
801
21 9,
800
28 ,
48,000
6226 MISC CONTRACTUAL SVCS 28,069 22,691 28,0 , ,
600 600
6231 LEGAL ADS 803
552
53 278
507
55 600
93,212 29
44,573 93,212 104,472
6238 UTILITIES
6240 CELL PHONE ,
6,491 ,
6,104 6,500 5,334 4,689
14 4,689
3
300
6241 TELEPHONE 3,528 3,082 3,314
0 2,033
744
5 3,3
4
500 ,
4,500
6245 EQUIPMENT RENTAL
WATER
A
R
6251 T 4,433
3,165,222 3,999
4,458,162 4,50
3,554,719 ,
2,930,549 ,
3,554,719 3,706,661
.
.
.
6252 T.R.A. SEWER 958,005 805,067 1,045,026 789,184
95 1,045,026
000
11 1,073,702
11
000
6253 WATER SAMPLES 8,851 9,132
219
10 11,000
500
7 2,9
381
10 ,
9,000 ,
10,000
6261 VEHICLE MAINTENANCE 6,762
386
23 ,
32
399 ,
35,007 ,
28,694 45,352 45,352
6262 GAS AND OIL
6271 WELL & PUMP MAINT. ,
5,376 ,
1,833 20,000 3,972 20,000 10,000
000
2
6272 01ST. SYSTEM MAINT. 0 0
740 2,000
000
2 0
360
2 2,000
6,000 ,
6,000
6273 STORAGE SYSTEM MAINT. 0 3.
0 ,
000
2 ,
18 2,000 2.000
6274 METER MAINT. & TESTING
6275 SEWER LINE MAINT D
7,725 16,984 ,
20,000 4,172 20,000 20,000
.
6281 COMMUNICATION MAINT 9,778 9,310 8,651
00 6,656
960
9 8,651
000
15 9,314
15,000
6284 EQUIP. MAINTENANCE 16,661 12,610
199
3 15,0
5
000 ,
321
3 ,
5,000 5,000
6285 BLDG MAINT&SUPPL
ENANCE 5,364
2
466 ,
735
3 ,
5,200 ,
2,706 5,200 5,200
6287 PROPERTY MAINT
G FEE ,
4
005 ,
824
3 4,850 3,824 4,850 4,850
6296 WATER LICENSIN ,
482
2 ,
1
859 2,500 1,487 2,500 2,500
6299 MISC
SUBTOTAL ,
4,427,312 ,
5,566,597 4,933,408 3,914,588 4,955,779 5,156,567
City of Colleyville 2006-2007 Budget Worksession -Page 69 of 71
7 ?7~?OUG
Cily of Colleyville, Texas
FY2007 Utility Fund Budget
Departmental Expense Summary
Department:
Utility Operations
Acct:
002-61
FY2006 FY2007 FY2007 CM
FY2004 FY2005 Adopted FY2006 YTD Department Proposed FY2007 Adopted
Description Actual Actual Budget (as of 6130) Request Budget Budget
SUPPLIES
6301 OFFICE SUPPLIES
1,329
623
5,000
1,333
5,000
2,500
6302 POSTAGE 1,852 1,529 3,825 1,303 3,825 3,825
500
6303 OPERATING SUPPLIES 377
69 652
672
2 500
000
7 14
012
2 500
7,000 5,000
6304 CHEMICALS
6305 UNIFORMS 3,3
8,774 ,
10,923 ,
10,870 ,
3,935 10,870 10,855
6308 PRINTING 1,260 2,772 2,500 367
1
119 3,050
14
263 2.800
510
8
6312 COMPUTER SUPPLIES 560
594
6 134
468
7 8,510
000
6 ,
5
393 ,
6,000 ,
8,000
6313 SMALL TOOLS
6324 REPAIR & MAINTENANCE ,
74,565 ,
33,516 ,
100,000 ,
46,174 100,000 80,000
6326 SAFETY EQUIP/SUPPLIES 9,563 8,388 8,300 8,411 8,300 10,000
6360 MINOR OPERATING OUTLAY 0
108
243 10,190
78
868 0
505
152 3,507
73,568 0
158,808 0
131,990
SUBTOTAL , , ,
CAPITAL OUTLAY
6625 IMPR. OTHER THAN BLDG
0
0
40,000
0
40,000
40,000
6635 COMPUTER EQUIPMENT 0 0 0 0 7,865 0
6645 OPERATING EQUIPMENT 0 0 0 0 0 0
6649 WATER PIPE & SUPPLIES 0 0 5,500 0 5,500 5,500
6650 MOTOR VEHICLES 0 0 0 0 0 105.000
6652 SEWER PIPE & SUPPLIES 0 0 2,000 0 2,000 2,000
6654 WATER MET. & FIRE PLUGS 0 0 70,000 4,823 75,000 75,000
SUBTOTAL 0 0 117,500 4,823 130,365 227,500
TOTAL 5,677,748 6,801,830 6,540,854 4,954,246 6,617,069 6,910,588
City of Colleyville 2006-2007 Budget Worksession -Page 70 of 71
0
0
0
7 ? 7: ?006
City of Colleyville, Texas
FY2007 Drainage Fund Budget
Departmental Expense Summary
Department: Acct:
Drainage 017-52
FYZ007 FY2007 CM FY2007
FY2004 FY2005 FY2006 Adopted FY2006 YTD Department Proposed Adopted
Descri lion Actual Actual Bud et as of 6130 Re uest Bud et Bud et
PERSONNEL
6101 SALARIES
150,455
138,680
204,983
149,852
210,500
210,500
6139 OVERTIME 5,483 3,368 11,040
844 7,537
11
976 8,853
17
116 8,853
17,116
6141 FICA EXPENSES 11,613
587
33 10,618
125
36 16,
54
326 ,
30,767 ,
57,042 57,042
6142 GROUP HEALTH INS ,
13 ,
351
6 ,
270
9 7,393 10,627 10,627
6143 WORKER'S COMP 7,4 ,
119 ,
540 1
627 1,620 1,620
6145 UNEMPCOMP 827
278
20 907
18 26,736 ,
20,142 26,194 26,194
6146 RETIREMENT , ,
0 480 0 480 480
6147 INCENTIVE PAY 0
435
3 795
3 4,163 4,045 4,383 4,383
6148 LONGEVITY
SUBTOTAL ,
233,043 ,
217,963 328,382 233,338 336,815 336,815
CONTRACTUAL SERVICES
6203 INSURANCE
1,883
1,625
1,874
1,180
1,874
1,874
0
6204 TRAVEL 0
667 0
1
276 2,600
1,540 41
256 0
2,100 4,700
6206 TRAINING
6207 PRE-EMPLOYMENT 148 ,
120 120 96
64 120
10
8
8 120
10
8
8
6208 ORG DEVELOPMENT 494 441 630 5
D ,
9
0 9
0
,
6209 DUES 8 SUBSCRIPTIONS 105 0
0 130
1
500 1
500 1,500 1,500
6221 AUDIT
6223 ENGINEERING SERVICES 0
0 24,565 ,
44,039 ,
7,665 44,039 44,039
6225 COMPUTER SERVICES 284 7,795 0 21
D 0
000
5 2,000
000
5
6226 CONTRACTURAL SERVICES 1,605 950 5,000 ,
750 ,
750
6229 COMMUNITY RELATIONS 0 477 750
202 130
2
099 2
20 2 20
6240 CELL PHONES 1,529 1,251 2, ,
0 ,
4 4
6241 TELEPHONE
6245 EQUIPMENT RENTAL 0
1,148 0
7,590 16
17,078 2,537 7,278 7,278
6254 DRAIN. DITCH CLEANING 24,083 19.124 22,000 0
72 22,000
2
500 22,000
500
2
6261 VEHICLE MAINTENANCE 531 4,945 2,400
097 2,3
821
8 ,
000
12 ,
12,000
6262 GAS AND OIL 4,423 6,711 8,
458
1 .
080
1 ,
1,570 1.570
6281 COMMUNICATION MAINT 1,851 1,542
1 ,
000
3 ,
555
5 8,500 8,500
6284 EQUIP. MAINTENANCE 3,900 6,33 , ,
0 0
6285 BLDG MAINTBSUPPL 155
500 53
580
2 0
870
2 32
2,502 2,670 2.670
6296 WATER LICENSING FEE 2, , ,
0
0 0
6299 MISCELLANEOUS 0
304
45 0
375
87 0
117,104 36,451 125,105 129,705
SUBTOTAL , ,
SUPPLIES
6301 OFFICE SUPPLIES
174
205
200
44
200
200
45
6302 POSTAGE 56 0 45 29
14 45
50 50
6303 OPERATING SUPPLIES 0
054
1 0
023
1 50
4,348 644 3,037 3,037
6305 UNIFORMS , , 0 0 0 0
6308 PRINTING
6312 COMPUTER SUPPLIES 33
1,069 33
1,423 1,710 134 1,889 1,889
250
6313 SMALL TOOLS
PLIES 40
872
30 0
991
29 250
35,000 95
32,323 250
35,000 35,000
6325 DRAINAGE SUP
6326 SAFETYEQUIPISUPPLIES ,
539 ,
295 1,170 447 1,170 1,170
6327 MOSQUITO CONTROL 0 0
970
2 500
273
43 377
107
34 500
42,141 500
42,141
SUBTOTAL 33,836 3
, , ,
CAPITAL OUTLAY
0
0
0 0
6615 LAND IMPROVEMENTS 0 0 0 0
6650 MOTOR VEHICLES 0 0 0 0 0 0
SUBTOTAL 0 0 0 0
TOTAL 312,234 338,307 488,759 303,896 504,061 508,661
City of Colleyville 2006-2007 Budget Worksession -Page 71 of 71
in ~~oa