HomeMy WebLinkAbout4.05 Financial Reports7-03CITY CLERK
File #
AGEN DA STATEMENT
CITY COUNCIL MEETING DATE: September 16, 2003
SUBJECT:
Preliminary Financial Reports For the Months of July and
August 2003
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 July and August 2003
RECOMMENDATION:~eceive 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 July and August. 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, August 2003 Revenue and Expenditure Report
Given that this is only the second 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.
Preliminary. Impacts resulting from Passage of State Budget for Fiscal Year 2003-2004
Although there are bills that remain to be completed before the State Budget for FisCal Year 2003-2004 is
officially adopted, the City has received some preliminary information regarding potential impacts that it
will have on the City's adopted budget for Fiscal Year 2003-2004. Additional information regarding the
State Budget will be presented to Council as a separate report at this Council meeting.
COPIES TO:
G:EVlonthly Financials\FY 03-04\07 and 082003 agenda statement monthly financials.doc
ITEM
General Fund Revenues
Total General Fund Revenues collected through AugUst are comparable to what occurred in tl~e first
month of the previous Fiscal Year. Through August 2003, the City had collected approximately 9% of the
total budgeted General Fund Revenues, which was similar to the percentage collected in the prior Fiscal
Year.
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 fimds 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 two
months of the Fiscal Year.
General Fund Expenditures
Overall, through the month of August expenditures in the General Fdnd totaled $2,052,508 and
represented approximately 5% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $90,440 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 August 2003 was
comparable to the amounts expended for the same period in the prior Fiscal Year. As of August 31, 2003,
the City had expended 6% of the General Fund Operating Budget compared to 7% 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. 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.
2%2-
City of Dublin 2003-2004 YTD Revenues and Budget Comparison
For the Period Ending August 31, 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%
9%
10%
0%
0%
16°)o
16°/
~11%
215°/o
~7%
}0%
~.6~
0%
2O/o
30% 60% 90% 120% 150%
[] FY 2003/04
[] FY 2002/03
17% 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 2003~04
Budget
11,274,729
13,036,000
334,000
719,550
1,414,237
2,025,003
897,550
2,372,900
4,868,788
106,500
551,071
37,600,32~8
FY 2003~04 % of FY 2002~03
YTD Actual Budget YTD Actual
0
2,073,400
36,245
37 700
59 472
537 768
40 052
183 802
376 368
6,105
11,769
3,362,68'1
O% 0
16% 1,923,300
11% 20,141
5% 51,457
4% 62,712
27% 402,915
4% 623,609
8% 347,963
8% 456,752
6% 11,543
2% 4,436
9% 3,904,828
% of Total for
FY 2002~03
0%
16%
5%
7%
4%
17%
30%
16%
10%
9%
1%
10%
ATTACHMENT 1
Date Printed: 9/3/2003 8:50 AM
City of Dublin 2003-2004 YTD Expenses and Budget Comparison
For the Period Ending August 31, 2003
Total General Fund
Expenses
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
O!
1%
13°/
2°/°
2%
3'/o
56°/o
% .
~ ~~ ~0%
~9%
0%
~2%
~0%
~0%
B2%
' h
Capital Improv.
Projects
0% 20% 40% 60% 80% 100%
· FY 2OO3~O4
[] FY 2OO2~O3
17% 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,824,656 546,091 11%
8,601,317 126,118 1%
7,159,187 39,171 1%
351,758 7,208 2%
1,607,102 79,213 5%
31,341 22,027 70%
5,329,601 526,956 10%
6,457,591 615,284 10%
5,434,997 90,440 2%
39,797,550 2,052,508 5%
34,362,553 1,962,068 6%
FY 2002~03
YTD Actual
526,621
116,585
60,554
7,781
81,449
7,539
551,591
536,390
837,165
2,725,675
1,888,510
% of Total for
FY 2002~03
13%
2%
2%
3%
6%
19%
12%
10%
21%
9%
7%
ATTACHMENT 2
Date Printed: 9/3/20O3 8:47 AM
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF AUGUST 2003
Prepared by
The Finance Department
September 3, 2003
ATTACHMENT 3
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 08/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 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
11,274,729.00 11,274,729.00 10,512,579.07 10,512,579.07
13,036,000.00 2,072,400.00 10,962,600.00 12,407.901109 1,923,300.00 10,484,601.09
334,000.00 36,245.25 297,754.75 379,088.81 20,140.70 358,948.11
719,550.00 37,699.87 681,850.13 717,083.07 51,457.34 665,625.73
1,414.237.00 59,472.00 1.354.765.00 1,394,953.26 62,712.00 1,332,241.26
2,025,003.00 537,767.90 1,487,235.10 2,419,950.99 402,914.55 2,017,036.44
106,500.00 6,104.95 100.395.05 128,014.83 11,543.46 116,471.37
751,710.00 5,139.51 746,570.49 1,952,879.65 609,282.78 1,343,596.87
145,840.00 34,912.01 110,927.99 116,835.62 14.326.15 102,509.47
2,372,900.00 183,802.10 2,189.097.90 2,140,597.93 347,963.33 1,792,634.60
4,868,788.00. 376,368.27 4,492,419.73 4,712,525.23 456,752.07 4,255.773.16
551.071.00 11,769.19 539,301.81 408,410.07 4,435.89 403,974.18
37,600,328.00 3,362,681.05 34,237,646.95 37,290,819.62 3,904,828.27 33,385,991.35
229,450.00
823,204.00
364,960.00
646,047.00
1,360,195.00
7t7,595.00
430,405.00
2,800.00
250,000.00
4,824,656.00
8,601,317.00
71,462.00
197,194.00
11,150.00
71,952.00
7,159,187.00
16,112,262.00
694,417.00
10.004.00
145,676.00
118,188.00
638,817.00
1,607,102.00
22,986.47 206,463.53 196,233.20 32,564.65
109,361.63 713,842.37 740.711.89 111,470.25
37,916.36 327.043.64 287,074.07 40,523.36
1,765.30 644,281.70 850,821.87 8,203.07
177,193.49 1,183,001.51 982,207.03 150,082.28
27,255.22 690,339.78 722,736.56 42.205.35
169,588.15 260,816.85 315,606.39 141,546.73
24.70 2,775.30 10,918.84 25.30
250,000.00 19,500.00
546,091.32 4,278,564.68 4,125,809.85 526.620.99
126,118.43 8.475,198.57 6,124,603.81 116,584.67
71,462.00 61.878.80
197,194.00 134,484.93
11,150.00
7,208.03 64,743.97 59,237.80 7,780.57
39,171.34 7,120,015.66 3,749,534.12 60,553.74
172,497.80 15,939,764.20 10.129,739.46 184,918.98
79,190.07 615,226.93 632,469.50 74,756.31
10,004.00 7,927.19
145,676.00 122,569.70
118,188.00 76,662.73
23.38 638,793.62 489,923.78 6,693.07
79,213.45 1,527,888.55 11329,552.90 81,449.38
163.668.55
629,241.64
246,550~71
842,618.80
832,124.75
680,531.21
174,059.66
10,893.54
19,500.00
3,599,188.86
6,008,019.t4
61,878.80
134,484.93
51,457.23
3;688,980.38
9,944,820.48
557,713.19
7,927.19
122,569.70
76,662.73
483,230.71
1,248,103.52
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 08/31/2003
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
WASTE MANAGEMENT 8,691.00 2,000.00 6,691.00 1,798.28 1,539.00 259.28
CHILD CARE 18,500.00 18,500.00 15,000,00 15,000.00
SOCIAL SERVICES 1,000.00 1,000.00 6,000.00 6,000.00
HOUSING PROGRAMS 3,150.00 527.18 2,622.82 17,50t.74 17,501.74
ACTIVITY TOTAL 31,341.00 22,027.18 9,313.82 40,300.02 7,539.00 32,761.02
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 553,662.00 3,624.24 550,037.76 485,204.42 485,204.42
CULTURAL ACTIVITIES' 138,088.00 47,124.38 90,963.62 121,196.83 49,910.80 71.286.03
HERITAGE CENTER 114,188.00 11,437.97 102,750.03 92,789.42 10,993.46 81,795.96
DUBLIN CEMETERY 43,858.00 43,858.00 31,092.26 1,716.53 29,375.73
PARK MAINTENANCE 1,457.804.00 973.90 1,456,830.10 1,185,367.27 22,221.02 1,163,146.25
COMMUNITY TV 64,634.00 55,590.38 9,043.62 76,233.17 54,328.98 21.904.19
RECREATION ADMIN 541,383.00 72,Z92.62 468,590.38 452,273.99 64,830.46 387,443.53
PLAYGROUNDS 281,699.00 48,046.38 233,652.62 230,269.67 44.363.04 185,906.63
SHANNON CENTER 291,253.00 32,058.13 259,194.87 266.837.31 31,293.00 235,544.31
PRESCHOOL 82,383.00 7,846,34 74,536.66 74,354.14 9,735.50 64.618.64
TEENS PROGRAM 111,392.00 13,437.73 97,954.27 100,141.63 16,149.00 83,992.63
ADULT SPORTS 105,034.00 15,696.83 89,337.17 96,542.28 13,257.35 83,284.93
YOUTH SPORTS 113,604.00 11,246.46 102,357.54 93,205.80 t6,528.04 76,677.76
COMMUNITY GYM 41,560.00 1,568.14 39,991.86 45,323.70 2,304.79 43,018.91
SPECIAL EVENTS 361,928.00 29,288.28 332,639.72 356,425.65 41.765.11 314,660.54
SENIOR CENTER 2t9,073.00 25,407.6t 193,665.39 183,985.64 23.561.28 160,424.36
RECREATION INSTRUCTION 190,418.00 35,448.57 154,969.43 153,581.45 30,731.1t 122,850.34
AQUATICS 364,122.00 82,998.37 281,123.63 337,695.64 87,434.12 250,261.52
PARKS/FACILITIES MANAGEMENT 249,479.00 32,369.61 217,109.39 211,108.63 30,467.87 180,640.76
ACTIVITY TOTAL 5,329,601~00 526,955.94 4.802,645.06 4,593.628.90 551,591.46 4,042.037.44
COMMUNITY DEVELOPMENT
PLANNING 2,451,689.00 222,446.10 2,229,242.90 1,763,303.93 191.053.24 1,572,250.69
BUILDING SAFETY 1,824,288.00 126,118.44 1,698,169.56 1,466,394.4! 80,907.51 1,385,486.90
ENGINEERING 1,900~705.00 182,957.28 1,717,747.72 1,829,631.84 176,332.92 1,653,298.92
ECONOMIC DEVELOPMENT 280,909.00 83,762.33 197,146.67 278,981.76 88,096.12 190,885.64
ACTIVITY TOTAL 6.457,591.00 615,284.15 5,842,306.85 5,338,311.94 536,389.79 4,80t.922.15
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 983,660.00 13,298.06 970,361.94 2,392,389.32 827,539.47 1,564,849.85
COMMUNITY IMPROVEMENTS 845,044.00 5,537.49 839,506.51 442,108.93 5,179.45 436,929.48
PARKS 2,869,563.00 62,630.88 2,806,932.12 641,274.57 641,274.57
STREET CONSTRC/IMPROVEMENTS 736,730.00 8,973.75 727,756.25 432.980.84 4,446.0t 428~534.83
ACTIVITY TOTAL 5,434,997.00 90,440.18 5,344,556.82 3,908,753.66 837,164.93 3,071,588.73
TOTAL EXPENDITURES 39,797,550.00 2,052,510.02 37,745,039.98 29,466,096.73 2,725,674.53 26,740,422.20
EXCESS REVENUE (EXPENDITURES) (2,197,222.00) 1,310,17t.03 (3.507.393.03) 7.824,722.89 1.179,153.74 6,645,569.15
TRANSFERS IN FROM OTHER FUNDS 6,600:00 6.600.00
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES (2,197,222.00) 1,310,171.03 (3,507,393.03) 7,831,322.89 1,179,153.74 6,652,169.15
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 08/31/2003
SPECIAL REVENUE FUNDS
CURRENT
BUDGET
CURRENT PRIOR
ACTUAL VARIANCE FISCAL YEAR
PRIOR
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
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
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
108,192.00 102,085.41
333,000.00 350.816'.43
63.89 148,936.11 134,666.76
36,949.00 74,300.20
78,930.04 1,208,080.96 7,104,041.57
282,829.00 217,208.00
1,675,946.00 229.067.77
981,937.00 908,872.79
102,000.00 251,582.51
78.993.93 4,877,870.07 9,372,641.44
168,735.00 206,772.25
6,339.54 183,160.46 142,988.43
500.00 250.079.00 217,619.80
6,839.54 608,974.46 567,380.48
237,579.00 238,621.60
237,579.00 238,621.60
500.00 1.294,825.00 573,456.65
44,935.00 28,427.00
500.00 1,339,760.00 601,883.65
6,000.00 6,000.00
6,000.00 6,000.00
50,000.00
770,167.00 36,200.00
341,928.00 254,440.00
10,749,86 1.868.862.14 3,447,513.76
10,749.86 3,030,957.14 3,738,153.76
23,816.39
46.45
35,000.00
58.862.84
13,860.84
3,014.64
254.88
17,130.36
260.68
260.68
91,332.20
91,332.20
102.085.41
327,000.04
134,620.31
74,300.20
7.104,041.57
217,208.00
194,067.77
908,872.79
251,582.51
9,313,778.60
192,911.41
139,973.79
217,364.92
550,250.12
238.621.60
238,621.60
573,195.97
28,427.00
601,622.97
6,000.00
6,000.00
36,200.00
254,440.00
3.356,181.56
3,646,82t.56
5.241,360.00 18,089.40 51223.270.60 5,152,039.49 108,723.24 5,043,316.25
284,496.00 (60,904.53) 345,400.53 (4,220,601.95) 49,860.40 (4,270,462.35)
3,820,981.40
3,820,981.40
EXCESS <REVENUE> EXPENDITURE 284,496.00 (60,904.53) 345,400.53 (399,620.55) 49.860.40 (449.480.95)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 08/31/2003
SPEC IA_ ASSESS~E NT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
~UNDS
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 498.217.78
13.704.00 13.222.07
100.00 3.900.00 10 598.97
100.00 648.086.00 522 038.82
498.217.78
13,222.07
10,598.97
522.038.82
**************************
PUBLIC SAFETY:
TRAFFIC SIGNAES & STREET LIG
ACTIVITY TOTAL
TRANSP[RTATION
PUBLIC WORKS
STREET TREE MAINTENANCE
STREET _ANDSCAPE MAINTENANCE
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
ENGINEERING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT
ACTIVITY TOTAL
- 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
269.686.00
269,686.00
1,791.00
29.768.00
355.332,0.0
386.892.00
15.250.00
15.250.00
70.8~1~00
70.881.00
14.663.09 255.022.91
14,663,09 255,022.91
134.22 1 656.78
29 768.00
3,742.06 351 590.94
3 876.28 383,015.72
4.380.67 10.869.33
4.380.67 10.869.33
70.881.00
70.881.00
204.363.84
204.363.84
1.393.46
9.437.02
260.845.86
271,676.34
14,565.20
14,565.20
56.000.00
56.000.00
14.787.18
14.787.18
235.58
8,229.14
8,464.72
4 335.84
4 335.84
189.576.66
189.576.66
1.157.88
9,437.02
252 616.72
263 211.62
10 229.36
10.229.36
56.000.00
56.000.00
742.709.00 22.920.04 719.788.96 546,605.38 27.587.74 519.017.64
94.523.00 22,820.04 71.702,96 24.566.56 27.587.74 (3.021.18)
EXCESS <REVENUE>EXPENDITURE 94,523.00 22.820.04 71.702.96 24.566.56 27.587.74 (3.021.18)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 08/31/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 1,041.798.88
19,079,000.00
19,838,951.00 1,041,798.88
1,041,798.88
1,041,798.88
**************************
GENERAL GOVERNMENT ACTIVITIES:
CITY ATTORNEY
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEV<ELOPMENT
PLANNING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
COMMUNITY IMPROVEMENTS
)ARKS
STREET CONSTRUCTION/IMPROVEMENT
ACTIVITY TOTAL
T 0 T A _ EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE
25,200.00
28,800.00
296,415.00
102,875.00
5.372.244.00
16,992,958.00
22.468,077.00
22.793,292.00
2,954.341.00
2,954,341,00
25,200.00 23,902.29
.28,800.00 23.902.29
28,816.92 267,598.08 219,771.73
2,561.31
2,561.31
441,907.95 (339,032.95) 10,032,241.19
123.885.10 5,248.358.90 1,474.670.53
32.337.87 16,960,620.13 10,144.224.18
598.130.92 21,869.946.08 21,651.135.90
626.947.84
626.947.84
626.947.84
22,166.344.16 21,897,371.23
2.327.393.16 20.855.572.35
2.327,393.16 20.855.572.35
17,340.00
376.14
376.14
372,058.23
5t9.11
121 5t8.50
494 095.84
511 811.98
511 811.98
511,811.98
23.902.29
23,902.29
202,431.73
2,185.17
2,185~17
9,660,182.96
1,474,151.42
10.022.705.68
21.157.040.06
21.385.559.25
20.343.760.37
20.343.760.37
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 08/31/2003
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
q
VARIANCE
************************
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
232,373.76
4,944.66
237,318.42
232,373.76
4,944.66
237,318.42
**************************
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
172,998.25 (172,998.25) 232,899.42 170,019.80 62,879.62
172,998.25 (172,998.25) 232,899.42 170,019.80 62,879.62
172,998.25 (172,998.25) 232,899.42 170,019.80 62,879.62
172,998.25 (172,998.25) (4,419.00) 170,019.80 (174,438.80)
172,998.25
172,998.25)
(4,419.00)
170,019.80
(174,438.80)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 08/31/2003
INTERNAL SERVICE FUNDS
CURRENT
BUDGET
CURRENT PRIOR
ACTUAL VARIANCE FISCAL YEAR
PRIOR
Y.T,D.
VARIANCE
************************
USES/MONEY & PROP-INTEREST
CHARGES FOR SERVICES
DTHER SOURCES OF REVENUE
TOTAL REVENUE
145,333.00
1,590,277.00
21,000.00
1.756,610.00
146,924.70
146,924.70
145,333.00 178,599.72
1,443,352.30 1,326,711.49
21,000.00 24,360.53
1,609,685.30 1,529,671.74
219,598.53
219,598.53
178,599.72
1,107,112.96
24,360.53
1,310,073.21
**************************
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 63,833.84 1,420,318.16 858,057.13 202,719.45 655,337.68
1,484,152.00 63,833.84 1,420,318.16 858,057.13 202,719.46 655,337.68
64,285.00
64,285.00
64,285.00 40,560.59
64,285.00 40,560.59
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 63,833.84 1,484,603.16 898,617.72 202,719.45 695,898.27
(208,173.00) (83,090.86) (125,082.14) (631,054.02) (16,879.08) (614,174.94)
EXCESS <REVENUE>EXPENDITURE (208,173.00) (83,090.86) (125,082.14) (631,054.02) (16,879.08) (614,174.94)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07JO1/2OO3THROUGH 08/31/2003
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
************************
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
***************************
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACTIVITY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
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 20.00 20.00
City of Dublin 2003-2004 YTD Revenues and Budget Comparison
For the Period Ending July 31, 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%
4%5%
0%
0%
7O/o
7%
0%
0%
0%
0%
-.~91o2°?o
~o/~
7i-~: 29%
2O/o
30/0
4%
1%
0%
[] FY 2003/04
[[] FY 2002/03
30% 60% 90% 120% 150%
8% 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
FY 2003~04 FY 2003/04
Budget YTD Actual
% of FY 2002~03 % of Total for
Budget YTD Actual FY 2002/03
11,274,729 0 0% 0 0%
13,036,000 888,600 7% 868,000 7%
334,000 0 0% 0 0%
719,550 0 0% 0 0%
1,414,237 0 0% 0 0%
2,025,003 244,739 12% 214,892 9%
897,550 28,309 3% 596,724 29%
2,372,900 126,977 5% 171,349 8%
4,868,788 115,471 2% 149,051 3%
106,500 3,380 3% 5,177 4%
551,071 4,709 1% 594 0%
37,600,328 1,412,185
4% 2,005,787 5%
ATTACHMENT 1
Date Printed: 9t2/2003 9:57 AM
City of Dublin 2003-2004 YTD Expenses and Budget Comparison
For the Period Ending July 31, 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%
2%
Yo
'i%
'1%
O%
~%
'1%
1%
2%
0%
~0%
2'/o
2%
0%
0%
0% 20% 40% 60% 80% 100%
8% of Year Complete
· FY 2003/04
-q FY 2OO2/03
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
Budget YTD Actual
% of
Budget
FY 2002~O3
YTD Actual
4,824,656 111,429 2% 112,502
8,601,317 68,352 1% 42,905
7,159,187 22,986 0% 19,275
351,758 2,164 1% 2,101
1,607,102 23,984 1% 20,682
31,341 0 0% 39
5,329,601 110,995 2% 114,041
6,457,591 !39,101 2% 128,499
5,434,997 1,469 0% 2,634
1%
1%
39,797,550 480,480
34,362,553 479,011
442,678
440,044
% of Totalfor
FY 2002~03
3%
1%
1%
1%
2%
0%
2%
2%
0%
2%
2%
ATTACHMENT 2
Date Printed: 9/Z¢2003 10:26 AM
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF JULY 2003
Prepared by
The Finance Department
September 2, 2003
ATTACHMENT 3
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 07/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 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
11,274,729
13,036 000
334 000.00
719 550.00
1,414 237.00
2,025 003.00
106 500.00
751 710.00
145.840.00
2,372.900.00
4,868,788.00
551,071.00
37,600,328.00
229,450.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,824,656.00
8,601,317.00
71,462.00
197,194.00
11,150.00
71,952.00
7,159,187.00
16,112,262.00
694,417.00
10,004.00
145,676.00
118,188.00
638,817.00
1,607,102.00
.00
.00 888,600.00
244,738.65
3,380.19
28,309.01
126,977.31
115,471.39
4,709.19
1,412,185.74
6,810.27
J0,504.31
10,271.73
462.08
47,155.31
16,225.67
111,429.37
68,352.18
2,164.38
22,986.08
93,502.64
23,983.65
23,983.65
11,274,729.00
12,147,400.00
334,000.00
719,550.00
1,4i4,237.00
1,780,264.35
103,119.81
751,710.00
117,530.99
2,245,922.69
4,753,316.61
546,361.81
36,188,142.26
222,639.73
792,699.69
354,688.27
645,584.92
1,313,039.69
701,369.33
430.405.00
2,800.00
250,000.00
4,713,226.63
8.532,964.82
71,462.00
197,194.00
11,150.00
69,787.62
7.136,200.92
16,018,759.36
670,433.35
10,004.00
145,676.00
118,188.00
638,817.00
1,583,118.35
10,512,579.07
12.407,901.09
379,088.81
717,083.07
1,394,953.26
2,419,950.99
128,014.83
1,952,879.65
116.835.62
2,140,597.93
4,712,525.23
408,364.83
37,290,774.38
196,233.20
740,711.89
287,074.07
850,821.87
982,207.03
722,736.56
315,606.39
10,918.84
19,500.00
4,125,809.85
6.124,603.81
61,878.80
134,484.93
59,237.80
3,749,534.12
10,129,739.46
632,469.50
7,927.19
122,569.70
76,662.73
489,923.78
1,329,552.90
868,000.00
214,892.27
5.177.39
589,306.54
7,417.05
171,349.38
149,050.50
594.42
2,005,787.55
12,410.42
31,830.12
13.703.66
901.70
39.107.04
14,549.05
112,501.99
42,904.74
2,101.07
19,275.02
64,280.83
20,682.44
20,682.44
10,512,579.07
11.539,901.09
379,088.81
717,083.07
1,394.953.26
2,205,058.72
122,837.44
~1,3631573.11
109,418.57
1,969,248~55
4,563,474.73
407.770.41
35,284.986.83
183,822,78
708,881.77
273,370.41
849,920.17
943,099.99
708,187.51
315,606.39
10,918.84
19,500.00
4,013,307.86
6,081,699.07
61,878.80
134,484.93
57,136.73
3,730,259.10
10,065,458.63
611,787.06
7,927.19
122,569.70
76,662.73
489,923.78
1,308,870.46
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 07/31/2003
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
WASTE MANAGEMENT
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
SPECIAL EVENTS
SENIOR CENTER
RECREATION INSTRUCTION
AQUATICS
PARKS/FACILITIES MANAGEMENT
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
BUILDING SAFETY
ENGINEERING
ECONOMIC DEVELOPMENT
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
COMMUNITY IMPROVEMENTS
PARKS
STREET CONSTRC/IMPROVEMENTS
ACTIVITY TOTAL
TOTAL EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES
8,691.00
18,500.00
1,000.00
3,150.00
31,341.00
553 662.00
138 088.00
114 188.00
43 858.00
t,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
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,59i.00
983,660.00
845,044.00
2,869,563.00
736,730.00
5,434,997.00
39,797,550.00
(2,t97,222.00)
(2,197,222.00)
190.52
3,355.91
3,434.65
6.38
20.903.64
13,095.76
8,052.19
2,735.64
3,614.89
2,339.39
2,454.25
77.20
12,171.52
7,454.64
3,027.52
19,278.37
8,802.12
110,994.59
55,013.13
24,122.11
47,253.85
12,712.13
139,101.22
125.00
588.74
51.24
703.85
1,468.83
480,480.30
931,705.44
931,705.44
8,691.00
18,500.00
1,000.00
3,150.00
31,341.00
553,471.48
134,732.09
110,753.35
43,858.00
1,457,804.00
64,627.62
520,479.36
268,603.24
283,200.81
79,647.36
107,777.11
102,694.61
111,149.75
41.482.80
349,756.48
211,618.36
187,390.48
344,843.63
240,676.88
5,218,606.41
2,396,675.87
1,800,165.89
1,853,451.15
268,196.87
6,318,489.78
983,535.00
844,455.26
2,869,511.76
736,026.15
5,433,528.17
39,317,069.70
(3,128,927.44)
(3,128,927.44)
1,798.28
15,000.00
6,000,00
17,501.74
40,300.02
485,204.42
121,196.83
92,789.42
31,092.26
1,185,367.27
76,233.17
452,273.99
230,269.67
266,837~31
74,354.14
t00,141.63
96,542.28
93,205.80
45,323.70
356,425.65
183,985.64
153,581.45
337,695.64
211,108.63
4,593,628.90
1,763,303.93
1,466,394.41
1,829,631.84
278,981.76
5,338,311.94
2,392,389.32
442,108.93
641,274.57
432,980.84
3,908,753.66
29,466.096.73
7.824,677.65
6,600.00
7,831,277.65
39.00
39.00
2,479.49
3,320.20
19.355.66
11,525.92
7,818.75
2,668.97
4,077.25
2,717.73
2,288.58
1,094.61
16,698.36
5,908.3t
3,009.45
22,456.28
8,621.12
114,040.68
49,868.19
24,697.99
47,538.93
6,393.95
128,499.06
1,040.38
136.83
1,457.27
2,634.48
442,678.48
1,563.109.07
1,563,109.07
1,759.28
15,000.00
6,000.00
17,501.74
40,261.02
485,204.42
1t8,717.34
89,469.22
31,092.26
1,185,367.27
76,233.17
432,918.33
218,743.75
259,018.56
71,685.17
96,064.38
93,824.55
90,917.22
44,229.09
339,727.29
178,077.33
150,572.00
315,239.36
202,487.51
4,479,588.22
1,713,435.74
1,441.696:42
1,782,092.91
272,587.81
5,209,812.88
2,391.348.94
441,972.10
641,274.57
431,523.57
3,906,119.18
29,023,418.25
6,261.568.58
6,600.00
6,268,168.58
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 07/31/2003
SPECIAL REVENUE FUNDS
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
T~FFIC 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
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
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
9,450.00
9,450.00
2,083.34
2,083.34
1,835.26
1,835.26
3,918.60
(5,531.40)
108 192.00
333 000.00
149 000.00
36 949.00
1,277 561.00
282 829.00
1,675 946.00
981 937.00
102 000.00
4,947 414.00
168,735.00
187,416.66
250,579.00
613,730.66
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,877,776.74
3,039,871.74
5,237,441.40
290,O27.40
102,085.41
350,816.43
134,666.76
74,300.20
7,104,041.57
217,208.00
229,067.77
908,872.79
251,582.51
9,372.641.44
206,772.25
142,988.43
217,619.80
567,380.48
238,621.60
238,621.60
573,456.65
28,427.0O
601,883.65
6,000.00
6,000.00
36,200.00
254,440.O0
3,447,513.76
3,738,153.76
5,152,039.49
i4,220,601.95)
3,820,981.40
18,347.59
18,347.59
3,340.06
3,340.06
3,340.06
(15,007.53)
102,085.41
332,468.84
134,666.76
74,300.20
7,104,041.57
217,208.00
229,067.77
908,872.79
251,582.51
9,354,293.85
206,772.25
142,988.43
217,619.80
567,380.48
238,621.60
238,621.60
573,456.65
28,427.00
601,883.65
6,000.00
6,000.00
36,200.00
254,440.00
3,444,173.70
3,734,813.70
5.148,699.43
(4,205,594.42)
3,820,981,40
EXCESS <REVENUE> EXPENDITURE 284,496.00 (5,531.40) 290,027.40 (399.620.55) (15,007.53) (384,613.02)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 07/31/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 498,217.78
13,704.00 13,222.07
100.00 3,900.00 10,598.97
100.00 648,086.00 522,038.82
498:217.78
13,222.07
10,598.97
522,038.82
**************************
PUBLIC SAFETY:
T~FFIC 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
EXCESS <REVENUE>EXPENDITURE
269,686.00
269,686.00
1,791.00
29,768.00
355,333.00
386,892.00
15,250.00
15,250.00
70,881.00
70,881.00
742,709.00
94,523.00
94,523.00
(100.00)
(100.00)
269,686.00
269,686.00
1,791.00
29,768.00
355,333.00
386,892.00
15,250.00
15,250.00
70,881.00
70,881.00
742,709.00
94,623.00
94,623.00
204,363.84
204.363.84
1,393.46
9,437.02
260,845.86
271,676.34
14,565.20
14,565.20
56,000.00
56,000.00
546.605.38
24,566.56
24,566.56
1,200.00
1,200.00
90.60
90.60
1,290.60
1,290.60
1,290.60
203,163.84
203,163.84
t,302.86
9,437.02
260,845.86
271,585.74
14,565.20
14,565.20
56.000.00
56.000.00
545,314.78
23,275.96
23,275.96
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 07/31/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,041,798.88
1,041,798.88
1,041,798.88
1,041,798.88
**************************
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
25,200.00
28,800.00
296,415.00
102,875.00
5,372,244.00
16,992,958.00
22,468,077.00
22,793,292.00
2,954,341.00
4,128.08
460.19
884.50
3,337.29
4,681.98
8,810.06
8,810.06
25,200.00
28,800.00
292,286.92
102,414,81
5,371,359.50
16,989,620.71
22,463,395.02
22.784,481.94
2,945,530.94
23,902.29
23,902.29
219,771.73
2,561.31
2,561.31
10,032,241.19
1,474,670.53
10,144,224.18
21,651,135.90
21,897,371.23
20,855,572.35
4,249,54
369,996.88
716.19
370,713.07
374,962.61
374,962.61
23,902.29
23,902.29
215,522.19
2,561.31
2,561.31
9,662,244.31
1,474,670.53
10,143,507.99
21,280,422.83
21,522,408.62
20,480,609.74
EXCESS <REVENUE>EXPENDITURE 2,954,341.00 8,810,06 2,945,530.94 20,855,572.35 374,962.61 20,480,609.74
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 07/31/2003
RUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y,T.D.
VARIANCE
************************
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
232,373.76
4,944.66
237,318.42
232,373.76
4,944.66
237,318.42
**************************
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
232,899.42
232,899.42
232,899.42
(4,419.00)
232,899.42
232,899.42
232,899.42
(4,419.00)
EXCESS <REVENUE>EXPENDITURE (4,419.00) (4,419.00)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 07/31/2003
INTERNAL SERVICE FUNDS
CURRENT
BUDGET
CURRENT PRIOR PRIOR
ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
************************
USES/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
146,924.70
145,333.00 178,599~72
1,443,352.30 1.326,711.49
21,000.00 24,360.53
146,924.70 1,609,685.30 1,529,671.74
109,448.17
109,448.17
178,599.72
1,217,263.32
24,360.53
1,420,223.57
**************************
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 31,676.85 1,452.475.15 858,057.13 21,339.17 836,717.96
1,484,152.00 31,676.85 1,452,475.15 858,057.13 21,339.17 836,717.96
64,285.00
64,285.00
64,285.00 40,560.59
64,285.00 40,560.59
40,560.59
40,560.59
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TP, ANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
1,548,437.00 31,676.85 1,516,760.15 898,617.72 21,339.17 877,278.55
(208,173.00) (115,247.85) (92,925.15) (631,054.02) (88,109.00) (542,945.02)
EXCESS <REVENUE>EXPENDITURE (208,173.00) (115,247.85) (92,925.15) (631,054.02) (88,109.00) (542,945.02)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 07/31/2003
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
************************
USES/MONEY & PROP-INTEREST
TOTAL RE*ENUE
***************************
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 <RE*ENUE>EXPENDITURE
TRANSFERS IN FROM OTHER FUNDS
TP, ANSFERS 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
EXCESS <RE*ENUE>EXPENDITURE 20.00 20.00 20.00 20.00