The URL can be used to link to this page

Home My WebLink AboutItem 4.08 FinancialRptJan&Feb05 CITY CLERK File # oaJ~[fi]-[1j1QL AGENDA STATEMENT CITY COUNCIL MEETING DATE: March 15, 2005 8IJB./ECT: Financial Reports for the Months of January and Fcbruary 2005 Report Prepared by: Carole A. Perry, Administrative Services Direclor and Fred w: Marsh, Finance Manager ATTACHMENTS: I. YTD Rcvcnues and Budget Comparison 2. YTD Expenses and Budget Comparison 3. Financial Statements for January and February 2005 RECOMMENDATION:g ~ Receive the reports. FINANCIAL STATEMENT: See reports for detail of monthly tlnancial activity. DESCRIPTION: This item provides the report on thc preliminary tlnancial statements for the months of January and Fcbruary 2005. Consistent with prior reports, the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion ofthc City's operations. Note that the City's revised budget has now accounted for all items affccting the City as part of the State's adopted budget for Fiscal Year 2004-2005. Analvsis of January and February 2005 Revenue and Expenditure Reports The January and February reports rcprcscnt the reporting of revenues and expenditurcs for the eight months ofthc Fiscal Year, through February 28, 2005. It should also bc 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 signitlcant amount of scrvices provided to the City by independent contractors, including Police and Fire Scrvices, General Fund Revenues Total General Fund Revenues collected through February are comparable to what occurred in the eighth month of the previous Fiscal Year. Through February 2005, the City had collected approximately 61% of thc total budgetcd General Fund Revenues, which was 5% more than the percentage collected in the prior Fiscal Year. A brief description is provided bclow to explain any material revenue variations. Rcal property transfer taxes are higher than in the same period of thc prior year due to timing differences in the collection of these taxes and two large transfers of properties by residential and commercial developers that occurred in previous months. Transient Occupancy Taxes are higher than in the same pcriod of the prior year due to higher occupancy rates and room rates at some of the City's hotels. Licenses and Permits are higher than in thc same period of the prior year due to an increase in the valuation of building permits on new residential and commercial projects. Interest and Rentals received to date (in dollars) are higher than the prior year due to timing differences in the receipt of interest payments _____________________________~_M______________________-__________________________~___________________________ COPIES TO: Documcnt in t'SCOLOR O~"Z005 \ttJ~ ITEM NO. ~ and an increase in the rate of return on the City's investments. Initially all interest revenue is recorded in the General Fund and is thcn allocated quarterly to other funds on a pro rata basis. Intergovernmental rcvcnuc, as a Dercent of the budget, is higher than in the prior year. However, the actual revenue dollars are lower than in the same period of thc prior year due to the cuts to the VLF allocation that werc implcmcnted 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 adopted budget plan. Charges for Services are higher than in the same period of the previous year due to additional wning and subdivision fccs and plan check and inspection fees received due to new development. Fines and Forfcitures are higher than in the same period of the previous year due to higher collections of parking and court fines. Other revenues arc highcr than in the same period of the prior year due to developer rcimbursements received for the costs of maintaining ncw storm drains and reimbursements received ITom the City of Pleasant on for the dcsign of improvements to the Fallon Road Interchangc. General Fund Expenditures Overall, through the month of Febnmry, expenditures in thc General FWld totaled about $20.5 million and represented approximately 45% of the total budgetcd cxpenditures in the General Fund. Of this amount, a total of approximately $2.4 million was related to Capital hnprovement Projects and the remainder was re1atcd 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 Expcnditures, the activity through Febmary 2005 was lower than the amounts expended for the same period in the prior Fiscal Year. Through the end of February 2005, thc City had expended 47% of the General Fund Operating Budget, which was 3% less than the amount expcndcd in thc prior Fiscal Year. Other Public Safety is lower than in the same period of the prior year due to timing differences in tbe payment for Animal Control and Traffic Signal and Strcet Lighting expenditllres. Health and Welfare is higher than in the same period of the prior year due to expenditures incurred for the evaluation of contractor proposals submitted for waste management services. Capital hnprovcmcnt Project expenditures are higher than in the same period of the previous year due to cxpenditures incurred on the construction of the new senior center. All expenditures are within the authorized budget. It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code, ~11b9-. \ "b 2..f .----.--.-- City of Dublin 2004-2005 YTD Revenues and Budget Comparison _ For_the :eri 8._2 05..._ FY 2004105 FY 2004/05 %of FY 2003104 Budget YTC Actual Budget YTC Actual Property Taxea 13,661,980 7,515,739 55% 5,942,512 Sales Taxes 13,613,216 8,495,435 62% 8.421,073 Real Property Transfer Tax 520,000 430,143 83% 289,105 Transient Occupancy Taxes 610,000 371,936 61% 360,325 Franchise Taxes 1,536,000 622,048 40% 585,730 Licenses and Penn Its 2,723,912 2,818,959 103% 2,238,018 Interest and Rentals 1,538,090 655,572 43% 421,888 Intergovernmental 449,100 362,838 81% 885,453 Charges for Services 5,177,916 3,173,721 61% 2,554,574 Fines and Forfeitures 112,900 88,204 78% 63,646 Other Revenues 952,837 541,367 57% 126,284 Total General Fund Revenues 40,895,951 25,075,762 61% 21,888,608 Total General Fund Revenues Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services Fines and Forfeitures Other Revennes Da1e-Pr1n1Iod:JlJI'lOCI'jIjjl:41AM 8% . FY 2004ï~] . FY 2003/04 -.-..----- 103% 57% 0% 120% 150% 30% 60% 90% 67% of Year Complete I ___I % of Total for FY 2003104 53% 60% 51% 54% 39% 72% 68% 48% 53% 54% 15% 56% ð-15- 0:;- 0+,8' ATTACHMENT 1 " ØfJ'2. 't Health and Welfare City of Dublin 2004-2005 YTD Expenses and Budget Comparison For the PeriodEndin 45% 47% General Government Fire Other PUblic Safety . FY 2004/05 . FY 2003104 Transportation 101% CUlture & Community Services Community Development Capitallmprov. Projects 0% 20% 40% 60% 80% 67% of Year Complete 100% 120% --.......-----...... 2004105 2004/05 %of FY 2003104 % of Total for Budget YTD Actual Budget YTD Actual FY 2003t04 General Government 4,964,972 2.748.731 55% 2,742,343 59% Police 9,883,259 4,407,282 45% 4,323,620 50% Fire 8,156,645 2,314,681 28% 2,208,367 30% Other Public Safety 421,298 90.159 21% 121,543 36% Transportation 1,690,651 904.969 54% 857,610 56% Health and Welfare 78,125 78.676 101% 36,393 44% Culture and Community Services 5,871,806 3,129.877 53% 2,897,564 57% Community Development 7,807,374 4,429,097 57% 3,718,031 59% Capital Improvement Projects 6,709,036 2,379.771 35% 1,390,164 30% Total General Fund Expenses 45,583,166 20,483,243 45% 18.295,635 47% General Fund Operating Expenses 38,874,130 18,103,472 47% 16,905,471 50% o.uf'rI_:~5,..¡:aAM ATTACHMENT 2 ~&þt.+ CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JANUARY 2005 Prepared by The Finance DeparlIì10nt March 2, 2005 ATTACHMENT 3 ~14 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Jan2005 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOT A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY--- FUNDS FUNDS FUNDS FUNDS FUND CURRENT PR IDR A5SETS CASH (51.860,320) 5,119,631 5BO . 728 38,547,740 136,336 (7,475,886) (20,597,459) CASH WITH FISCAL AGENT 172,779 172 .779 172,779 AMOUNT HELD IN ESCROW INVESTMENTS AT COST ID5 .748, 6B5 105,748,685 94.761. 254 RECFIVABI.ES, TAXES ACCOUNTS 23,148 52,B84 76,031 176,761 INTEREST 200,330 ASSESSMENTS DUE FROM OTHERS 1. 989,267 1. 989,267 308,720 INVENTORY AT COST PREPAID ITEMS 10.796 10,796 9,923 F I XED ASSETS 4,500,000 4.500,000 AMOUNT TO BE PROVIOED 1. 334,500 1. 334,500 1. 447 ,500 TOTAL ASSETS 55,911 , 576 5,172,514 580,728 43,047,740 1. 643,615 106.356,173 76,479,808 LIABILITIES/FIINO EOUITY DEPOSITS FOR PRIVATE DEVEL (1,221,079) (1,227,079) (702,364 ) DEPOSITS FOR AB1600 FEES (162,635) (208,363) (370,998) (2,460.271) OEPOSITS OTHERS (2.564,679) (2,564,619) (1,272,098) PAY ABLES , ACCOUNTS (217,034) (12,B50) (1/2,616) (402.500) (1,210,451) INTEREST PAYROLL (541,604) (541,604) (463,388) DUE TO OTHERS (160,054 ) (1.829,213) (1.9B9,267) (328,124) DEFERRED REVENUE (127,768) 027.168) (127,768) DEBT INSTRUMENTS PAYABI_F (1.452,000) (1.452,000) (1,565,000) TOTAL LIABILITIES (4,840,798) (172,904) (2,210,192) (1.452,000) (8,675,894) (8,129,463) FUND BALANCES (51.070,778) (4,999.610) (580.728) (40.837,548) (191. 615) (97,680,278) (68,350,345) TOTAL FUND E (51,070,778) (4,999,610) (580,728) 140,837,548) (191,615) (97,680,278) (68,350,345) TOTAL LIABILITIES/EQUITY (55,911,576) (5,172.514) (580,728) (43,047,740) (1,643,615)(106,356,173) (76,479,808) 6Db1.tf CITY OF DUBLI N BALANCE SHEET FOR THE PERIOD ENDING 31Jan2005 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOTALS SERVICE FUNO GROUP OF TERM DEBT ---MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 8,573,457 8,573,457 7,698,051 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES, TAXES ACCOUNTS INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 46,511,915 39,208,244 85.720,159 66.732,089 AMOUNT TO BE PROVIDED 66.753 , 945 66.753,945 68,683,627 TOTAL ASSETS 55,085,372 39,208,244 66.753 , 945 161. 047,560 143,113,767 LIABILITIES/FUND EOUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR ABI600 FEES DEPOSITS OTHERS PAY ABLES , ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE TOTAL LIA8ILITIES FUND 8ALANCES (55, D85, 372) TOTAL FUND E (55,085,372) ()7 .215) (66.753,945) (66.753,945) (66,753,945) (68,683,627) (66,753.945) (6B,700.842) (94,293.615) (74,412,925) (94,293,615) (74,412,925) (39,208,244) (39,208,244) TOTAL LIABILITIES/EOUITY (55,OB5,372) (39,208,244) (66,753,945) (161,047.560)(143,113,767) LP~'".?t.f THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 01/31/2005 G ENE R A L REV E N U E FUN 0 CURRENT CURRENT PRIOR PRIOR BUOGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES 13.661. 980.00 7,515,739.07 6,146,240.93 11.316,703.32 . 5,942,512.05 5.374,19127 SALES TAX 13,613,216.00 7.472,534.84 6,140.681.16 13,940,263,36 7,109,373.15 6,830,890.21 REAL PROPERTY TRANSFER TAX 520,000.00 430.142.83 89,857.17 571,360,79 289,105.02 282.255.77 HOTEL TRANSIENT OCCUPANCY TAX 610,00000 338,188.07 271, Bll, 93 664,308,51 302,347 86 361. 960.65 FRANCHISE TAXES 1.536,000.00 552,659.92 983,340,08 1.505.434.53 521.516.72 983,917 ,81 LICENSES & PERMITS 2,723,912.00 2,622,679.82 101. 232 .18 3,090,992,17 1. 836 ,562.88 1.254.429,29 FINES & FORFEITURES 112.900.00 79,502.0B 33,397,92 117 , 369 .48 50,40740 66.962,08 USE/MONEY & PROP-INTEREST 1. 369 .725.00 587,894.75 781. 830 . 25 492,971.23 331. 616.31 161. 354,92 USE/MONEY & PROP-RENTALS 168,36500 60,163.78 108,201.22 130,741.40 77,784.92 52 . 956.48 INTERGOVERNMENTAL 449,100.00 350,121. 21 9B, 978.79 1. 828,992 . 93 699,909.20 1.129,083.73 CHARGES FOR SERVICES 5,177,916.00 2,751.873.07 2,426,042.93 4.801.136.74 2,201.060.35 2,600.076,39 OTHER SOURCES OF REVENUE 952,837.00 469,058.50 483,778,50 860,434,13 121.347,73 739,086.40 TOTAL REVENUE 40,895,951. 00 23,230,557.94 17,665,393,06 39.320,708.59 19.483,543.59 19,837,165,00 *******EXPENOITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 262.91000 120,211.15 142,698.85 209,858.23 102,660,86 107,297.37 CITY MANAGER 928.273.00 515,362.27 412,910,73 817,034.42 452 .778.25 364,256.17 CENTRAL SERVICES 350,911.00 192,514.35 158,396.65 341. 914.49 194,013,09 147,901.40 CITY ATTORNEY 689.493.00 298,848.14 390,644,86 700,797,95 392.203.39 308,594.56 AOMIN SERVICES 1.557,095.00 777,423.66 779,671.34 1,244,537.07 683 .736,89 560,800.18 BUILDING MANAGEMENT 641.134.00 318,652.83 322,481.17 757,522.96 348.260,29 409,262.67 INSURANCE COST CENTER 358.98600 204,480,66 154,505.34 420,061. 97 250.418.65 169,643.32 ELECTIONS COST CENTER 15,670.00 2,972.41 12,697,59 3,048.13 2,895,03 153.10 NON-OEPARTMENTAL 160,500.00 160,500.00 125,656,16 125,656.16 ACTIVITY TOTAL 4,964.972.00 2.430,465,47 2,534,506,53 4,620.431. 38 2,426.866.45 2.193,564,93 PU8L1C SAFETY POll CE 9,883,259.00 2.176,519.28 7,706,739,72 8,570,937,09 2,410.652.26 6,160,284.83 CROSSING GUARDS 72,283.00 27,571.66 44,711.34 65.794.14 22,246,25 43,547,89 ANIMAL CONTROL 266,36200 19,242.00 247,120.00 198,953,52 57.513.37 141.440.15 TRAFFIC SIGNALS & STREET LIGHTIN 17.24000 3,90175 13,338.25 6.543.33 579.31 5.964,02 DISASTER PREPAREDNESS 65.413.00 30,770.04 34,642.96 70.993,74 30.750,28 40,243.46 FIRE SERVICES 8,156,64500 2.293,937.32 5.862,707,6B 7,440.483,12 2,172,313.29 5,26B.169.83 ACTI V ITY TOTAL lB ,461.202 00 4.551.942,05 13,909,259.95 16,353,704.94 4,694,054.76 l1,659.650,IB TRANSPORT A TI ON PU8L1 C WORKS 738,575.00 391. 999.54 346,575.46 686,881. 45 386,987.18 299,894.27 STREET MAINTENANCE 14.802.00 24.785.01 (9,983,01) 3,703.99 312.50 3,391.49 STREET SWEEPING 149.207.00 45,877,64 103,329.36 130,351.29 52,814.95 77,536.34 STREET TREE MAINTENANCE 97,352.00 16,389.20 80,962.80 117.583.47 49,535.93 68,047.54 STREET LANDSCAPING MAINTENAN 690,715.00 306,865,19 383,849.81 593.488,01 245,572,37 347,91564 ACTIVITY TOTAL 1.690,651. 00 785,916.58 904,734.42 1.532,008.21 735,222,93 796,78528 HEALTH & WELFARE WASTE MANAGEMENT 63,125.00 63,387.46 (262.46) 46.419,04 46,41904 WILD CARE 15,000.00 15,000,00 18,500.00 18,500.00 SOCIAL SERVICES 1.000,00 1. 000,00 HOUSING PROGRAMS 16,893.18 16,893.18 '7Þ:fJZ'f THE CITY OF OUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOO 0710112004 THROUGH 01/3112005 G ENE R A L REV E N U E FUN 0 CURRENT CURRENT PR lOR PRIOR BUD3ET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE ACTIVITY TOTAL 78,125,00 78.387.46 (262,46) 82.812.22 36,393.18 46,41904 CULTURE & LEISURE SERVICES LIBRARY SERVICES 582,730.00 274.417 64 308,312,36 522,604,10 247,551-49 275,052.61 CULTURAL ACTIVITIE5 163,918,00 6Ll59.30 102,758,70 110,249.30 84,379.12 25,870,18 HERITAGE CENTER 141. 775.00 66.95829 74,816.71 99,628,11 58,583,32 41.044,79 DUBLI N CEMETERY 53,602,00 17.429.22 36,172,78 53,533.84 27,238.17 26,295.67 PARK MAINTENANCE 1.532,409,00 671.204.70 861.204.30 1.403,774.51 640,027,36 763.747,15 COMMUNITY TV 62,999,00 57.34900 5,650.00 62,020,72 58,006,22 4,014.50 RECREATION ADMIN 638,564.00 323.68452 314,879,48 518,312,54 291. 605,04 226.707.50 PLAYGROUNDS 277 ,082,00 144.945.76 132,136,24 237,599.33 130,630.17 106,969.16 SHANNON CENTER 389,176.00 199.39061 189,785.39 294,742,36 152,162,02 142.580,34 PRESCHOOL 90,699,00 46.770.65 43,928,35 77,388.27 41.483.45 35,904.82 TEENS PROGRAM 118,941-00 45,769.49 73,171-51 86,212.99 43,560,20 42 , 652 .79 ADULT SPORTS 110,559.00 50.80923 59.749,77 101.640,17 55,986.91 45.653.26 YOUTH SPORTS 138,824,00 55.640.09 83,183.91 122,764.81 57,847,57 64,917,24 COMMUN ITY GYM 46,504.00 13.761.44 32,742.56 37,309,40 19,016,21 18.293.19 EMERALO GLEN ACTIVITY CENTER SPECIAL EVENTS 339,220,00 169.451. 88 169,768,12 348,052.22 179,277.13 168,775.09 SEN lOR CENTER 297.455,00 132,585.96 164,869.04 223,784.61 118.451. 05 105.333,56 RECREATION INSTRUCTION 195,220.00 94.77339 100,446,61 185,369.65 98.966.22 86,403.43 AQUATICS 407,136,00 203,62Ll7 203,514.83 366,568.40 183.407.28 183,16Ll2 PARKS/FACILITIES MANAGEMENT 284,993.00 148.21714 136,775,86 246,546.42 137.131-98 109,414.44 ACTI V ITY TOTAL 5.871.806,00 2,777,939.48 3,093,866.52 5.098,101.75 2,625.310.91 2,472,790.84 COMMUNITY OEVELOPMENT PLANNING 2.731.301. 00 1.367,145.83 1.364.155.17 2,271.403.13 1.141.103.39 1.130,299,74 BUILDING SAFETY 2.580,214.00 1.117,89206 1. 462,321. 94 1.907,211.35 839,671.55 1.067,539.80 ENGINEERING 2.209,633.00 Ll62, 065.98 1.047,567.02 1.861. 971, 85 939,287 35 922,684.50 ECONOMIC DEVELOPMENT 286,226,00 203,894,85 82,331.15 302,134.33 235,852 91 66,281. 42 ACTIVITY TOTAL 7,807,374.00 3,850,998,72 3,956.375.28 6,342.720.66 3,155,915.20 3,186,805.46 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1. 079,341. 00 335,042.50 744.298,50 1.163.181. 54 150,120.04 1. 013.061. 50 COMMUNITY IMPROVEMENTS 877 ,070,00 21. 921.35 855.148.65 718.087,36 331.182.87 386,904.49 PARKS 3.333,232,00 1.668,129,57 1.665.102,43 1. 831.348.20 438,672.52 1,392.675,68 STREET CONSTRC/IMPROVEMENTS 1.419,393.00 256,694.85 1.162.698.15 938.789,96 350,363,60 588.426 . 36 ACTIVITY TOTAL 6.709,036,00 2.281.788,27 4,427.247,73 4,651-407.06 1.270,339.03 3,381. 068.03 TOTAL EXPENDITURES 45,583,166.00 16.757,438.03 28,825.727,97 38, 68Ll86. 22 14.944,102.46 23.737.083.76 EXCESS REVENUE (EXPENDITURES) (4,687,215.00) 6,473,119,91 (11,160.334,91) 639.522.37 4.539,441.13 (3,899.918.76) TRANSFERS IN FROM OTHER FUNDS 21. 885.10 21.885.10 TRANSFERS OUT FROM OTHER FUNDS (20,00) (2000) REVENUES OVER(UNDER) EXPENDITURES (4.687,215.00) 6.473,119.91 (11,160,334,91) 661.387.47 4.539,441.13 (3,878.05366) 't lib 2. r{ THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 01/31/2005 S P E CIA L REV E N U E FUN 0 S CURRENT CURRENT PR lOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES 111.049.00 56,837.59 54,211,41 105,605,41 53,194.09 52,411.32 SALES TAX/OTlIER TAXES 336,500,00 122,240,82 214,259,1B 357,441.52 149.067.63 208,373,89 FINES & FORFEITURES 164,000.00 52,016.18 Ill. 983.82 154,784,03 65,910,87 88,873.16 USES/MONEY & PROPERTY 89,248.00 30,778,45 58,469,55 29,822.10 20.355.06 9,467,04 INTERGOVERNMENTAL FROM STATE I.l88,010,OO 1.674,784,21 (486,774.21) 2,590,885.16 2,025.046,54 565,838,62 INTERGOVERNMENTAL FROM COUNTY 306,890.00 72,652.00 234,238,00 259,149,00 52.093.00 217,056.00 INTERGOVERNMENTAL FROM FEDERAL 109,717.00 2,790,99 106,926,01 253,139.22 39.408.42 213.730,80 CHARGES FOR SERVICES I. 056 .723,00 543,712,28 513,010.72 988,833.16 497.885,40 490,947,16 OTHER SOURCES OF REVENUE 160,500,00 4,51835 155,981. 65 291. 518.00 291. 618.00 TOTAL REVENUE 3,522,637.00 2,560,33087 962,306,]3 5,041.177,60 2,902,961.01 2.138,216.59 *******EXPENDITURES******* PUBLIC SAfETY: POLICE 133,559.00 104.00780 29,551. 20 161. 4B7 ,38 87,850,86 73. 636 . 52 TRAFFIC SIGNALS & STREET LTG 217,596.00 59.143,97 158,452,03 143,451. 04 65.842 .48 77,608.56 DISASTFR PREPAREDNESS 8,179.22 2.175,00 6,004,22 FIRE SERVICES 287,626.00 28.391. 24 259,234,76 211,138,48 27.068.67 184,069.81 ACTIVITY TorAL 638,781. 00 191.543,01 447,237,99 524,256.12 182.937.01 341. 319,11 TRANSPORT A T ION : STREET MAINTENANCE 301.750.00 78.61599 223,134,01 216,334,44 74,104.48 141,629.96 STREET SWEEPING ACTIVITY TOTAL 301.750.00 78.61599 223,134,01 216,334.44 74.704.48 141,629.96 HEALTH & WELFARE: WASTE MANAGEMENT 1.402,134.00 22.62450 1.379,509,50 1.248,019,76 18,716.57 1.229,303.19 SOCIAL SERVICES 44,927.00 20.819,30 24,107,10 44,935.00 21. 626.55 23,308,45 HOUSING PROGRAMS ACTIVITY TOTAL 1.447,061.00 43.443 80 1.403,617 ,20 1.292,954.76 40,343.12 1.252,611.64 COMMUNITY DEVELOPMENT; ENGINEERING 6,000.00 2.490,50 3,509,50 6,000.00 6,000,00 ACTIVITY TOTAL 6,000,00 2.490 50 3,509.50 6,000,00 6,000,00 CAPITAL IMPROVEMENT PROJECTS; GfNfRAI_ CIP PROJECTS 100,000,00 100,000.00 COMMUNITY PROJECTS 44,928.00 44,928,00 63,670.75 63,670,75 PARKS 321.717,00 128,500,00 193,217.00 27,928.00 6,000,00 21. 928,00 STREET CONSTRUCTION/IMPROVEMENT 729,071. 00 72,900.46 656,170,54 2,293.708,38 1.545,00717 748.701.21 ACTIVITY TOTAL 1,095,716.00 201.400 46 894,315,54 2,485,307.13 1. 551. 00717 934,299,96 TOT A L EXPENDITURES 3,489,308.00 517,493,76 2,971,814,24 4,524,852.45 1. 854,991.78 2,669,860,67 EXCESS REVENUE (EXPENDITURES) 33,329.00 2,042,837,11 (2,009,508.11) 516,325.15 1.047,969,23 (531.644,08) TRANSfER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 21.885,10 21.885.10 REVENUES OVER (UNDER) EXPENDITURES 33,329,00 2,042,837,11 (2,009,50811) 494,440,05 1.047,969,23 (553,529.18) Cf~'¡* THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 01/31/2005 S P E C I A LAS S E SSM E N T FUN 0 S CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS 639.589.00 438,340.98 201. 248,02 593,202,41 297,924.67 295,277.74 USES/MONEY & PROP-INTEREST 12.909.00 3.767.17 9.141.83 4,093.98 2,558.64 1.535.34 OTHER SOURCES OF REVENUE 5,000,00 5.000.00 144.29 144.29 TOTAL REVENUE 657.498.00 442,108.15 215.389,85 597,440.68 300,627.60 296.813.08 *******EXPENDITURES******* PU8LIC SAFETY; TRAFFIC SIGNALS & STREET LIG 306.088.00 105,445.93 200.642,07 217.534.35 73,75972 143.774.63 ACTIVITY TOTAL 306.088.00 105.445,93 200.642.07 217.534.35 73.759 72 143.774,63 TRANSPORTATION PUBLI C WORKS 1.436.00 959.99 476.01 1.352.46 774 82 577 .64 STREET TREE MAINTENANCE 27,099.00 5.226,41 21,872.59 26.752.22 2,166.81 24.585.41 STREET LANDSCAPE MAINTENANCE 344,474.00 148.817.58 195,656,42 296.360.83 121.280.99 175.079.84 ACTI V ITY TOTAL 373.009.00 155.003,98 218.005,02 324.465.51 124.222.62 200,242B9 COMMUNITY DEVELOPMENT ENGINEERING 12.750. DO 6,669.94 6,OBO,06 15,007.20 8.105.50 6,901.70 ACTIVITY TOTAL 12.750, DO 6.669,94 6.080.06 15,00720 8.105,50 6,901.70 CAP ITAL IMPROVEMENT PROJECTS, COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT 53,98226 53,982,26 ACTIVITY TOTAL 53,982.26 53,982.26 TOT A L EXPENDITURES 691. 847 . 00 267.119.85 424.727,15 610,989.32 206,087.84 404,901. 48 EXCESS REVENUE (EXPENDITURES) (34.349.00) 174. 988,30 (209,337,30) (1J,548 64) 94,539,76 008,088,40) REVENUES OVER (UNDER) EXPENDITURES (34.349.00) 174.988.30 (209,337,30) (13,548.64) 94,539.76 008.088.40) IOor~'f THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 01/31/2005 CAP I TAL IMP R 0 V E MEN T FUN D 5 CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 810.154.00 18.631.900.00 19.442,054,00 382,033.41 9,972,193.69 10,354,22710 428,120,59 8.659,706.31 9.087,826.90 330,842.99 13.455,275.26 13.786,118,25 234,346.93 96,496,06 13.455,275,26 13.551.771. 32 234,346,93 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 55,300,00 50400 54,796.00 92,493,49 11,848,44 80.645.05 ACTI V ITY TOTAL 55,300.00 504.00 54.796,00 92.493.49 11 ,848.44 80,645,05 PUBLI C SAf [TY : TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 809,412.00 103,625.90 705,786.10 2,252,493.88 396 ,342,71 1.856.151.17 CULTURE & LEISURE SERVICES: RECREATION AOMINISTRATION ACTIVITY TOTAL COMMUNITY OEVELOPMENT PLANNING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 5.000.00 143,614.57 (138,614.57) 1.007,728,90 1.361. 812.68 (354.083.78) COMMUNITY IMPROVEMENTS 36,771. 00 36,771,00 PARKS 13,756.957,00 300,068.29 13,456,888,71 3,543,155.47 2,506,400,23 1.036.755,24 STREET CONSTRUCTION/IMPROVEMENT 19,299.474,00 1.190,476.90 18,108,997.10 5,377,070,50 2,120,794,18 3,256.276.32 ACTIVITY TOTAL. 33,098.202.00 1,634,159.76 31.464,042,24 9,927,954.87 5,989,007,09 3,938.947.78 TOT A L EXPENDITURES 33,962.914.00 1.738,289.66 32,224.624,34 12,272.942,24 6,397,198.24 5,875.744.00 EXCESS REVENUE (EXPENDITURES) (14.520.860,00) 8,615,937.44 (23,136,797.44) 1.513,176.01 (6,162,851.31) 7,676.027,32 TRANSFER IN FROM OTHER FUNOS TRANSFERS OUT TO OTHER FUNOS REVENUES OVER (UNOER) EXPENOITURES(14.520.860,OO) 8.615,937.44 (23,136.797.44) 1.513,176,01 (6,162,851.31) 7,676,027.32 1I'1:l '"\: THE CITY OF DUBLIN STArEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 01/31/2005 T R U S T / AGE N C Y FUN 0 CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 116.965.04 (1]6,965.04) 233.713 . 12 116.856,56 116,856.56 USES/MONEY & PROP-INTEREST 386,19 (386,19) 1.467 95 915.07 552,88 TOTAL REVENUE 117 . 351. 23 (117,351.23) 235.181. 07 117 .771. 63 117 ,409.44 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES; NON-DEPARTMENTAL 228,196.00 179.622,43 48,573.57 230,99350 174.133.25 56.860,25 ACTIVITY TOTAL 228,196.00 179.622.43 48,573. 57 230.993.50 174.133.25 56,860,25 PUBL! C SAFETY; TRANSPORTATION: HEALTH & WELFARE; CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT; CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES 228,196.00 179.622,43 4B, 573. 57 230.99350 174.133,25 56.860.25 EXCE5S REVENUE (EXPENDITURES) 1228,19600) (62.271.20) 065,924,80) 4.187.57 (56.361.62) 60.549.19 REVENUES OVER (UNDER) EXPENDITURES (228,196.00) (62.271.20) 065,924.80) 4.187.57 (56.361.62) 60,549.19 THE CITY OF DU8LIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 01/31/2005 1~2.t INTERNAL S E R V ICE FUN 0 S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR U,D, VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 226,186,00 79,081,16 147,104.84 72,481. 36 48,228,05 24,253.31 CHARGES FOR SERVICES 1.733,474.00 992,342.02 741.131. 98 1.690,762.96 961.724.04 729,038.92 OTHER SOURCES OF REVENUE 21.122,00 233,47 20,888,53 991.817.10 991. 817,10 TOTAL REVENUE 1. 980 .782 00 1. 071,656,65 909,125,35 2,755,061.42 1.009,952.09 1.745,109,33 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 2.329,74600 715,322,56 1.614,423,44 2,231.661.78 326,169.38 1,905,492.40 ACTIVITY TOTAL 2.329.746,00 715,322.56 1.614.423.44 2,231. 661. 78 326,169,38 1. 905 .492 .40 PU8LIC SAFETY; FIRE 66,010,00 66,010.00 57,068.73 57,068,73 ACTIVITY TOTAL 66,01000 66,010,00 57,068.73 57,068.73 TRANSPORT AT ION ; HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT; CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 2,395,75600 715,322 56 1. 680,433,44 2,288,730.51 326,169.38 1. 962. 561.13 EXCESS REVENUE (EXPENDITURES) (414,974,00) 356,334,09 (771.308.09) 466,330.91 683,782,7] (217.451.80) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUN~S REVENUES OVER (UNDER) EXPENDITURES (414,974,00) 356,334,09 (771,308.09) 466,330,91 683,782,71 (217.451.80) ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ·····***EXPENDITURES****··· GENERAL GOVERNMENT ACTIVITIES; NON-DEPARTMENTAL FINANCE ACT! V ITY TOTAL PUBLIC SAFETY; HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES CURRENT BUDGET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 01/31/2005 E N T E R P R I S E FUN 0 CURRENT ACTUAL VARIANCE J?~J.q.. PR lOR FISCAL YEAR PRIOR Y,T,O, VARIANCE 20,00 2000 20.00 20,00 2000 20,00 (20,00) (20,00) (20,00) (20,00) (20.00) 20,00 I Ltot'1.+ CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF FEBRUARY 2005 Prepared by The Finance Department March 3, 2005 1511'-1- CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 28Feb2D05 GENERAL SPECIAL SPECIAL CAPITAL TRU5T/ TOT A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM DNLY--- FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR ASSETS CASH (53,654,245) 5,123,059 547,342 38,158.438 85.163 (9,740,243) (20,381. 485) CASli WITH FISCAL AGENT 172.779 172,779 172,779 AMOUNT HELD IN ESCROW INVESTMENTS AT COST 105,748,685 105,748,685 93,105,254 RECEIVABLES: TAXES ACCOUNTS 23,148 52,884 76,031 176,761 INTEREST 200,330 ASSESSMENTS DUE FROM OTHERS 1. 989,267 1. 989,267 308,720 INVENTORY AT COST PREPAID ITEMS 10,924 10,924 8,3S2 FIXED ASSETS 4,SOO,OOO 4.500,000 AMOUNf TO 8E PROVIDEO 1. 334,500 1.334,500 1. 447,500 TOTAL ASSETS 54,117,77B 5,175,943 547,342 42,658.438 1. 592,441 104.091.943 75,038,211 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (1.1B3,l17) (1.183,117) (956,395) DEPOSITS FOR AB1600 FEES (166,259 ) (221.695) (387,954) (2,513,912) DEPOSITS OTHERS (2,579,95B) (2,579,958) (1,415,078) PAYABLES, ACCOUNTS (217,014) (17 .476) (163,441 ) (397,931) (1,220,743) INTEREST PAYROLL (541. 925) (541.925) (481.549) DUE TO OTHERS (lll,561) (160.054 ) (1.829,213) (2,100.828) (336.673) DEFERRED REVENUE (127,768) (127,768) (127.768) DEBT INSTRUMENTS PAYABLE (1.452,000) (1.452.000) (1,565,000) TOTAL LIABILITIES (4,927,602) (177 .530) (2.214,348) (1.452,000) (8,771.481) (8,617,118) FUND BALANCES (49,190,176) (4,99B.413) (547,342) (40,444,090) (140,441 ) (95,320,462) (66,421.093) TOTAL FUND E (49,190,176) (4,998.413) (547,342) (40,444,090) (140,441 ) (95,320,462) (66,421.093) TOTAL LIABILITIES/EOUITY (54,117,778) (5,115,943) (547,342) (42,658,438) (1,592,441)(104,091,943) (15,038,211) IlÞ~ ~t C!TV OF DUBLI N BALANCE SHEET FOR THE PERIOD ENDING 28Feb2005 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOTALS SERVICE FUND GROUP OF TERM DEBT ...MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 8,395,870 8,395,870 7,816,155 CASH W ITII FISCAL AGE NT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES, TAXES ACCOUNTS INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 46,511,915 39,208,244 85,720,159 66.732,089 AMOUNT TO BE PROVIDED 66.753,945 66,753,945 68,683,627 TOTAL ASSETS 54.907,785 39,208,244 66.753,945 160,869,974 143.231,871 LIABILITIES/FUND EOUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAY ABLES; ACCOUNTS INTEREST PAYROLL DUl TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE TOTAL LIA81LlfIES FUND BALANCES (54,907,785) TOTAL FUND E (54,907,785) (J7,215) (66.753,945) (66,753.945) (66,753,945) (68,683,627) (66,753,945) (68,700,842) (94,116,029) (74.531,030) (94,116,029) (74,531,030) (39,208,244) (39,208,244) TOTAL LIABILITIES/EQUITY (54,907,785) (39,208,244) (66,753,945) (160,869,974)(143,231,B71) THE CITY OF DUBLIN STATEMENT SHOWING Il~ ¡'Ÿ- REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 02/2B/2005 G ENE R A L REVENUE FUN 0 CURRENT CURRENT PR lOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y,T,D. VARIANCE *******REVENUES******* PROPERTY TAXES 13.661,980.00 7.515.739.07 6.146,240.93 11,316,703,32 5,942,512.05 5,374.191.27 SALES TAX 13.613.216.00 B.495,434.B4 5.117,7B1.16 13,940.263,36 8.421. 07315 5,519,190.21 REAL PROPERTY TRANSFER TAX 520,000.00 430,142,83 89,857,17 571. 360.79 2B9,105 02 282.255.77 HOTEL TRANSIENT OCCUPANCY TAX 610,000,00 371.936,15 238,063.85 664,308.51 360,324.68 303.983,83 FRANCHISE TAXES 1.536,000.00 622,047.92 913,952.08 I. 505,434 , 53 585,72972 919.704.81 LICENSES & PERMITS 2.723,912,00 2.B18,958,92 (95,046,92) 3,090,992.17 2.23B,01756 852,974,61 FINES & FORFEITURES 112,900,00 88.204.29 24,695.71 117 ,369.48 63,646.24 53.723,24 USE/MONEY & PROP-INTEREST I. 369,725.00 593,369.13 776,355.87 492,971. 23 340,39962 152.571.61 USE/MONEY & PROP-RENTALS 168,365.00 62,202,68 106,162,32 130,741.40 BI. 487 97 49,253.43 INTERGOVERNMENTAL 449,100,00 362,638.37 86.461. 63 1.82B, 992.93 8B5,452.69 943.540,24 CHARGES FOR SERVICES 5.177,916.00 3,173,720.65 2.004,195,35 4,801.136,74 2.554,57442 2,246,562.32 OTHER SOURCES OF REVENUE 952,837,00 541. 366.82 411.470,18 860,434.13 126,28360 734,150,53 TOTAL REVENUE 40,895,951. 00 26,075,761,67 15.820,IB9.33 39,320,708,59 21. 888,606.72 17.432.101. 87 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVlllES CITY COUNCI L 262,910,00 130,872 .72 132,037,28 209,858.23 124,066.09 85.792.14 CITY MANAGER 928,273,00 581. 077 , 91 347,195.09 817,034,42 514,588.94 302.445.48 CENTRAL SERVICES 350,911.00 228,224.B3 122,6B6,17 341.914.49 221.843.17 120,071.32 CITY ATTORNEY 689,493,00 363,240.31 326,252.69 700,797.95 396,157.70 304,640,25 AOMIN SERVICES 1.557,095.00 868,905.67 688,1B9,33 1.244,537,07 795.698.B7 448,838.20 BUILDING MANAGEMENT 641.134.00 359,595.98 281. 538,02 757,522.96 406.100,34 351. 422,62 INSURANCE COST CENTER 358,986,00 205,547.98 153,438.02 420,061. 97 280,992.65 139,069.32 ELECTIONS COST CENTER 15,670.00 11,265.41 4,404,59 3,048,13 2.895.03 153.10 NON-DEPARTMENTAL 160,500,00 160.500.00 125,656.16 125,656,16 ACTIVITY TOTAL 4.964,972.00 2,748,730.Bl 2.216,241.19 4,620,431.38 2,742.342.79 1.87B.088.59 PUßLI C SAFETY POll CE 9,883,259,00 4,407.282.01 5.475.976.99 8,570,937,09 4,323.619,52 4.247.317.57 CROSSING GUARDS 72,2B3.00 33,157.18 39,125.82 65,794.14 27.037.75 3B.75639 AN I MAL CONTROL 266,362,00 19,242.00 247.120.00 19B,953.52 57,513,37 141. 440.15 TRAFFIC SIGNALS & STREET LIGHTIN 17,240.00 4,130.29 13,109.71 6,543,33 2.130.33 4,41300 DISASTER PREPARlDNESS 65,413.00 33,630.01 31.782,99 70,993,74 34, B61. 54 36.132 20 FIRE SERVICES 8,156,645.00 2,314,681.49 5,841.963,51 7.440,483.12 2.208,367,48 5,232,115.64 ACTIVITY TOTAL 18,461. 202 . 00 6,812,122.98 11,649.079.02 16,353.704,94 6.653.529,99 9,/00,17495 TRANSPORTATION PUBLI C WORKS 738,575.00 440,159.75 298.415,25 6B6, 881. 45 438,923,18 247,958.27 STREET MAINTENANCE 14,802.00 24,867.89 00.065.89) 3,703.99 3.703.99 STREET SWEEPING 149,207.00 58,72313 90,4B3.87 130,351.29 67.452.09 62,89920 STREET TREE MAINTENANCE 97.352.00 18,588.63 78.763,37 I17 ,583.47 50,510.05 67,07342 STREET LANDSCAPING MAINTENAN 690.715.00 362,62974 328,085,26 593,488.01 297,021.17 296,466.84 ACT! V ITY TOTAL 1.690.651.00 904,96914 785,681. 86 1.532,008.21 857,610.48 674,397.73 HEALTH & WELFARE WASTE MANAGEMENT 63.125.00 63,499.22 (374.22) 46,419.04 46,419,04 CHILD CARE 15.000,00 15,000.00 18,500,00 18,500.00 SOCIAL SERVICES 1. 000.00 1. 000.00 HOUSING PROGRAMS 176.89 076.89) 16.893,18 16,893,18 THE CITY OF DUBLIN STATEMENT SHOWING 1Uè?"" REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 02/28/2005 G ENE R A L REV E N U E FUN 0 CURRENT CURRENT PRIOR PRIOR 8UDGET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE ACTIVITY TOTAL /8,12500 78,676.11 (551.11) 82,812.22 36,393.18 46,419,04 CULTURE & LEISURE SERVICES LIBRARY SERVICES 582.730,00 285,321.61 297,408.39 522.604,10 252,555.70 270,048.40 CULTURAL ACTIVITIES 163,918.00 68,409.96 95,508,04 110,249.30 88,644,07 21. 605,23 HERITAGE CENTER 141. 775,00 76,174,66 65,600.34 99.628,11 65,648.83 33,979.28 DUBL! N CEMETERY 53,602,00 19,878,52 33,723.48 53.533,84 29,915.18 23,618.66 PARK MAINTENANCE 1.532.409,00 774,011.34 758,397.66 1.403.774,51 700,175.88 703,598,63 COMMUN ITY TV 62,999.00 57,349.00 5,650,00 62,020.72 58,246,22 3,774,50 RECREATION ADMIN 638.564,00 372,949,70 265,614.30 518,312.54 333,523,22 184,789.32 PLAYGROUNDS 277 .082,00 160,327.55 116,754.45 237,599,33 146,222.17 91. 377 ,16 SHANNON CENTER 389.176.00 220,410,76 168,765,24 294,742.36 178,195,08 116,547.28 PRESCHOOl. 90,699,00 52,573.42 38,125.58 77,388,27 48,218.07 29,170.20 TEENS PROGRAM 118,941.00 52.799.33 66,141. 67 86,212.99 50,123.73 36,089.26 ADUI.T SPORTS 110,559,00 57,069,11 53,489.89 101.640,17 60,783.55 40,856.62 YOUTH SPORTS 138,824.00 69,959.28 68,864,72 122,764.81 66,955,91 55,808.90 COMMUN ITY GYM 46,504.00 24,522,92 21.981. 08 37,309.40 21.610,60 15,698.80 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 339,22D,OO 186,957.82 152,262,18 348,052.22 194,185.86 153,866,36 SEN10R CENTER 297,455.00 152.070,08 145,384.92 223,784.61 135,648,01 88,136.60 RECREATION INSTRUCTION 195,220,00 116,119,99 79,100.01 185,369,65 118,134.37 67,235.28 AQUATICS 407,136.00 217.13619 189,999,81 366,568.40 193,556,28 173,012,12 PARKS/FACILITIES MANAGEMENT 284,993,00 165,835,94 119,157.06 246,546,42 155,221. 05 91. 325.37 ACTIVITY TOTAL 5,871,806.00 3,129.87718 2.741.928,82 5,098,101.75 2,897,563,78 2,200,537.97 COMMUNITY DEVELOPMENT PLANNING 2,731. 301. 00 1,539,56361 1.191.737,39 2,271.403.13 1.320,035,52 951.367,61 SUI LOI NG SAFETY 2,580,214.00 1. 312.754 40 1.267,459,60 1.907,211.35 1.043,324,07 863,887.28 ENGINEERING 2,209,633.00 1.361.846,17 847,786.83 1.861. 971.85 1.107,105.26 754,866.59 ECONOMIC DEVELOPMENT 286,226,00 214,93256 71. 293,44 302,134.33 247,566,42 54,567,91 ACTI V!TV TOTAL 7,807,374.00 4,429,096,74 3,378,277,26 6,342,720.66 3,718,031.2/ 2,624,689.39 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1. 079,341. 00 336,46049 742,880,51 1.163,181. 54 158,928,49 1.004,253.05 COMMUNITY IMPROVEMENTS 877,070,00 23,987,69 853,082.31 718,087,36 583,454.78 134,63258 PARKS 3,333,2V.00 1.741.157.29 1.592,074.71 1. 831.348.20 467,038,75 1.364,309.45 STREET CONSTRC/1MPROVEMENTS 1.419,39300 278,165,29 1.141.227.71 938,789,96 180.74241 758,047.55 ACTIVITY TOTAL 6,709,036,00 2,379,770,76 4,329,265.24 4.651.407,06 1.390,16443 3,261.242,63 TOTAL EXPENDITURES 45,583,166,00 20,483,243,72 25,099,922.28 38.681.186,22 18,295,63592 20,385,550,30 EXCESS REVENUE (EXPENDITURES) (4,687,215,00) 4,592,517.95 (9,279.732,95) 639,522.37 3,592,970,80 (2,953,448,43) TRANSFERS IN FROM OTHER FUNDS 21,885.10 6,600,00 15,285.10 TRANSFERS OUT FROM OTHER FUNOS (20,00) (20.00) REVENUES OVER(UNDER) EXPENDITURES (4,687,215,00) 4,592,517.95 (9,279.73295) 661. 3B7 .47 3,599,57080 (2,938,183,33) THE CITY Of DUBLIN STATEMENT SHOWING IqOO¡'~ REVENUES VERSUS EXPENDITURES FOR THE PERIOO 07/01/2004 THROUGII 02/28/2005 S P E C I A L REV E N U E FUN D S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR n.D. VARIANCE ********RFVENUES******** PROPERTY TAXES III ,049.00 56,837.59 54,211 .41 105,605,41 53,194,09 52,411.32 SAllS lAX/OTHER TAXES 336,500.00 148,194,67 188,305,33 357,441.52 183,635.36 173,806,16 FINES & FORFEITURES 164,000.00 52,016.18 111,983.82 154.784,03 75,954,31 /8,829.66 USES/MONEY & PROPERTY 89,248.00 30,778.45 58 .469 , 55 29,822,10 20,355.06 9,467.04 INTERGOVERNMENTAL EROM STATE 1.188,010,00 1.737,230,52 (549,2205?J 2,590,885.16 2,025,046,54 565,838,62 INTERGOVERNMENTAL FROM COUNTY 306,890,00 72,652.00 234,23800 269,149,00 52,093.00 217,056.00 INTERGOVERNMENTAL EROM fEDERAl 109,717.00 20,56080 89,156,20 253,139.22 44,490.17 208,649,05 CHARGFS FOR SERVICES 1,056,723,00 543,712,28 513,010,72 988,833.16 497,885,40 490,947.76 OTHER SOURCES OF REVENUE 160,500,00 5,347.65 155,152 35 291. 518.00 291.518.00 TOTAL REVENUE 3.522,637.00 2,667,330.14 855,306,86 5,041.177,60 2,952,653.99 2,088,523.61 ******xEXPENDITURlS******* PU8L1 C SAFETY: POLICE 133,559.00 104,007.80 29,551. 20 161. 487 ,38 146,389.60 15,097.78 IRNflC SIGNALS & STREET l.TG 217,59600 84,388.82 133,207,18 143,451.04 75,060.46 68,390,58 DISASTER PREPAREDNESS 8,179.22 6,409,97 1.769,25 FIRE SERVICES 287,62600 28,391.24 259,23476 211,138,48 27,318,67 183,819.81 ACTIVITY TOTAL 638,78100 216.787.86 421. 99314 524,256,12 255,178.70 269,077.42 TRANSPORTATION; STRE[I MAINTENANCE 301. 750 00 98,917.14 202,832,86 216,334.44 105,440.18 110,894,26 STREET SWEEPING ACTIVITY TOTAL 301.750 00 98,917,14 202,832,86 216,334.44 105,440.18 110,894,26 HEALTH & WELFARE: WASTE MANAGEMENT 1,402,134.00 25,484.44 1.376,649,56 1.248,019,76 514,631. 67 733,388.09 SOCIAL SERVICES 44,927,00 30,681. 97 14,24503 44,935.00 29,373,14 15,561. 86 HOUSI NG PROGRAMS ACTI V ITY TOTAL 1.447,06100 56,166,41 1.390,894,59 1.292,954.76 544,004.81 748,949,95 COMMUNITY DEVELOPMENT: ENGINEERING 6,000,00 6,000.00 6,000,00 6,000,00 ACTIVITY TOTAL 6,00000 6,000,00 6,000.00 6,000.00 CAPITAL IMPROVEMENT PROJECTS; Gf.NtRAL CIP PROJECTS 100,000.00 100,000,00 COMMUNITY PROJECTS 44,928,00 44,92800 63,670,75 63,670.75 PARKS 321. 717 00 174.760.00 146,957,00 27,928.00 6,000.00 21. 928,00 STRFFT CONSTRUCTION/IMPROVEMENT 729,071,00 73,059,04 606,011,96 2,293,708.38 1.651,065,99 642,642,39 ACTIVITY TOTAL 1,095,716,00 247,819.04 847,89696 2,485,307,13 1.657,065.99 828,241.14 TOT A L EXPENDITURES 3,489,30800 625,690.45 2,863,617,55 4,524,852,45 2,567,689.68 1.957,162,77 EXCESS RlVENUE (EXPENDITURES) 33,32900 2,041.639,69 (2,008,310,69) 516,325.15 384,964,31 131.360,84 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTIIËR FUNDS 21. 885 .10 6,600.00 15,285,10 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 02/28/2005 ;?'OŒb~+ S P E C I A L ASS E SSM E N T FUN 0 S CURRENT CURRENT PR lOR PRIOR 8UDGET ACTUAL VARIANCE FISCAL YEAR Y,T,D VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS 639,S89.DD 438,340.98 201. 248.02 593.202,41 297.924,67 295,27174 USES/MONEY & PROp· INTEREST 12.909.00 3,767.17 9,141.83 4.093.98 2,558.64 1. 535 . 34 OTHER SOURCES OF REVENUE 5,000.00 5,000.00 144.29 144.29 TOTAL REVENUE 657.498.00 442,108.15 215,389.85 597,440.68 300.627,60 296,813.08 *******EXPENDITURES******* PUBLIC SAFETY; TRAFFIC SIGNALS & STREET LIG 306.088.00 120,357,08 185,730.92 217,534.35 122,926.88 94,607,47 ACTI V ITY TOTAL 306,088.00 120,357.08 185.730.92 217,534.35 122.926.88 94.607.47 TRANSPORT ATI ON PUBLI C WORKS 1. 436 . 00 977.81 458,19 1.352 .46 1.066,88 285.58 STREET TREE MAINTENANCE 27,099.00 7,11915 19,979,85 26.752,22 6.123.50 20,628.72 STREET LANDSCAPE MAINTENANCE 344,474.00 165.381. 45 179.092,55 296,360,83 131.346.10 165,014,73 ACTIVITY TOTAL 373,009.00 173.478.41 199.530.59 324,465.51 138,536.48 185,929.03 COMMUNITY DEVELOPMENT ENGINEERING 12,750.00 6,669.94 6,080.06 15,007,20 9,255.50 5.761.70 ACTI V ITY TOTAL 12,750,00 6,669.94 6,080,06 15,007.20 9,255.50 5.751. 70 CAPITAL IMPROVEMENT PROJECTS, COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT 53,982.26 50.688.68 3.293.58 ACTIVITY TOTAL 53.982.26 50,688,68 3,29358 TOT A L EXPENDITURES 691.847,00 300.505.43 391.341. 57 610,989,32 321.407.54 289,581. 78 EXCESS REVENUE (EXPENDITURES) (34.349.00) 141.602,72 m5, 951. 72) (13,548.64) (20.779,94) 7,231.30 REVENUES OVER (UNDER) EXPENDITURES (34,34900) 141. 602,72 m5, 951. 72) (13,548,64) (20,779,94) 7,23130 G2. \'1> 2.t1 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 02/2B/2005 CAP I TAL IMP R 0 V E MEN T FUN 0 S CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUE******** USES/MONEY & PROP· INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 810,154.00 18.631. 900,00 19,442,054.00 382,033,41 10,787,236,24 11,169,269.65 428,120 59 7,844.66376 8.272.784,35 330,84299 13,455,275,26 13.786,118,25 234,346,93 1. 000.00 235,346.93 96,496.06 13,454.275.26 13,550,771.32 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIV1TIES: CITY ATTORNEY 55,300,00 2,16400 53,136.00 92.493,49 11,848.44 80,645.05 ACTI V!TY TOTAL 55,30000 2,16400 53,136,00 92.493.49 1l,848,44 80,645,05 PUBU C SAFETY: TRANSPORTATION; HEALTH & WELFARE: HOUS I NG PROGRAMS 819,412,00 115,217,11 704,194.89 2,252.493,88 1.812,423.98 440,069.90 CULTURE & LEISURE SERVICES; RECREATION AOMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 5,000,00 143,982.52 (138,982,52) 1. 007 .728,90 1.362,122.62 C354,393,72) COMMUNITY IMPROVEMENTS 36,771. 00 36,771. 00 PARKS 13,756,957,00 307,623,51 13,449,333.49 3,543,155,47 2.719,189,13 823,966.34 STREET CONSTRUCTION/1M PROVE ME NT 19,299,474,00 2,377,802.97 16,921. 671. 03 5,377,070,50 2,269,490.30 3,107,580,20 ACTIVITY TOTAL 33,098,202.00 2,829,409,00 30,268,793.00 9,927,954.87 6,350,802,05 3,577,152.82 TOT A L EXPENDITURES 33,972,914.00 2,946,790.11 31. 026,123,89 12,272,942.24 8,175 ,074,47 4,097,867,77 EXCESS REVENUE (EXPENDITURES) (14,530,860,00 ) 8,222,479,54 (22,753,339.54) 1.513,176,01 (7,939.727.54) 9,452,903.55 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUFS OVER (UNOER) EXPENOITURESCI4,530,860,00) 8,222,479.54 C22,753,339.54) 1.513,176,01 (7,939.727.54) 9,452,903,55 THE CITY OF DUBLIN STATEMENT SHOWING ~?~ ~+ REV,:NUES VERSUS EXPENDITURES FOR THE PERIOO 07/01/2004 THROUGH 02/2B/2005 T R U S T / AGE N C Y FUN 0 CURRENT CURRENT PR lOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y,T,O, VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 116,965.04 (!l6,965.04) 233,713,12 ]]6,856,56 116,856 56 USES/MONEY & PROP· INTEREST 386,19 (386,19) 1.467.95 915.07 552,88 TOTAL REVENUE II7 ,351. 23 (]]7 ,351. 23) 235,181. 07 ]]7.771.63 ]]7,40944 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 228,196.00 230,79618 (2,600.1B) 230,993,50 229.893.50 1.100 00 ACT! V!TV TOTAL 228,196,00 230,796,18 (2,500,18) 230,993.50 229.B93,50 1.100,00 PUBLIC SAFETY; TRANSPORT AT ION; HEALTH & WELFARE: CULTURE & LEISURE SERVICES, COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES 228,196,00 230.796,18 (2,600.18) 230,993.50 229.893,50 1.l00,OO EXCESS REVENUE (EXPENDITURES) (228,196,00) 1113,44495) (1l4,751.05) 4,187,57 (ll2,121.87) 116,309.44 REVENUES OVER (UNDER) EXPENDITURES (228,196,00) 1]]3,44495) (!l4,751.05) 4,187,57 (!l2 .121. 87) 116,309.44 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 02/28/2005 ~=3co2-+ I N T ERN A L S E R V ICE FUN 0 S CURRE NT CURRENT PRIOR PRIOR BUCI3ET ACTUAL VARIANCE FISCAL YEAR V.T.O, VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 226,186.00 79,08U6 147,104,84 72,481.36 48,228.05 24,253,31 OIARGES fOR SERVICES 1.733,474,00 992,342,02 741.131. 98 1. 690.762,96 U06,851.38 583,911.58 OTHER SOURCES OF REVENUE 21.122.00 5,862.19 15,259,81 991.817.10 991. 817 , 10 TOTAL REVENUE 1,980,782,00 1.077 ,285,37 903,496 63 2.755,061. 42 U55, 079.43 1. 599,981.99 *******EXPENOITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 2,329.746.00 89B,537,43 1. 431. 208,57 2,231. 661. 78 353,192,30 1.878,469.48 ACTIVITY TOTAL 2,329,746.00 898,537.43 1. 431. 208,57 2,231.661.78 353,192.30 1.878.469,48 PUBLIC SAFETYo FIRE 66,010,00 66.010,00 57,068,73 57.068,73 ACTI V JTY TOTAL 66, OlD. 00 66,010,00 57,068.73 57,068.73 TRANSPORT A TJ ON : HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDiTURES 2,395,75600 898,537,43 1.497,218.57 2,288.730.51 353,192,30 1.935,538.21 EXCESS REVENUE (EXPENDITURES) (414,974,00) 178.747.94 (593,721.94) 466,330,91 801,887.13 (335.556.22) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDl1'URES (414,97400) 178.747.94 (593.721.94) 466,330.91 801. B87 ,13 (335,556,22) ********REVENUES******** USES/MONEY & PROP· INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON· DEPARTMENTAL FINANCE ACTIVITY TOTAL PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY OEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OllT TO OTHER FUNDS REVENUES OVER (UNOER) EXPENOITURES CURRENT BU¡X;ET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOO 07/01/2004 THROUGH 02/2B/2005 E N T E R P R I S E FUN 0 CURRENT ACTUAL VARIANCE -;?~ -z,L.\' PRIOR FISCAL YEAR PRIOR Y.T.D VARIANCE 20.00 20,00 20,00 20.00 20,00 20.00 (20.00) (20,00) (20,00) (20.00) (20.00) 20.00