Loading...
HomeMy WebLinkAboutItem 4.16 FinStmts 11-2000CITY CLERK FILE 330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: (December 19, 2000) SUBJECT: ATTACHMENTS: RECOMMENDATION: ~ FINANCIAL STATEMENT: Preliminary Financial Reports For the Month of November 2000 Report Prepared by: Carole Perry, Administrative Services Director and Fred Marsh, Finance Manager YTD Revenues and Budget Comparison YTD Expenses and Budget Comparison Financial Statements for the Month of November 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 November. The current monthly report includes the final audited results for Fiscal Year 1999/2000. 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 November 2000 Revenue and Expenditure Report The November report represents the reporting of revenues and expenditures for the first five months of the Fiscal Year. Major Property Tax revenue will not bc received until December. in the expenditure category, the November report does not include expenses for the first quarter of Police Services, which will bc paid at a later date. General Fund Revenues Total General Fund Revenues collected through November are comparable to what occurred in the fifth month of the previous Fiscal Year. The City had collected through November 2000 approximately 30% of the total budgeted General Fund Revenues compared to approximately 26% 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 three of the City's four hotels were open in November 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 five 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 COPIES TO: G:WIonthly Financials\ll2000 agenda statement monthly ~nancials.doc ITEM NO. 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 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 Exnenditures Overall, through the month of November expenditures in the General Fund totaled $5,630,909 and represented approximately 21% of the total budgeted expenditures in the General Fund. Of this amount, a total of $165,964 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 November 2000 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of November 30, 2000, the City had expended 24% of the General Fund Operating Budget compared to 21% 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 are higher 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 November 30, 2000 Total General Fund Revenues Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services Fines and Forfeitures Other Revenues ~ 30% ~~ 6% ~m38% '~"-;~::~-,~2:~::::~ 30% .;;~~ 32~ 58% ' ' ' ~ o 60% ~~g 43 % 54% 31 ~17% ill FY 2000/2001 ~ FY 1999/2000 0% 30% 60% 90% 120% 150% 42% of Year Complete Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes, Franchise Taxes Licenses and Permits Interest and Rentals I nte rg ove rn me nta I Charges for Services Fines and Forfeitures Other Revenues Total General Fund Revenues FY 2000/200~ FY 200012001 % of FY 99/00 Budget YTD Actual Budget YTD Actual 6,168,350' 413,589 7% 11,300,000 3,915,510 35% 288,000 153,382 53% 910,000 348,507 38% 1,017,840 199,784 20% 3,124,088 1,796,405 58% 1,513,259 904,882 60% 1,704,500 752,268 44% 3,415,408 1,163,681 34% 68,755 37,074 54% 2,990,075 104,174 3% 32,500,275 9,789,255 30% 528,360 3,253,269 90,147 243, 136 158,144 1,241,886 527,093 694,667 942,640 26,338 126,878 7,832,558 % Of Total for FY 99/00 9% 26% 30% t6% 32% 39% ~.3% 28% 31% '~7% 26% ~,~.. ......~,,00 ,o:2~ ATTACHMENT City of Dublin 2000-2001 YTD Expenses and Budget Comparison For the Period Ending November 30, 2000 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% 42% 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 2000/2001 Budget 2,937,967 6,061,524 4,448,831 283,619 960,383 19,390 3,451,699 4,780,762 4,375,700 27,319,875 FY200012001 % of YTD Actual Budget 943,723 32% 327,517 5% 1,132.055 25% 25,269 9% 289,454 30% 3,547 18% 1,192,101 35% 1,551,277 32% 165,964 4% 5,630,909 21% 22,944,175 5,464,944 24% FY 99~00 YTD Actual 781,107 195,035 756,507 20,964 258,212 0 997,338 1,184,979 116,028 4,310,170 4,194,142 % of Total for FY 99/00 34% 4% 18% 1I% 33% 0% 44% 33% 7% 20% 21% ATTACHMENT 2 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR T'HE MON.TH OF NOVEMBER 2000 Prepared by The Finance Department December 14, 2000 ATTACHMENT 3 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Nov2000 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,502.113) 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 12.272 31,050,889 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 (869,578) (81.463) (323,581) (199,6t3) (271,651) (85,174) (149,497) (1,980,558) (29,070,331) TOTAL FUND E (29,070,331) TOTAL LIAB. FND BAL. RETD 31.050,889) 2,003,864 65,646 556 2,070,066 (30,968) (30,968) (2,039,098) (2,039,098) (2,070,066) 221,933 21,716,761 515.300 221,933 22,232,061 26,807,275) (148.080)" (4.143) 26.959,498) 4,727,436 4,727,436 (221,933) (221.933) (221,933) (22,232,061) 4,233 157,925 (1,555,322) (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 12,272 13,144 1,745,500 1,745.500 57,482,607 48,125,255 (869,578) (663,000) (26,888,738) (12,455.564) (323,581) (354,683) (378,660) (4,536.975) (271.651) (85,174) (153,640) (1,863,000) (1,863,000) (1,863,000) (30;834,024) (44,658) (26,648,583) (44,658) (26,648,583) (1:907,658) (57.482.607) (446,756) (233,477) (153,640) (1,863.000) (20,707,095) 27,418,160) 27,418,160) 48,125,255) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FORTHE PERIOD ENDING 30Nov2000 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 INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 2.519,820 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 21,105,766 23,625,586 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,625,586) TOTAL FUND E (23,625.586) 8,626,020 48.519,614 8,626,020 48,519,614 (8,626.020) (8,626.020) (48,519,614) (48,519,614) 2,519.820 2,384,683 29,731,786 29,731.786 48.519,614 48,653,563 80,771,220 80,770,032 (6.353) (48,519,614) (48,653,563) (48,519,614) (48,659,916) (32.251,606) (32,110,116) (32.251,606) (32,110,116) TOTAL LIAB. FND BAL. RETD (23,625,586) (8,626,020) (48.519,614) (80.771,220) (80,770,032) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 11/30/2000 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES ~ALES 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 11,300,000.00 288,000.00 910,000.00 1,017,840.00 3.124.088.00 68.755.00 1.411,205.00 102,054.00 1,704,500.00 3,415,408.00 2,990,075.00 32.500,275.00 413,588.96 3,915,510.00 153,382.30 348.506.75 199,784.00 1,796,404.94 37,073.76 873,809.91 3t,071.87 752.267.61 1,163.680.53 104,174.28 9,789,254.91 5,754,761.04 7,384,490.00 134 617.70 561 493.25 818 056.00 1,327 683.06 3t 681.24 537 395.09 70 982.13 952 232.39 2,251,727.47 2,885,900.72 22,711,020.09 5,991,813.80 11,548,901.00 370,945.99 808,688.14 963,069.84 3,897,965.22 84,542.77 1,254,906.26 85,831.12 1,629,846.86 2,594.33 3.308,263.42 726,524.45 30,673,893.20 528,360.27 3,253.269.19 90,147.06 243,136.16 158,144.00 1,241,885.73 26.337.77 502.668.45 24.424.65 694,666.88 942,639.91 126,878.30 7,832,558.37 5,463,453.53 8,295,631.81 280,798.93 565,551.98 804,925.84 2,656.079.49 58,205.00 752,237.81 61,406.47 935,179.98 2,594.33 2,365,623.51 599,646.15 22,841,334.83 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL CITY MANAGER CENTRAL SERVICES CITY AI'FORNEY 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 445,805.00 250,000.00 293,882.00 889,601.00 505,311.00 120.00 245,493.00 7,350.00 130,000.00 2,937,967.00 6,061,524.00 63,760.00 177,595.00 42,264.00 4,448,831.00 10,793,974.00 508,071.00 861.00 107,031.00 45,768.00 298,652.00 960,383.00 47,665.56 168,269.15 88.427.25 118,426.84 258,626.74 157,554.29 102,838.30 1,915.29 943,723.42 327,517.28 '9,071.44 16,197.84 1,132,054.81 1,484,841.37 175,188.13 30,300.11 11,685.36 72,280.60 289,454.20 122,739.44 277,535.85 161,572.75 175,455.16 630,974.26 347.756.71 120.00 142,654.70 5,434.71 130,000.00 1,994,243.58 5,734,006.72 54,688.56 177,595.00 26,066.16 3,316,776.19 9,309,132.63 332,882.87 861.00 76,730.89 34,082.64 226,371.40 670,928.80 144,214.76 368,092.08 202,489.29 301,446.94 606,030.20 482,483.30 114.00 169,061.86 904.34 77.83 2,274,914.60 5,106,215.64 47,608.15 107,720.18 37,094.46 4,186,527.66 9,485.166.09 406,083.23 11,513.70 82.440.23 40,288.40 286,816.64 827,142.20 61,526.93 132,489.93 74,014.56 63,865.81 214,363.96 149,075.19 85,352.27 100.10 317.83 781.106.58 195,035.10 7,405.62 13.558.79 756,507.31 972,506.82 144,007.01 26.10 21,257.49 8,229.01 84,692.65 258,212.26 82,687.83 235,602.15 128,474.73 237,581.13 391,666.24 333,408.11 114.00 83,709.59 804.24 (240.00) 1,493,808.02 4,911,180.54 40.202.53 107.720.18 23,535.67 3.430,020.35 8,512,659.27 262,076.22 11,487.60 61,182.74 32,059~39 202.123.99 568,929.94 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 11/30/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 LIBP, ARY 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 GENE~L CIP PROJECTS COMMUNITY IMPROVEMENTS PARKS STREET CONSTRC/IMPROVEMENTS ACTIVITY TOTAL TOTAL EXPENDITURES EXCESS REVENUE (EXPENDITURES) T~NSFERS IN FROM OTHER FUNDS T~NSFERS OUT FROM OTHER FUNDS 7,390.00 12,000.00 19,390.00 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,350,595.00 1,313,919.00 1,816,058.00 300,190.00 4,780,762.00 2,546,651.00 377,563.00 506,976.00 944,510.00 4,375,700.00 27,319,875.00 5,180,400.00 22,850.00 (2,400,010.00) 1,053.88 6,336.12 7,085.81 2,493.00 9,507.00 12,000.00 3,546.88 15,843.12 19,085.81 90,730.50 29 537.79 21 293.86 9 170.98 241 549.14 56 905.43 106 002.71 7t 922.21 77 313.23 21369.97 36,851.75 27,146.56 29,790.43 4,894.99 91,561.31 54,915.70 45,948.98 138,843.56 36,352.24 1,192,101.34 475,984.94 379,860.49 548,297.03 147,134.73 1,551,277.19 72,769.50 8,928.97 61,228.13 23,037.62 165,964.22 5,630,908.62 4,158,346.29 272,191.50 22,070.21 46,567.14 24,166.02 617,257.86 12,946.57 206,310.29 141 286.79 156 527.77 34 420.03 68 201.25 48 615.44 45 253.57 29 140.01 161 622.69 90 070.30 83636.02 139 351.44 59,962.76 2,259,597.66 874,610.06 934,058.51 1,267,760.97 153,055.27 3,229,484.81 2,473,88t.50 368,634.03 445,747.87 921,472.38 4,209,735.78 21,688,966.38 1,022,053.71 22,850.00 (2,400,010.00) 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 1,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 6,180.73 18,655.59 4,491.89 176,551.62 47,805.84 99,904.60 59,589.50 61,683.61 17,705.28 23,374.20 21,487.64 26,461.62 3,126.50 I17,730.18 43,898.94 41,852.27 117,514.63 32,040.11 997,337.50 385,197.99 256,849.98 450,870.74 92,060.49 1,184,979.20 62,450.03 5,188.96 32,789.08 15,599.60 116,027.67 4,310,170.03 3,522,388.34 7,085.81 12,000.00 19,085.81 265,274.25 47,186.64 37,416.20 25,733.44 457,039.02 19,144.86 169,821.21 85,791.26 134,243.96 29,774.62 51,760.37 42,335.74 41,438.69 25,669.28 100,372.31 71,816.43 60,404.48 111,365.09 53,695.35 1,830,283.20 867,576.62 887,867.09 1,011,976.95 163,629.95 2,931,050.61 1,235,289.31 229,083.87 689,853.88 95,952.09 2,250,179.15 17,605,996.00 5,235,338.83 17,869.13 (931,640.50) REVENUES OVER(UNDER) EXPENDITURES 2,803,240.00 4,158,346.29 (1,355,106.29) 7,843,955.80 3,522,388.34 4,321~567.46 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 11/30/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 194,000.00 89,475.00 100,676.00 2,024,858.00 137,780.00 1,026,394.00 763,302.00 5,000.00 4,424,335.00 71,005.02 22,789.55 713,791.55 27,889.00 835,475.12 82 850.00 122 994.98 66 685.45 100 676.00 1,311 066.45 109 891.00 1,026 394.00 763 302.00 5 000.00 3,588,859.88 78,715.14 192,662.02 t13,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 701.36 74,809.07 20,142.21 301,608.52 24,215.00 7,525.31 7,148.26 31,609.31 467,759.04 78,013.78 117,852.95 93,228.75 103,772.70 856,925.32 153,689.00 80,154.36 726,060.73 8,992.00 2,218,689.59 *******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,657,505.00 2,951,329.00 5,241,270.00 816,935.00 22,850.00 28,571.18 20,864.20 975.00 50,410.38 68,597.63 68,597.63 203,503.55 203,503.55 8,908.11 226,828.84 235,736.95 558,248.51 (277,226.61) 177,668.82 120,780.80 88,150.00 386,599.62 591,298.37 591,298.37 966,031.45 7,500.00 10,000.00 983,531.45 6,000.00 6,000.00 276,095.89 8,820.00 2,430,676.16 2,715,592.05 4,683,021.49 1,094,161.61 22,850.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,997.81 59,617.41 20,517.41 429,360.36 523,492.99 2,218,445.31 (468,003.32) 17,869.13 40,112.22 40,112.22 20,407.97 20,407.97 13,832.96 13,832.96 5,322.83 3,577.66 7,065.44 15,965.93 90,319.08 (377,439.96 88,258.42 81,678.24 79,100.67 249,037.33 513,175.13 513,175.13 852,386.71 852,386.71 6,000.00 6,000.00 13,997.81 54,294.58 16,939.75 422,294.92 507,527.06 2,128,126.23 (90,563,36 17,869.13 EXCESS <REVENUE> EXPENDITURE 839,785.00 (277,226.61) 1,117,011.61 (450,134.19) (377,439.96 (72,694.23 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 11/30/2000 SPECIAL ASSESSMENT FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR 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 1,269.87 317,084.53 13,589.00 13,589.00 16,637.02 16,637.02 6,000.00 2,300.37 3,699.63 668.85 668.85 409,977.00 2,300.37 407,676.63 335,660.27 1,938.72 333,721.55 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 172,115.00 30,910.27 141,204.73 118,667.18 21,967.67 96,699.51 ACTIVITY TOTAL 172,115.00 30,910.27 141,204.73 118,667.18 21,967.67 96,699.51 TRANSPORTATION PUBLIC WORKS 4,480.00 1,086.65 3,393.35 3,613.20 1,394.48 2,218.72 STREET TREE MAINTENANCE 12,039.00 1,827.76 10,211.24 4,219.57 730.27 3,489.30 STREET LANDSCAPE MAINTENANCE 239,352.00 49,524.71 189,827.29 131,200.04 46,589.90 84,610.14 ACTIVITY TOTAL 255,871.00 52,439.12. 203,431.88 139,032.81 48,714.65 90,318.16 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 46.41 28,093.42 STREET CONSTRUCTION/IMPRVMNT 46,752.16 46,752.16 ACTIVITY TOTAL 52,840.00 94.30 52,745.70 74,891.99 46.41 74,845.58 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE 485,586.00 87,743.77 397,842.23 337,087.96 75,065.59 262,022.37 75,609.00 85,443.40 (9,834.40) 1,427.69 73,126.87 (71,699.18) EXCESS <REVENUE>EXPENDITURE 75,609.00 85,443.40 (9,834.40) 1,427.69 73,126.87 (71,699.18) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 11/30/2000 CAPITAL 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: 18,729,643.00 18,729,643.00 18,729,643.00 10,337,149.24 18,729,643.00 10,337,149.24 t0,337,149.24 10,337,149.24 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: T~NSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINIST~TION 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 T~NSFER IN FROM OTHER FUNDS T~NSFERS OUT TO OTHER FUNDS 31,334.00 15,934.00 15,400.00 12,389.68 31,334.00 15,934.00 15.400.00 12,389.68 56.72 56.72 12.332.96 12.382.96 1,628,667.00 225,850.54 1,402,816.46 1,859,640.67 '310,243.92 1,549,396.75 1,412,999.00 1.323.21 1,411,675.79 6,057,184.37 2,390,872.80 3.666,311.57 20,277,247.00 4,900,727.04 15,376,519.96 2,433,845.51 617,161.02 1,816,684.49 23,318,913.00 5,127,900.79 18,191.012.21 10,350,670.55 3,318,277.74 7,032,392.81 23,350,247.00 5.143.834.79 18,206.412.21 10,363,060.23 3,318,334.46 7,044,725.77 4.620,604.00 5,143,834.79 (523,230.79) 25,910.99 3,318,334.46 (3.292,423.47) EXCESS <REVENUE>EXPENDITURE 4,620.604.00 5,143,834.79 (523,230.79) 25.910.99 3,318,334.46 (3,292,423.47) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 11/30/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,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 t64,624.28 (164,624.28) 261,375.75 190,256.00 71,1t9.75 164,624.28 (164,624.28) 261,375.75 190,256.00 71,119.75 164,624.28 (164,624.28 164,624.28 (164,624.28 164,624.28 (164,624.28 261,375.75 14,904.55 14,904.55 190,256.00 190,256.00 190,256.00 71',119.75 (175,351.45) (175,351.45) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 11/30/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 392,166.67 527,331.33 580,974.63 240,499.39 340,475.24 17,000.00 17,000.00 42,214.73 10,455.79 31,758.94 1,124,170.00 392,166.67 732,003.33 688,513.53 250,955.18 437,558.35 *******EXPENDITURES******* GENE~L GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 1,014,920.00 129,047.55 885,872.45 865,319.44 124,032.72 741~286.72 1,043,745.00 129,047.55 9t4,697.45 865,319.44 124,032.72 741,286.72 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TP, ANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 1,043,745.00 129,047.55 914,697.45 (80,425.00) (263,119.12) 182,694.12 (2,480,425.00) (263,119.12) (2,217,305.88) 865,319.44 176,805.91 931,286.00 (754,480.09) 124,032.72 (126,922.46) 126,922.46) 741,286.72 303,728.37 931,286.00 (627,557.63> THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/02/2000 THROUGH 11/30/2000 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENE~L 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 T~NSFERS IN FROM OTHER FUNDS T~NSFERS OUT TO OTHER FUNDS 10.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 EXCESS <REVENUE>EXPENDITURE