Loading...
HomeMy WebLinkAboutItem 4.06 Financial Reports May 2009CITY CLERK ~~~ U~~ry File # ^~~®-0® ~~1 ~~~ $'~ AGENDA STATEMENT C~ l~ CITY COUNCIL MEETING DATE: July 21, 2009 ~LIFOR~~ SUBJECT: Preliminary Financial Reports for the Month of May 2009 Report Prepared by: Paul S. Rankin, Administrative Services Director and Vivian Gong, Finance Manager ATTACHMENTS: 1.YTD (Year-To-Date) Revenues and Budget Comparison 2.YTD (Year-To-Date) Expenditures and Budget Comparison 3. May 31, 2009 Financial Statements RECOMMENDATION: Receive the reports as authorized by Section 41004 of the California Government Code. ~, FINANCIAL STATEMENT: See reports for details of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary financial statements for the month of May 2009. The report includes a Balance Sheet format identifying summary information based on the "fund type". The reports also include Budget to Actual comparison for the following "fund types": General Revenue; Special Revenue; Special Assessment; Capital Improvement; Trust & Agency; and Internal Service Funds. Consistent with prior reports, the focus will be on the General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. The detailed amounts referenced are contained in Attachment 1 (Year to Date Revenues and Budget Comparison) and Attachment 2 (Year to Date Expenses and Budget Comparison). Analysis of May 2009 Revenue and Expenditure Reports The May report represents the reporting of revenues and expenditures for eleven months of Fiscal Year 2008/2009 (July 1, 2008 through May 31, 2009). This represents the completion of 92% of the Fiscal Year. It should be noted that there is not an even distribution of revenues and expenditures on a monthly basis. There is a lag with the reporting of some expenditures due to the significant amount of services provided to the City by outside independent contractors, including Police and Fire Services. These services are billed to the City on a quarterly basis and therefore, expenditures incurred during the first eleven months maybe incomplete until the billing is received and recorded. General Fund Revenues Total General Fund Revenues collected through May 2009 represented 92% of the budgeted amount. In the eleven months of the previous Fiscal Year the City collected 86% of its total General Fund revenue for the year. The revenue collected in July 2008 through May 2009 was approximately 6% or $820,427 more than the total collected in July 2007 through May 2008 (See Attachment 1). There were deviations in terms of dollars collected in several categories and the following Table summarizes some of the more significant deviations compared to the same reporting period in the prior year. COPIES TO: Page 1 of 4 ~• G:\Monthly Financials\FY 08-09\May 2009_Revise.doc ITEM NO. ~ ~' In order to place the year to date trends in context this Table also includes: the Current Year Budget, Prior Fiscal Year Total, and the Difference. This can be important given that in Fiscal Year 2008/09 not all revenue categories were expected to increase. Therefore a decrease in year to date collections may be consistent with the adopted Fiscal Year 2008/2009 Budget and Financial Plan, as well as the Mid-Year Budget adjustments approved by the City Council March 17, 2009. Summary of Significant General Fund Revenue Differences For Amounts Collected July -May 2009 vs. July -May 2008 REVENUE YTD YTD DIFFERENCE May May FY 08/09 More / EXPLANATION 2009 2008 (Less) FY 07/08 Property Tax $21,425,433 $20,250,217 $1,175,216 A majority of the increase was due to the annual increase in the assessed valuation of property on tax roll (52% of the increase or $619,000). The remainder of the increase is related to higher than usual payments of prior year taxes and late payment penalties. Collection from Supplemental Property Tax was $35,000 lower compared to the same period in the prior year and this revenue category was expected to be substantially less than the previous year. Revenues through May 2009 were tracking at 95% of ANNUAL ACTUAL the current budget. Alameda County BUDGET PRIOR YR DIFFERENCE adjustments are expected in the final $22,579,237 $22,098,429 $ 480,808 payments to reflect tax roll reductions and refunds. Sales Tax/In- $10,218,297 $11,553,484 ($1,335,187) As noted in the prior reports, Sales tax Lieu Sales continues to be on a declining trend. Tax Collection thru May 2009 decreased by $1,073,700 compared to prior year tax revenue. The remaining $261,411 decrease was due to a timing difference of the prior ANNUAL ACTUAL year Sales Tax In-lieu revenue. Revenue BUDGET PRIOR YR DIFFERENCE recorded accounted for 93% of the revised $11,008,800 $14,225,661 ($3,216,861) bud et. Real $233,264 $363,471 ($130,207) Decrease due to fewer real estate sale Property transactions occurring in the current fiscal Transfer Tax year. This trend was expected in the current ANNUAL ACTUAL budget. Revenue collected as of May 2009 BUDGET PRIOR YR DIFFERENCE represented 85 % of the current budget. $275,000 $493,175 $218,175 Transient $482,396 $670,675 ($188,278) The decrease was due to lower occupancy Occupancy rates. Collection through May 2009 was Taxes tracking at 82% of budget. ANNUAL ACTUAL BUDGET PRIOR YR DIFFERENCE $590,000 $789,397 ($199,397 Page 2 of 4 REVENUE YTD YTD DIFFERENCE May May FY 08/09 More / EXPLANATION 2009 2008 (Less) FY 07/08 License and $1,459,455 $1,559,911 ($100,456) A majority of the variance in this revenue Permits category was due to the decrease of Building permits revenue (-$107,000) and Encroachment/Transportation permits revenue (-$17,000) which were partially offset by the increase in Fire permits revenue ANNUAL ACTUAL (+$28,000). This revenue category was BUDGET PRIOR YR DIFFERENCE tracking at 77% of the current budget. $1,903,875 $1,784,644 $119,231 Interest and $2,163,115 $2,452,900 ($289,785) Interest income has decreased due to the Rentals declining investment yield rates (-$223,000). Other decrease has also occurred in property rental revenue (-$61,600) compared to the ANNUAL ACTUAL prior year as several tenants at the Dublin BUDGET PRIOR YR DIFFERENCE Square Property were relocated to $2,140,078 $2,955,280 $815,202 accommodate the Park Project. Inter- A major factor in the difference is due to governmental $254,064 $701,187 ($447,123) one-time grant funds such as the FY 2007- 2008 Workforce Housing grant ($409,600) received for the Shannon Community Center Reconstruction project. In the on-going revenues category, Vehicle License Fee revenue was $68,6001ess than the amount collected in the prior year. The current budget includes a potential grant for a storm ANNUAL ACTUAL water project ($605,700) which has been BUDGET PRIOR YR DIFFERENCE delayed. Therefore, this category is tracking $956,173 $1,079,088 $122,915 at 27% of the current bud et. The positive variance is primary associated Other $2,844,408 $675,229 $2,169,179 with two non-recurring events: a $1 million Revenue Community Benefit payment as provided for in the Wallis Ranch Development Agreement; and $1.5 million in ANNUAL ACTUAL reimbursements received in accordance with BUDGET PRIOR YR DIFFERENCE an agreement with the City of Pleasanton for $3,214,015 $866,992 $2,347,023 work related to the Fallon Interchange ro' ect. General Fund Expenditures Overall, through the month of May 2009, expenditures in the General Fund totaled approximately $39 million and represented approximately 62% of the total budgeted expenditures in the General Fund (Attachment 2). Of this amount, a total of $8,498,670 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. Page 3 of 4 An examination of only the General Fund Operating Expenditures (Attachment 2) indicates that through May 2009, expenditures totaled 65% of the Budgeted General Fund expenses. In the same period of the previous year the City expended 73% of the actual total General Fund Expenditures for the year. The total amount of General Fund Operating expenditures in the eleven months of Fiscal Year 2008-2009 were approximately $2,135,061 or 8% lower than the amounts expended for the same period in the prior Fiscal Year. This variance is primarily related to a timing difference of when contract services bills are received and processed. In the prior year, the third quarter payment to Alameda County for Fire Services was issued on May 20, 2008. In the current year, a payment of approximately $2,100,000 for third quarter services were not recorded until June 2009. 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. Page 4 of 4 __ City of Dublin 2008-2009 YTD Revenues and Budget Comparison For the Period Ending May 31, 2009 Total General Fund Revenues f 6%/O - - i Property Taxes 95% 92 /o -- _ - Sales Taxes I° 93% ^ FY 2008/09' I - ___ _ __ 81 /° ~ FY 2007/08 ; Transient Occupancy Taxes Franchise Taxes Licenses and Permits II Interest and Rentals ~~, Intergovernmental from State Real Property Transfer Tax 5% ,09 ~o 17% ~ 101% Charges for Services Fines and Forfeitures Other Revenues ~,~~~ ,_ ~~~ ___ _ ~ 65% ^ 98% 7% 195% 5% li 88% I ~ I -ivi p !~ '~ 0% 30% 60% 90% 120% 150% ', I 92% of Yea r Complete FY 2008/09 FY 2008/09 % of FY 2007/08 % of Total for Budget YTD Actual Budget YTD Actual FY 2007/08 Property Taxes 22,579,237 21,425,433 95% 20,250,217 92°/D Sales Taxes 11,008,800 10,218,297 93% 11,553,484 81 Real Property Transfer Tax 275,000 233,264 85% 363,471 74°/D Transient Occupancy Taxes 590,000 482,396 82% 670,675 85% Franchise Taxes 2,206,295 1,818,794 82% 1,847,654 83% Licenses and Permits 1,903,875 1,459,455 77% 1,559,911 87% Interest and Rentals 2,140,078 2,163,115 101% 2,452,900 83% Intergovernmental 956,173 254,064 27% 701,187 65% Charges for Services 5,751,709 5,623,257 98% 5,625,002 87% Fines and Forfeitures 138,900 132,301 95% 134,627 86% Other Revenues 3,224,015 2,844,408 88°/D 675,229 78°/D Total General Fund Revenues 50,774,082 46,654,783 92% 45,834,357 86% Dale Printed'. 8/i?J20097:01 PM ATTACHMENT 1 ~ o ~- 1. i~ ~, - - City of Dublin 2008-2009 YTD Expenses and Budget Comparison ~I For the Period Ending May 31, 2009 l ____ __ ~____ _. - - --- Total General Fund 62% I j Ex enses _ _ _ _ 7 % ~ '~ p i i I, General Government Police 52°/ 54 /o ~ I -- - Fire _ -- - --- -- -- - - ~ 49% ', -- __ I 71, I 0 Other Public Safety , 3 /0-- , e~oi I 82% ~ 86% Transportation 80% 8 /o Health and Welfare I 7U% 89% Culture & Community 78% Services 82% Community 82% Development 87% CapitalImprov. 55% Projects ' 88% 'I 0% 20% 40% 60% 80% 100% 92% of Year Complete ^ FY 2008/09 l ~ ®FY 2007/08 I 120% 2008/2009 .2008/2009 % of FY 2007/08 % of Total for Budget YTD Actual Budget YTD Actual FY 2007/08 General Government 6,132,761 5,042,015 82% 4,499,195 86% Police 13,476,020 6,945,663 52% 6,863,772 54% Fire 9,763,362 4,825,816 49% 7,059,372 75% Other Public Safety 652,838 236,432 36% 287,236 56% Transportation 2,304,606 1,847,403 80% 1,579,975 78% Health and Welfare 65,425 45,853 70% 45,800 89% Culture and Community Services 7,733,835 6,020,258 78% 5,879,817 82% Community Development 6,659,206 5,436,764 82% 6,320,099 87% Capital Improvement Projects 15,572,818 8,498,670 55% 4,509,561 88% Total General Fund Expenses 62,360,871 38,898,876 62% 37,044,828 75% General Fund Operating Expenses 46,788,053 30,400,206 65% 32,535,267 73% DMe Printed: Ni?/20091:03 PM ATTACHMENT 2 3 ~~ ~ CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF MAY 2009 Prepared by The Finance Department June 12, 2009 ATTACHMENT 3 r `~ a t" I? GENERAL SPECIAL SPECIAL REVENUE REVENUE ASSESSMENT FUNDS FUNDS FUNDS ASSETS CASH (43,427,330) 4,648.799 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST 110,441,858 RECEIVABLES: TAXES ACCOUNTS 141,747 191,054 INTEREST 619,653 ASSESSMENTS DUE FROM OTHERS 4.807,602 INVENTORY AT COST PREPAID ITEMS 5,229 FIXED ASSETS LOANS RECEIVABLE AMOUNT TO BE PROVIDED TOTAL ASSETS 72,588,759 4,839,852 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (692.928) DEPOSITS FOR AB1600 FEES (20.773) DEPOSITS OTHERS (710,999) PAYABLES: ACCOUNTS (436,823) (72.830) INTEREST PAYROLL (4,510) DUE TO OTHERS (30.226) DEFERRED REVENUE (138,385) DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (2,034,643) (72,830) FUND BALANCES (70.554.116) (4.767,022) TOTAL FUND E (70,554,116) (4,767.022) TOTAL LIABILITIES/EQUITY (72,588.759) (4,839.852) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31May2009 CAPITAL TRUST/ IMPROVEMENT AGENCY FUNDS FUND TOTALS ---MEMORANDUM ONLY--- CURRENT PRIOR 836,695 31,292,132 165,186 (6,484,518) (6,409,259) 180.410 180.410 177,719 146.200 146,200 12,458 110,441,858 124,919,772 60,158 392,958 106.525 619.653 666,589 4,807.602 5.078,847 5:229 6.168 4,814,244 4,814,244 5,117,250 792.500 792,500 943.500 836.695 37.190,075 1.138,096 116,593,477 131,225.480 (11,808) (704,736) (847,255) (91,490) (112,263) (1,140.671) (710,999) (1,107,918) (481,200) (990.853) (945.097) (4,510) (6,477) (1.837.021) (1,867,247) (2,482,380) (5.691.585) (5,829,970) (5,976,774) (910.000) (910,000) (1,061,000) (8.113.104) (910,000) (11.130,577) (13.567,571) (836.695) (29.076,971) (228.096)(105.462,899) (99.017,980) (836,695) (29,076.971) (228,096)(105,462,899) (99.017,980) (836.695) (37.190.075) (1,138,096)(116.593.477)(112,585.551) r~~ 13 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31May2009 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T O T A L S SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 7,503,794 7,503,794 7,152,563 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS 116,091 116,091 56,847 INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 664 664 FIXED ASSETS 51,306,938 359.885.309 411,192,247 399.631.407 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 69.985.183 69,985,183 62,053,336 TOTAL ASSETS 58.927,487 359,885,309 69,985,183 488.797.980 468.894,153 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEUEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (225.603) (69.985,183) (70.210,786) (62,131,982) TOTAL LIABILITIES (225,603) (69,985.183) (70.210.786) (62,131,982) FUND BALANCES (58.701.885) (359.885.309) (418,587,194)(405.866,781) TOTAL FUND E (58.701,885) (359,885,309) (418,587,194)(405,866.781) TOTAL LIABILITIES/EQUITY (58.927.487) (359,885.309) (69,985,183) (488.797,980)(467.998.763) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 05/31/2009 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D . VARIANCE *******REVENUES******* PROPERTY TAXES 22,579,237 .00 21,425,433. 20 1,153,803 .80 22,098,429 .20 20,250.217. 35 1,848,211. 85 SALES TAX 11.008.800 .00 10,218,296. 58 790.503 .42 14,225,660 .61 11,553.483. 50 2.672.177. 11 REAL PROPERTY TRANSFER TAX 275.000 .00 233,264. 37 41.735 .63 493.175 .01 363.471. 30 129.703. 71 HOTEL TRANSIENT OCCUPANCY TAX 590.000 .00 482,396. 22 107.603 .78 789,397 .41 670,674. 63 118.722. 78 FRANCHISE TAXES 2,206.295 .00 1,818,793. 95 387,501 .05 2,221,929 .73 1,847.653. 87 374.275. 86 LICENSES & PERMITS 1,903,875 .00 1,459,454. 95 444,420 .05 1,784,643 .77 1,559,911 .33 224,732. 44 FINES & FORFEITURES 138,900 .00 132,301. 01 6,598 .99 156,520 .17 134,626 .90 21,893. 27 USE/MONEY & PROP-INTEREST 1,921.137 .00 1,952,338. 34 (31,201 .34) 2,620,128 .17 2,173,372 .17 446,756. 00 USE/MONEY & PROP-RENTALS 218.941 .00 210,776. 28 8,164 .72 335.151 .45 279,527. 51 55,623. 94 INTERGOVERNMENTAL 956,173 .00 254,063. 66 702,109 .34 1,079.087 .97 701,186 .83 377,901. 14 CHARGES FOR SERVICES 5,751,709 .00 5,623.256. 85 128.452 .15 6,482,093 .07 5.625.002. 28 857,090. 79 OTHER SOURCES OF REVENUE 3.224,015 .00 2.844.408. 08 379.606 .92 866,991 .80 675.229. 10 191.762. 70 TOTAL REVENUE 50,774,082 .00 46.654,783. 49 4,119,298 .51 53.153,208 .36 45.834.356. 77 7.318,851. 59 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 292,096 .00 217.824. 78 74,271 .22 262,987 .19 244.365. 22 18.621. 97 CITY MANAGER 1.196,303 .00 1.042.470. 19 153.832 .81 1,052,588. 57 950,188. 37 102,400. 20 CENTRAL SERVICES 566.646 .00 451.775. 03 114,870 .97 495,825. 93 414,236. 77 81,589. 16 CITY ATTORNEY 739,979 .00 798.413. 44 (58,434 .44) 733,479 .11 503.158. 56 230.320. 55 ADMIN SERVICES 1,852,827 .00 1,518.345. 85 334.481 .15 1,600.978. 71 1,420.901. 00 180,077. 71 BUILDING MANAGEMENT 809.909 .00 572,297. 23 237,611 .77 699.948. 45 546.654. 86 153.293. 59 INSURANCE COST CENTER 527,781 .00 402,975. 72 124,805 .28 386.652. 28 401,417. 89 (14,765. 61) ELECTIONS COST CENTER 36,120 .00 29,439. 57 6,680 .43 1,124. 24 977. 39 146. 85 NON-DEPARTMENTAL 96,190 .00 8.473. 64 87,716 .36 19.754. 72 17,295. 36 2.459. 36 ACTIVITY TOTAL 6,117,851 .00 5.042.015. 45 1.075.835 .55 5.253,339. 20 4,499,195. 42 754,143. 78 PUBLIC SAFETY POLICE 13,476.020 .00 6.945.663. 41 6.530,356 .59 12,720.342. 53 6,863.772. 21 5.856,570. 32 CROSSING GUARDS 100.622 .00 75,469. 41 25,152 .59 97,662. 78 78.883. 20 18,779. 58 ANIMAL CONTROL 400.670 .00 71,161. 00 329,509 .00 311,991. 99 138,138. 90 173.853. 09 TRAFFIC SIGNALS & STREET LIGHTIN 13,845 .00 11.231. 94 2.613 .06 12,023. 37 8,943. 57 3.079. 80 DISASTER PREPAREDNESS 137,701 .00 78.569. 67 59.131 .33 92,050. 23 61,270. 76 30.779. 47 FIRE SERVICES 9.763.362 .00 4,825,815. 73 4,937,546 .27 9,430.762. 41 7.059.371. 78 2,371,390. 63 ACTIVITY TOTAL 23,892.220 .00 12.007.911. 16 11,884,308 .84 22.664,833. 31 14.210,380. 42 8.454,452. 89 TRANSPORTATION PUBLIC WORKS 1.144,148 .00 951,694. 48 192.453 .52 986.198. 88 846.492. 06 139,706. 82 STREET MAINTENANCE 40.686 .00 22.845. 03 17,840 .97 462. 72 397. 40 65. 32 STREET SWEEPING 145,605 .00 107.223. 83 38.381 .17 134,374. 05 102.755. 46 31,618. 59 STREET TREE MAINTENANCE 124,847 .00 84,181. 01 40.665 .99 78,680. 52 38,259. 99 40.420. 53 STREET LANDSCAPING MAINTENAN 849.320 .00 681,459. 02 167,860 .98 817,367. 33 592.070. 24 225,297. 09 ACTIVITY TOTAL 2.304,606 .00 1,847.403. 37 457,202 .63 2.017,083. 50 1,579.975. 15 437,108. 35 HEALTH & WELFARE WASTE MANAGEMENT 600. 00 (600 .00) 7,390. 58 7,390. 58 ~ o~= 13 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 05/31/2009 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D . VARIANCE CHILD CARE 18,500 .00 11.936 .73 6.563 .27 18.500 .00 16,414 .69 2,085 .31 SOCIAL SERVICES 46.925 .00 33,316 .72 13.608 .28 25,413 .00 21,994 .94 3,418 .06 HOUSING PROGRAMS ACTIVITY TOTAL 65,425 .00 45,853 .45 19,571 .55 51,303 .58 45,800 .21 5,503 .37 CULTURE & LEISURE SERVICES LIBRARY SERVICES 868.401 .00 635,863 .43 232.537 .57 802,695 .43 600.927 .43 201,768 .00 CULTURAL ACTIVITIES 238.281 .00 203.021 .68 35.259 .32 217,296 .55 199,504 .69 17,791 .86 HERITAGE CENTER 251,713 .00 215.708 .07 36.004 .93 234,222 .38 198,472 .57 35,749 .81 DUBLIN CEMETERY 46.750 .00 29,440 .03 17,309 .97 36,692 .31 25,681 .05 11,011 .26 PARK MAINTENANCE 2,049,027 .00 1,380,746 .98 668,280 .02 1.943,588 .26 1,374,535 .05 569,053 .21 COMMUNITY TV 78.445 .00 75,308 .20 3.136 .80 117,348 .36 116,258 .36 1,090 .00 RECREATION ADMIN 766.613 .00 661,120 .79 105,492 .21 724,768 .91 649,973 .44 74,795 .47 PLAYGROUNDS 389.872 .00 252,823 .97 137,048 .03 292,470 .16 244,437 .03 48,033 .13 SHANNON CENTER 344,555 .00 272.824 .86 71,730 .14 276,775 .62 245,988 .70 30,786 .92 PRESCHOOL 126.887 .00 127,030 .19 (143 .19) 108,501 .41 99,550 .75 8.950 .66 TEENS PROGRAM 161,187 .00 120.599 .07 40.587 .93 124.796 .04 107,681 .49 17,114 .55 ADULT SPORTS 187,182 .00 153.515 .60 33.666 .40 160,687 .23 137,536 .42 23,150 .81 YOUTH SPORTS 238.806 .00 208.465 .42 30.340 .58 222,307 .17 191,872 .12 30.435 .05 COMMUNITY GYM 47.937 .00 35,170 .71 12,766 .29 43.936 .22 37,141 .13 6.795. 09 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 440,889 .00 397,924 .12 42,964 .88 403.148 .41 384.857 .03 18.291. 38 SENIOR CENTER 604,477 .00 493,511 .59 110,965 .41 541,942 .56 463,074 .28 78.868. 28 RECREATION INSTRUCTION 193,304 .00 167,548 .88 25,755 .12 183.565 .98 166.297 .24 17.268. 74 AQUATICS 478,246 .00 359,254 .13 118.991. 87 458,574 .88 353,365 .09 105,209. 79 PARKS/FACILITIES MANAGEMENT 221,263 .00 230,380 .52 (9,117,. 52) 311,975 .20 282,662 .91 29.312. 29 ACTIVITY TOTAL 7,733.835 .00 6,020,258 .24 1,713,576. 76 7,205.293 .08 5,879.816 .78 1,325,476. 30 COMMUNITY DEVELOPMENT PLANNING 2,592,757 .00 1.967,213 .38 625,543. 62 2,479,866 .71 2,112,568 .54 367,298. 17 BUILDING SAFETY 1,998,503 .00 1,569.671 .87 428.831. 13 2,515,366 .57 2,181.582 .52 333.784. 05 ENGINEERING 1.816,437 .00 1,707,603 .39 108.833. 61 2.054.482 .25 1.828.690 .31 225.791. 94 ECONOMIC DEVELOPMENT 251.509 .00 192.275 .34 59.233. 66 255,829 .71 197.257 .37 58,572. 34 ACTIVITY TOTAL 6,659,206 .00 5.436,763 .98 1,222,442. 02 7,305.545 .24 6,320,098 .74 985.446. 50 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 5,770,057 .00 4.050.999 .10 1.719,057. 90 384,619 .81 290.278. 18 94,341. 63 COMMUNITY IMPROVEMENTS 117,110 .00 12,003. 99 105,106. 01 218.057 .69 150,622. 07 67,435. 62 PARKS 7.095,701 .00 2.780.149. 22 4.315,551. 78 4,249.293. 53 3.893,356. 37 355.937. 16 STREET CONSTRC/IMPROVEMENTS 2,604,860 .00 1,655,518. 14 949,341. 86 271,116. 67 175.304. 33 95,812. 34 ACTIVITY TOTAL 15,587,728 .00 8,498.670. 45 7,089,057. 55 5,123.087. 70 4,509.560. 95 613.526. 75 TOTAL EXPENDITURES 62,360,871 .00 38,898.876. 10 23.461.994. 90 49.620.485. 61 37,044,827. 67 12.575,657. 94 EXCESS REVENUE (EXPENDITURES) (11,586,789 .00) 7,755,907. 39 (19.342.696. 39) 3.532,722. 75 8.789.529. 10 (5,256,806. 35) TRANSFERS IN FROM OTHER FUNDS 70.927. 77 52,883. 57 18.044. 20 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES (11.586,789 .00) 7.755,907. 39 (19.342,696. 39) 3.603.650. 52 8.842,412. 67 (5,238.762. 15) ~~ i~ THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 05/31/2009 SPECIAL REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES 134,025 .00 128,341. 48 5,683 .52 130.609. 95 119,716 .70 10,893. 25 SALES TAX/OTHER TAXES 439.234 .00 329.515. 43 109,718 .57 458,429. 22 342,866 .69 115.562. 53 FINES & FORFEITURES 197.000 .00 152,888. 69 44,111 .31 203,975. 65 167.201 .26 36,774. 39 USES/MONEY & PROPERTY 134;360 .00 148,573. 13 (14,213 .13) 196,387. 20 173,469 .07 22,918. 13 INTERGOVERNMENTAL FROM STATE 1,509,854 .00 1,035,302. 21 474,551 .79 1,639,303. 16 1,440,098 .80 199.204. 36 INTERGOVERNMENTAL FROM COUNTY 366,575 .00 248,196. 49 118.378 .51 359.383. 45 235,563 .55 123.819. 90 INTERGOVERNMENTAL FROM FEDERAL 1.450.900 .00 180.930. 12 1.269,969 .88 353.538. 54 215,800 .17 137,738. 37 CHARGES FOR SERVICES 1,615,400 .00 1,504.687. 31 110.712 .69 1,497,236. 92 1.405,278 .20 91,958. 72 OTHER SOURCES OF REVENUE 6,500 .00 12,461. 04 (5.961 .04) 34,499. 24 9,205 .00 25.294. 24 TOTAL REVENUE 5,853,848 .00 3,740,895. 90 2,112.952 .10 4,873.363. 33 4,109,199 .44 764.163. 89 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 111.940 .00 110.442 .55 1.497 .45 102,652 .11 102,640 .36 11 .75 TRAFFIC SIGNALS & STREET LTG 306.670 .00 140.986 .61 165,683 .39 259,283. 22 191,040 .97 68,242 .25 DISASTER PREPAREDNESS FIRE SERVICES 374,014 .00 189,563 .08 184.450 .92 287,483. 00 220,016 .18 67,466 .82 ACTIVITY TOTAL 792,624 .00 440.992 .24 351,631 .76 649,418. 33 513.697 .51 135,720 .82 TRANSPORTATION: STREET MAINTENANCE 387,651 .00 231,377 .01 156,273 .99 271,408. 11 173.862 .59 97,545 .52 STREET LANDSCAPE MAINTENANCE 6,407. 67 6.407 .67 ACTIVITY TOTAL 387.651 .00 231,377 .01 156.273 .99 277,815. 78 173,862 .59 103,953 .19 HEALTH & WELFARE: WASTE MANAGEMENT 1,826,701 .00 1.659,649 .92 167.051 .08 1,602,667. 69 1,582,464. 26 20,203 .43 SOCIAL SERVICES 59,708 .00 56,590 .91 3.117 .09 52.944. 65 44,316. 16 8,628 .49 HOUSING PROGRAMS ACTIVITY TOTAL 1.886,409 .00 1,716,240 .83 170,168 .17 1,655.612. 34 1,626.780. 42 28.831 .92 COMMUNITY DEVELOPMENT: ENGINEERING 6.000 .00 6.000 .00 6,000. 00 2.472. 00 3.528 .00 ACTIVITY TOTAL 6.000 .00 6,000 .00 6.000. 00 2,472. 00 3,528 .00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 10.926. 00 10,926. 00 COMMUNITY PROJECTS PARKS 229,591. 00 176.580 .62 53,010 .38 61,729. 05 321. 34 61,407. 71 STREET CONSTRUCTION/IMPROVEMENT 3.381.533. 00 846,595 .13 2.534.937 .87 1,998.211. 85 1.180.254. 97 817,956. 88 ACTIVITY TOTAL 3,611,124. 00 1,023.175 .75 2,587,948 .25 2,070.866. 90 1,180.576. 31 890,290. 59 T 0 T A L EXPENDITURES 6,683,808. 00 3.417,785. 83 3,266,022 .17 4,659.713. 35 3,497,388. 83 1.162.324. 52 EXCESS REVENUE (EXPENDITURES) (847,960. 00) 305.595. 49 (1,153,555 .49) 213.649. 98 611,810. 61 (398.160. 63) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 6,600. 00 (6.600. 00) 77,527. 77 52,883. 57 24,644. 20 REVENUES OVER (UNDER) EXPENDITURES (847,960. 00) 298,995. 49 (1.146,955. 49) 136,122. 21 558,927. 04 (422.804. 83) # I?~ ~ J THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDI TURES FOR THE PERIOD 07/01/2008 THROUGH 05/31 /2009 S PE CIAL ASS ESSM ENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANC E FISCAL YEAR Y.T.D . VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS 831,987 .00 735.422. 47 96.564 .53 797,519 .80 720,660. 31 76,859. 49 USES/MONEY & PROP-INTEREST 22,931 .00 20.101. 18 2.829 .82 26.739 .60 21,558. 71 5,180. 89 OTHER SOURCES OF REVENUE 5,000 .00 10,959. 16 (5.959 .16) 578 .00 578. 00 TOTAL REVENUE 859,918 .00 766,482. 81 93.435 .19 824,837 .40 742,797. 02 82,040. 38 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 362,960 .00 259,244. 29 103.715 .71 315.699. 72 250,935. 89 64,763 .83 ACTIVITY TOTAL 362,960 .00 259.244. 29 103.715 .71 315,699. 72 250,935. 89 64,763. 83 TRANSPORTATION PUBLIC WORKS STREET TREE MAINTENANCE 40,430 .00 19.594. 17 20.835 .83 72,355. 91 44,274. 32 28.081. 59 STREET LANDSCAPE MAINTENANCE 410,969. 00 242.513. 94 168,455 .06 352,276. 33 227.215. 38 125,060. 95 ACTIVITY TOTAL 451,399 .00 262,108. 11 189,290 .89 424,632. 24 271.489. 70 153.142. 54 COMMUNITY DEVELOPMENT ENGINEERING 16,135. 00 14,786. 28 1,348 .72 16,032. 94 13,532. 94 2,500. 00 ACTIVITY TOTAL 16,135. 00 14,786. 28 1,348 .72 16,032. 94 13,532. 94 2.500. 00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRUMNT ACTIVITY TOTAL T 0 T A L EXPENDITURES 830.494. 00 536.138. 68 294,355 .32 756,364. 90 535,958. 53 220,406. 37 EXCESS REVENUE (EXPENDITURES) 29.424. 00 230,344. 13 (200.920 .13) 68.472. 50 206,838. 49 (138,365. 99) REVENUES OVER (UNDER) EXPENDITURES 29,424. 00 230.344. 13 (200,920 .13) 68.472. 50 206.838. 49 (138.365. 99) 0~ ~~ ~3 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 05/31/2009 ********REVENUE******** USES OF MONEY & PROPERTY INVESTMENT INTEREST LOAN REPAYMENT-PRINCIPAL LOAN REPAYMENT-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: CAPITAL IMPROVEMENT FUNDS CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR PRIOR Y.T.D. 1,427,074.00 1,211,908.18 215,165.82 1.749.574.46 1.557,479.75 750,000.00 (750.000.00) 1.500,000.00 1,500,000.00 90,000.00 90.000.00 8.842.750.00 (425,741.83) 9,268.491.83 18,353,827.13 17,768.180.87 10.269.824.00 1,536,166.35 8,733,657.65 21.693,401.59 20,915,660.62 192,094.71 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL CITY ATTORNEY ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS ACTIVITY TOTAL CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING 180,373.31 189,900.00 53.833.20 136,066.80 156,534.86 123,830.33 189.900.00 53,833.20 136,066.80 336,908.17 123.830.33 VARIANCE 585,646.26 777,740.97 180,373.31 32,704.53 213.077.84 3,942,094.00 972.570.01 2,969,523.99 1,007,526.67 789,681.34 217,845.33 3.942.094.00 972.570.01 2.969,523.99 1,007.526.67 789,681.34 217,845.33 ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 150,896. 00 14,554 .00 136,342 .00 29.278. 01 29.278 .01 COMMUNITY IMPROVEMENTS 250,000. 00 7,785 .60 242,214 .40 PARKS 7,811,302. 00 4,172,525 .80 3.638.776 .20 4,509,205. 57 2.895.233.46 1.613,972 .11 STREET CONSTRUCTION/IMPROVEMENT 19.222.467. 00 9.867,050 .07 9.355,416 .93 8.762,562. 03 7.971.902.40 790.659 .63 ACTIVITY TOTAL 27,434,665. 00 14,061,915 .47 13,372,749 .53 13,407,852. 01 10,867,135.86 2,540,716 .15 T 0 T A L EXPENDITURES 31.574,659.00 15.093.818.68 16.480,840.32 14.645,480.45 11.780.647.53 2.864,832.92 EXCESS REVENUE (EXPENDITURES) (21.304.835.00)(13.557,652.33) (7,747,182.67) 7,047,921.14 9,135,013.09 (2.087,091.95) TRANSFER IN FROM OTHER FUNDS 6,600.00 (6.600.00) 6.600.00 6.600.00 TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES(21.304,835.00)(13,551.052.33) (7,753.782.67) 7,054,521.14 9,135,013.09 (2.080,491.95) 11 b~ 13 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 05/31/2009 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T O T A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) REVENUES OVER (UNDER) EXPENDITURES 222,797.20 (222,797.20) 202,985.34 178,644.03 24,341.31 (2.005.002.11) 2.005.002.11 (201,809.72) (95,040.31) (106,769.41) (1,276,851.41) 1,276,851.41 517,841.22 561,374.53 (43,533.31) 235,438.87 (235,438.87) 236,480.04 236.396.70 83.34 480,166.42 (480,166.42) 446.924.16 422,885.73 24,038.43 480.166 .42 (480,166. 42) 446,924 .16 422.885. 73 24.038 .43 (1,757.017 .83) 1,757,017. 83 70,917 .06 138.488. 80 (67,571 .74) (1,757,017 .83) 1.757,017. 83 70.917 .06 138,488. 80 (67.571 .74) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 05/31/2009 INTERNAL SERVICE FUNDS CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ********REVENUES******** USES/MONEY & PROP-INTEREST CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: FIRE ACTIVITY TOTAL TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: is ~~ I3 PRIOR Y.T.D. VARIANCE 260,403 .00 226,004 .58 34,398. 42 286,586 .87 258,654. 74 27.932 .13 1,125,184 .00 1,799.445 .23 (674.261. 23) 1.968.529 .47 1.811,707. 19 156.822 .28 36,000 .00 255,42 .85 (219.142. 85) 5,259.344 .46 218,704. 23 5,040,640 .23 1,421,587 .00 2,280.592 .66 (859.005. 66) 7,514.460 .80 2,289.066. 16 5,225,394 .64 3,839,554.00 1.769,077.48 2,070,476.52 3,249,414.38 1,111,006.75 2,138,407.63 3,839.554.00 1,769,077.48 2.070,476.52 3,249,414.38 1,111,006.75 2,138,407.63 T 0 T A L EXPENDITURES 3.839.554.00 1,769,077.48 2,070,476.52 3.249.414.38 1.111,006.75 2,138,407.63 EXCESS REVENUE (EXPENDITURES) (2,417,967.00) 511,515.18 (2.929.482.18) 4,265,046.42 1.178,059.41 3.086.987.01 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (2,417,967.00) 511,515.18 (2.929,482.18) 4,265.046.42 1.178.059.41 3.086.987.01 ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL FINANCE ACTIVITY TOTAL PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T O T A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 05/31/2009 ENTERPRISE CURRENT CURRENT BUDGET ACTUAL VARIANCE 20.00 20.00 20.00 (20.00) FUND PRIOR FISCAL YEAR 20.00 20.00 20.00 (20.00) ~ ~ ~ ,~, PRIOR Y.T.D. VARIANCE REVENUES OVER (UNDER) EXPENDITURES (20.00) (20.00)