HomeMy WebLinkAboutItem 4.03 FinRpt11-93 (2)
e
e
CITY OF DUBLIN
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: January 24, 1994
SUBJECT: Financial Report For The Month of November 1993.
(Prepared by: Paul S. Rankin, Assistant City Manager)
EXHIBITS ATTACHED: 1. / Balance Sheet and Income Statements for the Period
_.0/ Ending November 30, 1993.
RECOMMENDATION:o/' Accept and file the report.
FINANCIAL: See report for monthly Financial Report.
DESCRIPTION: This item provides the monthly financial statement for
the month of November 1993.
GENERAL FUND REVENUES
The General Fund accounts for the majority of the City'S annual revenue and
expenses. Compared to the prior year Revenues are tracking very close to
the anticipated level. In Fiscal Year 1992/93 as of November the City had
collected nearly 28.0% of the budgeted General Fund Revenues as compared to
28.6% for the same period in Fiscal Year 1993/94. In the first five months
Staff has noted small increases in Sales Tax, Transient Occupancy Tax and
Fines and Forfei tures. These areas may be indicative of an improving
economy as compared to the previous year.
It should be noted that a proportionate amount of interest earnings on the
City'S portfolio are a significant revenue source for the City'S General
Fund. OVer the past few months the City has purchased investments which
provide interest payments twice each year (Federal Agency / Treasury
Notes) . This will also skew the comparison of interest revenue when
compared to prior years. In prior years the investments typically paid
interest either monthly, or in the case of LAIF quarterly. In addition the
ci ty has placed an investment in a mutual fund. The dividends are
currently being reinvested to maximize the earnings potential. Staff
intends to withdraw interest dividends from this investment at the end of
the Fiscal Year.
EXPENDITURES
Total expenditures as of November 30th for the General Fund, are less than
the percentage expended in the prior year. Significant portions of the
Public Safety Budgets including Police Services have not been expended due
to delays in receipt of billing statements from the provider of these
services. Expenses in most of the other divisions tend to follow expected
expenditure patterns.
It is recommended that the City Council receive and file these reports as
authorized by section 41004 of the California Government Code.
ITEM NO. ..9. j
COPIES TO:
CITY CLERK
FILE ~.
e
e
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF NOVEMBER 1993
prepared by
The Finance Department
BGL102 e CITY OF DUBLIN e PAGE 1
12/06/93 BALANCE SHEET 16.07.40
FOR THE
PERIOD 7/93 THROUGH 11/93
GENERAL SPECHL SPECHL Cf.PITAL
RE"">JEIfUE REVEIfUE ~.sSESSMElfT IMPROVEMENT
FUNDS FUllDS FUNDS FD1lDS
ASSETS
CASH 711649.47- 615683.18 251018.37 97109.72
CJ..sH WITH FISCJ..L AGENT 121210.04
UNAMORTIZED BOND DISCOUNT 625.00
INVESTMElfTS AT COST 17389417.33
RECEIVf~LES:T!XES
f.CCOUNTS (}fET) 191123.00 22343.74 110795.71
INTEREST 3601. 00
f.SSESSHENTS
RENTS
lKYI'ES
DUE FROM OTHERS 266806.79 13716.27
IlfVEN'f'ORY AT COST
PREPHD ITEMS 2570.00
FIXED ~.sSETS
AMOUllTS TO BE PROVIDED 2232500.00
TOTAL ASSETS 17147493.70 651743.19 2604728.41 207905.43
Ln~ I FHO BAt, RETllD EJ..RHllIGS
DEPOSITS FOR PRIVATE DEVILPIffiT 40137.66-
DEPOSITS FOR AB1600 FEES 141518.46-
DEPOSITS OTHERS 162923.66- 3125.00-
PAYABLES: ACCOUNTS 218742.67-
INTEREST
PAYROLL 46839.16- 323.86- 17 . 90-
DUE TO OTHERS 13306.86- 1190i7 .60- 147729.19-
DEBT lllSTRUMEllTS PAYf~LE 2790000.00-
TOTAL LI~~ILTIES 268207.34- 338144.13- 2793142.90- 289247.65-
FlJ1ID BllJ.lICES 16879286.36- 313599.06- 188414.49 81342.22
T01AL FmiD EQUITY 16879286.36- 313599.06- 188414.49 31342.22
TOTAL LIAB,FllD BALI RETD E.!..PJIS 17147493.70- 651743.19- 2604728.41- 207905.43-
BGL102 e CITY OF DUBLIN e PAGE 1
12/06/93 Bf.LlJfCE SHEET 16.10.57
FOR THE
PERIOD 7/93 THROUGH 11/93 ."
INTERUJ..L ENTERPRISE FIXED ).ssETS GENERAL LONG
SERVICE FmiDS GROUP OF TERM DEBT
FUlID ACCOUNTS ACCOUNT GR\."\UP
).ssETS
CASH 288954.14 2766.72-
CASH WITH FISCAL AGENT 1726901. 55
UNAMORTIZED BOND DISCOUlIT
INVESTMENTS AT COST
RECEIVABLES: TAXES
J..ccomrrs (NET)
INTEREST 46871.38
J..sSESSMEHTS
RElITS
JI()-TES
DUE FROM OTHERS
INVENTORY AT COST
PREP.UD ITEMS 119.60
FIXED ASSETS 165970.10 21623460.54 470014.62
J..MOUllTS '!'O BE PROVIDED 2548360.41
TOTf.L ASSETS 455043.84 23394466.75 470014.62 2548360.41
LIABI FND BALI RETND E~JrnINGS
DEPOSITS FOR PRIVATE DEVELPHN'l'
DEPOSITS OTHERS
PAy]'~LES:.~.CCOUNTS 25603.30-
INTEREST
PAYROLL
DUE TO OTHERS
DEBT ItlSTRUMEIITS PAYJ.~LE 18602851.88- 2548360.41-
TOTAL LIJ.~ILITIES 18628455.18- 2548360.41-
FUND BAIJlICE 286786.10- 343878.43
CONTRIBUTIOlIS 168257.74- 5109890.00-
Il~IESTMENTS IN FIXED ASSETS 470014.62-
RETAINED EJ.JU1IllGS
TOTAL FUlll) EQUITY 455043.84- 4766011.57- 470014.62-
TOTAL LIAB I FlID BAL I RETD E.lJlliS 455043 .84- 23394466.75- 470014 .62- 2548360.41-
BGLlO4 _CITY OF DUBWI STATEMEIlT SHOWING e PAGE 1
12/06/93 REVENUES VERSUS EXPENDITURE 15.33.58
FOR THE
PERIOD 7/93 THROUGH 11/93
GElIER.1,l. REVENUE FUlID
CURRENT PERIOD
BUDGET ACTUJ..L PERCENT Vl<.RIlJfCE
********REVENUES*******
PROPERTY TAXES 3839040.00- 383673.40- 10.0 3455366.60-
SALES TAX 5560000.00- 2116712.11- 38.1 3443287.89-
REAL PROPERTY TRfllSFERS 73000.00- 26994.13- 37.0 46005.87-
TRANSIENT OCCUPMICY TAX 86000.00- 47917.00- 55.7 38083.00-
FRANCHISE TAXES 505900.00- 45798.97- 9.1 460101.03-
LICENSES & PERMITS 375600.00- 180471. 95- 48.0 195128.05-
FINES & FORFEITURES 32000.00- 12893.36- 40.3 19106.64-
USES OF MONEY 1IHD PROPERTY 881100.00- 207710.05- 23.6 673389.95-
IHTERlfGOVERIDlENTAL FROM S'HTE 964425.00- 349843.70- 36.3 614581. 30-
CH.1&GES FOR SERVICES 714533.00- 229120.45- 32.1 485412.55-
OTHER SOURCES OF REVENUE 28100.00- 135530.04- 482.3 107430.04
TOTAL REVEIfUE 13059698.00- 3736665.16- 28.6 9323032.84-
*******EXPENDITURES*******
GENERAL C.oVERHMENT ACTIVITIES:
NOlI-DEPARTMENTAL 45625.00 .00 45625.00
CITY COUNCIL 1010 110388.00 40191.67 36.4 70196.33
CITY MANAGER 1020 254184.00 107048.86 42.1 147135.14
CITY ATTORNEY 1030 161170.00 59263.31 36.8 101906.19
ADMIN SERVICES 1040 407469.00 152356.73 37.4 255112.27
BUILDING KlJfAGEHENT 1050 327067.00 107841. 61 33.0 219225.39
FACILITY RENTAL 1050-719 1532816.00 .00 1532816.00
IHSURAHCE COST CENTER 1060 169656.00 132387.01 78.0 37268.99
ELECTIONS COST CENTER 1070 12910.00 1534.17 11.9 11375.83
ACTIVITY roTi.L 3021285.00 600623.86 19.9 2420661.14
PUBLIC SAFETY:
POLICE 2010 3080979.00 98710.29 3.2 2982268.71
CROSSING GUARDS COST 2020 .00 .00 .00
ANIMAL CONTROL 2030 103100.00 .00 103100.00
TRAFFIC SIGNALS 2040 .00 .00 .00
DIS~J5TER PRE~.PREDNESS 2050 36084.00 12691.11 35.2 23392.89
FIRE SERVICES JPA 2060 2724203.00 1307616.96 43.0 1416586.04
ACTIVITY TOTAL 5944366.00 1419018.36 23.9 4525347.64
TR.)JISPORTATION:
PUBLIC WORKS 3010 282681.00 108415.01 38.4 174265.99
STREET KHliTEli}1{CE 3020 165000.00 460.94 .3 164539.06
STREET TREE ~.INTENAHCE 3040 39150.00 13830.04 35.3 25319.96
STREET LAHDSCJ..PE KAIHT. 3050 157670.00 60743.53 38.5 96926.47
PARATRAHSIT SERVICES 3060 .00 .00 .00
i.CTIVITY TOTAL 644501.00 183449.52 28.5 461051.48
HE..l.LTH & WELFARE:
VECTOR CONTROL 5010 .00 .00 .00
wASTE W.NAGEMElfl' 5020 100.00 .00 100.00
ACTIVITY TOTAL 100.00 .00 100.00
CULTURE & LEISURE SERVICES:
LIBRJ..RY SERVICES 8010 165000.00 41250.00 25.0 123750.00
CULTURJ..L ACTIVITIES 8011 8000 . 00 8000.00 100.0 .00
HERITAGE CENTER 8012 10450.00 175.23 1.7 10274.77
GL104 THEa OF DUBLIN STATEMENT SHOWING e PAGE 2
12/06/93 REVEtfUES VERSUS EXPENDITURE 15.33.58
FOR THE
PERIOD 7/93 THROUGH 11/93
GENERAL REVENUE FlJlID
CURRENT PERIOD
BUDGET ACTUJ..L PERCENT V~.RLliliCE
PARK MAnlTEN~J1CE 8020 584100.00 223521. 70 38.3 360578.30
COKMUlUTY CABLE TV 8030 9000.00 9000.00 100.0 .00
RECREATION ADMIN. 8040 174258.00 70117.86 40.2 104140.14
PLAYGROOlIDS 8045 79482.00 33039.42 41.6 46442.58
SHAlmON CENTER 8050 124260.00 42368.52 34.1 81891. 48
PRESCHOOL 8055 36509.00 13499.84 37.0 23009.16
TEENS PROGRlJ! 8060 33891.00 10094.65 29.8 23796.35
PI ELD SCHEDULING 8065 104959.00 35593.16 33.9 69365.84
YOUTH SPORTS 8066 30805.00 9532.69 30.9 21272.31
SPEcnL EVENTS 8070 30655.00 7079.95 23.1 23575.05
SElfIOR CENTER 8080 136283.00 38245.51 28.1 98037.49
RECREATION IllSTRUCUon 8090 90861.00 30265.64 33.3 60595.36
AQUf.TICS 8100 196565.00 94889.61 48.3 101675.39
}.CTIVITY TOTAL 1815078.00 666673.78 36.7 1148404.22
COMMUNITY DEVELOPKEllT:
PLAlINING 9010 483617.00 202964.52 42.0 280652.48
BUILDInG SAFETY 9020 251277.00 90654.10 36.1 160622.90
ENGINEERlllG 9030 180555.00 89383.08 49.5 91171. 92
ECOHOKIC DEVELOPKElfl' 9040 9610.00 5304.04 55.2 4305.96
ACrfllITY TDTAt 925059.00 388305.74 42.0 536753.26
CAPITAL IMPROVEMEHT PROJECTS:
COIOOJNITY lllPROVEMEllTS 94NN .00 .00 .00
P f.RKS 95lUl 10000.00 .00 10000.00
STREET CONSTRC/lllPROVMT 96HN .00 11636.37 11636.37-
ACTIVITY TOTAL 10000 .00 11636.37 116.4 1636.37-
TOT A.L EXPENDITURES 12360389.00 3269707.63 26.5 9090681.37
EXCESS <REVEHUE>EXPEHDITURES 699309.00- 466957.53- 66.8 232351.47-
TRAlISFERS III FROM OTHER FffiiDS .00 .00 .00
EXCESS <REVEtfUE> EXPENDITURE 699309.00- 466957.53- 66.8 232351. 47-
BGL104 aITY OF DUBLIN STATEMENT SBOIiIllG e PAGE 1
12/06/93 REVENUES VERSUS EXPENDITURE 15.36.26
FOR THE
PERIOD 7/93 THROUGH 11/93
SPECnL REVENUE FUlIDS
CURRENT PERIOD
BUDGET ACTUJ..L PERCEllT VARWICE
********REVENUES*******
SJ..LES TAX 114000.00- 46106.35- 40.4 67893.65-
FINES & FORFEITURES 26500.00- 10587.43- 40.0 15912.52-
USES OF MONEY AIID PROPERTY 16430.00- .00 16430.00-
IHTERNGOVERHHENTAL FROM STATE 756440~00- 179112.30- 23.7 577327.70-
INTERGOVERNMEllTAL FROM COillfl'Y 29000.00- 21532.00- 74.2 7468.00-
IHTERC.{)VERHMENTAL FROM FEDER.!.L 2147125.00- .00 2147125.00-
CHARGES FOR SERVICES 716557.00- 2922.39- .4 713634.61-
OTHER SOURCES OF REVENUE 5000.00- 6587.32- 131.7 1587.32
TOTAL REVENUE 3811052.00- 266847.84- 7.0 3544204.16-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL .00 .00 .00
CITY K.WGER .00 .00 .00
ACTIVITY TOIJ..L .00 .00 .00
PUBLIC SAFETY:
POLICE 18170.00 1754.69 9.7 16415.31
TRAFFIC SIGNALS 93500.00 20771.12 22.2 72728.88
ACTIVITY TOO'H 111670.00 22525.81 20.2 89144.19
TRANSPORTATION:
STREET MAINTE}f~llCE 177350.00 112252.14 63.3 65097.86
STREET SWEEPING 67200 . 00 21452.06 31.9 45747.94
ACfIVITY 'I01'1-.L 244550.00 133704.20 54.7 110845.80
HEALTH & WELnRE:
WASTE MAHAGEMENT 572236.00 2253.20 .4 569982.80
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPHElIT:
EHGIllEERIHG 116497.00 16656.35 14.3 99840.65
ACTIVITY TOTAL 116497.00 16656.35 14.3 99840.65
CAPITAL IMPROVEMENT PROJECTS:
GEllERAL CIP PROJECTS .00 .00 .00
COMMUllITY IMPROVEMENTS 171958.00 28025.44 16.3 143932.56
PARKS 127971.00 12204.47 9.5 115766.53
STREET COllSTRUCTION /IHPROVMT 2342550.00 13956.52 .6 2328593.48
J..CTIVITY 'I{)T1-.L 2642479.00 54186.43 2.1 2588292.57
TOT A L EXPENDITURES 3687432.00 229325.99 6.2 3458106.01
EXCESS <REVEllUE> EXPElIDITTIRE 123620.00- 37521.85- 30.4 86098.15-
EXCESS <REVENUE> EXPENDITURE 123620.00- 37521.85- 30.4 86098.15-
OOL104 4IIt CITY OF DUBLIN STATEMENT SHOWING e PAGE 1
12/06/93 REVENUES vLRSUS EXPENDITURE 15.39.54
FOR THE
PERIOD 7/93 THROOC-H 11/93
SPECIAL }..ssESSMEIlT FrnDS
CURRENT PERIOD
BUDGET !CTU}'.L PERCElIT VARUlKE
********REVENUES*******
SPECI.~ BENEFITS }..ssESSMENTS 523913.00- 4583.62- .9 519329.38-
USES OF MONEY AlID PROPERTY 28260.00- .00 28260.00-
OTHER SOURCES OF REVENUE 10400.00- 4727.89- 45.5 5672.11-
TOTAL REVEliUE 562573.00- 9311.51- 1.7 553261. 49-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
llON-DEP}'.RTMENTJ..L 650731.00 565406.00 86.9 85325.00
FIN}'~CE DEPJ..RTHEIIT .00 .00 .00
ACTIVITY TOTAL 650731.00 565406.00 86.9 85325.00
PUBLIC SJ..FETY:
TRFC SIGS/STREET LIGHTING 197300.00 58341.26 29.6 138958.74
ACTIVITY ron.L 197300 .00 58341.26 29.6 138958.74
TRJJfSPORTATIOlf :
PUBLIC WORKS 1701. 00 1588.03 93.4 112.97
STREET TREE M.UNTElfAlfCE 11300.00 1432.37 12.7 9867.63
STREET B.NDSO.PE MHlITEID~CE 109520.00 43514.82 39.7 66005.18
ACTIVITY ron.L 122521.00 46535.22 38.0 75985.78
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COHMUNITY DEVELOPMENT:
ENGIHEERIlIG 7550.00 3458.52 45.8 4091. 48
ACTIVITY roIAL 7550.00 3458.52 45.8 4091. 48
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMEtlTS .00 4500.00 4500.00-
STREET CONSTRUCTION/IMPROVMT .00 .00 .00
ACTIVITY TOEi .00 4500.00 4500.00-
TOT }.. L EXPENDITURES 978102.00 678241.00 69.3 299861.00
EXCESS<REvllWE>EXPENDITURE 415529.00 668929.49 161.0 253400.49-
TRANSFERS OUT TO OTHER FUNDS .00 .00 .00
EXCESS <REVENUE> EXPENDITURE 415529.00 668929.49 161.0 253400.49-
BGLlO4 ~ITY OF DUBLIN STATEMENT SHOWING e PAGE 1
12/06/93 REVEIfUES VERSUS EXPEliDlTURE 16.03.54
FOR THE
PERIOD 7/93 THROUGH 11/93
C}.PITAL IMPROVEMENT FUND
CURRENT PERIOD
BUDGET AC'l'U.A.L PERCENT VillAlICE
********REVEliOES*******
USES OF MONEY }1ID PROPERTY 4340.00- .00 4340.00-
OTHER SOURCES OF REVEliUE 853500.00- .00 853500.00-
TOTAL REVENUE 857840.00- .00 857840.00-
*******EXPEHDITURES*******
GENERAL GOVERNKEllT ACTIVITIES:
ACTIVITY '1"'01'1-.1 .00 .00 .00
PUBLIC SAFETY:
TPJllSPORTATIOH:
H~~LTH & WELFARE:
Cu'LTURE & LEISURE SERVICES:
COHMUlfITY DEVELOPMENT:
EUGINEERllIG 91608.00 .00 91608.00
ACTIVITY 'fOH.L 91608.00 .00 91608.00
C}.PITAL IMPROVEMEllT PROJECTS:
COMMUNITY IMPRO\TEMENTS 50000.00 .00 50000.00
STREET CONSTRUCTION/IHPROv1ff 561150.00 32769.79 5.8 528380.21
ACTIVITY 101'1-.1 611150.00 32769.79 5.4 578380.21
TOT A L EXPENDITURES 702758.00 32769.79 4.7 669988.21
EXCESS<REVlrnUE>EXPENDITURE 155082.00- 32769.79 21.1- 187851.79-
EXCESS <REVEliOE> EXPENDI'l'URE 155082.00- 32769.79 21.1- 187851.79-
BGL104 ~CITY OF DUBLIN STATEMEnT SHOWING e PAGE 1
12/06/93 REVEIfUES VERSUS EXPENDITURE 15.43.37
FOR THE
PERIOD 7/93 THROUGH 11/93
IllTERNAL SERVICE FUlfD
CURREnT PERIOD
BUOCET ACTUAL PERCENT VARI!lICE
********REVEIfUES*******
USES OF MONEY ~1lD PROPERTt 9360.00- .00 9360.00-
CH.l.RGES FOR SERVICES 137229.00- 53558.59- 39.0 83670.41-
OTHER SOURCES OF REVENUE 4500.00- .00 4500.00-
'fOT}.L REVEIfUE 151089.00- 53558.59- 35.4 97530.41-
*******EXPEnDITURES*******
GENERAL GOVERHMElIT ACTIVITIES:
llOH-DEPARTME1ITAL 188239.00 63673.49 33.8 124565.51
ACTIVITY TOTAL 188239.00 63673.49 33.8 124565.51
PUBLIC S~.FETY:
TRJ.JISPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITJ..L IMPROVEHEllT PROJECTS:
GENERJ..L CIP PROJECTS .00 .00 .00
ACTIVITY roTAL .00 .00 .00
TOT A L EXPEnDITURES 188239.00 63673.49 33.8 124565.51
EXCESS<REVENUE> EXPENDITURE 37150 .00 10114.90 27.2 27035.10
TRANSFERS OUT 'I'D OrnER FUlfDS .00 .00 .00
EXCESS <REVENUE> EXPENDITURE 37150.00 10114.90 27.2 27035.10
BGLl04 T.ITY OF DUBLIN STJ..TEMENT SHOWING tit PAGE 1
12/06/93 REVENUES VERSUS EXPEHDITURE 15.59.58
FOR THE
PERIOD 7/93 THROUGH 11/93
ENTERPRISE FlJlIDS
CURREllT PERIOD
BUDGET !CTU~.L PERCEnT VJ..RHliCE
********REVENUES*******
USES OF MOllE J.1ID PROPERTY 1611177.00- 866.61- .1 1610310.39-
TOTAL REVEmJE 1611177.00- 866.61- .1 1610310.39-
*******EXPElIDITURES*******
GENERJ..L GOVERHMENT ACrrVITIES:
NON-DEP!R'r:mlTJ..L 1532876.00 31.70 1532844.30
CITY M.lj{!GER .00 .00 .00
FnI]'lICE DEPlJffHENT 8250.00 688.75 8.3 7561. 25
J..CTIVITY TOEL 1541126.00 720.45 1540405.55
PUBLIC SHETY:
DISJ..sm PREf.PREDlITSS 1140.00 .00 1140.00
ACTIVITY 'fOIll 1140.00 .00 1140.00
TRJ.J{SPORTATIOll:
HEJ.JLTH & WELFJ..RE:
CULTURE & LEISURE SERVICES:
RECREATION ].JDMINISTRATIOU 11800.00 2934.67 24.9 8865.33
SENIOR CENTER 450.00 238 .14 52.9 211.86
ACTIVITY 'fOUl 12250.00 3172.81 25.9 9077.19
COIOOJNITY DEVELOPMENT:
C.l.PITAL IMPROVEMENT PROJECTS:
TOT ! L EXPENDITURES 1554516.00 3893.26 .3 1550622.74
EXCESS<REVENUE> EXPEHDITURES 56661.00- 3026.65 5.3- 59687.65-
EXCESS <REV11lUE> EXPHlDITURE 56661. 00- 3026.65 5.3- 59687.65-