Loading...
Transmittal - 7/22/2021CITY COUNCIL TRANSMITTAL ___________________________________ Date Received: ________________ Lisa Shaffer, Chief Administrative Officer Date sent to Council: ___________ ______________________________________________________________________________ TO: Salt Lake City Council DATE: June 30, 2021 Amy Fowler, Chair FROM: Mary Beth Thompson, Chief Financial Officer SUBJECT: Budget Amendment #1 for Fiscal Year 2022 SPONSOR: NA STAFF CONTACT: John Vuyk, Budget Director (801) 535-6394 or Mary Beth Thompson (801) 535-6403 DOCUMENT TYPE: Budget Amendment Ordinance RECOMMENDATION: The Administration recommends that, subsequent to a public hearing, the City Council adopt the following amendments to the FY 2021 – 22 adopted budget. Lisa Shaffer (Jul 1, 2021 15:58 MDT) BUDGET IMPACT: REVENUE EXPENSE GENERAL FUND $ 0.00 ($ 5,138,235.00) MISC GRANT FUND 10,427,551.76 10,427,551.76 FLEET FUND 18,999.00 18,999.00 GOVERNMENTAL IMMUNITY FUND 24,843.00 24,843.00 IMS FUND 219,193.00 219,193.00 RISK FUND 19,705.00 19,705.00 AIRPORT FUND 0.00 1,350,949.00 STREET LIGHTING FUND 0.00 7,098.00 WATER FUND 0.00 460,716.00 SEWER FUND 0.00 221,826.00 STORM WATER FUND 0.00 19,705.00 REFUSE FUND 36,538.00 36,538.00 GOLF FUND 19,649.00 19,649.00 TOTAL $ 10,766,478.76 $ 7,688,537.76 BACKGROUND/DISCUSSION: Revenue for FY 2021-22 Budget Adjustments The following chart shows a current projection of General Fund Revenue for fiscal year 2022. The Fiscal Year has just started. The projections are as found in the adopted budget. FY21-22 Variance Annual Revised Favorable Revenue Budget Forecast (Unfavorable) Property Taxes 112,726,044 112,726,044 - Sales and Use Tax 73,956,475 73,956,475 - Franchise Tax 27,702,126 27,702,126 - PILOT Taxes 1,562,041 1,562,041 - TOTAL TAXES 215,946,686 215,946,686 - License and Permits 29,904,360 29,904,360 - Intergovernmental 4,644,018 4,644,018 - Interest Income 1,271,153 1,271,153 - Fines & Forfeiture 3,474,455 3,474,455 - Parking Meter Collection 2,693,555 2,693,555 - Charges and Services 3,934,570 3,934,570 - Miscellaneous Revenue 3,372,272 3,372,272 - Interfund Reimbursement 22,032,892 22,032,892 - Transfers 19,181,103 19,181,103 - TOTAL W/OUT SPECIAL TAX 306,455,064 306,455,064 - Sales and Use Tax - 1/2 cent 35,600,001 35,600,001 - Sales and Use Tax - County Option - - - TOTAL GENERAL FUND 342,055,065 342,055,065 - Given the available information fund balance would be projected as follows: Fund Balance projections are adjusted based on the proposed budget amendment and increase to 13.48% for the General Fund. TOTAL FOF GF Only TOTAL FOF GF Only TOTAL Beginning Fund Balance 79,814,009 6,625,050 82,617,126 89,242,176 7,018,483 50,124,619 57,143,102 Budgeted Change in Fund Balance (1,510,094) 2,924,682 (7,810,302) (4,885,620) (4,759,137) (19,471,917) (24,231,054) Prior Year Encumbrances (9,671,834) (3,733,743) (6,165,453) (9,899,196) - - - Estimated Beginning Fund Balance 68,632,081 5,815,989 68,641,371 74,457,360 2,259,346 30,652,702 32,912,048 Beginning Fund Balance Percent 20.35%16.62%23.32%22.61%5.60%9.64%9.18% Year End CAFR Adjustments Revenue Changes - - - - - - - Expense Changes (Prepaids, Receivable, Etc.) (4,127,838) - (5,676,583) (5,676,583) 4,759,137 5,477,037 10,236,174 Fund Balance w/ CAFR Changes 64,504,243 5,815,989 62,964,788 68,780,777 7,018,483 36,129,739 43,148,222 Final Fund Balance Percent 19.13%16.62%21.39%20.88%17.39%11.36%12.04% Budget Amendment Use of Fund Balance (15,370,734) BA#1 Revenue Adjustment - - - - - - BA#1 Expense Adjustment - - - - 5,138,235 5,138,235 BA#2 Revenue Adjustment - - - - - - BA#2 Expense Adjustment - (288,488) (288,488) - - - BA#3 Revenue Adjustment - - - - - - BA#3 Expense Adjustment - (6,239,940) (6,239,940) - - - BA#4 Revenue Adjustment - - - - - - BA#4 Expense Adjustment - - - - - - BA#5 Revenue Adjustment - (242,788) (242,788) - - - BA#5 Expense Adjustment - (2,783,685) (2,783,685) - - - BA#6 Revenue Adjustment - - - - - - BA#6 Expense Adjustment - (63,673) (63,673) - - - BA#7 Revenue Adjustment - 540,744 540,744 - - - BA#7 Expense Adjustment - (6,582,824) (6,582,824) - - - BA#8 Revenue Adjustment - - - - - - BA#8 Expense Adjustment (1,000,000) (1,000,000) (2,000,000) - - - BA#9 Revenue Adjustment - 439,809 439,809 - - - BA#9 Expense Adjustment - 362,532 1,555,532 - - - Change in Revenue 6,827,370 2,202,494 3,018,144 5,220,638 - - - Fund Balance Budgeted Increase 900,000 - - - - - - - - Adjusted Fund Balance 56,860,879 7,018,483 50,124,619 58,336,102 7,018,483 41,267,974 48,286,457 Adjusted Fund Balance Percent 16.86%20.05%17.03%17.71%17.39%12.98%13.48% Projected Revenue 337,251,407 35,000,000 294,345,168 329,345,168 40,359,137 317,980,599 358,339,736 2021 Projection2020 Fund Balance Projections 2022 Projection The Administration is requesting a budget amendment totaling $10,766,478.76 of revenue and expense of $7,688,537.76. The amendment proposes changes in the 13 funds increases General Fund fund balance by $5,138,235.00. The proposal includes four initiatives for Council review. No positions are being requested. A summary spreadsheet document, outlining proposed budget changes is attached. The Administration requests this document be modified based on the decisions of the Council. The budget opening is separated in eight different categories: A. New Budget Items B. Grants for Existing Staff Resources C. Grants for New Staff Resources D. Housekeeping Items E. Grants Requiring No New Staff Resources F. Donations G. Council Consent Agenda Grant Awards I. Council Added Items PUBLIC PROCESS: Public Hearing SALT LAKE CITY ORDINANCE No. ______ of 2021 First amendment to the Final Budget of Salt Lake City, including the employment staffing document, for Fiscal Year 2021-22) In June of 2021, the Salt Lake City Council adopted the final budget of Salt Lake City Corporation, including the employment staffing document, effective for the fiscal year beginning July 1, 2021 and ending June 30, 2022, in accordance with the requirements of Section 10-6-118 of the Utah Code. The City’s Budget Director, acting as the City’s Budget Officer, prepared and filed with the City Recorder proposed amendments to said duly adopted budget, including the amendments to the employment staffing document necessary to effectuate the staffing changes specifically stated herein, copies of which are attached hereto, for consideration by the City Council and inspection by the public. All conditions precedent to amend said budget, including the employment staffing document as provided above, have been accomplished. Be it ordained by the City Council of Salt Lake City, Utah: SECTION 1. Purpose. The purpose of this Ordinance is to amend the final budget of Salt Lake City Corporation, including the employment staffing document, as approved, ratified and finalized by Salt Lake City Ordinance No. 32 of 2021. SECTION 2. Adoption of Amendments. The budget amendments, including amendments to the employment staffing document necessary to effectuate the staffing changes specifically stated herein, attached hereto and made a part of this Ordinance are hereby adopted and incorporated into the budget of Salt Lake City Corporation, for the fiscal year beginning July 1, 2 2021 and ending June 30, 2022, in accordance with the requirements of Section 10-6-128 of the Utah Code. SECTION 3. Filing of copies of the Budget Amendments. The said Budget Officer is authorized and directed to certify and file a copy of said budget amendments, including amendments to the employment staffing document, in the office of said Budget Officer and in the office of the City Recorder which amendments shall be available for public inspection. SECTION 4. Effective Date. This Ordinance shall take effect upon adoption. Passed by the City Council of Salt Lake City, Utah, this _____ day of __________, 2021. ________________________ Amy Fowler, Council Chair ATTEST: ______________________________ CITY RECORDER Transmitted to the Mayor on __________________ Mayor’s Action: ____ Approved ____ Vetoed _________________________ MAYOR ATTEST: _______________________________ CITY RECORDER (SEAL) Bill No. _________ of 2021. Published: ___________________. Salt Lake City Attorney’s Office Approved As To Form Jaysen Oldroyd Senior City Attorney Initiative Number/Name Fund Revenue Amount Expenditure Amount Revenue Amount Expenditure Amount Ongoing or One-time FTEs 1 Police Department Salary Changes (See item E-2) GF - (6,864,665.00) 2 Non-Represented Salary Changes (GF)GF - 1,387,503.00 2 Non-Represented Salary Changes (GF Txr Out) GF - 338,927.00 2 Non-Represented Salary Changes (Fleet)Fleet 18,999.00 18,999.00 2 Non-Represented Salary Changes (Govt Immunity) Govt Immunity 24,843.00 24,843.00 2 Non-Represented Salary Changes (IMS)IMS 219,193.00 219,193.00 2 Non-Represented Salary Changes (Risk)Risk 19,705.00 19,705.00 2 Non-Represented Salary Changes (Airport)Airport - 1,350,949.00 2 Non-Represented Salary Changes (PU: Street Lighting) Street Lighting - 7,098.00 2 Non-Represented Salary Changes (PU: Water) Water - 460,716.00 2 Non-Represented Salary Changes (PU: Sewer) Sewer - 221,826.00 2 Non-Represented Salary Changes (PU: Storm Water) Storm Water - 19,705.00 2 Non-Represented Salary Changes (Refuse)Refuse 36,538.00 36,538.00 2 Non-Represented Salary Changes (Golf)Golf 19,649.00 19,649.00 Fiscal Year 2021-22 Budget Amendment #1 Council ApprovedAdministration Proposed Section A: New Items Section C: Grants for New Staff Resources Section B: Grants for Existing Staff Resources 1 Fiscal Year 2021-22 Budget Amendment #1 Initiative Number/Name Fund Revenue Amount Expenditure Amount Revenue Amount Expenditure Amount Ongoing or One-time FTEs 1 US Department of the Treasury; Emergency Rental Assistance 2 Misc Grants 1,920,233.76 1,920,233.76 2 Police Department Salary Changes (See item E-2) Misc Grants 6,864,665.00 6,864,665.00 2 Police Department Salary Changes (See item E-2) Misc Grants 1,642,653.00 1,642,653.00 - Council Approved Section D: Housekeeping Section F: Donations Section E: Grants Requiring No New Staff Resources Administration Proposed 2 Fiscal Year 2021-22 Budget Amendment #1 Initiative Number/Name Fund Revenue Amount Expenditure Amount Revenue Amount Expenditure Amount Ongoing or One-time FTEs Consent Agenda #5 Total of Budget Amendment Items 10,766,478.76 7,688,537.76 - - - Total by Fund Class, Budget Amendment #9: General Fund GF - (5,138,235.00) - - - Miscellaneous Grants Fund Misc Grants 10,427,551.76 10,427,551.76 - - - Fleet Fund Fleet 18,999.00 18,999.00 - - - Governmental Immunity Fund Govt Immunity 24,843.00 24,843.00 - - - IMS Fund IMS 219,193.00 219,193.00 - - - Risk Fund Risk 19,705.00 19,705.00 - - - Airport Airport - 1,350,949.00 - - - Street Lighting Fund Street Lighting - 7,098.00 - - - Water Fund Water - 460,716.00 - - - Sewer Fund Sewer - 221,826.00 - - - Storm Water Fund Storm Water - 19,705.00 - - - Refuse Fund Refuse 36,538.00 36,538.00 - - - Golf Fund Golf 19,649.00 19,649.00 - - - - - - Total of Budget Amendment Items 10,766,478.76 7,688,537.76 - - - Administration Proposed Council Approved Section I: Council Added Items Section G: Council Consent Agenda -- Grant Awards 3 Fiscal Year 2021-22 Budget Amendment #1 Current Year Budget Summary, provided for information only FY 2021-22 Budget, Including Budget Amendments FY 2021-22 Adopted Budget BA #1 Total BA #2 Total BA #3 Total BA #4 Total BA #5 Total ^^ Total Through BA#5 ^^ General Fund (FC 10)367,582,070 (5,138,235.00) 362,443,835.00 Curb and Gutter (FC 20)3,000 3,000.00 DEA Task Force Fund (FC 41)2,033,573 2,033,573.00 Misc Special Service Districts (FC 46)1,550,000 1,550,000.00 Street Lighting Enterprise (FC 48)5,699,663 7,098.00 5,706,761.00 Water Fund (FC 51)127,365,555 460,716.00 127,826,271.00 Sewer Fund (FC 52)268,213,796 221,826.00 268,435,622.00 Storm Water Fund (FC 53)19,201,013 19,705.00 19,220,718.00 Airport Fund (FC 54,55,56)706,792,500 1,350,949.00 708,143,449.00 Refuse Fund (FC 57)24,713,505 36,538.00 24,750,043.00 Golf Fund (FC 59)9,697,417 19,649.00 9,717,066.00 E-911 Fund (FC 60)4,056,856 4,056,856.00 Fleet Fund (FC 61)28,090,576 18,999.00 28,109,575.00 IMS Fund (FC 65)24,302,487 219,193.00 24,521,680.00 County Quarter Cent Sales Tax for Transportation (FC 69) 5,307,142 5,307,142.00 CDBG Operating Fund (FC 71)5,341,332 5,341,332.00 Miscellaneous Grants (FC 72)18,684,617 10,427,551.76 29,112,168.76 Other Special Revenue (FC 73)273,797 273,797.00 Donation Fund (FC 77)2,752,565 2,752,565.00 Housing Loans & Trust (FC 78)16,121,000 16,121,000.00 Debt Service Fund (FC 81)31,850,423 31,850,423.00 CIP Fund (FC 83, 84 & 86)29,503,216 29,503,216.00 Governmental Immunity (FC 85)2,933,913 24,843.00 2,958,756.00 Risk Fund (FC 87)52,939,489 19,705.00 52,959,194.00 Total of Budget Amendment Items 1,755,009,505 7,688,537.76 - - - - 1,762,698,042.76 4 Fiscal Year 2021-22 Budget Amendment #1 Current Year Budget Summary, provided for information only FY 2021-22 Budget, Including Budget Amendments ^^ FY 2021-22 Adopted Budget through BA#5 ^^ BA #6 Total BA #7 Total BA #8 Total BA #9 Total Total To-Date General Fund (FC 10)362,443,835 362,443,835 Curb and Gutter (FC 20)3,000 3,000 DEA Task Force Fund (FC 41)2,033,573 2,033,573 Misc Special Service Districts (FC 46)1,550,000 1,550,000 Street Lighting Enterprise (FC 48)5,706,761 5,706,761 Water Fund (FC 51)127,826,271 127,826,271 Sewer Fund (FC 52)268,435,622 268,435,622 Storm Water Fund (FC 53)19,220,718 19,220,718 Airport Fund (FC 54,55,56)708,143,449 708,143,449 Refuse Fund (FC 57)24,750,043 24,750,043 Golf Fund (FC 59)9,717,066 9,717,066 E-911 Fund (FC 60)4,056,856 4,056,856 Fleet Fund (FC 61)28,109,575 28,109,575 IMS Fund (FC 65)24,521,680 24,521,680 County Quarter Cent Sales Tax for Transportation (FC 69) 5,307,142 5,307,142 CDBG Operating Fund (FC 71)5,341,332 5,341,332 Miscellaneous Grants (FC 72)29,112,169 29,112,169 Other Special Revenue (FC 73)273,797 273,797 Donation Fund (FC 77)2,752,565 2,752,565 Housing Loans & Trust (FC 78)16,121,000 16,121,000 Debt Service Fund (FC 81)31,850,423 31,850,423 CIP Fund (FC 83, 84 & 86)29,503,216 29,503,216 Governmental Immunity (FC 85)2,958,756 2,958,756 Risk Fund (FC 87)52,959,194 52,959,194 Total of Budget Amendment Items 1,762,698,043 - - - - - 1,762,698,043 Budget Manager Analyst, City Council Contingent Appropriation 5 Fiscal Year 2021-22 Budget Amendment #1 6 Salt Lake City FY 2021-22 Budget Amendment #1 Initiative Number/Name Fund Amount 1 Section A: New Items A-1: Police Department Salary Changes (See item E-2 ) GF -$6,684,665.00 Department: Finance Prepared By: John Vuyk US Department of the Treasury issued the further guidance for the American Rescue Plan Act (ARPA), which allows Cities to use funding to pay for recruitment and retention of police officers. The Administration is proposing shifting funding already in the budget for police officers to the grant funds and using additional grant dollars to address compression issues within the Police Department between Officers and Administrative personnel. The administration is requesting the increased salaries for the Police Officers of $6,864,665 be transferred from the General Fund to the Grant Fund, funded through ARPA. The Administration is also proposing a salary increase that would match the top-level police officer for all Sergeants, Lieutenants and Captains within the police department. The total of this proposed salary increase is $1,642,653. The total salary increases of $8,507,318 would be funded through the ARPA. The General Fund would see a decrease for the $6,864,665 originally budgeted for the Police Officer increases. The Administration is seeking a straw poll to allow for payroll processing of these proposed changes. A-2: Non-Represented Salary Changes GF $1,387,503.00 GF $338,927.00 Fleet $18,999.00 Govt Immunity $24,843.00 IMS $219,193.00 Risk $19,705.00 Airport $1,350,949.00 Street Lighting $7,098.00 Water $460,716.00 Sewer $221,826.00 Storm Water $19,705.00 Refuse $36,538.00 Golf $19,649.00 Department: Finance Prepared By: John Vuyk US Department of the Treasury issued the further guidance for the American Rescue Plan Act, which allows Cities to use funding to pay for recruitment and retention of police officers. The Administration is proposing shifting funding already in the budget for police officers to the grant funds which will free up dollars within the General Fund. The Administration is proposing to use some of those funds to increase the salary adjustment for non -represented employees to 4.5%. Negotiations with the unions created compression issues between union employees a nd non-represented employees. This proposal reduces those compression issues. The proposal includes all departments across the City. The Airport and Public Utilities will fund the salary increases within their Departments through their respective funds. The General Fund, Internal Services Funds, and smaller Enterprise Funds will be funded by the General Fund. This will use $1,726,430 of General Fund fund balance. The Administration requests a straw poll to allow for processing of these pay increases moving forward. Section B: Grants for Existing Staff Resources Salt Lake City FY 2021-22 Budget Amendment #1 Initiative Number/Name Fund Amount 2 Section C: Grants for New Staff Resources Section D: Housekeeping Section E: Grants Requiring No New Staff Resources E-1: US Department of the Treasury; Emergency Rental Assistance 2 Grant $1,920,233.76 Department: Community and Neighborhoods Prepared By: Tony Milner / Brent Beck US Department of the Treasury deposited $1,920,233.76 into the City's bank account on June 3, 2021. These Emergency Rental Assistance Program (ERAP) 2 funds were made available in the American Rescue Pla n Act. These funds represent 40% of the City's total allocation ($4,800,599.40), with the remaining 60% to be deposited in December 2021. The Department of Treasury Emergency Rental Assistance Program (ERAP) 2 makes funds available to assist households who are unable to pay rent and utilities due to the COVID-19 pandemic. Funding is targeted to households that are at or below 80% of the Area Median Income, demonstrates a risk of experiencing homelessness or housing instability, and has experienced a reduction in household income and/or incurred significant costs and/or experienced financial hardship due to COVID-19. The Department of Treasury regulations set forth that 85% of the funds ($1,632,198.70) must be used for direct financial assistance, including rent, rental arrears, utilities and home energy costs, utilities and home energy costs arrears, and other expenses related to housing. The remaining 15% ($288,035.06) may be used for housing stability services, including case management and other services intended to keep households stably housed, and administrative costs. See Accounting & Fund Detail tab for more financial information. This budget amendment will create the ability for the City to accept the allocation from the Department of Trea sury and create appropriate expense and revenue budgets for the direct financial assistance and housing stability/administration budgets. It is the intent of the administration to deploy these funds in conjunction with the State (DWS) and County via the Rent Relief program being administered via the State. This is the same deployment strategy that was used with the first traunche of emergency rent assistance funding. HAND will not be requesting any staff positions as the required administrative work can be covered with existing resources. Salt Lake City FY 2021-22 Budget Amendment #1 Initiative Number/Name Fund Amount 3 E-2: Police Department Salary Changes (See item A-1) Grant $6,684,665.00 Grant $1,642,653.00 Department: Prepared By: John Vuyk US Department of the Treasury issued the furhter guidance for the American Rescue Plan Act (ARPA), which allows Cities to use funding to pay for recruitment and retention of police officers. The Administration is propo sing shifting funding already in the budget for police officers to the grant funds and using additional grant dollars to address compression issues within the Police Department between Officers and Administrative personnel. The administration is requesting the increased salaries for the Police Officers of $6,864,665 be transferred from the General Fund to the Grant Fund, funded through ARPA. The Administration is also proposing a salary increase that would match the top-level police officer for all Sergeants, Lieutenants and Captains within the police department. The total of this proposed salary increase is $1,642,653. The total salary increases of $8,507,318 would be funded through the ARPA. The General Fund would see a decrease for the $6,864,665 originally budgeted for the Police Officer increases. The Administration is seeking a straw poll to allow for payroll processing of these proposed changes. Section F: Donations Section G: Consent Agenda Consent Agenda Section I: Council Added Items Impact Fees ‐ Summary Confidential Data pulled 6/23/2021 Unallocated Budget Amounts: by Major Area Area Cost Center UnAllocated Cash Notes: Impact fee - Police 8484001 450,551$ A Impact fee - Fire 8484002 1,076,784$ B Impact fee - Parks 8484003 9,145,705$ C Impact fee - Streets 8484005 5,573,359$ D 16,246,399$ Expiring Amounts: by Major Area, by Month 202007 (Jul2020)2021Q1 -$ -$ -$ -$ -$ 202008 (Aug2020)2021Q1 -$ -$ -$ -$ -$ 202009 (Sep2020)2021Q1 -$ -$ -$ -$ -$ 202010 (Oct2020)2021Q2 -$ -$ -$ -$ -$ 202011 (Nov2020)2021Q2 -$ -$ -$ -$ -$ 202012 (Dec2020)2021Q2 -$ -$ -$ -$ -$ 202101 (Jan2021)2021Q3 -$ -$ -$ -$ -$ 202102 (Feb2021)2021Q3 16,273$ -$ -$ -$ 16,273$ 202103 (Mar2021)2021Q3 16,105$ -$ -$ -$ 16,105$ 202104 (Apr2021)2021Q4 1,836$ -$ -$ -$ 1,836$ 202105 (May2021)2021Q4 14,542$ -$ -$ -$ 14,542$ Current Month 202106 (Jun2021)2021Q4 30,017$ ^ 1 -$ -$ -$ 30,017$ 202107 (Jul2021)2022Q1 10,107$ ^ 1 -$ -$ -$ 10,107$ 202108 (Aug2021)2022Q1 6,804$ ^ 1 -$ -$ -$ 6,804$ 202109 (Sep2021)2022Q1 5,554$ ^ 1 -$ -$ -$ 5,554$ 202110 (Oct2021)2022Q2 3,106$ ^ 1 -$ -$ -$ 3,106$ 202111 (Nov2021)2022Q2 -$ -$ -$ -$ -$ 202112 (Dec2021)2022Q2 -$ -$ -$ -$ -$ 202201 (Jan2022)2022Q3 -$ -$ -$ -$ -$ 202202 (Feb2022)2022Q3 -$ -$ -$ -$ -$ 202203 (Mar2022)2022Q3 -$ -$ -$ -$ -$ 202204 (Apr2022)2022Q4 -$ -$ -$ -$ -$ 202205 (May2022)2022Q4 -$ -$ -$ -$ -$ 202206 (Jun2022)2022Q4 -$ -$ -$ -$ -$ 202207 (Jul2022)2023Q1 -$ -$ -$ -$ -$ 202208 (Aug2022)2023Q1 -$ -$ -$ -$ -$ 202209 (Sep2022)2023Q1 -$ -$ -$ -$ -$ 202210 (Oct2022)2023Q2 -$ -$ -$ -$ -$ 202211 (Nov2022)2023Q2 -$ -$ -$ -$ -$ 202212 (Dec2022)2023Q2 -$ -$ -$ -$ -$ 202301 (Jan2023)2023Q3 -$ -$ -$ -$ -$ 202302 (Feb2023)2023Q3 -$ -$ -$ -$ -$ 202303 (Mar2023)2023Q3 -$ -$ -$ -$ -$ 202304 (Apr2023)2023Q4 118$ -$ -$ -$ 118$ 202305 (May2023)2023Q4 469$ -$ -$ -$ 469$ 202306 (Jun2023)2023Q4 276$ -$ -$ -$ 276$ Total, Currently Expiring through June 2021 78,774$ -$ -$ -$ 78,774$ Notes ^1 FY 2023Calendar Month 6/23/21: We are currently in a refund situation. We will refund $56k in the next 5 months without offsetting expendituresFiscal Year 2021FY 2022Fiscal Quarter E = A + B + C + D Police Fire Parks Streets Total Impact Fees Confidential Data pulled 6/23/2021 AAA BBB CCC DDD = AAA - BBB - CCC Police Allocation Budget Amended Allocation Encumbrances YTD Expenditures Allocation Remaining Appropriation Values Description Cost Center Sum of Police Allocation Budget Amended Sum of Police Allocation Encumbrances Sum of Police Allocation YTD Expenditures Sum of Police Allocation Remaining Appropriation Impact fee - Streets Westside 8484005 -$ -$ -$ -$ Police'sConsultant'sContract 8419205 5,520$ 3,507$ 1,955$ 58$ Police Refunds 8418013 539,687$ -$ 69,291$ 470,396$ Police impact fee refunds 8417006 510,828$ -$ -$ 510,828$ A PolicePrecinctLandAquisition 8419011 1,410,243$ 239,836$ -$ 1,170,407$ Grand Total 2,512,316$ 289,381$ 71,246$ 2,151,690$ Fire Allocation Budget Amended Allocation Encumbrances YTD Expenditures Allocation Remaining Appropriation Values Fire refunds 8416007 82,831$ -$ -$ 82,831$ Fire Station #14 8415001 6,650$ 6,083$ 567$ -$ Fire Station #14 8416006 52,040$ -$ 7,428$ 44,612$ Fire Station #3 8415002 1,568$ -$ -$ 1,568$ Fire Station #3 8416009 1,050$ 96$ 485$ 469$ Impact fee - Fire 8484002 -$ -$ -$ -$ Impact fee - Streets Westside 8484005 -$ -$ -$ -$ Study for Fire House #3 8413001 15,700$ -$ -$ 15,700$ B FireTrainingCenter 8419012 46,550$ -$ 46,550$ -$ Fire'sConsultant'sContract 8419202 10,965$ 4,883$ 6,024$ 58$ FY20 FireTrainingFac. 8420431 66,546$ -$ 10,516$ 56,031$ Fire Station #3 Debt Service 8421200 541,106$ -$ 541,106$ -$ Fire Station #14 Debt Service 8421201 339,172$ -$ 339,172$ -$ Grand Total 1,164,177$ 11,063$ 951,846$ 201,268$ Parks Allocation Budget Amended Allocation Encumbrances YTD Expenditures Allocation Remaining Appropriation Values Impact fee - Parks 8484003 -$ -$ -$ -$ JR Boat Ram 8420144 125,605$ 42,546$ 83,059$ -$ Three Creeks Confluence 8419101 173,017$ -$ 173,017$ -$ Cnty #2 Match 3 Creek Confluen 8420426 515,245$ 303,578$ 211,667$ -$ Park'sConsultant'sContract 8419204 7,643$ 4,815$ 2,786$ 42$ Folsom Trail/City Creek Daylig 8417010 766$ -$ 470$ 296$ Cwide Dog Lease Imp 8418002 24,056$ 23,000$ 270$ 786$ C Rosewood Dog Park 8417013 16,087$ -$ 14,977$ 1,110$ Jordan R 3 Creeks Confluence 8417018 11,856$ -$ 10,287$ 1,570$ 9line park 8416005 86,322$ 19,702$ 64,364$ 2,256$ Jordan R Trail Land Acquisitn 8417017 2,946$ -$ -$ 2,946$ Warm Springs Off Leash 8420132 27,000$ 15,811$ 6,589$ 4,600$ Fairmont Park Lighting Impr 8418004 50,356$ 43,597$ 605$ 6,155$ FY Parks and Public Lands Compreh 8417008 7,500$ -$ -$ 7,500$ Rich Prk Comm Garden 8420138 27,478$ 4,328$ 14,683$ 8,467$ Redwood Meadows Park Dev 8417014 15,939$ -$ 6,589$ 9,350$ ImperialParkShadeAcct'g 8419103 10,830$ -$ -$ 10,830$ Park refunds 8416008 11,796$ -$ -$ 11,796$ IF Prop Acquisition 3 Creeks 8420406 350,000$ 21,375$ 272,516$ 56,109$ Parks Impact Fees 8418015 102,256$ -$ 875$ 101,381$ UTGov Ph2 Foothill Trails 8420420 200,000$ 22,524$ 64,916$ 112,560$ FY20 Bridge to Backman 8420430 727,000$ 574,709$ 4,080$ 148,211$ 9Line Orchard 8420136 195,045$ -$ -$ 195,045$ Waterpark Redevelopment Plan 8421402 225,000$ -$ -$ 225,000$ Trailhead Prop Acquisition 8421403 275,000$ -$ -$ 275,000$ Bridge to Backman 8418005 350,250$ 10,285$ 57,026$ 282,939$ Parley's Trail Design & Constr 8417012 327,678$ -$ -$ 327,678$ Cnty #1 Match 3 Creek Confluen 8420424 400,000$ 7,790$ 11,523$ 380,688$ Jordan Prk Event Grounds 8420134 431,000$ -$ -$ 431,000$ Wasatch Hollow Improvements 8420142 490,830$ -$ -$ 490,830$ Fisher House Exploration Ctr 8421401 540,732$ 1,883$ 1,556$ 537,293$ Marmalade Park Block Phase II 8417011 1,145,394$ 38,922$ 41,121$ 1,065,351$ Fisher Carriage House 8420130 1,098,764$ -$ -$ 1,098,764$ Pioneer Park 8419150 3,442,199$ 239,284$ 81,934$ 3,120,981$ Grand Total 11,415,591$ 1,374,148$ 1,124,909$ 8,916,534$ Streets Allocation Budget Amended Allocation Encumbrances YTD Expenditures Allocation Remaining AppropriationValues 9 Line Central Ninth 8418011 152,500$ 152,500$ -$ -$ Impact fee - Streets Westside 8484005 -$ -$ -$ -$ 500 to 700 S 8418016 575,000$ 96,637$ 478,363$ -$ Transportation Safety Imp 8418007 147,912$ 29,197$ 118,715$ -$ 700 South Reconstruction 8414001 310,032$ -$ 310,032$ -$ 700 South Reconstruction 8415004 1,157,506$ 2,449$ 1,155,057$ -$ Trans Safety Improvements 8419007 210,752$ 141,623$ 69,130$ -$ 500/700 S Street Reconstructio 8412001 41,027$ 32,718$ 8,309$ -$ D Trans Master Plan 8419006 13,000$ 13,000$ -$ -$ IF Roundabout 2000 E Parleys 8420122 455,000$ -$ 455,000$ -$ LifeOnState Imp Fee 8419009 124,605$ -$ 124,605$ -$ Transportation Safety Improvem 8417007 22,360$ -$ 20,821$ 1,539$ Gladiola Street 8406001 16,544$ 13,865$ 435$ 2,244$ Street'sConsultant'sContract 8419203 39,176$ 17,442$ 9,360$ 12,374$ Complete Street Enhancements 8420120 125,000$ -$ 87,005$ 37,995$ Transp Safety Improvements 8420110 250,000$ 121,917$ 90,000$ 38,083$ 1300 S Bicycle Bypass (pedestr 8416004 42,833$ -$ -$ 42,833$ Indiana Ave/900 S Rehab Design 8412002 124,593$ -$ -$ 124,593$ Bikeway Urban Trails 8418003 200,000$ -$ -$ 200,000$ TransportationSafetyImprov IF 8421500 375,000$ 72,947$ -$ 302,053$ IF Complete Street Enhancement 8421502 625,000$ -$ -$ 625,000$ Street Improve Reconstruc 20 8420125 2,858,090$ 1,216,451$ 607,870$ 1,033,769$ Traffic Signal Upgrades 8419008 251,316$ -$ 21,448$ 229,868$ Traffic Signal Upgrades 8420105 300,000$ 300,000$ -$ -$ Traffic Signal Upgrades 8421501 875,000$ -$ -$ 875,000$ Grand Total 9,292,247$ 2,210,747$ 3,556,149$ 3,525,351$ Total 24,384,332$ 3,885,339$ 5,704,150$ 14,794,843$ E = A + B + C + D TRUE TRUE TRUE TRUE 9,145,705$ 5,573,359$ 16,246,399$ 8484002 8484003 8484005 450,551$ $1,076,784 8484001 UnAllocated Budget Amount