HomeMy WebLinkAbout4.10 Financial Reports April 2006
CITY CLERK
File # Dl3l~[Q]-[5J~
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: May 16, 2006
SUBJECT
Financial Reports for the Month of April 2006
Report Prepared by' Paul S. Rankin, Administrative Services
Director and Fred Marsh, Finance Manager
ATTACHMENTS
1
2.
3
YTD Revenues and Budget Comparison
YTD Expenses and Budget Comparison
Financial Statements for April 2006
RECOMMENDATION 'is
FINANCIAL STATEMENT
Recel ve the reports.
See reports for detail ofmonthly financial acl1vIty
DESCRIPTION
This item provIdes the report on the preliminary financIal statements for the month of April 2006.
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.
Analvsis of April 2006 Revenue and Expenditure Reports
The April reports represent the reporting of revenues and expenditures for ten months of the Fiseal Year,
through April 30, 2006. It should also he 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
slgmficant amount of services provided to the City by mdependent contractors, includmg Police and Fire
Services.
General Fund Revenues
Total General Fund Revenues collected through April are slightly less tban what occurred in the tenth
montb of the previous Fiscal Year. Through April 2006, tbe City had collected approximately 81 % of the
total budgeted General Fund Revenues, in the same period for the pnor Fiscal Year the City had collected
84% of General Fund Revenue. The difference is made up of both positive and negatIve vanances from
the budget estimate. A brief description IS provided below to explain any matenal revenue variations.
Property Taxes are higher than III the prior year due to a higher than anticipated increase in the assessed
value of properties m the City and timing differences in the recognition of a sales tax shanng payment
relating to properties previously owned by Alameda County Surplus Property Authonty Sales Taxes are
lower than III the same period of the prior year This revenue was impacted by lower than expected auto
sales experienced during the second quarter of the Fiscal Year Sales Tax Revenue is also impacted by
timing differences in the receipt of In LIeu sales tax payments.
Transient Occupancy Taxes are higber than in the prior year due to timing differences III receIpts of
payments from two of the City's hotels. Licenses and Permlts, as a percent of the budget, are hIgher than
________________________________________~~M_______~~______________________~______~___________________________
nn(:uml:!nt in FS(:OLOK o4-20u6.XLS
ITEM NO.
If. \0
t/
COPIES TO:
Page lof2
III the prior year However, the actual revenue dollars are lower than m the samc period of the pnor year
due to fewer pennits pulled {[Jr rcsidential projects. This was accounted for in the original budget..
Interest and Rentals receIved to datc arc higher than the prior year due to a bighcr than expected return on
the City's investmcnts and timing differences in the receipt of mterest earnings on the City's securities.
InItially all interest revenue is rceorded in the General Fund and is thcn allocated to other funds on a pro
rata basis. Interest earnings have been allocated to all funds through thc end of March 2006. Year cnd
adjustments for market value are expected to reduce the total interest revenue.
Franchise Taxes are trackll1g shgblly highcr than budgeted primarily as a result of inclusion of multiple
Construcllon and Demohtion haulers as regulated servIce provIders. Intergovernmental revenue is higher
than in the prior year due to an early repayment by the State of the Vehicle License Fee (VLF) Loan from
Fiscal Year 20ll3-2004 At the timc 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 revenue was budgeted for
thlS evcnt. However, with the adoption of the State Budget, cities were advised that the VLF Gap Loan
would be repaid early
It IS typical lor the "Othcr Revenue" category to fluctuate from year to year since tlllS category includes
payments that may not be receJVed consistcntly each year. In Fiscal Year 2005-2006 the adopted budget
included the expected receipt of approximately $670,000 of reimbursemcnts from the City of Pleasanton
for improvements at the Fallon Road freeway interchange. Expenditures for the Fallon Interchange
project are occuillng at a slower pace than was assumed in the hudget estimate. The bulk of the
expenditures for this projcct is now expected to be incurred m Fiscal Year 2006-2007, which will also
shlft thc timing for receipt of this revenue. Tbis category also includes approximately $626,000 in
reimbursements for utility undergTOunding, which is still expected to be recognized as rcvenue in the
current Fiscal Year.
General Fund Expenditures
Overall, through the montll of April, expenditures in the General FlI11d totaled about $26.9 million and
represented approximately 56% ofthc total budgeted expenditures in the General Fund. Of this amount, a
total of approximately $1,748,000 was related to Capital Improvement Projects and the Iemamder was
related to Operating Costs reported 111 the General Fund. Capital Project expenditures typically do not
follow an even distrihutIon due to differences in project timing.
In looking only at General Fund Oueratmg Expenditures, the activity through April 2006 was similar to
the amounts expended for the same period in the prior Fiscal Year Through the end of April 2006, the
City had expended 59% of the General Fund Operating Budget, which was 3% less than the amount
expended 111 the prior Fiscal Year Culture and CommunIty Services through April is less than hudgeted
due to several factors including; staff vacancies; a delay in thc acceptance of mamtenance for the new
phase in EIllerald Glen Park; and reduced water usage due to SIgnificant rainfall. Community
Development IS lower than in the same period of the prior year due to temporary staffing vaCWlCIeS m the
Planmng Division.
Capitallmprovement Projects are lower than in the same period of the prior ycar. Several of the capltal
projects funded by thc General Fund in Fiscal Year 2005-2006 will either not incur major expenditures
until later in the Fiscal Year and/or will be carried over to Fiscal Year 2006-2007, including the CTV
Studio Remodel, Building Pennit Systcm, Fire Station 16 Repairs, design for the reconstruction of the
Shannon Center, and Utilities Undergrounding on Dougherty Road.
All expcnditures are within the authori"ed budget. It is recommended that the City Council receive tllese
reports as authorized by SectIOn 41004 of the California Govenmlent Code.
Page 2 of2
City of Dublin 2005-2006 YTD Revenues and Budget Comparison
. . ForJ\1ePeIio<,lJ<;Ill!iggApril30, 2006
81%
8%
Total General Fund Revenues
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Pcrmits
Interest and Rentals
Intergovernmental from State
Charges for Services
Fincs and Forfeitures
Other Revenues
I
1_ _____
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental
Charges for Services
Fines and Forfeitures
Other Revenues
I ot /Z>
Itj::y 2005/061
. FY 2004105 I
11%
30%
75% I
t
60% 90% 1211% 150%
83% of Year Complctc
FY 2005/06
Budget
FY 2005/06 %of FY 2004/05 % of Total for
YTD Actual Budget YTD Actual FY 2004/05
----.--....,.""..-
14,899,206 96% 12,667,434 90%
10,152,862 68% 11,925.467 84%
538,104 72% 614,608 74%
525,214 77% 472,338 71%
1,369,062 84% 1,274,321 82%
2,449,577 103% 3,065,514 87%
1,586,732 84% 1,334,816 77%
872,731 165% 463,146 81%
4,109,343 78% 4,085.440 74%
114.442 87% 114,546 80%
364,475 20% 590,903 75%
--...---
36,981,748 81% 36,608,533 84%
q-ID 'S/Ib/OO
ATTACHMENT 1
15,716.461
14,984,884
745,600
680,500
1 626,300
2,380,013
1,898,725
528,208
5,277,561
132,200
1,816,8~2_
Total General Fund Revenues 45,787,282
llol.P,,,,I.d,5/512DCI64:u! PM
J< 0' 13
City of Dublin 2005-2006 YTD Expenses and Budget Comparison
For the Period Ending April 30, 2006
Fire
. FY 2005/06
ft FY 2004/05
Total General Fond
Expenses
Ceneral Covernment
Pulice
Other Public Safety
Transportatiun
Health and Welfare
100%
100%
Culture & Commuuity
Servlees
Commuuity
Development
Capital Improv.
Projeets
0%
20%
40% 60% 80%
83% of Year Complete
100%
120%
2006/06 2005/06 '10 of FY 2004/05 % of Total for
Budget YTO Actual Budget YTO Actual FY 2004/05
~~-~
General Government 5,564.499 3,763,634 68% 3,529,146 73%
Pollee 11,361,037 5,379,960 47% 4,694,539 48%
Fire 8,902,188 4,588,966 52% 4,313,807 53%
Other Public Safety 376,705 159,360 42% 160,020 45%
Transportation 1,824,115 1,195,272 66% 1,128,383 68%
Health and Welfare 15,000 15,000 100% 83,556 100%
Culture and Community Services 6,394,638 4,435,765 69% 4 019,396 75%
Community Development 8.449.412 5,649,549 67% 5,530,819 75%
Capital Improvement Projects 5,418,989 1,748,198 32% 3,315,433 71%
Total General Fund Expenses 48,306,583 26,935,704 56% 26,775,099 63%
General Fund Operating Expenses 42,887,594 25,187,506 59% 23,459,666 62%
n.;.P,lnt.d:~"'~~'M
ATTACHMENT 2
30 113
CITY 01<' DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF APRIL 2006
Prepared by
The Finance Department
May 5, 2006
A TT ACHMENT 3
L'j' or '3
i:I I'y III DUBLI N
BALANCE SIIE[I
cOf THF
PERIOD ENDING 30Apr;'Ollh
GENERAL SPEI.IAL oPFCIAL, CMITAL TRUST/ TDTALJ
Revl NUl REVENUE ^:,SESSMENT IMPROVEMLNI AGENCY -- -MEMORANIJIIM ONLY ---
FUNDS ,UNDS ,UNIJo FIIND~ FUND CURRENT PRIOR
A~:;ET~
CI6H I be l~e ~:~4) 4 215 2U5 729 644 39 861 41J 174 548 17 1~7 7:!4, I?Y 468 404)
CASII WITH r loCAL AGENT 179 9~/ 17g 997 175 049
AMOUNI HLLD IN F~Cf10W 4 177 500 4 177 500
I NVE';TMENT~ ~ r cllSI llU "35 467 11 0 1,:)5 467 109 937 4'1:!
RfCFIVABLES TAXES
ACCOllNlo 127 76B 363 597 491 364 18n 001
I NTERF', T
(lS:;E:;SMENT~
DUF FROM OTHER'; 2 206 558 2 20fi hhK B29 213
INVENTORY AT CO';T
PREPAID ITEMo 5 952 5 952 4 26U
,IXLD ASSFTS
LOANS RECEIVABLE 4 596 534 4 596 S34
AMDUNr 'II) HI PROVIDED 1. 213 500 1 2t:l 01111 1 334 500
TOTAL ^~~ET:; riO H4, .:!11 4 57B 801 729 6~4 4H ri35 447 1 568 046 116 359 150 83 9q~ 7b']
L IA8ILITIES/FUND EDUITY
DEPOSITo lOR PRIVMF DFVEL 1519 5371 1 'l~ o:J/l 113977011
ULPUSW FOR A81600 FEEo 18ll riUJ I lAll 6011 (~119 /Yl ,
DEPOSIT:; OTHER'; '( "94 r,ll) (Z 294 67lJ (~ ~fJ4 352\
PAYAGLES ACCIIIINTS ,578 1071 5 JO:J (01( H04! (280 891l'
INTERE,T
PAYRUII (619 5181 (6JY SlHI (544 525)
DilL TO OTHER'; 15 270 I ~~ 1.01 289) ,2 20E 0581 l30 5811
OFFERRED REVENUE 11;'77681 (127 7681 \ 127 7681
DEBT IN';TRUMLNI" P~YA8LE 11331 oonl 'I :J31 0011) (l ~52 nllO!
TOTAL LIA8ILITIE'; 15 Illl :!01) (!~.270J " 195 9861 \1 331 UIIO' (8543457) (6 elll foll8 \
FUND 8ALANCE'; l,S5 ~36 011\ (~ 5735311 In9 "441 (46 439 ~621 (,37046,,107815694' (65 535 446)
TOTAL FUNO E 155836 Ull' 1407:1 ';J]l (729 64~ I '4h 4:>9 4(02) \237 0~6)(11l/ 815 694\ (65 535 44(0)
TOTAL LlAK II I TIE';/Eoun, (60 8~7 212' l4 o/~ 8011 (729 6~~ \ (4H oJ" 447: \l 568 046' IHo :159 150 \ 17234311,,4)
"5o.r I?:.-
cm or DUBLI N
BALANCE SHEET
fUR IHe.
PERIDD ENDING 30Apr20Ub
I NT[RNAl c.NTERPRISE FIXED N:;SET~ GENERAL LUNG T D TAL S
SERVICE rUND GRUUP Of TFRM DEBT ---MEMORANDUM---
rUNDS ACCDUNTS ACCOUNT GRUUP CURRENT PR lOR
AS~FT~
C~H q 9~9 OlS 9 929 nl5 8 fi~1 ~75
cASH WIIH fJ';CAI AGFNT
M-IOIINT HELD IN ESCROW
lNVF"TMENTc AT COST
RECEIVABLES TAXL:;
ACCOIINTS
INTERE';T
AS~E~SMENT~
DIIE FROM OTHER';
INVENTORY AT CUSI
PRLPAW lTFMS
FIXED II';SETS cU Ulk 601 333 664 335 383 bnl 161> H5 720 159
LOANS RECLI VABL.E
AMUlINT TO 8E PROVIDED 63 726 3U4 63 728 3114 Go 7S3 945
TOTAL ASSETS o~ 9:n ~hb 333 664 335 Ii:! 128 304 4~1 T~4 505 m 131 316
L1A~Il ITIES/FUNO EDllm
DEPOSIT, fOR PfllVATE DEVEL.
DFPOSITS FOR ABI600 FEES
DEPOSIT'; OTIIERS
PAYABIEC ACCOIINT:; II ~6:!)
INTEREST
P~YRUII
DUL IU OTHW
UEFeRRED RFVENIIE
DEBT IN';TRIIMENTS PAYABLL 11>.1 72B 3041 '10.1 72B 304 \ '66 ,'0:' ~45 I
IOTAL LIABILITIEc (63 728 .104) (63,721 :;U4) 166 7[5 ~n8)
FUND BALANCES (5Y nl 866' 1333 604 3~o) , 393 S96 201) (Y3 Y31 ?H11
TOTAL FIINO E 1[9 931 866) 1333 664 3351 ,393 5% ;<111) ,9.1 937 281 \
IOIAL LIABILITIE';/EOUITY 1 <;9 'rn H66) 1333 66~ 33<;) 1 h:; /"8 304) 1401 ::<4 SUS)116n 692 h1Y 1
0C~ 12,
THE CITY or DU~LIN STATEMENT SHOWING
REVENUE, VERSUS EXPENDITURES
EOR rilE PERIOD
07/111/201l0 IH~()UGH 04nu/2006
GENERAL R I V f N U E E U N D
CURRENT CURRLNJ PRIOR PRIOR
BUDGL I AcTllAI VARIANCE IISCAL YEAR Y T D VARTANCE
*******REVENUES*******
PROPERTY TAXE, 15 716 461 00 14 899.205 55 81/ 'oS 4S 14 054 547 16 lZ 66/ 4:,4 25 1 387 112 91
SALLS lAX 14 984 88~ 110 10 15, 802 111 4 8:']2 021 90 14 152 967 24 11 92546739 2 22/ bl~ H5
REAL PROPERTY TRANSEER TAX 740 oDU 00 5~,~ 103 60 207 496 ~II 8~1 003 24 614 607 53 ?16 395 71
HOTEL TRANSIENT OCCIIPANCY lAX "80 500 UO 525 21'1 23 ISS :'85 77 663 631 "7 4/? ~~~ 14 191 293 S:;
I' RANCH r:;F TAXES 1 626 31111 00 1 :,h9 Obi 15 257 237 85 1 5S'! ~1I11 n 1 274 3211 82 "Ho ,79 40
lICENSES & PERMITS 2 380 1113 110 2 449 577 18 (n9 "64 11' 3 S20 140 84 3 IIhS 014 ?O 454 626 h4
EINES & rDRI1111IRI'; 132 200 00 ll~ ~42 48 17 757 52 143 JIb 3:, 1I4 545 90 2K JIl) 43
USL/MONIY & PROP-INTEREST 1 757 5;'4 110 ~/H 041 25 229 282 7~ hllK %6 40 1 242 250 02 :166 711 38
USEIMONEY & PROP-RENTAIJ 141 201 00 58 4911 35 H;> 710 65 125 835 411 92 560 68 33 ~1!4 72.
INTERGOVLRNMFNTAI 528 208 Oil ~r' 7311 86 1344 522 86) ShA 5% 34 463 146 35 1.05 451 99
CHARGFo, EOR SERVIEE: 52/1 Sbl 1111 4 109 343 16 1 168 W 84 5 54A 124 34 ~ n8S 439 93 1 462 6~~ 41
OTHER SOURCES or REVENIIL 1 ~16 830 00 364 475 37 1 4S? 354 63 783 873 4b S~O 903 47 1~2 %y 9~
TOTAL REVENUI 45 787.28;' 00 3n Y81 14e ,K 8 805 533 72 ~3 SoO Y,.'4 "3 36 608 533 68 h yS2 390 95
*******EXPENDITURE~*******
GENERAL GOVIRNMlNT AcTIVITIE:
, II Y COllNrIL 3011 1114 011 209 278 78 91 4i~ t) 224 070 48 1% ;>S9 77 27 810 i"j
CITY MANACER 997 923 00 738 6011 01 ;'Sy 'm 99 919 9lb 6Y 719 741 41 i()().;;:15 28
CENT~AL SI-RVICES 5~S /;,11 IIV :;47 929 47 197 7911 5:\ ;11,2 244 59 290 IH;> 11 66 062 ~1
CITY ATTORNEY 824 252 00 425 196 13 39Y OSS 87 631 963 18 477 497 77 IS4 405 41
ADMIN cERVICES 1 648 603 no 1 1..22 i68 P.l 426 344 19 1 433 K/6 y4 1 138 442 98 ?% 433 96
BUILDING MANAGEMENT 734 foOl 00 5UU 037 98 23~ 619 0, 668 646 21 404 992 25 203 053 %
INSURANCE COST CENTER 422 038 UO Jll ~bO 61 11U 577 39 508 448 41 221 589 30 28G ~S9 II
ELECTIONS COST CENTER 2 890 00 2 221 40 668 00 12 265 33 l~ ;,/6S :n
NIIN-DEPARTMENTAL 87 712 UO 6 650 38 81 061 62 68 155 l:l 2 lI5 19 oS 979 94
ACTIVITY TOTAL 5 564 499 00 3 763 6:;:; 07 1 ~UO 865 43 ~ 8<'9 fAG 96 3 529 146 11 3UO 500 85
PUBLI C SAITI Y
~Ul IrE 11 :Ibl 037 ou 5 379 959 95 o Y81 077 05 9 837 84;' :'7 4 694 539 ~1 5 14~ .JU2 86
CROSSING GUA~DS 82 1~0 Oil S:1 1135 06 29 104 94 71 407 04 4R ?4:1 5G 23 In:' 4H
AN1MAL LIINTROI 2118 8% OU 53 428 29 100 409 71 20B 369 91 6" 037 41 14;,1 :r~2 50
TRAFFIC SIGNAL, & STREET LlGHIIN 18 110 00 ~ l~'~ 64 8 986 36 K 087 87 5 593 90 2 993 97
01 SASTER PRIYARFDNESS n7 Sol "II 43 772 67 23 '~4 3:1 68 023 15 40 145 59 27 811 S6
fI RE SERV ICES H ~02 188 00 4 588 %0 h4 4 313 222 36 8 201 Y44 .)8 4 313 BD6 76 :\ 894 137 62
ALTIVIIY TOTAL 20 639 '1311 Oil llJ 128.285 25 10 511 n44 10 18 402 174 62 Y lbH :;66 63 9 233 flu/ 99
TRANSPORTATION
PUBLI C WORKS 808 577 00 WI ~71 65 211 205 3b 7')3 562 41 501,287 03 166 D5 38
STREET MAl N I f NANCE 311 :n4 [III 57 50 311 20b su 15 906 28 12 510 61 :\:m 67
:;TREET SWEEPING 15U 670 00 91) 7!~: % 55 897 n5 140 /8~ ~5 9~ 8'14 "y 45 889 ~6
cTREEr TRI.1 MAINTENANCE 9'! 4:;11 1111 38 654 22 611 liS 7~ 99 195 40 21 642 67 II ~52 78
';TREET LANDSCAPING MAINTENAN 735 124 00 46~ 410 H:' 270 708 18 fi8;' 156 30 442 0~8 04 240 707 7h
Ac II ,11\ Ti'TAI 1 82~ llo 011 1% 272 14 62g 84? KfJ 1 662 2015 29 J:'H ~83 24 5~~:~ H/:1 us
I-IIAI. I H & WEIEARE
WASTE MANAGEMLNI 71 474 64 6H :157 22 3 111 42
CHILD CARL 15 01111 011 15 0011 00 15 000 00 15 000 011
SOCTAI SERVICE,j
HOUSING PROGRAMS 199 15 (P! IS!
'7 ~ I;;
THE cITY OF DUBLIN STATEMENT SHDW1NG Z; ..~
REVENUES VERSUS EXPENDJTIIRI ';
~OR THE PERIOD
07IUl/?1J05 THROUGH 04/30/2006
GENERAL R f V F N IJ E FUN D
CURRENT cURRLNI PRIOR PR lOR
~UOGET ACTUAL VARI~NCf FISCAL YEAR Y I IJ VAR1ANCE
ACTIVITY IIIIAI 15 000 no 15 noo 00 86 ~7~ h4 H~~ 556 37 < Ylti ?7
CULIURL & LEnlRF SERV1CES
lIBRARY :;ERV1CES 6<8 m UO 466 821 28 161 ~49 /< 577 734 07 ~<3 e/H 'J(; 154 455 71
CULTURAL ACT1VITIES ;'"'?5 701 uo 18S 250 53 40 4S0 47 125 102 O~ 8b 2b( 72 38 639 3:'
HER1TAG[ ([NIL, 163 333 00 116 lli 69 47 215 11 125 6~1 44 97 71E 24 el y,S 20
DUHI IN CFMETERY 49 %1 1111 01 11111 97 28 857 03 411 S73 15 24 50S 61 16 067 28
PARK MAINTENANCE 712 065 00 917 6nl e7 IY4 4"3 73 1 450 064 06 Y4h 321 21 503 74:' :il
LUMMIINIT, TV 06 4111 110 60 425 58 5 981 4e (,1 H09 00 59 WI 110 .2 6411 00
RECREATION ADM1N 7118 .174 00 53:..; 078 28 175 U95 72 608 76U 76 41,9 787 13 IJf3 CJI'~ 6,j
PLAYGROIINDS 275 357 on 18U 3114 97 94 992 03 <41 "14 "7 192 792 60 ;,4 421 67
SHANNON CENTER 34;> 70b OU 256 657 61 86 048 39 :Wl 071 12 U~ Y7~ 87 21 O~I co
PRESCHOOL lU5 458 DD 85 031 56 ?,O 426 32 82 63~ 86 65 180 23 11 459 63
TEENS PROGRAM 159 835 OU lU9 65~ 11 5D 181 89 RI :1U6 66 63 839 41 23 467 25
AOLIIT SPORTS 1UY i~O 00 59 236 02 49 993 9R 92 694 DI n9 4H8 44 23 200 b7
YOUTH ~rORT:; IS~ 6.17 00 12D 9~9 ~1 :(> fi67 59 118 533 3'1 93 168 4D <0 3104 99
COMMUN II Y GYM 43 ~59 UO 311 7:1R ?,S 12 72D 75 42 H87 87 33 758 I~ 9 129 68
EMERALD GLEN ACTIVlTY I:EN1TR
SPLCIAL fVFNr, 36~ nUl UO ~:IG 493 43 28 1117 01 ~~1 898 19 301 ohl R9 24 33h 311
SFNIOR cENTER 3(,S 728 OD 315 D5D ID 00 G77 9u 253 lCl 211 19~ 635 82 0'1 4ti5 .18
RECREATlON INSTRur:rION 183 023 nD 121 482 1~ 58 540 81 .17~ 4Y2 7S 133 811 lie 4U 681 7]
AOIIATICS ~29 2:n no 085 709 82 143 511 lK ~93 660 59 "13 070.28 12D 1184 :>1
P~RKS/FACIL1TIES ~N~EMENT 3UR 494 UO 231 on3 02 II 490 9R 261 928 01 205 569 02 bfJ '1S9 r;s
ACTlVITY TOTAL 6 394 638 00 ~ ~30 100 41 958 872 S9 5 3/1 1:1:~ 52 4 DI9 J~o III 357 737 82
COMMUNlTY DLVllOPMFNT
PI ANN1NG 2 6H5 164 UU I 737 288 51 94/ 87" 49 2 414 972 03 1 988 996 D6 520 976 47
BU1LDING SAfLIY 3.21~ 610 DII 1 Sl3H H1Y 22 1 275 795 78 2 ;{yg 434 25 1 66~ 6I1 :1H 714 822 67
ENGINEERING L 194 005 OU 1 7il 217 10 4/, 787 9D 2 3n~ 6'11 05 1 716 711 21 581 YHO 34
ECONOMIC U,VFIOPMENT 355 628 1111 ;52 224 36 ID3 ~U3 64 272 379 63 2~U 0110 12 31 879 51
ACT! V 1TY TOML 6 449 41:' 1111 5 649 549 19 2 )~9 %2 81 7 391 477 96 5 S:JO 818 77 1 860 hS9 1~
CAPlTAL 1MPROVEMENT PRIlJLC I S
GENERAL r: I P PROJFUc, 1 375 60h UU ?04 266 80 I 171 56'! 20 633 849 26 491 5?4 ~7 142 224 t\y
I;OMMlINlTY IMPROVEMENTS K74 999 00 631 673 n5 24j :QS 95 4D3 11U Uy 32 502 97 3/11 b07 12
PARK~ I 68U 115 DD 673 Ib1 H~ I 006 963 .17 < 630 O?U 78 2 085 361 Ul S44 659 77
STREET CONclRClIMPROVFMENTS 1 488 nl~ UO 239 1Vb 30 1 248 912 10 9RO 26D 11 IUb '145 OS 274 315 Oh
ACTIVITY TOTAL h 41H YH9 00 1 748 197 98 3 filO IYl 02 4 647 2'10 24 3 ~15 433 4D 1 c31 KOh 84
TOTAL EXPENOITllRfS 48 3D6 063 DO ;'6 9:15 7U:1 54 21 37D 879 4fi 4? 39b :354 23 26775 lUll ,2 15 621 251 01
EXCESS REVENUE I EXPENDlTURL'.) \2 519 301 00) ID D~n 1144 /4 ll<' 565 34S 74) 164 olU 4U 9 833 433 ~h '1 bb~ 863 D6\
TRANSfERc 1N FROM OTHER FUNDS ~7S 0":; 00 475 U"3 00 27 23D 91 27 OJ 9\
IRANSFERS OIlT FROM OTHER fUNDS
REVENIIES OVERI UNIJ~ R I f XPENDlTURES ,2 D44 24H IIU) ]11 1J4b 044 74 112 090 292 74, 191 801 31 9 833 4:':' 46 ,8 641 n32 1;')
'l o~ /::>
IHf 1.11 i 8F DUBLIN STATEMENT SIIOWING
REVENUES VERSUS EXPlNUIllIRES
FOR THE PERIOD
07/01/2005 THROUGH 01/30/200h
S P l C Al REV E N U E FUN U S
CURREN"I (:URRfNT PRIOR PR lOR
BUIJI;FT ACTUAL VARIANCE f I ';CAI. iEAR Y T D VARIANCE
********RC VL NI JI- ~********
PROPERTY TAXES 11/ n~O 110 1 U8 002 42 9 677 5B 112 032 03 105 199 21 7 332 7C
SALES TAX/OTHER TAXES 3bU 500 00 272 162 71 ~8 'm 2~ 364 477 II n~ III 91 144 765 ~O
,INE'; & fURfLlTIIRFS 156 000 00 119 1'J[ ~4 3(, 5U8 16 149 311 93 91 412 17 57 929 Ib
IISES/MONE', & PROPERTY 99 10/ 1111 bK (,13 05 31 143 95 1 V2 9:,? ;>y 47 549 70 ~~ :m2 59
INTERGOVERNMENTAL fROM SIAlf 014 231 00 811 130 II 203 1011 ~Y 2 354 339 65 1 ~ol 420 05 502 913 60
IN I lRGOVFRNMFNTAl FROM cOUNTY 340 1111 110 1 ~:' 390 110 147 050 00 332 344 00 182 650 00 Wi 094 00
INTFR(,OVERNMENTAl FROM FEOERAl In 192 00 77 48~ 23 4 309 77 on 790 HII 37 726 21 1Y 11711 56
CHARGES FOR SERVIClo 350 461 UO 1 253 018 16 q/ 4]~1 H4 1 075 178 65 1 02~ 141 U4 47 031 61
OTlllR SIIIIRCFS OF REVENUE 409 5011 00 4:~~ 0:;/ no I 25 537 00 ) 110 46e "'1 15 419 E5 100 116;' 74
TOTAL REVENUE 3 9?S 3(,1 uo 3 333 357 52 592 003 4R 4 718 425 40 3 579 ;:>41 y:; 1 139 183 52
:k:k:k:k-,l(":k1rI'XPFNOITlJRES*******
PUBLl C c^FETY
POll Cl 120 255 00 1110 ';Y6 95 14 858 05 105 95;' 411 105 639 67 11? 73
TRAFFIC SIGNAlc & STREET lTG ;>:>4 11111 IIU 168 912 22 65 187 16 1n 175 14 122 594 % SO 580 1':::1
OISAcTER PREPARlONljS
fl~L. jl"~VTCFC, 270 120 on 1~4 Y7h ~~ 135 143 77 201 0~1 01 85 228 83 I (,S 362 38
^CTl V In TOTAL 62S 075 011 409 285 40 215 7SC! hO S~U ~18 75 3lJ 4h3 45 ~16 755 3U
TRANcPORTATlON
srRFFT MAINTENNU 3:l0 4/4 00 eOO 531 18 129 912 ~2 en 390 25 131 601 4h 134 738 79
cTREET SWEEPING
ACTIVII Y IIlIAI 330 474 00 200 531 T~ 129 942 82 27~ 190 I'tJ 137 651 16 134 733 79
fllAl TH & WELFARE
W~TE MANAGEMENT ~74 906 00 1 133 nS9 ~~ /41 H16 78 I 383 901 16 632 906 17 101 1107 99
SOCIAL :;I,KVICFS 6n Ij~! 00 17 745 25 22 681 70 44 ~27 00 '32 1110 AI 12 m 13
HOLlSING PR[x;R;l}IS
~ClIVIIY I[)I~I 1 935 333 GO 1 1111 934 4/ 764 498 53 1 42~ I'll 16 714 922 r1'l 11:; 969 12
COMMLlNITY OEVElOPMENT
ENGINEERING 6 000 00 n 0011 IIU 6 0110 00 6 000 00
ACT! V In TOT ^l 6 OliO UO r: 000 00 (, 000 00 6 1I0U IIU
CAPITAl IMPROVEMENT PROJECTS
('ENERIIl CIP PROJli:TS
COMMIIN I. I Y PROJECTS J'I o~h UO 29 791 00 9 760 110 14 850 00 11 8511 [II)
PARKS 31 310 00 :n ~1U 00 321 III 110 .288 635 211 3:, IIKI 76
STREET \:ONS I KIUIONIlMPROVEMENT I 670 ~03 00 047 0(,2 01 1 123 540 '1'1 149 554 78 75 4"~ 11 74 149 01
ACTl V In TOT ^l 1 /41 bh9 011 577 053 01 1 104 olS 99 486 121 7~ :;64 040 95 12~ (]HU H3
"I 0 I A l EXPENDITURES 4 644 115 UU .2 368 528 02 2 21~ 5H6 93 2 723 621 94 1 5:;6 077 90 1~1 ~44 U4
EXCEcS REVlNIIl (fXPENDITIIRE'; I (ll8 154 011 I %4 H2~ 50 11 683 583 50' 1 Y~4 803 51 2 1143 ]64 O:J \43 360 52)
IKANSFER IN FROM OTIIER ,UNDo
TR^NSFERS our TO OIHl, FUNDS 88 731 011 h ',00 III! 82 137 00 1 'J:Jb 274 58 1 336 271 "H
REVENUES OVER (UNOlK) lXPlNlIlIIIlW 1807491 00\ 95~ 2','~ 011 \ 1 765 720 50) 6~~ 0?8 93 2 013 161 113 \1 J84 635 III!
THE CITY OF DUBLIN ,TATEMENT SIIOWING
REVENUES VERSUS LXPLNDI IU~ES
FOR Till PL~lOD
07ln1/2UUo IH~(}IJI;H 114/';UI,IIII"
'1'vif:"
5 r E C I A L ASoLSSMI' N T FUN D ,
CURRENT CURRENT PId OR PRIOR
IJIIIXil1 AU1IAL. VARIANCE FISCAL fEAR Y T D VARIANCE
****-,&;-A-A-.Io;RL VE NlJF~j********
';PFCIAI BENEFIT~ ~jSE~SMENT~ 664 6111 nu oell 129 33 e4 4BO 67 744 099 ~9 h83 yor, r,9 60 192 eu
USE,/MONEY & PROP-INTERE,T 10 4/H 011 10 053 4? 5 424 58 I~ 74S 10 6 265 99 8 ~S2 11
OTllER SOURCCS U~ ~LVlNUI 5 OOU uo 5 603 48 , 6U3 4H I
TOTAL REVENUE 68E uss no 0% IH6 23 e9 301 77 758 8~7 59 6911 17;> 08 68 67~ )1
****-,InIr.I;LXfJ~Nl)lTURFS******
PIIBLI C SAFETY
TRAFFIC ;IGNALS & STREET LIG Ll8 bOO 00 182 S89 78 96 010 ,-2 2:\1 5:n b? 167 398 66 h4 J:;4 96
ACI IVIIY IUIAL ~78 600 00 182 589 78 96 010 22 ? :JI 533 62 167 39S 6h fA 134 96
I ~ANSPUR I AT TON
PUBLI C WORK, ;: 41~ OU 1 GH6 54 728 ~6 1 oYl ?9 1 124 47 4hh 82
SIHLlI I~II MAINTENANCF 34 231 00 13 093 28 21 1:>/ 7" 18 466 76 lL 6fifi 11:1 5 80n 73
STREET LANDSCAPE MAINTENANCE 306 U3Y Uo :.'27 5U6 03 128 532 97 317 601 03 2Ul 070 56 ll6 "Hh 97
ACTlVllY lOTAI :1<:12 6H5 0 U 242 285 85 15n 39'1 1<; TQ 715 58 214 861 00 ]~.., 854 52
COMMUN ITY OEVELOPMENT
ENGINEERING 13 100 OU II 357 60 1 7~2 40 7 139 94 6 669 94 47U 00
ACTIVITY TOTAL 13 100 00 II 301 60 1 14~ 40 7 139 9~ o 669 94 ~711 UU
CAP IT Al IMPROVEMENT PROJECTS
COMMIINITY IMPROVEMENT, 3~ CJ20 OD Ie lOb (,9 14 813 31
,TREET CONoTRUCTION/lMPRVMNI 75 OOu UU 7E 000 OU
ACTIVITY TOTAL In7 920 on 18 10, 6'1 89 ~13 31
T UI A L LXPI'NOlTlIRF, 792 305 00 ~5~ 339 'It 337 '1;5 08 57E 3B9 1~ ';H8 929 66 IB7 ~59 4H
EXCEcS REVENUE (EXPENDITURES I [1U/.;>17 001 141 446 31 \2~8 063 3]) 1 H;J. 458 45 301 2'13 02 (11878457)
REVENUE, OVER I UNDER) EXPLND I IURFS 1107 217 00' 141 446 31 ms ofi~ 31) 182 458 45 301.243 II? : ll8 784 571
THE CITY or DUBLlN ';IAlfMENT :;HOWING
RFVFNUES VERSUS EXPENDITURES
FOR TIlE PERIOD
1I1/01/oUllo THROUGH 04/30/2006
IOofl?
E A PIT A L IMP, U V I M F N T FUN D S
r:lIRRINI CURRENT PR.IOR PR lOR
BUDGET ACTUAL VARIANCF FISCAL YEAR YI U VARIANCE
********REVENUE********
USEe/MONEl & PROP INITRL';I H6G 623 00 766 814 33 4e Hoe (,7 1 221 ,70 50 h4b :\14 12 676 656 38
OIHER o,lIlIRCFo, OF REVENUE 19 2el 628 UO 12 46/ B29 bb (, 799 795 34 11 361 '1<'1 97 11 B20 633 33 2 541 ,Y4 (,4
TOTAL REVENUE <'0 In IV UII L' 241.243 99 6 951 4B8 UI lh 89? '142 14 12 365 917 4b 4 S?(, 994 E9
*******EXPEND I Tl JRL~i*.I("~("**.};1..
GeNFRAI GOVERNMENT ACTIVITIES
CITY A TTORNEI 38 95U UO 39 140 ~7 \lyO 47: 35 736 ,9 15 e47 99 19 BBB 40
AC II V ITY TOTAl. 3B 950 no 39 1411 41 ,190 47) 35 736 "'I 15 B47 99 1'1 HHR 411
PUBI I C SAFETY
TRANSPORTATION
IIEALIll & WLLFARF
H[ II IS I NG PROGRilMS YU3 n:JII 00 "17 299 33 685 730 01 219 420 35 H3 nlf> 17 76 4n~ IB
UII.TURE & LEISURE SERVICES
RECREATION AllMINn~AII()N
ACTI V ITY Tor AL
COMMUN II Y lll' VH OPMENT
PI ANNI NG
ACTIVIn IIIIAI
CAPITAL IMPROVEMENT PROJECT';
GENFRAI CI P PROJECTS 1:, GOO 00 39 700 81 43 KY9 19 6<'4 9~3 3Y 144 059 02 48U 984 37
COMMUNITY IMPROVEMENTS 36 //1 011 ~G 771 00
P^RK~ 11 322 835 no J bYA lbA 01 7 724 66E 99 6 2BS be7 19 772 ~b[1 OU S 513 237 19
';TRELI CONSTRUCT! ON I IMPROVEMENT 36 3~1I 142 uv 1 4011 15S 00 34 889 9B7 [III 3 309 862 62 2 59B :J4Y YO 711 51<' /2
ACTIVITY TOTAL 4/ 740 077 UU o OBB 023 B2 4:' 60H 55:! Ie 10 257 ,04 %U J S14 B58 92 6 7 4~_l 4()S 28
TOT A L EXPLNIJI [IIR,S 48 68B ,57 110 " 344 4,,3 62 43 344 093 38 lU b/1 K9u 78 3 673 721 UB I, K9B 167 7n
LXCFC,o, REVENUE (EXPENDITURES' '<'B bSS .JOY UOI 7 890 IBO 37 (30 440 4K9 371 o 012 007 h9 B "Y? 224 37 (36811 nb bHl
TRANSFER IN FROM O'lHER fUND, (59484 no) 10 6UII Otl\ 152884 DOl 11 3U'! 04:, 1;7 J '1 :,OY 043 67 I
TRANSIUS 0111 TO OTHER FONDS 115 eoo 1111 4~5 800 UII
RFVFNUEo, OVER ,UNDER) lXPLNUJTURFC,I?R 941 625 00\ 7 B96 18[1 31 (31, H3R 405 37' 6 3<'1 ObI 36 8 692 224 3/ I;' 371 173 01 \
! I Of 1-:;
'._,)
THE cm OF DUBLIN STATEMENT SHUWING
REVENUE:; VLRSII'; I ,PI NlJlTlIRES
FOR THE PERIOD
07/01/21100 IHRU[K;H 04'3012006
T R U S T / AGE N C Y f II N D
CURRENT CURRENT PRIOR PR lOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y I IJ VARIMCE
********REVENUES********
SPECIAL ASSE;SMENIS 206 684 48 1200 68~ ~5' i;>H ?80 46 201 342 90 ;>" Y~j7 56
USI ':/MIINFY & PROP- INTERE5T 5 6'~ 36 \5 659 36) 5 612 63 3 139 "e 2 473 35
TOTAL REVENUE ~IO 343 84 1212 343 84 I ;>e:' eY3 09 2U4 482 18 ;>9 4111 91
*******EXPENDITURES*******
GENERAL GUVLRNMFNT ACTIVITIES
NON-DfPARTMENTAL 231 1138 110 i30 001. ;>5 ~31 75 de 571 18 ?31 421 18 I IoU 1111
ACT! V ITY TOTAL <"I 113e 00 230 506 25 531 75 :'3? 571 18 231 421 18 1 lC,U 00
PUBLIC SAfETY
I RANSPORTATION
HEALTII & WELfARL
CUll URL & LE hURF :;ERV ICES
UIMMUNITY DEVELOPMENT
CAPITAL IMPROVEMENI PRO, ILL I ';
TOT ^ L E<PENDITUREC "31 OJH 00 23U 506 20 '31 I" ":12 571 18 231 421 le I 150 DO
EXCE5:; REVENUE [LXPLN~j lURE'.' Inl 038 DOl 118 162 ~]) IL1~ H75 59) I 321 91 (~f1 g~g UOI 28 <60 91
REVENUES OVER (UNDERI EXPEND]lII~Lo ["31 03e 110 I I 18 162 41) [212 5/0 5YI I 321 91 w; Y3Y IIU! 28 2611 9]
THE I.IIY m IJIl~LlN STATEMENT SHOWING
REVENUES VLRSIlS IXPINII I I UHEo
FOR THE PERIOD
117101/2000 I H~OUGH 1l4/30/"1I06
1;Z 0 t I~
N I F R N A E S E R V ICE [ U N D S
CURREN I i:URHLNI PRIOR P~IOR
81lDGET ~CTU^L vARIANCE ~ l'iCAI YEAr! Y T 0 vARIANCE
********RL VL Nl JFS*****1r**
USES/MONEY & PROP-INTEREST ;':91 []W~ no lli' HS5 n 124 233 27 2~S 4117 :1/ llS 973 87 129 ~33 oil
CHARGES FOR SERVIce, 1 7% U96 00 1 338 844 57 457 251 ~3 1 fA? 441 30 I 387 334 1~ 20S 107 Il
OHlER SUIIRCE'i OF RFVFNIlF 23 400 00 31 510 011 1811000! 4 841 986 98 Y 993 55 4 831 993 ~3
TOTAL REVENUE ;! , Hl S8S 00 1 543 210 30 573 37~ 711 6 r>9 H3~ 65 I 513 3111 hI o illo 534 04
*~~1;*FXPFNDITURES*******
GENERAL GOVERNMENT ACTIVITIeS
NON uePARIMI..NTAI 2 092 680 110 51~ [JUH 28 1 579 771 72 :2 467 397 O;! 1 059 440 23 I 107 'lbh )g
ACTIVITY TOT^L 2 0~2 6811 00 o1? <JU8.?8 I 579 771 72 2 46/ 397 O? I 059 440 20 I 4117 gS6 79
PIlBU C S^FETY
FIRE 65 5El 00 30 0~8 81 .,s 51~ Ig 59 862 86 1S 172 IS 44 WO 71
ACTIVITY TOT^L 65 561 1111 30 048 81 35 512 19 5'1 8h? 86 1517215 44 fi9U 71
TRANSPORT^TION
HEALTII & WlLrA~L
(:ULlU~F & InSURE SERVICES
COMMUNITY DEVELOPMENT
CAPIIAI IMPROVEMENT PROJECT,
T 0 1 A L LXPENOITIIRES 2 158 2~1 00 04i' 957 U9 1 615 283 91 " o~'7 ?Sg 88 I 07~ 612 38 1 4S.2 647 50
LXIJSS REVENIIE ,EXPENDITURES I 141 6Sfi 0111 1 UOO.253 21 (I 011 9119 ;'l! 4 202 S75 77 ~3K hKg ?3 3 763 B86 04
TRMSFER IN [ROM UIHLR rUNDS
l~ANSFFR~ OIlT TO OTHER FUNDS
REVENUL, UVE~ IIINDER' EXPENDITURE:; 141 fi56 on, I 000 ?S:J ~I (l 041 909 21 \ 4 ;!Il/ 575 77 438 68'1 20 :1 763 886 51
********REVENUE~********
USLS/MONLY & ~ROP-INTFRF,T
TOTAL REVENUE
********EXPENDITURE.S*******
GENlKAL GOVERNMENT ArTTVlTlF"
NON-DEPARTMENTAL
,INANC[
~CTIVITY TOTAL
PUBLIC 'NETY
HI. Al TH & WELFARE
CULTURE & LEISUR[ SLRY H:L:;
Cl)1MUN1Il UFVFIOPMENT
CAFITAL IMPROVEMENT PROJECTS
TOT A L EX~lNOI IUKLS
LXU",'; KFYFNUE (EXPENDITURES \
TRANSFERS IN tROM OTIlER IUNDS
IKANSFFRS OIlT TO OTHER FUNDS
RLVLNUI:; IIVfK (UNDER) EXPENDITURES
CURRENT
BUDGET
IHF crn OF DUBLIN STATEMENT SHawING
REVENUES VERSUS EXPENDIIlIKh
FOR THE PERIOD
07/1l1/21111S THKOIIGH 114(JO/200[
I.NIIK~RI;;f
FUN D
CURRENT
ACIUAL
PRIOR
FlSCAL YEAR
VARlANCF
PRIO,
Y I D
I ?;Ot-13
VARIANCE