Item 3DWATER AND SEWER ENTERPRISE FUND
Comparative Statement of Revenues and Expenses
for the period ended July 31, 2007 and July 31, 2006
(fiscal month 10-83.33%)
AMENDED
Percent
Year to Date2006/07Collected/Year to Date
7/31/07BudgetExpended7/31/2006
REVENUES
Water Sales-residential$5,882,440$10,200,00057.7%$8,135,558
Water Sales-commercial1,909,0942,800,00068.2%2,187,093
Sewer Sales3,189,4663,700,00086.2%3,003,323
Sanitation Sales825,089960,00085.9%846,496
Other utility charges230,689285,50080.8%206,188
Miscellaneous140,817102,500137.4%147,074
100,000164.2%81,847
Interest Income164,200
$18,148,000
Total Revenues$12,341,79568.0%$14,607,579
EXPENSES
Water$5,273,697$9,601,02454.9%$5,820,013
Utility Billing221,558 358,863 61.7%181,616
Sewer980,4661,922,26851.0%999,542
Sanitation565,676754,50075.0%539,738
5,416,19980.7%4,284,645
Debt Service4,370,520
$18,052,854
Total Expenses$11,411,91763.2%$11,825,554
Excess (deficiency) of
$95,146
Revenue over Expenses$929,878$2,782,025
OTHER FINANCING
SOURCES AND (USES)
Transfer In-Other Funds$0$0
Developer Contributions$0$50,000$0
Transfer Out-Other Funds(275,595)(275,595)0
Total Other Sources/(Uses)($275,595)($225,595)$0
Excess (deficiency) of
Revenues and other sources
($130,449)$2,782,025
over Expenses$654,283
GENERAL FUND
Statement of Revenues, Expenditures and Changes in Fund Balance
for the period ended July 31, 2007
with comparative actual amounts for the period ended July 31, 2006
(fiscal month 10-83.33%)
AMENDED
Percent
Year to Date2006/07Collected/Year to Date
REVENUES7/31/07BudgetExpended7/31/2006
Ad Valorem Taxes$13,002,634$12,953,276100.4%$11,878,027
Sales Tax6,760,0717,952,00085.0%6,268,994
Franchise Fees1,635,7292,188,72374.7%1,497,614
Fines794,0681,216,00065.3%1,062,267
Charges for Services696,128729,61295.4%619,577
Permits/Fees1,733,2191,667,960103.9%1,485,229
Miscellaneous578,456484,966119.3%501,974
Interest Income228,060250,00091.2%203,726
$27,442,537
Total Revenues$25,428,36592.7%$23,517,408
EXPENDITURES
City Secretary$235,309$351,92066.9%$213,964
Human Resources307,589382,21480.5%277,439
City Manager391,512585,75266.8%385,583
Support Services2,559,5893,778,31067.7%2,374,544
General Government Total3,493,9995,098,19668.5%3,251,530
Finance767,837965,86479.5%692,776
Municipal Court429,183534,08980.4%348,076
Municipal Court-Teen Court87,831118,22474.3%53,204
Finance Total1,284,8511,618,17779.4%1,094,056
Fire 2,837,6893,802,93574.6%2,452,018
Police4,030,0625,600,22272.0%3,656,881
Public Safety Support1,461,0721,515,60996.4%1,146,083
Building542,169719,37075.4%638,639
Public Safety Total8,870,99211,638,13676.2%7,893,621
Streets/Drainage1,180,4931,589,73274.3%1,025,041
Public Works Administration715,195975,98973.3%588,389
Public Works Total1,895,6882,565,72173.9%1,613,430
Planning631,016931,29867.8%482,713
Planning Total631,016931,298482,713
67.8%
Economic Development237,406391,54160.6%246,622
Economic Development Total237,406391,54160.6%246,622
Community Services439,058524,06183.8%278,097
Parks and Recreation2,664,3393,969,70267.1%2,348,183
Library Services400,236480,16583.4%340,258
Community Services Total3,503,6334,973,92870.4%2,966,538
$19,917,585$27,216,99773.2%$17,548,510
Total Expenditures
Excess (deficiency) of
Revenue over Expenditures$5,510,780$225,540$5,968,898
OTHER FINANCING
SOURCES AND (USES)
Proceeds from lease/CO (net)$0$0$0
Transfer In-Other Funds295,752295,7520
Transfer To-Other Funds(1,700,000)(1,700,000)(3,160,000)
Total Other Sources/(Uses)($1,404,248)($1,404,248)($3,160,000)
Excess (deficiency) of
Revenues/other sources over Exp.$4,106,532($1,178,708)$2,808,898
FUND BALANCE OCT 1$7,985,520
Change in reserved fund balance$0
ENDING FUND BALANCE$6,806,812
fund balance percentage25.01%
CITY OF SOUTHLAKE
1% SALES TAX REPORT
2006-07CollectedBudgetBalance
Budgetto DateBalancePercent
$7,812,000$6,613,279$1,198,72115.34%
FISCALFISCALFISCAL
YEAR% IncYEAR% IncYEAR% Inc
MONTH04-05-Dec05-06-Dec06-07-Dec
412,69813.2%933,496126.2%674,934-27.7%
October
469,81926.5%520,78110.8%619,50919.0%
November
719,32318.3%823,10614.4%1,106,02634.4%
December
435,71623.1%499,82114.7%559,46911.9%
January
410,40928.1%477,01916.2%611,24228.1%
February
639,50926.7%733,39714.7%804,7529.7%
March
491,82218.4%619,82026.0%664,7687.3%
April
490,0738.0%632,95429.2%744,25817.6%
May
628,18326.8%899,05043.1%828,321-7.9%
June
450,4909.4%509,76713.2%0-100.0%
July
519,32733.4%642,63723.7%0-100.0%
August
613,02421.8%773,38626.2%0-100.0%
September
TOTAL$6,280,392$8,065,233$6,613,279
Three Year Revenue Comparison
by Month
1,200,000
1,000,000
800,000
600,000
400,000
200,000
0
FISCAL YEAR 03-04FISCAL YEAR 05-06FISCAL YEAR 06-07
ActualBudgetActualEstimated(budget-est.)%
Month2005-062006-072005-062006-07DifferenceChange
$ 549,186933,496$ 674,934$ 674,934$ 125,748$ 34.51%
October
$ 564,430520,781$ 619,509$ 619,509$ 55,079$ 14.83%
November
$ 892,262823,106$ 1,106,026$ 1,106,026$ 213,764$ 35.16%
December
$ 549,127499,821$ 559,469$ 559,469$ 10,342$ 2.92%
January
$ 522,041477,019$ 611,242$ 611,242$ 89,201$ 27.84%
February
$ 785,370733,397$ 804,752$ 804,752$ 19,383$ 3.84%
March
$ 600,359619,820$ 664,768$ 664,768$ 64,409$ 15.50%
April
$ 613,080632,954$ 744,258$ 744,258$ 131,178$ 28.91%
May
$ 870,822899,050$ 828,321$ 828,321$ (42,501)$ -8.58%
June
$ 493,762509,767$ -$ 493,762$ -$ 0.00%
July
$ 622,460642,637$ -$ 622,460$ -$ 0.00%
August
749,103$ -$ 749,103$ -$ 0.00%
$773,386
September
TOTAL$ 7,812,0008,065,233$ 6,613,279$ 8,478,604$ 666,604$
* Beginning April 2006 includes Grand Avenue sales tax collections per 380 agreement
80% of collections will be distributed to Cooper & Stebbins