The URL can be used to link to this page

Home My WebLink About4.05 97-98MidYrBudgetRpt ~':I <";:1~~ CITY CLERK File # [Q][!][i]~-g][9J . AGENDA STATEMENT...~., CITY COUNCIL MEETING DATE: (Febru~~.)?1~.98) . - . .. SUBJECT: Fiscal Year 1997-98 Mid-Year Budget Report p~ Report Prepared by: Paul S. Rankin, Assistant City Manager EXIllBITS ATTACHED: Chart of Fiscal Year 1997/1998 General Fund Revenues Collected To Date (December 31, 1997) 2. Chart of Fiscal Year 1997/1998 General Fund Expenditures Thro December 31, 1997 1. 3. Balance Sheet and Income Statements for the Period Ending December 31,1997 ;: 4. General Fund Budget Change Form . RECOMMENDATION: ~ FINANCIAL STATEMENT: Approve Budget Change Form and Receive and File Report See Report For Monthly Activity and Projections For Fiscal Year . DESCRIPTION: Attached is the monthly report of financial activities for December 1997. Given that one half of the Fiscal Year has lapsed, Staff has conducted a mid-year analysis of the City's Revenues and Expenditures. It is important to understand that some of the data is limited. Therefore, Staff has approached all projections in a conservative manner. This analysis focuses on the activities within the General Fund, which represents the largest portion of the City Budget. 1997/98 Adopted Budget 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 excess was projected to be approximately $271,106. Since the adoption of the Budget, the City Council has approved Budget Changes or Transfers which will reduce the amount of excess General Fund Revenues anticipated to be appropriated to Reserves at the end of the Fiscal Year. The net effect is that the revised estimate of the amount to be appropriated to reserves for Fiscal Year 1997-98 has decreased by $51,357 to $219,749. The following provides a reconciliation of the revised amount of appropriations that will be put into reserves at the end of the fiscal year, prior to accounting for any further budget adjustments. The approved additional General Fund appropriations listed below were items that were not offset by additional revenue or accomplished through a transfer from the Budgeted Contingent Reserve: . G:\FINANCE\MIDYRRPT\1998\AGMIDYR.DOC COPIES TO: ITEM NO. f,5 ---' . Reconciliation of Amount Appropriated to Reserves for Fiscal Year 1997/98 Amount Per Adopted Budget $ 271,106 , , Less Fundin~ of Additional Appropriations Traffic Signal Equip/LED Conversion (#13 - 11/4/97).. Crossing Guard at Dublin Elementary (#14 - 11/18(97) 8t. Patrick's Day Celebration (#19 - 12/3/97) <$35,876> . . <$3,161> <$12.320> $ 219,749 Revised Balance Appropriated to Reserves as of December 31, 1997 I I. Operatinf: Transfers The Adopted Fiscal Year Budget was predicated on an assumption that there would be $126,450 transferred to the General Fund by other funds. The source of these transfers included the following: a) Administrative CDBG costs in the amount of $6,600; b) Reimbursement for the cost of the Fire Impact ~ee Study in the amount of $10,785; c) Reimbursement of a portion of the Noise Mitigation Study costs in the amount of $5,000; and d) Dublin Information Inc. interest earnings on the Certificate of Participation Reserve Fund. At the present time all of these activities are tracking in accordance with the budget, and it is assumed that all anticipated transfers will be made to the General Fund prior to year end. Revised Budget Estimate: No Change . Fiscal Year Revenue Estimates Staff has analyzed the original Revenue Estimates contained in the 1997-98 Adopted Budget. Although there are anticipated fluctuations in revenues, adjustments will not be made to the Budget Estimates in the City's Financial records. The City has a balanced budget and the preliminary indications of variances do not warrant a change at this time. The following breakdown will address anticipated changes within major categories. Property Taxes (Represent Approximately 24% of the Budgeted General Fund Revenue) Based upon tax revenues for the first six months compared to the same period in the prior year it appears that that the Revenue Estimate contained in the 1997/98 Budget will remain unchanged. : In Fiscal Year 1996/97 the total collected was $ 3,920,897. The budget for Fiscal Year 1997/98 is $4,286,000, which represents an increase of nine percent. Overall, based upon limited collections to date this revenue projection should be met. Fluctuations do occur within individual revenue items. For example, the Secured Property Tax may actually exceed the original budget estimate, however, this appears to be offset by decreased collections in both Unsecured Property Tax and Supplemental Property Taxes. Revised Estimate: No Change . -;2.- . :. f . { . .~~ Taxes Other Than Property (Represent Approximately 44% of the Budgeted General Fund Revenue) Based upon tax revenues for the ,first six months compared to the same period in the prior year it appears that the Revenue Estimate may be, approximately $420,5.90 more than the 1997-98 Revenue estimate. . . 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, 1997. This does not include the retail Christmas season reporting, which typically represents a larger percentage of the total fiscal year sales tax revenue. Preliminary data reported in the press indicated that some retailers experienced a decline in sales over the 1996 Christmas season. Based on the available data, Sales Taxes collected through this period were $3,446,926, an increase of approximately $371,000 from the same period in the prior year. Although Auto Sales comprise a large percentage of the Retail Sales Tax base the City Staff have also noted improved sale reports in other sectors including: General Consumer Retail Stores; Business and Industry; etc. It is too early to determine the full extent that a decline in Christmas retail sales may make on gains experienced in the prior quarters. The sales tax data covering retail sales between October and December is usually received by the City in the months of March and April. However, the 1997/98 Budget estimate of $6,850,000 was approximately $258,598 less than actual sales tax collected in Fiscal Year 1996/97. Therefore, it appears reasonable at this point in time to anticipate that Sales Tax will be at least $300,000 above the budget estimate. In recent years the estimation of Documentary Transfer Tax has been difficult due to limited knowledge of the timing of major property transactions. Receipts posted as of December 31, 1997 show that a total of $85,561 was collected. This amounts to approximately 70% of the original budget estimate. Utilizing historical data and current trends this revenue may exceed the budget estimate by $75,000. This is caused by several large property transactions primarily in Eastern Dublin as well as a general increase in the number of real estate transactions elsewhere in the City~ ' Other revenue types accounted for in this category include Transient Occupancy Taxes and Franchise Fees. The City has continued to record an improvement in the Transient Occupancy Tax collections. If the current trend continues it is anticipated that this revenue may exceed the budget estimate by $50,000. Garbage Franchise Fees for the first six months are tracking at a level which may exceed the budget estimate by a minor amount. However, any increase may be offset by market fluctuations on the sale of the recycled commodities collected. The payment of Gas & Electric Franchise fees will not occur until April and for this analysis it was assumed that they would meet the budget. In January the City received a preliminary estimate of the Cable Television Franchise fee and it is projected to be approximately $4,500 less than the budget. Revised Estimate: Net Increase $ 420,500 new and existing projects during the last six months of Fiscal Year 1997-98, it is expected that the City will slightly exceed its revenue estimate for this category. Although the above revenues will be recorded during Fiscal Year 1997-98, the expenses associated with the building inspections may actually oc.~ur in Fiscal Y e~. 1998-99 or beyond. This is due to the lag between when a. permit is obtained and when the fuial inspection is made. .. .., Revised Estimate: No Change Use of Money & Property (Represent Approximately 7% of the Budgeted General Fund Revenue) ~ Interest Revenue represents 93% of the total budgeted revenue in this category. The remainder consists of rental income collected for the use of City facilities. f Although it is too early to calculate the exact General Fund share of total interest revenue, it appears that revenues in this category will exceed the Budget Estimate. The City has a larger fund balance available for investment than was assumed in preparing the original Budget Estimate. The final earnings may be affected by the recent decline in interest rates. Anticipated revenue from City facilities appear to be tracking below budget due to lower than expected field rental fees. Revised Estimate: Net Increase $ 100,000 Intergovernmental Revenues (Represent Approximately 7% of the Budgeted General Fund Revenue) Based upon revenues for the fIrst six months compared to the same period in the prior year it. appears that that projected revenues in this category will fall below the Revenue Estimate contained in the 1997/98 Budget by approximately $11,000, due to lower than expected Motor Vehicle in Lieu fees from the Department of Motor Vehicles. Revised Estimate: Net Decrease <$ 11,000> Charges For Services (Represent Approximately 9% of the Budgeted General Fund Revenue) Approximately, 54% of this revenue category is related to Zoning and Subdivision Fees and Engineering Plan Check & Inspection Fees. When there is a high level of development activity this revenue will fluctuate from period to period. Based upon current estimates, it appears that that the Revenue Estimate contained in the 1997/98 Budget will be exceeded. A significant portion of ,this revenue will also be reflected to offset contract service costs in Legal Services, Community , Development Services, and Engineering Services. The exact level also depends upon how quickly some of the proposed developments proceed through the approval process. In the event that developers delay their project processing, there will also be an offsetting savings in expenditures to the extent that the City is using independent contractors to process the development application. Based upon current activity it is recommended that the Zoning and Subdivision Fee Revenue estimate be increased..by $207,500. This is necessary to offset anticipated additional expenses in. Legal Services and Planning related to contract costs associated with processing applications. In addition it is recommended that the Engineering Plan Check Revenue estimate be increased by $250,000. This reflects increased Engineering activity related to development applications. ,- t./"-- . I. I " . . ":'""" Recreation Program Charges account for approximately 32 percent of this revenue category. Based upon programs completed as of December 21, 1997 it is projected that combined Recreation Program Revenue may exceed th~t>udget by apjm)xhDately $50,000. . A significant portion of the overall increase is due to new Drarila Class offerings which wet::e implemented for the first time in the Summer of 1997. ,-..., Revised Estimate: Net Increase S507,500 Other Revenues (Represents 3% of the Budgeted General Fund Revenue) ; . This category of Revenue often relates to one-time miscellaneous collections and therefore, the timing of receipts does not reflect any historical pattern. The adopted Budget did include $50,000 for the sale of access rights to a piece of property. The transaction has been delayed by the developer. Therefore, it is currently assumed that the revenue will not be received in Fiscal Year 1997/98. A minor contribution of $650 will be recorded, which was not previously budgeted. This item is more fully explained in the expenditure section of the Culture & Leisure Program area. Revised Estimate: Net Decrease <$49,350> Revisions To Expenditure Estimates Staff has reviewed expenditures through December 31, 1997 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 six months of expenses to review for each budget activity. The following discussion highlights those areas where the need for an increase in the Budget Appropriation appears likely at this time. The analysis assumes that all other expenditures will be in accordance with the adopted budget. General Government - (General Fund Budget Total: $1,779,029 - excluding debt service) (Represent Approximately 19% of the Budgeted General Fund Expenditures) The majority of General Government budget activities appear to be tracking within budget, based upon the fIrst six months of experience. A minor adjustment to the City Council Community Promotion Account (1010-731) is recommended based upon the Dublin Pride Week Report accepted at the City Council meeting on January 20, 1997. The City Council authorized expenditure of a $2,500 donation from Livermore Dublin Disposal in addition to the funds already included in the adopted budget. . ,The Legal Services Budget will require an adjustment. Most of the increased costs related to legal time expended on planning applications, for which the applicant is charged fees which will reimburse the City. It is recommended that the Legal Services Budget be increased by $48,000 to accommodate these services for projects currently being considered. In the event that Development Applicants decide to delay proceeding with projects these expenditures would not be realized, and the collection of the offsetting revenues would not occur. Revised Budget Estimate: Net Increase $ 50,500 -~- Public Safety - (General Fund Budget: $8,165,429) (Represent Approximately 46% of the Budgeted General Fund Expenditures) Currently, all of the Public SafetyJmdget actiVities appear to be tracking within budget, the Onl. exception being the Disaster Preparedness Activity, which i~, somewhat below budget due to temporary staff vacancy. At this time no change is recommend~d to the budget for this expenditure category. Revised Estimate: No Change Transportation - (General Fund Budget: $ 667,372) (Represent Approximately 4% of the Budgeted General Fund Expenditures) Currently, nearly all Transportation budget activities appear to be tracking within budget. Limited activity has been recorded in the street repair activity, as the annual work in advance of the overlay. project has been delayed. Based upon .information collected to date no change is recommended in ~~~ ~. t Revised Budget Estimate: No Change Health and Welfare - (General Fund Budget: $17,320) (Represent Less than 1 % of the Budgeted General Fund Expendit1;rres) .;: ' . Currently, all of the Health and Welfare budget activities appear to be tracking within budget. At this time no change is recommended to the budget for this expenditure category. . Revised Estimate: No Change Culture and Leisure Services - (General Fund Budget: $ 2,120,550) (Represent Approximately 12% of the Budgeted General Fund Expenditures) At the present time the Culture and Leisure Services budget activities are expected to exceed the ___ amount budgeted by $39,000. This is attributable to increased participation in Recreational Instruction classes and a pool repair which was originally expected to be completed in Fiscal Year 1996/97. The budget for contract Recreation Class Instruction is recommended to be increased by $35,000 for the contract services account. The City receives class revenues which offset the program costs associated with the contract instructors. The City has implemented various drama offerings which were well attended as well as attendance increases in other class offerings. The Swim Center incurred costs of approximately $4,000 associated with repairs of the filter equipment. This expense had been budgeted in the prior year. Staff is also presenting a Budget change for the Senior Center Activity, which will be financed from unanticipated revenues. Throughout the year the Senior Center receives various cash gifts and donations which are accepted by the City. In the event that a proposed expenditure is not initially identified the monies are recorded in a liability account, until they are expended. Senior Center Program need~. not originally included in the adopted budget were identified by Staff in the . amount of $650. The Budget Change will also account for the unanticipated revenue. Revised Budget Estimate: Net Increase $39,650 -10- . I !' . '",",,'- Community Development - (General Fund Budget: .$ 2,266,885) (Represent Approximately 13% Qf:the Budgeted General Fund Expenditures) . .". At the present time the Community Development Program is anticipated to exceed the amount budgeted by a total of $ 318,000. This is co~prised_ of expenditures' in the Community Development -. Planning activity of $ 118,000 and Engmeering Private Development Plan CheckinglInspection of $200,000. The Engineering activity is experiencing the same pressures from the quantity of development applications being processed. This is primarily due to the use of additional contract consultant services for the processing of several development projects within the City. As discussed in the Revenue section the City does recover these costs through fees collected from the project applicants. Revised Budget Estimate: Net Increase $ 318,000 Capital Projects - (General Fund Budget: $ 1,207,761) . . (Represent Approximately 6% of the Budgeted General Fund Expenditures) Revised Budget Estimate: Net Decrease $ <62,600> Summary of Estimated General Fund Revenue and Expenditure Variances The combined impact of the estimated revenue and expenditure adjustments are shown in the summary which follows. Staff has prepared a Budget Change Form (EXHIBIT 4) which will authorize the proposed line items to be adjusted. As outlined in the following section, the City is projected to continue to have a balanced budget following the recommended mid year adjustments. Based upon this analysis Staff anticipates that the 1997/98 General Fund Revenues will be increased by a net amount of $967,650 more than the adopted budget. As stated earlier in this report, the Budget already anticipated an appropriation to reserves. The impact of the revised revenue forecast is that the appropriations to reserves will increase. This will be offset by additional expenditure appropriations prior to year end, including those shown below. It is also important to note that over one half of this amount is related directly to areas where there will be increased costs (Le. development related activities). =-1- GENERAL FUND SUMMARY OF MID-YEAR ESTIMATES REVENUES -- . Taxes Other Than Property Use of Money & Property ~ Intergovernmental Charges For Services Other Revenues Sub-Total $420,500 100,090 ( 11,000) 507,500 ( 49,350) $967,650 . EXPENDITURES Operating Exp. General Government Culture & Leisure Services Community Development $ 50,500 39,650 318,000 408,150 ~' ( Capital Project Exp. Capital Projects TOTAL ESTIMATED NET EXP. CHANGE ( 62,600) $345,550 ESTIMATED NET IMPACT (Revenue Less Exp) $622,100 Summary of Projected 1997/98 General Fund Budget The City's fiscal condition remains positive for the current fiscal year. It should be noted that over $300,000 in Capital Projects are proposed to be undertaken subsequent to the preparation of this report. . Cal- Trans and other public agencies have noted increased bid awards in recent months due to the level of construction activity throughout the region. The following summarizes the projected General Fund results for Fiscal Year 1997/98: FISCAL YEAR 1997/98 MID YEAR SUMMARY OF ESTIMATED GENERAL FUND APPROPRIATIONS TO RESERVES 1997/98 General Fund Revenue Estimate Plus: Budgeted Net Transfers Plus: Projected Increases in Revenues: Less: Budgeted Expenditures Less: Approved Budget Changes Not Offset By Additional Revenue Less: Mid-Year Increase in General Fund Budgeted Operating Exp. Plus: Mid Year Decrease In General Fund CIP Budget $ 17,921,103 126,450 967,650 < 17,824,265> < 51,357> <408,150> 62.600 REVISED MID-YEAR PROJECTION OF GENERAL FUND REVENUES IN EXCESS OF GENERAL FUND EXPENDI11JRES $ 794.03 I It is important to note that these estimates are very preliminary and a number of circumstances could .' affect the final outcome. If the projections outlined in this report actually occur, the City will have an approximately 3.2 percent increase in the General Fund Balance at the end of the Fiscal Year. In the past, . interest earnings on the General Fund Balance provides an important source of revenue. Although the level of income fluctuates with interest rates these monies are independent of the State or other entities outside of the City's controL It is also important to consider that some revenues such as processing costs are one-time items and they should not be automatically expected to cover operating costs in a future year. - 5Z ~ . . . ,..'~~' It is also important to keep in mind that although expenditures are expected to be below the Budget in some categories, no adjustment is reconunended at this time. , Recommendation ..' Staffreconunends that the City Council take the folloWing actions: (1) Approve the Budget Change forms for additional appropriations (EXHIBIT 2); and (2) Receive and file this report:. . {' -1-- Exhibit 1 City of Dublin 1997-98 YTD Revenues and Budget Comparison For the Period Ending December 31,1997- Unaudited Franchise Taxes .., . Total General Fund. Revenues / .'- . :" .~. : . ..". . Sales Taxes Transient Occupancy Taxes .FY 97/98 . FY 96/97 Licenses and Permits 68% Interest and Rentals . Intergovernmental from State Charges for Services Other Revenues 0% 30% 60% 90% 120% 150% 50% of tear Complete FY 97/98 FY 97/98 %of FY 96/97 % of Total for Budget YTO Actual Budget YTO Actual FY 96/97 Property Taxes 4,407,700 2,306,657 52% 2,143,798 53% Sales Taxes 6,850,000 3,446,926 50% 3,075,379 43% Transient Occupancy Taxes 231,000 132,204 57% 90,447 34% Franchise Taxes 750,500 168,685 22% 135,276 19% Licenses and Pennlts 1,043,350 709,036 68% 414,759 38% Interest and Rentals 1,328,450 679,360 51% 458,157 33% Intergovernmental 1,171,620 557,155 48% 523,038 45% . Charges for Services 1,631,918 764,950 47% 564,243 41% Other Revenues 506,565 181,797 36% 100,920 37% Total General Fund Revenues 17,921,103 8,946,770 50% 7,506,017 43% 1130198 8:26 g:\mo.,thfsIfy9BVscolor.xls EXHIBIT 1 - GENERAL FUND REVENUES laj'/6 City of Dublin 1997.98 YTD Expenses and Budget Comparison For the Perio~Ending Dece~ber 31, 1997 - Unaudited Total General Fund 37% Expenses. '.38% --- ---- - Other Public Safety General Government Civic Center Lease Police Fire Transportation Health and Welfare 43% Culture & Community Services Community Development Capital Improv. Projects 8% 30% 60% 50% of Year Complete FY 97/98 % of YTO Actual Budget 832,930 47% 367,127 23% 1,070,087 25% 1,936,403 54% 20,110 7% 269,750 40% 4,425 26% 940,702 44% 1,011,593 45% 214,504 18% 6,667,631 37% 6,453,127 39% 0% FY 97/98 Budget General Government Civic Center Lease Police Fire Other Public Safety Transportation Health and Welfare Culture and Community Services Community Development Capital Improvement Projects 1,n9,029 1,599,919 4,283,274 3,598,953 283,202 667,372 17,320 2,120,550 2,266,885 1,207,761 Total General Fund Expenses 17,824,265 General Fund Operating Expenses 16,616,504 1130198 8:28 90% FY 96/97 YTO Actual. 732,823 389,547 933,7n 1,381,282 48,753 245,103 6,634 759,402 n3,986 603,794 5,875,101 5,271,307 EXHmIT 2 - GENERAL FUND EXPENDITURES Exhibit 2 .FY 97/98 . FY 96/97 120% % of Total for FY 96/97 g:lmonthfslfy98\fscolor Jds --; eO it; . 43% 26% 25% 50% 27% 39% 43% 38% 42% 58%. 38% 37% . :.. ~~. t ,- } t ~, r . . CITY OF DUBLIN'S FINANCIAL STATEMENTS , . , FOR THE MONTH OF DECEMBER 1997 Prepared by The Finance Department January 13, 1998 EXHIBIT 3 ,. /" I / ,. '-;)"'- I::::> ./ - , Gl1 02 CITY OF DUBLIN PAGE 1 1/13/98 BALANCE SHEET 17.29.19 FOR THE PERIOO 7197 THRCUGH 12/97' . . " L. GENERAL SPECIAL SPECIAL CAP IT AL TRUS-~1. T 0 T A REVENUE REVENUE ASSESSH;NT IMPROVEMENT AGENCY u - MEMORANDUM ONLY _n FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30, 1997 ASSETS CASH 5943737.72- 1638799.61 292755.56 4683636.47 134986.35 806440.27 259512.29- ~~ CASH WITH FISCAL AGENT 139866.37 139866.37 132608.16 UNAHORTIZED BOND DISCOUNT INVESTMENTS AT COST 32309321.17 32309321.17 26828006.89 RECEIVABLES;TAXES ACCOUNTS (NET) 179704.41 179704.41 306200.31 .~~ INTEREST 175681.50 175681.50 ASSESSMENTS RENTS NOTES DUE FRc>>4 OTHERS 248261.35 85226.76 333488.11 21596.01 INVENTORY AT COST PREPAID ITEMS 7014.75 7014.75 6082.85 FIXED ASSETS AMOONTS TO BE PROVIDED 2018500.00 2018500.00 2090500.00 TOTAL ASSETS 26976245.46 1724026.37 292755.56 4683636.47 2293352.72 35970016.58 29125481.93 LIAS, FND BAL, RETNO EARNINGS 353.7~ DEPOSITS FOR PRIVATE DEVELPMNT 446022.56- 446022.56- DEPOSITS FOR AB1600 FEES 4775995.12- 4775995.12- 688222.47- DEPOSITS OTHERS 650221. 14- 3547.89- 248261.35- 902030.38- 676866.40~ PAYABLES;ACCOUNTS 351085.84- 2861.85- 628.35 353319.34- 299327.55- INTEREST PAYROLL 3194.12- 3194.12- 760.00 DUE TO OTHERS 260.00- DEBT INSTRUMENTS PAYABLE 2136000.00~ 2136000.00- 2208000.00- TOTAL LIABILTIES 1450523.66- 6409.74- 5023628.12- 2136000.00- 8616561.52~ 4225705.59- FUND BALANCES 25525721.80- 1717616.63- 292755.56- 339991. 65 157352.72- 27353455.06- 24899776.34- TOTAL FUND EQUITY 25525721.80- 1717616.63- 292755.56- 339991.65 157352.72- 27353455.06- 24899776.34- TOTAL LIAS,FND BAL, RETD EARNS 26976245.46- 1724020.37- 292755.56- 4683636.47- 2293352.72- 35970016.58- 29125481.93- . LI / !~. ~D . 5 cD Jb ... ......... GL 104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 1113/98 REVENUES VERSUS EXPENDITURE 17.01.11 FOR THE PERIOD 1/97 THROUGH 12/97 . '.;" .. GENERAL REVENUE FUND CURRENT PERIOD PREV10US YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE- ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D P ~~~~~~..REVENUES**..". f PROPERTY TAXES 4286000.00- 2221095.92- 51.8 2064904.08- 3920897.29- 20967T7.66- 53.5 1824119.63- ; SALES TAX 6850000.00- 3446925.64- 50.3 3403074.36- 7108598.19- 3075379.37- 43.3 4033218.82- f REAL PROPERTY TRANSFERS 121700.00- 85561. 16- 70.3 36138.84- 138062.47- 47020.00- 34.1 91042.47- t TRANSIENT OCCUPANCY TAX 231000.00- 132204.00- 57.2 98796.00- 267007.09- 90446.72- 33.9 176560.37- f' FRANCHISE TAXES 750500.00- 168684.83- 22.5 ' 581815.17- 723384.60- 135275.83- 18.7 588108.77- ~:' LICENSES & PERMITS 1043350.00- 709035.68- 68.0 334314.32- 1092182.95- 414758.93- 38.0 677424.02- r FINES & FORFEITURES 33200.00- 18433.43- 55.5 14766.57- 38492.21- 23214.08- 60.3 15278.13- ~ 1328450.00- 679359.77- 51.1 649090.23- 1388948.66- 458156.73- t USES OF MONEY AND PROPERTY 33.0 930791.93- t INTERGOVERNMENTAL FROM STATE 1171620.00- 557154.78- 47.6 614465.22- 1151275.49- 523037.51- 45.4 628237.98- ! CHARGES;FOR SERVICES 1631918.00- 764949.84- 46.9 866968.16- 1386418.59- 564242.67- 40.7 822175.92- . OTHER SOuRCES OF REVENUE 473365.25- 163363.84- 34.5 310001.41- 223207.32- 7T705.68- 34.8 145501.64- TOTAl REVENUE 17921103.25- 8946768.89- 49.9 8974334 .36- 17438474.86- 7506015.18- 43.0 9932459.68- .......EXPENDITURES....... GENERAl GOVERNMENT ACTIVITIES: NOH-DEPARTMENTAL 19215.00 187.40 1.0 19027.60 27346.97 .00 27346.97 CITY COUNCIL 1010 137334.00 63648.40 46.3 73685.60 127472.84 69983.66 54.9 57489.18 CITY MANAGER 1020 334487.00 142715.08 42.7 191771.92 291093.65 129457.65 ' 44.5 ~~~ CITY ATTORNEY 1030 186794.00 96004.33 51.4 90789.67 201718.85 62215.29 30.8 ADMIN SERVICES 1040 637675.00 284870.03 44.7 352804.97 569247.12 251492.71 44.2 31 BUILDING MANAGEMENT 1050 315955.00 144751.29 45.8 171203.71 331517.40 135201.38 40.8 196316.02 FACILITY RENTAL 1050-719 1599919.00 367126.86 22.9 1232792.14 1496816.41 389546.91 26.0 1107269.50 INSURANCE COST CENTER 1060 146803.00 100377.47 68.4 46425.53 1227T7.83 82567.81 67.2 40210.02 ELECTIONS COST CENTER 1070 766.00 375 .91 49.1 390.09 20511.92 1904.68 9.3 18607.24 ACTIVITY TOTAL 3378948.00 1200056.77 35.5 2178891.23 3188502.99 1122370.09 35.2 2066132.90 PUBLIC SAFETY: POll CE 2010 4283274.00 1070086.77 25.0 3213187.23 3794625. 12 9337T7.49 24.6 2860847.63 CROSSING GUARDS COST 2020 49048.00 15986.64 32.6 33061.36 40926.26 13277.04 32.4 27649.22 ANIMAL CONTROL 2030 200124.00 .00 200124.00 110514.00 21918.00 19.8 88596.00 DISASTER PREAPREDNESS 2050 34030.00 4122.87 12.1 29907. 13 25992.10 13557.89 52.2 12434.21 FIRE SERVICES 2060 3598953.00 1936402.67 53.8 1662550.33 2751796.45 1381281.79 50.2 1370514.66 ACTIVITY TOTAL 8165429.00 3026598.95 37.1 5138830.05 6723853.93 2363812.21 35.2 4360041. 72 TRANSPORTATION: PUBlI C lJOR(S 3010 366732.00 162037.42 44.2 204694.58 319005.00 139257.24 43.7 179747.76 STREET HAINTENANCE 3020 55770.00 2794.43 5.0 52975.57 31593.44 28843.36 91.3 2750.08 STREET TREE MAINTENANCE 3040 47700.00 11260.11 23.6 36439.89 48375.71 10809.66 22.3 37566.05 STREET LANDSCAPE MAINT. 3050 197170.00 93657.88 47.5 103512.12 230289.60 66192.97 28.7 164096.63 ACTIVITY TOTAL 667372.00 269749.84 40.4 397622.16 629263.75 245103.23 39.0 384160.52 HEALTH & WELFARE: IJASTE HANAGEMENT 5020 5320.00 .00 5320.00 3595.87 633.50 17.6 2962.37 CHILD CARE 5030 12000.00 4425.32 36.9 7574.68 12000.00 6000.00 50.0 6000.00 ACTIVITY TOTAL 17320.00 4425.32 25.6 12894.68 15595.87 6633.50 42.5 8962.37 CULTURE & LEISURE SERVICES: lIB.RARY SERVICES 8010 216994.00 54249.25 25.0 162744.75 205874.00 51468.50 25.0 154405.50 CULTURAL ACTIVITIES 8011 10000.00 10000.00 100.0 .00 12500.00 10000.00 80.0 2500.00 HERITAGE CENTER 8012 55930.00 26338.72 47.1 29591 .28 54291. 08 29204.71 53.8 250. DUBLIN CEMETERY 8013 16690.00 7479.85 44.8 9210.15 15749.25 6369.99 40.4 93 6 J u~ -"i.,i .; -- GL104c THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2 1/13/98 REVENUES VERSUS EXPENDITURE 17.D1.11 FOR THE PERlOO 7197 THROUGH 12/97 . GENERAL REVENUE FUND " CURRENT PERlOO' PREVIOUS YEAR ENDING JUNE 30, 1997 r BUDGET ACTUAL PERCENT VARIANCE ACTUAL - . AcTUAL PERCENT VARIANCE " , FISCAL YR Y~T~O (- PARK MAINTENANCE 8020 589455.00 244756.32 41.5 344698.68 594119.19 154100.52 25.9 440018.67 ( , CCM4UNITY CABLE TV 8030 37051.00 26823.00 n.4. 10228.00 34256. n 24386.n 71.2 9870.00 <' RECREATION ADMIN. 8040 256353.00 112758.88 44.0 143594.12 234707.54 98876.16 42.1 135831.38 t- PLAYGROUNDS 8045 128003.00 59663.40 46.6 68339.60 108257.69 53273.04 49.2 54984.65 t' SHANNON CENTER 8050 148006.00 72109.51 48.7 75896.49 136660.43 59986.95 43.9 76673.48 , PRESCHOOL 8055 54333.00 24251.68 44.6 30081 .32 51629.57 23240.03 45.0 28389.54 r. -I-- TEENS PROGRAM 8060 35296.00 10984.04 31.1 24311.96 25445.93 12433.18 48.9 13012.75 .. ADULT SPORTS 8065 65350.00 28748.94 44.0 36601.06 61034.72 26041.10 42.7 34993.62 L "l. YOUTH SPORTS 8066 52406.00 20154.66 38.5 32251.34 39910.77 16283.n .. 40.8 23627.05 .-irc t' SPECIAL EVENTS 8070 42042.00 15897.34 37.8 26144.66 40133.97 14793.08 36.9 25340.89 ;- SENIOR CENTER 8080 104821.00 44576.19 42.5 60244.81 80392.97 36949.67 46.0 43443.30 RECREATION INSTRUCTION 8090 88555.00 64450.68 n.8 24104.32 89684.89 41333.00 46.1 48351.89 AQUATICS 8100 219265.00 117459.97 53.6 101805.03 215910.85 100661.48 46.6 115249.37 ACTIVITY TOTAL 2120550.00 940702.43 44.4 1179847.57 2000559.57 759401 .85 38.0 1241157.72 COMMUNITY DEVELOPMENT: PLANNING 9010 744971.00 348m.37 46.8 396198.63 659318.79 306m.45 46.5 352545.34 BUILDING SAFETY 9020 593826.00 245542.65 41.3 348283.35 386171.15 157828.55 40.9 228342.60 ENGINEERING 9030 781875.00 332034.35 42.5 449840.65 684913.30 254463 . 06 37.2 430450.24 ECONOMIC DEVELOPMENT 9040 146213.00 85243.17 58.3 60969.83 108155.26 54920.69 50.8 53234.57 ACTIVITY TOTAL 2266885.00 1011592.54 44.6 1255292.46 1838558.50 m985.75 42.1 1064572.75 CAPITAL IMPROVEMENT PROJECTS: ~RAL CIP PROJECTS 93NN 584850.00 188584.65 32.2 396265.35 80137.74 26081.84 32.5 54055.90 NITY IMPROVEMENTS 94NN 66000.00 1195.56 1.8 64804.44 51771.12 .00 51771.12 PARKS 95NN 196989.00 17116.08 8.7 179872.92 497423.22 393126.22 79.0 104297.00 STREET CONSTRC/IMPROVMT 96NN 359922.00 7607.64 2.1 352314.36 403724.50 184586.29 45.7 219138.21 ACTIVITY TOTAL 1207761.00 214503.93 17.8 993257.07 1033056.58 603794.35 58.4 429262.23 TOT A L EXPENDITURES 17824265.00 6667629.78 37.4 11156635.22 15429391.19 5875100.98 38.1 9554290.21 EXCESS <REVENUE>EXPENDITURES 96838.25- 2279139.11~ 2353.6 2182300.86 2009083.67- 1630914.20- 81.2 378169.47~ TRANSFERS IN FROM OTHER FUNDS .00 10785.46~ 10785.46 5017.54~ .00 5017.54- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 4211. 16 .00 4211.16 EXCESS <REVENUE> EXPENDITURE 96838.25- 2289924.57- 2364.7 2193086.32 2009950.05~ 1630914.20~ 81.1 379035.85' . 1 ~ /:= GL1 O4C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 1/13/98 REVENUES VERSUS EXPENDITURE 16.55.55 FOR THE PERIoo 7197 THROOGH 11,197 . .. SPECIAL REVENUE FUNDS .' aJRRENT PER I 00 PREVIOUS YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCENT VARIANCE ' ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T~D ~ ; ~ ~ ~ ~ ~ 6 6 6 R:EVENUES*"'***** PROPERTY TAXES 71500.00- 37965.32- 53.1 - 33534.68- .00 .00 .00 : ~ SALES TAX 159300.00- 82108.65- 51.5 77191.35- 152122.48- 60456.76- 39.7 91665.72- FINES & FORFEITURES 25000.00~ 12733.91- 50.9 12266.09- 22506.62- 10027.83- 44.6 12478.79- USES OF MONEY AND PROPERTY 78560.00- .00 78560.00- 98044.39- .00 98044.39- " INTERNGOVERNMENTAL FROM STATE 740859.00- 333069.78- 45.0 407789.22- 611716.48- 323343.21- 52.9 288373.27- INTERGOVERNMENTAL FROM COUNTY 141460.00- 54492.00- 38.5 86968.00- 143136.00- 55362.00- 38.7 8m4.oo- INTERGOVERNMENTAL FROM FEDERAL 464889_00- 10736.26- 2.3 454152.74- 185082.30- .00 185082.30- ..1'. ~r, CHARGES FOR SERVI CES 739000_00- 347338.67- 47.0 391661.33- 7BB267.59~ 391448.04- 49.7 396819.55- .... . ,- OTHER SWRCES OF REVENUE 218000.00- .00 218000.0o~ 311205.00- 23894.00- 7.7 287311. 00- ~7;;. TOT A~ REVENUE 2638568.00- 878444.59- 33.3 1760123.41- 2312080.86- 864531.84- 37.4 1447549.02- . ---EXPEND I TURES--- GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC 'SAFETY: POll CE 93845.00 21215.39 22.6 72629.61 63146.44 378.88 .6 62767.56 TRAFFIC SIGNALS 108150.00 29351.70 27.1 78798.30 78617.71 25129.82 32.0 53487.89 FIRE SERVICES 75960.00 37965.32 50.0 37994.68 .00 .00 .00 ACTIVITY TOTAL 277955.00 88532.41 31.9 189422.59 141764.15 25508.70 18.0 11.5 TRANSPORTATION: PUBLIC 1JQRk:S .00 .00 .00 172.47 .00 172.47 STREET MAINTENANCE 208910.00 52427.51 25.1 156482.49 213347.82 39951.25 18.7 173396.57 STREET SWEEPING 80600.00 31158.51 38.7 49441.49 67675.22 23748.74 35.1 43926.48 ACTI VITY TOTAL 289510.00 83586.02 28.9 205923.98 281195.51 63699.99 22.7 217495 .52 HEALTH & ~LFARE: WASTE MANAGEMENT 808166.00 367987.53 45.5 440178.47 718827.72 19782.25 2.8 699045.47 ACTIVITY TOTAL 808166.00 367987.53 45.5 440178.47 718827.72 19782.25 2.8 699045.47 CULTURE & LEISURE SERVICES: PARk: MAINTENANCE .00 .00 .00 7154.10 .00 7154.10 ACTIVITY TOTAL .00 .00 .00 7191.46 .00 7191.46 COMMUNITY DEVELOPMENT: ENGINEERING 88120.00 11073.46 12.6 77046.54 88980.07 20636.83 23.2 68343.24 ACTIVITY TOTAL 88120.00 11073.46 12.6 77046.54 88980.07 20636.83 23.2 68343.24 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 250983.00 53881.74 21.5 197101.26 140454.07 .00 140454.07 PARI::S 219102.23 87334.08 39.9 131768.15 443937.09 22018.12 5.0 421918.97 STREET CONSTRUCTION/IMPROVMT 766610.00 31663.07 4.1 734946.93 353418.05 223769.39 63.3 129648.66 ACTIVITY TOTAL 1236695.23 172878.89 14.0 1063816.34 937809.21 245787.51 26.2 692021.70 TOT A L EXPENDITURES 2707491.23 727016.63 26.9 1980474.60 2175768.12 375415.28 17.3 1800352.84 EXCESS <REVENUE>EXPENOITURE 68923.23 151427.96- 219.7- 220351. 19 136312.74- 489116.56- 358.8 352803.82 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 3395.00 .00 3395.00 EXCESS <REVENUE> EXPENDITURE 68923.23 151427.96- 219.7~ 220351.19 132917.74~ 489116.56- 368.0 356198.82 . ~ /. I X l.-t\ I 0 ~. (....' GL1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 1/13/98 REVENUES VERSUS EXPENDITURE 17.04.41 FOR THE . PERI ell 7/97 THROUGH 12(97. "' SPECIAL ASSESSMENT FUNDS .' CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE" ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D : t ........REVENUES******* ;. SPECIAl BENEFITS ASSESSMENTS 274407. DO- 128321.78- 46.8 146085.22- 243986.94- 120678.07- 49.5 123308.87- k USES OF MONEY AND PROPERTY 13395.00- .00 13395.00- 18795.26- 1672.49- 8.9 17122.77- : OTHER SOURCES OF REVENUE 2000.00- .00 2000.00- .00 .00 .00 " TOTAL REVENUE 289802.00- 128321.78- 44.3 161480.22- 262782.20- 122350.56- 46.6 140431.64- ~. . :.*******EXPENDITURES******* '~. GENERAL GOVERNMENT ACTIVITIES; >. ! ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 ~ PUBLIC ~AFETY; TRFe SIGS/STREET LIGHTING 121705.00 36046.00 29.6 85659.00 103293.98 28823.38 27.9 74470.60 ACTIVITY TOTAL 121705.00 36046.00 29.6 85659.00 103293.98 28823 .38 27.9 74470.60 TRANSPORTATION; PUBLIC \JOR($ 1300.00 1562.01 120.2 262.01- 4247.66 1389.71 32.7 2857.95 STREET TREE MAINTENANCE 11410.00 1992.26 17.5 9417.74 5697.32 1087.46 19.1 4609.86 STREET LANDSCAPE MAINTENANCE 139420.00 59549.83 42.7 79870.17 138868.81 36746.67 26.5 102122.14 ACTIVITY TOTAL 152130.00 63104.10 41.5 89025.90 148813.79 39223.84 26.4 109589.95 HEALTH & ~LFARE; CULTURE & LEISURE SERVICES; ~NITY DEVELOPMENT; GINEERING 4650.00 3465.00 74.5 1185.00 3185.96 3023.44 94.9 162.52 ACTIVITY TOTAL 4650.00 3465.00 74.5 1185.00 3185.96 3023.44 94.9 162.52 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 31815.00 7815.00 24.6 24000.00 16488.87 8067.92 48.9 8420.95 STREET CONSTRUCTION/IMPROVMT 47438.00 .00 47438.00 103000.00 103106.75 100.1 106.75- ACTIVITY TOTAL 79253.00 7815.00 9.9 71438.00 119488.87 111174.67 93.0 8314.20 TOT A L EXPENDITURES 35m8.00 110430.10 30.9 247307.90 374782.60 182245.33 48.6 192537.27 EXCESS<REVENUE>EXPENDITURE 67936.00 17891.68- 26.3- 85827.68 112000.40 59894.77 53.5 52105.63 EXCESS <REVENUE> EXPENDITURE 67936.00 17891.68- 26.3- 85827.68 112000.40 59894.77 53.5 52105.63 . :f 7' ~ GL 104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 1/13/98 REVENUES VERSUS EXPENDITURE 17.21.28 FOR THE PERI 00 7(97 THROUGH 12/97, .- . CAP IT AL IMPROVEMENT FUND .' CURRENT PERIOO PREV10US YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCENT VARIANCE -_, ACTUAL . ACTUAL PERCENT VARIANCE FISCAL YR Y-T-O AAAAAAA'REVEHUES******* t OTHER SOURCES OF REVENUE 2889412.00- 51796.03- 1.8 2837615.97- 328497.84- 70429.55- 21.4 258068.29- !' TOTAL REVENUE 2889412.00- 51796.03- 1.8 2837615.97- 328497.84- 70429.55- 21.4 258068.29- ~ *-EXPENDITURES---* ; \ GENERAL GOVERNMENT ACTIVITIES: I PUBLIC SAFETY: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 ~ TRANSPORTATION: .- , HEALTH It ~LFARE: , CULTURE" LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 100000.00 17421.55 17.4 82578.45 12823.75 5938.75 46.3 6885.00 COMMUNITY IMPROVEMENTS 19000.00 180.00 .9 18820.00 .00 .00 .00 PARKS- 239460.00 9168.78 3.8 230291.22 .00 .00 .00 STREET CONSTRUCTION/IMPROVMT 2515167.00 49525.00 2.0 2465642.00 449732.20 246147.44 54.7 203584.76 ACTIVITY TOTAL 2873627.00 76295.33 2.7 2797331.67 462555.95 252086.19 54.5 210469.76 TOT A L EXPENDITURES 2873627.00 76295.33 2.7 2797331.67 462555.95 252086.19 54.5 21~ EXCESS<REVENUE>EXPENDI TURE 15785.00- 24499 .30 155.2- 40284.30- 134058.11 181656.64 135.5 \ . 4 TRANSFERS OUT TO OTHER FUNDS .00 10785.46 10785.46- 1682.54 .00 EXCESS <REVENUE> EXPENDITURE 15785.00- 35284.76 223.5- 51069.76- 135740.65 181656.64 133.8 45915.99- . /6 ~ I b GL 104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 1/13/98 REVENUES VERSUS EXPENDITURE 17.25.53 FOR THE . PERIOO 7/97 THROUGH 12/97' TRUST/AGENCY FUND. CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCENT VARIANC!= . ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y.T-D .......aREVENUE~....... ~. SPECIAL BENEFITS ASSESSMENTS .00 117248.56- 117248.56 236036.28- 117654.79- 49.8 118381.49- t USES OF MONEY AND PROPERTY .Do 3479.31- 3479_31 11962.96- 2690.94- 22.5 9272.02- j r TOTAL REVENUE .00 120727.87- 120727.87 247999.24. 120345.73- 48.5 127653.51- ;' --EXPENDITURES.u".. } GENERAL GOVERNMENT ACTIVITIES ;" NON-DEPARTMENTAL .00 156154.75 156154.75- 232469.50 153314.75 66.0 79154.75 " ~ ACTIVITY TOTAL .00 156154.75 156154.75- 232469.50 153314.75 66.0 79154.75 ~ I'UBLIl;. ~AFETY: . TRANSpoRTATION: HEAlTH & ~LFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL, IMPROVEMENT pROJECTS: TOTAL EXPENDITURES .00 156154.75 156154.75- 232469.50 153314.75 66.0 79154.75 EXCESS(REVENUE)EXPENDITURE .00 35426.88 35426.88- 15529.74- 32969.02 212.3- 48498.76- EXCESS (REVENUE) EXPENDITURE .00 35426.88 35426.88- 15529.74- 32969.02 212.3- 48498.76- . . 1/ ci')b '. .," GL 104C THE CITY OF DUBLIN STATEMENT SHOVING PAGE 1/13/98 REVENUES VERSUS EXPENDITURE 17.11.' FOR THE PERIOO 7/97 THROUGH 12/97 . .. INTERNAL SERVICE FUND CURRENT PERIOD PREV.IOUS YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCENT VARIANCE .- ACTUAL ACTUAL PERCENT VARIANCE FI SCAl YR Y.T.D " ----..REVENUES--....... .; USES OF HONEY AND PROPERTY 13750.00- .00 13750.00- 18137.65- .00 18137.65- ~~ CHARGES FOR SERVICES 243411.00- 121297.84- 49.8 122113.16- 211049.81- 101779.68- 48.2 109270.13- '~ OTHER SOORCES OF REVENUE 500.00- 50.00- 10.0 450.00- 21901.75. 1072.70- 4.9 20829.05- ,'. --E TOTAL REVENUE 257661.00- 121347.84- 47.1 136313.16- 251089.21- 102852.38- 41.0 148236.83- ." 'i" ................*EXPEND I TURES.............. 2t GENERAL GOVERNMENT ACTIVITIES: ~"-" :"'-" NON-DEPARTMENTAL 266250.00 60554.67 22.7 205695.33 262014.45 89906.46 34.3 172107.99 " ACTIVITY TOTAL 266250.00 60554.67 22.7 205695.33 262014.45 89906.46 34.3 172107.99 .; , PUBLIC 'sAFETY: TRANSPORTATION: HEALTH & ~lFARE: CULTURE & lEISURE SERVICES: CtJKINITY DEVELOPMENT: CAPITAL' IMPROVEMENT PROJECTS: TOT A l EXPENDITURES 266250.00 60554.67 22.7 205695.33 262014.45 89906.46 34.3 172107.99 EXCESS<REVENUE>EXPENDI TURE 8589.00 60793.17- 707.8- 69382.17 10925 .24 12945.92- 118.5- 23871.16 EXCESS <REVENUE> EXPENDITURE 8589.00 60793.17- 707.8- 69382.17 10925.24 12945.92- 118.5- 23. . iJ- <J .'"c> ..; ~ . ~ ' ". . ~ GL 1041: THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 1/13/98 REVENUES VERSUS EXPENDITURE 17.16.39 FOR THE e PERIOO .7/97 THROUGH 12/97 ENTERPRISE FUNDS CURRENT PERlOO PREV_OUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE: ACTUAL' ACTUAL PERCENT VARIANCE FI SCAL YR Y-T-D ..........REVENUES---- : USES OF MONEY AND PROPERTY 1708264.00- 368354.65- 21.6 1339909.35- 1592321.83- 395544.83- 24.8 1196m.OO- ~ TOTAL REVENUE 1708264.00- 368354.65- 21.6 1339909.35- 1592321.83- 395544.83- 24.8 1196m.00- ; f .......EXPENDlTURES....... >: . GENERAL GOVERNMENT ACTIVITIES: ~ t NON-DEPARTMENTAL 1599939.00 69132.29 4.3 153D806.71 1314726.23 71616.84 5.4 1243109.39 t, ADMIN SERVICES 4260.00 1050.00 24.6 3210.00 4194.20 1000.00 23.8 3194.20 t ACTIVITY TOTAL 1604199.00 70182.29 . 4.4 1534016.71 1318920.43 72616.84 5.5 1246303.59 ~. PUBLlC{SAFETY: : TRANspoRTATION: ; HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: , TOT A'L EXPENDITURES 1604199.00 70182.29 4.4 1534016.71 1318920.43 72616.84 5.5 1246303.59 EXCESS<REVENUE>EXPENDI TURES 104065.00- 298172.36- 286.5 194101.36 273401.40- 322921.99- 118.1 49526.59 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 4211. 16- .00 4211.16- eESS <REVENUE> EXPENDITURE 104065.00- 298172.36- 286.5 194101.36 271612.56- 322927.99- 116.3 45315.43 e '" ./.' /:;.oz> ,<=:> CITY OF DUBLIN BUDGET CHANGE FORM CHANGE FORM # New Appropriations (City Council Approval Required): 'Budget, Transfers: " . _~ From Unappropriated Reserves From Budgeted Contingent Reserve (1080-799.000) Within,Same Department Activity X From New Revenues Between Departments (City Council Approval Required) Other ~:::ig:~:n.~~"iii;::--*'L<iD::lDo~""'5"~~~T~f&<:"Th:l$i:t1':>l"'"\i'l!i6Ji;~;u.w~"'ill-'fi'f~~:l':6~~Qtit~;l;-;;mnh~~:;:::~:::*f<:,"t'@?~":ti~'t~rw: ~:';...':'--;-;UA:"~D:~W~b;J;=::a.~~w.n::.&::':-=--~~;:;:::",>>">>,';+;':i~~~~J.~:al.m*~"f<::1.~~~6...ft;J:!;[ft.OA:aW~. . ~~~-wu:t~:J;::-:--":-:-:::,:-:::;--'@~!~U:~~~?!.~m<<@ \'~ .....-- -....... n.....____. .-.-.-.--.-.-.":".".-,-.-.-.-.-." . - -. ........................-........':f........-.........-..:.......:.....:.....:...........,..:.:.....~:-:.:.x. ,.......;.,........,....-....:. .-.......-....,..-................. ...............,...... ....,................-.....-_._....._..._..._._.......~.~.:.:.~. _:. ..~.'. .'. :.... ................."...,.:.,.....:......., ,...... .., , . ----------...--..---.--....--.. __._____n_.._...______...___.. Name: Name: General Fund City Council - Community Promotion $ 2,500 Account #: Account #: 001-1010-731-000 Name: Name: REVENUE - Charge For Services Recreation Classes REVENUE Account #: $ 50,000 <. Account #: 001-1000-565-010 . Name: Name: General Fund - ~ecreation Instruction - Contract Services $ 35,000 Account #: Account #: 001-8090-740-000 Name: Name: General Fund - Aquatics - Repairs & Maintenance $ 4,000 Account #: Account #: 001-8100-718-000 ..y~ ; -~~ 1;" City Manager: Date: Signature REASON FOR BUDGET CHANGE ENTRY: Mid Year Review of General Fund Activities as presented in the Staff Report City Council Meeting February 3, 1998. (See Also Subsequent Pages) ............, ." . ........ ..... , ..... .... ..,.... ............... ..... -........ ............ ...................,. . ,., .,.."..... ."., ',,, ','.......,....,'.. .. ',":::':':'~~'!}.jiPE9Yfili',,~~m~,R!~ggJffi9l,~~gg,g#~: :p~t~':i: ",.2/31Qs?:i ..............-.................................................................................... ...... ................................... Mayor: Date: Signature Posted By: Date: Signature . ~ EXHIBIT 4 (pAGE 1 of3) /IJ ".{ ! b 7 :J . ., . f . . CITY OF DUBLIN MID- YEAR BUDGET CHANGE FORM-PAGE 2 u'*">>n~JrBt.ttiGE1fAl!rtQ'UNCr_~~m'*1l1f.~~mitlr"'-"'<<<'"W"'W.'.w_OVNll'~""# ,:",,*,~:~ : -- .' , , .__.:_:___)::._._::_.._~.:..:~~.:: ,':'. ~ ._..~.):....~;f.*~~:;::::~...:~. ". _-:-::_-::_-.:.._..'x.~ ~;'::~:.::ft.~~::~~::...:..:....:..:;::.......:.....~. _.:..:._.. .~..... .:..;:.: -.:_.:...::......,.:.::.,_:~/-:-.:...-:::::..::::.:..::.::...~:.::..::~.:::...jlff\11i~~~1iiI:::..~:....:..,.,.,::.,.;...:._..-.::J...,i;~~k) :::::::::~~:::;.:: .'..:.....,.'...... ..........................-...- ..-..:.......,.......... .' Name: Name: REVENUE - General Fund Other Revenues Contribution .' ., $ 650 Account #: .' REVENUE , '. Account #: 601-1O00-570~002 Name: Name: General Fund Sr Center ~ Operating Supplies Account #: $ 210 Account #: 001-8080-713-000 Name: Name: General Fund Sr Center - Furniture & Fixtures $ 150 Account #: Account#:001-8080-750~1 Name: General Fund Sr Center - Equipment $ 290 Account #: 001-8080-750-071 t Name: Name: REVENUE - General Fund Zoning & Subdivision Fees $ 207,500 Account #: Account#: 001-1000-565~00l REVENUE Name: Name: REVENUE ~ General Fund Engineering Plan Check Fees $ 250,000 Account #: Account #: 001-1000-565~002 REVENUE Name: Name: General Fund - Legal Services ~ Professional Services Reimbursable $ 48,000 Account #: Account #: 001~1030.729-003 Name: Name: General Fund ~ Planning ~ Professional Services Reimbursable $ 118,000 Account #: Account #: 00 1-90 1O-729~003 Name: Name: General Fund ~ Engineering- Contract Services Private Development $ 200,000 Account #: Account #: 001-9030~740-072 Name: Name: General Fund - Internet Access Project Machinery & Equipment $ 2,400 Account #: Account #: 001~9321-750~072 EXHIBIT 4 (page 2 of 3) /5 :f 16 ;. CITY OF DUBLIN ,MID- YEAR BUDGET CHANGE FORM ~PAGE 3 . ~l;~~__~_OTa&1t.&i_MllC1tR$ltBDamxc<<omt1Wl%fHdYm&tlSTM~ \. ,-- ____..n_...'..._.....' ".-.-.-..."........-......'.....,.......,.,... .............................,..........,.............................................................,........................,.,.,.,...-.-.....,.,.,.__.......".-.....-...-....,..-......,.........................,.....,.....,...,..............................,......-....,..-.......... ---.----....----........--. n.___"'__...__...._____"_ . . _......__........... ____n ......____.... ____. n.. , . . Name: REVENUE - General Fund- Taxes Other Than Property - SALES TAX $ 300,000 REVENUE Account #: 001-1000-520-015 Name: REVENUE - General Fund- Taxes Other Than Property - Real Prop. Transfer Tax $ 75,000 REVENUE Account #: 001-1000-520-017 Name: REVENUE - General Fund- Taxes t Other Than Property - Transient Occ Tax $ 50,000 REVENUE Account #: 001-1000-520-018 Name: REVENUE - General Fund- Use of Money & Property (Interest) $ 100,000 REVENUE Account #: 001-1000-550-001 Name: REVENUE - General Fund - . Intergovernmental < 11,000 > Motor Vehicle In Lieu Fee REVENUE Account #: 001-1000-555-001 Name: REVENUE - General Fund - Taxes Other Than Property . < 4,500 > Cable Television Franchise Tax REVENUE Account #: 00i-1000-520-023 Name: REVENUE - General Fund - Miscellaneous Other Revenue - < 50,000 > Sale of Property REVENUE Account #: 001-1000-570-001 h. t': (' EXHIBIT 4 (page 3 of 3) . It ~ / 6