HomeMy WebLinkAbout4.08 Financial Statements 01-31-1989 SSO-5a
CITY OF DUBLIN
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: February 13, 1989
SUBJECT Financial Statements for January, 1989
EXHIBITS ATTACHED Balance Sheets and Income Statements
RECOMMENDATIO14a.K/Accept and approve January Financial Statements
DESCRIPTION See attached.
--------------------------------------------------------------------------
COPIES TO:
ITEM NO. 46
OF General Funds
�ITCITY DUBLIN ' S
Cumulative REVENUES Vs .EXPENDITURES
Millions
14
12
1Q
budgeted expenditure
' 8
® actual expenditures
estimated revenues
6
® actual receipts
4
2
Q
July August September October November December January
p.s. molina 12-05-88
GL102 CITY OF DUBLIN PAGE 1
2/03/89 BALANCE SHEET 14.08.27
FOR THE
PERIOD 7/88 THROUGH 1/89 _ ----------.--_--..-- -.--.
GENERAL SPECIAL. SPECIAL CAPITAL ENTERPRISE
REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS
FUNDS FUNDS FUNDS FUNDS
ASSETS
CASH 6858467.53- 1780477.73 540179.17 1428232.37 3401790.75
UNWORTIZED BOND DISCOUNT
INVESTMENTS AT COST 13895487.37 1772391.10
RECEIVABLES:TAXES
ACCOUNTS (NET) 2204.38- 119879.17-
INTEREST 50499.00
ASSESSMENTS 575971.43
RENTS
NOTES
DUE FROM OTHERS 145289.99 2093692.56 50499.00
INVENTORY AT COST
PREPAID ITEMS 2717.00-
FIXED ASSETS 11893496.33
AMOUNTS TO BE PROVIDED
TOTAL ASSETS 7177388.45 1780477.73 996271.43 3521924.93 17168676.18
LIAB, FND BAL, RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPMNT 287251.38-
DEPOSITS OTHERS 50836.33- 3125.00-
PAYABLFS:A000UNTS
INTEREST
PAYROLL PAYROLL 1708.65-
DUE TO OTHERS 1089.09 119881.89- 1500.00- 2112038.95-
DEBT INSTRUMENTS PAYABLE 715000.00- 17286093.00-
TOTAL LIABILTIES 340156.51- 119881.89- 719625.00- 2112038.95- 17286093.00-
FUND BALANCES 6837731.94- 1660595.84- 276646.43- 1409885.98- 117416.82
CONTRIBUTIONS
INVESTMENTS IN FIXED ASSETS
RETAINED EARNINGS
TOTAL FUND EQUITY 6837231.94- 1660595.84- 276&16.43- 1409885.93- 117416.82
TOTAL LIAB,FND BAL, RETD EARNS 7177388:45- 1780477.73- 996271.43- 3521924.93- 17168676.18-
GL102 CITY OF DUBLIN PAGE 1
2/G3/89 BALANCE SHEET 10.45.38
FOR THE
PERIOD 7/88 THROUGH 1/89 __._. .
INTERNAL TP.UST/AGENCY FIXED ASSETS
SERVICE FUND GROUP OF
FUND ACCOUNTS
ASSETS
CASH 156050.57 116318.37
UNAMORTIZED BOND DISCOUNT
INVESIHENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS (NET)
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FRaf OTHERS
INVENTORY AT COST
PREPAID ITEFLS 8616.00
i
PLXED ASSETS 153884.21 179451.00
AMOUNTS TO BE PROVIDED
TOTAL ASSETS 318550.78 116318.37 179451.00
LIAB, FND BAL, RETND EARNINGS
I
DEPOSITS FOR PRIVATE DEVELPMNT
DEPOSITS OTHERS 97808.75-
PAYABLES:A000UNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES 97808.75-
FUND BALANCE 318550.78- 18509.62- j
C014TRIBUTIONS 63309.00-
. �
INVESTMENTS IN FIXED ASSETS 179451.00- j
RETAINED EARNINGS I(
TOTAL FUND EQUITY 318550.78- 18509.62- 179451.00- j
- I
TOTAL T.IAB,FND BAL, RETD EARNS 318550.78- 116318.37- 179451.00-
.
`I
I
i
I
T1'^ "I.TY OF DUBLIN STATEMENT SHOWING PAGE 1
GI.104 10.24.03
2/03/89 � ,VENUES VERSUS EXPENDITURE
FOR THE
PERIOD 7/88 THROUGH 1/89
GENERAL REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAI. PERCENT VARIANCE
********REVENUES*******
PROPERTY TAXES 2741700.00- 384960.23- 14.0 2356739.77-
SALES TAX 5164000.00- 2840456.25- 55.0 2323543.75-
REAL PROPERTY TRANSFERS 92140.00- 48625.24- 52.8 43514.76-
TRAl1SIENT OCCUPANCY TAX 100000.00- 58784.94- 58.8 41215.06-
FRANCHISE TAXES 301850.00- 130098.15- 43.1 171751.85-
LICENSES & PERMITS 355250.00- 114108.13- 32.1 241141.87-
FINES & FORFEITURES 20000.00- 9794.10- 49.0 10205.90-
USES OF MONEY AND PROPER71 747500.00- 719508.42- 96.3 27991.58-
INPERIIGOVERNMENTAL FROM STATE 790600.00- 511671.40- 64.7 278928.60-
CHARGES FOR SERVICES 810300.00- 313376.76- 38.7 496923.24-
O'NIER SOURCES OF REVENUE 4000.00- 22292.47- 557.3 .18292.47
TOTAL REVENUE 11127340.00- 5153676.09- 46.3 5973663.91-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 617195.00 118.00 617077.00
CITY COUNCIL 83490.00 43151.44 51.7 40338.56
CITY MANAGER 350335.00 174362.67 49.8 175972.33
CITY ATTORNEY 118700.00 43585.10 36.7 75114.90
FINANCE DEPARTMENT 159280.00 71442.53 44.9 87837.47
BUILDING MANAGEMENT 1380150.00 90459.07 6.6 1289690.93
INSURANCE COST CENTER 213125.00 164430.66 77.2 48694.34
ELECTIONS COST CENTER 2650.00 315.44 11.9 2334.56
ACTIVITY TOTAL 2924925.00 587864.91 20.1 2337060.09
PUBLIC SAFETY:
POLICE 1891910.00 660394.84 34.9 1231515.16
CROSSING GUARDS COST .00 .00 •00
ANIMAL CONTROL 43000.00 .00 43000.00
TRAFFIC SIGNALS •00 •00 '00
DISASTER PREAPREDNESS 17300.DO 1873.17 10.8 15426.83
FIRE SERVICES OF THE JPA 186-3904.00 1517617.50 81.4 347286.50
ACTIVITY TOTAL 3817114.00 2179885.51 57.1 1637228.49
TRANSPORTATION:
PUBLIC WORKS 198300.00 89192.53 45.0 109107.47
STREET MAINTENANCE 42100.00 12926.27 30.7 29173.73
STREET SWEEPING 52800.00 24649.45 46.7 28150.55
STREET 'TREE MAINTENANCE 80600.00 19492.17 24.2 61107.83
STREET LANDSCAPE MAINTENANCE 158560.00 79017.40 49.8 79542.60
PA*RATRANSIT SERVICES 2000.00 .00 2000.00
ACTIVITY TOTAL 531360.00 225277.82 42.2 309082.18
HEALTH & WELFARE:
VECTOR CONTROL 20500.00 10053.04 49.0 10.146.92
ACTIVITY TOTAL 20500.00 10053.08 49.0 10446.92
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES 110315.00 53156.00 48.2 51159.00
PARR MAINTENANCE 368600.00 177861.07 48.3 190738.93
COMMUNITY CABLE TV 28500.00 13750.00 48.2 14750.00
RECREATION ADMINISTRATION 119603.00 61936.67 51.8 57666.33
GL104 'TY OF DUBLIN STATEMENT SHOWING PAGE 2
2/03/89 VENUES VERSUS EXPE2NlITURE 10.24.03
FOR T11F
PERIOD 7/88 THROUGH 1/89
GENERAL REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
PLAYGROUNDS 60655.00 30119.42 49.7 30535.58
SHANNON CENTER. 60823.00 29823.24 49.0 30999.76
PRESCHOOL 32708.00 13693.68 41.9 19014.32
TEENS PROGRAM 16398.00 4126.85 25.2 12271.15
FIELD SCIIEDULING 3668.00 1293.28 35.3 2374.72
SPECIAL EVENTS 28025.00 9331.31 33.3 18693.69
SENIOR CENTER 69580.00 25321.06 36.4 44258.94
RECREATION INSTRUCTION 49787.00 22824.77 45.8 26962.23
AQUATICS 104543.00 47181.29 45.1 57361.71
ACTIVITY TOTAL 1053205.00 490418.64 46.6 562786.36
COMMUNITY DEVELOPMENT:
PLANNING 739010.00 239496.70 32.4 499513.30
BUILDING SAFETY 334385.00 145661.09 43.6 188723.91
ENGINEERING 301500.00 111823.58 37.1 189676.42
ACTIVITY TOTAL 1374895.00 496981.37 36.1 877913.63
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIF PROJECTS 63000.00 24151.18 38.3 38848.82
COtlMUNITY IMPROVEMENTS 712354.00 248212.58 34.8 464141.42
PARKS 523850.63 200171.24 38.2 323679.39
STREET CONSTRUCTION/IMPROVMT 1090294.15 341953.12 31.4 748341.03
ACTIVITY TOTAL 2389498.78 814488.12 34.1 1575010.66
T O T A L EXPENDITURES 12114497.78 4804969.45 39.7 7309528.33
EXCESS <REVEIIUE>EXPFNDITURES 987157.78 348706.64- 35.3- 1335864.42
TRANSFERS OUT TO OTHER FUNDS .00 1627611.00 1627611.00-
EXCESS <REVFSUE> EXPENDITURE 987157.78 1278904.36 129.6 291746.58-
GLI04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/03/89 3EVENUES VERSUS EXPENDITURE 10.26.16
FOR THE
PERIOD 7/88 THROUGH 1/89
SPECIAL REVENUE FUIIDS
CURREW PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SALES TAX 83000.00- 52286.00- 63.0 30714.00-
FINES & FORFEITURES 85000.00- 58531.20- 68.9 26468.80-
USES OF HONEY AND PROPERTY 40000.00- .00 40000.00-
INTF.RNGOVERNMENTAL FROM STATE 364600.00- 396475.54= 108.7 31875.54
INTERGOVERNMENTAL FROM FEDERAL 1191100.00- 532263.43- 44.7 658836.57-
CHARGES FOR SERVICES .00 3250.00- 3250.00
WHER SOURCES OF REVENUE 288000.00- 1304.25- .5 286695.75-
TOTAL REVENUE 2051700.00- 1044110.42- 50.9 1007589.58-
*******EXPEIJDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
POLICE 11550.00 2955.67 25.6 8594.33
CROSSING GUARDS COST 22950.00 .00 22950.00
TRAFFIC SIGNALS 78100.00 34124.15 43.7 43975.85
ACTIVITY TOTAL 112600.00 37079.82 32.9 75520.18
TRAIISK)RTATION:
STREET MAINTENANCE 469700.00 123848.36 26.4 345851.64
PARATRANSIT SERVICES .00 .00 .00
ACP[VITY TOTAL 469700.00 123848.36 2G.4 345851.64
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
C04@LUNITY DEVELOPMENT:
ENGIIIEER.TNG 5000.00 2000.00 40.0 3000.00
ACTIVITY TOTAL 5000.00 2000.00 40.0 3000.00
CAPITAL IMPROVEMENT PROJECTS:
COMWITTY 1MPROVEHENTS 101100.00 104060.00 102.9 2960.00-
PARKS 384200.00 530.20 .1 383669.80
STREET CONSTRUCTION/IMPROVMT 12S,1300.GO 474168.60 37.8 780131.40
ACTIVITY TOTAL 1739600.00 578758.80 33.3 1160841.20
T 0 T A 1, EXPEIIDITURES 2326900.00 741686.98 31.9 1585213.02
EXCESS <RF.VENUE>EXPENDITURE 275200.00 302423.44- 109.9- 577623.44
TRANSFERS OUT TO OTHER FUIIDS .00 .00 .00
EXCESS <REVENUE> EXPENDITURE 275200.00 302423.41- 109.9- 577623.44
GL104 TY OF DUBLIN STATEMENT S11OWING PAGE 1
2/03/89 .VENUES VERSUS EXPENDITURE 10.29.28
FOR THE
PERIOD 7/88 THROUGH 1/89 - --- ---....-------
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 363140.00- 142872.20- 39.3 220267.80-
USES OF MONEY AND PROPERTY 39200.00- .00 39200.00-
OT11ER SOURCES OF REVENUE 5000.00- .00 5000.00-
TOTAL REVENUE 407340.00- 142872.20- 35.1 264467.80-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 117638.00 117150.00 99.6 488.00
ACTIVITY TOTAL 117638.00 117150.00 99.6 488.00
PUBLIC SAFETY:
TRFC SIGS/STREET LIGHTING 144500.00 64667.05 44.8 79832.95
ACTIVITY TOTAL 144500.00 64667.05 44.8 79832.95
TRANSPORTATION:
STREET TREE MAINTENANCE 10300.00 693.36 6.7 9606.64
STREET LANDSCAPE MAINTENANCE 64250.00 17854.78 27.8 46395.22
ACTIVITY TOTAL 74550.00 18548.14 24.9 56001.86
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
PARK MAINTENANCE 13600.00 6347.28 46.7 7252.72
ACTIVITY TOTAL 13600.00 6347.28 46.7 7252.72
COMMUNITY DEVELOPMENT:
ENGINEERING 13500.00 8381.65 62.1 5118.35
ACTIVITY TOTAL 13500.00 8381.65 62.1 5118.35
CAPITAL IMPROVEMENT PROJECTS:
T O T A L EXPENDITURES 363788.00 215094.12 59.1 148693.88
EXCESS<REVENUE>EXPENDITURE 43552.00- 72221.92 165.8- 115773.92-
EXCESS <REVENUE> EXPENDITURE 43552.00- 72221.92 165.8- 115773.92-
G1,104 "ITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/03/89 ZVENUES VERSUS EXPENDITURE 10.32.35
FOR THE
PERIOD 7/88 THROUGH 1/89
INTERNAL SERVICE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 1440.00- .00 1440.00-
CHARGES FOR SERVICES 130060.00- 24417.00- 18.8 105643.00-
TOTAL REVENUE 131500.00- 24417.00- 18.6 107083.00-
*******EXPENDITURES*******
GEIJERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 116050.00 18871.10 16.3 97178.90
ACTIVITY TOTAL 116050.00 18871.10 16.3 97178.90
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMU11ITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES 116050.00 18871.10 16.3 97178.90
EXCESS<REVENUFJ EXPENDITURE 15450.00- 5545.90- 35.9 9904.10-
EXCESS <REVENUE> EXPENDITURE 15450.00- 5545.90- 35.9 9904.10-
GL164 'TTY OF DUBLIN STATROn SH0WING PAGE 1
2/03/89 VENUES VERSUS EXPENDITURE 10.36.09
FOR THE
PERIOD 7/88 THROUGH 1/89
ENTERPRISE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 1405183.00- 48091.55- 3.4 1357091.45-
TOTAL REVENUE 1405183.00- 48091.55- 3.4 1357091.45-
*******EXPEIH)ITURES*******
GENERAL GOVERNMENT ACTIVITIES:
11011-DEPARTMENTAL 1191503.00 15337.37 1.3 1176165.63
CITY MANAGER 21875.00 .00 21875.00
FINANCE DEPARTMENT 9750.00 2597.80 26.6 7152.20
xTIVITY TOTAL 1223128.00 17935.17 1.5 1205192.83
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION 13775.00 4922.50 35.7 8852.50
ACTIVITY TOTAL 13775.00 4922.50 35.7 8852.50
COMMUNITY DEVELOPMENT:
ENGINEERING .00 152500.53 152500.53-
ACTIVITY TOTAL .00 152500.53 152500.53-
CAPITAL IMPROVEMENT PROJECTS:
CIVIC CENTER COSTS 8273120.00 3688103.70 44.6 4585016.30
ACTIVITY TOTAL 8273120.00 3688103.70 44.6 4585016.30
T O T A L EXPENDITURES 9510023.00 3863461.90 40.6 5646561.10
EXCESS<REVENUFJEXPENDITURES 8104840.00 3815370.35 47.1 4289469.65
TRANSFERS IN FROM OTHER FUNDS .00 1627611.00- 1627611.00
EXCESS <REVENUE> EXPENDITURE 8104840.00 2187759.35 27.0 5917080.65
GL104 ITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/03/89 i(EVENUES VERSUS EXPENDITURE 10.39.48
FOR THE
PERIOD 7/88 THROUGH 1/89
CAPITAL IMPROVEMENT FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVE)IUES*******
USES OF MONEY AND PROPERTY .00 .00. .00
OTHER SOURCES OF REVENUE 7898.00- .00 7898.00-
TOTAL REVENUE 7898.00- .00• 7898.00-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL .00 .00 •00
ACTIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMNI'PY DEVELOPMENT:
ENGINEERING •00 .00 .00
ACTIVITY TYPAL .00 .00 .00
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 4000.00 .00 4000.00
PARRS 3898.00 8414.27 215.9 4516.27-
ACTIVITY TOTAL 7898.00 8414.27 106.5 516.27-
T 0 T A 1, EXPENDITURES 7898.00 8414.27 106.5 516.27-
EXCESS<REVENUFJ EXPENDITURE .00 8414.27 8414.27-
TRANSFERS IN FROPI OTHER FUNDS .00 .00 .00
EXCESS <REVENUE> EXPENDITURE .00 8414.27 8414.27-