The URL can be used to link to this page

Home My WebLink About4.09 FinalFincialRpt 02-03 CITY CLERK File # ~-~-~~-~~ AGENDA STATEMENT CITY COUNCIL MEETING DATE: January 20, 2004 SUBJECT: Final Financial Report For Fiscal Year 2002-2003 Report Prepared by: Carole A. Perry, Administrative Services Director and Fred W.. Marsh, Finance Manager ATTACHMENTS: 1. YTD Revenues and Budget Comparison 2. YTD Expenses and Budget Comparison 3. Financial Statements for the Month of June 2003 RECOMMENDATION:t~f~eceive the Reports FINANCIAL STATEMENT: See Staff Report. DESCRIPTION: This report provides the final financial statements for Fiscal Year 2002-2003, and incorporates the audited results for the Fiscal Year. A. GENERAL FUND Significant General Fund Revenue Variances In Fiscal Year 2002-2003, the actual revenues in the General Fund exceeded the budget estimate by approximately $1.2 million (3%). The following revenues contributed to the final outcome: Property Taxes ($147,000, or 1 °A over budgeted proiection) The assessed valuation of all residential and non residential properties located within the City limits increased by $583 million (16%) over the prior Fiscal Year, due to the large number of new residential properties added to the tax roll for the first time in Fiscal Year 2002-2003, as well as a significant increase in property values within the area. Sales Taxes ($491,000, or 4% over budgeted projection) Sales taxes increased in comparison to the amount collected in the prior year, primarily due to a slight increase in sales tax collections experienced at the City's major retail outlets, including Hacienda Crossings. Real Proper .ty Transfer Tax ($36,000, or 9% under budgeted proiection) Real Property Transfer Taxes came in somewhat under budget due to lower than expected proceeds from the sale of non residential properties, which resulted in lower transfer taxes collected from these types of properties. Transient Occupancy Taxes ($141,000, or 16% under total budgeted projection) Transient Occupancy TaXes are lower than in the same period in the prior year due to lower than expected occupancy rates resulting from the national events of September 11, 2001, as well as the continued weak economy in the San Francisco Bay Area. COPIES TO: 1~~ ITEM NO. ~ GSAudit~Y 02-03\calf\agenda REV statement preliminary Year End Finan¢ials.do¢ Franchise Taxes ($99,000, or 7% under budgeted proiection) Franchise Taxes are lower than in the same period in the prior year due to the success achieved from the City's new commercial recycling programs, which have reduced the amount of garbage collected in the City, thereby reducing the Franchise Taxes received from the City's contract waste management provider. This has been somewhat offset by higher than expected franchise taxes received from the sale of electricity and cable television services. Licenses and Permits Revenue ($799,000, or 49% over budgeted projection) Building Permits came in above the original budgeted projections as the activity related to residential construction occurred at a faster pace than was originally anticipated. Due to the nature of this revenue, the expenses for inspections may actually be recognized in Fiscal Year 2003-2004. For example, a Building Permit may be obtained in May or June, with the majority of the inspection costs incurring in the following year. Interest and Rentals ($253,000, or 18% over budgeted proiection) Interest income exceeded the original budgeted projections as the General Fund had a larger cash balance available for investment than was assumed in the budget estimate, primarily due to deferrals that have occurred on some capital projects that are funded with General Fund monies. This was partially offset by an interest yield that was lower than originally assumed in the budget estimate. Intergovernmental ($138,000, or 7% over budgeted projection) Intergovernmental Revenues exceeded the original budgeted projections due to higher than expected Vehicle License fees. The higher projections are reflective of growth in new car sales statewide that occurred in Fiscal Year 2002-2003, which increases the Motor Vehicle in Lieu fees collected by the Department of Motor Vehicles. Charges for Services ($55,000, or 1% under budgeted projection) Charges for Services fell below original budgeted projections as Engineering Plan Check and Inspection fees were below the original adopted budget due to the delay of several commercial projects. The negative budget variance for Charges for Services was partially offset by higher than expected zoning and subdivision fees, due to reimbursements received from developers for staff, legal and consultant costs incurred for the processing of new development in eastern Dublin, primarily related to the proposed annexation in this area. Fines and Forfeitures ($26,000, or 22% over budgeted projection) Other Court fines exceeded the original budget projection due to an increase in the amount allocated to the City from the receipt of court fines over the prior Fiscal Year. Other Revenues ($345,000, or 46% under budgeted projection) Other revenues came in under the original budgeted estimate due to delays in the reimbursement of funds for the Dublin Boulevard Undergrounding project that were included as part of the budget for this category. However, this was partially offset by reimbursements received from the City of Pleasanton for design costs for the Fallon Road Interchange, which was not included as part of the original adopted budget. Significant General Fund Operating EXpenditure variances The City's General Fund operating expenses were approximately $1.2 million (4%) less than thc amount budgeted. The following breakdown examines major areas of savings by category: General Government ($212,000, or 5% under budgeted proicction) Factors which contributed to budget Savings in this category included lower than expected expenditures for health insurance in several divisions, insurance claims, contract professional services for the Central Services Division, as well as for technical support for the "Computers for Our Schools Project." Public Safety ($193,000, or 1% under budgeted proicction) The budget savings in this catego~ resulted primarily from lower than anticipated expenditures for contract fire and Animal Control services from the County, duc to lower than expected costs for contract fire personnel and lower than expected usage of Animal Control services by residents of Dublin. Transportation ($23,000, or 2% under budgeted proicction) The budget savings in this category resulted primarily from lower than anticipated costs for contract street sweeping and street landscape maintenance services. Health and Welfare ($29,000, or 42% under budgeted proicction) The budget savings in this category primarily resUlted from lower than anticipated expenditures for contract professional services in the Housing activity, duc to a delay in the completion of thc non- residential affordable housing fcc study until Fiscal Year 2003-2004. Culture and Leisure ($201,000, or 4% under budgeted proicction) The budget savings in this category resulted primarily from lower than expected costs for maintenance at the City's parks, salaries and benefits for several of thc Parks and Community Services divisions, and contract professional services duc to a delay in completion of the public art master plan. In addition, the delivery of the new van for the Senior Center was delayed until Fiscal Year 2003-2004. Community Development ($515,000, or 9% under budgeted proiection) The budget savings in this category occurred duc to lower than eXPected expenditures for salaries and benefits for the planning and engineering divisions; contract building services; and delays in thc completion of thc Historical District Designation Plan, Streetscape Master Plan, and Scarlett Court Specific Plan Amendment. General Fund Capital Project Expenditure Variances The City's General Fund capital project expenditures were approximately $3.5 million (48%) less than the amount budgeted. This variance primarily represents timing differences in the completion of these capital projects as well as lower than expected expenditures incurred for some of these capital projects. Several of the identified capital projects listed below have been carded over to and/or rebudgeted in Fiscal Year 2003 -2004. Amount of Unspent Amount ApproVed budgeted to be Carried Over expenditures on to Fiscal Year Project Name Capital Projects 2003-2004 Geographic Information System $178,532 $56,344 Front Counter Upgrade $58,118 $1,919 Emergency Generator - Civic Center $124,790 $1,629 Energy Projects $216,196 Downtown Improvements Implementation $941,177 $83,189 Freeway Art - Dublin Boulevard and Amador Valley $225,276 $22,998 Boulevard Bus Shelters $83,923 Shannon Decking and Exterior Painting $519,211 Senior Center $317,142 Utilities Undergrounding $328,765 $328,704 Village Parkway / Lewis Intersection Improvements $58,051 $21,244 Traffic Signal Battery Backup $55,678 Other Capital Improvement Projects - General Fund $381,774 $ 55,146 Total $3,488,633 $571,173 B. SPECIAL REVENUE AND SPECIAL ASSESSMENT FUNDS Gas Tax Expenditures were $468,000 under budget due to the carryover of portions of the Annual Street Overlay and Annual Slurry Seal Program, as well as the Traffic Signal Upgrade at Village Parkway and Amador Valley Boulevard into Fiscal Year 2003-2004. Expenditures in the Transportation for Clean Air Grant Fund were $107,000 under budget due to the carryover of the Bike Path - Alamo Creek North of Amador Valley Boulevard Project into Fiscal Year 2003-2004. Expenditures in the Street Light Assessment District fufid were $78,000 under budget due to the savings realized on the purchase of replacement light poles and lower than expected expenditures incurred for the operation of traffic signals and street lights. Revenues for the State Transportation Improvement Program were $851,000 under budget due to the carryover of the Tassajara Road Freeway Interchange project to Fiscal Year 2003-2004. C. IMPACT FEE AND HOUSING IN LIEU FUNDS Impact Fee Revenues in the City's Traffic Impact Fee and Fire Impact Fee Funds were significantly under budget due to developers using credits against a significant portion of impact fees owed. Impact Fee Revenues in the City's Public Facility Impact Fee Fund and Housing in Lieu Fee fund were significantly ahead of budget by $880,000 and $1.2 million respectively due to significant increases made to these fees and approved by Council during Fiscal Year 2002-2003. Traffic Impact Expenditures were under budget due to the carryover of the Tassajara and Fallon Interchange projects to Fiscal Year 2003-2004. In addition, approximately $7.5 million budgeted for the Eastern Dublin Arterial Street Improvement project remained unspent at year end due to decisions made by developers to pay directly for these improvements and receive impact fee credits in remm from the City. Public Facility Impact Fees expenditures were under budget due to lower than expected expenditures incurred for completion of the new Dublin Library and Phase ]~ of the Emerald Glen Park project in Fiscal Year 2003-2004. Park Dedication Fee Impact Fees were under budget due to the carryover of the Park Play Area Evaluation project to Fiscal Year 2003-2004. Fire Impact Fees were under budget due to the carryover of the Emerald Park Fire Station to Fiscal Year 2003-2004 and due to decisions made by developers to pay directly for purchase of the Fire Station 18 apparatus and construction of Fire Station 18. The developers in return received impact fee credits for these projects from the City. Housing In Lieu expenditures were under budget due to the carryover of expenditures for the Senior Center Affordable Housing Project to Fiscal Year 2003-2004. D. RECOMMENDATION It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. City of Dublin 2002-2003 YTD Revenues and Budget Comparison For the Period Ending June 30, 2003 Total General Fund Revenues Property Taxes Sales Taxes [] FY 2002/2003 Real Property Transfer Tax 91% Transient Occupancy Taxes Franchise Taxes 93% Licenses and Permits 149% Interest and Rentals Intergovernmental from State Charges for Services 99% Fines and Forfeitures 122% Other Revenues 0% 30% 60% 90% 120% 150% 100% of Year Complete FY 2002/03 FY 2002/03 % of FY 2001/02 Budget ~ YTD Actual Budget YTD Actual Property Taxes 9,892,843 10,039,543 101% 8,794,711 Sales Taxes 12,702,000' 13,193,407 104% 12,813,111 Real Property Transfer Tax 415,000' 379,089 91% 434,832 Transient Occupancy Taxes 858,000' 717,083 84% 810,220 Franchise Taxes 1,493,900. 1,394,953 93% 1,385,816 Licenses and Permits 1,622,404 2,421,885 149% 2,327,251 Interest and Rentals 1,373,538' 1,626,512 118% 1,929,611 IntergoVernmental 2,096,165~ 2,234,179 107% 2,076,649 Charges for Services 4,815,0351 4,760,255 99% 4,464,260 Fines and Forfeitures 114,000 139,615 122% 118,191 Other Revenues 755,839 410,714 54% 493,720 Total General Fund Revenues 36,138,72~4~.. ~__37'317'235 103% 35,648,372 Date Printed: ~2/~2003 1:27 PM ATTACHMENT City of Dublin 2002-2003 YTD Expenses and Budget Comparison For the Period Ending June 30, 2003 Total General Fund Expenses General Government Police 100% Fire Other Public Safety · FY 2002/03 Transportation Health and Welfare Culture & Community i% Services Community Development Capital Improv. Projects 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 100% of Year Complete FY 2002~03 FY 2002/03 % of FY 2001/02 Budget YTD Actual Budget YTD Actual General Government 4,551,612 4,339,320 95% 3,929,918 Police 7,947,079 7,947,079 100% 6,668,235 Fire 5,114,779 4,951,375 97% 4,698,608 Other Public Safety 315,058 285,§82 91% 241,625 Transportation 1,359,398 1,336,688 98% 1,094,099 Health and Welfare 69,001 40,300 58% 52,017 Culture and Community Services 4,812,790 4,611,563 96% 4,012,732 Community Development 5,893,670 5,379,083 91% 4,643,652 Capital Improvement Projects 7,323,108 3,834,476 52% 5,788,036 Total General Fund Expenses 37,386,495 32,725,566 88% 31,128,922 General Fund Operating Expenses 30,063,387 28,891,090 96% 25,340,886 ATTACHMENT 2 Date Printed: lf8/2(304 1:53 PM CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF JUNE 2003 (FINAL FISCAL YEAR 2002/2003) Prepared by The Finance Department November 24, 2003 ATTACHMENT 3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Jun2003 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY--- FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR ASSETS CASH (39.014,130) 3,089.386 472,776 31,895.252 189.493 (3.367.223) (24.674.312) CASH WITH FISCAL AGENT 172,312 172.312 170.522 AMOUNT HELD IN ESCROW INVESTMENTS AT COST 87,113.120 87,113.120 94,923.499 RECEIVABLES: TAXES ACCOUNTS 1,702.189 2.775,033 4,742 791,671 5.734 5.279,369 3.106.055 INTEREST 374 891 374.891 823,625 ASSESSMENTS DUE FROM OTHERS 1.662 782 1.662.782 1.124.961 INVENTORY AT COST PREPAID ITEMS 9 730 9.730 15.221 FIXED ASSETS AMOUNT TO BE PROVIDED 1.447.500 1.447.500 1.553.500 TOTAL ASSETS 51.848 582 5.864.419 477.519 32.686.923 1.815.039 92.692.481 77.043.071 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (621.725) (621.725) (654.899) DEPOSITS FOR AB1600 FEES 16 357 16.357 DEPOSITS OTHERS (869.935) (869.935) (893.646) PAYABLES: ACCOUNTS (5.376.917) (2.199.384) (58.231) (1.518.409) (340) (9.153.280) (7,672.600) INTEREST PAYROLL (788.344) (788.344) (655.124) DUE TO OTHERS (143.980) 1.202.702) (460.080) (1.806.761) (1.176.105) DEFERRED qEVENUE (127.768) (127.768) (146.433) DEBT INSTRUMENTS PAYABLE (1.565.000) (1.565,000) (1.671.000) TOTAL LIABILITIES (7,912.312) 3.402.086) (58.231) (1.978.489) (1.565.340) (14.916,457) (12.869.808) FUND BALANCES (42.936.271) 2,462.333) (419.288) (30.708.434) (249.699) (77.776.024) (64.173.263) TOTAL FUND E (43,936.271) (2.462,333) (419.288) (30.708.434) (249.699) (77.776,024) (64.173.263) TOTAL LIABILITIES/EQUITY (51.848.582) (5,864.419) (477,519) (32.686.923) (1,815.039) (92.692.481) (77,043.071) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Jun2003 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S SERVICE FUND GROUP OF TER~ DEBT ---MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 7.037,568 7.037,568 6,352,062 CASH WITH :ISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST qECEIVABLES: TAXES ACCOUNTS 6.230 6,230 1.191 INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 47,265~633 19,466.456 66.732,089 48,676.346 AMOUNT TO BE PROVIDED 68.752,907 68,752.907 50.682.757 TOTAL ASSETS 54,309,432 19,466,456 68.752,907 142.528.794 105.712.356 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS (46.725) (46,725) (40,026) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (68,752,907) (68,752,907) (50,682,757) TOTAL LIABILITIES (46,725) (68,752,907) (68,799,632) (50,722,783) FUND BALANCES (54,262,707) (19,466,456) (73,729,162) (54,989,573) TOTAL FUND E (54,262,707) (19,466,456) (73,729.162) (54,989,573) TOTAL LIABILITIES/EQUITY (54,309,432) (19,466,456) (68,752,907) (142,528,794)(105,712,356) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES ~ FOR THE PERIOD 07/01/2002 THROUGH 06/30/2003 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T,D. VARIANCE ********************** PROPERTY TAXES 9,892,843.00 10,039,542.89 (146,699.89) 8,794,710.89 8,794,710.89 SALES TAX 12,702,000.00 13,193,407.37 (491,407.37) 12,813 111.10 12,813,111.10 REAL PROPERTY TRANSFER TAX 415,000.00 379,088.81 35,911.19 43z 832.20 434,832.20 HOTEL TRANSIENT OCCUPANCY TAX 858,000.00 717,083.07 140,916.93 810 219.79 810,219.79 FRANCHISE TAXES 1,493,900.00 1,394,953.26 98,946.74 1,385 815.52 1,385,815.52 LICENSES & PERMITS 1,622,404.00 2,421,884,99 (799,480.99) 2,327 250.77 2,327,250.77 FINES & FORFEITURES 114,000.00 139,614,86 (25,614.86) 118 190,93 118,190.93 USE/MONEY & PROP-INTEREST 1,244,226,00 1,487,493.37 (243,267.37) 1,843 673.66 1,843,673.66 USE/MONEY & PROP-RENTALS 129,312,00 139,019.25 (9,707.25) 85 936.82 85,936.82 INTERGOVERNMENTAL 2,096,165,00 2,234,178~93 (138,013,93) 2,076,648,50 2,076,648.50 CHARGES FOR SERVICES 4,815,035.00 4,760,254.62 54,780.38 4,464,259,66 4,464,259.66 OTHER SOURCES OF REVENUE 755~839.00 410,713,57 345,125.43 493,722,65 493,722.65 TOTAL REVENUE 36,138,724.00 37,317,234.99 (1,178,510.99) 35,648,372.49 35,648,372.49 ************************** GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 218,332.00 196,233.20 22,098.80 217,946.55 217,946.55 CITY MANAGER 757,318.00 740,856.35 16,461.65 560,359.16 560,359,16 CENTRAL SERVICES 320,800.00 292,316.29 28,483,71 297,049.71 297,049,71 CITY ATTORNEY 850,822.00 850,821,87 .13 764,484.52 764,484,52 ADMIN SERVICES 1,038,223.00 982,221,59 56,001.41 922,865.72 922,865,72 BUILDING MANAGEMENT 757,327,00 757,323.39 3.61 657,327.17 657,327.17 INSURANCE COST CENTER 386,665,00 362,022.64 24,642.36 385,395.68 385,395.68 ELECTIONS COST CENTER 20,940.00 10,918.84 10,021.16 14,507,57 14,507.57 NON-DEPARTMENTAL 201,185.00 146,605.38 54,579.62 109,981,56 109,981,56 ACTIVITY TOTAL 4,551,612.00 4,339,319.55 212,292.45 3,929,917.64 3,929,917.64 PUBLIC SAFETY POLICE 7,947,079.00 7,947,078.88 .12 6,668,234.72 6,668,234.72 CROSSING GUARDS 71,462.00 61,878.80 9,583.20 56,677.08 56,677.08 ANIMAL CONTROL 181,437.00 164,564.93 16,872,07 138,935.98 138,935,98 TRAFFIC SIGNALS & STREET LIGHTIN DISASTER PREPAREDNESS 62,159,00 59,237,80 2,921.20 46,012.48 46,012.48 FIRE SERVICES 5,114,779,00 4,951,374.82 163,404.18 4,698,607.54 4,698,607.54 ACTIVITY TOTAL 13,376,916,00 13,184,135.23 192,780.77 11,608,467.80 11,608,467.80 TRANSPORTATION PUBLIC WORKS 632,482.00 632,481.15 ,85 557,207.53 557,207.53 STREET MAINTENANCE 10,427.00 9,868.95 558,05 6,406.00 6,406.00 STREET SWEEPING 132,100.00 122,569,70 9,530.30 132,383.34 132,383.34 STREET TREE MAINTENANCE 76,663.00 76,662.73 .27 51,079.02 51,079.02 STREET LANDSCAPING MAINTENAN 507,726.00 495,105.08 12,620.92 347,022.86 347,022.86 ACTIVITY TOTAL 1,359,398,00 1,336,687.61 22,710.39 1,094,098.75 1,094,098,75 HEALTH & WELFARE WASTE MANAGEMENT 8,242.00 1,798,28 6,443,72 1,807,38 1,807.38 THE CiTY OF DUBLIN STATEMENT SHOWING '~ _~ I~~) REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 06/30/2003 G E N E RAiL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T,D. VARIANCE CHILD CARE 15,000.00 15,000.00 15,000.00 15,000.00 SOCIAL SERVICES 6,000.00 6,000.00 HOUSING PROGRAMS 39,759.00 17,501.74 22,257.26 35,209.87 35,209.87 ACTIVITY TOTAL 69,001.00 40,300.02 28,700.98 52,017.25 52,017.25 CULTURE & LEISURE SERVICES LIBRARY SERVICES 496,219.00 485,281.21 10,937.79 376,276.00 376,276.00 CULTURAL ACTIVITIES 137,153.00 121,t98.29 15,954.71 119,409.29 119,409.29 HERITAGE CENTER 93,371.00 92 803.62 567.38 69,081.56 69,081.56 DUBLIN CEMETERY 37,418.00 31 341.84 6,076.16 30,077.98 30,077.98 PARK MAINTENANCE 1,263,230.00 1,200 226.46 63,003.54 1,086,713.48 1,086,713.48 COMMUNITY TV 83,906.00 76 233.17 7,672.83 80,087.02 80 087.02 RECREATION ADMIN 453,444.00 452 646.88 797.12 374,416.72 374 416.72 PLAYGROUNDS 261,690.00 230 269.67 31,420.33 207,515.47 207 515.47 SHANNON CENTER 270,182.00 266 989.58 3,192.42 250,834.31 250 834.31 PRESCHOOL 79,421.00 74,354.14 5,066.86 57,470.25 57 470.25 TEENS PROGRAM 113,854.00 100,141.63 13,712.37 Z06,183.40 106 183.40 ADULT SPORTS 95,061.00 97,087.23 (2,026.23) 76,886~84 76 886.84 YOUTH SPORTS 96,743.00 93,209.36 3,533.64 82,402.67 82 402.67 COMMUNITY GYM 35,167.00 46,605.98 (11,438.98) 23,572.33 23,572.33 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 349,589.00 356,425.65 (6,836.65) 314,735.18 314,735.18 SENIOR CENTER 247,286.00 183,985.64 63,300.36 146,824.25 146,824.25 RECREATION INSTRUCTION 143,005.00 153,581.45 (10,576.45) 145,812.50 145,812.50 AQUATICS 332,691.00 338,055.61 (5,364.61) 322,391.18 322,391.18 PARKS/FACILITIES MANAGEMENT 223,360.00 211,125.63 12,234.37 142,041.19' 142,041.19 ACTIVITY TOTAL 4,812,790.00 4,611,563.04 201,226.96 4,012,731.62 4,012,731.62 COMMUNITY DEVELOPMENT PLANNING 2,107,588.00 1,767,026.63 340,561.37 1,486,541.67 1,486,541.67 BUILDING SAFETY 1,585,701.00 1,467,363.47 118,337.53 1,276,343.20 1,276,343.20 ENGINEERING 1,902,477.00 1,865,709.85 36,767.15 1,609,544.48 1,609,544.48 ECONOMIC DEVELOPMENT 297,904.00 278,983.20 18,920.80 271,222.90 271,222.90 ACTIVITY TOTAL 5,893,670.00 5,379,083.15 514,586.85 4,643,652.25 4,643,652.25 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 2,9t2,748.30 2,258,752.04 653,996.26 4,582,889.35 4,582,889.35 COMMUNITY IMPROVEMENTS 1,825,317.00 442,108.93 Z,383,208.07 273,283.82 273,283.82 PARKS 1,598,896,00 669,566.48 929,329.52 351,854.08 351,854.08 STREET CONSTRC/IMPROVEMENTS 986,147.00 464,048.31 522,098.69 580,008.92 580,008.92 ACTIVITY TOTAL 7,323,108.30 3,834,475.76 3,488,632.54 5,788,036.17 5,788,036.17 TOTAL EXPENDITURES 37,386,495.30 32,725,564.36 4,660,930.94 31,128,921.48 31,128,921.48 EXCESS REVENUE (EXPENDITURES) (1,247,771.30) 4,591,670.63 (5,839,441.93) 4,519,451.01 4,519,451.01 TRANSFERS IN FROM OTHER FUNDS 22,350.00 18,560.t5 3,789.85 16,784.89 16,784.89 TRANSFERS OUT FROM OTHER FUNDS (20.00) 20.00 REVENUES OVER(UNDER) EXPENDITURES (1,225,421.30) 4,610,210.78 (5,835,632.08) 4,536,235.90 4,536,235.90 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 06/30/2003 SPECIAL REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** PROPERTY TAXES 93,610.00 103,107.58 (9,497.58) 91,099.68 91 099.68 SALES TAX/OTHER TAXES 317,700.00 380,199.02 (62,499.02) 206,812.62 206 812.62 FINES & FORFEITURES 153,000.00 134,670.06 18,329.94 149,023.41 149 023.41 USES/MONEY & PROPERTY 50,995.00 87,896.70 (36,901.70) 135,432.87 135 432.87 INTERGOVERNMENTAL FROM STATE 9,619,435.00 8,768,700.98 850,734.02 1,601,090.43 1,601 090.43 INTERGOVERNMENTAL FROM COUNTY 240,909.00 276,556.50 (35,647.50) 241,589.50 241 589.50 INTERGOVERNMENTAL FROM FEDERAL 249,461.00 133,137.78 116,323.22 782,793.26 782 793.26 CHARGES FOR SERVICES 885,779.00 920,648.29 (34,869.29) 865,790.08 865 790.08 OTHER SOURCES OF REVENUEr 5,000.00 251,582.51 (246,582.51 30,997.14 30 997.14 TOTAL REVENUE 11,615,889.00 11,056,499.42 559,389.58 4,104,628.99 4,104 628.99 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 215,663.00 2101229.18 5,433.82 377,390.53 377,390.53 TRAFFIC SIGNALS & STREET LTG 148,889.00 137,632.61 11,256.39 145,399.20 145,399.20 DISASTER PREPAREDNESS 7,259.00 7.258.78 .22 FIRE SERVICES 213,873.00 204,076.36 9.796.64 193.800.29 193,800.29 ACTIVITY TOTAL 585,684.00 559,196.93 26,487.07 716,590.02 716,590.02 TRANSPORTATION: STREET MAINTENANCE 238,622.00 238,621.60 .40 209,801.34 209,801.34 STREET SWEEPING ACTIVITY TOTAL 238,622.00 238,621.60 .40 209,801.34 209,801.34 HEALTH & WELFARE: WASTE MANAGEMENT 1,110,918.00 1,063,584.65 47,333.35 1,030,807.37 1 030 807.37 SOCIAL SERVICES 28,427.00 28,427.00 7,500.00 7,500.00 HOUSING PROGRAMS 9.999.54 9,999.54 ACTIVITY TOTAL 1,139,345.00 I 092,011.65 47,333.35 1.048,306.91 1,048,306.91 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 COMMUNITY PROJECTS 36,782.00 36.200.00 582.00 73,425.55 73,425.55 PARKS 426,095.00 426.095.00 STREET CONSTRUCTION/IMPROVEMENT 10.118.056.00 8.733.595.34 1,384,460.66 2,259,994.81 2.259.994.81 ACTIVITY TOTAL 10,580.933.00 9.195.890.34 1.385.042.66 2,333,420.36 2.333,420.36 T 0 T A L EXPENDITURES 12,550.584.00 11,091,720.52 1,458,863.48 4,314,118.63 4,314,118.63 EXCESS <REVENUE>EXPENDITURE 934.695.00 35,221.10 899,473.90 209,489.64 209.489.64 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS (4,207.524.00) 18,560.15 (4,226,084.15) 16,784.89 16.784.89 EXCESS <REVENUE> EXPENDITURE (3.272,829.00) 53.781.25 (3.326,610.25) 226,274.53 226.274.53 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 06/30/2003 CAPITAL IMPROVEMENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** USES/MONEY & PROP-INTEREST 1,104,085.00 1,120,018.43 (15.933.43) 1,743,568.68 1,743,568.68 OTHER SOURCES OF REVENUE 13,628,517.00 10,195,565.15 3.432.951.85 19.685.683.29 19.685,683.29 TOTAL REVENUE: 14,732,602.00 11,315,583.58 3.417.018.42 21,429,251.97 21'.429.251.97 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY A-FFORNEY 23,903.00 23.902.29 .71 ACTIVITY TOTAL 23,903.00 23.902.29 .71 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 524,797.00 219,771.73 305.025.27 96,133.06 96,133.06 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING 8 585.61 8,585.61 ACTIVITY TOTAL 8,585.61 8,585.61 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 14,765.153.43 10,315,973.90 4,449,179.53 4.324,162.75 4,324,162.75 COMMUNITY IMPROVEMENTS PARKS 3,416,077.00 1,274.709.53 2,141 367.47 125.589.57 125,589.57 STREET CONSTRUCTION/IMPROVEMENT 21,060,258.00 9,091.559.57 11 968 698.43 ~ 085.145.94 4,085.145.94 ACTIVITY TOTAL 39,241,488.43 20,682.243.00 18.559 245.43 8.534,898.26 8.534,898.26 T 0 T A L EXPENDITURES 39,790,188.43 20,925,917.02 I8,864.271.41 8,639.616.93 8,639.616.93 EXCESS <REVENUE>EXPENDITURE 25,057,586.43 9,610,333.44 15.447.252.99 (12.789.635.04)(12.789,635.04) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 25,057.586.43 9,610,333.44 15,447,252.99 (12,789,635.04)(12,789,635.04) REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 06/30/2003 SPECIAL ASSESSMENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. /ARtANCE ************************ SPECIAL BENEFITS ASSESSMENTS 536.364.00 501,425.07 34,938.93 431,564.21 431,564.21 USES/MONEY & PROP-INTEREST 13,888.00 14,049.83 (161.83) 20,738.74 20,738.74 OTHER SOURCES OF REVENUE 4,000.00 10,598.97 (6,598.97) 1,995.50 1,995.50 TOTAL REVENUE 554,252.00 526,073.87 28,178.12 454,298.45 454,298.45 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 274,300.00 204,778.18 69,521.82 198,138.51 198,138.51 ACTIVITY TOTAL 274,300.00 204,778.18 69,521.82 198,138.51 198,138.51 TRANSPORTATION PUBLIC WORKS 4,754.00 1,393.46 3,360.54 3,277.22 3,277.32 STREET TREE MAINTENANCE 15,944.00 9,437.02 6,506.98 7,713.24 7,713.24 STREET LANDSCAPE MAINTENANCE 296,055.00 264,802.70 31,252.30 221,458.34 231,458.34 ACTIVITY TOTAL 316,753.00 275,633.18 41,119.82 242,448.90 242,448.90 COMMUNITY DEVELOPMENT ENGINEERING 16,595.00 14,565.20 2,029.80 20,071.01 20,071.01 ACTIVITY TOTAL 16,595.00 14,565.20 2,029.80 20,071.01 20,071.01 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT 102,000.00 56,000.00 46,000.00 ACTIVITY TOTAL 102,000.00 '56,000.00 46,000.00 T 0 T A L EXPENDITURES 709,648.00 550,976.56 158,671.44 460.658.42 460,658.42 EXCESS <REVENUE>EXPENDITURE 155,396.00 24,902.69 130,493.31 6,359.97 6,359.97 EXCESS <REVENUE>EXPENDITURE 155,396.00 24,902.69 130,493.31 6.359.97 6,359.97 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 06/30/2003 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ SPECIAL ASSESSMENTS 238.107.33 (238,107.33) 237,264.42 237,264.42 USES/MONEY & PROP-INTEREST 5.009.96 (5.009.96) 8,099.29 8,099.29 TOTAL REVENUE 243.117.29 (243.117.29) 245.363.71 245.363.71 ************************** GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 233 950.00 233.949.42 .58 233.733.39 233 733.39 ACTIVITY TOTAL 233,950.00 233.949.42 .58 233.733.39 233 733.39 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 233.950.00 233.949.42 .58 233,733.39 233,733.39 EXCESS <REVENUE>EXPENDITURE 233.950.00 (9,167.87) 243,117.87 (11,630.32) (11.630.32) EXCESS <REVENUE>EXPENDITURE 233.950.00 (9,167.87) 243,117.87 (11 630.32) (11.630.32) REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 06/30/2003 INTERNAL SERVICE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** USES/MONEY & PROP-INTEREST 227,059.00 209,125.89 17,933.11 262,597.72 262,597.72 CHARGES FOR SERVICES 1,367,268.00 1,326.711.49 40,556.51 1,103,647.14 1,103,647.14 OTHER SOURCES OF REVENUE 20,000.00 12,629,422.53 (12,609,422.53) 22,267.13 22,267.13 TOTAL REVENUE 1,614,327.00 14,165,259.91 (12,550,932.91) 1,388,511.99 1,388.511.99 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 1,741,280.00 2.344,963.06 (603,683.06) 1,092,881.67 1,092,881.67 ACTIVITY TOTAL 1.741,280.00 2,344,963.06 (603,683.06) 1,092,881.67 1,092,881.67 PUBLIC SAFETY: FIRE 51,818.00 57,775.63 (5,957.63) 41,899.88 41,899.88 ACTIVITY TOTAL 51,818.00 57,775.63 (5,957.63) 41,899.88 41,899.88 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1,793,098.00 2,402,738.69 (609,640.69) 1,134,781.55 1,134,781.55 EXCESS <REVENUE>EXPENDITURE 178,771.00 (11,762,521.22) 11,941,292.22 (253,730.44) (253,730.44) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 178.771.00 (11,762,521.22) 11,941,292.22 (253,730.44) (253,730.44) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 06/20/2003 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGE~ ACTUAL VARIANCE FISCAL YEAR Y,T.D. VARIANCE *****************--*** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: N~N-DEPARTMENTAL 20.00 20.00 FINANCE ACTIVITY TOTAL 20.00 20.00 PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 20.00 20.00 EXCESS <REVENUE>EXPENDITURE 20.00 20.00 TRANSFERS' IN FROM OTHER FUNDS (20.00) 20,00 TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 20.00 20.00