HomeMy WebLinkAboutItem 4.05 Financial Report 12-31-1991 (2) 1
CITY OF DUBLIN
AGENDA STATEMENT
MEETING DATE: February 24, 1992
SUBJECT :Financial reports for the month of December
1991. (Report prepared by Phillip S. Molina)
EXHIBITS :BSYlance Sheets and Income Statements
RECOMMENDATION :Accept, review and file the financial reports
DESCRIPTION: The financial transactions for half of the fiscal
year are presented in this report. Because of the nature of the
current economy, it is important to compare the current ACTUAL
results of the revenue accounts in the General Fund to the
previous year:
Same period
Current last year variance
Other $207,606.00 $5,366.00 $202,240.00
Property taxes 1,997,359..00 1,979,129.00 18,230.00
Franchise tax 53,914.00 44,648.00 9,266.00
License & permits 139,385.00 131,914.00 71471.00
Fine & Forfeitures 10,254.00 8,674.00 1,580.00
Property Transfers 27,381.00 30,164.00 (23783.00)
Transient tax 513515.00 57,547.00 (6,032.00)
Charges for Services 399,434.00 458,824.00 (59,390.00)
Intergovernmental 403,237.00 479,480.00 (76,243.00)
Uses of assets 372,747.00 513,065.00 (140,318.00)
Sales Tax 2,356,188.00 2,833,158.00 (476,970.00)
$6,019,020.00 $63541,969.00 (522,949.00)
There have been changes in the variances compared to last month. This
month, five revenue accounts show positive growth compared to last
year (last month only four accounts showed any positive growth) . The
current total revenues are 92% of the previous years revenues at this
time (last month the current revenues were 93% of the prior years
revenues) .
Sales tax revenue for the prior year included an erroneous transfer
into Dublin's account of $153,446. The State corrected their error by
adjustments in the current year's allocations. For purposes of an
economic comparison, performing a reconciliation for the errors
results in current sales tax revenues of $2,509,634 and last year's
sales tax revenues of $2,679,712. This means that the adjusted current
years sales are 93.6% of the prior year's sales.
Expenditures are higher this year compared to last year at this time
by $997,752. Two items make up the majority of this difference:
First, the fact that this year the City has paid for the first quarter
of the Police Services contract to the County, which had not been
processed by this time last year, and secondly' the Foster City
payments for FAU funds occurred early this year and there were no
similar expenditures last year at this time.
-----------------------------------------=----- ..00■.
COPIES TO: CITY CLERK
ITEM NO. FILE 0 16- Q} I
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF DECEMBER 1991
Prepared by
The Finance Department
BGL102 CITY OF DUBLIN PAGE 1
2/12/92 BALANCE SHEET 11.06.41
FOR THE
PERIOD 7/91 THROUGH 12/91
GENERAL SPECIAL SPECIAL CAPITAL
REVENGE REVENUE ASSESSMENT IMPROVEMENT
FUNDS FUNDS FUNDS FUNDS
ASSETS
CASH 893083.40- 788273.87 1158073.53 210816.23
CASH WITH FISCAL AGENT
UNA.MORTIZED BOND DISCOUNT 1250.00
INVESTMENTS AT COST 16417000.00
RECEIVABLES:TAXES
ACCOUNTS (NET)
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS 1295203.82
INVENTORY AT COST
PREPAID ITEMS 5935.50
FIXED ASSETS
AMOUNTS TO BE PROVIDED
TOTAL ASSETS 16826305.92 788273.87 1158073.53 210816.23
LIAB, FUD B?Z, RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPMNT 99372.82-
DEPOSITS FOR 31600 FEES 156144.40-
DEPOSITS OTHERS 156422.05- 3125.00-
PAYA.BLES:A000UNTS 4234.10- 4552.00 24.00-
INTEREST
PAYROLL 8009.57
DUE TO OTHERS 20518.57- 1270598.35- 1500.00- 23105.47-
DEBT INSTRLMEN'TS PAYABLE 550000.00-
TOT.'-_L LIABILTIES 272533.05- 1266046.35- 554649.00- 179249.87-
FUND BALI-.ACES 16553767.87- 477772.48 603424.53- 31566.36-
TOTIL FUND EQUITY 16553767.87- 477772.48 603424.53- 31566.36-
TOTAL LIAB,FND BAL, RETD EARNS 16826305.92- 788273.87-.. 1158073.53- 210816.23-
BGL102 CITY OF DUBLIN PAGE 1
2/12/92 BALANCE SHEET 11.07.07
FOR THE
PERIOD 7/91 THROUGH 12/91
INTERNAL ENPERPRISE FIXED ASSETS
SERVICE FUNDS GROUP OF
FUND ACCOUNTS
ASSETS
CASH 286357.38 552097.89-
CASH WITH FISCAL AGENT 1718575.90
UNAMORTIZED BOND DISCOUNT
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS (NET)
INTEREST 64500.15
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 8124.75 1724.03
FIXED ASSETS 182941.50 21892690.65 444274.67
AMOUNTS TO BE PROVIDED
TOTAL ASSETS 478023.63 23125392.84 444274.67
LIAB, FND BAL, RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPMMT
DEPOSITS OTHERS
PAYABLES:A000UNTS 457.68-
INTEREST
PAYROLL
DUE TO OTHERS
DEBT INSTRUMENTS PAYABLE 16983728.08-
TOTAL LIABILITIES 457.68- 16983128.08-
FU`ND BADITCE 361561.77- 1038541.76-
CONTRIBUTIONS 115998.18- 5103123.00-
INVESTMENTS IN FIXED ASSETS 444214.67-
RETAINED EARNINGS
TOTAL FUND EQUITY 477565.95- 6141664.76- 444214.67-
TOTAL LIAB,FND BAL, RETD EARNS 478023.63- 23125392.84- 444274.67-
BGL104 HE CITY OF DUBLIN STATEMENT SHOWING PAGE
2/12/92 REVENUES VERSUS EXPENDITURE 10.40.34
FOR THE
PERIOD 7/91 THROUGH 12/91
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
PROPERTY TAXES 4034100.00- 1997359.44- 49.5 2036740.56-
SALES TAX 6300000.00- 2356188.23- 37.4 3943811.77-
REAL PROPERTY TRANSFERS 76000.00- 27381.61- 36.0 48618.39-
TRANSIENT OCCUPANCY TAX 100000.00- 51515.00- 51.5 48485.00-
FRANCHISE TAXES 434500.00- 53914.72- 12.4 380585.28-
LICENSES & PERMITS 474700.00- 139385.43- 29.4 335314.57-
FINES & FORFEITURES 19500.00- 10254.07- 52.6 9245.93-
USES OF MONEY AND PROPERTY 1091100.00- 372747.82- 34.2 718352.18-
I1ITERNGOVERNMENTAL FROM STATE 939366.00- 403237.60- 42.9 536128.40-
CHARGES FOR SERVICES 1209905.00- 399434.71- 33.0 810470.29-
OTHER SOURCES OF REVENUE 54600.00- 207606.52- 380.2 153006.52
TOTAL REVENUE 14733771.00- 6019025.15- 40.9 8714745.85-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 388867.00 289508.41 74.4 99358.59
CITY COUNCIL 1010 160669.00 51401.41 32.0 109267.59
CITY MANAGER 1020 506645.00 217553.51 42.9 289091.49
CITY ATTORNEY 1030 128250.00 77847.73 60.7 50402.27
FINANCE DEPARTMENT 1040 247049.00 102839.57 41.6 144209.43
DATA PROCESSING (FIN) 1045 35500.00 1700.00 4.8 33800.00
BUILDING MANAGEMENT 1050 363220.00 139965.91 38.5 223254.09
FACILITY RENTAL 1050-719 1720670.00 .00 1720670.00
INSURANCE COST CENTER 1060 166600.00 142912.75 85.8 23687.25
ELECTIONS COST CENTER 1070 .00 .00 .00
ACTIVITY TOTAL 3717470.00 1023729.29 27.5 2693740.71
PUBLIC SAFETY:
POLICE 2010 2794073.00 694827.64 24.9 2099245.36
CROSSING GUARDS COST 2020 33120.00 6471.04 19.5 26648.96
ANIMAL CONTROL 2030 56000.00 12554.75 22.4 43445.25
TRAFFIC SIGNALS 2040 73550.00 20753.26 28.2 52796.74
DISASTER PRFAPREDNESS 2050 42085.00 11985.80 28.5 30099.20
FIRE SERVICES JPA 2060 2578993.00 1237914.00 48.0 1341079.00
ACTIVITY TOTAL 5577821.00 1984506.49 35.6 3593314.51
TRANSPORTATION:
PUBLIC WORKS 3010 282015.00 119332.87 42.3 162682.13
STREET MAINTENANCE 3020 328100.00 30135.88 9.2 297964.12
STREET SWEEPING 3030 62000.00 25087.50 40.5 36912.50
STREET TREE MAINTENANCE 3040 66500.00 12834.75 19.3 53665.25
STREET LANDSCAPE MAINT. 3050 208850.00 79857.87 38.2 128992.13
PARATRANSIT SERVICES 3060 1500.00 1500.00 100.0 .00
ACTIVITY TOTAL 948965.00 268748.87 28.3 680216.13
HEALTH & WELFARE:
VECTOR CONTROL 5010 28296.00 25.00 .1 28271.00
WASTE MANAGEMENT 5020 33255.00 4023.00 12.1 29232.00
ACTIVITY TOTAL 61551.00 4048.00 6.6 57503.00
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES 8010 156007.00 39001.75 25.0 117005.25
GL104 ITY OF DUBLIN STATEMENT SHOWING PAGE 2
2/12/92 REVENUES VERSUS EXPENDITURE 10.40.34
FOR THE
PERIOD 7/91 THROUGH 12/91
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
CULTURAL ACTIVITIES 8011 44140.00 21645.45 49.0 22494.55
PARK MAINTENANCE 8020 545270.00 226119.65 41.5 319150.35
COMMUNITY CABLE TV 8030 49000.00 24000.00 49.0 25000.00
RECREATION ADMIN. 8040 171625.00 73203.46 42.7 98421.54
PLAYGROUNDS 8045 66924.00 31401.17 46.9 35522.83
SHANNON CENTER 8050 105787.00 45224.20 42.8 60562.80
PRESCHOOL 8055 32057.00 14184.10 44.2 17872.90
TEENS PROGRAM 8060 47185.00 15656.42 33.2 31528.58
FIELD SCHEDULING 8065 133395.00 52261.83 39.2 81133.17
YOUTH SPORTS 8066 31739.00 8715.94 27.5 23023.06
SPECIAL EVENTS 8070 27791.00 8548.98 30.8 19242.02
SENIOR CENTER 8080 104120.00 40920.72 39.3 63199.28
RECREATION INSTRUCTION 8090 76921.00 37593.66 48.9 39327.34
AQUATICS 8100 192225.00 90717.83 47.2 101507.17
ACTIVITY TOTAL 1784186.00 729195.16 40.9 1054990.84
COMMUNITY DEVELOPMENT:
PLANNING 9010 1050075.00 459128.81 43.7 590946.19
BUILDING SAFETY 9020 326796.00 112812.35 34.5 213983.65
ENGINEERING 9030 429791.00 120236.14 28.0 309554.86
ECONOMIC DEVELOPMENT 9040 57250.00 5744.33 10.0 51505.67
ACTIVITY TOTAL 1863912.00 697921.63 37.4 1165990.37
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS --93141 88850:00 313.41 .4 88536.59
COMMUNITY IMPROVEMENTS 941RI 66300.00 23035.51 34.7 43264.49
PARKS 951RI 213262.00 54500.71 25.6 158761.29
STREET CONSTRC/IMPROVMT 96NII 266458.00 6051.33 2.3 260406.67
ACTIVITY TOTAL 634870.00 83900.96 13.2 550969.04
T O T A L EXPENDITURES 14588775.00 4792050.40 32.8 9796724.60
EXCESS <REVEIIUE>EXPEIIDITURES 144996.00- 1226974.75- 846.2 1081978.75
EXCESS <REVENUE> EXPENDITURE 144996.00- 1226974.75- 846.2 1081978.75
BGL104 CITY OF DUBLIN STATEMENT SNOWING PAGE 1
2/12/92 REVENUES VERSUS EXPENDITURE 10.47.36
FOR THE
PERIOD 7/91 THROUGH 12/91
SPECIAL REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SALES TAX 114000.00- 51593.27- 45.3 62406.73-
FINES & FORFEITURES 15250.00- 15719.36- 103.1 469.36
USES OF MONEY AND PROPERTY 19360.00- .00 19360.00-
INTERNGOVERNMENTAL FROM STATE 797071.00- 317040.82- 39.8 480030.18-
INTERGOVERNMENTAL FROM FEDERAL 958558.00- 687741.97- 71.7 270816.03-
CHARGES FOR SERVICES 132065.00- 80861.41- 61.2 51203.59-
OTHER SOURCES OF REVENUE 1037300.00- 1932297.75- 186.3 894997.75
TOTAL REVENUE 3073604.00- 3085254.58- 100.4 11650.58
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 3142.00 .00 3142.00
ACTIVITY TOTAL 3142.00 .00 3142.00
PUBLIC SAFETY:
POLICE 13295.00 2957.86 22.2 10337.14
CROSSING GUARDS COST .00 .00 .00
TRAFFIC SIGNALS 15250.00 15250.00 100.0 .00
ACTIVITY TOTAL 28545.00 182071.86 63.8 10337.14
TRANSPORTATION:
STREET MAINTENANCE 151300.00 10439.39 6.9 140860.61
ACTIVITY TOTAL 151300.00 10439.39 6.9 140860.61 ~
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 132365.00 4313.96 3.3 128051.04
ACTIVITY TOTAL 132365.00 4313.96 3.3 128051.04
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 35024.00 43174.52 123.3 8150.52-
PARKS 41467^0.00 84128.54 20.3 330549.46
STREET CONSTRUCTION/IMPROVMT 4192510.00 2720076.71 64.9 1472433.29
ACTIVITY TOTAL 4642212.00 2847379.77 61.3 1794832.23
T O T A L EXPENDITURES 4957564.00 2880340.98 58.1 2077223.02
EXCESS <REVENUE>EXPENDITURE 1883960.00 204913.60- 10.9- 2088873.60
EXCESS <REVENUE> EXPENDITURE 1883960.00 204913.60- 10.9- 2088873.60
BGL104 _.E CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/12/92 REVENUES VERSUS EXPENDITURE 10.51.11
FOR THE
PERIOD 7/91 THROUGH 12/91
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 391430.00- 202882.79- 51.8 188547.21-
USES OF MONEY AND PROPERTY 17400.00- .00 17400.00-
OTHER SOURCES OF REVENUE 7000.00- 26187.80- 374.1 19187.80
TOTAL REVENUE 415830.00- 229070.59- 55.1 186759.41-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 103813.00 80575.00 77.6 23238.00
ACTIVITY TOTAL 103813.00 80575.00 77.6 23238.00
PUBLIC SAFETY:
TRFC SIDS/STREET LIGHTING 173550.00 70960.99 40.9 102589.01
ACTIVITY TOTAL 173550.00 70960.99 40.9 102589.01
TRANSPORTATION:
STREET TREE MAINTENANCE 13100.00 1636.06 12.5 11463.94
STREET LANDSCAPE MAINTENANCE 100880.00 48277.08 47.9 52602.92
ACTIVITY TOTAL 113980.00 49913.14 43.8 64066.86
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 11000.00 3750.59 34.1 7249.41
ACTIVITY TOTAL 11000.00 3750:59 34.1 7249.41
CAPITAL IMPROVEMENIT PROJECTS:
STREET CONSTRUCTION/IMPROVMT 1534400.00 .00 1534400.00
ACTIVITY TOTAL 1534400.00 .00 1534400.00
T 0 T A L EXPENDITURES 1936743.00 205199.72 10.6 1731543.28
EXCESS<REVENUE>EXPENDITURE 1520913.00 23870.87- 1.6- 1544783.87
EXCESS <REVENUE> EXPENDITURE 1520913.00 23870.87- 1.6- 1544783.87
BGL104 .E CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/12/92 REVENUES VERSUS EXPENDITURE 11.02.59
FOR THE
PERIOD 7/91 THROUGH 12/91
CAPITAL IMPROVEMENT FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 3200.00- .00 3200.00-
OTHER SOURCES OF REVENUE 649442.00- 167529.87- 25.8 481912.13-
TOTAL REVENUE 652642.00- 167529.87- 25.7 485112.13-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS .00 .00 .00
PARKS 49592.00 9633.50 19.4 39958.50
STREET CONSTRUCTION/IMPROVMT 123850.00 30994.54 4.3 692855.46
ACTIVITY TOTAL 773442.00 40628.04 5.3 732813.96
T O T A L EXPENDITURES 773442.00 40628.04 5.3 732813.96
EXCESS<REVENUE>EXPENDITURE 120800.00 126901.83- 105.1- 247701.83
EXCESS <REVENUE> EXPENDITURE 120800.00 126901.83- 105.1- 247701.83
BGL104 CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/12/92 REVENUES VERSUS EXPENDITURE 10.58.16
FOR THE
PERIOD 7/91 THROUGH 12/91
ENTERPRISE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 1862699.00- .00 1862699.00-
TOTAL REVENUE 1862699.00- .00 1862699.00-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 1720770.00 520018.18 30.2 1200751.82
CITY MANAGER 19465.00 18289.72 94.0 1175.28
FINANCE DEPARTMENT 10151.00 3552.65 35.0 6598.35
ACTIVITY TOTAL 1750386.00 541860.55 31.0 1208525.45
PUBLIC SAFETY:
DISASTER PREAPREDNESS 10900.00 .00 10900.00
ACTIVITY TOTAL 10900.00 .00 10900.00
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION 13080.00 3574.24 27.3 9505.76
SENIOR CENTER 500.00 201.00 40.2 299.00
ACTIVITY TOTAL 13580.00 3775.24 27.8 9804.76
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T O T A L EXPENDITURES 1774866:00 545635.79 30.7 1229230.21
EXCESS<REVENUE>EXPENDITURES 87833.00- 545635.79 621.2- 633468.79-
EXCESS <REVENUE> EXPENDITURE 87833.00- 545635.79 621.2- 633468.79-
BGL104 _AE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2%12/92 REVENUES VERSUS EXPENDITURE 10.54.40
FOR THE
PERIOD 7/91 THROUGH 12/91
INTERNAL SERVICE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 15000.00- .00 15000.00-
CHARGES FOR SERVICES 148354.00- 70456.45- 47.5 77897.55-
TOTAL REVENUE 163354.00- 70456.45- 43.1 92897.55-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 161069.00 52984.17 32.9 108084.83
ACTIVITY TOTAL 161069.00 52984.17 32.9 108084.83
PUBLIC SAFETY:
POLICE 16700.00 .00 16700.00
ACTIVITY TOTAL 16700.00 .00 16700.00
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES 177769.00 52984.17 29.8 124784.83
EXCESS<REVENUE>EXPENDITURE 14415.00 17472.28- 121.2- 31887.28
EXCESS <REVENUE> EXPENDITURE 14415.00 17472.28- 121.2- 31887.28