HomeMy WebLinkAbout4.09 July-Aug Fin ReportsCITY CLERK FILE # 0330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (September 19, 2000)
SUBJECT:
EXHIBITS ATTACHED:
RECOMMENDATION:
FINANCIAL STATEMENT:
Preliminary Financial Reports For the Months of
July and August 2000
Report Prepared by: Fred Marsh, Finance Manager
Pro Forma Balance Sheet and Income Statements for
the Periods Ending July and August 31, 2000
Receive the reports.
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report of the preliminary financial statements for the month
of August. The reason that the report is presented. as "preliminary" is that the final audited results of
Fiscal Year 1999/2000 are not yet available. Preliminary Financial Results for Fiscal Year 1999-2000
(subject to adjustments from the City's annual audit) will be presented at the October 17, 2000 council
meeting. 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.
Preliminary. ReOortinl~ of Information
The auditors will start the final phase of their field work necessary for the 1999/2000 audit in October.
The final audit results will impact the reported Fund Balance presented in the attached monthly reports.
Staff has not yet made the final year end accrual for sales tax, but anticipates the final entries will occur by
the October report. The scope of any remaining final entries will not be significant when compared to all
general fund revenues and expenses.
Analysis of Preliminary. August 2000 Revenue and Expenditure Reoort
Given that this is only the second month of the 2000/2001 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 August are comparable to what occurred in the second
month of the previous Fiscal Year. The City had collected through August 2000 approximately 10% of
the total budgeted General Fund Revenues compared to approximately 9% in the prior Fiscal Year.
Transient Occupancy Taxes are higher than in the same period in the prior year as only two of the City's
four hotels were open in July of the prior year.
COPIES TO:
G:X1VIONTHFS\082000 agenda statement monthly ~nancials.doc
ITEM NO.
Licenses and Permits are higher than in the same period in the prior year due to a increase in the valuation
of building permits issued during the first two months of Fiscal Year 2000/2001. Other Revenue is lower
than in the same period in the prior year due to a larger insurance equity distribution received from ABAG
in the prior Fiscal Year. Based upon the limited information available there were not any areas with
significant deviations from the current budget projections.
General Fund Exl~enditures
Overall, through the month of August expenditures in the General Fund totaled $983,340 and represented
approximately 4% of the total budgeted expenditures in the General Fund. Of this amount, a total of
$3,673 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 August 2000 was
comparable to the amounts expended for the same period in the prior Fiscal Year. As of August 31, 2000,
the City had expended 4% of the General Fund Operating Budget compared to 8% in the prior Fiscal
Year. As previously noted there are some timing differences with payment for contract services
(including Police and Fire 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 these reports as authorized by Section 41004 of the
California Government Code.
City of Dublin 2000-2001 YTD Revenues and Budget Comparison
For the Period Ending August 31, 2000 - Unaudited
Total General Fund Revenues
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental from State
Charges for Services
Fines and Forfeitures
Other Revenues
10%
9%
1%
1%
4o, 2%
4~
21%
16%
8%
9%
22%
0% 30% 60% 90% 120% 150%
· FY 2000/2001
[] FY 1999/2000
17% of Year Complete
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental
Charges for Services
Fines and Forfeitures
Other Revenues
FY 2000/2001
Budget
6, 168,350
11,300,000
288,000
910,000
1,017,840
3,124,088
1,513,259
1,704,500
3,415,408
68,755
2,990,075
FY 2000/2001 % of
YTD Actual Budget
55,047 1%
1,630,300 14%
33,822 12%
87,571 10%
46,156 5%
651,825 21%
21,997 1%
275,499 16%
284,434 8%
15,249 22%
· 53,077 2%
Total General Fund Revenues 32,500,275 3,154,977
10%
FY 99~00
YTD Actual
48,336
1,319,500
16,609
48,022
39,729
491,041
20,098
243,943
281,795
11,894
70,045
2,591,012
% of Total for
FY 99~00
1%
12%
4%
6%
4%
12%
1%
15%
9%
14%
10%
9%
ATTACHMENT 1
City of Dublin 2000-2001 YTD Expenses and Budget Comparison
For the Period Ending August 31, 2000 ~ Unaudited
Total General Fund Expenses
General Government
Civic Center Lease
Police
FiFe
Other Public Safety
Transportation
Health and Welfare
[] FY 2000/2001
la FY 1999/2000
Culture & Community Services
Community Development
Capital Improv. Projects
0%
20%
40% 60%
17% of Year Complete
80%
100%
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture and Community Services
Community Development
Capital Improvement Projects
Total General Fund Expenses
FY 200012001
Budget
FY 200012001 % of
YTD Actual Budget
FY 99/00
YTD Actual
2,927,377 229,216 8% 244,738
6,027,024 23,859 0% 52,767
4,448,83~1 74,026 2% 698,685
283,619 3,652 1% 3,038
960,383 41,916 4% 40,807
19,390 0 0% 0
3,446,699 301,489 9% 254,963
4,627,475 305,509 7% 339,506
4,325,689 3,673 0% 11,119
27,066,487 983,340 4% 1,645,623
General Fund Operating Expenses 22,740,798 979,666 4% 1,634,504
% of Total for
FY 99~00
11%
1%
17%
2%
5%
0%
11%
9%
1%
8%
9%
............. = ~0 .... ATTACH M E N T 2
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF AUGUST 2000
Prepared by
The Finance Department
September 6, 2000
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD' ENDING 31Aug2000
SPECIAL SPECIAL CAPITAL TRUST/
REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUND FUND
TOTALS
---MEMORANDUM ONLY---
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
(17.453.400)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
49.430.002
149.497
205.395
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
5,849
16,468
32,353.811
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES
FUND BALANCES
(984.840)
(42.013)
(368.305)
(2,731,657)
(269,260)
(262.869)
(149,497)
(4,808.441)
(27,545.370)
TOTAL FUND E (27.545,370)
TOTAL LtAB. FND BAL. RETD (32.353.81t)
1.592,104
311
667
1.593.082
(122.089)
(122.089)
(1.470,993)
(1.470,993)
(1.593,082)
292.585 19,423.783 164.876 4,019.948 (8.905.792)
154:569 154.569 154.569
4.267.787 4.267.787 4.267.787
292.585 23.691.570
(33.505.241)
(7.420) (291.071)
(5.849)
(7.420) 33.802.160)
(285,165) 10.110.590
(285.165) 10.110.590
(292.585) (23,691.570)
49,430,002
149.808
205,395
1.860.500
2.179.945
6.516
16.468-
1.860.500
60.110.993
(98~.84o)
(33.547,253)
(368.305)
(3,152.237)
(269.260)
(262,869)
(155,346)
(1.978.000) (1.978.000)
(1.978.000) (40.718.110)
(201.945) (19.392.883)
(201.945) (19.392,883)
(2,179.945) (60.110.993)
49.430,002
655.436
205,395
6.516
15.439
1.860.500
47.689.852
(668,247)
(14.693.665)
(354.683)
(4.487.047)
(444.837)
(177.077)
(155.346)
(1.978.000)
(22.958.902)
(24.730.950)
(24.730.950)
(47,689,852)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Aug2000
FIXED/LSSETS
GROUP OF
ACCOUNTS
GENERAL LONG
TERM DEBT
ACCOUNT GROUP
TOTALS
- - -MEMORANDUM- - -
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
1.314,626
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
DUE FROM OTHERS
'INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
/~J'IOUNT TO BE PROVIDED
TOTAL ASSETS
19,491,955
20.806.581
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS (1.494)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (1.494)
FUND BALANCES (20.805.087)
TOTAL FUND E (20.805.087)
TOTAL LIAB. FND BAL. RETD (20,806.581)
(355)
6,388.993
28.558.587
(355) 6.388.993 28.558.587
355 (6.388.993)
355 (6.388.993)
(28.558,587)
(28.558.587)
355 (6.388.993) (28.558.587)
1.314.272 1,331.187
25.880.948 25.880.948
28,558.587 28.57t.488
55.753.807 55.783.622
(1.494) (6,353)
(28.558,587) (28.571.488)
(28.560.080) (28.577.841)
(27,193.726) (27.205.781)
(27.193.726) (27.205.781)
:55,753,807) (55.783,622)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 08/31/2000
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
~A~AAREVENUES~***~
PROPERTY TAXES
SALES.TAX
REAL PROPERTY TRANSFER TAX
HOTEL TRANSIENT OCCUPANCY TAX
FR/~NCHISE TAXES
LICENSES & PERMITS
FINES & FORFEITURES
USE/MONEY & PROP-INTEREST
USE/MONEY & PROP-RENTALS
INTERGOVERNMENTAL FROM STATE
INTERGOVERNMENTAL FROM COUNTY
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
6,168,350.00
11,300,000.00
288,000.00
910,000.00
1,017,840.00
3,124,088.00
68,755.00
1,411,205.00
102,054.00
1,704,500.00
3,415.408.00
2,990,075.00
32,500,275.00
55,047.00
1,630,300.00
33,821.94
87,570.82
46,156.00
651,825.39
15,248.98
10,237.59
11,759.34
275,498.93
284,433.62
53,077.13
3.154,976.74
6o113 303.00
9,669 700.00
254 178.06
822 429.18
971 684.00
2,472 262.61
53 506.02
1,400,967.41
90.294.66
1,429,001.07
3,130,974.38
2,936.997.87
29,345,298.26
5,892,789.32
10,585,617.45
370,945.99
808,688.14
963,069.84
3,959,317.22
84,542.77
1,658,928.73
85,831.12
1,629.846.86
3,155,543.54
696.766.43
29,891,887.41
48,336.00
~,319,500.00
16,608.93
48,022.26
39,729.00
491,040.99
11,894.43
9,842.07
10,255.76
243,943.13
281,794.95
70,044.97
2,591,012.49
5,844,453.32
9,266,117.45
354,337.06
760 665.88
923 340.84
3,468 276.23
72 648.34
1,649086.66
75 575.36
1,385 903.73
2,873,748.59
626.721.46
27,300,874.92
~EXpENDiTURES~
GENEP, AL GOVERNMENT ACTIVITIES:
CITY COUNCIL
CITY MANAGER
CENTRAL SERVICES
CITY AI'[ORNEY
ADMIN SERVICES
BUILDING MANAGEMENT
FACILITY RENTAL
INSURANCE COST CENTER
ELECTIONS COST CENTER
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFELY POLICE
CROSSING GUARDS
ANIMAL CONTROL
DISASTER PREPAREDNESS
FIRE SERVICES
ACI'IVITY TOTAL
TRANSPORTATION
PUBLIC WORKS
STREET MAINTENANCE
STREET SWEEPING
STREET TREE MAINTENANCE
STREET LANDSCAPING MAINTENAN
ACTIVITY TOTAL
HEALTH & WELFARE
170,405.00
445,805.00
250,000.00
'- 293,882.00
889,601.00
494,721.00
120.00
245,493.00
7,350.00
130,000.00
2,927,377.00
6,027.024.00
63.760.00
177,595.00
42,264.00
4,448,831.00
10,759.474.00
508.071.00
861.00
107,031.00
45,768.00
298,652.00
960.383.00
12,069.06
43,792.56
21,337.93
64,098.45
9,293.73
78,606.73
17.23
229,215.69
23,859.46
3,652.22
74,025.57
i01,537.25
34,716.60
7,199.13
41,915.73
158,335.94
402,012.44
228,662.07
293,882.00
825,502.55
485.427.27
120.00
166,886.27
7,332.77
130,000.00
2,698,161.31
6,003,164.54
63,760.00
177,595.00
38,611.78
4.374,805.43
10,657,936.75
473,354.40
861.00
99,831.87
45.768.00
298,652.00
918,467.27
144,028.28
366,867.84
200,805.34
301,416.94
605,315.96
473.943.21
114.U0
169,061.86
904.34
77.83
2,262,535.60
5,075,035.24
47.608.15
85,316.18
37,007.88
4,202,731.64
9,447,699.09
404,754.65
11,513.70
82,440.23
40,288.40
286,816.64
825,813.62
15.441.87
42,073.40
16,583.28
730.32
64,644.53
27,277.58
77,986.71
244,737.69
52°767.36
3,037.70
698,684.98
754.490.04
40.680.37
127.03
40,807.40
128.586.41
324,794.44
184,222.06
300,686.62
540,671.43
446,665.63
1t4.00
91,075.15
904.34
77.83
2,017,797.9t
5,022,267.88
47,608.15
85,316.18
33,970.18
3,504,046.66
8,693,209.05
364,074.28
11,5t3.70
82,440.23
40,288.40
286,689.61
785,006.22
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 08/31/2000
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
W~STE MANAGEMENT
CHILD CARE
'- ACTIVITY TOTAL
CULTURE & LEISURE SERVICES
LIBRARY SERVICES
CULTURAL ACTIVITIES
HERITAGE CENTER
DUBLIN CEMETERY
PARK MAINTENANCE
COMMUNITY TV
RECREATION ADMIN
PLAYGROUNDS
SMANNON CENTER
PRESCHOOL
TEENS PROGRAM
ADULT SPORTS
YOUTH SPORTS
COMMUNITY GYM
SPECIAL EVENTS
SENIOR CENTER
RECREATION INSTRUCTION
AQUATICS
PARKS/FACILITIES MANAGEMENT
ACTIVITY TOTAL'
COMMUNITY DEVELOPMENT
PLANNING
BUILDING SAFETY
ENGINEERING
ECONOMIC DEVELOPMENT
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROjECTS
COMMUNITY IMPROVEMENTS
PARKS
STREET CONSTRC/IMPROVEMENTS
ACTIVITY TOTAL
TOTAL EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT FROM OTHER FUNDS
7,390.00
12,000.00
19,390.00
362,922.00
51,608.00
67,861.00
33,337.00
858,807.00
69,852.00
312,313.00
213,209.00
233.841.00
55,790.00
105,053.00
75,762.00
75,044.00
34,035.00
248,184.00
144,986.00
129,585.00
278.195.00
96.315.00
3,446,699.00
1.197,308.00
1,313,919.00
1,816,058.00
300,190.00
4,627,475.00
2,507,540.00
374,583.00
506.976.00
936,590.00
4,325.689.00
27,066,487.00
5.433.788.00
22,557.78
5,011.70
750.00
431.10
50,532.00
28,493.74
25.647.68
16.288.83
4,081.79
11,794.80
5,955.33
6,583.82
i 105.12
21 864.18
13 967.58
10 399.34
66 709.62
9 314.19
30t 488.60
97,313.38
35,046.41
98,377.81
74,771.60
305,509.20
3.535.62
137.74
3.673.36
983.339.83
2.171.636.91
7,390.00
12,000.00
19,390.00
362 922.00
29 050.22
62 849.30
32 587.00
858 375.90
19 320.00
283 819.26
187 561.32
217 552.17
51 708.21
93 258.20
69 806.67
68 460.!8
32.929.88
226,319.82
131,018.4~
119,185.66
21t,485.38
87,000.81
3,145,210.40
1,099,994.62
1,278,872.59
1,717,680.19
225,418.40
4,321,965.80
2,504,004.38
374,583.00
506,976.00
936,452.26
4,322,015.64
26,083,147.17
3,262,151.09
7,085.81
12.000.00
19,085.81
342,557.00
53,367.37
56,041.75
30,225.33
633,590.64
66.950.70
268,010.90
145,350.76
195,568.95
47,449.90
75 134.57
63 793.38
67 900.31
28 795.78
218 t02.49
115 557.53
102 256.75
228 822.22
85 705.46
2,825 181.79
1.250,742.64
1,053,067.17
1.460,679.29
334,514.99
4,099,004.09
1,031,530.09
234,423.08
723,705.98
117,203.65
2;106.862.80
21,586,182.80
8,305,704.61
4,835.76
699.15
42.986.00
32,251.45
24,444.09
14,928.69
5,168.21
4,199.67
5,460.27
16,482.81
14,606.44
10,856.62
13.836.38
55,293.89
8,913.34
254,962.77
114,289.98
86,306.33
79,741.58
59,168.15
339,506.04
7,470.62
67.80
755.61
2,824.76
11,118.79
1,645,622.73
945,389.76
7,085.81
12,000.00
19,085.81
342,557.00
53,367.37
51,205.99
30,225.33
632,891.49
23,964.70
235,759.45
120,906.67
180,640.26
42,281.69
70,934.90
58,333.11
51,417.50
28,795.78
203,496.05
104,700.91
88,420.37
173,528.33.
76,792.12
2,570,219.02
1,136,452.66
966,760.84
1,380,937.71
275,346.84
3,759,498.05
1,024,059.47
234,355.28
722,950.37
114.378.89
2.095.744.01
19,940,560:07
7,360,314.85
REVENUES OVER(UNDER) EXPENDITURES 5,433,788.00 2,171,636.91 3,262,151.09 8,305,704.61 945,389.76 7,360,314.85
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 08/31/2000
SPECIAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
A~A~REVENUES~***
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,850.00 82,850.00 77,916.49
194,000.00 29.810.88 164,189.12 192,662.02
89,475.00 89,475.00 113;370.96
100.676.00 100,676.00 27,034.22
2,024,858.00 114,647.95 1,910,210.05 629,750.40
137.780.00 137,780.00 132,904.00
1,026,394.00 1,026,394.00 87,679.67
763,302.00 763,302.00 724,750.40
5,000.00 5,000.00 40,601.31
4,424,335.00 144,458.83 4,279,876.17 2,026,669.47
77916.49
222472.90
113 370.96
27 034.22
744 398.35
132 904.00
87 679.67
724 750.40
40 601.31
2,171.128.30
(29,810.88)
(114,647.95)
(144.458.83)
**~EXpENDITURES***~
PUBLIC SAFETY: POLICE
TP, AFFIC SIGNALS & STREET LTG
FIRE SERVICES
ACTIVITY TOTAL
TRANSPORTATION:
STREET MAINTENANCE
STREET SWEEPING
ACTIVITY TOTAL
HEALTH & WELFARE:
WASTE MANAGEMENT
SENIOR SUPPORT CARE
HOUSING PROGRAMS
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>EXPENDII'URE
TRANSFER IN FROM O'FHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
139,290.00
141,645.00
89,125.00
370,060.00
626.322.00
626,322.00
1,169.535.00
7,500.00
10,000.00
1,187,035.00
6,000.00
6,000.00
285.004.00
8,820.00
2,560,234.00
2.854,058.00
5,043,475.00
619.140.00
33,573.56
33,573.56
1,511.37
1,5tl.37
5,331.86
6.074.51
11,406.37
46,491.30
(97,967.53)
139,290.00
141,645.00
89,125.00
370,060.~0
592.748.44
592,748.44
1,168,023.63
7,500.00
10,000.00
1,185.523.63
6,000.00
6,000.00
279.672.14
8,820.00
2.554,159.49
2.842,651.63
4.996,983.70
717,107.53'
88,258.42
121,790.46
79.100.67
289,149.55
533,583.10
533,583.10
866,219.67
866,219.67
6,000.00
6.000.00
13,997.81
59,614.67
20,517.41
408,087.86
502.217.75
2,197,170.07
170,500.60
88,258.42
121,790.46
79,100.67
289,149.55
567,156.66
567,t56.66
867,731.04
867,731.04
6,000.00
6,000.00
13,997.81
64,946.53
20,517.41
414,162.37
513,624.12
2,243,661.37
72,533.07
(33.573.56)
(33.573.56)
(1.511.37)
(1.511.37)
(5,331.86)
(6,074.51)
(11,406.37)
(46,491.30)
97,967.53
EXCESS <REVENUE> EXPENDITURE. 619,140.00 (97,967.53) 717,107.53 170,500.60 72,533.07 97,967.53
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 08/31/2000
SPECIAL ASSESSMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
F U N D
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
,~****REVENUES;~;~
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
390,388.00
13,589.00
6,000.00
409,977.00
390,388.00
13,589.00
6,000.00
409,977.00
315,835.83
4,876.24
668.85
321,380.92
315,835.83
4,876.24
668.85
321,380.92
~EXpENDiTURES~
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
172,115.00
172,115.00
4,480.00
12,039.00
239,352.00
255,871.00
4,760.00
4.760.00
52,840.00
52,840.00
485,586.00
75,609.00
7,420.76
7,420.76
679.27
679.27
8,100.03
8,100.03
164,694.24
t64.694.24
3.800.73
12,039.00
239,352.00
255,191.73
4,760.00
4.760.00
52,840.00
52.840.00
477,485.97
67,508.97
118,667.18
118,667.18
3,613.20
4,219.57
131,200.04
139,032.81
4,495.98
4.495.98
27,972.00
46,752.16
74,724.16
336,920.13
15.539.21
6,580.47
6,580.47
557.77
124.98
682.75
5.46
5.46
7.268.68
7,268.68
112.086.71
112,086.71
3.055.43
4,219.57
131,075.06
138,350.06
4.490.52
4,490.52
27,972.00
46,752.16
74,724.16
329,651.45
8,270.53
EXCESS <REVENUE>EXPENDITURE 75,609.00 8,100.03 67,508.97 15,539.21 7,2.68.68 8.270.53
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 08/31/2000
CURRENT
BUDGET
CAPITAL IMPROVEMENT FUND
CURRENT PRIOR
ACTUAL VARIANCE FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
~,REVENUE~
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
18,729,643.00
18,729,643.00
196,773.67
18,729,643.00
18,729,643.00 196,773.67
295.72
295.72
196,773.67
(295.72)
196,477.95
~EXpENDITURES~
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 CIP PROJECTS
COMMUNITY IMPROVEMENTS
PARKS
STREET CONSTRUCTION/IMPROVEMENT
ACTIVITY TOTAL
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OLFF TO OTHER FUNDS.
12,634.00
12,634.00
1,628,667.00
1,204.210.00
15,884.132.00
'18,717.009.00
18,729,643.00
4,464.83
125,230.19
129.695.02
129,695.02
129,695.02
12,634.0'0 12,389.68
12,634.Q0 12.389.68
1,624,202.17 2',122,917.18
1,204,210.00 6,056,106.29
15,758,901.81 2,428,564.76
18,587,313.98 10,607,588.23
18,599,947.98 10,619,977.91
(129,695.02) 10,423,204.24
56.72
56.72
1,300.00
343,048.90
6,863.96
351,212.86
351,269.58
350,973.86
12,332.96
12,332.96
2,121,6t7.18
5,713,057.39
2.421.700.80
10,256,375.37
10,268,708.33
10.072,230.38
EXCESS <REVENUE>EXPENDITURE 129.695.02 (129,695.02) 10,423,204.24 350,973.86 10,072.230.38
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/0'i/2000 THROUGH 08/31/2000
TRUST/AGENCY FUND
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
*******~REVENUES~
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
233,189.54
6.452.07
239,641.61
233,189.54
6,452.07
239,641.61
~EXpENDITURES~,~
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFELY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
EXCESS <REVENUE>EXPENDITURE
507.79
507.79
507.79
507.79
507.79
(507.79)
(507.79)
(507.79)
(507.79)
(507.79)
261,375.75
261.375.75
261,375.75
21,734.14
21.734.14
161.1t6.00
161,116.00
161.116.00
161,116.00
161,116.00
100,259.75
100.259.75
100.259.75
(139,381.86)
(139,381.86)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/0t/2000 THROUGH 08/31/2000
INTERNAL SERVICE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
~REVENUES~
USES/MONEY & PROP-INTEREST
CHARGES FOR SERVICES
OTHER SOURCESOF REVENUE
TOTAL REVENUE
187,672.00
919,498.00
17,000.00
1,124,170.00
187,672.00
919,498.00
17,000.00
1,124,170.00
14,165.24
517,710.38
42,214.73
574,090.35
93,888.87
35.00
93,923.87
14,165.24
423,821.51
42,179.73
480,166.48
~EXpENDiTURES~
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
981,790.00
1,010,615.00
12,055.18
12.055.18
969,734.82
998,559.82
251.603.17
251.603.17
24,165.76
24,165.76
227,437.41
227,437.41
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
1,010,615.00
(113.555.00)
i2,055.18
12,055.18
998,559.82
(125.610.18)
251.603.17
(322.487.18)
24,165.76
(69,758.11)
227,437.41
(252.729.07)
EXCESS <REVENUE>EXPENDITURE (113,555.00) 12.055.18 (125,610.18) (322,487.18) (69,758.11) (252,729.07)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 07/31/2000
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
~AA~;~AREVENUESA~;~A;~
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
~A~EXpENDITURESA;AA~
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
EXCESS <REVENUE>EXPENDITURE
10.00
10.00
10.00
10.00
10.00
10.00
10.00
lo.00
10.00
10.00
10.00
344.50
354.50
354.50
354.50
354.50
10.00
344.50
354.50
354.50
354.50
354.50
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF JULY 2000
Prepared by
The Finance Department
September 5, 2000
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31ju12000
SPECIAL SPECIAL CAPITAL TRUST/
REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUND FUND
TOTALS
---MEMORANDUM ONLY---
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
(18.557.717)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
49.430.002
251.085
205.395
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNTTO BE PROVIDED
TOTAL ASSETS
5.849
15.361
3t.349,976
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL (810.682)
DEPOSITS FOR AB1600 FEES (15.597)
DEPOSITS OTHERS (361,883)
PAYABLES: ACCOUNTS (3.172.263)
INTEREST
PAYROLL (276.230)
DUE TO OTHERS (195,977)
DEFERRED REVENUE (149,497)
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (4.982.129)
FUND BALANCES (26,367.847)
TOTAL FUND E (26,367.847)
TOTAL LIAB. FND BAL. RETD (31.349.976)
2.136.794
80,708
667
2,218.169
(833.936)
(833.936)
(1.384.232)
(1,384.232)
(2.218.169)
308,926 17,289.323 164,876 1.342.202
154,569 154,569
4,267.787 4.267.787
308.926 21,557.110
(30.872.423)
(16.944) (661,037)
(5.849)
(16.944) (31,539.308)
(291,981) 9.982.198
(291.981) 9.982.198
(308,926) (21.557,110)
49,430,002
331.793
205,395
1.860,500
2.179.945
6,516
15,361
1,860.500
57.614.125
(810,682)
(30.888.020)
(361,883)
(4.684,180)
(276.230)
(195.977)
(155.346)
(1.978.000) (1.978.000)
(1.978.000) (39.350.318)
(201.945) (18.263,807)
(201.945) (18.263,807)
(2.179.945) (57.614.125)
(8.905.792)
154.569
4.267.787
49.430,002
655,436
205.395
6.516
15.439
1.860.500
47.689.852
(668.247)
(14,693.665)
(354.683)
(4,487.047)
(444.837)
(177.077)
(155.346)
(1,978.000)
(22.958,902)
(24,730.950)
(24.730.950)
(47.689.852)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31ju12000
FIXED ASSETS GENERAL LONG
GROUP OF TERM DEBT
ACCOUNTS ACCOUNT GROUP
TOTALS
- - -MEMORANDUM - - -
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
1,329,585
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,821,540
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS (5,453)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (5,453)
FUND BALANCES (20,816,087)
TOTAL FUND E (20,816,087)
(355)
(355)
355 (6,388,993)
355 (6,388,993)
6,388,993
28,568,483
6,388,993 28,568,483
(28,568,483)
(28,568,483)
1,329,230 1,331,187
25,880,948 25,880,948
28,568,483 28,571,488
55,778,662 55,783,622
(5,453) (6,353)
(28,568,483) (28,571,488)
(28,573,936) (28,577,841)
(27,204,725) (27,205,781)
(27,204,725) (27,205,781)
.TOTAL LI/~3. FND BAL. RETD (20,82t.540) 355 (6.388.993) (28,568,483) (55,778..662) (55.783,622)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 07/31/2000
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
~;;~;;;REVENUES~
PROPERTY TAXES
SALES TAX
REAL PROPERTY TRANSFER TA~
HOTEL TRANSIENT OCCUPANCY TAX
FRANCHISE TAXES
LICENSES & PERMITS
FINES & FORFEITURES
USE/MONEY & PROP-INTEREST
USE/MONEY & PROP-RENTALS
INTERGOVERNMENTAL FROM STATE
INTERGOVERNMENTAL FROM COUNTY
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
6.168.350.00
11,300.000.00
288.000.00
910,000.00
1.017.840.00
3.124.088.00
68.755.00
1.411,205.00
102.054.00
1,704.500.00
3.415.408. O0
2.990.075. O0
32.500.275. O0
~ ,'~,on
~EXpENDtTURES~
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 170,405.00
CITY MANAGER 445.805.00
CENTRAL SERVICES 250.000.00
CITY AI'I'ORNEY ~ 293.882.00
ADMIN SERVICES 889.601.00
BUILDING MANAGEMENT 494,721.00
FACILITY RENTAL 120.00
INSURANCE COST CENTER 245~493.00
ELECTIONS COST CENTER 7.350.00
NON-DEPARTMENTAL 130.000.00
ACTIVITY TOTAL 2,927,377.00
PUBLIC SAFETY.
POLICE- 6.027.024.00
CROSSING GUARDS 63.760.00
ANIMAL CONTROL 177.595.00
DISASTER PREPAREDNESS 2 42.264.00
FIRE SERVICES y~ 4.448.831.00
ACTIVITY TOTAL ~' ~ 10.759.474.00
TRANSPORTATION
PUBLIC WORKS 508.071.00
STREET MAINTENANCE 861.00
STREET SWEEPING 107.03t.00
STREET TREE MAINTENANCE 45.768.00
STREET LANDSCAPING MAINTENAN 298.652.00
ACTIVITY TOTAL 960.383.00
HEALTH & WELFARE
6.168.350.00
698,700.00 10,601.300.00
288,000.00
910,000.00
1.017,840.00
227.329.83 2.896.758.17
5.700.00 63.055.00
1.010.34 1.410,194.66
4.810.74 97.243.26
135.642.38 1.568.857.62
92,254.54 3,323.153.46
39.803.63 2,950.271.37
1,205,251.46 31.295.023.54
5,892.789.32
10,585 617.45
370 945.99
808 688.14
963 069.84
3.959 317.22
84 542.77
1,658 928.73
85 831.12
1,629 846.86
3.155.543.54
696.766.43
29.891,887.41
565.500.00
196,232.66
- 7.156.63
8.158.56
4.637.60
136.198.34
92.922.24
59.844.73
1.070.650.76
5.892.789.32
10,020.117.45
370.945.99
808,688.14
963.069.84
3.763.084.56
77.386.14
1,650.770.17
81.193.52
1.493,648.52
3.062,621.30
636.921.70
28.821.236.65
6,309.37 164,095.63 144.028.28 5.696.27 138.332.01
14,766.80 431,038.20 366,867.84 16,393.92 350.473.92
6.92t.86 243.078.14 200.805.34 4.605.24 196,200.10
293.882.00 30t.416.94 365.16 301.051.78
24,566.04 865,034.96 605,315.96 23.997.50 581.318.46
391.02 494.329.98 473.943.21 10.749.03 463.194.18
120.00 114.00 114.00
245.493.00 169.061.86 77.254.63 91.807.23
7.350.00 904.34 904.34
130,000.00 77.83 77.83
52.955.09 2,874.421.91 2,262.535.60 139,061.75 2.123.473.85
5,988.23 6,021,035.77 5.075.035.24 23,216.73 5,051,818.51
63,760.00 47,608.15 47,608.15
177.595.00 85.316.18 85.316.18
1.221.71 41.042.29 37,007.88 560.89 36.446.99
1,240.55 4.447.590.45 4,202.731.64 330,594.35 3.872.137.29
8.450.49 10.751.023.51 9,447.699~09 354.371.97 9,093,327.12
10.575.60 497,495.40 404.754.65 15.271.19 389.483.46
861.00 11,513.70 11.513.70
107,031.00 82.440.23 82.440.23
45,768.00 40,288.40 40.288.40
298,652.00 286,816.64 286,816.64
10,575.60 949,807.40 825.813.62 15,271.19 810,542.43
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 07/31/2000
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
WASTE MANAGEMENT
CHILD CARE
ACTIVII'Y TOTAL
CULTURE & LEISURE SERVICES
LIBRARY SERVICES
CULTURAL ACTIVITIES
HERITAGE CENTER
DUBLIN CEMETERY
PARK MAINTENANCE
COMMUNITY TV
RECREATION ADMIN
PLAYGROUNDS
SHANNON CENTER
PRESCHOOL
TEENS PROGRAM
ADULT SPORTS
YOLFFH SPORTS
COMMUNITY GYM
SPECIAL EVENTS
SENIOR CENTER
RECREATION INSTRUCTION
AQUATICS
PARKS/FACILITIES MANAGEMENT
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
BUILDING SAFETY
ENGINEERING
ECONOMIC DEVELOPMENT
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROjECTS
COMMUNITY IMPROVEMENTS
PARKS
STREET CONSTRC/IMPROVEMENTS
ACTIVITY TOTAL
TOTAL EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT FROM OTHER FUNDS
7,390.00
12,000.00
19,390.00
362,922.00
51,608.00
67,861.00
33,337.00
858,807.00
69.852.00
312,313.00
213,209.00
233,841.00
55,790.00
105,053.00
75,762.00
75,044.00
34,035.00
248,184.00
144,986.00
129,585.00
278.195.00
96,315.00
3,446.699.00
1,197,308.00
1,313,919.00
1,816,058.00
300,190.00
4,627,475.00
2,507,540.00
374,583.00
506,976.00
936,590.00
4,325,689.00
27.066.487.00
5.433.788.00
632.22
1,520.62
7,615.82
7,593.62
4,177.51
1,295.60
3,657.55
1,496.03
1,756.27
83.79
6,797.94
3,257.09
2,553.39
18,297.80
3.133.11
63,868.36
26,693.07
12,007.60
32,598.26
3,989.37
75,288.30
211,137.84
994.113.62
7,390.00
12,000.00
19,390.00
362.922.00
50,975.78
66,340.38
33,337.00
858,807.00
69,852.00
304,697.18
205 615.38
229 663.49
54494.40
101395.45
74 265.97
73 287.73
33 951.21
241 386.06
14~.728.91
127,031.61
259,897.20
93,181.89
3,382,830.64
1,170,614.93
1,301,911.40
1,783,459.74
296,200.63
4,552,186.70
2,507,540.00
374.583.00
506,976.00
936,590.00
4,325,689.00
26,855.349.16
4,439,674.38
7,085.81
12,000.00
19,085.81
342,557.00
53,367.37
56,041.75
30,225.33
633,590.64
66,950.70
268,010.90
145,350.76
195,568.95
47,449.90
75,134.57
63,793.38
67,900.31
28,795.78
· 218,102.49
115.557.53
102,256.75
228,822.22
85,705.46
2,825,181.79
1,250,742.64
1,053.067.17
1,460,679.29
334,514.99
4,099,004.09
1,031,530.09
234.423.08
723,705.98
117,203.65
2.106,862.80
21,586,182.80
8.305,704.6t
1,790.15
13,432.32
9,255.72
4,849.10
2,106.01
1,756.64
1,705.34
4,493.72
4,136.25
2,920.07
2,980.60
19,646.51
2,788.74
71,861.17
40,943.20
8,457.61
20.898.96
136.19
70,435.96
67.80
288.28
1,144.10
1,500.18
652,502.22
4t8,148.54
7,085.81
12,000.00
19,085.81
342,557.00
53,367.37
54,251.60
30.225.33
633.590.64
66,950.70
254,578.58
136.095.04
190,719.85
45.343.89
73,377.93
62,088.04
63,406.59
28,795.78
213,966.24
112.637.46
99,276.15
209.175.71
82,916.72
2.753,320.62
1,209,799.44
1,044,609.56
1,439,780.33
334,378.80
4,028,568.13
1,031,530.09
234.355.28
723,417.70
116,059.55
2,105,362.62
20,933,680.58
7,887,556.07
REVENUES OVER(UNDER) EXPENDITURES 5,433,788.00 994,113.62 4,439,674.38 8,305,704.61 418,148.54 ,887,556.07
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 07/31/2000
SPECIAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
,~**REVENUES~
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,850.00 82,850.00 77,916.49 77,916.49
194,000.00 12,776.09 181,223.91 192,662.02 205,438.11 (12,776.09)
89,475.00 89,475.00 113,370.96 113,370.96
100,676.00 100,676.00 27,034.22 27,034.22
2,024,858.00 2,024,858.00 629,750.40 629,750.40
137,780.00 137,780;00 132,904.00 132,904.00
1,026,394.00 1,026,394.00 87,679.67 87,679.67
763,302.00 763,302.00 724,750.40 724,750.40
5,000.00 5,000.00 40,601.31 40,601.31
4,424,335.00 12,776.09 4,411,558.91.2,026,669.47 2,039,445.56 (12,776.09)
~***~EXpENDITURES~
PUBLIC SAFETY: POLICE
TRAFFIC SIGNALS & STREET LTG
FIRE SERVICES
ACTIVITY TOTAL
TRANSPORTATION:
STREET MAINTENANCE
STREET SWEEPING
ACTIVITY TOTAL
HEALTH & WELFARE:-
WASTE MANAGEMENT
SENIOR SUPPORT CARE
HOUSING PROGRAMS
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
TRAuNSFER IN FROM OTHER FUNDS
TRANSFERS OUTTO OTHER FUNDS
139,290.00
141,645.00
89.125.00
370,060.00
626,322.00
626,322.00
1,169,535.00
7,500.00
10,000.00
1,187,035.00
6,000.00
6,000.00
285,004.00
8.820.00
2,560,234.00
2.854,058.00
5,043.475.00
619.140.00
1.569.12
1,569.12
1,569.12
(11,206.97)
139.290.00
141,645.0'0
89,125.00
370.060.q0
626,322.00
626,322.00
1,169,535.00
7,500.00
10,000.00
1,187,035.00
6,000.00
6,000.00
285,004.00
8.820.00
2,558,664.88
2,852,488.88
5,041,905.88
630,346.97
88,258.42
121,790.46
79,100.67
289,149.55
533.583.10
533,583.10
866,2t9.67
866,219.67
6,000.00
6.000.00
13,997.81
59,614.67
20,517.41
408,087.86
502.217.75
2,197,170.07
170,500.60
88,258.42
121.790.46
79,100.67
289,149.55
533,583.10
533,583.10
866,219.67
866,219.67
6,000.00
6,000.00
13,997.81
59,614.67
20,517.41
409.656.98
503.786.87
2,198,739.19
159,293.63
(1.569.12)
(t.569.12)
(t.569.12)
11,206.97
EXCESS <REVENUE> EXPENDITURE 619,140.00 (tl,206.97) 630,346.97 170,500.60 159,293.63 11.206.97
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 07/31/2000
SPECIAL ASSESSMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
~,~A~REVENUES~
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
390,388.00
13,589.00
6.000.00
409,977.00
390,388.00
13,589.00
6,000.00
409,977.00
315,835.83
4,876.24
668.85
321,380.92
315,835.83
4.876.24
668.85
321,380.92
~EXpENDiTURES~
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
172,115.00
172.115.00
4,480.00
12,039.00
239,352.00
255,871.00
4,760.00
4,760.00
52,840.00
52,840.00
485.586.00
75,609.00
1,000.00
1.000.00
283.71
283.71
1,283.71
1,283.71
171,115.00
171,115.00
4,196.29
12,039.00
239.352.00
255,587.29
4.760.00
4,760.00
52,840.00
52,840.00
484.302.29
74,325.29
118,667.18
118.667.18
3,613.20
4,219.57
131,200.04
139,032.81
4,495.98
4,495.98
27,972.00
46,752.16
74,724.16
336,920.13
15,539.21
1.000.00
1.000.00
286.64
286.64
1,286.64
1,286.64
1t7,667.18
1t7.667.18
3,326.56
4,219.57
13t,200.04
138.746.17
4,495.98
4,495.98
27,972.00
46.752.16
74,724.16
335,633.49
14,252.57
EXCESS <REVENUE>EXPENDITURE 75,609.00 1.283.71 74,325.29 15,539.21 1,286.64 14,252.57
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 07/31/2000
CAPITAL IMPROVEMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
~REVENUE~
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
18.729,643.00
18,729,643.00
196,773.67
18,729,643.00
18,729,643.00 196,773.67
239.92
239.92
196.773.67
(239.92)
196,533.75
A~A~A~EXpENDITURES~,~
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNII'Y DEVELOPMENT
PLANNING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP 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
12,634.00
12,634.00
1,628,667.00
1.204,210.00
15,884,132.00
18,717,009.00
18,729.643.00
1.303.52
1,303.52
1,303.52
1,303.52
12.634.00 12,389.68
12.634.00 12,389.68
1,628.667.00 2.122,917.18
1,204.210.00 6.056,106.29
15.882,828.48 2,428.564.76
18,715,705.48 10,607,588.23
18,728.339.48 10.619,977.91
(1,303.52) 10,423,204.24
56.72
56.72
480.00
771.79
2,219.38
3,471.17
3,527.89
3.287.97
12,332.96
12,332.96
2,122,437.18
6.055,334.50
2.426,345.38
10,604,117.06
10,616.450.02
10,419,916.27
EXCESS <REVENUE>EXPENDITURE 1.303.52 (1,303.52) 10,423,204.24 3,287.97 10.419,916.27
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 07/31/2000
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
~REVENUES~k~
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
233.189.54
6.452.07
239.641.61
233,189.54
6,452.07
239,641.61
*******EXpENDITURES~
GENEP, AL 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
507.79 (507.79) 261.375.75
507.79 (507.79) '261.375.75
507.79 (507.79) 261.375.75
507.79 (507.79) 21.734.14
507.79 (507.79) 21.734:14
261.375.75
261,375.75
261,375.75
21,734.14
21,734.14
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 07/31/2000
INTERNAL SERVICE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARI/~J~CE FISCAL YEAR Y.T.D.
VARIANCE
~x~REVENUES~
USES/MONEY & PROP-INTEREST
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
187,672.00
919,498.00
17,000.00
1,124,170.00
187,672.00
919,498.00
17,000.00
1,124,170.00
14,165.24
517,710.38
42,214.73
574,090.35
48,317.05
48,317.05
14.165.24
469.393.33
42,214.73
525,773.30
~EXpENDiTURES~
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
981,790.00
1.010.615.00
1,056.00
1.056.00
980,734.00
1.009.559.00
251,603.17
251,603.17
12,023.00
12,023.00
239,580.17
239,580.17
T 0 T A. L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
1.010.615.00
(113.555.00)
1,056.00
1.056.00
1.009,559.00
(114,611.00)
251,603.17
(322,487.18)
12.023.00
(36.294.05)
239,580.17
(286,193.13)
EXCESS <REVENUE>EXPENDITURE (113,555.00) 1.056.00 (114,611.00) (322,487.18) (36.294.05) (286,193.13)
~REVENUES~
USES/MONEY & PROP-INTEREST
TOTAUREVENUE
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THRUGH 07/31/2000
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BU[X3ET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
~EXpENDITURES~
GENEP, AL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
A,CI'IVII'Y TOTAL
PUBLIC SAFETY:
HEALTH & WELFA.RE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TP, ANSFERS IN FROM OTHER FUNDS
TP, ANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE
10.00
10.00
10.00
10.00
10.00
10.00
10.00
10.00
10.00
10.00
10.00
344.50
354.50
35~.50
354.50
354.5O
10.00
344.50
354.50
354.50
354.50
354.50