HomeMy WebLinkAboutItem 4.11 FinancialReptNov2005
CITY CLERK
File # DL2J~ºJ-[5J~
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: December 20, 2005
SUBJECT:
Financial Reports for the Month of November 2005
Report Prepared by: Fred Marsh, Finance Manager and Lisa
Hisatomi, Administrative Analyst II
ATTACHMENTS: 1. YTD Revenucs and Budget Comparison
2. YTD Expenses and Budget Comparison
3. Financial Statements for November 2005
~y
RECOMMENDATION:~ \: Receivethcreports.
F1NANCIAL ST A TEM~: See reports for detail of monthly financial activity.
DESCRIPTION:
This item provides the report on the preliminary financial statements for the month of Novembcr 2005.
Consistent with prior reports, the focus will be on General Fund Revenues and Expenditures, which
rcprcsent thc most significant portion of the City's operations.
Analvsis of November 2005 Revenue and Expenditure Reports
The Novembcr rcports represent the reporting ofrevenues and expenditures for five months of the Fiscal
Year, through November 30, 2005. 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.
Given 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. The auditors have completed the final phase of the
fieldwork necessary for the Fiscal Year 2004·2005 audit. The final audit results will impact the reported
Fund Balance presented in the attached monthly reports and are expected to be presented to Council in
Jamlary 2006_
General Fund Revenues
Total General Fund Revenucs collected through November are less than what occurred in the fifth month
of the previous Fiscal Year. Through November 2005, the City had collected approximately 24% ofthc
total budgeted General Fund Revenues, which was 3% less than the pCTcentage eollcctcd in the prior
Fiscal Year_ A brief description is providcd below to explain any material revenue variations.
Sales Tax is lower, when compared to the same period in thc prior year, as last year the State delayed
implementation of the Y. percent reduction to sales tax (related to the "Triple Flip") until thc sccond
quarter. The City will receive reimbursements for thesc dcductions from the State as part ofthc property
tax receipts to be received latcr in thc Fiscal Year. Real Property Transfer Tax is lower than in the same
pcriod in the prior year due to timing differences in the receipt of these funds. Franchise Fees are lowcr
___________~_____~w_______________w~~w.__w~_._________-____________________~_________________________________
Docurnellt in FSCOLOR 11-200S.XLS
ITEM NO.
£f.t\
COPIES TO:
Page I of2
than in the samc pcriod in the prior period due to timing differences in the receipt of Garbagc Franchise
Fees. Licenses and Permits, as a Dercent of the budget, are slightly higher than in tlle prior year.
However, the actl1al revenue dollars are lower than in the same period of the prior year due to lower
permits pulled for rcsidential projects. Interest and Rentals received to date are lower than thc prior year
due to timing differences in the receipt of interest earnings on the City's securities and allocation of
interest revenue to other funds. Initially all interest revenue is recorded in the General Fund and is then
allocated quartcrly to other funds on a pro rata basis.
Intergovernmental revenue is higher than in the prior year due to an early repayment by the State of the
Vehiele License Fee (VLF) Loan from Fiscal Year 2003-2004. At the time the Fiscal Year 2005·2006
City budget was approved, there was no indication that the VLF loan would be repaid ahead of schedule;
therefore, no revcnue was budgeted for this event. However, with the adoption of the Statc Budget, cities
were advised that the VLF Gap Loan would be repaid early.
Other Revenues are lower than in the same period of the prior year due to a one time payment received in
the prior year for ongoing maintenance of storm drains and timing differences in the receipt of
reimbursements from the City of Pleasanton for thc dcsign of improvements to the Fallon RoadJI-580
freeway intcrchange.
General Fund Ex.øendItures
Ovcrall, through the month of November, expenditures in the General Flmd totaled about $9.3 million and
represented approximately 19% of the total budgctcd cxpenditures in the General Fund. Of this amount, a
total of approximately $1,310,000 was related to Capital Improvement Projects and the remainder was
related to Operating Costs reported in the General Fund. Capital Project expenditures typically do not
follow an even distribution due to differences in project timing.
In looking only at General Fund Operating Expcnditurcs, the activity through November 2005 was similar
to thc amounts cxpendcd for the same period in the prior Fiscal Year. Through the end of November
2005, the City had expended 19% of the General Fund Operating Budget, which was similar to the
amount expended in the prior Fiscal Year. Otller Public Safety is lower than in thc same pcriod of the
prior year due to timing differences in the payment 0 f contract animal services.
All expenditures are within thc authorized budget. It is recommended that the City Council receive these
rcports as authorized by Section 41004 of the Califomia Government Codc.
Pagc 2 of2
\ \-3
--------~
City of Dublin 2005-2006 YTD Revenues and Budget Comparison
l?_º.!:JI1~r~.Ijº<I..~.Il<l.i.llg]\ º\,çm.".er 30, .2.005
2%
7%
-----..---..----------.-..........".-..
Total General Fund Revenues
--------,..,~,.".,'.--,.._,.-
Property Taxes
Sales Taxes
Real Property Transfer Tax
Trausient Oeenpaney Taxes
Franchise Taxes
Licenses and Pcrmits
Interest and Rentals
Intergovernmental from State
Charges for Services
Fines and Forfeitures
Other Revenues
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmentill
Charges for Services
Fines ilnd Forfeitures
Other Revenues
45%
Ol~
60%
30%
!
. FY 2005/06
II FY 2004/05
142%
HI
I
150%
90%
120%
42% of Year Complete
I
.. ........--.-.-----
FY 2005/06
....~.';!!;I. ; !:.!..-..
FY 2005/06
YTD Actual
15,716,461
14,984,884
745,600
680,500
1,626,300
2,380,013
1,898,725
498,650
5,256,561
132,200
1,596,243
716,900
3,732,869
253,159
221,395
240,838
1,738,154
950,809
705,846
1.917,679
55,854
275.736
Totill Generill Fund Revenues 45,516,137
D~ltrPr1nltrd: 121712001> 10:1~AM
10,809,239
%of FY 2004/05 % of Total for
Budget YTD Actuill FY 2004105
5% 635,551 5%
25% 4,054,138 29%
34% 325,690 39%
33% 233,516 35%
15% 340,209 22%
73% 2,315,283 66%
50% 1,025,989 59%
142% 324,183 57%
36% 1 ,938,287 35%
42% 59,019 41%
17% 353,194 45%
~-~..~~
24% 11,605,059 27%
:D'£M 1..\-, I \ 1"'2.-W·OS-
ATTACHMENT 1
_._...__._.___....._._n
..-....-..----
City of Dublin 2005-2006 YTD Expenses and Budget Comparison d-Dò'3
For the Period Ending November 30, 2005
Fire
~-;~~~~:;~:
Total General Fnnd
Expenses
General Government
Police
other Public Safety
Transportation
Health and Welfare
11 %
44%
Culture & Community
Services
Community
Development
Capital Jmprov.
Projects
0%
20%
40% 60% 80%
42% orY,ar Complete
100%
120%
--...---"'...
2005106 2005/06 %of FY 2004105 % of Total for
Budget YTD Actual Budget YTD Actual FY 2004105
General Government 5.532.335 1,764.425 32% 1,567,599 32%
Police 11.358,537 564,304 5% 471.612 5%
Fire 8.890,188 223,634 3% 187.133 2%
Other Public Safety 383,869 74,820 19% 39,054 11%
Transportation 1,824,115 554,930 30% 503,296 30%
Health and Welfare 15,000 17.003 113% 38,086 44%
Culture and Community Services 6,363,138 2,116,134 33% 1,889,807 35%
Community Development 8.434.412 2,652,114 31% 2,518,555 34%
Capital Improvement Projects 5.110,097 1,309,870 26% 1.414,694 30%
Total General Fund Expenses 47,911,891 9,277,234 19% 8,629,836 20%
General Fund Operating Expenses 42,801,594 7,967.364 19% 7,215,142 19%
D...Prtntlld:I21'/!200~1Q.~_
ATTACHMENT 2
'3 cr) 3
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF NOVEMBER 2005
Prepared by
The Finance Department
December 7, 2005
ATTACHMENT 3
~ Db\3
CITY OF DUBLIN
BALANCe SHEeT
FOR THe
PeRIOD ENDING 30Nav2005
GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOT A L S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY---
FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR
ASSETS
CASH 150.913.744) 3.453.740 412.221 38.474.014 13.890 (8.559.8/9) (26.000.860)
CASH WITH FISCAL ^GENT 115.727 175.727 172.779
AMOUNT HELD IN ESCROW 4.177.500 4,177 ,500
INVESTMENTS AT COST 101.906.504 101.906.504 98.215.420
RECEIVABLES, TAXES
ACCOUNTS 12/.768 363.597 49l.364 30/.651
INTERFST 500.222 500.222 496.242
ASSESSMENTS
DUE FROM OTHERS 2.206.558 2.206.558 1. 829.213
INVENTORY AT COST
PREPMD ITEMS 6.B34 6.834 11 . 933
FIXED ASSETS
lOANS RFCEIVABLE 4.596.534 4.596.534
AMOUNT TO BE PROVIDED 1.213.500 1.213.500 1.334.500
TOTAL ASSETS 53,834,142 3.817.336 412.221 47.248.048 1.403.117 106.714.865 76.311.877
LIABILITIES/FUND EOUITY
DFPOSITS FOR PRIVATE DEVEL 1840.576) (840.576) (965.884)
DEPOSITS FOR AB1600 FEES (763.358) 1763.358) (317.047)
DEPOSITS OTHERS 12.707.854) (2.707.B54) (2.489.119)
PAY ABLES , ACCOUNTS (782.603) (04./38) 11.556) (838,896) (293.195)
INTEREST
PAYROLL (618.795) 1618.795) (511.842)
DUE TO OTHERS (671.217) 15.270) (2.201.289) 12.877.776) (145.083)
DEFERRED REVENUE 112/./68 ) (127.768) 112/./68)
DEBT INSTRUMENTS P^YA8LE (1.331.000) 0.331. 000) 0.452.000)
TOTAL LIABILITIES (6.512.170) 160.008) (2.202.845) (1. 331. 000) (lO , 106.022) (6.301.938)
FUND 8AI..ANCFS 147.321.972) 0.757.328) (412.221) (45,045.203) (72.117) (96.608.843) (70.009.940)
TOTAL FUND E (47,321.972) (3.757.328) (412.221) (45.045.203) (72.117) (96.608,843) (70.009.940)
TOTAL LIABILITIES/EQUITY (53.834.142) (3.817.336) (412,221) (47.248.048) (1.403.117)(106.714.865) (76.311.877)
5~13
CITY OF OUBLIN
BALANCE SHEET
FOR THE
PERIOO ENOING 30Nov2005
INTERNAL ENTERPRISl FIXED ASSETS GENERAl. lONG TOTALS
SERVICE FUNO GROUP OF TERM DEBT ---MEMORANDUM---
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PR lOR
ASSETS
CASH 9.446,414 9.446.414 8.271.014
CASH WITH FISCAL AGeNT
AMOUNT HELD IN ESCROW
INVLSTMENTS AI COST
RECEIVABLES, TAXES
ACCOUNTS
I NTERESr
ASSESSMENTS
OUf FROM OTHERS
INVENTORY AT COST
PRlPAID ITEMS
FIXED ASSETS 50.002.851 333.654.335 383,667,186 85.720.159
LOANS RECEIVABLE
AMOUN I' 10 Be PROV IOLO 63.728.304 63.72B.304 66.753.945
TOTAL ASSETS 59.449.266 333.604.335 63.728.304 456,841. 905 160.745.117
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSlTS OTIIERS
PAYABLES, ACêOUNTS
INTEREST
PAY ROI.l,
DUE TO OTHERS
DEFERRED REVENUE
DE8T INSTRUMtNTS PAYABLE (63.728.304) (63.728.304) (66.753.945)
TOTAL LIABILITIES (63 .728 , 304) (63.728.304) 166.753.945)
FUND BALANCES (59.449.266) (333.664.335) (393.113.600) 193.991.172)
TOTAL FIIND E (59.449.255) (333.664.335) (393.113.600) 193.991.172)
TOTAL LIABILITIES/EOUITY (59.449.266) (333.664.336) (63.728.304) (456.841.905)(160.745.117)
THE CITY OF DU8L1N STATEMENT SHOWING 1.0 Db \ 3
REVENUES VERSUS EXPENDITURES
FOR THE PERIOO
D7/0l/2005 THROUGII 11/30/2005
G ENE R A L REV E N U E FUN 0
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
*******RF,VENUES*******
PROPERTY TAXES 15,716,461.00 716,900,06 14,999,56094 14,054,547.16 635,550.84 13,418,99632
SALES TAX 14.984,88400 3,732,868.87 11,252.015.13 14,152,987.24 4,054,138.35 10,098.848,89
REAL PROPeRlY TRANSFER TAX 745,600.00 253,159.09 492.440.91 831. 003.24 325.690,33 505.31291
HOTEL TRANSIENT OCCUPANCY TAX 680,500,00 221. 394,92 459,105,08 663,631.67 233,515.89 430,115 78
FRANCHISE TAXES 1.626,300,00 240,837.53 1 , 385 .462 .47 1.559.900.22 340,208.77 1.219,691.45
LICENSES & PERMITS 2.380,01300 1.738,153.89 641. 859.11 3,520,140.84 2,315,283.49 1.204.861,35
FINES & FORFEITURES 132,200.00 55,854.41 76.345.59 143,316,33 59,018.63 84,29770
USE/MONEY & PROP-INTEREST 1. 757 ,524,00 932,351. 03 825,112.97 1.608.966.40 994,078.67 614,887.73
USE/MONEY & PROP-RENTAI_.5 141 ,201. 00 18,457.52 122,743.48 125,835.40 31. 910,08 93,92632
INTERGOVERNMENTAL 498,650.00 705,846,29 (207,196,29) 568.598.34 324.182.97 244,41537
CHARGES FOR SERVICES 5,256.561.00 1.917,679.16 3,338.881.84 5,548,124.34 1. 938,286 . 54 3,609.837,80
OHitR SOURCES OF REVENUE 1,596,243.00 275,736.08 1,320,506.92 783,873,45 353,193,85 430,679.60
TOTAL REVENUE 45,516,137,00 10.809,238,85 34.706,898,16 43,560.924.63 11,605.058.41 31,955,866.22
*******EXPENDITURES*******
GENER^L GOVERNMENT ACTIVITIES,
CITY COUNCIL 300.704.00 93.425.53 207,278.47 224,070,48 69.746,/8 164,323.70
CITY MANAGER 997,923.00 348,011.10 649,611,90 919.976.69 341. 923.04 578,053.65
CENrRAL SERVICES 638.556.00 147,249.24 391. 306.76 362,244,59 119.961.11 242,283.48
CTTY ATTORNEY 824,252.00 153,658.32 670.593.68 631. 963,18 125.813.27 506,149.91
ADMIN SERVICES 1.648,603,00 574.783,07 1.073,819.93 1.433,876.94 515,952.19 917,924,75
BUILDING MANAGlMlNT 734,657.00 212,597.28 522,059.72 668,646,21 206.292,24 462,353.97
INSURANCE COST CENTER 397,038.00 231. 904,31 165,133.69 508.448.41 187,321.30 321.12711
ELECTIONS COST CENTER 2.890.00 465.50 2,424.50 12,265.33 423.75 11,841.58
NON - DEPARTMFNT Al_ 87,712.00 2,030.30 85,681.70 68.155,13 16549 67,989.64
ACTIVITY TOTAL 5,532.335,00 1.764,424,65 3,76).910.35 4.829,646.96 1. 567 ,599 17 3,262.047.79
PUBLIC SAFETY
POll CE 11,358,537.00 564.303.58 10.794.233.42 9,837,842.27 471,61224 9,366,23003
CROSSING GUARDS 82.140.00 13.279.30 68,860.70 71,407.04 13.936,42 5/,4/062
ANIMAL CONTROL 208,898.00 39,878.00 169,020.00 208,369,91 208.369.91
TRAFFIC SIGNALS & STREET LIGHTIN 18,11000 2,862.73 15.247,2/ 8.587.87 2,44295 6,144.92
DISASTER PREPAREDNESS 74,721. 00 18,/99.67 55.921. 33 68,023.15 22,674,80 45,348,35
FIRE SERVICES 8,890.188.00 223,634.41 8,666,553,59 8.207.944,38 187,133 23 8,020,811.15
ACTI V!TV TOT ^L 20,632.594,00 862.757,69 19,769.836.31 18.402,174.62 697.799 64 17.704.374.98
TRANSPORTATION
PU8L1 C WORKS 808,577. DO 269,279.13 539,297.87 723,562,41 256,81025 466.752.16
STREET MAINTENANCE 30,31400 30.314,00 15,908.28 110.50 15,797.78
STREET SWEEPING 150,670,00 34.553,04 116.116.96 140,783.85 34,393.04 106.390,81
STREET TREE MAINTENANCE 99,430 00 23. 728. 82 75.781.18 99,195.45 11,534,64 87.660.81
STREET LANDSCAPING MAINTENAN 13",124.00 ??7.368.62 507,755.38 682.756.30 200,~48,02 482.308.28
AU1V1TY TOIAL 1. 824,115.00 554,929.61 1.269,185.39 1.662.206,29 503,29645 1.158,909.84
IIEAUH & WFt FARF
WASTE MANAGEMENT 2,00258 (2,002.58) 71.474.64 38,085,51 33.389.13
CHILD CARt 15,000.00 15,000 00 15,000,00 15,000.00
SOCIAL SERVICES
HOUSING PROGRAMS
THE CITY OF DUBLIN STATEMENT SHOWING 1 ðO\3
REVENUES VERSUS EXPENDITURES
fOR THF PFRIDD
07/01/2005 THROUGH 11/30/2005
G ENE R A L REV E N U E FUN D
CURRENT CURRENT PRIDR PR lOR
BUCGET ACTUAL VARIANCE F¡SCAL YEAR YTD. VARIANCE
ACTIVITY TOTAL 15,000,00 17.002,58 (2,002.58) 86.474-64 38,085.51 48,389.13
CULTURE & LEISURE SERVICES
LIBRARY SeRVICES 617.771.00 163,15215 454,618,85 577.134,07 142,129.43 435,604.64
CULTURAL ACTIVITIES 204,70LaO 116,35213 88,348,87 125.102_04 44,645.48 80.456 . 56
HERITAGE CENTER 163,33300 54,670,71 108,662,29 125.641.44 42,196.92 83 .444 . 52
DUBLIN CEMETERY 49,958,00 8,323,56 41,634.44 40,573.15 12,816,04 27.757,11
PARK MAINTENANCE 1.7l?, 065.00 423.453 21 1.288,611.79 1,450,064,58 431,273.57 1. Ot?. 791. 01
COMMUN ITY TV 66,40700 5B,985,5B 7,42142 61.809.00 55,899.00 5,910,00
RECREATION ADMIN 708,17400 240,40910 467,764.90 608,760.76 217 , 142, 07 391. 618,69
PLAYGROUNDS 275,357.00 93,36960 181. 9B7 ,10 247.214.27 101,920.66 145,293.61
SH^NNON CENTER 312,706.00 123,55985 219,146.15 301. 071. 12 134,177,69 166,893.43
PRESCHOOL 105,458.00 38,87061 66,587,39 82.639.86 30,563.79 52,076.07
TFENS PROGRAM 159,835,00 46.761,49 113,010 51 87..106.66 30,379.90 56,926,76
AOULT SPORTS 109,230,00 29,94564 79,284.36 92,694.01 36,810.74 55.883,27
YOUTH SPORTS 153,617.00 49,941. 32 103,675.68 118,533,39 34,592.07 83.94132
COMMUNITY GYM 43,459.00 14,52422 28,934.78 42.887.87 8,713.36 34,17451
EMERALD GLEN ACTIVITY CENTER
SPECIAL ,VlNTS .164,601. 00 169,11930 195,481. 70 331.898.19 137,136.29 194,761. 90
SEN lOR CENTER 365.728.00 149.971,34 210,756.66 253.121.20 87,47953 165,641.67
RECREATION INSTRUCTION 18.1,023.00 62,98341 120,039.59 174.492.75 74,88986 99,60289
AOU^TICS 429,221. 00 163,505.03 265,715.97 393,660.59 166,091. 23 227.569,36
PARKS/FACILITIES MANAGEMENT 308,494.00 108,232.70 200,261. 30 251. 928,57 94,949.76 166,97881
ACTIVITY TOTAL 6,36.1,138.00 2,116,133,95 4,247,004,05 5,377.133.52 1.889,807.39 3.487,326,13
COMMUNITY OEVELOPMENT
PLANNING 2.685,164.00 836.745 25 l.848,418.75 2,414,972.53 917,195,68 1.497,77685
BUILDING SAff.fY 3,214,615.00 964,20486 2,250,410,11 2,399.434.25 138,698.14 1. 660 .736,11
ENGINEERING 2,191,005.00 /14.322 95 1.479,682.05 2,304,691.55 718,336.33 1,586,355.22
ECONOMIC DEVEI.OPMENT 340,628.00 136,84094 203,787,06 272.379.63 144,324..15 128,055.28
ACTI V ITY TOT ^L 8.434,412,00 2,652.11400 5.782,298.00 7,391.477.96 2,518.551,50 4.872,923,46
CAPITAL IMPROVEMENT PROJlCTS
GENERAL CIP PROJECTS 1,350,856,00 67.935,54 1.282,920.46 633,849.26 206.195,80 127,653,46
COMMUNITY IMPROVEMENTS 874,999.00 579.95799 295,041. 01 403,110.09 18,188,31 384,32178
PARKS 1.614,31000 520,72101 1.O93, 588.99 2,630,020.18 940,681.11 1. 689,339 67
STREET CONSTRClI MPROVEM[NTS 1. 269,932.00 141. 255.82 1,128,676,18 980.260,11 249.028.76 7.11. 231. 35
ACTI V ITY TOTAL 5,110,097,00 1.309,870,35 .1.BOO,22664 4,647,240.24 1.414,693.98 3,232,546,26
TOTAL EXPENDITURES 47,911,69100 9,277.23284 38,6.14,458.16 42,396,354.23 8.629.836,64 33.766,517.59
EXCESS REVENUE (EXPEND! ¡URf:S) (2,395,55400) 1,532,006.01 (3,927,560,01) 1.164.570.40 2,975,221.77 (1,810,651.37)
TRANSFERS IN FROM OTHER FUNDS 475,053,00 415,053.00 27,230.91 27,230,91
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UND[R) éXPlNOITURFS (1,920,501.00) 1. 532,006.01 (3,452,507,01) 1.191. 801. 31 2,975,221.77 (1,783,420.46)
THE CITY OF DUBLIN STATEMENT SHOWING 'ß~\3
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 11/30/2005
S P E C I A L REVENUE FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.r.D. VARIANCE
********REVENUES********
PROPERTY TAXES 111 . 6BO 00 117.68000 112.532.03 112.532.03
SALES IAX/OlllER TAXES 360.50000 41. 252.07 319.24793 364.477.71 58.572.16 305.90555
FINFS & FORFEITURES 156.000.00 55,876.26 100.123.74 149.341.93 23.500 71 125.841.22
USESIMONEY & PROPERTY 99.75/.00 21. 083 99 78.67301 102.932.29 102.93229
INTERGOVERNMENTAL FROM STATE 1.014.23100 425.240.96 588.990.04 2.354.339,65 434,173.94 1. 920,165.71
INTERGOVERNMENTAL FROM COUNTY 340.440.00 38.110.00 302.330.00 332.344.00 332.344.00
INIERGOVERNMFNTAL FROM FEDERAL 76.792 00 3.37679 73,415.21 56.796.80 2.79099 54.00581
CHARGES FOR SERVICES 1. 350. 461 00 1 .350.461. 00 1.075.178.65 1. 075 .178.65
onlER SOURCES OF REVENUE 409.50000 390.000.00 19,500.00 170.482.39 4.51835 165.96404
TOTAL REVENUE 3.925.36100 974.940.07 2.950.420.93 4.718.425.45 523.556.15 4.194,869.30
*******EXPENDITURES*******
PU8LI C SAFETY;
POLlCF 120.25500 120,255.00 105.952.40 3.120.12 102.83228
TRAFFIC SIGNALS & STREET LTG 234.700 00 100,940.46 133.759.54 173.175.14 38.182.86 134.99228
DISASTER PREPAREDNESS
FIRE SERVICeS 270.120 00 2.500.00 267.620.00 251. 091. 21 2.588.18 248.503.03
ACTIVITY TOTAL 625.075.00 103 .440.46 S21. 634.54 530.218_75 43.891.16 486.327.59
IRANSPORIAiION,
STREET MAINTENANCE 330.474.00 68.651.66 271. 922 . 34 272.390.25 34.764.43 237.625.B2
STREET SWE[PING
ACTIVITY TOTAL 330.474.00 58.551.66 211. 922.34 272.390.25 34.764.43 237.625.82
HEALTH & WELFARE:
WASTE MANAGEMENT 1.874.906.00 113.420 92 1.761,4B5.08 1.3B3, 964 .16 10.54310 1. 373 .421. 06
SOCIAL SFRVICES 60.427.00 37.126.56 23,300.44 44.927.00 9.166_18 35.760.82
HOUSING PROGRAMS
ACTrVITY TOTAL 1.935.333.00 150.5474B 1.784,7B5.52 1.428.891.16 19./09.28 1.409.18188
COMMUNITY DEVELOPMENT:
ENGINEERING 6.000.00 6,000.00 6.000.00 568.50 5.431. 50
ACTIVITY TOTAL 6.000.00 6.00000 6.000.00 568.50 5.431.50
CAPITAL IMPROVEMENT PROJECTS;
GFNFRAL CI P PROJECTS
COMMUNITY PROJECTS 39.556.00 39.556.00 14.850.00 14.850.00
PARKS 31.310.00 JI. 310.00 321.717.00 12B.500.00 193,217.00
STREET CONSTRUCTlONII MPROVEMEN r 1.670.803.00 514.373 96 1.156.429.04 149.554.78 62.886.03 86.668.15
ACTIVITY TOTAL 1.741.669.00 514.37396 1.227.295.04 486.121.18 191.38603 294.735.75
TOT A L EXPENDIrURlS 4.644.115.00 B32. 913 56 3.811.20144 2.723.621.94 290.31940 2.433.30? 54
EXCESS REVENUE (EXPENOITURES) (718.754.00) 142.026.51 (860.180.61) 1.994.803.51 233.23675 1.761. 566 76
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 88.13700 88.737_00 1.336.274.58 1,336.274.0,8
REVENULS OVLR (UNDER) EXPENDITURES (807.49100) 142.026 51 (949.51751) 658,528.93 233.236 75 425.29218
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THl PERIOD
07/01/2005 THROUGH 11/30/2005
q1:Q\3
SPECIAL ASS E SSM L N T FUN 0 S
CURRENT CURRENT PRIOR PR lOR
BUDGET ACTUAL VARIANCE FISCAL YEAR YT.D. VARIANCE
********REVENUES********
SPFCIAL BENFFITS ASSFSSMFNTS 664.610.00 664.610.00 744.099.49 744.099.49
USES/MONEY & PROP- INTEREST 15A78.0D 3.12359 12.35441 14.748.10 14.148.10
OTHER SOURCES OF REVENUE 5.000.00 2.578.84 Z .421.16
TOTAL REVENUE 6B5.088.00 5.70243 679.38557 758.847.59 758.847.59
*****'"k1IrtXP[NDITURES***~
PUBLI C SAFETY:
TRAFf IC SIGNALS & STRElT UG 2/8.600.00 73.143 31 205.45669 231. 533.62 70,729 75 160.80387
ACT! V ITY TOTAL 278.600.00 73.143.31 205.456.69 231. 533.62 70.729/5 160.803.87
TRANSPORTATION
PUBI.f C WORKS 2.415.00 564.51 1.85049 I. 591. 29 444.62 1.146.67
STREET TREE MAINTENANCE 34.231. 00 3.656,73 30.574.27 18.466.76 3.588?8 14.878.48
STREEl LANDSCAPE MAINTENANCL 356.039 00 92.86974 263.169.26 317.657.53 94.84484 222.812.69
ACT! V ITY TOTAL 392.685.00 97.090.98 295.594.02 337.715.58 98.877.74 238.837.84
COMMUNITY OEVELOPMENT
ENGINEERING 13.10000 11.351.60 1.742 AO 7.139.94 6.669.94 470.00
ACT! V ITY TOTAL 13.10000 11.357.60 1.742.40 7.139.94 6.669.94 470 00
CAPITAL IMPROVLMEN I PROJ[(J S:
COMMUNITY IMPROVEMENTS 32.92000 86.79 32.833.21
STREET CONSTRUCTION/IMPRVMNT 75.000.00 /5.000.00
ACT! V ITY TOT Al_ 107.920.00 86.79 107.83321
TOT A L EXPENOITURES /92.30500 181.6IB.68 610.62632 576.389.14 176.277.43 400.11171
EXCESS RFVENUE (EXPENOITlJRES) (107.21700) (175.976.25) 68.759.25 182.458.45 (176.277 .43) 358.735.88
REVENUES OVER (UNDER) EXPLNDI URLS 1101.21700) (175.976.?5) 68.759.25 182.458.45 (176.277 43) 358.735.88
nlE CITY Of IJUeUN STAIIM[NT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
D7/DI/?00S THROUGH 11130/2005
IOOb \"3
CAP I r A L IMP R 0 V E MEN T FUN D S
CURRENT CURRENT PR lOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y. T.D VARIANCE
********REVENUE********
USES/MONEY & PROP- I N I[REST 865,623,00 211,301.96 654,315.04 U21. 970. SO I. 221. 970.50
OTHER SOURCES OF REVENUE 19.267,625.00 9,IS7,074.60 10.110.550.40 14.361. 927 . 97 10.131.803.55 4,230.124,42
TOTAL REVENUE; 20.192.732,00 9,368,382.56 10,824,349,44 16.892,942,14 10.131. 803.55 6, 161.138.59
*******EXPENDITURES*******
GENFRAI GOVERNMENT ACTIVITIES;
CITY ATTORNEY 38.950.00 10.192.90 28.757.10 35.736,39 396,00 35.340,39
ACTI V ITY TOTAL 38,950.00 10,192,90 28,757.10 30,136.39 396.00 35.34039
PUßt,IC SAFFTY;
TRANSPORTATION;
H[ALI'H & WE I. FARE;
HOUSING PROGRAMS 903,030.00 97.129.74 805,90026 219.420,35 59,071. 06 160.349,29
CULTURE & LEISURE SERVICES;
RFCREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTI V ITY TOTAL
CAP I I AI. lMPROVEMENT PROJECTS
GENERAL CIP PRDJECTS 67.700.00 67.700.00 624,913,39 112.414,57 482,528.82
COMMUNITY IMPROVEMENTS 36,77100 36,771. 00
PARKS 11.322,83S.00 2,S79.717.02 8.743,1l7.98 6,285.687.19 214.23034 6.071,456.85
STREET CONSTRUCTION/IMPROVEMENT 36.340,142.00 178.820 75 36,161. 321. 25 3,309.862,62 303,863,10 3,000,999.52
ACI'iVITY TOTAL 47.130,677.00 ?,158.53777 44,972,139.23 10.257.264.20 660.508.01 9.596.756.19
TOT A L EXPENDITURES ~8.6/2,60J.00 2,865.86041 45,806.796.59 10.571.890.78 719.97507 9,851.915.71
FXCESS REVENUE (EXPENOrTURES) 128,SJ9,40900) 6,S02.522.15 135,041.931.15) 5.012.007.69 9,411.828,48 (4,399.820.79)
T~NSFER IN FROM OTHER FUNDS (59,48400) (59.484,00) 1l.309,043.6)) (j, 309.043.67)
TRANSfERS OUT TO OTHER FUNDS 115,80000 445.80000
REVENUES OVER (UNDER) EXPENDITURESI28.925.725.00) 6,502.522.15 (35,428.247,15) 6,321.051,36 9.411,828.48 (3,090.777.12)
rllF CITY OF DUBLIN STATEMENT SHOWING \\1Jb\~
REVENUES VERSUS EXPENDITURES
FOR THE PERIOO
07/01/2005 THROUGH 11/30/2005
T R U sri AGE N C Y FUN 0
CURRENT CURRENT PRIOR PRlOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE
********REVENUES********
SPECIAL ASSESSMENTS 228.280.46 228,280.46
USES/MONEY & PROP-IN [REST 407.89 (407.89) 5,612.63 5.61263
TOTAl. REVFNUE 407.89 (407.89) 233.893.09 233.893.09
*******EÄPfNOITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 231.038. DD 183.498.75 47.539.25 232.571.18 178,997.43 53.573.75
ACT! V ITY TOTAL 231.038.00 183.498.75 47,539.25 232.571.18 178.99743 53.573.75
PU8LI C SAFETY:
TRANSPORTATION;
HFALTH & WELFARE:
CULTURE & LEISURE SERVICES;
COMMUN!TY OEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
TOT A L EÄPENOITURES 231.038.00 183,498.75 47.539.25 232.571.18 178.99743 53.573.75
EXCESS REVENUE (EXPENOITURES) (231.038.00) 1183.090.86) (47.947.14) 1. 321. 91 (l78.997.43) 180.319.34
REVENUES OVER (UNDER) EXPENDITURES (231.038.00) 1183.090.86) (4/.947.14) \.321. 91 (l78.99743) 180.319.34
THE CITY Of DUBLIN STAHM(NT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 11/30/2005
\"2-CV\3
I N T ERN A L S E R V ICE FUN 0 S
CURRENT CURRENT PR lOR PRIOR
ßUDGET ACTUAL VARIANCE FISCAL YEAR YTD VARIANCE
********REVENUES********
USlS/MONlY & PROP-!NTFRFST ~97,08900 49,62949 247.459.51 245,40737 245.407,37
CH^RGES FOR SERVICES 1.796,096,00 711. 924,35 1. OB4 .171. 65 1.642,44130 708.789. 8~ 933,65148
OTHER SOURCES Of REVENUE 23,400,00 14.020,00 8,87500 4,841,986.98 233.47 4,84U53 51
TOTAL REVFNUE ~.116,58500 776,078 84 U40,506.16 6,729,835.65 709,023.29 6,020.812,36
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 2,092,68000 258,42644 1.834,253.56 2,467.397,02 655,152 10 1. 812, ?44 9?
ACTIVITY TOTAL 2.092.680,00 258.426,44 1.834,253.56 ~,467.397.02 655,152.10 1812,24492
PUBLl C SAFETY
FIRE 65,561. DO 65,561. DO 59,862.86 59:86286
^CTlVITY TOT^L 65,561. DO 65,561. DO 59.862.86 59,86286
TRANSPORTATION,
HEALTH & WELFARE,
CULTURE & LEISURE SERVICES
COMMUNITY (J[VFIOPMFNL
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 2,158,241.00 258,426,44 1.899,81456 ~,5~7,259.88 655.152.10 1.872,107.78
EXCESS REVENUE (EXPENDITURES) (41.6%,00) 517,652,40 (559,30840) 4,202,575.77 53.871.19 4,148.704,58
rRANSfER IN FROM OTHER FUNDS
TRANSfERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES (41.65600) 517.652,40 (559,308,~0) 4,202.6/517 53.87119 4.148.704.68
********REVENUES********
USESIMONFY & PROP INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACTIVITY TOTAL
PUBLI C SAFETY:
HlAt..TH & WfllARE:
CULTURE & LEISURE SERVICES
COMMUNIIY DEVELOPMENf:
CAPITAl. IMPROVEMENT PROJECTS;
TOT A L EXPENDITURES
I.xnss RI_VlNUt OßLNDITURlSJ
TRANSFERS IN FROM OTHER FUNDS
IRANSFfYS OUT TO OIHtR FUNOS
RlVlNUlS UVER IUNDlR) EXPENDITURES
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR 1 Hl PlRIÜD
07/01/2005 THROUGH 11/30/2005
E N T E R P R I S E
FUN D
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
1.T .0.
(2000)
(2000)
(20.00)
20.00
20.00
\"3 ~ \3
VARIANCE
20.00
20.00
20.00
(2000)
(20.00)