The URL can be used to link to this page

Home My WebLink AboutItem 4.1 Mid-Yr Budg Report CITY CLERK File # 0330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: February 29, 2000 SUBJECT: Fiscal Year 1999-2000 Mid-Year Budget Report and January 2000 Monthly Report of Financial Activities Report Prepared by: Joe Aguilar, Interim Administrative Services Director and Fred Marsh, Finance Manager ATTACHMENTS: o Proforma Balance Sheet and Income Statements for the Month of January 2000 Budget Change Form , RECOMMENDATION'r~4~ 2. Approve Budget Change Form Receive the Report FINANCIAL STATEMENT: See Below. DESCRIPTION: Attached is the monthly report of financial activities for January 2000. This report combines the monthly financial analysis with a more detailed "Mid-Year Review." The emphasis of recommended adjustments is on material changes in Revenues and Expenditures. It is important to understand that some of the data is limited due to a lag in the time when bills for contract services are received. Therefore, Staff has approached all projections in a conservative manner. 1999/2000 ADOPTED BUDGET- GENERAL FUND REVENUES / EXPENDITURES In the Budget adopted by the City Council it was anticipated that General Fund Revenues, combined with the Net Fund Transfers In/Out, would exceed General Fund Expenditures. The amount of the surplus was projected to be approximately $3.4 million, which was allocated to reserves for the following projects: Name of Project Senior Center Downtown Improvements Open Space Library Building & Equipment Replacement (Internal Service Fund) Amount of Reserves $ 256,O98 250,000 150,000 1,783,857 __931,286 $3,371,241 Since the adoption of the Budget, the City Council has approved additional Budget Changes or Transfers. \~DUBLINFS2\CM\CC-MTGSX2000qtrl\FEBRUARY~2-29-00 g&o\as-midyear report, doc COPIES TO: ITEM NO. The approved additional General Fund appropriations listed below, includes only those items that were not offset by additional revenue or accomplished through a transfer from the Budgeted Contingent Reserve: ADDITIONAL APPROPRIATIONS/REVENUES APPROVED SUBSEQUENT TO BUDGET ADOPTION Library Materials Heritage & Cultural Arts Commission & Study Swim Center & Pool Renovations Civic Center Renovation Other Budget Adjustments Holiday Tree Lighting Sidewalk Safety Project Document Imaging System Downtown Specific Plan Sub-Total Expenditures Revenues $ 33,436 $63,731 19,500 101,405 95,503 12,526 9,335 10,926 13,400 14,492 $310,523 $63,731 Revenue Estimates Update Staff has analyzed the original Revenue Estimates in the 1999-2000 Adopted Budget. For most of the revised revenue forecasts, staff is not recommending budget changes since many of the revenue sources could differ as a result of economic changes or delays in development activity. The following breakdown will address anticipated changes within major categories as well as proposed adjustments to be made to the Budget Estimates in the City's Financial Records. The report focuses on areas where there are revised forecasts. No changes are expected for Use of Money & Property, and Other Revenues. Property Taxes (Category Represents 20% of the Budgeted General Fund Revenue) In February of each year, the Auditor Controller issues a current year estimate based on the Property Tax Roll and assumed countywide delinquency factors. Based upon this information, it appears that the budgeted property tax revenues will be exceeded by approximately $460,000. The estimated budget is net of revenue transfers mandated by the State of California. This includes the permanent Property Tax Shift to the Education Revenue Augmentation Fund ($599,132 for this year) and Property Tax Administrative Charges ($7t,300 for this year). As the City Council may recall, the State instituted these programs to solve State Budget issues. If these programs did not exist the cities would have these additional funds available to finance local programs. Revised Forecast: Increase $460,000 (No budget change recommended at this time) Taxes Other Than Property (Category Represents 34% of the Budgeted General Fund Revenue) When comparing tax revenues for the first seven months of this fiscal year to the same period in the prior year, it is projected that the revenue will exceed the budget estimate. The combined adjustments (positive and negative) are expected to result in a net increase of $600,000. -2- Sales' Tax represents the largest revenue included in this category. The retail sales tax data recorded to date only includes sales occurring prior to October 1, 1999. This does not include the retail Christmas season reporting, which typically represents a larger percentage of sales tax revenue. There has also been a delay in the relocation of businesses that the budget had assumed would not be located in the City for the full fiscal year. After discussions with the City's sales tax consultant, the City can expect to collect $9,650,000 for this fiscal year. This amounts to an increase of $450,000 above the original estimate of $9,200,000. Some of the revenue increases in this category are attributed to higher than expected collections of Transient Occupancy Tax (TOT) from the City's three hotels, due to higher room rates and higher than expected occupancy rates. Overall, the City expects to collect approximately $50,000 more than originally expected for TOT for the remainder of the 1999/2000 Fiscal Year. In addition, sales of commercial and residential properties continue to remain strong within the City, and as a result the City anticipates collecting approximately $50,000 more in property transfer taxes. Garbage Franchise Fees for the first six months is ahead of budget, and projected to be approximately $40,000 over budget by year end due to the addition of new residential customers and the development occurring in Eastern Dublin. The City received its annual payment of Cable Franchise fees in February 2000 and this ended up being approximately $18,000 over budget. The higher revenue resulted from the increase in cable rates that occurred during the year as well as more customers subscribing to new services offered by the cable company, such at intemet service and digital cable channels. This will 'result in Franchise fee estimated revenues exceeding budget by approximately $58,000. Revised Forecast: Increase $ 608,000 (No budget change recommended at this time) Licenses & Permits (Category Represents 8% of the Budgeted General Fund Revenue) Based upOn license and permit revenues for the first seven months comPared to the same period in the prior year'it appears that that the Revenue Estimate contained in the 1999-2000 Budget will be exceeded by approximately $173,000. Revenues in this category are often difficult to predict since Building Permits account for the majority of this revenue. At this time, the overall Building Permit revenue is falling behind the estimated budget due to delays ($322,000) in new construction activity in Eastern Dublin. The final year-end amounts are dependent upon the timing of permit issuance for development projects targeting the summer construction window. At the end of last fiscal year, about $186,000 in permits were pulled in June 1999 that were expected to be in this year's estimate. Although these revenues were recorded during Fiscal Year 1998-99, the expenses associated with the actual building inspections occurred in Fiscal Year 1999-2000. At this time, it is estimated that building permit revenue will drop from $2,861,000 to $2,339,000 for a decrease of $522,000. It app'ears that the permit revenue for encroachments and fire permits is ahead of the original budget forecast. Each of these revenue sources will generate an additional $23,000 and $20,000, respectively. Revised Forecast: Decrease $ 479,000 (No budget change recommended at this time) Intergovernmental Revenues (Category Represents 6% of the Budgeted General Fund Revenue) Based upon revenues for the first seven months compared to the same period in the prior year, it appears that that projected revenues in this category will exceed the Revenue Estimate contained in the 1999/2000 Budget -3, by approximately $110,000. The higher projections are assumed to be reflective of the continued growth in new car sales statewide, which increases the' Motor Vehicle in Lieu fees collected by the Department of Motor Vehicles. Revised Forecast: Increase $110,000 (No budget change recommended at this time) Charges For Services (Category Represents 12% of the Budgeted General Fund Revenue) Based upon Charges for Services for the first seven months, it appears that the overall Revenue Estimate for this category for 1999-2000 will be less than budgeted. The revenue shortfall is attributed to Engineering Plan Check and Fire Plan Check fees that are projected to be lower by $340,000 and $43,000, respectively. This decrease will be partially offset by lower expenditures related to these services. (See Expenditure. Discussion) The City will receive an increase in booking fees ($57,000) and higher than expected revenues for Zoning fees ($229,000). The greater portion of this increase in Zoning fees will be offset by increased contractual services for Planning and Legal Services. Revised Forecast: Decrease $97,000 Recommended Revenue Revision: Increase Zoning/Subdivision Fees by $229,000 (offset by $229,000 in expenditures) Expenditure Estimate Update Staff has reviewed expenditures through January 31, 2000 for all accounts that affect the City's General Fund. Given the lag in billing for some of the contract services the City does not have a full seven months of expenses to review for each budget activity. The following discussion highlights those areas where there is a variance in estimated expenditures at this time. The analysis assumes that all other expenditures will be in accordance with the adopted budget. General Government _(Represent 17% of the Budgeted General Fund Expenditures) The Legal Services Activity is projected to exceed budget by $70,000. In the General Legal expense category, legal expenditures have increased due to increased zoning enforcement issues and the overall increase in activities occurring in all Departments. These additional services will be approximately $55,000 more than budgeted. It is also anticipated that there will be an additional $15,000 in legal services associated with the various tasks and studies necessary to implement the Eastern Dublin Specific Plan. These costs will be offset by increased zoning and subdivision revenue. Recommended Budget Appropriation: Increase $70,000 (To be offset by $15,000 in revenue) Community Development (Represent 21% of the Budgeted General Fund Expenditures) At the present time the Planning Activity is projected to exceed the Budget estimate by $214,000. This is primarily due to increased development activity, the cost of which is recovered from the Project Applicants. Estimate for Engineering expenditures for contractual services are anticipated to be $272,000 less than budgeted. The reduced activity stems from delays in reviewing various plan checks associated with the development of Dublin Ranch in eastern Dublin. -4- Revised Expenditure Forecast: Decrease $272,000 for Engineering Services (No budget change recommended at this time.) Recommended Budget Appropriation: Increase $214,000 for Planning Services (To be ,offset by $214,000 in revenue) Capital Projects (Represent 11% of the Budgeted General Fund Expenditures) In the City Manager's Goals & Objectives Report dated January 27, 2000, 13 of 61 Capital Projects were identified as being behind schedule. Staff has not yet completed an analysis to identify how much Capital Project Funding will need to be carried over to Fiscal Year 2000-2001. Conclusion Based upon this analysis Staff recommends revising that the 1999-2000 General Fund Revenue Estimates should be increased by $229,000 and appropriations be increased by $284,000. These recommended changes were noted in bold lettering and are included in the table below recapping the General Fund budget. It shOuld be noted that these changes do not include potential additional revenue of $373,000 for revenue forecasts' that are still subject to change nor potential reduced expenditures of $272,000. If the combination of these forecasts are realized at year end, an additional $645,000 would be available. Staff does not recommend earmarking such funds until the conclusion of the fiscal year. It is important to note that these estimates are preliminary and a number of circumstances could affect the final outcome. MID YEAR 1999-2000 SUMMARY OF GENERAL FUND REVENUE & EXPENDITURE IMPACT ON RESERVES Revenue: 1999-2000 General Fund Revenue Estimate In Adopted Budget Earlier Revisions to Revenue Estimates Recommended Mid-Year Changes in Estimated Revenues Operating Transfers In Net Funds Available Appropriations: Budgeted Appropriations As Shown In the Adopted Budget Approved Appropriations Subsequent to Budget Adoption Recommended Mid-Year Changes in General Fund Appropriations Allocated Budget Reserves for Projects Operating Transfers to Internal Service Fund $ 26,694,329 63,731 229,000 27,600 23,350,676 310,523 284,000 2,439,955 931,296 $ 27,014,660 27,316,450 Appropriations and Project Reserves in Excess of Revenues $301,790' * Does not include forecasted increased revenues on reduced expenditures totaling $645,000. If these were included, 2000-2001 Revenues would exceed Expenditures by $343,210. Recommendation Staff recommends that the City Council take the following actions: (1) Receive this report and (2) Approve the Budget Change form. -5- CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF JANUARY 2000 Prepared by The Finance Department February 24, 2000 ATTACHMENT 1 City of Dublin 1999-2000 YTD Revenues and Budget Comparison For the Period Ending January 31, 2000 - Unaudited Total General Fund Sales Taxes , , ~50~ -- ~FY 1999/2000 Transient ~~ 62% Occupancy Taxes ~ FY 1998/1999 __ Franchise Taxes __ Licenses and ~ 58% Permits [52 -- I Interest and Rentals ]82~ Intergovernmental ~62% from State -- I Charges for Services ~ 36%48~ __ Other Revenues 0% 30% 60% 90% 120% 150% 58% of Year Complete FY 1999/2000 FY 1999/2000 % of FY 98~99 % of Total for Budget YTD Actual Budget YTD Actual FY 98/99 Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental Charges for Services Other Revenues 5,643,600 3,029,178 54% 2,635,429 51% 9,200,000 5,190,027 56% 4,347,194 50% 580,000 357,189 62% 163,981 42% 872,400 240,057 28% 216,434 25% 3,041,520 1,757,360 58% 1,279,774 52% 1,223,214 554,325 45% 1,103,085 82% 1,437,181 893,149 62% 701,614 52% 3,917,844 1,406,827 36% 1,664,079 48% 855,582 :180,907 21% 174,932 56% Total General Fund Revenues 26,771,341 13,609,019 51% 12,286,522 53% Date Printed: 02/07/200012:45 PM ATTACH M E N T I City of Dublin 1999-2000.YTD Expenses and Budget Comparison For the Period Ending January 31, 2000 - Unaudited ~48% llll/lllllll/~ 54~io i100% 7% ..... 154'% ~32% IFY 1999/2000 7% [] FY 1998/1999 __38% ]51% - ........ ,8% Total General Fund Expenses General Government Civic Center Lease Police Fire Other Public Safety Transportation Health and Welfare Community Development Capital Improv. Projects Culture & Community Services 0% 30% 60% 90% 120% 58% 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 98199 Budget YTD Actual Budget YTD Actual 2,501,322 1,107,956 44% 1,161,750 1,614,407 4,991,209 1,394,499 28% 1,21 7,443 4,209,712 782,363 19% 2,205,016 208,427 46,015 22% 60,466 827,008 385,419 47% 320,102 19,360 3,594 19% 727 3,059,288 1,31 7,469 43% 1,105,273 4,974,683 1,867,323 38% 1,822,233 2,873,951 555,378 19% 495,606 23,664,960 7,460,016 32% 10,003,023 20,791,009 6,904,638 33% 9,507,417 % of Total for FY 98~99 54% 100% 27% 54% 32% 41% 4% 49% 51% 28% 48% 49% ~,o ~.,,~: o=o,,~oo ~=~.~ ATTACH MENT 2 City of Dublin General Fund Income Statement Showing Revenues Versus Expenditures For the Period 7~99 Through 1100 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 5,190,027 56% 4,009,973 8,687,091 297,000 197,693 67% 99,307 282,733 580,000 357,189 62% 222,811 389,664 872,400 240,057 28% 632,343 849,959 3,041,520 1,757,360 58% 1,284,160 2,472,217 57,200 42,613 74% 14,587 60,876 1,128,154 524,513 46% 603,641 1,262,400 95,060 29,812 31% 65,248 90,539 1,437,181 893,149 62% 544,032 1,356,234 3,917,844 1,406,827 36% 2,511,017 3,482,983 798,382 138,294 17% 660,088 250,889 26,771,341 13,609,019 51% 13,162,322 24,051,678 150,305 87,711 58% 62,594 145,936 376,735 185,147 49% 191,588 331,437 222,712 104,264 47% 118,448 300,140 121,071 40% 179,069 310,558 723,174 296,249 41% 426,925 687,654 550,831 203,735 37% 347,096 531,1 67 114 -114 1,614,407 152,185 108,594 71% 43,591 125,622 940 753 80% 187 6,335 24,300 318 1% 23,982 1,029 2,501,322 1,107,956 44% 1,393,366 3,754,145 4,991,209 1,394,499 28% 3,596,710 4,505,598 54,760 15,367 28% 39,393 51,697 118,735 10,850 9% 107,885 104,137 34,932 19,798 57% 15,134 35,022 4,209,712 782,363 19% 3,427,349 4,109,003 9,409,348 2,222,877 24% 7,186,471 8,805,457 411,653 203,569 49% 208,084 389,595 500 26 5% 474 112,085 98,580 41,722 42% 56,858 46,320 11,661 25% 34,659 49,395 269,955 128,441 48% 141,514 225,855 827,008 385,419 47% 441,589 776,930 7,360 2,174 5,186 4,969 12,000 1,420 12% 10,580 12,000 19,360 3,594 19% 15,766 16,969 Prior YTD 2,494,015 4,347,194 141,414 163,981 216,434 1,279,774 36,017 1,063,227 39,858 701,614 1,664,079 138,915 12,286,522 83,898 189,218 122,313 368,283 306,583 1,614,407 85,150 6,305 2,776,157 1,217,443 19,475 21,865 19,126 2,205,016 3,482,925 209,013 114 14,164 96,811 320,102 727 727 51% 50% 50% 42% 25% 52% 59% 84% 44% 52% 48% 55% 51% 57% 57% 39% 54% 58% 100% 68% 100% 74% 27% 38% 21% 55% 54% 4O% 54% 29% 43% 41% Variance 2,372,078 4,339,897 141,319 225,683 633,525 1,192,443 24,859 199,173 50,681 654,620 1,818,904 111,974 11,765,156 62,038 142,219 188,245 319,371 224,584 40,472 3O 1,029 977,988 3,288,155 32,222 82,272 15,896 1,903,987 5,322,532 180,582 111,971 35,231 129,044 456,828 4,242 12,000 4% 16,242 City of Dublin General Fund Income Statement Showing Revenues Versus Expenditures For the Period 7199 Through 1100 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 Ca pital 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 Appropriations to Reserves ,., Current Current Prior Budget Actual % Variance Fiscal Year 342,994 77,283 23% 55,285 6,884 12% 55,074 26,888 49% 22,397 8,974 40% 757,818 258,909 34% 71,886 55,434 77% 280,456 138,120 49% 145,318 75,915 52% 201,388 87,370 43% 48,586 24,217 50% 83,391 32,874 39% 75,330 28,954 38% 62,015 37,003 60% 37,360 6,604 18% 240,908 162,977 68% 117,796 58,021 49% 114,863 53,302 46% 256,508 133,673 52% 89,915 44,067 49% 3,059,288 1,317,469 43% 1,007,854 568,169 56% 1,105,134 517,054 47% 2,549,357 657,751 26% 312,338 124,339 40% 4,974,683 1,867,323 38% 1,547,141 156,457 10% 304,646 72,068 24% 863,815 295,738 34% 158,349 31,115 20% 2,873,951 555,378 19% 23,664,960 7,460,016 32% 3,106,381 6,149,003 198% 3,106,381 6,149,003 198% 265,711 48,401 28,186 13,423 498 909 16 452 142 336 69 403 114 018 24 369 50,517 46 376 25 012 30 756 77 931 59 775 61 561 122 835 45 848 1,741,819 439,685 588,070 1,891,606 187,999 3,107,360 1,390,684 232,578 568,077 127,234 2,318,573 16,204,944 -3,042,622 -3,042,622 255,689 20,000 43,004 15,010 533,105 58 047 264382 137,577 164547 49 314 44 993 60 291 63 730 105,170 99,729 115,191 218,802 2,248,581 1,010,015 795,025 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 -9,115,813 Prior YTD 56,062 20,000 24,669 3,585 237,638 46,854 148,900 76,285 79,997 29,001 21,249 29,673 30,490 41,095 52,666 66,062 141,047 1,105,273 504,969 393,697 823,224 100,343 1,822,233 66,750 9,048 188,990 230,818 495,606 10,003,023 2,283,499 -12,134,212 -9,850,713 22% 100% 57% 24% 45% 81% 56% 55% 49% 59% 47% 49% 48% 39% 53% 57% 64% 49% 50% 50% 49% 87% 51% 26% 14% 17% 65% 28% 48% 75% Variance 199,627 18,335 11,425 295,467 11,193 115,482 61,292 84,550 20,313 23,744 30,618 33,240 64,075 47,063 49,129 77,755 1,143,308 505,046 401,328 862,375 15,419 1,764,168 185,263 54,224 921,314 122,752 1,283,553 10,964,619 780,537 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Jan2000 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,057.109) INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 43,592.415 149,497 205,076 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 5,849 13,997 24,909.725 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 (685.555) (17.878) (448,635) (163.436) (217,644) (10,047) (149,497) (1.692,693) (23.217,032) TOTAL FUND E (23.217,032) 1.896,207 311 28.347 1,924,865 (1,924.865) (1,924,865) 342,135 11,785,293 342,135 11,785,293 (18,061.409) (78.570) (5,849) (18.145,827) (342.135) 6,360,534 (342,135) 6,360.534 118,262 (4.915,212) (8,211.129) 149,763 149,763 149.763 43.592,415 149.808 205.076 34,196 13,997 34,556,969 1,399,589 502,727 212.897 7.027 1,860,500 1,860.500 1,860.500 2.128,525 41,090,543 30,478.344 (685,555) (18,079,287) (448,635) (242.006) (217 (10 (155 (t,978,000) (1,978 (1,978,000) (21,816 (150.525) (19,274 (150,525) (19.274 (498,812) (4,882,178) (468.866) (2.895,909) 644) (309,574) 047) (150,963) 346) (155.346) 000) (1,978.000) 520) (11,339,647) 023) (19,138,697) 023) (19,138,697) TOTAL LIAB. FND BAL. RETD (24,909.725) (1,924.865) (342.135) (11.785,293) (2,128,525) (41,090,543) (30,478,344) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Jan2000 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,120,650 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,612,605 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,612,605) TOTAL FUND E (20,612.605) 6.388,993 28.801.680 6,388,993 28.801.680 (6,388,993) (6,388,993) (28,801,680) (28,801.680) 1,120,650 1,023,507 25.880.948 25,880.948 28.801,680 29,519,398 55.803,278 56.423.853 (20,806) (28.801.680) (29.519.398) (28.801,680) (29,540,205) (27.001,598) (26,883,649) (27.001.598) (26,883,649) TOTAL LIAB. FND BAL. RETD (20,612.605) (6,388.993) (28.801.680) (55.803,278) (56,423,853) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/t999 THROUGH 01/31/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 183 800.00 59 000.00 90 160.00 2.515.457.00 136,650.00 402,336.00 729.650.00 30.000.00 4.230,018.00 39.810.33 43.154.67 75,233.49 108,566.51 47.131.66 11,868.34 90.160.00 342.034.01 2.173.422.99 50.924.00 85.726.00 23.174.31 379.161.69 3.67.819.69 361.830.31 31.609.31 (1,609.31) 977.736.80 3.252.281.20 76.684.53 172 561.75 65 857.76 93 371.12 753 103.27 149 244.00 374 449.92 706 992.33 22.439.87 2.414.704.55 *'*****~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 ACTIVITY TOTAL COMMUNITY DEVELOPMENT: ENGINEERING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: GENEP, AL 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.895.00 21.119.00 2.246.122.00 2,474,801.00 23.173.30 64,785.70 78.444.67 62.003.53 66.766.47 72.476.39 88.143.00 81.444.13 85.176.83 219.695.17 232.365.19 50,793.76 359.262.24 265.920.49 81.727.11 50.793.76 359.262.24 347.647.60 437.060.31 433.509.69 827.685.54 7.044.00 437.060.31 433.509.69 834,729.54 6.000.00 44.166.79 6.000.00 44.166.79 17,665.00 6.385.16 183.509.84 56.548.31 3.577.66 17,541.34 51.300.97 13.403.58 2.232,718.42 674.931.01 23,366.40 2.451.434.60 782.780.29 4.066.299.00 596.397.30 3.469.901.70 (163.719.00) (381.339.50) 217,620.50 2.241,689.41 (173.015.14) (130.265.91) 62.370.78 EXCESS <REVENUE> EXPENDITURE (163.719.00) (381.339.50) 217.620.50 (240.910:27) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 01/31/2000 S P EC I-AL ASSESSMENT FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ~****REVENUES******** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 309.093.00 151.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 ***~EXPENDITURES******* 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 EXCESS <REVENUE>EXPENDITURE 145,005.00 47.495.77 97.509.23 107,525.57 145.005.00 47.495.77 97.509.23 107,525.57 2,945.00 1.800.21 1.144.79 2,246.99 13,210.00 1,864.24 11.345.76 7,694.38 160.990.00 62.756.75 98~233.25 105,652.77 177.145.00 66,421.20 t10,723.80 115.594.14 4.200.00 4,336.86 (136.86) 3,084.88 4,200.00 4.336.86 (136.86) 3.084.88 18,700.00 46.41 18,653.59 82.600.00 166.57 82,433.43 101,300.00 212.98 101,087.02 427,650.00 101,030.00 101.030.00 118.466.81 309,183.19 (33,330.50) 134.360.50 (33,330.50) 134.360.50 226.204.59 (46.088.30) (46,088.30) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 01/31/2000 CAPITA[ IMPROVEMENT FUND CURRENT BUDGET CURRENT PRIOR ACTUAL VARIANCE FISCAL YEAR ********REVENUE******** 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 2,257,954.64 27.929.930.00 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 61.886 ACTIVITY TOTAL 61,886 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 2,206.938 COMMUNITY IMPROVEMENTS PARKS 9.443.800 STREET CONSTRUCTION/IMPROVEMENT 16,623.429 ACTIVITY TOTAL 28,274,167 16,915.01 16,915.01 .00 218.51 61.667.49 145.14 .00 218.51 61.667.49 145.14 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 28.336,053 406.123 EXCESS <REVENUE>EXPENDITURE 406,123.00 .00 638,621.17 1.568.316.83 .00 5.297,893.90 4.145.906.10 .00 866.110.11 15,757.318.89 .00 6.802,625.18 21,471.541.82 124.753.27 1,180,149.86 744,202.34 2.049.105.47 .00 6.802.843.69 21.533,209.31 2,066,165.62 .00 6.802.843.69 (6.396,720.69) (191,789.02) 6.802.843.69 (6,396.720.69) 17.586.84 (174.202.18) ********REVENUES***~**** SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE *******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 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 01/31/2000 TRUST/AGENCY FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR 116,594.77 (116.594.77) 235.672.36 12.637.55 116,594.77 (116.594.77) 248.309.91 190,256.00 (190.256.00) 231.864.50 190,256.00 (190.256.00) 231,864.50 190,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/01/1999 THROUGH 01/31/2000 INTERNAL SERVICE 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 240.499.39 348,775.61 726,998.50 25.700.00 28.607.44 (2.907.44) 17,455.06 671,807.00 269,106.83 402.700.17 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 145,567.39 561.341.61 794.802.16 706,909.00 151.157.39 555,75t.61 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 151.157.39 555,751.61 35.102.00 (117.949.44) 153,051.44 794,802.16 10,263.66 13,582.460.94 EXCESS <REVENUE>EXPENDITURE 35,102.00 (117.949.44) 153.051.44 (13.572.197.28)(13.690.146.72) 117.949.44 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THRUGH 01/31/2000 ENTERPRISE FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ,~****REVENUES***~* USES/MONE~ & PROP-INTEREST TOTAL REVENUE 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 TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 10.00 10.00 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 717.512.23 CITY OF DUBLIN BUDGET CHANGE FORM CHANGE FORM # New Appropriations (City Council Approval Required): Budget Transfers: XX From Unappropriated Reserves From Budgeted Contingent Reserve (1080-799.000) Within Same Department Activity XX From New Revenues Between Departments (City Council Approval Required) Other DECREASE BUDGET AccouNT "AMOUNT '.'.~ ~ INCREASE BUDGET. ACcoUNT'. AMOUNT'''. Name: Name: Revenue Account $225,000 Zoning/Subdivision Fees Account #: Account #: 001-565-001 Name: Name: Appropriation $70,000 .City Attorney - Contractual Services Account #: Account #: 001-10400-740 Name: Name: Appropriation $214,000 Planning Reimbursable Services Account #: Account #: 001-90100-741-003 Name: Name: Account #: Account #: Name: Name: Account #: Account #: Name: Account #: REASON FOR BUDGET CHANGE ENTRY: Mid-Year Budget Changes City Manager: Date: Signature As Approved at the City Council Meeting on: Date: Mayor: Date: Signature Posted By: Date: formslbudgchng Signature A-r.rAc M -r 2