Loading...
HomeMy WebLinkAbout4.10 Financial Reports FY 07-08o~,DU~~r~ CITY CLERK X11 ~ File # ^©© 0^-~^ -~-~ 8~ AGENDA STATEMENT ~~ ~ CITY COUNCIL MEETING DATE: November 18, 2008 .C',~Tt,.~~-,~1~ SUBJECT: Financial Reports for Fiscal Year 2007-2008 Report Prepared by: Paul S. Rankin, Administrative Services Director and Vivian Gong, Finance Manager ATTACHMENTS: 1. Revenues and Budget Comparison (Period Ending 06/30/08) 2. Expenditures and Budget Comparison (Period Ending 06/30/08) 3. Audited Financial Statements (Period Ending 06/30/08) RECOMMENDATION: Receive the reports as authorized under section 41004 of the California Government Code. FINANCIAL STATEM NT: See reports. DESCRIPTION: This item provides the report on the financial statements for the Fiscal Year Ended June 30, 2008. Consistent with prior reports, the financial analysis in this report focused on the General Fund, which is the most significant portion of City revenues and expenditures. Staff is in the process of completing the Comprehensive Annual Financial Report. As part of that report Staff will provide a full analysis of the change in fund balances. The focus of this report will be on the year-end revenue and expenditure accounts. Analysis of June Revenue and Expenditure Reports The June reports represent the reporting of revenues and expenditures for the Fiscal Year ending June 30, 2008. The financial Statements were audited by Caporicci and Larson, Certified Public Accountants, the City's independent auditors. Final accruals have been made for all revenues and expenditures that may have been July or August transactions, however, they related to Fiscal Year 2007/2008 activities. Given that there is a full year of data available more detail is provided regarding deviations that are significant. General Fund Revenues Total General Fund Revenues collected through June 2008 were $54.6 million compared to $54.2 million recorded in fiscal year 2006/2007. As will be explained in the detailed explanation about interest revenue, approximately $1.5 million of the total revenue presented in the audited financial statements are an unrealized gain on investments. Through June 2008, the City had collected approximately 103% of the total budgeted General Fund Revenues, which includes the unrealized interest income. Significant General Fund Estimated Revenue Variances The year end revenues in the General Fund exceeded the budget estimates by 3% or $ 1,609,226, of which $1,508,906 are from unrealized gain on investment. Excluding the unrealized gain on investment component, total revenues collection exceeded budget estimates by only 0.2% or $100,320. These results were a combination of deviations from both over and under the budget estimate. The following section describes the fluctuation by major revenue type: COPIES TO: Page 1 of 4 ~ ~O G:\Monthly Financials\FY 07-08\Jun2008VER PSR.doc ITEM NU. n • Property Taxes: -$95,700 (0.4% under budget estimate) The Property Taxes revenues are below budget at less than a half percent due to delinquencies. • Sales Taxes: -$164,300 (1% under budget estimate) Although revenue recorded this fiscal year totaled $14,225,661, ($199,792 more than total collections in the prior fiscal year) the slow-down in automobile and other retail sales impacted the year end results. • Real Property Transfer Tax: - $46,800 (9% under budget estimate) The Real Property Transfer Tax revenue trended below budget the entire year as a result of lower than expected sales activities from both the residential and non-residential properties. The collections of $493,175 were approximately $103,358 less than the revenue collected in Fiscal Year 2006/2007. • Transient Occupancy Taxes: + $14,400 (2% over budget estimate) Transient Occupancy Taxes are higher than budgeted by a minimal amount. The collections of $789,397 for Fiscal Year 2007/2008 were actually approximately $11,376 less than the amount collected for Fiscal Year 2006/2007. • Franchise Taxes: +$126,300 (6% over budget estimate) As reported in previous monthly reports, Gas, Electric, Waste, and Cable TV franchise taxes have trended above the level collected in prior year by $110,600 due to higher consumption. • Licenses and Permits: +220,000 (14% over budget estimate) This revenue category comprises of Building Permits, Animal Licenses, Encroachment Permits, Construction and Demolition Permits, Business Licenses, and Fire Permits. Building Permits represent a majority (84 percent) of the budget in this revenue category. Building Permit fees collected exceeded the revised budget by approximately $191,000. The encroachment permit fees exceeded the budget amount by approximately $24,898 as a result of additional utility work including AT&T Project Lightspeed. The final June 2008 collections for the License & Permit category were less than the Fiscal Year 2006/07 results by approximately $787,424. This reflects the slow-down in building related permits and development activity. • Interest Revenue: +$2,032,290 (96% over budget estimate -prior to adjustment for unrealized gain) Attachment 1 shows a total of $4,464,185 combined Interest and Facility Rental revenue (See next section for discussion of rental revenue). This is distorted by mandatory adjustments to the Interest Revenue account, in order to comply with governmental accounting rules. At year end the City must reflect the market value of its investments. On June 30, 2008 the fair market value of the investments was more than the book value resulting in an unrealized gain of $1,508,906. On the attached financial statements this amount was recorded as interest revenue. In the more detailed records a separate line item is used to segregate this entry. The final balance sheet will contain a reserve of this amount since it does not represent funds that can be expended. The City holds its investments until maturity and no gain was realized. If the revenue were adjusted for this accounting entry the total interest revenue would be $2,620,128 or $523,384 more than the Budget. The City's overall rate of return on its investments and balance available for investment was higher than assumed in the budget estimate. Page 2 of 4 • Rental Revenues: +$ 44,224 (15% over budget estimate) Rental of the City Fields and facilities were higher than was assumed in the budget. This was partially impacted by a timing difference in the payment of Field Rental Fees. The final 2007/2008 revenues for rentals were $131,910 more than in the prior fiscal year. • Intergovernmental: +$29,419 (3% over budget estimate) This category of revenue exceeded the budget primarily due to the timing of receipt for the SB-90 Mandated Cost reimbursements received from the State for prior years claims (+$13,716). It also included $4,862 one-time operating grant from the County to support the Heritage Center and slight increases in the collections of the Vehicle License Fees $7,245 and Home Owner Property Tax Relief revenue of $3,596. • Charges for Services: + $220,000 (4% over budget estimate) Consistent with previous monthly reports, a significant portion of the increases ($175,000) reflects a higher than expected Park & Community Services fees for aquatics, sports, preschool center and recreation classes. There was also an increase in Zoning and Subdivision fees ($299,830) which were offset by the decrease in Plan Check and Inspection fees ($258,330). • Fines and Forfeitures: +$13,500 (9.5% over budget estimate) Court Fines decreased by 26% or $17,700 which was offset by an increase in Parking Fines and one-time penalties associated late payments of taxes and permits penalties. The total change in this category compared to the prior year was an increase of $16,285. • Other Revenues: - $784,000 (48% under budget estimate) The primary variance in this revenue category was primary due to delays associated with Capital Projects. The I-580/Fallon Road Interchange project has not begun construction, and therefore reimbursements included in the Budget of $934,942 will be received in a future year after construction begins. This category does include approximately $190,600 of Community Benefit Payments made in accordance with Development Agreements. These were not included in the Budget figure. This category can include one-time revenues creating fluctuations when ayear-to- year comparison is made. Therefore a comparison to the prior year is not provided. Significant General Fund Estimated Operating Expenditures Variances The City's General Fund operating expenditures, excluding funds programmed for the Capital Projects, were approximately $2,254,200 or 5% less than the budget estimate. The following breakdown examines major areas of savings by Program: • General Government: -$706,521 (12% under budget estimate) Several factors contributed to budget savings in this category including a savings of salaries and benefits as a result of a vacancies in the City Clerk position and the Network System Coordinator for part of the year; lower than budgeted group insurance costs; Building Management incurred costs below budget primarily due to less time required for facility set up; lighting maintenance savings and savings in general building improvement projects; Savings in the Insurance/Risk Management program occurred in both the insurance premiums as well as the amount of claims paid; and approximately $25,370 remained in the Budgeted contingent reserve at the close of the Fiscal Year. Page 3 of 4 • Public Safety: - $87,469 (Less than one-half of 1 percent under budget estimate) The savings in this category were primarily due to the lower than budgeted contract costs associated with Fire operations and Animal Control Shelter and Field Services. • Transportation: - $222,300 (10% under budget estimate) The savings in this category was primarily due to the lower than budgeted salaries and benefits cost associated with personnel vacancies. Other savings resulted in the Street Maintenance drainage maintenance activity and the contract Street Sweeping services. • Culture and Community Services: - $324,500 (4% under budget estimate) There were several variances which resulted in the total expenditures being less than the Budget. These included: Library Service costs were approximately $33,875 less than budget; Park Maintenance costs were approximately $73,100 less than budget; and overall the various divisions within Parks and Community Services Department also experienced lower costs primarily related to staffing. Approximately $203,939 of the savings in this category were from Salaries and Benefits. • Community Development: - $912,600 (11 % under budget estimate) Savings in this category occurred due to: lower than expected expenditures for Salaries and Benefits for the Planning, Building, and Engineering division as a result of position vacancies; reduced Planning contract services in for the Downtown Specific Plan; reduced contract Building Services due to a slow down in the amount of new construction activity and applications; and lower than expected contract expenditures in Engineering for development related services. General Fund Capital Project Expenditure Variances The City's General Fund Capital Project Expenditures were approximately $5,123,000 or 44% less than the amount budgeted. This variance represents a combination of timing differences on the completion of these capital projects such as the Accounting/Permit System Replacement and the Heritage Park Acquisition. Also some of the completed projects incurred expenditures below the. project budget. Some of the unspent funds have already been re-appropriated and accounted for in the adopted Fiscal Year 2008/2009 budget or in the Budget Carry-Over item presented to the City Council on October 21,2008. Finalization of Comprehensive Annual Financial Report and Year End Fund Balance Designations for the General Fund In preparing the Fiscal Year 2008/2009 Budget, Staff presented to the City Council projected results from the 2007/2008 Fiscal Year. These projections will be updated with the final Audit Report and presented at a future meeting. The analysis will need to account for the final audited Financial Statements; the General Fund surplus; and a reduction of any carry-over of funds already authorized. The presentation of year-end changes in fund balance will be reported as part of the Comprehensive Annual Financial Report, which incorporates the annual Audit of the Financial Statements. RECOMMENDATION It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. Page 4 of 4 1 ~3 City of Dublin 2007-2008 YTD Revenues and Budget Comparison Total General Fund Revenues 100% 100 % 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 Revenues 100% 100% 99% 100% 1% 100% 102 _ 100% 1o~g~°r° 114% _ _~ 100% 103 100% 104% 00% 109% 100% ~3t~: ~_ ; <t ~_ __ - --100% ^ FY 2007/08 FY 2006/07 0% 30% 60% 90% 120% 150% 100% of Year Complete FY 2007/08 FY 2007108 % of FY 2006/07 % of Total for Budget YTD Actual Budget YTD Actual FY 2006/07 Property Taxes 22,194,200 22,098,429 100% 20,146,743 100% Sales Taxes 14,390,000 14,225,661 99% 14,025,869 100% Real Property Transfer Tax 540,000 493,175 91% 596,533 100% Transient Occupancy Taxes 775,000 789,397 102% 800,773 100% Franchise Taxes 2,095,635 2,221,930 106% 2,111,281 100% Licenses and Permits 1,564,645 1,784,644 114% 2,572,068 100% Interest and Rentals 2,387,671 4,464,185 187% 3,778,378 100% Intergovernmental 1,049,669 1,079,088 103% 1,149,759 100% Charges for Services 6,262,056 6,482,093 104% 8,015,065 100% Fines and Forfeitures 143,000 156,520 109% 140,235 100% Other Revenues 1,651,012 866,992 53% 928,704 100% Total General Fund Revenues 53,052,888 54,662,114 103% 54,265,408 100% Oate Printetl. t v612008 10.55 AM ~~~~'~p (~I~~~~ ATTACHMENT1 a ~-_L3 City of Dublin 2007-2008 YTD Expenses and Budget Comparison For the Period Ending June 30, 2008 Total General Fund 89°10 Expenses _ _ _..,100% 88% General Government o ~ 100 /o 100 % Police ° 100 /o 1000% Fire 100 /o _ ~ FY 2007/08 FY 2006/07 l 91% Other Public Safety _ 100% 90% Transportation 100% 99% Health and Welfare ° 100 /o Culture & Community 96% Services _ _ _ _ __ 100% Community 89%_ Development 100% CapitalImprov. 56% _ Projects 100% 0% 20% 40% 60% 80% 100% 120% 100% of Year Complete 2007/08 2007/08 % of FY 2006/07 % of Total for Budget YTD Actual Budget YTD Actual FY 2006107 General Government 5,959,860 5,253,339 88% 5,480,365 100% Police 12,720,344 12,720,343 100% 11,662,394 100% Fire .9,468,930 9,430,762 100% 9,178,765 100% Other Public Safety 563,028 513,728 91% 433,846 100% Transportation 2,239,419 2,017,084 90% 2,003,668 100% Health and Welfare 52,004 51,304 99% 40,555 100% Culture and Community Services 7,529,844 7,205,293 96% 6,874,595 100% Community Development 8,218,211 7,305,545 89% 7,698,894 100% Capital Improvement Projects 9,158,490 5,123,088 56% 3,400,139 100% Total General Fund Expenses 55,910,130 49,620,486 89% 46,773,221 100% General Fund Operating Expenses 46,751,640 44,497,398 95% 43,373,082 100% oaroPn~~,a.nranooewsenm ATTACHMENT 2 313 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDING JUNE 30, 2008 (FINAL AFTER AUDIT) Prepared by The Finance Department November 6, ?008 ATTACHMENT 3 y~ 13 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Jun2008 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUNDS FUNDS FUND ASSETS CASH (58,748.554) 4,618,112 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT•COST 124,909,737 RECEIVABLES: TAXES ACCOUNTS 3.227.389 524,887 INTEREST 955.006 ASSESSMENTS DUE FROM OTHERS 5.206,269 INVENTORY AT COST PREPAID ITEMS 37,583 FIXED ASSETS LOANS RECEIVABLE AMOUNT TO BE PROVIDED TOTAL ASSETS 75,587,430 5,142,999 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (479,255) DEPOSITS FOR A61600 FEES DEPOSITS OTHERS (745,262) PAYABLES: ACCOUNTS (10.426,091) (569.797) INTEREST PAYROLL (271,617) DUE TO OTHERS (105,176) DEFERRED REVENUE (252,896) DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (12,175,121) (674,973) FUND BALANCES (63,412.309) (4,468.026) TOTAL FUND E (63,412,309) (4,468.026) TOTAL LIABILITIES/EQUITY (75,587,430) (5,142,999) TOTALS ---MEMORANDUM ONLY--- CURRENT PRIOR 673,857 47,000.161 196.883 (6,259,540) (9,947,442) 329,286 329.286 171,889 158,658 158,658 1.692,262 124,909,737 113.400,818 6,749 62.301 3.821,326 4,439,088 378 955,384 1,094,719 5.206,269 5.458.936 37,583 9,306 5,346,702 5.346.702 6.723.334 792,500 792,500 943,500 680,606 53,191,889 1,319,047 135,921,971 123,986.408 (11,808) (447,060) (74.255) (2.297,208) (1,837.021) (5.970.768) (74,255) (10,563.866) (606,351) (42,628,023) (606.351) (42,628.023) (491,063) (850,699) (1,010.229) (1,192,322) (592.969) (151,000) (13.518,351) (11,885.694) (271,617) (218,942) (1,942,197) (2.495,525) (6,223.664) (2,603,370) (910,000) (910,000) (1,061,000) (1,061.000) (24,549,215) (20.718.428) (258,047)(111,372.756)(103.267,980) (258.047)(111,372,756)(103,267,980) (680,606) (53.191,889) (1,319.047)(135.921.971)(123,986.408) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Jun2008 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG SERVICE FUND GROUP OF TERM DEBT FUNDS ACCOUNTS ACCOUNT GROUP ASSETS CASH 7,306.101 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS 11,622 INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 51,306,938 359,885,309 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 71,485,183 TOTAL ASSETS 58.624,662 359,885,309 71,485,183 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS (23,261) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (117.540) (71.485.183) TOTAL LIABILITIES (140.801) (71,485,183) FUND BALANCES (58.483,861) (359.885.309) TOTAL FUND E (58.483,861) (359,885,309) TOTAL LIABILITIES/EQUITY (58,624,662) (359.885.309) (71,485,183) 5 ~-P 13 ~1 TOTALS ---MEMORANDUM--- CURRENT PRIOR 7,306,101 6,486.207 11,622 2,310 3.966 411,192.247 399,631,407 71,485,183 61,719,086 489.995,154 467,842,976 (23.261) (27,652) (71.602,723) (61,948.543) (71,625,985) (61.976,195) (418.369.170)(405,866.781) (418.369,170)(405,866,781) (489.995,154)(467,842,976) THE CITY OF DUBLIN STATEMENT SHOWING ~ Q.r I REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 06/30/2008 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES 22,194,200 .00 22,098,429. 20 95,770 .80 20,146,742 .78 20,146,742. 78 SALES TAX 14,390,000 .00 14,225,660. 61 164,339 .39 14,025,868 .73 14,025,868. 73 REAL PROPERTY TRANSFER TAX 540.000 .00 493.175. 01 46,824 .99 596,532 .87 596,532. 87 HOTEL TRANSIENT OCCUPANCY TAX 775,000 .00 789,397. 41 (14,397 .41) 800,772 .57 800.772. 57 FRANCHISE TAXES 2,095,635 .00 2,221,929. 73 (126,294 .73) 2,111,281 .26 2,111,281. 26 LICENSES & PERMITS 1,564.645 .00 1,784,643. 77 (219.998 .77) 2,572,067 .54 2,572,067. 54 FINES & FORFEITURES 143,000 .00 156,520. 17 (13,520 .17) 140.234 .79 140,234. 79 USE/MONEY & PROP-INTEREST 2,096,744 .00 4,129.033. 69 (2,032,289 .69) 3,575,137 .21 3,575,137. 21 USE/MONEY & PROP-RENTALS 290,927 .00 335,151. 45 (44.224 .45) 203,240 .52 203.240. 52 INTERGOVERNMENTAL 1,049,669 .00 1,079,087. 97 (29,418 .97) 1,149,759 .30 1,149,759. 30 CHARGES FOR SERVICES 6,262.056 .00 6.482,093. 07 (220,037 .07) 8,015.064 .77 8.015.064. 77 OTHER SOURCES OF REVENUE 1,651,012 .00 866,991. 80 784,020 .20 928,704 .12 928,704. 12 TOTAL REVENUE 53.052,888 .00 54,662,113. 88 (1,609.225 .88) 54,265,406 .46 54,265.406. 46 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES CITY COUNCIL 304,891 .00 262,987 .19 41,903 .81 320,924 .20 320,924 .20 CITY MANAGER 1,128,643 .00 1,052,588 .57 76,054 .43 1,042,480 .01 1,042,480 .01 CENTRAL SERVICES 573,400. 00 495,825 .93 77.574 .07 438,786 .38 438,786 .38 CITY ATTORNEY 733,483 .00 733.479 .11 3 .89 867,874 .77 867,874 .77 ADMIN SERVICES 1,844,459. 00 1,600,978. 71 243,480 .29 1,593.027 .81 1,593,027 .81 BUILDING MANAGEMENT 796.873. 00 699,948. 45 96,924 .55 707,316 .31 707.316 .31 INSURANCE COST CENTER 538.541. 00 386,652. 28 151,888 .72 474,542 .39 474,542 .39 ELECTIONS COST CENTER 2.500. 00 1.124. 24 1,375 .76 25,554 .79 25,554 .79 NON-DEPARTMENTAL 37.070. 00 19,754. 72 17,315 .28 9.858 .11 9,858 .11 ACTIVITY TOTAL 5,959.860. 00 5,253,339. 20 706.520 .80 5,480,364 .77 5,480.364 .77 PUBLIC SAFETY POLICE 12.720,344. 00 12.720.342. 53 1 .47 11.662,394 .30 11,662,394 .30 CROSSING GUARDS 98,648. 00 97.662. 78 985 .22 86.639 .21 86.639 .21 ANIMAL CONTROL 351,192. 00 311,991. 99 39,200 .01 251,956 .53 251,956 .53 TRAFFIC SIGNALS & STREET LIGHTIN 13,300. 00 12,023. 37 1,276 .63 15,424 .08 15.424 .08 DISASTER PREPAREDNESS 99,888. 00 92,050. 23 7,837. 77 79,826 .64 79.826 .64 FIRE SERVICES 9.468,930. 00 9.430.762. 41 38,167. 59 9.178,765 .31 9,178.765 .31 ACTIVITY TOTAL 22,752.302. 00 22,664.833. 31 87,468. 69 21.275,006 .07 21,275.006 .07 TRANSPORTATION PUBLIC WORKS 1,094,762. 00 986,198. 88 108,563. 12 907,511. 91 907,511. 91 STREET MAINTENANCE 33,147. 00 462. 72 32,684. 28 13,221. 64 13.221. 64 STREET SWEEPING 138,000. 00 134,374. 05 3.625. 95 139,992. 31 139.992. 31 STREET TREE MAINTENANCE 106,917. 00 78,680. 52 28,236. 48 131,391. 84 131,391. 84 STREET LANDSCAPING MAINTENAN 866,593. 00 817,367. 33 49,225. 67 811,550. 20 811.550. 20 ACTIVITY TOTAL 2.239,419. 00 2,017,083. 50 222.335. 50 2,003.667. 90 2,003,667. 90 HEALTH & WELFARE WASTE MANAGEMENT 8,091. 00 7,390. 58 700. 42 22,055. 21 22,055. 21 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 06/30/2008 G EN ERAL R EVENUE FUND CURRENT CURREN T PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL Y EAR Y.T.D . CHILD CARE 18,500 .00 18,500 .00 18,500 .00 18,500 .00 SOCIAL SERVICES 25,413 .00 25,413 .00 HOUSING PROGRAMS ACTIVTTY TOTAL 52,004 .00 51,303 .58 700 .42 40,555 .21 40,555 .21 CULTURE & LEISURE SERVICES LIBRARY SERVICES- 836,571 .00 802.695 .43 33,875. 57 809,628 .89 809.628 .89 CULTURAL ACTIVITIES 239,530 .00 217,296 .55 22,233. 45 251,944 .51 251,944 .51 HERITAGE CENTER 238,752 .00 234,222 .38 4,529. 62 181,827 .65 181,827 .65 DUBLIN CEMETERY 48.458 .00 36.692 .31 11,765. 69 43,942 .65 43.942 .65 PARK MAINTENANCE 2,016,692 .00 1,943.588 .26 73,103. 74 1,808,688 .78 1,808.688 .78 COMMUNITY TV 127,980 .00 117,348 .36 10.631. 64 128,881 .00 128,881 .00 RECREATION ADMIN 759,339 .00 724,768 .91 34.570. 09 702,189 .94 702,189 .94 PLAYGROUNDS 320,073 .00 292,470 .16 27,602. 84 260,228 .97 260,228. 97 SHANNON CENTER 286,982 .00 276.775 .62 10,206. 38 342,407 .56 342,407. 56 PRESCHOOL 115.643 .00 108,501 .41 7,141. 59 105,844 .87 105,844. 87 TEENS PROGRAM 146,164 .00 124,796 .04 21,367. 96 135,910 .40 135,910. 40 ADULT SPORTS 183,056 .00 160.687 .23 22,368. 77 106.532 .29 106.532. 29 YOUTH SPORTS 204,177 .00 222,307 .17 (18,130. 17) 174,520 .06 174,520. 06 COMMUNITY GYM 46,187 .00 43.936. 22 2,250. 78 44,662 .71 44,662. 71 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 403,471 .00 403,148. 41 322. 59 354,952 .30 354,952. 30 SENIOR CENTER 549,653 .00 541,942. 56 7,710. 44 472.926 .09 472,926. 09 RECREATION INSTRUCTION 209,545 .00 183,565. 98 25.979. 02 198;529 .01 198.529. 01 AQUATICS 467,488 .00 458,574. 88 8.913. 12 445,981 .03 445,981. 03 PARKS/FACILITIES MANAGEMENT 330,083 .00 311,975. 20 18,107. 80 304,996 .60 304,996. 60 ACTIVITY TOTAL 7,529.844 .00 7,205,293. 08 324,550. 92 6.874,595 .31 6,874,595. 31 COMMUNITY DEVELOPMENT PLANNING 2,893,306 .00 2,479.866. 71 413.439. 29 2,152,189. 29 2,152,189. 29 BUILDING SAFETY 2,708,274 .00 2,515.366. 57 192,907. 43 2,886.668. 83 2,886,668. 83 ENGINEERING 2,321,911 .00 2,054,482. 25 267.428. 75 2,407,540. 23 2,407,540. 23 ECONOMIC DEVELOPMENT 294,720 .00 255,829. 71 38,890. 29 252.495. 57 252,495. 57 ACTIVITY TOTAL 8.218,211 .00 7,305.545. 24 912.665. 76 7,698,893. 92 7,698,893. 92 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1,564,118. 00 384,619. 81 1.179,498. 19 377,025. 76 377,025. 76 COMMUNITY IMPROVEMENTS 329,568. 00 218.057. 69 111,510. 31 95,671. 93 95,671. 93 PARKS 6.120,360. 00 4,249,293. 53 1,871.066. 47 2.619,196. 45 2,619,196. 45 STREET CONSTRC/IMPROVEMENTS 1,144,444. 00 271,116. 67 873,327. 33 308,244. 43 308,244. 43 ACTIVITY TOTAL 9,158,490. 00 5.123.087. 70 4.035.402. 30 3.400,138. 57 3,400.138. 57 TOTAL EXPENDITURES 55,910,130. 00 49.620,485. 61 6.289,644. 39 46.773,221. 75 46,773,221. 75 EXCESS REVENUE (EXPENDITURES) (2,857,242. 00) 5.041,628. 27 (7,898.870. 27) 7,492,184. 71 7.492,184. 71 TRANSFERS IN FROM OTHER FUNDS 70.927. 77 (70.927. 77) 59,196. 81 59,196. 81 TRANSFERS OUT FROM OTHER FUNDS (23,505. 65) (23,505. 65) REVENUES OVER(UNDER) EXPENDITURES (2,857,242. 00) 5,112,556. 04 (7,969,798. 04) 7,527,875. 87 7,527.875. 87 -~ ~ i3 VARIANCE THE CITY OF DUBLIN STATEMENT SHOWING ~ 1 3 REVENUES VERSUS EXPENDITURES ( 1 FOR THE PERIOD 07/01/2007 THROUGH 06/30/2008 SPECIAL REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES 125,760. 00 130,609 .95 (4,849 .95) 119,472 .73 119,472 .73 SALES TAX/OTHER TAXES 460,862. 00 458,429 .22 2,432 .78 433,043 .17 433,043 .17 FINES & FORFEITURES 195,000. 00 203,975 .65 (8.975 .65) 201,862 .59 201,862 .59 USES/MONEY & PROPERTY 216.249. 00 196,387 .20 19,861 .80 194.816 .32 194.816 .32 INTERGOVERNMENTAL FROM STATE 1,972,487. 00 1,639,303 .16 333,183 .84 1.174,710 .84 1,174,710 :84 INTERGOVERNMENTAL FROM COUNTY 397,023. 00 359,383 .45 37,639 .55 376.594 .90 376,594 .90 INTERGOVERNMENTAL FROM FEDERAL 459.471. 00 353,538 .54 105.932. 46 144,868. 47 144,868 .47 CHARGES FOR SERVICES 1,513,762. 00 1,497,236 .92 16,525. 08 1,430,805. 72 1,430,805 .72 OTHER SOURCES OF REVENUE 9.000. 00 34,499 .24 (25,499. 24) 25,467. 40 25,467 .40 TOTAL REVENUE 5.349.614. 00 4,873,363 .33 476,250. 67 4,101,642. 14 4,101,642 .14 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 105.164 .00 102,652. .11 2,511 .89 101,780 .53 101.780 .53 TRAFFIC SIGNALS & STREET LTG 279,525 .00 259,283 .22 20,241 .78 249.275 .06 249,275 .06 DISASTER PREPAREDNESS FIRE SERVICES 287,483 .00 287,483 .00 196,755 .84 196.755 .84 ACTIVITY TOTAL 672,172 .00 649.418 .33 22,753 .67 547,811 .43 547;811 .43 TRANSPORTATION: STREET MAINTENANCE 398,986 .00 271,408 .11 127,577. 89 305,088 .60 305,088 .60 STREET LANDSCAPE MAINTENANCE 6,408 .00 6,407 .67 . 33 7,563 .43 7,563 .43 ACTIVITY TOTAL 405.394 .00 277,815 .78 127,578. 22 312,652 .03 312,652 .03 HEALTH & WELFARE: WASTE MANAGEMENT 1,663.490 .00 1.602,667 .69 60,822. 31 1.525.606 .71 1.525,606. 71 SOCIAL SERVICES 52,945 .00 52,944 .65 . 35 60,035 .35 60,035. 35 HOUSING PROGRAMS ACTIVITY TOTAL 1,716,435 .00 1,655,612 .34 60,822. 66 1.585.642 .06 1.585,642. 06 COMMUNITY DEVELOPMENT: ENGINEERING 6,000 .00 6,000. 00 6.000 .00 6.000. 00 ACTIVITY TOTAL 6,000 .00 6,000. 00 6.000 .00 6,000. 00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 10,926 .00 10,926. 00 COMMUNITY PROJECTS 17,580. 62 17,580. 62 PARKS 109,822 .00 61,729. 05 48.092. 95 132,238. 71 132,238. 71 STREET CONSTRUCTION/IMPROVEMENT 2.792,534 .00 1,998,211. 85 794.322. 15 726,185. 12 726,185. 12 ACTIVITY TOTAL 2,913,282 .00 2.070,866. 90 842,415. 10 876,004. 45 876.004. 45 T O T A L EXPENDITURES 5,713.283. 00 4,659,713. 35 1,053,569. 65 3,328,109. 97 3.328,109. 97 EXCESS REVENUE (EXPENDITURES) (363,669. 00) 213,649. 98 (577,318. 98) 773,532. 17 773.532. 17 TRANSFER IN FROM OTHER FUNDS (1,097. 00) (1,097. 00) TRANSFERS OUT TO OTHER FUNDS 77,527. 77 (77,527. 77) 27,368. 61 27,368. 61 REVENUES OVER (UNDER) EXPENDITURES (363,669. 00) 136.122. 21 (499,791. 21) 747,260. 56 747,260. 56 ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG ACTIVITY TOTAL TRANSPORTATION PUBLIC WORKS STREET TREE MAINTENANCE STREET LANDSCAPE MAINTENANCE ACTIVITY TOTAL COMMUNITY DEVELOPMENT ENGINEERING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRUMNT ACTIVITY TOTAL 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/2007 THROUGH 06/30/2008 SPECIAL ASSESSMENT FUNDS. CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR 785,567.00 .26,106.00 5,000.00 816,673.00 q a~ 13 PRIOR Y.T.D. VARIANCE 716,143.96 26,363.45 3,219.91 745,727.32 376,400. 00 315,699 .72 60.700. 28 325.491 .81 325,491 .81 376,400. 00 315,699 .72 60,700. 28 325.491 .81 325,491 .81 100. 00 100. 00 1,640 .07 1,640. 07 72,357. 00 72,355 .91 1. 09 39.305 .46 39,305. 46 388,998. 00 352,276. 33 36,721. 67 369,334 .70 369,334. 70 461.455. 00 424,632. 24 36,822. 76 410,280 .23 410.280. 23 15,875. 00 16,032. 94 (157. 94) 10,558 .50 10,558. 50 15,875. 00 16.032. 94 (157. 94) 10,558. 50 10.558. 50 797,519.80 26,739.60 578.00 824,837.40 (11.952.80) (633.60) 4,422.00 (8,164.40) 716,143.96 26,363.45 3.219.91 745,727.32 853,730. 00 756.364 .90 97,365 .10 (37,057. 00) 68,472 .50 (105..529 .50) (37,057. 00) 68,472 .50 (105,529 .50) 746,330.54 (603.22) (603.22) 746,330.54 (603.22) (603.22) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07!01!2007 THROUGH 06/30/2008 ********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 ~~ 13 PRIOR Y.T.D. VARIANCE 1,709,300.00 1,749,574.46 (40,274.46) 2,044,630.85 2,044,630.85 1,500,000.00 (1.500,000.00) 90,000.00 (90,000.00) 17,447,972.00 18,353.827.13 (905,855.13) 8,652,525.77 8.652,525.77 19.157.272.00 21,693,401.59 (2.536.129.59) 10.697.156.62 10,697,156.62 180,373.31 (180,373.31) 78.785.62 78,785.62 158.435.00 156.534.86 1,900.14 59.936.48 59,936.48 158.435.00 336,908.17 (178,473.17) 138.722.10 138.722.10 3,994,884.00 1,007,526.67 2.987,357.33 458,257.23 458,257.23 3.994,884.00 1,007,526.67 2,987,357.33 458.257.23 458,257.23 ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS. GENERAL CIP PROJECTS 195.550. 00 29,278 .01 166,271. 99 24,905. 17 24,905 .17 COMMUNITY IMPROVEMENTS 250.000. 00 250.000. 00 PARKS 8,242.583. 00 4,509,205 .57 3.733,377 .43 7.993.412. 28 7,993.412. 28 STREET CONSTRUCTION/IMPROVEMENT 29.417.820. 00 8,762,562 .03 20.655,257 .97 4.497,678. 86 4,497,678 .86 ACTIVITY TOTAL 38,105.953. 00 13,407.852 .01 24,698.100 .99 12.515,996. 31 12,515,996 .31 T O T A L EXPENDITURES 42.259.272. 00 14,645.480 .45 27,613.791 .55 13.112.975. 64 13.112,975 .64 EXCESS REVENUE (EXPENDITURES) (23,102.000. 00) 7,047,921 .14 (30,149.921 .14) (2.415.819. 02) (2,415,819 .02) TRANSFER IN FROM OTHER FUNDS 6,600 .00 (6,600 .00) 30,105. 65 30,105 .65 TRANSFERS OUT TO OTHER FUNDS 39,525. 20 39,525 .20 REVENUES OVER (UNDER) EXPENDITURES(23,102,000.00) 7,054,521.14 (30.156,521.14) (2,425.238.57) (2.425.238.57) ********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/2007 THROUGH 06/30/2008 TRUST/AGENCY FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR i-~ -3 PRIOR Y.T.D. VARIANCE 202,985.34 (202,985.34) 217,030.10 217,030.10 (201,809.72) 201,809.72 14,825.42 14,825.42 517,841.22 (517,841.22) 5.929.923.59 5.929,923.59 236,480.04 (236,480.04) 231.940.00 231,940.00 446,924.16 (446,924.16) 231.940.00 231,940.00 446.924. 16 (446,924 .16} 231.940. 00 231,940 .00 70,917. 06 (70,917 .06) 5,697,983. 59 5,697.983 .59 70,917. 06 (70,917 .06) 5,697.983. 59 5,697,983 .59 ********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: THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 06/30/2008 INTERNAL SERUICE FUNDS CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR la ~ ~3 PRIOR Y.T.D. VARIANCE 214.192.00 286,586.87 (72,394.87) 477.640.72 477,640.72 1,682,057.00 1.968,529.47 (286.472.47) 1,786,972.00 1,786,972.00 22,800.00 5,259,344.46 (5.236,544.46) 1,475,321.69 1,475,321.69 1,919.049.00 7,514,460.80 (5.595.411.80) 3,739.934.41 3,739,934.41 3.787,454.00 3,249,414.38 538,039.62 11.472,708.13 11,472,708.13 3.787.454.00 3.249,414.38 538,039.62 11,472.708.13 11,472,708.13 T O T A L EXPENDITURES 3.787,454.00 3,249,414.38 538,039.62 11,472.708.13 11,472,708.13 EXCESS REVENUE (EXPENDITURES) (1,868,405.00) 4,265,046.42 (6.133,451.42) (7,732,773.72) (7,732,773.72) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (1,868,405.00) 4,265,046.42 (6.133.451.42) (7,732,773.72) (7,732,773.72) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07!01/2007 THROUGH 06/30/2008 ENTERPRISE FUND ********REVENUES******** USESIMONEY &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 CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ~3 ~3 PRIOR Y.T.D. VARIANCE REVENUES OVER (UNDER) EXPENDITURES