HomeMy WebLinkAboutItem 8.3 Mid Year Budget Report CITY CLERK
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: March 2, 2004
SUBJECT: Fiscal Year 2003-04 Mid-Year Budget Report and
December 2003 Monthly Report of Financial Activities
Report Prepared by: Carole A. Perry, Administrative Services Director
and Fred W. Marsh, Finance Manager
ATTACHMENTS: 1. YTD Revenues and Budget Comparison
2. YTD Expenses and Budget Comparison
3. Financial Statements for the Month of
December 2003
4. Budget Change Forms
RECOMMENDATION: 1. Receive the Reports
2. Approve Budget Changes
3. Authorize the use of $664,875 from General Fund Senior
Center Reserves to pay for the current Fiscal Year portion of
Senior Center project
4. Authorize a Loan in the amount of $1,819,871 from the General
Fund Emerald Glen Fire Station Reserves to pay for the current
Fiscal Year portion of the Emerald Glen Fire Station project.
FINANCIAL STATEMENT: See Below
DESCRIPTION: Attached is the monthly report of financial activities for December 2003. 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.
2003-04 ADOPTED BUDGET - GENERAL FUND REVENUES / EXPENDITURES,
The Fiscal Year 2003-04 Budget adopted by the City Council in June 2003 anticipated that General Fund
Revenues, combined with reserves for Capital Projects and Net Fund Transfers In/Out, would exceed
General Fund Expenditures by $846,531. If the surplus was realized at the end of Fiscal Year 2003-04, the
City Council directed the surplus funds to be added to the City's reserve for Economic Uncertainty.
Since the adoption of the Budget, the City Council has approved additional Budget changes, Transfers, or
Revenue adjustments; which have occurred through the Council Meeting of January 16, 2004. These items
are summarized on the following page:
G:XMid Year Reports\FY 2003-04\midyear report.DOC COPIES TO:
l tl
APPROPRIATION ADJUSTMENTS APPROVED SUBSEQUENT TO BUDGET ADOPTION
Amount of
Additional Amount of Revenue
Appropriations Additions/
from Prior Year (Reductions)
Item Reserves
Elimination by State of Backfilling of Vehicle License Fee ($456,000)
Welcome Home Parade and Celebration $2,000
Writeoff of Uncollectible Receivables $26,485
State of the City Video $3,800
Traffic Signal at Central Parkway and Tassajara Creek $23,855
Front Counter Upgrade $27,358
Additional General Fund monies for Contract Police Personnel $3,254
Construction of Fire Station 17 $68,294
Additional CIP Carryovers from Fiscal Year 2002-03 $571,173
Additional Operating Carryovers from Fiscal Year 2002-03 $38,600
Champions of Small City Management Program $24,000
Strategic Planning Process $15,000
Totals $803,819 ($456,000)
REVENUE ESTIMATES UPDATE - GENERAL FUND
Staff has analyzed the original Revenue Estimates contained in the Fiscal Year 2003-04 Adopted Budget.
The following breakdown will address anticipated changes within major categories, as well as any proposed
adjustments to be made to the Budget Estimates in the City's Financial Records.
Property Taxes
(Category represents approximately 30% 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 2003-04. 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 monies due to the county for the sharing of sales tax collections
covered by the Santa Rita Annexation Agreement, as well as revenue transfers mandated by the State
of California. This includes the permanent Property Tax Shift to the Education Revenue
Augmentation Fund (estimated at $1.2 million in Fiscal Year 2003-04) and Property Tax
Administrative Charges (estimated at $150,000 in Fiscal Year 2003-04). 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 $91,000
Sales Taxes
(Category represents approximately 35% of budgeted General Fund Revenues)
Currently, sales tax collected to date is slightly ahead of the budgeted projection for the year. It
should be noted however, the retail sales tax data recorded to date only includes sales occurring prior
to October 1, 2003 (i.e. first quarter of Fiscal Year 2003-04) and the advances of sales taxes by the
State for the period of October 2003 through January 2004. It does not include the retail holiday
season reporting, which typically represents a larger percentage of sales tax revenue. Preliminary
projections indicate that sales tax is estimated to be over budget, largely due to auto sales and a one-
time receipt of sales tax monies from a cellular provider. However, this increase could be positively
or negatively impacted by holiday receipts, therefore Staff is recommending no increase to the sales
tax revenue estimate at this time.
Revised Estimate: No Change
Taxes Other than Property and Sales
(Category represents approximately 7% of budgeted General Fund Revenues)
When comparing tax revenues for the first six months of this fiscal year t° the same period in the
prior year, it is projected that the revenues will be above the budget estimate. The combined
adjustments are expected to result in an increase of $89,000.
The valuation from the sales of new and existing residential properties in the City has increased in
comparison to the prior year, and as a result the City expects to collect $105,000 more than originally
anticipated in property transfer taxes.
Due to the continued sluggish economy and lingering effects from the national events that occurred in
Fiscal Year 2001-02, Transient Occupancy Taxes (TOT) collected from the City's four hotels is
below the amount collected through the same period in the prior year. As a result, the City expects to
collect approximately $56,000 less than originally expected for TOT.
Franchise Fees for the first six months are above estimates and are projected to be approximately ·
$40,000 over budget by year end, dUe to a higher than expected addition of new residential customers
resulting from the continued development occurring in the eastern portion of the City.
Revised Estimate: Increase $ 89,000
Licenses & Permits
(Category represents approximately 5% 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 $280,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 2003-04, the expenses associated with the actual building
inspections may occur in Fiscal Year 2004-05.
REVISED ESTIMATE: Increase $ 280,000
Interest & Rentals
(Category represents approximately 2% of budgeted'General Fund Revenues)
Interest Revenue represents 84% 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 by approximately $188,000.
The City's interest yield to date has been higher than was originally assumed in the budget estimate.
In addition, the General Fund has had a larger cash balance than was assumed in' the budget estimate
that was available for investment through December 2003. 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 may be affected by any significant
changes that could occur in interest rates and changes in market value on the City's investments
during the remainder of the Fiscal Year.
It currently appears that the revenue to be received from the rental of City facilities will meet the
original budgeted forecast.
Revised Estimate: Increase $188,000
Intergovernmental Revenues
(Category represents approximately 5% of budgeted General Fund Revenues)
The County Auditor Controller has issued a statement to the City containing the estimated amount of
property tax relief to be received by the City from homeowner's exemptions claimed for Fiscal Year
2003-04, which is $12,000 below what the City had forecast in its adopted budget.
Based upon revenues for the first six months, as compared to the same period in the prior year, it
currently appears that that projected revenues from Vehicle License Fees (VLF) will fall below the
revenue estimate contained in the revised Fiscal Year 2003-04 budget by approximately $180,000.
The amount of VLF received in the current Fiscal Year has declined from the prior Fiscal Year due to
lower car sales statewide and the State not paying the backfill portion of the VLF for the first three
months of the Fiscal Year. It should be noted that Council already approved a budget adjustment at
the September 16, 2003, Council Meeting reducing the VLF revenue budget by $456,000 to
compensate for this expected loss of revenue.
The Governor recently repealed the increase in the VLF that took place on October 1, 2003. The
status of funding the VLF backfill is still not settled. Unless the State does pass legislation that
provides funding to reestablish the payment of the backfill portion of the fee, the City could realize a
total loss of approximately $1.5 million in VLF for Fiscal Year 2003-04. Thus the added net loss of
VLF revenue to the City would be approximately $1 million.
It should be noted, however, that the Governor has directed that the State make partial payments for
the VLF backfill to the counties and cities for the month of November and December. The total VLF
received in January 2004 was $246,641, which consisted of a normal payment of $150,002 plus a
partial payment of $96,639 for backfill monies due for the months of November and December.
For purposes of preparing the City'S mid year report, and due to the many uncertainties outstanding
regarding the future receipt of VLF revenue from the State, it was assumed that the City will continue
to receive payment of a portion of the "backfill" portion of this fee through the remainder of the Fiscal
Year. Should the State decide to discontinue payment of the backfill portion of the fee, the City will
be able to offset the loss of this revenue for Fiscal Year 2003-04 through the use of funds
accumulated in its General Fund reserves.
Revised Estimate: Decrease $192,000
Charges for Services
(Category represents approximately 13% of budgeted General Fund Revenues)
Based upon Charges for Services for the first six months, it appears that the original Revenue
Estimate for this category for Fiscal Year 2003-04 will be approximately $75,000 less than budgeted.
It should be noted that the City expects to receive approximately $267,000 less in revenue for the fire
charges for services revenue item due to a change in how the Alameda County Sheriffs Office is
handling calls for emergency service at the Santa Rita location. Zoning and Subdivision Fees are also
expected to come in approximately $50,000 less than budgeted, due to $254,000 of reimbursements
from developers from the Alameda County Courthouse Review and Camp Parks General Plan Study
not expected to be received until Fiscal Year 2004-05, which is also offset by a reduction of
Community Development expenditures discussed below. These projected revenue reductions in
zoning and subdivision fees are partially offset by approximately $204,000 of additional
reimbursements expected to be received from developers for legal costs incurred for the processing of
new development in eastern Dublin. Lastly, booking fee revenues are also projected to be about
$12,000 under budget.
Revised Estimate: Decrease $ 329,000
Fines & Forfeitures
(Category represents less than 1% of budgeted General Fund Revenues)
Parking Fine revenues for the first six months are ahead of budget and are projected to be
approximately $6,000 ahead of budget by year end, due to an increase in the amount allocated to the
City from the receipt of court fines in comparison to the same period in the previous year.
Revised Estimate: Increase $ 6,000
Other Revenues
(Category represents approximately 1% 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 above the revenue estimate contained in
the Fiscal Year 2003-04 Budget by $476,000. This variance is due to reimbursements received from
'a developer for street repair costs and turf maintenance which was not included as part of the original
budget, a one time receipt of funds from the City's life insurance company, and a higher than
anticipated reimbursement received from LAVTA for construction of new bus shelters. In addition,
reimbursements for the Dublin Boulevard Underground Utility project, originally expected to be
received in the prior Fiscal Year, are now projected to be received in the current Fiscal Year.
Revised Estimate: Increase $ 476,000
In summary, Staff's proposed changes to its'preliminary revised revenue estimate for the General Fund for
Fiscal Year 2003-04 is approximately $427,000 or 1% higher than the total revised budgeted amount for
revenues in the General Fund.
REVISIONS TO EXPENDITURE ESTIMATES - GENERAL FUND
Staff has reviewed expenditures through December 2003 for all accounts that affect the City's General Fund.
Given the lag in billing for some of the contract services, the Cky 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 12% of the budgeted General Fund Expenditures)
The Legal Services Activity is projected to exceed its budget by approximately $163,000. The main
reason for the higher costs is due to higher than anticipated time spent on legal services for new
development. Since the City is reimbursed from developers for the cost of development related
services, this has also resulted in higher than expected revenues collected for development related
services.
Revised Budget Estimate: Net Increase $163,000'
Culture and Leisure
(Represents approximately 13% of the Budgeted General Fund Expenditures)
The Aquatics budget is expected to exceed its budget by approximately $15,000 due to filter repairs
needed for the pool which were not anticipated as part of the original adopted budget. The Cemetery
budget is expected to exceed its budget by approximately $11,000 due to increased water costs and
higher than expected costs for contract maintenance services. The library budget is expected to be
below its budget by approximately $16,000 due to lower than expected costs for contract building
services.
Revised Budget Estimate: Net Increase $10,000
Community Development
(Represents approximately 16% of the Budgeted General Fund Expenditures)
Community Development expenditures are projected to be 'approximately $226,000 below budget.
The Planning Division anticipates being under budget by approximately $306,000 due to savings
realized and project delays on the following projects:
Amount of Amount Estimated to
Estimated Project be Deferred To
Name of Project Savings Fiscal Year 2004-2005
Historical District Specific Plan Amendment- $24,000 $25,000
Donlon Way
Alameda County Courthouse Review $7,000
Streetscape Master Plan $10,000
Scarlett Court Specific Plan Amendment $40,000
Amount of Amount Estimated to
Estimated Project be Deferred To
Name of Project Savings Fiscal Year 2004-2005
Camp Parks General Plan Study $200,000
Totals $41,000 $265,000
In addition, the City Engineer position will be vacant for a portion of the fiscal year, resulting in
savings of approximately $45,000. These budget savings are partially offset by $125,000 of
additional contract building services in the Building Services budget, due to the increase in permits
pulled for new residential construction noted above. Note these expenditure savings are offset by an
increased amount of building permit revenue, as noted in the licenses and permits section above, and
by a lower amount of revenues collected for development related services, as noted in the Charges for
Services section above.
Revised Budget Estimate: Net Decrease $226,000
Capital Projects
(Represents approximately 28% of the budgeted General Fund Expenditures)
The City is projecting to have either lower than anticipated costs or carryovers to Fiscal Year 2004-05
on the General Fund portion of sixof its capital projects for Fiscal Year 2003-04, as noted below:
Amount of Amount Estimated to
Name of Capital Project Projected be Deferred Until
Budget Savings Fiscal Year 2004-2005
Sidewalk Reconstruction -
Amador Valley Blvd and Dublin Blvd $20,000
Freeway Underpass Art $11,000
Village Parkway/Lewis Intersection Improvements $23,000
Cemetery Planning Study $25,000
1580 Fallon Interchange Improvements $150,000
Downtown Improvement Implementation $131,451
San Ramon Road Banner Poles $7,000
Total Projected Savings $54,000 $313,451
Revised Budget Estimate: Net Decrease $367,451
In summary, Staff's proposed changes to its preliminary revised expenditure estimate for the General Fund
for Fiscal Year 2003-04 is approximately $420,451 (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 $1,794,633
b. Senior Center Van $ 50,000
c. CTV Studio Remodel $ 74,660
d. Emerald Glen Fire Station $ 237,000
e. Downtown/Open Space $ 260,016
f. Capital Project Carryovers $ 603,514
$3,019,823
In addition to the use of reserves identified above, as part of the acceptance of the City's annual
Comprehensive Annual Financial Report, additional monies were set aside as a reserve for construction of
the new senior center, which resulted in an additional $656,614 of reserves being available in Fiscal Year
2003-04 for the funding of the senior center project. It will be necessary for the City Council to approve the
use of the reserves for expenditures incurred in Fiscal Year 2003-04.
The City also has incurred costs for Fire Stations 17 and 18 in Fiscal Year 2003-04 that Staff had originally
projected would be expended in Fiscal Year 2002-03. With respect to Fire Station 17, an additional
appropriation of $778,699 from the Designated Fire Station Construction Reserve in the General Fund will
be required. A budget transfer of $68,294 from the General Fund to the Fire Impact Fee Fund in the
Approved Budget for Fiscal Year 2003-04 is also necessary.
Staff is also requesting that the City Council authorize a loan in the amount of $1,819,871 from the
Designated Reserve for Fire Station Construction in the General Fund to the Fire Impact Fee Fund. A loan
from this reserve was anticipated in the development of the C~ for this project.
With respect to Fire Station 18 the City has incurred approximately $90,000 in Fiscal Year 2003-04, which
the owner of Dublin Ranch will be required to pay and therefore will be offset by additional revenue. It is
important to note that the City and the owner of Dublin Ranch have not concluded negotiations over the final
costs for Fire Station 18. The outcome of those negotiations could result in the City's General Fund share for
Fire Stations to increase, which would result in the reduction of the loan repayment from future Fire Impact
Fees to the General Fund.
GENERAL FUND REVENUE AND EXPENDITURE IMPACT ON RESERVES
Revenue
2003-04 General Fund Revenue Estimate in Adopted Budget $ 37,600,328
Approved Revenue Reductions Subsequent to Budget Adoption (456,000)
Appropriation from Reserves for Capital Projects 3,019,823
Additional Required Reserve for Emerald Glen Fire Station 1,819,871
Additional Available Reserve for Senior Center Project 664,875
Loan to Fire Impact Fee Fund for Fire Station (1,819,871)
Preliminary Estimated Increase in Revenues 427,000
Operating Transfers In 22,350
Total Revised Forecast of'General Fund Revenues $ 41,278,376
Appropriations:
2003-04 General Fund Appropriations in Adopted Budget $ 39,795,950
Approved Appropriations subsequent to budget adoption $ 803,819
Preliminary Estimated Reductions in General Fund Expenditures (420,451)
Other Operating Transfers Out
Total Revised General Fund Appropriations $ 40,179,318
Estimated Revenues in Excess of Appropriations $1,099,058
Less Anticipated Carryover to Fiscal Year 2004-05 (578,451)
Net Estimated General Fund Surplus 520,607
REVENUE ESTIMATES UPDATE - OTHER FUNDS
Traffic Impact Fee and Public Facility Fee Revenue collections are expected to be $1,596,000 and $590,000
under budget respectively due to delays that have occurred within new commercial development that was
originally anticipated to occur during Fiscal Year 2003-04. In addition, a budget transfer of
Intergovernmental Revenues is proposed to be made between the ISTEA and State Transportation
Improvement Program (STIP) Funds to reflect the fact that the source of grant funds for the Tassajara Road
Interchange project is actually being received from the State instead of the Federal government as originally
anticipated in the Fiscal Year 2003-04 budget.
REVISIONS TO EXPENDITURE ESTIMATES - OTHER FUNDS
The capital projects on the following page anticipate being under budget by approximately $2,163,000 due to
savings realized and project delays on the following projects:
Amount Estimated to
Amount of Estimated be Deferred Until Fiscal
Funding Source Name of Project Project Savings Year 2004-2005
Gas Tax Fund Annual Slurry Seal $152,000
Project
ISTEA Downtown Improvement $709,764
Implementation
Public Facility Fees Emerald Glen Park $75,000
Traffic Impact Fees Scarlett/Iron Horse Trail $140,000
Extension
Traffic Impact Fees Dougherty Road - $100,000
Houston Place to 1580
Traffic Impact Fees I580/Fallon Interchange $1,696,000
Totals $227,000 $2,645,764
In addition, the copier at the Shannon Center will need to be replaced at an estimated 'cost of $12,000. The
copier has provided over one million copies to the Center and has exceeded its recommended useful life as
established by the manufacturer of the machine. This item was not included as part of the original adopted
budget for the Equipment Replacement Internal Service Fund.
Expenditures for the Fire Fee Study Update Capital Project in the Fire Impact Fee Fund is expected to exceed
its budget by approximately $2,000 due to higher than anticipated costs to be incurred in order to complete
this project. In addition, the capital improvement projects for Fire Stations 17 and 18 will need budget
adjustments as previously discussed above.
FISCAL YEAR 2003-04 CONCLUSION
As indicated above, the City's estimated General Fund net surplus, based upon preliminary mid year
projections, is $520,607. Based upon the City's Vehicle License receipts to date, it is anticipated that the
maximum additional loss in Vehicle License Fees for the balance of the Fiscal Year would be and additional
$439,000 if the City did not receive full backfill payments from the State. Therefore, Staff projects that the
City will have adequate funds available to offset that loss if it occurs.
Staff has also prepared proposed budget changes to account only for events that are likely to occur during
Fiscal Year 2003-04, as summarized below:
a. An increase in Legal Development Related Professional Services Expenditures of $163,000, to be
offset by an additional $204,000 of Zoning and Subdivision fees, to reflect additional work performed
to date by the Legal Division on development related items.
b. An increase in the Building and Safety budget of $125,000 to fund additional contract building
services in the Building Division due to the increase in number of permits pulled for new residential
construction.
c. An increase in the Aquatics Budget by $15,000 due to filter repairs needed for the pool which were
not anticipated as part of the original adopted budget.
d. An increase in the Cemetery Division budget by $11,000 due to increased water costs and higher than
expected costs for contract maintenance services.
e. An increase in the Equipment Replacement Internal Service Fund budget by $12,000 to be used to
fund the replacement of the copier at the Shannon Center.
f. An increase in the Fire Fee Study Update Capital Project budget by $2,000 to fund additional costs
anticipated to be incurred in order to complete the project.
g. An increase in the capital improvement budgets for Fire Stations 17 and 18 by $778,699 and $90,000
to fund costs incurred in Fiscal Year 2003-04 which were originally anticipated to occur during Fiscal
Year 2002-03. Staff also proposes a budget transfer of $68,294 between the General Fund and Fire
Impact Fee Fund for Fire Station 17. These additional costs will be offset by approximately $90,000
of additional fire impact fee revenues expected to be received by the end of the Fiscal Year.
h. A budget transfer of Intergovernmental Revenues of $715,298 between the ISTEA and State
Transportation Improvement Program (STP) Funds to reflect that the grant funds for the Tassajara
Road Interchange project is actually being received from the State instead of the Federal government.
In addition Staff also proposes that Council authorize the use of $664,875 from General Fund Senior Center
Reserves to pay for the current Fiscal Year portion of Senior Center project. Lastly, Staff recommends that
Council authorize a Loan in the amount of $1,819,271 from the General Fund Emerald Glen Fire Station
Reserves to pay for the current Fiscal Year portion of the Emerald Glen Fire Station project.
PREVIEW FOR FISCAL YEAR 2004-05
Generally, a preview of the potential budget impacts for the upcoming fiscal year is presented to the City
Council at its budget study session in April. Given the precarious State budget, Staff has provided a glimpse
of what the City may face in Fiscal Year 2004-05. It is important to recognize that this information is
based npon very preliminary information obtained by Staff.
General Fund Project Carryovers
It is anticipated at this time that approximately $578,451 will need to be carded over the Fiscal Year 2004-05
for projects started, but not completed, in Fiscal Year 2003-04.
State BUdget Impacts
At this time, the Governor has repealed the increase in the VLF, which was previously scheduled to take
place in October. Unless the State does pass legislation that provides funding to reestablish the payment of
the backfill portion of the fee, the City could realize a total loss of approximately $1.5 million in VLF for
Fiscal Year 2004-05.
In addition~ it should be noted that the Governor has proposed, as part of the State's budget for Fiscal Year
2004-05, to increase the amount of the Educational Revenue Augmentation Fund (ERAF) shift of property
taxes from cities to schools. If this legislation is passed in its current form, it is estimated that there would be
a PERMANENT additional reduction to the City of approximately $300,000 in property taxes on an annual
basis beginning in Fiscal Year 2004-05.
Lastly, if California voters fail to approve the deficit reduction bonds included on the March 2, 2004 ballot,
the City could face additional revenue reductions from the State. Staff has not received any information to
date on what, if any, reductions might occur if the bonds do not pass.
Preliminar~ Forecast
In. the City's adopted Five-Year Capital Improvement Program (CIP), Staff projected that approximately $3.8
million would be needed from the General Fund to finance projects scheduled for Fiscal Year 2004-05. Of
this total, approximately $1.7 million dollars is earmarked for the Senior Center and is funded by a reserve
previously established by Council. Approximately $500,000 is allotted to fund improvements to the Fallon
Road Interchange (to be reimbursed by the City of Pleasanton). The remaining General Fund portion of the
CIP budget for Fiscal Year 2004-05 is approximately $1.6 million. If approved by Council, this amount
could be deferred, since no contract commitments are currently in place for any of these projects.
If all of the impacts identified above do come to pass, and if the economy does not materially change, Staff
projects that there may be insufficient revenues to finance all the capital projects proposed for Fiscal Year
2004-05 in the City's CIP. If this forecast does become reality, the City will either need to defer certain
projects, consider the utilization of reserves or possibly even reduction of services.
Recommendation
Staff recommends that the City Council (1) Receive the Report (2) Approve the Budget Change Forms (3)
Authorize the use of an additional $664,875 from General Fund Senior Center Reserves to pay for the current
Fiscal Year portion of the Senior Center project and 4) Authorize a Loan in the amount of $1,819,871 from
General Fund Emerald Glen Fire Station Reserves to' pay for the current Fiscal Year portion of the Emerald
Glen Fire Station project.
City of Dublin 2003-2004 YTD Revenues and Budget Comparison
For the Period Ending December 31, 2003
..................... 1 ................................................
Total General Fund Revenues
Property Taxes
Sales Taxes
W FY 2003/04
Real Property Transfer Tax i::i::i::ili FY 2002/03
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits 78~'
Interest and Rentals
Intergovernmental from State 29o/o420/0
Charges for Services
Fines and Forfeitures ~ ,3o/8oo/o
Other Revenues
0% 30% 60% 90% 120% 150%
50% of Year Complete
FY 2003/04 FY 2003/04 % of FY 2002~03 % of Total for
Budget YTD Actual Budget YTD Actual FY 2002~03
Property Taxes 11,274,729 5,942,512 53% 4,759,016 47%
Sales Taxes 13,036,000 6,125,573 47% 5,935,950 45%
Real Property Transfer Tax 334,000 251,112 75% 130,314 34%
Transient Occupancy Taxes 719,550 283,702 39% 321,920 45%
Franchise Taxes 1,414,237 373,485 26% 359,961 26%
LicenseS and Permits 2,025,003 1,575,791 78% 1,458,853 60%
Interest and Rentals 897,550 382,761 43% 811,089 50%
Intergovernmental 1,916,900 546,441 29% 940,408 42%
Charges for Services 4,868,788 1,819,391 37% 1,838,488 39%
Fines and Forfeitures 106,500 40,029 38% 45,011 32%
Other Revenues 551,071 93,903 17% 106,692 26%
Total General Fund Revenues . 37,144,328 17,434,700 47% _16,707,702 45%
1=1 4
ATTACHMENT 1
City of Dublin 2003-2004 YTD Expenses and Budget Comparison
For the Period Ending December 31, 2003
Total General Fund
Expenses ........................................... :::: ...... i! iiii 39%
~39%
General Government iiii!~iii!~ii~ii 44%
Police ~ 6%
Fire ~l30°/° '
1
Other Public S~ety ~ ........ 5 n ~,% · FY 2003/04
Transportation ~ %
Health and Welfare ~~7~°/°
39%
Culture & Community i iiiiiii 43%
Services
Community 141%
Development i::ii 42%
Capital Improv. 7%
0% 20% 40% 60% 80% 100% 120%
50% of Year Complete
2003/04 2003/04 % of FY 2002~03 % of Total for
Budget YTD Actual Budget, YTD Actual FY 2002/03
General Government 4,871,541 1,876,131 39% 1,894,099 44%
Police 8,604,571 503,577 6% 438,020 6%
Fire 7,159,187 2,130,528 30% 1,354,434 27%
Other Public Safety 351,758 29,493 8% 41,729 15%
Transportation 1,607,102 594,832 37% 471,961 35%
Health and Welfare 47,941 36,393 76% 21,429 53%
Culture and Community Services 5,329,601 2,095,617 39% 2,001,475 43%
Community Development 6,498,591 2,635,192 41% 2,260,427 42%
Capital Improvement Projects 6,125,677 1,032,460 17% 4,385,314 114%
Total General Fund Expenses 40,595,969 10,934,223 27% 12,868,888 39%
General Fund Operating Expenses 34,470,292 9,901,763 29% 8,483,574 29%
ATTACHMENT 2
Date Printed: 2/2D/2004 42:00 PM
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF DECEMBER 2003
Prepared by
The Finance Department
January 6, 2004
ATTACHMENT 3
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Dec2003
GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 - A _ S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMO~ND~M ONLY---
FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR
ASSETS
CASH (43,807,718) 3,841 588 54t.042 32,537.544 138.589 (6,748,955) (23,798.694)
CASH WITH FISCAL AGENT 172.312 172,312 171.289
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST 97,326.992 97,326.992 91.334,331
RECEIVABLES: TAXES
ACCOUNTS 232.566 37,776 270,342 500,688
INTEREST 200,330 200.330 642,481
ASSESSMENTS
DUE FROM OTHERS 308,720 308,720
INVENTORY AT COST
~REPAID ITEMS 14~232 14 232 7,536
FIXED ASSETS
AMOUNT TO BE PROVIDED 1,447,500 1,447.500 1.553.500
TOTAL ASSETS 54,275.122 3.879,364 541.042 32,537,544 1,758 401 92.991 473 70,31t.13]
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL (922,710) (922,710) (980.838)
DEPOSITS FOR AB1600 FEES (33,155) (6.822,666) (6 855,821) {624,365)
DEPOSITS OTHERS (1.208,678) (1 208,678) (911.258)
PAYABLES: ACCOUNTS (847,417) (315,458) (458,208) (1.621.083) (256.096)
INTEREST
PAYROLL (536,139) (536,139) (408,466)
DUE TO OTHERS (127,416) (308,720) (436,136) (17,932)
DEFERRED REVENUE (127,768) (127,768) (127,768)
DEBT INSTRUMENTS ~AYABLE (t,565,000) (1.565,000) 1,671,000)
TOTAL LIABILITIES (3,803 282) (624,179) (7,280.874) (1.565,000) (13.273,335) 4,997,723)
FUND BALANCES (50~,471,840) (3,255,185) (541,042) 28,256.670) (193,401) (79.718,138) (65.313,408)
TOTAL FUND E (50,471,840) (3.255~185) (541,042) 25,256,670) (193,401) (79.718,138) (65.313.408)
TOTAL LIABILITIES/EQUITY 54,275,122) (2,879,364) (541,042) 32.537,544) (1.758,401) (92,991,473) 70.311,131)
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Dec2003
INTERNAL ENTERPRISE ~IXED ASSETS GENERAL LONG T 0 - A _ S
SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM---
:UNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR
ASSETS
CASH 7,413.871 7.413,871 6,660,132
CASH WITH FISCAL AGENT
AMOUNT HELD ~N ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROV OTHERS
INVENTORY AT COST
PREPAID ITEMS
FI'XED ASSETS 47.265,623 19,466.456 66.732.089 48.676,346
AMOUNT' TO BE PROVIDED 68,709.959 68,709,959 50,675,589
TOTAL ASSETS 54,679 505 19.466.456 68.709.959 142.855,920 106.012,068
LIABILITIES/FUNb EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR ABZ600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS (17.215) (17,215)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (68,709,959) (68,709,959) (50.675,589)
TOTAL _IABILITIES (17,215) (68,709,959) (68,727,174) (50.'675,589)
FUND BALANCES (54.662,290) (19 466,456) (74,128,746) (55,336,478)
TOTAL FUND E (54,662,290) (19 466,456) (74,128,745) (55.336,478)
TOTAL LIABILITIES/EQUITY (54,679,505) (19.466.456) (68,709.959) 142,855,920~(106,012.068)
qEVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 12/31/2003
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
3UDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
*******REVENUES*******
PROPERTY TAXES 11.274.729.00 5,942 512.05 5,332,216.95 4.759,015.58 10,039,542.89 (5,280,527.31)
SALES TAX 12.036.000.00 6,125 573.15 6,910.426~85 5.935,949.56 13.193.407.37 (7.257.457.81)
REAL PROPERTY TRANSFER TAX 234.000.00 251 111.76 82.888.24 130,314.43 379,088.81 (248,774.38)
HOTEL TRANSIENT OCCUPANCY TAX 719.550.00 283 701.74 435.848.26 321,920.47 717.083.07 (295.162.60)
FRANCHISE TAXES 1.414.237.00 373 485.08 1,040,751.92 359,961.21 1.,394.953.26 (1,034.992.05)
LICENSES & PERMITS 2.025,003.00 1,575 791.47 449.211.53 1 458.853.41 2.421.884.99 (963,031.58)
FINES & FORFEITURES 106.500.00 40 028.89 66.471.11 45,010.98 139.614.86 (94,603.88)
USE/MONEY & PROP-INTEREST 751.710.00 318548.44 433.161.56 760.472.72 1.487.493.37 (727.020.65)
USE/MONEY & ~ROP-RENTALS t45.840.00 64 213.34 81.626.66 50.616.25 139.019.25 (88.403.00)
INTERGOVERNMENTAL 1.916,900.00 546 440.71 1.370.459.29 940.408.25 2.234.178.93 (1.293.770.68)
CHARGES FOR SERVICES 4,868,788.00 1,819.391.35 3.049,396.65 1,838.488.42 4,760,254.62 (2,921,766.20)
OTHER SOURCES OF REVENUE 55~.071.00 93.903.39 457.~67~.61 106.691.88 410,713.57 (304,021.69)
TOTAL REVENUE 37,144.328.00 17.434.701.37 19.709.626.63 16.707.703.16 37,317.234.99 (20.609.531.83)
**************************
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 248.650.00 79,206.95 169.443.05 102 208.34 196.233.20 (94,024.86)
CITY MANAGER 823.204.00 366 105.49 457 098.51 340 333.69 740.856.35 (400.522.66)
CENTRAL SERVICES 369.960.00 151 290.34 218 669.66 128 116.25 292.316.29 (164.200.04)
CITY ATTORNEY 646,047.00 240 567.70 405 479.30 413 187.64 850.821,87 (437.634.23)
ADMIN SERVICES 1,360.195.00 550,845.83 809 349.17 452 960.80 982.221.59 (529.260.79)
BUILDING MANAGEMENT 717.595.00 284,236.32 433 358.68 291 620.73 757,323.39 (465,702,66)
INSURANCE COST CENTER 430.405.00 202.575.98 227 829.02 164 048.86 362,022.64 (197,973.78)
ELECTIONS COST CENTER 2.800.00 1.302.41 I 497.59 1.622.50 10.918.84 (9.296:34)
NON-DEPARTMENTAL 272.685.00 272 685.00 146.605.38 (146.605.38)
ACTIVITY TOTAL 4.871.541.00 I 876.131.02 2,995 409.98 1,894,098.81 4,339.319.55 (2,445.220.74)
PUBLIC SAFETY
POLICE 8.604.571.00 503.577.10 8.100.993.90 438.020.03 7.947,078.88 (7.509.058.85)
CROSSING GUARDS 71.462.00 14.716.75 56.745.25 18,139.25 61,878.80 (43.739.55)
ANIMAL CONTROL 197.194.00 (9,547.00) 206.741.00 164.564.93 (164.564.93)
TRAFFIC SIGNALS & STREET LIGHTIN 11,150.00 188.26 10.961.64
DISASTER PREPAREDNESS 71,952.00 24.135.14 47.816.86 23,589.75 59,237.80 (35,648.05)
FIRE SERVICES 7,159.187.00 2.130.527.90 5.028.659.10 1,354 434.11 ~ 951.374.82 (3,596,940.71)
ACTIVITY TOTAL 16.115,516.00 2.663.598.25 13.451.917.75 1.834 182.14 13.184.135.23 (11.349.952.09)
TRANSPORTATION
PUBLIC WORKS 694.417.00 303.674.58 390.742.42 275 567.18 632.481.15 (356,913.97)
STREET MAINTENANCE 10 004.00 312.50 9,691.50 250.43 9.868.95 (9,618.52)
STREET SWEEPING 145 676.00 42.043.33 103.632.67 38,744.60 122.569.70 (83.825.10)
STREET TREE MAINTENANCE 118 188.00 44.668.28 73.519.72 17,883.91 76.662.73 (58,778.82)
STREET .ANDSCAPING MAINTENAN 638 817.00 204.133.32 434.683.68 139,514.86 495.105.08 (355,590.22)
ACTIVITY TOTAL 1.607 102.00 594.832.01 1.012.269.99 471,960.98 1,336.687.61 (864,726.63)
HEALTH & WELFARE
THE CITY OF DUBLIN 'STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 12/31/2003
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE-
WASTE MANAGEMENT 8.691.00 8,691.00 3.551.78 1,798.28 1,753.50
CHILD CARE 18.500.00 18,500.00 6.165.13 15,000.00 (8,834.87)
SOCIAL SERVICES 1.000.00 1,000.00 6.000.00 6.000.00
HOUSING PROGRAMS 19.750.00 16.893.18 2,856.82 5.711.74 17,501.74 (11,790.00)
ACTIVITY TOTAL 47,941.00 36.393.18 111547.82 21.428.65 40.300.02 (18,871.37)
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 553.662.00 130.387.67 423,274.23 119 829.50 485.281.21 (365,451.71)
CULTURAL ACTIVITIES 128.088.00 78.010.84 60,077.16 75 933.90 121,198.29 (45,264.39)
HERITAGE CENTER 114.188.00 49.527.86 64 660.14 40 227.34 92,803.62 (52.576.28)
DUBLIN CEMETERY 43 858.00 21.786.86 22.071.14 11 186.91 31,341.84 (20,154.93)
PARK MAINTENANCE 1.457 804.00 492.576.31 965.227.69 487 804.09 1,200.226.46 (712,422.37)
COMMUNITY TV 64 634.00 57.421.18 7.212.82 69 422.37 76.233.17 (6,810.80)
RECREATION ADMIN 541 383.00 236.091.20 305 291.80 208 545.94 452.646.88 (244.100.94)
~LAYGROUNDS 281 699.00 108.529.87 173 169.13 104 550.00 230,269.67 (125,719.67)
SHANNON CENTER 291 253.00 124.090.25 167 162.75 117 295.01 266.989.58 (149,694.57)
PRESCHOOL 82 383.00 33,193.t5 49 189.85 35.271.63 74.354.14 (39.082.51)
TEENS PROGRAM 111 392.00 36,978.12 74 413.88 43,382.64 100.141.63 (56.758.99)
ADULT SPORTS 105 034.00 48,187.16 56 846,84 44.777.36 97.087.23 (52,309.87)
YOUTH SPORTS 113 604.00 42 557.77 71 046.23 37.630.01 93.209.36 (55,579.35)
COMMUNITY GYM 41 560.00 10 355.22 31 204.78 16,121.90 46,605.98 (30,484.08)
EMERALD GLEN ACTIVITY CENTER 4.039.00 4 039.00
SPECIAL EVENTS 361.928.00 168~887.01 193 040.99 174.276.88 356.425.65 (182.148.77)
SENIOR CENTE7 219.073.00 90.403.60 128 669.40 77.043.85 183.985.64 (106,941.79)
RECREATION INSTRUCTION 190.418.00 89.687.01 100 730.99 75,437.57 153.581.45 (78.t43.88)
AQUATICS 364,122.00 164,826.14 199 295.86 167,958.34 338.055.61 (170,097.27)
PARKS/FACILITIES MANAGEMENT 249,479.00 112,119.31 137 359.69 94.779.93 21].125.63 (116,345.70)
ACTIVITY TOTAL 5.329.601.00 2,095.616.53 3.233 984.47 2,00t.475.17 4.611.563.04 (2,610.087.87)
COMMUNITY DEVELOPMENT
PLANNING 2.451,689.00 922.438.65 1,529.250.35 728.976.65 1,767.026.63 (1.03~.049.98)
BUILDING SAFETY 1,836,288.00 737.200.75 1,099.087.25 589.530.55 1,467.363.47 (877.832.92)
ENGINEERING 1,900,705.00 798.674.24 1,102,030.76 779.180.21 1.865.709.85 (1.086,529.64)
ECONOMIC DEVELOPMENT 309.909.00 176.878.16 133.030.84 162.739.29 278.983.20 (116.243.91)
ACTIVITY TOTAL 6,498,591.00 2,635.t91.80 3.863.399.20 2.260.426.70 5.379,083.15 (3.118.656.45)
CAPITAL IMPROVEMENT PROJECTS
GENEFU~L CIP PROJECTS 1,155.736.00 69.224.60 1.086.511.40 4.066,240.88 2.258,752.04 1.807.488.84
COMMUNITY IMPROVEMENTS 989,845.00 244'.367.55 745.477.45 153.503.78 442,108.93 (288,605.15)
PARKS 2,869.563.00 418.686.86 2.450,876.14 105.059.88 669,566.48 (564,506.60)
STREET CONSTRC/IMPROVEMENTS 1,110,533.00 200.181.09 810.351.91 60,509.07 464,048.31 (403,539.24)
ACTIVITY TOTAL 6.125,677.00 1.032.460.10 5.093.216.90 4.385,313.61 3,834,475.76 550.837.85
TOTAL EXPENDITURES 40.595,969.00 10.934.222.89 '29.661,746.11 12.868,887.06 32.725,564.26 (19,856,677.30)
EXCESS REVENUE (EXPENDITURES) (3.451.641.00) 6.500.478.48 (9.952,119.48) 3.838,816.10 4.591,670.63 (752.854.53)
TRANSFERS IN FROM OTHER FUNDS 18,560.15 18.560.15)
TRANSFERS OUT FROM OTHER FUNDS (20.00) 20.00
REVENUES VERSOS EXPENDITURES
FOR'THE PERIOD
07/01/2003 THROUGH 12/31/2003
SPECIAL REVENUE FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
************************
PROPERTY TAXES 108.192.00 53.194.09 54.997.91 103.107.58 51.268.30 51.839.28
SALES TAX/OTHER TAXES 333,000.00 123.188.61 209.811.39 380.t99.02 136.466.71 243.732.31
FINES & FORFEITURES 149,000.00 54.480.66 94,519.34 134.670.06 50,856.86 83.813.20
USES/MONEY & PROPERTY 36 949.00 14.494.78 22,454.22 87.896.70 46,054.73 41.841.'97
INTERGOVERNMENTAL FROM STATE 1.287.011.00 1.711,369~12 (424,358.12) 8.768,700.98 3.338 499.77 5.430.201.21
INTERGOVERNMENTAL FROM COUNTY 282.829.00 26.046.50 256,782.50 276.556.50 78.008.25 t98.548.25
INTERGOVERNMENTAL FROM FEDERAL t,672.692.00 31.579.65 1.641.112.36 133,137.78 60.723.72 72.414.06
CHARGES FOR SERVICES 981.937.00 497.885.40 484.051~60 920.648.29 458.063.84 462,584.45
OTHER SOURCES OF REVENUE t02.000.00 102.000.00 251.582.51 251.582.5t
TOTAL REVENUE 4.953.610.00 2.512,238:8t 2.441.371.19 11,056.499.42 4.219.942.18 6,836.557.24
**************************
PUBLIC SAFETY:
POLICE t65.48t.00 13.917.15 151.563.85 210 229.18 38.455.39 171 773.79
TRAFFIC SIGNALS & STREET LTG 189.500.00 51.963.68 137.536.32 137,632.61 42.346.72 95 285.89
DISASTER PREPAREDNESS 7.000.00 2.175,00 4.~25.00 7.258.78 7.258.78
FIRE SERVICES 250,579.00 27.068.67 223,510.33 204.076.36 51.160.25 152.916.11
ACTIVITY TOTAL 612.560.00 95.124.50 517.435.50 559.196.93 131,962.36 427.234.57
TRANSPORTATION:
STREET MAINTENANCE 237 579.00 58,908.43 178,670.57 238.621.60 49,096.27 t89.525.33
STREET SWEEPING
ACTIVITY TOTAL 237 579.00 58.908.43 178 670.57 238.621.60 49,096.27 189.525.23
HEALTH & WELFARE:
~ASTE qANAGEMENT I 295,325.00 5.400.37 1,289,924.63 1.063.584.65 517.78 1.063.066.87
SOCIAL SERVICES AA.935.00 18.695.07 26 239.93 28,427.00 5 6t6.17 22,8t0:83
HOUSING PROGRAMS
ACTIVITY TOTAL 1,340.260.00 24,095.44 I 316.164.56 1.092.011.65 6.133.95 1.085.877.70
COMMUNITY DEVELOPMENT.
ENGINEERING 6.000.00 7,428.00 (1,428.00) 6,000.00 364.50 5.635.50
ACTIVITY TOTAL 6,000.00 7,428.00 (1.428.00) 6,000.00 364.50 5.635.50
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 60.000.00 50.000.00
COMMUNITY PROJECTS 770,167.00 770.167.00 36.200.00 36,200.00
PARKS 341.928.00 34t.928.00 426,095.00 426.095.00
STREET CONSTRUCTION/IMPROVEMENT 1.879.612.00 1.533 830.13 345.781.87 8,733,595.34 1.555.173.81 7,178,421.53
ACTIVITY TOTAL 3.041.707.00 1,533.830.13 1.507,876.87 9,195 89~.34 1.555,173.81 7 640 716.53
T 0 - A _ EXPENDITURES 5.238,106.00 1,719.386.80 3,518,719.50 11,091,720.52 1.742,730.89 9.348,989.63
EXCESS <REVENUE>EXPENDITURE 284.496.00 (792,852.31) 1,077.348.31 35.221.10 (2.477.211.29) 2,512,432.39
TRANSFER tN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 18.560.t5 849.931.16 (831.371.01)
EXCESS <REVENUE> EXPENDITURE 284.496.00 (792.852.31) 1,077,348.31 53.781.25 (1,627,280.13) 1.681.061.38
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUE VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 12/31/2003
CAPITAL IMPROVEMENT FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL , VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUE********
USES/MONEY & PROP-INTEREST 759,951.00 234,346.93 525,604.07 690,013.13 1,120,018.43 (430,005.30)
OTHER SOURCES OF REVENUE 19,079,000.00 6,822 666.42 12,256,333.58 10,195,565.15 (10,195,565.15)
TOTAL REVENUE: 19,838,951.00 7,057,013.35 12,781,937.65 690,013.13 11,315,583.58 (10,625,570.45)
************************
GENERAL GOVERNMENT ACTIVITIES:
CITY ATTORNEY 28,800.00 2,395.44 26,404.56 3,964.92 23,902.29 (19,937.37)
ACTIVITY TOTAL 28,800.00 2,395.44 26,404.56 3,964.92 23,902.29 (19,937.37)
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 758,876.00 294,720.63 464,155.37 53,540.74 219,771.73 (166,230.99)
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING 2,561.31 2,561.31
ACTIVITY TOTAL 2,561.31 2,561.31
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 117,894.00 1,360,709.02 (1,242,815.02) 1,466,895.97 10,315,973.90 (8,849,077.93)
COMMUNITY IMPROVEMENTS
PARKS 5,513,453.00 2,292,038.10 3,221,414.90 879,595.65 1,274,709.53 (395,113.88)
STREET CONSTRUCTION/IMPROVEME: 17,400,716.00 1,619,127.43 15,781,588.57 4,673,599.50 9,091,559.57 (4,417,960.07)
ACTIVITY TOTAL 23,032,063.00 5,271,874.55 17,760,188.45 7,020,091.12 20,682,243.00 (13,662,151.88)
TO TA L EXPENDITURES 23,819,739.00 5,568,990.62 18,250,748.38 7,080,158.09 20,925,917.02 (13,845,758.93)
EXCESS <REVENUE>EXPENDITURE 3,980,788.00 (1,488,022.73) 5,468,810.73 6,390,144.96 9,610,333.44 (3,220,188.48)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 3,980,788.00 (1,488,022.73) 5,468,810.73 6,390,144.96 9,610,333.44 (3,220,188.48)
THE CITY OF DUBLIN STATENENT SHOWING
REVENUES VERSUS EXPENDITURES
FORTHE PER'rOD
07/01/2003 THROUGH 12/31/2003
SPECIAL ASSESSMENT FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
***********************
SPECIAL BENEFITS ASSESSMENTS 630.482.00 297,924.67 332.557.33 501.425.07 247.790,91 253.634.16
USES/MONEY & PROP-INTEREST 13.704.00 1,899.06 11.804.94 14.049.83 6.787.02 7.262'.81
OTHER SOURCES OF REVENUE 4.000.00 100.00 3.900.00 10,598.97 5.070.54 5.528,43
TOTAL REVENUE 648.186.00 299.923.73 348.262.27 526,073.87 259.648.47 266.~25.40
*******EXPENDITURES*******
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 269.686.00 69 423.91 200.262.09 204 778.18 75.580.56 129.197.62
ACTIVITY TOTAL 269.686.00 69.423.91 200.262.09 204 778.18 75.580.56 129,197.62
TRANSPORTATION
PUBLIC WORKS 1.791.00 600.37 1,190.63 1,393.46 681.-95 711.51
STREET TREE MAINTENANCE 29,768.00 1.611.72 28,156.28 9,437.02 4~904.06 '4 532.96
STREET _ANDSCAPE ~AI~TENANCE 355,333.00 98.427.83 256,905.17 264,802.70 t20.177.22 144 625.48
ACTIVITY TOTAL 386.892.00 100.639.92 286,252.08 275.633.18 125.763,23 149.869.95
COMMUNITY DEVELOPMENT
ENGINEERING 15 250.00 8,105.50 7,144.50 14.565.20 8,709.56 5.855.64
ACTIVITY TOTAL 15 250.00 8.105.50 7,144.50 14.565,20 8.709.56 5.855.64
CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT 70 881.00' 70 881.00 56.000.00 56.000.00
ACTIVITY TOTAL 70 881.00 70 881.00 56.000.00 56.000.00
= 0 - A _ EXPENDITURES 742.709.00 178.t69.33 564 539.67 550.976.56 210 053.35 340.923.21
EXCESS <REVENUE>EXPENDITURE 94.523.00 (121,754.40') 2t6,277.40 24.902.69 (49 595,12) 74.497.81
EXCESS <REVENUE>EXPENDITURE 94.523.00 (121,754.40) 216,277.40 24.902.69 49.595,12) 74.497.81
THE CITY OF DUBLIN STATEMENT SHOWING / .(..2I:~''~
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 12/31/2003
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
***********************
SPECIAL ASSESSMENTS 116,856.56 (116,856.56) 238,107.33 118.659.03 119.448.30
USES/MONEY & PROP-INTEREST 354.01 (354.01) 5,009.96 1.898.30 3',111.66
TOTAL REVENUE 117 210.57 (117,210.57) 243,117.29 120.557.33 122,559.96
**************************
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL -173.508.25 (173.508.25) 233 949.42 171 227.71 62,721 71
ACTIVITY TOTAL 173.508.25 (173,508.25) 233,949.42 171 227.71 62,721.71
PUBLIC SAFETY
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PRO3ECT$
T 0 T A L EXPENDITURES 173,508.25 (173,5'08.25) 233,949.42 171.227.71 62.721.71
EXCESS <REVENUE>EXPENDITURE 56,297.68 (56,297.68) (9,167.87) 50.670.38 (59,838.25)
EXCESS <REVENUE>EXPENDITURE 56.297.68 (56.297.68) (9,167.87) 50,670.38 (59,838.25)
THE CITY OF DUBLIN STATEMENT SHOWING /~'-~..~'"~3-~'~
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2003 THROUGH 12/31/2003
INTERNAL SERVICE =UNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T~D~ VARIANCE
************************
USES/MONEY & PROP-INTEREST 145,333.00 33.799.29 111,533.71 209,125.89 111.500.94 97,624.95
CHARGES FOR SERVICES 1,590,277.00 652,522.60 937 744.40 1.326,.711,49 660,917,90 665.792.59
OTHER SOURCES OF REVENUE 21.000,00 21 000,00 12.629,422.52 13.560.00 12.615,862,53
TOTAL REVENUE 1,756.610.00 686,331.89 1.070.278.11 14.165,259.91 785.978.84 13.379,281.07
*******~XPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 1.484.152,00 28~.748.91 1,197.403.09 2.344 963.06 426.575.06 1.918,388.00
ACTIVITY TOTAL 1.484.152.00 286.748.91 1.197.403.09 2.344 963.06 426.575.06 1.918 388.00
PUBLIC SAFETY:
FIRE 64,285.00 64.285.00 57.775.63 12.478.21 45,297.42
ACTIVITY TOTAL 64.285.00 64.285.00 57.775.63 12,478.21 45 297.42
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PRO~ZCTS:
T 0 - A _ EXPENDITURES 1,548.437.00 286,748.91 1.261 688.09 2,402,738,69 439 053.27 1,963,685.42
EXCESS <REVENUE>EXPENDITURE (208,173.00) (399,582.98) 191.409198 (1t.762,521,22) (346,925.57)(11,415.595.65)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE (208,173.00) (399.582.98) 191,409,98 (11,762.521.22) (346.925.57)(11,415,595.65)
THE CITY OF DUBLIN STATEME,T SHOWING/'~ ~ ~-
REVENUES VERSUS EXPE,D~TURES
FOR THE PERIOD
07/01/2003 THROUGH 12/31/2003
E N T E R P R I S E ~ U N'D
CURRENT CURRENT PRIOR PRI3R
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
***********************
JSES/MONEY & PROP-INTEREST
TOTAL REVENUE
***************************
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 20.00 20.00 20.00 20,00
FINANCE
ACTIVITY TOTAL 20.00 20,0~ 20,00 20,00
PUBLIC SAFETY
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
- 0 T A _ EXPENDITURES 20.00 20,00 20.00 20.00
EXCESS <REVENUE>EXPENDITURE 20.00 20.00 20,00 20.00
TRANSFERS IN FROM OTHER FUNDS (20.00) (20,00)
TRANSFERS OUT TO OTHER FUNDS .
EXCESS <REVENUE>EXPENDITURE 20,00 20.00 20.00 (20,00)
CITY OF DUBLIN
BUDGET CHANGE FORM
CHANGE FORM #:
New Appropriations (City Council Approval Required): Budget Transfers:
x From Unappropriated Reserves Fund # __ From Budgeted Contingent Reserve (1080-799.000)
From New Revenues x Within Same Department Activity
Between Departments (City Council Approval Required)
Other
Legal Services - Contract Services
Name: ISTEA - Intergovernmental - State 715,298 Name: Reimbursable 163,000
Account: 210-559-003 Account: 001-10300-741-003
Emerald Park Fire Station - Revenue - zoning and Subdivision
Name: Construction Admin 68,294 Name: Fees 204,000
Account: 001-93510-740-081 Account: 001-565-001
Cemetery Division - Contract
Name: Name: Services 11,000
Account: Account: 001-80130-740.000
Name: Name: Aquatic Division - Improvements 15,000
Account: Account: 001-81000-750.050
Name: Name: Building & Safety - Contract Services 125,000
Account: Account: 001-90200-740.000
Equipment Replacement Internal
Name: Name: Service Fund - Equipment ISF 12,000
Account: Account: 830-10000-750-073
State Transportation Improvement
Name: Program - Intergovt from State 715,298
Account: 219-555-016
Name: Emerald Park Fire Station - Building 846,993
Account: 320-93510-750-030
Fallon Fire Station - Machinery &
Name: Equipment 90,000
Account: 320-93511-750-073
REVENUE - Fire Impact Fee Fund ~
Name: Reimbursements General 90,000
Account: 320-570-005
G:Wlid Year ReportsXFY 2003-04\budget change_Lisa.xls 1 of 2 ATTACHMENT 4
CITY OF DUBLIN ?~'~% l~
BUDGET CHANGE FORM
CHANGE FORM #:
New Appropriations (City Cotmcil Approval Required): Budget Transfers:
x From Unappropriated Reserves Fund # __ From Budgeted Contingent Reserve (1080-799.000)
From New Revenues x Within Same Department Activity
Between Departments (City Council Approval Required)
Other
Fire Impact Fee Fund - Fire Fee Study
Name: Name: Update - Contract Service General 2,000
Account: Account: 320-94510-740-000
Total 783,592 Total 2,274,29i
IReason for Budget Change: To reflect budget changes proposed as part of the City's mid year financial report for Fiscal Year
2003-04.
Signature
City Manager: Date:
Signature
Mayor: Date:
Signature
Date:
Posted By: :
Signature
G:Wlid Year ReportsXFV 2003-04\budget change_Lisa, xls 2 of 2 ATTACHMENT 4