Item 3DWATER AND SEWER ENTERPRISE FUND
Comparative Statement of Revenues and Expenses
for the period ended May 31, 2007 and May 31, 2006
(fiscal month 8-66.67%)
AMENDED
Percent
Year to Date2006/07Collected/Year to Date
5/31/07BudgetExpended5/31/2006
REVENUES
Water Sales-residential$4,782,955$10,200,00046.9%$5,456,197
Water Sales-commercial1,530,2562,800,00054.7%1,568,960
Sewer Sales2,535,3473,700,00068.5%2,368,239
Sanitation Sales649,791960,00067.7%661,693
Other utility charges187,889285,50065.8%160,008
Miscellaneous126,874102,500123.8%98,206
100,00095.5%66,730
Interest Income95,467
$18,148,000
Total Revenues$9,908,57954.6%$10,380,033
EXPENSES
Water$4,078,930$9,601,02442.5%$3,635,631
Utility Billing180,167 358,863 50.2%146,617
Sewer820,5811,922,26842.7%874,488
Sanitation427,745754,50056.7%391,092
5,416,19980.7%4,284,645
Debt Service4,370,520
$18,052,854
Total Expenses$9,877,94354.7%$9,332,473
Excess (deficiency) of
$95,146
Revenue over Expenses$30,636$1,047,560
OTHER FINANCING
SOURCES AND (USES)
Transfer In-Other Funds$0$0
Developer Contributions$0$50,000$0
Transfer Out-Other Funds0(275,595)0
Total Other Sources/(Uses)$0($225,595)$0
Excess (deficiency) of
Revenues and other sources
($130,449)$1,047,560
over Expenses$30,636
GENERAL FUND
Statement of Revenues, Expenditures and Changes in Fund Balance
for the period ended May 31, 2007
with comparative actual amounts for the period ended May 31, 2006
(fiscal month 8-66.67%)
AMENDED
Percent
Year to Date2006/07Collected/Year to Date
REVENUES5/31/07BudgetExpended5/31/2006
Ad Valorem Taxes$12,767,038$12,953,27698.6%$11,940,917
Sales Tax5,131,1117,952,00064.5%4,696,171
Franchise Fees1,491,1592,188,72368.1%1,160,930
Fines630,6041,216,00051.9%870,338
Charges for Services548,474729,61275.2%495,470
Permits/Fees1,416,3291,667,96084.9%1,288,863
Miscellaneous404,505484,96683.4%332,390
Interest Income197,168250,00078.9%154,112
$27,442,537
Total Revenues$22,586,38882.3%$20,939,191
EXPENDITURES
City Secretary$191,369$351,92054.4%$165,253
Human Resources231,892382,21460.7%226,624
City Manager316,773585,75254.1%296,883
Support Services2,065,1903,778,31054.7%1,911,976
General Government Total2,805,2245,098,19655.0%2,600,736
Finance638,437965,86466.1%561,085
Municipal Court333,614534,08962.5%263,107
Municipal Court-Teen Court71,716118,22460.7%40,562
Finance Total1,043,7671,618,17764.5%864,754
Fire 2,214,3573,802,93558.2%1,975,031
Police3,866,3855,600,22269.0%2,968,200
Public Safety Support668,9891,515,60944.1%878,016
Building442,268719,37061.5%513,791
Public Safety Total7,191,99911,638,13661.8%6,335,038
Streets/Drainage891,0621,589,73256.1%691,682
Public Works Administration553,471975,98956.7%490,829
Public Works Total1,444,5332,565,72156.3%1,182,511
Planning500,529931,29853.7%379,227
Planning Total500,529931,298379,227
53.7%
Economic Development188,718391,54148.2%186,660
Economic Development Total188,718391,54148.2%186,660
Community Services338,130524,06164.5%221,092
Parks and Recreation1,992,2033,969,70250.2%1,817,425
Library Services325,918480,16567.9%270,590
Community Services Total2,656,2514,973,92853.4%2,309,107
$15,831,021$27,216,99758.2%$13,858,033
Total Expenditures
Excess (deficiency) of
Revenue over Expenditures$6,755,367$225,540$7,081,158
OTHER FINANCING
SOURCES AND (USES)
Proceeds from lease/CO (net)$0$0$0
Transfer In-Other Funds0295,7520
Transfer To-Other Funds(1,700,000)(3,160,000)
Total Other Sources/(Uses)$0($1,404,248)($3,160,000)
Excess (deficiency) of
Revenues/other sources over Exp.$6,755,367($1,178,708)$3,921,158
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$5,040,700$2,771,30035.47%
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%0-100.0%
May
628,18326.8%899,05043.1%0-100.0%
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$5,040,700
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,185.6933,496$ 674,934$ 674,934$ 125,748$ 34.51%
October
$ 564,429.9520,781$ 619,509$ 619,509$ 55,079$ 14.83%
November
$ 892,261.8823,106$ 1,106,026$ 1,106,026$ 213,764$ 35.16%
December
$ 549,127.3499,821$ 559,469$ 559,469$ 10,342$ 2.92%
January
$ 522,041.1477,019$ 611,242$ 611,242$ 89,201$ 27.84%
February
$ 785,369.5733,397$ 804,752$ 804,752$ 19,383$ 3.84%
March
$ 600,358.5619,820$ 664,768$ 664,768$ 64,409$ 15.50%
April
$ 613,080.2632,954$ -$ 613,080$ -$ 0.00%
May
$ 870,821.8899,050$ -$ 870,822$ -$ 0.00%
June
$ 493,761.8509,767$ -$ 493,762$ -$ 0.00%
July
$ 622,459.6642,637$ -$ 622,460$ -$ 0.00%
August
749,102.9$ -$ 749,103$ -$ 0.00%
$773,386
September
TOTAL$ 7,812,0008,065,233$ 5,040,700$ 8,389,926$ 577,926$
* Beginning April 2006 includes Grand Avenue sales tax collections per 380 agreement
80% of collections will be distributed to Cooper & Stebbins