HomeMy WebLinkAboutItem 4.10 FinRpts Oct 2001CITY CLERK FILE # 330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: November 20, 2001
SUBJECT:
ATTACHMENTS:
RECOMMENDATION:/~
FINANCIAL STATEMENT:
Financial Reports For the Month of October 2001
Report Prepared by: Carole Perry, Administrative Services Director
and Fred Marsh, Finance Manager
'1.
2.
3.
YTD Revenues and Budget Comparison
YTD Expenses and Budget Comparison
Financial Statements for the Month of October 2001
Receive the reports.
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report of the financial statements for the month of October.
The current monthly report includes the final audited results for Fiscal Year 2000/2001. 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.
Analysis of October 2001 Revenue and Expenditure Report
Given that this is only the fourth month of the 2001/2002 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 October are comparable to what occurred in the fourth
month of the pre~vious Fiscal Year. The City had collected through October 2001 approximately 21% of
the total budgeted General Fund Revenues, which was the same percentage as in the prior Fiscal Year.
Real Property Transfer Tax is lower than in the same period in the prior year due to a decrease in the
dollar amount of residential and commercial property sales transactions within the City.
Franchise Taxes are higher than in the same period of the prior year due to timing differences in the
receipt of Cable TV Franchise Taxes. Licenses and Permits are lower than in the same period of the prior
year due to a decline in the valu, ation of building permits issued on new residential and commercial
projects. Interest and Rentals are lower than in the same period of the prior year due to a decline in
interest rates and timing differences in the receipt of interest earnings fi.om the City's investments.
COPIES TO:
G:\Monthly Financials\102001 agenda statement monthly financials.doc
ITEM NO.
Charges for Services are higher than in the same period of the prior year due to the receipt of one time
monies from AT&T for cable equipment, and additional monies received for planning and fire plan check
fees for work performed by staff and consultants on new development occurring within the City. Fines
and Forfeitures are higher than in the prior year due to an increase in the number of traffic citations issued
over the prior year. Other Revenue is higher than in the same period of the prior year due to
reimbursements received from DSRSD for costs incurred on the Dublin Boulevard Widening project from
Dougherty Road to Scarlett Drive.
General Fund Expenditures
· Overall, through the month of October expenditures in~ the General Fund totaled $5,174,703 and
represented approximately 15% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $1,t71,928 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 pl~oject timing. The amount spent on Capital Projects is higher than
in the same period of the prior year due to expenditures incurred in the initial stages of construction of the
City's new library.
In looking at only General Fund Operating Expenditures, the activity through October '2001 was
comparable to the amounts expended for the same period in the prior Fiscal Year. As of October 30,
2001, the City had expended 15% of the General Fund Operating Budget, which was the same percentage
as 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.
City of Dublin 2001-2002 YTD Revenues and Budget Comparison
For the Period Ending October 31, 2001
Total General Fund Revenues ~ 221 ~/~
Property Taxes ~6~/~
Sales Taxes 5Ofo/°
· FY 2001/2002
Real Property Transfer Tax ~!9~ ~% FY 2000/2001
Transient Occupancy Taxes 22~
Franchise Taxes 1 %
Licenses and Permits
Interest and Rentals
Intergovernmental from State
Charges for Services ~o35%
Fines and Forfeitures ~139%
Other Revenues ~ ~ 3%
0% 30% 60% 90% 120% 150%
33% 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
Total General Fund Revenues
FY 2001102 FY 2001102 % of FY 2000101 % of Total for
Budget YTD Actual Budget YTD Actual FY 2000/01
8,258,100 527,038 6% 413,589 6%
13,200,000 3,247,033 25% 2,886,627 22%
450,000 86,531 19% 153,382 27%
1,035,000 211,068 20% 227,285 22%
1,254,830 261,606 21% 141,786 11%
2,957,140 594,890 20% 1,429,649 47%
1,787,578 494,774 28% 891,778 34%
1,948,150 639,042 33% 620,061 31%
3,859,216 1,347,688 35% 804,372 22%
102,000 39,793 39% 32,472 31%
1,030,772 239,911 23% 93,375 3%
35,882,786 7,689,374 21%
7,694,376 21%
ATTACHMENT 1
City of Dublin 2001-2002 YTD Expenses and Budget Comparison
For the Period Ending October 31, 2001
Total General Fund
Expenses
General Government
Police
Fire ~/,
Other Public Safety
% : ·FY2001/02
Transportation ~ ~122%~23oA I ~FY2000/01
Health and Welfare ~ ~ 19%
Culture&Community
Services
Community ~~i~$~
~25Y0
Development
Capital Improv.
~ 1 15 '/o
Projects
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
33% of Year Complete
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 2001/02 FY 2001102 % of FY 2000101 % of Total for
Budget YTD Actual Budget YTD Actual FY 2000101
3,863,768 1,012,785 26% 724,645 23%
6,801,424 328,012 5% 264,035 5%
4,672,577 88,247 2% 153,215 4%
292,463 18,438 6% 16,146 7%
1,127,147 244,444 22% 222,951 23%
64,495 2,682 4% 2,510 19%
4,265,669 1,034,561 24% 855,841 26%
5,647,549 1,273,606 23% 1,145,640 25%
8,030,596 1,171,928 15% 63,399 2%
34,765,688 5,174,703 15% 3,448,382 14%
26,735,092 4,002,775 15% 3,384,983 15%
ATTACHMENT 2
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF OCTOBER 2001
Prepared by
The Finance Department
November 13, 2001
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 310ct2001
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
(48,497,983)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
87,815,632
157,651
312,860
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
3,865
39,792,025
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
(834.984)
(9,222)
(400,178)
(727.771)
(333,340)
(35,601)
(146,433)
(2.487,528)
(37,304.496)
TOTAL FUND E (37,304,496)
TOTAL LIAB. FND BAL. RETD (39,792,025)
2.895,903
2.895,903
(27,142)
358,968 40,743,612
109,300
358.968 40,852.912
(41,645,335)
(12,089)
(27.142) (41.657,425)
2.868,761) (358,968) 804,512
2,868,761) (358.968) 804,512
2.895,903)
(358,968) (40,852.912)
12,543
167,304
(4,747,956) (24,052,805)
167,304 166.814
109,300 109,300
87.815,632 76,149,328
157,651 3,517,725
312,860 744,407
1,652,500
1,832,347
3,865
1,652,500
85.471,156
550,856
5,175
1,652.500
58,843,299
(834.984) (512.334)
(41,654.557) (11.556.340)
(400,178) (414,923)
(767,002) (5,323,868)
(333,340) (547.869)
(35.601) (603.122)
(146.433) (147.203)
(1,770,000) (1.770.000) (1.770.000)
(1,770.000) (45.942.095) (20.875.659)
(62.347) (39.529.061) (37,967.640)
(62.347) (39,529,061) (37.967.640)
(1.832.347) (85,471,156)
(58,843,299)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 310ct2001
FIXED ASSETS
GROUP OF
ACCOUNTS
GENERAL LONG
TERM DEBT
ACCOUNT GROUP
TOTALS
---MEMORANDUM---
CURRENT PRI OR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
5.557,428
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
22.149,264
27.706,692
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
TOTAL FUND E
(1)
(1)
27.706.691)
27.706.691)
TOTAL LIAB. FND BAL. RETD 27,706.692)
15,987.209
15.987,209
15,987.209)
15,987.209)
15.987.209)
41,574.550
41,574.550
41.574.550)
41.574.550)
41.574,550)
2,767.138 2,694.870
6,495
38.136.473 38.136.473
41.574.550 41.688.500
82,478.160 82,526.337
(1) (4.446)
(41.574.550) (41,688,500)
(41,574.551) (41.692.946)
(40,903,610) (40.833,391)
(40,903,610) (40.833,3'91)
(82.478,160) (82,526,337)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 10/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 ATTORNEY
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
3,859,216.00
1,030,772.00
35,882,786.00
527,037.54 7,731,062.46 7,174,289.56 413.588.96
3.247,032.98 9,952,967.02 12,985,986.39 2,886,626.52
86,530.64 363,469.36 575.281.78 153,382.30
211,068.t0 823,931.90 1,010,799.01 227,284.94
261,606.42 993,223.58 1,313,086.74 141,786.00
594,890.32. 2,362,249.68 3,028,655.28 1,429,649.35
39,793.20 62,206.80 106,233.99 32,471.75
467,922.02 1,221,065.98 2,512,223.69 864,598.27
26,852.10 71.737.90 1t4,614.48 27,179.93
639,042.34 1.309.107.66 2,006,116.43 620.061.05
1,347,688.39 2,511,527.61 3,719,568.13
239,911.34 790,860.66 2,715,619.50
7,689,375.39 28.193,410.61 37,262,474.98
233.439.00 47,030.21 186,408.79 157,649.46
684,838.00 146,297.07 538,540.93 451,460.84
298,657.00 88,432.71 210,224.29 254,490.40
469,339.00 162.961.83 306,377.17 566,876.47
958,814.00 282,844.29 675,969.71 755.484.16
681,962.00 142,255.19 539,706.81 561,347.95
389,315.00 132,962.05 256,352.95 273,267.70
1,532.00 1.50 1,530.50 12,013.21
145,872.00 10,000.00 135,872.00 53.136.03
3,863,768.00 1,012,784.85 2,850,983.15 3,085,726.22
6,801,424.00 328,012.19 6,472,411.81 5,842,597.93
63,495.00 4,248.79 59,246.21 49,327.13
180,757.00 180,757.00 136,903.24
48,211.00 14,189.13 34,021.87 41,743.47
4.672,577.00 88,246.76 4.584,330.24 4,331,237.29
11,766,464.00 434,696.87 11,331,767.13 10,401,809.06
574.025.00 166,417.81 407,607.19 504,545.32
6,406.00 429.60 5,976.40 79.88
139,200.00 9,631.16 129,568.84 105,015.72
55,629.00 7,723.54 47,905.46 52,929.17
351,887.00 60,241.77 291,645.23 297,191.50
1,127,147.00 244,443.88 882,703.12 959,761.59
804,372.12
93,374.86
7,694,376.05
41 677.54
134 278.77
65 238.75
81 110.99
196 573.23
104 422.04
101 324.40
19.23
724.644.95
264,034.82
3,740.80
12,405.65
153,214.81
433,396.08
138.298.57
22,335.06
8,086.36
54,230.90
222,950.89
6,76O,7O0.60
10,099,359.87
421,899.48
783,514.07
1,171,300.74
1,599,005.93
73,762.24
1,647,625.42
87,434.55
1.386,055.38
2,915,196.01
2,622,244.64
29,568,098.93
115 971.92
317 182.07
189 251.65
485 765.48
558 910.93
456 925.91
171 943.20
11 993.98
53136.03
2,361,081.27
5,578,563.11
45,586.33
136,903.24
29,337.82
4,178,022.48
9,968,412.98
366,246.75
79.88
82,680.66
44,842.81
242,960.60
736,810.70
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 10/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.00
15,000.00
41,100.00
64,495.00
400,725.00
148,028.00
84,170.00
39,687.00
1,138,123.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,765,688.00
1,117,098.00
1,117.098.00
46.38 8,348.62 1.483.29 1,053.88 429.41
1,836.00 13,164.00 12,000.00 1,456.00 10,544.00
800.00 40,300.00
2,682.38 61,812.62 13,483.29 2,509.88 10,973.41
73,149.97
14,451.70
5,457.58
184,244.18
55,857.00
96,564.08
66 699.87
65 283.70
17 196.83
29 515.60
24 599.15
22 248.98
3 254.10
130 797.25
41 369.39
37 227.75
131 934.39
34 709.15
1,024 560.67
401,090.30
343,775.00
413,694.04
115,047.01
1,273,606.35
941,168.68
40,481.51
4,220.61
186.057.44
1,171,928.24
5,174,703.24
2.514,672.15
2,514,672.15
400,725.00
74,878.03
69,718.30
34,229.42
953,878.82
25,625.00
302,245.92
170,190.13
200,572.30
41,778.17
79,323.40
56,104.85
70,774.02
34,735.90
125,909.75
115,310.61
92,894.25
236,116.61
146,097.85
3,231,108.33
1,363,879.70
1,278,225.00
1.585,721.96
146,115.99
4,373,942.65
4,259,378.32
1,130,392.49
661,642.39
807,254.56
6,858,667.76
29,590,984.76
(1,397,574.15)
(1,397.574.15)
362,922.00
48,979.05
64,337.03
35,168.63
863,488.51
65,376.81
299,517.33
179,746.06
223,534.64
54,261.57
95,263.42
74.298.29
76.437'.85
37,226.81
200,963.28
137,807.83
116,758.13
300,625.35
95,707.64
3,332,420.23
1,330,195.42
1,334,934.18
1,606.493.94
254,453.24
4,526,076.78
1,435,693.51
180,763.51
462,208.60
603,894.29
2,682,559.91
25,001.837.08
12,260,637:90
17.201.67
(2,400,000.00)
9,877,839.57
27,686.07
16 881.48
6 214.06
169 835.33
54 949.81
84 576.68
58 771.56
58 957.54
16611.82
27,496.13
18,949.11
23,990.11
2,439.29
57,938.32
43,398.38
29,711.12
128:365.55
29,068.17
855,840.52
358,192.24
260,518.11
389,014.76
137,915.34
1,145,640.45
44,996.72
2,141.55
451.67
15,809.18
63,399.12
3,448,381.90
4.245,994.15
4,245,994.15
362 922.00
'21 292.98
47 455.55
28 954.57
693 653.18
10 427.00
214 940.65
120 974.50
164 577.10
37 649.75
67 767.29
55349.18
52,447.74
34,787.52
143,024.96
94,409.45
87,047.01
172.259.80
66,639.47
2,476,579.70
972,003.18
1,074,416.07
1,217,479.18
1-16,537.90
3,380,436.33
1,390,696.79
178,621.96
461,756.93
588,085.11
2,619,160.79
21,553,455.18
8,014,643.75
17,201.67
(2.400,000.00)
5,631,845.42
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 10/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 SOURCESOF REVENUE
TOTAL REVENUE
*******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
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE> EXPENDITURE
90,175.00 90,175.00 81,587.21
230,500.00 65,903.71 164,596.29 218,443.36
145,155.00 19,106.74 126,048.26 136,129.03
110,312.00 110,312.00 186.396.07
3,303,769.00 382,171.13 2.921,597.87 1,401,011.82
234,000.00 54,082.00 179,918.00 235,575.00
1,122,338.00 20,195.00 1,102,143.00 486.386.87
876,760.00 876,760.00 766,872.19
5,000.00 5,000.00 17,930.25
6,118,009.00 541,458.58 5,576,550.42 3.530~331.80
302,730.00 54..361.41 248,368.59 163,769.23
175,041.00 13,664.96 161,376.04 87.789.56
177,100.00 566.05 176,533.95 188,299.58
654,871.00 68,592.42 586,278.58 439.858.37
175,084.00 14,106.61 160,977.39 348.601.71
175,084.00 14,106.61 160,977.39 348,601.71
1.049,577.00 2,124.70 1,047,452.30 1,108,496.91
7,500.00 7.500.00 7.500.00
10,000.00 10,000.00 9,918.66
1,067,077.00 2,124.70 1,064,952.30 1,125,915.57
6,000.00 1,001.00 4.999.00 4,999.00
6,000.00 1.001.00 4,999.00 4,999.00
7,073.035.00
955,026.00
955,026.00
66,643.86
22.707.07
660,586.59
27,889.00
15,230.00
793.056.52
8,762.07
5,825.34
975.00
15,562.41
59,192.29
59,192.29
203.492.17
203.492.17
81,587.21
151,799.50
113,421.96
186,396.07
740.425.23
207,686.00
471,156.87
766,872.19
17,930.25
2,727,275.28
155,007.16
81,964.22
187,324.58
424,295.96
289,409~42
289.409.42
905,004.74
7,500.00
9,918.66
922,423.40
4,999.00
4,999.00
80,373.00 18.688.96 61,684.04 86,648.98 8,127.81 78.521.17
411,119.00 411,119.00
4,678,511.00 310,572.56 4,367,938.44 760,517.95 70,323.49 690,194.46
5,170,003.00 329,261.52 4,840,741.48 847,166.93 78,451.30 768,715.63
415,086.25 6.657,948.75 2,766,541.58 356,698.17 2,409,843.41
(126,372.33) 1.,081,398.33 (763,790.22) (436,358.35) (327,431.87)
15,061.59 15,061.59
(126.372.33) 1.081,398.33 (748,728.63) (436,358.35) (312.370.28)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 10/31/2001
SPECIAL ASSESSMEN
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
/9
**********************
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
20,187.00
6,000.00
455,635.00
384,648.76
26,456.80
2,300.37
413,405.93
2,300.37
2,300.37
384,648.76
26,456.80
411,105.56
*******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
230,635.00
230,635.00
4,807.00
15.065.00
280,667.00
300,539.00
7,115.00
7,115.00
538,289.00
82,654.00
38,109.80
38,109.80
1,251.62
2,404.70
39,595.32
43,251.64
10,220.76
10,220.76
91,582.20
91,582.20
192,525.20
192,525.20
3,555.38
12,660.30
241,071.68
257,287.36
(3,105.76)
(3,105.76)
446,706.80
(8,928.20)
119,085.13
119,085.13
2,753.02
4,175.26
130,649.00
137,577.28
11,050.38
11,050.38
2,519.14
2,519.14
270.231.93
(143,174.00)
20,256.61
20,256.61
960.83
1.487.63
43,120.55
45,569.01
4,300.08
4,300.08
94.30
94.30
70,220.00
67,919.63
98,828.52
98,828.52
1,792.19
2,687.63
87,528.45
92,008.27
6,750.30
6;750.30
2,424.84
2,424.84
200,011.93
(211,093.63)
EXCESS <REVENUE>EXPENDITURE 82,654.00 91,582.20 (8,928.20) (143,174.00) 67,919.63 (211,093.63)
********REVENUE********
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 10/31/2001
CAPITAL IMPROVEMENT FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
1,640,682.00
37,719,269.00
39.359.951.00
1,640,682.00
37,719,269.00 8,882,376.17
39,359,951.00 8,882,376.17
VARIANCE
8,882,376.17
8.882,376.17
*******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,131,430.00
15,312,405.00
29,311.802.00
31,166,528.00
(8,193,423.00)
(8,193,423.00)
1.347.68
3.129.63
3,129.63
102,541.89
1,118,034.72
1,220,576.61
1.225,053.92
1,225,053.92
1,225.053.92
1.853.378.32
(3,129.63)
(3,129.63)
12,765,425.11
1,131,430.00
14,194,370~28
28,091,225.39
29,941,474.08
(9,418,476.92)
9,418,476.92)
30,854.96
30,854.96
936,862.45
18,854.85
7,890,520.72
8,846,238.02
8.877.092.98
(5,283.19)
1,140.08
(4,143.11)
11,261.32
11,261.32
115,170.30
1,323.21
4,676,808.06
4,793,301.57
4.804,562.89
4,804,562.89
4,804,562.89
19,593.64
19,593.64
821,692.15
17,531.64
3.213.712.66
4.052,936.45
4,072,520.09
(4,809,846.08)
1,140.08
(4,808,706.00)
************************
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 10/31/2001
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
490.25 (490.25)
490.25 (490.25)
237.172.56
16,539.29
253,711.85
VARIANCE
237,172.56
16.539.29
253,711.85
**************************
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
232,578.00 167,044.06 65,533.94 234,093.57 164,624.28 69,469.29
232.578.00 167,044.06 65,533.94 234,093.57 164,624.28 69,469.29
232,578.00 167,044.06 65,533.94 234,093.57 164,624.28 69,469.29
232.578.00 166.553.81 66,024.19 (19,618.28) 164,624.28 (184,242.56)
EXCESS <REVENUE>EXPENDITURE 232,578.00 166,553.81 66,024.19 (19,618.28) 164,624.28 184,242.56)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 10/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 298,835.00 205,273.76
1,171,448.00 350,157.49 821,290.51 944,535.35
17,000.00 4,781.12 12,218.88 6~495.00
1,487,283.00
354,938.61 1,132,344.39 1,156,304.11
313,790.76
205,273.76
630,744.59
6,495.00
313.790.76 842,513.35
*******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
990,046.00
45,828.00
45.828.00
189,750.00
166,095.15 823,950.85 1,018,788.52 107,708.4t 911,080.11
166,095.15 823,950.85 1,0t8,788.52 107,708.41 911,080.11
45,828.00
45,828.00
189,750.00
40,700.28
40,700.28
40,700.28
40,700.28
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
1,225,624.00 166,095.15 1,059,528.85
(261,659.00) (188.843.46) (72,815.54)
1,059,488.80 107,708.41 951,780.39
(96,815.31) (206.082.35) 109,267.04
2,400,000.00 2,400,000.00
EXCESS <REVENUE>EXPENDITURE (261,659.00) (188.843.46) (72,815.54) (2,496,815.31) (206,082.35) (2,290,732.96
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 10/31/2001
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
***********************
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
***************************
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACTIVITY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROOECTS:
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