Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Adden 3
February 8th, 2022 City of Renton Attn: Kari Roller 1055 S Grady Way Renton, WA 98057 PERIOD: 2022 INVOICE NO: 119 AMOUNT: $35,562.00 Pursuant to Section 13.g and Section 13.j. of the Interlocal Agreement, we are submitting invoice No. 119 for the year of 2022 for cost allocation totaling $35,562. Reimbursable Costs $ 33,562 Capital Cost Recovery Charges 2,000 Total $ 35,562 Please make a check payable to: Washington Multi-City Business License and Tax Portal Agency Attn: Francis & Company PLLC (Accountant) 200 W Mercer St, Suite 208 Seattle, Washington 98119 Please contact Kevin Fitzpatrick at 206.233.2513 for any questions you may have regarding this invoice. Thank you very much! CAG-18-164, Adden #3-22 Resolution No. FL2021-05 Page 1 of 2 1 RESOLUTION NO. FL2021-05 2 3 A Resolution of the Washington Multi-City Business 4 License and Tax Portal Agency Executive Board 5 adopting a final 2022-2026 Budget. 6 7 8 Whereas, the Washington Multi-City Business License and Tax Portal Agency 9 (“Portal Agency”) Interlocal Agreement (“Agreement”) requires the Executive Board to 10 adopt a draft Portal Agency 2022 budget by June 15; 11 12 Whereas, the Program Manager shall present a proposed budget to the 13 Executive Board no later than May 1 prior to the commencement of the budget period, 14 together with the Operation Committee’s recommendations with respect to the proposed 15 budget; 16 17 Whereas, the Executive Board received a draft 2022-2026 budget for review on 18 March 18, 2021 and approved the draft 2022-2026 Budget on May 27, 2021. 19 20 Whereas, the cities of Bellevue, Des Moines, Everett, Kent, Lake Forest Park, 21 Renton, Seattle, and Tacoma have each informed the Portal Agency by 22 December 1, 2021 that they will or have approved their shares of the Portal Agency 23 budget for 2022-2026. 24 25 Now Therefore, 26 27 BE IT RESOLVED by the Executive Board of the Washington Multi-City 28 Business License and Tax Portal Agency: 29 30 SECTION 1. The Executive Board hereby adopts the final 2022-2026 budget for 31 the Portal Agency as set forth in Exhibit A to this Resolution. 32 12-16-21 FY2022-FY2026 Final Budget 2 Washington Cities Business License and Tax Portal Agency Summary of Budget FY2022-FY2026 12-16-21 FY2022-FY2026 Budget Final 2020 (A) 2021 Budget Approved - Dec 2020 2022 (B)2023 (B)2024 (B)2025 (B)2026 (B) 2021 (B) vs. 2020 (B) 2022 (B) vs. 2021 (B) 2023 (B) vs. 2022 (B) 2024 (B) vs. 2023 (B) 2025 (B) vs. 2024 (B) 2026 (B) vs. 2025 (B) Revenue: Fund Carryover T4 - - - - - - - - - - - - - User Fees T1 437,628 497,196 550,500 576,921 588,747 600,655 612,719 59,568 53,304 26,421 11,826 11,908 12,064 Reimbursable Costs T3 839,331 849,041 781,844 812,641 842,648 877,057 912,767 9,710 (67,197) 30,796 30,007 34,409 35,710 Capital Cost Recovery Charges T2 21,000 16,000 20,500 20,500 20,500 20,500 20,500 (5,000) 4,500 - - - - Total Revenue B/(W)1,297,959 1,362,237 1,352,844 1,410,062 1,451,895 1,498,211 1,545,985 64,278 (9,393) 57,217 41,833 46,317 47,774 Expenditures Regular Expenditures: Labor T4.1 416,739 390,611 422,376 435,047 448,099 461,542 475,388 26,128 (31,765) (12,671) (13,051) (13,443) (13,846) Contracts T4.2 52,175 62,387 71,762 73,341 74,998 76,896 78,841 (10,212) (9,375) (1,579) (1,658) (1,897) (1,945) Overhead T4.3 20,379 48,820 69,801 71,512 73,295 75,259 77,276 (28,441) (20,981) (1,711) (1,784) (1,964) (2,017) Technology Costs T4.4 429,723 741,760 758,810 791,248 817,084 845,293 874,641 (312,038) (17,050) (32,438) (25,836) (28,210) (29,347) Operating Reserve T4.5 12,972 13,894 0 7,463 6,430 6,880 7,129 (922) 13,894 (7,463) 1,033 (450) (249) Capital Cost Recovery Payments T4.6 21,000 16,000 20,500 20,500 20,500 20,500 20,500 5,000 (4,500) - - - - Total Regular Expenditures 952,988 1,273,472 1,343,249 1,399,111 1,440,406 1,486,370 1,533,775 (320,485) (69,777) (55,862) (41,295) (45,964) (47,405) Incremental Expenses from The New Partners: Incremental Labor T4.1 - 56,314 3,203 3,689 3,924 4,096 4,278 (56,314) 53,111 (486) (234) (172) (182) Incremental Overhead T4.3 - 8,916 386 436 454 466 478 (8,916) 8,530 (49) (19) (12) (12) Incremental Technology Cost T4.4 - 23,535 6,006 6,826 7,111 7,279 7,455 (23,535) 17,529 (820) (286) (168) (175) Total Incremental Expenditures - 88,765 9,596 10,951 11,489 11,841 12,211 (88,765) 79,169 (1,355) (538) (352) (369) Total Expenditures B/(W)952,988 1,362,237 1,352,844 1,410,062 1,451,895 1,498,211 1,545,985 (409,250) 9,393 (57,217) (41,833) (46,317) (47,774) 344,971 (0) - - - - - (344,972) 0 (0) (0) 0 (0) Revenue T1 FY2022 (B) user fees are up $53k compared to FY2021 (B). This is due to an increase in transaction count by approximately 18K. T3 FY2022 (B) reimbursable costs decreases due primarily to the increase in transactions. Expense T4.1 FY2022 (B) Labor increases by approximately 3%. T4.2 FY2022 (B) Contracts increases by $10k, due to the estimated CPI inflation adjustments and additional costs for accounting T4.3 FY2022 (B) Overhead increased versus FY2021 due to estimated CPI inflation adjustments. T4.4 FY2022 (B) Technology costs are up by $17K. This is primarily due to the the estimated CPI inflation, and higher transaction numbers. T4.1/.3/.4 FY2022 (B) Incremental labor, overhead and technology costs are reflecting the incremental costs from Auburn and Kent. B/(W) Excess (Deficit) Actual (A), Projection (P), Budget (B) 3 Washington Cities Business License and Tax Portal Agency Key Assumptions for Budget FY2022-FY2026 12-16-21 FY2022-FY2026 Budget Final Assumptions and Notes Revenue Fund Carryover T4 Fund Carryover is the process by which unobligated funds remaining at the end of the budget period may be carried over to the next budget period. This is typically approved during the December Board Meeting User Fees T1 User Fees are fees charged to the business user for each city specific transaction net of zero dollar returns. The allocation methodology is based on projected transaction amounts. Reimbursable Costs T3 Costs to be reimbursed by participating cities. Capital Cost Recovery Charges T2/T4.6 Capital Cost Recovery Charge is an annual fee charged to all participating cities other than Seattle, for the purposes of reimbursing Seattle for a portion of the funding provided to pay for the start up of the Portal Agency. See Section 13.j in the Interlocal Agreement for further information. Expense Labor T4.1 Labor is broken into two primary categories. Agency employees which are budgeted based on City of Seattle estimates and Incremental Labor which is based on new city additions with the calculation determined in the Interlocal Agreement. Contracts T4.2 Consulting and Service Fees - is comprised of Outside Accounting, State Auditor, Insurance and Bank Fees. Overhead T4.3 Overhead is comprised of Legal, City of Seattle Technology Fees, Office and Operating Supplies, Printing, Licenses, Travel, Marketing, Incremental Technology Costs T4.4 Technology Costs are outside IT Costs and comprised of ASP Hosting, Software as a Service, USPS Address Lists, Transaction Fees, IT and Security Audit, Misc. Technology, Software Development and Incremental IT. Operating Reserve T4.5 Operating Reserve is an unrestricted fund balance set aside to provide a cushion against unexpected events. The current operating reserve is 15% of total operating expenditures. Incremental Labor T4.1 Incremental Labor, Overhead and Technology Costs are amounts calculated with each new city to determine the maximum amount which costs can increase as new cities are added. Incremental Overhead T4.3 Incremental Labor, Overhead and Technology Costs are amounts calculated with each new city to determine the maximum amount which costs can increase as new cities are added. Incremental Technology Cos T4.4 Incremental Labor, Overhead and Technology Costs are amounts calculated with each new city to determine the maximum amount which costs can increase as new cities are added. 4 Washington Cities Business License and Tax Portal Agency Summary of Budget FY2022-FY2026 May 2021 Draft FY2022-FY2026 w Auburn Bridge 2022 (B)2023 (B)2024 (B)2025 (B)2026 (B)2022 (B)2023 (B)2024 (B)2025 (B)2026 (B)2022 (B)2023 (B)2024 (B)2025 (B)2026 (B) Transaction counts: 183,500 192,307 196,249 200,218 204,240 183,100 191,827 195,697 199,611 203,602 400 480 552 607 638 Revenue: Fund Carryover 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 User Fees 550,500 576,921 588,747 600,655 612,719 549,300 575,481 587,091 598,833 610,806 1,200 1,440 1,656 1,822 1,913 Reimbursable Costs 781,844 812,641 842,648 877,057 912,767 779,159 810,486 840,532 874,949 910,631 2,685 2,155 2,116 2,109 2,136 Capital Cost Recovery Charges 20,500 20,500 20,500 20,500 20,500 18,500 18,500 25,000 25,000 25,000 2,000 2,000 -4,500 -4,500 -4,500 Total Revenue B/(W)1,352,844 1,410,062 1,451,895 1,498,212 1,545,986 1,346,959 1,404,467 1,452,623 1,498,782 1,546,437 5,885 5,595 -728 -570 -452 Expenditures Regular Expenditures: Labor 416,666 437,499 459,374 482,343 506,460 416,665 437,499 459,374 482,342 506,460 1 1 1 1 1 Contracts 71,762 73,341 74,998 76,895 78,841 71,762 73,341 74,998 76,895 78,841 0 0 0 0 0 Overhead 50,243 51,348 52,509 53,837 55,200 50,243 51,348 52,509 53,837 55,200 0 0 0 0 0 Technology Costs 784,078 808,959 826,595 845,915 865,646 783,438 808,191 825,712 844,943 864,625 640 768 883 972 1,020 Operating Reserve 0 7,463 6,430 6,880 7,129 -507 7,435 6,403 6,856 7,110 507 28 27 24 19 Capital Cost Recovery Payments 20,500 20,500 20,500 20,500 20,500 18,500 18,500 25,000 25,000 25,000 2,000 2,000 -4,500 -4,500 -4,500 Total Regular Expenditures 1,343,249 1,399,111 1,440,406 1,486,370 1,533,775 1,340,101 1,396,314 1,443,996 1,489,874 1,537,236 3,147 2,797 -3,589 -3,504 -3,461 Incremental Expenses from The New Partners: Incremental Labor 3,203 3,689 3,924 4,096 4,278 2,288 2,754 2,967 3,115 3,272 915 935 956 980 1,005 Incremental Overhead 386 436 454 466 478 276 323 339 348 357 110 113 115 119 122 Incremental Technology Cost 6,006 6,826 7,111 7,279 7,455 4,293 5,075 5,321 5,444 5,573 1,712 1,750 1,790 1,835 1,882 Total Incremental Expenditures 9,596 10,951 11,489 11,841 12,211 6,857 8,153 8,627 8,907 9,202 2,738 2,798 2,862 2,934 3,009 Total Expenditures B/(W)1,352,844 1,410,062 1,451,895 1,498,212 1,545,986 1,346,959 1,404,467 1,452,623 1,498,782 1,546,437 5,885 5,595 -728 -570 -452 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 May 2021 Draft Budget Delta Actual (A), Projection (P), Budget (B)Actual (A), Projection (P), Budget (B) Excess (Deficit) Actual (A), Projection (P), Budget (B) May 2021 Draft with Auburn 5 Washington Cities Business License and Tax Portal Agency Summary of Budget FY2022-FY2026 2022 (B)2023 (B)2024 (B)2025 (B)2026 (B)2022 (B)2023 (B)2024 (B)2025 (B)2026 (B)2022 (B)2023 (B)2024 (B)2025 (B)2026 (B) Reimbursable Costs Auburn 9,897 10,286 10,666 11,102 11,554 0 0 0 0 0 9,897 10,286 10,666 11,102 11,554 Bellevue 67,357 70,011 72,596 75,560 78,637 67,987 70,720 73,342 76,345 79,458 -629 -710 -746 -785 -822 Bremertion 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Des Moines 15,028 15,620 16,197 16,858 17,544 15,168 15,778 16,363 17,033 17,728 -140 -158 -166 -175 -183 Everett 31,345 32,580 33,783 35,162 36,594 31,638 32,910 34,130 35,527 36,976 -293 -330 -347 -365 -382 Kent 16,335 16,978 17,605 18,324 19,070 16,487 17,150 17,786 18,514 19,269 -153 -172 -181 -190 -199 Lake Forest Park 7,623 7,923 8,216 8,551 8,899 7,694 8,003 8,300 8,640 8,992 -71 -80 -84 -89 -93 Renton 33,562 34,884 36,172 37,649 39,182 33,876 35,238 36,544 38,040 39,592 -314 -354 -372 -391 -409 Seattle 462,720 480,947 498,706 519,070 540,205 467,043 485,821 503,831 524,461 545,850 -4,323 -4,874 -5,125 -5,391 -5,645 Shoreline 12,745 13,247 13,737 14,297 14,880 12,864 13,382 13,878 14,446 15,035 -119 -134 -141 -148 -155 Snoqualmie 16,335 16,978 17,605 18,324 19,070 16,487 17,150 17,786 18,514 19,269 -153 -172 -181 -190 -199 Tacoma 108,897 113,187 117,366 122,159 127,133 109,915 114,334 118,573 123,428 128,461 -1,017 -1,147 -1,206 -1,269 -1,329 Total 781,844 812,641 842,648 877,057 912,767 779,159 810,486 840,532 874,949 910,631 2,685 2,155 2,116 2,109 2,136 Actual (A), Projection (P), Budget (B)Actual (A), Projection (P), Budget (B) May 2021 Draft FY2022-FY2026 w Auburn Bridge - Reimbursement May 2021 Draft with Auburn May 2021 Draft Budget Delta Actual (A), Projection (P), Budget (B) 6 Washington Cities Business License and Tax Portal Agency Summary of Budget FY2022-FY2026 December 2021 Final vrs May 2021 w Auburn Bridge 2022 (B)2023 (B)2024 (B)2025 (B)2026 (B)2022 (B)2023 (B)2024 (B)2025 (B)2026 (B)2022 (B)2023 (B)2024 (B)2025 (B)2026 (B) Transaction counts: 183,500 192,307 196,249 200,218 204,240 183,500 192,307 196,249 200,218 204,240 0 0 0 0 0 Revenue: Fund Carryover 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 User Fees 550,500 576,921 588,747 600,655 612,719 550,500 576,921 588,747 600,655 612,719 0 0 0 0 0 Reimbursable Costs 781,844 812,641 842,648 877,057 912,767 781,844 812,641 842,648 877,057 912,767 0 0 -1 0 0 Capital Cost Recovery Charges 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 0 0 0 0 0 Total Revenue B/(W)1,352,844 1,410,062 1,451,895 1,498,211 1,545,985 1,352,844 1,410,062 1,451,895 1,498,212 1,545,986 0 0 -1 0 0 Expenditures Regular Expenditures: Labor 422,376 435,047 448,099 461,542 475,388 416,666 437,499 459,374 482,343 506,460 5,710 -2,452 -11,276 -20,801 -31,072 Contracts 71,762 73,341 74,998 76,896 78,841 71,762 73,341 74,998 76,895 78,841 0 0 0 0 0 Overhead 69,801 71,512 73,295 75,259 77,276 50,243 51,348 52,509 53,837 55,200 19,557 20,163 20,786 21,422 22,077 Technology Costs 758,810 791,248 817,084 845,293 874,641 784,078 808,959 826,595 845,915 865,646 -25,267 -17,711 -9,512 -621 8,995 Operating Reserve 0 7,463 6,430 6,880 7,129 0 7,463 6,430 6,880 7,129 0 0 0 0 0 Capital Cost Recovery Payments 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 20,500 0 0 0 0 0 Total Regular Expenditures 1,343,249 1,399,111 1,440,406 1,486,370 1,533,775 1,343,249 1,399,111 1,440,406 1,486,370 1,533,775 0 0 -1 0 0 Incremental Labor 3,203 3,689 3,924 4,096 4,278 3,203 3,689 3,924 4,096 4,278 0 0 0 0 0 Incremental Overhead 386 436 454 466 478 386 436 454 466 478 0 0 0 0 0 Incremental Technology Cost 6,006 6,826 7,111 7,279 7,455 6,006 6,826 7,111 7,279 7,455 0 0 0 0 0 Total Incremental Expenditures 9,596 10,951 11,489 11,841 12,211 9,596 10,951 11,489 11,841 12,211 0 0 0 0 0 Total Expenditures B/(W)1,352,844 1,410,062 1,451,895 1,498,211 1,545,985 1,352,844 1,410,062 1,451,895 1,498,212 1,545,986 0 0 -1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 December 2021 Final Incremental Expenses from The New Partners: Delta Actual (A), Projection (P), Budget (B) May 2021 Draft with Auburn Actual (A), Projection (P), Budget (B) Excess (Deficit) Actual (A), Projection (P), Budget (B) 7 Washington Cities Business License and Tax Portal Agency Summary of Budget FY2022-FY2026 2022 (B)2023 (B)2024 (B)2025 (B)2026 (B)2022 (B)2023 (B)2024 (B)2025 (B)2026 (B)2022 (B)2023 (B)2024 (B)2025 (B)2026 (B) Reimbursable Costs Auburn 9,897 10,286 10,666 11,102 11,554 9,897 10,286 10,666 11,102 11,554 0 0 0 0 0 Bellevue 67,357 70,011 72,596 75,560 78,637 67,357 70,011 72,596 75,560 78,637 0 0 0 0 0 Bremertion 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Des Moines 15,028 15,620 16,197 16,858 17,544 15,028 15,620 16,197 16,858 17,544 0 0 0 0 0 Everett 31,345 32,580 33,783 35,162 36,594 31,345 32,580 33,783 35,162 36,594 0 0 0 0 0 Kent 16,335 16,978 17,605 18,324 19,070 16,335 16,978 17,605 18,324 19,070 0 0 0 0 0 Lake Forest Park 7,623 7,923 8,216 8,551 8,899 7,623 7,923 8,216 8,551 8,899 0 0 0 0 0 Renton 33,562 34,884 36,172 37,649 39,182 33,562 34,884 36,172 37,649 39,182 0 0 0 0 0 Seattle 462,720 480,947 498,706 519,070 540,204 462,720 480,947 498,706 519,070 540,205 0 0 0 0 0 Shoreline 12,745 13,247 13,737 14,297 14,880 12,745 13,247 13,737 14,297 14,880 0 0 0 0 0 Snoqualmie 16,335 16,978 17,605 18,324 19,070 16,335 16,978 17,605 18,324 19,070 0 0 0 0 0 Tacoma 108,897 113,187 117,366 122,159 127,133 108,897 113,187 117,366 122,159 127,133 0 0 0 0 0 Total 781,844 812,641 842,648 877,057 912,767 781,844 812,641 842,648 877,057 912,767 0 0 -1 0 0 Actual (A), Projection (P), Budget (B) December 2021 Final Delta Actual (A), Projection (P), Budget (B) May 2021 Draft with Auburn Actual (A), Projection (P), Budget (B) December 2021 Final vrs May 2021 w Auburn Bridge - Reimbursement