HomeMy WebLinkAbout4.10 Financial Report 05-31-1989 t
S
CITY OF DUBLIN
AGENDA STATEMENT
MEETING DATE: June 12, 1989
SUBJECT :May 1989 Financial Statements
prepared by Phillip S. Molina
RECOMMENDATION c::.. �� :Review, accept and file the Statements
DESCRIPTION :The 88-89 fiscal year is almost over. Soon
the Council will meet to discuss the budget for the coming year.
To provide some information that might be useful during your
review of the budget and to provide you with summarized.
information that identified where the City' s money came from
during the current year as well as how the City administered the
funds , I prepared two graphs .
The first graph shows all the City' s revenue received by May
31st. The information shows, for example, that over 350 of Dublin
total revenues have been generated from the sales tax paid for
merchandise purchased in Dublin. Property tax generated 210 of
total receipts.
The other graph shows the total expenditures on a cash basis
through May 31st. Notice that over half of the City' s
disbursements are for capital improvements, not surprising given
the current construction of the Civic Center. Expenditures for
costs of Public Safety is over 210 of the City' s total
expenditures .
The details for these graphs came from the Financial Statements
that are attached.
JLCM
CITY OF DUBLIN
RECEIPTS BY TYPE
as of 5/ 31 /89
for all funds
Sales Taxes
Property Transfer Tax .6%
_ I
35.8%
Property Taxes '
21 .3% Other .4%
I+ Assessments 2.8%
Charges for Services 6. 1 %
Fines & Forfeitures .8% Franchise Taxes 2.3%
Uses of Assets 10.5% From Federal 6.8%
T!-ansien.t lodging tax .8% Licenses . & permits 2%
From State 9 .7%
Molina 6/8/89
i
CITY OF DUBLIN
I
COMPARISON OF EXPENDITU RES ,
BY TYPE AS OF 5 / 31 / 89
Public Safety
Transportation 4.7% Culture & Leisure 5.1 %
i
21 .7%
Community Development 8.5% General Government 9%
Health & Welfare .1 %
50.8%
i
Capital Improvements
EXPENDITURES OF ALL FUNDS
i
j
CITY OF DUBLIN
General REVENUE Vs .EXPENDITURES
14 Millions
12
10
budgeted expenditure
8
® actual expenditures
8 - estimated revenues
® actual receipts
4
2 -
0
July Aug Sept Oct Nov Dec Jan Feb Mar April May
p.s, molina 12-08-88
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF MAY 1989
Prepared by
The Finance Department
CITY OF DUBLIN. PAGE 1
GL102 16.32.16
5/01/89 BALANCE SHEET
FOR THE
PERIOD 7/88 THROUGH 5/89
GENERAL SPECIAL SPECIAL CAPITAL ENTERPRISE
REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS
FUNDS FUNDS FUNDS FUNDS
ASSETS
CASH 3952663.31- 1528187.14 721870.73 1437473.74 1330673.23
UNAMORTIZED BOND DISCOUNT
INVESTMENTS AT COST 14390487.37 1772391.10
RECEIVABLES:TAXES
ACCOUNTS (MtET) 1625.22
INTEREST
50499.00
ASSESSMENTS 456092.26
RENTS
NOTES
DUE FROM OTHERS 15931.90- 2093692.56 50459.00
INVENTORY AT COST
PREPAID ITEMS 2467.00-
FIXED ASSETS 11893496.33
AMOUNTS TO BE PROVIDED
TOTAL ASSETS 10421050.38 1528187.14 1177962.99 3531166.30 15097558.66
LIAB, FND BAL, RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPMNT 331920.57-
DEPOSITS OTHERS 50988.79- 3125.00-
PAYABLES:A000UNTS 1449.24-
INTEREST
PAYROLL 1668.48-
DUE TO OTHERS 1089.09 8660.00- 1500.00- 2062038.95-
DEBT INSTRUMENTS PAYABLE 715000.00- 17286093.00-
TOTAL LIABILTIES 384937.99- 8660.00- 719625.00- 2062038.95- 17286093.00-
FUND BALANCES 10036112.39- 1519527.14- 458337.99- 1469127.35- 2188534.34
CONTRIBUTIONS
INVESTMENTS IN FIXED ASSETS
RETAINED EARNINGS
TOTAL FUND EQUITY 10036112.39- 1519527.14- 458337.99- 1469127.35- 2188534.34
TOTAL LIAB,FND BAL, RETD EARNS 10421050.38- 1528187.14- 1177962.99- 3531166.30- 15097558.66-
l CITY OF DUBLIN PAGE 1
GL10
6/02 BALANCE SHEET 16.33.15
FOR THE
PERIOD 7/88 THROUGH 5/89
INTERNAL TRUST/AGENCY FIXED ASSETS
SERVICE FUND GROUP OF
FUND ACCOUNTS
ASSETS
CASH 208413.79 131063.37
UNAMORTIZED BOND DISCOUNT
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS (NET)
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVEINTORY AT COST
PREPAID ITEMS 8616.00
FIXED ASSETS 153884.21 179451.00
AMOUNTS TO BE PROVIDED -
TOTAL ASSETS 370914.00 131063.37 179451.00
LIAB, FND BAL, RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPMNT
DEPOSITS OTHERS 112553.75-
PAYABLES:A000UNTS
INTEREST
PAYROLL
DUE Tv OTHERS
DEBT INSTRUMENNTS PAYABLE
TOTAL LIABILITIES 112553.75-
FUND BALANCE 370914.00- 18509.62-
CONTRIBUTIONS 63309.00-
INVESTMENTS IN FIXED ASSETS 179451.00-
RETAINED EARNINGS
TOTAL FUND EQUITY 370914.00- 18509.62- 179451.00-
TOTAL LIAB,FND BAL, RETD EARNS 370914.00- 131063.37- 179451.00-
GL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
6/01,89
REVENUES VERSUS EXPENDITURE 16.11.24
FOR THE
PERIOD 7/88 THROUGH 5/89
GENERAL REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
PROPERTY TAXES 2741700.00- 2900196.24- 105.8 158496.24
SALES TAX 51.64000.00- 4804530.06- 93.0 359469.94-
REAL PROPERTY TRANSFERS 92140.00- 84181.41- 91.4 7958.59-
TRANSIENT OCCUPANCY TAX 100000.00- 108197.25- 108.2 8197.25
FRANCHISE TAXES 301850.00- 314988.24- 104.4 _ 13138.24
LICENSES & PERMITS 355250.00- 273795.77- 77.1 81454.23-
FINES & FORFEITURES 20000.00- 15838.19- 79.2 4161.81-
USES OF MONEY AND PROPERTY 747500.00- 1249273.20- 167.1 501773.20
INTERNGOVERNMENTAL FROM STATE 790600.00- 794803.43- 100.5 4203.43
CHARGES FOR SERVICES 810300.00- 743072.82- 91.7 67227.18-
OTHER SOURCES OF REVENUE 4000.00- 30668.50- 766.7 26668.50
TOTAL REVENUE 11127340.00- 11319545.11- 101.7 192205.11
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 617195.00 60073.49 9.7 557121.51
CITY COUNCIL 83490.00 66432.83 79.6 17057.17
CITY MANAGER 350335.00 285718.92 81.6 64616.08
CITY ATTORNEY 118700.00 86679.21 73.0 32020.79
FINei+CE DEPARTMENT 159280.00 127316.49 79.9 31963.51
BUILDING MANAGEMENT 1380150.00 262706.85 19.0 1117443.15
INSURANCE COST CENTER 223925.00 180991.20 80.8 42933.80
ELECTIONS COST CENTER 2650.00 2171.12 81.9 478.88
ACTIVITY TOTAL 2935725.00 1072090.11 36.5 1863634.89
PUBLIC SAFETY:
POLICE 1891910.00 1307517.39 69.1 584392.61
CROSSING GUARDS COST .00 .00 .00
ANIMAL CONTROL 43000.00 31959.90 74.3 11040.10
TRAFFIC SIGNALS .00 .00 .00
DISASTER PREAPREDNESS 17300.00 2952.19 17.1 14347.81
FIRE SERVICES OF THE JPA 1864904.00 1864904.00 100.0 .00
ACTIVITY TOTAL 3817114.00 3207333.48 84.0 609780.52
TRANSPORTATION:
PUBLIC WORKS 198300.00 153131.30 77.2 45168.70
STREET MAINTENANCE 26100.00 22537.39 86.4 3562.61
STREET SWEEPING 52800.00 37154.10 70.4 15645.90
STREET TREE MAINTENANCE 80600.00 38689.67 48.0 41910.33
STREET LANDSCAPE MAINTENANCE 158560.00 121871.46 76.9 36688.54
PARATRANSIT SERVICES 2000.00 2000.00 100.0 .00
ACTIVITY TOTAL 518360.00 375383.92 72.4 142976.08
HEALTH & WELFARE:
VECTOR CONTROL 20500.00 14927.08 72.8 5572.92
ACTIVITY TOTAL 20500.00 14927.08 72.8 5572.92
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES 110315.00 80734.00 73.2 29581.00
PARK MAINTENANCE 368600.00 260481.95 70.7 108118.05
C0t4HbNITY CABLE TV 28500.00 27500.00 96.5 1000.00
RECREATION ADMINISTRATION 119603.00 100569.73 84.1 19033.27
'GL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2
6/01/89 REVENUES VERSUS EXPENDITURE 16.11.24
FOR THE
PERIOD 7/88 THROUGH 5/89
GENERAL REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
PLAYGROUNDS 60655.00 46005.18 75.8 14649.82
SHANNON CENTER 60823.00 46973.51 77.2 13849.49
PRESCHOOL 32708.00 25349.59 77.5 7358.41
TEENS PROGRAM 16398.00 11663.39 71.1 4734.61
FIELD SCHEDULING 3668.00 2510.69 68.4 1157.31
SPACIAL EVENTS 28025.00 19516.12 69.6 8508.88
SENIOR CENTER 69580.00 44610.03 64.1 24969.97
RECREATION INSTRUCTION 49787.00 36835.80 74.0 12951.20
AQUATICS 104543.00 74751.50 71.5 29791.50
ACTIVITY TOTAL 1053205.00 777501.49 73.8 275703.51
COMMUNITY DEVELOPMENT:
PLANNING 743010.00 584804.61 78.7 158205.39
BUILDING SAFETY 334385.00 241214.64 72.1 93170.36
ENGINEERING 301500.00 214866.80 71.3 86633.20
ACTIVITY TOTAL 1378895.00 1040886.05 75.5 338008.95
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 63000.00 29053.06 46.1 33946.94
COMMUNITY IMPROVEMENTS 720070.00 493693.89 68.6 226376.11
PARKS 887329.44 356216.05 40.1. 531113.39
STREET CONSTRUCTION/IMPROVMT 815294.15 387276.37 47.5 428017.78
ACTIVITY TOTAL 2485693.59 1266239.37 50.9 1219454.22
T 0 T A L EXPENDITURES 12209492.59 7754361.50 63.5 4455131.09
EXCESS <REVENUF>EXPENDITURES 1082152.59 3565183.61- 329.5- 4647336.20
TRANSFERS IN FROM OTHER FUNDS .00 .00 .00
TRANSFERS OUT TO OTHER FUNDS .00 1627611.00 1627611.00-
EXCESS <REVENUE> EXPENDITURE 1082152.59 1937572.61- 179.0- 3019725.20
�GL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
6/01/89
REVENUES VERSUS EXPENDITURE 16.13.43
FOR THE
PERIOD 7/88 THROUGH 5/89
SPECIAL REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SALES TAX 83000.00- 83301.00- 100.4 301.00
FINES & FORFEITURES 85000.00- 88442.97- 104.1 3442.97
USES Of' MONEY AND PROPERTY 40000.00- .00 .40000.00-
INTERNGOVERNMENTAL FROM STATE 364600.00- 533276.69- 146.3 168676.69
INTERGOVERNMENTAL FROM FEDERAL 1191100.00- 933195.65- 78.3 257904.35-
OTHER SOURCES OF REVENUE 288000.00- 4554.25- 1.6 283445.75-
TOTAL REVENUE 2051700.00- 1642770.56- 80.1 408929.44-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL .00 1523.75 1523.75-
ACTIVITY TOTAL .00 1523.75 1523.75-
PUBLIC SAFETY:
POLICE 11550.00 5664.47 49.0 5885.53
CROSSING GUARDS COST 22950.00 13362.40 58.2 9587.60
TRAFFIC SIGNALS 78100.00 46858.66 60.0 31241.34
ACTIVITY TOTAL 112600.00 65885.53 58.5 46714.47
TRANSPORTATION:
STREET MAINTENANCE 535927.00 326503.17 60.9 209423.83
PARATRANSIT SERVICES .00 .00 .00
ACTIVITY TOTAL 535927.00 326503.17 60.9 209423.83
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMM MITY DEVELOPMENT:
ENGINEERING 16566.00 2000.00 12.1 14566.00
ACTIVITY TOTAL 16566.00 2000.00 12.1 14566.00
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 101100.00 104060.00 102.9 2960.00-
PARKS 384200.00 32880.64 8.6 351319.36
STREET CONSTRUCTION/IMPROVMT 1330654.00 901271.53 67.7 429382.47
ACTIVITY TOTAL 1815954.00 1038212.17 57.2 777741.83
T O T A L EXPENDITURES 2481047.00 1434124.62 57.8 1046922.38
EXCESS <REVENUFJEXPENDITURE 429347.00 208645.94- 48.6- 637992.94
TRANSFERS OUT TO OTHER FUNDS .00 50000.00 50000.00-
EXCESS <REVENUE> EXPENDITURE 429347.00 158645.94- 37.0- 587992.94
• GL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
6/01/89 REVENUES VERSUS EXPENDITURE 16.18.08
FOR THE
PERIOD 7/88 THROUGH 5/89
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 363140.00- 383008.15- 105.5 19868.15
USES OF MONEY AND PROPERTY 39200.00- .00 39200.00-
OTHER SOURCES OF REVENUE 5000.00- .00 5000.00-
TOTAL REVENUE 407340.00- 383008.15- 94.0 24331.85-
*******EXPENDITURES*******
GENERAL GOVERNMEIFT 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 110372.83 76.4 34127.17
ACTIVITY TOTAL 144500.00 110372.83 76.4 34127.17
TRANSPORTATION:
STREET TREE MAINTENANCE 10300.00 1356.84 13.2 8943.16
STREET LANDSCAPE MAINTENANCE 64250.00 27617.35 43.0 36632.65
ACTIVITY TOTAL 74550.00 28974.19 38.9 45575.81
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
PARK MAINTENANCE 13600.00 10476.80 77.0 3123.20
ACTIVITY TOTAL 13600.00 10476.80 77.0 3123.20
COMMUNITY DEVELOPMENT:
ENGINEERING 13500.00 8381.65 62.1 5118.35
ACT MTY TOTAL 13500.00 8381.65 62.1 5118.35
CAPITAL IMPROVEMENT PROJECTS:
T O T A L EXPENDITURES 363788.00 275355.47 75.7 88432.53
EXCESS<REVENUE>EXPENDITURE 43552.00- 107652.68- 247.2 64100.68
EXCESS <REVENUE> EXPENDITURE 43552.00- 107652.68- 247.2 64100.68
GL104
THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
6/01/89 REVENUES VERSUS EXPENDITURE 16.28.47
FOR THE
. PERIOD 7/88 THROUGH 5/89
CAPITAL IMPROVEMENT FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY .00 .00 .00
OTHER SOURCES OF REVENUE 131.00- 18434.17- 4071.9 18303.17
TOTAL REVENUE 131.00- 18434.17- 4071.9 18303.17
*******EXPENDITURES*******
GENERAL GOVER1MM ACTIVITIES:
NON-DEPARTMENTAL .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
TRANSPORTATION:
STREET LANDSCAPE MAINTENANCE .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 4000.00 4000.00 100.0 .00
PARKS 11665.00 8607.07 73.8 3057.93
ACTIVITY TOTAL 15665.00 12607.07 80.5 3057.93
T O T A L EXPENDITURES 15665.00 12607.07 80.5 3057.93
EXCESS<REVENUFJEXPENDITURE 15534.00 5827.10- 37.5- 21361.10
TRANSFERS IN FROM OTHER FUNDS .00 50000.00- 50000.00
EXCESS <REVENUE> EXPENDITURE 15534.00 55827.10- 359.4- 71361.10
i
i
i
s
GL104
THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
6/01/89 REVENUES VERSUS EXPENDITURE 16.24.58
FOR THE
PERIOD 7/88 THROUGH 5/89
ENTERPRISE FUNDS
CURRENT PERIOD.
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 1405183.00- 181150.73- 12.9 1224032.27-
OTHER SOURCES OF REVENUE .00 .00 .00
TOTAL REVENUE 1405183.00- 181150.73- 12.9 1224032.27-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 1204783.00 157456.44 13.1 1047326.56
CITY MANAGER 21875.00 13075.15 59.8 8799.85
CITY ATTORNEY .00 .00 .00
FINANCE DEPARTMENT 9750.00 8314.89 85.3 1435.11
ACTIVITY TOTAL '1236408.00 178846.48 14.5 1057561.52
PUBLIC SAFETY:
TRANSPORTATION: -
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION 13775.00 11923.31 86.6 1851.69
ACTIVITY TOTAL 13775.00 11923.31 86.6 1851.69
COMMUNITY DEVELOPMENT:
ENGINEERING 249840.00 274290.76 109.8 24450.76-
ACTIVITY TOTAL 249840.00 274290.76 109.8 24450.76-
CAPITAL IMPROVEMENT PROJECTS:
CIVIC CENTER COSTS 8010000.00 5602578.05 69.9 2407421.95
ACTIVITY TOTAL 8010000.00 5602578.05 69.9 2407421.95
T O T A L EXPENDITURES 9510023.00 6067638.60 63.8 3442384.40
EXCESS<REVENi1F>EXPENDITURES 8104840.00 5886487.87 72.6 2218352.13
TRANSFERS IN FROM OTHER FUNDS .00 1627611.00- 1627611.00
TRANSFERS OUT TO OTHER FUNDS .00 .00 .00
EXCESS <REVENUE> EXPENDITURE 8104840.00 4258876.87 52.5 3845963.13
` GL104 THE CITY OF DUBLIN STATEMENT. SHOWING PAGE 1
REVENUES VERSUS EXPENDITURE 16.21.15
6/01/89
FOR THE
PERIOD 7/88 THROUGH 5/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- 93585.80- 72.0 36474.20-
TOTAL REVENUE 131500.00- 93585.80- 71.2 37914.20-
*****``EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 116050.00 35676.68 30.7 80373.32
ACTIVITY TOTAL 116050.00 35676.68 30.7 80373.32
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS,:
T O T A L EXPENDITURES 116050.00 35676.68 30.7 80373.32
EXCESS<REVENUE>EXPENDITURE 15450.00- 57909.12- 374.8 42459.12
EXCESS <REVENUE> EXPENDITURE 15450.00- 57909.12- 374.8 42459.12