Loading...
Transmittal - 3/29/2022 DEPARTMENT OF FINANCE POLICY AND BUDGET DIVISION 451 SOUTH STATE STREET, ROOM 238 PO BOX 145467, SALT LAKE CITY, UTAH 84114-5455 TEL 801-535-6394 ERIN MENDENHALL Mayor MARY BETH THOMPSON Chief Financial Officer CITY COUNCIL TRANSMITTAL ___________________________________ Date Received: ________________ Lisa Shaffer, Chief Administrative Officer Date sent to Council: ___________ ______________________________________________________________________________ TO: Salt Lake City Council DATE: March 25,2022 Dan Dugan, Chair FROM: Mary Beth Thompson, Chief Financial Officer SUBJECT: Budget Amendment #7 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. BUDGET IMPACT: REVENUE EXPENSE GENERAL FUND $ ( 794,641.00) $ 843,298.00 SEWER FUND 157,874,000.00 874,000.00 WATER FUND 42,234,000.00 234,000.00 MISCELLANEOUS GRANT FUND 2,416,979.00 2,416,979.00 HOUSING FUND 0.00 2,800,000.00 CIP FUND 4,106,500.00 4,806,500.00 MISC, SPECIAL SERVICE DISTRICT FUND 500,000.00 500,000.00 IMS FUND 713,680.00 713,680.00 TOTAL $ 207,050,218.00 $ 13,188,157.00 Lisa Shaffer (Mar 29, 2022 08:23 MDT) BACKGROUND/DISCUSSION: Revenue for FY 2021-22 Budget Adjustments The following chart shows a current projection of General Fund Revenue for fiscal year 2022. Projections for fiscal year 2021 were better than expected, while projections for fiscal year 2022 continue to trend above budget. The City is forecasting increases in most categories. Sales tax for the first quarter was well above budget and the prior year. However, franchise tax is lagging below budget from a decrease in water franchise ($704,000) and telephone ($218,000) franchise taxes. Licenses and Permits is coming in very strong. Licenses are above budget driven by increases in airport parking taxes and innkeepers tax. The City continues to see positive construction number leading permits to remain very strong with increases in plan check fees and building permits. Field reservations, land leases and building leases are leading to an increase in Charges, Fees and Rentals. Miscellaneous revenue is seeing an increase in fuel reimbursement and other utility reimbursements. These are offset by special event revenue due to a continued decrease in in person events in the City. Fines and Forfeitures are below budget from a decrease in moving violations and justice court fines. Interfund Reimbursement is below budget due to fire reimbursement from the airport which should show an increase next fiscal year. FY21-22 FY21-22 Amended Variance Annual Ammended Revised Favorable Revenue Budget Budget Forecast (Unfavorable) Property Taxes 112,726,044 112,726,044 112,726,044 - Sales and Use Tax 89,556,472 89,556,472 96,561,473 7,005,001 Franchise Tax 12,102,129 12,102,129 11,202,353 (899,776) PILOT Taxes 1,562,041 1,562,041 1,562,041 - TOTAL TAXES 215,946,686 215,946,686 222,051,911 6,105,225 License and Permits 29,904,360 29,904,360 35,971,991 6,067,631 Intergovernmental 4,644,018 5,134,865 4,853,182 (281,683) Interest Income 1,271,153 1,271,153 1,271,153 - Fines & Forfeiture 3,474,455 3,474,455 3,374,595 (99,860) Parking Meter Collection 2,693,555 2,693,555 2,693,555 - Charges and Services 3,934,570 3,934,570 4,568,553 633,983 Miscellaneous Revenue 3,372,272 3,772,272 4,399,436 627,164 Interfund Reimbursement 22,032,892 22,032,892 21,707,813 (325,079) Transfers 21,079,600 22,587,644 22,337,645 (249,999) TOTAL W/OUT SPECIAL TAX 308,353,561 310,752,452 323,229,834 12,477,382 Sales and Use Tax - 1/2 cent 35,600,000 35,600,000 40,000,000 4,400,000 TOTAL GENERAL FUND 343,953,561 346,352,452 363,229,834 16,877,382 Including proposed changes for BA#7 and projected increases to revenue fund balance would be projected as follows for FY2022: Adjusted fund balance is projected to be at 25.67%. FOF GF Only TOTAL FOF GF Only TOTAL Beginning Fund Balance 6,625,050 82,617,126 89,242,176 12,114,190 104,171,780 116,285,970 Budgeted Change in Fund Balance 2,924,682 (7,810,302) (4,885,620) (2,879,483) (15,335,334) (18,214,817) Prior Year Encumbrances (3,733,743) (6,165,453) (9,899,196) (1,879,654) (10,259,789) (12,139,443) Estimated Beginning Fund Balance 5,815,989 68,641,371 74,457,360 7,355,053 78,576,657 85,931,710 Beginning Fund Balance Percent 14.51%23.16%22.13%18.22%24.71%23.98% Year End CAFR Adjustments Revenue Changes - - - - - - Expense Changes (Prepaids, Receivable, Etc.) - (5,676,583) (5,676,583) - (7,535,897) (7,535,897) Fund Balance w/ CAFR Changes 5,815,989 62,964,788 68,780,777 7,355,053 71,040,760 78,395,813 Final Fund Balance Percent 14.51%21.24%20.44%18.22%22.34%21.88% Budget Amendment Use of Fund Balance (1,000,000) (15,858,313) (16,858,313) BA#1 Revenue Adjustment - - - - BA#1 Expense Adjustment - - 5,138,235 5,138,235 BA#2 Revenue Adjustment - - 490,847 490,847 BA#2 Expense Adjustment - - (986,298) (986,298) BA#3 Revenue Adjustment - - - - BA#3 Expense Adjustment - (1,000,000) (1,000,000) (2,000,000) BA#4 Revenue Adjustment - - 1,508,044 1,508,044 BA#4 Expense Adjustment - - (4,242,779) (4,242,779) BA#5 Revenue Adjustment - - 400,000 400,000 BA#5 Expense Adjustment - - (400,000) (400,000) BA#6 Revenue Adjustment - - - - BA#6 Expense Adjustment - - (1,553,938) (1,553,938) BA#7 Revenue Adjustment - - (794,641) (794,641) BA#7 Expense Adjustment - - (843,298) (843,298) Change in Revenue 7,298,201 10,388,598 17,686,799 4,400,000 12,477,382 16,877,382 Fund Balance Budgeted Increase - - - - - - - - Adjusted Fund Balance 12,114,190 57,495,073 69,609,263 10,755,053 81,234,314 91,989,367 Adjusted Fund Balance Percent 30.21%19.40%20.69%26.65%25.55%25.67% Projected Revenue 40,095,707 296,422,894 336,518,601 40,359,137 317,980,599 358,339,736 2021 Projection 2022 Projection The Administration is requesting a budget amendment totaling $207,050,218.00 of revenue and expense of $13,188,157.00. The amendment proposes changes in eight funds, with one new FTE to help with cyber security. The amendment also includes the use of $843,298.00 from the General Fund fund balance. The proposal includes 25 initiatives for Council review. 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 2022 Seventh amendment to the Final Budget of Salt Lake City, including the employment staffing document, for Fiscal Year 2021-2022 In June of 2021, the Salt Lake City Council adopted the final budget of Salt Lake City, Utah, 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, 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 shall be, and the same hereby are adopted and incorporated into the budget of Salt Lake City, Utah, including the amendments to the employment staffing document described above, for the fiscal year beginning 2 July 1, 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 __________, 2022. ________________________ CHAIRPERSON ATTEST: ______________________________ CITY RECORDER Transmitted to the Mayor on __________________ Mayor’s Action: ____ Approved ____ Vetoed _________________________ MAYOR ATTEST: _______________________________ CITY RECORDER (SEAL) Bill No. _________ of 2022. Published: ___________________. Salt Lake City Attorney’s Office Approved As To Form Senior City Attorney Initiative Number/Name Fund Revenue Amount Expenditure Amount Revenue Amount Expenditure Amount Ongoing or One- time FTEs 1 Open Space Acquisition: Killyon Redrocks CIP - 700,000.00 One-time - 2 Cottonwood Park Bridge Rebuild GF - (195,000.00)One-time - 2 Cottonwood Park Bridge Rebuild GF - 195,000.00 One-time - 2 Cottonwood Park Bridge Rebuild CIP 195,000.00 195,000.00 One-time - 3 UDOT Pass-Through Funds - RAC Access Road CIP 1,000,000.00 1,000,000.00 One-time - 4 Withdrawn prior to transmittal 5 Road Cost Center Adjustments - Class C CIP - (611,749.00)One-time - 5 Road Cost Center Adjustments - Class C CIP - 611,749.00 One-time 6 Leonardo Flood Damage Repair GF - 300,000.00 One-time - 6 Leonardo Flood Damage Repair CIP 300,000.00 300,000.00 One-time - 7 Cyber Security Portfolio Expansion IMS 500,000.00 500,000.00 One-time - 7 Cyber Security Portfolio Expansion IMS 188,605.00 188,605.00 One-time - 7 Cyber Security Portfolio Expansion IMS 25,075.00 25,075.00 Ongoing 1.00 7 Cyber Security Portfolio Expansion GF - 713,680.00 1 Youth & Family, Salt Lake County Central City Damages Payment GF 37,892.00 37,892.00 One-time - 2 Withdrawn Prior to Transmittal 3 UTA Sponsored Routes - Encumbrance Carryforward GF - 184,259.00 One-time - 4 Fire - Wildland Deployment Reimbursements GF 653,571.00 653,571.00 One-time - 5 Fire - Other Reimbursements GF 21,896.00 21,896.00 One-time - 6 Remove Transfers for ARPA Funding GF (1,508,000.00) (1,508,000.00)One-time - 7 700S. Corridor Preservation Funds Reimbursement CIP 611,500.00 611,500.00 One-time - 8 Transfer to Sustainability GF - 440,000.00 One-time 9 Public Utilities Revenue Bonds Sewer 157,874,000.00 874,000.00 One-time 9 Public Utilities Revenue Bonds Water 42,234,000.00 234,000.00 One-time - 10 Police Budget Reallocation for Workers Compensation GF - (199,500.00)One-time - 10 Police Budget Reallocation for Workers Compensation GF - 199,500.00 One-time - 11 Budget Reallocation for CCT Supplies and Lease Improvements GF - (480,000.00)One-time - 11 Budget Reallocation for CCT Supplies and Lease Improvements GF - 480,000.00 One-time - 12 Central Business Improvement Area (CBIA) 2022 Budget Misc Special Serv 500,000.00 500,000.00 One-time - Fiscal Year 2021-22 Budget Amendment #7 Council ApprovedAdministration Proposed Section A: New Items Section D: Housekeeping Section C: Grants for New Staff Resources Section B: Grants for Existing Staff Resources 1 Fiscal Year 2021-22 Budget Amendment #7 Initiative Number/Name Fund Revenue Amount Expenditure Amount Revenue Amount Expenditure Amount Ongoing or One- time FTEs 13 Funding for Trailer Cameras Utilizing Attrition Savings GF - (383,160.00)One-time - 13 Funding for Trailer Cameras Utilizing Attrition Savings GF - 383,160.00 One-time - 14 Housing Trust Fund Transfer to RDA Housing - 2,800,000.00 One-time - 1 State of Utah, Governor's Office of Planning and Budget, Granary District Flood Plain Mitigation CIP 2,000,000.00 2,000,000.00 One-time - 1 State of Utah, Governor's Office of Planning and Budget, Granary District Flood Plain Mitigation Misc Grants 2,238,000.00 2,238,000.00 One-time - - Consent Agenda #5 1 National Renewal Energy Lab (NREL), Solar Energy Innovation Network (SEIN) Round 3 Multi-Stakeholder Team Misc Grants 166,979.00 166,979.00 One-time - Consent Agenda #6 2 Utah State Dept. of Public Safety, Bureau of Forensic Services, FY21 Paul Coverdell Forensic Science Improvement Grant Program Misc Grants 7,500.00 7,500.00 One-time - 3 Utah Department of Health - Bureau of Emergency Medical Services (EMS)grant, FY22 Per Capita Allocation Misc Grants 4,200.00 4,200.00 One-time - Total of Budget Amendment Items 207,050,218.00 13,188,157.00 - - 1.00 Initiative Number/Name Fund Revenue Amount Expenditure Amount Revenue Amount Expenditure Amount Ongoing or One- time FTEs Total by Fund Class, Budget Amendment #7: General Fund GF (794,641.00) 843,298.00 - - - Public Utilities: Sewer Sewer 157,874,000.00 874,000.00 - - - Public Utilities: Water Water 42,234,000.00 234,000.00 - - - Miscellaneous Grants Fund Misc Grants 2,416,679.00 2,416,679.00 - - - Housing Fund Housing - 2,800,000.00 - - - CIP Fund CIP 4,106,500.00 4,806,500.00 - - - Misc Special Service Districts Misc Special Serv 500,000.00 500,000.00 - - - IMS Fund IMS 713,680.00 713,680.00 - - 1.00 - - - Total of Budget Amendment Items 207,050,218.00 13,188,157.00 - - 1.00 Administration Proposed Council Approved Section I: Council Added Items Section F: Donations Section E: Grants Requiring No New Staff Resources Section G: Council Consent Agenda -- Grant Awards Administration Proposed Council Approved 2 Fiscal Year 2021-22 Budget Amendment #7 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) 986,298.00 2,000,000.00 4,242,779.00 400,000.00 370,072,912.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 18,118.00 127,844,389.00 Sewer Fund (FC 52)268,213,796 221,826.00 7,941.00 268,443,563.00 Storm Water Fund (FC 53)19,201,013 19,705.00 2,278.00 19,222,996.00 Airport Fund (FC 54,55,56)706,792,500 1,350,949.00 39,790.00 708,183,239.00 Refuse Fund (FC 57)24,713,505 36,538.00 4,109.00 24,754,152.00 Golf Fund (FC 59)9,697,417 19,649.00 88,749.00 1,802,257.00 11,608,072.00 E-911 Fund (FC 60)4,056,856 4,056,856.00 Fleet Fund (FC 61)28,090,576 18,999.00 112,646.00 423,258.00 28,645,479.00 IMS Fund (FC 65)24,302,487 219,193.00 135,492.00 24,657,172.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 1,522,743.00 11,151,215.48 3,447,000.00 45,233,127.24 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 26,165,000.00 58,015,423.00 CIP Fund (FC 83, 84 & 86)29,503,216 (150,753.00) 23,400,000.00 52,752,463.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 212,897.00 53,172,091.00 Total of Budget Amendment Items 1,755,009,505 7,688,537.76 2,559,683.00 2,000,000.00 67,605,134.48 3,847,000.00 1,838,709,860.24 3 Fiscal Year 2021-22 Budget Amendment #7 ^^ Total Through BA#5 ^^ BA #6 Total BA #7 Total ^^ Total Through BA#6^^ General Fund (FC 10)370,072,912.00 1,528,938.00 843,298.00 372,445,148.00 Curb and Gutter (FC 20)3,000.00 3,000.00 DEA Task Force Fund (FC 41)2,033,573.00 2,033,573.00 Misc Special Service Districts (FC 46)1,550,000.00 500,000.00 2,050,000.00 Street Lighting Enterprise (FC 48)5,706,761.00 5,706,761.00 Water Fund (FC 51)127,844,389.00 234,000.00 128,078,389.00 Sewer Fund (FC 52)268,443,563.00 874,000.00 269,317,563.00 Storm Water Fund (FC 53)19,222,996.00 19,222,996.00 Airport Fund (FC 54,55,56)708,183,239.00 708,183,239.00 Refuse Fund (FC 57)24,754,152.00 24,754,152.00 Golf Fund (FC 59)11,608,072.00 11,608,072.00 E-911 Fund (FC 60)4,056,856.00 4,056,856.00 Fleet Fund (FC 61)28,645,479.00 987,576.00 29,633,055.00 IMS Fund (FC 65)24,657,172.00 219,338.00 713,680.00 25,590,190.00 County Quarter Cent Sales Tax for 5,307,142.00 5,307,142.00 CDBG Operating Fund (FC 71)5,341,332.00 5,341,332.00 Miscellaneous Grants (FC 72)45,233,127.24 7,227,652.00 2,416,679.00 54,877,458.24 Other Special Revenue (FC 73)273,797.00 273,797.00 Donation Fund (FC 77)2,752,565.00 2,752,565.00 Housing Loans & Trust (FC 78)16,121,000.00 32,495.00 2,800,000.00 18,953,495.00 Debt Service Fund (FC 81)58,015,423.00 7,000,000.00 65,015,423.00 CIP Fund (FC 83, 84 & 86)52,752,463.00 1,013,616.75 4,806,500.00 58,572,579.75 Governmental Immunity (FC 85)2,958,756.00 2,958,756.00 Risk Fund (FC 87)53,172,091.00 53,172,091.00 - Total of Budget Amendment Items 1,838,709,860.24 18,009,615.75 13,188,157.00 - - - 1,869,907,632.99 BA#4, BA#5 and BA#6 remain open with the City Council. Budget Manager Analyst, City Council Contingent Appropriation 4 Salt Lake City FY 2021-22 Budget Amendment #7 Initiative Number/Name Fund Amount 1 Section A: New Items A-1: Open Space Acquisition Impact Fees $700,000.00 Department: Public Lands Prepared B: Kat Maus For Questions Please Include: Gregg Evans, Kristin Riker, Kat Maus, Lewis Kogan Public Lands is requesting an FY 2022 budget amendment for $700,000 in unallocated impact fees funding to acquire property to be preserved as open space. Details on the specific property will be discussed in a Council closed session meeting. A-2: Cottonwood Park Bridge Rebuild GF -$195,000.00 GF $195,000.00 CIP $195,000.00 Department: Public Lands Prepared By: Gregg Evans For Questions Please Include: Gregg Evans, Kristin Riker, Lee Bollwinkel The Public Lands Department is requesting a budget amendment of $195,000 to transfer general funds to POL CIP deferred maintenance fund. On November 6th, a windstorm upturned a large tree on top of the pedestrian bridge by Cottonwood Dog Park. This bridge is the main access for the dog park for residents over the Jordan River. A structural engineer has deemed that one side of the bridge can remain open to pedestrians to allow access. The engineer has also determined the bridge stability has been compromised to a level that it is unsafe for Parks vehicles to travel over this bridge, inhibiting maintenance vehicles from crossing. One of the two supporting braces on the bridge has been crushed and so the bridge can handle light pedestrian traffic but no vehicle use. The structural engineer determined that the cost of replacement of the brace is as much as the replacement of the bridge. Parks staff have barricaded the damaged side of the bridge to keep pedestrians away from the broken area for now. The bridge needs to be replaced as soon as possible as it is unclear how weather and use of the bridge may impact the bridge stability. Public Lands will continue to monitor the bridge safety until it can be replaced. Public Lands is proposing to use anticipated year-end savings as a source of funding for this bridge reconstruction. The funds would be transferred from Public Lands to the CIP Maintenance Fund. A-3: UDOT Pass-Through Funds – RAC Access Road CIP $1,000,000.00 Department: Public Services Prepared By: Dustin Petersen For Questions Please Include: Dustin Petersen, Matt Cassell In 2021, Utah State Legislature Senate Bill 3 allocated funds for a road connecting Rose Park Lane to Redwood Rd at 2600 North. An agreement between UDOT and the City has been executed for the City to receive the funds and to manage the project design and the funds have already been transferred. A-4: Withdrawn prior to transmittal A-5: Road Cost Center Adjustments – Class C CIP -$611,749.00 CIP $611,749.00 Department: Public Services Prepared By: Dustin Petersen For Questions Please Include: Dustin Petersen, Matt Cassell Public Services Engineering Division is requesting to revise the scope of Class C funds. Funds for 1300 East Projects - Cost Centers 8317035 in the amount of $39,051.55 and 8318154 in the amount of $572,697.11. Both of these cost centers are Class C funds. The 1300 East project was a partially federally funded project and has been completed two years ago but is Salt Lake City FY 2021-22 Budget Amendment #7 Initiative Number/Name Fund Amount 2 still not closed out by UDOT. Closeout is imminent. Staff is asking that these funds be moved from the 1300 East Class C cost centers to a new contingency Class C cost center. A-6: Leonardo Flood Damage Repair GF $300,000.00 CIP $300,000.00 Department: CAN Prepared By: Brent Beck For Questions Please Include: Brent Beck, Tammy Hunsaker, Shellie Petersen Flooding occurred at the Leonardo in July of 2021 due to a heavy rainstorm. The total anticipated cost of reconstruction is approximately $300,000. Real Estate Service will manage the reconstruction since the Leonardo is a city-owned building leased to a tenant. Funding will be transferred from the General Fund to a CIP Maintenance Fund cost center Real Estate Services utilizes for leased building repairs. A-7: Cyber Security Portfolio Expansion IMS $500,000.00 IMS $188,605.00 IMS $25,075.00 GF $713,680.00 Department: IMS Prepared By: Joseph Anthony For Questions Please Include: Joseph Anthony, Aaron Bentley, Mary Beth Thompson Salt Lake City is a major government organization that has a robust network with a vast array of valuable data and processes that are reliant on the network. This is a request to get the city's endpoint management upgraded due to current cyber security threats and a vast array of threats that are currently being seen throughout the industry. We are requesting $500,000 to secure a contract for a SIEM (Security Incident and Event Management) security suite to actively monitor and respond to security events ac ross the network that pose a risk to the city's network reliability. A SOC (Security Operations Center) will be created to mitigate and monitor the active threats against the network. We are also requesting an additional 75,000 for penetration testing and vulnerability scanning of our security posture, both internally and externally. Desktop/Laptop management expansion $65,800. The City’s Desktop Security solution needs additional licensing or a “true up”. Our current system has 2350 licenses, and we need to expand that to 3350 (1000 additional licenses). This software provides patch management to the primary devices (pcs and laptops) across the City. As Microsoft updates come out monthly (sometimes weekly) this software enables us to patch the devices across the network without having to touch every device individually. Security Suite additional software for desktops/laptops $47,805. This software is an expansion of the above desktop/laptop management software. It will allow us to tighten the security on these devices such as disabling USB connected peripherals, change administrative permissions for applications to install and run and allows enhanced control of the operating systems among other functionalities. To maintain these improvements an additional Cyber Security Engineer FTE will be needed. Annual maintenance will vary greatly based on the SIEM solution that is chosen but may be as much as $250,000 per year on an ongoing basis. Costs will initially be covered through a transfer from the general fund. Actual costs will be allocated across all funds based on usage. Salt Lake City FY 2021-22 Budget Amendment #7 Initiative Number/Name Fund Amount 3 Section B: Grants for Existing Staff Resources Section C: Grants for New Staff Resources Section D: Housekeeping D-1: Youth & Family, Salt Lake County Central City Damages Payment GF $37,892.00 Department: CAN Prepared By: Ken Perko For Questions Please Include: Ken Perko, Brent Beck, Blake Thomas, Orion Goff Youth and Family has partnered with Salt Lake County at the Central City Recreation Center since 2003 to provide youth and teen programs. Salt Lake City has provided staffing and purchased program supplies and furnishings while Salt Lake County has provided the space to operate the programs. In March, 2020 all in-person Youth and Family programming was halted. The County then contracted with the Salt Lake County Health Department to provide a space for homeless individuals who were Covid positive but did not need hospitalization. The health department moved out after a few months and the Center sat empty. Shortly thereafter, the Center was broken into and as a result sustained significant damage to the building and interior contents including a good portion of the equipment and furnishings that the City had paid for. This settlement payment of $37,892.00 is a reimbursement for the damaged equipment and supplies. D-2: Withdrawn Prior to Transmittal D-3: UTA Sponsored Routes – Encumbrance Carryforward GF $184,259.00 Department: Non-Departmental Prepared By: Sharon Mangelson For Questions Please Include: Sharon Mangelson, Mary Beth Thompson During encumbrance carry forwards Finance forgot to include the remaining encumbrance from FY 2021 in the amount of $184,259 to cover the contract cost. D-4: Wildland Deployment Reimbursements GF $653,571.00 Department: Fire Prepared By: Clint Rasmussen For Questions Please Include: Clint Rasmussen, Karl Lieb Personnel were deployed several times during the Summer of 2021 to assist in wildland firefighting. Beginning in July, SLCFD sent 6 individuals to Montana. Another crew of 3 were then sent to California in August and fulfilled a 2-week deployment. A third crew of 6 were then sent to swap them out at the end of August and continued wildland duties into September. All costs associated with these deployments will be reimbursed to Salt Lake City and will have a matching revenue offset budget. The Administration is asking the City Council to approve this request to offset personnel costs that include overtime, benefits, and backfill. This proposal will make the Fire Department whole as well as the General Fund. Expenses Montana Wildfire - July 2021 $270,921 California Wildfire - August 2021 $126,693 California Wildifire - Aug/Sept 2021 $255,957 Total Expense Incurred $653,571 D-5: Fire – Other Reimbursements GF $21,896.00 Department: Fire Prepared By: Clint Rasmussen Salt Lake City FY 2021-22 Budget Amendment #7 Initiative Number/Name Fund Amount 4 For Questions Please Include: Clint Rasmussen, Karl Lieb The Fire Department has provided several services in which it expects to receive a reimbursement including training backfill costs incurred on behalf of Utah Search and Rescue (USAR), Fire investigation overtime incurred on behalf of the Bureau of Alcohol, Tobacco, Firearms, and Explosives (ATF), and finally cost recovery efforts from negligent accidents/incidents. This will have a matching revenue offset budget. Utah Search and Rescue (USAR) Training/Backfill $2,936.37 Bureau of Alcohol, Tobacco, Firearms, and Explosives (ATF) Reimbursement $10,777.24 Cost Recovery: Incline Terrace Apartments - requested Fire Watch $6,432.00 Swift Water Rescue & Recovery on 12/11/21 $1,749.98 Total Reimbursement $21,895.59 D-6: Remove Transfers for ARPA Funding GF -$1,508,000.00 Department: Multiple Prepared By: John Vuyk For Question Please Include: John Vuyk, Mary Beth Thompson To ensure compliance with federal reporting all grant related expenses will remain in the grant fund. In BA#4 the Administration proposed transferring ARPA funds to the General Fund and the Fleet Fund. This amendment is to remove those transfers in the General Fund. D-7: 700 S. Corridor Preservation Funds Reimbursement CIP $611,500.00 Department: Public Services Prepared By: Dustin Petersen For Questions Please Include: Dustin Petersen, Jorge Chamarro, Holly Draney, Obreeae Hardy In March 2021 an administrative transmittal was sent to Council to enter into an Interlocal agreement with Salt Lake County for reimbursement of land purchase for the 700 South road construction project. Salt Lake City Council approved the Interlocal Agreement with Salt Lake County on April 20, 2021 to transfer the funds to the City. Funds of $611,500 have been received and are needed to complete the project. D-8: Transfer to Sustainability GF $440,000.00 Department: Non-Departmental Prepared By: John Vuyk For Questions Please Include: John Vuyk, Mary Beth Thompson During the FY2022 budget the administration and Council were briefed that a transfer of $440,000 would be made from the General Fund to the Sustainability Fund. This transfer was not included in the budget adoption, this amendment formalizes that transfer. D-9: Public Utilities Revenue Bonds Sewer $874,000.00 Water $234,000.00 Department: Public Utilities Prepared By: Mark Christensen For Questions Please Include: Mark Christensen, Laura Briefer, Lisa Tarufelli, Jamey West, Tamara Prue In order to adequately finance the construction of the new Water Reclamation Facility and to lock in a favorable interest rate, the Sewer and Water Utilities are planning to issue Revenue Bonds in June 2022 instead of two separate issuances in FY 2022 and FY 2023. Salt Lake City FY 2021-22 Budget Amendment #7 Initiative Number/Name Fund Amount 5 D-10: Police Budget Reallocation for Workers Compensation GF -$199,500.00 GF $199,500.00 Department: Police Prepared By: Shellie Dietrich For Questions Please Include: Shellie Dietrich, Mary Beth Thompson The Police Department is requesting a change in budget to cover the costs associated with a workers compensation settlement. The Department will utilize attrition from vacant positions that have not been able to fill to fund the expense. No additional budget is being requested. D-11: Budget Reallocation for CCT Supplies and Lease Improvements GF -$480,000.00 GF $480,000.00 Department: Police Prepared By Shellie Dietrich For Questions Please Include: Shellie Dietrich, Mary Beth Thompson In the FY 22 budget, the Police Department was allocated budget for 12 FTE's in the Social Work Program. Budget for uniform, equipment, supplies, IMS, Fleet was not included. Also in the Lease allocation for the Commu nity Connection Center leasehold improvement was not included. The Police Department is requesting a change in budget to cover the estimated costs of moving, leasehold improvements including IMS connectivity, WiFi, desks and cubicles for the new lease space, security, social work vehicles (2 shared), computers, supplies, radios and training. The Police Department will utilize attrition from the vacant positions that have not been able to fill to fund the needs of this program. No additional budget is being requested. D-12: Central Business Improvement Area (CBIA) 2022 Budget Misc Special Serv $500,000.00 Department: Economic Development Prepared By: Marina Scott / Jolynn Walz For Questions Please Include: Marina Scott, Jolynn Walz, Lorena Riffo-Jensen, Mary Beth Thompson The Administration is requesting the approval of a budget to collect new CBIA-22 assessment and pay contractual obligations to the Downtown Alliance Inc. The current assessment area CBIA-19 expires April 21, 2022. The City Council re-established a special assessment CBIA-22 for a three-year period to continue collection of assessment funds and allow the continuation of marketing, promotion, advocacy and other benefits to the City and downtown property owners and businesses. The new assessment ordinance was adopted and bills to the property owners will go out in the beginning of April 2022. D-13: Funding for Trailer Cameras Utilizing Attrition Savings GF -$383,160.00 GF $383,160.00 Department: Police Prepared By: Shellie Dietrich For Questions Please Include: Shellie Dietrich The Police Department is requesting a change in budget to utilize attrition savings to purchase 8 trailer cameras to provide coverage across all council districts. The Police Department will utilize attrition from vacant positions that have not been able to fill to fund the expense. No additional budget is being requested. D-14: Housing Trust Fund Transfer to RDA Housing $2,800,000.00 Department: Community and Neighborhoods Prepared By: Suzanne Swanson For Questions Please Include: Mary Beth Thompson, Suzanne Swanson, Mike Burns As requested by Council, budget amendment transfers the Housing Trust Fund loans and associated cash to the RDA. The $2,800,000 amount on the budget amendment is to move the cash in the current Housing Trust Fund cost centers to the Salt Lake City FY 2021-22 Budget Amendment #7 Initiative Number/Name Fund Amount 6 RDA. Approximately $20 million of loan receivables will also be transferred. As these are balance sheet accounts they do not affect budgets. Any remaining balance sheet items and cash that comes in will subsequently be transferred to the RDA. Section E: Grants Requiring No New Staff Resources E-1: State of Utah, Governor’s Office of Planning and Budget, Granary District Flood Plain Mitigation CIP $2,000,000.00 Misc Grants $2,238,000.00 Department: Finance Prepared By: Melyn Osmond For Questions Please Include: Melyn Osmond, Elizabeth Gerhart The Salt Lake City Department of Public Utilit ies received $2,000,000 for the Granary District Flood Plain Mitigation and Re-Mapping. Granary District Floodplain Mitigation and Re-Mapping is a phased planning, permitting, and capital improvement project to reduce the Federal Emergency Management Act (FEMA) designated 750 -acre Flood Hazard Area (FHA) concentrated in the Granary District and the adjacent stretch of the Jordan River. There are at least 1,182 properties partially or completely within the FHA. The flood hazard risk is substantial and limits new development. The project area is approximately 5,700 acres. The project under this Agreement will only cover Phase 1 for planning, design, and constructing water quality and storage facilities. Future Phase 2 will plan, study, and schedule additional capital improvements to maximize the FHA reduction as funding is secured from federal and state grants and/or Salt Lake City Department of Public Utilities (SLCDPU) capital funds. Phase 1 of the project is estimated to begin January 2023 and be completed by December 2026. This grant has a match requirement of $2,238,000. Salt Lake City identified $2 million from the first tranche of its American Rescue Plan Act State and Local Fiscal Recovery Funds. A public hearing was held on 12/7/21 on the grant application for this award. Section F: Donations Salt Lake City FY 2021-22 Budget Amendment #7 Initiative Number/Name Fund Amount 7 Section G: Consent Agenda Consent Agenda #5 G-1: National Renewal Energy Lab (NREL), Solar Energy Innovation Network (SEIN) Round 3 Multi- Stakeholder Team Misc Grants $166,979.00 Department: CAN (Youth & Family) Prepared By: Christopher Thomas/Melyn Osmond The Department of Sustainability applied for and received $166,979 in grant funding for the Solar Energy Innovation Network (SEIN) Round 3 Multi-Stakeholder Team grant program from the National Renewal Energy Laboratory. The funding will be used to increase uptake of commercial solar and/or storage in underserved communities through involvement from trusted stakeholders, community listening sessions, three to five solar and storage benefit case studies, and culturally relevant outreach tools and resources that address solar PV market barriers. Funding is allocated for: Travel $3,582 Three trips to Golden, Colorado for Team Lead (Senior Energy & Climate Program Manager) to participate in SEIN -hosted cohort peer exchange workings sessions and symposium. Contractual $163,397 Subrecipient contract to facilitate stakeholder convenings, guide case study assessments, and develop solar/storage resources, outreach materials, and deliverables. No match is required. A public hearing was held on 12/7/21 for this g rant application. Consent Agenda #6 G-2: Utah State Dept. of Public Safety, Bureau of Forensic Services, FY21 Paul Coverdell Forensic Science Improvement Grant Program Misc Grants $7,500.00 Department: Police Prepared By: Jordan Smith / Ann Garcia The police department is proposed as a sub-awardee in the Utah Department of Public Safety’s Bureau of Forensic Services (UBFS) application for the FY21 Paul Coverdell Forensic Science Improvement Grant Program. The state’s application includes $7,500 for the police department’s Crime Laboratory to attain 2022 annual accreditation fee through ANAB (ANSI National Accreditation Board) under ISO/IEC 17020:2012 requirement. The lab received their ANAB accreditation in June 2021. With the assessment fee and annual accreditation fee being paid with Coverdell 2020 funds, the costs for the first-year surveillance audit will be covered by this year's grant funds. A match is not required for this award. G-3: Utah Department of Health - Bureau of Emergency Medical Services (EMS)grant, FY22 Per Capita Allocation Misc Grants $4,200.00 Department: Fire Prepared By: Brittany Blair / Melyn Osmond ***Additional Funding of $4,200 has been awarded to this original grant bringing the total grant award amount to $14,450** This agenda item is to increase the funding budget. The Fire Department applied for and was awarded $10,250 of grant funding from the Utah Department of Health, Bureau of Emergency Medical Services. This funding will be used towards the purchase of a 12 -Lead Cardiac Monitor and medical supplies relating to the provision of Emergency Medical Services as funding permits. Section I: Council Added Items Impact Fees ‐ Summary Confidential Data pulled 03/16/2022 Unallocated Budget Amounts: by Major Area Area Cost Center UnAllocated Cash Notes: Impact fee - Police 8484001 524,230$ A Impact fee - Fire 8484002 808,770$ B Impact fee - Parks 8484003 13,256,676$ C Impact fee - Streets 8484005 7,147,853$ D 21,737,529$ Expiring Amounts: by Major Area, by Month 202107 (Jul2021)2022Q1 -$ -$ -$ -$ -$ 202108 (Aug2021)2022Q1 -$ -$ -$ -$ -$ 202109 (Sep2021)2022Q1 -$ -$ -$ -$ -$ 202110 (Oct2021)2022Q2 -$ -$ -$ -$ -$ 202111 (Nov2021)2022Q2 -$ -$ -$ -$ -$ 202112 (Dec2021)2022Q2 -$ -$ -$ -$ -$ 202201 (Jan2022)2022Q3 -$ -$ -$ -$ -$ 202202 (Feb2022)2022Q3 -$ -$ -$ -$ -$ Current Month 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 -$ -$ -$ -$ -$ 202305 (May2023)2023Q4 -$ -$ -$ -$ -$ 202306 (Jun2023)2023Q4 -$ -$ -$ -$ -$ 202307 (Jul2023)2024Q1 -$ -$ -$ -$ -$ 202308 (Aug2023)2024Q1 -$ -$ -$ -$ -$ 202309 (Sep2023)2024Q1 -$ -$ -$ -$ -$ 202310 (Oct2023)2024Q2 -$ -$ -$ -$ -$ 202311 (Nov2023)2024Q2 -$ -$ -$ -$ -$ 202312 (Dec2023)2024Q2 -$ -$ -$ -$ -$ 202401 (Jan2024)2024Q3 -$ -$ -$ -$ -$ 202402 (Feb2024)2024Q3 -$ -$ -$ -$ -$ 202403 (Mar2024)2024Q3 -$ -$ -$ -$ -$ 202404 (Apr2024)2024Q4 -$ -$ -$ -$ -$ 202405 (May2024)2024Q4 -$ -$ -$ -$ -$ 202406 (Jun2024)2024Q4 -$ -$ -$ -$ -$ Total, Currently Expiring through June 2021 0$ -$ -$ -$ 0$ FY 2023Calendar Month FY 2022FY 2024Fiscal Quarter E = A + B + C + D Police Fire Parks Streets Total Impact Fees Confidential Data pulled 03/16/2022 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 - Parks 8484003 -$ -$ -$ -$ Impact fee - Police 8484001 -$ -$ -$ -$ Eastside Precint 8419201 21,639$ 21,639$ -$ -$ ReimbExcessPoliceCapacity IF 8422800 1,898,497$ -$ 1,898,497$ -$ PolicePrecinctLandAquisition 8419011 239,836$ 239,836$ -$ -$ Impact fee - Streets Westside 8484005 -$ -$ -$ -$ Police'sConsultant'sContract 8419205 3,565$ -$ 3,565$ -$ A Public Safety Building Replcmn 8405005 14,068$ 14,068$ -$ 0$ Police Impact Fee Refunds 8421102 338,448$ -$ 68,100$ 270,347.94$ Fire Allocation Budget Amended Allocation Encumbrances YTD Expenditures Allocation Remaining Appropriation Values Description Cost Center Sum of Fire Allocation Budget Amended Sum of Fire Allocation Encumbrances Sum of Fire Allocation YTD Expenditures Sum of Fire Allocation Remaining Appropriation Fire refunds 8416007 82,831$ -$ -$ 82,830.52$ Fire Station #14 8415001 6,083$ 6,083$ -$ -$ Fire Station #14 8416006 44,612$ -$ -$ 44,612$ Fire Station #3 8415002 1,568$ -$ -$ 1,568$ Fire Station #3 8416009 565$ 96$ -$ 469$ Impact fee - Fire 8484002 -$ -$ -$ -$ Impact fee - Parks 8484003 -$ -$ -$ -$ Impact fee - Streets Westside 8484005 -$ -$ -$ -$ B Study for Fire House #3 8413001 15,700$ -$ -$ 15,700$ Fire'sConsultant'sContract 8419202 4,941$ 3,021$ 1,862$ 58$ Parks Allocation Budget Amended Allocation Encumbrances YTD Expenditures Allocation Remaining Appropriation Values Description Cost Center Sum of Parks Allocation Budget Amended Sum of Parks Allocation Encumbrances Sum of Parks Allocation YTD Expenditures Sum of Parks Allocation Remaining Appropriation JR Boat Ram 8420144 15,561$ 7,798$ 7,763$ -$ Warm Springs Off Leash 8420132 20,411$ -$ 20,411$ -$ Cnty #2 Match 3 Creek Confluen 8420426 88$ -$ 88$ -$ Fairmont Park Lighting Impr 8418004 49,752$ 12,155$ 37,597$ -$ Fisher Carriage House 8420130 1,098,764$ 875,563$ 223,201$ -$ Impact fee - Parks 8484003 -$ -$ -$ -$ Impact fee - Streets Westside 8484005 -$ -$ -$ -$ Park'sConsultant'sContract 8419204 4,857$ 2,596$ 2,219$ 42$ Folsom Trail/City Creek Daylig 8417010 146$ -$ -$ 146$ Cwide Dog Lease Imp 8418002 23,530$ 23,000$ -$ 530$ Rosewood Dog Park 8417013 1,110$ -$ -$ 1,110$ Jordan R 3 Creeks Confluence 8417018 1,570$ -$ -$ 1,570$ Waterpark Redevelopment Plan 8421402 224,247$ 148,037$ 74,564$ 1,646$ FY 9line park 8416005 21,958$ 17,010$ 2,692$ 2,256$ Jordan R Trail Land Acquisitn 8417017 2,946$ -$ -$ 2,946$ Rich Prk Comm Garden 8420138 12,795$ 4,328$ -$ 8,467$ Redwood Meadows Park Dev 8417014 9,350$ -$ -$ 9,350$ ImperialParkShadeAcct'g 8419103 10,830$ -$ -$ 10,830$ Park refunds 8416008 11,796$ -$ -$ 11,796.28$ IF Prop Acquisition 3 Creeks 8420406 58,014$ -$ 1,905$ 56,109$ C Parks Impact Fee Refunds 8418015 101,381$ -$ -$ 101,381.06 Fisher House Exploration Ctr 8421401 523,889$ 390,056$ 21,760$ 112,073$ UTGov Ph2 Foothill Trails 8420420 135,084$ 21,169$ 1,355$ 112,560$ Three Creeks West Bank NewPark 8422403 150,736$ -$ -$ 150,736$ 9Line Orchard 8420136 195,045$ 40,900$ -$ 154,145$ FY20 Bridge to Backman 8420430 722,920$ 402,239$ 161,343$ 159,338$ RAC Playground with ShadeSails 8422415 180,032$ -$ -$ 180,032$ Cnty #1 Match 3 Creek Confluen 8420424 388,477$ 14,066$ 109,534$ 264,877$ Trailhead Prop Acquisition 8421403 275,000$ -$ -$ 275,000$ Bridge to Backman 8418005 290,276$ 10,285$ 4,515$ 275,475$ Parley's Trail Design & Constr 8417012 327,678$ -$ -$ 327,678$ Historic Renovation AllenParK 8422410 420,000$ -$ -$ 420,000$ SLC Foothills Land Acquisition 8422413 425,000$ -$ -$ 425,000$ Wasatch Hollow Improvements 8420142 489,688$ 50,090$ 14,243$ 425,355$ Jordan Prk Event Grounds 8420134 431,000$ -$ -$ 431,000$ Jordan Park Pedestrian Pathway 8422414 510,000$ -$ -$ 510,000$ Green loop 200 E Design 8422408 610,000$ -$ -$ 610,000$ Marmalade Park Block Phase II 8417011 1,094,430$ 40,743$ 39,939$ 1,013,749$ SLCFoothillsTrailheadDevelpmnt 8422412 1,304,682$ -$ -$ 1,304,682$ Pioneer Park 8419150 3,343,904$ 66,409$ 162,614$ 3,114,882$ GlendaleWtrprk MstrPln&Rehab 8422406 3,200,000$ 17,400$ 21,800$ 3,160,800$ Streets Allocation Budget Amended Allocation Encumbrances YTD Expenditures Allocation Remaining Appropriation Values Description Cost Center Sum of Street Allocation Budget Amended Sum of Street Allocation Encumbrances Sum of Street Allocation YTD Expenditures Sum of Street Allocation Remaining Appropriation Trans Master Plan 8419006 13,000$ 13,000$ -$ -$ 9 Line Central Ninth 8418011 152,500$ 139,280$ 13,220$ -$ 500/700 S Street Reconstructio 8412001 32,718$ 16,691$ 16,027$ -$ 900 S Signal Improvements IF 8422615 70,000$ 70,000$ -$ -$ 700 South Reconstruction 8415004 2,449$ -$ 2,449$ -$ Trans Safety Improvements 8419007 95,653$ 20,953$ 73,999$ 700$ Transportation Safety Improvem 8417007 1,444$ -$ -$ 1,444$ Gladiola Street 8406001 16,109$ 13,865$ -$ 2,244$ Urban Trails FY22 IF 8422619 6,500$ -$ -$ 6,500$ Street'sConsultant'sContract 8419203 29,817$ 17,442$ -$ 12,374$ 500 to 700 S 8418016 96,637$ -$ 73,893$ 22,744$ Corridor Transformations IF 8422608 25,398$ -$ -$ 25,398$ 900 South 9Line RR Cross IF 8422604 28,000$ -$ -$ 28,000$ D 1700S Corridor Transfrmtn IF 8422622 35,300$ -$ -$ 35,300$ Complete Street Enhancements 8420120 35,392$ -$ -$ 35,392$ 200S TransitCmpltStrtSuppl IF 8422602 37,422$ -$ -$ 37,422$ Transp Safety Improvements 8420110 58,780$ 20,697$ -$ 38,083$ 1300 S Bicycle Bypass (pedestr 8416004 42,833$ -$ -$ 42,833$ Transportatn Safety Imprvmt IF 8422620 44,400$ -$ -$ 44,400$ Local Link Construction IF 8422606 50,000$ -$ -$ 50,000$ 400 South Viaduct Trail IF 8422611 90,000$ -$ -$ 90,000$ Neighborhood Byways IF 8422614 104,500$ -$ -$ 104,500$ Indiana Ave/900 S Rehab Design 8412002 124,593$ -$ -$ 124,593$ Bikeway Urban Trails 8418003 200,000$ -$ 12,484$ 187,516$ TransportationSafetyImprov IF 8421500 302,053$ 23,013$ 3,810$ 275,230$ Street Improve Reconstruc 20 8420125 2,250,220$ 513,372$ 1,353,539$ 383,309$ IF Complete Street Enhancement 8421502 625,000$ -$ -$ 625,000$ Traffic Signal Upgrades 8419008 221,688$ 156,078$ 65,159$ 450$ Traffic Signal Upgrades 8420105 300,000$ 300,000$ -$ -$ Traffic Signal Upgrades 8421501 875,000$ 67,474$ 19,589$ 787,937$ Total 26,384,700$ 3,810,784$ 5,505,369$ 17,068,547$ E = A + B + C + D TRUE TRUE TRUE TRUE 21,737,529$ 8484002 8484003 8484005 13,256,676$ 7,147,853$ $808,770 UnAllocated Budget Amount 8484001 524,230$