HomeMy WebLinkAboutItem 4.12 FinRpt Nov 2001CITY CLERK FILE # 330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: December 18, 2001
SUBJECT:
ATTACHMENTS:
RECOMMENDATION: ~
FINANCIAL STATEMENT:
Financial Reports For the Month of November 2001
Report Prepared by: Carole 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 November 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
November. 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 November 2001 Revenue and Expenditure Report
Given that this is only the fifth month of the 2001/2002 Fiscal Year, there is 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 Property Tax revenue will not be
received until December.
General Fund Revenues
Total General Fund Revenues collected through November are comparable to what occurred in the fifth
month of the previous Fiscal Year. The City had collected through November 2001 approximately 27%
of the total budgeted General Fund Revenues, compared to 26% in the prior Fiscal Year. Transient
Occupancy Tax is lower than in the same period of the prior year due to a decline in occupancy rates in
the City's hotels.
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 valuation 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 from the City's investments.
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
COPIES TO:
G:kMonthly Financials\ll2001 agenda statement monthly financials.doc
ITEM NO.
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 November expenditures in the General Fund totaled $8,090,340 and
represented approximately 23% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $1,704,651 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. 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 November 2001 was
comparable to the amounts expended for the same period in the prior Fiscal Year. As of November 30,
2001, the City had expended 24% 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 November 30, 2001
Total General FUnd ReVenues i 6%~7%
Property TaxeS ~66O~o°
Sales Taxes 30 '/o · FY 2001/2002
Real Property Transfer Tax S% ,:i:-.:i FY 2000/2001
Transient Occupancy Taxes ~ 29%
34
Franchise Taxes
Licenses Interest and and Permits Rentals - 2~yo 59%
~42%
I.ntergoVernmental from State % .
~ 44%
Charges for Services
Fines and Forfeitures 6°/
~ 1270/0
Other Revenues ~4%
0% 30% 60% 90% 120% 150%
42% 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 2001/02 % 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 4,432,533 34% 3,902,427 30%
450,000 111,104 25% '153,382 27%
1,035,000 302,338 29% 348,507 34%
1,254,830 318,558 25% 191,839 15%
2,957,140 765,715 26% 1,794,905 59%
1,787,578 506,179 28% 905,613 34%
1,948,150 811,337 42% 752,268 37%
3,889,911 1,697,840 44% 1,171,628 31%
102,000 46,841 46% 37,074 35%
1,068,372 286,499 27% 103,774 4%
35,951,081 9,805,982 27% 9,775,006 26%
~,~.~; .......... ~:~.. ATTACHMENT 1
City of Dublin 2001-2002 YTD Expenses and Budget Comparison
For the Period Ending November 30, 2001
123% ~23%
~~33~
~31%
6%
1%
~~31%
~ 30%
% ~~3(~%
29% ~ 34! /~
19%
Total General Fund
Expenses
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture & Communi~
Services
Community
Development
Capital Improv.
Projects
0% 20% 40% 60% 80% 100%
42% 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 FY 2001/02 % of FY 2000/01
Budget YTD Actual Budget YTD Actual
3,917,768 1,308,142 33% 943,723
6,801,424 388,032 6% 327,517
4,672,577 1,239,179 27% 1,132,055
292,463 28,215 10% 25,269
1,127,147 351,582 31% 289,454
64,495 6,545 10% 3,547
4,332,509 1,407,913 32% 1,192,101
5,660,185 1,656,081 29% 1,551,277
8,827,708 1,704,651 19% 165,964
35,696,276 8,090,340 23% 5,630,907
26,868,568 6,385,689 24% 5,464,943
% of Total for
FY 2000101
31%
6%
26%
11%
30%
26%
36%
34%
6%
23%
24%
ATTACHMENT 2
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF NOVEMBER 2001
Prepared by
The Finance Department
December 11, 2001
ATTACHMENT 3
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Nov2001
GENERAL SPECIAL SPECIAL CAPITAL TRUST/
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUNDS FUND FUND
TOTA S
---MEMORANDUM ONLY---
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
(47,808.891)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
86.170.632
157.651
312,860
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
i2,044
38,844,295
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL (809.709)
DEPOSITS FOR AB1600 FEES (18.768)
DEPOSITS OTHERS (401,353)
PAYABLES: ACCOUNTS (600,846)
INTEREST
PAYROLL (337.122)
DUE TO OTHERS (24.597)
DEFERRED REVENUE (146,433)
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (2,338.828)
FUND BALANCES (36.505.467)
TOTAL FUND E (36.505.467)
2,501,427
2,501,427
(66,172)
(66,172)
2,435,265)
2,435,255)
330.819 40.522,973
109,300
330,819 40,632,273
(41,784,947)
(12.089)
(41.797.036)
(330,819) 1.164.763
(330.819) 1.164,763
12,043
167,304
(4,527,404) (24.052,805)
167.304 166.814
109.300 109.300
86,170,632 76.149.328
157.651 3.517.725
312.860 744.407
1.652.500
1.831.847
12.044
1.652,500
84.054,886
550.856
5,175
1.652.500
58.843.299
(809,709)
(41,803.714)
(401.353)
(659.638)
(337.122)
(24.597)
(146.433)
(1.770,000) (1,770,000)
(1,770,000) (45,952.567)
(61.847) (38,102,320)
(61.847) (38.102,320)
(512.334)
(11.556.340)
(414.923)
(5.323.868)
(547.869)
(603,122)
(147.203)
(1.770.000)
(20,875,659)
(37,967,640)
(37.967,640)
TOTAL LIAB. FND BAL. RETD (38.844.295) (2,501.427) (330.819) (40,632,273) (1.831,847) (84,054.886) (58,843,299)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Nov2001
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,571,203
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,720,467
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
(1)
(1)
(27,720,466)
TOTAL FUND E (27,720,466)
15,987,209
41,566.827
15,987,209 41.566,827
(15,987,209)
(15,987,209)
(41,566,827)
(41.566,827)
2,751,257 2,694.870
6.495
38,136,473 38,136,472
41,566,827 41,688.500
82,454,556 82,526.337
1) (4,446)
(41,566,827) (41,688,500)
(41,566,827) (41,692,946)
(40,887,729) (40,833,391)
(40,887,729) (40,833,391)
TOTAL LIAB. FND BAL. RETD (27,720,467) (15,987,209) (41,566,827) (82,454,556) (82,526,337)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 11/30/2001
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
*********************
PROPERTY TAXES
SALES TAX
REAL PROPERTY TFUNNSFER 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
**************************
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 527,037.54 7,731,062.46
13,200,000.00 4.432,532.98 8,767,467.02
450.000.00 111,104.44 338,895.56
1,035,000.00 302,338.22 732,661.78
1,254,830.00 218,558.42 936,271.58
2,957,140.00 765,715.24 2,191,424.66
102,000.00 46,840.56 55,159.44
1,688,988.00 475,529.48 1,213,458.52
98,590.00 30,649.60 67,940.40
1,948,150.00 811,337.27 1,136,812.63
3,889,911.00 1,697,839.50 2,192,071.50
1,068,372.00 286,499.48 781,872.52
35,951,081.00 9,805,982.93 26,145,098.07
266 439.00
684 838.00
298 657.00
469 339.00
958 814.00
681 962.00
389315.00
22,532.00
145,872.00
3,917,768.00
6,801.424.00
63,495.00
180,757.00
48,211.00
4,672,577.00
11,766,464.00
574,025.00
6,406.00
139,200.00
55,629.00
351,887.00
1,127,147.00
80.860.35
186,086.98
109,653.00
233,952.16
358,947.02
195,382.03
133,251.70
7.50
10,000.00
1,308,141.74
388,032.36
10.478.65
17,735.86
1,239,179.37
1.655,426.24
209,075.60
510.15
42,888.38
10,111.06
88,996.51
351,581.70
185,578.65
498 751.02
189 004.00
235 385.84
599 866.98
486 579.97
256 063.30
22 524.50
135 872.00
2,609 626.26
6,'413,391.64
53,016.35
180,757.00
30,475.14
3,433,397.63
10,111,037.76
364,949.40
5,895.85
96,311.62
45,517.94
262,890.49
775,565.30
7,174,289.56 413,588.96 6,760,700.60
12,985,986.39 3,902,426.52 9,083,559.87
575,281.78 153,382.30 421,899.48
1,010,799.01 348,506.75 662,292.26
1,313,086.74 191,839.00 1,121,247.74
3,028,655.28 1,794,904.94 1,233,750.34
106,233.99 37,073.76 69.160.23
2,512,223.69 874,219.94 1,638,003.75
114,614.48 31,393.16 83,221.32
2,006,116.43 752.267.61 1,253,848.82
3,719,568.13 1,171,627.53 2,547,940.60
2,715,619.50 103,774.28 2,611,845.22
37,262,474.98 9,775,004.75 27,487,470.23
157 649.46
451 460.84
254 490.40
566 876.47
755 484.16
561 347.95
273 267.70
12 013.21
53 136.03
3,085.726.22
5,842,597.93
49,327.13
136,903.24
41,743.47
4,331,237.29
10,401,809.06
504,545.32
79.88
105,015.72
52,929.17
297,191.50
959,761.59
47,665.56
168,269.15
88,427.25
118,426.84
258,626.74
157,554.29
102,838.30
1,915.29
943,723.42
327,517.28
9,071.44
16,197.84
1,132,054.81
1,484,841.37
175,188.13
30,300.11
11,685.36
72,280.60
289,454.20
109,983.90
283,191.69
166,063.15.
448,449.63
496,857.42
403,793.66
170,429.40
10,097.92
53,136.03
2,142,002.80
5,515,080.65
40,255.69
136,903.24
25,545.63
3,199,182.48
8,916,967.69
329,357.19
79.88
74,715.61
41,243.81
224,910.90
670,307.39
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 11/30/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 46.38 8,348.62 1,483.29 1,053.88 429.41
15,000.00 2,599.00 12,401.00 12,000.00 2,493.00 9,507-.00
41,100.00 3,900.00 37,200.00
64,495.00 6,545.38 57,949.62 13,483.29 3,546.88 9,936.41
400 725.00
148 128.00
84 170.00
39 687.00
1,141 323.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
320,247.00
156,680.00
130,122.00
368,051.00
180,807.00
4,332,509.00
100,181.25 300,543.75 362,922.00 90,730.50
80,619.87 67,508.13 48,979.05 29,537.79
20,217.04 63,952:96 64,337.03 21,293.86
7,532.50 32,154.50 35,168.63 9,170.98
277,920.80 863,402.20 863,488.51 241.549.14
56,957.00 24,525.00 65,376~81 56,905.43
124,322.27 274,487.73 299,517.33 106,002.71
81,766.71 155,123.29 179,746.06 71,922.21
83,690.19 182,165.81 223,534.64 77,313.23
21.632.85 37,342.15 54,261.57 21,369.97
39,294.51 69,544.49 95,263.42 36,851.75
30,224.21 50,479.79 74,298.29 27,146.56
25,671.11 67,351.89 76,437.85 29,790.43
5,762.50 32,227.50 37,226.81 4,894.99
148,766.82 171,480.18 200,963.28 91,561.21
52,080.48 104,599.52 137,807.83 54,915.70
60,076.10 70.045.90 116,758.13 45,948.98
147,937.41 220,113.59 300,625.35 138,843.56
43,259.00 137,548.00 95,707.64 36,352.24
1,407,912.62 2,924.596.38 3,332.420.23 1,192,101.34
1,764,970.00 545,65!.10 1,219,218.90 1,330,195.42 475,984.94
1,622,000.00 450,697.97 1,171,302.03 1,334,934.18 379.860.49
1,999,416.00 522,268.33 1,477,147.67 1,606,493.94 548,297.03
273,799.00 137,463.91 136,335.09 254,453.24 147,134.73
5,660,185.00 1,656,081.31 4,004,103.69 4,526,076.78 1,551,277.19
5,954,929.00 1,393,128.57 4,561,800.43 1,435,693.51
1,198,376.00 41,432.78 1,156,942.22 180.763.51
665,863.00 68,486.81 597,376.i9 462,208.60
1,008,540.00 201,601.58 806,938.42 603,894..29
8,827,708.00 1,704,650.74 7,123,057.26 2,682,559.91
35,696,276.00
254,805.00
254,805.00
8,090,339.73
1,715,643.20
1,715,643.20
27,605,936.27 25,001,837.08
(1,460,838.20) 12,260,637.90
17,201.67
(2,400,000,00)
(1,460,838.20) 9,877,839.57
72,769.50
8,928.97
61,228.13
23,037.62
165,964.22
5,630,908.62
4,144,096.13
4,144,096.13
272,191.50
19,441.26
43,043.17
25,997.65
621,939.27
8,471.38
193,514.62
107823.85
146 221.41
32 891.60
58 411.67
47 151.73
46 647.42
32 331.82
109 401.97
82 892.13
70 809.15
161 781.79
59 355.40
2,140 318.89
854,210.48
955,073.69
1,058',196.91
107,318.51
2,974,799.59
1,362,924.01
171,834.54
400,980.47
580,856.67
2,516,595.69
19,370,928.46
8,116,541.77
17,201.67
(2,400,000.00)
5,733,743.44
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUSEXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 11/30/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
*******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
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
90,175.00
65,903.71 164,596.29
32,069.83 t13,085.17
110,312.00
431,032.92 2,872,736.08
54,082.00 179,918.00
20,195.00 1,102,143.00
876,760.00
7,570.13 (2,570.13)
610,853.59 5,507,155.41
302,730.00 70,696.20 232,033.80
175,041.00 18,294.76 156,746.24
177,100.00 55,413.89 121,686.11
654,871.00 144,404.85 510,466.15
175,084.00 20,430.16 154,653.84
175,084.00 20,430.16 154,653.84
1,049,577.00 4,124.70 1,045,452.30
7,500.00 1,875.00 5,625.00
10,000.00 2,496.40 7,503.60
1,067,077.00 8,496.10 1,058,580.90
6,000.00 1,001.00 4.999.00
6,000.00 1,001.00 4,999.00
80,373.00 18,688.96 61,684.04
411,119.00 411.119.00
4,744,341.00 724,966.00 4,019,275.00
5,235,833.00 743,654.96 4,492,178.04
7,138,865.00 917,987.07 6,220,877.93
1.020,856.00 307,133.48 713,722.52
1,020,856.00 307,132.48 713,722.52
81,587.21
218,443.36 84,088.50
136,129.03 22,789.55
186,396.07
1,401,011.82 713,791.55
235,575.00 27,889.00
486,386.87 15,230.00
766,872.19
17,930.25
3,530,331.80 863,788.60
163,769.23 28,571.18
87,789.56 20,864.20
188,299.58 975.00
439,858.37 50,410.28
348,601.71 68,597.63
348,601.71 68,597.63
1,108,496.91 203,503.55
7,500.00
9,918.66
1,125,915.57 203,503.55
4,999.00
4,999.00
81 587.21
134 354.86
113 339.48
186 396.07
687 220.27
207 686.00
471 156.87
766 872.19
17 930.25
2,666 543.20
125,198.05
66,925.36
187,324.58
389,447.99
280,004.08
280,004.08
904,993.36
7,500.00
9,918.66
922,412.02
4,999.00
4,999.00
86,648.98 8,908.11 77,740.87
760,517.95 226,828.84 533,689.11
847,166.93 225,736.95 611,429.98
2,766,541.58 558,248.51 .2,208,293.07
(763,790.22) (305,540.09) (458,250.13)
15.061.59 15,061.59
(748,728.63) (305,540.09) (443,188.54)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 11/30/2001
SPECIAL ASSESSMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
PRIOR
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
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
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
82,654.00
50,500.90
50,500.90
1,445.63
2,713.14
54,850.75
59,009.52
10,220.76'
10,220.76
119,731.18
119,731.18
119,731.18
180,134.10
180,134.10
3,361.37
12,351.86
225.816.25
241,529.48
(3,105.76)
(3,105.76)
418,557.82
(37,077.18)
37,077.18)
119,085
119,085
2,753
4,175
130,649
137,577
11,050
11,050
.13 30,910.27
.t3 30,910.27
.02 1,086.65
.26 1,827.76
.00 49,524.71
.28 52,439.12
.38 4,300.08
,38 4,3OO.O8
88,174.86
88,174.86
1,666.37
2,347.50
81,124.29
85,138.16
6,750.30
6,750.30
2,519.14 94.30 2,424.84
2,519.14 94.30 2,424.84
.93 87,743.77
.00) 85,443.40
270,231
(143,174
(143,174
182,488.16
(228,617.40)
.00) 85,443.40 (228,617.40)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 11/30/2001
CAPITAL IMPROVEMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
PRIOR
FISCAL YEAR
PRIOR
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
37,719,269.00
39,359,951.00
8.882,376.17
8,882,376.17
8,882,376.17
8.882,376.17
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 1,854,726.00
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 12,867,967.00
COMMUNITY IMPROVEBENTS
PARKS 1,396,354.00
STREET CONSTRUCTION/IMPROVEMENT 15,589.403.00
ACTIVITY TOTAL 29,853,724.00
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
31,708,450.00
(7,651,501.00)
EXCESS <REVENUE>EXPENDITURE
(7,65!,501.00)
1,684.60
8,049.60
8,049.60
202,193.84
1.373,376.56
1.575,570.40
1,585,304.60
1,585,304.60
1,585,304.60
1,853,041.40
(8,049.60)
(8,049.60)
12,665,773.16
1,396,354.00
14,216,026.44
28,278,153.60
30,123.145.40
(9,236,805.60)
(9,236,805.60)
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.142.11)
15,934.00
15,934.00
225,850.54
1.323.21
4,900.727.04
5,127,900.79
5,143,834.79
5,143,834.79
5,143.834.79
14,920.96
14,920.96
711,011.91
17,531.64
2,989,793.68
3,718.337.23
3,733,258.19
(5,149,117.98)
1,140.08
(5,147,977.90)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 11/30/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
490.25 (490.25)
490.25 (490.25)
237,172.56
16,539.29
253,711.85
237,172.56
16,539.29
253,711.85
*******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 167,544.06 65,033.94 234,093.57 164,624.28 69,469.29
232,578.00 167,544.06 65,033.94 234,093.57 164,624.28 69,469.29
232,578.00 167,544.06 65,033.94 234,093.57 164,624.28 69.469.29
232,578.00 167,053.81 '65,524.19 (19,'618.28) 164,624.28 (184,242.56)
232,578.00 167,053.81 65,524.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 11/30/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 422,055.95 749,392.05 944,535.35
17,000.00 12,802.54 4,197.46 6,495.00
1,487,283.00
434,858.49 1,052,424.51 1,156,304.11
392,166.67
205,273.76
552,368.68
6,495.00
392,166.67 764,137.44
**************************
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
232,239.66 757,806.34 1,018,788.52 129,047.55 889,740.97
232,239.66 757,806.34 1,018,788.52 129,047.55 889,740.97
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 232,239.66 993,384.34
(261,659.00) (202,618.83) (59,040.17)
1,059,488.80 129,047.55 930,441.25
(96,815.31) (263,119.12) 166,303.81
2,400,000.00 2,400,000.00
EXCESS <REVENUE>EXPENDITURE (261,659.00) (202,618.83) (59,040.17) (2,496,815.31) (263,119.12) (2,233,696.19)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 11/30/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 PROJECTS:
T 0 T A L EXPENDITURES
'EXCESS <REVENUE>EXPENDITURE
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00