Loading...
HomeMy WebLinkAboutQUARTER 4 2021 Finance Department  Memorandum         DATE: April 7, 2022     TO: Ryan McIrvin, Council President  Members of Renton City Council    CC: Armondo Pavone, Mayor  Ed VanValey, Chief Administrative Officer     FROM: Kari Roller, Finance Administrator     SUBJECT: Quarterly Financial Report 4th Quarter 2021       The attached report provides a detailed discussion of General Fund revenues and  expenditures with comparison to prior year and budget through the end of December  2021.      Detailed explanations are provided for General Fund revenue and expenditure items with  variances exceeding $100K.    Also provided are tables for each of the City’s other funds with comparison to prior year  and annual budget (YTD budgets are not prepared for City funds, with the exception of  the General Fund). For funds that adopt capital project budgets (which are subject to carry  forward in accordance with City Policy 220‐01), schedules of the project budgets have  also been provided.     Please do not hesitate to contact me at x6931 should you have any questions or any  suggestions about the report.            Page 1 of 41   OVERVIEW  This quarterly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through December  31, 2021. A detailed analysis, including current to prior year and budget to actual comparison is included for each City fund.  Excluded from this report are the City’s fiduciary funds as these funds are held on behalf of others and are not available for  City use. Budget figures shown reflect amounts authorized in ORD 6030, which includes the mid‐biennial budget adjustment  approved November 15, 2021.     GENERAL FUND  The General Fund is used to account for resources that are not generally dedicated for a specific purpose. The General Fund  is used to meet the basic services that the City provides including, but not limited to, police protection, parks and recreation,  human services, municipal court, street maintenance and planning, economic development, and administrative functions.  The table below displays the YTD revenues and expenditures for the General Fund, including comparison to prior year,  comparison to YTD budget amounts, and percentage of annual budget. YTD budget amounts are generally based on the  collection/disbursement patterns for the same period of the preceding two (2) years, with the following exceptions: property  tax revenue budgets are based on the collection patterns over the preceding four (4) years and sales tax revenue budgets are  based on the collection patterns over the preceding five (5) years.           General Fund YTD Prior Year YTD YTD Budget % BUDGET REVENUES Taxes 89,542,897$    78,953,070$     82,709,450$   93,151,259$    14,198,188$    10,441,809$    112.62% Licenses & Permits 5,750,061        5,199,555          4,696,877        5,255,808        56,253              558,931            111.90% Intergovernmental 4,820,547        9,387,904          25,869,099     8,843,799        (544,105)          (17,025,300)     34.19% Charges for Services 9,251,750        7,514,930          8,198,287        8,988,252        1,473,322        789,965            109.64% Fines and Penalties 4,688,980        3,310,279          4,102,782        4,622,320        1,312,041        519,538            112.66% Miscellaneous 3,764,087        2,465,125          1,319,497        1,752,739        (712,386)          433,242            132.83% Other Financing Sources (Transfer‐In, etc)13,239,402      17,656,495        (700,518)          (614,116)          (18,270,611)     86,402              N/A TOTAL REVENUES 131,057,724    124,487,359     126,195,474   122,000,061    (2,487,298)       (4,195,413)       96.68% EXPENDITURES City Attorney 2,353,520        2,207,330          2,611,347        2,440,372        (233,042)          170,975            93.45% Community and Economic Development 8,933,092        10,628,438        14,069,591     9,980,902        647,536            4,088,689        70.94% Council 359,238            425,744             554,485           592,930            (167,186)          (38,445)             106.93% Court Services 2,406,014        2,444,436          3,102,930        2,622,084        (177,648)          480,846            84.50% Equity, Housing, and Human Services 1,500,007        1,507,729          5,255,831        3,139,627        (1,631,898)       2,116,204        59.74% Executive Services 4,526,126        9,430,132          5,482,516        4,375,713        5,054,417        1,106,803        79.81% Finance 3,327,937        3,503,205          4,370,474        3,844,375        (341,170)          526,099            87.96% Human Resources 1,438,605        1,393,876          1,679,007        1,398,222        (4,346)               280,785            83.28% Parks and Recreation 13,963,819      11,963,172        16,585,246     12,281,771      (318,599)          4,303,475        74.05% Police 43,145,496      37,771,599        44,262,711     41,077,136      (3,305,539)       3,185,575        92.80% Public Works 15,288,231      13,502,943        14,724,792     13,182,027      320,916            1,542,765        89.52% Other Non‐Departmental 30,357,614      23,408,019        14,928,681     12,418,824      10,989,195      2,509,857        83.19% TOTAL EXPENDITURES 127,599,699    118,186,624     127,627,611   107,353,983    10,832,636      20,273,628      84.12% Change in Fund Balance 3,458,024        6,300,735          (1,432,137)      14,646,078      8,345,343        16,078,215      N/A Beginning Fund Balance 44,697,823      48,155,847        54,456,582     54,456,582      6,300,735         ‐                     100.00% ENDING FUND BALANCE 48,155,847$    54,456,582$     53,024,445$   69,102,660$    14,646,078$    16,078,215$    130.32% Operating Reserve 9,405,500        9,405,500         Economic Development Reserve 2,500,000        2,500,000         AVAILABLE FUND BALANCE 41,118,945$   57,197,160$     Summary of Sources and Uses Annual Actual Favorable (Unfavorable) 2019 2020 2021 Variance Annual Actual Annual Budget YTD Actual Quarterly Financial Report 4th Quarter 2021  Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 2 of 41   GENERAL FUND REVENUES  The following tables provide a more detailed summary of each revenue category within the General Fund. Detailed  explanations have been provided for variances from prior year or YTD budget in excess of $100K. All variances are shown in  a favourable/(unfavourable) format.    TAXES        Property Tax – Property tax collections by King County have exceeded prior year and YTD budget. $255K of property taxes  collected through December 31 were for prior years’ delinquent taxes, bringing the balance of delinquent taxes receivable to  $37K. The remainder of taxes collected were for the 2021 levy. The 2021 property tax levy, after levy changes by the assessor’s  office, totalled $22,794,007. The taxes receivable balance for the 2021 levy is $269K at December 31.     Local Retail Sales Tax – Local retail sales tax exceeded prior year and YTD budget. The majority of the increase in local retail  sale tax revenues over the prior year is coming from the general retail and automotive sectors.  It is important to note that  sales tax revenues have a two month lag between the time of the sale and the City’s receipt of the sale tax from the State.   Please see the December sales tax report for information regarding sales tax figures by industry.     State Sales Tax Credit – The City was awarded $500k per year in sales tax credit revenues under the Local Revitalization  Financing program. This award is to pay the debt service on the LRF bonds issued in 2019 to fund public improvements within  the South Lake Washington Local Revitalization Area.     In accordance with SHB 1406, the City passed ORD 5972 authorizing a .0073 sales and use tax for affordable and supportive  housing. The City began collecting these sales tax credit revenues in December 2020.    The City also received a one‐time payment in the amount of $587K in May 2020 related to sales tax credit revenues owed for  the Benson Hill Annexation. This on‐time payment was the result of an audit at the State level where it was determined the  State had underpaid the City in 2019.    Criminal Justice Sales Tax – The criminal justice sales tax is a 0.1% sales tax imposed by the County for criminal justice  purposes. The County must share 90% of the revenues collected with all cities and towns in the county on a per capita basis.  The increase in criminal justice sales tax directly relates to the increase in local retail sales tax, as described above.    Utility Tax – The amount of utility tax over budget is due to a combination of factors. Some taxes are under budget while  others have exceeded budget. The notable differences are (1) the overall budget was decreased at the mid‐biennial budget  adjustment as revenues were slow to come in due to the pandemic.  After the utility moratorium was lifted; we did see an  increase in utility tax payments in the 4th quarter of the year.  (2) cellular utility taxes continue to decrease due to the change  in how cell companies account for their various bunded services that include an exemption for cell data and (3) the garbage  utility tax was higher in 2020 due to a tax audit which discovered taxes due from 2016‐2020 of $253K that were recognized  in 2020.  The breakdown of Utility Tax is as follows:    2020 2021 2021 Actual Budget Actual $ % $ % Property Tax 21,874,241         22,554,697          22,582,760         708,519              3.2% 28,063                 0.1% Local Retail Sales Tax 26,452,836         27,959,932          32,659,994         6,207,158         23.5% 4,700,062         16.8% State Sales Tax Credit 1,292,834            736,380                 790,863                 (501,971)             ‐38.8%54,483                 7.4% Criminal Justice Sales Tax 3,017,430            2,988,502             3,440,504            423,074              14.0% 452,002              15.1% Natural Gas Use Tax 123,787                 110,900                 135,207                 11,420                 9.2% 24,307                 21.9% Admission Tax 85,174                    15,000                    31,794                    (53,380)                ‐62.7%16,794                 112.0% Utility Tax 15,916,169         14,414,739          16,664,174         748,005              4.7% 2,249,435         15.6% Leasehold Excise Tax 183,450                 129,300                 168,949                 (14,501)                ‐7.9%39,649                 30.7% Gambling Excise Tax 2,391,499            2,800,000             4,063,341            1,671,842         69.9% 1,263,341         45.1% B&O Tax 7,615,650            11,000,000          12,613,673         4,998,023         65.6% 1,613,673         14.7% YTD Total 78,953,070$      82,709,450$       93,151,259$      14,198,189$   18.0% 10,441,809$   12.6% Taxes by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through December Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 3 of 41       Gambling Excise Tax – Gambling excise taxes have not only exceeded prior year and YTD budget, but they have exceeded the  same period in 2019 by approximately $1.2 million as well. This tax can fluctuate based on economy therefore the budget is  set at an average amount over the past several years.    Business and Occupation (B&O) Tax – B&O tax revenues rely heavily on the revenue of a limited number of large businesses.  Payments received in the 1st quarter of each year are generally for activity in the 4th quarter of the prior year. $1.3M of the  $4.9M over the 2020 revenue is due to one taxpayer who had a 4th quarter amount due for the first time as they had reached  the B&O tax “cap” in prior years; $3M of the $4.9M over the 2020 revenue is due to one taxpayer who has seen large  improvement in revenues over 2020; the rest of the increase is due to various businesses.     LICENSES & PERMITS      Franchise Fees – Franchise permits grant authority to a provider to use the City’s right‐of‐way to provide or distribute its  services. Franchises are most commonly used to provide utility or telecommunications service. The amount of franchise fees  over the prior year and over budget are the result of increased permitting activity.    Business Licenses – The amount of business license revenue over budget is due to better than expected economic recovery.  The business license revenue budget was adjusted down at the start of the pandemic and has remained low as it was unknown  how quickly the economy would recover and how many businesses would be able to survive the COVID restrictions placed  on businesses.     Building Permits – Building permit revenues are down slightly from the prior year due to a general slow down in the  construction industry.   Building permits are collected upon permit issuance.     INTERGOVERNMENTAL      2020 2021 2021 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Electrical 5,497,851$      4,649,175$      5,783,016$               285,165$                   5.2% $   1,133,841 24.4% Natural Gas 1,583,721        1,223,009        1,606,373                  22,652                       1.4%          383,364 31.4% Cell 787,466            524,273            571,889                     (215,577)                     ‐27.4%            47,616 9.1% Phone 661,593            702,901            826,519                     164,926                     24.9%          123,618 17.6% Cable 1,447,676        1,201,847        1,422,996                  (24,680)                       ‐1.7%          221,149 18.4% Garbage 970,481            713,057            744,745                     (225,736)                     ‐23.3%            31,688 4.4% City Utilities 4,967,381        5,400,477        5,708,636                  741,255                     14.9%          308,159 5.7% YTD Total 15,916,169$    14,414,739$    16,664,174$             748,005$                   4.7%2,249,435$    15.6% 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % Franchise Fees 1,497,985         1,231,692          1,598,057         100,072          6.7% 366,365          29.7% Business Licenses 1,009,760         868,780             1,085,936         76,176             7.5% 217,156          25.0% Animal Licenses 71,445               63,174               67,890               (3,555)               ‐5.0%4,716               7.5% Building Permits 2,589,530         2,485,731          2,461,650         (127,880)          ‐4.9% (24,081)            ‐1.0% ROW/Street Excavation Permits 30,870               46,500               41,765               10,895             35.3%(4,735)               ‐10.2% Special Event Permits (35)                      1,000                  510                     545                  ‐1557.1% (490)                  ‐49.0% YTD Total 5,199,555$       4,696,877$       5,255,808$       56,253$          1.1% 558,931$        11.9% Licenses & Permits by Type Year to Date through December Revenue 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % State Shared Revenue 3,972,802$         4,202,865$          4,463,820            491,018$           12.4% 260,955$           6.2% Federal Grants 5,122,365            20,759,349          4,020,044            (1,102,321)         ‐21.5% (16,739,305)      ‐80.6% State Grants 75,878                    610,000                 84,403                    8,525                    11.2%(525,597)             ‐86.2% Local Grants 216,859                 296,885                 275,532                 58,673                 27.1%(21,353)                ‐7.2% YTD Total 9,387,904$         25,869,099$       8,843,799$         (544,105)$          ‐5.8% (17,025,300)$   ‐65.8% Intergovernmental by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through December Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 4 of 41   State Shared Revenue – The breakdown of State Shared Revenue is as follows:        Criminal Justice – One Time – During the 2021 legislative session, legislators approved a one‐time allocation to assist cities  to help offset costs from law enforcement and criminal justice related legislation enacted between January 2020 and June  2021.  This will not be an ongoing revenue source.      Federal/State/Local Grants – Federal/State/Local grant revenues vary significantly from year‐to‐year based on what grants  have been awarded and the timing of grant expenditures and related reimbursement requests. Grant revenues are budgeted  at 100% of the award at the time the grant agreement is finalized, and any amounts not received are carried forward each  year until either 1) the grant funds are fully received or 2) the grant agreement expires.   Federal grants budget increase in  2021 accounts for the ARPA grant of $18.1 million awarded to the City in June.  These grant funds can be spent through 2024.    CHARGES FOR SERVICES         Public Safety Services – The increase in public safety services and the amount over the prior year is primarily due to increased  receipts for private security services ($320K) and electronic home detention ($100K). The amount over the YTD budget is  primarily due to higher than anticipated receipts for private security services.     Development Services – The increase in development services over the prior year is primarily due to an increase in planning  fees ($730K) and inspection services ($170K). The amount over budget is primarily due to higher than anticipated planning  fees ($790K) offset by lower than anticipated other development services revenues.     Social Services – The increase is due to a new program in partnership with King County to provide after school programs for  kids in at risk areas.      Interfund Services – Interfund services revenues decrease from the prior year and the amount under budget is due to  reimbursement of staffing costs from CIP projects.     2020 2021 2021 Tax by Type YTD Actual YTD Budget YTD Actual$%$% Judicial Contribution 32,304$         17,212$         53,812$         21,508$        66.6% 36,600$        212.6% Crim Just ‐ High Crime 140,366          ‐                            ‐                           (140,366)       ‐100.0%‐                          N/A Crim Just ‐ Pop 32,817            24,725            34,718            1,901              5.8% 9,993              40.4% Crim Just ‐ Spec Prog 117,451         113,286         123,625         6,174              5.3% 10,339           9.1% Crim Just ‐ One Time ‐                           420,599         420,599         420,599        N/A ‐                          0.0% State DUI 15,226            18,043            17,282            2,056              13.5%(761)                  ‐4.2% Marijuana Distribution 203,826         199,000         229,998         26,172           12.8% 30,998           15.6% Liquor Profits 840,871         830,000         833,694         (7,177)             ‐0.8%3,694              0.4% Liquor Excise Tax 660,297         597,350         738,940         78,643           11.9% 141,590        23.7% Fuel Tax 1,929,644     1,982,650     2,011,152     81,508           4.2% 28,502           1.4% YTD Total 3,972,802$  4,202,865$  4,463,820$  491,018$     12.4%260,955$     6.2% 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % Passport Fees 8,883                        ‐                                   105                           (8,778)                   ‐98.8%105                        100.0% Court Services 110,288                 60,500                    106,751                 (3,536)                   ‐3.2%46,252                 76.4% General Government Services 646                           500                            461                           (186)                        ‐28.7% (39)                           ‐7.9% Public Safety Services 710,544                 865,110                 1,175,389            464,845              65.4% 310,279              35.9% Development Services 1,540,352            1,690,271             2,405,883            865,531              56.2% 715,612              42.3% Transportation Services 71,276                     ‐                                   56,659                    (14,617)                ‐20.5%56,659                 100.0% Social Services 10,892                    311,424                 221,596                 210,704              1934.5%(89,828)                ‐28.8% Recreation/Farmer's Market/Events 295,863                 311,610                 337,297                 41,434                 14.0% 25,687                 8.2% Interfund Services 4,766,185            4,958,872             4,684,111            (82,074)                ‐1.7% (274,761)             ‐5.5% YTD Total 7,514,930$         8,198,287$          8,988,252$         1,473,323$      19.6% 789,966$           9.6% Year to Date through December Charges for Services by Type Revenue 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 5 of 41   FINES AND PENALTIES      Civil Penalties – Decrease from prior year and the amount under budget relates to a decrease in traffic and parking  enforcement citations.      Photo Enforcement Program – Photo enforcement revenues have increased from prior year and are over budget due to  increased traffic volumes and school zone cameras were turned back on as in‐person learning resumed in early March 2021.     MISCELLANEOUS REVENUES      Interest and Other Investment Earnings – Interest earnings have decreased from the prior year primarily due to: 1) a  reduction in interfund interest ($375K); and 2) an overall reduction in interest rates. The amount of interest under budget is  almost entirely due to the interfund interest payment not being recorded in 2021. The revenue budget will be adjusted to  with the mid‐biennial budget adjustment.    Rents, Leases, and Concessions – Rents, leases, and concessions revenues increased over the prior year primarily due to rent  waivers provided in 2020 in response to COVID‐19. Rents, leases, and concessions revenues are over budget primarily due to  higher than anticipated concessions from one lessee and due to various rent budgets, that were not adjusted for scheduled  increases in rental rates.     Latecomer Agreement – Latecomer agreements for Sunset Lane infrastructure improvements were finalized in 2020.  Payments are due from property owners if/when various conditions are met. Conditions were met for one property owner  in 2020 and payment was received. It is not possible to estimate if/when the various conditions will be met for the other  property owners and, therefore, receipt of payments under the agreements will not be budgeted.     OTHER FINANCING SOURCES    Transfers from Other Funds – The decrease in transfers from other funds is primarily due to a decrease in the following: 1)  $11.8M decrease in transfers in resulting from a change in accounting recording transfers between the General Fund and its  2020 2021 2021 Actual Budget Actual $ % $ % Civil Penalties 349,999$          280,293$           237,545$          (112,454)$        ‐32.1% (42,748)$          ‐15.3% Photo Enforcement Program 2,754,379         3,687,000          4,222,877         1,468,499       53.3% 535,877          14.5% Criminal Traffic Misdemeanor Fines 55,162               39,447               44,791               (10,372)            ‐18.8%5,344               13.5% Criminal Non‐Traffic Fines 6,534                 8,500                  5,650                 (884)                  ‐13.5% (2,850)               ‐33.5% Criminal Costs 57,980               36,960               35,527               (22,453)            ‐38.7% (1,433)               ‐3.9% Non‐Court Fines, Forfeitures and Penalties 86,225               50,582               75,930               (10,295)            ‐11.9%25,348             50.1% YTD Total 3,310,279$       4,102,782$       4,622,320$       1,312,041$     39.6% 519,538$        12.7% Fines and Penalties by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through December 2020 2021 2021 Actual Budget Actual $ % $ % Interest and Other Investment Earnings 1,079,302$         220,000$              381,777$              (697,525)$          ‐64.6%161,777$           73.5% Rents, Leases, and Concessions 849,604                 795,324                 981,108                 131,504              15.5% 185,784              23.4% Contributions/Donations from Private Sources 47,019                    249,051                 275,820                 228,801              486.6% 26,769                 10.7% Latecomer Agreement 326,880                  ‐                                    ‐                                   (326,880)            0.0%‐                                N/A Other 162,320                 55,122                    114,034                 (48,286)                ‐29.7%58,912                 106.9% YTD Total 2,465,125$         1,319,497$          1,752,739$         (712,386)$          ‐28.9%433,242$           32.8% Miscellaneous by Type Year to Date through December Revenue 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % Transfers from Other Funds 17,631,829$      63,764                    82,198$                 (17,549,631)      ‐99.5%18,434                 28.9% Prior Period Adjustment ‐                                   (764,282)                (775,836)               (775,836)            100.0%(11,554)               1.5% Insurance Recoveries 4,566                        ‐                                   37,804                    33,238                 727.9% 37,804                 100.0% Sale of Capital Assets 20,100                     ‐                                   41,718                    21,618                 107.6% 41,718                 100.0% YTD Total 17,656,495$      (700,518)$             (614,116)$            (18,270,611)$   ‐103.5%86,402$              ‐12.3% Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through December Other Financing Sources by Type Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 6 of 41   consolidated management funds. Transfers between the consolidated funds were previously recorded as transfer in revenue  and transfer out expenditures. Transfers between the consolidated funds are now net together to avoid overstating revenues  and expenditures. 2) $2.6M one‐time transfer from the Housing Opportunity Fund. $2.5M of these funds are reserved for the  Economic Development Reserve. 3) $580K one‐time transfer in from Density Transfer fees that were held in the Municipal  Facilities CIP capital project fund. These funds were used to support low‐income housing project grants awarded by CED. 4)  $400K one time transfer in support of the RHA Sunset Neighborhood Center.  5) $1.8M one‐time transfer in from the  Municipal Facilities CIP fund to offset COVID‐19 revenue losses.    Prior Period Adjustments – When preparing the 2020 annual financial statement, the following adjustments were made to  correct errors related to prior years.  1) correction to accumulated depreciation of assets placed in service prior to 2010.  a  detailed review of the capital asset records revealed certain assets placed into service prior to 2010 had not been properly  depreciated. 2) correction of transactions related to the Wetland Mitigation Bank credits that were expensed instead of  capitalizing the costs as an intangible asset.        GENERAL FUND EXPENDITURES  The following tables summarize expenditures by category for each department within the General Fund. Detailed  explanations have been provided for variances from prior year or YTD budget in excess of $100K.         CITY ATTORNEY        Personnel – there was an increase in personnel costs over the prior year due to filling positions that were held vacant in 2020  in response to COVID‐19.  The amount of personnel costs under budget is due to the budget assuming all positions would be  filled for the entire year.      COMMUNITY AND ECONOMIC DEVELOPMENT        Personnel – The decrease in personnel costs from the prior year is primarily due to the city‐wide reorganization which shifted  two of the Economic Development employees to the new Equity, Housing, and Human Services department. The amount of  personnel costs under the YTD budget is due to open positions primarily in Planning and Development Services.     City Attorney Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 1,999,736         2,350,586       2,177,586       (177,850)$      ‐8.9%173,000$      7.4% Supplies 1,155                 3,550               473                  682                 59.0% 3,077             86.7% Contracted Services 24,021               49,450             24,239            (218)                 ‐0.9%25,211          51.0% Capital Outlay ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Debt Service ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Internal Services 182,418            207,761          238,074          (55,656)           ‐30.5% (30,313)          ‐14.6% Transfers Out ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Total Expenditures 2,207,330$       2,611,347$     2,440,372$    (233,042)$      ‐10.6%170,975$      6.5% 2021 vs. 20202021 2021 vs. Budget Community and Economic Development Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 7,402,921         8,079,481       7,040,347       362,574$       4.9% 1,039,134$  12.9% Supplies 13,741               29,580             11,017            2,724              19.8% 18,563          62.8% Contracted Services 1,588,445         3,059,512       686,989          901,456         56.8% 2,372,523     77.5% Capital Outlay 367,314            1,653,748       1,083,890       (716,576)         ‐195.1%569,858        34.5% Debt Service ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Internal Services 1,066,977         1,244,140       1,155,529       (88,552)           ‐8.3%88,611          7.1% Transfers Out 189,040            3,130               3,130               185,910         98.3%‐                      0.0% Total Expenditures 10,628,438$    14,069,591$  9,980,902$    647,536$       6.1% 4,088,689$  29.1% 2021 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 7 of 41   Contracted Services – The decrease in contracted services from the prior year is primarily due to the city‐wide reorganization  which shifted housing related expenditures and grants which were primarily paid to the Renton Housing Authority. This  activity and related budget were moved to the new Equity, Housing, and Human Services department.  The amount under  budget represents the allocation of the ARPA grants funds for small business support that was not spent by year end.    Capital Outlay – The increase amount of capital outlay over the prior year is due to the Downtown Streetscape project,  managed by Economic Development, that is being funded by a CDBG grant.    Transfers – The decrease in transfers out is due to a change in recording transfers between the General Fund and its  consolidated management funds. Transfers between the consolidated funds were previously recorded as transfer in revenue  and transfer out expenditures. Transfers between the consolidated funds are now net together to avoid overstating revenues  and expenditures.      COUNCIL          Internal Services – The increase in internal services costs over the prior year and budget is primarily due to a change in the  allocation method us to allocate facilities costs to the various departments.      COURT SERVICES            Personnel – there was an increase in personnel costs over the prior year due to filling positions that were held vacant in 2020  in response to COVID‐19.  The amount of personnel costs under budget is due to the budget assuming all positions would be  filled for the entire year.    Internal Services – The internal service costs are below budget due to a change in the allocation method in the current year  and a year‐end true up resulting in lower costs for Information Technology costs and Communications costs.           Council Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 346,653            421,784          421,332          (74,679)$         ‐21.5%452$              0.1% Supplies 930                    2,000               812                  118                 12.7% 1,188             59.4% Contracted Services 19,978               63,316             2,819               17,159           85.9% 60,497          95.5% Capital Outlay ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Debt Service ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Internal Services 58,183               67,385             167,967          (109,784)         ‐188.7% (100,582)        ‐149.3% Transfers Out ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Total Expenditures 425,744$          554,485$        592,930$        (167,186)$      ‐39.3% (38,445)$        ‐6.9% 2021 vs. Budget2021 2021 vs. 2020 Court Services Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 1,958,279         2,389,087       2,058,979       (100,700)$      ‐5.1%330,108$      13.8% Supplies 3,282                 7,700               5,723               (2,441)             ‐74.4%1,977             25.7% Contracted Services 93,410               149,716          111,906          (18,496)           ‐19.8%37,810          25.3% Capital Outlay ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Debt Service ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Internal Services 385,902            556,427          445,476          (59,574)           ‐15.4%110,951        19.9% Transfers Out 3,563                  ‐                    ‐                   3,563              100.0%‐                      0.0% Total Expenditures 2,444,436$       3,102,930$     2,622,084$    (177,648)$      ‐7.3%480,846$      15.5% 2021 vs. 20202021 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 8 of 41   EQUITY, HOUSING, AND HUMAN SERVICES      The Equity, Housing, and Human Services department is a newly formed department, the result of a city‐wide reorganization  approved by the City Council on July 19, 2021, effective August 1, 2021. 2021 budget and actuals have been shifted to the  newly created department for the entirety of 2021 where the costs are coming from an existing department. Newly created  positions in EHHS Admin and Community Outreach divisions are included in the mid‐biennial budget adjustment and are not  reflected here.  2020 actuals have also been reclassified to the new department, where possible, for comparative purposes.  It was not possible to reclassify 2020 Housing expenditures as they are intermixed with other transactions within the CED –  Economic Development division.     Personnel – The increase in personnel costs over the prior year is primarily due to two Housing division positions whose 2020  actuals are included in the 2020 actuals for CED – Economic Development. The amount of personnel costs under the YTD  budget is due to open positions.    Contracted Services – The increase in contracted services over the prior year is primarily due to increased Human Services  spending ($137K) and Housing division spending ($912K). The Housing division 2020 actuals are included in the 2020 actuals  for CED – Economic Development.  The amount of contracted services under the YTD budget is primarily due to the increase  in budget for Human Services at the end of 2021 ($1.5 M) along with CDBG – CV grants that were not spent by the end of the  year.  The unspent budget will be carried forward to 2022.     EXECUTIVE SERVICES         Personnel – The amount of personnel costs under the YTD budget is due to open positions.    Supplies – The decrease in supplies costs from the prior year is due to COVID‐19 expenditures incurred by Emergency  Management in 2020 that are not repeated in 2021.    Contracted Services – The decrease in contracted services costs from the prior year is due to COVID‐19 small business grants  and human services funding incurred by Emergency Management in 2020 that are not repeated in 2021.   The amount of contracted services under the YTD budget is a combination of budget savings in Admin ($104K), Emergency  Management ($111K), Organizational Development ($53K), and Neighborhood Program ($66K).     Internal Services – The increase in internal services costs over the prior year is primarily due to significantly increased  Communications charges to the Executive Admin division ($143K), combined with increased internal service fund charges  across the other internal service funds.  Equity, Housing, and Human Services Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 611,620            1,131,622       1,006,521       (394,901)$      ‐64.6%125,101$      11.1% Supplies 8,254                 19,416             12,071            (3,817)             ‐46.2%7,345             37.8% Contracted Services 805,388            3,982,880       1,866,640       (1,061,252)     ‐131.8%2,116,240     53.1% Capital Outlay ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Debt Service ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Internal Services 82,467               121,913          254,395          (171,928)         ‐208.5% (132,482)        ‐108.7% Transfers Out ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Total Expenditures 1,507,729$       5,255,831$     3,139,627$    (1,631,898)$   ‐108.2%2,116,204$  40.3% 2021 vs. Budget2021 2021 vs. 2020 Executive Services Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 4,394,657            2,493,196         2,097,025         2,297,632$     52.3% 396,171$        15.9% Supplies 375,592                16,869                 6,706                   368,886            98.2% 10,163              60.2% Contracted Services 4,069,802            1,951,973         1,586,125         2,483,677        61.0% 365,848           18.7% Capital Outlay ‐                             ‐                           ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                           ‐                              0.0%‐                             0.0% Internal Services 589,387                1,020,478         685,857             (96,470)               ‐16.4%334,621           32.8% Transfers Out 694                            ‐                           ‐                         694                       100.0%‐                             0.0% Total Expenditures 9,430,132$         5,482,516$      4,375,713$      5,054,419$     53.6% 1,106,803$   20.2% 2021 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 9 of 41     FINANCE     Personnel ‐ there was an increase in personnel costs over the prior year due to filling positions that were held vacant in 2020  in response to COVID‐19.  The amount of personnel costs under budget is due to the budget assuming all positions would be  filled for the entire year.    Contracted Services – The amount of contracted services over the prior year is primarily due to outside legal fees associated  with a utility tax audit.     HUMAN RESOURCES      Contracted Services – The amount of contracted services underbudget relates primarily to a decrease in outside legal fees  and training.      PARKS AND RECREATION      Personnel – The amount of personnel costs under the YTD budget is due to open positions. Recreation facilities were closed  to the public for much of the year and, therefore, supplemental staff were not utilized during this time.     Supplies – The amount of supplies costs under the YTD budget is primarily due to cost savings in the Recreation division that  are directly related to closed Recreation facilities, as noted above.    Contracted Services – The amount of contracted services under the YTD budget is primarily due to cost savings in Parks  Planning and Recreation divisions.    Finance Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 1,980,502            2,587,515         2,101,229         (120,727)$         ‐6.1%486,286$        18.8% Supplies 2,850                      11,500                 1,398                   1,452                  50.9% 10,102              87.8% Contracted Services 1,144,493            1,302,698         1,305,407         (160,914)            ‐14.1% (2,709)                ‐0.2% Capital Outlay ‐                             ‐                           ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 375,360                468,761              436,341             (60,981)               ‐16.2%32,420              6.9% Transfers Out ‐                             ‐                           ‐                          ‐                              0.0%‐                             0.0% Total Expenditures 3,503,205$         4,370,474$      3,844,375$      (341,170)$         ‐9.7%526,099$        12.0% 2021 vs. Budget2021 2021 vs. 2020 Human Resources Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 1,090,582         1,141,385       1,098,558       (7,976)$           ‐0.7%42,827$        3.8% Supplies 2,951                 21,828             7,680               (4,729)             ‐160.3%14,148          64.8% Contracted Services 68,759               229,838          97,642            (28,883)           ‐42.0%132,196        57.5% Capital Outlay ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Debt Service ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Internal Services 231,585            285,956          194,342          37,243           16.1% 91,614          32.0% Transfers Out ‐                      ‐                    ‐                    ‐                       0.0%‐                      0.0% Total Expenditures 1,393,877$       1,679,007$     1,398,222$    (4,345)$           ‐0.3%280,785$      16.7% 2021 vs. Budget2021 vs. 20202021 Parks and Recreation Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 6,728,349            9,426,233         6,703,570         24,779$            0.4% 2,722,663$   28.9% Supplies 286,962                480,566              344,024             (57,062)               ‐19.9%136,542           28.4% Contracted Services 2,053,757            2,327,909         2,069,111         (15,354)               ‐0.7%258,798           11.1% Capital Outlay 4,541                      170,041              173,552             (169,011)            ‐3721.9% (3,511)                ‐2.1% Debt Service ‐                             ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 2,885,715            4,141,756         2,943,188         (57,473)               ‐2.0%1,198,568      28.9% Transfers Out 3,848                      38,741                 48,326                (44,478)               ‐1155.9% (9,585)                ‐24.7% Total Expenditures 11,963,172$      16,585,246$   12,281,771$   (318,599)$         ‐2.7%4,303,475$   25.9% 2021 vs. Budget2021 2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 10 of 41   Internal Services – The amount of internal services costs under the YTD budget is primarily due to information services having  additional fund balance beyond budgeted reserves which was refunded to departments.     POLICE      Personnel – The increase in personnel costs from the prior year is primarily the result of salaries in 2020 being allocated to  the CARES grant. The amount of personnel costs under the YTD budget is primarily due to vacant positions, offset by an  increase in overtime ($330K).     Supplies – The increase in supplies costs from the prior year is primarily due to an increase in the quarter master system  ($51K). The amount of supplies costs under the YTD budget is due to the small tools and minor equipment budget which was  increased ($480k) for body cameras.      Contracted Services – The increase in contracted services from the prior year is primarily due to the increase in SCORE charges  of ($346k) as well as operating rentals due to a timing difference in monthly billing from prior year.  The amount of contracted  services under the YTD budget is primarily due to less than anticipated SCORE charges ($401k).     Internal Services – The increase in internal services is primarily due to increased Fleet equipment replacement charges. These  charges were temporarily suspended in 2020 due to COVID‐19 but resumed January 1, 2021.  The amount of internal services  costs under the YTD budget is primarily due to information services having additional fund balance beyond budgeted reserves  which was refunded to departments.    Transfers Out – The decrease in transfers out from the prior year is due to one‐time transfers that occurred in 2020. These  transfers were as follows: 1) $711,102 to the new Police Seizure special revenue fund established in 2020, and 2) $126,011  to the new Police CSAM Seizure special revenue fund established in 2020.    PUBLIC WORKS        Personnel – The amount of personnel costs under the YTD budget is primarily due to open positions in Street Maintenance  ($297K) and Transportation Systems ($328K).    Contracted Services – The amount of contracted services under the YTD budget is primarily due to lower than anticipated  Transportation Systems division electricity costs ($63K) and various professional services ($71K).    Police Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 22,829,120         26,800,144      25,187,299      (2,358,179)$    ‐10.3%1,612,845$   6.0% Supplies 282,573                995,494              443,925             (161,352)            ‐57.1%551,569           55.4% Contracted Services 9,176,395            10,263,110      9,831,465         (655,070)            ‐7.1%431,645           4.2% Capital Outlay ‐                            41,154                 20,405                (20,405)              100.0% 20,749              50.4% Debt Service ‐                             ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 4,640,249            6,162,809         5,584,959         (944,710)            ‐20.4%577,850           9.4% Transfers Out 843,262                 ‐                          9,083                   834,179            98.9%(9,083)               100.0% Total Expenditures 37,771,599$      44,262,711$   41,077,136$   (3,305,537)$    ‐8.8%3,185,575$   7.2% 2021 2021 vs. Budget2021 vs. 2020 Public Works Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 7,594,550         8,352,106       7,604,469       (9,919)$           ‐0.1%747,637$      9.0% Supplies 589,857            557,217          580,900          8,957              1.5%(23,683)          ‐4.3% Contracted Services 2,455,613         2,974,788       2,466,063       (10,450)           ‐0.4%508,725        17.1% Capital Outlay 41,006               5,200               40,213            793                 1.9%(35,013)          ‐673.3% Debt Service 175,000             ‐                    ‐                   175,000         100.0%‐                      0.0% Internal Services 1,879,147         2,835,481       2,490,382       (611,235)         ‐32.5%345,099        12.2% Transfers Out 767,770             ‐                    ‐                   767,770         100.0%‐                      0.0% Total Expenditures 13,502,943$    14,724,792$  13,182,027$  320,916$       2.4% 1,542,765$  10.5% 2021 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 11 of 41   Internal Services – The increase in internal services is primarily due to increased Fleet equipment replacement charges. These  charges were temporarily suspended in 2020 due to COVID‐19 but resumed January 1, 2021.  The amount of internal services  costs under the YTD budget is primarily due to information services having additional fund balance beyond budgeted reserves  which was refunded to departments.    Transfers Out – The decrease in transfers out from the prior year are primarily due to 2020 transfers to the Capital  Improvement capital project fund ($760K) that are not repeated in 2021.    NON‐DEPARTMENTAL AND OTHER        Personnel ‐ The amount of personnel expenditures over the prior year is due to timing of employee separations. The amount  of personnel expenditures under the YTD budget is due to lower than anticipated employee separation payments.     Contracted Services – The amount of contracted services under budget is due to contingency reserves that are set aside for  unanticipated costs related to the SCORE.     Debt Services – The amount under budget for debt service relates to an interfund loan with the Maplewood Golf Course to  purchase golf carts.  The carts are on back order due to supply chain constraints, this budget will be carried forward into 2022.     Transfers Out – The decrease in transfers out is primarily due to the following:  1) a change in accounting method for the  property tax transfers between consolidated funds.  Transfers between the consolidated funds were previously recorded as  transfer in revenue and transfer out expenditures.  Transfers between the consolidated fund are now net together to avoid  overstating revenues and expenditures. 2) one‐time transfer of REET revenues to the new REET1 capital project fund ($1.1M)  and REET2 capital project fund ($1.1M).                                          Non‐Departmental and Other Summary of Uses 2020 Year to Date through December YTD Actual YTD Budget YTD Actual $%$% Personnel 2,142,068            3,407,200         2,929,460         (787,392)$         ‐36.8%477,740$        14.0% Supplies ‐                             ‐                           ‐                          ‐                              0.0%‐                             0.0% Contracted Services 163,145                813,462              255,727             (92,582)               ‐56.7%557,735           68.6% Capital Outlay ‐                            100,000              39,780                (39,780)              100.0% 60,220              60.2% Debt Service ‐                            225,309               ‐                          ‐                              0.0% 225,309           100.0% Internal Services 18,828                   14,055                 14,055                4,773                  25.4%‐                             0.0% Transfers Out 21,083,978         10,368,655      9,179,802         11,904,176     56.5% 1,188,853      11.5% Total Expenditures 23,408,019$      14,928,681$   12,418,824$   10,989,195$  46.9% 2,509,857$   16.8% 2021 vs. 20202021 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 12 of 41       DEBT SERVICE FUNDS  Debt service funds are used to account for the accumulation of resources for the payment of principal and interest related to  the City’s general obligation bond issues. YTD budgets are not prepared for debt service funds.     GENERAL GOVERNMENTAL MISCELLANEOUS DEBT FUND  The General Governmental Miscellaneous Debt Fund is the only debt service fund maintained by the City.        Grants/intergovernmental – The decrease in intergovernmental revenue is due to a reduction in payments from Fire District  40 that support the debt service payments on Fire Station 13. The payment received in 2nd quarter 2021 was the final  payment scheduled to be received from Fire District 40 related to the debt service on the loan.                          2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR  YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 444,715$          114,631$           114,740$    (329,975)$ 109$            100.10% Investment Earnings 48,907               ‐                           28,416         (20,491)     28,416         N/A TOTAL REVENUES 493,622            114,631             143,156       (350,466)   28,525         124.88% EXPENDITURES: Principal 5,405,922         5,625,158          5,625,158   (219,236)    ‐                    100.00% Interest 1,783,752         1,530,011          1,500,315   283,437    29,696         98.06% TOTAL EXPENDITURES 7,189,674         7,155,169          7,125,473   64,201       29,696         99.58% Transfers In 7,707,225         7,378,667          7,189,814   (517,411)   (188,853)     97.44% NET TRANSFERS 7,707,225         7,378,667          7,189,814   (517,411)   (188,853)     97.44% CHANGE IN FUND BALANCE 1,011,172         338,129             207,497       (803,675)   (130,632)     61.37% BEGINNING FUND BALANCE, Jan 1 3,999,457         5,010,629          5,010,629   1,011,172 ‐                    100.00% ENDING FUND BALANCE, Dec 31 5,010,629$      5,348,758$        5,218,126$ 207,497$  (130,632)$   97.56% Debt Service Reserve 2,717,575         2,717,575          2,717,575    AVAILABLE FUND BALANCE 2,293,054$      2,631,183$        2,500,551$  VARIANCE FAVORABLE  (UNFAVORABLE) GENERAL GOVERNMENTAL MISCELLANEOUS DEBT Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 13 of 41   SPECIAL REVENUE FUNDS  Special revenue funds are used to account for revenues that are to be used for a specific purpose as required by law or  legislative action. YTD budgets are not prepared for special revenue funds.     Hotel/Motel Fund  The Hotel/Motel Fund accounts for monies collected through an increase of 1% in hotel/motel taxes for the purpose of  increasing tourism in the City or Renton, as authorized under RCW 67.28.180. The Lodging Tax Advisory Committee solicits  applications for awards and brings their recommendations to Council for approval at least once per year. Awards for events  are paid to applicants at the conclusion of the event once certain reporting requirements have been met.          Cable Communications Fund  The Cable Communications Fund accounts for funding for promotion and development of cable communications as  established by City ordinance. The main use of the fund is to support the broadcasting of City Council meetings on Channel  21.      2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 233,847$              200,000$                283,113$              49,266$                83,113$                141.56% Contributions 30,000                   25,000                     25,000                   (5,000)                     ‐                              100.00% Investment Earnings 8,888                      ‐                                4,306                     (4,582)                    4,306                     N/A TOTAL REVENUES 272,735                225,000                   312,419                39,684                   87,419                   138.85% EXPENDITURES: Contracted Services 285,520                556,197                   437,601                (152,081)               118,596                78.68% TOTAL EXPENDITURES 285,520                556,197                   437,601                (152,081)               118,596                78.68% Transfers Out 37,500                   40,000                     40,000                   2,500                      ‐                              100.00% NET TRANSFERS (37,500)                 (40,000)                    (40,000)                 (2,500)                     ‐                              N/A CHANGE IN FUND BALANCE (50,285)                 (371,197)                 (165,182)               (114,897)               206,015                44.50% BEGINNING FUND BALANCE, Jan 1 943,889                893,604                   893,604                (50,285)                  ‐                              94.67% ENDING FUND BALANCE, Dec 31 893,604$              522,407$                728,422$              (165,182)$             206,015$              81.52% VARIANCE FAVORABLE (UNFAVORABLE) HOTEL/MOTEL 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 80,144$                57,674$                    72,259$                (7,885)$                 14,585$                125.29% Investment Earnings 5,762                      ‐                                  3,331                     (2,431)                    3,331                     N/A TOTAL REVENUES 85,906                   57,674                      75,590                   (10,316)                 17,916                   131.06% EXPENDITURES: Supplies ‐                              6,302                         6,184                     6,184                     118                        98.13% Contracted Services 51,956                   51,372                      55,476                   3,520                     (4,104)                    107.99% Capital Outlay ‐                              40,000                      394                        394                        39,606                   0.99% TOTAL EXPENDITURES 51,956                   97,674                      62,054                   10,098                   35,620                   63.53% Transfers In 40,000                   40,000                      40,000                    ‐                               ‐                              100.00% NET TRANSFERS 40,000                   40,000                      40,000                    ‐                               ‐                              100.00% CHANGE IN FUND BALANCE 73,950                    ‐                                  53,536                   (20,414)                 53,536                   N/A BEGINNING FUND BALANCE, Jan 1 603,760                677,710                    677,710                73,950                    ‐                              100.00% ENDING FUND BALANCE, Dec 31 677,710$              677,710$                  731,246$              53,536$                53,536$                107.90% CABLE COMMUNICATIONS VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 14 of 41   Housing & Supportive Services  In accordance with HB 1590, the City Council passed ORD 5983 authorizing an additional 0.1% sales and use tax, effective  January 1, 2021. The additional sales tax was not authorized at the time the 2021‐2022 budget was prepared. Anticipated  revenues are expected to be included in the mid‐biennial budget adjustment. The additional sales and use tax is restricted  for housing and related services, in accordance with RCW 82.14.530.     Contracted Services ‐ $1M of the amount under budget relates to support the Renton Housing Authority’s Sunset Gardens  project and $30K is for the police navigator program.  Both amounts will be carried forward as it is expected to be funded in  2022.        Springbrook Wetlands Fund  The Springbrook Wetlands Fund was established in 2007 for the purpose of providing accounting for the Springbrook Creek  Wetland and Habitat Mitigation Bank project. The fund will receive revenue by selling Wetlands credits which will be used to  fund the ongoing maintenance of the wetland in perpetuity.           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes ‐$                       2,640,000$          3,166,434$      3,166,434$      526,434$          119.94% TOTAL REVENUES ‐                         2,640,000            3,171,729         3,171,729         531,729            120.14% EXPENDITURES: Contracted Services ‐                         1,030,000             ‐                          ‐                         1,030,000         0.00% TOTAL EXPENDITURES ‐                         1,030,000             ‐                          ‐                         1,030,000         0.00% NET TRANSFERS ‐                          ‐                             ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE ‐                         1,610,000            3,171,729         3,171,729         1,561,729         197.00% BEGINNING FUND BALANCE, Jan 1 ‐                          ‐                             ‐                          ‐                          ‐                         N/A ENDING FUND BALANCE, Dec 31 ‐$                       1,610,000$          3,171,729$      3,171,729$      1,561,729$      197.00% HOUSING & SUPPORTIVE SERVICES VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 3,168$                    ‐$                               1,541$                   (1,627)$                 1,541$                   N/A Sale of credits ‐                               ‐                                 867                        867                        867                        N/A TOTAL REVENUES 3,168                      ‐                                 2,408                     (760)                       2,408                     N/A EXPENDITURES: Personnel ‐                               ‐                                 2,825                     2,825                     2,825                     N/A Contracted Services ‐                               ‐                                 4,884                     4,884                     4,884                     N/A TOTAL EXPENDITURES ‐                               ‐                                 7,709                     7,709                     (7,709)                    N/A NET TRANSFERS ‐                               ‐                                  ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 3,168                      ‐                                 (5,301)                    (8,469)                    (5,301)                    N/A BEGINNING FUND BALANCE, Jan 1 345,658                348,826                   348,826                3,168                      ‐                              100.00% Prior Period Adjustment ‐                              (109,200)                  (109,200)               (109,200)                ‐                              N/A BEGINNING FUND BALANCE, Jan 1 ‐ restated 345,658                239,626                   239,626                (106,032)                ‐                              100.00% ENDING FUND BALANCE, Dec 31 348,826$              239,626$                 234,325$              (114,501)$             (5,301)$                 97.79% SPRINGBROOK WETLANDS VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 15 of 41   Police Seizure Fund  The Police Seizure Fund was established in the 2nd quarter of 2020 for the purpose of providing transparency in the accounting  for assets seized by Police in accordance with RCW 9A.83.030 and 69.50.505, previously accounted for within the General  Fund. These seizure funds are restricted to use exclusively for the expansion and improvement of controlled substances  related law enforcement activity.  The total fund balance remaining at the end of the year is budgeted in full the following  year.        Police CSAM Seizure Fund  The Police CSAM Seizure Fund was established in the 2nd quarter of 2020 for the purpose of providing transparency in the  accounting for assets seized by Police in accordance with RCW 9A.88.150, previously accounted for within the General Fund.  These seizure funds are restricted to the exclusive use of enforcing the provisions of chapter 9A.88 RCW, Indecent Exposure‐ Prostitution, or chapter 9.68A RCW, Sexual Exploitation of Children.      2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Contributions 323,507$           ‐$                         69,054$            (254,453)$        69,054$            N/A Investment Earnings 5,628                 ‐                            3,679                (1,949)               3,679                N/A TOTAL REVENUES 329,135             ‐                            72,733              (256,402)           72,733              N/A EXPENDITURES: Supplies 88,510              872,449              29,574              (58,936)             842,875            3.39% Contracted Services 58,392               ‐                            97,181              38,790              (97,181)             N/A Capital Outlay 20,886               ‐                            186,903            166,017            (186,903)           N/A TOTAL EXPENDITURES 167,788            872,449              313,658            145,870            558,791            35.95% Transfers In 711,102             ‐                             ‐                         (711,102)            ‐                         N/A NET TRANSFERS 711,102             ‐                             ‐                         (711,102)            ‐                         N/A CHANGE IN FUND BALANCE 872,449            (872,449)             (240,925)           (1,113,374)       631,524            N/A BEGINNING FUND BALANCE, Jan 1 ‐                         872,449              872,449            872,449             ‐                         100.00% ENDING FUND BALANCE, Dec 31 872,449$           ‐$                         631,524$          (240,925)$        631,524$          N/A POLICE SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Fines and penalties 20,194$             ‐$                         45,387$            25,193$            45,387$            N/A Investment Earnings 4,328                 ‐                            803                    (3,525)               803                    N/A TOTAL REVENUES 26,127               ‐                            46,190              20,063              46,190              N/A EXPENDITURES: Contracted Services 1,501                150,637              2,000                499                    (148,637)           1.33% TOTAL EXPENDITURES 1,501                150,637              22,000              20,499              128,637            14.60% Transfers In 126,011             ‐                             ‐                         (126,011)            ‐                         N/A NET TRANSFERS 126,011             ‐                             ‐                         (126,011)            ‐                         N/A CHANGE IN FUND BALANCE 150,637            (150,637)             24,190              (126,447)           174,827            N/A BEGINNING FUND BALANCE, Jan 1 ‐                         150,637              150,637            150,637             ‐                         100.00% ENDING FUND BALANCE, Dec 31 150,637$           ‐$                         174,827$          24,190$            174,827$          N/A POLICE CSAM SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 16 of 41   CAPITAL PROJECT FUNDS  Capital project funds are used to account for the acquisition and construction of major capital facilities and equipment. YTD  budgets are not prepared for capital project funds. Project budgets are adopted when funding is secured, and balances are  carried forward each year until they are either 1) fully spent or 2) reallocated to another project through the budget  adjustment process.    Community Services Impact Mitigation Fund   This fund accounts for park impact fees collected from developers as authorized under RCW 82.02.050‐.110. These fees are  used to help offset the cost of system improvements necessary to service the new development. Impact fees are held in this  fund and subsequently transferred to the Municipal Facilities CIP Fund when qualifying capital projects are budgeted.        Fire Impact Mitigation Fund  This fund accounts for fire impact fees collected from developers as authorized under RCW 82.02.050‐.110. These fees are  used to offset the cost of system improvements necessary to serve the new development. Impact fees are held in this fund  and subsequently transferred to the debt service fund to support the debt service on fire station 13. Once the debt on the  fire station is repaid, the remaining collections will be disbursed to the Renton Regional Fire Authority for use on qualifying  capital projects.        2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 495,647$              86,500$                  222,541$              (273,106)$             136,041$              257.27% Investment Earnings 18,232                    ‐                                12,056                   (6,176)                    12,056                   N/A TOTAL REVENUES 513,879                86,500                     234,597                (279,282)               148,097                271.21% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                 ‐                               ‐                               ‐                              N/A Transfers In ‐                              1,484,964               1,484,964             1,484,964              ‐                              100.00% Transfers Out 601,795                2,796,229                ‐                              (601,795)               2,796,229             0.00% NET TRANSFERS (601,795)               (1,311,265)              1,484,964             2,086,759             2,796,229              ‐113.25% CHANGE IN FUND BALANCE (87,916)                 (1,224,765)              1,719,561             1,807,477             2,944,326              ‐140.40% BEGINNING FUND BALANCE, Jan 1 1,886,999             1,713,833               1,713,833             (173,166)                ‐                              100.00% Prior Period Adjustment (85,250)                  ‐                                 ‐                              85,250                    ‐                              N/A BEGINNING FUND BALANCE, Jan 1 (restated) 1,801,749             1,713,833               1,713,833             (87,916)                  ‐                              100.00% ENDING FUND BALANCE, Dec 31 1,713,833$           489,068$                3,433,394$           1,719,561$           2,944,326$           702.03% COMMUNITY SERVICES IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 164,824$          99,000$              195,224$          30,400$            96,224$            197.20% Investment Earnings 19,876               ‐                           11,044              (8,832)               11,044              N/A TOTAL REVENUES 184,700            99,000                206,268            21,568              107,268            208.35% EXPENDITURES: TOTAL EXPENDITURES ‐                          ‐                            ‐                          ‐                          ‐                         N/A Transfers Out 113,806            436,987              436,987            323,180            0                        100.00% NET TRANSFERS (113,806)           (436,987)            (436,987)           (323,180)            ‐                         100.00% CHANGE IN FUND BALANCE 70,894              (337,987)            (230,719)           (301,613)           107,268            68.26% BEGINNING FUND BALANCE, Jan 1 2,120,558         2,191,452          2,191,452         70,894               ‐                         100.00% ENDING FUND BALANCE, Dec 31 2,191,452$      1,853,465$        1,960,733$      (230,719)$        107,268$          105.79% FIRE IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 17 of 41   Transportation Impact Mitigation Fund  This fund accounts for transportation impact fees collected from developers as authorized under RCW 82.02.050‐.110. These  fees are used to offset the cost of system improvements necessary to serve the new development. Impact fees are held in  this fund and subsequently transferred to the Capital Improvement Fund when qualifying projects are budgeted.        REET 1 Fund  This fund was established in the 2nd quarter of 2020 to account for the first quarter percent of real estate excise tax (REET)  levied in accordance with RCW 82.46.010. The tax may be used for eligible capital projects, as defined in RCW.82.46.010(6),  that are included in the capital facilities element of the City’s comprehensive plan. REET 1 tax revenues are held in this fund  and subsequently transferred to the appropriate capital project fund when qualifying projects are budgeted.         2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 1,989,329$      200,000$            2,085,910$      96,581$            1,885,910$      1042.96% Investment Earnings 35,268               ‐                            21,008              (14,260)             21,008              N/A TOTAL REVENUES 2,024,597         200,000               2,106,918         82,321              1,906,918         1053.46% EXPENDITURES: TOTAL EXPENDITURES ‐                          ‐                             ‐                          ‐                          ‐                         N/A Transfers Out 1,811,987         102,837               102,837            (1,709,149)       (0)                       100.00% NET TRANSFERS (1,811,987)       (102,837)             (102,837)           1,709,149          ‐                         100.00% CHANGE IN FUND BALANCE 212,610            97,163                 2,004,081         1,791,471         1,906,918         N/A BEGINNING FUND BALANCE, Jan 1 2,942,344         3,154,954           3,154,954         212,610             ‐                         100.00% ENDING FUND BALANCE, Dec 31 3,154,954$      3,252,117$         5,159,035$      2,004,081$      1,906,918$      158.64% TRANSPORTATION IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 3,303,490$      3,250,000$         5,043,939$      1,740,449$      1,793,939$      155.20% Investment Earnings 15,924               ‐                            21,914              5,990                21,914              N/A TOTAL REVENUES 3,319,414         3,250,000           5,065,853         1,746,439         1,815,853         155.87% EXPENDITURES: TOTAL EXPENDITURES ‐                          ‐                             ‐                          ‐                          ‐                         N/A Transfers In 1,143,855          ‐                             ‐                         (1,143,855)        ‐                         N/A Transfers Out 2,421,000         2,865,000           2,600,004         179,004            264,996            90.75% NET TRANSFERS (1,277,145)       (2,865,000)          (2,600,004)       (1,322,860)       264,996            90.75% CHANGE IN FUND BALANCE 2,042,269         385,000               2,465,849         423,580            2,080,849         640.48% BEGINNING FUND BALANCE, Jan 1 ‐                         2,042,269           2,042,269         2,042,269          ‐                         100.00% ENDING FUND BALANCE, Dec 31 2,042,269$      2,427,269$         4,508,118$      2,465,849$      2,080,849$      185.73% REET 1 VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 18 of 41   REET 2 Fund  This fund was established in the 2nd quarter of 2020 to account for the second quarter percent of real estate excise tax (REET)  levied in accordance with RCW 82.46.035. The tax may be used for eligible capital projects, as defined in RCW.82.46.035(5),  that are included in the capital facilities element of the City’s comprehensive plan. REET 2 tax revenues are held in this fund  and subsequently transferred to the appropriate capital project fund when qualifying projects are budgeted.        Municipal Facilities CIP Fund  This fund accounts for general governmental facility construction, improvement, and renovation; property acquisitions for  parks and City space needs; parks development and equipment; and major maintenance of existing general governmental  assets. Transportation capital improvements are accounted for in a separate fund.      2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 3,303,490$      3,250,000$         5,043,938$      1,740,448$      1,793,938$      155.20% Investment Earnings 15,924               ‐                            35,873              19,949              35,873              N/A TOTAL REVENUES 3,319,414         3,250,000           5,079,811         1,760,397         1,829,811         156.30% EXPENDITURES: TOTAL EXPENDITURES ‐                          ‐                             ‐                          ‐                          ‐                         N/A Transfers In 1,143,855         3,177,680           3,177,680         2,033,825          ‐                         100.00% Transfers Out 1,051,404         7,066,705           2,896,211         1,844,807         4,170,494         40.98% NET TRANSFERS 92,452              (3,889,025)          281,469            189,017            4,170,494          ‐7.24% CHANGE IN FUND BALANCE 3,411,866         (639,025)             5,361,280         1,949,414         6,000,305          ‐838.98% BEGINNING FUND BALANCE, Jan 1 ‐                         3,411,866           3,411,866         3,411,866          ‐                         100.00% ENDING FUND BALANCE, Dec 31 3,411,866$      2,772,841$         8,773,146$      5,361,280$      6,000,305$      316.40% REET 2 VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 3,073,037$      1,802,206$       1,334,416$      (1,738,621)$     (467,790)$        74.04% Charges for services 4,140                 ‐                          157,795            153,655            157,795            N/A Sale of general fixed assets 560,000             ‐                          80,000              (480,000)           80,000              N/A Contributions ‐                         86,000               11,000              11,000              (75,000)             12.79% Investment Earnings 226,519            86,185               83,297              (143,222)           (2,888)               96.65% TOTAL REVENUES 3,863,696         1,974,391         1,666,508         (2,197,188)       (307,883)           84.41% EXPENDITURES: Personnel 482,930            520,453             500,735            17,805              19,718              96.21% Contracted Services 564,939            267,991             157,401            (407,538)           110,590            58.73% Capital Outlay 7,107,728         27,783,905       3,955,052         (3,152,676)       23,828,853      14.24% TOTAL EXPENDITURES 9,026,715         28,572,349       4,613,188         (4,413,527)       23,959,161      16.15% Transfers In 1,789,795         11,614,909       4,633,641         2,843,846         (6,981,268)       39.89% Transfers Out 2,723,680         5,153,642         5,160,838         2,437,158         (7,196)               100.14% NET TRANSFERS (933,885)           6,461,267         (527,198)           406,687            (6,974,072)        ‐8.16% CHANGE IN FUND BALANCE (6,096,904)       (20,136,691)      (3,473,878)       2,623,026         16,662,813      17.25% BEGINNING FUND BALANCE, Jan 1 26,395,567      20,298,663       20,298,663      (6,096,904)        ‐                         100.00% ENDING FUND BALANCE, Dec 31 20,298,663$    161,972$          16,824,785$    (3,473,878)$     16,662,813$    10387.47% MUNICIPAL FACILITIES CIP VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 19 of 41   A listing of project budgets and balances at December 31 is provided below. The budget for personnel costs is included in the  listing for ease of comparison to total expenditures shown in the table above, but personnel costs are not considered projects  and, therefore, any remaining budget would not be carried forward at the end of the year.     Municipal Facilities CIP Fund (continued)               PROJECT BUDGET ACTUAL BALANCE CAPITAL PROJECT COORDINATORS 520,454$ 500,735$ 19,719$ PROPERTY AQUSITIONS 3,500,000 - 3,500,000 SUNSET NEIGHBORHOOD PARK ART 86,856 10,200 76,656 CITY HALL ELEVATORS/GENERATOR REPLACEME 540,583 463,349 77,234 ESCO FACILITIES ENERGY AUDIT 82,500 - 82,500 CITY WIDE SECURITY SYSTEM UPGRADES - - - COMM SVCS MAINT SHOPS REHAB 299,946 - 299,946 SIGN SHOP IMPROVEMENTS - - - CITY HALL MAJOR HVAC AND FIRE COMP REPL 2,754,288 2,263,750 490,538 RCC AUDIO AND VIDEO SYSTEMS 56,000 - 56,000 CITY HALL - REMODEL 60,000 8,469 51,532 CITY HALL - 7TH FLOOR REMODEL 210,000 2,431 207,569 PARK AVE MAINTENANCE FACILITIES STUDY 50,000 35,750 14,250 PUBLIC WORKS SHOPS - GENERATOR REPL 144,000 - 144,000 BOATHOUSE 7,352 7,352 - HENRY MOSES AQUATIC CENTER 88,644 45,351 43,293 SPORT COURT IMPROVEMENTS 192,434 127,434 65,000 PARKING LOT AND DRIVEWAY REPAIRS 90,000 - 90,000 URBAN FORESTRY PROGRAM 103,348 26,644 76,704 PARKS MM - PLAYGRDS, KIOSKS & INT SIGNS 554,255 121 554,134 PARKS MM - STRUCTURAL REVIEWS & REPAIRS 11,915 11,915 1 SUNSET EIS PARK 84,010 59,337 24,673 COULON PARK STRUCTURAL IMPROVEMENTS 150 150 - COULON PARK TURF REPLACEMENT 10,000 - 10,000 COULON SWIM BEACH 100,000 - 100,000 LIBERTY PARK IMPROVEMENTS 525,852 500,967 24,885 TRANSPORTATION LANDSCAPE - - - PHILIP ARNOLD PARK IMPROVEMENTS 5,951,133 169,190 5,781,943 KIWANIS PARK 6,687,100 46,827 6,640,273 COULON - WATERWALK 3,588,569 221,028 3,367,541 COULON - TRESTLE BRIDGE 1,997,854 98,784 1,899,070 FAWCETT ROFR - PROF SERVICES 107 107 - COULON - ROSEWALL REPAIRS & MAINTENANCE 10,000 - 10,000 MAY CREEK TRAIL SOUTH 250,000 - 250,000 PARKS AVE N ACQUISITION 10,000 9,800 200 COLLOODI MAY CREEK PROPERTY 5,000 3,500 1,500 TOTAL PROJECT BALANCES 28,572,349$ 4,613,188$ 23,959,161$ MUNICIPAL FACILITIES CIP PROJECT BUDGETS AT December 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 20 of 41   Capital Improvement Fund  This fund accounts for the City’s Transportation capital projects.         A listing of project budgets and balances at December 31 is provided on the following page.      2020 2021 2021 YTD YTD ACTUAL ANNUAL YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 2,439,149$      28,258,159$    7,710,276$      5,271,127$      (20,547,883)$   27.29% Charges for services 250,000             ‐                          ‐                         (250,000)            ‐                         N/A Fines and penalties 23,482               ‐                         32,706              9,224                32,706              N/A Investment Earnings 163,069             ‐                         68,537              (94,532)             68,537              N/A TOTAL REVENUES 2,875,700         28,258,159      7,811,519         4,935,819         (20,446,640)     27.64% EXPENDITURES: Personnel 104,094            56,000              125,923            21,829              (69,923)             224.86% Supplies 155,655            40,000              153,323            (2,332)               (113,323)           383.31% Contracted Services 154,324            188,248            511,778            357,454            (323,530)           271.86% Capital Outlay 8,522,976         45,778,219      14,897,642      6,374,666         30,880,577      32.54% TOTAL EXPENDITURES 8,937,049         46,062,467      15,702,666      6,765,617         30,387,801      34.09% Transfers In 3,905,909         2,102,837         1,858,387         (2,047,522)       (244,450)           88.38% NET TRANSFERS 3,905,909         2,102,837         1,858,387         (2,047,522)       (244,450)           88.38% CHANGE IN FUND BALANCE (2,155,440)       (15,701,471)     (6,032,760)       (3,877,320)       9,668,711         N/A BEGINNING FUND BALANCE, Jan 1 18,947,853      16,792,413      16,792,413      (2,155,440)        ‐                         100.00% Prior Period Adjustment ‐                         109,200            109,200            109,200             ‐                         100.00% BEGINNING FUND BALANCE, Jan 1 ‐ resta 18,947,853      16,901,613      16,901,613      (2,046,240)        ‐                         100.00% ENDING FUND BALANCE, Dec 31 16,792,413$    1,200,142$      10,868,853$    (5,923,560)$     9,668,711$      905.63% CAPITAL IMPROVEMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 21 of 41   Capital Improvement Fund (continued)          PROJECT BUDGET ACTUAL BALANCE WALKWAY PGM 267,096$ -$ 267,096$ NE 31ST ST CULVERT 12,228 12,090 138$ ARTERIAL CIRCULATION PGM 79,564 56,084 23,480$ BRIDGE INSPECTION & REPAIR 245,909 50,413 195,496$ ROADWAY SAFETY & GUARDRAIL 89,407 - 89,407$ CATCH BASIN REPAIR 250,000 - 250,000$ RENTON CONNECTOR 1,747,812 4,901 1,742,911$ STREET OVERLAY PGM 1,465,902 98,067 1,367,834$ TRAFFIC SAFETY PGM 117,808 38,803 79,005$ PROJ DEV & PRE-DESIGN 186,201 160,805 25,397$ SO 7TH ST 835,000 - 835,000$ ITS PGM 86,128 32,634 53,494$ RENTON AVE EXT PRES 40,920 32,139 8,781$ PARK AVE EXTENSION 7,394,795 3,885,838 3,508,957$ RAINIER AVE S/N PHASE 4 4,568,763 852,560 3,716,203$ INTERSECT SAFETY & MOBILITY 355,610 9,514 346,096$ NE 31ST ST BRIDGE REPLACEMENT 248,046 27,213 220,833$ N 27TH PL CULVERT SCOUR REPAIR 66,622 37,165 29,457$ DUVALL AVE 7TH TO SUNSET 6,499,523 221,005 6,278,518$ BARRIER FREE 113,883 77,813 36,070$ SIDEWALK REHAB 100,000 - 100,000$ LAKE WASHINGTON LOOP TRAIL 2,569,362 1,563,775 1,005,586$ HIGHLANDS TO LANDING 422,490 148,340 274,150$ SUNSET BLVD CORRIDOR 4,421,053 60,913 4,360,141$ PRES OF TOD 173,496 148,367 25,129$ WILLIAMS AVE S & WELLS AVE S CON 6,495,073 6,129,832 365,242$ ARTERIAL REHAB - SW 43RD 1,169,960 - 1,169,960$ BRONSON BRIDGE 463,766 72,442 391,323$ HOUSER WAY N BRIDGE 531,247 8,727 522,520$ WILLIAMS BRIDGE 649,992 8,366 641,626$ S 2ND STREET CONVERSION 1,545,494 1,985 1,543,509$ HOUSER WAY INT & PED IMP 1,297,340 739,421 557,919$ RENTON SCHOOL CROSSINGS 763,384 724,712 38,672$ SAFE ROUTES TO TRANSIT 763,592 471,100 292,492$ SOUND TRANSIT NE 44TH STREET 25,000 27,641 (2,641)$ TOTAL PROJECT BALANCES 46,062,467$ 15,702,666$ 30,359,801$ CAPITAL IMPROVEMENT PROJECT BUDGETS AT DECEMBER 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 22 of 41   New Library Development Fund  This fund was used to account for the construction of the new Highlands Library and the renovation of the Cedar River Library.  The fund is no longer needed as the library construction projects were complete in 2016. The fund has been closed and the  remaining fund balance was transferred to the General Fund.        Family First Center Fund  This fund is used to account for the construction of the new Family First Center. Funds accumulated for the construction of  the Family First Center are maintained in the fund balance until such time that Council authorizes their use through the  approval of contracts and additional project budget is established through the budget adjustment process.        Capital Outlay – The decrease in capital outlay from the prior year is due to timing of project costs within the overall project.     Note ‐ Additional funds designated for the Family First Center are being held in a fund with the Renton Community Foundation  (Foundation). Those funds are not reflected in the City’s records as they are assets of the Foundation, not the City. The City  must apply to the Foundation to receive the funds. Funds transferred from the Foundation will be recorded as contribution  revenue when received by the City.    2020 2021 2021 YTD YTD ACTUAL ANNUAL YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 271$                  ‐$                        ‐$                       (271)$                 ‐$                       N/A TOTAL REVENUES 271                     ‐                          ‐                         (271)                   ‐                         N/A TOTAL EXPENDITURES ‐                          ‐                          ‐                          ‐                          ‐                         N/A Transfers Out ‐                         16,679              16,679              16,679               ‐                         100.00% NET TRANSFERS ‐                         (16,679)             (16,679)             (16,679)              ‐                         N/A CHANGE IN FUND BALANCE 271                    (16,679)             (16,679)             (16,950)              ‐                         N/A BEGINNING FUND BALANCE, Jan 1 16,408              16,679              16,679              271                     ‐                         100.00% ENDING FUND BALANCE, Dec 31 16,679$             ‐$                        ‐$                       (16,679)$            ‐$                       N/A NEW LIBRARY DEVELOPMENT VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental ‐$                            1,530,000$            ‐$                             ‐$                            (1,530,000)$         0.00% Investment Earnings 76,555                    ‐                              39,771                   (36,784)                 39,771                   N/A TOTAL REVENUES 81,475                   1,530,000             39,771                   (41,704)                 (1,490,229)            2.60% EXPENDITURES: Contracted Services ‐                              82,382                   82,892                   82,892                   (510)                       100.62% Capital Outlay 276,172                2,367,775             121,844                (154,328)               2,245,931             5.15% TOTAL EXPENDITURES 276,172                2,450,157             204,736                (71,436)                 2,245,421             8.36% Transfers In ‐                              40,000                   47,196                   47,196                   7,196                     117.99% NET TRANSFERS ‐                              40,000                   47,196                   47,196                   7,196                     117.99% CHANGE IN FUND BALANCE (194,697)               (880,157)               (117,769)               76,928                   762,388                N/A BEGINNING FUND BALANCE, Jan 1 8,551,401             8,356,704             8,356,704             (194,697)                ‐                              100.00% ENDING FUND BALANCE, Dec 31 8,356,704$           7,476,547$           8,238,935$           (117,769)$             762,388$              110.20% FAMILY FIRST CENTER VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 23 of 41   ENTERPRISE FUNDS  Enterprise funds are used to account for operations that are financed and operated in a manner similar to private business  enterprises. YTD budgets are not prepared for Enterprise Funds.     Most Enterprise Funds maintain two separate “management funds”, an operating fund and a capital fund. The funds are  consolidated for budget/reporting purposes. Operating budgets lapse at the end of the year. Project budgets are adopted  when funding is secured, and balances are carried forward each year until they are either 1) fully spent or 2) reallocated to  another project through the budget adjustment process. A listing of project balances for each Enterprise Fund is included,  along with a reconciliation to the amounts reported as “Capital Outlay”.     Airport Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Renton Municipal Airport.   The lease revenues were previously classified as charges for services but are  not being reflected in their own line item below.        2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 69,000$        229,240$            ‐$                   (69,000)$      (229,240)$    0.00% Charges for services 2,297,210    2,997,910          1,771,638    (525,572)      (1,226,272)   59.10% Rents, leases, and misc fees 742,646        50,000                1,414,117    671,471        1,364,117    2828.23% Interest and other misc 102,477        4,857                  39,157          (63,320)         34,300          806.20% TOTAL REVENUES 3,211,333    3,282,007          3,224,912    13,579          (57,095)         98.26% EXPENSES: Personnel 885,041        1,322,337          1,067,346    (182,305)      254,991        80.72% Supplies 37,409          39,471                42,860          (5,451)           (3,389)           108.59% Contracted Services 389,436        1,257,790          1,222,491    (833,055)      35,299          97.19% Internal Services 314,510        393,723             344,095        (29,585)         49,628          87.40% TOTAL OPERATING EXPENSES 1,626,396    3,013,321          2,676,792    (1,050,396)   336,529        88.83% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 1,584,937    268,686             548,120        (1,036,817)   279,434        204.00% TOTAL DEBT SERVICE ‐                      ‐                            ‐                     ‐                      ‐                     N/A CAPITAL OUTLAY 284,571        6,574,125          348,644        (64,073)         6,225,481    5.30% TRANSFERS OUT 1,363             ‐                           16,130          (14,767)         (16,130)         N/A NET TRANSFERS (1,363)            ‐                           (16,130)         (14,767)         (16,130)         N/A CHANGE IN FUND BALANCE 1,299,003    (6,305,439)         183,346        (1,115,657)   6,488,785    N/A BEGINNING FUND BALANCE, Jan 1 6,259,402    7,558,405          7,558,405    1,299,003     ‐                     100.00% ENDING FUND BALANCE, Dec 31 7,558,405$  1,252,966$        7,741,751$  183,346$     6,488,785$  617.87% Operating Reserve 190,480        223,124             223,124         AVAILABLE FUND BALANCE 7,367,925$  1,029,842$        7,518,627$   VARIANCE AIRPORT Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 24 of 41   Grants / Intergovernmental – The Airport receives various grants, primarily from the FAA. The revenue from these grants  varies greatly depending on the timing and amount of qualifying expenses.     Charges for Services & Rents. Leases and Misc. fees ‐ A change in reporting for rents and leases that were previously included  in charges for services are now reported on their own line item.  When comparing prior year to current year and to budget  these amounts combined are consistent with budget and prior year figures.    Personnel – The increase in personnel costs from the prior year and the amount under budget is due to open positions.    Contracted Services – The increase in contracted services from the prior year are related to the Airport Management Program  project which is repairing taxiways and ramps. Expenses for this project are declining as the project is nearing completion.  Pavement management    Capital Outlay ‐ A listing of project budgets and balances at December 31 is provided below.                                                         PROJECT BUDGET ACTUAL BALANCE MAINTENANCE DREDGING & SHORELINE MITIGAT 163,000$ 52,360$ 110,640$ AIRPORT OFFICE REHAB 2,718,316$ -$ 2,718,316 MAJOR FACILITY MAINTENANCE 561,135$ 393,641$ 167,494 SURFACE WATER SYSTEM REHABILITATION 94,496$ -$ 94,496 PAVEMENT MANAGEMENT PROGRAM 805,930$ 705,164$ 100,766 SNOW REMOVAL EQUIPMENT 167,000$ -$ 167,000 MASTER PLAN UPDATE 354,472$ 57,460$ 297,012 TAXIWAY ALPHA REHABILITATION 1,317,495$ -$ 1,317,495 RUNWAY SAFETY AREA 774,359$ -$ 774,359 ENVIRONMENTAL IMPACT STUDY 400,000$ -$ 400,000 TOTAL PROJECT BALANCES 7,356,203$ 1,208,625$ 6,147,577$ Non-capital items included in project budgets (782,078) (859,982) 77,904 Operating fund equipment purchase - - - TOTAL CAPITAL OUTLAY 6,574,125$ 348,644$ 6,225,481$ AIRPORT PROJECT BALANCES AT DECEMBER 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 25 of 41   Solid Waste Fund  This fund accounts for revenues and expenses for administration and operating of solid waste, recycling, and yard waste  collection services for the City.       Grants / Intergovernmental – The Solid Waste division routinely receives intergovernmental grants which fund the City’s  various recycling events.   Amount under budget reflects the timing of the receipts of the grant.    Charges for Services – This account will fluctuate based on actual payments received for services.  Due to the utility  moratorium, all utilities revenues have been down during the pandemic.      Personnel – The amount under budget is due to open positions.    Contracted Services‐ Contracted services will fluctuate with the charges for services as this line item includes payment to the  City’s garbage hauler as well as King County dump fees.  The December payment for the monthly King County dump fees  ($450K) was not paid until January 2022, therefore next year 13 months will be reflected in the overall figures.  This payment  was accrued in the proper period for financial statement reporting, however.    Capital Outlay ‐ The Solid Waste Fund does not have a capital fund.            2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 89,664$        382,631$           69,496$        (20,168)$      (313,135)$    18.16% Charges for services 20,593,831  22,636,386        20,819,209  225,378        (1,817,177)   91.97% Interest and other misc 26,266          5,000                  13,637          (12,629)         8,637            272.74% TOTAL REVENUES 20,709,761  23,024,017        20,902,342  192,581        (2,121,675)   90.78% EXPENSES: Personnel 545,060        727,085             518,200        26,860          208,885        71.27% Supplies 5,641            11,900                2,496            3,145            9,404            20.97% Contracted Services 19,200,911  21,855,539        19,499,706  (298,795)      2,355,833    89.22% Internal Services 452,430        307,806             261,166        191,264        46,640          84.85% TOTAL OPERATING EXPENSES 20,204,042  22,902,330        20,281,568  (77,526)         2,620,762    88.56% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 505,719        121,687             620,774        115,055        499,087        510.14% TOTAL DEBT SERVICE ‐                      ‐                            ‐                     ‐                      ‐                     N/A CAPITAL OUTLAY ‐                      ‐                            ‐                      ‐                      ‐                     N/A TRANSFERS OUT 284                ‐                           94                  190               (94)                N/A NET TRANSFERS (284)               ‐                           (94)                190               (94)                N/A CHANGE IN FUND BALANCE 505,435        121,687             620,680        115,245        498,993        510.06% BEGINNING FUND BALANCE, Jan 1 2,266,127    2,771,562          2,771,562    505,435         ‐                     100.00% ENDING FUND BALANCE, Dec 31 2,771,562$  2,893,249$        3,392,242$  620,680$     498,993$     117.25% Operating Reserve 400,000        400,000             400,000         AVAILABLE FUND BALANCE 2,371,562$  2,493,249$        2,992,242$   SOLID WASTE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 26 of 41   Golf Course Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Maplewood Golf Course.      Charges for services – The increase in charges for services over the prior year is due to COVID‐19. As many recreational  activities have been cancelled in the region due to COVID‐19 restrictions, the number of people golfing has increased.    Rents, leases, and Misc. fees –Rents, leases, and misc. fees increased over the prior year primarily due to rent waivers  provided in 2020 in response to COVID‐19. Rents and leases are under budget primarily due to lower than anticipated banquet  concessions due to pandemic restrictions.    Interest and other Misc. – Amount under budget represents funds that are to be transferred and loaned to the golf course  from the general fund to help pay for the new golf carts.  The golf carts have been ordered but not yet received; once the  golf carts are received and paid for, the funds will be transferred.    2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 2,270,554$  2,304,205$        2,776,650$  506,096$     472,445$     120.50% Rents, leases, and misc fees 320,034        527,600             401,232        81,198          (126,368)      76.05% Interest and other misc 4,950            226,679             6,660            1,710            (220,019)      2.94% TOTAL REVENUES 2,595,538    3,058,484          3,184,542    589,004        126,058        104.12% EXPENSES: Personnel 1,434,588    1,673,092          1,543,698    (109,110)      129,394        92.27% Supplies 290,986        321,704             366,441        (75,455)         (44,737)         113.91% Contracted Services 223,569        176,150             151,080        72,489          25,070          85.77% Internal Services 340,704        350,253             364,509        (23,805)         (14,256)         104.07% TOTAL OPERATING EXPENSES 2,289,847    2,521,199          2,425,728    (135,881)      95,471          96.21% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 305,691        537,285             758,814        453,123        221,529        141.23% DEBT SERVICE: Principal ‐                     11,000                 ‐                      ‐                     11,000          0.00% Interest ‐                     554                      ‐                      ‐                     554               0.00% TOTAL DEBT SERVICE ‐                     11,554                 ‐                     ‐                     11,554          0.00% CAPITAL OUTLAY ‐                     270,309             12,662          (12,662)         257,647        4.68% TRANSFERS IN 76,000          68,100                68,100          (7,900)            ‐                     100.00% TRANSFERS OUT 78,695          68,100                68,100          10,595           ‐                     100.00% NET TRANSFERS (2,695)            ‐                            ‐                     2,695             ‐                     N/A CHANGE IN FUND BALANCE 302,996        255,422             746,152        443,156        490,730        292.13% BEGINNING FUND BALANCE, Jan 1 173,750        476,746             476,746        302,996         ‐                     100.00% ENDING FUND BALANCE, Dec 31 476,746$     732,168$           1,222,898$  746,152$     490,730$     167.02% Operating Reserve 585,769        641,500             641,500         AVAILABLE FUND BALANCE (109,023)$    90,668$             581,398$      GOLF COURSE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 27 of 41   Personnel ‐ there was an increase in personnel costs over the prior year due to filling positions that were held vacant in 2020  in response to COVID‐19.  The amount of personnel costs under budget is due to the budget assuming all positions would be  filled for the entire year.    Capital Outlay – A listing of project budgets and balances at December 31 is as follows:                                                                                     PROJECT BUDGET ACTUAL BALANCE MACHINERY & EQUIPMENT 250,309$ 12,662$ 237,647$ INTERFUND LOAN REPAY 11,000$ -$ 11,000$ INTERFUND LOAN REPAY 554$ -$ 554$ GOLF MM COURSE - MAINTENANCE 43,100 40,685 2,415 TOTAL PROJECT BALANCES 304,963$ 53,347$ 251,616$ Non-capital items included in project budgets (54,654) (40,685) (13,969) Operating fund equipment purchase 20,000 - 20,000 TOTAL CAPITAL OUTLAY 270,309$ 12,662$ 257,647$ GOLF PROJECT BALANCES AT DECEMBER 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 28 of 41   Water Utility Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the City’s water utility.      Charges for Services – Utility revenues are recognized when received for budgetary purposes. A moratorium on  disconnections for non‐payment has been in effect since March 2020 and was lifted in September of 2021.  With the  moratorium lifted in September of 2021, many prior balances were paid in full showing an increase from prior year.    Interest and other Misc. – Decrease over prior year is directly related to a decrease in system development charges ($112k)  and interest earned on the fund balance ($113K) due to low interest rates.    Personnel ‐ there was an increase in personnel costs over the prior year due to filling positions that were held vacant in 2020  in response to COVID‐19.  The amount of personnel costs under budget is due to the budget assuming all positions would be  filled for the entire year.    2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 17,248,806$ 17,314,812$      18,756,458$ 1,507,652$  1,441,646$    108.33% Rents, leases, and misc fees 281,084         136,591             202,333         (78,751)         65,742           148.13% Interest and other misc 891,399         521,000             567,000         (324,399)      46,000           108.83% TOTAL REVENUES 18,426,889    17,972,403        19,525,791    1,098,902    1,553,388      108.64% EXPENSES: Personnel 4,292,439      4,753,110          4,565,219      (272,780)      187,891         96.05% Supplies 819,726         885,876             865,824         (46,098)         20,052           97.74% Contracted Services 3,137,993      3,464,394          3,254,836      (116,843)      209,558         93.95% Internal Services 2,068,882      2,539,605          2,220,078      (151,196)      319,527         87.42% TOTAL OPERATING EXPENSES 10,319,040    11,642,985        10,905,957    (586,917)      737,028         93.67% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 8,107,849      6,329,418          8,619,834      511,985        2,290,416      136.19% DEBT SERVICE: Principal 1,540,568      1,563,068          1,563,068      (22,500)          ‐                      100.00% Interest 241,320         216,506             217,352         23,968          (846)                100.39% TOTAL DEBT SERVICE 1,781,888      1,779,574          1,780,420      1,468            (846)                100.05% CAPITAL OUTLAY 3,118,100      35,563,246        3,759,249      (641,149)      31,803,997    10.57% TRANSFERS OUT 614                  ‐                           6,614              (6,000)           (6,614)            N/A NET TRANSFERS (614)                 ‐                           (6,614)            (6,000)           (6,614)            N/A CHANGE IN FUND BALANCE 3,207,247      (31,013,402)       3,073,551      (133,696)      34,086,953    N/A BEGINNING FUND BALANCE, Jan 1 37,569,067    40,776,314        40,776,314    3,207,247     ‐                      100.00% ENDING FUND BALANCE, Dec 31 40,776,314$ 9,762,912$        43,849,865$ 3,073,551$  34,086,953$ 449.15% Restricted for Debt Service 1,394,050      1,394,050          1,394,050       Operating Reserve 3,072,760      1,614,304          1,614,304       AVAILABLE FUND BALANCE 36,309,504$ 6,754,558$        40,841,511$  WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 29 of 41   Contracted Services – The increase over prior year is directly related to the increase in utility taxes due on increased  charges for services.      Internal Services – An increase in internal services from prior year is primarily a result of a change in funding the fleet  replacement reserve in 2020 in response to COVID‐19.  Vehicle purchases and replacements were being postponed for one  year.  Current year costs are below budget as a year‐end true up was done for all internal service funds based on actual  costs.      Capital Outlay ‐ A listing of project budgets and balances at December 31 is provided below.           PROJECT BUDGET ACTUAL BALANCE PIPE OVERSIZING COSTS 100,000$ -$ 100,000$ TELEMETRY IMPROVEMENTS-PHASE 4 227,965 9,689 218,276 WATER SYSTEM PLAN UPDATE 334,254 52,016 282,238 UPDATE EMERGENCY RESPONSE PLAN 221,490 14,822 206,668 STEEL/AC WATERMAIN REPLC PLAN 1,553,482 82,867 1,470,615 RESERVOIR RECOATING 194,600 - 194,600 EMERGENCY RESPONSE PROJ 100,000 - 100,000 DOWNTOWN WATER MAIN REPLACEMENT 3,909,613 2,009,589 1,900,024 WATER PUMP STATIONS REHAB 400,000 91,751 308,249 RESERVOIR PRV METERS 337,235 9,983 327,252 MPLWD WATER TREATMENT IMPROV - CONST 715,241 18,118 697,123 HIGHLANDS WATER MAIN IMPROVEMENT 1,078,738 735,204 343,534 DUVALL AVE NE WATER MAIN REPLACEMENT 457,600 139 457,461 EMERGENCY POWER TO PUMP STATION 290,586 9,098 281,488 WATER SYSTEM SECURITY IMPROVEMENTS 100,000 - 100,000 AQUIFER MONITORING AND MANAGEMENT 30,000 - 30,000 WATER TREATMENT FILTER MEDIA 392,936 1,093 391,843 WSDOT I-405 WATER RELOCATIONS 536,810 2,765 534,045 AUTOMATIC METER READING CONVERSION 196,115 - 196,115 HIGHLANDS 435-RESERVOIRS REPLACEMENT 23,065,776 212,159 22,853,617 RAINIER AVE S ROAD & UTILITIES IMPRVMNT 300,000 - 300,000 KENNYDALE 320-RESERVOIR 790,842 602,171 188,671 BRONSN/HOUSR/WILLIAM BRIDGES WTRMAINREPL 200,000 - 200,000 TOTAL PROJECT BALANCES 35,533,283$ 3,851,465$ 31,681,818$ Non-capital items included in project budgets - (115,919) 115,919 Operating fund equipment purchase 29,963 23,703 6,260 TOTAL CAPITAL OUTLAY 35,563,246$ 3,759,249$ 31,803,997$ WATER UTILITY FUND PROJECT BALANCES AT DECEMBER 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 30 of 41   Wastewater Utility Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the City’s wastewater utility.        Charges for services – Wastewater charges increased from the prior year due to COVID‐19. Utility revenues are recognized  when received for budgetary purposes.  A moratorium on disconnections for non‐payment has been in effect since March  2020 and was lifted in September of 2021.  With the moratorium lifted in September of 2021, many prior balances were paid  in full showing an increase from prior year.    2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 109,025$       62,111$             85,775$         (23,250)$      23,664$         138.10% Charges for services 10,707,414    11,280,375        11,328,259    620,845        47,884           100.42% Fines and penalties 107                  ‐                           11,789           11,682          11,789           N/A Interest and other misc 670,965         444,000             747,027         76,062          303,027         168.25% TOTAL REVENUES 11,487,511    11,786,486        12,172,850    685,339        386,364         103.28% EXPENSES: Personnel 2,363,336      2,651,185          2,295,741      67,595          355,444         86.59% Supplies 68,992           73,842                108,182         (39,190)         (34,340)          146.50% Contracted Services 2,037,955      3,026,771          2,763,501      (725,546)      263,270         91.30% Internal Services 1,459,820      1,933,601          1,541,589      (81,769)         392,012         79.73% TOTAL OPERATING EXPENSES 5,930,103      7,685,399          6,709,013      (778,910)      976,386         87.30% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 5,557,408      4,101,087          5,463,837      (93,571)         1,362,750      133.23% DEBT SERVICE: Principal 601,300         612,850             612,850         (11,550)          ‐                      100.00% Interest 108,698         97,301                97,843           10,855          (542)                100.56% TOTAL DEBT SERVICE 709,998         710,151             710,693         (695)              (542)                100.08% CAPITAL OUTLAY 682,446         20,241,883        7,954,437      (7,271,991)   12,287,446    39.30% TRANSFERS OUT 1,098               ‐                           6,239              (5,141)           (6,239)            N/A NET TRANSFERS (1,098)             ‐                           (6,239)            (5,141)           (6,239)            N/A CHANGE IN FUND BALANCE 4,163,866      (16,850,947)       (3,207,532)     (7,371,398)   13,643,415    N/A BEGINNING FUND BALANCE, Jan 1 19,832,351    23,996,217        23,996,217    4,163,866     ‐                      100.00% ENDING FUND BALANCE, Dec 31 23,996,217$ 7,145,270$        20,788,685$ (3,207,532)$ 13,643,415$ 290.94% Restricted for Debt Service 661,227         661,227             661,227          Operating Reserve 1,489,966      914,224             914,224          AVAILABLE FUND BALANCE 21,845,024$ 5,569,819$        19,213,234$  WASTEWATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 31 of 41   Personnel ‐ there was an increase in personnel costs over the prior year due to filling positions that were held vacant in 2020  in response to COVID‐19.  The amount of personnel costs under budget is due to the budget assuming all positions would be  filled for the entire year.    Contracted Services – The increase over prior year is directly related to the increase in utility taxes due on increased  charges for services.      Internal Services – An increase in internal services from prior year is primarily a result of a change in funding the fleet  replacement reserve in 2020 in response to COVID‐19.  Vehicle purchases and replacements were being postponed for one  year.  Current year costs are below budget as a year‐end true up was done for all internal service funds based on actual  costs.      Capital Outlay ‐ A listing of project budgets and balances at December 31 is provided below.            PROJECT BUDGET ACTUAL BALANCE MISCELANEOUS SEWER PROJECTS 379,419$ 9,753$ 369,666$ 2008 LONG-RANGE WW MANAG PLAN 62,597 37,980 24,617 WASTEWATER OPERATIONS MASTER PLAN 724,622 467 724,155 WSDOT I-405 REPLACEMENT - 159 (159) THUNDER HILL INT REPL/REHAB 3,074,074 39,269 3,034,805 FORCE MAIN REHABILITATION REPLACEMENT 1,883,308 81,511 1,801,797 LIFT STATION REHABILITATION 1,879,795 94,067 1,785,728 DOWNTOWN SEWER REPLACEMENT/REHAB 7,192,313 7,703,192 (510,879) KENNYDALE LAKELINE SEWER UPGRADE 3,344,460 571,156 2,773,304 SANITARY SEWER REHAB/REPLACEMENT 2,478,314 21,225 2,457,089 TOTAL PROJECT BALANCES 21,018,902$ 8,558,780$ 12,460,122$ Non-capital items included in project budgets (787,219) (604,342) (182,877) Operating fund equipment purchase 10,200 - 10,200 TOTAL CAPITAL OUTLAY 20,241,883$ 7,954,437$ 12,287,446$ WASTEWATER UTILITY FUND PROJECT BALANCES AT DECEMBER 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 32 of 41   King County Metro Fund   This fund accounts for revenues and expenses for operation of the City’s wastewater utility, as it relates to charges for and  payment to King County Metro for water treatment services.        Charges for Services – Utility revenues are recognized when received for budgetary purposes. With the moratorium lifted in  September of 2021, many prior balances were paid in full showing an increase from prior year.    Contracted Services – Current year figures include 13 payments to King County Metro as January 2022 was paid in December;  an adjustment was made a year end to reflect properly in the financial statements.     Capital Outlay ‐ The King County Metro Fund does not have a capital fund.     2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 16,729,775$   17,607,838$          17,881,960$   1,152,185$      274,122$         101.56% Interest and other misc 52,558               ‐                                22,889              (29,669)            22,889              N/A TOTAL REVENUES 16,782,333      17,607,838            17,904,849      1,122,516        297,011           101.69% EXPENSES: Contracted Services 18,014,490      17,607,838            18,870,588      (856,098)          (1,262,750)       107.17% TOTAL OPERATING EXPENSES 18,014,490      17,607,838            18,870,588      (856,098)          (1,262,750)       107.17% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (1,232,157)        ‐                                (965,739)          266,418           (965,739)          N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE (1,232,157)        ‐                                (965,739)          266,418           (965,739)          N/A BEGINNING FUND BALANCE, Jan 1 5,961,906        4,729,749               4,729,749        (1,232,157)        ‐                         100.00% ENDING FUND BALANCE, Dec 31 4,729,749$      4,729,749$            3,764,010$      (965,739)$        (965,739)$        79.58% Operating Reserve 380,000           380,000                  380,000            AVAILABLE FUND BALANCE 4,349,749$      4,349,749$            3,384,010$       KING COUNTY METRO VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 33 of 41   Surface Water Utility Fund   This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the City’s surface water utility.        Grants/Intergovernmental – Federal/State/Local grant revenues vary significantly from year‐to‐year based on what grants  have been awarded and the timing of grant expenditures and related reimbursement requests. Grant revenues are budgeted  at 100% of the award at the time the grant agreement is finalized, and any amounts not received are carried forward each  year until either 1) the grant funds are fully received or 2) the grant agreement expires.    Charges for Services – Utility revenues are recognized when received for budgetary purposes. A moratorium on  disconnections for non‐payment has been in effect since March 2020 and was lifted in September of 2021.  With the  moratorium lifted in September of 2021, many prior balances were paid in full showing an increase from prior year.  2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 71,225$         50,708$             28,500$         (42,725)$      (22,208)$      56.20% Grants / intergovernmental 1,048,412      9,607,603          936,498         (111,914)      (8,671,105)   9.75% Charges for services 11,963,516    12,101,509        12,592,595    629,079        491,086        104.06% Interest and other misc 391,497         3,295,174          2,378,868      1,987,371    (916,306)      72.19% TOTAL REVENUES 13,474,650    25,054,994        15,936,461    2,461,811    (9,118,533)   63.61% EXPENSES: Personnel 3,656,655      3,730,881          3,861,860      (205,205)      (130,979)      103.51% Supplies 119,116         177,267             133,904         (14,788)         43,363          75.54% Contracted Services 1,852,982      4,329,262          2,497,750      (644,768)      1,831,512    57.69% Internal Services 1,754,465      2,557,505          2,446,763      (692,298)      110,742        95.67% TOTAL OPERATING EXPENSES 7,383,218      10,794,915        8,940,277      (1,557,059)   1,854,638    82.82% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 6,091,432      14,260,079        6,996,184      904,752        (7,263,895)   49.06% DEBT SERVICE: Principal 488,950         499,900             499,900         (10,950)          ‐                     100.00% Interest 640,663         110,950             111,349         529,314        (399)              100.36% TOTAL DEBT SERVICE 1,129,613      610,850             611,249         518,364        (399)              100.07% CAPITAL OUTLAY 1,728,735      19,589,880        6,373,606      (4,644,871)   13,216,274  32.54% Transfers In ‐                       ‐                           90,000           90,000          90,000          N/A Transfers Out 284                 18,347                28,919           (28,635)         (10,572)         157.62% NET TRANSFERS (284)                (18,347)              61,081           61,365          79,428          N/A CHANGE IN FUND BALANCE 3,232,800      (5,958,998)         72,410           (3,160,390)   6,031,408    N/A BEGINNING FUND BALANCE, Jan 1 18,377,556    21,610,356        21,610,356    3,232,800     ‐                     100.00% Prior Period Adjustment ‐                      775,836             775,836         775,836         ‐                     100.00% BEGINNING FUND BALANCE, Jan 1 ‐ restated 18,377,556    22,386,192        22,386,192    4,008,636     ‐                     100.00% ENDING FUND BALANCE, Dec 31 21,610,356$ 16,427,194$      22,458,602$ 848,246$     6,031,408$  136.72% Restricted for Debt Service 754,868         754,868             754,868          Operating Reserve 1,252,915      1,116,680          1,116,680       AVAILABLE FUND BALANCE 19,602,573$ 14,555,646$      20,587,054$  SURFACE WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 34 of 41     Interest and Other – A capital grant that was previously reported under grants and interlocal is now reported under the  misc.  gen    Prior Period Adjustments – When preparing the 2020 annual financial statement, an adjustment was made to correct errors  related to prior years.  There was a correction of transactions related to Wetland Mitigation bank credits that were expensed  vs capitalizing as an intangible asset in the general fund.  These costs were paid out of the Surface Water Utility Fund and  were reimbursed to this fund for the prior year errors.      Capital Outlay ‐ A listing of project budgets and balances at December 31 is provided below.            PROJECT BUDGET ACTUAL BALANCE COMP S&SW MGMT PLAN P&D 328,474$ 42,023$ 286,451$ SM DRAINAGE PROBLEMS 578,564 45,317 533,247 PANTHER CR WL MOSQUITO ABATEMENT 95,776 73,495 22,281 MADSEN CREEK SEDIMENT BASIN 276,795 163,183 113,612 SMALL DRAINAGE PROJ-MAPLEWOOD SEDIMENT - - - WETLAND MITIGATION BANK - - - ACOE 205 PROJECT 58,737 10,281 48,456 CEDAR RIVER GRAVEL REMOVAL 2,657,001 151,835 2,505,167 RENTON STORM WATER MANUAL 68,147 2,456 65,691 GREEN RIVER ECOSYSTEM STUDY 48,177 562 47,615 MISCELLANEOUS/EMERGENCY/STORM PROJECTS 100,000 - 100,000 SURFACE WATER UTILITY GIS 121,755 118,033 3,722 HARDIE AVE S UNDERPASS STORM SYSTEM IMPR 2,391 2,098 293 MONROE AVE/N 2ND ST 826,497 455,651 370,846 STORMWATER FACILITY FENCING PROJECT 262,201 20,378 241,822 CEDAR RIVER 205 LEVEE RECERTIFICATION 4,532,900 296,567 4,236,333 SE 172ND ST/125TH AVE SE 140,399 146,834 (6,435) RAINIER AVE/OAKSDALE AVE PUMP STATION UP 147,121 45,067 102,053 NE 16TH/JEFFERSON AVE NE 2,623,430 1,681,058 942,372 DOWNTOWN STORM SYSTEM IMPROVEMENT PRO 5,705,778 3,424,756 2,281,021 HEATHER DOWNS DETENTION POND 486,921 215,475 271,446 MADSEN CRK IMPROV PHASE 1-KCFCD 843,598 86,926 756,672 RAINIER AVE/BENSON RD S - CULVERT REPL - - - CMP STORM SYSTEM REPLACEMENT PROJECT 559,038 232,497 326,541 CEDAR RIVER FLOOD RISK REDUCTION 491,545 74,683 416,861 STORMWATER FACILITY RETROFIT STUDY 271,810 211,548 60,263 BURNETT AVE S/WILLIAMS AVE S 495,797 201,577 294,220 WSDOT LA ROW RUNOFF IMPACT MITIGATION 145,471 62,688 82,783 SW 23RD ST DRAINAGE AND FISH PASSAGE IMP 350,000 - 350,000 TOTAL PROJECT BALANCES 22,218,321$ 7,764,988$ 14,453,333$ Non-capital items included in project budgets (2,657,001) (1,391,382) (1,265,619) Operating fund equipment purchase 28,560 - 28,560 TOTAL CAPITAL OUTLAY 19,589,880$ 6,373,606$ 13,216,274$ SURFACE WATER UTILITY PROJECT BALANCES AT DECEMBER 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 35 of 41   INTERNAL SERVICE FUNDS  Internal service funds are used to account for the goods and services furnished by one City department to other City  departments on a cost reimbursement basis. YTD budgets are not prepared for Internal Service Funds.    Equipment Rental Fund  This fund accounts for revenues and expenses for administration, purchase, and maintenance of the City’s vehicle and  equipment Fleet services. Departments pay in monthly amounts for maintenance and operations. Replacement reserves are  paid monthly over the estimated useful lives of each individual vehicle or piece of equipment. These reverses are accumulated  in fund balance so that they are available to fund the replacement of the vehicle/equipment when the time comes.   Interdepartmental Services – Increased internal service fund charges over prior year are a result of 9 months’ replacement  reserve payments being waived in response to COVID‐19 for 2020. All vehicle/equipment purchases, and replacements are  being postponed one year.    Interest and other Misc. – Includes the sale of decommissioned vehicles ($166K) in the current year.    Supplies – Increase over prior year and amount below budget is mainly from decreased fuel costs.      Contracted Services – Increase over budget includes higher than expected costs for repairs and maintenance ($133K).    2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 73,872$         ‐$                        81,203$         7,331$          81,203$        N/A Interdepartmental services 3,635,985    6,451,395          6,574,687      2,938,702    123,292        101.91% Interest and other misc 90,311          12,000                214,760         124,449        202,760        1789.67% TOTAL REVENUES 3,800,168    6,463,395          6,870,650      3,070,482    407,255        106.30% EXPENSES: Personnel 1,052,975    1,206,146          1,053,073      (98)                153,073        87.31% Supplies 1,001,828    1,496,153          1,350,838      (349,010)      145,315        90.29% Contracted Services 285,598        133,166             289,223         (3,625)           (156,057)      217.19% Internal Services 32,697          30,338                30,338           2,359             ‐                     100.00% TOTAL OPERATING EXPENSES 2,373,098    2,865,803          2,723,472      (350,374)      142,331        95.03% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 1,427,070    3,597,592          4,147,178      2,720,108    549,586        115.28% TOTAL DEBT SERVICE ‐                      ‐                            ‐                      ‐                      ‐                     N/A CAPITAL OUTLAY 1,902,622    2,423,743          398,268         1,504,354    2,025,475    16.43% TRANSFERS IN ‐                      ‐                            ‐                       ‐                      ‐                     N/A TRANSFERS OUT ‐                      ‐                            ‐                       ‐                      ‐                     N/A NET TRANSFERS ‐                      ‐                            ‐                       ‐                      ‐                     N/A CHANGE IN FUND BALANCE (475,552)      1,173,849          3,748,910      4,224,462    2,575,061    319.37% BEGINNING FUND BALANCE, Jan 1 6,851,811    6,376,259          6,376,259      (475,552)       ‐                     100.00% ENDING FUND BALANCE, Dec 31 6,376,259$  7,550,108$        10,125,169$ 3,748,910$  2,575,061$  134.11% EQUIPMENT RENTAL VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 36 of 41   Insurance Fund  This fund accounts for the administration and operation of the City’s self‐insurance programs for property losses, liability,  workers’ compensation, and unemployment compensation. Expenses are paid by the Insurance Fund and rates are charged  to departments based on their claims history over the preceding five years and coverage requirements.      Interdepartmental services – Amount under budget relates to the amount of workers compensation transfers ($217K) and  unemployment transfers ($117K) from other funds.  This will fluctuate based on the number of budgeted FTE vs actual.  Due  to so many open positions, the amount of transfers to the insurance fund was less than budget.     Interest and other misc. ‐ Interest revenues have decreased from the prior year due to lower interest rates. Interest revenues  have exceeded the annual budget as these revenues are budgeted conservatively in anticipation of market volatility.     Personnel ‐ The amount of personnel costs over prior year are primarily due to lower than expected Workers’ Compensation  claims in 2020.  The claims in 2021 are more consistent with prior years.  The Workers Compensation and Unemployment are  budgeted conservatively as they can fluctuate year to year.    Contracted Services ‐ The increase in contracted services expenses over the prior year is primarily due to increased Liability  claims ($580K) and increased external insurance premiums ($150K).    Transfers in – this amount is to fund the reserves per the city’s fiscal policy.   2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 3,084,056$    3,511,775$        3,177,720$    93,664$        (334,055)$    90.49% Interest and other misc 400,398         22,000                337,030         (63,368)         315,030        1531.95% TOTAL REVENUES 3,484,454      3,533,775          3,514,750      30,296          (19,025)         99.46% EXPENSES: Personnel 856,776         1,411,787          1,095,735      (238,959)      316,052        77.61% Supplies 401                 6,956                  536                 (135)              6,420            7.71% Contracted Services 1,862,576      2,770,910          2,731,282      (868,706)      39,628          98.57% TOTAL OPERATING EXPENSES 2,719,753      4,189,653          3,827,553      (1,107,800)   362,100        91.36% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 764,700         (655,878)            (312,803)        (1,077,503)   343,075        N/A TOTAL DEBT SERVICE ‐                       ‐                            ‐                      ‐                      ‐                     N/A CAPITAL OUTLAY ‐                       ‐                            ‐                       ‐                      ‐                     N/A Transfers In ‐                      2,000,000          1,000,000      1,000,000    (1,000,000)   50.00% Transfers Out ‐                      52,868                52,868           (52,868)          ‐                     100.00% NET TRANSFERS ‐                      1,947,132          947,132         947,132        (1,000,000)   48.64% CHANGE IN FUND BALANCE 764,700         1,291,254          634,329         (130,371)      (656,925)      49.13% BEGINNING FUND BALANCE, Jan 1 19,095,508    19,860,208        19,860,208    764,700         ‐                     100.00% ENDING FUND BALANCE, Dec 31 19,860,208$ 21,151,462$      20,494,537$ 634,329$     (656,925)$    96.89% Operating Reserves 16,479,631    17,708,251        17,708,251     AVAILABLE FUND BALANCE 3,380,577$    3,443,211$        2,786,286$     INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 37 of 41   Information Technology Fund  This fund accounts for the administration, purchase, and operation of the City’s information technology systems, including  computer hardware and software, network servers and infrastructure, phone systems, and cell phones. Expenses are paid by  the Information Technology Fund and rates are charged to departments based on use.         Interdepartmental services – A true up was done at the end of the year to compare actual costs vs amount collected from  other funds.  This is the first time this true up has been done, thus creating a large refund back to operating funds.  This true  up will be done annually going forward.    Personnel ‐ The amount of personnel costs under prior year and budget are primarily due to open positions.     Supplies ‐ The amount under budget largely relates to the fact that there is a large back order of supplies due to supply chain  constraints.  The supplies have been ordered but not paid for.  A large amount of these funds under budget will be carried  forward to next year.    Contracted Services – The contracted services budget has not been trued up to right size the changes now that IT is no longer  supporting the RRFA.             2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 253,589$     150,000$           185,611$     (67,978)$      35,611$        123.74% Interdepartmental services 5,373,361    6,435,901          4,714,050    (659,311)      (1,721,851)   73.25% Interest and other misc 43,856          7,000                  44,957          1,101            37,957          642.24% TOTAL REVENUES 5,670,806    6,592,901          4,944,618    (726,188)      (1,648,283)   75.00% EXPENSES: Personnel 2,871,866    3,287,954          2,819,902    51,964          468,052        85.76% Supplies 525,907        1,257,555          537,837        (11,930)         719,718        42.77% Contracted Services 2,420,304    2,706,178          2,273,316    146,988        432,862        84.00% Internal Services 1,804             ‐                            ‐                     1,804             ‐                     N/A TOTAL OPERATING EXPENSES 5,819,881    7,251,687          5,631,055    188,826        1,620,632    77.65% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS (149,074)      (658,786)            (686,437)      (537,363)      (27,651)         N/A TOTAL DEBT SERVICE ‐                      ‐                            ‐                     ‐                      ‐                     N/A CAPITAL OUTLAY 436,562        838,000             237,601        198,961        600,399        28.35% TRANSFERS IN 35,515          613,084             643,551        608,036        30,467          104.97% NET TRANSFERS 35,515          613,084             637,551        602,036        24,467          103.99% CHANGE IN FUND BALANCE (550,121)      (883,702)            (286,487)      263,634        597,215        N/A BEGINNING FUND BALANCE, Jan 1 4,490,062    3,939,941          3,939,941    (550,121)       ‐                     100.00% ENDING FUND BALANCE, Dec 31 3,939,941$  3,056,239$        3,653,454$  (286,487)$    597,215$     119.54% INFORMATION TECHNOLOGY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 38 of 41   Facilities Fund  This fund accounts for the administration, maintenance, and operation of City‐owned facilities. Expenses are paid by the  Facilities Fund and rates are charged to departments based on square footage.         Interdepartmental services –The amount of interdepartmental services under budget is due to the revenue budget not being  reduced to reflect the reduction in charges to the departments.  The increase over prior year is due to COVID‐19 as planned  preventative maintenance was delayed to reduce the burden on departments paying into the Facilities Fund.    Personnel ‐ The amount of personnel costs under prior year and budget are primarily due to open positions.      Contracted Services ‐ The decrease in contracted services costs from budget relates largely to decreased  utility charges resulting from the Governor’s stay‐at‐home order.     2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 21,835$         ‐$                         ‐$                   (21,835)$       ‐$                   N/A Interdepartmental services 4,149,775    5,992,730          5,073,000    923,225        (919,730)      84.65% Rents, leases, and misc fees 1                     ‐                            ‐                     (1)                    ‐                     N/A Interest and other misc 10,426          4,000                  5,465            (4,961)           1,465            136.63% TOTAL REVENUES 4,182,037    5,996,730          5,078,465    896,428        (918,265)      84.69% EXPENSES: Personnel 2,864,198    3,861,996          2,991,378    (127,180)      870,618        77.46% Supplies 431,986        661,164             586,829        (154,843)      74,335          88.76% Contracted Services 1,412,250    1,870,336          1,404,849    7,401            465,487        75.11% Internal Services 68,309          129,486             129,486        (61,177)          ‐                     100.00% TOTAL OPERATING EXPENSES 4,776,743    6,522,982          5,112,542    (335,799)      1,410,440    78.38% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS (594,706)      (526,252)            (34,077)         560,629        492,175        N/A TOTAL DEBT SERVICE ‐                      ‐                            ‐                     ‐                      ‐                     N/A CAPITAL OUTLAY 129,999         ‐                           46,092          83,907          (46,092)         N/A Transfers In 8,596            353,913             361,194        352,598        7,281            102.06% NET TRANSFERS 8,596            353,913             361,194        352,598        7,281            102.06% CHANGE IN FUND BALANCE (716,109)      (172,339)            281,025        997,134        453,364        N/A BEGINNING FUND BALANCE, Jan 1 1,220,276    504,167             504,167        (716,109)       ‐                     100.00% ENDING FUND BALANCE, Dec 31 504,167$     331,828$           785,192$     281,025$     453,364$     236.63% FACILITIES VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 39 of 41   Communications Fund  This fund accounts for community and intergovernmental relations and communications with the public. Communications is  a major activity of the City’s administration responsible for external communications, employee communications, media  relations, and coordination of all departments in producing the City’s website. Expenses are paid by the Communications  Fund and rates are charged to departments based on usage.          Interdepartmental services – The increase in internal service fund charges from prior year is due to COVID‐19. Excess fund  balance was utilized to reduce the burden on departments paying into the Communications Fund. The amount of  interdepartmental services under budget is due to a true up to compare actual costs vs amount collected from other funds.   This true up will be done annually going forward.    Personnel ‐ The amount of personnel costs under prior year and budget are primarily due to open positions.     Contracted Services – The amount of contracted services under budget is primarily due to cost savings related to printing  and postage.          2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 341,175$     1,152,826$        827,218$     486,043$     (325,608)$    71.76% Interest and other misc 55,471          1,000                  19,277          (36,194)         18,277          1927.70% TOTAL REVENUES 396,646        1,153,826          846,495        449,849        (307,331)      73.36% EXPENSES: Personnel 802,827        762,368             661,597        141,230        100,771        86.78% Supplies 28,372          55,432                28,045          327               27,387          50.59% Contracted Services 209,214        359,512             164,959        44,255          194,553        45.88% Internal Services 3,941            2,000                  2,000            1,941             ‐                     100.00% TOTAL OPERATING EXPENSES 1,044,354    1,179,312          856,601        187,753        322,711        72.64% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS (647,708)      (25,486)              (10,106)         637,602        15,380          N/A TOTAL DEBT SERVICE ‐                      ‐                            ‐                     ‐                      ‐                     N/A CAPITAL OUTLAY ‐                      ‐                            ‐                      ‐                      ‐                     N/A Transfers Out 4,229             ‐                            ‐                     4,229             ‐                     N/A NET TRANSFERS (4,229)            ‐                            ‐                     4,229             ‐                     N/A CHANGE IN FUND BALANCE (651,937)      (25,486)              (10,106)         641,831        15,380          N/A BEGINNING FUND BALANCE, Jan 1 803,561        151,624             151,624        (651,937)       ‐                     100.00% ENDING FUND BALANCE, Dec 31 151,624$     126,138$           141,518$     (10,106)$      15,380$        112.19% COMMUNICATIONS VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 40 of 41   Health Insurance Fund  This fund accounts for the City’s self‐insured health insurance program. Expenses/claims are paid by the Health Insurance  Fund and rates are charged to employees and departments based on annual premiums determined by the City’s Employee  Health Plan Board for each type of coverage elected by the employee; paid semi‐monthly in conjunction with each payroll.         Premiums – The amount of premiums over prior year is due to vacant positions that were frozen for most of the year due to  COVID‐19.    Interest and other misc. – The amount of interest and other misc. over the prior year and budget is due to prescription  rebates received in 2021.      Medical/Dental Claims – The increase from previous year is due to many elective procedures were postponed or  rescheduled due to the pandemic.  The current year costs are beginning to stabilize but still not up to the amount expected  per the budget as there were still many elective procedures or well care check ups postponed due to the pandemic.          2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Premiums 11,143,596$   12,328,055$            12,300,979$   1,157,383$      (27,076)$          99.78% Interest and other misc 234,235           149,488                    349,691           115,456           200,203           233.93% TOTAL REVENUES 11,377,831      12,477,543               12,650,670      1,272,839        173,127           101.39% EXPENSES: Personnel 263,059           315,268                    306,053           (42,994)            9,215                97.08% Medical/Dental Claims 9,957,838        11,699,850               10,956,889      (999,051)          742,961           93.65% Supplies 6,930                7,500                         1,669                5,261                5,831                22.25% Contracted Services 467,793           478,037                    438,974           28,819              39,063              91.83% Internal Services 60,430              80,176                       65,379              (4,949)               14,797              81.54% TOTAL OPERATING EXPENSES 10,756,050      12,580,831               11,768,964      (1,012,914)       811,867           93.55% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 621,781           (103,288)                   881,706           259,925           984,994           N/A TOTAL DEBT SERVICE ‐                          ‐                                   ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                   ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                   ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 621,781           (103,288)                   881,706           259,925           984,994           N/A BEGINNING FUND BALANCE, Jan 1 5,151,648        5,773,429                 5,773,429        621,781            ‐                         100.00% ENDING FUND BALANCE, Dec 31 5,773,429$      5,670,141$               6,655,135$      881,706$         984,994$         117.37% Insurance Reserves 3,757,179        3,774,249                 3,774,249         AVAILABLE FUND BALANCE 2,016,250$      1,895,892$               2,880,886$       HEALTH INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2021  Page 41 of 41   Retiree Healthcare Fund  This fund accounts for the City’s self‐insured health insurance program for LEOFF1 retirees. Benefits include medical,  prescription drug, Medicare Part B premiums, long‐term care, and vision coverage for retired law enforcement officers and  firefighters that were employed by the City prior to October 1, 1977. Dependent spouses and children are not covered. 100%  of premiums are provided by the General Fund with annual contributions determined after review of a report prepared by  actuaries.         Premiums – The increase in premiums over the prior year is the result of COVID‐19. Funding of the retiree healthcare fund  reserves was reduced to decrease the burden on the General Fund in response to decreased revenues.    Medical/Dental Claims – The number of covered lives decreased in 2021 from 77 to 74 which impacts the overall claims.          CONTACT INFORMATION  This report is prepared by the Finance Department. For additional financial information, please also review our website:  http://www.rentonwa.gov/.  For any questions about the report, please feel free to contact Nate Malone at  nmalone@rentonwa.gov or Kari Roller at kroller@rentonwa.gov. 2020 2021 2021 YTD YTD ACTUAL ANNUAL  BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 74,545$         45,933$             40,651$         (33,894)$      (5,282)$         88.50% Premiums 1,624,684      2,640,000          2,624,684      1,000,000    (15,316)         99.42% Interest and other misc 171,108         20,000                167,996         (3,112)           147,996        839.98% TOTAL REVENUES 1,870,337      2,705,933          2,833,331      962,994        127,398        104.71% EXPENSES: Personnel 28,488           99,418                94,066           (65,578)         5,352            94.62% Medical/Dental Claims 1,057,676      1,233,956          1,027,301      30,375          206,655        83.25% Contracted Services 42,657           29,311                64,951           (22,294)         (35,640)         221.59% TOTAL OPERATING EXPENSES 1,128,821      1,362,685          1,186,318      (57,497)         176,367        87.06% AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 741,516         1,343,248          1,647,013      905,497        303,765        122.61% TOTAL DEBT SERVICE ‐                       ‐                            ‐                      ‐                      ‐                     N/A CAPITAL OUTLAY ‐                       ‐                            ‐                       ‐                      ‐                     N/A NET TRANSFERS ‐                       ‐                            ‐                       ‐                      ‐                     N/A CHANGE IN FUND BALANCE 741,516         1,343,248          1,647,013      905,497        303,765        122.61% BEGINNING FUND BALANCE, Jan 1 15,799,729    16,541,245        16,541,245    741,516         ‐                     100.00% ENDING FUND BALANCE, Dec 31 16,541,245$ 17,884,493$      18,188,258$ 1,647,013$  303,765$     101.70% Insurance Reserves 16,541,245    17,884,493        18,188,258     AVAILABLE FUND BALANCE ‐$                     ‐$                         ‐$                     RETIREE HEALTHCARE VARIANCE