ORD 811 09/13/2007 ORDINANCE NO. 811
AN ORDINANCE BY THE CITY COUNCIL OF THE CITY OF
CIBOLO, GUADALUPE COUNTY, TEXAS, ADOPTING THE
BUDGET FOR FISCAL YEAR 2007-08, BEGINNING OCTOBER 1,
2007,AND ENDING SEPTEMBER 30,2008.
WHEREAS,the City Council of the Municipality of Cibolo,Texas,has complied with all
laws of the State of Texas regarding calculation of effective and rollback tax rates; and
WHEREAS, the City Council of the municipality of Cibolo, Texas, has met in open
meetings, conducted public hearings and taken action to set the date of the adoption of
the 2007-08 City Budget as required by the "Truth in Taxation"legislation of the State of
Texas; and
WHEREAS,it is necessary at this time to adopt the annual budget;
BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CIBOLO,
TEXAS...
Section 1
That the City Budget herein presented and attached to this Ordinance is hereby approved
and adopted for the Fiscal Year 2007-08.
Section 2
That the City Manager and Finance Director are authorized to invest any funds not
needed for current use in United Treasury Bills, the State of Texas, TexPool system,
savings accounts in the City depository, or other such instrument or program allowed by
the City's investment policy adopted by the City Council. Interest accrued from such
investment(s) may be deposited in the General Fund for a specific enterprise fund as
required by accepted accounting procedures.
Section 3
That the City Manager be and is hereby authorized to contract for expenditure without
further approval of the City Council for all budgeted items not exceeding the limits set by
the City Council herein.
Section 4
This ordinance shall take effect and shall be in full force at 12:00 a.m. on October 1,
2007.
1
PASSED AND APPROVED AND ADOPTED THIS 13TH DAY OF SEPTEMBER,
2007.
APPROVED:
CJ-6)-tYYkOlf\il
J 4fer Hartman
Mayor
ATTEST:
0 2„ ,.....,,
Peggy Cimics
City Secretary
2
0 F4 C1 .
0
A s <
r 0
t )3/4.
*
YOUR
\
X ik
2007-2008
City of Cibolo Budget
Considered by
the Cibolo City Council on
September 13, 2007
This budget will raise more total property taxes
than last year's budget by $735,307, a 39.2%
increase, and of that amount $584;097 is tax
revenue to be raised from new property added
to the tax roll this year.
afi"O f
MANAGER'S BUDGET MESSAGE
ro
FY 2008 BUDGET
Atie1* ) *
September 13,2007
- , „ „„ , With regard to its rate of annual population growth, Cibolo is still one of
rC x A s the State's fastest growing cities. Since 2000, the City hasgrown from
witenimaisimimMIMINffini approximately 3,200 persons to an estimated 13,100 persons by the end
Cibolo of FY 2007. This represents a compound annual growth rate of i9.3
Administration percent since 2000. Accordingly, the City is starting to experience
significant increases in demands for service and the responsibility to
Todd Parton maintain and construct a constantly expanding system of public
City Manager infrastructure-i.e.water,wastewater, drainage,streets, and parks.
citvma naaer@cibolotx.net
Due to the unprecedented growth of the community, the FY 2008
budget is a hybrid budget that has been prepared utilizing program
budgeting and historical budgeting techniques. It is anticipated that
single family residential building activity will slow down during the next
fiscal years. Accordingly, the budget anticipates a 20% reduction in
single family building permit activity for FY 2008. An estimated 700 new
homes are forecasted for next year, down from :the 900 forecasted for FY
2007. This budget anticipates the resources necessary to achieve
specific program objectives related directly to the level of growth,and
looks to historical trends to estimate specific revenue projections for items
such as development permits, development processing fees and
property tax revenue.
One of the primary objectives is to create a balanced budget for FY
2007. This budget is balanced in that revenues match expenditures for
the year. The FY 2008 budget includes $242,660 in encumbered funds for
general fund projects initiated in FY 2007 that will be completed in FY
2008. Unexpended funds budgeted from FY 2007 will remain allocated in
• the same budgeted amounts and are reflected in FY 2008.
The FY 2008 Budget outlines revenues and expenditures of$12,632,396 for
all funds. This includes bond dollars allocated for capital projects like
drainage improvements, utility lines, roadway reconstruction, and other
similar types of projects. This budget provides for an increase of
$2,063,944 in expenditures above the $10,568,452 budgeted for FY 2007
(as amended on the date of this Budget Message). FY 2008 expenditures
City of Cibolo
P.O. Box 826 represent an increase of approximately 19.5 percent from FY 2007. The
200 South Main expenditure of bond funds issued in FY 2006 and FY 2007 for certain
Cibolo, Texas 78108 capital projects represent a large portion of this increased spending.
main 210.658.9900
Of the budgeted expenditures for FY 2008, a total of $6,642,323. or 53
fax 210.658.1687 percent of the total budgeted allocations are proposed for maintenance
httD://www.cibolotx.net and operations expenses for the General Fund. This compares to 43
percent of the total budgeted allocations for the General Fund for FY
2007.
Expand
Permits and fees continue to generate the most substantial amount of
Your revenues for FY 2008. As mentioned, single family development activity is
V 9 S ® n projected to slow by 20%for FY 2008. However, there is also projected to
be an increase in commercial building activity and the net result is a
Cibolo 13-Sep-07
Administration
slight increase in Construction Permits. The projected increase for FY 2008
is projected to increase by 5.3% percent ($2,583,550 in FY 2007 to
$2,720,270 in FY 2008) from those budgeted for FY 2007. For FY 2008,
construction permits are projected to drop to 42.0% of the General Fund
revenue as opposed to comprising 55.2% of the General Fund revenue
for FY 2007.
Property taxes generate approximately 29.2 percent of the general fund
revenues and are projected to bring in $1,892,354, an increase of
$532,354 from funds budgeted for FY 2007.
General fund revenue sources for FY 2007 versus FY 2008 are as follows:
FY 2007 FY 2008
Taxes 31.8% 39.6%
Construction Permits 55.2% 42.0%
Charges for Services 0.3% 0.1%
Fines 5.5% 9.6%
Other 7.2% 8.7%
Property tax rates for FY 2008 are proposed at$0.2282 cents for M&O and
at $0.0904 cents for l&S for a total property tax rate of $0.3186. The
proposed tax rate is the same as the tax rates set for FY 2007.
The l&S tax rate has been set to meet the City's debt service obligations
for FY 2008. There are 4 outstanding issues for a total outstanding general
fund bonded debt of $10,365,000 (principal only). Debt service for these
4 outstanding bonds is $15,692,558, which is inclusive of outstanding
principal and interest through the terms of the bonds. Debt service
obligations for the general fund for FY 2008 are $859,410. The existing
bonds and their respective outstanding principal are outlined below:
2001 Certificates of Obligation - $1,115,000 issue for drainage
improvements
2002 Tax Note - $390,000issue for water tower and utility line
construction
2003 Certificates of Obligation - $885,000 issue for City Hall
construction
2007 General Obligation Bonds - $7,975,000 for drainage
improvements, reconstruction of Main Street, and new
municipal facilities
Cibolo also has multiple Revenue Bonds issued in 2006 and 2007. The
2006 Revenue Bond has an outstanding principal amount of $2,905,000
and the 2007 Revenue Bond has an outstanding principal amount of
$3,025,000. These revenue bonds are paid from the Utility Fund and
impact fees collected and does not impact the l&S tax rate. These
bonds were issued to fund water and wastewater system expansions as
well as the system-wide replacement of the City's water meters. Debt
service obligations of approximately $403,845 are required for this
revenue bond.
City of Cibolo -2-
Cibolo 13-Sep-07
Administration
FY 2008 expenditures and revenues for the City's 3 types of funds are as
follows:
Revenues Expenditures
General Fund $6,642,323 $6,642,323
Utility Fund $5,128,163 $5,128,163
Debt Service Fund $ 888,601 $ 861,910
Major changes in expenditures by department in the FY 2008 budget are
as follows:
City Council 3.5% Increase
Administration 5.9% Increase
Police Department 22.9% Increase
Municipal Court 27.5%Increase
Building Inspections 10.7% Decrease
Public Works 100.4%Increase
Animal Control 18.5%Increase
Parks 1.3% Decrease
Community Development 13.3%Increase
Utilities 29.1% Increase
Primary reasons for increased expenditures by department are:
Administration-addition of a Fire Chief (the first step in creating a
City Fire Department), building renovations to City Hall,
conversion of the City's accounting software system,
inclusion of the Fire Marshal and related expenditures, and
the addition of an Administrative Assistant to the City
Secretary;
Police Department- addition of 2 patrol officers, 2 traffic officers,
1 investigator, the restructuring of the Department, and
the purchase of vehicles and related equipment for the
new positions (2 vehicles and 2 motorcycles);
Municipal Court - addition of a Deputy Court Clerk and related
furniture and equipment;
Public Works - addition of a Public Works Director, 3 new full-time
crew positions, a street sweeper position, increase of
Contract Street Maintenance, and the purchase of new
major equipment (10-yard dump truck, street sweeper,
front-end loader, pickup truck, and tractor with boom
mower);
Animal Control - purchase of animal control software, upgrades
to the existing animal control facility, and increases in
operational expenditures;
City of Cibolo -3-
Cibolo 13-Sep-07
Administration
Community Development - completion of on-going projects
initiated in FY 2007; and
Utilities-addition of 3 new full-time utility crew members, funds for
expansion to the City's water and wastewater systems,
increased water supply and water treatment costs,
increasedwastewater treatment costs, increased solid
waste services costs, and the purchase of major
•
equipment (Gooseneck trailer, 5-yard dump truck, and a
pickup truck).
The FY 2008 budget includes several capital projects in both the General
Fund and the Utility Fund. General Fund expenditures include $2,494,429
for capital projects and the Utility Fund expenditures include $1,342,500
for capital projects.
General Fund capital projects in varying stages are:
Dobie Creek Drainage $246,592
Town Creek East Drainage $1,087,232
Borgfeld Road Pedestrian Bridge $9,676
Main Street Reconstruction $3,100,000
Town Creek West Drainage $1,200,000
Public Works Facility $1,500,000
Utility Fund capital projects in varying stages are:
Water Line Projects $193,000
Wiedner Road Water Line- 16" $1,250,920
FM 1103 Water Feeder Line $1,375,000
FM 1103 Elevated Water Tank $2,029,500
Emergency Water Tower Generator $85,000
Wiedner Road Connector Line $200,000
FM 1103 Wastewater Line $200,000
Utility revenues for this budget do not include an increase in the utility-
rates
tilityrates for water,wastewater,solid waste or recycling services. A utility rate
study is underway to evaluate the City's rate structure and future utility
needs.
For the first time since 2000, Cibolo has started to see a decline in single-
family development activity. This is a reflection of the residential
construction trend seen throughout the country. However, even a 20%
reduction in the single-family development activity projected for this
budget still has a significant impact on the community. An estimated 700
new single-family permits are anticipated for FY 2008 with a gradual
decline anticipated over the next several years. This underscores the
need for the City to strive for ways to diversify its tax base and encourage
economic development to help cover the City's increasing operational
and capital needs.
City of Cibolo -4-
Cibolo 13-Sep-07
Administration
As Cibolo continues to grow and mature, there will be an increasing
need and demand for more quality of life improvements like parks and
recreational amenities. The City must strive to strike a balance between
expanding to meet the basic service needs of the citizenry while also
meeting increasing demands for these quality of life improvements.
Cibolo has implemented a formal 5-Year Capital Improvements Program
that identifies and prioritizes the competing needs for the community.
Through planning efforts such as these, Cibolo will be well on its way to
effectively and efficiently meeting the diverse demands of such a
dynamic community.
Respectfully submitted,
Todd Parton
City Manager
•
City of Cibolo -5-
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
PROPERTY TAX
01-31100 PROPERTY TAX - CURRENT 1,344,000 1,870,354 526,354 39.16
01-31120 DELINQUIENT TAXES 10,000 13,000 3,000 30.00
01-31130 PENALTY & INTEREST 6,000 9,000 3,000 50.00
TOTAL PROPERTY TAX 1,360,000 1,892,354 532,354 39.14
SALES TAX
01-31200 SALES TAX 320,000 360,000 40,000 12.50
01-31220 MIXED BEVERAGE TAX 1,500 1,500 0 0.00
TOTAL SALES TAX 321,500 361,500 40,000 12.44
STREETS
01-31300 STREET USE 240,000 0 ( 240,000) 100.00-
01-31310 FRANCHISE FEE - ELECTRIC 0 182,000 182,000 0 00
01-31315 FRANCHISE FEE - PHONE 0 24,200 24,200 0.00
01-31320 FRANCHISE FEE - CABLE 0 81,900 81,900 0.00
01-31325 FRANCHISE FEE - GAS 0 9,800 9,800 0.00
01-31330 FRANCHISE FEE - GVSUD 0 10,900 10,900 0.00
TOTAL STREETS 240,000 308,800 68,800 28.67
PERMITS
01-32100 PLUMBING PERMITS 75,000 139,300 64,300 85.73
01-32150 ELECTRICAL PERMITS 80,000 161,000 81,000 101.25
01-32200 BUILDING PERMITS 127,500 175,000 47,500 37.25
01-32250 BUILDING PERMITS - NEW HOME 1,188,000 1,183,000 ( 5,000) 0.42-
01-32260 TREE AFFIDAVIT 250 170 ( 80) 32.00-
01-32270 SITE DEVELOPMENT FEES 100,000 24,000 ( 76,000) 76.00-
01-32300 CONTRACTOR PERMITS 7,500 12,000 4,500 60.00
01-32350 REINSPECTION FEES 220,000 270,000 50,000 22.73
01-32400 SUBDIVISION PLAT FEES 94,000 50,000 ( 44,000) 46.81-
01-32410 PRELIMINARY PLAT 0 0 0 0.00
01-32420 FINAL PLAT 0 0 0 0.00
01-32425 PLAT RECORDING FEES 0 2,800 2,800 0.00
01-32430 ZONING VARIANCE 0 0 0 0.00
01-32440 LAND STUDY 0 0 0 0.00
01-32500 HEATING & A/C PERMITS 70,000 100,000 30,000 42.86
01-32600 PLAN CHECKS 600,000 591,500 ( 8,500) 1.42-
01-32630 ZONING FEES 15,000 10,000 ( 5,000) 33.33-
01-32650 VARIANCE FEES 6,300 1,500 ( 4,800) 76.19-
01-32700 IMPACT FEES - STREETS 0 0 0 0.00
01-32800 IMPACT FEES - DRAINAGE 0 0 0 0.00
TOTAL PERMITS 2,583,550 2,720,270 136,720 5.29
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 2
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
ANIMAL CONTROL
01-33100 ANIMAL REGISTRATION 10,000 2,000 ( 8,000) 80.00-
01-33115 ANIMAL CONTROL DONATIONS 0 0 0 0.00
01-33200 IMPOUND FEES 7,600 6,500 ( 1,100) 14.47-
TOTAL ANIMAL CONTROL 17,600 8,500 ( 9,100) 51.70-
COURT FINES
01-34100 FINES 337,400 577,300 239,900 71.10
01-34105 WARRANT FEES 22,000 40,000 18,000 81.82
01-34110 TIME PAY FEES 2,000 1,000 ( 1,000) 50.00-
01-34310 CASH OVER/SHORT 0 0 0 0.00
01-34500 ADMIN FEES 0 0 0 0 00
01-34510 COURT SECURITY FEES 12,600 0 ( 12,600) 100 00-
01-34520 COURT TECHNOLOGY FEES 8,800 0 ( 8,800) 100.00-
01-34540 CREDIT CARD FEES 1,500 2,200 700 46.67
01-34550 OMNI FEES 0 0 0 0.00
01-34600 REPORTS & OTHER 1,000 1,600 600 60.00
TOTAL COURT FINES 385,300 622,100 236,800 61.46
POLICE REVENUE
01-34710 TASK OFFICER GRANT 0 0 0 0.00
01-34720 POLICE DONATIONS 0 0 0 0.00
01-34730 LEOSE FUNDS 1,600 0 ( 1,600) 100.00-
01-34750 PD FORFEITURE ACCOUNT 300 0 ( 300) 100.00-
01-34900 ALARM FEES 7,000 9,900 2,900 41.43
TOTAL POLICE REVENUE 8,900 9,900 1,000 11.24
OTHER REVENUE
01-35100 INTEREST 90,000 132,000 42,000 46.67
01-35105 2006 TAX NOTE INTEREST 0 0 0 0.00
01-35230 TRANSFER IN FUND BALANCE 0 0 0 0.00
01-35235 ENCUMBERED FUNDS 26,200 242,660 216,460 826.18
CODIFICATION 0 0.00 3,700.00
PARKS CRITERIA MANUALS 0 0.00 6,960.00
MAPPING FOR IMPACT FEE 0 0.00 10,000.00
EDC CONTRACT WORK 0 0.00 12,000.00
LEGAL SERVICES IMPACT FEES 0 0.00 30,000.00
THISTLE CREEK OVERLAY 0 0.00 180,000.00
01-35240 TRF IN - UTILITY/ADMIN FEE 55,000 59,510 4,510 8.20
01-35245 TRF IN - PARK FEES 92,000 10,000 ( 82,000) 89.13-
01-35250 2006 TAX NOTE PROCEEDS 0 0 0 0.00
01-35255 NOTES PROCEEDS 0 0 0 0.00
01-35260 TRF IN - CAP REPLACEMENT 0 101,000 101,000 0.00
01-35265 TRF IN STREET/DRAIN MAINT TAX 0 70,000 70,000 0.00
01-35270 TRF IN - SECURITY FEE 17,231 8,443 ( 8,788) 51.00-
01-35275 TRF IN - TECHNOLOGY FEE 1,500 5,632 4,132 275.47
01-35280 TRF IN - POLICE FUNDS 9,229 17,500 8,271 89.62
01-35300 MISCELLANEOUS 20,000 20,000 0 0.00
01-35310 CCMA PASS THRU FEES 16,500 11,000 ( 5,500) 33.33-
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 3
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-35315 NSF FEES 250 250 0 0.00
01-35320 CHILD SUPPORT FEES 72 76 4 5.56
01-35330 WRECKER REIMB FEES 2,000 2,000 0 0.00
01-35335 CINGULAR 9,000 8,388 ( 612) 6.80-
01-35340 A/C - TRAP RENTAL 50 50 0 0.00
01-35400 GARBAGE TRANSFERS 153,750 175,000 21,250 13.82
01-36100 PARK/ PAVILION RENTALS 4,000 3,700 ( 300) 7.50-
01-36120 PARK DONATIONS/ GRANTS 0 0 0 0.00
01-36121 TWDB GRANT REIMBURSEMENT 21,156 0 ( 21,156) 100.00-
01-36124 GRANT - BULLET PROOF VEST 0 0 0 0.00
01-36125 CDJ GRANT SF-07-A10-17645-02 27,765 27,890 125 0.45
01-36130 TRANSFER - DEDICATION FEES 0 0 0 0.00
01-36210 BUFFALO CROSSING PARK 5,500 0 ( 5,500) 100.00-
01-36250 CIBOLOFEST 0 0 0 0.00
01-36255 YOUTH COUNCIL 1,000 0 ( 1,000) 100.00-
01-36300 PARK - BALLFIELD RENTAL 4,000 3,500 ( 500) 12.50-
01-36400 COKE MACHINE REVENUE 400 300 ( 100) 25.00-
01-36410 MISC OVER/SHORT 0 0 0 0.00
01-36600 CONTRIBUTED CAPITAL 0 0 0 0.00
TOTAL OTHER REVENUE 556,603 898,899 342,296 61.50
*** TOTAL REVENUE *** 5,473,453 6,822,323 1,348,870 24.64
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 4
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
COUNCIL
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-41-2630 CONFERENCE TRAVEL 1,315 2,500 1,185 90.11
01-41-2820 TELEPHONE 630 1,140 510 80.95
01-41-3090 CLOTHING 1,000 0 ( 1,000) 100.00-
01-41-3215 PRINTING 0 800 800 0.00
01-41-3610 MEETING EXPENSE 1,500 1,500 0 0.00
01-41-3620 YOUTH COUNCIL 1,626 0 ( 1,626) 100.00-
01-41-3760 AWARDS 250 600 350 140.00
TOTAL COUNCIL 6,321 6,540 219 3.46
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 5 X
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
ADMINISTRATION
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-42-1010 SALARIES - ADMIN 264,935 314,444 49,509 18.69
01-42-1011 LONGEVITY PAY 720 1,800 1,080 150.00
01-42-1012 CAR ALLOWANCE 4,500 4,500 0 0.00
01-42-1015 OVERTIME 0 0 0 0.00
01-42-1016 PHONE ALLOWANCE 600 0 ( 600) 100.00-
01-42-1020 UNEMPLOYMENT TAX 1,620 1,620 0 0.00
01-42-1030 SOCIAL SECURITY / MEDICARE 20,323 24,193 3,870 19.04
01-42-1040 TMRS 23,049 24,857 1,808 7.84
01-42-1060 HEALTH - LIFE INSURANCE 19,897 22,771 2,874 14.44
01-42-1070 WORKER'S COMP 852 1,018 166 19.48
01-42-2200 DATA PROCESSING 0 500 500 0.00
01-42-2610 CONTRACT SERVICES 22,000 25,688 3,688 16.76
01-42-2620 PUBLICATIONS 1,500 1,500 0 0.00
01-42-2625 ADVERTISING/LEGAL NOTICES 7,000 7,000 0 0.00
01-42-2630 TRAVEL - TRAINING 7,000 13,000 6,000 85.71
01-42-2635 DUES AND FEES 0 2,500 2,500 0.00
01-42-2650 GENERAL LIABILITY INSURANCE 26,000 26,300 300 1.15
01-42-2660 OTHER INSURANCE 300 0 ( 300) 100.00-
01-42-2670 GCAD/GCTAC 24,264 24,264 0 0.00
01-42-2680 LEGAL SERVICES 50,000 65,000 15,000 30.00
01-42-2710 PROFESSIONAL SERVICES 64,542 34,808 ( 29,734) 46.07-
01-42-2712 DESIGN STANDARDS 0 0 0 0.00
01-42-2714 ECONOMIC DEVELOPMENT 0 0 0 0.00
01-42-2720 AUDIT SERVICES 17,000 10,000 ( 7,000) 41.18-
01-42-2810 UTILITIES 27,000 27,000 0 0.00
01-42-2815 CPS - STREET LIGHT UTILITIES 1,000 1,000 0 0.00
01-42-2820 TELEPHONE 15,040 15,040 0 0.00
01-42-2850 NEWSLETTER 3,000 12,000 9,000 300.00
01-42-3210 OFFICE SUPPLIES 9,939 8,939 ( 1,000) 10.06-
01-42-3220 JANITORAL SUPPLIES 500 1,000 500 100.00
01-42-3225 OFFICE MACHINERY AND EQUIPMENT 0 3,600 3,600 0.00
01-42-3230 OTHER SUPPLIES 3,800 6,320 2,520 66.32
01-42-3240 POSTAGE 2,800 2,800 0 0.00
01-42-3410 BUILDING MAINTENANCE 3,800 6,300 2,500 65.79
01-42-3430 OFFICE EQUIPMENT REPAIR 200 200 0 0.00
01-42-3640 ELECTION 12,000 12,000 0 0.00
01-42-4900 NON CAPITAL OUTLAY <$9,999 0 14,323 14,323 0.00
FURNITURE COUNCIL CHAMBERS 0 0.00 1,200.00
PHONE SYSTEM UPGRADE 0 0.00 4,785.00
WIRELESS MICROPHONES/COUNCIL 0 0.00 8,338.00
01-42-4910 CAPITAL OUTLAY 16,700 65,406 48,706 291.65
BUILDING RENOVATIONS 0 0.00 31,406.00
FINANCIAL SOFTWARE UPGRADE 0 0 00 34,000.00
01-42-4920 CAPITAL REPLACEMENT TRANS 0 0 0 0.00
01-42-4925 TRANSFER TO 2007 GO'S 330,500 0 ( 330,500) 100.00-
01-42-5080 CAR ALLOWANCE 0 0 0 0.00
01-42-5720 FALL/SPRING CLEANUP BEXAR WAST 15,513 20,000 4,487 28.92
01-42-5730 LIBRARY DONATIONS 20,000 20,000 0 0.00
01-42-5740 NORTHEAST PARTNERSHIP 1,000 0 ( 1,000) 100.00-
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 6
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
ADMINISTRATION
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-42-5750 RANDOLPH METROCOM 2,000 0 ( 2,000) 100.00-
01-42-5981 TRANSFER TO FUND BALANCE 0 128,710 128,710 0 00
01-42-6900 PRIOR PERIOD ADJUSTMENT 0 0 0 0.00
01-42-6955 BUDGET-FIRE MARSHAL 0 82,575 82,575 0.00
01-42-6956 BUDGET - FIRE DEPARTMENT/CHIEF 0 48,378 48,378 0.00
01-42-6960 IMPACT DRAINAGE TRNSFER 0 0 0 0.00
01-42-6970 IMPACT STREET TRNSFR 0 0 0 0.00
TOTAL ADMINISTRATION 1,020,894 1,081,354 60,460 5.92
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 7
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
POLICE DEPARTMENT
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-43-1010 SALARIES -PD 739,613 961,429 221,816 29.99
01-43-1011 LONGEVITY 8,670 9,270 600 6.92
01-43-1013 CERTIFICATE PAY 16,900 15,600 ( 1,300) 7.69-
01-43-1015 OVERTIME 9,510 12,187 2,677 28.15
01-43-1016 PHONE ALLOWANCE 2,880 5,040 2,160 75.00
01-43-1020 UNEMPLOYMENT TAX 5,940 7,290 1,350 22.73
01-43-1030 SOCIAL SECURITY - MEDICARE 59,079 76,384 17,305 29.29
01-43-1040 TMRS 65,678 78,481 12,803 19.49
01-43-1060 HEALTH - LIFE INSURANCE 76,796 91,218 14,422 18.78
01-43-1070 WORKERS COMPENSATION 25,290 33,519 8,229 32.54
01-43-2095 MEDICAL EXAMS 276 800 524 189.86
01-43-2610 CONTRACT SERVICES 7,220 7,220 0 0.00
01-43-2620 PUBLICATIONS - DUES - FEES 1,500 400 ( 1,100) 73.33-
01-43-2625 ADVERTISING 0 500 500 0.00
01-43-2630 TRAVEL AND TRAINING 2,500 3,500 1,000 40.00
01-43-2635 DUES AND FEES 0 600 600 0.00
01-43-2780 MEDICAL & LAB 724 800 76 10.50
01-43-2810 UTILITIES 5,500 5,500 0 0.00
01-43-2820 TELEPHONE 2,360 2,360 0 0.00
01-43-3090 UNIFORM REPLACEMENT 9,800 12,300 2,500 25.51
01-43-3210 OFFICE SUPPLIES 5,000 6,000 1,000 20.00
01-43-3240 POSTAGE 1,000 1,100 100 10.00
01-43-3250 OFFICER'S EQUIPMENT - SUPPLIES 11,729 8,000 ( 3,729) 31.79-
01-43-3260 CRIME PREVENTION SUPPLIES 1,000 1,000 0 0.00
01-43-3410 BUILDING MAINTENANCE 1,500 1,500 0 0.00
01-43-3430 OFFICE EQUIPMENT MAINTENANCE 1,500 2,500 1,000 66 67
01-43-3450 VEHICLE OPERATION EXPENSE 15,200 15,200 0 0.00
01-43-3455 VEHICLE FUEL 50,000 55,000 5,000 10.00
01-43-3470 VEHICLE REPAIRS 12,000 12,000 0 0.00
01-43-4910 CAPITAL OUTLAY 104,000 140,000 36,000 34.62
POLICE CRUSIER REPLACEMENT 0 0.00 26,000.00
POLICE CRUSIER REPLACEMENT 0 0.00 26,000.00
POLICE CRUISER NEW 0 0.00 26,000.00
POLICE CRUSIER NEW 0 0.00 26,000.00
POLICE MOTORCYLE 0 0.00 18,000.00
POLICE MOTORCYCLE 0 0.00 18,000.00
01-43-4930 COMMUNICATION EQUIPMENT 2,500 3,000 500 20.00
01-43-5635 LEOSE TRAINING EXPENSE 1,500 2,500 1,000 66 67
01-43-5742 SCHERTZ EMS CONTRACT 103,000 138,000 35,000 33.98
01-43-5743 PUBLIC SAFETY DISPATCH 106,801 106,801 0 0.00
01-43-5745 CIBOLO VOL FIRE DEPARTMENT 215,500 233,000 17,500 8.12
01-43-5770 JAIL COST 15,000 15,000 0 0.00
01-43-5790 ASSET FORFEIT EXPENSES 500 15,000 14,500 2,900.00
01-43-5800 GRANT- SF-SCJP 9/1-/06-2/28/07 27,765 27,890 125 0.45
TOTAL POLICE DEPARTMENT 1,715,731 2,107,889 392,158 22.86
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 8
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
COURT
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-44-1010 SALARIES 82,929 112,744 29,815 35.95
01-44-1011 LONGEVITY 480 1,080 600 125.00
01-44-1013 CERTIFICATE PAY 0 1,040 1,040 0.00
01-44-1015 OVERTIME 200 0 ( 200) 100.00-
01-44-1016 PHONE ALLOWANCE 240 480 240 100.00
01-44-1020 UNEMPLOYMENT 810 1,080 270 33.33
01-44-1030 SOCIAL SECURITY - MEDICARE 5,912 8,787 2,875 48.63
01-44-1040 TMRS 6,681 9,028 2,347 35.13
01-44-1060 HEALTH - LIFE INSURANCE 11,520 14,155 2,635 22.87
01-44-1070 WORKERS COMP 1,148 1,675 527 45.91
01-44-2420 JUDGE - PROSECUTOR 23,900 33,000 9,100 38.08
01-44-2425 JURY FEES 0 0 0 0.00
01-44-2610 CONTRACT SERVICES 2,720 6,078 3,358 123.46
01-44-2630 TRAVEL - TRAINING 1,800 1,800 0 0.00
01-44-2640 MSB - OMNI 0 0 0 0.00
01-44-3090 UNIFORMS 400 500 100 25.00
01-44-3210 OFFICE SUPPLIES 2,500 2,500 0 0.00
01-44-3215 PRINTING 0 4,000 4,000 0.00
01-44-3225 OFFI CE MACHINERY & EQUIPMENT 0 6,480 6,480 0.00
01-44-3230 OTHER SUPPLIES 4,000 0 ( 4,000) 100 00-
01-44-3240 POSTAGE 1,500 2,500 1,000 66.67
01-44-4900 NON CAPITAL OUTLAY < $9,999 0 0 0 0.00
01-44-4910 CAPITAL OUTLAY 0 0 0 0.00
01-44-4930 COMMUNICATIONS EQUIPMENT 0 0 0 0.00
01-44-5425 CREDIT CARD MACHINE FEES 3,800 3,800 0 0.00
01-44-5830 SECURITY FUND EXPENSE 8,180 0 ( 8,180) 100.00-
01-44-5840 TECHNOLOGY FUND EXPENSE 6,500 0 ( 6,500) 100.00-
TOTAL COURT 165,220 210,727 45,507 27.54
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 9
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
CODE ENFORCEMENT
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-45-1010 SALARIES 315,983 330,038 14,055 4.45
01-45-1011 LONGEVITY 2,160 2,040 ( 120) 5.56-
01-45-1015 OVERTIME 12,000 11,930 ( 70) 0.58-
01-45-1016 PHONE ALLOWANCE 1,920 2,640 720 37.50
01-45-1020 UNEMPLOYMENT TAX 2,430 2,700 270 11.11
01-45-1030 SOCIAL SECURITY - MEDICARE 24,969 26,317 1,348 5.40
01-45-1040 TMRS 28,208 27,039 ( 1,169) 4.14-
01-45-1060 HEALTH - LIFE INSURANCE 37,305 33,524 ( 3,781) 10 14-
01-45-1070 WORKERS COMPENSATION 2,566 2,709 143 5.57
01-45-2095 MEDICAL EXAMS 430 200 ( 230) 53.49-
01-45-2610 CONTRACT SERVICES 14,200 14,200 0 0.00
01-45-2611 INSPECTION SERVICES CONTRACT 210,000 135,000 ( 75,000) 35.71-
01-45-2620 PUBLICATIONS 7,000 7,000 0 0.00
01-45-2625 DUES, FEES AND TRAVEL 15,000 0 ( 15,000) 100.00-
01-45-2630 TRAVEL AND TRAINING 0 14,200 14,200 0.00
01-45-2635 DUES AND FEES 0 3,000 3,000 0.00
01-45-2710 PROFESSIONAL SERVICES 0 0 0 0 00
01-45-2810 UTILITIES 0 0 0 0.00
01-45-2820 TELEPHONE 0 3,456 3,456 0.00
01-45-3090 UNIFORM REPLACEMENT 3,000 3,000 0 0.00
01-45-3210 OFFICE SUPPLIES 8,000 6,000 ( 2,000) 25.00-
01-45-3215 PRINTING 0 3,500 3,500 0.00
01-45-3225 OFFICE MACHINERY AND EQUIPMENT 0 22,500 22,500 0.00
01-45-3230 OTHER SUPPLIES 1,000 1,000 0 0.00
01-45-3240 POSTAGE 300 300 0 0 00
01-45-3280 MINOR TOOLS AND EQUIPMENT 1,000 2,000 1,000 100.00
01-45-3450 VEHICLE OPERATION EXPENSE 1,500 1,500 0 0 00
01-45-3455 VEHICLE FUEL 3,500 5,000 1,500 42.86
01-45-3470 VEHICLE REPAIRS 2,000 2,000 0 0.00
01-45-3610 MEETING EXPENSES 3,500 3,500 0 0.00
01-45-4910 CAPITAL OUTLAY 48,500 0 ( 48,500) 100.00-
TOTAL CODE ENFORCEMENT 746,471 666,293 ( 80,178) 10.74-
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 10
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
PUBLIC WORKS
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-46-1010 SALARIES 240,592 377,625 137,033 56.96
01-46-1011 LONGEVITY 3,840 3,960 120 3.13
01-46-1013 CERTIFICATE PAY 0 3,120 3,120 0.00
01-46-1014 ON-CALL PAY 1,500 0 ( 1,500) 100.00-
01-46-1015 OVERTIME 2,280 4,181 1,901 83 38
01-46-1016 PHONE ALLOWANCE 1,560 3,360 1,800 115.38
01-46-1020 UNEMPLOYMENT TAX 2,835 4,050 1,215 42.86
01-46-1030 SOCIAL SECURITY / MEDICARE 18,965 29,750 10,785 56.87
01-46-1040 TMRS 21,234 30,566 9,332 43.95
01-46-1060 HEALTH - LIFE INSURANCE 42,015 52,190 10,175 24.22
01-46-1070 WORKERS COMPENSATION 21,000 38,330 17,330 82.52
01-46-2095 MEDICAL EXAMS 1,700 1,700 0 0.00
01-46-2610 CONTRACT SERVICES 1,000 0 ( 1,000) 100.00-
01-46-2615 CONTRACT MAINTENANCE STREETS 185,000 520,000 335,000 181.08
CONTRACT MAINTENANCE 0 0.00 340,000.00
THISTLE CREEK OVERLAY 0 0.00 180,000.00
01-46-2620 PUBLICATIONS 250 250 0 0.00
01-46-2625 DUES, FEES, TRAVEL 1,000 1,500 500 50.00
01-46- 635 DUES AND FEES 0 0 0 0.00
01-46-2680 TELEPHONE 1,540 1,540 0 0.00
01-46-2710 PROFESSIONAL SERVICES 500 0 ( 500) 100.00-
01-46-2720 ENGINEERING 5,000 5,000 0 0.00
01-46-2810 UTILITIES 4,500 4,500 0 0.00
01-46-3090 UNIFORMS 5,300 11,270 5,970 112.64
01-46-3095 SAFETY SUPPPLIES 0 4,000 4,000 0.00
01-46-3210 OFFICE SUPPLIES 1,500 3,000 1,500 100.00
01-46-3220 JANITORIAL SUPPLIES 0 500 500 0.00
01-46-3225 OFFICE MACHINERY AND EQUIPMENT 0 8,000 8,000 0.00
01-46-3230 OTHER SUPPLIES 200 200 0 0.00
01-46-3272 MAINTENANCE SUPPLIES - PW 0 0 0 0.00
01-46-3275 MAINTENANCE SUPPLIES - STREETS 74,300 70,000 ( 4,300) 5.79-
01-46-3276 DRAINAGE MAINTENANCE 0 10,000 10,000 0 00
01-46-3277 RENTAL 0 10,000 10,000 0.00
01-46-3280 MINOR TOOLS & EQUIPMENT 7,000 7,000 0 0 00
01-46-3295 STREET/DRAIN PROJECT 0 0 0 0.00
01-46-3410 BUILDING MAINTENANCE 700 3,000 2,300 328.57
01-46-3440 MACHINERY MAINTENANCE 10,000 10,000 0 0.00
01-46-3450 VEHICLE OPERATION EXPENSE 6,000 6,000 0 0.00
01-46-3455 VEHICLE FUEL 19,000 19,000 0 0.00
01-46-3470 VEHICLE REPAIRS 4,500 4,500 0 0.00
01-46-3530 SIGNS MAINTENANCE 5,000 6,000 1,000 20.00
01-46-4900 NON CAPITAL OUTLAY <$9,999 0 13,565 13,565 0.00
WATER WAGON ON TRAILER 0 0.00 5,370.00
VIBRATORY PLATE COMPACT 0 0.00 5,200.00
TRACKS FOR SKIDLOADER 0 0.00 2,995.00
01-46-4910 CAPITAL OUTLAY 132,000 417,560 285,560 216.33
ROAD REPAIR MACHINE LOAN 0 0.00 18,000.00
10 YD DUMP TRUCK 0 0.00 77,000.00
STREET SWEEPER VEHICLE 0 0.00 101,000.00
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 11
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
PUBLIC WORKS
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
JOHN DEER FRONT END LOADER 0 0.00 120,700.00
DUAL WHEEL HD3500 QUAD CAB 0 0.00 30,000.00
JOHN DEER TRACTOR/BOOM MOWER 0 0.00 70,860.00
01-46-4925 CAPITAL REPLACEMENT STREET TRA 0 0 0 0.00
01-46-4926 STREETS - CAPITAL PROJECTS 0 0 0 0.00
01-46-4927 DRAINAGE - CAPITAL PROJECTS 0 0 0 0.00
01-46-4928 TWDB GRANT EXPENSES 21,156 0 ( 21,156) 100.00-
01-46-4930 COMMUNICATIONS EQUIPMENT 1,500 7,010 5,510 367.33
01-46-5204 CIBOLO VALLEY DRIVE- REIMB. 0 0 0 0.00
TOTAL PUBLIC WORKS 844,467 1,692,227 847,760 100.39
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 12
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
ANIMAL CONTROL
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-47-1010 SALARIES - A/C 21,237 27,300 6,063 28.55
01-47-1011 LONGEVITY 120 240 120 100.00
01-47-1013 CERTIFICATE PAY 0 0 0 0.00
01-47-1014 ON CALL PAY 0 2,080 2,080 0.00
01-47-1015 OVERTIME 1,500 1,969 469 31.27
01-47-1016 PHONE ALLOWANCE 480 480 0 0.00
01-47-1020 UNEMPLOYMENT TAX 270 270 0 0.00
01-47-1030 SOCIAL SECURITY MEDICARE 1,657 2,417 760 45.87
01-47-1040 TMRS 1,874 2,483 609 32.50
01-47-1060 HEALTH - LIFE INSURANCE 4,189 4,002 ( 187) 4.46-
01-47-1070 WORKERS COMPENSATION 917 684 ( 233) 25.41-
01-47-2200 DATA PROCESSING 0 5,000 5,000 0.00
01-47-2630 TRAVEL AND TRAINING 1,000 1,000 0 0.00
01-47-2710 PROFESSIONAL SERVICES 6,500 10,290 3,790 58.31
01-47-3090 UNIFORMS 1,400 1,400 0 0.00
01-47-3095 SAFETY SUPPLIES/EQUIPMENT 0 500 500 0.00
01-47-3225 OFFICE MACHINERY/EQUIPMENT 0 3,350 3,350 0.00
01-47-3270 OPERATING SUPPLIES 2,000 3,500 1,500 75.00
01-47-3410 BUILDING MAINTENANCE 0 2,000 2,000 0.00
01-47-3450 VEHICLE OPERATION EXPENSE 0 500 500 0.00
01-47-3455 VEHICLE FUEL 0 4,500 4,500 0.00
01-47-4900 NON/CAPITAL OUTLAY 0 6,000 6,000 0.00
01-47-4910 CAPITAL OUTLAY 25,000 0 ( 25,000) 100.00-
01-47-4920 CAPITAL REPLACEMENT TRANS 0 0 0 0.00
01-47-4930 COMMUNICATION EQUIPMENT 0 750 750 0.00
TOTAL ANIMAL CONTROL 68,144 80,715 12,571 18.45
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 13
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
PARKS
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-48-1010 SALARIES - PARK 103,544 146,984 43,440 41.95
01-48-1011 LONGEVITY 240 1,560 1,320 550.00
01-48-1013 CERTIFICATE PAY 0 0 0 0.00
01-48-1015 OVERTIME 1,592 2,204 612 38.44
01-48-1016 PHONE ALLOWANCE 500 720 220 44.00
01-48-1020 UNEMPLOYMENT TAX 1,350 1,620 270 20.00
01-48-1030 SOCIAL SECURITY - MEDICARE 8,251 11,524 3,273 39.67
01-46-1040 TMRS 9,321 11,840 2,519 27.02
01-48-1060 HEALTH / LIFE INSURANCE 19,897 21,824 1,927 9.68
01-48-1070 WORKERS COMPENSATION 4,558 4,793 235 5.16
01-48-2610 CONTRACT SERVICES 10,000 10,000 0 0.00
01-48-2680 TELEPHONE 500 500 0 0.00
01-48-2710 PROFESSIONAL SERVICES 18,000 31,960 13,960 77.56
01-48-2810 UTILITIES 9,000 13,000 4,000 44.44
01-48-3090 UNIFORMS 4,000 4,805 805 20.13
01-48-3095 SAFETY SUPPLIES 0 3,000 3,000 0.00
01-48-3210 OFFICE SUPPLIES 1,000 1,000 .0 0.00
01-48-3225 BOTANICAL SUPPLIES 2,500 3,500 1,000 40.00
01-48-3240 POSTAGE 500 0 ( 500) 100.00-
01-48-3280 MINOR TOOLS AND EQUIPMENT 4,500 4,500 0 0.00
01-48-3370 PARK MAINTENANCE/REPAIR 5,500 5,500 0 0.00
01-48-3390 PARK SUPPLIES 2,500 2,500 0 0.00
01-48-3400 CIBOLOFEST EXPENSE 4,000 4,000 0 0.00
01-48-3440 MACHINERY MAINTENANCE 2,000 2,000 0 0.00
01-48-3442 MACHINERY OPERATIONS 4,000 0 ( 4,000) 100.00-
01-48-3445 MACHINERY REPAIR 4,000 2,000 ( 2,000) 50.00-
01-48-3450 VEHICLE OPERATIONS 2,500 3,500 1,000 40.00
01-48-3455 VEHICLE FUEL 10,500 12,500 2,000 19.05
01-48-3470 VEHICLE REPAIR 3,000 4,000 1,000 33.33
01-48-4900 NON CAPITAL OUTLAY <$9,999 0 14,000 14,000 0.00
PARKS SINAGE 0 0.00 10,000.00
FENCE 0 0.00 4,000.00
01-48-4910 CAPITAL OUTLAY 50,150 49,100 ( 1,050) 2.09-
4WD TRACTOR//FRONT LOAD CUTTER 0 0.00 49,100.00
01-48-4911 RICH PARK IMPROVEMENTS 0 0 0 0.00
01-48-4912 CIBOLO VALLEY PARK - IMPROVEME 0 0 0 0.00
01-48-4913 BUFFALO CROSSING PARK IMPVMNTS 92,000 0 ( 92,000) 100.00-
01-48-4930 COMMUNICATIONS EQUIPMENT 2,000 2,000 0 0.00
TOTAL PARKS 381,403 376,434 ( 4,969) 1.30-
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 14
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
01 -GENERAL FUND
COMMUNITY DEVELOPMENT
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
01-49-1010 SALARIES 104,520 111,496 6,976 6.67
01-49-1011 LONGEVITY 120 480 360 300.00
01-49-1012 CAR ALLOWANCE 1,200 1,200 0 0.00
01-49-1016 PHONE ALLOWANCE 760 1,200 440 57.89
01-49-1020 UNEMPLOYMENT TAX 540 540 0 0.00
01-49-1030 SOCIAL SECURITY-MEDICARE 8,005 8,557 552 6.90
01-49-1040 TMRS 9,093 8,792 ( 301) 3.31-
01-49-1060 HEALTH - LIFE INSURANCE 8,378 7,590 ( 788) 9.41-
01-49-1070 WORKERS COMPENSATION 336 360 24 7.14
01-49-2095 MEDICAL EXAMS 39 0 ( 39) 100.00-
01-49-2200 DATA PROCESSING SOFTWARE 2,400 1,800 ( 600) 25.00-
01-49-2610 CONTRACT SERVICES 30,000 13,184 ( 16,816) 56.05-
01-49-2620 PUBLICATIONS 1,500 1,000 ( 500) 33.33-
01-49-2625 ADVERTISING 0 1,200 1,200 0.00
01-49-2630 TRAVEL AND TRAINING 9,000 12,400 3,400 37.78
01-49-2635 DUES AND FEES 1,900 7,420 5,520 290.53
01-49-2710 DEVELOPMENT REVIEW 100,000 338,000 238,000 238.00 ,
01-49-2715 DEVELOPMENT CODES/STUDIES 68,000 0 ( 68,000) 100.00-
01-49-2720 MAPPING 15,000 0 ( 15,000) 100.00-
01-49-2730 IMPACT FEE STUDY 68,000 0 ( 68,000) 100.00-
01-49-2750 ECONOMIC DEV-SERVICES/LEGAL 75,000 65,000 ( 10,000) 13.33-
01-49-3090 UNIFORM AND CLOTHING 0 425 425 0.00
01-49-3210 OFFICE SUPPLIES 5,661 11,000 5,339 94.31
01-49-3215 PRINTING 0 1,500 1,500 0.00
01-49-3225 OFFICE MACHINERY & EQUIMENT 0 0 0 0.00
01-49-3240 POSTAGE 5,000 3,000 ( 2,000) 40.00-
01-49-3280 MINOR TOOLS AND EQUIPMENT 1,800 4,000 2,200 122.22
01-49-4910 CAPITAL OUTLAY 13,550 0 ( 13,550) 100.00-
01-49-5800 CONTINGENCY 0 0 0 0.00
TOTAL COMMUNITY DEVELOPMENT 529,802 600,144 70,342 13.28
*** TOTAL EXPENDITURES *** 5,478,453 6,822,323 1,343,870 24.53
** REVENUE OVER(UNDER) EXPENDITURES ** ( 5,000) 0 5,000 100.00-
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
02 -WATER & SEWER FUND
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
WATER SALES
02-31100 WATER SALES - RESIDENTIAL 1,375,000 1,607,040 232,040 16.88
02-31110 WATER SALES - COMMERCIAL 0 168,876 168,876 0.00
TOTAL WATER SALES 1,375,000 1,775,916 400,916 29.16
WASTE WATER
02-31200 WASTE WATER - RESIDENTIAL 927,600 1,019,940 92,340 9.95
02-31210 WASTE WATER - COMMERCIAL 0 94,008 94,008 0.00
TOTAL WASTE WATER 927,600 1,113,948 186,348 20.09
GARBAGE
02-31300 GARBAGE COLLECTION - RESID 1,025,000 617,047 ( 407,953) 39.80-
02-31310 GARBAGE COLLECTION - COMM 0 448,200 448,200 0.00
TOTAL GARBAGE 1,025,000 1,065,247 40,247 3.93
MISC WATER
02-31400 LATE FEES 74,900 87,000 12,100 16.15
02-31450 DEPOSIT REFUND CONV CHARGE 0 0 0 0.00
02-31600 RECYCLING FEES - A/R 89,900 112,191 22,291 24.80
02-31610 RECYCLING FEES - CASH BACK 9,000 12,000 3,000 33.33
02-31700 WATER ACQUISITION FEE 163,300 205,344 42,044 25.75
TOTAL MISC WATER 337,100 416,535 79,435 23.56
PERMITS
02-32100 CONNECT FEES 83,100 42,600 ( 40,500) 48.74-
02-32200 METER INSTALLATION FEES 46,800 25,200 ( 21,600) 46.15-
02-32250 METER SALES 137,280 84,000 ( 53,280) 38.81-
02-32300 IMPACT FEES - WATER 0 0 0 0.00
02-32400 IMPACT FEES - WASTE WATER 0 0 0 0.00
TOTAL PERMITS 267,180 151,800 ( 115,380) 43.18-
CREDIT CARD
02-34540 CREDIT CARD FEES 1,800 1,800 0 0.00
TOTAL CREDIT CARD 1,800 1,800 0 0.00
OTHER REVENUE
02-35100 INTEREST 34,000 35,000 1,000 2.94
02-35105 2006 REVENUE BOND INTEREST 0 0 0 0.00
02-35150 2006 BOND TRANSFER IN 0 0 0 0.00
02-35235 ENCUMERED FUNDS 0 25,000 25,000 0.00
02-35250 2006 REVENUE BOND PROCEEDS 0 0 0 0.00
02-35260 CAP REPLACE TRANSFER 0 0 0 0 00
02-35265 TRANSFER IN DEBT FUND 0 198,613 198,613 0.00
02-35266 TRANSFER IN FROM FUND BALANCE 0 0 0 0.00
02-35270 WATER IMPACT FEE TRF/DEBT 0 340,004 340,004 0.00
02-35280 TRF IN - POLICE FUNDS 0 0 0 0.00
02-35300 MISC RECEIPTS 1,000 1,000 0 0.00
02-35315 NSF FEES 2,900 3,300 400 13.79
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 2
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
02 -WATER & SEWER FUND
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
02-35320 CHILD SUPPORT FEE 0 0 0 0.00
02-35410 CASH OVER/SHORT 0 0 0 0.00
TOTAL OTHER REVENUE 37,900 602,917 565,017 1,490.81
*** TOTAL REVENUE *** 3,971,580 5,128,163 1,156,583 29.12
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 3
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
02 -WATER & SEWER FUND
UTILITIES-ADMINISTRATION
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
02-42 0 0 0 0 0.00
02-42-1010 SALARIES 94,058 84,390 ( 9,668) 10.28-
02-42-1011 LONGEVITY 2,880 3,120 240 8.33
02-42-1015 OVERTIME 1,000 0 ( 1,000) 100.00-
02-42-1020 UNEMPLOYMENT TAX 1,080 810 ( 270) 25.00-
02-42-1030 SOCIAL SECURITY - MEDICARE 7,416 6,695 ( 721) 9.72-
02-42-1040 TMRS 8,183 6,878 ( 1,305) 15.95-
02-42-1060 HEALTH - LIFE INSURANCE 12,567 11,898 ( 669) 5.32-
02-42-1070 WORKERS COMPENSATION 302 282 ( 20) 6.62-
02-42-2200 DATA PROCESSING 3,000 3,000 0 0.00
02-42-2610 CONTRACT SERVICES 55,000 20,000 ( 35,000) 63.64-
02-42-2640 BILLING SERVICE - DATA PROSE 15,100 36,000 20,900 138.41
02-42-2650 GENERAL LIABILITY INSURANCE 20,000 20,000 0 0.00
02-42-2680 LEGAL SERVICES 1,500 5,000 3,500 233.33
02-42-2710 PROFESSIONAL SERVICES 0 25,000 25,000 0.00
02-42-2720 AUDIT SERVICES 8,000 8,000 0 0.00
02-42-2975 AGENT FEES 0 0 0 0.00
02-42-3210 OFFICE SUPPLIES 2,500 2,500 0 0.00
02-42-3225 OFFICE MACHINERY & EQUIPMENT 0 3,000 3,000 0.00
02-42-3230 OTHER SUPPLIES 500 500 0 0.00
02-42-3240 POSTAGE 9,000 6,000 ( 3,000) 33.33-
02-42-3410 BUILDING MAINTENANCE 2,500 0 ( 2,500) 100.00-
02-42-4910 CAPITAL OUTLAY 1,500 0 ( 1,500) 100.00-
02-42-4925 LAND PURCHASE 1,500 0 ( 1,500) 100.00-
02-42-4955 CAPITAL OUTLAY - NEW METERS 0 0 0 0.00
02-42-5000 DEPRECIATION 0 0 0 0.00
02-42-5001 PRIOR PERIOD ADJUSTMENT 0 0 0 0.00
02-42-5002 AMORTIZED BOND ISSUE COST 0 0 0 0.00
02-42-5425 CREDIT CARD MACHINE FEES 2,000 2,000 0 0.00
02-42-5732 GBRA 116,000 143,100 27,100 23.36
02-42-5735 TRANSFER TO GENERAL/ADMIN 55,000 59,510 4,510 8.20
02-42-5762 GREEN VALLEY SUD 10,000 10,000 0 0.00
02-42-5764 REGIONAL WTR DEV GRP 2,000 2,000 0 0.00
02-42-5766 CCMA 700,000 715,400 15,400 2.20
02-42-5767 BEXAR WASTE CONTRACT 861,000 1,094,200 233,200 27.08
02-42-5768 REFUSE TRANSFER TO GENERAL 153,750 175,000 21,250 13.82
02-42-5769 CRWA 820,000 949,600 129,600 15.80
02-42-5830 TRANSFER TO DEBT SERVICE 60,000 0 ( 60,000) 100.00-
02-42-5900 CHARGE OFF WATER ACCOUNTS 3,000 0 ( 3,000) 100.00-
02-42-5980 CONTINGENCY 3,892 0 ( 3,892) 100.00-
02-42-5981 TRANSFER TO FUND BALANCE 0 96,714 96,714 0.00
02-42-6855 BOND FEES 2,000 2,000 0 0.00
02-42-6902 2002 TAX NOTE _ 0 198,613 198,613 0.00
02-42-6903 2006 TEN YEAR REVENUE BOND 0 57,908 57,908 0.00
02-42-6904 2006 20 YEAR REVENUE BOND 0 158,291 158,291 0.00
02-42-6905 2007 GENERAL OBLIGATION BOND 0 187,647 187,647 0.00
02-42-6965 SERIES 1985 INT 0 0 0 0.00
02-42-860 WATER SEWR BOND INTEREST 0 0 0 0.00
TOTAL UTILITIES-ADMINISTRATION 3,036,228 4,095,056 1,058,828 34.87
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 4
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
02 -WATER & SEWER FUND
UTILITIES-OPERATIONS
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
02-46-1010 SALARIES 195,336 269,184 73,848 37.81
02-46-1011 LONGEVITY 1,560 960 ( 600) 38.46-
02-46-1013 CERTIFICATE PAY 0 0 0 0.00
02-46-1014 ON-CALL PAY 2,500 2,500 0 0.00
02-46-1015 OVERTIME 15,069 25,996 10,927 72.51
02-46-1016 PHONE ALLOWANCE 940 1,680 740 78.72
02-46-1020 UNEMPLOYMENT 2,160 2,700 540 25.00
02-46-1030 SOCIAL SECURITY - MEDICARE 15,463 22,655 7,192 46.51
02-46-1040 TMRS 17,476 23,277 5,801 33.19
02-46-1060 HEALTH - LIFE INSURANCE 29,322 38,841 9,519 32.46
02-46-1070 WORKERS COMPENSATION 7,821 12,190 4,369 55.86
02-46-2095 MEDICAL EXAMS 1,000 1,000 0 0.00
02-46-2200 DATA PROCESSING 0 0 0 0.00
02-46-2510 UTILITY LAB FEES 5,500 5,500 0 0.00
02-46-2610 CONTRACT SERVICES 9,500 9,500 0 0.00
02-46-2625 DUES - FEES 2,000 2,000 0 0.00
02-46-2630 TRAVEL - TRAINING 3,000 4,500 1,500 50.00
02-46-2710 PROFESSIONAL SERVICES 20,000 20,000 0 0.00
02-46-2811 UTILITIES 30,000 30,000 0 0 00
02-46-2820 TELEPHONE 1,020 1,020 0 0.00
02-46-3090 UNIFORMS 6,000 8,050 2,050 34.17
02-46-3095 SAFETY SUPPLIES 0 4,000 4,000 0.00
02-46-3210 OFFICE SUPPLIES 1,000 1,500 500 50.00
02-46-3220 JANITORIAL SUPPLIES 500 500 0 0.00
02-46-3225 OFFICE MACHINERY & EQUIPMENT 0 3,000 3,000 0.00
02-46-3230 OTHER SUPPLIES 6,000 500 ( 5,500) 91.67-
02-46-3240 POSTAGE 500 500 0 0.00
02-46-3271 MAIN REPAIR WATER 45,000 45,000 0 0.00
02-46-3272 MAIN REPAIR SEWER 10,000 10,000 0 0.00
02-46-3280 MINOR TOOLS/EQUIPMENT 7,000 7,000 0 0.00
02-46-3440 MACHINERY MAINTENANCE 4,500 6,500 2,000 44.44
02-46-3450 VEHICLE OPERATION EXPENSE 1,300 2,000 700 53.85
02-46-3455 VEHICLE FUEL 9,700 18,700 9,000 92.78
02-46-3470 VEHICLE REPAIRS 3,000 3,000 0 0.00
02-46-4900 NON CAPITAL OUTLAY <$9,999 0 21,825 21,825 0.00
SEWER CAMERA 0 0.00 9,175.00
ELECTRIC-HYDRAULIC CRANE 0 0.00 9,400.00
GAS WELDER 0 0.00 3,250.00
02-46-4910 CAPITAL OUTLAY 177,287 82,529 ( 94,758) 53.45-
GOOSENECK TRAILER 0 0.00 11,200.00
5 YD DUMP TRUCK 0 0.00 44,329.00
3/4 TON EXT CAB/BED 0 0 00 27,000.00
02-46-4916 WATER LINE PROJECTS 151,898 193,000 41,102 27.06
BORGFELD ROAD WATER LINE "T" 0 0.00 55,000.00
INDUSTRIAL WATER LINE CONNECT 0 0.00 53,000.00
PFIEL RD CONNECTOR 0 0.00 85,000.00
02-46-4917 SEWER LINE PROJECTS 0 0 0 0.00
02-46-4920 CAPITAL REPLACEMENT TRANS 0 0 0 0.00
02-46-4930 COMMUNICATION EQUIPMENT 2,000 2,000 0 0.00
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 5
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
02 -WATER & SEWER FUND
UTILITIES-OPERATIONS
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
02-46-4955 WATER METERS 150,000 150,000 0 0.00
02-46-5000 DEPRECIATION 0 0 0 0.00
02-46-5300 METER CONVERSION COST 0 0 0 0.00
02-46-5500 LAND ACQUISITION 0 0 0 0.00
TOTAL UTILITIES-OPERATIONS 935,352 1,033,107 97,755 10.45
*** TOTAL EXPENDITURES *** 3,971,580 5,128,163 1,156,583 29.12
** REVENUE OVER(UNDER) EXPENDITURES ** 0 0 0 0.00
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
03 -DEBT SERVICE FUND
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
PROPERTY TAX
03-31100 PROPERTY TAXES - CURRENT 533,335 742,288 208,953 39.18
03-31120 PROPERTY TAXES - DELINQUENT 2,500 4,900 2,400 96.00
03-31130 PROP TAX - PENALTY & INTEREST 4,000 4,000 0 0.00
03-31140 2001 BOND PROCEEDS 0 0 0 0.00
TOTAL PROPERTY TAX 539,835 751,188 211,353 39.15
COURT FINES
03-34310 CASH OVER/SHORT 0 0 0 0.00
TOTAL COURT FINES 0 0 0 0.00
OTHER REVENUE
03-35100 INTEREST INCOME 2,500 6,500 4,000 160.00
03-35200 TRANSFER FROM W/S IMPACT 210,731 0 ( 210,731) 100.00-
03-35220 TRANSFER IN FROM WATER FUND 60,000 0 ( 60,000) 100.00-
03-35230 TRANSFER IN FROM WASTE W IMPAC 0 0 0 0.00
03-35280 TRF IN - POLICE FUNDS 0 0 0 0.00
03-35300 TRANS FROM GF FUND BAL 0 0 0 0.00
03-35400 TRANSFER IN DRAINAGE IMPACT 305,353 130,913 ( 174,440) 57.13-
03-35500 MISCELLANEOUS 0 0 0 0.00
TOTAL OTHER REVENUE 578,584 137,413 ( 441,171) 76.25-
*** TOTAL REVENUE *** 1,118,419 888,601 ( 229,818) 20.55-
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 2
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
03 -DEBT SERVICE FUND
DEBT SERVICE
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
03-41-0930 2001 SERIES - PRINCIPAL 50,000 55,000 5,000 10.00
03-41-0940 2001 SERIES - INTEREST 56,163 53,669 ( 2,494) 4.44-
03-41-0950 AGENT FEES 5,000 2,500 ( 2,500) 50.00-
03-41-0960 2002 TAX NOTE PRINCIPLE 185,000 0 ( 185,000) 100.00-
03-41-0970 2002 TAX NOTE INTEREST 13,491 0 ( 13,491) 100.00-
03-41-0980 2003 CERT OF OBLIGATION-PRINC 70,000 75,000 5,000 7.14
03-41-0990 2003 CERT OF OBLIGATION - INT 35,975 33,075 ( 2,900) 8.06-
03-41-1000 2006 TAX NOTE PRINCIPLE 380,000 0 ( 380,000) 100.00-
03-41-1010 2006 TAX NOTE INTEREST 107,623 0 ( 107,623) 100.00-
03-41-1020 2006 REVENUE BOND PRINCIPLE 95,000 0 ( 95,000) 100.00-
03-41-1030 2006 REVENUE BOND INTEREST 120,167 0 ( 120,167) 100.00-
03-41-1040 2007 GO BOND PRINCIPAL 0 80,000 80,000 0.00
03-41-1045 2007 GO BOND INTEREST 0 364,053 364,053 0.00
03-41-5981 TRANSFER TO FUND BALANCE 0 26,691 26,691 0.00
03-41-9600 2002 TAX NOTE TRF TO WATER 0 198,613 198,613 0.00
TOTAL DEBT SERVICE 1,118,419 888,601 ( 229,818) 20.55-
*** TOTAL EXPENDITURES *** 1,118,419 888,601 ( 229,818) 20.55-
** REVENUE OVER(UNDER) EXPENDITURES ** 0 0 0 0.00
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
04 -CAPITAL PROJECTS FUND
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
PROPERTY TAX
04-31100 TRANS FROM DRAIN IF - STREET 0 0 0 0.00
TOTAL PROPERTY TAX 0 0 0 0.00
SALES TAX
04-31200 TRANS FROM STREET IF - STREET 0 0 0 0.00
TOTAL SALES TAX 0 0 0 0.00
STREETS
04-31300 TRANS FROM GF - STREETS 0 0 0 0.00
TOTAL STREETS 0 0 0 0.00
REV CATG 14-20
04-31400 TRANS FROM PARK FEES 0 0 0 0.00
04-31500 2003 BOND SALE 0 0 0 0.00
04-31600 TRANSFER FROM GF - CITY HALL 0 0 0 0.00 •
04-31700 TRANSFER FROM GF - CRWA 0 0 0 0.00
TOTAL REV CATG 14-20 0 0 0 0.00
BOND REVENUE
04-34000 BOND REVENUE 0 0 0 0.00
TOTAL BOND REVENUE 0 0 0 0.00
COURT FINES
04-34310 CASH OVER/SHORT 0 0 0 0.00
TOTAL COURT FINES 0 0 0 0.00
OTHER REVENUE
04-35150 2001 STREET CONST INTEREST 0 0 0 0.00
04-35155 2003 CONSTRUCTION INTEREST 0 0 0 0.00
04-35280 TRF IN - POLICE FUNDS 0 0 0 0.00
04-35600 TRANSFER IN 0 0 0 0.00
TOTAL OTHER REVENUE 0 0 0 0.00
*** TOTAL REVENUE *** 0 0 0 0.00
*** TOTAL EXPENDITURES *** 0 0 0 0.00
** REVENUE OVER(UNDER) EXPENDITURES ** 0 0 0 0.00
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
07 -2006 TAX NOTE
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
OTHER REVENUE
07-35105 2006 TAX NOTE INTEREST 40,000 50,000 10,000 25.00
07-35230 TRANSFER IN FUND BALANCE 0 2,033,561 2,033,561 0.00
07-35250 2006 TAX NOTE PROCEEDS 2,305,869 0 ( 2,305,869) 100.00-
07-35280 TRF IN - POLICE FUNDS 0 0 0 0.00
TOTAL OTHER REVENUE 2,345,869 2,083,561 ( 262,308) 11.18-
*** TOTAL REVENUE *** 2,345,869 2,083,561 ( 262,308) 11.18-
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 2
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
07 -2006 TAX NOTE
2006 BOND NOTE
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
07-41-5000 BOND ISSUANCE COST 0 0 0 0.00
07-41-5001 BOND CONTINGENCY 376,485 601,345 224,860 59.73
07-41-5100 S BORGFELD DRNG-CONST COST 437,259 246,592 ( 190,667) 43.61-
07-41-5200 TOWN CREEK EAST-CONST COST 1,723,236 1,087,232 ( 636,004) 36.91-
07-41-5201 2006 DRAINAGE PROJ-ENG/CONST 253,726 138,716 ( 115,010) 45.33-
07-41-5202 PEDESTRIAN BRIDGE-CONST COST 66,734 9,676 ( 57,058) 85.50-
TOTAL 2006 BOND NOTE 2,857,440 2,083,561 ( 773,879) 27.08-
*** TOTAL EXPENDITURES *** 2,857,440 2,083,561 ( 773,879) 27 08-
** REVENUE OVER(UNDER) EXPENDITURES ** ( 511,571) 0 511,571 100.00-
*** END OF REPORT ***
9-13-2007 09:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
08 -2007 GO GENERAL
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
OTHER REVENUE
08-35105 GO BOND INTEREST 0 120,000 120,000 0.00
08-35230 TRF FROM FUND BALANCE 0 5,230,000 5,230,000 0.00
08-35250 BOND PROCEEDS-MAIN ST 0 0 0 0.00
08-35251 BOND PROCEEDS-DRAINAGE 0 0 0 0.00
08-35252 BOND PROCEEDS - PUBLIC WORKS 0 0 0 0.00
TOTAL OTHER REVENUE 0 5,350,000 5,350,000 0.00
*** TOTAL REVENUE *** 0 5,350,000 5,350,000 0.00
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 2
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
08 -2007 GO GENERAL
2007 CAPITAL PROJECTS
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
08-41-5000 BOND CONTINGENCY 0 150,000 150,000 0.00
08-41-5010 BOND ISSUANCE COST 0 0 0 0.00
08-41-5110 MAIN STREET RECONSTURCTION 0 3,100,000 3,100,000 0.00
08-41-5130 TOWN CREEK WEST DRAINAGE 0 600,000 600,000 0.00
08-41-5200 PUBLIC WORKS FACILITY 0 1,500,000 1,500,000 0.00
TOTAL 2007 CAPITAL PROJECTS 0 5,350,000 5,350,000 0.00
*** TOTAL EXPENDITURES *** 0 5,350,000 5,350,000 0.00
** REVENUE OVER(UNDER) EXPENDITURES ** 0 0 0 0.00
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
12 -W/WW 2006 BOND FUND
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
OTHER REVENUE
12-35105 2006 REVENUE BOND INTEREST 40,000 50,000 10,000 25.00
12-35150 2006 BOND TRF FROM RESERVES 879,900 0 ( 879,900) 100.00-
12-35230 TRANSFER IN FUND BALANCE 0 2,570,539 2,570,539 0.00
12-35242 TRF IN FROM 2007 GO W/WW 0 118,517 118,517 0.00
12-35250 2006 REVENEU BOND PROCEEDS 0 0 0 0.00
12-35280 0 0 0 0 00
TOTAL OTHER REVENUE 919,900 2,739,056 1,819,156 197.76
*** TOTAL REVENUE *** 919,900 2,739,056 1,819,156 197.76
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 2
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
12 -W/WW 2006 BOND FUND
2006 REVENUE TAX NOTE
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
12-41-5000 BOND ISSUANCE COST 0 0 0 0.00
12-41-5001 CAPITAL OUTLAY - NEW METERS 0 0 0 0.00
12-41-5100 WEIDNER RD 16" WTR LINE-ENG 62,400 12,191 ( 50,209) 80.46-
12-41-5150 LAND ACQUISITION/EASEMENTS 16" 0 0 0 0.00
12-41-5200 WEIDNER RD 16" WTR LINE CONST 630,000 1,250,920 620,920 98.56
12-41-5206 FM 1103 WTR FEEDER LINE - ENG 137,500 100,945 ( 36,555) 26.59-
12-41-5207 FM 1103 WTR FEEDER-CONSTR 0 1,375,000 1,375,000 0.00
12-41-5226 LAND ACQUIST/EASEMENT FM 1103 0 0 0 0.00
12-41-5500 LAND AQUISITION 50,000 0 ( 50,000) 100.00-
TOTAL 2006 REVENUE TAX NOTE 879,900 2,739,056 1,859,156 211.29
*** TOTAL EXPENDITURES *** 879,900 2,739,056 1,859,156 211.29
** REVENUE OVER(UNDER) EXPENDITURES ** 40,000 0 ( 40,000) 100.00-
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
14 -2007 GO W/WW PROJECTS
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
OTHER REVENUE
14-35105 GO BOND INTEREST 0 70,000 70,000 0.00
14-35230 TRF IN FUND BALANCE RESERVE 0 2,942,550 2,942,550 0.00
14-35250 BOND PROCEEDS 0 0 0 0.00
14-35285 TRANSFER IN WATER IMPACT FUND 0 0 0 0.00
14-35290 TRANSFER IN FROM GENERAL FUND 0 0 0 0.00
TOTAL OTHER REVENUE 0 3,012,550 3,012,550 0.00
*** TOTAL REVENUE *** 0 3,012,550 3,012,550 0.00
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 2
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
14 -2007 GO W/WW PROJECTS
2007 GO W/WW PROJECTS
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
14-41-5000 BOND CONTINGENCY 0 379,533 379,533 0.00
14-41-5010 TRF TO 2007 REVENUE PROJECTS 0 118,517 118,517 0.00 _
14-41-5050 FM 1103 LAND 11.906 ACRES 0 0 0 0.00
14-41-5100 WATER TOWER ENG/CONST 0 2,029,500 2,029,500 0.00
14-41-5110 WATER TOWER GENERATOR 0 85,000 85,000 0.00
14-41-5115 WIEDNER 12" CONNECTOR LINE 0 200,000 200,000 0.00
14-41-5120 FM 1103 WASTE WTR LINE 0 200,000 200,000 0.00
TOTAL 2007 GO W/WW PROJECTS 0 3,012,550 3,012,550 0.00
*** TOTAL EXPENDITURES *** 0 3,012,550 3,012,550 0.00
** REVENUE OVER(UNDER) EXPENDITURES ** 0 0 0 0.00
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
22 -WATER IMPACT FEES
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
IMPACT FEES
22-32300 IMPACT FEES - WATER 0 0 0 0.00
22-32580 TRF IN - WATER IMPACT FEES 619,231 619,231 0 0.00
TOTAL IMPACT FEES 619,231 619,231 0 0.00
OTHER REVENUE
22-35100 INTEREST 0 0 0 0.00
22-35280 TRF IN - POLICE FUNDS 0 0 0 0.00
TOTAL OTHER REVENUE 0 0 0 0.00
*** TOTAL REVENUE *** 619,231 619,231 0 0.00
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 2
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
22 -WATER IMPACT FEES
WATER IMPACT FEE EXPENSE
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
22-46-4925 LAND PURCHASE 49,000 49,000 0 0.00
22-46-5201 BRENTWOOD RANCH OVERSIZE LINE 279,500 279,500 0 0.00
22-46-5202 1.25M WATER TOWER - ENGINEER 80,000 80,000 0 0.00
22-46-5830 TANSFER TO DEBT 210,731 210,731 0 0.00
TOTAL WATER IMPACT FEE EXPENSE 619,231 619,231 0 0.00
*** TOTAL EXPENDITURES *** 619,231 619,231 0 0.00
** REVENUE OVER(UNDER) EXPENDITURES ** 0 0 0 0.00
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
24 -WASTE WATER IMPACT FEE
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
IMPACT FEES
24-32400 IMPACT FEES - WASTE WATER 0 0 0 0 00
TOTAL IMPACT FEES 0 0 0 0.00
OTHER REVENUE
24-35100 INTEREST 0 0 0 0.00
24-35230 TRANSFER IN FUND BALANCE 85,000 85,000 0 0.00
24-35280 TRF IN - POLICE FUNDS 0 0 0 0.00
TOTAL OTHER REVENUE 85,000 85,000 0 0.00
*** TOTAL REVENUE *** 85,000 85,000 0 0.00
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 2
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
24 -WASTE WATER IMPACT FEE
WASTE WATER IMPACT EXPEN
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
24-46-5830 TRANSFER TO DEBT SERVICE 0 0 0 0.00
24-46-5910 CIBOLO/SCHERTZ LINE - ENG 8,000 8,000 0 0.00
24-46-5915 CIBOLO/SCHERTZ LINE CONST 77,000 77,000 0 0.00
TOTAL WASTE WATER IMPACT EXPEN 85,000 85,000 0 0.00
*** TOTAL EXPENDITURES *** 85,000 85,000 0 0.00
** REVENUE OVER(UNDER) EXPENDITURES ** 0 0 0 0.00
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
30 -STREET IMPACT FEE
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
IMPACT FEES
30-32700 IMPACT FEES - STREET 250,000 250,000 0 0.00
TOTAL IMPACT FEES 250,000 250,000 0 0.00
OTHER REVENUE
30-35100 INTEREST 0 0 0 0.00
30-35280 TRF IN - POLICE FUNDS 0 0 0 0.00
TOTAL OTHER REVENUE 0 0 0 0.00
*** TOTAL REVENUE *** 250,000 250,000 0 0.00
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
31 -DRAINAGE IMPACT FEE
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
IMPACT FEES
31-32800 IMPACT FEES - DRAINAGE 150,000 150,000 0 0.00
TOTAL IMPACT FEES 150,000 150,000 0 0.00
OTHER REVENUE
31-35100 INTEREST 0 0 0 0.00
31-35280 TRF IN - POLICE FUNDS 0 0 0 0.00
TOTAL OTHER REVENUE 0 0 0 0.00
*** TOTAL REVENUE *** 150,000 150,000 0 0.00
*** TOTAL EXPENDITURES *** 0 0 0 0 00
** REVENUE OVER(UNDER) EXPENDITURES ** 150,000 150,000 0 0.00
*** END OF REPORT ***
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 1
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
32 -PARK LAND FEES
CURRENT SELECTED BUDGET PERCENT BUDGET
REVENUES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
OTHER REVENUE
32-35100 INTEREST 0 0 0 0.00
32-35280 TRF IN - POLICE FUNDS 0 0 0 0 00
32-36200 PARK LAND FEES 150,000 150,000 0 0.00
32-36210 BUFFALO CROSSING PARK FEES 0 0 0 0.00
32-36215 BUILDER PARK LAND FEES 0 0 0 0.00
TOTAL OTHER REVENUE 150,000 150,000 0 0 00
*** TOTAL REVENUE *** 150,000 150,000 0 0.00
9-13-2007 04:36 PM CITY OF CIBOLO PAGE: 2
BUDGET COMPARISON REPORT
AS OF: JULY 31ST, 2007
32 -PARK LAND FEES
PARKS
CURRENT SELECTED BUDGET PERCENT BUDGET
EXPENDITURES BUDGET BUDGET VARIANCE VARIANCE WORKSPACE
32-48-2710 PROFESSIONAL SERVICES 30,750 0 ( 30,750) 100 00-
32-48-5735 TRANSFER TO GENERAL FUND 92,000 0 ( 92,000) 100.00-
TOTAL PARKS 122,750 0 ( 122,750) 100.00-
*** TOTAL EXPENDITURES *** 122,750 0 ( 122,750) 100.00-
** REVENUE OVER(UNDER) EXPENDITURES ** 27,250 150,000 122,750 450.46
*** END OF REPORT ***