The URL can be used to link to this page

Home My WebLink About4.08 FinanceReport May02 CITY CLERK File # 330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: July 2, 2002 SUBJECT: Financial Reports For the Month of May 2002 Report Prepared by: Carole Perry, Administrative Services Director and Fred Marsh, Finance Manager ATTACHMENTS: 1. YTD Revenues and Budget Comparison 2. YTD Expenses and Budget Comparison 3. Financial Statements for the Month of May 2002 RECOMMENDATION: ~'~ Receive the reports. FINANCIAL STATEMENT: See reports fOr detail of monthly financial activity. DESCRIPTION: This item provides the report of the financial statements for the month of May. 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. Analysis of May 2002 Revenue and Expenditure Report The May report represents the reporting of revenues and expenditures for the first eleven months of the Fiscal Year. It should be noted that there is not an even distribution of revenues and expenditures on a monthly basis. For example, the expenditures for major contracts such as Police and Fire Services lag since the City is billed on a quarterly basis. A more detailed analysis of General Fund Revenue and Expenditures is shown on the attached reports and discussed below. General Fund Revenues Total General Fund Revenues collected throUgh May are lower than occurred in the eleven months of the previous Fiscal Year. The City had collected through May 2002 approximately 83% of the total budgeted General Fund Revenues compared to approximately 88% in the prior Fiscal Year. Real Property Transfer Tax is lower than in the same period of the prior year as the valuation from the sales of new and existing residential properties in the City.had dropped significantly in comparison to the prior year. Transient Occupancy Tax is lower than in the same period of the prior year due to a decline in occupancy rates for the City's hotels. Franchise Taxes are higher than in the same period of the prior year due to higher than expected revenues from gas and electric franchise fees resulting from the significant increase in gas and electric rates that occurred over the prior Fiscal Year. Licenses and'Permits are lower than in the same period of the prior year due to a decline in the valuation of building permits issued on new residential and commercial projects. Interest and Rentals are lower COPIES TO: 4~ G:\Monthly Financials\052002 agenda statement monthly financials, doc ITEM NO. ~ than in the same period of the prior year due to a higher than expected drop in interest rates that has occurred during the current Fiscal Year. Fines and Forfeitures are higher than in the prior year due to an increase in the number of traffic citations issued over the prior year. Other Revenue is lower than in the same period of the prior year due to a one time contribution received from a developer in the prior Fiscal Year to assist with funding construction of the City's new library. General Fund Expenditures Overall, through the month of May expenditures in the General Fund totaled $24.0 million and represented approximately 67% of the total budgeted expenditures in the General Fund. Of this amount, a total of $6.5 million was related to Capital Improvement Projects and the remainder was related to Operating Costs reported in the General FUnd. Capital Project expenditures typically do not follow an even distribution due to differences in project timing. In looking only at General Fund Operating Expenditures, the activity through May 2002 was comparable to the amounts expended for the same period in the prior Fiscal Year. Thru the end of May 2002, the City had expended 65% of the General Fund Operating Budget compared to 70% in the prior Fiscal Year. As previously noted there are some timing differences with payment for contract services, which complicate comparisons between Fiscal Years. Fire is lower than in the same period of the prior year due to timing differences in payments for contract personnel. Health and Welfare is lower than in the same period of the prior year as the review of the City's housing element is expected to be' completed later in the current Fiscal Year. Community Development is lower than in the same period of the prior year due to delays in filling staffing vacancies in the Planning Division. The amoUnt spent on Capital Projects is higher than in the same period of the prior year due to expenditures incurred in the initial stages of construction of the City's new library. All expenditures to date are within the authorized budget. It is recommended that the City Council'receive these reports as authorized by Section 4t 004 of the California Government Code. City of Dublin 2001-2002 YTD Revenues and Budget Comparison / For the Period Ending May 31, 2002 Total General Fund Revenues ,~3% · 188% 94% Property Taxes 196% 32% Sales Taxes 185% · FY 2001/2002 -- I/~8% [] FY 2000/2001 Real Property Transfer Tax 192% Transient Occupancy Taxes 65% t83% Franchise Taxes t79% 96% 73%1 Licenses and Permits 196% Interest and Rentals 7 Intergovernmental from State 90% I I 189% Charges for Services 184% Fines and Forfeitures 184% 105% 51% Other Revenues. 186% 0% 30% 60% 90% 120% 150% 92% of Year Complete FY 2001/02 FY 2001/02 % of FY 2000/01 % of Total for Budget YTD Actual Budget YTD Actual FY 2000/01 Property Taxes 8,258,100 7,801,405 94% 6,874,391 96% Sales Taxes 13,200,000 10,794,201 82% 10,992,071 85% Real Property Transfer Tax 450,000 395,438 88% 527,437 92% Transient Occupancy Taxes 1,035,000 677,117 65% 841,921 83% Franchise Taxes 1,254,830 1,198,419 96% 1,038,653 79% Licenses and Permits 2,957,140 2,166,978 73% 2,911,043 96% Interest and Rentals 1,787,578 1,270,262 71% 2,077,246 79% Intergovernmental 1,948,150 1,747,202 90% 1,793,832 89% Charges for Services 4,773,691 3,872,171 81% 3,128,658 84% Fines and Forfeitures 102,000 107,451 105% 88,933 84% Other Revenues 880,972 453,026 51% 2,340,944 86% Total General Fund Revenues 36,647,461 30,483,670 83% 32,615,129 88% Date Printed: 6/21/2002 2:35 PM '- ATTACHMENT I City of Dublin 2001-2002 YTD Expenses and Budget Comparison For the Period Ending May 31, 2002 Total General Fund Expenses General Government Police Fire 173% Other Public Safety 50% 68% · FY 2001/02 Transportation [] FY 2000/01 Health and Welfare Culture & Community 76% Services Community Development Capital Improv. Projects 0% 20% 40% 60% 80% 100% 92% of Year Complete FY 2001/02 FY 2001/02 % of FY 2000/01 % of Total for Budget YTD Actual Budget YTD Actual FY 2000/01 General Government 4,210,768 3,110,000 74% 2,362,399 77% Police 6,804,324 3,627,582 53% · 2,892,585 50% Fire 4,672,577 2,522,732 54% 3,161,560 73% Other Public Safety 292,463 197,712 68% 114,263 50% Transportation 1,127,147 872,921 77% 751,942 78% Health and Welfare 64,495 36,500 57% 9,993 74% Culture and Community Services 4,354,294 3,312,068 76% 2,592,587 78% Community Development. 5,594;~915 3,871,455 69% 3,794,601 84% Capital Improvement Projects 8,807,889 6,472,847 73% 1,036,938 39% Total General Fund Expenses 35,928,872 24,023,817 67% 16,716,868 67% General FUnd Operating Expenses 27,120,983 17,550,970 65% 15,679,930 70% ~. ATTACHMENT 2 Date Printed; 6z21/2002 2:25 PM CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MAY 2002 Prepared by The Finance Department June 21, 2002 ATTACHMENT 3 CIT OF DU8LIN '/ - BALANCE SHEET FOR THE PERIOD ENDING 31May2002 GENERAL ' SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMO~NDUM ONLY--- FUNDS FUNDS FUNDS FUND FUND CURRENT PRIOR ASSETS CASH (50,347,168) 2,292,825 508,975 43,449,635 150,358 (4,014,323) (24,052,805) CASH WITH FISCAL AGENT 167.304 167,304 166,814 AMOUNT HELD IN ESCROW 109,300 109.300 109,300 INVESTMENTS AT COST 93,738,874 93,738.874 76,149.328 RECEIVABLES: TAXES ACCOUNTS (NE 157,651 157,651 3.517,725 INTEREST 312.860 312.860 744.407 ASSESSMENTS DUE FROM OTHERS 550,856 INVENTORY AT COST PREPAID ITEMS 7.256 7,256 5.175 FIXED ASSETS AMOUNT TO BE PROVIDED 1,652,500 1,652,500 1,652,500 TOTAL ASSETS 43.869,472 2,292,825 508.975 43,558,935 1,970,162 92,131,421 58,843,299 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL (986,607) (986,607) (512,334) DEPOSITS FOR AB1600 FEES (23.322) (46,281.532) (46.304.854) (11,556,340) DEPOSITS OTHERS (882,477) (882,477) (414.923) PAYABLES: ACCOUNTS (154.658) (88,463) (14,507) (216.298) (5,323.868) INTEREST PAYROLL (327.107) (327.107) (547,869) DUE TO OTHERS (98,751) (98,751) (603,122) DEFERRED REVENUE (146,433) (146,433) (147,203) DEBT INSTRUMENTS PAYABLE (1,770.000) (1,770.000) (1,770,000) TOTAL LIABILITIES (2 619,355) (88,463) (46,296,038) (1,770,000) (50,732.527) (20,875,659) FUND BALANCES (41,250.117) (2,204,362) (508.975) 2,737.104 (200.162) (41.398.894) (37,967,640) TOTAL FUND E (41.250,117) (2,204,362) (508,975) 2.737.104 (200.162) (41,398.894) (37,967.640) TOTAL LIAB. FND BAL. RETD (43.869.472) (2,292,825) (508,975) (43,558,935) (1.970,162) (92,131.421) (58,843.299) C:T: oF BALANCE SHEET FOR THE PERIOD ENDING 31May2002 INTERNAL ENTERPRISE. FIXED ASSETS' GENERAL LONG T 0 T A L S SERVICE FUNDS GROUP OF TERM DEBT ---MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 6.144.493 3.122.122 2.694.870 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE 6.495 INTEREST ASSESSMENTS - DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 22.149.264 15.987.209 38.136,473 38.136.473 AMOUNT TO BE PROVIDED 41.464.568 41.464.568 41,688,500 TOTAL ASSETS 28.2931757 15,987,209 41.464.568 82.723.163 82.526.337 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS (4.446) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (41,464.568) (41.464.568) (4t.688.500) TOTAL LIABILITIES (41,464.568) (41.464.568) (41.692.946) FUND BALANCES (28.293.757) (15.987.209) (41,258,594) (40.833.391 TOTAL FUND E (28.293,757) (15.987.209) (41.258,594) (40.833.391 TOTAL LIAB. FND BAL. RETD (28,293.757) (15.987.209) (41,464,568) (82.723,163) (82.526.337 THE CITY OF DUBLIN STATEMENT SHOWING Z'_,~ REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 05/31/2002 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES**~-?*** PROPERTY TAXES 8,258,100.00 7,801,404.71 456,695.29 7,174 289.56 6,874,390.92 299 898.64 SALES TAX 13,200,000.00 10,794,201.30 2,405,798.70 12,985 986.39 10,992 071.27 1,993 915.12 REAL PROPERTY TRANSFER TAX 450,000.00 395,437.89 54,562.11 575 281.78 527 437.37 47 844.41 HOTEL TRANSIENT OCCUPANCY TAX 1,035,000.00 677,117.01 357,882.99 1,010 799.01 841 920.51 168 878.50 FRANCHISE TAXES 1,254,830.00 1,198,419.23 56,410.77 t,313 086.74 1,038 653.17 274 433.57 LICENSES & PERMITS 2,957,140.00 2,166,977.98 790,162.02 3,028 655.28 2,911 043.37 117611.91 FINES & FORFEITURES 102,000.00 107,451.10 (5,451.10) 106 233.99 88 932.74 17 301.25 USE/MONEY & PROP-INTEREST ~,688,988.00 1,198,126.60 490,861.40 2,512 223.69 1,990 643.83 521 579.86 USE/MONEY & PROP-RENTALS 98,590.00 72,135.80 26,454.20"- 114 614.48 86 601.97 28,012.51 INTERGOVERNMENTAL FROM STATE 1,948,150.00 1,744,201.99 203,948.01 2,006 116.43 1,793 831.51 212,284.92 INTERGOVERNMENTAL FROM COUNTY 3,000.00 (3,000.00) CHARGES FOR SERVICES 4,773,691.00 3,872,171.42 901,519.58 3,719,568.13 3,128,658.41 590,909.72 OTHER SOURCES OF REVENUE 880,972.00 453,026.04 427,945.96 2,715,6t9.50 2.340,943.74 374,675.76 TOTAL REVENUE 36,647,461.00 30,483,671.07 6,163,789.93 37,262,474.98 32,615,128.81 4,647,346.17 ************************** GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 266 439.00 211.775.79 54,663.2t 157 649.46 137 770.70 19,878.76 CITY MANAGER 684 838.00 460,376.94 224,461.06 451 460.84 385 909.94 65,550.90 CENTRAL SERVICES 311 657.00 272,390.28 39,266.72 254 490.40 213 537.73 40.952.67 CITY A1-FORNE~ 749 339.00 595,152.08 154,186.92 566 876.47 392 898.58 173.977.89 'ADMIN SERVICES 958 814.00 787,083.98 171.730.02 755 484.16 639 013.21 116,470.95 BUILDING MANAGEMENT 681 962.00 501,286.26 180.675.74 561 247.95 421 802.06 139,545.89 INSURANCE COST CENTER 389 315.00 257,449.41 131,865.59 273 267.70 159 277.11 113,990.59 ELECTIONS COST CENTER 22,532.00 14,485.59 8,046.41 12,013.21 12 013.21 NON-DEPARTMENTAL 145,872.00 10,000.00 135,872.00 53,136.03 176.10 52,959.93 ACTIVITY TOTAL 4,210.768.00 3,110,000.33 1,100,767.67 2,085,726.22 2,362,398.64 723,327.58 PUBLIC SAFETY POLICE 6.804,324.00 3 627.581.82 3,176,742.18 5.842.597.93 2,892,585.20 2,950,012.73 CROSSING GUARDS 63.495.00 44.370.24 19,124.76 49.327.13 27.929.38 11,397.75 ANIMAL CONTROL 180,757.00 111,543.64 69.213.36 136.903.24 38,868.24 98,035.00 DISASTER PREPAREDNESS 48.211.00 41,798.12 6.412.88 41,743.47 37,465.59 4,277.88 FIRE SERVICES 4,672.577.00 2,522,731.58 2.149,845.42 4,331.237.29 3,161,559.50 1,169,677.79 ACTIVITY TOTAL 11,769,364.00 6.348,025.40 5,421.338.60 10,401,809.06 6,168,407.91 4,233.401.15 TRANSPORTATION PUBLIC WORKS '574.025.00 483.551.29 90,473.71 504.545.32 430,901.00 73,644.32 STREET MAINTENANCE 6.406.00 1,970.19 4,435.81 79.88 79.88 STREET SWEEPING 129.200.00 100.727.25 38,472.75 105.015.72 79.752.13 25,263.59 STREET TREE MAINTENANCE 55,629.00 37,890.51 17.738.49 52.929.17 36,870.01 16,059.16 STREET LANDSCAPING MAINTENAN 35t.887.00 248.781.43 103.105.57 297.191.50 204,338.59 92,852.91 ACTIVITY TOTAL 1,127,147.00 872.920.67 254.226.33 959.761.59 751,941.61 207,819.98 HEALTH & WELFARE THE CITYOF DUBLIN STATEMENTSHOWING REVENUESVERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 05/31/2002 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE WASTE MANAGEMENT 8.395.00 46.38 8,348.62 1,483.29 1,469.88 13.41 CHILD CARE 15,000.00 11,845.00 3,155.00 12,000.00 8.523.00 3,477.00 HOUSING PROGRAMS 41,100.00 24,608.77 16,491.23 ACTIVITY TOTAL 64,495.00 36.500.15 27,994.85 13,483.29 9,992.88 3,490.41 CULTURE & LEISURE SERVICES LIBRARY SERVICES 400,725.00 376 276.00 24,449.00 362,922.00 272,191.50 90,730.50 CULTURAL ACTIVITIES 149,328.00 113 999.44 35,328.56 48,979.05 46,307.59 2,671.46 HERITAGE CENTER 84,170.00 57 429.97 26,740.03 64,337.03 53,088.33 11,248.70 DUBLIN CEMETERY 39,687.00 20 976.67 t8,710.33 35,168~63 29,608.05 5,560.58 PARK MAINTENANCE 1,142,023.00 782 359.07 359 663.93-.- 863,488.51 580,818.64 . 282,669.87 COMMUNITY TV 90,982.00 70 355.12 20 626.88 65,376.81 61,304.35 4,072.46 RECREATION ADMIN 398.810.00 321 065.23 77 744.77 299,517.33 260,945.94 38,571.39 PLAYGROUNDS 236,890.00 172 121.38 64 768.62 179,746.06 154,378.68 25,367.38 SHANNON CENTER 265,856.00 213 725.76 52 130.24 223,534.64 185,329.35 38,205.29 PRESCHOOL 58,975.00 49 669.07 9 305.93 54,261.57 47.780.38 6,481.19 TEENS PROGRAM 108,839.00 81 994.43 26 844.57 95,263.42 79,840.12 15,423130 ADULT SPORTS 80,704.00 61 840.92 18,863.08 74,298.29 52,686.48 20,611.81 YOUTH SPORTS 93,023.00 69 230.30 23,792.70 76,437.85 65,279.44 11,158.41 COMMUNITY GYM 37,990.00 15,504.99 22,485.01 37,226.81 15,778.42 21,448.39 SPECIAL EVENTS 320,247.00 290.502.78 29,744.22 200,963.28 180,705.28 20,258.00 SENIOR CENTER 167.065.00 124,6t4.31 42,450.69 137,807.83 116,811.22 20,996.61 RECREATION INSTRUCTION 130,122.00 127.883.52 2,238.48 116,758.13 95,471.99 21,286.14 AQUATICS 368,051.00 244,915.65 123,135.35 300,625.35 209,669.91 90,955.44 PARKS/FACILITIES MANAGEMENT 180,807.00 117,603.58 63,2Q3.42 95,707.64 83,591.54 12,116.10 ACTIVITY TOTAL 4,354,294.00 3,312,068.19 1,042,225.81 3,332,420.23 2,592,587.21 739,833.02 COMMUNITY DEVELOPMENT P~NNING 1,689,970.00 1.281,831.99 408,138.01 1,330,195.42 1,112,321.45 217,873.97 BUILDING SAFETY 1,622.000.00 1,013,701.72 608,298.28 1,334,934.18 1,090,771.15 244,163.03 ENGINEERING 1,999.416.00 1,329,892.50 669,523.50 1,606,493.94 1,253,272.81 253,221.13 ECONOMIC DEVELOPMENT 282,529.00 246.028.35 27,500.65 254,453.24 238.225.67 16.217.57 ACTIVITY TOTAL 5,594.915.00 3,871.454.56 1,723,460.44 4,526,076.78 3,794,601.08 73t,475.70 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 6,095,010.00 5,434,286.54 660,723.46 1,435,693.51 341,145.32 1,094,548.18 COMMUNITY IMPROVEMENTS 1,198,376.00 237,418.97 960,957.03 180,763.51 131,465.57 49,297.94 PARKS 665,863.00 349,673.74 316,189.26 462,208.60 390,200.11 72,008.49 STREET CONSTRC/IMPROVEMENTS 848,640.00. 451.467.84 397,172.16 603,894.29 174,127.15 429,767.14 ACTIVITY TOTAL 8,.807,889.00 6,472,847.09 2,335,041.91 2,682,559.91 1,036,938.16 1,645,621.75 TOTAL EXPENDITURES 35,928,872.00 24,023,816.39 11,905,055.61 25.001,837.08 16,716,867.49 8,284,969.59 EXCESS REVENUE (EXPENDITURES) 718,589.00 6,459,854.68 (5,741,265.68) 12,260,637.90 15,898,261.32 (3,637,623.42) TRANSFERS IN FROM OTHER FUNDS 438.00 (438.00) 17,201.67 17,201.67 TRANSFERS OUT FROM OTHER FUNDS (2,400,000.00 (2,400,000.00) REVENUES OVER(UNDER) EXPENDITURES 718.589.00 6.460,292.68 (5,741.702.68) 9,877,839.57 15,898,261.32 (6,020,421.75) SPECIAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ PROPERTY TAXES 90,175.00 83,308.48 6,866.52 81 587.21 75,000.93 6,586.28 SALES TAX/OTHER TAXES 230.5b0.00 180,182.92 50,317.07 218 443.26 199.323.12 19,120.24 FINES & FORFEITURES 145.155.00 112.260.83 32,894.17 136 129.03 102,831.20 32,297.83 USES/MONEY & PROPERTY 110,312.00 63,876.24 46,425.66 186 396.07 87,213.13 991182.94 INTERGOVERNMENTAL FROM STATE 3,457,849.00 894.472.95 2,563,376.05 1.401 011.82 1,033,889.38 367,122.44 INTERGOVERNMENTAL FROM COUNTY 234.000.00 156,410.25 77,589.75 235 575.00 186.368.00 49,207.00 INTERGOVERNMENTAL FROM FEDERAL 1,122,338.00 57,304.62 1,065.033.38 486 386.87 93.840.87 392,546.00 CHARGES FOR SERVICES 876,760.00 803,827.35 72,932.65 766 872.19 714.741.38 52,130.81 OTHER SOURCES OF REVENUE 5,000.00 16.025.14 (11,025.141'- 17 930.25 5,259.25 12,671.00 TOTAL REVENUE 6.272,089.00 2,367.668.89 2,904,420.11 3,530 331.80 2,498.467.26 1.031.864.54 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 304.065.00 167.916.26 136,148.64 163,769.23 '87.578.30 76,190.93 TRAFFIC SIGNALS & STREET LTG 175,041.00 89,796.30 85,244.70 87,789.56 61.971.08 25,818.48 FIRE SERVICES 177,100.00 124.972.22 52,127.77 188,299.58 138.640.86 49,658.72 ACTIVITY TOTAL 656,206.00 382,684.89 273,521.11 439,858.37 288,190.24 151.668.13 TRANSPORTATION: STREET MAINTENANCE 175,084.00 138.256.46 36,727.54 348,601.71 155,390.73 193.210.98 STREET SWEEPING ACTIVITY TOTAL 175,084.00 138,356.46 36,727.54 248.601.71 155,390.73 193,210.98 HEALTH & WELFARE: WASTE MANAGEMENT 1,049,577.00 521,316.66 528,260.34 1,108.496.91 660,882.41 447,614.50 SENIOR SUPPORT CARE 7,500.00 5,625.'00 1,875.00 7,500.00 5,625.00 1,875.00 HOUSING PROGRAMS 10,000.00 4.681.46 5,318.54 9,918.66 6.202.30 3,716.36 ACTIVITY TOTAL 1,067.077.00 531.623.12 535,453.88 1,125,915.57 672,709.71 452,205.86 COMMUNITY DEVELOPMENT: ENGINEERING 6,000.00 2,398.50 3,601.50 4,999.00 4,999.00 ACTIVITY TOTAL 6,000.00 2,398.50 3,601.50 4,999.00 4,999.00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS 80,373.00 29,458.55 50,914.45 86,648.98 53.851.22 32,797.76 PARKS 411,119.00 411,119.00 STREET CONSTRUCTION/IMPROVEMENT 4,898,421.00 1,820.735.75 3.077 685.25 760,517.95 588.679.58 171,838.37 ACTIVITY TOTAL 5,389.912.00 1,850.194.30 3.539~718.70 847.166.93 642.530.80 204.626.13 T 0 T A L EXPENDITURES 7.294,280.00 . 2,905.257.27 4.389,022.73 2.766,541.58 1.763.820.48 1.002~721.10 EXCESS <REVENUE>EXPENDITURE 1.022.191.00 537.588.28 484,602.62 (763,790.22) (734,646.78 (29.143.44) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 438.00 (428.00) 15 061.59 15.061.59 EXCESS <REVENUE> EXPENDITURE 1,022,191.00 538,026.38 484 164.62 (748,728.63) (734.646.78 (14.081.85) THE CITY OFDUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 05/31/2002 SPECIAL ASSESSMENT FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** SPECIAL BENEFITS ASSESSMENTS 429,448.00 397,355.99 32,092.01 384,648.76 345,216.36 39,432.40 USES/MONEY & PROP-INTEREST 20,187.00 9,125.20 11,061.80 26,456.80 10,955.35 15,501.45 .OTHER SOURCES OF REVENUE 6,000.00 1,995.50 4,004.50 2,300.37 2,300.37 TOTAL REVENUE 455,635.00 408,476.69 47,158.31 413,405.93 358,472.08 54,933.85 ************************** PUBLIC SAFETY: -- TRAFFIC SIGNALS & STREET LIG 230,635.00 160,355.60 70,279.40 119,085.13 86,151.73 32,933.40 ACTIVITY TOTAL 230,635.00 160,355.60 70,279.40 119,085.13 86,151.73 32,933.40 TRANSPORTATION PUBLIC WORKS 4,807.00 2,760.97 2,046.03 2,753.02 1,874.00 879.02 STREET TREE MAINTENANCE 15,065.00 5,654.24 9,410.76 4,175.26 3,642.85 532.41 STREET LANDSCAPE MAINTENANCE 280,667.00 162,243.61 118,423.39 130,649.00 100,248.41 30,400.59 ACTIVITY TOTAL 300,539.00 170,658.82 129,880.18 137,577.28 105,765.26 31,812.02 COMMUNITY DEVELOPMENT ENGINEERING 7,115.00 19,037.56 (11,922.56) 11,050.38 8,550.38 2,500.00 ACTIVITY TOTAL 7,115.00 19,037.56 (11,922.56) 11,050.38 8,550.38 2,500.00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 2,519.14 2,519.14 STREET CONSTRUCTION/IMPRVMNT ACTIVITY TOTAL 2,519.14 2,519.14 T 0 T A L EXPENDITURES 538,289.00 350,051.98 188,237.02 270,231.93 202,986.51 67,245.42 EXCESS <REVENUE>EXPENDITURE 82.654.00 (58.424.71) 141,078.71 (143,174.00) (155,485.57) 12,311.57 EXCESS <REVENUE>EXPENDITURE 82,654.00 (58.424.71) 141,078.71 (143,174.00) (155,485.57) 12,311.57 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES /~ ~/-~ FOR THE PERIOD 07/0t/2001 THROUGH 05/31/2002 CAPITAL IMPROVEMENT FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** USES/MONEY &PROP-INTEREST 1,640,682.00 766,333.51 874,348.49 789,214.44 (789,214.44) OTHER SOURCES OF REVENUE 37,719,269.00 37,719,269.00 8,882,376.17 8.882,376.17 TOTAL REVENUE: 39,359,951.00 766,333.51 38,593,617.49 8,882,276.17 789,214.44 8,093,161.73 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL ~'- PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMs 1,854,726.00 65,392.33 1,789,333.67 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING 8,398.57 (8,398.57) 30,854.96 28,319.15 2,535.81 ACTIVITY TOTAL 8,398.57 (8,398.57) 30,854.96 28.319.15 2,525.81 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 12,869,967.00 1,322,726:10 11,547,240.90 936,862.45 672,210.52 264,651.93 ~OMMUNITY IMPROVEMENTS PARKS t,422,224.00 106,117.02 i,316,106.98 18,854.85 18,854.85 STREET CONSTRUCTION/IMPROVEMENT 15,659,638.00 2,421,344.86 13.228,293.14 7,890,520.72 6,880,297.12 1.010,223.60 ACTIVITY TOTAL 29,951,829.00 3,850,187.98 26,101,641.02 8,846,238.02 7,571,362.49 1,274,875.53 T 0 T A L EXPENDITURES 31,806.555.00 3,923,978.88 27,882,576.12 8,877,092.98 7,599,681.64 1,277,411.34 EXCESS <REVENUE>EXPENDITURE (7,553,396.00) 3.157,645.37 (10,711,041.37) (5,283.19) 6,810,467.20 (6,815,750.39) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 1,140.08 1,140.08 EXCESS <REVENUE>EXPENDITURE (7,553,396.00) 3,157.645.37 (10,711,041.37) (4,143.11) 6.810.467.20 (6,814,610.21) THE CITY OF DUBLIN STATEMENT SHOWING //qw FOR THE PERIOD 07/01/2001 THROUGH 05/31/2002 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** SPECIAL ASSESSMENTS 202,227.39 (202,227.39) 237.172.56 206,511.07 30.661.49 USES/MONEY & PROP-INTEREST 1,767.78 (1,757.78) 16,539.29 5,939.51 10,599.78 TOTAL REVENUE 203,995.17 (203,995.17) 253,711.85 212,450.58 41,261.27 *******EXPENDITURES******* GENEP, AL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 232,578.00 232,733.39 (155.39) 234,093.57 233,093.57 1,000.00 ACTIVITY TOTAL 232,578.00 · 232.733.39 (155.39~- 234,093.57 233,093.57 1.O00.O0 PUBLIC SAFETY: TP, ANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 232.578.00 232.733.39 (155.39) 234.093.57 233.093.57 1.000.00 EXCESS <REVENUE>EXPENDITURE 232.578.00 28.738.22 203,839.78 (19,618.28) 20.642.99 (40,261.27) EXCESS <REVENUE>EXPENDITURE 232,578.00 28.738.22 203 839.78 (19.618.28) 20.642.99 (40,261.27) THE CITY OF DUBLIN STATEMENT SHOWING FOR THE PERIOD 07/01/2001 THROUGH 05/31/2002 INTERNAL SERVICE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 298,835.00 121,730.05 177,104.95 205,273.76 96,664.80 108,608.96 CHARGES FOR SERVICES 1.171,448.00 1,029,015.30 142,432.70 944,535,35 866,861.86 77,673.49 OTHER SOURCES OF REVENUE 17,000.00 21,076.05 (4,076.05) 6,495.00 6,495.00 TOTAL REVENUE 1,487,283.00 1,171,821.40 315,461.60 1,156,304.11 963,526.66 t92,777.45 *******EXPENDITURES******* "- GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 1.140.046.00 362,235.75 777,810.25 1,018,788.52 435,996.14 582,792.38 ACTIVITY TOTAL 1,140,046.00 362,235.75 777,810.25 1,018,788.52 435,996.14 582,792.38 PUBLIC SAFETY: FIRE 45.828.00 33,676.47 12,151.53 40,700.28 30,005.23 10,695.05 ACTIVITY TOTAL 45,828.00 33,676.47 12,151.53 40,700.28 30,005.23 10.695.05 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 189.750.00 189,750.00 20.576.74 (20,576.74) T 0 T A L EXPENDITURES 1,375,624.00 395,912.22 979,711.78 1.059,488.80 486':'578.11 572.910.69 EXCESS <REVENUE>EXPENDITURE (111.659.00) (775,909.18) 664.250.18 (96.815.31) (476,948.55) 380,133.24 TRANSFER IN FROM OTHER FUNDS 2.400.000.00 2.400.000.00 TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE (111,659.00) 775,909.18) 664,250.18 (2,496,815.31) (476.948.55) (2,019.866.76) THE CITY OF ~u~,~N ST^TEnaNT sHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 05/31/2002 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** USES/MONEY & PROP-INTEREST TOTAL REVENUE ***~*****EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPAR-FMENTAL 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 TP~ANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE . 20.00 20.00