The URL can be used to link to this page

Home My WebLink About4.07 FinReports March2003 CITY CLERK File # I , lJ l AGENDA STATEMENT CITY COUNCIL MEETING DATE: April 15, 2003 SUBJECT: Financial Reports For the Month of March 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 March 2003 Receive the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary financial statements for the month of March. 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 March 2003 Revenue and Expenditure Report The March report represents the reporting of revenues and expenditures for the first nine 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 in a subsequent section of this report. Additional Impacts resulting from Passage of State Budget for Fiscal Year 2002/2003 As previously reported in the Mid Year Report to Council on March 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,748 was received from the State for the City's Booking Fee Reimbursements 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. Staff will continue to 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. COPIES TO: ~f~ G:~VIonthly Financials~32003 agenda statement monthly finaneials.doc ITEM NO. . General Fund Revenues Total General Fund ReVenueS cOllected through March are ah6ad of what occurred in the ninth month of the previous Fiscal Year. Through March 2003, the City has collected approximately 71% of the total budgeted General Fund Revenues compared to 61% 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 reveau~ ~h~r~g agreement with the City. The amount of sales tax rePorted through the end of March includes actual sa!,estax~s~r~geiyed t.~.~, ough December 2002. The amount is higher than in the same period of the prior year due to higher .than expected auto sales. 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 lower than expected occupancy rates at some of the City's hotels. Franchise Taxes are lower than in the .s~ .amc 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 allocated,to,~,o~r _fimds on ~ pro rata basis twice a year. Charges for Services is lower thanin 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., Fin~es,~d,,foffeitur_~s~are,lo~er ~gg_~n, the prior year due to a decrease in traffic citation collections. ~,p~er.~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 March expenditures m the Ge%ml Fired t0ialed approximately $14.4 million and rePresented approximately 39% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $2.1 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 March 2003 was lower than the amounts expended for the same period in' the prior Fiscal Year. Through March 2003, the City had expended 41% of the General Fund Operating Budget, compared to 59% in the prior Fiscal Year. Police and Fire are lower than i~ th,e~_~s. ,.am~e 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 10w,,er ~,~, ~g~,.th~s_~,~,~,,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. Several of the capital projects funded by the General"FUnd in Fiscal Year 2002-2003 wi!! n9~i~¢~..~major expenditures until later in the Fiscal Year, including the Geographic Information System, Civic Center HVAC, Downtown Improvement Implementation, Freeway Underpass Art at Dublin Boulevard and. Amador Valley Boulevard, Shannon Corem.unity Center Decking & Exterior Painting, Senior Center and Dublin Boulev~O~UndergroUnding ofUtilltles. All expenditures to date are within the ou~o_fiz.eO~budget. It is recommended that ~...~G.~i~ty 'Council receive these reports as authorized by Section 41004 of the California Government Code, .................. City of Dublin 2002-2003 YTD Expenses and Budget Comparison For the Period Ending March 31, 2003 Total General Fund ;9% Expenses 61% General Government 62% 65% Police ] 52% Fire 52% Other Public Safety · FY 2002/03 [] FY 2001/02 Transportation 63% Health and Welfare 40% Culture & Community 63% Services 63% Community 61% Development 67% Capital Improv. Projects ~ ]71% 0% 20% 40% 60% 80% 100% 75% of Year Complete FY 2002/03 FY 2002/03 % of FY 2001/02 % of Total for Budget YTD Actual Budget YTD Actual FY 2001102 General Government 4,420,521 2,752,739 62% 2,555,447 65% Police 7,876,674 663,797 8% 3,472,762 52% Fire 5,108,279 1,423,055 28% 2,450,519 52% Other Public Safety 313,858 109,001 35% 120,155 50% Transportation 1,337,221 789,691 59% 686,065 63% Health and Welfare 69,001 27,351 40% 26,444 51% Culture and Community Services 4,740,119 2,973,392 63% 2,530,003 63% Community Development 5,824,070 3,547,138 61% 3,108,428 67% Capital Improvement Projects 7,321,648 2,098,129 29% 4,121,031 71% Total General Fund Expenses 37,011,391 14,384,293 39% 19,070,854 61% General Fund Operating Expenses 29,689,743 12,286,164 41% 14,949,823 59% .................. ATTACH M E NT 2 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MARCH 2003 Prepared by The Finance Department April 4, 2003 ATTACHMENT 3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2003 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 (29,591,150) 4,883,271 471.119 30,683,854 92,400 (3,460,506) (24,709,425) CASH WITH FISCAL AGENT 171,289 171,289 t67,304 AMOUNT HELD IN ESCROW 109,300 INVESTMENTS AT COST 92,118,978 92,118,978 88,291,267 RECEIVABLES: TAXES ACCOUNTS 138,985 361,702 500,688 157,651 INTEREST 542,481 542,481 212,860 ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 12.793 12,793 13,107 FIXED ASSETS AMOUNT TO BE PROVIDED 1,553,500 1,553,500 1,652,500 TOTAL ASSETS 53,222,087 5,244,974 471,119 30,683,854 1,817,189 91,439,222 65,994.563 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (1,014,363) (1,014,363) (722,349) DEPOSITS FOR AB1600 FEES (12,136) (6.218,986) (6,231,122) (24,420~020) DEPOSITS OTHERS (926,761) (926,761) (695,524) PAYABLES: ACCOUNTS (203,860) (167.286) (170,060) (541,205) (238,200) INTEREST PAYROLL (415,265) (415,265) (333,467) DUE TO OTHERS (49,537) (49,537) (103,013) DEFERRED REVENUE (127,768) (127,768) (146,433) DEBT INSTRUMENTS PAYABLE (1.671.000) (1,671,000) (1,770,000) TOTAL LIABILITIES (2,749,688) (167,286) (6,389,046) (1,671,000) (10,977,020) (28,429,005) FUND BALANCES (50,472,398) (5,077,688) (471,119) (24,294,808) (146,189) (80,462,202) (38,211,664) TOTAL FUND E (50,472,398) (5,077,688) (471,119) (24,294,808) (146.189) (80,462,202) (38,211,664) TOTAL LIABILITIES/EQUITY (53,222,087) (5,244,974) (471,119) (30,683,854) (1.817,189) (91,439,222 (66,640,669) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2003 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,744 (20) 6,626,724 6,019,707 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,485,875 TOTAL ASSETS 42,810,703 (20) 12,492,387 50,614,106 105,917,177 85,642,055 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,485,875) TOTAL LIABILITIES (50,614,106) (50,614,106) (41,485,876) FUND BALANCES (42~810,703) 20 (12,492,387) (55,303,070) (43~505,056) TOTAL FUND E (42,810,703) 20 (12,492,387) (55,303,070) (43.505.056) TOTAL LIABILITIES/EQUITY (42,810,703) 20 (12,492,387) (50,614,106) (105,917,177) (84~990,932) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 03/31/2003 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************* PROPERTY TAXES 9,892,843.00 6.776,840.82 3,116,002.18 8,794,710.89 3,587,732.94 5,206,977.95 SALES TAX 12,702,000.00 9,179,195.04 3,522,804.96 12,813 111.10 8,947.501.30 3.865.609.80 REAL PROPERTY TRANSFER TAX 415,000.00 226,220.43 188,779.57 434 832.20 327,224.47 107.607.73 HOTEL TRANSIENT OCCUPANCY TAX 858,000.00 470,102.54 387,897.46 810 219.79 540,835.62 269 384.17 FRANCHISE TAXES 1,493,900.00 604,342.67 889,557.33 1,385 815.52 620,071.96 76~ 743.56 LICENSES & PERMITS t,622,404.00 1,927,976.12 (305,572.12) 2,327 250.77 1,601,603.80 725 646.97 FINES & FORFEITURES 114,000.00 69,536.65 44,463.35 118 190.93 83,159.32 35 031.61 USE/MONEY & PROP-INTEREST 1,244,226.00 1.476,646.77 (232,420.77) 1,843 673.66 1,116,277.77 727 395.89 USE/MONEY & PROP-RENTALS 129,312.00 92,661.12 36,650.88 85 936.82 51,528.05 34 408.77 INTERGOVERNMENTAL 2,096,165.00 1,521,305.28 574,859.72 2,076 648.50 1,397,839.30 678 809.20 CHARGES FOR SERVICES 4,815,035.00 2.958,026.81 1,857,008.19 4.464 259.66 2.960,199.68 1,504 059.98 OTHER SOURCES OF REVENUE 742,768.00 221,176.38 521,591.62 493 722.65 392,710.10 101 012.55 TOTAL REVENUE 36,125,653.00 25.524,030.63 10,601,622.37 35.648 372.49 21,626,684.31 14,021 688.18 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 212,932.00 154,027.27 58.904.73 217 946.55 178 693.75 39 252.80 CITY MANAGER 739 518.00 529,854.56 209.663.44 560 359.16 354 013.88 206 345.28 CENTRAL SERVICES 319 600.00 205,878.51 113,721.49 297 049.71 232 081.64 64 968.07 CITY ATTORNEY 686 076.00 520,378.90 165,697.10 764 484.52 479 806.27 284 678.25 ADMIN SERVICES 1,038 223.00 690,745.04 347,477.96 922 865.72 651 975.98 270 889.74 BUILDING MANAGEMENT 731 567.00 465,406.14 266,160.86 657 327.17 411 339.87 245 987.30 INSURANCE COST CENTER 386 665.00 175,779.83 210,885.17 385395.68 235 480.56 149 915.12 ELECTIONS COST CENTER 20 940.00 10,668.84 10,271.16 14,507.57 2 055.09 12452.48 NON-DEPARTMENTAL 285 000.00 285,000.00 109,981.56 10 000.00 99,981.56 ACTIVITY TOTAL 4,420 521.00 2,752.739.09 1,667,781.91 3,929,917.64 2,555,447.04 1,374,470.60 PUBLIC SAFETY POLICE 7,876,674.00 663,796.78 7,212,877.22 6.668,234.72 3,472,761.54 3,195,473.18 CROSSING GUARDS 71,462.00 36.607.06 34,854.94 56,677.08 33,280.07 23~397.01 ANIMAL CONTROL 181,437.00 36,194.97 145,242.03 138,935.98 53,835.87 85,100~11 DISASTER PREPAREDNESS 60,959.00 36,198.89 24,760.11 46,012.48 33,038.96 12.973~52 FIRE SERVICES 5,108,279.00 1,423,055.42 3,685,223.58 4,698,607.54 2,450,518.90 2,248,088.64 ACTIVITY TOTAL 13,298,811.00 2,195,853.12 11,102,957.88 11,608,467.80 6,043,435.34 5,565~032.46 TRANSPORTATION PUBLIC WORKS 616,631.00 431,474.25 185,156.75 557,207.53 397,635.99 159~571.54 STREET MAINTENANCE 10,427.00 5,973.33 4,453.67 6,406.00 617.55 5~788.45 STREET SWEEPING 132,100.00 73,164.78 58,935.22 132,383.34 74,449.66 57,933~68 STREET TREE MAINTENANCE 70,337.00 37,911.38 32,425.62 51,079.02 31,118.70 19,960~32 STREET LANDSCAPING MAINTENAN 507,726.00 241,166.96 266,559.04 347,022.86 182.243.55 164~779431 ACTIVITY TOTAL 1,337,221.00 789,690.70 547,530.30 1,094,098.75 686,065.45 408,033~30 HEALTH & WELFARE WASTE MANAGEMENT 8,242.00 3,551.78 4,690,22 1,807.38 96.38 1,711o00 REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 03/31/2003 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE CHILD CARE 15,000.00 10,587.00 4,413.00 15,000.00 7,527.00 7,473.00 SOCIAL SERVICES 6,000.00 6,000.00 HOUSING PROGRAMS 39,759.00 7,211.74 32,547.26 35,209.87 18,820.50 16,389,37 ACTIVITY TOTAL 69,001.00 27,350.52 41.650.48 52,017.25 26,443.88 25,573o37 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 93,744.29 43,408.71 119 409.29 108,189.64 11 219.65 HERITAGE CENTER 90,771.00 60,714.20 30.056.80 69 081.56 47,896.88 21 184,68 DUBLIN CEMETERY 37,418.00 17,070.97 20,347.03 30 077.98 16,472.79 13 605.19 PARK MAINTENANCE 1,263,230.00 702,946.35 560,283.65 1,086 713.48 611 815.45 474 898.03 COMMUNITY TV 70,906.00 72,309.90 (1.403.90) 80 087.02 59 717.95 20 369.07 RECREATION ADMIN 453,444.00 314,893.65 138,550.35 374 416.72 254 657.24 119 759.48 PLAYGROUNDS 261,690.00 156,480.47 105,209.53 207 515.47 144 267.10 63 248.37 SHANNON CENTER 270,182.00 186,878.04 83.303.96 250 834.21 165 271.11 85 563.20 PRESCHOOL 79,421.00 53,095.22 26,325.78 57 470.25 40 465.39 17 004.86 TEENS PROGRAM 113,854.00 65,795.49 48,058.51 106 183.40 67 893.31 38 290.09 ADULT SPORTS 95,061.00 63,511.10 31,549.90 76886.84 48 100.95 28 785.89 YOUTH SPORTS 96,743.00 69,170.00 27,573.00 82,402.67 61 702.27 20 700.40 COMMUNITY GYM 35,167.00 20,144.35 5,022.65 22,572.33 11 073.13 12 499.20 SPECIAL EVENTS 349,589.00 252,062.20 97,526.80 314,735.18 212 255.11 102 480.07 SENIOR CENTER 190,215.00 122,389.73 67,825.27 146,824.25 95 997.81 50 826°44 RECREATION INSTRUCTION 143,005.00 113,361.60 29,643.40 145,812.50 101 084.42 44 728.08 AQUATICS 332,691.00 211,468.28 121,222.72 322,391.18 194 565.39 127 825.79 PARKS/FACILITIES MANAGEMENT 223,360.00 147,697.03 75,662.97 142,041.19 88 214.62 53 826.57 ACTIVITY TOTAL 4,740,119.00 2,973,391.87 1,766,727.13 4,012,731.62 2,520 003.06 1,482,728.56 COMMUNITY DEVELOPMENT PLANNING 2,021,188.00 1,155,543.20 865,644.80 1,486,541.67 1,013,414.17 473,127.50 BUILDING SAFETY 1,603,701.00 914,185.43 689,515.57 1,276,343.20 796,565.54 479,777.66 ENGINEERING 1,902,477.00 1,247,343.28 655,133.72 1,609,544.48 1,085.406.81 524,137.67 ECONOMIC DEVELOPMENT 296,704.00 230,065.91 66,638.09 271,222.90 213,041.84 58,181.06 ACTIVITY TOTAL 5,824,070.00 3,547,137.82 2,276,932.18 4,643,652.25 3,108.428.36 1,535,223.89 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 2,911,288.30 1,374,602.85 1,536,685.45 4,582,889.35 3,293,206.84 1,289.682.51 COMMUNITY IMPROVEMENTS 1,814,645.00 228,526.71 1,586,118.29 273,283.82 123,750.85 149,532.97 PARKS 1,598,896.00 278,811.41 1,320,084.59 351,854.08 347,102.32 4,751.76 STREET CONSTRC/IMPROVEMENTS 996,819.00 216,188.08 780,630.92 580,008.92 356,970.72 223,038°20 ACTIVITY TOTAL 7,321,648.30 2,098,129.05 5,223,519.25 5,788,036.17 4,121,030.73 1,667,005.44 TOTAL EXPENDITURES 37,011,391.30 14,384,292.17 22,627,099.13 31,128,921.48 19,070.853.86 12,058.067~62 EXCESS REVENUE (EXPENDITURES) (885,738.30) 11,139,738.46 (12,025,476.76) 4,519,451.01 2,555,830.45 1,963,620~56 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) 11,146.338.46 (12,032.076.76) 4,536,235.90 2,555,830.45 1,980,405.45 REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 03/31/2003 SPECIA REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** PROPERTY TAXES 93,610.00 65 092.95 28.517.05 91,099.68 45,429.96 45,669.72 SALES TAX/OTHER TAXES 317,700.00 232 783.66 84.916.34 206,812.62 135,552.55 71,260.07 FINES & FORFEITURES 153,000.00 87 377.34 65,622.66 149,023.41 85,401.04 63,622.37 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 5.466 982.26 (948,596.26) 1,601,090.43 632,550.85 968.539.58 INTERGOVERNMENTAL FROM COUNTY 240,909.00 121 495.50 119,413.50 241,589.50 131,604.00 109.985.50 INTERGOVERNMENTAL FROM FEDERAL 242,461.00 77 701.14 164,759.86 782,793.26 24,398.80 758,394.46 CHARGES FOR SERVICES 885,779.00 599 221.14 286,557.86 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 6.698 648.00 (190,808.00) 4,104,628.99 1,564,522.85 2,540,106~14 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 218,727.00 40,271.14 178,455.86 377,390.53 154,432.11 222,958~42 TRAFFIC SIGNALS & STREET LTG 145.900.00 71,257.96 74,642.04 145,399.20 61,706.31 83,692°89 FIRE SERVICES 213.873.00 51,160.25 162,712.75 193.800.29 124,720.27 69,080.02 ACTIVITY TOTAL 578,500.00 162,689.35 415,810.65 716,590.02 340.858.69 375,731.33 TRANSPORTATION: STREET MAINTENANCE 219,619.00 101,767.51 117,851.49 209,801.34 114,791.57 95,009.77 STREET SWEEPING ACTIVITY TOTAL 219,619.00 101,767.51 117,851.49 209,801.34 114,791.57 95,009.77 HEALTH & WELFARE: WASTE MANAGEMENT 1,079,569.00 508,436.38 571,132.62 1,030,807.37 521,001.92 509,805.45 SOCIAL SERVICES 28,427.00 16,998.90 11,428.10 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 525,435.28 582,560.72 1.048,306.91 527,248.32 521,058.59 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 2,197,111.81 2,748,514.19 2,259,994.81 1,768,472.16 491,522.65 ACTIVITY TOTAL 5,408,503.00 2,489,243.81 2,919,259.19 2.333,420.36 1,788,430.71 544,989°65 T 0 T A L EXPENDITURES 7,320,618.00 3,280,542.95 4,040,075.05 4,314,118.63 2.773,727.79 1,540,390~84 EXCESS <REVENUE>EXPENDITURE 812.778.00 (3.418,105.05) 4,230,883.05 209,489.64 1,209,204.94 (999,715.30) 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 812,778.00 (2,561,573.89) 3,374,351.89 226,274.53 1,209,204.94 (982,930~41) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 03/31/2003 SPECIAL ASSESSMENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y,T.D, VARIANCE ********************** SPECIAL BENEFITS ASSESSMENTS 536,364.00 307.885.97 228,478.03 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 6,863.08 (2,863.08) 1,995.50 1,995.50 TOTAL REVENUE 554,252.00 321.536.07 222.715.93 454,298.45 228.452.72 225,845.73 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 274.300.00 106,349.87 167,950.13 198,138.51 110.294.45 87.844.06 ACTIVITY TOTAL 274,300.00 106.349.87 167,950.13 198,128.51 110,294.45 87,844.06 TRANSPORTATION PUBLIC WORKS 4,754.00 1,111.49 3,642.51 3,277.32 2,639.87 637.45 STREET TREE MAINTENANCE 15,944.00 7,203.51 8,740.49 7,713.24 5,498.14 2,215.10 STREET LANDSCAPE MAINTENANCE 292,861.00 171,233.37 121,627.63 231,458.34 133,200.58 98,257.76 ACTIVITY TOTAL 313,559.00 179,548.37 134,010.63 242,448.90 141.338.59 101,110.31 COMMUNITY DEVELOPMENT ENGINEERING 16,250.00 8,709.56 7,540.44 20,071.01 14,497.80 5,573.21 ACTIVITY TOTAL 16,250.00 8,709.56 7,540.44 20,071.01 14,497.80 5.573.21 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 294,607.80 411,501.20 460,658.42 266,130.84 194,527.58 EXCESS <REVENUE>EXPENDITURE 151,857.00 (26.928.27) 178,785.27 6,359.97 37,678.12 (31,318.15) EXCESS <REVENUE>EXPENDITURE 151,857.00 (26.928.27) 178,785.27 6,359.97 37,678.12 (31,318.15) THE CITY OF DUBLIN STATEMENT SHOWING 1 0 ~"~:~ REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 03/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 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 12,950.00 17,996.86 (5,046.86) ACTIVITY TOTAL 12,950.00 17,996.86 (5.046.86) PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 494.797.00 84.701.14 410,095.86 96,133.06 41,457.78 54,675.28 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,716,783.24 7,047,432.19 4,324,162.75 524.467.72 3,799,695.03 COMMUNITY IMPROVEMENTS PARKS 3,416,077.00 994,418.32 2,421,658.68 125,589.57 47,584.06 78,005.51 STREET CONSTRUCTION/IMPROVEMENT 19,770.575.00 7.897,512~18 11,873,062.82 4,085,145.94. 2.218,284.49 1,866,861.45 ACTIVITY TOTAL 37,950.867.43 16,608,713.74 21,342,153.69 8.534,898.26 2,790,336.27 5.744,561.99 T 0 T A L EXPENDITURES 38.458,614.43 16,713,973.05 21,744,641.38 8.639,616.93 2.840,192.62 5,799,424.31 EXCESS <REVENUE>EXPENDITURE 26,174,124.43 16,023,959.92 10.150.164.51 (12,789,635.04) 2,073,859.11 (14.863.494.15) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 26,174,124.43 16,023,959.92 10,150,164.51 (12,789,635.04) 2,073,859.11 (14,863,494.15) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 03/31/2003 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** SPECIAL ASSESSMENTS 135,354.44 (135,354.44) 2375264.42 118,632.21 118,632.21 USES/MONEY & PROP-INTEREST 1.898.30 (1,898.30) 8,099.29 1,767.78 6,331.51 TOTAL REVENUE 137.252.74 (137,252.74) 245,363.71 120,399.99 124,963.72 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 229,828.00 231,594.42 (1,766.42) 233,733.39 231,667.20 2,066.19 ACTIVITY TOTAL 229,828.00 231,594.42 (1,766.42) 233,733.39 231,667.20 2,066.19 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,733.39 231,667.20 2,066.19 EXCESS <REVENUE>EXPENDITURE 229,828.00 94,341.68 135,486.32 (11.630.32) 111,267.21 (122,897.53) EXCESS <REVENUE>EXPENDITURE 229,828.00 94,241.68 135,486.32 (11,630.22) 111,267.21 (122,897.63) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 03/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 861,380.45 505,887.55 1,103,647.14 844.178.54 259,468.60 OTHER SOURCES OF REVENUE 20,000.00 17,630.53 2,369.47 22,267.13 19,744.05 2,523.08 TOTAL REVENUE 1,614,327.00 990,511.92 623.815.08 1,388,511.99 985,652.64 402,859.35 ************************** GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 1,741,280.00 652,246.98 1.089,033.02 1,092,881.67 313,139.96 779,741.71 ACTIVITY TOTAL 1,741,280.00 652,246.98 1,089,033.02 1,092,881.67 313,139.96 779,741.71 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 676,994.45 1,116,103.55 1,134,781.55 334,530.05 800,251o50 EXCESS <REVENUE>EXPENDITURE 178,771.00 (313,517.47) 492,288.47 (253,730.44) (651,122.59) 397,392.15 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 178,771.00 (313,517.47) 492,288.47 (253,730.44) (651,122.59) 397,392.15 THE CITY OF DUBLIN STATEMENT SHOWING 1~ ~C/ REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 05/81/2008 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-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)