Item 3CWATER AND SEWER ENTERPRISE FUND
Comparative Statement of Revenues and Expenses
for the period ended August 31, 2007 and August 31, 2006
(fiscal month 11-91.67%)
AMENDED
Percent
Year to Date2006/07Collected/Year to Date
8/31/07BudgetExpended8/31/2006
REVENUES
Water Sales-residential$6,776,782$10,200,00066.4%$8,855,005
Water Sales-commercial2,166,9032,800,00077.4%2,296,455
Sewer Sales3,537,5483,700,00095.6%3,148,729
Sanitation Sales931,987960,00097.1%895,064
Other utility charges259,948285,50091.1%226,433
Miscellaneous165,272102,500161.2%169,144
100,000252.6%89,748
Interest Income252,553
$18,148,000
Total Revenues$14,090,99377.6%$15,680,578
EXPENSES
Water$5,872,701$9,601,02461.2%$5,295,788
Utility Billing251,105 358,863 70.0%200,724
Sewer1,090,1041,922,26856.7%1,036,703
Sanitation637,574754,50084.5%601,051
5,416,199100.0%5,392,155
Debt Service5,416,199
$18,052,854
Total Expenses$13,267,68373.5%$12,526,421
Excess (deficiency) of
$95,146
Revenue over Expenses$823,310$3,154,157
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)$3,154,157
over Expenses$547,715
GENERAL FUND
Statement of Revenues, Expenditures and Changes in Fund Balance
for the period ended August 31, 2007
with comparative actual amounts for the period ended August 31, 2006
(fiscal month 11-91.67%)
AMENDED
Percent
Year to Date2006/07Collected/Year to Date
REVENUES8/31/07BudgetExpended8/31/2006
Ad Valorem Taxes$13,114,442$12,953,276101.2%$12,293,086
Sales Tax7,475,4127,952,00094.0%6,778,762
Franchise Fees2,070,7932,188,72394.6%1,583,152
Fines914,9501,216,00075.2%1,155,805
Charges for Services768,656729,612105.4%715,250
Permits/Fees1,916,5741,667,960114.9%1,644,466
Miscellaneous641,421484,966132.3%580,217
Interest Income365,745250,000146.3%223,726
$27,442,537
Total Revenues$27,267,99399.4%$24,974,464
EXPENDITURES
City Secretary$267,348$351,92076.0%$237,474
Human Resources343,621382,21489.9%298,615
City Manager527,127585,75290.0%338,822
Support Services2,851,5703,778,31075.5%2,542,542
General Government Total3,989,6665,098,19678.3%3,417,453
Finance855,610965,86488.6%751,621
Municipal Court488,624534,08991.5%378,748
Municipal Court-Teen Court100,946118,22485.4%56,361
Finance Total1,445,1801,618,17789.3%1,186,730
Fire 3,157,8843,802,93583.0%2,691,183
Police4,563,6425,600,22281.5%3,991,829
Public Safety Support1,512,7751,515,60999.8%1,247,710
Building613,543719,37085.3%696,417
Public Safety Total9,847,84411,638,13684.6%8,627,139
Streets/Drainage1,369,8791,589,73286.2%1,106,527
Public Works Administration812,365975,98983.2%646,576
Public Works Total2,182,2442,565,72185.1%1,753,103
Planning720,593931,29877.4%531,072
Planning Total720,593931,298531,072
77.4%
Economic Development268,749391,54168.6%269,616
Economic Development Total268,749391,54168.6%269,616
Community Services434,307524,06182.9%232,228
Parks and Recreation3,215,0293,969,70281.0%2,592,157
Library Services450,676480,16593.9%374,059
Community Services Total4,100,0124,973,92882.4%3,198,444
$22,554,288$27,216,99782.9%$18,983,557
Total Expenditures
Excess (deficiency) of
Revenue over Expenditures$4,713,705$225,540$5,990,907
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.$3,309,457($1,178,708)$2,830,907
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$7,328,621$483,3796.19%
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%715,34240.3%
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$7,328,621
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$ 715,342$ 715,342$ 221,580$ 53.79%
July
$ 622,460642,637$ -$ 622,460$ -$ 0.00%
August
749,103$ -$ 749,103$ -$ 0.00%
$773,386
September
TOTAL$ 7,812,0008,065,233$ 7,328,621$ 8,700,184$ 888,184$
* Beginning April 2006 includes Grand Avenue sales tax collections per 380 agreement
80% of collections will be distributed to Cooper & Stebbins