The URL can be used to link to this page

Home My WebLink About4.07 Financial Rpt March 09CITY CLERK }~ ~~ U~~ry File # ^®0®'0® ~~\ ~~~~~ az AGENDA STATEMENT C~ ~ CITY COUNCIL MEETING DATE: May 5, 2009 ~LII'pR~~ SUBJECT: Preliminary Financial Reports for the Month of March 2009 Report Prepared by: Paul S Rankin, Administrative Services ,~~/j Director and Vivian Gong, Finance Manager ~lJ"~ ATTACHMENTS: 1.YTD (Year-To-Date) Revenues and Budget Comparison 2.YTD (Year-To-Date) Expenditures and Budget Comparison 3.March 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 March 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 March 2009 Revenue and Expenditure Reports The March report represents the reporting of revenues and expenditures for nine months of Fiscal Year 2008/2009 (July 1, 2008 through March 31, 2009). This represents the completion of three quarters 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 nine months may be incomplete until the billing is received and recorded. General Fund Revenues Total General Fund Revenues collected through March 2009 represented 66% of the budgeted amount. In the first nine months of the previous Fiscal Year the City collected 60% of its total General Fund revenue for the year. The revenue collected in July 2008 through March 2009 was approximately 6% or $1,238,050 more than the total collected in July 2007 through March 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\Mar 2009.doc ITEM NU. ~• n 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 -March 2009 vs. July -March 2008 REVENUE YTD YTD DIFFERENCE March March FY 08/09 More / EXPLANATION 2009 2008 (Less) FY 07/08 Property Tax $13,732,059 $13,040,773 $691,286 A majority of the increase ($615,800 or 89%) was due to the annual increase in the assessed value of secured properties. ANNUAL ANNUAL ACTUAL Collections through March 2009 were BUDGET BUDGET PRIOR YR DIFFERENCE tracking at 61 % of the annual budget. $22,579,237 $22,098,429 $ 480,808 Sales Tax/In- Sales tax decreased by $1.1 million Lieu Sales $7,193,826 $8,330,362 ($1,136,536) comprised of a) an $875,125 decrease in Tax local sales tax transactions compared to the same period in the prior year. (This accounts for the 4`h qtr holiday sales and decline due to the economic recession). B) the remaining $261,411 decrease is attributed to a timing ANNUAL ANNUAL ACTUAL difference of a prior year Sales Tax In-lieu BUDGET BUDGET PRIOR YR DIFFERENCE revenue. Receipts thru March 2009 $11,008,800 $14,225,661 ($3,216,861) accounted for 65% of the revised bud et. Real $197,261 $339,378 ($142,117) The decrease is due to fewer real estate sale Property transactions have occurred, a trend which Transfer Tax was expected in the current budget. ANNUAL ANNUAL ACTUAL BUDGET BUDGET PRIOR YR DIFFERENCE $275,000 $493,175 $218,175 Transient $397,593 $553,869 ($156,276) This revenue has decreased as a direct result Occupancy of lower hotel occupancy rates. Collections Taxes through March 2009 were approximately 3% less than the same period of the previous year ANNUAL ACTUAL and accounted for 67% of budget. ANNUAL BUDGET PRIOR YR DIFFERENCE BUDGET $590,000 $789,397 $199,397 License and $1,344,355 $1,293,803 $50,552 There were slight increases in building Permits permits revenue (+$40,400) and Fire Permits revenue (+$29,300) which were partially offset by a decrease (-$19,200) in Encroachment Permits, Construction ANNUAL ANNUAL ACTUAL /Demolition Permits, and Business Licenses. BUDGET BUDGET PRIOR YR DIFFERENCE This category is tracking at 70% of the $1,903,875 $1,784,644 $119,231 current budget. Page 2 of 4 REVENUE YTD YTD DIFFERENCE March March FY 08/09 More / EXPLANATION 2009 2008 (Less) FY 07/08 Interest revenue has decreased by $120,000 Interest and $1,683,952 $1,860,708 ($176,756) compared to same period of the prior year Rentals and was due to the declining investment rates. A decrease has also occurred in rental ANNUAL ANNUAL ACTUAL income. Only US bank remains at the BUDGET BUDGET PRIOR YR DIFFERENCE Dublin Square Property, whereas in the prior $2,140,078 $2,955,280 $815,202 ear the Cit collected from other tenants. 84% of the variance is due to a one-time Inter- $184,486 $668,801 ($484,315) Workforce Housing grant of $409,600 the governmental City received in FY07/08 for the Shannon Community Center Reconstruction project. The remaining variance occurred in the ongoing revenues received from State, particularly the Vehicle License Fee (VLF), which decreased $63,000, and the State Mandated Costs reimbursement program decreased $18,000. A potential $605,700 grant for the storm water project was ANNUAL ACTUAL included in the current budget and the project ANNUAL BUDGET PRIOR YR DIFFERENCE has been delayed. No expenditures have BUDGET $956,173 $1,079,088 $122,915 occurred for this roject. The deviation in this category is composed Charges for $4,723,017 $4,381,178 $341,839 by the increases and decreases of several Services revenues: 1) Zoning & Subdivision Fees increased +$444,800; 2) Plan Check & Inspection Fees decreased <$171,400>; 3) Fire Inspection Fee increased +$20,400; and ANNUAL ANNUAL ACTUAL 4) Recreational services increased +$48,100. BUDGET BUDGET PRIOR YR DIFFERENCE Revenues are tracking at 82% of the current $5,751,709 $6,482,093 $730,384 bud et. The increase is primary associated with a $1 Other $2,817,138 $522,200 $2,294,938 million Community Benefits payment the Revenue City received per the Wallis Ranch development agreement and $1.5 million reimbursement received in accordance with ANNUAL ANNUAL ACTUAL an agreement with the City of Pleasanton for BUDGET BUDGET PRIOR YR DIFFERENCE work related to the Fallon Interchange $3,214,015 $866,992 $2,347,023 ro'ect. General Fund Expenditures Overall, through the month of March 2009, expenditures in the General Fund totaled approximately $34 million and represented approximately 55% of the total budgeted expenditures in the General Fund (Attachment 2). Of this amount, a total of $7,540,621 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 O erating Expenditures (Attachment 2) indicates that through March 2009, expenditures totaled 56% of the Budgeted General Fund expenses. In the same period of the previous year the City expended 51 % of the actual total General Fund Expenditures for the year. The total amount of General Fund Operating expenditures in the first nine months of Fiscal Year 2008/09 were approximately $3,793,689 or 5% higher than the amounts expended for the same period in the prior Fiscal Year. The primary cause of the deviation was due to a timing difference in the second quarter payment for contracted Police services provided by the Alameda County. In the current fiscal year the City made the second quarter payment in March 2009. In the prior year, the second quarter payment did not occur until April. 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 t ~ , City of llublin 2008-2009 YTD Revenues and Budget Comparison For the Period Ending March 31, 2009 Total General Fund Revenues Property Taxes 6 ~% 59 /° Sales Taxes «65% Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services 72% 69% I 67% 70% X71 72 --- 79% 63 ® 19% 62 82 `% -_ _ 68% Fines and Forfeitures o6% ~--- - _ _ ~ 68 /° Other Revenues 88 ^ FY ?008/09 FY ?007/08 0% ~ 30% 60% 90% 120% 150% 75% of Yea-• Complete FY 2008/09 FY 2008!09 % of FY 2007108 Budget YTD Actual Budget YTD Actual of Total for FY 2007108 Property Taxes 22,579,237 13,732,059 81 % 13,040,773 59% Sales Taxes 11,008,800 7,193,826 85% 8,330,362 59% Real Property Transfer Tax 275,000 197,261 72% 339,378 69% Transient Occupancy Taxes 590,000 397,593 67% 553,869 70% Franchise Taxes 2,206,295 ;,99.7,413 45% 1,040,195 47% Licenses and Permits 1,903,875 1.,344,355 71% 1,293,803 72% Interest and Rentals 2,140,078 1,683,952 79% 1,860,708 63% Intergovernmental 956,173 184,486 19% 668,801 62% Charges for Services 5,751,709 4,723,017 82% 4,381,178 68% Fines and Forfeitures 138,900 105,060 76% 106,844 68% Other Revenues 3,214,015 2,817,138 88% 522,200 60% Total General Fund Revenues 50,764,082 33,376,160 66% 32,138,110 60% :Jain Fri~.ttetl aitfi/:OU9 5 tC AM ATTACHMENT1 ---- - _ ~ _~_ ~'~v City of Dublin 2008-2009 YTD Expenses and Budget Comparison For the Period Ending March 31, 2009 Total General Fund 55% Expenses ~ 54% Creneral Government 68% 68% Police ~ 50% 26% Fire 48% 50% - ^ FY 2008/09 Other Public Safety 31%--- o D FY 2007/08 Transportation 63% '59/0 - Health and Welfare 55%_____ _ _ '73% -_ - _ -_ _ _ Culture & Community 61% Services : -- _ __ -_ - - -_ _ 63% Community ~ 66% Development _____- 68% Capital Irnprov. 49% Projects ~ 78% 0% 20% 40% 60% 80% 100% 120% 7_5% of Year Complete 2008/2009 200812009 % of FY 2007(08 % of Total for Budget YTD Actual Budget YTD Actual FY 2007/08 General Government 6,132,761 4,149,910 68% 3,582,881 68% Police 13,476,020 6,685,556 50% 3,330,545 26% Fire 9,763,362 4,729,012 48% 4,676,241 50% Other Public Safety 652,838 200,440 31% 247,179 48% Transportation ,.2;304,600 1,450639 63% 1,194,796 59% Health and Welfare 65,425 35,796 55% 37,432 73% Culture and Community Services 7,733,835 4,742,128 61 % 4,551,614 63% Community Development 6,659,206 4,421,856 66% 5,000,959 68% Capital Improvement Projects 15,496,818 7,540,621 49% 4,003,469 78% Total General Fund Expenses 62,284,871 33,955,958 55% 26,625.116 54% General Fund Operating Expenses 46,78$,053 26,415,336 56% 22,621,647 51 ~a:,.,~„~ 4„~,~~ase,~4M1• ATTACHMENT 2 ~ ~.. CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF MARCH 2009 Prepared by 11~e Finance De-partment April 15, 7p~9 ATTACHMENT 3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2009 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUNDS FUNDS FUND ASSETS CASH (45,329,308) 4.857,703 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST 103,917,380 RECEIVABLES: TAXES ACCOUNTS 144,337 2,500 INTEREST 619,653 ASSESSMENTS DUE FROM OTHERS 4,869,369 INVENTORY AT COST PREPAID ITEMS 5,839 FIXED ASSETS LOANS RECEIVABLE AMOUNT TO BE PROVIDED TOTAL ASSETS 64,227,268 4,860.203 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (625,663) DEPOSITS FOR AB1600 FEES (20,773) DEPOSITS OTHERS (833,458) PAYABLES: ACCOUNTS (364,464) (64.585) INTEREST PAYROLL (5.380) DUE TO OTHERS (30.226) DEFERRED REVENUE (128.895) DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (2.008.858) (64,585) FUND BALANCES (62,218,410) (4,795.618) TOTAL FUND E (62,218,410) (4.795.618) TOTAL LIABILITIES/EQUITY (64.227.268) (4,860.203) ~ ~ ~-, TOTALS ---MEMORANDUM ONLY-- CURRENT PRIOR 683,171 34,618.801 94,408 (5,075,225) (2,733.437) 180.381 180.381 177.719 146,200 146.200 152.697 103,917,380 117,108.386 60.158 206,994 106.525 619,653 612.631 4,869,369 5,137,890 5,839 6.184 4.779,955 4,779,955 5.117,250 792,500 792,500 943.500 683.171 40,455.030 1.067,289 111,292,960 127,216,081 (11,808) (637,472) (1.323.512) (91,469) (112,242) (1,136.326) (833.458) (941.769) (454,510) (883.558) (632.320) (5.380) (3,929) (1,837.021) (1.867.247) (1,819,768) (5.629.871) (5.758,765) (5,846,540) (910.000) (910.000) (1.061,000) (8.024,679) (910,000) (11.008,121) (12.765.163) (683.171) (32,430.351) (157.289)(100.284,839) (99.017.980) (683.171) (32.430.351) (157,289)(100.284,839) (99.017.980) (683.171) (40.455,030) (1.067.289)(111,292,960)(111,783.143) ' ~ ~. CIT Y OF DUBLIN BA LANCE SHEET FOR THE PERIOD ENDING 31Mar2009 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,256.728 7,256.728 7,040,779 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS 68.850 68,850 18,320 INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 2.969 2.969 3.966 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 61,986,566 TOTAL ASSETS 58.635.485 359.885,309 69,985,183 488.505,978 468,681,037 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (122.266) (69,985.183) (70.107,449) (61,986.566) TOTAL LIABILITIES (122,266) (69,985,183) (70.107,449) (61,986.566) FUND BALANCES (58.513.220) (359.885,309) (418.398,529)( 405,866.781) TOTAL FUND E (58.513.220) (359,885.309) (418.398.529)( 405,866.781) TOTAL LIABILITIES/EQUITY (58.635.485) (359.885.309) (69.985,183) (488,505.978)( 467,853.347) THE CITY OF DUBLIN STATEMENT SHOWING ~ ~ ~,,,. REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 03/31/2009 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL Y EAR Y.T.D . VARIANCE *******REVENUES******* PROPERTY TAXES 22,579,237 .00 13.732,058 .91 8.847,178 .09 22.098.429 .20 13,040,772 .68 9.057,656 .52 SALES TAX 11.008.800 .00 7.193.826 .14 3,814,973 .86 14,225,660 .61 8,330,361 .65 5.895,298 .96 REAL PROPERTY TRANSFER TAX 275,000 .00 197.260 .54 77.739 .46 493.175 .01 339.377 .97 153.797 .04 HOTEL TRANSIENT OCCUPANCY TAX 590.000 .00 397,593 .34 192.406 .66 789,397 .41 553,869 .09 235,528 .32 FRANCHISE TAXES 2,206,295 .00 997,413 .09 1.208.881 .91 2.221,929 .73 1.040,195 .27 1.181,734 .46 LICENSES & PERMITS 1,903,875 .00 1.344,354 .64 559,520 .36 1,784,643 .77 1.293,802 .97 490.840 .80 FINES & FORFEITURES 138,900 .00 105,059 .65 33.840 .35 156.520 .17 106.843 .53 49.676 .64 USE/MONEY & PROP-INTEREST 1.921,137 .00 1,511,936 .22 409,200 .78 2,620,128 .17 1,620,997 .81 999,130 .36 USE/MONEY & PROP-RENTALS 218.941 .00 172.015 .75 46,925 .25 335.151 .45 239,710 .47 95,440 .98 INTERGOVERNMENTAL 956.173 .00 184,486 .08 771,686 .92 1,079.087 .97 668.801 .28 410.286 .69 CHARGES FOR SERVICES 5,751,709 .00 4,723,017 .49 1.028,691 .51 6,482,093 .07 4,381,178 .02 2.100,915 .05 OTHER SOURCES OF REVENUE 3.214,015 .00 2.817.137 .96 396.877. 04 866.991 .80 522,199. 55 344.792 .25 TOTAL REVENUE 50,764,082 .00 33,376.159 .81 17,387,922. 19 53,153,208 .36 32,138,110. 29 21,015.098 .07 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 292,096 .00 192,904 .18 99,191. 82 262,987 .19 210.615. 92 52,371. 27 CITY MANAGER 1,196,303 .00 833.547 .11 362,755. 89 1,052.588 .57 757,062. 34 295,526. 23 CENTRAL SERVICES 566,646 .00 379.611 .22 187.034. 78 495.825 .93 329,475. 85 166,350. 08 CITY ATTORNEY 739,979 .00 625,278. 31 114,700. 69 733,479 .11 378.360. 25 355,118. 86 ADMIN SERVICES 1.852,827 .00 1,229.382. 22 623,444. 78 1,600.978 .71 1,131.161. 54 469.817. 17 BUILDING MANAGEMENT 809.909 .00 492.858. 89 317,050. 11 699.948. 45 455,673. 87 244,274. 58 INSURANCE COST CENTER 527,781 .00 359.562. 84 168,218. 16 386,652. 28 304,363. 49 82,288. 79 ELECTIONS COST CENTER 36,120 .00 30,140. 17 5,979. 83 1,124. 24 425. 00 699. 24 NON-DEPARTMENTAL 111.100 .00 6.625. 41 104,474. 59 19.754. 72 15,742. 51 4.012. 21 ACTIVITY TOTAL 6.132,761 .00 4,149.910. 35 1,982.850. 65 5.253.339. 20 3,582,880. 77 1,670.458. 43 PUBLIC SAFETY POLICE 13.476.020 .00 6.685,555. 65 6.790,464. 35 12.720,342. 53 3,330,544. 83 9.389.797. 70 CROSSING GUARDS 100,622 .00 51.834. 33 48.787. 67 97.662. 78 54,560. 88 43,101. 90 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 7,070. 45 6,774. 55 12.023. 37 7,445. 00 4,578. 37 DISASTER PREPAREDNESS 137.701. 00 70.373. 88 67.327. 12 92,050. 23 47,034. 38 45.015. 85 FIRE SERVICES 9,763.362. 00 4.729,012. 27 5.034,349. 73 9.430,762. 41 4.676.241. 25 4.754,521. 16 ACTIVITY TOTAL 23,892,220. 00 11,615.007. 58 12,277.212. 42 22.664,833. 31 8.253,965. 24 14,410.868. 07 TRANSPORTATION PUBLIC WORKS 1,144,148. 00 767,217. 34 376.930. 66 986,198. 88 651.312. 45 334.886. 43 STREET MAINTENANCE 40,686. 00 22.704. 63 17,981. 37 462. 72 397. 40 65. 32 STREET SWEEPING 145,605. 00 84.141. 73 61,463. 27 134,374. 05 81,987. 76 52.386. 29 STREET TREE MAINTENANCE 124.847. 00 78.102. 60 46.744. 40 78.680. 52 34,514. 77 44,165. 75 STREET LANDSCAPING MAINTENAN 849,320. 00 498,472. 46 350.847. 54 817.367. 33 426,583. 75 390.783. 58 ACTIVITY TOTAL 2.304.606. 00 1.450.638. 76 853.967. 24 2,017.083. 50 1.194,796. 13 822.287. 37 HEALTH & WELFARE WASTE MANAGEMENT 600. 00 (600. 00) 7,390. 58 7,390. 58 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 03/31/2009 GENERAL REVENUE FUND CURRENT BUDGET CHILD CARE 18.500 .00 SOCIAL SERVICES 46.925 .00 HOUSING PROGRAMS ACTIVITY TOTAL 65.425 .00 CULTURE & LEISURE SERVICES LIBRARY SERVICES 868.401 .00 CULTURAL ACTIVITIES 238.281 .00 HERITAGE CENTER 251,713 .00 DUBLIN CEMETERY 46.750 .00 PARK MAINTENANCE 2.049,027 .00 COMMUNITY TV 78.445 .00 RECREATION ADMIN 766,613 .00 PLAYGROUNDS 389,872 .00 SHANNON CENTER 344,555 .00 PRESCHOOL 126.887 .00 TEENS PROGRAM 161,187 .00 ADULT SPORTS 187,182 .00 YOUTH SPORTS 238.806 .00 COMMUNITY GYM 47,937 .00 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 440,889 .00 SENIOR CENTER 604,477 .00 RECREATION INSTRUCTION 193,304 .00 AQUATICS 478.246 .00 PARKS/FACILITIES MANAGEMENT 221.263 .00 ACTIVITY TOTAL 7.733,835 .00 COMMUNITY DEVELOPMENT PLANNING 2.592.757 .00 BUILDING SAFETY 1.998,503. 00 ENGINEERING 1.816.437. 00 ECONOMIC DEVELOPMENT 251,509. 00 ACTIVITY TOTAL 6,659.206. 00 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 5.694,057. 00 COMMUNITY IMPROVEMENTS 117.110. 00 PARKS 7,080,791. 00 STREET CONSTRC/IMPROVEMENTS 2,604,860. 00 ACTIVITY TOTAL 15.496,818. 00 TOTAL EXPENDITURES 62.284.871. 00 EXCESS REVENUE (EXPENDITURES) (11.520,789. 00) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES (11,520.789. 00) CURRENT PRIOR ACTUAL VARIANCE FISCAL YEAR 9.945.11 8.554.89 18.500.00 25.239.42 21.685.58 25,413.00 11.04 (11.04) 35,795.57 29,629.43 51,303.58 429,552.16 438,848.84 802.695.43 173,145.19 65,135.81 217,296.55 179,644.45 72,068.55 234.222.38 22,085.42 24,664.58 36,692.31 1,093,996.34 955,030.66 1.943,588.26 74,133.86 4,311.14 117,348.36 516.501.98 250.111.02 724,768.91 202,422.98 187,449.02 292.470.16 216,025.89 128,529.11 276,775.62 102.190.47 24,696.53 108,501.41 94.952.77 66.234.23 124,796.04 114,264.87 72,917.13 160,687.23 181,136.20 57.669.80 222,307.17 30,255.17 17,681.83 43,936.22 316,459.97 124,429.03 403.148.41 393,123.77 211.353.23 541,942.56 139,803.09 53,500.91 183,565.98 283,324.74 194,921.26 458,574.88 179,108.45 42,154.55 311.975.20 4,742,127.77 2,991,707.23 7,205.293.08 1,588,800.29 1,003,956.71 2.479.866.71 1,294,418.25 704.084.75 2.515,366.57 1.401.056.03 415.380.97 2.054.482.25 137.581.75 113.927.25 255,829.71 4,421,856.32 2.237.349.68 7.305,545.24 ~~rv PRIOR Y.T.D. VARIANCE 12,537.11 5.962.89 17,504.80 7,908.2C 37,432.49 13,871.09 406,701.37 395.994.06 164,950.83 52,345.72 159.301.00 74,921.38 17,854.34 18.837.97 1,104,530.91 839.057.35 114,326.41 3.021.95 507,356.00 217,412.91 192,249.42 100.220.74 192,655.77 84.119.85 79,030.64 29,470.77 83,651.40 41,144.64 105,701.26 54,985.97 156,585.19 65,721.98 31,104.81 12,831.41 254,267.39 148.881.02 356.583.33 185.359.23 131,561.82 52,004.16 272,712.57 185.862.31 220,489.56 91.485.64 4,551,614.02 2,653.679.06 1,623.032.95 856.833.76 1.803.939.83 711,426.74 1.423.999.94 630.482.31 149,985.98 105.843.73 5,000.958.70 2.304,586.54 4,033,225.15 1.660,831.85 384,619.81 238.661.52 145,958.29 10.531.62 106.578.38 218.057.69 127,144.03 90,913.66 1,936.776.22 5.144.014.78 4.249,293.53 3.591,790.10 657.503.43 1,560,088.29 1,044,771.71 271.116.67 45,873.10 225,243.57 7,540.621.28 7,956.196.72 5.123.087.70 4,003.468.75 1.119.618.95 33.955.957.63 28.328.913.37 49.620.485.61 26.625,116.10 22,995.369.51 (579,797.82)(10.940.991.18) 3,532.722.75 5.512,994.19 (1,980,271.44) 70,927.77 52.883.57 18.044.20 (579.797.82)(10.940.991.18) 3.603.650.52 5,565.877.76 (1,962,227.24) THE CITY OF DUBLIN STATEMENT SHOWING ~ ~~ REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 03/31/2009 SPECIAL REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES 134.025. 00 85,387 .22 48,637. 78 130,609 .95 80,245. 80 50,364 .15 SALES TAX/OTHER TAXES 439.234. 00 233,736 .05 205,497. 95 458.429 .22 238.657. 09 219.772 .13 FINES & FORFEITURES 197,000. 00 123,441 .25 73,558. 75 203.975 .65 129.846. 13 74.129 .52 USES/MONEY & PROPERTY 134.360. 00 115,487 .54 18.872. 46 196,387 .20 124,090. 08 72,297 .12 INTERGOVERNMENTAL FROM STATE 1,509,854. 00 737,723 .71 772,130. 29 1.639,303 .16 679.580. 92 959,722 .24 INTERGOVERNMENTAL FROM COUNTY 366,575. 00 206.552 .66 160,022. 34 359.383 .45 166.056. 65 193,326 .80 INTERGOVERNMENTAL FROM FEDERAL 1.450.900. 00 171,955 .55 1.278,944. 45 353,538 .54 101,225. 73 252,312 .81 CHARGES FOR SERVICES 1,615,400. 00 1,016.203. 20 599,196. 80 1,497,236 .92 952.140. 29 545,096. 63 OTHER SOURCES OF REVENUE 6,500. 00 12.461. 04 (5,961. 04) 34,499 .24 34.499. 24 TOTAL REVENUE 5.853.848. 00 2.702,948. 22 3.150,899. 78 4.873,363 .33 2,471,842. 69 2,401,520. 64 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 111.940 .00 109.686 .72 2,253 .28 102,652 .11 102.297 .91 354 .20 TRAFFIC SIGNALS & STREET LTG 306,670 .00 112,352 .35 194,317 .65 259,283 .22 152,808 .82 106,474 .40 DISASTER PREPAREDNESS FIRE SERVICES 374,014 .00 188,920 .52 185,093 .48 287,483 .00 147,500 .85 139.982 .15 ACTIVITY TOTAL 792,624 .00 410,959 .59 381,664 .41 649.418 .33 402,607 .58 246.810 .75 TRANSPORTATION: STREET MAINTENANCE 387.651 .00 189,971 .30 197,679 .70 271,408. 11 146.265 .65 125,142 .46 STREET LANDSCAPE MAINTENANCE 6,407. 67 6,407 .67 ACTIVITY TOTAL 387,651 .00 189.971 .30 197,679 .70 277,815. 78 146,265 .65 131,550 .13 HEALTH & WELFARE: WASTE MANAGEMENT 1.826,701 .00 844,345 .97 982,355 .03 1,602,667. 69 817,309 .97 785,357 .72 SOCIAL SERVICES 59,708 .00 50,788 .67 8,919 .33 52.944. 65 40.204 .07 12.740 .58 HOUSING PROGRAMS ACTIVITY TOTAL 1.886.409. 00 895,134 .64 991,274 .36 1,655,612. 34 857.514 .04 798.098 .30 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 173.196 .04 56.394. 96 61,729. 05 61,729. 05 STREET CONSTRUCTION/IMPROVEMENT 3.381,533. 00 700,094. 86 2,681,438. 14 1,998.211. 85 824.985. 54 1,173,226. 31 ACTIVITY TOTAL 3,611,124. 00 873.290 .90 2,737,833. 10 2,070,866. 90 824,985. 54 1.245,881. 36 T 0 T A L EXPENDITURES 6.683.808. 00 2.375.356. 43 4.308.451. 57 4.659.713. 35 2.233.844. 81 2,425.868. 54 EXCESS REVENUE (EXPENDITURES) (847.960. 00) 327.591. 79 (1.175.551. 79) 213.649. 98 237,997. 88 (24.347. 90) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 77,527. 77 52.883. 57 24,644. 20 REVENUES OVER (UNDER) EXPENDITURES (847,960. 00) 327.591. 79 (1.175.551. 79) 136,722. 21 185.114. 31 (48.992. 10) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 03/31/2009 SPECIAL ASSESSMENT FUNDS CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE quiz.. PRIOR Y.T.D. VARIANCE 831,987. 00 488,473 .40 343.513 .60 797,519 .80 483.681 .34 313,838.46 22,931. 00 14,710 .57 8,220 .43 26.739. 60 15,276 .71 11,462.89 5,000. 00 5.011 .65 (11. 65) 578. 00 578. 00 859.918. 00 508.195 .62 351,722. 38 824,837. 40 499.536. 05 325,301.35 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 362,960.00 208.955.13 154,004.87 ACTIVITY TOTAL 362,960.00 208.955.13 154.004.87 TRANSPORTATION PUBLIC WORKS STREET TREE MAINTENANCE 40.430 .00 STREET LANDSCAPE MAINTENANCE 410.969 .00 ACTIVITY TOTAL 451,399 .00 COMMUNITY DEVELOPMENT ENGINEERING 16,135. 00 ACTIVITY TOTAL 16,135. 00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRUMNT ACTIVITY TOTAL T O T A L EXPENDITURES 830.494. 00 EXCESS REVENUE (EXPENDITURES) 29,424. 00 REVENUES OVER (UNDER) EXPENDITURES 29,424. 00 315.699.72 200,381.83 115,317.89 315,699.72 200,381.83 115.317.89 6,626. 33 33,803 .67 72,355. 91 39,318 .95 33.036 .96 203.613. 37 207,355 .63 352,276. 33 184,348 .56 167,927 .77 210,239. 70 241,159 .30 424,632. 24 223,667 .51 200,964 .73 12,181. 30 3,953 .70 16,032. 94 12,282 .94 3.150 .00 12,181. 30 3.953 .70 16,032. 94 12,282 .94 3,750 .00 431,376. 13 399,117 .87 756,364 .90 436.332. 28 320,032. 62 76.819. 49 (47,395 .49) 68.472 .50 63.203. 77 5.268. 73 76,819. 49 (47,395. 49) 68.472. 50 63.203. 77 5.268. 73 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 03/31/2009 ********REVENUE******** USES OF MONEY & PROPERTY INVESTMENT INTEREST LOAN REPAYMENT-PRINCIPAL LOAN REPAYMENT-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: *******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 CAPITAL IMPROVEMENT FUNDS CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ~~ (~ PRIOR Y.T.D. VARIANCE 1,427,074.00 992.230.91 434,843.09 1,749.574.46 1,144.382.26 605.192.20 750.000.00 (750,000.00) 1,500,000.00 1,500,000.00 90.000.00 90.000.00 8,842,750.00 889,923.23 7,952,826.77 18,353.827.13 15,741.875.64 2,611.951.49 10,269.824.00 2.632,154.14 7,637,669.86 21,693,401.59 18,476,257.90 3,217.143.69 180.373.31 189,900 .00 41,604. 53 148,295 .47 156.534 .86 189.900 .00 41,604. 53 148,295 .47 336.908. 17 3,942.094. 00 798.520. 97 3,143,573. 03 1,007,526. 67 3.942,094. 00 798.520. 97 3.143,573. 03 1,007,526. 67 180,373.31 40,751.13 115,783.73 40.751.13 296.157.04 713.657.04 293.869.63 713,657.04 293.869.63 ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 150.896 .00 13.432 .00 137,464 .00 29.278 .01 29.278. 01 COMMUNITY IMPROVEMENTS 250.000 .00 5.285 .60 244,714 .40 PARKS 7,811.302 .00 3.407,854 .59 4.403,447 .41 4.509.205 .57 1.188.608 .82 3.320.596. 75 STREET CONSTRUCTION/IMPROVEMENT 19.222.467 .00 8.559.428 .86 10,663,038 .14 8,762.562 .03 6.898,806 .04 1,863,755. 99 ACTIVITY TOTAL 27,434.665 .00 11.986.001. 05 15.448.663 .95 13,407,852 .01 8,087,414 .86 5,320.437. 15 T 0 T A L EXPENDITURES 31,574,659 .00 12,829.826. 55 18.744,832 .45 14.645.480. 45 8.841.823 .03 5.803,657. 42 EXCESS REVENUE (EXPENDITURES) (21,304,835 .00) (10.197,672. 41) (11,107.162 .59) 7,047.921. 14 9.634,434 .87 (2,586.513. 73) TRANSFER IN FROM OTHER FUNDS 6,600. 00 6.600. 00 TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES(21.304,835.00)(10.197,672.41)(11.107,162.59) 7.054,521.14 9.634,434.87 (2.579,913.73) ********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 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 03/31/2009 TRUST/AGENCY FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR f ~ ~ R PRIOR Y.T.D. VARIANCE 142,957.42 (142.957.42) 202.985.34 117,040.38 85,944.96 (1,495,908.47) 1,495.908.47 (201,809.72) (97.672.21) (104,137.51) (952,184.41) 952,184.41 517.841.22 277,756.84 240.084.38 233,253.28 (233.253.28) 236,480.04 84.591.28 151,888.76 428,881.16 (428,881.16) 446,924.16 232.552.71 214.371.45 428,881 .16 (428.881. 16) 446,924 .16 232,552. 71 214,371 .45 (1.381,065 .57) 1,381,065. 57 70,917 .06 45.204. 13 25.712. 93 (1,381,065 .57) 1,381,065. 57 70,917 .06 45.204. 13 25,712. 93 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 03/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: a~~rz PRIOR Y.T.D. VARIANCE 260.403 .00 177.573 .56 82,829. 44 286.586 .87 197,037 .16 89,549. 71 1.125,184 .00 1.452.687 .74 (327,503. 74) 1,968,529 .47 1,458,517 .75 510.011. 72 36.000 .00 205.162 .64 (169,162. 64) 5.259.344 .46 175,066 .51 5,084.277. 95 1.421,587 .00 1,835.423 .94 (413.836. 94) 7,514,460 .80 1,830.621 .42 5.683,839. 38 3,839,554.00 1,574.340.16 2,265,213.84 3,249.414.38 779,304.89 2,470.109.49 3,839,554.00 1,574,340.16 2,265,213.84 3,249,414.38 779,304.89 2.470,109.49 T 0 T A L EXPENDITURES 3.839,554.00 1,574.340.16 2.265,213.84 3.249,414.38 779,304.89 2,470.109.49 EXCESS REVENUE (EXPENDITURES) (2,417.967.00) 261.083.78 (2,679,050.78) 4,265.046.42 1,051,316.53 3.213.729.89 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (2,417,967.00) 261,083.78 (2.679,050.78) 4,265,046.42 1,051,316.53 3.213.729.89