HomeMy WebLinkAbout12-02-19 City Commission Packet Materials - A5. Library Depreciation Fund CIP for FY21-25 and FY20 Project Changes
Commission Memorandum
REPORT TO: Honorable Mayor and City Commission
FROM: Kristin Donald, Finance Director
SUBJECT: Adopt the Library Depreciation Fund Capital Improvement Plan
(CIP) for Fiscal Years 2021-2025 and Changes to FY20 Projects
AGENDA ITEM TYPE: Action
MEETING DATE: December 2, 2019
RECOMMENDATION: Adopt the Library Depreciation Fund Capital Improvement
Plan (CIP) for Fiscal Years 2021-2025 and FY20 Project Changes as Presented
BACKGROUND: Each year, the City Manager is required to prepare a 5 Year Capital
Improvements Plan and submit it to the Commission by December 15th. The Library, City
Manager, and other city staff met in October to develop the attached Capital Plan for the
equipment and capital needs of the Library. This plan was proposed to and approved by the
Library Board at their meeting on November 20, 2019.
The plan has made some changes that impact the projects planned in FY20. Moving up LIB26
Materials Conveyor from FY21 to FY20 would aid greatly in the efforts of creating staff
efficiency. In addition, the carpet budgeted for in FY20 would make more sense to spread out
over time and replace as needed rather than all at once and having to shut down the Library for a
period of time.
190
The project for repairing the parking lot has been delayed the last couple of years and money was
added but prior year amounts were not rolled and in order to complete the work in FY20 there
needs to be $65,000 added.
These changes to FY20 would keep the fund within is approved appropriation for FY20 and the
Carpet repairs are put back into the plan spread out over three years.
UNRESOLVED ISSUES: None.
ALTERNATIVES: As suggested by the City Commission. If the Commission does not
wish to adopt this schedule tonight, it can be scheduled for approval on a later agenda.
FISCAL EFFECTS: This step in the process has no fiscal effect. The FY20 project
changes are still within the funds budgeted expenditures. Once adopted, the Capital
Improvements Plan becomes the basis of the City Manager’s Recommended Budget for FY21.
Report compiled on: November 20, 2019
Attached: Library Depreciation Fund CIP Section
FY20 Appropriation 280,000
NEW CARPET PUBLIC AREA (15,000)
RECONFIGURE CUSTOMER COUNTER (50,000)
MATERIALS CONVEYOR SYSTEM (150,000)
PARKING LOT REPAIRS NOT ROLLED FY17 (65,000)
-
191
LIBRARY DEPRECIATION FUND FINANCIAL SUMMARY Financial Summary Current YearFY20 FY21 FY22 FY23 FY24 FY25UnscheduledProjected Beginning Reserve Balance Dedicated to CIP 405,810$ 105,866$ 74,506$ 43,959$ 14,241$ 57,369$ Plus: Estimated Annual Unspent Appropriations 42,057$ 40,640$ 41,453$ 42,282$ 43,128$ 43,990$ ‐$ Less: Carryover FY19 Capital Projects (62,000)$ Less: Scheduled CIP Project Costs** (280,000)$ (72,000)$ (72,000)$ (72,000)$ ‐$ ‐$ ‐$ Projected Year‐End Cash Dedicated to CIP 105,866$ 74,506$ 43,959$ 14,241$ 57,369$ 101,359$ Assumptions Made for Revenue Estimates: Current YearFY20 FY21 FY22 FY23 FY24 FY25Estimated Annual Library Budget 2,213,510$ 2,257,780$ 2,302,936$ 2,348,995$ 2,395,974$ 2,443,894$ Estimated Amount of Budget left Unused 1.9% 1.8% 1.8% 1.8% 1.8% 1.8%Estimated Annual Unspent Appropriations 42,057$ 40,640$ 41,453$ 42,282$ 43,128$ 43,990$ Current Budget Amount Dedicated to CIP % 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Plus: Increase Dedicated to Capital Improvements % 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Total % Dedicated to CIP 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%Total Estimated Revenues Dedicated to CIP 42,057$ 40,640$ 41,453$ 42,282$ 43,128$ 43,990$ Appropriation FY2 280,000 LIB26 Conveyor (150,000) LIb27 Re configure(50,000) LIB12 Parking lot (65,000) LIB22 Carpet (15,000) ‐ ProjectedProjected** Originally LIB22 for carpet $230,000 and Lib27 for $50,000. Proposed change $150,000 for LIB26 (was in FY21 for $75,000 and pricing came back 150k and is needed this year), LIB 27 for $50,000 and remaining of 280k appropriations going towards the parking lot CURRENT$(72,000)$(72,000)$(72,000)$‐$‐$‐FY20 FY21 FY22 FY23 FY24 FY25 UNSCHEDULEDLIBRARY DEPRECIATION FUND PROJECTS & EQUIPMENT192
LIBRARY DEPRECIATION FUND PROJECT SUMMARY Project # Project Name FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 UnscheduledLIB22NEW CARPET PUBLIC AREA 15,000 72,000 72,000 72,000 ‐ ‐ ‐ LIB27RECONFIGURE CUSTOMER COUNTER 50,000 ‐ ‐ ‐ ‐ ‐ ‐ LIB26MATERIALS CONVEYOR SYSTEM 150,000 ‐ ‐ ‐ ‐ ‐ ‐ LIB12PARKING LOT REPAIRS NOT ROLLED FY17 65,000 ‐ ‐ ‐ ‐ ‐ ‐ Fiscal Year totals 215,000 72,000 72,000 72,000 ‐ ‐ ‐ ** Originally LIB22 for carpet $230,000 and Lib27 for $50,000. Proposed change $150,000 forLIB26 (was in FY21 for $75,000 and pricing came back 150k and is needed this year), LIB 27 for$50,000 and remaining of 280k appropriations going towards the parking lot repairs.FY20 Appropriation 280,000 NEW CARPET PUBLIC AREA (15,000) RECONFIGURE CUSTOMER COUNTER (50,000) MATERIALS CONVEYOR SYSTEM (150,000) PARKING LOT REPAIRS NOT ROLLED FY17 (65,000) ‐ 193
LIBRARY DEPRECIATION FUND DETAIL BACKGROUND Any unspent budget authority within the Library’s departmental budget in the General Fund is transferred to this fund at year‐end. The amount transferred each year fluctuates greatly; especially when personnel positions remain vacant for extended periods of time. Our estimate for the coming years of the plan are that approximately 1.9% of the annual budget will remain unspent – to be transferred to this fund. ‐ 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,0002015 2016 2017 2018 2019 2020Estimate ‐AverageRemaining Library Budget194
CAPITAL PLAN SUMMARY The plan has made some changes that impact the projects planned in FY20. Moving up LIB26 Materials Conveyor from FY21 to FY20 would aid greatly in the efforts of creating staff efficiency. In addition, the carpet budgeted for in FY20 would make more sense to spread out over time and replace as needed rather than all at once and having to shut down the Library for a period of time. The project for repairing the parking lot has been delayed the last couple of years and money was added but prior year amounts were not rolled and in order to complete the work in FY20 there needs to be $65,000 added. These changes to FY20 would keep the fund within is approved appropriation for FY20 and the Carpet repairs are put back into the plan spread out over three years. 195
Project Name Year Description Amount Total Project #NEW CARPET IN PUBLIC AREAS 72,000 DESCRIPTION: ‐ DUE TO THE LIBRARY SCHEDULE THIS PROJECT WILL ‐ BE DONE OVER TIME TO AVOID A MAJOR SHUT DOWN OF ‐ THE LIBRARY. THIS WILL REPLACE THE WORN CARPET ‐ ON BOTH FLOORS AND PUBLIC AREAS. ‐ ALTERNATIVES: ‐ CONTINUE WITH WORN CARPET OR SHUT DOWN FOR A ‐ PERIOD OF TIME AND REPLACE ALL AT ONCE. ‐ ADD OPERATING: ‐ NONE ‐ NEW CARPET IN PUBLIC AREAS 72,000 DESCRIPTION: ‐ DUE TO THE LIBRARY SCHEDULE THIS PROJECT WILL ‐ BE DONE OVER TIME TO AVOID A MAJOR SHUT DOWN OF ‐ THE LIBRARY. THIS WILL REPLACE THE WORN CARPET ‐ ON BOTH FLOORS AND PUBLIC AREAS. ‐ ALTERNATIVES: ‐ CONTINUE WITH WORN CARPET OR SHUT DOWN FOR A ‐ PERIOD OF TIME AND REPLACE ALL AT ONCE. ‐ ADD OPERATING: ‐ NONE ‐ NEW CARPET IN PUBLIC AREAS 72,000 DESCRIPTION: ‐ DUE TO THE LIBRARY SCHEDULE THIS PROJECT WILL ‐ BE DONE OVER TIME TO AVOID A MAJOR SHUT DOWN OF ‐ THE LIBRARY. THIS WILL REPLACE THE WORN CARPET ‐ ON BOTH FLOORS AND PUBLIC AREAS. ‐ ALTERNATIVES: ‐ CONTINUE WITH WORN CARPET OR SHUT DOWN FOR A ‐ PERIOD OF TIME AND REPLACE ALL AT ONCE. ‐ ADD OPERATING: ‐ NONE ‐ NEW CARPET PUBLIC AREA 202372,000 LIB22 (FY23) 72,000 2021NEW CARPET PUBLIC AREALIB22 (FY21) NEW CARPET PUBLIC AREA 202272,000 LIB22 (FY22) 196