The City of Lucas

Memo

To:        Mayor and Council

From:    Dedra Bates

Date:     7/28/2003

Re:        Overview of June 2003

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

·          Financial statements for fund 11,  51 AND 59 - as  of  June 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         3,422.59       630,012.83   101.51   (     9,343.83)

OTHER TAXES              115,000.00        10,330.02       188,308.71   163.75   (    73,308.71)

FINES & FORFEITURES          200.00           243.00         4,132.66    66.33   (     3,932.66)

LICENSES & PERMITS       175,000.00        10,533.70       219,767.48   125.58   (    44,767.48)

FIRE DEPARTMENT REVENUE   12,500.00         6,027.40        11,684.53    93.48           815.47

FEES AND SERVICE CHARGES   4,500.00           248.95         2,847.41    63.28         1,652.59

TRASH SERVICE                  0.00        17,353.82       140,126.52     0.00   (   140,126.52)

INTERGOVERNMENTAL              0.00             0.00             3.00     0.00   (         3.00)

MISCELLANEOUS REVENUES    45,000.00         4,257.37       130,453.39   289.90   (    85,453.39)

 

TOTAL REVENUE            972,869.00        52,416.85     1,327,336.53   136.44   (   354,467.53)

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

 

 

EXPENDITURE SUMMARY

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

CITY COUNCIL              11,800.00           783.89         7,810.12    66.19         3,989.88

ADMINISTRATION           170,596.97        12,032.90        99,806.94    58.50        70,790.03

PUBLIC WORKS             142,781.39        11,107.50        82,176.34    57.55        60,605.05

FIRE                     141,660.00         2,588.26        90,547.62    63.92        51,112.38

NON-DEPART.EXPENDITURES  715,760.00       118,133.00     1,070,505.33   149.56   (   354,745.33)

 

TOTAL EXPENDITURES     1,182,598.36       144,645.55     1,350,846.35   114.23   (   168,247.99)

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

 

EXCESS REVS/EXPENDS  (   209,729.36)  (    92,228.70)  (    23,509.82)   11.21   (   186,219.54)

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

 

 

 

 

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       116,252.66       785,106.08    82.62       165,193.92

MISCELLANEOUS REVENUES       1,700.00             0.00             0.00     0.00         1,700.00

 

TOTAL REVENUE              952,000.00       116,252.66       785,106.08    82.47       166,893.92

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

EXPENDITURE SUMMARY

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

WATER UTILITIES            278,014.51        24,563.37       253,525.54    91.19        24,488.97

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

 

TOTAL EXPENDITURES         729,043.51        25,626.87       809,436.54   111.03   (    80,393.03)

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

 

EXCESS REVS/EXPENDS        222,956.49        90,625.79   (    24,330.46)   10.91-      247,286.95

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

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         2,073.98       383,162.45    95.79        16,837.55

 

TOTAL REVENUE               400,000.00         2,073.98       383,162.45    95.79        16,837.55

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

EXPENDITURE SUMMARY

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

DEBT SERVICES               391,714.00       172,546.25       296,744.17    75.76        94,969.83

 

TOTAL EXPENDITURES          391,714.00       172,546.25       296,744.17    75.76        94,969.83

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

 

EXCESS REVS/EXPENDS          8,286.00   (   170,472.27)       86,418.28    42.94   (    78,132.28)

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

 

·         Logic- As of June 31st the ending balance for GF was $289,689.73. As of June 31st the ending balance for H2O was $2,526,821.40. As of June 31st he ending balance for PJ02 was $3,026,636.64.

·         Lone Star- As of  June 31stthe ending balance was

o        Water impact fee  $ 112,425.25

o        Road impact fee 1 $ 52,788.73

o        Road impact fee 2 $258,548.42

o        Road Impact fee 3 $ 140,702.34

o        Water fund reserves $ 74,424.97

o        Fire department donations fund $ 46,733.75

o        Road Impact fee 4 $ 226,502.96

o        General Fund $ 562,561.25