HomeMy WebLinkAboutItem 4.4 Financial Report 08-31-1992 CITY OF DUBLIN
AGENDA STATEMENT
MEETING DATE: September 14,1992
>UBJECT :Financial reports for the month of August 1992
Prepared by Phillip S. Molina
17XHIBITS ATTACHED :Balance Sheets and Income Statements
RECOMMENDATION(S) :Accept, review and file the financial reports
17INANCIAL STATEMENT:(See reports)
DESCRIPTION: The first two months of this fiscal year have not
generated positive revenue results in the City's General Fund. The
total revenue received this year through August 31st is down from the
amount received last year. The information below shows the types of
revenue within the General Fund and compares each to the amounts
received last year at this time:
-fiscal year-
92-93 91-92 <loss>
+gain
Property Tax 74,231 0 74,231
Sales Tax 631,601 877,139 (245,538)
Real Property Transfer 4,375 14,783 (10,408)
Transient Occu Tax 22,216 23,284 (1,068)
Franchise Tax 22,151 20,313 1,838
Licenses & Permits 28,006 32,071 (4,065)
Fines & Forfeitures 2,810 3,331 (521)
Uses Of Assets 41,027 70,529 (29,502)
Intergovernmental 0 170,474 (170,474)
Charges For Services 102,396 76,798 25,598
Other 1,531 21,569 (20,038)
930,344 1,310,291
The result is an overall revenue performance that is $379,947 below
the amount received last year at this time. Furthermore, the property
tax revenue account does not include any adjustments for the amount
that will be transferred to the schools as a result of the State's
budget. Recent information from Hinderliter and De Llamas, the sales
tax auditing firm, indicates that sales tax revenues may be on the
upswing for Dublin, though the sales tax allocation received from the
State did not yet reflect that position.
CITY CLERK
♦ FILE t� C
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF AUGUST 1992
Prepared by
The Finance Department
BGL102 CITY OF DUBLIN PAGE 1 _
9/03/92 BALANCE SHEET 13.46.01
FOR THE
PERIOD 7/92 THROUGH 8/92
GENERAL SPECIAL SPECIAL CAPITAL
REVENUE REVENUE ASSESSMENT IMPROVEMENT
FUNDS FUNDS FUNDS FUNDS
ASSETS
CASH 425038.22- 374663.97- 1107668.11 322703.52-
CASH WITH FISCAL AGENT 117500.00
UNA.MORTIZED BOND DISCOUNT 937.50
INVESTMENTS A' 15647093.31 150356.44 1101722.13
RECEIVA.BLES:hXES
ACCOUNTS (NET)
INTEREST 41651.34- 41651.34
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS 528367.92
INVENTORY AT CAST
PREPAID ITEMS 3217.12
FIXED ASSETS
AMO-ITS TO BE PROVIDED 2232500.00
TOTAL ASSETS 15712926.29 333012.63- 3608024.55 779018.61
L•IAB, FND BAL,, RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPMNT 65091.22
DEPOSITS FOR AB1600 FEES 96230.04-
DEPOSITS OTHERS 167292.27- 3125.00-
PAY.ABLES:A000IINTS 317.82 24.00-
INTEREST
PAYROLL 21077.12-
DUE TO OTHERS 526867.92- 1500.00-
DEBT INSTRUMENTS PAYABLE 2845000.00-
TOTAL !LIABILTIES 122960.35- 526867.92- 2849649.00- 96230.04-
FUND BALANCES 15589965.94- 859880.55 758375.55- 682788.57-
TOTAL :FUND EQUITY 15589965.94- 859880.55 758375.55- 682788.57-
TOTAL LIAB,FNI) BA.L, RETD EARNS 15712926.29- 333012.63 3608024.55- 779018.61-
BGL102 CITY OF DUBLIN PAGE 1
9/03/92' BALANCE SHEET 13.46.18
FOR THE
PERIOD 7/92 THROUGH 8/92
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG - -
SERVICE FUNDS GROUP OF TERM DEBT
FUND ACCOUNTS ACCOUNT GROUP
ASSETS
CASH 239322.18 554189.14-
CASH WITH FISCAL AGENT 1720985.93
UNAMORTIZED BOND DISCOUNT
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS (NET)
I1TEREST 64500.15
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 1724.03
FIXED ASSETS 110488.69 21420859.73 459282.53
AMOUNTS TO BE PROVIDED 2285000.00
TOTAL ASSETS 349810.87 22653880.70 459282.53 2285000.00
LI3-B, FND BAL, RETHD EARNINGS
DEPOSITS FOR PRIVATE DEVELPMNiT
DEPOSITS OTHERS
PAYABLES:A000UNTS 457.68-
INTEREST
PAYROLL
DUE TO OTHERS
DEBT INSTRUMENTS PAYABLE 16556062.08- 2285000.00-
TOTAL LIABILITIES 457.68- 16556062.08- 2285000.00-
FLRID BALANCE 233355.01- 994695.62-
CONTRIBUTIONS 115998.18- 5103123.00-
INVESTMENTS III FIXED ASSETS 459282.53-
RETAINED EARNINGS
TOTAL FUND EQUITY 349353.19- 6097818.62- 459282.53-
TOTAL LIAB,FllD BAL, RETD EARNS 349810.87- 22653880.70- 459282.53- 2285000.00-
BC-L104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
9/03/92 REVENUES VERSUS EXPENDITURE 13.21.45
FOR THE
PERIOD 7/92 THROUGH 8/92
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
PROPERTY TAXES 4035400.00- 74231.06- 1.8 3961168.94-
SALES TAX 5400000.00- 631601.00- 11.7 4768399.00-
REAL PROPERTY TRANSFERS 66000.00- 4375.79- 6.6 61624.21-
TRANSIENT OCCUPANCY TAX 96000.00- 22216.00- 23.1 73784.00-
FRA.IICHISE TAXES 451250.00- 22151.62- 4.9 429098.38-
LICENSES & PERMITS 225200.00- 28006.76- 12.4 197193.24-
FINES & FORFEITURES 22000.00- 2810.46- 12.8 19189.54-
USES OF MONEY MID PROPERTY 1008450.00- 41027.50- 4.1 967422.50-
INTERNGOVERNNENTAL FROM STATE 880750.00- .00 880750.00-
CHARGES FOR SERVICES 836136.00- 102396.76- 12.2 733739.24-
OTHER SOURCES OF REVENUE 297205.00- 1531.47- .5 295673.53-
TOTAL REVENUE 13318391.00- 930348.42- 7.0 12388042.58-
*******EXPEf[DITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 86365.00 .00 86365.00
CITY COUNCIL 1010 103574.00 9083.86 8.8 94490.14
CITY MANAGER 1020 478477.00 66126.20 13.8 412350.80
CITY ATTORNEY 1030 174454.00 23423.66 13.4 151030.34
FINANCE DEPARTMENT 1040 241796.00 29700.49 12.3 212095.51
DATA PROCESSING (FIN) 1045 14850.00 95.00 .6 14755.00
BUILDING MANAGEMENT 1050 338187.00 22260.21 6.6 315926.79
FACILITY RENTAL 1050-719 1718970.00 .00 1718970.00
INSURANCE COST CENTER 1060 152500.00 125678.65 82.4 26821.35
ELECTIONS COST CENTER 1070 4000.00 33.14 .8 3966.86
ACTIVITY TOTAL 3313173.00 276401.21 8.3 3036771.79
PUBLIC SAFE"Y:
POLICE 2010 2963006.00 29869.57 1.0 2933136.43
CROSSING GUARDS COST 2020 35346.00 2061.96- 5.8- 37407.96
ANIMAL CONTROL 2030 86535.00 .00 86535.00
TRAFFIC SIGNALS 2040 63116.00 3902.08 6.2 59213.92
DISASTER PREAPREDNESS 2050 42312.00 3693.83 8.7 38618.17
FIRE SERVICES JPA 2060 2697625.00 .00 2697625.00
ACTIVITY TOTAL 5887940.00 35403.52 .6 5852536.48
TRAIISPORTATION:
PUBLIC WORKS 3010 284700.00 33999.00 11.9 250701.00
STREET MAINTENANCE 3020 221180.00 2438.92 1.1 218741.08
STREET SWi;EPING 3030 .00 .00 .00
STREET TREE MAINTENANCE 3040 60000.00 3152.68 5.3 56847.32
STREET LAillDSCAPE MAINT. 3050 222880.00 17100.73 7.7 205779.27
PARATRANSIT SERVICES 3060 1500.00 .00 1500.00
ACTIVITY TOTAL 790260.00 56691.33 7.2 733568.67
HEALTH & WELFARE:
VECTOR CGJTROL 5010 .00 .00 .00
WASTE MANAGEMENT 5020 2620.00 .00 2620.00
ACTIVITY TOTAL 2620.00 .00 2620.00
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES 8010 164870.00 .00 164870.00
GL104 idE CITY OF DUBLIN STATEMENT SHOWING PAGE 2
9/03/92 REVENUES VERSUS EXPENDITURE 13.21.45
FOR THE
PERIOD 7/92 THROUGH 8/92
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
CULTURAL ACTIVITIES 8011 8000.00 .00 8000.00
HERITAGE CENTER 8012 20390.00 .00 20390.00
PARK MAINTENANCE 8020 598910.00 49191.60 8.2 549718.40
COMMUNITY CABLE TV 8030 49000.00 .00 49000.00
RECREATION A.DMIN. 8040 171241.00 23813.05 13.9 147427.95
PLAYGROUNDS 8045 82692.00 13039.50 15.8 69652.50
SHANNON CENTER 8050 113195.00 12798.78 11.3 100396.22
PRESCHOOL 8055 35590.00 3036.02 8.5 32553.98
TEENS PROGRAM 8060 27173.00 2641.66 9.7 24531.34
FIELD SCHEDULING 8065 112601.00 16252.76 14.4 96348.24
YOUTH SPORTS 8066 24879.00 2852.43 11.5 22026.57
SPECIAL EVENTS 8070 30040.00 2606.03 8.7 27433.97
SENIOR CENTER 8080 104199.00 11886.43 11.4 92312.57
RECREATION INSTRUCTION 8090 87065.00 13856.09 15.9 73208.91
AQUATICS 8100 198787.00 60650.34 30.5 138136.66
ACTIVITY TOTAL 1828632.00 212624.69 11.6 1616007.31
COMMUNITY DEVELOPMENT:
PLANNING 9010 734366.00 76690.49 10.4 657675.51
BUILDING SAFETY 9020 254801.00 24625.46 9.7 230175.54
ENGINEERING 9030 302827.00 29523.39 9.7 273303.61
ECONOMIC DEVELOPMENT 9040 29300.00 2.25 29297.75
ACTIVITY TOTAL 1321294.00 130841.59 9.9 1190452.41
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 931RI .00 64.90 64.90-
COMMUNITY IMPROVEMENTS 94NN 67000.00 954.92 1.4 66045.08
PARKS 951IN 20717.00 10824.11 52.2 9892.89
STREET CONSTRC/IMPROVMT 96NN 287861.00 4732.51 1.6 283128.49
ACTIVITY TOTAL 375578.00 16576.44 4.4 359001.56
T O T A L EXPENDITURES 13519497.00 728538.78 5.4 12790958.22
EXCESS <REVENUE>EXPEIIDITURES 201106.00 201809.64- 100.3- 402915.64
TRANSFERS IN FROM OTHER FUNDS .00 26000.00- 26000.00
EXCESS <REVENUE> EXPENDITURE 201106.00 227809.64- 113.3- 428915.64
BGL104
THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
9/03/92 REVENUES VERSUS EXPENDITURE 13.23.44
FOR THE
PERIOD 7/92 THROUGH 8/92
SPECIAL REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SALES TAX 108000.00- 17613.84- 16.3 90386.16-
FINES & FORFEITURES 34130.00- 2394.24- 6.9 32335.76-
USES OF MONEY AND PROPERTY 12530.00- .00 12530.00-
INTERNGOVERNMENTAL FROM STATE 943659.00- .00 943659.00-
INTERGOVERNMENTAL FROM FEDERAL 201109.00- .00 201109.00-
CHARGES FOR SERVICES 144900.00- 1796.49- 1.2 143103.51-
OTHER SOURCES OF REVENUE 15000.00- 989.31- 6.6 14010.69-
TOTAL REVENUE 1459928.00- 22793.88- 1.6 1437134.12-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 2600.00 .00 2600.00
CITY MANAGER 24459.00 2084.89 8.5 22374.11
ACTIVITY TOTAL 27059.00 2084.89 7.7 24974.11
PUBLIC SAFETY:
POLICE 13942.00 175.38 1.3 13766.62
TRAFFIC SIGNALS 25084.00 .00 25084.00
ACTIVITY TOTAL 39026.00 175.38 .4 38850.62
TRANSPORTATION: :.
STREET MAINTENANCE 211500.00 266.68 .1 211233.32
STREET SWEEPING 67500.00 5420.50 8.0 62079.50
ACTIVITY TOTAL 279000.00 5687.18 2.0 273312.82
HEALTH & WELFARE:
WASTE MANAGEMENT 18870.00 .00 18870.00
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 129285.00 4166.26 3.2 125118.74
ACTIVITY TOTAL 129285.00 4166.26 3.2 125118.74
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 9700.00 .00 9700.00
COMMUNITY IMPROVEMENTS 164160.00 .00 164160.00
PAS 125150.00 .00 125150.00
STREET CONSTRUCTION/IMPROVMT 888590.00 1100906.47 123.9 212316.47-
ACTIVITY TOTAL 1187600.00 1100906.47 92.7 86693.53
T O T A L EXPENDITURES 1680840.00 1113020.18 66.2 567819.82
EXCESS <REVENUE>EXPENDITURE 220912.00 1090226.30 493.5 869314.30-
EXCESS <REVENUE> EXPENDITURE 220912.00 1090226.30 493.5 869314.30-
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
9/03/92 REVENUES VERSUS EXPENDITURE 13.31.25
FOR THE
PERIOD 7/92 THROUGH 8/92
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 331629.00- 3084.31- .9 328544.69-
USES OF MONEY AND PROPERTY 14580.00- .00 14580.00-
OTHER SOURCES OF REVENUE 4900.00- 1611.46- 32.9 3288.54-
TOTAL REVENUE 351109.00- 4695.77- 1.3 346413.23-
*******EXPE?IDITURES******* -
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 97413.00 78237.50 80.3 19175.50
FINANCE DEPARTMENT 4500.00 606.85 13.5 3893.15
ACTIVITY TOTAL 101913.00 78844.35 77.4 23068.65
PUBLIC SAFETY:
TRFC SIGS/STREET LIGHTING 179190.00 14411.32 8.0 164778.68
ACTIVITY TOTAL 179190.00 14411.32 8.0 164778.68
TRANSPORTATION:
STREET TREE MAINTENANCE 18321.00 158.77 .9 18162.23
STREET LANDSCAPE MAINTENANCE 123240.00 12624.57 10.2 110615.43
ACTIVITY TOTAL 141561.00 12783.34 9.0 128777.66
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 10964.00 1766.57 16.1 9197.43
ACTIVITY TOTAL 10964.00 1766.57 16.1 9197.43
CAPITAL IMPROVEMENT PROJECTS:
STREET CONSTRUCTION/IMPROVMT .00 15.00 15.00-
ACTIVITY TOTAL .00 15.00 15.00-
T 0 T A L EXPENDITURES 433628.00 107820.58 24.9 325807.42
EXCESS<REVENUE>EXPENDITURE 82519.00 103124.81 125.0 20605.81-
EXCESS <REVENUE> EXPENDITURE 82519.00 103124.81 125.0 20605.81-
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
9/03/92 REVENUES VERSUS EXPENDITURE - 13.42.27
FOR THE
PERIOD 7/92 THROUGH 8/92
CAPITAL IMPROVEMENT FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARI.ANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 10290.00- .00 10290.00-
OTHER SOURCES OF REVENUE 92713.00- 28585.00- 30.8 64128.00-
TOTAL REVENUE 103003.00- 28585.00- 27.8 74418.00-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
TR-.NSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
PAYS .00 .00 .00
STREET CONSTRUCTION/IMPROVMT 791247.00 230880.06 29.2 560366.94
ACTIVITY TOTAL 791247.00 230880.06 29.2 560366.94
T O T A L EXPENDITURES 791247.00 230880.06 29.2 560366.94
EXCESS<REVENUE>EXPENDITURE 688244.00 202295.06 29.4 485948.94
EXCESS <REVEi(UE> EXPENDITURE 688244.00 202295.06 29.4 485948.94
i
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
9/03192 REVENUES VERSUS EXPENDITURE 13.35.51
FOR THE
PERIOD 7/92 THROUGH 8/92
INTERNAL SERVICE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 14250.00- .00 14250.00-
CHARGES FOR SERVICES 143994.00- 22942.25- 15.9 121051.75-
OTHER SOURCES OF REVENUE 3000.00- .00 3000.00-
TOTAL REVENUE 161244.00- 22942.25- 14.2 138301.75-
*******EXPENDITURES*******
GENERAL GOVER11MENT ACTIVITIES:
NON-DEPARTMENTAL 272041.00 111698.93 41.1 160342.07
ACTIVITY TOTAL 272041.00 111698.93 41.1 160342.07
PUBLIC SAFETY:
POLICE .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 22000.00 .00 22000.00
ACTIVITY TOTAL 22000.00 .00 22000.00
T 0 T A L EXPENDITURES 294041.00 111698.93 38.0 182342.07
EXCESS<REVENUE>EXPENDITURE 132797.00 88756.68 66.8 44040.32
T1411SFERS OUT TO OTHER FUNDS .00 26000.00 26000.00-
EXCESS <REVENUE> EXPENDITURE 132797.00 114756.68 86.4 18040.32
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
9/03792 REVENUES VERSUS EXPENDITURE 13.39.19
FOR THE
PERIOD 7/92 THROUGH 8/92
ENTERPRISE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 1859697.00- .00 1859697.00-
TOTAL REVENUE 1859697.00- .00 1859697.00-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 1719025.00 552008.71 32.1 1167016.29
CITY MANAGER 3625.00 .00 3625.00
FINANCE DEPARTMENT 8440.00 .00 8440.00
ACTIVITY TOTAL 1731090.00 552008.71 31.9 1179081.29
PUBLIC SAFETY:
DISASTER PREkPREDNESS 1700.00 .00 1700.00
ACTIVITY TOTAL 1700.00 .00 1700.00
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION 11360.00 651.16 5.7 10708.84
SENIOR CENTER 500.00 65.17 13.0 434.83
ACTIVITY TOTAL 11860.00 716.33 6.0 11143.67
COMMUNITY DEVELOPMENT: _
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES 1744650.00 552725.04 31.7 1191924.96
EXCESS<REVENUE>EXPENDITURES 115047.00- 552725.04 480.4- 667772.04-
EXCESS <REVENUE> EXPENDITURE 115047.00- 552725.04 480.4- 667772.04-