HomeMy WebLinkAboutItem 4.03 FinRpt 1-94
.
e
CITY OF DUBLIN
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: February 28, 1994
SUBJECT:
roJIn Financial Report For The Month of January 1994.
~~ (Prepared by: Paul S. Rankin, Assistant City Manager)
Statements for the Period
1.
EXHIBITS ATTACHED:
Balance Sheet and Income
Ending January 31, 1993.
~ccePt and file the report.
RECOMMENDATION:
FINANCIAL:
See report for monthly financial activity.
DESCRIPTION: This item provides the monthly financial statement for
the month of January 1994. This report will highlight significant trends,
which differ from information presented in earlier monthly reports.
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 slightly below
the anticipated level. In Fiscal Year 1992/93 as of January the city had
collected nearly 55.5% of the budgeted General Fund Revenues as compared to
53.2%% for the same period in Fiscal Year 1993/94. This is partially
impacted by the fact that the 1993/94 annual Cable TV Franchise payment was
not received until February. If an adjustment were made for this factor,
the January 1993/94 General Fund Revenues would reflect 54.3% collected.
EXPENDITURES
Total expenditures as of January 31st for the General Fund, represent 46.4%
authorized budget. 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. This lag is
expected to be eliminated in the upcoming month.
Planning Department expenses are at approximately 47.8% of their authorized
budget. Two significant factors have impacted expenses for this
Department. First, the Department has had employee turnover, which
resul ted in a vacant posi tion during the time required to complete the
recruitment. The second impact has been a delay in receipt of the final
billing for consultant services, related to finalizing the East Dublin
General Plan Amendment and specific Plan.
The Engineering Department Expenses in the General Fund are currently
tracking at a faster pace than experienced in the previous year. As of
January 31, 1994 the General Fund Engineering Department expense is 79.0%
of its budget. This is primarily attributable to less activity on Capital
Improvement Projects, which increases the proportion of expense incurred
under General Engineering. The adopted Budget assumed that several major
construction projects would be underway in Fiscal 'Year 1993/94. It now
appears that the following projects will not be as far along and will be
carried over into next Fiscal Year: Bike Path Project / Dougherty
Road Improvements south of SP Railroad Right of Way / Dublin Blvd
Improvements From Donlon To Village Parkway_ As a result of being carried
over there will be limited staff inspection time incurred on these
projects. 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. 4.7
COPIES TO:
CITY CLERK
FILE~
e
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF JANUARY 1994
Prepared by
The Finance Department
e
e e
BCLlO2 CITY OF DUBLIN PAGE 1
2/17/94 BALANCE SHEET 15.46.17
FOR THE
PERIOD 7/93 THROUGH 1/94
GENERAL SPECIAL SPECIAL CAPITAL
REVENUE REVENUE ASSESSHElfT IMPROVEMENT
FUlIDS FUNDS FUNDS FUNDS
ASSETS
CASH 902343.42- 644236.65 470537.90 89133.11-
CASH WITH FISCAL AGENT 121210.04
UNAMORTIZED BOND DISCOUNT
INVESTMENTS AT COST 18368948.63
RECEIVABLES: TAXES
ACCOUNTS (NET) 191123.00 110795.71
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 6650.84
FIXED ASSETS
AMOUNTS TO BE PROVIDED 2232500.00
TOTAL ASSETS 17664379.05 644236.65 2824247.94 21662.60
LIAB, FND BALI RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPHNT 34472.02~
DEPOSITS FOR AB1600 FEES 145648.46-
DEPOSITS OTHERS 191458.66~ 3125.00-
PAYABLES:ACCOUNTS 217855.67-
INTEREST
PAYROLL 7891.99-
"I"': TO OTHERS 1155.00-
.. ':>1' INSTRUMEHTS PAYABLE 2790000.00-
TOTAL LIABILTIES 234977.67- 217855.67- 2793125.00- 145648.46-
FUND BALANCES 17429401. 38- 426380.98- 31122.94- 123985.86
TOTAL FUND EQUITY 17429401.38- 426380.98- 31122.94- 123985.86
TOTAL LIAB,FlID BAL, RETD EARNS 17664379.05- 644236.65- 2824247.94- 21662.60-
e e
BGL102 CITY OF DUBLIN PAGE 1
2/17/94 BALANCE SHEET 15.47 . 54
FOR THE
PERIOD 7/93 THROUGH 1/94
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG
SERVICE FUNDS GROUP OF TERM DEBT
FUND ACCOUNTS ACCOUNT GROUP
ASSETS
CASH 308248.28 3664.25-
CASH WITH FISCAL AGENT 1726901.55
UNAMORTIZED BOND DISCOUNT
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS (NET)
INTEREST 46871.38
ASSESSMENTS
RENTS
NOTES
"UE FROM OTHERS
,NVENTORY AT COST
PREPAID ITEMS 119.60
FIXED ASSETS 165970.10 21623460.54 470014.62
AJ<<>UHTS TO BE PROVIDED 2548360.41
TOTAL ASSETS 474337.98 23393569.22 470014.62 2548360.41
LIAB, FND BAL, RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPMlfT
DEPOSITS OTHERS
PAYABLES:ACCOUNTS 25603.30-
INTEREST
PAYROLL
)UE TO OTHERS
DEBT INSTRUMENTS PAYABLE 18602851.88~ 2548360.41-
TOTAL LIABILITIES 18628455.18- 2548360.41-
i ' ;;D BALANCE 306080.24- 344775.96
CONTRIBUTIONS 168257.74- 5109890.00-
INVESTMENTS IN FIXED ASSETS 470014.62-
RETAINED EARNINGS
TOTAL FUND EQUITY 474337.98- 4765114.04- 470014.62-
TOTAL LIAB,FHD BAL, RETD EARNS 474337.98- 23393569.22- 470014.62~ 2548360.41-
e e
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/17/94 REVENUES VERSUS EXPENDITURE 15.02.50
FOR THE
PERIOD 7/93 THROUGH 1/94
GENERAL REVENUE ' FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
PROPERTY TAXES 3839040.00- 2128220.44- 55.4 1710819.56-
SALES TAX 5560000.00- 3132197.61~ 56.3 2427202.39-
REAL PROPERTY TRANSFERS 73000.00- 30007.57- 41.1 42992.43-
TRAlfSIElfT oca1PANCY TAX 86000.00- 67468.00- 78.5 18532.00-
FRAHCHISE TAXES 505900.00- 57973.57- 11.5 447926.43-
LICENSES & PERMITS 315600.00~ 215909.54- 57.5 159690.46-
FINES & FORFEITURES 32000.00- 21688.33- 67.8 10311. 67-
USES OF MONEY AND PROPERTY 881100.00- 382760.86- 43.4 498339.14-
INTERNGOVERNMENTAL FROM STATE 964425.00- 482525.36- 50.0 481899.64-
CHARGES FOR SERVICES 714533.00- 290314.12- 40.6 424218.88-
OTDER SOURCES OF REVENUE 28100.00- 131578.45- 468.3 103478.45
TOTAL REVENUE 13059698.00- 6941243.85- 53.2 6118454.15-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 45625.00 .00 45625.00
CITY COUNCIL 1010 112438.00 54522.81 48.5 57915.19
CITY MANAGER 1020 258909.00 144826.79 55.9 114082.21
CITY ATTORNEY 1030 306170.00 127899.85 41.8 178270.15
ADMIN SERVICES 1040 414253.00 209305.47 50.5 204947.53
BUILDING MANAGEMENT 1050 334867.00 158827.04 47.4 176039.96
FACILITY RENTAL 1050-719 1532816.00 1444778.58 94.3 88037.42
INSURAlfCE COST CENTER 1060 169656.00 134987.01 79.6 34668.99
ELECTIONS COST CENTER 1070 12910.00 10548.15 81.7 2361. 85
ACTIVITY TOTAL 3187644.00 2285695.10 71.7 901948.30
PUBLIC SAFETY:
POLICE 2010 3109012.00 134896.77 4.3 2974115.23
CROSSING GUARDS COST 2020 .00 .00 .00
ANIMAL CONTROL 2030 103100.00 .00 103100.00
TRAFFIC SIGNALS 2040 .00 .00 .00
DISASTER PREAPREDNESS 2050 37067.00 17783.46 48.0 19283.54
FIRE SERVICES JPA 2060 2733103.00 1743489.28 63.8 989613.72
ACTIVITY TOTAL 5982282.00 1896169.51 31.7 4086112.49
TRAlfSPORTATION:
PUBLIC WORKS 3010 288715.00 149763.83 51.9 '138951.17
STREET MAINTENANCE 3020 165025.00 707.91 .4 164317.09
STREET TREE HAINTENANCE 3040 48960.00 22610.93 46.2 26349.07
STREET LANDSCAPE RAINT. 3050 160260.00 85361.73 53.3 74898.27
PARATRANSIT SERVICES 3060 .00 .00 .00
ACTIVITY TOTAL 662960.00 258444.40 39.0 404515.60
HEALTH & WELFARE:
VECl'OR 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 193.47 1.8 10656.53
tit e
GL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2
2/17/94 REVENUES VERSUS EXPENDITURE 15.02.50
FOR THE '
PERIOD 7/93 THROOGH 1/94
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIABCE
PARK MAINTENANCE 8020 591955.00 302471.07 51.1 1289483.93
COHM\JNITY CABLE TV 8030 20279.00 9000.00 44.4 11279.00
RECREATION ADMIN. 8040 176453.00 97016.15 55.0 79436.85
PLAYGROUNDS 8045 80378.00 40837.07 50.8 39540.93
SHANNON CENTER 8050 125344.00 60744.84 48.5 64599.16
PRESCHOOL 8055 36966.00 18238.18 49.3 18727.82
TEENS PROGRAM 8060 34350.00 14575.86 42.4 19774.14
FIELD SCHEDULING 8065 105635.00 43206.15 40.9 62428.85
YOUTH SPORTS 8066 31043.00 15484.42 49.9 15558.58
SPECIAL EVEIlTS 8070 31070.00 10966.52 35.3 20103.48
SENIOR CENTER 8080 137449.00 53832.65 39.2 83616.35
RECREATION INSTRUCTION 8090 91764.00 39634.97 43.2 52129.03
AQUATICS 8100 199966.00 116149.06 58.1 83816.94
ACTIVITY TOTAL 1846502.00 912850.41 49.4 933651.59
COMMUNITY DEVELOPMENT:
PLANNING 9010 560879.00 267979.49 47.8 292899.51
BUILDING SAFETY 9020 256241.00 128645.45 50.2 127595.55
ENGINEERING 9030 173970.00 137481. 52 79.0 36488.48
ECONOHIC DEVELOPMENT 9040 9610.00 5322.05 55.4 4287.95
ACTIVITY TOTAL 1000700.00 539428.51 53.9 461271. 49
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 94NH .00 .00 .00 I
PARKS 95NN 20000.00 .00 20000.00
STREET CONSTRCjIMPROVMT 96HN 37000.00 12918.52 34.9 24081. 48
ACTIVITY TOTAL 57000.00 12918.52 22.7 44081. 48
TOT A L EXPENDITURES 12737188.00 5905525.29 46.4 6831662.71 ,
EXCESS <REVENUE>EXPENDITURES 322510.00~ 1035718. 56~ 321.1 713208.56
TRANSFERS IN FROM OTHER FUNDS .00 .00 .00
TRANSFERS OUT ro OTHER FUNDS .00 29875.68 29875.68-
EXCESS <REVENUE> EXPENDITURE 322510.00- 1oo5842.88~ 311. 9 683332.88
e e
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/17/94 REVENUES VERSUS EXPENDITURE 15.07.49
FOR THE
PERIOD 7/93 THROUGH 1/94
SPECIAL REVENUE FUHDS
CURRENT PERIOD
BuDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SALES TAX 114000.00- 65999.69- 57.9 48000.31-
FINES & FORFEITURES 26500.00- 22208.80- 83.8 4291.20-
USES OF MONEY AND PROPERTY 16430.00- .00 16430.00- .
IlfTERHGOVERlfMElfTAL FROM STATE 719440.00- 247666.77- 34.4 471773.23-
INTERGOVERNMENTAL FROM COUNTY 38265.50- 21532.00- 56.3 16733.50-
IlfTERGOVERHMElfTAL FROM FEDERAL 2147125.00- .00 2147125.00-
CHARGES FOR SERVICES 716557.00- 382330.38- 53.4 334226.62-
OTHER SOURCES OF REVENUE 5000.00- 8294.03~ 165.9 3294.03
TotAL REVENUE 3783317.50- 748031.67- 19.8 3035285.83-
~*****EXPENDITURES*******
HfERAL GOVERNMENT ACTIVITIES:
CTTY COUNCIL 2450.00 .00 2450.00
C1TY MANAGER .00 .00 .00
ACTIVITY TotAL 2450.00 .00 2450.00
PUBLIC SAFETY:
POLICE 18170.00 2182.43 12.0 , 15987.57
TRAFFIC SIGNALS 93500.00 38313.69 41.0 55186.31
ACTIVITY TotAL 111670.00 40496.12 36.3 71173.88
TRAlfSPORTATION:
STREET MAINTENANCE 177865.00 125311. 49 70.5 52553.51
STREET SWEEPING 67200 .00 35900.02 53.4 31299.98
STREET LANDSCAPE MAINTENANCE .00 .00 .00
ACrIVITY TOTAL 245065.00 161211.51 65.8 83853.49
HEALTH & WELFARE:
WAf,'fE MANAGEMENT 572236.00 261919.20 45.8 310316.80
CUL'ftkE & LEISURE SERVICES:
C()M}~;;NITY DEVELOPMENT:
:.!/GINEERING 116497.00 22832.44 19.6 93664.56
ACTIVITY TOTAL 116497.00 22832.44 19.6 93664.56
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS .00 .00 .00
COMMUNITY IMPROVEMENTS 181223.50 34108.33 18.8 147115.17
PARKS 127971.00 73014.99 57.1 54956.01
STREET CONSTRUCTION/IMPROVMT 2334975.00 34020.99 1.5 2300954 .01
ACTIVITY TOTAL 2644169.50 141144.31 5.3 2503025.19
TOT A L EXPENDITURES 3692087.50 627603.58 17.0 3064483.92
EXCESS <REVENUE>EXPEHDITURE 91230.00- 120428.09- 132.0 29198.09
TRANSFERS IN FROM OTHER FUNDS .00 32728.18- 32728.18
TRANSFERS OUT TO otHER FUNDS .00 2852.50 2852.50-
EXCESS <REVENUE> EXPENDITURE 91230.00- 150303.77- 164.8 59073.77
e e
BGLl04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/17/94 REVENUES VERSUS EXPENDITURE 15.13.44
FOR THE
PERIOD 7/93 THROUGH 1/94
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 523913.00- 265991.14- 50.8 257921.86-
USES OF MONEY AND PROPERTY 28260.00- .00 28260.00-
OTHER SOURCES OF REVENUE 10400.00- 8960.15- 86.2 1439.85-
TOTAL REVENUE 562573.00- 274951. 29- 48.9 287621.71-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
HOH-DEPARTMENTAL 650731. 00 565406.00 86.9 85325.00
FINANCE DEPARTMENT .00 .00 .00
ACTIVITY TOTAL 650731. 00 565406.00 86.9 85325.00
PUHLIC SAFETY:
TRFC SIGS/STREET LIGHTING 202300.00 91646.59 45.3 110653. 41
ACTIVITY TOTAL 202300.00 91646.59 4~.3 110653.41
TRANSPORTATION:
PUBLIC WORKS 1701. 00 1599.20 94.0 101.80
STREET TREE MAINTENANCE 11350.00 2864.53 25.2 8485.47
STREET LAHDSCAPE MAINTENANCE 110085.00 54782.09 49.8 55302.91
ACTIVITY TOTAL 123136.00 59245.82 48.1 63890.18
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
OOHHUNITY DEVELOPMENT:
ENGINEERING 7550.00 3544.94 47.0 4005.06
ACTIVITY TOTAL 7550.00 3544.94 47.0 4005.06
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS .00 4500.00 4500.00-
STREET CONSTRUCTION/IMPROVMT .00 .00 .00
ACTIVITY TOTAL .00 4500.00 4500.00-
TOT A L EXPEnDITURES 983717.00 724343.35 73.6 259373.65
EXCESS<REVENUE>EXPEHDITURE 421144.00 449392.06 106.7 28248.06.
TRANSFERS IN FRO!( OTHER FUNDS .00 110995.44- 110995.44
TRANSFERS OUT TO OTHER FUNDS .00 110995.44 110995.44-
EXCESS <REVENUE> EXPENDITURE 421144.00 449392.06 106.7 28248.06-
e e
BGLl04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/17/94 REVENUES VERSUS EXPENDITURE 15.25.16
FOR THE
PERIOD 7/93 THROUGH 1/94,
CAPITAL IMPROVEMENT FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF HONEY AND PROPERTY 4340.00- .00 4340.00-
OTHER SOURCES OF REVENUE 925445.00- .00 925445.00-
TOTAL REVENUE 929785.00- .00 929785.00-
*******EXPEHDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 50000.00 .00 50000.00
STREET CONSTRUCTIOH/IMPROVMT 646136.00 75413.43 11.7 570722.57
ACTIVITY TOTAL 696136.00 75413.43 10.8 620722.57
TOT A L EXPENDITURES 696136.00 75413.43 10.8 620722.57
EXCESS<REVENUE>EXPENDITURE 233649.00- 75413.43 32.3- 309062.43-
EXCESS <REVENUE> EXPENDITURE 233649.00- 75413.43 32.3- 309062.43-
e e
BGLl04 THE CITY OF DUBLIlI STATEMENT SHOWING PAGE 1
2/17/94 REVENUES VERSUS EXPENDITURE 15.17.24
FOR THE
PERIOD 7/93 THROUGH 1/94
INTERNAL SERVICE FUllD
CURRENT PERIOD
BUDGET ACTUAL PERCENT I VARIANCE
********REVENUES*******
USES OF HONEY AND PROPERTY 9360.00- .00 9360.00-
CHARGES FOR SERVICES 137229.00- 75807.13- 55.2 61421. 87-
OTHER SOURCES OF REVENUE 4500.00- 6275.50- 139.5 1775.50
TOTAL REVElfUE 151089.00- 82082.63- 54.3 69006.37-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
HOH-DEPARTMENTAL 188239.00 72903.39 38.7 115335.61
ACTIVITY TOTAL 188239.00 72903.39 38.7 115335.61
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COHMUlfITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
GEHERAL CIP PROJECTS .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
TOT A L EXPENDITURES 188239.00 72903.39 38.7 115335.61
EXCESS<REVEKUE>EXPENDITURE 37150.00 9179.24- 24.7- 46329.24
TRAlfSFERS OUT TO OTHER FUNDS .00 .00 .00
EXCESS <REVENUE> EXPENDITURE 37150.00 9179.24- 24.7- 46329.24
e ft
BGLl 04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/17/94 REVENUES VERSUS EXPENDITURE 15.21.00
FOR THE
PERIOD 7/93 THROUGH 1/94
ENTERPRISE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 1611177.00- 1533682.44- 9~.2 77494.56~
TOTAL REVENUE 1611177.00- 1533682.44- 95.2 77494.56-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 1532876.00 1532852.53 100.0 23.47
CITY WAGER .00 .00 .00
FINANCE DEPARTMENT 8250.00 688.75 8.3 7561. 25
ACTIVITY TOTAL 1541126.00 1533541. 28 99.5 7584.72
PUBLIC SAFETY:
DISASTER PREAPREDNESS 1140.00 .00 1140.00
ACTIVITY TOTAL 1140.00 .00 1140.00
J ,:,AHSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION 11800.00 3827.20 32.4 7972.80
SENIOR CENTER 450.00 238.14 52.9 211. 86
ACTIVITY TOTAL 12250.00 4065.34 33.2 8184.66
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 1554516.00 1537606.62 98.9 16909.38
EXCESS<REVENUE>EXPENDITURES 56661.00- 3924.18 6.9- 60585.18-
EXCESS <REVENUE> EXPENDITURE 56661.00- 3924.18 6.9- 60585.18-