HomeMy WebLinkAboutItem 4.05 FinancialRpt
.
.
CITY OF DUBLIN
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: October 25, 1993
SUBJECT: Financial Report For The Month of September 1993
~ (prepared by: Paul S. Rankin, Assistant city Manager)
EXHIBITS ATTACHED: 1. /Balance Sheet and Income Statements for the Period
Ending september 30, 1993.
RECOMMENDATION: ~AccePt and file the report.
DESCRIPTION: This item provides the monthly financial statement for
the month of September 1993.
The final 1992/93 audit results will impact the Fund Balance figures
presented in this monthly report. For example, any General Fund revenues
in excess of General Fund expenditures for the previous Fiscal Year have
not been carried forward to the 1993/94 Fund Balance. The Auditors have
completed the field work and Staff anticipates the receipt of their draft
report in the near future.
Although the month of September marks the end of the first quarter, ~ome
major City expenses have not reached 25% of the total budgeted expenditure.
For example, the City has not processed the quarterly billing for Police
Services, which account for a significant amount of the annual operating
budget. Recently, the City was advised that the billing will be late due
to an effort by the County to evaluate its Communications / Dispatch
Charges. In general, City expenses to date for most operational
departments, have been less than 25% of the budget. In some cases the
seasonal nature of the service may distort a pure straight line expenditure
pattern. For example, Aquatic programs incur the majority of the expenses
only during the time that the pool is operated. Also, contract service
billings tend to lag behind the period in which service is received.
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 September the City had
collected nearly 16% of General Fund Revenues as compared to 17% for the
same period in Fiscal Year 1993/94. Total expenditures as of September
30th for the General Fund, are identical to the prior year.
It is recommended that the City Council receive and file these reports as
authorized by section 41004 of the California Government Code.
ITEM NO.
4.;
COPIES TO:
C IT Y CL E R K
FILE ~
.
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF SEPTEMBER 1993
Prepared by
The Finance Department
.
. .
BGLl02 CITY OF DUBLIN PAGE 1
10/18/93 BH}J!CE SHEET 10.57.56
FOR THE
PERIOD 7 /93 THROC~ 9/93
GEllIRAL SPECIAL SPECIAL CJ..PITAL
REVENUE REVEnUE ~.ssESSHEHT IMPROVEMElfT
FUlIDS FUlIDS FUNDS FUlIDS
~.sSETS
CASH 1246616.36- 659056.19 319965.20 65869.04
CASH WIm FISO..L ~.GEIIT 121210.04
UlIAMORTIZED 8011D DISCOUNT 625.00
IUVESTKEHTS AT COST 13126360.59
RECEIV~JBLES:TAXES
~.CCOUllTS (NET) 191123.00 22343.74 110795.71
HfTEREST 8601.00
ASSESSHEIITS
REIITS
NOTES
DUE FROM OTHERS 266806.79 13716.27
INVEIfl''ORY AT C'OST
PREPAID ITEMS 2630.97
FIXED ASSETS
OOUllTS TO BE PROVIDED 2232500.00
TOTAL ASSETS 17349580.99 695116.20 2673675.24 176664.75
LHJB, FIID BAL, RETlID EARNINGS
DEPOSITS FOR PRIVATE DEVELPMHl' 38970.02-
DEPOSITS FOR AB1600 FEES 108508.46-
DEPOSITS OTHERS 166608.66- 3125.00-
PAYABLES:ACCOUNTS 41226.71- 220455.67-
IllTEREST
P.HROLL 10447.04-
DUE TO OTHERS 124926.85- 119077 .60- 147729.19-
DEBT IlISTRUMElITS PAYABLE 2790000.00-
T'OTAL LUJBILTIES 382179.28- 339533.27- 2793125.00:-_~ _ 256237.65-
FUlID B!IJ.J1CES 16967401. 71- 355582.93- 119449.7b 79572.90
TOTAL FUlfD EQUITY 16967401.71- 355582.93- 119449.76 79572.90
TOTAL LIAB,FND BAL, RETD EARlIS 17349580.99- 695116.20- 2673675.24- 176664.75-
"
BGLl02 . CITY or DUBLIN . Pf.GE 1
Hl/18/93 B!IJ.1ICE SHEET 10.58.39
FOR THE
PERIOD 7/93 THROUGH 9/93
IIITERlIAL EIITERPRISE FIXED ASSETS GENERAL LOnG
SERVICE FUllDS GROUP OF TERM DEBT
FilllD Accomrrs ACCOmIT GROUP
ASSETS
CASH 281427.70 2456.27-
CASH WITH FISCAL AGENT 1726901.55
UN.1,.HORTIZED BOND DISCOUNT
mVESTHENTS }.T COST
RECEIV}-BLES:T!XES
ACCOUNTS (!lET)
I1ITEREST 46871.38
}.S5ESSMEHTS
RENTS
nOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS 165970.10 21623460.54 470014.62
}JKXnrrS TO BE PROVIDED 2548360.41
TOTAL ASSETS 447397.80 23394777.20 470014.62 2548360.41
LBB, FND BAL, RETlID ERlfIllGS
DEPOSITS FOR PRIVATE DEVELPMNT
DEPOSITS OTHERS
P}'y}'-BLES: ACCOunTS 25603.30-
INTEREST
PAYROLL
DUE TO OTHERS
DEBT IIISTRUMEnTS PAY!BLE 18602851.88- 2548360.41-
TOTAL LIABILITIES 18628455.18- 2548360.41-
FUND BALMICE 323550.06- 336800.98
CONTRIBUTIONS 123847 .74- 5103123.00-
INVESTMENTS IN FIXED ASSETS 470014 . 62-
RETAINED EARHIIIGS
'I'01'}.L FilllD EQUITY 447397.80- 4766322.02- 470014.62-
TOV.L LIABIFND BALI RETD EARlIS 447397.80- 23394777.20- 470014 .62- 2548360.41-
. .
BGLI04 THE CITY OF DUBLIlI ST~.TEHE11T SHOWIlIG PA
10/18/93 REVUIUES VERSUS EXPUfDITURE 10.18.10
FOR THE
PERIOD 7/93 THROUGH 9/93
GfllERAL REVENUE FUUD
CURRE11T PERIOD
BUJX;ET ACTUAL PERCENT VARDlICE
********REVENUES*******
PROPERTY TAXES 3839040.00- 345594.44- 9.0 3493445.56-
SALES TAX 5560000.00- 1222473.37- 22.0 4337526.63-
REAL PROPERTi TRlJISFERS 73000.00- 19606.02- 26.9 53393.98-
TRJ..HSIENT OCCUP.lJICY TH 86000.00- 22546.00- 26.2 63454.00-
FRJ.JICHISE TAXES 505900.00- 19178.02- 3.8 486721.98-
LICENSES & PERMITS 375600.00- 109445.90- 29.1 266154.10-
FIllES & FORFEITURES 32000.00- 8226.01- 25.7 23773.99-
USES OF MONEY ~JID PROPERTY 881100 .00- 27629.17- 3.1 853470.83-
DlTERlIC-oVERIDIElITAL FROM STJ..TE 964425.00- 229451.13- 23.8 734973.87-
CHARGES FOR SERVICES 714533.00- 157351.18- 22.0 557181.82-
O1'HER SOURCES OF REVEllUE 27850.00- 62632.25- 224.9 34782.25
TOTAL REVENUE 13059448.00- 2224133.49- 17.0 10835314.51-
*******EXPEllDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
liON - D EP ]..RTJ.IE}IT AL 50000.00 .00 50000.00
CITY COUHCIL 1010 110338.00 18020.21 16.3 92367.79
CITY KJ.JIAGER 1020 254184.00 58625.83 23.1 195558.17
CITY ATTORNEY 1030 161170.00 21204.02 13.2 139965.93
]..mUlf SERVICES 1040 407469.00 78176.50 19.2 329292.50
BOILDI1IG M.lliAGEMElIT 1050 327067.00 51715.43 15.8 275351.57
FACILITY RENT]'.L 1050-719 1532816.00 .00 1532816.00
INSURANCE COST CENTER 1060 169656.00 127449.14 75.1 42206.86
ELECTIONS COST CElITER 1070 12910.00 27.87 .2 12882.13
ACTIVITY TOTJ..L 3025660.00 355219.00 11.7 2670441.00
PUBLIC SAFETY:
POLICE 2010 3080979.00 43013.19 1.4 3037965.81
CROSSING GUARDS COST 2020 .00 .00 .00
]'.NlHAL COlITROL 2030 103100.00 .00 103100.00
TRAFFIC SIGNHS 2040 .00 5969.69 _,.59.69.69-
DISASTER PREAPREDNESS 2050 36084.00 5954.44 16.5 30129.56
FIRE SERVICES JPA 2060 2724203.00 653808.48 24.0 2070394.52
ACTIVITY T01'AL 5944366.00 708745.80 11.9 5235620.20
TR.lJISPORTATION:
PUBLIC WORKS 3010 282681.00 56601.06 20.0 226079.94
STREET MAlNTIDO~CE 3020 165000.00 355.01 .2 164644.99
STREET TREE HAUITEN.lJICE 3040 39150.00 9316.81 23.8 29833.19
STREET LAHDSCAPE MoUNT. 3050 157670.00 27785.16 17.6 129884. 84
P.l~TR}J1SIT SERVICES 3060 .00 .00 .00
}.CTIVITY TOTAL 644501.00 94058.04 14.6 550442.96
RE!LTH & WELF}~E:
Wt.5TE HlJfAGEMElIT 5020 100.00 .00 100.00
ACTIVITY T01}.L 100.00 .00 100.00
CULTURE & LEISURE SERVICES:
LIBR}~Y SERVICES 8010 165000.00 .00 165000.00
CGLTUR.\L ACTIVITIES 8011 8000.00 8000.00 100.0 .00
HERITAGE CENTER 8012 10450.00 .00 10450.00
PAPJ< HHNTEUtllCE 8020 534100.00 10s-i74.06 18.0 478925.94
. .
GLI04 THE CITY OF DUBLnl STATEMENT SHOWHlG .. PAGE 2
10/18/93 REVEnUES VERSUS EXPElIDITURE 10.13.10
FOR THE
PERIOD 7/93 THROUGH 9/93
GEllERAL REVENUE FIJ1ID
CURREnT PERIOD
BUDGET }.CTU}..L PERCEN1' VARHllCE
COHMUIUTY CABLE TV 8030 9000.00 .00 9000.00
RECR~~TION ADMIN. 8040 174258.00 37957.00 21.8 136301. 00
PLAYGROUlIDS 8045 79482.00 22065.90 27.8 57416.10
SlilllliOH CEnTER 8050 124260.00 21997.96 17.7 102262.04
PRESCHOOL 8055 36509.00 5976.82 16.4 30532.18
TEENS PROGllliI 8060 33891.00 3971. 29 11.7 29919.71
FIELD SCHEDULING 8065 104959.00 22148.53 21.1 82810.47
YOUTH SPORTS 3066 30305.00 5036.70 16.4 25768.30
SPECIAL EVEll'TS 8070 30655.00 3647.74 11.9 27007.26
SENIOR CENTER 8080 136033.00 17559.58 12.9 118473.42
RECREATION INSTRUCTION 8090 90861. 00 16655.82 18.3 74205.18
}.QU.\TICS 8100 196565.00 70938.34 36.1 125626.66
ACTIVITY TOT.1.L 1814828.00 341129.74 18.8 1473698.26
COHHUlII'l'Y DEv'ELOPMEllT:
PLAlnlIl1G 9010 483617.00 96997.19 20.1 386619.81
BOILDHIG SAFETY 9020 251277.00 46525.79 18.5 204751. 21
EIIGIllEERING 9030 176180.00 47201. 25 26.8 128978.75
ECOUOMIC DEVELOPMEllT 9040 9610.00 93.00 1.0 9517.00
ACTIVITY TOTAL 920684.00 190817.23 20.7 729866.77
CAPITAL IMPROVEMENT PROJECTS:
GEllER.3J. CIP PROJECTS 931m .00 .00 .00
COHHUHITY IMPROVEMENTS 94lIH .00 1143.70- 1143.70
PARKS 951ill 10000.00 .00 10000.00
STREET CONSTRC/IMPROvlfr 96Hlf .00 8191. 29 8191.29-
ACTIVITY TOTAL 10000.00 7047.59 70.5 2952.41
TOT A L EXPEliDITURES 12360139.00 1697017.40 13.7 10663121.60
EXCESS <REVENUE>EXPElIDITURES 699309.00- 527116.09- 75.4 172192.91-
TRz.JfSFERS IN FROH OTHER FUliDS .00 .00 .00
EXCESS <REV'ENUE> E~1E1IDITU~E 699309.00- 527116.09- 75.4 172192.91-
. .
BGLl04 THE CITY OF DUBLIlI STATEMEUT SHOOING PAGE 1
10/18/93 REVElfUES VERSOS EXPENDITURE 10.21.25
FOR THE
PERIOD 7/93 THROUGH 9/93
SPECHL REVENUE FUlIDS
CURRElIT PERIOD
BUDGET ACTU.l.L PERCEnT VARI!lICE
********R@lENUES*******
S~.LES TAX 114000.00- 27899.16- 24.5 86100.84-
FINES & FORFEITURES 26500.00- 5215.42- 19.7 21284.58-
USES OF MONEY !lID PROPERTY 16430.00- .00 16430.00-
IHTEJUfC-oVERNMENT:\L FROM STATE 756440.00- 91880.07- 12.1 6Jj4559.93-
IlITERGOVERlIME1ITH FROH ComiTY 29000.00- .00 29000.00-
INTERGOVERNMENTAL FROM FEDER.~L 2147125.00- .00 214 7125 .00-
C]llJRGES FOR SERVICES 716557.00- 2015.91- .3 714541.09-
OTHER SOURCES OF REVElfUE 5000.00- 6587.32- 131.7 1587.32
'WI AI. REVENUE 3811052.00- 133597.88- 3.5 3677454.12-
*******EXPEHDITURES*******
GUIER.~L C.{)VERlIHElIT ACTIVITIES:
CITY COUNCIL .00 .00 .00
CITY IVJlAGER .00 .00 .00
ACTIVITY TOT~.L .00 .00 .00
PUBLIC SAFETY:
POLICE 18170.00 1218.42 6.7 16951.58
TRAFFIC SIGNALS 93500.00 2038.87 2.2 91461.13
ACTIVITY 'WIAI. 111670.00 3257.29 2.9 108412.71
TlillfSPORTATION:
STREET HAIlITENAlICE 177350.00 6845.85 3.9 170504.15
STREET SWEEPIlfG 67200.00 102H.26 15.2 56955.74
ACTIVITY TO'T.1..L 244550.00 17090.11 7.0 227459.89
HEALTH & WELFARE:
w~.sTE M}..NAGEMENT 572236.00 2200.00 .4 570036.00
CULTURE & LEISURE SERVICES:
C~JITY DEVELOPHENT:
EllGlllEERING 116497.00 8146.26 7.0 108350.74
ACTIVITY 'fOl'AL 116497.00 8146.26 7.0 108350.74
CAPITAL IMPROVEMElIT PROJECTS:
GEllERAL eIP PROJECTS .00 .00 .00
COMMUNITY IMPROVEMENTS 171958.00 567.39 .3 171390.61
P!RKS 127971. 00 9911. 28 7.7 118059.72
STREET COllSTRUCTIOlf/IMPROVMT 2342550.00 13487.04 .6 2329062.96
ACTIVITY TOT~.L 2642479.00 23965.71 .9 2618513.29
TOT A L EXP~IDITDRES 3687432.00 54659.37 1.5 3632772.63
EXCESS <REVENUE>E1~E}lDlTURE 123620.00- 78938.51- 63.9 44681. 49-
EXCESS <RtvIDfUE> EXPflfDITURE 123620.00- 78938.51- 63.9 44681. 49-
. .
BGLl04 THE CITY OF DUBLIlI ST~.TEHENT SHOWING PAGE 1
10/18/93 REVElfUES VERSUS EXPElfDITURE 10.25.19
FOR THE
PERIOD 7/93 THROUGH 9/93
SPECIAL ASSESSMENT FUlfDS
CURRENT PERIOD
BUDGET }.CTlm PERCENT V}.RI}.1{CE
********REVENUES*******
SPECI.~ BENEFITS ASSESSHEIITS 523913.00- 3198.61- .6 520714.39-
OSES OF HONEY }.1{D PROPERTY 28260.00- .00 28260.00-
OTIlER SOURCES OF REVEl/UE 10400.00- 4i27.89- 45.5 5672 .11-
TOTAL REVElfUE 562573.00- 7926.50- 1.4 554646.50-
*******EXPEIIDITURES*******
GEllER.~ GOVERlIMEUT ACTIVITIES:
1I01l-DEPARTMEIITAL .00 565406.00 565406.00-
FINANCE DEPARTMEnT .00 .00 .00
ACTIVITY TOTAL .00 565406.00 565406.00-
PUBLIC SAFETY:
TRFC SIGS/STREET LIGHTING 197300.00 16125.70 8.2 181174.30
}.CTIVITY TDT.~.L 197300.00 16125.70 8.2 181174.30
TR.~lISPORTATION :
PUBLIC WORKS 1701.00 1433.39 84.3 267.61
STREET TREE HAINTEN}.NCE 11300.00 673.55 6.0 10626.45
STREET IJJlDSCAPE MmITEHAlICE 109520.00 17255.90 15.8 92264.10
ACTIVITY TOT}.L 122521.00 19362.84 15.8 103158.16
HE}.LTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMEIIT:
ElIGINEERIllG 7550.00 3458.52 45.8 4091.48
ACTIVITY TOT}.L 7550.00 3458.52 45.8 4091.48
CAPITAL IHPROVEMElIT PROJECTS:
COHMUlIITY IMPROVEHElITS .00 4500.00 4500.00-
STREET OOllSTRUCTIONjIHPROviHT .00 .00 .00
ACTIVITY TOTAL .00 4500.00 4500.00-
TOT A L EXPEHDITURES 327371.00 608853.06 186.0 281482.06-
EXCESS<REVEIWE>EXPElfDlTURE 235202.00- 600926.56 255.5- 836128.56-
-..- -
EXCESS <REVENUE> EXPENDITURE 235202.00- 600926.56 255.5- 836123.56-
~
. .
BGLl04 THE CITY OF DUBLIll STATEMENT SHOWIlIG PAGE 1
10/18/93 REVElmES VERSUS EXPEIIDITURE 10.53.31
FOR THE
PERIOD 7/93 THROUGH 9/93
CAPITAL IHPROVEJ.IEIIT FmlD
CURREnT PERIOD
BUWET ACTU.1.L PERCEtfT VARH1ICE
********REVENUES*******
USES OF HONEY AlTD PROPERTY 4340.00- .00 4340.00-
ornER SOURCES OF REVElmE 853500.00- .00 853500.00-
TOTAL REVENUE 357840.00- .00 857840.00-
*******EXPEIIDITORES*******
GllmRAL GOVEmrnENT ACTIVITIES:
CITY ATTOmlEY .00 .00 .00
ACTIVITY TOTF.L .00 .00 .00
PUBLIC SAFETY:
:~}J'SPORTATIOll:
HElLIH & WELFARE:
CUL'IURE & LEISURE SERVICES:
COMHUlfITY DEVELOPMEnT:
EllGnmERIUG 91608.00 .00 91608.00
ACTIVITY TOT~.L 91608.00 .00 91608.00
CAPITAL IHPROVEHTIIT PROJECTS:
COHJ.IUHITY IMPROVEMEIITS 50000.00 .00 50000.00
STREET COIlSTRUCTIOll /IMPRO'v'HT 561150.00 31463.45 5.6 529686.55
ACTIVITY TOTAL 611150.00 31463.45 5.1 579686.55
TOT A L EXPIDfDITURES 702758.00 31463.45 4.5 6i1294.55
EXCESS<REVElIUE> EXPElTDITURE 155082.00- 31463.45 20.3- 186545.45-
EXCESS <REVElmE> EXPElfDITORE 155082.00- 31463.45 20.3- 186545.45-
.;.'
. .
BGL104 THE CITY OF DUBLIU STATEMENT SHOWInG PAGE 1
10/18/93 REVENUES VERSuS EXPENDITURE 10.44.39
FOR THE
PERIOD 7/93 THROC{-H 9/93
HlTERll.li SERVICE FDlID
CURREnT PERIOD
BUIX;ET ;_C'fUJ..L PERCElIT V}.RV.NCE
********REVENUES*******
USES OF MOlIEY AND PROPERTY 9360.00- .00 9360.00-
CH!RGES FOR SERVICES 137229.00- 31541. 60- 23.0 105687.40-
OTHER SOURCES OF REVENUE 4500.00- .00 4500.00-
TOTAL REVEnUE 151089.00- 31541. 60- 20.9 119547.40-
*******EXP~lDITURES*******
G~{E~\L GOVERNMENT ACTIVITIES:
liON- DEPARTMElITAL 188239.00 49583.43 26.3 138655.57
}.CTIVITY TOTAL 188239.00 49583.43 26.3 138655.57
PUBLIC SAFETY:
IR.UISPORTATION:
HL~LTH & WELFARE:
CULT~~E & LEIS~~E SERVICES:
COHHUNITY DEVELOPMElIT:
C!PIT}.L IMPROVEMENT PROJE.cTS:
GEllERAL CIP PROJECTS .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
TOT A L EXPEIIDITURES 188239.00 49583.43 26.3 138655.57
EXCESS<REVElfUE>EXPENDITURE 37150.00 180n.83 48.6 19108.17
TR\USFERS OUT TO OTHER FUNDS .00 .00 .00
EXCESS <REVENUE> EXPENDITuRE 37150.00 18041.83 43.6 19108.17
--.--
. .
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
10/18/93 REVENUES VERSUS EXPENDITURE 10.48.59
FOR THE
PERIOD 7/93 THRO'GGH 9/93
ENTERPRISE FUlIDS
CURRENT PERIOD
BUDGET ACIU}.L PERCENT V~.RDJICE
********REVEHUES*******
USES OF MONEY }JID PROPERTY 1611177.00- 866.61- .1 1610310.39-
TOTAL REVENUE 1611177 .00- 866.61- ' .1 1610310.39-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
llON-DEPARTHEl!T!1 60.00 .00 60.00
CITY ~lIAGER .00 .00 .00
FINANCE DEPARTMENT 8250.00 410.00 5.0 7840.00
ACTIVITY TOTAL 8310.00 410.00 4.9 7900.00
PUBLIC SHETY:
DISASTER PREAPREDNESS 1140.00 .00 1140.00
ACTIVITY TOTAL 1140.00 .00 1140.00
TRfJfSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISORE SERVICES:
RECREATION ADHllIISTRATION 11800.00 2934.67 24.9 8865.33
SENIOR CEIITER 450.00 238.14 52.9 211.86
ACTIVITY TOTAL 12250.00 3172.81 25.9 9077.19
COHHUlIITY DEVELOPMEllT:
CAPITAL UIPROVDIENT PROJECTS:
TOT A L EXPENDITURES 21700.00 3582.81 16.5 18117.19
EXCESS<REVEHUE> EXPENDITORES 1539477.00- 2716.20 .2- 1592193.20-
EXCESS <REVElruE> EXPEIIDITURE 1589477.00- 2716.20 .2- 1592193.20-
-~."" -