The URL can be used to link to this page

Home My WebLink About4.08 Fin Rpt Feb 2003 CITY CLERK File# AGENDA STATEMENT CITY COUNCIL MEETING DATE: March '18, 2003 SUBJECT: Financial Reports For the Month of February 2003 Report Prepared by: Carole A. Perry, Administrative Services Director and Fred Marsh, Finance Manager ATTACHMENTS: 1. YTD Revenues and Budget Comparison d0,4~ 2. YTD Expenses and Budget Comparison 3. Financial Statements for the Month of February 2003 RECOMMENDATIO~)~ Receive the reports. FINANCIAL STAT~T: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary financial statements for the month of February. The budget changes presented in the Mid Year Financial Report and approved at the City Council Meeting on February 4, 2003 are included in this report. 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 February 2003 Revenue and Expenditure Report The February report represents the reporting of revenues and expenditures for the first eight months of the Fiscal Year. It should be noted that there is not an even distribution of revenues and expenditures on a monthly basis. Major amounts of Property Taxes and Sales Taxes are not received until later in the Fiscal Year. There is also a lag with the reporting of expenditures due to the significant amount of services provided to the City by independent contractors. Additional Impacts resulting from Passage of State Budget for Fiscal Year 2002/2003 As previously reported in the Mid Year Report to Council on February 4th, and as currently budgeted by the State, the City expects 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,747.80 from the State for the City's Booking Fee Reimbursements was received in November 2002. The State budget condition remains uncertain. Of critical importance continues to be the Motor Vehicle in Lieu Fees (VLF). For the City, VLF comprises $1,937,000 million of the City's General Fund revenue. About $1.4 million represents the "backfill" portion that is funded by the State. Governor Davis has already vetoed one bill that would have restored the Vehicle License Fee to the amount assessed in 1999. However, there is an alternative proposal afoot that makes no cuts to local government VLF revenues. Whether or not this budget option will be approved is still unknown. Staff will continue to COPIES TO: 4.~ G:~Monthly Finaneials~22003 agenda statement monthly finan¢ials.doe ITEM NO. monitor the situation and will report back to Council any subsequent adjustments to the State's budget that have a direct financial impact on the City. General Fund Revenues Total General Fund Revenues collected through February are comparable to what occurred in the eighth month of the previous Fiscal Year. Through February 2003, the City has collected approximately 59% of the total budgeted General Fund Revenues compared to 53% in the prior Fiscal Year. Property Taxes are higher than in the same period of 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. Sales Tax is higher than in the same period of the prior year. The State has raised the amount of monthly sales tax advances to the City as a result of the increased sales activity within the City, primarily related to tax collections from motor vehicle sales. It should be noted that a major portion of the annual sales tax is a result of the Christmas retail season. The City will not receive data on this sales activity until April 2003. 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 are lower than in the same period of the prior year due to timing differences and lower than expected occupancy rates at some of the City's hotels. 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 and a higher cash balance. Initially all interest revenue is recorded in the General Fund and allocated to other funds on a pro rata basis twice a year. Charges for Services is lower than in the same period of the prior year due to a receipt of one time monies from AT&T for cable equipment in Fiscal Year 2001-2002. Fines and forfeitures are lower than in the prior year due to a decrease in traffic citation collections over the prior year. Other Revenues are lower than in the prior year due to reimbursements received in the prior year from DSRSD for work performed on the Dublin Boulevard Widening project. General Fund Expenditures Overall, through the month of February expenditures in the General Fund totaled approximately $12.5 million and represented approximately 34% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $1.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 February 2003 was comparable to the amounts expended for the same period in the prior Fiscal Year. Through February 2003, the City had expended 37% of the General Fund Operating Budget, compared to 44% in the prior Fiscal Year. Police is lower than in the same period of the prior year due to timing differences for the payment of contract police services. Other Public Safety is lower than in the same period of 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. 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. Also, as part of the preparation of the February Monthly Financials, Staff reclassified Library construction expenditures previously recorded in the General Fund to the Public Facility Impact Fee Fund (as previously discussed in the Mid-year Budget Report presented to Council on February 4, 2003). In addition, 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, including the Geographic Information System, Civic Center HVAC, Downtown Improvement Implementation, Shannon Community Center Decking & Exterior Painting, Senior Center and Dublin Boulevard Undergrounding of Utilities. 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 February 28, 2003 Total General Fund Revenues Property Taxes Sales Taxes 65% · FY 2002/2003 Real Property Transfer Tax [] FY 2001/2002 Transient Occupancy Taxes Franchise Taxes 107% Licenses and Permits 146o/, 90% Interest and Rentals 15: %o 63% Intergovernmental from State 60% Charges for Services Fines and Forfeitures Other Revenues 0% 30% . 60% 90% 120% 150% 67% of Year Complete FY 2002~03 FY 2002~03 % of FY 2001102 % of Total for Budget YTD Actual Budget YTD Actual FY 2001/02 Property Taxes 9,892,843 4,759,016 48% 3,587,733 41% Sales Taxes 12,702,000 8,264,650 65% 7,548,908 59% Real Property Transfer Tax 415,000 206,538 50% 242,224 56% Transient Occupancy Taxes 858,000 418,016 49% 434,453 54% Franchise Taxes 1,493,900 545,221 36% 569,217 41% Licenses and Permits 1,622,404 1,741,986 107% 1,080,248 46% Interest and Rentals 1,373,538 1,231,088 90% 1,026,006 53% Intergovernmental 2,096,165 1,326,371 63% 1,248,992 60% Charges for Services 4,815,035 2,596,804 54% 2,568,909 58% Fines and Forfeitures 114,000 61,000 54% 76,578 65% Other Revenues 742,768 202,347 27% 382,648 78% Total General Fund Revenues 36,125,653 21,353,037 59% 18,765,916 53% .... Prinled: ~2oo3 9:28~M ATTACH M ENT 1 City of Dublin 2002-2003 YTD Expenses and Budget Comparison For the Period Ending February 28, 2003 Total General Fund 34°~o Expenses 148% General Government Police 30% Fire 24% Other Public Safety [3{ % · FY 2002/03 -- ,.,,,,~--~0:~ [] FY 2001/02 Transportation l~ 49o Health and Welfare 56% Culture & Community Services Community 53% Development 59% Capital Improv. 2q % Projects 166% 0% 20% 40% 60% 80% 100% 67% 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 General Government 4,420,521 2,466,908 56% 2,142,074 55% Police 7,876,674 611,308 8% 2,019,837 30% Fire 5,108,279 1,396,205 27% 1,314,908 28% Other Public Safety 313,858 76,862 24% 87,731 36% Transportation 1,337,221 675,232 50% 576,004 53% Health and Welfare 69,001 25,922 38% 25,496 49% Culture and Community Services 4,740,119 2,674,112 56% 2,216,072 55% Community Development 5,824,070 3,0851572 53% 2,734,827 59% Capital Improvement Projects 7,321,648 1,510,797 21% 3,837,356 66% Total General Fu nd Expenses 37,011,391 12,522,918 34% 14,954,305 48% General Fund Operating Expenses 29,689,743 11,012,121 37% 11,116,949 44% .................... 29 ~ ATTACH M E NT 2 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF FEBRUARY 2003 Prepared by The Finance Department March 4, 2003 ATTACHMENT 3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 28Feb2003 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 (43,473,181) 3,111,808 426,198 33,591,130 75,705 (6,268,400) (24,366,292) CASH WITH FISCAL AGENT 171,289 171,289 167,304 AMOUNT HELD IN ESCROW 109.300 INVESTMENTS AT COST 93.290,046 93.290.046 88,925,895 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 13,792 13.792 14.848 FIXED ASSETS AMOUNT TO BE PROVIDED 1,553.500 1.553.500 1.652.500 TOTAL ASSETS 50.512.123 3.473,511 426,138 33.591.130 1.800.494 89.803.396 66.974.066 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (711.473) (711.473) (680,392) DEPOSITS FOR AB1600 FEES (6.332) (5.745,688) (5,752.020) (24.306,291) DEPOSITS OTHERS (896,958) (896.958) (543.375) PAYABLES: ACCOUNTS (169.640) (126,161) (138,279) (434.080) (268,433) INTEREST PAYROLL (405,847) (405.847) (327,037) DUE TO OTHERS (31.326) (31,326) (26.476) DEFERRED REVENUE (127.768) (127,768) (146,433) DEBT INSTRUMENTS PAYABLE (1.671.000) (1.671.000) (1.770,000) TOTAL LIABILITIES (2,349,344) (126,161) (5.883,967) (1.671.000) (10.030.471) (28,068.438) FUND BALANCES (48,162.780) (3,347,350) (426.138) (27,707,163) (129,494) (79,772,925) (38,211.664) TOTAL FUND E (48.162.780) (3,347,350) (426.138) (27,707,163) (129.494) (79,772,925) (38,211,664) TOTAL LIABILITIES/EQUITY (50.512.123) (3,473.511) (426,138) (33.591,130) (1,800,494) (89,803.396) (66,280.101) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 28Feb2003 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,606,228 (20) 6,606,208 5,933,073 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,614.106 50,614.106 41.550.537 TOTAL ASSETS 42,790.187 (20) 12.492.387 50.614,106 105.896,660 85.620,083 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS (1) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (50.614.106) (50,614.106) (41,550.537) TOTAL LIABILITIES (50,614.106) (50,614.106) (41,550.538) FUND BALANCES (42,790,187) 20 (12.492.387) (55,282.554) (43.505.056) TOTAL FUND'E (42,790.187) 20 (12.492.387) (55.282.554) (43.505,056) TOTAL LIABILITIES/EQUITY (42,790,187) 20 (12.492.387) (50.614.106) (105,896.660) (85.055.594) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 02/28/2003 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES 9,892,843.00 4,759.015.58 5,133,827.42 8,794,710.89 3,587,732.94 5,206,977.95 SALES TAX 12,702,000.00 8,264,649.56 4.437,350.44 12,813.111.10 7,548,907.80 5,264,203.30 REAL PROPERTY TRANSFER TAX 415,000.00 206,538.28 208,461.72 434,832.20 242,224.14 192,608.06 HOTEL TRANSIENT OCCUPANCY TAX 858,000.00 418,016.33 439,983.67 810,219.79 434,452.61 375,767.18 FRANCHISE TAXES 1,493,900.00 545,220.67 948,679.33 1,385,815.52 569,216.96 816,598.56 LICENSES & PERMITS 1,622,404.00 1,741,985.55 (119.581.55) 2,327,250.77 1,080,247.61 1,247,003.16 FINES & FORFEITURES 114,000.00 60,999.83 53 000.17 118,190.93 76,578.41 41,612.52 USE/MONEY & PROP-INTEREST 1,244.226.00 1,160,062.42 84 163.58 1,843,673.66 982,144.14 861,529.52 USE/MONEY & PROP-RENTALS 129,312.00 71,025.95 58 286.05 85,936.82 43,862.20 42.074.62 INTERGOVERNMENTAL 2,096,165.00 1,326,371.47 769 793.53 2,076,648.50 1,248,992.22 827,656.28 CHARGES FOR SERVICES 4,815,035.00 2,596,804.35 2,218 230.65 4,464,259.66 2,568,908.93 1,895,350.73 OTHER SOURCES OF REVENUE 742,768.00 202,346.92 540 421.08 493,722.65 382,648.21 111,074.44 TOTAL REVENUE 36,125,653.00 21,353,036.91 14,772 616.09 35,648,372.49 18,765,916.17 16,882,456.32 *******EXPENDITURES******* GENE~L GOVERNMENT ACTIVITIES: CITY COUNCIL 212,932.00 145,618.19 67 313.81 217,946.55 158.352.78 59,593.77 CITY MANAGER 739,518.00 471,618.25 267 899.75 560,359.16 299,723.20 260,635.96 CENTRAL SERVICES 319,600.00 183,924.80 135 675.20 297,049.71 207,346.14 89,703.57 CITY ATTORNEY 686,076.00 454,209.24 231 866.76 764,484.52 415,310.62 349,173.90 ADMIN SERVICES 1,038,223.00 613,115.03 425 107.97 922,865.72 556,926.29 365,939.43 BUILDING MANAGEMENT 731,567.00 413,999.17 317 567.83 657,327.17 345,410.95 311,916.22 INSURANCE COST CENTER 386.665.00 173,754.16 212 910.84 385,395.68 147,939.78 237,455.90 ELECTIONS COST CENTER 20,940.00 t0,668.84 10 271.16 14,507.57 1,064.30 13,443.27 NON-DEPARTMENTAL 285,000.00 285 000.00 109,981.56 10,000.00 99,981.56 ACTIVITY TOTAL 4,420,52t.00 2,466,907.68 1,953 613.32 3,929,917.64 2,142,074.06 1,787,843.58 PUBLIC SAFETY POLICE 7.876,674.00 611,307.89 7,265,366.11 6,668,234.72 2,019,837.07 4,648,397.65 CROSSING GUARDS 71,462.00 30,104.31 41,357.69 56,677.08 27,228.57 29,448.51 ANIMAL CONTROL 181,437.00 t4,741.97 166,695.03 138,935.98 32,068.87 106,867.11 DISASTER PREPAREDNESS 60,959.00 32,015.73 28.943.27 46,012.48 28,433.13 17,579.35 FIRE SERVICES 5.108,279.00 1,396,205.43 3,712,073.57 4,698,607.54 1,314,907.97 3,383,699.57 ACTIVITY TOTAL 13,298,811.00 2,084,375.33 11,214,435.67 11,608,467.80 3,422,475.61 8,185,992.19 T~NSPORTATtON PUBLIC WORKS 616,631.00 381,658.55 234.972.45 557,207.53 334,721.42 222,486.11 STREET MAINTENANCE 10,427.00 5,973.33 4.453.67 6,406.00 617.55 5,788.45 STREET SWEEPING 132,100.00 64,049.78 68,050.22 132,383.34 63,333.26 699050.08 STREET TREE MAINTENANCE 70,337.00 22,792.10 47,544.90 51,079.02 20,147.64 30,931.38 STREET LANDSCAPING MAINTENAN 507,726.00 200,757.79 306,968.21 347,022.86 157,184.25 189,838.61 ACTIVITY TOTAL 1,337,221.00 675,231.55 661,989.45 1,094,098.75 576,004.12 518,094.63 HEALTH & WELFARE WASTE MANAGEMENT 8,242.00 3,551.78 4,690.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 02/28/2003 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE CHILD CARE 15,000.00 9,158.03 5.841.97 15,000.00 6,629.00 8,371.00 SOCIAL SERVICES 6,000.00 6,000.00 HOUSING PROGRAMS 39,759.00 7,21t.74 32,547.26 35,209.87 18,820.50 16,389.37 ACTIVITY TOTAL' 69,001.00 25,921.55 43,079.45 52,017.25 25,495.88 26,521.37 CULTURE & LEISURE SERVICES LIBRARY SERVICES 496 219.00 239,659.00 256,560.00 376,276.00 200,362.50 175 913.50 CULTURAL ACTIVITIES 137 153.00 88,262.06 48,890.94 119,409.29 96,591.29 22 818.00 HERITAGE CENTER 90 771.00 54,184.16 36,586.84 69.081.56 42,196.58 26 884.98 DUBLIN CEMETERY 37 418.00 15,697.07 21,720.93 30.077.98 15,146.27 14 931.71 PARK MAINTENANCE 1,263 230.00 637,198.52 626,031.48 1,086,713.48 542.385.33 544 328.15 COMMUNITY TV 70 906.00 71 764.86 (858.86) 80,087.02 58,067.95 22019.07 RECREATION ADMIN 453 444.00 277 776.17 175,667.83 374,416.72 212.124.45 162 292.27 PLAYGROUNDS 261 690.00 140 846.95 120,843.05 207,515.47 122,259.58 85255.89 SHANNON CENTER 270 182.00 161 230.29 108,951.71 250.834.31 141,954.72 108 879.59 PRESCHOOL 79 421.00 47 417.27 32,003.73 57.470.25 34,015.35 23,454.90 TEENS PROGRAM 113 854.00 59 758.40 54,095.60 106,183.40 56,817.63 49,365~77 ADULT SPORTS 95061.00 57 654.62 37,406.38 76,886.84 43,895.89 32,990.95 YOUTH SPORTS 96743.00 62 580.01 34,162.99 82,402.67 47,229.09 35,173.58 COMMUNITY GYM 35 167.00 20 018.22 15,148.78 23,572.33 10,661.63 12,910.70 SPECIAL EVENTS 349 589.00 206 758.88 142,830.12 314,735.18 169,204.88 145,530.30 SENIOR CENTER 190215.00 104 128.95 86,086.05 146,824.25 82,643.43 64,180.82 RECREATION INSTRUCTION 143 005.00 100 776.18 42,228.82 145,8t2.50 89,699.46 56,113.04 AQUATICS 332691.00 196 373.23 136,317.77 322,391.18 183,056.83 139.334.35 PARKS/FACILITIES MANAGEMENT 223 360.00 132 026.95 91,333.05 142,041.19 67,759.39 74,281.80 ACTIVITY TOTAL 4,740,119.00 2,674,111.79 2,066,007.21 4,012,731.62 2,216,072.25 1,796,659.37 COMMUNITY DEVELOPMENT PLANNING 2,021,188.00 1,009,797.94 1,011,390.06 1,486,541.67 877,949.94 608,591.73 BUILDING SAFETY 1,603,701.00 775,128.75 828,572.25 1,276,343.20 719,426.55 556,916.65 ENGINEERING 1,902,477.00 1,081,604.22 820,872.78 1,609,544.48 939,551.28 669,993.20 ECONOMIC DEVELOPMENT 296,704.00 219,041.07 77,662.93 271,222.90 197,899.66 73,323.24 ACTIVITY TOTAL 5,824,070.00 3,085,571.98 2,738,498.02 4,643,652.25 2,734,827.43 1,908,824.82 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 2,911,288.30 993,551.38 1,917,736.92 4,582,889.35 3,029,120.27 1,553,769.08 COMMUNITY IMPROVEMENTS 1,814,645.00 188,423.48 1,626,221.52 273,283.82 112,079.14 161,204.68 PARKS 1,598,896.00 188,035.40 1,4t0,860.60 351,854.08 342,083.72 9,770.36 STREET CONSTRC/IMPROVEMENTS 996,819.00 140,786.96 856,032.04 580,008.92 354,072.76 225,936.16 ACTIVITY TOTAL 7,321,648.30 1,510,797.22 5,810,851.08 5,788,036.17 3,837,355.89 1,950,680.28 TOTAL EXPENDITURES 37,011,391.30 12,522,917.10 24,488,474.20 31,128,921.48 14,954,305.24 16,174,616.24 EXCESS REVENUE (EXPENDITURES) (885,738.30) 8.830,119.81 (9,715,858.11) 4,519,451.01 3,811.610.93 707,840.08 TRANSFERS IN FROM OTHER FUNDS 6,600.00 (6,600.00) 16,784.89 16,784.89 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES (885,738.30) 8.836,719.81 (9,722,458.11) 4,536.235.90 3,8tl,6t0.93 724,624.97 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 02/28/2003 SPECIAL REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** PROPERTY TAXES 93,610.00 51,268.30 42,341.70 91,099.68 45,429.96 45,669.72 SALES TAX/OTHER TAXES 317,700.00 231,231.53 86,468.47 206,812.62 116,843.81 89.968.81 FINES & FORFEITURES 153,000.00 74,222.75 78,777.25 149,023.41 70,892.91 78.130.50 USES/MONEY & PROPERTY 50,995.00 46,054.73 4,940.27 135,432.87 63,876.34 71,556.53 INTERGOVERNMENTAL FROM STATE 4,518,386.00 3,472,390.67 1,045,995.33 1,601,090.43 572,081.54 1,029,008.89 INTERGOVERNMENTAL FROM COUNTY 240,909.00 102,814.50 138,094.50 241,589.50 106,732.00 134,857.50 INTERGOVERNMENTAL FROM FEDERAL 242,461.00 65,563.31 176,897.69 782,793.26 24,398.80 758,394.46 CHARGES FOR SERVICES 885,779.00 458,063.84 427,715.16 865,790.08 430,184.18 435.605.90 OTHER SOURCES OF REVENUE 5,000.00 1,939.28 3,060.72 30,997.14 15,525.13 15,472.01 TOTAL REVENUE 6,507,840.00 4,503,548.91 2,004.291.09 4.104,628.99 1,445.964.67 2,658,664.32 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 218,727.00 38,968.92 179,758.08 377,390.53 131,552.45 245,838.08 TRAFFIC SIGNALS & STREET LTG 145,900.00 67,905.25 77,994.75 145,399.20 53,769.84 91,629.36 FIRE SERVICES 213,873.00 51,160.25 162,712.75 193,800.29 55,413.89 138,386.40 ACTIVITY TOTAL 578,500.00 158,034.42 420,465.58 716,590.02 240,736.18 475,853.84 TRANSPORTATION: STREET MAINTENANCE 219,619.00 87,678.83 131,940.17 209,801.34 79,054.24 130,747.10 STREET SWEEPING ACTIVITY TOTAL 219,619.00 87,678.83 131,940.17 209.801.34 79,054.24 130,747.10 HEALTH & WELFARE: WASTE MANAGEMENT 1,079,569.00 506,956.38 572,612.62 1,030,807.37 520,750.50 510,056.87 SOCIAL SERVICES 28,427.00 16,449.14 11,977.86 7,500.00 3,750.00 3,750.00 HOUSING PROGRAMS 9,999.54 2,496.40 7,503.14 ACTIVITY TOTAL 1,107,996.00 523,4~5.52 584,590.48 1,048,306.91 526,996.90 521,310.01 COMMUNITY DEVELOPMENT: ENGINEERING 6,000.00 1,407.00 4,593.00 6,000.00 2,398.50 3.601.50 ACTIVITY TOTAL 6,000.00 1,407.00 4,593.00 6.000.00 2,398.50 3.601.50 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS 36,782.00 36,782.00 73,425.55 19,958.55 53.467.00 PARKS 426,095.00 292,132.00 133,963.00 STREET CONSTRUCTION/IMPROVEMENT 4,945.626.00 1,753,124.14 3,192,501.86 2,259,994.81 1,758,121.04 501.873.77 ACTIVITY TOTAL 5,408,503.00 2,045,256.14 3,363,246.86 2,333,420.36 1,778,079.59 555,340.77 T 0 T A L EXPENDITURES 7,320,618.00 2,815,781.9t 4,504,836.09 4,314,118.63 2,627,265.41 1,686,853.22 EXCESS <REVENUE>EXPENDITURE 812,778.00 (1,687,767.00) 2,500,545.00 209,489.64 1,181,300.74 (971,811.10) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 856,531.16 (856,531.16) 16,784.89 16,784.89 EXCESS <REVENUE> EXPENDITURE 8t2,778.00 (831,235.84) 1,644,013.84 226,274.53 1,181,300.74 (955,026.2t) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 02/28/2003 SPECIAL ASSESSMENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ SPECIAL BENEFITS ASSESSMENTS 536,364.00 247,790.91 288,573.09 431,564.21 217,332.02 214,232.19 USES/MONEY & PROP-INTEREST 13,888.00 6,787.02 7,100.98 20,738.74 9,125.20 11,613.54 OTHER SOURCES OF REVENUE 4,000.00 5,070.54 (1,070.54) 1,995.50 1,995.50 TOTAL REVENUE 554,252.00 259,648.47 294,603.53 454,298.45 228,452.72 225.845.73 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 274,300.00 105,042.94 169,257.06 198.138.51 95,645.21 102,493.30 ACTIVITY TOTAL 274,300.00 105,042.94 169,257.06 198,138.51 95,645.21 102,493.30 TRANSPORTATION PUBLIC WORKS 4,754.00 1,046.27 3,707.73 3,277.32 2,554.47 722.85 STREET TREE MAINTENANCE 15,944.00 5,140.21 10,803.79 7,713.24 3.543.34 4,169.90 STREET LANDSCAPE MAINTENANCE 292,861.00 157,761.59 135,099.41 231,458.34 122.156.69 109.301.65 ACTIVITY TOTAL 313,559.00 163,948.07 149,610.93 242,448.90 128,254.50 114,194.40 COMMUNITY DEVELOPMENT ENGINEERING 16,250.00 8,709.56 7,540.44 20,071.01 10,220.76 9,850.25 ACTIVITY TOTAL 16,250.00 8,709.56 7,540.44 20,071.01 t0,220.76 9,850.25 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 277,700.57 428,408.43 460,658.42 234,120.47 226,537.95 EXCESS <REVENUE>EXPENDITURE 151,857.00 t8,052.10 133,804.90 6,359.97 5,667.75 692.22 EXCESS <REVENUE>EXPENDITURE 151,857.00 18,052.10 133,804.90 6,359.97 5,667.75 692.22 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 02/28/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 690,013.13 414,071.87 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 690,013.13 11,594,476.87 21,429,251.97 766,333.51 20,662,918.46 ************************** GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 12,950.00 8,153.46 4,796.54 ACTIVITY TOTAL 12,950.00 8,153.46 4,796.54 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 494,797.00 76,352.22 418.444.78 96,133.06 30,468.33 65,664.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 7,144,413.44 7,619,801.99 4,324.162.75 452,780.18 3,871,382.57 COMMUNITY IMPROVEMENTS PARKS 3,416,077.00 965.033.46 2,451,043.54 125,589.57 13,125.00 112,464.57 STREET CONSTRUCTION/IMPROVEMENT 19,770,575.00 5,105.104.07 14.665.470.93 4,085,145.94 2,194,609.74 1,890,536.20 ACTIVITY TOTAL 37,950,867.43 13,214,550.97 24,736,316.46 8,534,898.26 2,660,514.92 5,874,383.34 T 0 T A L EXPENDITURES 38,458,614.43 13,301,617.96 25,156,996.47 8,639,616.93 2,699,381.82 5,940,235.11 EXCESS <REVENUE>EXPENDITURE 26,174,124.43 12,611,604.83 13,562,519.60 (12,789,635.04) 1,933,048.31 (14,722,683.35) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 26,174,124.43 12.611,604.83 13,562,519.60 (12,789,635.04) 1,933,048.3t (14,722,683.35) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 02/28/2003 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ SPECIAL ASSESSMENTS 118,659.03 (118,659.03) 237,264.42 118,632.21 118,632.21 USES/MONEY & PROP-INTEREST 1,898.30 (1,898.30) 8,099.29. t,767.78 6,331.51 TOTAL REVENUE 120,557.33 (120,557.33) 245,363.71 120,399.99 124,963.72 ************************** GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 229,828.00 231,594.42 (1,766.42) 233,733.39 230,965.31 2,768.08 ACTIVITY TOTAL 229,828.00 231,594.42 (1,766.42) 233,723.39 230,965.31 2,768.08 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 229,828.00 231,594.42 (1,766.42) 233,723.39 230,965.31 2,768.08 EXCESS <REVENUE>EXPENDITURE 229,828.00 111,037.09 1t8.790.91 (11,630.32) 110,565.32 (122,195.64) EXCESS <REVENUE>EXPENDITURE 229,828.00 111,037.09 118,790.91 (11,630.32) 110,565.32 (122,195.64) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 02/28/2003 INTERNAL SERVICE FUNDS CURRENT CURRENT- PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** USES/MONEY & PROP-INTEREST 227,059.00 111,500.94 115,558.06 262,597.72 121.730.05 140,867.67 CHARGES FOR SERVICES 1,367,268.00 773,567.79 593,700.21 1,103,647.14 748,222.23 355,424.91 OTHER SOURCES OF REVENUE 20.000.00 13,560.00 6,440.00 22,267.13 19,744.05 2,523.08 TOTAL REVENUE 1,614,327.00 898,628.73 715.698.27 1,388.511.99 889.696.33 498,815.66 ************************** GENE~L GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 1,741,280.00 580,879.98 1,160,400.02 1,092,881.67 303.817.48 789,064.19 ACTIVITY TOTAL 1,741,280.00 580.879.98 t,160,400.02 1.092,881.67 303.817.48 789,064.19 PUBLIC SAFETY: FIRE 51,818.00 24,747.47 27,070.53 41,899.88 21.390.09 20,509.79 ACTIVITY TOTAL 51,818.00 24,747.47 27,070.53 41,899.88 21.390.09 20,509.79 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1.793,098.00 605,627.45 1,187,470.55 1.134.781.55 325,207.57 809,573.98 EXCESS <REVENUE>EXPENDITURE 178,771.00 (293,001.28) 471,772.28 (2531730.44) (564,488.76) 310,758.32 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 178,771.00 (293,001.28) 471,772.28 (253,730.44) (564,488.76) 310,758.32 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 02/28/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)