HomeMy WebLinkAboutagenda.council.worksession.202005041
AGENDA
CITY COUNCIL WORK SESSION
May 4, 2020
4:00 PM, City Council Chambers
130 S Galena Street, Aspen
I.WORK SESSION
I.A.2020 Revised Budget Discussion
1
MEMORANDUM
TO: City Council
FROM: Sara Ott, City Manager
Pete Strecker, Finance Director
MEETING DATE: May 4, 2020
RE: 2020 Budget Adjustments and Reductions Due to COVID
Request of Council:
This work session is to update City Council on the revised revenue forecast for the remainder of
2020, and to present the City Manager’s recommended budget adjustments for the remainder
of the fiscal year. City Council will be presented the supplemental budget appropriations
ordinance for first and second reading on May 12 and 28, respectively. This work session
provides more time for Council to review the recommendations prior taking any action to
implement them.
The Bottom-Line Up Front:
The City Administration finds that the economic impact of COVID is requiring significant and swift
reductions in City expenditures to ensure the City maintains healthy fund balances and can
deliver core services during this economic downturn.
In the past month, additional analysis has occurred on most revenue sources. As of May 1, the
revised revenue projections show a $23M reduction from 2020 original estimates, along with
cancelling approximately $2M in internal transfers to preserve fund balance health. The change
since the March 30 revised forecast is namely due to anticipated declines in fees for services,
such as recreation and cultural arts programming, golf pass and retail sales, and recreation pass
and daily use sales, but also includes reductions to real estate transfer tax projections as well.
In response, all departments have reviewed labor and operating costs, identifying at least an 8%
expenditure reduction to these budgets. Further, all remaining 2019 and 2020 capital projects
were reviewed and prioritized, and when reasonable, additional reductions were suggested.
These plans were reviewed internally, and the City Manager’s recommended revisions are
incorporated into the Spring Supplemental ordinance. Some departments are proposing to
reduce more than 8%, while others are performing core services that would be negatively
impacted by reductions of this size or that would hinder advancing City Council’s COVID
recovery outcomes identified in Resolution 33-2020. Overall proposed reductions total more
than 14%, or roughly $16.2M, of the original 2020 operating and capital budgets.
Revised Revenue Forecast:
On March 30, 2020, the City’s Finance Department released revised sales and lodging tax
collection estimates reflecting a drop of $277M in sales base, and a correlating $12.6M reduction
in sales and lodging tax estimates from 2020 original estimates. This revised estimate was based
upon the sudden halt of almost all economic activity in the community on March 14th due to local
and state public health orders and executive orders.
1
2
Since the release of the March revisions, February taxes have been remitted, showing a 7%
increase in collections over 2019 actuals – this was better than projected. March tax filings were
due on April 20, with a City-granted 30-day deferral period for payment. This deferral was
granted to coincide with Governor Polis’s executive order to delay remittance deadlines by 30
days for state-administered collections. While many business filings are late, initial review of
timely filings indicate that revenue reductions are significant.
Further, recent weeks provided time to estimate the reductions in additional revenue categories,
as summarized in Table 1.
Table 1: Estimated Revenue Reductions from 2020 Original Estimates
Original Revised Change
City 2.4% Sales Tax $19,897,400 $13,313,800 ($6,583,600)
City Share of 2.0% County Sales Tax $10,889,000 $8,893,000 ($1,996,000)
City 2.0% Lodging Tax $3,989,100 $2,334,500 ($1,654,600)
City 2.0% Use Tax $1,000,000 $500,000 ($500,000)
Real Estate Transfer Taxes $11,569,000 $5,784,500 ($5,784,500)
City Tobacco Tax $410,000 $275,000 ($135,000)
Specific Ownership Tax $260,000 $160,000 ($100,000)
Share of State Funds (Tobacco/Marijuana) $243,400 $143,400 ($100,000)
Subtotal Tax Revenue $48,257,900 $31,404,200 ($16,853,700)
General Fund - Env. Health $112,770 $100,270 ($12,500)
General Fund - Recreation $2,526,290 $1,263,060 ($1,263,230)
Water Utility Fund $10,162,120 $8,883,320 ($1,278,800)
Electric Utility Fund $10,164,650 $8,832,050 ($1,332,600)
Parking Fund $4,909,030 $3,386,530 ($1,522,500)
Golf Course Fund $1,906,210 $1,260,100 ($646,110)
Subtotal Fees / Fines Revenue $29,781,070 $23,725,330 ($6,055,740)
Parks and Open Space Fund $100,000 $0 ($100,000)
Golf Course Fund $210,000 $0 ($210,000)
Employee Housing Fund $2,396,600 $599,080 ($1,797,520)
Subtotal Transfers In $2,706,600 $599,080 ($2,107,520)
Grand Total $80,745,570 $55,728,610 ($25,016,960)
As noted above, projections have been adjusted significantly downward for multiple major
revenue sources, including sales, lodging, use and real estate transfer taxes; and fees for
recreation, golf, parking and water and electric utilities. These projections are a point-in-time
snapshot as of mid-April and can change as additional data becomes available. With the ever-
evolving environment around public health and safety and the impact that has on tourism and
2
3
Aspen’s economy, revenue projections will be monitored and updated over the coming months
to help further assess spending authority for the remainder of 2020 and for planning for future
years.
The impact by fund is shown below. This delineation is valuable when considering the individual
health of each fund and the services provided under these groupings. There is some flexibility
on how to respond to these reductions, in large part, due to the forward-looking actions of past
and present Councils around maintaining healthy reserves.
Table 2: Revenue Reductions by Fund and Type
Taxes Fees Transfers Total
General Fund ($2,331,000) ($1,275,730) ($3,606,730)
Parks and Open Space Fund ($4,114,700) ($100,000) ($4,214,700)
Wheeler Opera House Fund ($1,981,000) ($1,981,000)
Tourism Promotion Fund ($1,240,900) ($1,240,900)
Public Education Fund ($823,000) ($823,000)
Transportation Fund ($1,325,100) ($1,325,100)
Housing Development Fund ($4,359,000) ($4,359,000)
Kids First Fund ($679,000) ($679,000)
Water Utility Fund ($1,278,800) ($1,278,800)
Electric Utility Fund ($1,332,600) ($1,332,600)
Parking Fund ($1,522,500) ($1,522,500)
Golf Course Fund ($646,110) ($210,000) ($856,110)
Employee Housing Fund ($1,797,520) ($1,797,520)
Total Across Funds ($16,853,700) ($6,055,740) ($2,107,520) ($25,016,960)
Revised Expenditure Authority:
With such large changes to projected revenues, it was evident that the 2020 operating and
capital budgets require immediate revision to maintain within the City’s financial policies. The
Spring Supplemental ordinance reflects the work of all departments in evaluating expenditures
plans, regardless of fund balance, to prioritize work for the remainder of the year to reflect
reduced revenues and/or reduced service levels due to public health orders. In general,
departments were asked to reduce labor and operational spend by approximately 8%. Typical
criteria used to identify cost savings included the ability to:
Reduce labor costs through, but not limited to:
o Freezing or delaying non-essential full-time, part-time and seasonal vacancies;
o Layoff of employees, particularly in closed cultural or recreational facilities;
o Freezing wage increases and discretionary pay; and
o Reducing overtime costs.
3
4
Reduce operational costs through, but not limited to:
o Delay of studies;
o Reduction of discretionary training;
o Reduction of miscellaneous supplies, memberships, fees, etc.
Adjust capital projects to:
o Close out previous year projects;
o Matching capital to revised labor;
o Prioritize projects with grant, state or federal funding or debt-related obligations;
o Ability to phase work into future years;
o Not cause any further damage to infrastructure by delay;
o Ability to complete work with social distancing; and
o Potential to take advantage of extended building closures for major maintenance.
Ability to maintain healthy fund balances in line or above the City’s financial policies
through organization-wide requirements, such as:
o 50% reduction in departmental and city savings program; and
o Suspension of employee housing transfers.
In addition to the reduction efforts noted above, there were two significant appropriation
increases, approved in Ordinances 4-2020 and 5-2020, that provided for an additional $6M in
authority specifically for COVID relief and recovery responses. The sum of all COVID changes
to expenditure authority are noted below.
Table 3. Summary of 2020 Net Expense Authority Across All Funds Due to COVID
Labor Reductions ($2,046,160)
Operational Reductions ($7,089,900)
Capital Projects ($4,909,700)
Transfers Between Funds ($2,107,520)
Subtotal – Reductions ($16,153,280)
COVID New – General Fund $3,500,000
COVID New – Housing Development Fund $1,500,000
COVID New – Kids First $1,000,000
Subtotal – Additions $6,000,000
COVID Transfer – Wheeler Opera House Fund $3,500,000
Subtotal – Technical $3,500,000
Total Change Due to COVID ($6,653,280)
Given the large obligation from the General Fund, the Council further adopted Resolution #34-
2020 on April 14 to approve an interfund advance of $3.5M from the Wheeler Opera House fund
balance, to be repaid over a maximum of 10 years. The annual debt service payment for this
advance is approximately $367K.
4
5
For multiple departments, significant scrutiny was placed on capital spending. The Parks and
Open Space Fund capital plan in particular has major reductions due to the Fund’s high
dependence on annual sales tax collections. The Asset Management Plan (AMP) was also
reviewed to ensure flexibility in the event that revenues declined further within the General Fund,
thereby allowing City Council to redirect property tax revenue to support critical operations.
Finally, while essential to attracting and retaining employees, the internal employee housing
charge to each department is proposed to be suspended for the remainder of the fiscal year (9
months) to keep greater resources in the individual funds. These transfers, plus a few capital
project related transfers, equate to a total reduction of $16.2M for 2020.
Table 4. Expense Adjustment by Type and Fund
Fund
Labor /
GOMs
Operating /
Savings Capital Transfers Total
AMP Fund $0 $0 ($1,676,000) $0 ($1,676,000)
General Fund ($1,478,410) ($1,812,270) $0 ($892,910) ($4,183,590)
Parks & Open Space ($245,480) ($233,200) ($1,835,300) ($443,250) ($2,757,230)
Wheeler ($33,080) ($181,000) ($703,000) ($86,180) ($1,003,260)
Tourism Promotion $0 ($1,240,900) $0 $0 ($1,240,900)
Public Education $0 ($823,000) $0 $0 ($823,000)
Transportation ($8,280) ($1,367,880) $0 ($33,150) ($1,409,310)
Housing ($1,650) $0 $0 $0 ($1,650)
Kids First ($89,230) ($83,730) ($406,700) ($50,400) ($630,060)
Stormwater ($34,190) ($101,610) $0 ($138,480) ($274,280)
Water Utility ($19,490) ($451,870) $0 ($165,450) ($636,810)
Electric Utility ($58,140) ($345,280) $0 ($87,830) ($491,250)
Parking ($23,140) ($184,970) $0 ($95,930) ($304,040)
Golf Course ($39,340) ($137,670) ($198,700) ($48,750) ($424,460)
Truscott I Housing ($2,140) $0 $0 ($8,930) ($11,070)
Marolt Housing ($2,010) $0 $0 ($8,330) ($10,340)
Information Tech. ($11,580) ($126,520) ($90,000) ($47,930) ($276,030)
Total ($2,046,160) ($7,089,900) ($4,909,700) ($2,107,520) ($16,153,280)
Preliminary Outlook for 2020-2022:
Some level of economic activity is not expected to return for multiple years and has been worked
into new long-range plans that are included each fund’s long-range plan. For now, it has been
assumed that most tax revenue will take two years to recover, realizing half in 2021 and half in
2022. With this graduated recovery assumption, all funds can maintain the required targeted
reserve without spending cuts beyond the current year; however, this may change if economic
activity does not begin to show signs of improvement relative to the assumptions used in early
forecasts(See Table 5, attached.)
Recommendation
It is recommended City Council adopt the revised budget for the remainder of 2020.
Attachments:
Table 5. Forecasted Revenue Declines by Sector for 2020 dated March 30, 2020
Draft Spring Supplemental ordinance
5
6
Below are the initial forecasted declines in sales tax revenue by industry for the City. As one reviews this, it is important to note that each month is not weighted equally in the City’s annual collections – off-season months have largely local resident spend vs. high season months that have heavy tourism spend. Additionally, note that February collections were up approximately 7% (in aggregate) relative to 2019 which was an improvement over the level projection for that month when the below forecast was developed and published on March 30, 2020. Table 5. Forecasted Revenue Declines by Sector for 2020 Actual Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Industry Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Accommodations ‐2% 0% ‐75% ‐100% ‐100% ‐75% ‐75% ‐50% ‐30% ‐30% ‐30% ‐20% ‐40% Restaurants 11% 0% ‐80% ‐50% ‐50% ‐70% ‐50% ‐30% ‐20% ‐20% ‐20% ‐10% ‐32% Sporting Goods 7% 0% ‐75% ‐100% ‐100% ‐70% ‐70% ‐50% ‐50% ‐50% ‐50% ‐20% ‐38% Clothing 1% 0% ‐75% ‐100% ‐100% ‐70% ‐70% ‐50% ‐50% ‐50% ‐50% ‐20% ‐46% Food & Drug ‐8% 0% ‐50% ‐20% ‐20% ‐30% ‐30% ‐30% ‐20% ‐10% ‐10% ‐10% ‐20% Liquor 5% 0% ‐50% ‐30% ‐30% ‐40% ‐40% ‐20% ‐10% ‐10% ‐10% ‐10% ‐20% Marijuana ‐14% 0% ‐30% ‐50% ‐50% ‐50% ‐40% ‐20% ‐10% ‐10% ‐10% ‐10% ‐23% General/Misc 6% 0% ‐30% ‐30% ‐30% ‐30% ‐30% ‐20% ‐20% ‐20% ‐20% ‐10% ‐19% Luxury 112% 0% ‐90% ‐100% ‐100% ‐90% ‐90% ‐90% ‐75% ‐75% ‐75% ‐50% ‐53% Utilities ‐3% 0% ‐20% ‐20% ‐20% ‐20% ‐10% ‐10% ‐10% ‐10% ‐10% ‐10% ‐11% Construction 23% 0% ‐30% ‐30% ‐30% ‐40% ‐40% ‐40% ‐50% ‐50% ‐50% ‐60% ‐38% Automobile 16% 0% ‐50% ‐80% ‐80% ‐80% ‐60% ‐60% ‐60% ‐50% ‐50% ‐50% ‐50% Aggregate 7% 0% ‐65% ‐56% ‐52% ‐58% ‐58% ‐40% ‐32% ‐31% ‐32% ‐22% ‐34% As of: March 30, 2020 67
MEMORANDUM
TO: City Council
FROM: Sara Ott, City Manager
Pete Strecker, Finance Director
MEETING DATE: May 4, 2020
RE: 2020 Spring Supplemental Overview
Overview:
In tandem with the partnering memo around COVID impacts to the City’s revenue and associated
budgetary reduction measures, this memorandum provides an outline to the combined impact
of the “routine” Spring Supplemental request and COVID adjustments.
The annual Spring Supplemental reflects an increase in net expenditure authority of
$58,020,448. This increase, while significant, largely reflects the re-appropriation of budget
authority associated with capital projects that began in 2019. Under Colorado Statute, all annual
appropriations lapse at the end of a fiscal year and therefore require a re-appropriation by the
governing body. For this Spring Supplemental request, this includes a few significant projects
such as City Offices at Galena and Rio Grande Building ($27.5M) and the three public private
partnership affordable housing projects ($13.6M). Including all capital carry-forward projects
(Exhibit E), nearly 88% of the total Spring Supplemental request is reflected by this re-
appropriation.
Also incorporated into the Spring Supplemental are new requests (Exhibit B) that reflect items
previously unforeseen or needed due to changing circumstances. The total ask includes
$198,270 in operational costs and $1,050,980 in capital across the organization and reflects just
2% of the Spring Supplemental.
Per the City’s financial policies, the Spring Supplemental also includes a re-appropriation of
operational savings (Exhibit C) that have resulted from department managers’ efforts to be
fiscally prudent with taxpayer / rate payer funds. Per the policy, this program allows for 50% of
an annual operational savings amount to be re-appropriated in the subsequent budget year to
be used for mission specific purposes. This program was created to deter what often happens
in other government sectors, when there is a “use it or lose it” mentality on expenditure authority.
Note, as part of the COVID reduction plan, the 2020 departmental savings amount is proposed
to be reduced by 50% to help preserve fund balances.
Remaining items within the attached packet include items that the Council has reviewed and
approved previously, are net-zero requests due to offsetting grants, or are internal transfers
between funds (Technical Exhibit F); or reflect carry-forward appropriations for special projects
or replacement schedules (Exhibit D).
Resources:
To support the increased authority within the Spring Supplemental request, note the opening
balance change for 2020 equal to $89.3M. This again is predominately a reflection of the
1
8
unspent appropriation for 2019 capital projects that extended beyond the one fiscal year. It does
however also reflect the increase in collections above conservative projections when the budget
was developed and includes savings from underspent operational budgets.
Incorporating all the above Spring Supplemental requests, plus the adjustments due to COVID,
into the City’s annual spending plan results in aggregate ending fund balance across City funds
equal to $144.3M. This is greater than the original $127.4M anticipated and allows for some
additional buffer in the event that current actions are not sufficient in this uncertain economy.
Original
Budget Spring Supp. COVID Supp. Aggregate Revised Budget
Proj. Opening Balance $123,305,817 $89,290,241 $0 $89,290,241 $212,596,058
Original Revenues $151,495,585 $0 $0 $151,495,585
New Revenues $0 $617,380 $0 $617,380
Transfers $0 $199,050 $0 $199,050
COVID Reductions $0 $0 ($25,016,960) ($25,016,960)
COVID Increases $0 $0 $3,500,000 $3,500,000
Revenues $151,495,585 $816,430 ($21,516,960) ($20,700,530) $130,795,055
Base $74,897,470 $0 $0 $74,897,470
New Requests (Exh B) $1,979,440 $198,270 $0 $2,177,710
Savings Program (Exh C) $0 $3,826,330 $0 $3,826,330
Carry Forwards (Exh D) $0 $1,049,930 $0 $1,049,930
Technical (Exh F) $0 $468,980 $0 $468,980
COVID Increases $0 $0 $6,000,000 $6,000,000
COVID Reductions $0 $0 ($9,136,060) ($9,136,060)
Operating Budget $76,876,910 $5,543,510 ($3,136,060) $2,407,450 $79,284,360
Original $28,660,750 N/A $0 $28,660,750
New Requests (Exh B) $0 $1,050,980 $0 $1,050,980
Carry Forwards (Exh E) $0 $51,324,198 $0 $51,324,198
Technical (Exh F) $0 $101,760 $0 $101,760
COVID Reductions $0 $0 ($4,909,700) ($4,909,700)
Capital Outlay $28,660,750 $52,476,938 ($4,909,700) $47,567,238 $76,227,988
Debt Service $7,408,320 $0 $0 $7,408,320
Net Appropriations $112,945,980 $58,020,448 ($8,045,760) $49,974,688 $162,920,668
Original Transfers $34,501,270 $0 $0 $34,501,270
Technical (Exh F) $0 $199,590 $0 $199,590
COVID Reductions $0 $0 ($2,107,520) ($2,107,520)
COVID Increases $0 $0 $3,500,000 $3,500,000
Transfers $34,501,270 $199,590 $1,392,480 $1,592,070 $36,093,340
Total Appropriations $147,447,250 $58,220,038 ($6,653,280) $51,566,758 $199,014,008
Proj. Ending Balance $127,354,152 $31,886,633 ($14,863,680) $17,022,953 $144,377,105
2
9
CITY OF ASPEN 2020 APPROPRIATIONS BY FUNDExhibit AFund NameProjected Opening Balance2020 Adopted Revenue2020 Spring Supplemental RevenueCOVID Adjustments ‐ Revenue2020 Amended Revenue Budget2020 Adopted Expense2020 Spring SupplementalCOVID Adjustments ‐ Expenses2020 Spring Ordinance2020 Amended Expense Budget2020 Ending BalanceGeneral Governmental Fund 001 ‐ General Fund$21,738,324$36,091,050 $112,930 ($106,730) $36,097,250 $36,709,130 $3,702,590 ($683,590) $3,019,000 $39,728,130$18,107,444Subtotal General Gov't Funds$21,738,324$36,091,050 $112,930 ($106,730) $36,097,250 $36,709,130 $3,702,590 ($683,590) $3,019,000 $39,728,130$18,107,444Special Revenue Governmental Funds100 ‐ Parks and Open Space Fund$7,722,372$13,692,910 $0 ($4,214,700) $9,478,210 $14,180,960 $1,554,602 ($2,757,230) ($1,202,628) $12,978,332$4,222,250120 ‐ Wheeler Opera House Fund$32,616,443$5,865,220 $9,000 ($1,981,000) $3,893,220 $5,459,320 $2,087,951 $2,496,740 $4,584,691 $10,044,011$26,465,652130 ‐ Tourism Promotion Fund$103,630$2,993,610$0 ($1,240,900) $1,752,710 $2,991,800$0 ($1,240,900) ($1,240,900) $1,750,900$105,440131 ‐ Public Education Fund$0$2,920,000$0 ($823,000) $2,097,000 $2,920,000$0 ($823,000) ($823,000) $2,097,000$0132 ‐ REMP Fund$5,238,857$914,010$0$0 $914,010 $1,945,400$0$0$0 $1,945,400$4,207,467141 ‐ Transportation Fund$7,714,320$5,404,090$0 ($1,325,100) $4,078,990 $6,809,520 $251,450 ($1,409,310) ($1,157,860) $5,651,660$6,141,650150 ‐ Housing Development Fund$48,525,279$21,687,160$0 ($4,359,000) $17,328,160 $16,488,840 $13,697,347 $1,498,350 $15,195,697 $31,684,537$34,168,902152 ‐ Kids First Fund$6,279,775$2,334,325$0 ($679,000) $1,655,325 $2,709,290 $197,620 $369,940 $567,560 $3,276,850$4,658,250160 ‐ Stormwater Fund$1,673,013$1,436,490$0$0 $1,436,490 $1,364,030 $349,787 ($274,280) $75,507 $1,439,537$1,669,966Subtotal Special Revenue Funds$109,873,689$57,247,815 $9,000 ($14,622,700) $42,634,115 $54,869,160 $18,138,757 ($2,139,690) $15,999,067 $70,868,227$81,639,577Debt Service Governmental Fund250 ‐ Debt Service Fund$1,026,470$6,244,110$0$0 $6,244,110 $6,238,030$0$0$0 $6,238,030$1,032,550Subtotal Debt Service Fund$1,026,470$6,244,110$0$0 $6,244,110 $6,238,030$0$0$0 $6,238,030$1,032,550Capital Projects Governmental Funds000 ‐ Asset Management Plan Fund$47,271,740$9,723,680 ($111,000)$0 $9,612,680 $3,502,700 $30,211,156 ($1,676,000) $28,535,156 $32,037,856$24,846,564Subtotal Capital Fund$47,271,740$9,723,680 ($111,000)$0 $9,612,680 $3,502,700 $30,211,156 ($1,676,000) $28,535,156 $32,037,856$24,846,564Enterprise Proprietary Funds421 ‐ Water Utility Fund$8,189,182$10,162,120 $579,500 ($1,278,800) $9,462,820 $11,973,150 $1,903,265 ($636,810) $1,266,455 $13,239,605$4,412,397431 ‐ Electric Utility Fund$5,161,141$10,169,550 $226,000 ($1,332,600) $9,062,950 $10,083,450 $2,264,090 ($491,250) $1,772,840 $11,856,290$2,367,801451 ‐ Parking Fund$7,082,783$4,939,030$0 ($1,522,500) $3,416,530 $8,429,050 $158,903 ($304,040) ($145,137) $8,283,913$2,215,400471 ‐ Golf Course Fund$576,062$2,578,450$0 ($856,110) $1,722,340 $2,341,270 $111,925 ($424,460) ($312,535) $2,028,735$269,667491 ‐ Truscott I Housing Fund$894,922$2,401,400$0$0 $2,401,400 $2,268,290 $334,537 ($11,070) $323,467 $2,591,757$704,565492 ‐ Marolt Housing Fund$2,041,095$1,453,120$0$0 $1,453,120 $2,457,590 $277,020 ($10,340) $266,680 $2,724,270$769,945Subtotal Enterprise Funds$23,945,185$31,703,670 $805,500 ($4,990,010) $27,519,160 $37,552,800 $5,049,740 ($1,877,970) $3,171,770 $40,724,570$10,739,775Internal Proprietary Funds501 ‐ Employee Benefits Fund$3,867,693$5,538,880$0$0 $5,538,880 $5,806,600$0$0$0 $5,806,600$3,599,973505 ‐ Employee Housing Fund$3,902,169$2,576,640$0 ($1,797,520) $779,120 $421,410 $666,775$0 $666,775 $1,088,185$3,593,104510 ‐ Information Technology Fund$970,788$2,369,740$0$0 $2,369,740 $2,347,420 $451,020 ($276,030) $174,990 $2,522,410$818,118Subtotal Internal Service Funds$8,740,650$10,485,260$0 ($1,797,520) $8,687,740 $8,575,430 $1,117,795 ($276,030) $841,765 $9,417,195$8,011,195ALL FUNDS$212,596,058$151,495,585 $816,430 ($21,516,960) $130,795,055 $147,447,250 $58,220,038 ($6,653,280) $51,566,758 $199,014,008$144,377,105Less Interfund Transfers$34,501,270 $199,590 $1,392,480 $36,093,340 $34,501,270 $199,590 $1,392,480 $1,592,070 $36,093,340NET APPROPRIATIONS$212,596,058$116,994,315 $616,840 ($22,909,440) $94,701,715 $112,945,980 $58,020,448 ($8,045,760) $49,974,688 $162,920,668$144,377,105RevenuesExpenses310
411
Revenue
Department/Description Amount
Asset Management Plan Fund: Because of CDOT grant funding requirements, the timeline for completion
of the Garmisch Bus Stop and Pedestrian Improvements project was advanced one year. The grant
redistributed cost sharing between the Transportation fund and the Asset Management fund, reducing the
original transfer amount of $156,000 from Transportation to $45,000.
($111,000)
000 ‐ Asset Management Fund Total:($111,000)
Transfer from Wheeler Opera House Fund: Transfer from the Wheeler Fund to cover a portion of the grant
review process assessment and overhaul, managed by the Quality Office within the Manager's Office. See
"New Requests" for further specifics around this ask.
$9,000
Transfer from Multiple Funds: Transfers from non‐General Fund departments associated with the Central
Savings program per City Financial Policies, equal to 10% of operational savings in the preceding year.
$93,050
City Manager Subtotal:$102,050
Net Zero Impact ‐ 100% Grant funded Food Safety Program: The Environmental Health and Sustainability
Department was awarded two grants for a total of $6,000 to enhance the food safety program in the City of
Aspen. The first provides $3,000 to go towards providing food safety trainings for restaurants which can
cover costs such as language translation services, materials and supplies, and refreshments for the
trainings. The second, also for $3,000, goes to cover travel and lodging expenses plus registration for the
Food Program Manager to attend two conferences on food protection. One is put on by the FDA and the
other by the state of Colorado. This request is to extend spending authority in the lines listed to allow for
the use of the awarded grant dollars
$6,000
Net Zero Impact ‐ 100% Grant funded Radon Program: EH&S requests the budget authority for a Radon
Reimbursement Grant budget of $4,880. With this grant, staff provides radon test kits and education to
residents in Aspen. Staff will provide training to the public on radon awareness in real estate transactions.
As part of the City's Radon Program staff will assistant homeowners with high radon by providing
information on how they can lower their lung cancer risk by installing radon mitigation and lowering radon
levels below the EPA action level of 4 pCi/L. Radon grant dollars also cover the cost of the department's
multi‐media outreach campaign on radon, including social media, newspaper ads, banners on Main Stand
informational post cards and posters posted throughout the community.
$4,880
Environmental Health Subtotal:$10,880
001 ‐ General Fund Total:$112,930
Wheeler: Aspen Public House Pipe Repair & On Going Maintenance: An unexpected repair to the pipe
that carries grease from the restaurant floor drains and dishwashing stations was required in order for the
restaurant to continue running efficiently and safely. This pipe must be maintained and pumped monthly
in order to abide with the required building code. In order to ensure that the tenant properly maintains this
item, Wheeler will schedule and oversee vendor in the monthly process ($750/month) and will charge the
cost back to the tenant in the monthly rent bill.$9,000
120 ‐ Wheeler Opera House Fund Total:$9,000
2020 SPRING SUPPLEMENTAL REVENUE DETAIL
5
12
Revenue
Department/Description Amount
Updated revenue projection: Based on current trends revenue projections for Fire Charge ($25,500) and
Raw Water ($54,000) were increased.$79,500
Grant Funded: The Bureau of Reclamation grant will be used to implement water AMI and meter
replacement projects.
$500,000
421 ‐ Water Utility Fund Total:$579,500
Updated revenue projection: Based on current trends revenue projections for Electric Development Fee
($18,000) were increased.$18,000
Transfer from Water Utility Fund: Revised apportionment of the automated metering (AIM) project
between the two utility funds based on the benefits provided to each fund. A corresponding expense is
shown in the "Technical" section of this Spring Supplemental, with the result being a slightly smaller cost
burden to the Electric Utility.$208,000
431 ‐ Electric Utility Fund Total:$226,000
Total Revenue:$816,430
6
13
Exhibit B ‐ New Requests
Department/Description Amount
50486 Garmisch Bus Stop and Pedestrian Improvements: CDOT awarded the City of Aspen a $600,000
grant for the Garmisch Bus Stop and Pedestrian Improvements project. This is a reimbursement grant that
requires the project be completed by the end of 2021. The design work needs to be completed by fall of
2020, in order to solicit bids, conduct public outreach, and start construction in 2021. Funding and project
timelines need to be accelerated in order to meet the grant deadline. $156,000 was planned to be spent in
2021; however, this will need to be moved up to 2020 and the planned construction ($939,000) will be
moved to 2021. The current funding requirement from the Transportation fund and the AMP fund will be
reduced by $300,000 each. One‐time
$156,000
Ice Garden Sanitary Sewer Replacement: The discharging sanitary sewer on the north east corner of the Ice
Garden Center is in poor condition and could shut down the center if a break occurs. Funds would replace
approximately one block of pipe. Roots and age have minimized the current capacity of discharge and staff
anticipates this section of pipe to have remaining limited life. The project originally started under the Asset
group to finalize design and was transferred to Engineering for construction in the summer of 2019. One‐
time
$134,000
Airport Signal Repair: City Council approved the placement of a foundation and replacement of the light
pole that was damaged by a City vehicle on April 14, 2020 by Resolution #027. CDOT requested the City
proceed with the contracting and management of the project to reduce the cost by up to 25% and decrease
the time needed for placement of the signal. An insurance claim will be potentially required to cover cost
after placement is complete. One‐time
$75,980
000 ‐ Asset Management Fund Total:$365,980
City Manager Administrative Assistant (0.7 FTE): The City Manager’s Office previously shared a position
with the Finance Department to perform two full time functions, that of an Administrative Assistant for the
Manager’s Office as well as the City’s Procurement Officer. With the departure of this tenured individual,
the City has evaluated the needs of the organization and requests that these two roles be separated and
funded at a higher level to allow for a net increase of 1.0 FTE across the organization. Given the City's
volume of procurement and the needs of the Manager’s Office (including Council support), broadening the
expectations of these two positions to match the demands associated with both roles necessitates two full
time staff. On‐going
$61,640
Arts, Nonprofit, HHS Grant Program Evaluation: Based on feedback through previous award cycles, City
Staff has initiated a RFQ to seek out an organization to help administer an evaluation of the City’s grant
application and award process. This evaluation will include all grant awarding, including health and human
services (HHS), parks, recreation and the arts. The cost of the evaluation is estimated at $18,000 and is
proposed to be split between the General Fund and the Wheeler Opera House Fund. One‐time
$18,000
City Manager Subtotal $79,640
2020 SPRING SUPPLEMENTAL NEW REQUESTS
7
14
Exhibit B ‐ New Requests
Department/Description Amount
Procurement Officer (0.3 FTE): The City Manager’s Office previously shared a position with the Finance
Department to perform two full time functions, that of an Administrative Assistant for the Manager’s
Office as well as the City’s Procurement Officer. With the departure of this tenured individual, the City has
evaluated the needs of the organization and requests that these two roles be separated and funded at a
higher level to allow for a net increase of 1.0 FTE across the organization. Given the City's volume of
procurement and the needs of the Manager’s Office (including Council support), broadening the
expectations of these two positions to match the demands associated with both roles necessitates two full
time staff.
The Procurement Officer role has changed to require a much higher level of engagement, including
increased audit and compliance, legal, and award disclosure requirements. Because of these changes and
of the separation from the administrative roles pr evious layered on this position, the cost of this FTE is
higher than previously budgeted. On‐going
$32,830
Software Hosting Costs: Due to the delay in implementing new sales and lodging tax software, the Finance
Department is covering the maintenance and hosting costs for the legacy system longer than expected.
The additional cost for the year is slightly less than $9,000 and provides for technical assistance with the
system that continues to be "temperamental". Ultimately, Finance would like to turn on the new system in
Oct/Nov to take advantage of the functionality of the new system, but understands that the current
environment is not the right moment to make the system live. One‐time.
$8,800
Finance Subtotal: $41,630
Fee‐in‐Lieu Study Extension: In August of 2019, City Council approved a professional services contract with
White and Smith, in partnership with TischlerBise, for a study of Aspen's Fee‐in‐Lieu (FIL) for affordable
housing mitigation. The study is evaluating the calculation, updates methods, legal sufficiency of related
code language and methodology, and relationship of the FIL to the Affordable Housing Credits Program.
The report will make recommendations for improvements to the program. Per Council direction following
discussion of the report, a new contract with the c onsultant team would provide direction on any
additional requested analysis. One‐time
$25,000
Planning Subtotal: $25,000
001 ‐ General Fund Total:$146,270
Theater Project Study Phase II ‐ Organizational Assessment: Following input from City Council in Fall 2019,
the Wheeler Opera House staff increased the scope of work for the Theatre Projects 2019 contract (Phase I
Feasibility Study). Phase II will include conducting an organizational/departmental review of the Wheeler
Opera House to determine the Wheeler's success in meeting its strategic goals over the last five years as
well as a review and recommendations for the long‐term sustainability and organization of the department.
This additional scope of work will include operations analysis, staff interviews and final recommendations.
The study beings on March 29 and will be completed by July 1, 2020. One‐time
$35,000
8
15
Exhibit B ‐ New Requests
Department/Description Amount
Aspen Public House Pipe Repair and Maintenance: An unexpected repair ($9,000) to the pipe that carries
grease from the restaurant floor drains and dishwashing stations was required in order for the restaurant
to continue running efficiently and safely. This pipe must be maintained and pumped monthly in order to
abide with the required building code. In order to ensure that the tenant properly maintains this item,
Wheeler will schedule and oversee vendor in the monthly process ($750/month) and will charge the cost
back to the tenant in the monthly rent bill.
$17,000
120 ‐ Wheeler Fund Total:$52,000
Yellow Brick Entrance Concrete Repair: The entrance landings and stairs have been deteriorating for a
number of years. The plan calls for removing the existing paint, patching, and cleaning the concrete stairs
and landings at east and west main entrances, repairing and encapsulating the steel stair nosing’s in an
epoxy paint, and adding a clear protective coating to the concrete surfaces. With a focus on historic
sensitivity, this process will improve the aesthetics at the entrances and protect the stairs from further
deterioration. This work is expected to last for ten years with minor touch ups. One‐time
$45,000
152 ‐ Kid's First Fund Total:$45,000
50745 Drying Bed Maintenance and Rebuild: The backwash pond for the clarifier residuals needs to have
the materials removed and taken to the landfill. The second piece of the project is to rebuild the drying bed
for placement of the new materials stored from the plant. One‐time
$160,000
421 ‐ Water Utility Fund Total:$160,000
Renovations of Existing Employee Housing Units: Units within the current City of Aspen inventory have
been occupied for decades without significant improvements. As these units turnover, the City needs to
perform renovations to make them livable for new tenants. The prior City Manager unit on Cemetery Lane
will be renovated and converted into two units, providing additional housing in the city. Units at Water
Place need carpet, paint, and countertop replacements, plus one unit needs changes to plumbing for
kitchen and laundry locations. The proposed renovations will give these units new or extended useful life
and help the City to ensure an appropriate level of housing for its staff. One‐time.
$480,000
505 ‐ Employee Housing Fund Total:$480,000
Total New Requests ‐ First Reading:$1,249,250
Total New Requests ‐ Second Reading:$0
Total Requests:$1,249,250
9
16
10
17
Exhibit C ‐ Savings
2020 DEPARTMENTAL SAVINGS
Fund/Department Central Savings "10%" Department Savings "50%"
COVID19: 50% Reduction
in Department Savings
City Clerk (113)$20 $27,290 $13,650
City Manager (114)$455,550 $285,650 $142,830
Human Resources (115)$8,920 $44,120 $22,060
City Attorney (116)$3,530 $80,380 $40,190
Finance (117)$12,910 $321,960 $160,980
Asset Management (119)$8,420 $41,580 $20,790
Planning (122)$6,050 $144,800 $72,400
Building (123)$2,430 $32,520 $16,260
Police (221)$8,920 $44,120 $22,060
Streets (321)$4,180 $290,080 $145,040
Engineering (327)$7,210 $35,070 $17,540
Environmental Health (431)$5,230 $102,210 $51,110
Special Events (532)$6,220 $133,070 $66,540
Recreation / ARC / AIG (Based on Subsidy) ‐ 542 $10,680 $109,500 $54,750
Red Brick Center for the Arts (552)$7,290 $78,150 $39,080
001 ‐ General Fund $547,560 $1,770,500 $885,280
100 ‐ Parks and Open Space Fund $960 $104,970 $52,490
120 ‐ Wheeler Opera House Fund $0 $0 $0
141 ‐ Transportation Fund $6,410 $161,980 $80,990
152 ‐ Kids First Fund $5,950 $127,460 $63,730
160 ‐ Stormwater Fund $24,110 $122,790 $61,400
421 ‐ Water Utility Fund $0 $252,830 $126,420
431 ‐ Electric Utility Fund $42,950 $356,870 $178,440
451 ‐ Parking Fund $0 $55,550 $27,780
471 ‐ Golf Fund $5,210 $73,210 $36,610
510 ‐ Information Technology Fund $0 $167,020 $83,510
Total Savings to be appropriated $633,150 $3,193,180 $1,596,650
The purpose of allowing carryforward savings is to provide an additional incentive for frugality by
operating departments. Unlike traditional governments, which have a “use it or lose it” approach to
annual operating budgets, Aspen’s policy encourages departments to create savings in their annual
operating budgets. Savings in annual operating budgets are distributed as follows:
50% of the savings are carried forward into the appropriate department’s savings account.
10% is allocated to a Central Savings account.
40% is returned to the appropriate fund balance.
Carryforward Savings represent 50% of the previous year’s operating budget savings from individual
Departments or Funds. Departments and Funds are allocated these amounts as a reward for finding
efficiencies in their operations that meet their operating goals while spending less than their
appropriations. Prior year savings that are not expended are maintained in full and appropriated every
year unless directed otherwise by the City Manager. These appropriations can be spent on items
related to the Department’s or Fund’s mission but may not be used for ongoing expenditures. If a
particular expenditure was denied as part of the budget process, departmental savings may not be used
for this purpose without City Manager approval. Expenditures of $10,000 or more must be approved by
the City Manager. Departments and Funds can accrue these savings to a maximum of 15% of their
operating budgets.
Financial constraints related to the COVID19 pandemic mean that the normal 50% departmental
carryforward amount has been reduced by 50%.
11
18
12
19
Exhibit D ‐ Operation Carry Forwards
2020 OPERATIONAL CARRY FORWARDS
Department/Description Amount
ERP ‐ Support Contract ‐ Funds will be used to support benefits/payroll configuration, benefits self‐service,
open enrollment, and other Human Resources related systems.
$15,000
Human Resources Subtotal:$15,000
ERP ‐ Support Contract ‐ Funds will be used to support payroll, procurement, reporting, and configuration
of various finance related systems.$41,700
Finance Subtotal:$41,700
Historic Preservation Review Sheets ‐ Approved by Council on November 27, 2017. In 2017, Community
Development Staff undertook enforcement on a historic preservation project where work was taking place
contrary to HPC approvals and building permits. The enforcement action resulted in a $30,000 financial
assurance the owner was required to post during construction that would not be refunded. Council
approved moving the forfeited funds into ComDev's operating budget to create new processes to prevent
future violations. Phase 1 of this project was completed in 2018, and resulted in a number of suggested
Phase 2 implementation steps. Progress was made in 2019, but other workload, in particular Council
directed amendments to preservation benefits, took priority. One‐quarter of the original budget remains
and will be used to conclude the project in 2020.
$6,980
Historic Preservation Benefits Outreach ‐ Approved by Council May 29, 2018. City Council identified
amendments to historic preservation benefits as a priority in 2018, and authorized staff to conduct public
outreach. Although outreach, such as an online survey, was completed, staff did the work in‐house and
funding was not used. Adoption of the requested amendments took until summer 2019 to complete. Staff
would like to focus the unspent funds, plus additional savings in the Community Development Department
budget, promoting remaining benefits. This could include developing a technical assistance program on the
care of historic buildings and public education tools about Aspen's designated properties, such as creating
a book, brochures, or marker program.
$35,000
Electronic Permit System Training ‐ Council approved funds for the design, build, and implementation of a
new permits management system for the City. All development permits are live in the system, and land use
applications are just starting to be put into the system. These funds will be used to train both staff and
stakeholders in the system's operation. In addition, we need to invest funds to train staff involved with
system administration to increase internal capacity to address ongoing maintenance and system issues.
$30,870
Wireless Facilities Design Guidelines and Public Outreach ‐ Approved August 8, 2019. Staff request funds
be carried forward to complete the final work on the Wireless Communications Facilities Design Guidelines
to ensure the City has robust requirements related to wireless facilities, particularly in the right‐of‐way.
Funds have thus far enabled staff to provide information to the community about the changed local
regulations in response to state and federal rules, as well as provided an opportunity for the community to
weigh in on other changes they desire. Council passed Ordinance #3 Series 2020 on April 28, 2020.
$30,260
13
20
Exhibit D ‐ Operation Carry Forwards
Department/Description Amount
Census Organizing Project ‐ Approved on April 9, 2019. In 2018, Council approved the Census Organizing
Project to develop and execute a plan for the City of Aspen to assist with the 2020 U.S. Census. These funds
need to be carried forward in order to complete the project and support the City's collaborative efforts
with Census project partners valley‐wide.
$16,190
Affordable Housing Fee‐in‐Lieu Update ‐ Approved on August 26, 2019. The land use code requires an
update to the cash‐in‐lieu charged for affordable housing mitigation every five years. City Council
requested this study be accelerated by a year and completed in 2019. The project focuses on more Aspen‐
specific costs, rather than national or statewide averages as the current fee does. Additionally, the fee will
be updated to reflect the elimination of categories 6 and 7 in the Housing Guidelines. The rollover of these
funds from 2019 will allow the contract for White and Smith, in partnership with TischlerBise, to complete
the FIL report. $33,450
Lift 1A Planning ‐ Approved by Council in 2019 as a supplemental funding request. Staff requests carryover
of the supplemental funding to address potential additional review and partnership needs that may arise
as part of the ongoing Lift 1 process. All stakeholders are working together in moving forward with final
development applications for the project. As the City is heavily involved in this effort, funds will assist the
City in covering miscellaneous additional expenses that may arise, including any costs related to seeking a
tramway board variance, community outreach, and additional work that may be needed as the proposal is
revised and finalized. $15,000
Community Development Subtotal:$167,750
001 ‐ General Fund Total:$224,450
Aggregate Equipment/Maintenance/Repair Carry Forwards $466,780
Aggregate PC Replacement Carry Forwards $339,480
Aggregate Workstation Replacement Carry Forwards $19,220
Other Operational Carry Forward Requests Total:$825,480
Total Operational Carry Forward Requests:$1,049,930
14
21
Exhibit E ‐ Capital Carry Forwards
2020 CAPITAL CARRY FORWARDS
Project Title
Lifetime
Budget
2019 Carry
Forward
Completion
Estimate
50922 HWY 82 Roundabout Evaluation $128,000 $128,000 Fall 2020
50486 Garmisch Bus Stop and Pedestrian Improvements $1,416,000 $111,365 Fall 2022
50473 Paving 4th Street Design and Construction $110,000 $0 Fall 2020
50903 Summer Road Improvements ‐ 2019 $70,000 $22,000 Fall 2020
50488 Ute Avenue Traffic Calming and Trail Connection $240,000 $52,500 Spring 2021
50844 Phase 1 Main St Improvements to signals with CDOT Coordination $40,000 $40,000 Spring 2021
50842 City Survey Monument Maintenance $20,000 $8,961 Summer 2020
Engineering Subtotal:$362,826
50952 ARC Downstairs Remodel $450,000 $100,000 12/1/2020
50360 AIG Cooling Tower replacement $85,000 $84,728 11/1/2020
50956 Water Feature Replacement $95,000 $44,277 12/1/2020
50945 Sound Baffling $90,000 $34,617 10/1/2020
50797 ARC Siding $15,000 $10,522 10/31/2020
Recreation Subtotal:$274,144
50064_APD Project $22,861,668 $9,758 9/1/2020
50074_Pedestrian Mall ‐ Planning and Design (ONLY)$1,942,000 $923,782 12/31/2020
50060_Old Powerhouse Preservation Project $3,551,700 $0 12/31/2024
51112 City Offices ‐ 425 Rio Grande $33,040,260 $26,307,409 12/31/2021
51113 City Offices ‐ Armory Renovation $13,911,660 $200,000 12/31/2024
51114 City Offices ‐ Existing Rio Grande Building $1,200,000 $1,200,000 12/31/2021
Asset Management Subtotal:$28,640,949
51059 Core City Network ‐ AMP ‐ 2019 $195,700 $195,700 7/1/2021
Information Technology Subtotal:$195,700
50259_Electronic Permitting System $719,350 $19,262 6/1/2020
Community Development ‐ Planning Subtotal:$19,262
50829 Electrical Restraint Device and Cameras $89,000 $31,055 12/31/2020
51012 Dispatch Center Equipment ‐ 2019 $113,200 $113,200 12/31/2020
Police Subtotal:$144,255
51014 Fleet ‐ 2019 $585,800 $237,600 2/29/2020
51016 Electrical ‐ Streets Facilities ‐ 2019 $54,200 $0 11/30/2020
50834 Exterior Streets Facilities 2018 $48,200 $0 11/30/2020
Streets Subtotal:$237,600
000 ‐ Asset Management Fund Total:$29,874,736
50309_Castle Creek Music School Trail $1,109,000 $1,109,000 9/30/2020
51186 Galena Plaza and Pedestrian Corridor $1,226,120 $163,598 10/31/2021
50974 Parks Campus Drainage and Paving $150,000 $0 10/31/2020
50285_Cozy Point Grading/Drainage Improvements $180,000 $0 10/31/2020
50977 Cozy Point Ranch Management Plan Implementation*$250,000 $0 10/31/2020
51001 Tiehack / Maroon Creek Bridges Concrete Repairs $60,000 $0 10/31/2020
50971 Fleet ‐ Parks ‐ 2019 $349,000 $47,721 6/30/2020
50779 Oklahoma Flat Trail Railing Replacement $55,000 $0 8/31/2020
15
22
Exhibit E ‐ Capital Carry Forwards
Project Title
Lifetime
Budget
2019 Carry
Forward
Completion
Estimate
50872 John Denver Sanctuary $94,579 $30,834 8/31/2020
50078_Hunter/Smuggler Co‐Op Implementation ‐ Recreation $125,000 $0 11/30/2020
50322 Glory Hole Park $225,000 $0 10/31/2020
51111 Lift 1A/Dolinsek Planning $30,000 $5,000 10/31/2021
50986 Irrigation Efficiency Improvements $200,000 $17,839 10/31/2020
50772 Archery Range Improvements $15,000 $0 10/31/2020
100 ‐ Parks and Open Space Fund Total:$1,373,992
51036 Production Improvements ‐ 2019 $166,550 $106,577 5/1/2020
51030 Interior ‐ Wheeler Opera House ‐ 2019 $57,000 $15,277 6/1/2020
51042 Core City Network ‐ Wheeler ‐ 2019 $6,000 $6,000 12/31/2020
51041 Wheeler Building and Site Improvements $2,283,420 $1,775,415 11/1/2020
51031 Electrical ‐ W heeler Opera House ‐ 2019 $124,000 $103,722 12/31/2020
120 ‐ Wheeler Opera House Fund Total:$2,006,991
51109 CMAQ Grant for WE‐Cycle Stations and Equipment $180,000 $180,000 12/31/2020
51085 Rubey Park Maintenance ‐ 2019 $138,400 $0 12/31/2020
141 ‐ Transportation Fund Total:$180,000
50542_PPP Development Rental Housing $25,650,000 $13,595,215 12/31/2020
51225 Lumber Yard Housing Development $76,675,000 $61,960 12/31/2028
51088 Burlingame Phase 3 ‐ Public Outreach and Design $500,000 $38,102 12/31/2024
150 ‐ Housing Development Fund Total:$13,695,277
51020 Park Avenue Stormwater Conveyance ‐ 2019 $100,000 $0 12/1/2020
50849 Master Planning ‐ River Management Plan Phase II $60,000 $60,000 12/1/2020
51021 Mud and Debris Flow Alert System ‐ 2019 $50,000 $50,000 12/1/2020
50129_Aspen Mtn Drainage Basin Improvements $250,506 $30,896 4/1/2020
50126_SW Master Planning 2016 $225,000 $31,637 12/1/2020
50850 Master Planning ‐ Riparian Area Master Plan $60,000 $19,134 6/1/2020
160 ‐ Stormwater Fund Total:$191,667
50135_Reclaimed Waterline Completion at ACSD $1,742,910 $0 2022 ‐ 2023
50132_New Equipment Storage Building $880,000 $312,733 12/31/2020
50565 Castle Creek Headgate/Pipeline $160,000 $124,950 12/31/2020
50568 Reservoir and Water Treatment Plant and Improvements $120,000 $119,915 12/31/2020
50745 Backwash Pond ‐ Master Plan & Solids Mitigation $1,110,000 $81,778 12/31/2020
50566 Maroon Creek Headgate/Pipeline $160,000 $67,401 12/31/2020
50939 Maroon Creek Hydro Building Repairs $60,000 $59,024 12/31/2020
50942 Integrated Resource Plan $275,000 $51,895 2020‐2021
50573 Altitude Valve at Tiehack Tank $50,000 $50,000 12/31/2020
50937 WTP Campus ‐ Exterior Building Improvements $645,000 $47,600 12/31/2022
50927 Fleet ‐ Water ‐ 2019 $45,000 $45,000 12/31/2020
50755 USGS Gaging Stations ‐ 2018 $40,000 $40,000 12/31/2020
50556_Water Site Maintenance $125,000 $34,872 12/31/2020
51079 Core City Network ‐ Water ‐ 2019 $12,700 $12,700 12/31/2021
50571 12 Inch Line to Tiehack Tank Feed $1,835,000 $12,614 12/31/2020
50933 Kayak Course Improvements ‐ 2019 $10,000 $10,000 12/31/2020
50265_Core City Network ‐ Water ‐ 2016 $8,240 $1,163 12/31/2021
421 ‐ Water Utility Fund Total:$1,071,645
16
23
Exhibit E ‐ Capital Carry Forwards
Project Title
Lifetime
Budget
2019 Carry
Forward
Completion
Estimate
50594 Electric AMI ‐ Mesh Network $1,800,000 $1,776,620 2021‐2022
50891 Electric System Replacement ‐ 2019 $200,000 $35,000 12/31/2020
50595 Other Renewable Opportunities ‐ 2018 $50,000 $26,065 2021‐2022
50897 Core City Network ‐ Electric ‐ 2019 $3,500 $3,500 12/31/2021
50266_Core City Network ‐ Electric ‐ 2016 $2,580 $1,395 12/31/2021
431 ‐ Electric Utility Fund Total:$1,842,580
51119 30 Additional Parking Spaces $95,000 $0 12/31/2020
50605 Kiosk ‐ Airport $110,000 $16,673 7/20/2020
51026 Core City Network ‐ Parking ‐ 2019 $6,000 $6,000 12/31/2020
50267_Core City Network ‐ Parking ‐ 2016 $5,600 $5,600 12/31/2020
451 ‐ Parking Fund Total:$28,273
50783 Fleet ‐ Golf ‐ 2018 $154,000 $0 12/31/2020
50203_Fleet ‐ Golf ‐ 2016 $135,250 $0 12/31/2020
51008 Core City Network ‐ Golf ‐ 2019 $10,350 $10,350 12/31/2020
50198_Exterior ‐ Golf and Nordic Clubhouse $7,400 $0 12/31/2020
51007 Golf Course Annual Improvements ‐ 2019 $10,000 $0 12/31/2020
50784 Facility Work ‐ Golf and Nordic Clubhouse $104,400 $0 12/31/2020
50271_Core City Network ‐ Golf ‐ 2016 $5,600 $2,045 12/31/2020
471 ‐ Golf Course Fund Total:$12,395
51072 Truscott Phase I ‐ 400‐1000 Roof and Gutter Replacement $657,427 $319,057 12/31/2020
50624 Truscott Asphalt Overlay $40,000 $0 12/31/2020
51073 Truscott Boiler in Clubhouse $25,000 $0 12/31/2020
51074 Truscott Clubhouse Deck Replacement $25,000 $0 12/31/2020
50854 Truscott Snow Removal Equipment Replacement $10,000 $0 12/31/2020
491 ‐ Truscott I Housing Fund Total:$319,057
51066 Marolt ‐ Full Exterior Paint & Repair $275,000 $275,000 11/1/2020
492 ‐ Marolt Housing Fund Total:$275,000
50231_540 Employee Housing ‐ Construction $5,426,830 $124,775 12/31/2020
50681_Water Place Phase II ‐ Design $3,350,000 $62,000 12/31/2021
505 ‐ Employee Housing Fund Total:$186,775
50237_Galena Plaza Fiber $125,000 $80,177 7/1/2021
51055 Small Cell ‐ 2019 $60,000 $60,000 12/31/2020
51043 Fiber Investments ‐ 2019 $115,000 $55,736 12/31/2020
51044 Network Services ‐ 2019 $86,000 $50,000 12/31/2020
50819 Microsoft Active Directory Upgrade $18,150 $11,635 12/31/2020
51048 CitySource Refresh ‐ 2019 $8,000 $0 12/31/2020
50879 Community Broadband – Create Aspen MeetMe Center $86,000 $4,193 12/31/2020
51107 Streets Generator $30,000 $4,069 9/1/2020
510 ‐ Information Technology Fund Total:$265,810
Grand Total:$51,324,198
17
24
18
25
Exhibit F ‐ Technical Adjustments
2020 TECHNICAL ADJUSTMENTS
Department/Description Amount
Net Zero Impact ‐ The GIS flyover project (51252 GIS Aerial Photography ‐ 2020) update came in under
budget. The unspent authority (plus additional departmental savings) is requested within the Engineering
operational budget to pay for temporary labor costs to incorporate the updated data into the GIS layers.
($29,560)
000 ‐ Asset Management Fund Total:($29,560)
Tobacco Tax for Human Services: Revenues collected from the City's tobacco tax will be used to pay for a
portion of an intergovernmental agreement for the provision of mental health services in Pitkin County.
The adopted 2020 budget included $74,078 in funding for this IGA. The total cost to the City of the IGA is
$107,550. The resolution to adopt the agreement is scheduled to go before Council on May 12, 2020.
$33,420
Mayor and Council Subtotal: $33,420
Net Zero Impact ‐ 100% Grant funded Food Safety Program: The Environmental Health and Sustainability
Department was awarded two grants for a total of $6,000 to enhance the food safety program in the City of
Aspen. The first provides $3,000 to go towards providing food safety trainings for restaurants which can
cover costs such as language translation services, materials and supplies, and refreshments for the
trainings. The second, also for $3,000, goes to cover travel and lodging expenses plus registration for the
Food Program Manager to attend two conferences on food protection. One is put on by the FDA and the
other by the state of Colorado. This request is to extend spending authority in the lines listed to allow for
the use of the awarded grant dollars
$6,000
Net Zero Impact ‐ 100% Grant funded Radon Program: EH&S requests the budget authority for a Radon
Reimbursement Grant budget of $4,880. With this grant, staff provides radon test kits and education to
residents in Aspen. Staff will provide training to the public on radon awareness in real estate transactions.
As part of the City's Radon Program staff will assistant homeowners with high radon by providing
information on how they can lower their lung cancer risk by installing radon mitigation and lowering radon
levels below the EPA action level of 4 pCi/L. Radon grant dollars also cover the cost of the department's
multi‐media outreach campaign on radon, including social media, newspaper ads, banners on Main Stand
informational post cards and posters posted throughout the community.
$4,880
Net Zero Impact ‐ 100% Grant Funded: In late 2019, the Colorado Department of Local Affairs (DOLA)
awarded a $24,740 grant to the City of Aspen in support of ComDev's Uphill Economy initiative. The
Department requests that Council increase the Community Development Department's appropriation in
the amount of the grant to enable the Department to further the goals of the Uphill Economy program.
$24,740
Environmental Health Subtotal: $35,620
Net Zero Impact ‐ GIS Flyover Temporary Labor Support: In order to incorporate the scheduled 2020
flyover data, the City needs to bring in temporary labor to update the multiple GIS layers. Each
department's savings were reduced, as was project 51252 GIS Aerial Photography ‐ 2020 for the unneeded
authority that remained once the bids were collected.
$47,840
Engineering Subtotal: $47,840
001 ‐ General Fund Total:$116,880
19
26
Exhibit F ‐ Technical Adjustments
Department/Description Amount
Transfer ‐ Arts, Non‐Profit, & HHS City of Aspen Grant Program Evaluation (50% Contribution)The City of
Aspen, led by the Quality Office, is completing an assessment of the overall grants program and has
completed vendor selection. The allocated amount needed to cover the cost of administering this
evaluation is estimated at $18,000 to be split between the City of Aspen General Fund and the Wheeler
Opera House Fund. The Wheeler's 50% project contribution ($9,000) was authorized but not budgeted for
in the 2020 planning cycle. The Wheeler Arts Grants account for approximately 25% of the overall grant
pool.
$9,000
120 ‐ Wheeler Opera House Fund Total:$9,000
Transfer ‐ Reduced the transfer to the Asset Management fund based on the timing and grant funding of
the 50486 Garmisch Bus Stop and Pedestrian Improvements project. See new requests for additional
details.
($111,000)
141 ‐ Transportation Fund Total:($111,000)
50568 Reservoir and Water Treatment Plant and Improvements: (Resolution #29 Apr 14, 2020)
Replacement of slide gates, overflow piping at reservoir, chara weed removal, East WTP flocculator rebuild,
replacing two filter inlet valves, and concrete repair work.
$131,320
Transfer ‐ Revised apportionment of the automated metering (AIM) project between the two utility funds
based on the benefits provided to each fund resulting in a slightly smaller cost burden to the Electric Utility.
$208,000
421 Water Utility Fund Total:$339,320
Workers' Compensation was not loaded in the system when the 2020 Budget Resolution was calculated for
adoption. This action corrects this oversight.
001 ‐ General Fund $185,760
100 ‐ Parks and Open Space Fund $70,260
120 ‐ Wheeler Opera House Fund $14,130
141 ‐ Transportation Fund $1,940
150 ‐ Housing Development Fund $1,330
152 ‐ Kids First Fund $2,170
160 ‐ Stormwater Fund $6,900
421 ‐ Water Utility Fund $27,200
431 ‐ Electric Utility Fund $13,880
451 ‐ Parking Fund $15,850
471 ‐ Golf Course Fund $9,610
491 ‐ Truscott I Housing Fund $1,220
492 ‐ Marolt Housing Fund $1,130
510 ‐ Information Technology Fund $720
20
27
Exhibit F ‐ Technical Adjustments
Department/Description Amount
Transfer: The City is updating its GIS maps with an updated flyover and costs are being distributed to
various user departments.
572 ‐ Parks and Open Space $1,000
132 ‐ Transportation $1,000
421 ‐ Kids First $500
328 ‐ Stormwater $1,000
322 ‐ Water $1,000
323 ‐ Electric $1,000
136 ‐ Parking $1,000
582 ‐ Golf Course $500
118 ‐ Information Technology $1,000
Transfer: To Central Savings.
100 ‐ Parks and Open Space Fund $960
141 ‐ Transportation Fund $6,410
152 ‐ Kids First Fund $5,950
160 ‐ Stormwater Fund $24,110
431 ‐ Electric Utility Fund $42,950
471 ‐ Golf Fund $5,210
Total Technical Adjustments $770,330
21
28
City of Aspen Budget000 ‐ Asset Management Plan Fund2018 2019 2020 20202020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$31,139,954 $26,259,538 $13,270,832 $34,000,908$0 $34,000,908 $47,271,740 $24,846,564 $11,914,584 $11,378,944 $12,107,664Property Tax$5,373,920 $3,386,380 $3,540,000$0$0$0 $3,540,000 $3,681,600 $3,828,860 $3,982,010 $4,141,290Other Revenues$434,642 $723,153 $265,420$0$0$0 $265,420 $496,930 $238,290 $227,580 $242,150Non‐Classified$5,808,562 $4,109,533 $3,805,420$0$0$0 $3,805,420 $4,178,530 $4,067,150 $4,209,590 $4,383,44011925 ‐ Red Brick Building$0$0$0$0$0$0$0$0$0$0$0Red Brick$0$0$0$0$0$0$0$0$0$0$081200 ‐ Capital Projects$752,682 $364,397$0$0$0$0$0 $600,000$0$0$0Capital$752,682 $364,397$0$0$0$0$0 $600,000$0$0$0$0 $30,867,420$0$0$0$0$0$0$0$0$0Debt Proceeds$0 $30,867,420$0$0$0$0$0$0$0$0$0Revenues In$6,561,244 $35,341,350 $3,805,420$0$0$0 $3,805,420 $4,778,530 $4,067,150 $4,209,590 $4,383,440From the General Fund$2,041,100 $16,000$0$0$0$0$0$0$0$0$0From the Parks and Open Space Fund$1,461,064 $362,300$0$0$0$0$0 $10,000 $75,000$0$0From the Transportation Fund$145,756 $92,600 $2,209,010 ($111,000)$0 ($111,000) $2,098,010$0$0$0$0From the Stormwater Fund$69,750 $76,616$0$0$0$0$0$0$0$0$0From the Water Utility Fund$111,250 $229,838$0$0$0$0$0$0$0$0$0From the Electric Utility Fund$64,058$0$0$0$0$0$0$0$0$0$0From the Parking Fund$0$0 $3,709,250$0$0$0 $3,709,250$0$0$0$0From the IT Fund$15,000$0$0$0$0$0$0$0$0$0$0Transfers In$3,907,978 $777,354 $5,918,260 ($111,000)$0 ($111,000) $5,807,260 $10,000 $75,000$0$0Total Revenues$10,469,222 $36,118,703 $9,723,680 ($111,000)$0 ($111,000) $9,612,680 $4,788,530 $4,142,150 $4,209,590 $4,383,440Property Tax Collection Fees$107,223 $67,835 $70,800$0$0$0$70,800 $72,220 $73,660 $75,130 $76,630Operational Costs$9,402$0$0$0$0$0$0$0$0$0$0Operating$116,625 $67,835 $70,800$0$0$0$70,800 $72,220 $73,660 $75,130 $76,630Clerks Office$9,395 $8,759 $12,000$0 ($12,000) ($12,000)$0 $26,000 $56,000 $14,000 $26,000Finance$92,000$0$0$0$0$0$0$0 $9,000$0$0Information Technology$0$0 $57,500 $195,700$195,700 $253,200$0 $35,500$0$0Asset Management$7,524,053 $11,813,207 $850,000 $28,640,949 ($740,000) $27,900,949 $28,750,949 $12,040,660 $129,000 $389,000 $2,650,000Planning$512,906 $73,817 $25,000 $19,262$0 $19,262$44,262$0$0$0$0Building$0$0$0$0$0$0$0$0$0$0 $10,000Police$92,798 $66,108$0 $144,255$0 $144,255 $144,255$0 $18,000 $12,000 $50,0002229
City of Aspen Budget000 ‐ Asset Management Plan Fund2018 2019 2020 20202020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionStreets$284,725 $778,130 $204,000 $237,600 ($204,000) $33,600 $237,600 $1,289,950 $1,992,300 $963,050 $765,400Conservation Efficiency Renewables$0$0 $70,000$0 ($70,000) ($70,000)$0 $75,000$0 $80,000$0Engineering$5,979,762 $1,103,265 $1,391,400 $699,246 ($251,500) $447,746 $1,839,146 $3,075,000 $1,471,000 $1,619,500 $1,156,000Environmental Health$31,517$0 $125,000$0 ($125,000) ($125,000)$0$0$0$0$0Recreation$545,755 $953,639 $508,000 $274,144 ($184,500) $89,644 $597,644 $916,680 $893,330 $328,190 $713,860Red Brick Center of the Arts$0 $99,860 $189,000$0 ($89,000) ($89,000) $100,000$0$0$0$0Capital$15,072,911 $14,896,786 $3,431,900 $30,211,156 ($1,676,000) $28,535,156 $31,967,056 $17,423,290 $4,604,130 $3,405,740 $5,371,26065100 ‐ Transfer to Parks Fund$12,500$0$0$0$0$0$0 $225,000$0$0$065160 ‐ Transfer to Stormwater Fund$60,000 $95,880$0$0$0$0$0$0$0$0$091012 ‐ 2015 STRR Bonds ‐ Parks$87,600 $46,000$0$0$0$0$0$0$0$0$0Transfers Out$160,100 $141,880$0$0$0$0$0 $225,000$0$0$0Total Uses$15,349,636 $15,106,501 $3,502,700 $30,211,156 ($1,676,000) $28,535,156 $32,037,856 $17,720,510 $4,677,790 $3,480,870 $5,447,890Ending Fund Balance$26,259,540 $47,271,740 $19,491,812 $3,678,752 ($1,676,000) $2,002,752 $24,846,564 $11,914,584 $11,378,944 $12,107,664 $11,043,214Restricted Fund Balance$24,134,420Unrestricted Fund Balance$23,137,320$24,846,564Change in Fund Balance($4,880,414) $21,012,202 $6,220,980 ($30,322,156) $1,676,000 ($28,646,156) ($22,425,176) ($12,931,980) ($535,640) $728,720 ($1,064,450)2330
City of Aspen Budget001 ‐ General Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$16,970,190 $16,800,695 $15,203,097$6,535,227$0$6,535,227 $21,738,324 $18,107,444 $15,527,594 $13,796,434 $13,504,784Property Tax$1,790,465 $4,138,066 $4,327,000$0$0$0 $4,327,000 $4,500,040$4,680,000 $4,867,160 $5,061,810Specific Ownership Tax$301,259 $301,780 $260,000$0($100,000) ($100,000)‐38% $160,000 $191,000 $228,000 $292,470 $304,170County Sales Tax$9,792,485 $12,080,894 $10,889,000$0 ($1,996,000) ($1,996,000)‐18% $8,893,000 $9,708,000 $10,598,000 $12,248,640 $12,738,590City Tobacco Tax$0 $403,589 $410,000$0 ($135,000) ($135,000)‐33% $275,000 $320,000 $373,000 $461,200 $479,650Other Taxes$1,549,849 $1,626,132 $1,515,720$0 ($100,000) ($100,000)‐7% $1,415,720 $1,462,000 $1,510,000 $1,608,490 $1,640,670State Government Shared Revenues$533,575 $168,011 $243,400$0$0$0$243,400 $248,270 $253,240 $258,310 $263,480Investment Income$302,041 $601,439 $304,060$0$0$0$304,060 $362,150 $310,550 $275,930 $270,100Other Revenues$5,220,067 $5,415,606 $5,644,800$0$0$0 $5,644,800 $5,842,400$6,047,000 $6,258,600 $6,477,500Unassigned Revenues$19,489,741 $24,735,517 $23,593,980$0 ($2,331,000) ($2,331,000) $21,262,980 $22,633,860 $23,999,790 $26,270,800 $27,235,970Mayor and Council$432$0$0$0$0$0$0$0$0$0$0Clerks Office$88,127$74,952 $63,000$0$0$0$63,000 $64,260 $65,530 $66,850 $68,170Managers Office$47,939 $19,496 $19,020$0$0$0$19,020 $19,400 $19,790 $20,190 $20,590Human Resources$3,223 $11,021$0$0$0$0$0$0$0$0$0Attorney$1,083 $2,228$0$0$0$0$0$0$0$0$0Finance$88,872 $105,214 $122,660$0$0$0$122,660 $125,110 $127,610 $130,170 $132,770Asset Management$67,150 $89,983 $46,360$0$0$0$46,360 $47,290 $48,230 $49,190 $50,170Planning$914,997 $1,127,100 $759,500$0$0$0 0% $759,500 $760,000 $760,000 $805,980 $822,110Building$5,725,723 $5,829,305 $4,600,000$0$0$0 0% $4,600,000 $4,600,000 $4,600,000 $4,881,570 $4,979,200Police$216,121 $235,612 $172,600$0$0$0$172,600 $176,050 $179,570 $183,140 $186,790Streets$528,262 $524,438 $486,540$0$0$0$486,540 $496,280 $506,200 $516,330 $526,660Engineering$1,032,885 $1,252,505 $1,071,280$0$0$0 0% $1,071,280 $1,071,000 $1,071,000 $1,136,850 $1,159,590Environmental Health$144,388 $103,878 $112,770 $10,880 ($12,500) ($1,620)‐11% $111,150 $115,020 $117,320 $119,670 $122,060Events$59,605 $122,482 $45,900$0$0$0$45,900 $46,820 $47,750 $48,710 $49,690Recreation$2,349,786 $2,564,464 $2,526,290$0 ($1,263,230) ($1,263,230)‐51% $1,263,060 $2,274,000 $2,729,000 $2,678,400 $2,731,160Red Brick Arts$666,204 $613,168 $467,500$0$0$0$467,500 $476,250 $485,180 $494,290 $503,580Department Collections$11,934,797 $12,675,846 $10,493,420 $10,880 ($1,275,730) ($1,264,850) $9,228,570 $10,271,480 $10,757,180 $11,131,340 $11,352,540Total Revenues$31,424,538 $37,411,363 $34,087,400 $10,880 ($3,606,730) ($3,595,850) $30,491,550 $32,905,340 $34,756,970 $37,402,140 $38,588,510From the Parks and Open Space Fund$33,150 $36,360 $36,360 $1,960$0 $1,960$38,320 $36,360 $36,360 $36,360 $36,360From the Wheeler Opera House Fund$2,060$0$0 $9,000 $3,500,000 $3,509,000 $3,509,000$0$0$0$0From the Tourism Promotion Fund$0$0$0$0$0$0$0$0$0$0$0From the REMP Fund$0 $187,000 $145,400$0$0$0$145,400 $148,000 $151,000 $154,000 $157,000From the Transportation Fund$54,090 $78,630 $66,230 $7,410$0 $7,410$73,640 $66,230 $66,230 $66,230 $66,230From the Housing Development Fund$3,120 $5,100 $5,100$0$0$0$5,100 $5,100 $5,100 $5,100 $5,100From the Kids First Fund$10,910 $9,210 $6,060 $6,450$0 $6,450$12,510 $6,060 $6,060 $6,060 $6,060From the Stormwater Fund$8,830 $19,420$0 $25,110$0 $25,110$25,110$0$0$0$0From the Water Utility Fund$991,290 $1,189,050 $1,133,000 $1,000$0 $1,000 $1,134,000 $1,111,000$1,089,000 $1,067,000 $1,045,000From the Electric Utility Fund$344,320 $616,030 $611,500 $43,950$0 $43,950$655,450 $640,000 $659,000 $678,500 $693,900From the Parking Fund$0$0$0 $1,000$0 $1,000$1,000$0$0$0$0From the Golf Course Fund$1,940 $750$0 $5,170$0 $5,170$5,170$0$0$0$0From the IT Fund$3,070 $6,400$0 $1,000$0 $1,000$1,000$0$0$0$0From the APCHA Fund$0 $27,980$0$0$0$0$0$0$0$0$0Transfers In$1,452,780 $2,175,930 $2,003,650 $102,050 $3,500,000 $3,602,050 $5,605,700 $2,012,750 $2,012,750 $2,013,250 $2,009,650Total Revenues$32,877,318 $39,587,293 $36,091,050 $112,930($106,730) $6,200 $36,097,250 $34,918,090 $36,769,720 $39,415,390 $40,598,1602431
City of Aspen Budget001 ‐ General Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionNon‐Classified$255,924 $83,197 $86,520 $0 $0 $0 $86,520 $88,250 $90,020 $91,820 $93,660Mayor and Council$1,676,624 $1,812,657 $1,807,570 $33,420 $3,500,000 $3,533,420 $5,340,990 $1,814,340 $1,824,390 $1,834,730 $1,845,370Clerks Office$614,027 $678,593 $710,830 $44,190 ($64,610) ($20,420) $690,410 $734,670 $759,430 $785,300 $812,290Managers Office$1,384,291 $1,623,268 $1,582,940 $1,017,400 ($344,190) $673,210 $2,256,150 $1,642,070 $1,703,800 $1,768,260 $1,835,610Human Resources$811,783 $786,173 $911,640 $62,310 ($102,400) ($40,090)$871,550 $942,820$975,270 $1,009,160 $1,044,500Attorney$497,570 $504,463 $590,990 $83,530 ($77,410) $6,120$597,110 $612,500 $634,900 $658,300 $682,690Finance$2,086,793 $2,032,072 $2,218,380 $422,930 ($334,010) $88,920 $2,307,300 $2,296,980 $2,379,020 $2,464,730 $2,554,270Asset Management$1,531,070 $1,676,550 $1,853,270 $52,260 ($103,970) ($51,710) $1,801,560 $1,911,250 $1,969,780 $2,031,900 $2,097,090Planning$1,745,259 $1,926,159 $1,957,760 $373,460 ($301,540) $71,920 $2,029,680 $1,810,120 $1,881,720 $1,956,700 $2,035,290Building$2,014,139 $1,962,671 $1,885,280 $41,670 ($110,210) ($68,540) $1,816,740 $1,879,090 $1,951,100 $2,026,480 $2,105,460Police$5,245,741 $5,357,594 $5,589,980 $219,910 ($422,710) ($202,800) $5,387,180 $5,795,470 $6,010,200 $6,234,680 $6,469,470Streets$1,679,872 $1,905,486 $2,025,280 $551,630 ($306,320) $245,310 $2,270,590 $2,092,600 $2,162,780 $2,235,970 $2,312,340Conservation Efficency Renewables$58,663 $511,587 $631,950 $4,670 ($81,380) ($76,710)$555,240 $654,130 $677,260 $701,400 $726,660Engineering$1,857,698 $2,130,692 $2,249,550 $98,090 ($194,360) ($96,270) $2,153,280 $2,325,930 $2,405,510 $2,488,510 $2,575,030Environmental Health$665,963 $778,621 $1,059,470 $122,630 ($176,480) ($53,850) $1,005,620 $990,690$1,023,180 $1,057,010 $1,092,290Events$761,191 $875,758 $949,660 $142,420 ($197,890) ($55,470)$894,190 $979,120$1,009,740 $1,041,580 $1,074,710Recreation$4,588,002 $4,698,191 $4,383,423 $353,920 ($410,490)($56,570) $4,326,853 $4,534,540 $4,657,000 $4,809,450 $4,980,770Red Brick Arts$417,067 $451,445 $517,710 $78,150 ($59,830) $18,320$536,030 $534,560 $552,100 $570,370 $589,380Parks and Recreation$216,340 $130,837 $238,840$0 ($2,880) ($2,880)$235,960 $247,200 $255,940 $265,080 $274,640Business Services Group$0$0 $211,007$0$0$0$211,007 $215,230 $219,540 $223,910 $228,390Operating$28,108,017 $29,926,014 $31,462,050 $3,702,590 $209,320 $3,911,910 $35,373,960 $31,886,330 $32,923,140 $34,031,430 $35,201,520IT Overhead$1,010,400 $1,160,700 $1,339,000$0$0$0 $1,339,000 $1,298,210$1,218,490 $1,280,000 $1,288,840Overhead Allocations$1,010,400 $1,160,700 $1,339,000$0$0$0 $1,339,000 $1,298,210 $1,218,490 $1,280,000 $1,288,840To the AMP Fund$2,041,100 $16,000$0$0$0$0$0$0$0$0$0To the Parks and Open Space Fund$0$0 $177,300$0$0$0$177,300$180,800 $184,400 $188,100 $191,900To the Wheeler Opera House Fund$0$0$0$0$0$0$0 $364,210 $364,210 $364,210 $364,210To the Transportation Fund$128,850 $22,800$0$0$0$0$0$0$0$0$0To the Debt Service Fund$1,156,450 $1,813,120 $2,510,280$0$0$0 $2,510,280 $2,509,390$2,513,440 $2,507,600 $2,509,630To the Parking Fund$55,584 $30,000 $30,000$0$0$0$30,000 $30,000 $30,000 $30,000 $30,000To the Employee Housing Fund$546,408$1,147,600 $1,190,500$0 ($892,910) ($892,910)$297,590 $1,229,000$1,267,200 $1,305,700 $1,344,200Other Transfers$3,928,392 $3,562,950 $3,908,080$0 ($892,910) ($892,910) $3,015,170 $4,313,400 $4,359,250 $4,395,610 $4,439,940Transfers Out$4,938,792 $4,723,650 $5,247,080$0 ($892,910) ($892,910) $4,354,170 $5,611,610 $5,577,740 $5,675,610 $5,728,780Total Uses$33,046,809 $34,649,664 $36,709,130 $3,702,590 ($683,590) $3,019,000 $39,728,130 $37,497,940 $38,500,880 $39,707,040 $40,930,300Targeted Reserve (25% of Uses)$8,261,702 $8,662,416 $9,177,283 $925,648 ($170,898) $754,750 $9,932,033 $9,374,485 $9,625,220 $9,926,760 $10,232,575Ending Fund Balance$16,800,695 $21,738,324 $14,585,017 $2,945,567 $576,860 $3,522,427 $18,107,444 $15,527,594 $13,796,434 $13,504,784 $13,172,644Ending Balance as % of Targeted Reserve203% 251% 172%0%182% 166% 143% 136% 129%Over/(Short) of Targeted Reserve$8,538,993 $13,075,908 $6,452,810$0 $6,452,810 $6,153,109 $4,171,214 $3,578,024 $2,940,069Change in Fund Balance($169,491) $4,937,629 ($618,080) ($3,589,660) $576,860 ($3,012,800)($3,630,880) ($2,579,850) ($1,731,160) ($291,650) ($332,140)2532
City of Aspen Budget100 ‐ Parks and Open Space Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$7,610,576 $6,919,689 $4,744,089 $2,978,283$0 $2,978,283 $7,722,372 $4,222,250 $2,427,819 $1,981,652 $3,085,402City Sales Tax$7,547,919 $8,202,433 $8,084,500$0 ($2,743,100) ($2,743,100)‐34% $5,341,400 $6,248,000 $7,308,000 $9,093,970 $9,457,730City Sales Tax ‐ Sunset$3,773,054 $4,099,705 $4,042,200$0 ($1,371,600) ($1,371,600)‐34% $2,670,600 $3,124,000 $3,654,000 $4,546,930 $4,728,810Tax Related$11,320,973 $12,302,138 $12,126,700$0 ($4,114,700) ($4,114,700)‐34% $8,012,000$9,372,000 $10,962,000$13,640,900 $14,186,540Interest Income$103,512 $229,053 $94,880$0$0$0$94,880 $84,450 $48,560 $39,630 $61,710Non‐Tax Related$547,902 $669,863 $129,150$0$0$0$129,150 $131,730 $134,360 $137,040 $139,780Non‐Classified$11,972,387 $13,201,054 $12,350,730$0 ($4,114,700) ($4,114,700) $8,236,030 $9,588,180 $11,144,920 $13,817,570 $14,388,03057220 ‐ Tree Program$317,242 $377,636 $204,000$0$0$0$204,000 $208,080 $212,240 $216,480 $220,810Forestry and Natural Areas$317,242 $377,636 $204,000$0$0$0$204,000 $208,080 $212,240 $216,480 $220,81057310 ‐ Trails Maintenance$820$0$0$0$0$0$0$0$0$0$057320 ‐ Nordic Maintenance$281,944 $305,124 $330,580$0$0$0$330,580 $337,190 $343,930 $350,810 $357,830Trails Management$282,763 $305,124 $330,580$0$0$0$330,580 $337,190 $343,930 $350,810 $357,83057410 ‐ Parks Maintenance$165,317 $48,975 $346,800$0$0$0$346,800 $353,730 $360,800 $368,020 $375,38057420 ‐ Cozy Point$1,200 $1,100 $20,400$0$0$0$20,400 $20,810 $21,230 $21,650 $22,080Parks Management$166,517 $50,075 $367,200$0$0$0$367,200 $374,540 $382,030 $389,670 $397,46081200 ‐ Capital Projects$42,000 $174,100$0$0$0$0$0$0$0$0$0Capital Projects$42,000 $174,100$0$0$0$0$0$0$0$0$0Revenues In$12,780,909 $14,107,988 $13,252,510$0 ($4,114,700) ($4,114,700) $9,137,810 $10,507,990 $12,083,120 $14,774,530 $15,364,130From the AMP Fund$12,500$0$0$0$0$0$0 $225,000$0$0$0From the General Fund$0$0 $177,300$0$0$0$177,300 $180,800 $184,400 $188,100 $191,900From the Stormwater Fund$0 $12,500 $100,000$0 ($100,000) ($100,000)$0$0$0$0 $300,000From the Water Utility Fund$150,000 $150,000 $150,000$0$0$0$150,000 $150,000 $150,000 $150,000$0From the Golf Course Fund$13,104 $13,100 $13,100$0$0$0$13,100 $13,100 $13,100 $13,100 $13,100Transfers In$175,604 $175,600 $440,400$0 ($100,000) ($100,000)$340,400 $568,900 $347,500 $351,200 $505,000Total Revenues$12,956,513 $14,283,588 $13,692,910$0 ($4,214,700) ($4,214,700) $9,478,210 $11,076,890 $12,430,620 $15,125,730 $15,869,130$0$0$000000 ‐ Non‐Classified$39,304 $27,921$0 $104,970 ($52,490) $52,480$52,480$0$0$0$0Non‐Classified$39,304 $27,921$0 $104,970 ($52,490) $52,480$52,480$0$0$0$010010 ‐ General Administrative$998,924 $895,725 $797,050 $4,540 ($120,020) ($115,480)$681,570 $826,140 $856,520 $888,260 $921,41010040 ‐ Sales Tax Refunds$108,432 $130,470 $121,300$0$0$0$121,300 $123,730 $126,200 $128,720 $131,29010050 ‐ Minor Capital Outlay$27,516 $8,728 $10,660 $3,420$0 $3,420$14,080 $10,870 $11,090 $11,310 $11,53010070 ‐ Business Services$0$0 $251,570$0 ($18,500) ($18,500)$233,070 $256,600 $261,740 $266,980 $272,310Administrative$1,134,872 $1,034,923 $1,180,580 $7,960 ($138,520) ($130,560) $1,050,020 $1,217,340 $1,255,550 $1,295,270 $1,336,54057110 ‐ Clean Team / Snow Removal$125,513 $175,673 $223,550 $1,600 ($4,110) ($2,510)$221,040 $233,060 $243,060 $253,580 $264,640Downtown Beautification$125,513 $175,673 $223,550 $1,600 ($4,110) ($2,510)$221,040 $233,060 $243,060 $253,580 $264,64011929 ‐ Parks Department Campus$33,662 $44,784 $168,060$0 ($3,980) ($3,980)$164,080 $174,210 $180,630 $187,360 $194,38011999 ‐ Other Facility / Maintenance$0$0 $69,800$0 ($8,000) ($8,000)$61,800 $71,210 $72,650 $74,100 $75,560Facilities Maintenance$33,662 $44,784 $237,860$0 ($11,980) ($11,980)$225,880 $245,420 $253,280 $261,460 $269,94057210 ‐ Open Space Management$303,569 $313,827 $298,010 $3,950 ($117,610) ($113,660)$184,350 $308,560 $319,590 $331,110 $343,14057220 ‐ Tree Program$301,592 $354,126 $328,630 $3,890 ($22,220) ($18,330)$310,300 $339,370 $350,560 $362,240 $374,410Forestry and Natural Areas$605,161 $667,953 $626,640 $7,840 ($139,830) ($131,990)$494,650 $647,930 $670,150 $693,350 $717,5502633
City of Aspen Budget100 ‐ Parks and Open Space Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection Projection57310 ‐ Trails Maintenance$415,205 $438,654 $503,930 $6,590 ($15,280) ($8,690) $495,240 $522,830 $542,590 $563,240 $584,83057320 ‐ Nordic Maintenance$264,457 $310,915 $285,740 $3,760 ($5,060) ($1,300) $284,440 $296,060 $306,840 $318,130 $329,930Trails Management$679,662 $749,569 $789,670 $10,350 ($20,340) ($9,990) $779,680 $818,890 $849,430 $881,370 $914,76057410 ‐ Parks Maintenance$2,243,341 $2,204,030 $2,265,330 $29,900 ($99,580) ($69,680) $2,195,650 $2,127,971 $2,293,747 $2,493,610 $2,576,02057420 ‐ Cozy Point$123,479 $153,611 $148,410 $1,190 ($3,240) ($2,050) $146,360 $152,870 $157,540 $162,370 $167,410Parks Management$2,366,820 $2,357,641 $2,413,740 $31,090 ($102,820) ($71,730) $2,342,010 $2,280,841 $2,451,287 $2,655,980 $2,743,43059020 ‐ Parks Grants$21,000 $33,000 $33,000 $0 $0 $0 $33,000 $33,000 $33,000 $33,000 $33,000Grants$21,000 $33,000 $33,000 $0 $0 $0 $33,000 $33,000 $33,000 $33,000 $33,000Operating$5,005,994 $5,091,464 $5,505,040 $163,810 ($470,090) ($306,280) $5,198,760 $5,476,481 $5,755,757 $6,074,010 $6,279,86081100 ‐ Capital Labor$726,142 $862,001 $761,470 $14,840 ($8,590) $6,250 $767,720 $791,700 $823,300 $856,340 $890,93081200 ‐ Capital Projects$1,618,143 $1,977,810 $2,315,800 $1,373,992 ($1,835,300) ($461,308) $1,854,492 $957,900 $708,000 $1,500,000 $2,045,200Capital$2,344,285 $2,839,811 $3,077,270 $1,388,832 ($1,843,890) ($455,058) $2,622,212 $1,749,600 $1,531,300 $2,356,340 $2,936,130General Fund Overhead$1,074,996 $1,117,700 $1,137,500 $0 $0 $0 $1,137,500 $1,177,300 $1,218,500 $1,261,100 $1,305,200IT Overhead$126,300 $155,900 $209,200 $0 $0 $0 $209,200 $202,830 $190,380 $199,990 $201,370Overhead Allocations$1,201,296 $1,273,600 $1,346,700 $0 $0 $0 $1,346,700 $1,380,130 $1,408,880 $1,461,090 $1,506,570To the AMP Fund$1,461,064 $362,300 $0 $0 $0 $0 $0 $10,000 $75,000 $0 $0To the General Fund$33,150 $36,360 $36,360 $1,960$0 $1,960$38,320 $36,360 $36,360 $36,360 $36,360To the Debt Service Fund$2,953,500 $3,062,270 $3,232,350$0$0$0 $3,232,350 $3,239,650 $3,240,050 $3,237,720 $3,238,120To the Golf Course Fund$506,304 $528,000 $672,240$0 ($210,000) ($210,000)$462,240 $647,400 $487,340 $504,060 $530,930To the Employee Housing Fund$141,804 $287,100 $311,000$0 ($233,250) ($233,250)$77,750 $331,700 $342,100 $352,400 $362,800Other Transfers$5,095,822 $4,276,030 $4,251,950 $1,960 ($443,250) ($441,290) $3,810,660 $4,265,110 $4,180,850 $4,130,540 $4,168,210Transfers Out$6,297,118 $5,549,630 $5,598,650 $1,960 ($443,250) ($441,290) $5,157,360 $5,645,240 $5,589,730 $5,591,630 $5,674,780Total Uses$13,647,397 $13,480,905 $14,180,960 $1,554,602 ($2,757,230) ($1,202,628) $12,978,332 $12,871,321 $12,876,787 $14,021,980 $14,890,770Targeted Reserve (12.5% of Uses)$1,705,925 $1,685,113 $1,772,620($150,329) $1,622,292 $1,608,915 $1,609,598 $1,752,748 $1,861,346Ending Fund Balance$6,919,689 $7,722,372 $4,256,039 $1,423,681 ($1,457,470) ($33,789) $4,222,250 $2,427,819 $1,981,652 $3,085,402 $4,063,762Ending Balance as % of Targeted Reserve406% 458% 240%22%260% 151% 123% 176% 218%Over/(Short) of Targeted Reserve$5,213,764 $6,037,259 $2,483,419$116,540 $2,599,959 $818,904 $372,054 $1,332,655 $2,202,416Change in Fund Balance($690,884) $802,683 ($488,050) ($1,554,602) ($1,457,470) ($3,012,072) ($3,500,122) ($1,794,431) ($446,167) $1,103,750 $978,3602734
City of Aspen Budget120 ‐ Wheeler Opera House Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$31,861,383 $30,808,392 $29,853,589 $2,762,854$0 $2,762,854 $32,616,443 $26,465,652 $27,546,392 $29,213,822 $31,205,732Real Estate Transfer Tax$4,633,568 $4,420,987 $3,962,000$0 ($1,981,000) ($1,981,000)‐50% $1,981,000 $4,160,100 $4,368,110 $4,586,520 $4,815,850Investment Income$509,841 $1,237,548 $597,070$0$0$0$597,070 $605,190 $619,520 $645,580 $678,140Other Revenues$7,373$1$0$0$0$0$0$0$0$0$0Non‐Classified$5,150,782 $5,658,536 $4,559,070$0 ($1,981,000) ($1,981,000) $2,578,070 $4,765,290 $4,987,630 $5,232,100 $5,493,99051110 ‐ Presented Events$557,284 $630,744 $543,500$0$0$0$543,500 $554,370 $565,460 $576,770 $588,31051120 ‐ Rental Events$108,712 $181,133 $115,250$0$0$0$115,250 $117,560 $119,910 $122,300 $124,74051130 ‐ Box Office$201,931 $207,224 $157,500$0$0$0$157,500 $160,650 $163,870 $167,150 $170,500Arts$867,927 $1,019,101 $816,250$0$0$0$816,250 $832,580 $849,240 $866,220 $883,55011918 ‐ Wheeler ‐ Rental Spaces$148,068 $185,633 $205,130 $9,000$0 $9,000$214,130 $209,230 $213,410 $217,680 $222,030Facilities Maintenance$148,068 $185,633 $205,130 $9,000$0 $9,000$214,130 $209,230 $213,410 $217,680 $222,030Revenues In$6,166,777 $6,863,270 $5,580,450 $9,000 ($1,981,000) ($1,972,000) $3,608,450 $5,807,100 $6,050,280 $6,316,000 $6,599,570From the General Fund$0$0$0$0$0$0$0 $364,210 $364,210 $364,210 $364,210From the Water Utility Fund$284,770$284,770 $284,770$0$0$0$284,770 $284,770 $284,770 $284,770 $284,770Transfers In$284,770 $284,770 $284,770$0$0$0$284,770 $648,980 $648,980 $648,980 $648,980Total Revenues$6,451,547 $7,148,040 $5,865,220 $9,000 ($1,981,000) ($1,972,000) $3,893,220 $6,456,080 $6,699,260 $6,964,980 $7,248,550$0$000000 ‐ Non‐Classified$13,500 $4,381$0$0$0$0$0$0$0$0$0Non‐Classified$13,500 $4,381$0$0$0$0$0$0$0$0$010010 ‐ General Administrative$386,579 $458,935 $459,970 $1,600 ($19,060) ($17,460)$442,510 $474,750 $490,140 $506,180 $522,90010020 ‐ Long Range Planning$0 $58,812$0 $35,000$0 $35,000$35,000$0$0$0$010030 ‐ Public Outreach$83,172 $75,533 $73,140 $630 ($5,580) ($4,950)$68,190 $76,050 $79,100 $82,300 $85,66010050 ‐ Minor Capital Outlay$8,298 $17,348 $9,170 $5,830$0 $5,830$15,000 $9,360 $9,550 $9,740 $9,940Administrative$478,049 $610,628 $542,280 $43,060 ($24,640) $18,420$560,700 $560,160 $578,790 $598,220 $618,50051110 ‐ Presented Events$1,762,184 $1,778,279 $1,843,260 $4,200 ($161,560) ($157,360) $1,685,900 $1,888,630 $1,935,360 $1,983,530 $2,033,20051120 ‐ Rental Events$248,625 $327,930 $288,130 $2,720 ($10,030) ($7,310)$280,820 $300,030 $312,510 $325,600 $339,35051130 ‐ Box Office$150,066 $135,559 $87,700 $780 ($6,830) ($6,050)$81,650 $90,670 $93,750 $96,970 $100,35051140 ‐ Indirect Production Costs$289,809 $301,315 $285,100 $2,390 ($4,230)($1,840)$283,260$296,150 $307,720 $319,840 $332,570Arts$2,450,684 $2,543,083 $2,504,190 $10,090 ($182,650) ($172,560) $2,331,630 $2,575,480 $2,649,340 $2,725,940 $2,805,47011917 ‐ Wheeler ‐ Theatre Spaces$474,718 $419,117 $383,250 $1,760 ($6,710) ($4,950)$378,300 $394,120 $405,380 $417,070 $429,2002835
City of Aspen Budget120 ‐ Wheeler Opera House Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection Projection11918 ‐ Wheeler ‐ Rental Spaces$66,223 $25,627 $21,200 $17,050 ($80) $16,970$38,170 $21,730 $22,280 $22,850 $23,430Facilities Maintenance$540,941 $444,744 $404,450 $18,810 ($6,790) $12,020$416,470 $415,850 $427,660 $439,920 $452,63059010 ‐ Arts Grants$395,000 $400,753 $400,000$0$0$0$400,000 $400,000 $400,000 $400,000 $400,000Grants$395,000 $400,753 $400,000$0$0$0$400,000 $400,000 $400,000 $400,000 $400,000Operating$3,878,174 $4,003,589 $3,850,920 $71,960 ($214,080) ($142,120) $3,708,800 $3,951,490 $4,055,790 $4,164,080 $4,276,60081200 ‐ Capital Projects$543,538 $631,000 $975,100 $2,006,991($703,000) $1,303,991 $2,279,091$774,540 $318,600 $126,930 $167,130Capital$543,538 $631,000 $975,100 $2,006,991 ($703,000) $1,303,991 $2,279,091 $774,540 $318,600 $126,930 $167,130General Fund Overhead$415,704 $468,900 $367,700$0$0$0$367,700 $380,600 $393,900 $407,700 $422,000IT Overhead$92,604 $121,700 $150,700$0$0$0$150,700 $146,110 $137,140 $144,060 $145,050Overhead Allocations$508,308 $590,600 $518,400$0$0$0$518,400 $526,710 $531,040 $551,760 $567,050To the General Fund$2,060$0$0 $9,000 $3,500,000 $3,509,000 $3,509,000$0$0$0$0To the Water Utility Fund$2,515,000$0$0$0$0$0$0$0$0$0$0To the Employee Housing Fund$57,600 $114,800 $114,900$0 ($86,180) ($86,180)$28,720 $122,600 $126,400 $130,300 $134,100Other Transfers$2,574,660 $114,800 $114,900 $9,000 $3,413,820 $3,422,820 $3,537,720 $122,600 $126,400 $130,300 $134,100Transfers Out$3,082,968 $705,400 $633,300 $9,000 $3,413,820 $3,422,820 $4,056,120 $649,310 $657,440 $682,060 $701,150Total Uses$7,504,680 $5,339,989 $5,459,320 $2,087,951 $2,496,740 $4,584,691 $10,044,011 $5,375,340 $5,031,830 $4,973,070 $5,144,880Targeted Reserve (25.0% of Uses)$1,876,170 $1,334,997 $1,364,830$1,146,173$2,511,003$1,343,835 $1,257,958 $1,243,268 $1,286,220Ending Fund Balance$30,808,392 $32,616,443 $30,259,489 $683,903 ($4,477,740) ($3,793,837) $26,465,652 $27,546,392 $29,213,822 $31,205,732 $33,309,402Ending Balance as % of Targeted Reserve1,642% 2,443% 2,217%(331%)1,054% 2,050% 2,322% 2,510% 2,590%Over/(Short) of Targeted Reserve$28,932,222 $31,281,446 $28,894,659($4,940,010) $23,954,649 $26,202,557 $27,955,865 $29,962,465 $32,023,182Change in Fund Balance($1,053,133) $1,808,051 $405,900 ($2,078,951) ($4,477,740) ($6,556,691) ($6,150,791) $1,080,740 $1,667,430 $1,991,910 $2,103,6702936
City of Aspen Budget130 ‐ Tourism Promotion Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$93,671 $75,541 $90,421 $13,209$13,209$103,630 $105,440 $105,440 $105,440 $105,4401.5% Lodging Tax$2,767,454 $2,914,139 $2,991,800$0 ($1,240,900) ($1,240,900) $1,750,900 $3,111,470 $3,235,930 $3,365,370 $3,499,980Investment Interest$4,926 $5,380 $1,810$0$0$0$1,810 $2,110 $2,110 $2,110 $2,110Marketing and Tourism Promotion$2,772,380 $2,919,519 $2,993,610$0 ($1,240,900) ($1,240,900) $1,752,710 $3,113,580 $3,238,040 $3,367,480 $3,502,090Revenues In$2,772,380 $2,919,519 $2,993,610$0 ($1,240,900) ($1,240,900) $1,752,710 $3,113,580 $3,238,040 $3,367,480 $3,502,090Total Revenues$2,772,380 $2,919,519 $2,993,610$0 ($1,240,900) ($1,240,900) $1,752,710 $3,113,580 $3,238,040 $3,367,480 $3,502,09011010 ‐ Marketing And Tourism Promotion$2,790,510 $2,891,430 $2,991,800$0 ($1,240,900) ($1,240,900) $1,750,900 $3,113,580 $3,238,040 $3,367,480 $3,502,090Marketing and Tourism Promotion$2,790,510 $2,891,430 $2,991,800$0 ($1,240,900) ($1,240,900) $1,750,900 $3,113,580 $3,238,040 $3,367,480 $3,502,090Operating$2,790,510 $2,891,430 $2,991,800$0 ($1,240,900) ($1,240,900) $1,750,900 $3,113,580 $3,238,040 $3,367,480 $3,502,090Total Uses$2,790,510 $2,891,430 $2,991,800$0 ($1,240,900) ($1,240,900) $1,750,900 $3,113,580 $3,238,040 $3,367,480 $3,502,090Ending Fund Balance$75,541 $103,630 $92,231 $13,209$0 $13,209$105,440 $105,440 $105,440 $105,440 $105,440Change in Fund Balance($18,130) $28,089 $1,810$0$0$0$1,810$0$0$0$03037
City of Aspen Budget131 ‐ Public Education Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$4,767 ($36,132)$0$0$0$0$0$0$0$00.3% Sales Tax ‐ Sunset$2,274,410 $2,469,812 $2,920,000($823,000) ($823,000) ($0) $2,097,000 $2,180,880 $2,268,120 $2,358,840 $2,453,190Investment Interest$0 $201$0$0$0$0$0$0$0Public Education Funds$2,274,410 $2,470,013 $2,920,000$0 ($823,000) ($823,000) $2,097,000 $2,180,880 $2,268,120 $2,358,840 $2,453,190Revenues In$2,274,410 $2,470,013 $2,920,000$0 ($823,000) ($823,000) $2,097,000 $2,180,880 $2,268,120 $2,358,840 $2,453,190Total Revenues$2,274,410 $2,470,013 $2,920,000$0 ($823,000) ($823,000) $2,097,000 $2,180,880 $2,268,120 $2,358,840 $2,453,19061000 ‐ Public Education Funds (Admin Costs)$46,306 $49,546 $58,400$0$58,400 $43,620 $45,360 $47,180 $49,06061000 ‐ Public Education Funds (Disbursements)$2,269,003 $2,384,335 $2,861,600($823,000) ($823,000) $2,038,600 $2,137,260 $2,222,760 $2,311,660 $2,404,130Public Education Funds$2,315,309 $2,433,881 $2,920,000$0 ($823,000) ($823,000) $2,097,000 $2,180,880 $2,268,120 $2,358,840 $2,453,190Operating$2,315,309 $2,433,881 $2,920,000$0 ($823,000) ($823,000) $2,097,000 $2,180,880 $2,268,120 $2,358,840 $2,453,190Total Uses$2,315,309$2,433,881 $2,920,000$0 ($823,000)($823,000) $2,097,000 $2,180,880 $2,268,120 $2,358,840 $2,453,190Ending Fund Balance($36,132)$0$0$0$0$0$0$0$0$0$03138
City of Aspen Budget132 ‐ Renewable Energy Mitigation Program Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$5,182,618 $5,201,667 $4,900,697 $338,160$0 $338,160 $5,238,857 $4,207,467 $3,975,937 $3,753,427 $3,540,447REMP ‐ renewable energy mitigation plan$1,114,807 $1,312,346 $816,000$0$0$0$816,000 $832,320 $848,970 $865,950 $883,270Other Revenues$89,242 $204,823 $98,010$0$0$0$98,010 $84,150 $79,520 $75,070 $70,810Revenues In$1,204,049 $1,517,169 $914,010$0$0$0$914,010 $916,470 $928,490 $941,020 $954,080Total Revenues$1,204,049 $1,517,169 $914,010$0 $0 $0$914,010 $916,470 $928,490 $941,020 $954,080Agency Distributions$1,185,000 $1,292,979 $1,800,000$0$0$0 $1,800,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000Operating$1,185,000 $1,292,979 $1,800,000$0$0$0 $1,800,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000Transfers to the General Fund$0 $187,000 $145,400$0$0$0$145,400 $148,000 $151,000 $154,000 $157,000Transfers Out$0 $187,000 $145,400$0$0$0$145,400 $148,000 $151,000 $154,000 $157,000Total Uses$1,185,000 $1,479,979 $1,945,400$0$0$0 $1,945,400 $1,148,000 $1,151,000 $1,154,000 $1,157,000Ending Fund Balance$5,201,667 $5,238,857 $3,869,307 $338,160$0 $338,160 $4,207,467 $3,975,937 $3,753,427 $3,540,447 $3,337,5273239
3340
City of Aspen Budget141 ‐ Transportation FundCARES funding offsetting loss on 1% transit tax in 20202018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact From COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$4,237,236 $6,185,866 $4,228,581 $3,485,739$0 $3,485,739 $7,714,320 $6,141,650 $4,681,390 $4,122,510 $4,023,580City Sales Tax$1,132,101 $1,230,271 $1,212,700$0 ($411,400) ($411,400)‐34% $801,300 $937,000 $1,096,000 $1,364,130 $1,418,700Lodging Tax$922,482 $971,378 $997,300$0 ($413,700) ($413,700)‐41% $583,600 $705,000 $851,000 $1,121,830 $1,166,700Use Tax$1,092,681 $2,240,191 $1,000,000$0 ($500,000) ($500,000)‐50% $500,000 $500,000 $500,000 $500,000 $500,000Tax Related$3,147,264 $4,441,840 $3,210,000$0 ($1,325,100) ($1,325,100) $1,884,900 $2,142,000 $2,447,000 $2,985,960 $3,085,400Investment Income$191,497 $216,466 $84,570$0$0$0$84,570 $122,830 $93,630 $82,450 $80,470Non‐Tax Related$282,414 $303,951 $10,200$0$0$0$10,200 $10,400 $10,610 $10,820 $11,040Non‐Classified$3,621,175 $4,962,257 $3,304,770$0 ($1,325,100) ($1,325,100) $1,979,670 $2,275,230 $2,551,240 $3,079,230 $3,176,91011924 ‐ Rubey Park Transit Center$41,524 $32,241 $45,000$0$0$0$45,000 $45,900 $46,820 $47,760 $48,720Property / Facilities Maintenance$41,524 $32,241 $45,000$0$0$0$45,000 $45,900 $46,820 $47,760 $48,72013100 ‐ Mass Transit$318,713 $283,972 $217,260$0$0$0$217,260 $221,600 $226,030 $230,550 $235,160Mass Transit$318,713 $283,972 $217,260$0$0$0$217,260 $221,600 $226,030 $230,550 $235,16013200 ‐ Alternative Transit$41,232 $43,917 $43,860$0$0$0$43,860 $44,740 $45,630 $46,540 $47,470Alternative Transit$41,232 $43,917 $43,860$0$0$0$43,860 $44,740 $45,630 $46,540 $47,47013300 ‐ Transportation Demand Management$0 $81 $10,200$0$0$0$10,200 $10,400 $10,610 $10,820 $11,040Transportation Demand Management$0 $81 $10,200$0$0$0$10,200 $10,400 $10,610 $10,820 $11,04081200 ‐ Capital Projects$1,080,000 $614,957 $33,000$0$0$0$33,000$0$0 $46,400$0Capital$1,080,000 $614,957 $33,000$0$0$0$33,000$0$0 $46,400$0Revenues In$5,102,644 $5,937,425 $3,654,090$0 ($1,325,100) ($1,325,100) $2,328,990 $2,597,870 $2,880,330 $3,461,300 $3,519,300From the General Fund$128,850 $22,800$0$0$0$0$0$0$0$0$0From the Parking Fund$1,749,996 $1,750,000 $1,750,000$0$0$0 $1,750,000 $1,750,000 $1,750,000 $1,750,000 $1,750,000Transfers In$1,878,846 $1,772,800 $1,750,000$0$0$0 $1,750,000 $1,750,000 $1,750,000 $1,750,000 $1,750,000Total Revenues$6,981,490 $7,710,225 $5,404,090$0 ($1,325,100) ($1,325,100) $4,078,990 $4,347,870 $4,630,330 $5,211,300 $5,269,300$0$0$000000 ‐ Non‐Classified$5,400$0$0 $161,980 ($80,990) $80,990$80,990$0$0$0$0Non‐Classified$5,400$0$0 $161,980 ($80,990) $80,990$80,990$0$0$0$010010 ‐ General Administrative$165,381 $182,325 $168,790 $320 ($1,660) ($1,340)$167,450 $174,800 $181,080 $187,610 $194,44010020 ‐ Long Range Planning$364,739 $54,766$0$0$0$0$0$0$0$0$010040 ‐ Sales Tax Refunds$10,813 $12,950 $12,120$0$0$0$12,120 $12,360 $12,610 $12,860 $13,12010050 ‐ Minor Capital Outlay$6,204 $377 $1,890 $11,120$0 $11,120$13,010 $1,930 $1,970 $2,010 $2,050Administrative$547,137 $250,418 $182,800 $11,440 ($1,660) $9,780$192,580 $189,090 $195,660 $202,480 $209,61011905 ‐ Main Street Cabin$15,968 $17,954 $31,180$0$0$0$31,180 $31,790 $32,420 $33,070 $33,72011924 ‐ Rubey Park Transit Center$252,292 $266,225 $316,130$50 ($830) ($780)$315,350 $323,620 $331,290 $339,200 $347,34011926 ‐ Yellow Brick Building$3,600 $3,300$0$0$0$0$0$0$0$0$0Facilities Maintenance$271,860 $287,479 $347,310$50 ($830) ($780)$346,530 $355,410 $363,710 $372,270 $381,06013110 ‐ In‐Town Service$1,843,783 $1,367,407 $1,998,450 $190 ($1,164,140) ($1,163,950)‐58% $834,500 $2,719,000 $2,382,100 $2,477,800 $2,576,7003441
City of Aspen Budget141 ‐ Transportation FundCARES funding offsetting loss on 1% transit tax in 20202018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact From COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection Projection13120 ‐ Highlands Service$179,881 $198,267 $217,260$0$0$0$217,260 $221,600 $226,030 $230,550 $235,16013130 ‐ Bus Stop Maintenance$42,133 $44,390 $34,470$30 ($330) ($300)$34,170 $35,640 $36,850 $38,110 $39,430Mass Transit$2,065,797 $1,610,064 $2,250,180 $220 ($1,164,470) ($1,164,250) $1,085,930 $2,976,240 $2,644,980 $2,746,460 $2,851,29013210 ‐ Car‐To‐Go Program$122,128 $128,040 $136,110 $520 ($1,320) ($800)$135,310 $140,570 $145,220 $150,070 $155,12013220 ‐ Bike Share Program$168,937 $164,681 $167,370$60 ($12,240) ($12,180)$155,190 $171,110 $174,950 $178,870 $182,89013230 ‐ Late Night Taxi Program$25,129 $24,917 $27,730$20 ($12,490) ($12,470)$15,260 $28,620 $29,550 $30,500 $31,50013240 ‐ Mobility Services$523,146 $581,317 $603,110$40 ($100,580) ($100,540)$502,570 $616,030 $629,270 $642,820 $656,690Alternative Transit$839,340 $898,955 $934,320 $640 ($126,630) ($125,990)$808,330 $956,330 $978,990 $1,002,260 $1,026,20013310 ‐ Transportation Demand Management$192,805 $186,003 $252,070 $710 ($1,580) ($870)$251,200 $259,200 $266,610 $274,280 $282,240Transportation Demand $192,805 $186,003 $252,070 $710 ($1,580) ($870)$251,200 $259,200 $266,610 $274,280 $282,240Operating$3,922,339 $3,232,919 $3,966,680 $175,040 ($1,376,160) ($1,201,120) $2,765,560 $4,736,270 $4,449,950 $4,597,750 $4,750,40081200 ‐ Capital Projects$492,768 $2,329,122 $99,500 $180,000$0 $180,000$279,500 $522,000 $176,000 $131,500 $614,500Capital$492,768 $2,329,122 $99,500 $180,000$0 $180,000$279,500 $522,000 $176,000 $131,500 $614,500General Fund Overhead$368,496 $374,300 $388,700$0$0$0$388,700 $402,300 $416,400 $431,000 $446,100IT Overhead$27,204 $30,000 $35,200$0$0$0$35,200 $34,130 $32,030 $33,650 $33,880Overhead Allocations$395,700 $404,300 $423,900$0$0$0$423,900 $436,430 $448,430 $464,650 $479,980To the AMP Fund$145,756 $92,600 $2,209,010 ($111,000)$0 ($111,000) $2,098,010$0$0$0$0To the General Fund$54,090 $78,630$66,230 $7,410$0 $7,410$73,640 $66,230 $66,230 $66,230 $66,230To the Employee Housing Fund$22,200 $44,200 $44,200$0 ($33,150) ($33,150)$11,050 $47,200 $48,600 $50,100 $51,600Other Transfers$222,046 $215,430 $2,319,440 ($103,590) ($33,150) ($136,740) $2,182,700 $113,430 $114,830 $116,330 $117,830Transfers Out$617,746 $619,730 $2,743,340 ($103,590) ($33,150) ($136,740) $2,606,600 $549,860 $563,260 $580,980 $597,810Total Uses$5,032,853 $6,181,771 $6,809,520 $251,450 ($1,409,310) ($1,157,860) $5,651,660 $5,808,130 $5,189,210 $5,310,230 $5,962,710Targeted Reserve (12.5% of Uses)$629,107 $772,721 $851,190 $31,431 ($176,164) ($144,733)$706,458 $726,016 $648,651 $663,779 $745,339Ending Fund Balance$6,185,873 $7,714,320 $2,823,151 $3,234,289 $84,210 $3,318,499 $6,141,650 $4,681,390 $4,122,510 $4,023,580 $3,330,170Ending Balance as % of Targeted Reserve983% 998% 332%(2,293%)869% 645% 636% 606% 447%Over/(Short) of Targeted Reserve$5,556,766 $6,941,599 $1,971,961$3,463,232 $5,435,193 $3,955,374 $3,473,859 $3,359,802 $2,584,832Change in Fund Balance$1,948,637 $1,528,454 ($1,405,430) ($251,450) $84,210 ($167,240) ($1,572,670) ($1,460,260) ($558,880) ($98,930) ($693,410)3542
Cty of Aspen Budget150 ‐ Housing Development Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget ProjectionProjection Projection ProjectionOpening Balance$37,904,680 $47,551,435 $23,465,320 $25,059,959$0 $25,059,959$48,525,279 $34,168,902 $19,389,412 $35,112,442 $51,709,292Real Estate Transfer Tax$8,896,761 $8,439,265 $7,607,000$0 ($3,803,500) ($3,803,500)‐50% $3,803,500 $7,987,350 $8,386,720 $8,806,060 $9,246,360City Sales Tax$1,528,784 $1,661,352 $1,637,100$0 ($555,500) ($555,500)‐34% $1,081,600 $1,265,100 $1,479,700 $1,841,510 $1,915,170Investment Income$798,569 $950,760 $469,310$0$0$0$469,310 $683,380 $387,790 $702,250 $1,034,190Other Revenues$371,364 $1,159,849 $260,100$0$0$0$260,100 $265,300 $270,610 $276,020 $281,540Non‐Classified$11,595,478 $12,211,226 $9,973,510$0 ($4,359,000) ($4,359,000) $5,614,510 $10,201,130 $10,524,820 $11,625,840 $12,477,26011932 ‐ Housing Development Properties$729,161 $789,991 $593,650$0$0$0$593,650 $605,520 $617,630 $629,980 $642,580Property / Facilities Maintenance$729,161 $789,991 $593,650$0$0$0$593,650 $605,520 $617,630 $629,980 $642,58081200 ‐ Capital Projects$5,844,624 $280,238 $9,420,000$0$0$0 $9,420,000$0 $7,920,000 $9,460,000 $2,500,000Capital Related$5,844,624 $280,238 $9,420,000$0$0$0 $9,420,000$0 $7,920,000 $9,460,000 $2,500,000Revenues In$18,169,263 $13,281,456 $19,987,160$0 ($4,359,000) ($4,359,000) $15,628,160 $10,806,650 $19,062,450 $21,715,820 $15,619,840From the Truscott I Housing Fund$0$0$0$0$0$0$0$0$0 $225,000 $225,000From the Marolt Housing Fund$100,000$0 $1,700,000$0$0$0 $1,700,000$800,000$800,000 $800,000 $800,000Transfers In$100,000$0 $1,700,000$0$0$0 $1,700,000 $800,000 $800,000 $1,025,000 $1,025,000New Sales Tax Bonds (GO)$0$0$0$0$0$0$0 $17,500,000$0$0$0Debt Proceeds$0$0$0$0$0$0$0 $17,500,000$0$0$0Total Revenues$18,269,263 $13,281,456 $21,687,160$0 ($4,359,000) ($4,359,000) $17,328,160 $29,106,650 $19,862,450 $22,740,820 $16,644,840$0$0$0$000000 ‐ Non‐Classified$1,350$0$0$0 $1,500,000 $1,500,000 $1,500,000$0$0$0$0Non‐Classified$1,350$0$0$0 $1,500,000 $1,500,000 $1,500,000$0$0$0$010010 ‐ General Administrative$376,816 $458,866 $483,830 $530 ($660) ($130)$483,700 $494,620 $505,690 $517,030 $528,66010010 ‐ Add' Housing Admin Subsidy$0$0$0$0$0$0$0 $200,000 $204,000 $208,100 $212,30010040 ‐ Sales Tax Refunds$14,614 $17,496 $16,340$0$0$0$16,340 $16,670 $17,000 $17,340 $17,69010050 ‐ Minor Capital Outlay$0$0 $380 $740$0 $740$1,120 $390 $400 $410 $420Administrative$391,430 $476,362 $500,550 $1,270 ($660) $610$501,160 $711,680 $727,090 $742,880 $759,07011932 ‐ Housing Development Properties$66,617 $56,560 $68,530$0$0$0$68,530 $69,910 $71,310 $72,740 $74,21011999 ‐ Other Facility / Maintenance$12,413 $12,090 $13,800$0$0$0$13,800 $14,080 $14,360 $14,650 $14,940Property / Facilities Maintenance$79,030 $68,650 $82,330$0$0$0$82,330$83,990$85,670 $87,390 $89,150Operating$471,810 $545,012 $582,880 $1,270 $1,499,340 $1,500,610 $2,083,490 $795,670 $812,760 $830,270 $848,2203643
Cty of Aspen Budget150 ‐ Housing Development Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget ProjectionProjection Projection Projection81100 ‐ Capital Labor$79,266 $86,122 $85,260 $800 ($990) ($190) $85,070 $88,660 $92,210 $95,910 $99,80081200 ‐ Capital Projects$7,383,713 $9,935,928 $13,650,000 $13,695,277 $0 $13,695,277 $27,345,277 $40,300,000 $500,000 $2,800,000 $0Capital$7,462,979 $10,022,050 $13,735,260 $13,696,077 ($990) $13,695,087 $27,430,347 $40,388,660 $592,210 $2,895,910 $99,80091017 ‐ Truscott II (CHFA Loan)$0$0$0$0$0$0$0$0$0$0$0Debt$0$0$0$0$0$0$0$0$0$0$0General Fund Overhead$677,796 $671,300 $893,400$0$0$0$893,400 $924,700 $957,100 $990,600 $1,025,300IT Overhead$5,304 $6,100 $1,200$0$0$0$1,200 $1,160 $1,090 $1,150 $1,160Overhead Allocations$683,100 $677,400 $894,600$0$0$0$894,600 $925,860 $958,190 $991,750 $1,026,460To the General Fund$3,120 $5,100 $5,100$0$0$0$5,100 $5,100 $5,100 $5,100 $5,100To the Debt Service Fund ‐ City Offices$0 $83,050 $171,000$0$0$0$171,000 $170,850 $171,160 $170,940$0To the Debt Service Fund ‐ GO Bonds$0$0$0$0$0$0$0 $1,250,000 $1,250,000 $1,250,000 $1,250,000To the Truscott I Housing Fund$0 $975,000 $1,100,000$0$0$0 $1,100,000 $350,000 $350,000$0$0Other Transfers$3,120 $1,063,150 $1,276,100$0$0$0 $1,276,100 $1,775,950 $1,776,260 $1,426,040 $1,255,100Transfers Out$686,220 $1,740,550 $2,170,700$0$0$0 $2,170,700 $2,701,810 $2,734,450 $2,417,790 $2,281,560Total Uses$8,621,009 $12,307,612 $16,488,840 $13,697,347 $1,498,350 $15,195,697 $31,684,537 $43,886,140 $4,139,420 $6,143,970 $3,229,580Ending Fund Balance$47,552,934 $48,525,279 $28,663,640 $11,362,612 ($5,857,350)$5,505,262 $34,168,902 $19,389,412 $35,112,442 $51,709,292 $65,124,5523744
City of Aspen Budget152 ‐ Kids First Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact From COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$5,455,622 $5,606,016 $5,561,041 $718,734$0 $718,734 $6,279,775 $4,658,250 $3,897,540 $3,589,700 $3,683,650City Sales Tax$1,867,508 $2,029,448 $2,000,900$0 ($679,000) ($679,000)‐34% $1,321,900 $1,546,000 $1,808,000 $2,250,750 $2,340,780Investment Income$92,841 $203,618 $111,220$0$0$0$111,220 $93,170 $77,950 $71,790 $73,670Other Non‐Classified Income$7,683 $12,334 $1,000$0$0$0$1,000 $1,000 $1,000 $1,000 $1,000Non‐Classified$1,968,032 $2,245,400 $2,113,120$0 ($679,000) ($679,000) $1,434,120 $1,640,170 $1,886,950 $2,323,540 $2,415,45011926 ‐ Yellow Brick Building$167,270 $175,692 $183,705$0$0$0$183,705 $187,390 $191,140 $194,960 $198,860Property / Facilities Maintenance$167,270 $175,692 $183,705$0$0$0$183,705 $187,390 $191,140 $194,960 $198,86041110 ‐ Financial Aid$0$0$0$0$0$0$0$0$0$0$041210 ‐ Quality Improvement Support$33,060 $25,686 $17,500$0$0$0$17,500 $17,500 $17,500 $17,500 $17,50041230 ‐ Reimbursable Support$25,664 $35,098 $20,000$0$0$0$20,000 $20,400 $20,810 $21,230 $21,650Childcare Grants and Reimbursable Support$58,724 $60,784 $37,500$0$0$0$37,500 $37,900 $38,310 $38,730 $39,150Revenues In$2,194,026 $2,481,876 $2,334,325$0 ($679,000) ($679,000) $1,655,325 $1,865,460 $2,116,400 $2,557,230 $2,653,4600Total Revenues$2,194,026 $2,481,876 $2,334,325$0 ($679,000) ($679,000) $1,655,325 $1,865,460 $2,116,400 $2,557,230 $2,653,460$0$000000 ‐ Non‐Classified$6,757 ($3)$0 $127,460 ($63,730) $63,730$63,730$0$0$0$0Non‐Classified$6,757‐$3$0 $127,460‐$63,730 $63,730$63,730$0$0$0$010010 ‐ General Administrative$215,328 $224,167 $259,780 $720 ($2,640) ($1,920)$257,860 $269,290 $279,200 $289,560 $300,39010020 ‐ Long Range Planning$0 $11,595 $35,000$0 ($10,000) ($10,000)$25,000$0$0$0$010030 ‐ Public Outreach$11,451 $7,708 $27,070$0$0$0$27,070 $27,610 $28,150 $28,720 $29,29010040 ‐ Sales Tax Refunds$17,905 $21,436 $21,000$0$0$0$21,000 $21,420 $21,850 $22,290 $22,74010050 ‐ Minor Capital Outlay$0 $1,120 $3,740 $16,540$0 $16,540$20,280 $3,810 $3,880 $3,950 $4,030Administrative$244,684 $266,025 $346,590 $17,260 ($12,640) $4,620$351,210 $322,130 $333,080 $344,520 $356,45011926 ‐ Yellow Brick Building$206,905 $203,796 $214,250 $380 ($2,310) ($1,930)$212,320 $221,410 $228,840 $236,610 $244,720Property / Facilities Maintenance$206,905 $203,796 $214,250 $380 ($2,310) ($1,930)$212,320 $221,410 $228,840 $236,610 $244,72041110 ‐ Financial Aid$445,982 $318,321 $450,140 $230 $998,680 $998,910 $1,449,050 $460,810 $471,790 $483,090 $494,72041120 ‐ Operational Subsidies$271,404 $257,298 $265,460$0$0$0$265,460 $270,770 $276,190 $281,710 $287,340Enrollment Support$717,386 $575,619 $715,600 $230 $998,680 $998,910 $1,714,510 $731,580 $747,980 $764,800 $782,06041210 ‐ Quality Improvement Support$265,355 $257,649 $342,290 $550 ($13,300) ($12,750)$329,540 $351,590 $361,320 $371,500 $382,16041220 ‐ Technical and Operational Support$74,580 $54,785 $120,000$0$0$0$120,000 $122,400 $124,850 $127,350 $129,90041230 ‐ Reimbursable Support$136,300 $137,258 $246,050 $290 ($79,660) ($79,370)$166,680 $256,430 $267,340 $278,810 $290,910Childcare Program Support$476,235 $449,693 $708,340 $840 ($92,960) ($92,120)$616,220 $730,420 $753,510 $777,660 $802,9703845
City of Aspen Budget152 ‐ Kids First Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact From COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOperating$1,651,967 $1,495,129 $1,984,780 $146,170 $827,040 $973,210 $2,957,990 $2,005,540 $2,063,410 $2,123,590 $2,186,200081200 ‐ Capital Projects$119,851 $12,178 $412,450 $45,000 ($406,700) ($361,700) $50,750 $298,800 $32,700 $0 $0Capital$119,851 $12,178 $412,450 $45,000 ($406,700) ($361,700) $50,750 $298,800 $32,700 $0 $00General Fund Overhead$194,604 $182,900 $191,800 $0 $0 $0 $191,800 $198,500 $205,400 $212,600 $220,000IT Overhead$32,604 $41,600 $47,000 $0 $0 $0 $47,000 $45,570 $42,770 $44,930 $45,240Overhead Allocations$227,208 $224,500 $238,800 $0 $0 $0 $238,800 $244,070 $248,170 $257,530 $265,240To the General Fund$10,910 $9,210 $6,060 6,450 0 $6,450 $12,510 $6,060 $6,060 $6,060 $6,060To the Employee Housing Fund$33,696 $67,100 $67,200 $0 ($50,400) ($50,400) $16,800 $71,700 $73,900 $76,100 $78,400Other Transfers$44,606 $76,310 $73,260 $6,450 ($50,400) ($43,950) $29,310 $77,760 $79,960 $82,160 $84,460Transfers Out$271,814 $300,810 $312,060 $6,450‐$50,400 ($43,950) $268,110 $321,830 $328,130 $339,690 $349,7000Total Uses$2,043,632 $1,808,117 $2,709,290 $197,620 $369,940 $567,560 $3,276,850 $2,626,170 $2,424,240 $2,463,280 $2,535,900Targeted Reserve (12.5% of Uses)$255,454 $226,015 $338,661 $24,703 $46,243 $70,945 $409,606 $328,271 $303,030 $307,910 $316,988Ending Fund Balance$5,606,016 $6,279,775 $5,186,076 $521,114 ($1,048,940) ($527,826) $4,658,250 $3,897,540 $3,589,700 $3,683,650 $3,801,210Ending Balance as % of Targeted Reserve2,195% 2,778% 1,531% (744%) 1,137% 1,187% 1,185% 1,196% 1,199%Over/(Short) of Targeted Reserve$5,350,562 $6,053,760 $4,847,415 ($598,771) $4,248,644 $3,569,269 $3,286,670 $3,375,740 $3,484,2230Change in Fund Balance$150,394$673,759($374,965)($197,620) ($1,048,940) ($1,246,560) ($1,621,525) ($760,710) ($307,840) $93,950 $117,5603946
City of Aspen Budget160 ‐ Stormwater Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$2,327,777 $1,898,024 $874,532 $798,481$0 $798,481 $1,673,013 $1,669,966 $1,572,626 $1,835,536 $2,066,526Property Tax$1,059,797 $1,056,054 $1,194,000$0$0$0 $1,194,000 $1,194,000$1,241,800 $1,241,800 $1,291,500Building Permit Review Fees$215,809 $155,085 $135,000$0$0$0$135,000 $137,700 $140,450 $143,260 $146,130Construction Mitigation Fees$82,061 $178,805 $90,000$0$0$0$90,000 $91,800 $93,640 $95,510 $97,420In Lieu Of Fees$0 $79$0$0$0$0$0$0$0$0$0Investment Income$45,526 $35,231 $17,490$0$0$0$17,490 $33,400 $31,450 $36,710 $41,330Other Revenues$438 $1,251$0$0$0$0$0$0$0$0$0Revenues In$1,403,631 $1,426,505 $1,436,490$0$0 $0 $1,436,490 $1,456,900 $1,507,340 $1,517,280 $1,576,380From the AMP Fund$60,000 $95,880$0$0$0$0$0$0$0$0$0Transfers In$60,000 $95,880$0$0$0 $0$0$0$0$0$0Total Revenues$1,463,631 $1,522,385 $1,436,490$0$0 $0 $1,436,490 $1,456,900 $1,507,340 $1,517,280 $1,576,38000000 ‐ Non‐Classified$28,864 $21,155 $23,880 $122,790 ($61,400) $61,390$85,270 $24,360 $24,850 $25,350 $25,860Non‐Classified$28,864$21,155 $23,880 $122,790 ($61,400) $61,390$85,270 $24,360$24,850 $25,350 $25,86010010 ‐ General Administrative$39,799 $46,360 $68,560 $510 ($7,660) ($7,150)$61,410 $70,640 $72,810 $75,040 $77,34010050 ‐ Minor Capital Outlay$0$0 $750 $3,320$0 $3,320$4,070 $770 $790 $810 $830Administrative$39,799 $46,360 $69,310 $3,830 ($7,660) ($3,830)$65,480 $71,410 $73,600 $75,850 $78,17011904 ‐ Mill Street Annex$53,228 $59,250 $66,530$0 ($4,700) ($4,700)$61,830 $67,860 $69,220 $70,600 $72,010Property / Facilities Maintenance$53,228 $59,250 $66,530$0 ($4,700) ($4,700)$61,830 $67,860 $69,220 $70,600 $72,01012110 ‐ Development Review$87,363 $92,411 $93,910 $880 ($5,960) ($5,080)$88,830 $97,560 $101,370 $105,350 $109,51012210 ‐ Inspection And Enforcement$29,974 $29,513 $30,510 $280 ($1,610) ($1,330)$29,180 $31,710 $32,960 $34,280 $35,65012310 ‐ Long Range Planning / Policy$41,297 $38,566 $44,770 $460 ($7,710) ($7,250)$37,520 $46,370 $48,040 $49,770 $51,570Development Services$158,634 $160,490 $169,190 $1,620 ($15,280)‐$13,660$155,530 $175,640 $182,370 $189,400 $196,73035010 ‐ Drainage Infrastructure Maintena$92,453 $48,167 $71,300 $320 ($13,320) ($13,000)$58,300 $73,310 $75,380 $77,530 $79,77035020 ‐ Natural Treatment Area Maintena$66,667 $106,712 $183,930$0 ($13,300) ($13,300)$170,630 $191,250 $198,950 $207,050 $215,57035030 ‐ Streets And Vault Area Maintenan$135,866 $125,740 $162,170 $3,520 ($12,820) ($9,300) $152,870 $168,280 $174,670 $181,360 $188,370Storm Drainage$294,986 $280,619 $417,400 $3,840 ($39,440)‐$35,600 $381,800 $432,840 $449,000 $465,940 $483,710Operating$575,511 $567,874 $746,310 $132,080 ($128,480) $3,600$749,910 $772,110 $799,040 $827,140 $856,4804047
City of Aspen Budget160 ‐ Stormwater Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection Projection81100 ‐ Capital Labor$102,010 $62,038 $98,530 $930 ($7,320) ($6,390)$92,140 $102,380 $106,410 $110,620 $115,02081200 ‐ Capital Projects$884,582 $719,958 $100,000 $191,667$0 $191,667$291,667 $350,000$0$0$0Capital$986,592 $781,996 $198,530 $192,597 ($7,320) $185,277$383,807 $452,380 $106,410 $110,620 $115,020General Fund Overhead$217,500 $203,200 $208,900$0$0 $0$208,900 $216,200 $223,800 $231,600 $239,700IT Overhead$9,396 $7,300 $2,800$0$0 $0$2,800 $2,710 $2,540 $2,670 $2,690Overhead Allocations$226,896 $210,500 $211,700$0$0 $0$211,700 $218,910 $226,340 $234,270 $242,390To the AMP Fund$69,750 $76,616$0$0$0 $0$0$0$0$0$0To the General Fund$8,830 $19,420$0 $25,110$0 $25,110$25,110$0$0$0$0To the Parks and Open Space Fund$0 $12,500 $100,000$0 ($100,000)($100,000)$0$0$0$0 $300,000To the Debt Service Fund$0 $27,290 $56,190$0$0 $0$56,190 $56,140 $56,240 $56,160 $56,220To the Employee Housing Fund$25,800 $51,200 $51,300$0 ($38,480) ($38,480)$12,820 $54,700 $56,400 $58,100 $59,800Other Transfers$104,380 $187,026 $207,490 $25,110 ($138,480) ($113,370)$94,120 $110,840 $112,640 $114,260 $416,020Transfers Out$331,276$397,526 $419,190 $25,110 ($138,480) ($113,370)$305,820 $329,750$338,980 $348,530 $658,410Total Uses$1,893,379 $1,747,396 $1,364,030 $349,787 ($274,280) $75,507 $1,439,537 $1,554,240 $1,244,430 $1,286,290 $1,629,910Targeted Reserve (12.5% of Uses)$236,672 $218,425 $170,504$9,438$179,942 $194,280 $155,554 $160,786 $203,739Ending Fund Balance$1,898,029 $1,673,013 $946,992 $448,694 $274,280 $722,974 $1,669,966 $1,572,626 $1,835,536 $2,066,526 $2,012,996Ending Balance as % of Targeted Reserve802% 766% 555%7,660%928% 809% 1,180% 1,285% 988%Over/(Short) of Targeted Reserve$1,661,357 $1,454,589 $776,488$713,536 $1,490,024 $1,378,346 $1,679,982 $1,905,740 $1,809,257Change in Fund Balance($429,748) ($225,011) $72,460 ($349,787) $274,280 ($75,507)($3,047) ($97,340) $262,910 $230,990 ($53,530)4148
City of Aspen Budget421 ‐ Water Utility Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget ProjectionProjection Projection ProjectionOpening Balance$6,234,375 $8,090,833 $5,538,471 $2,650,711$0 $2,650,711 $8,189,182 $4,412,397 $4,219,027 $4,719,127 $6,225,037Metered Demand$1,693,620 $1,725,725 $1,822,770$0 ($20,800) ($20,800)‐1% $1,801,970 $1,888,390 $1,960,150 $2,038,560 $2,122,140Unmetered Demand$489,775 $427,969 $554,510$0 ($144,500) ($144,500)‐26% $410,010 $599,430 $647,980 $700,470 $757,210Fire Charge$613,209 $757,931 $854,520 $25,500$0 $25,500$880,020 $978,430 $1,112,470 $1,257,090 $1,412,970Demand Service$2,796,604 $2,911,625 $3,231,800 $25,500 ($165,300) ($139,800) $3,092,000 $3,466,250 $3,720,600 $3,996,120 $4,292,320Variable Service$3,635,065 $3,058,114 $3,532,150$0 ($532,150) ($532,150)‐15% $3,000,000 $3,782,930 $4,055,300 $4,347,280 $4,664,630Pump Charges$488,371 $482,457 $585,190$0 ($85,200) ($85,200)‐15% $499,990 $644,290 $708,070 $776,750 $815,590Variable Service$4,123,436 $3,540,571 $4,117,340$0 ($617,350) ($617,350) $3,499,990 $4,427,220 $4,763,370 $5,124,030 $5,480,220Raw Water$275,321 $331,363 $345,850 $54,000$0 $54,000$399,850 $418,130 $495,900 $580,200 $671,290Reclaimed Water$0$0 $106,090$0$0$0$106,090 $109,270 $112,550 $115,930 $119,410Wholesale Water$523,067 $443,538 $490,610$0 ($40,600) ($40,600)‐8% $450,010 $515,140 $540,900 $567,950 $596,350Other Water Service$798,388 $774,901 $942,550 $54,000 ($40,600) $13,400$955,950 $1,042,540 $1,149,350 $1,264,080 $1,387,050Building Permit Review Fees$817,402 $624,599 $550,000$0 ($350,000) ($350,000)‐64% $200,000 $561,000 $572,220 $583,660 $595,330Development Review Fees$817,402 $624,599 $550,000$0 ($350,000) ($350,000)$200,000 $561,000 $572,220 $583,660 $595,330Tap Fees$1,114,020 $1,523,182 $892,550$0 ($95,550) ($95,550)‐11% $797,000$910,400$928,610 $947,180 $966,120Investment Income$114,750 $147,429 $110,770$0$0$0$110,770 $88,250 $84,380 $94,380 $124,500Other Revenues$196,382 $134,949 $317,110 $500,000 ($10,000) $490,000‐3% $807,110 $83,750 $85,430 $87,140 $88,880Other Revenues$311,132 $282,378 $427,880 $500,000 ($10,000) $490,000$917,880 $172,000 $169,810 $181,520 $213,380Revenues In$9,960,982 $9,657,256 $10,162,120 $579,500 ($1,278,800) ($699,300) $9,462,820 $10,579,410 $11,303,960 $12,096,590 $12,934,420From the Wheeler Opera House Fund$2,515,000$0$0$0$0$0$0$0$0$0$0From the Electric Utility Fund$175,000 $175,720$0$0$0$0$0$0$0$0$0Transfers In$2,690,000 $175,720$0$0$0$0$0$0$0$0$0Total Revenues$12,650,982 $9,832,976 $10,162,120 $579,500 ($1,278,800) ($699,300)‐13% $9,462,820 $10,579,410 $11,303,960 $12,096,590 $12,934,420$0$000000 ‐ Non‐Classified$91,345 $23$0 $252,830 ($126,420) $126,410$126,410$0$0$0$0Non‐Classified$91,345 $23$0 $252,830‐$126,420 $126,410$126,410$0$0$0$010010 ‐ General Administrative$515,626 $545,894 $606,630 $2,000 $32,030 $34,030$640,660 $627,220 $648,650 $671,030 $694,35010050 ‐ Minor Capital Outlay$65,258 $55,149 $47,040 $47,260 ($30,000) $17,260$64,300 $47,980 $48,940 $49,910 $50,920Administrative$580,884 $601,044 $653,670 $49,260 $2,030 $51,290$704,960 $675,200 $697,590 $720,940 $745,27011927 ‐ Water Department Campus$175,405 $172,405 $184,010 $4,650 $9,400 $14,050$198,060 $189,360 $194,890 $200,640 $206,610Property / Facilities Maintenance$175,405 $172,405 $184,010 $4,650 $9,400 $14,050$198,060 $189,360 $194,890 $200,640 $206,61012110 ‐ Development Review$330,782 $453,671 $513,080$3,850($36,660) ($32,810)$480,270 $533,130 $554,140 $576,160 $599,230Development Services$330,782 $453,671 $513,080 $3,850 ($36,660) ($32,810)$480,270 $533,130 $554,140 $576,160 $599,23031110 ‐ Utility Billing Services$329,498 $358,312 $429,420 $2,820 ($62,420) ($59,600)$369,820 $444,770 $460,810 $477,580 $495,150Support Services$329,498 $358,312 $429,420 $2,820 ($62,420) ($59,600)$369,820 $444,770 $460,810 $477,580 $495,1504249
City of Aspen Budget421 ‐ Water Utility Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget ProjectionProjection Projection Projection31520 ‐ Efficiency Program$151,901 $228,979 $113,110 $50 ($5,520) ($5,470) $107,640 $116,090 $119,160 $122,330 $125,61031530 ‐ Climate Action and Resiliency$268,234 $21,142 $0 $0 $0 $0 $0 $0 $0 $0 $0Conservation, Efficiency, Renewables$420,135 $250,120 $113,110 $50 ($5,520) ($5,470) $107,640 $116,090 $119,160 $122,330 $125,61032110 ‐ Treated Water$556,478 $695,191 $735,900 $6,340 ($112,040) ($105,700) $630,200 $758,950 $782,910 $807,820 $833,760Treated Water$556,478 $695,191 $735,900 $6,340 ($112,040) ($105,700) $630,200 $758,950 $782,910 $807,820 $833,76032210 ‐ Raw Water$260,328 $190,833 $284,720 $1,210 ($63,690) ($62,480) $222,240 $293,570 $302,790 $312,380 $322,38032220 ‐ Reclaimed Water$37,932 $34,853 $31,610 $400 ($7,230) ($6,830) $24,780 $32,770 $33,980 $35,240 $36,570Untreated Water$298,260 $225,686 $316,330 $1,610 ($70,920) ($69,310) $247,020 $326,340 $336,770 $347,620 $358,95032310 ‐ Water Line Maintenance$761,553 $746,496 $682,880 $4,050 ($29,970) ($25,920) $656,960 $705,270 $728,590 $752,940 $778,32032320 ‐ Storage Tank and Pump System Maint.$251,956 $285,356 $367,050 $1,530 ($33,220) ($31,690) $335,360 $377,180 $387,640 $398,490 $409,72032340 ‐ Telemetry$190,302 $163,345 $168,410 $960 $3,120 $4,080 $172,490 $174,090 $180,010 $186,190 $192,640Distribution Management$1,203,811 $1,195,197 $1,218,340 $6,540 ($60,070) ($53,530) $1,164,810 $1,256,540 $1,296,240 $1,337,620 $1,380,68032410 ‐ Water Rights$229,480 $217,635 $285,830 $750 ($8,600) ($7,850) $277,980 $293,320 $301,020 $308,980 $317,200Water Rights$229,480 $217,635 $285,830 $750 ($8,600) ($7,850) $277,980 $293,320 $301,020 $308,980 $317,200Operating$4,216,078 $4,169,284 $4,449,690 $328,700 ($471,220) ($142,520) $4,307,170 $4,593,700 $4,743,530 $4,899,690 $5,062,46081100 ‐ Capital Labor$183,782 $170,899 $180,990 $2,600 ($140) $2,460 $183,450 $188,270 $195,880 $203,860 $212,23081200 ‐ Capital Projects$3,793,686$1,575,586 $4,538,500 $1,362,965$0 $1,362,965 $5,901,465 $2,991,000$3,042,300$2,640,000 $3,961,000Capital$3,977,468 $1,746,485 $4,719,490 $1,365,565 ($140) $1,365,425 $6,084,915 $3,179,270 $3,238,180 $2,843,860 $4,173,230General Fund Overhead$716,304 $796,600 $821,600$0$0$0$821,600 $850,400 $880,200 $911,000 $942,900IT Overhead$136,104 $153,000 $189,100$0$0$0$189,100 $183,340 $172,080 $180,760 $182,010Overhead Allocations$852,408 $949,600 $1,010,700$0$0$0 $1,010,700 $1,033,740 $1,052,280 $1,091,760 $1,124,910To the AMP Fund$111,250 $229,838$0$0$0$0$0$0$0$0$0To the General Fund$991,290 $1,189,050 $1,133,000 $209,000$0 $209,000 $1,342,000 $1,111,000 $1,089,000 $1,067,000 $1,045,000To the Parks and Open Space Fund$150,000 $150,000 $150,000$0$0$0$150,000 $150,000 $150,000 $150,000$0To the Wheeler Opera House Fund$284,770 $284,770 $284,770$0$0$0$284,770 $284,770 $284,770 $284,770 $284,770To the Electric Utility Fund$3,200 $803,300 $4,900$0$0$0$4,900 $185,000 $3,500 $3,600 $5,500To the Employee Housing Fund$113,400 $212,300 $220,600$0 ($165,450) ($165,450)$55,150 $235,300 $242,600 $250,000 $257,300Other Transfers$1,653,910 $2,869,258 $1,793,270 $209,000 ($165,450) $43,550$1,836,820 $1,966,070 $1,769,870 $1,755,370 $1,592,570Transfers Out$2,506,318 $3,818,858 $2,803,970 $209,000 ($165,450) $43,550$2,847,520 $2,999,810 $2,822,150 $2,847,130 $2,717,480Total Uses$10,699,864 $9,734,627 $11,973,150 $1,903,265 ($636,810) $1,266,455‐5% $13,239,605 $10,772,780 $10,803,860 $10,590,680 $11,953,170Targeted Reserve (25.0% of Uses)$2,674,966$2,433,657 $2,993,288$316,614 $3,309,901 $2,693,195 $2,700,965 $2,647,670$2,988,293Ending Fund Balance$8,185,493 $8,189,182 $3,727,441 $1,326,946 ($641,990) $684,956 $4,412,397 $4,219,027 $4,719,127 $6,225,037 $7,206,287Ending Balance as % of Targeted Reserve306% 336% 125%216%133% 157% 175% 235% 241%Over/(Short) of Targeted Reserve$5,510,527 $5,755,525 $734,154$368,342 $1,102,496 $1,525,832 $2,018,162 $3,577,367 $4,217,995Change in Fund Balance$1,951,118 $98,349 ($1,811,030) ($1,323,765) ($641,990) ($1,965,755) ($3,776,785) ($193,370) $500,100 $1,505,910 $981,2504350
City of Aspen Budget431 ‐ Electric Utility Fund2018 2019 2020 20202020 20202020 2021 2022 2023 2024Actuals Draft ActualsOrginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$4,967,332 $3,283,651 $2,661,654 $2,499,487$0 $2,499,487 $5,161,141 $2,367,801 $2,702,541 $2,786,896 $3,233,136Residential Consumption$2,851,549 $3,511,864 $3,193,610$0 ($479,000) ($479,000)‐15% $2,714,610 $3,254,290 $3,290,090 $3,329,570 $3,356,210Residential Availability$465,145 $657,045 $818,970$0$0$0$818,970 $1,069,570 $1,224,660 $1,385,090 $1,504,210Residential$3,316,694 $4,168,908 $4,012,580$0‐$479,000 ($479,000) $3,533,580 $4,323,860 $4,514,750$4,714,660 $4,860,420Sm. Commercial Consumption$3,048,036 $3,161,411 $3,308,730$0 ($496,000) ($496,000)‐15% $2,812,730 $3,368,290 $3,405,340 $3,442,800 $3,470,340Sm. Commercial Availability$263,996 $382,634 $473,000$0$0$0$473,000 $614,430 $701,680 $792,200 $858,740Sm. Commercial$3,312,032 $3,544,045 $3,781,730$0‐$496,000 ($496,000) $3,285,730 $3,982,720 $4,107,020$4,235,000 $4,329,080Lg. Commercial Consumption$1,098,155 $1,420,056 $1,406,470$0 ($211,000) ($211,000)‐15% $1,195,470 $1,357,240 $1,326,020 $1,294,200 $1,270,900Lr. Commercial Availability$46,262 $96,665 $122,520$0$0$0$122,520 $163,810 $189,360 $215,870 $235,510Lg. Commercial Demand$350,914 $561,281 $649,400$0 ($130,000) ($130,000)‐20% $519,400 $746,160 $805,850 $867,900 $913,900Lg. Commercial$1,495,331 $2,078,002 $2,178,390$0‐$341,000 ($341,000) $1,837,390 $2,267,210 $2,321,230$2,377,970 $2,420,310Sm. City Facility Consumption$74,108$0$0$0$0$0$0$0$0$0$0Sm. City Facility Availability$10,847$0$0$0$0$0$0$0$0$0$0Sm. City Facility$84,955$0$0$0$0$0$0$0$0$0$0Lg. City Facility Consumption$339,676$0$0$0$0$0$0$0$0$0$0Lr. City Facility Availability$14,593$0$0$0$0$0$0$0$0$0$0Lg. City Facility Demand$151,937$0$0$0$0$0$0$0$0$0$0Lg. City Facility$506,206$0$0$0$0$0$0$0$0$0$0Investment Income$86,667 $70,663 $53,230$0$0$0$53,230 $47,360 $54,050 $55,740 $64,660Electric Development Fee$142,863 $90,926 $102,000 $18,000 $0 $18,000$120,000 $104,040 $106,120 $108,240 $110,400All Other Revenues$117,203 $97,382 $36,720$0 ($16,600) ($16,600)$20,120 $37,450 $38,200 $38,960 $39,740Other Revenues$346,733 $258,971 $191,950 $18,000 ($16,600) $1,400$193,350 $188,850 $198,370 $202,940 $214,800Revenues In$9,061,951 $10,049,926 $10,164,650 $18,000 ($1,332,600) ($1,314,600) $8,850,050$10,762,640 $11,141,370 $11,530,570 $11,824,61091023 ‐ Refunding of 2008 GO Bonds$0$0$0$0$0$0$0$0$0$0$0Debt Proceeds$0$0$0$0$0$0$0$0$0$0$0From the AMP Fund$0$50,000$0$0$0$0$0$0$0$0$0From the Water Utility Fund$3,200 $803,300 $4,900$208,000$0 $208,000$212,900 $185,000 $3,500 $3,600 $5,500Transfers In$3,200 $853,300 $4,900 $208,000$0 $208,000$212,900 $185,000 $3,500 $3,600 $5,500Total Revenues$9,065,151 $10,903,227 $10,169,550 $226,000 ($1,332,600) ($1,106,600)‐13% $9,062,950 $10,947,640 $11,144,870 $11,534,170 $11,830,110$0$0$000000 ‐ Non‐Classified$15,725 ($1)$0 $356,870 ($178,440) $178,430$178,430$0$0$0$0Non‐Classified$15,725 ($1)$0 $356,870‐$178,440 $178,430$178,430$0$0$0$010010 ‐ General Administrative$326,309 $355,043 $425,590 $1,220 $7,800 $9,020$434,610 $440,250 $455,490 $471,400 $488,03010050 ‐ Minor Capital Outlay$43 $2,790 $1,120 $6,810$0 $6,810$7,930 $1,150 $1,180 $1,210 $1,240Administrative$326,352 $357,833 $426,710 $8,030$7,800 $15,830$442,540 $441,400 $456,670 $472,610 $489,27011928 ‐ Electric Department Campus$44,153 $46,694 $57,580$290 ($1,990) ($1,700)$55,880 $59,510 $61,520 $63,610 $65,800Property / Facilities Maintenance$44,153 $46,694 $57,580$290 ($1,990) ($1,700)$55,880 $59,510 $61,520 $63,610 $65,80031110 ‐ Utility Billing Services$259,931 $264,227 $383,120 $1,880 ($61,530) ($59,650)$323,470 $396,690 $410,880 $425,710 $441,230Support Services$259,931 $264,227 $383,120 $1,880($61,530) ($59,650)$323,470 $396,690 $410,880 $425,710 $441,23031520 ‐ Efficiency Program$53,015 $84,522 $17,930$430 ($170)$260$18,190 $18,630 $19,360 $20,110 $20,90031530 ‐ Climate Action and Resiliency$252,893 ($103)$0$0$0$0$0$0$0$0$0Conservation, Efficiency, Renewables$305,908 $84,420 $17,930$430 ($170) $260$18,190 $18,630 $19,360 $20,110 $20,9004451
City of Aspen Budget431 ‐ Electric Utility Fund2018 2019 2020 20202020 20202020 2021 2022 2023 2024Actuals Draft ActualsOrginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection Projection33110 ‐ Ruedi Hydroelectric$357,347 $251,781 $381,940 $580 ($47,950) ($47,370) $334,570 $390,390 $399,050 $407,920 $417,03033120 ‐ Maroon Creek Hydroelectric$116,738 $107,822 $138,290 $1,370 ($17,080) ($15,710)$122,580 $142,800 $147,500 $152,370 $157,490Locally Produced Power$474,085 $359,603 $520,230 $1,950($65,030) ($63,080)$457,150 $533,190 $546,550 $560,290 $574,52033210 ‐ Hydroelectric$407,817 $441,133 $555,010$0$0$0$555,010 $566,110 $577,430 $588,980 $600,76033220 ‐ Windpower$2,362,951 $2,253,672 $2,061,330$0$0$0 $2,061,330 $2,102,560 $2,144,610 $2,187,500 $2,231,25033230 ‐ Landfill Gas$71,010 $61,158 $74,290$0$0$0$74,290 $75,780 $77,300 $78,850 $80,43033240 ‐ Transmission and Wheeling Charges$829,062 $793,212 $931,330$0$0$0$931,330 $949,960 $968,960 $988,340 $1,008,11033250 ‐ Fixed Cost Recovery Charge$1,200,341 $1,204,486 $1,233,960$0$0$0 $1,233,960 $1,258,640 $1,283,810 $1,309,490 $1,335,68033260 ‐ Other Charges$130,296 $80,589 $85,050$550 ($10,480) ($9,930)$75,120 $88,420 $91,920 $95,590 $99,430Purchased Power$5,001,477 $4,834,249 $4,940,970$550 ($10,480) ($9,930) $4,931,040 $5,041,470 $5,144,030 $5,248,750 $5,355,66033310 ‐ Electric Line and Transformer Main.$419,123 $543,817 $618,520 $4,110 ($4,130) ($20)$618,500 $641,000 $664,470 $688,980 $714,56033320 ‐ Telemetry$64,953 $44,584 $71,550$550 ($16,370) ($15,820)$55,730 $73,840 $76,220 $78,710 $81,280Distribution Management$484,076 $588,401 $690,070 $4,660($20,500) ($15,840)$674,230 $714,840 $740,690 $767,690 $795,84033920 ‐ Public Lighting$124,161 $109,044 $188,610$640 ($67,230) ($66,590)$122,020 $195,640 $203,010 $210,710 $218,780Public Lighting$124,161 $109,044 $188,610$640 ($67,230) ($66,590)$122,020 $195,640 $203,010 $210,710 $218,780Operating$7,035,868 $6,644,470$7,225,220$375,300 ($397,570) ($22,270) $7,202,950 $7,401,370 $7,582,710 $7,769,480 $7,962,00081100 ‐ Capital Labor$175,192 $159,107 $185,770 $2,260 ($5,850) ($3,590)$182,180 $193,230 $201,040 $209,220 $217,77081200 ‐ Capital Projects$150,612 $601,436 $1,127,910 $1,842,580$0 $1,842,580 $2,970,490 $1,426,530 $1,646,260 $1,432,040 $1,717,950Capital$325,804 $760,543 $1,313,680 $1,844,840 ($5,850) $1,838,990 $3,152,670 $1,619,760 $1,847,300 $1,641,260 $1,935,720Fiscal Agent$900$0 $2,000$0$0$0$2,000 $2,000 $2,000 $2,000 $2,000Principal ‐ Bonds$2,135,000 $300,000 $300,000$0$0$0$300,000 $305,000 $315,000 $330,000 $335,000Interest ‐ Bonds$189,880 $31,974 $53,650$0$0$0$53,650 $44,950 $36,105 $26,970 $17,400Debt Service$2,325,780 $331,974 $355,650$0$0$0$355,650 $351,950 $353,105 $358,970 $354,400General Fund Overhead$396,996 $376,400 $438,100$0$0$0$438,100 $453,400 $469,300 $485,700 $502,700IT Overhead$20,796 $13,400 $22,200$0$0$0$22,200 $21,520 $20,200 $21,220 $21,370Overhead Allocations$417,792 $389,800 $460,300$0$0$0$460,300 $474,920 $489,500 $506,920 $524,070To the AMP Fund$64,058$0$0$0$0$0$0$0$0$0$0To the General Fund$344,320 $616,030 $611,500 $43,950$0 $43,950$655,450 $640,000 $659,000 $678,500 $693,900To the Water Utility Fund$175,000 $175,720$0$0$0$0$0$0$0$0$0To the Employee Housing Fund$60,204 $107,200 $117,100$0 ($87,830) ($87,830)$29,270 $124,900 $128,900 $132,800 $136,700Other Transfers$643,582 $898,950 $728,600 $43,950 ($87,830) ($43,880)$684,720 $764,900 $787,900 $811,300 $830,600Transfers Out$1,061,374$1,288,750 $1,188,900 $43,950 ($87,830) ($43,880) $1,145,020$1,239,820$1,277,400 $1,318,220 $1,354,670Total Uses$10,748,826 $9,025,737 $10,083,450 $2,264,090($491,250) $1,772,840‐5% $11,856,290 $10,612,900 $11,060,515 $11,087,930 $11,606,790Targeted Reserve (25.0% of Uses)$2,687,207 $2,256,434 $2,520,863 $566,023 ($122,813) $443,210 $2,964,073 $2,653,225 $2,765,129 $2,771,983 $2,901,698Ending Fund Balance ‐ Unrestricted$3,283,651 $5,161,141 $2,747,754 $461,397 ($841,350) ($379,953) $2,367,801 $2,702,541 $2,786,896 $3,233,136 $3,456,456Unrestricted Balance as % of Targeted Reserve122% 229% 109%82% 685% (86%)80% 102% 101% 117% 119%Over/(Short) of Targeted Reserve$596,445 $2,904,707 $226,892 ($104,626) ($718,538) ($823,163) ($596,272) $49,316 $21,767 $461,154 $554,759Change in Fund Balance($1,683,675) $1,877,490 $86,100 ($2,038,090) ($841,350) ($2,879,440) ($2,793,340) $334,740 $84,355 $446,240 $223,3204552
City of Aspen Budget451 ‐ Parking Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$5,340,986 $6,369,739 $6,090,805 $991,978$0 $991,978 $7,082,783 $2,215,400 $1,149,400 ($389,720) ($329,190)Short‐Term Meters$33,200 $28,140 $32,000$0 ($12,000) ($12,000)‐38% $20,000 $24,000 $29,000 $33,960 $34,640Multi‐Space Meters$1,927,287 $2,080,434 $2,000,000$0 ($600,000) ($600,000)‐30% $1,400,000 $1,610,000 $1,852,000 $2,122,420 $2,164,870Pay By Phone$720,016 $808,445 $710,000$0 ($185,000) ($185,000)‐26% $525,000 $593,000 $670,000 $753,450 $768,520E‐Cards$9,270 $7,831 $7,000$0 ($4,000) ($4,000)‐57% $3,000 $3,900 $5,000 $7,430 $7,580Tokens$2,410 $3,086 $2,500$0 ($1,500) ($1,500)‐60% $1,000 $1,300 $1,700 $2,650 $2,700All Day Pass$253,970 $253,553 $258,000$0 ($115,000) ($115,000)‐45% $143,000 $175,000 $214,000 $273,790 $279,260Business Permits$8,800 $22,930 $18,000$0 $7,000 $7,000 39% $25,000 $20,000 $16,000 $19,100 $19,480Lodge Permits$32,967 $32,612 $28,000$0 ($18,000) ($18,000)‐64% $10,000 $13,000 $17,000 $29,710 $30,300Special Permits$94,980 $92,464 $80,000$0 ($35,000) ($35,000)‐44% $45,000 $55,000 $67,000 $84,890 $86,590Construction Permits$754,345 $777,740 $400,000$0 ($50,000) ($50,000)‐13% $350,000 $372,000 $395,000 $424,480 $432,970Tickets$710,785 $591,519 $700,060$0 ($300,000) ($300,000)‐43% $400,060 $486,000 $590,000 $742,910 $757,770On‐Street Parking$4,548,030 $4,698,754 $4,235,560$0 ($1,313,500) ($1,313,500) $2,922,060 $3,353,200 $3,856,700 $4,494,790 $4,584,680Daily Admittance$225,163 $211,011 $220,000$0 ($85,000) ($85,000)‐39% $135,000 $161,000 $192,000 $233,470 $238,140Permits$61,835 $53,670 $60,000$0 ($30,000) ($30,000)‐50% $30,000 $38,000 $48,000 $63,670 $64,940Validation Stickers$207,872 $206,308 $230,000$0 ($80,000) ($80,000)‐35% $150,000 $176,000 $207,000 $244,080 $248,960Garage Parking$494,870 $470,989 $510,000$0 ($195,000) ($195,000)$315,000 $375,000 $447,000 $541,220 $552,040Rio Grande Garage Office Space$61,482 $57,869$0$0$0$0$0 $0 $0 $0 $0Lease Revenue$61,482 $57,869$0$0$0$0$0 $0 $0 $0 $0Investment Income$104,114 $230,860 $121,820$0$0$0$121,820 $44,310 $22,990 $0 $0All Other Revenue$53,211 $31,816 $41,650$0 ($14,000) ($14,000)‐34% $27,650 $32,000 $37,000 $44,180 $45,050Other Revenues$157,325 $262,676 $163,470$0 ($14,000) ($14,000)$149,470 $76,310 $59,990 $44,180 $45,050Revenues In$5,261,707 $5,490,288 $4,909,030$0 ($1,522,500) ($1,522,500) $3,386,530 $3,804,510 $4,363,690 $5,080,190 $5,181,770From the General Fund$55,584 $30,000 $30,000$0$0$0$30,000 $30,000 $30,000 $30,000 $30,000Transfers In$55,584 $30,000 $30,000$0$0$0$30,000 $30,000 $30,000 $30,000 $30,000Total Revenues$5,317,291 $5,520,288 $4,939,030$0 ($1,522,500) ($1,522,500) $3,416,530 $3,834,510 $4,393,690 $5,110,190 $5,211,770$0$0$000000 ‐ Non‐Classified$18,900$0$0 $55,550 ($27,770) $27,780$27,780 $0 $0 $0 $0Non‐Classified$18,900$0$0 $55,550‐$27,770 $27,780$27,780 $0 $0 $0 $010010 ‐ General Administrative$342,531 $344,870 $364,180 $3,320 ($16,040) ($12,720)$351,460 $377,910 $392,260 $407,300 $423,03010030 ‐ Public Outreach$33,060 $69,727 $45,510$20 ($13,530) ($13,510)$32,000 $46,990 $48,520 $50,110 $51,78010050 ‐ Minor Capital Outlay$0 $14,440 $7,110 $28,340$0 $28,340$35,450 $7,250 $7,390 $7,540 $7,690Administrative$375,591 $429,037 $416,800 $31,680($29,570) $2,110$418,910 $432,150 $448,170 $464,950 $482,5004653
City of Aspen Budget451 ‐ Parking Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpact from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection Projection11901 ‐ Rio Grande Building$47,988 $8,647 $0 $0 $0 $0 $0 $0 $0 $0 $011904 ‐ Mill Street Annex$0 $66,492 $124,600$0 ($8,000) ($8,000)$116,600 $127,090 $129,630 $132,220 $134,86011923 ‐ Rio Grande Parking Garage$84,115 $9,429 $125,210$0 ($12,000) ($12,000)$113,210 $127,710 $130,240 $132,830 $135,490Property / Facilities Maintenance$132,103 $84,568 $249,810$0 ($20,000) ($20,000)$229,810 $254,800 $259,870 $265,050 $270,35013510 ‐ On‐Street$1,193,254 $1,370,425 $1,292,960 $10,260 ($116,340) ($106,080) $1,186,880 $1,335,690 $1,380,280 $1,426,850 $1,475,52013520 ‐ Garage$240,246 $310,535 $265,540 $31,760 ($14,000) $17,760$283,300 $274,850 $284,580 $294,740 $305,38013530 ‐ Buttermilk$11,790 $18,545 $51,590 $380 ($430) ($50)$51,540 $53,130 $54,740 $56,410 $58,160Parking Enforcement$1,445,290 $1,699,505 $1,610,090 $42,400 ($130,770) ($88,370) $1,521,720 $1,663,670 $1,719,600 $1,778,000 $1,839,060Operating$1,971,884 $2,213,110 $2,276,700 $129,630 ($208,110) ($78,480)‐9% $2,198,220 $2,350,620 $2,427,640 $2,508,000 $2,591,91081200 ‐ Capital Projects$35,148 $256,434 $62,000 $28,273$0 $28,273$90,273 $152,000 $1,092,200 $105,000 $177,000Capital$35,148 $256,434 $62,000 $28,273$0 $28,273$90,273 $152,000 $1,092,200 $105,000 $177,000General Fund Overhead$404,796 $394,900 $427,200$0$0$0$427,200 $442,200 $457,700 $473,700 $490,300IT Overhead$64,704 $69,100 $76,000$0$0$0$76,000 $73,690 $69,170 $72,660 $73,160Overhead Allocations$469,500 $464,000 $503,200$0$0$0$503,200 $515,890 $526,870 $546,360 $563,460To the General Fund$0$0$0 $1,000$0 $1,000$1,000 $0 $0 $0 $0To the AMP Fund$0$0 $3,709,250$0$0$0 $3,709,250 $0 $0 $0 $0To the Transportation Fund$1,749,996 $1,750,000 $1,750,000$0$0$0 $1,750,000 $1,750,000 $1,750,000 $1,750,000 $1,750,000To the Employee Housing Fund$62,004 $123,700 $127,900$0 ($95,930) ($95,930)$31,970 $132,000 $136,100 $140,300 $144,400Other Transfers$1,812,000 $1,873,700 $5,587,150 $1,000 ($95,930) ($94,930) $5,492,220 $1,882,000 $1,886,100 $1,890,300 $1,894,400Transfers Out$2,281,500 $2,337,700 $6,090,350 $1,000 ($95,930) ($94,930) $5,995,420 $2,397,890 $2,412,970 $2,436,660 $2,457,860Total Uses$4,288,532 $4,807,244 $8,429,050 $158,903 ($304,040) ($145,137) $8,283,913 $4,900,510 $5,932,810 $5,049,660 $5,226,770Targeted Reserve (12.5% of Uses)$536,067 $600,906 $1,053,631 $19,863 ($38,005) ($18,142) $1,035,489 $612,564 $741,601 $631,208 $653,346Ending Fund Balance$6,369,739 $7,082,783 $2,600,785 $833,075 ($1,218,460) ($385,385) $2,215,400 $1,149,400 ($389,720) ($329,190) ($344,190)Balance as % of Targeted Reserve1,188% 1,179% 247%2,124%214% 188% (53%) (52%) (53%)Over/(Short) of Targeted Reserve$5,833,673 $6,481,878 $1,547,154($367,243) $1,179,911 $536,836 ($1,131,321) ($960,398) ($997,536)Change in Fund Balance$1,028,759 $713,044 ($3,490,020) ($158,903) ($1,218,460) ($1,377,363) ($4,867,383) ($1,066,000) ($1,539,120) $60,530 ($15,000)4754
City of Aspen Budget471 ‐ Golf Course Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$783,311 $1,036,406 $254,015 $322,047 $0 $322,047$576,062 $269,667 $268,987 $324,247 $372,607Daily Greens Fees$486,460 $463,289 $484,500$0 ($183,040) ($183,040)$301,460 $494,190 $504,070 $514,150 $524,430Passes$664,697 $713,084 $678,300$0 ($257,500) ($257,500)$420,800 $691,870 $705,710 $719,820 $734,220Other Revenues$661 $12,460 $27,000$0 ($9,450) ($9,450)$17,550 $27,540 $28,090 $28,650 $29,220Course Operations$1,151,818 $1,188,833 $1,189,800$0 ($449,990) ($449,990)$739,810 $1,213,600 $1,237,870 $1,262,620 $1,287,870Driving Range$79,229 $75,979 $74,460$0 ($24,460) ($24,460)$50,000$75,950 $77,470 $79,020 $80,600Cart Rentals$166,946 $154,395 $160,140$0 ($32,080) ($32,080)$128,060 $163,340 $166,610 $169,940 $173,340Club Rentals$52,341 $56,220 $70,000$0 ($21,000) ($21,000)$49,000$71,400 $72,830 $74,290 $75,780Retail$214,830 $215,291 $220,320$0 ($66,100) ($66,100)$154,220 $224,730 $229,220 $233,800 $238,480Special Orders$32,905 $28,384 $45,900$0 ($22,950) ($22,950)$22,950$46,820 $47,760 $48,720 $49,690Lessons$83,155 $93,328 $85,680$0 ($25,700) ($25,700)$59,980$87,390 $89,140 $90,920 $92,740Other Revenues$17,366 $17,153 $15,300$0 ($3,830) ($3,830)$11,470 $15,610 $15,920 $16,240$16,560Pro Shop Operations$646,772 $640,749 $671,800$0 ($196,120) ($196,120)$475,680$685,240 $698,950 $712,930 $727,190Lease Revenue$77,582 $90,716 $38,760$0 $0 $0$38,760 $12,000 $12,240 $12,490 $12,730Property / Facility Maintenance$77,582 $90,716 $38,760$0 $0 $0$38,760 $12,000 $12,240 $12,490 $12,730Investment Income$21,305 $32,722 $5,080$0 $0 $0$5,080 $5,390 $5,380 $6,480 $7,450All Other Revenues$1,254 ($6,365) $770$0 $0 $0$770 $790 $810 $830 $850Other Revenues$22,559 $26,357 $5,850$0 $0 $0$5,850 $6,180 $6,190 $7,310 $8,300Revenues In$1,898,731 $1,946,655 $1,906,210$0 ($646,110) ($646,110) $1,260,100 $1,917,020 $1,955,250 $1,995,350 $2,036,090From the Parks and Open Space Fund$506,304 $528,000 $672,240$0 ($210,000) ($210,000)$462,240 $647,400 $487,340 $504,060 $530,930Transfers In$506,304 $528,000 $672,240$0 ($210,000) ($210,000)$462,240$647,400 $487,340 $504,060 $530,930Total Revenues$2,405,035 $2,474,655 $2,578,450$0 ($856,110) ($856,110) $1,722,340 $2,564,420 $2,442,590 $2,499,410 $2,567,020$0 $0$000000 ‐ Non‐Classified($16,201)$0$0$73,210 ($36,610) $36,600$36,600$0$0$0$0Non‐Classified($16,201)$0$0 $73,210 ($36,610) $36,600$36,600$0$0$0$010010 ‐ General Administrative$185,091 $256,804 $318,740 $1,860 ($34,020) ($32,160)$286,580 $330,960 $343,740 $357,100 $371,09010030 ‐ Public Outreach$5,762 $6,090 $12,050$0 ($2,800) ($2,800)$9,250 $12,290 $12,530 $12,770 $13,03010050 ‐ Minor Capital Outlay($1,285)$0 $2,360 $11,000 ($1,260) $9,740$12,100 $2,410 $2,460 $2,510 $2,560Administrative$189,568 $262,894 $333,150 $12,860 ($38,080) ($25,220)$307,930$345,660 $358,730 $372,380 $386,68011930 ‐ Golf Course Campus$138,912 $141,123 $169,030 $430 ($3,290) ($2,860)$166,170 $173,870 $178,890 $184,110 $189,510Property / Facilities Maintenance$138,912 $141,123 $169,030 $430 ($3,290) ($2,860)$166,170$173,870 $178,890 $184,110 $189,51058110 ‐ Course Area Maintenance$422,899 $359,694 $440,730 $2,440 ($22,770) ($20,330)$420,400 $453,700 $467,100 $480,960 $495,33058120 ‐ Equipment Maintenance$146,275 $201,022 $159,540 $1,530 ($17,800) ($16,270)$143,270 $165,090 $170,860 $176,900 $183,210Course Operations$569,174 $560,716 $600,270 $3,970 ($40,570) ($36,600)$563,670$618,790 $637,960 $657,860 $678,54058210 ‐ Retail Operations$562,512$607,155 $544,620 $3,350 ($23,460) ($20,110)$524,510$560,700$577,350 $594,590 $612,43058220 ‐ Lessons$74,545 $84,019 $79,260$0 ($35,000) ($35,000)$44,260$80,850 $82,470 $84,120 $85,800Pro Shop Operations$637,057 $691,174 $623,880 $3,350 ($58,460) ($55,110)$568,770$641,550 $659,820 $678,710 $698,230Operating$1,518,510 $1,655,907$1,726,330 $93,820 ($177,010) ($83,190) $1,643,140 $1,779,870 $1,835,400 $1,893,060 $1,952,9604855
City of Aspen Budget471 ‐ Golf Course Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection Projection81200 ‐ Capital Projects$271,230 $899,905 $288,040 $12,395 ($198,700) ($186,305) $101,735 $451,200 $129,200 $125,700 $65,300Capital$271,230 $899,905 $288,040 $12,395 ($198,700) ($186,305) $101,735$451,200 $129,200 $125,700 $65,300Fiscal Agent$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Principal ‐ Bonds$123,050 $65,000 $0 $0 $0 $0 $0 $0 $0 $0 $0Interest ‐ Bonds$4,500 $1,996 $0 $0 $0 $0 $0 $0 $0 $0 $0Principal ‐ Bonds$0 $56,541 $56,500$0 $0 $0$56,500 $56,500 $138,500 $138,500 $82,000Debt Service$127,550 $123,537 $56,500$0 $0 $0$56,500 $56,500 $138,500 $138,500 $82,000General Fund Overhead$163,800 $161,400 $167,100$0 $0 $0$167,100 $172,900 $179,000 $185,300 $191,800IT Overhead$30,096 $24,700 $25,200$0 $0 $0$25,200 $24,430 $22,930 $24,090 $24,260Overhead Allocations$193,896 $186,100 $192,300$0 $0 $0$192,300 $197,330 $201,930 $209,390 $216,060To the General Fund$1,940 $750$0 $5,710 $0 $5,710$5,710$0$0$0$0To the Parks and Open Space Fund$13,104 $13,100$13,100$0 $0 $0$13,100 $13,100 $13,100 $13,100 $13,100To the Employee Housing Fund$25,704 $55,700 $65,000$0 ($48,750) ($48,750)$16,250$67,100 $69,200 $71,300 $73,400Other Transfers$40,748 $69,550 $78,100 $5,710 ($48,750) ($43,040)$35,060$80,200 $82,300 $84,400 $86,500Transfers Out$234,644 $255,650 $270,400 $5,710 ($48,750) ($43,040)$227,360$277,530 $284,230 $293,790 $302,560Total Uses$2,151,934 $2,934,999$2,341,270 $111,925 ($424,460) ($312,535)‐18% $2,028,735 $2,565,100 $2,387,330 $2,451,050 $2,402,820Targeted Reserve (12.5% of Uses)$268,992 $366,875 $292,659 $13,991 ($53,058) ($39,067)$253,592 $320,638 $298,416 $306,381 $300,353Ending Fund Balance$1,036,406 $576,062 $491,195 $210,122 ($431,650) ($221,528)$269,667$268,987 $324,247 $372,607 $536,807Fund Balance as % of Targeted Reserve385% 157% 168%567%106% 84% 109% 122% 179%Over/(Short) of Targeted Reserve$767,414 $209,187 $198,536($182,461)$16,075 ($51,651) $25,831 $66,226 $236,455Change in Fund Balance$253,101 ($460,344) $237,180 ($111,925) ($431,650) ($543,575) ($306,395) ($680) $55,260 $48,360 $164,200444456
City of Aspen Budget491 ‐ Truscott Phase I Affordable Housing Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget ProjectionProjection Projection ProjectionOpening Balance$622,458 $485,416 $177,021 $717,901$0 $717,901$894,922 $704,565 $669,655 $635,885 $731,825Rental Income ‐ Permanent$1,207,158 $1,236,093 $1,254,740$0$0$0 $1,254,740 $1,279,830 $1,305,430 $1,331,540 $1,358,170Late Rent Fees$4,650 $3,750 $2,550$0$0$0$2,550 $2,600 $2,650 $2,700 $2,750Laundry$33,007 $32,666 $35,700$0$0$0$35,700 $36,410 $37,140 $37,880 $38,640Parking Fees$100 $100 $150$0$0$0$150 $150 $150 $150 $150Investment Income$18,509 $14,153 $3,540$0$0$0$3,540 $6,200 $5,500 $4,830 $6,750Other Revenues$10,305 $6,199 $4,720$0$0$0$4,720 $4,810 $4,900 $5,000 $5,100Unallocated Revenues$1,273,729 $1,292,961 $1,301,400$0$0$0 $1,301,400 $1,330,000 $1,355,770 $1,382,100 $1,411,560Revenues In$1,273,729 $1,292,961 $1,301,400$0$0$0 $1,301,400 $1,330,000 $1,355,770 $1,382,100 $1,411,560From the Housing Development Fund$0 $975,000 $1,100,000$0$0$0 $1,100,000 $350,000 $350,000$0$0Transfers In$0 $975,000 $1,100,000$0$0$0 $1,100,000 $350,000 $350,000$0$0Total Revenues$1,273,729 $2,267,961 $2,401,400$0$0$0 $2,401,400 $1,680,000 $1,705,770 $1,382,100 $1,411,5600$000000 ‐ Non‐Classified$1,337$0$0$0$0$0$0$0$0$0$0Non‐Classified$1,337$0$0$0$0$0$0$0$0$0$010010 ‐ General Administrative$12,033 $28,862 $18,420$0$0$0$18,420 $18,800 $19,180 $19,560 $19,96010050 ‐ Minor Capital Outlay$2,517 $5,189 $2,810$0$0$0$2,810$2,870$2,930 $2,990 $3,050Administrative$14,550 $34,051 $21,230$0$0$0$21,230 $21,670 $22,110 $22,550 $23,01011911 ‐ Truscott Affordable Housing ‐ City Owned$415,987 $438,388 $479,610 $15,480 ($2,140) $13,340$492,950 $491,760 $504,330 $517,310 $530,720Property / Facilities Maintenance$415,987 $438,388 $479,610 $15,480 ($2,140) $13,340$492,950 $491,760 $504,330 $517,310 $530,72043040 ‐ Property Management$145,400 $148,300 $150,600$0$0$0$150,600 $153,600 $156,700 $159,800 $163,000Housing Sales and Rental Services$145,400 $148,300 $150,600$0$0$0$150,600 $153,600 $156,700 $159,800 $163,000Operating$577,274 $620,739 $651,440 $15,480 ($2,140) $13,340$664,780 $667,030 $683,140 $699,660 $716,73081200 ‐ Capital Projects$0 $375,016 $768,750 $319,057$0 $319,057 $1,087,807 $201,180 $907,800 $207,700 $67,800Capital$0 $375,016 $768,750 $319,057$0 $319,057 $1,087,807 $201,180 $907,800 $207,700 $67,800Fiscal Agent$1,000 $500 $1,000$0$0$0$1,000 $1,000$0$0$0Principal ‐ Bonds$610,000 $630,000 $655,000$0$0$0$655,000 $675,000$0$0$0Interest ‐ Bonds$96,700 $78,400 $53,200$0$0$0$53,200 $27,000$0$0$0Debt Service$707,700 $708,900 $709,200$0$0$0$709,200 $703,000$0$0$0General Fund Overhead$120,000 $142,300 $127,000$0$0$0$127,000 $131,400 $136,000 $140,800 $145,700Overhead Allocations$120,000 $142,300 $127,000$0$0$0$127,000 $131,400 $136,000 $140,800 $145,700To the Housing Development Fund$0$0$0$0$0$0$0$0$0 $225,000 $225,000To the Employee Housing Fund$5,796 $11,500 $11,900$0 ($8,930) ($8,930)$2,970 $12,300 $12,600 $13,000 $13,400Other Transfers$5,796 $11,500 $11,900$0 ($8,930) ($8,930)$2,970 $12,300 $12,600 $238,000 $238,400Transfers Out$125,796$153,800 $138,900$0 ($8,930)($8,930)$129,970$143,700 $148,600 $378,800 $384,100Total Uses$1,410,770 $1,858,455 $2,268,290 $334,537 ($11,070) $323,467$2,591,757 $1,714,910 $1,739,540 $1,286,160 $1,168,630Targeted Reserve (12.5% of Uses)$176,346 $232,307 $283,536$40,433$323,970 $214,364 $217,443 $160,770 $146,079Ending Fund Balance$485,416 $894,922 $310,131 $383,364 $11,070 $394,434$704,565 $669,655 $635,885 $731,825 $974,755Fund Balance as % of Targeted Reserve275% 385% 109%976%217% 312% 292% 455% 667%Over/(Short) of Targeted Reserve$309,070 $662,615 $26,595$354,001$380,595 $455,291 $418,443 $571,055 $828,676Change in Fund Balance($137,041) $409,506 $133,110 ($334,537) $11,070 ($323,467) ($190,357) ($34,910) ($33,770) $95,940 $242,930454557
City of Aspen Budget492 ‐ Marolt Affordable Housing Fund2018 2019 2020 2020202020202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget ProjectionProjection Projection ProjectionOpening Balance$550,258 $1,176,861 $1,634,511 $406,5840$406,584 $2,041,095 $769,945 $668,655 $602,495 $561,295Rental Income ‐ Seasonal$1,240,899 $1,360,913 $1,314,730$0$0$0 $1,314,730 $1,341,020 $1,367,840 $1,395,200 $1,423,100Late Rent Fees$1,800 $1,850 $2,000$0$0$0$2,000 $2,040 $2,080 $2,120 $2,160Laundry$21,949 $24,155 $22,000$0$0$0$22,000 $22,440 $22,890 $23,350 $23,820Parking Fees$20,475 $15,375 $20,000$0$0$0$20,000 $20,400 $20,810 $21,230 $21,650Cafeteria Lease$18,875 $18,695 $12,000$0$0$0$12,000 $12,240 $12,480 $12,730 $12,980Music Room Rentals$5,708$0 $14,500$0$0$0$14,500 $14,790 $15,090 $15,390 $15,700Investment Income$22,884 $41,213 $32,690$0$0$0$32,690 $12,840 $11,050 $9,970 $9,400Other Revenues$40,784 $43,236 $35,200$0$0$0$35,200 $35,900 $36,610 $37,340 $38,080Unallocated Revenues$1,373,374 $1,505,437 $1,453,120$0$0$0 $1,453,120 $1,461,670 $1,488,850 $1,517,330 $1,546,890Revenues In$1,373,374 $1,505,437 $1,453,120$0$0$0 $1,453,120 $1,461,670 $1,488,850 $1,517,330 $1,546,890Total Revenues$1,373,374 $1,505,437 $1,453,120$0$0$0 $1,453,120 $1,461,670 $1,488,850 $1,517,330 $1,546,890000000 ‐ Non‐Classified$1,330$0$0$0$0$0$0$0$0$0$0Non‐Classified$1,330$0$0$0$0$0$0$0$0$0$010010 ‐ General Administrative$3,819 $5,166 $7,020$0$0$0$7,020 $7,160 $7,300 $7,450 $7,60010050 ‐ Minor Capital Outlay$0$0 $560$180$0$180$740 $570 $580 $590 $600Administrative$3,819 $5,166 $7,580$180$0$180$7,760 $7,730 $7,880 $8,040 $8,20011911 ‐ Truscott Affordable Housing ‐ City$18$0$0$0$0$0$0$0$0$0$011913 ‐ Marolt Affordable Housing$342,843 $350,723 $375,510 $1,840 ($2,010) ($170)$375,340 $385,430 $395,680 $406,290 $417,290Property / Facilities Maintenance$342,861 $350,723 $375,510 $1,840 ($2,010) ($170)$375,340 $385,430 $395,680 $406,290 $417,29043040 ‐ Property Management$136,300 $163,310 $157,800$0$0$0$157,800 $161,000 $164,200 $167,500 $170,900Housing Sales and Rental Services$136,300 $163,310 $157,800$0$0$0$157,800 $161,000 $164,200 $167,500 $170,900Operating$484,310 $519,199 $540,890 $2,020 ($2,010)$10$540,900 $554,160 $567,760 $581,830 $596,39081200 ‐ Capital Projects$105,535 $55,404 $155,500 $275,000$0 $275,000$430,500 $145,500 $121,750 $109,000 $104,300Capital$105,535 $55,404 $155,500 $275,000$0 $275,000$430,500 $145,500 $121,750 $109,000 $104,300General Fund Overhead$52,500 $55,900 $50,100$0$0$0$50,100 $51,900 $53,700 $55,600 $57,500Overhead Allocations$52,500 $55,900 $50,100$0$0$0$50,100 $51,900 $53,700 $55,600 $57,500To the Housing Development Fund$100,000$0 $1,700,000$0$0$0 $1,700,000 $800,000 $800,000 $800,000 $800,000To the Employee Housing Fund$5,400 $10,700 $11,100$0 ($8,330) ($8,330)$2,770 $11,400 $11,800 $12,100 $12,500Other Transfers$105,400 $10,700 $1,711,100$0 ($8,330) ($8,330) $1,702,770 $811,400 $811,800 $812,100 $812,500Transfers Out$157,900 $66,600 $1,761,200$0 ($8,330) ($8,330) $1,752,870 $863,300 $865,500 $867,700 $870,000Total Uses$747,745 $641,203 $2,457,590 $277,020 ($10,340) $266,680 $2,724,270 $1,562,960 $1,555,010 $1,558,530 $1,570,690Targeted Reserve (12.5% of Uses)$93,468$80,150 $307,199 $34,628$33,335$340,534$195,370$194,376 $194,816 $196,336Ending Fund Balance$1,175,861 $2,041,095 $630,041 $129,564 $10,340 $139,904$769,945 $668,655 $602,495 $561,295 $537,495Fund Balance as % of Targeted Reserve1,258% 2,547% 205%420%226% 342% 310% 288% 274%Over/(Short) of Targeted Reserve$1,082,393 $1,960,945 $322,842$106,569$429,411 $473,285 $408,119 $366,479 $341,159Change in Fund Balance$625,629 $864,234 ($1,004,470) ($277,020) $10,340 ($266,680) ($1,271,150) ($101,290) ($66,160) ($41,200) ($23,800)464658
City of Aspen Budget501 ‐ Employee Health Insurance Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$3,325,122 $3,783,892$3,193,922 $673,771$0 $673,771$3,867,693 $3,599,973 $3,329,053 $3,055,273 $2,779,003Refund of Expenditure ‐ Stop Loss$78,938 $200,657 $150,000$0$0$0$150,000 $153,000 $156,060 $159,180 $162,360Investment Income$74,030 $129,763 $63,880$0$0$0$63,880 $58,520 $53,110 $47,630 $42,100Employee Premiums$682,356 $693,352 $690,000$0$0$0$690,000 $745,200 $804,820 $869,210 $938,750Employer Premiums$4,553,155 $4,645,332 $4,635,000$0$0$0 $4,635,000 $5,005,800 $5,406,260 $5,838,760 $6,305,860Other Revenues$64,348 $179,211$0$0$0$0$0$0$0$0$0Unallocated Revenues$5,452,827 $5,848,315 $5,538,880$0$0$0 $5,538,880 $5,962,520 $6,420,250 $6,914,780 $7,449,070Revenues In$5,452,827 $5,848,315 $5,538,880$0$0$0 $5,538,880 $5,962,520 $6,420,250 $6,914,780 $7,449,070Total Revenues$5,452,827 $5,848,315 $5,538,880$0$0$0 $5,538,880 $5,962,520 $6,420,250 $6,914,780 $7,449,07099971 ‐ Administrative Costs$203,573 $203,036 $209,800$0$0$0$209,800 $214,000 $218,290 $222,660 $227,12099972 ‐ Employee Health Wellness and Safety$307,947 $265,155 $346,800$0$0$0$346,800 $349,440 $352,140 $354,900 $357,71099973 ‐ Reinsurance$569,905 $508,158 $650,000$0$0$0$650,000 $702,000 $758,160 $818,810 $884,31099974 ‐ Claims Paid$3,912,580 $4,788,165 $4,600,000$0$0$0 $4,600,000 $4,968,000 $5,365,440 $5,794,680 $6,258,250Operating$4,994,005 $5,764,514 $5,806,600$0$0$0 $5,806,600 $6,233,440 $6,694,030 $7,191,050 $7,727,390Total Uses$4,994,005 $5,764,514 $5,806,600$0$0$0 $5,806,600 $6,233,440 $6,694,030 $7,191,050 $7,727,390Ending Fund Balance$3,783,944 $3,867,693$2,926,202 $673,771$0 $673,771$3,599,973 $3,329,053 $3,055,273 $2,779,003 $2,500,683Change in Fund Balance$458,822 $83,801 ($267,720)$0$0$0 ($267,720) ($270,920) ($273,780) ($276,270) ($278,320)4759
City of Aspen Budget505 ‐ Employee Housing Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget Projection Projection Projection ProjectionOpening Balance$3,676,437 $2,002,676 $742,871 $3,159,298$0 $3,159,298 $3,902,169 $3,593,104 $5,899,704 $8,313,534 $10,836,124Rental Income ‐ Permanent$156,840 $209,269 $165,180$0$0$0$165,180 $168,480 $171,850 $175,290 $178,800Investment Income$49,115 $59,763 $14,860$0$0$0$14,860 $71,860 $117,990 $166,270 $216,720Sale of Housing Units$738,316$0$0$0$0$0$0$0$0$0$0Other Revenues$453,296 $6,774$0$0$0$0$0$0$0$0$0Unallocated Revenues$1,397,567 $275,806 $180,040$0$0$0$180,040 $240,340 $289,840 $341,560 $395,520From the General Fund$546,408 $1,147,600 $1,190,500$0 ($892,910) ($892,910)‐75% $297,590 $1,229,000 $1,267,200 $1,305,700 $1,344,200From the Parks and Open Space Fund$141,804 $287,100 $311,000$0 ($233,250) ($233,250)‐75% $77,750 $331,700 $342,100 $352,400 $362,800From the Wheeler Opera House Fund$57,600 $114,800 $114,900$0 ($86,180) ($86,180)‐75% $28,720 $122,600 $126,400 $130,300 $134,100From the Transportation Fund$22,200 $44,200 $44,200$0 ($33,150) ($33,150)‐75% $11,050 $47,200 $48,600 $50,100 $51,600From the Kids First Fund$33,696 $67,100 $67,200$0 ($50,400) ($50,400)‐75% $16,800 $71,700 $73,900 $76,100 $78,400From the Stormwater Fund$25,800 $51,200 $51,300$0 ($38,480) ($38,480)‐75% $12,820 $54,700 $56,400 $58,100 $59,800From the Water Utility Fund$113,400 $212,300 $220,600$0 ($165,450) ($165,450)‐75% $55,150 $235,300 $242,600 $250,000 $257,300From the Electric Utility Fund$60,204 $107,200 $117,100$0 ($87,830) ($87,830)‐75% $29,270 $124,900 $128,900 $132,800 $136,700From the Parking Fund$62,004 $123,700 $127,900$0 ($95,930) ($95,930)‐75% $31,970 $132,000 $136,100 $140,300 $144,400From the Golf Course Fund$25,704 $55,700 $65,000$0 ($48,750) ($48,750)‐75% $16,250 $67,100 $69,200 $71,300 $73,400From the Truscott I Housing Fund$5,796 $11,500 $11,900$0 ($8,930) ($8,930)‐75% $2,970 $12,300 $12,600 $13,000 $13,400From the Marolt Housing Fund$5,400 $10,700 $11,100$0 ($8,330) ($8,330)‐75% $2,770 $11,400 $11,800 $12,100 $12,500From the IT Fund$26,604$53,000$63,900$0($47,930) ($47,930)‐75% $15,970 $66,000 $68,100 $70,100 $72,200Transfers In$1,126,620 $2,286,100 $2,396,600$0 ($1,797,520) ($1,797,520)$599,080 $2,505,900 $2,583,900 $2,662,300 $2,740,800Total Revenues$2,524,187 $2,561,906 $2,576,640$0 ($1,797,520) ($1,797,520)$779,120 $2,746,240 $2,873,740 $3,003,860 $3,136,32000000 ‐ Non‐Classified$21$0$0$0$0$0$0$0$0$0$0Non‐Classified$21$0$0$0$0$0$0$0$0$0$063000 ‐ Down Payment Assistance Progra$34,368 $14,589 $60,000$0$0$0$60,000 $60,000 $60,000 $60,000 $60,000Down Payment Assistance$34,368 $14,589 $60,000$0$0$0$60,000 $60,000 $60,000 $60,000 $60,00011906 ‐ Old Powerhouse$120$0$0$0$0$0$0$0$0$0$011933 ‐ Employee Housing Properties$136,873 $165,502 $161,410$0$0$0$161,410 $164,640 $167,910 $171,270 $174,68011936 ‐ COA Employee Housing Units$603,994$0$0$0$0$0$0$0$0$0$0Property / Facilities Maintenance$740,987 $165,502 $161,410$0$0$0$161,410 $164,640 $167,910 $171,270 $174,680Operating$775,376 $180,091 $221,410$0$0$0$221,410 $224,640 $227,910 $231,270 $234,68081200 ‐ Capital Projects$3,422,572 $482,322 $200,000 $666,775$0 $666,775$866,775 $215,000 $232,000 $250,000 $269,000Capital$3,422,572 $482,322 $200,000 $666,775$0 $666,775$866,775 $215,000 $232,000 $250,000 $269,000Total Uses$4,197,948 $662,413 $421,410 $666,775$0 $666,775 $1,088,185 $439,640 $459,910 $481,270 $503,680Ending Fund Balance$2,002,676 $3,902,169 $2,898,101 $2,492,523 ($1,797,520) $695,003 $3,593,104 $5,899,704 $8,313,534 $10,836,124 $13,468,764Change in Fund Balance($1,673,761) $1,899,493 $2,155,230 ($666,775) ($1,797,520) ($2,464,295) ($309,065) $2,306,600 $2,413,830 $2,522,590 $2,632,6404860
City of Aspen Budget510 ‐ Information Technology Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget ProjectionProjection Projection ProjectionOpening Balance$830,607 $971,068 $516,860 $453,928$0 $453,928$970,788 $818,118 $844,988 $878,968 $911,628IT Fees$76,822 $57,583 $81,500$0$0$0$81,500 $83,130 $84,790 $86,490 $88,220Refund of Expenditures ‐ County$55,832 $45,304 $45,300$0$0$0$45,300 $46,210 $47,130 $48,070 $49,030Investment Income$16,795 $19,372 $10,340$0$0$0$10,340 $10,780 $11,320 $12,000 $12,650Other Revenues$21 $10,035$0$0$0$0$0$0$0$0$0Unallocated Revenues$149,470 $132,294 $137,140$0$0$0$137,140 $140,120 $143,240 $146,560 $149,90011860 ‐ Community Broadband$0 $55,288 $135,000$0$0$0$135,000 $137,700 $140,450 $143,260 $146,130Program Specific Revenues$0 $55,288 $135,000$0$0$0$135,000 $137,700 $140,450 $143,260 $146,130$0$0$0Revenues In$149,470 $187,582 $272,140$0$0$0$272,140 $277,820 $283,690 $289,820 $296,030From the General Fund$1,010,400 $1,160,700 $1,339,000$0$0$0 $1,339,000 $1,298,210 $1,218,490 $1,280,000 $1,288,840From the Parks and Open Space Fund$126,300 $155,900 $209,200$0$0$0$209,200 $202,830 $190,380 $199,990 $201,370From the Wheeler Opera House Fund$92,604 $121,700 $150,700$0$0$0$150,700 $146,110 $137,140 $144,060 $145,050From the Transportation Fund$27,204$30,000$35,200$0$0$0$35,200 $34,130 $32,030 $33,650 $33,880From the Housing Development Fund$5,304 $6,100 $1,200$0$0$0$1,200 $1,160 $1,090 $1,150 $1,160From the Kids First Fund$32,604 $41,600 $47,000$0$0$0$47,000 $45,570 $42,770 $44,930 $45,240From the Stormwater Fund$9,396 $7,300 $2,800$0$0$0$2,800 $2,710 $2,540 $2,670 $2,690From the Water Utility Fund$136,104 $153,000 $189,100$0$0$0$189,100 $183,340 $172,080 $180,760 $182,010From the Electric Utility Fund$20,796 $13,400 $22,200$0$0$0$22,200 $21,520 $20,200 $21,220 $21,370From the Parking Fund$64,704 $69,100 $76,000$0$0$0$76,000 $73,690 $69,170 $72,660 $73,160From the Golf Course Fund$30,096 $24,700 $25,200$0$0$0$25,200 $24,430 $22,930 $24,090 $24,260Transfers In$1,555,512 $1,783,500 $2,097,600$0$0$0 $2,097,600 $2,033,700 $1,908,820 $2,005,180 $2,019,030Total Revenues$1,704,982 $1,971,082 $2,369,740$0$0$0 $2,369,740 $2,311,520 $2,192,510 $2,295,000 $2,315,060$0$0$000000 ‐ Non‐Classified$8,100$0$0 $167,020 ($83,510) $83,510$83,510$0$0$0$0Non‐Classified$8,100$0$0 $167,020 ($83,510) $83,510$83,510$0$0$0$010010 ‐ General Administrative$205,871 $149,711 $160,320 $130 ($21,840) ($21,710)$138,610 $165,480 $170,850 $176,450 $182,26010050 ‐ Minor Capital Outlay$564 $1,975 $6,790 $16,470 ($4,960) $11,510$18,300 $6,930 $7,070 $7,210 $7,350Administrative$206,435 $151,686 $167,110 $16,600 ($26,800) ($10,200)$156,910 $172,410 $177,920 $183,660 $189,61011810 ‐ Workgroup Services$167,950 $313,504 $307,730 $220 ($3,400) ($3,180)$304,550 $319,100 $330,980 $343,390 $356,37011820 ‐ Network Services$444,361 $569,522 $487,170 $190 ($8,480) ($8,290)$478,880 $502,580 $518,610 $535,270 $552,61011830 ‐ Phone Services$79,338 $79,073 $83,030$20 ($420) ($400)$82,630 $85,370 $87,800 $90,310 $92,9204761
City of Aspen Budget510 ‐ Information Technology Fund2018 2019 2020 2020 2020 20202020 2021 2022 2023 2024Actuals Draft ActualsOriginal BudgetSpring SupplementalImpacts from COVIDSpring OrdinanceAdjusted Budget ProjectionProjection Projection Projection11840 ‐ Application Licenses$71,840 $95,316 $147,220 $30 ($720) ($690) $146,530 $151,350 $155,640 $160,060 $164,65011850 ‐ Help Desk$155,338 $156,232 $171,510 $130 ($5,920) ($5,790)$165,720 $178,240 $185,290 $192,670 $200,41011860 ‐ Community Broadband$0 $63,969 $105,520$0 ($8,850) ($8,850)$96,670 $107,630 $109,780 $111,980 $114,220Technology Services$918,827 $1,277,617 $1,302,180 $590 ($27,790) ($27,200)$1,274,980 $1,344,270 $1,388,100 $1,433,680 $1,481,180Operating$1,133,362 $1,429,303 $1,469,290 $184,210 ($138,100) $46,110$1,515,400 $1,516,680 $1,566,020 $1,617,340 $1,670,79081200 ‐ Capital Projects$209,180 $213,059 $535,300 $265,810 ($90,000) $175,810$711,110 $416,000 $231,000 $274,000 $228,800Capital$209,180 $213,059 $535,300 $265,810 ($90,000) $175,810$711,110 $416,000 $231,000 $274,000 $228,800General Fund Overhead$177,300 $179,100 $202,200$0$0$0$202,200 $209,300 $216,600 $224,200 $232,000Overhead Allocations$177,300 $179,100 $202,200$0$0$0$202,200 $209,300 $216,600 $224,200 $232,000To the AMP Fund$15,000$0$0$0$0$0$0$0$0$0$0To the General Fund$3,070 $6,400$0 $1,000$0 $1,000$1,000$0$0$0$0To the Debt Service Fund$0 $37,270 $76,730$0$0$0$76,730 $76,670 $76,810 $76,700 $76,780To the Employee Housing Fund$26,604 $53,000 $63,900$0 ($47,930) ($47,930)$15,970 $66,000 $68,100 $70,100 $72,200Other Transfers$44,674 $149,900 $140,630 $1,000 ($47,930) ($46,930)$93,700 $142,670 $144,910 $146,800 $148,980Transfers Out$221,974 $329,000 $342,830 $1,000 ($47,930) ($46,930)$295,900 $351,970 $361,510 $371,000 $380,980Total Uses$1,564,516 $1,971,362 $2,347,420 $451,020 ($276,030) $174,990$2,522,410 $2,284,650 $2,158,530 $2,262,340 $2,280,570Ending Fund Balance$971,073 $970,788 $539,180 $2,908 $276,030 $278,938$818,118 $844,988 $878,968 $911,628 $946,118Change in Fund Balance$140,466($280) $22,320 ($451,020) $276,030 ($174,990) ($152,670) $26,870 $33,980 $32,660 $34,4904862