Loading...
HomeMy WebLinkAboutFIN 2024-03-25 Item 1C - Report - 2023 3rd Quarter Financial ReportCity of Tukwila Thomas McLeod, Mayor Finance Department - Vicky Carlsen, Director INFORMATIONAL MEMORANDUM TO: Finance and Governance Committee CC: Mayor McLeod FROM: Vicky Carlsen, Finance Director BY: Tony Cullerton, Deputy Finance Director DATE: March 25, 2024 SUBJECT: 2023 3rd Quarter Report ISSUE The report below summarizes the citywide financial results and highlights significant items or trends through the third quarter of 2023. The report is based on data available as of January 5, 2024, for the reporting period ending September 30, 2023. General Fund revenues are tracking higher than in the same period last year. . Additionally, they are reporting $1.7 million (3.3%) higher than budget through September 2023. Expenditures are below budget. However, one-time vacancy savings and delayed implementation of anticipated wage and benefit adjustments associated with collective bargaining have yielded reductions to expenditures. While our current projections indicate underspending, it's important to note that the majority, if not all, of these are postponed expenses that are expected to come due by year-end. If not by year-end, then contractual obligations related to labor will be paid out in 2024, after contracts are settled. Our most reliable estimates suggest that there is more than $2.5 million in expenditures incurred (but not yet reported) due to contractual and retroactive salaries. These expenditures are expected to be paid in the near future. As the financial statements are reviewed, please note the new formatting and additions to the statements. With the new ERP system, we are now able to capture budget amendments in the statements that have been approved via consensus. This enhancement will allow the reader to understand the impacts of proposed amendments on fund balance as the year progresses rather than waiting for formal approval at year-end. Additional details can be found in the attached financial reports. Tukwila City Hall • 6200 Southcenter Boulevard • Tukwila, WA 98188 • 206-433-1800 • Website: TukwilaWA.gov 41 INFORMATIONAL MEMO February 12, 2024 Page 2 DISCUSSION January through September Highlights General Fund • Unassigned beginning fund balance was $16.2 million, lower than expected but still exceeding fund balance policy requirements. Beginning fund balance is lower than expected due to land sale revenue expected at the end of 2022 having not yet been received. • Revenue through September 30th is $51.7 million, slightly above the allocated budget of $50 million. Increases in sales tax and building permits are offsetting those revenue streams that are not currently meeting expectations. • Major revenue performers included Retail Sales Tax, Business Licenses, and Building Permits. • Salaries and benefits are currently lower than budget pending the conclusion of collective bargaining with Teamsters Local 763. Upon agreement and ratification, a retroactive payment will be processed that will reconcile the variance. • General Fund departmental expenditures through September are at $49.9 million and transfers out are at $4.7 million for a total general fund expenditures of $55.6 million. • Total general fund expenditures are below allocated budget by $2.6 million. As previously noted, this is largely due to one-time savings generated from staff vacancies and pending wage and benefit adjustments associated with collective bargaining. Other Funds Capital Projects Several capital projects are in process including: • The Allentown Truck Reroute project recommended alternatives for further consideration. • The Transportation Element Comp Plan incorporated community input into draft transportation networks. • West Valley Highway (1405 to Strander) Project completed significant work, including stripping and installations. • Public Works Shops Phase 1 and Phase 2 advanced with roofing and painting updates. Utilities In the third quarter, Utility projects achieved significant milestones. • The Levee Certification/Green River Corridor project involved ongoing collaboration with the Army Corps of Engineers. • Regulatory reviews continued for the Surface Water, Water & Sewer Comprehensive Plans, while the Surface Water Comp Plan was actively developed. • The Annual Small Drainage Program secured a design consultant, and NPDES Program compliance was ensured through the successful hiring of new inspectors. • The Green the Green project, involving grants and vegetation management, continued, and the Chinook Wind Public Access/Extension project received a grant of $280,000 for design activities. Phone: 206-433-1800 • Email: Mayor@TukwilaWA.gov • Website: TukwilaWA.gov 42 INFORMATIONAL MEMO February 12, 2024 Page 3 Foster Golf Course • Foster Golf Course entered into a strategic partnership with GolfNow, a prominent player in the online tee time booking service sector. • Foster Golf Course upgraded its website which resulted in increased online visibility, amplifying the course's presence during customer searches for golf facilities. • The Golf Course was able to successfully justify a modest adjustment in Green Fees, aligning the cost of a round of golf with that of other surrounding municipal golf courses. Equipment Rental • The Equipment Rental Fund has strategically leveraged the Enterprise Fleet Leasing program by adding twelve new patrol vehicles into its fleet. • PD has completed the implementation of the Police Department's take-home vehicle program. • The department has realized increased revenue from the Sale of Capital Assets over the anticipated budget. Lodging Tax • Lodging tax revenue is on pace to meet and exceed budget. Lodging tax revenue through September is $787k and exceeds allocated budget by $61k. Drug Seizure • For the period January 1st through September 30th, 2023, the seizure fund brought in $79,010 through the Dept of Justice's Equitable Sharing program. • Police Department sent $82,322 to Sound Mental Health as contracted compensation for our two Mental Health Co -Responders (a portion of these expenditures will be returned to us via the grant). • The Department spent $11,423 of Seizure Funds to replace the Special Response Team's (SWAT) equipment. Debt Service Funds • Debt Service is funded by budgetary approved interfund transfers. All long-term debt obligations are paid timely and in accordance with the debt schedule. Insurance — Active Employees / Insurance LEOFF 1 Retirees Funds • The Insurance funds are trending as anticipated. The funds are adequately funded, and Program Cost expenditures are slightly under budget. Both funds are stable and well positioned heading into Q4. ATTACHMENTS 3rd Quarter Financial Report Phone: 206-433-1800 • Email: Mayor@TukwilaWA.gov • Website: TukwilaWA.gov 43 44 CITY OF TUKWILA 2023 Q3 FINANCIAL REPORT HIGHLIGHTS This report explains the City's income and spending activities through September 30, 2023, with a primary emphasis on the General Fund activities. Although it encompasses financial information about all City funds, the discretionary activity in the other funds is constrained by statutory restrictions, unlike the General Fund. Year-to-date revenues are slightly higher than budgeted, and expenditures are lower than budgeted. 2023 YTD 2023 YTD Budget Actual $ Diff % Diff Revenues 50,038,867 51,712,623 1,673,756 3.3% Expenditures 57,145,620 54,555,154 ($2,590,466) -4.5% General Fund 2023 Q3 Revenues & Expenditures Budget vs Actual 58,000 56,000 54,000 52,000 50,039 50,000 48,000 51,713 57,146 54,555 - 46,000 c ro Revenues Expenditures c 0 - ■ 2023 YTD Budget ■ 2023 YTD Actual I- 46 The quarter concluded with operating expenditures below the budget. It's important to note that the $2.5 million under budget is not indicative of savings due to ongoing labor negotiations, and retro pay is anticipated soon. Expenditures appear higher than revenues due to a delayed property tax deposit that was expected in the third quarter but arrived in the following month. Although expenditures are evenly distributed and budgeted in the month of occurrence, revenues are occasionally received in subsequent months. Year-to-date revenues are slightly higher than budget with a 3.3% increase over expectations. Over the past three years, 2023 revenues are up 11.5% over 2021, and 0.9% when compared to the same period in 2022. While revenues are trending up and to the right, they are not significant enough to keep pace with the increase in inflation. Thousands 53,000 52,000 51,000 50,000 49,000 48,000 47,000 46,000 45,000 44,000 43,000 Total Revenue 2021 - 2023 51,230 51,713 46,398 2021 2023 Major Performing Revenues • Retail Sales Tax increase 7.5% • Interfund Utility Tax increase 8.0% • Business Licenses increase 6.6% • Building Permits increase 27.1 3 47 City of Tukwila General Fund as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget REVENUE: Property Tax 517.682.000 S S 17 682.000 S 9 595 750 S (8.086.250) 54.3% Sales Taxes -Retail 20.378.000 1.000.000 21 378.000 16.250.146 (5.127.854) 79.7% Sales Taxes -Criminal Justice 905 000 905 000 754,014 (150.986) 83.3% Admission Taxes 850 000 850 000 681.981 (168.019) 80.2% Utility Taxes 4.300.000 4.300.000 3.219.572 (1.080.428) 74.9% Interfund Utility Taxes 2.634.980 2.634.980 2.160.738 (474.242) 82.0% Gambling & Excise Taxes 4.665.700 4.665.700 3.606.519 (1.059.181) 77.3% Business Licenses 3.230.000 3.230.000 2.286.658 (943.342) 70.8% Rental Housing Permits 41 000 41 000 39.856 (1.144) 97.2% Building Permits 1 739 660 1.739.660 1.862.306 122.646 107.0% Franchise Fees 508.000 508 000 418.919 (89.081) 82.5% Sales Tax Mitigation Payments 635 470 635 470 494.254 (141.216) 77.8% SCL Agreement 2.300.000 - 2 300.000 2.064.356 (235.644) 89.8% Grant Revenues 2.873.788 1.445.215 4 319.003 2.632 121 (1.686.882) 91.6% State Entitlements 505 500 505 500 460.823 (44.677) 91.2% Intergovernmental Revenue 628 804 628 804 18.428 (610.376) 2.9% General Government Revenue 16 620 16 620 17.017 397 102.4% Security Revenue 1 138 900 200.000 1 338.900 768.010 (570.890) 67.4% Transportation Revenue 20.000 20 000 288 (19.712) 1.4% Plan Check and Review; Fees 794268 794 268 966.653 172.385 121.7% Culture and Recreation Fees 171 200 10.000 181 200 110.707 (70.493) 64.7% Fines and Penalties 760 475 - 760 475 228.515 (531,960) 30.0% Other Income 178 155 117.396 295 551 402.845 107.294 226.1% Total Operating Revenues 66.957.520 2.772.611 69 730.131 49.040.475 120.689.656) 73.2% Indirect Cost Allocation 2.822.397 2 322.397 2.116.809 (705.588) Investment Earnings 100.000 150.000 250 000 317.897 67.897 Rent & Concessions 335.570 335 570 237.442 (98.128) Transfers In 1.624.147 (270.000) 1 354.147 (1.354.147) Total Non -Operating Revenues 4.882.114 (120.000) 4.762 114 2.672.147 (2.089.966) Total Revenues 71.839.634 2.652.6111 74.492.245 75.0% 317.9% 70.8% 0.0% 54.7% 51.712.623 (22.779.622) 72.0% The Budget Amendments (Consensus) were formally approved at the November 20th Regular Meeting. 48 Property Tax 2023 2023 YTD vs Allocated Actual less 2022 YTD $ Budget 2021 Actual 2022 Actual 2023 Actual Budget Diff % Diff 10,800,133 9,796,332 9,740,424 9,595,750 (1,204,383) (144,674) -1.5% Property Tax declined 1.5% over the same period last year. However, the dip is a result of a timing variance due to delayed receipt of the September property tax distribution deposited from King County. A $1.1 million property tax deposit was anticipated in September but received in the 1st week of October. 2023 Property Tax has been received and posted. Property taxes are trending as budgeted. 9,850,000 9,800,000 9,750,000 9,700,000 9,650,000 9,600,000 9,550,000 9,500,000 9,450,000 9,796,332 2021 Actual Property Tax Jan -Sept. 2021 - 2023 9,740,424 9,595,750 2022 Actual 2023 Actual 5 49 Sales Tax 2023 2023 YTD vs Allocated Actual less 2022 YTD $ Budget 2021 Actual 2022 Actual 2023 Actual Budget Diff % Diff 15, 692, 788 14, 727, 965 15, 823,150 17, 004,160 1,311,372 1,181, 010 7.5% Sales Tax is up, over $1.2 million (7.5%) compared to last year. Within Sales Tax, Retail Trade was down 2.9% compared to last year. The Construction sector and Services sector were the strongest performers. Construction is one of the more volatile sectors and is difficult to project within the Sales Tax umbrella. Inflationary pricing also contributed to the overall increase in Sales Tax revenue. 17,500,000 17,000,000 16,500,000 16,000,000 15,500,000 15,000,000 14,500,000 14,000,000 13,500,000 14,727,965 2021 Actual Sales & Use Tax - Retail Jan - Sept 2021 - 2023 15,823,150 17, 004,160 2022 Actual 2023 Actual 6 50 Utility Tax 2023 Allocated 2023 YTD vs Actual less 2022 YTD $ Budget 2021 Actual 2022 Actual 2023 Actual Budget Diff % Diff 3,294,842 2,770,027 3,218,118 3,219,572 (75, 270) $1,454 0.0% Utility tax came in slightly under budget but revenues were on par with the same period last year. Utility tax is a combination of the following utilities: $ 2022 2023 Change % Change Cable 163,804 171,069 7,265 4.4% Electric 1,403,974 1,356,265 (47,709) -3.4% Gas 542,695 575,820 33,125 6.1 Telecommunications 535,249 534,608 (641) -0.1 Solid Waste 572,397 581,810 9,413 1.6% Total 3,218,119 3,219,572 1,453 0.05% 3,300,000 3,200,000 3,100,000 3,000,000 2,900,000 2,800,000 2,700,000 2,600,000 2,500,000 2,770,027 2021 Actual Utility Tax Jan - Sept 2021 - 2023 3,218,118 3,219,572 2022 Actual 2023 Actual 7 51 Interfund Utility Tax 2023 2023 YTD vs Allocated Actual less 2022 YTD $ Budget 2021 Actual 2022 Actual 2023 Actual Budget Dif % Diff 2,157,684 1,924,692 2,000,766 2,160,738 3,054 159,972 8.0% Interfund Utility Tax is the tax the City imposes on itself for the use of utilities. All three utilities saw an increase greater than 5% over the prior year. $ 2022 2023 Change % Change Utility Tax -IF Surface Water 738,913 777,822 38,909 5.3% Utility Tax-Interfund Sewer 705,428 766,427 60,999 8.6% Utility Tax-Interfund Water 556,426 616,489 60,063 10.8% Total 2,000,766 2,160,738 2,200,000 2,150,000 2,100,000 2,050,000 2,000,000 1,950,000 1,900,000 1,850,000 1,800,000 Interfund Utility Tax Jan - Sept 2021- 2023 1,924,692 2021 Actual 2,000,766 2,160,738 Mil 2022 Actual 2023 Actual 52 Gambling Tax 2023 YTD 2023 Actual vs 2022 Allocated 2023 less YTD $ Budget 2021 Actual 2022 Actual Actual Budget Diff % Diff 3,547,750 2,870,753 3,733,387 3,606,519 58,769 (126,868) -3.4% Gambling Tax revenue increased sharply in 2022 over 2021. Third quarter reports a slight cooling off compared to the same period last year. However, Q3 slightly exceeded budget, demonstrating the anticipated slight dip in Gambling Tax revenues. 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 2,870,753 2021 Actual Gambling Tax Jan - Sept 2021 - 2023 3,733,387 3,606,519 2022 Actual 2023 Actual 9 53 Admission Tax 2023 YTD vs 2023 Actual 2022 Allocated 2021 202 2023 less YTD $ Budget Actual Actual Actual Budget Diff 731,161 253,342 685,838 681,981 (49,180) (3,857) Diff -0.6% Admission tax is trending at a similar pace to the prior year. Current revenues are down less than 1 %, compared to the same time last year. 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 253,342 2021 Actual Admission Tax Jan - Sept 2021 - 2023 685,838 681,981 2022 Actual 2023 Actual 10 54 Business Licenses 2023 YTD vs 2023 Actual 2022 Allocated 2021 2022 2023 less YTD $ Budget Actual Actual Actual Budget Diff % Diff 2,301,683 2,644,400 2,145,501 2,286,658 (15,025) 141,157 6.6% Business License revenue has been down over the past few years. As we emerge from the pandemic, businesses are still reporting challenges in the ability to attract candidates to fill employment vacancies. Early in 2023 the Director of Security at Westfield Mall came to Council and shared that businesses within the mall are having difficulty filling positions due to safety concerns of potential job candidates. Council responded by passing a budget that fully funded Public Safety. Local businesses are reporting a light increase (1.7%) over the prior year. Non -Residential Business licenses have improved by greater than 5% over the same period last year. 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 2,644,400 2021 Actual Business Licenses Jan - Sept 2021 - 2023 2,145,501 2022 Actual 2,286,658 2023 Actual 2022 2023 Change % Change Tukwila Businesses 2,291 2,329 38 1.7% Non -Residential Business Licenses 2,701 2,922 221 8.2% Total Business Licenses 4,992 5,251 259 5.2% 11 55 Building Permits 2023 YTD vs 2023 Actual 2022 Allocated 2021 2022 2023 less YTD $ Budget Actual Actual Actual Budget Diff % Diff 1,304,745 1,266,110 1,465,127 1,862,306 557,561 397,179 27.1% Building permits have been showing steady growth over the past three years. 2,000,000 1,500,000 1,000,000 500,000 0 1,266,110 2021 Actual Building Permits Jan - Sept 2021 - 2023 1,465,127 1,867,306 2022 Actual 2023 Actual Building permits have increased in both volume and valuation. YTD the number of permits issues has increased by almost 30%. The valuation has increased by about 3% over the same period last year. Building Permits is a volatile revenue stream that is difficult to predict with any amount of certainty. 2022 2023 Change % Change # of Permits 1,126 1,439 313 27.8% Valuation of Permits $151,835,692 $156,003,356 $4,167,664 2.7% 12 56 EXPENDITURES General Fund departmental expenditures totaled $49.9 million through September, which is $2.4 million below the allocated budget of $52 million. Department 20, which transfers to other funds, reported $4.65 million in expenditures. This number reflects transactions for debt payments and interfund activity. In total the General Fund activity YTD as of the end of September was $54.56 million, which is 2.6 below the allocated budget. However, due to ongoing labor negotiations, the $2.6 million under budget does not represent savings. BUDGET ACTUAL Allocated Budget % 2023 2023 2021 2022 2023 vs Actual Expendec, $ Change % Change DEPARTMENT Annual Allocated OVER/(UNDER) 2022/2023 City Council 384,889 286,333 253,457 263,478 273,753 (12,580) 71.1% 10,275 3.9% Mayor's Office 2,502,666 1,900,892 1,462,714 1,532,984 1,592,997 (307,895) 63.7% 60,013 3.9% Administrative Services 5,676,491 4,166,583 3,511,068 3,414,056 4,777,319 610,736 84.2% 1,363,263 39.9% Finance Department 3,868,642 2,849,613 1,973,945 2,471,281 2,481,681 (367,932) 64.1% 10,400 0.4% Rec Dept/ Parks Maint 5,109,490 3,965,438 3,110,182 3,623,904 3,751,451 (213,987) 73.4% 127,547 3.5% Community Dev 4,672,314 3,498,530 2,870,673 3,066,304 3,374,793 (123,736) 72.2% 308,489 10.1% Municipal Court 1,741,340 1,306,005 905,547 1,148,351 1,194,503 (111,502) 68.6% 46,152 4.0% Police Department 22,746,448 17,034,293 13,269,954 13,783,111 15,559,019 (1,475,274) 68.4% 1,775,907 12.9% Fire Department 14,790,120 11,264,770 10,124,717 10,788,292 11,486,993 222,223 77.7% 698,700 6.5% PW Dept / Street Maint 7,574,988 6,047,440 5,074,768 5,296,669 5,407,255 (640,185) 71.4% 110,586 2.1% Subtotal 69,067,388 52,319,897 42,557,026 45,388,431 49,899,764 (2,420,132) 72.2% 4,511,333 9.9% Non Departmental 6,688,881 4,825,723 3,793,874 7,588,145 4,655,390 (170,333) 69.6% (2,932,755) -38.6% Total Expenditures 75,756,269 57,145,620 46,350,900 52,976,577 54,555,154 (2,590,465) 72.0% 1,578,577 3.0% %of Year 75.0%1 As of the end of September, all departments except Administrative Services and Fire are operating within their allocated budgets. The overage in Administrative Services is attributed to the Private LTE project that will be reimbursed by a state grant. The increase in Fire is due to higher than anticipated contracted services including overtime and increased call volume with dispatch services. 13 57 The table below displays General Fund expenditures by category. All categories are performing within budgetary expectations. Salaries& Wages appear to be significantly below budget. This does not represent a savings. The City has been involved in ongoing labor discussions. Upon completion of negotiations there is an expectation of a retroactive payment of salaries that will bring the account in line with expectations. Budget Revised Annual Amendments Annual Budget (Consensus) Budget Variance Year to Date Over/(Under) % of Annual Actual Encumbrances Annual Budget Budget EXPENDITURES: Salaries & Wages 27.561.307 27.561.307 18.928.035 (8.633.272) 68.7% Benefits 10.858.318 50.000 10.908.318 7.334.654 (3.573.664) 67.5% Supplies 678.334 90.880 769.214 310.859 (458.355) 45.8% Repair & Maintenance Supplies 450.010 450.010 280.052 (169.958) 62.2% Resale Supplies 2.500 2.500 - (2.500) 0.0% Small Tools 213.203 213.203 62.264 (150.939) 29.2% Technology Supplies 110.798 232.416 343.214 270.859 (72.354) 244.5% Fleet Supplies 7.000 - 7.000 4.758 (2.242) 68.0% Professional Services 21.798.538 1.208.794 23.007.332 16,773.810 (6.233.521) 76.9% Communications 440.528 - 440.528 328.380 (112,148) 74.5% Professional Development 570.360 690 571.050 321.328 (249.722) 56.3% Advertising 66.300 66.300 26.396 (39.904) 39 8% Rentals 1.298.060 1.298,060 898.633 (399.426) 69.2% Technology Services 1.031.264 1.031.264 710.731 (320.533) 68.9% Utilities 2.244.354 2.244.354 2.003.235 (241.119) 89.3% Repairs & Maintenance Services 1.286.418 1.286.418 1.017.489 (268.929) 79.1% Other Expenditures 1.012.899 (325.000) 687.899 390.786 (297.113) 38.6% Total Operating Expenditures 69.630.190 1.257,780 70.887,970 49.662.270 (21.225.700) 71 3% Machinery & Equipment Transfers Out 420.000 807.831 1.227,831 1.082.062 (145,769) 257.6% 5,706,078 122,151 5.828.229 3.810,823 (2.017.407) 66.8% Total NonOperating Expenditure: 6.126.078 929.982 7.056,060 4.892.884 (2.163 176) 79.9% Total Expenditures 75.756,268 2.187.762 77,944,030 54.555.154 (23.388.876) 72.0% Beginning Fund Balance Change in Fund Balance Ending Fund Balance 19.085.142 (3.916.634) 515.168.508 (2.840.262) 16.244.880 464.849 (3.451 785) S 12 793.095 16.244.880 (2.842.532) S 13.402.349 14 58 CITY OF TUKWILA 2023 3rd QUARTER FINANCIAL REPORT OTHER FUNDS FINANCIAL REPORT Other Funds Capital Projects Q3 saw ongoing developments in capital projects. The Allentown Truck Reroute project recommended alternatives for further consideration. The Transportation Element Comp Plan incorporated community input into draft transportation networks. West Valley Highway (1405 to Strander) Project completed significant work, including stripping and installations. Construction progressed on Overlay & Repair, and Foster Point Repairs were completed in Bridge Inspections. S 152nd Safe Routes to School moved forward with design, and ADA improvements were embedded into ongoing projects. Public Works Shops Phase 1 and Phase 2 advanced with roofing and painting updates. Utility Funds In the third quarter, Utility projects achieved significant milestones. The Levee Certification/Green River Corridor project involved ongoing collaboration with the Army Corps of Engineers. Regulatory reviews continued for the Surface Water, Water & Sewer Comprehensive Plans, while the Surface Water Comp Plan was actively developed. The GIS Utilities Inventory project, now nearing completion, benefited from the hired GIS Field Technician's contributions. Construction progressed for the S 152nd Waterline Extension. Gilliam Creek Fish Barrier Removal and Nelsen Side Channel projects advanced with ongoing design work. Stormwater Quality Retrofit reached the 90% design stage, and the City pursued wetland delineation for S 131st Drainage Improvements. The Annual Small Drainage Program secured a design consultant, and NPDES Program compliance was ensured through the successful hiring of new inspectors. The Green the Green project, involving grants and vegetation management, continued, and the Chinook Wind Public Access/Extension project received a grant of $280,000 for design activities. Foster Golf Course Foster Golf Course entered into a strategic partnership with GolfNow, a prominent player in the online tee time booking service sector. This business arrangement has not only facilitated an upgraded website for Foster Golf Course but has also resulted in increased online visibility, amplifying the course's presence during customer searches for golf facilities. Leveraging these enhancements, the department management successfully justified a modest adjustment in Green Fees, aligning the cost of a round of golf with that of other municipal golf courses in the city. 15 59 Equipment Rental The Equipment Rental Fund has strategically leveraged the Enterprise Fleet Leasing program by adding twelve new patrol vehicles into its fleet, thereby completing the implementation of the Police Department's take-home vehicle program. This initiative not only enhances response times but also strengthens the Police Department's competitive edge in attracting new officers and recruits. Additionally, the utilization of the fleet leasing program has enabled the Equipment Rental department to capitalize on surplus vehicles during opportune periods, leading to elevated resale values. The department has realized a noteworthy sum of $326,067 from the Sale of Capital Assets, surpassing the budget by $164,317 (201.6%). This financial achievement underscores the effective management and optimization of resources within the department. Lodging Tax Lodging tax revenue is on pace to meet and exceed budget. Lodging tax revenue through September is $787k and exceeds allocated budget by $61k. Drug Seizure For the period January 1st through September 30th, 2023, the seizure fund brought in $79,010 through the Dept of Justice's Equitable Sharing program and $63,433 of funds spent from these Seizure Funds was reimbursed by the Associated of Washington Cities via their Alternative Response Team Grant (this is the program that partially funds the Police Department's Mental Health Co -Responder program). On the expenditure side, the Police Department sent $82,322 to Sound Mental Health as contracted compensation for our two Mental Health Co -Responders (a portion of these expenditures will be returned to us via the grant). The Police Department also spent $11,423 of these Seizure Funds to replace our Special Response Team's (SWAT) ballasted -rated helmets and $6,716 on a software program used by our detectives to aid them in solving felony crimes. Debt Service Funds Debt Service is funded by budgetary approved interfund transfers. All long-term debt obligations are paid timely and in accordance with the debt schedule. Insurance — Active Employees / Insurance LEOFF 1 Retirees Funds The Insurance funds are trending as anticipated. The funds are adequately funded, and Program Cost expenditures are slightly under budget. Both funds are stable and well positioned heading into Q4. 16 60 City of Tukwila Contingency Fund as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget REVENUE: Investment Earnings 20.000 100,000 120,000 132.388 12,388 661.9% Transfers In 170,470 170,470 (170,470) 0.0% Total Revenues EXPENDITURES: 20,000 270.470 290.470 132,388 (158,082) 661.9% Total Expenditures Beginning Fund Balance Change in Fund Balance Ending Fund Balance 7,042,148 20,000 S 7, 062,148 (295. 673) 6,746,475 270.470 290,470 S 7.036, 945 City of Tukwila Hotel/Motel Tax Special Rev Fd as of September 30, 2023 0.0% 6,746,475 132.388 S 6.878, 864 Annual Budget Budget Revised Amendments Annual (Consensus) Budget Year to Date Actual Variance Over/(Under) Annual Budget % of Annual Budget REVENUE: Hotel/Motel Tax 720,000 - 720,000 700.171 (19.829) 97.2% Investment Earnings 6,000 - 6,000 86.776 80,776 1446.3% Total Revenues 726,000 - 726,000 786.947 60,947 108.4% EXPENDITURES: Salaries & Wages Benefits 68,766 22,631 - 68,766 - 22,631 52.320 13.143 (16,446) (9.488) 76.1% 58.1% Supplies 2,000 - 2,000 154 (1.846) 7.7% Professional Services 375,000 - 375,000 150.033 (224.967) 40.0% Professional Development Advertising 21,500 350,000 - 21,500 - 350,000 2.731 71.426 (18.769) (278.574) 12.7% 20.4% Technology Services 2,500 - 2,500 1.323 (1.177) 52.9% Other Expenditures 70,000 - 70,000 - (70.000) 0.0% Total Operating Expenditures 912,397 - 912,397 291.131 (621,266) 31.9% Indirect Cost Allocation 26,493 - 26.493 19 872 (6.621) 75.0% Total NonOperating Expenditures 26,493 - 26,493 19.872 (6.621) 75.0% Total Expenditures 938,890 - 938,890 311,003 (627.887) 33.1% 2,342.419 475.944 Beginning Fund Balance Change in Fund Balance 2,048,201 (212.890) 294,218 2,342,419 - (212.890) Ending Fund Balance $ 1,835,311 $ 2,129,529 $ 2.818,363 17 61 City of Tukwila Drug Seizure Fund as of September 30, 2023 Budget Revised Variance Annual Amendments Annual Year to Date Over/(Under) % of Annual Budget (Consensus) Budget Actual Annual Budget Budget REVENUE: Grant Revenues - 60.000 60.000 Intergovernmental Revenue 35.000 35.000 Other Income 80.000 80.000 Investment Earnings 500 500 Total Revenues 63 433 79 010 3.433 0.0% 44.010 225.7% (80.000) 0.0% (500) 0.0% 115.500 60,000 175,500 142.443 (33.057) 123.3% EXPENDITURES: Salaries & Wages 100.107 (100.107) 0.0% Benefits 48.901 (48.901) - 0.0% Supplies 10.000 - 10.000 - (10,000) 0.0% Small Tools 19.000 19.000 11.423 (7,577) 60.1% Professional Services 15.000 149.008 164.008 82.322 (81,686) 548.8% Professional Development 16.000 16.000 (16.000) 0.0% Technology Services 22.000 22.000 6.716 (15.284) 30.5% Total Operating Expenditures 231.008 231,008 100.462 (130.546) 43.5% Machinery & Equipment 35.000 35.000 (35.000) 0.0% Total NonOperating Expenditures 35.000 35.000 Total Expenditures (35.000) 0.0% 266,008 266.008 100.462 (165.546) 37.8% Beginning Fund Balance Change in Fund Balance Ending Fund Balance 435.515 (150.508) 5 285.008 (140.295) 295.220 295.220 60.000 (90.508) 41.981 5 204.713 S 337202 City of Tukwila LTGO Debt Service Fund as of September 30, 2023 REVENUE: SCORE Contribution Transfers In Budget Revised Annual Amendments Annual Budget (Consensus) Budget Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget 376,876 - 376,876 - (376,876) 5,802,194 5,802,194 0.0% 4.351.645 (1,450.549) 75.0% Total Revenues 6.179,070 6,179,070 4,351.645 (1,827,425) 70.4% EXPENDITURES: Principal 4.005,836 4,005,836 - (4,005.836) Interest Expense 2.173.234 2,173,234 994.044 (1,179,190) Total Expenditures 6.179,070 6,179,070 Beginning Fund Balance Change in Fund Balance Ending Fund Balance 0.0% 45.7% 994,044 (5,185.026) 16.1% 3.357.601 S 3,357,601 18 62 City of Tukwila UTGO Debt Service Fund as of September 30, 2023 Annual Budget Budget Revised Amendments Annual (Consensus) Budget REVENUE: Property Tax Investment Earnings $ 4,485,975 $ 1,200 Variance Year to Date Overl(Under) % of Annual Actual Annual Budget Budget - $ 4,485,975 $ 1.200 Total Revenues 4.487,175 2,473.800 $ (2,012,175) 55.1% 41,650 40,450 3470.8% 4.487,175 2,515.450 EXPENDITURES: Principal Interest Expense 1,980,000 1,980,000 2,505,975 (1.971,725) 56.1% 2,505,975 1,252.988 (1,980,000) (1.252.988) 0.0% 50.0% Total Expenditures 4,485,975 4,485,975 1,252,988 (3,232,988) 27.9% Beginning Fund Balance Change in Fund Balance Ending Fund Balance 314,818 1.200 $ 316,018 87,811 402,630 1,200 $ 403,830 City of Tukwila LID #33 & Guarantee Funds as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget REVENUE: Special Assessment Interest Investment Earnings LID Assessment Principal Total Revenues 125,000 3,000 400,000 125,000 3,000 400,000 402.630 1,262.462 $ 1,665.092 Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget 112.694 28,509 382.843 (12.306) 25,509 (17,157) 90.2% 950.3% 95.7% 528,000 528,000 524,046 (3,954) 99.3% EXPENDITURES: Principal 400,000 400,000 400,000 100.0% Interest Expense 125,000 19,188 144,188 144,188 115.4% Total Expenditures 525,000 19,188 544,188 544,188 103.7% Beginning Fund Balance Change in Fund Balance Ending Fund Balance 1.345,636 3,000 $ 1.348,636 (12,837) 1,332,799 (19,188) (16,188) $ 1,316,612 1,332,799 (20,141) $ 1,312,658 19 63 City of Tukwila Residential Streets Fund as of September 30, 2023 Annual Budget Budget Revised Amendments Annual (Consensus) Budget Year to Date Actual Variance Over/(Under) Annual Budget % of Annual Budget REVENUE: Solid Waste Utility Tax 650,000 - 650.000 650.000 - 100 0% Grant Revenues 4,033,000 (4.000.000) 33,000 3.133 (29,867) 0.1% State Entitlements 268,800 - 268,800 220.737 (48.063) 82.1% Investment Earnings 1.000 - 1.000 23.351 22.351 2335.1% Transfers In 400,000 . - 400.000 7.201 (392.799) 1.8% Total Revenues 5,352,800 (4,000,000) 1,352,800 904,424 (448,376) 16.9% PROJECTS Traffic Calming/Residental Safety 650,000 (250,000) 400,000 65,720 (334,280) 10.1% 46th Ave S Safe Routes to School 510,000 (510.000) - - - 0.0% S 152nd St Safe Routes School 4,015,000 (4,015,000) - 40.749 40.749 1.0% S 119th St Br/ 42nd Ave S RRFB 250,000 - 250,000 114,699 (135,301) 45.9% 53rd Ave S 243,500 - 243,500 121.121 (122.379) 49.7% 42nd Ave S Phase III 243,500 - 243,500 121.370 (122.130) 49.8% Total Expenditures by Project 5,912,000 (4,775,000) 1,137,000 463,659 (673,341) 7.8°0 Beginning Fund Balance 847,903 (113,497) 734,407 734.407 Change in Fund Balance (559,200) 215,800 440.765 Ending Fund Balance $ 288,703 $ 950,207 $ 1.175.171 20 64 City of Tukwila Arterial Street Fund as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget REVENUE: Solid Waste Utility Tax Parking Tax Real Estate Excise Tax (REET) Permits Franchise Fees Grant Revenues State Entitlements Traffic Impact Fees Fines and Penalties Concurrency Fees Investment Earnings Variance Year to Date Over RUnderi % of Annual Actual Annual Budget Budget 490.000 490.000 319.683 (170.317) 65.2% 600.000 600.000 594.268 (5.732) 99.0% 500.000 500.000 190,268 (309.732) 38.1% - 831 831 0.0% 75.000 75.000 (75.000) 0.0% 2.779.000 2.779.000 513.326 (2.265.674) 18.5% 144.800 144.800 112.785 (32.015) 77.9% 200.000 200.000 765.241 565.241 382.6% - 11.081 11.081 0.0% 80.000 80.000 166.534 86.534 208.2% 5.000 5.000 193.018 188.018 3860.4% Total Revenues 4.873,800 4.873.800 2,867.035 (2,006.765) 58.8% PROJECTS Transportation Elmnt-Comp Plan Annual Bridge Inspections Annual Overlay & Repair Annual Traffic Signals Annual Traffic Counts S 144th St Bridge - Sidewalks ADA Improvements 2015 Green River Trail Improvements 42nd Ave S Bridge Replacement Allentown Truck Reroute Proj Solid Waste Program Wetland Monitoring W Valley Hwy (I-405-Strander) Public Records Request Other/Misc 300.000 (300.000) - 180.610 180.610 60.2% 200.000 200.000 87.818 (112.182) 43.9% 1.400.000 1,400.000 1.119.538 (280.462) 80.0% 130.000 130.000 43.205 (86.795) 33.2% 6.000 6.000 0.0% 100.000 (100.000) - 261 261 0.3% 50.000 50.000 306 (49.694) 0.6% 1.297.000 (1.150.000) 147.000 89.051 (57.949) 6.9% 1.500.000 1.500.000 714.457 (785.543) 47.6% 600.000 (750.000) (150.000) 265,841 415.841 44.3% 32.195 32.195 0.0% 8.476 8.476 0.0% 654.531 654.531 0.0% 634 634 0.0% 572.662 572.662 207.539 (365.122) 36.2% Total Expenditures by Project 6.149.662 (2.300.000) 3.849 662 3,410.463 (439.199) 55.5% Beginning Fund Balance Change in Fund Balance 6.570.879 .1.275.862) (1 036 386) 2.300 000 5.534.493 1.024.138 Ending Fund Balance 3 5 295 017 S 6 558 631 5.534.493 (543.427) S 4.991 065 21 65 City of Tukwila Land Acq., Rec. & Park Devlpmn as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget REVENUE: Property Tax Real Estate Excise Tax (REET) Park Impact Fees Investment Earnings Transfers In Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget $ 165,000 $ $ 165,000 $ 129,956 $ (35,044) 150,000 150,000 36.224 (113,776) 100,000 100,000 980.841 880,841 8,000 8,000 122.618 114.618 64,250 51.681 115,931 64.250 (51.681) Total Revenues 78.8% 24.1% 980.8% 1532.7% 100.0% 487,250 51,681 538,931 1,333,888 794,957 273.8% PROJECTS Art Projects 64.250 64,250 60.688 (3,562) 94.5% Park Improvements 742.000 - 742,000 (742,000) 0.0% Foster & TCC Parks Master Plan 2,588 2,588 0.0% Parks Maintenance 147.719 147,719 0.0% Multipurpose Trails 125,000 125,000 (125,000) 0.0% Other/Misc 5.917 5.917 0.0% Total Expenditures by Project 931,250 931.250 216,911 (714.339) 23.3% Beginning Fund Balance Change in Fund Balance Ending Fund Balance 3,751,186 (444.000) $ 3,307.186 (681,383) 3.069,803 51,681 (392.319) $ 2,677.484 City of Tukwila Urban Renewal as of September 30, 2023 3.069.803 1,116,977 $ 4.186.781 Budget Revised Annual Amendments Annual Budget (Consensus) Budget REVENUE: Investment Earnings Sale of Capital Assets 1.350.000 - 1.350.000 Total Revenues 1,350,000 - 1,350,000 EXPENDITURES: Utilities Transfers Out 300.000 730,000 1.030.000 Total Expenditures Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget 64,184 64,184 0.0% (296,496) (1,646,496) -22.0% (232.312) (1.582.312) -17.2% 3.927 3,927 (1,030,000) 0.0% 0.0% 300,000 730,000 1,030,000 3.927 (1,026.073) 1_3% Beginning Fund Balance Change in Fund Balance Ending Fund Balance 1.183,800 1,050,000 $ 2,233,800 220,443 1,404,242 (730,000) 320,000 $ 1,724,242 3,411,652 (236,239) 3,175.413 22 66 City of Tukwila General Govemmnt Improvements as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget REVENUE: Grant Revenues Investment Earnings Transfers In 1.800,000 (1,800,000) 1.000 100,000 (100,000) Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget 1.000 17,323 16.323 0.0% 1732.3% 0.0% Total Revenues 1,901,000 (1,900,000) 1,000 17.323 16,323 0.9% PROJECTS TC HVAC Replacement Citywide Facilities Plan City Hall Siding Repairs Other/Misc 2,000,000 (1.865.000) 135,000 (135,000) 0.0% 340,000 (340,000) - - - 0.0% 149,200 149,200 149,185 (15) 0.0% 5,128 5,128 - (5,128) 0.0% Total Expenditures by Project 2,345,128 (2,055,800) 289,328 149,185 (140,143) 6.4% Beginning Fund Balance 444,128 109,258 553,386 Change in Fund Balance (444.128) 155,800 (288,328) Ending Fund Balance $ $ 265,058 City of Tukwila Fire Improvements as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget 553,386 (131,862) $ 421.524 Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget REVENUE: Fire Impact Fees 300,000 450.000 750,000 697.505 (52.495) 232.5% Total Revenues EXPENDITURES: Transfers Out 300,000 450,000 750,000 697,505 (52,495) 232.5% 300,000 450,000 750,000 - (750.000) 0.0% Total Expenditures 300,000 450,000 750,000 (750,000) 0.0% Beginning Fund Balance Change in Fund Balance Ending Fund Balance 697,505 $ 697.505 23 67 City of Tukwila Public Safety Plan as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget REVENUE: Real Estate Excise Tax (REET) 500.000 - 500.000 154.045 (345.955) 30.8%I Fire Impact Fees 300.000 - 300.000 - (300.000) 0.0% Investment Earnings - 36,625 36,625 0.0% Transfers In 300.000 450.000 750.000 (750,000) 0.0% Total Revenues 1,100.000 450,000 1,550,000 190.670 (1,359,330) 17.3% EXPENDITURES: Repairs & Maintenance Services Transfers Out 1.319.019 1,319,019 Total Expenditures 1.319,019 (1,700) (1,700) 1,319,019 (1,700) Beginning Fund Balance Change in Fund Balance Ending Fund Balance 538,557 (219,019) $ 319,538 453,309 991,865 450,000 230,981 $ 1,222,846 City of Tukwila City Facilities as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget REVENUE: Investment Earnings Transfers In 1.000 - 1,000 2.140,000 1.000,000 3.140,000 Total Revenues 2,141,000 1,000,000 3,141,000 PROJECTS Public Works Shops 2,500,000 200,000 Minkler Improvements 200,000 (200,000) Other/Misc - - 2,700,000 0.0% (1,319,019) 0.0% (1,320.719) -0.1% 991,865 192,369 $ 1,184.235 Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget 26.541 25.541 (3.140.000) 2654.1% 0.0% 26.541 (3,114,459) 1.2% 1.779.370 (920,630) 71.2% 0.0% 0.0% Total Expenditures by Project 2,700,000 2.700,000 1,779.370 (920.630) 65.9% Beginning Fund Balance Change in Fund Balance Ending Fund Balance 2,274,324 (559.000) $ 1.715,324 (314.958) 1,959,366 1,000,000 441,000 $ 2,400,366 1.959.366 (1,752,829) $ 206.537 24 68 City of Tukwila Water Utility Fund as of September 30. 2023 8u:get Revised Variance Annual Amendments Annual Year to Date Oveo'IUnder) % of Annual BL.i.toct 1Consensusl Budget Actual Amual Budget Budget REVENUE: Viater Saes Security Revenue Interest on Recelvablez 21.000 7.647.000 6.161.545 8.557 21.000 19.143 11.485.4551 8.557 11.857) 80.6`5 0.0'%, 91.2'h TOW OperaSrg Revere ee 7.668.000 7.668.000 6.189.245 (1.478.755) 80.7% Investment Earning: 60.000 .50 C00 147 4.87 81.487 235.8` 1 Told Non-Ogenling Revenues 60.000 60.000 141.487 81.487 235.8% TOW Revenues 7 728.000 7.728.000 6 330.732 11.397.2681 81.9'%, EXPENDITURES. Salares 8 Wages 707.380 707.380 547.612 (159.768) 77.4% BeneCts 274.851 274.851 251.367 (23.484) 91.5% Supp:es 29.000 29.000 13.027 (15.973) 44.9% Repair & Mantenance Supplies 115.500 115.500 55.127 (60.373) 47.7% Small Tools 14.000 - 14.000 6.915 (7.085) 49.4% Technology Supplies 1.000 1.000 396 (604) 39.6% Utility rund Supplies 2773243 2.773.243 2.611.186 (162.057) 94.2% Professional Services 115.491 115,491 181.510 66.019 157.2% Communications 8.000 8.000 5.795 (2.205) 72.4% Pro(essonal Development 12.000 12.000 12.477 477 104.0% Advertising 1.459 1.459 0.0% Rentals 1.600 1.600 1,782 182 111.4% Technology Services 15.000 15.003 17,051 2.051 113.7% Utilities 46.600 46.600 19.599 (27.001) 42.1% Repairs 8 Maintenance Services 94.976 94.976 325.154 230.178 342.4% Other Expenses 1.131.750 1,131.750 998.851 (132.899) 88.3% TOW Operating Expendhoes 5.340.390 5.340.330 5.049.309 (291.082) 94.6% Other Capital Improvements 50.000 50.000 (50.000) 0.0% Construction Prolectr 1.880.000 1.880.000 466.103 (1.413.897) 24.8% Principal 122891 122.891 80.625 (42.266) 65.6% Interest Expense 4.929 4.929 2.868 (2.062) 58.2% Transfers Out 1.052.804 1,052.804 283.353 (769.451) 28.9% Indirect Cost AIlocrton 740.347 740.347 555.264 (185.083) 75.0% Ta111 NonOper.Lng ExpenditureS 3.850.972 3.650.972 ' 388.213 (2.462.7591 38.0% TOW 6tpendRwes 9.191.362 9.191.362 8.437522 (2.753.840) 70.0% Beginning Fund Balm •. Change it Fund Balance Ending fund Balance 4.690.562 (1.463.3821 S 3.227.2C0 479.614 5.170.176 '.463.3621 S 3.7C6 814 S 5.170.176 (106.7901 5.063.386 25 69 City of Tukwila Sewer Utility Fund as of September 30. 2023 Budget Rcwscd Annual Amendment: Annual Year to Data Budget (Consensus' Budget Budget Variance Year to Date Over,iUrder) % of Annual Actual Annual Budget Budget REVENUE Sewer Sates 10,802 300 10.802.300 8.101,725 7.659.358 i2 4=.942I 70 y`: Intern onRccenavabie: 30.000 30.000 22.500 45.7'5 15.7'5 -524` Told Operating Revenue* 10.832300 10.832.300 8.124,225 7,706.073 (3.1272271 71.1% Investment Earnings 50.000 50.000 37.500 369.050 319.050 738.1% Total Non-OpaeBlq Re en e8 50.000 50.000 37.500 369.050 319.050 738.1% Total Revenues 10.662300 10.882.300 8.161.725 8.074.123 12.808.177) 74.2% ExPENDfTUFRES: Salares 8 Wage: 947.190 947.190 710.393 648.398 (298.792) 68.5% Benefits 340.550 340.550 255.414 282.750 (57.801) 83.0% Supp:cs 6200 6.200 4.650 4.512 (1.688) 72.8% Repair & )d3ntenancc Swplres 17,600 17.600 13200 8.536 (9.064) 48.5% Small Tools 5.000 5.000 3.750 3,439 (1,561) 68.8% Technology Supplies 2.500 2.500 1.875 - (2500) 0.0% Utility rtrtd Supplas 5.525.960 5.525.950 4.144,470 3229.546 (2.29(5.414) 58.4% Professional Service.: 253437 253.437 197.312 244.816 (8.621) 96.8% Communications 7.000 7.000 5.250 2.994 (4.006) 42.8% Professional Development 5000 - 5.000 3,750 1.827 (3.173) 36.5% Adyorusmg - - 1.535 1,535 0.0% Rentals 24.916 24.916 18.687 17.199 (7,717) 69.0% Technology Services 153000 15.000 11250 18.341 3.341 122.3% Utilities 50.430 50.430 37.823 30.058 (20.372) 59.8% Repairs S Maintenance Services 1.127.567 1127.567 758.174 402.535 (725.032) 35.7% Other Expenses 1.342 930 1.342.930 1.007.197 • 007.454 035.476) 75.0% TOW Operating Experdlaee 9.671.281 9671281 7.173.194 5.903.941 13.787.340) 61.0% Corructron Pro.ectr. 1.300.000 1.300.030 866.667 '1,300.000) 0.0% Principal 334223 334.223 233.436 233436 (100.787) 69.8% Intern Expense 13.813 13.813 8.897 8.897 (4.916) 64.4% Transfers Out 605.949 605.949 460.963 175.962 (429.987) 29.0% Indirect Cost Allocaton 623.733 623.733 467.802 467.802 (155.931) 75.0% Total NonOpeailg Expenditures 2 877 719 2.877.719 2.037.764 888.097 (1.901.622) 30.8% Total Expers:Ilk/es 12,549.000 - 12509.003 9210.969 6.790.038 15,758.982) 54.1% Beginning rune O:rarce Chanoc n run:" "cc 11.742.027 536.097 12 278.125 (1.866.700) :56,7001 Endmq r.:•• • " S 10.075.327 S • 425 12 278.125 264.065 13 562.210 70 City of Tukwila Foster Golf Course as of September 30, 2023 3uoget Re•.' sei Annual Amendments Anrua Budget (Consensus) Buoget REVENUE: E..c se T3:.e3 3'-i Re_.ea:: i. Fees Total Operating Revenues 3.000 1.412.500 145.000 2.000 t C.000 100.000 Variance Year to Date Over!(Under) % of Annual Actual Annual Budget Budget 3.000 - (3.000) 0.0% 1.512.500 1.808.022 95.522 113.8% 145.000 150.473 5.473 103.8% 2.000 1.405 (595) 70.3% 10.000 28.886 18.888 288.9% 1 572.500 130.003 1.872.E 1.788.588 116.086 113.7% Investment Earnings 2000 Rent & Concessions 423.3C0 Transfers In 3C0.000 Sale of Capital Assets - 2,030 42.0.030 300.000 51.472 423.466 225.000 12.800 49.472 3.408 (75.000) 12.800 2573.8% 100.8% 75.0% C.0% Total Non -Operating Revenues 722.000 722.030 712.738 (9.262) 98 7% Total Revenues 2.294.500 100.000 2.394.500 2.501. 323 106.823 109.0 % EXPENDITURES: S3 3res & . ges 931.842 931.642 817.722 (314.519) 68.2% 3ene5s 372.040 372.040 272.193 (99.847) 73.2% Slop es 4.250 4.250 4.019 (231) 94.6% Repair & Maintenance Supplies 83.500 83.500 108.985 23.465 128.1% Resale Supp. es 98.500 96.500 101.050 4.550 104.7% Small Tools 4.500 4.500 82.585 78.085 1834.8% Fleet Supplies 38.000 - 38.000 28.688 (9.312) 74.1% Professional Services 32.575 25.000 57.575 58.816 (759) 174.4% Communications 4.900 4.900 7.176 2.278 148.5% Professional Development 1.935 - 1.935 1.990 55 102.8% Advertising 5.000 5.000 4.476 (524) 89.5% Rentals 39.000 39.000 28.167 (10.833) 72.2% Technology Services 4.000 4,000 - (4.000) 0.0% Utilities 82.700 - 82.700 70.180 (12.520) 84.9% Repairs & Maintenance Services 34.500 50.000 84.500 149.378 64.876 433.0% Other Expenses 30.520 25.000 55.520 65.728 10.206 215.4% Total Operating Expenditures 1.783.582 100.000 1.863.582 I 1.504.5111 (269.051) 90.4% Other Capital Improv e^-erts Machinery & Equipment Indirect Cost Allocation 230.000 80.000 310.000 (310.000) 0.0% 100.000 100.000 28.582 (71.418) 28.6% 219.309 219.309 184.484 (54.825) 75.0% Total NonOperating Expenditures 549.309 80.000 629.309 193.086 (438.243) 35.1% Total Expenditures 2.312.871 180.000 2.492.871 1.787.577 (705.294) 77.3% 27 71 City of Tukwila Surface Water Utility Fund as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget RE''.ENUE 7.717.500 Z 176.000 1.444.000 Total Operating Revenues 11.337.500 .es:me : Ear^. -- 7.717,500 2.178.000 1.444.000 Variance Year to Date Over;(Under) % of Annual Actual Annual Budget Budget 7.787.059 81,177 92.747 49.559 (2.114.823) (1.351.253) 100.8% 2.8% 8.4% 11,337.500 7.920.983 (3.416,517) 89.9% 30.000 30.000 230.693 230.693 789.0% Total Non -Operating Revenues 30.000 30.030 230.693 200.693 769.0% Total Revenues 11,367.500 11.387.500 8.151.677 (3.215.823) 71.7% EXPENDITURES: Sa ares & Wages 1.555.045 1.555.045 906.268 (848. 77) 58.3% Benefits 703.378 700.378 413.927 (286.451) 59.1% Suppmes 20.300 20.300 15.053 (5.247) 74.2% Repair & Maintenance Supplies 17.500 17.500 11.870 (5.830) 87.8% Small Tools 8,500 8,500 9.057 2.557 139.3% Technology Supplies 500 500 1.804 1.104 320.8% Professional Services 4.103,137 4.103.137 503.787 (3.599.350) 12.3% Communications 7.100 7,100 7,877 577 108.1% Professional Development 7.990 7.990 6.128 (1.884) 76.7% Advertising - - 1.939 1.939 0.0% Rentals 4,000 4.000 12 (3.988) 0.3% Technology Services 3.000 3.000 18.887 13.887 582.9% Utilities 90.885 90.685 18.170 (72.515) 20.0% Repairs & Maintenance Services 59.000 59.000 35.999 (23.001) 81.0% Other Expenses 882.475 882,475 853.337 (9.138) 98.9% Total Operating Expenditures 7.437.810 7.437,810 2.801.713 (4.635.397) 37.7% Other : ap:tal ! mp-overner s 900.000 900.030 - (930.000) 0.0% Construction Projects 1.687,000 1.887,000 30.114 (1.858.886) 1.8% Principal 278.883 278.883 250.358 (19.507) 93.0% Interest Expense 4,497 4,497 3.545 (952) 78.8% Transfers Out 1.441.812 1,441.612 377.959 (1,083.853) 26.2% Indirect Cost Allocation 659.842 859.842 494.883 (164.959) 75.0% To NonOperating Expenditures 4.971,813 4.971.813 Total Expenditures 1.165.857 (3.805.957) 23.4% 12,400.424 12.409.424 3067.570 (8.441.854) 32.0% 28 72 City of Tukwila Equipment Rental as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget Variance Yew to Date Over/(Under) % of Annual Actual Annual Budget Budget RE'.ENJE . _ . _ . _ _ _ 2.058.241 2.058.241 1.542,178 (514.065) 75.0% E. _ _ _ •_ : - - 85 85 0.0% Investment Earnings 20.000 20.000 153.138 133.138 785.7% Sa'e of Capital Assets 181,750 181.750 328.087 184.317 201.8% Total Revenues 2.237.991 2.237.991 2.021,464 (218.52, i 9C 3% EXPENDITURES: Sa ares & Wages 478.273 478,273 257.889 (218.404) 54.1% Benefits 227,102 227.102 130,859 (98.443) 57.5% SuppZies 3.350 3.350 2.316 (1.034) 89.1% Repair & Maintenance Supplies 643 843 0.0% Small Toots 10,750 10.750 4.482 (8.268) 41.7% Technology Supplies 8,200 8.200 339 (5.881) 5.5% Fleet Supplies 710.000 710,000 528.218 (181.783) 74.4% Professional Services 102.100 102.100 101.917 (183) 99.8% Communications 5.000 5.000 3.584 (1.438) 71.3% Professional Development 5,850 5.850 5.802 (48) 99.2% Advertising 50 50 0.0% Rentals 1,500 1.500 273.847 272,347 18258.5% Technology Services 10.500 10.500 4,684 (5.818) 44.8% Utilities 4,000 4,000 784 (3.238) 19.1% Repairs & Maintenance Services 153.771 153,771 200,143 46.372 130.2% Other Expenses 500 500 - (500) 0.0% Total Operating Expenditures 1.718.896 1,710,896 1,515.298 (201509) 88.3% Machinery & Equipment Indirect Cost Allocation 1.143.558 1.143.558 147,238 (998,318) 12.9% 350.392 350.392 282.791 (87.601) 75.0% Total NonOperating Expenditures 1.403.9413 1.493,948 410,029 (1.083.919) 27.4% Total Expenditures 3,210.844 3.210.844 1,925.328 (1.285.518) 80.0% Beginning Fund Balance 4.322.760 (100.403) 4.222.357 Change in Fund Balance (972.853) - (972.853) Ending Fund Balance S 3.349.937 $ 3.249.504 4.222.357 96.138 4.318.495 29 73 City of Tukwila Insurance - Active Employees as of September 30, 2023 REVENUE: Investment Earnings Employee Trust Contributions Employer Trust Contributions Budget Revised Annual Amendments Annual Budget (Consensus) Budget 6,000 294,885 5.903,457 6,000 294,885 5.903,457 Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget 149.059 143,059 117,362 (177.523) 4.202.484 (1,700.973) 2484.3% 39.8% 71.2% Total Revenues 6,204,342 6,204,342 4,468,905 (1,735,437) 72.0% EXPENDITURES: Insurance Program Costs 5,750,222 5,750,222 4,102.303 (1,647,919) 71.3% Supplies 628 628 0.0% Professional Services 100,000 100,000 47.577 (52.423) 47.6% Other Expenses 21,000 21,000 102 (20.898) 0.5% Total Operating Expenditures 5,871,222 5,871,222 4,150,610 (1,720.612) 70.7% Indirect Cost Allocation 189,639 - 189.639 142.227 (47.412) 75.0% Total NonOperating Expenditures 189,639 189,639 142,227 (47,412) 75.0% Total Expenditures 6,060,861 6.060,861 4,292,837 (1,768.024) 70.8% Beginning Fund Balance 764,171 1,607,526 2,371,697 Change in Fund Balance 143,481 - 143,481 Ending Fund Balance $ 907,652 $ 2,515,178 City of Tukwila Insurance - LEOFF I Retirees as of September 30, 2023 2,371,697 176.068 $ 2,547,766 Budget Revised Annual Amendments Annual Budget (Consensus) Budget Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget REVENUE: Investment Earnings 500 500 5.583 5,083 1116.6% Employer Trust Contributions 350,000 50.000 400,000 239.738 (160.262) 68.5% Total Revenues 350,500 50,000 400,500 245.321 (155,179) 70.0% EXPENDITURES: Insurance Program Costs 426,296 - 426,296 348.239 (78,057) 81.7% Professional Services 5,000 - 5,000 (5,000) 0.0% Other Expenses 500 500 (500) 0.0% Total Operating Expenditures 431,796 431,796 348.239 (83,557) 80.6% Indirect Cost Allocation 12.642 - 12.642 9.486 (3,156) 75.0% Total NonOperating Expenditures 12.642 12.642 9.486 (3.156) 75.0% Total Expenditures 444,438 444,438 357,725 (86,713) 80.5% Beginning Fund Balance Change in Fund Balance Ending Fund Balance 258,737 (93.938) $ 164,799 (84,183) 174,554 50,000 (43.938) $ 130,616 174,554 (112,404) $ 62.150 30 74 City of Tukwila Firemen's Pension Fund as of September 30, 2023 Budget Revised Annual Amendments Annual Budget (Consensus) Budget Variance Year to Date Over/(Under) % of Annual Actual Annual Budget Budget REVENUE: Fire Insurance Premium Tax 74.000 - 74,000 86.708 12,708 117.2% Investment Earnings 1.500 - 1.500 55,424 53.924 3694.9% Total Revenues 75,500 - 75,500 142.132 66,632 188.3% EXPENDITURES: Benefits 60,000 60,000 - (60.000) 0.0% Professional Services 2,000 2,000 - (2.000) 0.0% Total Operating Expenditures 62,000 62,000 (62.000) 0.0% Total NonOperating Expenditures - 0.0% Total Expenditures 62,000 62,000 (62.000) 0.0% Beginning Fund Balance 1,543,370 22,737 1,566,108 Change in Fund Balance 13.500 - 13,500 Ending Fund Balance $ 1,556,870 $ 1,579,608 1,566,108 142,132 $ 1,708.240 31 75