HomeMy WebLinkAboutItem 4.4 Financial Report 11-30-1991 (2) CITY OF DUBLIN
AGENDA STATEMENT
MEETING DATE: December 9, 1991
SUBJECT :Financial reports for the months of November 1991
(Report prepared by Phillip S. Molina)
EXHIBITS :��� :Balance Sheets and Income Statements
RECOMMENDATION :Accept and file the financial reports
DESCRIPTION: The financial transactions for the first five months of
this year are reflected in these financial statements. An update of
General Fund Revenue comparisons to last year is shown below:
GENERAL FUND
SAME PERIOD VARIANCE
CURRENT PRIOR YEAR
Other $207,517.94 $4,947.89 $202,570.05
License & Permits 129,430.25 114,944.61 14,485.64
Fines & Forfeiture 8,773.37 7,375.94 1,397.43
Franchise Tax 39,889.53 39,493.37 396.16
Property Transfer 24,960.53 26,639.93 (1,679.40)
Charges for Service 328,508.01 333,307.59 (4,799.58)
Transient Occup. 51,515.00 57,547.00 (6,032.00)
Intergovernmental 404,181.87 419,698.68 (15,516.81)
Property Taxes 312,475.50 359,161 .86 (46,686.36)
Uses of Assets 359,959.72 484,285.84 (124,326.12)
Sales Tax 1,924,329.94 2,217,790.50 (293,460.56)
TOTAL $3,791,541.66 $4,065,193.21 (273,651.55)
The two accounts with the largest negative impact are `Uses of
Assets' and `Sales Tax' revenues. The reason for the downward
movement of the `Uses of Assets' account is due almost entirely
to the City's investments--the amount invested is less than last
year and the interest rates are lower than last year:
current year prior year
Investments:
amount invested $14,977,000.00 $16,069,000.00
weighted average yield 6.81% 8.37%
Property Taxes are down because the County has not distributed the
supplemental property tax allocation this year, whereas last year the City
had received $49,944 is supplemental property tax by November.
Sales taxes are continuing to show sluggishness in recovering:
Sales tax revenues cumulative each month:
91-92 90-91 89-90
July 171,393.08 161,807.00 175,948.39
Aug 877,139.99 659,707.00 695,348.39
Sept 1,075,429.94 1,312,190.50 1,097,284.49
Oct 1,473,329.94 1,700,290.50 1,477,684.49
Nov 1,924,329.94 2,217,790.50 1,984,984.49
Sales taxes are 97% of the 89-90 level .
Special Revenue Funds are up $575,292 when compared to the same period
last year.
General Fund expenses are greater than the prior year's amount by
$978,000. This increase includes payments to Foster City for FAU funds;
what is not reflected in the General Fund is the $570,314.38 of FAU fund
revenues that were received from the State in the month of November and
posted into the Special Revenue Funds.
The balance of the increase in expenditures is due to the payment to the
County for Police Services for the first quarter of this year totaling
$673,196.05. The County was late in billing for Police services last year
and Dublin did not pay for the first quarter services until February.
------------------------------------------------ ---!CX ZY---CIE-R-K-
COPIES TO: FILE .3 5
ITEM NO. 4 1
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF NOVEMBER 1991
Prepared by
The Finance Department
EGL102 CITY OF DUBLIN PAGE 1
12/02/91 BALAIICE SHEET 12.02.46
FOR THE
PERIOD 7/91 THROUGH 11/91
GENERAL SPECIAL SPECI.'-.L CAPITAL
REVENUE REVENUE ASSESSMENT IMPROVEMENT
FUtIDS FUNDS FUNDS FUNDS
ASSETS
CASH 10194.63- 306009.28- 929573.85 113309.94-
CASH WITH FISCAL AGENT
UNAMORTIZED BOND DISCOUNT 1250.00
INVESTMENTS AT COST 14976999.00
RECEIVA.BLES:TAXES 230898.13-
ACCOUNTS (NET) 89360.01- 497800.15-
INTEREST 199249.44-
ASSESSMENTS
270572.83
RENTS
NOTES
DUE FROM OTHERS 215565.91
INVENTORY AT COST
PREPAID ITEMS 4685.50
FIXED ASSETS
AMOUNTS TO BE PROVIDED
TOTAL ASSETS 14668798.20 803809.43- 1200146.68 113309.94-
LIAB, FND BAL, RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPM111T 223756.65-
DEPOSITS FOR A.B1600 FEES 148316.40-
DEPOSITS OTHERS 134774.70- 3125.00-
PAYABLES:A000UNTS 1178394.28 124672.47 26048.53 925.00
INTEREST
PAYROLL 75509.34
DUE TO OTHERS 23884.01- 205405.91- 1500.00-
DEBT INSTRUMENTS PAYABLE 605000.00-
TOTAL LI?BILTIES 871483.26 80733.44- 533576.42- 147391.40-
FUND BAL?110ES 15540286.46- 884542.8? 616570.26- 260701.34
TOTAL FUND EQUITY 15540286.46- 834542.87 616570.26- 260701.34
TOTAL LI3,F1ID BAL, RETD EARNS 14668798.20- 803809.43 1200146.68-_ 113309.94
BGL102 CITY OF DUBLIN PAGE 1
12/02/91 B=LANCE SHEET 12.04.02
FOR THE
PERIOD 7/91 THROUGH 11/91
INTERN.`.`-.L ENTERPRISE FIXED ASSETS
SERVICE FUNDS GROUP OF
FUND ACCOUNTS
ASSETS
CASH 269139.57 542150.89-
CASH WITH FISCAL AGENT 1714537.60
UNAMORM ED BOND DISCOUNT
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS (NET) 768.68-
INTEREST 44632.03
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 8724.75 1724.03
FIXED ASSETS 190056.57 22364521.57 379709.90
AMOUNTS TO BE PROVIDED
TOTAL ASSETS 467952.21 23583264.34 379709.98
LIAR, FHD BAL, RETHD EARNINGS
DEPOSITS FOR PRIVATE DEVELPMIIT
DEPOSITS OTHERS
PAYABLES:ACCOUIITS 104847.90-
INTEREST
PAYROLL
DUE TO OTHERS
DEBT INSTRUMENTS PAYABLE 17320767.00-
TOTAL LIABILITIES 17425614.90-
FUND B!*L1110E 373674.21- 1054526.44-
CONTRIBUTIONS 94278.00- 5103123.00-
INVESTHENTS IN FIXED ASSETS 379709.98-
RETAINED EARNINGS
TOTAL FUND EQUITY 467952.21- 6157649.44- 379709.98-
TOTAL LI.'-B,F1ID BAL, RETD EARIIS 467952.21- 23583264.34- 379709.90-
s
t �
Y BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PA
12/02/91 REVENUES VERSUS EXPENDITURE 11.23.13
FOR THE
PERIOD 7/91 THROUGH 11/91
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
PROPERTY TAXES 4034100.00- 312475.50- 7.7 3721624.50-
SALES TAX 6300000.00- 1924329.94- 30.5 4375670.06-
REAL PROPERTY TRSIISFERS 76000.00- 24960.53- 32.8 51039.47-
TRANSIENT OCCUPANCY TAX 100000.00- 51515.00- 51.5 43435.00-
FRANCHISE TAXES 434500.00- 39389.53- 9.2 394610.47-
LICENSES & PERMITS 474700.00- 129430.35- 27.3 345269.65-
FINES & FORFEITURES 19500.00- 8773.37- 45.0 10726.63-
USES OF MONEY AND PROPERTY 1091100.00- 359959.72- 33.0 731140.23-
INTERNGOVERNMEITTAL FROM STATE 939366.00- 404181.78- 43.0 535184.22-
CHARGES FOR SERVICES 1209905.00- 323503.01- 27.2 881396.99-
OTHER SOURCES OF REVENUE 54600.00- 207517.94- 380.1 152917.94
TOTAL REVENUE 14733771.00- 3791541.67- 25.7 10942229.33-
***{*{*EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 388913.00 232400.00 72.6 106513.00
CITY COUNCIL 1010 160669.00 44272.76 27.6 116396.24
CITY MANAGER 1020 506645.00 183651.71 36.2 322993.29
CITY ATTORNEY 1030 128250.00 59444.65 46.4 68305.35
FINANCE DEPARTMENT 1040 247049.00 86342.83 34.9 160706.17
DATA PROCESSING (FIN) 1045 35500.00 .00 35500.00
BUILDING MAIAGEMENT 1050 363220.00 120781.47 33.3 242438.53
FACILITY RENTAL 1050-719 1720670.00 .00 1720670.00
INSURAIICE COST CENTER 1060 166600.00 143136.76 85.9 23413.24
ELECTIONS COST CENTER 1070 .00 .00 .00
ACTIVITY TOTAL 3717516.00 920080.18 24.7 2797435.82
PUBLIC SAFETY:
POLICE 2010 2794073.00 673196.05 24.1 2120876.95
CROSSING GUARDS COST 2020 33120.00 3168.66 9.6 29951.34
ANIMAL CONTROL 2030 56000.00 12554.75 22.4 43445.25
TRAFFIC SIGN 1S 2040 72550.00 12918.96 17.8 59631.04
DISASTER PREAPREDNESS 2050 42085.00 9679.87 23.0 32405.13
FIRE SERVICES JPA 2060 2573993.00 1031595.00 40.0 1547395.00
ACTIVITY TOTAL 5576821.00 1743113.29 31.3 3833707.71
TRANSPORTATION: -
PUBLIC WORKS 3010 282015.00 100617.46 35.7 181397.54
STREET MAINTENANCE 3020 328100.00 22213.41 6.8 305331.59
STREET SWEEPING 3030 62000.00 19636.00 31.7 42364.00
STREET TREE MAINTENANCE 3040 66500.00 11644.56 17.5 54855.44
STREET LANDSCAPE MAINT. 3050 208850.00 62667.07 30.0 146132.93
PARATRANSIT SERVICES 3060. 1500.00 1500.00 100.0 .00
ACTIVITY TOTAL 948965.00 218283.50 23.0 730631.50
HEALTH & WELFARE:
VECTOR CONTROL 5010 28296.00 .00 23296.00
WASTE MANAGEMENT 5020 33255.00 4023.00 12.1 29232.00
ACTIVITY TOTAL 61551.00 4023.00 6.5 ' 57528.00
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES 8010 156007.00 39001.75 25.0 117005.25
GL104 THE CITY OF DUBLIN STATEMENT SHOWING PACE 2
12/02/91 REVENUES VERSUS EXPENDITURE 11.28.18
FOR THE
PERIOD 7/91 THROUGH 11/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 191301.65 35.1 353968.35
COMMUNITY CABLE TV 8030 49000.00 24000.00 49.0 25000.00
RECREATION ADMIN. 8040 171625.00 60750.66 35.4 110874.34
PLAYGROUNDS 8045 66924.00 28447.95 42.5 38476.05
SHANNON CENTER 8050 105787.00 43503.54 41.1 62283.46
PRESCHOOL 8055 32057.00 10943.40 34.1 21113.60
TEENS PROGRAM 8060 47185.00 14011.93 29.7 33173.07
FIELD SCHEDULING 8065 133395.00 48253.68 36.2 85141.32
YOUTH SPORTS 8066 31739.00 7298.37 23.0 24440.63
SPECIAL EVENTS 8070 27791.00 6954.84 25.0 20836.16
SENIOR CENTER 8080 104120.00 34744.71 33.4 69375.29
RECREATION INSTRUCTION 8090 76921.00 28914.79 37.6 48006.21
AQUATICS 8100 192225.00 87060.60 45.3 105164.40
ACTIVITY TOTAL 1784186.00 646833.32 36.3 1137352.68
COMMUNITY DEVELOPMENT:
PLANNING 9010 1050075.00 402385.36 38.3 647689.64
BUILDING SAFETY 9020 326796.00 91965.08 28.1 234830.92
ENGINEERING 9030 429791.00 106033.13 24.7 323757.87
ECONOMIC DEVELOPMENT 9040 57250.00 5744.33 10.0 51505.67
ACTIVITY TOTAL 1863912.00 606127.90 32.5 1257784.10
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 93MI 88850.00 313.41 .4 88536.59
COMI4UIIITY IMPROVEMENTS 94NN 66300.00 14799.56 22.3 51500.44
PARKS 9511 213216.00 31706.20 14.9 181509.80
STREET COIISTRC/I14PROVMT 96NN 266458.00 5082.21 1.9 261375.79
ACTIVITY TOTAL 634824.00 51901.38 8.2 582922.62
T 0 T A L EXPENDITURES 14587775.00 4190362.57 28.7 10397412.43
EXCESS <REVENUE>EXPENDITURES 145996.00- 398820.90 273.2- 544816.90-
EXCESS <RE,iEIIUE> EXPENDITURE 145996.00- 398820.90 273.2- 544816.90-
Olt
BGL1O4 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
12/02/91 REVENUES VERSUS EXPENDITURE 11.41.05
FOR THE
PERIOD 7/91 THROUGH 11/91
SPECI.'-.L REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIA110E
********REVENUES*******
SALES TAX 114000.00- 40263.31- 35.3 73736.69-
FINES & FORFEITURES 15250.00- 13196.63- 86.5 2053.37-
USES OF MONEY AND PROPERTY 19360.00- .00 19360.00-
INTERNGOVERNMENTAL FROM STATE 797071.00- 245263.88- 30.8 551807.12-
INTERGOVERNMENTAL FROM FEDERAL 958558.00- 570314.38- 59.5 388243.62-
CHARGES FOR SERVICES 132065.00- .00 132065.00-
OTHER SOURCES OF REVENUE 1037300.00- 4050.00- .4 1033250.00-
TOTAL REVENUE 3073604.00- 873080.20- 28.4 2200515.80-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 3142.00 .00 3142.00
ACTIVITY TOTAL 3142.00 .00 3142.00
PUBLIC SAFETY:
POLICE 13295.00 3798.84 28.6 9496.16
CROSSING GUARDS COST .00 .00 .00
TRAFFIC SIGNALS 15250.00 15250.00 100.0 .00
ACTIVITY TOTAL 23545.00 19048.84 66.7 9496.16
TRANSPORTATION:
STREET HAINTEN KE 151300.00 11993.75 7.9 139306.25
ACTIVITY TOTAL 151300.00 11993.75 7.9 139306.25
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERIIIG 132365.00 2950.00 2.2 129415.00
ACTIVITY TOTAL 132365.00 2950.00 2.2 129415.00
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 35024.00 27030.45 77.2 7993.55
PARKS 412475.00 72365.52 17.5 340109.40
STREET CONSTRUCTION/IMPROVMT 4192510.00 814978.41 19.4 3377531.59
ACTIVITY TOTAL 4640009.00 914374.38 19.7 3725634.62
T O T A L EXPENDITURES 4955361.00 940366.97 19.1 4006994.03
EXCESS <REVENUE>EXPENDITURE 1881757.00 75278.77 4.0 1006478.23
EXCESS <REVEIIUE> EXPENDITURE 1881757.00 75278.77 4.0 1806478.23
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
12/02/91 REVENUES VERSUS EXPENDITURE 11.45.52
FOR THE
PERIOD 7/91 THROUGH 11/91
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 391430.00- 30240.02- 7.7 361189.98-
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- 56427.82- 13.6 359402.18-
*******EXPENIDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 103813.00 805715.00 77.6 23238.00
ACTIVITY TOTAL 103813.00 80575.00 77.6 23238.00
PUBLIC SAFETY:
TRFC SIGS/STREET LIGHTING 173550.00 53199.28 30.7 120350.72
ACTIVITY TOTAL 173550.00 53199.23 30.7 120350.72
TRAiiSPORTATION:
STREET TREE MAINTENANCE 13100.00 1479.62 11.3 11620.38
STREET LANDSCAPE MAINTENANCE 100880.00 44114.81 43.7 56765.19
ACTIVITY TOTAL 113980.00 45594.43 40.0 68385.57
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
C014MUNITY DEVELOPMENT:
ENGINEERING 11000.00 3750.59 34.1 7249.41
ACTIVITY TOTAL 11000.00 3750.59 34.1 7249.41
CAPITAL IMPROVEMENT PROJECTS:
STREET CONSTRUCTION/IMPROVMT 1534400.00 .00 1534400.00
ACTIVITY TOTAL 1534400.00 .00 1534400.00
T O T A L EXPENDITURES 1936743.00 183119.30 9.5 1753623.70
EXCESS<REVENUE>EXPENDITURE 1520913.00 126691.48 8.3 1394221.52
EXCESS <REVENUE> EXPENDITURE 1520913.00 126691.48 8.3 1394221.52
EGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
12/02/91 REVENUES VERSUS EXPENDITURE 11.57.45
FOR THE
PERIOD 7/91 THROUGH 11/91
CI.PIT.'-.L IMPROVEMENT FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVEIICES*******
USES OF MONEY AND PROPERTY 3200.00- .00 3200.00-
OTHER SOURCES OF REVENUE 649442.00- .00 649442.00-
TOTAL REVENUE 652642.00- .00 652642.00-
*******EXPEIIDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELF'-.RE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS .00 .00 .00
PARKS 49592.00 8537.47 17.2 41054.53
STREET CONSTRUCTION/IMPROVMT 723850.00 28574.07 3.9 695275.93
ACTIVITY TOTAL 773442.00 37111.54 4.8 736330.46
T O T A L EXPENDITURES 773442.00 37111.54 4.8 736330.46
EXCESS<REVENUE>EXPEIIDITURE 120800.00 37111.54 30.7 83683.46
EXCESS <REVEIIUE> EXPENDITURE 120800.00 37111.54 30.7 83688.46
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
12/02/91 REVENUES VERSUS EXPENDITURE 11.53.47
FOR THE
PERIOD 71191 THROUGH 11/91
ENTERPRISE FUNDS
CURRENT PERIOD
BUDGET ACIU..1L 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 M.?11AGER 19465.00 4743.71 24.4 14721.29
FINANCE DEPARTMENT 10151.00 3552.65 35.0 6598.35
ACTIVITY TOTAL 1750386.00 528314.54 30.2 1222071.46
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 2999.69 22.9 10080.31
SENIOR CENTER 500.00 201.00 40.2 299.00
ACTIVITY TOTAL 13580.00 3200.69 23.6 10379.31
C0141.1UNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES 1774866.00 531515.23 29.9 1243350.77
EXCESS<REVENUE>EXPENDITURES 87833.00- 531515.23 605.1- 619348.23-
EXCESS <REVENUE> EXPENDITURE 87833.00- 531515.23 605.1- 619348.23-
BGL104 Tnc CITY OF DUBLIN STATEMENT SHOWING P.'.GE 1
12/02/91 REVENUES VERSUS EXPENDITURE 11.49.45
FOR THE
PERIOD 7/91 THROUGH 11/91
INTERN.'.'-.L SERVICE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 15000.00- .00 15000.00-
CHARGES FOR SERVICES 148354.00- 51333.85- 34.6 96965.15-
TOTAL REVENUE 163354.00- 513083.85- 31.5 111965.15-
*******EXPEIIDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
11011-DEPARTMENTAL 161069.00 45465.62 28.2 115603.38
ACTIVITY TOTAL 161069.00 45465.62 28.2 115603.38
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 45465.62 25.6 132303.38
EXCESS<REVENUE>EXPENDITURE 14415.00 5923.23- 41.1- 20338.23
EXCESS <REVENUE> EXPENDITURE 14415.00 5923.23- 41.1- 20338.23