HomeMy WebLinkAbout8.4 Mid-Year Budget & Monthly Reports
CITY CLERK
File # D[3]~[Q]-[5J[Q
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: March 21,2006
SUBJECT
Fiscal Year 2005-2006 Mid-Year Budget Report and
December 2005 Monthly Report of Financial Activities
Report Prepared by" Paul S. Rankin, Administrative Services
Director and Fred W Marsh. Finance Manager
ATTACHMENTS:
1
2.
3
YTD Revenues and Budget Comparison
YTD Expenses and Budget Comparison
Financial Statements for the Month of
December 2005
Budget Change Forms
4
RECOMMENDATION (jfi"Il
~ 2.
FINANCIAL STATEMENT
Receive the Report and Staff Presentation
Approve Budget Changes
See Below
DESCRIPTION. Attached is the monthly report of financial activities for December 2005 This
report combines the typical monthly financial statements for December with a more detailed "Mid-Year
Review" It should be noted, that as a separate agenda item for this meeting, Council is also presented
with the monthly financial reports for January 2006.
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 For the
mid-year analysis receipts and expenditures subsequent to December 31, 2005 have also been reviewed in
key areas before identifying a deviation from the adopted budget. Prior year trends have been used to
assess whether the current revenue and expenditures are tracking as expected in the adopted 2005/2006
Budget.
The primary focus of this analysis is on the General Fund Revenue and Expenditures. Significant changes
to the Budget are discussed in more detail.
REVENUE ESTIMATES UPDATE - GENERAL FUND
There are projected deviations where the Revenue is expected to fluctuate both above and below the
adopted Budget. Overall, the cumulative impact is that the General Fund Revenue is currently projected
to exceed the Budget estimate. The following Table summarizes the key adjustments expected to occur in
General Fund Revenue Accounts.
COPY TO:
Page 1 0[6
ITEMNO.~
G:\Mid year Reports\F\ 2005-06\Agenda\midyear reporcDOC
SUMMARY OF PROJECTED CHANGES IN 200512006 BUDGETED REVENUE
PRESENTED BY MAJOR CATEGORY
Property Taxes
Sales Taxes
Taxes Other Than Property/ Sales
(Franchise)
Licenses & Permits
Interest & Rentals
Intergovernmental (VLF)
Charges For Services
Fines & Forfeiture
Other Revenue
NET PROJECTED CHANGE
REVENUE
$453,000
(58,000)
114,000
374,000
(380,000)
477,000
o
o
o
$980,000
The following provides additional analysis about the trends in the major categories. It is not proposed to
adjust the actual revenue budgets as a result of mid-year analysis, for the items outlined above. There is a
small revenue budget change associated with Heritage and Cultural Arts expenses which is discussed later
in the report. The general budget trends are presented in order to identify any deficiencies which would
require an adjustment to operating expenses in order to balance the Budget. Although based on the
projections the General Fund Revenue will be approximately $980,000 more than the Budget, this only
represents a 2.1 percent deviation from the Total General Fund Budgeted Revenue of $45 7 million and
six months remain in the Fiscal Year.
Property Taxes
(Category represents approximately 34% 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 2005-2006. Based upon this
information it appears that the projected property tax revenues will be above the budget originally
approved by Council, due to additional new development being added 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, a two year property tax shift to the State. The Property Taxes are also
reduced $146,786 which is retained by the County for Property Tax Administration. These shifts
of local shares of the taxes were instituted to solve State budget deficits. If these programs did not
exist the City Government would have these additional funds available to finance local programs.
Revised Estimate Property Tax Category:
(+) Increase $453,000
Sales Taxes
(Category represents approximately 33% of budgeted General Fund Revenues)
Currently, sales tax collected to date is ahead of the budgeted proj ection for the year It should be
noted however, the retail sales tax data recorded to date only includes sales occurring prior to
October 1, 2005 (i.e. first quarter of Fiscal Year 2005-2006) and the advances of sales taxes by the
State for the period of October 2005 through December 2005 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 slightly ahead of budget. However, this
increase could be positively or negatively impacted by holiday receipts. This information should
be available in the next month.
The projected incremental increase in General Sales Tax is projected to be offset by an adjustment
to the projection for In Lieu Sales and Use Tax Payments. The Budget anticipated a "clean-up"
payment in January 2006 related to 2004/2005 tax collections. The State has made a one time
change to the basis used for calculating the In Lieu sales tax, and the clean-up adjustment was
recorded as a 2004/2005 entry The combined net impact is a projected decrease for 2005/2006 of
$58,000.
Revised Estimate Sales Tax Category:
(-) Decrease) $58,000
Taxes Other Than Property and Sales Tax (i.e. Franchise Tax I TOT)
(Category represents approximately 7% of budgeted General Fund Revenues)
Franchise Fees for the first six months are above estimates and are projected to be approximately
$114,000 over budget by year end, due primarily to collection of non exclusive garbage franchise
fees, separate from those collected by Amador Valley Industries. There is also a modest increase
due to more residential customers than originally expected.
Revised Estimate Other Taxes Category:
(+) Increase $ 114,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 and fire permit revenue is projected to
be ahead of budget at year end by approximately $365,000, resulting from a higher than expected
number of permits pulled for new residential construction. This is more a matter of timing than
the result of unexpected units. 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 2005-2006, the expenses associated with the actual building
inspections may occur in Fiscal Year 2006-2007
In addition, the other permit revenues category is projected to be approximately $9,000 over
budget due to higher than expected collections from the issuance of animal licenses.
Revised Estimate Licenses & Permits Category:
(+) Increase $ 374,000
Interest & Rentals
(Category represents approximately 4% of budgeted General Fund Revenues)
Interest Revenue represents 93% of the total budgeted revenue in this category The remainder
consists of rental income collected for the use of City facilities. The analysis of interest revenue is
impacted by government accounting rules which require adjustments to revenue based on the year
end market value of investments held in the City portfolio. Although it is too early to calculate the
exact General Fund share of total interest revenue, it appears that the interest earnings actually
received in this category will slightly exceed the budget estimate by $74,000. The City's overall
rate of return on its investments was higher than assumed in the budget estimate. However, it is
expected that the year end accounting entry for changes in market value will more than offset any
increase in actual revenue recorded.
The City's portfolio currently has some securities which were purchased when interest rates were
lower than today's rates. They do not mature for another 2-3 years. As interest rates increase the
market value of the security decreases. These declines are short term in nature, as the City intends
to hold these investments to maturity and therefore will receive the full amount of the original
investments at their maturity Since the General Fund represents approximately 50% of the City's
total funds available for investment, staffis anticipating a reduction of recorded interest revenue of
$440,000 based on the current market value compared to the market value on the City financial
records, which was established as of June 30, 2005
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 be below
the original budgeted forecast by approximately $14,000 due to lower than expected revenues from
field rentals.
Revised Estimate Interest & Rentals Category:
(-) Decrease $ 380,000
Interl!:overnmental 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
currently appears that that projected revenues from Vehicle License Fees (VLF) will be above the
revenue estimate contained in the revised Fiscal Year 2005-2006 budget by approximately
$477,000. The State repaid the VLF Loan that was outstanding from Fiscal Year 2003-2004 in
July 2005 This repayment was not assumed as part of the budget estimate for this item in Fiscal
Year 2005-2006.
Revised Estimate Intergovernmental Category:
(+) Increase $477,000
Charl!:es for Services
(Category represents approximately 11 % of budgeted General Fund Revenues)
Overall the net change to this category is projected to result in no change. It is projected that
specific revenue components in the category will fluctuate both above and below the Budget
estimate. For example, Planning, Zoning and Subdivision Fees, Engineering Plan Check fees, are
expected to be higher than budget. However this is offset by a reduction in time required for
development reimbursed legal services. Fire Plan Check fees are projected to be approximately
$50,000 below the budget estimate, due to a lower number of sprinkler plans being submitted for
review Increases are projected in the following: Recreation Charges for Services - approximately
$30,000 over budget, primarily from Cultural Arts participant program charges; Booking Fee
Revenues - projected to be about $20,000 over budget.
Revised Estimate Charges For Services Category:
No Chanl!:e
Fines & Forfeitures
(Category represents less than 1 % of budgeted General Fund Revenues)
It currently appears that the revenue to be received from fines and forfeitures will meet the original
budgeted forecast.
Revised Estimate Fines & Forfeitures Category:
No Chanl!:e
Other Revenues
(Category represents approximately 4% of budgeted General Fund Revenues)
Approximately 70% of the revenue in this budgeted category represents reimbursements to the
General Fund associated with Capital Projects (BART Mitigation - St Patrick Way / Fallon Road I
Utility Undergrounding. It is likely that revenues in this category will be below the budget
estimate due to timing changes on these projects. This also means that expenses will not be
incurred as originally planned and there would not be any net change in the financial impact.
Revised Estimate Other Revenues Category:
No Chanl!:e
In summary, Staff is projecting cumulative net changes to the preliminary revised revenue estimate for the
General Fund for Fiscal Year 2005-2006 of approximately $980,000 or 2.1 % higher than the total revised
budgeted amount for revenues in the General Fund. This data is provided to Council for information
purposes only; Staff is not recommending any budget changes for the City's revenue appropriations at this
time.
REVISIONS TO EXPENDITURE ESTIMATES - GENERAL FUND
Staff has reviewed expenditures through December 2005 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 is recommended at this time. The analysis assumes that
all other expenditures will be in accordance with the adopted budget.
INSURANCE (10600)
Included in the Insurance budget is costs associated with the defense of claims that fall under the
City's deductible. Expenditures for specific claims can sometimes cross fiscal years depending on
the complexities of the issues. Based on current open items it is expected that the claims expense
will exceed the funds included in the adopted budget. It is recommended that an additional
$25,000 be appropriated to Claims Expense.
Proposed Additional Appropriation Insurance:
Increase $25,000
FIRE (20600)
(Represents approximately 18% ofthe budgeted General Fund Expenditures)
Unexpected operational maintenance issues encountered at the Fire Stations. This has included:
replacement of large volume water heater; replacement dishwashers; temporary rain barrier at
Station 16 (Donohue) pending permanent roof repair; roll-up door costs; and lighting repairs.
Staff is managing the budget by offsetting some of these costs with savings in contract
maintenance contract costs. Even with managing those costs an additional $12,000 in
appropriations for maintenance is recommended to meet the expected annual maintenance
expenditures.
Proposed Additional Appropriation Fire Services:
Increase $12,000
CULTURE AND LEISURE SERVICES
(Represents approximately 13% of the budgeted General Fund Expenditures)
Library (80100) + $10,500
A Budget change of $10,500 is being recommended to fund unanticipated sewer line repairs
required at the City's library This was an unexpected repair that has been completed.
Cultural Activities (80110) + $21,000
The contract instructor payments for programs in the Heritage and Cultural Arts division, are
projected to be $21,000 more than the adopted 2005/2006 Budget. Expenses for these services
are offset by class fees collected from the participants. The offerings for classes and events have
exceeded what was originally projected when the original budget was prepared. Therefore, the
recommended Budget Change also includes a $21,000 increase in revenue for these programs.
Proposed Additional Culture & Leisure Services Expenditures:
Increase $31,500
Proposed Additional Culture & Leisure Services Revenue:
Increase $21,000
CAPITAL PROJECTS (GENERAL FUND)
Habitat Monitoring Project (93181) + $25,000
The City included in the adopted Capital Improvement Program a project to assist with the
preservation and monitoring of the habitat of an endangered Golden Eagle. The project was
designed to implement a web-linked camera tool to allow for monitoring of a remote nesting area.
The installation requires the discreet placement of monitoring equipment in an area where utilities
are not readily accessible. Therefore, it will require a solar power system, which was not
originally scoped as part of the project. Also adjustments were required to the specified cameras
in order to provide the desired camera views.
Proposed Additional Capital Project Appropriation:
Habitat Monitoring Project #93181
Increase $25,000
In summary, the total recommended increases in General Fund Expenditure Appropriations are $93,500.
Of that amount $68,500 is associated with the Operating Expenditures and $25,000 associated with
Capital Projects. The Operating Expenditure adjustments are less than two-tenths of one percent
(0.0016%) of the total adopted General Fund expenditures. With the preliminary projections of adjusted
General Fund Revenue it is projected that the additional appropriations will not negatively impact the
reserves.
Recommendation
Staff recommends that the City Council (1) Receive the Report and Staff Presentation (2) Approve the
Budget Changes.
10+/'-/
City of Dublin 2005-2006 YTD Revenues and Budget Comparison
For..th.e..P.er1Q.!I..EIl!lillg])ecember.;U,2QQS.....
39%
49 .
Total General Fund Revenues
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental from State
Charges for Services
Fines and Forfeitures
Other Revenues
. FY 2005/0~
FY 2004/05
-- .----
I
I
1~4%
I
I
I
I
i
51 .
0%
120%
150%
30%
60%
90%
50% of Year Complete
FY 2005/06 FY 2005/06 %of FY 2004105 % of Total for
Budget YTD Actual Budget YTD Actual FY 2004/05
Property Taxes 15,716,461 6,948,784 44% 7,515,739 53%
Sales Taxes 14,984,884 3,732,869 25% 6,705,335 47%
Real Property Transfer Tax 745,600 334,018 45% 325,690 39%
Transient Occupancy Taxes 680,500 275,150 40% 297,059 45%
Franchise Taxes 1,626,300 326,838 20% 399,660 26%
Licenses and Permits 2,380,013 1,875,316 79% 2,451,777 70%
Interest and Rentals 1,898,725 479,757 25% 545,035 31%
Intergovernmental 498,650 715,641 144% 331,989 58%
Charges for Services 5,256,561 2,553,655 49% 2,434,804 44%
Fines and Forfeitures 132,200 64,131 49% 70,900 49%
Other Revenues 1,814,330 335,167 18% 397,005 51%
Total General Fund Revenues 45,734,224 17,641,326 39% 21,474,993 49%
"6,1-/ 3/;:; I/O ~
Da'ePr,nled'1/20120064.56PM ATTACHMENT 1
0( of I '-f
City of Dublin 2005-2006 YTD Expenses and Budget Comparison
For the Period Ending December 31, 2005
Total General Fund
Expenses
General Government
Police
Otber Public Safety
Transportation
Healtb and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
Fire
. FY 2005/06
!!l FY 2004/05
100%
... 85%
44%
0%
80%
120%
100%
20%
40%
60%
50% of Year Complete
2005/06 2005/06 %of FY 2004/05 % of Total for
Budget YTD Actual Budget YTD Actual FY 2004105
General Government 5,532,335 2,342,539 42% 2,094,771 43%
Police 11,358,537 2,463,782 22% 2,080,052 21%
Fire 8,890,188 2,358,377 27% 2,249,987 27%
Other Public Safety 383,869 108,489 28% 72 ,422 20%
Transportation 1,824,115 752,060 41% 654,205 39%
Health and Welfare 15,000 15,003 100% 73,392 85%
Culture and Community Services 6,363,138 2,700,335 42% 2,281,460 42%
Community Development 8,449,412 3,462,673 41% 3,263,376 44%
Capital Improvement Projects 5,342,794 1,419,449 27% 2,024,071 44%
Total General Fund Expenses 48,159,388 15,622,707 32% 14,793,736 35%
General Fund Operating Expenses 42,816,594 14,203,258 33% 12,769,665 34%
O..IePrlnt0<t112D12l1065.ODPM
ATTACHMENT 2
3D F It{
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF DECEMBER 2005
Prepared by
The Finance Department
January 20, 2006
ATTACHMENT 3
Y 0 f' IL{
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Dec2005
GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOT A L S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM DNLY---
FUNDS FUNDS FUNOS FUNDS FUND CURRENT PRIOR
ASSETS
CASH (53.331 427) 3 903.864 656 713 38.046 987 131. 555 (10 592.307) (28 668.225)
CASH WITH FISCAL AGENT 178 349 178 349 172.779
AMOUNT HELD IN ESCROW 4.177 500 4.177.500
INVESTMENTS AT COST 104 602 683 104 602 683 106 196 662
RECEIVA8LES TAXES
ACCOUNTS 127 768 363.597 491. 364 180 651
INTEREST
ASSESSMENTS
OUE FROM OTHERS 2.206 558 2 206 558 1 829.213
INVENTORY AT COST
PREPAIO ITEMS 2 346 2 346 12.930
FIXED ASSETS
LOANS RECEIVABLE 4 596 534 4 596 534
AMOUNT TO BE PROVIDED 1 213 500 1 213 500 1 334 500
TOTAL ASSETS 53 607 929 4 267 461 656 713 46 821. 021 1 523 404 106 876 528 81 058 510
LIA8ILITIES/FUND EOUITY
DEPOSITS FOR PRIVATE DEVEL (726 033) (726 033) (1.209,231)
DEPOSITS FOR A81600 FEES (763 358) (763.358) (344 022)
DEPOSITS OTHERS (2 518 865) (2 518 865) (2527,404)
PAYA8LES ACCOUNTS (725 828) (54 738) (1 440) (1 556) (783.562) (284 836)
INTEREST
PAYROLL (615 270) (615 270) (406 883)
OUE TO OTHERS (322 222) (5.270) (2.201 289) (2.528 780) (!l 799)
OEFERRED REVENUE (127 768) 027.768 ) (127 768)
DEBT INSTRUMENTS PAYA8LE (1 331 000) (1 331 000) (1 452 000)
TOTAL LIA8ILITIES (5 799 343) (60 008) (1 440) (2.202 845) (1 331. 000) (9 394 636) (6 363 942)
FUND 8ALANCES (47 808 585) (4 207 453) (655.273) (44 618 176) (192 404) (97 481.892) (74 694 568)
TOTAL FUND E (47 808 585) (4 207 453) (655 273) (44 618 176) (192.404) (97 481 892) (74 694 568)
TOTAL LIA8ILITIES/EOUITY (53 607 929) (4 267 461) (656 713) (46,821. 021) (1 523 404)(106 876 528) (81.058.510)
50tlLf
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Dec2005
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOT A L S
SERVICE FUND GROUP OF TERM DEBT ~~ MEMORANDUM---
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR
ASSETS
CASH 9.658 628 9 658 628 8 467 090
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVA8LES TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS 50 002 B51 333 664 335 383.667.186 85.720 159
LOANS RECEIVA8LE
AMOUNT TO 8E PROVIOEO 63 728 304 63 728 304 66 753 945
TOTAL ASSETS 59 661 479 333 664 335 63 728 304 457 054 118 160 941 193
LIA8ILITIES/FUNO EOUITY
OEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR A81600 FEES
DEPOSITS OTHERS
PAYA8LES ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (63 .728 . 304) (63 728.304) (66 753 945)
TOTAL LIA8ILITIES (63 728 304) (63.728 304) (66 753.945)
FUND BALANCES (59 661.479) (333 664 335) (393 325 814) (94 187.248)
TOTAL FUND E (59 661 479) (333 664 335) (393 325 B14) (94 187 248)
TOTAL LIABILITIES/EOUITY (59 661 479) (333 664,335) (63.72B 304) (457 054 118)(160 941 193)
THE CITY OF DUBLIN STATEMENT SHOWING b of-- ILj
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 12/31/2005
GENERAL REVENUE FUN 0
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y T.D VARIANCE
*******REVENUES*******
PROPERTY TAXES 15 716 461 00 6.948.783 60 8 767 677 40 14 054 547 16 7.515.739 07 6 538.808 09
SALES TAX 14 984 884 00 3 732.868 87 11.252 015 13 14 152 987 24 6.705,334 84 7 447 652 40
REAL PROPERTY TRANSFER TAX 745 600 00 334 018 49 411 581 51 831. 003 24 325 690 33 505 312 91
HOTEL TRANSIENT OCCUPANCY TAX 680 500 00 275 149 97 405 350 03 663 631 67 297 059 30 366 572 37
FRANCHISE TAXES I 626 300 00 326 838 02 1.299,461 98 1 559 900 22 399 659 77 1.160.240 45
LICENSES & PERMITS 2 380 013 00 1 875 315 99 504 697 01 3,520.140 84 2 451 777 03 1 068 363 81
FINES & FORFEITURES 132 200 00 64.130 73 68 069.27 143 316 33 70 899 80 72 416 53
USE/MONEY & PROP-INTEREST 1 757 524 00 440.91274 1316,611.26 1 608.966 40 487 600 64 1 121. 365 76
USE/MONEY & PROP-RENTALS 141.201 00 38 844 47 102 356 53 125 835 40 57 434.28 68 401 12
INTERGOVERNMENTAL 498 650 00 715 640 91 (216 990 9lJ 568.598 34 331. 989 06 236 609 28
CHARGES FOR SERVICES 5.256 561 00 2.553.655 45 2 702 905.55 5 548.124 34 2.434 803 71 3 113 320 63
OTHER SOURCES OF REVENUE 1.814 330 00 335 166 77 1.479 163.23 783 873 45 397,00485 386 868 60
TOTAL REVENUE 45 734 224 00 17 641 326 01 28 092,897 99 43 560 924 63 21 474 992 68 22.085.931 95
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
CITY COUNCIL 300 704 00 121 354 80 179,349.20 224 070 48 81 454 89 142 615 59
CITY MANAGER 997 923 00 452 425 48 545497.52 919 976 69 437 718.59 482.258 10
CENTRAL SERVICES 538 556 00 207 092 92 331 463 08 362 244 59 166 998.41 195.246 18
CITY ATTORNEY 824 252 00 270 138 46 554 113.54 631 963 18 287 019 70 344 ,943 48
ADMIN SERVICES 1 648 603 00 743.516 66 905 086 34 1 433 876 94 654 202 54 779 674 40
8UILDING MANAGEMENT 734 657 00 286.883 29 447 773 71 668 646.21 262 809 70 405 836 51
INSURANCE COST CENTER 397 038 00 256 176 31 140 861 69 508 448 41 202 312 46 306,135 95
ELECTIONS COST CENTER 2 890 00 1 072 08 1 817 92 12.265 33 2 089 08 10 176.25
NON DEPARTMENTAL 87 712 00 3.879 08 83 832 92 68 155 13 165 49 67 989 64
ACT! V ITY TOTAL 5 532 335 00 2.342.539 08 3 189 795 92 4 829 646 96 2.094.770 86 2.734 876 10
PU8L1 C SAFETY
POll CE 11.358 537 00 2.463 .781 88 8.894 755 12 9 837 842.27 2.080 052 39 7 757 789 88
CROSSING GUARDS 82 140 00 23 670 01 58 469 99 71. 407 04 22 410 53 48 996 51
ANIMAL CONTROL 208 898 00 53 428.29 155 469 71 208.369 91 19.242 00 189 127 91
TRAFFIC SIGNALS & STREET LIGHTIN 18 110 00 6 890 46 11 219 54 8.587.87 3 422.24 5 165 63
DISASTER PREPAREDNESS 74 721 00 24.499 89 50.221 11 68 023 15 27 347 14 40 676 01
FIRE SERVICES 8 890 188 00 2 358.376 95 6 531 811 05 8.207 944 38 2.249 987.27 5 957 957 11
ACTIVITY TOTAL 20 632 594 00 4 930 647 48 15 701 946.52 18.402 174 62 4 402 461 57 13 999 713 05
TRANSPORT A T! ON
PU8L1C WORKS 808 577 00 366 974 87 441 602 13 723 562 41 333 024 21 390 538.20
STREET MAINTENANCE 30 314 00 30 314 00 15 908 28 24.729 76 (8.821 48)
STREET SWEEPING 150.670 00 45 724.29 104 945 71 140 783 85 45 877 64 94 906 21
STREET TREE MAINTENANCE 99 430 00 29 046 84 70 383 16 99,19545 14 584 17 84 611.28
STREET LANDSCAPING MAINTENAN 735 124 00 310,314 18 424 809 82 682 756 30 235 989 53 446 766 77
ACT! V ITY TOTAL 1. 824 115 00 752 060 18 1 072.054 82 1 662 206.29 654.205 31 1 008.000 98
HEALTH & WELFARE
WASTE MANAGEMENT 2 58 (2.58) 71 474 64 58 392 46 13 082 18
CH I LD CARE 15 000 00 15 000 00 15,000 00 15 000 00
SOCIAL SERVICES
HOUS I NG PROGRAMS
THE CITY OF DUBLIN STATEMENT SHOWING 7oflL-f
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 12/31/2005
G ENE R A L REV E N U E FUN D
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y T 0 VARIANCE
ACTIVITY TOTAL 15 000 00 15 002 58 (2 58) 86 474 64 73 392 46 13,082 18
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 617 771 00 179956.58 437.81442 577 734 07 148 877 91 428 856 16
CULTURAL ACTIVITIES 204.701 00 133 582 80 71 118 20 125 102 04 52 610 05 72,491 99
HERITAGE CENTER 163 333 00 72 687 74 90 645 26 125,641 44 54 724 44 70 917 00
DUBLI N CEMETERY 49 958 00 11 652.25 3B.305 75 40 573 15 14 507.38 26 065 77
PARK MAl NTENANCE 1 712.065 00 619 176.20 1 092.888 80 1. 450 064 58 535 460 98 914 603 60
COMMUNITY TV 66 407 00 59 545 58 6 861 42 61 809 00 56 829 00 4 980 00
RECREATION AOMIN 708 174 00 328 219 74 379 954 26 608 760 76 277 695 16 331 065 60
PLAYGROUNDS 275 357 00 118 370 95 156.986 05 247 214.27 125 529 01 121 685.26
SHANNON CENTER 342 706 00 158 709 87 183 996 13 301 071 12 171 680.50 129,390 62
PRESCHOOL 105 458 00 48.836.23 56 621 77 82 639.86 39 901 67 42 738 19
TEENS PROGRAM 159 835 00 61 217 59 98 617 41 87 306 66 39 358 66 47 948 00
ADULT SPORTS 109.230 00 39 028.29 70.201 71 92,694 01 42 959 03 49,734 98
YOUTH SPORTS 153 617 00 61 943 02 91 673 98 118 533.39 44 369 87 74 163 52
COMMUNITY GYM 43 459 00 19 050 40 24 408 60 42887.87 11 937.26 30 950 61
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS 364 601 00 186 869 17 177 .731 83 331 898 19 157.19263 174 705 56
SEN lOR CENTER 365 728 00 195 355 42 170 372 58 253 121. 20 113 983 13 139 138 07
RECREATION INSTRUCTION 183 023 00 75 818.87 107.204 13 174 492 75 86 968 32 87 524 43
AOUA TI CS 429 221 00 185 982 98 243.238 02 393 660 59 183 047 20 210 613.39
PARKS/FACILITIES MANAGEMENT 308 494 00 144 331 74 164.162 26 261 928 57 123.827 56 138 101 01
ACTI V ITY TOTAL 6 363.138 00 2 700 335 42 3 662 802 58 5 377 133 52 2.281 459 76 3.095 673 76
COMMUNITY DEVELOPMENT
PLANNING 2 685 164 00 1 073 143 89 1.612.020 11 2 414 972.53 1 186.673 30 1. 228. 299 23
BUILDING SAFETY 3.214 615 00 1 177 982.25 2 036 632 75 2 399 434.25 935.336 06 1 464 098 19
ENGINEERING 2.194 005 00 1 025 503 09 1 168 501 91 2 304 691 55 950 033 40 1. 354 658 15
ECONOMIC DEVELOPMENT 355 628 00 186 043 68 169 584 32 272 379 63 191 332 91 81 046 72
ACT! V ITY TOTAL 8 449 412 00 3 462 672 91 4 986 739 09 7 391 477 96 3.263 375 67 4.128.10229
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 1 350.856 00 102 124 28 1 248.731 72 633 849 26 310 652 94 323 196 32
COMMUNITY IMPROVEMENTS 874 999 00 587 106 76 287 892 24 403 110 09 20 317 93 382 792 16
PARKS 1 628.920 00 572 510 10 1 056.409 90 2 630 020 78 1 442.327 01 1 187 693 77
STREET CONSTRC/IMPROVEMENTS 1 488 019 00 157 708.32 1 330.310 68 980 260 11 250 773 42 729 486 69
ACTI V ITY TOTAL 5 342 794 00 1.419 449 46 3 923 344 54 4 647 240.24 2 024 071 30 2 623 168 94
TOTAL EXPENDITURES 48 159.388 00 15 622 707 11 32 536 680 89 42 396 354.23 14 793.736 93 27 602 617 30
EXCESS REVENUE (EXPENDITURES) (2 425 164 00) 2 018 618.90 (4 443 782 90) 1.164 570 40 6 681 255 75 (5 516 685 35)
TRANSFERS IN FROM OTHER FUNDS 475 053 00 475,053 00 27 230 91 27.23091
TRANSFERS OUT FROM OTHER FUN OS
REVENUES DVER(UNDER) EXPENDITURES (1 950 111 00) 2 018 618 90 (3 968.729 90) 1 191 801.31 6 681 255 75 (5 489 454 44)
~ 0 +- J I..f
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 12/31/2005
S P E C I A L REV E N U E FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUOGET ACTUAL VARIANCE FISCAL YEAR Y T 0 VARIANCE
********REVENUES********
PROPERTY TAXES 117 6BO 00 58.866 64 58 813.36 112.532 03 56 837 59 55 694 44
SALES TAX/OTHER TAXES 360 500 00 159,812.90 200 687 10 364 477 71 91 298 54 273 179 17
FINES & FORFEITURES 156 000 00 73 826 76 82 173 24 149 341 93 23 ,500 71 125 841 22
USES/MONEY & PROPERTY 99 757 00 46,829 50 52 927 50 102 932.29 30 778 45 72 153 84
INTERGOVERNMENTAL FROM STATE 1 014.231 00 491 802 81 522 428 19 2 354 339 65 1 615 519.27 738.820 38
INTERGOVERNMENTAL FROM COUNTY 340 440 00 79 255 00 261 1B5 00 332 344 00 72 652 00 259 692 00
INTERGOVERNMENTAL FROM FEDERAL 76 792 00 37 404 53 39 3B7 47 56 796 80 2 790 99 54 005 81
CHARGES FOR SERVICES 1. 350 .461 00 670 163.35 680 297 65 1 075.178 65 543 712.28 531 466 37
OTHER SOURCES OF REVENUE 409 500 00 390 000 00 19 500 00 170 482.39 4.518.35 165.964 04
TOTAL REVENUE 3 925 361 00 2 007 961 49 1 917 399 51 4 718 425 45 2 441 608 18 2.276 817 27
*******EXPENDITURES*******
PUBLI C SAFETY
POll CE 120.255 00 101 033 88 19.221 12 105 952 40 104 007 80 1 944 60
TRAFFIC SIGNALS & STREET LTG 234 700 00 120 069 36 114 630 64 173,175 14 44.885 04 128 290 10
DISASTER PREPAREDNESS
FIRE SERVICES 270 120 00 76 109 59 194 010 41 251 091. 21 28.391. 24 222 699 97
ACTI V!TY TOTAL 625 075 00 297 212.83 327 862 17 530 218 75 177 . 284 08 352 934 67
TRANSPORTATION
STREET MAINTENANCE 330 474 00 104 376 38 226 097 62 272 390.25 66 681 47 205 708.78
STREET SWEEPING
ACTI V ITY TOTAL 330 474 00 104 376 38 226 097 62 272 390 25 66.681 47 205 708 78
HEALTH & WELFARE
WASTE MANAGEMENT 1 B74 906 00 451 336.81 1 423.569 19 1. 383 964 16 15 056 90 1 368907.26
SOCIAL SERVICES 60.427 00 9 168 62 51.258.38 44 927 00 15.392 30 29 534 70
HOUSING PROGRAMS
ACTIVITY TOTAL 1. 935 . 333 00 460 505 43 1 474.827 57 1.428.891 16 30 449 20 1 398.441 96
COMMUNITY OEVELOPMENT
ENGINEERING 6 000 00 6.000 00 6 000 00 2 490 50 3 509 50
ACTI V ITY TOTAL 6.000 00 6 000 00 6 000 00 2 490 50 3 509 50
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
COMMUNITY PROJECTS 39 556 00 29 791 00 9 765 00 14 850 00 14.850 00
PARKS 31.310 00 31 310 00 321 717 00 128 500 00 193.217 00
STREET CONSTRUCTION/IMPROVEMENT 1 670 803 00 517 924 91 1 152 878 09 149 554 78 72 610 21 76 944 57
ACTI V!TY TOTAL 1 741 669 00 547 715 91 1 193 953 09 486 121 78 201.110 21 285,011.57
TOT A L EXPENDITURES 4 644 115 00 1 415 810 55 3.228 304 45 2 723 621 94 478.015 46 2,245 606 48
EXCESS REVENUE (EXPENDITURES) (718 754 00) 592.150 94 (1.310 904 94) 1. 994.803 51 1 963 592 72 31 210 79
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 88 737 00 88 737 00 1 336.274 58 1 336 274 58
REVENUES OVER (UNDER) EXPENDITURES (807 491 00) 592 150 94 ([ 399 641 94) 658.528 93 1 963 592 72 (l 305 063 79)
THE CITY OF DUBLIN STATEMENT SHDWING i of ('-1
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 12/31/2005
S P E C I A L ASS E SSM E N T FUN D S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y T.D VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS 664 610 00 324 983.90 339 626 10 744 099 49 438 340 98 305 758 51
USES/MONEY & PROP-INTEREST 15 478 00 6 615 42 8,862 58 14 748 10 3.767 17 10.980 93
OTHER SOURCES OF REVENUE 5 000 00 2.578.84 2 421 16
TOTAL REVENUE 685 088 00 334.178.16 350 909 84 758.847 59 442 108.15 316 739 44
*******EXPENDITURES*******
PUBLI C SAFETY
TRAFFIC SIGNALS & STREET LIG 278 600 00 94.208 39 184 391 61 231 533 62 B6 399 98 145 133 64
ACT! V ITY TOTAL 278.600 00 94.208 39 184,391 61 231. 533 62 86 399 98 145.133 64
TRANSPORTATION
PUBLI C WORKS 2.415 00 739 03 1 675 97 1 591 29 666 69 924 60
STREET TREE MAINTENANCE 34 231 00 6.214 54 28 016 46 18 466 76 4 386 76 14 080 00
STREET LANDSCAPE MAINTENANCE 356 039 00 136.476 13 219 562 87 317 657 53 114 III 31 203.546 22
ACTI V!TY TOTAL 392 685 00 143 429 70 249 255.30 337 715 58 119,164 76 218.550 82
COMMUNITY DEVELDPMENT
ENGINEERING 13 100 00 11 357 60 1 742 40 7 139 94 6,669 94 470 00
ACT! V!TY TOTAL 13 100 00 11 357 60 1 742 40 7.13994 6 669 94 470 00
CAPITAL IMPROVEMENT PROJECTS
COMMUNITY IMPROVEMENTS 32 920 00 18 106 69 14 813 31
STREET CONSTRUCTION/IMPRVMNT 75. 000 00 75 000 00
ACTI V!TY TOTAL 107 920 00 18.106 69 89 813 31
TOT A L EXPENDITURES 792 305 00 267 102 38 525 202 62 576.389 14 212 234 68 364 154 46
EXCESS REVENUE (EXPENDITURES) (107 217 00) 67 075 78 (174 292 78) 182.458 45 229 873 47 (47 415 02)
REVENUES OVER (UNDER) EXPENDITURES (107 217 00) 67 075 78 (174 292 78) 182.458 45 229 873 47 (47 415 02)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 12/31/2005
100+ It..\-
CAP I TAL IMP R 0 V E MEN T FUN 0 S
CURRENT CURRENT PR lOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y T 0 VARIANCE
********REVENUE********
USES/MONEY & PROP-INTEREST 865 623 DO 468 841 91 396 781 09 1.221 970 50 382.033 41 839 937 09
OTHER SOURCES OF REVENUE 19.267 625 DO 9 083.026 75 10 184.598.25 14.361 927 97 9 691 912 86 4 670 015 11
TOTAL REVENUE 20 192.732.00 9 551 868 66 10 640 863 34 16.892.942 14 10 073 946 27 6 818 995 87
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
CITY ATTORNEY 38 950 00 20 562 79 18 387.21 35 736 39 504 00 35.232 39
ACT! V ITY TOTAL 38.950 00 20.562 79 18 387.21 35 736 39 504 00 35.232 39
PU8L1C SAFETY
TRANSPORT A T! ON
HEALTH & WELFARE
HDUS I NG PROGRAMS 903 030 00 141 037 41 761 992 59 219 420 35 83 413 44 136 006 91
CULTURE & LEISURE SERVICES
RECREATION ADMINISTRATION
ACT! V ITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACT! V ITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 83 600 00 83 600 00 624 943 39 143 164 57 481 778 82
COMMUNITY IMPROVEMENTS 36 771 00 36 771 DO
PARKS 11,322.835 00 3.093 954.25 8 228.880 75 6.285 687 19 223 634 37 6 062 052 82
STREET CONSTRUCTION/IMPROVEMENT 36 340 142 00 220.819 01 36,119 322 99 3 309 862 62 1 058 539 13 2 251 323 49
ACT! V ITY TOTAL 47 746 577 00 3 314 773.26 44 431 803 74 10.257.264 20 1 425 338 07 8 831 926 13
TOT A L EXPENDITURES 48 688 557 00 3476.37346 45 212 183 54 10 571 890 78 1.509.255.51 9 062 635.27
EXCESS REVENUE (EXPENDITURES) :28,555 309 00) 6.075.495.20 (34 630 804.20) 5 012 007 69 8 564 690 76 (3 552 683 07)
TRANSFER IN FROM OTHER FUNDS (59 484 00) (59 484 00) (1 309 043 67) (1.309 043 67)
TRANSFERS OUT TO OTHER FUNDS 445 800 00 445.800 00
REVENUES OVER (UNDER) EXPENDITURES(28 941 625 00) 6 075 495.20 (35 017 120 20) 6 321 051 36 8,564 690 76 (2 243 639 40)
11 o ~ ILf
THE CITY OF DU8LIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FDR THE PERIOD
07/01/2005 THROUGH 12/31/2005
T R U S T / AGE N C Y FUN 0
CURRENT CURRENT PRIOR PRIOR
8UlXiET ACTUAL VARIANCE FISCAL YEAR Y T 0 VARIANCE
********REVENUES********
SPECIAL ASSESSMENTS 117.292.54 (Il7 292.54) 228 280 46 116,965 04 111 315 42
USES/MONEY & PROP-INTEREST 3.402.26 (3 402.26) 5 612 63 386 19 5.226 44
TOTAL REVENUE 120 694 80 <120 694 80) 233.893 09 117 351.23 116 541 86
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-OEPARTMENTAL 231 038 00 183 498 75 47 539.25 232.571 18 179 622 43 52 948 75
ACT! V!TV TOTAL 231. 038 00 183,498.75 47 539.25 232 571 18 179 622 43 52.948.75
PUBU C SAFETY
TRANSPORTATION
HEALTH & WELFARE
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT
CAPITAL IMPROVEMENT PROJECTS
TOT A L EXPENDITURES 231 038 DO 183,498 75 47 539.25 232 571 18 179 622 43 52 948 75
EXCESS REVENUE (EXPENDITURES) (231 038 DO) (62 803 95) 068.234 05) 1 321 91 (62.271.20) 63 593 11
REVENUES OVER (UNDER) EXPENDITURES (231 038 00) (62 803 95) 068.234 05) 1. 321 91 (62.271.20) 63 593 11
THE CITY OF DUBLIN STATEMENT SHOWING i:2oFl4
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 12/31/2005
I N T ERN A L S E R V ICE FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y T D VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST 297 089 00 113 324 31 183 764 69 24S 407.37 79 081 16 166.326 21
CHARGES FOR SERVICES 1 796.096 00 893 723 71 902 372.29 1 642 441 30 850.851 51 791. 589 79
OTHER SOURCES OF REVENUE 23.400 00 14.525 00 8 875 00 4 841 986 98 233 47 4 841 753 51
TOTAL REVENUE 2 116 585 00 1 021.573 02 1. 095 011 98 6 729 835 65 930 166 14 5 799 669 51
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 2 092.680 00 291 706 80 1 800,973.20 2 467 397 02 680 218 76 1 787 178 26
ACT! V!TY TOTAL 2,092 680 00 291 706 80 1 800,973 20 2 467 397 02 680 218.76 1 787 178 26
PU8LIC SAFETY
FIRE 65 561 00 65 561 00 59 862 86 59 862 86
ACT! V!TY TOTAL 65 561 00 65 561 00 59 862 86 59 862 86
TRANSPORTATION
HEALTH & WELFARE
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT
CAPITAL IMPROVEMENT PROJECTS
TOT A L EXPENDITURES 2 158.241 00 291.706 80 1 866 534 20 2527.25988 680 218 76 1847.04112
EXCESS REVENUE (EXPENDITURES) (41 656 00) 729 866 22 (771 522.22) 4 202 575 77 249947.38 3 952 628 39
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES (41 656 00) 729 866 22 (771 522 22) 4 202 575 77 249 947 38 3 952 628.39
********REVENUES********
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
FINANCE
ACT! V !TV TOTAL
PUBLI C SAFETY
HEALTH & WELFARE
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT
CAPITAL IMPROVEMENT PROJECTS
TOT A L EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 12/31/2005
E N T E R P R I S E
FUN D
CURRENT
ACTUAL
PRIOR
FISCAL YEAR
VARIANCE
PRIOR
Y T D
(20 00)
(20 00)
(20 00)
20 00
20 00
/3of fLi
VARIANCE
20 00
20 00
20 00
(20 00)
(20 00)
CITY OF DUBLIN
BUDGET CHANGE FORM
14 o~ 1'-1
CHANGE FORM #
New Appropriations (City Council Approval Required):
Budget Transfers:
DEcREASE BUDGEl' AcCOUNT
AMOUNT
From Budgeted Contingent Reserve (1080-799.000)
Within Same Department Activity
Between Departments (City Council Approval Required)
Other
INCREASE BUDGET ACCOUNT AMOUNT
X From Unappropriated Reserves
(If Other than General Fund, Fund)
X From New Revenues (Heritage & Cultural Arts)
Name: EXPENSE: General Fund - Insurance- $25,000
Claims Paid
Account #:001- 10600-717.002
Name: Name: EXPENSE: General Fund - Fire - $12,000
Building Maintenance
Account #"
Account #:001-20600-740-012
Name: Name: EXPENSE: General Fund - Library $10,500
Services - Repairs and Maintenance
Account #:
Account #:001-80] 00-7 I 8-000
Name: Name: EXPENSE: Genera] Fund - Cultural $21,000
Activities - Contract Services General
Account #"
Account #: 00 I -80] I 0-740-000
Name: ~: General Fund - Cultural $21,000
Activities - Contract Services General
Account #: 001-565-009
Name: Name: EXPENSE: General Fund - Capital $ 25,000
Project - Habitat Monitoring
Account #"
Account #:00]-93181 -740-000
City Manager
Date:
Signature
ASDlFin Mgr
Date:
Signature
REASON FOR BUDGET CHANGE ENTRY Budget Changes designated in Mid Year Report for Fiscal
Year 2005-06
Mayor:
Date:
Signature
Posted By'
Date:
Signature
G' Wid Yetlr Repol"/slFY J005-06lAgendaIFORM-hwlgel chunge mid J'f OJ-DO. doc
Attachment 4