HomeMy WebLinkAboutItem 8.2 FY2002-3 MidYr$Rpt CITY CLERK
File # 330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: February 4, 2003
SUBJECT: Fiscal Year 2002-03 Mid-Year Budget Report and
December 2002 Monthly Report of Financial Activities
Report Prepared by: Carole A. Perry, Administrative Services Director
and Fred Marsh, Finance Manager
ATTACHMENTS: 1. YTD Revenues and Budget Comparison
2. YTD Expenses and Budget Comparison
3. Financial Statement~ for the Month of
December 2002
4. Budget Change Forms
RECOMMENDATION: /.I~N' 1. Receive the Reports
2. Approve Budget Changes
FINANCIAL STATEMENT: See Below
DESCRIPTION: Attached is the monthly report of financial activities for December 2002. This report
combines the monthly financial analysis with a more detailed "Mid-Year Review." It is important to note
that some of the data is limited due to a lag in the time when bills for contract services are received.
Therefore, Staff has approached all projections in a conservative manner.
STATUS OF FINAL REPORT FOR FISCAL YEAR 2001-2002
Staff will be scheduling the Audit committee to review the City's Comprehensive Annual Financial Report,
for Fiscal Year 2001-02, which will be in compliance with GASB 34, during the month of February. Staff
also anticipates bringing the report to Council during the second Council meeting in February. It should be
noted that the following amounts will be added to reserves for the following projects for Fiscal Year 2001-
02, as previously discussed by the City Manager as part of his transmittal letter in the preliminary budget for
Fiscal year 2002-03.
FISCAL ~AR 2001-2002
Project Amount Added to Reserves
Open Space / Downtown $626,360
Affordable Housing $626,3,60
Energy Projects $715,781
Capital Project Carryovers $2,032,767
G:LMid Year ReportsXFY 2002-03\midyear report.DOC COPIES TO: ~ ~
ITEM NO.
2002-03 ADOPTED BUDGET - GENERAL FUND REVENUES / EXPENDITURES
The Fiscal Year 2002-03 Budget adopted by the City Council in June 2002 anticipated that General Fund
Revenues, combined with reserves for Capital Projects and Net Fund Transfers In/Out, would exceed
General Fund Expenditures by $1,030,112. If the surplus was realized at the end of Fiscal Year 2002-03, the
City Council directed the surplus funds be reserved as follows:
Amount of
Name of Project Reserves
Open Space / Downtown $ 373,640
Affordable Housing $ 373,640
Economic Uncertainty $ 282,832
$1,030,112
Since the adoption of the Budget, the City Council has approved additional Budget Changes or Transfers,
which have occurred through the Council Meeting of January 21, 2003, as listed below:
ADDITIONAL APPROPRIATIONS APPROVED SUBSEQUENT TO BUDGET ADOPTION
Amount of
Amount of Additional
Additional Related Revenues
Item Appropriations
Village Parkway U Turn Project $6,230
Work for DSRSD on Dublin Blvd Widening Project $4,790
Murray School Bell Tower $15,570
Dublin Sports Grounds Renovation $158,291
IKEA Traffic Study $50,000 $62,500
Library Furniture Bid $9,929
Tri Valley Jobs Website $10,829
Signal Battery Backup $0 $22,400
Additional CIP Carryovers from Fiscal Year 2001-02 $47,971
Open Space West Dublin $10,000
Totals $313,610 $84,900
REVENUE ESTIMATES UPDATE
Staff has analyzed the original Revenue Estimates contained in the Fiscal Year 2002-03 Adopted Budget.
The following breakdown will address anticipated changes within major categories, as well as proposed
adjustments to 'be made to the Budget Estimates in the City's Financial Records.
Property Taxes
(Category represents approximately 27% of budgeted General Fund Revenues)
The County Auditor Controller has issued a statement to the City containing the amount of
assessments placed on the Property Tax Roll for Fiscal Year 2002-03. Based upon this information it
appears that the projected property tax revenues will fall below the budget originally approved by
Council due to delays by the County in adding some new development to the tax roll.
The estimated budget is net of revenue transfers mandated by the State of California. This includes
the permanent Property Tax Shift to the Education Revenue Augmentation Fund (estimated at $1.1
million in Fiscal Year 2002-03) and Property Tax Administrative Charges (estimated at $103,000 in
Fiscal Year 2002-03). Council will recall the State instituted these programs to solve State budget
issues. If these programs did not exist the City Government would have. these additional funds
available to finance local programs.
Revised Estimate: Decrease $111,000
Sales Taxes
(Category represents approximately 35% of budgeted General Fund Revenues)
Currently, sales tax collected to date is ahead of the budgeted projection for the year. However, the
retail sales tax data recorded to date only includes sales occurring prior to October 1, 2002 (i.e. first
quarter of Fiscal Year 2002-03) and the advances of sales taxes by the State for the period of October
2001 through December 2002. It does not include the retail holiday season reporting, which typically
represents a larger percentage of sales tax revenue. Preliminary projections would indicate that sales
tax may be above the budgeted revenue estimate by approximately $241,000 to date, largely due to an
increase in auto sales. However, this projection will be impacted by holiday shopping receipts
and any changes that occur with the overall economy during the next six months.
Revised Estimate: Increase $241,000
Taxes Other than Property and Sales
(Category represents approximately 8% of budgeted General Fund Revenues)
When comparing tax revenues for the first six months of this fiscal year to the same period in the
prior year, it is projected that the revenues will be below the budget estimate. The combined
adjustments are expected to result in a decrease of $126,000.
The valuation from the sales of new and existing residential properties in the City has dropped in
comparison to the prior year, and as a result the City expects to collect $16,000 less than originally
anticipated in property transfer taxes.
Due to the slowdown in the economy, the national events that occurred in Fiscal Year 2001-02 and
the continuing economic disruption for this Fiscal Year as well, the year to date Transient Occupancy
Taxes (TOT) collected from the City's four hotels is below the amount collected through the same
period in the prior year, and thus the City expects to collect approximately $90,000 less than
originally expected for TOT.
Franchise Fees for the first six months are below estimates and are projected to be approximately
$20,000 under budget by year end, due to the success achieved from the City's new commercial
recycling programs, which have reduced the amount of garbage collected in the City, thereby
reducing the Franchise Taxes received from the City's contract waste management provider.
Revised Estimate: Decrease $126,000
Licenses & Permits
(Category represents approximately 4% of budgeted General Fund Revenues)
Revenues in this category are often difficult to predict since Building Permits account for the majority
of this revenue. At this time the overall Building Permit revenue is projected to be ahead of budget at
year end by approximately $448,000, resulting from a higher than expected number of permits pulled
for new residential construction. The final year end amounts will be dependent on the timing of
permit issuance for projects targeting the summer construction window. Although these revenues
will be recorded during Fiscal Year 2002-03, the expenses associated with the actual building
inspections may occur in Fiscal Year 2003-04.
Revised Estimate: Increase $ 448,000
Interest & Rentals
(Category represents approximately 4% of budgeted General Fund Revenues)
Interest Revenue represents 91% of the total budgeted revenue in this category. The remainder
consists of rental income collected for the use of City facilities.
Although it is too early to calculate the exact General Fund share of total interest revenue, it appears
that the revenues in this category will be ahead of the budget estimate. The City's interest yield to
date has been lower than was originally assumed in the budget estimate. However, this has been
offset by the fact that the General Fund has had a larger cash balance than was assumed in the budget
estimate, that was available for investment through December 2002. This was due, in part, to
deferrals that have occurred on some capital projects that are funded with General Fund monies and
late billings by the City's major contract service providers. The final earnings will be affected by the
recent decline in interest rates and change in market value on the City's investments.
It currently appears that the revenue to be received from the rental of City facilities will meet the
original budgeted forecast.
Revised Estimate: Increase $122,000
Intergovernmental Revenues
(Category represents approximately 5% of budgeted General Fund Revenues)
Based upon revenues for the first six months, as compared to the same period in the prior year, it
appears that that projected revenues from Vehicle License Fees will exceed the revenue estimate
contained in the Fiscal Year 2002-03 budget by approximately $8,000. The higher projections are
reflective of the growth in new car sales statewide that occurred in the prior year, which increases the
Motor Vehicle in Lieu fees collected by the Department of Motor Vehicles. Council is aware that this
revenue source is extremely vulnerable.
It should be noted that this estimate DOES NOT reflect a proposal by the Governor to
eliminate the funding of the "backfill" of deductions made by the State for the amount assessed
for motor vehicle fees for the period from January 2003 through June 2003, as well as the
funding of the backfill for future fiscal years. Should this proposal pass the State legislature, it
is estimated that the City would lose $678,000 for Fiscal Year 2002-03 and $1.4 million in Fiscal
Year 2003-04.
Revised Estimate: Increase $ 8,000
Charges for Services
(Category represents approximately 13% of budgeted General Fund Revenues)
Based upon Charges for Services for the first seven months, it appears that the original Revenue
Estimate for this category for Fiscal Year 2002-03 will be less than budgeted. Planning, Zoning and
Subdivision Fees, as well as Engineering Plan Check fees, are expected to be below budget by a total
of $386,000 based on delays in the processing of new development in eastern Dublin (resulting from
the slowdown in the local economy, primarily in the commercial and office sectors).
Due to the increase in residential construction noted above (re: that the overall Building Permit
revenue is projected to be higher than budgeted, due to an increase in the number of permits issued
for new residential construction), fire plan check fees are anticipated to be approximately $76,000
more than budget. Fire Service Fees are anticipated to exceed budget by approximately $11,000 due
to increased reimbursements to be received from Alameda County.
Other miscellaneous revenues anticipated to under realize this fiscal year are the Special Events
Revenues - expected to be approximately $14,000 under budget; Booking Fee Revenues - projected
to be about $14,000 under budget; and Waste Management Fees - currently estimated to be $15,000
under budget.
Revised Estimate: Decrease $ 342,000
Fines & Forfeitures
(Category represents less than 1% of budgeted General Fund Revenues)
Parking Fines revenues for the first seven months are under-realizing and are projected to be
approximately $15,000 below budget by year end, due to lower than expected collections from
parking citations.
Revised Estimate: Decrease $15,000
Other Revenues
(Category represents approximately 2% of budgeted General Fund Revenues)
Based upon revenues for the first six months, as compared to the same period in the prior year, it
appears that that projected revenues in this category will be below the revenue estimate contained in
the Fiscal Year 2002-03 Budget by $383,000. This variance is due to delays in the reimbursement of
funds for the Dublin Boulevard Undergrounding project that were included as part of the budget for
this category. However, this was partially offset by reimbursements received from the City of
Pleasanton for design costs for the Fallon Road Interchange. All of the other revenues within this
category are projected to meet their original budget forecasts.
Revised Estimate: Decrease $ 383,000
In summary, Staff's preliminary revised revenue estimate for the General Fund for Fiscal Year 2002-03 is
approximately $158,000, which is LESS than 1% of the total revised budgeted amount for revenues in the
General Fund.
~, : 1:<:9
REVISIONS TO EXPENDITURE ESTIMATES
Staff has reviewed expenditures through December 2002 for all accounts that affect the City's General Fund.
Given the lag in billing for some of the contract services, the City does not have a full six months of
expenses to review for each budget activity. The following discussion highlights those areas where the need
for an increase in the budget appropriation appears likely at this time. The analysis assumes that all other
expenditures will be in accordance with the adopted budget.
General Government
(Represents approximately 11% of the budgeted General Fund Expenditures)
The Legal Services'Activity is projected to exceed budget by approximately $27,000. The main
reason for the higher costs is due to litigation that has occurred during Fiscal Year 2002-2003 that
was not anticipated as part of the adopted budget. This has been offset somewhat by lower than
anticipated time spent on legal services for new development. Since the City is reimbursed from
developers for the cost of these services, this has also resulted in lower than expected revenues
collected for development related services.
Revised Budget Estimate: Net Increase $27,000
Culture and Leisure
(Represents approximately 11% of the Budgeted General Fund Expenditures)
The Community Cable TV budget will exceed its budget by approximately $13,000 due to: a.) an
assumption for an earlier completion date (with a resulting reduction in production costs) for the
City's new cablecast system; and, b.) additional charges for City Council meeting coverage (beyond
four hours).
Revised Budget Estimate: Net Increase $13,000
Community Development
(Represents approximately 14% of the Budgeted General Fund Expenditures)
Community Development expenditures are projected to be approximately $206,000 below budget in
total. The Planning and Engineering divisions have had lower than expected use of development
related contract services due to delays in development projects. This will result in budget savings of
approximately $167,000. In addition, the new City Engineer position (previously classified as a
Senior Engineer) will be vacant for a significant portion of the Fiscal Year, resulting in savings of
approximately $79,000.
These budget savings are partially offset by $40,000 of additional contract building services in the
Building Division, due to the increase in number of permits pulled for new residential construction
noted above. Note that this expenditure savings is offset by an increased amount of building permit
revenue, as discussed in the Licenses and Permits section above.
Revised Budget Estimate: Net Decrease $206,000
Capital Projects
(Represents approximately 28% of the budgeted General Fund Expenditures)
The City is projecting to have lower than anticipated costs on the General Fund portion of several of
its capital projects for Fiscal Year 2002-03, which are noted on the following page:
Amount of Projected
Name of Capital Project Budget Savings
Dublin Sports Grounds Renovation $55,000
Geographic Information Systems $70,000
Civic Center HVAC Renovation $200,000
Traffic Signal Battery Backup $25,000
Sidewalk Safety Repair $10,000
Fuel Tank Upgrade $10,000
Sidewalk Reconstruction - Amador
Valley Blvd and Dublin Blvd $30,000
Total Projected Savings $400,000
Revised Budget Estimate: Decrease $400,000
In summary, Staff's preliminary revised expenditure estimate for the General Fund for Fiscal Year 2002-03 is
approximately $566,000 (1%) LESS than the total amount budgeted as revised for expenditures in the
General Fund.
USE OF SET ASIDE RESERVES FOR ONE TIME CAPITAL PROJECTS
The Adopted Budget anticipated the use of set aside reserves for the following capital projects:
a. Senior Center $ 666,680
b. Library $4,041,229
c. Energy Projects $ 715,781
d. Capital Project Carryovers $2,032,767
All of the Library Set Aside Reserves were actually used during Fiscal Year 2001-02 to fund the early
construction costs of this project. Therefore, as a result: a.) most of the remaining portion of the costs for
Fiscal Year 2002-03 will be funded by the Public Facilities Fund; and, b.) the amount budgeted in the
General Fund for Fiscal Year 2002-03 will be reduced by the General Fund Library reserves used in Fiscal
Year 2001-02.
In addition, a loan of $1.8 million from the General Fund was authorized to pay for construction of Fire
Station 17 for Fiscal Year 2002-03. Staff anticipates that due to lower than anticipated costs for construction
of Station 17, only $1.2 million will be required as the loan amount in Fiscal Year 2002-03.
MID YEAR 2002-2003 SUMMARY OF
GENERAL FUND REVENUE AND EXPENDITURE IMPACT ON RESERVES
Revenue
2002-03 General Fund Revenue Estimate in Adopted Budget $ 36,040,753
Approved Revenues Subsequent to Budget Adoption 84,900
Appropriation from Reserves for Capital Projects (excluding library) 3,415,228
Projected Loan to Fire Impact Fee Fund for Fire Station (1,200,000)
Preliminary Estimated Reduction in Revenues (158,000)
Operating Transfers In 22,350
Total Revised Forecast of General Fund Revenues $ 38,205,231
Appropriations:
2002-03 General Fund Appropriations in Adopted Budget $ 40,672,010
Approved Appropriations Subsequent to Budget Adoption 313,610
Reduction in General Fund Library Appropriations (used in FY 2001-02) (4,041,229)
Preliminary Estimated Reductions in General Fund Expenditures (566,000)
Other Operating Transfers Out -
Total Revised General Fund Appropriations $ 36,378,391
Revenues in Excess of Appropriations (w/o State Budget Cuts) $1,826,840
Governor's Proposed VLF Reduction for Fiscal Year 2002-2003 (678,000)
Estimated Revenues in Excess of Appropriations 1,148,840
FISCAL YEAR 2002-2003 CONCLUSION
At this point in the Fiscal Year it is anticipated that the year end surplus will exceed the $1.03 million
projected in the adopted budget. If the Governor's proposal is adopted by the legislature, the City still should
be able to appropriate as much to the Affordable Housing and Open Space Reserves as approved by the City
Council at the time the 2002-03 budget was adopted.
PROPOSED BUDGET CHANGES
Staff has prepared proposed budget changes to account only for events that are likely to occur during Fiscal
Year 2002-03, as summarized beloW:
a. An increase in Legal Services Litigation Expenditures of $27,000, to reflect additional work
performed to date by the Legal Division on litigation.
b. An increase in the Community Cable TV budget of $13,000, to reflect higher than anticipated
production costs in the broadcast of City Council meetings.
c. An increase in the Building and Safety budget of $40,000 to fund additional contract building
services in the Building Division due to the increase in number of permits pulled for new residential
construction.
d. A transfer of approximately $4 million of budgeted expenditures from the General Fund to the Public
Facility fund to reflect the use of General Fund library reserves for expenditures incurred in Fiscal
Year 2001-02.
PREVIEW FOR FISCAL YEAR 2003-2004
Normally, a preview of the potential budget impacts for the upcoming fiscal year are presented to the City
Council at its budget study session in March. Given the precarious State budget, Staff has provided a
glimpse of what the City may face in Fiscal Year 2003-2004. It is important to recognize that this
information is based upon very preliminary budget data.
Fire Station 17 & 18
It is anticipated that the City will open Fire Station #18 in July 2003, and Fire Station #17 in Fall 2003. The
City will have additional annual personnel expense of more than $1 million per year for Fire Station #18, as
compared to Fiscal Year 2003-2003. The City will also have additional operational and maintenance costs
for both stations.
New Library_
The new library will open in Spring 2003. This will result in additional costs to the City for library hours
funded by the City and additional building operation and maintenance costs. These costs have yet to be
determined.
Salary and Benefit Increases
At this time, Staff anticipates that negotiated increases for salary and benefit cost associated with the City's
major service providers (Police and Fire) and City Staff, and the full year funding of City positions which
were partially filled in Fiscal Year 2002-03 will result in additional costs to the City of approximately $1.75
million in Fiscal Year 2003-2004.
General Fund Capital Proiect Carryover
It is anticipated at this time that approximately $630,000 will need to be carried over the Fiscal Year 2003-
2004 for projects started, but not completed, in Fiscal Year 2002-2003.
State Budget Impacts
At this time, the Governor has proposed a reduction in Fiscal Year 2003-2004 in Vehicle License Fee (VLF)
payments to the City, which would amount to approximately $1.4 million and the elimination of booking fee
reimbursements of approximately $61,000.
Both of these revenues directly impact the City's General Fund. In addition, the Governor is proposing to
suspend the Prop. 42 allocations to cities for road maintenance in Fiscal Year 2003-2004. The City of Dublin
would lose approximately $84,000. This would result in either reduction in the City's annual street
maintenance (overlay) program or other funds (i.e., General Fund or Gas Tax) would need to be used to
maintain the level of service.
Preliminary Forecast
In the City's adopted Five-Year Capital Improvement Program (CIP), Staff projected that approximately $2.5
million would be needed from the General Fund to finance projects scheduled for Fiscal Year 2003-2004.
If the impacts identified materialize and the economy does not materially change, Staff projects that there
will be insufficient revenues to finance all the capital projects proposed for Fiscal Year 2003-2004 in the
CIP. If this projection materializes, the City will either need to defer projects or utilize reserves.
Recommendation
Staff recommends that the City Council (1) Receive the Report and (2) Approve the Budget Change Forms.
For the Period Ending December 31, 2002
Total General Fund Revenues
Property Taxes
Sales Taxes " ..... · FY 2002/2003
Real Property Transfer Tax [] FY 2001/2002
Transient Occupancy Taxes
Franchise Taxes 90%
Licenses and Permits
Interest and Rentals 159%
150%
Intergovernmental from State
Charges fo.r Services
Fines and Forfeitures 7o
14%9 °~
Other Revenues ': I I 76 ~
0% 30% 60% 90% 120% 150%
50% of Year Complete
FY 2002/03 FY 2002~03 % of FY 2001/02 % of Total for
Budget YTD Actual Budget YTD Actual FY 2001102
Property Taxes 9,892,843 4,759,016 48% 3,587,733 41%
Sales Taxes 12,702,000 5,935,950 47% 5,483,008 43%
Real Property Transfer Tax 415,000 130,314 31% 196,151 45%
Transient Occupancy Taxes 858,000 321,920 38% 347,686 43%
Franchise Taxes 1,493,900 359,961 24% 372,623 27%
Licenses and Permits 1,622,404 1,459,639 90% 856,407 37%
Interest and Rentals 1,373,538 811,085 59% 963,410 50%
Intergovernmental 2,096,165 940,408 45% 935,776 45%
Charges for Services 4,815,035 1,838,665 38% 2,017,837 45%
Fines and Forfeitures 114,000 45,011 39% 58,707 50%
Other Revenues 742,768 106,692 14% 373,750 76%
Total General Fund Revenues 36,125,653 16,708,661 46% 15,193,088 43%
Date Printed: 1/7,2003 2:38 PM ATTACH MEN T 1
City of Dublin 2002-2003 YTD Expenses and Budget Com ~arison
For the Period Ending December 31, 2002
Total General Fund ~1 '/0
Expenses ~
~ 43°/,
General Government · ]40%
Police l~°~ °/'°
2F% !i
1
Fire ~ 2 r%
Other Public Safety 29%
· FY 2002/03
353/0 [] FY 2001/02
Transportation 40%
Health and Welfare 131%
,
Culture & Community 142%
Services ~ 42%
Community I/~1~% o
Development
Capital Improv. 39%
Projects 139%
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
50% of Year Complete
FY 2002/03 FY 2002~03 % of FY 2001/02 % of Total for
Budget YTD Actual Budget YTD Actual FY 2001/02
General Government 4,393,521 1,893,671 43% 1,580,057 40%
Poi ice 7,876,674 415,643 5% 513,260 8%
Fire 5,108,279 1,354,399 27% 1,265,540 27%
Other Public Safety 313,858 41,729 13% 69,463 29%
Transportation 1,337,221 470,359 35% 434,328 40%
Health and Welfare 69,001 21,429 31% 11,686 22%
Culture and Community Services ,4,740,119 2,000,218 42% 1,673,625 42%
Community Development 5,784,070 2,259,486 39% 2,026,729 44%
Capital Improvement Projects 11,362,877 4,385,152 39% 2,284,912 39%
Total General Fund Expenses 40,985,620 12,842,086 31% 9,859,600 32%
General Fund Operating Expenses 29,622,743 8,456,934 29% 7,574,688 · 30%
ATTACHMENT 2
Date Pdnted: 1/30/2003 12:52 PM
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF DECEMBER 2002
Prepared by
The Finance Department
January 7, 2003
ATTACHMENT 3
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Dec2002
GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY---
FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR
ASSETS
CASH (46,154,848) 3.891,134 493,786 37,623,057 136.071 (4,010,800) (23,144,394)
CASH WITH FISCAL AGENT 171,289 171,289 167,304
AMOUNT HELD IN ESCROW 109,300
INVESTMENTS AT COST 91,334,331 91,334,331 90,237,895
RECEIVABLES: TAXES
ACCOUNTS 128,985 36t,702 500,688 157,651
INTEREST 542,481 542,481 312,860
ASSESSMENTS
DUE FROM OTHERS 6.791 6,791
INVENTORY AT COST
PREPAID ITEMS 10,919 10,919 8,745
FIXED ASSETS
AMOUNT TO BE PROVIDED 1,553,500 1,553,500 1,652,500
TOTAL ASSETS 45,878,659 4,252,826 493,786 27,623,057 1,860,860 90,109,198 69,501,860
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL (980.838) (980,838) (764,022)
DEPOSITS FOR AB1600 FEES (86.735) (3,604,987) (3.691,722) (23.843,140)
DEPOSITS OTHERS (910,758) (910.758) (460,416)
PAYABLES: ACCOUNTS (153,525) (102,571) (89.182) (345,278) (260,646)
INTEREST
PAYROLL (408,466) (408.466) (329,197)
DUE TO OTHERS (17,932) (6,791) (24.723) (28,280)
DEFERRED REVENUE '(127,768) (127,768) (t46,433)
DEBT INSTRUMENTS PAYABLE (1,671.000) (1,671,000) (1,770,000)
TOTAL LIABILITIES (2,686,022) (109,362) (3,694,169) (1.671,000) (8,160,553) (27,602,134)
FUND BALANCES (43,192,637) (4.143,474) (493,786) (33.928.888) (189,860) 81,948,645) (41,899,726)
TOTAL FUND E (43.192,637) (4,143,474) (493.786) (33,928.888) (189,860) 81.948,645) (41,899,726)
TOTAL LIABILITIES/EQUITY (45,878.659) (4,252,836) (493,786) (37,623,057) (1,860,860) (90,109,198) (69,501,860)
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Dec2002
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S
SERVICE FUND GROUP OF TERM DEBT ---MEMO~NDUM---
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR
ASSETS
CASH 6,636,388 (20) 6,636.368 5,801,139
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS 36.183,959 t2,492,387 48,676,346 38.136,473
AMOUNT TO BE PROVIDED 50,675,589 50.675,589 41.557,588
TOTAL ASSETS 42.820.346 (20) 12.492.387 50.675,589 105.988.303 85.495,200
LIABILITIES/FUND EQU[TY
DEPOSITS FOR ~RIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS (1)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (50,675,589) (50.675.589) (41,557,588)
TOTAL LIABILITIES (50,675,589) (50,675.589) (41,557.588)
FUND BALANCES (42.820,346) 20 12,492.387) (55.312.714) (43.937.611)
TOTAL FUND E (42.820,346) 20 12.492.387) (55.312:714) (43,937,611)
TOTAL LIABILITIES/EQUITY (42.820.346) 20 12.492,387) (50.675.589) (105,988,303) (85,495.200)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 12/31/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T,D. VARIANCE
**********************
PROPERTY TAXES 9,892,843.00 4,759,015.58 5.133,827.42 8,794 710.89 3,587,732.94 5,206,977.95
SALES TAX 12,702,000.00 5,935,949.56 6,766,050.44 12,813 111.10 5,483,007.80 7,330,103.30
REAL PROPERTY T~NSFER TAX 415.000.00 130,314.43 284,685.57 434 832.20 196,151.29 238,680.91
HOTEL T~NSIENT OCCUPANCY TAX 858,000.00 321,920.47 536,079.53 8t0 219.79 347,685.68 462,534.11
F~NCHISE TAXES 1,493.900.00 359.961.21 1,133,938.79 1.385 815.52 272,623.42 1,013,192.10
LICENSES & PERMITS 1,622,404.00 1.459,639.24 162,764.76 2.327 250.77 856.406.83 1,470,843.94
FINES & FORFEITURES 114,000.00 45,010.98 68,989.02 118 190.93 58.706.73 59,484.20
USE/MONEY & PROP-INTEREST 1,244.226.00 760,468.80 483.757.20 1,843 673.66 926,856.56 916,817.10
USE/MONEY & PROP-RENTALS 129,312.00 50,616.25 78,695.75 85 936.82 26,553.60 49,383.22
INTERGOVERNMENTAL 2,096,165.00 940,408.25 1.155,756.75 2.076 648.50 935,776.29 1.140,872.21
CHARGES FOR SERVICES 4,815,035.00 1,838,665.42 2,976,369.58 4,464,259.66 2,017,837.21 2,446,422.45
OTHER SOURCES OF REVENUE 742,768.00 106,691.88 636,076.12 493.722.65 373,750.1t 119.972.54
TOTAL REVENUE 36,125,653.00 16,708,662.07 19,416,990.93 35.648,372.49 15,193,088.46 20,455,284.03
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 212,922.00 102,208.34 110,723.66 217 946:55 95,677.90 122,268.65
CITY MANAGER 739,518.00 340,300.99 399,217.01 560 359.16 224.023.68 326,335.48
CENTRAL SERVICES 319,600.00 127.911.57 191,688.43 297 049.71 132.237.64 164 812.07
CITY A-FFORNEY 659,076.00 413,187.64 245,888.36 764 484.52 315,579.93 448 904.59
ADMIN SERVICES 1.038,223.00 452,769.89 585,453.11 922 865.72 426.088.74 496,776.98
BUILDING MANAGEMENT 731,567.00 291,620.72 439,946.27 657 327.17 241,973.62 415 353.55
INSURANCE COST CENTER 286,665.00 164:048.86 222,616.14 385 295.68 134,042.84 251 352.84
ELECTIONS COST CENTER 20.940.00 1,622.50 19,317.50 14.507.57 432.19 14,075.38
NON-DEPARTMENTAL 285,000.00' 285,000.00 t09,981.56 10,000.00 99,981.56
ACTIVITY TOTAL 4.393,521.00 1,893,670.52 2,499,850.48 3,929,917.64 !,580,056.54 2,349,861.10
PUBLIC SAFETY
POLICE 7.876,674.00 415,643.03 7,461,020.97 6,668,234.72 513,260.04 6,154,974.68
CROSSING GUARDS 71,462.00 18,139.25 53,322.75 56,677.08 16,415.49 40,261.59
ANIMAL CONTROL 181,437.00 181,427.00 138,935.98 32,068.87 106.867.11
DISASTER PREPAREDNESS 60,959.00 23.589.75 37,369.25 46,012.48 20,978.22 25,034.26
FIRE SERVICES 5,108,279.00 1,354.398.95 3,753,880.05 4,698.607.54 1,265,540.41 3,433,067.13
ACTIVITY TOTAL 13,298,811.00 1,811,770.98 11,487,040.02 11~608,467.80 1,848,263.03 9,760,204.77
T~NSPORTATION
PUBLIC WORKS 616,631.00 273.965.14 342,665.86 557,207.53 251,433.85 305,773.68
STREET MAINTENANCE 10,427.00 250.43 10,176.57 6,406.00 617.55 5.788.45
STREET SWEEPING 132,100.00 38.744.60 93,355.40 122,383.34 42,888.38 89.494.96
STREET TREE MAINTENANCE 70,337.00 17.883.91 52,453.09 51.079.02 17,864.40 32.214.62
STREET LANDSCAPING MAINTENAN 507,726.00 139,514.86 368,211.14 347,022.86 121,523.81 225,499.05
ACTIVITY TOTAL 1,337,221.00 470.358.94 866,862.06 1,094,098.75 434,327.99 659,770.76
HEALTH & WELFARE
WASTE MANAGEMENT 8,242.00 3.551.78 4,690.22 1,807.38 46.38 1.761.00
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 12/31/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR ~RIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
CHILD CARE 15.000.00 6.165.13 8.834.87 15.000.00 3,640.00 11.360.00
SOCIAL SERVICES 6.000.00 6.000.00
HOUSING PROGRAMS 39.759.00 5.71t.74 34.047.26 35.209.87 8.000.00 27,209.87
ACTIVITY TOTAL 69.001.00 21.428.65 47.572.35 52.017.25 1t.686.38 40.330.87
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 496 219.00 119.829.50 376 389.50 376.276.00 100 181.25 276.094.75
CULTURAL ACTIVITIES 137 t53.00 75.933.90 61 219.10 119.409.29 85 896.96 33 512.33
HERITAGE CENTER 90 771.00 40,227.34 50 543.66 69.081.56 25 526.00 43 555.56
DUBLIN CEMETERY 37 418.00 11.186.91 26 231.09 30.077.98 10 658.96 19 419.02
PARK MAINTENANCE 1,263 230.00 487.804.09 775 425.91 1,086.713.48 399 025.65 687 687.83
COMMUNITY TV 70 906.00 69,402.69 i 503.31 80.087.02 56 957.00 23 130.02
RECREATION ADMIN 453 444.00 207.657.72 245 786.28 374.416.72 155 172.30 219 244.42
PLAYGROUNDS 261 690.00 104.550.00 157 140.00 207,515.47 94 995.93 112 519.54
SHANNON CENTER 270,182.00 117,295.01 152 886.99 250.834.31 100 695.28 150 t39.03
PRESCHOOL 79.421.00 35,271.63 44 149.37 57.470.25 25 958.58 31.511.67
TEENS PROGRAM 113.854.00 43 382.64 70.471.36 106.182.40 47 805.74 58.377.66
ADULT SPORTS 95.061.00 44 777.36 50.283.64 76.886.84 34 741.84 42,145.00
YOUTH SPORTS 96.743.00 37 630.01 59,112.99 82,402.67 31 151.10 51.251.57
COMMUNITY GYM 35.167.00 16 121.90 19.045.10 23,572.33 7 659.12 15.913.21
SPECIAL EVENTS 349,589.00 174 440.77 175.148.23 314.735.18 156 449.36 158,285.82
SENIOR CENTER 190.215.00 76.530.19 113.684.81 146 824.25 61 496.18 85°328.07
RECREATION INSTRUCTION 143,005.00 75.437.57 67.567.43 145 812.50 63.896.81 81.915.69
AQUATICS 332.691.00 167,958.34 164.732.66 322 391.18 163.882.42 158.508.76
PARKS/FACILITIES MANAGEMENT 223,360.00 94.779.93 128.580.07 142 041.19 51,474.02 90,567.17
ACTIVITY TOTAL 4.740,1t9.00 2.000.217.50 2.739.901.50 4.012.731.62 1.673.624.50 2~339.107.12
COMMUNITY DEVELOPMENT
PLANNING 2,021,188.00 728.698.84 1.292,489.16 1.486,541.67 644.657.19 841o884.48
BUILDING SAFETY 1,563,70t.00 589.509.44 974.191.56 1,276,343.20 547.440.75 728,902.45
ENGINEERING 1,902,477.00 778.550.72 1.123,926.28 1.609,544.48 687.912.79 921.631.69
ECONOMIC DEVELOPMENT 296.704.00 162.727.08 133.976.92 271.222.90 146.7t8.19 124.504.71
ACTIVITY TOTAL 5.784,070.00 2.259.486.08 3.524,583.92 4,643.652.25 2.026.728.92 2.616.923.33
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 6,952.517.30 4,066,221.34 2,886,295.96 4,582,889.35 1,923,098.26 2,659.791.09
COMMUNITY IMPROVEMENTS 1,814,645.00 152,417.79 1,661.227.2t 273,282.82 42,669.26 230,614.56
PARKS 1.598.896.00 105,059.88 1,493,836.12 35t,854.08 81,484.72 270,269.36
STREET CONSTRC/IMPROVEMENTS 996.819.00 60,452.89 936,366.11 580,008.92 237,660.13 342,348.79
ACTIVITY TOTAL 11,362,877.30 4,385,151.90 6.977,725.40 5,788.036.17 2,284,912.37 3.503.123.80
TOTAL EXPENDITURES 40,985,620.30 12,842,084.57 28.143,535.73 31,128.921.48 9,859,599.73 21.269,321.75
EXCESS REVENUE (EXPENDITURES (4,859,967.30) 3,866,577.50 (8.726,544.80) 4.519.451.01 5,333.488.73 (814.037.72)
TRANSFERS IN FROM OTHER FUNDS 16,784.89 16,784.89
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES (4,859,967.30) 3,866,577.50 (8,726,544.80) 4.536,235.90 5,333,488.73 (797,252.83)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 12/3t/2002
SPECIAL REVENUE FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
***********************
PROPERTY TAXES 93.610.00 51.268.30 42.341.70 91.099.68 45.429.96 45,669.72
SALES TAX/OTHER TAXES 317.700.00 136.466.71 181,233.29 206.812.62 85,617.60 121.195.02
FINES & FORFEITURES 153,000.00 50.856.86 102.143.14 t49.023.41 44.939.99 104,083.42
USES/MONEY & PROPERTY 50.995.00 46.054.73 4,940.27 135.432.87 63.876.34 71.556.53
INTERGOVERNMENTAL FROM STATE 4,518.386.00 3,338.499.77 1.179.886.23 1,601.090.43 444.981.34 1.156.109.09
INTERGOVERNMENTAL FROM COUNTY 240.909.00 78.008.25 162.900.75 241.589.50 83.107.00 158.482.50
INTERGOVERNMENTAL FROM FEDE~L 242.461.00 60.723.72 181,737.28 782.793.26 24,398.80 758.394.46
CHARGES FOR SERVICES 885.779.00 458,063.84 427.715.16 865.790.08 430,184.18 435.605~90
OTHER SOURCES OF REVENUE 5.000.00 5.000.00 30,997.14 15,525.13 15.472.01
TOTAL REVENUE 6.507.840.00 4,219.942.18 2.287.897.82 4,104.628.99 1.238.060.34 2.866,568.65
**************************
PUBLIC SAFETY:
POLICE 205,727.00 38.455.39 167,271.61 377,390.53 96,551.36 280.839.17
T~FFIC SIGNALS & STREET LTG 145.900.00 42.346.72 103.553.28 145.399.20 36.000.38 109.398.82
FIRE SERVICES 213,873.00 51.160.25 162,712.75 193,800.29 55,413.89 138.386.40
ACTIVITY TOTAL 565,500.00 131,962.36 433,537.64 716.590.02 187.965.63 528.624.39
T~NSPORTATION:
STREET MAINTENANCE 219.619.00 49.096.27 170,522.73 209.801.34 45.697.28 164.104.06
STREET SWEEPING
ACTIVITY TOTAL 219.619.00 49.096.27 170,522.73 209.801.34 45.697.28 164,104.06
HEALTH & WELFARE:
WASTE MANAGEMENT 1.079.569.00 517.78 1.079.051.22 1.030,807.37 4,136.78 1,026.670.59
SOCIAL SERVICES 28.427.00 5.616.17 22.810.83 7,500.00 1.875.00 5.625.00
HOUSING PROGRAMS 9.999.54 2.496.40 7.503.14
ACTIVITY TOTAL 1.107.996.00 6.133.95 1,101.862.05 1.048 306.91 8.508.18 1.039.798.73
COMMUNITY DEVELOPMENT:
ENGINEERING 6.000.00 364.50 5.635.50 6.000.00 1,311.00 4.689.00
ACTIVITY TOTAL 6.000.00 364.50 5.635.50 6.000.00 1.311.00 4.689.00
CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS
COMMUNITY PROJECTS 36.782.00 36.782.00 73.425.55 19.958.55 53.467.00
PARKS 426.095.00 426.095.00
STREET CONSTRUCTION/IMPROVEMENT 4.890.626.00 1.555.093.68 3.335.532.32 2.259.994.81 1.547.555.05 712.439.76
ACTIVITY TOTAL 5.353.503.00 1.555.093.68 3.798.409.32 2.233.420.36 1.567.513.60 765.906.76
T 0 T A L EXPENDITURES 7,252.618.00 1,742.650.76 5.509.967.24 4.314.118.63 1.8t0.995.69 2.503.122.94
EXCESS <REVENUE>EXPENDITURE 744.778.00 2,477.291.42) 3,222.069.42 209.489.64 572.935.35 (363.445.71)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 849.931.16 (849.931.16) 16.784.89 t6.784.89
EXCESS <REVENUE> EXPENDITURE 744.778.00 (1.627.360.26) 2.372.138.26 226.274.53 572.935.35 (346.660.82)
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 12/31/2002
SPECIAL ASSESSMENT FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
**********************
SPECIAL BENEFITS ASSESSMENTS 536.364.00 247.790.91 288,573.09 43t.564.21 217,332.02 214,232.19
USES/MONEY & PROP-INTEREST 13,888.00 6,787.02 7,100.98 20,738.74 9,125.20 11,613.54
OTHER SOURCES OF REVENUE 4,000.00 5,070.54 (1,070.54) 1,995.50 1,970.50 25.00
TOTAL REVENUE 554,252.00 259.648.47 294,603.53 454,298.45 228,427.72 225,870.73
*******EXPENDITURES****-~*~
PUBLIC SAFETY:
T~FFIC SIGNALS & STREET LIG 274,300.00 75,580.56 198.719.44 198,138.51 66,785.58 131~352.93
ACTIVITY TOTAL 274.300.00 75.580.56 198,719.44 198,138.51 66,785.58 131.352.93
TRANSPORTATION
PUBLIC WORKS 4,754.00 681.95 4,072.05 3.277.32 1,548.11 1,729.21
STREET TREE MAINTENANCE 15,944.00 4,904.06 11,039.94 7,713.24 2.907.94 4,805.30
STREET LANDSCAPE MAINTENANCE 292,861.00 120,177.22 172,683.78 231,458.34 96,543.39 134,914.95
ACTIVITY TOTAL 313.559.00 125.763.23 187,795.77 242,448.90 100.999.44 14t,449.46
COMMUNITY DEVELOPMENT
ENGINEERING 16,250.00 8,709.56 7,540.44 20,071.01 10,220.76 9.850.25
ACTIVITY TOTAL 16,250.00 8.709.56 7,540.44 20,071.01 10,220.76 9,850.25
CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT 102,000.00 102,000.00
ACTIVITY TOTAL 102,000.00 102,000.00
T 0 T A L EXPENDITURES 706,109.00 210.053.35 496,055.65 460,658.42 178,006.78 282,652.64
EXCESS <REVENUE>EXPENDITURE 151,857.00 (49,595.12) 201,452.12 6,359.97 (50~421.94) 56,781.91
EXCESS <REVENUE>EXPENDITURE 151,857.00 (49,595.12) 201,452.12 6,359.97 (50,421.94) 56,781.9t
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 12/31/2002
CAPITAL IMPROVEMENT FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
**********************
USES/MONEY & PROP-INTEREST 1,104,085.00 690,013.13 4t4,071.87 1,743,568.68 766,333.51 977,235.17
OTHER SOURCES OF REVENUE 11.180,405.00 11.180,405.00 19,685,683.29 19,685,683.29
TOTAL REVENUE: 12.284,490.00 690,013.13 11.594.476.87 21,429.251.97 766,333.51 20,662,918.46
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
CITY ATTORNEY 12,950.00 3.964.92 8,985.08
ACTIVITY TOTAL 12,950.00 3,964.92 8,985.08
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 214,797.00 53.540.74 161,256.26 96,t33.06 13,488.06 82,645.00
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING 2,561.31 (2.561,31) 8.585.61 8,049.60 536.01
ACTIVITY TOTAL 2.561.31 (2,561.31) 8.585.61 8.049.60 536.01
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 10,722,986.43 1,466,854.45 9,256,131.98 4.324,162.75 306,517.35 4,017,645.40
COMMUNITY IMPROVEMENTS
PARKS 3,416,077.00 879,554.12 2,536,522.88 125,589.57 125,589.57
STREET CONSTRUCTION/IMPROVEMENT 19,770.575.00 4,673.417.77 15,097,157.23 4,085,145.94 1,450,266.77 2.634.879.17
ACTIVITY TOTAL 33,909,638.43 7,019,826.34 26,889,812.09 8,534.898.26 1,756,784.12 6,778,114.14
T 0 T A L EXPENDITURES 34,137,385.43 7.079,893~31 27,057,492.12 8,639.616.93 1,778,321.78 6,861,295.15
EXCESS <REVENUE>EXPENDITURE 21.852,895.43 6,389,880.18 15,463,015.25 (12,789,635.04) 1.011,988.27 (13.801,623.31)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 2t,852.895.43 6,389,880.18 15.463,015.25 (12,789,635.04) 1,011,988.27 (13,801.623.31)
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 12/31/2002
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
**********************
SPECIAL ASSESSMENTS 118,659.03 (118,659.03) 237,264.42 118,632.21 118,632,21
USES/MONEY & PROP-INTEREST 1,898.30 (1,898.30) 8,099.29 1,767.78 6,331.51
TOTAL REVENUE 120,557.33 (120,557.33) 245,363.71 120,399.99 124,963.72
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 229,828.00 171,227.71 58,600,29 233.733.39 167,544.06 66,189.33
ACTIVITY TOTAL 229,828.00 171,227.71 58,600.29 233.733.39 167,544,06 66,189.33
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES 229,828.00 171 227.71 58,600.29 233,733.39 167,544.06 66.189.33
EXCESS <REVENUE>EXPENDITURE 229.828.00 50 670.38 179.157.62 (11.630.32) 47.144.07 (58.774.39)
EXCESS <REVENUE>EXPENDITURE 229,828.00 50.670.38 179,157.62 (11,630.32) 47.144.07, (58,774.39)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 12/31/2002
INTERNAL SERVICE FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
--********************
USES/MONEY & PROP-INTEREST 227,059.00 111,500.94 115,558.06 262.597.72 121,730.05 140,867.67
CHARGES FOR SERVICES 1,367,268.00 637,667.04 729.600.96 1,103,647.14 560,976.22 542,670.92
OTHER SOURCES OF REVENUE 20.000.00 13,560.00 6.440.00 22,267.13 14.678.10 7.589.03
TOTAL REVENUE 1.614.327.00 762,727.98 851.599.02 1.388.511.99 697.384.37 691.127.62
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 1,741.280.00 427.088.72 1.314.191.28 1.092.881.67 250.569.19 842.312.48
ACTIVITY TOTAL 1.74t.280.00 427 088.72 1.314,191.28 1,092,881.67 250.569.19 842.312.48
PUBLIC SAFETY:
FIRE 51.818.00 12 478.21 39.339.79 41,899.88 14.260.06 27.639.82
ACTIVITY TOTAL 51.818.00 12 478.21 39.339.79 41,899.88 14.260.06 27.639.82
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 I A L EXPENDITURES 1.793,098.00 439,566.93 1.353.531.07 1,134.781.55 264.829.25 869.952.30
EXCESS <REVENUE>EXPENDITURE 178.771.00 (323.161.05) 501.932.05 (253,730.44) (432.555.12) 178.824.68
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 178.771.00 (323,161.05) 501,932.05 (253.730.44) (432.555.12) 178.824.68
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/0t/2002 THROUGH 12/31/2002
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
**********************
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 20.00 (20.00)
FINANCE
ACTIVITY TOTAL 20.00 (20.00)
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES 20.00 (20.00)
EXCESS <REVENUE>EXPENDITURE 20.00 (20.00)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 20.00 (20.00)
CITY OF DUBLIN
BUDGET CHANGE FORM
CHANGE FORM #
New Appropriations (City Council Approval Required): Budget Transfers:
X From Unappropriated Reserves From Budgeted Contingent Reserve (1080-799.000)
--(If Other than General Fund, Fund) __X__ Within Same Department Activity
From New Revenues Between Departments (City Council Approval Required)
Other
Name: Library- Building $3,938,898 Name: Legal Services - Litgation $27,000
Account #: 001.93450.750.030 Account #: 001.10300.741.001
Name: Library ~ Furniture $102,331 Name: Community Cable TV - Contract $13,000
Services
Account #: 001.93450.750.062 Account #: 200.20100.750.073
Name: Name:Building and Safety - Contract Services $40,000
Account #: AccoUnt #:001.90200.740.000
Name: Name: Library- Building $3,938,898
Account #: Account #: 310.93450.750.030
Name: Name: Library - Furniture $102,331
Account #: Account #: 310.93450.750.062
Name: Name:
Account #: Account #:
City Manager: "'~'""~~0~:~O C.. ~,,.Signatu~e D ate:(~
ASD/Fin Mgr * ~?,tZ~-~?~-~ ~x'~e~',~'---- Date:
Signature
REASON FOR BUDGET CHANGE ENTRY: Budget Changes designated in Mid Year Report for Fiscal
Year 2002-03
Mayor: Date:
Signature
Posted By: Date:
Signature
G: lMid Year ReportslFY 2OO2-O31FORM-budget change mid yr. doc