Loading...
HomeMy WebLinkAbout4.02 FinStatmnts&AuditRpt CITY OF DUBLIN AGENDA STATEMENT CITY COUNCIL MEETING DATE: January 11 , 1993 SUBJECT: Fiscal Year 1991-92 Financial Statements an. A dit Report (Prepared by: Stanley Stephens, Jr. ) Ago EXHIBITS ATTACHED: Exhibit 1 : Comprehensive Annual Financial Report, June 30, 1992 Exhibit 2: Financial Report (Final) , June 30, 1992 Exhibit 3: 7 Schedule of Supplemental Appropriations, FY 1991-92 RECOMMENDATION: Receive the June 30, 1992 Comprehensive Annual Financial Report with Auditor's Report thereon; Receive `�~� the final June 30, 1992 (monthly) Financial Report; and Authorize the year end supplemental appropriations described in Exhibit 3. FINANCIAL STATEMENT: See Below. DESCRIPTION: The City of Dublin has compiled and published its Comprehensive Annual Financial Report (CAFR) for the fiscal year ending June 30, 1992 on which the Auditors, Maze and Associates, have issued an unqualified opinion. The Auditors met with the Audit Committee on December 8, 1992 to discuss the CAFR and the City's financial operations. It is worth noting that the Auditors issued no Management Letter this year since their Audit disclosed no matters which required corrective action (i.e. internal controls, errors, or irregularities) . The Letter of Transmittal, starting on page 1 of the CAFR, provides an excellent overview of the CAFR's contents, as well as highlights of a number of other important areas. Last year's CAFR received awards from both national and California professional organizations based on their stringent peer review programs. (See pages 12 and 13. ) We have submitted the 1992 CAFR for similar reviews and fully expect to receive the awards again. Our monthly in-house Financial Report for June 30, 1992 is submitted in "final" form and includes all adjustments required in closing the books and preparation of the CAFR. In this process, certain expenditures were recorded (or had been recorded during the regular accounting process) which exceeded the budgeted appropriations adopted by the City Council. Exhibit 3 lists those overexpended appropriations, by fund and department/function, with comments on all material variances. The General Fund had five such variances totaling $17,788, related to various operating activities. One capital improvement fund had no current year appropriations, but all expenditures had been authorized by the City Council and appropriated in the previous Fiscal Year (FY 1990/91 ) . Finally, two assessment districts exceeded their original appropriations, by department; however, sufficient uncommitted departmental appropriations or fund balances were available for all expenditures over appropriated amounts. Staff recommends that the City Council approve appropriation changes as listed on Exhibit 3 attached. a:111$rpt.agenda#11 COPIES TO: X A22/ X30 50 ITEM NO. 42 CITY CLERK FILE I 3 / 10 -13.0 City of Dublin California Compreli e-nsive Annual Financial Report For Fiscal Year Ended June 30, 1992 EMT CITY OF DUBLIN DUBLIN, CALIFORNIA COMPREHENSIVE ANNUAL FINANCIAL REPORT . . FOR THE YEARS ENDED JUNE 30, 1992 AND JUNE 30, 1991 • . • Prepared by DEPARTMENT OF FINANCE (This Page Left Blank Intentionally) INTRODUCTORY SECTION I__ CITY OF DUBLIN Comprehensive Annual Financial Report For the Years Ended June 30, 1992 and 1991 Table of Contents Pagc INTRODUCTORY SECTION Table of Contents i Letter of Transmittal 1 Elected Officials and Administration Personnel 10 Organization Chart of Major City Activities 11 GFOA Certificate of Achievement for Excellence in Financial Reporting 12 CSMFO Certificate of Award for Outstanding Financial Reporting 13 FINANCIAL SECTION . Independent Auditor's Report 17 General Purpose Financial Statements Combined Balance Sheets-All Fund Types and Account Groups 20 Combined Statements of Revenues,Expenditures and Changes in Fund Balances-All Governmental Fund Types 23 Combined Statement of Revenues,Expenditures and Changes in Fund Balances-Budget and Actual- General,Special Revenue and Capital Projects Fund Types 24 Combined Statements of Revenues,Expenses and Changes in Fund.Equity-All Proprietary Fund Types 26 Combined Statements of Cash Flows-All Proprietary Fund Types 27 Notes to General Purpose Financial Statements 28 CITY OF DUBLIN Comprehensive Annual Financial Report For the Years Ended June 30, 1992 and 1991 Table of Contents Page Combining Fund Statements and Schedules General Fund Comparative Balance Sheets 49 Statements of Revenues,Expenditures and Changes in Fund Balance-Budget and Actual 50 Schedule of Budget Versus Actual Departmental Expenditures 51 Special Revenue Funds Combining Balance Sheets 54 _ - Combining Statements of Revenues,Expenditures and Changes in Fund Balances 56 Combining Statement of Revenues,Expenditures and Changes in Fund Balances-Budget and Actual 58 Schedule of Budget Versus Actual Departmental Expenditures 64 Capital Projects Funds Combining Balance Sheets 66 Combining Statements of Revenues,Expenditures and Changes in Fund Balances 67 Combining Statement of Revenues,Expenditures and Changes in Fund Balances-Budget and Actual 68 Schedule of Budget Versus Actual Departmental Expenditures 70 Agency Funds Combining Statement of Changes in Assets and Liabilities 72 CITY OF DUBLIN Comprehensive Annual Financial Report For the Years Ended June 30, 1992 and 1991 Table of Contents PUG STATISTICAL SECTION Governmental Expenditures by Function-All Governmental Fund Types-Last Ten Fiscal Years 75 General Governmental Revenues by Source-All Governmental Fund Types-Last Ten Fiscal Years 76 Assessed and Estimated Actual Value of Taxable Property-Last Ten Fiscal Years 77 Property Tax Rates-All Overlapping Governments-Last Ten Fiscal Years 78 Computation of Legal Debt Margin 79 • Computation of Direct and Overlapping Debt 80 Demographic Statistics-Last Ten.Fiscal Years 81 Property Value,Construction,and Bank Deposits -Last Ten Fiscal Years 82 Miscellaneous Statistical Data 83 Schedule of 1985 Certificates of Participation Coverage-Fiscal Years 1985-1988 84 - Schedule of 1988 Certificates of Participation Coverage-Last Five Fiscal Years 85 California Public Employees Retirement System Funding Analysis-Fiscal Years 1986-1992 86 Property Tax Levies and Collections- Last Nine Fiscal Years 87 Principal Taxpayers 88 111 OF �P' 82 CITY OF DUBLIN "Celebrating 10 Years Of Cityhood 1982-1992" �� <�s� P.O. Box 2340, Dublin, California 94568 • City Offices, 100 Civic Plaza, Dublin, California 94568 To the Honorable Mayor, November 13, 1992 Members of the City Council , and City Manager • City of- Dublin, California Transmittal Letter Introduction This is the Comprehensive Annual Financial Report for the City of Dublin -for the year ended June 30, 1992. The responsibility for the accuracy, completeness, and fairness of the material presented in this report rests with the City The report is prepared in conformance with the guidelines of the Government Finance Officers Association, and the governmental accounting requirements of the American - Institute of Certified Public Accountants. This report fairly presents in all material respects the financial position, results of operations and the current economic environment of the City of Dublin. Report Format- - The Introductory Section provides narrative information about the City's , background, important recent activities and the management organization structure. The narrative material- appears within the Transmittal letter. Also included are the directory of City Officials, and the organization chart. The Financial Section contains the audited financial -statements, and the opinion of the City's Independent Auditors concerning the fairness of the informati-on in the financial statements. The Statistical Section provides historical and perspective information about the City's financial , economic and industrial environment. . The Reporting Entity Dublin is a_ General Law City. It was incorporated in the State of California in February 1982., Dublin is referred to as a contract city, because many of the common municipal functions are provided through contracts with both private companies and other governmental agencies. The City's police services, for • example, are provided through a contract with. the Alameda County Sheriff's Department. The street maintenance services and park maintenance. services are - currently provided by contracts with MCE Corporation. City engineering services are augmented with off-site engineers provided by Santina & Thompson Inc. The Planning Department depends heavily on assistance from private . contracted help from professional planners to provide the additional services ' required for land use development. The City established a separate legal entity called Dublin Information Inc. , which is included in the reporting entity. This non-profit entity was created to assist in reducing the postage cost of mailing the City's periodic newsletters, 1 Administration (510) 833-6650•City Council (510) 833-6605• Finance (510) 833-6640•.Building Inspection (510)833-6620 Code Enforcement(510) 833-6620 • Engineering (510) 833-6630 • Planning (510) 833-6610 - Police (510) 833-6670 • Public Works(510) 833-6630 • Recreation (510)833-6645 • calendars and recreation brochures. The entity's functions were expanded after the first few _years of operations, when the City Council realized that the - growth in the City coupled with the corresponding growth in City staff, plus the desire to provide the City with its own identity, required_the construction of a 53,000 square foot Civic Center. Certificates-of-Participation were issued for construction of the Center by Dublin Information Inc. , the municipal conduit for administering the debt service on the long term instruments. The City administration, which occupies the Civic Center, uses General Fund resources to pay for rental space from Dublin Information Inc. on a year-by-year basis. -- After Dublin acquired the responsibility for fire suppression services as well as park maintenance services from the Dublin San Ramon Services District (DSRSD) the City also received the allotment of property tax revenue, which was previously assigned to DSRSD. Because the district previously provided fire suppression services to both the cities of San Ramon and Dublin, the two cities formed a joint powers authority to maintain the integrity of the fire services. Each city makes payments for its pro-rata share for the amount of the operating and maintenance costs of the authority. Economic Conditions The City is located at the crossroads of two main thoroughfares: Interstate 680 and Interstate 580. This has helped to generate a healthy financial climate for the City. However, the Tri-Valley area, which includes the cities of Dublin, Pleasanton, San Ramon and Livermore, has recently noticed the impact of the recession. City of Dublin Percentage Sales Tax Revenue Generated GENERAL MERCHANDISE DRUG & FOOD STORES 10`%� CAR DEALERS FRS 20% RESTAURANTS 5% - • 11% `l 30% AFFLIANCE STORES 14 LIGI-IT INDUSTRY OTHER BUSI. TYPES SERVICE STATIONS SOURCE CALIFORNIA STATE BOARD OF EQUALIZATION 2 COMPARISON OF PER CAPITA TAXABLE SALES City of Dublin and three surrounding communities Dublin Pop 76,160 Pleasanton Pep 07,000 '+'•"'—�' S�Se:.�s 'G!6 • r f jj:% jbes: San Ramon ��� %/��%�� Pop 76,700 I • Livermore Pop 60,+00 j !%%���'� $0 $5 $10 $15 $20 $25 Thousands En annual data More than most California cities, Dublin's operating funds rely heavily on Sales Tax revenue. There were 835 retail establishments reporting sales taxable transactions within the Dublin point-of-sales area for the most recent quarter reported. The top twenty sales tax revenue generators for the most current quarter produced over 55% of the total taxable sales transactions for that quarter, which is down 4% from the same quarter last year. Yet within the last four quarters only three of the top twenty businesses ever ranked below the top twenty; these factors show the economic impact of the recession on the City. Furthermore, sales tax revenues have been fairly flat over the last three years as witnessed from the graphs below: CITY OF DUBLIN TOTAL TAXABLE SALES BY QUARTER ACTUAL DATA AND TREND EVALUATION Millions $160 $140 - - _ - . -._ . :__..._ - ...... $120 - $80 $60 - - - $4 0 - - -- ----- - -- . _. - .. ._ $20 - $0 I i I i I I I I I I 1 I I I I I I I I I I I I I I I I I I I 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1984 85 86 87 88 89 90 91 3 The five largest employers in the City are listed below: Hexcel : Manufactures honey comb material for the space and aerospace industry. SmithKline Beecham Clinical Laboratories: Medical testing of patient specimens. Lucky Stores, Inc. : Headquarters offices for grocery retailers. Unisource: Wholesale distributor of paper & packaging -- products. Target Stores Inc. : Retail Store (Source City 91-92 business license database) Major Departmental Initiatives City Manager: The City Manager is appointed by the five member City, Council . The daily operation of the City is handled by six department heads, who report directly to the City Manager. Also included in the City's management structure is the Fire Chief; even though he does not work directly for the City, the fire chief participates in the management structure of the City. Planning Department: The Planning Department has guided the development of Dublin from the 4.1 square mile town in 1980 to the present 9 square mile city. Recent development studies point to the fact that Dublin will grow in both east and west directions to cover approximately 23 square miles with a population of between 55,000 and 85,000 by the year 2015. This year the Department has been pro-active in preparing preliminary plans for the ultimate annexation of 10.8 square miles called the Eastern Dublin Area. Negotiations are also underway between the County and the City for mutually acceptable development on County property, _ which lies between the City's current developed area and the City's eastern boundary. This development agreement is necessary to the viability of the annexation of the Eastern Dublin Area. Recreation: Since 1986 the City has made major improvements to four parks totaling 18.74 acres. These improvements included picnic areas, children's playgrounds, walk ways, and general landscaping. Other capital renovations to the Nielson and Cronin School Playgrounds, installation of a playground for handicapped children at the municipal Kolb Park, and the Development of a Parks and Recreation Master Plan were also undertaken. The City also made other major improvements to the Senior Center, Shannon Park, and Shannon Community Center. Public Works: The City completed the formation of the Dublin Boulevard Assessment District to help fund the extension of Dublin Boulevard to the eastern City boundaries. The first phase of the project began in fiscal year 91-92 and is expected to be completed in fiscal year 92-93. 4 w I The second phase of the project will start in 92-93. This phase will tie the easterly-portion of the first phase to Tassajara Road. Agreements have been reached to have the southern. neighboring City of Pleasanton lend Dublin the cost for the road construction. The San Ramon Road Improvements program was completed in 1991-92. The improvement of San Ramon Road from two to four lanes provides a better and - faster access to the community along the south to north corridor. paralleling Interstate 680. The City used a phasing concept for these improvements too, and the first phase of this project was bid in 1986,. Finance/Treasurer: : The Finance Department is responsible for payroll and accounts payable processing, accounts receivable invoicing and collections, business license administration, the treasury investment functions, monthly financial statement preparation and computer operations. Monthly financial reports are submitted` to the Council . Financial Information Internal. Control : . The. City Management is responsible for est ablishing the methods employed by the City to safeguard its assets, to ensure the reliability of the accounting data, to promote more efficient operations, and to ensure compliance with the City's established policies. The management uses both administrative and accounting controls to fulfill that responsibility. The Finance Department is responsible _ for establishing the account'in'g controls used for the City. To the, extent possible and within the limits of the staffing size, the accounting department has segregated duties between the custody and the accountability of City assets. The tasks associated with accounts payable are placed in the hands of a different 'accounting staff person than those connected with accounts receivable and cash.. management.. But, even when staffing limitations demand that a task reside primarily in the hands of one person, the accounting system is set up; so that another staff's approval is necessary before the task is completed. Thus, for example, the City's use of the Federal wire transfer system for investments can only be completed after two signatures of approval are obtained from either the City Manager, City Clerk, or Treasurer: 5 Budgetary Control: Each year the City Manager develops and presents the budget document, and the Council adopts the budget, which includes both operating programs and capital improvement projects. The Council approves the budget on .a departmental basis and the staff identifies the funding sources. The City Manager is authorized through the accounting procedures to transfer budget amounts between line items within the same department during the year. The City staff uses the real time on-line computer budget system to determine the remaining budget balances before submitting purchase requests. Purchases exceeding $200 are accomplished by use of purchase orders, while purchases exceeding $5,000 require that a formal bidding process be performed to determine the vendor. The accounting staff reviews the purchase request for small item purchases, purchase orders, and bid results for accuracy and sufficiency of budget balances. Risk Management The City of Dublin is a member of the ' ABAG PLAN Corporation; a self insured, public entity for general liability pool . This is a general liability insurance, which includes automobile liability. The coverage amount is $5 million per occurrence. The term of the coverage is July 1991 to June 1992 with a renewal date of July 1992 to June 1993. The City records the liability for claims and judgements when the amount of the loss can be estimated and when the loss is probable. Cash Management The City Treasurer manages the amount of idle cash for the City by purchasing various investment instruments. The invested portfolio averaged almost $16.4 million in size for the year. The yield for the year was 6.87% based upon the average monthly investment portfolio. The City's investment process takes into, consideration in order ' of importance: 1. the safety of the principal amount invested, 2. liquidity "so that the maturity of the investments are consistent ' with future projected cash requirements, 3. the maximum earnings possible, 4. the provision for maximum diversification within the same industry, and_5. the liquidity of the instrument consistent with the cash flow needs of the City. To maximize the City's earnings while maintaining all other investment criteria under a year of rapidly decreasing interest rates, the Treasurer extended the • portfolio's average term and yield by purchasing Federal Agency Notes or Debentures with prices as close to par as possible, and also increased the amount invested with the State's Local Agency Investment Pool . There were 6 investment instruments purchased as of June 30, 1992. The largest single amount invested by the City was in the State. Treasurer's investment pool, which totaled $17,186,000. The other five items were Federal Agency debentures . and totaled $2,013,171.88. 6 • • Financial Statement Analysis The financial reports reflect the fact that the City's General Funds represent . over 60% of both the revenues and expenditures for all City fund types. The changes in the General Fund revenues over the last four . fiscal years have - increased the emphasis on tax revenues. These changes . include large increases in property taxes due to a shift in - both responsibilit.ies. and property taxes from DSRSD (Dublin San Ramon Services District). to the City. The graph below reflects this fact. Sales tax revenue of $5,293,709 represents over forty . percent of General Fund total revenues for the City in fiscal year 91-92. General Fund Revenue Type: % of total dollar percent current change . - change 1991-92 year : from prior year Taxes' $9,700,250 74.19% ($ 503,802) - 4.94% License/Permits . 246,459 1.89% ' (1,657) - . .67% . Intergovernmental 864,647 6.61% (108,619) ' -11.16% Charges for Services 939,833 7.19% . (256,651) . -21.45% Uses of Assets 1,038,503 7.94% (300,444) -22.44% Fines & Forfeitures 25,780 .20% 6,304 32.37% • Other 258,944 1.98% _(31,310) -10.79 TOTALS: $13,074,416 100.00%. ($1,196,179) - .8.38% ' City of Dublin. .. . . General Fund Revenues by Year and Type --- Millions i . „ . $12 / $10 - $8- . 56 - �-" �,t� / �J7TAXES i'T/l,7r- "' / ' USES OF ASSETS $4 marYk g ;:; )" - � ,.. CHARGES FOR SERVICES 1 S2 - `r—�/ / —7 ���+ �J INTERGOVERNMENTAL iE1) j , r' OTHER A //�%-" I/" / / /7-7 LICENSE/PERMITS SO : 1 :. 1 FINES 8 FORFEITURES . 9 9 .8 8 8 8 . 1 0 9 8 7 6 - -- / / / / / / •9 9 9 8 8 8 2 1 0 9 8 7 SOURCE: AUDITED FINANCIAL REPORTS . • 7 . Expenditures of the General Fund show decreases in all the activities except Public Safety and Highways & Streets. The largest increase, $601,120 is primarily due to the increases in both the Police and Fire Safety costs - totalling $497,474. Some increase was due to the fact that a greater amount of Traffic Signals Activities cost was paid with General Fund money compared to prior years when Traffic Safety Fund money paid for most of these costs: General Fund 1991-92 % of dollar percent Expenditures: total total change change from prior year General Government 1,791,218 13.82% (218,887) -10.89% Facilities Rent 1,544,701 11.92% (34,771) - 2.20% Public Safety 5,404,855 41.69% 601,120 12.51% Highway & Streets 841,414 6.49% 3,867 .46% Health & Welfare 29,526 .23% 3,249 12.36% Community Development 1,438,475 11.10% (388,879) -21.28% Culture & Leisure 1,682,262 12.98% 222,843 15.27% Capital Outlay 231,877 1.79% (613,790) -72.58% TOTALS: 12,964,327 100.00% (425,249) - 3.18% City of Dublin Comparison of expenditures in General Fund by Activities Millions - /l / i / $6 $5 , r �i ,- Public Safety General Government :: : r 1 1 71/1 fir Culture & Leisure I1 �� Capital Outlay , /— / /� Highways & Streets $0 - �- `-1�- �� r I Health & Welfare 01-B2 90-91 09-90 88-89 07-88 00-07 SOURCE: Audited Financial Reports 8 This report has been prepared following the guidelines recommended by the Government Finance Officers Association (GFOA) of the United States and Canada. Those local agencies whose annual financial reports are evaluated to conform substantially to the highest standards of public financial reporting as well as meeting the standards of generally accepted accounting principles receive the Certificate of Achievement from the Government Finance Officers Association. Our report last year received this award from GFOA and is being submitted this year for such recognition. The preparation of this Comprehensive Annual Financial Report is the result of the efforts of the Finance Department Staff. I would also like to thank the City. Council for their support. Respectfully submitted, Richard C. Ambrose City Manager 9 CITY OF DUBLIN ELECTED OFFICIALS June 30, 1992 Mayor Peter W. Snyder Vice Mayor Councilmember Linda J. Jeffery Dave Burton Councilmember Councilmember Lisbeth Howard Paul C. Moffatt ADMINISTRATION PERSONNEL City Manager Richard C. Ambrose City Attorney Elizabeth Silver City Clerk Kay Keck Chief of Police Jim Rose Public Works Director Lee Thompson Planning Director Laurence L. Tong Chief Building Official Victor L. Taugher Recreation Director Diane Lowart Finance Director and Treasurer Phillip Molina 10 ■ I - I - I - I - �-- CITY OF DUBLIN • ORGANIZATION CHART FOR MAJOR CITY ACTIVITIES REGISTERED VOTERS OF THE CITY OF DUBLIN COUNCILMEMBERS CITY MANAGER I I FIRE J.P.A. Manager Staff & City Clerk I Building & RECREATION POLICE PLANNING FINANCE PUBLIC WORKS BuSafety ITREASURER I • • 11 Certificate of Achievement for Excellence in Financial Reporting Presented to City of Dublin, California For its Comprehensive Annual Financial Report for the Fiscal Year Ended June 30, 1991 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to government units and public employee retirement systems whose comprehensive annual financial reports (CAFRs)achieve the highest standards in government accounting and financial reporting. UNa OfFj�, / OFTHE F9� ',k�a UROED STATES y S w[ ANO w CI PORATIN President oo lE�II. �o�ti CHIC A` A 1 cutive Director 12 f -- --(---4 Caqfornia Society of Municipa( Finance Officers Certificate of Award Outstandin g Financial-Reporting 1990-91 Presented to Cit y of Dublin This certificate is issued in recognition of meeting professional standards and criteria in reporting which reflect a high level of quality in the annual financial statements and in the underlying accounting system from which the reports were prepared February 28, 1992 - it t.i .NWil/1/''V.. 1� / /. tip ..d y 1 _. i,/. .,,�i r i•,.'.. .r Chair,Professional&Technical Standards Committee c'.:N '11111' ref,;;1'8, -t• . /gy=p♦ n ♦M ,Rt� Q ' �/ !� ��. i 't- T=Yia,>S. fr t± , President Or Dedicated to Exiceffence in Municipal:Financial.Management 1 Z GFOA CERTIFICATE OF ACHIEVEMENT FOR f1 EXCELLENCE IN FINANCIAL REPORTING The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the City of Dublin for its Comprehensive Annual Financial Report for the fiscal year ended June 30, 1991. The Certificate of Achievement is the highest form of recognition for excellence in state and local government financial reporting. In order to be awarded a Certificate of Achievement,a government unit must publish an easily readable and efficiently organized Comprehensive Annual Financial Report,whose contents conform to program standards. Such a CAFR must satisfy both generally accepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for a period of one year only. We believe our current report continues to conform to the Certificate of Achievement program requirements,and we are submitting it to GFOA. The California Society of Municipal Finance Officers (CSMFO) presented a Certificate of Award for Outstanding Financial Reporting to the City of Dublin for its comprehensive annual financial report for the fiscal year ended June 30, 1991. The Certificate is valid for one year only. We believe our current report continues to conform to the program requirements and we are submitting it to the CSMFO. i5 14 • FINANCIAL SECTION . 1 ,r• (This Page Left Blank Intentionally) • 1 MAZE & I ASSOCIATES ACCOUNTANCY CORPORATION 1670 Riviera Avenue- Suite 100 Walnut Creek, California 94596 (510) 930-0902 • (916) 972-7333 FAX(510)930-0135 INDEPENDENT AUDITOR'S REPORT To the City Council City of Dublin,California We have audited the general purpose financial statements of the City of Dublin as of and for the years ended June 30,1992 and 1991, as listed in the table of contents. These financial statements are the responsibility of the City's management. Our responsibility is to express an opinion on these financial statements based on our audits. We conducted our audits in accordance with generally accepted auditing standards. Those standards require that we plan and perform the audits to obtain reasonable assurance as to whether the financial statements are free of material misstatement. An audit includes examining on a test basis evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principlesused and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe our audits provide a reasonable basis for our opinion. In our opinion,such general purpose financial statements present fairly in all material respects the financial position of the City of Dublin at June 30, 1992 and 1991 and the results of its operations and cash flows of its proprietary fund types for the years then ended,in conformity with generally accepted accounting principles. Our audits were made for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The accompanying combining fund statements and schedules,which are also listed in the table of contents,are presented for the purpose of additional analysis and are not a required part of the general purpose financial statements. Such combining fund statements and schedules have been subjected to the auditing procedures applied in the audit of the general purpose financial statements,and in our opinion are fairly stated in all material respects when considered in relation to the general purpose financial statements taken as a whole. The statistical section listed in the table of contents was not examined by us and,accordin ly,we do not express an opinion on this information. , September 17, 1992 17 A Professional Corporation CITY OF DUBLIN GENERAL PURPOSE FINANCIAL STATEMENTS These statements provide an overview of the combined financial position and the operating results of all fund types and account groups. Individual funds and account group utilized by the City are grouped in these statements as follows: GOVERNMENTAL FUND TYPES These funds(general,special revenue and capital projects)are those through which governmental functions are typically funded,with the emphasis on sources and uses of resources. PROPRIETARY FUND TYPES These funds(enterprise and internal service)are used to account for activities similar to private industry,with emphasis on net income determination and cost recovery. FIDUCIARY FUND TYPE These funds(agency funds)are those used to account for assets held by the city as and agent. ACCOUNT GROUPS The account groups are used to establish accounting control over the City's general fixed assets and unmatured principal of general long-term obligations. These assets and liabilities are not spendable resources and do not require current appropriation. They are accounted for separately from governmental fund types. I 19 CITY OF DUBLIN COMBINED BALANCE SHEETS - ALL FUND TYPES AND ACCOUNT GROUPS JUNE 30, 1992. WITH COMPARATIVE AMOUNTS AS OF JUNE 30, 1991 GOVERNMENTAL FUND TYPES PROPRIETARY FUND TYPES Special Capital Internal General Revenue Projects Service Enterprise ASSETS Cash and investments(Note 2) $15,684,894 $813,934 $1,413,278 $358,334 - Restricted cash and investments(Note 2) $1,720,986 Receivables: Accounts 262,263 3,100 1,279 Accrued interest 242,570 41,651 64,500 Due from other governments 215,199 Due from other funds (Note 3) 355,102 Prepaid expenses 1,939 109 1,725 r� Condemnation deposits 32,700 Fixed assets,net of accumulated depreciation(Note 4) 110,488 21,420,859 Amount to be provided for general long-term obligations Total Assets $16,761,967 $817,034 $1,488,908 $468,931 $23,208,070 LIABILITIES Accounts payable $898,538 $181,182 $471,956 $4,821 $1,464 Accrued wages 96,773 - Accumulated unpaid general leave 116,175 Deposits payable 170,994 95,865 Due to other funds(Note 3) 353,602 Due to other governments 24,650 Due to bondholders Deferred compensation payable Interest payable 498,900 BART advance payable(Note 5) Certificates of participation(Note 5) 16,057,162 Total Liabilities 1,307,130 534,784 567,821 4,821 16,557,526 FUND EQUITY AND OTHER CREDITS Investments in general fixed assets Contributed capital 168,258 5,109,891 Retained earnings: Reserved for debt service 1,540,653 Reserved for equipment replacement 295,852 Fund balances(Note 6): Reserved: Reserved for prepaid expenses 1,939 C' Reserved for condemnation deposits - 32,700 Unreserved: ° Designated for authorized expenditures 15,452,898 468,475 Undesignated (186,225) 888,387 . Total Fund Equities(Deficits) 15,454,837 282,250 921,087 464,110 6,650,544 Total Liabilities and Fund Equities $16,761,967 $817,034 $1,488,908 $468,931 $23,208,070 See accompanying notes to financial statements 20 • FIDUCIARY TOTALS FUND TYPE ACCOUNT GROUPS (Memorandum Only) Agency General Fixed General Long- Fund Assets Term Obligations 1992 1991 $18,270,440 $16,056,660 $1,304,356 3,025,342 2,621,910 13 266,655 274,394 348,721 263,749 215,199 724,787 355,102 1,363,311 3,773 17,398 32,700 $459,283 21,990,630 22,519,907 -` $2,285,000 2,285,000 $1,304,369 $459,283 $2,285,000 $46,793,562 $43,842,116 $10,963 $1,568,924 $1,419,658 96,773 67,630 116,175 105,488 266,859 541,562 1,500 355,102 1,363,311 24,650 23,884 1,193,238 1,193,238 843,686 98,668 98,668 59,648 498,900 498,900 $2,285,000 2,285,000 16,057,162 16,484,831 1,304,369 2,285,000 22,561,451 21,408,598 $459,283 459,283 444,275 5,278,149 5,278,149 1,540,653 1,580,406 • 295,852 291,836 1,939 7,058 32,700 15,921,373 15,736,524 702,162 (904,730) .. 459,283 24,232,111 22,433,518 $1,304,369 $459,283. $2,285,000 $46,793,562 $43,842,116. 21 (This Page Left Blank Intentionally) I r CITY OF DUBLIN - COMBINED STATEMENTS OF REVENUES, EXPENDITURES - AND CHANGES IN FUND BALANCES . ALL GOVERNMENTAL FUND TYPES -: - FOR THE YEAR ENDED JUNE 30, 1992 WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1991 TOTALS GOVERNMENTAL FUND TYPES (Memorandum Only) , Special Capital . General Revenue Projects 1992 1991 REVENUES Taxes $9,700,250 $105,484 $9,805,734 $10,312,208 Licenses and permits 246,459 246,459 248,116 Intergovernmental 864,647 1,625,118 2,489,765 2,564,553. Charges for services 939,833 145,418 1,085,251 1,196,484 Use of money and property 1,038,503 36,494 $50,157 1,125,154 1,388,351 } Fines and forfeits 25,780 32,721 58,501 82,367 Other revenue 310,851 454,584 286,190 1,051,625 383,423 Special assessments 275,890 275,890 281,428 Total Revenues 13,126,323 2,675,709 336,347 16,138,379 16,456,930 EXPENDITURES , Current: General government 3,335,919 3,142 3,339,061 3,593,481 Public safety 5,404,855 249,201 5;654,056 5,068,755 Highways and streets 841,414 183,851 1,025,265 1,041,627 Health and welfare 29,526 29,526 26,277 Community development 1,438,474 102;733 1,541,207 1,827,354 Culture and leisure 1,682,262 .1,682,262 1,459,419 _ Capital outlay . 231,877 . 1,481,764 3,559,400. 5,273,041 3,403,128 Total Expenditures - 12,964,327 2,020,691 3,559,400 18,544,418 16,420,041 EXCESS OF REVENUES OVER (UNDER)EXPENDITURES 161,996 - 655,018 (3,223;053) (2,406,039) 36,889 OTHER FINANCING SOURCES(USES) . Operating transfers in(Note 7) ' . 15,023 35,950 2,453 53,426 10,474 Operating transfers(out)(Note 7) (50,064) (15,023) (35,950) (101,037) (14,648) Proceeds from BART advance(Note 5) 2,285,000 2,285,000 Contribution in aid of construction(Note 5) 1,987,972 1,987,972 Total Other Financing Sources(Uses) (35;041) 20,927 4,239,475 4,225,361 (4,174) EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER ' - EXPENDITURES AND OTHER - FINANCING USES 126,955 675,945 1,016,422 1,819,322 32,715 °-`- Fund balances(deficit),beginning of year 15,327,882 (393,695) (95,335) 14,838,852 14,819,138 Residual equity transfers(out) (13,001) Fund balances,end of year $15,454,837 $282,250 $921,087 $16,658,174 . $14,838,852 See accompanying notes to financial statements , 1 23 . CITY OF DUBLIN ,, COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES -BUDGET AND ACTUAL ,� GENERAL, BUDGETED SPECIAL REVENUE AND BUDGETED CAPITAL PROJECTS FUND TYPES FOR THE YEAR ENDED JUNE,30, 1992 Budgeted General Fund Special Revenue Funds Variance Variance .,- ,, Favorable , Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) `_ REVENUES Taxes $10,944,600 $9,700,250 ($1,244,350) $114,000 $105,484 ($8,516) ( Licenses and permits 474,700 246,459 (228,241) Intergovernmental 939,366 864,647 (74,719) 1,784,410 1,565,567 (218,843) Charges for services 1,209,905 939,833 (270,072) 132,065 145,418 13,353 Use of money and property 1,091,100 1,038,503 (52,597) 36,760 35,913 (847) Fines and forfeits 19,500 25,780 6,280 15,250 32,721 17,471 Other revenue 54,600 258,944 204,344 603,300 340,409 (262,891) Special assessment 263,230 275,890 12,660 Total Revenue 14,733,771 13,074,416 (1,659,355) 2,949,015 2,501,402 (447,613) EXPENDITURES __ Current: General government 3,797,753 3,335,919 461,834 3,142 3,142 Public safety •5,577,844 5,404,855 172,989 202,095 191,090 . 11,005 Highways and streets 948,965 841,414 107,551 . 265,280 241,962 23,318 Health and welfare 61,551 29,526 32,025 Community development 1,863,912 1,438,474 425,438 142,365 102,733 39,632 Culture and leisure 1,791,507 1,682,262 109,245 Capital outlay 586,270 231,877 354,393 2,210,548 1,481,764 728,784 Total Expenditures 14,627,802 12,964,327 1,663,475 2,823,430 2,020,691 802,739 EXCESS OF REVENUES OVER (UNDER)EXPENDITURES 105,969 110,089 4,120 125,585 480,711 355,126 OTHER FINANCING SOURCES(USES) Operating transfers in(Note 7) 15,023 15,023 •4 Operating transfers(out)(Note 7) (50,064) (50,064) Proceeds from BART advance(Note 5) Contribution in aid of construction(Note 5) Total Other Financing Sources(Uses) (35,041) (35,041) EXCESS OF REVENUES AND OTHER FINANCING `" SOURCES OVER(UNDER)EXPENDITURES AND OTHER FINANCING USES $105,969 75,048 ($30,921) $125,585 480,711 $355,126 Adjustments to budgetary basis(Note 1) 51,907 ti Fund balances(deficit),beginning of year 15,327,882 (311,042) A Fund balances,end of year $15,454,837 $169,669 See accompanying notes to financial statements 24 I • • • TOTALS Capital Projects Funds (Memorandum Only) Variance Variance • Favorable Favorable Budget. Actual (Unfavorable) Budget Actual (Unfavorable) $11,058,600 $9,805,734 ($1,252,866) 474,700 246,459 (228,241) • 2,723,776 2,430,214 (293,562) • • 1,341,970 1,085,251 (256,719) $3,200 $50,157 $46,957 1,131,060 1,124,573 (6,487) 34,750 58,501 23,751 1,090,442 286,190 (804,252) 1,748,342 885,543 (862,799) 263,230 275,890 12,660 • 1,093,642 336,347 (757,295) 18,776,428 15,912,165 (2,864,263) • 3,800,895 - 3,339,061 461,834 5,779,939 • 5,595,945 183,994 1,214,245 1,083,376 130,869 --- 61,551 29,526 32,025 2,006,277 1,541,207 465,070 1,791,507 1,682,262 109,245' 4,402,083 3,559,400 842,683 . 7,198,901 5,273,041 1,925,860 4,402,083 3,559,400 842,683 . 21,853,315 18,544,418 3,308,897 (3,308,441) (3,223,053) 85,388 (3,076,887) (2,632,253) 444,634 . 2,453 2,453 17,476 17,476 (35,950) (35,950) (86,014) (86,014) 2,285,000 2,285,000 2,285,000 2,285,000 • 1,987,972 .1,987,972 1,987,972 1,987,972 • 4,272,972 4,239,475 (33,497) . 4,272,972 4,204,434 (68,538) • • $964,531, 1,016,422 $51,891 $1,196,085 1,572,181 $376,096 51,907 • • (95,335) • • 14,921,505 • } $921,087 $16,545,593 25 CITY OF DUBLIN 6_ COMBINED STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN FUND EQUITY ALL PROPRIETARY FUND TYPES FOR THE YEAR ENDED JUNE 30, 1992 WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1991 Internal Enterprise TOTALS . Service Fund Fund (Memorandum Only) Dublin Equipment Information Replacement Inc. 1992 1991 REVENUES Facilities rents(Note 5) $1,544,609 $1,544,609 $1,579,379 Equipment usage $144,490 144,490 132,516 Miscellaneous 2,410 2,410 2,260 Total Revenues 144,490 1,547,019 1,691,509 1,714,155 EXPENSES Depreciation 90,321 471,831 562,152 559,494 Miscellaneous 68,125 45,609 113,734 106,038 Total Expenses 158,446 517,440 675,886 665,532 Operating Income (13,956) 1,029,579 1,015,623 1,048,623 NONOPERATING INCOME(EXPENSE) Interest income 17,972 140,727 158,699 178,414 Interest expense and bond discount amortization (1,257,670) (1,257,670) (1,271,468) Nonoperating Income(Loss) 17,972 (1,116,943) (1,098,971) (1,093,054) Income(Loss)Before Operating Transfers 4,016 (87,364) (83,348) (44,431) (-- OPERATING TRANSFER IN(Note 7) 47,611 47,611 4,174 Net Income(Loss) 4,016 (39,753) (35,737) (40,257) Retained earnings,beginning of year 291,836 1,580,406 1,872,242 1,912,499 Retained earnings,end of year 295,852 1,540,653 1,836,505 1,872,242 Contributed capital,beginning of year 168,258 5,109,891 5,278,149 5,265,148 ■ Residual equity transfer in 13,001 Contributed capital,end of year 168,258 5,109,891 5,278,149 5,278,149 Total fund equity $464,110 $6,650,544 $7,114,654 $7,150,391 y See accompanying notes to financial statements 26 CITY OF DUBLIN COMBINED STATEMENTS OF CASH FLOWS ALL.PROPRIETARY FUND TYPES FOR THE YEAR ENDED JUNE 30, 1992 WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1991 Internal Enterprise TOTALS Service Fund Fund (Memorandum Only) Dublin Equipment Information Replacement Inc. 1992 1991 CASH FLOWS FROM OPERATING ACTIVITIES Operating income(loss) ($13,956) $1,029,579 $1,015,623 $1,048,623 Adjustments to reconcile operating income(loss) to cash flows from operating activities: Depreciation 90,321 471,831 562,152 559,494 Net effect of changes in: Accounts receivable 769 769 (769) Prepaid expenses 8,507 (1) 8,506 704 Accounts payable 4,363 (1,998) 2,365 (23,128) Cash Flows From Operating Activities 90,004 1,499,411 1,589,415 1,584,924 CASH FLOWS FROM INVESTING ACTIVITIES Interest received 17,972 140,727 158,699 158,546 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Fixed asset purchases (17,861) (17,861) (80,397) Contributed capital 13,001 Increase in restricted cash and investments (2,410) (2,410) (4,039) Certficates of Participation principal retirement (445,000) (445,000) (420,000) Interest paid (1,240,339) (1,240,339) (1,297,072) Cash Flows From Capital and Related Financing Activities (17,861) (1,687,749) (1,705,610) (1,788,507) CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES Operating transfers in 47,611 47,611 4,174 Net Cash Flows 90,115 90,115 (40,863) Cash and investments at beginning of year 268,219 268,219 309,082 Cash and investments at end of year $358,334 $358,334 $268,219 See accompanying notes to financial statements 27 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 1 -SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Dublin(City)was incorporated February 1,1982 under the Municipal Organization Act of 1977. The City operates under a Council-Manager form of government and provides services to residents primarily by contracting with other governmental agencies and private contractors. The following is a summary of the significant policies of the City which conform to generally accepted accounting principles as applicable to governments. A. Reporting Entity The general purpose financial statements of the City of Dublin include the fmancial activities of the City as well as separate legal entities which are controlled by or dependent on the City. Determination of "controlled by or dependent on" is based on the National Council on Governmental Accounting Statement 3 "Defining the Governmental Reporting Entity". This statement deals with existence as an organized entity,governmental character, and autonomy. Management has considered all potential component units in evaluating how to define the City for general purpose financial statement purposes. The criteria for including a potential component unit in the City's financial statements are the City Council's ability to exercise oversight responsibility,the scope of the entity's service and the existence of special financing relationships,regardless of whether the City is able to exercise oversight responsibilities. Dublin Information,Inc.(DII)is a separate legal entity established solely to assist in providing financing to the City and to own and rent facilities to the City. DII is dependent on the City for its cash flows and therefore meets the criterion of ability to significantly influence operations and accountability for fiscal matters for inclusion in the City's reporting entity. The financial activities of DII have been included in the Dublin Information,Inc.Enterprise Fund. Since DII's sole business is facilities rental,it accounts for rents as operating revenues. The general purpose financial statements exclude the activities of the Livermore-Amador Valley Transit Authority, the Dublin Housing Authority,the Tri Valley Transportation Council,the Dublin San Ramon Services District and the Dougherty Regional Fire Authority. Each of these agencies is managed and operated independently of the City, which is not able to significantly influence their operations,budgets or financing. B. Fund Accounting The accounts of the City are organized on the basis of funds and account groups, each of which is considered a separate accounting entity. The operations of each fund are accounted for with a separate set of self-balancing accounts that comprise its assets,liabilities,fund equity,revenues, and expenditures,or expenses, as appropriate. Government resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending activities are controlled. The various funds are grouped in the general purpose financial statements as follows: 28 CITY OF DUBLIN Notes.to General Purpose Financial Statements NOTE 1 -SUMMARY OF SIGNIFICANT_ACCOUNTING POLICIES (Continued) GOVERNMENTAL FUND TYPES General Fund is the general operating fund of the City. It is used to account for all financial resources except those required to be accounted for in another fund. Special Revenue Funds are used to account for the proceeds of specific revenue sources(other than major capital projects)that are legally restricted to expenditures for specific purposes. Capital Projects Funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities(other than those financed by proprietary funds). PROPRIETARY FUND TYPES Enterprise Fund is used to account for operations which are financed and operated in a manner similar to private business enterprises where the intent of the governing body is that the costs and expenses,including depreciation,of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or where the governing body has decided that periodic determination of revenues earned,expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability,or other purposes. - Internal Service Fund is used to account for the financing of goods provided by one department or agency to other departments or agencies of the City on a cost-reimbursement basis. FIDUCIARY FUND TYPE Agency Funds are used to account for assets held by the City as an agent for individuals,private organizations,other governments.and/or other funds, in accordance with the conditions of the agreements. Agency funds are purely custodial and thus do not involve measurement of results of operations. C Account Groups The accounting and reporting treatment applied to the fixed assets and long-term obligations associated with a fund are determined by its measurement focus. All governmental fund types are accounted for on a spending or"financial flow"measurement focus,which means that only current assets and current liabilities are generally included on their balance sheets. Their reported fund-balance (net current assets) is considered a measure of"available spendable resources". Governmental fund operating statements present increases(revenues and other financing sources)and decreases (expenditures and other financing uses) in net current assets. Accordingly, they are said to present a summary of sources and uses of"available spendable resources"during a period. Fixed assets used in governmental fund type operations(general fixed assets)are accounted for in the general fixed assets account group,rather than in governmental fund types. Long term obligations expected to be financed from governmental fund types are accounted for in the general long- term obligations account group,not in the governmental fund types. 29 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 1 -SUMMARY OF ACCOUNTING POLICIES (Continued) <- The two account groups are not"funds". They are concerned only with the measurement of financial position.They are not involved with measurement of results of operations. Because of their spending measurement focus, expenditure recognition for governmental fund types is limited to exclude amounts represented by noncurrent liabilities.Since they do not affect net current assets,such long-term amounts are not recognized as governmental fund expenditures or fund liabilities. D. .Fired Assets All fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not available. T Donated fixed assets are valued at their estimated fair value on the date donated. No depreciation has been provided on general fixed assets. The City has elected not to capitalize its infrastructure, which consists of roads, bridges, curbs, gutters, streets, sidewalks,drainage systems,and lighting systems except where required by the state for property acquired with state grants funds. All proprietary funds are accounted for on a cost of services or"capital maintenance"measurement focus, which means that all assets and all liabilities,current and non-current,associated with their activity are included on their balance sheets. Their reported fund equity is segregated into contributed capital and retained earnings components. Proprietary fund type operating statements present increases(revenues)and decreases(expenses)in net assets. Depreciation of all exhaustible fixed assets used by proprietary funds is charged as an expense against their operations. Accumulated depreciation is reported on proprietary fund balance sheets. ,.,, Depreciation has been provided over the estimated useful lives of proprietary fund assets using the straight line method. The estimated useful lives are as follows: Building 37.5 years Machinery and equipment 3-7 years E. Contributed Capital in Proprietary Fund Types Contributed capital in proprietary funds represents general fund residual equity transfers used to acquire or construct fixed assets. F. Basis of Accounting Basis of accounting refers to when revenues and expenditures or expenses are recognized in the accounts and reported r in the general purpose financial statements. Basis of accounting relates to the timing of the measurements made, regardless of the measurement focus applied. - All governmental and agency fund types are accounted for using the modified accrual basis of accounting. Their revenues are recognized when they become measurable and available as net current assets. 30 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 1 -SUMMARY OF ACCOUNTING POLICIES (Continued) Those revenues susceptible to accrual are property taxes, interest revenues and charges for services. Sales taxes collected and held by the State at year end on behalf of the City also are recognized as revenue. Fines,licenses,hotel and motel taxes, permits and parking meter revenues are not susceptible to accrual because they generally are not measurable until received in cash. Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability __ r is incurred except for principal and interest on general long term obligations which is recognized when due. Because of their current financial resources focus,expenditure recognition for governmental fund types excludes amounts represented by noncurrent liabilities. Since they do not affect net current assets,such long-term amounts are not recognized as governmental fund expenditures or fund liabilities. All proprietary fund types are accounted for using the accrual basis of accounting. Their revenues are recognized - _, when they are earned,and their expenses are recognized when they are incurred. G. Budgets and Budgetary Accounting The City follows these procedures in establishing the budgetary data reflected in the general purpose financial statements: 1. Prior to June 30 the City Manager submits to the City.Council a proposed operating budget for the fiscal year commencing the following July 1. The operating budget includes proposed expenditures and the means of financing them. 2. Public hearings are conducted to obtain taxpayer comments. 3. Prior.to July 1,the budget is legally enacted through passage of a resolution. 4. The City Manager is authorized to transfer budgeted amounts between line items within any department; - however, any revisions,which alter total departmental expenditures of the City must be approved by City Council.Expenditures may not exceed budgeted appropriations at the departmental level without City Council approval. . 5. Formal budgetary integration is employed as management control device during the year for the general fund, special revenue funds,except the Bond,Measure D,and SAFCO Grant Special Revenue Funds,and the capital projects funds. 6. Budgets for the general, special revenue and capital projects funds are adopted on a basis consistent with generally accepted accounting principles(GAAP)except for prior year items,which are not budgeted and which are recorded as prior year adjustments in the budget basis financial statements. 31 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 1 -SUMMARY OF ACCOUNTING POLICIES (Continued) Budget basis and GAAP basis fund balances differ because of prior year items and certain funds which are not budgeted. These fund balances are reconciled as follows(excludes funds with no ending fund balances): Special General Revenue Fund Funds Fund balances,budgetary basis $15,402,930 $169,669 Add prior year items _ 51,907 Add(deduct)fund balances for: r SAFCO Grant (727) Measure D 113,308 Fund balances,GAAP Basis $15,454,837 $282,250 All unexpended appropriations lapse at the end of the fiscal year. Budgeted amounts presented in the financial statements are as originally adopted,or as amended by the City Council. Individual amendments were not material in relation to original appropriations. H Cash and Investments The City pools idle cash from all funds,except Cash and Investments with Fiscal Agent and Deferred Compensation Plan assets,for the purpose of increasing income through investment activities. Investments are carried at cost,except Deferred Compensation Plan assets which are carried at market value. Interest income on investments is allocated on the basis of average month-end cash and investment balances in each fund. -- Proprietary fund type cash and investments are used in the preparation of the statement of cash flows as investments are not allocated to specific funds. Each funds allocation of pooled cash and investments is considered cash and cash equivalents. /- Restricted cash and investments are composed of investments with a maturity date greater than September 30,1992 and are therefore not considered cash and cash equivalents. Deferred Compensation Plan City employees may defer a portion of their compensation under City sponsored deferred compensation plans created in accordance with Internal Revenue Code Section 457. Under these plans,participants are not taxed on the deferred portion of their compensation until distributed to them;distributions may be made only at termination,retirement, death or in an emergency as defined by the Plan. All assets of the Plans, including participant contributions and earnings therefrom, are the property of the City. These assets may also be claimed by the general creditors of the City;however,the City believes the likelihood of any such claim is remote. Participants rights under the Plan are equal to those of general creditors of the City. 32 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 1 -SUMMARY OF ACCOUNTING POLICIES(Continued) Investments in the Plans are managed by trustees under agreements which allow participants to choose among various investment options including stocks,bonds,money market accounts,and a guaranteed rate of return based on the five year Treasury bond index. The City has no liability for any losses which may be incurred by the Plan and does not participate in any gains,but it does have the duty of due care that would be required of an ordinary prudent investor. City management has assigned fiduciary management functions to a professional asset management company. J. Property Tax Alameda County assesses properties and bills for and collects property taxes as follows: Secured Unsecured Valuation dates March 1 March 1 Lien/levy dates March 1 March 1 Due dates 50%on November 1 July 1 50%on February 1 Delinquent as of December 10(for November) August 31 April 10(for February) The term"unsecured"refers to taxes on property other than real estate,land"and buildings. These taxes are secured by liens on the property being taxed. " Property taxes are recorded when levied,provided they are measurable and collected within 60 days of year end. K Accumulated Unpaid General Leave The City accounts for the entire unpaid liability for accrued general leave in the general fund since the City's policy is to liquidate any unpaid general leave from currently available expendable resources rather than future resources. The City offers its employees general leave benefits which are composed of time off for illnesses and vacations. Employees receive benefits in the form of time off or,if terminated,in cash. L. Claims and Adjustments The City records a liability for uninsured claims and judgements and its deductible when it is probable that an asset has been impaired or a liability has been incurred,and the amount of impairment or liability is reasonably estimable. No material claims or judgements were accrued at year end. 33 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 1 -SUMMARY OF ACCOUNTING POLICIES (Continued) 1- M Post Employment Health Care Benefits The City provides certain health care benefits for one retiree. All former full time employees are eligible for these benefits. The cost of retiree health care benefits is recognized as an expenditure as claims are paid. For the year ended June 30, 1992 those costs totaled approximately$4,865. N New Funds and Account Group T During the year the City established five funds and one account group: The Measure D Special Revenue Fund was established to account for the use of funds received from a judgement in favor of the City for an invalid surcharge imposed by the County on Dublin citizens. The National Pollution Discharge Special Revenue Fund was established to account for the use of funds received _ from fees collected to mitigate pollution within the City. The Dublin Boulevard Extension #1 Capital Projects Fund was established to account for infrastructure .- improvements financed with resources received from other governmental agencies. The Dublin Boulevard Extension #2 Capital Projects Fund was established to account for infrastructure improvements financed by the Dublin Boulevard Assessment District. The Dublin Boulevard Assessment District Agency Fund was established to account for cash and investments - held on behalf of bond holders. The General Long-Term Obligations Account Group was established to account for long-term obligations expected to be financed from revenues of governmental funds. O. Closed Funds The following special revenue funds were closed during the year ended June 30, 1992: State Park Bond Act Bond Fund Measure AA Dublin Boulevard Extension#1 Dublin Boulevard Extension#2 Community Parklands Act 34 7 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 1 -SUMMARY OF ACCOUNTING POLICIES (Continued) P. Total Columns on Combined Statements Total columns on the combined statements are captioned Memorandum Only to indicate that they are presented only to facilitate financial analysis. Data in these columns do not present financial position,results of operations,or cash flows in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of this data Q. Classification Changes For the year ended June 30,1992,certain account classifications have been changed to improve financial statement presentation. For comparative purposes,prior year balances have been reclassified to conform to the June 30,1992 presentation. NOTE 2-CASH AND INVESTMENTS - A Collateral All cash in banks and non-negotiable certificates of deposit are entirely insured or collateralized with securities held by the pledging financial institutions in the City's name.The California Government Code requires California banks and savings and loan associations to secure the City's cash deposits by pledging securities as collateral. This California Government Code states that collateral pledged in this manner shall have the effect of perfecting a security interest in such collateral superior to those of a general creditor. Thus,collateral for cash deposits are considered to be held in the City's name. The City has waived collateral requirements for cash deposits which are fully insured up to$100,000 by the Federal Deposit Insurance Corporation(FDIC)or Savings Account Insurance Fund(SAIF). At year end,the carrying amount of the City's cash deposits was$175,108 and the bank balance was$522,036. Of the bank balance,$115,651 was covered by federal depository insurance. The balance was covered by collateral as discussed above. - - B. Authorized Investments The City's investment policy and Section 53601 of the California Government Code allow the City to invest in the following types of investments: Securities of the U.S. Government, or its agencies Certificates of Deposit Bankers Acceptances Local Agency Investment Fund(State Pool)Deposits Repurchase Agreements - Commercial Paper Medium Term Corporate Notes Local Agent Long-Term Debt Registered State Warrants 3.5 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 2-CASH AND INVESTMENTS (Continued) The above investments may be held by the City subject to certain limitations as described in the City's investment policy. Deferred Compensation Plan assets are governed by federal law which allows for additional types of investments. C Credit Risk, Carrying Amount,and Market Value ofInvestments Investments represented by specific identifiable investment securities are classified as to credit risk in three categories as follows:Category 1 includes investments that are insured or registered or for which securities are held by the City or its agent in the City's name; Category 2 includes any unregistered investment for which the securities are held by the financial institution's trust department or agent in the City's name; Category 3 includes uninsured investments which are purchase _. and held by the Trustee,but not in the City's name. Pooled investments are not required to be categorized. The City's investments at June 30, 1992 and 1991 comprise: 1992 1991 Category Category Non Carrying Market Carrying 1 3 Categorized Value Value Amount Cash deposits: Cash in banks and certificates of deposit $175,108 $175,108 $175,108 $5,600,346 City treasury investments: - Securities of the U.S. Government or its agencies $2,013,172 2,013,172 2,085,061 1,300,000 - Local Agency Investment Fund 17,186,000 17,186,000 17,186,000 10,000,000 Investments with Fiscal Agents: Deferred Compensation Plan Mutual Funds 98,668 98,668 98,668 59,648 Securities of the U.S. Government or its agencies $1,822,834 1,822,834 1,956,587 1,718,576 Total of Cash and Investments $2,013,172 $1,822,834 $17,459,776 $21,295,782 $21,501,424 $18,678,570 Financial Statement Presentation: Cash and investments $18,270,440 $16,056,660 Restricted cash and investments 3,025,342 2,621,910 $21,295,782 $18,678,570 36 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 2-CASH AND INVESTMENTS (Continued) At June 30, 1992 the City had $1,838,485 in cash and investments held by fiscal agents which is pledged for the payment of certificates.of participation, bonds, or employee compensation. The California Government Code requires these funds to be invested in accordance with any applicable City ordinance,resolution or bond.indenture, unless there are specific State statutes governing their investment. All these funds have been invested only,as permitted either the above Code or applicable City ordinance.. The City entered into no reverse repurchase agreements during the year ended June 30, 1992. NOTE 3-INTERFUND BALANCES . The General Fund was owed the amounts below at June 30, 1992 by the funds listed: Special Revenue Funds: Traffic Safety $27,240 Transportation Development Act 80,998 Federal Aid Urban Highway 77,907 Community Development Block Grant 575 Safco Grant 727" SB 300 Grant 166,155 Dublin Blvd Extension A.D.Agency Fund 1,500 Total Amount Owed General Fund $355,102 The amounts owed represent General Fund advances for expenditures made by these funds which will be repaid in the normal course of business in fiscal 1993. 37 -- CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 4-FIXED ASSETS Fixed assets balances and activity were as follows: 4 Balance Balance July 1,1991 Additions Retirements June 30, 1992 General Fixed Assets Land $120,000 $120,000 Equipment 324,275 $15,008 339,283 Total $444,275 $15,008 $459,283 Enterprise Fund Land $6,842,037 $6,842,037 Building 15,453,847 15,453,847 Machinery&equipment 422,510 422,510 Total 22,718,394 22,718,394 Less accumulated depreciation 825,704 $471,831 1,297,535 Net $21,892,690 $21,420,859 Internal Service Fund Machinery&equipment $516,998 $17,868 $51,763 $483,103 Less accumulated depreciation 334,056 $90,322 $51,763 372,615 Net $182,942 $110,488 • NOTE 5-LONG TERM OBLIGATIONS A. BART Agreemenffhiblin Boulevard Assessment District In 1990, the City and Bay Area Rapid Transit District(BART) entered into a financing Agreement regarding the extensions of Dublin Boulevard and Hacienda Drive to service a station to be constructed by BART. In fiscal 1992, BART advanced the City $2,285,000 to purchase land and construct these extensions. In addition, the Dublin Boulevard Extension Assessment District was formed in 1992 and contributed$1,987,972 to the City to aid in the construction of the Dublin Boulevard extension. The City established the Dublin Boulevard Extension Capital Projects Funds#1 and#2 to account separately for these respective amounts. 38 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 5-LONG TERM OBLIGATIONS (Continued) BART's advances to the City comprise,$1,224,000 due December 31, 1995 and$1,061,000 which has no due date. Under the City'sAgreement with BART,interest on these advances accrues at a rate based on BART's average rate of return on its investments. The City expects to repay principal and interest on BART's advances out of developer fees,charges and other non-tax revenues generated by future development in the area of the BART station. However, the Agreement provides for the forgiveness by BART of any principal or interest still outstanding on March 27,2010. The City has recorded BART's advances as general long-term debt at June 30,1992 because,despite the Agreement's forgiveness clause,the City is confident there will be sufficient City revenues generated in the BART station area to repay this debt. B. Certificates ofParticfpation Through Dublin Information Inc.,the City in 1988 issued Refunding Certificates of Participation(1988 COP's)in the amount of$17,230,000,which are repayable from facilities rents and are collateralized by the Dublin Civic Center. The 1988 COP's bear interest at 5.75%to 7.875%,are due serially through February 1,2010,require annual principal payments on February 1 and semi-annual interest payments on February 1 and July 1. The City has a non-cancelable lease expiring in 2010 with Dublin Information Inc. (DII),which used the lease as collateral for the issuance of the 1988 COPs. The lease provides for semi=annual payments which are sufficient to pay principal and interest due on the 1988 COPs. Ownership of the Civic Center Building reverts to the City at the end of the lease. The 1988 COPs balances comprised the following at June 30, 1992 and 1991. 1992 1991 Principal balance at July 1 $16,810,000 $17,230,000 Less: bond discount,net of amortization 307,838 325,169 Principal retirements 445,000 420,000 Balance at June 30,net of bond discount $16,057,162- $16,484,831 . 39 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 5-LONG TERM OBLIGATIONS (Continued) r- e MatutitySchedule Annual debt service requirements for long term obligations including interest on 1988 COPs are as follows: For the Year Bart Ending June 30 Agreement 1988 COPS Total 1993 $1,718,970 $1,718,970 1994 1,719,595 1,719,595 1995 1,717,095 1,717,095 1996 $1,224,000 1,716,320 2,940,320 1997 1,716,770 1,716,770 Thereafter 1,061,000 22,335,840 23,396,840 $2,285,000 $30,924,590 $33,209,509 D. Special Assessment Districts Special assessment districts formed within City limits have issued debt totaling$2,845,000,the proceeds of which were used to fmance improvements within district boundaries. The City has no legal,contingent or moral obligation for the repayment of this debt and acts solely as the collecting and paying agent for each district. E. DefeasedDebt At June 30, 1992 the balance of the 1985 Certificates of Participation which were defeased by the 1988 Refunding Certificates of Participation was $10,750,000. As required by the 1988 defeasance, securities were placed in an irrevocable trust with an escrow agent to provide for all future debt service payments on the 1985 Certificates of Participation,which are no longer considered a liability of the City. NOTE 6-FUND BALANCES The following funds had deficit balances at June 30, 1992: Special Revenue Funds: Traffic Safety $18,303 Transportation Development Act 88,460 Federal Aid Urban Highway 78,866 Safco Grant 727 SB 300 Grant 207,439 Capital Projects Funds: Capital Projects 7,837 These deficits will be eliminated through future revenues or through General Fund transfers,once the underlying projects have been completed. 40 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 7-TRANSFERS During the year.ended June 30, 1992 the following operating transfers were made to reimburse expenses or expenditures: Fund Making Transfer Fund Receiving Transfer Amount General Fund Capital Projects Fund $2,453 General Fund Dublin Information Inc. Enterprise Fund 47,611 Community Parkland Act Special General Fund Revenue Fund 15,023 Dublin Boulevard Extension#1 Capital Dublin Boulevard Extension#1 Projects Fund Special Revenue Fund 35,950 $101,037 NOTE 8 -JOINT POWERS AGENCIES The City participates in joint ventures through Joint Powers Authorities(JPAs)established under the Joint Exercise of Powers Act of the State of California. As separate legal entities,these JPAs exercise full powers and'authorities within the scope of the related Joint Powers Agreement,including the preparation of annual budgets,accountability for all funds,the power to make and execute contracts and the right to sue and be sued. Obligations and liabilities of the JPAs are not those of the City. Each JPA is governed by a board consisting of representatives from each member agency. Each board controls the operations of its respective JPA,including selection of management and approval of operating budgets,independent of any influence by member agencies beyond their representation on the Board. The City is a member of the following JPAs: A: Livermore Amador Valley Transit Authority This Authority was formed in May 1985 by a joint exercise of powers agreement between the County of Alameda and the Cities of Livermore,Pleasantonand Dublin for the purpose of providing general public transportation under the business name"Wheels". B. Dougherty Regional Fire Authority The Cities of Dublin and San Ramon established the Dougherty Regional Fire Authority(DRFA)to provide fire suppression and prevention services. DRFA is controlled by a six member board consisting of three members from each City Council. The board appoints management and employees of DRFA and is responsible for DRFA's budget, operations and finances. 41 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 8 -JOINT POWERS AGENCIES (Continued) C. Tri-Valley Transportation Council The Tri-Valley Transportation Council was formed in 1991 by a joint exercise of powers agreement between the cities of Dublin,Livermore,Pleasanton and San Ramon,the Town of Danville and the counties of Alameda and Contra Costa for the purposes of preparing a transportation plan and providing transportation facilities within the Tri-Valley area. There was no financial activity during the year ended June 30, 1992. D. Alameda County Congestion Management Program The Alameda County Congestion Management Program was formed in 1991 by a joint exercise of powers agreement .- between the County of Alameda and the Cities of Alameda County for the purpose of preparing,implementing and administering a traffic congestion management plan pursuant to California Government Code section 66531. There was no financial activity during the year ended June 30, 1992. E. Association ofBay Area Governments PLAN Corporation The City is a member of ABAG PLAN Corporation,which provides annual general liability coverage in the aggregate up to $5,000,000 per occurrence; the City has a$25,000 deductible per claim. Once the City's deductible is met, ABAG becomes responsible for payment of claims. The City's deposits with ABAG are in accordance with formulas established by ABAG. Actual surpluses or losses will be shared according to a formula developed from overall loss costs and spread to member entities on a percentage basis after a retrospective rating. F. Condensed Financial Information Audited condensed financial information for the above authorities which had financial activity during the year ended June 30, 1992 is presented below: Transit Year End Authority DRFA ABAG Total assets $13,024,672 $8,626,455 $17,348,069 Total current liabilities 1,394,522 1,130,280 9,187,416 Total long-term liabilities 1,403,085 Total equity 11,630,150 6,093,090 8,160,653 Total revenue 3,792,512 4,194,915 5,549,832 Total expenditures 3,832,512 4,082,324 1,121,412 Other financing sources 40,000 Contributed capital reductions 2,050 000 Net increase in fund equity 112,591 2,378,420 42 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 9-PENSION PLAN A. Plan Description The City contributes to the California Public Employees Retirement System(PERS), an agent multiple-employer public employee retirement system which acts as a common investment and administrative agent for participating members in California. All qualified permanent and probationary employees are eligible to participate in PERS. Benefits vest after five years of service and are payable monthly for life upon retirement. Employees who retire at age 60 with 5 years of credited service receive a benefit equal to 10%of their average monthly salary for their highest three consecutive years of employment. Benefits increase with age and credited service years up to a maximum of 2:148%for each credited service year. A credited service year is one year of full time employment. PERS requires a contribution of 7% of the employees annual salary which the City pays on the behalf of the employees. These benefit provisions and all other requirements are established by state statute and city ordinance. Contributions necessary to fund PERS on an actuarial basis are determined by PERS and its Board of Administration.. A Funding Status and Progress The amount shown below as the"pension benefit obligation"is a standardized disclosure measure of the present value of pension benefits,adjusted for the effects of projected salary increases and step-rate benefits estimated to be payable in the future as a result of employee service to date. The measure is intended to help users assess the funding status of PERS on a going-concern basis,assess progress made in accumulating sufficient assets to pay benefits when due and make comparisons among employers. The measure is the actuarial present value of credited projected benefits and is independent of the funding method used to determine contributions to the PERS. The pension benefit obligation was computed as part of an actuarial valuation performed as of June 30, 1991. Significant actuarial assumptions used in the valuation include(a)a rate of return on the investment of present and future assets of 8.5%a year compounded annually,.(b)projected salary increases of 5%a year compounded annually, attributable to inflation, plus additional projected salary increases.attributable to seniority/merit, and (d) post retirement benefit increases adjusted 2%annually after the fist two years of retirement. 43 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 9-PENSION PLAN(Continued) Total over-funded pension benefit obligation applicable to the City's employees at June 30, 1991 is as follows: Pension benefit obligation: Retirees and beneficiaries currently receiving benefits and terminated employees not yet receiving benefits $10,767 Current employees: - Accumulated employee contributions including allocated investment 395,349 Employer-financed vested 256,090 Employer-financed nonvested 56,518 _- Total pension benefit obligation 718,724 Net assets available for benefits,at cost (Market value was$966,241 at June 30, 1991) 871,272 Over-funded pension benefit obligation $152,548 C Actuarially Determined Contribution Requirements and Contributions Made - PERS uses the Entry Age Normal Actuarial Cost Method which is a projected benefit cost method. That is,it takes into account those benefits that are expected to be earned in the future as well as those already accrued. According to this cost method,the normal cost for an employee is the level amount which would fund the projected benefit if it were paid annually from date of employment until retirement. PERS uses a modification of the Entry - Age Cost Method in which the employer's total normal cost is expressed as a level percentage of payroll. PERS also uses the level percentage of payroll method to amortize any unfunded actuarial liabilities. The amortization period of the unfunded actuarial liability ends on June 30,2011. _ The significant actuarial assumptions used to compute the actuarially determined contribution requirement are the same as those used to compute the pension benefit obligation,as previously described. 44 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 9-PENSION PLAN(Continued) Contributions to PERS are made in accordance with actuarially determined requirements computed through an actuarial valuation performed as of year end. PERS contributions,which were entirely paid by the City,consisted of the following for the fiscal years ended June 30, 1992 and 1991: 1992 1991 Percent of Percent of Covered - Covered Amount Payroll , Amount Payroll Covered.payroll $1,507,749 $1,241,152 Total payroll $1,751,039 $1,448,959 Normal cost,including employee contributions $202,138 13.5% $159,311 12.8% Amortized(over- funded) pension benefit obligation (43,792) (3.0%) Total $158,346 10.5% $159,311 12.8% City contributions $52,793 3.5% $72,400 5.8% Employee contributions 105,543 7.0% 86,811 7.0% Total $158,336 10.5% $159,311 12.8% D. Trend Informatio Trend information gives an indication of the progress made in accumulating sufficient assets to pay benefits when due. System wide ten-year trend information may be found in the California Public Employees'Retirement System Annual Reports. For the fiscal years ended June 30, 1991, 1990 and 1989,net assets available for benefits funded 121%, 115.7%and 112.1% respectively, of the pension plan's total pension benefit obligation and the overfunded pension benefit obligation represented 2.3%,7.4%and 5.1%respectively,of covered payroll. In addition,for the three years ended June 30, 1992, 1991 and 1990 the City's contributions to the System, all made in accordance with actuarially determined requirements, were 10.5%, 12.8% and 12.8% respectively of annual covered payroll. Other trend information required by Governmental Accounting Standard No.5 is presented in the City's Comprehensive Annual Financial Statement statistical section. 45 CITY OF DUBLIN Notes to General Purpose Financial Statements NOTE 10-COMMITMENT AND CONTINGENT LIABILITIES - As part of the BART Agreement,and in accordance with federal requirements,the City and the City of Pleasanton reached an agreement under which the City of Pleasanton is constructing a second BART station access road in the City of Dublin. Total cost of this project is presently expected to be$3,800,000,which is due within 12.5 years after the completion and acceptance of the project by the City of Dublin. However,if an assessment district is formed in this area of the City,the Agreement provides that the cost of the project will be borne by the assessment district. If no assessment district is formed and the City has not repaid the City of Pleasanton by the due date,an agency of the County of Alameda will become responsible for half the cost of the project. At June 30, 1992, the City of Pleasanton had expended approximately$430,000 on this project,which is presently expected to be completed in June 1993. The City participates in several federal and State grant programs. These programs have been audited by the City's independent accountants in accordance with the provisions of the federal Single Audit Act of 1984 and applicable State requirements. No cost disallowances were proposed as a result of these audits;however,these programs are still subject to further examination by the grantors and the amount,if any,of expenditures which may disallowed by the granting agencies cannot be determined at this time.The City expects such amounts,if any,to be immaterial. 46 FINANCIAL SECTION COMBINING FUND STATEMENTS (This Page Left Blank Intentionally) CITY OF DUBLIN GENERAL FUND COMPARATIVE BALANCE SHEETS JUNE 30, 1992 AND 1991 1992 1991 ASSETS Cash and investments $15,684,894 $15,136,269 Receivables: Accounts 262,263 268,625 Accrued interest 242,570 199,249 Due from other governments 215,199 231,987 Due from other funds 355,102 1,363,311 Prepaid expenses 1,939 7,058 Total Assets $16,761,967 $17,206,499 LIABILITIES Accounts payable $898,538 $1,273,147 Accrued wages 96,773 67,630 Accumulated unpaid general leave 116,175 105,488 Deposits payable 170,994 408,468 Due to other governments 24,650 23,884 Total Liabilities 1,307,130 1,878,617 FUND BALANCES Reserved for prepaid expenses 1,939 7,058 Designated for authorized expenditures 15,452,898 15,320,824 Total Fund Balances 15,454,837 15,327,882 Total Liabilities and Fund Balances $16,761,967 $17,206,499 49 1 CITY OF DUBLIN GENERAL FUND STATEMENTS OF REVENUES, EXPENDITURES - AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL FOR THE YEAR ENDED JUNE 30, 1992 WITH COMPARATIVE ACTUAL AMOUNTS FOR THE YEAR ENDED JUNE 30, 1991 1992 1991 Variance Favorable Budget Actual (Unfavorable) Actual REVENUES Taxes $10,944,600 $9,700,250 ($1,244,350) $10,204,052 Licenses and permits 474,700 246,459 (228,241) 248,116 Intergovernmental 939,366 864,647 (74,719) 973,266 Charges for services 1,209,905 939,833 (270,072) 1,196,484 Use of money and property 1,091,100 1,038,503 (52,597) 1,338,947 Fines and forfeits 19,500 25,780 6,280 19,476 _ Other revenue 54,600 258,944 204,344 114,038 Total Revenues 14,733,771 13,074,416 (1,659,355) 14,094,379 , _ EXPENDITURES ' Current: General government 3,797,753 3,335,919 461,834 3,589,577 Public safety 5,577,844 5,404,855 172,989 4,800,963 , Highways and streets 948,965 841,414 107,551 837,547 Health and welfare 61,551 29,526 32,025 26,277 Community development 1,863,912 1,438,474 425,438 1,827,354 Culture and leisure 1,791,507 1,682,262 109,245 1,459,419 Capital outlay 586,270 231,877 354,393 848,439 Total Expenditures 14,627,802 12,964,327 1,663,475 13,389,576 1 EXCESS OF REVENUE OVER EXPENDITURES 105,969 110,089 4,120 704,803 OTHER FINANCING SOURCES Operating transfers in ' 15,023 15,023 Operating transfers(out) (50,064) (50,064) (4,174) Total Other Financing Sources(Uses) (35,041) (35,041) (4,174) EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER EXPENDITURES AND OTHER FINANCING USES $105,969 75,048 - ($30,921) 700,629 i Adjustments to budgetary basis 51,907 176,216 Fund balances,beginning of year 15,327,882 14,464,038 Residual equity transfers(out) (13,001) Fund balances,end of year $15,454,837 $15,327,882 50 I CITY OF DUBLIN GENERAL FUND SCHEDULE OF BUDGET VERSUS ACTUAL DEPARTMENTAL EXPENDITURES FOR THE YEAR ENDED JUNE 30, 1992 WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1991 1992 Variance Favorable Budget Actual (Unfavorable) General government: _ City Council $159,669 $123,424 $36,245 City Manager 506,645 460,781 45,864 City Attorney 206,533 206,533 Finance department 282,549 230,354 52,195 Building management 363,220 331,686 31,534 Insurance cost center 166,600 145,934 20,666 Elections cost center 3,000 2,997 3 Nondepartmental 388,867 289,508 99,359 Facilities rents 1,720,670. 1,544,702 175,968 Total General Government 3,797,753 3,335,919 461,834 Public safety: Police 2,794,073 2,752,425 41,648 Crossing guards 33,143 33,143 Traffic signal and street lighting 73,550 72,969 581 Animal control 56,000 39,120 16,880 Disaster preparedness 42,085 31,370 10,715 Fire services JPA 2,578,993 2,475,828 103,165 - - Total Public Safety 5,577,844 5,404,855 172,989 Highways and streets: Public works ' 282,015 267,078 14,937 Street maintenance 328,100 269,134 58,966 - Street sweeping 62,000 61,455 545 Street tree maintenance 66;500 46,090 20,410 Street landscape maintenance 208,850 196,157 12,693 Paratransit services 1,500 1,500 Total Highways and Streets 948,965 841,414 107,551 Health and welfare: Vector Control 28,296 21,394 6,902 Waste management 33,255 8,132 25,123 Total Health and Welfare 61,551 29,526 32,025 Community development: Planning 1,050,075 950,526 - 99,549 Building safety 326,796 261,821 64,975 Engineering 429,791 220,207 209,584 -� Economic development 57,250 5,920 51,330 Total Community Development 1,863,912 1,438,474 425,438 ' Culture and leisure: Library services 156,007 156,007 Cultural activities 44,140 24,137 20,003 Park maintenance 552,453 552,453 Community cable television 49,000 49,000 Recreation administration 171,625 158,732 12,893 Playgrounds 66,924 64,680 2,244 Shannon center 105,787 99,301 6,486 Preschool 32,195 31,914 281 Teens program - 47,185 29,761 17,424 Field scheduling 133,395 105,796 27,599 Youth sports • 31,739 22,600 9,139 Special events 27,791 23,937 3,854 Senior center 104,120 95,734 8,386 Recreation instruction 76,921 82,678 (5,757) Aquatics - 192,225 185,532 6,693 Total Culture and Leisure 1,791,507 1,682,262 109,245 -, Capital outlay: General capital improvement projects 88,850 1,902 84,948 Community improvements 66,300 60,567 5,733 Parks 195,162 122,823 72,339 Street construction and improvements 235,958 44,585 191,373 Total Capital Outlay - 586,270 231,877 354,393 Total Expenditures $14,627,802 $12,964,327 $1,663,475 51 (This Page Left Blank Intentionally) CITY OF DUBLIN SPECIAL REVENUE FUNDS Traffic Safety Fund-Established to account for the receipt of traffic fines and traffic safety expenditures. State Gas Tax Fund-Established to account for receipt of state gasoline taxes and expenditures. Transportation Development Act Fund-Established to account for Transportation Development Act grant receipts and construction expenditures for bike paths and access ramps for the handicapped. Special Criminal Activity Fund-Established to account for receipt of funds derived from asset forfeitures. Federal Aid Urban Highway Fund-Established to account for receipt of Federal Aid Urban Highway grants. Community Development Block Grant Fund-Used to account for grants and expenditures related to the community development block grants. Park Dedication Fund-Established to account for park dedication fees received in lieu of property from developers pursuant to the Quimby Act. State Park Bond Act Fund-Established to account for proceeds from the State bond sales. Sales Tax Measure B Fund-Established to account for an Alameda County Voter approved increase in sales tax used for improvements on streets and roads. Bond Fund Measure AA-Established to account for proceeds from Measure AA State Bond Sales for park capital improvements. SAFCO Grant Fund-Established to account for grant receipts from the State used for capital improvements on parks. Maintenance Districts-Established to account for revenue and related expenditures of lighting and landscape activities. Community Parkland Act Fund-Established to account for State bond proceeds for park improvements. SB300 Grant Fund-Established to account for grant receipts from the State used for capital improvements on local streets. National Pollution Discharge Fund-Established to account for the use of funds received from fees collected to mitigate pollution within the City without specific sources. Measure D Fund-Established to account for the use of funds received form a judgement in favor of the City for an invalid surcharge imposed by the County on Dublin citizens. 53 CITY OF DUBLIN SPECIAL REVENUE FUNDS COMBINING BALANCE SHEETS JUNE 30, 1992 WITH COMPARATIVE AMOUNTS AS OF JUNE 30, 1991 Federal Sales Transportation Special Aid Community State Tax Traffic State Development Criminal Urban Development Park Park Measure Safety Gas Tax Act Activity Highway Block Grant ,Dedication Bond Act B ASSETS l{i Cash and investments $6,933 $122,285 $26,647 $123,215 $45,382 Accounts receivable 2,004 $575 H Due from other governments - Total Assets $8,937 $122,285 $26,647 $575 $123,215 . $45,382 LIABILITIES Accounts payable $69,018 $7,462 $334 $959 $32,716 Due to other funds $27,240 80,998 77,907 $575 -- Total Liabilities 27,240 69,018 88,460 334 78,866 575 32,716 FUND BALANCES(DEFICITS) Unreserved: Designated for authorized expenditures 53,267 90,499 Undesignated fund balances(deficits) (18,303) (88,460) 26,313 (78,866) $45,382 Total Fund Balances(Deficits) (18,303) 53,267 (88,460) 26,313 (78,866) 90,499 45,382 Total Liabilities and Fund Balances $8,937 $122,285 $26,647 $575 $123,215 $45,382 I 54 Bond MAINTENANCE DISTRICTS Fund Dougherty Dublin Dublin Community National TOTALS Measure Safco Street Stagecoach Landscape Boulevard Boulevard Parklands SB 300 Polution AA Grant Lighting Landscape &Lighting Extension#1 Extension#2 Act Grant Discharge Measure D 1992 1991 $160,696 $22,287 $144,193 $48,988 $113,308 $813,934 $590,377 402 76 43 3,100 5,000 492,800 $161,098 $22,363 $144,236 $48,988 $113,308 $817,034 $1,088,177 ,.� $13,831 $6,991 $8,361 $41,284 $226 181,182 $141,666 $727 166,155 353,602 1,340,206 727 13,831 6,991 8,361 207,439 226 534,784 1,481,872 ti 147,267 15,372 48,762 $113,308 468,475 415,700 (727) 135,875 (207,439) (186,225) (809,395) (727) 147,267 15,372 135,875 (207,439) 48,762 113,308 282,250 (393,695) $161,098 $22,363 $144,236 $48,988 $113,308 $817,034 $1,088,177 55 CITY OF DUBLIN SPECIAL REVENUE FUNDS r COMBINING STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES � FOR THE YEAR ENDED JUNE 30, 1992 I. WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1991 Sales _ Transportation Special Federal Community State Tax Traffic State Development Criminal Aid Urban Development Park Park Measure, Safety Gas Tax Act Activity Highway Block Grant Dedication Bond Act B. REVENUES Taxes I"1", Sales and use taxes $105,484 Intergovernmental FAU grant $855,020 '' CDBG grant $34,124 i Gasoline tax $423,740 TDA Act funds $146,433 SB 300 grant State park bond $7,202 State parkland grant Local grant Charges for services Property fees Use of money and property . Interest 13,264 $1,621 ` $151 2,599 - Fines and forfeits ./, Vehicle code fines $32,721 { Other revenue Park dedication fees 325,217 Miscellaneous 4,150 a- Special assessments , Total Revenues 32,721 437,004 146,433 5,771 855,020 34,124 325,368 7,202 108,083 EXPENDITURES i General government Service and supplies 3,142 Public safety Service and supplies 6,353 Contract services 15,250 ,-.t Highways and streets r. Service and supplies 56,054 Contract services 1,225 Community development Contract services 5,000 `" Capital outlay 1, Service and supplies 361,283 98,505 548,554 26,927 3,508 63,952 '� Contract services 35,316 10,626 28,415 148,400 6,950„-- Total Expenditures 15,250 458,878 112,273 6,353 576,969 26,927 151,908 70,902,^ EXCESS OF REVENUES OVER (UNDER)EXPENDITURES 17,471 (21,874) 34,160 • (582) 278,051 7,197 173,460 7,202 37,181 OTHER FINANCING SOURCES(USES) Operating transfers in Operating transfers(out) - 1 Total Other Financing Sources(Uses) t EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER(UNDER)EXPENDITURES 4 L. AND OTHER FINANCING USES 17,471 (21,874) 34,160 (582) 278,051 7,197 173,460 7,202 37,181 Fund balances(deficits),beginning of the year (35,774) 75,141 (122,620) 26,895 (356,917) (7,197) (82,961) (7,202) 8,201 j Fund balances(deficits),end of the year ($18,303) $53,267 ($88,460) $26,313 ($78,866) $90,499 $45,382 j 56 Bond MAINTENANCE DISTRICTS Fund Dougherty Dublin Dublin Community National TOTALS 1 Measure Safco Street Stagecoach Landscape Boulevard Boulevard Parklands SB 300 Pollution AA Grant Lighting Landscape &Lighting Extension#1 Extension l!2 Act Grant Discharge Measure D 1992 1991 $105,484 $108,156 855,020 723,546 34,124 ro 423,740 378,020 146,433 58,583 $106,250 106,250 7,202 $5,000 5,000 5,000 $47,349 47,349 426,138 $145,418 145,418 $7,507 $949 $7,817 2,005 $581 36,494 37,529 r.. 32,721 62,891 325,217 3,361 7,681 $1,448 112,727 129,367 17,078 177,615 48,324 49,951 275,890 281,428 47,349 5,000 188,483 49,273 65,449 1,448 106,250 147,423 113,308 2,675,709 2,098,369 3,142 3,904 163,440 169,793 208,415 6,047 58,111 79,408 59,377 12,421 15,933 4,700 89,108 87,125 43,727 49,791 94,743 116,955 2,328 763 681 93,961 102,733 1 65,866 1,168,595 2,301,501 83,462 313,169 120,723 171,815 56,911 66,405 207,439 98,661 2,020,691 2,898,000 ` 47,349 5,000 16,668 (7,638) (956) 1,448 (101,189) 48,762 113,308 655,018 (799,631', $35,950 35,950 10,474 ($15,023) (15,023) (10,474 35,950 (15,023) 20,927 47,349 5,000 16,668 (7,638) (956) 35,950 1,448 (15,023) (101,189) 48,762 113,308 675,945 (799,631 (47,349) (5,727) 130,599 23,010 136,831 (35,950) (1,448) 15,023 (106,250) (393,695) 405,936 I ($727) $147,267 $15,372 $135,875 ($207,439) $48,762 $113,308 $282,250 ($393,695 I 57 • CITY OF DUBLIN BUDGETED SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL FOR THE YEAR ENDED JUNE 30, 1992 TRAFFIC SAFETY STATE GAS TAX Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES Taxes Sales and use taxes Intergovernmental FAU grant CDBG funds Gasoline tax $410,750 $423,740 $12,990 TDA Act funds SB 300 Grant Charges for services Property fees Use of money and property Interest 11,200 13,264 2,064 Fines and forfeits Vehicle code fines $15,250 $32,721 $17,471 Other revenue Park dedication fees Miscellaneous Special assessments Total Revenues 15,250 32,721 17,471 421,950 437,004 15,054 EXPENDITURES General government Service and supplies Public safety Service and supplies Contract services 15,250 15,250 Highways and streets Service and supplies 60,000 56,054 3,946 Contract services 86,600 1,225 85,375 Community development Contract services 5,000 5,000 Capital outlay Service and supplies 466,054 361,283 104,771 Contract services 35,316 (35,316) Total Expenditures 15,250 15,250 617,654 458,878 158,776 EXCESS OF REVENUES OVER (UNDER)EXPENDITURES 17,471 $17,471 ($195,704) (21,874) $173,830 Fund balances(deficits), beginning of the year (35,774) 75,141 Fund balances(deficits), end of year ($18,303) $53,267 58 • TRANSPORTATION DEVELOPMENT ACT SPECIAL CRIMINAL ACTIVITY FEDERAL AID URBAN HIGHWAY Variance Variance Variance Favorable Favorable Favorable . Budget Actual (Unfavorable) Budget Actual (Unfavorable) 'Budget Actual (Unfavorable) $938,833 $855,020 ($83,813) • $113,166 $146,433 $33,267 • $1,360 $1,621 - $261 - • 6,000 4,150 (1,850) 113,166 146,433 33,267 7,360 5,771 (1,589) 938,833 855,020 (83,813) • 3,142 3,142 13,295 6,353 6,942 • 110,024 98;505 11,519 • 744,956 548,554 196,402 10,626 (10,626) • 28,415 (28,415) • 113,166 112,273 893 13,295 . 6,353 6,942 744,956 576,969 167,987 34,160 . $34,160 ($5,935) (582) $5,353 $193,877 278,051 $84,174 (122,620) 26,895 - (356,917) . ($88,460) $26,313 ($78,866) (Continued) 59 CITY OF DUBLIN BUDGETED SPECIAL REVENUE FUNDS COMBINING STATEMENT.OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL FOR THE YEAR ENDED JUNE 30, 1992 iT COMMUNITY DEVELOPMENT BLOCK GRANT PARK DEDICATION Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES Taxes Sales and use taxes Intergovernmental FAU grant CDBG funds $48,506 $34,124 ($14,382) Gasoline tax TDA Act funds SB 300 Grant Charges for services Property fees Use of money and property Interest $6,200 $151 ($6,049) Fines and forfeits Vehicle code fines Other revenue Park dedication fees 590,300 325,217 (265,083) Miscellaneous Special assessments Total Revenues 48,506 34,124 (14,382) 596,500 325,368 (271,132) EXPENDITURES General-government Service and supplies Public safety Service and supplies Contract services Highways and streets Service and supplies Contract services Community development Contract services Capital outlay z Service and supplies 50,709 26,927 23,782 3,508 (3,508) Contract services 415,150 148,400 266,750 Total Expenditures 50,709 26,927 23,782 415,150 151,908 263,242 EXCESS OF REVENUES OVER (UNDER)EXPENDITURES ($2,203) 7,197 $9,400 $181,350 173,460 ($7,890) Fund balances(deficits),beginning of the year (7,197) (82,961) Fund balances(deficits),end of year $90,499 60 - SALES TAX MEASURE B STREET LIGHTING STAGECOACH LANDSCAPE Variance Variance Variance -- Favorable Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) $114,000 $105,484 ($8,516) 600 2,599 1,999 $6,800 $7,507 $707 $900 $949 $49 3,000 3,361 361 169,750 177,615 7,865 45,780 48,324 2,544 114,600 108,083 (6,517) 179,550 188,483 8,933 46,680 49,273 2,593 ._ 170,250 163,440 6,810 3,300 6,047 (2,747) 10,080 12,421 (2,341) 38,500 43,727 (5,227) 6,000 2,328 3,672 2,000 763 1,237 58,298 63,952 (5,654) 6,950 (6,950) 58,298 70,902 (12,604) 179,550 171,815 7,735 50,580 56,911 (6,331) $56,302 37,181 ($19,121) 16,668 $16,668 ($3,900) (7,638) ($3,738) 8,201 130,599 23,010 $45,382 $147,267 $15,372 (Continued) 61 CITY OF DUBLIN BUDGETED SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL FOR THE YEAR ENDED JUNE 30, 1992 DOUGHERTY LANDSCAPE AND LIGHTING SB 300 GRANT "r Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES Taxes Sales and use taxes Intergovernmental FAU grant CDBG funds Gasoline tax --- TDA Act funds SB 300 Grant $273,155 $106,250 ($166,905) Charges for services Property fees ; Use of money and property Interest $9,700 $7,817 ($1,883) Fines and forfeits _ Vehicle code fines Other revenue Park dedication fees Miscellaneous 4,000 7,681 3,681 Special assessments 47,700 49,951 2,251 Total Revenues 61,400 65,449 4,049 273,155 106,250 (166,905) EXPENDITURES General government Service and supplies Public safety Service and supplies Contract services Highways and streets Service and supplies 14,800 15,933 (1,133) Contract services 50,600 49,791 809 58,111 (58,111) Community development Contract services 2,000 681 1,319 Capital outlay Service and supplies 365,357 65,866 299,491 Contract services 83,462 (83,462) Total Expenditures 67,400 66,405 995 365,357 207,439 157,918 EXCESS OF REVENUES OVER (UNDER)EXPENDITURES ($6,000) (956) $5,044 ($92,202) (101,189) ($8,987) Fund balances(deficits),beginning of the year 136,831 (106,250) Fund balances(deficits),end of year $135,875 ($207,439) 62 � NATIONAL POLLUTION DISCHARGE TOTAL Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) $114,000 $105,484 ($8,516) ' 938,833 855,020 (83,813) 48,506 34,124 (14,382) 410,750 423,740 12,990 113,166 146,433 33,267 273,155 106,250 (166,905) $132,065 $145,418 $13,353 132,065 145,418 13,353 2,005 2,005 36,760 35,913 (847) 15,250 32,721 17,471 590,300 325,217 (265,083) 13,000 15,192 2,192 263,230 275,890 12,660 132,065 147,423 15,358 2,949,015 2,501,402 (447,613) 3,142 3,142 183,545 169,793 13,752 18,550 21,297 (2,747) 84,880 84;408 472 - 4,700 4,700 180,400. 157,554 22,846 127,365 93,961 33,404 142,365. 102,733 39,632 1,795,398 1,168,595 626,803 415,150 313,169 101,981 $132,065 $98,661 $33,404 2,823,430 2,020,691 802,739 48,762 $48,762 $125,585 480,711 $355,126 (311,042) $48,762 $169,669 63 CITY OF DUBLIN BUDGETED SPECIAL REVENUE FUNDS SCHEDULE OF BUDGET VERSUS ACTUAL DEPARTMENTAL EXPENDITURES FOR THE YEAR ENDED JUNE 30, 1992 1992 yt Variance Favorable Budget Actual. (Unfavorable) General government-City Council $1,142 $3,142 Public safety: Police 13,295 6,353 $6,942 t, Traffic signals and street lighting 188,800 184,737 4,063 Total Public Safety 202,095 191,090 11,005 Highways and streets: Street tree maintenance 13,100 4,884 8,216 Street landscaping maintenance 100,880 116,988 (16,108) Street maintenance 151,300 120,090 31,210 -_ Total Highways and Streets 265,280 241,962 23,318 Community development-Engineering 142,365 102,733 39,632 - Capital outlay: San Ramon Road improvements,phase four 1,042,510 954,723 87,787 Senior Citizen kitchen upgrade 21,928 21,927 1 Dublin Boulevard extension 223,655 74,586 149,069 Annual street overlay project 200,000 139,240 60,760 Dublin High girls athletic field renovation . 224,600 369 224,231 Street subdrain project 128,000 6,404 121,596 I Dublin Boulevard bridge 40,500 18,845 21,655 Kalidescope Center project 5,000 5,000 ,,- Arroyo Vista playgrounds 23,781 23,781 Handicapped ramps 35,024 33,972 1,052 Nelsen School play area 37,800 13,848 23,952 Wells Cronin play area 58,800 45,252 13,548 Murry School baseball diamond 22,400 20,469 • 1,931 Dublin Sports Grounds 6,800 6,800 ', Dublin Swim Center 64,750 6,407 58,343 Shannon Park 65,563 (65,563) s` Dougherty Road bike path project 75,000 75,159 (159) Total Capital Outlay 2,210,548 1,481,764 728,784 Total Expenditures $2,823,430 $2,020,691 $802,739 R 1 6 4 ;}_ • CITY OF DUBLIN CAPITAL PROJECTS FUNDS Capital Projects Fund-To account for acquisitions and constructions of capital facilities other than those financed by proprietary funds. The Dublin Boulevard Extension #1 Capital Projects Fund was established to account for infrastructure improvements financed with resources received from other governmental agencies. The Dublin Boulevard Extension #2 Capital Projects Fund was established to account for infrastructure improvements financed by the Dublin Boulevard Assessment District. 65 CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEETS JUNE 30, 1992 WITH COMPARATIVE AMOUNTS AS OF JUNE 30, 1991 Dublin Dublin TOTALS Capital Boulevard Boulevard Projects Extension#1 Extension#2 1992 1991 ASSETS Cash and investments $109,879 $216,272 $1,087,127 $1,413,278 $61,789 Receivables: Accounts 1,279 1,279 Interest 41,651 41,651 Condemnation deposits 32,700 32,700 Total Assets $109,879 $290,623 $1,088,406 $1,488,908 $61,789 LIABILITIES Accounts payable $21,851 $240,025 $210,080 $471,956 $925 Deposits payable 95,865 95,865 133,094 Due to other funds 23,105 Total Liabilities 117,716 240,025 210,080 567,821 157,124 FUND BALANCES Reserved for condemnation deposits 32,700 32,700 Undesignated (7,837) 17,898 878,326 888,387 (95,335) Total Fund Balances(Deficit) (7,837) 50,598 878,326 921,087 (95,335) '-" Total Liabilities and Fund Balances(Deficit) $109,879 $290,623 $1,088,406 $1,488,908 $61,789 66 ,- CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES (DEFICITS) FOR THE YEAR ENDED JUNE 30, 1992 WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1991 Dublin Dublin TOTALS I Capital Boulevard Boulevard Projects Extension#1 Extension#2 1992 1991 REVENUES - Use of money and property $2,856 $41,651 $5,650 $50,157 $11,875 Other revenue 286,190 286,190 76,091 Total Revenues. 289,046 41,651 5,650 336,347 87,966 EXPENDITURES Capital outlay: Land,equipment and other facilities 36,433 1,457,856 1,082,474 2,576,763 63,984 1 Contractual services 167,568 782,247 32,822 982,637 - -- 68,481 Total Expenditures 204,001 2,240,103 1,115,296 3,559,400 132,465 EXCESS OF REVENUES OVER __- (UNDER)EXPENDITURES 85,045 (2,198,452) (1,109,646) (3,223,053) (44,499) OTHER:FINANCING SOURCES Operating transfer in 2,453 2,453 Operating transfer(out) (35,950) (35,950) Proceeds from BART Advance 2,285,000 2,285,000 Contribution in aid of construction. 1,987,972 1,987,972 Total Other Financing Sources 2,453 2,249,050 1,987,972 " 4,239,475 EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER(UNDER) EXPENDITURES 87,498 50,598 - 878,326 1,016,422 (44,499) Fund deficits,beginning of year (95,335) (95,335) (50,836) Fund balances(deficits), end of year ($7,837) $50,598 $878,326 $921,087 ($95,335) 67 CITY OF DUBLIN BUDGETED CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES (DEFICITS) BUDGET AND ACTUAL FOR THE YEAR ENDED JUNE 30, 1992 CAPITAL PROJECTS DUBLIN BOULEVARD EXTENSION#1 Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES Use of money and property $3,200 $2,856 ($344) $41,651 $41,651 Other revenue • 649,442 286,190 (363,252) $441,000 (441,000) Total Revenues 652,642 289,046 (363,596) 441,000 41,651 _ (399,349) EXPENDITURES Capital outlay: Land, equipment and other facilities 744,592 36,433 708,159 2,513,345 1,457,856 1,055,489 Contractual services 28,850 167,568 (138,718) 782,247 (782,247) Total Expenditures 773,442 204,001 569,441 2,513,345 2,240,103 273,242 EXCESS OF REVENUES OVER (UNDER)EXPENDITURES (120,800) 85,045 205,845 (2,072,345) (2,198,452) (126,107) OTHER FINANCING SOURCES Operating transfer in 2,453 2,453 Operating transfer(out) (35,950) (35,950) Proceeds from BART Advance 2,285,000 2,285,000 Contribution in aid of construction Total Other Financing Sources 2,453 2,453 2,285,000 2,249,050 (35,950) EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER(UNDER) EXPENDITURES ($120,800) 87,498 $208,298 $212,655 50,598 ($162,057) Fund deficit,beginning of year (95,335) Fund balances(deficits),end of year ($7,837) $50,598 68 DUBLIN BOULEVARD EXTENSION#2 TOTAL Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) $5,650 $5,650 $3,200 $50,157 $46,957 1,090,442 286,190 (804,252) 5,650 5,650 1,093,642 336,347 (757,295) $1,082,474 1,082,474 4,340,411 2,576,763 1,763,648 32,822 32,822 61,672 982,637 (920,965) 1,115,296 1,115,296 4,402,083 3,559,400 842,683 (1,115,296) (1,109,646) 5,650 (3,308,441) (3,223,053) 85,388 2,453 2,453 (35,950) (35,950) 2,285,000 2,285,000 1,987,972 1,987,972 1,987,972 1,987,972 1,987,972 1,987,972 4,272,972 4,239,475 (33,497) $872,676 878,326 $5,650 $964,531 1,016,422 $51,891 (95,335) $878,326 $921,087 69 CITY OF DUBLIN BUDGETED CAPITAL PROJECTS FUNDS SCHEDULE OF BUDGET VERSUS ACTUAL , DEPARTMENTAL EXPENDITURES FOR THE YEAR ENDED JUNE 30, 1992 1992 Variance Favorable Budget Actual (Unfavorable) Capital outlay: Nielsens School athletic play field $21,000 $21,000 Dublin High School football renovation 28,592 36,433 ($7,841) Dougherty Road improvements 38,000 9,079 28,921 Dublin Boulevard/Silvergate Drive improvements 320,850: 107,094 213,756 Dublin Boulevard/San Ramon Road/Village Parkway improvements 365,000 30,395 334,605 Dublin Boulevard Extension#1 2,513,345 2,240,103 273,242 Dublin Boulevard Extension#2 1,115,296 1,115,296 Total Expenditures $4,402,083 $3,559,400 $842,683 r-- 70 CITY OF DUBLIN AGENCY FUNDS Agency funds are used to account for assets held by the City in a fiduciary capacity for individuals,governmental entities and others. These funds carry out the specifications of trust indentures,ordinance or other regulations. San Ramon Road Specific Improvement Plan Agency Fund-To account for the special assessment established to fund the improvements to San Ramon Road and Amador Valley Boulevard. Employee Deferred Compensation Plan-To account for assets of the City's Employee Deferred Compensation Plan. Dublin Boulevard Improvement Assessment District Fund-To account for the special assessment established to fund the improvements to Dublin Boulevard. 71 CITY OF DUBLIN AGENCY FUNDS COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES FOR THE YEAR ENDED JUNE 30, 1992 Balance Balance June 30, 1991 Additions Reductions July 1, 1992 C- San Ramon Road Specific Improvement Plan Restricted cash and investments $843,686 $183,487 ($103,936) $923,237 Accounts receivable 13 13 Total Assets $843,686 $183,500 ($103,936) $923,250 Due to bondholders $843,686 $183,500 ($103,936) $923,250 Employee Deferred Compensation Plan Restricted cash and investments $59,648 $44,027 ($5,007) $98,668 Deferred compensation payable $59,648 $44,027 ($5,007) $98,668 Dublin Boulevard Extension Assessment District Restricted cash and investments $347,958 . ($65,507) $282,451 Total assets $347,958 ($65,507) $282,451 Accounts payable $10,963 $10,963 Due to other funds 1,500 1,500 Due to bondholders 335,495 ($65,507) 269,988 ,_.._ Total liabilities $347,958 ($65,507) $282,451 Total Agency Funds Restricted cash and investments $903,334 $575,472 ($174,450) $1,304,356 Accounts Receivable 13 13 Total Assets $903,334 $575,485 ($174,450) $1,304,369 Accounts payable $10,963 $10,963 Due to other funds 1,500 1,500 Due to bondholders $843,686 518,995 ($169,443) 1,193,238 Deferred compensation payable 59,648 44,027 (5,007) 98,668 Total Liabilities $903,334 $575,485 ($174,450) $1,304,369 72 STATISTICAL SECTION (This Page Left Blank Intentionally) CITY OF DUBLIN GOVERNMENTAL EXPENDITURES BY FUNCTION ALL.GOVERNMENTAL FUND TYPES LAST TEN FISCAL YEARS PUBLIC GENERAL SAFETY AND GOVERNMENTAL HEALTH HIGHWAYS CULTURE FISCAL AND FACILITIES AND AND COMMUNITY AND CAPITAL YEAR RENTS WELFARE STREETS DEVELOPMENT LEISURE OUTLAY TOTAL 1982-1983 $222,837 $1,179,124 $150,069 $152,064 $3,348 $112,909 $1,820,351 - 1983-1984 273,906 1,327,700 199,291 434,921 64,602 714,566 3,014,986 1984-1985 361,392 1,494,855 319,247 602,567 224,588 1,982,847 4,985,496 1985-1986 542,616 1,676,247 635,445 961,541 309,092 3,641,282 7,766,223 1986-1987 2,208,131 1,770,331. 730,051 1,062,858 365,193 3,668,733 9,805,297 1987-1988 2,308,376 2,039,119 813,482 1,091,901 524,622 2,914,458 9,691,958 1988-1989 1,286,201 3,986,097 941,276 1,336,870 1,026,538 3,214,398 11,791,380 1989-1990 2,047,506 4,672,847 1,021,641 1,583,504 1,274,861 2,652,683 13,253,042 1990-1991 3,593,481 5,095,032 1,041,627 1,827,354 1,459,419 3,403,128 16,420,041 1991-1992 3,339,061 5,683,582 1,025,265 1,541,207 1,682,262 5,273,041 18,544,418 SOURCE:CITY OF DUBLIN ANNUAL FINANCIAL REPORT INCLUDES FIRE SERVICES AND CULTURE AND LEISURE SERVICES RESPONSIBILITIES ASSUMED JULY 1, 1988. INCLUDES FEDERAL AID URBAN EXPENDITURES BEGINNING IN 1986-1987. 75 CITY OF DUBLIN GENERAL GOVERNMENTAL REVENUES BY SOURCE ALL GOVERNMENTAL FUND TYPES LAST TEN FISCAL YEARS USE OF LICENSES CHARGES MONEY FINES FISCAL AND INTER- FOR AND AND OTHER SPECIAL YEAR TAXES PERMITS GOVERNMENTAL SERVICES PROPERTY FORFEITS REVENUE ASSESSMENTS TOTAL 1982-1983 $3,009,677 $3,936 $905,461 $32,906 $132,913 $48,806 $5,055 $4,138,754 1983-1984 3,845,968 345,346 1,114,109 123,124 409,198 61,734 533,113 6,432,592 1984-1985 4,738,818 333,982 1,456,930 260,217 1,004,263 68,301 556,690 $137,145 8,556,346 1985-1986 5,062,103 410,246 1,436,379 682,324 1,111,034 68,995 381,784 435,995 9,588,860 1986-1987 5,837,811 586,320 1,965,454 593,407 883,644 91,755 501,802 157,704 10,617,897 1987-1988 6,179,005 532,696 1,660,205 466,673 1,074,160 94,584 593,069 246,915 10,847,307 1988-1989 9,305,662 292,189 2,567,703 738,314 1,183,847 104,641 68,617 262,197 14,523,170 1989-1990 9,769,276 315,010 1,667,801 1,090,386 1,405,882 91,221 908,784 287,205 15,535,565 1990-1991 10,312,208 248,116 2,564,553 1,196,484 1,388,351 82,367 383,423 281,428 16,456,930 1991-1992 9,805,734 246,459 2,489,765 1,085,251 1,125,154 58,501 1,051,625 275,890 16,138,379 SOURCE:CITY OF DUBLIN ANNUAL FINANCIAL REPORT 76 CITY OF DUBLIN ASSESSED AND ESTIMATED ACTUAL VALUE OF TAXABLE.PROPERTY LAST TEN FISCAL YEARS TOTAL FISCAL SECURED UNSECURED NET ASSESSED' YEAR PROPERTY UTILITY PROPERTY VALUATION 1982-1983 $420,655,192 $11,395,380 $52,149,934 $484,200,506 1983-1984 474,965,963 ' 12,582,160 62,296,499 549,844,622 1984-1985 515,660,344 13,182,170 64,760,035 593,602,549 1985-1986 598,426,296 14,662,390 74,740,855 687,829,541 1986-1987 721,792,937 16,371,040 82,214,150 820,378,127 1987-1988 802,835,061 18,759,300 85,253,484 906,847,845 1988-1989 962,867,790 1,812,200 84,339,466 1,049,019,456 1989-1990 1,086,479,184 1,812,200 94,717,004 1,183,008,388 1990-1991 1,195,196,327 4,536,700 90,697,434 1,290,430,461 1991-1992 1,285,655,755 4,536,700 92,332,101 1,382,524,556 SOURCE: ALAMEDA COUNTY OFFICE OF THE AUDITOR-CONTROLLER 77 CITY OF DUBLIN PROPERTY TAX RATES ALL OVERLAPPING GOVERNMENTS LAST TEN FISCAL YEARS _ BASIC FLOOD BAY EAST DUBLIN COUNTY ZONE AREA BAY SAN RAMON FISCAL WIDE LEVY SCHOOL STATE RAPID PARKS SERVICES ALAMEDA YEAR ($1/$100) DISTRICTS BONDS TRANSIT BOND DISTRICT COUNTY TOTAL 1982-1983 $1.0000 $0.2157 $0.0363 $0.0628 $0.0162 $0.0060 $1.3370 1983-1984 1.0000 0.1979 0.0326 0.0617 0.0164 0.0094 1.3180 1984-1985 1.0000 0.2045 0.0291 0.0572 0.0156 0.0091 1.3155 1985-1986 1.0000 0.1136 0.0429 0.0508 0.0055 1.2128 1986-1987 1.0000 0.0820 0.0185 0.0421 0.0051 1.1477 1987-1988 1.0000 0.0958 0.0119 0.0390 0.0032 0.0017 1.1516 1988-1989 1.0000 0.0862 0.0183 0.0372 0.0019 0.0019 1.1455 1989-1990 1.0000 0.0701 0.0198 0.0319 $0.0047 0.0020 0.0019 1.1304 1990-1991 1.0000 0.1003 0.0142 0.0250 0.0032 0.0007 0.0013 1.1447 1991-1992 1.0000 0.0935 0.0133 0.0251 0.0028 0.0010 0.0058 1.1415 SOURCE: ALAMEDA COUNTY OFFICE OF THE AUDITOR-CONTROLLER i 78 CITY OF DUBLIN COMPUTATION OF LEGAL DEBT MARGIN JUNE 30, 1992 Assessed valuation : Assessed value $1,382,524,556 Add back exempt real property 45,564,903 Total Assessed Value $1,428,089,459 Legal debt margin : Debt limitation- 15 percent of total assessed value $214,213,419 Percent of debt limit authorized and issued 0.00% SOURCE: CITY OF DUBLIN FINANCE DEPARTMENT EXCLUDES CERTIFICATES OF PARTICIPATION AND 1915 ACT BONDS SINCE THEY ARE NOT GENERAL OBLIGATION DEBT. 79 CITY OF DUBLIN COMPUTATION OF DIRECT AND OVERLAPPING DEBT JUNE 30, 1992 NET DEBT PERCENTAGE OUTSTANDING APPLICABLE APPLICABLE TO CITY OF TO CITY JURISDICTION DUBLIN OF DUBLIN Alameda County Authorities 2.215 $6,797,148 Alameda County Superintendent of Schools 2.215 172,992 Oakland-Alameda County Coliseum Authority 1.108 150,731 Bay Area Rapit Transit District 0.855 2,397,634 Alameda County Flood Control District, Zone#7 12.920 71,706 Dublin Joint Unified School District • ' 98.904 3,436,914 Amador Valley Joint Union High School District 98.904 124,964 Murray School District 98.904 294,709 East Bay Regional Park District 1.274 741,341 Bay Area Pollution Control Authority 0.396 455 City of Dublin Certificates of Participation 100.000 16,365,000 City of Dublin 1915 Act Bonds 100.000 2,845,000 TOTAL GROSS DIRECT AND OVERLAPPING BONDED DEBT 33,398,594 LESS:OAKLAND-ALAMEDA COUNTY COLISEUM AUTHORITY (100% SELF-SUPPORTING) 150,731 TOTAL $33,247,863 (1)Excludes tax and revenue anticipation notes; revenue,mortgage revenue and tax allocation bonds; and non-bonded capital lease. STATE SCHOOL BUILDING AID REPAYABLE AS OF 6/30/92: $883,469 SOURCE: CALIFORNIA MUNICIPAL STATISTICS, INC. AND CITY FINANCE DEPARTMENT. 80 CITY OF DUBLIN DEMOGRAPHIC STATISTICS LAST TEN FISCAL.YEARS ALAMEDA CITY RANK IN SIZE FISCAL COUNTY POPULATION OF CALIFORNIA YEAR POPULATION• POPULATION % OF COUNTY CITIES 1982-1983 . * 1,132,300 .*_ 1983-1984 15,100 1,149,200 1.31% 230 1984-1985 15,500 1,166,800 1.33% 232 1985-1986 15,450 . 1,181,000 1.31% 237 1986-1987 17,650 1,201,400 1.47% . 231 1987-1988. 20,850 1,214,200 1.72% 218 1988-1989 21,950 - 1,234,900 1.78% 221 1989-1990 23,550 1,252,600 1.88% 220 1990-1991 23,500 1,293,000 1.82% 230 1991-1992 25,162 1,313,300 1.92% 222 *INFORMATION NOT AVAILABLE SOURCE: STATE OF CALIFORNIA DEPT,OF FINANCE-POPULATION RESEARCH UNIT 81 • • CITY OF DUBLIN PROPERTY VALUE, CONSTRUCTION AND BANK DEPOSITS LAST TEN FISCAL YEARS • TOTAL COMMERCIAL RESIDENTIAL FISCAL NUMBER OF CONSTRUCTION CONSTRUCTION • BANK YEAR PERMITS ISSUED . VALUE •VALUE DEPOSITS 1982-1983 529 $7,048,317 $24,784,393 • $164,428,000 1983-1984 525 3,461,360 7,245,025 232,571,000 1984-1985 768 16,093,749 18,991,926 247,622,000 1985-1986 868 17,720,298 90,012,961 294,462,000 1986-1987 1,193 11,784,734 44,889,395 336,751,000 1987-1988 1,068 12,777,965 52,580,666 378,557,000 • 1988-1989 901 13,654,511 15,911,836 399,923,000 1989-1990 910 6,367,726 30,536,676 439,781,000 1990-1991 752 7,604,547 8,074,458 450,215,000 1991-1992 798 9,759,533 5,005,547 + •INFORMATION NOT AVAILABLE SOURCES:FINDLEY REPORTS, INC. AND CITY BUILDING DEPARTMENT STATUS REPORTS 82 CITY OF DUBLIN MISCELLANEOUS STATISTICAL DATA JUNE 30, 1992 Date of Incorporation February 1982 Education: - Form of Government Council/Manager I. Public: Employees 101 . Elementary Schools 3 Population 25,162 Middle School 1 Area - 8 Sq. Miles High School 1 Miles of streets 52.60 Continuation 1 Miles of Curbs 124.70 Teachers 158 Signaled Intersections 20 Elementary Classrooms 54 Number of Street Lights 1,697 Middle School Classrooms 39 Average Daily Trips on I-680 95,500 High School Classrooms 41 Average Daily Trips on I-580 140,000. Continuation School Classrooms 5 Fire Protection: Students Enrolled: Dougherty Regional Fire Authority- September 1982 3,643 Number of Stations 2 September 1983 3,442 Number of Fire Personnel 50 September 1984 3,354 September 1985 3,326 Police Protection: September.1986 3,407 Number of Stations 1 September 1987 3,499 Number of Police Officers 28 September 1988 3,213 Number of Support Personnel 3.5 September 1989 3,135 September 1990 3,150 September 1991 3,173 September 1992 3,379 Parks and Recreation: Parks - 9 II. Private Schools: Arcres in Parks 147 Valley Christian: Elementary 521 Junior High 122 High 152 Valley Lutheran Elementary 150 St. Raymonds Elementary 247 Number of Registered Voters 11,306 Community Facilities: Dublin Civic Center Dublin Senior Center Dublin Shannon Center Dublin Swim Center Dublin Sports Grounds Source: City and School District Records 8 3 CITY OF DUBLIN SCHEDULE OF 1985 CERTIFICATES OF PARTICIPATION COVERAGE - FISCAL YEARS 1985-1988 NET REVENUE DEBT SERVICE DIRECT AVAILABLE REQUIREMENTS FISCAL GROSS OPERATING FOR DEBT YEAR REVENUE(1) EXPENSES(2) SERVICE PRINCIPAL INTEREST TOTAL COVERAGE 1985-1986 $667,811 $667,811 $667,811 $667,811 100.000% 1986-1987 1,815,555 $443,194 -1,372,361 $173,000 1,078,080 1,251,080 109.694% 1987-1988 13,180,797 27,216 13,153,581 11,795,000 (3) 1,066,403 12,861,403 102.272% (1)GROSS REVENUE INCLUDES RENT, INTEREST INCOME AND 1985 CERTIFICATES OF PARTICIPATION PROCEEDS EARMARKED FOR DEBT SERVICE. THE 1987-1988 TOTAL INCLUDES$11,615,000 PRINCIPAL AMOUNT OF 1988 CERTIFICATES OF PARTICIPATION PROCEEDS USED TO DEFEASE THE 1985 CERTIFICATES OF PARTICIPATION. - (2)DIRECT OPERATING EXPENSES EXCLUDES INTEREST AND DEPRECIATION - (3)INCLUDES$11,615,000 PRINCIPAL AMOUNT OF 1985 CERTIFICATES OF PARTICIPATION DEFEASED IN 1988 AND NO LONGER THE CITY'S DEBT SOURCE: CITY OF DUBLIN ANNUAL FINANCIAL REPORT 84 'i CITY OF DUBLIN SCHEDULE OF 1988 CERTIFICATES OF PARTICIPATION COVERAGE LAST FOUR FISCAL YEARS NET REVENUE DEBT SERVICE - DIRECT AVAILABLE REQUIREMENT FISCAL GROSS OPERATING FOR DEBT YEAR REVENUE(1) EXPENSES(2) SERVICE PRINCIPAL INTEREST(3) TOTAL COVERAGE 1988-1989 $1,547,681 $33,328 $1,514,353 $1,178,501 $1,178,501 128.50% 1989-1990 1,452,254 30,945 1,421,309 1,282,483 1,282,483 110.82% 1990-1991 1,740,720 42,264 1,698,456 $420,000 1,254,131 1,674,131 101.45% 1991-1992 1,735,357 45,609. 1,689,748 445,000 1,240,333 1,685,333 100.26% (1)GROSS REVENUE INCLUDES FACILITIES RENT, INTEREST INCOME AND 1988 CERTIFICATES OF PARTICIPATION PROCEEDS EARMARKED FOR DEBT SERVICE.. . (2)DIRECT OPERATING EXPENSES EXCLUDES INTEREST AND DEPRECIATION . (3)EXCLUDES AMORTIZATION OF BOND DISCOUNT . SOURCE: CITY OF DUBLIN ANNUAL FINANCIAL REPORT 85 . CITY OF DUBLIN CALIFORNIA PUBLIC EMPLOYEES RETIREMENT SYSTEM FUNDING ANALYSIS FISCAL YEARS 1986-1991 PERCENT OF OVERFUNDED PENSION BENEFIT OVERFUNDED OBLIGATION NET ASSETS PENSION PENSION ANNUAL TO ANNUAL FISCAL AVAILABLE BENEFIT PERCENT BENEFIT COVERED COVERED YEAR FOR BENEFITS OBLIGATION FUNDED OBLIGATION PAYROLL PAYROLL 1986-1987 $224,510 $193,490 116.03% $31,020 $641,910 4.83% 1987-1988 331,670 321,820 103.06% 9,850 818,530 1.20% '- 1988-1989 485,870 433,477 112.09% 52,393 1,034,010 5.07% 1989-1990 673,728 582,374 115.69% 91,354 1,241,152 7.36% 1990-1991 871,272 718,724 121.22% 152,548 1,507,749 10.12% • THE ABOVE INFORMATION WAS NOT AVAILABLE FOR YEARS PRIOR TO 1986 OR FOR FISCAL YEAR 1992. SOURCE:CALFORNIA PUBLIC EMPLOYEES RETIREMENT SYSTEM. (PERS) 86 CITY OF DUBLIN PROPERTY TAX LEVIES AND COLLECTIONS LAST NINE FISCAL YEARS PERCENT OF TOTAL TOTAL TAX PROPERTY PROPERTY COLLECTED FISCAL TAX TAX TO TAX YEAR LEVIED - COLLECTED = LEVIED 1983-1984 $363,804 $346,406 95.22% 1984-1985 399,650 380,095 95.11% 1985-1986 467,835 444,612 95.04% 1986-1987 553,730 523,149 94.48% 1987-1988 618,512 590,860 95.53% 1988-1989 2,915,555 2,797,473 95.95% 1989-1990 3,286,145 3,149,417 95.84% • 1990-1991 3,570,018 3,399,795 95.23% 1991-1992 3,860,349 3,611,824 93.56% THE CITY WAS INCORPORATED IN FEBRUARY 1982. NO PROPERTY TAX WAS ALLOCATED TO THE CITY PRIOR TO THAT YEAR. THE CITY ACQUIRED THE RESPONSIBILITY FOR PARKS MAINTENANCE, FIRE PROTECTION SERVICES AND THE RELATED PROPERTY TAXES IN FISCAL YEAR 1988-1989 SOURCE: ALAMEDA COUNTY AUDITOR-CONTROLLER OFFICE 87 CITY OF DUBLIN PRINCIPAL TAXPAYERS JUNE 30, 1992 PERCENT OF TOTAL ASSESSED ASSESSED TAXPAYER VALUE VALUE Metric Institutional Company Investment Partners $20,798,051 1.6177% Dublin Meadow Partners 19,419,331 1.5105% Cottonwood Associates 18,522,712 1.4407% Amador Lakes Associates III 17,829,838 1.3868% Rafanelli&Nahas&VM Rafaenelli Vineyards 16,892,169 1.3139% Sierra Dublin Properties 16,050,535 1.2484% Phoenix Mutual Life Insurance Company 14,656,026 1.1400% Dublin Associates 14,522,856 1.1296% Bedford Peter B. and Kirsten N. 13,175,917 1.0248% _. Chevron U.S.A. Inc. 12,557,320 0.9767% Total $164,424,755 12.7892% SOURCE: COUNTY OF ALAMEDA 88 e CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF JUNE 1992 FINAL (Revised - 10/23/92) prepared by The Finance Department . c... 'f, '~e,r '5 ~:L E' e~'THI~~~1,..~n J ' ~"4;l~ ~j' P ~l . ':t 'r"" .; to ,,,, "" ".... ~', .</'1... i' ~,;! ;. .1 ...." iL;;; ,!"Ok! Ii :I e e BGLl02 CITY OF DOBLIlI PAGE 1 10/23/92 BALAlICE SHEET 15.43.06 FOR THE PERIOD 7/91 THROOGH 6/92 GE1IERAL SPECIAL SPECIAL CAPITAL TOT A L S REVEl/UE REVENUE ASSESSMElIT IMPROVEHEIlT --- MEHOlUlIDOM OIlLY--- FmlDS FUl/DS FUllDS FUlIDS CURRElIT mlE 30, 1991 ASSETS CASH 2278043.28- 486756.50 1265009.04 326150.80 200126.94- 275174.23- CASH WITH FISCAL AGENT 117500.00 117500.00 UllAMORTIZED BOl/D DIscounT 1250.00 1250.00 1562.50 IIIVESTMffilTS AT COST 17961688.77 150356.44 1087126.67 19199171.88 16904999.00 RECEIVABLES: TAXES 38057.08 534.88 38591.96 ACCOUNTS (NET) 217326.52 2579.21 1278.52 221184. 25 INTEREST 242570.02 41651.34 284221.36 ASSESSMENTS 270572.83 RENTS 1I0TES DUE FROM OTHERS 355100.98 355100.98 283673.53 INVENTORY AT coST PREPAID ITEMS 1938.67 1938.67 5808.31 FIXED ASSETS ~.HOmITS TO BE PROVIDED 2232500.00 2232500.00 TOTAL ASSETS 16539888.76 489335.71 3765900.36 1456207.33 22251332.16 17191441.94 LUB, FND BAL, RETlID EARlIIlIGS DEPOSITS FOR PRIVATE DEVELPMlIT 40030.63 40030.63 301871. 37- DEPOSITS FOR AB1600 FEES 95865.04- 95865.04- 133094.40- DEPOSITS OTHERS 165180.77- 3125.00- 168305.77- 131896.34- PAYABLES:ACCOUNTS 898537.51- 151999.97- 40145.09- 471955.14- 1562637.71- 109874.00- IlITEREST PAYROLL 96771.29- 96771.29- 392.09- DUE TO OTHERS 24649.79- 353600.98- 1500.00- 379750.77- 297808.45- DEBT IlISTRUMEIlTS PAYABLE 2845000.00- 2845000.00- 605000.00- TOTAL LIABILTIES 1145108.73- 505600.95- 2889770.09- 567820.18- 5108299.95- 1579936.65- FUlID BAIJJICES 15394780.03- 16265.24 876130.27- 888387.15- 17143032.21- 15611505.29- TOTAL FUlID EQUITY 15394780.03- 16265.24 876130.27- 888337.15- 17143032.21- 15611505.29- TOTAL LIAB,FMD BAL, RETD EARNS 16539888.76- 489335.71- 3765900.36- 1456207.33- 22251332.16- 17191441. 94- e e PAGE 1 BGLl02 CITY OF DOBLIU 10/23/92 BAL.~llCE SHEET 16.52.28 FOR THE PERIOD 7/91 THROUGH 6/92 IlITERUAL ElrrERPRISE FIXED ASSETS GEUERAL LOJlG TOT A. L S SERVICE FUlIDS GROUP OF TERM DEBT --- MEMORAIIDUM OIlLY --- FUND ACCOmlTS ACCOUlIT GROUP CURRElIT JUliE 30 I 1991 ASSETS CASH 358333.50 358333.50 258382.85 CASH WITH FISCAL AGENT 1720935.93 1720985.93 1714537.60 illlAMORTIZED oolID DIscomlT IUVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (!lET) IIITEREST 64500.15 64500.15 44632.03 ASSESSHEIITS REllTS 1I0TES DUE FROM OTHERS INVEHTORY AT COST PREPAID ITEMS 108.75 1724.03 1832.78 10340.03 FIXED ASSETS 110488.69 21420859.73 459282.53 21990630.95 22935088.12 AHOUlITS TO BE PROVIDED 2285000.00 2285000.00 TOTAL ASSETS 468930.94 23208069.84 459282.53 2285000.00 26421283.31 24962980.63 LIABI FIID BALI RETND EARllIlfGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:ACCOUllTS 4821.07- 1464.10- 6285.17- 108310.00- IltTEREST P.~YROLL DUE TO OTHERS DEBT IlISTRUMElITS PAYABLE 16556062.08- 2285000.00- 18841062.08- 17320767.00- TOTAL LIABILITIES 4821.07- 16557526.18- 2285000.00- 18847347.25- 17429077.00- FUlID BALAlICE 348111.69- 1547420.66- 1895532.35- 1964669.65- CONTRIBUTIONS 115998.18- 5103123.00- 5219121. 18- 5197401.00- IlIVESTMEIITS III FIXED ASSETS 459282.53- 459282.53- 379709.98- RETAIllED EARllIIlGS TOTAL FUlID EQUITY 464109.87- 6650543.66- 459282.53- 7573936.06- 7533903.63- TOTAL LIABIFIID BALI RETD EARlIS 468930.94- 23208069.84- 459282.53- 2285000.00- 26421283.31- 2~962980.63- e e BGLl04 THE CITY OF DUBLIlI STATEHEIIT SHOWIlIG Pi\.GE 1 10/23/92 REVENUES VERSUS EXPEllDITURE 15.16.01 FOR THE PERIOD 7/91 THROUGH 6/92 GENERAL REVElIUE FunD CURRElIT PERIOD PREVIOUS PERIOD 91 BUDGET ACTUp], PERCElIT VARIAlICE BUDGET ACTUAL PERCElIT Vp.RIAlICE ******** REVEnUES ** * **** PROPERTY TAXES 4034100.00- 3807251.35- 94.4 226848.65- 3704500.00- 3543516.91- 95.7 160983.09- SALES TAX 6300000.00- 5293709.47- 84.0 1006290.53- 5700000.00- 5749728.72- 100.9 49728.72 REAL PROPERTY TRAlISFERS 76000.00- 62318.57- 82.0 13681. 43- 76000.00- 67577.31- 88.9 8422.69- TlWlSIENT OCCUPANCY TAX 100000.00- 93958.00- 94.0 6042.00- 106000.00- 99646.00- 94.0 6354.00- FRAllCRISE TAXES 434500.00- 443012.78- 102.0 8512.78 389900.00- 407128.53- 104.4 17228.53 LICENSES & PERHITS 474700.00- 246458.50- 51.9 228241 .50- 408100.00- 248841. 31- 61.0 159258.69- FINES & FORFEITURES 19500.00- 25780.28- 132.2 6280.28 20000.00- 19476.34- 97.4 523.66- USES OF MONEY AIlD PROPERTY 1091100.00- 1038502.77- 95.2 52597.23- 1211870.00- 1253699.99- 103.5 41829.99 IlrrERlIGOVERllJ.IEllTAL FROM STATE 939366.00- 864646.98- 92.0 74719.02- 1027260.00- 969735.21- 94.4 57524.79- CELljGES FOR SERVICES 1209905.00- 939833.28- 77.7 270071.72- 1164816.00- 1022906.34- 87.8 141909.66- OTHER SOURCES OF REVENUE 54600.00- 258944.33- 474.3 204344 .33 97500.00- 171538.63- 175.9 74038.63 TOT>.L REVENUE 14733771.00- 13074416.31- 83.7 1659354.69- 13905946.00- 13553795.29- 97.5 352150.71- *******EXPEIIDITURES******* GElIERAL C-OVERlfHE1IT ACTIVITI ES: 1101l- DEPARTHElfr AL 388867.00 289508.41 74.4 99358.59 738212.00 778118.37 105.4 39906.37- CITY COOlICIL 1010 159669.00 123424.14 77.3 36244.86 121778.00 101469.28 83.3 20308.72 CITY MANAGER 1020 506645.00 460780.40 90.9 45864.60 430061.00 392999.26 91.4 37061. 74 CITY ATTORlIEY 1030 196450.00 206533.31 105.1 10083.31- 165000.00 156831. 81 95.0 8168.19 FIlIAlICE DEPARTMENT 1040 247049.00 224100.76 90.7 22948.24 220516.00 200000.06 90.7 20515.94 DATA PROCESSING (FIll) 1045 35500.00 6253.04 17.6 29246.96 .00 .00 .00 BUILDING HAlIAGEHElIT 1050 363220.00 331685.55 91.3 31534. 45 320610.00 284364.04 88.7 36245.96 FACILITY RENTAL 1050-719 1720670.00 1544702.17 89.8 175967.83 1719820.00 1579472.05 91.8 140347 .95 INSURAlICE COST CEIITER 1060 166600.00 145934.30 87.6 20665.70 177500.00 136307.04 76.8 41192.96 ELECT lOllS COST CElITER 1070 3000.00 2997.25 99.9 2.75 3825.00 3066.03 80.2 758.97 ACTIVITY TOTAL 3787670.00 3335919.33 88.1 451750.67 3897322.00 3632627.94 93.2 264694.06 PUBLIC SAFETY: POLlCE 2010 2794073.00 2752425.36 98.5 41647 . 64 2581151.00 1870151.63 72.5 710999.37 CROSSIlIG GUARDS COST 2020 33120.00 33141.31 100.1 23.31- 8000.00 1366.41 17 .1 6633.57 AlIIHAL COllTROL 2030 56000.00 39120.27 69.9 16879.73 54330.00 49398.89 90.9 4931.11 TRAFFIC SIGlIALS 2040 73550.00 72969.12 99.2 580.88 .00 .00 .00 DISASTER PREAPREDNESS 2050 42085.00 31369.60 74.5 10715.40 30735.00 11456.07 37.3 19278.93 FIRE SERVICES JPA 2060 2578993.00 2475828.00 96.0 103165.00 2295338.00 2203524.00 96.0 91814 .00 ACTIVITY TOTAL 5577821.00 5404855.66 96.9 172965.34 4969554.00 4135897.02 83.2 833656.98 TRAlISPORTATIOll : PUBLIC WORKS 3010 282015.00 267077.61 94.7 14937.39 260494.00 235587.43 90.4 24906.57 STREET HAIlITElIAIICE 3020 328100.00 269134.03 82.0 58965.97 64200.00 35785.41 55.7 28414. 59 STREET SWEEPIlIG 3030 62000.00 61454.50 99.1 545.50 62000.00 55096.50 88.9 6903.50 STREET TREE HAnITEll~.NCE 3040 66500.00 46090.36 69.3 20409.64 67000.00 54184.47 80.9 12815.53 STREET UJIDSCAPE HAIlIT. 3050 208850.00 196157.46 93.9 12692.54 182500.00 161451. 53 88.5 21048.47 PARATRJ1ISIT SERVICES 3060 1500.00 1500.00 100.0 .00 1500.00 1500.00 100.0 .00 ACTIVITY TOTAL 948965.00 841413.96 88.7 107551. 04 637694.00 543605.34 85.2 94088.66 HEALTH & WELFARE: VECTOR COlITROL 5010 28296.00 21394.00 75.6 6902.00 27010.00 19707.75 73.0 7302.25 WASTE HAllAGEHEllT 5020 33255.00 8131. 95 24.5 25123.05 .00 .00 .00 ACTIVITY TOTAL 61551.00 29525.95 43.0 32025.05 27010.00 19707.75 73.0 7302.25 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 156007.00 156007.00 100.0 .00 149650.00 149650.00 100.0 .00 e e GL104 THE CITY OF DUBLIU STATEMEUT SHOWIllG PAGE 2 10/23/92 REVEllUES VERSUS EXPENDITURE 15.16.01 FOR THE PERIOD 7/91 THROOGH 6/92 GEIlERAL REVElIUE FUlID CURREIIT PERIOD PREVIOUS PERIOD 91 BUDGET ACTUAL PERCElIT V}JUH1CE BUDGET ACTUAL PERCElIT V}.RIMICE CULTURAL ACTIVITIES 8011 44140.00 24137.36 54.7 20002.64 32785.00 .00 32785.00 PARK MAIllTENAlICE 8020 545270.00 552453.63 101. 3 7183.63- 518570.00 425494. 77 82.1 93075.23 COMMUNITY CABLE TV 8030 49000.00 49000.00 100.0 .00 46000.00 46000.00 100.0 .00 RECREATION ADMIlI. 8040 171625.00 158732.32 92.5 12892.68 154760.00 139767.99 90.3 14992 .01 PLAYGROUUDS 8045 66924.00 64679.53 96.6 2244.47 67030.00 64201. 25 95.8 2828.75 SlVllliON CENTER 8050 105787.00 99301.55 93.9 6485.45 94861.00 93065.75 98.1 1795.25 PRESCHOOL 8055 32194.79 31914.44 99.1 280.35 28877.00 27627.27 95.7 1249.73 TEEIlS PROGRAM 8060 47185.00 29761.10 63.1 17423.90 44881.00 23768.17 53.0 21112.83 FIELD SCHEDULIUG 8065 133395.00 105795.55 79.3 27599.45 124931. 00 88360.71 70.7 36570.29 YOUTH SPORTS 8066 31739.00 22599.57 71. 2 9139.43 .00 .00 .00 SPECIAL EVEllTS 8070 27791.00 23936.79 86.1 3854.21 25140.00 21503.64 85.5 3636.36 SElIIOR CENTER 8080 104120.00 95734.44 91.9 8385.56 96401.00 82095.67 85.2 14305.33 RECREATIOU IUSTRUCTION 8090 76921.00 82678.01 107.5 5757.01- 62090.00 51750.01 83.3 10339.99 AQUATICS 8100 192225.00 185531.76 96.5 6693.24 152051. 00 147754.45 97.2 4296.55 ACTIVITY TOTAL 1784323.79 1682263.05 94.3 102060.74 1598027.00 1361039.68 85.2 236987.32 COHHUlUTY DEVELOPHEllT: PIJ.JilIIllG 9010 1050075.00 950525.99 90.5 99549.01 1261937.00 967660.05 76.7 294276.95 BUILDIIIG SAFETY 9020 326796.00 261821. 47 80.1 64974.53 365584.00 327261. 84 89.5 38322.16 EllGIIIEERIlIG 9030 429791. 00 220206.61 51.2 209584.39 429992.00 358644.55 83.4 71347.45 ECOIIOMIC DEVELOPMENT 9040 57250.00 5920.47 10.3 51329.53 83606.00 11106.09 13.3 72499.91 ACTIVITY TOTAL 1863912.00 1438474.54 77.2 425437.46 2141119.00 1664672.53 77.7 476446.47 CAPITAL IMPROVEMEIlT PROJECTS: GENER.~L CIP PROJECTS 931m 88850.00 3902.22 4.4 84947.78 160815.00 25666.69 16.0 135148.31 COMMUlIITY IMPROVEMENTS 94111I 67300.00 60566.29 90.0 6733.71 125681.00 120064.59 95.5 5616.41 PARKS 951111 194162.00 122822.27 63.3 71339.73 776997.00 500185.16 64.4 276811. 84 STREET CONSTRC/IHPROv1tT 961nl 235958.00 44584.38 18.9 191373.62 1851847.00 219224.40 11.8 1632622.60 ACTIVITY TOTAL 586270.00 231875.16 39.6 354394.84 2915340.00 865140.84 29.7 2050199.16 TOT A L EXPDIDITURES 14610512.79 12964327.65 88.7 1646185.14 16186066.00 12222691.10 75.5 3963374.90 EXCESS <REVEllUE>EXPEIIDITURES 123258.21- 110088.66- 89.3 13169.55- 2280120.00 1331104.19- 58.4- 3611224.19 TR.~lISFERS IN FROM OTHER FUlIDS .00 15022.96- 15022.96 .00 .00 .00 TRAlISFERS OUT TO OTHER FUlIDS .00 50063.67 50063.67- .00 .00 .00 EXCESS <REVEIIOE> EXPEIIDITURE 123258.21- 75047.95- 60.9 48210.26- 2280120.00 1331104.19- 58.4- 3611224.19 e e BGL104 THE CITY OF DOBLIlI STATEHEIIT SHOWING PAGE 1 10/23/92 REVElmES VERSUS EXPEIIDITURE 15.13.36 FOR THE PERIOD 7/91 THROUGH 6/92 SPECIf..L REVEIIUE FillfDS CUR RElIT PERIOD PREVIOUS PERIOD 91 BUDGET ACTUJ..L PERCENT VARmlCE BUDGET J..CTm.L PERCElIT VJ..RWICE ********REVENUES******* SALES TAX 114000.00- 105434.20- 92.5 8515.80- 109000.00- 108156.42- 99.2 843.58- FINES & FORFEITURES 15250.00- 32720.99- 214.6 17470.99 80000.00- 62891.45- 78.6 17108.55- USES OF MONEY AND PROPERTY 19360.00- 20220.85- 104.4 860.85 41950.00- .00 41950.00- nrrERlIC,QVER1IMElrrAL FROM STATE 797071.00- 735974.36- n.3 61096.64- 1051569.00- 862740.93- 82.0 183828.07- IlITERGOVER1IHElITAL FROH FEDERAL 987339.00- 889144.24- 90.1 98194.76- 1373880.00- 230745.80- 16.8 1143134.20- CHARGES FOR SERVICES 132065.00- 145417.33- 110.1 13352.33 .00 .00 .00 arIlER SOURCES OF REVEllUE 596300.00- 442094.00- 74.1 154206.00- 339000.00- 13109.03- 3.9 325890.97- TOTAL REVEIIUE 2661385.00- 2371055.97- 89.1 290329.03- 2995399.00- 1277643 .63- 42.7 1717755.37- *******EXPENDITURES******* GElIERAL GOVERlIMElIT ACTIVITIES: 1I0N-DEPARTHEIITAL 23781. 00 .00 28781.00 .00 .00 .00 CITY comlCIL 3142.00 3142.00 100.0 .00 5492.00 3904.25 71.1 1587.75 ACTIVITY TOTAL 31923.00 3142.00 9.8 28781.00 5492.00 3904.25 71.1 1587.75 PUBLIC SAFETY: POLICE 13295.00 6352.78 47.8 6942.22 20150.00 11913.09 59.1 8236.91 CROSSING GuARDS COST .00 .00 .00 24125.00 24125.00 100.0 .00 TR.1l.FFIC SIGlIJ...LS 15250.00 15250.00 100.0 .00 78000.00 73197.32 93.8 4802.68 ACTIVITY TOTAL 28545.00 21602.73 75.7 6942.22 122275.00 109235.41 89.3 13039.59 TlUlISPORTATION: STREET MAIlrrENAlICE 151300.00 120091. 02 79.4 31208.98 381200.00 268040.84 70.3 113159.16 ACTIVITY TOTAL 151300.00 120091.02 79.4 31208.98 381200.00 268040.84 70.3 113159.16 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMHUlIITY DEVELOPMENT: PLAlnlIlIG .00 5000.00 5000.00- .00 .00 .00 E1IGINEERING 132365.00 98960.52 74.8 33404.48 5000.00 5000.00 100.0 .00 AcrIVITY TOTAL 132365.00 103960.52 78.5 28404.48 5000.00 5000.00 100.0 .00 CAPITAL IMPROVEMEIIT PROJECTS: COIDIUlIITY IHPROVnlElITS 35024.00 33972.00 97.0 1052.00 72254.00 40834.33 56.5 31419.67 PJ..RKS 437078.00 173336.01 39.8 263241. 99 333711.00 645299.54 190.5 306583.54- STREET COIISTRUCTIOll/IHPROVHT 1709665.00 1268958.14 74.2 440706.86 1022704.00 1221033.33 119.4 198329.33- ACTIVITY TOTAL 2181767.00 1476766.15 67.7 705000.85 1433669.00 1907167.20 133.0 473498.20- TOT A L EXPEIIDITL~ES 2554681. 00 1725562.47 67.5 829118.53 1947636.00 2293347.70 117.8 345711. 70- EXCESS <REVEIIUE>EXPENDITURE 135485.00- 645493.50- 476.4 510008.50 1047763.00- 1015704.07 96.9- 2063467.07- TRf.JISFERS OUT TO OTHER FUIIDS .00 15022.96 15022.96- .00 .00 .00 EXCESS <REVEIIUE> EXPEh~ITURE 135485.00- 630470.54- 465.3 494985.54 1047763.00- 1015704.07 96.9- 2063467.07- e e PAGE BGL104 THE CITY OF DUBLIN STATEMENT SHOWING 1 10/23/92 REVElIUES VERSUS EXPElIDITURE 15.23.25 FOR THE PERIOD 7/91 THROUGH 6/92 SPECIAL ~.SSESSMElIT FUllDS CURRElIT PERIOD PREVIOUS PERIOD 91 BUDGET ACTU>.L PERCENT VARIANCE BUDGET ACTUJ..L PERCElIT VJ..RIAlICE ********REVENUES******* SPECIAL BENEFITS ASSESSHElffS 391430.00- 380716.70- 97.3 10713.30- 370535.00- 539761.26- 145.7 169226.26 USES OF HOllEY AlID PROPERTY 17400.00- 66656.63- 383.1 49256.63 55600.00- .00 55600.00- OTHER SOORCES OF REVENUE 7000.00- 39804.87- 568.6 32804.87 5000.00- 3968.88- 79.4 1031.12- TOTAL REVEllUE 415830.00- 487178.20- 117.2 71348.20 431135.00- 543730.14- 126.1 112595.14 *******EXPE1IDITURES******* GElIERAL GOVERllMEIlT ACTIVITIES: liON-DEPARTMENTAL 103813.00 95812.50 92.3 8000.50 108419.00 108418.75 100.0 .25 FItIAlICE DEPARTMENT .00 1076.00 1076.00- .00 .00 .00 ACTIVITY TOTAL 103813.00 96888.50 93.3 6924.50 108419.00 108418.75 100.0 .25 PUBLIC SAFETY: TRFC SIGS/STREET LIGHTING 173550.00 169486.81 97.7 4063.19 160650.00 139428.13 86.8 21221. 87 ACTIVITY TOTAL 173550.00 169486.81 97.7 4063.19 160650.00 139428.13 86.8 21221.87 TR.llJISPORTATIOII : STREET TREE MAIImNlillCE 13100.00 4883.23 37.3 8216.77 13500.00 4214.76 31.2 9285.24 STREET LANDSCAPE MAINTENAlICE 100880.00 116986.77 116.0 16106.77- 112990.00 92133.36 81.5 20856.64 ACTIVITY TOTAL 113980.00 121870.00 106.9 7890.00- 126490.00 96348.12 76.2 30141. 88 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMONITY DEVELOPHElff: ElIGIllEERING 11000.00 8995.62 81.8 2004.38 12000.00 9600.05 80.0 2399.95 ACTIVITY TOTAL 11000.00 8995.62 81.8 2004.38 12000.00 9600.05 80.0 2399.95 C~.PITAL IMPROVEMEllT PROJECTS: STREET COllSTRUCTION/IHPROVHT 1534400.00 37888.66 2.5 1496511.34 .00 .00 .00 ACTIVITY TOTAL 1534400.00 37888.66 2.5 1496511. 34 .00 .00 .00 TOT A L EXPENDITURES 1936743.00 435129.59 22.5 1501613.41 407559.00 353795.05 86.8 53763.95 EXCESS<REVENUE> EXPEIIDITURE 1520913.00 52048.61- 3.4- 1572961. 61 23576.00- 189935.09- 805.6 166359.09 TRAIlSFERS IN FROM OTHER FUNDS .00 .00 .00 .00 2502.65- 2502.65 EXCESS <REVFJlUE> EXPEllDITURE 1520913.00 52048.61- 3.4- 1572961.61 23576.00- 192437.74- 816.2 168861.74 e e BGL104 THE CITY OF DUBLIN STATEMElrr SHOWING PAGE 1 10/23/92 REVENUES VERSUS EXPEllDITURE 15.37.59 FOR THE PERIOD 7/91 THROUGH 6/92 CAPITAL IHPROVEMEIlT FUlID CURRElIT PERIOD PREVIOUS PERIOD 91 BUDGET ACTUAL PERCFllT VARIAlICE BUDGET ACTUAL PERCENT V>.RWICE ********REVENUES******* USES OF MONEY AND PROPERTY 3200.00- 50156.90- 1567.4 46956.90 2000.00- .00 2000.00- OTHER SOURCES OF REVENUE 1090442.00p 4559161.67p 418.1 3468719.67 859565.00- 76090.17- 8.9 783474.83- TOTAL REVENUE 1093642.00- 4609318.57- 421.5 3515676.57 861565.00- 76090.17- 8.8 785474.83- *******EXPEllDITURES******* GEllERAL C-OVERllMEllT ACTIVITIES: 1I01l-DEPARTMElITAL .00 1181258.00 1181258.00- .00 .00 .00 ACTIVITY TOTAL .00 1181258.00 1181258.00- .00 .00 .00 PUBLIC SAFETY: TRAlISFORTATIOlI : HFJ.LTH & WELFARE: CULTURE & LEISURE SERVICES: COHMIDIITY DEVELOPMENT: C.\PITAt IMPROVEMENT PROJECTS: COMHUlIITY UIPROVEMENTS .00 .00 .00 9000.00 9000.00 100.0 .00 PARKS 49592.00 57433.10 115.8 7841.10- 177936 .00 177996.88 100.0 60.88- STREET COllSTRUCTION/IMPROVHT 3237195.00 2320707.39 71.7 916487.61 2449629.00 82352.78 3.4 2367276.22 >.CTIVITY TOTAL 3286787.00 2378140.49 72.4 908646.51 2636565.00 269349.66 10.2 2367215.34 TOT A L EXPEIIDITURES 3286787.00 3559398.49 108.3 272611. 49- 2636565.00 269349.66 10.2 2367215.34 EXCESS<REVEIIUE> EXPENDITURE 2193145.00 1049920.08- 47.9- 3243065.08 1775000.00 193259.49 10.9 1581740.51 TRAlISFERS III FROM OTHER FUlIDS .00 2452.84- 2452.84 .00 .00 .00 TRJJISFERS OUT TO OTHER FIDIDS .00 .00 .00 .00 2502.65 2502.65- EXCESS <REVEIWE> EXPENDITURE 2193145.00 1052372.92- 48.0- 3245517.92 1775000.00 195762.14 11.0 1579237.86 ,.. I ,', . e e BGL104 TllE CITY OF DUBLIlI STATEMENT SHOWING PAGE 1 10/23/92 REVENUES VERSUS EXPElfDITURE 15.33.38 FOR THE PERIOD 7/91 THROUGH 6/92 EtlTERPRISE FUNDS CURRElIT PERIOD PREVIOUS PERIOD 91 BUDGET ACTUAL PERCEnT VARIAnCE BUDGET ACTUAL PERCEnT V~.RmlCE *** *****REVEHUES** * ** ** USES OF HOllEY AIID PROPERTY 1862699.00- 1685336.67- 90.5 177362.33- 1841487.00- 1579379.05- 85.8 262107.95- OTHER SOURCES OF REVEnUE .00 2410.03- 2410.03 .00 .00 .00 TOTAL REVENUE 1862699.00- 1687746.70- 90.6 174952.30- 1841487.00- 1579379.05- 85.8 262107.95- *******EXPENDITURES******* GENERAL GOVERlffiENT ACTIVITIES: NON-DEPARTMENTAL 1720770.00 1729551.85 100.5 8781.85- 1720120.00 1579472.25 91.8 140647.75 CITY MAllAGER 19465.00 18364. 72 94.3 1100.28 19810.00 14941.69 75.4 4868.31 FIllAIICE DEPARTMEIIT 10151.00 8433.65 83.1 1717.35 13000.00 4912.61 37.8 8087.39 ACTIVITY TOTAL 1750386.00 1756350.22 100.3 5964.22- 1752930.00 1599326.55 91.2 153603.45 PUBLIC SAFETY: DISASTER PREAPREDllESS 10900.00 4731. 07 43.4 6168.93 .00 .00 .00 ACTIVITY TOTAL 10900.00 4731.07 43.4 6168.93 .00 .00 .00 TR.!JISPORTATIOll : HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATIon ADMnlISTRATION 13080.00 10584.56 80.9 2495.44 9165.00 10980.38 119.8 1815.38- SElIIOR CEIITER 500.00 448.57 89.7 51. 43 .00 .00 .00 ACTIVITY TOTAL 13580.00 11033.13 81.2 2546.87 9165.00 10980.38 119.8 1815.38- COHlroJlITY DEVELOPHElrr: CAPITAL HlPROVEHEIIT PROJECTS: CIVIC CENTER COSTS .00 .00 .00 7877 .00 7877.00 100.0 .00 ACTIVITY TOTAL .00 .00 .00 7877.00 7877.00 100.0 .00 TOT A L EXPENDITURES 1774866.00 1772114.42 99.8 2751.58 1769972.00 1618183.93 91. 4 151788.07 EXCESS<REVElIUE> EXPEllDITURES 87833.00- 84367.72 96.1- 172200.72- 71515.00- 38804.88 54.3- 110319.88- TR.UISFERS IN FROM OTHER FUNDS .00 47610.83- 47610.83 .00 .00 .00 EXCESS <REVElIUE> EXPEllDITURE 87833.00- 36756.89 41. 8- 124589.89- 71515.00- 38804.88 54.3- 110319.88- . e . BGLl04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 10/23/92 REVEIIUES VERSUS EXPEllDITORE 15.29.03 FOR THE PERIOD 7/91 THROUGH 6/92 IlITERlIAL SERVICE FUllD CURRE1!T PERIOD PREVIOUS PERIOD 91 BUDGET ACTUAL PERCEIlT VARWICE BUDGET ACTm.L PERCEIlT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY 15000.00- 17971. 93- 119.8 2971.93 21000.00- .00 21000.00- CHARGES FOR SERVICES 148354.00- 144490.30- 97.4 3863.70- 141576.00- 126480.80- 89.3 15095.20- OTHER SOURCES OF REVElmE .00 .00 .00 .00 2260.00- 2260.00 TOTAL REVEllUE 163354.00- 162462.23- 99.5 891.77- 162576.00- 128740.80- 79.2 33835.20- *** **** EXPEIlD ITURES **** ** * GENERAL GOVERlIMEUT ACTIVITIES: nOn-DEPARTMENTAL 161069.00 149830.03 93.0 11238.97 149800.00 54713.85 36.5 95086.15 ACTIVITY TOT~.L 161069.00 149830.03 93.0 11238.97 149800.00 54713.85 36.5 95086.15 PUBLIC SAFETY: POLICE 16700.00 .00 16700.00 74055.00 59326.17 80.1 14728.83 ACTIVITY TOTAL 16700.00 .00 16700.00 74055.00 59326.17 80.1 14728.83 TRAlISPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COHHUlIITY DEVELOPMEllT: CAPITAL IMPROVEMEIIT PROJECTS: GElffiRAL CIP PROJECTS .00 .00 .00 8720.00 .00 8720.00 ACTIVITY TOTAL .00 .00 .00 8720.00 .00 8720.00 TOT A. L EXPEIlDITURES 177769.00 149830.03 84.3 27938.97 232575.00 114040.02 49.0 118534. 98 EXCESS<REVElIUE> EXPEIlD ITURE 14415.00 12632.20- 87.6- 27047 .20 69999.00 14700.78- 21.0- 84699.78 EXCESS <REVENUE> EXPEllDlTURE 14415.00 12632.20- 87.6- 27047.20 69999.00 14700.78- 21.0- 84699.78 ~ e . SUPPLEMENTAL APPROPRIATIONS BY FUND/DEPARTMENT FOR FISCAL YEAR 1991-92 General Fund: City Attorney Crossing Guards Park Maintenance Dougherty Bike Path Kolb - Handicap Playground Shannon Park Renovation Fund: Improvements Landscape Assessment - Stagecoach Landscape Maintenance Street Tree Maintenance Engineering Landscape/Light Assess - Dougherty Landscape Maintenance Street Tree Maintenance Engineering Actual Budqet Increase (Decrease) Appropriations $10,083(1) 23 7,184(2) 464(3) 34 $17,788 $65,564(4) $1 0,918(5) (3,352) (1,237) $ 5,189(5) (4,865) (324) (1) Actual Attorney's Fees, particularly for litigation, exceeded the Department's original appropriations. (2) Actual water and sewer charges significantly exceeded the Department's original appropriations. (3) The slight overrun in Bike Path expenditures (TDA Projects) must be covered by an appropriation from the General Fund. (4) The Shannon Park costs were available in FY 1990/91 and merely need reappropriation to the current year. (5) Assessment District costs are adequately covered transfers between departmental appropriations within the funds or by supplemental appropriation of available fund balance (Stagecoach - $6,329). a:lllexh3.agenda#ll $206,533 33,143 552,454 464 12,061 $196,450 33,120 545,270 12,027 $65,564 $54,298 1 ,848 763 $43,380 5,200 2,000 $62,689 3,035 681 $57,500 7,900 2,000 Eif" :Q,'l,!,:},r ~:; t.., . 3