Loading...
HomeMy WebLinkAboutItem 4.07 Feb 2000 Fin Report CITY CLERK File # 0330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: (March 21, 2000) SUBJECT: Preliminary Financial Report For the Month of February 2000 Report Prepared by: Fred Marsh, Finance Manager EXHIBITS ATTACHED: Pro Forma Balance Sheet and Income Statements for the Month of February 2000 RECOMMENDATION: ~"/Receive the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the financial statements for the month of February. The budget changes presented in the Mid Year Financial Report and approved at the City Council Budget Study Session on February 29, 2000 will be included in next month's financial report. 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 February_ 2000 Revenue and Expenditure Report Through the first eight months of the fiscal year the revenue collections and expenses have been tracking similar to thc previous fiscal year. It should be noted that there is not an even distribution of revenues and expenditures on a monthly basis. For example, in the revenue category, the City receives significant property tax reVenues in the months of December and April, and the expenditures for major contracts such as Police and Fire Services lag since thc City is billed on a quarterly basis. A more detailed analysis of General Fund Revenue and Expenditures is shown on the attached reports and discussed below. General Fund Revenues Total General Fund Revenues collected through February are comparable to what occurred in the eight months of the previous Fiscal Year. The City had collected through February 2000 approximately 60% of the total budgeted General Fund Revenues compared to approximately 59% 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 the monthly sales tax advances to the City as a result of the increased sales activity within the City, primarily related to autos. It should be noted that a major portion of the annual sales tax is a result of the Christmas retail season, for which the City will not receive data until April. Transient Occupancy Taxes are higher than in the same period of the prior year due to additional revenues received from the City's two new hotels. The percentage of Franchise Fees collected is reflective of growth in the City. This report includes 100% of the Cable TV franchise taxes and Garbage franchise taxes through the month ended January 2000. As the subscription to these services increase the total revenue also increases. Similar trends are also COPIES TO: G:XMONTHFS\022000 agenda statement month financials.doc ITEM NO. reflected in the issuance of building permits. Through the month of February permits issued represented improvements valued in excess of $166 million. The data presented regarding Interest and Rental revenue is somewhat skewed in the current report as the interest earnings reported in the General Fund have not been allocated to all of the City's funds on a pro rata basis. This allocation is done on an annual basis. In addition, the City has had more cash available in the first eight months for investment than was assumed in the budget calculations. Intergovernmental Revenue is higher than in the same period in the'prior year due to an increase in the allocation of State Motor Vehicle In Lieu Fees from the State and the receipt of a one time ERAF repayment from the State of $63,700, out of a total of $150 million allocated by the State. The ERAF rebate was allocated to cities based upon each city's population. Charges for services are lower than in the same period in the prior year. This is due to a lower than expected amount of revenue for reimbursements received from developers for engineering plan checking services due to delays that have occurred on some development projects. The amount of the revenue recorded is based upon the payments made to date to outside contractors for these services. In the Other Revenue category, the amount budgeted to be received from the sale of a Fire Engine to Alameda County was billed in February and received in March. General Fund Expenditures Overall, through the month of February expenditures in the General Fund totaled $9,646,371 and represented approximately 41% of the total budgeted expenditures in the General Fund. Of this amount, a total of $711,945 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, activity through February 2000 was below the amounts expended for the same period in the prior Fiscal Year, primarily due to timing differences in the payment for contract fire services and several capital projects scheduled to be completed later in the Fiscal Year. Through February 2000, the City had expended 43% of the General Fund Operating Budget compared to 55% 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. Police Services is higher than in the same period of the prior year due to timing differences in the payment for contract police services. Fire Services is lower than the same period in the prior year due to timing differences in payments for contract fire services. Parks and Community Services Expenditures are lower than the same period in the prior year due to lower than expected expenditures to date for Park Maintenance. Community Development Expenditures are lower than in the prior Fiscal Year due to lower than expected expenditures incurred on new development for engineering professional services. Capital Improvements Projects expenditures are lower than in the same period of the prior year as several of the capital projects funded by the General FUnd in Fiscal Year 1999-2000 will not incur major expenditures until later in the Fiscal Year, including the purchase of a new fire apparatus, the Civic Center Design Modification and Roof Replacement Projects, the Downtown Median Paver Repair project, the Heritage Center Storage Building; the Alamo Canal Bike Path and the Swim Center Project. All expenditures to date are within the authorized budget. It is recommended that the City Council receive and file these reports as authorized by Section 41004 of the California Government Code. City of Dublin 1999-2000 YTD Revenues and Budget Comparison For the Period Ending February 29, 2000 - Unaudited Total General Fund Revenues 60% 59% Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services Other Revenues 66% 68% 72% ;7% lm FY 1999/2000 []FY 1998/1999 0% 30% 60% 90% 120% 150% 67% of Year Complete FY 199912000 Budget Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental Charges for Services Other Revenues Total General Fund Revenues 5,643,600 9,200,000 580,000 872,400 3,041,520 1,223,214 1,437,181 3,917,844 855,582 26,771,341 FY 199912000 % of YTD Actual Budget 3,054,332 54% 6,045,160 66% 394,574 68% 493,900 57% 2,190,090 72% 1,066,369 87% 1,038,750 72% 1,582,848 40% 215,579 25% 16,081,602 60% FY 98199 YTD Actual 2,650,650 5,179,394 188,549 430,267 1,466,806 906,858 837,567 1,897,549 199,147 13,756,787 % of Total for FY 98199 51% 60% 48% 51% 59% 67% 62% 54% 64% 59% ATTACHMENT 1 Date Printed: 03/03/200012:11 PM City of Dublin 1999-2000 YTD Expenses and Budget Comparison For the Period Ending February 29, 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% 80% 67% of Year Complete 100% · FY 1999/2000 [] FY 1998/1999 120% General Government Civic Center Lease 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 1999/2000 FY 1999/2000 % of Budget YTD Actual Budget 2,501,322 1,297,243 52% 4,991,209 2,519,940 50% 4,209,712 869,135 21% 208,427 63,080 30% 827,008 446,500 54% 19,360 5,063 26% 3,059,288 1,549,061 51% 4,974,683 2,184,404 44% 2,883,472 711,945 25% 23,674,481 9,646,371 41% 20,791,009 8,934,426 43% FY 98199 YTD Actual 1,297,622 1,614,407 1,249,332 2,544,881 69,168 371,261 727 1,282,100 2,092,173 532,516 11,054,187 10,521,671 % of Total for FY 98199 61% 100% 28% 62% 36% 48% 4% 57% 58% 30% 53% 55% Elate Pti ...... 03/ ..... F~M ATTACH M E NT 2 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF FEBRUARY 2000 Prepared by The Finance Department March 3, 2000 ATTACHMENT 3 City of Dublin General Fund Income Statement Showing Revenues Versus Expenditures For the Period 7199 Through 2/00 Revenues Property Taxes Sales Taxes Real Property Transfer Tax Hotel Transient Occupancy Tax Franchise Taxes Licenses and Permits Fines and Forfeitures Use Money and Property - Interest Use Money and Property - Rentals Intergovernmental from State Charges for Services Other Sources of Revenue Total Revenue Expenditures General Government City Council City Manager Central Services City Attorney Administrative 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 Maintenance Activity Total Health and Welfare Waste Management Child Care Activity Total Current Current Prior Prior Budget Actual % Variance Fiscal Year YTD % Variance 5,346,600 2,831,485 53% 2,515,115 4,866,093 2,494,015 51% 2,372,078 9,200,000 6,045,160 66% 3,154,840 8,687,091 5,179,394 60% 3,507,697 297,000 222,847 75% 74,153 282,733 156,635 55% 126,098 580,000 394,574 68% 185,426 389,664 188,549 48% 201,115 872,400 493,900 57% 378,500 649,959 430,267 51% 419,692 3,041,520 2,190,090 72% 851,430 2,472,217 1,466,806 59% 1,005,411 57,200 48,644 85% 8,356 60,876 40,487 67% 20,389 1,128,164 1,027,095 91% 101,059 1,262,400 864,927 69% 397,473 95,060 39,274 41% 55,786 90,539 41,931 46% 48,608 1,437,181 1,038,750 72% 398,431 1,356,234 837,567 62% 518,667 3,917,844 1,582,848 40% 2,334,996 3,482,983 1,897,549 54% 1,585,434 798,382 166,735 21% 631,647 250,889 158,660 63% 92,229 26,771,341 16,081,602 60% 10,689,739 24,051,678 13,756,787 57% 10,294,891 150,305 94,203 63% 56,102 145,936 90,148 62% 55,788 376,735 221,221 59% 155,514 331,437 213,722 64% 117,715 222,712 122,065 55% 100,647 300,140 145,611 49% 154,529 310,558 151,649 49% 158,709 723,174 342,635 47% 380,539 687,654 414,996 60% 272,658 550,831 255,245 46% 295,586 531,167 335,122 63% 196,045 1,614,407 1,614,407 100% 152,185 115,432 76% 36,753 125,622 85,480 68% 40,142 940 753 80% 187 6,335 6,305 100% 30 24,300 78 24,222 1,029 1,029 2,501,322 1,297,243 52% 1,204,079 3,754,145 2,912,029 78% 842,116 4,991,209 2,519,940 50% 2,471,269 4,505,598 1,249,332 28% 3,256,266 54,760 17,985 33% 36,775 51,697 25,007 48% 26,690 118,735 22,623 19% 96,112 104,137 21,865 21% 82,272 34,932 22,472 64% 12,460 35,022 22,296 64% 12,726 4,209,712 869,135 21% 3,340,577 4,109,003 2,544,881 62% 1,564,122 9,409,348 3,452,155 37% 5,957,193 8,805,457 3,863,381 44% 4,942,076 411,653 235,623 57% 176,030 389,595 500 26 5% 474 112,085 98,580 52,409 53% 46,171 46,320 13,215 29% 33,105 49,395 269,955 145,227 54% 124,728 225,855 827,008 446,500 54% 380,508 77.6,930 237,191 61% 152,404 114 111,971 20,071 41% 29,324 113,885 50% 111,970 371,261 48% 405,669 7,360 2,174 30% 5,186 4,969 727 4,242 12,000 2,889 24% 9,111 12,000 12,000 19,360 5,063 26% 14,297 16,969 727 4% 16,242 City of Dublin General Fund Income Statement Showing Revenues Versus Expenditures For the Period 7~99 Through 2/00 Culture and 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 / Facility Management Activity Total Community Development Planning Building Safety Engineering Economic Development Activity Total Capital Improvement Projects General CIP Projects Community Improvements Parks Street Construction / Improvements Activity Total Total Expenditures Excess Revenues (Expenditures) Transfers In From Other Funds Transfers Out From Other Funds Appropriations to Reserves Current Current Prior Prior Budget Actual % Variance Fiscal Year YTD Variance 1,556,662 297,961 19% 1,258,701 252,013 89,085 35% 162,928 304,646 73,897 24% 230,749 63,272 10,388 16% 52,864 863,815 302,955 35% 560,860 1,110,304 194,493 18% 915,811 158,349 37,132 23% 121,217 353,570 238,550 67% 115,020 2,883,472 711,945 25% 2,171,527 1,779,159 532,516 30% 1,246,643 23,674,481 9,646,371 41% 14,028,110 20,987,642 11,064,187 53% 9,933,455 3,096,860 6,435,231 208% -3,338,371 3,064,036 2,702,600 88% 361,436 39,874 -12,219,723 -12,134,212 3,096,860 6,435,231 208% -3,338,371 -9,115,813 -9,431,612 1,007,854 643,383 64% 364,471 1,010,015 588,272 58% 421,743 1,105,134 619,857 56% 485,277 795,025 454,523 57% 340,502 2,649,357 780,302 31% 1,769,055 1,685,599 941,950 56% 743,649 312,338 140,862 45% 171,476 115,762 107,428 93% 8,334 4,974,683 2,164,404 44% 2,790,279 3,606,401 2,092,173 58% 1,514,228 342,994 154,566 45% 188,428 255,689 112,124 44% 143,565 55,285 7,342 13% 47,943 20,000 20,000 100% 55,074 31,034 56% 24,040 43,004 27,897 65% 15,107 22,397 12,661 57% 9,736 15,010 5,515 37% 9,495 757,818 297,791 39% 460,027 533,105 263,598 49% 269,507 71,886 58,459 81% 13,427 58,047 48,542 84% 9,505 280,456 161,032 57% 119,424 264,382 168,812 64% 95,570 145,318 84,912 58% 60,406 137,577 85,300 62% 52,277 201,388 104,941 52% 96,447 164,547 96,674 59% 67,873 48,586 27,946 58% 20,640 49,314 32,781 66% 16,533 83,391 38,156 46% 45,235 44,993 25,644 57% 19,149 75,330 32,098 43% 43,232 60,291 31,429 52% 28,862 62,015 46,681 75% 15,334 63,730 38,838 61% 24,892 37,360 8,565 23% 28,795 240,908 168,631 70% 72,277 105,170 47,185 45% 57,985 117,796 66,103 56% 51,693 99,729 62,072 62% 37,657 114,863 57,908 50% 56,955 115,191 70,838 61% 44,353 256,508 140,161 55% 116,347 218,802 144,651 66% 74,151 89,915 50,074 56% 39,641 3,059,288 1,649,061 51% 1,510,227 2,248,581 1,282,100 57% 966,481 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 02/29/2000 SPECIAL' REVENUE FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR /¢ ********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,965.00 39,810.33 43.154.67 76.684.53 183.800.00 121.649.55 62.150.45 172.561.75 59.000.00 53.573.47 5.426.53 65.857.76 90,160.00 90.160.00 93,371.12 2,515~457.00 383,756.51 2,131.700.49 753.103.27 136,650.00 50,924.00 85,726.00 149.244.00 402.336.00 27,554.07 374,781.93 374.449.92 729.650.00 367,819.69 361.830.31 706.992.33 30.000.00 31.609.31 (1.609.21) 22.439.87 4.230.018.00 1.076.696.93 3.153,321.07 2.414.704.55 ******~EXPENDITURES~***** PUBLIC SAFETY: POLICE 87,959.00 44,162.07 TRAFFIC SIGNALS & STREET LTG 128,770.00 65,389.47 FIRE SERVICES 88.143.00 975.00 ACTIVITY TOTAL 304.872.00 110,526.54 TRANSPORTATION: STREET MAINTENANCE 410,056.00 58,694.91 STREET SWEEPING ACTIVITY TOTAL 410,056.00 58.694.91 HEALTH & WELFARE: WASTE MANAGEMENT 870,570.00 437,060.31 SENIOR SUPPORT CARE ACTIVITY TOTAL 870.570.00 437,060.31 COMMUNITY DEVELOPMENT: ENGINEERING 6.000.00 ACTIVITY TOTAL 6,000.00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 17.665.00 COMMUNITY PROJECTS 189,895.00 6,542.73 PARKS 21.119.00 3,577.66 STREET CONSTRUCTION/IMPROVEMENT 2,246,122.00 14,604.01 ACTIVITY TOTAL 2,474,801.00 24.724.40 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER tN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 43.796.93 63,380.53 87,168.00 194,345.46 351.361.09 351,361.09 433.509.69 433,509.69 6,000.00 6.000.00 17.665.00 183,352.27 17,541.34 2.231.517.99 2.450.076.60 4,066,299~00 63t.006.16 3,435.292.84 (163,719.00) (445.690.77) 28t.971.77 78.444.67 72.476.39 81.444.13 232,365.19 265.92O.49 81.727.11 347.647.60 827,685.54 7.044.00 834.729.54 44,166.79 44.166.79 56.548.31 51.300.97 674.931.01 782.780.29 2,241,689.41 (173,015.14) (130.265.91) 62,370.78 EXCESS <REVENUE> EXPENDITURE (163.719.00) (445,690.77) 281.971.77 (240.910.27) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 02/29/2000 CAPITAL- IMPROVEMENT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND .PRIOR FISCAL YEAR ***~==*REVENUE***~*x USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 73,785.00 27.856,145.00 27.929,930.00 73.785.00 27,856.145.00 27.929.930.00 2.257.954.64 2.257.954.64 *******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 OLFF TO OTHER FUNDS 61.886.00 61,886.00 2,206.938.00 9.443,800.00 16,623.429.00 28.274,167.00 28,336.053.00 406.123.00 602.80 602.80 821,390.36 5,474,623.52 964.110.95 7.260,124.83 7,260,727.63 7,260,727.63 61,283.20 61.283.20 1.385,547.64 3.969,176.48 15.659,318.05 21.014.042.17 21.075,325.37 (6.854,604.63) 16,915.01 16,915.01 145.14 145.14 124,753.27 1,180.149.86 744.202.34 2,049.t05.47 2,066,165.62 (191,789.02) 17,586.84 EXCESS <REVENUE>EXPENDITURE 406.123.00 7,260,727.63 (6,854.604.63) (174,202.18) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 02/29/2000 S P E C I'AL' AS~S E SSM E NT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND PRIOR FISCAL YEAR ~xx~XXXREVENUES~*** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 309.093.00 151.797.31 157.295.69 253.t75.40 15.027.00 15.027.00 16.381.44 2.500.00 668.85 1.831.15 2.736.05 326.620.00 152.466.t6 174,153.84 272.292.89 x~x~EXPENDITURES***~x* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG ACTIVITY TOTAL TRANSPORTATION PUBLIC WORKS STREET TREE MAINTENANCE STREET LANDSCAPE MAINTENANCE ACTIVITY TOTAL qEALTH & WELFARE: ENGINEERING ACTIVITY TOTAL ]APITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/tMPRVMNT ACTIVITY TOTAL ~ 0 T A L EXPENDITURES !XCESS <REVENUE>EXPENDITURE 145.005.00 50,935.83 94,069.17 145.005.00 50.935.83 94.069.17 2,945.00 1.905.19 1.039.81 13.210.00 1.864.24 11.345.76 160.990.00 69.611.11 91,378.89 177~145.00 73,380.54 103.764.46 4.200.00 4.336.86 (136.86) 4.200.00 4,336.86 (136.86) 18,700.00 46.41 18.653,59 82.600.00 620.68 81.979.32 101,300.00 667.09 100,632.91 107,525.57 107.525.57 2.246.99 7,694.38 105.652.77 t15,594.14 3.084.88 3.084.88 427.650.00 129.320.32 298,329.68 226,204.59 101,030.00 (23,145.84.) 124.175.84 (46,088.30) :XCESS <REVENUE>EXPENDITURE 101,030.00 (23.145.84) 124.175.84 (46,088.30) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 02/29/2000 TRUST/AG'ENCY. FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ********REVENUES~*~,¢* SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE 116,594.77 (116,594.77) 235.672.36 12.637.55 116,594.77 (116.594.77) 248.309.91 *******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 190,256.00 (t90,256.00) 231.864.50 190,256.00 (t90,256.00) 231,864.50 t90,256.00 (190.256.00) 231,864.50 73,661.23 (73.661.23) (16,445.41) EXCESS <REVENUE>EXPENDITURE 73.661.23 (73,661.23) (16,445.41) THE CItY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/0t/1999 THROUGH 02/29/2000 t NTE RNA-L SE RV I CE FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ~REVENUES**-*~ USES/MONEY & PROP-INTEREST CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE 56.832.00 56.832.00 40.084.94 589.275.00 371.607.90 217.667.10 726.998.50 25,700.00 28,607.44 (2,907.44) 17.455.06 671.807.00 400,215.34 27t,591.66 784.538.50 ***~EXPENDITURES**~'**** GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH'& WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 706.909.00 156.310.34 550.598.66 794,802.16 706.909.00 161.900.34 545.008.66 794,802.16 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 706.909.00 161,900.34 545.008.66 35.102.00 (238.315.00) 273.417.00 794,802.16 10,263.66 13.582.460.94 EXCESS <REVENUE>EXPENDITURE. 25.102.00 (238.315.00) 273.417.00 (13.572,197.28) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THRUGH 02/29/2000 E NT-E R-P R I S E FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR *********************** USES/MONEY & PROP-INTEREST TOTAL REVENUE 1.671.632.89 1.671,632.89 ****~*x~EXPENDITURES*~*~ GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL FINANCE ACTIVITY TOTAL PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES SOMMUNITY DEVELOPMENT: SAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TP~ANSFERS IN FROM OTHER FUNDS TRANSFERS ObrF TO OTHER FUNDS 10.00 IO.O0 10.00 10.00 10.00 10.00 10.00 10.00 935,724.30 500.00 936.'224.30 936,224.30 (735.408.59) (12.134.212.45) 13.587.133.27 EXCESS <REVENUE>EXPENDITURE 10.00 10.00 717,512.23 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 29Feb2000 SPECIAL SPECIAL CAPITAL TRUST/ REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUND FUND TOTALS ---MEMORANDUM ONLY--- CURRENT PRIOR ASSETS CASH CASH WITH FISCAL'AGENT UNAMORTIZED BOND DISCOUNT (16.109,992) INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 41.051,425 149,497 205.076 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 5.849 19.746 25,321,602 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 (649,197) (19,380) (597.119) (154,355) (210,273) (38,520) (149.497) (1.818,342) (23,503.261) TOTAL FUND E (23,503,261) 1.960,558 311 28.347 1.989.217 (1,989,217) (1.989,217) 331.950 13,557,871 331.950 13.557.871 (20.271.025) (99,415) (5.849) (20.376.289) (331,950) 6.818,418 (331,950) 6,818,418 118.262 (141,350) (8.211,129) 1491763 149,763 149,763 41,051,425 149,808 205,076 t,860,500 2.128.525 34,196 19,746 1,860,500 43,329.165 (649,197) (20.290,406) (597,119) (253.770) (210,273) (38,520) (t55,346) (1.978,000) (1,978,000) (1,978,000) (24,172,630) (150.525) (19,156.535) (150,525) (19,156.535) 34.556,969 1,399,589 502,727 212,897 7.O27 1.860,500 30,478,344 (498,812) (4.882,178) (468,866) (2,895,909) (309.574) (150,963) (155,346) (1,978,000) (11,339,647) (19.138,697) (19,138,697) TOTAL LIAB. FND BAL. RETD (25,321,602) (1,989,217) (331,950) (13.557,871) (2,128,525) (43,329.165) (30,478,344) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 29Feb2000 FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP TOTALS ---MEMORANDUM--- CURRENT PRI OR ASSETS CASH CASH WITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT 1.241,016 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 19,491.955 20,732,970 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 (20.732,970) TOTAL FUND E (20.732,970) (10) 6,388,993 28.663.249 (10) 6,388.993 28.663.249 10 (6,388,993) 10 (6,388,993) (28.663,249) (28.663,249) 1,241,006 1.023.507 25,880,948 25,880,948 28,663,249 29,519,398 55.785.203 56.423.853 (20.806) (28,663,249) (29,519,398) (28,663.249) (29,540.205) (27,121.954) (26,883,649) (27.121.954) (26.883.649) TOTAL LIAB. FND BAL. RETD (20.732.970) 10 (6.388,993) (28,663,249) (55.785,203) (56,423.853)