HomeMy WebLinkAboutItem 4.03 FinancialRptsNov2004
CITY CLERK
File # D[3]~lOJ-[5 ~
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: January 4,2005
SUBJECT:
Financial Reports for the Month of November 2004
Report Prepared by: Carole A. Perry, Administrative Services
Director and Fred w: Marsh. Finance Manager
ATTACHMENTS:
YTD Revenues and Budget Comparison
YTD Expenses and Budget Comparison
Financial Statements for the Month of November 2004
1.
2.
~.
RECOMMENDATION:~' Receive the reports.
FINANCIAL ST A TEMQT: See reports for detail of monthly financial activity.
DESCRIPTION:
This item provides the report on the preliminary financial statements for the month of November 2004.
The final audited results for Fiscal Year 2003-2004 are not yet available; therefore, this report is presented
as "preliminary" at this time. Consistent with prior reports, the focus wil1 be on General Fund Revenues
and Expenditures, which represent the most significant portion of the City's operations.
Note that the City's revised budget has now accounted for all items affecting the City as part of the State's
adopted budget for Fiscal Year 2004-2005. Agenda reports were previously presented to Council that
discussed the impacts ofthe State Budget for Fiscal Year 2004-2005 in more specific detail, ineluding the
significance of the passage of Proposition IA.
Analvsis of November 2004 Revenue and Exnenditure Rcnort
The aùditors have finished the final phase of the fieldwork necessary for the Fiscal Year 2003-2004 audit.
The final audit results will impact the reported Fund Balance presented in the attached monthly reports.
Staff expects to bring the annual audit results to City Council in February 2005. That report will inelude
the full financial statements prepared by the City's independent auditors for Fiscal Year 2003-2004.
Givcn November is only the fifth month of the Fiscal Year, there is limited data on which to base any
major projections or identifY significant trends. 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,
ineluding Police and Fire Services.
General Fund Revenues
Total General Fund Revenues collected through November are comparable to what occurred in the fifth
month of the previous Fiscal Year. Through November 2004, the City had collected approximately 28%
of the total budgeted General Fund Revenues, which was 3% more than the percentage collected in the
prior Fiscal Year.
____________________________________.______~_~._______________________________~__~__________________________M
COPIES TO:
Document in FSCOLOR 11-2004
IOb~
ITEM NO.
4-.~
w
Sales Tax is lower than in the same period of the prior year due to the "triple flip" reduction by the State.
The State will remit V. less sales tax to the City; to be reimbursed through property tax, under the "triple
flip" provision (NOTE: this reduction was incorporated into the City's adoptcd budget). Real property
transfer taxes are higher than in the same period of the prior ycar due to timing differences in thc
collection of these taxes and two large transfers of properties by residential and commercial developers
that were recorded in November. Transient Oeeupancy Taxes are higher than in the same period of the
prior year due to higher occupancy rates and room rates at some of the City's hotels.
Licenses and Pennits are higher than in the same pcriod of the prior year due to an increase in the
valuation of building pennits on new residential and commercial projects. Interest and Rentals received to
date are higher than the prior year due to timing differences in the receipt of interest payments and an
inerease in the rate of return on the City's investments. Initially all interest revenue is recorded in the
General Fund and is then allocated quarterly to other funds on a pro rata basis.
Intergovernmental revenue is higher than in the prior year, when viewed strictly as a percentage
comparison. However, the actual revenue dollars are lower than in the same period ofthe prior year due
to the cuts to the VLF allocation that were implemented by the State, as part of the approved State Budget
for Fiscal Year 2004-2005. Since these changes were anticipated by Staff, they were ineluded as part of
the City's adoptcd budget plan. Charges for Services are higher than in the same period of the previous
year due to additional zoning and subdivision fees and plan check and inspection fees received due to new
development.
Fines and ForfeiÜlres are higher than in the same period of the previous year due to timing differences in
the collection of parking and court fines. Other revenues are higher than in the same period of thc prior
year due to developer reimbursements received for the costs of maintaining new stonn drains and
reimbursements received from the City of Pleasanton for the design of improvements to the Fallon Road
Interchange.
General Fund Expenditures
Overall, through the month of November, expenditures in the General Fund totaled $8.6 million and
represented approximately 19% of the total budgeted expenditures in the General Fund. Of this amount, a
total of approximately $1,410,000 was related to Capital Improvement Projects and the remainder was
related to Operating Costs reported in the General Fund. Capital Project expenditures typieally do not
follow an even distribution due to differences in project timing.
In looking only at General Fund Operating Expenditures, the activity through November 2004 was lower
than the amounts expended for the same period in the prior Fiscal Year. Through the end of November
2004, the City had expended 19% of the General Fund Operating Budget, which was 6% less than the
amount expended in the prior Fiscal Year. Fire is lower than in the same period of the prior year due to
timing differences in the payment for contract fire services. Health and Welfare is higher than in the same
period of the prior year due to expenditures incurred for the evaluation of contraetor proposals submitted
for waste management services.
Capital Improvement Project expenditures are higher than in the same period of the previous year due to
expenditures incurred on the construction of the new senior center. As previously noted tllere are some
timing differences with payment for contraet services, which complicate comparisons ITom one year to the
next.
All expenditures are within the authorized hudget. It is recommended that the City Council receive these
reports as authorized by Section 41004 of the California Government Code.
~'b~
·------...
'of.) 13'
City of Dublin 2004-2005 YTD Revenues and Budget Comparison
Total General Fnnd Rcvenues .or.the.. eriod..Eu ing Novc hcr 30, 004........ """1
I
i
Property Taxcs
Sales Taxes
Real Property Transfcr Tax
TransIent Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental from State
Charges for Services
Fines and Forfeitures
Othcr Revenues
85%
67%
72%
37%
0%
60%
90%
30%
42% of Year Complete
FY 2004105 FY 2004105 %of
Budget YTD Actual Budget
Property Taxes 13,661,980 635,551 5%
Sales Taxes 13,613,216 4,054,138 30%
Real Property Transfer Tax 520,000 325,690 63%
Transient Occupancy Taxes 610,000 233,516 38%
Franchise Taxes 1,536,000 340,209 22%
Licenses and Permits 2,723,912 2,315,283 85%
Interest and Rentals 1,538,090 1,025,931 67%
Intergovernmental 449,100 324,183 72%
Charges for Services 5.177,916 1,938,554 37%
Fines and Forfeitures 112,900 55,089 49%
Other Revenues 951 ,837 353,094 37%
Total General Fund Revenues 40.894,951 11,601,238 28%
[JIII.P,ri~.1:;>.'1C1/"2004~~7PM
-~
120%
150%
FY 2003/04
YTD Actual
633,580
4,784,997
220.651
221,849
319.653
1,540,981
302,108
416,225
1,436,901
33,889
42,936
9.953,770
-"...._----
. FY 2004/05
.. FY?Q91i04 I
~
% of Total for
FY 2003/04
6%
34%
39%
33%
21%
50%
48%
23%
30%
29%
5%
25%
1- ~- 06 ~,~
ATTACHMENT 1
._n.._u...__._.__.._
------.....-..
--.----...--.
?~13
City of Dublin 2004-2005 YTD Expenses and Budget Comparison
For he Peri0Ø-- Novemb r 30,2
% I
24%
Total Ceneral Fnad
Expenses
General Government
Police
Other Pnblie Safety
Transpnrtatloo
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
pmjeets
Fire
28%
ì'-.Fy 2004./05 I
I II FY 2003~
0%
40% 60% 80%
42% nfVear Complete
100%
120%
20%
---...-.---..
2004/05 2004/05 %of FY 2003t04 % of Total for
Budg,!!- YTD Actual Budget YTD Actual FY 2003/04
General Government 4.964,972 1,567,434 32% 1,454,199 31%
Police 9,882,259 471,612 5% 395,575 5%
Fire 8,156,645 187,133 2% 2,093,865 28%
Other Public Safety 421,298 39,054 9% 22,036 6%
Transportation 1,690,651 503,296 30% 473,891 31%
Health and Welfare 78,125 38,086 49% 34,653 42%
Culture and Community Services 5,863,186 1,888,663 32% 1,787,511 35%
Community Development 7,807,374 2,518,555 32% 2,148,516 34%
Capital Improvement Projects 5,874,231 1,414,594 24% 798,057 17%
..-
Total General Fund Expenses 44,738,741 8,628,427 19% 9,208,303 24%
General Fund Operating Expenses 38,864,510 7,213,833 19% 8,410,246 25%
l;IoloPrlntod'1J/2IJ:zoo.I2'4IIPM
ATTACHMENT 2
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF NOVEMBER 2004
Prepared by
The Finance Department
December 10, 2004
3"t) I)
ATTACHMENT 3
4abl2
CITY OF DU8L1 N
8ALANCE SHEET
FOR THE
PERIOD ENDING 30Nov2004
GENERAL SPECTAL SPECIAL CAPITAL TRUST / TOT A L S
REV¡NUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY-·-
FUNDS FUNDS fUNDS FUNDS FUND CURRENT PR lOR
ASSETS
CASH (48.556.680) 3.233.679 229,462 39.299,821 19.610 (5,774,108) (21.859.626)
CASH W ITII FISCAL AGENT 172,779 172.779 172.312
AMOUNT HELO IN ESCROW
INVESTMENTS AT COST 9B.215,420 98,215.420 96,342,992
RECEIVABLES; TAXES
ACCOUNTS 23.14B 179.884 203.031 IB4,D20
INTEREST 496.242 496.242 200,330
ASSESSMENTS
DUE fROM OTHERS 1. 989.267 1. 9B9, 267 308.720
INVENTORY AT COST
PRE PAlO ITFMS 11 ,933 11 , 933 4.324
FIXED ASSETS 4.500.000 4,500,000
flMOUNI TO BE PROVIDED 1. 334,500 1. 334,500 1. 447 . 500
TOTAL ASSETS 52.1/9,329 3.413.563 229,462 43.799.821 1. 526. BB9 101.149,064 76.800.573
LIABILITIES/FUND EOUITY
OEPOSIT5 FOR PRIVATE DLVEL (965.256) (965,256) (1.004.962)
DEPOSITS FOR AB1600 FEES (151.104) (165.943) (317,047) (6,535,062)
DEPOSITS OTHERS (2.489.119) (2.4B9,119) 0.129.237)
PAYABLES, ACCOUNTS (218.181) (61,416) 071.207) (450,B03) (1.070.227)
INTEREST
PAYROLL (511,B42) (511.B42) (51B.I27)
DUE TO OTHERS (l45.083) (160.054 ) (1,829.213) (2,134.350) (436.136)
DEFERRED REVENUE (127.76B) (127.76B) (127.76B)
DEBT INSTRUMENTS PAYABLE (1.452.000) (1.452 . 000) (l.565,000)
TOTAL LIABILITIES (4,60B,353) (221.470) (2,166,363) 0.452.000) (8.448,185) (12.386,520)
FUND BALANCES (47,570.977) (3.192.093) (229,462) (41.633.458) (74.889) (92.700.879) (64 .414.053)
TOTAL FUNO E (47,570.977) (3,192.093) (229,462) (41.633.458) (74.889) (92.700.B79) (64.414,053)
TOTAl, LlABILITIES/EOUITY (52,179.329) (3,413.563) (229,462) (43.799,821) (1.526.889)(101.149.064) (76,800,573)
~'t>I:?
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Ncv2004
INTERNAL ENTERPRISE FIXED ASSETS GFNERAL LONG TOTALS
SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM---
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR
ASSETS
CASH 8,270,994 20 8.271,014 7,441.404
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAIO ITEMS
FIXED ASSETS 46, 51I. 915 39.208,244 85.720.159 66,732,089
AMOUNT TO 8E PROVIDED 66,153.945 66.753.945 68.709,959
TalAL ASSETS 54.782.909 20 39.208,244 66.753.945 160.745.1I7 142,883,453
LIABILITIES/FUND EOUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR ABI600 FEES
DEPOSITS OTHFRS
PAY ABLES: ACCOUNTS (!7 .215)
INTEREST
PAYROLL
DUE TO OTfIERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (66.753,945) (66.753.945) (68.709.959)
TOTAL LIABILITIES (66.753,945) (66.753,945) (68,727.174)
FUND BALANCES (54.782,909) (20) (39,208.244) (93,991,172) (74,156.278)
TOTAL FUND E (54,782,909) (20) (39,208,244) (93.991.172) (74,156.278)
TOTAL LIABILITIES/EOUITY (54,782,909) (20) (39.208,244) (66.753,945) (160.745.117)(142,883.453)
THE CITY OF DUBLIN STATEMENT SHOWING ~~
REVENUES VERSUS EXPENoITURFS
FOR THE PERIOD
o7/D1/2DD4 THROUGH 11/3D/2004
G ENE R A L REV E N U E FUN 0
CURRENT CURRENT PRIOR PR IOR
BUDGET ACTU^L VARIANCE rlSCAL YEAR Y.T.D. VARIANCE
*******REVENUES*******
PROPERTY T^XES 13.661. 980.00 635.55D84 13.D26,429.16 11.316.703.32 633 . 580 .48 1D,683.122.84
SALES TAX 13.613.216.DD 4.D54.138.35 9.559.077.65 13.94D.263.36 4.784,997.43 9.155.265.93
REAL PROPERTY TRANSFER TAX 52D.DDD.DD 325.690.33 194.3D9.67 571. 36D.79 220.651-33 35D. 7D9.46
HOTEL TRANSIENT OCCUPANCY TAX 610,000.00 233.515.89 376.484.11 664.308.51 221. 849.04 442.459.47
FRANCHISE TAXES 1.536.DDD.00 340.2D8.77 1.195.791. 23 1.505.434.53 319,653.08 1.185.781.45
LICENSES & PERMITS 2.723,912.DO 2.315.283.49 4D8.628.51 3,D90.992.17 1 . 54D. 981-37 1.55D.010.8D
FINES & FORFEITURES 112. 9DD. DD 55.D88.63 57.811 . 37 117 . 369.48 33,889.D3 83 .480 .45
USE/MONEY & PROP· INTEREST 1.369.725.DD 994,D20.99 375.704D1 492.971.23 248.322.21 244.649.D2
USE/MONEY & PROP-RENTALS 168,365.DO 31. 910.08 136.454 92 130.741.40 53.785.74 76.955.66
INTERGOVERNMENTAL 449.100.00 324.182.97 124,917.03 1.828.992.93 416,225.29 1.412.767.64
CHARGES FOR SERVICES 5.177.916.DD 1.938,554.14 3.239.36186 4.801.136.74 1. 436.901-24 3.364.235.50
OTHER SOURCES OF REVENUE 951.837.00 353.093.85 598.743.15 860.434.13 42.936.39 817,497.74
TOTAL REVENUE 40.894.951.00 II . 601. 238.33 29,293,712.67 39.320.708.59 9.953,772.63 29.366.935.96
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES,
CITY COllNCIL 252.91000 69.746.78 183,163.22 209.858.23 71 .658. 93 138.199.30
CITY MANAGER 928.273 00 341. 923. D4 586.349.96 817 .034.42 298,279.43 518.754.99
CENTRAL SERVICES 35D.9ll.DO ll9. 961. II 230.949.89 341. 914.49 112.122.73 229.791. 76
CITY ATTORNEY 689.493 00 125.813.27 563.679.73 700.79795 97.6DO.67 6D3.197.28
AOMI N SERV ICES 1. 557 . 095 00 515.952.19 1. 041.142.81 1.244.537.07 458.453.14 785.083.93
8UILDING MANAGEMENT 641.134.00 206.292.24 434.841.76 757.522.95 212.731. D3 544.791. 93
INSURANCE COST CENTER 358.985.00 187.321. 3D 17l.654.70 420. D6197 202,338.73 217.723.24
ELECTIONS cosr CENTER 15,67D.DD 42375 15.246.25 2,541.41 1.014.7D 1.526.71
NON-DEPARTMENTAL 170.500.DO 170,500.00 125.55616 125.656.16
ACTIVITY TOTAL 4.964.972.DD 1.567.433.68 3.397.538.32 4.619,924.66 1.454.199.36 3.165.725.3D
PUBl.I C SAFETY
POll CE 9.882.259.00 471.612.24 9,410.646.76 8.570.93709 395,574.62 8.175.362.47
CROSSING GUARDS 72,283.00 13.93642 58.345.58 65.794.14 11.536.5D 54.157.64
ANIMAL CONTROL 266.362.00 266,362.00 198.95352 (9,547.DD) 208.500.52
TRAFFIC SIGNALS & STREET LIGHTIN 17.24D.00 2,442.95 14.797.05 6.543.33 188.36 6.354.97
DISASTER PREPAREDNESS 65,413.00 22.67480 42.738.2D 70,993.74 19.758.37 51. 235.37
FIRE SERVICES 8.156.645.DO 187.133.23 7,969,511.77 7.440.483.12 2.D93,864.53 5.346.618.59
ACTI V ITY TOTAL 18.460.202.DD 697,799.64 17.762 .4D2 .36 16.353.704.94 2.511.475.38 13.842.229.56
TRANSPORTATION
PUBLIC WORKS 738.575.DD 256.81D.25 481.764.75 586.88145 248.110.06 438.77139
STREET MAINTENANCE 14.802.DD llO.50 14.591-50 3.7D3.99 202.30 3.5D1.69
STREET SWEEPING 149.207.DD 34.393.04 114.813.96 13D,351.29 32.056.78 98,294.51
STREËT TREE MAINTENANCE 97,352.00 11.534.64 85.817.36 117.583.47 38.931. 58 78,651.89
STREET LANDSCAPING MAINTENAN 690.715.00 200.448.02 490.266.98 593.488.01 154,590.24 438.897 77
ACT! V ITY TOTAL 1.69D.65100 503 . 296.45 1.187,354.55 1.532.008.21 473,890.96 1.058.1l725
HEAL TH & WELFARE
WASTE MANAGEMENT 63.125DD 38.D8551 25.03949 46.419.D4 2.DOO.00 44.41904
CHILD CARE 15.00D.00 15.DDDDD 18,500.00 18.50D.00
SOCIAL SERVICES 1.00D.DO 1. DOO. 00
HOUSING PROGRAMS 16,893.18 13.153.18 3.740.DO
lOb I»
THE CITY OF DU8LIN STATEMENT SHOWING
REVENUES VERSUS EXPENOITURES
FOR THE PERIOD
07/0172004 THROUGH 1173072004
G ENE R A L R [ V E N U E FUN 0
CURRENT CURRENT PRIOR PR lOR
8UDGET ACTUAL VARIANCE FISCAL YEAR Y,T,D. VARIANCE
ACTIVITY TOTAL 78,125,00 38.085,51 40.039.49 82.81222 34,653.18 48,159.04
CULTURE & LEISURE SERVICES
LI8RARY SERVICES 582,73000 142.129.43 440.600.57 522.604,10 133,888.81 388.715 29
CUL TURAI. ACTlV1T1ES 159.718 00 44,645.48 115,072,52 110.24930 64,824.27 45.425.03
HERITAGE CENTER 141.355,00 42.196,92 99.158.08 99.628.11 37,487.30 62,140,81
DU8LI N CEMETERY 53.60200 12.816.04 40.785.96 53,533,84 8,071-70 45.46214
PARK MAINTENANCE 1. 532 .409 00 437.273.57 1,095,135,43 1.403.774.51 392,644.58 1.011.12993
COMMUNITY TV 62,999,00 55.899.00 7.100.00 62.020.72 56,941.18 5,079,54
RECREAlION ADMIN 638.56400 217.142.07 421.421. 93 518.312,54 190,093.00 328.21954
PLAYGROUNDS 277 , 082 , 00 101. 985,19 175.096.81 237.599.33 94,212.81 143,386,52
SHANNON CENTER 389.176,00 133.248.33 255.927.67 294.742.36 101. 403.52 193.33884
PRESCHOOL 90.699.00 30.563.79 60,135.21 77,388,27 27,149.59 50.238 68
TEENS PROGRAM 118.941.00 30.379,90 88.561.10 86.212.99 29,984.19 56,228,80
ADULT SPORTS 110.559,00 36.810.74 73.748.26 101.640.17 42,564.06 59.07611
YOUTH SPORTS 138.824 00 34.59207 104,231.93 122.764.81 37.632.70 85.132,11
COMMUNITY GYM 46,504,00 8,713,36 37.790.64 37.309.40 7,862.02 29.447,38
EMERALD GLEN ACTIVITY CENTlR
SPECIAL EVENTS 339.220,00 137,136,29 202.083.71 348.052.22 160.953.31 187,098,91
SENIOR CENTER 297.455.00 87,339.63 210.115.37 223.784.61 75,308.94 148.47567
RECREATION INSTRUCTION 195.220.00 74,889.86 120,330,14 185.369.65 81.710.17 103.659,48
AOUATICS 407,136,00 165,951. 33 241.184.67 366.568.40 156,109,26 210.459,14
PARKS/FACILITIES MANAGEMENT 280.993.00 94,949.76 186.043.24 246,546,42 88 , 669 .46 157.87696
ACTIVITY TOTAL 5,863.186.00 1. 888,662.76 3.974.523,24 5.098.101-75 1.787,510.87 3,310,590,88
COMMUNITY DEVELOPMENT
PLANNING 2,731.301. 00 917 .195.68 1.814,105,32 2.211.403.13 732.572.19 1. 538.830.94
8UILOING SAFETY 2,580.214,00 738,698,14 1. 841.515 86 1.907.2]].35 596.587.04 1.310,624,31
ENGINEERING 2,209.633.00 718.336.33 1.491.296,67 1. 861. 971. 85 656.551.12 1.205.420.73
ECONOMIC OEVELOPMENT 286.226.00 144,324,35 141.901.65 302.134.33 162,806.12 139.328,21
ACTIVITY TOTAL 7,807.374.00 2.518,554.50 5.288.819.50 6.342.720.66 2,148.516.47 4.194.204.19
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 1.043.120.00 206,195,80 836.924.20 1.163.181. 54 50,962.00 1.]]2.219.54
COMMUNITY IMPROVEMENTS 799.839.00 18,788.31 781. 050.69 718,087.36 178.540.68 539.546.68
PARKS 2,619.129.00 940,581.l! 1.678.547,89 1. 831. 348.20 277 . 751. 96 1.553,596.24
STREET CONSTRC/IMPROVEMENTS 1. 412 ,143,00 249,028,76 1.163.l!424 938.789.96 290,801. 95 647,988.01
ACTIVITY TOTAL 5,874,231-00 1.414,593.98 4.459.63702 4,651.407.06 798.056.59 3.853,350.47
TOTAL EXPENDITURES 44,738.741.00 8.628,42652 36,]]0,314,48 38.680,679.50 9,208.302,81 29,472,376,69
EXCESS REVENUE (EXPENOITURES) (3,843.790.00) 2.972,8]],81 (6.816,60181) 640,029.09 745.469,82 Cl05, 440.73)
TRANSFERS IN FROM OTHER FUNDS 21. 885 .10 21,885.10
TRANSFERS OUT FROM OTlIER FUNDS (20.00) (20,00)
REVENUES OVER(UNOER) EXPENDITURES (3,843.790.00) 2.972,811.81 (6,816,601.81) 661.894.19 745.469,82 (83,575,63)
ßtb !>
THE CITY OF OUBUN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 11/30/2004
S P E C I A L REV E N U E FUNDS
CURRENT CURRENT PR lOR PRIOR
BUcx:;n ACTUAL VARIANCE F I seAL YEAR Y.T.D. VARIANCE
********REVENUES********
PRDPER IY TAXES 1ll,049.00 Ill. 049.00 105,605.41 105,605.41
SALES TAXI OTHER TAXES 336,500.00 5B.572.16 277.927.84 357,441. 52 91. 059 . 68 266, 3B1. 84
FINES & FORFEITURES 164,000.00 23,500.71 140.499.29 154.784,03 39,480.67 115,303,36
USES/MONEY & PROPERTY 89, 24B, 00 89.248,00 29.822.10 14.494.78 15,327.32
INTERGOVERNMENTAL FROM STATE 1.188.010.00 434.173.94 753.83606 2.590.8B5,16 715,243.21 1. 875,641. 95
INTERGOVERNMENTAL FROM COUNTY 306.890.00 306.89000 269.14900 26,046.50 243,102.50
INTERGOVERNMENTAL FROM FEDERAL 97,718.00 2.790.99 94,927,01 253.13922 18,124.14 235,015.0B
CHARGES FOR SERVICES 1.056.723.00 1.056.723,00 988.833,16 988,833,16
OTHER SOURCES OF REVENUE 160.500.00 4,518.35 155.98165 291.518,00 291. 518,00
TDTAL REVENUE 3,510,638,00 523,556.15 2,987,081,85 5.041.177.60 904,448,98 4,136.728 62
*******EXPENDITURES*******
PUBLI C SAF E TY :
POLICE 121560 00 3,120,12 118.439.88 161.487.38 12.917.15 148,570,23
TRAFFIC SIGNALS & STREET LTG 217.596,00 36.09953 181.496.47 143.45104 42,659.51 100.79153
DISASTER PREPAREDNESS 8,179,22 2.175.00 6.004,22
FIRE SERVICES 287.626.00 2,588,18 285,037.82 211.138.48 27.068.67 184.069.81
ACTIVITY TOTAL 626,782.00 41807.83 584,974,17 524.256.12 84,820.33 439.435 . 79
TRANSPORTATION:
STREET MAINTENANCE 301750.00 34.764.43 266.985.57 216,334.44 43,581.66 172.752.78
STRElT SWEEPING
ACTI V ITY TOTAL 301750.00 34.764.43 266.985.57 216,334.44 43.58166 172 .752 ./8
HEALTH & WELFARE:
WASTE MANAGEMENT 1.346.244.00 10,543,10 1.335.700.90 1248,019.76 5.400.37 1.242,619.39
SOCIAL SERVICES 44,927.00 9.166.18 35.760,82 44,935.00 11.795.76 33.139.24
HOUSING PROGRAMS
ACTIVITY TOTAL 1.391.17I.00 19.709,28 1.37146172 1.292,954,76 17 .196.13 1.275.758.63
COMMUNITY OEVELOPMENT:
ENGI N(ER! NG 6.000,00 568.50 5.431. 50 6.000,00 6,000.00
ACTI V ITY TOTAL 6.00000 568.50 5.43150 6.00000 6,000,00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 100.000,00 100,000,00
COMMUNITY PROJECTS 44.92800 44.92800 63.61075 63,670.75
PARKS 321. 717,00 128.500.00 193.217,00 27.928,00 27,928.00
STREET CONSTRUCTION/IMPROVEMENT 673.211.00 62,886,03 610.324.97 2,293.708,38 640.839.19 1652,869.19
ACTIVITY TOTAL 1039.856.00 19I.386 ,03 848.469.97 2,485,307.13 640,B39,19 1.844,467.94
TOT A L EXPENDITURES 3.365,559.00 288.236 07 3,077,322.93 4.524.852.45 792.437.31 3.732,415,14
EXCESS REVENUE (EXPENDITURES) 145,079.00 235.320,08 (90,241-08) 516,325.15 112.011.67 404,313,48
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 21885.10 2188510
REVENUES OVeR (UNDER) EXPENDITURES 145,079.00 235.320.08 (90,24108) 494,440,05 112.011.67 382,428,38
'1't \:7
THE CITY OF DUBLIN STATEMENT SHOWING
REVeNUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 11/30/2004
S P E C I A L ASS E SSM E N T FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMFNTS 639.589.00 639.589.00 593.20241 593,202.41
USES/MONEY & PROP-INTEREST 12,909.00 12,909.00 4.09398 1. 899.06 2.194 92
OTHER SOURCES OF REVENUE 5.00000 5.000.00 144.29 144.29
TOTAL REVENUE 657.498.00 657.498.00 597.44068 2.043.35 595.397.33
*******EXPENDITURES*******
PUBLIC SAFETY,
TRAFFIC SIGNALS & STREET LIG 306.088.00 70.729.75 235.358.25 217.534.35 65,359.05 152.175.30
ACTIVITY TOTAL 306.088.00 70.72975 235,358.25 217.534.35 65.359.05 152.175.30
TRANSPORTATION
PUBLI C WORKS 1.436.00 444.62 991.38 1. 352 .46 579.50 772.96
STREET TREE MAINTENANCE 27.099.00 3.588.28 23.5tO.72 26.752.22 1.214.72 25,537.50
STREET LANDSCAPE MAINTENANCE 344,474.00 94.844.84 249,629.16 296.360.83 72,820.76 223.540.07
ACTIVITY TOTAL 373.009.00 98,877.74 274.131.26 324,465.51 74.614.98 249,850.53
COMMUNITY DEVELOPMeNT
ENGI NEERI NG 12.750.00 6.559.94 6,080.06 15.007.20 8.105.50 6.901.70
ACTIVITY TOTAL 12.75000 6.559.94 6.08006 15.007.20 8.105.50 6.901.70
CAPITAL IMPROVEMENT PROJECTS,
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT 53,9B2.26 53.9B2.26
Acr¡VITY TOTAL 53.98226 53.982.26
TOT A L EXPENDITURES 691.B47.00 176.277 .43 515,569.57 610.98932 148,079.53 462.909.79
EXCESS REVENUE (EXPENDITURES) (34.349.00) (176,277 .43) 141.928.43 (13,548.64) (145.036.i8) 132.4B7.54
REVENUES OVER (UNDER) EXPENDiTURES (34,349.00) (176.27743) 141. 928.43 (13.54864) (146.036.18) 132.487.54
\{)IIb~
THE CITY OF OUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERJOD
07/01/2004 THROUGH 11/30/2004
CAP I TAL IMP R 0 V E MEN T FUN D S
CURRENT
BUDGET
CURRENT
ACTUAL
VARIANCE
PRJOR
FISCAL YEAR
PR IOR
Y.T.D.
VARIANCE
********REVENUEW*******
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
810.154.00
18.631. 900.00
19,442,054.00
10,131.803.55
10.131.803.55
810.154.00
8.500.096.45
9.310,250.46
330.842.99
13.455.275.26
13.786.118.25
159.451. 55
111.391-44
13,455.275.26
13.626.666.70
159.451-55
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY ATTORNEY 55.300.00 396.00 54.904.00 92.493.49 2.395.44 90.098.05
ACTIVITY TOTAL 55.300.00 396.00 54.904.00 92.493.49 2,395.44 90.098.05
PUBLIC SAFETY;
TRANSPORTATJON:
HEALTH & WELFARE;
HOUSING PRI)3RAMS 809.41200 59.071.06 750.340.94 2.252.493.88 99.048.80 2.153.445.08
CULTURE & LEISURE SERVICES,
RECREATION AOMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 5.000.00 142.414.57 (137.414.57) 1.007.728.90 1.355.151-97 C347 .423.07)
COMMUNITY IMPROVEMENTS 36.771.00 36.771.00
PARKS 13.582.774.00 214.230.34 13.368.54366 3.543,135.97 1.845.327.73 I. 697,808.24
STREET CONSTRUCTION/IMPROVEMENT 19.124,537.00 303.863.10 18.820,673.90 5.377 .070.50 I. 055.466.47 4.321. 604.03
ACTIVITY TOTAL 32.749.08200 660.508.01 32.088.57399 9.927,935.37 4.255.946.17 5,671.989.20
TOT A L EXPENDITURES 33.613,794.00 719.975.07 32.B93,B18.93 12.272.922.74 4.357.390.41 7.915.532.33
EXCESS REVENUE (EXPENDITURES) (14,171.740 00) 9.411.B28.48 (23.5B3.568.48) 1.513,195.51 C4.197.938.86) 5.711.134.37
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO DTHER FUN OS
REVENUES OVER (UNDER) EXPENDITURESC14.111.740.00) 9.411,828.48 C23.583.568.48) 1.513.195.51 C4.197.938.86) 5.711.134.37
1 ~lp
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
0710112004 THROUGH 1113012004
T R U S T 1 AGE N C Y FUN 0
CURRENT CURRENT PRIOR PRIOR
BUOGET ACTUAL VARIANCE FISCAL YEAR 1.T .0. VARIANCE
********REVENUES********
SPECIAL ASSESSMENTS 233.713.12 233,713,12
USESIMONEY & PROP-INTEREST 1.467.95 354.01 1. 113 . 94
TOTAL REVENUE 235,181. 07 354.01 234.827.06
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITJES,
NON-DEPARTMENTAL 228.196.00 178.997.43 49,19B,57 230.993.50 173,508.25 57.485.25
ACTIVITY TOTAL 228.196.00 178,997,43 49.198.57 230,993.50 173.508.25 57.48525
PU8LIC SAFETY:
TRANSPORTATION,
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES,
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PRWECTS
TOT A L EXPENDITURES 228.196.00 178.997,43 49.198.57 230.993,50 173,508.25 57,485.25
EXCESS REVENUE ¡EXPENDITURES) (228,196.00) (178.99743) (49.198.57) 4.18757 (173.154.24) 177,341.81
REVENUES OVER ¡UNDER) EXPENDITURES (228.196.00) (!l8, 997,43) (49,198.57) 4,187,57 (173.154.24) 177 .341.81
THE cm OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 11/30/2004
r2-'tJ;>
I N T ERN A L S E R V ICE FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUD3ET ACTUAL VARIANCE FISCAL YEAR YT.D. VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST 226.186.00 226.186.00 72 .481. 36 33.799.29 38,682.07
CHARGES FOR SERVICES 1. 733 .474.00 708.78982 1.024.684.18 1.690.762.96 652.532.60 1. 038 . 230.36
OTHER SOURCES OF REVENUE 21.122.00 23347 20,888.53 991. 817 .10 991.817.10
TOTAL REVENUE 1.980.782.00 709.023.29 1.271.758.71 2./55.061.42 686,331. 89 2.068.729.53
****~**EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 2.309.74600 655,152.10 1. 654.593 90 2,231.66178 259.216.15 1. 972.445 63
ACT! V ITY TOTAL 2.309.746. DO 655.152.10 1.654,593.90 2.231.66178 259.216.15 1. 972 . 445 63
PUBLIC SAFETY;
FIRE 66.010.00 66,010.00 57.068.73 57.06873
ACTIVITY TOTAL 66.010.00 66.010.00 57.068.73 57,068.73
TRANSPORTATI ON:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CA~ITAL IMPROVEMENT PROJECTS,
TOT A L EXPENDITURES 2.375.756.00 655.152.10 1720.603.90 2.288,730.51 259.216.15 2,029.514.36
EXCESS REVENUE (EXPENDITURES) (394.974.00) 53.871-19 (448.845.19) 466.330.91 427,115.74 39.215.17
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES (394.974.00) 53.871-19 (448.845.19) 466.330.91 427,115.74 39.215.17
I~I?
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 11/3012004
E N T E R P R I S E FUN 0
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 20.00 20.00
FINANCE
ACTIVITY TOTAL (20.00) 20.00 20.00 20.00
PUBLI C SAFETY,
HEALTH & WELfARE,
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT,
CAPITAL IMPROVEMENT PROJECTS,
rOT A L EXPENOITURES (20.00) 20,00 20.00 20.00
EXCESS REVENUE (EXPENDITURES) 20.00 (20,00) (20.00) (20.00)
TRANSFERS IN FROM OTHFR FUNDS (20.00) (20.00)
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES 20.00 (2000)