HomeMy WebLinkAbout06-17-2013 ac PH 1 Lichtig`.council mEmonanbum
city of San LUIS OBISPO, finance anb l.t. 6epal2tment
DATE: June 14, 2013
TO: Mayor & Council Members
VIA: Katie Lichtig, City Manager
FROM: Wayne Padilla, Interim Director of Finance & I.T
SUBJECT: Funding Options for Downtown Officer Alternatives
RECEIVED
JUN 14 2013
AGENDA
CORRESPONDENCE
Date Al 113 item#_'�
Please find attached 6 worksheets which relate to the City Council's discussions from this
week's budget hearings. Attachment 1 reflects the city's financial position after incorporating the
amounts from the items that were previously on the "Parking Lot" list and which received the
concurrence of the City Council on Wednesday night. Each of Attachments 2 — 5 combines the
information from Attachment 1 with the costs related to one of the four staffing options
(highlighted in green) for the Downtown Officer that are identified in the Council Memorandum
that was sent out Thursday evening. Also shown (highlighted in yellow) in Attachments 2 — 5
are the potential adjustments identified by staff that could be made to offset the staffing option
cost that is shown, in order to maintain a stable financial position of revenues over expenditures
for the city and a reasonable excess over the 20% reserve requirement over the 5 -year Financial
Forecast period.
More specifically, these spreadsheets use the same format as the one that was shared with the
City Council on Wednesday night as it reflects the impact that a change in the cost structure has
on both the total ending fund balance and the amount in excess of the 20% reserve. In order to
make this calculation correctly, adjustments to operating costs are shown under the header,
"Subject to 20% adjustment" and 20% of the amounts shown in this section are added to the
General Fund's 20% reserve requirement. As a result, any increases to the 20% reserve
requirement lower the amount of the fund balance that exceeds the 20% reserve as a result.
Attachment 6 reflects the options that staff has identified for offsetting the cost of the police
staffing alternatives. As noted in previous discussions, the Council may wish to identify other
adjustments than those proposed by staff. During the June 17, 2013 meeting, staff will be
prepared to respond to requests for information on these items. With regard to the options listed
in Attachment 6, the Public Works Director has confirmed that the listed reductions to general
purpose capital improvement projects will not have a material effect on the overall group of
projects and replacements that are shown. As discussed on Wednesday night, if the additional
Ranger position that was identified in an SOPC and included in the Preliminary Financial
Forecast is removed from the cost structure, there will be an impact on the city's ability to
address certain enforcement issues. Nonetheless, it is a possible alternative for the City
Council's consideration.
Please feel free to contact me with any questions you may have by calling me at 781-7125 or by
e-mail at wpadilla ub.,slocity.o_rt.
HNnformation memos\6-12-13 CC meeting follow-up\COUNCIL MEMORANDUM -downtown officer ft
City of San Luis- ispo Revised Forecast with Council Re Tmendations from 6/12/13
FY 13/14 FY 14/15 FY 15/16 FY 16/17 FY 17/18
Net changes above:
Full Year Revenues Over (Under) Exp.
Beginning Fund Balance:
Ending Fund Balance:
20% Reserve Amount:
Excess Over 20% Reserve Requirement
($44,500)
($141,000)
$0
$0
$0
$0
$0
($16,700)
Not Subiect to 20% adjustment:
$13,000
$314,200
$116,200
$46,874
$815,904
_
Fire Station #2 Upgrade
($2,700)
($27,800)
$2,700
$27,800
$0
$10,417,700
Increase Wayfinding Signs:
($25,000)
($40,000)
$15,000
$0
$50,000
Q
Open Space CIP
($33,200)
($49,600)
($50,800)
($52,100)
($53,400)
Increase Bikeway Funding:
($75,000)
($75,000)
($75,000)
($75,000)
($75,000)
Jack House Gazebo:
$0
($40,000)
$0
$0
$0
`O
Decrease Fleet Funding:
$91,400
$91,400
$91,400
$91,400
$91,400
Net changes above:
Full Year Revenues Over (Under) Exp.
Beginning Fund Balance:
Ending Fund Balance:
20% Reserve Amount:
Excess Over 20% Reserve Requirement
($44,500)
($141,000)
($16,700)
($7,900)
$13,000
($44,500)
($141,000)
($16,700)
($7,900)
$13,000
$314,200
$116,200
$46,874
$815,904
$41,300
$9,987,300
$10,301,500
$10,417,700
$10,464,574
$11,280,478
$10,301,500
$10,417,700
$10,464,574
$11,280,478
$11,321,778
$9,879,300
$10,103,000
$10,455,274
$10,768,378
$11,129,778
$422,200
$314,700
$9,300
$512,100
$192,000
ATTACHMENT 1
H:\Budget information\13-15 issues\5yr fiscal plan\revision for SOPC changes
City of Sa
Subject to 20% adjustment:
Option A Costs: �
Not Subject to 20% adiustment:
Fire Station #2 Upgrade
c
Increase Wayfinding Signs:
a Open Space CIP
rn
Increase Bikeway Funding:
Jack House Gazebo:
iO Decrease Fleet Funding:
uis Obispo Revised Forecast with Dow, wn Staffing Option A
FY 13/14 FY 14/15 FY 15/16 FY 16/17
($114,100)
($114,100) $0 $0 $0
Redirect Street Sweeping Funding
Reduce Storm Drain Replacements
Reduce Traffic Sign Maintenance
FY 17/18
$0
($2,700)
($27,800)
$2,700
$27,800
$0
($25,000)
($40,000)
$15,000
$0
$50,000
($33,200)
($49,600)
($50,800)
($52,100)
($53,400)
($75,000)
($75,000)
($75,000)
($75,000)
($75,000)
$0
($40,000)
$0
$0
$0
$91,400
$91,400
$91,400
$91,400
$91,400
$43,000
$50,000
$40,000
$88,500 ($141,000) ($16,700) ($7,900) $13,000
Net changes above:
($25,600)
($141,000)
($16,700)
($7,900)
$13,000
Full Year Revenues Over (Under) Exp.
$333,100
$116,200
$46,874
$815,904
$41,300
Beginning Fund Balance:
$9,987,300
$10,320,400
$10,436,600
$10,483,474
$11,299,378
Ending Fund Balance: $10,320,400 $10,436,600 $10,483,474 $11,299,378 $11,340,678
20% Reserve Requirement $9,902,120 $10,103,000 $10,455,274 $10,768,378 $11,129,778
Excess Over 20% Reserve Requirement $418,280 $333,600 $28,200 $531,000 $210,900
ATTACHMENT 2
HABudget information\13-15 issues\5yr fiscal plan\revision for SOPC changes
City of c Luis Obispo Revised Forecast with Dowr pn Staffing Option B
Subject to 20% adjustment: FY 13/14 FY 14/15 FY 15/16 FY 16/17
Remove Ranger SOPC: $59,300 $75,700 $75,700 $75,700
CJptiora B Costs: $0 ($1� 4,700) ($168,800) ($173,000)
$59,300 ($89,000) ($93,100) ($97,300)
Not Subiect to 20% Adiustment:
Street Sweeping Augmentation:
Reduce Storm Drain Replacements:
Net changes above:
Full Year Revenues Over (Under) Exp
Beginning Fund Balance:
FY 17/18
$75,700
($177,400)
($101,700)
($2,700)
Fire Station #2 Upgrade
c
Increase Wayfinding Signs:
41
U
Open Space CIP
($40,000)
Increase Bikeway Funding:
$0
Jack House Gazebo:
($33,200)
Decrease Fleet Funding:
Street Sweeping Augmentation:
Reduce Storm Drain Replacements:
Net changes above:
Full Year Revenues Over (Under) Exp
Beginning Fund Balance:
FY 17/18
$75,700
($177,400)
($101,700)
($2,700)
($27,800)
$2,700
$27,800
$0
($25,000)
($40,000)
$15,000
$0
$50,000
($33,200)
($49,600)
($50,800)
($52,100)
($53,400)
($75,000)
($75,000)
($75,000)
($75,000)
($75,000)
$0
($40,000)
$0
$0
$0
$91,400
$91,400
$91,400
$91,400
$91,400
$0
$43,000
$43,000
$43,000
$43,000
$0
$50,000
$50,000
$50,000
$50,000
($44,500) ($48,000) $76,300 $85,100 $106,000
$14,800
($137,000)
($16,800)
($12,200)
$4,300
$373,500
$120,200
$46,774
$811,604
$32,600
$9,987,300 $10,360,800 $10,481,000 $10,527,774 $11,339,378
Ending Fund Balance:
$10,360,800
$10,481,000
$10,527,774
$11,339,378
$11,371,978
20% Reserve Requirement
$9,867,440
$10,120,800
$10,473,894
$10,787,838
$11,150,118
Excess Over 20% Reserve Requirement
$493,360
$360,200
$53,880
$551,540
$221,860
ATTACHMENT 3
H:\Budget information\13-15 issues\5yr fiscal plan\revision for 50PC changes
Beginning Fund Balance:
$9,987,300 $10,336,850 $10,453,050 $10,540,324 $11,356,228
Ending Fund Balance: $10,336,850 $10,453,050 $10,540,324 $11,356,228 $11,382,728
20% Reserve Requirement $9,898,830 $10,123,020 $10,475,794 $10,789,418 $11,151,338
Excess Over 20% Reserve Requirement $438,020 $330,030 $64,530 $566,810 $231,390
ATTACHMENT 4
H:\Budget information\13-15 issues\5yr fiscal plan\revision for SOPC changes
City of S; suis Obispo Revised Forecast with Dow
)wn Staffing Option C
Subject to 20% adjustment:
FY 13/14
FY 14/15
FY 15/16
FY 16/17
FY 17/18
Option C Costs:
(557,650)
($100,100)
($102,600)
($10S,200'1
($107,800)
($97,650)
($100,100)
($102,600)
($105,200)
($107,800)
Not Subject to 20% Adjustment:
_
Fire Station #2 Upgrade
($2,700)
($27,800)
$2,700
$27,800
$0
c
r
Increase Wayfinding Signs:
($25,000)
($40,000)
$15,000
$0
$50,000
a
Open Space CIP
($33,200)
($49,600)
($50,800)
($52,100)
($53,400)
V
Increase Bikeway Funding:
($75,000)
($75,000)
($75,000)
($75,000)
($75,000)
Jack House Gazebo:
$0
($40,000)
$0
$0
$0
`O
Decrease Fleet Funding:
$91,400
$91,400
$91,400
$91,400
$91,400
$0
$0
$0
$0
Redirect Street Sweeping Amount:
$43,000
$43,000
$43,000
$43,000
$43,000
Reduce Storm Drain Replacements:
$50,000
$57,100
$50,000
$50,000
$50,000
Reduce Annual Paving:
$0
$0
$50,000
$12,200
$0
Reduce Traffic Sign Maintenance:
$40,000
$0
$0
$0
$0
$88,500
($40,900)
$126,300
$97,300
$106,000
Net changes above:
($9,150)
($141,000)
$23,700
($7,900)
($1,800)
Full Year Revenues Over (Under) Exp.
$349,550
$116,200
$87,274
$815,904
$26,500
Beginning Fund Balance:
$9,987,300 $10,336,850 $10,453,050 $10,540,324 $11,356,228
Ending Fund Balance: $10,336,850 $10,453,050 $10,540,324 $11,356,228 $11,382,728
20% Reserve Requirement $9,898,830 $10,123,020 $10,475,794 $10,789,418 $11,151,338
Excess Over 20% Reserve Requirement $438,020 $330,030 $64,530 $566,810 $231,390
ATTACHMENT 4
H:\Budget information\13-15 issues\5yr fiscal plan\revision for SOPC changes
City of SE pis Obispo Revised Forecast with Dow wn Staffing Option D
Beginning Fund Balance:
$9,987,300 $10,301,500 $10,431,200 $10,527,674 $11,343,578
Ending Fund Balance:
Subject to 20% adjustment:
FY 13/14
FY 14/15
FY 15/16
FY 16/17
FY 17/18
$9,894,620
Remove Ranger SOPC:
$59,300
$75,700
$75,700
$75,700
$75,700
$312,300
Option D Costs,
($135,900)
(S155,200i
($159,107)
($163,100)
($167,200)
($76,600)
($79,500)
($83,400)
($87,400)
($91,500)
Not Subject to 20% Adjustment:
Fire Station #2 Upgrade
($2,700)
($27,800)
$2,700
$27,800
$0
Increase Wayfinding Signs:
($25,000)
($40,000)
$15,000
$0
$50,000
a
Open Space CIP
($33,200)
($49,600)
($50,800)
($52,100)
($53,400)
Increase Bikeway Funding:
($75,000)
($75,000)
($75,000)
($75,000)
($75,000)
Jack House Gazebo:
$0
($40,000)
$0
$0
$0
iO
Decrease Fleet Funding:
$91,400
$91,400
$91,400
$91,400
$91,400
Reduce Annual Paving:
$50,000
Redirect Street Sweeping Amount:
$43,000
$43,000
$43,000
$43,000
$43,000
Reduce Storm Drain Replacements:
$33,600
$50,000
$40,000
$44,400
$48,500
$32,100
($48,000)
$116,300
$79,500
$104,500
Net changes above:
($44,500)
($127,500)
$32,900
($7,900)
$13,000
Full Year Revenues Over (Under) Exp.
$314,200
$129,700
$96,474
$815,904
$41,300
Beginning Fund Balance:
$9,987,300 $10,301,500 $10,431,200 $10,527,674 $11,343,578
Ending Fund Balance:
$10,301,500
$10,431,200
$10,527,674
$11,343,578
$11,384,878
20% Reserve Requirement
$9,894,620
$10,118,900
$10,471,954
$10,785,858
$11,148,078
Excess Over 20% Reserve Requirement
$406,880
$312,300
$55,720
$557,720
$236,800
ATTACHMENT 5
H:\Budget information\13-15 issues\syr fiscal plan\revision for SOPC changes
Options to Offset the Cost of Additional Downtown Policing
FY 13/14
Street Sweeping Augmentation: $43,000
Remove Ranger SOPC* $59,300
Annual Paving $0
Reduce Storm Drain Replacements: $50,000
Traffic Sign Maintenance $40,00.0
Reduce Parking Lot Maintenance:
$192,300
FY 14/15 FY 15/16 FY 16/17 FY 17/18
$43,000
$43,000
$43,000
$43,000
$75,700
$75,700
$75,700
$75,700
$0
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$50,000
$218,700 $218,700 $218,700 $218,700
Page Reference
Prelim Fin Plan pg #C-73
CIP page #3-223
CIP page #3-313
CIP page #3-495
* This will limit the work done in handling creek enforcement and homeless issues; all functions returned to Parks and Rec. Department
ATTACHMENT 6
H:\Budget information\13-15 issues\5yr fiscal plan\revision for SOPC changes