The URL can be used to link to this page

Home My WebLink About4.06 Dec 1999 Fin Report CITY CLERK File # 0330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: (February 15, 2000) SUBJECT: Preliminary Financial Report For the Month of December 1999 Report Prepared by: Fred Marsh, Finance Manager EXHIBITS ATTACHED: Pro Forms Balance Sheet and Income Statements for the Month of December 1999 RECOMMENDATION: ~'~ Accept and file 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 December. 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. Staff will provide an in depth mid-year analysis of Revenues and Expenditures as part of the Budget Study Session on February 29, 2000. The report will identify any necessary mid-year adjustments and current revenue and expenditure trends. Analysis of December 1999 Revenue and Expenditure Report The December report represents the reporting of revenues and expenditures for the six months of the Fiscal Year. Major property tax revenues were received in December. In the expenditure category, the December report does not include expenses for the second quarter of Police and Fire Services, which are scheduled to be paid in February. 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 December are comparable to what occurred in the six months of the previous Fiscal Year. The City had collected through December 1999 approximately 46% of the total budgeted General Fund Revenues compared to approximately 45% in the prior Fiscal Year. Based upon the limited information available there were not any areas with significant deviations from the current budget projections. 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 being received from the City's two new hotels. mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm COPIES TO: G:\MONTHFS\1299 agenda statement month financials.doc' ITEM NO. ~ 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 due to timing differences in the recording of revenue for reimbursements received from developers for engineering plan checking services. 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. General Fund Expenditures Overall, through the month of December expenditures in the General Fund totaled $6,504,380 and represented approximately 28% of the total budgeted expenditures in the General Fund. Of this amount, a total of $266,122 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 December 1999 was somewhat below the amounts expended for the same period in the prior Fiscal Year. Through December 1999, the City had expended 28% of the General Fund Operating Budget compared to 36% 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 the same period in the prior year due to timing differences in payments for contract fire services. Community Development Expenditures are lower than in the prior Fiscal Year due to timing differences in the payment for contract professional services related to new development. Capital Improvements Projects expenditures are lower than in the same period of the prior year due to expenditures incurred in the prior year for the completion of the Dougherty Hills Park Slope Repair Capital 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. )$ Total General Fund Revenues City of Dublin 1999-2000 YTD Revenues and Budget Comparison For the Period Ending December 30, 1999 - Unaudited Property Taxes ~ 53~% , ,, i51% II I Sales Taxes 49% ~% ~ Transient Occupancy Taxes 37% Franchise Taxes 23% 21% Licenses and Permits 52% 149% Interest and Rentals 44% 43% Intergovernmental from State 54% '45% Charges for .Services 32% ~40% Other Revenues [] FY 1999/2000 ~FY 1998/1999 0% 30% 60% 90% 120% 150% 50% of Year Complete FY 1999/2000 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,400 3,041,520 1,223,214 1,437,181 3,917,844 855,582 Total General Fund Revenues 26,771,341 FY 1999/2000 YTD Actual 2,987,412 4,534,127 272,031 198,121 1,591,953 540,688 777,906 1,263,447 170,781 12,336,466 % of Budget 53% 49% 47% 23% 52% 44% 54% 32% 20% 46% FY 98/99 YTD Actual 2,607,660 3,723,094 143,547 179,593 1,212,613 580,238 606,099 1,391,583 144,479 10,588,906 % of Total for FY 98/99 51% 43% 37% 21% 49% 43% 45% 40% 46% 45% ATTACHMENT 1 Date Printed: 01/14/2000 10;54 AM City of Dublin 1999-2000 YTD Expenses and Budget Comparison For the Period Ending December 31, 1999 - Unaudited Total General Fund Expenses General Government Civic Center Lease Police Fire Other Public Safety Transportation Health and Welfare 121% 7% - ~ ~46% 38% Culture & Community Services 41% _ Community Development 41% 1 Capital Improv. Projects 2~% IFY 1999/2000 e~FY 1998/1999 0% 30% 60% 90% 120% 50% of Year Complete 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 199912000 FY 1999/2000 % of FY 98/99 Budget YTD Actual Budget YTD Actual 2,501,322 988,425 40% 951,124 346,063 4,991,209 1,364,869 27% 1,174,610 4,209,712 778,032 18% 1,908,406 208,427 41,117 20% 52,169 827,008 316,491 38% 264,150 19,360 1,420 7% 727 3,059,288 1,162,500 38% 926,641 4,960,191 1,585,404 32% 1,465,952 2,772,546 266,122 10% 459,712 23,549,063 6,504,380 28% 7,549,554 20,776,517 6,238,258 30% 7,089,842 % of Total for FY 98/99 44% 21% 26% 46% 27% 34% 4% 41% 41% 26% 36% 37% ATTACHMENT 2 Date Pdnted: 02_/0412000 4:31 PM CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF DECEMBER 1999 Prepared by The Finance Department January 14, 2000 ATTACHMENT 3 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Dec1999 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 (19,262,217) INVESTMENTS AT COST 43,592,415 RECEIVABLES: TAXES ACCOUNTS (NE 149,497 INTEREST 205,076 ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 5,849 15,637 24.706,258 LtAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL (760,273) DEPOSITS FOR AB1600 FEES (21,813) DEPOSITS OTHERS (422.043) PAYABLES: ACCOUNTS (160,835) INTEREST PAYROLL (224,166) DUE TO OTHERS (67,514) DEFERRED REVENUE (149,497) DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (1,806,141) ,116) ,116) FUND BALANCES (22,900 TOTAL FUND E (22,900 1,896.t39 311 28,347 1,924,797 (1.924.797) (1,924,797) 362,t45 16,240,072 362.145 16.240.072 (22,040.629) (46,074) (5.849) (22.092.552) (362,145) 5.852,480 (362.145) 5,852,480 118~262 (645.600) (8.211.t29) 149,763 149.763 149,763 43.592,415 34.556,969 149.808 1,399.589 205,076 502,727 34,196 212.897 15.637 7.027 1,860,500 1,860,500 1.860.500 2.128.525 45,361,796 30.478.344 (760,273) (22,062,441) (422.043) (206,909) (224.166) (67,514) (155.346) (1.978.000) (1,978,000) (1.978,000) (25,876,693) (150,525) (19.485,103) (150.525) (19,485,103) (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 (24,706,258) (1,924,797) (362.145) (16.240,072) (2.128,525) (45.361,796) (30.478.344) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Dec1999 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.122.615 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.614.569 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE BEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANCES (20,614,569 TOTAL FUND E (20,614,569 TOTAL LIAB. FND BAL. RETD (20,614,569 6.388.993 28.822.697 6.388.993 28.822,697 (6,388,993) (6.388.993) (28,822.697 (28,822.697 (6.388,993) (28.822.697 1.122.615 25,880,948 28,822,697 55,826.259 28.822.697 28.822.697 27.003.563 27,003,563 (55,826,259 City of Dublin General Fund Income Statement Showing Revenues Versus Expenditures For the Period 7/99 Through 12/99 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 Budget Actual % Variance Fiscal Year 5,346,600 2,831,485 53% 2,515,115 4,866,093 9,200,000 4,534,127 49% 4,665,873 8,687,091 297,000 155,927 53% 141,073 282,733 580,000 272,031 47% 307,969 389,664 872,400 198,121 23% 674,279 849,959 3,041,520 1,591,953 52% 1,449,567 2,472,217 57,200 33,981 59% 23,219 60,876 1,128,154 513,219 45% 614,935 1,262,400 95,060 27,469 29% 67,591 90,539 1,437,181 777,906 54% 659,275 1,356,234 3,917,844 1,263,447 32% 2,654,397 3,482,983 798,382 136,800 17% 661,582 250,889 26,771,341 12,336,466 46% 14,434,875 24,051,678 150,305 71,492 48% 78,813 145,936 376,735 158,524 42% 218,211 331,437 222,712 91,507 41% 131,205 300,140 121,071 40% 179,069 310,558 723,174 256,396 35% 466,778 687,654 550,831 180,403 33% 370,428 531,167 1,614,407 152,185 107,963 71% 44,222 125,622 940 751 80% 189 6,335 24,300 318 1% 23,982 1,029 2,501,322 988,425 40% 1,512,897 3,754,145 4,991,209 1,364,869 27% 3,626,340' 4,505,598 54,760 12,654 23% 42,106 51,697 118,735 10,850 9% 107,885 104,137 34,932 17,613 50% 17,319 35,022 4,209,712 778,032 18% 3,431,680 4,109,003 9,409,348 2,184,018 23% 7,225,330 8,805,457 411,653 173,074 42% 238,579 389,595 500 26 5% 474 112,085 98,580 28,281 29% 70,299 46,320 9,432 20% 36,888 49,395 269,955 105,678 39% 164,277 225,855 827,008 316,491 38% 510,517 776,930 7,360 7,360 4,969 12,000 1,420 12% 10,580 12,000 19,360 1,420 7% 17,940 16,969 Prior YTD % 2,494,015 51% 3,723,094 43% 113,645 4O% 143,547 37% 179,593 21% 1,212,613 49% 32,211 53% 545,516 43% 34,722 38% 606,099 45% 1,391,583 40% 112,269 45% 10,588,907 44% 76,221 52% 152,302 46% 90,045 29% 298,210 43% 248,989 47% 346,063 21% 84,309 67% 1,048 17% 1,297,187 35% 1,174,610 26% 15,072 29% 21,865 21% 15,233 43% 1,908,406 46% 3,135,186 36% 170,011 44% 114 11,892 24% 82,133 36% 264,150 34% 727 727 4% Variance 2,372,078 4,963,997 169,088 246,117 670,366 1,259,604 28,665 716,884 55,817 750,135 2,091,400 138,620 13,462,771 69,715 '179,135 220,513 389,444 · 282,178 1,268,344 41,313 5,287 1,029 2,456,958 3,330,988 36,625 82,272 19,789 2,200,597 5,670,271 219,584 111,971 37,5O3 143,722 512,780 4,242 12,000 16,242 City of Dublin General Fund Income Statement Showing Revenues Versus Expenditures For the Period 7~99 Through 12199 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 ClP 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 Budget Actual % Variance Fiscal Year 342 994 55 285 .55 074 22 397 757 818 71 886 280 456 145 318 201 388 48 586 83,391 75,330 62,015 37,360 240,908 117,796 114,863 256,508 89,915 3,059,288 993,362 1,105,134 2,549,357 312,338 4,960,191 1,547,141 304,646 762,410 158,349 2,772,546 23,549,063 3,222,278 77,283 23% 6,505 12% 23,467 43% 5,976 27% 213,166 28% 51,437 72% 120,005 43% 67,826 47% 75,146 37% 21,325 44% 28,853 35% 25,156 33% 34,658 56% 4,615 12% 145,269 60% 51,360 44% 49,136 43% 123,332 48% 37,985 42% 1,162,500 38% 483,264 49% 417,224 38% 571,691 22% 113,225 36% 1,585,404 32% 144,214 9% 54,428 18% 43,55O 6% 23,93O 15% 266,122 10% 6,504,380 28% 5,832,086 181% 265 711 48 780 31 607 16 421 544 652 20 449 160 451 77 492 126 242 27 261 54 538 50 174 27 357 32 745 95 639 66436 65 727 133,176 51 930 1,896,788 510,098 687,910 1,977,666 199,113 3,374,787 1,402,927 250,218 718,860 134,419 2,506,424 17,044,683 -2,609,808 255,689 20,000 43,004 15,010 533,105 58,047 264,382 137,577 164,547 49,314 44,993 60,291 63,730 105,170 99,729 115,191 218,802 2,248,581 1,010,015 795,O25 1,685,599 115,762 3,606,401 252,013 63,272 1,110,304 353,570 1,779,159 20,987,642 3,064,036 39,874 -12,219,723 Prior YTD 56,062 20,000 19,084 3,137 191,527 46 854 122 869 66 170 64 788 24 341 16 152 25 790 23 082 14,959 43,9O0 60,886 127,042 926,643 395,634 326,933 653,872 ~89,513 1,465,952 65,462 8,479 155,962 229,809 459,712 7,549,557 3,039,350 22% 100% 44% 21% 36% 81% 46% 48% '39% 49% 36% 43% 36% 14% 44% 53% 58% 41% 39% 41% 39% 77% 41% 26% 13% 14% 65% 26% 36% 99% Variance 199,627 23,920 11,873 341,578 11,193 141,513 71,407 99,759 24,973 28,841 34,501 40,648 90,211 55,829 54,305 91,760 1,321,938 614,381 468,092 1,031,727 26,249 2,140,449 186,551 54,793 954,342 123,761 1,319,447 13,438,085 24,686 Appropriations to Reserves 3,222,278 5,832,086 181% -2,609,808 -9,115,813 3,039,350 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 12/31/1999 SPECIAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ 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 183 800.00 59 000.00 90 160.00 2,515 457.00 136 650.00 401 640.00 729 650.00 30 000.00 4,229 322.00 39.810.33 62,341.24 30,580.71 342 034.0t 50 924.00 23 174.31 367 819.69 31 609.31 948 293.60 43 121 28 90 2,173 85 378 36t (1 3,281 154 458 419 160 422 726 465 830 609 028 67 76 76 172 29 65 O0 93 99 753 O0 149 69 374 3t 706 31) 22 40 2.414, 684.53 561.75 857.76 371,12 103.27 244.00 449.92 992.33 439.87 704.55 76 172 65 93 753 149 374 706 22 2,414 684 561 857 371 103 244 449 992 439 704 53 75 76 12 27 O0 92 33 87 55 ************************** PUBLIC SAFETY: POLICE TRAFFIC SIGNALS & STREET LTG FIRE SERVICES ACTIVITY TOTAL T~NSPORTATION: 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 87,959.00 128.770.00 88,143.00 304,872.00 410,056.00 410,056:00 870,570.00 870,570.00 6.000.00 6.000.00 17,665.00 189,199.00 21,119.00 2,246,122.00 2.474.105.00 4.065.603.00 (163,719.00) 23 173.30 48 154.27 71 327.57 39 148.42 39,148.42 435,846.96 435,846.96 5.602.25 3,577.66 11,519.92 20,699.83 567,022.78 (38t,270.82) 64.785.70 80,615.73 88,143.00 233,544.43 370,907.58 370,907.58 434,723.04 434,723.04 6,000.00 6.000.00 17,665.00 183,596.75 17,541.34 2.234,602.08 2,453,405.17 3,498,580.22 217,551.82 78,444.67 72,476.39 81.444.13 232,365.19 265.920.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 78.444 72.476 81.444 232.365 265.920 81.727 347,647 827.685 7.044 834.729 44.166 44,166 .67 .39 .13 .19 .49 .11 .60 .54 .00 .54 .79 .79 56,548.31 51,300.97 674,931.0t 782.780.29 2,241,689.41 (173,015.14) (130,265.91) 62,370.78 EXCESS <REVENUE> EXPENDITURE (t63.719.00) (381.270.82) 217,551.82 (240,910.27) (240,910.27) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 12/31/1999 SPECIAL ASSESSMENT FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 309.093.00 t51,797.31 157,295.69 253,175.40 15,027.00 15,027.00 16.381.44 2,500.00 2,500.00 2,736.05 326,620.00 151,797.31 174,822.69 272,292.89 253.175.40 16.381.44 2,736.05 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 145,005 2,945 t3,210 160,990 t77,145 ~,200 4,200 .00 .00 .00 .00 .00 .00 .00 .00 38,669.53 106,335.47 38,669.53 106,335.47 18,700.00 82,600.00 101,300.00 t.598.12 1.346.88 1,024.37 12,185.63 52.781.69 108,208.31 55.404.18 121,740.82 427.650. 101,030. 4,336.86 (136.86) 4,336.86 (136.86) 46.41 18.653.59 82,600.00 46.41 101,253.59 107,525 107,525 2,246 7,694 105,652 115,594 3,084 3,084 .57 .57 .99 .38 .77 .14 .88 .88 O0 98,456.98 329,193.02 226,204.59 O0 (53,340.33) 154,370.33 (46.088.30) 107,525.57 107.525.57 2,246.99 7,694.38 105.652.77 115,594.14 3.084.88 3,084.88 226.204.59 (46,088.30) EXCESS <REVENUE>EXPENDITURE 101,030.00 (53.340.33) 154,370.33 (46,088.30) (46,088.30) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 12/31/1999 CAPITAL IMPROVEMENT FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** 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 2.257,954.64 2,257,954.64 ************************** 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 CtP 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 61,886.00 61.886.00 2,029,737.00 9,443.800.00 16,623,429.00 28,096,966.00 16.915.01 16,915.01 56.72 61,829.28 145.14 56.72 61,829.28 145.14 372,510.t2 1,657.226.88 5,170,802.25 4,272.997.75 751,420.38 15.872.008.62 6,294,732.75 21.802,233.25 124.753.27 1,180.149.86 744,202.34 2,049.105.47 28.158.852.00 6.294,789.47 21,864,062.53 2.066,165.62 228~922.00 6,294,789.47 (6,065,867.47) (191,789.02) 17,586.84 t6,915.01 16.915.01 145.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 EXCESS <REVENUE>EXPENDITURE 228,922.00 6.294,789.47 (6,065,867.47) (174.202.t8) (174.202.18) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 12/31/1999 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE 116,594.77 (t16,594.77) 235,672.36 12.637.55 116,594.77 (116.594.77) 248.309.9t 235.672.36 12,637.55 248,309.91 ************************** 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 190,256.00 (190,256.00) 231,864.50 190,256.00 (190.256.00) 231,864.50 190.256.00 (190.256.00 73,661.23 (73.661.23 73,661.23 (73.66t.23 231.864.50 (16,445.41) 16,445.41) 231,864.50 231,864.50 231,864.50 (16.445.41) (16,445.41) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/t999 THROUGH 12/31/1999 INTERNAL SERVICE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ 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 240,499.39 348.775.61 726.998.50 25.700.00 10,455.79 15.244.21 17.455.06 671.807.00 250,955.18 420.851.82 784,538.50 40.084.94 726,998.50 17,455.06 784,538.50 ************************** GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: T~NSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 706.909.00 131,041.19 575.867.81 794,802.16 706,909.00 131.041.19 575.867.81 794,802.16 706.909.00 131.041.19 575.867.81 35,102.00 (119,9t3.99) 155.015.99 794,802.16 10,263.66 13.582,460.94 794,802.t6 794.802.16 794,802.16 10,263.66 13,582.460.94 EXCESS <REVENUE>EXPENDITURE 35,102.00 (119,913.99) 155.015.99 (13,572,197.28) (13.572,197.28) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THRUGH 12/3t/1999 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ USES/MONEY & PROP-INTEREST TOTAL REVENUE 1,671.632.89 1,671,632.89 1,671,632.89 1,671,632.89 *************************** 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 935,724.30 500.00 936,224.30 936.224.30 (735,408.59) (12,134,212.45) 13,587,133.27 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 717,512.23