Loading...
HomeMy WebLinkAboutItem 4.03 PrelFinRpt July2001CITY CLERK File # 330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: September 4, 2001 SUBJECT: ATTACHMENTS: RECOMMENDATION: ~' FINANCIAL STATEMENT: Preliminary Financial Reports For the Month of July 2001 Report Prepared by: Carole A. Perry, Administrative Services Director and Fred Marsh, Finance Manager YTD Revenues and Budget Comparison YTD Expenses and Budget Comparison Financial Statements for the Month of July 2001 Receive the reports. See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the preliminary financial statements for the month of July. The final audited results of Fiscal Year 2000/2001 are not yet available, therefore, this report is presented as "preliminary" at this time. Preliminary Financial Results for Fiscal Year 2000-2001 (subject to adjustments from the City's annual audit) will be presented at the October 2, 2001 council meeting. 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 will start the final phase of their field work necessary for the 2000/2001 audit in September 2001. The final audit results will impact the reported Fund Balance presented in the attached monthly reports. Staff has not yet made the final year end accrual for sales tax, but anticipates the final entries will occur by the October report. The scope of any remaining final entries will not be significant when compared to all general fund revenues and expenses. Analysis of Preliminary, July 2001 Revenue and Expenditure Report Given that this is only the first month of the 2000/2001 Fiscal Year, there is extremely limited data on which to base any major Projections or identify significant trends. For example the receipt of revenues does not typically follow an even distribution throughout the Fiscal Year. Major amounts of Property Taxes and Sales Taxes are not received until later in the Fiscal Year. There is als°a lag with the reporting of expenditures due to the significant amount of services provided to the City by independent contractors. General Fund Revenues Total General Fund Revenues collected through July are comparable to what occurred in the first month of the previous Fiscal Year. The City had collected through July 2001 approximately 4% of the total budgeted General Fund Revenues compared to approximately 4% in the prior Fiscal Year. cOPIES TO: G:~VIonthly Financiais\072001 agenda statement monthly financials.doc ITEM NO. General Fund Expenditures Overall, through the month of July expenditures in the General Fund totaled $560,657 and represented approximately 2% of the total budgeted expenditures in the General Fund. Of this amount, a total of $47,709 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 at only General Fund Operating Expenditures, the activity through July 2001 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of July 31, 2001, the City had expended 2% of the General Fund Operating Budget compared to 2% in the prior Fiscal Year. As previously noted there are some timing differences with payment for contract services, which complicate comparisons between one year to the next. 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. Total General Fund Revenues Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits interest and Rentals Intergovernmental from State Charges for Services Fines and Forfeitures Other Revenues City of Dublin 2001-2002 yTD Revenues and Budget Comparison For the Period Ending July 31, 2001 ........................................................................................................ 4% % % i7% ~6% 0% O% 0% O% ~8% 7O/o ~i 7% 13% 2% ~17% ~5% ~% [] FY 2001/2002 ~ FY 2000/2001 0% 30% 60% 90% 120°/o 150% 8% of Year Complete Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovemmental Charges for Services Fines and Forfeitures Other Revenues Total General Fund Revenues Date Pdnted: 8/22/0t 6:00 PM FY 2001/02 FY 2001102 % of FY 2000101 Budget YTD Actual Budget YTD Actual 8,258,100 0% 13,200,000 860,500 7% 698,700 450,000 0% 1,035,000 0% 1,254,830 0% 2,957,140 168,702 6% 227,330 1,787,578 6,215 0% 116,057 1,948,150 133,232 7% 135,642 3,859,216 112,744 3% 92,199 102,000 6,708 7% 5,700 1,021,672 28,895 3% 39,804 35,873,686 1,316,996 4% 1,315,432 % of Total for FY 2000101 0% 6% 0% 0% 0% 8% 5% 7% 2% 5% 2% 4% ATTACHMENT City of Dublin 2001-2002 YTD Expenses and Budget Comparison For the Period Ending July 31, 2001 Total General Fund Expenses General Government Police Fire Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects 2%2% 1% 0%' 0% 1O/o 2% 0% 0% 34°/o 3% ]1% 0% 0% 20% 40% 60% 80% 100% 8% of Year Complete [] FY 2001/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 Budget FY 2001/02 % of YTD Actual Budget FY 2000101 YTD Actual 3,837,268 114,296 3% 104,162 6,798,924 40,142 1% 30,390 4,663,477 17,925 0% 14,841 292,463 2,666 1% 2,814 1,127,147 27,279 2% 20,239 64,495 0 0% 4,265,669 166,336 4% 91,579 5,647,549 144,304 3% 128,410 8,030,596 47,709 1% 560,657 2% 512,948 2% 34,727,588 26,696,992 392,435 392,435 %ofTotalfor FY200010J 3% 1% O% 1% 2% O% 3% 3% O% 2% 2% D .......... ~7~0~ ~ ..... ATTACHMENT 2 CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JULY 2001 Prepared by The Finance Department August 8, 2001 ATTACHMENT 3 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Ju12001 SPECIAL SPECIAL CAPITAL TRUST/ REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUND FUND TOTALS ---MEMORANDUM ONLY--- CURRENT PRIOR ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW (33,954.806) INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 74.945.557 552.954 312,860 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 12.514 41,869.078 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 (758,306) (72,600) (414,998) (2,117.748) (330.661) (52.266) (149.497) (3.896,076) (37,973.002) TOTAL FUND E (37.973.002) 2.100.750 57.991 2,158.741 (160.923) 459.113 26,480,437 109.300 459,113 26,589.737 (34.451.440) (22,338). (265,296) (160.923) (22.338) (34,716.736) (1,997.818) (436,775) 8,126.998 (1,997,818) (436.775) 8,126.998 175.176 166.814 (4,975,415) (22.986,810) 166.814 166,814 109,300' 109.300 74,945.557 76,149,328 610.945 1,642.039 312.860 744.407 1.652,500 1.994,490 12.514 5,883 1.652.500 1.652.500 72,835,074 57.483,461 (758,306) (520.390) (34.524.040) (18,700.081) (414.998) (414.923) (2.566.304) (3,217,616) (330.661) (52.266) (149.497) (1,770.000) (1,770,000) (1.~70.000) (40,566.072) (224,490) (32.269,001) (224.490) (32,269.001) (547,869) (52,266) (149.497) (1.770.000) (25.372.643) (32.110,819) (32.110,819) TOTAL LIAB. FND BAL. RETD (41,869,078) (2.158.741) (459.113) (26.589,737) (1.994.490) (72.835.074) (57.483,461) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Ju12001 FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP TOTALS ---MEMORANDUM--- CURRENT PRIOR ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW 5,326,328 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 21,105,766 26,432,094 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS (2,047) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (2,047) FUND BALANCES (26.430,047) TOTAL FUND E (26,430,047) 8,626,020 47,878,408 8,626,020 47,878,408 (8,626,020) (8,626,020) (47,878,408) (47.878,408) 2,649.615 2.607,765 6,495 29,731,786 29.731,786 47.878.408 47,878,408 80,.259,809 80,224,454 (2,047) (4,246) (47,878,408) (47,878,408) (47,880,455) (47,882.655) (32,379,354) 32,341,800) (32,379,354) 32,341,800) TOTAL LIAB. FND BAL. RETD (26,432,094) (8,626,020) (47,878,408) (80,259,809) 80,224,454) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES ,~ FOR THE PERIOD 07/01/2001 THROUGH 07/31/2001 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************* 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 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL CITY MANAGER CENTRAL SERVICES CITY A1-FORNEY 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 8,258,100.00 7,473,600.79 860,500.00 12,339,500.00 12,177,358.01 450.000.00 575,281.78 1,035,000.00 1,010,799.01 1,254,830.00 1,138,841.17 168,701.81 2,788,438.19 3,028,955.28 6,708.92 95,29~.08 106,678.99 495.00 1~688,493.00 3,576,542.32 5,719.95 92,870.05 111,093.30 133,231.52 1,814,918.48 2,006,116.43 698,700.00 227,329.83 5,700.00 111,246.29 4,810.74 135,642.38 7,473,600.79 11,478,658.01 575,281.78 1,010,799.01 1,138,841.17 2,801,625.45 100,978.99 3,465,296.03 106,282.56 1,870,474.05 3,859,216.00 112,743.85 3,746,472.15 3,708,280.54 92,198.54 3,616,082.00 1,021,672.00 28,894.50 992,777.50 2,750,044.35 39,803.63 2,710,240.72 35,873,686.00 1,316,995.55 34,556,690.45 37,663,591.97 1,315,43i.41 36,348,160.56 157 648.08 451 303.65 254 397.62 566 876.47 755 325.08 559 897.45 242 231.09 12,013.21 2,999,692.66 4,465,397.70 49,327.13 136,903.24 41,742.09 4,330,515.41 9,023,885.57 504,382.13 79.88 105,015.72 52,929.17 290,757.23 953,164.13 229,439.00 684,838.00 286,157.00 469,339.00 958,814.00 681,962.00 389,315.00 1,532.00 135,872.00 3,837,268.00 6,798,924.00 63,495.00 180,757~00 48,211.0'0 4.663,477.00 11,754,864.00 574,025.00 6,406.00 139,200.00 55,629.00 351,887.00 1,127,147.00 19,377.80 23,517.34 12,260.86 40,577.17 8.429.02 104,162.19 30,389.77 2,814.42 14,841.08 48~045.27 20,239.24 20,239.24 12,257.18 217,181.82 27,063.31 657,774.69 14,308.90 271,848.10 469,339.00 50,760.22 908,053.78 9,369.17 672,592.83 537.55 388,777.45 1,532.00 135,872.00 114,296.33 3,722,971.67 40,141.73 6,758,782.27 63,495.00 180,757.00 2,665.70 45,545.30 17,925.04 4,645,551.96 60,732.47 11,694,131.53 27,279.48 546,745.52 6,406.00 139,200.00 55,629.00 351,887.00 27,279.48 1,099,867.52 138,270.28 427,786.31 242,136.77 566,876.47 714~747.91 551,468.43 242,231.09 12,013.21 2,895,530.47 4,435,007.93 49,327.13 136,903.24 38,927.67 4,315,674.33 8,975,840.30 484,142.89 79.88 105,015.72 52,929.17 290,757.23 932,924.89 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 07/31/2001 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR 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.O0 15,000.00 41,100.00 64,495.OO 400,725.00 148,028.00 84,170.00 39,687.00 1,138,122.00 81,482.00 398,810.00 236,890.00 265,856.00 58,975.00 108,839.00 80,704.00 93,023.00 37,990.00 256,707.00 156,680.00 130;122.00 368,051.00 180,807.00 4,265,669.00 1.764,970.00 1,622,000.00 1,999,416.00 261,163.00 5,647,549.00 5,200,547.00 1,170,874.00 665,863.00 993,212.00 8,030,596.00 34,727,588.00 1,146,098.00 1,146,098.00 50,136.31 2,144.57 18,729.49 13,303.39 8,633.48 3,154.63 5,426.11 2.681.05 2,710.01 1,212.05 18,216.27 8,541.35 2,696.26 21,470.89 6,280.60 166,336.46 62,268.18 23,749.47 50,989.45 7,296.81 144,303.91 46,922.82 251.60 524.41 47,708.83 560,657.48 756,338.07 756,338.07 8,395.00 15,000.00 41,100.00 64.495.00 400,725.00 97,891.69 82,025.43 39,687.00 1,138,123.00 81,482.00 380,080.5t 223,586.61 257,222.52 55,820.37 103,412.89 78,022.95 90,312.99 36,777.95 238,490.73 148,138.65 126,425.74 346,580.11 174,526.40 4,099,332.54 1,702,701.82 1,598,250.53 1,948,426.55 253,866.19 5,503,245.09 5,153,614.18 1,170,874.00 665,611.40 992,787.59 7,982,887.17 34,166,930.52 389.759.93 389.759.93 1,483.29 12,000.00 13.483.29 362,922.00 48,979.05 64,323.04 35 029.30 843 738.61 65 359.53 299 351.76 179 746.06 223 279.64 53 781.57 95,263.42 71,566.23 76,387.85 23,550.81 200,941.25 137,734.65 116,758.13 298,178.13 95,706.26 3,292,597.29 1,324,548.16 1,334,871.77 1,604,523.67 254,451.86 4,518,395.46 964,643.51 180,763.51 462,226.74 567,071.79 2,174,705.55 22,975,923.95 14,687,668.02 17,201.67 (2,400,190.01) 12,304,679.68 968.96 2,343.12 14.236.86 9,260.55 9,132.10 3,157.64 4,572.14 2,149.66 2,409.74 83.79 8,632.23 5,561.61 4,120.19 19,955.20 4,995.15 91,579.04 50,868.65 20,961.60 50,255.48 6,323.78 128,409.51 392.435.25 922,996.16 922,996.16 1,483.29 12,000.00 13,483.29 362,922.00 48,010.09 61,979.92 35,029.30 843,738.61 65,359.53 285,114.90 170,485.51 214,147.54 50,623.93 90,691.28 69,416.57 73.978.11 23,467.02 192,309~02 132,173.04 112,637.94 278,222.83 90,711.11 3,201,018.25 1,273,679.51 1,313,910.17 1,554,268.19 248.128.08 4,389,985.95 964,643.51 180,763.51 462,226.74 567,071.79 2,174,705.55 22,583,488.70 13,764,671.86 17,201.67 (2,400,190.01) 11,381,683.52 THE CITY OF DUBLIN STATEMENT sHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 07/31/2001 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 ************************** PUBLIC SAFETY: POLICE TRAFFIC SIGNALS & STREET LTG FIRE SERVICES ACTIVITY TOTAL TRANSPORTATION: 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,5O0.0O 10,000.00 1,067,077.00 6,000.00 6,000.00 80,273.00 411,119.00 4,678,511.00 5,170,003.00 7,073,035.00 955,026.00 90,175.00 80,718.02 i5,439.75 215,060.25 218,443.36 145,155.00 126,860.43 110,312.00 91,898.87 3,303,769.00 1,095,795.37 234,000.00 235,575.00 1,122,338.00 112,206.27 876,760.00 756,956.73 5,000.00 17,930.25 15,439.75 6,102,569.25 2,736,384.30 1.338.34 301,391.66 91,937.68 175,041.00 .87,388.36 177,100.00 188,299.58 1,338.34 653,532.66 367,625.62 175,084.00 348,601.71 175,084.00 348,601.71 1,049,577.00 1,108,496.91 7,500.00 7,500.00 10,000.00 8,796.82 1,067,077.00 1,124,793.73 1.001.00 4,999.00 4,999.00 1,001.00 4,999.00 4,999.00 80,372.00 86,648.98 411,119.00 288.20 4,678,222.80 797,307.95 288.20 5~169,714.80 883,956.93 2,729,976.99 (6,407.31) 15,061.59 955,026.00 (12,812.21) 967,838.21 8,654.28 2,627.54 7,07Q,407.46 (12,812.21) 967,838.21 12,776.09 12,776.09 1,569.12 1,569.12 1,569.12 11,206.97) 11,206.97) 80,718.02 205 667.27 126 860.43 91 898.87 1,095 795.37 235 575.00 112 206.27 756 956.73 17 930.25 2,723,608.21 91,937.68 87,388.36 188,299.58 367,625.62 348,601.71 348,601.71 1,108,496.91 7,500.00 8,796.82 1,124,793.73 4,999.00 4,999.00 ~ 86,648.98 795,738.83 882.387.81 2,728,407.87 4,799.66 15,061.59 19,861.25 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 07/31/2001 SPECIAL ASSESSMENT FUND CURRENT BUDGET CURRENT PRIOR ACTUAL VARIANCE FISCAL YEAR PRIOR Y.T.D. VARIANCE ********************** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 429,448.00 20,187.00 6,000.00 455,635.00 429,448.00 281,464.74 20,187.00 12,942.44 6,000.00 2,300.37 455,635.00 396,707.55 381,464.74 12,942.44 2,300.37 396,707.55 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG ACTIVITY TOTAL TRANSPORTATION PUBLIC WORKS STREET TREE MAINTENANCE STREET LANDSCAPE MAINTENANCE ACTIVITY TOTAL HEALTH & WELFARE: ENGINEERING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT ACTIVITY TOTAL T O,T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE 230,635.00 1,200.00 229,435.00 118,925.62 1,000.00 117,925.62 230,635.00 1,200.00 229,435.00 118,925.62 1,000.00 117.925.62 4,807.00 15,065.00 280,667.00 300,539.00 7,115.00 7,115.00 538,289.00 82,654.00 196.15 4,610.85 2,753.02 15,065.00 4,175.26 280.667.00 126,489.46 196.15 300,342.85 133.417.74 7,115.00 11,050.38 7,115.00 11,050.38 2,519.14 2,519.14 1,396.15 536,892.85 265.912.88 1,396.15 81,257.85 (130,794.67) 283.71 283.71 1,283.71 1,283.71 2,469.31 4,175.26 126,489.46 133,134.03 11,050.38 11,050.38 2,519.14 2,519.14 264,629.17 (132,078.38) EXCESS <REVENUE>EXPENDITURE 82,654.00 1,396.15 81,257.85 (130,794.67) 1.283.71 (132,078.38) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 07/31/2001 CAPI AL IMPROVEMENT FUND CURRENT BUDGET CURRENT PRIOR PRIOR ACTUAL VARIANCE FISCAL YEAR 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 1,640,682.00 789,214.44 37.719,269.00 5,283.19 39,359,951.00 794,497.63 789,214.44 5,283.19 794,497.63 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS COMMUNITY IMPROVEMENTS 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 1,854,726.00 12.867.967.00 1,121,430.00 15,131,302.00 29,130,699.00 30,985,425.00 (8,374.526.00) (8,374.526.00.) 336.92 816.83 816.83 2,340.46 2,340.46 3,494.21 3,494.21 3,494.21 1,854,389.08 (816.83) (816.83) 12,867,967.00 1,131,430.00 15,128,961.54 29,128,358.54 30,981,930.79 (8,378,020.21) (8.378,020.21) 30,854.96 30,854.96 1,392,997.05 18,854.85 7,890,553.22 9,302,405.12 9,333,260.08 8,538,762.45 1,140.08 8,539,902.53 4,159,790.52 4,159,790.52 4,159,790.52 4.159,790.52 4.159,790.52 30,854.96 30,854~96 1,392,997.05 18,854.85 3,730,762.70 5,142,614.60 5.173,469.56 4,378.971.93 1,140.08 4,380,112.01 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 07/31/2001 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. // VARIANCE *********************** SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE 237,172.56 12,128.59 249,301.15 237,172.56 12,128.59 249,201.15 *******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 EXCESS <REVENUE>EXPENDITURE 232,578.00 232,578.00 232,578.00 232,578.00 232.578.OO 232,578.00 232,578.00 232,578.00 232,578.00 232,578.00 234,093.57 234,093.57 234,093.57 (15,207.58) (15,207.58) 507.79 507.79 507.79 507.79 507.79 233,585.78 233,585.78 233,585.78 (15,715.37) (15,715.27) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 07/31/2001 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 1,171,448.00 17,000.00 93,454.87 298,835.00 96,664.80 1,077,993.13 944,535.35 17,000.00 6,495.00 104,492.43 96,664.80 840,042.92 6,495.00 1,487,283.00 93,454.87 1,393,828.13 1,047,695.15 104,492.43 943.202.72 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: FIRE ACTIVITY TOTAL TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS 990,046.00 29,366.38 960,679.62 504,555.13 1,056.00 503,499.13 990,046.00 29,366.38 960,679.62 504,555.13 1,056.00 503,499.13 45,828.00 45,828.00 189.750.00 45,828.00 40,700.28 45,828.00 40,700.28 189,750.00 20,576.74 40,700.28 40,700.28 20,576.74 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 1,225,624.00 (261,659.00) (261,659.00) 29,366.38 (64,088.49) (64.088.49) 1,196,257.62 565,832.15 (197,570.51) (481,862.00) 2,400,000.00 (197,570.51) (2,881,863.00) 1,056.00 564,776.15 103,436.43) (378,426.57) 2,400,000.00 103,436.43)(2,778,426.57) CURRENT BUDGET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 07/31/2001 ENTERPRISE FUND CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR 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