The City of Lucas

Memo

To:        Mayor and Council

From:    Dedra Bates

Date:     10/31/2003

Re:        Overview of Financial for August 2003

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

·          Financial statements for fund 11,  51 AND 59 - as  of  August 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             640,000.00         1,268.82       639,991.39   100.00             8.61

OTHER TAXES                220,000.00        12,640.71       218,226.79    99.19         1,773.21

FINES & FORFEITURES          5,100.00           898.34         5,115.00   100.29   (        15.00)

LICENSES & PERMITS         265,000.00        20,840.00       263,119.58    99.29         1,880.42

FIRE DEPARTMENT REVENUE     21,000.00         2,353.85        21,578.38   102.75   (       578.38)

FEES AND SERVICE CHARGES     4,500.00           449.50         3,986.36    88.59           513.64

TRASH SERVICE              175,000.00        17,840.01       175,347.10   100.20   (       347.10)

INTERGOVERNMENTAL               14.00             0.00            14.00   100.00             0.00

MISCELLANEOUS REVENUES     133,000.00         1,363.22       125,913.65    94.67         7,086.35

 

TOTAL REVENUE            1,463,614.00        57,654.45     1,453,292.25    99.29        10,321.75

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

 

 

EXPENDITURE SUMMARY

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

 

CITY COUNCIL                11,800.00            33.04         8,543.16    72.40         3,256.84

ADMINISTRATION             170,596.97        10,012.16       125,393.03    73.50        45,203.94

PUBLIC WORKS               142,781.39        10,983.75       111,609.29    78.17        31,172.10

PARKS DEPARTMENT                 0.00             0.00             0.00     0.00             0.00

FIRE                       141,660.00        28,366.54       127,240.69    89.82        14,419.31

NON-DEPART. EXPENDITURES   991,768.05       199,461.88     1,532,815.53   154.55   (   541,047.48)

 

TOTAL EXPENDITURES       1,458,606.41       248,857.37     1,905,601.70   130.65   (   446,995.29)

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

 

EXCESS REVS/EXPENDS          5,007.59   (   191,202.92)  (   452,309.45)   32.48-      457,317.04

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

 

 

 

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

ACCT#    ACCOUNT NAME        BUDGET           PERIOD           ACTUAL   BUDGET         BALANCE

__________________________________________________________________________________________________

REVENUE SUMMARY

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

FEES AND SERVICE CHARGES  1,120,000.00       221,794.78     1,119,579.34    99.96           420.66

MISCELLANEOUS REVENUES            0.00             0.00             0.00     0.00             0.00

 

TOTAL REVENUE             1,120,000.00       221,794.78     1,119,579.34    99.96           420.66

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

EXPENDITURE SUMMARY

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

WATER UTILITIES            323,223.20       274,014.39       539,222.61   166.83   (   215,999.41)

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

NON-DEPART. EXPENDS              0.00             0.00             0.00     0.00             0.00

 

TOTAL EXPENDITURES         774,252.20       274,014.39     1,095,133.61   141.44   (   320,881.41)

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

EXCESS REVS/EXPENDS        345,747.80   (    52,219.61)       24,445.73     7.07       321,302.07

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

 

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           772.20       389,232.27    97.31        10,767.73

MISCELLANEOUS REVENUES            0.00             0.00             0.00     0.00             0.00

 

TOTAL REVENUE               400,000.00           772.20       389,232.27    97.31        10,767.73

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

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 REVS/EXPENDS          8,286.00           772.20        92,488.10   116.20   (    84,202.10)

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

 

·         Logic- As of August 31st the ending balance for General Fund was $290,196.69, Water 2002 $2,531,243.31, and Projects 2002 was $3,031,933.24.

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

o        Water impact fee  $ 112,616.09

o        Road impact fee 1 $ 52,878.34

o        Road impact fee 2 $258,987.32

o        Road Impact fee 3 $ 140,941.19

o        Water fund reserves $ 74,551.31

o        Fire department donations fund $ 46,813.09

o        Road Impact fee 4 $ 226,887.46

o        General Fund $ 563,516.22