The City of Lucas

Memo

To:        Mayor and Council

From:    Dedra Bates

Date:     12/9/2003

Re:        Overview of Financial for October 2003

·        Bank reconciliation – The ending balance of $1,042,698.53 is in our general operating account

·        Financial statements for fund 11,  51 AND 59 - as  of  October 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             727,259.56             0.00             0.00     0.00       727,259.56

OTHER TAXES                175,000.00        19,046.70        19,046.70    10.88       155,953.30

FINES & FORFEITURES         29,850.00           290.00           290.00     0.97        29,560.00

LICENSES & PERMITS         150,000.00        14,711.20        14,711.20     9.81       135,288.80

FIRE DEPARTMENT REVENUE      7,500.00           604.40           604.40     8.06         6,895.60

FEES AND SERVICE CHARGES     3,000.00            35.55            35.55     1.19         2,964.45

TRASH SERVICE              210,227.88        17,999.80        17,999.80     8.56       192,228.08

INTERGOVERNMENTAL                0.00             0.00             0.00     0.00             0.00

MISCELLANEOUS REVENUES      32,400.00        16,325.11        16,325.11    50.39        16,074.89

 

TOTAL REVENUE            1,335,237.44        69,012.76        69,012.76     5.17     1,266,224.68

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

 

EXPENDITURE SUMMARY

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

 

CITY COUNCIL                21,300.00         1,050.00         1,050.00     4.93        20,250.00

ADMINISTRATION             151,794.84        10,538.41        10,538.41     6.94       141,256.43

PUBLIC WORKS               140,900.58         7,938.17         7,938.17     5.63       132,962.41

PARKS DEPARTMENT            59,839.80         4,969.54         4,969.54     8.30        54,870.26

FIRE                       155,720.00         6,247.84         6,247.84     4.01       149,472.16

NON-DEPART. EXPENDITURES   559,678.44       132,922.31       132,922.31    23.75       426,756.13

 

TOTAL EXPENDITURES       1,089,233.66       163,666.27       163,666.27    15.03       925,567.39

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

 

EXCESS REVS/EXPENDS        246,003.78   (    94,653.51)  (    94,653.51)   38.48-      340,657.29

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

 

 

 

 

 

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

ACCT#    ACCOUNT NAME        BUDGET           PERIOD           ACTUAL   BUDGET         BALANCE

__________________________________________________________________________________________________

REVENUE SUMMARY

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

FEES AND SERVICE CHARGES 1,002,800.00       105,307.14       105,307.14    10.50       897,492.86

MISCELLANEOUS REVENUES       1,700.00             0.00             0.00     0.00         1,700.00

 

TOTAL REVENUE            1,004,500.00       105,307.14       105,307.14    10.48       899,192.86

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

EXPENDITURE SUMMARY

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

WATER UTILITIES            664,739.69       290,589.86       290,589.86    43.71       374,149.83

DEBT SERVICES              441,951.25        32,272.00        32,272.00     7.30       409,679.25

NON-DEPART. EXPENDS              0.00             0.00             0.00     0.00             0.00

 

TOTAL EXPENDITURES       1,106,690.94       322,861.86       322,861.86    29.17       783,829.08

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

 

EXCESS REVES/EXPENDS   (   102,190.94)  (   217,554.72)  (   217,554.72)  212.89       115,363.78

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

59 -DEBT SERVICES FUND

                               ANNUAL          CURRENT            Y-T-D     % OF         BUDGET

ACCT#    ACCOUNT NAME          BUDGET           PERIOD           ACTUAL   BUDGET         BALANCE

__________________________________________________________________________________________________

REVENUE SUMMARY

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

PROPERTY TAXES            393,614.00         7,142.52         7,142.52     1.81       386,471.48

MISCELLANEOUS REVENUES          0.00             0.00             0.00     0.00             0.00

 

TOTAL REVENUE             393,614.00         7,142.52         7,142.52     1.81       386,471.48

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

EXPENDITURE SUMMARY

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

DEBT SERVICES             392,564.00             0.00             0.00     0.00       392,564.00

 

TOTAL EXPENDITURES        392,564.00             0.00             0.00     0.00       392,564.00

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

 

EXCESS REV/EXPENDS          1,050.00         7,142.52         7,142.52   680.24   (     6,092.52)

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

·         Logic- As of October 31st the ending balance for General Fund was $290,682.80, Water 2002 $2,084,708.01 and Projects 2002 was $2,522,779.41.

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

o        Water impact fee  $ 130,212.48

o        Road impact fee 1 $ 54,76704

o        Road impact fee 2 $274,477.95

o        Road Impact fee 3 $ 145,527.16

o        Water fund reserves $ 74,673.83

o        Fire department donations fund $ 46,890.03

o        Road Impact fee 4 $ 232,265.34

o        General Fund $ 564,442.39