Loading...
HomeMy WebLinkAboutItem 4.14 FinRpts Jan2003 CITY CLERK File # AGENDA STATEMENT CITY COUNCIL MEETING DATE: February 18, 2003 SUBJECT: Preliminary Financial Reports For the Month of January 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 January 2003 RECOMMENDATIO~ ~A~Receive the reports. FINANCIAL STATEME-~T: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary financial statements for the month of January. The budget -changes presented in the Mid Year Financial Report and approved at the City Council Meeting on February 4, 2003 will be included in the February 2003 report. The final audited results for Fiscal Year 2001/2002 will be presented to the Council in March; therefore, this report is presented as "Preliminary" at this time. 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. Preliminary Reporting of Information The auditors are completing the final phase of the fieldWork necessary for the 2001/2002 audit. The final audit results will impact the reported Fund Balance presented in the attached monthly reports. The scope of any remaining final entries will not be significant when compared to all general fund revenues and expenses. Analysis of Preliminary January, 2003 Revenue and Expenditure Report The January report represents the reporting of revenues and expenditures for the first seven 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 the Gas Taxes, booking fee reimbursements and motor vehicle in lieu fees from the Department of Motor Vehicles. It should be noted that the $100,000 revenue budgeted for the Citizen's Option for Public Safety (COPS) grant for Fiscal Year 2002/2003 was received at the end of October 2002. COPIES TO: G:XNIonthly Financials\12003 agenda statement monthly finaneiats.doe ITEM NO. The State budget situation is still precarious. Of critical importance continues to be the motor vehicle in lieu fees (VLF). Governor Davis has vetoed a bill that would have restored the Vehicle License Fee to the amount assessed in 1999. 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. Since the final outcome regarding the VLF is still unknown, no budget adjustments are being proposed at this time. Staff will remain vigilant and will report back to Council any subsequent adjustments to the State's budget that have a direct financial impact to the City. General Fund Revenues Total General Fund Revenues collected through January are comparable' to what occurred in the seventh month of the previous Fiscal Year. Through January 2003, the City has collected approximately 52% of the total budgeted General Fund Revenues compared to 47% 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, for which the City will not receive data 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, an increase in market value on the City's investments, 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. Miscellaneous 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 January expenditures in the General Fund totaled approximately $15.4 million and represented approximately 38% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $5.3 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 January 2003 was comparable to the amounts expended for the same period in the prior Fiscal Year. Through January 2003, the City had expended 38% of the General Fund Operating Budget, compared to 42% 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 higher than in the same period of the prior year due to payment for contract senior support services in the current year. 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, 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 January 31, 2003 Total General Fund Revenues Property Taxes Sales Taxes % · FY 2002/2003 [] FY 2001/2002 Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services Fines and Forfeitures 25% Other Revenues 0% 30% 60% 90% 120% 150% 58% 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 4,759,016 48% 3,587,733 41% Sales Taxes 12,702,000 6,933,950 55% 6,429,808 50% Real Property Transfer Tax 415,000 166,492 40% 196,151 45% Transient Occupancy Taxes 858,000 365,355 43% 395,674 49% Franchise Taxes 1,493,900 415,786 28% 519,750 38% Licenses and Permits 1,622,404 1,686,689 104% 945,828 41% Interest and Rentals 1,373,538 1,061,730 77% 1,004,749 52% Intergovernmental 2,096,165 1,127,856 54% 1,073,325 52% Charges for Services 4,815,035 2,126,214 44% 2,282,952 51% Fines and Forfeitures 114,000 53,351 47% 67,876 57% Other Revenues 742,768 182,941 25% 376,431 76% Total General Fund Revenues 36,125,653 18,879,380 52% 16,880,277 47% ATTACHMENT City of Dublin 2002-2003 YTD Expenses and Budget Comparison For the Period Ending January 31, 2003 Total General Fund 38% Expenses 42% General Government Police ] 29% 27% Fire 27% Other Public Safety · FY 2O02/03 44% [] FY 200'1/02 Transportation 46% 35% Health and Welfare 35% Culture & Community Services Community Development Capital Improv, Projects I I 5~% 0% 20% 40% 60% 80% 100% 58% of Year Complete FY 2002/03 FY 2002/03 % of FY 2001i02 % of Total for Budget YTD Actual Budget YTD Actual FY 2001/02 General Government 4,393,521 2,249,401 51% 1,850,410 47% Police 7,876,674 564,417 7% 1,949,352 29% Fire 5,108,279 1,384,192 27% 1,286,713 27% Other Public Safety 313,858 54,050 17% 79,045 33% Transportation 1,337,221 591,993 44% 506,009 46% Health and Welfare 69,001 24,322 35% 18,431 35% Culture and Community Services 4,740,119 2,433,688 51% 1,890,511 47% Community Development 5,784,070 2,715,248 47% 2,328,771 50% Capital Improvement Projects 11,362,877 5,395,052 47% 3,311,322 57% Total General Fund Expenses 40,985,620 15,412,363 38% 13,220,564 42% General Fund Operating Expenses 29,622,743 10,017,311 34% 9,909,242 39% ATTACHMENT 2 Date Printed: 2J5/2003 2:32. PM CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JANUARY 2003 Prepared by The Finance Department February 5, 2003 ATTACHMENT 3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Jan2003 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 (48,572,242) 3,349,375 459,667 39,289,798 135,363 (5,338,039) (24,404,646) CASH WITH FISCAL AGENT 171,289 171,289 167,304 109,300 AMOUNT HELD IN ESCROW INVESTMENTS AT COST 93,168,169 93,168,169 89,784,895 RECEIVABLES: TAXES ACCOONTS 138,985 361,702 500,688 157,651 INTEREST 542,481 542,481 312,860 ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 14,006 14,006 5,549 FIXED ASSETS AMOUNT TO BE PROVIDED 1,553,500 1,553,500 1,652,500 TOTAL ASSETS 45,291,400 3,711,077 459,667 39,289,798 1,860,152 90,612,093 67,785,412 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (853,579) (853,579) (730,695) DEPOSITS FOR AB1600 FEES (46,739) (5,992,478) (6,039,218) (24.256,951) DEPOSITS OTHERS (896,192) (896,192) (435,795) PAYABLES: ACCOUNTS (147,030) (114,928) (117,234) (379,t92) (260,646) iNTEREST PAYROLL (397,304) (397,304) (322,962) DUE TO OTHERS (29,712) (29,712) (t7,376) DEFERRED REVENUE (127,768) (127,768) (146.433) DEBT INSTRUMENTS PAYABLE (1,671,000) (1,671,000) (1,770,000) TOTAL LIABILITIES (2,498,324) (114,928) (6,109,712) (1,671,000) (t0,393,965) (27,940,858) FUND BALANCES (42,793,075) (3,596,149) (459,667) (33,180,085) (189,152) (80,218,129) (39,844,554) TOTAL FUND E (42,793,075) (3,596,149) (459,667) (33,180,085) (189,152) (80,218,129) (39,844,554) TOTAL LIABILITIES/EQUITY (45,291,400) (3,711.077) (459,667) (39,289,798) (1,860,t52) (90,612,093) (67,785,412) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Jan2003 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,626,185 (20) 6,626,165 5,894,653 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,624,278 50,624,278 41,550,537 TOTAL ASSETS 42,810,144 (20) 12,492,387 50,624,278 105,926.789 85,581,663 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS (1) PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (50,624,278) (50,624,278) (41,550,537) TOTAL LIABILITIES (50,624.278) (50,624,278) (41,550,538) FUND BALANCES (42.810,144) 20 (12,492.387) (55,302,511) (44,031,125) TOTAL FUND E (42,810,144) 20 (12,492,387) (55,302,51Z) (44.031.125) TOTAL LIABILITIES/EQUITY (42,810,144) 20 (12,492,387) (50,624.278) (105,926,789) (85,581,663) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 01/31/2003 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** 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 6,933,949.56 5,768,050.44 12,813,111.10 6,429,807.80 6,383,303.30 REAL PROPERTY TRANSFER TAX 415,000.00 166,492.33 248,507.67 434,832.20 196,151.29 238,680.91 HOTEL TRANSIENT OCCUPANCY TAX 858,000.00 365,355.36 492,644.64 810,219.79 395,674.06 414,545.73 FRANCHISE TAXES 1,493,900.00 415,786.21 1,078,113.79 1,385,815~52 519,749.96 866,065.56 LICENSES & PERMITS 1,622,404.00 1,686,689.38 (64,285.38) 2,327,250.77 945,828.28 1,381,422.49 FINES & FORFEITURES 114,000.00 53,350.63 60,649.37 118,190.93 67,876.47 50,314.46 USE/MONEY & PROP-INTEREST 1,244,226.00 1,003,928.82 240,297.18 1,843,673.66 965,036.51 878,637.15 USE/MONEY & PROP-RENTALS 129,312.00 57,800.62 71,511.38 85,936.82 39.7tl.80 46,225.02 INTERGOVERNMENTAL 2,096,165.00 1,127,856.30 968,308.70 2,076,648.50 1,073,325.20 1,003,323.30 CHARGES FOR SERVICES 4,815,035.00 2,126,213.86 2,688,82t.14 4,464,259.66 2,282,952.01 2,181,307.65 OTHER SOURCES OF REVENUE 742,768.00 182,940.86 559,827.t4 493,722.65 376,431.tl 117,291.54 TOTAL REVENUE 36,125,653.00 18,879,379.51 17,246,273.49 35,648,372.49 16,880,277.43 18,768,095.06 ************************** GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 212,932.00 136.31t.69 76,620.31 217,946.55 122,003.43 95,943.12 CITY MANAGER 739,518.00 417,451.36 322,066.64 560,359.16 260,837.32 299,521.84 CENTP, AL SERVICES 319,600.00 164,363.76 155,236.24 297,049.71 165,921.93 131,127.78 CITY ATTORNEY 659.076.00 453,681.21 205,394.79 764,484.52 377,294.01 387.190.51 ADMIN SERVICES 1,038,223.00 548,920.00 489,303.00 922,865.72 491,651.18 431,214.54 BUILDING MANAGEMENT 731,567.00 352,996.67 378,570.33 657,327.17 286,907.79 370,419.38 INSURANCE COST CENTER 386,665.00 165,007.57 221,657.43 385.395.68 134,729.75 250,665.93 ELECTIONS COST CENTER 20.940.00 10,668.84 10,271.16 14,507.57 1,064.30 13,443.27 NON-DEPARTMENTAL 285,000.00 285,000.00 109,98t.56 10,000.00 99,981.56 ACTIVITY TOTAL 4.393,521.00 2,249,401.10 2.144,119.90 3,929,917.64 1,850,409.71 2,079,507.93 PUBLIC SAFETY POLICE 7,876.674.00 564,416.96 7,312,257.04 6,668,234.72 1,949,352.27 4.718,882.45 CROSSING GUARDS 71,462.00 25,326.50 46,135.50 56,677.08 22.769.57 33,907.51 ANIMAL CONTROL 181,437.00 181,437.00 138,935.98 32,068.87 106,867.11 DISASTER PREPAREDNESS 60,959.00 28,723.77 32,235.23 46,012.48 24.206.71 21,805.77 FIRE SERVICES 5,108.279.00 1,384,192.34 3,724,086.66 4,698.607.54 1,286,712.60 3,411,894.94 ACTIVITY TOTAL 13.298,811.00 2,002,659.57 11,296,151.43 11,608,467.80 3,315,110.02 8,293.357.78 TRANSPORTATION PUBLIC WORKS 616,631.00 338,306.01 278,324.99 557,207.53 291,619.86 265,587.67 STREET MAINTENANCE 10.427.00 5.917.68 4,509.32 6,406.00 617.55 5,788.45 STREET SWEEPING 132.100.00 51,669.22 80,430.78 132,383.34 53,058.14 79.325.20 STREET TREE MAINTENANCE 70,337.00 20,589.50 49,747.50 51,079.02 18.559.10 32,519.92 STREET LANDSCAPING MAINTENAN 507,726.00 175.511.01 332,214.99 347,022.86 142,154.30 204,868.56 ACTIVITY TOTAL 1,337.221.00 591,993.42 745,227.58 1,094.098.75 506,008.95 588,089.80 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 01/31/2003 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T,D. VARIANCE CHILD CARE 15,000.00 7,558.81 7,441.19 15,000.00 4,485.00 10,515.00 SOCIAL SERVICES 6,000.00 6,000.00 HOUSING PROGRAMS 39,759.00 7,211.74 32,547.26 35,209.87 13,900.00 21,309.87 ACTIVITY TOTAL 69,001.00 24,322.33 44,678.67 52,017.25 18,431.38 33,585.87 CULTURE & LEISURE SERVICES LIBRARY SERVICES 496,219.00 239,659.00 256,560.00 376,276.00 100,181.25 276,094.75 CULTURAL ACTIVITIES 137,153.00 83,316.76 53,836.24 119,409.29 90,702.37 28,706.92 HERITAGE CENTER 90,771.00 48,356.94 42,414.06 69,081.56 36,972.65 32,108.91 DUBLIN CEMETERY 37,418.00 14,352.52 23,065.48 30,077.98 13,546.79 16,531.19 PARK MAINTENANCE 1,263,230.00 576,952.37 686,277.63 1,086,713.48 479,837.10 606,876.38 COMMUNITY TV 70,906.00 70,655.58 250.42 80,087.02 56,957.00 23,130.02 RECREATION ADMtN 453,444.00 247,729.74 205,714.26 374,416.72 182,319.17 192,097.55 PLAYGROUNDS 261,690.00 125,629.15 136,060.85 207,515.47 108,114.39 99,401.08 SHANNON CENTER 270,182.00 139,589.t2 130,592.88 250,834.31 122,156.46 128,677.85 PRESCHOOL 79,421.00 42,276.85 37,144.15 57,470.25 29,785.73 27,684.52 TEENS PROGRAM t13,854.00 50,949.21 62,904.79 106,183.40 52,651.15 53,532.25 ADULT SPORTS 95,061.00 52,118.09 42,942.91 76,886.84 38,376.98 38,509.86 YOUTH SPORTS 96,743.00 47,849.23 48,893.77 82,402.67 36,724.97 45,677.70 COMMUNITY GYM 35,167.00 18,300.40 16,866.60 23,572.33 9,308.12 14,264.21 SPECIAL EVENTS 349,589.00 194,915.73 154,673.27 314,735.18 161,969.65 152,765.53 SENIOR CENTER 190,215.00 91,862.44 98,352.56 t46,824.25 71,442.15 75,382.10 RECREATION INSTRUCTION 143,005.00 83,662.71 59,342.29 145,8t2.50 68,894.61 76,917.89 AQUATICS 332,691.00 188,316.3t 144,374.69 322,391.18 171,008.23 t51,382.95 PARKS/FACILITIES MANAGEMENT 223,360.00 117,195.39 106,164.61 142,041.19 59,562.21 82,478.98 ACTIVITY TOTAL 4,740,119.00 2,433,687.54 2,306,431.46 4,012,731.62 1,890,510.98 2,122,220.64 COMMUNITY DEVELOPMENT PLANNING 2,021,188.00 881,094.33 1,140,093.67 1,486,541.67 766,839.90 719,701.77 BUILDING SAFETY 1,563,701.00 703,609.17 860,091.83 1,276,343.20 587,262.41 689,080.79 ENGINEERING 1,902,477.00 921,270.74 981,206.26 1,609,544.48 786,174.18 823,370.30 ECONOMIC DEVELOPMENT 296,704.00 209,273.94 87,430.06 271,222.90 188,494.41 82,728.49 ACTIVITY TOTAL 5,784,070.00 2,715,248.18 3,068,821.82 4,643,652.25 2,328,770.90 2,314,881.35 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 6,952,517.30 4,999,047.98 1,953,469.32 4,582,889.35 2,686,164.71 1,896,724.64 COMMUNITY IMPROVEMENTS 1,814,645.00 167,538.94 1,647,106.06 273,283.82 45,825.26 227,458.56 PARKS 1,598,896.00 118,247.21 1,480,648.79 351,854.08 336,474.53 15,379.55 STREET CONSTRC/IMPROVEMENTS 996,819.00 110,217.81 886,601.19 580,008.92 242,857.66 337,151.26 ACTIVITY TOTAL 11,362,877.30 5,395,051.94 5,967,825.36 5,788,036.17 3,311,322.16 2,476,714.01 TOTAL EXPENDITURES 40,985,620.30 15,412,364.08 25,573,256.22 31,128,921.48 13,220,564.10 17,908,357.38 EXCESS REVENUE (EXPENDITURES) (4,859,967.30) 3,467,0t5.43 (8,326,982.73) 4,519,451.01 3,659,713.33 859,737.68 TRANSFERS IN FROM OTHER FUNDS 16,784.89 16,784.89 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES (4,859,967.30) 3,467,015.43 (8,326,982.73) 4,536,235.90 3,659,713.33 876,522.57 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 01/31/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 195,322.23 122,377.77 206,812.62 116.843.81 89,968.81 FINES & FORFEITURES 153,000.00 60,375.60 92.624.40 149,023.41 58,552.53 90,470~88 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 78,008.25 162.900.75 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 5,000.00 30,997.14 15,525.13 15,472.01 TOTAL REVENUE 6,507,840.00 4.427,046.93 2,080,793.07 4,104,628.99 1,433,624.29 2,671,004.70 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 205,727.00 38.455.39 167.271.61 377,390.53 129.267.68 248,122.85 TRAFFIC SIGNALS & STREET LTG 145,900.00 60,177.22 85,722.78 145,399.20 44,575.17 100,824.03 FIRE SERVICES 213,873.00 51,160.25 162,712.75 t93,800.29 55,413.89 138,386.40 ACTIVITY TOTAL 565,500.00 149,792.86 415,707.14 7t6,590.02 229.256.74 487,333.28 TRANSPORTATION: STREET MAINTENANCE 219,619.00 65,689.43 153,929.57 209,801.34 63,579.46 146,221.88 STREET SWEEPING ACTIVITY TOTAL 219,619.00 65,689.43 153,929.57 209,801.34 63,579.46 146,221.88 HEALTH & WELFARE: WASTE MANAGEMENT 1,079,569.00 506,956.38 572,612.62 1,030,807.37 4,167.84 1,026,639.53 SOCIAL SERVICES 28.427.00 11,043.17 17,383.83 7,500.00 1,875.00 5,625.00 HOUSING PROGRAMS 9,999.54 2,496.40 7,503.14 ACTIVITY TOTAL 1,107,996.00 517,999.55 589,996.45 1,048,306.91 8.539.24 1,039,767.67 COMMUNITY DEVELOPMENT: ENGINEERING 6,000.00 1,407.00 4,593.00 6,000.00 1,621.00 4,379.00 ACTIVITY TOTAL 6,000.00 1,407.00 4,593.00 6,000.00 1,621.00 4,379.00 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 122,119.00 303,976.00 STREET CONSTRUCTION/IMPROVEMENT 4,945,626.00 1,640,073.09 3,305,552.91 2,259,994.81 1,556,557.95 703,436.86 ACTIVITY TOTAL 5,408,503.00 1,762,192,09 3,646,310.91 2,333,420,36 1,576,516.50 756,903.86 T 0 T A L EXPENDITURES 7,307,618.00 2,497,080.93 4,810,537,07 4,314,118.63 1,879,512.94 2,434,605.69 EXCESS <REVENUE>EXPENDITURE 799,778,00 (1,929,966.00) 2,729,744.00 209,489.64 445,888,65 (236,399,01) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 849,931.16 (849,931.16) 16,784.89 16,784.89 EXCESS <REVENUE> EXPENDITURE 799,778.00 (1,080,034,84) t,879,812.84 226,274.53 445,888.65 (219,614,12) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 01/31/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 ************************** PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 274,300.00 87,704.74 186,595.26 198,t38.51 81,378.00 116,760.51 ACTIVITY TOTAL 274,300.00 87,704.74 186,595.26 198,138.51 81,378.00 116,760.51 TRANSPORTATION PUBLIC WORKS 4,754.00 857.66 3,896.34 3.277.32 2,282.77 994.55 STREET TREE MAINTENANCE 15,944.00 5,041.88 10,902.12 7,713.24 3,112.34 4,600.90 STREET LANDSCAPE MAINTENANCE 292,861.00 141,858.22 151,002.78 23t.458.34 113.330.59 118,127.75 ACTIVITY TOTAL 313,559.00 147,757.76 165,801.24 242,448.90 118,725.70 123,723.20 COMMUNITY DEVELOPMENT ENGINEERING 16,250.00 8,709.56 7.540.44 20,07t.01 10,220.76 9.850.25 ACTIVITY TOTAL 16,250.00 8,709.56 7,540.44 20,071.01 10,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 244,172.06 461.936.94 460,658.42 210,324.46 250,333.96 EXCESS <REVENUE>EXPENDITURE 151,857.00 (15,476.41) 167,333.41 6,359.97 (18.128.26) 24,488.23 EXCESS <REVENUE>EXPENDITURE 151,857.00 (15,476.41) 167.333.41 6,359.97 (18,128.26) 24,488.23 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 01/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 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 214,797.00 65,476.65 149,320.35 96,133.06 21,986.49 74,146.57 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING 2,561.31 (2,561.31) 8,585.61 8,049.60 536.01 ACTIVITY TOTAL 2,561.31 (2,561.31) 8,585.61 8,049.60 536.01 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 10,722,986.43 1,982,528.16 8,740,458.27 4,324,162.75 396,279.89 3,927,882.86 COMMUNITY IMPROVEMENTS PARKS 3,4t6,077.00 952,36t.60 2,463,715.40 125,589.57 8,750.00 116,839.57 STREET CONSTRUCTION/IMPROVEMENT 19,770,575.00 4,817,614.40 14,952,960.60 4,085,145.94 1,926,416.22 2,158,729.72 ACTIVITY TOTAL 33,909,638.43 7,752,504.16 26,157,134.27 8,534,898.26 2,331,446.11 6,203,452.15 T 0 T A L EXPENDITURES 34~,137,385.43 7,828,695.58 26,308,689.85 8,639,616.93 2,361,482.20 6,278,134.73 EXCESS <REVENUE>EXPENDITURE 21,852,895.43 7,138,682.45 14,714,212.98 (12,789,635.04) 1,595,148.69 (14,384,783.73) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 21,852,895.43 7,138,682.45 14,714,212.98 (12,789,635.04) 1,595,148.69 (14,384,783.73) THE CITY OF DUBLIN STATEHENT SHO~ING REVENUES VERSUS EXPENDITURES FOR THE ~ERIOD 07/01/2002 THROUGH 01/31/2003 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ SPECIAL ASSESSHENTS 118,659.03 (118,659.03) 237,264.42 118,632.21 118,632.21 USES/HONEY & PROP-INTEREST 1,898.30 (1,898.30) 8,099.29 1,767.78 6,331.81 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 t71,936.17 57,891.83 233,733.39 167,544.06 66,189.33 ACTIVITY TOTAL 229,828.00 171,936.17 57.891.83 233,733.39 167,544.06 66,189.33 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 229,828.00 171.936.17 57,891,83 233.733.39 167,544.06 66.189.33 EXCESS <REVENUE>EXPENDITURE 229,828.00 51,378.84 178,449.16 (11,630.32) 47,144.07 (58,774.39) EXCESS <REVENUE>EXPENDITURE 229,828.00 51,378.84 178,449.16 (11,630.32) 47.144.07 (58,774.39) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 01/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 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 654,825.92 448,821.22 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 796,300.02 592,21t.97 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 1,741,280.00 573,192.26 1,168,087.74 1,092,881.67 255,970.77 836,910.90 ACTIVITY TOTAL 1,741,280,00 573,192.26 1,168,087.74 1,092,881,67 255,970.77 836,910.90 PUBLIC SAFETY: FIRE 51,818,00 12,478.21 39,339.79 41,899,88 14,260.06 27,639.82 ACTIVITY TOTAL 51,818.00 12,478.21 39,339.79 41,899.88 14,260.06 27,639.82 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1,793,098.00 585,670.47 1,207,427.53 1,134,781.55 270,230.83 864,550.72 EXCESS <REVENUE>EXPENDITURE 178,771.00 (312,958.26) 491,729.26 (253,730.44) (526,069.19) 272,338.75 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 178,771.00 (312,958.26) 491,729.26 (253,730.44) (526,069.19) 272,338.75 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 01/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)