CC 2018-02-27_12a FY 2017-18 Mid Year Budget Report
MEMORANDUM
TO: CITY COUNCIL
FROM: JIM BERGMAN, CITY MANAGER
DEBBIE MALICOAT, DIRECTOR OF ADMINISTRATIVE SERVICES
SUBJECT: CONSIDERATION OF FISCAL YEAR 2017-18 MID-YEAR BUDGET
REPORT
DATE: FEBRUARY 27, 2018
SUMMARY OF ACTION:
Consider adjustments to the City’s budget at the mid-point of the fiscal year.
IMPACT ON FINANCIAL AND PERSONNEL RESOURCES:
Additional appropriations or budget adjustments are reflected in the ending fund
balances for all funds as detailed in Schedule A attached to the Mid-Year Budget
Report. The recommended budget adjustments are anticipated to have a minimal
impact on staff workload.
RECOMMENDATION:
It is recommended the City Council:
1. Approve detailed budget adjustments and requests for additional appropriations listed
in the Mid-Year Budget Report; and
2. Approve Schedule A attached to the Mid-Year Budget Report.
BACKGROUND:
Each year, the City Council adopts a budget, which commits resources to the
accomplishment of its policies. The Administrative Services Department prepares
periodic budget updates for the City Council.
The purpose of the City's Mid-Year Budget Report is to:
• Compare revenues received and expenditures made to budgeted amounts to
determine appropriate adjustments.
• Provide a link between the City budget, the financial records, and the
independent financial audit.
• Compare current revenues and expenditures against the prior fiscal year.
Item 12.a. - Page 1
CITY COUNCIL
CONSIDERATION OF FISCAL YEAR 2017-18 MID-YEAR BUDGET REPORT
FEBRUARY 27, 2018
PAGE 2
ANALYSIS OF ISSUES:
As detailed in the attached Mid-Year Budget Report, the City is currently facing a mixed
fiscal picture. Revenues in many General Fund categories are increasing and economic
indicators are generally favorable. The City has strong reserves and a diverse revenue
stream, which will be important in facing the upcoming challenges associated with
increasing retirement costs, deferred infrastructure maintenance, and other unmet
needs.
The current projected available General Fund Balance for June 30, 2018 is $6.4 million.
This projected fund balance represents 36% of appropriations, which exceeds the City
Council fund balance goal of 20%. The increase in the projected fund balance is largely
due to one-time savings in the prior year and higher than expected revenues in the current
year. The projected Fund Balance assumes revenues are received exactly as budgeted,
all budget expenditures are made, and all capital transfers required by the Capital
Improvement Plan Program are completed. Historically, the General Fund has not been
required to fund all budgeted capital transfers and expenditures at year-end are
traditionally less than budgeted.
As described more fully in the Mid-Year Budget Report, staff is recommending several
minor adjustments to the FY 2017-18 budget in order to address needs that are
unanticipated and necessary. In addition, the Report includes budget adjustments
directed by the City Council to-date.
Historically, the Mid-Year Report is based on the completed Comprehensive Annual
Financial Report (CAFR) or audited financial statements. This year, due to capacity
constraints, the audit is not yet complete and the CAFR has not been presented to the
City Council. No significant variance in any fund balances is anticipated with the
completion of this work, which is expected to be completed in the next month.
ALTERNATIVES:
1. Approve the recommended budget adjustments and Schedule A of the Mid-Year
Budget Report;
2. Modify and approve the recommended budget adjustments and Schedule A of the
Mid-Year Budget Report;
3. Do not approve the recommended adjustments or Schedule A; or
4. Provide further direction to staff
ADVANTAGES:
The Mid Year Budget Report provides an updated review of the City finances in the
current fiscal year, allocates additional funding to meet unanticipated needs and complete
projects, and maintains a fund balance that exceeds the City’s minimum reserve policy
amount.
Item 12.a. - Page 2
CITY COUNCIL
CONSIDERATION OF FISCAL YEAR 2017-18 MID-YEAR BUDGET REPORT
FEBRUARY 27, 2018
PAGE 3
DISADVANTAGES:
Based on the recommendations, departmental budgets maintain current service levels, no
significant new projects or programs are recommended.
ENVIRONMENTAL REVIEW:
No environmental review is required for this item.
PUBLIC NOTIFICATION AND COMMENTS:
The Agenda was posted at City Hall and on the City’s website in accordance with
Government Code Section 54954.2.
Attachment:
1. Mid-Year Budget Report
Item 12.a. - Page 3
City of
Arroyo Grande
Administrative Services Department
MID-YEAR BUDGET REPORT
FISCAL YEAR 2017-2018
ATTACHMENT 1
Item 12.a. - Page 4
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
2
Table of Contents
Overview ........................................................................................................................................................................3
Summary of Key Points................................................................................................................................................3
Budget Changes Approved To-Date ..........................................................................................................................4
Mid Year Budget Changes ...........................................................................................................................................4
General Fund Expenditures: ...................................................................................................................................5
General Fund Revenues:..........................................................................................................................................7
Other Funds: ..............................................................................................................................................................7
General Fund Overview ...............................................................................................................................................7
General Fund Revenues ...............................................................................................................................................9
General Fund Expenditures ........................................................................................................................................10
Other Funds ...................................................................................................................................................................12
Attachments ...................................................................................................................................................................12
Item 12.a. - Page 5
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
3
Overview
The City’s Mid-Year Report is prepared to compare the revenues and expenditures occurring during the first six months
of the fiscal year against budgeted amounts to determine appropriate adjustments; to provide links between the City
budget, the financial records, and the independent financial audit and; to compare revenues earned and expenses made
during the first six months of the Fiscal Year (FY) 2017-18 against the FY 2016-17 figures. This information is provided in
the following format:
Schedule A: The starting point is the FY 2016-17 ending fund balances, which is also the beginning Available Fund
Balance for the FY 2017-18. Combining the beginning Available Fund Balances with the estimated revenues, transfers,
and appropriations adopted in the Biennial Budget and this report, provides the estimated ending fund balances.
As a result of a comprehensive review, adjustments are recommended where actual receipts and disbursements are
materially different from the budgeted amounts. Although budget adjustments are recommended across several City
funds, typically the emphasis of the Mid-Year Budget Report is directed at the General Fund. The General Fund is
deemed to be the most critical as it provides most services commonly associated with government (i.e., public safety,
recreation, parks, building, public works, planning, etc.) and is limited primarily by tax-generated revenues.
Historically, the Mid-Year Report is based on the completed Comprehensive Annual Financial Report (CAFR) or audited
financial statements. This year, due to capacity constraints, the audit it not yet complete and the CAFR has not been
presented to the City Council. No significant variance in any fund balances is anticipated with the completion of this
work, which is expected to be completed in the next month.
Summary of Key Points
The City is currently facing a mixed fiscal picture. Revenues in many General Fund categories are increasing and
economic indicators are generally favorable. The City has strong reserves and a diverse revenue stream, which will be
important in facing the upcoming challenges associated with increasing retirement costs, deferred infrastructure
maintenance, and other unmet needs.
Minor adjustments to the budget are recommended at this time. There are no significant new initiatives or emergency
issues that require budget amendments.
Item 12.a. - Page 6
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
4
The City Council has established an Undesignated General Fund Balance goal of 20 % of annual appropriation with a
minimum goal of 15%. The City’s Undesignated General Fund Balance represents the available r esources to provide
funding for future contingencies such as earthquakes, civil unrest, economic fluctuations, major infrastructure repairs
and investment in capital for improved productivity and efficiencies. Inadequate reserves increase financial risk,
negatively impact cash flow, and reduce the City’s ability to attract and sustain economic development and growth.
The current projected available General Fund Balance for June 30, 2018 is $6.4 million. This projected fund balance
represents 36% of appropriations, which exceeds the City Council fund balance goal of 20%. The increase in the projected
fund balance is largely due to one-time savings in the prior year and higher than expected revenues in the current year.
The projected Fund Balance assumes revenues are received exactly as budgeted, all budget expenditures are made, and
all capital transfers required by the Capital Improvement Plan Program are completed. Historically, the General Fund
has not been required to fund all budgeted capital transfers and expenditures at year-end are traditionally less than
budgeted.
Budget Changes Approved To-Date
Various budget changes have been approved by the Council or City Manager, as appropriate, since the adoption of the
original Budget in June 2017 and reflect changes made through December 31, 2017. These include previously approved
changes to salaries and benefits of approximately $84,200 for all bargaining groups and unrepresented employees as well
as minor adjustments to capital projects and operating budgets.
Mid Year Budget Changes
As part of the mid-year process, departments were asked to review their current budgets and determine if any adjustments
should be proposed in this report. Departments have been asked to closely monitor their budgets and spend only what is
necessary. At this time, only minor adjustments are recommended to the General Fund departmental budgets that are
necessary due to timing considerations, increases that are supported by additional revenues, and one-time project funding.
Item 12.a. - Page 7
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
5
General Fund Expenditures:
Summary of Requests
Inspection & Plan check contractual services 40,000 *
Coverage for employee medical leave $25,000
Fire hazard fuel modification 12,000 *
Grant match for countywide Hazard Mitigation Plan 4,500
Software licenses 3,500
Increased citywide water use 50,000
Increased citywide electrical costs 40,000
EVC Diablo closure economic study 28,800
Total General Fund $203,800
* Indicates revenue offsets
As summarized above, additional expenditures for FY 2017-18 totaling $203,800 in the General Fund are recommended.
Additional information is provided for each request below.
Community Development – Recent development activity has increased and a commensurate demand for inspection
and plan check services has resulted. In order to meet these needs in building and stormwater compliance, additional
contractual services totaling $40,000 is required. These additional costs are expected to be fully offset by fee revenues.
Second, the Department has an employee on extended medical leave. Contractual services will be required in order to
continue providing building services to the community. It is anticipated that these costs will not exceed $25,000.
Fire hazard fuel modification – With the recent wildland fires to the south, City staff evaluated several
urban/wildland interface areas to assess vulnerability to similar fire threats. In response, a fuel reduction effort in
areas near the James Way open space and other property in the city will be undertaken, primarily through the use of
the California Conservation Corp. City staff has applied for grant funding from the Fire Safe Council, therefore some
or all of the $12,000 cost may be offset if the grant is successful.
Countywide Hazard Mitigation Plan – The City has a current Hazard Mitigation Plan that is due for updating. There
is an effort to prepare a countywide Hazard Mitigation Plan and grant funding may be available for a portion of the
Item 12.a. - Page 8
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
6
costs. The City would be required to provide matching funds of $4,500 for this effort. By comparison, it is estimated
that a stand-alone Hazard Mitigation Plan would cost the City over $14,000.
Software Licenses – Staff has identified additional licenses that are needed across the City to provide for Adobe
software products. A budget augmentation of $3,500 is needed in order to provide for legal compliance with the
software licensing.
Citywide water and electricity utilities – The current budget for citywide water use was developed during the
drought and anticipated a continuation of restricted water use at City parks. In addition, a one-time event at the Soto
Sports Complex at the beginning of the fiscal year caused the need to use potable water on the fields for
approximately a six week period. The fields had just been reseeded when the well that normally provides water to the
fields experienced a pump failure. In order to provide water to the newly planted grass, potable water was used on
the fields which resulted in water costs of approximately $8,500. With this, in addition to the lack of rainfall to-date
and higher than normal temperatures, staff estimates the current budget for citywide water will need to be increased
by $50,000 for the balance of the fiscal year.
City electricity costs have also increased more than estimated in the budget. In analyzing the situation, there appears
to be several factors contributing to this. First, the previously mentioned situation at the Soto Sports Complex
required additional electricity costs to pump the potable water onto the fields. This was a one-time event that is not
expected to recur in the future. In addition, overall electrical use is slightly higher than in previous years and
electricity rates have increased by more than the budget originally projected. An increase of $40,000 is recommended
for the balance of the fiscal year.
EVC Diablo closure economic study – As the City Council is aware, the City has been participating with other local
agencies in efforts to understand, quantify and mitigate the eventual closure of the Diablo Nuclear Power Plant. The
Economic Vitality Corporation (EVC) has spearheaded the efforts to study the economic impacts of the closure. All
participating agencies have provided financial support to this effort. Recently, the EVC requested additional funding,
of which the City’s identified share is $28,800.
Item 12.a. - Page 9
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
7
General Fund Revenues:
Additional budgeted revenues are proposed totaling $237,200 for FY 2017-18 in the General Fund. Significant variances
are described below.
Sales Tax – Based on the most recent estimates from the City’s sales tax consultant, an increase of $22,300 is projected.
Transient Occupancy Tax – Based on year to date results, revenues are expected to be nearly $30,000 higher than the
prior fiscal year, but not as high as the original budget. A reduction of $34,300 is projected.
Building & Planning Permits and Fees – Due to the increase in activity, an increase in building and planning
revenues of $73,900, approximately $65,000 of which is a direct offset for additional contractual services required, as
mentioned previously in this report.
Sale of equipment/materials – As previously approved by the City Council, the Mid-Year budget reflects the sale of
surplus police vehicles, estimated at $100,000. The proceeds of the sale have been allocated to the purchase of new
light bars, sirens and other equipment needed for the replacement police patrol fleet.
Other Funds:
Local Use Tax Fund (Fund 218)
Based on past trends, revenues are slightly lower than original estimates. Staff recommends decreasing the anticipated
revenue by $71,600 along with decreases in the spending plan of $46,500. This will eliminate $25,000 in funding set aside
for contingencies as well as a project on Alpine Street that will be reevaluated during the upcoming Biennial Budget
process.
In general, revenues and expenditures in all other funds are on target with projections and prior year trends. No other
adjustments are required at this time.
General Fund Overview
Revenues are currently 40% collected and expenditures are 49% spent. This reflects the fact that not all revenues and
expenditures occur evenly throughout the fiscal year. Significant variances are discussed later in the report, but in
general, this trend is consistent with prior years. As reflected on the following chart, collecting approximately 40% of the
Item 12.a. - Page 10
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
8
General Fund revenues by the mid-point of the fiscal year is consistent with past trends.
After Mid-Year adjustments are recorded, the June 30, 2018 fund balance in the General Fund will be approximately $6.4
million, if all budget projections are fulfilled. However, at June 30, 2018, the City may find that revenues have not met the
budgeted projections and not all budgeted appropriations will be spent as year-end actual expenditures are traditionally
less than budgeted amounts.
Shown on the following page is an overview of the revenues, expenses, and transfers for Fiscal Years 2017-18 and 2016-17
as of the mid-point of each fiscal year. As reflected, both revenues and expenditures are higher in the current fiscal year
than they were at the same point in time last year.
40% 40% 40% 39% 38%
0
5,000,000
10,000,000
15,000,000
20,000,000
25,000,000
2016-17 2015-16 2014-15 2013-14 2012-13
Revenue: % Collected at Mid Year
Mid Year Year End
Item 12.a. - Page 11
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
9
General Fund FY 2017-18 FY 2016-17 Variance
Revenues:
Mid-Year Actual $5,496,889 $5,255,433 $241,456
Mid-Year Transfers 1,328,640 1,271,952 $56,688
Total 6,825,529 6,527,385 $298,144
Expenditures:
Mid-Year Actual 8,864,356 7,729,287 1,135,069
Total 8,864,356 7,729,287 1,135,069
General Fund Revenues
Total General Fund revenue collections are at 40% with half of the year complete. This is below 50% because certain
revenues have a delay in when they are received by the City; specifically, it only represents four months of Sales Tax
revenue, five months of Transient Occupancy Tax (TOT) revenue and four months of Franchise Fee revenue. The table on
the following page presents a comparison of the top revenue accounts. Because the top revenue sources account for
approximately 75% of total General Fund revenues, changes here can have profound impacts. The mid-year budget
includes additional revenues of $237,200 for FY 2017-18 discussed previously.
Actual
Title Budget Actual %Budget Actual % Change
Property Tax 6,387,800$ 2,604,051$ 41% 5,985,100$ 2,455,518$ 41% 148,533
Sales & Use Tax 3,800,000 996,215 26% 3,632,400 959,707 26% 36,508
Transient Occupancy Tax 995,900 466,333 47% 1,000,200 453,227 45% 13,106
Franchise Fees 612,000 141,056 23% 593,000 148,589 25% (7,533)
Children in Motion 360,000 210,537 58% 350,000 186,863 53% 23,674
Telecom Site Leases 235,000 109,250 46% 235,000 105,738 45% 3,512
Building Permits 260,800 133,825 51% 214,700 127,510 59% 6,315
Planning Fees 330,500 173,860 53% 247,300 133,413 54% 40,447
Total 12,982,000$ 4,835,127$ 37% 12,257,700$ 4,570,565$ 37% 264,562$
Mid-Year Current Fiscal Year Mid-Year Prior Fiscal Year
Item 12.a. - Page 12
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
10
Property Tax – Property tax trends are consistent with the same period last year and budgeted revenues are expected
to be met.
Sales Tax – Sales tax is slightly higher than projected and higher than the same period last fiscal year and an increase
to the budgeted revenue is proposed.
Transient Occupancy Tax – Revenues are higher than the previous fiscal year, however actual results are lower than
anticipated. A reduction in budgeted revenue of $34,300 is included in the Mid-Year Report.
Building Permits & Planning Fees – The increase in these revenue sources reflect activity in the construction
industry as well as the fee increases adopted by the City Council. These revenues are difficult to predict and staff will
continue to closely monitor them.
All other variances are within normal ranges.
General Fund Expenditures
Most departmental expenses are under the 50% budget mark with total FY 2017-18 expenses at 49% of budget. Individual
department/division differences between the current and prior fiscal year are highlighted in the table shown on the next
page. This fiscal year, there is an increase of approximately $890,000 in General Fund expenditures over the original
budget. A portion of this increase reflects carryovers of $396,300 from unspent expenditure and project budgets in the
prior fiscal year, $289,900 in appropriations previously approved during the course of the first half of the current fiscal
year and $203,800 in mid-year requests included in this report.
Item 12.a. - Page 13
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
11
Actual
Title Budget Actual % Budget Actual % Change
City Manager 433,166$ 195,969$ 45% 395,715$ 189,847$ 48% 6,122$
Legislative & Info Svcs 447,900 209,618 47% 449,300 197,183 44% 12,435$
Retirees 235,000 62,072 26% 205,000 57,806 28% 4,266$
City Attorney 305,225 127,278 42% 283,200 118,550 42% 8,728$
Admin. Services 915,200 413,685 45% 864,800 339,035 39% 74,650$
Planning 1,006,359 429,861 43% 943,640 366,722 39% 63,139$
Information Technology 607,900 352,840 58% 554,915 203,407 37% 149,433$
Non Departmental 3,334,100 2,276,800 68% 3,243,271 1,836,324 57% 440,476$
Police 6,802,300 2,972,466 44% 6,302,700 2,732,794 43% 239,672$
Building & Life Safety 386,700 197,945 51% 292,300 126,005 43% 71,940$
Engineering 696,566 287,372 41% 496,400 249,326 50% 38,046$
Recreation Services 1,033,900 445,094 43% 1,029,900 451,061 44% (5,967)$
Public Works 2,018,812 893,356 44% 1,922,400 861,227 45% 32,129$
Total 18,223,128$ 8,864,356$ 49% 16,983,541$ 7,729,287$ 46% 1,135,069$
Mid-Year Current Fiscal Year Mid-Year Prior Fiscal Year
Administrative Services – the majority of this increase reflects payment for accrued leave for an employee that retired
at the beginning of the fiscal year.
Planning – the increase from the prior year is indicative of contractual services provided to the Department during the
current fiscal year related to major planning efforts such as the East Grand Avenue Master Plan and Camp Arroyo
Grande.
Information Technology – the increase from the prior year reflects one-time purchases in the current year for network
storage.
Non Departmental – the variance from the prior year reflects timing of payments made for the City’s contribution to
the Five Cities Fire Authority as well as the annual payments made in July for Liability Insurance premiums.
Police – The majority of this increase reflects staffing vacancies in the previous fiscal year that are now filled.
All other variances are within a normal range.
Item 12.a. - Page 14
City of Arroyo Grande
Mid-Year Budget Report – 2017/18 February 27, 2018
12
Other Funds
Local Use Tax Fund (Fund 218)
This fund has been established to account for the ½ cent sales tax increase that was approved in November 2006. With
four months of sales, this revenue source is at 26%. Based on past trends, revenues are slightly lower than original
estimates. Staff recommends decreasing the anticipated revenue by $71,600 along with decreases in the spending plan of
$46,500. This will eliminate $25,000 in funding set aside for contingencies as well as a project on Alpine Street that will be
reevaluated during the upcoming Biennial Budget process.
Water and Sewer Funds
The City lifted the Stage 1 Water Emergency and revenues in the Water and Sewer Funds have steadily increased. This
behavior was anticipated, however it is difficult to predict how many changes in the community were permanent and
how many were short-term in response to the drought conditions. Year to date revenues for the current fiscal year
continue to be higher than the prior year for both the Water Fund and Sewer Fund. Revenues for the Sewer Fund are
estimated to be $43,400 higher than original projections. Likewise, the Water Fund is projected to see $315,000 in higher
revenues. However, caution is warranted as the region has seen lower than average rainfall this year and higher than
average temperatures. Staff continues to closely monitor the City’s water supply and demand and will return to the
Council for any future actions necessary in order to appropriately respond to any changing circumstances.
Attachments
A brief overview of the attached schedules is provided to inform the reader of the purpose of each schedule.
Schedule A - Fund Balance. This schedule is provided to incorporate prior year fund balance into the current year
and to summarize the FY 2017-18 budget adopted by the City Council. This schedule includes adjustments that have
previously been approved by the City Council and includes the current requested adjustments in total.
General Fund Summary. This schedule provides a summary of the revenues, expenditures and fund balance with
actual results for the prior fiscal year as well as the current FY 2017-18 Budget and proposed amended balances for FY
2017-18.
Item 12.a. - Page 15
Fund Balance
All Funds Operating Budget
2017-18 Mid-Year Budget Update
Schedule A
Estimated Estimated
Total Total
Available Available
Fund Balance Original Adjustment Operating Operating FY 2016-17 Budgeted Adjustments to Fund Balance
July 1, 2017 Revenues to Revenues Transfer In Transfer Out Carryovers Appropriations Appropriations June 30, 2018
General Fund
010 General Fund:$7,011,681 $14,246,000 $237,200 $2,681,400 $157,100 $396,300 $17,026,100 $203,800 $6,392,981
Special Revenue Funds:
210 Fire Protection Impact Fees $229,814 $35,500 $0 $0 $0 $75,600 $0 $0 $189,714
211 Public Access Television 27,642 8,000 0 0 0 0 0 0 35,642
212 Police Protection Impact Fees 36,760 5,300 0 0 1,400 400 0 0 40,260
213 Park Development Fees 1,256,331 101,000 0 0 0 371,300 0 0 986,031
214 Park Improvement Fees 287,787 50,700 0 0 60,000 700 0 0 277,787
215 Recreation Community Center 62,284 3,800 0 0 55,000 100 0 0 10,984
216 Grace Lane Assessment District 66,259 10,600 0 0 3,100 0 13,300 0 60,459
217 Landscape Maintenance District 10,901 5,900 0 0 2,000 0 5,700 0 9,101
218 Local Use Tax Fund 1,582,505 2,331,600 (71,600)0 3,489,000 0 260,600 13,000 79,905
219 Parkside Assessment District 429,269 44,500 0 0 6,100 0 30,300 0 437,369
220 Streets 0 500,300 0 359,100 90,500 0 767,300 0 1,600
222 Traffic Signal 872,483 36,000 0 0 0 400 0 0 908,083
223 Traffic Circulation 132,332 400 0 0 0 0 0 0 132,732
224 Transportation Facility Impact 2,014,954 85,000 0 0 1,735,000 2,700 0 0 362,254
225 Transportation 27 252,800 0 0 232,800 0 20,000 0 27
226 Water Neutralization Impact 214,875 58,000 0 50,000 0 0 188,700 0 134,175
230 Construction Tax 29 0 0 0 0 0 0 0 29
231 Drainage Facility 16,671 0 0 0 16,500 0 0 0 171
232 In-Lieu Affordable Housing 338,184 118,400 0 0 0 0 145,000 0 311,584
233 In-Lieu Underground Utility 4,051 0 0 0 0 0 0 0 4,051
240 Tourism Business Improvement District 184,238 200,000 0 5,000 3,000 0 248,000 0 138,238
241 Water Availability Fund 1,680,535 57,000 0 0 587,762 553,421 0 0 596,352
250 CDBG Grant Funds 10,095 127,800 0 0 124,183 0 3,641 0 10,071
271 State COPS Block Grant 202,825 120,800 0 0 210,200 0 100,900 0 12,525
Total Special Revenue Funds $9,660,851 $4,153,400 (71,600)$414,100 $6,616,545 $1,004,621 1,783,441 $13,000 $4,739,144
City of Arroyo Grande
13 Item 12.a. - Page 16
Fund Balance
All Funds Operating Budget
2017-18 Mid-Year Budget Update
Schedule A
Estimated Estimated
Total Total
Available Available
Fund Balance Original Adjustment Operating Operating FY 2016-17 Budgeted Adjustments to Fund Balance
July 1, 2017 Revenues to Revenues Transfer In Transfer Out Carryovers Appropriations Appropriations June 30, 2018
City of Arroyo Grande
Capital Project Funds:
350 Capital Improvement Fund $19,895 $5,400 $17,397,357 $5,728,169 $0 $21,264,026 $1,866,900 $19,895
Total Capital Project Funds $19,895 $5,400 $17,397,357 $5,728,169 $0 $21,264,026 $1,866,900 $0 $19,895
Enterprise Funds:
612 Sewer $1,394,091 $937,300 $43,400 $0 $404,025 $461,400 $474,100 $106,900 $928,366
634 Sewer Facility 493,620 42,000 0 0 0 0 0 0 535,620
640 Water Fund 3,382,026 6,436,600 127,400 662,162 5,347,225 301,300 1,623,800 321,900 3,013,963
641 Lopez Water 1,702,312 0 0 3,505,200 0 0 3,505,200 0 1,702,312
642 Water Facility 446,156 60,000 0 0 74,400 0 0 0 431,756
Total Enterprise Funds $7,418,205 $7,475,900 $170,800 $4,167,362 $5,825,650 $762,700 $5,603,100 $428,800 $6,612,017
Trust and Agency Fund:
751 Downtown Parking 314 11,000 0 0 4,000 0 4,800 2,514
Total Trust & Agency Fund $314 $11,000 $0 $0 $4,000 $0 $4,800 $0 $2,514
Grand Total All Funds $24,110,946 $25,891,700 $17,733,757 $12,991,031 $12,603,295 $23,427,647 $26,284,341 $645,600 $17,766,551
14 Item 12.a. - Page 17
2017-18 2017-18
2014-15 2015-16 2016-17 ORIGINAL AMENDED
ITEM ACTUAL ACTUAL ACTUAL (Unaudited)BUDGET BUDGET
Beginning Fund Balance 4,942,735$ 5,946,521$ 7,059,746$ 6,447,790$ 7,011,681$
Revenues:
Revenues 13,926,223 13,951,297 14,073,887 14,246,000 14,483,200
Transfers In 2,539,503 2,579,125 2,348,804 2,657,300 2,681,400
Total Revenues 16,465,726 16,530,422 16,422,691 16,903,300 17,164,600
Expenditures:
Salaries and Benefits 8,707,086 9,630,928 9,447,375 11,317,900 11,392,700
Services and Supplies 4,801,378 5,018,369 5,993,481 5,622,600 6,198,677
Debt Service 141,076 201,391 129,523 206,300 263,000
Capital Outlay 97,077 344,807 77,843 124,200 211,651
Transfers Out 1,715,323 221,702 426,234 45,000 157,100
Expenditure Savings (423,500) (439,800)
Total Expenditures 15,461,940 15,417,197 16,074,456 16,892,500 17,783,328
Total Operating Increases (Decreases)1,003,786 1,113,225 348,235 10,800 (618,728)
Reserved for carryover - (396,300) - -
Total Adjustments to Fund Balance 1,003,786 1,113,225 (48,065) 10,800 (618,728)
Available Fund Balance 5,946,521$ 7,059,746$ 7,011,681$ 6,458,590$ 6,392,953$
GENERAL FUND SUMMARY - Mid-Year Budget Report
15 Item 12.a. - Page 18