Loading...
HomeMy WebLinkAbout4.15 PrelFinRpt Aug/Sept01CITY CLERK FILE # 330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: October 16, 2001 SUBJECT: Preliminary Financial Reports For the Months of August and September 2001 Report Prepared by: Fred Marsh, Finance Manager ATTACHMENTS: RECOMMENDATION: 1. YTD Revenues and Budget Comparison 2. YTD Expenses and Budget Comparison 3. Financial Statements for the Months of August and September 2001 r po s. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the preliminary financial statements for the months of August and September. 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 November 6, 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. Analysis of Preliminary September 2001 Revenue and Expenditure Report Given that this is only the third month of the 2001/2002 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 also 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 September are comparable to what occurred in the third month of the previous Fiscal Year. The City had collected through September 2001 approximately 15% of the total budgeted General Fund Revenues, which was the same percentage as in the prior Fiscal Year. Real Property Transfer Tax is lower than in the same period in the prior year due to a decrease in the dollar amount of residential and commercial property sales transactions within the City. Transient Occupancy Taxes are lower than in the same period of the prior year due to timing differences in the collection of these taxes. 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. COPIES TO: G:\Monthly Finaneials\08 and 092001 agenda statement monthly financials, doc ITEM NO. Interest and Rentals are lower than in the same period of the prior year due to a decline in interest rates and timing differences in the receipt of interest earnings from the City's investments. Charges for Services are higher than in 'the same period of the prior year due to the receipt of one time monies from AT&T for cable equipment, and additional monies received for planning and fire plan check fees for work performed by staff and consultants on new development occurring within the City. Intergovernmental Revenue is higher than the same periOd of the prior year due to an increase in the allocation of State Motor Vehicle in Lieu fees from the State. General Fund Expenditures Overall, through the month of September expenditures in the General Fund totaled $3,897,918 and represented approximately 11% of the total budgeted expenditures in the General Fund. Of this amount, a total of $1,030,090 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. 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. In looking at only General Fund Operating Expenditures, the activity through September 2001 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of September 30, 2001, the City had expended 11% of the General Fund Operating Budget compared to 10% 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. City of Dublin 2001-2002 YTD Revenues and Budget Comparison For the Period Ending September 30, 2001 Total General Fund Revenues I! 15%4 15%4 Property Taxes · FY 2001/2002 FY 2000/2001 Re~ Property Transfer Tax ~14% Transient Occupancy T~es 17~ Franchise T~es ~o Licenses and PermitS ~ ~ 37% Interest and Rentals ~175 Intergovernmental from State 28% % Charges for Ser~ces ;6o~ Fines and Forfeitures ~7% Other Revenues ~3% 0% 30% 60% 90% 120% 150% 25% of Year COmplete 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 FY 2001102 FY 2001/02 % of FY 2000101 % of Total for Budget YTD Actual Budget YTD Actual FY 2000101 8,258,100 527,038 6% 413,589 6% 13,200,000 2,357,933 18% 2,124,727 16% 450,000 23,936 5% 79,290 14% 1,035,000 131,393 13% 170,714 17% 1,254,830 114,365 9% 95,218 7% 2,957,140 474,078 16% 1,131,078 37% 1,787,578 100,526 6% 454,266 17% 1,948,150 543,658 28% 428,835 21% 3,859,216 1,021,057 26% 540,408 15% 102,000 27,324 27% 25,357. 24% 1,021,672 58,422 6% 70,023 3% 35,873,686 5,379,730 15% 5,533,505 15% ATTACHMENT City of Dublin 2001-2002 YTD Expenses and Budget Comparison For the Period Ending September 30, 2001 Total General Fund Expenses General Government Police Fire Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects i~1-~11% % iillll~19% r% % 4% mmm~14~ 14~. ~12% 8% 12% 0% 20% 40% 60% 80% 100% 25% 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 2001/02 Budget 3,853,768 6,8'01,424 4,663,477 292,463 1,127,147 64,495 4,265,669 5,647,549 8,030,596 34,746,588 26,715,992 FY 2001/02 % of YTD Actual Budget 743,568 19% 244,046 4% 64,373 1% 10,684 4% 160,103 14% 1,763 3% 745,259 17% 890,032 16% 1,038,090 13% 3,897,918 11% 2,859,828 11% FY 2000/01 YTD Actual 539,756 130,942 128,146 9,295 134,503 1,655 590,754 798,321 41,404 2,374,776 2,333,372 %ofTotalfor FY 2000/01 17% 2% 3% 4% 14% 12% 18% 18% 2% 9% 10% ATTACHMENT 2 CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTHS OF AUGUST AND SEPTEMBER 2001 Prepared by The Finance Department October 9, 2001 ATTACHMENT 3 GENEP~qL REVENUE FUNDS CITY OF DUBLIN' BALANCE SHEET FOR THE PERIOD ENDING 30Sep2001 SPECIAL SPECIAL CAPITAL TRUST/ REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUND FUND TOTALS ---MEMORANDUM ONLY--- CURRENT PRI OR ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW (35,235.084) INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 73,658,557 157.651 312,860 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 7,626 38,901,609 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 (926,064) (32,330) (399.519) (778,610) (335,011) (12,007) (146.433) (2,629,974) (36,271.636) TOTAL FUND E (36.271,636) TOTAL LIAB. FND BAL. RETD (38,901,609) 2,443,710 296,409 2,740,119 (17.705) (17.705) (2,722,414) (2,722,414) (2,740.119) 396,725 30,137,872 109,300 396,725 30,247,172 (30.115,078) (30,115,078) (396,725) (132.094) (396,725) (132,094) (396,725) (30,247,172) 13.120 167,304 (2,487,681) (24,052.805) 167,304 166,814 109,300 109,300 73.658,557 76,149,328 454,060 3,517,725 312,860 744.407 1.652,500 1.832,925 7,626 1,652,500 73,874,526 550,856 5,175 1,652.500 58.843,299 (926,064) (512.334) (30,147,408) (11,556,340) (399,519) (414,923) (796,314) (5,323,868) (335,011) (547,869) (12,007)- (603,122) (146,433) (147,203) (1,770,000) (1,770,000) (1,770.000) (1,770,000) (34,532,756) (20,875.659) (62,925) (39,341,770) (37,967,640) (62,925) (39.341,770) (37,967.640) (1,832,925) (73,874,526) (58,843.299) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Sep2001 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,509,308 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.112,016 27,621,324 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 (1) (1) (27.621,324) TOTAL FUND E (27,621.324) 15.987,209 41,651,252 15.987,209 41,651,252 (15,987,209) (15,987,209) (41,651,352) (41,651,352) 2,748,675 2,694.870 6.495 38,099,225 38,099,225 41.651,352 41,734,598 82,499,251 82,535,188 (1) (4,446) (41,651,352) (41.734,598) (41,651,352) (41,739,045) (40.847,899) (40,796,143) (40.847.899) (40,796,142) TOTAL LtAB. FND BAL. RETD (27.621,324) (15,987,209) (41,651,352) (82,499,251) (82,535.188) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 09/30/2001 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 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL CITY MANAGER CENTRAL SERVICES CITY A1-TORNEY ADMIN SERVICES BUILDING MANAGEMENT INSUP~ANCE 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 527,037.54 7,731,062.46 7,174,289.56 413,588.96 13,200,000.00 2,357,932.98 10,842,067.02 12,985,986.39 2,124,726.52 450,000.00 23,935.88 426,064.12 575,281.78 79,290.17 1,035,000.00 131,393.33 903,606.67 1,010,799.01 170,714.33 1,254,830.00 114,365.00 1,140,465.00 1,313,086.74 95,218.00 2,957,140.00 474,077.96 2,483,062.04 3,028,655.28 1,121,078.28 102,000.00 27,324.45 74,675.55 106,233.99 25,357.21 1.688,988.00 80,633.34 1,608,354.66 2,512,223.69 437,083.96 98,590.00 19,892.61 78,697.39 114,614.48 17,182.38 1,948,150.00 543,657.71 1,404,492.29 2,006,116.43 428,834.82 6,760 700.60 10.861 259.87 495 991.61 840 084.68 1,217 868.74 1,897 577.00 80 876.78 2,075 139.73 97432.10 1,577,281.61 3,859,216.00 1,021,057.30 2,838,158.70 3,719,568.13 540,407.63 3,179,160.50 1,021,672.00 58,422.12 963;249.88 2,715,619.50 70,023.12 2,645,596.38 35,873,686.00 5,379,730.22 30,493,955.78 37,262,474.98 5,533,505.38 31,728,969.60 33 047.27 110 290.22 64 469.95 107 557.38 211 779.22 83965.19 132 458.90 743,568.13 244,045.89 10,684.49 64,273.t0 319,103.48 116,301,60 9,631.16 4,200.74 29,969.97 160,103.47 200 391.73 574 547.78 234 187.05 361 781.62 747 034.78 597 996.81 256 856.10 i 532.00 135 872.00 3,110 199.87 6,557,378.1t 63,495.00 180,757.00 37,526.51 4,599,103.90 11,438,260.52 457,723.40 6,406.00 129,568.84 51,428.26 321,917.03 967,043.52 157649.46 451460.84 254 490.40 566 876.47 755 484.16 56t 347.95 273 267.70 12,013.21 52,946.02 2,085,536.21 5,842,597.93 49,327.13 136,902.24 41,743.47 4,331,237.29 10,401,809.06 504,545.32 79.88 105,015.72 52,929.17 297,19t.50 959,761.59 34,036.71 97,357.73 49,483.73 58,566.15 140,611.11 62,338.97 97,242.t5 19.23 539,755.78 130,94t.71 9,294.75 128,146,26 268,382.72 94,729.75 14,694.13 3,589.32 21,489.63 124,502.83 233,439.00 684.838.00 298,657.00 469,339.00 958,814.00 681,962.00 389,215.00 1,532.00 135,872.00 3,853,768.00 6,801,424.00 63,495.00 180,757.00 48,211.00 4,663,477.00 11,757,364.00 574,025.00 6,406.00 i39,200.00 55,629.00 351,887.00 1,127,147.00 123,612.75 354.103.11 205,006.67 508,310.32 614,873.05 499,008.98 175,925.55 11,993.98 52,946.02 2,545,780.43 5,711,656.22 49,327.13 136,903.24 22,448.72 4,202,091.03 10,133,426.34 409,815.57 79.88 90,321.59 49,239.85 275,701.87 825,258.76 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 09/30/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.00 25.00 8,370.00 1,483.29 15,000.00 938.00 14,062.00 12,000.00 41,100.00 800.00 40,300.00 64,495.00 1,763.00 62,732.00 13,483.29 400,725.00 400,725.00 362,922.00 148,028.00 62,101.40 85,926.60 48,979.05 84,170.00 9,487.03 74,682.97 64,337.03 39,687.00 1,634.21 38,052.79 35,168.63 1,138,123.00 97,944.85 1,040,178.15 863,488.51 81.482.00 54,757.00 26,725.00 65,376.81 398,810.00 73,862.10 324,947.90 299,517.32 236,890.00 52,552.11 184,337.89 179,746.06 265,856.00 46,318.63 219,537.37 223,534.64 58,975.00 12,598.42 46,276.58 54,261.57 108,839.00 23,375.14 85,463.86 95,263.42 80,704.00 20,335.07 60,368.93 74,298.29 93,023.00 13,703.64 79,219.36 76,437.85 37,990.00 1,851.07 36,138.93 37,226.81 256,707.00 67,094.23 189,612.77 200,963.28 156,680.00 20,774.01 125,905.99 137,807.83 130,122.00 32,480.63 97,641.37 116,758.13 368,051.00 118,175.82 249,875.18 300,625.35 180,807.00 26,213.61 154,593.39 95,707.64 4,265,669.00 745,258.97 3,520,410.03 3,332,420.23 1,764,970.00 304,053.87 1,460,916.13 1,330,195.42 1,622,000.00 245,843.23 1,376,156.67 1,334,934.18 1,999,416.00 248,295.27 1,751,120.73 1,606,493.94 261,163.00 91,839.51 169,323.49 254,453.24 5,647,549.00 890,031.98 4,757,517.02 4,526,076.78 5,200,547.00 883,880.92 4,316,666.08 1,435,693.51 1,170,874.00 31,662.51 1,139,211.49 180,763.51 665,862.00 1,011.51 664,851.49 462,208.60 993,312.00 121,534.57 871,777.43 603,894.29 8,030,596.00 1,028,089.51 6,992,506.49 2,682,559.91 1.053.88 601.00 1,654.88 25,221.39 11,093.66 2,109.86 62 803.84 51 499.68 63 048.32 45 813.99 41 231.13 12 406.72 20 882.66 13 220.67 11 180.26 1,403.72 45,386.06 28,057.60 24,999.15 108,639.19 21.755.91 590,753.91 271,748.52 149,628.07 256,377.83 120,566.43 798,320.85 30,583.91 401.44 i0,418.71 41,404.06 429.41 11,399.00 11,828.41 362,922.00 23,757.66 53,243.37 33,058.77 800,684.67 13,877.12 236,469.01 133,922.07 182,303.51 41 854.85 74 380.76 61 077.62 65 257.49 35 822.09 155577.22 109750.23 91,758.98 191,986.16 73,951.73 2,741,666.32 1~058,446.90 1,!85,206.11 1,350,116.11 133,886.81 3,727,755.92 1,405,109.60 180,362.07 462,208.60 593,475.58 2,641,155.85 34,746,588.00 3.897,918.54 30,848,669.46 25,001.647.07 2,374,775.03 22,626,872.04 1,127,098.00 1,48t,811.68 (354,713.68) 12,260,827.91 3,158,730.35 9,102,097.56 17,201.67 17,201.67 (2,400,190.0t) (2,400,190.01) 1,127,098.00 1,481,811.68 (354,713.68) 9,877,839.57 3,158,730.35 6,719,109.22 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 09/30/2001 SPECIAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** 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 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 90,175.00 81,587.21 81,587.21 36,026.22 194,473.78 218,443.36 29,810.88 t88,632.48 107.46 145,047.54 136,129.02 11,650.98 124,478.05 110,312.00 186,396.07 186,296.07 112,232.57 3,191,536.43 1,401,011.82 230,399.21 1,170,612.61 234,000.00 235,575.00 27,889.00 207,686.00 20,195.00 1,102,143.00 486,386.87 486,386.87 876,760.00 766,872.19 766,872.19 5,000.00 17,930.25 17,930.25 168,561.25 5,949,447.75 2,530,33t.80 299,750.07 3,230,581.73 302,730.00 33,675.22 269,054.78 163,769.23 175,041.00 3,953.09 171,087.91 87,789.56 177,100.00 273.06 176,826.94 188,299.58 654,871.00 37,901.37 616,969.63 439,858.37 175,084.00 5,000.48 170,083.52 348,601.71 175,084.00 5,000.48 170,083.52 248,601.71 1,049,577.00 1,807.56 1,047,769.44 1,108,496.91 7,500.00 7.500.00 7,500.00 10,000.00 10,000.00 9,918.66 1,067,077.00 1,807.56 1,065',269.44 1,125,915.57 6,000.00 1,001.00 4,999.00 4,999.00 6,000.00 1,001.00 4,999.00 4,999.00 80,373.00 80,373.00 86,648.98 411,119.00 411,119.00 4,678,511.00 142,825.35 4,535,685.65 760,517.95 5,170,003.00 142,825.35 5,027,177.65 847,166.93 7,073,035.00 188,535.76 6,884,499.24 2,766,541.58 955,026.00 19,974.5t 935,051.49 (763,790.22) 15,061.59 955,026.00 19,974.51 935,051.49 (748,728.63) 8,762.07 2,834.51 975.00 12.571.58 45,955.70 45,955.70 2,486.37 2,486.37 7,669.33 16,181.29 23,850.62 84,864.27 (214,885~80) (2t4,885.80) 155,007.16 84,955.05 187,324.58 427,286.79 302,646.01 302,646.01 1,106,010.54 7,500.00 9,918.66 1,123,429.20 4,999.00 4,999.00 78,979.65 744,336.66 822,316.31 2,681,677.31 (548,904.42) 15,061.59 (533,842.83) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 09/30/2001 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 20,187.00 6,000.00 455,635.00 429.448.00 20,187.00 6,000.00 455,635.00 384,648.76 26,456.80 2,300.37 413,405.93 2,300.37 2,300.37 384,648.76 26,456.80 411,105.56 *******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 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE 230,635.00 230,635.00 4,807.00 15,065.00 280,667.00 300,539.00 7,115.00 7,115.00 538,289.00 82,654.00 24.848.08 24.848.08 1,251.62 1,032.60 22,048.20 24.332.42 4,645.15 4,645.15 53,825.65 53,825.65 205,786.92 205,786.92 3,555.38 14,032.40 258,618.80 276,206.58 2,469.85 2,469.85 484,463.35 28,828.35 119,085.13 119,085.13 2,753.02 4,175.26 130,649.00 137,577.28 11,050.38 11,050.38 2,519.14 2,519.14 270,231.93 (143,174.00) 13,857.50 13,857.50 852.15 177.33 17,312.62 18,342.10 4.300.08 4.300.08 94.30 94.30 36,593.98 34,293.61 105,227.63 105,227.63 1,900.87 3,997.93 113,336.38 119,235.18 6,750.30 6,750.30 2,424.84 2,424.84 233,637.95 (177,467.61) EXCESS <REVENUE>EXPENDITURE 82,654.00 53,825.65 28,828.35 (143,174.00) 34,293.61 (177,467.61) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 09/30/2001 CAP.I TAL IMPROVEMENT FUND CURRENT CURRENT PRIOR PRIOR. BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 1.640,682.00 27.719,269.00 39.359,951.00 1,640,682.00 37,719,269.00 8,882,376.17 39,359,951.00 8,882,376.17 8,882.376.17 8.882.376.17 *******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 i2.867,967.00 1.131,430.00 15,131,302.00 29,120.699.00 30,985,425.00 '(8,374,526.00) (8,374,526.00) 1.010.76 3,129.63 3,129.63 33.393.44 250.913.43 284,306.87 288,447.26 288.447.26 288.447.26 1.853,715.24 (3,129.63) (3.129.63) 12.834.573.56 1,131,430.00 14.880.388.57 28,846,392.13 30,696,977.74 (8,662,973.26) (8,662.973.26) 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) 10,855.10 10,855.10 115,170.30 1,323.21 4,374,308.51 4,490,802.02 4,501,657.12 4,501,657.12 4,501.657.12 19,999.86 19.999.86 821,692.15 17.531.64 3,516.212.21 4.355,436.00 4,375,435.86 (4.506,940.31) 1,140.08 (4,505,800.23) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 09/30/2001 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE 490.25 (490.'25) 490.25 (490.25) 237,172.56 16,539.29 253,711.85 237,172.56 16,539.29 252,711.85 *******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 166,466.18 66,111.82 234,093.57 163,602.54 70,491.03 232,578.00 166,466.18 66,111.82 234,093.57 162,602.54 70,491.03 232,578.00 166,466.18 66,111.82 234,093.57 163,602.54 70,491.03 232,578.00 165,975.93 66,602.07 (19,618.28) 163,602.54 (182,220.82) EXCESS <REVENUE>EXPENDITURE 232,578.00 165,975.93 66,602.07 (19,618.28) 163,602.54 (183,220.82) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 09/30/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 298,835.00 205,273.76 1,171.448.00 258,299.84 913,148.16 944,535.35 17,000.00 2,265.00 14,-735.00 6,495.00 1,487,283.00 260,564.84 1,226,718.t6 1,156,304.11 233,769.29 205,273.76 710,766.06 6,495.00 233,769.29 922,534.82 *******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 990,046.00 45,828.00 45,828.00 189,750.00 119,840.55 870,205.45 1,018,788.52 78,548.19 940,240.33 119,840.55 870,205.45 1,018,788.52 78,548.19 940,240.33 45,828.00 45,828.00 189,750.00 40,700.28 40,700.28 40,700.28 40,700.28 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 1,225.624.00 119,840.55 1,105,783.45 (261,659.00) (140,724.29) (120,934.71) 1,059,488.80 78,548.19 980,940.61 (96,815.31) (155,221.10) .58,405.79 2,400,000.00 2,400,000.00 EXCESS <REVENUE>EXPENDITURE (261,659.00) (140,724.29) (120,934.71) (2,496,815.31) (155,221.10) (2,341,594.21) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 09/30/2001 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** 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 EXCESS <REVENUE>EXPENDITURE 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Aug2001 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 iNVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS (35,222,764) 73,658,557 1,132.310 312,860 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 9,619 39.890,582 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 (770,316) (406,583) (2,313,746) (324,007) (83,190) (146,433) (4,054,275) (35,836,307) TOTAL FUND E (35,836,307) 2,174,964 690,182 2,865.146 (102,204) (102,204) (2,762,941) (2,762,941) 432,618 29,913.357 t3,120 167,304 109,300 3.184 1,652,500 425,802 30,022,657 1,832,925 (29.698,290) (4,319) (14,915) (4,319) (29~,713,205) (431,483) ~"(309,452) (43t,483) (309,452) (2,932,728) (24,052,805) 167,304 166,814 109.300 109,300 73,658,557 76,149,328 1,825,676 3,517,725 312,860 744,407 9,619 1,652,500 74,803,088 550,856 5,175 1,652,500 58,843,299 (770,316) (512,334) (29,698,290) (11.556,340) (406,583) (414,923) (2.435,185) (5,323,868) (334,00~) (547,869) (83,190) (603,122) (146,433) (147,203) (1,770.000) (1,770,000) (1,770.000) (1,770,000) (35.644,004) (20,875,659) (62.925) (39,159,084) (37,967,640) (62,925) (39,159,084) (37,967,640) TOTAL LIAB. FND BAL. RETD (39,890.582) (2,865,146) (435,802) (30,022,657) (1,832,925) (74,803,088 (58,843,299) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Aug2001 FIXED.ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP TOTA S -- -MEMOPJkNDUM- - - CURRENT PRIOR ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW 5,488,443 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,112,016 27,600,459 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 (201) (201) (27,600,258) TOTAL FUND E (27,600,258) 15,987,209 41,651,352 15,987,209 41,651.352 (15,987,209) (15,987,209) (41,651,352) (41,651,352) 2,757,465 2,694,870 6,495 38,099,225 38,099,225 41,651,252 41,734,598 82,508,041 82,535,188 (201) (4,446) (41,651,352) (41,734,598) (41,651,552) (41,739,045) (40.856.489) (40,796,142) (40,856,489) (40.796,143) TOTAL LIAB. FND BAL. RETD (27,600,459) (15,987,209) (41,651,352) (82,508,041) (82,535,188) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 08/31/2001 GENERAL REVENUE FUND CURRENT CURRENT -PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERLY 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 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 8,258,100.00 7,174,289.56 55,047.00 7,119,242.56 13,200,000.00 2,007,800.00 11,192,200.00 12,985.986.39 1,630,300.00 11,355,686.39 450,000.00 23,935.88 426,064.12 575,281.78 33,821.94 541,459.84 1,035,000.00 72,121,55 962,878.45 1,010,799.01 87,570.82 923,228.19 1,254,830.00 52,568.00 1,202,262.00 1,313,086.74 46,156.00 1,266,930.74 2,957,140.00 368,577.32 2,588,562.68 3,028,655.28 651,455.39 2,377,199.89 102,Q00.00 16,507.t0 851492.90 106,233.99 15,248.98 90,985.01 1,688,988.00 71,544.74 1,617,443.26 2,512,223.69 120,632.45 2,391,591.24 98,590.00 11,795.01 86,794.99 114,614.48 ,12,080.63 102,533.85 1,948,150.00 359,661.96 1,588,488.04 2,006,116.43 275,498.93 1,730,617.50 3,859,216.00 816,193.49 3,043,022.51 3,719,568.13 284,502.62 3,435,065.51 1,021,672.00 57,980.28 963,691.72 2,715,619.50 52,677.13 2,662,942.37 35,873,686.00 3,858,685.33 32,0t5,000.67 37,262,474.98 3,264,991.89 33.997,483.09 232,439.00 24,295.90 209,043.10 684,838.00 74,173.10 610,664.90 298,657.00 42,339.23 256,317.77 469,339.00 103,557.38 365,781.62 958,814.00 142,532.56 816,281.44 681,962.00 35,419.59 646,542.41 389,315.00 120,783.96 268,531.04 1,532.00 1,522.00 135,872.00 135,872.00 3,853,768.00 542,201.72 3,310,566.28 6,801,424.00 134,181.08 6,667,242.92 63,495.00 63,495.00 180,757.00 180,757.00 48,211.00 7,226.50 40,974.50 4,663,477.00 42,411.55 4,621,065.45 11,757,364.00 183,829.13 11,573,524.87 574,025.00 70,632.85 503,392.15 6,406.00 6,406.00 139,200.00 139,200.00 55,629.00 55,629.00 351,887.00 230.78 351,656.22 t,127,147.00 70,863.63 1,056,283.37 157 649.46 451 460.84 254 490.40 566 876.47 755 484.16 561 347.95 273 267.70 12013.21 52,946.02 3,085,536.21 5,842,597.93 49,327.13 136,903.24 41,743.47 4,331,237.29 10,401,809.06 504,545.32 79.88 105,015.72 52,929.17 297,191.50 959,761.59 25,302.33 53,777.79 27,243.12 81,873.31 25,369.73 78,606.73 17.23 292,190.24 68,861.56 5,351.76 100.121.54 174.334.86 45,780.16 7,199.13 52,979.29 132,347.13 .397 683.05 227 247.28 566 876.47 673 610.85 535 978.22 194 660.97 11 995.98 52 946.02 2,793,345.97 5,773,736.37 49,327.13 136,903.24 36,391.71 4,23t,115.75 10,227,474.20 458,765.16 79.88 97,816.59 52,929.17 297,191.50 906,782.30 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 08/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.00 15,000.00 41,100.00 64,495.00 400,725.00 148,028.00 84,170.00 39,687.00 1,138,123.00 81 482.00 398 810.00 236 890.00 265 856.00 58 975.00 108 839.00 80 704.00 93 022.00 37 990.00 256 707.00 156 680.00 120 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 25.00 8,370.00 t,483.29 15,000.00 12,000.00 41,100.00 25.00 64,470.00 13,483.29 4O0,725.OO 56,820.40 91,207.60 6,600.99 77,569.01 39,687.00 3,426.64 1,134,696.36 53,657.00 27.825.00 48,209.27 350,600.73 40,509.85 196,380.15 28,960.72 236.895.28 7,955.50 51,019.50 15,992.48 92,846.52 9,248.71 71,455.29 10,045.31 82,977.69 1,667.61 36,322.39 39,892.67 216,814.33 21,428.36 135,251.64 27,787.90 102,324.10 92,255.57 274,795.43 16,600.95 164,206.05 482,059.93 3,783,609.07 362 922.00 48 979.05 64 337.03 35 168.63 863 488.51 65 376.81 299 517.33 t79 746.06 222 534.64 54 261.57 95 263.42 74 298.29 76 437.85 27,226.81 200,963.28 137,807.83 116,758.13 300,625.35 95,707.64 3,232,420.23 185,499.77 1,579,470.23 1,330,195.42 146,868.36 1,475,121.64 1,334,934.18 139,289.87 1,860,126.13 1,606,493.94 58,021.68 203,141.32 254,453.24 529,679.68 5,117,869.32 4,526,076.78 5,200,547.00 864,442.38 4,336,104.62 1,435,693.51 1,170,874.00 24,999.99 1,145,874.01 180,762.51 665,863.00 639.53 665,223.47 462,208.60 993,312.00 112,461.27 880,850.73 603,894.29 8,030,596.00 1,002,543.17 7,028,052.83 2,682,559.91 22,894.52 5,834.20 750.00 431.10 50,532.00 36,843.26 27,314.61 21,949.59 5,943.83 12,709.29 6 608.96 7 237.29 I 105.12 23 813.31 16 424.10 11 966.14 68 367.12 11 176.23 331 900.77 123,934.36 44,801.47 118,148.95 77,395.43 364,280.21 3,535.62 137.74 3,673.36 1,483.29 12,000.00 13,483.29 362,922.00 26,084.53 58,502.83 34,418.63 863,057.41 14,844.81 262 674.07 152 431.45 201 585.05 48 317.74 82 554.02 67 689.33 69 200.56 36 121.69 177 149.97 121 282.73 104 791.99 232 258.22 84 531.41 3,000 519.46 1,206,261.06 1,290,132.71 1,488,344.99 177,057.81 4,161,796.57 1,432,157.89 180,763.51 462,208.60 603,756.55 2,678,886.55 34,746,588.00 2,812,202.26 31,934,385.74 25,001,647.07 1,219,358.73 23,782,288.34 1,127,098.00 1,046,482.07 80,614.93 12,260,827.91 2,045,633.16 10,215,194.75 17,201.67 17,201.67 (2,400~190.01) (2,400,190.01) 1,127,098.00 1,046,483.07 80,614.93 9,877.839.57 2,045,633.16 7,832,206.41 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 08/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 *******EXPENDITURES******* 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 t10,312.00 3,303,769.00 234,000.00 1,122,338.00 876,760,00 5,000.00 6,118,009.00 90,175.00 36,026.22 194,473.78 58.46 145,096.54 110,312.00 112,232..57 3,191,536.43 234,000.00 20,195.00 1,102,143.00 876,760.00 5,000.00 168,512.25 5,949,496.75 81 587.21 218 443.36 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 302,730.00 28,723.91 274,006.09 163.769.23 175,041.00 1,527.24 173,513.76 87,789.56 177,100.00 273.06 176,826.94 188,299.58 654,871.00 30,524.21 624,346.79 439,858.37 175,084.00 175,084.00 348,601.71 175,084.00 175,084.00 348,601.7t 1,049,577.00 273.06 1,049,303.94 1,108,496.91 7,500.00 7,500.00 7,500.00 10,000.00 i0,000.00 9,918.66 1,067,077.00 273.06 1,066,803.94 1,125,915.57 6,000.00 1,001.00 4,999.00 · 4,999.00 6,000.00 1,001.00 4,999.00 4,999.00 80,373.00 80,373.00 86,648.98 411,119.00 411,119.00 4,678,511.00 116,161.37 4,562,349.63 760,517.95 5,170,003.00 116,161.27 5,053,841.63 847,166.93 7,073,035.00 147,959.64 6,925,075.36 2,766,541.58 955,026.00 (20,552.61) 975,578.61 (763,790.22) 15.061.59 955,026.00 (20,552.61) 975,578.61 (748,728.63) 29,810.88 114,647.95 144,458.83 3~,573.56 33,573.56 1,511.37 1,511.37 5,331.86 6.074.51 11,406.37 46,491.20 (97,967.53) (97,967.53) 81,587.21 188,632.48 136,129.03 186,396.07 1,286.363.87 235,575.00 486,386.87 766,872.19 17,930.25 3,385,872.97 163,769.23 87,789.56 188,299.58 439,858.37 315,028.15 315,028.15 1,106,985.54 7,500.00 9,918.66 1,124,404.20 4,999.00 4,999.00 81,317.12 754,443.44 835,760.56 2,720,050.28 (665,822.69) 15,061.59 (650,761.10) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/0t/2001 THROUGH 08/3t/2001 SPECIAL ASSESSMENT FUND CURRENT BUDGET CURRENT PRIOR PRIOR ACTUAL VARIANCE FISCAL YEAR 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 384,648.76 20,187.00 26,456.80 6,000.00 2,300.37 455,635.00 413,405.93 384,648.76 26,456.80 2,300.37 413,405.93 *******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 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE 230,635.00 13,062.80 217,572.20 119,085.13 7,420.76 111,664.37 230,635.00 13,062.80 217,572.20 119,085.13 7,420.76 111,664.37 4,807.00 1,176.91 3,630.09 2,753.02 15,065.00 15,065.00 4,175.26 280,667.00 182.36 280,484.64 130,649.00 300,539.00 1,359.27 299,179.73 137,577.28 7,115.00 4,645.15 2,469.85 11,050.38 7,115.00 4,645.15 2,469.85 11,050.38 2,519.14 2,519.14 679.27 679.27 538,289.00 19,067.22 519,221.78 270,231.93 8,100.03 82,654.00 19,067.22 63,586.78 (143,174.00) 8,100.03 2.072.75 4,175.26 130,649.00 136,898.01 11,050.38 11,050.38 2,519.14 2,519.14 262,131.90 151,274.03) EXCESS <REVENUE>EXPENDITURE 82,654.00 19,067.22 63,586.78 (143,174.00) 8,100.03 (151,274.03) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 08/31/2001 CAPITAL 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 37,719,269.00 8,882,376.17 39,359,951.00 8,882,376.17 8,882,376.17 8,882,376.17 *******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,131,430.00 15,131,302.00 29,120,699.00 30,985,425.00 (8,374,526.00) (8,374,526.00) 673.84 1,854,052.16 2,129.63 (3,129.63) 30,854.96 3,129.63 (3,129.63) 30,854.96 5,859.72 12,862,107.28 936,862.45 1,131,430.00 18,854.85 101,426.75 15,029,875.25 7,890,520.72 107,286.47 29,023,412.53 8,846,238.02 111,089.94 30,874,335.06 8,877,092.98 111,089.94 (8,485,615.94) (5,283.19) 1,140.08 111,089.94 (8,485,615.94) (4,143.11) 4,464.83 41283,717.19 4,288,182.02 4,288,182.02 4,288,182.02 30,854.96 30,854.96 932,397.62 18,854.85 3,606,803.53 41558,056.00 4,588,910.96 (4,292,465.21) 1,140.08 4,288,182.02 (4,292.225.13) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 08/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 490.25 (490.25) 490.25 (490.25) 237,172.56 16,539.29 253,7tl.85 237,172.56 16,539.29 253,711.85 *******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 166,466.18 66,111.82 234,093.57 163,602.54 70,49~.03 232,578.00 166,466.18 66,111.82 234,093.57 163,602.54 70,491.03 232,578.00 166,466.18 66,111.82 234,093.57 163,602.54 70.491.03 232,578.00 165,975.93 66,602.07 (19,618.28) 163,602.54 (183,220.82) EXCESS <REVENUE>EXPENDITURE 232,578.00 165,975.93 66,602.07 (19,618.28) 163,602.54 (183,220.82) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 08/31/2001 INTERNAL SERVICE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE 298,835.00 298,835.00 205,273.76 1,171,448.00 186,401.38 985,046.62 944,535.35 17,000.00 2,265.00 14,735.00 6,495.00 156,550.64 205,273.76 787,984.71 6,495.00 1,487,283.00 188,666.38 1,298,616.62 1,156,304.1t 156,550.64 999,753.47 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: FIRE ACTIVITY TOTAL TRANSPORTATIONi HEALTH & WELFARE: CULTURE &LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 990,046.00 990,046.00 45,828.00 45,828.00 189,750.00 69,007.66 921,038.34 1,018,788.52 12,055.18 1,006,733.34 69,007.66 921,038.34 1,018,788.52 12,055.18 1,006,733.34 45,828.00 45,828.00 189,750.00 40,700.28 40,700.28 40.700.28 40,700.28 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TP, ANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 1,225,624.00 69,007.66 1,156,616.34 (261,659.00) (119,658.72) (142,000.28) 261,659.00) (119,658.72) 1,059,488.80 12,055.18 1,047,433.62 (96,815.31) (144,495.46) 47,680.15 2,400,000.00 2,400,000.00 (t42,000.28) (2,496,815.31) (144,495.46) (2,352,319.85) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2001 THROUGH 08/31/2001 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE EISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** 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 tN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00