Loading...
HomeMy WebLinkAbout4.11 PrelFin Oct 2000CITY CLERK FILE # 330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: (November 21, 2000) SUBJECT: EXHIBITS ATTACHED: RECOMMENDATION: FINANCIAL STATEMENT: Preliminary Financial Reports For the Month of October 2000 Report Prepared by: Carole Perry, Administrative Services Director and Fred Marsh, Finance Manager Pro Forma Balance Sheet and Income Statements for the Period Ending October 31, 2000 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 October. The current monthly report includes the final audited results for Fiscal Year 1999/2000. Consistent with prior reports, the focus will be on General Ftmd Revenues and Expenditures, which represent the most significant portion of the City's operations. Analysis of October 2000 Revenue and Exnenditure Renort The October report represents the reporting of revenues and expenditures for the first four months of the Fiscal Year. Major Property Tax revenue will not be received until December. In the expenditure category, the October report does not include expenses for the first quarter of Police Services and Fire Services, both of which will be paid at a later date. General Fund Revenues Total General Fund Revenues collected through October are comparable to what occurred in the fourth month of the previous FisCal Year. The City had collected through October 2000 approximately 24% of the total budgeted General Fund Revenues compared to approximately 20% in the prior Fiscal Year. Sales Tax is higher than in the same period of the prior year. The State has raised the amount of monthly sales tax advances to the City as a result of the increased sales activity within the City, primarily related to tax collections from motor vehicle sales. Real Property Transfer Tax is higher than 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 since only two of the City's four hotels were open in October of the prior year. Licenses and Permits are higher than in the same period in the prior year due to an increase in the valuation of building permits issued during the first four months of Fiscal Year 2000/2001. Interest and Rentals are higher than 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 COPIES TO: G:MMonthly Financials\102000 agenda statement monthly ~nancials.doc ITEM NO. pro rata basis at year end. Other Revenue iS lower than the same period in the prior year, since the developer' s contribution for construction on 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 October expenditures in the General Fund totaled $3,448,382 and represented approximately 13% of the total budgeted expenditures in the General Fund. Of this amount, a total of $63,399 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 October 2000 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of October 31, 2000, the City had expended 15% of the General Fund Operating Budget compared to 18% 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. Property Taxes Sales Taxes City of Dublin 2000-2001 YTD Revenues and Budget Comparison For the Period Ending October 31, 2000 - Unaudited 24% Total General Fund Revenues 0% 26% Real Property Transfer Tax 53% · FY 2000/2001 [] FY 1999/2000 Transient Occupancy Taxes Franchise Taxes 25% Licenses and Permits Interest and Rentals ~ 59% 36% Intergovernmental from State 36% 24% Charges for Services Fines and Forfeitures i47% 3~ Other Revenues 17% 0% 30% 60% 90% 120% 150% 33% of Year Complete FY 2000/2001 FY 200012001 % of Budget YTD Actual 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 413,589 7% 11,300,000 2,899,710 26% 288,000 153,382 53% 910,000 227,285 25% 1,017,840 141,786 14% 3, 124,088 1,430,649 46% 1,513,259 891,457 59% 1,704,500 620,061 36% 3,415,408 804;372 24% 68,755 32,472 47% 2,990,075 93,775 3% Total General Fund Revenues 32,500,275 7,708,538 24% FY 99~00 YTD Actual 439,035 2,423,369 90,147 114,740 119,636 1,069,362 523,943 588,316 751,503 20,607 122,647 6,263,304 % of Total for FY 99~00 7% 21% 24% 14% 12% 27% 39% 36% 23% 24% 17% 20% ATTACHMENT 1 City of Dublin 2000-2001 YTD Expenses and Budget Comparison For the Period Ending October 31, 2000 - Unaudited Total General Fund Expenses General Government Civic Center Lease Police Fire Other Public Safety Transportation Health and Welfare [] FY 2000/2001 [] FY 1999/2000 Culture & Community Services Community Development Capital Improv. Projects 0% 20% 40% 60% 33% of Year Complete 80% 100% 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 27,105,987 22,780,298 FY 200012001 % of YTD Actual Budget 724,645 25% 264,035 4% 153,215 3% 16,146 6% 222,951 23% 2,510 13% 855,841 25% 1,145,640 25% 63,399 1% 3,448,382 3,384,983 13% 15% FY 99~00 YTD Actual 625,860 155,794 733,249 12,303 187,584 0 802,987 968,520 24,755' 3,511,052 3,486,297 % of Total for FY 99/00 28% 3% 17% 6% 24% 0% 36% 27% 1% 16% 18% ATTACHMENT 2 CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF OCTOBER 2000 Prepared by The Finance Department November 6, 2000 ATTACHMENT 3 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 310ct2000 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 (25,218,045) INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 56,054,474 179,827 302,286 DUE FROM OTHERS INVENTORY AT COST. PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 4,143 11,737 31,334,422 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL (895.076) DEPOSITS FOR AB1600 FEES (161,675) DEPOSITS OTHERS (333,148) PAYABLES: ACCOUNTS (191,401) INTEREST PAYROLL (268,205) DUE TO OTHERS (163,279) DEFERRED REVENUE (149,497) DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (2,162,282) FUND BALANCES (29,172,141) TOTAL FUND E (29,172,141) 2,120,790 65,646 556 2,186,991 (17,075) (17,075) (2.169,916) (2,169,916) 239,457 21,230,493 515,300 239,457 21,745,793 (25,935,437) (167,840) 4,233 157,925 · (1,623,073) (10,431,784) 157,925 157,925 515,300 4,267,787 56,054,474 49,227,117 245,473 2,365,857 302,286 718,499 1,745,500 1,907,658 4,699 61.210 11,737 13,144 1,745,500 1,745,500 57,414.321 48,125,255 (895,076) (663,000) (26,097,112) (12,455,564) (333,148) (354,683) (376,316) (4,536,975) (268,205) (446,756) (163,279) (233.477) (4,143) (153,640) (153,640) (1,863.000) (1,863.000) (1,863,000) (26,107.420) (1,863,000).(30,149,777) (20,707,095) '(239.457) 4,361,627 (44,658) (27,264,545) (27,418,160) (239,457) 4,361,627 (44,658) (27,264.545) (27.418,160) TOTAL LIAB. FND BAL. RETD (31,334,422) (2,186,991) (239,457) (21,745,793) (1,907,658) (57,414.321) (48.125,255) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 310ct2000 FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP TOTALS - - -MEMORANDUM- - - CURRENT PRI OR ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW 2,487,031 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 23.592,797 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 (23,592,797) TOTAL FUND E (23,592,797) TOTAL LIAB. FND BAL. RETD (23,592,797) 8,626,020 28,197,188 8,626,020 28,197,188 (8,626,020) (8,626,020) (28,197,188) (28,197,188) (8,626,020) (28,197,188) 2,487.031 2,384,683 29,731,786 29,731,786 28,197,188 28,234,363 60,416,005 60,350,832 (6,353) (28,t97,188) (28,234,363) (28,197,188) (28,240,716) (32,218,817) (32,110,116) (32,218,817) (32,110,116) (60,416,0d5) (60,350,832) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 10/31/2000 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 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,899,710.00 8,400,290.00 11,548,901.00 2,423,369.19 9,125,531.81 288,000.00 153,382~30 134,617.70 370,945.99 90,147.06 280,798.93 910,000.00 227,284.94 682,715.06 808,688.14 114,740.03 693,948.11 1,017,840.00 141,786.00 876,054.00 963,069.84 119,636.00 843,433.84 3,124,088.00 1.430,649.35 1,693,438.65 3,897.965.22 1,069,361.77 2.828,603.45 68,755.00 32.471.75 36,283.25 84,542.77 20,606.82 63,935.95 1,411,205.00 864,598.27 546,606.73 1,254,906.26 501,534.35 753,371.91 102,054.00 26,858.64 75,195.36 85,831.12 22,408.70 63,422.42 1,704,500.00 620,061.05 1,084,438.95 1,629.846.86 588,316.02 1,041,530.84 2,594.33 2,594.33 3,415,408.00 804,372,12 2,611,035.88 3,308,263.42 751,502.54 2,556,760.88 2,990,075.00 93,774.86 2,896,300.14 726,524.45 122,646.75 603,877.70 32o500L275.00 7,708,538,24 24,791,736.76 30,673,893.20 6,263,304.10 24,410,589.10 *******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 170,405.00 41,677.54 128,727.46 144,214.76 445,805.00 134.278.77 311.526.23 368,092.08 250,000.00 65,238.75 184,761.25 202.489.29 293,882.00 81,110.99 212,771.01 302,446.94 889,601.00 196,573.23 693,027.77 606,030.20 494,721.00 104,422.04 390,298.96 482,483.30 120.00 120.00 114.00 245,493.00 101,324.40 144,168.60 169,061.86 7,350.00 19.23 7,330.77 904.34 130,000.00 130,000.00 77.83 2,927,377.00 724,644.95 2,202,732.05 2,274,914.60 6,061,524.00 264,034.82 5,797,489.18 5,106,215.64 63,760.00 3,740.80 60,019.20 47,608.15 177,595.00 177,595.00 107,720.18 42,264.00 12,405.65 29,858.35 37,094.46 4,448,831.00 153,214.81 4,295,616.19 4,186,527.66 10,793.974.00 433,396.08 10,360,577.92 9,485,166.09 508,071.00 138,298.57 369,772.43 406,083.23 861.00 861.00 11,513.70 107,031.00 22.335.06 84,695.94 82,440.23 45,768.00 8,086.36 37,681.64 40,288.40 298,652.00 54,230.90 244,421.10 286,816.64 960,383.00 222,950.89 737,432.11 827,142.20 43,511.07 105,783.08 55,266.90 63,135.50 172,698.95 100,353.77 85,090.73 20.12 625,860.12 155,793.88 2,747.15 9,556.25 733,249.16 901.346.44 112,381.08 21,257.49 6,394.32 47,550.79 187.583.68 100,703.69 262,309.00 147,222.39 238,311.44 433,331.25 382,129.53 114.00 83,971.13 884.22 77.83 1,649,054:48 4,950,421.76 44,861.00 107,720.18 27,538.21 3,453,278.50 8,583,819.65 293,702.15 11,513.70 61,182.74 33,894.08 239,265.85 639,558.52 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 10/31/2000 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR 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 PROGP, AM 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 1,053.88 6,336.12 7,085.81 12,000.00 1,456.00 10,544.00 12,000.00 19,390.00 2,509.88 16,880.12 19.085.81 362 922.00 51 608.00 67 861.00 33 337.00 858 807.00 69 852.00 312 313.00 213 209.00 233,841.00 55,790.00 105,053.00 75,762.00 75,044.00 34.035.00 253,184.00 144,986.00 129,585.00 278,195.00 96,315.00 3,451.699.00 1,197,308.00 1,313,919.00 1,816,058.00 300,190.00 4,627,475.00 2,507,540.00 374,583.00 506,976.00 936,590.00 4,325,689.00 27,105,987.00 5,394,288.00 27,686.07 16,881.48 6,214.06 169,835.33 54,949.81 84,576.68 58 771.56 58 957.54 16 611.82 27 496s13 18 949.11 23 990.11 2 439.29 57 938.32 43398.38 29,711.12 128,365.55 29,068.17 855,840.53 358,192.24 260,518.11 389,014.76 137,915.34 1,145,640.45 44,996.72 2,141.55 451.67 15,809.18 63,399.12 3.448.381.90 4.260.156.34 362,922.00 23,921.93 50,979.52 27,122.94 688,971.67 14,902.19 227 736.32 154 437.44 174 883.46 39 178.18 77 556.87 56 812.89 51 053.89 31 595.71 195 245.68 101 587.62 99 873.88 149 829.45 67 246.83 2,595,858.47 839,115.76 1,053,400.89 1,427,043.24 162,274.66 3,481,834.55 2,462.543.28 '372,441.45 506,524.33 920,780.82 4,262,289.88 23,657,605.10 1,134,131.66 342,557.00 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 1,252,774.61 1,144,717.07 1,462,847.69 255,690.44 4,116.029.81 t,297.739.34 234,272.83 722.642.96 111.551.69 2,366,206.82 21,916,166.03 8,757,727.17 17,869.13 (931,640.50) 77,282.75 5,706.22 13,921.57 1,613.02 111,436.93 46.900.26 80.170.87 50,085.50 45,127.62 '13,826.47 17,193.19 17,021.76 22,993.28 1,420.88 106.576.58 30,787.45 26,394.37 108,766.27 25,761.96 802,986.95 301.231.75 244,420.17 339,134.24 83,733.58 968,519.74 29,909.71 ~2,959.09 6,509.51 12,077.32 51,455.63 3.537,752.56 2,725,551.54 7.085.81 12,000.00 19,085.81 265.274.25 47,661.15 42,150.22 28,612.31 522,153.71 20,050.44 189.554.94 -95,295.26 150,799.95 33,653.43 57,941.38 46,801.62 44,907.03 27,374.90 111,525.91 84,927.92 75,862.38 120,113.45 59,973.50 2,024,633.75 951.542.86 900,296.90 1,123,713.45 171,956.86 3,147,510.07 1.267,829.63 231,3t3.74 716,133.45 99,474.37 2,314,751.19 18.378.413.47 6,032,175.63. 17,869.13 (931,640.50) REVENUES OVER(UNDER) EXPENDITURES 5,394,288.00 4,260.156.34 1,134,131.66 7,843,955.80 2.725,551.54 5,118,404.26 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 10/31/2000 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 82,850.00 82,850.00 194.000.00 53,560.38 140,439.62 89,475.00 22,707.07 66,767.93 100,676.00 100,676.00 2,024,858.00 660,586.59 1,364,271.41 137.780.00 27,889.00 109,891.00 1,026,394.00 1,026,394.00 763,302.00 763,302.00 5,000.00 5,000.00 4,424,335.00' 764,743.04 3,659,591.96 78 715.14 192 662.02 113 370.96 103 772.70 1.158 533.84 177 904.00 87 679.67 733 208.99 40 601.31 2,686 448.63 38.07 58,142.05 20,192.21 209,278.98 24,215.00 2,534.66 31,609.31 346,010.28 78,677.07 134,519.97 93,178.75 103,772.70 949,254.86 153,689.00 87,679.67 730,674.33 8,992.00 2,340,438.35 *******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 206,240.00 141,645.00 89,125.00 437,010.00 659,896.00 659,896.00 1,169,535.00 7,500.00 10,000.00 1,187,035.00 6,000.00 6,000.00 285,004.00 8,820.00 2,560,234.00 2,854,058.00 5,143,999.00 719,664.00 8,762.07 197,477.93 5,825.34 135,819.66 975.00 88,150.00 15,562.41 421,447.59 59,192.29 600,703.71 59,192.29 600.703.71 88,258.42 121,790.46 79,100.67 289,149.55 533,583.10 533.583.10 203,492.17 966,042.83 866,219.67 7,500.00 10,000.00 203,492.17 983,542.83 866,219.67 6,000.00 6,000.00 6,000.00 6,000.00 34,145.54 34,145.54 15,520.07 15,520.07 4,103.80 4.103.80 88,258.42 87,644.92 79,100.67 255,004.01 518,063.03 518,063.03 862,115.87 862,115..87 6,000.00 6,000.00 13,997.81 13,997.81 8,127.81 276,876.19 59,617.41 5,322.83 54,294.58 8,820.00 20,517.41 3,577.66 16,939,75 70,323.49 2,489,910.51 429,360.36 2,795.31 426,565.05 78,451,30 2,775,606.70 523,492.99 11,695.80 511,797.19 356,698.17 4,787,360.83 2,218,445.31 65,465.21 2,152,980.10 (408,044.87) 1.127,708.87 (468,003.32) (280,545.07) (187,458.25) 17,869.13 17,869.13 EXCESS <REVENUE> EXPENDITURE 719,664.00 (408,044.87) 1,127,708.87 (450,134.19) (280,545.07) 169,589.12) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 10/31/2000 SPECIAL ASSESSMENT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 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 317,898.39 16,637.02 668.85 335,204.26 *******EXPENDITURES******* PUBLIC SAFETY: T~FFIC SIGNALS & STREET LIG 172,115.00 20,256.61 151,858.39 118,667.18 18,595.71 100,071.47 ACTIVITY TOTAL 172,115.00 20,256.61 151,858.39 118,667.18 18,595.71 100,071.47 TRANSPORTATION PUBLIC WORKS 4,480.00 960.83 3,519.17 3,6t3.20 1,172.38 2,440.82 STREET TREE MAINTENANCE 12,039.00 1,487.63 10,551.37 4,219.57 689.57 3:530.00 STREET LANDSCAPE MAINTENANCE 239,352.00 43,120.55 196,231.45 131,200.04 24,490.64 106,709.40 ACTIVITY TOTAL 255,871.00 45,569.01 210,301.99 139,032.81 26,352.59 112,680.22 HEALTH & WELFARE: ENGINEERING 4,760.00 4,300.08 459.92 4,495.98 4,336.86 159.12 ACTIVITY TOTAL 4,760,00 4,300.08 459.92 4,495.98 4,336.86 159.12 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 52,840.00 94.30 52,745.70 28,139.83 43.93 28,095.90 STREET CONSTRUCTION/IMPRVMNT 46,752.16 46,752.16 ACTIVITY TOTAL 52,840.00 94.30 52,745.70 74,891.99 43.93 74,848.06 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE EXCESS <REVENUE>EXPENDITURE 485,586.00 70,220.00 415,366.00 337,087.96 49,329.09 287,758.87 75,609.00 67,919.63 7,689.37 1,427.69 48,873.08 (47,445.39) 75,609.00 67,919.63 7,689.37 1,427.69 48,873.08 (47,445.39) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 10/31/2000 CAPITAL IMPROVEMENT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 18,729,643.00 18,729.643.00 18,729,643.00 18,729,643.00 10.363,686.73 10,363,686.73 1,289.10 10,362.397.63 1,289.10 10,362,397.63 *******EXPENDITURES******* GENE~L GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINIST~TION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENE~L 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 12,634.00 11,261.32 1,372.68 12,389.68 12,634.00 11,261.32 1,372.68 12,389.68 1,628,667.00 115,170.30 1.513.496.70 1,859,640.67 56.72 12,332.96 56.72 12,332.96 43,196.85 1,816,443.82 1,204,210.00 1,323.21 1,202,886.79 6,057,184.37 2,026,521.96 4,030,662.41 15,884,132.00 4.676,808.06 11,207.323.94 2,433,845.51 367,668.71 2,066,176.80 18,717,009.00 4.793.301.57 13,923,707.43 10,350,670.55 2,437,387.52 7,913,283.03 10,363.060.23 (626.50) 4,804,562.89 13,925,080.11 4,804,562.89 (4,804,562.89) 18,729,643.00 2,437,444.24 7,925,615.99 2,436,155.14 (2,436,781.64) EXCESS <REVENUE>EXPENDITURE 4,804,562.89 (4,804,562.89) (626.50) 2,436,155.14 (2,436,781.64) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 10/31/2000 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 233,189.54 13,281.66 246,471.20 233,t89.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 164,624.28 (164,624.28) 261,375.75 190,256.00 71,119.75 164,624.28 (164,624.28) 261,375.75 190,256.00 71,119.75 164,624.28 (164,624.28) 261,375.75 190,256.00 71,119.75 164,624.28 (164,624.28) 14,904.55 190,256.00 (175,351.45) EXCESS <REVENUE>EXPENDITURE 164,624.28 (164,624.28) 14,904.55 190,256.00 (175,351.45 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 10/31/2000 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 187,672.00 187,672.00 65,324.17 65,324.17 919,498.00 313,790.76 605~707.24 580,974.63 192,766.85 388,207.78 17,000.00 17,000.00 42,214.73 270.02 41,944.71 1,124,170.00 313,790.76 810,379.24 688,513.53 193,036.87 495,476.66 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL. ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 1,0t4,920.00 107,708.41 907,211.59 865,319.44 122,154.29 743,165.15 1,043,745.00 107,708.41 936,036.59 865,319.44 122,154.29 743,165.15 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 107,708.41 936,036.59 (80,425.00) (206,082.35) 125,657.35 865,319.44 176,805.91 931,286.00 (80,425.00) (206,082.35) 125,657.35 (754,480.09 122,154.29 (70,882.58) (70,882.58) 743,165.15 247,688.49 931,286.00 (683,597.51) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 10/31/2000 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 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) EXCESS <REVENUE>EXPENDITURE 10.00 10.00