HomeMy WebLinkAboutItem 4.06 Financial Report 01-31-1992 CITY OF DUBLIN
AGENDA STATEMENT
MEETING DATE: February 24, 1992
SUBJECT :Financial reports for the month of January
1992. (Report prepared by Phillip S. Molina)
EXHIBITS ��,,,,��Balance Sheets and Income Statements
RECOMMENDATIONIJIRAccept, review and file the financial reports
DESCRIPTION: The financial transactions for the period ending January 31, 1992
are presented in this report. Because of the nature of the current economy, it
is important to compare some of the current ACTUAL results of the revenue
accounts in the General Fund to the results on a year-to-date (YTD) basis of the
previous year:
YTD Same period
This year Last Year variance
Other 213,851 10,786 203,065
Franchise Taxes 189,884 49,801 140,083
Property Taxes 2,072,200 1,987,810 84,390
Licenses & Permits 154,782 143,494 11,288
Fines & Forfeitures 11,545 11,326 219
Property Transfers 31,263 35,682 (4,419)
Transient Occu. 51,515 77,801 (26,286)
Charges for Services 499,587 537,265 (37,678)
Intergovernmental 459,273 558,454 (99,181)
Uses of Assets 582,429 790,945 (208,516)
Sales Tax 2,760,788 3,297,558 (536,770)
7,027,117 7,500,922 (473,805)
Compared to last month's report, the amount of the difference between similar
periods this year compared to last year has improved by $49,144:
This Year Last year variance
TOTAL YTD December $6,019,020.00 $6,541,969.00 (522,949.00)
TOTAL YTD January $7,027,117.00 $7,500,922.00 (473,805.00)
.Change in variances 49,144.00
This improvement is due entirely from the change in the amounts reported for
Franchise Taxes. This year the City received the Cable TV Franchise payment in
January whereas last year the payment was received in early February.
Both `Sales Tax' and `Uses of Assets' continue to perform poorly when compared
to last year. Sales tax YTD allocations from the State are 83% of the amount
received last year (Current adjusted Sales Tax revenue remains at 92% of the
amount received last year at this time. ). Earnings from Uses of Assets is 73% of
last year. It is estimated though that interest earnings, which makes up 94% of
the Uses of Assets budget, can come close to the current budgeted amount if the
weighted average interest rates on the investments do not fall further.
General Fund expenditures are down compared to January 1991. Current
expenditures are $517,777 less than last year. The reason for this is in the
facility rental account and is due to a late posting of the expenditures from
the General Fund into the Enterprise fund this year when compared to last year.
The rental amount will be posted in February and as you remember is equal to the
amount of the Certificates of Participation debt service payments posted, which
equal $1,544,609. Once adjusted for this expense, the General Fund expenditures
will exceed the amount spent last year by $1,026,832.
------------------------------ -------- ---
COPIES TO: u G UE TT K-
ITEM NO. ♦6 FILE 1 N3
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF JANUARY 1992
Prepared by
The Finance Department
BGL102 CITY OF DUBLIN PAGE 1
2/12/92 BALANCE SHEET 12.13.51
FOR THE
PERIOD 7/91 THROUGH 1/92
GENERAL SPECIAL SPECIAL CAPITAL
REVENUE REVENUE BSESS14ENT IMPROVEMENT
FUNDS FUNDS FUNDS FUNDS
ASSETS
CASH 717564.38- 1047565.00 1116440.96 137470.36
CASH WITH FISCAL AGENT
UNAMORTIZED BOND DISCOUNT 1250.00
INVESTMENTS AT COST 16318000.00
RECEIVABLES:TAXES `
ACCOUNTS (NET)
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS 1295203.82
INVENTORY AT COST
PREPAID ITEMS 5935.50
FIXED ASSETS
AMOUNTS TO BE PROVIDED
TOTAL ASSETS 16902824.94 1047565.00 1116440.96 137470.36
LIAB, FND BAL, RETND Eb.RNINGS — -
DEPOSITS FOP, PRIVATE DEVEL•PMNT 49335.80-
DEPOSITS FOR AB1600 FEES - 156144.40-
DEPOSITS OTHERS 153704.05- 3125.00-
PAYABLES:A000UNTS 4234.18- 4552.00 24.00-
INTEREST
PAYROLL 8089.61
DUE TO OTHERS 1270598.35- 1500.00- 23105.47-
DEBT INSTRUMENTS PAYABLE 550000.00-
TOTAL LIABILTIES 199184.42- 1266046.35- 554649.00- 179249.87-
FUND BALANCES 16703640.52- 218481.35 561791.96- 41779.51
TOTAL FUND EQUITY 16703640.52- 218481.35 561791.96- 41779.51
TOTAL LIA.B,FND BAL, RETD EARNS 16902824.94- 1047565.00- 1116440.96- 137470.36-
BGL102 CITY OF DUBLIN PAGE 1
2/12/92 BALANCE SHEET 12.14.18
FOR THE
PERIOD 7/91 THROUGH 1/92
INTERNAL ENTERPRISE FIXED ASSETS
SERVICE FUNDS GROUP OF
FUND ACCOUNTS
ASSETS
CASH 298030.58 1578650.69-
CASH WITH FISCAL AGENT 1718575.90
UNAMORTIZED BOND DISCOUNT
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS (NET)
INTEREST 64500.15
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 8724.75 1724.03
FIXED ASSETS 182941.50 21892690.65 444274.67
AMOUNTS TO BE PROVIDED
TOTAL ASSETS 489696.83 22098840.04 444274.67
LIAB, FND BAL, RETHD EARNINGS
DEPOSITS FOR PRIVATE DEVELPMNT
DEPOSITS OTHERS
PAY.ABLES:A000UNTS 457.68-
INTEREST
PAYROLL
DUE TO OTHERS
DEBT INSTRUMENTS PAYABLE 16983728.08-
TOTAL LIABILITIES 457.68- 16983728.08-
FUND BALANCE 373240.97- 11988.96-
CONTRIBUTIONS 115998.18- 5103123.00-
INVESTMENTS IN FIXED ASSETS 444274.67-
RETAINED EARNINGS
TOTAL FUND EQUITY 489239.15- 5115111.96- 444274.67-
,
TOTAL LIAB,FND BAL, RETD EARNS 489696.83- 22098840.04- 444274.67-
BGL104 CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/12/92 REVENUES VERSUS EXPENDITURE 11.41.45
FOR THE
PERIOD 7/91 THROUGH 1/92
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
PROPERTY TAXES 4034100.00- 2072200.44- 51.4 1961899.56-
SALES TAX 6300000.00- 2760788.23- 43.8 3539211.77-
REAL PROPERTY TRANSFERS 76000.00- 31263.50- 41.1 44736.50-
TRANSIENT OCCUPANCY TAX 100000.00- 51515.00- 51.5 48485.00-
FRANCHISE TAXES 434500.00- 189884.08- 43.7 244615.92-
LICENSES & PEP14ITS 474700.00- 154782.98- 32.6 319917.02-
FINES & FORFEITURES 19500.00- 11545.34- 59.2 7954.66-
USES OF MONEY AND PROPERTY 1091100.00- 582429.07- 53.4 508670.93-
INTERNGOVERNMENTAL FROM STATE 939366.00- 459273.20- 48.9 480092.80-
CHARGES FOR SERVICES 1209905.00- 499587.53- 41.3 710317.47-
OTHER SOURCES OF REVENUE 54600.00- 213851.65- 391.7 159251.65
TOTAL REVENUE 14733771.00- 7027121.02- 47.7 7706649.98- ]
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 388867.00 289508.41 74.4 99358.59
CITY COUNCIL 1010 160669.00 69213.99 43.1 91455.01
CITY MANAGER 1020 506645.00 264352.77 52.2 242292.23
CITY ATTORNEY 1030 128250.00 96711.31 75.4 31538.69
FINANCE DEPARTMENT -- 1040 247049.00 126064.38 51.0 120984.62
DATA PROCESSING (FIN) 1045 - 35500.00 3000.00 8.5 32500.00
BUILDING MANAGEMENT 1050 363220.00 168882.22 46.5 194337.78
FACILITY RENTAL 1050-719 1720670.00 .00 1720670.00
INSURANCE COST CENTER 1060 166600.00 143108.59 85.9 23491.41
ELECTIONS COST CENTER 1070 3000.00 .00 3000.00
ACTIVITY TOTAL 3720470.00 1160841.67 31.2 2559628.33
PUBLIC SAFETY:
POLICE 2010 2794073.00 710641.40 25.4 2083431.60
CROSSING GUARDS COST 2020 33120.00 9743.03 29.4 23376.97
ANIMAL CONTROL 2030 56000.00 12554.75 22.4 43445.25
TRAFFIC SIGNALS 2040 73550.00 31901.33 43.4 41648.67
DISASTER PRE.APREDNESS 2050 42085.00 14978.26 35.6 27106.74
FIRE SERVICES JPA 2060 2578993.00 1444233.00 56.0 1134760.00
ACTIVITY TOTAL 5577821.00 2224051.77 39.9 3353769.23
TRANSPORTATION:
PUBLIC WORKS 3010 282015.00 146032.83 51.8 135982.17
STREET MAINTENANCE 3020 328100.00 35967.95 11.0 292132.05
STREET SWEEPING 3030 62000.00 30951.50 49.9 31048.50
STREET TREE MAINTENANCE 3040 66500.00 21975.04 33.0 44524.96
STREET LANDSCAPE MAINT. 3050 208850.00 93851.77 44.9 114998.23
PARATRA.NSIT SERVICES 3060 1500.00 1500.00 100.0 .00
ACTIVITY TOTAL 948965.00 330279.09 34.8 618685.91
HEALTH & WELFARE:
VECTOR CONTROL 5010 28296.00 25.00 .1 28271.00
WASTE MANAGEMENT 5020 33255.00 7961.20 23.9 25293.80
ACTIVITY TOTAL 61551.00 7986.20 13.0 53564.80
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES 8010 156007.00 78003.50 50.0 78003.50
GL104 Ta CITY OF DUBLIN STATEMENT SHOWING PAGE 2
2/12/92 REVENUES VERSUS EXPENDITURE 11.41.45
FOR THE
PERIOD 7/91 THROUGH 1/92
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
CULTURAL ACTIVITIES 8011 44140.00 22534.55 51.1 21605.45
PARK MAINTENANCE 8020 545270.00 274796.12 50.4 270473.88
COMMUNITY CABLE TV 8030 49000.00 48000.00 98.0 1000.00
RECREATION ADMIN. 8040 171625.00 90292.20 52.6 81332.80
PLAYGROUNDS 8045 66924.00 37772.45 56.4 29151.55
SHANNON CENTER 8050 105787.00 57108.78 54.0 48678.22
PRESCHOOL 8055 32057.00 17473.79 54.5 14583.21
TEENS PROGRAM 8060 47185.00 18610.99 39.4 28574.01
FIELD SCHEDULING 8065 133395.00 58273.46 43.7 75121.54
YOUTH SPORTS 8066 31739.00 10749.59 33.9 20989.41
SPECIAL EVENTS 8070 27791.00 10161.72 38.7 17029.28
SENIOR CENTER 8080 104120.00 50586.29 48.6 53533.71
RECREATION INSTRUCTION 8090 76921.00 42563.02 55.3 34357.98
AQUATICS 8100 192225.00 102585.26 53.4 89639.74
ACTIVITY TOTAL 1784186.00 920111.72 51.6 864074.28
COMMUNITY DEVELOPMENT:
PLANNIIIG 9010 1050075.00 575245.03 54.8 474829.97
BUILDING SAFETY 9020 326796.00 134312.26 41.1 192483.74
ENGINEERING 9030 429791.00 140434.37 32.7 289356.63
ECONOMIC DEVELOPMENT 9040 57250.00 5760.33 10.1 51489.67
ACTIVITY TOTAL 1863912.00 855751.99 45.9 1008160.01
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 93NN 88850.00 313.41 .4 88536.59
COMMUNITY IMPROVEMENTS 94UN 66300.00 52243.90 78.8 14056.10
PARKS 951RI 213262.00 90666.59 42.5 122595.41
STREET CONSTRC/IMPROVMT 961H1 266458.00 8027.28 3.0 258430.72
ACTIVITY TOTAL 634870.00 151251.18 23.8 483618.82
T O T A L EXPENDITURES 14591775.00 5650273.62 38.7 8941501.38
EXCESS <REVENUE>EXPENDITURES 141996.00- 1376847.40- 969.6 1234851.40
EXCESS <REVENUE> EXPENDITURE 141996.00- 1376847.40- 969.6 1234851.40
BGL104 ..r CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/12`/92 REVENUES VERSUS EXPENDITURE 11.47.00
FOR THE
PERIOD 7/91 THROUGH 1/92
SPECIAL REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SALES TAX 114000.00- 59069.34- 51.8 54930.66-
FINES & FORFEITURES 15250.00- 17853.06- 117.1 2603.06
USES OF MONEY AND PROPERTY 19360.00- .00 19360.00-
INTERNGOVERNMENTAL FROM STATE 797071.00- 536789.28- 67.3 260281.72-
INTERGOVERNMENTAL FROM FEDERAL 958558.00- 821738.41- 85.7 136819.59-
CHARGES FOR SERVICES 132065.00- 80861.41- 61.2 51203.59-
OTHER SOURCES OF REVENUE 1037300.00- 1932297.75- 186.3 894997.75
TOTAL REVENUE 3073604.00- 3448609.25- 112.2 375005.25
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 3142.00 .00 3142.00
ACTIVITY TOTAL 3142.00 .00 3142.00
PUBLIC SAFETY:
POLICE 13295.00 4519.35 34.0 8775.65
CROSSING GUARDS COST .00 .00 .00
TRAFFIC SIGNALS 15250.00 15250.00 100.0 .00
ACTIVITY TOTAL 28545.00 19769.35 69.3 8775.65
TRANSPORTATION:
STREET MAINTENANCE 151300.00 10439.39 6.9 140860.61
ACTIVITY TOTAL 151300.00 10439.39 6.9 140860.61
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 132365.00 6169.36 4.7 126195.64
ACTIVITY TOTAL 132365.00 6169.36 4.7 126195.64
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 35024.00 43174.52 123.3 8150.52-
PARKS 414678.00 86397.23 20.8 328280.77
STREET CONSTRUCTION/IMPROVMT 4192510.00 2818454.67 67.2 1374055.33
ACTIVITY TOTAL 4642212.00 2948026.42 63.5 1694185.58
T 0 T A L EXPENDITURES 4957564.00 2984404.52 60.2 1973159.48
EXCESS <REVENUE>EXPENDITURE 1883960.00 464204.73- 24.6- 2348164.73
EXCESS <REVENUE> EXPENDITURE 1883960.00 464204.73- 24.6- 2348164.73
BGL104 ..1E CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/12/92 REVENUES VERSUS EXPENDITURE 11.50.14
FOR THE
PERIOD 7/91 THROUGH 1/92
SPECIAL ASSESSMEIlT FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 391430.00- 212851.03- 54.4 178578.97-
USES OF MONEY AND PROPERTY 17400.00- .00 17400.00-
OTHER SOURCES OF REVENUE 7000.00- 26187.80- 374.1 19187.80
TOTAL REVENUE 415830.00- 239038.83- 57.5 176791.17-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
11011-DEPARTMENTAL 103813.00 103812.50 100.0 .50
ACTIVITY TOTAL 103813.00 103812.50 100.0 .50
PUBLIC SAFETY:
TRFC SIGS/STREET LIGHTING 173550.00 86416.92 49.8 87133.08
ACTIVITY TOTAL 173550.00 86416.92 49.8 87133.08
TRANSPORTATION:
STREET TREE MAINTENANCE 13100.00 2548.43 19.5 10551.57
STREET LANDSCAPE MAINTENANCE 100880.00 60272.09 59.7 40607.91
ACTIVITY TOTAL 113980.00 62820.52 55.1 51159.48
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 11000.00 3750.59 34.1 7249.41
ACTIVITY TOTAL 11000.00 3750.59 34.1 7249.41 - _
CAPITAL IMPROVEMENT PROJECTS:
STREET CONSTRUCTION/IMPROVMT 1534400.00 .00 1534400.00
ACTIVITY TOTAL 1534400.00 .00 1534400.00
T O T A L EXPENDITURES 1936743.00 256800.53 13.3 1679942.47
EXCESS<REVENUE>EXPENDITURE 1520913.00 17761.70 1.2 1503151.30
EXCESS <REVE{NJE> EXPENDITURE 1520913.00 17761.70 1.2 1503151.30
BGL104 - CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/12/92 REVENUES VERSUS EXPENDITURE 12.04.50
FOR THE
PERIOD 7/91 THROUGH 1/92
CAPITAL IMPROVEMENT FUND
CURRENT PERIOD
BUDGET ACTUAL, PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 3200.00- .00 3200.00-
OTHER SOURCES OF REVENUE 649442.00- 167529.87- 25.8 481912.13-
TOTAL REVENUE 652642.00- 167529.87- 25.7 485112.13-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS .00 .00 .00
PARKS 49592.00 31199.96 62.9 18392.04
STREET CONSTRUCTION/IMPROVMT 723850.00 82773.95 11.4 641076.05
ACTIVITY TOTAL 773442.00 113973.91 14.7 659468.09
T 0 T A L EXPENDITURES 773442.00 113973.91 14.7 659468.09
EXCESS<REVENUE>EXPENDITURE 120800.00 53555.96- 44.3- 174355.96
EXCESS <REVENUE> EXPENDITURE 120800.00 53555.96- 44.3- 174355.96
BGL104 CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/12/92 REVENUES VERSUS EXPENDITURE 11.53.42
FOR THE
PERIOD 7/91 THROUGH 1/92
INTERNAL SERVICE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 15000.00- .00 15000.00-
CHARGES FOR SERVICES 143354.00- 83266.35- 56.1 65087.65-
TOTAL REVENUE 163354.00- 83266.35- 51.0 80087.65-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
11011-DEPARTMENTAL 161069.00 54120.87 33.6 106948.13
ACTIVITY TOTAL 161069.00 54120.87 33.6 106948.13
PUBLIC SAFETY:
POLICE 16700.00 .00 16700.00
ACTIVITY TOTAL 16700.00 .00 16700.00
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE &.LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T O T A L EXPENDITURES 177769.00 54120.87 30.4 123648.13
EXCESS<REVENUE>EXPENDITURE 14415.00 29145.48- 202.2- 43560.48
EXCESS <REVENUE> EXPENDITURE 14415.00 29145.48- 202.2- 43560.48
BGL104 LSE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/12/92 REVENUES VERSUS EXPENDITURE 11.58.14
FOR THE
PERIOD 7/91 THROUGH 1/92
ENTERPRISE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY MID PROPERTY 1862699.00- .00 1862699.00-
TOTAL REVENUE 1862699.00- .00 1862699.00-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
11011-DEPARTMEIITAL 1720770.00 1544654.43 89.8 176115.57
CITY MANAGER 19465.00 18289.72 94.0 1175.28
FINANCE DEPARTMENT 10151.00 3552.65 35.0 6598.35
.A.CTIVITY TOTAL 1750386.00 1566496.80 89.5 183889.20
PUBLIC SAFETY:
DISASTER PREkPREDNESS 10900.00 .00 10900.00
ACTIVITY TOTAL 10900.00 .00 10900.00
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION 13080.00 5404.55 41.3 7675.45
SENIOR CENTER 500.00 287.24 57.4 212.76
ACTIVITY TOTAL 13580.00 5691.79 41.9 7888.21
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES' 1774866:00 1572188.59 -'88.6 202677.41
EXCESS<REVENUE>EXPENDITURES 87833.00- 1572188.59 1790.0- 1660021.59-
EXCESS <REVENUE> EXPENDITURE 87833.00- 1572188.59 1790.0- 1660021.59-