The City of Lucas

Memo

To:        Mayor and Council

From:    Dedra Bates

Date:     10/31/2003

Re:        Overview of July 2003

·          Bank reconciliation – The ending balance of $814,349.45 is in our general operating account

·          Financial statements for fund 11,  51 AND 59 - as  of  July 2003

 

11 -GENERAL FUND

 

 

11 -GENERAL FUND

FINANCIAL SUMMARY

 

                            ANNUAL          CURRENT            Y-T-D     % OF         BUDGET

ACCT#    ACCOUNT NAME       BUDGET           PERIOD           ACTUAL   BUDGET         BALANCE

________________________________________________________________________________________________

 

REVENUE SUMMARY

----------------

 

PROPERTY TAXES          620,669.00         5,995.51       638,722.57   102.91   (    18,053.57)

OTHER TAXES             115,000.00        17,277.37       205,586.08   178.77   (    90,586.08)

FINES & FORFEITURES         200.00            84.00         4,216.66   108.33   (     4,016.66)

LICENSES & PERMITS      175,000.00        22,512.10       242,279.58   138.45   (    67,279.58)

FIRE DEPARTMENT REVENUE  12,500.00         7,540.00        19,224.53   153.80   (     6,724.53)

FEES AND SERVICE CHARGES  4,500.00           689.45         3,536.86    78.60           963.14

TRASH SERVICE                 0.00        17,380.57       157,507.09     0.00   (   157,507.09)

INTERGOVERNMENTAL             0.00             0.00            14.00     0.00   (        14.00)

MISCELLANEOUS REVENUES   45,000.00         3,161.34       124,550.43   276.78   (    79,550.43)

 

TOTAL REVENUE           972,869.00        74,640.34     1,395,637.80   143.46   (   422,768.80)

                     ==============   ==============   ==============   ======   ==============

 

 

EXPENDITURE SUMMARY

--------------------

 

CITY COUNCIL             11,800.00           700.00         8,510.12    72.12         3,289.88

ADMINISTRATION          170,596.97        15,163.83       115,380.87    67.63        55,216.10

PUBLIC WORKS            142,781.39        13,449.20       100,625.54    70.48        42,155.85

FIRE                    141,660.00         8,546.53        98,874.15    69.80        42,785.85

NON-DEPART.EXPENDS      715,760.00       215,441.05     1,333,353.65   186.29   (   617,593.65)

 

TOTAL EXPENDITURES    1,182,598.36       253,300.61     1,656,744.33   140.09   (   474,145.97)

                    ==============   ==============   ==============   ======   ==============

 

EXCESS REVES/EXPENS(   209,729.36)  (   178,660.27)  (   261,106.53)  124.50        51,377.17

                    ==============   ==============   ==============   ======   ==============

 

 

 

 

51 -WATER              ANNUAL          CURRENT            Y-T-D     % OF         BUDGET

ACCT#    ACCOUNT NAME        BUDGET           PERIOD           ACTUAL   BUDGET         BALANCE

__________________________________________________________________________________________________

REVENUE SUMMARY

----------------

FEES AND SERVICE CHARGES    950,300.00       112,828.16       897,784.56    94.47        52,515.44

MISCELLANEOUS REVENUES        1,700.00             0.00             0.00     0.00         1,700.00

 

TOTAL REVENUE               952,000.00       112,828.16       897,784.56    94.31        54,215.44

                         =============   ==============   ==============   ======   ==============

EXPENDITURE SUMMARY

--------------------

WATER UTILITIES            278,014.51        30,647.68       265,208.22    95.39        12,806.29

DEBT SERVICES              451,029.00             0.00       555,911.00   123.25   (   104,882.00)

 

TOTAL EXPENDITURES         729,043.51        30,647.68       821,119.22   112.63   (    92,075.71)

                        ==============   ==============   ==============   ======   ==============

 

EXCESS REVS/EXPENDS        222,956.49        82,180.48        76,665.34    34.39       146,291.15

                        ==============   ==============   ==============   ======   ==============                       

 

59 -DEBT SERVICES FUND

                               ANNUAL          CURRENT            Y-T-D     % OF         BUDGET

ACCT#    ACCOUNT NAME          BUDGET           PERIOD           ACTUAL   BUDGET         BALANCE

__________________________________________________________________________________________________

REVENUE SUMMARY

----------------

PROPERTY TAXES             400,000.00         3,645.77       388,460.07    97.12        11,539.93

MISCELLANEOUS REVENUES           0.00             0.00             0.00     0.00             0.00

 

TOTAL REVENUE              400,000.00         3,645.77       388,460.07    97.12        11,539.93

                        ==============   ==============   ==============   ======   ==============

 

EXPENDITURE SUMMARY

--------------------

DEBT SERVICES              391,714.00             0.00       296,744.17    75.76        94,969.83

 

TOTAL EXPENDITURES         391,714.00             0.00       296,744.17    75.76        94,969.83

                       ==============   ==============   ==============   ======   ==============

 

EXCESS REVES/EXPENDS         8,286.00         3,645.77        91,715.90   106.88   (    83,429.90)

                       ==============   ==============   ==============   ======   ==============

 

·         Logic- As of July 31st the ending balance for GF was $289,949.43. As of July 31st the ending balance for H2O was $2,529,086.62. As of July 31st he ending balance for PJ02 was $3,029,349.94.

·         Lone Star- As of  July 31st the ending balance was

o        Water impact fee  $ 112,520.57

o        Road impact fee 1 $ 52,833.49

o        Road impact fee 2 $258,767.64

o        Road Impact fee 3 $ 140,821.64

o        Water fund reserves $ 74,488.07

o        Fire department donations fund $ 46,773.38

o        Road Impact fee 4 $ 226,695.01

o        General Fund $ 563,038.24