HomeMy WebLinkAboutItem 4.03 PrelimFinRpt 6-97
..
CITY CLERK
File # nl3J[3l[(iJ-~lQ]
.
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (September 16,1997)
SUBJECT: Preliminary Financial Report For the Month of July 1997
rrJv Report Prepared by: Paul S. Rankin, Assistant City Manager
EXHIBITS ATTACHED: Pro Forma Balance Sheet and Income Statements for
the Period Ending July 31, 1997
RECOMMENDATION: l!v"ry{ccept and file 1he reports. .
FINANCIAL STATEMENT: See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report of the preHminary financial statements for the month
of July. The reason that the report is presented as "preHminary" is that the final audited results of Fiscal
Year 1996/97 are not yet available. Consistent with prior reports the focus will be on General Fund
Revenues and Expenditures, which represent the most significant portion of the City's operations.
Preliminarv ReDortin2 of Information
. The auditors have just begun the :final phase of their field work necessary for the 1996/97 audit. The:final
audit results will impact the reported Fund Balance presented in the attached monthly reports. For
example, any General Fund Revenues which exceeded the 1996/97 expenditures have not been carried
forward to the 1997/98 Fund Balance. The computer program used by the City requires that all posting
entries to the prior year be complete, prior to posting the change in fund balance. Staff anticipates the
:final entries will occur by the October report, including the :final year end accrual entry for Sales Tax.
In addition, there are some expense accruals which have not been posted to Fiscal Year 1996/97 and thus
will affect comparisons of the percentage incurred in the :first month.. The scope of the changes is not
significant when compared to all general fund spending.
Analvsis ofPreliminarv Julv 1997 Revenue and Expenditure ReDort
Given that this is only the first month of the 1997/98 Fiscal Year, there is extremely limited data on which
to base any major projections or identify significant trends. For example the receipt of revenues does not
typically follow an even distribution throughout the Fiscal Year. Major amounts of Property Taxes and
Sales Taxes are not received until later in the Fiscal Year. There is also a lag with the reporting of
expenditures due to the significant amount of services provided to the City by independent contractors.
General Fund Revenues
Total General Fund Revenues collected through July are comparable to what occurred in the first month
.Of the previous Fiscal Year. The City had collected through July 1997 approximately 4% of the total
budgeted General Fund Revenues compared to approximately 5% in the prior Fiscal Year. Licenses and
Permits are lower than in the same period in the prior year due to the issuance of several building permits
-------------------------------------------------------------------
COPIES TO:
G:\MONTHFS\F'\'98'10797 AG.DOC
ITEM NO.
4.,
for the California Highlands project in the previous year. Other revenues are higher than in the same
period in the prior year due to an increase in the equity distribution payment received from ABAG.
Although this report does not typically focus on Special Revenue Funds, the impact of State Budget
deliberations is worth noting. In Fiscal Year 1996/97 the City collected approximately $69,740 in Special .
Revenues in the month of July. In the cunent Fiscal Year the City received less than $12,000 in the first
month. lIDs was due to the fact that the State is not authorized do distribute certain revenues if a State
Budget has not been adopted. With action by the Legislature in August the remittance of these fimds has
now begun.
Based upon the limited information available there were not any areas with significant deviations from the
current budget projections.
General Fund Expenditures
Overall, through the month of July expenditures in the General Fund totaled $1,003,450 and represented
approximately 6% of the total budgeted expenditures in the General Fund. Of this amount, a total of
$131 was related to Capital Improvement Projects and the remainder was related to Operating Costs
reported in the General Fund. Capital Project expenditures typically do not follow an even distribution
due to differences in project timing.
In looking at only General Fund Operating Expenditures, the activity through July 1997 was comparable
to the amounts expended for the same period in the prior Fiscal Year. As of July 31, 1997, the City had
expended 6% of the General Fund Operating Budget compared to 5% in the prior Fiscal Year. As
previously noted there are some timing differences with payment for contract services, which complicate
comparisons between one year to the next. All expenditures to date are within the authorized budget.
.
It is recommended that the City Council receive and file these reports as authorized by Section 41004 of
the California Government Code.
.
-~-
--.
. ..",
City of Dublin 1997-98 YTD Revenues and Budget Comparison
For the Period Endin July 31, 1997- Unaudited
Total General Fund 4%
. Revenues 5%
Property Taxes 0010
0%
Sales Taxes 7%
7%
Transient 0%
Occupancy Taxes 0% .FY 97/98
I Franchise Taxes 0% . FY 96/97
0%
I Licenses and Permits 4%
I 12%
I
I Interest and Rentals 0%
1%
.
Intergovernmental
from State
Other Revenues
%
Charges for Services
0%
30%
60% 90%
8% of Year Complete
120%
150%
FY 97/98 FY 97/98 %of FY96197 % of Total for
Budget YTD Actual Budget YTD Actual FY 96/97
Property Taxes 4,407,700 0 0% 0 0%
Sales Taxes .6,850,000 479,700 7% 456,100 7%
Transient Occupancy Taxes 231,000 0 0% 0 0%
Franchise Taxes 750,500 0 0% 0 0%
Ucenses and Pennits 1,043,350 37,604 4% 127,800 12%
Interest and Rentals 1,328,450 6,616 0% 9,915 1%
Intergovernmental 1,171,620 0 0% 85,616 7%
Charges for Services 1,631,918 83,488 5% 56,135 4%
. Other Revenues 487,500 114,773 24% 54,808 20%
Total General Fund Revenues 17,902,038 722,180 4% 790,374 5%
8l29I97 18:26 g:ImOI'lIhfs'lfy98\ts.xls
I
City of Dublin 1997-98 YTD Expenses and Budget Comparison
For the Period Ending July 31, 1997 - Unaudited
Police
~
I
I
Total General Fund
Expenses
General Government
Civic Center Lease
Fire
Other Public Safety
0%
1%
.FY 97/98
. FY 96/97
Transportation .
4%
3%
Health and Welfare
Culture & Community
Services
Community Development
3%
3%
Capital Improv. Projects
0%
0%
,.
0%
30%
60%
8% of Year Complete
90%
120%
FY 97198 FY 97198 %of FY 96197 % of Total for
Budget YTD Actual Budget YTD Actual FY 96197
General Government 1,808,378 152,5n 8% 133,642 8%
Civic Center Lease 1,599,919 361,627 23% 376,881 25%
Police 4,280,674 23,392 1% 12,471 0%
Fire 3,598,953 296,150 8% 0 0%
Other Public Safety 276,880 62 0% 1,595 1%
Transportation 667,372 12,786 2% 13,139 2%
Health and Welfare 17,320 0 0% 0 0%
Culture and Community Services 2,119,950 82,009 4% 64,070 3%
Community Development 2,266,885 74,847 3% 59,910 3%
Capital Improvement Projects 1.131,051 131 0% 1,857 0%
4%.
Total General Fund Expenses 17,767,382 1.003,581 6% 663.564
General Fund Operating Expenses 16,636.331 1,003,450 6% 661,707 5%
8I29If17 16;31 g:\monthfslfyllBlfula
^
.
.
.
.'. . ...
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF JULY 1997
Prepared by
The Finance Department
August 28, 1997
j
EXHIBIT 1
GL1 02
0/28/97
ASSETS
CASH
CASH WITH FISCAL AGENT
UHAMORTI ZED BOND DISCOUNT
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS (NET)
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNTS TO BE PROVIOED
TOTAl ASSETS
LIAS, FND BAL, RETND EARNINGS
DEPOSITS FOR PRIVATE DEVElPMNT
JEPOSITS FOR AB1600 FEES
JEPDSITS OTHERS
:>AYABLES:ActOUNTS
INTEREST
PAYROLL
)UE TO DTIERS
)EBT INSTRUMENTS PAYABLE
TOTAl lIABIlTIES
=UND BALANCES
TOTAl FUND EQUITY
GENERAL
REVENUE
FUNDS
CITY OF DUBLUI
BALANCE SHEET
FOR THE
PERIOD 7/97 THROUGH 7/97
SPECIAL
REVENUE
FUNDS
4029599.52- 1m735.46
27680177.42
345585.07
356.98
20093.41-
6376.05
23982802.59
472499.88-
470503.89-
408405. 75~
1171.82-
1352581.34-
22630221.25-
22630221.25-
21596.01
1795331.47
313475.4B-
313475 .48-
1481855.99-
1481855.99-
.OTAL LIAS, FHD BAL, RETll EARNS 23982802.59- 1795331.47-
'I
SPECIAL
ASSESSMENT
FUNDS
339148.94
339148.94
46744_96-
46744.96~
292403_98~
292403.98-
CAPITAL
IMPROVEMENT
FUNDS
1685333.95
98536.69
1783870.64
2204708.65-
98536.69-
9424_07-
2312669.41-
528798.77
528798.77
TRUST I
AGENCY
FUND
173892.54
135920.94
2090500.00
2400313.48
2208000.00-
2208000.00-
192313.48-
192313.4S-
339148.94- 1783870.64- 2400313.48-
PAGE 1
14.08.06
.
TOTALS
MEMORANDUM ONLY ---
CURRENT JUNE 3D, 1997
57488.63-
135920.94
27680177.42
444121.76
356.98
1502.60
6376.05
2090500.00
30301467.12
472499.88-
2204708.65-
569040.58-
778050.26-
1171.82-
2208000.00-
6233471.19-
24067995.93-
24067995.93-
67216.84-
129917.22
24268006.89
74334.65
832225 . 03
107209.14
30957.72
406140.56
4332.75
2090500.00
27876407.
178055.84-
210m.11-
556209_72-
1623084:'25~-
5957.33
477.50-
2208000.00-
4770103.09-
23106304.03-
23106304.03-
30301467.12- 27876407.12-
.
G~1(j2
8/28/97
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD 7197 THROUGH
.
INTERNAL
SERVI CE
FUND
ASSETS
CASH
CASH WITH FISCAL AGENT
UNAMORTIZED BOND DISCOUNT
420930.01
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS CNET)
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOONTS TO BE PROVIDED
4511B7.86
TOTAL ASSETS
.FND BAL, RETND EARNINGS
DEPOSITS FOR PRIVATE DEVELPMNT
DEPOSITS OTHERS
PAYABLES:ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEBT INSTRUMENTS PAYABLE
TOTAL lIABILITIES
FUND BALAN::E
CONTRIBUTIONS
INVESTMENTS IN fIXED ASSETS
RETAINED EARNINGS
TOTAL fUND EQUITY
672117.87
522046.42.
350071.45-
872117.87.
EtlTERPRISE
fUNDS
4211.16.
1682518.55
1%16208.27
2i294515.66
15919421.35-
15919421.35.
265204.31-
5109890.00-
872117.87- 21294515.66-
5375094.31-
TOTAL LIAB,FND BAl, RElll EARNS
.
~
7197
FIXED ASSETS GENERAL lONG
GROUP OF TERM DEBT
ACCOUNTS ACCOUNT GROUP
510205.13
510205.13
510205.13-
510205.13-
5327970.26
5327970.26
5327970.26-
5327970.26-
510205.13- 5327970.26-
PAGE 1
11.00.36
TOT A L S
MEMORANDUM ONLY ---
CURRENT JUNE 3D, 1997
416718.85
1682518.55
20577601.26
5327970.26
28004808.92
21247391.61.
21247391.61-
787250.73-
5459961.45-
510205.13-
6757417.31-
280308.09
1719013.14
21045462.27
5327970.26
28372753.76
588.78-
21592970.26'
21593559.04-
809028.14-
5459961.45-
510205.13-
28004808.92- 28372753.76-
6779194.72-
GL104C THE CITY OF DUBLIH STATEMEHT SH~IHG PAGE "
6/28/97 REVENUES VERSUS EXPEHDITURE 9.02.1'
FOR THE
PERIOO 7/97 THROUGH 7/97 .
GENERAL REVENUE FUND
CURREHT PERIOO PREVIOUS YEAR ENDIHG JUHE 3D, 1997
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
...."'.REVENUES*******
PROPERTY TAXES 4286000.00- .00 4286000.00- 3876823.33- .00 3876823.33-
SALES TAX 6850000.00- 479700.00- 7.0 6370300.00- 6570433.37- 456100.00- 6.9 6114333.37.
REAL PROPERTY TRANSFERS 121700.00- .00 121700.00- 114533.84' .00 114533.s.; .
TRANSIENT OCCUPANCY TAX 231000.00- .00 231000.00- 237681.09' .00 237681.09-
FRANCH I SE TAXES 750500.00- .00 750500.00- 723384.60. .00 723384.60.
LICENSES & PERMITS 1043350.00. 37603.52- 3.6 1005746.48- 1092182.95- 127799.99- 11.7 964382.96-
FINES & FORFEITURES 33200.00. 4621.88- 13.9 28578.12' 38492.21- 2753.56- 7.2 35738.65.
USES OF MONEY AND PROPERTY 1328450.00' 6616.42- .5 1321833.58' 1374024.07- 9914.65- .7 1364109.42'
INTERGOVERNMENTAL FROM STATE 1171620.00- .00 1171620.00- 1151275 .49- 85615.60' 7.4 1065659.89.
INTERGOVERNMENTAL FROM FEDERAL .00 .00 .00 974.00- .00 974.00.
CHARGES FOR SERVICES 1631918.00- 83487.71 - 5.1 1548430.29- 1339422.90. 56135.04- 4.2 1283287.86'
OTHER SOORCES OF REVENUE 454300.00- 110150.67- 24.2 344149.33- 232207.32- 52054.68- 22.4 180152.64.
TOTAL REVENUE 17902038.00- 722180.20- 4.0 17179857.80- 16751435.17- 790373.52- 4.7 15961061.65.
.......EXPENDITURE~~.-~-..
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 48564.00 .00 48564.00 27346.97 .00 27346.97
CITY CWNCn 1010 137334.00 9452.48 6.9 127881.52 12747.2.84 8327.90 6.5 119144.
CITY KANAGER 1020 334487.00 18380.52 5.5 316106.48 288443.65 15302.64 5.3 273141
CITY ATIORNEY 1030 186794.00 .00 186794.00 201718.85 .00 201718.
ADMIN SERVICES 1040 637675 . 00 33859.29 5.3 603815.71 565808.19 27119.70 4.8 538688.49
BUILDING MANAGEMENT 1050 315955.00 2032.52 .6 313922.48 329127.11 2680.14 .8 326446.97
FACILITY RENTAL 1050-719 1599919.00 361626.86 22.6 1238292.14 1496816.41 376880.55 25.2 1119935.86
INSURANCE COST CENTER 1060 146803.00 88852.38 60.5 57950.62 118766.13 80212.09 67.5 38554;04 -
ELECTIONS COST CENTER 1070 766.00 .00 766_00 20511.92 .00 20511.92
ACTIVITY TOTAL 3408297.00 514204.05 15.1 2894092.95 3176012.07 510523 .02 16.1 2665489.05
"UBLIC SAFETY:
POll CE 2010 4280674.00 23392.10 .5 4257281.90. 3790901.92 12471. 1 0 .3 3778430.82
CROSSING GUARDS COST 2020 42726.00 .00 42726.00 40926.26 .00 40926.26
AN I MAL CONTROL 2030 200124.00 .00 200124.00 110514.00 .00 110514.00
DISASTER PREAPREDNESS 2050 34030.00 62.43 .2 33967.57 25992.10 1594.56 6.1 24397 .5~
FIRE SERVICES 2060 3598953. DO 296149.85 8.2 3302803. 15 2539957.33 .00 2539957.33
ACTIVITY TOTAL 8156507.00 319604.38 3.9 1836902.62 6508291.61 14065.66 .2 64 94225 . 95
fRANSPORTATION:
PUBLI C J.OU::S 3010 366732. DO 12785.56 3.5 353946.44 319005.00 13139.32 4.1 305865.68
STREET MAINTENANCE 3020 55770.00 .00 55770.00 29045.29 .00 29045.29 - .
STREET TREE MAINTENANCE 3040 47700.00 .00 47700.00 48375.71 .00 48375.71
STREET LANDSCAPE MAINT. 3050 197170.00 .00 197170.00 213134.19 .00 213134.19 :.
ACTIVITY TOTAL 667372.00 12785.56 1.9 654586.44 609560.19 13139.32 2.2 596420.87
iEALTH & \.IELFARE:
-.
WASTE MANAGEMENT 5020 5320.00 .00 5320.00 3595 .87 .00 3595.87 . .
CH I III CARE 5030 12000.00 .00 12000.00 12000.00 .00 12000.00 ..
ACTI VITY TOTAL 17320.00 .00 17320.00 15595.87 .00 15595.87
:ULTURE & L=ISURE SERVICES:
LIBRARY SERVICES 8010 216994.00 . .00 216994.00 205874.00 .00 205874.00
CULTURAL ACTIVITIES 8011 10000.00 10000.00 100.0 .00 15000.00 .00 15000.
HER IT AGE CENTER 8012 55930.00 1710.14 3.1 54219.86 54241.01 596.56 1.1 53644
b
GL 1 04C THE CJTY OF DUBLJN STATEMENT SHOWJNG PAGE 2
8[28[97 REVENUES VERSUS EXPENDJTURE 9.02.11
FOR THE
. PERJOD 7[97 THRCXJGH 7[97
GENERAL REVENUE FUND
CURRENT PERJOD PREVJCXJS YEAR ENDJNG JUNE 30, 1997
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARJANCE
FJSCAL YR Y-T-D
DUBLIN CEMETERY 8013 16690.00 .00 16690.00 15661.93 .00 15661.93
PARI:: MAIIlTENANCE 8020 589455.00 .00 589455.00 545079.21 .00 545079.21
COMMUNI7Y CABLE TV 8030 37051-.00 .00 37051.00 34256.72 .00 34256.72
RECREATION ADMJN. 8040 256353.00 13419.71 5.2 242933.29 234707.54 10869.22 4.6 223838.32
PLAYliRCUlDS 8045 128003.00 8465.55 6.6 119537 .45 108257.69 9335 . 05 8.6 98922.64
SHANNON teNTER 8050 148006.00 4471. 14 3.0 143534.86 136213.43 4078.57 3.0 132134.86
PRESCHOOL 8055 54333.00 2707.19 5.0 51625.81 51629.57 2676.43 5.2 48953.14
TEENS J>ROGRAM 8060 35296.00 736.40 2.1 34559.60 25445.93 973.73 3.8 24472.20
ADULT SPORTS 8065 65350.00 2404.46 3.7 62945.54 60649.87 1933.86 3.2 58716.01
YOUTH SPORTS 8066 52406.00 3313.71 6.3 49092.29 39910.77 1915.09 4.8 37995.68
SPECIAL EVENTS 8070 42042.00 1495.77 3.6 40546.23 40133.97 1366.71 3.4 38767.26
SEN J OR teNTER 8080 104221.00 3031.13 2.9 101189.87 80392.97 4414.84 5.5 75978.13
RECREATION INSTRUCTION 8090 88555.00 14518.02 16.4 74036.98 89684.89 3000.10 3.3 86684 .79
AQUATICS 8100 219265.00 15735.67 7.2 203529.33 209946.85 22909.49 10.9 187037.36
ACTIVITY TOTAL 2119950.00 82008.89 3.9 2037941.11 1947086.35 64069.65 3.3 1883016.70
COMMUNJ7Y DEVELOPMENT:
PLANNING 9010 744971.00 31223.90 4.2 713747.10 659308.79 30685 .97 4.7 628622.82
BUILDING SAFETY 9020 593826.00 6504.28 1.1 587321 .72 386171.15 7063.40 1.8 379107.75
ENGINEERING 9030 781875.00 32322.22 4.1 749552.78 620566.91 17090.89 2.8 603476.02
.rJ4I C DEVELOPMENT 9040 146213.00 4796.22 3.3 141416.78 106871.69 5069.24 4.7 101802.45
ACTIVITY TOTAL 2266885.00 74846.62 3.3 2192038.38 1m918.54 59909.50 3.4 1713009.04
L IMPROVEMENT PROJECTS:
GENERAL tIP PROJECTS 93NN 560350.00 .00 560350.00 80137.74 .00 80137.74
COMMUNI7Y IMPROVEMENTS 94NN 66000.00 .00 66000.00 51681.62 ,.00 51681.62
PAR~ 95NN 192140.00 131.20 .1 192008.80 497423.22 1857.28 .4 495565.94
STREET OJNSTRCIIMPROVMT 96NN 312561.00 .00 312561.00 409250.39 .00 409250~39~
ACTIVI7Y TOTAL 1131051.00 131.20 1130919.80 1038492.97 1857.28 .2 1036635.69
lOT A L EXPENDITURES 17767382.00 1003580.70 5.6 16763801.30 15067957.60 663564 .43 4.4 14404393.17
EXCESS UR-~NUE>EXPENOITURES 134656.00- 281400.50 209.0. 416056.5o~ 1683477.57- 126509.09- 7.5 1556668.48-
TRANSFERS IN FRrJ4 OTHER FUNDS .00 .00 .00 2097. DO. .00 2097.00-
EXCESS tR:-vENUE> EXPENDITURE 134656.00- 281400.50 209.0- 416056.50- 1685574.57. 126809.09- 7.5 1558765.48-
.
1
GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE
8/28/97 REVENUES VERSUS EXPENDITURE 13.36.02
FOR THE
PERIOD 7197 THROUGH 7/97 .
SPECIAL REVENUE FUNDS
CURRENT PERlOO PREVIOUS YEAR ENDING JUNE 3D, 1997
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FI SCAL YR Y-T~D
.......6REVENUE~**
:>ROPERTY TAXES 71500.00- .00 71500.00- .00 .00 .00
>ALES TAX 159300-.00- 10476.56~ 6.6 148823 .44- 152122.48- 9626.99- 6.3 142495.49-
"INES & FORFEITURES 25000.00- .00 25000.00- 22506.62- 2105.03- 9.4 20401.59-
JSES OF MONEY AND PROPERTY 78560.00- .00 7856o.o0~ 98044 .39- .00 98D44 .39-
iNTERNGOVERNMENTAL FROM STATE 740859.0o~ 134/..71- .2 739514.29- 606015.48- 46614.52- 7.7 559400.96-
:NTERGOV:ERNMENTAL FROM COUNTY 141460.00- .00 141460.00- 143136.00- .00 143136.00-
INTERGOVERNMENTAL FROM FEDERAL 464889.00- .00 464889.00- 89148.90- .00 89148.90-
:HARGES FOR SERVI CES 739000.00~ .00 739000.00- 780801.05- .00 780801.05-
lTHER stlJRCES OF REVENUE 218000.00- .00 218000.00- 311205.00- 11394.00- 3.7 299811.00-
TOTAL REVENUE 2638568.00- 11821.27- .4 2626746.73- 2202979.92~ 69740.54- 3.2 2133239_38-
----EXPENDITURES--
;ENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00 .00 .00 .00
UBLl C SAFETY:
POll Cf 93845.00 .00 93845.00 63146.44 .00 63146.44
TRAFFIC SIGNALS 108150.00 .00 108150.00 78617.71 .00 78617.71
FIRE SERVICES OF THE JPA 75960.00 .00 75960.00 .00 .00 .00
ACTIVITY TOTAL 277955.00 .00 277955.00 141764.15 .00 141764..
RANSPDRT A TI OH:
PUBLIC ~S .00 .00 .00 24.47 .00 24.47
STREET MAINTENANCE 208910.00 .00 208910.00 215895.97 ._00 215895.97
STREET SliEEPING 80600.00 .00 80600.00 67675.22 .00 67675.22
ACTIVITY TOTAL 289510.00 .00 289510.00 283595.66 .00 283595.66 __
:AL TH & WELFARE:
WASTE MANAGEMENT 808166.00 15.00 808151.00 718827.72 .00 718827.72
ACTIVITY TOTAL 808166.00 15.00 808151.00 718827.72 .00 718827.72
JLTURE & 1..EISURE SERVICES:
PARle MAINTENANCE .00 .00 .00 7154.10 .00 7154.10
ACTIVITY TOTAL .00 .00 .00 7191.46 .00 7191.46
~NITY DEVELOPMENT:
ENGINEERING 88120.00 606.30 .7 87513.70 88980.07 1269.64 1.4 87710.43
ACTIVITY TOTAL 88120.00 606.30 .7 87513.70 88980.07 1269.64 1.4 87710.43
,PITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 241447.00 1147.10 .5 240299.90 140364.57 .00 140364.57
PARKS 191902.00 1549.60 .8 190352.40 443802.84 .00 443802.84
STREET CDNSTRUCTIDN/IMPROVMT 766610.00 .00 766610.00 336274.66 6370.19 1.9 329904.47
ACTIVITY TOTAL 1199959.00 2696.70 .2 1197262.30 920442.07 6370.19 .7 914071.88
o TAL EXPENDITURES 2670755.00 3318.00 .1 2667437.00 2160801.13 7639.83 .4 2153161.30
CESS rREVENUE>EXPENDITURE 32187.00 8503.27- 26.4- 40690.27 42178.79- 62100.71- 147.2 19921.92
ANSFERS OUT TO OTHER FUNDS .00 .00 .00 2097.00 .00 2097.00
CESS IREVENUE> EXPENDITURE 32187.00 8503.27- 26.4- 40690.27 40081. 79- 62100.71- '54.9 22018.92
.
~
GL 1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
8/28/97 REVENUES VERSUS EXPENDITURE 13.13.19
FOR THE
. PERla> 7/97 THRCllGH 7/97
SPECIAL ASSESSMENT FUNDS
c:LlRRENT PER I 00 PREVIOUS YEAR ENDING JUNE 30, 1997
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y~T~D
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 274407.00. .00 274407.00~ 242789.85~ .00 242789.85-
USES OF MONEY AND PROPERTY 13395.00. .00 13395. OO~ 18795.26~ .00 18795.26-
OTHER SOURCES OF REVENUE 2000.00' .00 2000.00. .00 .00 .00
TOT Ai REVENUE 289802.00~ .00 289802.00~ 261585.11' .00 261585.11~
~~~~"'EXPENDITURES*******
GENERAl GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00 .00 .00 .00
pUBLIC SAFETY:
TRFe SIGS/STREET LIGHTING 121705.00 1000.00 .8 120705.00 103264.91 1000.00 1.0 102264.91
ACTIVITY TOTAL 121705.00 1000.00 .8 120705.00 103264.91 1000.00 1.0 102264.91
TRANSPORT A TI ON:
PUBLIC WRI::S 1300.00 154.18 11.9 1145.82 4240.27 127.63 3.0 4112.64
STREET TREE MAINTENANCE 11410.00 .00 11410.00 5697.32 .00 5697.32
STREET LANDSCAPE MAINTENANCE 139420.00 .00 139420.00 118256.51 .00 118256.51
ACTIVITY TOTAL 152130.00 154.18 .1 151975.82 128194.10 127.63 .1 128066.47
HEALTH & WELFARE:
~ & LEISURE SERVICES:
ITY DEVELOPMENT:
INEERING 4650.00 750.00 16.1 3900.00 3193.35 .00 3193.35
ACTIVITY TOTAL 4650.00 750.00 16.1 3900.00 3193.35 .00 3193.35
CAPITAL IMPROVEMENT PROJECTS:
CClMJNITY IMPROVEMENTS 24000.00 .00 24000.00 16488.87 .00 16488.87
STREET CONSTRUCTION/IMPROVMT 45000.00 .00 45000.00 103000.00 .00 1 03000~ oq .
ACTIVITY TOTAL 69000.00 .00 69000.00 119488.87 .00 119488.87
TOT A L EXPENDITURES 347485.00 1904.18 .5 345580.82 354141.23 1127.63 .3 353013.60
EXCESS IREVENUE>EXPEND I TURE 57683.00 1904.18 3.3 55778.82. 92556.12 1127.63 1.2 91428.49
EXCESS [fL;=veNUE> EXPENDITURE 57683.00 1904.18 3.3 5577B.82 92556.12 1127.63 1.2 91428.49
.
1
GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE ,
8(28/97 REVENUES VERSUS EXPENDITURE B.40.45
FOR THE
PER I 00 7/97 THROOGH 7/97 .
CAPITAL IMPROVEMENT FUND
CURRENT PERloo PREVIOUS YEAR ENDING JUNE 30, 1997
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y.T.D
........REVENUES--.....
USES OF MONEY AND PROPERTY .00 .00 .00 32293.87. .00 32293.87.
OTHER SOURCES OF REVENUE 288941;!'.00- .00 2889412.00- 70429.55- .00 70429.55-
TOTAL REVENUE 2889412.00- .00 2889412.00- 102723.42- .00 102723.42-
~**EXPENDITURES.&&....
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00 .00 .00 .00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULlURE & LEISURE SERVICES:
RECREATION ADMINISTRATION .00 .00 .00 3250.00 .00 3250.00
ACTIVITY TOTAL .00 .00 .00 3250.00 .00 3250.00
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 100000.00 .00 100000.00 9573.75 .00 9573 .75
CCMfUNITY IMPROVEMENTS 19000.00 .00 19000.00 .00 .00 .00
PARKS 239460.00 .00 239460.00 .00 .00 .00
STREET CONSTRUCTIDN/IMPROVMT 2515167.00 .00 2515167.00 449732.20 2055.15 .5 4476.
ACTIVITY TOTAL 2873627.00 .00 2873627.00 459305.95 2055.15 . .4 45725
TOT A L EXPENDITURES 2813627.00 .00 2873627.00 462555.95 2055~15 .4 460500.80
EXCEss~NUE>fXPENDITURE 15785.00- .00 15785.00- 359832.53 2055.15 .6 357777.38
EXCESS [REVENUE> EXPENDllURE 15785.00- .00 15785.00- 359832.53 2055.15 .6 357777.38
:
.'
/0
.
~- . -' -..
. .... .....-.
.....: - ~ _-r... . -r -:. ~..'
...... .
Gl104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
8/ZB/97 REVENUES VERSUS EXPENDITURE 10.14.59
fOR THE
. PERIOO 7/97 THROUGH 7/97
TRUST/AGENCY fUND
CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1997
BWGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
fISCAL YR Y-T-D
.6_~.....REVENUE~~..66..
,SPECIAL BENEfITS ASSESSMENTS .00 .00 .00 236036.28- .00 236036.28-
'USES Of tDIEY AND PROPERTY ..00 .00 .00 11496.84- .00 11496.84-
! TOTAL REVENUE .00 .00 .00 247533.12- .00 247533.12-
~
-EXJ>ENl)ITURES6 6 6 6 ......
GENERAL GOVERNMENT ACTIVITIES
~ NON-DEPARlMENTAL .00 .00 .00 232469.50 .00 232469.50
! ACTIVITY TOTAL .00 .00 .00 232469.50 .00 232469.50
;PUlL I C SAFETY:
:.TRANSPDRTATION:
~lIEALTH & YfLfARE:
~CULTURE & LEISURE SERVICES:
.:tCIMJN I TY DEVELOPMENT:
'~tAPITAL IMPROVEMENT PROJECTS:
IOTAL EXPBIDITURES .00 .00 .00 232469.50 .00 232469.50
EXCESS C REVENUE )EXPEND ITURE .00 .00 .00 15063.62- .00 15063.62-
. C~) EXPENDITURE .00 .00 .00 15063.62- .00 15063.62-
.
II
:>L104C
812B/97
444~~,.tEVENUE~44444"
SES OF MONEY AND PROPERTY
KARGES FOR SfRVI CES
THfR SClJRCfS OF REVENUE
TOTAL REVENUE
-EXPENDITURES--
5NERAl GOVERNMENT ACTIVITIES:
N~-DEPARlMEHTAl
ACTIVITY TOTAL
JBLIC SAFETY:
WSPORTATION :
:AlTH & WELFARE:
JllURE & LEISURE SERVICES:
HUUTY DEVELOPMENT:
U>ITAl IMPROVEMENT PROJECTS:
o TAL EXPBIDIUES
(CESS IRfVENUE>EXPEND ITURE
:CESS [REVENUE> EXPEND I lURE
/:1-
.... .
. .". .-..... . .
-....... ......-
. . .. ~ . .
THE CITY OF DUBLIN STATEMENT SH~ING
REVENUES VERSUS EXPENDITURE
FOR THE
PER I 00 7197 THROUGH 7/97
BlIlGET
13750.00-
243411-.00-
500.00-
257661.00-
266250.00
266250.00
266250.00
8589.00
8589.00
INTERNAL
SERV I Cf
CURRENT PERlOO
ACTUAL PERCENT
.00
24905.08- 10.2
.00
24905.08- 9.7
8510.00 3.2
8510.00 3.2
8510.00
16395.08-
3.2
190.9-
16395.08- 190.9-
FUND
VARIANCE
13750.00-
218505.92-
500.00-
232755.92-
257740.00
257740.00
257740.00
24984.08
24984.08
".'.. -
Ow.. ...
PAGE 1
9.36.3'
.
PREVIOUS YEAR ENDING JUNE 3D, 1997
ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y~T~O
18137.65-
211049.81-
21901.75.
251089.21-
121763.11
121763.11
121654.87
129434.34~
129434.34-
.00
'4004.19-
.00
14004.19-
8385.47
8385.47
6.6
18137.65-
197045.62-
21901. 75-
237085.02-
5.6
6.9
6.9
113377.64
113377.64
8385.47 6.9 113269.40
5618.72- 4.3 123815.62~
5618.72- 4.3 123815..
:
.'
:.'
.
.;
.,... r _ .. + . . . .. . ~'. . _ . . ." -
..... .-. '.--'
.".. .
GL104C THE CITY OF OUSLIN STATEMENT SH~ING PAGE ,
8J2B/97 REVENUES VERSUS EXPENDITURE 9.49.59
FOR THE
. PERI 00 7/97 THROUGH 7/97
ENTERPRISE FUNDS
CURRENT PER I 00 PREVIOUS YEAR ENDING JUNE 3D, 1997
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
F1 SCAL YR Y-T-P
..~~~~~~KEVENUESA~~~~~A
USES OF MONEY AND PROPERTY 1708264.00- 361626.86- 21.2 1346637.14- 1557743.46. 381511.15- 24.5 1176232.31 -
TOTAL REVENUE 1708264.00- 361626.86- 21.2 1346637 .14. 1557743.46- 381511.15- 24.5 1176232.31-
. ....-exPENDITURES...... ~...I.
GENERAL GOVERNMENT ACTIVITIES:
NON-PEPARlMENTAL 1599939.00 69115.73 4.3 1530823.27 1699147.23 71609.88 4.2 1627537.35
~ ADM I N SERVI CES 4260.00 .00 4260.00 4194.20 1000.00 23.8 3194.20
ACTIVITY TOTAL 1604199.00 69115.73 4.3 1535083.27 1703341.43 72609.88 4.3 1630731.55
; l'UBLIt SAFETY:
: llAN~TATIDN:
~HEAl.TH & YElFARE:
{DJLTURE & LEISURE SERVICES:
; tofIIUNITY DEVELOPMENT:
~ CAPITAL ItlP'RDVEMENT PROJECTS:
: lOT A L EXPENDITURES 1604199.00 69115.73 4.3 1535083.27 1703341.43 72609. B8 4.3 1630731.55
, "EXCESS [REYfNUE>EXPEND IlURES 104065.00- 292511.13- 281.1 188446.13 145597.97 308901.27- 212.2- 454499.24
EXCESS ~NUE> EXPENDITURE 104065.00- 292511.13- 281.1 188446.13 145597.97 308901.27- 212.2- 454499.24
.
.
1:P