HomeMy WebLinkAboutItem 4.02 FinRpt 1-97 (2)
.~r
CITY CLERK
File # D3J~~-~ill
:.
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (February 18, 1997)
SUBJECT:
~Iinancial Report For the Month of January 1997
'iV-Report Prepared by: Paul S. Rankin, Assistant City Manager
EXlUBITS ATTACHED:
Balance Sheet and Income Statements for
the Period Ending January 31, 1997
RECOMMENDATION:
Accept and file the reports.
FINANCIAL STATEMENT:
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report of the monthly financial statements for the month of
January. 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. The budget changes in the Mid
Year report approved at the City Council meeting on February 4, 1997 will be included in the February
1997 financial report.
::. Analysis of .January 1997 Revenue and Expenditure Report
TIrrough the first seven months of the fiscal year the revenue collections and expenses have been tracking
similar to the previous fiscal year. Franchise fees from utility operations will not be received until the
latter part of the fiscal year. In the expenditure category, the January report does not include expenses for
the second quarter of contract Police Services, which will be paid in February. A more detailed analysis
of General Fund Revenue and Expenditures follows.
General Fund Revenues
Total General Fund Revenues collected through January are comparable to what occurred in the first
seven months of the previous Fiscal Year. The City had collected through January 1997 approximately
54% of the total General Fund Revenues compared to approximately 51 % in the prior Fiscal Year.
Taxes: Property Taxes to date are comparable to the amount received in the same period in the prior year.
Although Sales Tax is tracking at levels ahead of the prior year, a major portion of the sales tax collected
is a result of the Christmas retail sales season. The City will not receive reports of sales for that period
until March of 1997. At this point in the Fiscal Year the sales of new and used automobiles have
remained strong and contributed towards offsetting any declines in other retail sectors. Transient
Occupancy Taxes are up from the amount reported for the previous fiscal year due to increased business at
the hotel.
..
Licenses and Permits: The largest part of the Licenses & Permits category is Building Permits. As of
January 1997 the City had collected 52% of the amount budgeted for this category. Most of the revenues
------------------~------------------------------------------------
COPIES TO:
ITEM NO.
4.2
G\agenda \agfinrpt\f)'97\1296ag.doc
~.
~. ,,-~-".
, .:., .,....
remaining to be collected relate to major projects which may not occur until the Spring Construction
season.
This category also includes Business Licenses which have a renewal date of October 1, 1996. As of ,
January 31, 1997 the City had collected $73,029 in Business License Revenue. This was a 1% increase .'.
over the amount collected for the same period in the previous Fiscal Year.
Charges for Services: Charges for Services to date are 48% of Budget compared to 51 % in the prior
Fiscal Year. This is due to lower than expected plan checking fee revenue due to delays in the
implementation of development projects in East Dublin.
Other Revenues: : Other Revenues received to date are 91 % of Budget compared to 73% in the prior
Fiscal Year. This is due to an unanticipated credit of approximately $100,000 from the Public Employees
Retirement System (PERS). The credit relates to excess contributions that occurred during the past
several years.
General Fund Expenditures
Overall, through the month of January expenditures in the General Fund totaled $ 7,765,551 and
represented approximately 48% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $629,645 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 January 1997 was below
the amounts expended for the same period in the prior Fiscal Year. As of January 31, 1996, the City had
expended 47% of the General Fund Operating Budget compared to 51 % in the prior Fiscal Year. The .
following areas contributed to the differences:
Civic Center Lease: Expenditures to date are recorded at approximately 93% of the budget compared to
100% in the same period of the prior Fiscal Year. This is partially due to the fact that the City is required
to budget the gross debt service payment, even though part of the payment is offset by funds held by the
Trustee. As of the January report the City has recorded the full amount of the debt service payment to be
made by the General Fund.
Public Safety: Expenditures to date are 35% of Budget compared to 43% in the prior Fiscal Year. This
was due largely to a difference in timing of the monthly DRFA payment. In 1996, the January report
statements included the payment of contract Fire Services costs for February 1996. Also, the current year
costs for Fire Service are anticipated to be less than budgeted due to a decision by the DRF A Board to
reduce the budget and not fund equipment replacement contributions in the final year of operation.
Culture & Leisure: Expenditures to date are 44% of Budget compared to 53% in the prior Fiscal Year.
This was due in large part to timing differences in the payment of invoices. In the prior fiscal year the 2nd
Quarter payment for Library Services, as well as contract Park Maintenance and Water charges were both
processed earlier than the current year.
Capital Improvement Projects:: Expenditures to date are 81 % of Budget compared to 14% in the prior .
Fiscal Year. This is due to completion of a significant portion of work on the projects relating to the .....
Dougherty Hills Slope Repair and the A.nnual Street Overlay during the first half of Fiscal Year 1996-97.
It is recommended that the City Council receive and file these reports as authorized by Section 41004 of
the California Government Code.
/"
! fi;.4
lp?" .
C'
:r
.
.
..
.A-c!
'"J?"""\-,. . .At,-'.-, ..c.
. ..~' .".- . .' .
". ..' . ; -,~._....._ . -OJ:- .
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF JANUARY 1997
Prepared by
The Finance Department
February 5, 1997
EXHIBIT 1
'f~'
.- ....J.' ~..: _ :-.
City of Dublin 1996.97 YTD Revenues and Budget Comparison
For the Period Ending January 31, 1997- Unaudited
Total General Fund
Revenues
Property Taxes
Sales Taxes
Transient
Occupancy Taxes
Franchise Taxes
Licenses and
Permits
Interest and Rentals
Intergovernmental
from State
Charges for Services
Other Revenues
. ------ --, ----
54 Yo
1%
.FY
96/97
.FY
95/96
91%
.
'.
,',
FY 96/97 FY 96/97 %of FY 95/96 % of Total for
Budget YTD Actual Budget YTD Actual FY 95/96
Property Taxes 4,042,000 2.221,613 55% 2,184,232 56%
Sales Taxes 6,480,000 3,594,379 55% 3,395,338 50%
Transient Occupancy Taxes 176,000 128,069 73% 91,357 46%
Franchise Taxes 709,800 314,231 44% 202,051 33%
Licenses and Pennits 873,400 455,245 52% 223,083 48%
Interest and Rentals 1,259,600 646,468 51% 532,265 42%
Intergovernmental from State 1,085,650 607,420 56% 577,502 52%
Charges for Services 1,393,510 663,329 48% 695,568 51% ':.
Other Revenues 150,660 136,760 91% 109,837 73%
Total General Fund Revenues 16,170,620 8,767,514 54% 8,011,233 51%
217/97 10:47 g:\fred\ty97\excellfs.xls
:J..
0%
80%
100%
20%
40% 60%
58% of Year Complete
,.
-~ '~~~.'l::.: >;~~:~~.---..,
.~.~?:.:;~~~;.t\.::..,~~.>...~~#?~.,~;-~~:~~<~:,,::~ '- ':
'.: .:".:.~/I'''J,;;..
~.-.' ~~.:-~~~);;.~~.-.._" .
City of Dublin 1996-97 YTD Expenses and Budget Comparison
For the Period Endin Janua 31 1997 - Unaudited
.
Total General Fund
Expenses
~ ~~~--- ----~ ~-~ ~~~--
8%
52%
Police
100%
General Government
Civic Center Lease
Fire 66% . FY 96/97
.FY 95/96
Other Public Safety
Transportation
Health and Welfare 47%
Culture & Community
:. Services 53%
'" Community Development
Capital Improv. Projects 81%
0% 20% 40% 60% 80% 100%
58% of Year Complete
FY 96/97 FY 96/97 % of FV 95/96 % of Total for
Budget YTD Actual Budget YTD Actual FY 95/96
General Government 1.735,411 693,222 51% 604,064 54%
Civic Center Lease 1,601,965 1,496,713 93% 1,499,416 100%
Police 4,016,642 960,364 24% 905,242 26%
Fire 3,195,294 1,610,616 50% 1,960,152 66%
Other Public Safety 256,071 56,116 22% 20,907 11%
Transportation 697,277 295,150 42% 277,576 40%
Health and Welfare 14,000 6,634 47% 0 0%
Culture and Community Services 2,000,640 876,151 44% 976,568 53%
Community Development 1,762,334 940,716 53% 904,466 51%
:.. ~apitallmpro."et1lent Projects 774,608 629,645 61% 45,257 14%
Total General Fund Expenses 16,054,262 7,765,551 48% 7,395,670 52%
217/9714:11 g:VredVy97\excellfs.ld.
3
.:".''':'
.:-..'-
."
GL102 CITY OF DUBLIN PAGE 1
2/07197 BALANCE SHEET 13.25.04
FOR THE
PERIOD 7196 THRCXJGH 1/97
GENERAL SPECIAL SPECIAL CAPITAL TRUSTI T 0 T A L S .
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY MEMORANDUM ONLY ..-
FUNDS FUND S FUNDS FUNDS FUND CURRENT JUNE 30, 1996
ASSETS
CASH 3071292.76- 1997642.18 326267.24 414779.67 129172.68 203430.99- 92474.41-
CASH WITH FISCAL AGENT 132608.16 132608.16 125579.24
UNAMORTIZED BOND DISCCXJNT
INVESTMENTS AT COST 26328006.89 26328006.89 23047647.50
RECEIVABLES:TAXES
ACroJNTS (NET) 169903.57 37760.05 98536.69 306200.31 437477 .67
INTEREST
ASSESSMENTS
REWTS
WOTES
DUE FROM OTHERS 21596.01 21596.01 5967.43
INVENTORY AT COST
PREPAID ITEMS 7789.68 7789.68 7166.39
FIXED ASSETS
AMCXJNTS TO BE PROVIDED 2090500.00 2090500.00 2090500.00
TOTAL ASSETS 23434407.38 2056998.24 326267.24 513316.36 2352280.84 28683270.06 25621863.82
LIAB, FND BAL, RETWD EARNINGS .
DEPOSITS FOR PRIVATE DEVELPMNT 401582.73- 401582.73- 175583.~'" .
DEPOSITS FOR AB1600 FEES 771081.47- 771081.47- 231112.48-
DEPOSITS OTHERS 572429.71- 98536.69- 670966.40- 1056101.35-
PAYABLES:ACCCXJNTS 184403.30- 120555.85- 722.20- 305681.35- 232625.86-
INTEREST
PAYROLL 48042.66- 48042.66- 4507.73 .:
DUE TO OTHERS 140.00- 140.00- 265.00- "
DEBT INSTRUMENTS PAYABLE 2208000.00- 2208000.00- 2208000.00-
TOTAL LIABILTIES 1206598.40- 120555.85- 722.20- 869618.16- 2208000.00- 4405494.61- 3899180.37-
FUND BALANCES 22227808.98- 1936442.39- 325545.04- 356301.80 144280.84- 24277775.45- 21722683.45-
TOTAL FUND EQUITY 22227808.98- 1936442.39- 325545.04- 356301.80 144280.84- 24277775.45- 21722683.45-
TOTAL LIAB,FND BAL, RETD EARNS 23434407.38- 2056998.24- 326267.24- 513316.36- 2352280.84- 28683270.06- 25621863.82-
..
'I
~>
:.:.-
GL102 CITY OF DUBLIN PAGE 1
2/07/97 BALANCE SHEET 14.45.30
FOR THE
e PERIClO 7/96 THROOGH 1/97
INTERNAL ENTERPRISE FIXED ASSETS GENERAL lONG T 0 T A l S
SERVICE FUNDS GROOP OF TERM DEBT -.- MEMORANDUM ONLY u'
FUND ACCOONTS ACCOONT GROOP CURRENT JUNE 30, 1996
ASSETS
CASH 303230.88 1108176.64- 804945.76- 309744.05
CASH WITH FISCAL AGENT 1680552.94 1680552.94 1757988.45
UNAMORTIZED BONO DISCOONT
INVESTMENTS AT COST
RECEIVABlES:TAXES
ACCOONTS (NET)
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS 451187.86 20084069.28 510205.13 21045462.27 21361185.01
AMOONTS TO BE PROVIDED 5327970.26 5327970.26 2855403.88
TOTAL ASSETS 754418.74 20656445.58 510205.13 5327970.26 27249039.71 26284321.39
LeFND BAl, RETND EARNINGS
OE~~~ITS FOR PRIVATE DEVELPMNT
DEPOSITS OTHERS
PAYABLES:ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEBT INSTRUMENTS PAYABLE 16265000.00- 5327970.26- 21592970.26- 19825403.88-
TOTAL LIABILITIES 16265000.00- 5327970.26- 21592970.26- 19825403.88-
FUND BALANCE 404347.29- 718444.42 314097.13 618679.46'
CONTRIBUTIONS 350071.45- 5109890.00- 5459961.45- 5347612.75-
INVESTMENTS IN FIXED ASSETS 510205.13- 510205.13- 492625.30-
RETAINED EARNINGS
TOTAL FUND EQUITY 754418.74- 4391445.58- 510205.13- 5656069.45- 6458917.51-
TOTAL LIAB,FND BAL, RETD EARNS 754418.74- 20656445.58- 510205.13- 5327970_26- 27249039.71 - 26284321.39-
e.
5
GL 1 04C
2/07197
********REVENUES*******
PROPERTY TAXES
SALES TAX
REAL PROPERTY TRANSFERS
TRANSIENT OCCUPANCY TAX
FRANCHISE TAXES
LICENSES & PERMITS
FINES & FORFEITURES
USES OF MONEY AND PROPERTY
INTERGOVERNMENTAL FROM STATE
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
CITY COUNCIL 1010
CITY MANAGER 1020
CITY ATTORNEY 1030
ADMIN SERVICES 1040
BUILDING MANAGEMENT 1050
FACILITY RENTAL 1050-719
INSURANCE COST CENTER 1060
ELECTIONS COST CENTER 1070
ACTIVITY TOTAL
PUBLIC SAFETY:
POLICE 2010
CROSSING GUARDS COST 2020
ANIMAL CONTROL 2030
DISASTER PREAPREDNESS 2050
FIRE SERVICES JPA 2060
ACTIVITY TOTAL
TRANSPORTATION:
PUBLIC WORKS 3010
STREET MAINTENANCE 3020
STREET TREE MAINTENANCE 3040
STREET LANDSCAPE MAINT. 3050
ACTIVITY TOTAL
HEALTH & WELFARE:
~ASTE MANAGEMENT
CHILD CARE
5020
5030
ACTIVITY TOTAL
:ULTURE & LEISURE SERVICES:
LIBRARY SERVICES 8010
CULTURAL ACTIVITIES 8011
HERITAGE CENTER 8012
DUBLIN CEMETERY 8013
o
THE CITY OF DUBLIN STATEMENT SH~ING
REVENUES VERSUS EXPENDITURE
FOR THE
PERIOD 7/96 THROUGH 1/97
BUDGET
3968400.00-
6480000.00-
73600.00-
176000.00-
709800.00-
873400.00-
36000.00-
1259600.00-
1085650.00-
1393510.00-
114659.75-
16170619.75-
86351.00
128264.00
297973 . 00
154181.00
607227.00
321500.00
1601985.00
133550.00
6365.00
3337396.00
4016642.00
43000.00
180286.00
32785.00
3195294.00
7468007.00
320887.00
128200.00
48580.00
199610.00
697277.00
2000.00
12000.00
14000.00
205874.00
12500.00
51960.00
17160.00
GENERAL
REVENUE
CURRENT PERIOD
ACTUAL PERCENT
2158152.60-
3594379.37-
63459.81-
128068.72-
314230.93-
455244.93-
25377.79-
646467.74-
607419.98-
663328.71-
111382.34-
8767512.92-
.00
80496.53
158997.53
91232.46
318838.14
157619.68
1496712.41
83260.24
2778.38
2389935.37
960383.78
16833.39
21918.00
17366.56
1610815.63
2627317.36
171118.39
28894.37
14120.70
81016.90
295150.36
633.50
6000.00
6633.50
51468.50
10000.00
25714.26
7361. 71
54.4
55.5
86.2
72.8
44.3
52.1
70.5
51.3
55.9
47.6
97.1
54.2
62.8
53.4
59.2
52.5
49.0
93.4
62.3
43.7
71.6
23.9
39.1
12.2
53.0
50.4
35.2
53.3
22.5
29.1
40.6
42.3
31.7
50.0
47.4
25.0
80.0
49.5
42.9
FUND
VARIANCE
1810247.40-
2885620.63-
10140.19-
47931.28-
395569.07-
418155.07.
10622.21-
613132.26-
478230.02-
730181.29-
3277.41-
7403106.83-
86351. 00
47767.47
138975 .47
62948.54
288388.86
163880.32
105272.59
50289.76
3586.62
947460.63
3056258.22
26166.61
158368.00
15418.44
1584478.37
4840689.64
149768.61
99305.63
34459.30
118593.10
402126.64
1366.50
6000.00
7366.50
154405.50
2500.00
26245.74
9798.29
PAGE 1
12.55.27
.
PREVIOUS YEAR ENDING JUNE 3D, 1996
ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
386I613 .84-
6760413.09-
60181.18-
198284.00-
607146.84-
466198.72-
38792.80-
1268885.15-
1102495.65-
1372959.58-
110803.95-
15853774.80-
.00
127389.95
275833.29
161933.22
495172.80
334374.72
1499521.58
101710.52
563.52
2996499 . 60
3540387.58
43292.88
126363.14
27045.45
29m19.09
6714808.14
304830.22
140949.59
48192.39
197364.32
691336.52
.00
.00
.00
194188.00
17500.00
41860.33
16075.33
2150485.68-
3395338.43-
33745.95-
91357.00-
202050.98-
223083.27-
22594.92-
532264 .81-
5m02.49-
695567.87-
87242.14-
8011233.54-
.00
71977.14
148815.53
61927.62
250822.15
175107.49
1499417 .58
94850.60
563.52
2303481.63
905241.86
18074.07
.00
2833.58
1960152.00
2886301.51
160845.73
23.01
13163.68
103543.60
2m76.02
97094.00
10000.00
20867.85
9855.41
55.6
50.2
56.1
46.1
33.3
47.9
58.2
41.9
52.4
50.7
78.7
50.5
56.5
54.0
38.2
50.7
52.4
100.0
93.3
100.0
76.9
25.6
41.7
10.5
65.8
43.0
52.8
27.3
52.5
40.2
.00
.00
.00
50.0
57.1
49.9
61.3
1717128.16-
3365074.66-
26435.23-
106927.00-
405095.86-
243115.45-
16197.88-
736620.34 -
524993.16.
6m91.71-
23561.81-
7842541.26-
.00
55412.81
127017.76
100005..
244350..
159267 .~,..;. "
104.00
6859.92
.00
693017.97
2635145.72
25218.81
126363.14
24211.87
1017567.09
3828506.63
143984.49
140926.58
35028.71
93820.72
413760.50
.00
.00
.00
97094.00
7500.00
20992._
6219.
GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2
2/07/97 REVENUES VERSUS EXPENDITURE 12.55.27
FOR THE
PERIOO 7/96 THROUGH 1/97
. GENERAL REVENUE FUND
CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y+T-D
PARK MAINTENANCE 8020 573868.00 177151.36 30.9 396716.64 554536.91 303408.34 54.7 251128.57
COMMUNITY CABLE TV 8030 33916.00 24386.72 71.9 9529.28 23736.00 21236.00 89.5 2500.00
RECREATION ADMIN. 8040 242784.00 132795.71 54.7 1 09988.29 190175.44 98157.51 51.6 92017.93
PLAYGROUNDS 8045 109528.00 60986.15 55.7 48541.85 99908.83 55164.23 55.2 44744.60
SHANNON CENTER 8050 134604.00 71906.36 53.4 62697.64 128665.35 65977.40 51.3 62687.95
PRESCHOOL 8055 52070.00 28122.80 54.0 23947.20 48241.56 21972.26 45.5 26269.30
TEENS PROGRAM 8060 35294.00 14714.57 41.7 20579.43 29512.30 15195.07 51.5 14317 .23
ADULT SPORTS 8065 62718.00 28856.81 46.0 33861. 19 59974.79 31589.39 52.7 28385.40
YOUTH SPORTS 8066 37176.00 22879.34 61.5 14296.66 33593.09 18437.44 54.9 15155.65
SPECIAL EVENTS 8070 38930.00 18413.14 47.3 20516.86 33694.49 11441.51 34.0 22252.98
SEN lOR CENTER 8080 112578.00 45450.37 40.4 67127.63 101733.54 56377.87 55.4 45355.67
RECREATION INSTRUCTION 8090 80763.00 46548.38 57.6 34214.62 76940.68 40752.78 53.0 36187.90
ACUATICS 8100 198917.00 109395.11 55.0 89521.89 196m.22 101060.93 51.4 95712.29
ACTIVITY TOTAL 2000640.00 876151.29 43.8 1124488.71 1847109.86 978587.99 53.0 868521.87
COMMUNITY DEVELOPMENT:
PLANNING 9010 732994.00 373505.99 51.0 359488.01 838445.66 391137.01 46.7 447308.65
BUILDING SAFETY 9020 365919.00 190533.85 52.1 175385.15 263771.36 128020.70 48.5 135750.66
ENGINEERING 9030 547425.00 312509.24 57.1 234915.76 569323.23 323814.04 56.9 245509.19
ECONOMIC DEVELOPMENT 9040 115996.00 64168.93 55.3 51827.07 106703.40 61493.80 57.6 45209.60
ACTIVITY TOTAL 1762334.00 940718.01 53.4 821615.99 1778243.65 904465.55 50.9 873778.10
~ IMPROVEMENT PROJECTS:
. AL CIP PROJECTS 93NN 116113.00 31444.08 27.1 84668.92 73453.55 4249.49 5.8 69204.06
. _::;;otMUNITY IMPROVEMENTS 94NN 50000.00 367.66 .7 49632.34 84890.76 40731.04 48.0 44159.72
PARKS 95NN 406645.00 413158.15 101.6 6513.15- 59292.04 276.48 .5 59015.56
STREET CONSTRC/IMPROVHT 96NN 201850.00 184675.34 91.5 17174.66 104607.01 .00 104607.01
ACTIVITY TOTAL 774608.00 629645.23 81.3 144962.77 322243.36 45257.01 14.0 276986.35
TOT A L EXPENDITURES 16054262.00 7765551.12 48.4 8288710.88 14350241.13 7395669.71 51.5 6954571.42
EXCESS [REVENUE>EXPENDITURES 116357.75- 1001961.80- 861.1 885604.05 1503533.67- 615563.83- 40.9 887969.84-
TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 38508.75- 1015.00- 2.6 37493.75-
TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 18673.28 .00 18673.28
EXCESS [REVENUE> EXPENDITURE 116357.75- 1001961.80- 861.1 885604.05 1523369.14- 616578.B3- 40.5 906790.31-
.
1
GL 1 04C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1
2/07/97 REVENUES VERSUS EXPENDITURE 12.58.22
FOR THE
PER I 00 7/96 THROUGH 1/97
SPECIAL REVENUE FUNDS .
CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
********REVENUES*******
SALES TAX 136000.00- 86577.98- 63.7 49422.02- 141116.52- 77739.86- 55.1 63376.66-
FINES & FORFEITURES 24500.00- 12003.34- 49.0 12496.66- 24330.57- 11922.67- 49.0 12407.90-
USES OF MONEY AND PROPERTY 76830.00- .00 76830.00- 89945.79- .00 89945.79-
INTERNGOVERNMENTAL FROM STATE 523290.00- 368996.95- 70.5 154293.05- 536n4.31- 302688.59- 56.4 234035.n-
INTERGOVERNMENTAL FROM COUNTY 102655.00- 55362.00- 53.9 47293.00- 126726.00- 65680.00- 51.8 61046.00-
INTERGOVERNMENTAL FROM FEDERAL 369757.00- .00 369757.00- 1908174.78- 704337.34- 36.9 1203837.44-
CHARGES FOR SERVICES 764600.00- 397368.12- 52.0 367231.88- 820879.80- 417178.19- 50.8 403701.61-
OTHER SOURCES OF REVENUE 130350.00- 36549.00- 28.0 93801.00- 568753.12- 258938.44- 45.5 309814.68-
TOTAL REVENUE 2127982.00- 956857.39- 45.0 1171124.61- 4216650.89- 1838485.09- 43.6 2378165.80-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
BUILDING MANAGEMENT .00 .00 .00 244.70 .00 244.70
ACTIVITY TOTAL .00 .00 .00 244.70 .00 244.70
PUBLI C SAFETY:
POll CE 66061. 00 757.74 1.1 65303.26 5899.29 764.88 13.0 5134.41
TRAFFIC SIGNALS 109327.00 29580.90 27.1 79746.10 85416.04 27875 .99 32.6 57540.05
ACTIVITY TOTAL 175388.00 30338.64 17.3 145049.36 91315.33 28640.87 31.4 62674.46 , .
TRANSPORTATION: 115660:4~.
PUBLI C \KIRKS 321.00 .00 321.00 1.45 1.45 100.0
STREET MAINTENANCE 198960.00 49724.45 25.0 149235.55 163324.71 47664.26 29.2
STREET SWEEP I NG 75600.00 31799.54 42.1 43800.46 69954.11 34997.90 50.0 34956.21 ..
ACTIVITY TOTAL 274881.00 81523.99 29.7 193357.01 233280.27 82663.61 35.4 150616.66
rlEALTH & WELFARE:
WASTE MANAGEMENT 743135.00 19782.25 2.7 723352.75 1183933.08 347941.44 29.4 835991.64
743135.00 19782.25 2.7 1183933.08 347941.44 29.4 835991. 64 : '.
ACTIVITY TOTAL 723352.75
:ULTURE & LEISURE SERVICES: ..
:OMMUNITY DEVELOPMENT:
PLANNING 1275.00 .00 1275.00 .00 .00 .00 . .
ENGINEERING 98102.00 22561.47 23.0 75540.53 51425.60 17888.83 34_8 33536.77
ACTIVITY TOTAL 99377.00 22561.47 22.7 76815.53 51425.60 17888.83 34.8 33536.77
:APITAL IMPROVEMENT PROJECTS:
.-
GENERAL CIP PROJECTS .00 .00 .00 7089.00 .00 7089.00
COMMUNITY IMPROVEMENTS 168510.00 5124.98 3.0 163385.02 80111. 16 46517.16 58.1 33594.00 :
PARKS 503008.00 23129.01 4.6 479878.99 211220.20 135787.40 64.3 75432.80
STREET CONSTRUCTION/IMPROVMT 620540.00 271225.59 43.7 349314.41 1967504.82 797435.52 40.5 1170069.30
ACTIVITY TOTAL 1292058.00 299479 . 58 23.2 992578.42 2265925. 18 979740.08 43.2 1286185.10
. 0 TAL EXPENDITURES 2584839.00 453685.93 17.6 2131153.07 3826124.16 1456874.83 38.1 2369249.33
XCESS [REVENUE>EXPENOITURE 456857.00 503171.46- 110.1- 960028.46 390526.73- 381610.26- 97.7 8916.47-
RANSFERS IN FROM OTHER FUNDS .00 .00 .00 19860.59- 14897.00- 75.0 4963.59- o.
RANSFERS OUT TO OTHER FUNDS .00 .00 .00 28838.30 15912.00 55.2 12926.30 ..
'.
XCESS [REVENUE> EXPENDITURE 456857.00 503171.46- 110.1- 960028.46 381549.02- 380595.26- 99.8 953.76-
0._,.
9'
,~.';
Gl1 D4C THE CITY Of DUBLIN STATEMENT SHOWING PAGE 1
2/07/97 REVENUES VERSUS EXPENDITURE 13.02.12
FOR THE
. PER I ()[) 7196 THROUGH 1/97
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 234660.00- 122270.01- 52.1 112389.99- 318115.75- 150936.34- 47.4 167179.41-
USES OF MONEY AND PROPERTY 20280.00- 1672.49- 8.2 18607.51- 17813.47- .00 17813 .47-
OTHER SOURCES OF REVENUE 4000.00- .00 4000.00- .00 .00 .00
TOTAL REVENUE 258940.00- 123942.50- 47.9 134997.50- 335929.22- 150936.34- 44.9 184992.88-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00 .00 .00 .00
PUBLIC SAFETY:
TRFC SIGS/STREET LIGHTING 130569.00 30123.02 23.1 100445.98 180611.18 81937.79 45.4 98673.39
ACTIVITY TOTAL 130569.00 30123.02 23.1 100445.98 180611.18 81937.79 45.4 98673.39
TRANSPORTATION:
PUBLI C WORKS 7688.00 1737.85 22.6 5950.15 3947.86 1501.64 38.0 2446.22
STREET TREE MAINTENANCE 8470.00 1121.48 13.2 7348.52 8867.39 2960.79 33.4 5906.60
STREET LANDSCAPE MAINTENANCE 113800.00 38081.28 33.5 75718.72 105578.03 55219.44 52.3 50358.59
ACTIVITY TOTAL 129958.00 40940.61 31.5 89017.39 118393.28 59681.87 50.4 58711.41
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
~.ITY DEVELOPMENT:
. .' ..,;lEERING 3560.00 3023.44 84.9 536.56 3085.26 3027.96 98.1 57.30
ACTIVITY TOTAL 3560.00 3023.44 84.9 536.56 3085.26 3027.96 98.1 57.30
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 10000.00 8067.92 80.7 1932.08 27505.63 19226.03 69.9 8279.60
PARKS .00 .00 .00 .00 55.59 55.59-
STREET CONSTRUCTION/IMPROVMT 103000.00 103106.75 100.1 106.75- 7649.54 636.53 8.3 7013.01
ACTIVITY TOTAL 1 13000.00 111174.67 98.4 1825.33 35155.17 19918.15 56.7 15237.02
TOT A L EXPENDITURES 377087.00 185261. 74 49.1 191825.26 337244.89 164565.77 48.8 172679.12
EXCESS [REVENUE>EXPENDITURE 118147.00 61319.24 51.9 56827.76 1315.67 13629.43 1035.9 12313.76-
EXCESS [REVENUE> EXPENDITURE 118147.00 61319.24 51.9 56827.76 1315.67 13629.43 1035.9 12313.76-
.
9
GL 1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/07/97 REVENUES VERSUS EXPENDITURE 13.06.10
FOR THE
PERlOO 7196 THROUGH 1/97
INTERNAL SERVICE FUND .
CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
********REVENUES*******
USES OF MONEY AND PROPERTY 16300.00- .00 16300.00- 15884.33- .00 15884.33-
CHARGES FOR SERVICES 216315.00- 119791.47- 55.4 96523.53- 184255.91- 108673.65- 59.0 75582.26-
OTHER SOURCES OF REVENUE 12100.00- 1122.70- 9.3 10977.30- 29894,08- 29505.92- 98.7 388.16-
TOTAL REVENUE 244715.00- 120914.17- 49.4 123800.83- 230034.32- 138179.57- 60.1 91854.75-
****..*EXPENDI TURES.......
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTME~TAL 288082.00 92783.88 32.2 195298.12 184660.68 116676.23 63.2 67984.45
ACTIVITY TOTAL 288082.00 92783.88 32.2 195298.12 184660.68 116676.23 63.2 67984.45
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 288082.00 92783.88 32.2 195298.12 184660.68 116676,23 63.2 67984.45
EXCESS[REVENUE~EXPENOITURE 43367.00 28130.29- 64.9- 71497.29 45373.64- 21503.34- 47.4 23870.30-
EXCESS [REVENUE~ EXPENDITURE 43367.00 28130.29- 64.9- 71497.29 45373.64- 21503.34- 47.4 23870.:.
:.
10
~_..' r "~__ _ ~. ".__ ~ "
".
~f,," -
GL104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1
2/07/97 REVENUES VERSUS EXPENDITURE 13.10.27
FOR THE
. PERIOD 7/96 THROUGH 1/97
ENTERPRISE FUNDS
CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
........REVENUEs.......
USES OF MONEY AND PROPERTY 1709285.00- 395544.83- 23.1 1313740.17- 1594060.99- 1558500.02- 97.8 35560.97-
OTHER SOURCES OF REVENUE .00 5.82- 5.82 .00 .00 .00
TOTAL REVENUE 1709285.00- 395550.65- 23.1 1313734.35- 1594060.99- 1558500.02- 97.8 35560.97-
.......EXPENDITURES...**..
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 1602005.00 1231286.22 76.9 370718.78 1388507.17 1222327.25 88.0 166179.92
ADMIN SERVICES 4365.00 1000.00 22.9 3365.00 6948.40 2819.23 40.6 4129.17
ACTIVITY TOTAL 1606370.00 1232286.22 76.7 374083.78 1395455.57 1225146.48 87.8 170309.09
PUBLI C SAFETY:
DISASTER PREAPREDNESS .00 .00 .00 1226.33 .00 1226.33
ACTIVITY TOTAL .00 .00 .00 1226.33 .00 1226.33
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION .00 .00 .00 10125.56 5820.26 57.5 4305.30
SENIOR CENTER .00 .00 .00 200.00 .00 200.00
ACTIVITY TOTAL .00 .00 .00 10325.56 5820.26 56.4 4505.30
~TY DEVELOPMENT:
t '. IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 1606370.00 1232286.22 76.7 374083.78 1407007.46 1231119.65 87.5 175887.81
EXCESS [REVENUE>EXPENOITURES 102915.00- 836735.57 813.0- 939650.57- 187053.53- 327380.37- 175 .0 140326.84
TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 18673.28- .00 18673.28-
EXCESS [REVENUE> EXPENDITURE 102915.00- 836735.57 813.0- 939650.57- 205726.81 - 327380.37- 159.1 121653.56
.
-."-
J I
GL104C
2/07/97
.*******REVENUES*******
JTHER SOURCES OF REVENUE
TOTAL REVENUE
-******EXPENDITURES*******
.ENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL
'UBl! C SAFETY:
:RANSPORTATlON:
lEALTH & WELFARE:
:ULTURE & LEISURE SERVICES:
:OHHUNITY DEVELOPMENT:
:APITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS
STREET CONSTRUCTION/IMPROVHT
ACTIVITY TOTAL
. 0 TAL EXPENDITURES
.XCESS[REVENUE>EXPENDITURE
RANSFERS OUT TO OTHER FUNDS
XCESS [REVENUE> EXPENDITURE
j)-
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURE
FOR THE
PERIOD 7/96 THROUGH 1/97
PAGE 1
13.14.59
CAP IT AL
<.
IMPROVEMENT FUND
CURRENT PERIOO
BUDGET ACTUAL PERCENT VARIANCE ACTUAL
FISCAL YR
870421.00. 70429.55- 8.1 799991.45- 839611.07-
870421.00- 70429.55. 8.1 799991.45- 839611.07-
PREVIOUS YEAR ENDING JUNE 30, 1996
ACTUAL PERCENT VARIANCE
Y-T-D
;.
.00
.00
839611.07-
839611.07-
.00
.00
.00
.00
.00
.00
108500.00 5938.75 5.5 102561.25 8021.77 4218.00 52.6 3803.77
-'
789421.00 251826.36 31.9 537594.64 707259.92 220386.34 31.2 486873 . 58 .'
897921.00 257765.11 28.7 640155.89 715281.69 224604.34 31.4 490677.35 . .
897921.00 257765. " 28.7 640155.89 715281.69 224604.34 31.4 490677.35
27500.00 187335.56 681.2 159835.56- 124329.38- 224604.34 180.7- 348933.72- . .
.00 .00 .00 29531.04 .00 3:::::~~. ..
27500.00 187335.56 681.2 159835.56- 94798.34- 224604.34 236.9-
,"."
.::...
GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
2/07/97 REVENUES VERSUS EXPENDITURE 13.42.50
FOR THE
PERIOD 7/96 THROUGH 1/97
. TRUST/AGENCY FUNO
CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
........REVENUES.......
SPECIAL BENEFITS ASSESSMENTS .00 117654.79- 117654.79 234629.50- 117314.75- 50.0 117314.75-
USES OF MONEY AND PROPERTY .00 2690.94- 2690.94 11997.60- 2675.55- 22.3 9322.05-
TOTAL REVENUE .00 120345.73- 120345.73 246627.10- 119990.30- 48.7 126636.80-
.......EXPENDI TURES.......
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL .00 153314.75 153314.75- 232584.50 151269.75 65.0 81314.75
ACTIVITY TOTAL .00 153314.75 153314.75- 232584 .50 151269.75 65.0 81314.75
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOTAL EXPENDITURES .00 153314.75 153314.75- 232584.50 151269.75 65.0 81314.75
EXCESS(REVENUE)EXPENDITURE .00 32969.02 32969.02- 14042.60- 31279.45 222.7- 45322.05-
EXCESS (REVENUE) EXPENDITURE .00 32969.02 32969.02- 14042.60- 31279.45 222.7- 45322.05-
.
.
(3)