HomeMy WebLinkAbout4.08 FinRpt 12-93
..
e
.
CITY OF DUBLIN
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: February 14, 1994
~~~ Financial Report For The Month of December 1993.
~_ (Prepared by: Paul S. Rankin, Assistant City Manager)
EXHIBITS ATTACHED: 1. Balance Sheet and Income Statements for the Period
Ending December 31, 1993.
RECOMMENDATION:;t()P" Accept and file the report.
FINANCIAL: See report for monthly Financial Report.
SUBJECT:
DESCRIPTION: This item provides the monthly financial statement for
the month of December 1993. 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 December the city had
collected nearly 48.2% of the budgeted General Fund Revenues as compared to
47.9%% for the same period in Fiscal Year 1993/94.
The Sales Tax revenues recorded during this month only reflect an estimated
December tax payment. The final impact of the December retail sales is
typically not known until the middle of March. As discussed in the mid
year Financial report this revenue source is anticipated to be at least
$24,000 under budget, due to the impact of the Eastern Dublin General Plan
Referendum. The Budget was predicated on the revised tax sharing
arrangement with the County. The implementation of the revised agreement
was stalled pending the outcome of the referendum election. If the Budget
for this revenue was adjusted to account for this difference, the
percentage of the budgeted amount collected as of December 31, 1993, would
be tracking with the previous year.
EXPENDITURES
Total expenditures as of December 31st 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.
The Engineering Department Expenses in the General Fund are currently
tracking at a faster pace than experienced in the previous year. As of
December 31, 1993 the General Fund Engineering Department expense is 59.1%
of its budget, as compared to 32.9% for the same period in Fiscal Year
1992/93. This is primarily attributable to less activity on capital
Improvement Projects, which increases the proportion of expense incurred
under General Engineering. 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. ~
COPIES TO:
CITY CLERK
FILE ~
e
e
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF DECEMBER 1993
Prepared by
The Finance Department
e e
BGLl02 CITY OF DUBLIN PAGE 1
2/04/94 BALANCE SHEET 14.56.15
FOR THE
PERIOD 7/93 THROUGH 12/93
GENERAL SPECIAL SPECIAL CAPITAL
REVENUE REVENUE ASSESSMENT IMPROVEMENT
FUlIDS FUNDS FUNDS FUNDS
ASSETS
CASH 1799798.12- 926902.38 486811. 22 90788.86-
CASH WITH FISCAL AGENT 121210.04
UNAMORTIZED BOND DISCOUNT 625.00
INVESTMENTS AT COST 20603948.63
RECEIVABLES: TAXES
ACCODNTS (HET) 191123.00 22343.74 110795.71
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS 13716.27
INVENTORY AT COST
PREPAID ITEMS 2342.25
FIXED ASSETS
AMOUNTS TO BE PROVIDED 2232500.00
TOTAL ASSETS 18998240.76 962962.39 2840521.26 20006.85
LIAB, FlID BAL, RETlID EARNINGS
DEPOSITS FOR PRIVATE DEVELPKNT 29551.09w
DEPOSITS FOR AB1600 FEES 143398.46-
DEPOSITS OTHERS 165173.66- 3125.oq-
PAYABLES:ACOOUNTS 218742.67-
INTEREST
PAYROLL 22616.33-
Dl;E TO OTHERS 1537.50-
DEBT INSTRUMENTS PAYABLE 2790000.00-
TOTAL LIABILTIES 218878.58- 218742.67- 2793125.00- 143398.46-
FUlID BALANCES 18779362.18- 744219.72- 47396.26- 123391.61
TOTAL FUND EQUITY 18779362.18- 744219.72- 47396.26- 123391.61
TOTAL LIAB,FHD BAL, RETD EARNS 18998240.76- 962962.39- 2840521.26~ 20006.85-
e e
001102 CITY OF DUBLIN PAGE 1
2/04/94 BAWCE SHEET 14 .59.07
FOR THE
PERIOD 7/93 THROUGH 12/93
IlrrERNAL ENTERPRISE FIXED ASSETS GENERAL LONG
SERVICE FUNDS , GROUP OF TERM DEBT
FUND ACCOUNTS ACCOUNT GROUP
ASSETS
CASH 298090.53 3664.25-
CASH WITH FISCAL AGENT 1726901. 55
UNAMORTIZED BOlID DISCOUNT
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NET)
INTEREST 46871.38
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 119.60
FIXED ASSETS 165970.10 21623460.54 470014.62
AMOUNTS TO BE PROVIDED 2548360.41
TOTAL ASSETS 464180.23 23393569.22 470014.62 2548360.41
LIAB, FND BAL, RETlID EARNINGS
DEPOSITS FOR PRIVATE DEVELPMNT
DEPOSITS OTHERS
PAYABLES:ACCOUNTS 25603.30-
INTEREST
PAYROLL
"JUE TO OTHERS
DEBT INSTRDMENTS PAYABLE 18602851.88- 2548360.41-
TOTAL LIABILITIES 18628455.18w 2548360.41-
FUND BALANCE 295922.49- 344775.96
CONTRIBUTIONS 168257.74- 5109890.00-
INVESTMENTS IN FIXED ASSETS 470014.62-
RETAINED EARNINGS
TOTAL FUND EQUITY 464180.23- 4765114.04- 470014.62-
TOTAL LIAB,FND BAL, RETD EARNS 464180.23- 23393569.22- 470014.62- 2548360.41-
e e
OOLl04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/04/94 REVENUES VERSUS EXPENDITURE 14.34.16
FOR THE
PERIOD 7/93 THROUGK 12/93
GENERAL REVENUE FUND
CURRElIT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVEHUES*******
PROPERTY TAXES 3839040.00- 2128220.44- 55.4 1710819.56-
SALES TAX 5560000.00- 2707497.61~ 48.7 2852502.39-
REAL PROPERTY TRANSFERS 73000.00- 26994.13- 37.0 46005.87-
TRANSIENT OCCUPANCY TAX 86000.00~ 47917.00- 55.7 38083.00-
FRAlICHISE TAXES 505900.00- 51839.77- 10.2 454060.23-
LICENSES & PERMITS 375600.00- 200278 .51- 53.3 175321. 49-
FINES & FORFEITURES 32000.00~ 17743.57- 55.4 , 14256.43-
USES OF MONEY AND PROPERTY 881100.00- 262362.46- 29.8 618737.54w
INTERNGOVERHMENTAL FROM STATE 964425.00- 419160.36- 43.5 545264.64-
CHARGES FOR SERVICES 714533.00- 257752.78- 36.1 456780.22-
OTHER SOURCES OF REVENUE 28100.00- 139587.90- 496.8 111487.90
TOTAL REVENUE 13059698 . OO~ 6259354.53- 47.9 6800343.47-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 45625.00 .00 45625.00
CITY COUNCIL 1010 114888.00 45690.60 39.8 69197.40
CITY MANAGER 1020 258909.00 126608.02 48.9 132300.98
CITY ATTORNEY 1030 306170.00 80814.87 26.4 225355.13
ADMIN SERVICES 1040 414253.00 180666.43 43.6 233586.57
BUILDING MANAGEMENT 1050 334867.00 134029.82 40.0 200837.18
FACILITY RENTAL 1050-719 1532816.00 .00 1532816.00
INSURANCE COST CENTER 1060 169656.00 132762.01 78.3 36893.99
ELECTIONS COST CENTER 1070 12910.00 10548.15 81.7 2361. 85
ACTIVITY TOTAL 3190094.00 711119.90 22.3 2478974.10
PUBLIC SAFETY:
POLICE 2010 3109012.00 121033.83 3.9 2987978.17
CROSSING GUARDS COST 2020 .00 .00 .00
ANIMAL CONTROL 2030 103100.00 .00 103100.00 i
TRAFFIC SIGNAlS 2040 .00 .00 .00
DISASTER PREAPREDNESS 2050 37067.00 15570.25 42.0 21496.75
FIRE SERVICES JPA 2060 2733103.00 1525553.12 55.8 1207549.88
ACTIVITY TOTAL 5982282.00 1662157.20 27.8 4320124.80
TRANSPORTATION:
PUBLIC WORKS 3010 288715.00 129700.46 44.9 159014.54
STREET MAINTENANCE 3020 165025.00 602.30 .4 164422.70
STREET TREE MAINTENANCE 3040 48960.00 17414.39 35.6 31545.61
STREET LANDSCAPE KAINT. 3050 160260.00 76405.55 47.7 83854.45
PARATRANSIT SERVICES 3060 .00 .00 .00
ACTIVITY TOTAL 662960.00 224122.70 33.8 438837.30
HEALTH & WELFARE:
VECTOR CONTROL 5010 .00 .00 .00
WASTE KANAGEMEKT 5020 100.00 .00 100.00
ACTIVITY TOTAL 100.00 .00 100.00
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES 8010 165000.00 41250.00 25.0 123750.00
CULTURAL ACTIVITIES 8011 8000.00 8000.00 100.0 .00
HERITAGE CENTER 8012 10850.00 175.23 1.6 10674.77
e e
GLl04 THE CITY OF DUBLIN STATEME}H SHOWING PAGE 2
2/04/94 REVENUES VERSUS EXPENDITURE 14.34.16
FOR THE
PERIOD 7/93 THROUGH 12/93
GENERAL REVENUE FllHD
CURREllT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
PARK MAINTENANCE 8020 591955.00 275799.51 46.6 316155.49
COHMUlfITY CABLE TV 8030 20279.00 9000.00 44.4 11279.00
RECREATION ADMIN. 8040 176453.00 84110.44 47.7 92342.56
PLAYGROUNDS 8045 80378.00 37708.72 46.9 42669.28
SHAmlON CENTER 8050 125344.00 52350.64 ~1.8 72993.36
PRESCHOOL 8055 36966.00 16089.89 43.5 20876.11
TEENS PROGRAM 8060 34350.00 12578.61 36.6 21771.39
FIELD SCHEDOLING 8065 105635.00 40755.01 38.6 64879.99
YOUTH SPORTS 8066 31043.00 12336.65 39.7 18706.35
SPECIAL EVENTS 8070 31070.00 9517.26 30.6 21552.74
SENIOR CENTER 8080 137449.00 45426.16 33.0 92022.84
RECREATION INSTRUCTION 8090 91764.00 34456.28 37.5 57307.72
AQUATICS 8100 199966.00 108715.77 54.4 91250.23
ACTIVITY TOTAL 1846502.00 788270.17 42.7 1058231.83
.HKUNITY DEVELOPMENT:
PLAllNING 9010 560879.00 235537.88 42.0 325341.12
BUILDING SAFETY 9020 256241.00 109035.86 42.6 147205.14
ENGINEERING 9030 193462.00 114421. 55 59.1 79040..45
ECONOMIC DEVELOPMENT 9040 9610.00 5312.54 55.3 4297.46
ACTIVITY TOTAL 1020192.00 464307.83 45.5 555884.17
CAPITAL IMPROVEMENT PROJECTS:
COHHUNITY IMPROVEMENTS 94HN .00 .00 .00
PARKS 95NN 20000.00 .00 20000.00
STREET CONSTRC/IMPROVHT 96}rN 37000.00 12918.52 34.9 24081. 48
ACTIVITY TOTAL 57000.00 12918.52 22.7 44081. 48
TOT A L EXPENDITURES 12759130.00 3862896.32 30.3 8896233.68
EXCESS <REVENUE>EXPEHDITURES 300568.00- 2396458.21- 797.3 2095890.21
fRANSFERS IN FROM OTHER FUNDS .00 .00 .00
TRANSFERS OUT TO OTHER FUNDS .00 29424.86 29424.86-
EXCESS <REVENUE> EXPENDITURE 300568.00- 2367033.35- 787.5 2066465.35
e e
001104 THE CITY OF DUBLIN STATEMENT SIIOWIHG PAGE 1
2/04/94 REVENUES VERSUS EXPENDITURE 14 . 37 . 05
FOR THE
PERIOD 7/93 THROUGH 12/93
SPECIAL REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SALES TAX 114000.00- 57101.38- 50.1 56898.62-
FINES & FORFEITURES 26500.00- 13996.90- 52.8 12503.10-
USES OF MONEY AND PROPERTY 16430.00~ .00 16430. O~
IHTERHGOVERlfMEHTAL FROM STATE 719440.00- 250519.27- 34.8 468920.73-
INTERGOVERNMENTAL FROM COUNTY 38265.50- 21532.00~ 56.3 16733.50-
INTERGOVERlfMEHTAL 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- 733773.96- 19.4 3049543.54-
*t*****EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL .00 .00 .00
CITY KANAGER .00 .00 .00
ACfIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
POLICE 18170.00 1991. 54 11.0 16178.46
TRAFFIC SIGNALS 93500.00 26471. 92 28.3 67028.08
ACTIVITY TOTAL 111670.00 28463.46 25.5 83206.54
TRANSPORTATION:
STREET MAINTENANCE 177865.00 121093.06 68.1 56771. 94
STREET SWEEPING 67200.00 27757.24 41.3 39442.76
STREET LANDSCAPE MAINTENANCE .00 .00 .00
ACTIVITY TOTAL 245065.00 148850.30 60.7 96214.70
HEALTH & WELFARE:
WASTE MAlfAGEMENT 572236.00 2286.55 .4 569949.45
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 116497.00 19271. 27 16.5 97225.73
ACTIVITY TOTAL 116497.00 19271. 27 16.5 97225.73
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS .00 .00 .00
COMMUNITY IMPROVEMENTS 181223.50 34108.33 18.8 147115.17
PARKS 127971.00 29717.28 23.2 98253.72
STREET COHSTRUCTIOH/IMPROVMT 2334975.00 32359.12 ,1.4 2302615.88
ACTIVITY TOTAL 2644169.50 96184.73 3.6 2547984.77
TOT A L EXPENDITURES 3689637.50 295056.31 8.0 3394581.19
EXCESS <REVENUE>EXPEHDITURE 93680.00- 438717.65- 468.3 345037.65
TRANSFERS IN FROM OTHER FUNDS .00 29424.86- 29424.86
EXCESS <REVENUE> EXPENDITURE 93680.00- 468142.51- 499.7 374462.51
e e
001104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/04/94 REVENUES VERSUS EXPENDITURE 14.40.46
FOR THE
PERIOD 7/93 THROUGH 12/93
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 523913.00- 265991.14- 50.8 257921.86-
USES OF MOKEY AND PROPERTY 28260.00- .00 28260.00-
OTHER SOURCES OF REVENUE 10400.00- 5519.94- 53.1 4880.06w
TOTAL REVENUE 562573.00- 271511.08- 48.3 291061.92~
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 650731.00 565406.00 86.9 85325.00
FINANCE DEPARTMENT .00 .00 .00
ACTIVITY TOTAL 650731. 00 565406.00 86.9 85325.00
P(lBLIC SAFETY:
TRFC SIGS/STREET LIGHTING 202300.00 76429.96 37.8 125870.04
ACTIVITY TOTAL 202300.00 76429.96 37.8 125870.04
TRANSPORTATION:
PUBLIC WORKS 1701. 00 1599.20 94.0 101. 80
STREET TREE MAINTENANCE 11350.00 2806 . 72 24.7 8543 .28
STREET LAHDSCAPE MAINTENANCE 110085.00 50429.42 45.8 59655.58
ACTIVITY TOTAL 123136.00 54835.34 44.5 68300.66
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COHMUHITY DEVELOPMENT:
ENGIlIEERIlIG 7550.00 3458.52 45.8 4091. 48
ACTIVITY TOTAL 7550.00 3458.52 45.8 4091. 48
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS .00 4500.00 4500.00-
STREET OONSTRUCTION/IMPROVHT .00 .00 .00
ACTIVITY TOTAL .00 4500.00 45oo.oo~
TOT A L EXPENDITURES 983717.00 704629.82 71.6 279087.18
EXCESS<REVElIUE>EXPENDITURE 421144.00 433118.74 102.8 11974.74-
TR.ijfSFERS OUT TO OTHER FUNDS .00 .00 .00
EXCESS <REVEIWE> EXPENDITURE 421144.00 433118.74 102.8 11974.74-
e e
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/04/94 REVENUES VERSUS EXPENDITURE 14.52.39
FOR THE
PERIOD 7/93 THROUGH 12/93
CAPITAL IMPROVEMENT FuND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 4340.00~ .00 4340.00-
OTHER SOURCES OF REVENUE 925445.00- .00 92544 5 .00-
TotAL REVENUE 929785.00- .00 929785.00-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACfIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
TRANSpORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
EIIGUJEERING 91608.00 .00 91608.00
ACTIVITY TOTAL 91608.00 .00 91608.00
CAPITAL IMPROVEMENT PROJECTS:
COHMUllITY IMPROVEMENTS 50000.00 .00 50000.00
STREET CONSTRUCTIOH/IMPROVMT 646136.00 74819.18 11.6 571316.82
ACTIVITY TOTAL 696136.00 74819.18 10.7 621316.82
TOT A L EXPENDITURES 787744.00 74819.18 9.5 712924.82
EXCESS<REVENUE>EXPENDITURE 142041. 00- 74819.18 52.7- 216860.18-
EXCESS <REVENUE> EXPENDITURE 142041.00- 74819.18 52.7~ 216860.18-
e e
BGLl04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/04/94 REVENUES VERSUS EXPENDITURE 14 . 44 . 21
FOR THE
PERIOD 7/93 THROUGH 12/93
INTERNAL SERVICE FUND
CURRENT PERIOD
BUJX;ET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 9360.00- .00 9360.00-
CHARGES FOR SERVICES 137229.00- 64172.90- 46.8 73056.10-
OTHER SOURCES OF REVENUE 4500.00- 6275.50- 139.5 1775.50
TOTAL REVENUE 151089.00- 70448.40- 46.6 80640.60-
*******EXPENDlTURES*******
GENERAL GOVERNMENT ACTIVITIES:
HOH-DEPARTMENTAL 188239.00 71426.91 37.9 116812.09
ACTIVITY TOTAL 188239.00 71426.91 37.9 ,116812.09
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
OOHHUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
TOT A L EXPENDITURES 188239.00 71426.91 37.9 116812.09
EXCESS<REVEHUE>EXPENDITURE 37150.00 978.51 2.6 36171.49
TRAltSFERS OUT TO OTHER FUNDS .00 .00 .00
EXCESS <REVENUE> EXPENDITURE 37150.00 978.51 2.6 36171. 49
. e
BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/04/94 REVENUES VERSUS EXPENDITURE 14.49.04
FOR THE
PERIOD 7/93 THROUGH 12/93
ENTERPRISE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVEHUES*******
USES OF MONEY AND PROPERTY 1611177.00- 866.61- .1 1610310.39-
TOTAL REVENUE 1611177.00- 866.61- .1 1610310.39-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON~DEPARTMEHTAL 1532876.00 36.70 1532839.30
CITY !tANAGER .00 .00 .00
FINANCE DEPARTMENT 8250.00 688.75 8.3 7561. 25
ACTIVITY TOTAL 1541126.00 725.45 1540400.55
PUBLIC SAFETY:
DISASTER PREAPREDNESS 1140.00 .00 1140.00
ACTIVITY TOTAL 1140.00 .00 1140.00
TRANSPORTATION:
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 4790.79 .3 1549725.21
EXCESS<REVEHUE> EXPENDITURES 56661.00- 3924.18 6.9- 60585.18- .
EXCESS <REVEIWE> EXPENDITURE 56661. 00- 3924.18 6.9- 60585.18-