HomeMy WebLinkAbout4.03 PrelFinRpt July2001CITY CLERK
File # 330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: September 4, 2001
SUBJECT:
ATTACHMENTS:
RECOMMENDATION: ~'
FINANCIAL STATEMENT:
Preliminary Financial Reports For the Month of
July 2001
Report Prepared by: Carole A. Perry, Administrative Services
Director and Fred Marsh, Finance Manager
YTD Revenues and Budget Comparison
YTD Expenses and Budget Comparison
Financial Statements for the Month of July 2001
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 July. The final audited results of Fiscal Year 2000/2001 are not yet available, therefore, this report is
presented as "preliminary" at this time. Preliminary Financial Results for Fiscal Year 2000-2001 (subject
to adjustments from the City's annual audit) will be presented at the October 2, 2001 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, Reporting of Information
The auditors will start the final phase of their field work necessary for the 2000/2001 audit in September
2001. 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, July 2001 Revenue and Expenditure Report
Given that this is only the first 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 als°a lag with the reporting
of expenditures due to the significant amount of services provided to the City by independent contractors.
General Fund Revenues
Total General Fund Revenues collected through July are comparable to what occurred in the first month of
the previous Fiscal Year. The City had collected through July 2001 approximately 4% of the total
budgeted General Fund Revenues compared to approximately 4% in the prior Fiscal Year.
cOPIES TO:
G:~VIonthly Financiais\072001 agenda statement monthly financials.doc
ITEM NO.
General Fund Expenditures
Overall, through the month of July expenditures in the General Fund totaled $560,657 and represented
approximately 2% of the total budgeted expenditures in the General Fund. Of this amount, a total of
$47,709 was related to Capital Improvement Projects and the remainder was related to Operating Costs
reported in the General Fund. Capital Project expenditures typically do not follow an even distribution
due to differences in project timing.
In looking at only General Fund Operating Expenditures, the activity through July 2001 was comparable
to the amounts expended for the same period in the prior Fiscal Year. As of July 31, 2001, the City had
expended 2% of the General Fund Operating Budget compared to 2% in the prior Fiscal Year. As
previously noted there are some timing differences with payment for contract services, which complicate
comparisons between one year to the next. All expenditures to date are within the authorized budget.
It is recommended that the City Council receive these reports as authorized by Section 41004 of the
California Government Code.
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
City of Dublin 2001-2002 yTD Revenues and Budget Comparison
For the Period Ending July 31, 2001
........................................................................................................
4%
%
%
i7%
~6%
0%
O%
0%
O%
~8%
7O/o
~i 7%
13%
2%
~17%
~5%
~%
[] FY 2001/2002
~ FY 2000/2001
0% 30% 60% 90% 120°/o 150%
8% of Year Complete
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovemmental
Charges for Services
Fines and Forfeitures
Other Revenues
Total General Fund Revenues
Date Pdnted: 8/22/0t 6:00 PM
FY 2001/02 FY 2001102 % of FY 2000101
Budget YTD Actual Budget YTD Actual
8,258,100 0%
13,200,000 860,500 7% 698,700
450,000 0%
1,035,000 0%
1,254,830 0%
2,957,140 168,702 6% 227,330
1,787,578 6,215 0% 116,057
1,948,150 133,232 7% 135,642
3,859,216 112,744 3% 92,199
102,000 6,708 7% 5,700
1,021,672 28,895 3% 39,804
35,873,686 1,316,996 4% 1,315,432
% of Total for
FY 2000101
0%
6%
0%
0%
0%
8%
5%
7%
2%
5%
2%
4%
ATTACHMENT
City of Dublin 2001-2002 YTD Expenses and Budget Comparison
For the Period Ending July 31, 2001
Total General Fund
Expenses
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
2%2%
1%
0%'
0%
1O/o
2%
0%
0%
34°/o
3%
]1%
0%
0% 20% 40% 60% 80% 100%
8% of Year Complete
[] FY 2001/02
· FY 2000/01
General Government
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 2001102
Budget
FY 2001/02 % of
YTD Actual Budget
FY 2000101
YTD Actual
3,837,268 114,296 3% 104,162
6,798,924 40,142 1% 30,390
4,663,477 17,925 0% 14,841
292,463 2,666 1% 2,814
1,127,147 27,279 2% 20,239
64,495 0 0%
4,265,669 166,336 4% 91,579
5,647,549 144,304 3% 128,410
8,030,596 47,709 1%
560,657 2%
512,948 2%
34,727,588
26,696,992
392,435
392,435
%ofTotalfor
FY200010J
3%
1%
O%
1%
2%
O%
3%
3%
O%
2%
2%
D .......... ~7~0~ ~ ..... ATTACHMENT 2
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF JULY 2001
Prepared by
The Finance Department
August 8, 2001
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Ju12001
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
(33,954.806)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
74.945.557
552.954
312,860
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
12.514
41,869.078
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
(758,306)
(72,600)
(414,998)
(2,117.748)
(330.661)
(52.266)
(149.497)
(3.896,076)
(37,973.002)
TOTAL FUND E (37.973.002)
2.100.750
57.991
2,158.741
(160.923)
459.113 26,480,437
109.300
459,113 26,589.737
(34.451.440)
(22,338). (265,296)
(160.923) (22.338) (34,716.736)
(1,997.818) (436,775) 8,126.998
(1,997,818) (436.775) 8,126.998
175.176
166.814
(4,975,415) (22.986,810)
166.814 166,814
109,300' 109.300
74,945.557 76,149,328
610.945 1,642.039
312.860 744.407
1.652,500
1.994,490
12.514 5,883
1.652.500 1.652.500
72,835,074 57.483,461
(758,306) (520.390)
(34.524.040) (18,700.081)
(414.998) (414.923)
(2.566.304) (3,217,616)
(330.661)
(52.266)
(149.497)
(1,770.000) (1,770,000)
(1.~70.000) (40,566.072)
(224,490) (32.269,001)
(224.490) (32,269.001)
(547,869)
(52,266)
(149.497)
(1.770.000)
(25.372.643)
(32.110,819)
(32.110,819)
TOTAL LIAB. FND BAL. RETD (41,869,078) (2.158.741) (459.113) (26.589,737) (1.994.490) (72.835.074) (57.483,461)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Ju12001
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
5,326,328
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
21,105,766
26,432,094
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS (2,047)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (2,047)
FUND BALANCES (26.430,047)
TOTAL FUND E (26,430,047)
8,626,020
47,878,408
8,626,020 47,878,408
(8,626,020)
(8,626,020)
(47,878,408)
(47.878,408)
2,649.615 2.607,765
6,495
29,731,786 29.731,786
47.878.408 47,878,408
80,.259,809 80,224,454
(2,047) (4,246)
(47,878,408) (47,878,408)
(47,880,455) (47,882.655)
(32,379,354) 32,341,800)
(32,379,354) 32,341,800)
TOTAL LIAB. FND BAL. RETD (26,432,094) (8,626,020) (47,878,408) (80,259,809) 80,224,454)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES ,~
FOR THE PERIOD
07/01/2001 THROUGH 07/31/2001
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
*********************
PROPERTY TAXES
SALES TAX
REAL PROPERTY TRANSFER TAX
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
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL
CITY MANAGER
CENTRAL SERVICES
CITY A1-FORNEY
ADMIN SERVICES
BUILDING MANAGEMENT
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 MAINTENAN
ACTIVITY TOTAL
HEALTH & WELFARE
8,258,100.00
13,200,000.00
450,000.00
1,035,000.00
1,254,830.00
2,957,140.00
102,000.00
1,688,988.00
98,590.00
1,948,150.00
8,258,100.00 7,473,600.79
860,500.00 12,339,500.00 12,177,358.01
450.000.00 575,281.78
1,035,000.00 1,010,799.01
1,254,830.00 1,138,841.17
168,701.81 2,788,438.19 3,028,955.28
6,708.92 95,29~.08 106,678.99
495.00 1~688,493.00 3,576,542.32
5,719.95 92,870.05 111,093.30
133,231.52 1,814,918.48 2,006,116.43
698,700.00
227,329.83
5,700.00
111,246.29
4,810.74
135,642.38
7,473,600.79
11,478,658.01
575,281.78
1,010,799.01
1,138,841.17
2,801,625.45
100,978.99
3,465,296.03
106,282.56
1,870,474.05
3,859,216.00 112,743.85 3,746,472.15 3,708,280.54 92,198.54 3,616,082.00
1,021,672.00 28,894.50 992,777.50 2,750,044.35 39,803.63 2,710,240.72
35,873,686.00 1,316,995.55 34,556,690.45 37,663,591.97 1,315,43i.41 36,348,160.56
157 648.08
451 303.65
254 397.62
566 876.47
755 325.08
559 897.45
242 231.09
12,013.21
2,999,692.66
4,465,397.70
49,327.13
136,903.24
41,742.09
4,330,515.41
9,023,885.57
504,382.13
79.88
105,015.72
52,929.17
290,757.23
953,164.13
229,439.00
684,838.00
286,157.00
469,339.00
958,814.00
681,962.00
389,315.00
1,532.00
135,872.00
3,837,268.00
6,798,924.00
63,495.00
180,757~00
48,211.0'0
4.663,477.00
11,754,864.00
574,025.00
6,406.00
139,200.00
55,629.00
351,887.00
1,127,147.00
19,377.80
23,517.34
12,260.86
40,577.17
8.429.02
104,162.19
30,389.77
2,814.42
14,841.08
48~045.27
20,239.24
20,239.24
12,257.18 217,181.82
27,063.31 657,774.69
14,308.90 271,848.10
469,339.00
50,760.22 908,053.78
9,369.17 672,592.83
537.55 388,777.45
1,532.00
135,872.00
114,296.33 3,722,971.67
40,141.73 6,758,782.27
63,495.00
180,757.00
2,665.70 45,545.30
17,925.04 4,645,551.96
60,732.47 11,694,131.53
27,279.48 546,745.52
6,406.00
139,200.00
55,629.00
351,887.00
27,279.48 1,099,867.52
138,270.28
427,786.31
242,136.77
566,876.47
714~747.91
551,468.43
242,231.09
12,013.21
2,895,530.47
4,435,007.93
49,327.13
136,903.24
38,927.67
4,315,674.33
8,975,840.30
484,142.89
79.88
105,015.72
52,929.17
290,757.23
932,924.89
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 07/31/2001
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
WASTE MANAGEMENT
CHILD CARE
HOUSING PROGRAMS
ACTIVITY 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
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
REVENUES OVER(UNDER) EXPENDITURES
8,395.O0
15,000.00
41,100.00
64,495.OO
400,725.00
148,028.00
84,170.00
39,687.00
1,138,122.00
81,482.00
398,810.00
236,890.00
265,856.00
58,975.00
108,839.00
80,704.00
93,023.00
37,990.00
256,707.00
156,680.00
130;122.00
368,051.00
180,807.00
4,265,669.00
1.764,970.00
1,622,000.00
1,999,416.00
261,163.00
5,647,549.00
5,200,547.00
1,170,874.00
665,863.00
993,212.00
8,030,596.00
34,727,588.00
1,146,098.00
1,146,098.00
50,136.31
2,144.57
18,729.49
13,303.39
8,633.48
3,154.63
5,426.11
2.681.05
2,710.01
1,212.05
18,216.27
8,541.35
2,696.26
21,470.89
6,280.60
166,336.46
62,268.18
23,749.47
50,989.45
7,296.81
144,303.91
46,922.82
251.60
524.41
47,708.83
560,657.48
756,338.07
756,338.07
8,395.00
15,000.00
41,100.00
64.495.00
400,725.00
97,891.69
82,025.43
39,687.00
1,138,123.00
81,482.00
380,080.5t
223,586.61
257,222.52
55,820.37
103,412.89
78,022.95
90,312.99
36,777.95
238,490.73
148,138.65
126,425.74
346,580.11
174,526.40
4,099,332.54
1,702,701.82
1,598,250.53
1,948,426.55
253,866.19
5,503,245.09
5,153,614.18
1,170,874.00
665,611.40
992,787.59
7,982,887.17
34,166,930.52
389.759.93
389.759.93
1,483.29
12,000.00
13.483.29
362,922.00
48,979.05
64,323.04
35 029.30
843 738.61
65 359.53
299 351.76
179 746.06
223 279.64
53 781.57
95,263.42
71,566.23
76,387.85
23,550.81
200,941.25
137,734.65
116,758.13
298,178.13
95,706.26
3,292,597.29
1,324,548.16
1,334,871.77
1,604,523.67
254,451.86
4,518,395.46
964,643.51
180,763.51
462,226.74
567,071.79
2,174,705.55
22,975,923.95
14,687,668.02
17,201.67
(2,400,190.01)
12,304,679.68
968.96
2,343.12
14.236.86
9,260.55
9,132.10
3,157.64
4,572.14
2,149.66
2,409.74
83.79
8,632.23
5,561.61
4,120.19
19,955.20
4,995.15
91,579.04
50,868.65
20,961.60
50,255.48
6,323.78
128,409.51
392.435.25
922,996.16
922,996.16
1,483.29
12,000.00
13,483.29
362,922.00
48,010.09
61,979.92
35,029.30
843,738.61
65,359.53
285,114.90
170,485.51
214,147.54
50,623.93
90,691.28
69,416.57
73.978.11
23,467.02
192,309~02
132,173.04
112,637.94
278,222.83
90,711.11
3,201,018.25
1,273,679.51
1,313,910.17
1,554,268.19
248.128.08
4,389,985.95
964,643.51
180,763.51
462,226.74
567,071.79
2,174,705.55
22,583,488.70
13,764,671.86
17,201.67
(2,400,190.01)
11,381,683.52
THE CITY OF DUBLIN STATEMENT sHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 07/31/2001
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
**************************
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
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE> EXPENDITURE
90,175.00
230,500.00
145,155.00
110,312.00
3,303,769.00
234,000.00
1,122,338.00
876,760.00
5,000.00
6,118,009.00
302,730.00
175,041.00
177,100.00
654,871.00
175,084.00
175,084.00
1,049,577.00
7,5O0.0O
10,000.00
1,067,077.00
6,000.00
6,000.00
80,273.00
411,119.00
4,678,511.00
5,170,003.00
7,073,035.00
955,026.00
90,175.00 80,718.02
i5,439.75 215,060.25 218,443.36
145,155.00 126,860.43
110,312.00 91,898.87
3,303,769.00 1,095,795.37
234,000.00 235,575.00
1,122,338.00 112,206.27
876,760.00 756,956.73
5,000.00 17,930.25
15,439.75 6,102,569.25 2,736,384.30
1.338.34 301,391.66 91,937.68
175,041.00 .87,388.36
177,100.00 188,299.58
1,338.34 653,532.66 367,625.62
175,084.00 348,601.71
175,084.00 348,601.71
1,049,577.00 1,108,496.91
7,500.00 7,500.00
10,000.00 8,796.82
1,067,077.00 1,124,793.73
1.001.00 4,999.00 4,999.00
1,001.00 4,999.00 4,999.00
80,372.00 86,648.98
411,119.00
288.20 4,678,222.80 797,307.95
288.20 5~169,714.80 883,956.93
2,729,976.99
(6,407.31)
15,061.59
955,026.00 (12,812.21) 967,838.21 8,654.28
2,627.54 7,07Q,407.46
(12,812.21) 967,838.21
12,776.09
12,776.09
1,569.12
1,569.12
1,569.12
11,206.97)
11,206.97)
80,718.02
205 667.27
126 860.43
91 898.87
1,095 795.37
235 575.00
112 206.27
756 956.73
17 930.25
2,723,608.21
91,937.68
87,388.36
188,299.58
367,625.62
348,601.71
348,601.71
1,108,496.91
7,500.00
8,796.82
1,124,793.73
4,999.00
4,999.00
~ 86,648.98
795,738.83
882.387.81
2,728,407.87
4,799.66
15,061.59
19,861.25
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 07/31/2001
SPECIAL ASSESSMENT FUND
CURRENT
BUDGET
CURRENT PRIOR
ACTUAL VARIANCE FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
**********************
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
429,448.00
20,187.00
6,000.00
455,635.00
429,448.00 281,464.74
20,187.00 12,942.44
6,000.00 2,300.37
455,635.00 396,707.55
381,464.74
12,942.44
2,300.37
396,707.55
*******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 O,T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
230,635.00 1,200.00 229,435.00 118,925.62 1,000.00 117,925.62
230,635.00 1,200.00 229,435.00 118,925.62 1,000.00 117.925.62
4,807.00
15,065.00
280,667.00
300,539.00
7,115.00
7,115.00
538,289.00
82,654.00
196.15 4,610.85 2,753.02
15,065.00 4,175.26
280.667.00 126,489.46
196.15 300,342.85 133.417.74
7,115.00 11,050.38
7,115.00 11,050.38
2,519.14
2,519.14
1,396.15 536,892.85 265.912.88
1,396.15 81,257.85 (130,794.67)
283.71
283.71
1,283.71
1,283.71
2,469.31
4,175.26
126,489.46
133,134.03
11,050.38
11,050.38
2,519.14
2,519.14
264,629.17
(132,078.38)
EXCESS <REVENUE>EXPENDITURE 82,654.00 1,396.15 81,257.85 (130,794.67) 1.283.71 (132,078.38)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 07/31/2001
CAPI AL IMPROVEMENT FUND
CURRENT
BUDGET
CURRENT PRIOR PRIOR
ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
**********************
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
1,640,682.00
37,719,269.00
39,359,951.00
1,640,682.00 789,214.44
37.719,269.00 5,283.19
39,359,951.00 794,497.63
789,214.44
5,283.19
794,497.63
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS
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 OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE
1,854,726.00
12.867.967.00
1,121,430.00
15,131,302.00
29,130,699.00
30,985,425.00
(8,374.526.00)
(8,374.526.00.)
336.92
816.83
816.83
2,340.46
2,340.46
3,494.21
3,494.21
3,494.21
1,854,389.08
(816.83)
(816.83)
12,867,967.00
1,131,430.00
15,128,961.54
29,128,358.54
30,981,930.79
(8,378,020.21)
(8.378,020.21)
30,854.96
30,854.96
1,392,997.05
18,854.85
7,890,553.22
9,302,405.12
9,333,260.08
8,538,762.45
1,140.08
8,539,902.53
4,159,790.52
4,159,790.52
4,159,790.52
4.159,790.52
4.159,790.52
30,854.96
30,854~96
1,392,997.05
18,854.85
3,730,762.70
5,142,614.60
5.173,469.56
4,378.971.93
1,140.08
4,380,112.01
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 07/31/2001
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
//
VARIANCE
***********************
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
237,172.56
12,128.59
249,301.15
237,172.56
12,128.59
249,201.15
*******EXPENDITURES*******
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
232,578.00
232,578.00
232,578.00
232,578.00
232.578.OO
232,578.00
232,578.00
232,578.00
232,578.00
232,578.00
234,093.57
234,093.57
234,093.57
(15,207.58)
(15,207.58)
507.79
507.79
507.79
507.79
507.79
233,585.78
233,585.78
233,585.78
(15,715.37)
(15,715.27)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 07/31/2001
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
298,835.00
1,171,448.00
17,000.00
93,454.87
298,835.00 96,664.80
1,077,993.13 944,535.35
17,000.00 6,495.00
104,492.43
96,664.80
840,042.92
6,495.00
1,487,283.00 93,454.87 1,393,828.13 1,047,695.15 104,492.43 943.202.72
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
FIRE
ACTIVITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
990,046.00 29,366.38 960,679.62 504,555.13 1,056.00 503,499.13
990,046.00 29,366.38 960,679.62 504,555.13 1,056.00 503,499.13
45,828.00
45,828.00
189.750.00
45,828.00 40,700.28
45,828.00 40,700.28
189,750.00 20,576.74
40,700.28
40,700.28
20,576.74
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE
1,225,624.00
(261,659.00)
(261,659.00)
29,366.38
(64,088.49)
(64.088.49)
1,196,257.62 565,832.15
(197,570.51) (481,862.00)
2,400,000.00
(197,570.51) (2,881,863.00)
1,056.00 564,776.15
103,436.43) (378,426.57)
2,400,000.00
103,436.43)(2,778,426.57)
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 07/31/2001
ENTERPRISE
FUND
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
Y.T.D~
VARIANCE
***********************
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENDITURES*******
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
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
EXCESS <REVENUE>EXPENDITURE 20.00 20.00