HomeMy WebLinkAboutItem 8.1 Mid Year Budget Rpt~~~~ Off' nU~~~
/ii ~ 111
L~~ - ~ ~~~
DATE:
TO:
FROM:
STAFF REPORT CITY CLERK
CITY COUNCIL File # 330-20/330-50
March 3, 2012
Honorable Mayor and City Councilmembers
~~
Joni Pattillo, City Manager ° ~'
SUBJECT: Fiscal Year 2011 - 2012 Mid-Year Budget Report and December 2011 Quarterly
Report of Financial Activities
Prepared by Paul S. Rankin, Administrative Services Director
EXECUTIVE SUMMARY:
Staff has prepared a detailed Mid-Year Budget Review to identify any material deviations from
the adopted Fiscal Year 2011 - 2012 Budget. The primary focus of the report is on the General
Fund, which accounts for the majority of city operations. Staff has identified proposed
adjustments to Revenues and Expenditures. This item also provides the report of the financial
statements for the period ending December 31, 2011.
FINANCIAL IMPACT:
Detailed financial information can be found within the Staff Report and the Attachments.
RECOMMENDATION:
Staff recommends that the City Council (1) Receive the Report as authorized by Section 41004
of the California Government Code and (2) Approve the Budget Changes.
~'~
... ,
~"
M_ °~...,,..... ~ " ~ ..
l a,ti~ .......~~ .
Submitted By Reviewed By
Administrative Services Director Assistant City Manager
DESCRIPTION:
This item provides the report on the financial statements for the month of December 2011 with a
more detailed "Mid-Year Budget Review".
Attachments 3-6 contain the standard quarterly financial reports for the period ending December
31, 2011. However, the focus of the Mid-Year review will be on adjustments proposed to the
adopted budget. Changes are considered where there is adequate information available to
suggest a revised budget at this time. Adjusting the budget to reflect updated information is
important to assist in monitoring both revenue and expenditures. Making adjustments at this
time will not eliminate all deviations, since the proposed adjustments rely upon estimates and
only a partial year of actual data.
Page 1 of 5 ITEM NO. 8.1
Overview
This report will present in detail the adjustments required to both Revenue and Expenditure
budgets. One area that was difficult to project as the current budget was prepared was the
projected pace of new development. This has impacts on both revenue and expenditures and
contributed to some of the most significant changes recommended as part of the Mid-Year
Analysis. The City has also experienced some positive development among General Fund
revenue including taxes. Some of these gains are offset by reductions in other revenue such as
Interest Revenue and the elimination by the State of the local Motor Vehicle Fee revenue. The
trends and levels of adjustment are discussed in more detail later in this report.
General Fund Overview
The following Table summarizes, by major category, the total General Fund Revenue budget
adjustments recommended as part of the mid-year report.
SUMMARY OF GENERAL FUND MID-YEAR REVENUE BUDGET ADJUSTMENTS
Property Taxes Decrease Budget ($129,810)
Sales Taxes Increase Budget 500,000
Transient Occupancy Tax Increase Budget 180,000
Franchise Taxes Increase Budget 98,780
Licenses & Permits Increase Budget 1,000,000
Fines and Forfeitures No change at this time 0
Interest & Rentals Decrease Budget (225,000)
Intergovernmental Decrease Budget (180,000)
Charges For Services Increase Budget $775,600
Other Revenues (One-Time) No change at this time 46,000
TOTAL NET ADJUSTMENTS $2,065,570
Several of the sources of these changes also have offsetting increases in expenditures, which
will be discussed later in this report. For example, the Permit Fees have an associated cost
which may span multiple years and the majority of the Charges For Services also have a direct
contract costs associated with them. These two categories account for 88% of the total mid-
year revenue adjustments.
The General Fund Revenue increases are offset by $891,000 in recommended expenditure
adjustments. The following Table summarizes the changes by major category. As previously
discussed some of the expenditure changes have offsetting revenues.
SUMMARY OF GENERAL FUND MID-YEAR EXPENDITURE BUDGET ADJUSTMENTS
General Government Increase Budget $ 211,000
Police Increase Budget 19,500
Fire Increase Budget 72,000
Other Public Safety None at this time
Transportation None at this time
Health & Welfare None at this time
Culture And Community Services None at this time
Community Development Increase Budget 588,500
TOTAL NET ADJUSTMENTS
(General Fund Expenditures) $ 891,000
Page 2 of 5
The total of the adjustments represent a change of approximately 1.8% compared to the
adopted general fund operating budget. Please refer to Attachment 2 -Narrative Description
and Analysis for a detailed review of the proposed expenditure changes.
Summary Special Revenue Adjustments - (Non General Fund)
In addition to adjustments to the General Fund Revenue and Expenditures, adjustments are
also recommended for Special Revenue Funds. The following summarizes the by major
category the total budget adjustments recommended as part of the mid-year report for Special
Revenue Funds and Impact Fees. These funds have a restricted use and cannot be used for
discretionary programs and services. A significant amount of the changes relate to capital
project grants for projects that are not expected to proceed in the current year.
SPECIAL REVENUE AND CAPITAL IMPACT FEE REVENUE BUDGET ADJUSTMENTS
Public Safety Increase Budget $ 61,620
Transportation Decrease Budget ( 51,000)
Environmental Decrease Budget (498,300)
Parks None at this time
Maintenance Assessment Districts None at this time
Culture & Arts None at this time
Health & Welfare Increase Budget 300,000
Capital Impact Fees None at this time
A detailed description and analysis of the proposed changes is provided in Attachment 1.
Based on the Mid-Year Review, changes in expenditures outside the General Fund are limited
to three items in the Operating Budget and three capital projects as described below:
OPERATING EXPENDITURE CHANGES (Non-General Fund)
• Police Services (Patrol) (#2103) -State COPS Grant Fund (#2103)
fRecommended Increase in Expenditures: $100,0001
The State Budget was originally proposed without funding this local law enforcement
program and no expenses were budgeted in this fund. The final State Budget included
funding for this program and the City will receive $100,000. An appropriation of $100,000
for Police Patrol personnel cots will provide for the use of funds received.
• Public Works Administration (#31011- Measure B Bike /Pedestrian Fund (#22051
fRecommended Increase in Expenditures: $10,6901
This department is used to capture Staff costs associated with supporting the programs
which are implementation measures in the Bikeways Master Plan. These expenses can
be paid from Measure B. The adopted Budget did not include a specific appropriation for
Staff costs in the Measure B fund. An appropriation of $10,690 is estimated to reflect the
planned staff hours.
Page 3 of 5
• Waste Management (#5101) - Measure D Recycling Fund (#2304)
fRecommended Increase in Expenditures: $20,0001
As part of efforts to divert waste from the landfill the City has used Measure D funds to
reduce the cost to businesses that have food waste and participate in a composting
program. The level of participation has exceeded what was estimated when the budget
was prepared. An additional appropriation of $20,000 is recommended to fully cover the
projected costs.
CAPITAL PROJECT EXPENDITURE CHANGES (Non-General Fund)
• Capital Project #960024 -Traffic Speed Feedback Signs (Gas Tax)
fRecommended Increase in Expenditures: $1,8151
This project including the review of data and results is expected to be complete by June
30, 2012. The total cost of the project was $57,600 and it was funded using State Gas
Tax funds. The cost of installation of the signs was slightly more than anticipated
resulting in the need for an increased appropriation of $1,815.
• Capital Project #930004 -Geographic Information System (Traffic Safety Grant)
fRecommended Decrease in Expenditures: $38,3801
This project contained two components. One was a General Fund component to conduct
a GIS Needs Assessment. The second component was a Traffic Safety Grant, in the
amount of $38,380, that was applied for to obtain a computerized traffic accident
database. The grant funding for this component was not available and the system
procurement did not proceed. Since the revenue will not be received in the current fiscal
year, it is appropriate to also reduce the expenditures.
• Capital Project #950014 -Shannon Center & Park Parking Lot Improvements
(Storm Water Management Grant Applied For /Pending Notification)
fRecommended Decrease in Expenditures: $489,3001
This project was included in the Capital Improvement Program contingent upon receiving
a Storm Water Management Grant. The City is currently awaiting notification from the
State as to whether the City will be awarded grant funding. Since there would be limited
time to get the project underway in the current fiscal year, Staff is proposing an
adjustment to both revenue and expenditures for this project. Staff will examine funding
options and potential timing as part of the development of the Capital Improvement
Program.
As part of the preparation for the two year budget covering Fiscal Years 2012-2013 and 2013-
2014, Staff will continue to assess changes in expenditures and revenue. As part of the regular
financial reporting, Staff will also provide additional updates on major financial trends. A Budget
Change Form that includes all accounts discussed for adjustment as part of the Mid-Year
Review is included as Attachment 7 for approval by the City Council.
NOTICING REQUIREMENTS/PUBLIC OUTREACH:
None.
Page 4 of 5
ATTACHMENTS: 1. Proposed Revenue Adjustments - Narrative Description and
Analysis
2. Proposed Expenditure Adjustments - Narrative Description and
Analysis
3. General Fund Year to Date Revenues and Budget Comparisons
(December 31, 2011)
4. General Fund Year to Date Expenditures and Budget Comparisons
(December 31, 2011)
5. Comparison of Revenue versus Expenditures - By Fund Type
6. Monthly Fund Balances -For the Period Ending December 31, 2011
7. Mid-Year Budget Change
Page 5 of 5
CITY OF DUBLIN FISCAL YEAR 2011 - 2012 MID YEAR REPORT
PROPOSED REVENUE ADJUSTMENTS
NARRATIVE DESCRIPTION AND ANALYSIS
(MARCH 3, 2012)
The purpose of this document is to provide a narrative description of the revenue budget
adjustments being proposed as part of the Mid-Year Report. The adjustments are based on
actual year to date revenue collected as well as a high level assessment of estimated
revenues through the year ending June 30, 2012. The information is arranged focusing first
on the General Fund and then Special Revenue.
REVISIONS TO REVENUE ESTIMATES -GENERAL FUND
The following narrative provides additional analysis about the trends in the major revenue
categories, which are also shown graphically in the December 31, 2011 General Fund YTD
(Year-To-Date) Revenues /Budget Comparison (see Attachment 3 of Staff Report).
• Property Taxes (Adopted Budget Estimate = $22,066,000)
fRecommended Decrease in Revenue: ($129,810)1
(Category represents approximately 44.1 % of budgeted General Fund Revenues)
As of December 2011, the City has only received the first advance of the Fiscal Year
2011-2012 secured taxes. Based on historical trends the amount collected for
Secured Property Taxes should meet the budget projection. However, Unsecured
Property Tax is projected to be $15,000 less than the budget and In-Lieu Property Tax
will be $29,810 less than budget. The final area contributing to the decline is a
decrease of $85,000 in Property Tax Penalties. Penalties are allocated on a pooled
basis county-wide and, as defaulted properties have been brought current, there has
been a decline in the revenue from this source. Staff will be receiving an update from
the Alameda County Assessor in the coming month to obtain input on assessed value
trends expected in Fiscal Year 2012-2013.
• Sales Tax (Adopted Budget Estimate = $13,245,000)
fRecommended Increase in Revenue: $500,0001
(Category represents approximately 26.4% of budgeted General Fund Revenues)
Although the only site specific sales tax data currently available covers retail sales that
occurred between July 1, 2011 and September 30, 2011, Staff is recommending an
increase of $500,000. The lag means that even when the current budget was
prepared the City did not have any real data on sales occurring between January 2011
and June 2011. The positive change is based on how retail sales performed in this
period, as well as trends the City is seeing in certain sectors. Retail auto sales have
been strong as well as additional sales taxes collected from gasoline sales. The City's
tax consulting and monitoring firm is expecting the higher levels of growth to flatten in
the coming year in response to global economic pressures.
Page 1 of 6
Attachment 1
CITY OF DUBLIN FISCAL YEAR 2011 - 2012 MID YEAR REPORT
PROPOSED REVENUE ADJUSTMENTS
NARRATIVE DESCRIPTION AND ANALYSIS
(MARCH 3, 2012)
• Real Property Transfer Tax (Adopted Budget Estimate = $400,000)
fNo change is recommended.l
(Category represents 0.8% of budgeted General Fund Revenues)
Transfer taxes are collected when real estate is sold and the amount collected is
based on the transaction value. At this time no adjustments are recommended.
• Transient Occupancy Tax (Adopted Budget Estimate = $670,000)
fRecommended Increase in Revenue: $180,0001
(Category represents approximately 0.8% of budgeted General Fund Revenues)
Transient Occupancy Tax (TOT) is collected from hotels in the City. For the first six
months the City has experienced increases over the previous year. The prior year
results were partially impacted by hotel renovation projects which had temporarily
reduced the number of rooms available. The Tri-Valley Convention and Visitors
Bureau has seen an increase in weekday business stays, reflecting some of the
increased activity by major employers. The projection is that the TOT will be $180,000
more than the current budget.
• Franchise Taxes (Adopted Budget Estimate = $2,802,130)
fRecommended Increase in Revenue: $98,7801
(Category represents approximately 5.6% of budgeted General Fund Revenues)
This category includes PG&E Franchise Fees for Gas and Electric operations,
Garbage Franchise Fees, and Cable TV Franchise Fees. An Audit conducted by
PG&E resulted in one-time payment of fees that had been improperly coded to other
jurisdictions in prior years. This resulted in $58,780 in additional revenue. A review of
garbage franchise fees indicates that this revenue is projected to be $40,000 more
than originally estimated.
• Licenses & Permits (Adopted Budget Estimate = $2,043,830)
fRecommended Increase in Revenue: $1,000,0001
(Category represents approximately 4.1 % of budgeted General Fund Revenues)
The budget for this category was developed prior to the City having indications from
Developers that they would, in fact, proceed to construction. Many of the projects
hinged on financing and corporate decisions that could not be known for certain. A
conservative budget was developed to prevent the City from relying on general fund
revenue which was uncertain. The recommended change in this category is an
increase in Building permits. The budgeted revenue is proposed to be increased by
$1 million. Several of the residential Developers have proceeded with production at a
faster pace than originally anticipated. It is important to note that several of the
projects will require expenses in the following year for inspections; however, the permit
revenue is recorded in the year collected, even if it occurs at the end of the year.
Page 2 of 6
Attachment 1
CITY OF DUBLIN FISCAL YEAR 2011 - 2012 MID YEAR REPORT
PROPOSED REVENUE ADJUSTMENTS
NARRATIVE DESCRIPTION AND ANALYSIS
(MARCH 3, 2012)
Fines & Forfeitures (Adopted Budget Estimate = $118,860)
fNo change is recommended.l
(Category represents 0.2% of budgeted General Fund Revenues)
This category only relates to General Fund revenues. Parking Citations and Other
Court Fines are the major components of this revenue. At this time no adjustments
are recommended.
• Interest & Rentals (Adopted Budget Estimate = $1,322,050)
fRecommended Decrease in Revenue: ($225,000)1
(Category represents approximately 2.6% of budgeted General Fund Revenues)
Interest Revenue represents 65% of the total budgeted revenue in this category, with
facility rental revenue comprising 35%. At this time a decrease of $225,000 is
recommended for Interest Revenue. The rates available on investments have
remained low and are projected to continue to be less favorable than the estimate
used for the Budget. In addition the balance available for investment has decreased
with the purchase of property adjacent to the Civic Center.
Intergovernmental Revenues (Adopted Budget Estimate = $360,000)
fRecommended Decrease in Revenue: ($180,000)1
(Category represents approximately 0.7% of budgeted General Fund Revenues)
The recommended positive adjustment in this category is the result of action taken by
the State of California, which eliminated the Vehicle License Fee revenue distributed
to local agencies. The League of California Cities has pursued the legality of the State
action, however, the outcome is uncertain.
Charges for Services (Adopted Budget Estimate = $5,854,490)
fRecommended Increase in Revenue: $775,6001
(Category represents approximately 11.7% of budgeted General Fund Revenues)
This category includes a wide variety of fees and charges. The budget is concentrated
in the following three categories: Fire Charges; Parks & Community Services Fees;
and Community Development fees. As mentioned earlier with the Building Permit
revenue, the City has experienced an increase in the level of activity beyond what the
revenue budget was based upon. The total recommended adjustment for this
category is a combination of increases and decreases as described below:
Page 3 of 6
Attachment 1
CITY OF DUBLIN FISCAL YEAR 2011 - 2012 MID YEAR REPORT
PROPOSED REVENUE ADJUSTMENTS
NARRATIVE DESCRIPTION AND ANALYSIS
(MARCH 3, 2012)
Fire Service Charges
Increase Revenue from development application processing. $122,600
Parks & Community Services Charges
No Change is recommended at this time $ 0
Community Development Charges
An increase is recommended at this time $ 618,000
The increase reflects additional development activity beyond what was provided
for in the adopted budget. To provide these services there has also been
increases in costs for those services provided by a contract consultant. The
total change breaks down as follows:
Planning & Zoning Processing Fees $382,000
Engineering Plan Check Fees 236,000
Total $618,000
Waste Management Administrative Charges
An increase is recommended at this time $ 35,000
The increase reflects the trend based on six months of revenue collected from
the franchised garbage and recycling company.
• Other Revenues (Adopted Budget Estimate = $1,205,590)
(Recommended Increase in Revenue: $46,0001
(Category represents approximately 2.4% of budgeted General Fund Revenues)
It is common for this category to have wide fluctuations as it typically is used to record
one-time revenues and miscellaneous collections. The City received a general fund
grant of $46,000 from ABAG PLAN (the City's liability insurance provider.) The
funding will support general fund expenditures that are part of the Storm Drain
Assessment project.
Page 4 of 6
Attachment 1
CITY OF DUBLIN FISCAL YEAR 2011 - 2012 MID YEAR REPORT
PROPOSED REVENUE ADJUSTMENTS
NARRATIVE DESCRIPTION AND ANALYSIS
(MARCH 3, 2012)
PROPOSED REVENUE CHANGES -OTHER FUNDS (Non- General Fund)
Based on the mid-year analysis it is appropriate to also adjust the revenue projected in some
of the Special Revenue and Capital Impact Fee Funds.
SPECIAL REVENUE -PUBLIC SAFETY -Net change $61,620 increase.
• State Law Enforcement Grant Fund #2103 (COPS Grant)
(Adopted Budget Estimate = $ 0)
[Recommended Increase in Revenue: $100,000]
The proposed State Budget had proposed to eliminate this program. In previous years
the City had used this grant to offset Police personnel costs. As part of the final State
Budget the program was restored. There will also be an offsetting expenditure for
Police personnel costs in this fund.
• Traffic Safetv Fund #2106 (Traffic Safetv Grant)
(Adopted Budget Estimate = $38,380)
[Recommended Decrease in Revenue: ($38,380)]
The decrease in this fund is related to project specific Grant revenue. A Traffic Safety
Grant in the amount of $38,380 was applied for to obtain a computerized traffic
accident database. The grant funding for this component was not available and the
system procurement did not proceed. The budgeted revenue is recommended to be
reduced along with the associated project expenditures.
SPECIAL REVENUE -TRANSPORTATION -Net change ($51,000) decrease
• Gas Tax Fund #2201 (State Allocation of Gas Taxes)
(Adopted Budget Estimate = $1,280,500)
(Recommended Decrease in Revenue: $51,0001
The City receives gas tax distributed by the State under various allocation methods.
The allocation factors based on population for the current Fiscal Year are less than the
previous year. Therefore, a reduction of $51,000 is recommended at this time.
Page 5 of 6
Attachment 1
CITY OF DUBLIN FISCAL YEAR 2011 - 2012 MID YEAR REPORT
PROPOSED REVENUE ADJUSTMENTS
NARRATIVE DESCRIPTION AND ANALYSIS
(MARCH 3, 2012)
SPECIAL REVENUE -ENVIRONMENTAL -Net change ($489,300) decrease
• Storm Water Management Fund #2321 (State Grant)
(Adopted Budget Estimate = $489,300)
[Recommended Decrease in Revenue: ($489,300)]
The adopted budget included funding of $489,300 associated with a capital project to
refurbish the Shannon Center Parking Lot. The project was contingent upon receiving
the competitive grant funding. The City is currently awaiting notification from the State
as to whether the City will be awarded grant funding. Since there would be limited
time to get the project underway in the current fiscal year, Staff is proposing an
adjustment to both revenue and expenditures for this project. Staff will examine
funding options and potential timing as part of the development of the Capital
Improvement Program.
SPECIAL REVENUE -PARKS
No changes are recommended.
SPECIAL REVENUE -MAINTENANCE ASSESSMENT DISTRICTS
No changes are recommended.
SPECIAL REVENUE -CULTURE & ARTS
No changes are recommended.
SPECIAL REVENUE -HEALTH & WELFARE -Net change ($300,000) increase.
• Affordable Housing Fund #2901 (Contributions)
(Adopted Budget Estimate = $ 0)
[Recommended Increase in Revenue: $300,000]
At the time the Budget was prepared the City was not expecting any payments from
Developers for In Lieu Fees or contributions. As a resulted of an amended
Development Agreement on the D R Horton Transit Center site, a payment of
$300,000 was collected.
CAPITAL IMPACT FEE REVENUE
No changes are recommended.
Page 6 of 6
Attachment 1
CITY OF DUBLIN FISCAL YEAR 2011 - 2012 MID YEAR REPORT
PROPOSED EXPENDITURE ADJUSTMENTS
NARRATIVE DESCRIPTION AND ANALYSIS
(MARCH 3, 2012)
The purpose of this document is to provide a narrative description of the expenditure budget
adjustments being proposed as part of the Mid-Year Report. The adjustments are based on
actual year to date expenses as well as an assessment of estimates for the remainder of the
Fiscal Year. The information is arranged focusing first on the General Fund and then Special
Revenue and Impact Fees.
REVISIONS TO EXPENDITURE ESTIMATES -GENERAL FUND OPERATING BUDGET
The following narrative provides additional analysis about the trends in the major General
Fund expenditure categories, which are also shown graphically in December 31, 2011
General Fund YTD (Year-To-Date) Expenditures /Budget Comparison (see Attachment 4 of
Staff Report).
• General Government (Adopted Budget Estimate = $7,329,587)
fRecommended Increase in Expenditures: $211,0001
(Category represents approximately 14.8% of budgeted General Fund Operating
Expenditures)
Based on current estimates, the City Attorney activity will require an additional
appropriation. Legal Services estimated expenses are projected to be $111,000 more
than the amount budgeted. The additional cost relates to activities associated with
development applications and the cost is recovered from the applicant. In addition
$100,000 is proposed to be added to replenish the Budgeted Contingency account.
During the first six months the City Council has approved various uses of the
contingency including: $50,000 in operating costs for the Civic Center expansion site;
$28,960 related to facility studies coordinated by Parks & Community Services; and
approximately $23,600 for the close out of General Fund Capital projects.
• Public Safety -Police (Adopted Budget Estimate = $13,315,008)
fRecommended Increase in Expenditures: $19,5001
(Category represents approximately 26.9% of budgeted General Fund Operating
Expenditures)
Additional support costs have been incurred to enhance the organization of the Crime
Prevention programs and activities. Contract services were obtained to develop a
Crime Prevention Task Manual which will document the standard for programs,
practices and procedures of the Crime Prevention Unit. An additional appropriation of
$19,500 is recommended.
Page 1 of 3
Attachment 2
CITY OF DUBLIN FISCAL YEAR 2011 - 2012 MID YEAR REPORT
PROPOSED EXPENDITURE ADJUSTMENTS
NARRATIVE DESCRIPTION AND ANALYSIS
(MARCH 3, 2012)
Public Safetv -Fire (Adopted Budget Estimate = $10,534,240)
(Recommended Increase in Expenditures: $72,0001
(Category represents approximately 21.3% of budgeted General Fund Operating
Expenditures)
Among the activities in the Fire Budget are on-going close-out obligations for the
Dougherty Regional Fire Authority. The agency was self-insured for Workers
Compensation claims and it also incurs costs associated with retirees. An additional
$72,000 appropriation is recommended at this time.
Public Safetv -Other (Adopted Budget Estimate = $647,772)
fNo change proposed at this timel
(Category represents approximately 1.3% of budgeted General Fund Operating
Expenditures)
Based on current estimates no change is recommended at this time.
Transportation (Adopted Budget Estimate = $2,024,442)
fNo change proposed at this timel
(Category represents approximately 4.1 % of budgeted General Fund Operating
Expenditures)
Based on current estimates no change is recommended at this time.
• Health & Welfare (Adopted Budget Estimate = $314,404)
fNo change proposed at this timel
(Category represents approximately 0.6% of budgeted General Fund Operating
Expenditures)
Based on current estimates no change is recommended at this time.
Culture & Community Services (Adopted Budget Estimate = $8,131,931)
fNo change proposed at this timel
(Category represents approximately 16.4% of budgeted General Fund Operating
Expenditures)
Based on current estimates no change is recommended at this time.
Page 2 of 3
Attachment 2
CITY OF DUBLIN FISCAL YEAR 2011 - 2012 MID YEAR REPORT
PROPOSED EXPENDITURE ADJUSTMENTS
NARRATIVE DESCRIPTION AND ANALYSIS
(MARCH 3, 2012)
Communitv Development (Adopted Budget Estimate = $7,150,555)
(Recommended Increase in Expenditures: $588,5001
(Category represents approximately 14.5% of budgeted General Fund Operating
Expenditures)
Community Development includes the following activities: Planning, Building and
Safety, Engineering, and Economic Development. To the extent that the increases are
associated with increased development activity there are off-setting revenues. The
proposed adjustments by division are as follows:
Communitv Development Dept -Planning Division
No adjustment is required at this time.
Communitv Development Dept -Building and Safety Division
Increase Contract Building Inspection Services
Public Works Deat - Enaineerina Division
Increase contract services for private development
Economic Develoament
Increase expenditures for Community Promotion activities
Related to the All American City recognition.
$ 300, 000
$ 260, 000
$ 28, 500
Page 3 of 3
Attachment 2
City of Dublin 2011-2012 YTD Revenues and Budget Comparison
for the Period Ending December 31, 2011
Total General fund
Revenues
Other Revenues
Charges for Services 47 °/o
43 /o
Intergovernmental ~ ~ ~ ,
from State ~~~~~~~~~~~~~ 31°/0
Interest ~~~ ~/O
4(%
fines and forfeitures 44/0
-44 /o
Licenses and Permits
franchise Taxes ~ 25°/0
22 °/o
Transient Occu
anc
p
y
Taxes 42°/0
Real Property 39 °/o
Transfer Tax ~~`~o
Sales Taxes a
-47
49
Property Taxes
i ~U~
hh'%,
79
97
(5%
^ FY 2011/12
uuuuu FY 2010/11
0 °Io 30 °Io 60 °Io ~0 °Io 120 °Io
50 °/o of Year Complete
150 °/o
FY 2011 /12 FY 2011 /12 % of FY 2010/11 % of Total for
Budget YTD Actual Budget YTD Actual FY 2010/11
Property Taxes 22,066,000 10,799,100 49% 10,938,415 50%
Sales Taxes 13,245,000 6,380,648 48% 6,160,138 47%
Real Property Transfer Tax 400,000 157,182 39% 114,417 24%
Transient Occupancy Taxes 670,000 438,536 65% 283,997 42%
Franchise Taxes 2,802,130 700,113 25% 582,605 22%
Licenses and Permits 2,043,830 1,984,634 97% 1,186,489 43%
Fines & Penalties 118,650 52,294 44% 54,466 44%
Interest & Rentals 1,322,050 525,673 40% 695,008 46%
Intergovernmental 360,000 15,851 4% 154,243 31%
Charges for Services 5,854,490 2,722,719 47% 2,748,845 43%
Other Revenues 1,205,590 799,480 66% 2,633,945 79%
Total General Fund Revenues 50,087,740 24,576,230 49% 25,552,568 48%
Dd1e ATTACHMENT 3
49
-48'
City of Dublin 2011-2012 YTD Expenses and Budget Comparison
For the Period Ending December 31, 2011
Total General Fund
Expenses
35%
C1P Projects 51
Community Development 43%
45 /°
Culture & Community ~ 46%
Services 46%
Health and Welfare ~ 21 %
20%
Transportation 39% °
45 /°
Other Public Safety ~ 10 °
11/
Fire 26%
25%
Police ~ 5%
5%
General Government 41
33%
0% 20% 40% 60% 80% 100% 120%
50% of Year Complete
FY 2011 /12 FY 2011 /12 % of FY 2010/11 % of Total for
Budget YTD Actual Budget YTD Actual FY 2010/11
General Government 7,329,587 3,011,905 41% 2,653,508 33%
Police 13,315,008 667,347 5% 573,039 5%
Fire 10,534,240 2,705,999 26% 2,520,979 25%
Other Public Safety 647,772 84,403 13% 114,070 11%
Transportation 2,024,442 780,358 39% 822,050 45%
Health and Welfare 314,404 65,737 21% 67,063 20%
Culture and Community Services 8,131,931 3,708,980 46% 3,317,954 46%
Community Development 7,150,555 3,083,622 43% 2,507,428 45%
CIP Projects 8,094,007 5,970,998 74% 1,693,063 51%
Total General Fund Expenses 57,541,946 20,079,349
^ FY 201 1 /12
uuuu FY 2010/11
35% 14,269,154
General Fund Operating Expenses 49,447,939 14,108,351 29% 12,576,091
Dale
ATTACHMENT 4
29%
27%
CITY OF DUBLIN
PRO FORMA
COMPARISON OF REVENUE VERSUS EXPENDITURES
(By Fund Type)
FISCAL YEAR 2011-2012
FOR THE PERIOD ENDING DECEMBER 31, 2011 (Quarter 2)
,~~ ~~1V L~l\
~~, _~~,
'~.
llt ~'~ . X11
{ ,;
~ ~ -~~- -
I
..~
.I~. ~~~
Prepared by
The Finance Department
March 3, 2012
• General Fund -Comparison of Revenue & Expenditures 7/1/2011 - 12/31/2011
• Special Revenue Funds -Comparison Revenue & Expenditures 7/1/2011 - 12/31/2011
• Assessment District Funds -Comparison Revenue & Expenditures 7/1/2011 - 12/31/2011
• Agency Trust Funds -Comparison Revenue & Expenditures 7/1/2011 - 12/31/2011
• Internal Service Funds -Comparison Revenue & Expenditures 7/1/2011 - 12/31/2011
ATTACHMENT 5
Printed on: 02/25/2012 CITY OF DUBLIN Page 1 of 2
GENERAL FUND
COMPARISON OF REVENUES /VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2011 THROUGH 12/31/2011
2012 2012 2012 2012 2011 2011 2011
BUDGET ACTUAL VARIANCE °~ BUD ACTUAL YTD °~
*" "**"*REVENUES/SOURCE OF FUNDING*"*" "**
PROPERTY TAXES 22,066,000 10,799,100 11,266,900 49°~ 21,918,484 10,938,415 50°~
SALES TAX 13,245,000 6,380,648 6,864,352 48°~ 12,969,119 6,160,138 47°~
PROPERTY TRANSFER TAX 400,000 157,182 242,818 39°~ 475,199 114,417 24°~
HOTEL TAX 670,000 438,536 231,464 65°~ 683,732 283,997 42°~
FRANCHISE TAXES -WASTE MGT 1,600,000 474,867 1,125,133 30°~ 1,444,816 414,943 29°~
FRANCHISE TAXES -UTILITIES 1,202,130 225,248 976,882 19°~ 1,194,768 167,661 14°~
LICENSES & PERMITS 2,043,830 1,984,634 59,196 97°~ 2,752,748 1,186,489 43°~
FINES & PENALTIES 118,650 52,294 66,356 44°~ 124,615 54,466 44°~
INTEREST 853,040 265,197 587,843 31°~ 999,167 445,507 45°~
RENTALS & LEASES 469,010 260,477 208,533 56°~ 501,602 249,501 50°~
INTERGOVERNMENTAL -FEDERAL 19,353 92,500 478°~
INTERGOVERNMENTAL-STATE 360,000 15,851 344,149 4°~ 477,259 61,743 13°~
CHARGES FOR SERVICES 5,854,490 2,722,719 3,131,771 47°~ 6,432,785 2,748,845 43°~
OTHER REVENUE 1,205,590 799,480 406,110 66°~ 3,326,671 2,633,945 79°~
SUB-TOTAL OPERATING REVENUES 50,087,740 24,576,230 25,511,510 49% 53,320,317 25,552,568 4$%
TRANSFERS IN 140,345 140,345 29,726
GRAND TOTAL REVENUE/SOURCES 50,228,085 24,576,230 25,651,855 49% 53,350,042 25,552,568 48%
****"*"*EXPENDITURES/TRANSFERS" "*" "*
GENERAL GOVERNMENT
CITY COUNCIL 465,680 147,184 318,496 32°~ 338,090 111,129 33°~
CITYMANAGER/CITYCLERK 1,264,082 637,069 627,013 50% 1,120,492 551,801 49%
ELECTIONS 1,870 587 1,283 31°~ 24,389 2,443 10°~
CENTRAL SERVICES/HUMAN RESOURCES 540,236 235,046 305,190 44°~ 387,252 193,792 50°~
INSURANCE 884,370 272,271 612,099 31% 902,515 251,785 28%
CITY ATTORNEY 687,540 325,720 361,820 47°~ 652,766 240,888 37°~
ADMINISTRATIVE SERVICES 2,104,687 933,558 1,171,129 44°~ 1,787,878 874,814 49°~
BUILDING MANAGEMENT 790,785 316,545 474,240 40% 684,517 309,509 45%
NON-DEPARTMENTAL 590,337 143,923 446,414 24°~ 2,252,977 117,348 5°~
GENERAL GOVERNMENT- SUBTOTAL 7,329,587 3,011,905 4,317,682 41% 8,150,877 2,653,508 33%
PUBLIC SAFETY
POLICE 13,315,008 667,347 12,647,661 5°~ 12,514,134 573,039 5°~
FIRE 10,534,240 2,705,999 7,828,241 26% 10,069,956 2,520,979 25%
DISASTER PREPAREDNESS 101,432 34,791 66,641 34°~ 346,664 45,880 13°~
CROSSING GUARDS 122,960 41,111 81,849 33°~ 100,893 33,667 33°~
ANIMAL CONTROL 370,310 370,310 414,420
TRAFFIC SIGNALS/STREET LIGHTING 53,070 8,501 44,569 16°~ 130,759 34,523 26°~
PUBLIC SAFETY- SUBTOTAL 24,497,020 3,457,749 21,039,271 14% 23,576,827 3,208,088 14%
TRANSPORTATION
PUBLIC WORKS ADMINISTRATION 876,742 394,138 482,604 45°~ 833,733 396,208 48°~
STREET MAINTENANCE/SWEEPING 150,930 33,976 116,954 23% 134,967 33,997 25%
STREET LANDSCAPE/TREE MAINTENANCE 996,770 351,240 645,530 35°~ 865,091 391,845 45°~
TRANSPORTATION -SUBTOTAL 2,024,442 779,354 1,245,088 38% 1,833,791 822,050 45%
HEALTH & WELFARE
ENVIRONMENTAL SERVICES 61,000 1,425 59,575 2°~
SOCIAL SERVICES 253,404 64,262 189,142 25% 337,222 67,063 20%
HOUSING PROGRAMS 50 (50)
HEALTH & WELFARE- SUBTOTAL 314,404 65,737 248,667 21% 337,222 67,063 20%
Printed on: 02/25/2012 CITY OF DUBLIN
GENERAL FUND
COMPARISON OF REVENUES /VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2011 THROUGH 12/31/2011
2012 2012 2012 2012 2011
BUDGET ACTUAL VARIANCE °~ BUD ACTUAL
****"*"*EXPENDITURES/TRANSFERS" "*" "*
CULTURE & LEISURE SERVICES
COMMUNITY TV
LIBRARY SERVICES
PARK MAINTENANCE
HERITAGE & CULTURAL ARTS
RECREATION & COMMUNITY SERVICES
PARKS/FACILITIES DEVELOPMENT
CULTURE & LEISURE SERVICES -SUBTOTAL
COMMUNITY DEVELOPMENT
DEVELOPMENT SERVICES
ENGINEERING
ECONOMIC DEVELOPMENT
COMMUNITY DEVELOPMENT -SUBTOTAL
SUB-TOTAL OPERATIONG EXPENDITURES
TRANSFERS OUT
GRAND TOTAL EXPENDITURES
REVENUES (SOURCE OF FUNDS) OVER/(UNDER)
EXPENDITURES
Page 2 of 2
2011 2011
YTD °~
32,840 9,764 23,076 30°~ 145,326 38,969 27°~
593,875 150,552 443,323 25°~ 518,077 249,457 48°~
2,487,971 1,113,782 1,374,189 45°~ 1,973,357 867,999 44°~
846,891 376,181 470,710 44°~ 739,661 305,000 41°~
3,849,825 1,818,254 2,031,572 47°~ 3,625,011 1,762,196 49°~
320,529 240,448 80,081 75°~ 211,679 94,334 45°~
8,131,931 3,708,980 4,422,951 46% 7,213,112 3,317,954 46%
4,487,613 1,821,888 2,665,725 41°~ 3,447,767 1,565,195 45°~
1,952,800 1,056,674 896,126 54°~ 1,804,759 806,600 45°~
710,142 206,064 504,078 29°~ 318,726 135,633 43°~
7,150,555 3,084,626 4,065,929 43% 5,571,252 2,507,428 45%
49,447,939 14,108,350 35,339,589 29% 46,683,081 12,576,091 27%
8,094,007 5,970,998 2,123,009 74°~ 3,347,946 1,693,063 51°~
57,541,946 20,079,348 37,462,598 35% 50,031,027 14,269,154 29%
(7,313,861) 4,496,882 (11,810,743) (61%) 3,319,015 11,283,414 340%
Printed on: 02/25/2012 CITY OF DUBLIN Page 1 of 1
SPECIAL REVENUE FUNDS
COMPARISON OF REVE NUES /VERSUS E XPENDITU RES
FOR THE PERIOD 7/1/2011 THROUGH 12/31/2011
2012 2012 2012 2012 2011 2011 2011
BUDGET ACTUAL VARIANCE °~ BUD ACTUAL YTD °~
*" "**"*REVENUES/SOURCE OF FUNDING*"*" "**
PROPERTY TAXES 150,100 76,464 73,636 51°~ 148,590 75,117 51°~
SALES TAX 437,450 106,839 330,611 24°~ 443,313 151,600 34°~
FINES & PENALTIES 173,500 52,883 120,617 30°~ 178,980 74,426 42°~
INTEREST 126,600 43,560 83,040 34°~ 267,583 147,049 55°~
LOAN REPAYMENTS 500 250 250 50°~ 477,039 50,727 11°~
INTERGOVERNMENTAL-FEDERAL 2,586,770 12,939 2,573,831 1°~ 446,947 14,857 3°~
INTERGOVERNMENTAL-STATE 2,961,100 606,015 2,355,085 20°~ 1,781,225 563,695 32°~
INTERGOVERNMENTAL-COUNTY 381,170 61,413 319,757 16°~ 1,221,488 143,053 12°~
CHARGES FOR SERVICES 2,544,310 1,297,940 1,246,370 51°~ 2,310,676 1,173,906 51°~
OTHER REVENUE 231,030 323,867 (92,837) 140°~ 1,714,182 968,733 57°~
SUB-TOTAL OPERATING REVENUES 9,592,530 2~ 52867 6477041, 3 26% 541304721 14181881 9g%
TRANSFERS IN 6,600 6,600 6,600
GRAN9 TOTAL REVENUEISOUR/ ES 3~ 33810 2~ 52867 6477841, 3 26% 5838821 14181881 16%
****"*"*EXPENDITURES/TRANSFERS" "*" "*
GENERAL GOVERNMENT
CITY ATTORNEY 50,166 12,368 37,798 25°~ 56,447 18,534 33°~
GENERAL GOVERNCENT-SUBTOTAL ,0888 724185 16835 2, % , 84VIVS 75~ 1M 11%
PUBLIC SAFETY
POLICE 66,408 41,521 24,887 63°~ 123,041 10,646 9°~
FIRE 321,670 80,960 240,710 25% 315,733 85,877 27%
TRAFFICSIGNALS/STREETLIGHTING 318,690 53,431 265,259 17°~ 141,859 31,993 23°~
PUBLI/ SAFETY- SUBTOTAL 608885 76, 4172 , 108, 8 2, % , 5081M 725 78 22%
TRANSPORTATION
PUBLIC WORKS ADMINISTRATION 4,430 2,598 1,832 59°~ 12,642 5,218 41°~
STREET MAINTENANCE/SWEEPING 574,706 172,841 401,865 30°~ 408,779 163,643 40°~
TRANSPORTATION -SUBTOTAL , 63818 76, 4V~3 M)1836 10% NE741R7 7854187 M)%
HEALTH & WELFARE
WASTE MANAGEMENT 2,625,580 116,775 2,508,805 4°~ 2,449,915 1,187,964 48°~
ENVIRONMENTAL SERVICES 370,050 97,475 272,575 26°~ 234,324 132,796 57°~
SOCIAL SERVICES 85,010 24,906 60,104 29% 104,235 64,141 62%
HOUSING PROGRAMS 1,822,180 725,981 1,096,199 40°~ 9,649,841 216,942 2°~
Others 22
HEALTH & WELFARE- SUBTOTAL Mti024i20 38, 4715 1816852 20% 724V~54178 7807418, 71%
CULTURE & LEISURE SERVICES
PARK MAINTENANCE 2,500 2,500
/ ULTURE & LEISURE SERVI/ ES -SUBTOTAL 2~ 00 2~ 00
COMMUNITY DEVELOPMENT
ENGINEERING 6,000 960 5,040 16°~ 6,000 2,965 49°~
/ OCC UNITY 9 EVELOPCENT -SUBTOTAL 84100 380 , 41ND 78% 84100 2418, N8%
SUB-TOTAL OPERATIONG EXPEN9ITURES 6,247,390 74/234176 Mti76~ 61 27% 71~ 024175 78208NY 7M/
TRANSFERS OUT 4,945,018 892,358 4,052,660 18°~ 3,473,960 1,780,030 51°~
GRAN9 TOTAL EXPEN9ITURES 77832415 282286, 5860811 20% 78868866 1800862 22%
REVENUES (SOUR/ E OF FUN9 S) OVERWUN9 ER) (74 314?65) 1, 34138 (741, 186M (21 %) (68508, M (116805) M/o
EXPEN9ITURES
Printed on: 02/25/2012 CITY OF DUBLIN Page 1 of 1
ASSESSMENT DISTRICT FUNDS
COMPARISON OF REVENUES /VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2011 THROUGH 12/31/2011
2012 2012 2012 2012 2011 2011 2011
BUDGET ACTUAL VARIANCE °~ BUD ACTUAL YTD °~
*" "**"*REVENUES/SOURCE OF FUNDING*"*" "**
PROPERTY TAXES 957,200 485,949 471,251 51°~ 904,738 465,040 51°~
INTEREST 11,330 3,551 7,779 31°~ 13,554 5,500 41°~
OTHER REVENUE 2,500 2,500 4,584
SUB-TOTAL OPERATING REVENUES 971,030 489,499 481,531 Sp% 922,876 470,540 $9%
GRAND TOTAL REVENUE/SOURCES 971,030 489,499 481,531 50% 922,876 470,540 51%
****"*"*EXPENDITURES/TRANSFERS" "*" "*
PUBLIC SAFETY
TRAFFICSIGNALS/STREETLIGHTING 431,030 115,390 315,640 27°~ 363,532 124,384 34°~
PUBLIC SAFETY- SUBTOTAL 431,030 115,390 315,640 27% 363,532 124,384 34%
TRANSPORTATION
STREET LANDSCAPE/TREE MAINTENANCE 487,300 187,442 299,858 38°~ 430,182 198,115 46°~
TRANSPORTATION-SUBTOTAL 487,300 187,442 299,858 38% 430,182 198,115 46%
COMMUNITY DEVELOPMENT
ENGINEERING 32,880 14,211 18,669 43°~ 32,351 15,179 47°~
COMMUNITY DEVELOPMENT-SUBTOTAL 32,880 14,211 18,669 43% 32,351 15,179 47%
SUB-TOTAL OPERATIONG EXPENDITURES 951,210 317,043 634,167 33% 826,065 337,679 49%
TRANSFERS OUT 87,570 87,570 44,238 84 0°~
GRAND TOTAL EXPENDITURES 1,038,780 317,043 721,737 31% 870,303 337,763 39%
REVENUES (SOURCE OFFUNDS)OVER/(UNDER) (67,750) 172,456 (240,206) (255%) 52,573 132,778 253%
EXPENDITURES
Printed on: 02/25/2012 CITY OF DUBLIN Page 1 of 1
AGENCY/TRUST FUNDS
COMPARISON OF REVENUES /VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2011 THROUGH 12/31/2011
2012 2012 2012 2012 2011 2011 2011
BUDGET ACTUAL VARIANCE °~ BUD ACTUAL YTD °~
*" "**"*REVENUES/SOURCE OF FUNDING*"*" "**
PROPERTY TAXES 231,104 (231,104) 531,728 271,837 51°~
INTEREST 2,922 (2,922) 1,485,341 683,344 46°~
OTHER REVENUE 392,746 (392,746) 1,862,493 280,333 15°~
SUB-TOTAL OPERATING REVENUES 626,772 (626,772) 3,879,562 1,235,515 320/
GRAND TOTAL REVENUE/SOURCES 626,772 (626,772) 3,879,562 1,235,515 32%
****"*"*EXPENDITURES/TRANSFERS" "*" "*
GENERAL GOVERNMENT
NON-DEPARTMENTAL 244,170 952,131 (707,961) 390°~ 1,048,309 370,043 35°~
GENERAL GOVERNMENT- SUBTOTAL 244,170 952,131 (707,961) 390% 1,048,309 370,043 35%
SUB-TOTAL OPERATIONG EXPENDITURES 244,170 952,131 (707,961) 390% 1,048,309 370,043 3$%
GRAND TOTAL EXPENDITURES 244,170 952,131 (707,961) 390% 1,048,309 370,043 35%
REVENUES (SOURCE OFFUNDS)OVER/(UNDER) (244,170) (325,359) 81,189 133% 2,831,253 865,472 31%
EXPENDITURES
Printed on: 02/25/2012 CITY OF DUBLIN Page 1 of 1
INTERNAL SERVICE FUNDS
COMPARISON OF REVENUES /VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2011 THROUGH 12/31/2011
2012 2012 2012 2012 2011 2011 2011
BUDGET ACTUAL VARIANCE °~ BUD ACTUAL YTD °~
*" "**"*REVENUES/SOURCE OF FUNDING*"*" "**
INTEREST 216,860 66,158 150,702 31°~ 176,799 73,900 42°~
CHARGES FOR SERVICES 2,436,960 1,184,021 1,252,939 49°~ 1,998,730 999,190 50°~
OTHER REVENUE 375,900 180,441 195,459 48°~ 2,339,146 151,737 6°~
SUB-TOTAL OPERATING REVENUES 3,029,720 6~ 73893 68)) 833 , 1( , 86, 815 689, Ti81 g1(
GRAND TOTAL REVENUE/SOURCES 789) X93 6~ 73893 68)) 833 , 1( , 86, 815 689, Ti81 91(
****"*"*EXPENDITURES/TRANSFERS" "*" "*
GENERAL GOVERNMENT
NON-DEPARTMENTAL 5,381,068 943,721 4,437,347 18°~ 4,290,345 632,012 15°~
GENERAL GOVERNMENT -SUBTOTAL 571°rfi88% ), 72196 , ~ 7171, 1 6°/( , 8) 371, 5 879869 65(
SUB-TOTAL OPERATIONG EXPENDITURES 5,381,068 ), 72196 , ~ 7171, 1 6°/( , 8) 371, 5 879869 65(
TRANSFERS OUT 211,600 211,600 114,832 26,450 23°~
GRAND TOTAL EXPENDITURES 58) 988% ), 72196 , 8, %j, 1 61( , ~ 35811 85°/~ 86 65(
REVENUES QSOURCE OX XUNDSFOVER/QJNDERF ®8897) , °iF , °iSP/~) W8,) y 1 F C6) (F 63) 2) % 5887/88 561(
EXPENDITURES
CITY OF DUBLIN
PRO FORMA MONTHLY FINANCIAL INFORMATION
FOR THE PERIOD ENDING DECEMBER 31, 2011 (Quarter 2)
_ 1
~"'
Prepared by
The Finance Department
March 3, 2012
• SUMMARY -All Funds Revenue, Expenditures and Fund
Balances 7/1 /2011 - 12/31 /2011
• DETAIL - By Individual Fund Revenue, Expenditures and Fund
Balances 7/1 /2011 - 12/31 /2011
ATTACHMENT 6
N
d
V
C
R ~
m C
'a N
C
7 ~
~ M
L
r 0
Q
0 ~ ~ C
r X OL ~
U LLI r ~
d
7 ~
C ~
y O
~ N
O
N ~
~ ~
C ~
7
LL
Q
Z U
0 Z
zg
W a
m
~ O
LL N
~ M
F
~ ~
W ~
~ N
~ M
D N
W ~
a
x
w
o rn
W W
H ~
W
('~ H
0 0
~ Z
m W
a
x
w
V1 W
Q J
Z m
~g
LL
Q ~
Oa
F
r
W O
LL N
~ M
F
rn
W ~
~ N
Z
W M
W
D to
w w
H 7
W Z
(7 w
0 ~
~ W
m ~
W ~_
Z ~
N
a O
m p
y
D
z
7
LL
O O N 00 O O M In 00 O V ~ N N N ~ I~
In
(O ~
f0 O
O V
N O
N M
~ V
O M
W ~
O N
O N
O M
I~ N N_ I~
O O
In ~
~ N
M
V ~ I~ to W (`') O r r r W V ~ V o0 M M
M _
~? I~
In N
N ~ N
O O
V In
O M
~? W
N ~
N M
O ~ ~ V
M ~
r N
W
I~ r N N r ~ 00 ~ (O N N W ~ I~
(p ~ r ~ O r ~
op 00 O In M 0 0 0 0 00 O In ~ O O O O O O O
O
O ~
~ M
V O
M O
In ~
M
N
N r
In r
In
O I~ (V ~ N W 00
~ ~ W •ri ~ N N r r
00 ~ N ~ 00 O M O (p ~ O O ~ ~ .-. '~ V I~ '~
I~ O V V In I~ O O N N M
V r
~ O In O N ~p
pp In O r
~ O ~ r V I~ ~ ~
00 pp In V (O I~ M ~p O " (O M pj (O In N' N
O O I~ M N M ~ ~ O ~ O V ~ V
~ ~ O
•~ r
•~ N M I~ ~p N M O p~ ~ p~ O
V ~ ~ r M In
N N
(D (D W ~ (D O O O O W O Ln M M O O O M
a
~ ~
~ ~
~
. N
M
.
. W
1~
. O
1n
. ~
~
. W W
M
. W
~
. (D
W ~
~ (D
(D
. (D
(D
. O
1~
. 1~
a
. r
. M
W
N W ~ W N ~ 1n (D ~ N N W 1n a
~
In a
1n N
n 1n
r ~
r M
O 1n
~ M
N N
~ ~
r r
r ~
~ ~
1n ~
1n N
N a
N W
r
1~ r ~ M r N ~ (D p In 1n (D
In 1n N M ~ O
I~
N r
N V
O M_ O O
In (O
~ In
V ~
00 f0
~ O
I~ O
M ~
O N_ N
~ N
~ ~
W O 1n I
O I
_ O W
r I~ In O N In N ~ N W ~ M N ~ I
a ~
0
~ m m r~ ui
~
M ~
~? V
I~ (
0
N ~
M V
M O
V
I~ r
a? ~ r
r N
~ O M
O ~
O M
O to
M I
r I
I~ r M N r In M ~ W ~ I~ M M O ~ I
00 ~ ~ r N N r ~
O O 0 0 0 0 0 0 0 O O O O O O O O O O
~ ~ ~
r
~ r ~
O O O O O O M M O O to ~ to O O V o0 N
M
N M
N 00
M N
O
O O
V O
O In
O r
f0 M
O f0
~ (p
W N
(O N
f0 I~
r O
In r
~
(O ~ M N O O O V O O O In ~
I~ r W o0 00 00 V O r M f0 O M M O N N
In ~ M N V M O W ~ In V ~ V N ~
V ~ r M O ~ ~
N N M
In
W
O
W
N
N
O
1n In
W
O
W
N
N
O
IA 0
O
1~
1~
W
In 0
(D
1~
~
In 0
1~
M
~
N
M 0 0
M
O
r
~ 0
(D
M
r
N
r 0
~
r
~
(D 0
(D
O
1~
In
O 0
~
r
N
W 0
N
N
r
~
(D
~ o
(D
M
~
1~
1~
1~ In
O
(D
N
r
In
W
r o
N
1~
~
N
O
M 0
N
n
~
N
O
M 0 0 o In
N
M
N
O
(D
W
(O
O ~
~ Q
N M
O O
V O I~
I~ W
M V
M f0
O O V
~ ~
r f0
r N
N N
N M
r
N M
M
M
00 00 In W N N M O f0 N N f~ N N N (O 00 00
I~ r V
(O In
00 ~ M
In V
M O
N ~
O M M ~
M ~
M r
M M
to N
M ~
~
M
00 ~ In to W M M ~ O a? ~ M ~ M V ~ N
~ ~ N r In O W ~ ~ 00 ~ MO
R
O
F
M
~ ~
!_
w Z R
U ~ (~
0
j j
~ U_ ~
~
Z
cq
~ LL
p
> N
~
cq
~
0 ~ > fi Z Q 7 N
- W .~. Z
Z
7
W N
N W
~ d
~O Z
W F
Z LL o
~ (A
J ~
Q 7
W
J ¢ Z vNi ~ Q M d J 2 U W Z ~ r
a ~ W W ~ ~ Q N w U ~ yN, ~ Z > U d' ~ ~ z
W
^ ~
J W
C~ ~ ~ N
~ N
~ C Q
Nf ~ d
M LL N
U ~ Q
U ~ M N
M z ~
LL U
3 I
U C~
Q
Z
Z ~ ~ (6 J (~
Q fl- ~ ~
N d ~
t N J
Q C W (6 O
(~ J
Q (6 (6 ~ W 01 N
~ s w
~ ~ m ~ ~ ~ s ~ s F w ~ s w °' s
O w
C7 (7 3 a
~ a ~ w a ~ U 2 ~ ¢
U U ~ ~ O ~ ~ C7 ~ U ~
C7 cq cq cq F ? cq ¢ cq
N
V
C
R
R ~
m C
'a N
C
7 ~
~ M
'a d
R ~ 0
z
L V ~
~ ~ d LL
y ~ M~M
0 ~ ~ W
O Q. ~ J
}~'' x ~ Q
V W r W
~ r 0
C ~
y O
~ N
d _
~ O
N ~
~ ~
~ ~
7
LL
Q
Z U
0 Z
Z J
W a
m
~ ~_
W G
LL N
~ M
F
to ~
W ~
~ N
7
~ M
0 N
Z
W
a
x
w
o rn
w w
H (Y
W ~
(7 H
0 0
~ Z
m W
a
x
w
vi w
Q J
Z m
~g
LL _
Q ~
F Q
0
F
to ~_
W G
LL N
~ M
F
rn
W ~
~ N
Z
W M
w
D to
w w
H 7
W Z
(7 w
0 ~
~ W
m ~
W ~_
Z o
Q ~
J p
m r
O
0
Z
7
LL
O O (O N M to V (O Q N O O O V O (p o0 I~ M W ~ (O O V
(O
M o0
N In
(O M
(O W
o0 _
N O (O
N M V
V O
o0 V O
O M
V M
M
V M
O ~
N V
r M
V N
(O V V
O V
`~ In
o0 M
V O V M O N M O In N r W I~ to O W
In M W _ V I~ N N M N O M O to W
N M N r r In M M M `-' N N M `-' M
I~ ~ r N r
M M
00 O o0 O O O O O O O O O M O In ~ O (p In O O O (~ (p O O
O O N O O M (O V V
~ ~ O (O O O V O ~
O O In M M r
I~
O ~
O
In
~ M
~ O
~ M
`-' ~
W
`-'
~ ~
O O I O M ~ O ~ ~ ~ ~ M I `N ~ O O ~ O O I~ ~ N ~ O O O `O
V 1 V
cn o cn o 0 o m o 0 0 o m a o 0 0 0 o a cn o 0 0 0 0 0
a a ~ O ~ r N r ~ r n O M r r N ~ M O ~ O O O
O ~ n O 1n O N (D N V (D O ~ O N M M M W M M O O
M O r 1n O ~ N ~ O N N O W O O N 1~ O O 1n
~ ~ r ~ N r N In 1n O 1n O 1n M O r (D W W
In 1n M M r N M ~ (D 1~ M M N r ~
1~ r r N a N
~ ~
In ~ O M M (O N N (D N Q In O M M O O M Q I~ W O O W Q
V
00 o0
N N M
O V
O
N
I~ O
~ O
V (O
I~ V
O O
O (O
O M
O
O
W O o0
O (O
N In
00 M
M O V V ~ N I~ M ~ O M I~ W I~ W V o0 In O M
M (O O W V (O V O V O In M to to V In O
M M N r r I~ O ~ In N N N M M r
r M r
~ ~
O O 1 0 O O O O O O O O 1 0 O O O O O O 1 0 O O O O O O O
O O O In M M M O V N O O o0 N O O O O (O N O O I~ M
V 00 M O 00 N O In Lfl In W In In N Lfl V N M I~
O N N M r N V In V O M In r M O O W (O (O V
In M O N M M r M O N I~ O O r
I~ ~ V In ~ W I~ W N 00 M N
In In In Lfl N
~ ~ r
N N
in o in o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1~ W O 1~ O N W ~ O ~ O 1~ r r (D (D 1~ a O M O
O O M (D 1~ O n N n W O M In N O M ~ M M O (D
1~ W r In N r ~ 1~ ~ M O (D O 1~ O O r O a r
N
N N
N M
N N
M r W
In O
M In
M M
M 1n
M N
1n O
(D n
a 1n
r W
M ~ (D
r W
~
O O r N In N
~ ~
(O
O O
O (O
O O
M W O
In M
O O
O M
V N
O O
O V
N V O I~
(O O O M
O V
V
V I~
V O O N
N
00
00 O o0 (O o0 (O N 00 M o0 In V N N o0 (O N CO
I~ O r M r I~ M O V N V O I~ W In M W In O N
In M W O r V r (p N ~ 00 00 M N V O
I~ W N r In V (O V In N M M
~ ~ r N
U
N
LL
C
N
(7
7 O ~
lL m 7
_ LL
`° ~ U d d d R
O U ~ ~ 7 C N O
¢
M ~ Q N C U N > N ~
Z
N
M
C
~
w
M N
~
M
LL (~
7 ~ ~ W E N M W ~ N N ~
a ~ ~ ~ n d w w ~~ d
J W ~ Z U ¢ O ~ R Q d ~
U J ~ N
F ~ ~ ~ >. (6 U U ~ M i
Z ~ E w W ~ ~ ~ ~ w
~ m t J
Z ~ (7 U a ~ ~ > u
i ~ ~ li w w
W Z O O W S O O O O O O O r
~ W O O ~
~ ~ ~ d N N N N N N N N
m
T C
N ~ ~
~ -6 N U
d N Q ~
a -°
M N
_ otf C
N U U R
~ Y ~ •^w y0
J m 01 ~ F
N ~. 7
X ~ ~ ~ ~ Vl
~ w
H J N N ~ (6
N ¢ m m o ~
O C7 H M M N N
N ¢ ¢ N
R LL H H ~ t
a cq cn Q Q U 2
N N Q In M O
O O O O O
F N N N N N N
C
W
U
Q
N
N ~
E ~ d
(6
C `pl ~ N
3
W O
a`
N
'~ U ~ 01
N N
^ fn T ~ y ~ U
d d d~ R> ~
r 01 ~ U ~ ~ \
~ Q ~ ~ C
U X
c ~ (7 J ¢ fq m D
0
•> N M Q r N M
W O O O N N N N
N
V
C
fC
fC ~
m C
'a N
C
7 ~
~ M
'a d
fC ~ D
z
L V ~
~ ~ d LL
y ~ M~M
0 ~ ~ W
O Q. ~ J
r X OL Q
U W r W
~ r 0
C ~
y O
~ N
d _
~ O
N ~
~ ~
~ ~
7
LL
Q
U W
Z U W
I~ O
O O I~
M In
r V
O V
N V
O M
M In
N O
N In
V W
M O
N ~
M O O O O O
O Z ~ N O In M N M ~ O r O (O O M
I~ W
Z Q (O In O W o0 O O 00 00 V M In r N O
J I~ In N N r In In N M M O W (O In
W
Q N N V O M V o0 O
m N V V
~~ O M O O O O O O O O O O O O O O O O O O O
W N M ~ ~
LL ~ N ~ N
F
~~
W O o0 O V (O O V o0 M O O O N O V (O (O M In r O
~ N O
O V
In V
M In
O N
M In M
N V
O M
M N
M In
N M
r W
W
O O
O I~
ln
~~
l~
M
N
r _
In
O
r
W
V
M
M
M
O
M _
~ M N W ~ ~ O ~ ~ ~ ~ N r
Z ~ ~ M ~ `-' `-' ~
~ ~ ~
W
a
x
w
O M O (D O O O O O O O O O O O O O O In M O ~
W W O O ~ In M W O O (D M ~ (D M In M W
H d' O O (D N N (D 1~ 1n 1n 1n ~ ~ W In r N M
W 7 In pj W M N N N W N N pj O pj W (D O pj 11j
(~ H ~ O 1~ N N M ~ (D In N M ~ N
0 0 n M r M N O W ~ ~ N M ~ a
~ Z M r W ~ N
m W r
a
x
w
y w
0 J o 0 o v oo
~ M m u~ o u~ o
~ rn o ~ m M u~ ~ o
~
Z m ~
I~ In W
N M
~ N
M I
M M
O ~
~ N
V N V
In I
N N
O W
W 00
O (O
I~ 00
W O O
O I
In
~g
LL -
W ~ M ~ ~ ~ o ~ -
~ ~ ~ ~ ~ - ~ M M o M
J Q O
M O
M (O N
r In
M O
V V
M I
M M O
V M
(O M r
I~ V
r r o0
N In
Q ~ N In In In r I~
F Q
0
F
~ ~ O o o O O O O O o O O o O O O o ~ ~ In O o
W N r W O O ~
LL ~ M ~ O M
Z M ~ N r
~
~ r
~
F
~~ M O O In O N W V W M O M M O W M O O O O O
W I~ W V O W O W W O N V 00 In
7 N M O I~ M O r V I~ ~ O O W O
Z O (O I~ M V I~ W M V O ~ V
W M
~ W
N ~ M In ~ O W
V M V o0
M r O
M
~
O M
W W O
(D O
1~ O O
~ O
~ O
W O O
M O
M O
W O
W O
(D O
In O
(D O
M O O ~
(D N M
~ O
H ~
N
M
(D
M V
~
O
(D
(D
M
M
~
~ ~
1~ M
W
<D
(D
(D a
W Z r M In N 1n ~ M M M r r r O ~ ~ M ~ W 1~
(~ W a r n O O r N N O (D (D N M ~ N
0~ N N r M N ~ r r In r O ~
7 W M M a r m
m LL _
W ~
U In O O In N N O W I~ W O 00 V O O V O O O O O
o
Z N O
V V
N O
V O
00 M
In O
r M ~
N M
M M
M V
N o0
~ M
O
Q~ M (O o0 (O M CO V V M (O O
J p
Q o0 (O N I~ O
N W
M In
00 M
M M
M In
N M N
M
m O _ lO lO
N N
~
~
~
~ C
~
N
N
O O r C~ U O
t C N
N O
R ~` .R. Q O a s
v ~ ~ ~ ~ m U
. r ~ a
y ~ O 01 ~ N M ~ ~ U N
R R 0 O y O R R R W R 3 ~ ~ R ~ R
O O fn ~ fn W O ~ O W ~ Q O ~ O N O
~
C
i
~
J
~
W O F
y
N > N F
S
M >~ ~
7 ~
7 E i i i S
7 S
7 N C N
> S
7 '
"
U ~
Q U
N N
Z R ~ ~ H ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ o o ~ o d ~
w ~ ~ ~ m a E a
~ z
d H rn a a a rn r ~ ~ ~ . ~ ~ ~ U
Q W R Q J U U U J N
' Q W w ~ ~ 3 0 r ~ 7 U N
~ W C 01 d ~ N N N ~ t .~? J d -O N ~ Z •G- N ~ N N
Z ~ ~ ` `' ~ w LL
E
~ R
fn R
J R
J R
J
fn otf 3
d Q
U
Q O
Z O
U U N
~ O
U R
d .`.
M
Z Q p ~ ` ~ a ~
~
U ` C N M Q In y r }' N M ~ ~ O O O O
p
W
W >
C N
R O O O O O
~ O R
N O O O d
~ O O O O
~ ~ d
W M
N R
d
r2 ~
N ~
N ~
N ~
N ~
N
U W
N 00
N
2 O
N O
N O
N Q
U M
M V
M In
M M
M
0 ~ U
LL t7
N
V
C
fC
fC ~
m C
'a N
C
7 ~
~ M
'a d
fC ~ D
Z
L V ~
~ ~ d LL
y ~ M~M
0 ~ ~ W
O Q. ~ J
}~'' x ~ Q
V W r W
~ r 0
C ~
y O
~ N
d _
~ O
N ~
~ ~
~ ~
7
LL
Q
O O o0 00 N In M O M O N O M r M O W I~
N
~ N
~ In
M M
M N
O M
In O
M ~
M V
M M
r V (O
r I~ M
V (O
O In
O M
O V
V O M
r
r I~
M M
In V
(O In
O N
r
M M In V (O M o0 00 00 O V In W (O N (O In V
O
O O
V O
V O
O O
M N
M W
V M
O O
M M
M r
r W
M
M (O
r o0 In
(O M M V I~ N_
r r r I~ N W N N N
(p (p O O V ~ O M In O O O In ~ O O O O O O O O O O
I~ r M M O N M
_ ~ 00 00 O
(O (O In V O N
00 00 `-' I~ O
O O O O O O O O O O O O O O (O O O (~ O O M (O O
O
O O
O o0
N M M
r N r
V In
(O N
I~
O O o0 I~ r O O M
O O N (O o0 ~ ~
Z U
0 Z
Z J
W a
m
~ ~_
W ~
LL N
~ M
F
~ ~
W ~
j N
~ M
0 N
Z
W
a
x
w
O O O O O O O O O O O O O O N O O O (D O O O O W
W W O M M O V O r O W W O M O (D
~ ~ O In r M ~ O O r W M (D (D O (D
N N ~ ~ W W W a a ~ n ~ N r N N
N N 1~ N O V 1n N (D (D (D ~ ~ W (D ~
N N M r N M ~ In M 1n M (D M r In
M M r r M N r In
o ~
W W
H ~
W ~
H
0 0
~ Z
m w
a
x
w
CO CO 00 00 I~ (D (O Q In (D V CD In ~ W N W Q I~ ~ N
O O M M M O ~ M M V (O (O O M In V M (O I~ r O M V
M M M M ~ M ~ M ~ N O M O V N M M O O O W
O O _ _ M O M M M o0 00 O I~ M o0 M o0 N (O O In r
O
O O
O O
V O
V O I~
(O N
In W
V W
O O
M In M
M r O
W
M M
r
I~
V M N
N M
In r M
O
r r r r 00 N 00 N N M
O I O O I O O O O O O O O O O I O O O O O O O O O O I O
vi w
Q J
Z m
~g
LL _
J Q
Q ~
oa
F
~ ~
W ~
LL N
~ M
F
O O O O O N V In M O V V In r O W V (O O M (O o0 O
N N M M N N N M O I~ O N W (O V I~ M ~ O O N
In M M M V (O r O N N N N I~ W V N r r O M V o0 O M
M M V V N O I~ M O N M M (O In O N V N V O V O
M M ~ r N O W r ~ In O V (O M
V V M M r o0 _ r N In V
a0 a0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O O O ~ In ~ N ~ N ~ V W O W N
1~ r ~ ~ M M N ~ O N (D O N N (D ~ In W O N 1~
N N N N 1~ M W W M r ~ N W W In ~ N N ~
O
In O
1n O
N O
N O
r W In
In W
r a
~ ~
r W
r N 1~
N
M O
r
~ (D ~
M N
O
W W r M
I~
I~ ~
r W
W 00
o0 I~
M V
O N
I~ O
M O
M 00
W In
I~ ~
M O
M M
W O
M M
O O
O V
M I~
O O
M N
O In
M N
N
O O O O I~ O M W r O o0 V In W I~ N O V In N O N
CO
00 (O
00 In
M M
M M
~ O
(O O ~
I~ V
r V
N I~
M M
N M
M (O
O N
M
M
O M
M N
N O
V ~
M
In M r r O M M V O r (O O I~ N r (p N M (O
M M ~ r r " r I~ N W N N r
y
W ~
~ N
Z
W M
W ~
d'
D M
w w
H 7
W Z
(7 w
0 ~
~ W
m ~
W ~_
Z ~
a N
J p
m r
O
D
Z
7
LL
N R R
~ F F
M LL ~ N ~
~ - ~ ~ M
Z ~ y
LL U U
J ~ Q
Z W '_-' U E
W LL .R ~ N
z F ~ d
U
W Q ~ O_ o
~ d ~ N
0 2 d V LL V
C7
N
N
U N
~ ~ U
'~
_ C _
~ ~ R ~ ~ i T R
N M ~ N 3 ~ D !Z ~ ~ N d ~
w N ~ Q ~ ~ N ¢ t ~ ~ C 7
01 01 01 ~ R t N ~ f/1 LL N ~ ; U °~ y ~ f/1
(6 (6 (6 Q > d ~ U (~ ~ U T C Q C N ~
U U U ~ ~ ~ C~ .o > > ~ ~ m ~ ~ C ~ ~ y
H H H w m > O> o~ _rn w u~ ~ -o '~ ~ ~ ~~ Z
~ ~ ~~ ~ F R Q '- v1 'o ~ o '3 a R R d w ~
~ w m~ Q a ii z m w a~~ a }
N M Q In W r W W Z N M V
jp O O O O O O O O O ~ O O O O O O O O In Z
F V V V V V V V V V F (O (O (O (NO (MO (~O (MO (00 (00 W
Z ~
Q
N
U
C
R
R ~
m C
'a N
C
7 ~
~ M
'a d
fC ~ D
z
L U ~
~ ~ d LL
y ~ M~M
0 ~ ~ W
O Q. ~ J
}~'' x ~ Q
U W r W
~ r 0
C ~
y O
~ N
d _
~ O
N ~
~ ~
C ~
7
LL
Q
Z U
0 Z
Z J
W a
m
y ~_
W ~
LL N
~ M
F
~ ~
W ~
j N
~ M
0 N
Z
W
a
x
w
p ~
W W
H ~
W ~
H
p p
~ Z
m W
a
x
w
vi w
Q J
Z m
~g
LL _
J Q
Q ~
F Q
0
F
y ~_
W ~
LL N
~ M
F
y
W ~
~ N
Z
W M
w
p~
w w
H 7
W Z
(7 w
p
~ W
m ~
W ~_
Z ~
a N
J p
m r
O
y
D
Z
7
LL
M r N r
o0 In O N
V O In O O M M M
(O N In V V M o0 (O
I~ W In V O V N
I~ N N V (O 00
I~ W I~
O O O O O O O O
M
O In ~ V (O
In
(O N
N M
In
V W
In M_
~ (O
~
00 M V (O N M In N
N
~ I~
~ M
In
~ V
O `-' `-' O
O
M
N
O O O O O O O M '.
O
n O
r In
r N
r n
a M '..
~
W W (D W In
N N W
N N 1~
(D
o'
n o rn ~ 0 0 °~ ~
o
o
O N O M In r N M
o
N O W O N V (O O
r O O
V
O O O o O O o 0
r
~ ~ W ~ ~ V ~ N
l
~ ~
O O N N (O
M V ~ N In
M
0 0 0 0 0 0 o in '..-.
'
.
M
,.-
N ',.
~ ',..
W ',..
N M
N (O ~ V N M
M (O N N M N (O o0
M O M (O V o0 N
~ M N
N In (
O ~ N V
I~ W M
O
T
U
C
N
01
Q
N ~
3
H W
~ N
O i
C ~
•-~ m
w a
>_ O
y m ~
o w .s m a
~ ~ ~ w U
LL LL p U Q
r
U y ao
Z ` O r O
W F ~ ~ ~
C7
Q
R
O
F
R p R 'O
O y p =
~ O R
s v = s C7
~
y R ~
s ~ U
~ ~
y
~ m R
~
N ~ w
R ~
= o ~
~
.~
v ii ~
0
~ ~ N
~
CHANGE FORM #:
MID-YEAR BUDGET CHANGE FORM FISCAL YEAR 2011/2012
REVENUE ACCOUNTS
DECKEASE BLll(:ETS INCKEASE BUDGETS
ICI.CKI~:-~SI~:IiI~DGI~;'I'.1000l~V~I' 1~~lOl~A'I' 1..1CKI~::151~:Iil!I)GI~;~I'.1C('Ol!V'I' ;A~lOl~V'I'
General Fund -REVENUE -
Name: Unsecured Property Tax
($15,000) General Fund -REVENUE -Sales
Name: & Use Tax
Account. 1001-0000-41102 Account. 1001-0000-42101 $375,000
General Fund -REVENUE - In-
Name: Lieu Property Tax
(29,810) General Fund -REVENUE - In
Name: Lieu Sales Tax
Account. 1001-0000-41103 Account. 1001-0000-42102 $125,000
General Fund -REVENUE -
Name: Property Tax Penalties
(85,000) General Fund -REVENUE -
Name: Transient Occupancy Tax Tax
Account. 1001-0000-41303 Account. 1001.0000.42301 $180,000
General Fund -REVENUE -
Name: Interest
(225,000) General Fund -REVENUE -
Name: Electric Franchise Tax
Account. 1001-0000-46101 Account. 1001.0000.42401 $54,350
General Fund -REVENUE -
Name: Motor Vehicle License Tax
(180,000) General Fund -REVENUE -Gas
Name: Franchise Tax
Account. 1001-0000-47201 Account. 1001-0000-42402 $4,430
Name: General Fund -REVENUE -
Name: Garbage Franchise Tax
Account. Account. 1001-0000-42403 $40,000
Name: General Fund -REVENUE -
Name: License/Permits- Building
Account. Account. 1001-8102-44231 $1,000,000
Name: General Fund -REVENUE -Fire
Name: Alarm Plans
Account. Account. 1001-2402-48301 $10,000
Name: General Fund -REVENUE -Fire
Name: Sprinkler /Underground
Account. Account. 1001-2402-48302 $95,000
Name: General Fund -REVENUE -Fire
Name: Plan Check Fees
Account. Account. 1001-2402-48305 $17,600
Name: General Fund -REVENUE -
Name: Planning & Zoning Fees
Account. Account. 1001-8101-4891 1 $382,000
Name: General Fund -REVENUE -
Name: Engineering Plan Checking
Account. Account. 1001-8301-48921 $236,000
Name: General Fund -REVENUE -Waste
Name: Management Admire Fee
Account. Account. 1001-0000-4851 1 $35,000
General Fund -REVENUE - ABAG
Name: PLAN GRANT
Account. 1001-0000-48511 $46,000
Reason for Budget Change: To reflect budget changes to Revenue Accounts proposed as part of the City's mid-year review
of financial activity as of December 31, 201 1 for Fiscal Year 201 1/12- per the report to the City Council 3/3/12.
\ti ;l~~~n~~~c~l ,it thr ('it~~ (~~xmril ,A-lcctin_ un: 3/3/?Ill?
Y~~sted B Date:
Page 1 of 4 Attachment 7
CHANGE NORM #:
MID-YEAR BUDGET CHANGE FORM FISCAL YEAR 2011/2012
REVENUE ACCOUNTS (SPECIAL REVENUE /NON-GENERAL FUND)
DECREASE BUDGETS INCREASE BUDGETS
~)I~;("RI~;.~S1~; l3llllG1~'I'.~C("Ol1N"I' .~1l~IOl1N"I' INCRI~;AS1~ 1311llC1~'I' ~~("COUN"I' ~~I~IOUN"I'
TRAIIIIIC SAIIETY I1UND -
REVENUE - Intergovernmental
State -Other State Grants
Name:
38,380) State COPS Grant I1und -
REVENUE - Intergovernmental
State
Name:
100,000
Account: 2103-0000-47261 Account: 2103-0000-47261
STATE GAS TAX TUND -
REVENUE - Intergovernmental
Name: State (Section 2105)
(32,000)
Affordable Housing Tund -
Name: Developer Contributions
300,000
Account: 2201-3201-47251 Account: 2901-0000-49161
STATE GAS TAX TUND -
REVENUE - Intergovernmental
Name: State (Section 2106)
($12,000)
Account: 2201-3201-47252
STATE GAS TAX TUND -
REVENUE - Intergovernmental
Name: State (Section 2107)
(7,000)
Account: 2201-3201-47253
STORM WATER TUND -
REVENUE - Intergovernmental
Name: State -Other State Grant
498,300
Account: 2321-0000-47261
Reason for Budget Change: To reflect budget changes to Revenue Accounts proposed as part of the City's mid-year
review of financial activity as of December 31, 2011 for Fiscal Year 2011/2012 per the report to the City Council 3/3/12.
Posted By: Date:
Signature
Page 2 of 4 Attachment 7
CHANGE FORM #:
MID-YEAR BUDGET CHANGE FORM FISCAL YEAR 2011/2012
GENERAL FUND OPERATING EXPENDITURE BUDGET ACCOUNTS
DECREASE BUDGETS INCREASE BUDGETS
ni,c~icASC i~cncc~r ~~ccOUh r An-~ovh r ih~C[icASC i~cncc~r ~~cCO~~h r ~~~OUh~„i.
Name: Legal Services-T'rof Svcs Litigation
Account: 1001-1501-65105 $111,000
Non-Departmental -Budgeted
Name: Contingency
Account: 1001-1901-81101 $100,000
T'olice Services -Crime T'revention
Name: T'rogram -Contract Services
Account: 1001-2105-64001 $19,500
Building & Safety -Contract
Name: Services
Account: 1001-8102-64001 $300,000
Engineering -Inspection T'rivate
Name: Development
Account: 1001-8301-64093 $260,000
Economic Development -
Name: Community T'romotion Supplies
Account: 1001-8401-61118 $21,000
Economic Development -Contract
Name: Services Community Events
Account: 1001-8401-64089 $7,500
Reason for Budget Change: To reflect budget changes to General Fund Expenditure Accounts proposed as part of the
City's mid-year review of financial activity as of December 31, 2011 for Fiscal Year 2011/2012 -per the report to the City
Council 3/3/2012.
ids ~~~i~u~ovrcl at ttic Cite C~wncil ~ti1rrtin~ on: 3/3/2012
Y<~•~~d By: llu~~:
Signa~urc
Page 3 of 4 Attachment 7
CHANGE FORM #:
MID-YEAR BUDGET CHANGE FORM FISCAL YEAR 2011/2012
SPECIAL REVENUE FUNDS -EXPENDITURE BUDGET ACCOUNTS
DECREASE BUDGETS INCREASE BUDGETS
ni,c~u.ASC i~cncc~r ACC~~~'h r A~~OUh r ihc[icASC i~cncc~r ~~cCO~~h r A~~Ot;~;,.~.
Name: State COT'S Grant 1+'und - T'olice
Services (T'atrol)- Contract
Services - T'ersonnel
Account: 2103-2102-64021 $100,000
Name: Measure BBike / T'ed 1+'und-
T'ublic Works Admire-Salaries
Account: 2205-3 1 0 1-5 1 1 0 1 $10,690
Name: Capital T'roject 1+'und-GIS
T'roject- Machinery &
Equipment
Name:
Measure D Recycling Fund- Waste
Management -Contract Services
Account: Proj Acct: 930004.9600.9605.2106
GL Account: 3300.9301.72102 ($38,380)
Account:
2304-5101-64001 $20,000
Name: Capital T'roject 1+'und-Shannon
T'arking Lot-Improvements
Name: Capital T'roject 1+'und-Speed
Feedback Signs-Improvements
Account: Proj Acct: 950014.9400.9401.2321
GL Account: 3500.9501.73103 ($489,300)
Account: Proj Acct: 960024.9400.9401.2201
GL Account: 3600.9501.73103 $1,815
Transfers Between Funds:
Name: Traffic Safety T+'d Transfer Out Name: CI[' Oren Impv Transfer In
Account: 2106.9301.89101 (38,380) Account: 3300.9301.49999 ($38,380)
Name: Storm Water Mgt Transfer Out Name: CI[' T'arks Impv Transfer In
Account: 2321.9501.89101 (489,300) Account: 3500.9501.49999 ($489,300)
Name: Cras Tax T+'d Transfer Out Name: CI[' Oren Impv Transfer In
Account: 2201.9601.89101 1,815 Account: 3600.9601.49999 $1,815
Reason for Budget Change: To reflect budget changes to General Fund Expenditure Accounts proposed as part of the
City's mid-year review of financial activity as of December 31, 2011 for Fiscal Year 2011/2012 -per the report to the City
Council 3/3/2012.
P<~~~rd By: Duly:
Signature
Page 4 of 4 Attachment 7