HomeMy WebLinkAboutagenda.council.worksession.20231002AGENDA
CITY COUNCIL WORK SESSION
October 2, 2023
4:00 PM, City Council Chambers
427 Rio Grande Place, Aspen
I.Work Session
I.A 2024 Recommended Budget Review - Administrative Departments, Information
Technology, Employee Housing and Benefits
Zoom Meeting Instructions
Join from a PC, Mac, iPad, iPhone or Android device:
Please click this URL to join: https://us06web.zoom.us/j/87968236325?
pwd=yNVzFttdcEm1KmtBh9MuTJhO6E7cr1.1
Passcode: 81611
Or join by phone:
Dial(for higher quality, dial a number based on your current location):
US: +1 719 359 4580
Webinar ID: 879 6823 6325
Passcode: 81611
International numbers available: https://us06web.zoom.us/u/kd4LLo2fJO
FY24 Budget Kick-off and Oct 2 2023 presentations - final.pdf
1
1
2024 Proposed Budget OverviewMatt Grau – Budget Manager October 2, 2023
2
OVERVIEW: VALUES & BALANCE23
BASE REVENUES & EXPENSES3Revenue by Category2022 2023 2024General Revenue (Taxes) $66,801,179 $80,796,720 $96,104,660Licenses and Permits $7,228,300 $7,309,430 $6,819,630Intergovernmental Revenues $926,630 $2,731,850 $860,190Charges for Services $44,858,060 $54,205,070 $37,256,042Other Inflows $13,281,000 $14,984,720 $18,336,626Other Revenue Sources $8,469,885 $7,753,627 $13,931,278General Transfers In $15,697,940 $18,874,850 $17,724,150Total Gross Revenue $157,262,993 $186,656,267 $191,032,576
4
New RequestsBase Budget (Incl. Inflationary Changes)4Total Operating: $102MSupplementals: $3.0MBase Budget: $99M•Prior Year Continuation Budget plusoUp to +7.00% Merit in 2024oHealth Insurance Premiums increaseo+2.50% on Contracts & Materials5
SUPPLEMENTAL REQUESTS: $3.0M5•2% of proposed 2024 budget•Includes $1.6 million on‐going6
6Capital and Capital Maintenance: $46MHOUSING$14.25M – Lumberyard phase 0$2.4M –Main Street Cabin HousingINFRASTRUCTURE$3.8M Preservation of historic Powerhouse Building$3.6M Water Treatment Facility improvements$2.6M electrical grid replacements & upgrades$0.9M Armory long‐term planENVIRONMENT$0.5M Animal Shelter Energy Efficiency$0.3M COREFleet will continue to explore the opportunity to shift to hybrid/electric vehicle and equipment optionsMOBILITY$0.3M parking improvements in City core$0.75M pedestrian connectivity & ADA$0.5M transportation shuttle replacements7
7Annual Debt Payments: $6.4MParks and Recreation Bonds$11,040,00021.8%Facility Bonds$39,535,00078.2%Debt Outstanding As of 1/1/2024$50.6M•New City Hall ($23.4M)•Aspen Police Department ($15.6M)•Parks & Open Space ($11.0M)•CCEC Balance ($600K)City Charter: Section 10.4General Obligation Debt Limit: 20% of Assessed Value(~$633M)*8
8Budget Presentation Calendar9
General Fund / AMP FundsOverviewOctober 2, 20239Matt Grau, Budget Manager10
001 – GENERAL FUND REVENUES10Property Tax8%Personal Property Tax1%County Sales Tax40%Tobacco Tax0%STR Tax1%Other Tax4%Other Rev20%Dept Collections26%20282027202620252024ProjectionProjectionProjectionProjectionRequest$32,494,235$33,146,815$34,003,395$35,296,385$35,675,570Opening Balance$4,242,340$4,079,210$3,922,360$3,771,540$3,625,520Real Property$368,500$354,330$340,700$327,600$315,000Personal Property$20,955,680$20,149,690$19,374,700$18,629,520$17,913,000County Sales Tax$356,810$343,090$329,890$317,200$305,000City Tobacco Tax$216,060$205,770$195,970$186,640$177,750STR Excise Tax ‐5%$504,130$480,120$457,260$435,490$414,750STR Excise Tax ‐10%$1,918,060$1,880,460$1,843,590$1,807,440$1,772,000Other Taxes$119,060$116,730$114,440$112,200$110,000State Government Shared Revenues$21,650$21,230$20,810$20,400$20,000Pitkin County Shared Revenue$8,900,400$8,599,500$8,308,800$8,027,800$7,756,500Refund of Expenditures$649,880$662,940$680,070$705,930$1,071,600Investment Income$38,252,570$36,893,070$35,588,590$34,341,760$33,481,120Unassigned Revenues$12,354,230$12,120,120$11,890,670$11,724,680$11,584,270Departmental Collections$2,113,830$2,030,200$1,953,200$1,953,430$2,050,980Transfers In$52,720,630$51,043,390$49,432,460$48,019,870$47,116,370Total Revenues11
001 – GENERAL FUND EXPENDITURES11Administrative36%Police19%ComDev/EH/Climate18%Engineering6%Streets5%Rec/Events/Bus Svcs16%Operating Budget20282027202620252024ProjectionProjectionProjectionProjectionRequest$16,251,670$15,745,850$15,260,590$14,795,010$14,758,689Administrative$2,940,470$2,827,840$2,720,240$2,617,460$2,503,173122 ‐Planning$3,134,270$3,020,610$2,911,880$2,807,780$2,710,303123 ‐Building$9,311,750$9,161,180$8,849,400$9,125,690$7,947,820221 ‐Police$2,572,060$2,484,820$2,401,160$2,321,020$2,245,490321 ‐Streets$891,390$861,200$832,280$804,560$780,542325 ‐Climate Action$2,730,270$2,632,430$2,538,750$2,448,970$2,368,793327 ‐Engineering$1,440,650$1,391,960$1,345,270$1,300,520$1,257,549431 ‐Environmental Health$1,257,890$1,219,150$1,181,870$1,146,090$1,117,676532 ‐Events$5,786,910$5,581,640$5,385,140$5,196,900$5,033,353542 ‐Recreation$358,060$345,280$333,080$321,400$311,077572 ‐Parks and Open Space$106,900$104,810$102,750$100,730$98,760592 ‐Business Services$46,782,290$45,376,770$43,862,410$42,986,130$41,133,225Operating$6,498,180$6,319,200$6,426,630$6,326,730$6,362,330Transfers Out$53,280,470$51,695,970$50,289,040$49,312,860$47,495,555Total Uses$31,934,395$32,494,235$33,146,815$34,003,395$35,296,385Ending Fund Balance12
Administrative Services(Mayor & Council, Clerk, City Manager’s Office, Human Resources, Attorney’s Office, Finance, Asset Management)October 2, 202313
13Administrative Services (57.23 FTE)Mayor & Council (2.5)Clerks Office (5.0)City Manager (15.75)Human Resources (5.0)Attorney (4.0)Finance (15.6)Asset Management (9.38)GF ADMIN SERVICES STRUCTURE14
ADMIN SERVICES REVENUES14GF Overhead94%Clerk's Office1%Finance4%Asset Management1%2024 2025 2026 2027 2028General Fund Overhead $7,756,500 $8,027,800 $8,308,800 $8,599,500 $8,900,400Unassigned Collections $7,756,500 $8,027,800 $8,308,800 $8,599,500 $8,900,400113 ‐ Clerks Office $64,800 $66,100 $67,430 $68,780 $70,150117 ‐ Finance $339,800 $334,330 $338,950 $343,670 $348,480119 ‐ Asset Management $70,200 $0 $0 $0 $0Departmental Collections $565,200 $491,200 $497,530 $503,980 $510,550Transfers In $136,380 $141,830 $147,500 $153,400 $159,530Total Revenues$8,458,080 $8,660,830 $8,953,830 $9,256,880 $9,570,480
15
ADMIN SERVICES EXPENDITURES15Mayor and Council15%Clerks Office6%Managers Office23%Human Resources8%Attorney's Office6%Finance20%Asset Management22%Operating Budget20282027202620252024ProjectionProjectionProjectionProjectionRequest$78,490$76,950$75,440$73,960$72,510Non‐Classified$2,067,010$2,046,480$2,026,600$2,007,400$2,227,157Mayor and Council$940,200$908,020$877,250$847,790$824,522Clerks Office$3,771,080$3,632,870$3,500,500$3,373,740$3,327,332Managers Office$1,333,280$1,289,050$1,246,600$1,205,790$1,174,205Human Resources$1,054,350$1,016,120$979,470$944,350$920,561Attorney's Office$3,399,370$3,277,610$3,161,060$3,049,510$2,956,175Finance$3,607,890$3,498,750$3,393,670$3,292,470$3,256,228Asset Management$16,251,670$15,745,850$15,260,590$14,795,010$14,758,689Operating$561,190$519,550$566,440$549,370$575,200Overhead Allocations$561,190$519,550$566,440$549,370$575,200Transfers Out$16,812,860$16,265,400$15,827,030$15,344,380$15,333,889Total Uses($7,242,380)($7,008,520)($6,873,200)($6,683,550)($6,875,809)Surplus/(Subsidy)43%43%43%44%45%As a Percent of Uses16
FY24 Budget Administrative Supplemental Requests(Mayor & Council, City Manager’s Office)October 2, 2023Sara Ott, City Manager17
2024 SUPPLEMENTAL 17Destination Marketing Plan — $339,620 savings• Costs associated with Aspen Chamber Resort Association event production and visitor center operations were moved out of the General Fund into the destination marketing plan and are now funded from lodging tax revenues• Marketing agreement approved through Resolution 46, Series 2023. In effect Jan. 2023.18
2024 SUPPLEMENTAL REQUEST18Grants Program: HHS Capacity Building Services $75,000 (One-Time)• Directly aligns the Council Goal to support our HHS non-profits• Provides direct support where it is most needed• Fosters collaboration between organizations• Focuses on measuring the impact to the community• Action-oriented plans and deliverables
19
2024 SUPPLEMENTAL REQUEST19City of Aspen Employee Appreciation Funding – $55,000 (On‐Going)•Supporting multiple employee events throughout the year –Including summer BBQ & Winter/holiday event•Contributes to employee retention & satisfaction‐Providing a $50 gift to all employees would be an additional approx. $28,825. 20
2024 SUPPLEMENTAL REQUEST20PTO Cash Out ‐$227,200 (One‐Time)•One time employee PTO Cash Out to eliminate unnecessary liability from City of Aspen financials•Will reduce the allowable carryover maximum PTO to 328 hours per employee (408 for patrol officers)•A like request is also included in the City’s component unit funds for APCHA staff of $6,58021
2024 SUPPLEMENTAL REQUEST21Deputy Public Works Director ‐$106,650 (Termed)•Continuity of the Deputy Public Works Director position, which started in 2023 and helps prepare for the day that the Public Works Director retires•If the position is not funded, the city would not benefit from succession planning as currently envisioned.22
2024 SUPPLEMENTAL REQUESTS22Comprehensive Equity & Accessibility Roadmap $75,000 (One‐Time)Funds to implement consultant driven‐recommendations•Expected outcome of ongoing comprehensive organizational assessment •Proven method to improve organizational recruitment, retention and productivity•Alignment to council goal of Customer‐focused Government and Community Building & Health•Expected uses: policy updates, trainings, outreach, program changes23
2024 SUPPLEMENTAL REQUEST23Translation Software/Multilingual Support: $28,000 (On‐Going)•Establishment of multilingual services, including professional translation services and the integration of translation software, to enhance communication and accessibility.•Growing demand for multilingual services•Ensures the timely delivery of services to non‐English‐speaking residents24
2024 SUPPLEMENTAL REQUEST24Strategy Management Enterprise Software $60,000 (Ongoing)•To execute an effective city‐wide strategy program•Supports “Smart Customer‐Focused Government”•Achieves greater impact through organizational alignment•Promotes efficiency, reduces departmental silos•Gauges departmental progress through quarterly reviews25
25Administrative Services SummaryQuestions?Supplementals:‐Destination Marketing Plan $339,620 savings‐Grants Program‐HHS Capacity Building $75,000‐City of Aspen Employee Appreciation Funding $55,000‐PTO Cash Out $227,200‐Deputy Director‐Public Works $106,650‐Comprehensive Equity & Accessibility Roadmap $75,000‐Multilingual Support $28,000‐Strategy Management Enterprise Software $60,000Capital:‐Clerk’s Office, Printer $7,00026
FY24 Compass & Budget ReportAsset Management – 001.119 General Fund & 000 AMP FundsRobert Schober | DirectorOctober 2, 202327
COMPASS WINS – A LOOK BACK27Impact•79 new affordable housing units•Unit sales expected by end of 2023Completed ProjectsBudget & Resource EfficiencyTargeted Stakeholder SurveysBurlingame Phase 3•Efficient allocation of resources•Increased budget accuracy•Communication with internal & external customers28
COMPASS HIGHLIGHTS28PROJECTS:•Preventative Maintenance Procedures•Planned ResiliencyGOAL: Develop Long‐Term City Hall Operational Procedures29
COMPASS HIGHLIGHTS29PROJECTS:•Update 505 Recordkeeping •Develop Renovation StandardsGOAL: Streamline City Employee Housing Program Management30
COMPASS HIGHLIGHTS30PROJECTS:•Enhance Formal Capital Projects Report•Streamline Capital Project Review Process •Standardize Budget ForecastingGOAL: Improve Budget And Capital Project Transparency31
31Asset Management (9.38 FTE)General Administrative (2.6)City Facilities (2.9)Employee Housing (0.27)Capital (3.59)ASSET STRUCTURE32
000 - AMP REVENUES32Property Tax63%STR Tax21%Investment Income9%Other Rev4%Transfers In3%20282027202620252024ProjectionProjectionProjectionProjectionRequest$32,391,303$27,746,893$24,073,073$25,237,103$26,705,817Opening Balance$6,362,010$6,117,320$5,882,040$5,655,810$5,438,280Property Tax$1,512,390$1,440,370$1,371,780$1,306,460$1,244,250STR Excise Tax 10%$648,180$617,310$587,910$559,910$533,250STR Excise Tax 5%$647,830$554,940$481,460$504,740$808,200Investment Income$250,000$65,000$675,000$0$275,200Capital Projects$0$0$0$0$82,476Capital Maintenance$9,420,410$8,794,940$8,998,190$8,026,920$8,381,656Revenues In$100,000$150,000$80,000$3,250,000$0From the Transportation Fund$550,000$0$100,000$0$100,000From the Stormwater Fund$0$0$0$0$150,000From the REMP Fund$650,000$150,000$180,000$3,250,000$250,000Transfers In$10,070,410$8,944,940$9,178,190$11,276,920$8,631,656Total Revenues33
000 – AMP EXPENDITURES33Asset Management57%Streets13%Engineering29%Recreation1%Capital Projects20282027202620252024ProjectionProjectionProjectionProjectionRequest$117,740$115,430$113,170$110,950$108,770Non‐Classified/Other Expenditures$0$0$130,000$0$7,000113 ‐Clerks Office$16,000$0$0$14,000$0115 ‐Human Resources$0$0$10,000$0$0117 ‐Finance$0$0$0$0$5,215,000119 ‐Asset Management$0$0$0$0$10,000123 ‐Building$0$0$15,000$437,000$0221 ‐Police$347,000$1,031,300$1,259,300$1,239,800$1,144,000321 ‐Streets$0$90,000$0$85,000$0325 ‐Climate Action$4,856,000$2,307,000$3,291,500$9,428,800$2,600,000327 ‐Engineering$0$65,000$0$0$25,200431 ‐Environmental Health$127,000$30,000$48,000$565,000$68,000542 ‐Recreation$0$0$0$0$0592 ‐Business Services$5,346,000$3,523,300$4,753,800$11,769,600$9,069,200Capital Projects$256,700$238,300$287,300$191,500$184,000119 ‐Asset Management$19,400$0$0$0$19,600221 ‐Police$114,500$221,600$59,000$108,400$218,600321 ‐Streets$189,900$184,900$275,100$175,500$171,200327 ‐Engineering$18,000$17,000$16,000$85,000$14,000542 ‐Recreation$598,500$661,800$637,400$560,400$607,400Capital Maintenance$6,062,240$4,300,530$5,504,370$12,440,950$10,100,370Total Uses$36,399,473$32,391,303$27,746,893$24,073,073$25,237,103Ending Fund Balance$4,360,000$4,360,000$4,360,000$4,360,000$4,360,000Set Aside for Lift 1A Escrow$32,039,473$28,031,303$23,386,893$19,713,073$20,877,103Adjusted Ending Fund Balance34
2024 SUPPLEMENTAL REQUEST34Reinstatement of Capital Asset Manager FTE: $188,400 (On‐Going)•Position had previously been included in the Capital Asset organizational structure •Re‐apportioned in 2022; Maintenance Tech 3, City Hall•Meets and immediate need•This position will focus on:Long term capital planning & budget developmentProvide operational support for all phases of capital project execution across the organization35
2024 SUPPLEMENTAL REQUEST35City Hall Operating Budget Increase $110,000 (On‐Going)•Audit shows that the buildings electrical demand charges had not been previously incurred will total approx. $70,000+ annually•With the buildings warranty expiring, a new annual mechanical maintenance and servicing contract will cost approx. $35,000•Staff is requesting an increase to the operating budget of $110,000 annually.36
2024 Major Capital Projects36Appropriations by Year$100,000Prior Years$920,0002024TBDOut Years$1,020,000Lifetime Budget51685 Armory Remodel & Reuse Long‐Term Plan•Develop A Long‐Term Plan for the Remodel and Reuse of the Armory Building•Begin Analyzing Future Programming Requirements Necessary to Meet Community Expectations and Needs•Develop Potential Funding Options for Remodel and Management of the New Facility•Create Construction Timeline for the Project•2024 Budget Appropriation for Design Work through SD and EntitlementsTask Level Budget$1,020,000Design & Engineering 37
2024 Major Capital Projects37Appropriations by Year$50,000Prior Years$450,0002024$0Out Years$500,000Lifetime Budget51249 –Animal Shelter – Efficiency Upgrades•Site Solar, High Efficiency Boilers, Improving Building Envelope•Updating Fixtures And Finishes That Are At End Of Life•2023 –Complete Design & Address Immediate Needs•Costs Are Shared With Pitkin County Per The IGA;50% of projects cost will be reimbursed•CoA REMP funding $150K of energy upgradesTask Level Budget$50,000Design & Engineering $450,000Hard Construction Cost38
2024 Major Capital Projects38Appropriations by Year$600,000Prior Years$3,845,0002024$0Out Years$4,445,000Lifetime Budget51420 –Old Powerhouse Preservation Project•Restoration of Building Envelope and Mechanical Systems ‐End of Life•Design to Match Departmental Programmatic Needs plus ADA Requirements•2023 –Complete Design; 2024 – ConstructionTask Level Budget$420,000Design & Engineering $3,675,000Hard Construction Cost$350,000Project Contingencies39
2024 Capital Maintenance392024Capital Maintenance Projects$20,00040001 Core City Network ‐AMP$136,00040002 Facility Maintenance$28,00040003 Animal Shelter Maintenance40
40Asset SummaryQuestions?Compass Goals:‐Develop Long‐Term City Hall Operational Procedures‐Streamline City Housing Program Management‐Improve Budget and Capital Project TransparencySupplementals:‐Capital Asset Manager $188,400‐City Hall Operating Budget Increase $110,000Capital: ‐Capital Projects $5,215,000‐Capital Maintenance $184,00041
FY24 Compass & Budget ReportFinance Department – 001.117Pete Strecker | DirectorOctober 2, 202342
COMPASS WINS – A LOOK BACK42Impact•Greater understanding of impacts on workloadCompleted ProjectsTax Filing / Fee Remittance SupportImprove Communication and Outreach / TrainingImproved Internal Metrics & Measurement•New tax forms allow for new STR collections•Increased tracking•Greater financial awareness at all levels•Increased partnerships43
COMPASS HIGHLIGHTS43PROJECTS:•Cash Management Module•Fixed Asset Module•Procurement Module•Reporting ImprovementsGOAL: Embrace Technology For Improved Efficiency44
COMPASS HIGHLIGHTS44PROJECTS:•State Sales Tax System Integration•Extend Housing Sales Tax & RETT*•Motor Vehicle Use Tax*•Sales Tax VS Use Tax AnalysisGOAL: Assess and Support Taxation Changes* Require Council and Voter Approval to Adopt45
COMPASS HIGHLIGHTS45PROJECTS:•Publish Capital Project Reporting in Partnership with Asset / Comms•Transition Internal Training Program to Monthly Cadence ScheduleGOAL: External & Internal Education / Outreach46
2024 SUPPLEMENTAL REQUEST46Administrative Specialist (1.0 FTE): $60,000 (On‐Going)The Finance Department lacks clerical support and has had to absorb administrative tasks across all levels, making for an inefficient operation. With this new role:•Financial records management will transition off the Payroll Specialist•Purchasing card program administration will transition off the Controller•Website management will transition off the Finance Director•Walk‐in customer support will transition off the Tax Technician•Administer the Sales Tax Rebate (Food Tax)Additionally:•Shared position will support Strategy & Innovation and Communications staff•Will help with coverage of the City Manager’s Office window for walk‐in traffic47
47Strategy & Innovation Office SummaryQuestions?Compass Goals:‐Innovate within Financial Technology Solutions‐Tackle Broader Funding Issues‐Elevate PartnershipsSupplementals: ‐Administrative Support Specialist $60,000Capital: None48
FY24 Compass & Budget ReportHuman Resources – 001.115 FundCourtney DeVito | DirectorOctober 2, 202349
COMPASS WINS – A LOOK BACK49Impact•Innovative solution for health benefits•Wellness Program Completed ProjectsTotal BenefitsLearning & Development ProgramNew Health Insurance Broker•Paid Parental leave•Competitive pay •Supports employee growth•Improved employee engagement 50
COMPASS HIGHLIGHTS50PROJECTS:•Roadmap of Reward Criteria •Staff Survey & Focus Groups•Internal Communications PlanGOAL: Improve Rewards And Recognition Program 51
COMPASS HIGHLIGHTS51PROJECTS:•Employee Engagement Analysis•Employee Engagement Action Plan GOAL: Increase Employee Engagement And Retention52
COMPASS HIGHLIGHTS52PROJECTS:•Orientation Roadmap •Feedback Loop•Peer Groups GOAL: Reimagine Employee Onboarding 53
2024 SUPPLEMENTAL REQUEST53Citywide Training Request – Colorado Certified Public Manager Program (CPM) – $16,500 On‐Going•Participation for up to 10 City staff in the CU Denver, Colorado Certified Public Manager Program (CPM)•Investing in and offering growth programs assists in recruitment and retention •Increases staff skills in the following areas: •Leadership and Teamwork•Budgeting and Finance•Public Engagement•Managing Crises and Emergencies •Alignment with Citywide values 54
54Human Resources SummaryQuestions?Compass Goals:‐Improve Rewards and Recognition Program‐Increase Employee Engagement and Retention‐Reimagine Employee OnboardingSupplementals:‐Citywide Training Request, Colorado Certified Public Manager Program (CPM) $16,500Capital: None55
FY24 Budget & Compass ReportEmployee Benefits – 501 FundOctober 02, 2023Courtney DeVito | Director56
2024 Employee Benefits56•Self‐Funded Health Plan•City supplies Health Insurance•Employee and Employer take on premiums•Employee Health Insurance Premiums –8% increase•Employer Health Insurance – 10% increase•Up to 7% merit increase57
EE BENEFITS REVENUES57Refund on Stop Loss5%Refund on Rx1%Employee Premiums11%Employer Premiums82%Other Revenues1%2024 2025 2026 2027 2028Request Projection Projection Projection ProjectionOpening Balance $1,392,490 $959,990 $527,780 $540,210 $1,052,950Refund on Stop Loss $350,000 $378,000 $408,200 $440,900 $476,200Refund on Rx $70,000 $75,600 $81,600 $88,100 $95,100Employee Premiums $859,600 $928,370 $1,002,640 $1,082,850 $1,169,480Employer Premiums $6,138,000 $6,629,040 $7,159,360 $7,732,110 $8,350,680COBRA Revenues $29,200 $31,540 $34,060 $36,780 $39,720Investment Income $41,800 $19,200 $10,560 $10,800 $21,060Other Revenues $4,300 $4,390 $4,480 $4,570 $4,660Total Revenues$7,492,900 $8,066,140 $8,700,900 $9,396,110 $10,156,900
58
EE BENEFITS EXPENDITURES58Administrative3%Employee Wellness/Safety6%Reinsurance8%Claims Paid83%Operating Budget2024 2025 2026 2027 2028Request Projection Projection Projection ProjectionAdministrative Costs $258,500 $263,670 $268,940 $274,320 $279,800Employee Wellness/Safety $439,100 $447,880 $456,830 $465,950 $475,340Reinsurance $640,500 $672,500 $706,100 $741,400 $778,500Claims Paid $6,587,300 $7,114,300 $7,256,600 $7,401,700 $7,549,700Total Uses $7,925,400 $8,498,350 $8,688,470 $8,883,370 $9,083,340Ending Fund Balance$959,990 $527,780 $540,210 $1,052,950 $2,126,510
59
FY24 Budget & Compass ReportEmployee Housing – 505 FundOctober 02, 2023Robert Schober | Director60
EE HOUSING REVENUES60Rental Income7%Refund of Expenditures ‐Housing3%Transfers In86%Investment Income4%2024 2025 2026 2027 2028Request Projection Projection Projection ProjectionOpening Balance $5,569,386 $6,574,966 $10,212,466 $13,993,636 $17,919,806Rental Income $300,000 $306,000 $312,120 $318,360 $324,730Investment Income $167,100 $131,500 $204,250 $279,870 $358,400Refund of Expenditures $134,900 $138,200 $141,700 $145,000 $148,400Revenues In $602,000 $575,700 $658,070 $743,230 $831,530Transfers In $3,554,800 $3,644,000 $3,733,100 $3,821,800 $3,910,700Total Revenues$4,156,800 $4,219,700 $4,391,170 $4,565,030 $4,742,230
61
EE HOUSING EXPENDITURES61Down Payment Assistance2%Facilities Maintenance4%Capital94%Operating & Capital Budget2024 2025 2026 2027 2028Request Projection Projection Projection ProjectionDown Payment Assistance $61,500 $61,500 $61,500 $61,500 $61,500Facilities Maintenance $136,970 $139,700 $142,500 $145,360 $148,270Operating $273,470 $201,200 $204,000 $206,860 $209,770Capital $2,877,750 $381,000 $406,000 $432,000 $460,000Total Uses $3,151,220 $582,200 $610,000 $638,860 $669,770Ending Fund Balance$6,574,966 $10,212,466 $13,993,636 $17,919,806 $21,992,266
62
2024 SUPPLEMENTAL REQUEST62Forest Service Housing Partnership – $75,000 One‐Time•Continuing high level plans for new facilities at Forest Service site, includes workforce housing (Aspen, RFTA, Colorado Mountain College, Pitkin County, Aspen Valley Hospital, and Aspen School District). •Predevelopment and additional high level design costs. •A final number of housing units for the site has not been identified.63
2024 Major Capital Projects63Appropriations by Year$315,000Prior Years$2,409,7502024$0Out Years$2,724,750Lifetime Budget51529 –Main Street Cabin Housing•Conversion of Main Street Cabin From Office Space Into Two Employee Housing Units•Design & Entitlements – 2022/2023, Construction ‐2024•Budget Risk Potential: Cost Exposure For Potential Structural Improvements To The Panabode Is Unknown At This TimeHistoric Preservation Commission Review & Pending Design Requirements Is Also UnknownTask Level Budget$315,000Design & Engineering$2,199,750Hard Construction Cost$210,000Project Contingency64
2024 Capital Projects & Capital Maintenance642024Capital Projects$75,00051740 –City Housing Property Condition Assessment$35,00051741 – 1101 East Cooper Window Replacement2024Capital Maintenance Projects$358,00040071 –Property Repair and Renovations65
65Employee Housing SummaryQuestions?Compass Goals:Part of Asset ManagementSupplementals:‐Forest Service Housing Partnership $75,000Capital: ‐Capital Projects $2,519,750‐Capital Maintenance $358,00066
FY24 Compass & Budget ReportInformation Technology – 510 FundJohn Sobieralski | DirectorOctober 2, 202367
COMPASS WINS – A LOOK BACK67Impact•More secure, robust, and reliable remote access for City staffCompleted ProjectsIT Cybersecurity Administrator (Termed)New Application IntegrationsConsolidate VPN Technology•Managing cyber systems & training•Keeping the City network safe•City departments are more efficient•Partnership with departments68
COMPASS HIGHLIGHTS68PROJECTS:•Cybersecurity Audit•Risk MitigationGOAL: Minimize Cybersecurity Threats69
COMPASS HIGHLIGHTS69PROJECTS:•Building IQ •Accessibility Compliance•New Onboarding ProcessGOAL: Enable City Departments To Do Their Jobs Better 70
COMPASS HIGHLIGHTS70PROJECTS:•Data Room Systems Replacements•City Source Knowledge Base UpdatesGOAL: Device Lifecycle Sustainability71
71Information Technology (8.0 FTE)General Administrative (0.98)Workgroup Services (2.1)Network Services (2.1)Phone Services (0.49)Application Licenses (0.46)Help Desk (1.87)INFORMATION TECHNOLOGY STRUCTURE72
IT REVENUES72IT Fees4%Refund of Expenditures ‐County1%Community Broadband4%Transfers In91%2024 2025 2026 2027 2028Request Projection Projection Projection ProjectionOpening Balance $460,334 $472,080 $443,500 $414,390 $384,690IT Fees $120,200 $114,800 $118,370 $108,570 $117,270Refund of Expenditures ‐ County $47,100 $48,000 $49,000 $50,000 $51,000Interest Income $13,800 $9,440 $8,870 $8,290 $7,690Other Revenues $0$0$0$0$0Community Broadband $116,000 $118,320 $120,690 $123,100 $125,560Transfers In $2,957,000 $2,824,240 $2,911,990 $2,670,940 $2,885,040Total Revenues$3,254,600 $3,115,310 $3,209,440 $2,961,430 $3,187,100
73
2024 PROPOSED FEE CHANGES73•ACB Monthly Recurring Charges –approx. 5% increase•100 Mbps up/down from $350 to $368•200 Mbps up/down from $500 to $525•500 Mbps up/down from $750 to $788•1 Gbps up/down from $1,500 to $1,575•5% increase will be applied to all other recurring fees charged•No fee change proposed for non‐recurring charges74
IT EXPENDITURES74Administrative12%Workgroup Services17%Network Services36%Phone Services6%Application Licenses10%Help Desk13%Community Broadband6%Operating Budget20282027202620252024ProjectionProjectionProjectionProjectionRequest$269,480$260,740$252,360$244,310$236,557Administrative$414,610$398,490$383,100$368,390$354,317Workgroup Services$801,330$775,850$751,370$727,820$745,182Network Services$136,480$132,200$128,110$124,160$120,360Phone Services$238,180$231,770$225,570$219,570$213,759Application Licenses$301,090$289,270$278,000$267,240$256,985Help Desk$124,200$121,760$119,370$117,030$114,740Community Broadband$2,285,370$2,210,080$2,137,880$2,068,520$2,041,901Operating$390,100$252,000$584,160$571,050$741,760Capital$503,170$490,280$477,780$465,620$453,700Transfers Out$3,178,640$2,952,360$3,199,820$3,105,190$3,237,361Total Uses$439,154$429,784$420,594$411,614$402,874Ending Fund Balance75
2024 SUPPLEMENTAL REQUESTS75IT Cybersecurity Administrator $137,310 (1.0 FTE On‐Going)•Manages Cybersecurity Functions For City Network and Staff•Currently A Termed Position – Requesting It Be Permanent•One Of The Top 5 Recommendations In The 2023 Cybersecurity Audit •Without Adequate Cyber Defense Management Our Network Is More Susceptible To Hackers, Malware, Ransomware•Protects the City From An Incident That Can Cripple Its Service to the Community76
2024 SUPPLEMENTAL REQUESTS76Mobile Device Management $14,400 (On‐Going) •Piloted in 2023•Allows IT to manage all mobile devices (over 400) for the City•Centrally managed, improved security and access77
2024 Capital Projects & Capital Maintenance772024Capital Projects$89,10051742 –IT Firewall Refresh – 2024$30,00051745 – Vulnerability Management$10,00051746 –Intranet CitySource Rebuild$25,00051747 – CommVault Backup Upgrade$40,00051748 – Microwave Data Link$160,00051750 –Fiber Optic Improvements – 2024 2024Capital Maintenance Projects$211,36040073 –Network Services$26,30040072 – Cybersecurity Outyears – Implementation$10,00040091 –Fiber Optic Maintenance$20,00040138 –Core City Network ‐Citywide78
78Information Technology SummaryQuestions?Compass Goals:‐Minimize Cybersecurity Threats‐Enable City Departments to do Their Jobs Better‐Device Lifecycle SustainabilitySupplementals:‐Cybersecurity Administrator $137,310‐Mobile Device Management $14,400Capital: ‐Capital Projects $514,100‐Capital Maintenance $267,66079