HomeMy WebLinkAboutItem 4.06 Dec 1999 Fin Report CITY CLERK
File # 0330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (February 15, 2000)
SUBJECT:
Preliminary Financial Report For the Month of December 1999
Report Prepared by: Fred Marsh, Finance Manager
EXHIBITS ATTACHED: Pro Forms Balance Sheet and Income Statements for
the Month of December 1999
RECOMMENDATION: ~'~ Accept and file the reports.
FINANCIAL STATEMENT: See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report of the financial statements for the month of
December. 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.
Staff will provide an in depth mid-year analysis of Revenues and Expenditures as part of the Budget
Study Session on February 29, 2000. The report will identify any necessary mid-year adjustments and
current revenue and expenditure trends.
Analysis of December 1999 Revenue and Expenditure Report
The December report represents the reporting of revenues and expenditures for the six months of the
Fiscal Year. Major property tax revenues were received in December. In the expenditure category, the
December report does not include expenses for the second quarter of Police and Fire Services, which are
scheduled to be paid in February. A more detailed analysis of General Fund Revenue and Expenditures is
shown on the attached reports and discussed below.
General Fund Revenues
Total General Fund Revenues collected through December are comparable to what occurred in the six
months of the previous Fiscal Year. The City had collected through December 1999 approximately 46%
of the total budgeted General Fund Revenues compared to approximately 45% in the prior Fiscal Year.
Based upon the limited information available there were not any areas with significant deviations from the
current budget projections.
Sales Tax is higher than in the same period of the prior year. The State has raised the amount of the
monthly sales tax advances to the City as a result of the increased sales activity within the City, primarily
related to autos. It should be noted that a major portion of the annual sales tax is a result of the Christmas
retail season, for which the City will not receive data until April. Transient Occupancy Taxes are higher
than in the same period of the prior year due to additional revenues being received from the City's two
new hotels.
mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm
COPIES TO:
G:\MONTHFS\1299 agenda statement month financials.doc' ITEM NO. ~
Intergovernmental Revenue is higher than in the same period in the prior year due to an increase in the
allocation of State Motor Vehicle In Lieu Fees from the State and the receipt of a one time ERAF
repayment from the State of $63,700, out of a total of $150 million allocated by the State. The ERAF
rebate was allocated to cities based upon each city's population.
Charges for services are lower than in the same period in the prior year due to timing differences in the
recording of revenue for reimbursements received from developers for engineering plan checking
services. The amount of the revenue recorded is based upon the payments made to date to outside
contractors for these services. In the Other Revenue category, the amount budgeted to be received from
the sale of a Fire Engine to Alameda County was billed in February.
General Fund Expenditures
Overall, through the month of December expenditures in the General Fund totaled $6,504,380 and
represented approximately 28% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $266,122 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, activity through December 1999 was somewhat
below the amounts expended for the same period in the prior Fiscal Year. Through December 1999, the
City had expended 28% of the General Fund Operating Budget compared to 36% 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. Fire Services is lower than the same period in the
prior year due to timing differences in payments for contract fire services. Community Development
Expenditures are lower than in the prior Fiscal Year due to timing differences in the payment for contract
professional services related to new development.
Capital Improvements Projects expenditures are lower than in the same period of the prior year due to
expenditures incurred in the prior year for the completion of the Dougherty Hills Park Slope Repair
Capital Project. 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.
)$
Total General Fund
Revenues
City of Dublin 1999-2000 YTD Revenues and Budget Comparison
For the Period Ending December 30, 1999 - Unaudited
Property Taxes
~ 53~%
, ,, i51%
II I
Sales Taxes
49%
~% ~
Transient
Occupancy Taxes
37%
Franchise Taxes
23%
21%
Licenses and
Permits
52%
149%
Interest and Rentals
44%
43%
Intergovernmental
from State
54%
'45%
Charges for .Services
32%
~40%
Other Revenues
[] FY 1999/2000
~FY 1998/1999
0% 30% 60% 90% 120% 150%
50% of Year Complete
FY 1999/2000
Budget
Property Taxes
Sales Taxes
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental
Charges for Services
Other Revenues
5,643,600
9,200,000
580,000
872,400
3,041,520
1,223,214
1,437,181
3,917,844
855,582
Total General Fund Revenues 26,771,341
FY 1999/2000
YTD Actual
2,987,412
4,534,127
272,031
198,121
1,591,953
540,688
777,906
1,263,447
170,781
12,336,466
% of
Budget
53%
49%
47%
23%
52%
44%
54%
32%
20%
46%
FY 98/99
YTD Actual
2,607,660
3,723,094
143,547
179,593
1,212,613
580,238
606,099
1,391,583
144,479
10,588,906
% of Total for
FY 98/99
51%
43%
37%
21%
49%
43%
45%
40%
46%
45%
ATTACHMENT 1
Date Printed: 01/14/2000 10;54 AM
City of Dublin 1999-2000 YTD Expenses and Budget Comparison
For the Period Ending December 31, 1999 - Unaudited
Total General Fund Expenses
General Government
Civic Center Lease
Police
Fire
Other Public Safety
Transportation
Health and Welfare
121%
7%
-
~ ~46%
38%
Culture & Community Services 41%
_
Community Development 41%
1
Capital Improv. Projects 2~%
IFY 1999/2000
e~FY 1998/1999
0% 30% 60% 90% 120%
50% of Year Complete
General Government
Civic Center Lease
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture and Community Services
Community Development
Capital Improvement Projects
Total General Fund Expenses
General Fund Operating Expenses
FY 199912000 FY 1999/2000 % of FY 98/99
Budget YTD Actual Budget YTD Actual
2,501,322 988,425 40% 951,124
346,063
4,991,209 1,364,869 27% 1,174,610
4,209,712 778,032 18% 1,908,406
208,427 41,117 20% 52,169
827,008 316,491 38% 264,150
19,360 1,420 7% 727
3,059,288 1,162,500 38% 926,641
4,960,191 1,585,404 32% 1,465,952
2,772,546 266,122 10% 459,712
23,549,063 6,504,380 28% 7,549,554
20,776,517 6,238,258 30% 7,089,842
% of Total for
FY 98/99
44%
21%
26%
46%
27%
34%
4%
41%
41%
26%
36%
37%
ATTACHMENT 2
Date Pdnted: 02_/0412000 4:31 PM
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF DECEMBER 1999
Prepared by
The Finance Department
January 14, 2000
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Dec1999
SPECIAL SPECIAL CAPITAL TRUST/
REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUND FUND
TOTALS
---MEMORANDUM ONLY---
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
UNAMORTIZED BOND DISCOUNT
(19,262,217)
INVESTMENTS AT COST 43,592,415
RECEIVABLES: TAXES
ACCOUNTS (NE 149,497
INTEREST 205,076
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
5,849
15,637
24.706,258
LtAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL (760,273)
DEPOSITS FOR AB1600 FEES (21,813)
DEPOSITS OTHERS (422.043)
PAYABLES: ACCOUNTS (160,835)
INTEREST
PAYROLL (224,166)
DUE TO OTHERS (67,514)
DEFERRED REVENUE (149,497)
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (1,806,141)
,116)
,116)
FUND BALANCES (22,900
TOTAL FUND E (22,900
1,896.t39
311
28,347
1,924,797
(1.924.797)
(1,924,797)
362,t45 16,240,072
362.145 16.240.072
(22,040.629)
(46,074)
(5.849)
(22.092.552)
(362,145) 5.852,480
(362.145) 5,852,480
118~262 (645.600) (8.211.t29)
149,763 149.763 149,763
43.592,415 34.556,969
149.808 1,399.589
205,076 502,727
34,196 212.897
15.637 7.027
1,860,500 1,860,500 1.860.500
2.128.525 45,361,796 30.478.344
(760,273)
(22,062,441)
(422.043)
(206,909)
(224.166)
(67,514)
(155.346)
(1.978.000) (1,978,000)
(1.978,000) (25,876,693)
(150,525) (19.485,103)
(150.525) (19,485,103)
(498,812)
(4,882.178)
(468.866)
(2,895.909)
(309 574)
(150 963)
(155 346)
(1,978 000)
(11.339 647)
(19.138 697)
(19.138 697)
TOTAL LIAB. FND BAL. RETD (24,706,258) (1,924,797) (362.145) (16.240,072) (2.128,525) (45.361,796) (30.478.344)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Dec1999
FIXED ASSETS GENERAL LONG
GROUP OF TERM DEBT
ACCOUNTS ACCOUNT GROUP
TOTALS
---MEMORANDUM- - -
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
UNAMORTIZED BOND DISCOUNT
1.122.615
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
19.491,955
20.614.569
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE BEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES
FUND BALANCES (20,614,569
TOTAL FUND E (20,614,569
TOTAL LIAB. FND BAL. RETD (20,614,569
6.388.993
28.822.697
6.388.993 28.822,697
(6,388,993)
(6.388.993)
(28,822.697
(28,822.697
(6.388,993) (28.822.697
1.122.615
25,880,948
28,822,697
55,826.259
28.822.697
28.822.697
27.003.563
27,003,563
(55,826,259
City of Dublin General Fund Income Statement Showing
Revenues Versus Expenditures
For the Period 7/99 Through 12/99
Revenues
Property Taxes
Sales Taxes
Real Property Transfer Tax
Hotel Transient Occupancy Tax
Franchise Taxes
Licenses and Permits
Fines and Forfeitures
Use Money and Property - Interest
Use Money and Property - Rentals
Intergovernmental from State
Charges for Services
Other Sources of Revenue
Total Revenue
Expenditures
General Government
City Council
.City Manager
Central Services
City Attorney
Administrative Services
Building Management
Facility Rental
Insurance Cost Center
Elections Cost Center
Non Departmental
Activity Total
Public Safety Police
Crossing Guards
Animal Control
Disaster Preparedness
Fire Services
Activity Total
Transportation
Public Works
Street Maintenance
Street Sweeping
Street Tree Maintenance
Street Landscaping Maintenance
Activity Total
Health and Welfare
Waste Management
Child Care
Activity Total
Current Current Prior
Budget Actual % Variance Fiscal Year
5,346,600 2,831,485 53% 2,515,115 4,866,093
9,200,000 4,534,127 49% 4,665,873 8,687,091
297,000 155,927 53% 141,073 282,733
580,000 272,031 47% 307,969 389,664
872,400 198,121 23% 674,279 849,959
3,041,520 1,591,953 52% 1,449,567 2,472,217
57,200 33,981 59% 23,219 60,876
1,128,154 513,219 45% 614,935 1,262,400
95,060 27,469 29% 67,591 90,539
1,437,181 777,906 54% 659,275 1,356,234
3,917,844 1,263,447 32% 2,654,397 3,482,983
798,382 136,800 17% 661,582 250,889
26,771,341 12,336,466 46% 14,434,875 24,051,678
150,305 71,492 48% 78,813 145,936
376,735 158,524 42% 218,211 331,437
222,712 91,507 41% 131,205
300,140 121,071 40% 179,069 310,558
723,174 256,396 35% 466,778 687,654
550,831 180,403 33% 370,428 531,167
1,614,407
152,185 107,963 71% 44,222 125,622
940 751 80% 189 6,335
24,300 318 1% 23,982 1,029
2,501,322 988,425 40% 1,512,897 3,754,145
4,991,209 1,364,869 27% 3,626,340' 4,505,598
54,760 12,654 23% 42,106 51,697
118,735 10,850 9% 107,885 104,137
34,932 17,613 50% 17,319 35,022
4,209,712 778,032 18% 3,431,680 4,109,003
9,409,348 2,184,018 23% 7,225,330 8,805,457
411,653 173,074 42% 238,579 389,595
500 26 5% 474 112,085
98,580 28,281 29% 70,299
46,320 9,432 20% 36,888 49,395
269,955 105,678 39% 164,277 225,855
827,008 316,491 38% 510,517 776,930
7,360 7,360 4,969
12,000 1,420 12% 10,580 12,000
19,360 1,420 7% 17,940 16,969
Prior
YTD %
2,494,015 51%
3,723,094 43%
113,645 4O%
143,547 37%
179,593 21%
1,212,613 49%
32,211 53%
545,516 43%
34,722 38%
606,099 45%
1,391,583 40%
112,269 45%
10,588,907 44%
76,221 52%
152,302 46%
90,045 29%
298,210 43%
248,989 47%
346,063 21%
84,309 67%
1,048 17%
1,297,187 35%
1,174,610 26%
15,072 29%
21,865 21%
15,233 43%
1,908,406 46%
3,135,186 36%
170,011 44%
114
11,892 24%
82,133 36%
264,150 34%
727
727 4%
Variance
2,372,078
4,963,997
169,088
246,117
670,366
1,259,604
28,665
716,884
55,817
750,135
2,091,400
138,620
13,462,771
69,715
'179,135
220,513
389,444
· 282,178
1,268,344
41,313
5,287
1,029
2,456,958
3,330,988
36,625
82,272
19,789
2,200,597
5,670,271
219,584
111,971
37,5O3
143,722
512,780
4,242
12,000
16,242
City of Dublin General Fund Income Statement Showing
Revenues Versus Expenditures
For the Period 7~99 Through 12199
Culture and Leisure Services
Library Services
Cultural Activities
Heritage Center
Dublin Cemetery
Park Maintenance
Community TV
Recreation Admin
Playgrounds
Shannon Center
Preschool
Teens Program
Adult Sports
Youth Sports
Community Gym
Special Events
Senior Center
Recreation Instruction
Aquatics
Parks / Facility Management
Activity Total
Community Development
Planning
Building Safety
Engineering
Economic Development
Activity Total
Capital Improvement Projects
General ClP Projects
Community Improvements
Parks
Street Construction / Improvements
Activity Total
Total Expenditures
Excess Revenues (Expenditures)
Transfers In From Other Funds
Transfers Out From Other Funds
Current CUrrent Prior
Budget Actual % Variance Fiscal Year
342 994
55 285
.55 074
22 397
757 818
71 886
280 456
145 318
201 388
48 586
83,391
75,330
62,015
37,360
240,908
117,796
114,863
256,508
89,915
3,059,288
993,362
1,105,134
2,549,357
312,338
4,960,191
1,547,141
304,646
762,410
158,349
2,772,546
23,549,063
3,222,278
77,283 23%
6,505 12%
23,467 43%
5,976 27%
213,166 28%
51,437 72%
120,005 43%
67,826 47%
75,146 37%
21,325 44%
28,853 35%
25,156 33%
34,658 56%
4,615 12%
145,269 60%
51,360 44%
49,136 43%
123,332 48%
37,985 42%
1,162,500 38%
483,264 49%
417,224 38%
571,691 22%
113,225 36%
1,585,404 32%
144,214 9%
54,428 18%
43,55O 6%
23,93O 15%
266,122 10%
6,504,380 28%
5,832,086 181%
265 711
48 780
31 607
16 421
544 652
20 449
160 451
77 492
126 242
27 261
54 538
50 174
27 357
32 745
95 639
66436
65 727
133,176
51 930
1,896,788
510,098
687,910
1,977,666
199,113
3,374,787
1,402,927
250,218
718,860
134,419
2,506,424
17,044,683
-2,609,808
255,689
20,000
43,004
15,010
533,105
58,047
264,382
137,577
164,547
49,314
44,993
60,291
63,730
105,170
99,729
115,191
218,802
2,248,581
1,010,015
795,O25
1,685,599
115,762
3,606,401
252,013
63,272
1,110,304
353,570
1,779,159
20,987,642
3,064,036
39,874
-12,219,723
Prior
YTD
56,062
20,000
19,084
3,137
191,527
46 854
122 869
66 170
64 788
24 341
16 152
25 790
23 082
14,959
43,9O0
60,886
127,042
926,643
395,634
326,933
653,872
~89,513
1,465,952
65,462
8,479
155,962
229,809
459,712
7,549,557
3,039,350
22%
100%
44%
21%
36%
81%
46%
48%
'39%
49%
36%
43%
36%
14%
44%
53%
58%
41%
39%
41%
39%
77%
41%
26%
13%
14%
65%
26%
36%
99%
Variance
199,627
23,920
11,873
341,578
11,193
141,513
71,407
99,759
24,973
28,841
34,501
40,648
90,211
55,829
54,305
91,760
1,321,938
614,381
468,092
1,031,727
26,249
2,140,449
186,551
54,793
954,342
123,761
1,319,447
13,438,085
24,686
Appropriations to Reserves 3,222,278 5,832,086 181% -2,609,808 -9,115,813 3,039,350
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 12/31/1999
SPECIAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
************************
PROPERTY TAXES
SALES TAX/OTHER TAXES
FINES & FORFEITURES
USES/MONEY & PROPERTY
INTERGOVERNMENTAL FROM STATE
INTERGOVERNMENTAL FROM COUNTY
INTERGOVERNMENTAL FROM FEDERAL
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
82 965.00
183 800.00
59 000.00
90 160.00
2,515 457.00
136 650.00
401 640.00
729 650.00
30 000.00
4,229 322.00
39.810.33
62,341.24
30,580.71
342 034.0t
50 924.00
23 174.31
367 819.69
31 609.31
948 293.60
43
121
28
90
2,173
85
378
36t
(1
3,281
154
458
419
160
422
726
465
830
609
028
67 76
76 172
29 65
O0 93
99 753
O0 149
69 374
3t 706
31) 22
40 2.414,
684.53
561.75
857.76
371,12
103.27
244.00
449.92
992.33
439.87
704.55
76
172
65
93
753
149
374
706
22
2,414
684
561
857
371
103
244
449
992
439
704
53
75
76
12
27
O0
92
33
87
55
**************************
PUBLIC SAFETY: POLICE
TRAFFIC SIGNALS & STREET LTG
FIRE SERVICES
ACTIVITY TOTAL
T~NSPORTATION:
STREET MAINTENANCE
STREET SWEEPING
ACTIVITY TOTAL
HEALTH & WELFARE:
WASTE MANAGEMENT
SENIOR SUPPORT CARE
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT:
ENGINEERING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS
COMMUNITY PROJECTS
PARKS
STREET CONSTRUCTION/IMPROVEMENT
ACTIVITY TOTAL
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
87,959.00
128.770.00
88,143.00
304,872.00
410,056.00
410,056:00
870,570.00
870,570.00
6.000.00
6.000.00
17,665.00
189,199.00
21,119.00
2,246,122.00
2.474.105.00
4.065.603.00
(163,719.00)
23 173.30
48 154.27
71 327.57
39 148.42
39,148.42
435,846.96
435,846.96
5.602.25
3,577.66
11,519.92
20,699.83
567,022.78
(38t,270.82)
64.785.70
80,615.73
88,143.00
233,544.43
370,907.58
370,907.58
434,723.04
434,723.04
6,000.00
6.000.00
17,665.00
183,596.75
17,541.34
2.234,602.08
2,453,405.17
3,498,580.22
217,551.82
78,444.67
72,476.39
81.444.13
232,365.19
265.920.49
81,727.11
347,647.60
827,685.54
7,044.00
834,729.54
44,166.79
44,166.79
56.548.31
51.300.97
674.931.01
782,780.29
2.241,689.41
(173.015.14)
(130.265.91)
62,370.78
78.444
72.476
81.444
232.365
265.920
81.727
347,647
827.685
7.044
834.729
44.166
44,166
.67
.39
.13
.19
.49
.11
.60
.54
.00
.54
.79
.79
56,548.31
51,300.97
674,931.0t
782.780.29
2,241,689.41
(173,015.14)
(130,265.91)
62,370.78
EXCESS <REVENUE> EXPENDITURE (t63.719.00) (381.270.82) 217,551.82 (240,910.27) (240,910.27)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 12/31/1999
SPECIAL ASSESSMENT
FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
************************
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
309.093.00 t51,797.31 157,295.69 253,175.40
15,027.00 15,027.00 16.381.44
2,500.00 2,500.00 2,736.05
326,620.00 151,797.31 174,822.69 272,292.89
253.175.40
16.381.44
2,736.05
272,292.89
**************************
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG
ACTIVITY TOTAL
TRANSPORTATION PUBLIC WORKS
STREET TREE MAINTENANCE
STREET LANDSCAPE MAINTENANCE
ACTIVITY TOTAL
HEALTH & WELFARE:
ENGINEERING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT
ACTIVITY TOTAL
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
145,005
145,005
2,945
t3,210
160,990
t77,145
~,200
4,200
.00
.00
.00
.00
.00
.00
.00
.00
38,669.53 106,335.47
38,669.53 106,335.47
18,700.00
82,600.00
101,300.00
t.598.12 1.346.88
1,024.37 12,185.63
52.781.69 108,208.31
55.404.18 121,740.82
427.650.
101,030.
4,336.86 (136.86)
4,336.86 (136.86)
46.41 18.653.59
82,600.00
46.41 101,253.59
107,525
107,525
2,246
7,694
105,652
115,594
3,084
3,084
.57
.57
.99
.38
.77
.14
.88
.88
O0 98,456.98 329,193.02 226,204.59
O0 (53,340.33) 154,370.33 (46.088.30)
107,525.57
107.525.57
2,246.99
7,694.38
105.652.77
115,594.14
3.084.88
3,084.88
226.204.59
(46,088.30)
EXCESS <REVENUE>EXPENDITURE 101,030.00 (53.340.33) 154,370.33 (46,088.30) (46,088.30)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 12/31/1999
CAPITAL IMPROVEMENT
FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
***********************
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
73,785.00
27,856,145.00
27,929,930.00
73,785.'00
27,856,145.00
27,929,930.00
2,257,954.64
2,257,954.64
2.257,954.64
2,257,954.64
**************************
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CtP PROJECTS
COMMUNITY IMPROVEMENTS
PARKS
STREET CONSTRUCTION/IMPROVEMENT
ACTIVITY TOTAL
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
61,886.00
61.886.00
2,029,737.00
9,443.800.00
16,623,429.00
28,096,966.00
16.915.01
16,915.01
56.72 61,829.28 145.14
56.72 61,829.28 145.14
372,510.t2 1,657.226.88
5,170,802.25 4,272.997.75
751,420.38 15.872.008.62
6,294,732.75 21.802,233.25
124.753.27
1,180.149.86
744,202.34
2,049.105.47
28.158.852.00 6.294,789.47 21,864,062.53 2.066,165.62
228~922.00 6,294,789.47 (6,065,867.47) (191,789.02)
17,586.84
t6,915.01
16.915.01
145.14
145.14
124,753.27
1.180.149.86
744.202.34
2,049 105.47
2,066 165.62
(191,789.02)
17,586.84
EXCESS <REVENUE>EXPENDITURE 228,922.00 6.294,789.47 (6,065,867.47) (174.202.t8) (174.202.18)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 12/31/1999
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
************************
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
116,594.77 (t16,594.77) 235,672.36
12.637.55
116,594.77 (116.594.77) 248.309.9t
235.672.36
12,637.55
248,309.91
**************************
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
EXCESS <REVENUE>EXPENDITURE
190,256.00 (190,256.00) 231,864.50
190,256.00 (190.256.00) 231,864.50
190.256.00 (190.256.00
73,661.23 (73.661.23
73,661.23 (73.66t.23
231.864.50
(16,445.41)
16,445.41)
231,864.50
231,864.50
231,864.50
(16.445.41)
(16,445.41)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/t999 THROUGH 12/31/1999
INTERNAL SERVICE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
************************
USES/MONEY & PROP-INTEREST
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
56.832.00 56.832.00 40,084.94
589.275.00 240,499.39 348.775.61 726.998.50
25.700.00 10,455.79 15.244.21 17.455.06
671.807.00 250,955.18 420.851.82 784,538.50
40.084.94
726,998.50
17,455.06
784,538.50
**************************
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
T~NSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
706.909.00 131,041.19 575.867.81 794,802.16
706,909.00 131.041.19 575.867.81 794,802.16
706.909.00 131.041.19 575.867.81
35,102.00 (119,9t3.99) 155.015.99
794,802.16
10,263.66
13.582,460.94
794,802.t6
794.802.16
794,802.16
10,263.66
13,582.460.94
EXCESS <REVENUE>EXPENDITURE 35,102.00 (119,913.99) 155.015.99 (13,572,197.28) (13.572,197.28)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THRUGH 12/3t/1999
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
************************
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
1,671.632.89
1,671,632.89
1,671,632.89
1,671,632.89
***************************
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACTIVITY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
10.00
10.00
10.00
10.00
10.00
10.00
10.00
10.00
935,724.30
500.00
936,224.30
936.224.30
(735,408.59)
(12,134,212.45)
13,587,133.27
935,724.30
500.00
936,224.30
936,224.30
(735.408.59)
12,134,212.45)
13.587,133.27
EXCESS <REVENUE>EXPENDITURE 10.00 10.00 717,512.23 717,512.23