HomeMy WebLinkAboutItem 4.07 PrelimFinclRptsOct03 CITY CLERK
File #1 -L LW
AGEN DA STATEMENT
CITY COUNCIL MEETING DATE: December 2, 2003
SUBJECT:
ATTACHMENTS:
Preliminary Financial Reports For the Month of October 2003
Report Prepared by: Carole A. Perry, Administrative Services
Director and Fred W. Marsh, Finance Manager
YTD Revenues and Budget COmparisOn
YTD Expenses and Budget ComParison
Financial Statements for the Months of October 2003
RECOMMENDATION: ~
FINANCIAL STATEMENT:
Receive the reports.
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report on the preliminary financial statements for the month
of October. 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 fund revenues and
· expenses.
Analysis of Preliminary October 2003 Revenue and Expenditure Report
Given that this is only the fourth 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 mounts of Property
Taxes and Sales Taxes are not received until later in the Fiscal Year. There is also a lag with the reporting
of expenditures due to the significant amount of services provided to the City by independent contractors.
General Fund Revenues
Total General Fund Revenues collected through October are comparable to what occurred in the fourth
month of the previous Fiscal Year. Through October 2003, the City had collected approximately 21% 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
Document in FSCOLOR 10.2003.XLS
COPIES TO:
ITEM NO.
Permits are higher than in the same period of the p~3f ~ due 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, a change in the method of allocating
interest to all funds (from semi annually to quarterly) 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 (VLF) are lower than in the same period of the prior year due to lower car sales
statewide and the State not paying the backfill portion of the VLF for the first three months of the Fiscal
Year. The Governor has recently passed legislation that repealed the increase in the VLF that took place
on October 1, 2003. Therefore, unless the State passes subsequent legislation that' reestablishes the
payment of the backfill portion of the fee to cities, the City will realize a projected total loss of $1.5
million in VLF for Fiscal Year 2003-2004. It should be noted that Council already approved a budget
adjustment at the September 16, 2003 Council Meeting reducing the VLF revenue budget by $456,000,
thus the additional net loss of VLF revenue to the City will be approximately $1 million.
In the Charges for Services category, it should be noted that the City expects to receive approximately
$267,000 less in revenue for the fire charges for services revenue item due to a change in how calls for
emergency service are being handled. Other Revenue is lower than in the same period of the prior year
due to timing differences in the receipt of a reimbursement from the School District for partial
reimbursement of the costs of a School Resource Officer in the prior Fiscal Year.
General Fund Expenditures
Overall, through the month of October expenditures in the General Fund totaled $5.4 million and
represented approximately 13% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $500,000 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 October 2003 was
comparable to the amounts expended for the same period in the prior Fiscal Year. Thru the end of
October 2003, the City had expended 14% 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 and expenditures incurred for an update to the City's
housing element that was originally anticipated to occur in Fiscal Year 2002-2003. 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 October 31, 2003
6% 6%
4%
~ ~~73%
115%
Total General Fund Revenues
Intergovernmental from State
Charges for Services
Fines and Forfeitures
Other Revenues
0% 30% 60% 90% 120% 150%
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
[] FY 2003/04
[] FY 2002/03
33% of Year Complete
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental
Charges for Services
Fines and Forfeitures
Other Revenues
Total General Fund Revenues
Date Printed: 11/12/2003 8:O5 AM
FY 2003~04 FY 2003/04
Budget YTD Actual
11,274,729 633,580
13,036,000 3,484,797
334,000 123,789
719,550 162,969
1,414,237 260,922
2,025,003 1,472,354
897,550 284,064
1,916,900 398,086
4,868,788 1,047,921
106,500 25,416
551,071 22,907
37,144,328 7,916,805
% of FY 2002/03 % of Total for
Budget YTD Actual FY 2002/03
6% 604,014
27% 3,167,657
37% 94,944
23% 172,704
18% 251,522
73% 1,151,964
32% 1,272,117
21% 684,542
22% 1,130,938
24% 28,067
4% 61,802
21% 8,620,271
6%
24%
25%
24%
18%
48%
78%
32%
24%
2O%
15%
23%
ATTACHMENT 1
City of Dublin 2003-2004 YTD Expenses and Budget Comparison
For the Period Ending October 31, 2003
Total General Fund
Expenses
%
/~%
2"
J ~
121%
19%
~24% o
29¥0
~26%
5%
9%
I
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
0% 20% 40% 60% 80% 100%
· FY 2003/04
[] FY 2002~03
33% of Year Complete
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture and Community Services
Community Development
Capital Improvement Projects
Total General Fund Expenses
General Fund Operating Expenses
2003~04 2003~04 % of FY 2002~03
Budget YTD Actual Budget YTD Actual
4,851,541 1,161,658 24% 1,216,566
8,601,317 266,301 3% 283,736
7,159,187 107,174 1% 112,673
351,758 10,774 3% 20,571
1,607,102 338,362 21% 247,653
31,341 34,653 111% 13,566
5,329,601 1,269,482 24% 1,323,229
6,457,591 1,675,273 26% 1,350,890
5,434,997 499,626 9% 2,712,539
39,824,435 5,363,303 13% 7,281,423
34,389,438 4,863,677 14% 4,568,884
% of Total for
FY 2002/03
28%
4%
2%
7%
19%
34%
29%
25%
70%
22%
16%
ATTACHMENT 2
Date Pdnled: 11/12/2003 8:10 AM
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF OCTOBER 2003
Prepared by
The Finance Department
November 12, 2003
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 310ct2003
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
(44.578,927)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
94,193,992
138,985
200,330
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
308,720
9,778
50,272,879
LIABILITIES/FUND EQUITY
3,293,632
32,353
3,325,985
DEPOSITS FOR PRIVATE DEVEL (1,130,691)
DEPOSITS FOR AB1600 FEES (51.418)
DEPOSITS OTHERS (1.123.034)
PAYABLES: ACCOUNTS (823.045) (658.131)
INTEREST
PAYROLL (500.265)
DUE TO OTHERS (134,401) (308.720)
DEFERRED REVENUE (127.768)
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (3,890.623) (966.852)
FUND BALANCES (46,382.257) (2,359.134)
TOTAL FUND E (46,382.257) (2.359.134)
302,562 35,405,425
302,562 35,405,425
(6.903.345)
(292.565)
(7.195.910)
(302.562) (28.209,515)
(302.562) (28.209.515)
21.732 (5,555,575) (25,936,449)
172,312 172,312 171.289
94,193,992 90,795,617
171,338 944.459
200.330 542.481
1,447.500
1.641,544
308.720
9,778
1.447,500
90.948.396
12,776
1,553,500
68.083,673
(1.130,691)
(6,954,763)
(1,123,034)
(1,773,742)
(500,265)
(443.121)
(127.768)
(1.565.000) (1,565.000)
(1.565.000) (13.618.384)
(76.544) (77.330.012)
(76.544) (77.330.012)
(1.023,618)
(499,775)
(1.027,991)
(251.832)
(393.400)
(38.446)
(127,768)
(1,671,000)
(5,033.829)
(63,049,843)
(62,049,843)
TOTAL LIABILITIES/EQUITY (50.272,879) (3.325.985) (302.562) (35.405.425) (1.641.544) (90.948.396) (68.083.673)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUND
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 310ct2003
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,216.179
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.265,633
54,481,812
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS (17,215)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (17.215)
FUND BALANCES (54,464,597)
TOTAL FUND E (54,464,597)
19.466.456
68,724,531
19,466.456 68.724,531
(19,466,456)
(19,466,456)
(68,724,531)
(68,724,531)
7,216,179 6.378,362
66,732,089 48,676,346
68,724,531 50,675,589
142,672,799 105,730,297
(17,215)
(68,724,531) (50,675,589)
(68,741,746) (50,675,589)
(73.931,053) (55,054,708)
(73,931,053) (55,054,708)
TOTAL LIABILITIES/EQUITY (54,481,812) (19,466,456) (68,724,531) (142,672,799)(105,730,297)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 10/31/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 A1-FORNEY
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
7
16
11,274.729.00 633,580.48 10,641,148.52
13,036,000.00 3,484,797.43 9,551,202.57
334,000.00 123,788.63 210,211.37
719,550.00 162,968.92 556,581.08
1,414.237.00 260.922.08 1,153,314.92
2,025,003.00 1,472,353.85 552,649.15
106,500.00 25,416.42 81,083.58
751,710.00 241,467.58 510,242.42
145,840.00 42,595.64 103.244.36
1,916,900.00 398,085.59 1,518,814.41
4,868,788.00 1,047,920.52 3,820,867.48
551,071.00 22,906.90 528,164.10
37,144,328.00 7,916,804.04 29,227,523.96
229,850.00 60,95t.84 168,898.16
823,204.00 231,815.94 591,388.06
364,960.00 85,232.17 279,727.83
646,047.00 96,022.87 550,024.13
1,360,195.00 359,630.84 1,000,564.16
717,595.00 150,444.39 567,150.61
430,405.00 176,745.37 253,659.63
2,800.00 814.70 1,985.30
276,485.00 276,485.00
4,851,541.00 1,161,658.12 3,689,882.88
8,601,317.00
71,462.00
197,194.00
11,150.00
71,952.00
,159,187.00
,112,262.00
10,039 542.89
13,193 407.37
379 088.81
717 083.07
1,394 953.26
2,421 884.99
139614.86
1,487,493.37
139,019.25
2,140,597.93
4,760,254.62
410,713.57
37,223,653.99
196 233.20
740 856.35
292 316.29
850 821.87
982 221.59
757 323.39
262 022.64
10,918.84
146,605.38
4,239,319.55
266,301.46 8,335,015.54 7,947,078.88
4,791.50 66,670.50 61,878.80
(9,547.00) 206,741.00 164,564.93
188.36 10.961.64
15,340.96 56,611.04 59,237.80
107,173.80 7,052,013.20 4,951.374.82
384,249.08 15,728,012.92 13,184,135.23
604 014.12
3,167 657.30
94 943.53
172 704.08
251 522.21
1,151 963.79
28 066.79
1,234 253.83
37 862.69
684 542.17
1,130 937.94
61 801.76
8,620 270.21
51,794.58
224,704.97
84,065.30
210,342.88
305,080.24
187,699.41
152,853.57
25.30
1,216,566.25
283,736.00
4,791.50
15,779.33
112,673.01
416.979.84
9.435 528.77
10,025 750.07
284 145.28
544 378.99
1,143 431.05
1,269 921.20
111 548.07
253 239.54
101 156.56
1,456 055.76
3,629 316.68
348 911.81
28,603 383.78
144 438.62
516151.38
208250.99
640 478.99
677 141.35
569 623.98
209 169.07
10,893.54
146.605.38
3,122,753.30
7,663.342.88
57,087.30
164,564.93
43,458.47
4,838,701.81
12,767,155.29
8,691.00 2,000.00 6,691.00 1,798.28 3,539.00 (1,740.72)
694,417.00 189,371.94 505,045.06 632,481.15 154,664.05 477,817.10
10,004.00 202.30 9,801.70 9,868.95 83.48 9,785.47
145,676.00 21,059.51 124,616.49 122,569.70 19,430.41 103,139.29
118,188.00 30,706.20 87,481.80 76,662.73 10,638.06 66,024.67
638,817.00 97,022.34 541,794.66 495,105.08 62,836.74 432,268.34
,607,102.00 338,362.29 1,268.739.71 1,336,687.61 247,652.74 1,089,034.87
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 10/31/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
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
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
GENEP, AL 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
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,824,435.00
(2,680,107.00)
(2,680,107.00)
18,500.00 15,000.00 2,626.00 12,374.00
1,000.00 6,000.00 6,000.00
13,153.18 (10,003.18) 17,501.74 1,400.53 16,101.21
34,653.18 (3,312.18) 40,300.02 13,565.53 26,734.49
17 529
58 436
28 399
4 689
211 775
56 510
146 832
79 121
79 921
20 146
24 389
36 506
32 674.41
6,099.26
130,574.68
60,104.99
66,109.96
139,587.89
70,072.15
1,269,482.16
.37 536,132.63
.71 79,651.29
.58 85,788.42
.47 39,168.53
.51 1,246,028.49
.38 8~123.62
.40 394 550.60
.97 202 577.03
.70 211 331.30
.04 62 236.96
.04 87 002.96
.65 68 527.35
80 929.59
35 460.74
4 039.00
231 353.32
158 968.01
124 308.04
224 534.11
179 406.85
4,060.118.84
560,877.24
489,359.99
497,840.15
127,195.78
1,675,273.16
37,459.26
31,407.65
238,477.98
192,281.25
499.626.14
5,363,304.13
2,553,499.91
2,553,499.91
1,890,811.76
1,334,928.01
1,402,864.85
153,713.22
4,782.3t7.84
946,200.74
813,636.35
2,631,085.02
544,448.75
4,935,370.86
34,461,130.87
(5,233,606.91)
(5.233,606.91)
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 141.63
97 087.23
93 209.36
46 605.98
356,425.65
183,985.64
153,581.45
338,055.61
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,739,497.32
4,484,156.67
18,560.15
(20.00)
4,502,696.82
119,829.50
61,394.75
24,671.07
6,334.82
208,285.84
64,030.22
132,777.34
74,425.34
77,312.26
24,631.84
29,845.90
28,769.25
24,390.40
7,030.90
137.837.68
50,437.86
50,189.04
137,736.82
63.298.04
1,323,228.87
443,566.94
319,651.31
447,112.86
140,558.58
1,350,889.69
2,533 815.26
90 641.46
43 743.82
44 338.32
2,712 538.86
7,281 421.78
1.338 848.43
1,338,848.43
365,451.71
59,803.54
68,132.55
25,007.02
991,940.62
12,202.95
319 869.54
155 844.33
189 677.32
49 722.30
70 295.73
68 317.98
68 818.96
39 575.08
218,587.97
133,547.78
103,392.41
200,318.79
147,827.59
3,288,334.17
1,323,459.69
1,147,712.16
1,418,596.99
138,424.62
4,028,193.46
(275.O63.22)
351 467.47
625 822.66
433 642.95
1,135 869.86
25,458 075.54
3,145 308.24
18 560.15
(20.00)
3,163,848.39
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 10/31/2003
SPECIAL REVENUE FUNDS
CURRENT
BUDGET
CURRENT PRIOR
ACTUAL VARIANCE FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
********REVENUES********
PROPERTY TAXES
SALES TAX/OTHERTAXES
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
168,735.00
189,500.00
7,000.00
250,579.00
615,814.00
237,579.00
237,579.00
1,295,325.00
44,935.00
1,340,260.00
6,000.00
6,000.00
50,000.00
770,167.00
341,928.00
1,879,612.00
3,041,707.00
5,241,360.00
284,496.00
59,302.80
12,299.13
14,494.78
259,482.11
26,046.50
1,726.14
373,351.46
12,917.15
29,720.52
2,175.00
1,250.00
46,062.67
27,187:41
27,187.41
5,387.77
514.79
5,902.56
3,612.00
3,612.00
407,718.82
407,718.82
490,483.46
117,132.00
108 192.00
273 697.20
136 700.87
22 454.22
1,027 528.89
256 782.50
1,674 219.86
981 937.00
102 000.00
4,583 512.54
155,817.85
159,779.48
4,825.00
249,329.00
569,751.33
210,391.59
210,391.59
1,289,937.23
44,420.21
1,334,357.44
2,388.00
2,388.00
50,000.00
770,167.00
341,928.00
1,471,893.18
2,633,988.18
4,750,876.54
167,364.00
103,107.58
380,199.02
134,670.06
87,896.70
8.756,019.28
276,556.50
133,137.78
920,648.29
251,582.51
11,043,817.72
210,229.18
137,632.61
7,258.78
204,076.36
559,196.93
238,621.60
238,621.60
1,063,584.65
28,427.00
1.092,011.65
6,000.00
6,000.00
36,200.00
426.095.00
8,706,980.68
9,169,275.68
11,065,105.86
21,288.14
18,560.15
101,252.57
24,953.68
1,291,048.34
27,905.00
57,763.34
1,502,922.93
16,988.86
22,696.48
254.88
39,940.22
25,999.O7
25.999.07
260.68
1,038.02
1,298.70
209.50
209.50
726,009.21
726,009.21
793,456.70
(709,466.23)
103,107.58
278,946.45
109,716.38
87,896.70
7,464,970.94
248,651.50
75,374.44
920,648.29
251,582.51
9,540,894.79
193,240.32
114,936.13
7,258.78
203,821.48
519,256.71
212,622.53
212,622.53
1,063,323.97
27,388.98
1,090.712.95
5,790.50
5,790.50
36,200.00
426,095.00
7,980,971.47
8,443,266.47
10.271,649.16
730,754.37
18,560.15
EXCESS <REVENUE> EXPENDITURE 284,496.00 117.132.00 167,364.00 39,848.29 (709,466.23) 749,314.52
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 10/31/2003
S P E C I A L AS S E *SM E N'T
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 630,482.00 501,425.07 (264.03) 501,689.10
13,704.00 1,899.06 11.804.94 14,049.83 14,049.83
4,000.00 100.00 3,900.00 10,598.97 5,070.54 5,528.43
648,186.00 1,999.06 646,186.94 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
269,686
1,791
29,768
355,333
386,892
15,250
15,250
70,881.00
70,881.00
742,709.00
94,523.00
.00 45,333.75 224,352.25 204.778.18 46,461.66 158,316.52
.00 45,333.75 224,352.25 204,778.18 46,461.66 158,316.52
· 00 370.88 1,420.12 1,393.46
.00 366.19 29,401.81 9,437.02
.00 64,549.09 290,783.91 264,802.70
.00 65,286.16 321,605.84 275,633.18
361.32
2,853.72
59,034.78
62,249.82
1,032.14
6,583.30
205,767.92
213,383.36
.00 8,105.50 7,144.50 14.565.20 4,335.84 10,229.36
.00 8,105.50 7,144.50 14,565.20 4,335.84 10,229.36
70,881.00
70,881.00
56,000.00
56,000.00
55O,976.56
24,902.69
118.725.41
116,726.35
113,047.32
108,240.81
623,983.59
(22,203.35)
56,000.00
56,000.00
437,929.24
(83,338.12)
EXCESS <REVENUE>EXPENDITURE 94,523.00 116,726.35 (22,203.35) 24,902.69 108,240.81 (83.338.12)
***********************
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 10/31/2003
CAPITAL IMPROVEMENT FUNDS
CURRENT
BUDGET
CURRENT PRIOR PRIOR
ACTUAL VARIANCE FISCAL YEAR Y.T.D.
759,951.00
19,079,000.00
19,838,951.00
159,451.55 600,499.45 1,120,018.43
19,079,000.00 10,195,565.15
159,451.55 19,679,499.45 11,315,583.58
VARIANCE
1,120,018.43
10,195,565.15
11,315,583.58
**************************
GENERAL GOVERNMENT ACTIVITIES:
CITY A-FFORNEY
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
5,372,244.00
17,296,286.00
22,771,405.00
2.395.44 26,404.56 23,902.29
46,390.78 (17,590.78) 4.253,902.29
89,870.20 206,544.80 219,771.73
979,008.28 (876,133.28) 10,315,973.90
836,800.72 4,535,443.28 1,274,709.53
706,300.63 16.589,985.37 4,861,559.57
2,522,109.63 20,249,295.37 16,452,243.00
35,981.74
2,561.31
2,561.31
1,022,1i0.01
30,118.25
2,894,241.42
3,946,469.68
'23,902.29
4,253,902.29
183,789.99
(2,561.31)
(2,561.31)
9,293,863.89
1,244,591.28
1,967,318.15
12,505,773.32
23,096,620.00 2,658,370.61 20,438.2~9.39 20,925,917.02 3,985,012.73 16,940.904.29
3,257,669.00 2,498,919.06 758,749.94 9,610,333.44 3,985,012.73 5,625,320.71
EXCESS <REVENUE>EXPENDITURE 3,257.669.00 2,498,919.06 758,749.94 9,610,333.44 3,985,012.72 5,625,320.71
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 10/31/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
354.01 (354.01)
354.01 (354.01)
238,107.33
5,009.96
243,117.29
767.13
767.13
238,107.33
4,242.83
242,350.16
**************************
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
173,508.25 (173,508.25) 233,949.42 170,019.80 63,929.62
173,508.25 (173,508.25) 233,949.42 170,019.80 63,929.62
173,508.25 (173,508.25) 233,949.42 170,019.80 63,929.62
173,154.24 (173,154.24) (9,167.87) 169,252.67 (178,420.54)
173,154~24 (173,154.24) (9,167.87) 169,252.67 (178,420.54)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 10/31/2003
INTERNAL SERVICE FUNDS
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
145,333.00 33,799.29 111,533.71 209,125.89
1,590,277.00 398,647.26 1.191,629.74 1.326,711.49
21.000.00 21,000.00 24,360.53
1,756,610.00
432,446.55 1,324,163.45 1.560,197.91
440,245.82
440,245.82
209,125.89
886,465.67
24,360.53
1,119,952.09
**************************
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
230,555.99 1,253,596.01 2,344,963.06
230.555.99 1,253,596.01 2,344,963.06
64,285.00 57,775.63
64,285.00 57,775.63
375,090.70
375,090.70
1,969,872.36
1,969,872.36
57,775.63
57,775.63
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE
1,548,437.00 230,555.99 1,317,881.01 2,402,738.69
(208,173.00) (201,890.56) (6,282.44) 842,540.78
(208,173.00) (201,890.56) (6,282.44) 842,540.78
375,090.70
(65,155.12)
65,155.12)
2,027,647.99
907,695.90
907,695.90
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 10/31/2003
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
************************
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
***************************
GENE~L GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
FINANCE
ACTIVITY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENTPROJECTS:
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.O0
(20.00)
20.00
20.00
20,00
20.00
(20.00)
EXCESS <REVENUE>EXPENDITURE 20.00 20.00 20.00 (20.00)