HomeMy WebLinkAboutItem 4.09 FinancialRptJuly-Sept
CITY CLERK
File # D[2]~[Q]-[5]~
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: November 6, 2007
SUBJECT:
Financial Reports for the Month of July, August, & September 2007
Report Prepared by: Paul S. Rankin, Administrative Services fh;A.,.
Director and Vivian Gong, Finance Manager
ATTACHMENTS:
1.
Period Ending July 31, 2007
a. YTD (Year T 0 Date) Revenues and Budget
Comparison
b. YTD Expenditures and Budget Comparison
c. July 31, 2007 Financial Statements
2. Period Ending August 31, 2007
a. YTD (Year To Date) Revenues and Budget
Comparison
b. YTD Expenditures and Budget Comparison
c. August 31, 2007 Financial Statements
RECOMMENDATION: ~
FINANCIAL STATEM~:
Period Ending September 30, 2007
a. YTD (Year To Date) Revenues and Budget
Comparison
/7 ri b. YTD Expenditures and Budget Comparison
"VI" c. September 30, 2007 Financial Statements
Receive the reports.
3.
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report on the preliminary financial statements for the months
of July, August, and September 2007. Due to Staff resources required for audit tasks, there was a delay in
presenting the monthly financial statements. Therefore, . three months of financial reports are being
presented in a combined Staff Report. At this time the presentation of the Balance Sheet reports are
"Preliminary," since the results of changes to the fund balance from the close of 2006/2007 have not been
brought forward. These will be reflected in the October 2007 reports which will be presented at a future
meeting.
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. The analysis offered in this Agenda Report
will also focus on the September data which is the most recent information available.
Analvsis of September 2007 Revenue and Expenditure Reports
The September reports represent the reporting of revenues and expenditures for first quarter of the Fiscal
Year, (July 1, 2007 - through September 30, 2007). It should also be noted that there is not an even
distribution of revenues and expenditures on a monthly basis. There is also a lag with the reporting of
-------------------------------------------------------------------------------------------------------------
COPIES TO:
Page 10f3
G:\Monthly Financials\FY 07-08\JuIAugSept2007.doc
ITEM NO.
'-I. 9
C/
expenditures due to the significant amount of services provided to the City by outside independent
contractors, including Police and Fire Services. 'Some services are billed on a quarterly basis and
therefore, no expenditures may have been reported.
General Fund Revenues
Total General Fund ,Revenues collected through September are less, based upon the percentage collected,
to what occurred through the same period of the previous Fiscal Year. Through September 2007, the City
had collected approximately 7% of the total budgeted General Fund Revenues, which was 5% less than
the percentage collected in the same period of the prior Fiscal Year. There are deviations in terms of
dollars collected in several categories and the following summarizes some of the more significant
deviations compared to the same reporting period in the prior year. It is important to note that some of the
deviations are the result of changes.in timing or reporting changes to accommodate audit requirements.
Summary of Significant General Fund Revenue Differences
For Amounts Collected July - September 2007 vs. July - September 2006
REVENUE YTD YTD , DIFFERENCE
September September FY 07/08 More / EXPLANATION
2007 2006 (Less) FY 06-07
Property Tax $ 749,251 ($ 749,251) This variance is due to timing. In
the prior year the City recorded its
first Property Tax payment in
September. However in FY07-08,
the County Auditor disbursed the
payment in October. The amount
received was $826,000.
Sales Tax $ 1,049,911 $2,222,751 ($ 1,172839) The difference is distorted due to a
required change in the accounting'
for year end payments. If the Sept
2006 amount had been presented on
the same basis as the current year,
the amount for 2006 would have
been $850,842. Accounting for this
adjustment would result in a
positive variance of$199,069.
Licenses & $ 537,375 $1,236,300 ($689,925) This largely reflects the decline in
Permits building permit activity which was
a trend that was expected with the
2007/2008 adopted budget.
Charges For $ 1,249,559 $1,214,028 $ 35,530 An small increases primarily in the
Services Zoning and Subdivision Fees and in
the Plan checking and Inspection
Fees occurred.
Other $ 34,182 $ 79,930 ($45,748) The variance is primarily due to a
Revenues correction in the. revenue grouping.
In prior years, State Mandated Cost
Reimbursements were recorded as
General Reimbursement. In FY
2007/08 they have been reclassified
as Intergovernmental Revenues.
Page 2 of3
General Fund Expenditures
Overall, through the month of September, expenditures in the General Fund totaled approximately $4.7
million and represented approximately 9% of the total budgeted expenditures in the General Fund. Of this
amount, a total of approximately $345,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.
A closer examination of only General Fund Operating Expenditures indicates that the activity through .
September 2007 was only slightly lower ($38,000) than the amounts expended for the same period in the
prior Fiscal Year. Through the end of September 2007, the City had expended 9% of the General Fund
Operating Budget, which is 1 % less than the percentage expended in the first three months of the prior
Fiscal Year. On a percentage basis there is a significant variance in the Health and Welfare expenditure.
This was attributable to the timing of the disbursement of funding to Child Care Links as a lump sum
payment in the first quarter.
All expenditures 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.
Page 3 of3
L. City of Dublin 2007-2008 YTD Revenues and Budget Comparison
For the Period Ending July 31, 2007
2%
I Total General Fund Revenues 2%
I
Property Taxes 00/0
0%
Sales Taxes )%
11114%
Real Property Transfer Tax 0%
0%
Transient Occupancy Taxes 0%
0%
Franchise Taxes 8~
Licenses and Permits
Interest and Rentals
Intergovernmental from State .,0%
%2%
Charges for Services
Fines and Forfeitures
Other Revenues
0% 30%
60%
90%
8% of Year Complete
FY 2007/08 FY 2007/08 %of
Budget YTD Actual Budget
Property Taxes 22,194,200 0 0%
Sales Taxes 14,840,000 261,411 2%
Real Property Transfer Tax 540,000 0 0%
Transient Occupancy Taxes 775,000 0 0%
Franchise Taxes , . 2,095,635. 0 0%
Licenses and Permits 2,306,445 251,020 11%
Interest and Rentals 2,964,212 110,211 4%
Intergovernmental 672,876 3,083 0%
Charges for Services 6,337,596 360,616 6%
Fines and Forfeitures 143,000 7,890 6%
Other Revenues 1,338,678 5,546 0%
Total General Fund Revenues 54,207,642 999,777 2%
Dale Printed: 10/2512007 1:45 PM
120%
150%
,~, 31
i
!
I
I
1
i
I
I
I
i
I
!
.1
I
1
I
-~-~---l i
. FY 2007/08 i i
I~FY 2006/071 i
I
I
---------'
FY 2006/07
YTD Actual
(-
o
549,897
o
o
o
229,613
73,095
22,667
216,795
5,220
5,276
1,102,56;3
% of Total for
FY 2006/07
0%
4%
0%
0%
0%
9%
2%
2%
3%
4%
1%
2%
\\-/..p-Dl if,'7
ATTACHMENT1a
r--~-~--
I
I
~-~1J31
City of Dublin 2007-2008 YTD Expenses and Budget Comparison
For the Period Ending July 31, 2007
Total General Fund -~2to c
Expenses // 3 Yo
~~1~----1-~-~l
. i I
!
General Government
Police 1 ~ %
0%
Fire
0%
0%
Other Public Safety
1%
1%
. FY 2007/08
FY 2006/07
Transportation
46%
Health and Welfare.
Culture & Community
Services
Community
Deveiopment
Capital Improv.
Projects
0%
20%
40%
60%
80%
100%
120%
8% of Year Complete
----
2007/08 2007/08 %of FY 2006/07 % of Total for
Budget YTD Actual Budget YTD Actual FY 2006/07
General Government 5,845,305 459,311 8% 470,216 9%
Police 12,554,821 76,402 1% 44,848 0%
Fire 9,558,930 27,164 0% 28,552 0%
Other Public Safety 565,259 2,875 1% 2,456 1%
Transportation 2,239,419 53,487 2% 46,208 2%
Health and Welfare 35,413 1 ,490 4% 18,500 46%
Culture and Community Services 7,408,783 241,787 3% 283,937 4%
Community Development 8,652,745 239,859 3% 291,599 4%
Capital Improvement Projects 8,173,401 28,897 0% 96,338 3%
Total General Fund Expenses 55,034,076 1,131,272 2% 1,282,654 3%
General Fund Operating Expenses 46,860,675 1,102,375 2% 1,186,316 3%
Dale Printed: l0f2512007 1:45 PM
ATTACHMENT 2b
3 ~3Ci
. CITY OF DUBLIN'S
PROFORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF J1JL Y 2007
Prepared by
The Finance Depaliment
October 25, 2007
ATTACHMENT lcc_
L1VV::' ~
CITY OF DU[~LIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Ju12007
GENERAL
REVENUE
FUNDS
SPECIAL
REVENUE
FUNDS
SPECIAL
ASSESSMENT
FUNDS
CAPITAL
IMPROVEMENT
FUNDS
mUST/
AGENCY
FUND
T () TAL S
---MEMORANDUM ONLY---
CURRENT PRIOR
ASSETS
CASH (49,730,709) 4,339,469 617 ,490 36.593.337 220,189 (7 .960,224) (9,664,310)
CASH WITH FISCAL AGENT 172,5:i5 172 , 555 181,893
AMOUNT HELD IN ESCROW 242,262 242,262 1. 762,000
INVESTMENTS AT COST 108,294.211 108,294.211 106,566,435
RECEIVABLES. TAXES
,1\CCOUNTS 2.542,855 292.828 4.496 20,526 2.860.705 2,531. 742
INTEREST 573.106 57:3.106 671,287
ASSESSMENTS
DUE FROM OTHERS 5,361.516 5,361,516 1 ,965 , ~)()l
INVENTORY AT COST
PREPAID ITEMS '.10,872 10.872 2,190
FIXED ASSETS
LOANS RECEIVABLE 6,758.930 6,758,930 8,345,396
AHOUNT TO BE PROVIDED 943,500 943,500 1,083,500
TOTAL ASSETS 67,051.851 4,632,298 621,986 43,615,054 1. 336,244 117.257,433 113 445,631
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
(824.700)
06.778)
(682,825)
(7.335,962)
06,860)
o , 083 , 171)
(841. 559)
0,099.949)
(682,825)
(7,856,987)
(749,468)
(659,837)
(2,338,982)
(6.683,266)
(297.7%)
(82,683) (140,547)
(9,733,245)
(297,795)
(4.334,503)
(4.334.503)
(82,683) (5,505.674)
(539:303) (38.109.380)
(539,303) (38 109,380)
(275,244){lOO,577.036)
(3 , 958)
(2,304.335)
(2.498.136)
(1,201,000)
(16.438,983 )
(97.006.649)
(97,006,649)
(79,542)
(672.462)
(120.977 )
(1. 791. 762)
(2,473.334)
(79,542)
(2.464,224)
(2.594,311)
(1.061.000) (1.061.000)
(1,061,000) (16,680.397)
(57,318,606)
TOTAL FUND E (57,318,606)
(275.244)(100.577.036)
TOTAL LIABILITIES/EQUITY. (67,051,851) (4,632,298)
(621,986) (43.615,054) (1,336,244)(117.257,433)(113,445,631)
,-
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW'
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
LOANS RECEIVABLE
AMOUNT TO BE PROVIDED
TOTAL ASSETS
LIABILITIES/FUND EQUITY
INTERNAL
SERVICE
FUNDS
6,548,792
2,310 .
3.966
48.656,880
55.211:948
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (229,457)
TOTAL LIABILITIES (252,862)
FUND BALANCES (54,959.086)
TOTAL FUND E (54.959,086)
(23.405)
TOTAL LIABILITIES/EQUITY (55,211.948)
CITY OF DUBLIN
BALANCE, SHEET
FOR THE
PERIOD ENDING 31Ju12007
ENTERPRISE FIXED
FUND (,ROUP OF
ACCOUNTS
351.342.286
351.342.286
(3:)1,342,286)
(3EJ 1. 342 . 286)
l~ENER/iL LClNG
TERM DEBT
,'l,CCOUNT GROUP
61.719,086 .
61. 719,086
(61.719,086)
(61.719,086)
(351,342.286) (61.719.086)
?OO3~
TOTA,LS
- - -f~EMORA,N[)UM- --
CURRENT PRIOR
6.548.792 10.415;459
2.310
3.966
399.999.166
387,888.144
61 .719 , 086
468.273.320
62,320,166
460,623.770
(23,405)
(27,473)
(61,948.543) (62.838.532)
(61,97f.948) (62.866.005)
(406,301.372)(397,757.765)
(406.301,372)(397.757,765)
(468,273.320)(460,623,770)
*******REVENUES*******
PROPERTY TAXES
SALES TAX
REAL PROPERTY TRANilFER 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
'*******E X PE NO I TLIRES*******
GENERAL GOVERNMENT,ACTIVITIES:
C!TY COUNC I L
(=ITY MANAGER
CENTRAL SERVICES
CITY ATTORNEY
.4DMIN SERVICES
BUILDING MANAGEMENT
INSURANCE COST CENTER
ELECTIONS COST CENTER
NON-DEPARTMENTAL
ACT! V !TY TOTAL
PUBLIC SAFETY
POLI C E
CROSSING GUARDS
ANIMAL CONTROL
TRAFFIC SIGNALS & STREET IGHTIN
DISASTER PREPAREDNESS
FIRE SERVICES
ACT! V ITY TOTAL
TRANSPORT A TI ON
PUBLIC WORKS
STREET MAINTENANCE
STREET SWEEPING
STREET TREE MAINTENANCE
STRC:ET LAN DSCfl,PI N(; M.4I NTU~.4N
ACTIVITY TOTAL
HEALTH & ~iELF p,RE
vJfl.STE MANACiE~,EfI!T
CHILD CARE
SOCIAL SERVICES
HOUSING PRCGRAMS
THE CITY OF DUBLIN STAJEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 07/31/2007
(~'EN"R.4L
CURRENT,
BUDGET
22.194.200.00
14.840.000.00
540.000.00
775.000.00
2.095.635.00
2.306.445,,00
143,000.00
2.621.744.00
342.4oll.00
672.876.00
6.337.596.00
1.338.678.00
54.207.642.00
304.891.00
1.128.643.00
549.400.00
615.723.00
1. 840.534.00
785.873.00
538.541. 00
2.500:00
79.20000
5.845.305.00
12.554.821. 00
90.879.00
351.192.00
13.30000
109.888.00
9.558.930.00
22.679.010,00
1.094.76200
33.147.00
138.000.00
106.91700
866.59300
2,239,419,OD
1, .00
18,500.00
15.413.00
'~URRENT
ACTUAL
261. 411. 31
251.019.81
7.889.55'
81.653.67
28.557.19
3, 083 48
360.616.30
5.546.29
999.777.60
10.889.44
64.057.54
20.534.75
2.65945
106.143.87
12,788.50
242.210.00
27.00
459.310.55
76.402.19
2,874,62
27.16421
106.441.02
53.436.69
50.19
R L V E N IJ r
VARIANCE
22.194.200.00
14.578.588.69
540.000.00
775,000.00
2.095.635.00
2.055.425.19
135.11 0 . 45
2.540.090.33
313.910.81
669.792.52
5.976,979.70
1.333.131.71
53.207.864.40
294.001. 56
1. 064 .585.46
528.865.25
613.063.55
1.734.390.13
773.084.50
296,331.00
2.500.00
79.173.00
5,385 .994 .45
12.478.418.81
90.879.00
351.192.00
13.300.
107.013.38
9.531.765.79
22.572.5613,98
1. 041. 325.31
33.147(j()
138.000.00
106.917.Qt}
.54281
, IJ ~i [)
PRIOR
FISCAL YEAR
20,146.742.78
14.135.423.73
596.532.87
800.772.57
2.111.281.26
2.572.067.54
140.234.79
3.575.137.21
198,560.52
1.149.759.30
8.015.064.77.
928.704. 12
54.370.281. 46
320.924.20
1 .042.480.01
438.786.38
867.874.77
1.593.027.81
707.316.31
474.542.39
25.554.79
9.858.11
5.480.364.77
11.662.394.30
86.639.21
251.956.53
15.424.08
79,826.64
9.178,76531
21.27EJ.006.07
907.511.91
13.221. 64
139.992.31
131.391.84
811.550.20
53,486.88 2,185.932.12 2,003.667.90
1,49D,00
10,00
18,500,00
15..413,00
22.(j5~).21
1Ei.500.DO
PRIOR
YTO
549.897.39
229.613.45
5.219.66
68.FO.05
4.325.05
22.667.27
216.794.64
5.276.09
1.102.563.60
17.131.11
59.775.09
18.61193
2.87256
114.550.68
12.968.77
.244.161.00
145.00
470.216.14
44.84824
2.45606
28.EJ51.63
75.85593
46.20829
~t3" .
VAR1AI~CE
20.146.742.78
13.585.526.34
596,532.87
800.772.57
2.111. 281. 26
.2.342 . 454 . 09
135.015.13
3.506.367.16
194.235.47
1.127.092 03
7.798.270.13
923.428.03
53.267.717.86
303.793.09
982.704.92
420.174.45
865.002.21
1.478.477.13
694.347.54
230,381.39
25.409.79
9.858.11
5.010.148.63
11.617 .546.06
86.639.21
251.956.53
15.42408
77.370.58
9.150.213.68
21.199.150.14
861. 303.62
13.221. 64
139.992.31
131.391.84
811. 550.20
46.208.29 1,957,459,61
18.500.00
22,055 21
ACT! V I TY TOTAL
CULTURE & LEISURE SERVICES
tI BRARY SERV ICES
CULTURAL ACTIVITIES
HERITAGE CENTER
DUBLI N CEMETERY
PARK MAINTENANCE
COMMUN!TY TV
RECREATION ADMIN
PLAYGROUNDS
SHANNON CENTER
PRESCHOOL
TEENS PROGRAM
ADULT SPORTS
YOUTH SPORTS
COMMUNITY GYM
EMERALD GLEN ACTI~ITY CENTER
SPECIAL EVENTS
SENIOR CENTER
RECREAT! ON I NSTRUCTI ON
AI)UA T! CS
PARKS/FACILITIES MANAGEMENT
ACT! V ITY TOTAL
COMMUNITY DEVELOPMENT
PLANNII~G
BUILDING SAFETY
ENGINEERING
ECONOMIC DEVELOPMENT
ACT! V I TY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
COMMUN I TY I~1PROVEMENTS
PARK,S
STREET CONSTRC/IMPROVEMENTS
A.cTIVlTY TOTAL
TOTAL EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS I N FROM OTHER FUNDS
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 07/31/2007
G E N t R A L
CUR,RENT
BUDGET
35.413.00
836,571.00
239,530.00
225.052.00
48.458.00
2,008,692.00
75,027.00
759,339.00
296,265.00
286,982.00
115,643.00
146,164.00
183,056,00
204, 177 00
46.187.00
403.471.00
549,653.00
209,545.00
444,888.00
330,083.00
7,408,783.00
2,893,306.00
3,130,274.00
2,337,445.00
291.720.00
8,652.745.00
1. 424.979.00
311. 3=j5. 00
5,443.744,00
993.34300
8.173,401. 00
55.034,076.00
(826 .434 , 00)
(826.434.00)
CURRENT
ACTUAL.
1,490.00
13.913.53
9,916c19
290.64
14,866.50
42.221.16
18.773.69
15,153.42
6,914.81
8,111.81
4,740.51
4,827.20
291.32
14,O~)3.60
21. 441. 84
5,659.33
38,039.10
22,572.38
241.787.03
B9,039.76
45, ~)69. 99
85.191.14
20,058.30
239.859.19
2.220.00
26,677.00
28.897.00
1.131. 271. 67
(131.494.07)
(131. 494 (7)
REV E N L! E
VARIANCE
33,923.00
836,571.00
225,616,47
215.135.81
48.458.00
2,008.401.36
60,160,50
717 , 117 84
277,491,31
271.828,58
108.728.19
138 . 052 . 19
178,315.49
199.349.80
45,895.68
389,417.40
528.211.16
203.885.67
406.848.90
307.510.62
7.166.995.97
2.804,266.24
3.084.704.01
2,252.253.86
271.661.7D
8,412,885.81
1. 424,979 DO
309.115,00
5.417.067 00
993.343.00
8,144.504.00
53,902.804.33
(694.939.93)
(694,939,93)
F L! N D
PR lOF;
FISCAL YEAR
40,555.21
809.628.89
251. 944.51
181,827.65
43,942.65
1. 808 . 688.78
128,881,00
702,189.94
260.228.97
342.407.56
105,844.87
135,910.40
106,532.29
174,520,06
44,662.71
354,952,30
472,926.09
198,529.01
445.981.03
304.996.60
6.874,59531
2,152,18929
2,886,668.83
2.407.540.23
252.49557
7.698.893.92
377.025.76
95,671.93
2.619.196,45
308,244.43
3.400,138.57
46,773,221.75
7 ,597 ,059.71
59,196,81
(23,50565)
7.632.750.87
PRIOR
Y.T.D.
18,500.00
338.49
30.974.55
7,92467
59.466,00
46,322.20
17,47990
15,256.15
4,803.95
8,450.57
4,56088
4,773.81
31.79
8,667.49
18.793.72
7.479.97
31. 295 , 85
17.31653
283.936,52
94.962,00
52,891.26
89.531,72
54,213.98
291.598.96
975,29
.116.03
247.04
96.338.36
1,282.654.20
(180.090.60)
( 18D ,090.60 )
) OO~4
VARIANCE
22,05521
809.290.40
220,969,96
173,902.98
43.942.65
1. 808 ,688.78
69,415.00
655.867.74
242,749.07
327,151. 41
101. 040.92
127.459.83
101. 97f.41
169,746.25
44.630,92
346.284.81
454,132.37
191. 049.04
414.685.18
287,680.07
6,590,658.79
2,057,227,29
2.833.777.57
2,318,008,51
198: 281. 59
7.407,294.96
377 . 025.76
94.696.64
2,524,080.42
307,997.39
3.303,800.21
45.490,567.55
7.777.150.31
59,196.81
(23.505.65)
7,812.E:4147
********REVENUES********
PROPERTY TAXES
SALES TAX/OTHER TAXES
FINES & FORFEITURES
USES/MONEY & PROPERTY
INTERGOVERNMENTAL FROM STATE
INTERGOVERNMENTAL FROM COUNTY
INTERGOVERNMENTAL FROM FEDERAL
CHARGES FOR SERVICES '
OTHER SOURCES OF REVENUE
TOTAL REVENUE
*******EXPENDITURES*******
PUBLIC SAFETY:
POll CE
TRAFFIC SIGNALS & STREET LTG
DISASTER PREPAREDNESS
FIRE SERVICES
ACT! V ITY TOTAL
TRANSPORTATION
STREET MAINTENANCE
STREET LANDSCAPE MAINTENANCE
ACTIVITY TOTAL
HEALTH & WELFARE:
WASTE MANAGEMENT
SOCIAL SERVICES
HOUSING PROGRAMS
ACT! V ITY TOTAL
COMMUNITY DEVELOPMENT:
ENGINEERING
ACT! V ITY TOTAL
C0PITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJtCTS
COMMUNITY PROJECTS
PARKS
STREET CONSTRUCTION/IMPROVEMENT
ACTIVITY TOT,ll.L
TOT A L EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 07/31/2007
~~1
S P E C I A L
CURRENT
BUDllET
125,760.00
.862.00
195,000.00
216.249.00
1.670,059.00
397,023.00
457.70200
1.513,762.00
9,000.00
5,045.417.00
104.810,00
279.525.00
287,483.00
671.818. CiO
398,986.00
6.038.00
405.024.00
1.643,490.00
51.176.00
1.694.666.00
6.000.00
6,00000
10.853.00
62,050.00
1.974,111.00
2.047,014.00
4,824.522.00
220.895.00
REVENLJES OVER (LINDER) EXPENDITURES 22(.895.00
REV E N U E
FUN 0 S
CURRENT
ACTUAL
PR lOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
VARIANCE
125,760.00 119.472.73 119,472.73
460,862.00 433.043.17 433 . 043 . 17
195,000.00 ' 201. 862.59 201.862.59.
5,95982 210.289.18 194.816.32 4,461.39 190.354.93
1.670,059.00 1.172.212.86 1.172,212.86
397.023.00 376,594.90 . 376,594.90
457.702.00 144,868.47 144,868.47
1,513,762.00 1. 430,805.72 1.430.805.72
16,901. 00 (7,901.00) 25.467.40 . 25,467.40
22;860.82 5,022.556.18 4,099.144.16 4.461. 39 4.094.682.77
THE CITY OF DUBLIN STATEMENT SHOVJING
REVENUES VERSUS EXPENDITURES
~t31
FOR THE PER ICiD
07/01/2007 1HROUGH 07/31/2007 .
s P E C I A L ASS E S 'S MEN T F U N,D S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS 785.56700 785.567.00 716.143.96 716.143.96
USES/MONEY & PROP-INTEREST 26,106.00 846.26 25.259.74 26.363.45 703.91 25.659.54
OTHER SOURCES OF REVENUE 5,000.00 578.00 4.422.00 3.219.91 3,219.91
TOTAL REVENUE 816.673.00 1. 424.26 815.248.74 745,727.32 703.91. 745.023.41
*******EXPENDITURES*******
PUBLIC SAFETY.
TRAFFIC SIGNALS & STREET LIG 376.400.00 376.400.00 325.491. 81 325.491. 81
ACTIVITY TOTAL 376.400.00 376.40D.OO 325.491.:31 325.491. 81
TRANSPORTATION
PUBLIC WORKS '100. DO 100.00 1.640.07 0(J r ~~ 1.61141
.:::.0.00
STREET TREE MAINTENANCE 65.910.00 65.910 .00 39.305.46 39.305.46
STREET LANDSCAPE MAINTENANCE 393.67800 393.678.00 369.334.70 369.334.70
ACT! V ITY TOT,l\L 459.688.00 459.688.00 410.280.23 28.66 410.251.57
COMMUNITY DEVELOPMENT
ENl, I NEER I NG 15.500.00 15.500.00 10.558.50 10.558.50
ACTIVITY TOTAL 15.500.00 15,500.00 10.558.50 10.558.50
CAPITAL IMPROVEMENT PROJECTS.
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT
ACT I V ITY TOTAL
TOT A L EXPEND !TURES 851.588.00 851. 588.00 746,330.54 28.66 746.301.88
EXCESS REVENUE (EXPENDITURES) (34.915.00) 1. 424.26 (36,339.26) (603.22) 675.25 (1 . 278 . 47)
REVENUES OVER (UNDER) EXPEND !TURES (34.915.00) 1.424.26 (36,339.26) (603.22) 675.2~J (1.278.47)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
. FOR THE PERIOD
07/01/2007 THROUGH 07/31/2007
\0 'b'3~
CAP I TA L IMP R 0 V E MEN T FUN D S
CURRENT
BUDGET
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
YT.D.
VARIANCE
'H******RE V E N UE ********
USES/MONEY,& PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
1.709.300.00
25.682.181.00
27.391.481.00
50,150.66 1,659.149.34 2.044.630.85
738.140.75 24.944.040.25 8.652.525.77
788.291.41 26.603.189.59 10.697.156.62
44,467.97 2.000,162.88
367.041.00 8.285.484.77
411.508.97 10.285.647.65
*******EXPENDITURES*HH**
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 78.785.62 78.785.62
CITY ATTORNEY 49.400.00 49.400.00 59.936.48 59.936.48
ACTIVITY TOTAL 49.400.00 49.400,00 1.38.722.10 138.72210
PUBLI C SAFETY:
TRANSPORTATION:
HEALTH & ~ELFARE:
HOUSING PROGRAMS 3.994.884.00 14.136.77 3.980.747.23 458.257.23 10.999.46 447.257.77
ACT I V ITY TOTAL 3,994,884.00 14.136.77 3,980,747.23 458.257.23 10.999.46 447.257.77
CUL TURE I~ LEISURE SERVICES:
RECRE.4TION ADMINISTRATImi
ACTIVITY TOTA.L
COMMUN ITY DEVELOP!'IIENT'
PLANNING
ACTIVITY. TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL erp PROJECTS 135.305.00 135,305.00 24.905.17 24.905.17
COt/IMUN ITY IMPROVEMENTS 250.000.00 250,000,00
PARKS 7.876.563.00 11,604.50 7.864.958.50 7.993,41228 30:=,,255.00 7.688.157.28
STREET CONSTRUCTION/IMPROVEMENT 30,104,449.00 2.476.672.11 27.627.776.89 4.497.678.86 321,305.54 4.176.373.32
ACT I V ITY TOTAL 38,366.317.00 2.488,27661 35,878.040.39 12.515.996.31 626.560.54 11 ,889.435.77
T 0 TA L EXPENDITURES 42,410,601. 00 2.502.413.38 39.908.187.62 13,112.975.64 637 .560.00 12,475.415.64
EXCESS REVENUE (EXPENDITURES) (1~.0l9.120.00) (1.714.121.97)(13,304.998.03) (2.415.81902) (226.051. (3) (2.189.767.99)
TRANSFER IN FROM OTHER FUNDS 30.105.65 30.105.65
TRANSFERS OUT TO OTHER FUNDS 39.525.20 39,525.20
REVENLlES OVER (LINDER) EXPENDITLlRES(15,019.120.00) (1.714.121.97)(13,304,998.03) (2.425.2385]) (226,051. 03 ) (2.199,187.:=14)
********REVENUES********
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
ACTI V ITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PRmECTS
f 0 TAL EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
REVENUES OVER (UNDER) EXPENDITURES
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 07/31/2007
T R U S T / AGE N C Y
FUN D
CURRE~iT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
301.76
301.76
217.030.10
14.825.42
5,929.923.59
(301.76)
(301.76)
231,940.00
231. 940.00
301.76
231.94Ci.00 ,
(301.76) 5,697.983.59
301 .} 6
(301.76) 5.697.983.59
PRIOR
Y.T.D.
259.93
259.93
\.\ Ub3~
VARIANCE
217.030.10
14.565.49
5.929.663.66
231.940.00
231.940.00
231,940.00
259.93 5.697,723.66
259.93 5.697.723.66
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 07/31/2007
\ZV03~
N T ERN A L S E R V ICE FUN D S
CURRENT
BUDGET
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
YT.D.
VARIANCE
********REVENUES***H***
USES/MONEY & PROP-INTEREST 214.192.00 8.975.03 205,216.97 477 .640.72 12.613.42 465.027.30
CHARGES FOR SERV ICES 1.682,057.00 88.840'.44 1.593.216.56 1. 786.972.00 118.652.91 1.668.319.09
OTHER SOURCES OF REVENUE 22.800.00 22.809.00 1.475.321.69 1.475.321.69
TOTAL REVENUE 1..919.049.00 97.815.47 1.821.233.53 3.739.93441 131.266.33 3.608.668.08
H*****E XPEND I TURES**'k'H**
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTI V ITY TOTAL
PUBLI C SAF ETY :
FIRE
3.787.454.00
3.787,454.00
30.983.94
30.983.94
3.756.470.06 11.474.930.13
3.756.470.06 11,474.930.13
17.650.34 11.457.279.79
17.650.34 11.457.279.79
. ACTIVITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
3.787.454.00
(1.868.405.00)
30.983.94 3:756.470.06 11.474.930.13
66,831. 53 (1. 935.236.53). (7.734,995 72)
17.650.34 11.457,279.79
113.615.99 (7.848.611.71)
REVENUES OVER (UNDER) EXPENDITURES (1,868.405.00)
66.831.53 (1,935.236.53) (7,734.995.72)
113,615.99 (7,848,611'.71)
'H******RE V E N U ES********.
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
*'^"***'^"*'^"EXPENDI TURES**'^"**'^"*
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACTIVITY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 07/31/2007
E N T E R PR I S E
CURRENT
ACTUAL
VARIANCE
F II N D
PRIOR
FISCAL YEAR
PR IClR
Y.T,D.
\3 Vb 3d1f
VARIANCE
City of Dublin 2007-2008 YTD Revenues and Budget Comparison
For the Period Ending August 31. 2007
Ii! I I
140;(' . I
Total General Fund Revenues .70/0 ! I !
I !
\~31
I
I
I
I
i
Property Taxes i 8~
12%
Sales Taxes ~!!':!!::::!!::!:!!!!:!!1:!112%.
Real Property Transfer Tax ~l%
. FY 2007/08 i
I
FY 2006/07: i
-+-
i
i
I
I
!
I
I
I
i
!
i
. I
i
Transient Occupancy Taxes "'~!!!!! J~.:o
, +
Franchise Taxes '340%0
I
-+-
Licenses and Permits l'i""'!"""!i!!!.I\I:!il< 41 % :
Interest and Rentals rs~;o
-L
i
Intergovernmental from State ~3;~/0
-l
. _15%
Charges for Services 1!!!!11118% .
J_
Fines and Forfeitures.::lOo~o
l:ii""i""i""" 12 Yo
i 20/0
Other Revenues 1~!15%
I
0% 30% 60% 90% 120% 150%
17% of Year Complete
FY 2007/08 FY 2007/08 % of FY 2006/07 % of Total for
Budget YTO Actual Budget YTO Actual FY 2006/07
Property Taxes 22,194,200 0 0% 0 0%
Sales Taxes 14,840,000 261,411 2% 1,647,597 12%
Real Property Transfer Tax 540,000 44,077 8% 0 0%
Transient Occupancy Taxes 775,000 77,369 10% 72,093 9%
Franchise Taxes 2,095,635 87,476 4% 66,773 3%
Licenses and Permits 2,306,445 378,264 16% 1,059,465 41%
Interest and Rentals 2,964,212 225,562 8% 194,451 5%
Intergovernmental 672,876 22,176 3% 52,262 5%
Charges for Services 6,337,596 919,637 15% 658,032 8%
. Fines and Forfeitures 143,000 14,835 10% 16,676 12%
Other Revenues 1,338,678 20,218 2% 49,520 5%
Total General Fund Revenues 54,207,642 2,051,025 4% 3,816,869 7%
Date Printed: 10/25/20072:30 PM
ATTACHMENT 2a
City of Dublin 2007-2008 YTD Expenses and Budget Comparison
For the Period Ending August 31,2007
t~Vb~r.
Total General Fund .5%
Expenses ... 6%
General Government
,
130/0
111111:11111113%
-,
Police I ~~:
11%
Fire ~ 1%
11%
Other Public Safety 12%
. FY 2007/08
Ii FY 2006/07
.6%
Transportation : :1" 5%
Community
Development
46%
Health and Welfare
Culture '& Community
Services
Capital Improv. 11%
Projects 113%
0%
20%
40%
60%
80%
100%
120%
17% of Year Complete
2007/08 2007/08 % of FY 2006/07 % of Total for
Budget YTD Actual Budget YTD Actual FY 2006/07
General Government 5,845,305 788,325 13% 733,961 13%
Police 12,554,821 178,583 1% 164,112 1%
Fire 9,558,930 61,991 1% 60,870 1%
Other Public Safety 565,259 7,865 1% 6,761 2%
Transportation 2,239,419 125,437 6% 98,687 5%
Health and Welfare 35,413 3,471 10% 18,500 46%
Culture and Community Services 7,408,783 687,121 9% 647,203 9%
Community Development 8,652,745 850,215 10% 805,744 10%
Capital Improvement Projects 8,173,401 92,816 1% 102,519 3%
Total General Fund Expenses 55,034,076 2,795,824 5% 2,638,357 6%
General Fund Operating Expenses 46,860,675 2,703,008 6% 2,535,838 6%
Date Prrnted: 10/2512007218 PM
ATTACHMENT 2b
I ft:;1;~
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF AUGUST 2007
Prepared by
The Finance Department
October 25, 2007
A TT ACHMENT 2c
\"1~3~
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Aug2007
GENERAL
REVENUE
FUNDS
SPECIAL SPECIAL CAPITAL TRUST/
REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUNDS FUND
TOT A L S
---MEMORANDUM ONLY-'-
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
(47.351.185) 4.392.044
491.116 36:313.918
254.720
179.340 (5.974.766) (6.387.564)
173.246 173.246 164.500
254.720 1.762.000
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
98.778.718
'98.778.718 108.898.623
1.441.887
619.167
210.424
4.496
1.656.806 2.328,748
619.167 671.287
ASSESSMENTS
DUE FROM OTHERS 5.361.516 5.361.516 1. 901. 086
INVENTORY AT COST
PREPAID ITEMS 7.454 7.454 2.684
FIXED ASSETS
LOANS RECEIVABLE 6.758.930 6.758.930 8.345.396
AMOUNT TO BE PROVIDED 943.500 943.500 1. 083.500
TOTAL ASSETS 58.857.557 4.602.468 495.612 43.327.568 1. 296 , 086 108.579.291 1I8. 770.260
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL (588.395) (16.860) (605.255) (780.374)
DEPOSITS FOR ABI600 FEES (16.778 ) (1,083.171 ) . (1.099.949) (887.998)
DEPOSITS OTHERS (615.876) (615.876) (2.305.026)
PAYABLES: ACCOUNTS (613,054) (173.339 ) (6.275) (52,413) (845.081) (5.400.695)
INTEREST
PAYROLL (139.300 ) (139.300 ) (2.633)
DUE TO OTHERS (66.218) (1. 791. 762) (1. 857.98]) (2.471.242)
DEFERRED REVENUE (1I2.633) ( 2 . 47.3. 334 ) r (2.585.967) (2.504.946)
DEBT INSTRUMENTS PAYABLE (]. 061.1JOO) (1.061.000) (]. 201.lJOO)
TOTAL LIABILITIES (2.152.255) 073.339) (6.275) (5.417.540) (] , 061. 000) (8.810.408) 05.553.914)
FUND BALANCES (56.705,302) (4.429.129) (489.337) (37.910.028) (235.086) (99.768.883)(103.216.346)
TOTAL FUND E (56.705.302) (4.429.129) (489.337) (37.910.028,) (235.086) (99.768,883)(103.216.346)
TOTAL LIABILITIES/EQUITY (5e.857.557) (4,602.468) (495.612) (43.327.568) (1.296.086)(108.579.291)(118.770.260)
\ ~1JfJ ~"
CITY OF DUBLIN
BAL,!I,NCE SHEET
FOR THE
PERIOD ENDING 31Aug2007
I NTERNA.L ENTERPR I SE F I XED ASSETS GE~\jERt\L LON(;
SERVICE FUND GROUP OF TERM DEBT
FUNDS ACCOUrHS l'.CCOUNT GROUP
TOTALS
- - - MEI\~OF(ANDUM - - -
CURRENT PRIOR
ASSETS
CASH 6,588,811 6,588,811 10,565,009
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEI V ABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 3,966 3,966
FIXED ASSETS 48,656,880 351,342,286 399,999,166 387,888,144
LOANS RECEIVABLE
AMOUNT TO BE PROVIDED 61. 719,086 61. 719,086 62.320,166
TOTAL ASSETS 55,249,657 351. 342.286 61,719.086 468,311. 029 460,773,319
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 (229,457)
TOTAL LIABILITIES (229.457)
FUND BALANCES (55,020.200)
TOtAL FUND E (55,020,200)
(61.719,086)
(61.719.086)
(61,948,543) (62,838.532)
(61,948.543) (62,838.532)
(406,362.486)(397,934,787)
(406,362,486)(397,934,787)
(351.342,286)
(351. 342,286)
TOTAL LIABILITIES/EQ~ITY (55,249,657)
(351,342,286) (61,719,086)
(468,311.029)(460,773.319)
*******RE V E N U ES*****''''*
PROPERTY TAXES
SALES TAX
REAL PROPERTY TRANSFER TAX
HOTEL TRANSIENT OCCUPANCY TAX
FRANCHISE TAXES
LI CENSES & PERMITS
FINES & FOR~EITURES
USE/MONEY & PROP-INTEREST
USE/MONEY & PROP-RENTALS
INTERGOVERNMENTAL
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL
CITY IMANAGER
CENTRAL SERVICES
CITY ATTORNEY
ADMIN SERVICES
BUILDING MANAGEMENT
INSURANCE COST CENTER
ELECTIONS COST CENTER
NON~DEPARTMENTAL
ACTI VITY TOTAL
PUBLI C SAFETY
POLICE
CROSSING GUARDS
ANIMAL CONTROL
TRAFFIC SIGNALS & STREET LIGHTIN
DISASTER PREPAREDNESS
FIRE SERVICES
,l1,CTI V ITY TOTAL
TRANSPORTATION
PUBLI C l-JORKS
STREET MAINTENANCE
STREET SWEEPING
STREET TREE MAINTENANCE
STREET LANDSCAPING MAINTENAN
ACTI V ITY TOTAL
HEALTH & WELFARE
WASTE MANAGEIMENT
THE CITY OF DUBLIN '~TATEMENT SHOI.JING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 08/31/2007
G t N E R ,II, L
CURRE:~T
BUDGET
22,194,200,00
14.840,00000
540.000.00
775.000.00
2,095,635,00
2,306.445,00
143,000,00
2,621, 744 00
342,468.00
672,876.00
6,337.596.00
1.338.678.00
54.207,642.00
304,891.00
1.128,643.00
~A9 .400.00
615,723.00
1.840,534.00
785,873.00.
538,541. 00
2,500.00
79,200,00
5.845,305.00
12,554,821,00
90,879,00
351,192.00
13.300,00
109.888.00
9,558.930.00 .
22,679,010.00
1,094,762,00
33,147,00
138.000,00
106,917.00
866,593.00
2,239.419.00
1.500.00
CUIQRENT
ACTU/l.L
261. 411. 31
44,077.28
77 ,368 . 68
87,476.39
378,263.90
14.834.99
167.631.05
57,930.71
22,175,61.
919,636,65
20,218,35
2,051,024.92
38,442.93
149,906.84
62,061,83
5,371,66
235,277 .01
54,075.81
242,308.00
881. 39
788,325.47
178,582,92
448.20
1.057.71
6,359.02
61. 990.70
248,438.55
123,192,50
2,244,05
125.436.55
3,470.58
REV E N U_
VARIANCE
22,194,200.00
14,578.588,69
495,922,72
697,631.32
2,008,158.61
1. 928,181.10
128,165.01
2,454,"112,95
284 ,~)37 . 29
650,700.39
5,417,959,35
1.318,459,65
52,156,617.08
266,448.07
978.736.16
487 . 338 . 17
610.351. 34
1.605.256,99
731,797.19
296,233.00
2.500,00
78,318.61
5,056,979,53
12,376.238,08
90,430,80
351,192.00
12,242.29
103,528.98
9,496,939.30
22,430,57145
971,569.50
33,147,00
138,000.00
106,917.00
864.348.95
2,113.982.45
(1,970. ~)8)
N 0
PRIOR
FISCAL YEAR
20,146.742.78
14,135,423,73
596,532,87
800,772.57
2.111.281.26
2,572 . 067 . 54
140,234.79
3,575.137.21
198.560.52
1,149,759.30
8.015,064 77
928,704,12
54.370.281. 46
320,924,20
!JJ42 , 480,01
438,786.38
867 , 874, 77
1.593,027,81
707.316,31
474,542,39
25,554.79
9 , 858 . 11
5,480,364.77
11 ,662 , 394 , 30
86,639.21
251,956,53
15,42408
79,826.64
9,178.765.31
21,275,006.07
907,511.91
13,221. 64
139,992,31
131,391,84
811. 550.20
2.003,667.90
22.055.21
PRIOR
YT.D
1.647,597.39
72.092.83
66,772.64
1.059,464.81
16,676.17
185,211.34
9.239.43
52,262.34
658.031. 70
49.520.40
3,816,869.05
27,890.59
146,848,48
50,06293
5,745.12
226,862,21
31. 713,43
244,161.00
195.39 .
481. 49
733,960,64
164,111. 72
435,30
6.325.24
60.870.38
231. 742.64
97.818.97
868.40
98.687.37
l q ~:$4?'
VARIANCE
20,146.742.78
12.487,826,34
596,53287
728,67974
2~044,508.62
1.512.602.73
123,558.62
3,389,925.87
189,321. 09 ~
1.097,496.96
7,357,033.07
879.183.72
50.553,412.41
293,03361
895.631.53
388,723.45
862,129.65
1.366,165.60
675,602.88
230,381.39
25.359.40
9.376.62
4.746.404.13
11.498,282,58
86,203.91
251.956.53
15,424,08
73,501.40
9,117 .894.93
21,043,263.43
809,692.94
13,221. 64
139,992.31
131,391,84
810,681.80
'1,904,980.53
22.055.21
CHILD CARE
SOCIAL SERVICES
HOUSING PROGRAMS
ACT! V ITY TOTAL
CULTURE & LEISURE SERVICES
lIBRARY SERVICES
CULTURAL ACTIVITIES
HERITAGE CENTER
DUBL! N CEMETERY
PARK MAINTENANCE
COMMUNITY TV
RECREATION ADMIN
PLAYGROUNDS
SHANNON CENTER
PRESCHQOL
TEENS PROGRAM
ADULT SPORTS
YOUTH SPORTS
COMMUNITY GYM
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS
SENIOR CENTER
RECREATION I NSTRUCTI ON
AQUATI CS
PARKS/FACILITIES MANAGEMENT
ACTI V ITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
BUILDING SAFETY
ENGINEERING
ECONOMIC DEVELOPMENT
ACTI V ITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
COMMUNITY IMPROVEMENTS
PARKS
STREET CONSTRC/IMPROVEMENTS
ACTI V ITY TOTAL
TOTAL EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PER ICID
07/0112007 THROUGH 08/31/2007
l;EI~ER.AL
CURRENT
BUDGET
18,500.00
15,413.00
35,413.00
836,571.00
239.530,00
225,052,00
48,458,00
2,008.692,00
75.027,00
759,339,00
296.265,00
286,982,00
115.643.00
146.164,00
183,056,00
204,177 .00
46.187.00
403,471.00
549,65300
209,545.00
444,888,00
330,083.00
7,408,783.00
2,893,306.00
3,130,274.00
2,337.445,00
291,720.00
8,652,745.00
1.424,979.00
311.335.00
5,443,744.00
993,343.00
8.173,401.00
55,034,076.00
(826.43400)
(826,43400)
CURRENT
ACTUAL
3,470.58
2,259,85
56,04638
36,013.61
10.622.39
14,941.50
100.727,62
49,736.28
45,598.69
14.326,99
20.292.30
13.96578
26,357.43
1.714.45
57,468.12
61.130.87
30.574,19
98,35241
46.991. 75
687,120,61
248,747.33
299,300.68
267,715.17
34,452,09 .
850.215.27
4,230.34
88.130.76
454.81
92,815,91
2,795,822.94
(744,79802)
(744,79802)
~~ E \j E N. U E
VARLl\NCE
18.500.00
15,413,00
31. 942,42
834,311.15
183.483,62
189,038.39
48.458.00
1. 998,069.61
60,085.50
658,611.38
246.528,72
241.383.31
101. 316.01
125,871.70
169,090.22
177 ,819.57
44.472.55
346,002.88
488.522.13
178.970,81
346,535,59
283,091,25
6,721. 662 . 39
2,644.558,67
2,830.973,32
2,069.72983
257,267,91
7.802,529.73
FUN 0
PRIOF;
F I Sc.l\l YEAR
18.500.00
40.555.21
809,628,89
251,944.51
181,827,65
43,942,65
1.808,688.78
128,881.00
702,189.94
260,228.97
342,407.56
105,844.87
135,910.40
106.532,29
174,520.06
44, 662 . 71
354,952.30
472,926.09
198.529.01
445,981.03
304,9%.60
6.874,595.31
2,152.189,29
2,886,668,83
.2.407,540,23
252,495.57
7,698,893.92
1,424,979,00 377,025.76
307,104.66 95:671.93
5.355,613.24 2,619.196,45
992,888,19 308,244.43
8,080,585.09 3.400,138.57
52.238,253,06 46.773,221.75
(81,635.98), 7.597.059.71
59,196.81
(23.505.65)
(81,635,98) 7,632,750.87
PFnOR
YTD.
18.500.00
18.500.00
4,176.24
66.575.20
21,883.64
4,823.07
59,681.00
104.308.79
46,720.74
46,178.05
11 , 002.25
18,642.57
12,126.17
22.685.53
1. 321. 79
31.310.57
51.507,74
22,707.66
73,714,26
47.837.56
647,202.83
233,948.49
273,768,59
217.940,47
80,086.45
B05,744.00
140.00
1.244.67
100,887.34
247.04
102,519,05
2.638.356,53
1.178.512.52
1.178,512.52
~f)13~
VARIANCE
22.055.21
805.452.65
185,369.31
159.944.01
43.942.65
1. 803 , 865.71
69,200.00
597.881.15
213,508.23
296.229.51
94,842.62
117,267.83
94,406.12
151,834.53
43.340.92
323.641. 73
421. 418.35
175,821.35
372 ,266 , 77
257,159.04
6,227,392,48
1.918,240.80
2,612,900.24
2.189 ,~,gg, 76
172,409.12
6,893,14992
376,885.76
94,427.26
2.518,309.11
307,997.39
3,297.619.52
44.134.865,22
6.418,54719
59,1%,81
(23,505.65)
6,454,238.35
THE CITY OF DUBLIN STATEMENT SHOt~ING -z.l~ ~~
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 08/31/2007
~ P E C I A L RE\JEr~UE , UNO S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTl:JAL VARIMCE FISCP.,L YEAR Y.T.D. VARIANCE
********REVENUES********
PROPERTY TAXES 125.760.00 125.760.00 119.472.73 119.472. 73
SALES TAX/OTHER TAXES 460.862.00' 460.862.00 433.043.17 433.043.17
FINES & FORFEITURES 195.000.00 17 .197 .05 177.802.95 201.862.59 18.29513 183.567.46
USES/MONEY & PROPERTY 216.249.00 13.304.67 202.944.33 194.816.32 22.53264 172 . 283 68
INTERGOVERNMENTAL FROM STATE 1. 670.059; 00 86.631.82 1. 583 .427 .18 1.172 .212.86 348.021.03 824.191.83
INTERGOVERNMENTAL FROM COUNTY . 397.023.00 397.023.00 376.594.90 376.594.90
INTERGOVERNMENTAL FROM FEDERAL 457.702.00 457.702.00 144.868.47 144.868.47
CHARGES FOR SERVICES 1.513.762.00 1.513.762.00 1.430.805.72 1.430.805.72
OTHER SOURCES OF REVENUE 9.000.00 16.901. 00 (7.901.00) 25.467.40 25.467.40
TOTAL REVENUE 5.045.417.00 134,034.54 4. 911. 382 .46 4.099.144. 16 388.848.80 3 . 71 0 . 295 . 36
*******EXPENDITURES*******
PUBLIC SAFETY:
POLI CE 104.810.00 104.810.00 101. 780.53 101. 780.53
TRAFFIC SIGNALS & STREET LTG 279.525.00 26.187.95 253.337.05 249.275.06 11.55958 237 . 71~). 48
DISA?TER PREPAREDNESS
FIRE SERVICES 287.483,00 308.33 287.174.67 196.755.84 196.755,.84
ACT! V ITY TOTAL 671,818.00 26.496.28 645,321. 72 547.811.43 11. 559.58 536.251..85
TRANSPORTATION:
STREET MAINTENANCE 398.986.00 398.986.00 305.088.60 10.020.90 295,067.70
STREET LANDSCAPE MAINTENANCE 6.038.00 6.0313.00 7.563.43 7.563.43
ACT! VITY TOTAL 405.024.00 405.024.00 312.652.03 10.020.90 302.631.13
.J
HEALTH & WELFARE: ~
"
WASTE MANAGEMENT 1.643.490.00 9.689.28 1. 633. 1300.72 1.525.606.71 4.952:54 1. 520.654.17
SOCIAL SERVICES 51.176.00 51.176.00 60.035.35 60.035.35
HOUSING, PROGRAMS
ACT! V ITY TOTAL 1. 694.666.00 9.689.28 1.684.976.72 1. 585 ,642.06 4.952.54 1.580.689.52
COMMUNITY DEVELOPMENT:
ENGINEERING 6.000.00 6.000.00 6.000.00 6.000.00
ACT! V ITY TOTAL 6,000.00 6.000.00 6.000.00 6.000.00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 10.853.00 10.853.00
COMMUNITY PROJECTS 17 .580.62 17.580.62
PARKS 62.050.00 62.050.00 132,238.71 132.238.71
STREET CONSTRUCTIONIIMPROVEl1ENT 1. 974 .111. 00 o ,874 .36) 1.975.985.36 726.185.12 6.98333 719.201. 79
ACTI V ITY . TOTAL 2.047.014.00 ( 1. 874 .36) 2.048.888.36 876,004.45 6.983.33 869.021.12
TOT A L EXPENDITURES 4.824..522.00 34.311.20 4.790.210.80 3.328.109.97 33,516,35 3 . 294 . ~m . 62
EXCESS REVENUE (EXPEND ITURES) 220,895.00 99.723.34 121.171.66 771.034.19 355.332.45 415.701.74
TRANSFER IN FROM OTHER FUNDS 0.097.00) 0.09700)
TRANSFERS OUT TO OTHER FUNDS 27.368.61 27.368.61
REVENUES OVER (UNDER) EXPENDITURES 220.895.00 99.723.34 121.171.66 744.762.58 355.332.45 389.430.13
THE CITY OF DUBLIN STATEMENT SHmnNG
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 08/31/2007
~21J3'
" P E C ; " L A " S E ~) S 1"1 E T c: U N [)
:) M J ~
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISC4L YEAF< Y.T.D. V/\RIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS 785.567.00 785.567.00 716.143.96 716,143.96
USES/MONEY (~ PROP-INTEREST 26.106.00 1.687.14 24.418.86 26,363.45 1. 848 .56 24.514.89
OTHER SOURCES OF REVENUE 5.000.00 578.00 4.422.00 3.219.91 3.219.91
TOTAL REVENUE 816.673. 00 2.265.14 814.407.86 745.727.32 1.848.56 743.87876
'H*****EXPEND I TURES*******
PUBLI C SAFETY:
TRAFFIC SIGNALS & STREET LIG 376,400.00 44,624.93 331. 775.07 325,491. 81 19,109.39 306,382.42
ACTI V!TY TOTAL 376.400.00 44,624.93 331. 775.07 325.491. 81 19.109.39 . 306.382.42
TRANSPORTATION
PUBLIC WORKS 100.00 100.00 1. 640 . 07 85.96 1. 554 . 11
STREET TREE MAINTENANCE 65,910.00 516.00 65,394.00 39.305.46 39.305.46
STREET LANDSCAPE MAINTENANCE 393,678.00 3,823.20 389,854.80 369,334.70 20.54 369,314.16
ACTI V!TY TOTAL 459,688.00 4.339.20 455,348.80 410,280.23 106.50 410,173.73
COMMUNITY DEVELOPMENT
ENGINEERING 15,500.00 1. 842 . 64 13.657.36 10,558.50 358.50 10.200.00
ACT! V ITY TOTAL 15,500.00 1. 842 . 64 . 13,657.36 10,558.50 358,50 10.200.00
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT
~ ACT! V ITY TOT,tlL
TOT A L EXPENDITURES 851,588.00 50,806.77 800 781.23 746,330.54 19.574.39 726,756.15
EXCESS REVENUE (EXPENDITURES). (34,915.00) (48,541.63) 13.626.63 (603.22) (17,725.83) 17 ,122.61
REVENUES OVER (UNDER) EXPENDITURES (34,915.00) (48,541.63 ) 13.626.63 (603.22) (17 , 725 . 83 ) 17,122.61
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 08/31/2007
t';~ ~~
CAP I TAL IMP R 0 V E MEN T FUN D
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEfl,R YTD VARIANCE
'H******REV EN U E ***,H***
USES/MONEY 0 PROP-INTEREST 1.709.300.00 110.94743 1. 598 . 352 .57 2.044.630.85 129.299.06 1.915..331.79
"
OTHER SOURCES OF REVEINUE 25.682.181. 00 741.475.75 24,940.705.25 8.652.525.77 5.463.701.11 3.188.824.66
TOTAL REVENUE: 27.391.481.00 852.42318 26,539.057.82 10.697.156.62 5.593.00017 5.104.156.45
*******EXPENDITURES*******
tENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL' 78.785.62 78.78562
CITY ATTORNEY 49.400.00 49.400.00 59.936.48 59.93648
ACTI V ITY TOTAL 49.400.00 49.400.00 138.722.10 138.722.10
PUBLI C SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 3.994'.884.00 40.575.64 3.954.308.36 458.257.23 23.658.40 434.598.83
ACTI V!TY TOTAL 3.994.88400 40.575.64 . 3.954.3013.36 458.257.23 23.658 .40 434.59883
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTI V!TY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTI V!TY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 135.305.00 135.305.00 24.905.17 24.905.17
COMMUNITY IMPROVEMENTS 250,000.00 250.000.00
PARKS 7.876.563.00 224.972.27 7.651.590.73 7.993.412.28 305.255.00 7.688.157.28
STREET CONSTRUCTION/IMPROVEMENT 30.104.449.00 2.500.349.39 27.604.099.61 4.497.67886 797.3::',5.29 3.700.323.57
.~,CTI V!TY TOTAL 38.366.317.00 2.725.321.66 35.640.995.34 12.515.99631 1.102.610.29 11.413.386.02
TOT A L EXPENDITURES 42.410.601. 00 2.765.897.30 39.644.703.70 13.112.975.64 1.126.268.69 11. 986.706 95
EXCESS REVENUE (EXPENDITURES) (15.019.120.00 ) (1.913,474.12)(13.105.645.88)' (2.415.81902) 4.466.731.48 (6.882,550.50)
TRANSFER IN FROM OTHER FUNDS 30.105.65 30.10565
TRANSFERS OUT TO OTHER FUNDS 39.525.20 39.525.20
REVENUES OVER (UNDER) EXPENDITURES(15.019,120.00) (1.913.474.12)(13.105.645.88) (2.425,238.57) 4.466.731.48 (6.891.97005,)
. ,"
********REVENUES********
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
ACTI V I TY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CU~TURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
TOT A L EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
REVENUES OVER (UNDER) EXPENDITURES
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 08/31/2007
T RU S T / AGE N C Y
CURRENT
ACTUAL
1. 298 . 88
1. 298 . 88
41.155 42
41.155.42
41.155.42
(39.856.54)
(39.856.54)
VARIANCE
( 1. 298 . 88)
0.29888)
(41.15542)
(41.155.42)
(41.155.42)
39.85654
F !H1 0
PRIOR
FISCAl YEAR
217.030.10
14.825.42
5',929,923.59
231.940.00
231.940.00
231.940.00
5.697.983.59
39.856.54 5.697.983.59
PRIOR
YT D.
1. 088 . 94
1. 088.94
186.363.75
186.363.75
186.363.75
085.274.8ll
2~~3~
VARIANCE
217.030.10
1:3.736.48
5.928.834.65
45.576.25
45.576.25
45.57625
5.883.258.40
(185.274.81) 5.883.258.40
THE CITY OF DUBLH~ STATEMENT SHOWI NG
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROliGH 08/31/2007.
'2.l3'b:;~
N T ERN A L S E R V ICE FUN D S
CURRENT
BUD(;ET
CURRENT
ACTU/\L
VARIANCE
PRIOR
FISc'~L YEAR
PRIOR
YTD.
VAFIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST 214.192.00 19.992.21 194.199.79 477.640.72 34.524.75 443.115.97
CHARGES FOR SERVICES 1. 682.057.00 181.322.17 1. 500.734 83 1.786.972.00 296.202.50 1.490.769.50
OTHER SOURCES OF REVENUE 22.800.00 250.00 22.550.00 1.475.321.69 1. 475.321. 69
TOTAL REVENUE 1. 919.049.00 201. 564.38 1. 717 .484. 62 3.739.934.41 330.727.25 3.409.207.16
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 3.787.454.00 '- 73.618.99 3.713.835 01 11.474.930 13 40.088.98 11 . 434 . 841 . 15
ACT I V ITY TOTAL 3.787.454.00 73.618.99 3.713.835.01 11.474.930.13 40.088.98 11.434.841.15
PU8LI C SAFETY:
FIRE
ACT I V ITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 3.787.454.00 73.618.99 3.713.835'.01 11.474.930.13 40.088.98 11 .434 .841. 15
EXCESS REVENUE (EXPENDITURES) ( 1. 868 .405 . 00) 127.945.39 (1.996.350.39) (7.734.995 72) 290.638.27 (8.025.633.99)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES (1~868.405.00) 127.945.39 . (1.996,350.39) (7.734.995.72) 290.638.27 (8.025.633.99)
********REVENUES********
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACT! V ITY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 08/31/2007
E N T E R P R I S E
CUR,Q,ENT
ACTUAL
VARIANCE
FUN 0
PRIOR
FISC~L YEAR
Pc)'
KJ
YTD.
VARIANCE
t~dJJ31
City of Dublin 2007-2008 YTD Revenues and Budget Comparison
For the Period Ending September 30, 2007
31
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
. FY 2007/08
FY 2006/07
4800
0%
30%
120%
150%
60%
90%
25% of Year Complete
FY 2007/08 FY 2007/08 %of FY 2006/07 % of Total for
Budget YTD Actual Budget YTD Actual FY 2006/07
Property Taxes 22,194,200 .0 0% 749,251 4%
Sales Taxes 14,840,000 1,049,911 7% 2,222,751 16%
Real Property Transfer Tax 540,000 152,818 28% 141,560 24%
Transient Occupancy Taxes 775,000 165,621 21% 156,519 20%
Franchise Taxes 2,095,635 168,336 8% 160,276 8%
Licenses and Permits 2,306,445 537,375 . 23% 1,236,300 48%
Interest and Rentals 2,964,212 231 ,466 8% 288,211 8%
Intergovernmental 672,876 81,205 12% 98,016 9%
Charges for Services 6,337,596 1,249,559 20% 1,214,028 15%
Fines and Forfeitures 143,000 29,525 21% 28,628 20%
Other Revenues 1,338,678 34,182 3% 79,930 9%
Total General Fund Revenues 54,207,642 3,699,999 7% 6,375,471 12%
Dale Prinled: 10/25120071:45 PM
ATTACHMENT 3a
City of Dublin 2007-2008 YTD Expenses and Budget Comparison
For the Period Ending September 30, 2007
2~~3~
Total General Fund
Expenses
General Government
Police
Fire
Other Public Safety
. FY 2007/08
II FY 2006/07
Transportation
Health and Welfare
46%
4%
6%
0% 20% 40% 60% 80% 100% 120%
25% ~f Year Complete
2007/08 .2007/08 %of FY 2006/07 % of Total for
Budget YTD Actual Budget YTD Actual FY 2006/07
General Government 5,845,305 1,152,812 20% 1,136,081 21%
Police 12,554,821 272,845 2% 282,628 2%
Fire 9,558,930 79,208 1% 111,391 1%
Other Public Safety 565,259 11,913 2% 11 ,450 3%
Transportation 2,239,419 266,105 12% 254,362 13%
Health and Welfare 35,413 8,765 25% 18,500 46%
Culture and Community Services 7,408,783 1,196,037 16% 1,115,227 16%
Community Development 8,652,745 1,393,317 16% 1,489,704 19%
Capital Improvement Projects 8,193,429 344,499 4% 192,904 6%
Total General Fund Expenses 55,054,104 4,725,502 9% 4,612,248 10%
General Fund Operating Expenses 46,860,675 4,381,003 9% 4,419,344 10%
O."le Printed: 10/2512007 2:29 PM
ATTACHMENT 3b
~~~3'4
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF SEPTEMBER 2007
Prepared by
The Finance Department
October 25, 2007
ATTACHMENT 3c
CITY OF DUBLI N 6(lfb ~~
BALANCE SHEET
FOR THE
PERIOD ENDING 30Sep2007
GENERAL SPECIAL SPECIAL CAP IT AL TRUST/ TOT A L S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY---
FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR
ASSETS
CASH (47.003.800) 4 .471 .329 463.577 35.651.539 180.784 (6.236.570) 00.218.719)
CASH WITH FISCAL AGENT 173.924 173.924 164.500
AMOUNT HELD IN ESCROW 254.720 254.720 1. 762.000
INVESTMENTS AT COST 99.657.529 99.657.529 109.207.121
RECEIVABLES: TAXES
ACCOUNTS 627 . 175 58.224 () 685.398 1. 615 .486
INTEREST 656.903 656.903 671.287
ASSESSMENTS
DUE FROM OTHERS 5.361.516 5.361.516 1. 901,086
INVENTORY AT COST
PREPAID ITEMS 8.894 8,894 5.508
FIXED ASSETS
LOANS RECEIVABLE 6.586,880 6.586.880 8,345.396
AMOUNT TO BE PROVIDED 943,500 943.500 1. 083.500
TOTAL ASSETS 59,308.217 4.529.553 463,577 42;852.317 1. 298.208 108.451. 874 114.537.164
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL (776.102) 06.860) 092.962 ) (541. 577)
DEPOSITS FOR AB1600 FEES 08.601) 0.091.370) 0,109.971 ) (907.297)
DEPOSITS OTHERS (543.689) (543.689) (2.323.474)
PAYABLES ACCOUNTS (315,663) (65.768) 001.225) (482,656) (687,312)
INTEREST
PAYROLL 095.949) 095.949) (5.009)
DUE TO OTHERS (66.218) 0.791. 762) 0,857.981) (2,471.242)
DEFERRED REVENUE 017 . 744 ) (2.696.059) (2.813.803) (2,510.633)
DEBT INSTRUMENTS PAYABLE 0.061. 000) 0.061. 000) (1. 201. 000)
TOTAL LIABILITIES (2.033,968) (65,768) (5,697,276) 0,061. 000) (8,858.011) (10.647.545)
FUND BALANCES (57,274,250) (4.463,786) (463,577) (37,155.042) (237.208) (99,593.862)(103.889,620)
TOTAL FUNG E (57,274,250) (4.463,786) (463.577) (37.155.042) (237.208) (99,593.862)(103.889,620)
TOTAL LIABILITIES/EQUITY (59,308,217l (4,529.553) (463.577) (42.852.317l (1.298.208)(108,451,874)(114.537.164)
CITY OF DUBLI N
BALANCE SHEET
FOR THE
PERIOD ENDING 30Sep2007
31~ 31
INTERNAL
SERVICE
FUNDS
ENTERPRISE FIXED ASSETS GENERAL LONG
FUND GROUP OF TERM DEBT
ACCOUNTS ACCOUNT GROUP
TOT A L S
- - -MEMORANDUM- --
CURRENT PRIOR
ASSETS
CASH 6.595,720 6,595.720 10,657.060
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEI VABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 3.966 3,966
FIXED ASSETS 48,289.121 351.342,286 399,631. 407 387,888,144
LOANS RECEIVABLE
AMOUNT TO BE PROVIDED 61. 719,086 61. 719,086 62,320,166
TOTAL ASSETS 54,888,806 351.342,286 61. 719,086 467,950,178 460.865,370
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 (229,457)
TOTAL LIABILITIES (229,457)
FUND BALANCES (54,659,349)
TOTAL FUND E (54,659,349)
(61.719,086)
(61. 719,086)
(61,948.543) (62,838,532)
(61.948,543) (62,838.532)
(406,001,635)(398,026,838)
(406,001,635)(398,026.838)
(351. 342,286)
(351. 342,286)
TOTAL LIABILITIES/EQUITY (54,888,806)
(351,342,286) (61,719,086)
(467,950,178)(460,865,370)
THE CITY OF DUBLIN STATEMENT SHOWING 3tfb .3 ~
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 09/30/2007
G ENE R A L REV E N U E FUN D
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
*******REVENUES*******
PROPERTY TAXES 22.194.200.00 22.194.200.00 20.146.742.78 749.251. 08 19.397.491. 70
SALES TAX 14.840.000.00 1.049.911.31 13.790.088.69 14.025.868.73 2.222.75079 11.803.117.94
REAL PROPERTY TRANSFER TAX 540.000.00 152.818.43 387.181.57 596,532.87 141. 560.22 454.972. 65
HOTEL TRANSIENT OCCUPANCY TAX 775.000.00 165,621.34 609,378.66 800.772.57 156.519.33 644.253.24
FRANCHISE TAXES 2.095.635.00 168.336.15 1. 927 . 298 . 85 2.111. 281. 26 160.276.3~ 1. 951. 004.91
LICENSES & PERMITS 2.306.445.00 537.375.07 1. 769.069.93 2.572.067.54 1.236.300.11 1. 335 . 767 .43
j 111. 606.91
FINES & FORFEITURES 143.000.00 29.524.74 113.475.26 140.234.79 28.627:88
USE/MONEY & PROP-INTEREST 2.621.744.00 159.759.64 2.461. 984.36 3.575.137.21 273.831..42 3.301.305.79
USE/MONEY ,& PROP-RENTALS 342.468.00 71.706.47 270.761.53 203.240.52 14.379:.4.3 188.861.09
INTERGOVERNMENTAL 672.876.00 81.204.91 591. 671. 09 1.149.759.30 98.015.60, 1. 051. 743.70
CHARGES FOR SERVICES 6.337.59600 1.249.558.62 5.088.037.38 8.015.064.77 1.214.028.29 6.801. 036.48
OTHER SOURCES OF REVENUE 1.338.678.00 34.181. 92 1. 304 . 496 . 08 928.704.12 79.930.32 848.773.80
TOTAL REVENUE 54.207.642.00 3.699.998.60 50.507.64340 54.265.406.46 6.375.470.82 47.889.935.64
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 304.891.00 49.921. 58 254.969.42 320.924.20 58.156.85 262.767.35
CITY MANAGER 1.128.643.00 236.199.20 892.443.80 1. 042 .480.01 222.885.12 819.594.89
CENTRAL SERVICES 549.400.00 98.284.22 451.115.78 438.786.38 79,274.38 359,512.00
CITY ATTORNEY 615.723.00 52.282.57 563.440.43 867.874.77 76.07146 791.803.31
ADMIN SERVICES 1.840.534.00 347,664.37 1. 492.869.63 1.593.027.81 351.877.30 1. 241.150.51
BUILDING MANAGEMENT 785.873.00 117.118.14 668.754.86 707.316.31 102.255.55 605.060.76
INSURANCE COST CENTER .541. 00 242.308.00 296.233.00 474.542.39 244.161.00 230.381.39
ELECTIONS COST CENTER 2.500.00 2.500.00 25.55479 394.53 25.160.26
NON-DEPARTMENTAL 79.200.00 9.034.39 70.165.61 9.858.11 1.005.25 8.852.86
ACTIVITY TOTAL 5.845.305.00 1.152.812 47 4.692.492.53 5.480.364.77 1.136.081. 44 4.344.283.33
PUBLIC SAFETY
POLI CE 12.554.821.00 272.845.03 12.281. 975.97 11.662.394.30 282.628.42 11.379.765.88
CROSSING GUARDS 90.879.00 761.94 90.117.06 86.639.21 435.30 86,203.91
ANIMAL CONTROL 351.192.00 351.192.00 251.956.53 251.956.53
TRAFFIC SIGNALS & STREET LIGHTIN 13.300.00 2.118.99 11,181. 01 15.424.08 1. 453. 52 13.970.56
DISASTER PREPAREDNESS 109.888.00 9.032.50 100,855.50 79.826.64 9.560.79 70.265.85
FIRE SERVICES 9.558.930.00 79.208.32 9,479.721.68 9.178,765.31 111. 390. 76 9,067.374.55
ACTI V ITY TOTAL 22,679,010.00 363.966.78 22,315.043.22 21. 275.006.07 405,468.79 20.869,537.28
TRANSPORTATION
PUBLI C WORKS 1.094.762.00 188,969.54 905.792.46 907.511.91 174, 381. 74 733.130.17
STREET MAINTENANCE 33.147.00 33,147.00 13.221. 64 65.05 13.156.59
STREET SWEEPING 138.000.00 11. 072 .18 126,927.82 139.992.31 9,738.20 130.254.11
STREET TREE MAINTENANCE 106.917.00 5,814.90 101.102.10 131. 391. 84 6.681.09 124,710.75
STREET LANDSCAPING MAINTENAN 866.593.00 60.24845 806.344.55 811.550.20 63.496.24 748,053.96
ACTI V ITY TOTAL 2,239.419.00 266.105.07 1.973.313.93 2.003.667.90 254.362.32 1.749.305.58
HEALTH & WELFARE
WASTE MANAGEMENT 1. 500 . 00 7 . 190 . 58 (5,690.58) 22,055.21 22,055.21
CHILD CARE 18.500.00 1.574.30 16,925.70 18.500.00 18.500.00
SOCIAL SERVICES 15,41300 15,413.00
HOUSING PROGRAMS
THE CITY OF DUBLIN STATEMENT SHOWING ~ ~ 1l}'1
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 09/30/2007
G ENE R A L REV E N U E FU N 0
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
ACTI V ITY TOTAL 35.41300 8.764.88 26.648.12 40.555.21 18.500.00 22.055.21
CULTURE & LEISURE SERVICES
L! BRARY SERV ICES 836,571.00 9.515.79 827.055.21 809.628.89 9.952.26 799.676.63
CULTURAL ACTIVITIES 239.530.00 74.575.60 164.954.40 251.944.51 76,649.19 175.295.32
HERITAGE CENTER 225.052.00 51. 308.84 173.743.16 181.827.65 39.837.81 141. 989.84
DUBL! N CEMETERY 48.458.00 2.136.00 46.322.00 43.942.65 3.094.76 40.847.89
PARK MAINTENANCE 2.008.692.00 177 . 137 . 73 1. 831. 554.27 1.808.688.78 127.587.43 1.681.101.35
CClMMUNITY TV 75.027.00 - 14.941.50 60.085.50 128,881. 00 59.681. 00 69.200.00
RECREATION ADMIN 759.339.00 156.331. 85 603,007.15 702.189.94 157.074.73 545,115.21
PLAYGROUNDS 296.265.00 68.422.94 227.842.06 260.228.97 61. 921. 22 198.307.75
SHANNON CENTER 286.982.00 64.901.31 222.080.69 342.407.56 72.032.98 270.374.58
PRESCHOOL 115.643.00 22.591.12 93.051.88 105.844.87 18.887.72 86.957.15
TEENS PROGRAM 146.164.00 29,988.85 116.175.15 135.910.40 30.251.13 105.659.27
ADULT SPORTS 183.056.00 21. 914.33 161.141.67 106.532.29 20.259.26 86.273.03
YOUTH SPORTS 204.177 .00 40.869.98 163.307.02 174.520.06 40.894.50 133.625.56
COMMUNITY GYM 46.187.00 3.725.24 42.461. 76 44.662 . 71 1.799.78 42,862.93
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS 403.471.00 104.608.63 298.862.37 354.952.30 79,875.88 275.076.42
SENIOR CENTER 549.653.00 95.046.24 454.606.76 472.926.09 91.155.37 381.770.72
RECREATION INSTRUCTION 209.545.00 41. 366.95 168,178.05 198.529.01 35.671.85 162.857.16
AQUATICS 444.888.00 146,908.61 297.979.39 445.981. 03 118.551. 07 327.429.96
PARKS/FACILITIES MANAGEMENT 330.083.00 69.745.53 260.337.47 304.996.60 70.049.31 234,947.29
ACTI V ITY TOTAL 7.408.783.00 1.196.037.04 6.212.745.96 6.874.595.31 1.115.227.25 5.759.368.06
COMMUNITY DEVELOPMENT '
PLANNING 2.893.306.00 399.157.05 2.494.148.95 2 . 152.189. 29 394,655.58 1. 757 .533.71
BUILDING SAFETY 3.130.274.00 561.354.07 2.568.919.93 2.886.668.83 548.008.78 2.338.660.05
ENGINEERING 2.337.44500 384.231. 96 1. 953.213.04 2.407.540.23 453.803.28 1. 953 . 736 .95
ECONOMIC DEVELOPMENT 291.720.00 48,573.49 243.146.51 252.495.57 93.236.16 159.259.41
ACTIVITY TOTAL 8.652.745.00 1.393.316.57 7.259.428.43 7.698,893.92 1.489,703.80 6.209.190.12
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 1. 427.764.00 5.539.70 1. 422 . 224.30 377 . 025.76 (2 . 329 . 57) 379.355.33
COMMUNITY IMPROVEMENTS 328.578.00 7.437.72 321.140.28 95.671.93 1. 297.90 94.374.03
PARKS 5.443.744.00 331. 066.63 5.112.677 .37 2.619.196.45 189.431.90 2.429.764.55
STREET CONSTRC/IMPROVEMENTS 993.34300 454.81 992.888.19 308.244.43 4.504.04 303.740.39
ACTI V ITY TOTAL 8.193.429.00 344.498.86 7.848.930.14 3.400.138.57 192.904.27 3,207.234.30
TOTAL EXPENDITURES 55.054.104.00 4.725.501.67 50.328.602.33 46.773.221.75 4.612.247.87 42.160.973.88
EXCESS REVENUE (EXPENDITURES) (846.462.00) (1. 025.503.07) 179.041. 07 7.492.184.71 1.763.222.95 5,728.961. 76
TRANSFERS IN FROM OTHER FUNDS 59.196.81 59.196.81
TRANSFERS OUT FROM OTHER FUNDS (23.505.65) (23.505.65)
REVENUES OVER(UNDER) EXPENDITURES (846.462.00) (1.025.503.07) 179,041. 07 7.527.875.87 1. 763.222.95 5.764.652.92
THE CITY OF DUBLIN STATEMENT SHOWING ~ r{'b3Q
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 09/30/2007
SPECIAL REVENUE FUN D S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
PROPERTY TAXES 125.760.00 286.76 125.473.24 119.472.73 119.472.73
SALES TAX/OTHER TAXES 460,862.00 460.862.00 433 . 043 . 17 41. 994.18 391,048.99
FINES & FORFEITURES 195.000.00 ' 32.099.49 162.900.51 201,862.59 36.080.91 165,781.68
USES/MONEY & PROPERTY 216,2.49.00 17,019;28 . 199,229.72 194,816.32 25,501. 87 169,314.45
INTERGOVERNMENTAL FROM STATE 1. 670,059 00 161.740.78 1.508.318.22 1.17 4.710.84 .416,916.82 757,794.02
INTERGOVERNMENTAL FROM COUNTY 397,023.00 397.023.00 376.594.90 376,594.90
INTERGOVERNMENTAL FROM FEDERAL 457,702.0IJ 457.7IJ2.00 144.868.47 144,868.47
CHARGES FOR SERVICES 1.513.762.00 4,327.42 1.5!J9.434.58 1.43!J.805.72 1.430,805.72
OTHER SOURCES OF REVENUE 9,000.00 16,901.00 (7.901.(10 ) 25.467.40 25.467.40
TOTAL REVENUE :, . 045 , 417 . [10 232.374.73 4,813,04227 4,101. 64214 520,493.78. 3,581.148 36
/
*******EXPENDITURES*******
PUBLIC SAFETY:
POll CE 104,810.00 50.00 104,760.00 101. 780.53 101. 780.53
TRAFFIC SIGNALS & STREET LTG 279,525.00 30.570.50 248,954.50 249.275.06 52,337.38 196,937.68
DISASTER PREPAREDNESS
FIRE SERVICES 287.483.00 616.66 286.866.34 196,755.84 196,755.84
ACTIVITY TOTAL 671,818 00 31.237.16 640. :,80 . 84 547.811.43 52.33738 495,474.05
TRANSPORTATION:
STREET MAINTENANCE 398.986.00 15.404.37 383.581.63 305,088.60 17,359.81 287.728.79
STREET LANDSCAPE MAINTENANCE 6,03800 6,!J38.00 7 .563 .43 7 ,563.43
ACT! V I TY TOTAL 405.024.00 1~),404.37 389,619.63 312,652.03 17,359.81 295,292.22
HEALTH & WELFARE:
WASTE MANAGEMENT 1. 643 ,490.00 14,67100 1.628,819.00 1.525,606.71 9,470.74 1.516,135.97
SOCIAL SERVICES 51.176.00 1. 768.65 49,407.35 60,035.35 406.12 59,629.23
HOUSING PROGRAMS
ACT! V ITY TOTAL 1.694.666.00 16,439.65 1.678,226.35 1. 585 , 642 . 06 9,876.86 1.575,765.20
COMMUNITY DEVELOPMENT:
ENGINEERING 6.000.00 6,000.00 6,000.00 6,000.00
ACTIVITY TOTAL 6,00000 6,000.00 6,000.00 6,000.00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 10.85300 10.853.00
COMMUN ITY PROJECTS 17.580.62 17.580.62
PARKS 62,050.00 62.050.00 132.238.71 132.238.71
STREET CONSTRUCTION/IMPROVEMENT 1. 974.111 .00 37.411.95 1.936,699.05 726,185.12 12,352.09 713.833.03
ACT! V ITY TOTAL 2.047,014.00 37,41195 2,009,602.05 876,004.45 12,352.09 863.652.36
TOT A L EXPENDITURES 4,824,52200 100,493.13 4,724,028.87 3,328,109.97 91. 926 .14 3.236,183.83
EXCESS REVENUE (EXPENDITURES) 220.895.00 131,881.60 89,013.40 77 3 , 532 . 17 428.567.64 344,964.53
TRANSFER IN FROM OTHER FUNDS (1 .097.00) (1,097.00 )
TRANSFERS OUT TO OTHER FUNDS 27,368.61 27,368.61
REVENUES OVER (UNDER) EXPENDITURES 220.895.00 131.881.60 ' 89,013 .40 747,260.56 428,567.64 318,692.92
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 09/30/2007
?;6~31
S P E C I A L ASS E SSM E N T FUN D S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS 785.567.00 2.018.00 783.549.00 716.143.96 716.143.96
USES/MONEY & PROP-INTEREST 26.106.00 2.040.23 24.065.77 26.363 .45 2.09824 .24.265.21
OTHER SOURCES OF REVENUE 5.00000 578.00 4.422.00 3.219.91 3.219.91
TOTAL REVENUE 816.673.00 4.636.23 812.036.77 745.727.32 2.09824 743.629.08
*******EXPENDITURES*******
PUBLI C SAF ETY
TRAFFIC SIGNALS & STREET LIG 376.400.00 45.824.93 330.575.07 325.491. 81 58.741. 29 266.750.52
ACT! V!TY TOTAL 376.400.00 45.824.93 330.575.07 325.491.81 58.741. 29 266.750.52
TRANSPORT A T! ON
PUBLIC WORKS 100.00 100.00 1. 640 .07 257.86 1. 382 . 21
STREET TREE MAINTENANCE 65.9lCi.00 2 . 045 . 15 63.864.85 39.305.46 2.394.70 36.910.76
STREET LANDSCAPE MAINTENANCE 393.67800 27.97538 365.702.62 369.334.70 30.171.39 339.163.31
ACT! V!TY TOTAL 459,688.00 30.020 . ~J3 429.667.47 410.280.23 32.823.95 377.456.28
COMMUNITY DEVELOPMENT
ENGINEERING 15.500.00 3.092.65 12.407.35 10.558.50 358.50 10.200.00
ACT! V!TY TOTAL 15.500.00 3.092.65 12.407.35 10,558.50 358.50 10.200.00
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT
ACT! V!TY TOTAL
TOT A L EXPENDITURES 851.588.00 78.938.11 772.649.89 746.330.54 91. 923.74 654.406.80
EXCESS REVENUE (EXPENDITURES) (34.915.00) (74 . 301. 88 ) 39.386.88 (60322) (89.825.50) 89.222.28
REVENUES OVER (UNDER) EXPENDITURES (34.915.00) (74 . 301. 88 ) 39.386.88 (603.22) (89.825.50) 89.222.28
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 09/30/2007
310 ~ Y1
CAP I TAL IMP R 0 V E MEN T FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUE********
USES/MONEY & PROP-INTEREST 1. 709.300 00 140.988.98 1. 568.311. 02 2,044,630.85 159,878.03 1. 884 ,752 . 82
OTHER SOURCES OF REVENUE 25.682.181. 00 825.813.97 24, 8~)6 ,367.03 8,652,525.77 5 , 644 . 163.86 3,008,361.91
TOTAL REVENUE: 27.391.481. 00 966.802.95 26.424,678.05 10,697.156.62 5.804.041.89 4,893,114.73
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 78,785.62 78,785.62
CITY ATTORNEY 49,400.00 183.46 49,216.54 59,936.48 4,216.59 55,719.89
ACTI V ITY TOTAL 49.400.00 183.46 49,216.54 138,722.10 4,216.59 134,505.51
PUBLI C SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 3.994.884.00 280.951.72 3.713.932.28 458.257.23 60,293.70 397,963.53
ACTI V ITY TOTAL 3,994,884.00 280,951.72 3.713.932.28 458.257.23 60.293.70 397,963.53
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTI V ITY TOTAL
COMMUNITY DEVELOPMENT
PLANN I Nll
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 135.305.00 135.305.00 24,905.17 12.646.50 12.258.67
COMMUNITY IMPROVEMENTS 250.000.00 250,000.00
PARKS 7.876.563.00 386,946.32 7.489.616.68 7.993,412.28 309.368.11 7,684.044.17
STREET CONSTRUCTION/IMPROVEMENT 30.104,449.00 2.967,182.13 27,137,266.87 4,497,678.86 863,333.06 3,634,345.80
ACTI V I TY TOTAL 38,366,317.00 3,354,128.45 35.012,188.55 12.515,996.31 1.185.347.67 11,330,648.64
TOT A L EXPENDITURES 42,410,601. 00 3.635,263.63 38,775,337.37 13,112,975.64 1.249,857.96 11,863,117.68
EXCESS REVENUE (EXPENDITURES) (15,019.120.00 ) (2.668,460.68)(12.350.659.32) (2,415.819.02) 4,554.183.93 (6,970,002.95)
TRANSFER IN FROM OTHER FUNDS 30.105.65 30.105.65
TRANSFERS OUT TO OTHER FUNDS 39.525.20 39,525.20
REVENUES OVER (UNDER) EXPENDITURES(15.019,120.00) (2,668.460.68)(12,350,659.32) (2,425,238.57) 4,554.183.93 (6.979,422.50)
THE CITY OF DUBLIN STATEMENT SHOWING 31~31
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 09/30/2007
T R U S T / AGE N C Y FUN 0
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
SPECIAL ASSESSMENTS 1.340.50 ( 1. 340 . 50) 217,030.10 217.030.10
USES/MONEY & PROP-INTEREST 2.12269 (2.122.69) 14.825.42 1.064.42 13.761. 00
TOTAL REVENUE 3,463.19 (3.46319) 5,929.923.59 1. 064 .42 5.928.859.17
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 41.197.09 (41.197.09) 231,940.00 186.363.75 45.576.25
ACTIVITY TOTAL 41.197.09 (41.197.09) 231.940.00 186.363.75 45.576.25
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES.
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
TOT A L EXPENDITURES 41.197.09 (41.197'.09) 231.940.00 186.363.75 45.576.25
EXCESS REVENUE (EXPENDITURES) (37.733.90) 37.733.90 5.697.983.59 (185.299.33 ) 5,883.282.92
REVENUES OVER (UNDER) EXPENDITURES (37,733.90) 37:733.90 5.697.983.59 (185 . 299 . 33) 5.883.282.92
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 09/30/2007
3~Db~
N T ERN A L S E R V ICE FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR . Y. T .0. VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST 214,192.00 25,628.09 188,563.91 477 .640.72 42,495.83 435.144.89
CHARGES FOR SERVICES 1.682,057.00 221,756.57 1.460,300.43 1.786,972.00 447,715.01 1. 339 . 256 . 99
OTHER SOURCES OF REVENUE 22.80000 250.00 22,550.00 1.475,321.69 1. 475,321. 69
TOTAL REVENUE 1.919,049.00 247,634.66 1.671,414.34 3,739.934.41 490,210.84 3,249,723.57
*******E X PEND I TURE'S*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 3.787.454.00 112.780.83 3,674,673.17 11,472,708.13 107,521.62 11,365.186.51
ACTI V ITY TOTAL 3.787.454.00 112,780.83 3,674.673.17 11.472,708.13 107.521. 62 11 .365 ,186 . 51
PUBLl C SAFETY
FIRE
ACTI V ITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 3.787,45400 112.780.83 3.674.673.17 11.472,708.13 107,521.62 11.365.186.51
EXCESS REVENUE (EXPEND1TURES) (1.868,405.00) 134.853.83 (2,003.258.83) (7,732,773 72) 382.689.22 (8,115,462.94)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER' (UNDER) EXPENDITURES (1,868.405.00) 134,853.83 (2.003.258.83) (7.732.773.72) 382,689.22 (8,115,462.94 )
********REVENUES********
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACT! V !TY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 09/30/2007
E N T E R P R I S E
FUN 0
CURRENT
ACTUAL
PRIOR
FISCAL YEAR
VARIANCE
PRIOR
Y.T.D.
316b "3;/j
VARIANCE