The URL can be used to link to this page

Home My WebLink About4.13 FinRpt March2002CITY CLERK FILE #330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: April 16, 2002 'SUBJECT: Financial Reports For the Month of March 2002 Report Prepared by: Carole Perry, Administrative Services Director and Fred Marsh, Finance Manager ATTACHMENTS: YTD Revenues and Budget Comparison YTD Expenses and Budget Comparison Financial Statements for the Month of March 2002 RECOMMENDATION: ¢ V~Receive the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the financial statements for the month of 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 2002 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 below. General Fund Revenues Total General Fund Revenues collected through March are lower than occurred in the nine months of the previous Fiscal Year. The City had collected through March 2002 approximately 59% of the total budgeted General Fund Revenues compared to approximately 69% in the prior Fiscal Year. Property Tax Revenue is lower than in the same period of the prior year due to timing differences in the receipt of sUpplemental and delinquent property taxes, as well as for prior 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 taxes reported through the end of March includes actual sales taxes received through December 2001. The amount is lower than in the same period of the prior year due to declines that have occurred in auto sales resulting from the recession. Transient Occupancy Tax is lower than in the same period of the prior year due to a decline in occupancy rates for the City's hotels. Franchise Taxes are lower than in the same period of the prior year due to timing differences in the receipt of Cable TV franchise revenues. COPIES TO: G:~Ionthly Financials\032002REV agenda statement monthly financials, doc ITEM NO. Licenses and Permits are lower than in the same period of the prior year due to a decline in the valuation of building permits issued on new residential and commercial projects. Interest and Rentals are higher on a percentage basis than in the same period of the prior year due to timing differences. Initially, all interest revenue is recorded in the General Fund and allocated to other funds on a semi annual basis. However, the actual interest dollars received have decreased due an overall decline in the rates earned on the City's investments. Fines and Forfeitures are higher than in the prior year due to an increase in the number of traffic citations issued over the prior year. Other Revenue is loWer than in the same period of the prior year due to a one time contribution received from a developer in the prior Fiscal Year to assist with funding construction of the City's new library. General Fund Expenditures Overall, through the month of March expenditures in the General Fund totaled $19.0 million and represented approximately 53% of the total budgeted expenditures in the General Fund. Of this amount, a total of $4.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 2002 was comparable to the amounts expended for the same period in the prior Fiscal Year. Thru the end of March 2002, the City had expended 55% of the General Fund Operating Budget compared to 50% in the prior Fiscal Year. As previously noted there are some timing differences with payment for contract services, which complicate comparisons between Fiscal Years. Fire is higher than in the same period of the prior year due to higher costs incurred to date for contract fire personnel. Police is higher than in the same period in the prior year due to timing differences in payments for contract personnel. Other Public Safety is higher than in the same period in the prior year due to timing differences in payments for contract Animal Control services. Health and Welfare is lower than in the same period of the prior year as the review of the City's housing element is expected to be completed later in the current Fiscal Year. Community Development is lower than in the same period of the prior year due to delays in filling staffing vacancies in the Planning Division. The amount spent on Capital Projects is higher than in the same period of the prior year due to expenditures incurred in the initial stages of construction of the City's new library. All expenditures to date are within the authorized budget. It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. City of Dublin 2001-2002 YTD Revenues and Budget Comparison For the Period Ending March 31, 2002 Total General Fund Revenues ~ ~ ~ ~ .' ~i~! o 69 ~/O - 4 o Property Taxes ~ ~ 65% ' ~ 68~°~ Sales Taxes ~I!!!~,~! '~ Il ~ ~i~/i~ iiiii 70 ~ I FY 2001/2002 -- ,73% FY 2000/2001 Real Property Transfer Tax ~ ..~ o ~ ~i....I,1~ ~ 74 Yo - Transient Occupancy Taxes ~ ~. Franchise Taxes- Licenses and Permits ~} ~g 8.' Interest and Rentals 61% i- 72%0 Intergovernmental from State l/I//~?i?~ ~i i',i~ .... 74%o · 62% Charges for Services ?~!?~II!II i! 61% Fines and Forfeitures 74 Other Revenues I 82 '/o 0%0 30% 60% 90% 120% 150% 75% of Year Complete FY 2001102 FY 2001/02 % of FY 2000/01 % of Total for Budget YTD Actual Budget YTD Actual FY 2000101 Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental Charges for Services Fines and Forfeitures Other Revenues Total General Fund Revenues 8,258,100 3,587,733 43% 4,668,423 - 65% 13,200,000 8,947,501 68% 9,084,471 70% 450,000 327,224 73% 428,040 74% 1,035,000 540,836 52% 656,938 65% 1,254,830 620,072 49% 664,040 51% 2,957,140 1,601,674 54% 2,519,622 83% 1,787,578 1,154,505 65% 1,597,412 , 61% 1,948,1 50 1,397,839 72% 1,492,310 74% 4,773,691 2,940,509 62% 2,279,362 61% 102,000 83,159 82% ~ 78,470 74% 879,072 392,782 45% ,, 2,216,457 82% 36,645,561 21,593,834 59% 25,685,545 69% ATTACHMENT 1 City of DUblin 2001-2002 YTD Expenses and Budget Comparison For the Period Ending March 31, 2002 Total General Fund Expenses General Government Police Fire Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects I~11161% ~~. 60% ~~150°/o 48% ~161% 6O% 41% ~~ 63% 47% 0% 20% 40% 60% 80% 100% 75% of Year Complete · FY 2O01/02 ~ FY 2000/01 General Government Police Fire Other Public Safety Transportation Health and Welfare Culture and Community Services Community Development Capital Improvement Projects Total General Fund Expenses General Fund OPerating Expenses FY 2001102 FY 2001102 Budget YTD Actual 4,210,768 2,563,002 6,802,424 3,428,221 4,672,577 2,457,649 292,463 120,155 1,127,147 686,065 64,495 26,444 4,352,294 2,530,003 5,594,915 3,107,637 8,777,489 4,082,259 35,894,572 19,001,435 27,117,083 14,919,176 % of Budget 61% 5O% 53% 41% 61% 41% 58% 56% 47% 53% 55% FY 2000/01 YTD Actual 1,846,267 1,397,495 2,066,126 73,340 579,063 7,810 2,087,783 3,110,292 818,966 11,987,142 11,168,176 %ofTotalfor FY 2000101 60% 24% 48% 32% 60% 58% 63% 69% 31% 48% 50% o ........... ATTACHMENT 2 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MARCH 2002 Prepared by The Finance Department April 8, 2002 ATTACHMENT 3 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2002 SPECIAL SPECIAL CAPITAL TRUST/ REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUND FUND TOTALS ---MEMORANDUM ONLY--- CURRENT PRIOR ASSETS CASH CASH WITH FISCAL AGENT /~MOUNT HELD IN ESCROW (49,225,416) INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 88,291,267 157,651 312,860 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 13.107 39,549.468 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANCES (722,349) (20,305) (7O3,O79) (138,598) (333,467) (102,013) (146,433) (2,167.243) (37.382.225) TOTAL FUND E (37,382,225) TOTAL LIAB. FND BAL. RETD (39.549,468) 1.611.319 1,611,319 (87,513) 412,872 42,476,022 109,300 412.872 42.585.322 (44,255,722 (12,089) 131,250 167.304 1,652.500 1.951,054 (1,770.000) (87,513) (44,267,811) ('1,770,000) (1,523,806) (412,872) 1,682,489 (181,054) (1.523,806) (412,872) 1.682,489 (181.054) (1,611,319) (412,872) (42,585.322) (1,951.054) (4,637,51t) (24,052,805) 167,304 166,814 109,300 109,300 88,291.267 76,149,328 157,651 3,517,725 312,860 744,407 13.107 1.652.500 86.066.477 550.856 5,175 1.652.500 58.843.299 (722,349) 44,276,026) (703.079) (196,870) (333,467) (103,013) (146,433) (1,770,000) 48.251,238) 37.815,239) 37,815,239) 86,066,477) (512,334) (11.556,340) (414,923) (5.323.868) (547,869) (603,122) (147,203) (1;770.000) (20,875,659) (37,967,640) (37.967.640) (58,843,299) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2002 FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP TOTALS ---MEMORANDUM--- CURRENT PRI OR ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW 5,981,281 INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 22,149,264 28,130,545 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS ,~ DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (1) FUND BALANCES (28,130.545) TOTAL FUND E (28,130,545) (1) 15,987,209 41,485,875 15,987.209 41,485,875 (15,987,209) (15.987,209) (41,485,875) (41,485,875) 2,997,824 2,694,870 6,495 38,136,473 38,136,473 41,485,875 41,688,500 82,620,172 -82,526,337 (1) (4.446) (41,485,875) (41,688,500) (41.485,876) (41,692,946) (4t,134,296) (40,833,391) (41,134,296) (40,833,391) TOTAL LIAB. FND BAL. RETD (28,130.545) (15,987,209) (41,485,875) (82,620,172) (82,526,337) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 03/31/2002 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES SALES TAX REAL PROPERTY TRANSFER TAX HOTEL TRANSIENT OCCUPANCY TAX FRANCHISE TAXES LICENSES & PERMITS FINES & FORFEITURES USE/MONEY & PROP-INTEREST USE/MONEY & PROP-RENTALS INTERGOVERNMENTAL FROM STATE INTERGOVERNMENTAL FROM COUNTY CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE ************************** GENE~L GOVERNMENT ACTIVITIES: CITY COUNCIL CITY MANAGER CENTRAL SERVICES CITY ATTORNEY ADMIN SERVICES BUILDING MANAGEMENT INSURANCE COST CENTER ELECTIONS COST CENTER NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY POLICE CROSSING GUARDS ANIMAL CONTROL DISASTER PREPAREDNESS FIRE SERVICES ACTIVITY TOTAL TRANSPORTATION PUBLIC WORKS STREET MAINTENANCE STREET SWEEPING STREET TREE MAINTENANCE STREET LANDSCAPING MAINTENAN ACTIVITY TOTAL HEALTH & WELFARE 8,258 100.00 13,200 000.00 450 000.00 1,035 000.00 1,254 830.00 2,957 140.00 102 000.00 1,'688.988.00 98,590.00 1,948,150.00 3,587,732.94 4,670,367.06 7,174,289.56 8,947,501.30 4,252,498.70 12,985,986.39 327,224.47 1.22,775.53 575,281.78 540,835.62 494,164.38 1,010,799.01 620,071.96 634,758.04 1,313,086.74 1,601,673.80 1,355,466.20 3,028,655.28 83,159.32 18,840.68 106,233.99 1,102,977.08 586,010.92 2,512,223.69 51,528.05 47,061.95 114,614.48 1,397,839.20 550.310.70 2,006,116.43 4,773,691.00 2,940,508.85 1,833,182.15 879,072.00 392,782.10 486,289.90 36,645.561.00 21,593,834.79 15,051,726.21 3,719,568.13 2,715,619.50 37,262,474.98 4,668 9,084 428 656 664 2,519 78 1,528 68 1,492 2,279 2,216 25,685 423.12 471.27 040.08 937.63 040.38 621.76 469.56 826.25 585.66 309.82 ,362.01 ,457.12 ,544.66 266,439.00 186,248.75 80,190.25 157,649.46 119,668.26 684,838.00 354,013.88 330,824.12 451,460.84 312,458.30 311,657.00 232,081.64 79,575.36 254,490.40 177,626.21 749,339.00 479,806.27 269,532.73 566,876.47 253,558.62 958,814.00 651,975.98 306,838.02 755,484.16 520,124.73 681,962.00 411,339.87 270,622.13 561,347.95 3331078.69 389,315.00 235,480.56 153,834.44 273,267.70 117,740.96 22,532.00 2,055.09 20,476.91 12,013.21 12,010.96 145,872.00 10,000.00 135.872.00 53,126.03 4,210,768.00 2,563,002.04 1,647.765.96 3,085,726.22 1,846,266.73 6,802,424.00 3,428,220.52 3,374,203.48 5,842,597.93 1,397,495.04 63,495.00 33,280.07 30,214.93 49,327.13 27,767.26 180.757.00 53,835.87 126,921.13 136,903.24 14,616~94 48,211.00 33,038.96 15,172.04 41,743.47 30,956.17 4,672,577.00 2,457,648.93 2,214,928.07 4,331,237.29 2,066,125.52 11,767,464.00 6,006,024.35 5,761,439.65 10,401,809.06 3,526,960.93 574,025.00 397,635.99 176,389.01 504,545.32 343,701.74 6.406.00 617.55 5,788.45 79.88 139.200.00 74,449.66 64,750.34 105,015.72 61,366.13 55,629.00 31,118.70 24,510.30 52,929.17 18,407.71 351,887.00 182,243.55 169,643.45 297,191.50 155,587.70 1,127,147.00 686,065.45 441,081.55 959,761.59 579,063.28 2,505 3,901 147 353 649 5O9 27 983 46 513 1,440 499 11,576 37 139 76 313 235 228 155 53 1,239 4,445 21 122 10 2,265 6,864 160 43 34 141 38O 866.44 515.12 241.70 861.38 046.36 033.52 764.43 297.44 028.82 806.61 ,206.12 ,162.38 ,930.32 981.20 002.54 864.19 317.85 359.43 269.26 526.74 2.25 ,136.02 ,459.49 ,102.89 ,559.87 ,286.30 ,787.30 ,111.77 ,848.13 ,843.58 79.88 ,649.59 ,521.46 ,603.80 ,698.31 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 03/31/2002 GENERAL REVENUE FUND CURRENT CURRENT ' BUDGET ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE WASTE MANAGEMENT CHILD CARE HOUSING PROGRAMS ACTIVITY TOTAL CULTURE & LEISURE SERVICES LIBRARY SERVICES CULTURAL ACTIVITIES HERITAGE CENTER DUBLIN CEMETERY PARK MAINTENANCE COMMUNITY TV RECREATION ADMIN PLAYGROUNDS SHANNON CENTER PRESCHOOL TEENS PROGRAM ADULT SPORTS YOUTH SPORTS COMMUNITY GYM SPECIAL EVENTS SENIOR CENTER RECREATION INSTRUCTION AQUATICS PARKS/FACILITIES MANAGEMENT ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING BUILDING SAFETY ENGINEERING ECONOMIC DEVELOPMENT ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS COMMUNITY IMPROVEMENTS PARKS STREET CONSTRC/IMPROVEMENTS ACTIVITY TOTAL TOTAL EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES 8,395.00 96.38 8,298.62 15,000.00 7,527.00 7,473.00 41,100.00 18,820.50 22,279.50 64,495.00 26,443.88 28,051.12 400,725.00 200,362.50 200,362.50 149,328.00 108,189.64 41,138.36 84,170.00 47,896.88 36,273.12 39,687.00 16,472.79 23,214.21 1,142,023.00 611,815.45 530,207.55 88,982.00 59,717.95 29.264.05 398,810.00 254,657.24 144,152.76 236,890.00 144,267.10 92,622.90 265,856.00 165,271.11 t00,584.89 58,975.00 40,465.39 18,509.61 108,839.00 67,893.31 40,945.69 80,704.00 48,100.95 32,603.05 93,023.00 60,490.27 32,532.73 37,990.00 11,073.13 26,916.87 320,247.00 212,255.11 107,991.89 167,065.00 95,997.81 71,067.19 130,122.00 102,296.42 27.825.58 368,051.00 194,565.39 173,485.61 180,807.00 88,214.62 92,592.38 4,352,294.00 2,530.003.06 1,822,290.94 1,689,970.00 1,013,414.17 676,555.83 1,622,000.00 796,565.54 825,434.46 1,999,416.00 1,084,615.13 914,800.87 283,529.00 213,041.84 70,487.16 5,594,915.00 3,107,636.68 2,4871278.32 6,095.010.00 3,292,983.84 2,802.026.16 1,198,376.00 123,750.85 1,074,625.15 665,863.00 347,102.32 318,760.68 818,240.00 318,421.58 499,818.42 8,777,489.00 4,082,258.59 4,695,230.41 35,894,572.00 750,989.00 750,989.00 19,001,434.05 2,592,400.74 2,592,400.74 1,483.29 12,000.00 13,483.29 362,922.00 48,979.05 64,337.03 35 168.63 863 488.51 65 376.81 299 517.33 179 746.06 223 534.64 54 261.57 95 263.42 74 298.29 76 437.85 ~37 226.81 200 963.28 137 807.83 116 758.13 300 625.25 95 707.64 3.332,420.23 1,330,195.42 1,334,934.18 1,606,493.94 254,452.24 4,526,076.78 1,435,693.51 180,763.51 462,208.60 603,894.29 2,682,559.91 16,893,137.95 25,001,837.08 (1,841,411.74) 12,260,637.90 17,201.67 (2,400,000.00) (1,841,411.74) 9,877,839.57 1,469.88 6,340.00 7,809.88 181461.00 41 471.35 41 124.11 18 408.48 462 992.56 59 304.35 211 552.35 130 838.32 t49 691.21 39 726.13 70 159.88 44,102.49 57,393.37 13,002.88 137.848.87 96,626.48 82.449.71 180,677.76 68,951.64 2,087,782.94 923,355.36 866,103.16 1,103,581.93 217,251.41 3,110,291.86 309,339.08 99,757.90 366,282.88 43,586.05 818,965.91 11,987,141.53 13,698,403.13 13,698,403.13 13.41 5,660.00 5,673.41 181,461.00 7,507.70 23,212.92 16,760.15 400,495.95 6,072.46 87,964.98 48,907.74 73,843.43 14,535.44 25,103.54 30.195.80 19,044.48 24,223.93 63,114.41 41,181.35 24,308.42 119,947.59 26,756.00 1,244,637.29 406,840.06 468,831.02 502,912.01 37,201.83 1,415,784.92 1,126,354.43 81,005.61 95.925.72 560,308.24 1,863,594.00 13,014,695.55 (1,437,765.23) 17,201.67 (2,400,000.00) (3,820,563.56) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 03/31/2002 SPECIAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** PROPERTY TAXES SALES TAX/OTHER TAXES FINES & FORFEITURES USES/MONEY & PROPERTY INTERGOVERNMENTAL FROM STATE INTERGOVERNMENTAL FROM COUNTY INTERGOVERNMENTAL FROM FEDERAL CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE *******EXPENDITURES******* PUBLIC SAFETY: POLICE TRAFFIC SIGNALS & STREET LTG FIRE SERVICES ACTIVITY TOTAL T~NSPORTATION: STREET MAINTENANCE STREET SWEEPING ACTIVITY TOTAL HEALTH & WELFARE: WASTE MANAGEMENT SENIOR SUPPORT CARE HOUSING PROGRAMS ACTIVITY TOTAL COMMUNITY DEVELOPMENT: ENGINEERING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS PARKS STREET CONSTRUCTION/IMPROVEMENT ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE> EXPENDITURE 90,175.00 230,500.00 145,155.00 110,312.00 3,303,769.00 234,000.00 1,122,338.00 876,760.00 5,000.00 6,118,009.00 302,730.00 175,041.00 177,100.00 654,871.00 175,084.00 175,084.00 1,049,577.00 7,500.00 10,000.00 1,067,077.00 6,000.00 6,000.00 80,373.00 411,119.00 4,744,341.00 5,235,833.00 7,138,865.00 1,020,856.00 1,020,856.00 45,429.96 135 552.55 85 401.04 63 876.34 632 550.85 131 604.00 24 398.80 430 184.18 15 525.13 1,564 522.85 154,432.11 61,706.31 124,720.27 340,858.69 114,791.57 114,791.57 521.001.92 3,750.00 2,496.40 527,248.32 2,398.50 2,398.50 19,958.55 1,777,849.60 1,797,808.15 2,783.105.23 1,218,582.38 1,218,582.38 44 745.04 94 947.45 59 753.96 46 435.66 2,671 218.15 102 396.00 1,097 939.20 446 575.82 (10,525.13) 4,553,486.15 148,297.89 113,334.69 52,379.73 314,012.31 60,292.43 60,292.43 528,575.08 3,750.00 7,503.60 539,828.68 3,601.50 3,601.50 60,414.45 411,119.00 2,966.491.40 3.438,024.85 4,355,759.77 (197,726.28) (197,726.38) 81,587.21 218,443.26 136.129.03 186,396.07 1,401,011.82 235,575.00 486,386.87 766,872.19 17,930.25 3,530,331.80 163,769.23 87,789.56 188,299.58 439,858.37 3481601.71 348,601.71 1,108,496.91 7,500.00 9,918.66 1,125.915.57 4,999.00 4,999.00 86,648.98 760,517.95 847,166.93 2,766,541.58 (763,790.22) 15,061.59 (748,728.63) 47,592.36 166,994.08 77,272.86 87,213.13 934,753.05 128,820.00 64,286.02 457,43t.56 5,259.25 1,969,622.31 60,216.83 48,215.75 131,419.58 239,852.16 126,931.31 126,931.31 660,601.51 2,750.00 6,202.30 670,553.81 36,202.98 514,179.74 550,382.72 1,587,720.00 (381,902.31) (381,902.31) 33.994.85 51,449.28 58,856.17 99,182.94 466,258.77 106,755.00 422,100.85 309,440.63 12,671.00 1,560,709.49 103,552.40 39,573.81 56,880.00 200,006.21 221,670.40 221,670.40 447,895.40 3,750.00 3,716.36 455,361.76 4,999.00 4,999.00 50,446.00 246,338.21 296,784.21 1,178,821.58 (381,887.91) 15,061.59 (366,826.32) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 03/31/2002 SPECIAL ASSESSMENT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********************** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 429,448.00 217,332.02 212,115.98 384,648.76 220,822.96 163,825.80 20,187.00 9,125.20 11,061.80 26,456.80 10,955.35 15,501.45 6,000.00 1,995.50 4,004.50 2,300.37 2,300.37 455,635.00 228,452.72 227,182.28 413,405.92 234,078.68 179,327.25 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG ACTIVITY TOTAL TRANSPORTATION PUBLIC WORKS STREET TREE MAINTENANCE STREET LANDSCAPE MAINTENANCE ACTIVITY TOTAL COMMUNITY DEVELOPMENT ENGINEERING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE EXCESS <REVENUE>EXPENDITURE 230,635.00 110,294.45 120,340:55 119,085.13 66,240.83 52,844.30 230,635.00 110,294.45 120,240.55 119,085.13 66,240.83 52,844.30 4,807.00 2,639.87 2,167.13 2,753.02 1,706.73 1,046.29 15:065.00 5,498.14 9.566.86 4,175.26 2,495.99 1,679.27 280,667.00 133.200.58 147,466.42 130,649.00 86,976.16 43,672.84 300,539.00 141,338.59 159,200.41 137,577.28 91,178.88 46,398.40 7,115.00 14,497.80 (7,382.80) 11,050.38 4,300.08 6,750.30 7,115.00 14,497.80 (7,382.80) 11,050.38 4,300.08 6,750.30 2,519.14 2.519.14 2,613.44 2,613.44 (94.30) (94.30) 538,289.00 266,130.84 272,158.16 270,231.93 164,333.23 105,898.70 82,654.00 37,678.12 44,975.88 (143,174.00) (69,745.45) (73,428.55) 82,654.00 37,678.12 44,975.88 (143,174.00) 69,745.45) (73,428.55) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 03/31/2002 CAPITAL IMPROVEMENT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********************** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 1,640,682.00 37,719,269.00 39,359,951.00 766,333.51 874,348.49 37,719,269.00 766,333.51 38,593,617.49 8,882,276.17 8,882,376.17 789,214.44 789,214.44 (789,214.44) 8,882,376.17 8,093,16t.73 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 1,854,726.00 41,457.78 1,813,268.22 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING 8,398.57 (8,398.57) ACTIVITY TOTAL 8,398.57 (8,398.57) CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 12,869,967.00 524,467.72 12,345,499.28 COMMUNITY IMPROVEMENTS PARKS 1,422,224.00 47,584.06 1,374,639.94 STREET CONSTRUCTION/IMPROVEMENT 15,659,638.00 2,247,456.19 t3,412,181.81 ACTIVITY TOTAL 29,951,829.00 2,819,507.97 27,132,321.03 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 31,806,555.00 (7,553,396.00) (7,553,396.00) 2,869,364.32 28,937,190.68 2,103,030.81 (9,656,426.81) 2,103,030.81 (9,656,426.81) 30,854.96 30,854.96 936,862.45 18,854.85 7,890,520.72 8,846,238.02 8,877,092.98 (5,283.19) 1,140.08 (4,143.11) 24,820.65 24,820.65 629,295.06 11,262.11 6,438,014.43 7,078,571.60 7,103,392.25 6,314,177.81 6,314,177.8t 6,034.31 6,034.31 307,567.39 7,592.74 1,452,506.29 1,767,666.42 1,773,700.73 (6.319.461.00) 1,140.08 (6,318,320.92) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 03/31/2002 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE 118,632.21 (118,632.21) 237,172.56 125,910.80 111,261.76 1,767.78 (1,767.78) 16,539.29 5,939.5t 10,599.78 120,399.99 (120,399.99) 253,711.85 131,850.31 121,861.54 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE 232.578.00 168,245.95 64,332.05 234,093.57 232,035.86 2,057.71 232,578.00 168,245.95 64,332.05 234,093.57 232,035.86 2,057.71 232,578.00 168,245.95 64,332.05 234,093.57 232,035.86 2,057.71 232,578.00 47,845.96 184.732.04 (19,618.28) 100,185.55 (119,803.83) EXCESS <REVENUE>EXPENDITURE 232,578.00 47.845.96 184.732.04 (19,618.28) 100,185.55 (119,803.83) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 03/31/2002 INTERNAL SERVICE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** USES/MONEY & PROP-INTEREST CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE 298,835.00 121.730.05 177,104.95 205,273.76 96,664.80 108,608.96 1,171,448.00 798,622.84 372,825.16 944,535.35 690,544.75 253,990.60 17,000.00 19,744.05 (2,744.05) 6,495.00 6,495.00 1,487,283.00 940,096.94 547,186.06 1,t56,304.1t 787,209.55 369,094.56 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: FIRE ACTIVITY TOTAL TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 1,140,046.00 1,140,046.00 45.828.00 45,828.00 189,750.00 313,139.96 826,906.04 1,018,788.52 313,139.96 826,906.04 1,018,788.52 14,260.06 31,567.94 40,700.28 14,260.06 31.567.94 40,700.28 189,750.00 273,952.~ 744,836.08 273,952.44 744,836.08 40,700.28 40,700.28 20,576.74 (20,576.74) T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TPJNNSFERS OUT TO OTHER FUNDS 1,375,624.00 327,400.02 1,048,223.98 (111,659.00) (612,696.92) 501,037.92 1,059,488.80 294,529.18 764,959.62 (96,815.31) (492,680.37) 395,865.06 2,400,000.00 2,400,000.00 EXCESS <REVENUE>EXPENDITURE (111,659.00) (612,696.92) 501,037.92 (2,496,8t5.31) (492,680.37) (2,004,134.94) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 03/31/2002 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL FINANCE ACTIVITY TOTAL PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 EXCESS <REVENUE>EXPENDITURE 20.00 20.00