HomeMy WebLinkAboutItem 4.09 Financial Report March April 07of' 061 CITY CLERK
File # ❑�®E-❑ o1
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: May 15, 2007
SUBJECT: Financial Reports for the Month of March And April 2007
Report Prepared by: Paul S. Rankin, Administrative Services Dir.evr ,
ATTACHMENTS: 1. Period Ending March 31, 2007
a) Year To Date (YTD) Revenues and Budget
Comparison
b) YTD Expenses and Budget Comparison
c) March 31, 2007 Financial Statements
2. Period Ending April 30, 2007
a) Year To Date (YTD) Revenues and Budget
Comparison
b) YTD Expenses and Budget Comparison
11J/ c) April 30, 2007 Financial Statements
RECOMMENDATION. Receive the reports.
FINANCIAL STATEMENT: See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report on the preliminary financial statements for the months
of March 2007 and April 2007. Due to a staffing vacancy two months of reports have been combined in
one Staff Report. 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 April data which is the most recent information available.
Analysis of April 2007 Revenue and Expenditure Reports
The April reports represent the reporting of revenues and expenditures for the first ten months of the
Fiscal Year, through April 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 expenditures due
to the significant amount of services provided to the City by independent contractors, including Police and
Fire Services.
General Fund Revenues
Total General Fund Revenues collected through April are slightly more, based upon the percentage
collected, to what occurred through the first quarter of the previous Fiscal Year. Through April 2007, the
City had collected approximately 81% of the total budgeted General Fund Revenues, which was 1% more
than the percentage collected in the same period of the prior Fiscal Year. This remains unchanged from
the condition reported for the month of February.
Although on a percentage basis the revenues are tracking according to the budget, there are deviations in
terms of dollars collected in several categories. The following summarizes some of the more significant
deviations from the prior year.
------------------------------------------- - - - - -- ---------------------------------------------------- - - - - -- C
COPIES TO: Page 1 of 3
GAMonthly Financials\FY 06- 07 \Mar_Apri12007.doc ITEM NO. 4+
Summary of Significant General Fund Revenue Differences
For Amounts Collected Julv - April 2007 vs July - April 2006
REVENUE
YTD
YTD
DIFFERENCE
April 2007
April 2006
2007 More /
EXPLANATION
Less Than 2006
Property Tax
$15,877,669
$14,899,206
$ 978,463
Increases in assessed values as well
as the elimination of ERAF III.
There is also a timing difference in
the City / County Property Tax
sharing. As reported earlier in the
mid -year report property tax
revenue in 2006/07 is expected to
exceed the budgeted amount.
Sales Tax
$11,396,854
$10,152,862
$1,243,992
The current amount reported is
distorted due to a change in the
final accrual methodology used at
year end. Also, there is a
difference in timing between the
two years. In 2006 the City
received its second in -lieu sales tax
payment in June. In 2007 the
payment was received in April and
totaled $1.853 million. As
previously reported total sales tax is
expected to be below the budget
due to general economic trends and
delays in completion of new retail
outlets.
Real Property
$389,353
$538,104
($148,751)
Fewer real estate transactions in the
Transfer Tax
current year.
Transient
$ 588,194
$ 525,214
$ 62,980
The 2006/07 budget is $42,611
Occupancy Tax
lower than the final revenue
achieved in 2005/06. Current
trends are that there will be
additional growth above what was
achieved last year.
Franchise Taxes
$ 1,625,063
$1,369,062
$256,001
All categories of franchise taxes are
above the level collected in
accordance with the agreements in
2006. (Gas; Electric; Waste; Cable
TV)
Interest & Rentals
$1,955,037
$1,566,318
$388,719
Reflects increase in interest rates
and total funds invested.
Intergovernmental
$ 229,131
$872,731
($643,600)
In 2005 there was a one -time
repayment by the State of funds
borrowed in FY 2003/04.
Other Revenues
$ 871,945
$252,683
$619,262
Increase is largely reimbursements
budgeted for underground project
ands ill related response costs.
Page 2 of 3
General Fund Expenditures
Overall, through the month of April, expenditures in the General Fund totaled approximately $28.7
million and represented approximately 54% of the total budgeted expenditures in the General Fund. Of
this amount, a total of approximately $1,758,358 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 April 2007 was lower than
the amounts expended for the same period in the prior Fiscal Year. Through the end of April 2007, the
City had expended 59% of the General Fund Operating Budget, which is 4% less than the percentage
expended in the first ten months of the prior fiscal year.
This difference is primarily attributable to lower costs incurred in Community Development which reflect
a combination of Staff vacancies and a general slowdown in development activities resulting in lower
expenditures. The 2006/07 Budget also included funding for major planning studies that have not
incurred costs in the first ten months of the year.
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 of 3
City of Dublin 2006 -2007 YTD Revenues and Budget Comparison
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
60%
61%
62 %
1166%
74
°�3 %
63%
63%
40%
■ FY 2006/07
FY 2005/06
0% 30% 60% 90% 120% 150%
75% of Year Complete
Date P,inted 5/412007 10 '59 AM
% of Total for
FY 2005/06
53%
66%
74%
63%
41%
77%
54%
75%
65%
63%
86%
61%
5 - i!5-o-7 `f. �
ATTACHMENT 1(04
FY 2006/07
FY 2006/07
% of
FY 2005106
Budget
YTD Actual
Budget
YTD Actual
Property Taxes
17,470,288
9,307,348
53%
8,882,802
Sales Taxes
15,283,000
9,543,875
62%
9,433,762
Real Property Transfer Tax
712,000
389,353
55%
514,066
Transient Occupancy Taxes
685,000
515,474
75%
459,735
Franchise Taxes
1,921,000
955,872
50%
733,922
Licenses and Permits
2,901,819
2,103,518
72%
2,405,806
Interest and Rentals
2,037,738
1,281,546
63%
848,564
Intergovernmental
1,530,976
199,064
13%
765,550
Charges for Services
6,740,407
5,825,982
86%
3,742,332
Fines and Forfeitures
143,560
90,253
63%
93,705
Other Revenues
1,983,070
788,334
40%
238,023
Total General Fund Revenues
51,408,858
31,000,619
60%
28,118,267
Date P,inted 5/412007 10 '59 AM
% of Total for
FY 2005/06
53%
66%
74%
63%
41%
77%
54%
75%
65%
63%
86%
61%
5 - i!5-o-7 `f. �
ATTACHMENT 1(04
City of Dublin 2006 -2007 YTD Expenses and Budget Comparison
For the Period Ending March 31, 2007
Total General Fund
Exnenses
General Government
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
PAM
■ FY 2006/07
FY 2005/06
0% 20% 40% 60% 80% 100% 120%
75% of Year Complete
Total General Fund Expenses 52,729,586
General Fund Operating Expenses 45,431,418
D- PrinWd. 514QW7 10 '55 AM
2006/07
2006/07
FY 2005/06
Budget
General Government
5,741,378
Police
12,175,438
Fire
9,294,483
Other Public Safety
463,056
Transportation
2,057,857
Health and Welfare
57,575
Culture and Community Services
7,037,361
Community Development
8,604,270
Capital Improvement Projects
7,298,168
Total General Fund Expenses 52,729,586
General Fund Operating Expenses 45,431,418
D- PrinWd. 514QW7 10 '55 AM
2006/07
% of
FY 2005/06
% of Total for
YTD Actual
Budget
YTD Actual
FY 2005/06
3,731,728
65%
3,462,357
71%
5,699,871
47%
5,319,470
51%
4,549,428
49%
4,557,252
51%
132,992
29%
145,914
39%
1,235,077
60%
1,086,538
61%
18,500
32%
15,000
63%
4,186,462
59%
4,055,624
68%
5,421,215
63%
5,221,657
67%
1,658,846
23%
1,755,460
57%
26,634,119
51%
25,619,272
59%
24,975,273
55%
23,863,812
59%
ATTACHMENT Q
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF MARCH 2007
Prepared by
The Finance Department
May 4, 2007
3'b2,a
ATTACHMENT = (a,
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Mar2007
GENERAL SPECIAL SPECIAL CAPITAL TRUST/
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUNDS FUNDS FUND
ASSETS
CASH
(59,794,941)
4,459.892
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
112,754,448
RECEIVABLES: TAXES
ACCOUNTS
1,499,678
52,884
INTEREST
671,287
ASSESSMENTS
DUE FROM OTHERS
1,901,086
INVENTORY AT COST
PREPAID ITEMS
5,894
FIXED ASSETS
LOANS RECEIVABLE
AMOUNT TO BE PROVIDED
TOTAL ASSETS
57,037,452
4,512,775
LIABILITIES /FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
(766.182)
DEPOSITS FOR AB1600 FEES
(6,075)
DEPOSITS OTHERS
(519,568)
PAYABLES: ACCOUNTS
(363.268)
INTEREST
PAYROLL
(4,277)
DUE TO OTHERS
(70,671)
(7,488)
DEFERRED REVENUE
(140,415)
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES
(1,870,456)
(7,488)
FUND BALANCES
(55,166,996)
(4,505,287)
TOTAL FUND E
(55,166,996)
(4,505,287)
TOTAL LIABILITIES /EQUITY
(57,037,452)
(4,512,775)
qv- ('0
TOTALS
- -- MEMORANDUM ONLY-- -
CURRENT PRIOR
502,954 43,808,116 112,062 (10,911,917) (8,378,478)
169,862 169,862 179,997
1,631.500 1,631,500 4,177,500
112,754,448 101,981,813
1,552,561 491.364
671.287
1,901,086 2,206,558
5,894 2,115
6,713,816 6,713,816 4.596,534
1,083,500 1,083,500 1,213,500
502,954 52,153,431 1.365.425 115,572,037 106,470,904
(20,000) (786,182) (623,765)
(978.093) (984,168) (871,601)
(519,568) (2,239,985)
(18,549) (381.817) (570,501)
(4,277) (617,405)
(1,893,598) (1,971,756) (2,392,557)
(2,363,862) (2,504,276) (127,768)
(1.201,000) (1,201.000) (1,331,000)
(5,274,101) (1,201,000) (8,353,045) (8,774,582)
(502.954) (46,879.330) (164,425)(107,218,992) (88,791,355)
(502,954) (46,879,330) (164,425)(107,218,992) (88,791,355)
(502,954) (52,153,431) (1,365,425)(115,572,037) (97,565,937)
5� t2, (to
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Mar2007
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S.
SERVICE FUND GROUP OF TERM DEBT --- MEMORANDUM - --
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR
ASSETS
CASH 11,442,931 11,442,931 10,009.453
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 3,966 3,966
FIXED ASSETS 49.264,248 338,623,896 387,888,144 383.667.186
LOANS RECEIVABLE
AMOUNT TO BE PROVIDED 62,220,554 62,220,554 63,728,304
TOTAL ASSETS 60,711.146 338,623,896 62,220,554 461,555,596 457,404,944
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
(518,366)
(62.220,554) (62,738,920)_(63,728,304)
TOTAL LIABILITIES
(518,366)
(62.220.554) (62.738,920) (63,728,304)
FUND BALANCES
(60.192,780)
(338.623,896) (398,816,676)(392,595,948)
TOTAL FUND E
(60,192,780)
(338,623,896) (398,816,676)(392,595,948)
TOTAL LIABILITIES /EQUITY
(60,711,146)
(338,623,896) (62,220,554) (461,555,596)(456,324,252)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 03/31/2007
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
* * * * ** *REVENUES * * * * * **
PROPERTY TAXES
17,470,288.00
9,307,347.81
8.162,940.19
246,713.83
16,775,905.94
198,887.67
8,882,801.58
7,893,104.36
SALES TAX
15,283,000.00
9,543,874.59
5.739,125.41
960.957.13
14,363,863.47
672,908.73
9,433.762.10
288,048.40
4,930.101.37
REAL PROPERTY TRANSFER TAX
712,000.00
389,353.26
322,646.74
429,560.48
690.404.35
324,483.04
514,065.77
105,077.44
176,338.58
HOTEL TRANSIENT OCCUPANCY TAX
685.000.00
515,473.50
169,526.50
623,049.58
727,611.60
377,215.28
459,734.75
245,834.30
267.876.85
FRANCHISE TAXES
1.921,000.00
955.871.69
965,128.31
1.526,107.93
1,789,355.75
1,113,809.89
733,922.21
412.298.04
1.055.433.54
LICENSES & PERMITS
2,901,819.00
2,103.518.47
798,300.53
709.411.15
3,142,223.22
458,750.95
2.405,806.31
250,660.20
736.416.91
FINES & FORFEITURES
143,560.00
90,253.03
53.306.97
353,414.23
149,467.45
307,867.52
93,704.57
45,546.71
55,762.88
USE /MONEY & PROP- INTEREST
1.864,164.00
1,195,675.32
668,488.68
2.244.10
1,447,812.35
2,221.40
793,434.55
22.70
654,377.80
USE /MONEY & PROP- RENTALS
173,574.00
85,870.53
87,703.47
10,230.71
123,154.10
6,212.76
55,129.41
4,017.95
68,024.69
INTERGOVERNMENTAL
1,530,976.00
199,063.73
1,331.912.27
4,861,689.14
1,020,574.22
3.462,357.24
765,550.38
1.399,331.90
255,023.84
CHARGES FOR SERVICES
6.740,407.00
5,825,982.15
914.424.85
5,774.668.80
3.742,331.98
2,032,336.82
OTHER SOURCES OF REVENUE
1.983,070.00
788.334.05
1,194,735.95
10,519,026.18
275,245.24
5,319,470.21
238,023.08
5.199.555.97
37,222.16
TOTAL REVENUE
51.408,858.00
31.000.618.13
20,408,239.87
79.558.58
46,280.286.49
44.451.43
28,118,266.69
35,107.15
18,162,019.80
* * ** ***EXPENDITURES * **** **
GENERAL GOVERNMENT ACTIVITIES
CITY COUNCIL
362,356.00
247.248.56
115,107.44
246,713.83
198,887.67
47.826.16
CITY MANAGER
1,045.943.00
744,165.34
301,777.66
960.957.13
672,908.73
288,048.40
CENTRAL SERVICES
453.571.00
294,270.16
159,300.84
429,560.48
324,483.04
105,077.44
CITY ATTORNEY
750,395.00
481,279.64
269,115.36
623,049.58
377,215.28
245,834.30
ADMIN SERVICES
1.731,461.00
1,142,643.99
588.817.01
1.526,107.93
1,113,809.89
412.298.04
BUILDING MANAGEMENT
762.909.00
435,467.53
327,441.47
709.411.15
458,750.95
250,660.20
INSURANCE COST CENTER
534,659.00
355,029.91
179,629.09
353,414.23
307,867.52
45,546.71
ELECTIONS COST CENTER
21,815.00
25,554.79
(3,739.79)
2.244.10
2,221.40
22.70
NON- DEPARTMENTAL
78,269.00
6.067.62
72,201.38
10,230.71
6,212.76
4,017.95
ACTIVITY TOTAL
5,741,378.00
3,731,727.54
2,009,650.46
4,861,689.14
3.462,357.24
1.399,331.90
PUBLIC SAFETY
POLICE
12,175,438.00
5.699,870.92
6,475,567.08
10,519,026.18
5,319,470.21
5.199.555.97
CROSSING GUARDS
88,511.00
49,522.63
38,988.37
79.558.58
44.451.43
35,107.15
ANIMAL CONTROL
255,100.00
42,739.22
212,360.78
225,853.07
53,428.29
172,424.78
TRAFFIC SIGNALS & STREET LIGHTIN
16.315.00
10,514.20
5.800.80
12,608.33
8.782.65
3,825.68
DISASTER PREPAREDNESS
103.130.00
30.215.59
72.914.41
59.513.44
39,251.77
20.261.67
FIRE SERVICES
9.294.483.00
4,549,428.21
4,745.054.79
8,896,548.07
4,557,251.50
4,339.296.57
ACTIVITY TOTAL
21.932,977.00
10.382,290.77
11,550.686.23
19,793.107.67
10,022,635.85
9.770,471.82
TRANSPORTATION
PUBLIC WORKS
975.320.00
635.702.90
339,617.10
783,632.70
540.760.42
242,872.28
STREET MAINTENANCE
33,440.00
7,467.59
25,972.41
30,314.00
30.314.00
STREET SWEEPING
145,400.00
95,605.89
49,794,11
135,923.35
84,719.19
51.204.16
STREET TREE MAINTENANCE
103,529.00
33.020.19
70.508.81
119,576.15
33.218.36
86,357.79
STREET LANDSCAPING MAINTENAN
800.168.00
463,280.88
336,887.12
709,557.73
427,840.49
281,717.24
ACTIVITY TOTAL
2,057.857.00
1,235,077.45
822,779.55
1,779.003.93
1,086,538.46
692,465.47
HEALTH & WELFARE
WASTE MANAGEMENT
29,075.00
29,075.00
8.829.31
8,829.31
CHILD CARE
18,500.00
18,500.00
15,000.00
15,000.00
SOCIAL SERVICES
10,000.00
10.000.00
HOUSING PROGRAMS
THE CITY OF DUBLIN STATEMENT SHOWING
--"rb -VIA
REVENUES
VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006
THROUGH 03/31/2007
GENERAL
REVENUE
FUND
CURRENT
CURRENT
PRIOR
PRIOR
BUDGET
ACTUAL
VARIANCE
FISCAL YEAR
Y.T.D.
VARIANCE
ACTIVITY TOTAL
57,575.00
18,500.00
39.075.00
23,829.31
15,000.00
8,829.31
CULTURE & LEISURE SERVICES
LIBRARY SERVICES
832.317.00
417.822.75
414.494.25
618.993.45
459,877.71
159,115.74
CULTURAL ACTIVITIES
265,457.00
165.995.26
99.461.74
233.515.51
176,314.80
57,200.71
HERITAGE CENTER
192,777.00
131.024.16
61.752.84
158.806.33
105,736.04
53,070.29
DUBLIN CEMETERY
49,060.00
21.692.55
27,367.45
36,321.70
19,174.69
17,147.01
PARK MAINTENANCE
1.852.674.00
896.530.36
956.143.64
1,390,353.67
816,981.56
573.372.11
COMMUNITY TV
67.591.00
60,921.00
6,670.00
63,060.91
60.125.58
2.935.33
RECREATION ADMIN
740,553.00
492.245.08
248.307.92
686.496.76
483,546.00
202,950.76
PLAYGROUNDS
280,851.00
177.852.30
102.998.70
243.464.19
166,209.25
77,254.94
SHANNON CENTER
315.329.00
243,072.41
72,256.59
328,750.40
230,702.22
98,048.18
PRESCHOOL
121.504.00
71,767.03
49,736.97
108,039.36
76,549.53
31.489.83
TEENS PROGRAM
150.581.00
94,276.07
56.304.93
143.225.92
95,579.89
47,646.03.
ADULT SPORTS
136.873.00
75,154.95
61,718.05
83,918.06
54.488.45
29,429.61
YOUTH SPORTS
170.700.00
137.516.13
33,183.87
142.237.92
115,538.44
26.699.48
COMMUNITY GYM
43.969.00
28.218.54
15.750.46
40.429.40
25.225.79
15,203.61
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS
369.636.00
244,461.94
125.174.06
377,607.25
277,509.49
100.097.76
SENIOR CENTER
485.216.00
323.549.47
161.666.53
421,034.20
291.392.36
129,641.84
RECREATION INSTRUCTION
189,417.00
131.372.67
58.044.33
166,976.26
114,430.21
52.546.05
AQUATICS
446.642.00
256.851.65
189,790.35
411,688.61
275.006.25
136.682.36
PARKS /FACILITIES MANAGEMENT
326,214.00
216.138.16
110,075.84
293.642.66
211,235.43
82.407.23
ACTIVITY TOTAL
7,037.361.00
4,186.462.48
2.850.898.52
5.948.562.56
4.055.623.69
1.892.938.87
COMMUNITY DEVELOPMENT
PLANNING
2.920,013.00
1,524,811.76
1,395.201.24
2.218,620.09
1,572,910.48
645,709.61
BUILDING SAFETY
3,205,667.00
2,001,215.54
1,204,451.46
2,908,309.60
1.872,342.58
1,035,967.02
ENGINEERING
2,215.848.00
1.695,493.84
520.354.16
2,380,371.77
1,536.409.67
843.962.10
ECONOMIC DEVELOPMENT
262,742.00
199,693.46
63,048.54
291,110.11
239.994.70
51,115.41
ACTIVITY TOTAL
8.604,270.00
5,421,214.60
3,183,055.40
7,798,411.57
5,221,657.43
2,576,754.14
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
1,198,578.00
245,233.59
953,344.41
606,778.83
161,778.90
444,999.93
COMMUNITY IMPROVEMENTS
202,544.00
23.475.51
179,068.49
780,954.81
630,914.32
150,040.49
PARKS
4.835.076.00
1.121.793.37
3,713.282.63
1,037,007.51
723,534.44
313,473.07
STREET CONSTRC /IMPROVEMENTS
1,061.970.00
268.343.51
793,626.49
660.581.62
239.232.28
421.349.34
ACTIVITY TOTAL
7.298,168.00
1,658,845.98
5,639,322.02
3,085.322.77
1.755,459.94
1,329,862.83
TOTAL EXPENDITURES
52.729.586.00
26,634,118.82
26.095.467.18
43.289,926.95
25,619,272.61
17,670,654.34
EXCESS REVENUE (EXPENDITURES)
(1,320,728.00)
4,366.499.31
(5.687.227.31)
2.990.359.54
2.498.994.08
491,365.46
TRANSFERS IN FROM OTHER FUNDS
39.525.20
(39.525.20)
15,188.59
15,188.59
TRANSFERS OUT FROM OTHER FUNDS
(23.505.65)
23,505.65
(23.505.65)
23,505.65
REVENUES OVER(UNDER) EXPENDITURES
(1,320,728.00)
4,382.518.86
(5,703.246.86)
3.005,548.13
2,475.488.43
530.059.70
* * * * * ** *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:
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 03/31/2007
SPECIAL REVENUE FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
t �
r
VARIANCE
119,960.00 61,237.46 58.722.54 115,763.98 59,287.64 56.476.34
426,421.00 228,243.34 198,177.66 443,195.51 237,180.35 206.015.16
177,000.00 133,706.85 43,293.15 190,869.24 119,491.84 71,377.40
120,002.00 130,233.83 (10,231.83) 108,314.70 68,613.05 39.701.65
1,084,313.00 910,862.87 173,450.13 1,094,513.46 764,122.45 330,391.01
370,913.00 171,013.60 199,899.40 355,919.00 155,280.00 200,639.00
482,198.00 19,494.85 462,703.15 122,330.00 51,833.41_ 70,496.59
1,462,058.00 735,276.64 726,78.1.36 1,315,435.57 675.,216.24 640,219.33
29,000.00 3.404.00 25,596.00 420,867.00 390,000.00 30,867.00
4,271,865.00 2,393,473.44 1,878,391.56 4,167,208.46 2.521,024.98 1.646.183.48
POLICE
103,710.00
100,370.70
3,339.30
105,670.43
105.389.23
281.20
TRAFFIC SIGNALS & STREET LTG
265,922.00
138,557.00
127,365.00
225,650.30
157.258.88
68.391.42
DISASTER PREPAREDNESS
FIRE SERVICES
276,973.00
178,880.86
98,092.14
267,350.23
134,976.23
132,374.00
ACTIVITY TOTAL
646,605.00
417.808.56
228,796.44
598,670.96
397,624.34
201,046.62
TRANSPORTATION:
STREET MAINTENANCE
379.294.00
131,441.39
247,852.61
335,939.86
177,937.24
158,002.62
STREET LANDSCAPE MAINTENANCE
5,822.00
13,198.43
(7,376.43)
4,823.96
4,823.96
ACTIVITY TOTAL
385,116.00
144.639.82
240,476.18
340,763.82
182,761.20
158,002.62
HEALTH & WELFARE:
WASTE MANAGEMENT
1,575,838.00
751,732.52
824,105.48
1,822,693.60
1,126,548.14
696,145.46
SOCIAL SERVICES
61,804.00
33,072.50
28,731.50
60,427.00
36,956.81
23,470.19
HOUSING PROGRAMS
ACTIVITY TOTAL
1,637,642.00
784,805.02
852.836.98
1,883,120.60
1,163,504,95
719.615.65
COMMUNITY DEVELOPMENT:
ENGINEERING
6,000.00
2,981.36
3,018.64
6,000.00
6,000.00
ACTIVITY TOTAL
6,000.00
2.981.36
3,018.64
6,000.00
6,000.00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS
COMMUNITY PROJECTS
17,581.00
17,581.00
39,556.00
29,791.00
9,765.00
PARKS
136,587.00
75,525.71
61,061.29
50,349.43
50,349.43
STREET CONSTRUCTION /IMPROVEMENT
1,204,569.00
47,069.36
1.157,499.64
1,257,617.38
535,398.52
722,218.86
ACTIVITY TOTAL
1,358,737.00
122,595.07
1.236,141.93
1,347,522.81
565,189.52
782,333.29
T 0 T A L EXPENDITURES
4,034,100.00
1,472,829.83
2,561,270.17
4,176,078.19
2,315,080.01
1,860.998.18
EXCESS REVENUE (EXPENDITURES)
237,765.00
920,643.61
(682,878.61)
(8,869.73)
205.944.97
(214.814.70)
TRANSFER IN FROM OTHER FUNDS
(1.097.00)
1,097.00
TRANSFERS OUT TO OTHER FUNDS
1,097.00
(1,097.00)
21,788.59
6,600.00
15.188.59
REVENUES OVER (UNDER) EXPENDITURES
237,765.00
920,643.61
(682,878.61)
(30,658.32)
199.344.97
(230,003.29)
THE CITY OF DUBLIN STATEMENT SNOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 03/31/2007
SPECIAL ASSESSMENT FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
* *** * ** *REVENUES * * * * * * **
319.000.00
210,688.79
108,311.21
SPECIAL BENEFITS ASSESSMENTS
737,494.00
364,945.60
372.548.40
645.230.59
326.006.80 319,223.79
USES /MONEY & PROP- INTEREST
17,137.00
14,815.26
2.321.74
17.139.71
10.053.42 7,086.29
OTHER SOURCES OF REVENUE
9,700.00
102.844.90
1.194.03
8,505.97
5,603.48
5,603.48
TOTAL REVENUE
764.331.00
380,954.89
383.376.11
667,973.78
341,663.70 326,310.08
* * * * ** *EXPENDITURES * * * * * **
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG
319.000.00
210,688.79
108,311.21
262.370.43
159.525.53
102.844.90
ACTIVITY TOTAL
319,000.00
210,688.79
108,311.21
262,370.43
159,525.53
102.844.90
TRANSPORTATION
PUBLIC WORKS
2.470.00
1.511.59
958.41
2,095.50
1,574.78
520.72
STREET TREE MAINTENANCE
31.173.00
9,135.17
22,037.83
19,407.11
7,728.91
11,678.20
STREET LANDSCAPE MAINTENANCE
404,790.00
194,788.44
210,001.56
329,352.28
214,281.26
115.071.02
ACTIVITY TOTAL
438.433.00
205,435.20
232,997.80
350,854.89
223.584.95
127.269.94
COMMUNITY DEVELOPMENT
ENGINEERING
13.100.00
358.50
12,741.50
11,357.60
11,357.60
ACTIVITY TOTAL
13.100.00
358.50
12,741.50
11,357.60
11,357.60
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
18,106.69
18.106.69
STREET CONSTRUCTION /IMPRVMNT
75,000.00
75,000.00
ACTIVITY TOTAL
93.106.69
18,106.69
75,000.00
T 0 T A L EXPENDITURES
770.533.00
416.482.49
354,050.51
717,689.61
412.574.77
305,114.84
EXCESS REVENUE (EXPENDITURES)
(6,202.00)
(35.527.60)
29,325.60
(49,715.83)
(70,911.07)
21,195.24
REVENUES OVER (UNDER) EXPENDITURES
(6,202.00)
(35,527.60)
29,325.60
(49.715.83)
(70,911.07)
21,195.24
* * * * * ** *REVENUE * * * * * * **
USES /MONEY & PROP- INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
* * * * ** *EXPENDITURES * * *** **
GENERAL GOVERNMENT ACTIVITIES:
NON- DEPARTMENTAL
CITY ATTORNEY
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS
ACTIVITY TOTAL
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 03/31/2007
CAPITAL IMPROVEMENT' FUNDS
CURRENT CURRENT PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR
PRIOR
Y.T.D. VARIANCE
1,444,942.00 1,404,702.35 40,239.65 1.286,165.31 747,975.84 538.189.47
21,267.707.00 7.132,469.08 14,135,237.92 17,143.271.43 10,737,470.24 6,405.801.19
22,712.649.00 8.537,171.43 14,175,477.57 18.429,436.74 11,485,446.08 6,943,990.66
39,525.20 (39,525.20)
52.250.00 55.530.01 (3,280.01)
52,250.00 95,055.21 (42,805.21)
75,050.34 75,050.34
56,509.63 33,516.47 22,993.16
131,559.97 33,516.47 98,043.50
864,070.00 232,588.59 631.481.41 327.654.70 200,323.37 127.331.33
864,070.00 232.588.59 631,481.41 327.654.70 200.323.37 127.331.33
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
31,220.00
16,751.50
14,468.50
59,380.81
36,670.81
22,710.00
COMMUNITY IMPROVEMENTS
PARKS
1.738.504.00
361,059.14
1,377,444.86
9,102.130.25
3,475,523.11
5,626,607.14
STREET CONSTRUCTION /IMPROVEMENT
32.653,594.00
3,264,158.53
29,389,435.47
5.109,251.49
1.361,562.32
3,747,689.17
ACTIVITY TOTAL
34,423,318.00
3,641.969.17
30,781,348.83
14,270,762.55
4,873,756.24
9.397,006.31
T 0 T A L EXPENDITURES
35,339,638.00
3,890.562.57
31,449,075.43
14,729,977.22
5,107,596.08
9,622,381.14
EXCESS REVENUE (EXPENDITURES)
(12,626.989.00)
4,670,114.51
(17,297,103.51)
3,706,059.52
6.407,955.65
(2,701.896.13)
TRANSFER IN FROM OTHER FUNDS
23,505.65
(23,505.65)
6,600.00
30,105.65
(23,505.65)
TRANSFERS OUT TO OTHER FUNDS
39,525.20
(39,525.20)
REVENUES OVER (UNDER) EXPENDITURES(12,626,989.00) 4;630,589.31 (17,257,578.31) 3,706,059.52 6,407,955.65 (2.701.896.13)
< <�
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 03/31/2007
TRUST /AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
** * * * ** *REVENUES * * * * * * **
SPECIAL ASSESSMENTS 108.515.05 (108,515.05) 242.044.14 117,292.54 124.751.60
USES /MONEY & PROP- INTEREST 9,003.95 (9,003.95) 9,505.83 5.659.36 3.846.47
TOTAL REVENUE 117.519.00 (117,519.00) 251,549.97 122.951.90 128.598.07
* * * * ** *EXPENDITURES *** ****
GENERAL GOVERNMENT ACTIVITIES
NON- DEPARTMENTAL
230,503.00
228.121.25
2,381.75
231.731.25
229,862.50
1,868.75
ACTIVITY TOTAL
230,503.00
228,121.25
2,381.75
231,731.25
229,862.50
1.868.75
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES
230,503.00
228.121.25
2,381.75
231.731.25
229,862.50
1.868.75
EXCESS REVENUE (EXPENDITURES)
(230,503.00)
(110.602.25)
(119,900.75)
19.818.72
(106,910.60)
126,729.32
REVENUES OVER (UNDER) EXPENDITURES
(230,503.00)
(110,602.25)
(119.900.75)
19,818.72
(106,910.60)
126,729.32
* * * * *** *REVENUES * * * * * * **
USES /MONEY & PROP- INTEREST
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
* * * * ** *EXPENDITURES * **** **
GENERAL GOVERNMENT ACTIVITIES
NON- DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
FIRE
ACTIVITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T O T A L EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
THE CITY OF DUBLIN STATEMENT SHOWING Ob 2(P
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 03/31/2007
INTERNAL SERVICE FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
407,294.00
309.892.82
97,401.18
267.035.82
172,855.73
94,180.09
1.784,731.00
1,309,449.25
475.281.75
1.790,982.80
1,338,844.57
452,138.23
19,800.00
10,046.58
9,753.42
939,048.36
31,510.00
907,538.36
2,211.825.00
1,629,388.65
582,436.35
2,997.066.98
1,543,210.30
1,453,856.68
2,043,020.00 456,861.82 1,586,158.18 2,908,427.37
2,043.020.00 456,861,82 1.586.158.18 2.908.427.37
447,429.54 2.460,997.83
447,429.54 2,460,997.83
15,089.26 (15.089.26)
15,089.26 (15,089.26)
2,043,020.00 456.861.82 1,586.158.18 2,908,427.37 462,518.80 2,445,908.57
168,805.00 1,172,526.83 (1,003,721.83) 88,639.61 1,080,691.50 (992.051.89)
REVENUES OVER (UNDER) EXPENDITURES 168,805.00 1,172.526.83 (1,003,721.83) 88.639.61 1,080,691.50 (992,051.89)
THE
CITY OF DUBLIN
STATEMENT SHOWING
REVENUES VERSUS
EXPENDITURES
FOR THE
PERIOD
07/01/2006 THROUGH 03/31/2007
ENTERPRISE
FUND
CURRENT
CURRENT
PRIOR
PRIOR
BUDGET
ACTUAL
VARIANCE FISCAL YEAR
Y.T.D. VARIANCE
* * ** ****REVENUES *** * * * **
USES /MONEY & PROP- INTEREST
TOTAL REVENUE
* * * * * ** *EXPENDITURES * * * * * **
GENERAL GOVERNMENT ACTIVITIES:
NON- DEPARTMENTAL
20.00
20.00
FINANCE
ACTIVITY TOTAL
20.00
20.00
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES
20.00
20.00
EXCESS REVENUE (EXPENDITURES)
(20.00)
(20.00)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES
(20.00)
(20.00)
City of Dublin 2006 -2007 YTD Revenues and Budget Comparison
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
1%
44
197%
14
■ FY 2006/07
FY 2005/06
0% 30% 60% 90% 120% 150%
83% of Year Complete
% of Total for
FY 2005/06
0
89%
71%
78%
72%
77%
78%
100%
86%
73%
77 %
92%
80%
Date P-t.d. 5/420074 48 PM ATTACHMENT 01
FY 2006/07
FY 2006/07
% of
FY 2005/06
Budget
YTD Actual
Budget
YTD Actual
Property Taxes
17,470,288
15,877,669
91%
14,899,206
Sales Taxes
15,283,000
11,396,854
75%
10,152,862
Real Property Transfer Tax
712,000
389,353
55 %
538,104
Transient Occupancy Taxes
685,000
588,194
86%
525,214
Franchise Taxes
1,921,000
1,625,063
85%
1,369,062
Licenses and Permits
2,901,819
2,175,147
75%
2,447,357
Interest and Rentals
2,037,738
1,955,037
96%
1,566,318
Intergovernmental
1,530,976
229,131
15%
872,731
Charges for Services
6,740,407
6,509,011
97%
4,213,298
Fines and Forfeitures
143,560
97,768
68%
114,417
Other Revenues
1,983,070
871,945
44%
252,683
Total General Fund Revenues
51,408,858
41,715,172
81%
36,951,252
% of Total for
FY 2005/06
0
89%
71%
78%
72%
77%
78%
100%
86%
73%
77 %
92%
80%
Date P-t.d. 5/420074 48 PM ATTACHMENT 01
City of Dublin 2006 -2007 YTD Expenses and Budget Comparison
For the Period Ending April 30, 2007
Total General Fund
V- - - - - --
General Government
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
40% 60% 80%
83% of Year Complete
�5z,z
D- P,,.Wd5142W74r5 PM ATTACHMENT 2 CIO)
2006/07
2006/07
% of
FY 2005/06
% of Total for
Budget
YTD Actual
Budget
YTD Actual
FY 2005/06
General Government
5,741,378
4,184,989
73%
3,794,897
78%
Police
12,175,438
5,787,210
48%
5,422,795
52%
Fire
9,294,483
4,577,279
49%
4,609,821
52 %
Other Public Safety
463,056
180,539
39%
159,913
42%
Transportation
2,057,857
1,344,055
65%
1,200,891
68%
Health and Welfare
57,575
20,421
35%
15,000
63%
Culture and Community Services
7,037,361
4,783,811
68%
4,454,707
75%
Community Development
8,604,270
6,015,599
70%
5,679,591
73%
Capital Improvement Projects
7,298,168
1,758,358
24%
1,748,278
57%
Total General Fund Expenses
52,729,586
28,652,261
549/.
27,085,893
63%
General Fund Operating Expenses
45,431,418
26,893,903
59%
25,337,615
63%
D- P,,.Wd5142W74r5 PM ATTACHMENT 2 CIO)
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF APRIL 2007
Prepared by
The Finance Department
May 4, 2007
ATTACHMENT X (P.)
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Apr2007
GENERAL SPECIAL SPECIAL CAPITAL TRUST/
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUNDS FUNDS FUND
ASSETS
CASH
(61,233,298)
4.306,437
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
122,824,719
RECEIVABLES: TAXES
ACCOUNTS
1,499,678
52,884
INTEREST
671,287
ASSESSMENTS
DUE FROM OTHERS
1,901,086
INVENTORY AT COST
PREPAID ITEMS
9,910
FIXED ASSETS
LOANS RECEIVABLE
AMOUNT TO BE PROVIDED
TOTAL ASSETS
65,673,381
4,359,321
LIABILITIES /FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
(671,721)
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
(586,838)
PAYABLES: ACCOUNTS
(370,704)
INTEREST
PAYROLL
(3.181)
DUE TO OTHERS
(36.483)
(7,488)
DEFERRED REVENUE
(141,045)
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES
(1,809,971)
(7,488)
FUND BALANCES
(63:863,410)
(4,351,833)
TOTAL FUND E
(63,863,410)
(4,351,833)
TOTAL LIABILITIES /EQUITY
(65,673,381)
(4,359,321)
Rom
TOTALS
- -- MEMORANDUM ONLY-- -
CURRENT PRIOR
657,480 43,299,993 178.007 (12,791,381) (7,303,548)
169.862 169,862 179,997
1,631,500 1.631,500 4,177,500
122,824.719 110,635,467
1,552,561 491,364
671.287
1,901,086 2,206,558
9,910 3,688
6,750,316 6,750,316 4,596,534
1,083,500 1.083,500 1,213,500
657,480 51,681,808 1,431:369 123,803,359 116,201,062
(20.000) (691,721) (379,895)
(978,093) (978,093) (871,601)
(586.838) (2,294,586)
(18,549) (389,253) (571,260)
(3,181) (606,334)
(1,893,598) (1,937,568) (2,206.558)
(2,363,862) (2,504,907) (127,768)
(1,201,000) (1,201,000) (1,331,000)
(5,274,101) (1,201,000) (8.292,561) (8,389,003)
(657,480) (46,407,707) (230,369)(115,510,798) (88,791,355)
(657,480) (46,407,707) (230,369)(115,510,798) (88,791,355)
(657,480) (51,681,808) (1, 431 ,369)(123,803,359) (97,180,358)
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Apr2007
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S
SERVICE FUND GROUP OF TERM DEBT --- MEMORANDUM - --
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR
ASSETS
CASH 11,450,083 11.450,083 10,081,302
CASH WITH FISCAL AGENT -
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 3,966 3,966
FIXED ASSETS 49,264,248 338,623,896 387,888,144 383,667,186
LOANS RECEIVABLE
AMOUNT TO BE PROVIDED 62,216,048 62,216.048 63,728,304
TOTAL ASSETS 60.718,298 338.623,896 62,216,048 461,558,241 457,476,792
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
(518,366)
(62,216.048) (62,734,414) (63,728,304)
TOTAL LIABILITIES
(518,366)
(62,216,048) (62,734,414) (63,728,304)
FUND BALANCES
(60,1.99.932)
(338,623,896) (398,823,827)(392,595,948)
TOTAL FUND E
(60,199,932)
(338,623,896) (398.823,827)(392,595.948)
TOTAL LIABILITIES /EQUITY
(60,718,298)
(338,623,896) (62,216,048) (461,558,241)(456,324,252)
THE CITY OF DUBLIN STATEMENT SHOWING ` Db*2`9
REVENUES VERSUS EXPENDITURES t/
FOR THE PERIOD
07/01/2006 THROUGH 04/30/2007
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
* * * * ** *REVENUES * * * * * **
PROPERTY TAXES
17.470,288.00
15,877,668.60
99,295.02
1,592.619.40
246,713.83
16.775,905.94
14,899,205.55
1,876,700.39
SALES TAX
15183,000.00
11,396,854.13
3.886,145.87
14.363,863.47
10,152,862.10
4,211,001.37
REAL PROPERTY TRANSFER TAX
712,000.00
389.353.26
322,646.74
690,404.35
538,103.60
152,300.75
HOTEL TRANSIENT OCCUPANCY TAX
685,000.00
588,194.39
96,805.61
727,611.60
525,214.23
202,397.37
FRANCHISE TAXES
1,921,000.00
1,625,063.11
295,936.89
1,789,355.75
1,369,062.15
420.293.60
LICENSES & PERMITS
2,901,819.00
2,175,147.33
726,671.67
3,142,223.22
2,447,357.18
694.866.04
FINES & FORFEITURES
143,560.00
97,768.46
45,791.54
149,467.45
114,417.48
35,049.97
USE /MONEY & PROP- INTEREST
1,864,164.00
1,851.871.41
12.292.59
1,447,812.35
1,507,627.42
(59,815.07)
USE /MONEY & PROP- RENTALS
173,574.00
103,165.41
70,408.59
123,154.10
58,690.35
64,463.75
INTERGOVERNMENTAL
1,530.976.00
229.131.24
1,301,844.76
1,020,574.22
872,730.86
147,843.36
CHARGES FOR SERVICES
6,740,407.00
6.509,010.77
231.396.23
5,774,668.80
4.213.298.44
1,561,370.36
OTHER SOURCES OF REVENUE
1,983,070.00
871,944.73
1,111,125.27
275.245.24
252,682.87
22,562.37
TOTAL REVENUE
51,408,858.00
41.715.172.84
9,693.685.16
46,280.286.49
36,951,252.23
9,329,034.26
* * * * ** *EXPENDITURES * * * * * **
GENERAL GOVERNMENT ACTIVITIES
CITY COUNCIL
362,356.00
263,060.98
99,295.02
246,713.83
210,398.55
36,315.28
CITY MANAGER
1.045,943.00
831,567.80
214,375.20
960,957.13
744,491.64
216.465.49
CENTRAL SERVICES
453,571.00
319,038.67
134,532.33
429,560.48
350.552.67
79,007.81
CITY ATTORNEY
750,395.00
659,011.91
91,383.09
.623.049.58
425,807.30
197.242.28
ADMIN SERVICES
1,731,461.00
1,238,851.70
492.609.30
1,526,107.93
1,232,049.51
294,058.42
BUILDING MANAGEMENT
762,909.00
484,841.80
278,067.20
709,411.15
511,265.31
198..145.84
INSURANCE COST CENTER
534,659.00
356,150.41
178.508.59
353,414.23
311,460.61
41,953.62
ELECTIONS COST CENTER
21.815.00
25,554.79
(3,739.79)
2,244.10
2,221.40
22.70
NON- DEPARTMENTAL
78,269.00
6,910.77
71,358.23
10,230.71
6,650.38
3,580.33
ACTIVITY TOTAL
5,741,378.00
4,184,988.83
1,556,389.17
4,861,689.14
3,794,897.37
1,066,791.77
PUBLIC SAFETY
POLICE
12,175,438.00
5,787,209.63
6,388,228.37
10,519,026.18
5.422,795.07
5,096,231.11
CROSSING GUARDS
88,511.00
58,591.38
29,919.62
79,558.58
53,035.06
26,523.52
ANIMAL CONTROL
255,100.00
74,570.22
180,529.78
225,853.07
53,428.29
172,424.78
TRAFFIC SIGNALS & STREET LIGHTIN
16,315.00
11,684.91
4,630.09
12,608.33
9.123.64
3,484.69
DISASTER PREPAREDNESS
103,130.00
35,692.44
67.437.56
59.513.44
44,326.09
15.187.35
FIRE SERVICES
9,294,483.00
4,577,278.65
4,717,204.35
8,896.548.07
4,609,821.14
4,286,726.93
ACTIVITY TOTAL
21,932.977.00
10.545,027.23
11,387,949.77
19,793.107.67
10,192.529.29
9,600,578.38
TRANSPORTATION
PUBLIC WORKS
975,320.00
697,507.48
277.812.52
783,632.70
602,990.22
180,642.48
STREET MAINTENANCE
33.440.00
7,467.59
25.972.41
30,314.00
57.50
30,256.50
STREET SWEEPING
145,400.00
95.605.89
49,794.11
135,923.35
94,772.95
41,150.40
STREET TREE MAINTENANCE
103.529.00
35,617.29
67,911.71
119.576.15
38,654.22
80,921.93
STREET LANDSCAPING MAINTENAN
800.168.00
507,856.81
292,311.19
709.557.73
464,415.82
245.141.91
ACTIVITY TOTAL
2,057,857.00
1,344.055.06
713,801.94
1,779.003.93
1,200,890.71
578,113.22
HEALTH & WELFARE
WASTE MANAGEMENT
29,075.00
1,921.25
27.153.75
8,829.31
8,829.31
CHILD CARE
18,500.00
18,500.00
15,000.00
15,000.00
SOCIAL SERVICES
10,000.00
10,000.00
HOUSING PROGRAMS
THE CITY OF DUBLIN STATEMENT SHOWING Z 0 v (
REVENUES VERSUS EXPENDITURES Ob
FOR THE PERIOD
07/01/2006 THROUGH 0413012007
GENERAL REVENUE FUND
CURRENT
CURRENT
PRIOR
PRIOR
BUDGET
ACTUAL
VARIANCE
FISCAL YEAR
Y.T.D.
VARIANCE
ACTIVITY TOTAL
57,575.00
20,421.25
37,153.75
23,829.31
15.000.00
8,829.31
CULTURE & LEISURE SERVICES
LIBRARY SERVICES
832.317.00
592,227.36
240,089.64
618,993.45
466,821.28
152.172.17
CULTURAL ACTIVITIES
265.457.00
175,355.84
90,101.16
233,515.51
185,939.95
47,575.56
HERITAGE CENTER
192,777.00
143,571.87
49,205.13
158,806.33
117,100.81
41,705.52
DUBLIN CEMETERY
49,060.00
24,528.49
24,531.51
36,321.70
21.100.97
15,220.73
PARK MAINTENANCE
1,852,674.00
1,000.940.30
851,733.70
1,390.353.67
917,601.27
472,752.40
COMMUNITY TV
67,591.00
60.921.00
6.670.00
63,060.91
60.425.58
2.635.33
RECREATION ADMIN
740,553.00
557,476.43
183.076.57
686,496.76
538,141.01
148,355.75
PLAYGROUNDS
280,851.00
194.863.67
85,987.33
243,464.19
180.952.14
62,512.05
SHANNON CENTER
315.329.00
266,544.39
48,784.61
328,750.40
259,032.69
69,717.71
PRESCHOOL
121.504.00
79.462.12
42,041.88
108,039.36
85,618.85
22,420.51
TEENS PROGRAM
150,581.00
102,353.18
48,227.82
143,225.92
110.240.28
32.985.64
ADULT SPORTS
136,873.00
82,058.46
54.814.54
83.918.06
59,470.85
24.447.21
YOUTH SPORTS
170.700.00
143.774.35
26,925.65
142,237.92
121,184.24
21,053.68
COMMUNITY GYM
43.969.00
32.220.86
11348.14
40,429.40
30,738.25
9,691.15
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS
369,636.00
297,940.37
71,695.63
377,607.25
337.227.43
40,379.82
SENIOR CENTER
485,216.00
361,367.20
123.848.80
421,034.20
319.098.74
101.935.46
RECREATION INSTRUCTION
189.417.00
140,544.36
48,872.64
166,976.26
125,069.36
41,906.90
AQUATICS
446,642.00
290.382.57
156,259.43
411,688.61
286,267.65
125.420.96
PARKS /FACILITIES MANAGEMENT
326.214.00
237,278.11
88.935.89
293.642.66
232,675.43
60.967.23
ACTIVITY TOTAL
7,037,361.00
4,783,810.93
2,253,550.07
5,948.562.56
4,454,706.78
1,493,855.78
COMMUNITY DEVELOPMENT
PLANNING
2.920,013.00
1.704,038.60
1.215.974.40
2,218,620.09
1,748,953.93
469,666.16
BUILDING SAFETY
3.205,667.00
2.223,192.75
982,474.25
2,908.309.60
1.946,752.87
961.556.73
ENGINEERING
2.215,848.00
1.874,629.18
341,218.82
2.380.371.77
1,730.661.08
649,710.69
ECONOMIC DEVELOPMENT
262,742.00
213,738.51
49,003.49
291,110.11
253.222.70
37,887.41
ACTIVITY TOTAL
8.604,270.00
6,015.599.04
2,588,670.96
7,798,411.57
5,679.590.58
2,118.820.99
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
1,198,578.00
262,607.23
935,970.77
606,778.83
204,266.80
402,512.03
COMMUNITY IMPROVEMENTS
202,544.00
25,920.93
176.623.07
780,954.81
631.706.57
149,248.24
PARKS
4,835,076.00
1,174,336.50
3,660.739.50
1.037,007.51
673.164.25
363.843.26
STREET CONSTRC /IMPROVEMENTS
1.061,970.00
295,492.84
766,477.16
660,581.62
239.140.82
421,440.80
ACTIVITY TOTAL
7.298,168.00
1,758,357.50
5,539,810.50
3,085,322.77
1,748,278.44
1.337,044.33
TOTAL EXPENDITURES
52,729.586.00
28,652,259.84
24,077,326.16
43;289,926.95
27,085.893.17
16.204,033.78
EXCESS REVENUE (EXPENDITURES)
(1,320,728.00)
13,062,913.00
(14.383.641.00)
2.990.359.54
9,865.359.06
(6.874,999.52)
TRANSFERS IN FROM OTHER FUNDS
39,525.20
(39,525.20)
15,188.59
15.188.59
TRANSFERS OUT FROM OTHER FUNDS
(23,505.65)
23.505.65
(23,505.65)
23.505.65
REVENUES OVER(UNDER) EXPENDITURES
(1.320.728.00)
13,078,932.55
(14,399,660.55)
3,005.548.13
9.841,853.41
(6,836,305.28)
THE CITY OF DUBLIN .STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 04/30/2007
SPECIAL REVENUE FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
* * * * * ** *REVENUES * * * * * * **
PROPERTY TAXES
119.960.00
97,674.60
3,289.30
22,285.40
105,670.43
115.763.98
105.396.95
108,002.42
SALES TAX /OTHER TAXES
426,421.00
TRAFFIC SIGNALS & STREET LTG
288,138.44
138,282.56
443,195.51
272,162.71
FINES & FORFEITURES
177,000.00
152,804.40
24,195.60
190,869.24
119,491.84
USES /MONEY & PROPERTY
120.002.00
148.639.50
(28,637.50)
108,314.70
FIRE SERVICES
68,613.05
INTERGOVERNMENTAL FROM STATE
1.084,313.00
978,582.48
105,730.52
1,094.513.46
811,130.11
INTERGOVERNMENTAL. FROM COUNTY
370,913.00
646,605.00
171,013.60
465,567.95
199.899.40
181,037.05
355,919.00
598.670.96
.193,390.00
INTERGOVERNMENTAL FROM FEDERAL
482,198.00
187,302.23
33,887.13
TRANSPORTATION:
448,310.87
122,330.00
72.482.23
CHARGES FOR SERVICES
1,462,058.00
1.172.140.43
289,917.57
1,315.435.57
379,294.00
1.253.048.16
OTHER SOURCES OF REVENUE
29,000.00
236,802.32
25.467.40
335,939.86
3.532.60
200,531.18
420,867.00
135,408.68
435,037.00
TOTAL REVENUE
4,271,865.00
3,068.347.98
1.203,517.02
4,167,208.46
3,333,357.52
* * * * ** *EXPENDITURES * * * * * **
PUBLIC SAFETY:
VARIANCE
7,761.56
171,032.80
71,377.40
39.701.65
283.383.35
162,529.00
49,847.77
62.387.41
(14,170.00)
833,850.94
POLICE
103,710.00
100,420.70
3,289.30
105,670.43
105.396.95
273.48
TRAFFIC SIGNALS & STREET LTG
265,922.00
186,266.39
79,655.61
225,650.30
170,995.55
54,654.75
DISASTER PREPAREDNESS
FIRE SERVICES
276,973.00
178,880.86
98,092.14
267,350.23
134,976.23
132,374.00
ACTIVITY TOTAL
646,605.00
465,567.95
181,037.05
598.670.96
411,368.73
187,302.23
TRANSPORTATION:
STREET MAINTENANCE
379,294.00
142,491.68
236,802.32
335,939.86
200,531.18
135,408.68
STREET LANDSCAPE MAINTENANCE
5,822.00
13,198.43
(7,376.43)
4,823.96
4,823.96
ACTIVITY TOTAL
385,116.00
155,690.11
229,425.89
340,763.82
205,355.14
135,408.68
HEALTH & WELFARE:
WASTE MANAGEMENT
1,575,838.00
1,481,632.91
94,205.09
1,822,693.60
1,133,282.97
689,410.63
SOCIAL SERVICES
61,804.00
39,343.68
22,460.32
60.427.00
37,745.25
22,681.75
HOUSING PROGRAMS
ACTIVITY TOTAL
1,637,642.00
1,520,976.59
116,665.41
1,883,120.60
1,171,028.22
712,092.38
COMMUNITY DEVELOPMENT:
ENGINEERING
6,000.00
6,000.00
6,000.00
6,000.00
ACTIVITY TOTAL
6,000.00
6,000.00
6.000.00
6,000.00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS
COMMUNITY PROJECTS
17,581.00
17,581.00
39,556.00
29,791.00
9,765.00
PARKS
136,587.00
75,525.71
61,061.29
50,349.43
50.349.43
STREET CONSTRUCTION /IMPROVEMENT
1,204,569.00
77,398.56
1,127,170.44
1,257,617.38
547,435.59
710,181.79
ACTIVITY TOTAL
1,358,737.00
152,924.27
1,205,812.73
1,347,522.81
577,226.59
770,296.22
T 0 T A L EXPENDITURES
4,034,100.00
2,301,158.92
1,732,941.08
4,176,078.19
2,370,978.68
1,805.099.51
EXCESS REVENUE (EXPENDITURES)
237,765.00
767,189.06
(529,424.06)
(8,869.73)
962,378.84
(971,248.57)
TRANSFER IN FROM OTHER FUNDS
(1,097.00)
1,097.00
TRANSFERS OUT TO OTHER FUNDS
1,097.00
(1,097.00)
21,788.59
6,600.00
15.188.59
REVENUES OVER (UNDER) EXPENDITURES
237,765.00
767,189.06
(529.424.06)
(30,658.32)
955,778.84
(986,437.16)
*** * ** *EXPENDITURES * * * * * **
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG
THE
CITY OF DUBLIN
STATEMENT SHOWING
57.438.24
262,370.43
2 2 l/•C�
182.689.78
REVENUES VERSUS EXPENDITURES
ACTIVITY TOTAL
319,000.00
261,561.76
57,438.24
FOR THE
PERIOD
182,589.78
79,780.65
TRANSPORTATION
07/01/2006 THROUGH
04/30/2007
SPECIAL
ASSESSMENT
PUBLIC WORKS
FUNDS
1,597.54
872.46
CURRENT
CURRENT
1,686.54
PRIOR
408.96
PRIOR
STREET TREE MAINTENANCE
31.173.00
BUDGET
ACTUAL
VARIANCE
FISCAL YEAR
Y.T.D.
VARIANCE
* * * * * ** *REVENUES * * * * * * **
6,313.83
STREET LANDSCAPE MAINTENANCE
404,790.00
211.946.49
192,843.51
SPECIAL BENEFITS ASSESSMENTS
737,494.00
583,715.23
153,778.77
645.230.59
101.846.25
580.129.33
ACTIVITY TOTAL
65,101.26
USES /MONEY & PROP- INTEREST
17,137.00
17.512.42
(375.42)
17,139.71
350,854.89
10,053.42
242.285.85
7,086.29
OTHER SOURCES OF REVENUE
9,700.00
3,219.91
6.480.09
5,603.48
5.603.48
TOTAL REVENUE
764,331.00
604.447.56
159.883.44
667,973.78
595,786.23
13,100.00
72,187.55
*** * ** *EXPENDITURES * * * * * **
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG
319,000.00
261.561.76
57.438.24
262,370.43
182.689.78
79,780.65
ACTIVITY TOTAL
319,000.00
261,561.76
57,438.24
262,370.43
182,589.78
79,780.65
TRANSPORTATION
PUBLIC WORKS
2,470.00
1,597.54
872.46
2,095.50
1,686.54
408.96
STREET TREE MAINTENANCE
31.173.00
9,985.57
21,187.43
19,407.11
13,093.28
6,313.83
STREET LANDSCAPE MAINTENANCE
404,790.00
211.946.49
192,843.51
329,352.28
227.506.03
101.846.25
ACTIVITY TOTAL
438,433.00
223,529.60
214,903.40
350,854.89
242.285.85
108.569.04
COMMUNITY DEVELOPMENT
ENGINEERING
13,100.00
358.50
12,741.50
11,357.60
11,357.60
ACTIVITY TOTAL
13,100.00
358.50
12,741.50
11,357.60
11,357.60
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
18,106.69
18.106.69
STREET CONSTRUCTION /IMPRVMNT
75,000.00
75,000.00
ACTIVITY TOTAL
93.106.69
18,106.69
75.000.00
T 0 T A L EXPENDITURES
770,533.00
485,449.86
285.083.14
717.689.61
454,339.92
263,349.69
EXCESS REVENUE (EXPENDITURES)
(6.202.00)
118,997.70
(125.199.70)
(49,715.83)
141,446.31
(191,162.14)
REVENUES OVER (UNDER) EXPENDITURES
(6,202.00)
118.997.70
(125,199.70)
(49,715.83)
141.446.31
(191.162.14)
* * * * * ** *REVENUE * * * * * * **
USES /MONEY & PROP- INTEREST
OTHER SOURCES OF REVENUE
TOTAL. REVENUE:
* * * * ** *EXPENDITURES * * * * * **
GENERAL GOVERNMENT ACTIVITIES:
NON- DEPARTMENTAL
CITY ATTORNEY
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS
ACTIVITY TOTAL
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 04/30/2007
CAPITAL IMPROVEMENT FUNDS
CURRENT CURRENT PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR
23Ob 2ttp
PRIOR
Y.T.D. VARIANCE
1.444,942.00 1.588,698.60 (143,756.60) 1,286.165.31 787,428.16 498,737.15
21,267,707.00 6,725,488.45 14,542.218.55 17,143,271.43 12,627,146.66 4,516,124.77
22,712,649.00 8,314,187.05 14,398.461.95 18,429.436.74 13,414.574.82 5.014,861.92
39.525.20 (39.525.20)
52,250.00 57,794.59 (5,544.59)
52,250.00 97,319.79 (45,069.79)
75,050.34 75.050.34
56,509.63 39,140,47 17,369.16
131,559.97 39,140.47 92.419.50
864,070.00 254,993.14 609.076.86 327,654.70 218.563.41 109,091.29
864,070.00 254,993.14 609,076.86 327,654.70 218,563.41 109,091.29
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
31,220.00
16,751.50
14.468.50
59.380.81
39.700.81
19.680.00
COMMUNITY IMPROVEMENTS
PARKS
1.738,504.00
371,678.54
1.366,825.46
9.102,130.25
3.596,612.09
5,505,518.16
STREET CONSTRUCTION /IMPROVEMENT
32.653,594.00
3.477,508.45
29,176,085.55
5,109.251.49
1,450,875.84
3.658,375.65
ACTIVITY TOTAL
34,423,318.00
3.865.938.49
30,557,379.51
14,270,762.55
5,087,188.74
9.183.573.81
T 0 T A L EXPENDITURES
35.339,638.00
4,139,201.02
31,200,436.98
14,729,977.22
5,344,892.62
9,385,084.60
EXCESS REVENUE (EXPENDITURES)
(12.626.989.00)
4,198,491.68
(16.825,480.68)
3.706.059.52
8,099.787.85
(4,393,728.33)
TRANSFER IN FROM OTHER FUNDS
23,505.65
(23,505.65)
6,600.00
30,105.65
(23,505.65)
TRANSFERS OUT TO OTHER FUNDS
39,525.20
(39,525.20)
REVENUES OVER (UNDER) EXPENDITURES(12,626.989.00) 4,158,966.48 (16.785.955.48) 3.706,059.52 8.099,787.85 (4,393.728.33)
THE CITY OF DUBLIN STATEMENT SHOWING [ Z�
REVENUES VERSUS EXPENDITURES E
FOR THE PERIOD
07/01/2006 THROUGH 04/30/2007
TRUST /AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
* * * * * ** *REVENUES * * * * * * **
SPECIAL ASSESSMENTS
174.662.43
(174,662.43)
242,044.14
206,684.48
35,359.66
USES /MONEY & PROP- INTEREST
9,695.20
(9,695.20)
9,505.83
5,659.36
3.846.47
TOTAL REVENUE
184,357.63
(184,357.63)
251,549.97
212,343.84
39,206.13
* *** ** *EXPENDITURES * * * * * **
GENERAL GOVERNMENT ACTIVITIES:
NON- DEPARTMENTAL
230,503.00
229.015.00
1,488.00
231,731.25
230,506.25
1.225.00
ACTIVITY TOTAL
230,503.00
229,015.00
1,488.00
231,731.25
230,506.25
1,225.00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES
230,503.00
229,015.00
1,488.00
231,731.25
230,506.25
1,225.00
EXCESS REVENUE (EXPENDITURES)
(230.503.00)
(44,657.37)
(185,845.63)
19.818.72
(18.162.41)
37,981.13
REVENUES OVER (UNDER) EXPENDITURES
(230,503.00)
(44,657.37)
(185.845.63)
19.818.72
(18,162.41)
37,981.13
* * * **** *REVENUES * * * * * * **
USES /MONEY & PROP- INTEREST
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
* * * * ** *EXPENDITURES * * * * * **
GENERAL GOVERNMENT ACTIVITIES
NON- DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
FIRE
ACTIVITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T O T 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 ✓ �i�[J'
FOR THE PERIOD
07/01/2006 THROUGH 04/30/2007
INTERNAL SERVICE FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
407,294.00
358,963.83
48.330.17
267.035.82
172.855.73
94,180.09
1,784.731.00
1.309,449.25
475,281.75
1,790,982.80
1,491,131.14
299,851.66
19.800.00
10,046.58
9;753.42
939,048.36
31,510.00
907,538.36
2.211,825.00
1.678,459.66
533,365.34
2,997,066.98
1,695.496.87
1.301,570.11
2,043.020.00 498,780.91 1,544.239.09 2,908,427.37
2,043,020.00 498,780.91 1,544,239.09 2,908,427.37
512,908.28 2,395,519.09
512,908.28 2.395.519.09
30,048.81 (30,048.81)
30.048.81 (30.048.81)
2,043,020.00 498,780.91 1,544,239.09 2,908,427.37 542,957.09 2,365.470.28
168,805.00 1,179,678.75 (1,010,873.75) 88,639.61 1,152,539.78 (1.063,900.17)
REVENUES OVER (UNDER) EXPENDITURES 168,805.00 1,179.678.75 (1.010,873.75) 88,639.61 1,152,539.78 (1,063,900.17)
THE
CITY OF DUBLIN STATEMENT SHOWING
-j4
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 04/30/2007
ENTERPRISE
FUND
CURRENT
CURRENT PRIOR
PRIOR
BUDGET
ACTUAL VARIANCE FISCAL YEAR
Y.T.D. VARIANCE
** * * * ** *REVENUES * * * * * * **
USES /MONEY & PROP- INTEREST
TOTAL REVENUE
* * *- ** *EXPENDITURES * **** **
GENERAL GOVERNMENT ACTIVITIES:
NON- DEPARTMENTAL
20.00
20.00
FINANCE
ACTIVITY TOTAL
20.00
20.00
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T O T A L EXPENDITURES
20.00
20.00
EXCESS REVENUE (EXPENDITURES)
(20.00)
(20.00)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES
(20.00)
(20.00)