HomeMy WebLinkAboutItem 4.02 FinRpt 4-94
e
.
CITY OF IX1BLIN
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: May 23, 1994
SUBJECT:
Financial Report For The Month of April 1994.
~ (Prepared by: Paul S. Rankin, Assistant city Manager)
EXHIBITS A'rrACBED: 1. Balance Sheet and Income StateJIents for the Period
Ending April 30" 1994
RECOJIIIEllDATIOR(# Accept and file the report.
\
FINANCIAL:
See report for monthly financial activity.
DESCRIPTION: This item provides the JIOnthly financial statement for
the :month of April 1994.. This report will highlight significant trends,
which differ frolll information presented in earlier IIOnthly reports..
GENERAL FUlft) REVENUES
OVerall, when compared. to the prior year, Revenues are tracking at slightly
below the level collected in the prior year.. In Fiscal Year 1992/93 as of
April the city had collected nearly 81..6% of the actual General Fund Revenues
collected for the entire year.. The April 1994 report shows in the current
year 80.. 4% of the budgeted General Fund revenues have been received..
Franchise taxes are traCking at below the expected level.. This ~as been
impacted by : Reduced. Cable Tv Rates, and Lower Useage of PG&E Energy..
GENERAL FUND EXPENDITURES
Total expenditures as of April 30th for the General Fund, represent 71..3%
authorized budget.. The following are explanations of significant deviations
by Program Area..
Transportation:
A large portion
Street Repair /
will be expended
(58% of Budgeted Expenditures through April..)
of the budgeted General Fund expenditure is for the
OVerlay project, which is now underway.. These funds
in the final two months of the fiscal year..
COJllJlUl1ity Developm.ent:(78..2% of Budgeted Expenditures through April..)
Expenditures have been impacted as a result of staffing vacancies in
planning and Engineering.. Despite this condition in Engineering,
expenses are traCking faster than anticipated due to a delay on several
Capital Projects.
capital Projects: (15..1% of Budgeted Expenditures through April.)
The majority of the projects containing General Funds were not
undertaken until the Spring of 1994 (i.e.. Sidewalk Repair, Dublin Sports
Ground Bleachers, and Annual Street overlay..) Expendi tures in these
areas are anticipated to be recorded in the final months..
It is recoJDJDended that the City Council receive and file these reports as
authorized by section 41004 of the California Government Code..
-----------------------------------------------------------~----------
ITEM NO.
4.z
COPIES TO:
CITY CLERK
FILE ~
--
e
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF APRIL 1994
Prepared by.
The Finance Department
e
e e
BGLlO2 CITY OF DUBLIN PAGE 1
5/16/94 BALAlICE SHEET 11.54.36
FOR m
PERIOD 7/93 TBROOGll 4/94
GENERAL SPECUL SPECIAL CAPIUt
REVENUE REVENUE ASSESSMElfT IHPROVEMENT
FUNDS FUNDS FUJIDS FUNDS
ASSETS
CASH 1919037.87- 682822.47 565731. 32 4930.92-
CASH WITH FISCAL AGEHT 121210.04
UHAMORnZED BOHD DISCOUHT
DlVESTMEHTS AT COST 19800988.71
RECEIVABLES: TAXES
AcromrfS (NET) 191123.00 110795.71
IllTEREST
ASSESSMDTS
RENTS
ms
OC FROM 0l'HERS
Df~SlITORY AT COST
PREPAID ITEMS 5725.27
FIXED ASSETS
AHOOlfl'S TO BE PROVIDED 2232500.00
TOTAL ASSETS 18078799.11 682822.47 2919441.36 105864.79
LI!B I FHD BAt f RETHD EARNINGS
DEPOSITS FOR PRIVATi DEVELPMHT 6503.22
DEPOSITS FOR AB1600 FEES 217208. 46-
DEPOSITS 0l'HERS 193283.66- 3125.00.
PAYABLES:ACCOUHTS 217855.67-
INTEREST .
PAYROLL 39058.11-
OOE TO OTHERS 415 .00-
DEBT INSTRUKENTS PAYABLE 2790000.00-
TOTAL LIABILTIES 226253.55- 217855.674 2793125.00- 211208. 46-
FUND BALANCES 17852545.56~ 464966.80- 126316.36. 111343.61
TOTAL FUND EQUITY 17852545.56- 464966.80- 126316.364 1113 43.67
TmAL LIAB,FlID BAL, RETD EARNS 18078799.11- 682822.47- 2919441. 36- 105864.79-
e e
BGLl02 CITY OF OOBLIlI PAGE 1
5/16/94 BALAltCE SHEET 12.00.49
FOR m
PERIOD 7/93 THROOGH 4/94
INTERNAL EmRPRISE FIXED ASSETS GENERAL LONG
SERVICE FtllIDS GROUP OF TERM DEBT
FUND ACCOUNTS ACCOUNT GROUP
ASSETS
CASH 308582.44 5084.31
CASR WITH FISCAL AGENT 1717488.10
UHAMORTIZED BOND DISCOUNT
IBVESTKENTS AT COST
RlCEIVABLES:TAXES
ACCOUNTS (NET)
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM <YrBERS
IBVElfl'ORY AT COST
PREPAID ITEMS 119.60
FIXED ASSETS 165970.10 21623460.54 470014.62
AMOUNTS TO BE PROVIDED 2548360.41
TOTAL ASSETS 474672.14 23346032.95 470014.62 2548360.41
LIAB I FlID BAL I RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPMHT
DEpOSITS OO'HERS
PAYABLES:ACCOONTS
MEREST
PAYROLL
DUE TO OO'RERS
DEBT INSTRUMENTS PAYABLE 18525000.00- 2548360.41-
TOTAL LI~~ILITIES 18525000.00- 2548360.41-
FUND BALANCE 306414.40- 288857.05
CONTRIBUTIONS 168257.74- 5109890.00-
IlfVESTMElITS IN FIXED ~.ssETS 470014.62-
RETAINED EARNINGS
TOTAL FUND EQUITY 474672.14- 4821032.95- 470014 . 62-
TOTAL Ln~/FND BAL, RETD EARNS 474672.14- 23346032.95- 470014.62- 2548360.41-
BGLl04 T~ITY OF DUBLIN STATEMENT SHOWING e PAGE 1
5/16/94 REVENUES VERSUS EXPENDITURE 11.30.43
FOR THE
PERIOD 7/93 THROUGH 4/94
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
PROPERTY TAXES 3839040.00- 3318174.11. 86.4 520865.89-
SALES TAX 5560000.00~ 4583759.24- 82.4 "976240.76-
REAL PROPERTY TRANSFERS 73000.00- 52257.98~ 71.6 20742.02-
TRANSIENT OCCUPANCY TAX 86000.00. 67468.00- 78.5 18532.00-
FRARCHISE TAXES 505900.00- 459360.72- 90.8 46539.28-
LICENSES & PERMITS 375600.00- 297880.06- 79.3 77719.94-
FINES & FORFEITURES 32000.00- 29807.55~ 93.1 2192.45-
USES OF HONEY AND PROPERTY 881100.00- 546365.34- 62.0 ,334734.66-
IHTERNGOVERNMEHTAL FROM STATE 964425.00- 697989.63- 72.4 266435.37-
CHARGES FOR SERVICES 714533.00- 430305.52- 60.2 284227.48-
OTHER SOURCES OF REVENUE 30649.09- 142576.89- 465.2 111927.80
TOTAL REVENUE 13062247.09- 10625945.04- 81.3 2436302.05-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 45625.00 .00 45625.00
CITY COUNCIL 1010 112438.00 84960.16 75.6 27477.84
CITY MANAGER 1020 258909.00 211648.82 81.7 47260.18
CITY ATTORNEY 1030 306170.00 199540.60 65.2 106629.40
ADMIN SERVICES 1040 414253.00 311261.92 75.1 102991.08
BUILDING MANAGEMENT 1050 334867.00 233196.62 69.6 101670.38
FACILITY RENTAL 1050-719 1532816.00 1458500.27 95.2 74315.73
INSURANCE COST CENTER 1060 169656.00 145613.59 85.8 24042.41
ELECTIONS COST CENTER 1070 12910.00 10802.75 83.7 2107.25
ACTIVITY TOTAL 3187644 .00 2655524.73 83.3 532119.27
PUBLIC SAFETY:
POLICE 2010 3109012.00 1597248.93 51.4 1511763.07
CROSSING GUARDS COST 2020 .00 .00 .00
ANIMAL CONTROL 2030 103100.00 45402.48 44.0 57697.52
TRAFFIC SIGNALS 2040 .00 .00 .00
DISASTER PREAPREDNESS 2050 37067.00 25042.88 67.6 12024.12
FIRE SERVICES JPA 2060 2733103.00 2397297.76 87.7 335805.24
ACTIVITY TOTAL 5982282.00 4064992.05 68.0 1917289.95
TRANSpORTATION:
PUBLIC WORKS 3010 288715.00 225423.66 78.1 63291.34
STREET MAINTENANCE 3020 165025.00 877.22 .5 164147.78
STREET TREE MAINTENANCE 3040 48960.00 33223.86 67.9 15736.14
STREET LANDSCAPE MArNT. 3050 160260.00 124874.87 77.9 35385.13
PARATRANSIT SERVICES 3060 .00 .00 .00
ACTIVITY TOTAL 662960.00 384399.61 58.0 278560.39
HEALTH & WELFARE:
VECTOR CONTROL 5010 .00 .00 .00
WASTE MANAGEMENT 5020 100.00 18.24 18.2 81. 76
ACTIVITY TOTAL 100.00 18.24 18.2 81.76
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES 8010 165000.00 82500.00 50.0 82500.00
CULTURAL ACTIVITIES 8011 8000.00 8000.00 100.0 .00
HERITAGE CENTER 8012 10850.00 733.89 6.8 , 10116.11
GLI04 THEey OF DUBLIN STATEMENT SHOWIlIG e PAGE 2
5/16/94 REVENUES VERSUS EXPENDITURE 11. 30.43
FOR THE
PERIOD 7/93 THROUGH 4/94
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
DUBLIN CEMETERY 8013 .00 4845.74 4845.74-
PARK MAINTENANCE 8020 591955.00 399411.48 67.5 192543.52
COMMlllUTY CABLE TV 8030 20279.00 20279.00 100.0 .00
RECREATION ADMIN. 8040 176453.00 144938.86 82.1 31514.14
PLAYGROUNDS 8045 80378.00 55982.08 69.6 24395.92
SHANNON CENTER 8050 125344 .00 89811.94 71.7 35532.06
PRESCHOOL 8055 37290.59 28537.89 76.5 8752.70
TEENS PROGRAM 8060 34350.00 23470.82 68.3 10879.18
FIELD SCHEDULING 8065 105635.00 58530.03 55.4 47104.97
YOUTH SPORTS 8066 32880.85 25286.52 76.9 7594.33
SPECIAL EVENTS 8070 31070.00 25689.21 82.7 5380.79
SENIOR CENTER 8080 137449.00 78076.78 56.8 59372.22
?ECREATION INSTRUCTION 8090 91764.00 62204.24 67.8 29559.76
"~TICS 8100 199966.00 145245.40 72.6 I 54720.60
ACTIVITY TarAL 1848664.44 1253543.88 67.8 595120.56
COfo; 'HTY DEVELOPMENT:
PL..\jRUNG 9010 560879.00 398811.90 71.1 162067.10
BUILDING SAFETY 9020 256241.00 192035.96 74.9 64205.04
ENGINEERING 9030 173970.00 186246.22 107.1 12276.22-
ECOlfOHIC DEVELOPMENT 9040 9610.00 577.7.18 60.1 I 3832.82
ACTIVITY TarAL 1000700.00 782871.26 78.2 217828.74
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 94HN 50000.00 5469.69 10.9 44530.31
P1;:U';S 951fN 20000.00 8201. 22 41.0 11798.78
S;"~EET CONSTRC/IHPROVMT 96NN 100791.00 12061. 62 12.0 88729.38
ACTIVI'l'Y TOTAL 170791.00 25732.53 15.1 145058.47
T [ A L EXPENDITURES 12853141. 44 9167082.30 71.3 3686059.14
[ ..SS <REVENUE> EXPEHDITURES 209105.65- 1458862.74- 697.7 1249757.09
"' :JlSFERS IN FROM Of HER FUNDS .00 .00 .00
l'RAlfSFERS OOT TO OTHER FUNDS .00 29875.68 29875.68-
EXCESS <REVENUE> EXPENDITURE 209105.65- 1428987.06- 683.4 1219881.41
BGLI04 ~ITY OF DUBLIN STATEMENT SHOWING e PAGE 1
5/16/94 REVENUES VERSUS EXPENDITURE 11.33.33
FOR THE
PERIOD 7/93 THROUGH 4/94
SPECIAL REVEJlUE FUNDS
CURREIIT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVEHUES*******
SALES TAX 114000.00- 95646.79- 83.9 18353.21-
FINES & FORFEITURES 26500.00~ 26564.35- 100.2 64.35
USES OF HONEY AND PROPERTY 16430.00- .00 16430.00~
IHTERNGOVERHMEHTAL FROM STATE 781878.00- 365852.81- 46.8 416025.19-
INTERGOVERNMENTAL FROM COUNTY 38265.50- 90246.83- 235.8 51981. 33
INTERGOVERNMENTAL FROM FEDERAL 2154582.00- 62428.57- 2.9 2092153.43-
CHARGES FOR SERVICES 716557.00~ 638595.85- 89.1 77961.15-
OTHER SOURCES OF REVENUE 5000.00- 8294.03- 165.9 3294.03
TOTAL REVENUE 3853212.50- 1287629.23- 33.4 2565583.27-
*******EXPEHDITURES*******
CENiRAL GOVERNMENT ACTIVITIES:
NOH-DEPARTMENTAL .00 .00 .00
CITY COUNCIL 2450.00 .00 2450.00
CITY MANAGER .00 .00 .00
CITY ATTORNEY .00 .00 .00
AC'fIVITY TOTAL 2450.00 .00 2450.00
PUBLIC SAFETY:
POLICE 18170.00 5811.42 32.0 12358.58
TRAFFIC SIGNALS 93500.00 54102.21 57.9 39397.79
ACTIVITY TOTAL 111670.00 59913.63 53.7 51756.37
TRANSPORTATION:
STREET MAINTENANCE 177865.00 135422.45 76.1 I 42442.55
STREET SWEEPING 67200.00 53312.10 79.3 13887 .90
STREET LANDSCAPE MAINTENANCE .00 .00 .00
ACTIVITY TOTAL 245065.00 188734.55 77.0 56330.45
lE"LTH & WELFARE: ,
WASTE MANAGEMENT 572236.00 542495.39 94.8 29740.61
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 116497.00 106944.11 91.8 9552.89
ACTIVITY TOTAL 116497.00 106944 .11 91.8 9552.89
CAPITAL IMPROVEMENT PROJECTS:
GENERAL ClP PROJECTS .00 .00 .00
COHHUNITY lKPROVDlENTS 181223.50 34118.87 18.8 147104.63
PARKS 135564.00 130736.58 96.4 4827.42
STREET CONSTRUCTIOH/IHPROVMT 2488552.00 65672.19 2.6 2422879.81 -
ACfIVITY TOTAL 2805339.50 230527.64 8.2 2514811.86
TOT A L EXPElfDITDRES 3853257.50 1128615.32 29.3 2724642.18
EXCESS <REVEHUE>EXPlNDITURE 45.00 159013.91- 3364.2- 159058.91 1
TRANSFERS IN FROM OIHER FUNDS .00 32728.18- 32728.18
TRANSFERS OUT TO OTDR FUNDS .00 2852.50 2852.50-
EXCESS <REVIDIUE> EXPENDITURE 45.00 188889.59- 9754.6- 188934.59
BGL104 T~ITY OF DUBLIN STATEMENT SHOWING e PAGE 1
5/16/94 REVENUES VERSUS EXPENDITURE 11.37.02
FOR THE
PERIOD 7/93 THROUGH 4/9~
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 523913.00~ 515249.75~ 98.3 8663.25~
USES OF MONEY AlID PROPERTY 28260.00- .00 28260.00~
OO'BER SOURCES OF REVENUE 10400.00~ 14269.21~ 137.2 3869.21
TOTAL REVEHUE 562573.00~ 529518.96~ 94.1 33054.04-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
HOH-DEPARTMENTAL 650731.00 650730.75 100.0 .25
FINANCE DEPARTMENT .00 .00 .00
ACTIVITY TOTAL 650731. 00 650730.75 100.0 .25
I'~JBLIC SAFETY:
"l1FC SIGS/STREET LIGHTING 202300.00 142414.47 70.4 59885.53
ACTIVITY TOTAL 202300.00 142414.47 70.4 59885.53
1 :$pORTATION:
I'liBLI C WORKS 1701. 00 2349.84 138.1 648.84-
STREET TREE MAINTENANCE 11350.00 3551. 21 31.3 7798.79
STREET LANDSCAPE MAINTENANCE 110085.00 76620.37 69.6 33464.63
ACTIVITY TOTAL 123136.00 82521.42 67.0 40614 .58
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMEIT:
ENGINEERING 7550.00 3550.96 47.0 3999.04
ACTIVITY TOTAL 7550.00 3550.96 47.0 3999.04
CAPITAL IMPROVEMENT PROJECTS:
COHHUNITY IMPROVEMENTS .00 4500.00 4500.00-
STREET CONSTRUCTIOH/IMPROVMT .00 .00 .00
ACTIVITY TOTAL .00 4500.00 4500.00~
T 1 TAL EXPENDITURES 983717.00 883717.60 89.8 99999. 40
EXCESS<REVENUE>EXPEHDITURE 421144.00 354198.64 84.1 66945.36
TRANSFERS IN FROM OTHER FUNDS .00 1l0995.44~ 110995.44
TRANSFERS OUT TO arHER FUNDS .00 110995.44 1l0995.44~
EXCESS <REVENUE> EXPENDITURE 421144.00 354198.64 84.1 I 66945.36
BGL104 THflTY OF DUBLIN STATEMENT SHOIHlIG e PAGE 1
5/16/94 REVENUES VERSUS EXPENDITURE 11.50.55
FOR THE
PERIOD 7/93 THROUGH 4/94
CAPITAL IMPROVEMENT FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT I VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 4340.00- 721.53- 16.6 3618.47-
OTHER SOURCES OF REVENUE 925445.00- 19312.00- 2.1 906133.00-
TcYrAL REVENUE 929785.00- 20033.53- 2.2 909751.47-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
BLIC SAFETY:
NSPORTATION:
',TH & WELFARE:
liRE & LEISURE SERVICES:
~IITY DEVELOPMENT:
,L IMPROVEMENT PROJECTS:
~ET CONSTRUCrrOH/IMPROVMT 675426.00 82804.77 12.3 592621. 23
ACTIVITY TOTAL 675426.00 82804.77 12.3 592621. 23
r A L EXPENDITURES 675426.00 82804.77 12.3 592621.23
5S<REVENUE> EXPEHDITURE 254359.00- 62771.24 24.7- 317130.24-
~SS <REVENUE> EXPENDITURE 254359.00- 62771. 24 24.7~ 317130.24-
BGL104 T~ITY OF DUBLIN STATEMENT SHOWING e PAGE 1
5/16/94 REVENUES VERSUS EXPENDITURE 11.42.15
FOR THE
PERIOD 7/93 THROUGH 4/94
INTERNAL SERVICE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 9360.00~ .00 9360.00-
CHARGES FOR SERVICES 137229.00- 107114.14- 78.1 30114 .86-
OTHER SOURCES OF REVENUE 6711.00- 6305.50- 94.0 405.50~
TOTAL REVENUE 153300.00- 113419.64- 74.0 39880.36~
*******EXPENDlTURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 201514.00 103906.24 51.6 97607.76
ACrIVITY TOTAL 201514 .00 103906.24 51.6 97607.76
PUBLIC SAFETY:
tRANSPORTATION:
BALTa & WELFARE:
"'LTURE & LEISURE SERVICES:
1HUNITY DEVELOPMENT:
j'ITAL IMPROVEMENl PROJECTS:
GENERAL CIP PROJEctS .00 .00 .00
ACfIVITY TOTAL .00 .00 .00
TOT A L EXPENDITURES 201514.00 103906.24 51.6 97607.76
EXCESS<REVENUE> EXPEHDITURE 48214.00 9513 . 40~ 19.7- 57727.40
TRANSFERS OUT TO orDER FUNDS .00 .00 .00
EXCESS <REVENUE> EXPENDITURE 48214.00 9513 . 40~ 19.7- 57727.40
BGL104 TATY OF DUBLIN STATEMEHT SHOWING e PAGE 1
5/16/94 REVENUES VERSUS EXPENDITURE 11.46.45
FOR THE
PERIOD 7/93 THROUGH 4/94
ENTERPRISE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF HONEY AND PROPERTY 1611177.00- 1516722.60- 94.1 94454.40-
TOTAL REVENUE 1611177 .00- 1516722.60- 94.1 94454.40-
*******EXPENDITURES*******
GEKERAL GOVERNMENT ACTIVITIES:
ROH"DEPARTHEHTAL 1532876.00 1455000.65 94.9 77875.35
CITY MANAGER .00 .00 .00
FINANCE DEPARTMENT 8250.00 1126.20 13.7 7123. 80
ACTIVITY TOTAL 1541126.00 1456126.85 94.5 84999.15
PUBLIC SAFETY:
~rSASTER PREAPREDNESS 1140.00 .00 1140.00
ACTIVITY TOTAL 1140.00 .00 1140.00
:"QRTATION:
Hi ; & WELFARE:
ct ~E & LEISURE SERVICES:
..REATION ADMINISTRATION 11800.00 8262.88 70.0 3537.12
SENIOR CENTER 450.00 338.14 75.1 111. 86
ACTIVITY TOTAL 12250.00 8601.02 70.2 I 3648.98
COMMUHITY DEVELOPMEIfT:
CAPITAL IHPROVEMEHT PROJECTS:
TOT A L EXPENDITURES 1554516.00 1464727.87 94.2 89788.13
E:i'~ '.SS<REVENUE> EXPElfDITURES 56661.00- 51994.73- 91.8 4666.27-
I
E j <REVENUE> EXPENDITURE 56661.00- 51994.73~ 91.8 4666.27-