The URL can be used to link to this page

Home My WebLink AboutItem 4.05 Mar 2000 Fin Report CITY CLERK File # 0330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: (April 18, 2000) SUBJECT: Preliminary Financial Report For the Month of March 2000 ~ t~Report Prepared by: Fred Marsh, Finance Manager EXHIBITS ATTACHED: Pro Forma Balance Sheet and Income Statements for the Month of March 2000 RECOMMENDATION: ~4~/~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 March. 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 March 2000 Revenue and Expenditure Report Through the first nine months of the fiscal year the revenue collections and expenses have been tracking similar to the 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 the 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 March are ahead of what occurred in the nine months of the previous Fiscal Year. The City had collected through March 2000 approximately 74% of the total budgeted General Fund Revenues compared to approximately 67% 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 significant portion of the annual sales tax is a result of the Christmas retail season, for which the City will not receive data until the end of April. Transient Occupancy Taxes are higher than in the same period of the prior year due to additional revenues received fi'om 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 February 2000. As the subscription to these services increase the total revenue also increases. Similar trends are also reflected in the issuance of building permits. Through the month of March permits issued represented improvements valued in excess of $206 million. COPIES TO: G:XMONTHFS\032000 agenda statement month financials.doc ITEM NO. 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 nine 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 received in March. General Fund Expenditures Overall, through the month of March expenditures in the General Fund totaled $12,720,912 and represented approximately 53% of the total budgeted expenditures in the General Fund. Of this amount, a total of $1,344,012 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 March 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 March 2000, the City had expended 54% of the General Fund Operating Budget compared to 65% 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. General Government is lower than in the same period in the prior year due to staffing vacancies in the Finance Department. 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 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 March 31, 2000 - Unaudited Total General Fund Revenues Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services 74% 67% 70% 61% 82~ 68% Other Revenues FY 1999/2000 FY 1998/1999 61% 66% 8~ % 90% 0% 30% 60% 90% 75% of Year Complete 120% 150% FY 199912000 Budget Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental Charges for Services Other Revenues 5,643,600 9,200,000 580,000 872,4O0 3,041,520 1,223,214 1,439,880 4,142,844 854,416 Total General Fund Revenues 26,997,874 FY 199912000 % of YTD Actual Budget 3,925,724 70% 7,508,520 82% 469,797 81% 533,928 61% 2,742,472 90% 1,085,928 89% 1,196,848 83% 1,902,320 46% 692,209 81% 20,057,745 74% FY 98199 YTD Actual 3,161,159 5,878,196 214,977 466,649 1,623,980 934,235 961,256 2,117,222 262,337 15,620,011 % of Total for FY 98199 61% 68% 55% 55% 66% 69% 71% 61% 84% 67% ~a,~ ~,.~: o~c~ .:~ ^. ATTACHMENT 1 City of Dublin 1999-2000 YTD Expenses and Budget Comparison For the Period Ending March 31, 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% 100% 120% 75% of Year Complete [] FY 1999/2000 [] FY 1998/1999 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 FY 98~99 Budget YTD Actual Budget YTD Actual 2,573,322 1,532,789 .60% 1,438,434 1,614,407 4,992,259 2,576,642 52% 2,242,867 4,209,712 2,135,057 51% 2,977,231 208,427 104,425 50% 87,576 827,008 513,487 62% 417,009 19,360 5,595 29% 6,075 3,061,123 1,857,362 61% 1,425,450 5,188,683 2,651,544 51% 2,359,612 2,930,957 1,344,012 46% 898,474 24,010,851 12,720,912 53% 13,467,135 21,079,894 11,376,900 54% 12,568,661 % of Total for FY 98/99 67% 100% 5O% 72% 46% 54% 36% 63% 65% 5O% 64% 65% o ............... ATTACHMENT 2 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MARCH 2000 Prepared by The Finance Department April 10, 2000 ATTACHMENT 3 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2000 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 (17.913.601) INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 44,026.425 149.497 205.076 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 5.849 10.877 26,484.123 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 TOTAL FUND E (786. (41, (605. (157, (2t5. (123. (149. 691) 321) 639) 244) 657) 213) 497) (2.079,262) 24,404,861) 24,404.861) TOTAL LIAB. FND BAL. RETD 26.484.123) 2.114,922 311 28,347 2,143,580 (2.143.580) (2.143,580) (2,143.580) 317.634 15.076.439 4.267.787 317,634 19,344,226 (26.685,117) (95,653) (5.849) (26,786.619) (317.634) 7.442.393 (317.634) 7,442,393 (317,634) (19,344,226) 55,344 (349.262) 154,569 154.569 4,267.787 44;026,425 149,808 205.076 1.860,500 2.070.413 34.196 10.877 1.860.500 50,359,976 (786.691) (26.726,437) (605.639) (252.897) (215.657) (123.213) (155.346) (1,978,000) (1.978.000) (1.978,000) (30.843,880) (92,413) (19.516.096) (92,413) (19.516.096) (2.070,413) (50.359,976) (8,211,129) 149,763 34.556.969 1.399.589 502.727 212,897 7.027 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) (30.478,344) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2000 FIXED ASSETS. GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP TOTALS ---MEMORANDUM--- CURRENT PRIOR ASSETS CASH CASH WITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT 1,266,294 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,758,249 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.758,249) TOTAL FUND E (20,758,249) TOTAL LIA8. FND BAL. RETD (20,758,249) (355) (355) 355 (6,388,993) 355 (6,388,993) 6,388,993 28,663,249 6,388,993 28,663,249 (28,663,249) (28,663,249) 355 (6.388,993) (28,663,249) 1,265,939 1.023,507 25,880,948 25.880.948 28,663,249 29.519,398 55,810,136 56,423,853 (20,806) (28,663,249) (29,519,398) (28,663,249) (29,540;205) (27,146,888) (26,883,649) (27,146,888) (26,883,649) (55,810,136) (56.423,853) City of Dublin General Fund Income Statement Showing Revenues Versus Expenditures For the Period 711999 Through 3~2000 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 Revenue 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 3,670,106 69% 1,676,494 4,866,093 2,992,593 61% 1,873,500 9,200,000 7,508,520 82% 1,691,480 8,687,091 5,878,196 68% 2,808,895 297,000 255,618 86% 41,382 282,733 168,566 60% 114,167 580,000 469,797 ' 81% 110,203 389,664 214,977 55% 174,687 872,400 533,928 61% 338,472 849,959 466,649 55% 383,310 3,041,520 2,742,472 90% 299,048 2,472,217 1,623,980 66% 848,237 57,200 64,111 95% 3,089 60,876 44,496 73% 16,380 1,128,154 1,037,244 92% 90,910 1,262,400 888,019 70% 374,381 95,060 48,684 51% 46,376 90,539 46,216 51% 44,323 1,439,880 1,196,848 83% 243,032 1,356,234 961,256 71% 394,978 4,142,844 1,902,320 46% 2,240,524 3,482,983 2,117,222 61% 1,365,761 797,216 638,098 80% 159,118 250,889 217,840 87% 33,049 26,997,874 20,057,746 74% 6,940,128 24,051,678 15,620,010 65% 8,431,668 152,305 109,148 72% 43,157 145,936 98,543 68% 47,393 376,735 257,813 68% 118,922 331,437 239,518 72% 91,919 222,712 141,329 63% 81,383 300,140 201,959 67% 98,181 310,558 178,936 58% 131,622 793,174 412,448 52% 380,726 687,654 467,375 68% 220,279 550,831 288,550 52% 262,281 531,818 362,187 68% 169,631 114 -114 1,614,407 1,614,407 100% 152,185 120,519 79% 31,666 125,622 85,567 68% 40,055 940 832 89% 108 6,335 6,308 100% 27 24,300 78 24,222 378 378 2,573,322 1,532,790 60% 1,040,532 3,754,145 3,052,841 81% 701,304 4,992,259 2,576,642 52% 2,415,617 4,505,598 2,242,867 50% 2,262,731 54,760 25,420 46% 29,340 51,697 30,585 59% 21,112 118,735 51,132 43% 67,603 104,137 31,531 30% 72,606 34,932 27,873 80% 7,059 35,022 25,461 73% 9,561 4,209,712 2,135,057 51% 2,074,655 4,109,003 2,977,231 72% 1,131,772 9,410,398 4,816,124 51% 4,594,274 8,805,457 5,307,675 60% 3,497,782 411,653 279,673 68% 131,980 389,595 500 26 5% 474 112,085 98,580 52,409 53% 46,171 46,320 20,523 44% 25,797 49,395 269,955 160,855 60% 109,100 225,855 827,008 513,486 62% 313,522 776,930 267,488 69% 122,107 114 111,971 22,597 46% 26,798 126,809 56% 99,046 417,008 54% 359,922 7,360 2,174 30% 5,186 4,969 727 4,242 12,000 . 3,422 29% 8,578 12,000 5,349 45% 6,651 19,360 5,596 29% 13,764 16,969 6,076 36% 10,893 City of Dublin General Fund Income Statement Showing Revenues Versus Expenditures For the Period 711999 Through 312000 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 Current Current Prior Prior Budget Actual % Variance Fiscal Year YTD % Variance 342,994 248,561 72% 94,433 255,689 112,124 44% 143,565 55,285 20,645 37% 34,640 20,000 20,000 100% 55,074 37,346 68% 17,728 43,004 30,960 72% 12,044 22,397 14,572 65% 7,825 15,010 6,438 43% 8,572 757,818 328,520 43% 429,298 533,105 298,611 56% 234,494 71,886 58,915 82% 12,971 58,047 49,799 86% 8,248 280,456 191,999 68% 88,457 264,382 189,653 72% 74,729 145,318 98,896 68% 46,422 137,577 94,194 68% 43,383 201,388 124,703 62% 76,685 164,547 105,194 64% 59,353 48,586 33,503 69% 15,083 49,314 36,440 74% 12,874 83,391 44,981 64% 38,410 44,993 30,549 68% 14,'!.'!.'!. 75,330 35,101 47% 40,229 60,291 35,254 58% 25,037 62,015 56,150 91% 5,865 63,730 43,372 68% 20,358 37,360 10,737 29% 26,623 240,908 190,860 79% 50,048 105,170 67,636 64% 37,534 119,631 77,241 65% 42,390 99,729 67,939 68% 31,790 114,863 73,107 64% 41,756 115,191 87,715 76% 27,476 256,508 151,497 59% 105,011 218,802 149,573 68% 69,229 89,915 60,030 67% 29,885 3,061,123 1,857,364 61% 1,203,759 2,248,581 1,425,451 63% 823,130 1,221,854 804,396 66% 417,458 1,010,015 666,168 66% 343,847 1,105,134 651,968 59% 453,166 795,025 517,696 65% 277,329 2,549,357 927,496 36% 1,621,861 1,685,599 1,065,063 63% 620,536 312,338 267,684 86% 44,654 115,762 110,685 96% 5,077 5,188,683 2,651,544 51% 2,537,139 3,606,401 2,359,612 65% 1,246,789 1,556,662 868,976 56% 687,686 252,013 309,056 108,969 35% 200,087 63,272 906,890 309,185 34% 597,705 1,110,304 158,349 56,882 36% 101,467 353,570 2,930,957 1,344,012 46% 1,586,945 1,779,159 24,010,851 12,720,916 53% 11,289,935 2,987,023 7,336,830 246% -4,349,807 102,031 40% 149,982 10,803 17% 52,469 546,425 49% 563,879 239,215 68% 114,355 898,474 50% 880,685 20,987,642 13,467,137 64% 7,520,505 3,064,036 2,152,873 70% 911,163 39,874 -12,219,723 -12,134,212 Appropriations to Reserves 2,987,023 7,336,830 246% -4,349,807 -9,115,813 -9,981,339 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 03/31/2000 SPECIAL REVENUE FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ************************ 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 45,875.19 37,089.81 183,800.00 143,256.80 40,543.20 59,000.00 61,256.89 (2,256.89) 90,160.00 90,160.00 2,515,457.00 479,384.94 2,036,072.06 136,650.00 75,388.00 61,262.00 402,336.00 27,554.07 374,781.93 729,650.00 432,223.75 297,426.25 30,000.00 31,609.31 (1,609.31) 4,230,018.00 1,296,548.95 2,933.469.05 76 684.53 172561.75 65 857.76 93371.12 753 103.27 149 244.00 374 449.92 706 992.33 22,439.87 2,414.704.55 ************************** 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 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 93,034.00 50,320.60 42,713.40 78.444.67 128,770.00 77,043.65 51,726.35 72,476.39 88,t43.00 40,698.75 47,444.25 81.444.13 309,947.00 t68,062.00 141,884.00 232,365.19 410,056.00 64,258.88 345,797.12 265,920.49 81,727.11 410,056.00 64,258.88 345,797.12 347,647.60 870,570.00 437,074.29 433,495.71 827,685.54 7,044.00 870,570.00 437,074.29 433,495.71 834.729.54 6,000.00 6,000.00 44,166.79 6,000.00 6,000.00 44,166.79 17,665.00 17,665.00 189.895.00 6.818.43 183,076.57 56,548.31 21,119.00 3,577.66 17,541.34 51,300.97 2,246,122.00 16,702.26 2,229,419.74 674,931.01 2,474,801.00 27,098.35 2,447,702.65 782,780.29 4,071,374.00 696,494.52 3,374,879.48 (158,644.00) (600,054.43) 441,410.43 2,241,689.41 (173,015.14) (130.265.91) 62,370.78 EXCESS <REVENUE> EXPENDITURE (158,644.00) (600,054.43) 441,410.43 (240,910.27) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 03/31/2000 SPECIAL ASSESSMENT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND PRIOR FISCAL YEAR ************************ SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 309,093.00 169.025.72 140.067.28 253,175.40 15,027.00 15.027.00 16,381.44 2,500.00 668.85 1.831.15 2,736.05 326.620.00 169,694.57 156.925.43 272,292.89 ************************** 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 145.005.00 68.836.68 76.168.32 145.005.00 68.836.68 76,168.32 2,945.00 2,125.10 819.90 13,210.00 2,115.04 11,094.96 160 990.00 81,912.44 79.077.56 177,145.00 86,152.58 90,992.42 4,200.00 4.336.86 (136.86) 4,200.00 4,336.86 (136.86) 18,700.00 323.19 18,376.81 82,600.00 1,215.46 81,384.54 101,300.00 1,538.65 99,761.35 107,525.57 107,525.57 2,246.99 7,694.38 105,652.77 115,594.14 3,084.88 3,084.88 427,650.00 160,864.77 266,785.23 226,204.59 101,030.00 (8,829.80) 109,859.80 (46,088.30) EXCESS <REVENUE>EXPENDITURE 101,030.00 (8,829.80) 109,859.80 (46,088.30) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 03/31/2000 CAPITAL IMPROVEMENT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND PRIOR FISCAL YEAR /$ ********************* 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******* GENEEAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & JELFARE: 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 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 406,123.00 946.64 946.64 1,013,143.79 5,531,139.47 1,339,472.12 7,883,755.38 7,884,702.02 7,884,702.02 7,884,702.02 60,939.36 60,939,36 1,193,794.21 3,912,660.53 15,283,956.88 20.390,411.62 20,451,350.98 (7,478,579.02) 7,478,579.02) 16,915.01 16,915.01 t45.14 145.14 124,753.27 1,180,149.86 744,202.34 2,049,105.47 2,066,165.62 (191,789.02) 17,586.84 (174,202.18) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 03/31/2000 TRUST/AGENCY FUND CURRENT CURRENT pRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ************************ SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE 123,796.42 (123,796.42) 235,672.36 4,805.38 (4.805.38) 12,637.55 128,601.80 (128,601.80) 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 EXCESS <REVENUE>EXPENDITURE 260,375.75 (260,375.75) 231,864.50 260,375.75 (260.375.75) 231,864.50 260,375.75 (260.375.75) 231.864.50 131.773.95 (131.773.95) (16,445.41) 131,773.95 131,773.95) (16,445.41) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 03/31/2000 INTERNAL SERVICE FUND CURRENT CURRENT pRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR /$ ********************** 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 428,039.40 161,235.60 726,998.50 25.700.00 28,607.44 (2,907.44) 17,455.06 671,807.00 456,646.84 215,160.16 784,538.50 ************************** GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 723,983.00 t87,463.63 536,519.37 794,802.16 723,983.00 193,053.63 530,929.37 794,802.16 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 723.983.00 52,176.00 193,053.63 530,929.37 263,593.21) 315,769.21 794,802.16 10,263.66 t3,582,460.94 EXCESS <REVENUE>EXPENDITURE 52,176.00 (263,593.21) 315,769.21 (13,572,197.28) ********REVENUES*****W** USES/MONEY & PROP-INTEREST TOTAL REVENUE CURRENT BUDGET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THRUGH 03/31/2000 ENTERPRISE FUND CURRENT PRIOR ACTUAL VARIANCE FISCAL YEAR 1,671,632.89 1,671,632.89 ********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 T~NSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 10.00 10.00 10.00 10.00 10.00 10.00 935,724.30 344.50 (344.50) 500,00 354.50 (344.50) 936.224.30 354.50 (344.50) 936,224.30 354.50 (344.50) (735,408.59) (12,t34,212.45) 13,587,133.27 354.50 (344.50) 717,512.23