Loading...
HomeMy WebLinkAbout4.11 FinalFinRpt FY00-01CITY CLERK File # 330-50 A6ENDA STATEMENT 61TY COUNCIL MEETIN6 DATE: (December 18, 2001) SUBJECT: ATTACHMENTS: RECOMMENDATION: FINANCIAL STATEMENT: Final Financial Report For Fiscal Year 2000/2001 Report Prepared by: Carole Perry, Administrative Services Director and Fred Marsh, Finance Manager YTD Revenues and Budget Comparison YTD Expenses and Budget Comparison Financial Statements for the Month of June 2001 Receive the Reports See Staff Report. DESCRIPTION: This item provides the report of the final financial statements for Fiscal Year 2000- 2001, and incorporates the final audited results for the Fiscal Year. Consistent with prior reports, the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. Significant General Fund Revenue Variances In Fiscal Year 2000/2001 the actual revenues in the General Fund exceeded the budget estimate by approximately $4.6 million. The following revenues contributed significantly to the final outcome: Current Secured Property Tax ($837,000 over budgeted proieCtion) The assessed valuation of all residential and non residential properties located within the City limits increased by $686 million (30%) over the prior Fiscal Year, due to the large number of new residential and non residential properties added to the tax roll for the first time in Fiscal Year 2000/2001, as well as a significant increase in property values within the area. Sales Taxes ($1.7 million over budgeted projection) As reported throughout the fiscal year, the local economy had another positive surge in retail sales. The increase was affected primarily by continued strong sales in the Autos and Transportation and General Consumer Categories. Franchise Taxes ($295,000 over budgeted proiection) Franchise Taxes are higher than in the same period in the Prior year due to an increase in cable rates that occurred during the year as well as a larger than expected increase in the number of new residential customers in Eastern Dublin. Proper .W Transfer and Transient Occupancy Taxes ($388,000 over total budgeted proiections) Real Property Transfer Tax is higher than the same period of the prior year due to increased sales of residential and commercial properties within the City and higher than anticipated property COPIES TO: G:XAUDIT~FY 2000-01\cafrXagenda statement preliminary Year End Financials.doc ITEM NO.~ ~ values associated with those sales. Transient Occupancy Taxes are higher than in the same period in the prior year due to higher room rates and higher than expected occupancy rates. Licenses and Permit Revenue ($95,000 UNDER budgeted projection) The activity related to both residential and commercial construction occurred at a slightly slower pace than was originally anticipated, resulting from a slowdown in the area's economy that occurred during the latter part of Fiscal Year 2000/2001. Due to the nature of this revenue the expenses for inspections may actually be recognized in a future year. For example, a Building Permit may be obtained in May or June, with the majority of the inspection costs incurred in the following year. Investment Income and Interest ($1.1 million over budgeted projection) Interest earnings were higher than originally anticipated as additional funds were made available for investment due to the expenditure savings and delays in Capital Projects noted below, and higher than anticipated revenues in the General Fund, as discussed in this section of the report. In addition, the rate of return on the City's investments was higher than originally estimated in the budget for Fiscal Year 2000/2001. Vehicle License Fees ($180,000 over budgeted projection) Vehicle License Fees were higher than originally anticipated due to an increase in the allocation of Motor Vehicle in Lieu fees from the State. The increase in allocations are reflective of the growth in new car sales statewide during the year, and the higher values of those sales, which increases the amount of fees collected by the Department of Motor Vehicles and allocated to the cities in California. Zoning and Subdivision Fees ($236,000 over budgeted projection) This revenue category exceeded its adopted budget due to additional fees generated from new residential and commercial development that occurred during the year. These fees typically have corresponding expenditures related to Staff and/or consultant time associated with project processing. Significant General Fund Operating Expenditure Variances The City's General Fund "operating expenses" were approximately $1.2 million less than the amount budgeted. The following breakdown examines major areas of savings by Program: General Government ($229,000 under budgeted proiection) Factors which contributed to budget savings in this division included staffing vacancies in the Administrative Services division and lower than anticipated expenditures for technical support for the "Computers for Our Schools Project." Public SafeW ($457,000 under budgeted projection) The budget savings in this category resulted primarily from a delay from the County in the billing of final expenditures for Fiscal Year 2000-01, which will not be received and recorded until well into Fiscal Year 2001-02. In addition, there were lower than expected expenditures for contract fire plan check and inspection services. Culture and Leisure ($143,000 under budgeted projection) The budget savings in this category resulted primarily from staffing vacancies in several of the Parks and Community Services divisions, deferral of maintenance on the alarm system at Shannon to Fiscal Year 2001/2002, and lower than eXpected participation in programs in the Playgrounds activity, thereby reducing the expenditures made for this activity. Communi ,ty Development ($368,000 under budgeted proiection) The budget savings in this category occurred due to staffing vacancies in the Planning Division, lower than expected expenditures for contract building services (which corresponds to the lower than expected building permit revenue noted above), and lower than expected expenditures for contract engineering services, which corresponded with a lower than expected amount of engineering plan check revenue related to private development. Project Name Development Services Data Processing Senior Center Computer System Electrostatic Printer Data Processing System Upgrade ** Geographic Information System ** Communications System Upgrade ** Computers for Our Schools Project Telecommunications Plan Civic Center Library ** Freeway Underpass Art ** Sidewalk Reconstruction Underneath 1-680 Street Banner Art Project ** Shannon Center Doors Heritage Center Storage Building Senior Center Undergrounding Utilities ** LED Traffic Signal Conversion Alamo Canal Bike Path ** Dublin Blvd Widening - Dougherty to Scarlett Other General Fund Capital Projects Total General Fund Capital Project Expenditure Variances The City expended less in Capital Expenditures than originally budgeted. This variance primarily represents a timing difference in the completion of these projects, several of which have been carried over to Fiscal Year 2001/2002. Other budget adjustments may be needed during the current Fiscal Year when these projects are completed. In addition, expenditures for the Senior Center Computer System and LED Traffic Signal Conversion, completed during Fiscal Year 2000/2001, were lower than anticipated. General Fund Unspent Capital Projects Budgets for Fiscal Year 2000/2001 $7,803 $6,490 $8,750 $11,731 $61,701 $9,500 $60,149 $32,620 $1,057,557 $82,967 $84,000 $30,258 $16,235 $73,775 $30,000 $588,783 $16,700 $94,817 $187,861 $3,486 $2,465,183 Unspent budgeted funds for the capital projects marked with a "**" were carded over to Fiscal Year 2001-02 as a budget adjustment approved by Council at the November 20, 2001 Council meeting. It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. City of Dublin 2000-2001 YTD Revenues and Budget Comparison For the Period Ending June 30, 2001 14% Total General Fund Revenues I I I II 16°/o 116% Property Taxes I112% -- 15%o Sales Taxes ,,,,, , , i ,t126~ · FY 2000/2001 ~- Real Property Transfer Tax I I / I FY 1 999/2000 Transient Occupancy Taxes 111 Franchise Taxes 97% Licenses and Permits L74% Interest and Rentals Intergovernmental from State , I~ ~°O~o Charges for Services , ~11~~/O~o 155°A Fines and Forfeitures , ' ,, ' ...... ,,,,I 148% 93% Other Revenues 151 0% 30% 60% 90% 120% 150% 180% 210% 100% of Year Complete FY 2000101 FY 2000101 % of FY 199912000 % of Budget for Budget Y'rD Actual Budget YTD Actual FY 1999/2000 Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental Charges for Services Fines and. Forfeitures Other Revenues 6,168,350 7,174,290 116% 5,991,814 112% 11,300,000 12,985,986 115% 11,548,901 126% 288,000 575,282 200% 370,946 125% 910,000 1,010,799 111% 808,688 139% 1,017,840 1,313,087 129% 963,070 110% 3,124,088 3,028,655 97% 3,897,965 128% 1,513,259 2,626,837 174% 1,340,737 110% 1,813,500 2,006,116 111% 1,632,441 113% 3,542,918 3,719,568 105% 3,308,263 108% 68,755 106,234 155% 84,543 148% 2,935,854 2,716,620 93% 726,525 51% Total General Fund Revenues 32,682,564 37,263,474 114% 30,673,893 116% Date Printed: 12/12/200t 9:t 1 AM ATTACHMENT 1 City of Dublin 2000-2001 YTD Expenses and Budget Comparison For the Period Ending June 30, 2001 Total General Fund General Government Police Fire Other Public Safety Transportation Health and Welfare Cultur~ & Community Services Community Development Capital Improv. Projects 0% a 92% ~9% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 100% of Year Complete [] FY 2000/01 [] FY 1999/00 General Government Police Fire Other Public Safety Transportation Health and Welfare Culture and Community Services Community Development Capital Improvement Projects Total General Fund Expenses General Fund Operating Expenses FY 2000101 Budget 3,314,765 6,125,924 4,448,831 283,619 967,545 19,390 3,475,641 4,894,262 5,147,743 28,677,720 23,529,977 FY 2000/01 % of FY 199912000 YTD Actual Budget YTD Actual 3,085,726 93% 2,274,914 5,842,598 95% 5,106,216 4,331,237 97% 4,186,528 227,973 80% 192,422 959,762 99% 827,142 13~83 70% 19,086 3,332,421 96% 2,827,821 4,526,077 92% 4,116,030 2,682,560 52% 2,366,207 25,001,837 87% 21,916,166 22,319,277 95% 19,549,959 %of Budgetfor FY 199912000 88% 100% 99% 91% 97% 99% 92% 99% 66% 92% 97% GRAPH DATA Da~ Pr~te~: 12/12/2001 9:11 AM ATTACHMENT 2 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET · FOR THE PERIOD ENDING 30Jun2001 SPECIAL SPECIAL CAPITAL TRUST/ REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUND FUND TOTALS ---MEMORANDUM ONLY--- CURRENT PRIOR ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW (39.033.656) INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 76.149.328 2.621,747 744,407 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 550.856 5,175 41.037,857 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANCES (512.334) (72,600) (414,923), (4.500,838) (547,869) (52,266) (147.203) (6,248,033) (34.789.824) ~OTAL FUND E (34,789.824) 2.974,650 822.590 3,797.240 (503.996) (550.856) 448.833 27.742,813 109.300 41.419 490,253 27,852,113 (27,108.591) (39.702) (322,980) (1.054.851) (39,702) (27.431,571) (2.742.389) (450.551) (420,542) (2.742.389) (450,551) (420,542) 147.619 166.814 31.968 (7.963,764) (10,431.784) 166.814 157.925 109.300 4,267.787 76,149.228 49,227.117 3.517.725 2.365.857 744.407 718.499 1,652,500 1,998.900 550.856 61.210 5,175 13.144 1.652.500 1',745.500 74.932.340 48.125.255 (512,334) (663.000) (27.!81.191) (12,455.564) (414.923) (354.683) (5,367,516) (4,536.975) (547.869) (446.?56) (603,122) (233.477) (147.203) (153.640) (1.770.000) (1,770,000) (1,863,000) (1.770,000) (36,544,158) (20,707.095) (228,900) (38,388,181) (27,418.160) (228.900) (38,388.181) (27,418.160) TOTAL LIAB. FND BAL. RETD (41,037.857) (3,797.240) (490.253) (27.852,113) (1,998.900) (74,932,340) (48,125,255) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Jun2001 FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP TOTALS ---MEMORANDUM--- CURRENT PRIOR ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW 5.377,230 INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 6.495 DUE FROM OTHERS INVENTORY ATCOST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 22,149.264 27,532,989 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS (15,141) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (15,141) FUND BALANCES (27.517,848) TOTAL FUND E (27.517,848) 15,987,209 41,688,500 15,987,209 41,688,500 (15,987,209) (15,987,209) (41.688,500) (41,688,500) 2,694,870 2,384,683 6,495 38,136,473 29,731,786 41,688.500 48.653,563 82,526,327 80,770,032 (4.446) (6,353) (41,688,500) (48,653,563) (41,692,946) (48,659,916) (40,833,391) (32.110,116) (40,833,391) (32,110.116) TOTAL LIAB. FND BAL. RETD (27,532.989) (15,987,209) (41,688,500) (82.526,337) (80,770,032) THE cITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 06/30/2001 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************* PROPERTY TAXES SALES TAX REAL PROPERTY TRANSFER TAX HOTEL TRANSIENT,OCCUPANCY TAX FRANCHISE TAXES LICENSES & PERMITS FINES & FORFEITURES USE/MONEY & PROPzINTEREST USE/MONEY & PROP-RENTALS INTERGOVERNMENTAL FROM STATE INTERGOVERNMENTAL FROM COUNTY CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL CITY MANAGER CENTRAL SERVICES CITY'A1-FORNEY ADMIN SERVICES BUILDING MANAGEMENT INSURANCE COST CENTER ELECTIONS COST CENTER NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY POLICE CROSSING GUARDS ANIMAL CONTROL DISASTER PREPAREDNESS FIRE SERVICES ACTIVITY TOTAL TRANSPORTATION PUBLIC WORKS STREET MAINTENANCE STREET SWEEPING STREET TREE MAINTENANCE STREET LANDSCAPING MAINTENAN ACTIVITY TOTAL HEALTH & WELFARE 6,168,350.00 7,174,289.56 (1,005,939.56) 5,991,813.80 11,300,000.00 12.985,986.39 (1,685,986.39) 11,548,901.00 288,000.00 575,281.78 (287,281.78) 370,945.99 910,000.00 1,010,799.01 (100,799.01) 808,688.14 1.017,840.00 1,313,086.74 (295,246.74) 963,069.84 3,124,088.00 3,028,655.28 95,432.72 3,897,965.22 68,755.00 106,233.99 (37,478.99) 84,542.77 1,411,205.00 2,512,223.69 (1,101.018.69) 1,254,906.26 102,054.00 114,614.48 (.12,560.48) 85,831.12 1,813,500.00 2,006,116.43 (192,616.43) 1,629,846.86 2,594.33 3,542,918.00 3,719,568.13 (176,650.13) 3,308,263.42 2,935,854.00 2,715,619.50 220,224.50 726,524.45 32,682,564.00 37.262,474.98 (4,579,910.98) 30.673,893.20 178205.00 451 461.00 254 491.00 566 877.00 889 601.00 561 348.00 273 268.00 12,014.00 127,500.00 3,314,765.00 6,125,924.00 63,760.00 177,595.00 42,264.00 4,448,831.00 10,858,374.00 157,649.46 20,555.54 451,460.84 .16 254,490.40 .60 566,876.47 .53 755,484.16 134,116.84 561.347.95 .05 273,267.70 .30 12,013.21 .79 52,946.02 74,553.98 3,085.536.21 229,228.79 144,214.76 368,092.08 202,489.29 301,446.94 606,030.20 482,597.30 169,061.86 904.34 77.83 2,274,914.60 5,991,813.80 11,548,901.00 370,945.99 808 688.14 963 069.84 3,897 965.22 84 542.77 1,254 906.26 85 831.12 1,629 846.86 2 594.33 3,308 263.42 726 524.45 30,673,893.20 144 214.76 368 092.08 202 489.29 301 446.94 606 030.20 482 597.30 169 061.86 904.34 77.83 2,274,914.60 5,842,597.93 283,326.07 5,106,215.64 5,106,215~64 49,327.13 14,432.87 47,608.I5 47,608.15 136,903.24 40,691.76 107,720.18 107,720.18 41,743.47 520.53 37,094.46 '37,094.46 4,331,237.29 117,593.71 4,186,527.66 4,186,527.66 10,401,809.06 456,564.94 9,485,166.09 9,485,166.09 508,071.00' 504,545.32 3,525.68 861.0~ 79.88 781.12 107,031.00 105,015.72 2,015.28 52,930.00 52,929.1~ .83 298,652.00 297,191.50 1,460.50 967,545.00 959,761.59 7,783.41 406,083.23 11,513.70 82,440.23 40.288.40 286,816.64 827,142.20 406,083.23 11,513.70 82,440.23 40,288.40 286,816.64 827,142.20 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THEPERIOD 07/01/2000 THROUGH 06/30/2001 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE WASTE MANAGEMENT CHILD CARE HOUSING PROGRAMS ACTIVITY TOTAL CULTORE.& LEISURE SERVICES LIBRARY SERVICES CULTURAL ACTIVITIES HERITAGE CENTER DUBLIN CEMETERY PARK MAINTENANCE COMMUNITY TV RECREATION ADMIN PLAYGROUNDS SHANNON CENTER PRESCHOOL TEENS PROGRAM ADULT SPORTS YOUTH SPORTS COMMUNITY GYM SPECIAL EVENTS SENIOR CENTER RECREATION INSTRUCTION AQUATICS PARKS/FACILITIES MANAGEMENT ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING BUILDING SAFETY ENGINEERING ECONOMIC DEVELOPMENT ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS COMMUNITY IMPROVEMENTS PARKS STREET CONSTRC/IMPROVEMENTS ACTIVITY TOTAL TOTAL EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES 7,390.00 1,483.29 5,906.71 12,000.00 12,000.00 7,085.81 12,000.00 7,085.81 12,000.00 19,390.00 13,483.29 5,906.71 19.085.81 19,085.81 362 922.00 55 408.00 67 861.00 35 169.00 863 907.00 69 852.00 312 313.00 213 209.00 233 841.00 55 790.00 105 253.00 76562.00 75,044.00 34,035.00 265,144.00 145,236.00 129,585.00 278,195.00 96,315.00 3,475,641.00 6,428.95 3,523.97 .37 418.49 4,475.19 12,795.67 33,462.94 10,306.36 1,528.43 9,989.58 2,263.71 (1,393.85) (3,191.81) 64,180.72 7,428.17 12,826.87 (22,430.35) 607.36 143.220.77 45,899.58 66,984.82 209,564.06 45,736.76 368,185.22 362,922.00 48,979.05 64,337.03 35,168.63 863,488.51 65,376.81 299,517.32 179,746.06 223,534.64 54,261.57 95,263.42 74,298.29 76,437.85 37 226.81 200 963.28 137 807.83 116 758.13 300 625.35 95 707.64 3,332 420.23 342,557.00 53,367.37 56,071.79 20,225.33 633,590.64 66,950.70 269,725.81 145,380.76 195,927.57 47,479.90 75.134.57 63,823.38 67,900.31 28,795.78 218,102.49 115,715.37 102.256.75 228,879.72 85,735.46 2,827,620.70 1.252,774.61 1,144,717.07 1,462,847.69 255,690.44 4,116,029~81 1,376,095.00 1,330,195.42 1,401,919.00 1,334,934.18 1,816,058.00 1,606,493.94 300,190.00 254,453.24 4,894,262.00 4.526,076.78 342 557.00 53 367.37 56 071.79 30 225.33 633 590.64 66 950.70 269 725.81 145 380.76 195 927.57 47 479.90 75 134.57 62823.38 67900.31 28,795.78 218,102.49 115,715.37 102,256.75 228,879.72 85,735.46 2,827,620.70 1,252,774.61 1,144,717.07 1,462.847.69 255,690.44 4,116,029.81 2,673,851.00 1,435,693.51 1,238,157.49 1,297,739.34 1,297.739.34 386,056.00 180,763.51 205~292.49 234,272.83 234,272.83 592,863.00 462,208.60 120,654.40 722,642.96 722,642.96 1,494,973.00 603,894.29 891,078.71 111,551.69 111,551.69 5,147,743.00 2,682,559.91 2,465,183.09 2,366,206.82 2,366,206.82 3,676,072.93 (8,255,983.91) 5,648.33 180.01 (8.250,155.57) 28,677,720.00 25,001,647.07 4,004,844.00 12,260,827.91 22,850.00 17,201.67 (2,400,010.00) (2,400.190.01) 1,627,684.00 9,877,839.57 21,916,166.03 8,757,727.17 17,869.13 (931,640.50) 7,843.955.80 21,916.166.03 8,757,727.17 17,869.13 (931,640.50) 7.843,955.80 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 06/30/2001 SPECIAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES SALES TAX/OTHER TAXES FINES & FORFEITURES USES/MONEY & PROPERTY INTERGOVERNMENTAL FROM STATE INTERGOVERNMENTAL FROM COUNTY INTERGOVERNMENTAL FROM FEDERAL CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE *******EXPENDITURES******* PUBLIC SAFETY: POLICE TRAFFIC SIGNALS & STREET LTG FIRE SERVICES ACTIVITY TOTAL TRANSPORTATION: STREET MAINTENANCE STREET SWEEPING ACTIVITY TOTAL HEALTH & WELFARE: WASTE MANAGEMENT SENIOR SUPPORT CARE HOUSING PROGRAMS ACTIVITY TOTAL COMMUNITY DEVELOPMENT: ENGINEERING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS PARKS STREET CONSTRUCTION/IMPROVEMENT ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE> EXPENDITURE 82,850.00 81,587.21 1,262.79 78,715.14 78,715.14 194,000.00 218,443.36 (24,443.36) 192,662.02 192,662.02 89,475.00 136,129.03 (46,654.03) 113,370.96 113,370.96 100,676.00 186,396.07 (85,720.07) 103,772.70 103,772.70 2,367,881.00 1,401,011.82 966,869.18 1,158,533.84 1,158,533.84 222,530.00 235,575.00 (13,045.00) 177;904.00 177,904.00 1.041.103.00 486,386.87 554,716.13 87,679.67 87,679.67 763,302.00 766,872.19 (3,570.19) 733,208.99 732,208.99 5,000.00 17,930.25 (12,930.25) 40,601.31 40,601.31 4,866,817.00 3,530,331.80 1,336,485.20 2,686,448.63 2,686,448.63 225,874.00 163,769.23 62,104.77 88,258.42 88,258.42 141,645.00 87.789.56 53,855.44 121,790.46 121,790.46 188,300.00 188,299.58 .42 79,100.67 79,100.67 555,819.00 439,858.37 115,960.63 289,149.55 289,149.55 659,896.00 348,601.71 311,294.29 533,583.10 533,583.10 659,896.00 348,601.71 311,294.29 533,583.10 533,583.10 1,173,771.00 1,108,496.91 65,274.09 866,219.67 866,219.67 7,500.00 7,500.00 10,000.00 9,918.66 81.34 1,191,271.00 1,125.915.57 65,355.43 866,219.67 866,219.67 6,000.00 4,999.00 1,001.00 6,000.00 6,000.00 6,000.00 4,999.00 1,001.00 6,000.00 6,000.00 13,997.81 13,997.81 285,004.00 86,648.98 I98,355.02 59,617.41 59,617.41 8~820.00 8,820.00 20,517.41 20,517.41 2,722,428.00 760,517.95 1,961,910.05 429,360.36 429,360.36 3,016,252.00 847,166.93 2,169,085.07 523,492.99 523,492.99 5,429,238.00 2,766,541.58 2,662,696.42 2,218,445.31 2,218,445.31 562,421.00 (763,790.22) 1,326,211.22 (468,003.32) (468,003.32) 23,838.00 15,061.59 8,776.41 17,869.13 17,869.13 586,259.00 (748,728.63) 1,334,987.63 (450,134.19) (450,134.19) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 06/30/2001' CAPITAL IMPROVEMENT FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 19,313,431.75 19,313,431.75 8,882,376.17 10,431,055.58 10,337,149.24 8,882,376.17 10,431,055.58 10,337,149.24 10,337,149.24 10,337,149.24 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TP, ANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS COMMUNITY IMPROVEMENTS PARKS STREET CONSTRUCTION/IMPROVEMENT ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 37,834.00 30,854.96 6,979.04 12.389.68 12.389.68 37,834.00 30,854.96 6,979.04 12,389.68 12,389.68 1,750,835.75 936,862.45 813,973.30 1,859,640.67 1,859,640.67 1,412,999.00 18,854.85 1,394,144.15 6,057,184.37 6,057,184.37 20,787.408.00 7,890,520.72 12.896,887.28 2,433,845.51 2,433,845.51 23,951,242.75 8,846,238.02 15,105,004.73 10,350,670.55 10,350,670.55 23,989,076.75 8,877,092.98 15,11i,983.77 10,363,060.23 10,363,060.23 4,675,645.00 (5,283.19) 4,680,928.19 25,910.99 25,910.99 1,140.00 1,140.08 (.08) 4,676,785.00 (4,143.11) 4,680.928..11 25,910.99 25,910.99 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 06/30/2001 SPECIAL ASSESSMENT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 390,388.00 384,648.76 5,739.24 318,354.40 318,354.40 13,589.00 26,456.80 (12,867.80) 16,637.02 16,637.02 6,000.00 2,300.37 3,699.63 668.85 668.85 409,977.00 413,405.92 (3,428.93) 335,660.27 325,660.27 *******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/IMPRVMNT ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE EXCESS <REVENUE>EXPENDITURE 172,115.00 119,085.13 53,029.87 118,667.18 118,667.18 172,115.00 119,085.13 53,029.87 118,667.18 118,667.18 4,649.00 2,753.02 1,895.98 3,613~20 3,613.20 12,039.00 4,175.26 7,863.74 4,219.57 4,219.57 243,001.00 130,649.00 112,352.00 131,200.0~ 131,200.04 259,689.00 137,577.28 122,111.72 139,032.81 139,032.81 11,051.00 11,050.38 .62 4,495.98 4,495.98 11,051.00 11,050.28 .62 4,495.98 4,495.98 52,840.00 2~519.14 50,320.86 28,139.83 28,139.83 46,752.16 46,752.16 52,840.00 2,519.14 50,320.86 74,891.99 74,891.99 495,695.00 270,231.93 225,463.07 337,087.96 337,087.96 85,718.00 (143,174.00) 228,892.00 1,427.69 1,427.69 85,718.00 (143,174.00) 228,892.00 1,427.69 1,427.69 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 06/30/2001 RUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE 237,172.56 (227,172.56) 223,189.54 233,189.54 16,539.29 (16,539.29) 13,281.66 13.281.66 253,711.85 (253,711.85) 246.471.20 246,471.20 *******EXPENDITURES******* GENE~L GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE 234,093.57 (234,093.57) 261,375.75 261,375.75 234,093.57 (234,093.57) 261,375.75 261,375.75 234,093.57 (234,093.57) 261,375.75 261,375.75 (19,618.28) 19,618.28 14,904.55 14,904.55 EXCESS <REVENUE>EXPENDITURE (19,618.28) 19,618.28 14,904.55 14,904.55 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 06/30/2001 INTERNAL SERVICE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** USES/MONEY & PROP-INTEREST CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE 187,672.00 205,273.76 (17,601.76) 65,324.17 65,324.17 919,498.00 944,535.35 (25,037.25) 580,974.63 580,974.62 17,000.00 6,495.00 10,505.00 42,214.73 42,214.73 1,124,170.00 1,156,304.11 (32,134.11) 688,513.53 688,513.53 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: FIRE ACTIVITY TOTAL TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 1,021,125.00 1,021,135.00 28,825.00 1,018,788.52 2,346.48 865,319.44 865,319.44 1,018,788.52 2,346.48 865,319.44 865,319.44 40,700.28 (40,700.28) 40,700.28 (40,700.28) 28,825.00 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 1,049,960.00 1,059,488.80 (9,528.80) 865,319.44 865,319.44 (74,210.00) (96,815.31) 22,605.31 176,805.91 176,805.91 2,400,000.00 2,400,000.00 931,286.00 931,286.00 EXCESS <REVENUE>EXPENDITURE (2,474,210.00) (2,496,815.31) 22,605.31 (754,480.09) (754,480.09 CURRENT BUDGET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 06/30/2001 ENTERPRISE FUND CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE *********************** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL FINANCE ACTIVITY TOTAL PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 10.00 10.00 10.00 10.00 (10.00) 10.00 10.00 10.00 10.00 (10.00) 10.00 344.50 354.50 354.50 354.50 (354.50) 10.00 344.50 354.50 354.50 354.50 (354.5O) EXCESS <REVENUE>EXPENDITURE