HomeMy WebLinkAbout4.03 Financial Report CITY CLERK
File # 330-50
AGEN DA STATEMENT
CITY COUNCIL MEETING DATE: October 21,2003
SUBJECT:
Preliminary Financial Reports For the Month of September 2003
Report Prepared by: Carole A. Perry, Administrative Services
Director and Fred Marsh, Finance Manager
ATTACHMENTS:
RECOMMENDATiON~Q~/~)/
FINANCIAL STATEMENT:
1. YTD Revenues and Budget Comparison
2. YTD Expenses and Budget Comparison
3. Financial Statements for the Months of September 2003
Receive the reports.
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report on the preliminary financial statements for the months
of September. The final audited results for Fiscal Year 2002/2003 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 Reporting of Information
The auditors have begun the final phase of the fieldwork necessary for the 2002/2003 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 fired revenues and
expenses.
Analysis of Preliminary September 2003 Revenue and Expenditure Report
Given that this is only the third month of the 2003/2004 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 September are comparable to what occurred in the third
month of the previous Fiscal Year. Through September 2003, the City had collected approximately 15%
of the total budgeted General Fund Revenues, which was similar to the percentage collected in the prior
Fiscal Year.
Real Property Transfer Tax is higher than in the same Period of the prior year due to an increase in the
dollar amount of residential and commercial property sales transactions within the City. Licenses and
COPIES TO:
G:\Monthly Financials'dzY 03-04\092003 agenda statement monthly financials.doc l 0~'
ITEM NO.
Permits are higher than in the same period 0f th~ pfi0i~ y~iP flue to an increase in the valuation of building
permits on new residential and commercial projects.
Interest Revenue is lower than in the same period in the prior year due to significant market value
increases that occurred in the City's investments in the prior year and timing differences in the receipt of
interest payments. Initially all interest revenue is recorded in the General Fund and is then allocated
quarterly to other funds on a pro rata basis.
Vehicle License Fees are lower than in the same period of the prior year due to the state not paying the
backfill portion of the Vehicle License fee for the first three months of the Fiscal Year. Fines and
Forfeitures are higher than in the same period of the prior year due to an increase in the allocation of court
fines to the City for the first three months of the Fiscal Year. Other Revenue is lower than in the same
period of the prior year due to the final payment received from the School District for partial
reimbursement of the costs of a School Resource Officer.
General Fund Expenditures
Overall, through the month of September expenditures in the General Fund totaled $3.7 million and
represented approximately 9% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $206,342 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 2003 was
comparable to the amounts expended for the same period in the prior Fiscal Year. Thru the end of
September 2003, the City had expended 10% of the General Fund Operating Budget, which was similar to
the percentage collected in the prior Fiscal Year. As previously noted there are some timing differences
with payment for contract services, which complicate comparisons from one year to the next.
Health and Welfare is higher than in the same period of the prior year due to timing differences in the
payments for contract child care support services. Capital Improvement Projects are lower than in the
same period of the prior year due to expenditures incurred to date in the prior year for construction of the
City's new library. 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 2003-2004 YTD Revenues and Budget Comparison
For the Period Ending September 30, 2003
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
0%
6% 6%
17° ~7%
5%
4%
! 2%
30% 60% 90% 120% 150%
[] FY 2003/04
[] FY 2002/03
25% of Year Complete
Pro perty 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
Date Printed; 10/6/2003 10:25 AM
FY 2003/04 FY 2003/04 % of FY 2002/03
Budget YTD Actual Budget YTD Actual
11,274,729 633,580 6% 604,014
13,036,000 2,509,697 19% 2,289,757
334,000 36,245 11% 20,141
719,550 125,227 17% 132,640
1,414,237 118,670 8% 121,151
2,025,003 869,474 43% 647,096
897,550 305,662 34% 1,050,928
1,916,900 339,216 18% 528,063
4,868,788 680,744 14% 760,329
106,500 20,727 19% 20,235
551,071 13,177 2% 61,458
37,144,328 5,652,419 15% 6,235,812
% of Total for
FY 2002/03
6%
17%
5%
18%
9%
27%
65%
25%
16%
14%
15%
16%
ATTACHMENT 1
City of Dublin 2003-2004 YTD Expenses and Budget Comparison
For the Period Ending September 30, 2003
Total General Fund
Expenses
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
1~%
8%
,~1,~ ~;~ ~, ..... 20%
3O/o
3 /o
2%
3% 4%
~ 14~
2%
'r%
19%
r%
8%
14%
[ I
0% 20% 40% 60% 80% 100%
· FY 2OO3/04
[] FY 2OO2~O3
25% 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
2003~04 2003~04 % of
Budget YTD Actual Budget
4,825,056 866,380 18%
8,601,317 243,059 3%
7,159,187 90,298 1%
351,758 11,856 3%
1,607,102 222,564 14%
31,341 22,027 70%
5,329,601 906,084 17%
6,457,591 1,116,053 17%
5,434,997 206,342 4%
39,797,950
34,362,953
3,684,663 9%
3,478,321 10%
FY 2OO2~O3
YTD Actual
854,123
204,407
84,868
11,209
163,433
11,140
872,194
969,932
1,971,583
5,142,689
3,171,106
% of Totalfor
FY 2002~03
2O%
3%
2%
4%
12%
28%
19%
18%
51%
16%
11%
ATTACHMENT 2
Date Printed: 1016/2003 10:30 AM
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF SEPTEMBER 2003
Prepared by
The Finance Department
October 6, 2003
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Sep2003
SPECIAL SPECIAL CAPITAL TRUST/
REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUNDS FUND
TOTALS
---MEMORANDUM ONLY---
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
(43,579,336)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
94,112,095
138,985
200,330
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
308,720
9,913
51,190,708
LIABILITIES/FUND EQUITY
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
(955,826)
(44,782)
(997,723)
(1,995,332)
(547,958)
(11,820)
(127,768)
(4,681,209)
(46,509,499)
TOTAL FUND E (46,509,499)
TOTAL LIABILITIES/EQUITY (51,190,708)
3,535,583
32,353
3,567,936
(161,327)
308,720)
(470,047)
(3,097,889)
(3,097,889)
(3,567,936)
361,418 33,670,375
361,418 33,670,375
(3,885,432)
(244,136)
(4,129,568)
(361,418) (29,540,807)
(361,418) (29,540,807)
(361,418) (33,670,375)
21,378 (5,990,582) (25,267,397)
172,312 172,312 170,522
94,112,095 90,934,928
171,338 1,031,249
200,330 542,481
1,447,500
1,641,190
308,720
9,913
· 1,447,500
90,431,627
8,838
1,553,500
68,974,122
(955,826)
(3,930,214)
(997,723)
(2,400,795)
(547.958)
(320,540)
(127,768)
(1,565,000) (1,565,000)
(1,565,000) (10,845,825)
(76,190) (79,585,803)
(76,190) (79,585,803)
1,641,190) (90,431,627)
(974.979)
103,635
(969,009)
(455,216)
(418,759)
(55,123)
(127,768)
(1,671,000)
(4,568,218)
{64,405,903)
(64,405,903)
(68,974,122)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUND
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Sep2003
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
7,246,978
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
47,305,485
54,552,463
LIABILITIES/FUND EQUITY
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 (54,552,463)
TOTAL FUND E (54,552,463)
19,466,456
68,752,907
19,466,456 68,752,907
(19,466,456)
(19,466,456)
(68,752,907)
(68,752,907)
7,246,978 6,412,239
66,771,941 48,676,346
68,752,907 50,675,589
142,771,826 105,764,174
(68,752,907) (50,675,589)
(68,752,907) (50,675,589)
(74,018,919) (55,088,585)
(74.018,919) (55,088,585)
TOTAL LIABILITIES/EQUITY (54,552,463) (19,466,456) (68,752,907) (142,771,826)(105,764,174)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 09/30/2003
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
TRAFFIC SIGNALS & STREET LIGHTIN
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
11,274,729.00
13,036,000.00
334,000.00
719,550.00
1,414,237.00
2,025,003.00
106,500.00
751.710.00
145,840.00
1,9t6,900.00
4,868,788.00
551,071.00
37.144,328.00
229 850.00
823 204.00
364 960.00
646 047.00
1,360 195.00
717 595.00
430 405.00
2,800.00
250,000.00
4,825,056.00
8,601,3t7.00
71.462.00
197,194.00
11,150.00
71,952.00
7,159,187.00
16,112,262.00
694,417.00
t0,004.00
145,676.00
118,188.00
638,817.00
1,607,102.00
8,691.00
633 580.48
2,509 697.43
36 245.25
125 226.90
118 670.00
869 474.12
20 727.37
272 675.38
32,986.58
339,215.71
680.743.89
13,177.19
5,652,420.30
38,660115
174,756.31
61,423.93
38,282.94
275,905.18
105,550.90
171,775.42
24.70
866,379.53
243,059.28
188.36
tl,667.20
90,298.38
345,213.22
143,539.35
202.30
10,819.19
23,885.87
44,117.78
222,564.49
2,000.00
10,641,148.52
10,526,302.57
297,754.75
594,323.10
1,295,567.00
1,155,528.88
85,772.63
479,034.62
112,853.42
1,577,684.29
4,188,044.11
537,893.81
31,491,907.70
191,189.85
648,447.69
303,536.07
607,764.06
1,084,289.82
612,044.10
258.629.58
2,775.30
250,000.00
3,958,676.47
8,358,257.72
71,462.00
197,194.00
i0,961.64
60,284.80
7,068,888.62
15,767,048.78
550,877.65
9,801.70
134,856.81
94,302.13
594,699.22
1,384,537.51
6,691.00
10,707,601.89
13.193,407.37
379,088.81
717,083.07
1,394,953.26
2,421,884.99
139,614.86
1,487,493.37
139,019.25
2,t40.597.93
4,760,254.62
410,713.57
37,891,712.99
196,233.20
740,856.35
292,316.29
850,821.87
982,221.59
757,323.39
325,538.39
10,9t8.84
146,605.38
4,302,835.30
7,947,078.88
61,878.80
164,564.93
(5,355.82)
59,237.80
4,948,289.35
13,175,693.94
632,481.15
9,868.95
122,569.70
76,662.73
495,105.08
1,336,687.61
1,798.28
604,014.12
2,289,757.30
20,140.70
132,639.54
121,151.00
647 095.58
20 234.74
1,025 346.08
25 581.68
528 063.01
760 329.09
61 457.78
6,235 810.62
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
204,406.72
11.209.09
84,667.77
300,283.58
112,960.68
10,313.52
7,525.13
32,634.02
1631'433.35
3,539.00
10,103,587.77
10,903,650.07
358.948.11
584.443.53
1,273,802.26
1,774,789.41
119,380.12
462,147.29
113,437.57
1,612,534.92
3,999,925.53
349,255.79
31,655,902.37
151,084.39
575,428.33
230,224.55
750,988.55
757,367.78
642,657.27
183,462.78
10,893.54
146,605.38
3,448.712.57
7,742,672.16
61,878.80
164,564.93
(5,355.82)
48,028.71
4,863,62t.58
12.875,410.36
519,520.47
9,868.95
1t2,256.18
69,137.60
462,471.06
t.173,254.26
(1,740.72)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 09/30/2003
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
LIB~RY 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
EMERALD GLEN ACTIVITY CENTER
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)
T~NSFERS IN FROM OTHER FUNDS
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES
18,500.00
1.000.00
3,150.00
31.341.00
553,662.00
138,088.00
114,188.00
43,858.00
1,457,804.00
64,634.00
541,383.00
281.699.00
291.253.00
82,383.00
111,392.00
105,034.00
113,604.00
41,560.00
4,039.00
361,928.00
219,073.00
190,418.00
364.122.00
249,479.00
5,329,601.00
2,451,689.00
1,824,288.00
1,900,705.00
280,909.00
6,457,591.00
983,660.00
845,044.00
2,869,563.00
736.730.00
5,434,997.00
39,797,950.00
(2,653,622.00)
(2,653,622.00}
18,500.00
1.000.00
527.18
22,027.18
10,643.16
53,052.50
19,654.39
2,271.16
108,484.68
56,510.38
114,816.64
63,879.72
55,623.22
13,745.20
18,686.47
24,245~60
16,130.82
2,772.91
83,602.36
44,074.57
48,404.18
117,863.03
51,622.54
906,083.53
392,639.42
293,293.66
329,296.96
100,823.45
1,116,053.49
19,t42.19
26,278.48
121.603.71
39,317.15
206,341.53
3,684,662.97
1,967,757.33
1,967,757.33
2,622.82
9,313.82
543.018.84
85.035.50
94,533.61
41,586.84
1,349,319.32
8,123.62
426,566.36
217,819.28
235,629.78
68,637.80
92,705.53
80,788.40
97,473.18
38,787.09
4 039.00
278 325.64
174 998.43
142 013.82
246 258.97
197 856.46
4,423 517.47
2,059,049.58
1,530,994.34
1,571,408.04
180.085.55
5,341,537.51
964,517.81
818,765.52
2,747,959.29
697,412.85
5,228.655.47
36,113,287.03
{4.621,379.33)
(4,621,379.33)
15,000.00
6,000.00
17,501.74
40,300.02
485.281.21
121,198.29
92,803.62
31,341.84
1,200,226.46
76,233.17
452,646.88
230,269.67
266,989.58
74,354.14
100,t41.63
97,087.23
93,209.36
46,605.98
356,425.65
183,985.64
153,581.45
338,055.6t
211,125.63
4,611,563.04
1,767,026.63
1,467,363.47
1,865,709.85
278,983.20
5,379.083.15
2,258,752.04
442,108.93
669,566.48
477,981.27
3,848,408.72
32,694,571.78
5.197,141~21
18,560.15
(20.00)
5,215,681.36
1,200.00
6,000.00
40O.53
11,139.53
55,427.39
18,187.27
3,788.04
100,714.87
63,784.95
99,512.58
58,994.20
50,114.76
17,238.44
22,585.51
20,395.17
21,243.58
2,487.57
97,826.23
36,528.19
39,208.70
118,704.19
45,452.03
872,193.67
319,937.71
232,298.69
304,373.32
113,321.79
969,93t.51
1,864,293.46
64,582.98
25,652.02
17,054.89
1,971.583.35
5,142,687.72
1,093,122.90
1,093,122.90
13,800.00
17,101.21
29,160.49
485,281.21
65,77O.9O
74,616.35
27,553.80
1,099.511.59
12,448.22
353,134.30
171,275.47
216,874.82
57,115.70
77,556.12
76,692.06
71,965.78
44,118.41
258.599.42
147,457.45
114,372.75
219,351.42
165,673.60
3,739,369.37
1,447,088.92
1,235,~64.78
1,561,336.53
165,661.41
4,409,151.64
394,458.58
377,525.95
643,914.46
460,926.38
1,876,825.37
27,551,884.06
4,104,018.31
18,560.15
(20.00)
4,122,558.46
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 09/30/2003
SPECIAL REVENUE FUNDS
CURRENT
BUDGET
CURRENT PRIOR PRIOR
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
DISASTER PREPAREDNESS
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
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
108,192.00
333,000.00
149,000.00
36,949.00
1,287,011.00
282,829.00
1,675,946.00
981,937.00
102,000.00
4,956,864.00
108,192.00 103,107.58
333,000.00 380,199.02
12,272.78 136,727.22 134,670.06
36,949.00 87,896.70
200,634.69 1,086,376.31 8,756,019.28
282,829.00 276,556.50
1,675,946.00 133,137.78
981,937.00 920,648.29
102,000.00 251,582.51
212,907.47 4,743,956.53 11,043,817.72
168,735.00 168,735.00 210,229.18
189,500.00 14,748.06 174,751.94 142,988.43
7,000.00 2,175.00 4,825.00 7.258.78
250,579.00 1,250.00 249,329.00 204,076.36
615.814.00 18,173.06 597.640.94 564,552.75
237,579.00 14,677.72 222,901.28 238,621.60
237,579.00 14.677.72 222,901.28 238,621.60
1,295,325.00 1,250.00 1,294,075.00 597,456.65
44,935.00 44,935.00 28,427.00
1,340,260.00 1,250.00 1.339,010.00 625,883.65
6,000.00
6,000.00
50,000.00
770,167.00
341.928.00
1,879,612.00
3,041,707.00
6,000.00 6,000.00
6,000.00 6,000.00
50,000.00
770,167.00 36,200.00
341,928.00 426,095.00
17,956.02 1,861,655.98 8,706,980.68
17,956.02 3,023,750.98 9,169,275.68
53,731.09
12,237.66
134,423.27
27,905.00
56,487.82
284,784.84
15,235.39
5,996.97
254.88
21,487.24
16,t63.58
16,163.58
260.68
446.44
707.12
669,258.65
669,258.65
103,107.58
326,467.93
122,432.40
87,896.70
8,621.596.01
248,651.50
76,649.96
920,648.29
251,582.51
10,759.032.88
194,993~79
136,991.46
7,258.78
203,821.48
543,065.51
222.458~02
222,458.02
597,195.97
27,980.56
625,176.53
6,000.00
6,000.00
36,200.00
426,095.OO
8,037,722.03
8,500,017.03
5,241,360.00 52,056.80 5,189,303.20 10,604,333.68 707,616.59 9,896,717.09
284,496.00 (160,850.67) 445,346.67 (439,484.04) 422,831.75 (862,315.79)
18,560.15
18,560.15
EXCESS <REVENUE> EXPENDITURE 284,496.00 (160,850.67) 445,346.67 {420,923.89) 422,831.75 (843,755.64)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 09/30/2003
SPECIAL ASSESSMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUNDS
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
************************
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
630,482.00
13,704.00
4,000.00
648,186.00
630,482.00 501,425.07 (264.03) 501,689.10
13,704.00 14,049.83 14,049.83
100.00 3,900.00 10,598.97 5,070.54 5,528.43
100.00 648,086.00 526,073.87 4,806.51 521,267.36
**************************
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
269,686.00 29,032.55 240,653.45 204,778.18 41,247.08 163,531.10
269,686.00 29,032.55 240,653.45 204,778.18 41,247.08 163,531.10
1,791.00 262.33 1,528.67 1,393.46 307.91 1,085.55
29,768.00 97.08 29,670.92 9,437.02 2,122.71 7,314.31
355,333.00 20,472.09 334,860.91 264,802.70 28,989.71 235,812.99
386.892,00 20,831.50 366.060.50 275,633.18 31,420.33 244,212.85
15,250.00 8,105.50 7,144.50 14,565.20 4,335.84 10,229.36
15,250.00 8,105.50 7.144.50 14,565.20 4,335.84 10,229.36
70,881.00
70,881.00
70,881.00
70,881.00
56,000.00
56,000.00
56,000.00
56,000.00
742,709.00 57,969.55 684,739.45 550,976.56 77,003.25 473,973.31
94,523.00 57,869.55 36,653.45 24,902.69 72,196.74 (47,294.05)
EXCESS <REVENUE>EXPENDITURE 94,523.00 57,869.55 36,653.45 24,902.69 72,196.74 (47,294.05)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD '
07/01/2003 THROUGH 09/30/2003
CAPITAL IMPROVEMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUNDS
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
***********************
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
759,951.00
19,079,000.00
19,838,951.00
759,951.00
19,079,000.00
19,838,951.00
1,120,018.43
10,195,565.15
11,315,583.58
1,120,018.43
10,195,565.15
11,315,583.58
**************************
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
28,800.00
28.800.00
296,415.00
102,875.00
51372,244.00
17:296,286.00
22,771,405.00
23,096,620.00
3,257,669.00
1.422.00
1,422.00
81,190.16
464,517.81
278,275.79
342,221.94
1,o85,o15.54
1,167,627.70
1,167,627.70
27,378.00
27,378.00
215,224.84
(361,642.81)
5,093,968.21
16,984,064.06
21,686,389.46
21,928,992.30
2,090,041.30
23,902.29
4,253,902.29
219,771.73
10,315,973.90
1,274,709.53
4,861.559.57
16,452.243.00
20,925,917.02
9,610,333.44
25,088.97
696.45
696.45
436,131.11
12,322.05
195,434.67
643,887.83
669,673.25
669.673.25
23,902.29
4,253,902.29
194,682.76
(696.45)
(696.45)
..9,879,842.79
1,262,387.48
4,666,124.90
15,808,355.17
20,256,243.77
8,940,660.19
EXCESS <REVENUE>EXPENDITURE 3,257.669.00 1,167,627.70 2,090,041.30 9,610,333.44 669,673.25 8,940,660.19
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD~
07/01/2003 THROUGH 09/30/2003
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
************************
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
238,107.33
5.009.96
243,117.29
238,107.33
5,009.96
243,117.29
*******EXPENDITURES~******
GENE~L 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
173.508.25 (173,508.25) 233,949.42 170,019.80
173,508.25 (173,508.25) 233,949.42 170,019.80
173,508.25 (173,508.25) 233,949.42 170,019.80
173,508.25 (173,508.25) (9,167.87) 170,019.80
63,929.62
63,929.62
63,929.62
179,187.67)
EXCESS <REVENUE>EXPENDITURE 173,508.25 (173,508.25) (9,167.87) 170,019.80 (179,187.67)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 09/30/2003
INTERNAL SERVICE FUNDS
CURRENT
BUDGET
CURRENT PRIOR PRIOR
ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
*************************
US*S/MONEY & PROP-INTEREST
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
145.333.00
1,590,277.00
21,000.00
1,756,610.00
393,561.70
393,561.70
145,333.00 209,125.89
1,196.715.30 1,326,711.49
21,000.00 24,360.53
1,363,048.30 1.560,197.91
330.700.20
330,700.20
209,125.89
996,011.29
24,360.53
1,229,497.71
**************************
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
FIRE
ACTIVITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
1,484,152.00
1.484,152.00
64,285.00
64,285.00
160,871.92 1,323,280.08 2,305,111.06
160,871.92 1,323,280.08 2,305,111.06
64,285.00 40,560.59
64,285.00 40,560.59
231,688.34
231,688.34
2,073,422.72
2,073,422.72
40.560.59
40,560.59
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
1,548,437.00 160,871.92 1,387,565.08 2,345,671.65
(208,173.00) (232.689.78) 24,516.78 785,473.74
231,688.34
(99,011.86)
2,113,983.31
884,485.60
EXCESS <REVENUE>EXPENDITURE (208.173.00) (232,689.78) 24,516.78 785,473.74' (99,011.86) 884,485.60
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 09/30/2003
ENTERPRISE
FUND
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
13
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
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
(20.00)
20.00
20.00
20.00
20.00
20.00)
EXCESS <REVENUE>EXPENDITURE 20.00 20.00