Finance Committee Meeting

Agenda City of Ocean Shores Finance Committee Meeting Tuesday May 16, 2023 Zoom Meeting 3:00 PM Page Call to Order Financials 3 - 28 1. January 2023 Financial Statements • Presented by: Finance Director, Angela Folkers and Assistant Treasurer, Shante Nations 2. 2022 Annual Reports • Presented by: Finance Director, Angela Folkers 3. 2023-2024 Budget Amendment No. 1 • Presented by: Finance Director, Angela Folkers Police Department Report 4. Life Buoys • Presented by: Police Chief, Neccie Logan City Administrator Report 5. City Administrator's Monthly Update • Presented by: City Administrator, Scott Andersen Mayor Report 6. Mayor's Monthly Update • Presented by: Mayor, Jon Martin Adjourn _________________________________________________________ Public Notice: Page 1 of 28 Page • Persons requiring auxiliary aids or special arrangements in order to participate in meetings should call 360.940.7498 at least two business days prior to the scheduled meeting. Page 2 of 28  City of Ocean Shores January 2023 Financials - Executive Fund Summaries City of Ocean Shores 800 Anchor Ave NW Ocean Shores, Washington 98569 360-289-2488 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 3 of 28  This Page Intentionally Left Blank. 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 4 of 28  City of Ocean Shores January 2023 Executive Summary Narrative During the first quarter of each year we make a number of "annual" payments that impact the comparison of actual to budget performance. The payments cover insurance, and annual membership dues to state, county and local groups. We also do a number of one-time transfers in January to various funds. The annual payments and one-time transfers total $564,610 and are charged to multiple funds. Two of our main tax revenues are very cyclical. The bulk of our property taxes are paid to us primarily in May/June and Nov/Dec. This affects the General Fund (001) and EMS fund (104). The majority of our Hotel/Motel taxes are collected between July and November. This affects the Hotel/Motel fund (105). The following schedule indicates what our actual cash figures would look like if we "biennialized" the one-time "annual" expenses and transfers. It also shows the revenue adjustments to equalize fluctuations in property and hotel/motel tax receipts. It only shows the operating funds that are affected by these items. It will help to explain many of those situations where our actual revenues are more or less than planned and our expenses are more than planned throughout the biennium. 2023 Adjusted Performance for Selected Funds January Target is 4.17% (1/24 months) Revenue adjustments to equalize fluctuations in property tax and hotel/motel tax receipts Expense adjustments to biennialize one time payments and transfers made in the first quarter of each year Budgeted YTD Revenue Adj YTD % of Budgeted YTD Expense Adj YTD % of Fund Description Revenues Revenues Adjust Revenues Total Expenses Expenses Adjust Expenses Total 001 Legislative $ 210,100 $ 18,724 $ (12,433) $ 6,292 2.99% 001 Executive $ 594,561 $ 30,477 $ (12,261) $ 18,216 3.06% 001 City Hall $ 3,277,313 $ 192,033 $ (162,437) $ 29,597 0.90% 001 Fire $ 2,332,071 $ 97,006 $ (41,358) $ 55,648 2.39% 001 Municipal Vehicles $ 990,063 $ 38,129 $ (7,556) $ 30,573 3.09% 001 Planning $ 1,247,517 $ 67,393 $ (10,016) $ 57,377 4.60% 001 Total General Fund $ 21,189,295 $ 691,302 $ 263,641 $ 954,944 4.51% $ 21,685,775 $ 882,418 $ (246,059) $ 636,359 2.93% 101 Streets $ 1,675,455 $ 59,215 $ 59,215 3.53% $ 2,210,261 $ 82,963 $ (7,860) $ 75,103 3.40% 104 EMS $ 9,323,446 $ 185,784 $ 57,264 $ 243,048 2.61% $ 9,121,429 $ 342,911 $ (43,233) $ 299,678 3.29% 105 Hotel-Motel Tax $ 2,033,650 $ 58,942 $ 28,555 $ 87,497 4.30% $ 2,548,638 $ 106,193 $ - $ 106,193 4.17% 106 Convention Center $ 2,864,858 $ 99,434 $ 99,434 3.47% $ 2,717,180 $ 125,586 $ (54,637) $ 70,950 2.61% 434 Water $ 8,357,350 $ 289,450 $ 289,450 3.46% $ 8,817,329 $ 423,687 $ (62,105) $ 361,582 4.10% 435 Sewer $ 5,578,972 $ 211,204 $ 211,204 3.79% $ 5,868,332 $ 282,062 $ (100,239) $ 181,823 3.10% 438 Storm $ 3,131,200 $ 53,824 $ 53,824 1.72% $ 2,586,902 $ 54,660 $ (466) $ 54,195 2.09% 439 Sh Utility $ 1,001,750 $ 44,274 $ 44,274 4.42% $ 975,878 $ 33,422 $ - $ 33,422 3.42% 504 Severance $ 821,977 $ 16,750 $ 16,750 2.04% $ 802,000 $ 15,483 $ 15,483 1.93% Year to Date Comparison to 2022 Year to Date Comparison to 2021 2023 2022 % Change 2023 2021 % Change Property Taxes-GF $ 16,995 $ 9,108 87% Property Taxes-GF $ 16,995 $ 17,472 -3% Sales Taxes $ 122,467 $ 120,403 2% Sales Taxes $ 122,467 $ 96,997 26% Utility Taxes $ 182,261 $ 210,846 -14% Utility Taxes $ 182,261 $ 167,334 9% Building Permits $ 58,718 $ 53,084 11% Building Permits $ 58,718 $ 108,836 -46% Hotel/Motel Taxes $ 56,029 $ 74,917 -25% Hotel/Motel Taxes $ 56,029 $ 58,063 -4% Real Estate Excise Tax $ 22,317 $ 52,993 -58% Real Estate Excise Tax $ 22,317 $ 39,316 -43% Gasoline Taxes $ 9,831 $ 9,942 -1% Gasoline Taxes $ 9,831 $ 8,185 20% 2023-2024 Exec Narr JAN23 5/10/2023 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 5 of 28  City of Ocean Shores Monthly Cash Activity Summary - Per Actuals January 2023 Financial Report MTD Fund Description MTD Beg Balance MTD Revenues Ending Balance Expenditures 001 GENERAL FUND 3,183,911.22 691,302.48 882,417.58 2,992,796.12 002 CONTINGENCY FUND 352,365.37 0.00 0.00 352,365.37 003 CUMULATIVE RESERVE - ARPA 1,830,422.28 6,521.45 0.00 1,836,943.73 101 STREETS 574,172.74 59,214.96 82,962.95 550,424.75 102 GOLF COURSE 9,530.64 1,410.50 0.00 10,941.14 103 STREET RESERVE 378,636.94 1,349.01 5,746.35 374,239.60 104 EMERGENCY CARE 1,252,111.90 185,783.80 342,911.02 1,094,984.68 105 HOTEL-MOTEL TAX 817,804.15 58,942.21 106,193.25 770,553.11 106 CONVENTION/TOURISM & CATERING 267,444.45 99,434.21 125,586.08 241,292.58 107 CONFISCATED PROPERTY FUND 4,721.73 0.00 0.00 4,721.73 110 EQUIPMENT RESERVE 719,485.54 33,563.39 112,868.29 640,180.64 112 BOATING SAFETY 37,771.21 1,666.67 0.00 39,437.88 114 REPAIR & DEMOLITION 115,338.80 17,262.75 0.00 132,601.55 117 LID ADMINISTRATIVE COST 1,328,079.82 15,351.46 11,369.84 1,332,061.44 202 GO FIRE BOND REDEMPTION 10,615.92 32,481.25 0.00 43,097.17 206 GO CONV CENTER BOND REDEMPTION 377,352.33 55,693.51 0.00 433,045.84 213 LID BOND GUARANTY 452,601.32 1,612.53 10,599.67 443,614.18 214 LID 07-01 BOND REDEMPTION 900,751.83 46,909.16 0.00 947,660.99 301 CAPITAL IMPROVEMENT 2,655,009.21 48,497.73 78,479.91 2,625,027.03 320 WATER CAPITAL REPLACEMENT FUND 2,627,915.97 89,571.10 0.00 2,717,487.07 330 SEWER CAPITAL REPLACEMENT FUND 909,919.94 3,241.87 0.00 913,161.81 350 CONVENTION CENTER CAP IMPROVMT 806,456.83 27,873.25 0.00 834,330.08 373 FAA AIRPORT IMPROVEMENTS 0.00 0.00 0.00 0.00 406 MITIGATION LAND BANK 228,340.20 813.53 2,916.58 226,237.15 407 WATER-ARRA LOAD 2,745.09 12,825.83 0.00 15,570.92 408 WATER-CTED LOAD 1,874.76 7,494.83 0.00 9,369.59 409 W/S REVENUE BOND REDEMPTION 1,355.82 13,883.25 0.00 15,239.07 412 LID 95-01 BOND REDEMPTION 1,360.26 0.00 20.09 1,340.17 415 GO WATER/SEWER BOND REDEMPTION 158,737.38 1,549.91 5,715.52 154,571.77 417 LID 98-01 BOND REDEMPTION 7,969.92 0.00 0.00 7,969.92 420 WATER CAPITAL IMPROVEMENT FUND 1,434,278.31 29,043.73 20,320.66 1,443,001.38 430 SEWER CAPITAL IMPROVEMENT FUND 369,356.50 4,885.96 0.00 374,242.46 434 WATER UTILITY OPERATIONS 1,603,312.12 289,449.94 423,686.62 1,469,075.44 435 SEWER UTILITY OPERATIONS 1,248,024.81 211,204.16 282,061.88 1,177,167.09 438 STORM DRAIN UTILITY OPERATIONS 1,103,474.68 53,823.90 54,660.41 1,102,638.17 439 SHARED UTILITY FUND 40,073.88 44,274.09 33,422.44 50,925.53 503 UNEMPLOYMENT COMPENSATION FUND 126,752.79 451.60 0.00 127,204.39 504 SELF INSURANCE FUND 358,017.18 16,750.00 15,483.07 359,284.11 621 AVIATION SCHOLARSHIP TRUST 1,839.88 0.00 0.00 1,839.88 622 MUNICIPAL COURT TRUST 8,472.41 7,259.21 9,069.59 6,662.03 632 CLAIMS CLEARING 800,956.46 1,784,358.57 1,824,262.47 761,052.56 633 TREASURER'S CLEARING 3,995.68 586.76 450.00 4,132.44 634 TRANSPORT BENEFIT DISTRICT-TBD 1,156,599.20 32,187.99 5,746.25 1,183,040.94 TOTAL ALL FUNDS $ 28,269,957.47 $ 3,988,526.55 $ 4,436,950.52 $ 27,821,533.50 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 6 of 28  City of Ocean Shores All Fund Summary - Biennium Budget vs BTD Actuals January 2023 Financial Report 2023-2024 2023-2024 Fund Description BTD Revenues % of Total BTD Expenditures % of Total Revenues Appropriations 001 GENERAL FUND 21,189,294.61 691,302.48 3.26% 21,685,775.21 882,417.58 4.07% 002 CONTINGENCY FUND 0.00 0.00 0.00 0.00 003 CUMULATIVE RESERVE - ARPA 0.00 6,521.45 1,804,869.51 0.00 0.00% 101 STREETS 1,675,455.41 59,214.96 3.53% 2,210,261.00 82,962.95 3.75% 102 GOLF COURSE 0.00 1,410.50 0.00 0.00 103 STREET RESERVE 0.00 1,349.01 292,000.00 5,746.35 1.97% 104 EMERGENCY CARE 9,323,445.76 185,783.80 1.99% 9,121,428.66 342,911.02 3.76% 105 HOTEL-MOTEL TAX 2,033,650.00 58,942.21 2.90% 2,548,638.00 106,193.25 4.17% 106 CONVENTION/TOURISM & CATERING 2,864,858.00 99,434.21 3.47% 2,717,180.00 125,586.08 4.62% 110 EQUIPMENT RESERVE 744,000.00 33,563.39 4.51% 1,185,000.00 112,868.29 9.52% 112 BOATING SAFETY 40,000.00 1,666.67 4.17% 47,878.00 0.00 0.00% 114 REPAIR & DEMOLITION 0.00 17,262.75 80,000.00 0.00 0.00% 117 LID ADMINISTRATIVE COST 294,874.05 15,351.46 5.21% 419,340.00 11,369.84 2.71% 202 GO FIRE BOND REDEMPTION 779,550.00 32,481.25 4.17% 779,550.00 0.00 0.00% 206 GO CONV CENTER BOND REDEMPTION 1,052,950.00 55,693.51 5.29% 1,319,050.00 0.00 0.00% 213 LID BOND GUARANTY 1,000.00 1,612.53 161.25% 254,392.00 10,599.67 4.17% 214 LID 07-01 BOND REDEMPTION 2,502,000.00 46,909.16 1.87% 1,434,132.00 0.00 0.00% 301 CAPITAL IMPROVEMENT 6,513,124.00 48,497.73 0.74% 7,478,670.00 78,479.91 1.05% 320 WATER CAPITAL REPLACEMENT FUND 1,935,000.00 89,571.10 4.63% 2,425,000.00 0.00 0.00% 330 SEWER CAPITAL REPLACEMENT FUND 10,000.00 3,241.87 32.42% 380,000.00 0.00 0.00% 350 CONVENTION CENTER CAP IMPROVMT 600,000.00 27,873.25 4.65% 950,000.00 0.00 0.00% 373 FAA AIRPORT IMPROVEMENTS 500,000.00 0.00 0.00% 500,000.00 0.00 0.00% 406 MITIGATION LAND BANK 157,600.00 813.53 0.52% 96,998.00 2,916.58 3.01% 407 WATER-ARRA LOAD 308,320.00 12,825.83 4.16% 307,820.00 0.00 0.00% 408 WATER-CTED LOAD 180,476.00 7,494.83 4.15% 179,786.00 0.00 0.00% 409 W/S REVENUE BOND REDEMPTION 333,598.00 13,883.25 4.16% 333,198.00 0.00 0.00% 412 LID 95-01 BOND REDEMPTION 0.00 0.00 482.05 20.09 4.17% 415 GO WATER/SEWER BOND REDEMPTION 0.00 1,549.91 137,172.41 5,715.52 4.17% 417 LID 98-01 BOND REDEMPTION 0.00 0.00 0.00 0.00 420 WATER CAPITAL IMPROVEMENT FUND 888,200.00 29,043.73 3.27% 887,696.00 20,320.66 2.29% 430 SEWER CAPITAL IMPROVEMENT FUND 242,400.00 4,885.96 2.02% 0.00 0.00 434 WATER UTILITY OPERATIONS 8,357,350.00 289,449.94 3.46% 8,817,329.00 423,686.62 4.81% 435 SEWER UTILITY OPERATIONS 5,578,972.41 211,204.16 3.79% 5,868,332.00 282,061.88 4.81% 438 STORM DRAIN UTILITY OPERATIONS 3,131,200.00 53,823.90 1.72% 2,586,902.00 54,660.41 2.11% 439 SHARED UTILITY FUND 1,001,750.00 44,274.09 4.42% 975,878.00 33,422.44 3.42% 503 UNEMPLOYMENT COMPENSATION FUND 68,917.06 451.60 0.66% 50,000.00 0.00 0.00% 504 SELF INSURANCE FUND 821,977.00 16,750.00 2.04% 802,000.00 15,483.07 1.93% 634 TRANSPORT BENEFIT DISTRICT-TBD 800,000.00 32,187.99 4.02% 1,220,000.00 5,746.25 0.47% TOTAL ALL FUNDS $ 73,929,962.30 $ 2,196,322.01 2.97% $ 79,896,757.84 $ 2,603,168.46 3.26% 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 7 of 28  General Fund City of Ocean Shores January 2023 Financial Report 2023-2024 Biennium-to- Revenues % of Total Budget Date BEGINNING BALANCE AND REVENUES 308 - Beginning Balance 3,183,911.22 3,183,911.22 100.00% 010 - Taxes 15,381,808.00 409,060.89 2.66% 020 - Licenses and Permits 1,387,900.00 72,138.08 5.20% 030 - Intergovernmental 508,853.61 44,989.70 8.84% 040 - Charges for Goods and Services 172,950.00 3,234.45 1.87% 050 - Fines and Penalties 125,500.00 0.00 0.00% 060 - Miscellaneous 100,600.00 15,667.57 15.57% 080 - Nonrevenues 2,600.00 0.00 0.00% TOTAL REVENUES 17,680,211.61 545,090.69 3.08% TOTAL BEGINNING BALANCE AND REVENUES 20,864,122.83 3,729,001.91 17.87% OTHER REVENUES AND TRANSFERS IN Trf In - Cost Allocation/CE 101 422,754.00 17,614.75 4.17% Trf In - Cost Allocation/CE 104 820,295.00 34,178.96 4.17% Trf In - Cost Allocation/CE 106 278,510.00 11,604.58 4.17% Trf In - Cost Allocation/CE 117 30,913.00 1,288.04 4.17% Trf In - Cost Allocation/ce 434 828,503.00 34,520.96 4.17% Trf In - Cost Allocation/ce 435 765,764.00 31,906.83 4.17% Trf In - Cost Allocation/ce 438 256,116.00 10,671.50 4.17% Trf In - Cost Allocation/CE 439 106,228.00 4,426.17 4.17% TOTAL OTHER REVENUES AND TRANSFERS IN 3,509,083.00 146,211.79 4.17% GRAND TOTAL GENERAL FUND SOURCES 24,373,205.83 3,875,213.70 15.90% 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 8 of 28  This Page Intentionally Left Blank. 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 9 of 28  General Fund City of Ocean Shores January 2023 Financial Report APPROPRIATIONS/USES 2023-2024 % of Departments Biennium-to-Date Budget Total 001-110: Legislative 210,100.00 18,724.29 8.91% 001-120: Municipal Court 355,743.00 17,736.38 4.99% 001-130: Executive 594,561.00 30,476.55 5.13% 001-142: Finance 1,203,054.00 41,342.24 3.44% 001-143: City Clerk 604,345.00 24,507.64 4.06% 001-145: City Hall 3,277,313.00 192,033.19 5.86% 001-150: Legal Services 526,400.00 12,068.37 2.29% 001-160: Civil Service 9,400.00 0.00 0.00% 001-184: Purchasing 228,477.00 10,077.25 4.41% 001-210: Police 4,899,455.58 157,254.81 3.21% 001-220: Fire 2,332,070.86 97,005.54 4.16% 001-320: Engineering 184,339.00 4,675.38 2.54% 001-370: Litter Control 255,849.00 6,170.87 2.41% 001-390: Code Enforcement 442,021.72 17,709.09 4.01% 001-460: Airport 128,631.00 1,607.55 1.25% 001-480: Municipal Vehicles 990,063.00 38,128.63 3.85% 001-570: Radio Station 143,283.00 1,360.28 0.95% 001-580: Planning 1,247,517.00 67,392.52 5.40% 001-590: Building & Permitting 930,926.64 28,276.48 3.04% 001-720: Library 1,024,201.00 35,336.86 3.45% 001-760: Parks 324,469.00 6,635.52 2.05% TOTAL GENERAL FUND DEPARTMENT USES 19,912,219.80 808,519.44 4.06% 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 10 of 28  General Fund City of Ocean Shores January 2023 Financial Report 2023-2024 Biennium-to- Transfers Out % of Total Budget Date Trf Out-Street 101/CE 110 415,000.00 17,291.67 4.17% Trf Out-Fund Boating Safety 40,000.00 1,666.67 4.17% Trf Out-Gen Fund Hydrants/434 146,350.00 6,097.92 4.17% Trf Out-Golf Course 102 0.00 0.00 Trf Out-Self Ins 504 (leoff 1) 402,000.00 16,750.00 4.17% Trf Out-Street 101 770,205.41 32,091.88 4.17% Trf Out-Eqp Res 110/Litter Ctrl 0.00 0.00 Total Transfers Out 1,773,555.41 73,898.14 4.17% TOTAL EXPENDITURES & TRANSFERS OUT 21,685,775.21 882,417.58 GENERAL FUND ENDING BALANCE: 2,687,430.62 2,992,796.12 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 11 of 28  002 - Contingency Fund City of Ocean Shores January 2023 Financial Report 2023-24 Biennium-to- % of BEGINNING BALANCE AND REVENUES Budget Date Total 308 - Beginning Balance 352,365.37 352,365.37 100.00% 390 - Other Financing Sources/Trfs In 0.00 0.00 TOTAL REVENUES 0.00 0.00 #DIV/0! TOTAL BEGINNING BALANCE AND REVENUES 352,365.37 352,365.37 100.00% OPERATING EXPENDITURES 0.00 0.00 002 - CONTINGENCY FUND END BALANCE 352,365.37 352,365.37 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 12 of 28  003 - Cumulative Reserve - ARPA City of Ocean Shores January 2023 Financial Report 2023-24 Biennium-to- % of BEGINNING BALANCE AND REVENUES Budget Date Total 308 - Beginning Balance 1,830,422.28 1,830,422.28 330 - Intergovernmental 0.00 0.00 360 - Miscellaneous 0.00 6,521.45 TOTAL REVENUES 0.00 6,521.45 #DIV/0! TOTAL BEGINNING BALANCE AND REVENUES 1,830,422.28 1,836,943.73 100.4% OPERATING EXPENDITURES 40 - Other Services & Charges 1,804,869.51 0.00 TOTAL OPERATING EXPENDITURES 1,804,869.51 0.00 0.0% 003 - CUMULATIVE RESERVE - ARPA - END BALANCE 25,552.77 1,836,943.73 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 13 of 28  101 - Streets City of Ocean Shores January 2023 Financial Report 2023-24 Biennium-to- % of BEGINNING BALANCE AND REVENUES Budget Date Total 308 - Beginning Balance 574,172.74 574,172.74 100.00% 330 - Intergovernmental 480,000.00 9,831.41 2.05% 340 - Charges for Goods and Services 10,000.00 0.00 0.00% 360 - Miscellaneous 250.00 0.00 0.00% 390 - Other Financing Sources/Trfs In 1,185,205.41 49,383.55 4.17% TOTAL REVENUES 1,675,455.41 59,214.96 3.5% TOTAL BEGINNING BALANCE AND REVENUES 2,249,628.15 633,387.70 28.2% OPERATING EXPENDITURES 10 - Salaries & Wages 541,937.00 18,970.62 3.50% 20 - Personnel Benefits 284,485.00 15,805.93 5.56% 30 - Supplies 154,250.00 1,652.77 1.07% 40 - Other Services & Charges 191,835.00 11,582.21 6.04% 60 - Capital Outlays 200,000.00 45.00 0.02% 97 - Other Financing Uses/Transfers Out 837,754.00 34,906.42 4.17% TOTAL OPERATING EXPENDITURES 2,210,261.00 82,962.95 3.8% 101 - STREETS END BALANCE 39,367.15 550,424.75 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 14 of 28  102 - Golf Course City of Ocean Shores January 2023 Financial Report 2023-24 Biennium-to- % of BEGINNING BALANCE AND REVENUES Budget Date Total 308 - Beginning Balance 9,530.64 9,530.64 100.00% 360 - Miscellaneous 0.00 1,410.50 390 - Other Financing Sources/Trfs In 0.00 0.00 TOTAL REVENUES 0.00 1,410.50 #DIV/0! TOTAL BEGINNING BALANCE AND REVENUES 9,530.64 10,941.14 114.8% OPERATING EXPENDITURES 40 - Other Services & Charges 0.00 0.00 TOTAL OPERATING EXPENDITURES 0.00 0.00 #DIV/0! 102 - GOLF COURSE END BALANCE 9,530.64 10,941.14 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 15 of 28  103 - Street Reserve City of Ocean Shores January 2023 Financial Report 2023-24 Biennium-to- % of BEGINNING BALANCE AND REVENUES Budget Date Total 308 - Beginning Balance 378,636.94 378,636.94 100.00% 360 - Miscellaneous 0.00 1,349.01 390 - Other Financing Sources/Trfs In 0.00 0.00 TOTAL REVENUES 0.00 1,349.01 #DIV/0! TOTAL BEGINNING BALANCE AND REVENUES 378,636.94 379,985.95 100.4% OPERATING EXPENDITURES 40 - Other Services & Charges 292,000.00 5,746.35 1.97% TOTAL OPERATING EXPENDITURES 292,000.00 5,746.35 2.0% 103 - STREET RESERVE END BALANCE 86,636.94 374,239.60 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 16 of 28  104 - Emergency Care City of Ocean Shores January 2023 Financial Report 2023-24 Biennium-to- % of BEGINNING BALANCE AND REVENUES Budget Date Total 308 - Beginning Balance 1,252,111.90 1,252,111.90 100.00% 310 - Taxes 1,973,151.00 4,298.31 0.22% 330 - Intergovernmental 837,594.76 3,670.08 0.44% 340 - Charges for Goods and Services 6,500,200.00 173,239.35 2.67% 360 - Miscellaneous 12,500.00 4,576.06 36.61% 380 - Nonrevenues 0.00 0.00 390 - Other Financing Sources/Trfs In 0.00 0.00 TOTAL REVENUES 9,323,445.76 185,783.80 2.0% TOTAL BEGINNING BALANCE AND REVENUES 10,575,557.66 1,437,895.70 13.6% OPERATING EXPENDITURES 10 - Salaries & Wages 4,724,038.06 170,373.71 3.61% 20 - Personnel Benefits 1,853,919.10 64,069.09 3.46% 30 - Supplies 240,396.00 1,198.11 0.50% 40 - Other Services & Charges 544,960.00 48,705.95 8.94% 50 - Intergovernmental Services 67,240.00 2,671.61 3.97% 60 - Capital Outlays 349,454.50 0.00 0.00% 97 - Other Financing Uses/Transfers Out 1,341,421.00 55,892.55 4.17% TOTAL OPERATING EXPENDITURES 9,121,428.66 342,911.02 3.8% 104 - EMERGENCY CARE END BALANCE 1,454,129.00 1,094,984.68 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 17 of 28  105 - Hotel-Motel Tax City of Ocean Shores January 2023 Financial Report Biennium-to- % of 2023-24 Budget BEGINNING BALANCE AND REVENUES Date Total 308 - Beginning Balance 817,804.15 817,804.15 100.00% 310 - Taxes 2,030,000.00 56,028.53 2.76% 360 - Miscellaneous 3,650.00 2,913.68 79.83% 390 - Other Financing Sources/Trfs In 0.00 0.00 TOTAL REVENUES 2,033,650.00 58,942.21 2.9% TOTAL BEGINNING BALANCE AND REVENUES 2,851,454.15 876,746.36 30.7% OPERATING EXPENDITURES 97 - Other Financing Uses/Transfers Out 2,548,638.00 106,193.25 4.17% TOTAL OPERATING EXPENDITURES 2,548,638.00 106,193.25 4.2% 105 - HOTEL-MOTEL TAX END BALANCE 302,816.15 770,553.11 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 18 of 28  106 - Convention/Tourism & Catering City of Ocean Shores January 2023 Financial Report 2023-24 Biennium-to- % of BEGINNING BALANCE AND REVENUES Budget Date Total 308 - Beginning Balance 267,444.45 267,444.45 100.00% 330 - Intergovernmental 0.00 0.00 340 - Charges for Goods and Services 504,600.00 13,050.00 2.59% 360 - Miscellaneous 478,120.00 9,357.63 1.96% 380 - Nonrevenues 33,500.00 0.00 0.00% 390 - Other Financing Sources/Trfs In 1,848,638.00 77,026.58 4.17% TOTAL REVENUES 2,864,858.00 99,434.21 3.5% TOTAL BEGINNING BALANCE AND REVENUES 3,132,302.45 366,878.66 11.7% OPERATING EXPENDITURES 10 - Salaries & Wages 592,629.00 17,481.98 2.95% 20 - Personnel Benefits 311,041.00 7,744.31 2.49% 30 - Supplies 715,200.00 19,721.63 2.76% 40 - Other Services & Charges 796,800.00 64,988.78 8.16% 50 - Intergovernmental Services 23,000.00 4,044.80 17.59% 97 - Other Financing Uses/Transfers Out 278,510.00 11,604.58 4.17% TOTAL OPERATING EXPENDITURES 2,717,180.00 125,586.08 4.6% 106 - CONVENTION/TOURISM & CATERING END BALANCE 415,122.45 241,292.58 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 19 of 28  112 - Boating Safety City of Ocean Shores January 2023 Financial Report 2023-24 Biennium-to- % of BEGINNING BALANCE AND REVENUES Budget Date Total 308 - Beginning Balance 37,771.21 37,771.21 100.00% 330 - Intergovernmental 0.00 0.00 na 390 - Other Financing Sources/Trfs In 40,000.00 1,666.67 4.17% TOTAL REVENUES 40,000.00 1,666.67 4.2% TOTAL BEGINNING BALANCE AND REVENUES 77,771.21 39,437.88 50.7% OPERATING EXPENDITURES 10 - Salaries & Wages 13,798.00 0.00 0.00% 20 - Personnel Benefits 7,180.00 0.00 0.00% 30 - Supplies 7,400.00 0.00 0.00% 40 - Other Services & Charges 19,500.00 0.00 0.00% TOTAL OPERATING EXPENDITURES 47,878.00 0.00 0.0% 112 - BOATING SAFETY END BALANCE 29,893.21 39,437.88 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 20 of 28  434 - Water Utility Operations City of Ocean Shores January 2023 Financial Report 2023-24 Biennium-to- % of BEGINNING BALANCE AND REVENUES Budget Date Total 308 - Beginning Balance 1,603,312.12 1,603,312.12 100.00% 320 - Licenses and Permits 250,000.00 9,935.04 3.97% 330 - Intergovernmental 0.00 0.00 na 340 - Charges for Goods and Services 7,950,000.00 267,704.68 3.37% 350 - Fines and Penalties 0.00 0.00 na 360 - Miscellaneous 11,000.00 5,712.30 51.93% 380 - Nonrevenues 0.00 0.00 na 390 - Other Financing Sources/Trfs In 146,350.00 6,097.92 4.17% TOTAL REVENUES 8,357,350.00 289,449.94 3.5% TOTAL BEGINNING BALANCE AND REVENUES 9,960,662.12 1,892,762.06 19.0% OPERATING EXPENDITURES 10 - Salaries & Wages 1,313,699.00 61,665.55 4.69% 20 - Personnel Benefits 676,222.00 31,493.33 4.66% 30 - Supplies 1,001,670.00 67,543.68 6.74% 40 - Other Services & Charges 1,048,075.00 83,028.65 7.92% 50 - Intergovernmental Services 878,850.00 17,504.87 1.99% 97 - Other Financing Uses/Transfers Out 3,898,813.00 162,450.54 4.17% TOTAL OPERATING EXPENDITURES 8,817,329.00 423,686.62 4.8% 434 - WATER UTILITY OPERATIONS END BALANCE 1,143,333.12 1,469,075.44 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 21 of 28  435 - Sewer Utility Operations City of Ocean Shores January 2023 Financial Report Biennium-to- % of 2023-24 Budget BEGINNING BALANCE AND REVENUES Date Total 308 - Beginning Balance 1,248,024.81 1,248,024.81 100.00% 320 - Licenses and Permits 360,000.00 15,036.00 4.18% 330 - Intergovernmental 0.00 0.00 #DIV/0! 340 - Charges for Goods and Services 5,075,000.00 186,006.16 3.67% 360 - Miscellaneous 6,800.00 4,446.48 65.39% 390 - Other Financing Sources/ Trfs In 137,172.41 5,715.52 4.17% 380 - Nonrevenues 0.00 0.00 na TOTAL REVENUES 5,578,972.41 211,204.16 3.8% TOTAL BEGINNING BALANCE AND REVENUES 6,826,997.22 1,459,228.97 21.4% OPERATING EXPENDITURES 10 - Salaries & Wages 1,664,021.00 62,088.27 3.73% 20 - Personnel Benefits 928,662.00 39,145.47 4.22% 30 - Supplies 350,450.00 5,358.89 1.53% 40 - Other Services & Charges 1,308,265.00 126,237.81 9.65% 50 - Intergovernmental Services 495,205.00 5,393.00 1.09% 60 - Capital Outlays 57,250.00 -514.85 -0.90% 97 - Other Financing Uses/Transfers Out 1,064,479.00 44,353.29 4.17% TOTAL OPERATING EXPENDITURES 5,868,332.00 282,061.88 4.8% 435 - SEWER UTILITY OPERATIONS END BALANCE 958,665.22 1,177,167.09 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 22 of 28  438 - Storm Drain Utility Operations City of Ocean Shores January 2023 Financial Report Biennium-to- % of 2023-24 Budget BEGINNING BALANCE AND REVENUES Date Total 308 - Beginning Balance 1,103,474.68 1,103,474.68 100.00% 330 - Intergovernmental 0.00 0.00 #DIV/0! 340 - Charges for Goods and Services 3,125,000.00 49,892.43 1.60% 360 - Miscellaneous 6,200.00 3,931.47 63.41% 380 - Nonrevenues 0.00 0.00 na 390 - Other Financing Sources/Trfs In 0.00 0.00 #DIV/0! TOTAL REVENUES 3,131,200.00 53,823.90 1.7% TOTAL BEGINNING BALANCE AND REVENUES 4,234,674.68 1,157,298.58 27.3% OPERATING EXPENDITURES 10 - Salaries & Wages 517,292.00 13,825.62 2.67% 20 - Personnel Benefits 296,897.00 8,564.87 2.88% 30 - Supplies 82,680.00 1,169.26 1.41% 40 - Other Services & Charges 1,009,870.00 11,276.53 1.12% 50 - Intergovernmental Services 250,000.00 1,900.67 0.76% 97 - Other Financing Uses/Transfers Out 430,163.00 17,923.46 4.17% TOTAL OPERATING EXPENDITURES 2,586,902.00 54,660.41 2.1% 438 - STORM DRAIN UTILITY OPERATIONS END BALANCE 1,647,772.68 1,102,638.17 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 23 of 28  439 - Shared Utility Fund City of Ocean Shores January 2023 Financial Report Biennium-to- % of 2023-24 Budget BEGINNING BALANCE AND REVENUES Date Total 308 - Beginning Balance 40,073.88 40,073.88 100.00% 340 - Charges for Goods and Services 40,500.00 1,437.50 3.55% 350 - Fines and Penalties 161,000.00 9,503.25 5.90% 360 - Miscellaneous 250.00 0.00 0.00% 390 - Other Financing Sources/Trfs In 800,000.00 33,333.34 4.17% TOTAL REVENUES 1,001,750.00 44,274.09 4.4% TOTAL BEGINNING BALANCE AND REVENUES 1,041,823.88 84,347.97 8.1% OPERATING EXPENDITURES 10 - Salaries & Wages 302,018.00 11,417.95 3.78% 20 - Personnel Benefits 166,009.00 6,014.44 3.62% 30 - Supplies 50,000.00 275.44 0.55% 40 - Other Services & Charges 337,500.00 11,140.36 3.30% 50 - Intergovernmental Services 14,123.00 148.08 1.05% 97 - Other Financing Uses/Transfers Out 106,228.00 4,426.17 4.17% TOTAL OPERATING EXPENDITURES 975,878.00 33,422.44 3.4% 439 - SHARED UTILITY FUND END BALANCE 65,945.88 50,925.53 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 24 of 28  503 - Unemployment Compensation Fund City of Ocean Shores January 2023 Financial Report 2023-23 Biennium-to- % of BEGINNING BALANCE AND REVENUES Budget Date Total 308 - Beginning Balance 126,752.79 126,752.79 100.00% 330 - Intergovernmental 0.00 0.00 na 360 - Miscellaneous 68,917.06 451.60 0.66% TOTAL REVENUES 68,917.06 451.60 0.7% TOTAL BEGINNING BALANCE AND REVENUES 195,669.85 127,204.39 65.0% OPERATING EXPENDITURES 50 - Intergovernmental Services 50,000.00 0.00 0.00% TOTAL OPERATING EXPENDITURES 50,000.00 0.00 0.0% 503 - UNEMPLOYMENT COMPENSATION FUND END BALANCE 145,669.85 127,204.39 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 25 of 28  504 - Self Insurance Fund City of Ocean Shores January 2023 Financial Report Biennium-to- % of 2023-24 Budget BEGINNING BALANCE AND REVENUES Date Total 308 - Beginning Balance 358,017.18 358,017.18 100.00% 360 - Miscellaneous 419,977.00 0.00 0.00% 390 - Other Financing Sources/Trfs In 402,000.00 16,750.00 4.17% TOTAL REVENUES 821,977.00 16,750.00 2.0% TOTAL BEGINNING BALANCE AND REVENUES 1,179,994.18 374,767.18 31.8% OPERATING EXPENDITURES 10 - Salaries & Wages 0.00 0.00 na 20 - Personnel Benefits 802,000.00 15,483.07 1.93% TOTAL OPERATING EXPENDITURES 802,000.00 15,483.07 1.9% 504 - SELF INSURANCE FUND END BALANCE 377,994.18 359,284.11 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 26 of 28  634 - Transport Benefit District-TBD City of Ocean Shores January 2023 Financial Report 2023-24 Biennium-to- % of Total BEGINNING BALANCE AND REVENUES Budget Date 308 - Beginning Balance 1,156,599.20 1,156,599.20 100.00% 310 - Taxes 800,000.00 28,067.25 3.51% 360 - Miscellaneous 0.00 4,120.74 na TOTAL REVENUES 800,000.00 32,187.99 4.0% TOTAL BEGINNING BALANCE AND REVENUES 1,956,599.20 1,188,787.19 60.8% OPERATING EXPENDITURES 50 - Intergovernmental Services 1,220,000.00 5,746.25 0.47% TOTAL OPERATING EXPENDITURES 1,220,000.00 5,746.25 0.5% 634 - TRANSPORT BENEFIT DISTRICT-TBD END BALANCE 736,599.20 1,183,040.94 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 27 of 28  This Page Intentionally Left Blank. 1. January 2023 Financial Statements Presented by: Finance Director, Ang... Page 28 of 28