Loading...
HomeMy WebLinkAbout4.08 Prel Fin Sept 2000 CITY CLERK FILE #330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: (November 8, 2000) SUBJECT: Preliminary Financial Reports For the Month of September 2000 Report Prepared by: Carole Perry, Administrative Services Director and Fred Marsh, Finance Manager EXHIBITS ATTACHED: Pro Forrna Balance Sheet and Income Statements for the Period Ending September 30, 2000 RECOMMENDATION:/~ Receive the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the preliminary financial statements for the month of September. The reason that the report is presented as "preliminary" is that the final audited results of Fiscal Year 1999/2000 are not yet available. 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 recently completed the final phase of their field work necessary for the 1999/2000 audit. The final audit results will impact the reported Fund Balance presented in the attached monthly reports. Staff has already made the final year end accrual for sales tax, and anticipates the final entries will occur by the November report. The scope of any remaining final entries will not be significant when compared to all General Fund revenues and expenses. Analysis of Preliminary September 2000 Revenue and Expenditure Report Given that this is only the third 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 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 2000 approximately 16% of the total budgeted General Fund Revenues compared to approximately 15% in the prior Fiscal Year. Real Property Transfer Tax is higher than in the same period of the prior year due to increased sales of residential and commercial properties within the City. Transient Occupancy Taxes are higher than in the same period in the prior year as only two of the City' s four hotels were open in July of the prior year. COPIES TO: G:MMonthly Financials\092000 agenda statement monthly ~nancials.doc ITEM NO. Licenses and Permits are higher than in the same period in the prior year due to a increase in the valuation of building permits issued during the first three months of Fiscal Year 2000/2001. Interest and Rentals is higher than in the same period of the prior year due to timing differences and a higher cash balance. Initially all interest revenue is recorded in the General Fund and allocated to other funds on a pro rata basis at year end. Other Revenue is lower than in the same period as a contribution from a developer for construction of the City's new library is scheduled to occur later in the Fiscal Year. Based upon the limited information available there were not any areas with significant deviations from the current budget projections. General Fund Expenditures Overall, through the month of September expenditures in the General Fund totaled $2,368,402 and represented approximately 9% of the total budgeted expenditures in the General Fund. Of this amount, a total of $41,404 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 September 2000 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of September 30, 2000, the City had expended 10% of the General Fund Operating Budget compared to 13% 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. Fire Services is lower than in the same period in the prior year due to timing differences in payments for contract fire services. Culture and Leisure Services are lower than in the same period of the prior year due to timing differences in the payment for contract park maintenance services. 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 2000-2001 YTD Revenues and Budget Comparison For the Period Ending September 30, 2000 - Unaudited ]gli~16% Total General Fund Revenues ~ 5% ......... 1 Property Taxes ~ 19% Sales Taxes ~ 28% Real Property Transfer Tax ~ 12 Yo ~ 19% Transient Occupancy Taxes .:::::::~:! % .......... 12 Franchise Taxes ~!~ 36% Licenses and Permits ~20~/; Interest and Rentals Intergovernmental from State Charges for Services Fines and Forfeitures Other Revenues 0% 30% 60% 90% 120% 150% [] FY 20O0/2001 ~ FY 1999/2000-' 25% of Year Complete FY 200012001 Budget 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 6, 168,350 1,300,000 288,000 910,000 1,017,840 3,124,088 1,513,259 1,704,500 3,415,408 68,755 2,990,075 Total General Fund Revenues 32,500,275 FY 200012001 % of YTD Actual Budget 413,589 7% 2,124,727 19% 79,290 28% 170,714 19% 95,218 9% ! ,131,448 36% 147,534 10% 428,835 25% 541,053 16% 25,357 37% 70,423 2% 5,228, 188 16% FY 99/00 YTD Actual 439,035 1,800,969 44,297 99,394 81,100 790,796 35,036 475,260 484,106 17,021 74,720 4,341,734 % of Total for FY 99~00 7% 17% 12% 12% 8% 20% 2% 29% 15% 20% 11% 15% City of Dublin 2000-2001 YTD Expenses and Budget Comparison For the Period Ending September 30, 2000 - Unaudited Total General Fund Expenses General Government Civic Center Lease Police, Fire Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects 0% 20% 40% 60% 25% of Year Complete 80% 100% [] FY 2000/2001 [] FY 1999~2000 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 200012001 Budget 2,927,377 6,061,524 4,448,831 283,619 960,383 19,390 3,451,699 4,627,475 4,325,689 FY 200012001 % of YTD Actual Budget 538,823 18% 129,500 2% 128.074 3% 9,295 3% 133,858, 14% 1,6-55 9% 589,344 17% 796,450 17% 41,404 ,1% 27, 105,987 2,368,402 9% 22,780,298 2,326,998 10% FY 99~00 YTD Actual 430,462 111,103 717,382 5,436 107,442 0 487,045 606,759 24,755 2,490,384 2,465,629 % of Total for FY 99~00 19% 1 '7% 3% 't~% 0% 22% t7% I% 12% 13% CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF SEPTEMBER 2000 Prepared by The Finance Department October 9, 2000 ATTACHMENT 3 GENERAL REVENUE FUNDS ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW / (24.443,182) INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 53,808,011 212,051 135,193 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 60,543 10,824 29,783,440 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 (901,734) (41,538) (378,365) (214,467) (291.130) (131,467) (149,497) (2,108,197) (27,675.243) TOTAL FUND E (27,675,243) TOTAL LIAB. FND BAL. RETD (29,783,440) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Sep2000 SPECIAL SPECIAL CAPITAL TRUST/ REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUND FUND 1.648,661 TOTALS ---MEMO~NDUM ONLY--- CURRENT PRIOR 510,995 273,083 20.633.845 4,267,787 5.255 157,925 (1,882,338) (10.394.915) 157,925 157,925 4,267,787 4,267,787 53,808,011 49,227,117 723,046 2.365,857 135,193 551,406 556 2,160,212 273.083 24,901.632 1,745,500 ~1,908,680 61,099 61.210 10.824 13.144 1,745,500 1.745,500 59,027,046 47,995.031 (11,886) (56,400) (68,286) (2,091,926) (2,091,926) (2,160,212) (24,631,230) (166,493) (4,143) (24,801,866) (273,083) (99,766) (273,083) (99.766) (273,083) (24,901,632) (901.734) (24,672,768) 378,365) 392,846) (291,130) (187,867) (153.640) (1,863,000) (1,863,000) (1,863,000) (28.841,349) (45,680) (30,185,698) (45.680) (30,185,698) (1,908,680) (59,027,046) (663,000) (12,427,252) (354,683) (4,536,975) (446,756) (233,477) (153.640) (1.863,000) (20.678,783) (27,316,248) (27,316,248) (47.995,031) INTERNAL SERVICE FUNDS ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW / 2.455,307 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 20,382.611 22.837,918 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 (22.837,918) TOTAL FUND E (22,837.918) TOTAL LIAB. FND BAL. RETD (22,837,918) ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Sep2000 FIXED ASSETS GROUP OF ACCOUNTS GENERAL LONG TERM DEBT ACCOUNT GROUP 10.151,802 10.151.802 28,203,197 28,203,197 (10.151.802 (10,151.802 (10,151,802 (28,203,197) (28,203,197) (28,203.197) TOTALS - - -MEMORANDUM- - - CURRENT PRIOR 2.455,307: 2.379.573 30,534.412 30,534,412 28,203.197 28.234.363 61,192,917 61.148,348 (6.353) (28,203,197) (28,234,363) (28,203,197) (28.240,716) (32,989,720) (32,907,632) (32.989.720) (32.907,632) (61.192,917) (61,148,348) *******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 ATTORNEY ADMIN SERVICES BUILDING MANAGEMENT FACILITY RENTAL 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 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 09/30/2000 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE 170,405.00 33,696.55 136,708.45 144,214.76 33,693.81 110,520.95 445,805.00 97,212.84 348,592.16 368,092.08 68,261.92 299,830.16 250.000.00 49,361.64 200,638.36 202,489.29 32,716.27 169,773.02 293,882.00 58,566.15 235,315.85 301.446.94 38.661.60 262,785.34 889.601.00 140,285.49 749,315.51 606,030.20 115,449.37 490,580.83 494,721.00 62,338.97 432,382,03 482.483.30 63,081.36 419,401.94 120.00 120.00 114.00 114.00 245,493.00 97.842.15 148,150.85 169,061.86 78,597.74 90,464.12 7,350.00 19.23 7,330.77 904.34 904.34 t30,000.00 130,000.00 77.83 77.83 2.927,377.00 538,823.02 2,388,553.98 2.274,914.60 430,462.07 1,844,452.53 6,061,524.00 129.499.61 5,932.024.39 5,106,215.64 111,102.95 4,995,112,69 63,760.00 63,760.00 47.608.15 47,608,15 177,595.00 177,595.00 107,720.18 107,720.18 42,264.00 9,294:75 32,969.25 37,094.46" 5,436.20 31,658.26 4,448,831.00 128.073.79 4,320,757.21 4.186,527.66 ~17.381.52 3,469,146.14 10,793,974.00 266,868.15 10,527,105.85 9,485.166.09 833,920.67 8,651,245.42 508,071.00 94,085.05 413.985.95 406,083.23 71,047.08 335,036.15 861.00 861.00 11,513.70 11,513.70 107,031.00 14,694.13 b2,336.87 82.440.23 7,456.38 74,983.85 45.768.00 3.589.32 42,178.68 40,288.40 2,824.37 37,464.03 298.652.00 21,489.63 277.162.37 286,816.64 26,114.35 260,702.29 960.383.00 133.858.13 826,524.87 827,142.20 107.442.18' 719.700.02 6,168,350.00 413,588.96 5,754,761.04 5,991,813.80 439',034.87 5,552,778.93 11,300,000.00 2,124.726.52 9,175,273.48 11,548,901.00 1.800,969.19 9.747,931.81 288,000.00 79,290.17 208,709.83 370,945.99 44,296.71 326.649.28 910,000.00 170,714.33 739,285.67 808,688.14 99,394.23 709,293.91 1,017.840.00 95,218.00 922.622.00 963,069.84 81,100.00 881,969.84 3,124,088.00 1,131,448.28 1,992,639.72 3,897,965.22 790,796.09 3,107.169.13 68;755.00 25.357.21 43,397.79 84,542.77 17,021.30 67,521.47 1,411,205.00 130,672.73 1,280,532.27 1.158,379.26 19,273.35 t.139,105.91 102.054.00 16,861.09 85,192.91 85,831.12 15,762.36 70,068.76 1,704,500.00 428.834.82 1,275,665.18 1,629.846.86 475,259.74 1,154,587.12 2,594.33 2,594.33 3,415,408.00 541.052.63 2,874,355.37 3,308,263.42 484,105.87 2,824.157.55 2,990,075.00 70,423.12 2,919,651:88 726,524.45 74,719.82 '651,804.63 32,500,275.00 5,228.187.86 27,272,087.14 30,577,366.20 4,341,733.53 26,235,632.67 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 09/30/2000 GENERAL REVENUE FUN'D CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR PRIOR Y.T.D. VARIANCE WASTE MANAGEMENT CHILD CARE 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 / 7,390.00 12,000.00 19,390.00 1,053.88 6,336.12 7,085.81 601.00 11,399.00 12,000.00 1,654.88 17,735.12 19,085.81 362,922.00 51,608.00 25,221.39 67,861.00 11,093.66 33,337.00 2,109.86 858,807.00 62,803.84 69,852.00 51,499.68 312,313.00 61,753.00 213,209.00 45,813.99 233,841.00 41,231.13 55,790.00 12,406.72 105,053.00 20,882.66 75,762.00 13,220.67 75,044.00 11,180.36 34,035.00 1,403.72 253,184.00 45,271.22 144,986.00 28,057.60 129,585.00 24,999.15 278,195.00 108,639.19 96,315.00 21,755.91 3,451,699.00 589,343.75 362 922.00 26 386.61 56 767.34 31 227.14 796 003.16 18 352.32 250 560.00 167 395.01 192 609.87 43 383.28 84 170.34 62 541.33 63 863.64 32 631,28 207 912,78 116 928.40 104 585,85 169 555,81 74 559.09 2,862,355.25 342 557. O0 53 367.37 56 071.79 30 225.33 633 590.64 66 950.70 269 725.81 145 380.76 195 927.57 47 479.90 75 134: 57 63 823.38 67 900.31 28 795.78 218 102.49 115 715.37 102 256.75 228 879.72 85 735.46 2,827 620.70 7,085.81 12,000.00 19,085.81 342,557.00 431.55 52,935.82 8,560.77 47,511.02 979.19 29,246.14 59,087.08 574,503.56 45,986.00 20,964.70 54,866.30 214,859.51 35,774.t2 109,606.64 27,788.05 168,139.52 8,508.06 38,971.84 8,982.62 66,151.95 12,376.60 51,446.78 18,816.25 49,084.06 30.31 28,765.47 51,488.30 166,614.19 19,312.40 96,402.97 19,999.73 82,257.02 98,355.83 130,523.89 15,701.87 70,033.59 487,045.03 2,340,575.67 1,197,308.00 270,256.22 927,051.78 1,252,774.61 193,046.68 1,059,727.93 1,313,919.00 149,514.57 1,164,404.43 1,t44,717.07 163,573.49 981,143.58 1,816,058.00 256,377.83 1,559,680.17 1,462,847.69 178,064.99 1,284,782.70 300,190.00 120,301.18 179,888.82 255,690.44 72,074.04 183,616.40 4,627,475.00 796,449.80 3,831,025.20 4,116,029.81 606,759.20 3,509,270.61 2,507,540.00 30,583.91 2,476,956.09 1,297,739.34 15,457.26 1,282,282.08 374,583.00 401.44 374,181.56 234,272.83 527.41 233,745.42 506,976.00 506,976.00 722,642.96 5,152.52 717,490.44 936,590.00 10,418.71 926,171.29 111,551.69 3,617.77 107,933.92 4,325,689:00 41,404.06 4,284,284.94 2,366,206.82 '~4,754.96 2,341,451.86 27,105,987.00 2,368,401.79 24,737,585.21 21,916,166.03 2,490,384.11 19,425,781.92 5,394,288.00 2,859,786.07 2,534,501.93 8,661,200.17 1,851,349.42 6,809,850.75 17,869.13 17,869.13 (931,640.50) (931,640.50) REVENUES OVER(UNDER) EXPENDITURES 5,394,288.00 2,859,786.07 2,534,501.93 7,747,428.80 1,851,349.42 5,896,079.38 ********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 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 09/30/2000 SPECIAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. 82;850.00 194,000.00 89,475.00 100,676.00 ,024,858.00 137,780.00 ,026,394.00 763,302.00 5,000.00 ,424,335.00 82 29,810.88 164 .11,650.98 77 100 119,164.21 1,905 27,889.00 109 1,026 763 5 188,515.07 4,235 850.00 189.12 824,02 676.00 693.79 891.00 394.00 302.00 000.00 819.93 78,715.14 192,662.02 113,370.96 98,387.70 1,158,533.84 177,904.00 87,679.67 733,208.99 40,601.31 2,681,063.63 38.07 45,641.79 12,672.67 209,278.98 24,215.00 2,534,66 31,609.31 325,990.48 V~RIANCE 78,677.07 147,020.23 100,698.29 98,387.70 949,254.86 i53,689.00 87,679.67 730,674.33 8,992.00 2,355,073.15 /5 *******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 GENE~L 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 206,240.00 8,762.07 197,477.93 141,645.00 2,834.51 138,810.49 89,125.00 975.00 88,150.00 437,010.00 12,571.58 424,438.42 659,896.00 45,955.70 613,940.30 659,896.00 45,955.70 613,940.30 1,169,535.00 7,500.00 10,000.00 1,187,035.00 6,000.00 6,000.00 2,486.37 1,167,048.63 7,500.00 10,000.00 2,486.37 1,184,548.63 6,000.00 6,000.00 88,258.42 121,790.46 79,100.67 289,149.55 533,583.10 533,583.10 866,219.67 866,219.67 6,000.00 6,000.00 13,473.29 13,473.29 S,ss4.mo 8,554.10 3,716.75 3,716.75 88,258.42 108,317.17 79,100.67 275,676.26 525,029.00 525,029.00 862,502.92 862,502.92 6,000.00 6,000.00 13,997.81 13,997.81 285,004.00 7,669.33 277,334.67 59,617.41 1,948.50 57,668.91 8,820.00 8,820.00 20,517.41 ':-3,577.66 16,939.75 2,560,234.00 16,181.29 2,544,052.71 429,360.36 303.94 429,056.42 2,854,058.00 23,850.62 2,830,207.38 523,492.99 5,830.10 517,662.89 5,143,999.00 84,864.27 5,059,134.73 2,218,445.31 31,574.24 2,186,871.07 719,664.00 (103,650.80) 823,314.80 (462,618.32) (294,416.24) (168,202.08) 17,869.13 17,869.13 EXCESS <REVENUE> EXPENDITURE 719,664.00 (103,650.80) 823,314.80 (444,749.19) (294,4t6,24) (150,332.95) ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 09/30/2000 SPECIAL ASSESSMENT FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. 390,388.00 390,388.00 318,354.40 13,589.00 13,589.00 16,637.02 6,000.00 2,300.37 3,699.63 668.85 409,977.00 2,300.37 407,676.63 335,660.27 456.01 456.01 VARIANCE 317,898.39 16,637.02 668.85 335,204.26 *******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 172,115.00 13,857.50 158,257.50 118,667.18 172,115.00 13,857.50 158,257.50 118,667.18 4,480.00 12,039.00 239,352.00 255,871.00 852.15 3,627.85 3,613L20 177.33 11,861.67 '4,219.57 17,312.62 222,039.38 ~.131,200.04 18,342.10 237,528.90 139,032.81 6,669.86 6,669.86 822.50 241.03 15,256.80 16:320.33 111,997.32 111,997.32 2,790.70 3,978.54 115,943.24 122,712.48 4,760.00 4,300.08 459.92 4,495.98. 4,336.86 159.12 4,760.00 4,300.08 459.92 4,495.98 4,336.86 159.12 52,840.00 94.30 52,745.70 28,139.83 46,752.16 94'.30 52,745.70 74,891.99 52,840.00 28,139.83 46,752.16 74,891.99 485,586.00 36,593.98 448,992.02 337,087.96 27,327.05 309,760.91 75,609.00 34,293.61 41,315.39 1,427.69 26,871.04 (25,443.35) EXCESS <REVENUE>EXPENDITURE 75,609.00 34,298.61 41,315.39 1,427.69 26,871.04 (25,443.35) ********REVENUE******** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 09/30/2000 CURRENT BUDGET CAPITAL IMPROVEMENT FUND CURRENT PRIOR ACTUAL VARIANCE FISCAL YEAR 18,729,643.00 18,729,643.00 18,729,643,00 10,363,686.73 18,729,643,00 10,363,686.73 PRIOR Y.T.D. 686.28 686.28 VARIANCE 10,363,000.45 10.363,000.45 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: 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 12,634.00 10,855.10 1,778.90 12,389.68 12,634,00 10,855.10 1,778.90 12,389.68 1,628,667.00 t,204,210.00 15,884,132.00 18,717,009.00 18,729,643.00 115,170.30 1,513,496.70 1,859,640.67 56.72 56.72 31,529.30 12,332.96 12,332.96 1,828,111.37 1,323.21 1,202,886.79 6,057,184.37 1,030,850.61 5.026,333.76 215,821.51 15,668,310.49 2.433.845.51 165,746.33 2,268,099.18 332,315.02 18.384.693.98 10,350,670.55 1,228.126.24 9,122.544.31 343,170.12 18,386,472.88 10,363,060.23 t,228,182.96 343,170.12 (343,170.12) (626.50) 1,227,496.68 343,170.12 (343,170.12) (626.50) 1,227,496.68 9,134,877.27 (1,228,123.18) (1,228,123.18) CURRENT BUDGET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 09/30/2000 TRUST/AGENCY FUND CURRENT PRIOR PRIOR ACTUAL' VARIANCE FISCAL YEAR Y.T.D. VARIANCE *~*~REVENUES******** SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE 233,189.54 13,281.66 246,471.20 233,189.54 13,281.66 246,471.20 *******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 168,602.54 (168,602.54) 261,375.75 189,956.00 71,419.75 163,602.54 (163,602.54) 261,375.75 189,956.00 71,419.75 163,602.54 (163,602.54) 163,602.54 (163,602.54) 163,602.54 (163,602.54) 261,375.75 14,904.55 14,904.55 189,956.00 189,956.00 189,956.00 71,419.75 (175,051.45) (175,051.45) ********REVENUES******** USES/MONEY & PROP-INTEREST CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE THE CITYOF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 09/30/2000 INTERNAL SERVICE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE 187,672.00 187,672.00 60,214.17 60,214.17 919,498.00 233,769.29 685,728.71 580,974.63 144,717.59 436,257.04 17,000.00 17,000.00 42,214.73 235.02 41,979.71 1,124,170.00 233,769.29 890,400.71 683,403.53 144,952.61 538,450.92. *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT! CAPITAL IMPROVEMENT PROJECTS: 1.014,920.00 78,548.19 936,371.81 102,872.41 55,284.24 47,588.17 1,043,745.00 78,548.19 965,196.81 102,872.41 55,284.24 47,588.17 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER:FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 1,043.745.00 (80,425.00) (80,425.00 78,548.19 .(155,221.10) 965,196.81 74,796.10 102,872.41 (580,531.12 931,286.00 (155,221.10) 74,796.10 (1,511,817.12 55,284.24 47,588o17 (89,668.37) (490.862.75) 931,286.00 (89,668,37) (1,422,148.75) ********REVENUES******** USES/MONEY &PROP-INTEREST TOTAL REVENUE THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 09/30/2000 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********EXPENDITURE.S******* 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 t0.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 344.50 354.50 354.50 354.50 (354.50) 10.00 344.50 354.50 354,50 354,50 (354,50)