HomeMy WebLinkAbout4.08 FinRpts Aug&Sept2002 CITY CLERK
FILE # 330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: October 15, 2002
SUBJECT:
Preliminary Financial Reports For the Months of August and
September 2002
Report Prepared by: Carole A. Perry, Administrative Services
Director and Fred Marsh, Finance Manager
ATTACHMENTS: 1. YTD Revenues and Budget Comparison
2. YTD Expenses and Budget Comparison
3. Financial Statements for the Months of August and
September 2002
RECOMMENDATION: ~ Receive the reports.
FINANCIAL STATEMENT:
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report on the preliminary financial statements for the months
of August and September. The final audited results for Fiscal Year 2001/2002 are not yet available;
therefore, this report is presented as "preliminary" at this time. 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 Re~}ortin~ of Information
The auditors have begun the final phase of the fieldwork necessary for the 2001/2002 audit. The final
audit results will impact the reported Fund Balance presented in the attached monthly reports. The scope
of any remaining final entries will not be significant when compared to all general fund revenues and
expenses.
Analysis of Preliminary, August and September 2002 Revenue and Expenditure Report
Given that this report encompasses only the first three months of the 2002/2003 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.
Preliminary lml~acts resulting from Pas.sage of State Budget for Fiscal Year 2002/2003
Although there are bills that remain to be completed before the State Budget for Fiscal Year 2002/2003 is
officially adopted, the City had received some preliminary information regarding potential reductions in
funding the areas of Gas Taxes, Vehicle License Fee (VLF), and Citizens Option for Public Safety
COPIES TO:
/~
C:\Documents and Settings\jonip~Vly Documents~_ssistant City ManagerLS. dministrative Services\092002 agenda statement monthly financials.doc
i m o. N' gl,
(COPS) grants that would have an impact on the City's adopted budget for Fiscal Year 2002/2003. As it
currently being represented by the State, the City will continue to receive the full amount of Gas Taxes,
VLF, and is expected to receive the COPS grant for Fiscal Year 2002/2003. Therefore no budget
adjustments are being proposed at this time.
Staff anticipates receiving final information regarding the State's adopted budget from the League of
California Cities by November, and will report back to Council on any additional information received
that might adversely affect the City's adopted budget for Fiscal Year 2002/2003. Here are some
additional highlights on the budget:
The budget fully funds the booking fee reimbursements
As previously mentioned, the backfill payments from the state to local government remain intact
regarding Vehicle License Fees (VLF)
ca Senate bill (SB 68) has been signed, defining Local Agency Investment Fund (LAIF) deposits as
the property of local agencies (held in trust by the State), thereby eliminating the opportunity for
the State to "borrow" the funds in the future
General Fund Revenues
Total General Fund Revenues collected through September are comparable to what occurred in the third
month of the previous Fiscal Year. Through September 2002, the City has collected approximately 17%
of the total budgeted General Fund Revenues compared to 15% in the prior Fiscal Year.
Licenses and Permits are higher than in the same period of the prior year due to an increase in the number
of permits pulled for new residential projects. Interest and Rentals is higher than in the same period of the
prior year due to three key reasons. The first is related to the timing difference of recording of interest
accrued from the City's investments from a bi-annual basis as was done in the September 2001 financials
to a monthly basis in Fiscal 2002-2003 in order to more adequately reflect interest activity. Secondly,
there was an increase in market value on the City's investments, and the third and last factor is a higher
cash balance.
Charges for Services are lower than in the same period of the prior year due to a receipt of one-time
monies from AT&T for cable equipment. Fines and forfeitures are lower than in the prior year due to a
decrease in the number of traffic citations issued over the prior year.
General Fund Expenditures
Overall, through the month of September expenditures in the General Fund totaled $5,119,820 and
represented approximately 13% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $1,971,583 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 only at General Fund Operating Expenditures, the activity through September 2002 was
comparable to the amounts expended for the same period in the prior Fiscal Year. As of September 30,
2002, the City had expended 11% of the General Fund Operating Budget, which was the same percentage
as in the prior Fiscal Year. Health and Welfare is higher than in the same period of the prior year due to
payment for contract senior support services in the current year. 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 2002-2003 YTD Revenues and Budget Comparison
For the Period Ending September 30, 2002
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
I17, 15°A
7%
6%
1128~ ~/o 1 Fy: 2002/2003'']
ll~OOo [] FY 2001/2002/
/j3%
16°/,
I
69%
~3%
3
0°/o
~7°/o
10%
12%
0% 30% 60% 90% 120% 150%
25% 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 2002~03 FY 2002~03 % of FY 2001102 % of Total for
Budget YTD Actual Budget YTD Actual FY 2001/02
9,892,843 666,400 7% 527,038 6%
12,702,000 2,289,757 18% 2,357,933 20%
415,000 20,141 5% 23,936 6%
858,000 108,728 13% 131,393 16%
1,493,900 121,151 8% 114,365 8%
1,622,404 627,433 39% 474,078 20%
1,373,538 950,332 69% 100,526 3%
2,073,765 612,328 30% 543,658 27%
4,815,035 757,566 16% 1,021,403 23%
114,000 20,235 18% 28,265 24%
742,768 74,294 10% 58,722 12%
36,103,253 6,248,365 17% 5,381,317 15%
ATTACHMENT 1
City of Dublin 2002-2003 YTD Expenses and Budget Comparison
For the Period Ending September 30, 2002
Total General Fund
Expenses
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
2%
4%
%
%
0%
19%
19%
~%
8%
19%
7%
19%
20%
40% 60%
25% of Year Complete
80%
100%
[] FY 2002~03
[] FY 2001/02
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 2002~03
Budget
4,393,521
7,876,674
5,108,279
313,858
1,337,221
69,001
4,740,119
5,763,241
11,3O7,436
40,909,350
29,601,914
FY 2002~03 % of
YTD Actual Budget.
854,123 19%
181,538 2%
84,668 2%
11,209 4%
163,433 12%
11,140 16%
872,194 18%
969,932 17%
1,971,583 17%
5,119,820 13%
3,148,237 11%
FY 2001102 % of Total for
YTD Actual FY 2001102
743 568
263 723
64 373
10 684
160 087
1 763
745 259
890 314
1,040,047
19%
4%
1%
5%
15%
0%
19%
19%
14%
3,919,818
2,879,771
12%
11%
ATTACHMENT 2
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF SEPTEMBER 2002
Prepared by
The Finance Department
October 2, 2002
ATTACHMENT 3
GENEItAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Sep2002
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.408.648)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
90.840.322
138.985
542.481
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
(121,261)
8,838
43.000.717
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
(930.404)
(15.303)
(970.729)
(174.677)
(418.759)
(55.123)
(127.768)
(2.692,762)
(40.307,955)
TOTAL FUND E (40.307.955)
1,259,965
888.267
2.148.232
(189.851)
121.261
(68,590)
(2,079,643)
(2.079.643)
371,994 41,083,953
371.994 41.083.953
(1.344.171)
(90.688)
(1,434,859)
(371,994) (39,649.095)
(371.994) (39.649.095)
17,489
170.522
(5,675,247) (21,672,752)
170.522 167.304
109.300
90.840.322 75.237.557
1.027.252 454.060
542,481 312,860
1.553.500
1.741.511
(121.261)
8.838
1.553.500
88.346.408
7,626
1.652.500
56.268.454
(930,404)
(1.359,474)
(970,729)
(455,216)
(418,759)
66.138
(127.768)
(1.671.000) (1.671.000)
(1,671,000) (5.867.211)
(70.511) (82.479.197)
(70,511) (82,479,197)
(926.064)
(12,698.675)
(399,519)
(796,314)
(335,011)
(12.007)
(146.433)
(1,770.000)
(17.084.024)
(39.184.430)
(39,184,430)
TOTAL LIAB. FND BAL. RETD (43.000.717) (2.148.232) (371,994) (41.083,953) (1,741,511) (88.346.408) (56.268.454)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Sep2002
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
6.390.370
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,454,099
28,844,469
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 (28.844.469)
TOTAL FUND E (28,844.469)
27,146,580
41.183,864
27.146,580 41,183,864
(27,146,580)
(27,146,580)
(41.183.864)
(41.183,864)
6,390.370 5.529.268
49,600,680 38,136,473
41,183,864 41,605,253
97,174,913 85,270,993
(1)
(41.183.864) (41.605.253)
(41,183,864) (41,605,254)
(55,991,050) (43,665,740)
(55.991.050) (43,665,740)
TOTAL LIAB. FND BAL. RETD (28.844,469) (27.146.580) (41.183,864) (97.174.913) (85.270,993)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002THROUGH 09/30/2002
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
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
WASTE MANAGEMENT
9,892 843,00
12.702 000,00
415 000,00
858 000,00
1.493 900.00
1,622 404.00
114000,00
1.244.226,00
129.312.00
2,073.765.00
4,815.035.00
742.768,00
36.103.253,00
212,932.00
739,518,00
319,600.00
659,076,00
1,038,223,00
731,567,00
386,665.00
20.940.00
285.000.00
4.393.521.00
7.876.674.00
71.462.00
181.437,00
60,959,00
5,108,279.00
13,298,811,00
616.631.00
10.427.00
132,100.00
70,337.00
507.726.00
1,337,221,00
8.242.00
666.400.12 9.226.442,88 8.732,324,89 527.037,54 8.205.287,35
2.289,757,30 10.412.242.70 12.813,111.10 2.357.932.98 10.455,178,12
20.140,70 394.859,30 434,832,20 23.935.88 410.896,32
108.728,18 749.271,82 810.219,79 131.393,33 678.826.46
121.151,00 1.372.749,00 1.385.815,52 114.365,00 1.271.450,52
627,432,97 994,971,03 2.327,250,77 474.077,96 1.853.172.81
20,234,74 93.765,26 118.190,93 28.265,45 89.925,48
926.791,45 317.434,55 1.843.673.66 80.633.34 1.763.040.32
23.540,68 105,771,32 85,936.82 19.892,61 66,044,21
612.328,01 1,461,436,99 1,992,383,50 543,657,71 1,448,725,79
757.565.83 4,057,469,17 4,464,259,66 1,021,403.30 3,442,856.36
74.294,03 668,473,97 493,722,65 58.722,12 435,000,53
6.248.365,01 29,854.887.99 35.501,721,49 5,381,317,22 30.120,404.27
45,148.81
165,428.02
62,091.74
99.833.32
224,853.81
114,666.12
142,075,61
25,30
854,122,73
181.538.02
11,209.09
84.667.77
277.414.88
112.960.68
10.313.52
7.525.13
32.634.02
163,433.35
3,539.00
167783,19
574 089,98
257 508,26
559 242,68
813 369,19
616 900.88
244 589,39
20,914,70
285.000.00
3.539.398.27
7.695.135.98
71,462.00
181,437,00
49,749,91
5,023,611,23
13,021,396,12
503.670.32
10,427.00
121,786.48
62.811.87
475.091.98
1,173,787.65
4.703.00
217.946.55
560,359,16
297,049,71
764,484,52
922,865,72
657,327.17
385,395,68
14,507,57
109.981,56
3.929.917,64
6.668.234.72
56,677.08
138,935.98
46,012.48
4,698,607.54
11,608,467.80
557.207.53
6.406.00
132,383.34
51.079.02
347.022.86
1,094,098.75
1,807.38
33.047.27
110.290,22
64,469,95
107,557.38
211.779,22
83.965.19
132,458,90
743,568,13
263,722.74
10,684.49
64.373.10
338,780.33
116,285,04
9,631,16
4.200.74
29.969,97
160,086.91
25,00
184 899.28
450 068.94
232 579,76
656 927.14
711 O86,5O
573 361,98
252 936.78
14,507.57
109.981.56
3,186.349,51
6.404.511.98
56,677.08
138,935.98
35,327,99
4.634,234.44
11,269,687.47
440.922.49
6.406.00
122,752.18
46.878.28
317.052.89
934,011,84
1,782.38
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 09/30/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T,D,
VARIANCE
CHILD CARE
SOCIAL SERVICES
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
15,000,00 1,200,00 13,800,00 15,000.00
6.000,00 6.000,00
39,759,00 400,53 39.358.47 35,209.87
69,001,00 11,139~53 57,861.47 52,017,25
496.219,00 496.219,00 376,276,00
137.153,00 55,427,39 81,725,61 119,409,29
90.771,00 18,187,27 72,583,73 69,081,56
37,418,00 3,788.04 33,629.96 30,077,98
1,263,230.00 100,714,87 1,162,515,13 1,086,713.48
70.906,00 63.784,95 7.121.05 80.087,02
453,444,00 99,512,58 353,931,42 374,416.72
261,690,00 58,994,20 202,695~80 207,515.47
270,182,00 50,114,76 220,067,24 250,834.31
79,421,00 17,238,44 62,182,56 57,470~25
113,854,00 22,585,51 91.268,49 106,183.40
95,061,00 20,395.17 74,665.83 76,886,84
96,743,00 21,243.58 75,499.42 82,402,67
35,167~00 2,487,57 32,679,43 23.572,33
349.589,00 97.826,23 251.762,77 314.735,18
190.215,00 36.528,19 153.686,81 146.824,25
143.005,00 39.208,70 103.796,30 145.812,50
332.691,00 118.704,19 213.986,81 322.391,18
223.360.00 45.452,03 177.907,97 142.041.19
4.740.119.00 872.193,67 3.867.925,33 4.012.731,62
2.011.188,00 319.937,71 1.691,250,29 1.486,541,67
1.563.701.00 232.298,69 1.331.402,31 1.276,343,20
1.902.477,00 304,373,32 1,598.103,68 1,609,544.48
285,875.00 113,321,79 172,553,21 271.222,90
5,763,241.00 969,931.51 4,793.309.49 4.643.652.25
6,949.450.30 1.864,293,46 5,085.156.84 4,582,889.35
1.774.943.00 64.582.98 1,710.360.02 273,283,82
1.591.426.00 25.652.02 1,565.773.98 351.854.08
991.617.00 17.054.89 974.562.11 580.008.92
11,307.436.30 1.971.583.35 9.335.852.95 5.788.036.17
40.909.350.30 5.119.819.02
(4.806.097.30) 1.128.545,99
(4.806.097.30) 1.128,545,99
35.789.531,28 31.128.921,48
(5.934.643,29) 4.372.800,01
16,784.89
(5.934.643.29) 4.389,584,90
938,00
800.00
1,763.00
62,101,40
9,487,03
1.634.21
97.944.85
54.757.00
73.862.10
52.552.11
46.318.63
12.598.42
23,375.14
20.335.07
13.703.64
i 851.07
67 094,23
30 774~01
32 480.63
118 175,82
26 213.61
745 258,97
304,053,87
245,843.33
248,577.61
91.839.51
890,314.32
883.880.92
31,662.51
1,011.51
123,492.30
1,040,047,24
3,919,818.90
1,461,498.32
1,461,498,32
14,062,00
34.409.87
50,254,25
376,276,00
57,307,89
59,594.53
28,443.77
988,768.63
25.330,02
300,554.62
154.963.36
204,515.68
44,871.83
82,808~26
56,551.77
68.699.03
21.721.26
247,640,95
116,050,24
113,331,87
204,215,36
115.827.58
3,267.472.65
1,182,487.80
1,030,499.87
1.360,966,87
179.383.39
3.753.337.93
3,699,008.43
241,621_31
350,842~57
456,516,62
4,747,988,93
27.209.102.58
2,911,301,69
16.784.89
2,928,086,58
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 09/30/2002
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
93,610.00 93,610,00 91.099.68 91.099,68
317,700.00 53,731.09 263,968,91 206.812.62 36.026,22 170.786.40
153,000.00 11,833~79 141,166.21 149.023.41 107,46 148.915.95
50.995.00 50.995,00 135.432,87 135.432.87
4,516,742.00 125.184.27 4,391.557.73 1.601.090.43 112.232.57 1.488.857.86
240,909,00 27.905,00 213,004,00 241,589,50 241,589,50
242,461,00 56,487.82 185,973.18 778,796~26 20.195.00 758,601.26
885.779,00 885.779,00 865.790,08 865,790,08
5.000,00 5.000,00 30,997,14 30,997,14
6.506.196,00 275.141,97 6.231.054,03 4,100.631,99 168,561,25 3,932,070,74
**************************
PUBLIC SAFETY:
POLICE 205.727.00 15.235.39
TRAFFIC SIGNALS & STREET LTG 145,900.00 5,996.97
FIRE SERVICES 213,873.00 254.88
ACTIVITY TOTAL 565,500~00 21,487.24
TP~ANSPORTATION:
STREET MAINTENANCE 219,619.00 16,163.58
STREET SWEEPING
ACTIVITY TOTAL 219.619.00 16.163.58
HEALTH & WELFARE:
WASTE MANAGEMENT 1.079.569,00 260,68
SOCIAL SERVICES 28,427.00 446,44
HOUSING PROGRAMS
ACTIVITY TOTAL 1.107,996.00 707,12
COMMUNITY DEVELOPMENT:
ENGINEERING 6.000,00
ACTIVITY TOTAL 6.000,00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS
COMMUNITY PROJECTS 36.782,00
PARKS 426,095,00
STREET CONSTRUCTION/IMPROVEMENT 3,932,073.00 669,258~65
ACTIVITY TOTAL 4,394.950,00 669.258,65
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE> EXPENDITURE
190.491.61
139,903,03
213,618.12
544,012.76
203,455.42
203.455,42
1.079,308,32
27,980.56
1,107,288,88
6.000,00
6.000,00
36.782,00
426,095.00
3,262,814.35
3,725.691,35
6,294,065.00 707.616.59 5.586.448.41
(212.131~00) 432,474,62 (644,605.62)
(212.131.00) 432.474.62 (644,605,62)
377.390.53
145.399.20
193.800.29
716.590.02
209,801.34
209.801,34
1,030,807,37
7,500.00
9,999.54
1,048,306,91
6.000.00
6.000.00
73,425.55
2,259,994.81
2,333,420~36
4.314.118,63
213,486.64
16,784.89
230,271.53
33,675.22
3,953.09
273.06
37,901.37
5.O00.48
5,OOO,48
1,807.56
1.807.56
1,001,00
1,001+00
141.223.85
141,223.85
186.934.26
18.373.01
18,373.01
343.715,31
141.446,11
193.527.23
678.688.65
204.800.86
204.800,86
1,028,999.81
7.500.00
9,999.54
1,046,499,35
4,999.00
4,999.00
73,425.55
2.118.770.96
2.192,196.51
4.127.184.37
195.113.63
16,784.89
211.898.52
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 09/30/2002
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
536,364.00 (264.03) 536.628.03 431.564,21
13,888~00 13,888.00 20.738.74
4,000.00 5,070,54 (1,070.54) 1.995.50
554.252.00 4,806.51 549,445~49 454,298.45
431.564.21
20.738.74
1,995.50
454,298.45
**************************
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 274.300.00 41.247.08 233.052,92 198,138.51 24,848,08 173,290.43
ACTIVITY TOTAL 274.300.00 41.247.08 233,052.92 198,138.51 24.848.08 173,290.43
TRANSPORTATION
PUBLIC WORKS 4.754,00 307,91 4.446.09 3,277,32 1,251.62 2,025,70
STREET TREE MAINTENANCE 14,734,00 2,122,71 12,611,29 7,713.24 1.032.60 6.680,64
STREET LANDSCAPE MAINTENANCE 292.861,00 28.989.71 263.871.29 231,458.34 22.048.20 209,410.14
ACTIVITY TOTAL 312,349.00 31,420.33 280,928.67 242.448,90 24.332,42 218,116,48
COMMUNITY DEVELOPMENT
ENGINEERING 16.250.00 4.335,84 11.914.16 20.071.01 4,645.15 15,425.86
ACTIVITY TOTAL 16,250,00 4,335.84 11,914.16 20.071,01 4,645.15 15.425,86
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT 102,000.00 102.000,00
ACTIVITY TOTAL 102,000,00 102,000.00
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
704.899.00 77.003.25 627.895.75 460,658,42 53,825.65 406.832.77
150.647.00 72.196,74 78.450,26 6.359.97 53,825,65 (47,465.68)
EXCESS <REVENUE>EXPENDITURE 150.647.00 72.196.74 78.450.26 6,359.97 53.825.65 (47,465.68)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 09/30/2002
CURRENT
BUDGET
CAPITAL IMPROVEMENT FUND
CURRENT PRIOR
ACTUAL VARIANCE FISCAL YEAR
PRIOR
Y,T,D.
VARIANCE
***********************
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
1.104.085.00
11.180.405.00
12.284.490.00
1.104.085.00 1.743.568.68
11.180.405.00 19.685.683.29
12.284.490.00 21.429.251.97
1.743.568.68
19.685.683.29
21.429.251.97
**************************
GENERAL GOVERNMENT ACTIVITIES:
CITY ATTORNEY
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
12.950.00
12.950.00
214.797.00
10.696.199.43
3.361.981.00
19.756.297.00
33.814.477.43
34.042.224.43
21,757,734.43
12.950.00
12.950.00
25,088.97 189,708.03 96.133.06 1.010.76 95.122.30
696.45 (696.45) 8.585.61 3.129.63 5.455.98
696.45 (696.45) 8.585.61 3,129.63 5.455.98
436,131,11 10.260.068,32 4,324,162.75 33.393.44 4.290,769,31
12.322.05 3,349.658.95 125,589.57 125,589,57
195.434.67 19.560.862.33 4.085,145,94 250,557.20 3,834.588,74
643.887.83 33,170,589.60 8.534,898,26 283,950.64 8,250,947~62
669.673.25
669.673.25
33.372.551.18 8.639,616.93
21.088.061.18 (12.789,635.04)
288,091.03 8,351.525.90
288,091.03 (13.077,726,07)
EXCESS <REVENUE>EXPENDITURE 21,757,734~43 669.673~25 21.088.061.18 (12.789,635.04) 288.091.03 (13.077.726.07)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 09/30/2002
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,264,42
8,099,29
245,363.71
490.25
490.25
237.264.42
7,609.04
244,873.46
**************************
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
229,828~00 170,019.80 59,808.20 233,733.39 166.466.18 67.267.21
229.828.00 170.019.80 59,808.20 233,733.39 166,466+18 67,267.21
229.828.00 170.019.80 59.808.20 233.733,39 166,466,18 67,267,21
229,828.00 170.019,80 59,808.20 (11.630.32) 165.975.93 (177,606,25)
EXCESS <REVENUE>EXPENDITURE 229,828.00 170,019.80 59,808.20 (11.630.32) 165.975.93 (177.606.25)
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF AUGUST 2002
Prepared by
The Finance Department
September 13, 2002
ATTACHMENT 3
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 09/30/2002
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
227,059.00
1,367,268,00
20.000.00
1.614.327.00
308,831.50
308.831.50
227,O59.OO
1,058.436,50
20.000.00
1.305.495.50
262,597.72
1,103,647.14
22,267.13
1.388.511,99
278,259.03
2.265.00
28O.524.O3
262,597,72
825.388,11
20.002,13
1.107.987.96
**************************
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
FIRE
ACTIVITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
1.741.280.00
1.741.280,00
51.818,00
51.818.00
231.688.34
231.688.34
1.509.591,66
1.509,591,66
51,818,00
51.818,00
1.092,881.67
1.092,881.67
41.899,88
41.899,88
119.840,55
119.840,55
973.041.12
973,041,12
41.899.88
41.899.88
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
1,793,098.00
178.771.00
231.688.34
(77.143,16)
1.561,409.66
255,914.16
1.134.781.55
(253.730.44)
119.840.55
(160.683.48)
1.014,941.00
(93,046.96)
EXCESS <REVENUE>EXPENDITURE 178.771,00 (77,143,16) 255.914,16 (253,730,44) (160.683.48) (93.046.96)
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Aug2002
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
(47,029.047)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
89,800,785
138.985
542.481
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
10.883
43,464,087
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
(889.871)
(13.790)
(926,456)
(211,874)
(415,669)
(139,430)
(127,768)
(2,724,857)
(40,739,230)
TOTAL FUND E (40,739,230)
1.474.756
1,474.756
(142.081)
401.696 39.656,454
401.696 39.656.454
(47.404.206)
(95,522)
(142.081) (47.499.729)
(1,332.675) (401.696) 7.843.274
(1.332.675) (401.696) 7.843,274
14,758 (5,481,384) (24,095.150)
170.522 170.522 170.522
89.800,785 94,923,499
138.985 1.025,806
542,481 823.625
1,553,500
1.738,779
10.BB3 15.221
1,553.500 1.553.500
86,735,772 74.417,022
(889.871) (654.899)
(47.417.997) (24.837.479)
(926,456) (893,646)
(449,478) (7,658,200)
(415,669) (652,884)
(139,430) (51,144)
(127,768) (146,433)
(1.671,000) (1.671,000) (1,671,000)
(1.671.000) (52.037,667) (36,565,685)
(67,779) (34.698,105) (37,851,337)
(67,779) (34,698,105) (37,851,337)
TOTAL LIAB. FND BAL. RETD (43,464,087) (1.474.756) (401.696) (39.656,454) (1,738,779) (86,735,772) (74,417,022)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Aug2002
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
6,186.304
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
28.335.569
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 (28,335.569)
TOTAL FUND E (28.335.569)
15,987.209
41.191.031
15.987.209 41.191,031
(15,987,209)
(15,987,209)
(41,191.031)
(41,191.031)
6.186,304 6.230.598
1.191
38.136.473 38.136.473
41,191.031 41.191.031
85,513,809 85,559,293
(40,026)
(41.191.031) (41.191.031
(41.191.031) (41.231.057
(44.322.777) (44.328.236
(44.322.777) (44.328.236
TOTAL LIAB. FND BAL. RETD (28.335.569) (15,987,209) (41,191.031) (85,513.809) (85.559.293
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 08/31/2002
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
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
WASTE MANAGEMENT
9,892,843.00 62.386,00 9.830.457,00 8.534,344,98 8,534,344,98
12.702,000~00 1,923,300.00 10.778.700.00 12.042.175,86 2.007.800,00 10.034.375.86
415,000,00 20,140.70 394,859.30 434.832.20 23.935.88 410.896.32
858,000,00 51,457.34 806,542.66 810.219.79 72,121.55 738.098.24
1.493.900,00 62,712,00 1,431,188~00 1,385,815.52 52.568.00 1.333.247.52
1.622.404,00 402.919,65 1.219.484,35 2,327,250~77 368,577.32 1,958,673.45
114.000,00 11,543,46 102,456,54 118,190.93 16.283.10 101.907.83
1.244.226,00 609.282,78 634,943~22 3,045,456.98 71,544.74 2,973,912.24
129.312,00 14,326,15 114,985.85 85.936.82 11.795.01 74.141.81
2,073,765.00 432.228.33 1,641.536.67 1.992.383,50 359.661.96 1.632,721,54
4,752,535~00 456.746.97 4.295.788,03 4.464,259,66 816.193,49 3,648,066,17
742.768.00 4,435.89 738,332.11 493.722.65 58.280.28 435.442.37
36.040.753.00 4,051,479.27 31,989,273.73 35.734.589,66 3.858.761.33 31.875,828.33
212.932.00
739,518,00
319,600.00
659.076,00
1.038.223,00
731.567.00
386,665.00
20,940.00
285,000.00
4,393,521.00
7,876,674.00
71.462,00
181,437,00
60.959,00
5.108.279.00
13,298.811,00
616,631.00
10,427.00
132,100.00
70,337.00
507.726.00
1.337.221,00
8.242.00
32,564,65 180,367.35
111.470.25 628,047.75
40.523.36 279.076.64
8,203.07 650.872.93
150.082.28 888.140.72
42.205.35 689.361.65
141.546.73 245.118.27
25.30 20.914.70
285.OOO.OO
526.620.99 3.866.900.01
94.246.97 7.782.427.03
71.462,00
181,437.00
7.780.57 53.178.43
60.553.74 5.047.725.26
162.581.28 13.136.229.72
74.756.31 541.874.69
10.427.00
132.100.00
70.337,00
6,693.07 501.032,93
81,449.38 1,255,771.62
1.539,00 6.703,00
237.213.05
560.261.66
296.959.71
764,454.52
922,573,22
657,327,17
371,825.68
14,507.57
109,981.56
3,935,104.14
6,671.225,63
56.677.08
138.935.98
46,012.48
4,712,147.54
11,624,998,71
557.092,53
6.406.00
132.383,34
51.079,02
347,022,86
1,093,983,75
1,807,38
24.395.90
74.173.10
42,339.23
103.557.38
142,532.56
35,419.59
120,783.96
543,201.72
134,181,08
7.236.50
42,411~55
183,829.13
70,632,85
230,78
70.863,63
25~00
212.817,15
486.088.56
254.620.48
660,897.14
780,040.66
621,907.58
251,041,72
14,507.57
109,981.56
3,391,902.42
6,537,044,55
56.677.08
138.935.98
38.775.98
4,669,735,99
11,441,169.58
486,459.68
6,406.00
132.383.34
51.079.02
346,792.08
1.023.120.12
1,782.38
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 08/31/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y,T,D,
VARIANCE
CHILD CARE
SOCIAL SERVICES
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
15,000,00
6.000.00
39.759.00
69.001.00
496,219.00
137.153,00
90.771,00
37.418,00
1.263,230,00
70,906,00
453.444,00
261.690,00
270.182.00
79.421.00
113.854.00
95,061.00
96.743.00
35,167,00
349.589.00
190,215.00
143.005_00
332.691.00
223.360.00
4.740.119.00
2.011.188.00
1,563,701.00
1.852.477.00
285.875.00
5.713.241.00
6.939.521.00
1,774.943.00
1,591,426.00
991.617.00
11,297.507.00
40,849,421.00
(4.808.668,00)
(4.808,668.00)
6,000.00
7,539,00
49.910.80
10.993,46
1.716,53
22.221,02
54.328.98
64.830,46
44.363,04
31,293,00
9,735,50
16,149.00
13,257.35
16.528,04
2,304~79
41,765,11
23,561.28
30,731.11
87,434.12
30.467.87
551,591,46
191.053,24
80.907.51
176,332,92
88.096.12
536.389,79
827.539,47
5.179,45
4.446,01
837.164,93
2,703,336.83
1.348,142,44
1,348,142.44
15.000.00
39.759,00
61.462.00
496.219.00
87.242.20
79.777.54
35,701.47
1.241,008.98
16,577.02
388.613.54
217,326.96
238.889.00
69 685.50
97 705.00
81 803,65
80 214.96
32 862.21
307 823.89
166 653.72
112 273.89
245 256.88
192,892.13
4.188.527.54
1.820.134.76
1.482.793.49
1,676,144.08
197.778.88
5.176,851.21
6.111.981.53
1.769.763.55
1.591.426.00
987,170.99
10.460.342.07
38,146,084.17
(6.156.810.44)
(6,156,810,44)
15.000.O0
35.209.87
52.017.25
376,276.00
119.409.29
69.056.56
30,077~98
1,086,713.48
80,087,02
374.296.72
207.485.47
250.744.31
57.440,25
106.153.40
76.856.84
82.402,67
23.572,33
314.727.68
146,794,25
145.812,50
322,361.18
141.968,69
4.012.236.62
1.486,174.17
1.276,188.20
1,609,264.48
271.192.90
4,642,819.75
4,568.489.35
273.283.82
351,854.08
580.027.47
5.773.654.72
31.134.814,94
4.599.774.72
1,488.54
4,601,263.26
25.00
56.820.40
6,600.99
3,426.64
53.657.00
48,209.27
40,509,85
28.960.72
7.955.50
15.992,48
9.248.71
10.045.31
1.667.61
39.892.67
21.428,36
27.787.90
93,255.57
16,600.95
482.059.93
185,499.77
146.868.36
139,289,87
58.021.68
529,679,68
864.442.38
24.999.99
639.53
112,461.27
1,002,543.17
2.812,202.26
1.046.559.07
1,046.559.07
15,000~00
35,209.87
51.992.25
376,276,00
62,588,89
62.455,57
30.077,98
1,083,286.84
26.430.02
326.087,45
166.975,62
221,783,59
49,484,75
90.160,92
67.608.13
72,357.36
21,904.72
274,835,01
125,365.89
118,024.60
229.105,61
125.367,74
3,530,176,69
1,300.674,40
1,129,319,84
1.469.974,61
213,171.22
4,113.140,07
3,704,046.97
248,283.83
351,214.55
467,566,20
4,771.111,55
28.322.612.68
3,553,215.65
1.488.54
3,554.704.19
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 08/31/2002
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
SOCIAL SERVICES
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
T~NSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE> EXPENDITURE
93,610.00
317,700.00
153.000.00
50,995~00
4.516.742.00
240,909.00
242.461,00
885,779.00
5,000.00
6,506,196.00
205.727,00
145,900,00
213,873.00
565,500.00
219,619.00
219.619,00
1,079.569.00
28.427,00
1.107.996,00
6,000.00
6.000.O0
36.782.00
426.095.00
3.932.073.00
4.394.950.00
93.610.
23.816.39 293.883.
46.45 152,953.
50.995.
4,516,742~
240,909.
35,000.00 207.461.
885,779.
5.000.
58,862.84 6.447.333.
(212.131.00) 49,860,40 (261,991,40)
O0 89.809.03
61 206.812.62 36.026.22
55 149.023.41 58,46
O0 65.404,41
O0 1,148,613.90 112.232.57
O0 241.589.50
O0 289,566.21 20.195.00
O0 852.087,78
O0 30.997,14
16 3,073.904,00 168.512,25
13,860.84 191,866.16 374.279.62
3,014.64 142,885.36 145.399.20
254.88 213.618.12 193.800.29
17.130.36 548.369,64 713.479,11
219,619.00 209.801.34
219.619,00 209,801,34
260,68 1.079.308,32 1,030,807,37
28.427,00 7,500.00
9,999.54
260.68 1,107,735.32 1.048.306.91
6.000.00 6.000.00
6.000.00 6,000.00
36,782.00 73,425.55
426,095.00
91,332.20 3,840,740.80 2,381,255.78
91,332.20 4,303,617.80 2,454,681.33
6,294,065.00 108,723.24 6,185,341.76 4,432,268.69
(212.131.00) 49.860,40 (261,991.40) 1.358.364.69
1.488.54
1,359,853.23
28.723.91
1.527.24
273,06
30,524.21
273.06
273.06
1,001.00
1,001.00
116.161,37
116.161,37
147.959.64
(20.552,61)
(20.552,61)
89.809.03
170.786.40
148.964.95
65.404.41
1.036.381.33
241.589,50
269.371.21
852,087,78
30.997,14
2,905.391,75
345.555,71
143.871,96
193.527,23
682,954,90
209.801,34
209.801.34
1.030,534.31
7.500.00
9.999.54
1.048.033.85
4,999.00
4,999.00
73.425.55
2.265.094,41
2.338.519,96
4.284.309.05
1.378.917,30
1,488,54
1.380.405,84
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 08/31/2002
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
536,364.00
13.888,00
4,000,00
554,252,00
536,364,00
13.888.00
4,000.00
554,252.00
427.577.38
9,818.32
1.995.50
439.391.20
427.577.38
9,818.32
1.995.50 '
439,391.20
**************************
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG
ACTIVITY TOTAL
TRANSPORTATION
PUBLIC WORKS
STREET TREE MAINTENANCE
STREET LANDSCAPE MAINTENANCE
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
ENGINEERING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT
ACTIVITY TOTAL
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
274.300.00
274.300.0O
4.754.00
14.734.00
292.861.00
312.349.00
16.250.00
16,250.00
102.000.00
102.000,00
704.899.00
150.647.00
14.787.18
14.787.18
235,58
8.229.14
8.464.72
4,335.84
4,335.84
27,587.74
27.587.74
259.512.82
259.512.82
4,518.42
14,734.00
284,631.86
303,884,28
11,914,16
11,914.16
102.000,00
102.000,00
677.311.26
123.059.26
198.138.51
198,138.51
3.277.32
7,713.24
231,458.34
242,448.90
20.071.01
20.071,01
460.658,42
21,267,22
13,062.80
13,062.80
1.176.91
182.36
1.359.27
4,645.15
4.645.15
19,067.22
19,067.22
185.075.71
185,075.71
2.100.41
7,713.24
231.275.98
241,089.63
15,425.86
15.425,86
441,591.20
2,200.00
EXCESS <REVENUE>EXPENDITURE 150.647.00 27.587,74 123.059,26 21.267,22 19,067,22 2,200.00
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 08/31/2002
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,104,085,00
11,180,405,00
12,284,490,00
1.104.085.00
11,180,405.00
12,284,490.00
766.333,51
766.333,51
766.333.51
766.333.51
**************************
GENERAL GOVERNMENT ACTIVITIES:
CITY ATTORNEY
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
12.950.00
12.950.00
214.797.00
10,679,999.00
3.348.169.00
19.756.297.00
33.784,465,00
34,012,212.00
21.727.722.00
17,340,00
376.14
376.14
372.058.23
519.11
121.518.50
494,095,84
511,811.98
511,811.98
12.950.00
12,950.00
197.457.00
(376.14)
(376.14)
10.307.940.77
3.347.649.89
19.634.778.50
33,290,369.16
33,500,400.02
21.215.910.02
96,133.06
8.585.61
8.585.61
4.324,162.75
125.589.57
3,963.866.42
8.413.618.74
8.518.337.41
7,752,003.90
673.84
3,129,63
3.129,63
5,859,72
101.426,75
107.286.47
111.089.94
111,089+94
95.459.22
5,455.98
5,455.98
4,318.303,03
125,589.57
3.862,439,67
8.306.332.27
8.407.247.47
7,640,913,96
EXCESS <REVENUE>EXPENDITURE 21.727.722.00 511.811.98 21.215.910.02 7,752,003.90 111,089.94 7,640,913.96
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 08/31/2002
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,264,42
5,367,69
242,632,11
490,25
490,25
237.264.42
4.877.44
242.141.86
**************************
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
229,828.00 170,019,80 59,808,20 233,733,39 166,466.18 67.267,21
229,828.00 170.019.80 59,808.20 233.733.39 166,466.18 67.267.21
229.828.00 170.019.80 59.808,20 233,733.39 166.466.18 67.267.21
229.828,00 170.019,80 59.808,20 (8,898,72) 165.975,93 (174.874.65
EXCESS <REVENUE>EXPENDITURE 229.828.00 170.019,80 59.808.20 (8.898,72) 165.975.93 (174.874.65
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 08/31/2002
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
227,059.00
1,367,268.00
20,000.00
1,614.327.00
197.260.83
197,260.83
227.059.00
1.170.007.17
20,000.00
1.417.066.17
121,730.05
1,123,051.14
22,267.13
1,267,048.32
186,401.38
2,265.00
188.666.38
121.730.05
936.649.76
20.002.13
1,078.381.94
**************************
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
FIRE
ACTIVITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROOECTS:
1.741.280.00
1,741.280.00
51,818.00
51.818.00
202,719,45
202,719.45
1,538,560.55
1.538.560.55
51.818.00
51.818.00
401.968.85
401,968.85
41,899.88
41.899.88
69.007.66
69,007.66
332,961.19
332,961.19
41.899.88
41.899.88
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
T~NSFERS OUT TO OTHER FUNDS
1,793,098.00
178.771.00
202.719.45
5,458.62
1.590,378.55
173,312_38
443,868.73
(823.179.59)
69.0O7.66
(119.658.72)
374.861.07
(703.520.87)
EXCESS <REVENUE>EXPENDITURE 178,771.00 5.458.62 173.312.38 (823,179.59) (119.658.72) (703.520.87)