Loading...
HomeMy WebLinkAbout4.08 May 2003 FinRpts CI'TY CLERK File 330-50 AGENDA STATEMENT CI'TY COUNCIL MEETI'NG DATE: July 2003 SUBJECT: Financial Reports For the Month of May 2003 Report Prepared by: Carole A. 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 2003 RECOMMENDATIO~ ~z~Receive the reports. FINANCIAL STAT~_~_~ENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary 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 2003 Revenue and Expenditure Report The May report represents the reporting of revenues and expenditures for 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 somewhat, 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 in a subsequent section of this report. Additional Impacts resulting from Passage of State Budget for Fiscal Year 2002/2003 As previously reported to Council in the April Financial Reports on May 20th, and as currently budgeted by the State, the City continues to receive Gas Taxes and Motor Vehicle in Lieu Fees from the Department of Motor Vehicles. It should be noted that, for Fiscal Year 2002-2003, the $100,000 revenue budgeted for the Citizen's Option for Public Safety (COPS) grant was received at the end of October 2002 and that $60,748 was received from the State for the City's Booking Fee Reiml>ursements in November 2002. The State budget condition remains unsettled. As of the date that this report was prepared, the State has yet to adopt a final budget for Fiscal Year 2003-2004. Therefore, Staff has no confirmed information regarding the fate of revenue streams critical to the City, such as the Motor Vehicle in Lieu Fees (VLF). As reported previously, VLF comprises $1,937,000 million of the City's General Fund revenue for Fiscal Year 2002-2003. About $1.4 million represents the "backfill" portion that is funded by the State. There is scant optimism that the State will bring in a budget soon. However, Staff will continue to monitor the situation and will report back to Council on any subsequent modifications to the State's budget that have a direct financial impact on the City. COPIES TO: 4~ G:\Monthly Financials\5-2003 agenda statement monthly financials, doc ITEM NO. General Fund Revenues · Total General Fund Revenues collected through May have exceeded what was collected in the eleventh month of the previous Fiscal Year. Through May 2003, the City has collected approximately 90% of the total budgeted General Fund Revenues compared to 86% in the prior Fiscal Year. Property Taxes are higher than in the same period in the prior year due to timing differences related to deductions of property tax receipts for monies due to the Alameda County Surplus Property Authority under its revenue sharing agreement with the City. The amount of sales tax reported through the end of May includes actual sales taxes received through December 2002. Real Property Transfer Tax is lower than in the same period of the prior year due to lower than expected year to date proceeds from the sale of non residential properties. Transient Occupancy Taxes (TOT) are lower than in the same period of the prior year due to lower than expected occupancy rates at some of the City's hotels. In addition, there has been an increase in the amount of exemptions claimed by two of the local hotels. These exemptions are the result of hotel bookings by federal and state employees, who are exempt from paying this tax under the City's TOT ordinance. Franchise Taxes are lower than in the same period of 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. Licenses and Permits are higher than in the same period of the prior year due to an increase in the number of permits pulled for new residential projects. Interest and Rentals is higher than in the same period of the prior year due to timing differences in the receipt of interest payments from federal securities and a higher year to date cash balance in the General Fund than originally estimated in the budget. Initially all interest revenue is recorded in the General Fund and is then allocated quarterly to other funds on a pro rata basis. Intergovernmental Revenue is higher than in the same period of the prior year due to an increase in the allocation of State Motor Vehicle in Lieu fees. Charges for Services is lower than in the same period of the prior year due to the receipt of one time monies from AT&T (now Comcast) for cable equipment in Fiscal Year 2001-2002. Fines and forfeitures are higher than in the same period of the prior year due to an increase in the dollar amount of court convictions from previous outstanding court cases relating to arrests occurring within the City. Other Revenues are lower than in the prior year due to reimbursements received in the prior year from Dublin San Ramon Services District (DSRSD) for work performed on the Dublin Boulevard Widening project. General Fund Expenditures Overall, through the month of May, expenditures in the General Fund totaled approximately $23.9 million and represented approximately 65% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $3.2 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 2003 was similar to the amounts expended for the same period in the prior Fiscal Year. Through May 2003, the City had expended 70% of the General Fund Operating Budget, compared to 69% in the prior Fiscal Year. Fire is higher than in the same period of the prior year due to timing differences for the payment of contract fire services. Other Public Safety was lower than in the same period in the prior year due to timing differences for the payment of contract animal control services. Health and Welfare is lower than in the same period of the prior year due to delays in the completion of the non residential affordable housing fee study. Culture and Community Services are lower than in the same period of the prior year due to timing differences in the payments for partial funding of library services. Community Development is lower than in the same period of the prior year due to lower than expected use of development related contract services in the Planning and Engineering divisions due to delays in development projects. Capital Improvement Projects are lower than in the same period of the prior year. Several of the capital projects funded by the General Fund in Fiscal Year 2002-2003 will not incur major expenditures until later in the Fiscal Year and/or will be carried over into future years, including the Downtown Improvement Implementation, Freeway Underpass Art at Dublin Boulevard and Amador Valley Boulevard, Shannon Community Center Decking & Exterior Painting, Senior Center and Dublin Boulevard Undergrounding of Utilities. In addition, the expenditures for some capital projects are anticipated to come in significantly under budget during the year, including the Geographic Information System and Civic Center HVAC Project. All expenditures to date are within the authorized budget. It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. City of Dublin 2002-2003 YTD Revenues and Budget Comparison For the Period Ending May 31, 2003 Total General Fund Revenues ',6% Property Taxes Sales Taxes :7% · FY 2002/2003 [] FY 2001/2002 Real Property Transfer Tax 91% Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services 87% Fines and Forfeitures 95% Other Revenues ]92 % 0% 30% 60% 90% 120% 150% 92% of Year Complete FY 2002~03 FY 2002~03 % of FY 2001/02 % of Total for Budget YTD Actual Budget YTD Actual FY 2001/02 Property Taxes 9,892,843 9,700,313 98% 7,801,405 89% Sales Taxes 12,702,000 11,095,595 87% 10,794,201 84% Real Property Transfer Tax 415,000 277,165 67% 395,438 91 Transient Occupancy Taxes 858,000 548,981 64% 677,117 84% Franchise Taxes 1,493,900 1,205,899 81% 1,198,419 86% Licenses and Permits 1,622,404 2,293,049 141% 2,166,978 93% Interest and Rentals 1,373,538 1,299,551 95% 1,270,262 66% Intergovernmental 2,096,165 1,875,833 89% 1,747,202 84% Charges for Services 4,815,035 3,866,246 80% 3,872,171 87% Fines and Forfeitures 114,000 108,816 95% 107,451 91 Other Revenues 755,839 342,099 45% 453,026 92% Total General Fund Revenues 36,138,724 32,613,547 90% 30,483,670 86% D ....... ed: ~,~®~ ~:.~ ~,~ ATTACHMENT City of Dublin 2002-2003 YTD Expenses and Budget Comparison For the Period Ending May 31, 2003 Total General Fund Expenses 750/° General Government 79 111111153~ Police 54 ! i o Fire ! 172% i, 0 ~,8 Other Public Safety ~8 ¥o · FY 2002~03 ~~7% [] FY 2001/02 Transportation 80% Health and Welfare 70o/, Culture & Community ~/ '8_.°/_o Services Community 75 o 0 Development 83 Capital Improv. l/lllll~~ I ] 43°/~/ ~95' Projects I I ! I I ] I ] I 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 92% of Year Complete FY 2002103 FY 2002103 % of FY 2001/02 % of Total for Budget YTD Actual Budget YTD Actual FY 2001/02 General Government 4,334,621 3,444,813 79% 3,102,445 79% Police 7,900,174 4,201,030 53% 3,627,582 54% Fire 5,114,779 3,693,393 72% 2,522,732 54% Other Public Safety 315,058 181,708 58% 197,712 82% Transportation 1,337,221 1,034,099 77% 872,921 80% Health and Welfare 69,001 34,538 50% 36,500 70% Culture and Community Services 4,812,790 3,738,249 78% 3,312,068 83% Community Development 5,893,670 4,438,669 75% 3,871,455 83% Capital Improvement Projects 7,321,648 3,166,310 43% 6,471,607 95% Total General Fund Expenses · 37,098,962 23,932,809 65% 24,015,022 75% General Fund Operating Expenses 29,777,314 20,766,499 70% 17,543,415 69% ATTACHMENT 2 Date P~nted: 6,t20f2003 5:01 PM CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MAY 2003 Prepared by The Finance Department June 3, 2003 ATTACHMENT 3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31May2003 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 (40.487.813) 2,854.691 539,549 30.605,412 164,758 (6.323.403) (24.890.008) CASH WITH FISCAL AGENT 172,101 172,101 167,304 AMOUNT HELD IN ESCROW 109,300 INVESTMENTS AT COST 90,247,099 90,247,099 93,738,874 RECEIVABLES: TAXES ACCOUNTS 138,985 361,702 500,688 157,651 INTEREST 542,481 542,481 312,860 ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 17.321 17.321 7,256 FIXED ASSETS AMOUNT TO BE PROVIDED 1,553,500 1,553,500 1,652,500 TOTAL ASSETS 50,458,073 3,216,393 539,549 30,605,412 1,890,360 86,709,787 71,255,737 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (761,790) (761,790) (986,607) DEPOSITS FOR AB1600 FEES (34,901) (7,742,861) (7,777.763) (24.669,965) DEPOSITS OTHERS (851,098) (851,098) (874.922) PAYABLES: ACCOUNTS (216,428) (140,012) (212,833) (569,273) (257.628) INTEREST PAYROLL (403,757) (403,757) (327,107) DUE TO OTHERS (48,928) (48,928) (98,751) DEFERRED REVENUE (127,768) (127,768) (146,433) DEBT INSTRUMENTS PAYABLE (1,671,000) (1,671,000) (1,770,000) TOTAL LIABILITIES (2.444,671) (140,012) (7,955,694) (1,671,000) (12,211,377) (29,131,412) FUND BALANCES (48,013,402) (3,076,381) (539,549) (22,649,718) (219,360) (74,498,410) (38,211,664) TOTAL FUND E (48,013,402) (3,076,381) (539,549) (22,649,718) (219,360) (74.498,410) (38,211,664) TOTAL LIABILITIES/EQUITY (50,458,073} (3,216,393) (539,549) (30,605,412) (1,890.360) (86,709,787) (67,343,076) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31May2003 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 6,731,076 (20) 6,731,056 6,144,493 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 36,183,959 12,492,387 48,676,346 38,136,473 AMOUNT TO BE PROVIDED 50,612,604 50,612,604 41.464,568 TOTAL ASSETS 42,915,035 (20) 12,492,387 50.612,604 106,020,006 85,745,534 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (50,612,604) (50.612,604) (41,464,568) TOTAL LIABILITIES (50,612,604) (50,612,604) (41,464,568) FUND BALANCES (42.915.035) 20 (12,492,387) (55,407,402) (43,505,056) TOTAL FUND E (42,915,035) 20 (12,492,387) (55,407,402) (43,505,056) TOTAL LIABILITIES/EQUITY (42,915,035) 20 (12,492,387) (50.612.604) (106,020,006) (84,969,625) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 05/31/2003 GENERA REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D~ VARIANCE ********************** PROPERTY TAXES 9,892,843.00 9,700,313.05 192,529.95 8,794,710.89 7,801,404.71 993,306.18 SALES TAX 12,702,000.00 11,095,595.04 1,606,404.96 12,813,111.10 10,794,201.30 2,018,909.80 REAL PROPERTY TRANSFER TAX 415,000.00 277,165.46 137,834.54 434,832.20 395,437.89 39,394.31 HOTEL TRANSIENT OCCUPANCY TAX 858.000.00 548,981.46 309,018.54 810,219.79 677,117.01 133,102.78 FRANCHISE TAXES 1,493,900.00 1,205,899.27 288,000.73 1,385,815.52 1,198,419.23 187,396.29 LICENSES & PERMITS 1,622,404.00 2,293,049.39 (670,645.39) 2,327,250.77 2,166.977.98 160,272.79 FINES & FORFEITURES 114,000.00 108,816.44 5,183.56 118,190.93 107,451.10 10,739.83 USE/MONEY & PROP-INTEREST 1,244,226.00 1,187,719.92 56,506.08 1,843,673.66 1,198,126.60 645,547.06 USE/MONEY & PROP-RENTALS 129,312.00 111,831.52 17,480.48 85,936.82 72,135.80 13.801.02 INTERGOVERNMENTAL 2,096,165.00 1,875,833.22 220,331.78 2,076,~48.50 1,747,201.99 329,446.51 CHARGES FOR SERVICES 4,815,035.00 3,866,246.10 948,788.90 4,464,259.66 3,872,171.42 692,088.24 OTHER SOURCES OF REVENUE 755,839.00 342.099.12 413,739.88 493,722.65 453,026.04 40,696.61 TOTAL REVENUE 36,138,724.00 32.613,549.99 3,525,174.01 35,648,372.49 30,483,671.07 5,164,701.42 ************************** GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 218,332.00 176,620.99 41,711.01 217,946.55 204,220.79 13,725.76 CITY HANAGER 757,318.00 639,388.99 117,929.01 560,359.16 460,376.94 99,982.22 CENTRAL SERV*CES 320,800.00 248,966.69 71,833.31 297,049.71 272,390.28 24,659.43 CITY ATTORNEY 686,076.00 651,722.14 34,353.86 764,484.52 595,152.08 169,332.44 ADMIN SERVICES 1,038,223.00 843,699.02 194,523.98 922,865.72 787,083.98 135,781.74 BUILDING MANAGEMENT 731,567.00 584,555.07 147.011.93 657,327.17 501,286.26 156,040.91 INSURANCE COST CENTER 386,665.00 269,691.14 116,973.86 385,396.68 257,449~41 127,946.27 ELECTIONS COST CENTER 20,940.00 10,668.84 10,271.16 14,507.57 14,485.59 21.98 NON-DEPARTMENTAL 174,700.00 19,500.00 155,200.00 109,981.56 10,000.00 99,981.56 ACTIVITY TOTAL 4,334,621.00 3,444,812.88 889,808.12 3,929,917.64 3,102,445.33 827,472.31 PUBLIC SAFETY POLICE 7,900,174.00 4,201,029.94 3,699,144.06 6,668,234.72 3,627,581.82 3,040,652.90 CROSSING GUARDS 71.462.00 50,242.30 21,219.70 56,677.08 44,370.24 12,306.84 ANIMAL CONTROL 181,437.00 87,887.97 93,549.03 138,935.98 111,543.64 27,392.34 DISASTER PREPAREDNESS 62,159.00 43,577.71 18,581.29 46,012.48 41,798.12 4,214.36 FIRE SERVICES 5,114,779.00 3,693,392.52 1,421,386.48 4,698,607.54 2,522,731.58 2,175,875.96 ACTIVITY TOTAL 13,330,011.00 8,076,130.44 5,253,880.56 11,608,467.80 6,348,025.40 5,260,442.40 TRANSPORTATION PUBLIC WORKS 616,631.00 531,023.98 85,607.02 557,207.53 483,551.29 73,656.24 STREET MAINTENANCE 10,427.00 7,927.19 2,499.81 6,406.00 1,970.19 4,435.81 STREET SWEEPING 132,100.00 92,542.87 39,557.13 132,383.34 100,727.25 31,656.09 STREET TREE MAINTENANCE 70,337.00 51,342.07 18,994.93 51,079.02 37,890.51 13,188.51 STREET LANDSCAPING MAINTENAN 507,726.00 351,263.12 156.462.88 347,022.86 248,781.43 98,241.43 ACTIVITY TOTAL 1,337,221.00 1,034,099.23 303,121.77 1,094,098.75 872,920.67 221,178.08 HEALTH & WELFARE WASTE MANAGEMENT 8,242.00 182.78 8,059.22 1,807.38 46.38 1,761.00 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 05/31/2003 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE CHILD CARE 15,000.00 13,603.00 1,397.00 15,000.00 11,845.00 3,155.00 SOCIAL SERVICES 6,000.00 6,000.00 HOUSING PROGRAMS 39,759.00 14,751.74 25,007,26 35,209.87 24,608.77 10,601.10 ACTIVITY TOTAL 69,001.00 34,537.52 34,463,48 52,017,25 36,500.15 15,517.10 CULTURE & LEISURE SERVICES LIBRARY SERVICES 496,219.00 373,839.97 122,379.03 376,276.00 376,276.00 CULTURAL ACTIVITIES 137,153.00 104,566.67 32,586.33 119,409.29 113,999.44 5.409.85 HERITAGE CENTER 93,371.00 80.417.09 12,953.91 69,081.56 57,429.97 11,651.59 DUBLIN CEMETERY 37,418.00 21,029.43 16,388.57 30,077.98 20,976.67 9,101.31 PARK MAINTENANCE 1,263,230.00 862,347.76 400,882.24 1,086,713.48 782,359.07 304,354.41 COMMUNITY TV 83,906.00 74,500.07 9,405.93 80,087.02 70,355.12 9,731.90 RECREATION AOMIN 453,444.00 385,341.42 68,102.58 374,416.72 321,065.23 53,351.49 PLAYGROUNDS 261,690.00 191,383.88 70,306.12 207,515.47 172,121.38 35,394.09 SHANNON CENTER 270,182.00 228,985.53 41,196.47 250,834.31 213,725.76 37,108.55 PRESCHOOL 79,421.00 64,664.63 14,756.37 57,470.25 49,669.07 7,801.18 TEENS PROGRAM 113,854.00 80,326.70 33,527.30 106,183.40 81,994.43 24,188.97 ADULT SPORTS 95,061.00 78,760.40 16,300.60 76,886.84 61,840.92 15,045.92 YOUTH SPORTS 96,743.00 82,973.55 13,769.45 82,402.67 69,230.30 13,172.37 COMMUNITY GYM 35,167.00 41,499.89 (6,332.89) 23,572.33 15,504.99 8.067.34 SPECIAL EVENTS 349,589.00 337,335.41 12,253.59 314,735.18 290,502.78 24,232.40 SENIOR CENTER 247,286.00 153,457.29 93,828.71 146,824.25 124,614.31 22,209.94 RECREATION INSTRUCTION 143,005.00 139,075.72 3,929.28 145,812.50 127,883.52 17,928.98 AQUATICS 332,691.00 258,054.55 74,636.45 322,391.18 244,915.65 77,475.53 PARKS/FACILITIES MANAGEMENT 223,360.00 179,688.73 43,671.27 142,041.19 117,603.58 24,437.61 ACTIVITY TOTAL 4,812,790.00 3,738,248.69 1,074,541.31 4,012,731.62 3,312,068.19 700,663.43 COMMUNITY DEVELOPMENT PLANNING 2,107,588.00 1,473,829.90 633,758.10 1,486,541.67 1,281,831.99 204,709.68 BUILDING SAFETY 1,585,701.00 1,175,307.94 410,393.06 1,276,343.20 1,013,701.72 262,641.48 ENGINEERING 1,902,477.00 1,534,889.31 367,587.69 1,609,544.48 1,329.892.50 279,651.98 ECONOMIC DEVELOPMENT 297,904.00 254,642.06 43,261.94 271,222.90 246,028.35 25,194.55 ACTIVITY TOTAL 5,893,670.00 4,438,669.21 1,455~000.79 4,643,652.25 3,871,454.56 772,197.69 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 2,911,288.30 2,057,857.97 853,430.33 4,582,889.35 5,434,286~54 (851,397.19) COMMUNITY IMPROVEMENTS 1,825,317.00 400,470.55 1,424,846.45 273,283.82 237,418.97 35,864.85 PARKS 1,598,896.00 445,295.94 1,153,600.06 351,854.08 349,673.74 2,180.34 STREET CONSTRC/IMPROVEMENTS 986,147.00 262,685.21 723,461.79 580,008.92 450,228.00 129,780.92 ACTIVITY TOTAL 7,321,648.30 3,166,309.67 4,155,338.63 5,788,036.17 6,471,607.25 (683,571.08) TOTAL EXPENDITURES 37,098,962.30 23,932,807.64 13,166,154.66 31,128,921.48 24,015,021.55 7,113,899.93 EXCESS REVENUE (EXPENDITURES) (960,238.30) 8,680,742.35 (9,640,980.65) 4,519,451.01 6,468,649.52 (1,949,198.51) TRANSFERS IN FROM OTHER FUNDS 6,600,00 (6,600.00) 16,784.89 438,00 16,346.89 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES (960,238.30) 8,687,342.35 (9,647,580.65) 4,536,235.90 6,469,087.52 (1,932,851.62) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 05/31/2003 SPECIAL REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D, VARIANCE ************************ PROPERTY TAXES 93,610.00 96,049.33 (2,439.33) 91,099.68 83,308.48 7,791.20 *ALE* TAX/OTHER TAXES 317,700.00 300,163.26 17,536.74 206,812.62 180,182.93 26,629.69 FINE* & FORFEITURES 153,000.00 98,313.06 54,686.94 149,023.41 112,260.83 36,762.58 U,ES/MONEY & PROPERTY 50,995.00 72,893.73 (21,898.73) 135,432.87 63,876.34 71,556.53 INTERGOVERNMENTAL FROM *TATE 4,518,386.00 6,109,970.63 (1,591,584.63) 1,601,090.43 894,472.95 706,617.48 INTERGOVERNMENTAL FROM COUNTY 240,909.00 147,542.00 93.367.00 241.589.50 156,410.25 85,179.25 INTERGOVERNMENTAL FROM FEDERAL 249,461.00 184,537.72 64,923.28 782,793.26 57,304.62 725,488.64 CHARGE* FOR *ERVICE* 885,779.00 875,768.87 10,010.13 865,790.08 803,827.35 61,962.73 OTHER *OURCE* OF REVENUE 5,000.00 12,315.28 (7,315.28) 30,997.14 16,025.14 14,972.00 TOTAL REVENUE 6,514,840.00 7,897,553.88 (1,382,713.88) 4,104,628.99 2,367,668.89 1,736,960.10 ************************** PUBLIC SAFETY: POLICE 205,727.00 90,243.93 115,483.07 377,390.53 167,916.36 209,474.17 TRAFFIC SIGNALS & STREET LTG 145,900.00 102,616.00 43,284.00 145,399.20 89,796.30 55,602.90 FIRE SERVICES 213,873.00 217,119.80 (3,246.80) 193,800.29 124,972.23 68,828.06 ACTIVITY TOTAL 572,500.00 409.979.73 162,520.27 716,590.02 382,684.89 333,905.13 TRANSPORTATION: STREET MAINTENANCE 219,619.00 120,913.37 98.705.63 209.801.34 138,356.46 71,444.88 STREET SWEEPING ACTIVITY TOTAL 219,619.00 120,913.37 98,705.63 209,801.34 138,356.46 71,444.88 HEALTH & WELFARE: WASTE MANAGEMENT 1,079,569.00 512,501,72 567,067.28 1,030,807.37 521,316.66 509,490.71 SOCIAL SERVICES 28,427.00 23,382.38 5,044.62 7,500.00 5,625.00 1,875.00 HOUSING PROGRAMS 9,999.54 4,681.46 5,318.08 ACTIVITY TOTAL 1,107,996.00 535,884.10 572,111.90 1,048,306.91 531,623.12 516,683.79 COMMUNITY DEVELOPMENT: ENGINEERING 6,000.00 6,000.00 6,000.00 2,398.50 3,601.50 ACTIVITY TOTAL 6,000.00 6,000.00 6,000.00 2,398.50 3,601.50 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS 36,782.00 36,200.00 582.00 73,425.55 29,458.55 43,967.00 PARKS 426,095.00 254,440.00 171,655.00 STREET CONSTRUCTION/IMPROVEMENT 4,995,626.00 2,311,458.62 2,684,167.38 2,259,994.81 1,821.975.59 438,019.22 ACTIVITY TOTAL 5,458,503.00 2,602,098.62 2,856,404.38 2,333,420.36 1,851,434.14 481,986.22 T 0 T A L EXPENDITURES 7.364,618.00 3,674,875.82 3,689,742.18 4,314.118.63 2.906,497.11 1,407,621.52 EXCESS <REVENUE>EXPENDITURE 849,778.00 (4,222,678.06) 5,072,456.06 209,489.64 538,828.22 (329,338.58) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 3,662,410.97 (3,662,410.97) 16,784.89 438.00 16,346.89 EXCESS <REVENUE> EXPENDITURE 849,778.00 (560,267.09) 1,410,045.09 226,274.53 539,266.22 (312,991.69) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 05/31/2003 SPECIAL ASSESSMENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ SPECIAL BENEFITS ASSESSMENTS 536.364.00 457,610.11 78,753.89 431,564.21 397,355.99 34,208.22 USES/MONEY & PROP-INTEREST 13,888.00 11,341.69 2,546.31 20,738.74 9,125.20 11,613.54 OTHER SOURCES OF REVENUE 4,000.00 6,863.08 (2,863.08) 1,995.50 1,995.50 TOTAL REVENUE 554,252.00 475,814.88 78,437.12 454,298.45 408,476.69 45,821.76 ************************** PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 274,300.00 158,874.27 115,425.73 198,138.51 160,355.60 37,782.91 ACTIVITY TOTAL 274,300.00 158,874.27 115,425.73 198,138.51 160,355.60 37,782.91 TRANSPORTATION PUBLIC WORKS 4,754.00 1,224.71 3,529.29 3,277.32 2,760.97 516.35 STREET TBEE MAINTENANCE 15,944.00 8,390.99 7,553.01 7,713.24 5,654.24 2,059.00 STREET LANDSCAPE MAINTENANCE 292,861.00 200,214.34 92,646.66 231,458.34 162,243.61 69,214.73 ACTIVITY TOTAL 313,559.00 209,830,04 103,728.96 242,448.90 170,658.82 71,790.08 COMMUNITY DEVELOPMENT ENGINEERING 16,250.00 11,752.20 4,497.80 20,071.01 19,037.56 1,033.45 ACTIVITY TOTAL 16,250.00 11,752.20 4,497.80 20,071.01 19,037.56 1,033.45 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT 102,000.00 102,000.00 ACTIVITY TOTAL 102,000.00 102,000.00 T 0 T A L EXPENDITURES 706.109.00 380,456.51 325,652.49 460,658.42 350,051.98 110,606.44 EXCESS <REVENUE>EXPENDITURE 151,857.00 (95.358.37) 247.215.37 6,359.97 (58,424.71) 64,784.68 EXCESS <REVENUE>EXPENDITURE 151,857.00 (95,358.37) 247,215.37 6,359.97 (58.424.71) 64,784.68 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/20~2 THROUGH 05/31/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,041,798.88 62,286.12 1,743,568.68 766,333.51 977,235.17 OTHER SOURCES OF REVENUE 11,180,405.00 11,180,405.00 19,685,683.29 19,685,683.29 TOTAL REVENUE: 12,284,490.00 1,041,798.88 11,242,691.12 21,429,251.97 766,333.51 20,662,918.46 ************************** GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 12,950,00 18,691.06 I5,741.06) ACTIVITY TOTAL 12,950.00 18,691.06 (5,741.06) PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 494,797.00 144,280.53 350,516.47 96,133.06 65,392.33 30,740.73 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING 2,561.31 (2,561.31) 8,585,61 8,398.57 187.04 ACTIVITY TOTAL 2,561.31 (2,561.31) 8,585.61 8,398.57 187.04 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 14,764,215.43 8.776,442.66 5,987,772.77 4,324,162.75 1,322,726.10 3,001,436.65 COMMUNITY IHPROVEMENTS PARKS 3,416,077.00 1,081,790.90 2,334,286.10 125,589.57 106,117.02 19,472.55 STREET CONSTRUCTION/IMPROVEMENT 19,770,575.00 8,687,082.09 11,083,492.91 4,085,145.94 2,421,344.86 1,663,801.08 ACTIVITY'TOTAL 37,950,867.43 18,545,315.65 19,405,551.78 8,534,898.26 3,850,187.98 4,684,710.28 T 0 T A L EXPENDITURES 38,458,614.43 18,710,848.55 19,747,765.88 8,639,616.93 3,923,978.88 4,715,638.05 EXCESS <REVENUE>EXPENDITURE 26,174,124.43 17,669,049.67 8,505,074.76 (12,789,635.04) 3,157,645.37 (15,947,280.41) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 26,174,124.43 17,669,049.67 8,505,074.76 (12,789,635.04) 3,157,645.37 (15,947,280,41) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/0t/2002 THROUGH 05/31/2003 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ SPECIAL ASSESSMENTS 207,689.64 (207,689.64) 237,264.42 202,227.39 35,037.03 USES/MONEY & PROP-INTEREST 3,698.90 (3,698.90) 8,099.29 1,767.78 6,331.51 TOTAL REVENUE 211,388.54 (211,388.54) 245,363.71 203,995.17 41,368.54 ************************** GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 229,828.00 232,559.42 (2,731.42) 233,733.39 232,733.39 1.000.00 ACTIVITY TOTAL 229,828.00 232,559.42 (2,731.42) 233,733.39 232,733.39 1,000.00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 229,828.00 232,559.42 (2,731.42) 233,733.39 232,733.39 1,000.00 EXCESS <REVENUE>EXPENDITURE 229,828.00 21,170.88 208,657.12 (11,630.32) 28,738.22 (40,368.54) EXCESS <REVENUE>EXPENDITURE 229,828.00 21,170.88 208,657.12 {11,630.32) 28,738.22 (40,368.54) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 05/31/2003 INTERNAL SERVICE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T,D. VARIANCE ************************ USES/MONEY & PROP-INTEREST 227,059.00 178,599.72 48,459.28 262,597.72 121.730.05 140,867.67 CHARGES FOR SERVICES 1,367,268.00 1,070,321.60 296,946.40 1,103,647.14. 1,029,015.30 74,631.84 OTHER SOURCES OF REVENUE 20,000.00 17,630.53 2,369.47 22,267.13 21,076.05 1,191.08 TOTAL REVENUE 1,614,327.00 1,266,551.85 347,775.15 1,388,511.99 1,171,821.40 216,690.59 ************************** GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 1,741,280.00 808,141.90 933.138.10 1,092.881.67 362,235.75 730,645.92 ACTIVITY TOTAL 1,741,280.00 808,141.90 933,138.10 1,092,881.67 362,235.75 730,645.92 PUBLIC SAFETY: FIRE 51,818.00 40,560.59 11,257.41 41,899.88 33,676.47 8,223.41 ACTIVITY TOTAL 51,818.00 40,560.59 11,257.41 41,899.88 33,676.47 8,223.41 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1,793,098.00 848,702.49 944,395.51 1,134,781.55 395,912.22 738,869.33 EXCESS <REVENUE>EXPENDITURE 178,771.00 (417,849.36) 596,620.36 {253~730.44) (775,909.18) 522,178.74 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 178,7~1.00 (417,849.36) 596,620.36 (253,730.44) (775,909.18) 522,178.74 THECITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES . FOR THE PERIOD 07/01/2002 THROUGH 05/31/2003 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ USES/MONEY & PROP-INTEREST TOTAL REVENUE *************************** GENERAL GOVERNMENT ACTIVITIES: NON-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 TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 20.00 (20.00)