The URL can be used to link to this page

Home My WebLink About4.11 Financial Rept Nov2005 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)