Finance Committee Meeting

Agenda City of Ocean Shores Finance Committee Meeting Tuesday June 20, 2023 Zoom Meeting 1:00 PM Page Call to Order Financials 1. 2023 Monthly Financial Update • Presented by: Finance Director, Angela Folkers and Assistant Treasurer, Shante Nations 2-8 2. 2023 - 2024 Budget Amendment No. 1 • Presented by: Finance Director, Angela Folkers 3. American Rescue Plan Act Project Updates • Presented by: Project Manager, Becky Leach Ocean Shores Development and Grants 9 4. Development and Grant Activity Update • Presented by: Grant Manager, Sarah Bisson Mayor Report Adjourn Page 1 of 9 2. 2023 - 2024 Budget Amendment No. 1 Presented by: Finance Director, An... CITY OF OCEAN SHORES 2023-2024 Sources and Uses Per Budget Amendment #1 Exhibit A - Detail Beg Bal - Sources - Sources BA Amended Uses - Uses Amended End Bal - Before End Bal - End Bal - Total Fund Description 2023-2024 Orig #1 Sources Orig BA #1 Uses BA #1 After BA #1 Change 001 GENERAL FUND 3,183,911.22 21,189,294.61 121,517.02 21,310,811.63 21,685,775.21 234,631.85 21,920,407.06 2,687,430.62 2,574,315.79 (113,114.83) 002 CONTINGENCY 352,365.37 - - - - - - 352,365.37 352,365.37 - 003 CUMULATIVE RESERVE - ARPA 1,830,422.28 - - - 1,804,869.51 - 1,804,869.51 25,552.77 25,552.77 - 101 STREET 574,172.74 1,675,455.41 (40,881.15) 1,634,574.26 2,210,261.00 (39,763.44) 2,170,497.56 39,367.15 38,249.44 (1,117.71) 102 GOLF COURSE 9,530.64 - 216,250.00 216,250.00 - 216,250.00 216,250.00 9,530.64 9,530.64 - 103 STREET RESERVE 378,636.94 - - - 292,000.00 - 292,000.00 86,636.94 86,636.94 - 104 EMERGENCY CARE 1,252,111.90 9,323,445.76 - 9,323,445.76 9,121,428.66 8,993.00 9,130,421.66 1,454,129.00 1,445,136.00 (8,993.00) 105 HOTEL-MOTEL TAX 817,804.15 2,033,650.00 - 2,033,650.00 2,548,638.00 98,309.00 2,646,947.00 302,816.15 204,507.15 (98,309.00) 106 CONVENTION & TOURISM 267,444.45 2,864,858.00 98,309.00 2,963,167.00 2,717,180.00 122,034.00 2,839,214.00 415,122.45 391,397.45 (23,725.00) 107 CONFISCATED PROPERTY FUND 4,721.73 - - - - - - 4,721.73 4,721.73 - 110 EQUIPMENT RESERVE 719,485.54 744,000.00 - 744,000.00 1,185,000.00 112,868.29 1,297,868.29 278,485.54 165,617.25 (112,868.29) 112 BOATING SAFETY 37,771.21 40,000.00 - 40,000.00 47,878.00 - 47,878.00 29,893.21 29,893.21 - 114 REPAIR & DEMOLITION 115,338.80 - - - 80,000.00 - 80,000.00 35,338.80 35,338.80 - 117 LID AMINISTRATIVE COST 1,328,079.82 294,874.05 - 294,874.05 419,340.00 - 419,340.00 1,203,613.87 1,203,613.87 - 202 GO FIRE BOND REDEMPTION 10,615.92 779,550.00 - 779,550.00 779,550.00 - 779,550.00 10,615.92 10,615.92 - 206 GO CONV CENTER BOND REDEMPTION 377,352.33 1,052,950.00 - 1,052,950.00 1,319,050.00 - 1,319,050.00 111,252.33 111,252.33 - 213 LID BOND GUARANTY 452,601.32 1,000.00 - 1,000.00 254,392.00 - 254,392.00 199,209.32 199,209.32 - 214 LID 07-01 BOND REDEMPTION 900,751.83 2,502,000.00 - 2,502,000.00 1,434,132.00 - 1,434,132.00 1,968,619.83 1,968,619.83 - 301 CAPITAL IMPROVEMENT 2,655,009.21 6,513,124.00 - 6,513,124.00 7,478,670.00 519,708.07 7,998,378.07 1,689,463.21 1,169,755.14 (519,708.07) 320 WATER CAPITAL REPLACEMENT 2,627,915.97 1,935,000.00 - 1,935,000.00 2,425,000.00 - 2,425,000.00 2,137,915.97 2,137,915.97 - 330 SEWER CAPITAL REPLACEMENT 909,919.94 10,000.00 - 10,000.00 380,000.00 - 380,000.00 539,919.94 539,919.94 - 350 HOTEL-MOTEL CAP. IMPROVMT 806,456.83 600,000.00 - 600,000.00 950,000.00 - 950,000.00 456,456.83 456,456.83 - 373 FAA AIRPORT IMPROVEMENTS - 500,000.00 - 500,000.00 500,000.00 - 500,000.00 - - - 406 WEATHERWAX MITIGATN/LAND BANK 228,340.20 157,600.00 - 157,600.00 96,998.00 - 96,998.00 288,942.20 288,942.20 - 407 WATER TREATMENT PLANT-ARRA LOAD 2,745.09 308,320.00 - 308,320.00 307,820.00 - 307,820.00 3,245.09 3,245.09 - 408 WTP CTED LOAD REDEMPTION 1,874.76 180,476.00 - 180,476.00 179,786.00 - 179,786.00 2,564.76 2,564.76 - 409 W/S REVENUE BOND REDEMPTION 1,355.82 333,598.00 - 333,598.00 333,198.00 - 333,198.00 1,755.82 1,755.82 - 412 LID 95-01 BOND REDEMPTION 1,360.26 - - - 482.05 - 482.05 878.21 878.21 - 415 GO WATER/GHC BOND REDEMPTION 158,737.38 - - - 137,172.41 - 137,172.41 21,564.97 21,564.97 - 417 LID 98-01 BOND REDEMPTION 7,969.92 - - - - - - 7,969.92 7,969.92 - 420 WATER CAPITAL IMPROVEMENT 1,434,278.31 888,200.00 - 888,200.00 887,696.00 - 887,696.00 1,434,782.31 1,434,782.31 - 430 SEWER CAPITAL IMPROVEMENT 369,356.50 242,400.00 - 242,400.00 - - - 611,756.50 611,756.50 - 434 WATER UTILITY 1,603,312.12 8,357,350.00 - 8,357,350.00 8,817,329.00 72,194.99 8,889,523.99 1,143,333.12 1,071,138.13 (72,194.99) 435 SEWER UTILITY 1,248,024.81 5,578,972.41 - 5,578,972.41 5,868,332.00 35,175.55 5,903,507.55 958,665.22 923,489.67 (35,175.55) 438 STORM DRAIN UTILITY 1,103,474.68 3,131,200.00 - 3,131,200.00 2,586,902.00 67,738.00 2,654,640.00 1,647,772.68 1,580,034.68 (67,738.00) 439 SHARED UTILITY 40,073.88 1,001,750.00 - 1,001,750.00 975,878.00 - 975,878.00 65,945.88 65,945.88 - 503 UNEMPLOYMENT COMPENSATION 126,752.79 68,917.06 - 68,917.06 50,000.00 - 50,000.00 145,669.85 145,669.85 - 504 SELF-INSURANCE 358,017.18 821,977.00 - 821,977.00 802,000.00 - 802,000.00 377,994.18 377,994.18 - 634 TRANSPORTATION BENEFIT DISTRICT 1,156,599.20 800,000.00 - 800,000.00 1,220,000.00 - 1,220,000.00 736,599.20 736,599.20 - TOTAL FUNDS 27,454,693.04 73,929,962.30 395,194.87 74,325,157.17 79,896,757.84 1,448,139.31 81,344,897.15 21,487,897.50 20,434,953.06 (1,052,944.44) Page 2 of 9  CITY OF OCEAN SHORES 2023-2024 Sources and Uses Per Budget Amendment #1 Exhibit A - Detail Beg Bal - Estimated Budgeted Ending Bal - Fund Description 2023-2024 Sources Uses 2023-2024 001 GENERAL FUND 3,183,911.22 21,310,811.63 21,920,407.06 2,574,315.79 002 CONTINGENCY 352,365.37 - - 352,365.37 003 CUMULATIVE RESERVE - ARPA 1,830,422.28 - 1,804,869.51 25,552.77 101 STREET 574,172.74 1,634,574.26 2,170,497.56 38,249.44 102 GOLF COURSE 9,530.64 216,250.00 216,250.00 9,530.64 103 STREET RESERVE 378,636.94 - 292,000.00 86,636.94 104 EMERGENCY CARE 1,252,111.90 9,323,445.76 9,130,421.66 1,445,136.00 105 HOTEL-MOTEL TAX 817,804.15 2,033,650.00 2,646,947.00 204,507.15 106 CONVENTION & TOURISM 267,444.45 2,963,167.00 2,839,214.00 391,397.45 107 CONFISCATED PROPERTY FUND 4,721.73 - - 4,721.73 110 EQUIPMENT RESERVE 719,485.54 744,000.00 1,297,868.29 165,617.25 112 BOATING SAFETY 37,771.21 40,000.00 47,878.00 29,893.21 114 REPAIR & DEMOLITION 115,338.80 - 80,000.00 35,338.80 117 LID AMINISTRATIVE COST 1,328,079.82 294,874.05 419,340.00 1,203,613.87 202 GO FIRE BOND REDEMPTION 10,615.92 779,550.00 779,550.00 10,615.92 206 GO CONV CENTER BOND REDEMPTION 377,352.33 1,052,950.00 1,319,050.00 111,252.33 213 LID BOND GUARANTY 452,601.32 1,000.00 254,392.00 199,209.32 214 LID 07-01 BOND REDEMPTION 900,751.83 2,502,000.00 1,434,132.00 1,968,619.83 301 CAPITAL IMPROVEMENT 2,655,009.21 6,513,124.00 7,998,378.07 1,169,755.14 320 WATER CAPITAL REPLACEMENT 2,627,915.97 1,935,000.00 2,425,000.00 2,137,915.97 330 SEWER CAPITAL REPLACEMENT 909,919.94 10,000.00 380,000.00 539,919.94 350 HOTE-MOTEL CAP. IMPROVMT 806,456.83 600,000.00 950,000.00 456,456.83 373 FAA AIRPORT IMPROVEMENTS - 500,000.00 500,000.00 - 406 WEATHERWAX MITIGATN/LAND BANK 228,340.20 157,600.00 96,998.00 288,942.20 407 WATER TREATMENT PLANT-ARRA LOAD 2,745.09 308,320.00 307,820.00 3,245.09 408 WTP CTED LOAD REDEMPTION 1,874.76 180,476.00 179,786.00 2,564.76 409 W/S REVENUE BOND REDEMPTION 1,355.82 333,598.00 333,198.00 1,755.82 412 LID 95-01 BOND REDEMPTION 1,360.26 - 482.05 878.21 415 GO WATER/GHC BOND REDEMPTION 158,737.38 - 137,172.41 21,564.97 417 LID 98-01 BOND REDEMPTION 7,969.92 - - 7,969.92 420 WATER CAPITAL IMPROVEMENT 1,434,278.31 888,200.00 887,696.00 1,434,782.31 430 SEWER CAPITAL IMPROVEMENT 369,356.50 242,400.00 - 611,756.50 434 WATER UTILITY 1,603,312.12 8,357,350.00 8,889,523.99 1,071,138.13 435 SEWER UTILITY 1,248,024.81 5,578,972.41 5,903,507.55 923,489.67 438 STORM DRAIN UTILITY 1,103,474.68 3,131,200.00 2,654,640.00 1,580,034.68 439 SHARED UTILITY 40,073.88 1,001,750.00 975,878.00 65,945.88 503 UNEMPLOYMENT COMPENSATION 126,752.79 68,917.06 50,000.00 145,669.85 504 SELF-INSURANCE 358,017.18 821,977.00 802,000.00 377,994.18 634 TRANSPORTATION BENEFIT DISTRICT 1,156,599.20 800,000.00 1,220,000.00 736,599.20 TOTAL FUNDS 27,454,693.04 74,325,157.17 81,344,897.15 20,434,953.06 2. 2023 - 2024 Budget Amendment No. 1 Presented by: Finance Director, An... Page 3 of 9 2. 2023 - 2024 Budget Amendment No. 1 Presented by: Finance Director, An... EXHIBIT B - SOURCES CITY OF OCEAN SHORES 2023-2024 Sources Budget Amendment #1 - Detail Per Fund/BARS Account Total Amended Fund Account No BARS Category Description Orig Rev Est Post BA #1 $ % 001 001.030.000.331.20.00.00 FAA Airport Grant FAA Grant Reimbursement for expenses Paid in 2022 - 111,517.02 111,517.02 001 001.030.000.334.01.20.00 State Grant - Other Agency Adding Police training grant revenue - 10,000.00 10,000.00 TOTAL FUND 001 - GENERAL FUND AMENDMENTS - 121,517.02 121,517.02 101 101.030.000.334.03.80.00 Pt Brown Crosswalks - TIB Reducing Point Brown Crosswalk grant revenue 200,000.00 169,720.00 (30,280.00) -15% 101 101.030.000.337.00.00.01 WCIA Grant Adding WCIA (Dolphin Ave) grant revenue - 5,934.00 5,934.00 101 101.090.000.397.40.00.00 Trf In - General Fund 001 Reduction of transfers in from General Fund 770,205.41 753,670.26 (16,535.15) -2% TOTAL FUND 101 - STREET AMENDMENTS 970,205.41 929,324.26 (40,881.15) -4% 102 102.090.000.397.76.02.00 Trf In - General Fund 001 Transfer in for Golf Course operations - 216,250.00 216,250.00 TOTAL FUND 102 - GOLF COURSE AMENDMENTS - 216,250.00 216,250.00 106 106.090.000.397.75.04.00 Trf In - H/M Tax 105 - Promotions Increasing transfers in to add LTAC surplus awards 231,000.00 329,309.00 98,309.00 43% TOTAL FUND 106 - HOTEL-MOTEL TAX AMENDMENTS 231,000.00 329,309.00 98,309.00 43% TOTAL AMENDMENTS - ALL FUNDS: 1,201,205.41 1,596,400.28 395,194.87 33% Page 4 of 9 2. 2023 - 2024 Budget Amendment No. 1 Presented by: Finance Director, An... EXHIBIT B - USES CITY OF OCEAN SHORES 2023-2024 Sources Budget Amendment #1 - Detail Per Fund/BARS Account Total Amended Fund Account No BARS Category Description Orig Rev Est Post BA #1 $ % 001 001.145.000.514.89.46.00 Liability Insurance Additional Insurance Costs 250,000.00 264,181.00 14,181.00 6% 001 001.210.000.521.20.49.00 Dues/Subscriptions/Training Adding Police training grant expense 14,000.00 24,000.00 10,000.00 71% 001 001.220.000.522.20.46.00 Liability Insurance Additional Insurance Costs 84,000.00 92,785.00 8,785.00 10% 001 001.480.000.548.38.46.00 Property and Liability Insurance Additional Insurance Costs 15,000.00 16,951.00 1,951.00 13% 001 001.970.000.597.04.00.00 Trf Out - Golf Course 102 Transfer out for Golf Course operations - 216,250.00 216,250.00 001 001.970.000.597.40.00.00 Trf Out - Street 101 Reduction of transfers out to Street Fund 770,205.41 753,670.26 (16,535.15) -2% TOTAL FUND 001 - AMENDMENTS 1,133,205.41 1,367,837.26 234,631.85 21% Reduction in Street Fund payroll due to vacant Maintenance Worker II 101 101.420.000.542.30.11.00 Salaries 353,525.00 312,380.59 (41,144.41) -12% positions funded starting 1/1/23 Reduction in Street Fund payroll due to vacant Maintenance Worker II 101 101.420.000.542.30.21.00 Health Insurance 92,039.00 77,683.24 (14,355.76) -16% positions funded starting 1/1/23 Reduction in Street Fund payroll due to vacant Maintenance Worker II 101 101.420.000.542.30.22.00 Retirement 76,650.00 67,141.81 (9,508.19) -12% positions funded starting 1/1/23 Reduction in Street Fund payroll due to vacant Maintenance Worker II 101 101.420.000.542.30.23.00 Industrial Insurance 13,078.00 11,457.76 (1,620.24) -12% positions funded starting 1/1/23 Reduction in Street Fund payroll due to vacant Maintenance Worker II 101 101.420.000.542.30.24.00 Unemployment 1,276.00 1,127.47 (148.53) -12% positions funded starting 1/1/23 Reduction in Street Fund payroll due to vacant Maintenance Worker II 101 101.420.000.542.30.25.00 Severance Reserve 8,131.00 7,184.68 (946.32) -12% positions funded starting 1/1/23 Reduction in Street Fund payroll due to vacant Maintenance Worker II 101 101.420.000.542.30.27.00 Social Security 5,126.00 4,529.40 (596.60) -12% positions funded starting 1/1/23 101 101.420.000.542.30.63.00 Point Brown Midblock X'ing Increasing Point Brown Crosswalk project expense 200,000.00 221,504.90 21,504.90 11% 101 101.424.000.542.64.31.00 Office and Operating Supplies Adding WCIA grant (Dolphin Ave) project expenses 28,650.00 36,067.71 7,417.71 26% 101 101.430.000.543.30.46.00 Liability Insurance Reduction in Insurance Costs 18,000.00 17,634.00 (366.00) -2% TOTAL FUND 101 - AMENDMENTS 796,475.00 756,711.56 (39,763.44) -5% 102 102.760.000.576.60.41.00 Professional Services Addition of Golf Course operational expenses - 216,250.00 216,250.00 TOTAL FUND 102 - AMENDMENTS - 216,250.00 216,250.00 104 104.260.000.522.20.46.00 Liability Insurance Additional Insurance Costs 88,000.00 96,993.00 8,993.00 10% TOTAL FUND 104 - AMENDMENTS 88,000.00 96,993.00 8,993.00 10% 105 105.970.000.597.75.04.00 Trf Out - 106/ Promotions Increasing transfers out to add LTAC surplus awards 231,000.00 329,309.00 98,309.00 43% TOTAL FUND 105 - AMENDMENTS 231,000.00 329,309.00 98,309.00 43% 106 106.730.000.573.90.44.00 Promotions Increasing promotions expense for LTAC surplus awards 191,000.00 289,309.00 98,309.00 51% 106 106.750.000.575.40.46.00 Liability Insurance Additional Insurance Costs 58,000.00 81,725.00 23,725.00 41% TOTAL FUND 106 - AMENDMENTS 249,000.00 371,034.00 122,034.00 49% Page 5 of 9 2. 2023 - 2024 Budget Amendment No. 1 Presented by: Finance Director, An... EXHIBIT B - USES CITY OF OCEAN SHORES 2023-2024 Sources Budget Amendment #1 - Detail Per Fund/BARS Account Total Amended Fund Account No BARS Category Description Orig Rev Est Post BA #1 $ % 110 110.110.000.594.46.64.00 Equipment - Airport Tractor ordered in 2022; delivered and paid Jan 2023 - 37,622.76 37,622.76 110 110.110.000.594.31.64.00 Equipment - Storm Drain Tractor ordered in 2022; delivered and paid Jan 2023 - 37,622.76 37,622.76 110 110.110.000.594.95.64.00 Equipment - Street Tractor ordered in 2022; delivered and paid Jan 2023 715,000.00 752,622.77 37,622.77 5% TOTAL FUND 110 - AMENDMENTS 715,000.00 827,868.29 112,868.29 16% 301 301.001.000.541.62.63.00 Dunes Trail Project Adding additional Dune Trail project expense 162,707.00 220,164.51 57,457.51 35% 301 301.001.000.594.18.60.05 Golf Course Equipment Adding expense for Golf Course equipment purchase - 462,250.56 462,250.56 TOTAL FUND 301 - AMENDMENTS 162,707.00 682,415.07 519,708.07 319% 434 434.635.000.534.00.48.00 Repairs and Maintenance Adding additional expense for Central Station Roof and Residing 18,750.00 43,259.97 24,509.97 131% 434 434.651.000.534.00.48.00 Repairs and Maintenance Adding expense for Point Brown Crosswalk hydrant work 16,650.00 53,978.50 37,328.50 224% 434 434.921.000.534.00.46.00 Property and Liability Insurance Additional Insurance Costs 114,000.00 139,331.00 25,331.00 22% 434 434.921.000.534.00.48.00 Repairs and Maintenance Reducing expense for Treatment Plant Building Roof and Gutters 48,100.00 33,125.52 (14,974.48) -31% TOTAL FUND 434 - AMENDMENTS 197,500.00 269,694.99 72,194.99 37% 435 435.640.000.535.00.48.00 Repairs and Maintenance Adding additional expense for Old Collections Gutters and Siding 18,750.00 23,065.55 4,315.55 23% 435 435.921.000.535.00.46.00 Property and Liability Insurance Additional Insurance Costs 158,000.00 188,860.00 30,860.00 20% TOTAL FUND 435 - AMENDMENTS 176,750.00 211,925.55 35,175.55 20% 438 438.673.030.531.00.41.01 Fresh Wtrway - Aquatic Weed Mgmt Aquatic weed spraying perfomed in 2022; paid on 2/2/23 270,000.00 337,700.00 67,700.00 25% 438 438.921.000.531.00.46.00 Property and Liability Insurance Additional Insurance Costs 24,000.00 24,038.00 38.00 0% TOTAL FUND 304 - AMENDMENTS 294,000.00 361,738.00 67,738.00 23% TOTAL AMENDMENTS - ALL FUNDS: 4,043,637.41 5,491,776.72 1,448,139.31 36% Page 6 of 9 2. 2023 - 2024 Budget Amendment No. 1 Presented by: Finance Director, An... Council Approved 2023-2024 Budget Amendment #1 Items: Council Meeting Budget Amendment Fund Name & Total Expensed Date Agenda Item Amount Budgeted Amount Number BARS Code Comments Council Approval Completion Date as of 5.23.2023 A Request of the City Council of the City of Ocean Shores, Washington, approving the Transfer out needed to cover additional cost of February 13, 2023 $770,205.41 $51,784.90 001 - General Fund 001.970.000.597.40.00.00 Passed 7 Yes Votes N/A N/A Transportation Improvement Board Point Brown Point Brown crosswalk project Crosswalk Project Bid Award A Request of the City Council of the City of Ocean Shores, Washington, approving the February 13, 2023 $200,000.00 ($30,280.00) 101 - Street Fund 101.030.000.334.03.80.00 Reducing grant revenue Passed 7 Yes Votes N/A N/A Transportation Improvement Board Point Brown Crosswalk Project Bid Award A Request of the City Council of the City of Ocean Shores, Washington, approving the Transfer in needed to cover additional cost of February 13, 2023 $770,205.41 $51,784.90 101 - Street Fund 101.090.000.397.40.00.00 Passed 7 Yes Votes N/A N/A Transportation Improvement Board Point Brown Point Brown crosswalk project Crosswalk Project Bid Award A Request of the City Council of the City of Ocean Shores, Washington, approving the February 13, 2023 $200,000.00 $21,504.90 101 - Street Fund 101.420.000.542.30.63.00 Increasing total project expense Passed 7 Yes Votes In Process $89,007 Transportation Improvement Board Point Brown Crosswalk Project Bid Award A Request of the City Council of the City of Ocean Shores, Washington, approving the February 13, 2023 $0.00 $37,328.50 434 - Water Fund 434.651.000.534.00.48.00 Adding expense for hydrant work Passed 7 Yes Votes In Process $0 Transportation Improvement Board Point Brown Crosswalk Project Bid Award March 13, 2023 Ocean Shores Police Department Training $0.00 $10,000.00 001 - General Fund 001.030.000.334.01.20.00 Adding grant revenue Passed 6 Yes Votes; 0 No Votes N/A N/A allocation from the Washington Association of Sheriffs and Police Chiefs March 13, 2023 Ocean Shores Police Department Training $0.00 $10,000.00 001 - General Fund 001.210.000.521.20.49.00 Adding grant expense Passed 6 Yes Votes; 0 No Votes In Process $0 allocation from the Washington Association of Sheriffs and Police Chiefs April 10, 2023 $0.00 $5,934.00 101 - Street Fund 101.030.000.337.00.00.01 Adding grant revenue Passed 6 Yes Votes; 0 No Votes N/A N/A WCIA Risk Mitigation Grant Award (Dolphin Ave) April 10, 2023 $0.00 $7,417.71 101 - Street Fund 101.424.000.542.64.31.00 Adding project expenses Passed 6 Yes Votes; 0 No Votes In Process $6,799 WCIA Risk Mitigation Grant Award (Dolphin Ave) 105 - Hotel/Motel Tax Increasing transfers out to add LTAC surplus See meeting minutes for vote counts April 10, 2023 $231,000.00 $98,309.00 105.970.000.597.75.04.00 N/A N/A LTAC Surplus Awards Fund awards on each of the five awards 106 - Convention Increasing transfers in to add LTAC surplus See meeting minutes for vote counts April 10, 2023 $231,000.00 $98,309.00 106.090.000.397.75.04.00 N/A N/A LTAC Surplus Awards Center Fund awards on each of the five awards 106 - Convention Increasing promotions expense for LTAC See meeting minutes for vote counts April 10, 2023 $191,000.00 $98,309.00 106.730.000.573.90.44.00 5/12/2023 $98,309 LTAC Surplus Awards Center Fund surplus awards on each of the five awards Golf Facility Management and Professional Reduction of transfer out to Street Fund for April 20, 2023 Employment Services Agreement for Ocean $770,205.41 ($68,320.05) 001 - General Fund 001.090.000.597.40.00.00 Passed 7 Yes Votes N/A N/A payroll savings Shores Golf Course Golf Facility Management and Professional April 20, 2023 Employment Services Agreement for Ocean $0.00 $216,250.00 001 - General Fund 001.970.000.597.04.00.00 Transfer out for Golf Course operations Passed 7 Yes Votes N/A N/A Shores Golf Course Golf Facility Management and Professional Reduction of transfer in to Street Fund for payroll April 20, 2023 Employment Services Agreement for Ocean $770,205.41 ($68,320.05) 101 - Street Fund 101.090.000.397.40.00.00 Passed 7 Yes Votes N/A N/A savings Shores Golf Course Golf Facility Management and Professional Reduction in Street Fund payroll due to vacant April 20, 2023 Employment Services Agreement for Ocean $353,525.00 ($41,144.41) 101 - Street Fund 101.420.000.542.30.11.00 Maintenance Worker II positions funded starting Passed 7 Yes Votes N/A N/A Shores Golf Course 1/1/23 Golf Facility Management and Professional Reduction in Street Fund payroll due to vacant April 20, 2023 Employment Services Agreement for Ocean $92,039.00 ($14,355.76) 101 - Street Fund 101.420.000.542.30.21.00 Maintenance Worker II positions funded starting Passed 7 Yes Votes N/A N/A Shores Golf Course 1/1/23 Golf Facility Management and Professional Reduction in Street Fund payroll due to vacant April 20, 2023 Employment Services Agreement for Ocean $76,650.00 ($9,508.19) 101 - Street Fund 101.420.000.542.30.22.00 Maintenance Worker II positions funded starting Passed 7 Yes Votes N/A N/A Shores Golf Course 1/1/23 Golf Facility Management and Professional Reduction in Street Fund payroll due to vacant April 20, 2023 Employment Services Agreement for Ocean $13,078.00 ($1,620.24) 101 - Street Fund 101.420.000.542.30.23.00 Maintenance Worker II positions funded starting Passed 7 Yes Votes N/A N/A Shores Golf Course 1/1/23 Page 7 of 9 2. 2023 - 2024 Budget Amendment No. 1 Presented by: Finance Director, An... Council Approved 2023-2024 Budget Amendment #1 Items: Council Meeting Budget Amendment Fund Name & Total Expensed Date Agenda Item Amount Budgeted Amount Number BARS Code Comments Council Approval Completion Date as of 5.23.2023 Golf Facility Management and Professional Reduction in Street Fund payroll due to vacant April 20, 2023 Employment Services Agreement for Ocean $1,276.00 ($148.53) 101 - Street Fund 101.420.000.542.30.24.00 Maintenance Worker II positions funded starting Passed 7 Yes Votes N/A N/A Shores Golf Course 1/1/23 Golf Facility Management and Professional Reduction in Street Fund payroll due to vacant April 20, 2023 Employment Services Agreement for Ocean $8,131.00 ($946.32) 101 - Street Fund 101.420.000.542.30.25.00 Maintenance Worker II positions funded starting Passed 7 Yes Votes N/A N/A Shores Golf Course 1/1/23 Golf Facility Management and Professional Reduction in Street Fund payroll due to vacant April 20, 2023 Employment Services Agreement for Ocean $5,126.00 ($596.60) 101 - Street Fund 101.420.000.542.30.27.00 Maintenance Worker II positions funded starting Passed 7 Yes Votes N/A N/A Shores Golf Course 1/1/23 Golf Facility Management and Professional 102 - Golf Course April 20, 2023 Employment Services Agreement for Ocean $0.00 $216,250.00 102.090.000.397.76.02.00 Transfer in for Golf Course operations Passed 7 Yes Votes N/A N/A Fund Shores Golf Course Golf Facility Management and Professional 102 - Golf Course April 20, 2023 Employment Services Agreement for Ocean $0.00 $216,250.00 102.760.000.576.60.41.00 Addition of Golf Course operational expenses Passed 7 Yes Votes In Process $0 Fund Shores Golf Course A Request of the City Council of the City of Ocean Shores, Washington, awarding the High April 24, 2023 $162,707.00 $57,457.51 301 - Capital Fund 301.001.000.541.62.63.00 Adding additional project expense Passed 7 Yes Votes In Process $20,474 Dune Trail Construction Contract Award to KR Homes April 28, 2023 Golf Course Equipment Sales Agreement $0.00 $462,250.56 301 - Capital Fund 301.001.000.594.18.60.05 Adding expense for equipment purchase Passed 5 Yes Votes; 0 No Votes Paid first installment $200,000 A Request of the City Council of Ocean Shores, WA, awarding the Central Pump Station Roof and Siding Replacements, Water Treatment Plan Adding additional expense for Central Station May 8, 2023 $18,750.00 $24,509.97 434 - Water Fund 434.635.000.534.00.48.00 Passed 5 Yes Votes; 0 No Votes In Process $0 Storage Building Roof Replacement, and PW Roof and Residing Building No. 2 Siding and Gutter Replacements to Western Washington Construction, LTD A Request of the City Council of Ocean Shores, WA, awarding the Central Pump Station Roof and Siding Replacements, Water Treatment Plan Reducing expense for Treatment Plant Building May 8, 2023 $37,500.00 ($14,974.48) 434 - Water Fund 434.921.000.534.00.48.00 Passed 5 Yes Votes; 0 No Votes In Process $0 Storage Building Roof Replacement, and PW Roof and Gutters Building No. 2 Siding and Gutter Replacements to Western Washington Construction, LTD A Request of the City Council of Ocean Shores, WA, awarding the Central Pump Station Roof Adding additional expense for Old Collections May 8, 2023 and Siding Replacements, Water Treatment Plan $18,750.00 $4,315.55 435 - Sewer Fund 435.640.000.535.00.48.00 Passed 5 Yes Votes; 0 No Votes In Process $0 Storage Building Roof Replacement, and PW Gutters and Siding Building No. 2 Siding and Gutter Replacements to Western Washington Construction, LTD Page 8 of 9 4. Development and Grant Activity Update Presented by: Grant Manager, Sa... Grant Summary Finance Committee 06.20.23 Award Year Grant Title Pass Through Agency Agency Department Purpose Project Amount Award Match Amount End Date Status Carry Over 2023 NOTES ***ACTIVE*** Cowlitz Wahkiakum 2019 Surface Transportation Block Grant Set Aside - TA Funds Council of Governments DOT Public Works High Dune Trail 277,217.22 277,217.22 0.00 6/30/2023 In progress Yes TBD 2022 WSDOT - BIL FUNDS CWCOG DOT Public Works High Dune Trail 606,822.00 606,822.00 0.00 9/30/2025 In progress Yes TBD WA State Dept. of 2019 Vertical Evacuation Tower N/A Commerce Public Works construction and design of VES 490000 490000 0 6/30/2025 In progress YES TBD WA State Dept. of 2019 High Dune Trail N/A Commerce Public Works construction and design of trail 137200 137200 0 6/30/2025 In progress YES Carry over 137,200 (Robert allocated towards construction) 2020 Pre-Disaster Mitigation 2018 WA EMD FEMA Public Works Vertical Evacuation Structure 4,789,522.00 3,592,141.50 1,197,380.50 4/1/2024 In progress Yes TBD 2020 ***COVID-19*** Airport Coronavirus Response Grant Program Federal Aviation Admin. USDOT Airport Coronavirus Relief 20,000.00 20,000.00 0.00 7/15/2024 In progress To Spend Out to offset wages./fringe operating (not seperated out) 2021 Airport Improvement Program Federal Aviation Admin. US DOT Airport Design of obstruction removal 212,634.00 212,634.00 0.00 5/24/2025 Complete No Project complete. Awaiting Agency close out report and final reimbursement. 2022 Airport Improvement Program 615,287.78 553,759.00 61,528.78 7/5/2026 In progress Yes TBD Project mostly complete - some costs will be incurred in spring 2023 2022 Airport Improvement Program - BIL Funds 122,224.25 110,000.00 12,224.25 7/20/2026 In progress Yes TBD Project mostly complete - some costs will be incurred in spring 2023 General maintenance, operations & stopping 2021 ***Covid-19*** Airport Rescue Grant Program N/A FAA Airport spread of Covid-19 pathogens 22,000.00 22,000.00 0.00 10/26/2025 Not started YES Carry over 22,000 into 2023 Operations, janitorial services, sanization measures 2021 ***COVID-19*** Airport Coronavirus Response Grant Program Federal Aviation Admin. USDOT Airport for Covid-19 9,000.00 9,000.00 0.00 3/22/2025 Not started YES Carry over 9,000 into 2023 2021 Assistance to Firefighters 2020 N/A FEMA Fire Dept. New ambulance 228,731.42 217,839.45 10,891.97 8/22/2023 In progress YES Carry over 228,731.42 into 2023 (award 217,839.45 and match 10,891.97) Study to assess erosion issues and solutions @ 2021 CTP Risk Mapping N/A FEMA Public Works Marine View Drive 150,000.00 150,000.00 0.00 9/30/2022 In progress Yes TBD 2021 Bullet Proof Vest Program N/A DOJ Police Dept. Partially reimburse bullet proof vests for OSPD 3,456.00 1,728.00 1,728.00 8/31/2023 LAST DAY TO In progress Yes TBD Payment request still pending in system . 3-6 months to process. $618.01 claimed. Potential for more costs. Reimburse for damages, debris removal and 25% of all applicable INCUR COSTS 2021 DR-4539 2020 Public Assistance N/A FEMA Public Works associated costs for Jan. & Feb. 2020 storm expenses 10/23/2021 In progress Yes TBD 2021 Transportation Improvement Board - Pt. Brown Crosswalk N/A WSDOT Public Works Crosswalk between Pt. Brown & Shoal St. 259,292.00 169,721.00 89,571.00 1/25/2032 In progress Yes TBD 2022 Shoreline Master Plan Update Grant N/A WA Dept. of Ecology Planning Required SMP update by 06/30/23 16,800.00 16,800.00 0 6/30/2023 In progress Yes TBD partially reimburse bullet proof vests for OSPD 2022 Bullet Proof Vest Program N/A DOJ Police Dept. 4,907.22 2,453.61 2453.61 8/31/2024 Not started YES Carry over 2453.61 into 2023 2023 WCIA Risk Mitigation Grant N/A WCIA Police Dept. Dolphin Ave. traffic calming signage 7417.71 1483.71 0 12/5/2023 2023 WASPC Training WASPC DOJ Police Dept. Specific Training 10000 10000 0 6/30/2023 ACTIVE GRANT PROJECTS $8,734,779.73 ***PENDING*** Reimburse for damages associated with Jan. & Feb. 25% of all applicable 2021 DR-4593 2021 Public Assistance N/A FEMA Public Works 2021 storm expenses YES Working with agency on appropriate documentation 2022 FEMA Building Resilient Infrastructure and Communities WA EMD FEMA Public Works 3mg water storage seismic retrofit approx $800k 200k 2023 Assistance to Firefighters N/A FEMA Fire Dept. SCBA Compressors / SCBAs 331,293.15 2023 SAFER N/A FEMA Fire Dept. Three firefighter/EMTs 1,315,542.00 Page 9 of 9