HomeMy WebLinkAboutItem 4.8 1990-91 Audit Report CITY OF DUBLIN
AGENDA STATEMENT
MEETING DATE: December 23, 1991
SUBJECT :1990-91 Audit Report
EXHIBITS ATTACHED :1. The June 30, 1991 audit report,
2. Internal Control Recommendations,
3. Report in Compliance with Proposition 111,
and
4. The June 30, 1991 Financial Reports.
RECOMMENDATIONS :Authorize all the necessary year end budget
qu�>' changes and review, accept and file the audit
report, the auditors recommendations on
internal control and managements' responses to
same, and accept final June financial
statements.
FINANCIAL STATEMENT: (See attached reports)
DESCRIPTION: Dublin received its annual audit report on the
City's financial statements for the period ending June 30, 1991.
Once again the independent auditors were able to provide the City
with a "clean audit", which is the highest rating that can be
issued.
The City Council 's Audit Committee met with the City's auditors
and the City Manager and Finance Director to discuss the audit
and the "Recommendations for Improvements in Internal Control".
One of the primary requirements in any audit is the determination
by the auditors of the reliability of the City's operating plans,
policies and organizational structure, which are set in place by
management. When properly executed, those plans, policies and the
organization structure safeguard the City's assets, ensure the
reliability of its accounting data, promote efficiency and ensure
compliance. The results of the determination of reliability is
presented by the auditors in their "Recommendation for
Improvements in Internal Control ".
The Council 's Audit Committee and Staff reviewed the
recommendations and responded to each in the following manner:
RECOMMENDATION #1: Set up procedures to allow electronic
data processing to resume operations after a disaster.
Response: The City Finance Department periodically makes
backup copies on tapes of the computer libraries that hold
all the programs accessed by the Finance Department
including payroll , general ledger, accounts receivable,
accounts payable, and business licenses. These tapes are
retained in a rotating sequence of three, which are commonly
referred to as the grandfather, father, son orientation.
This means that at any one time there is a current copy of
the library plus copies of the previous two levels of the
libraries. This is the professional method for assuring that
prior levels of operating programs are available for
operating integrity under adverse conditions such as a fire.
The Department creates backup copies of all financial data
on a daily basis. These tapes are retained on a rotating
sequence organized in a Monday, Tuesday, Wednesday, Thursday
and Friday basis. This means that during operating hours on
Monday, the Finance Department staff will create a backup
tape of all financial activities for the year up to that
CITY CLERK
���• FILE 3 / 0 Z 0
Monday on the `Monday' tape. Likewise backup tapes will be
made on Tuesday, Wednesday, Etc. This keeps the process
simple and assures the integrity of the cumulative historic
data for each backup tape copy.
The auditors noted that these backup copies of the libraries
and data were kept in the same location as the computer.
This means that in the case of a disaster in which the
computer room was destroyed, the likelihood is that the data
and library backup tapes would also be destroyed. The
recommendation is to locate the library and data backup
tapes in a separate building from the one that houses the
computer system.
Arrangements have been made with the Police Department to
keep the Finance Department's data and library tapes in the
separate Police Department building--the alternative site
location. Each time the data and/or libraries are
copied the appropriate tape will be retrieved from the
Police Department building, used to copy the appropriate
material and returned to the Police Department.
RECOMMENDATION #2. Grant reimbursements should be billed
more timely.
Response: The various reimbursement grants that the City
uses require that the Finance Department invoice the grantor
for reimbursement of amounts first paid to contractors that
are working on the project. The Engineering Department
prepares and/or approves the necessary work records that are
used to issue the City's check to the contractor as well as
the City's invoice to the Grantor.
In the past there have been delays between the time when the
City pays the contractor and the time the City invoices the
Grantors.
The auditors recommend that these delays be minimized.
This issue has been addressed by the City Manager with the
Public Works and Finance Departments several months prior to
the audit report. In recent months the data that is
necessary to invoice the Grantors have been received in
Finance at the same time as the spreadsheets used to
generate the City's check to pay the contractors.
RECOMMENDATION U. The City should revise its appropriation
limits to comply with Proposition 111 .
The Auditor's report on the compliance with Proposition 111
identifies that the appropriation limit for 1990-91 was
determined using the pre-proposition 111 rules. The 1991-92
appropriation limit was calculated using the Proposition 111
rules for that year only and should be recomputed using the
new rules retroactively starting with the 1986-87
appropriation limit.
Response: Proposition 111 changed the manner in which cities
calculate their appropriation limits. The proposition
provided that information, which is only available from the
County, be used to determine the limit. During the 91-92
budget preparation the City Finance Department received
material from the County on the same day as the budget
hearings were held. Consequently, the appropriation limit
for the 1991-92 year was calculated based upon Proposition
111 for that year only.
Proposition 111 provides for the re-calculation of the
City's appropriation limit by going back to the 1986-87
fiscal year. If the City decides to perform the limit
calculations again using the newly authorized factors, the
City could increase its appropriation limit by approximately
$132,000.
The City calculated the 1991-92 appropriation limits
consistent with Proposition 111 for that year only. Because
the County was unable to provide the data needed to
recompute all prior year limits until the day of the budget
hearing, not enough time was available for the
re-computation of the prior year appropriation limits.
The 1990-91 appropriation limits were computed under
pre-Proposition 111 rules, which were in effect at the time.
To recalculate the prior year limits will allow the public
to question, debate, and object to the appropriation limits
for each of the years that are recalculated. The window for
public comments is itself, however, limited to 45 days.
Since the City is well under its current appropriation
limit, it is not necessary to re-calculate the prior
appropriation limits until the preparation of the fiscal
year 1992-93 budget.
RECOMMENDATION #4: The City should take steps to reduce the
unpaid balance of private developer deposit billings.
The City has a large number of deposit accounts. These
accounts are used when, for example, a developer submits a
plan for review. An estimate of the City's cost to review
those plans are charged to the developer at the time the
plans are submitted. The amount in the deposit account is
decreased by the amount of work that City staff puts into
reviewing the plans.
Some of these deposit accounts show that the City is owed
money. Ideally the City should instead be in the position of
holding developer's deposit.
The auditors feel that consideration should be given to
decreasing the amounts that are owed the City in these
deposit accounts. The City is owed money when the dollar
value of the staff work performed on the plan review is
greater .than the dollar amount that was deposited by the
developer.
There are a number of solutions:
1 . Increase the amount of the deposits.
2. Contract with a collection company to trace down
developers who owe the City money and who have not paid
after a reasonable time.
3. Increase the fees to provide for current cost recovery
and set the fees on an hourly basis. Have the Planning,
Engineering and Public Works, Departments estimate the
number of hours that it will take to complete their
respective reviews and charge the developer in advance for
the total amount.
At this time only one account appears to be un-collectable
due to bankruptcy. The amount in that account is $3,223.06.
RECOMMENDATION #5. Interfund balances should be paid timely.
The auditors noted that some funds owe the General Fund
money at year end (June 30) even though they have cash
balances in their respective accounts. They recommend that
these cash accounts be zeroed out and the amount that is
owed to the General Fund be decreased.
The Finance Director prefers to hold enough cash at year end
in each fund to payoff any payables that are estimated to
accrue after July 1 and before August 15th. After the end of
August any cash balances remaining in funds that owe the
General fund money is then closed to the General Fund. This
method eliminates the churning of the cash accounts back and
forth--once to pay off the General Fund at year end, once to
move money back from the General Fund to the Special Fund to
pay off the payables, and finally to settle the accounts
after all other transaction are completed.
RECOMMENDATION #6: The City should maintain petty cash
acceptance forms for petty cash kept by custodians.
Petty Cash acceptance forms should be signed by each person
responsible for petty cash.
The City has two petty cash accounts: One at the Recreation
department, and one in the City Clerks Office. Each is an
imprest fund type account--the money is replenished as it is
documented to have been used. Each account is $200.00.
This is an administrative action, which is being addressed.
The forms will be developed and the appropriate signatures
will be obtained. The forms will be placed in the personnel
files of those signing for responsibility of each petty cash
fund.
Some budget changes were necessary at the close of the fiscal
year. These budget changes are the result of changes in the funds
that were used for various projects in order to assure that
`maintenance of effort' (MOE) levels were met. The City received
SB 140 grants funds, Gas Tax section 2105 money, and Sales tax
Measure B funds, which require either a base maintenance level or
a matching of_ general funds money. The MOE for example can
require that the General Funds continue to pay for at least
$612,403 each year for street improvements before Gas Tax money
can be received. The State Controllers Office determined the
amount of the MOE for some of the grants, and because these MOE
amounts were not known at the beginning of the year it was not
possible to plan for them in the budget. Therefore, the budget
changes that were made could not have been accomplished earlier
in the year. No increases in project budgets resulted from these
budget changes.
The information on the following page shows the various funds
budgets before and after the changes:
TOTALS
budgets before budgets after
FUNDS changes adjustment changes
General Fund $16,186,066 ($1,449,350) $14,736,716
Traffic Safety 102,125 0 102,125
Gas Tax 386,200 9,427 395,627
CDBG 19,800 (10,100) 9,700
FAU 721,325 359,760 1,081,085
TDA 150,000 (27,800) 122,200
State Park Bond 7,202 (1,735) 5,467
Park Dedication 301,709 (103,805) 197,904
Measure B 125,000 0 125,000
Measure AA 0 461,367 461,367
SafeCo 10,000 (10,000) 0
SB140 104,125 2,125 106,250
Dublin Blvd Ext 2,218,000 (2,155,000) 63,000
RESULTS $20,331,552 ($2,925,111) $17,406,441
At year end the expenditures exceeded the budget in only one
operating budget--City Attorney. A transfer of $2,455 from the
Finance Department to the City Attorney's Department budget is
needed.
RECOMMENDATION: Staff recommends that Council authorize that the
budget changes that were necessary in order to meet the MOE and
matching requirements, plus the $2,455 transfer to the City
Attorney's Budget from the Finance Department Budget; and staff
recommends that Council receive, review, approve and file the
financial audits for the year ending June 30, 1991, accept the
management responses of the Auditor's internal control
recommendations, and accept the Report in Compliance with
Proposition 111 .
r
r
City of Dublin
California
Comprehensive Annual Financial Report
r
CFor Fiscal Year Ended
C June 30, 1991
'1.
l�
C
L
CITY OF DUBLIN
DUBLIN, CALIFORNIA
COMPREHENSIVE
ANNUAL FINANCIAL REPORT
FOR THE YEARS ENDED JUNE 30, 1991 AND JUNE 30, 1990
Prepared by
DEPARTMENT OF FINANCE
INTRODUCTORY SECTION
CITY OF DUBLIN
Comprehensive Annual Financial Report
For the Years Ended June 30, 1991 and 1990
Table of Contents
Page
INTRODUCTORY SECTION
Table of Contents . . . . . . . . . . . . . . . . . . . . . . i
Letter of Transmittal . . . . . . . . . . . . . . . . . . . . 1
Elected Officials and Administration
Personnel . . . . . . . . . . . . . . . . . . . . . . . . . 10
Organization Chart of Major City Activities . . . . . . . . . 11
Certificate of Achievement for Excellence
in Financial Reporting . . . . . . . . . . . . . . . . . . 12
FINANCIAL SECTION
Independent Auditor's Report . . . . . . . . . . . . . . . . . . . 13
General Purpose Financial Statements
Combined Balance Sheets - All Fund Types and
Account Groups . . . . . . . . . . . . . . . . . . . . . . . 16
Combined Statements of Revenues, Expenditures
and Changes in Fund Balances - All Governmental
Fund Types . . . . . . . . . . . . . . . . . . . . . . . . . 19
Combined Statement of Revenues, Expenditures and
Changes in Fund Balances - Budget and Actual -
General, Special Revenue and Capital Projects Fund
Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Combined Statements of Revenues, Expenses and
Changes in Fund Equity - All Proprietary
Fund Types . . . . . . . . . . . . . . . . . . . . . . . . . 22
Combined Statements of Cash Flows -
All Proprietary Fund Types . . . . . . . . . . . . . . . . . 23
Notes to General Purpose Financial Statements. . . . . . . . . 24
Combining Fund Statements
General Fund
Comparative Balance Sheets . . . . . . . . . . . . . . . . . . 44
-i-
CITY OF DUBLIN
Comprehensive Annual Financial Report
For the Years Ended June 30, 1991 and 1990
Table of Contents
Page
Statements of Revenues, Expenditures and
Changes in Fund Balance - Budget and Actual . . . . . . . . . 45
Schedule of Budget Versus Actual Departmental
Expenditures . . . . . . . . . . . . . . . . . . . . . . . . 46
Special Revenue Funds
Combining Balance Sheets . . . . . . . . . . . . . . . . . . . 50
Combining Statements of Revenues, Expenditures
and Changes in Fund Balances. . . . . . . . . . . . . . . . . 52
Combining Statement of Revenues, Expenditures
and Changes in Fund Balances - Budget and Actual . . . . . . 54
Schedule of Budget Versus Actual Departmental
Expenditures . . . . . . . . . . . . . . . . . . . . . . . . 61
Capital Projects Fund
Comparative Balance Sheets . . . . . . . . . . . . . . . . . . 63
Statements of Revenues, Expenditures and
Changes in Fund Deficits - Budget and Actual. . . . . . . . . 64
Schedule of Budget Versus Actual Departmental
Expenditures . . . . . . . . . . . . . . . . . . . . . . . . 65
Agency Funds
Statement of Changes in Assets and Liabilities . . . . . . . 67
STATISTICAL SECTION
Governmental Expenditures by Function -
All Governmental Fund Types - Last Nine Fiscal
Years . . . . . . . . . . . . . . . . . . . . . . . . . . . 70
General Governmental Revenues by Source - All
Governmental Fund Types - Last Nine Fiscal
Years . . . . . . . . . . . . . . . . . . . . . . . . . . . 71
Assessed and Estimated Actual Value of
Taxable Property - Last Nine Fiscal Years . . . . . . . . . 72
-ii-
CITY OF DUBLIN
Comprehensive Annual Financial Report
For the Years Ended June 30, 1991 and 1990
Table of Contents
Pa-ze
Property Tax Rates - All Overlapping
Governments - Last Nine Fiscal Years . . . . . . . . . . . 73
Computation of Legal Debt Margin . . . . . . . . . . . . . . 74
Computation of Direct and Overlapping Debt . . . . . . . . . 75
Demographic Statistics - Last Nine Fiscal
Years . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
Property Value, Construction, and Bank Deposits
- Last Nine Fiscal Years . . . . . . . . . . . . . . . . . . 77
California Public Employees Retirement System
Funding Analysis - Fiscal Years 1986-1990. . . . . . . . . . 78
Miscellaneous Statistical Data . . . . . . . . . . . . . . . 79
Schedule of 1985 Certificates of Participation
Coverage - Fiscal Years 1985-1988 . . . . . . . . . . . . . 80
Schedule of 1988 Certificates of Participation
Coverage - Last Three Fiscal Years . . . . . . . . . . . . . 81
Property Tax Levies and Collections -
Last Eight Fiscal Years . . . . . . . . . . . . . . . . . . 82
Principal Taxpayers . . . . . . . . . . . . . . . . . . . . . 83
-iii-
19 � �8�2 CITY OF DUBLIN "Celebrating 10 Years Of Cityhood 1982-1992"
P.O. Box 2340, Dublin, California 94568 City Offices, 100 Civic Plaza, Dublin, California 94568
To the Honorable Mayor, October 25, 1991
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, 1991 . 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 requirement 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. This information appears in the Transmittal letter, 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
information 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 government agencies. The City police services, for example,
are provided through a contract with the Alameda County Sheriffs Department. The
street maintenance services, and park maintenance services are currently
provided by contracts with MICE Corporation. City engineering services are
augmented with on-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.
Administration (510)833-6650•City Council (510) 833-6605• Finance(510) 833-6640• Building Inspection (510)833-6620
Code Enforcement(510)833-6620 • Enginegring (510) 833-6630 • Planning (510) 833-6610
Police (510)833-6670 • Public Works(510) 833-6630 • Recreation (510) 833-6645
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,
calendars and recreation brochures. The entity's functions were expanded when
after the first few years of operations, 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.
Dublin recently acquired the responsibility for fire suppression services as
well as park maintenance services from the Dublin San Ramon Services District
(DSRSD) . Along with the added responsibility the City received the allotment of
property tax revenue, which was previously assigned to DSRSD. The District
provides fire suppression services to both the cities of San Ramon and Dublin.
Upon transfer of the responsibility for fire services from the District, the
two cities formed a joint powers authority to maintain the integrity of the fire
services. Each city makes monthly 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. Eight hundred and nineteen retail establishments are registered with
the State to do retail business within the City. Given the City's certified
population of 23,500 on January 1991 , the city generates more taxable sales per
capita than any other surrounding city. The long term trend (beyond the current
recession) for the City's sales tax is up. The Tri-Valley area, which includes
the cities of Dublin, Pleasanton, San Ramon and Livermore continues to grow in
population. More than most California cities, Dublin's operating funds rely
heavily on Sales Tax revenue.
C§T ' OF DUDS LL B/V
Percentage Sales Tax Revenue
Generated by Eusiness Types
DEPARTMENT STORES
RADIO 8 APPLIANCES
21%
HOUSEHOLD FURN. 7% CAR DEALERS
SPECIALTY STORES % 13%
a
LIGHT INDUSTRY
SERVICE STATIONS 43%
OTHER BUSINESS TYPES
2
COMPARISON OF PER CAPITA TAXABLE SALES
City of Dublin and three surrounding communities
Dublin
Pop :3.EOo
I
I
Pleasanton
Pop aaroo '
I
San Ramon i
Pop 33.930 I •I
I
I
i
Livermore
Pop 48.100
SO $5 Sto $15 S20 $25
Thousands
® annual data
There were 819 retail establishments reporting sales taxable transaction with a
Dublin point of sale in 1990. The top twenty sales tax revenue generators for
the most current quarter produced over 59% of the total taxable sales
transactions for that quarter. Within the last four quarters only five of the
top twenty businesses ever ranked below the top twenty; this factor shows the
economic stability of the City. The following graph shows the sales tax trends
for the City.
CITY OF DUBLIN
TOTAL TA%ABLE SALES BY OUARTER
TREND LINE EVALUATION
Millions EOUACE:ETATE 6OAAO Or EQUALISATION
$160•
$1401 ,
$1201
$100 �
S80I�
S60I
$401
S20 i.
BA 85 BB B7 BB 09 90
$D
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
84 85 86 87 88 89 90
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.
Electronic Tele-Communicators (formerly Automation
Electronic Corporation) : Manufacturer & distributor of
telephone peripheral equipment.
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 2,015. The Planning Department is participating with Public
Works and the Building Department, to coordinate the acquisition of hardware and
software, which may provide computer generated maps, parcel information and
improvement conditions with a key stroke.
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. The City made other major improvements to the
Senior Center Kitchen, and the Shannon Park. Other improvement projects include
the High School boys and girls sports fields.
Public Works:
The City continued to work on the easterly extension of Dublin Boulevard,
parallel to but north of Interstate Highway 580. The Boulevard will be extended
in phases with the first phase of construction being a 1,700 lineal feet
project, scheduled to begin in fiscal year 91-92. This portion of the project
will include the right-of-way acquisitions needed to construct a 400 feet six
lane road plus a 1,300 feet two lane road. The complete project will also
provide a two lane road beyond the easterly most boundaries of the City limits.
4
This Boulevard is one of the main business streets for the City, and will
provide access to the land further east of City's present eastern limit. The
cost associated with construction of the first 1 ,700 feet of this project is
estimated to run $4,271,400.
The San Ramon Road Improvements program, which will be completed in 1991-92,
improves San Ramon Road from two to four lanes. This project provides a better
and faster access to the community along the south to north corridor paralleling
Interstate 680 as well as median landscaping, street lighting, and sound walls
along the edge of the road. The City used a phasing concept for these
improvements too, and the first phase of this project was bid in 1986. The total
cost of the project is estimated at $2,429,605.
Finance/Treasurer:
The Finance Department is responsible for payroll , accounts payable processing,
accounts receivable, business license, treasury functions and monthly financial
statement preparation, which are accomplished by the use of in-house computers.
The monthly financial reports are submitted to the Council . The City-wide
financial information system, and the cash management functions are also located
within Finance. The computer system is used for all the financial and investment
record keeping plus budgeting, word processing, police records, police
management information, recreation scheduling and program registration. There
are twenty six personal computers and two terminals accessing both mainframe
system data and various software products simultaneously. These units are
located throughout the city staff offices.
Financial Information
Internal Control :
The City Council is responsible for the overall plan of the organization. The
City Management is responsible for establishing 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 accounting 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
resides 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. The accounting staff
reviews the purchase request and purchase orders 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 1990 to June 1991 with a renewal
date of July 1991 to June 1992. The ABAG PLAN experienced its first equity
allocation at the close of fiscal year 1989-90, with distributions occurring on
July 2 1990. 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 $17
million in size for the year. The average yield for the year was 8.5%. The
City's investment process takes into consideration in order of importance: I .
the safety of the principal amount invested, 2. 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. Inasmuch as the greatest portion of Dublin's
portfolio is in Certificates of Deposit, the diversification criteria is
satisfied by dividing that amount into the greatest number of individual
certificates of less than $100,000. There were 56 investment instruments
purchased as of June 30, 1991 of which only seven exceeded $100,000. The largest
single amount invested by the City was in the State Treasurer's investment pool ,
which totaled $10,000,000. The other six large items were either collateralized
certificates of deposit or Federal Agency debentures.
6
Financial Statement Analysis
The financial reports reflect the fact that the City's General Funds
represent over 70% of both the revenues and expenditures for all City .
fund types. The Changes in the General Fund revenues over the last
three fiscal years show the emphasis on tax revenues with recent large
increases in property taxes due to the shift in responsibilities and
property tax from DSRSD (Dublin San Ramon Services District)to the
City. The graph below reflects this fact. Sales tax revenue of
$5,839,088 represents over forty percent of total revenues for the
City in fiscal year 90-91 .
Revenue Type 1990-91 % of dollar percent
total change change
current from prior
year year
Taxes 10,204,052.00 71 .50% 541,717.00 5.61%
License/Permits 248, 116.00 1 .74% (66,894.00) -21 .24%
Intergovernmental 973,266.00 6.82% 40,432.00 4.33%
Charges for Services 1 , 196,484.00 8.38% 106,098.00 9.73%
Uses of Assets 1,338,947.00 9.38% 5,274.00 .40%
Fines & Forfeitures 19,476.00 .14% 61 .00 .31%
Other 290,254.00 2.03% 269,645.00 . 1308.38%
TOTALS 14,270,595.00 1.00 896,333.00 6.70%
City of Dublin
General Fund Revenues
Millions
$12 —
$10
$8 {
$4 ;/ H 1987 88
1989-90
$0-,
,.... u......I i... cn.rp.. o...e1 il...A oinu
e e.w. A.0Ib0 iln•nalN R.p.a.
7
Expenditures of the General Fund show increases in the General Government
activity, which is primarily due to the purchase of F.A.U. funds from two other
California cities totaling $558,370. The largest increase, $843,837, is due to
the Facilities rental payment, which is programed to equal the net annual amount
of debt service due on the Certificates of Participation. This is the first year
the entire amount of the interest portion of the debt service is posted as an
expense and, therefore, appears as a large increase in the expenditures. During
construction the interest was required to be capitalized.
Expenditures 1990-91 % of dollar percent
total change change
current from prior
year year
General Government 2,010,105.00 15.01% 674,224.00 50.47%
Facilities rent 1,579,472.00 11.79% 872,563.00 123.43%
Public Safety 4,803,735.00 35.88% 383,311 .00 8.67%
Highways & Streets 837,547.00 6.26% 318,381 .00 61.33%
Health & Welfare 26,277.00 .20% 1,697.00 6.90%
Community Development 1,827,354.00 13.65% 260,580.00 16.63%
Culture & Leisure 1,459,419.00 10.90% 209,313.00 16.74%
Capital Outlay 845,667.00 6.32% (323,365.00) -27.66%
TOTALS 13,389,576.00 1.00 2,396,704.00 21.80%
Comparison of types of expenditures for
the General Fund
Millions
$5 -
$4 -
$3 -
$2 -
I r
A
1986-87
1 - IC F I 1987-88
1988-89
1989-90
$0 i i 1 1 I 1 i I 1990-91
G•naral Facility Public Straa La a Health Comm. Culture Capital
Gorarntnant rental Salaly Roads i Waller• Darrl. 1 Laiaor+ Outlay
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 and City Manager for their support.
Respectfully submitted,
r ip S. Molina, CPA
Finance Director, City Treasurer
9
CITY OF DUBLIN
ELECTED OFFICIALS
June 30, 1991
Mayor
Peter W. Snyder
Vice Mayor Council-member
Linda J . Jeffrey Dave Burton
Councilmember Council-member
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 Lawrence L. Tong
Chief Building Official Victor L. Taugher
Recreation Director Diane Lowart
Finance Director and Treasurer Phillip Molina
10
CITY OF DUBLIN
ORGANIZATION CHART FOR MAJOR CITY ACTIVITIES
REGISTERED VOTERS OF THE CITY OF DUBLIN
i
COUNCILMEMBERS
I
i
CITY MANAGER
FIRE J.P.A. ____________ Manager Staff & City Clerk
i
i
i
I
I
� I I
POLICE PLANNING FINANCE PUBLIC WORKS Building & i I RECREATION
Safety
TREASURER
CERTIFICATE OF ACHIEVEMENT FOR
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, 1990. 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 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 printed Certificate of Achievement had not been received from GFOA at the
time this report was printed.
12
FINANCIAL SECTION
4AZE &
ASSOCIATES
ACCOUNTANCY CORPORATION
1670 Riviera Avenue-Suite 100
Walnut Creek, California 94596
(510) 930-0902 • (916)972-7333
INDEPENDENT AUDITOR'S REPORT FAX(510)930-0135
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, 1991 and 1990, 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 principles
used 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, 1991 and 1990 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, 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 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, accordingly, we do not express an opinion on this information.
October 18, 1991
13
A Professional Corporation
(This Page Left Blank Intentionally)
14
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 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 TYPES
These funds are those used to account for assets held by government in a
trustee capacity or as an agent.
ACCOUNT GROUP
The account group is used to establish accounting control over the City's
general fixed assets. Because these assets are long-term they are not
spendable resources and do not require current appropriation. They are
accounted for separately from governmental fund types.
15
CITY OF DUBLIN
COMBINED BALANCE SHEETS - ALL FUND TYPES AND ACCOUNT GROUPS
JUNE 30, 1991
WITH COMPARATIVE AMOUNTS AS OF JUNE 30, 1990
GOVERNMENTAL FUND TYPES PROPRIETARY FUND TYPES
Special Capital Internal
General Revenue Projects Service Enterprise
ASSETS
Cash and investments(Note 2) $15,136,269 $590,377 $61,789 $268,225
Restricted cash and investments(Note 2) $1,718,576
Receivables:
Accounts 268,625 5,000 769
Accrued interest 199,249 64,500
Due from other governments 231,987 492,800
Due from other funds (Note 3) 1,363,311
Prepaid expenses 7,058 8,616 1,724
Fixed assets(net of accumulated
depreciation)(Note 4) 182,942 21,892,690
Total Assets $17,206,499 $1,088,177 $61,789 $460,552 $23,677,490
LIABILITIES
Accounts payable $1,297,031 $141,666 $925 $458 $3,462
Accrued wages 67,630
Accumulated unpaid general leave 105,488
Deposits payable 408,468 133,094
Due to other funds(Note 3) 1,340,206 23,105
Due to other governments
Due to bondholders
Deferred compensation payable
Interest payable 498,900
Certificates of participation(Note 5) 16,484,831
Total Liabilities 1,878,617 1,481,872 157,124 458 16,987,193
FUND EQUITY AND OTHER CREDITS
Investments in general fixed assets
Contributed capital(Note 7) 168,258 5,109,891
Retained earnings:
Reserved for debt service 1,580,406
Reserved for equipment replacement 291,836
Unreserved
Fund balances: (Notes 6 and 7)
Reserved:
Reserved for prepaid expenses 7,058
Unreserved:
Designated for authorized expenditures 15,320,824 415,700
Undesignated (809,395) (95,335)
Total Fund Equities(Deficits) 15,327,882 (393,695) (95,335) 460,094 6,690,297
Total Liabilities and Fund Equities $17,206,499 $1,088,177 $61,789 $460,552 $23,677,490
See accompanying notes to financial statements
16
FIDUCIARY ACCOUNT TOTALS
FUND TYPE GROUP (Memorandum Only)
Agency General Fixed
Fund Assets 1991 1990
$16,056,660 $16,577,463
$903,334 2,621,910 2,350,063
274,394 191,760
263,749 247,606
724,787 433,714
1,363,311 311,763
17,398 23,102
$444,275 22,519,907 22,934,440
$903,334 $444,275 $43,842,116 $43,069,911
$1,443,542 $1,346,291
67,630 64,724
105,488 85,444
541,562 777,540
1,363,311 311,763
43,049
$843,686 843,686 635,526
59,648 59,648
498,900 541,585
16,484,831 16,887,494
903,334 21,408,598 20,693,416
$444,275 444,275 379,710
5,278,149 5,265,148
1,580,406 1,620,428
291,836 292,071
7,058 12,058
15,736,524 14,958,374
(904,730) (151,294)
444,275 22,433,518 22,376,495
$903,334 $444,275 $43,842,116 $43,069,911
17
CITY OF DUBLIN
COMBINED STATEMENTS OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCES
ALL GOVERNMENTAL FUND TYPES
FOR THE YEAR ENDED JUNE 30, 1991
WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1991
TOTALS
GOVERNMENTAL FUND TYPES (Memorandum Only)
Special Capital
General Revenue Projects 1991 1990
REVENUES
Taxes $10,204,052 $108,156 $10,312,208 $9,769,276
Licenses and permits 248,116 248,116 315,010
Intergovernmental 973,266 1,591,287 2,564,553 1,667,801
Charges for services 1,196,484 1,196,484 1,090,386
Use of money and property 1,338,947 37,529 $11,875 1,388,351 1,405,882
Fines and forfeits 19,476 62,891 82,367 91,221
Other revenue 290,254 17,078 76,091 383,423 908,784
Special assessments 281,428 281,428 287,205
Total Revenues 14,270,595 2,098,369 87,966 16,456,930 15,535,565
EXPENDITURES
Current:
General government 2,010,105 3,904 2,014,009 1,340,597
Facilities rents 1,579,472 1,579,472 706,909
Public safety 4,800,963 267,792 5,068,755 4,672,847
Highways and streets 837,547 204,080 1,041,627 1,021,641
Health and welfare 26,277 26,277 24,580
Community development 1,827,354 1,827,354 1,583,504
Culture and leisure 1,459,419 1,459,419 1,250,281
Capital outlay 848,439 2,422,224 132,465 3,403,128 2,652,683
Total Expenditures 13,389,576 2,898,000 132,465 16,420,041 13,253,042
EXCESS OF REVENUES OVER
(UNDER)EXPENDITURES 881,019 (799,631) (44,499) 36,889 2,282,523
OTHER FINANCING SOURCES (USES)
Operating transfers in(Note 7) 10,474 10,474 924,959
Operating transfers(out)(Note 7) (4,174) (10,474) (14,648) (924,959)
Total Other Financing Sources(Uses) (4,174) (4,174)
EXCESS OF REVENUES AND OTHER
FINANCING SOURCES OVER(UNDER)
EXPENDITURES AND OTHER
FINANCING USES 876,845 (799,631) (44,499) 32,715 2,282,523
Fund balances(deficit),beginning of year 14,464,038 405,936 (50,836) 14,819,138 12,604,362
Residual equity transfers(out)(Note 7) (13,001) (13,001) (67,747)
Fund balances(deficit), end of year $15,327,882 ($393,695) ($95,335) $14,838,852 $14,819,138
See accompanying notes to financial statements
19
CITY OF DUBLIN
COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCES - BUDGET AND ACTUAL
GENERAL, BUDGETED SPECIAL REVENUE AND CAPITAL PROJECTS FUND TYPES
FOR THE YEAR ENDED JUNE 30, 1991
General Fund Special Revenue Funds
Variance Variance
Favorable Favorable
Budget Actual (Unfavorable) Budget Actual (Unfavorable)
REVENUES
Taxes $9,976,400 $10,204,052 $227,652 $109,000 $108,156 ($844)
Licenses and permits 408,100 248,116 (159,984)
Intergovernmental 1,027,260 973,266 (53,994) 2,465,821 1,591,287 (874,534)
Charges for services 1,164,816 1,196,484 31,668
Use of money and property 1,211,870 1,338,947 127,077 56,750 37,526 (19,224)
Fines and forfeits 20,000 19,476 (524) 80,000 62,891 (17,109)
Other revenue 97,500 114,038 16,538 785,000 17,078 (767,922)
Special assessment 274,400 281,428 7,028
Total Revenue 13,905,946 14,094,379 188,433 3,770,971 2,098,366 (1,672,605)
EXPENDITURES
Current:
General government 2,177,502 2,010,105 167,397 5,492 3,904 1,588
Facilities rents 1,719,820 1,579,472 140,348
Public safety 4,969,554 4,800,963 168,591 282,925 267,792 15,133
Highways and streets 862,659 837,547 25,112 225,631 204,080 21,551
Health and welfare 27,010 26,277 733
Community development 2,141,119 1,827,354 313,765
Culture and leisure 1,598,027 1,459,419 138,608
Capital outlay 1,241,025 848,439 392,586 2,474,967 2,422,224 52,743
Total Expenditures 14,736,716 13,389,576 1,347,140 2,989,015 2,898,000 91,015
EXCESS OF REVENUES OVER
(UNDER)EXPENDITURES (830,770) 704,803 1,535,573 781,956 (799,634) (1,581,590)
OTHER FINANCING SOURCES (USES)
Operating transfers in(Note 7) 10,474 10,474
Operating transfers(out)(Note 7) (4,174) (4,174) (10,474) (10,474)
Total Other Financing Sources(Uses) (4,174) (4,174)
EXCESS OF REVENUES AND OTHER FINANCING
SOURCES OVER(UNDER)EXPENDITURES
AND OTHER FINANCING USES ($830,770) 700,629 $1,531,399 $781,956 (799,634) ($1,581,590)
Adjustments to budgetary basis(Note 1) 176,216
Fund balances(deficit), beginning of year 14,464,038 392,364
Residual equity transfers(out)(Note 7) (13,001)
Fund balances(deficit), end of year $15,327,882 ($407,270)
See accompanying notes to financial statements
20
TOTALS
Capital Projects Fund (Memorandum Only)
Variance Variance
Favorable Favorable
Budget Actual (Unfavorable) Budget Actual (Unfavorable)
$10,085,400 $10,312,208 $226,808
408,100 248,116 (159,984)
3,493,081 2,564,553 (928,528)
1,164,816 1,196,484 31,668
$2,000 $11,875 $9,875 1,270,620 1,388,348 117,728
100,000 82,367 (17,633)
418,565 76,091 (342,474) 1,301,065 207,207 (1,093,858)
274,400 281,428 7,028
420,565 87,966 (332,599) 18,097,482 16,280,711 (1,816,771)
2,182,994 2,014,009 168,985
1,719,820 1,579,472 140,348
5,252,479 5,068,755 183,724
1,088,290 1,041,627 46,663
27,010 26,277 733
2,141,119 1,827,354 313,765
1,598,027 1,459,419 138,608
418,565 132,465 286,100 4,134,557 3,403,128 731,429
418,565 132,465 286,100 18,144,296 16,420,041 1,724,255
2,000 (44,499) (46,499) (46,814) (139,330) (92,516)
10,474 10,474
(14,648) (14,648)
(4,174) (4,174)
$2,000 (44,499) ($46,499) ($46,814) (143,504) ($96,690)
176,216
(50,836) 14,805,566
(13,001)
($95,335) $14,825,277
21
CITY OF DUBLIN
COMBINED STATEMENTS OF REVENUES, EXPENSES
AND CHANGES IN EQUITY
ALL PROPRIETARY FUND TYPES
FOR THE YEAR ENDED JUNE 30, 1991
WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1990
Internal Enterprise TOTALS
Service Fund Fund (Memorandum Only)
Dublin
Equipment Information
Replacement Inc. 1991 1990
REVENUES
Equipment usage $132,516 $132,516 $132,720
Miscellaneous 2,260 2,260 10,535
Total Revenues 134,776 134,776 143,255
EXPENSES
Depreciation 88,310 $471,184 559,494 442,831
Miscellaneous 63,774 42,264 106,038 86,586
Total Expenses 152,084 513,448 665,532 529,417
Operating Loss (17,308) (513,448) (530,756) (386,162)
NONOPERATING INCOME(EXPENSE)
Interest income 17,073 161,341 178,414 152,434
Facilities rents(Note 5) 1,579,379 1,579,379 706,909
Interest expense (1,271,468) (1,271,468) (654,249)
Nonoperating Income 17,073 469,252 486,325 205,094
OPERATING TRANSFER IN 4,174 4,174
Net Income(Loss) (235) (40,022) (40,257) (181,068)
Retained earnings, beginning of year 292,071 1,620,428 1,912,499 2,093,567
Retained earnings, end of year $291,836 $1,580,406 $1,872,242 $1,912,499
Contributed capital,beginning of year $155,257 $5,109,891 $5,265,148 $5,197,401
Residual equity transfer in(Note 7) 13,001 13,001 67,747
Contributed capital, end of year $168,258 $5,109,891 $5,278,149 $5,265,148
Total fund equity $460,094 $6,690,297 $7,150,391 $7,177,647
See accompanying notes to financial statements
22
CITY OF DUBLIN
COMBINED STATEMENTS OF CASH FLOWS
ALL PROPRIETARY FUND TYPES
FOR THE YEAR ENDED JUNE 30, 1991
WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1990
Internal Enterprise TOTALS
Service fund Fund (Memorandum Only)
Dublin
Equipment Information
Replacement Inc. 1991 1990
CASH FLOWS FROM OPERATING ACTIVITIES
Operating loss ($17,308) ($513,448) ($530,756) ($386,162)
Adjustments to reconcile operating loss
to cash flows from operating activities:
Depreciation and amortization 88,310 488,521 576,831 460,168
Decrease(increase)in accounts receivable (769) (769)
Decrease(increase)in accrued interest (19,868) (19,868) 20,354
Decrease(increase)in prepaid expenses 704 704 (2,428)
Increase(decrease)in accounts payable (23,128) (23,128) (455,247)
Increase(decrease)in interest payable (250) (42,685) (42,935) 3
Cash Flows From Operating Activities 70,687 (110,608) (39,921) (363,312)
CASH FLOWS FROM INVESTING ACTIVITIES
Interest income 17,073 161,341 178,414 152,434
Cash Flows From Investing Activities 17,073 161,341 178,414 152,434
CASH FLOWS FROM CAPITAL AND RELATED
FINANCING ACTIVITIES
Capital expenditures (80,397) (80,397) (2,657,387)
Contributed capital 13,001 13,001 67,747
Decrease in restricted cash and investments (4,039) (4,039) 441,212
Certficates of Participation principal retirement (420,000) (420,000)
Interest expense (1,271,468) (1,271,468) (654,249)
Facilities rents 1,579,379 1,579,379 706,909
Cash Flows From Capital and Related Financing Activities (67,396) (116,128) (183,524) (2,095,768)
CASH FLOWS FROM NONCAPITAL AND RELATED
FINANCING ACTIVITIES
Operating transfers in 4,174 4,174
Cash Flows From Noncapital and Related Financing Activities 4,174 4,174
Net Cash Flows 20,364 (61,221) (40,857) (2,306,646)
Cash and investments at beginning of year 247,861 61,221 309,082 2,615,728
Cash and investments at end of year $268,225 $268,225 $309,082
See accompanying notes to financial statements
23
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 1 - SUKKARY 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 accounting policies of the City conform to generally accepted
accounting principles as applicable to governments. The following is
a summary of the more significant policies:
A. Reporting Entity
The general purpose financial statements of the City of Dublin include
the financial 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
to assist in providing financing 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.
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
it is not able to significantly influence their operations, budgets or
financing.
24
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued)
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 in this
report, into three broad fund categories and six generic fund types as
follows:
GOVERNMENTAL FUNDS
General Fund-- The 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-- 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 Fund-- The capital projects fund is 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 FUNDS
Enterprise Fund - The 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 -- The 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.
25
CITY OF DUBLIN
Notes to Ceneral Purpose Financial Statements
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued)
FIDUCIARY FUNDS
Agency Fund- -The agency fund is 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. Fixed Assets and Long-Term Liabilities
The accounting and reporting treatment applied to the fixed assets and
long-term liabilities associated with a fund are determined by its
measurement focus. All governmental funds 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 funds. The account group is not a
"fund" . It is concerned only with the measurement of financial
position and is not involved with measurement of results of
operations.
All fixed assets are valued at historical cost or estimated historical
cost if actual historical cost is not available. 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.
26
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued)
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 years
Machinery and equipment 3-7 years
D. Contributed Capital in Proprietary Funds
Contributed capital in proprietary funds represents general fund
residual equity transfers used to acquire or construct fixed assets.
E. Basis of Accounting
Basis of accounting refers to when revenues and expenditures or
expenses are recognized in the accounts and reported 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 funds are accounted for using the modified
accrual basis of accounting. Their revenues are recognized when they
become measurable and available as net current assets.
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 is incurred. 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 type
expenditures or fund liabilities.
All proprietary funds 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.
F. 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.
27
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 1 - SUHHARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued)
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 expenditures of the City must be approved by City Council.
Expenditures may not exceed budgeted appropriations at the fund level
without City Council approval.
5. Formal budgetary integration is employed as a management control device
during the year for the general fund, special revenue funds, except the
Community Parkland Bond and Dublin Boulevard Extension Fund #2 Special
Revenue Funds, and the capital projects fund. The Community Parkland
Bond Special Revenue Fund had no activity during the year ended June 30,
1991.
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.
Budget basis and GAAP basis financial statements are reconciled as follows:
Special
General Revenue
Fund Funds
Excess (deficiency) of revenues over
expenditures-budgetary basis $700,629 ($799,634)
Less: Unbudgeted refund of
prior year contributions from
Dougherty Regional Fire
Authority 176,216
Dublin Boulevard Extension
Fund #2 excess of revenues over
expenditures 3
Excess (deficiency) .of revenues over
expenditures-GAAP basis jn6,845 ($799,631)
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.
28
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE I - SUHMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued)
G. 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 cash and investments are used in the preparation of the
statement of cash flows as investments are not allocated to specific
funds. Cash and investments represents each funds allocation of pooled
cash and investments and is considered readily available for expenditure.
H. 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.
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.
I. Property, Tag
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)
29
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued)
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 levied are recorded as revenue and receivables in the fiscal
year of levy.
J. 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 at June 30 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.
K. New Funds
During the year the City established two funds:
The Deferred Compensation Agency Fund was established to account for
deferred compensation benefits.
The SB 140 Special Revenue Fund was established to account for state
grant funds to be spent on street related expenditures.
L. Postemployment 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, 1991 those costs totaled approximately $2,310.
K. 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.
30
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 2 - CASH AND INVESTMENTS
A. Cash Deposits
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
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 market value of pledged
securities must equal at least 110% of the City's deposits. California
law also allows financial institutions to secure City deposits by
pledging first trust deed mortgage notes having a value of 150% of the
City's total deposits.
At year end, the carrying amount of the City's deposits was $5,600,346
and the bank balance was $6,811,946. Of the bank balance, $5,056,834 was
covered by federal depository insurance. The balance was covered by
collateral held by the pledging financial institution in the City's name.
The City has waived collateral requirements for deposits which are fully
insured up to $100,000 by the Federal Deposit Insurance Corporation
(FDIC) or Savings Account Insurance Fund (SAIF) .
B. Authorized Investments
Under provision of the City's investment policy, and in accordance with
Section 53601 of the California Government Code, the City may 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
Passbook Savings Account Demand Deposits
Repurchase Agreements
Commercial Paper
Money Market Accounts
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.
31
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 2 - CASH AND INVESTMENTS (Continued)
The City's investments at June 30, 1991 and 1990 comprise:
1991
1990
Category Non Carrying Market Carrying
1 categorized Value Value Amount
Cash deposits:
Cash in banks and
Certificates of
Deposit $5,600,346 $5,600,346 $5,600,346 $7,061,111
Pooled investments:
Securities of the
U.S. Government or
its Agencies $1,300,000 1,300,000 1,292,810 797,878
Local Agency
Investment Fund 10,000,000 10,000,000 10,000,000 9,354,000
Investments with Fiscal
Agents:
Deferred Compensation
Plan Mutual Funds 59,648 59,648 59,648
Securities of the U.S.
Government or its
Agencies 1.718,576 1,718,576 1.765,616 1,714.537
Total of Cash
and Investments $3,018,576 15.659,994 $18,678,570 $18,718,420 $18,927,526
Cash and investments are reported in the general purpose financial
statements as follows:
June 30,
1991 1990
Cash and investments $16,056,660 $16,577,463
Restricted cash and investments 2.621,910 2.350,063
Total cash and investments $18,678,570 $18,927,526
C. Credit Risk, Carrying Amount, and Market Value of Investments
Investments that are 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 and unregistered investments for which the securities are held by
the financial institution's trust department or agent in the City's name;
Category 3 includes uninsured and unregistered investments for which the
securities are held by the financial institution, or by its trust department
or agent but not in the City's name.
32
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 2 - CASH AND INVESTMENTS (Continued)
At June 30, 1991 and 1990 the City had $1,778,224 and $1,714,537 in. cash
and investments held by fiscal agents which is pledged for the payment of
certificates of participation 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 by the either above Code or applicable City
ordinance.
The City entered into no reverse repurchase agreements during the year
ended June 30, 1991.
NOTE 3 - INTERFUND RECEIVABLES AND PAYABLES
The General Fund was owed the amounts below at June 30, 1991 by the funds
listed:
Special Revenue Funds:
Traffic Safety $ 27,240
Transportation Development Act 144,051
Federal Aid Urban Highway 847,114
Community Development Block Grant 2,061
Park Dedication 77,379
State Park Bond Act 12,209
Sales Tax Measure B 3,225
Bond Fund Measure AA 47,349
Safco Grant 15,746
Dublin Boulevard Extension 24,605
Community Parkland 32,977
SB 140 Grant 106,250
Capital Project Fund 23.105
Total amount owed General Fund $1,363,311
The amounts owed represent General Fund advances for expenditures made by these
Funds which will be repaid out of federal and state grants which had been
awarded but not yet funded at June 30, 1991.
33
CITY OF DUBLIN
Notes to Ceneral Purpose Financial Statements
NOTE 4 - FIXED ASSETS
Changes in fixed assets were as follows:
Balance Balance
July 1, 1990 Additions Retirements June 30, 1991
General Fixed Assets
Land $120,000 $120,000
Equipment 259,710 $64,565 324.275
Total $379,710 J4275
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 (354,520) ($471,184) (825,704)
Net $22,363,874 $21,892,690
Internal Service Fund
Machinery & equipment 488,365 80 397 $51,764 516,998
Less: Accumulated
depreciation (297,509) 36 547) (334,056)
Net 190 856 182 942
During the year ended June 30, 1991 the City determined $120,000 of land had
been inadvertently excluded from the general fixed assets account group in
prior years. Accordingly the general fixed assets account group has been
restated to include this land.
34
CITY OF DUBLIN
Notes to the General Purpose Financial Statements
NOTE 5 - CERTIFICATES OF PARTICIPATION
The City has a non-cancellable lease expiring in 2010 with Dublin
Information Inc. (DII) , which used the lease as collateral for the
issuance of the 1988 Refunding Certificates of Participation. The
lease provides for semi-annual payments which are sufficient to pay
principal and interest due on the 1988 Refunding Certificates of
Participation. Ownership of the Civic Center Building reverts to the
City at the end of the lease.
Since the lease is in essence a financing arrangement with ownership of
the financed assets reverting to the City, the assets and the related
debt evidenced by the 1988 Refunding Certificates of Participation have
been included in the City's financial statements. The refunding
Certificates of Participation will be. repaid from enterprise fund
revenues. Refunding Certificates of Participation balances comprised
the following at June 30, 1991 and 1990:
June 30
1991 1990'
Original principal amount $17,230,000 $17,230,000
Less: bond discount, net of amortization 325,169 342,506
principal retirement 420,000
Ending balance $16,484,831 $16,887,494
Annual debt service requirements for the 1988 Refunding Certificates
of Participation, including interest, are as follows:
For the Year
ending June 30 Total
1992 $1,720,670
1993 1,718,970
1994 1,719,595
1995 1,717,095
1996 1,716,320
thereafter 26.543,932
$35,136,582
At June 30, 1991 the balance of the 1985 Certificates of Participation
which were defeased by the 1988 Refunding Certificates of
Participation was $10,990,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.
35
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 6 - DEFICIT FUND BALANCES
The following funds had deficit balances as of June 30, 1991:
Special Revenue Funds:
Traffic Safety $ 35,774
Transportation Development Act 122,620
Federal Aid Urban Highway 356,917
Community Development Block Grant 7,197
Park Dedication 82,961
State Park Bond Act 7,202
Bond Fund Measure AA 47,349
Safco Grant 5,727
Dublin Boulevard Extension 37,398
SB 140 Grant 106,250
Capital Projects Fund 95,335
These deficits will be eliminated through future revenues or through
general fund transfers, once the underlying projects have been completed.
NOTE 7 - TRANSFERS
During the years ended June 30, 1991 and 1990 the General Fund made
residual equity transfers of $13,001 and $60,979, respectively, to the
Internal Service Fund for asset acquisition purposes. During the year
ended June 30, 1990 the General Fund made a residual equity transfer of
$6,768 to the Enterprise Fund for the same purpose.
During the year ended June 30, 1991 the General Fund made an operating
transfer of $4,174 to the Dublin Information Inc. Enterprise Fund for
reimbursement of expenses. An operating transfer of $10,474 was also made
from the State Park Bond Act Special Revenue Fund to the Bond Fund Measure
AA Special Revenue Fund for reimbursement of expenditures.
NOTE 8 - JOINT POWERS AGENCIES/AGREEMENTS
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,
Pleasanton and 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.
36
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 8 - JOINT POWERS AGENCIES/AGREEMENTS (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, 1991.
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. 1 There was no financial activity during the
year ended June 30, 1991.
E. Association of Bay 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; 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 each of the above authorities
is presented below for the year ended June 30, 1990:
Transit
Authority DRFA ABAG
Total assets $2,100,985 $7,153,093 $14,430,400
Total current liabilities 361,512 726,991 8,648,167
Total long-term liabilities 1,290,325
Total equity 1,739,473 5,135,777 5,782,233
Total revenue 3,657,352 4,212,435 5,320,139
Total expenditures 3,525,730 3,574,643 787,785
Other financing uses (45,139)
Contributed capital reductions (83,804)
Net increase in fund equity 2,679 637,792 4,532,354
37
CITY OF DUBLIN
Notes to the 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.
B. 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, 1990. 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) postretirement
benefit increases adjusted 2% annually after the fist two years of
retirement.
38
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, 1990 is as follows:
Pension benefit obligation:
Retirees and beneficiaries currently
receiving benefits and terminated employees
not yet receiving benefits $4,803
Current employees:
Accumulated employee contributions including
allocated investment earnings 307,250
Employer-financed vested 216,647
Employer-financed nonvested 53,674
Total pension benefit obligation 582.374
Net assets available for benefits, at cost
(market value was $764,008 at June 30, 1990) 673.728
Over-funded pension benefit obligation 91 354
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.
39
CITY OF DUBLIN
Notes to Ceneral 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, 1991 and 1990:
1991 1990
Percent Percent
of Covered of Covered
Amount Payroll Amount Payroll
Covered payroll $1,241,152 $ 998,127
Total payroll $1,448,959 $1,215,970
Normal cost,
including employee
contributions $159,311 12.8% $ 180,350 18.0%
Amortized unfunded
(over-funded) pension
benefit obligation (52,400) (5.2)%
Total 159 311 12.8 127 950 12.8%
City contributions $72,430 5.8% $58,081 5.8%
Employee
contributions 86.881 7.0% 69,869 7.0%
Total 159 311 12.8% 127 950 12.8%
D. Trend Information
Trend information gives an indication of the progress made in accumulating
sufficient assets to pay benefits when due. Systemwide ten-year trend
information may be found in the California Public Employees' Retirement
System Annual Reports.
For the fiscal years, 1989-90, 1988-89 and 1987-88, net assets available
for benefits funded 115.7%, 112.1% and 103.1% respectively, of the pension
plan's total pension benefit obligation and the overfunded pension benefit
obligation represented 7.4%, 5.1% and 1.2% respectively, of covered
payroll. In addition, for the three years ended June 30, 1991, 1990 and
1989, the City's contributions to the System, all made in accordance with
actuarially determined requirements, were 12.8%, 12.8% and 12.5%
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.
40
CITY OF DUBLIN
Notes to General Purpose Financial Statements
NOTE 10 - CONTINGENT LIABILITIES
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 be disallowed by the granting agencies cannot be determined at
this time. The City expects such amounts, if any, to be immaterial.
The City is the collecting and paying agent for the San Ramon Road Specific
Improvement Plan Special Assessment Bonds, but has no moral or legal
obligation to repay the $550,000 in bonds which were outstanding as of June
30, 1991.
41
(This Page Left Blank Intentionally)
42
FINANCIAL SECTION
COMBINING FUND STATEMENTS
(This Page Left- Blank Intentionally)
CITY OF DUBLIN
GENERAL FUND
The general fund is used to account for all of the general
revenues of the city that are not specifically levied or
collected for other city funds, and for the expenditures related
to the rendering of general services by the city. The general
fund is used to account for all resources not required to be
accounted for in another fund.
43
CITY OF DUBLIN
GENERAL FUND
COMPARATIVE BALANCE SHEETS
JUNE 30, 1991 AND 1990
1991 1990
ASSETS
Cash and investments $15,136,269 $15,506,342
Receivables:
Accounts 268,625 178,933
Accrued interest 199,249 202,974
Due from other governments 231,987 211,593
Due from other funds 1,363,311 311,763
Prepaid expenses 7,058 12,058
Total Assets $17,206,499 $16,423,663
LIABILITIES
Accounts payable $1,297,031 $1,138,240
Accrued wages 67,630 64,724
Accrued vacation 105,488 85,444
Deposits payable 408,468 628,168
Due to other governments 43,049
Total Liabilities 1,878,617 1,959,625
FUND BALANCES
Reserved for prepaid expenses 7,058 12,058
Designated for authorized expenditures 15,320,824 14,451,980
Total Fund Balances 15,327,882 14,464,038
Total Liabilities and Fund Balances $17,206,499 $16,423,663
44
CITY OF DUBLIN
GENERAL FUND
STATEMENTS OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCES
BUDGET AND ACTUAL
FOR THE YEAR ENDED JUNE 30, 1991
WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1990
1991 1990
Variance
Favorable
Budget Actual (Unfavorable) Actual
REVENUES
Taxes $9,976,400 $10,204,052 $227,652 $9,662,335
Licenses and permits 408,100 248,116 (159,984) 315,010
Intergovernmental 1,027,260 973,266 (53,994) 932,834
Charges for services 1,164,816 1,196,484 31,668 1,090,386
Use of money and property 1,211,870 1,338,947 127,077 1,333,673
Fines and forfeits 20,000 19,476 (524) 19,415
Other revenue 97,500 114,038 16,538 20,609
Total Revenues 13,905,946 14,094,379 188,433 13,374,262
EXPENDITURES
Current:
General government 2,177,502 2,010,105 167,397 1,335,881
Facilities rents 1,719,820 1,579,472 140,348 706,909
Public safety 4,969,554 4,800,963 168,591 4,420,424
Highways and streets 862,659 837,547 25,112 519,166
Health and welfare 27,010 26,277 733 24,580
Community development 2,141,119 1,827,354 313,765 1,566,774
Culture and leisure 1,598,027 1,459,419 138,608 1,250,106
Capital outlay 1,241,025 848,439 392,586 1,169,032
Total Expenditures 14,736,716 13,389,576 1,347,140 10,992,872
EXCESS OF REVENUE OVER
(UNDER)EXPENDITURES (830,770) 704,803 1,535,573 2,381,390
OTHER FINANCING SOURCES
Operating transfers in 849,435
Operating transfers(out) (4,174) (4,174) (75,524)
Total Other Financing Sources(Uses) (4,174) (4,174) 773,911
EXCESS OF REVENUES AND OTHER
FINANCING SOURCES OVER(UNDER)
EXPENDITURES AND OTHER
FINANCING USES ($830,770) 700,629 $1,531,399 3,155,301
Adjustments to budgetary basis 176,216
Fund balances,beginning of year 14,464,038 11,376,484
Residual equity transfers(out) (13,001) (67,747)
Fund balances,end of year $15,327,882 $14,464,038
45
CITY OF DUBLIN
GENERAL FUND
SCHEDULE OF BUDGET VERSUS ACTUAL
DEPARTMENTAL EXPENDITURES
FOR THE YEAR ENDED JUNE 30, 1991
Variance
Favorable
Budget Actual (Unfavorable)
General government:
City Council $121,778 $108,998 $12,780
City Manager 431,768 409,150 22,618
City Attorney 165,000 167,455 (2,455)
Finance department 220,516 210,719 9,797
Building management 320,610 306,015 14,595
Insurance cost center 177,500 136,458 41,042
Elections cost center 3,825 3,066 759
Nondepartmental 736,505 668,244 68,261
Total General Government 2,177,502 2,010,105 167,397
Facilities rents 1,719,820 1,579,472 140,348
Public safety:
Police 2,581,151 2,497,477 83,674
Crossing guards 8,000 2,964 5,036
Traffic signal and street lighting 5,831 (5,831)
Animal control 54,330 49,399 4,931
Disaster preparedness 30,735 11,990 18,745
Fire services JPA 2,295,338 2,233,302 62,036
Total Public safety 4,969,554 4,800,963, 168,591
Highways and streets:
Public works 260,494 252,854 7,640
Street maintenance 289,165 289,164 1
Street sweeping 62,000 59,778 2,222
Street tree maintenance 67,000 57,996 9,004
Street landscape maintenance 182,500 176,255 6,245
Paratransit services 1,500 1,500
Total Highways and streets 862,659 837,547 25,112
Health and welfare 27,010 26,277 733
Community development:
Planning 1,261,937 1,051,890 210,047
Building safety 365,584 352,439 13,145
Engineering 429,992 411,755 18,237
Economic development 83,606 11,270 72,336
Total Community development 2,141,119 1,827,354 313,765
Culture and leisure:
Library services 149,650 149,650
Cultural activities 32,785 32,785
Park maintenance 518,570 478,382 40,188
Community cable television 46,000 46,000
Recreation administration 154,760 146,545 8,215
Playgrounds 67,030 68,141 (1,111)
Shannon center 94,861 98,492 (3,631)
Preschool 28,877 28,612 265
Teens program 44,881 25,638 19,243
Field scheduling 124,931 91,457 33,474
Special events 25,140 22,490 2,650
Senior center 96,401 85,957 10,444
Recreation instruction 62,090 53,026 9,064
Aquatics 152,051 165,029 (12,978)
Total Culture and leisure 1,598,027 1,459,419 138,608
Capital outlay:
General capital improvement projects 160,815 8,366 152,449
Community improvements 125,681 120,065 5,616
Parks 776,997 632,434 144,563
Street construction and improvements 177,532 87,574 89,958
Total Capital outlay 1,241,025 848,439 392,586
Total Expenditures $14,736,716 $13,389,576 $1,347,140
46
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 bikepaths 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.
SB140 GRANT FUND
Established to account for grant receipts from the State used for
capital improvements on local streets.
47
(This Page Left Blank Intentionally)
48
CITY OF DUBLIN
SPECIAL REVENUE FUNDS
MAINTENANCE DISTRICTS
Established to account for revenue and related expenditures of
lighting and landscape activities.
DUBLIN BOULEVARD EXTENSION FUND
Established to identify the costs associated with determining the
types of financing available for various options on the
improvements needed for Dublin Boulevard. Dublin Boulevard
Extension Fund #1 accounts for improvements financed with City
resources, whereas Dublin Boulevard Extension Fund #2 accounts
for improvements financed with resources to be received from
other governmental agencies.
COMMUNITY PARKLAND ACT FUND
Established to account for State bond proceeds for park
improvements.
49
CITY OF DUBLIN
SPECIAL REVENUE FUNDS
COMBINING BALANCE SHEETS
JUNE 30, 1991
WITH COMPARATIVE AMOUNTS AS OF JUNE 30, 1990
Federal
Transportation Special Aid Community State
Traffic State Development Criminal Urban Development Park Park
Safety Gas Tax Act Activity Highway Block Grant Dedication Bond Ac
ASSETS
Cash and investments $5,831 $111,344 $47,350 $27,588 $10,367 $5,00
Accounts receivable
Due from other governments $492,800
Total Assets $5,831 $111,344 $47,350 $27,588 $492,800 $10,367 $5,00
LIABILITIES
Accounts payable $14,365 $36,203 $25,919 $693 $2,603 $5,136 $15,949
Due to other funds 27,240 144,051 847,114 2,061 77,379 $12,20
Total Liabilities 41,605 36,203 169,970 693 849,717 7,197 93,328 12,209
FUND BALANCES(DEFICITS)
Unreserved:
Designated for authorized expenditures 75,141 26,895
Undesignated fund balances(deficits) (35,774) (122,620) (356,917) (7,197) (82,961) (7,20
Total Fund Balances(Deficits) (35,774) 75,141 (122,620) 26,895 (356,917) (7,197) (82,961) (7,20
Total Liabilities and Fund Balances $5,831 $111,344 $47,350 $27,588 $492,800 $10,367 $5,00
50
MAINTENANCE DISTRICTS TOTALS
Dougherty Dublin Dublin Community
Sales Tax Bond Fund Safco Street Stagecoach Landscape Boulevard Boulevard Parkland SB 140
Measure B Measure AA Grant Lighting Landscape &Lighting Extension p1 Extension#2 Bond Grant 1991 1990
$13,282 $5,019 $144,372 $27,771 $144,394 $52 $48,000 $590,377 $657,074
5,000 5,000 12,827
492,800 222,121
$13,282 $10,019 $144,372 $27,771 $144,394 $52 $48,000 $1,088,177 $892,022
$1,856 $13,773 $4,761 $7,563 $12,845 $141,666 $174,323
3,225 $47,349 $15,746 23,105 $1,500 $32,977 $106,250 1,340,206 311,763
5,081 47,349 15,746 13,773 4,761 7,563 35,950 1,500 32,977 106,250 1,481,872 486,086
8,201 130,599 23,010 136,831 15,023 415,700 506,394
(47,349) (5,727) (35,950) (1,448) (106,250) (809,395) (100,458)
8,201 (47,349) (5,727) 130,599 23,010 136,831 (35,950) (1,448) 15,023 (106,250) (393,695) 405,936
$13,282 $10,019 $144,372 $27,771 $144,394 $52 $48,000 $1,088,177 S892;022
51
CITY OF DUBLIN
SPECIAL REVENUE FUNDS
COMBINING STATEMENTS OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCES
FOR THE YEAR ENDED JUNE 30, 1991
WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1990
Transportation Special Federal Community
Traffic State Development Criminal Aid Urban Development Park State Park
Safety Gas Tax Act Activity Highway Block Grant Dedication Bond Act
REVENUES
Taxes
Sales and use taxes
Intergovernmental
FAU grant $723,546
Gasoline tax $378,020
TDA Act funds $58,583
State park bond
State parkland grant
Local grant
Fines and forfeits
Vehicle code fines $62,891
Use of money and property
Interest 13,375 $1,810
Other revenue
Park dedication fees
Miscellaneous 13,109
Special assessments
Total Revenues 62,891 391,395 58,583 14,919 723,546
EXPENDITURES
General government
Service and supplies 3,904
Public safety
Service and supplies 43,000 12,606
Contract services 59,125
Highways and streets
Service and supplies 57,005
Contract services 30,136
Community development
Contract services
Culture and leisure
Service and supplies
Capital outlay
Service and supplies 308,486 81,831 1,078,430 $7,197 $142,993 $5,467
Contract services 21,043 2,655 45,555
Total Expenditures 102,125 395,627 106,778 12,606 1,081,085 7,197 188,548 5,467
EXCESS OF REVENUES OVER
(UNDER)EXPENDITURES (39,234) (4,232) (48,195) 2,313 (357,539) (7,197) (188,548) (5,467)
OTHER FINANCING SOURCES(USES)
Operating transfers in 10,474
Operating transfers(out)
Total Other Financing Sources(Uses) 10,474
EXCESS OF REVENUES AND OTHER FINANCING
SOURCES OVER(UNDER)EXPENDITURES
AND OTHER FINANCING USES (39,234) (4,232) (48,195) 2,313 (357,539) (7,197) (188,548) 5,007
Fund balances(deficits),beginning of the year 3,460 79,373 (74,425) 24,582 622 105,587 (12,209)
Fund balances(deficits),end of the year ($35,774) $75,141 ($122,620) $26,895 ($356,917) ($7,197) ($82,961) ($7,202)
52
MAINTENANCE DISTRICTS TOTALS
Dougherty Dublin Dublin Community
Sales Tax Bond Fund Safeo Street Stagecoach Landscape Boulevard Boulevard Parkland SB 140
Measure B Measure AA Grant Lighting Landscape &Lighting Extension#1 Extension k2 Act Grant 1991 1990
$108,156 $108,156 $106,941
723,546 173,121
378,020 332,031
58,583 75,000
64,815
$5,000 5,000 90,000
$426,138 426,138
62,891 71,806
4,159 $7,426 $1,292 $9,464 $3 37,529 60,482
660,367
3,969 17,078
171,006 45,186 65,236 281,428 287,205
112,315 426,138 5,000 182,401 46,478 74,700 3 2,098,369 1,921,768
3,904 4,716
152,809 208,415 193,603
252 59,377 58,820
33 7,982 22,105 87,125 63,112
4,122 32,346 50,351 116,955 439,363
16,730
175
112,012 461,367 $281 $103,437 2,301,501 932,974
12,988 35,669 2,813 120,723 235,100
125,000 461,367 157,216 40,328 72,456 35,950 106,250 2,898,000 1,944,593
(12,685) (35,229) 5,000 25,185 6,150 2,244 (35,950) 3 (106,250) (799,631) (22,825)
10,474 8,660
(10,474) (10,474) (849,435)
(10,474) (840,775)
(12,685) (45,703) 5,000 25,185 6,150 2,244 (35,950) 3 (106,250) (799,631) (863,600)
20,886 (1,646) (10,727) 105,414 16,860 134,587 (1,451) $15,023 405,936 1,269,536
$8,201 ($47,349) ($5,727) $130,599 $23,010 $136,831 ($35,950) ($1,448) 515,023 ($106,250) (5393,695) $405,936
53
CITY OF DUBLIN
BUDGETED SPECIAL REVENUE FUNDS
COMBINING STATEMENTS OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCES
BUDGET AND ACTUAL
FOR THE YEAR ENDED JUNE 30, 1991
TRAFFIC SAFETY STATE GAS TAX
Variance Variance
Favorable Favorable
Budget Actual (Unfavorable) Budget Actual (Unfavorable)
REVENUES
Taxes
Sales and use taxes
Intergovernmental
FAU grant
Gasoline tax $345,000 $378,020 $33,020
TDA Act funds
CDBG Funds
SB 140 Grant
State park bond
State parkland grant
Local grant
Fines and forfeits
Vehicle code fines $80,000 $62,891 ($17,109)
Use of money and property
Interest 1,000 (1,000) 2,650 13,375 10,725
Other revenue
Park dedication fees
Miscellaneous
Special assessments
Total Revenues 81,000 62,891 (18,109) 347,650 391,395 43,745
EXPENDITURES
General government
Service and supplies
Public safety
Service and supplies 43,000 43,000
Contract services 59,125 59,125
Highways and streets
Service and supplies 57,005 57,005
Contract services 30,136 30,136
Capital outlay
Service and supplies 308,486 308,486
Contract services
Total Expenditures 102,125 102,125 395,627 395,627
EXCESS OF REVENUES OVER
(UNDER)EXPENDITURES (21,125) (39,234) (18,109) (47,977) (4,232) 43,745
OTHER FINANCING SOURCES (USES)
Operating transfers in
Operating transfers(out)
Total Other Financing Sources(Uses)
EXCESS OF REVENUES AND OTHER FINANCING
SOURCES OVER(UNDER)EXPENDITURES
AND OTHER FINANCING USES ($21,125) (39,234) ($18,109) ($47,977) (4,232) $43,745
Fund balances(deficits),beginning of the year 3,460 79,373
Fund balances(deficits), end of year ($35,774) $75,141
54
FEDERAL AID URBAN
TRANSPORTATION DEVELOPMENT ACT SPECIAL CRIMINAL ACTIVITY HIGHWAY
Variance Variance Variance
Favorable Favorable Favorable
Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable)
$1,354,080 $723,546 ($630,534)
$150,000 $58,583 ($91,417)
$2,100 $1,810 ($290)
12,000 13,109 1,109
150,000 58,583 (91,417) 14,100 14,919 819 1,354,080 723,546 (630,534)
5,492 3,904 1,588
20,150 12,606 7,544
95,665 81,831 13,834 1,078,430 1,078,430
21,043 21,043 2,655 2,655
122,200 106,778 15,422 20,150 12,606 7,544 1,081,085 1,081,085
27,800 (48,195) (75,995) (6,050) 2,313 8,363 272,995 (357,539) (630,534)
27,800 (48,195) ($75,995) ($6,050) 2,313 $8,363 $272,995 (357,539) ($630,534)
(74,425) 24,582 622
($122,620) $26,895 ($356,917)
55 (Continued)
CITY OF DUBLIN
BUDGETED SPECIAL REVENUE FUNDS
COMBINING STATEMENTS OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCES
BUDGET AND ACTUAL
FOR THE YEAR ENDED JUNE 30, 1991
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
Gasoline tax
TDA Act funds
CDBG Funds $19,800 ($19,800)
SB 140 Grant
State park bond
State parkland grant
Local grant
Fines and forfeits
Vehicle code fines
Use of money and property
Interest $35,200 ($35,200)
Other revenue
Park dedication fees 327,000 (327,000)
Miscellaneous
Special assessments
Total Revenues 19,800 (19,800) 362,200 (362,200)
EXPENDITURES
General government
Service and supplies
Public safety
Service and supplies
Contract services
Highways and streets
Service and supplies
Contract services
Capital outlay
Service and supplies 7,435 $7,197 238 152,349 $142,993 9,356
Contract services 2,265 2,265 45,555 45,555
Total Expenditures 9,700 7,197 2,503 197,904 188,548 9,356
EXCESS OF REVENUES OVER
(UNDER)EXPENDITURES 10,100 (7,197) (17,297) 164,296 (188,548) (352,844)
OTHER FINANCING SOURCES(USES)
Operating transfers in
Operating transfers(out)
Total Other Financing Sources(Uses)
EXCESS OF REVENUES AND OTHER FINANCING
SOURCES OVER(UNDER)EXPENDITURES
AND OTHER FINANCING USES $10,100 (7,197) ($17,297) $164,296 (188,548) ($352,844)
Fund balances(deficits), beginning of the year 105,587
Fund balances(deficits), end of year ($7,197) ($82,961)
56
STATE PARK BOND ACT SALES TAX MEASURE B BOND FUND MEASURE AA
Variance Variance Variance
Favorable Favorable Favorable
Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable)
$109,000 $108,156 ($844)
$7,202 (7,202)
$473,487 $426,138 ($47,349)
1,000 4,159 3,159
7,202 (7,202) 110,000 112,315 2,315 473,487 426,138 (47,349)
5,467 $5,467 116,757 112,012 4,745 461,367 461,367
8,243 12,988 (4,745)
5,467 5,467 125,000 125,000 461,367 461,367
1,735 (5,467) (7,202) (15,000) (12,685) 2,315 12,120 (35,229) (47,349)
10,474 10,474
(10,474) (10,474)
10,474 10,474 (10,474) (10,474)
$1,735 5,007 $3,272 ($15,000) (12,685) $2,315 $12,120 (45,703) ($57,823)
(12,209) 20,886 (1,646)
($7,202) $8,201 ($47,349)
(Continued)
57
CITY OF DUBLIN
BUDGETED SPECIAL REVENUE FUNDS
COMBINING STATEMENTS OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCES
BUDGET AND ACTUAL
FOR THE YEAR ENDED JUNE 30, 1991
MAINTENANCE DISTRICTS
SAFCO GRANT STREET LIGHTING
Variance Variance
Favorable Favorable
Budget Actual (Unfavorable) Budget Actual (Unfavorable)
REVENUES
Taxes
Sales and use taxes
Intergovernmental
FAU grant
Gasoline tax
TDA Act funds
CDBG Funds
SB 140 Grant
State park bond
State parkland grant $10,000 $5,000 ($5,000)
Local grant
Fines and forfeits
Vehicle code fines
Use of money and property
Interest $6,000 $7,426 $1,426
Other revenue
Park dedication fees
Miscellaneous 5,000 3,969 (1,031)
Special assessments 160,000 171,006 11,006
Total Revenues 10,000 5,000 (5,000) 171,000 182,401 11,401
EXPENDITURES
General government
Service and supplies
Public safety
Service and supplies 157,835 152,809 5,026
Contract services 2,815 252 2,563
Highways and streets
Service and supplies 33 (33)
Contract services 6,000 4,122 1,878
Capital outlay
Service and supplies
Contract services
Total Expenditures 166,650 157,216 9,434
EXCESS OF REVENUES OVER
(UNDER)EXPENDITURES 10,000 5,000 (5,000) 4,350 25,185 20,835
OTHER FINANCING SOURCES(USES)
Operating transfers in
Operating transfers(out)
Total Other Financing Sources(Uses)
EXCESS OF REVENUES AND OTHER FINANCING
SOURCES OVER(UNDER)EXPENDITURES
AND OTHER FINANCING USES $10,000 5,000 ($5,000) $4,350 25,185 $20,835
Fund balances(deficits),beguming of the year (10,727) 105,414
Fund balances(deficits), end of year ($5,727) $130,599
58
MAINTENANCE DISTRICTS
DOUGHERTY LANDSCAPE
STAGECOACH LANDSCAPE AND LIGHTING DUBLIN BOULEVARD EXTENSION N1
Variance Variance Variance
Favorable Favorable Favorable
Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable)
$800 $1,292 $492 $8,000 $9,464 $1,464
$441,000 (441,000)
41,900 45,186 3,286 72,500 65,236 (7,264)
42,700 46,478 3,778 80,500 74,700 (5,800) 441,000 (441,000)
11,430 7,982 3,448 19,160 22,105 (2,945)
31,700 32,346 (646) 70,200 50,351 19,849
281 281
62,719 35,669 27,050
43,130 40,328 2,802 89,360 72,456 16,904 63,000 35,950 27,050
(430) 6,150 6,580 (8,860) 2,244 11,104 378,000 (35,950) (413,950)
($430) 6,150 $6,580 ($8,860) 2,244 $11,104 $378,000 (35,950) ($413,950)
16,860 134,587
$23,010 $136,831 ($35,950)
(Continued)
59
CITY OF DUBLIN
BUDGETED SPECIAL REVENUE FUNDS
COMBINING STATEMENTS OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCES
BUDGET AND ACTUAL
FOR THE YEAR ENDED JUNE 30, 1991
SB 140 GRANT TOTAL
Variance Variance
Favorable Favorable
Budget Actual (Unfavorable) Budget Actual (Unfavorable)
REVENUES
Taxes
Sales and use taxes $109,000 $108,156 ($844)
Intergovernmental
FAU grant 1,354,080 723,546 (630,534)
Gasoline tax 345,000 378,020 33,020
TDA Act funds 150,000 58,583 (91,417)
CDBG Funds 19,800 (19,800)
SB 140 Grant $106,252 ($106,252) 106,252 (106,252)
State park bond 7,202 (7,202)
State parkland grant 10,000 5,000 (5,000)
Local grant 473,487 426,138 (47,349)
Fines and forfeits
Vehicle code fines 80,000 62,891 (17,109)
Use of money and property
Interest 56,750 37,526 (19,224)
Other revenue
Park dedication fees 327,000 (327,000)
Miscellaneous 458,000 17,078 (440,922)
Special assessments 274,400 281,428 7,028
Total Revenues 106,252 (106,252) 3,770,971 2,098,366 (1,672,605)
EXPENDITURES
General government
Service and supplies 5,492 3,904 1,588
Public safety
Service and supplies 220,985 208,415 12,570
Contract services 61,940 59,377 2,563
Highways and streets
Service and supplies 87,595 87,125 470
Contract services 138,036 116,955 21,081
Capital outlay
Service and supplies 103,437 $103,437 2,329,674 2,301,501 28,173
Contract services 2,813 2,813 145,293 120,723 24,570
Total Expenditures 106,250 106,250 2,989,015 2,898,000 91,015
EXCESS OF REVENUES OVER
(UNDER)EXPENDITURES 2 (106,250) (106,252) 781,956 (799,634) (1,581,590)
OTHER FINANCING SOURCES(USES)
Operating transfers in 10,474 10,474
Operating transfers(out) (10,474) (10,474)
Total Other Financing Sources(Uses)
EXCESS OF REVENUES AND OTHER FINANCING
SOURCES OVER(UNDER)EXPENDITURES
AND OTHER FINANCING USES $2 (106,250) ($106,252) $781,956 (799,634) ($1,581,590)
Fund balances(deficits),beginning of the year 392,364
Fund balances(deficits), end of year ($106,250) ($407,270)
60
CITY OF DUBLIN
BUDGETED SPECIAL REVENUE FUNDS
SCHEDULE OF BUDGET VERSUS ACTUAL
DEPARTMENTAL EXPENDITURES
FOR THE YEAR ENDED JUNE 30, 1991
Variance
Favorable
Budget Actual (Unfavorable)
EXPENDITURES
General government-city council $5,492 $3,904 $1,588
Public safety:
Police 20,150 12,606 7,544
Crossing guards 24,125 24,125
Traffic signals and street lighting 238,650 231,061 7,589
Total Public Safety 282,925 267,792 15,133
Highways and streets:
Street tree maintenance 13,500 4,256 9,244
Street landscaping maintenance 112,990 104,061 8,929
Street maintenance 82,141 82,141
Engineering 17,000 13,622 3,378
Total Highways and Streets 225,631 204,080 21,551
Capital outlay:
San Ramon Road improvements,phase four 1,333,737 1,333,737
Dublin Boulevard extension 63,000 35,950 27,050
1990-91 Annual street overlay project 231,250 231,250
Shannon Center renovations 8,151 8,151
Alamo Creek Park project 122,571 122,570 1
Dublin High baseball field renovation 27,025 17,699 9,326
Dublin High girls athletic field renovation 17,640 17,611 29
Shannon Park renovations 489,351 489,351
Senior Citizen kitchen upgrade 9,700 7,197 2,503
Catch basin grate replacement 44,454 44,380 74
I-580/I-680 ramp widening 55,834 55,834
Dougherty Road bike path project 72,254 58,494 13,760
Total Capital Outlay 2,474,967 2,422,224 52,743
Total Expenditures $2,989,015 $2,898,000 $91,015
61
CITY OF DUBLIN
CAPITAL PROJECTS FUND
The capital projects fund is used to account for acquisition and
construction of capital facilities other than those financed by
proprietary funds.
62
CITY OF DUBLIN
CAPITAL PROJECTS FUND
COMPARATIVE BALANCE SHEETS
JUNE 30, 1991 AND 1990
1991 1990
ASSETS
Cash and investments $61,789 $104,965
Total Assets $61,789 $104,965
LIABILITIES
Account payable $925 $6,429
Deposits payable 133,094 149,372
Due to other funds 23,105
Total Liabilities 157,124 155,801
FUND DEFICITS
Undesignated (95,335) (50,836)
Total Fund Deficits (95,335) (50,836)
Total Liabilities and Fund Deficits $61,789 $104,965
63
CITY OF DUBLIN
CAPITAL PROJECTS FUND
STATEMENTS OF REVENUES, EXPENDITURES
AND CHANGES IN FUND DEFICITS
BUDGET AND ACTUAL
FOR THE YEAR ENDED JUNE 30, 1991
WITH COMPARATIVE AMOUNTS FOR THE YEAR ENDED JUNE 30, 1990
1991 1990
Variance
Favorable
Budget Actual (Unfavorable) Actual
REVENUES
Use of money and property $2,000 $11,875 $9,875 $11,727
Other revenue 418,565 76,091 (342,474) 227,808
Total Revenues 420,565 87,966 (332,599) 239,535
EXPENDITURES
Capital outlay
Land,equipment and other facilities 181,936 63,984 117,952 228,815
Contractual services 236,629 68,481 168,148 86,762
Total Expenditures 418,565 132,465 286,100 315,577
EXCESS OF REVENUES OVER
(UNDER)EXPENDITURES 2,000 (44,499) (46,499) (76,042)
OTHER FINANCING SOURCES
Operating transfer in 66,864
EXCESS OF REVENUES AND OTHER
FINANCING SOURCES OVER(UNDER)
EXPENDITURES $2,000 ($44,499) ($46,499) ($9,178)
Fund deficits,beginning of year (50,836) (41,658)
Fund deficits,end of year ($95,335) ($50,836)
64
CITY OF DUBLIN
CAPITAL PROJECTS FUND
SCHEDULE OF BUDGET VERSUS ACTUAL
DEPARTMENTAL EXPENDITURES
FOR THE YEAR ENDED JUNE 30, 1991
Variance
Favorable
Budget Actual (Unfavorable)
Capital outlay:
City entrance signs $9000 $9,000
Dublin High school football renovation 172,936 54,985 $117,951
Frederiksen Kindergarten tot lot 5,000 5,250 (250)
Dublin Boulevard improvements 231,629 60,726 170,903
Nondepartmental 2,504 (2,504)
Total Capital Outlay 418,565 132,465 286,100
Total Expenditures $418,565 $132,465 $286,100
65
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, ordinances 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.
66
CITY OF DUBLIN
AGENCY FUNDS
STATEMENT OF CHANGES IN ASSETS AND LIABILITIES
FOR THE YEAR ENDED JUNE 30, 1991
Balance Balance
June 30, 1990 Additions Reductions July 1, 1991
SAN RAMON ROAD SPECIFIC IMPROVEMENT PLAN
Restricted cash and investments $554,390 $344,164 ($54,868) $843,686
Due to bondholders 554,390 $344,164 ($54,868) $843,686
EMPLOYEE DEFERRED COMPENSATION PLAN
Restricted cash and investments $59,648 $59,648
Deferred compensation payable $59,648 $59,648
TOTAL AGENCY FUNDS
Restricted cash and investments $554,390 $403,812 ($54,868) $903,334
Total Assets $554,390 $403,812 ($54,868) $903,334
Due to bondholders $554,390 $344,164 ($54,868) $843;686
Deferred compensation payable 59,648 59,648
Total Liabilities $554,390 $403,812 ($54,868) $903,334
67
STATISTICAL SECTION
(This Page Left Blank Intentionally)
CITY OF DUBLIN
STATISTICAL SCHEDULES
Statistical tables are included to provide data on the city' s
demographic, economic and political characteristics. They will
help the user to understand the city and its fiscal affairs
beyond the level which is provided by the general purpose
financial statements and supporting schedules included in the
financial section of this report.
69
CITY OF DUBLIN
GOVERNMENTAL EXPENDITURES BY FUNCTION
ALL GOVERNMENTAL FUND TYPES
LAST NINE FISCAL YEARS
PUBLIC
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
NOTE:CITY WAS INCORPORATED IN FEBRUARY 1982
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.
70
CITY OF DUBLIN
GENERAL GOVERNMENTAL REVENUES BY SOURCE
ALL GOVERNMENTAL FUND TYPES
LAST NINE FISCAL YEARS
REVENUES USE OF
LICENSES FROM INTER- CHARGES MONEY FINES
FISCAL AND GOVERNMENTAL FOR AND AND OTHER SPECIAL
YEAR TAXES PERMITS AGENCIES SERVICES PROPERTY FORFEITS REVENUE ASSESSMENT 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
SOURCE: CITY OF DUBLIN ANNUAL FINANCIAL REPORT
NOTE: CITY WAS INCORPORATED IN FEBRUARY 1982
71
CITY OF DUBLIN
ASSESSED AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTY
LAST NINE 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
SOURCE: ALAMEDA COUNTY OFFICE OF THE AUDITOR-CONTROLLER
NOTE: CITY WAS INCORPORATED IN FEBRUARY 1982
72
CITY OF DUBLIN
PROPERTY TAX RATES
ALL OVERLAPPING GOVERNMENTS
LAST NINE 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
SOURCE: ALAMEDA COUNTY OFFICE OF THE AUDITOR-CONTROLLER
NOTE: CITY WAS INCORPORATED IN FEBRUARY 1982
73
CITY OF DUBLIN
COMPUTATION OF LEGAL DEBT MARGIN
JUNE 30, 1991
Assessed valuation
Assessed value $1,290,430,461
Add back exempt real property 45,607,493
Total Assessed Value $1,336,037,954
Legal debt margin :
Debt limitation - 15 percent of total assessed value $200,405,693
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.
74
CITY OF DUBLIN
COMPUTATION OF DIRECT AND OVERLAPPING DEBT
JUNE 30, 1991
NET DEBT
PERCENTAGE OUTSTANDING
APPLICABLE APPLICABLE
TO CITY OF TO,CITY
JURISDICTION DUBLIN OF DUBLIN
Alameda County Authorities 2.232 $4,015,011
Alameda County Superintendent of Schools 2.232 182,801
Oakland-Alameda County Coliseum Authority 1.116 160,592
Bay Area Rapit Transit District 0.844 2,661,976
Alameda County Flood Control District, Zone#7 13.027 93,794
Amador Valley Joint Union High School District
and Certificates of Participation 98.877 244,864 (1)
Dublin Joint Unified School District 98.877 3,997,829
Murray School District 98.877 353,554
East Bay Regional Park District 1.283 761,717
Dublin-San Ramon Community Services District I.D. #1 59.209 41,446
Bay Area Pollution Control Authority 0.393 884
City of Dublin Certificates of Participation 100.000 16,810,000
City of Dublin 1915 Act Bonds 100.000 550,000
TOTAL GROSS DIRECT AND OVERLAPPING BONDED DEBT 29,874,468
LESS: OAKLAND-ALAMEDA COUNTY COLISEUM AUTHORITY
(100% SELF-SUPPORTING) 160,592
TOTAL $29,713,876
(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/91: $1,781,613
SOURCE: CALIFORNIA MUNICIPAL STATISTICS, INC. AND CITY FINANCE DEPARTMENT.
75
CITY OF DUBLIN
DEMOGRAPHIC STATISTICS
LAST NINE 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
*INFORMATION NOT AVAILABLE
SOURCE: STATE OF CALIFORNIA DEPT.OF FINANCE-POPULATION RESEARCH UNIT
NOTE: CITY INCORPORATED IN FEBRUARY 1982
76
CITY OF DUBLIN
PROPERTY VALUE, CONSTRUCTION AND BANK DEPOSITS
LAST NINE 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
*INFORMATION NOT AVAILABLE
SOURCES: FINDLEY REPORTS, INC. AND CITY BUILDING DEPARTMENT STATUS REPORTS
77
CITY OF DUBLIN
CALIFORNIA PUBLIC EMPLOYEES RETIREMENT SYSTEM
FUNDING ANALYSIS
FISCAL YEARS 1986-1990
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%
THE ABOVE INFORMATION WAS NOT AVAILABLE FOR YEARS PRIOR TO
1986 OR FOR FISCAL YEAR 1991.
SOURCE: CALFORNIA PUBLIC EMPLOYEES RETIREMENT SYSTEM. (PERS)
78
CITY OF DUBLIN
MISCELLANEOUS STATISTICAL DATA
JUNE 30, 1991
Date of Incorporation February 1982 Education:
Form of Government Council/Manager I. Public:
Employees 87 Elementary Schools 3
Population 23,484 Middle School 1
Area 8 Sq. Miles High School 1
Miles of streets 52.60 Continuation 1
Miles of Curbs 124.70 Teachers 157
Signaled Intersections 20 Elementary Classrooms 54
Number of Street Lights 1,693 Middle School Classrooms 39
Average Daily Trips on I-680 109,000 High School Classrooms 41
Average Daily Trips on I-580 145,000 Continuation School Classrooms 2
Fire Protection: Students Enrolled.
Dougherty Regional Fire Authority September 1982 3,643
Number of Stations 2 September 1983 3,442
Number of Firefighters 45 September 1984 3,354
September 1985 3,326
Police Protection: September 1986 3,407
Number of Stations 1 September 1987 3,499
Number 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
Parks and Recreation:
Parks 9 II. Private:
Arcres in Parks 147 Valley Lutheran School (Elementary) 131
Valley Christian Elementary School 512
Valley Christian Junior High School 83
Valley Christian High School 152
Number of Registered Voters 9,731 St. Raymonds School (Elementary)' 255
Community Facilities:
Dublin Civic Center
Dublin Senior Center
Dublin Shannon Center
Dublin Swim Center
Source: City and School District Records
79
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 AN40UNT OF 1985 CERTIFICATES OF PARTICIPATION
DEFEASED IN 1988 AND NO LONGER THE CITY'S DEBT
SOURCE: CITY OF DUBLIN ANNUAL FINANCIAL REPORT
80
CITY OF DUBLIN
SCHEDULE OF 1988 CERTIFICATES OF PARTICIPATION COVERAGE
LAST THREE FISCAL YEARS
NET REVENUE DEBT SERVICE
DIRECT AVAILABLE REQUIREMENT
FISCAL GROSS OPERATING FOR DEBT
YEAR REVENUE(1) EXPENSES (2) SERVICE PRINCIPAL INTEREST TOTAL COVERAGE
1988-1989 $1,547,681 $33,328 $1,514,353 $1,195,838 $1,195,838 126.64%
1989-1990 1,452,254 30,945 1,421,309 1,299,820 1,299,820 109.35%
1990-1991 1,740,720 42,264 1,698,456 420,000 1,271,468 1,691,468 100.41%
(1)GROSS REVENUE INCLUDES RENT, INTEREST INCOME AND 1988 CERTIFICATES
OF PARTICIPATION PROCEEDS EARMARKED FOR DEBT SERVICE.
(2)DIRECT OPERATING EXPENSES EXCLUDES INTEREST AND DEPRECIATION
SOURCE: CITY OF DUBLIN ANNUAL FINANCIAL REPORT
81
I
i
CITY OF DUBLIN
PROPERTY TAX LEVIES AND COLLECTIONS
LAST EIGHT 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`70
1981986 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.94%
1990-1991 3,570,018 3,399,795 95.23%
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
82
CITY OF DUBLIN
PRINCIPAL TAXPAYERS
JUNE 30, 1991
PERCENT OF
TOTAL
ASSESSED ASSESSED
TAXPAYER VALUE VALUE
Belford Peter B. and Kirsten N. 29,070,097 2.25%
Metric Institutional Company Investment Partners 19,954,320 1.55%
Cottonwood Associates 17,698,948 1.37%
Phoenix Mutual Life Insurance Company 14,095,924 1.09%
Dublin Associates 13,958,872 1.08%
Montgomery Ward Development Corporation 13,416,106 1.04%
Chevron U.S.A. Inc. 12,798,129 .99%
Kildara Properties 12,141,342 .95%
Amador Lakes Associates 12,069,385 .94%
Dublin Sprung Inc. 11,042,620 .86%
SOURCE: COUNTY OF ALAMEDA
83
(This Page Left Blank Intentionally)
CITY OF DUBLIN
RECOMMENDATIONS FOR IMPROVEMENTS
IN INTERNAL CONTROL
YEAR ENDED JUNE 30, 1991
A4ZE &
ASSOCIATES
- ACCOUNTANCY CORPORATION
1670 Riviera Avenue- Suite 100
Walnut Creek, California 94596
(510) 930-0902 • (916)972-7333
FAX(510)930-0135
The Honorable Mayor and
City Council
City of Dublin
Dublin, California
We have audited the general purpose financial statements of the City of Dublin
for the year ended June 30, 1991, and have issued our report thereon dated
October 18, 1991. As part of our audit, we made a study and evaluation of the
system of internal. accounting control to the extent we considered necessary to
evaluate the system as required by generally accepted auditing standards. The
purpose of our study and evaluation was to determine the nature, timing, and
extent of the auditing procedures necessary for expressing an opinion on the
financial statements. Our study and evaluation was more limited than would be
necessary to express an opinion on the system of internal accounting control
taken as a whole.
Management is responsible for establishing and maintaining a system of internal
accounting control. In fulfilling this responsibility, estimates and judgments
by management are required to assess the expected benefits and related costs of
control procedures. The objectives of a system are to provide management with
reasonable, but not absolute assurance that assets are safeguarded against loss
from unauthorized use or disposition, and that transactions are executed in
accordance with management's authorization and recorded properly to permit the
preparation of financial statements in accordance with generally accepted
accounting principles.
Because of inherent limitations in any system of internal accounting control,
errors or irregularities may nevertheless occur and not be detected. Also,
projections of any evaluation of the system to future periods is subject to the
risk that procedures may become inadequate because of changes in conditions or
that the degree of compliance with the procedures may deteriorate.
Our study and evaluation made for the limited purpose described in the first
paragraph would not necessarily disclose all material weaknesses in the
system. Accordingly, we do not express an opinion on the system of internal
accounting control of the City of Dublin taken at whole. Our study and
evaluation disclosed no condition that we believe to be a material weakness.
However, our audit disclosed the following areas in which internal controls
could be strengthened:
A Professional Corporation
CITY OF DUBLIN
MANAGEMENT RECOMMENDATIONS
RECONNENDATION 1 - PROCEDURES SHOULD BE ESTABLISHED TO ALLOW ELECTRONIC
DATA PROCESSING TO RESUME OPERATIONS IN THE EVENT OF
AN INTERRUPTION
During our review of the City's electronic data processing
operations in the Finance Department we noted the following
should be addressed:
1) Backups of data and program files should be stored offsite in
a fire safe location and include data for the prior twelve
months of operations.
2) The City should develop an emergency plan for use in the event
of a natural disaster. This plan should specifically address
recovery of backups, an alternative site for data processing
and training of staff in these emergency procedures.
3) Insurance coverage should be expanded to cover the costs of
media recovery and business interruption due to loss of
electronic data processing functions.
RECOM4ENDATION 2 - GRANT REIMBURSEMENTS SHOULD BE BILLED MORE TIMELY
During our Single Audit Act work we noted that $357,539 of
Federal Aid Urban grant costs, $7,197 in Community Development
Block Grant Costs, and $106,778 in Transportation Development Act
costs were incurred during the year ended June 30, 1991, but that
reimbursement was not requested for these costs until after
October 1991. Reimbursements should be requested for costs
incurred under such grants as soon as possible after being
incurred; progress billings are appropriate.
RECOMMENDATION 3 - THE CITY SHOULD REVISE ITS APPROPRIATION LIMITS TO
COMPLY WITH PROPOSITION 111 REQUIREMENTS
During our tests of compliance with Proposition 111 we noted the
City used the change in the consumer price index as the inflation
factor in the appropriation limit computations for the years
ended June 30, 1991 and 1992. Proposition 111 requires the City
to use either the change in California per capita income or the
change in non-residential assessed valuation as the inflation
factor. Although non-residential assessed value statistics were
not available from the County, we recomputed the appropriation
limits using the California per capita income factor and
determined, on a cummulative basis, that the limits for the years
ended June 30, 1991 and 1992, as adapted by the City were,
$253,653 and $132,793 below the allowable limits. Based on the
above we recommend: -
CITY OF DUBLIN
MANAGEMENT RECOMMENDATIONS
RECOMMENDATION 3 - THE CITY SHOULD REVISE ITS APPROPRIATION LIMITS TO
COMPLY WITH PROPOSITION 111 REQUIREMENTS (Continued)
1) The City revise its appropriation limit computation method
to include the required inflation factors.
2) The City obtain non-residential assessed valuation
statistics from the County assessors office and consider
using them if they are higher than the change in California
per capita income.
RECOMMENDATION 4 - THE CITY SHOULD TAKE STEPS TO REDUCE THE UNPAID BALANCE OF
PRIVATE DEVELOPER DEPOSIT BILLINGS
During our audit we performed tests of private developer
deposits and noted the following:
approximately $140,000 in billings to private developers
for costs in excess of their deposits remained unpaid as
of June 30, 1991;
of these billings, $28,967 was outstanding for over one
year, even though such items are rebilled each month;
nearly half the billings, or $65,854, was due from five
developers for large projects. This amount included most
of the balances over one year old.
Based on the above we recommend the following actions:
The City should strengthen its efforts to collect the
unpaid balance of private developer deposits.
The City should consider linking the permit approval
process with its collection efforts for past due amounts.
The City should also consider increasing private developer
deposit prepayments to cover the total cost of
improvements. This will eliminate the necessity of
billing after the fact.
RECOMMENDATION 5 - INTERFUND BALANCES SHOULD BE PAID TIMELY
At June 30, 1991 the City's special revenue funds still owed
a total of $311,763 to the general fund; these balances are
now a year old. Interfund payables should be paid timely or
accounted for as transfers.
CITY OF DUBLIN
MANAGEMENT RECOMMENDATIONS
RECOMMENDATION 6 - THE CITY SHOULD MAINTAIN PETTY CASH ACCEPTANCE FORMS FOR
PETTY CASH KEPT BY CUSTODIANS
A petty cash acceptance form should document the employee
responsible for each petty cash fund and should be kept in
the Finance Department. A copy of this form should be kept
in the custodian's personnel file and should be signed by
custodians holding petty cash. This form would also serve
As documentation of changes in the amount or custodianship
of petty cash.
CITY OF DUBLIN
STATUS OF PRIOR YEAR RECOMMENDATIONS
Recommendation Status
Recommendation 1 During our Single Audit Not implemented. See
Act work for the year current year
ended June 30, 1990, we recommendation 2.
noted that a total of
$147,121 in Federal Aid
Urban grant costs were
incurred in July and
December 1989, but that
reimbursement was not
requested for costs
incurred under such grants
as soon as possible after
being incurred; progress
. billings are appropriate.
Recommendation 2 The later the audit report Implemented
is received the less
valuable it is to the
City. The year-end
portion of our audit was
carefully planned and
coordinated with Finance
Department staff during
our interim work in June
and was to be performed in
October, which would have
allowed a November release
date for the audit
report. Unfortunately, we
were forced to discontinue
our work in October
because the books were not
yet ready for audit;
significant accounting
entries relating to the
capitalization of the
Civic Center and the
year's fiscal agent
activity had not been
prepared. All the
information necessary to
complete the audit was not
provided until December.
CITY OF DUBLIN
STATUS OF PRIOR YEAR RECOMMENDATIONS
Recommendation Status
Recommendation 2 We understand the Finance Implemented
(Continued) Department is small and
that unanticipated demands
can disrupt the work
schedule. However, we
believe a higher priority
should be given to closing
the books and preparing
for the audit. If
temporary work-load
demands exceed the Finance
Department's capacity,
consideration should be
given to using temporary
employees or to using us
as consultants to help in
closing the books.
Recommendation 3 The City is required under Implemented
the terms of its
Certificates of
Participation issues to
maintain significant cash
balances with fiscal
agents. Currently, the
transactions and activity
generated by these fiscal
agents are not recorded by
the Finance Department
until year end, even
though monthly statements
are submitted to the
City. Monthly evaluation
and recording of the
fiscal agent accounts
activity would minimize
the chance for error as
well as correctly reflect
the account balances on a
timely basis.
Recommendation 4 Generally accepted Not Implemented
accounting principles do
not allow prior period
adjustments to fund
balance except for those
few material items which
are both unusual and
non-recurring. The City,
on the other hand,
employes a strong
budgetary control system
and including prior year
items in the current year
can degrade this control.
CITY OF DUBLIN
STATUS OF PRIOR YEAR RECOMMENDATIONS
Recommendation Status
Recommendation 4 Over the years the number
of prior year adjustments
has been reduced to a
level well below that of
our other city clients,
but there will always be a
few such unavoidable
adjustments due to events
entirely beyond the City's
control.
In order to isolate these
adjustments and prevent
them from degrading the
budgetary controls, we
recommend a Prior Year
Adjustment account be
established.
All prior year adjustments
would be entered to this
account, which would be
presented as a separate
line item in the City's
financial statements. A
budget amount could even
be established if the City
wished, based on a review
of the nature of past
adjustments. This
approach would be in
accordance with generally
accepted accounting
principles while allowing
the City to maintain its
strong budgetary controls.
We wish to express our appreciation for the courtesy and cooperation extended
to us by Phil Molina and his staff during our audit.
October 18, 1991
AZE &
ASSOCIATES
ACCOUNTANCY CORPORATION
1670 Riviera Avenue- Suite 100
Walnut Creek, California 94596
(510) 930-0902 • (916)972-7333
INDEPENDENT AUDITOR'S REPORT ON FAX(510)930-0135
COM13LIANCE WITH THE PROPOSITION 111
1990-91 APPROPRIATION LIMIT INCREMENT
To the Honorable Mayor and City Council
City of Dublin
We have applied the procedures enumerated below to the accompanying
Appropriations Limit Worksheet (Worksheet) for the City of Dublin for the
year ended June 30, 1991. These procedures, which were suggested by the
League of California Cities and presented in their Article XIIIB
Appropriations Limitation Uniform Guidelines (Guidelines) , were performed
solely to assist you in meeting the requirements of Section 1.5 of Article
XIIIB of the California Constitution. This report is intended for the
information of management and the City Council; however, this restriction
is not intended to limit the distribution of this report, which is a
matter of public record.
At your request, based on the League of California Cities' interpretation
of Article XIIIB of the California Constitution, the scope of our work
excluded any tests or other procedures regarding the accuracy of the
1978-79 or 1986-87 "base year" appropriations limit calculations.
The procedures you requested us to perform and our findings were as
follows:
A. Proposition 111 was implemented with the passage of Resolution 66-91,
A Resolution of the City Council of Dublin Adopting the Appropriations
Limit for the Fiscal Year 1991-92. We obtained the Worksheet, and
were unable to determine that the limit and annual adjustment factors
were adopted by resolution of the City Council. The 1990-91
appropriation limit of $16,699,868, as adjusted for Proposition 111
requirements, was not adopted by City Council resolution as required
by page 27 of the Guidelines. The original 1990-91 appropriation
limit of $16,445,712 as computed under pre-Proposition 111 rules was
adopted by City Council resolution.
B. For the Worksheet, we recomputed the Appropriations Limit by
multiplying the prior year Appropriations Limit by the population
factor, the result of which was multiplied by the change in the
consumer price index. This recomputation was performed for the
1987-88, 1988-89, 1989-90, and 1990-91 fiscal years.
C. For the 1987-88, 1988-89, 1989-90 and 1990-91 fiscal years, we agreed
the City and County Population factors to the California State
Department of Finance Worksheets.
6�k t16
A Professional Corporation
Page 2
As noted in our report for the 1990-91 Appropriations Limit, the City
used the change in the consumer price index as the inflation factor
for computing the 1990-91 Appropriation Limit which was used to
compute the 1991-92 limit of $17,515,840. Proposition 111 requires
alternative inflation factors to be used, and had these been used in
the computation of the City's 1991-92 limit would be $17,648,633.
D. The 1990-91 appropriation limit of $16,699,868, as adjusted for
Proposition 111 requirements, was not adopted by City Council
resolution as required by page 27 of the Guidelines. Proposition 111
was implemented with the passage of Resolution 66-91, A Resolution of
the City Council of Dublin adopting The Appropriations Limit for the
Fiscal Year 1991-92. The original 1990-91 appropriation limit of
$16,445,712 as computed under pre-Proposition 111 rules was adopted by
City Council resolution.
These agreed-upon procedures are substantially less in scope than an
audit, the objective of which is the expression of an opinion on the
Worksheet. Accordingly, we do not express such an opinion.
Based on the application of the procedures referred to above, nothing came
to our attention which caused us to believe that the accompanying
Worksheet was not computed in accordance with Article XIIIB of the
California Constitution, as interpreted in the California League of Cities
Article XIIIB Appropriations Limit Uniform Guidelines. Had we performed
additional procedures or had we made an audit of the Worksheet and the
other completed worksheets described in #A above, matters might have come
to our attention which would have been eported to you.
November 12, 1991
AZE &
ASSOCIATES
ACCOUNTANCY CORPORATION
1670 Riviera Avenue-Suite 100
INDEPENDENT AUDITOR'S REPORT ON Walnut Creek, California 94596
COMPLIANCE WITH THE PROPOSITION 111 (510) 930-0902 • (916)972-7333
1991-92 APPROPRIATION LIIIIT INCREMENT FAX(510)930-0135
To the Mayor and City Council
City of Dublin, California
We have applied the procedures enumerated below to the accompanying
Appropriations Limit Worksheet (Worksheet) prepared by City Management for
the year ended June 30, 1992. These procedures, which were suggested by
the League of California Cities and presented in their Article XIIIB
Appropriations Limitation Uniform Guidelines (Guidelines) , were performed
solely to assist you in meeting the requirements of Section 1.5 of Article
XIIIB of the California Constitution. This report is intended for the
information of management and the City Council; however, this restriction
is not intended to limit the distribution of this report, which is a
matter of public record.
At your request, based on the League of California Cities' interpretation
of Article XIIIB of the California Constitution, the scope of our work
excluded any tests or other procedures regarding the accuracy of the
1978-79 or 1986-87 "base year" appropriations limit calculations.
The procedures you requested us to perform and our findings were as
follows:
A. We obtained the Worksheet, and determined that the limit and annual
adjustment factors were adopted by resolution of the City Council. We
also determined that the population and inflation options were
selected by a recorded vote of the City Council.
B. For the Worksheet, we computed the 1991-92 Appropriations Limit by
multiplying the 1990-91 Year Appropriations Limit by the change in per
capita income, the result of which was multiplied by the County
Population Factor. Our computed limit did not agree with the 1991-92
Appropriations limit.
C. We recomputed the percentage change in City and County population and
we agreed the beginning and ending City and County population
statistics to the California Department of Finance worksheets, except
that the beginning County population included in the computation was
1,264,338. County population as reported on the California State
Department of Finance Worksheets was 1,265,929.
A Professional Corporation
Page 2
The City used the change in the consumer price index as the inflation
factor for computing the 1990-91 Appropriation Limit of $16,446,215.
Proposition 111 requires alternative inflation factors to be used, and
had these been used in the computation of the City's 1991-92 limit
would be $16,699,868.
D. We agreed the 1986-87 appropriations limit of $7,672,746 to a
resolution of the City Council.
These agreed-upon procedures are substantially less in scope than an
audit, the objective of which is the expression of an opinion on the
Worksheet. Accordingly, we do not express such an opinion.
Based on the application of the procedures referred to above, nothing came
to our attention which caused us to believe that the accompanying
Worksheet was not computed in accordance with Article XIIIB of the
California Constitution, as interpreted in the California League of Cities
Article XIIIB Appropriations Limit Uniform Guidelines. Had we performed
additional procedures or had we made an audit of the Worksheet and the
other completed worksheets described in #A above, matters might have come
to our attention which would have been reported to you.
November 11, 1991
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF JUNE 1991
(FINAL)
Prepared by
The Finance Department
z �
BGL102 CITY OF DUBLIN PACE 1
12/19/91 BALANCE SHEET 11.35.50
FOR THE
PERIOD 7/90 THROUGH 6/91
GENERAL SPECIAL SPECIAL CAPIT=.L
REVENUE REVENUE ASSESSMENT IMPROVEMENT
FUNDS FUNDS FUNDS FUNDS
ASSETS
CASH 1770294.66- 273788.21 1160275.24 61789.40
CASH WITH FISCAL AGENT
UNs.MORTIZED BOND DISCOUNT 1562.50
INVESTMENTS AT COST 16905000.00
RECEIVABLES:TAXES 230898.13
ACCOUNTS (NET) 89360.01 497800.15
INTEREST 199249.44
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS 1363311.44
INVENTORY AT COST
PREPAID ITEMS 7058.31
FIXED ASSETS
AMOUNTS TO BE PROVIDED
TOTAL ASSETS 17026145.17 771588.36 1160275.24 61789.40
LIAB, FND BAL•, RETHD EARNINGS
DEPOSITS FOR PRIVATE DEVELPM11T 223765.05-
DEPOSITS FOR AB1600 FEES 133094.40-
DEPOSITS OTHERS 150025.26- 3125.00-
PAYABLES:A000UNTS 1297030.46- 115568.47- 26096.58- 925.00-
INTEREST
PAYROLL 67630.28-
DUE TO OTHERS 1039.09 1338705.97- 1500.00- 23105.47-
DEBT INSTRL41ENTS PAYABLE 550000.00-
TOTAL LIABILTIES 1737361.96- 1454274.44- 5 80721.58- 157124.87-
FLZiD BAL110ES 15288783.21- 682686.08 579553.66- 95335.47
TOTAL FUND EQUITY 15283783.21- 632686.08 579553.66- 95335.47
TOTAL LI3,FND B=L, RETD EARNS 17026145.17- 771588.36- 1160275.24- 61789.40-
BGL102 CITY OF DUBLIN PAGE 1
12/19/91 BALANCE SHEET 11.36.49
FOR THE
PERIOD 7/90 THROUGH 6/91
INTERNAL ENTERPRISE FIXED ASSETS
SERVICE FUNDS GROUP OF
FUND ACCOUNTS
ASSETS
CASH 268225.17
CASH WITH FISCAL AGENT 1718575.90
UNAMORTIZED BOND DISCOUNT
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS (NET) 768.68
INTEREST 64500.15
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 8616.00 1724.03
FIXED ASSETS 182941.50 21892690.65 444274.67
A140U11TS TO BE PROVIDED
TOTAL ASSETS 460551.35 23677490.73 444274.67
LIAB, FND BAL, RETHD EARNINGS
DEPOSITS FOR PRIVATE DEVELPMNT
DEPOSITS OTHERS
PAYABLES:A000@1TS 457.68- 3462.10-
INTEREST
PAYROLL
DUE TO OTHERS
DEBT INSTRUMENTS PAYABLE 16983728.08-
TOTAL LIABILITIES 457.68- 16937190.18-
FUND BALANCE 352815.41- 1595054.55-
CONTRIBUTIONS 115998.18- 5103123.00-
INVESTMENTS IN FIXED ASSETS 444274.67-
RETAINED EARNINGS
TOTAL FUND EQUITY 460093.67- 6690300.55- 444274.67-
TOTAL LIAB,FND BAL, RETD EARNS 460551.35- 23677490.73- 444274.67-
BGL104 n CITY OF DUBLIN STATEMENT SHOWING PAGE 1
12/19/91
REVENUES VERSUS EXPENDITURE 15.05.36
FOR THE
PERIOD 7/90 THROUGH 6/91
GENERAL REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
PROPERTY TAXES 3704500.00- 3790610.96- 102.3 86110.96
SALES TAX 5700000.00- 5839088.73- 102.4 139088.73
REAL PROPERTY TRANSFERS 76000.00- 67577.31- 88.9 8422.69-
TRANSIENT OCCUPANCY TAX 106000.00- 99646.00- 94.0 6354.00-
FRANCHISE TAXES 389900.00- 407128.53- 104.4 17228.53
LICENSES & PERMITS 408100.00- 248116.11- 60.8 159983.89-
FINES & FORFEITURES 20000.00- 19476.34- 97.4 523.66-
USES OF HONEY AND PROPERTY 1211870.00- 1338946.79- 110.5 127076.79
INTERNGOVERNMENTAL FROM STATE 1027260.00- 973266.41- 94.7 53993.59-
CHARGES FOR SERVICES 1164816.00- 1196483.66- 102.7 31667.66
OTHER SOURCES OF REVENUE 97500.00- 74938.63- 76.9 22561.37-
TOTAL REVENUE 13905946.00- 14055279.47- 101.1 149333.47
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 736505.00 668244.37 90.7 68260.63
CITY COUNCIL 1010 121778.00 108997.89 89.5 12780.11
CITY MANAGER 1020 431768.00 409149.99 94.8 22618.01
CITY ATTORNEY 1030 167455.00 167454.71 100.0 .29
FINANCE DEPARTMENT 1040 218061.00 210719.07 96.6 7341.93
BUILDING MANAGEMENT 1050 320610.00 306014.90 95.4 14595.10
FACILITY RENTAL 1050-719 1719820.00 1579472.05 91.8 140347.95
INSURANCE COST CENTER 1060 177500.00 136457.70 76.9 41042.30
ELECTIONS COST CENTER 1070 3825.00 3066.03 80.2 758.97
ACTIVITY TOTAL 3897322.00 3589576.71 92.1 307745.29
PUBLIC SAFETY:
POLICE 2010 2581151.00 2497477.09 96.8 83673.91
CROSSING GUARDS COST 2020 8000.00 2963.50 37.0 5036.50
ANIMAL CONTROL 2030 54330.00 49398.89 90.9 4931.11
TRAFFIC SIGNALS 2040 .00 5831.09 5831.09-
DISASTER PREA.PREDNESS 2050 30735.00 11989.90 39.0 18745.10
FIRE SERVICES JPA 2060 2295338.00 2233302.07 97.3 62035.93
ACTIVITY TOTAL 4969554.00 4800962.54 96.6 168591.46
TRANSPORTATION:
PUBLIC WORKS 3010. 260494.00 252853.70 97.1 7640.30
STREET MAINTENANCE 3020 289165.00 289164.48 100.0 .52
STREET SWEEPING 3030 62000.00 59778.00 96.4 2222.00
STREET TREE MAINTENANCE 3040 67000.00 57995.95 86.6 9004.05
STREET LANDSCAPE MAINT. 3050 182500.00 176255.02 96.6 6244.98
PARATRANSIT SERVICES 3060 1500.00 1500.00 100.0 .00
ACTIVITY TOTAL 862659.00 837547.15 97.1 25111.85
HEALTH & WELFARE:
VECTOR CONTROL 5010 27010.00 26277.00 97.3 733.00
ACTIVITY TOTAL 27010.00 26277.00 97.3 733.00
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES 8010 149650.00 149650.00 100.0 .00
CULTURAL ACTIVITIES 8011 32785.00 .00 32785.00 -
PIZ MAINTENANCE 8020 518570.00 478382.30 92.3 40187.70
GL104 iuL CITY OF DUBLIN STATEMENT SHOWING PAGE 2
REVENUES VERSUS EXPENDITURE 15.05.36
12/19/91 FOR THE
PERIOD 7/90 THROUGH 6/91
GENER'-Z REVENUE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
COMMUNITY CABLE TV 8030 46000.00 46000.00 100.0 .00
RECREATION ADMIN. 8040 154760.00 146544.57 94.7 8215.43
PLAYGROUNDS 8045 67030.00 68140.74 101.7 1110.74-
SHANNON CENTER 8050 94861.00 98492.49 103.8 3631.49-
PRESCHOOL 8055 28877.00 28612.22 99.1 264.78
TEENS PROGRAM 8060 44881.00 25637.78 57.1 19243.22
FIELD SCHEDULING 8065 124931.00 91457.07 73.2 33473.93
SPECIAL EVENTS 8070 25140.00 22490.15 89.5 2649.85
SENIOR CENTER 8080 96401.00 85957.32 89.2 10443.68
RECREATION INSTRUCTION 8090 62090.00 53025.49 85.4 9064.51
AQUATICS 8100 152051.00 165029.17 108.5 12978.17-
ACTIVITY TOTAL 1598027.00 1459419.30 91.3 138607.70
COMMUNITY DEVELOPMENT:
PLANNING 9010 1261937.00 1051889.73 83.4 210047.27
BUILDING SAFETY 9020 365584.00 352438.88 96.4 13145.12
ENGINEERING 9030 429992.00 411754.79 95.8 18237.21
ECONOMIC DEVELOPMENT 9040 83606.00 11270.67 13.5 72335.33
ACTIVITY TOTAL 2141119.00 1827354.07 85.3 313764.93
CAPITAL IMPROVE14ENT PROJECTS:
GENERAL CIP PROJECTS 931UI 160815.00 8365.87 5.2 152449.13
COMMUNITY IMPROVEMENTS 94NN 125681.00 120064.59 95.5 5616.41
PAS 95NN 776997.00 632433.69 81.4 144563.31
STREET CONSTRC/IMPROVMT 96NN 177532.00 87575.85 49.3 89956.15
ACTIVITY TOTAL 1241025.00 848440.00 68.4 392585.00
T O T A L EXPENDITURES 14736716.00 13389576.77 90.9 1347139.23
EXCESS <REVENUE>EXPENDITURES 830770.00 665702.70- 80.1- 1496472.70
TRANSFERS IN FROM OTHER FUNDS .00 .00 .00
TRANSFERS OUT TO OTHER FUNDS .00 4173.56 4173.56-
EXCESS <REVENUE> EXPENDITURE 830770.00 661529.14- 79.6- 1492299.14
BGL104 ITY OF DUBLIN STATEMENT SHOWING PAGE 1
12/19/91 REVENUES VERSUS EXPENDITURE 11.18.03
FOR THE
PERIOD 7/90 THROUGH 6/91
SPECIAL REVENUE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVEIUES*******
SALES TAX 109000.00- 108156.42- 99.2 843.58-
FINES & FORFEITURES 80000.00- 62891.45- 78.6 17108.55-
USES OF MONEY MID PROPERTY 41950.00- 19343.00- 46.1 22607.00-
INTERNGOVERiMENTAL FROM STATE 1091941.00- 867740.93- 79.5 224200,07-
INTERGOVERNMENTAL FROM FEDERAL 1373880.00- 723545.95- 52.7 650334.05-
OTHER SOURCES OF REVENUE 780000.00- 13109.03- 1.7 766890.97-
TOTAL REVENUE 3476771.00- 1794786.78- 51.6 1681984.22-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 5492.00 3904.25 71.1 1587.75
ACTIVITY TOTAL 5492.00 3904.25 71.1 1587.75
PUBLIC SAFETY:
POLICE 20150.00 12606.47 62.6 7543.53
CROSSING GUARDS COST 24125.00 24125.00 100.0 .00
TRAFFIC SIGNALS 78000.00 78000.00 100.0 .00
ACTIVITY TOTAL 122275.00 114731.47 93.8 7543.53
TRANSPORTATION:
STREET MAINTENA.NCE 82141.00 82141.49 100.0 .49-
ACTIVITY TOTAL 82141.00 82141.49 100.0 .49-
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 5000.00 5000.00 100.0 .00
ACTIVITY TOTAL 5000.00 5000.00 100.0 .00
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 44454.00 44379.33 99.8 74.67
PARKS 674438.00 662579.08 98.2 11858.92
STREET CONSTRUCTION/IMPROVMT 1756075.00 1715263.70 97.7 40811.30
ACTIVITY TOTAL 2474967.00 2422222.11 97.9 52744.89
T 0 T A. L EXPENDITURES 2689875.00 2627999.32 97.7 61875.68
EXCESS <REVENUE>EXPENDITURE 786896.00- 833212.54 105.9- 1620108.54-
TRA.NSFERS OUT TO OTHER FUNDS .00 .00 .00
EXCESS <REVEi1UE> EXPENDITURE • 786896.00- 833212.54 105.9- 1620108.54•
BGL104 .ITY OF DUBLIN STATEMENT SHOWING PAGE 1
12/19/91 REVENUES VERSUS EXPENDITURE 11.21.19
FOR THE
PERIOD 7/90 THROUGH 6/91
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 370535.00- 551012.59- 148.7 180477.59
USES OF MONEY AND PROPERTY 55600.00- 66686.00- 119.9 11086.00
OTHER SOURCES OF REVENUE 5000.00- 3968.88- 79.4 1031.12-
TOTAL REVENUE 431135.00- 621667.47- 144.2 190532.47
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 108419.00 53418.75 49.3 55000.25
ACTIVITY TOTAL 108419.00 53418.75 49.3 55000.25
PUBLIC SAFETY:
TRFC SIGS/STREET LIGHTING 160650.00 153059.35 95.3 7590.65
ACTIVITY TOTAL 160650.00 153059.35 95.3 7590.65
TRANSPORTATION:
STREET TREE MAINTENANCE 13500.00 4256.22 31.5 9243.78
STREET LANDSCAPE MAINTENANCE 112990.00 104061.49 92.1 8928.51
ACTIVITY TOTAL 126490.00 108317.71 85.6 18172.29
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 12000.00 10071.82 83.9 1928.18
ACTIVITY TOTAL 12000.00 10071.82 83.9 1928.18
CAPITAL IMPROVEMENT PROJECTS:
STREET CONSTRUCTION/IMPROVMT .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
T O T A L EXPENDITURES 407559.00 324867.63 79.7 82691.37
EXCESS<REVENUE>EXPENDITURE 23576.00- 296799.84- 1258.9 273223.84
TRANSFERS IN FROM OTHER FUNDS .00 2502.65- 2502.65
EXCESS <REVENUE> EXPENDITURE 23576.00- 299302.49- 1269.5 275726.49
BGL104 CITY OF DUBLIN STATEMENT SHOWING PAGE 1
12/19/91 REVENUES VERSUS EXPENDITURE 11.32.11
FOR THE
PERIOD 7/90 THROUGH 6/91
CAPITAL IMPROVEMENT FUND
CURRENT PERIOD
BUDGET ACTUa.L PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 2000.00- 11875.00- 593.8 9875.00
OTHER SOURCES OF REVENUE 418565.00- 76090.17- 18.2 342474.83-
TOTAL REVENUE 420565.00- 87965.17- 20.9 332599.83-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOP14EIIT:
ENGINEERING .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 9000.00 9000.00 100.0 .0(
PARKS 177936.00 60237.31 33.9 117698.6
STREET CONSTRUCTION/IMPROVMT 231629.00 60725.46 26.2 170903.5?
ACTIVITY TOTAL 418565.00 129962.77 31.0 288602.2:
T 0 T A L EXPENDITURES 418565.00 129962.77 31.0 288602.2:
EXCESS<REVENUE>EXPENDITURE 2000.00- 41997.60 2099.9- 43997.61
TRANSFERS OUT TO OTHER FUNDS .00 2502.65 2502.6
EXCESS <REVENUE> EXPENDITURE 2000.00- 44500.25 2225.0- 46500.2
BGL104 _ CITY OF DUBLIN STATEMENT SHOWING PAGE 1
12/19/91 REVENUES VERSUS EXPENDITURE 11.28.32
FOR THE
PERIOD 7/90 THROUGH 6/91
ENTERPRISE FUNDS
CURRENT PERIOD
BUDGET ACTUAL PERCENT V.ARIA.NCE
********REVENUES*******
USES OF MONEY AND PROPERTY 1841487.00- 1740720.20- 94.5 100766.80-
TOTAL REVENUE 1841487.00- 1740720.20- 94.5 100766.80-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 1720120.00 1743383.98 101.4 23263.98-
CITY MANAGER 19810.00 14946.69 75.5 4863.31
FINANCE DEPARTMENT 13000.00 8374.71 64.4 4625.29
ACTIVITY TOTAL 1752930.00 1766705.38 100.8 13775.38-
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION 9165.00 10980.38 119.8 1815.38-
ACTIVITY TOTAL 9165.00 10980.38 119.8 1815.38-
COMMUNITY DEVELOPMENT:
ENGINEERING .00 .00 .00
ACTIVITY TOTAL .00 .00 .00
CAPITAL IMPROVEMENT PROJECTS:
CIVIC CENTER COSTS 7877.00 7877.00 100.0 .00
ACTIVITY TOTAL 7877.00 7877.00 100.0 .00
T 0 T A L EXPENDITURES 1769972.00 1785562.76 100.9 15590.76-
BXCESS<REVENUE>EXPENDITURES 71515.00- 44842.56 62.7- 116357.56-
TRANSFERS IN FROM OTHER FUNDS .00 4173.56- 4173.56
EXCESS <REVENUE> EXPENDITURE 71515.00- 40669.00 56.9- 112184.00-
BGL104 CITY OF DUBLIN STATEMENT SHOWING PAGE 1
12/19/91 REVENUES VERSUS EXPENDITURE 11.24.52
FOR THE
PERIOD 7%90 THROUGH 6/91
INTERNAI: SERVICE FUND
CURRENT PERIOD
BUDGET ACTUAL PERCENT VARIANCE
********REVENUES*******
USES OF MONEY AND PROPERTY 21000.00- 17073.00- 81.3 3927.00-
CHARGES FOR SERVICES 141576.00- 132516.40- 93.6 9059.60-
OTHER SOURCES OF REVENUE .00 2260.00- 2260.00
TOTAL REVENUE 162576.00- 151849.40- 93.4 10726.60-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 149800.00 143028.73 95.5 6771.27
ACTIVITY TOTAL 149800.00 143028.73 95.5 6771.27
PUBLIC SAFETY:
POLICE 74055.00 335.54 .5 73719.46
ACTIVITY TOTAL 74055.00 335.54 .5 73719.46
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & L•EISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 8720.00 8719.92 100.0 .08
ACTIVITY TOTAL 8720.00 8719.92 100.0 .08
T O T A L EXPENDITURES 232575.00 152084.19 65.4 80490.81
EXCESS<REVENUE>EXPENDITURE 69999.00 234.79 .3 69764.21
EXCESS <REVENUE> EXPENDITURE 69999.00 234.79 .3 69764.21