The URL can be used to link to this page

Home My WebLink AboutTransmittal - 2/14/2023ERIN MENDENHALL Mayor DEP %RTI= oP FIN_A CE CITY COUNCIL TRANSMITTAL Lis (Feb 14, 202315:21 MST) Lisa Shaffer, Chief Administrative Officer MARY BETH THOMPSON Chief Financial Officer Date Received: 02/14/2023 Date sent to Council: 02/14/2023 TO: Salt Lake City Council DATE: February 14', 2023 Darin Mano, Chair FROM: Mary Beth Thompson, Chief Financial Officer W7 SUBJECT: Budget Amendment #5 - Revised 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 FY2022-23 adopted budget. BUDGET IMPACT: GENERALFUND CIP FUND IMS FUND MISCELLANEOUS GRANTS FUND DONATION FUND DEBT SERVICE FUND TOTAL DEPARTMENT OF FINANCE POLICY AND BUDGET DIVISION 451 SOUTH STATE STREET, ROOM 238 PO BOX 145467, SALT LAKE CITY, UTAH 84114-5455 REVENUE EXPENSE 0.00 4,451,976.00 14,216,233.99 14,216,233.99 3,099,185.00 3,099,185.00 4,131,170.00 8,431,170.00 1,000,000.00 1,000,000.00 334,957.90 334,957.90 $22,781,546.89 $31,533,522.89 TEL 801-535-6394 BACKGROUND/DISCUSSION: Revenue for FY 2022-23 Budget Adjustments The following chart shows a current projection of General Fund Revenue for fiscal year 2023. Amended Variance Favorable Revenue FY22-FY23 Annual Budget FY22-23 Amended Budget Revised Forecast (Unfavorable) Property Taxes 125,012,927 125,012,927 125,012,927 - Sale and Use Taxes 105,050,018 105,050,018 108,269,378 3,219,360 Franchise Taxes 11,657,128 11,657,128 11,640,553 (16,575) Payment in Lieu of Taxes 1,638,222 1,638,222 1,638,222 243,358,295 243,358,295 246,561,080 3,202,785 Total Taxes Licenses and Permits 40,736,114 40,736,114 41,114,687 378,573 Intergovernmental Revenue 4,644,622 4,644,622 4,722,377 77,755 Interest Income 2,071,154 2,071,154 4,771,154 2,700,000 Fines 3,765,174 3,765,174 3,817,666 52,492 Parking Meter Collections 2,635,475 2,635,475 2,635,475 - Charges, Fees, and Rentals 4,432,794 4,432,794 4,887,307 454,513 Miscellaneous Revenue 3,438,710 3,438,710 3,857,347 418,637 Interfund Reimbursement 24,431,717 24,431,717 24,422,422 (9,295) Transfers 28,821,993 34,921,993 34,829,993 (92,000 358,336,048 364,436,048 371,619,508 7,183,460 Total W/O Special Tax Additional Sales Tax (1/2%) 44,364,490 44,364,490 45,614,490 1,250,000 402,700,538 408,800,538 417,233,998 8,433,460 Total General Fund The current projections for fiscal year 2023 projections continue to be positive. Sales tax is currently projected to exceed budget by $3.2 million while the sales tax associated with Funding Our Future is projected to exceed budget by $1.25 million. Building permits continue to stay strong projecting to be over budget by $378,573. Charges and services is projecting to be over budget because of strong numbers from police service revenues, while miscellaneous revenue shows an increase over budget due to an increase in fuel reimbursement costs. The City is also projecting a large surplus due to the rising interest rates. Fund balance has been updated with information from the 2022 ACFR, including proposed changes for BA#5 fund balance would be projected as follows for FY2023: Beginning Fund Balance Budgeted Change in Fund Balance Prior Year Encumbrances Estimated Beginning Fund Balance Beginning Fund Balance Percent Year End CAFR Adjustments Revenue Changes Expense Changes (Prepaids, Receivable, Etc.) Fund Balance w/ CAFR Changes Final Fund Balance Percent Budget Amendment Use of Fund Balance BA#1 Revenue Adjustment BA#1 Expense Adjustment BA#2 Revenue Adjustment BA#2 Expense Adjustment BA#3 Revenue Adjustment BA#3 Expense Adjustment BA#4 Revenue Adjustment BA#4 Expense Adjustment BA#5 Revenue Adjustment BA#5 Expense Adjustment BA#6 Revenue Adjustment BA#6 Expense Adjustment BA#7 Revenue Adjustment BA#7 Expense Adjustment Change in Revenue Change in Expense Fund Balance Budgeted Increase Adjusted Fund Balance Adjusted Fund Balance Percent Revenue _ F Only T��JJJJMFW GF Only JJJlF=L 4,171,780 116,�18,395,660 141,728,022 160,123,682 2,879,483 (15,335,334 (18,214,817 li2,1 (2,100,608 (20,736,262) (22,836,870) l,879,6 (10,259,7891. (12,139,443) (3,162,300 (17,260,90 (20,423,209) , 8,576,657 85,931,710 13,132,752 103,730,8 116,863,603 28° 22.33° 21.30% N 28.46° 28.58% (7,535,897 (7,535,897) 8,556,220 (8,556,220) 78,395,813 13,132,75 95,174,6 108,307,383 19.43% 29.6 26.11 26.49% 2,100,608 12,134,899 14,235,507 `18,3 112,371,078 jL9,927=5,452,679 IN L 27.86% 22.58 23.34% 1,499, 403,409,906 44, 364,530,648 408,895,138 Adjusted fund balance is projected to be at 23.34%. The Administration is requesting a budget amendment totaling $22,781,546.89 of revenue and expense of $31,533,522.89. The amendment proposes changes in six funds, with one FTE. The amendment also includes the use of $4,451,976.00 from the General Fund fund balance. The proposal includes twenty-one 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 M SALT LAKE CITY ORDINANCE No. of 2023 (Fifth amendment to the Final Budget of Salt Lake City, including the employment staffing document, for Fiscal Year 2022-2023) An Ordinance Amending Salt Lake City Ordinance No. 32 of 2022 which adopted the Final Budget of Salt Lake City, Utah, for the Fiscal Year Beginning July 1, 2022, and Ending June 30, 2023. In June of 2022, 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, 2022, and ending June 30, 2023, 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 any 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 2022. SECTION 2. Adoption of Amendments. The budget amendments, including any 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 any amendments to the employment staffing document described above, for the fiscal year beginning July 1, 2022 and ending June 30, 2023, in accordance with the requirements of Section 10-6-128 of the Utah Code. SECTION 3. Filingpies of the Budget Amendments. The said Budget Officer is authorized and directed to certify and file a copy of said budget amendments, including any 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 , 2023. ATTEST: CITY RECORDER Transmitted to the Mayor on Mayor's Action: Approved ATTEST: CITY RECORDER (SEAL) Bill No. of 2023. Published: CHAIRPERSON Vetoed MAYOR Salt Lake City Attorney's Office Approved As To Form �� Jaysen Oldroyd K Section A: New Items 1 Rapid Intervention Te 2 City and County Buildi Repairs - General Fun 2 City and County Buildi Repairs - General Fun 3 Fiber Conduit Phase 2 4 Withdrawn Prior to Tr 5 Public Safety Radio Co 6 Consulting for the Ent Systems 7 Lindsey Gardens CIP 7 Lindsey Gardens CIP 7 Lindsey Gardens CIP 8 Donation for the Ceme Bonuses for Police PO 9 Recruitment and Rete Bonuses for Police PO 9 Recruitment and Rete 10 Real Property Purchas 10 Real Property Purchas Main Street Pedestria 11 Design Study Tea Section B: Grants for Section Q Grants for N FY 2023 Budget Amendment #5 d Section D: Housekeeping 1 Interest on General Obligat Series 202o and Series 202 1 Interest on General Obligat Series 202o and Series 202 1 Interest on General Obligat Series 202o and Series 202 2 Withdrawn Prior to Trans 3 300 West Roadway Bond A 3 300 West Roadway Bond A 4 Insurance Funds for City a Building 5 IMS Budget for New GF Po Real Property Purchase - C 6 Associated with BA #4 Con Initiative 7 Move Cost of Issuance Cost Debt Service Fund Class 7 Move Cost of Issuance Cost Debt Service Fund Class 7 Move Cost of Issuance Cost Debt Service Fund Class 7 Move Cost of Issuance Cost Debt Service Fund Class an CI Section E: Grants Requirin 1 Treasury ERAP 2 Addition Section F: Donatio FY 2023 Budget Amendment #5 al ion Series 2019A, CIP 62,203.69 62,203.69 One-time 1 ion Series 2019A, CIP 222,627.19 222,627.19 One-time 1 ion Series 2019A 1 CIP 321,497.01 321,497•01 One-time mittal djustments CIP - (2,150,000.00) One-time djustments CIP 2,150,000.00 One-time County CIP 7,252,300.00 7,252,300.00 One-time sitions IMS 207,000.00 207,000.00 One-time - Budget ncil-Added CIP 3,567,564.00 3,567,564.00 One-time s from CIP to CIP (194,957.90) (194,957.90) One-time - s from CIP to Debt Service 194,957.90 194,957.90 One-time - s from CIP to CIP (140,000.00) (140,000.00) One-time - s from CIP to Debt Service 140,000.00 140,000.00 One-time - g No New Staff Resources�Mm� Resources Misc Grants 4,000,000.00 4,000,000.00 One-time FY 2023 Budget Amendment #5 Section G: Council Consent Agenda -- Grant Awards 1 Know Your Neighbor Grant Program, Open Misc Grants Consent Agenda #5 61,000.00 61,000.00 One-time Society Foundation - Salt Lake County Utah State Office of Education, Child and 2 Adult Care Food Program -Youth After Misc Grants 46,000.00 46,000.0o One-time School Programs Consent Agenda #6 1 U S Department of Justice, Community Misc Grants 24,170.00 24,170.00 One-time Oriented Policing Services (COPS), FY22 Community Police Development (CPD) Grant �ncil Added Items - Total of Budget Amendment Items 22,781,546.89 319533,522.89 - Administration Proposed Council Approved Expenditure Expenditure Ongoing or One - Initiative Number/Name Fund Revenue Amount Amount Revenue Amount Amount time FTEs Total by Fund ClasS, BudgetAmendment # General Fund GF - 4,451,976.00 CIP Fund CIP 14,216,233.99 14,216,233.99 IMS Fund IMS 3,o99,i85.00 3,099,185.00 Miscellaneous Grant Fund Misc Grants 4,131,170.00 8,431,170.00 Donation Fund Donation 1,000,000.00 1,000,000.00 Debt Service Fund Debt Service 334,957.90 334,957.90 Total of Budget Amendment Items 229781,546.89 31,533,.1j22.89 FY 2023 Budget Amendment #5 Current Year Budget Summary, provided for information only rY2022-2 a Budoet. Includina BudoetAmendments General Fund (FC io) 425,537,408 100,000 6,000,000 194,600 431,8329008 Curb and Gutter (FC 20) 3,000 3,000 DEA Task Force Fund (FC 41) 1,762,560 1,762,560 Mise Special Service Districts (FC 46) 1,700,000 1,700,000 Street Lighting Enterprise (FC 48) 4,302,222 4,302,222 Water Fund (FC 51) io8,i96,368 36,680,000 260,687 1459137,055 Sewer Fund (FC 52) 196,630,907 196,630,907 Storm Water Fund (FC 53) 13,476,733 13,476,733 Airport Fund (FC 54,55,56) 302,268,600 302,268,600 Refuse Fund (FC 57) 21,458,105 219458,105 Golf Fund (FC 59) 11,560,676 25,700 119586,376 E-91i Fund (FC 60) 3,925,000 39925,000 Fleet Fund (FC 61) 28,826,992 120,000 1,119,900 30,066,892 IMS Fund (FC 65) 30,523,167 2,627,420 3,099,185 36,249,772 County Quarter Cent Sales Tax for 9,600,000 9,600,000 Transportation (FC 69) CDBG Operating Fund (FC 71) 4,670,517 4,670,517 Miscellaneous Grants (FC 72) 34,158,918 2,749,584 2,517,995 8,103,151 4,131,170 51,66o,8i8 Other Special Revenue (FC 73) 300,000 300,000 Donation Fund (FC 77) 2,920,250 20,000 44,668 1,000,000 3,984,918 Housing Loans & Trust (FC 78) 16,217,000 16,217,000 Debt Service Fund (FC 81) 32,037,989 (2,951,727) 334,958 29,421,220 CIP Fund (FC 83, 84 & 86) 35,460,387 6,603,019 5,267,217 91,967,958 14,216,234 153,514,815 Governmental Immunity (FC 85) 3,964,523 2,000,000 500,000 6,464,523 Risk Fund (FC 87) 54,679,000 54,679,000 Total of Budget Amendment Items 1,344,180,322 11,592,603 51,009,880 101,347,689 229781,547 19530,912,041 4 FY 2023 Budget Amendment #5 Current Year Budget Summary, provided for information only FY2022-2,4 Budoet. Includina BudaetAmendments General Fund (FC io) 425,537,408 847,540 6,538,000 7,584,328 4,451,976 444,9593252 Curb and Gutter (FC 20) 3,000 3,000 DEA Task Force Fund (FC 41) 1,762,560 1,762,560 Misc Special Service Districts (FC 46) 1,700,000 1,700,000 Street Lighting Enterprise (FC 48) 5,757,825 5,757,825 Water Fund (FC 51) 132,752,815 36,680,000 260,687 16g,693,502 Sewer Fund (FC 52) 255,914,580 255,914,580 Storm Water Fund (FC 53) 18,699,722 18,699,722 Airport Fund (FC 54955,56) 384,681,671 688,8i8,000 1,073,499,671 Refuse Fund (FC 57) 24,952,672 3,035,700 27,988,372 Golf Fund (FC 59) 14,726,016 46,800 14,772,816 E-911 Fund (FC 60) 3,800,385 3,800,385 Fleet Fund (FC 61) 30,426,032 4,011,36o io,678,500 45,115,892 IMS Fund (FC 65) 30,523,167 2,782,449 3,099485 36,404,801 County Quarter Cent Sales Tax for 9,458,748 9,458,748 Transportation (FC 69) CDBG Operating Fund (FC 71) 4,958,433 49958,433 Miscellaneous Grants (FC 72) 26,614,153 2,749,584 2,517,995 8,481,711 8,431,170 48,794,613 Other Special Revenue (FC 73) 300,000 300,000 Donation Fund (FC 77) 287,250 20,000 44,668 1,000,000 1,35i,9i8 Housing Loans & Trust (FC 78) 25,779,253 100,000 25,879,253 Debt Service Fund (FC 81) 33,658,558 (2,951,727) 334,958 31,041,789 CIP Fund (FC 83, 84 & 86) 35,460,387 11,713,917 12,267,217 96,317,958 14,216,234 i6g,975,713 Governmental Immunity (FC 85) 3,169,767 2,000,000 500,000 5,669,767 Risk Fund (FC 87) 54,679,000 54,679,000 Total of Budget Amendment Items 1,525,6039402 21,442,401 688,8i8,000 61,583,580 123,200,706 31,533,523 2,452,181,612 Budget Manager Analyst, City Council 5 Salt Lake City FY2022-23 Budget Amendment #5 A�Section A: New Ite — A-1: Rapid Intervention Team Trailer GF $25,000.00 Department: Public Services For questions please include: Jim Cleland, Jorge Chammoro Prepared By: Jim Cleland The Rapid Intervention Team has been in operation since July, 2022. Improvements in the processes and procedures had led to the need for one more trailer. The team begins at 6:ooam and immediately go to the landfill. They begin their remediations at around 7:3oam and usually fill one trailer by mooam. By this time the wait at the SLC Landfill is approximately 2 hours. There is not enough time in the day for two trips to the landfill. With a second trailer they can fill both trailers by 2:00 PM and be ready to dump again in the morning. A second trailer outfitted is estimated at $25,000. A-2: City and County Building Earthquake Repairs — GF $2,300,000.00 General Fund Supplement CIP $2,300,000.00 Department: Public Services Prepared By: Dustin Petersen For questions please include: Dustin Petersen, Jorge Chammoro, City Engineer Public Services Engineering has been working with the City's insurance company (FM Global) on being fronted funding for repairs to the City and County Building. The Insurance company will only reimburse loss items as assessed on date of loss (March 202o). As with many city contracts the expenses have increased from the time of the event. Budget Amendment is requesting supplemental funds from the General Fund, to ensure contracts can be executed according to the full extent of repairs needed. Upon project completion, any unused funds will be returned to the General Fund. A current list of earthquake expenses is included as an attachment at the end of the document (Attachment #1) A-3: Fiber Conduit Phase 2 - 200 S IMS $242,185.00 Department: IMS Prepared By: Joseph Anthony For questions please include: Aaron Bentley, Joseph Anthony This is part of the 200 south roadway project. The projected costs are more than anticipated and budgeted. The council approved $5ok as part of the FY23 budget, but the actual costs based on the current engineering estimate are $292,185. Therefore, we are requesting an increase to the budget for the difference of $242,185. This will allow the city to improve our connection between city offices and the airport as well as pioneer park. A-4: Withdrawn Prior to Transmittal A-5: Public Safety Radio Cost Increases IMS $2,400,000.00 Department: IMS Prepared By: Joseph Anthony For questions please include: Aaron Bentley, Joseph Anthony Due to an updated quote from Motorola we are requesting an increase in the budget for the radios in the amount of 2.4 Million. This money will come from the IMS Fund balance. Please see the attached quote for the details (Attachment #2). Administration would like to request a straw poll on this item. The straw poll is being requested because it's imperative the Administration move forward on the contract process to avoid a further 8% increase in the cost of the radios. Salt Lake City FY2022-23 Budget Amendment #5 A-6: Consulting for the Enterprise Billing Systems IMS $250,000.00 Department: IMS Prepared By: Joseph Anthony For questions please include: Aaron Bentley, Joseph Anthony This request is for consulting services for Enterprise Billing systems for PUBS which is primarily used by Sustainability and Public Utilities. PUBS Needs to be replaced and the consultant will do an analysis of the City's needs and compare that to best practices and make a recommendation on where the city should be moving with regards to future decisions. Microsoft's current roadmap has our current solution mapped at the end of life by FY 2025. As such, we need to start finding a solution in this fiscal year to be able to have it in place by the beginning of FY 2025. The cost is based on an estimated 1,000 that will be needed for the consultation at $250 per hour. It is estimated to be a total of $250,000. A-7: Lindsey Gardens CIP Project Rescope CIP-$402,938.57 CIP-$56,421.90 CIP $459,36o•47 Department: Public Lands Prepared By: Kyle Shields For questions please include: Kristin Riker, Kyle Shields, Gregg Evans The Public Lands Department is requesting a Budget Amendment to revise the scope of work for existing CIP funded projects. The original scope of work for Lindsey Gardens Concessions had two projects (83-204o8, 86-194o8) that supported baseball concessions and public access. The department has struggled with estimates that would come in under budget for either project. The first project involved new construction as well as a new location for an aging concession stand and the second, a new path to link parking lot access to the middle field. As cost estimates rose, it was decided to keep the standing location, but remove it to build a new, smaller, and simpler version. Rapidly rising building costs brought this new construction bid in even higher than the original plan, and the second idea had to be rejected. With these concerns, Engineering, Parks, and the Avenues Baseball League decided that a facelift to the existing stand would be sufficient and ask that the scope of work be adjusted for both projects to spend the remaining funds as outlined below: - Concession stand renovation - Pedestrian path to middle field - Batting cage renovation - Covering dugouts with shade canopies - Trail from middle field to lower field The Avenues Baseball League supports the scope change as they are the ones that submitted the application in 2018. They have seen the costs associated with the building and path and asked if we could rescope the project to better use the funds that we have to improve all of the baseball fields at Lindsey Gardens. The following is a note from the league President: This note is to confirm that the Board of Directors of the Avenues Baseball League (ABL) has been informed of and approved the changes to the scope of work at Lindsey Gardens. As president of the league, I have been involved with you, Dat, Preston, and others to change the scope of work and establish new priorities given the anticipated cost overruns after getting the bids for the original scope of work. I have communicated the revised scope of work and the priority of the projects to the ABL board. The board agrees with the priorities that we have discussed and is eager to get on with the project. 2 Salt Lake City FY2022-23 Budget Amendment #5 Bart Cocke President, Avenues Baseball League According to the cost estimate for the scope of work above there isn't enough funding to do all of the items, but the list is prioritized and Public Lands will work through and make the funding go as far as possible. A-8: Donation for the Cemetery Donation $1,000,000.00 Department: Public Lands Prepared By: Gregg Evans For questions please include: Gregg Evans, Kristin Riker This amendment recognizes a donation to the City for cemetery maintenance. A-9: Bonuses for Police POST Training, Recruitment Misc Grants $4,300,000.00 and Retention GF $1,201,976.00 Department: Police Prepared By: Chief Mike Brown For questions please include: Chief Brown, Shellie Dietrich, Mary Beth Thompson The Salt Lake City Police Department (SLCPD) is committed to recruiting the best and brightest individuals to join its team to help provide a safe and thriving community. Today, law enforcement agencies across the country continue experiencing challenges recruiting and hiring qualified police candidates. To that end, the department is seeking funding to provide a hiring bonus of $1o,000 to lateral officers with a two-year commitment to employment with the department. Additionally, the department is seeking funding to provide a $5,000 bonus to qualified new SLCPD officers who have graduated from a self -sponsored, state -certified Utah Peace Officer Standards and Training (POST) academy. Finally, the department is seeking funding to provide a one-time retention bonus for current sworn members. The funding being requested for the above -mentioned bonuses this fiscal year includes $4.3 million from ARPA funds and $1.2 million from the general fund. A more detailed breakdown is contained in the table below. Total Retention and Hiring Program Cost Program Total Cost Estimate ARPA GF - 23 GF - 24 Lateral Hiring $ 367,000 $ 200,000 $ 83,500 $ 83,500 Academy Hiring $ 36,700 $ 36,700 $ - $ - Retention $ 6,142,112 $ 4,o63,300 $ 1,118,476 $ 96o,336 Total $ 6,545,812 $ 4,300,000 $ 1,201,976 $1,043,836 Further information is contained in the memo from Chief Brown that is attached at the end of the transmittal (Attachment #3) 3 Salt Lake City FY2022-23 Budget Amendment #5 A-io: Real Property Purchase GF $825,000.00 CIP $825,000.00 Department: Finance Prepared By: Mary Beth Thompson For questions please include: Mary Beth Thompson Funds are being requested in conjunction with the $3.56 million included as a Council -added item for property acquisition on budget amendment #4. A-11: Main Street Pedestrian Mall Conceptual Design GF $100,000.00 Study Department: Economic Development Prepared By: Lorena Rifoo-Jenson For questions please include: Lorena Riffo-Jenson, Mary Beth Thompson, Lisa Shaffer Salt Lake City's Department of Economic Development is seeking consultant services to develop a conceptual design study that will provide a vision, high level recommendations, and a path toward implementing the Main Street pedestrian mall. The consultant selected will be responsible for managing all aspects of the project outlined in this scope of work, including examining the current street conditions, creating planning and design recommendations (including emergency vehicle access, maintenance, utilities access, accessibility considerations, operations and maintenance needs, landscaping, and drainage, etc.), visualizing concept designs, public outreach, and calculating a cost analysis for each future phase of the project. Section B: Grants for Existing Staff Resources Section C: Grants for New Staff Resources Section D: Housekeeping D-1: Interest on General Obligation Series 2o19A, Series CIP 202o and Series 2021 $62,203.69 CIP $222,627.19 CIP $321,497.01 Department: Finance Prepared By: Brandon Bagley For questions please include: Brandon Bagley, Marina Scott, Mary Beth Thompson General Obligation Bond Series 2019A, was issued in October 2019 to fund reconstruction of City streets. Par value of the issued bonds was $22,840,000. At the time the bonds were issued the proceeds were deposited with the Trustee. Since then, unspent bond proceeds have earned interest. This amendment will adjust the budget to reflect actual proceeds available including interest earned from September 2021 through November 2022. General Obligation Bond Series 2020, was issued in September 2020 to fund reconstruction of City streets. Par value of the issued bonds was $17,745,000. At the time the bonds were issued the proceeds were deposited with the Trustee. Since then, unspent bond proceeds have earned interest. This amendment will adjust the budget to reflect actual proceeds available including interest earned from September 2021 through November 2022. 4 Salt Lake City FY2022-23 Budget Amendment #5 General Obligation Bonds Series 2021, was issued in November 2021 to fund reconstruction of City streets. Par value of the issued bonds was $20,600,000. At the time the bonds were issued the proceeds were deposited with the Trustee. Since then, unspent bond proceeds have earned interest. This amendment will adjust the budget to reflect actual proceeds available including accumulated interest from December 2021 through November 2022. 5 Salt Lake City FY2022-23 Budget Amendment #5 D-2: Withdrawn Prior to Transmittal D-3: 300 West Roadway Bond Adjustments CIP-$2,150,000.00 CIP $2,150,000.00 Department: Public Services Prepared By: Joshua Willie For question please include: Joshua Willie, Jorge Chamorro, Brandon Bagley, Mike Atkinson, Dustin Petersen Public Services Engineering Division is requesting to revise the second tranche of bond funds. The 300 West project - Cost Center 83-21201 is coming in under budget in the amount of $2,150,000.00. To ensure we utilize all of the bond funds before they expire, it is in our best interest to move these funds to Cost Center 83-21203 which is a Bond Contingency Cost Center. This will provide flexibility to use these funds on other approved bond projects within the bond's scope as funding is needed. The potential funding uses includes local street reconstruction candidates as listed below. • 60o S from goo W to 800 W at an initial estimated cost of $746,984 • 800 W from ARAPAHOE AV to 600 S at an initial estimated cost of $191,476 • 800 W from ARAPAHOE AV to 700 S at an initial estimated cost of $218,109 • goo S from noo E to 120o E at an initial estimated cost of $501,825 • BRYAN AVE from 800 E to goo E at an initial estimated cost of $310,153 • INDUSTRIAL RD from 2100 S to ASSOCIATED AV at an initial estimated cost of $401,643 • JEFFERSON ST from TERMINUS END to 1400 S at an initial estimated cost of $80,300 • KENSINGTON AVE from 800 E to goo E at an initial estimated cost of $308,933 • LIBERTY AVE from LAKE ST to 800 E at an initial estimated cost of $81,454 • ROOSEVELT AVE from 600 E to 70o E at an initial estimated cost of $239,128 2 Salt Lake City FY2022-23 Budget Amendment #5 D-4: Insurance Funds for City and County Building CIP $7,252,300.00 Department: Public Services Prepared By: Dustin Petersen For questions please include: Jorge Chamorro, Jim Cleland, City Engineer, Mary Beth Thompson, Dustin Petersen Public Services' Engineering division has been working with the City's Insurance carrier (FM Global) to receive funding for earthquake damages to the City and County building. The amount has been agreed to and is currently being processed. This amendment allows for the revenue to be recorded and the corresponding expense budget of $7,252,300. D-5: IMS Budget for New GF Positions IMS $207,000.00 Department: IMS Prepared By: Randy Hillier For questions please include: Joseph Anthony, Aaron Bentley, Randy Hillier, John Vuyk Budget was approved for a $207,000 general fund transfer to IMS for the cost of hardware for newly funded general fund positions, but the budget for the revenue coming in from the general fund and the expenditure on the hardware was inadvertently left out of the IMS budget. This amendment will rectify that mistake. D-6: Real Property Purchase — CIP Budget Associated CIP $3,567,564.00 with BA #4 Council -Added Initiative Department: Finance Prepared By: Randy Hillier For questions please include: Randy Hillier, John Vuyk In budget amendment #4 the Council added a general fund budget of $3,567,564 for a real property purchase. Typically, real property purchases are budgeted in a CIP cost center in order for the asset to be capitalized. This amendment will add the necessary CIP budget for the purchase. D-7: Move Cost of Issuance Costs from CIP to Debt CIP-$194,957.90 Service Fund Class Debt Service $194,957.90 CIP-$140,000.00 Debt Service $140,000.00 Department: Finance Prepared By: Brandon Bagley For questions please include: Brandon Bagley, Nancy Sanders, Mike Atkinson Per GASB 65, the cost of issuance for bonds is a non -capital expense. The cost of issuance budgets for General Obligation Bonds, Series 2022, and Sales and Excise Tax Revenue Bonds, Series 2022 C Federally Taxable were recorded in Fund Class 83 CIP. Fund Class 83 CIP is reserved for capital expense. The proper accounting treatment for cost of issuance expense budgets is to record them in Fund Class 81 Debt Service. This budget amendment proposes to move the approved cost of issuance non -capital budgets from Fund Class 83 CIP to Fund Class 81 Debt Service. Section E: Grants Requiring No New Staff Resources E-1: Treasury ERAP 2 Additional Resources Misc Grants $4,000,000.00 Department: CAN Prepared By: Tony Milner For questions please include: Tony Milner, Brent Beck, Ann Garcia This budget amendment is to recognize the City's additional allocation of the American Rescue Plan Act, Treasury Emergency Rent Assistance Program 2 (ERAP 2) funds, in the amount of $4,000,000, for the purpose of assisting in the stabilization and recovery of COVID-affected, low-income residential renters in Salt Lake City. 7 Salt Lake City FY2022-23 Budget Amendment #5 This budget amendment is separate from previous Council -approved City ERAP allocations: ERAP 1 Initial Award ($6,o67,033), ERAP i Additional Allocation ($3,000,000), ERAP i Additional Allocation ($5,000,000), and ERAP 2 Initial Award ($4,800,559.40)• To administer this additional ERAP 2 allocation the City will contract with the State of Utah, Department of Workforce Services' (DWS) online Utah Rent Relief application portal, https://rentrelief.utah.gov/. The City has previously and successfully contracted with DWS for the City's ERAP 1 and 2 funds. This budget amendment aligns with Treasury guidance on eligible activities and allowable percentage amounts for ERAP 2. Direct Client Assistance: Deposits, rent, utilities, rent arrears, and utility arrears. Housing Stability Services: Treasury guidance for eligible Housing Stability services include: Case management, Eviction prevention, Eviction diversion programs, Mediation between landlords and tenants, Housing counseling, Fair housing counseling, Housing navigators or promotoras that help households access ERA programs or find housing, Housing - related services for survivors of domestic abuse or human trafficking, Legal services or attorney's fees related to eviction proceedings and maintaining housing stability, Specialized services for individuals with disabilities or seniors that support their ability to access or maintain housing. A public competitive process would receive applications from providers for eligible Housing Stability services. All ERAP 2 funds must be obligated by September 30, 2025. section : onations Section G: Consent Agenda Consent Agenda #5 G-1: Know Your Neighbor Grant Program, Open Society Foundation - Salt Lake County Department: Mayor's Office Misc Grants $61,000.00 Prepared By: Kaletta Lynch / Ann Garcia The Mayor's Office of Equity & Inclusion received $61,000 in grant funding from Salt Lake County as a pass through from the County's application to the Operation Afghan Resettlement Support (OARS) program. The County was awarded $150,000 and is requesting to partner with Salt Lake City's Know Your Neighbor Program to assist the County in assimilating and welcoming the Afghan Refugees. The funding will be used to hire a new part-time program coordinator and not more than $1,000 for the program coordinator to travel for program related purposes. No match is required. A public hearing was held for this grant application on 1o/18/2022. 0 Salt Lake City FY2022-23 Budget Amendment #5 G-2: Utah State Office of Education, Child and Adult Misc Grants $46,000.00 Care Food Program - Youth After School Programs Department: CAN Prepared By: Kim Thomas /Ann Garcia The Youth & Family Division of Public Services applied for and received a continuation grant offered annually by the Utah State Office of Education, under the Child and Adult Care Food Program. These funds are available to youth service providers as part of the At -Risk Snack Program to reimburse for the costs of snacks served to children participating in the after -school programs. Central City Rec. Center, Fairmont Park, Glendale Library, Liberty Park, Northwest Rec. Center, Ottinger Hall, the Youth and Family Division Office, and Sorenson Campus will receive reimbursement directly through the State Office of Education and will receive up to $46,000, based on qualified snack expenses. SLC is reimbursed on a monthly basis and only qualified healthy snacks and meals served to children participating in the after -school enrichment/education activities during the afterschool program hours are eligible for reimbursement. A public hearing was held for the grant application on 10/4/2022. G-1: U S Department of Justice, Community Oriented Misc Grants $24,170.00 Policing Services (COPS), FY22 Community Police Development (CPD) Grant Department: Police Department Prepared By: Jordan Smith / Ann Garcia The police department applied for and received a $24,170 grant from the U.S. Department of Justice, Community Oriented Policing Services through the FY22 Community Policing Development Grant. The grant will fund an evaluation for the Promising Youth Project. The project will fund training and curriculum recommended by the evaluation contractor. The Police Department will develop an evaluation that will provide four major services: Evaluation of Program Fidelity, Evaluation of Program Outcomes, Training and Technical Assistance, and development of a Final Report. A Public Hearing was held on 07/19/2022 for the grant application on this award. Section I: Council Added Items E Salt Lake City FY2022-23 Budget Amendment #5 Attachment #1 Object Code Primary Second. Vendor Transaction Posting MKA M" Not Inv. Description Pm3e� RQnrRy Ref. ryRef. ID Vendor Name Description Set ID Check# Dale Debi[ Substantiate tl Total Su TOW Total Location Ventlor Inv. No. Date Description Other Professional&Ti N/A.N/A 10/07/20 TD530)9 CP21261300684 TERRACONCONSULTANTSINC TERRMONC0NSUCP100720 50011253 09/30/20 $2,396.50 $2,396.50 Salt Lake City&Terracon TD53079 04/W/30 EQdamage assessment. Other Professional&T.N/A.. N/A 10/21/20100520 09128 SALT LAKEARTS C0UNCI L TOO N SALT LAKE ART551, 0HNS10192050011629 10/21/20 $160,00 $160.1. A.Council??? SEE Arts Coucil SiAt City 10/05/20 Staff hours to pack up Sirter City C.11daio, Other Expenses N/A.N/A 05/20/21 JE05192021NV1))96: N/A.N/A BL02021-04249 JE0519W21H 05/Ol/21 $8,999.51 CAPITAL EXPENDITURE 2OA11E4 E)J 20338 IP1121111111 MODERN ROOFING& C0NSTRU MODERN R00FIN( CF081920 SW09915 OB/19/20 $12,ERCOD $12,864.00 Salt Lake City&Modern Conrt920-338 O8/07/10 Temp. egress. CAPITAL EXPENDITURE N/p..N/A 09/09/20 I. CP19109204628 GSBSPCDBAGSBSARCHITE[GSBSPC DBA CAPCPo90920 SW10484 08/31/20 $15,080.00 $15,080.00 Salt Lake City& GSBS N<hl[eRs 3811 04/30/20 EQ damage assessment. CAPITAL EXPENDITURE N/p..N/A 09/09/20 38151A CP19f09204628 GSBSPCDBAGSBSARCHITE(GSBSPC DBA CAFCPo90920 Wl0¢94 OB/31/20 $13, $13,55¢.00 Salt Lake City& GSBS Architects Os/31/20 Ex or sti,tlesign. CAPITAL EXPENDITU RE N/A.. N/A 11/09/20 38152A CP1910920121 GSBSPCDBAGSBSARCHITE(G585PCOBACAFCP090 N 5W10484 08/31/20 11,820.00 $],8]0.00 Salt Lake City& G1S11- itects 38152 05/31/20 Selective demolition. CAPITAL EXPENDITURE N/A.. N/A 09/09/20 38206A CP191o9204628 GSBSPCDBAGSB S ARCHITE(G S B S PC DBA CAFCPo90920 SW10484 08/31/20 '14,231.]0 $14,231.J0 Salt Lake City& GSBSArcM1i"s 38206 O6/30/20 Exterior stair design. CAPITAL EXPENDITU RE N/A.. N/A 11119120 38201 CP1910920121 GSBSPCDBAGSBSARCHITE( GSBSPC DBACAF CP0E.E20 SOON- 0.1120 $3,148.00 $3,148.00 Salt Lake City& GSBS Architects 38207 O6/30/20 Selective demolition. CAPITAL EXPENDITURE N/A.N/A 09/W/20 38342A CP1110920 621 GSBSPCDBAGSBSARCHITE(GSBSPCDBACAF CP090920 10010- 08/31/20 $4,066.20 $4,066.W Salt Lake City& GSBS Architect 38342 0]/31/20 EM iorstairdesign. CAPITAL EXPENDITURE N/A.N/A 09/W/20 38343A CP19109204628 GSBSPCDBAGSBSARCHITE(GSBSPC DBA CAFCPo90920 5W30484 08/31/20 $3,146.00 $3,148.00 Salt Lake Clty& GSBS Architects 38343 O7/31/20 Selective demolltipn. CAPITAL EXPENDITURE N/A..N/A O1/13/211 CP212)(1543)J9 STALLINGS CONSTRUCTION INC STALLI NGS C0NST C-1321 SW33642 11/31/20 $39SEDO $39,990.01 Salt Lake Clty&Stallings Constr I12/16/20 Selective dem0111ion. CAPITAL EXPENDITURE N/A..N/A Ol/20/21 10057 431J6 ENVIRO CARE INC ENVIRO CARE INC 0HNW1192160016042 01/20/21 $2,168.W $2,168.00 SLC Corp Bldg 4 Enviro Care, Inc 10057 W/17/20 Misc. Recontamination Materials&Supply CAPITAL EXPENDITU RE N/A.. N/A 02/10/21 38916 CP19109204628 GSBSPCDBAGSBSARCHITE(GSBSPCDB4CAFCW21021 SW14329 01/31/21 $1,5)4.W 11,SJ4 pp Sall Lake City& GSBS Archiect 38916 01/31/21 W1111ve demolition survey CAPITAL EXPENDITURE 20APREQ 6]] 111943629 MODERN ROOFING& C0NSTRU MODERN R00FIN( CP041421A SW3613) 04/1A/21 531,192.00 $31, 9 Plaza Parkin Modern Constr 20-385 02/12/21 EDd A9Prepalrs. CAPITAL EXPENDITU RE N/A.N/A 07/20/21 00000108: CP21316241]]3 M0CA SYSTEMS M0CASY5TEMSC<CPo]2021 50018875 06/30/21 $2,8W.W $2,850.00 Salt Lake Ci<y& MOCA Syzlems 10815 06/09/21 Project management. CAPITALEXPENDITURE 20APREQ E] FAC20045 CP20232943629 MODERN ROOFING& C0NSTRU MODERN R00FIN( CPo720I 5W38876 06/30/21 $8,]06.80 $8,J06.80 349 PIaza Parkin Modern C.n ,20-418 06/11/21 EQdamage repairs. CAPITAL EXPENDITURE 20APREQ 677 FAC2oo45:CP20232941621 MODERN ROOFING& C0NSTRU MODERN R00FIN( CPo)2021 500188)6 O6/30/21 $3,883.20 $3,883.20 349 R.A. Parkin Modern Constr 20-417 W/11/21 EQdamage repairs. ITHERMATERIAL&SL20ERTHQUAK 085 JE02053021BR0W"!N/A.N/A 1PMMAR20 IE0201211 Ol/Ol/21 ITHERMATERIAL&SL20ERTHQUAK 085 MEN 202 TK0SH"1N/A.N/A 1PM MAR20 1E02052021H Ol/Ol/21 $313.45 ITHERMATERIAL&SL20ERTHQUAK No JE0205202 RSEALN/A.N/A 1PMMAR20 JE02052021H Ol/Ol/21 $332.24 OTHER MATERIAL&SL WERTHQUAK 300 JE0WINI RSEAL"5: N/A.N/A 1PM MAR20 1E02052021H Ol/O1/21 $J6.26 OTHER MATERIAL&SL 20ERTHQUAK too IE0295202 [P19070358JW GRAINGER 9484572762 1E02052021H 5W066J8 01/01/21 $11, 510 $15.50 Facilities-2299 GRAINGER 94846J2]103/24/22 Steel come, braces. AL&"2oERTHQUAK SW MODERN ROOFING&C0NSTRu 200¢311 0)061 01/01/21 $1,325.00 51,325.00 Salt Lake City&Modern Co t,20-O,E31104/06/20 Seal damaged paste,. OTHER MATERIAL&SL 2oERTHQUAK Too 1Eo2D52D2 RBI RD"6': NIA-. N/A 1PM APR20 1E0N 202, Ol/Ol/21 $525.W OTHERMATERIAL&SL20ERTHQUAK 100 1E0N 202RB1Ro' 6.N/A.N/A 1PM APR20 IE0212021H O1101/21 $985.W OTHERMATERIAL&SL20ERTHQUAK NO JE0W 202FGIRD"6:N/A.N/A 1PM APR20 JE02052021H 01/Ol/21 $945.W ITHERMATERIAL&SL20ERTHQUAK IN JE0205202PR0CK"8N/A.N/A 1PM APR20 JE02052021H Ol/Ol/21 $5.28 ITHERMATERIAL&SLWERTHQUAK JOG JE0205302 PR0CK"8N/A.N/A 1PM APR20 JE02052021H Ol/Ol/21 $8.59 OTHER MATERIAL&SL 20ERTHQUAK 300 JE02052023O1W3301N/A.. N/A JE0511202OPDP 1E02052021H SW068W Ol/Ol/21 $11, 30 $11.31 Facilities- 2299 Commercial LIE 1010632-Cp3/35/30 BI-pin Quartz Socket&SOW FL36 Halogen OTHER MATERIAL &SL 2oERTHQUAK 101 1E0205202 CP115189 NO, N/A SH17215001 JE02052021H SWOJJ36 OS/O1121 $1,J20.00 $1,)20.00 Public Sery B10TIS SH1721501 p3/25/20 Elevato,repairs. 'THERAL &SL 20ERTHquAK rv/a.N/A ..21H"'13551 p1101121 $a1.o0 $61.00 FadIk1,s- 2299 Commercial Lig 101O49E-Cp3/24/20 A(tylic Lenses. Other Profes .I&Ti 2oERTHQUAK No 1 E02052o2 SIGNS FISE N/A.N/A IE05112020OHA 1E02052021H 01/01/21 5356.)2 Ocher Professional&Ti 20ERTHQUAN 100 1 E0LO5202 SIGNS RISE N/A.N/A 1E05112-IHA 1E02052021H O1/Ol/21 565C.)9 Other Professional&Ti 20ERTHQUAK 100 JE0N5202 BARRICAD N/A. N/A 1E051120MOHA JE0202021H O1/O1/21 $1,5)).91 Oth.,Professia Rl&T:2oERTHQUAK I.. JE0N5202 BARRICAD N/A.N/A JE051120MOHA JE02052021H OS/Ol/21 $4,310.06 Other Professional&T.N/A..N/A 051 2/21 20250101 CP19096336336 AR CHIPLEXGROUPLLC ARCH I PLEXGR0U 11-512 5001684) 05/12/21 $1,593.55 $1,593.55 Firesation No.!ARCHIPLEXGR(2025.01-D.03/08/211prthkecturalservices. Other Professional&T.N/A.. N/A 0511Z/21 20250102 CP19096336336 ARCHIPLEXGROUPLLC ARCHI PLEX GR0LE CP051231 SW16847 OS/,1/21 $1,E39,0. $1,639.08 Firesation No.! ARCHI PLEX GR(202501-0. 0/04/21 A1hkettu1lservices. BLDG&H0USINGREPI20ERTHQUAK No 1E0205202C1191369361. NONE INC 115J9))047 JE02052021H 50DOJ389 01/01/21 $508.5) $508,57 Salt Lake City&Kong Elevator 1.16E+09p4/16/20 Elevato11011. BLDG&HOUSING REPI20ERTHQUAK lOO JE0205202 CP3913E9 N/A..N/A 115J9815. 1EO2052021H 5WOJ5W 01/OS/21 $E25.91 $62591 Salt Lake City& Kone Elevator 1.16E+09 04/28/21 El...to,repai,s. Other Expenses 20APEEQ 100 1E0205202 CP1J902949191 INTERSTATE BARRICADES LLC IJ063 JE02052021H 5WO9615 01/01/21 $110.DO $110.00 BRIINing Intettateba,rl, 1]06305/31/20$Idewalkb i11desduetOEQd...vW Other Expenses PREQ too IE02o52o2 cP2o2329 rv/A..rv/A 2003309 SW09813 01/01/21 $31837.50 $3,63].50 SaltnLake city& Modern conztn 20-03-3W 03/20/20 Remove loose plaster. OtherExpenses 20APREQ 100 1E0W5202 CP202329 N/A.N/A 2006310 1E02052021H SW09813 ol/Ol/21 $271.W $2]5.01 Multiple(SLC&Modern Constn20-04-31004/02/1. Sea1damagedplaster. OtherExpenses 20APREQ 100 1E0205202 CP202329 N/A..N/A 2006314 1E02052021H SW09813 Ol/Ol/21 $690.00 $690.00 Salt Lake Clty&Modern Cons[n20-0431404/lfi/20 Respontlto aftershock. CAPITAL EXPENDITURE 20APFEQ 677 20... CP20232913621 MODERN ROOFING& C0N1111 MODERN R00FIN(CP091620 111011 09/16/20 121112.. $20,562.00 Fischer Mansion Modern Constr 20-344 09/03/20 EQdamagerepairs. CAPITAL EXPENDITU RE N/A..N/A O'/04/21325]96 CP3804)1500fi8 KP F F INC K P F F INC CAPITAI CP050621 60018535 OS/04/21 $7,460,00 $),460.00 SEE Eng Pa,king kpff 325,796. 0120/20 Engineering services. Printing -Public Notices N/A..N/A 09/OB/212021CI-12 526JJ SALT LAKETRIBUNEINC,THE SALTLAKETRIBUC0HDP090J20,60021812 0S/O8/21 $688.10 Printing -Public Notices N/A..N/A O'/7/212021CI-14 526JJ SALT LAKE TRIBUNE INC, THE SALT LAKE TRIBU F OHDPWO720', GW21812 09/06/21 $381.20 $381.20 Salt Lake City& The Salt Lake Ti 202111-141 pb/2J/21 I Notild to biddlll. CAPITAL EXPENDITURE 20ERTHQUAK lOO 39217PR9 CP39109204628 GSBSPCDBAGSBSARCHITE(GSBSPCDBACALCP080421 50019245 0)/31/21 $2,033.10 $2,11110 Salt Lake City&GSBS Architects 3921)p4/3p/21 Extedo, SUP', Repairs. RTHDUAl 100 GSBSPCDBAGSBSARCHITE(GSBSPCDBACAF CP080421 50019245 O;/31/21 $;259.00 52,259.00 Salt Lake City& GSBS-hkeIs 39352 O5/31/21 Extrio, SO,, Repairs. TURE THQUAK 100 0462E GSBSPCDBAGSBSARCHITE(GSBSPCDBACAFCP080421 SW19245 .131/21 $1,80).20 CAPITAL EXPENDITURE N/AR.N/A 09/O8/21 INV50000C CP21316241J]3 MOCASYSTEMS M0CASYSTEMSCICM90821 SOON— 08/31/21 $1,985.W Salt Lake city& MOCA Systems NATO 07/19/21 Project management. CAPITAL EXPENDITURE N/A..N/A 09/O8/21 INV-OOOOC CP21316241J]3 MOCASYSTEMS M0CA SYSTEMS C< CM90821 50020269 08/31/21 $1,3W.W :1,981.11 $1,350.00 Salt Lake City& MOCA SVsems 11044 08/20/21 P,o At management. CAPITAL EXPENDITURE N/A..N/A 09/29/2120-431-PR CP21341343629 MODERN ROOFING& C0NSTRU MODERN R00FIN(CP092921 SW20849 09/29/21 $SS,WO.W $55,000.00 Salt Lake City& Modern Constr 20-Ul 07/12/21 Stal„epairs. CAPITAL EXPENDITU RE 20ERTHQUAK 111 39539 CP39109204621 GSBSPCDBAGSBSARCHITE(GSBSPCDBICIICP112321 1122122 11/23/21 $1,W).20 $1,807.20 Sall Lake City& GSBS Architect 39539 07/31/21 EMerior5tair Repairs. CAPITAL EXPENDITURE 20ERTHQUAK 300 396W CP19109204628 GSBSPCDBAGSBSARCHITE(GSBSPC DBA CAP CP112321 SW22422 11/23/21 $1,W7.2O $1,807,20 Sall Lake City& GSBS Nchitects 39680 O./31/` EMerior5tair Repairs. CAPITAL EXPENDITURE 20ERTHQUAK 100 IS— CP19109204628 GSBSPCDBAGSBSARCHITE(GSBSPCDBACALCP112321 SOD22422 11/23/21 $1,W).20 $1,BOJ.20 Salt Lake Clty&GSBS Plchltec[s 3992910/31/21 Exte1ior5[aiI Repairs. CAPITAL EXPENDITUREN/p..N/A 12/O1/21 INV-OOXX CP21316241773 MOCASYSTEMS M0CA SYSTEMS Ct CP320121 SW22638 11/30/21 $2,250.. $3,250.00 Salt Lake City& MOCA Systems 1111J W/OB/21 Project management. EN/A..N/A 12/OII NV-OOOW CP21316241]]3 MOCA SYSTEMS M0CA SYSTEMS C<CP120121 11/30/21 $1,900.W $1,900 Salt Lake chY&MOCA Systems 1123310/13/21 Project management. EN/A..N/A 12/01/11 INV-o00W CP213I6241]]3 MOCASYSTEMS M0CASYSTEMSCt CP129121 5W22638 11/30/21 $1,150.00 $1,"Coa Salt Lake City&MOCA Systems 124M 11/12/21 Project management. CAPITAL EXPENDITURE 20ERTHQUAK 100 20-11 PR CP21341343fi29 MODERN ROOFING& C0NSTRU MODERN R00FIN(CP120]21 SW32M 11/30/21 $166,400,00 CAPITAL EXPENDITURE 20ERTHQUAK 100 4.015 CP1910920628 GSBSPCDBAGSBSARCHITE(GSBSPCDBACAFCPoSo522 SW23541 12/31/21 $903.60 CAPITAL EXPENDITURE FAC2W45 No JE02U 021NV38290N/A.N/A BLD2021-0)44] FS JE02142022H O1/O1/22 $1,429.13 CAPITAL EXPENDITU RE FAC20044 683 4010) CP22316204621 GSBSPCDBAGSBSARCHITE(G11SPCDBACAfC120S22 50024111 Ol/31/22 $1,'130.00 CAPITAL EXPENDITURE FAC2W44 683 40204 CP22376204628 GSBSPCDBAGSBSARCHITE( G S B S PC DBA CAP CPo20922 SW24511 01/31/22 $38,5)3.5) CAPITAL EXPENDITURE 20ERTHQUAK No 20 -484-PR CP21341343629 MODERN ROOFING& C0NSTRU MODERN R00FIN(CP03O822 50025385 02/28/22 $892W ,.W CAPITAL EXPENDITURE 2oERTHQUAK NO 000004011 CP22403241JJ3 MOCASYSTEMS MO CASYSTEMSC<CP033022 SW26020 03/30/22 $1,J)5.00 CAPITAL EXPENDITURE 20ERTHQUAK 100 00000402'CP22Q 2 41]]3 MOCASYSTEMS M0CA SYSTEMS CA CM33022 50026020 03/30/22 $1,025.W CAPITAL EXPENDITURE 20ERTHQUAK 100 402. CP19f09204628 65 BSPCDBAGSBSARCHITE(GSBSPCDBACAFCPo40622 500261)9 03/31/22 :13.60 CAPITAI EXPENDITURE 20ERTHQUAK 100 00000403E CP22403241]]3 MOCASYSTEMS M0CASYSTEMSCACP041322A 50026446 03/31/22 $9%DO CAPITAL EXPENDITURE FAC2W44 683 40332 CP22376204628 GSBSPCDBAGSB SARCHITE( G S B S PC DBA CAP CP0A1322A 5002640) 03/31/22 $51,S.GO CAPITAL EXPENDITURE FAEW44 683 40441 CP2237620628 G S B S PC DBA G S B SARCHITE( G S B S PC DBA CAP CPo41322A 5002640) 03/31/22 $9,80fi.95 CAPITAL EXPENDITURE 20ERTHQUAK 300 20-984-PR CP21341343629 MODERN ROOFING&C0NSTRU MODERN R00FIN(CPo50422A SW2J055 04/30/22 $113,381.25 CAPITAL EXPENDITURE 1111144 683 40530 CP223)6204621 GSBSPCCIA GSBSARCHITE( GSB S PC DBA CAP CP070622A SW29WB 0.0/22 $8,995.W $8,995.do Salt Lake City& GSBS Architect 40530 03/31/31 Seismic repairs. CAPITAL EXPENDITURE FAC20044 683 40670 CP223)6204628 GSBSPCDBAGSBSARCHITE(GSBSPC DBACAFCP0J0632A BW2908 06/30/22 $1b,643.50 116,643.10 Salt Lake City&GSBSArchltect 4067004/3G/22 Seismic repairs. CAPITAL EXPENDITUREFAC20p44 683 1EOGIS 2 N/A,. N/A Unrecorded Li1b.k JE0PI922MW 06/30/22 $30,380.98 $3p,3.. 9' Salt Lake City& GSBS Architect 40788 05/31/22 Seismic repair. FACNOPM 683 JEW19221 rv/A..rv/A Unrecorded Liabillt1E091922Mw 06/30/22 $27,247.50 $2J,24J.50 Salt Lake CRY& GSBS Architects J 06/30/22 Seismic repairs. Other ProfesziODnal&Ti N/A.. N/A 11/03/212025.01-0. CP19W6336R36 RCHIPLEX GROUP LLC ARCHIPLEX GR0UP CPIIDA21 SW21])6 30/31/21 $163.91 $163.91 HIPLEXGR(2025.E1-0'. 0)/02/21 Conzt. Docs Other Professional&Ti N/A..N/A 11/03/212.25.01-0CP19W6336336 ARCHIPLEX GROUP LLC ARCHIPLEX GROUP CP110321 5W21]J6 10/31/21 $1% $18.21 Firertation No.! ARCH I PLEX GR(2025D E,./15/21 Consl. Docs Other Professional&Ti O1/05/22 2025.01-0'. CP19W633633: AR CHIPLEXGROUPLLC ARCHI PLEX GR0UPC ED 0522 5W23506 12/31/21 $113.83 $113.83 Firertation No.!ARCHIPLEXGR(2025. 01-0'. 12/O6/21 Eldding/Pe itE,,g Other Professional&T.N/A.. N/A 02/11222021.01-01 CP1916336336 ARCHI PLEXGROUPLLC ARCHIPLEXGR0UPCPo20922 5W244)1 01/31/22 $102.44 $102.44 Firertation No.! ARCH IPLEX GR(2o25.01-O�TON/22 Bldding/Permiting Printing -Public Notices FAC2W45 l0o 2022CI-59 526JJ SALT LAKE TRIBUNE INC, SALT LAKE TRIBU NOHO]0520221fiW3005) 06/30/22 $549.50 $549.50 Fire Station119 The Sall Lake T,2021c15E!OG/I3/22 Notice to bidders. CAPITAL EXPENDITURE N/A.N/A 09/14/21 JEOSOEWI 8D1059-FN/A.N/A BLD2021-0)44J PI:1E0EDSW21A1 OS/25/21 $919.74 CAPITAL EXPENDITURE N/A..N/A 09/29/2139676PR1 CP19109204628 GSBSPCDBAGSBSARCHITE(GSBSPCDBACAPCPo92921 SW20814 09/29/21 $3,J80.00 $3,J80.00 Brine Shrimp W. GSBS Architects IS—G8/31/21 Archite 111ces. CAPITAL EXPENDITURE III RTHQUAK No 3980J C119109204628 G S R SPCDBAGS B SARCHITE(G S R S PC DBA CAF CP111721 5W22215 11/L7/2L $3,024.00 $3,02400 rive Shrimp W. GSBS Architects 39807 0/30/21 Arthltclservkc RE1/1-N/A 03/W/221117121 CP21311838515 IMADDOXCONSTRUCTIONLC MADD0XC0NSTR1CPo30822 5W253)8 02/28/22 $I),226.W $17,226.00 Salt Lake Acting Maddox Constr 1537429 W/29/21IEQrepaim. RE 20ERTHQUAK Too 403]0 CP19109204628 GSBSPCDRAGS BSARCHITE( G S B SPC DBACAFCM33022 5W25983 03/30/22 $J56.W $756.00 ire Shrimp W. G585 Architect 4037002/28/22 Archileclservicez. CAPITALEXPENDITURE N/A.N/A 04/13/22 6fi0314-6 CP2o199436298 HOGAN&ASSOCIATES CONSTRI HOGAN.-CIA CPo41322A 6W2JSW 03/31/22 $6,52A.W Sorenson MCC Hagan C.r SMCCN.. O4/o7/12 Provided imially, paid within SMCC project CAPITAL EXPENDITURE 20ERTHQUAK Too 40621 CP19109204628 GSBSPCDBA GSBSARCHITE( G S B S PC DBA CAP CP052522 5002]]16 05/25/22 1,,505.00 $8,505.00 Brine Shrimp Wa G585 Architects 4062104/30/22 Archltctservices. ENGINEER&ARCHITCIFAC2W44 975 1E080420201015DP-(N/A..N/A Engineenng Fees2:1EO8043O22A1 07/31/22 $3,12194 ENGINEER& ARCHITCI FACNN4 975 JE1014202PP220101',N/A.N/A Engineering Fees PIJE1O142022A1 09/W/22 $4,109120 CAPITAL EXPENDITU RE 2oERTHQUAK No OOOE(d 5 CP22403241773 MOCASYSTEMS M0CA-,IMSC{C12421 SW306W 0'/24/22 $1,665.00 $1,685.00 _ Salt Lake City& MOCA Systems 411141/11/12 Project management_ CAPITAL EXPENDITURE 20ERTHQUAK 100 00000406: CP22403241773 MOCA SYSTEMS M0CASYSTEMS C{ CP082422 SW306W 08/24/22 $1,OW.W :1,060.0p Salt Lake City& MID ASystems 40635 06/O7/22 Project management. CAPITAL EXPENDITURENILITHQUAl NO 0000040J! CP224032 A11773 MOCASYSTEMS M0CA SYSTEMS C< CPo82ALO SW306W 08/24/22 $2,6W.W� $2,EOC 00 Salt Lake City& MOCA Systems 40J52 OJ/12/22 Pr ject management. RTHQUAK 100 00000408E CP22403241]]3 MOCASYSTEMS M0CA SYSTEMS C< CM82422 0o3o6W 08/24/22 $2,9W.W $2,900.00 Salt Lake C11,I MOCASyslems 4as1 O8/04/22 Project manAR-em. CAPITAL EXPENDITURE FAC2044 683 409WR CP22376204628 GSBSPCDBAGSBSARCHITE(GSBSPCDBACAF CM90822 5W31125 08/31/22 $8,816.J) $8,816.]J Salt Lake Clt"GSBSArthit(:-.1FC RJ 08/16/22 Seismic repairs. CAPITAL EXPENDITURE FACNE04 683 411' CP223)6204621 GSBSPCDBAGSB SARCHITE( G S B S PC DBACAF CP110232A 5W3202 10/31/22 $8,3W.50 $8,380.50 Salt Lake City&GSBSArchite<t 4116508/31/22 Seizmic repairs. CAPITAL EXPENDITURE FAC2W44 683 41302 CP223)6204628 GSBSPCDBAGSB SARCHITE( G S E S PC DBA CAP CP110222A SW32W2 10/31/22 $1,932.0 $1,932.00 Salt Lake City&GSBSAPitects 41302 W/30/22 Seismic repairs. ENGINEER&ARCHITCI-2-1 9)5 JE08042020101SDP-(N/A.N/A Engineerng Fees 2:JE08042022A1 UJ/31/22 $1,634.51 ENGINEER&ARCHITCIFAC2W45 975 JE1014202PP220301',N/A.N/A Engineering Fees PI1E30142032AI 09/30/22 $3,081.55 Printing -Public Notices FAC2W45 IN 2022CI-61 11677 SALTLAKE TRIBUNE INC,THE 54T LAKE TRIBU N0Hp8012022I6W30833 08/03/22 $549,50 $549.SC Fire Station 0The SIR Lake Ti 2021d 59'W/13/22 Notice to bidders -rebid. CAPITAL EXPENDITURE 20ERTHQUAK No 41097 CP19109304628 GSBSPCDBA GSBSARCHITE( G S B S PC DBA CAP CM92822 50031549 09/28/22 $2,835DO $2,835.00 Brine Shrimp Wa GSBS Architects 41W7 08/31/22 ArchiteRservlces. 5951,312.94 $429,331.35 10 Salt Lake City FY2022-23 Budget Amendment #5 Billing Address: SALT LAKE CITY CORP 451 S STATE ST RM 235 SALT LAKE CITY UT, 84111 Customer: SALT LAKE CITY CORP Attachment #2 Quote Name: Salt Lake City - Public Safety Radio Equipment Quote Date: 2022-11-17 Expiration Date: 2022-12-09 Contract Name: 18015 - STATE OF UTAH 800 MHZ AR- 3841 Quote Number: QUOTE-1957361 Quote Created By: Walter Whately Area Sales Manager walter.whately@motorolasolutions.com (520)457-8604 Currency: USD Line # Item Number APX' 6500/Enh Series Description Fire Mobiles (Utah Bundle Package, $900 Trade -In Included) Quantity Unit List Price Ext. List Price Discount % Discount 1 M25URS9PWIBN APX6500 ENHANCED 7/800 MHZ MOBILE. 122 $3,253.00 $396,866.0 74.67% $2,428.9 $824.09 $100,538.9 1a G832AD ADD: SPKR 7.5W WTR RST APEX. 122 $67.00 $8,174.0 27.00% $18.0 $48.91 $5,967.02 lb GA00580AA ADD: TDMA OPERATION. 122 $495.00 $60,390.00 47.00% $232.6 $262.35 $32,006.7 1c G51AU ENH: SMARTZONE OPERATION APX6500. 122 $1,320.00 $161,040.0 47.00% $620.4 $699.60 $85,351.2 1d G67DT ADD: REMOTE MOUNT ES APXM. 122 $327.00 $39,894.0 47.00% $153.6 $173.31 $21,143.82 1e G78AT ENH: 3 YEAR ESSENTIAL SVC. 122 $176.00 $21,472.00 0.00% $0.0 $176.00 $21,472.00 if GA01606AA ADD: NO GPS/WI-FI ANTENNA NEEDED. 122 $0.00 $0.0 0.005 $0.0 $0.00 $0.00 1g G444AH ADD: APX CONTROL HEAD SOFTWARE. 122 $0.00 $0.0c 0.005 $0.0q $0.00 $0.00 1h G335AW ADD: ANT 1/4 WAVE 762-870MHZ. 122 $15.00 $1,830.00 47.005 $7.05 $7.95 $969.9 li G806BL ENH: ASTRO DIGITAL CAI OP APX. 122 $567.00 $69,174.0 47.005 $266.49 $300.51 $36,662.22 1i GA01670AA ADD: APX ES CONTROL HEAD. 122 $717.00 $87,474.0 47.005 $336.99 $380.01 $46,361.22 lk W22BA ADD: STD PALM MICROPHONE APX. 122 $79.00 $9,638.0 47.005 $37.13 $41.87 $5,108.1 11 Q629AK ENH: AES ENCRYPTION AND ADP. 122 $523.00 $63,806.0 43.005 $224.89 $298.11 $36,369.42 1m G361AH ENH: P25 TRUNKING SOFTWARE APX. 122 $330.00 $40,260.0 47.005 $155.1C $174.90 $21,337.8 APX- 6500 / Enh Series Fire Mobiles for FSA (Utah Bundle Package, $900 Trade -In Included) 2 M25URS9PWIBN APX6500 ENHANCED 7/800 MHZ MOBILE. 15 $3,253.00 $48,795.0 74.675 $2,428.91 $824.09 $12,361.35 2a G832AD ADD: SPKR 7.5W WTR RST APEX. 15 $67.00 $1,005.0 27.005 $18.09 $48.91 $733.65 2b G66BF ADD: DASH MOUNT 02 APXM. 15 $138.06 $2,070.0 27.005 $37.26 $100.74 $1,511.1 2c GA00580AA ADD: TDMA OPERATION. 15 $495.00 $7,425.0 47.005 $232.65 $262.35 $3,935.25 2d G51AU ENH: SMARTZONE OPERATION APX6500. 15 $1,320.00 $19,800.0 47.005 $620.40 $699.60 $10,494.30 2e G78AT ENH: 3 YEAR ESSENTIAL SVC. 15 $176.00 $2,640.0 0.005 $0.00.$176.00 $2,640.00 2f GA01606AA ADD: NO GPS/WI-FI ANTENNA NEEDED. 15 $0.00 $0.0 0.005 $0.0q $0.0 $0. 2g GA00804AA ADD: APX 02 CH (GREY). 15 $541.00 $8,115.0 27.00% $146.0 $394.93 $5,923.95 2h G444AH ADD: APX CONTROL HEAD SOFTWARE. 15 $0.00 $0.0 0.00% $0.0 $0.00$0. 2i G335AW ADD: ANT 1/4 WAVE 762-870MHZ. 15 $15.00 $225.0 47.00% $7.0 $7.95 $1$9.25 2j G806BL ENH: ASTRO DIGITAL CAI OP APX. 15 $567.00 $8,505.0 47.001 $266.4 $300.51 $4,507.65 2k W22BA ADD: STD PALM MICROPHONE APX. 15 1 $79.001 S1,185.0(.47.009' $37.11 $41.87 $628.05 11 Salt Lake City FY2022-23 Budget Amendment #5 21 G843AH ADD: AES ENCRYPTION AND ADP. 15 $523.0 $7,845.0 47.00% $245.8 $277AS $4,157.8 2m G361AH ENH: P25 TRUNKING SOFTWARE APX. 15 $330.0 $4,950.0 47.00% $155.1 $174.9C $2,623.5 APX- 6000 Series Fire Portables with AES Encryption (Utah Bundle Package, $700 Trade -In Included) 3 H98UCD9PW5BN APX60007/800 MHZ MODEL 1.5 13 $3,213.0 $41,769.00 64.79% $2,081.5 $1,131.43 $14,708.3 3a QA05570AA ALT: U-ION IMPRES 2 IP68 3400 MAH. 13 $110.0 $1,430.0 27.00% $29.7 $803C $1,043.9 3b Q361AR ADD: P259600 BAUD TRUNKING. 13 $330.0 $4,290.0 43.00% $141.9 $188.1c $2,445.3 3c H38BT ADD: SMARTZONE OPERATION. 13 $1,320.0 $17,160. 43.00% $567.6 $752AC $9,781.2( 3d Q58AL ADD: 3Y ESSENTIAL SERVICE. 13 $121.0 $1,573.0 0.00% $0.0 $121.0 $1,573.00 3e QA00580AC ADD: TDMA OPERATION. 13 $495.0 $6,435.0 43.00% $212.8 $282.1 $3,667.95 3f QA01768AA ENH: ENHANCED ZONE BANK. 13 $83.00 $1,079.0 27.00% $22.4 $60.5 $787.67 3g Q806BM ADD: ASTRO DIGITAL CAI OPERATION. 13 $567.0 $7,371.0 43.00% $243.8 $323.1 $4,201.47 3h Q629AK ENH: AES ENCRYPTION AND ADP. 13 $523.0 $6,799.0 43.00% $224.8 $298.1 $3,875.4? 4 NNTN8863A CHARGER, SINGLE -UNIT, IMPRES 2, 3A, 100 13 $169.5 $2,204.2E 26.81% $45.41 $124.1 $1,613.3C Standalone Items 5 PMNN4486A BATT IMPRES 2 LIION R IP673400T. 13 $179.3 $2,330.9 27.00% $48.41 $130.8 $1,701.57 6 PMMN4099CL AUDIO ACCESSORY -REMOTE SPEAKER 13 $142.5f $1,853.2E 27.00% $38.4 $104.0 $1,352.91 APX- 6000 Series Fire Portables Non-XE (Utah Bundle Package, $700 Trade -In Included) 7 H98UCD9PW5BN APX60007/800 MHZ MODEL 1.5 131 $3,213.0 $420,903.0 64.79% $2,081.5 $1,131.4 $148,214.71 7a G843AH ADD: AES ENCRYPTION AND ADP. 131 $523.0 $68,513. 47.00% $245.83 $277.1 $36,311.82 7b QA05570AA ALT: U-ION IMPRES 2 IP68 3400 MAH. 131 $110.0 $14,410. 27.00% $29.70 $80.3 $10,519.3C 7c Q361AR ADD: P259600 BAUD TRUNKING. 131 $330.0 $43,230.00 43.00% $141.9 $188.1 $24,641.1C 7d H38BT ADD: SMARTZONE OPERATION. 131 $1,320.0 $172,920.0 43.00% $567.6 $752.4 $98,564.4C 7e Q58AL ADD: 3Y ESSENTIAL SERVICE. 131 $121.0 $15,851.0c 0.00% $0.0 $121.0 $15,851.00 7f QA00580AC ADD: TDMA OPERATION. 131 $495.0 $64,845. 43.00% $212.8 $282.1 $36,961.65 7g QA01768AA ENH: ENHANCED ZONE BANK. 131 $83.00 $10,873.00 27.00% $22.4 $60.5 $7,937.25 7h Q806BM ADD: ASTRO DIGITAL CAI OPERATION. 131 $567.0 $74,277.00 43.00% $243.8 $323.1 $42,337.85 8 NNTN8863A CHARGER, SINGLE -UNIT, IMPRES 2, 3A, 100 131 $169.5 $22,212.3E 26.81% $45.4 $124.1 $16,257.1C Standalone Items 9 PMNN4486A BATT IMPRES 2 LIION R IP673400T. 131 $1793C $23,488.3C 27.00% $48.4 $130.85 $17,146.55 10 PMMN4099CL AUDIO ACCESSORY -REMOTE SPEAKER 131 $142.56 $18,675.3E 27.00% $38.49 $104.0 $13,633.17 APX- 6000 Series Fire Portables XE for Wild Fire Ops. (Utah Bundle Package, $700 Trade -In Included) 11 H98UCD9PW5BN APX60007/800 MHZ MODEL 1.5 36 $3,213.00 $115,668.00 62.79% $2,017.3 $1,195.6 $43,044.12 Ila G843AH ADD: AES ENCRYPTION AND ADP. 36 $523.00 $18,828.00 47.00% $245.81 $277.15 $9,978.84 llb Q361AR ADD: P259600 BAUD TRUNKING. 36 $330.0 $11,880.0c 41.00% $1353C $194.7 $7,009.2C llc QA02006AA ENH: APX6000XE RUGGED RADIO. 36 $880.0 $31,680.00 41.00% $360.8C. $519.2 $18,691.2C 11d Q58AL ADD: 3Y ESSENTIAL SERVICE. 36 $121.0 $4,356.0 0.00% $0.0 $121.0 $4,356.00 Ile QA00580AC ADD: TDMA OPERATION. 36 $495.0 $17,820.DC 41.00% $202.9 $292.0 $10,513.8C llf QA0176W ENH: ENHANCED ZONE BANK. 36 $83.00 $2,988.0 27.00% $22.4 $60.5 $2,181.24 11g H38BT ADD: SMARTZONE OPERATION. 36 $1,320.0 $47,520. 41.00% $541.2 $778.8 $28,036.8C 11h QA01427AB ALT: IMPACT GREEN HOUSING. 36 $28.00 $1,008.0 27.00% $7.5 $20. $735.84 Ili Q806BM ADD: ASTRO DIGITAL CAI OPERATION. 36 $567.0 $20,412.DC 41.00% $232.4 $334.5 $12,043.0£ 12 PMNN4547A BATT IMPRES 2 UION TIA4950 R IP68 36 $203.0 $7,308.0 27.00 $54.8 $148.1 $5,334.84 13 NNTN8863A CHARGER, SINGLE -UNIT, IMPRES 2, 3A, 100 36 $169.5 $6,1.' 26.81% $45.4 $124AC $4,467.6 Standalone Items 14 PMMN4107C AUDIO ACCESSORY -REMOTE SPEAKER 1 36 1 $594.Oq $21,384.Oq 27.001 $160.3 $43162 $15,610.3 12 Salt Lake City FY2022-23 Budget Amendment #5 FLASHport Series Flashes for Fire 15 T8010A ANALOG 3600 TRUNKING. 1 $0.0 $0.0c 0.00% $0.0c $0.0 $0.00 15a GA00894AB ENH: ANALOG 3600 TRUNKING TO 9600 1 $721.0 $721.0 27.00% $194.6 $526.3 $526.33 15b UA00083AA ADD: SOFTWARE LICENSE ONLINE 1 $0.0 $0.0c 0.00% $0.0c $0.0 $0.00 15c GA00580AC ENH: UPGRADE TO TDMA. 1 $569.0 $569.0 27.00% $153.61 $415.3 $415.37 FLASHport Series Flashes for Fire 16 T7905A ANALOG 3600 TRUNKING. 1 $0.0 $0.0C 0.00% $0.0 $0.0 $0.00 16a QA03216AB ENH: ANALOG 3600 TRUNKING TO 9600 1 $721.0 $721.0 27.00% $194.6 $526.3 $526.33 16b UA00083AA ADD: SOFTWARE LICENSE ONLINE 1 $0.0 $0.0C 0.00% $0.0 $0.0c $0.00 16c QA00580AE ENH: TDMA OPERATION. 1 $569.0 $569.0 27.00% $153.6 $415.3 $415.37 FLASHport Series Flashes for Fire 17 T7697A DIGITAL SMARTZONE. 1 $0.0 $0.0c 0.005, $0.0c $0.0c $0.00 17a UA00083AA ADD: SOFTWARE LICENSE ONLINE 1 $0.0 $0.0c 0.00% $0.0c $0.0c $0.00 17b GA00580AC ENH: UPGRADE TO TDMA. 4 $569.0 $2,276.0 27.00% $153.6 $415.3 $1,661.4E FLASHport Series Flashes for Fire 18 T7664A DIGITAL SMARTZONE. 1 $0.0 $0.0c 0.00% $0.0 $0.0 $0.00 18a QA01768AD ENH: ENHANCED ZONE BANK. 13 $95.0q $1,235.0 27.00% $25.6 $69.3 $901.5E 18b UA00083AA ADD: SOFTWARE LICENSE ONLINE 1 $0.0 $0.0c 0.00% $0.0 $0.0 $0.00 18c QA00580AE ENH: TDMA OPERATION. 13 $569.0 $7,397.0 27.00% $153.6 $415.3 $5,399.81 FLASHport Series Flashes for Fire 19 T7664A DIGITAL SMARTZONE. 1 $0.0 $0.0c 0.005, $0.0 $0.0 $0.00 19a QA01768AD ENH: ENHANCED ZONE BANK. 20 $9S.0c $1,900.0 27.00% $2S.61 $69.3 $1,387.00 19b UA00083AA ADD: SOFTWARE LICENSE ONLINE 1 $0.0 $0.0c 0.00% $0.0 $0.0 $0.00 19c QA00580AE ENH: TDMA OPERATION. 20 $569.0 $11,380. 27.00% $153.6 $415.3 $8,307.4C FLASHport Series Flashes for Fire 20 T7664A DIGITAL SMARTZONE. 1 $0.0 $0.0c 0.00% $0.0 $0.0 $0.00 20a QA01768AD ENH: ENHANCED ZONE BANK. 8 $95.00 $760.0 27.00% $25.6E $69.3 $554.8C 20b QA00580AE ENH: TDMA OPERATION. 8 $569.0 $4,552.0 27.00% $153.6 $415.3 $3,322.9E FLASHport Series Flashes for Fire 21 T7664A DIGITAL SMARTZONE. 1 $0.0 $0.0c 0.005, $0.0c $0.0 $0.00 21a QA01768AD ENH: ENHANCED ZONE BANK. 10 $95.00 $950.0 27.00% $25.6 $69.3 $693.5C 21b UA00083AA ADD: SOFTWARE LICENSE ONLINE 1 $0.0 $0.0c 0.00% $0.0 $0.0 $0.00 21c QA00580AE ENH: TDMA OPERATION. 10 $569.0 $5,690.0 27.00% $153.6 $415.3 $4,153.7 FLASHport Series Flashes for Fire 22 T8012A 9600 OR 3600 SINGLE SYSTEM DIGITAL 1 $0.0 $0.0c 0.00% $0.0c $0.0 $0.00 22a UA00083AA ADD: SOFTWARE LICENSE ONLINE 1 $0.0 $0.0c 0.005, $0.0c $0.0 $0.00 22b GA00580AC ENH: UPGRADE TO TDMA. 8 $569.0 $4,552.0 27.00% $153.6 $415.3 $3,322.9E KVL 5000 Encryption Keyloader for Police 23 T8476B KVL 5000. 1 $6,000.0 $6,000.0 27.005 $1,620. $4,380.01 $4,380.00 23a CA00182AW ADD: AES ENCRYPTION SOFTWARE. 1 $0.0 $0.0 0.005 $0.0c $0.0 $0.06 23b CA03467AA ADD: NORTH AMERICA MICRO USB 1 $0.0 $0.0 0.005 $0.0 $0.01 $0.00 23c CA03358AA ADD: ASTRO 25 MODE. 1 $0.0 $0.01 0.005 $0.0 $0.01 $0.00 24 HKN61828 CABLE KEYLOADING ADAPTER CGAI. 2 $196.0 $392.0 20.005 $39.2 $156.8 $313.6( 25 WPLN6904A ASSY:KIT,KEYLOAD CABLE. 2 $118.8 $237.6 27.005 $32.0 $86.7 $173.44 26 PMNN4549A BATTIMPRES2 UION 2925T. 2 $80.0 $160.0 27.005 $21.6 $58.4 $116.8C 27 TKN8531C CABLE, KEYLOAD. 2 $311.4 $622.8 20.005 $62.2C $249.1 $498.3( After Market Encryption Upgrades AES for Police 28 T7936A IAPX UCM UPGRADE CD. 1 $57.5C 557.5 26.99% $15.5 $41.9 $41.9 28a CA00182AR ADD: AES ENCRYPTION SOFTWARE. 100 $696.Oq $69,600. 27.00° $187.9 $508.04 $50,808.0 13 Salt Lake City FY2022-23 Budget Amendment #5 After Market Encryption Upgrades AES for Police 29 T7936A APX UCM UPGRADE CD. 1 $57.5 $57.5 26.99 $15.5 $41.9 $41.9£ 29a CA00182AR ADD: AES ENCRYPTION SOFTWARE. 100 $696.0 $69,600. 27.00% $187.9 $508.0 $50,808.0C After Market Encryption Upgrades AES for Police 30 T7936A APX UCM UPGRADE CD. 1 $57.5 $57.5 26.99° $15.5 $41.9 $41.9£ 30a CA00182AR ADD: AES ENCRYPTION SOFTWARE. 65 $696.0 $45,240. 27.00% $187.9 $508.0 $33,025.2C Standalone Items 31 RMN5070A DESKTOP MIC (GCAI). 15 $185.7 $2,786. 27.00% $50.16 $135.6 $2,034.00 32 7012074001 BRACKET,BRACKET, WORKSTATION. 30 $3.6 $108.0 20.00% $0.72 $2.8 $86AC 33 NNTN8844A CHARGER, MULTI -UNIT, IMPRES 2, 6-DISP, 43 $1,420.2 $61,068. 27.00% $383.4E $1,036.7 $44,580.2E APX- 6500 / En Series Police Mobileswith AES (Utah Bundle Package, $900 Trade -In Included) 34 M25URS9PWIBN APX6500 ENHANCED 7/800 MHZ MOBILE. 568 $3,253.0 $1,847,704.0 74.67% $2,428.91 $824.0 $468,083.12 34a G66BF ADD: DASH MOUNT O2 APXM. 568 $138.00 $78,384.00 27.00% $37.26 $100.7 $57,220.32 34b GA00580AA ADD: TDMA OPERATION. 568 $495.0 $281,160.0 47.00% $232.6E $262.3 $149,014.8C 34c G51AU ENH: SMARTZONE OPERATION APX6500. 568 $1,320.0 $749,760.0 47.005 $620.41 $699.6 $397,372.8C 34d G78AT ENH: 3 YEAR ESSENTIAL SVC. 568 $176.00. $99,968. 0.005 $0.0 $176.0 $99,968.00 34e IGA01606AA ADD: NO GPS/WI-FI ANTENNA NEEDED. 568 $0.0 $0.0c 0.005 $0.0 $O.Oi $0.00 34f B18CR ADD: AUXILIARY SPKR 7.5 WATT APX. 568 $66.0 $37,488. 47.005 $31.0 $34.9 $19,868.64 34g G843AH ADD: AES ENCRYPTION AND ADP. 568 $523.0 $297,064.0 47.005 $245.8 $277.1 $157,443.92 34h GA00804AA ADD: APX 02 CH (GREY). 568 $541.0 $307,288.0 27.005 $146.0 $394.9 $224,320.24 34i G444AH ADD: APX CONTROL HEAD SOFTWARE. 568 $0.0 $0.0c 0.005 $0.0 $0.01 $0.06 34j G335AW ADD: ANT 1/4 WAVE 762-870MHZ. 568 $15.0 $8,520.0 47.005 $7.05 $7.9 $4,515.6C 34k G806BL ENH: ASTRO DIGITAL CAI OP APX. 568 $567.0 $322,056.0 47.00% $266.4S $300.5 $170,689.6£ 341 W22BA ADD: STD PALM MICROPHONE APX. 568 $79.0 $44,872.00 47.00% $37.1 $41.8 $23,782.1E 34m G361AH ENH: P25 TRUNKING SOFTWARE APX. 568 $330.00 $187,440.00 47.00% $155.1C $174.9 $99,343.2C APX- 6500 / Enh Series Police Mobiles with AES (Utah Bundle Package, $900 Trade -In Included) 35 M25URS9PW1BN APX6500 ENHANCED 7/800 MHZ MOBILE. 44 $3,253.0 $143,132.0 74.67% $2,428.9 $824.0 $36,259.9E 35a G90AC ADD: NO MICROPHONE NEEDED APX. 44 $0.0c $0.0c 0.00% $0.00 $0.0 $0.00 35b G72AD ADD: APX 03 HANDHELD CH. 44 $1,041.0 $45,804. 27.00% $281.0 $759.9 $33,436.92 35c GA00580AA ADD: TDMA OPERATION. 44 $495.00 $21,780. 47.005 $232.6 $262.3 $11,543.4C 35d G51AU ENH: SMARTZONE OPERATION APX6500. 44 $1,320.0 $58,080. 47.005 $620.4 $699.6 $30,782.4C 35e G67DR ADD: REMOTE MOUNT 03 APXM. 44 $327.0 $14,388. 27.005 $88.2 $238.7 $10,503.24 35f G78AT ENH: 3 YEAR ESSENTIAL SVC. 44 $176.0 $7,744.0 0.005 $0.0 $176.0 $7,744.00 35g GA01606AA ADD: NO GPS/WI-FI ANTENNA NEEDED. 44 $0.0 $0.0c 0.005 $0.00 $0.01 $0.00 35h B18CR ADD: AUXILIARY SPKR 7.5 WATT APX. 44 $66.0 $2,904.0 47.005 $31.02 $34.9 $1,539.12 35i G843AH ADD: AES ENCRYPTION AND ADP. 44 $523.0 $23,012.00 47.005 $245.81 $277.1 $12,196.3E 35j G444AH ADD: APX CONTROL HEAD SOFTWARE. 44 $0.0 $0.00 0.005 $0.00 $0.00 $0.00 35k G335AW ADD: ANT 1/4 WAVE 762-870MHZ. 44 $15.0c $660.0 47.005 $7.05 $7.9 $349.8C 351 G806BL ENH: ASTRO DIGITAL CAI OP APX. 44 $567.0 $24,948. 47.005 $266AS $300.51 $13,222.44 35m G361AH ENH: P25 TRUNKING SOFTWARE APX. 44 $330.0 $14,520.00 47.0W $155.1C $174.9C $7,695.6C APX- 6000 Series Police Portables with AES (Utah Bundle Package, $700 Trade -In Included) 36 H98UCF9PW6BN APX6000700/800 MODEL 2.5 PORTABLE. 628 $3,595.0 $2,257,660.0 63.47°/ $2,281.8 $1,313.2C $824,689.6 36a QA05570AA ALT: U-ION IMPRES 2 IP68 3400 MAH. 628 $110.0 $69,080. 27.0091 $29.7 $803C. $50,428. 36b 4361AR ADD: P259600 BAUD TRUNKING. 628 $330.0 $207,240.0 44.00� $145.2 $184.8 $116,054.4 36c H388T ADD: SMARTZONE OPERATION. 628 $1,320. $$828,960.0 44.001 $580.8 $739.2 $464,217.6 36d Q58AL ADD: 3Y ESSENTIAL SERVICE. 628 $121.0 S75,988.0C 0.009, $0.0 $121.0 $75,988.0 14 Salt Lake City FY2022-23 Budget Amendment #5 36e QA00580AC ADD: TDMA OPERATION. 628 $495.0 $310,860.0 44.005 $217.8 $277.2 $174,081.6C 36f Q806BM ADD: ASTRO DIGITAL CAI OPERATION. 628 $567.0 $356,076.0 44.005 $249.4 $317.5 $199,402.5E 369 H122BR ALT: 1/4 WAVE 7/8 STUBBY (NAR6595). 628 $26.00 $16,328. 27.005 $7.02 $18.9 $11,919.44 36h Q629AK ENH: AES ENCRYPTION AND ADP. 628 $523.0 $328,444.0 44.005 $230.1 $292.8 $183,928.64 37 NNTN8863A CHARGER, SINGLE -UNIT, IMPRES 2, 3A, 100 628 $169.5 $106,483.6 26.815 $45.4 $124.1 $77,934.8C Standalone Items 38 PMNN4486A BATT IMPRE52 LII0N R IP673400T. 628 $179.3 $112,600.4 27.005 $48.4 $130.8 $82,198.92 39 NTN2570C ASSEMBLY ACCESSORY WIRELESS ACCY KIT 628 $350AE $220,088.8f 27.005 $94.6 $255.8 $160,667.52 40 PMMN4099CL AUDIO ACCESSORY -REMOTE SPEAKER 628 $142.56 $89,527. 27.00% $38.49 $104.0 $65,355.9E 41 HLN6875A BELT CLIP 3INCH. 628 $14.04 $8,817.1 26.99% $3.79 $10.2 $6,437.0( After Market Encryption Upgrades AES for legacy Fire Radios 42 T7936A APX UCM UPGRADE CD. 1 $57.50 $57.5C 26.99% $15.52 $41.9 $41.9E 42a CA00182AR ADD: AES ENCRYPTION SOFTWARE. 42 $696.00 $29,232. 27.00% $187.92 $508.0 $21,339.3E APX- Radio Management Radio Management for loading flashes and programming radios (tethered) 43 T7914A RADIO MANAGEMENT ONLINE. 1 $0.0 $0. 0.00 $0.0 $0.0 $O.GC 43a UA00049AA ADD: RADIO MANAGEMENT LICENSES 1622 $110.0 $178,420. 227.00Y $29.7 $0.0 $0. 44 PSVO1S01987A RADIO MANAGEMENT (RM) TRAINING 2 $1,500.0 $3,000.0 0.00° 50.0 $0.0 $0. 45 1 Incentive 1. Additional trade-in incentive of 1I -$311,400.0 -$311,400.Oq 0.009 $0.0 -$311,400.0q $311,400.0 The Utah BUNDLE PACKAGE PRICING includes $900 Trade -In for Mobile Radios and $700 Trade -In for Portable Radios and is including In the pricing discount line item. We have given an extra $200, 3000+Volume Trade -In as well (Item 43). Quote and Pricing valid until December 30, 2022 and contingent on $5,000,000.00 or more purchased by this date Pricing includes all discounts and trade-in incentives on a one for one trade in basis and trade in concession Motorola Contact: Walter Whately, Area Sales Manager, 520-457-8604, walter.whately@motorolasolutions.com 15 Net Total $5,598,775.01 Estimated Tax $0.00 Estimated Freight $0.00 Grand Total $5,598,775.01 Salt Lake City FY2022-23 Budget Amendment #5 Attachment *3 CONFIDENTIAL From: Chief Mike Brown To: City Council Re: Hiring Bonuses and Retention Bonuses — Salt Lake City Police Department Summary: The Salt Lake City Police Department (SLCPD) is committed to recruiting the best and brightest individuals to join its team to help provide a safe and thriving community. Today, law enforcement agencies across the country continue experiencing challenges recruiting and hiring qualified police candidates. To that end, the department is seeking funding to provide a hiring bonus of $1o,000 to lateral officers with a two-year commitment to employment with the department. Additionally, the department is seeking funding to provide a $5,000 bonus to qualified new SLCPD officers who have graduated from a self -sponsored, state -certified Utah Peace Officer Standards and Training (POST) academy. Finally, the department is seeking funding to provide a one-time retention bonus for current sworn members. Current Staffing: The police department currently has 47 sworn vacancies out of its authorized staffing level of 597. The total number of resignations and retirements for FY 23 is currently at 23. If that current pace 46 employees per month) continues through the end of the fiscal year, the department predicts losing 55 total sworn employees by June 30, 2023. The department is proposing a multifaceted approach to improving sworn staffing utilizing overtime funding to ensure the department can provide, maintain and improve call responsiveness to community needs. While many other law enforcement jurisdictions have offered new hiring or lateral hiring bonuses greater than $15,000, the Salt Lake City Police Department is approaching funding this bonus using ARPA funding to reduce impact on the city's general fund. The department recognizes the competition that exists nationally to recruit officers with hiring bonuses and may need to reevaluate its approach. 16 Salt Lake City FY2022-23 Budget Amendment #5 Hiring Bonus: The lateral hiring bonus would provide greater incentive for a person who is law enforcement certified to leave their current department and to seek employment with the SLCPD. Hiring lateral officers will allow the department to reduce its sworn vacant positions faster than relying on a new hire recruit class. A lateral officer can be patrolling solo within approximately io-12 weeks of hire. Whereas, a new hire, with no law enforcement certification, will be patrolling solo at least 40-42 weeks from the start of their recruit class start date. Lateral Hiring bonus - Tiered rate based on length of commitment # year commitment 2 Bonus year 1 $ 10,000 Pensionable cost $ 4,680 # of officers estimated to hire 25 Total Cost $ 367,000 ARPA Funded $ 200,000 General Fund FY 23 $ 83,500 General Fund FY 24 - if approved for ongoing funding $ 83,500 If a lateral officer leaves employment with the SLCPD prior to the end of the employment commitment, there would be a requirement to repay the bonus prorated for time of commitment that was met. A proposal for repayment would be worked on jointly with the City's Human Resources and City Attorney's Office. For each new lateral hire, the department could likely save $i682 per week, which is currently being spent to backfill those patrol shifts using overtime. The department is also proposing providing a hiring bonus to qualified candidates who graduate from a self - sponsored, state certified satellite police academy. These candidates must meet all SLCPD hiring standards. This would provide $5000 to the qualified applicant. Post Academy Recruit Bonus Hiring Bonus $ 5,000 Pensionable Cost $ 2,340 Estimated number of hires 5 17 Salt Lake City FY2022-23 Budget Amendment #5 Total Cost $ 36,700 ARPA Funded $ 36,700 General Fund $ - The department is currently accelerating and prioritizing hiring but key to maintaining staffing stability is to slow the department's separation rate. Providing a retention bonus would provide further incentive to current sworn employees so the department could keep sworn FTE at a higher level than is currently being experienced. A retention bonus would be offered to most sworn employee excluding any officers who was hired and accepted a bonus and long-term military until those employees return to their regular duties within the department, if within the retention period. The retention bonus would be offered to the employee on their hiring date anniversary. This would stagger retention periods over the course of a calendar year, splitting it over two fiscal years and thereby preventing the potential of a mass calendar year retirement. Retention bonus - Tiered rate based on length of commitment # year commitment 1 2 Total Bonus $ 5,000 $ 8,000 Pensionable Cost $ 2,340 $ 3,744 # of officers estimated 16 513 529 Total Cost $ 117,440 $ 6,024,672 $ 6,142,112 ARPA Funded $ 117,440 $ 4,104,000 $ 4,221,440 General Fund FY 23 $ - $ 960,336 $ 960,336 General Fund FY 24 - if approved as an ongoing program $ - $ 960,336 $ 960,336 Total Retention and Hiring Program Cost Program Total Cost Estimate ARPA GF - 23 GF - 24 Lateral Hiring $ 367,000 $ 200,000 $ 83,500 $ 83,500 IM Salt Lake City FY2022-23 Budget Amendment #5 Academy Hiring $ 36,700 $ 36,700 $ - $ - Retention $ 6,142,112 $ 4,221,440 $ 960,336 $ 96o,336 Total $ 6,545,812 $ 4,458,140 $ 1,043,836 $ 1,043,836 The department has carefully evaluated these proposals using our best educated judgement to predict future hiring. There is no guarantee to the estimated number of new hires. I look forward to further discussion with you about these matters. Respectfully submitted, Chief Mike Brown Salt Lake City Police Department 19 Impact Fees - Summary Confdential Data pulled 12/28/2022 Unallocated Budget Amounts: by Major Area Area Cost Center Impact fee - Police 8484001 Impact fee - Fire 8484002 UnAllocated Cash Notes: A $ 989,579 $ 1,479,222 B Impact fee - Parks 8484003 $ 12,150,505 C Impact fee - Streets 8484005 $ 4,182,237 D $ 18,801,543 E=A+B+C+D Expiring Amounts: by Major Area, by Month Month 202207(Ju12022) QuarterCalendar Fiscal 2023Q1 $ - $ - $ - $ - Total $ - 202208(Aug2022) 2023Q1 $ - $ - $ - $ - $ - 202209(Sep2022) 2023Q1 $ - $ - $ - $ - $ - 202210(Oct2022) 2023Q2 $ - $ - $ - $ - $ - M 202211(Nov2022) 2023Q2 $ - $ - $ - $ - $ - N202212(Dec2022) 2023Q2 $ - $ - $ - $ - $ - 202301(Jan2023) 2023Q3 $ - $ - $ - $ - $ - 202302(Feb2023) 2023Q3 $ $ $ $ $ 202303(Mar2023) 2023Q3 $ - $ - $ - $ - $ - 202304(Apr2023) 2023Q4 $ - $ - $ - $ - $ - 202305(May2023) 2023Q4 $ - $ - $ - $ - $ - 202306(Jun2023) 2023Q4 $ - $ - $ - $ - $ - 202307(Ju12023) 2024Q1 $ - $ - $ - $ - $ - 202308 (Aug2023) 2024Q1 $ - $ - $ - $ - $ - 202309 (Sep2023) 2024Q1 $ - $ - $ - $ - $ - 202310 (Oct2023) 2024Q2 $ - $ - $ - $ - $ - N 202311 (Nov2023) 2024Q2 $ - $ - $ - $ - $ - N 202312(Dec2023) 2024Q2 $ - $ - $ - $ - $ - 202401(1an2024) 2024Q3 $ - $ - $ - $ - $ - 202402(Feb2024) 2024Q3 $ $ $ $ $ 202403(Mar2024) 2024Q3 $ - $ - $ - $ - $ - 202404 (Apr2024) 2024Q4 $ - $ - $ - $ - $ - 202405(May2024) 2024Q4 $ - $ - $ - $ - $ - 202406(7un2024) 2024Q4 $ - $ - $ - $ - $ - 202407 (Ju12024) 2025Q1 $ - $ - $ - $ - $ - 202408(Aug2024) 2025Q1 $ - $ - $ - $ - $ - 202409(Sep2024) 2025Q1 $ - $ - $ - $ - $ - 202410(Oct2024) 2025Q2 $ - $ - $ - $ - $ - Ln 202411(Nov2024) 2025Q2 $ - $ - $ - $ - $ - N202412(Dec2024) 2025Q2 $ - $ - $ - $ - $ - 202501(Jan2025) 2025Q3 $ - $ - $ - $ - $ - 202502(Feb2025) 2025Q3 $ - $ - $ - $ 132,793 $ 132,793 202503(Mar2025) 2025Q3 $ - $ - $ - $ 24,194 $ 24,194 202504(Apr2025) 2025Q4 $ - $ - $ - $ 260,338 $ 260,338 202505(May2025) 2025Q4 $ - $ - $ - $ 277,473 $ 277,473 202506(Jun2025) 2025Q4 $ - $ - $ - $ 28,350 $ 28,350 202507(Ju12025) 2026Q1 $ - $ - $ - $ 121,823 $ 121,823 202508(Aug2o25) 2026Q1 $ $ $ $ 194,127 $ 194,127 C:) 202509(Sep2025) 2026Q1 $ - $ - $ - $ 215,520 $ 215,520 rV 202510(Oct2025) 2026Q2 $ $ $ 679,086 $ 135,760 $ 814,847 202511 (Nov2025) 2026Q2 $ $ $ 987,055 $ 1,256,504 $ 2,243,559 202512(Dec2025) 2026Q2 $ $ $ 26,719 $ 113,748 $ 140,467 Total, Currently Expiring through Dec 2025 $ 0 $ - $ 1,692,860 $ 2,760,629 $ 4,453,490 :urrent Month Impact Fees Confidential Data pulled 12/28/2022 qqq BBB CCC DDD = PAN - BBB - CCC Allocation Budget Allocation YTD Allocation Remaining Police Amended Encumbrances Expenditures Appropriation Sum of Police Allocation Sum M Police Allocation Sum of Police Allocation Remaining Cost can Budget Amended Encumbrances Sum nf Police Allocation TTD I Appropriation 9 Llne Central Ninth 9418011 $Impact: fee - Police 8484001 $ $- $- $- $ $ $ - $ 19,14,068 $ 21,639 $ - $ 237,606 $ $ 273,314 14 $ $ - - $ - 0 $ 21,639 $ 237,606.45 259,246 Bridge W Backman 6418005 Im aR fee -Streets Westside 8484005 Im sofas -Fire M14111 Bilemay Urban Trails 641SM3 Gladiola Spread 9406001 845005 Public Esi 8419201 Police Im R Fee Refunds L21102 Grand Total Allocation Budget Allocation Allocation Remaining Fire Amended Encumbrances YTD Expenditures Appropriation Fire I.pact Fee Activi J Y Sum of Fire Allocation Sum of Fire Allocation Sum of Fire Allocation Remaining Desai lion cost C. Budget Amended Encumbrances Sum of Fire Allocation TTD Ex Appropriation Flre'aMltanVsContmct 6419202 $ 3,079 $ 3,021 $ - 58.00 MO FirsTrainin Fac. B420931 $ - $ - $ Grand Total 3,079 3,021 - 58.00 Allocation Budget Allocation Allocation Remaining YTD Expenditures Parks Amended Encumbrances Appropriation ion Cost C. Sum of Parks Allocation Sum of Parks Allocation Sum of Parka Allocation Remaining Budget Amended Encumbrances Sum of Parks Allocation YTDI Appropriation SpaceAC 8422423 $ 700,000 $ $ 3,33] $ $ 261,187 $ $ 2,638 $ $ 23,262 $ $ 16,959 $ $ 1,056 $ 1,570 $ $ 2,946 $ $ 6,31 $ $ 16,495 $ $ 12,411 $ $ 9,350 $ $ 2]5,000 $ $ 4575:030 $ $ 56,109 $ $ 1,042:694 $ $ 254,159 $ $ 156,565 $ $ 122,261 $ $ 156,827 $ $ 150,736 $ $ 420,000 $ $ 160,819 $ $ 179,323 $ $ 266306 $ $ 287:848 $ $ 30000 $ $ 319,139 $ 32J,671 $ $ 4278 74 $ $ 946,825 $ $ 510,000 $ $ 499,563 $ $ 521,564 $ $ S08,990 $ $ 867,962 $ $ 1,304,682 $ $ 3, 177,899 $ $ 3,149,123 $ $ 4,350,000 $ 21,852,274 - $ - $ - $ 2,596 $ 23,000 $ 1,]OS $ - $ - 1$ - $ 855 $ '328 $ - $ - $ 365,156 $ - $ 935,679 $ 133,12: $ 16,348 $ - $ 10,265 $ - $ 260,376 $ - $ - $ 10,285 $ - $ - $ - $ 19,719 $ 21,823 $ 34,234 $ - $ - $ - $ - $ 88,382 $ 267,681 $ 67,450 $ - $ 2,263,009 707,192 $ 3,33] $ 261,187 $ - $ - $ 14,873 $ $ - $ - $ - $ 7,745 $ - $ - $ 253,170 $ 64,525 $ 1,302 $ 29,674 $ 5,716 $ 22,490 $ 60 $ 3,950 $ - $ $ - - $ 57 $ 4,051 $ - $ $ - $ 7,448 $ 10,771 $ 10,127 $ - $ - $ 2,452 $ - $ - $ 163,900 $ 22,109 $ - $ 1,591,335 (7,192) - - 42 262 381 1,056 1,570 2,946 6,398 7,895 8,103 9,350 21,830 25,348 St,808 82,141 115,318 '17:1 122,222 142,612 151,736 159,624 160,819 179,266 2:1,969 27,848 311,00 319,139 327,678 400,906 414,230 465,638 999,563 521,564 606,038 867,962 1,216,300 2,746,268 3,059,564 4,350,000 17 997 931 =:n it Ram 8420144 Cartia Xouu 9420130 nsultant bract 8419204 Do Lease Im 9418002 lark Redevelo men! Plan 8421402 ood Dog Park R 3 Creeks Confluence 9417013 8417018 R Troll Lantl Acqulsibl 'alPorlrShadeAtR' 6417017 6419103 ark rk Comm Garden 6416005 6420138 .d Meatlows Park Dar 6417014 Id uisition 6421403 Xause Exploretlon Ctr s Ac uisition 3 Creeks 6421401 6420906 ilade Park Block Phase ll 8417011 '1 Match 3 Creek Confluen 6420424 trld a[o Backman 8420430 Ph2 Foothill Trails S420420 )rchard 8420136 Creeks Weal: Bank NeerPark 6922903 c Renovatlon AllenParK 'ark Nei hborh00d Center 8422410 6923903 aygrountl with shatleSails M Backman 8422415 S418005 River Park Soccer Reid NMiuellEdltl 8423406 S423909 on 's Treil Oesi n&COnMr 8422413 691J012 Prk Evert Grountls ch 111,11-Inn -ends 8420134 B420142 Park Pedestrian Pathway my Than le Property Park 8422414 $423408 around Phase 11 I 200 E Design 8423405 $422408 rise Grove Design & Ind. atlrillsTreilheadDevel met 8423407 $422412 ileWt rk MstrPln&Rehab 8422406 rr Park M19150 tie Regional Park Phase 1 ttel 8423950 -__ as „_LL „__ Sum of Street Allocation Sum Budget Amended of Street Allocation Encumbrances „_„ Sum of Street Allocation Remaining Appropriation 63,955 $ - $ 63,955 $ - 70,000 $ - $ 70,000 $ - 15,026 $ 11,703 $ 3,323 $ - 1,292 $ - $ - $ 1,292 16,109 $ 13,865 $ - $ 2,299 6,500 $ . $ - $ 6,500 44,900 $ 3,939 $ 28,319 $ 12,142 29,817 $ 17,492 $ - $ 12,374 13,973 $ - $ - $ 13,473 22,744 $ - $ - $ 22,744 25,398 $ - $ - $ 25,398 28,000 $ - $ - $ 26,000 35,300 $ - $ - $ 35,300 35,392 $ - $ - $ 35,392 37,922 $ - $ - $ 3],422 58,780 $ 20,697 $ - $ 38,083 40,000 $ - $ - $ 40,000 42,833 $ - $ - $ 42,833 50,000 $ - $ - $ 50,000 90,000 $ - $ - $ 90,000 104,500 $ - $ - $ 109,500 110,000 $ - $ - $ 110,000 124,593 $ - $ - $ 124,593 141,661 $ - $ - $ 141,663 154,739 $ - $ - $ 154,739 158,570 $ - $ - $ 158,570 171,941 $ - $ - $ 171,949 181,846 $ - $ - $ 181,846 281,586 $ 10,390 $ 34,272 $ 236,979 252,000 $ - $ - $ 252,000 338633 $ - $ - $ 338,633 780:182 $ 147,983 $ 248,890 $ 383,309 SM 728 $ - $ - $ 500,728 625,000 $ - $ - $ 625,M 660,410 $ - $ - $ 660,410 950 $ - $ - $ 450 836,736 $ 65,646 $ 42,175 $ 728,815 812,805 $ - $ 971 $ 811,834 915,151 $ - $ - $ 915,151 120,000 $ $ $ 1120 000 0,976 $ 311 15 $ 491,804 $ 8,214,356 UnAllocated Budget Amount i $ 989,579 8484001 A $1,479,222 s4Baooz e $12,150,505 8484003 C $ 4,182,237 8484005 D Sum of Budget -Amended Sum of ncum- prances Sum of 1. EspendiWres Sum of Remaining Appropriation $18,801,543 rota) 1 $ 31,139,643 $ 2,584,913 $ 2,083,139 26,47 591 E=A+B+C+D TRUE TRUE TRUE TRUE