Finance Committee Meeting

Agenda City of Ocean Shores Finance Committee Meeting Join Zoom Meeting Online Click Here Join Zoom Meeting by Phone Phone Number: 1.253.215.8782 Meeting ID: 845 5745 1488 Passcode: 607880 Thursday Ocean Shores Library May 22, 2025 573 Point Brown Ave NW 5:00PM Ocean Shores, Washington Page Call to Order Financials 2 - 10 1. 2025 April Financial Update  Presented by: Finance Director, Sara D. Logan 11 - 14 2. Cost Allocation  Led by: Finance Director, Sara D. Logan 3. Revenue and Expense Fund Cleanup Project  Led by: Finance Director, Sara D. Logan Office of the Washington State Auditor - Object Codes/Charts of Accounts 2019-2020/2021-2022/2023-2024 Revenue and Expense Documentation Future Meeting Date Thursday, June 26, 2025 at 5:00pm in the Ocean Shores Library Meeting Room. Adjourn _________________________________________________________ Public Notice:  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 1 of 14  City of Ocean Shores April 2025 - Executive and General Fund Summaries City of Ocean Shores 800 Anchor Ave NW Ocean Shores, Washington 98569 360-289-2488 1. 2025 April Financial Update Presented by: Finance Director, Sara D. L... Page 2 of 14  This Page Intentionally Left Blank. 1. 2025 April Financial Update Presented by: Finance Director, Sara D. L... Page 3 of 14  City of Ocean Shores April 2025 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. 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. 2025 Adjusted Performance for Selected Funds April Target is 16.67% (04/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 BTD % of Budgeted BTD % of Fund Description Revenues Revenues Total Expenses Expenses Total 001 Legislative $ 253,200 $ 20,091 7.93% 001 Executive $ 853,514 $ 119,441 13.99% 001 City Hall $ 3,450,294 $ 1,510,855 43.79% 001 Fire $ 2,726,445 $ 417,718 15.32% 001 Municipal Vehicles $ 1,146,454 $ 228,620 19.94% 001 Planning $ 855,595 $ 177,390 20.73% 001 Total General Fund $ 24,024,940 $ 4,083,457 17.00% $ 25,266,528 $ 4,900,294 19.39% 101 Streets $ 1,655,837 $ 267,278 16.14% $ 1,740,817 $ 212,895 12.23% 104 EMS $ 9,731,429 $ 1,427,110 14.66% $ 9,815,629 $ 1,635,221 16.66% 105 Hotel-Motel Tax $ 2,424,400 $ 257,178 10.61% $ 3,024,638 $ 504,108 16.67% 106 Convention Center $ 3,958,976 $ 565,531 14.28% $ 3,965,739 $ 863,209 21.77% 434 Water $ 8,743,100 $ 1,444,927 16.53% $ 9,009,274 $ 1,669,556 18.53% 435 Sewer $ 5,592,305 $ 952,045 17.02% $ 6,434,806 $ 1,136,155 17.66% 438 Storm $ 3,310,000 $ 720,510 21.77% $ 2,969,613 $ 339,840 11.44% 439 Sh Utility $ 1,063,100 $ 177,484 16.69% $ 981,784 $ 239,651 24.41% 504 Severance $ 833,400 $ 131,499 15.78% $ 827,000 $ 13,473 1.63% Year to Date Comparison to 2024 Year to Date Comparison to 2023 2025 2024 % Change 2025 2023 % Change Property Taxes- GF $ 535,094 $ 507,645 5% Property Taxes-GF $ 535,094 $ 591,736 -10% Sales Taxes $ 505,279 $ 511,552 -1% Sales Taxes $ 505,279 $ 517,054 -2% Utility Taxes $ 617,022 $ 604,105 2% Utility Taxes $ 617,022 $ 667,334 -8% Building Permits $ 256,762 $ 238,653 8% Building Permits $ 256,762 $ 206,635 24% Hotel/Motel Taxes $ 267,069 $ 263,961 1% Hotel/Motel Taxes $ 267,069 $ 383,975 -30% Real Estate Excise Tax $ 101,846 $ 112,721 -10% Real Estate Excise T $ 101,846 $ 135,928 -25% Gasoline Taxes $ 33,054 $ 39,558 -16% Gasoline Taxes $ 33,054 $ 39,258 -16% April 2025 Financial Report APR25 5/12/2025 1. 2025 April Financial Update Presented by: Finance Director, Sara D. L... Page 4 of 14  City of Ocean Shores Monthly Cash Activity Summary - Per Actuals April 2025 Financial Report MTD Fund Description MTD Beg Balance MTD Revenues Ending Balance Expenditures 001 GENERAL FUND 2,450,618.83 1,797,083.36 967,399.70 3,280,302.49 002 CONTINGENCY FUND 352,365.37 0.00 0.00 352,365.37 003 CUMULATIVE RESERVE - ARPA 712,817.35 2,442.38 0.00 715,259.73 101 STREETS 40,705.24 64,311.72 46,592.31 58,424.65 102 GOLF COURSE 39,102.49 9,000.00 628.72 47,473.77 103 STREET RESERVE 333,297.65 1,142.00 0.00 334,439.65 104 EMERGENCY CARE 1,312,794.49 531,710.46 409,782.43 1,434,722.52 105 HOTEL-MOTEL TAX 514,365.59 67,170.42 126,027.00 455,509.01 106 CONVENTION/TOURISM & CATERING 151,333.76 89,754.12 110,082.06 131,005.82 107 CONFISCATED PROPERTY FUND 4,721.73 0.00 0.00 4,721.73 110 EQUIPMENT RESERVE 241,097.34 826.09 0.00 241,923.43 112 BOATING SAFETY 54,022.06 1,667.00 0.00 55,689.06 114 REPAIR & DEMOLITION 87,183.64 0.00 0.00 87,183.64 117 LID ADMINISTRATIVE COST 1,564,168.24 15,906.42 22,285.64 1,557,789.02 202 GO FIRE BOND REDEMPTION 107,461.92 32,482.00 0.00 139,943.92 206 GO CONV CENTER BOND REDEMPTION 556,493.15 49,459.17 0.00 605,952.32 213 LID BOND GUARANTY 202,331.03 693.26 10,527.00 192,497.29 214 LID 07-01 BOND REDEMPTION 133,052.24 9,937.48 0.00 142,989.72 301 CAPITAL IMPROVEMENT 1,881,979.93 98,878.49 190,800.54 1,790,057.88 320 WATER CAPITAL REPLACEMENT FUND 4,897,386.70 96,988.27 0.00 4,994,374.97 330 SEWER CAPITAL REPLACEMENT FUND 593,824.40 2,034.66 0.00 595,859.06 350 CONVENTION CENTER CAP IMPROVMT 1,148,912.47 39,353.60 0.00 1,188,266.07 373 FAA AIRPORT IMPROVEMENTS 70,842.63 0.00 0.00 70,842.63 406 MITIGATION LAND BANK 439,803.99 8,886.93 2,917.00 445,773.92 407 WATER-ARRA LOAD 41,224.27 12,826.00 0.00 54,050.27 408 WATER-CTED LOAD 24,449.88 7,495.00 0.00 31,944.88 409 W/S REVENUE BOND REDEMPTION 43,604.98 13,883.00 0.00 57,487.98 412 LID 95-01 BOND REDEMPTION 818.10 0.00 20.00 798.10 415 GO WATER/SEWER BOND REDEMPTION 45,204.55 156.58 3,013.00 42,348.13 417 LID 98-01 BOND REDEMPTION 7,969.92 0.00 0.00 7,969.92 420 WATER CAPITAL IMPROVEMENT FUND 1,853,976.87 31,835.41 20,321.00 1,865,491.28 430 SEWER CAPITAL IMPROVEMENT FUND 635,529.82 10,847.56 0.00 646,377.38 434 WATER UTILITY OPERATIONS 947,456.96 394,995.60 434,466.80 907,985.76 435 SEWER UTILITY OPERATIONS 1,156,628.79 286,202.63 260,970.58 1,181,860.84 438 STORM DRAIN UTILITY OPERATIONS 2,588,867.40 138,812.23 85,734.92 2,641,944.71 439 SHARED UTILITY FUND 37,751.59 43,509.87 47,480.41 33,781.05 503 UNEMPLOYMENT COMPENSATION FUND 183,208.01 2,328.87 0.00 185,536.88 504 SELF INSURANCE FUND 486,613.27 33,252.26 22,186.61 497,678.92 621 AVIATION SCHOLARSHIP TRUST 1,842.58 0.00 0.00 1,842.58 622 MUNICIPAL COURT TRUST 16,596.84 7,386.28 8,681.56 15,301.56 632 CLAIMS CLEARING 591,968.60 1,952,028.39 2,094,864.01 449,132.98 633 TREASURER'S CLEARING 5,375.06 646.50 324.00 5,697.56 634 TRANSPORT BENEFIT DISTRICT-TBD 2,268,549.68 33,051.61 0.00 2,301,601.29 TOTAL ALL FUNDS $ 28,828,319.41 $ 5,888,985.62 $ 4,865,105.29 $ 29,852,199.74 1. 2025 April Financial Update Presented by: Finance Director, Sara D. L... Page 5 of 14  City of Ocean Shores All Fund Summary - Biennium Budget vs BTD Actuals April 2025 Financial Report 2025-2026 2025-2026 Fund Description BTD Revenues % of Total BTD Expenditures % of Total Revenues Appropriations 001 GENERAL FUND 24,024,939.72 4,083,456.97 17.00% 25,266,527.86 4,900,294.47 19.39% 002 CONTINGENCY FUND 0.00 0.00 0.00 0.00 003 CUMULATIVE RESERVE - ARPA 0.00 9,992.27 580,430.00 50,441.50 8.69% 101 STREETS 1,655,837.26 267,277.88 16.14% 1,740,817.25 212,895.09 12.23% 102 GOLF COURSE 216,250.00 36,000.00 16.65% 120,000.00 23,559.34 19.63% 103 STREET RESERVE 20,000.00 4,553.44 22.77% 0.00 14,839.00 104 EMERGENCY CARE 9,731,428.50 1,427,110.00 14.66% 9,815,628.96 1,635,221.48 16.66% 105 HOTEL-MOTEL TAX 2,424,400.00 257,178.35 10.61% 3,024,638.00 504,108.00 16.67% 106 CONVENTION/TOURISM & CATERING 3,958,976.00 565,530.73 14.28% 3,965,739.16 863,208.73 21.77% 110 EQUIPMENT RESERVE 40,000.00 3,256.33 8.14% 235,000.00 0.00 0.00% 112 BOATING SAFETY 44,000.00 6,668.00 15.15% 49,454.95 0.00 0.00% 114 REPAIR & DEMOLITION 0.00 0.00 65,000.00 0.00 0.00% 117 LID ADMINISTRATIVE COST 313,125.16 63,266.31 20.20% 329,739.94 48,018.88 14.56% 202 GO FIRE BOND REDEMPTION 779,540.00 129,928.00 16.67% 779,550.00 0.00 0.00% 206 GO CONV CENTER BOND REDEMPTION 1,230,800.00 212,925.66 17.30% 1,309,050.00 0.00 0.00% 213 LID BOND GUARANTY 20,000.00 2,945.41 14.73% 252,643.00 42,108.00 16.67% 214 LID 07-01 BOND REDEMPTION 1,332,176.00 88,558.95 6.65% 1,579,732.00 606,987.46 38.42% 301 CAPITAL IMPROVEMENT 6,783,450.00 358,256.73 5.28% 6,863,802.36 774,603.60 11.29% 320 WATER CAPITAL REPLACEMENT FUND 2,125,000.00 385,357.28 18.13% 2,425,000.00 0.00 0.00% 330 SEWER CAPITAL REPLACEMENT FUND 50,000.00 9,308.97 18.62% 380,000.00 248,962.57 65.52% 350 CONVENTION CENTER CAP IMPROVMT 920,680.00 157,282.48 17.08% 910,379.44 232,635.87 25.55% 373 FAA AIRPORT IMPROVEMENTS 401,254.00 0.00 0.00% 472,097.56 0.00 0.00% 406 MITIGATION LAND BANK 283,509.04 20,752.51 7.32% 93,998.00 16,668.00 17.73% 407 WATER-ARRA LOAD 308,865.45 51,304.00 16.61% 307,820.00 0.00 0.00% 408 WATER-CTED LOAD 181,054.54 29,980.00 16.56% 179,706.00 0.00 0.00% 409 W/S REVENUE BOND REDEMPTION 334,036.36 55,532.00 16.62% 333,798.00 0.00 0.00% 412 LID 95-01 BOND REDEMPTION 0.00 0.00 484.00 80.00 16.53% 415 GO WATER/SEWER BOND REDEMPTION 25,000.00 683.33 2.73% 72,305.40 12,052.00 16.67% 417 LID 98-01 BOND REDEMPTION 0.00 0.00 0.00 0.00 420 WATER CAPITAL IMPROVEMENT FUND 957,000.00 123,582.71 12.91% 887,696.00 81,284.00 9.16% 430 SEWER CAPITAL IMPROVEMENT FUND 230,000.00 35,013.40 15.22% 580,000.00 0.00 434 WATER UTILITY OPERATIONS 8,743,100.00 1,444,926.57 16.53% 9,009,274.44 1,669,555.64 18.53% 435 SEWER UTILITY OPERATIONS 5,592,305.40 952,044.69 17.02% 6,434,806.46 1,136,155.44 17.66% 438 STORM DRAIN UTILITY OPERATIONS 3,310,000.00 720,509.98 21.77% 2,969,613.38 339,840.24 11.44% 439 SHARED UTILITY FUND 1,063,100.00 177,483.97 16.69% 981,784.36 239,651.44 24.41% 503 UNEMPLOYMENT COMPENSATION FUND 45,600.00 9,110.90 19.98% 50,000.00 0.00 0.00% 504 SELF INSURANCE FUND 833,400.00 131,498.85 15.78% 827,000.00 13,472.95 1.63% 634 TRANSPORT BENEFIT DISTRICT-TBD 984,200.00 147,467.76 14.98% 1,220,000.00 0.00 0.00% TOTAL ALL FUNDS $ 78,963,027.43 $ 11,968,744.43 15.16% $ 84,113,516.52 $ 13,666,643.70 16.25% 1. 2025 April Financial Update Presented by: Finance Director, Sara D. L... Page 6 of 14  General Fund City of Ocean Shores April 2025 Financial Report 2025-2026 Biennium-to- Revenues % of Total Budget Date BEGINNING BALANCE AND REVENUES 308 - Beginning Balance 4,097,139.99 4,097,139.99 100.00% 010 - Taxes 16,657,893.00 1,960,469.03 11.77% 020 - Licenses and Permits 1,663,700.00 307,443.02 18.48% 030 - Intergovernmental 558,344.72 835,544.91 149.65% 040 - Charges for Goods and Services 200,880.00 49,819.90 24.80% 050 - Fines and Penalties 60,900.00 8,336.96 13.69% 060 - Miscellaneous 348,700.00 166,082.10 47.63% 080 - Nonrevenues 3,600.00 605.05 16.81% TOTAL REVENUES 19,494,017.72 3,328,300.97 17.07% TOTAL BEGINNING BALANCE AND REVENUES 23,591,157.71 7,425,440.96 31.48% OTHER REVENUES AND TRANSFERS IN Trf In - Cost Allocation/CE 101 341,756.00 56,960.00 16.67% Trf In - Cost Allocation/CE 104 1,005,937.00 167,656.00 16.67% Trf In - Cost Allocation/CE 106 630,510.00 105,084.00 16.67% Trf In - Cost Allocation/CE 416 27,038.00 4,508.00 16.67% Trf In - Cost Allocation/ce 434 1,291,258.00 215,208.00 16.67% Trf In - Cost Allocation/ce 435 807,794.00 134,632.00 16.67% Trf In - Cost Allocation/ce 438 304,936.00 50,824.00 16.67% Trf In - Cost Allocation/CE 439 121,693.00 20,284.00 16.67% TOTAL OTHER REVENUES AND TRANSFERS IN 4,530,922.00 755,156.00 16.67% GRAND TOTAL GENERAL FUND SOURCES 28,122,079.71 8,180,596.96 29.09% 1. 2025 April Financial Update Presented by: Finance Director, Sara D. L... Page 7 of 14  General Fund City of Ocean Shores April 2025 Financial Report APPROPRIATIONS/USES 2025-2026 % of Departments Biennium-to-Date Budget Total 001-110: Legislative 253,200.00 20,091.15 7.93% 001-120: Municipal Court 374,665.78 64,972.37 17.34% 001-130: Executive 853,514.02 119,441.49 13.99% 001-142: Finance 1,137,733.08 211,848.17 18.62% 001-143: City Clerk 901,621.37 136,292.89 15.12% 001-145: City Hall 3,450,294.27 1,510,854.52 43.79% 001-150: Legal Services 578,480.00 76,186.26 13.17% 001-160: Civil Service 3,500.00 488.75 13.96% 001-184: Purchasing 241,543.24 41,373.29 17.13% 001-210: Police 6,047,872.77 859,170.30 14.21% 001-220: Fire 2,726,445.20 417,717.62 15.32% 001-320: Engineering 339,546.96 41,001.83 12.08% 001-370: Litter Control 426,678.90 27,547.98 6.46% 001-390: Code Enforcement 352,114.46 78,483.88 22.29% 001-460: Airport 151,790.42 16,315.76 10.75% 001-480: Municipal Vehicles 1,146,453.68 228,620.01 19.94% 001-570: Radio Station 144,600.00 21,085.33 14.58% 001-580: Planning 855,595.28 177,389.71 20.73% 001-590: Building & Permitting 511,680.95 98,241.15 19.20% 001-720: Library 1,063,165.64 165,137.48 15.53% 001-760: Parks 586,344.58 68,082.53 11.61% TOTAL GENERAL FUND DEPARTMENT USES 22,146,840.60 4,380,342.47 19.78% 1. 2025 April Financial Update Presented by: Finance Director, Sara D. L... Page 8 of 14  This Page Intentionally Left Blank. 1. 2025 April Financial Update Presented by: Finance Director, Sara D. L... Page 9 of 14  General Fund City of Ocean Shores April 2025 Financial Report 2025-2026 Biennium-to- Transfers Out % of Total Budget Date Trf Out-Street 101 1,405,337.26 234,224.00 16.67% Trf Out-Fund Boating Safety 40,000.00 6,668.00 16.67% Trf Out-Gen Fund Hydrants/434 146,350.00 24,392.00 16.67% Trf Out-Golf Course 102 216,000.00 36,000.00 16.67% Trf Out-Self Ins 504 (leoff 1) 340,000.00 56,668.00 16.67% Trf Out 301 - Gen Fund Surplus 650,000.00 108,332.00 16.67% Trf Out Fund 301/SCBA Reserve 322,000.00 53,668.00 16.67% Total Transfers Out 3,119,687.26 519,952.00 16.67% TOTAL EXPENDITURES & TRANSFERS OUT 25,266,527.86 4,900,294.47 GENERAL FUND ENDING BALANCE: 2,855,551.85 3,280,302.49 1. 2025 April Financial Update Presented by: Finance Director, Sara D. L... Page 10 of 14  City of Ocean Shores Cost Allocation Plan Background Indirect cost allocation is a method to determine and assign the cost of central services to the internal users of those services. Cost allocation enables local governments to more accurately account for the complete cost of the services it provides, and to provide a clear/concise method to use in budget development. Indirect costs include central services costs related to legislative, executive, finance, city clerk, city hall, legal, purchasing and municipal vehicles. Cost allocation plans share indirect costs across programs, activities, funds and departments. The term “allocation” implies that there is no precise method for charging indirect costs, however cost allocations should be designed to provide a consistent, reasonable and equitable means to allocate costs. Funds to Be Charged An indirect cost allocation plan is intended to charge restricted funds for a fair and equitable portion of central services costs. The City has two fund types that could be eligible for indirect cost allocation – special revenue funds and enterprise funds. Special revenue funds must be at least partially funded by an externally restricted or internally assigned revenue source; however, the special revenue funds can be, and many are, subsidized by the general fund. Therefore, there is no benefit to be had by including most special revenue funds in the indirect cost allocation plan (increasing expenditures in funds subsidized by the general fund would simply increase the amount of general fund subsidy required). The City currently has two special revenue funds, Convention Tourism and Emergency Care, which are significant in size and do not receive general fund subsidies. These are the only special revenue funds included in the cost allocation plan. The City’s enterprise funds must be self-supporting and cannot receive general fund support in the form of subsidization or services provided at no charge. An indirect cost allocation plan is the appropriate way to charge enterprise funds for services provided by the general fund. The City’s current enterprise funds subject to allocation are Water Utility, Sewer Utility, and Storm Utility. The cost allocation plan shall be developed based on the principle that costs will be split between general government activities (those pertaining to the general fund and special revenue funds) and enterprise activities. Enterprise activities will be further allocated by fund, based on the criteria described below. General government activities will remain in the general fund, with the exception of the portion fairly related to Convention Tourism and Emergency Care. DRAFT 5.7.2025 2. Cost Allocation Led by: Finance Director, Sara D. Logan Page 11 of 14  Costs to Be Allocated The following costs are subject to allocation: - Salaries, benefits, supplies, training, equipment, etc. associated with: o Mayor and City Council (Legislative Department 001-110) o City Administrator/Mayor (Executive Department 001-130) o Finance Department (001-142) o City Clerk (001-143) o Utility Billing (001-14x) new department, currently fund 439 o City Hall (001-145) o Legal Services (001-150) o Purchasing (001-184) o Municipal Vehicles (001-480) Costs listed above are paid for out of the general fund and primarily exist for the support of the City as a whole. Costs included in the allocation plan should be administrative in nature and must be reasonably perceived to benefit all City funds. Therefore, the cost of services such as public safety, street maintenance, community events, etc. are excluded from the plan and are not subject to allocation. Activities & Measurement Criteria The activities on which to base allocations and the measurement criteria for those activities are identified in the following table. ACTIVITIES MEASUREMENT CRITERIA Payroll Salaries/benefits expense Human Resources Salaries/benefits expense Accounts Payable Non-salary expenses Mayor and Council Quantity of agenda items General accounting & administration Total expenses w/out transfers or debt service Utility Billing Utility revenue Budget & Accounting Procedures 1/24th of the budgeted overhead allocation for the biennium will be charged each month. At year end, actual costs shall be input into the plan and a year-end adjustment processed. The adjustment should be based on actual cost inputs into the plan (i.e., actual costs incurred by the “charging” General Fund departments). The allocation factors (each “receiving” department’s proportionate share) will not be updated as part of the year end adjustment. The purpose of the year end adjustment is to allocate the correct total cost, but not to change the percentages charged to each fund. The cost allocation plan should be reviewed during each budget development cycle. It is not necessary to update the activities or measurement criteria on an annual or bi-annual basis if the plan has been reviewed for general reasonableness. If significant changes have been made which may affect the overall DRAFT 5.7.2025 2. Cost Allocation Led by: Finance Director, Sara D. Logan Page 12 of 14  allocation percentages then the plan should be updated. The plan should be updated at least every four years. Costs Excluded from Allocation This plan assumes that fuel and vehicle repair/maintenance will be directly charged to the receiving department as costs are incurred. Any remaining costs which cannot be directly charged (salaries, benefits, general shop supplies, etc.) will be charged to 001-480 and allocated based on the % of direct vehicle repair and maintenance costs. DRAFT 5.7.2025 2. Cost Allocation Led by: Finance Director, Sara D. Logan Page 13 of 14 2. Cost Allocation Led by: Finance Director, Sara D. Logan General Convention Total Department 2025/2026 Budget Government Tourism EMS Sewer Storm Water Allocated Method Check 001-110 Legislative 253,200 213,411 14,469 7,234 - 10,851 7,234 39,789 2024 agenda items - 001-130 Executive 728,515 433,795 51,738 90,104 55,414 25,373 72,091 294,720 Custom - see Executive tab - 001-142 Finance 1,137,734 667,812 75,962 147,655 95,129 33,766 117,411 469,922 Custom - see Finance tab - 001-143 City Clerk 901,621 759,938 51,521 25,761 - 38,641 25,761 141,683 2024 agenda items - 001-14x Utility Billing (New) 860,090 - - 293,489 176,966 99,649 289,986 860,090 Utility revenue - 001-145 City Hall 3,450,295 2,800,626 79,981 257,741 128,179 46,189 137,578 649,668 Custom - see City Hall tab - 001-150 Legal Services 350,000 184,451 26,685 52,179 33,503 11,894 41,288 165,549 2024 expenditures - 001-184 Purchasing 241,543 135,495 29,439 6,992 23,107 7,862 38,648 106,048 2024 non-salary expense - 001-480 Municipal Vehicles -excl. direct charge 425,455 215,979 - 13,766 46,375 61,691 87,644 209,476 Custom - see Municipal Veh tab - Total to be allocated 8,348,453 5,411,508 329,794 894,920 558,672 335,918 817,641 2,936,944 - New Codes: 2025/2026 Budget Monthly 001-110-000-511-60-49-99 (39,789) (1,658) 49-99 = cost allocation (can be any series within 4x-xx) 001-130-000-513-10-49-99 (294,720) (12,280) 001-142-000-514-23-49-99 (469,922) (19,580) 001-143-000-514-30-49-99 (141,683) (5,903) 001-14x-000-514-20-49-99 (860,090) (35,837) 001-145-000-514-89-49-99 (649,668) (27,070) 001-150-000-515-30-49-99 (165,549) (6,898) 001-184-000-518-40-49-99 (106,048) (4,419) 001-480-000-548-38-49-99 (209,476) (8,728) 106-xxx-xxx-xxx-xx-49-99 329,794 13,741 104-260-000-522-20-49-99 894,920 37,288 435-xxx-000-535-00-49-99 558,672 23,278 438-xxx-000-531-00-49-99 335,918 13,997 434-xxx-000-534-00-49-99 817,641 34,068 - - Page 14 of 14