09-A-1 Quarterly Financial Rpt KEY OPERATING FUNDS
DECEMBER 3t, 2002
WW/SS Tax & Rev. Cert. of Ob.
2000 Series 2000 Series 2002 Series
General Fund* Water & Sewer Construction Construction Construction
Cash & Investments $4,188,382.13 -$1,583,435.52 $7,286,433.55 $3,593,691.31 $5,829,947.31
2 months operating $ $3,578,293.00
3 months operating $ $5,367,440.00
Bond Ord. requirement $1,263,264.00
DECEMBER 31, 2001
WW/SS Tax & Rev. Cert. of Ob.
2000 Series 2000 Series 2002 Series
General Fund Water & Sewer Construction Construction Construction
Cash & Investments $2,783,965.26 -$1,599,237.82 $9,838,332.52 $4,173,865.82 $0.00
2 months operating $ $3,384,898.00
3 months operating $ $5,077,348.00
Bond Ord. requirement $1,236,460.00
* Increased cash balance due to one time settle up payment from TXU, timing differences in other
franchise payments, increased property tax collections from larger tax roll, reimbursements
received on grants, and increased sales tax collections.
KEY REVENUES: BUDGET VERSES ACTUAL
DECEMBER 31, 2002
Current Property Taxes-O&M
Budget YTD Actual % Collected
Current Year $5,662,968.00 $1,564,350.86 27.62
Prior Year $5,077,866.00 $1,420,525.78 27.97
Sales Taxes: 1.25 %
Budget YTD Actual % Collected
Current Year $4,490,065.00 $1,200,348.76 26.73
Prior Year $5,000,000.00 $1,049,008.82 20.98
Franchise Type Fees*
Budget Y'rD Actual % Collected
Current Year $2,986,430.00 $633,730.53 21.22
Prior Year $2,950,073.00 $186,421.22 6.32
Sewer Charges
Budget YTD Actual % Collected
Current Year $4,372,792.00 $975,251.28 22.3
Prior Year $4,060,000.00 $947,927.02 23.35
Water Sales
Budget YTD Actual % Collected
Current Year $6,451,618.00 $1,592,752.90 24.68
Prior Year $6,268,250.00 $1,428,532.58 22.79
* Franchise fee revenue is larger than normal because of a one time
settleup payment from TXU and timing differences on normal payments
from SW Bell and TXU Gas.
DEPARTMENTAL EXPENDITURE SUMMARY
DECEMBER 31, 2002 PRIOR YEAR
Budget YTD Actual % Expended Budget YTD Actual % Expended
city Council* $808,238.00 $648,005.46 80.18% $1,438,538.00 $419,439.74 29.15%
City Manager $237,985.00 $67,270.24 28.27% $236,722.00 $64,481.83 27.24%
City Attorney $404,055.00 $95,294.36 23.58% $369,878.00 $95,810.86 25.90%
Municipal Court $220,661.00 $56,209.56 25.47% $22`1,69`1.00 $59,458.83 28.62%
City Clerk $132,009.00 $41,074.13 31.11% $120,577.00 $39,032.39 32.37%
Finance $452,983.00 $132,708.87 29.30% $481,021.00 $`116,235.01 24.t6%
Police $4,929,323.00 $`1,324,082.84 28.88% $5,088,32;'.00 $1,295,141.48 25.56%
Fire $3,286,608.00 $811,031.92 24.88% $3,3`18,880.00 $888,778.70 26.78%
Community Dev. $535,024.00 $126,127.37 23.57% $594,543.00 $139,611.00 23.48%
Engineering $445,977.00 $124,578.49 27.93% $497,183.00 $124,275.56 25.00%
Public Works $256,543.00 $80,106.93 31.23% $212,875.00 $54,554.53 25.63%
Parks, Rec, ROW $2,675,588.00 $259,855.13 9.7'1% $1,226,253.00 $277,446.64 22.63%
Sanitation $'1,436,741.00 $3'1'1,35'1.86 21.67% $1,397,189.00 $3'10,067.'19 22.'19%
Streets $'1,743,664.00 $406,102.80 23.29% $1,528,384.00 $443,856.46 27.26%
Traffic&Lighting $39'1,001.00 $5'1,707.57 13.22% $385,748.00 $46,952.'18 '12.'17%
Garage $305,528.00 $81,208.90 26.58% $42'1,388.00 $77,243.64 '18.33%
EMS $1,743,999.00 $5'15,801.79 29.56% $'1,846,564.00 $479,443.05 25.96%
(:;ox Field Airport $293,273.00 $30,914.76 '10.54% $165,606.00 $27,938.89 '16.87%
Paris Band $18,202.00 $8.00 0.04% $20,670.00 $'16.22 0.08%
Library $1,002,338.00 $202,257.14 20.18% $768,354.00 $178,073.10 23.18%
Debt $1,352,240.00 $0.00 0.00% $662,260.00 $0.00 0.00%
Contingency $150,000.00 $0.00 0.00% $150,000.00 $200.96 0.13%
$22,822,000.00 $5,366,498.12 23.51% $21,230,651.00 $5,138,058.26 24.20%
Warehouse $122,513.00 $30,663.12 25.03% $116,554.00 $27,872.73 23.91%
Billing & Collection $1,648,266.00 $137,037.46 8.31% $1,672,421.00 $149,679.75 8.95%
Water Production $2,462,529.00 $338,728.89 13.81% $2,496,811.00 $399,872.96 16.02%
Water Distribution $924,045.00 $285,052.67 30.85% $1,011,562.00 $321,042.35 31.74%
Sewer Maintenance $479,461.00 $104,117.90 21.72% $816,638.00 $102,424.64 16.61%
Waste Wtr. Treatment $1,833,259.00 $370,465.49 20.21% $1,761,639.00 $418,182.51 23.74%
Uftstations $323,475.00 $69,978.90 21.63% $340,682.00 $79,490.92 23.33%
Debt $3,815,250.00 $0.00 0.00% $2,825,010.00 $0.00 0.00%
$11,598,798.00 $1,336,044.43 11.52% $10,841,317.00 $1,498,565.86 13.82%
* Council budget is distorted by sales tax transfers to PEDC. Adjusting for this activity,
Council expenses would be $407,935.71 or 50.47% of budget. Also skewing their expense
percentage is that contributions to non-profit organizations and payments on work on the
depot have already been made.