Loading...
HomeMy WebLinkAboutQuarter 4 2020 H:\Finance\Financial Reporting\Monthly Reports\2020 Reports\QUARTERLY\Cover 4Q2020.docx  ADMINISTRATIVE SERVICES    M   E   M   O   R   A   N   D   U   M       DATE: February 11, 2021     TO: Randy Corman, Council President  Members of Renton City Council     CC: Armondo Pavone, Mayor  Ed VanValey, Interim Chief Administrative Officer     FROM: Kari Roller, Interim ASD Administrator     STAFF CONTACT: Misty Baker, Sr. Finance Analyst     SUBJECT: Quarterly Financial Report 4th Quarter 2020       The attached report provides a detailed discussion of General Fund revenues and  expenditures with comparison to prior year and budget through the end of 2020.      General Fund revenues, excluding Interfund transfers, were $106.9M, which is $11M less  than 2019, but $8.7M over budget. General Fund expenditures, excluding Interfund  transfers, were $97M, which is $3.2M less than 2019 and $10.7M less than budget.   Detailed explanations are provided for 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 x6869 should you have any questions or any  suggestions about the report.      Page 1 of 45   OVERVIEW  This quarterly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through December   31, 2020. 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 include adjustments adopted through Ordinance 5995, which includes revenue and  expenditure budget reductions in response to COVID‐19.    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$      69,685,704$    69,685,704$ 78,953,070$   (10,589,827)$  9,267,366      113.30% Licenses & Permits 5,750,061            4,676,877          4,676,877       5,199,555         (550,506)            522,678           111.18% Intergovernmental 4,820,547            11,086,103       11,086,103    9,387,904         4,567,357         (1,698,199)     84.68% Charges for Services 9,251,750            7,513,713          7,513,713       7,514,930         (1,736,820)        1,217                 100.02% Fines and Penalties 4,688,980            3,284,187          3,284,187       3,310,279         (1,378,701)        26,092              100.79% Miscellaneous 3,762,854            1,928,417          1,928,417       2,463,789         (1,299,065)        535,372           127.76% Other Financing Sources (Transfer‐In, etc) 13,137,402         21,951,170       21,951,170    17,475,836      4,338,434         (4,475,334)     79.61% Total Revenues 130,954,491      120,126,171    120,126,171 124,305,363   (6,649,128)        4,179,192      103.48% EXPENDITURES Council 359,238                420,924               420,924            425,744             (66,506)               (4,820)               101.15% Executive 2,559,087            2,595,793          2,595,793       2,276,448         282,639              319,345           87.70% Emergency Management 621,727                7,888,225          7,888,225       5,966,342         (5,344,615)        1,921,883      75.64% City Attorney 2,353,520            2,421,421          2,421,421       2,207,330         146,190              214,091           91.16% Court Services 2,406,014            2,706,695          2,706,695       2,444,436         (38,422)               262,259           90.31% Community and Eco Dvlpmnt Admin 1,598,892            1,560,726          1,560,726       1,547,585         51,307                 13,141              99.16% Development Services 2,322,460            2,648,176          2,648,176       2,454,062         (131,602)            194,114           92.67% Economic Development 1,085,032            4,465,671          4,465,671       2,383,215         (1,298,183)        2,082,456      53.37% Planning 3,802,894            4,359,422          4,359,422       4,027,715         (224,821)            331,707           92.39% Finance 3,327,937            3,709,001          3,709,001       3,503,205         (175,268)            205,796           94.45% City Clerk 1,286,227            1,175,923          1,175,923       1,179,642         106,585              (3,719)               100.32% Human Resources 1,438,605            1,530,267          1,530,267       1,393,876         44,729                 136,391           91.09% Police 37,379,203         33,705,130       33,705,130    33,063,510      4,315,693         641,620           98.10% Jail Services 5,766,293            4,707,756          4,707,756       4,708,087         1,058,206         (331)                    100.01% Community Services Admin 594,844                520,919               520,919            502,089             92,755                 18,830              96.39% Leased Properties 880,676                1,013,086          1,013,086       883,577             (2,901)                  129,509           87.22% Parks & Trails 5,249,860            5,028,628          5,028,628       4,819,600         430,260              209,028           95.84% Parks Planning & Natural Resources 1,514,329            2,506,579          2,506,579       2,091,103         (576,774)            415,476           83.42% Recreation & Neighborhoods 6,432,140            4,904,722          4,904,722       4,375,970         2,056,170         528,752           89.22% Human Services 1,478,729            2,055,693          2,055,693       1,468,780         9,949                    586,913           71.45% Museum 253,008                225,195               225,195            221,057             31,951                 4,138                 98.16% Public Works Admin 424,466                444,895               444,895            400,739             23,727                 44,156              90.07% Street Maintenance 5,822,538            5,591,654          5,591,654       5,449,555         372,983              142,099           97.46% Transportation 8,160,553            7,059,187          7,059,187       6,769,072         1,391,481         290,115           95.89% Non‐Departmental and Other 30,357,614         25,489,926       25,489,926    23,408,024      6,949,590         2,081,902      91.83% Total Expenditures 127,475,886      128,735,614    128,735,614 117,970,763   9,505,123         10,764,851   91.64% Change in Fund Balance 3,478,605            (8,609,443)         (8,609,443)      6,334,600         2,855,995         14,944,043   N/A Beginning Fund Balance 44,578,377         48,056,982       48,056,982    48,056,982      3,478,605          ‐                       100.00% Ending Fund Balance 48,056,982$      39,447,539$    39,447,539$ 54,391,582$   6,334,600$      14,944,043   137.88% Favorable (Unfavorable) 2019 2020 Variance YTD Actual Annual Budget YTD Budget YTD Actual Summary of Sources and Uses Quarterly Financial Report 4th Quarter 2020  Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 2 of 45   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 variance are shown in a   favorable (unfavorable) format.    TAXES        Property Tax – Property tax collections by King County have exceeded prior year and YTD budget. $208K of property taxes  collected through December 31 were for prior years’ delinquent taxes, bringing the balance of delinquent taxes receivable to  $36K. The remainder of taxes collected were for the 2020 levy. The 2020 property tax levy after levy changes by the assessor’s  office totalled $21,985,155. The taxes receivable balance for the 2020 levy is $296K at December 31.    Local Retail Sales Tax – COVID‐19 will heavily influence the sales tax figures throughout 2020. There are three factors which  as going to impact our sales tax distribution: 1) DOR is providing extensions for monthly filers, 2) many stores and other retail  locations have been required to be closed during the governor’s stay‐at‐home order, therefore, little to no sales will be made  during this time, and 3) some businesses will be closing due to decreased revenues. Please see the monthly sales tax report  for more information. Sales tax revenues came in at $1.9M less than 2019, however, they were $2.5M more than expected  after the budget was reduced ($4.7M) for COVID‐19.    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. The City began receiving the state sales tax credit revenues in the 4th  quarter of 2019.     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 one‐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 capital basis.  The decrease in criminal justice sales tax directly relates to the decrease in retail sales tax, as described above.     Natural Gas Use Tax – Per RCW 82.14.230, any city that has a natural gas utility tax may impose an equivalent “use tax” upon  brokered natural gas sales that are otherwise not subject to the utility tax. Natural gas use taxes are paid by the consumer  and is remitted to the city by the Washington Department of Revenue. Natural gas use tax revenues ended the year $101K  and $107K less than prior year and budget, respectively.   2019 2020 2020 Actual Budget Actual $ % $ % Property Tax 20,978,323$      21,280,959$       21,874,241$      895,919$           4.3% 593,282$           2.8% Local Retail Sales Tax 28,318,580         23,959,932          26,452,836         (1,865,744)         ‐6.6%2,492,904         10.4% State Sales Tax Credit 340,573                 500,000                 1,292,834            952,261              279.6% 792,834              158.6% Criminal Justice Sales Tax 3,267,926            2,988,502             3,017,430            (250,496)             ‐7.7%28,928                 1.0% Natural Gas Use Tax 224,519                 230,900                 123,787                 (100,732)             ‐44.9% (107,113)             ‐46.4% Admission Tax 196,087                 150,000                 85,174                    (110,914)             ‐56.6% (64,826)                ‐43.2% Utility Tax 15,337,128         14,561,111          15,916,168         579,040              3.8% 1,355,057         9.3% Leasehold Excise Tax 179,612                 129,300                 183,450                 3,838                    2.1% 54,150                 41.9% Gambling Excise Tax 2,883,506            1,385,000             2,391,499            (492,007)             ‐17.1%1,006,499         72.7% Real Estate Excise Tax 6,737,711             ‐                                    ‐                                   (6,737,711)        0.0%‐                                N/A B&O Tax 11,078,932         4,500,000             7,615,650            (3,463,282)         ‐31.3%3,115,650         69.2% YTD Total 89,542,897$      69,685,704$       78,953,070$      (10,589,827)$   ‐11.8%9,267,366$      13.3% Annual Total 89,542,897$      69,685,704$        Taxes by Type Revenue 2020 vs. 2019 2020 vs. Budget Year to Date through December Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 3 of 45   Admission Tax – Per RCW 35.21.280, any city may impose an admission tax up to 5% of the admission charge for various  events and facilities. The decrease in admission tax revenues is due to COVID‐19 restrictions which closed events and facilities  subject to the admissions tax for the majority of 2020.    Utility Tax – The increase in utility tax is due to a combination of factors. Some taxes have decreased while others have  increased.     The breakdown of Utility Tax is as follows:        Gambling Excise Tax – COVID‐19 heavily influenced the gambling tax figures. Card game operations have not been permitted  to operate indoors for the majority of 2020. While the gambling tax revenues ended the year $492K less than 2019, they were  $1M higher than expected after the budget was reduced ($1.1M) for COVID‐19.    Real Estate Excise Tax ‐ REET taxes were improperly recorded to the General Fund in the 3rd and 4th quarter of 2019. The  taxes were subsequently transferred to the appropriate capital project funds where they are properly budgeted and recorded  in 2020 in accordance with the requirements of RCW 82.46.    Business and Occupation (B&O) Tax – B&O tax revenues rely heavily on the revenue of a limited number of large businesses.  These businesses have seen economic downturn in 2020 as a result of COVID‐19 as well as other factors. However, the $3.5M  decrease in B&O taxes from 2019 is much less than anticipated when the budget was reduced ($5M) for COVID‐19 and B&O  tax revenues ended the year $3.1M over budget.     LICENSES & PERMITS        Franchise Fees – Franchise fees ended the year $266K higher than expected after the budget was reduced ($420K) for COVID‐ 19.      Building Permits – The governor’s stay‐at‐home order forced many commercial and most residential construction projects to  stop for an extended period of time. The stay‐at‐home order has now expired, but permit activity has not returned to pre‐ COVID‐19 levels due to an overall decline in the economy. However, the decline is less than anticipated after the budget was  reduced ($339K) for COVID‐19 and building permits ended the year $204K over budget.   2019 2020 2020 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Electrical 5,125,961$     4,999,176$         5,497,851$     371,890$        7.3% $      498,675 10.0% Natural Gas 1,324,323        1,223,009            1,583,721        259,398           19.6%          360,712 29.5% Cell 797,541            624,273                 787,466            (10,075)             ‐1.3%          163,193 26.1% Phone 858,927            802,901                 661,593            (197,334)          ‐23.0%        (141,308)‐17.6% Cable 1,457,008        1,436,847            1,447,676        (9,332)                ‐0.6%             10,829 0.8% Garbage 796,379            733,057                 970,481            174,102           21.9%          237,425 32.4% City Utilities 4,976,990        4,741,848            4,967,380        (9,610)                ‐0.2%          225,532 4.8% YTD Total 15,337,128$  14,561,111$      15,916,168$  579,040$        3.8%1,355,057$  9.3% 2020 vs. 2019 2020 vs. Budget 2019 2020 2020 Actual Budget Actual $ % $ % Franchise Fees 1,520,143            1,231,692             1,497,985            (22,159)                ‐1.5%266,293              21.6% Business Licenses 1,098,584            918,780                 1,009,760            (88,824)                ‐8.1%90,980                 9.9% Animal Licenses 80,770                    93,174                    71,445                    (9,325)                   ‐11.5% (21,729)                ‐23.3% Building Permits 3,008,083            2,385,731             2,589,530            (418,553)             ‐13.9%203,799              8.5% ROW/Street Excavation Permits 40,315                    46,500                    30,870                    (9,445)                   ‐23.4% (15,630)                ‐33.6% Special Event Permits 2,165                       1,000                       (35)                             (2,200)                   ‐101.6% (1,035)                   ‐103.5% YTD Total 5,750,061$         4,676,877$          5,199,555$         (550,506)$          ‐9.6%522,678$           11.2% Annual Total 5,750,061$         4,676,877$           Licenses & Permits by Type Year to Date through December Revenue 2020 vs. 2019 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 4 of 45   INTERGOVERNMENTAL        State Shared Revenue – The decrease in state shared revenues over prior year is almost entirely due to decreases in criminal  justice – high crime and fuel tax revenues. COVID‐19 is heavily influencing these revenues. However, higher than expected  liquor excise taxes and unbudgeted marijuana taxes are resulting in overall state shared revenues ending the year $330K over  budget. The breakdown of State Shared Revenue is as follows:        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.     CHARGES FOR SERVICES        Public Safety Services – The decrease in public safety services is due to two factors: 1) payments under the School Resource  Officer program ceased with the closure of schools due to COVID‐19 and 2) collections of home detention fees have been  reduced by half due to the closure of City Hall and not having an online payment option. Finance is working with the Police  Department to develop alternative collection options.   2019 2020 2020 Actual Budget Actual $ % $ % State Shared Revenue 4,291,629$         3,642,420$          3,972,802$         (318,827)$          ‐7.4%330,382$           9.1% Federal Grants 189,155                 6,871,029             5,122,364            4,933,209         2608.0%(1,748,665)         ‐25.4% State Grants 65,878                    181,271                 75,879                    10,001                 15.2%(105,392)             ‐58.1% Local Grants 273,886                 391,383                 216,859                 (57,027)                ‐20.8% (174,524)             ‐44.6% YTD Total 4,820,547$         11,086,103$       9,387,903$         4,567,356$      94.7%(1,698,199)$      ‐15.3% Annual Total 4,820,547$         11,086,103$        Intergovernmental by Type Revenue 2020 vs. 2019 2020 vs. Budget Year to Date through December 2019 2020 2020 Tax by Type YTD Actual YTD Budget YTD Actual$%$% Judicial Contribution 21,666$         17,212$         32,304$         10,638$        49.1% 15,092$        87.7% Crim Just ‐ High Crime 289,405         279,154         140,366         (149,039)       ‐51.5% (138,788)       ‐49.7% Crim Just ‐ Pop 31,208            24,725            32,817            1,609              5.2% 8,092              32.7% Crim Just ‐ Spec Prog 112,281         113,286         117,451         5,170              4.6% 4,165              3.7% State DUI 14,506            18,043            15,226            720                  5.0%(2,817)             ‐15.6% Marijuana Distribution 209,738          ‐                           203,826         (5,912)             ‐2.8%203,826        100.0% Liquor Profits 848,678         850,000         840,871         (7,807)             ‐0.9% (9,129)             ‐1.1% Liquor Excise Tax 569,220         497,350         660,296         91,077           16.0% 162,946        32.8% Fuel Tax 2,194,927     1,842,650     1,929,644     (265,283)       ‐12.1%86,994           4.7% YTD Total 4,291,629$  3,642,420$  3,972,802$  (318,827)$   ‐7.4%330,382$     9.1% 2020 vs. 2019 2020 vs. Budget 2019 2020 2020 Actual Budget Actual $ % $ % Passport Fees 35,025                    60,000                    8,883                       (26,142)                ‐74.6% (51,117)                ‐85.2% Court Services 82,972                    11,000                    110,288                 27,316                 32.9% 99,288                 902.6% General Government Services 2,359                       8,000                       11,538                    9,179                    389.1% 3,538                    44.2% Public Safety Services 1,266,661            737,835                 710,544                 (556,116)             ‐43.9% (27,291)                ‐3.7% Development Services 2,090,933            1,490,271             1,540,352            (550,581)             ‐26.3%50,081                 3.4% Transportation Services 17,144                     ‐                                   71,276                    54,132                 315.7% 71,276                 100.0% Recreation/Farmer's Market/Events 1,561,932            218,633                 295,863                 (1,266,069)         ‐81.1%77,230                 35.3% Interfund Services 4,194,724            4,987,974             4,766,185            571,462              13.6%(221,788)             ‐4.4% YTD Total 9,251,750$         7,513,713$          7,514,930$         (1,736,820)$      ‐18.8%1,217$                 0.0% Annual Total 9,251,750$         7,513,713$           Year to Date through December Charges for Services by Type Revenue 2020 vs. 2019 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 5 of 45   Development Services – The decrease in development services from the prior year is primarily due to inspection services  ($326K) and planning fees ($269K). The amount of development services revenues over budget is primarily due to a  combination of inspections services under budget ($137K) offset by planning fees over budget $215K.     Recreation/Farmer’s Market/Events – The decrease in revenues is related to cancelled programs, as a result of COVID‐19.    Interfund Services – Interfund services revenues increased from the prior year due to increased reimbursement of staffing  costs from CIP projects ($435K), increases in indirect cost allocations ($90K), and increased services performed for Enterprise  Funds ($46K). Interfund services revenues are less than the YTD budget as the budget reflects reimbursement of staffing costs  from CIP projects that staff did not work on during the first three quarters of the year, including reimbursement for a capital  project coordinator position that is vacant ($154K) and less than anticipated charges for work performed for Enterprise Funds  ($67K).    FINES AND PENALTIES        Civil Penalties – The majority of Civil Penalties less than prior year and under budget are due to less than anticipated traffic  infraction penalties. COVID‐19 is heavily influencing these penalties as people are driving less.     Photo Enforcement Program – Photo enforcement revenues have decreased from prior year due to reduced citations as a  result of the governor’s stay‐at‐home order. Traffic volumes have decreased and school zone cameras have been turned off  as a result of school closures.    MISCELLANEOUS REVENUES        Interest and Other Investment Earnings – Since interest earnings can vary greatly based on market conditions, the City has  historically budgeted interest and investment earnings very conservatively. As such, even though interest earnings decreased  ($283K) from the prior year, they were still $253K over budget.    Rents, Leases, and Concessions ‐ Rental revenue is down from the prior year due to a few vacant City facilities, combined  with cancelled facility space rentals at the Senior Center and Renton Community Center and waived rent for tenants of City  facilities that were ordered closed in March due to COVID‐19.    2019 2020 2020 Actual Budget Actual $ % $ % Civil Penalties 471,329$              428,200$              349,999$              (121,330)$          ‐25.7% (78,201)$             ‐18.3% Photo Enforcement Program 3,920,305            2,621,405             2,754,379            (1,165,926)         ‐29.7%132,974              5.1% Criminal Traffic Misdemeanor Fines 61,914                    77,500                    55,162                    (6,752)                   ‐10.9% (22,338)                ‐28.8% Criminal Non‐Traffic Fines 80,602                    29,500                    6,534                       (74,068)                ‐91.9% (22,966)                ‐77.9% Criminal Costs 71,145                    25,000                    57,980                    (13,165)                ‐18.5%32,980                 131.9% Non‐Court Fines, Forfeitures and Penalties 83,685                    102,582                 86,225                    2,540                    3.0%(16,357)                ‐15.9% YTD Total 4,688,980$         3,284,187$          3,310,279$         (1,378,701)$      ‐29.4%26,092$              0.8% Annual Total 4,688,980$         3,284,187$           Year to Date through December Revenue 2020 vs. 2019 2020 vs. Budget Fines and Penalties by Type 2019 2020 2020 Actual Budget Actual $ % $ % Interest and Other Investment Earnings 1,360,892$         825,000$              1,077,967$         (282,925)$          ‐20.8%252,967$           30.7% Rents, Leases, and Concessions 1,715,372            758,295                 849,604                 (865,768)             ‐50.5%91,309                 12.0% Contributions/Donations from Private Source 271,592                 90,000                    47,019                    (224,573)             ‐82.7% (42,981)                ‐47.8% Seizure Funds ‐ Federal/State/Local 102,229                  ‐                                    ‐                                   (102,229)            0.0%‐                                N/A Other 312,769                 255,122                 489,199                 176,430              56.4% 234,077              91.8% YTD Total 3,762,854$         1,928,417$          2,463,789$         (1,299,065)$      ‐34.5%535,372$           27.8% Annual Total 3,762,854$         1,928,417$           Year to Date through December Revenue 2020 vs. 2019 2020 vs. Budget Miscellaneous by Type Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 6 of 45   Seizure Funds – Federal/State/Local – Seizure funds decreased from the prior year because they were transferred to their  own special revenue funds in 2020 to allow for transparency in the accounting for these restricted revenues.     Other – Other miscellaneous revenues are higher than prior year and higher than the YTD budget primarily due to the receipt  of an unbudgeted payment of $327K under the terms of the Sunset Lane Latecomer Agreement (ORD 5961), which is  offsetting a decrease in utility late payments of ($128K) from prior year and ($167K) below budget. There is currently a State  mandated moratorium on utility disconnections for non‐payment due to COVID‐19.    OTHER FINANCING SOURCES        Transfers from Other Funds – Transfers from Other Funds are summarized below:        The remaining balance of the Benson Hill Annexation sales tax credit reserves held in the Insurance Fund was budgeted to be  transferred to the General Fund to offset COVID‐19 revenue shortfalls in the amount of $4.5M. However, once it was apparent  that revenue shortfalls were not going to be as significant as originally anticipated, management decided the $4.5M transfer  of reserves from the Insurance Fund was unnecessary.    *Transfers between the General Fund and its management funds are just over $12.1M. In the past, these tax revenues were  allocated amount the various management funds of the General Fund. In 2020, 100% of tax revenues are recognized in the  General Fund (000) with transfers to the Community Services Fund (001), the Street Fund (003), and the Museum Fund (005).  For budgetary purposes, the transfer in and transfer out amounts are reflected in the General Fund revenues and  expenditures. Transfers between the General Fund and its management funds are eliminated for reporting in the City’s  Comprehensive Annual Financial Report (CAFR).     2019 2020 2020 Actual Budget Actual $ % $ % Transfers from Other Funds 13,126,453$      21,951,170$       17,451,170$      4,324,717         32.9%(4,500,000)         ‐20.5% Prior Period Adjustment ‐                                    ‐                                    ‐                                    ‐                                N/A ‐                                N/A Insurance Recoveries 10,949                     ‐                                   4,566                       (6,383)                   ‐58.3%4,566                    100.0% Sale of Capital Assets ‐                                    ‐                                   20,100                    20,100                 100.0% 20,100                 100.0% YTD Total 13,137,402$      21,951,170$       17,475,836$      4,338,434$      33.0%(4,475,334)$      ‐20.4% Annual Total 13,137,402$      21,951,170$        Year to Date through December Other Financing Sources by Type Revenue 2020 vs. 2019 2020 vs. Budget Purpose 000 General Fund* 110 Hotel/Motel Tax 316  Municipal Facilities  CIP 326 Housing  Opportunity Total Density Transfer proceeds funding affordable housing grants in Sunset area 514,460$                      514,460$          Library sale proceeds funding Multi‐Service Center capital grant 400,000                         400,000             Housing Opportunity funding for affordable housing grant 25,000                            25,000                CIP funding reductions to offset COVID‐19 revenue shortfalls 1,809,220                     1,809,220         Renton Marketing Campaign funding match for Port of Seattle grant 37,500                                 37,500                Create Fund 098 ‐ Economic Development Reserve (GF mgmt fund)2,551,659                    2,551,659         Property Tax Funding of Fund 001 ‐ Community Services (GF mgmt fund)* 5,094,333                             5,094,333         Property Tax Funding of Fund 003 ‐ Streets (GF mgmt fund)* 6,779,869                             6,779,869         Property Tax Funding of Fund 005 ‐ Museum (GF mgmt fund)* 239,129                                 239,129             Total 12,113,331$                       37,500$                              2,723,680$                  2,576,659$                 17,451,170$   From: Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 7 of 45   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.     COUNCIL        EXECUTIVE        Personnel – The amount of personnel expenditures under the prior year and budget is due an open position.    Contracted Services – The amount of contracted services under budget is due to a combination of savings in amounts spent  for Court Public Defenders $68K, the Renton Results program $20K, and the Inclusion program $39K.     Internal Services – The decrease in internal services from the prior year is due to reductions made to Communications and  Facilities in response to COVID‐19.    EMERGENCY MANAGEMENT        Personnel – The amount of personnel costs over the prior year is due to $2.5M in Police salary/benefits being reclassified to  Emergency Management to reflect the cost of the public safety response to the COVID‐19 emergency. These costs qualified  for reimbursement under the CARES grant passed through to the City from the Washington Department of Commerce.    Supplies – The amount of supplies in excess of the prior year is due to supplies purchased in conjunction with COVID‐19. The  supplies consisted of items such as cleaning agents, personal protective equipment (PPE), additional hand sanitizing stations,  plexiglass barriers, etc. The amount of supplies under the budget is due to budgeting more in supplies under the CARES grant  than was needed. The excess grant funds were applied to eligible salaries and benefits instead, as noted above.  Council Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 288,140$             337,867$            337,867$         346,653$          (58,512)$            ‐20.3% (8,786)$             ‐2.6% Supplies 3,541                      1,400                     1,400                  930                        2,611                  73.7% 470                     33.6% Contracted Services 13,186                   23,316                  23,316               19,978                (6,792)                  ‐51.5%3,338                 14.3% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 54,371                   58,341                  58,341               58,183                (3,812)                  ‐7.0%158                     0.3% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 359,238$             420,924$            420,924$         425,744$          (66,506)$            ‐18.5% (4,820)$             ‐1.1% 2020 Prior Year YTD YTD Budget Variance Favorable (Unfavorable) Executive Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 868,749$             899,204$            899,204$         752,056$          116,693$         13.4% 147,148$        16.4% Supplies 9,814                      8,100                     8,100                  1,646                   8,168                  83.2% 6,454                 79.7% Contracted Services 1,231,570            1,400,134           1,400,134       1,273,995         (42,425)               ‐3.4%126,139           9.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 448,954                288,355               288,355            248,751             200,203            44.6% 39,604              13.7% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 2,559,087$         2,595,793$        2,595,793$    2,276,448$      282,639$         11.0% 319,344$        12.3% 2020 Prior Year YTD YTD Budget Variance Favorable (Unfavorable) Emergency Management Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 422,702$             2,933,658$        2,933,658$    2,917,758$      (2,495,056)$    ‐590.3%15,900$           0.5% Supplies 17,736                   1,498,500           1,498,500       367,307             (349,571)            ‐1971.0%1,131,193      75.5% Contracted Services 26,136                   3,252,361           3,252,361       2,496,612         (2,470,476)       ‐9452.3%755,749           23.2% Capital Outlay ‐                                  18,438                  18,438                ‐                                ‐                              0.0% 18,438              100.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 155,153                185,268               185,268            183,971             (28,818)               ‐18.6%1,297                 0.7% Transfers Out ‐                                   ‐                                  ‐                              694                        (694)                     100.0%(694)                    100.0% Total Expenditures 621,727$             7,888,225$        7,888,225$    5,966,342$      (5,344,615)$    ‐859.6%1,921,883$   24.4% 2020 Prior Year YTD YTD Budget Variance Favorable (Unfavorable) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 8 of 45   Contracted Services – The amount of contracted services over the prior year is due to COVID‐19 related small business grants  and rental and food assistance. These expenditures were funded by the CARES grant. The amount of contracted services  under the budget is due to less rental and food assistance costs than anticipated. This assistance was provided by contracting  with local non‐profit agencies. The excess grant funds were applied to eligible salaries and benefits instead, as noted above.    CITY ATTORNEY        Personnel ‐ The amount of personnel costs under the prior year and budget is due to open positions.    COURT SERVICES        Personnel ‐ The increase in personnel costs over the prior year is due to COLA’s, reclassifications, and the addition of a judge.  The amount of personnel costs under the YTD budget is due to open positions.    COMMUNITY AND ECONOMIC DEVELOPMENT ADMIN           City Attorney Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 2,131,174$         2,193,925$        2,193,925$    1,999,736$      131,437$         6.2% 194,188$        8.9% Supplies 979                           3,550                     3,550                  1,155                   (176)                      ‐18.0%2,395                 67.5% Contracted Services 32,937                   41,465                  41,465               24,021                8,916                  27.1% 17,444              42.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 184,281                182,481               182,481            182,418             1,863                  1.0% 63                        0.0% Transfers Out 4,150                       ‐                                  ‐                               ‐                               4,150                  100.0%‐                             0.0% Total Expenditures 2,353,520$         2,421,421$        2,421,421$    2,207,330$      146,191$         6.2% 214,091$        8.8% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Court Services Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,793,080$         2,203,800$        2,203,800$    1,958,279$      (165,199)$         ‐9.2%245,522$        11.1% Supplies 5,103                      7,700                     7,700                  3,282                   1,821                  35.7% 4,418                 57.4% Contracted Services 128,988                106,856               106,856            93,410                35,578               27.6% 13,446              12.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 458,596                388,339               388,339            385,902             72,694               15.9% 2,437                 0.6% Transfers Out 20,248                    ‐                                  ‐                              3,564                   16,684               82.4%(3,564)               100.0% Total Expenditures 2,406,014$         2,706,695$        2,706,695$    2,444,436$      (38,422)$            ‐1.6%262,259$        9.7% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Community and Econ Dvlpmnt Admin Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 370,347$             389,402$            389,402$         381,551$          (11,204)$            ‐3.0%7,851$              2.0% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 825                           850                          850                      556                        269                       32.6% 294                     34.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 1,050,460            989,334               989,334            976,439             74,021               7.0% 12,895              1.3% Transfers Out 177,261                181,140               181,140            189,040             (11,779)               ‐6.6% (7,900)                ‐4.4% Total Expenditures 1,598,892$         1,560,726$        1,560,726$    1,547,585$      51,307$            3.2% 13,141$           0.8% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 9 of 45   DEVELOPMENT SERVICES        Personnel – The increase in personnel costs over the prior year is due to COLA’s, reclassifications, and the addition of a  building inspector/combination position. The amount of personnel costs under budget is due to open positions.    ECONOMIC DEVELOPMENT        Personnel ‐ The increase in personnel costs over the prior year is due to COLA’s, reclassifications, and the filling of the Housing  Programs Manager position that was vacant for most of 2019.    Contracted Services ‐ The increase in contracted services over the prior year is due to a $25K Housing Opportunity grant, a  $60K Density Transfer grant, a $400K grant to support construction of RHA’s new Multi‐Service Center, $88K for the DOC  grant funded Housing Action Plan, $160K for COVID‐19 business support activities funded by a King County CARES Act grant,  and $265K in impact fee waivers that were awarded to multiple non‐profits to support low income housing developments.  RMC 4‐1‐210 allows for the waiver of 100% of impact fees associated with certain low‐income housing developments. State  law only allows for an 80% waiver of these fees, so the General Fund must contribute the remaining 20% of the fees to the  impact mitigation funds. Ordinance No. 5973 imposed a six‐month moratorium on the submission, acceptance, processing,  or approval of any application for waived fees under RMC 4‐1‐210, effective December 22, 2020. The amount of contracted  services expenditures under the budget is primarily due to anticipated CDBG grant funding for Economic Development  ($362K) that was not realized and City grants awarded to support low‐income housing and other charitable construction  projects that have not been paid out yet ($850K). The City grants are subject to certain performance measures being met by  the grantee prior to the payment of the grant award. The balance of these grants not yet paid will be included in the 2021  carry forward budget adjustment.     Capital Outlay – Economic Development capital outlay is associated with the Downtown Streetscape project being funded  through a CDBG grant. The amounts over the prior year are due to timing of project planning/construction costs. As with  other capital projects, the entire amount of the project has been budgeted and the budget balance will be carried forward  each year until the project is complete.        Development Services Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 2,148,838$         2,458,925$        2,458,925$    2,316,739$      (167,901)$         ‐7.8%142,186$        5.8% Supplies 6,672                      7,525                     7,525                  2,854                   3,818                  57.2% 4,671                 62.1% Contracted Services 104,374                122,912               122,912            75,654                28,719               27.5% 47,257              38.4% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 62,576                   58,814                  58,814               58,814                3,762                  6.0%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 2,322,460$         2,648,176$        2,648,176$    2,454,062$      (131,602)$         ‐5.7%194,114$        7.3% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Economic Development Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 681,788$             940,340$            940,340$         852,171$          (170,382)$         ‐25.0%88,170$           9.4% Supplies 21,304                   35,625                  35,625               7,298                   14,006               65.7% 28,327              79.5% Contracted Services 311,246                2,507,432           2,507,432       1,229,562         (918,317)            ‐295.0%1,277,869      51.0% Capital Outlay 70,694                   982,274               982,274            294,184             (223,490)            ‐316.1%688,090           70.1% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,085,032$         4,465,671$        4,465,671$    2,383,215$      (1,298,183)$    ‐119.6%2,082,456$   46.6% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 10 of 45   PLANNING        Personnel – The increase in personnel costs over the prior year is due to COLA’s, reclassifications, and the filling of a  construction inspector position that was vacant in 2019. The amount of personnel costs under budget are due to vacant  positions.    Contracted Services – The majority of contracted services under the budget is due to the TOD Subarea Plan contract which  is still in process. The amount of the contract remaining at December 31 is $82,467. In accordance with City Policy 220‐01,  Budget Preparation and Control, section 4.2.6, the balance of this contract will be included in the 2021 carry forward budget  adjustment.     FINANCE        Personnel ‐ The amount of personnel costs under the YTD budget is due to open positions.    Contracted Services – The amount of contracted services over the prior year is primarily due to increased merchant fees  ($103K) as more payments have been received online due to COVID‐19 and legal fees ($81K) associated with a utility tax  assessment that is being contested by the taxpayer. The amount of contracted services over budget is primarily due to higher  than anticipated merchant fees ($118K).     CITY CLERK           Planning Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 3,633,581$         4,008,905$        4,008,905$    3,852,460$      (218,878)$         ‐6.0%156,445$        3.9% Supplies 9,562                      11,600                  11,600               3,083                   6,479                  67.8% 8,517                 73.4% Contracted Services 126,467                249,492               249,492            140,448             (13,981)               ‐11.1%109,044           43.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 33,284                   31,724                  31,724               31,724                1,560                  4.7%‐                             0.0% Transfers Out ‐                                  57,700                  57,700                ‐                                ‐                              0.0% 57,700              100.0% Total Expenditures 3,802,894$         4,359,422$        4,359,422$    4,027,715$      (224,821)$         ‐5.9%331,706$        7.6% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Finance Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,956,457$         2,288,635$        2,288,635$    1,980,502$      (24,045)$            ‐1.2%308,133$        13.5% Supplies 4,683                      11,500                  11,500               2,850                   1,833                  39.1% 8,650                 75.2% Contracted Services 967,662                1,028,521           1,028,521       1,144,493         (176,831)            ‐18.3% (115,972)          ‐11.3% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 397,355                380,345               380,345            375,361             21,994               5.5% 4,984                 1.3% Transfers Out 1,781                       ‐                                  ‐                               ‐                               1,781                  100.0%‐                             0.0% Total Expenditures 3,327,937$         3,709,001$        3,709,001$    3,503,205$      (175,268)$         ‐5.3%205,795$        5.5% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 City Clerk Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 746,919$             723,688$            723,688$         724,843$          22,076$            3.0%(1,154)$             ‐0.2% Supplies 3,951                      4,094                     4,094                  1,259                   2,691                  68.1% 2,835                 69.2% Contracted Services 364,774                288,739               288,739            296,876             67,898               18.6%(8,137)                ‐2.8% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 169,814                159,402               159,402            156,665             13,149               7.7% 2,737                 1.7% Transfers Out 770                            ‐                                  ‐                               ‐                               770                       100.0%‐                             0.0% Total Expenditures 1,286,227$         1,175,923$        1,175,923$    1,179,642$      106,585$         8.3%(3,719)$             ‐0.3% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 11 of 45   HUMAN RESOURCES        POLICE        Personnel ‐ The decrease in salaries and benefits over the prior year is the net effect of increases due to COLAs, annual step  increases, and the reclassification of the deputy chief and commander positions, offset by $2.5M in Police salary/benefits  that were reclassified to Emergency Management to reflect the cost of the public safety response to the COVID‐19  emergency. These costs qualified for reimbursement under the CARES grant passed through to the City from the Washington  Department of Commerce.     Supplies – The decrease in supplies over the prior year is primarily due to cost savings in Patrol Operations ($72K) and Police  Administration ($158K), and supply purchases utilizing seizure funds ($101K) that have been moved into their own special  revenue funds in 2020. The amount of supplies under budget is primarily due to cost savings in Investigations ($21K), Quarter  Master System ($34K), and four multi‐year grant awards ($70K). The budget balance in grant funded supplies will be included  in the carry forward budget adjustment.     Contracted Services – The decrease in contracted services from the prior year is primarily due to the following: The City did  not contribute to the Alive and Free Program in 2020 ($30K), decreased travel/training expenses in Police Admin ($26K), a  decrease in costs associated with school zone cameras ($450K), a decrease in equipment rental related to Electronic Home  Detention ($80K), and contracted services expenditures utilizing seizure funds ($111K) that have been moved into their own  special revenue funds in 2020. The amount of contracted services under budget is primarily due to lower than anticipated  costs associated with school zone cameras ($440K) that have been turned off since March due to COVID‐19.    Internal Services ‐ Decreased internal service fund charges are a result of 9 months’ replacement reserve payments being  waived in response to COVID‐19. All vehicle/equipment purchases and replacements are being postponed one year.     Transfers Out – The decrease in transfers out from the prior year is primarily the net effect of a $1.5M transfer in 2019 to  fund new Police take‐home vehicles that was not repeated in 2020 and the transfer out in 2020 of seizure fund balances in  the amount of $732K.   Human Resources Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,024,525$         1,153,163$        1,153,163$    1,090,582$      (66,057)$            ‐6.4%62,581$           5.4% Supplies 17,099                   8,828                     8,828                  2,951                   14,148               82.7% 5,877                 66.6% Contracted Services 120,116                130,663               130,663            68,759                51,357               42.8% 61,904              47.4% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 267,513                237,613               237,613            231,585             35,928               13.4% 6,028                 2.5% Transfers Out 9,352                       ‐                                  ‐                               ‐                               9,352                  100.0%‐                             0.0% Total Expenditures 1,438,605$         1,530,267$        1,530,267$    1,393,876$      44,729$            3.1% 136,391$        8.9% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Police Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 24,994,284$      22,813,594$     22,813,594$ 22,829,119$   2,165,166$     8.7%(15,525)$          ‐0.1% Supplies 612,118                419,405               419,405            282,572             329,546            53.8% 136,833           32.6% Contracted Services 5,183,266            4,938,680           4,938,680       4,468,309         714,957            13.8% 470,371           9.5% Capital Outlay 10,569                   41,154                  41,154                ‐                               10,569               100.0% 41,154              100.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 4,956,999            4,646,155           4,646,155       4,640,249         316,750            6.4% 5,907                 0.1% Transfers Out 1,621,967            846,143               846,143            843,263             778,704            48.0% 2,880                 0.3% Total Expenditures 37,379,203$      33,705,130$     33,705,130$ 33,063,510$   4,315,693$     11.5% 641,620$        1.9% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 12 of 45   JAIL SERVICES        Contracted Services ‐ The decrease in jail services from the prior year due to a decrease in the monthly contract payments  to SCORE for 2020.     COMMUNITY SERVICES ADMIN        LEASED PROPERTIES        Contracted Services – The amount of contracted services under budget is due to decreased utility and janitorial costs  associated with COVID‐19 shut downs and vacant City facilities.     PARKS AND TRAILS        Personnel – The decrease in personnel costs from the prior year and budget is due to vacant positions.     Jail Services Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel ‐$                                ‐$                               ‐$                            ‐$                             ‐$                           0.0%‐$                          0.0% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 5,766,293            4,707,756           4,707,756       4,708,087         1,058,206        18.4%(331)                    0.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 5,766,293$         4,707,756$        4,707,756$    4,708,087$      1,058,206$     18.4%(331)$                 0.0% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Community Services Admin Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 339,177$             373,991$            373,991$         362,535$          (23,358)$            ‐6.9%11,456$           3.1% Supplies 6,531                      3,200                     3,200                  1,753                   4,778                  73.2% 1,447                 45.2% Contracted Services 70,106                   19,859                  19,859               12,076                58,030               82.8% 7,783                 39.2% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 142,940                123,869               123,869            121,876             21,064               14.7% 1,994                 1.6% Transfers Out 36,090                    ‐                                  ‐                              3,849                   32,241               89.3%(3,849)               100.0% Total Expenditures 594,844$             520,919$            520,919$         502,089$          92,755$            15.6% 18,830$           3.6% 2020 Prior Year YTD Variance Favorable (Unfavorable) YTD Budget Leased Properties Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 145,913                176,062               176,062            174,324             (28,411)$            ‐19.5%1,739$              1.0% Supplies 11,006                   2,440                     2,440                  2,172                   8,834                  80.3% 268                     11.0% Contracted Services 545,965                656,768               656,768            502,077             43,887               8.0% 154,691           23.6% Capital Outlay ‐                             ‐                            ‐                        27,188                (27,188)              100.0%(27,188)            100.0% Debt Service 175,000                175,000               175,000            175,000              ‐                              0.0%‐                             0.0% Internal Services 2,792                      2,816                     2,816                  2,816                   (24)                         ‐0.9%‐                             0.0% Transfers Out ‐                             ‐                            ‐                         ‐                          ‐                              0.0%‐                             0.0% Total Expenditures 880,676$             1,013,086$        1,013,086$    883,577$          (2,901)$               ‐0.3%129,510$        12.8% 2020 Prior Year YTD YTD Budget Variance Favorable (Unfavorable) Parks & Trails Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 3,107,941$         2,922,399$        2,922,399$    2,771,152$      336,789$         10.8% 151,247$        5.2% Supplies 202,526                207,834               207,834            161,980             40,545               20.0% 45,854              22.1% Contracted Services 701,965                707,451               707,451            679,537             22,428               3.2% 27,914              3.9% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 1,237,428            1,190,944           1,190,944       1,206,931         30,498               2.5%(15,986)             ‐1.3% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 5,249,860$         5,028,628$        5,028,628$    4,819,600$      430,260$         8.2% 209,028$        4.2% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 13 of 45   PARKS PLANNING AND NATURAL RESOURCES        Personnel – The increase in personnel costs over the prior year is due to filling a capital project coordinator position that was  vacant in 2019. The amount of personnel costs under budget is due to a remaining vacant capital project coordinator position.    Contracted Services – The increase in contracted services costs over the prior year is due to tree maintenance. The amount  of contracted services under budget is primarily due to cost savings associated with the contracted arborist ($52K) and  contracted landscape maintenance services ($60K).     RECREATION AND NEIGHBORHOODS        Personnel – The decrease in personnel costs from the prior year is the result of recreation facility closures related to COVID‐ 19. The amount of personnel costs under budget is due to open positions.     Supplies – The amount of supplies under budget is the result of recreation facility closures related to COVID‐19.     Contracted Services – The decrease in contracted services from the prior year is the result of recreation facility closures  related to COVID‐19.    Internal Services ‐ The decrease in internal services from the prior year is due to reductions made to Communications and  Facilities in response to COVID‐19.    HUMAN SERVICES        Contracted Services – The amount of contracted services under budget is primarily due to CDBG grant funded human service  agency payments not paid out. The unspent grant balance ($411K) will be included in the carry forward budget adjustment.   Parks Planning & Natural Resources Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 681,475$             1,249,203$        1,249,203$    963,718$          (282,242)$         ‐41.4%285,486$        22.9% Supplies 3,428                      4,827                     4,827                  5,169                   (1,740)                  ‐50.8% (342)                     ‐7.1% Contracted Services 789,900                1,207,061           1,207,061       1,077,077         (287,177)            ‐36.4%129,984           10.8% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 39,525                   45,488                  45,488               45,140                (5,615)                  ‐14.2%348                     0.8% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,514,329$         2,506,579$        2,506,579$    2,091,103$      (576,774)$         ‐38.1%415,476$        16.6% Variance Favorable (Unfavorable) YTD BudgetPrior Year YTD2020 Recreation & Neighborhoods Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 3,665,393$         2,734,261$        2,734,261$    2,497,211$      1,168,183$     31.9% 237,050$        8.7% Supplies 215,629                298,019               298,019            123,440             92,190               42.8% 174,579           58.6% Contracted Services 633,488                421,708               421,708            326,335             307,153            48.5% 95,373              22.6% Capital Outlay ‐                                   ‐                                  ‐                              4,541                   (4,541)                 100.0%(4,541)               100.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 1,821,113            1,447,735           1,447,735       1,424,444         396,669            21.8% 23,291              1.6% Transfers Out 96,517                   3,000                     3,000                   ‐                               96,517               100.0% 3,000                 100.0% Total Expenditures 6,432,140$         4,904,722$        4,904,722$    4,375,970$      2,056,170$     32.0% 528,752$        10.8% Variance Favorable (Unfavorable) Prior Year YTD2020 YTD Budget Human Services Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 577,938$             703,400$            703,400$         611,620$          (33,683)$            ‐5.8%91,779$           13.0% Supplies 14,029                   15,650                  15,650               8,254                   5,775                  41.2% 7,396                 47.3% Contracted Services 778,103                1,247,521           1,247,521       766,439             11,664               1.5% 481,082           38.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 108,659                89,123                  89,123               82,467                26,192               24.1% 6,656                 7.5% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,478,729$         2,055,693$        2,055,693$    1,468,780$      9,948$               0.7% 586,913$        28.6% Variance Favorable (Unfavorable) Prior Year YTD2020 YTD Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 14 of 45   MUSEUM        PUBLIC WORKS ADMIN        STREET MAINTENANCE        Personnel – The amount of personnel costs under budget is due to open positions.    Transfers Out – The decrease in transfers out is due to one‐time transfers in 2019 for the purchase of three new pieces of  equipment that were not repeated in 2020.    TRANSPORTATION        Personnel – The increase in salaries and benefits is due to COLAs and two vacant positions in 2019 that are filled in 2020. The  amount of personnel costs under budget is due to vacant positions during the year.    Museum Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 142,754$             134,675$            134,675$         133,733$          9,021$               6.3% 942$                  0.7% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 110,254                90,520                  90,520               87,324                22,930               20.8% 3,196                 3.5% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 253,008$             225,195$            225,195$         221,057$          31,951$            12.6% 4,138$              1.8% Variance Favorable (Unfavorable) Prior Year YTD2020 YTD Budget Public Works Admin Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 352,456$             374,676$            374,676$         304,599$          47,857$            13.6% 70,077$           18.7% Supplies 512                           800                          800                      1,488                   (976)                      ‐190.8% (688)                     ‐85.9% Contracted Services 1,920                      1,650                     1,650                  26,900                (24,980)               ‐1300.9% (25,250)             ‐1530.3% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 69,578                   67,769                  67,769               67,753                1,825                  2.6% 16                        0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 424,466$             444,895$            444,895$         400,739$          23,726$            5.6% 44,155$           9.9% 2020 Variance Favorable (Unfavorable) BudgetPrior Year Street Maintenance Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 2,830,844$         3,030,489$        3,030,489$    2,826,171$      4,673$               0.2% 204,318$        6.7% Supplies 343,470                279,798               279,798            361,614             (18,143)               ‐5.3% (81,816)             ‐29.2% Contracted Services 1,060,383            1,133,781           1,133,781       1,087,724         (27,341)               ‐2.6%46,057              4.1% Capital Outlay ‐                                  5,200                     5,200                   ‐                                ‐                              0.0% 5,200                 100.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 1,266,841            1,142,386           1,142,386       1,169,235         97,606               7.7%(26,849)             ‐2.4% Transfers Out 321,000                 ‐                                  ‐                              4,811                   316,189            98.5%(4,811)               100.0% Total Expenditures 5,822,538$         5,591,654$        5,591,654$    5,449,555$      372,984$         6.4% 142,100$        2.5% Prior Year YTD2020 YTD Budget Variance Favorable (Unfavorable) Transportation Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 4,112,698$         4,487,507$        4,487,507$    4,289,456$      (176,757)$         ‐4.3%198,052$        4.4% Supplies 253,161                223,252               223,252            224,584             28,577               11.3%(1,332)                ‐0.6% Contracted Services 885,576                945,974               945,974            838,912             46,664               5.3% 107,062           11.3% Capital Outlay ‐                                   ‐                                  ‐                              13,818                (13,818)              100.0%(13,818)            100.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 728,881                642,453               642,453            639,344             89,537               12.3% 3,110                 0.5% Transfers Out 2,180,237            760,000               760,000            762,959             1,417,278        65.0%(2,959)                ‐0.4% Total Expenditures 8,160,553$         7,059,187$        7,059,187$    6,769,072$      1,391,481$     17.1% 290,115$        4.1% Prior Year YTD2020 Variance Favorable (Unfavorable) YTD Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 15 of 45   Contracted Services – The amount of contracted services under budget is due to cost savings associated with electricity  charges for signals and streetlights ($98K) and employee ORCA card purchases under the Commute Trip Reduction (CTR)  program ($59K) as many employees are working from home due to the COVID‐19 pandemic. These cost savings are being  offset by higher than anticipated property loss repair costs ($62K) that have not yet been reimbursed by the insurance fund.    Transfers Out – The increase in transfers over the prior year is due to fuel tax previously recorded in the Arterial Street Fund  and transferred to the Capital Improvement Fund are now being recorded in and transferred from the General Fund.    NON‐DEPARTMENTAL AND OTHER        Personnel ‐ The amount of personnel expenditures under the prior year and budget is due to savings from expected employee  separation payments.     Contracted Services – The amount of contracted services under budget is due to a $1.8M contingency reserve that was set  aside for unanticipated costs related to the SCORE that were not utilized.     Transfers Out – Transfers Out have a net decrease from prior year primarily due to 1) a decrease in REET transfers ($2.2M),  2) a 2019 transfer to the Family First Center capital fund ($3.4M) that was not repeated in 2020, and 3) a decrease in the  amount of B&O tax transferred to the Transportation capital project fund ($670K).     Transfers between the General Fund and its management funds are just over $12.1M. In the past, these tax revenues were  allocated among the various management funds of the General Fund. Now, 100% of tax revenues are recognized in the  General Fund (000) with transfers to the Community Services Fund (001), the Street Fund (003), and the Museum Fund (005).  For budgetary purposes, the transfer in and transfer out amounts are reflected in the General Fund revenues and  expenditures. Transfers between the General Fund and its management funds are eliminated for reporting in the City’s  Comprehensive Annual Financial Report (CAFR).   Non‐Departmental and Other Summary of Uses 2019 Year to Date through December YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 2,821,737$         2,407,200$        2,407,200$    2,142,073$      679,664$         24.1% 265,127$        11.0% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 176,710                1,979,919           1,979,919       163,145             13,566               7.7% 1,816,774      91.8% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 15,830                   18,828                  18,828               18,828                (2,998)                  ‐18.9%‐                             0.0% Transfers Out 27,343,337         21,083,979        21,083,979    21,083,979      6,259,358        22.9%‐                             0.0% Total Expenditures 30,357,614$      25,489,926$     25,489,926$ 23,408,024$   6,949,590$     22.9% 2,081,901$   8.2% Prior Year YTD2020 Variance Favorable (Unfavorable) YTD Budget Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 16 of 45   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.        Principal and Interest – The increase in principal and interest payments is due to the 2019 Parks and LRF bonds.    Transfers In – The decrease in transfers in is due to using excess fund balance for debt service payments rather than  transferring in additional funds.         2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 63,526$                56,930$                  57,888$         (5,638)$         958$                101.68% Charges for services 372,059                386,827                  386,828         14,769          1                       100.00% Investment Earnings 62,171                    ‐                                48,906           (13,265)         48,906            N/A TOTAL REVENUES 497,756                443,757                  493,622         (4,134)           49,865            111.24% EXPENDITURES: Principal 5,167,947             5,405,922               5,405,922      (237,975)       ‐                        100.00% Interest 1,646,927             1,756,464               1,783,753      (136,826)      (27,289)           101.55% TOTAL EXPENDITURES 6,814,874             7,162,386               7,189,675      (374,801)      (27,289)           100.38% TRANSFERS IN 8,009,403             7,707,227               7,707,225      (302,178)      (2)                     100.00% NET TRANSFERS 8,009,403             6,817,424               7,707,225      (302,178)      889,801          113.05% CHANGE IN FUND BALANCE 1,692,285             98,795                    1,011,172      (681,113)      912,377          1023.51% BEGINNING FUND BALANCE, Jan 1 2,307,173             3,999,457               3,999,457      1,692,284     ‐                        100.00% ENDING FUND BALANCE, Dec 31 3,999,458$           4,098,252$            5,010,629$   1,011,171$  912,377$        122.26% VARIANCE FAVORABLE (UNFAVORABLE) GENERAL GOVERNMENTAL MISCELLANEOUS DEBT Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 17 of 45   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.        Taxes – The decrease in taxes from the prior year is due to COVID‐19 resulting in less people travelling.    Contracted Services – The amount of contracted services under budget is due to the cancellation of events that had been  approved for funding by the Lodging Tax Advisory Committee due to COVID‐19.        2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 531,587$              200,000$                233,846$              (297,741)$             33,846$                116.92% Contributions 24,000                   25,000                     30,000                   6,000                     5,000                     120.00% Investment Earnings 12,067                    ‐                                8,888                     (3,179)                    8,888                     N/A TOTAL REVENUES 567,654                225,000                   272,734                (294,920)               47,734                   121.22% EXPENDITURES: Contracted Services 346,154                416,562                   285,519                60,635                   131,043                68.54% TOTAL EXPENDITURES 346,154                416,562                   285,519                60,635                   131,043                68.54% TRANSFERS OUT ‐                              37,500                     37,500                   37,500                    ‐                              100.00% NET TRANSFERS ‐                              (37,500)                    (37,500)                 (37,500)                  ‐                              N/A CHANGE IN FUND BALANCE 221,500                (229,062)                 (50,285)                 (271,785)               178,777                21.95% BEGINNING FUND BALANCE, Jan 1 722,387                943,889                   943,889                221,502                 ‐                              130.66% ENDING FUND BALANCE, Dec 31 943,887$              714,827$                893,604$              (50,283)$               178,777$              94.67% VARIANCE FAVORABLE (UNFAVORABLE) HOTEL/MOTEL Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 18 of 45   Municipal Art Fund  The Municipal Art Fund was established to account for the activities of the Renton Municipal Arts Commission, as outlined in  Renton Municipal Code (RMC) section 2‐8‐7. Expenditures include grants paid to local artists, organizations, and community  groups for arts and culture projects and events that serve the general public in Renton and payments for Public Art capital  projects located throughout the City.         Contracted Services – In the past, the operational budget of the Renton Municipal Arts Commission (RMAC) was included in  the Economic Development budget within the General Fund and the capital budget was reported in the Municipal Art Fund.  In 2020 the operational budget of the RMAC was combined with the capital budget in the Municipal Art fund. The increase  in contracted services in the Municipal Art fund is the result of this change in reporting.    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.      2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 1,233$                    ‐$                              1,336$                   103$                      1,336$                   N/A TOTAL REVENUES 1,233                      ‐                                1,336                     103                        1,336                     N/A EXPENDITURES: Supplies ‐                              200                          506                        (506)                       (306)                       253.00% Contracted Services ‐                              183,460                  142,225                (142,225)               41,235                   77.52% Capital Outlay 123,813                88,130                     73,130                   50,683                   15,000                   82.98% TOTAL EXPENDITURES 123,813                271,790                  215,861                (92,048)                 55,929                   79.42% TRANSFERS IN 102,000                180,660                  180,660                78,660                   (0)                            100.00% NET TRANSFERS 102,000                180,660                  180,660                78,660                    ‐                              100.00% CHANGE IN FUND BALANCE (20,580)                 (91,130)                   (33,865)                 (13,285)                 57,265                   37.16% BEGINNING FUND BALANCE, Jan 1 119,446                98,865                     98,865                   (20,581)                  ‐                              100.00% ENDING FUND BALANCE, Dec 31 98,866$                7,735$                     65,000$                (33,866)$               57,265$                840.34% MUNICIPAL ART VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 40,000$                 ‐$                                ‐$                            (40,000)$                ‐$                            N/A Licenses and permits 85,177                   57,674                      80,143                   (5,034)                    22,469                   138.96% Investment Earnings 8,288                      ‐                                  5,762                     (2,526)                    5,762                     N/A TOTAL REVENUES 133,465                57,674                      85,905                   (47,560)                 28,231                   148.95% EXPENDITURES: Personnel 9,314                      ‐                                   ‐                              (9,314)                     ‐                              N/A Supplies 304                        6,302                          ‐                              (304)                       6,302                     0.00% Contracted Services 49,247                   51,372                      51,955                   2,708                     (583)                       101.13% Capital Outlay ‐                              40,000                       ‐                               ‐                              40,000                   0.00% TOTAL EXPENDITURES 58,865                   97,674                      51,955                   (6,910)                    45,719                   53.19% TRANSFERS IN ‐                              40,000                      40,000                   40,000                    ‐                              100.00% NET TRANSFERS ‐                              40,000                      40,000                   40,000                    ‐                              100.00% CHANGE IN FUND BALANCE 74,600                    ‐                                  73,950                   (650)                       73,950                   N/A BEGINNING FUND BALANCE, Jan 1 529,159                603,760                    603,760                74,601                    ‐                              100.00% ENDING FUND BALANCE, Dec 31 603,759$              603,760$                  677,710$              73,951$                73,950$                112.25% CABLE COMMUNICATIONS VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 19 of 45   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 to third parties and  to the City’s internal departments.         Police Seizure Fund  The Police Seizure Fund was established in 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.        Contributions – Contributions reflect the value of assets seized during the year. These seizures are variable each year and,  therefore, are not budgeted.     Supplies – Annually, the beginning balance of seizure funds is appropriated to the supplies expenditure account in order to  give Police the budget authority to spend the seizure funds as items qualifying for use of the funds are identified throughout  the year.     Transfers In – Transfers in represents the balance of seizure funds that were previously held in the General Fund that were  transferred in with the establishment of the special revenue fund in 2020.   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 4,763$                    ‐$                               3,169$                   (1,594)$                 3,169$                   N/A TOTAL REVENUES 4,763                      ‐                                 3,169                     (1,594)                    3,169                     N/A TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                                  ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 4,763                      ‐                                 3,169                     (1,594)                    3,169                     N/A BEGINNING FUND BALANCE, Jan 1 340,895                345,658                   345,658                4,763                      ‐                              100.00% ENDING FUND BALANCE, Dec 31 345,658$              345,658$                 348,827$              3,169$                   3,169$                   100.92% SPRINGBROOK WETLANDS VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Contributions ‐$                             ‐$                               323,507$              323,507$              323,507$              N/A Investment Earnings ‐                               ‐                                 5,628                     5,628                     5,628                     N/A TOTAL REVENUES ‐                               ‐                                 329,135                329,135                329,135                N/A EXPENDITURES: Supplies ‐                              711,102                   88,510                   88,510                   (622,591)               12.45% Contracted Services ‐                               ‐                                 58,392                   58,392                   58,392                   N/A Capital Outlay ‐                               ‐                                 20,886                   20,886                   20,886                   N/A TOTAL EXPENDITURES ‐                              711,102                   167,788                167,788                543,314                23.60% TRANSFERS IN ‐                              711,102                   711,102                711,102                 ‐                              100.00% NET TRANSFERS ‐                              711,102                   711,102                711,102                 ‐                              100.00% CHANGE IN FUND BALANCE ‐                               ‐                                 872,449                872,449                872,449                N/A BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Dec 31 ‐$                             ‐$                               872,449$              872,449$              872,449$              N/A POLICE SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 20 of 45   Police CSAM Seizure Fund  The Police CSAM Seizure Fund was established in 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.        Transfers In – Transfers in represents the balance of CSAM seizure funds that were previously held in the General Fund that  were transferred in with the establishment of the special revenue fund in 2020.   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Fines and penalties ‐$                             ‐$                               21,799$                21,799$                21,799$                N/A Investment Earnings ‐                               ‐                                 4,328                     4,328                     4,328                     N/A TOTAL REVENUES ‐                               ‐                                 26,127                   26,127                   26,127                   N/A Contracted Services ‐                               ‐                                 1,501                     1,501                     1,501                     N/A TOTAL EXPENDITURES ‐                               ‐                                 1,501                     1,501                     (1,501)                    N/A TRANSFERS IN ‐                              126,011                   126,011                126,011                 ‐                              100.00% NET TRANSFERS ‐                              126,011                   126,011                126,011                 ‐                              100.00% CHANGE IN FUND BALANCE ‐                              126,011                   150,637                150,637                24,626                   119.54% BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Dec 31 ‐$                            126,011$                 150,637$              150,637$              24,626$                119.54% POLICE CSAM SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 21 of 45   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.        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.         2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 469,290$              86,500$                  495,647$              26,357$                409,147$              573.00% Investment Earnings 39,453                    ‐                                18,232                   (21,221)                 18,232                   N/A TOTAL REVENUES 508,743                86,500                     513,879                5,136                     427,379                594.08% TOTAL EXPENDITURES ‐                               ‐                                 ‐                               ‐                               ‐                              N/A TRANSFERS OUT 1,200,000             945,909                  601,795                (598,205)               344,114                63.62% NET TRANSFERS (1,200,000)            (945,909)                 (601,795)               598,205                344,114                63.62% CHANGE IN FUND BALANCE (691,257)               (859,409)                 (87,916)                 603,341                771,493                10.23% BEGINNING FUND BALANCE, Jan 1 2,578,256             1,886,999               1,886,999             (691,257)                ‐                              100.00% Prior Period Adjustment ‐                               ‐                                (85,250)                 (85,250)                 (85,250)                 N/A BEGINNING FUND BALANCE, Jan 1 (restated) 2,578,256             1,886,999               1,801,749             (776,507)               (85,250)                 95.48% ENDING FUND BALANCE, Dec 31 1,886,999$           1,027,590$             1,713,833$           (173,166)$             686,243$              166.78% COMMUNITY SERVICES IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 1,875,489$           1,435,875$              1,989,329$           113,840$              553,454$              138.54% Investment Earnings 58,530                    ‐                                 35,268                   (23,262)                 35,268                   N/A TOTAL REVENUES 1,934,019             1,435,875                2,024,597             90,578                   588,722                141.00% TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS OUT 2,324,200             1,811,987                1,811,987             (512,213)               0                             100.00% NET TRANSFERS (2,324,200)            (1,811,987)               (1,811,987)            512,213                 ‐                              100.00% CHANGE IN FUND BALANCE (390,181)               (376,112)                  212,610                602,791                588,722                 ‐56.53% BEGINNING FUND BALANCE, Jan 1 3,332,524             2,942,344                2,942,344             (390,180)                ‐                              100.00% ENDING FUND BALANCE, Dec 31 2,942,343$           2,566,232$              3,154,954$           212,611$              588,722$              122.94% TRANSPORTATION IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 22 of 45   REET 1 Fund  This fund accounts 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.        REET 2 Fund  This fund accounts 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.         2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes ‐$                            2,000,000$              3,303,490$           3,303,490$           1,303,490$           165.17% Investment Earnings ‐                               ‐                                 15,924                   15,924                   15,924                   N/A TOTAL REVENUES ‐                              2,000,000                3,319,414             3,319,414             1,319,414             165.97% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS IN ‐                              1,143,855                1,143,855             1,143,855              ‐                              100.00% TRANSFERS OUT ‐                              2,421,000                2,421,000             2,421,000              ‐                              100.00% NET TRANSFERS ‐                              (1,277,145)               (1,277,145)            (1,277,145)             ‐                              100.00% CHANGE IN FUND BALANCE ‐                              722,855                    2,042,269             2,042,269             1,319,414             282.53% BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Dec 31 ‐$                            722,855$                 2,042,269$           2,042,269$           1,319,414$           282.53% REET 1 VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes ‐$                            2,000,000$              3,303,490$           3,303,490$           1,303,490$           165.17% Investment Earnings ‐                               ‐                                 15,924                   15,924                   15,924                   N/A TOTAL REVENUES ‐                              2,000,000                3,319,414             3,319,414             1,319,414             165.97% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS IN ‐                              1,143,855                1,143,855             1,143,855             (0)                            100.00% TRANSFERS OUT ‐                              1,692,404                1,051,404             1,051,404             641,000                62.12% NET TRANSFERS ‐                              (548,549)                  92,451                   92,451                   641,000                 ‐16.85% CHANGE IN FUND BALANCE ‐                              1,451,451                3,411,865             3,411,865             1,960,414             235.07% BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Dec 31 ‐$                            1,451,451$              3,411,865$           3,411,865$           1,960,414$           235.07% REET 2 VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 23 of 45   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.        A listing of project budgets and balances at December 31 is provided on the following page. 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.      2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 731,955$              3,820,752$            3,073,037$           2,341,082$           (747,715)$             80.43% Charges for services 10,643                    ‐                               4,140                     (6,503)                    4,140                     N/A Sale of general fixed assets 180,000                560,000                 560,000                380,000                 ‐                              100.00% Contributions 288,462                11,000                     ‐                              (288,462)               (11,000)                 0.00% Investment Earnings 412,656                175,910                 226,519                (186,137)               50,609                   128.77% TOTAL REVENUES 1,628,056             4,567,662              3,863,696             2,235,640             (703,966)               84.59% EXPENDITURES: Personnel 438,323                746,459                 482,930                44,607                   263,529                64.70% Supplies 126,551                878,203                 871,118                744,567                7,085                     99.19% Contracted Services 277,606                742,280                 564,939                287,333                177,341                76.11% Capital Outlay 9,718,976             27,542,441            7,107,728             (2,611,248)            20,434,713           25.81% TOTAL EXPENDITURES 10,561,456           29,909,383            9,026,715             (1,534,741)            20,882,668           30.18% TRANSFERS IN 2,077,000             2,774,909              1,789,795             (287,205)               (985,114)               64.50% TRANSFERS OUT 1,924,971             2,723,680              2,723,680             798,709                 ‐                              100.00% NET TRANSFERS 152,029                51,229                    (933,885)               (1,085,914)            (985,114)                ‐1822.96% CHANGE IN FUND BALANCE (8,781,371)            (25,290,492)          (6,096,904)            2,684,467             19,193,588           24.11% BEGINNING FUND BALANCE, Jan 1 20,675,238           26,395,567            26,395,567           5,720,329              ‐                              100.00% ENDING FUND BALANCE, Dec 31 11,893,867$        1,105,075$            20,298,663$        8,404,796$           19,193,588$        1836.86% MUNICIPAL FACILITIES CIP VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 24 of 45   Municipal Facilities CIP Fund (continued)             PROJECT BUDGET ACTUAL BALANCE CAPITAL PROJECT COORDINATORS 746,459$ 482,930$ 263,529$ SALE OF PARK LAND COSTS 10,000 10,000 - SUNSET NEIGHBORHOOD PARK ART 224,100 137,244 86,856 CITY HALL ELEVATORS 2,079,704 409,436 1,670,268 CITY WIDE SECURITY SYSTEM UPGRADES 340,055 77,973 262,082 COMM SVCS MAINT SHOPS REHAB 299,946 - 299,946 SIGN SHOP IMPROVEMENTS 37,719 34,895 2,824 FIRE STATION 15 957,962 866,131 91,831 CITY HALL MAJOR HVAC AND FIRE COMP REPL 1,796,262 53,159 1,743,103 4TH FLOOR REMODEL AND POLICE TRAINING CENTER 210,371 415,046 (204,675) BOATHOUSE 323,248 308,485 14,763 HENRY MOSES AQUATIC CENTER 88,644 - 88,644 PARKS RECREATION AND OPEN SPACE PLAN 8,730 8,730 - REGIS PARK ATHLETIC FIELD EXPANSION 32,161 32,161 - SPORT COURT IMPROVEMENTS 150,000 - 150,000 PARKING LOT AND DRIVEWAY REPAIRS 90,000 - 90,000 IRRIGATION AUTOMATION & CONSERVATION 12,072 4,987 7,085 URBAN FORESTRY PROGRAM 106,044 6,836 99,208 PARKS MM - PLAYGRDS, KIOSKS & INT SIGNS 665,640 589,853 75,787 PARKS MM - SHORELINE AND BANK STABILIZAT 182,500 - 182,500 PARKS MM - STRUCTURAL REVIEWS & REPAIRS 632,506 549,460 83,046 SUNSET EIS PARK 3,907,344 3,727,418 179,926 COULON PARK STRUCTURAL IMPROVEMENTS 1,038 4,595 (3,557) COULON PARK TURF REPLACEMENT 25,788 - 25,788 COULON SWIM BEACH 250,000 - 250,000 LIBERTY PARK IMPROVEMENTS 525,852 - 525,852 TRANSPORTATION LANDSCAPE 90,000 - 90,000 PHILIP ARNOLD PARK IMPROVEMENTS 6,105,000 153,867 5,951,133 COULON - ROSEWALL 7,775 17,645 (9,870) KIWANIS PARK 5,325,388 227,434 5,097,954 COULON - WATERWALK 2,471,415 142,195 2,329,220 COULON - TRESTLE BRIDGE 1,594,296 164,440 1,429,856 FAWCETT PROPERTY PURCHASE ROFR 611,364 601,795 9,569 TOTAL PROJECT BALANCES 29,909,383$ 9,026,715$ 20,882,668$ MUNICIPAL FACILITIES CIP PROJECT BUDGETS AT DECEMBER 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 25 of 45   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.    2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 2,292,238$           28,444,058$        2,439,149$           146,911$              (26,004,909)$       8.58% Charges for services ‐                              250,000                250,000                250,000                 ‐                              100.00% Fines and penalties 55,788                   7,200                     23,482                   (32,306)                 16,282                   326.14% Contributions 238,518                 ‐                               ‐                              (238,518)                ‐                              N/A Investment Earnings 148,433                70,000                   163,069                14,636                   93,069                   232.96% TOTAL REVENUES 2,734,977             28,771,258           2,875,700             140,723                (25,895,558)         10.00% EXPENDITURES: Personnel 119,458                56,000                   104,094                (15,364)                 (48,094)                 185.88% Supplies 44,903                    ‐                              155,655                110,752                (155,655)               N/A Contracted Services 184,819                 ‐                              154,324                (30,495)                 (154,324)               N/A Capital Outlay 6,036,639             51,555,373           8,522,976             2,486,337             43,032,397           16.53% TOTAL EXPENDITURES 6,385,819             51,611,373           8,937,049             2,551,230             42,674,324           17.32% TRANSFERS IN 8,479,757             3,963,609             3,905,909             (4,573,848)            (57,700)                 98.54% NET TRANSFERS 8,413,257             3,963,609             3,905,909             (4,507,348)            (57,700)                 98.54% CHANGE IN FUND BALANCE 4,762,415             (18,876,506)         (2,155,440)            (6,917,855)            16,721,066           N/A BEGINNING FUND BALANCE, Jan 1 5,492,313             18,947,853           18,947,853           13,455,540            ‐                              100.00% ENDING FUND BALANCE, Dec 31 10,254,728$        71,347$                16,792,413$        6,537,685$           16,721,066$        23536.26% CAPITAL IMPROVEMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 26 of 45   Capital Improvement Fund (continued)         PROJECT BUDGET ACTUAL BALANCE WALKWAY PGM 217,096$ -$ 217,096$ NE 31ST ST CULVERT 12,228 - 12,228 ARTERIAL CIRCULATION PGM 100,000 55,436 44,564 BRIDGE INSPECTION & REPAIR 236,916 41,007 195,909 ROADWAY SAFETY & GUARDRAIL 54,407 - 54,407 CATCH BASIN REPAIR 250,000 - 250,000 I-405/44TH GATEWAY SIGNAGE 57,700 - 57,700 RENTON CONNECTOR 1,593,294 11,594 1,581,700 STREET OVERLAY PGM 1,705,830 239,929 1,465,901 TRAFFIC SAFETY PGM 260,507 202,699 57,808 PROJ DEV & PRE-DESIGN 116,940 40,207 76,733 SO 7TH ST 135,000 - 135,000 ITS PGM 159,891 133,763 26,128 RENTON AVE EXT PRES 778,082 289,162 488,920 SW GRADY WAY PRES 7,603 12,274 (4,671) DUVALL AVE NE PRES - (2,209) 2,209 PARK AVE EXTENSION 7,712,602 290,675 7,421,927 RAINIER AVE S/N PHASE 4 5,689,029 1,120,266 4,568,763 INTERSECT SAFETY & MOBILITY 386,934 111,324 275,610 NE 31ST ST BRIDGE REPLACEMENT 251,030 2,984 248,046 N 27TH PL CULVERT SCOUR REPAIR 71,719 5,097 66,622 DUVALL AVE 7TH TO SUNSET 6,910,089 410,566 6,499,523 BARRIER FREE 85,000 6,117 78,883 SIDEWALK REHAB 100,000 - 100,000 LAKE WASHINGTON LOOP TRAIL 1,099,156 93,051 1,006,105 HIGHLANDS TO LANDING 533,310 110,820 422,490 SUNSET BLVD CORRIDOR 4,639,769 218,715 4,421,054 PRES OF TOD 245,001 171,505 73,496 WILLIAMS AVE S & WELLS AVE S CONV 10,385,423 3,890,350 6,495,073 ARTERIAL REHAB - SW 43RD 1,125,000 80,040 1,044,960 BRONSON BRIDGE 611,235 147,469 463,766 HOUSER WAY N BRIDGE 590,985 79,988 510,997 WILLIAMS BRIDGE 713,535 63,543 649,992 NILE BRIDGE 50,000 - 50,000 S 2ND STREET CONVERSION 1,540,750 5,256 1,535,494 HOUSER WAY INT & PED IMP 814,625 84,160 730,465 RENTON SCHOOL CROSSINGS 870,687 199,853 670,834 SAFE ROUTES TO TRANSIT 1,500,000 821,408 678,592 TOTAL PROJECT BALANCES 51,611,373$ 8,937,049$ 42,674,324$ CAPITAL IMPROVEMENT PROJECT BUDGETS AT DECEMBER 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 27 of 45   Housing Opportunity Fund  This fund was historically used to account for the Economic Development Reserve and Housing Opportunity Grants. After a  review of the fund, it was determined that the use of the fund did not qualify as a capital project fund under Generally  Accepted Accounting Principles (GAAP) and the fund has been closed. The fund balance was transferred to a management  fund of the General Fund where the fund balance will remain intact until authorized by Council to be spent.        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. Closure of the fund and a transfer  of the remaining fund balance will be proposed with the 1st quarter 2021 budget adjustment.       2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 37,284$                6,309$                   6,309$                   (30,975)$                ‐$                            100.00% TOTAL REVENUES 37,284                   6,309                     6,309                     (30,975)                  ‐                              100.00% EXPENDITURES: Contracted Services 49,139                    ‐                               ‐                              (49,139)                  ‐                              N/A TOTAL EXPENDITURES 49,139                    ‐                               ‐                              (49,139)                  ‐                              N/A TRANSFERS OUT ‐                              2,576,659             2,576,659             (2,576,659)             ‐                              100.00% NET TRANSFERS ‐                              (2,576,659)            (2,576,659)            2,576,659              ‐                              N/A CHANGE IN FUND BALANCE (11,855)                 (2,570,350)            (2,570,350)            2,594,823              ‐                              N/A BEGINNING FUND BALANCE, Jan 1 2,582,203             2,570,350             2,570,350             (11,853)                  ‐                              100.00% ENDING FUND BALANCE, Dec 31 2,570,348$            ‐$                             ‐$                            2,582,970$            ‐$                            N/A HOUSING OPPORTUNITY VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 5,408$                    ‐$                            271$                      (5,137)$                 271$                      N/A TOTAL REVENUES 5,408                      ‐                              271                        (5,137)                    271                        N/A TOTAL EXPENDITURES ‐                               ‐                               ‐                               ‐                               ‐                              N/A NET TRANSFERS (445,591)                ‐                               ‐                              445,591                 ‐                              N/A CHANGE IN FUND BALANCE (440,183)                ‐                              271                        440,454                271                        N/A BEGINNING FUND BALANCE, Jan 1 456,591                16,408                   16,408                   (440,183)                ‐                              100.00% ENDING FUND BALANCE, Dec 31 16,408$                16,408$                16,679$                271$                      271$                      101.65% NEW LIBRARY DEVELOPMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 28 of 45   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.        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.        2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental ‐$                            75,000$                 ‐$                             ‐$                            (75,000)$               0.00% Contributions 37,495                    ‐                              4,920                     (32,575)                 4,920                     N/A Investment Earnings 60,791                    ‐                              76,555                   15,764                   76,555                   N/A TOTAL REVENUES 98,286                   75,000                   81,475                   (16,811)                 6,475                     108.63% EXPENDITURES: Capital Outlay 696,113                648,948                276,173                (419,940)               372,775                42.56% TOTAL EXPENDITURES 740,691                648,948                276,173                (464,518)               372,775                42.56% NET TRANSFERS 5,000,000              ‐                               ‐                              (5,000,000)             ‐                              N/A CHANGE IN FUND BALANCE 4,357,595             (573,948)               (194,698)               (4,552,293)            379,250                N/A BEGINNING FUND BALANCE, Jan 1 4,193,806             8,551,401             8,551,401             4,357,595              ‐                              100.00% ENDING FUND BALANCE, Dec 31 8,551,401$           7,977,453$           8,356,703$           (194,698)$             379,250$              104.75% FAMILY FIRST CENTER VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 29 of 45   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.         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. The decrease in grant revenues in 2020  corresponds to the decrease in expenses related to the Airport Master Plan Update.    Charges for Services – Charges for services represents fuel charges and service fees. There has been a decrease in utilization  of Airport services by customers related to shutdown of aviation manufacturing due to the pandemic and other economic  factors in and around the airport.    Personnel – The decrease in personnel costs from the prior year and the amount under budget is due to open positions.    Contracted Services – The decrease in contracted services from the prior year and amounts under budget are related to the  Airport Master Plan Update project. Expenses for this project are declining as the project is nearing completion.     Capital Outlay ‐ A listing of project budgets and balances at December 31 is provided on the following page.   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 198,148$          ‐$                             69,000$           (129,148)$        69,000$           N/A Charges for services 291,026           145,557                  84,735              (206,291)          (60,822)            58.21% Rents, leases, and misc fees 2,876,245        2,902,353               2,955,121        78,876              52,768              101.82% Interest and other misc 92,292              3,857                       102,476           10,184              98,619              2656.88% TOTAL REVENUES 3,458,328        3,051,767               3,211,332        (246,996)          159,565           105.23% EXPENSES: Personnel 1,084,126        1,109,685               885,042           199,084           224,643           79.76% Supplies 54,659              43,500                    37,409              17,250              6,091                86.00% Contracted Services 555,786           491,088                  389,434           166,352           101,654           79.30% Internal Services 318,121           310,765                  314,510           3,611                (3,745)               101.21% TOTAL OPERATING EXPENSES 2,012,692        1,955,038               1,626,395        386,297           328,643           83.19% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,445,636        1,096,729               1,584,937        139,301           488,208           144.51% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 213,110           5,944,832               284,571           (71,461)            5,660,261        4.79% TRANSFERS OUT 6,000                 ‐                                1,363                4,637                (1,363)               N/A NET TRANSFERS 41,500               ‐                                (1,363)               (42,863)            (1,363)               N/A CHANGE IN FUND BALANCE 1,274,026        (4,848,103)             1,299,003        24,977              6,147,106        N/A BEGINNING FUND BALANCE, Jan 1 4,985,377        6,259,402               6,259,402        1,274,025         ‐                         100.00% ENDING FUND BALANCE, Dec 31 6,259,403$      1,411,299$            7,558,405$      1,299,002$      6,147,106$      535.56% VARIANCE AIRPORT Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 30 of 45   Airport Fund (continued)        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. COVID‐19 resulted in the cancellation of events in 2020.     Charges for services ‐ The increase in charges for services over the prior year is due to increased rates. The majority of the  increase is coming from commercial and multi‐family steel collections. The large amount over budget is due to the revenue  budget not being adjusted for the rate increase.    PROJECT BUDGET ACTUAL BALANCE MAINTENANCE DREDGING & SHORELINE MITIGAT 67,000$ -$ 67,000$ AIRPORT OFFICE REHAB 2,763,289 44,973 2,718,316 MAJOR FACILITY MAINTENANCE 357,263 156,128 201,135 SURFACE WATER SYSTEM REHABILITATION 44,496 - 44,496 PAVEMENT MANAGEMENT PROGRAM 255,930 - 255,930 SNOW REMOVAL EQUIPMENT 167,000 - 167,000 MASTER PLAN UPDATE 103,850 77,573 26,277 TAXIWAY ALPHA REHABILITATION 1,115,495 - 1,115,495 RUNWAY SAFETY AREA 774,359 - 774,359 ENVIRONMENTAL IMPACT STUDY 400,000 - 400,000 TOTAL PROJECT BALANCES 6,048,682$ 278,674$ 5,770,008$ Non-capital items included in project budgets (103,850) (24,753) (79,097) Operating fund equipment purchase - 30,650 (30,650) TOTAL CAPITAL OUTLAY 5,944,832$ 284,571$ 5,660,261$ AIRPORT PROJECT BALANCES AT DECEMBER 31, 2020 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 167,153$         268,631$                89,664$           (77,489)$          (178,967)$        33.38% Charges for services 20,314,470      19,343,186            20,593,831      279,361           1,250,645        106.47% Interest and other misc 35,550              5,000                       26,266              (9,284)               21,266              525.32% TOTAL REVENUES 20,517,173      19,616,817            20,709,761      192,588           1,092,944        105.57% EXPENSES: Personnel 582,687           579,726                  545,060           37,627              34,666              94.02% Supplies 11,212              10,171                    5,641                5,571                4,530                55.46% Contracted Services 19,456,995      18,338,705            19,200,912      256,083           (862,207)          104.70% Internal Services 476,485           438,482                  452,430           24,055              (13,948)            103.18% TOTAL OPERATING EXPENSES 20,527,379      19,367,084            20,204,043      323,336           (836,959)          104.32% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (10,206)            249,733                  505,718           515,924           255,985           202.50% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TRANSFERS OUT ‐                          ‐                                284                   (284)                  (284)                  N/A NET TRANSFERS ‐                          ‐                                (284)                  (284)                  (284)                  N/A CHANGE IN FUND BALANCE (10,206)            249,733                  505,434           515,640           255,701           202.39% BEGINNING FUND BALANCE, Jan 1 2,276,333        2,266,127               2,266,127        (10,206)             ‐                         100.00% ENDING FUND BALANCE, Dec 31 2,266,127$      2,515,860$            2,771,561$      505,434$         255,701$         110.16% SOLID WASTE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 31 of 45   Solid Waste Fund (continued)     Contracted Services ‐ The decrease increase in contracted services expense from the prior year is primarily due to decreased  dump fees ($396K), which are being offset by increased payments to the garbage contractor ($108K). The decreased dump  fees directly relate to a decrease in the amount of garbage disposed of with King County, the rates per ton did not change  from 2019. The increase in payments to the garbage contractor directly relates to the increased billing rates, as noted above.    Capital Outlay ‐ The Solid Waste Fund does not have a capital fund.    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 – The decrease in rents, leases, and misc fees from the prior year is due to COVID‐19. Rent for  the Golf Course’s restaurant tenant is based on a percentage of restaurant and banquet sales which have declined significantly  due to COVID‐19 restrictions.    Capital Outlay ‐ The Golf Course has $20K budgeted for capital in 2020. This budget is for equipment purchases in the  operating fund and is not related to a capital project.        2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 1,954,194$      2,294,800$            2,270,554$      316,360$         (24,246)$          98.94% Rents, leases, and misc fees 456,998           500,750                  320,034           (136,964)          (180,716)          63.91% Interest and other misc 8,068                1,370                       4,950                (3,118)               3,580                361.31% TOTAL REVENUES 2,419,260        2,796,920               2,595,538        176,278           (201,382)          92.80% EXPENSES: Personnel 1,500,987        1,512,192               1,434,588        66,399              77,604              94.87% Supplies 346,608           321,500                  290,986           55,622              30,514              90.51% Contracted Services 239,454           205,050                  223,568           15,886              (18,518)            109.03% Internal Services 251,690           341,940                  340,704           (89,014)            1,236                99.64% TOTAL OPERATING EXPENSES 2,338,739        2,380,682               2,289,846        48,893              90,836              96.18% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 80,521              416,238                  305,692           225,171           (110,546)          73.44% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 14,140              20,000                     ‐                         14,140              20,000              0.00% TRANSFERS IN 72,000              76,000                    76,000              4,000                 ‐                         100.00% TRANSFERS OUT 75,443              76,000                    78,695              (3,252)               (2,695)               103.55% NET TRANSFERS (3,443)                ‐                                (2,695)               748                   (2,695)               N/A CHANGE IN FUND BALANCE 62,938              396,238                  302,997           240,059           (93,241)            76.47% BEGINNING FUND BALANCE, Jan 1 110,812           173,750                  173,750           62,938               ‐                         100.00% ENDING FUND BALANCE, Dec 31 173,750$         569,988$                476,747$         302,997$         (93,241)$          83.64% GOLF COURSE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 32 of 45   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 – Water charges decreased from the prior year due to COVID‐19. Utility revenues are recognized when  received for budgetary purposes. While consumption changes between commercial and residential properties have resulted  in a net increase of $30K in amounts billed, receipts associated with these billings decreased $233K over the same period in  2019. A moratorium on disconnections for non‐payment has been in effect since March and was recently extended into spring  2021. The decrease in customer account collections is being offset by an increase of $68K in interfund charges to CIP projects.  The amount of charges for services under budget is due to revenue budget being overestimated. The revenue budget has  been reduced for the 2021/2022 budget.    Rents, leases, and misc fees – The amount of rents, leases, and misc. fees over the budget is due to the rent revenue budget  not being adjusted for scheduled increases in rental rates associated with cell tower leases that are situated on water utility  property.    Interest and other misc – Interest revenues have exceeded the annual budget as these revenues are budgeted conservatively  in anticipation of market volatility.     Personnel – Personnel costs under budget are due to open positions.    Supplies – Supplies decreased from the prior year as cost cutting measures were taken during the year in response to COVID‐ 19.  2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 17,394,961$   19,180,991$          17,248,806$   (146,155)$        (1,932,185)$    89.93% Fines and penalties ‐                          ‐                                5,600                5,600                5,600                N/A Rents, leases, and misc fees 206,731           136,591                  281,084           74,353              144,493           205.79% Interest and other misc 980,115           199,070                  891,399           (88,716)            692,329           447.78% TOTAL REVENUES 18,581,807      19,516,652            18,426,889      (154,918)          (1,089,763)       94.42% EXPENSES: Personnel 4,318,871        4,640,953               4,292,439        26,432              348,514           92.49% Supplies 959,046           833,418                  819,726           139,320           13,692              98.36% Contracted Services 3,217,930        3,193,299               3,137,994        79,936              55,305              98.27% Internal Services 2,219,647        2,185,563               2,068,882        150,765           116,681           94.66% TOTAL OPERATING EXPENSES 10,715,494      10,853,233            10,319,041      396,453           534,192           95.08% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 7,866,313        8,663,419               8,107,848        241,535           (555,571)          93.59% DEBT SERVICE: Principal 1,525,168        1,540,568               1,540,568        (15,400)             ‐                         100.00% Interest 265,464           241,747                  241,320           24,144              427                   99.82% TOTAL DEBT SERVICE 1,790,632        1,782,315               1,781,888        8,744                427                   99.98% CAPITAL OUTLAY 6,461,095        37,304,963            3,118,100        3,342,995        34,186,863      8.36% TRANSFERS OUT 2,855                 ‐                                614                   2,241                (614)                  N/A NET TRANSFERS (2,855)                ‐                                (614)                  2,241                (614)                  N/A CHANGE IN FUND BALANCE (388,269)          (30,423,859)           3,207,246        3,595,515        33,631,105      N/A BEGINNING FUND BALANCE, Jan 1 37,957,336      37,569,067            37,569,067      (388,269)           ‐                         100.00% ENDING FUND BALANCE, Dec 31 37,569,067$   7,145,208$            40,776,313$   3,207,246$      33,631,105$   570.68% WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 33 of 45   Internal Services – The decrease in internal services from the prior year is primarily the result of 9 months’ replacement  reserve payments being waived in response to COVID‐19. All vehicle/equipment purchases and replacements are being  postponed one year. The amount of internal services under budget is primarily due to internal payments to Street  Maintenance for paving services that were lower than anticipated.     Capital Outlay ‐ A listing of project budgets and balances at December 31 is as follows:          PROJECT BUDGET ACTUAL BALANCE PIPE OVERSIZING COSTS 100,000$ -$ 100,000$ TELEMETRY IMPROVEMENTS-PHASE 4 250,000 22,035 227,965 WATER SYSTEM PLAN UPDATE 200,000 65,746 134,254 UPDATE EMERGENCY RESPONSE PLAN 250,000 28,510 221,490 STEEL/AC WATERMAIN REPLC PLAN 1,130,000 6,518 1,123,482 RESERVOIR RECOATING 200,000 5,399 194,601 EMERGENCY RESPONSE PROJ 100,000 - 100,000 DOWNTOWN WATER MAIN REPLACEMENT 3,500,000 190,387 3,309,613 GPS & GIS DATABASE/CONVERSION - (4,432) 4,432 WATER PUMP STATIONS REHAB 400,000 - 400,000 RESERVOIR PRV METERS 300,000 42,765 257,235 MPLWD WATER TREATMENT IMPROV - CONST 770,000 104,759 665,241 HIGHLANDS WATER MAIN IMPROVEMENT 1,100,000 21,262 1,078,738 DUVALL AVE NE WATER MAIN REPLACEMENT 360,000 2,400 357,600 EMERGENCY POWER TO PUMP STATION 300,000 9,414 290,586 WATER SYSTEM SECURITY IMPROVEMENTS 100,000 - 100,000 AQUIFER MONITORING AND MANAGEMENT 30,000 - 30,000 WATER TREATMENT FILTER MEDIA 400,000 7,064 392,936 WSDOT I-405 WATER RELOCATIONS 300,000 13,190 286,810 AUTOMATIC METER READING CONVERSION 85,000 38,885 46,115 TRANSMISSION MAIN REPLACEMENT - (248) 248 HIGHLANDS 435-RESERVOIRS REPLACEMENT 23,100,000 34,224 23,065,776 RAINIER AVE S ROAD & UTILITIES IMPRVMNT 300,000 - 300,000 KENNYDALE 320-RESERVOIR 4,000,000 2,609,158 1,390,842 TOTAL PROJECT BALANCES 37,275,000$ 3,197,036$ 34,077,964$ Non-capital items included in project budgets - (78,936) 78,936 Operating fund equipment purchase 29,963 - 29,963 TOTAL CAPITAL OUTLAY 37,304,963$ 3,118,100$ 34,186,863$ WATER UTILITY FUND PROJECT BALANCES AT DECEMBER 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 34 of 45   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 decreased from the prior year due to COVID‐19. Utility revenues are recognized  when received for budgetary purposes. While consumption changes between commercial and residential properties have  resulted in a net decrease in amounts billed through December 31 of only $51K, receipts associated with these billings have  decreased $140K over the same period in 2019. A moratorium on disconnections for non‐payment has been in effect since  March and was recently extended into spring 2021. The amount of charges for services under budget is due to revenue budget  being overestimated.     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.     Contracted Services – The decrease in contracted services from the prior year is due primarily to reductions in amounts spent  for equipment rental and professional services related to preparation of the Wastewater Long Range Plan. The amount under  budget is primarily due to unspent professional services related to preparation of the Wastewater Operations Master Plan.    Internal Services ‐ The decrease in internal services from the prior year is primarily the result of 9 months’ replacement  reserve payments being waived in response to COVID‐19. All vehicle/equipment purchases and replacements are being  postponed one year.    Capital Outlay ‐ A listing of project budgets and balances at December 31 is provided on the following page.   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 112,779$         61,802$                  109,025$         (3,754)$            47,223$           176.41% Charges for services 10,862,024      11,248,216            10,707,414      (154,610)          (540,802)          95.19% Fines and penalties 616                    ‐                                107                   (509)                  107                   N/A Interest and other misc 824,539           320,766                  670,965           (153,574)          350,199           209.18% TOTAL REVENUES 11,799,958      11,630,784            11,487,511      (312,447)          (143,273)          98.77% EXPENSES: Personnel 2,311,705        2,456,376               2,363,337        (51,632)            93,039              96.21% Supplies 83,839              70,880                    68,992              14,847              1,888                97.34% Contracted Services 2,314,239        2,644,281               2,037,954        276,285           606,327           77.07% Internal Services 1,602,273        1,455,392               1,459,820        142,453           (4,428)               100.30% TOTAL OPERATING EXPENSES 6,312,056        6,626,929               5,930,103        381,953           696,826           89.48% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 5,487,902        5,003,855               5,557,408        69,506              553,553           111.06% DEBT SERVICE: Principal 592,700           601,300                  601,300           (8,600)                ‐                         100.00% Interest 119,821           108,921                  108,698           11,123              223                   99.80% TOTAL DEBT SERVICE 712,521           710,221                  709,998           2,523                223                   99.97% CAPITAL OUTLAY 3,528,918        18,463,200            682,446           2,846,472        17,780,754      3.70% TRANSFERS OUT 95,768               ‐                                1,098                94,670              (1,098)               N/A NET TRANSFERS (95,768)             ‐                                (1,098)               94,670              (1,098)               N/A CHANGE IN FUND BALANCE 1,150,695        (14,169,566)           4,163,866        3,013,171        18,333,432      N/A BEGINNING FUND BALANCE, Jan 1 18,681,655      19,832,351            19,832,351      1,150,696         ‐                         100.00% ENDING FUND BALANCE, Dec 31 19,832,350$   5,662,785$            23,996,217$   4,163,867$      18,333,432$   423.75% WASTEWATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 35 of 45   Wastewater Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE MISCELANEOUS SEWER PROJECTS 185,000$ 5,581$ 179,419$ 2008 LONG-RANGE WW MANAG PLAN 97,000 74,403 22,597 WASTEWATER OPERATIONS MASTER PLAN 774,000 8,909 765,091 FALCON RIDGE LS REHAB - 59 (59) AIRPORT LS REHAB - 409 (409) THUNDER HILL INT REPL/REHAB 3,110,000 35,926 3,074,074 FORCE MAIN REHABILITATION REPLACEMENT 1,487,000 7,692 1,479,308 LIFT STATION REHABILITATION 1,891,000 11,205 1,879,795 DOWNTOWN SEWER REPLACEMENT/REHAB 7,537,000 344,687 7,192,313 2019 SANITARY SEWER REHAB/REPLACEMENT - 3,704 (3,704) 2020 SANITARY SEWER REHAB/REPLACEMENT 2,700,000 217,982 2,482,018 KENNYDALE LAKELINE SEWER UPGRADE 1,248,000 53,540 1,194,460 TOTAL PROJECT BALANCES 19,029,000$ 764,097$ 18,264,903$ Non-capital items included in project budgets (571,000) (81,651) (489,349) Operating fund equipment purchase 5,200 - 5,200 TOTAL CAPITAL OUTLAY 18,463,200$ 682,446$ 17,780,754$ WASTEWATER UTILITY FUND PROJECT BALANCES AT DECEMBER 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 36 of 45   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 – Surface water charges for services increased over the prior year due to rate increases. Unlike Water  and Wastewater charges, Surface water charges are not based on usage, but rather on impervious surface area, so COVID‐19  did not affect the amounts billed. Utility revenues are recognized when received for budgetary purposes, so although  amounts billed increased $244K from the prior year, the revenue reflects a smaller increase as accounts receivable balances  increased by 8.56% over the prior year. A moratorium on disconnections for non‐payment has been in effect since March and  was recently extended into spring 2021. The amount of charges for services under budget is due to revenue budget being  overestimated. The revenue budget has been reduced for the 2021/2022 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.        2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 52,975$           50,456$                  71,225$           18,250$           20,769$           141.16% Grants / intergovernmental 1,260,393        12,481,399            1,048,412        (211,981)          (11,432,987)    8.40% Charges for services 11,746,291      13,000,699            11,963,516      217,225           (1,037,183)       92.02% Interest and other misc 660,311           135,163                  391,497           (268,814)          256,334           289.65% TOTAL REVENUES 13,719,970      25,667,717            13,474,650      (245,320)          (12,193,067)    52.50% EXPENSES: Personnel 3,593,493        3,488,003               3,656,655        (63,162)            (168,652)          104.84% Supplies 142,760           167,949                  119,116           23,644              48,833              70.92% Contracted Services 1,733,948        4,327,721               1,852,981        (119,033)          2,474,740        42.82% Internal Services 1,959,078        1,746,577               1,754,465        204,613           (7,888)               100.45% TOTAL OPERATING EXPENSES 7,429,279        9,730,250               7,383,217        46,062              2,347,033        75.88% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 6,290,691        15,937,467            6,091,433        (199,258)          (9,846,034)       38.22% DEBT SERVICE: Principal 472,950           488,950                  488,950           (16,000)             ‐                         100.00% Interest 649,826           640,845                  640,663           9,163                182                   99.97% TOTAL DEBT SERVICE 1,122,776        1,129,795               1,129,613        (6,837)               182                   99.98% CAPITAL OUTLAY 3,043,116        20,385,802            1,728,735        1,314,381        18,657,067      8.48% TRANSFERS OUT 7,721                8,381                       284                   7,437                8,097                3.39% NET TRANSFERS (1,343)               (8,381)                     (284)                  1,059                8,097                N/A CHANGE IN FUND BALANCE 2,123,456        (5,586,511)             3,232,801        1,109,345        8,819,312        N/A BEGINNING FUND BALANCE, Jan 1 16,254,097      18,377,556            18,377,556      2,123,459         ‐                         100.00% ENDING FUND BALANCE, Dec 31 18,377,553$   12,791,045$          21,610,357$   3,232,804$      8,819,312$      168.95% SURFACE WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 37 of 45   Surface Water Utility Fund (continued)    Personnel – The amount of personnel costs over budget are due to a difference in classification between the budget and  actual expenses. Certain projects were budgeted as capital outlay, but if the project does not qualify for capitalization under  GAAP, the actual expenses have been reported under the appropriate operational category.    Contracted Services – The increase in contracted services from the prior year is primarily due to professional services related  to the Cedar River Levee Recertification. The amount of contracted services under budget is primarily due to unspent  professional services related to the Cedar River Gravel Removal project.     Internal Services – Decreased internal service fund charges are a result of 9 months’ replacement reserve payments being  waived in response to COVID‐19. All vehicle/equipment purchases and replacements are being postponed one year.    Capital Outlay ‐ A listing of project budgets and balances at December 31 is as follows:         PROJECT BUDGET ACTUAL BALANCE COMP S&SW MGMT PLAN P&D 172,034$ 143,560$ 28,474$ SM DRAINAGE PROBLEMS 683,923 105,359 578,564 PANTHER CR WL MOSQUITO ABATEMENT 89,767 78,991 10,776 MADSEN CREEK SEDIMENT BASIN 83,738 74,447 9,291 SMALL DRAINAGE PROJ-MAPLEWOOD SEDIMENT 111,314 89,000 22,314 WETLAND MITIGATION BANK 160,345 50,759 109,586 ACOE 205 PROJECT 61,693 2,956 58,737 CEDAR RIVER GRAVEL REMOVAL 2,902,163 245,162 2,657,001 RENTON STORM WATER MANUAL 75,815 7,668 68,147 GREEN RIVER ECOSYSTEM STUDY 48,336 159 48,177 MISCELLANEOUS/EMERGENCY/STORM PROJECTS 100,000 - 100,000 SURFACE WATER UTILITY GIS 125,382 113,627 11,755 HARDIE AVE S UNDERPASS STORM SYSTEM IMPR 2,391 - 2,391 MONROE AVE/N 2ND ST 453,837 223,503 230,334 STORMWATER FACILITY FENCING PROJECT 265,101 2,901 262,200 CEDAR RIVER 205 LEVEE RECERTIFICATION 4,854,386 321,486 4,532,900 SE 172ND ST/125TH AVE SE 232,561 112,162 120,399 RAINIER AVE/OAKSDALE AVE PUMP STATION UP 207,466 75,346 132,120 NE 16TH/JEFFERSON AVE NE 2,768,213 144,783 2,623,430 DOWNTOWN STORM SYSTEM IMPROVEMENT PROJEC 6,030,270 324,492 5,705,778 HEATHER DOWNS DETENTION POND 693,543 36,872 656,671 MADSEN CRK IMPROV PHASE 1-KCFCD 1,033,096 189,499 843,597 RAINIER AVE/BENSON RD S - CULVERT REPL 200,610 148,934 51,676 CMP STORM SYSTEM REPLACEMENT PROJECT 439,934 31,389 408,545 CEDAR RIVER FLOOD RISK REDUCTION 499,658 8,113 491,545 STORMWATER FACILITY RETROFIT STUDY 300,000 28,190 271,810 BURNETT AVE S/WILLIAMS AVE S 567,629 71,831 495,798 DISASTER RESP CEDAR RIVER GRAVEL REMOVAL - 1,183 (1,183) WSDOT LA ROW RUNOFF IMPACT MITIGATION 96,200 48,937 47,263 TOTAL PROJECT BALANCES 23,259,405$ 2,681,309$ 20,578,096$ Non-capital items included in project budgets (2,902,163) (952,574) (1,949,589) Operating fund equipment purchase 28,560 - 28,560 TOTAL CAPITAL OUTLAY 20,385,802$ 1,728,735$ 18,657,067$ SURFACE WATER UTILITY PROJECT BALANCES AT DECEMBER 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 38 of 45   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 – Metro charges decreased from the prior year due to COVID‐19. Utility revenues are recognized when  received for budgetary purposes. While consumption changes between commercial and residential properties have resulted  in a net decrease in amounts billed through December 31 of $472K, receipts associated with these billings have decreased  $525K over the same period in 2019. A moratorium on disconnections for non‐payment has been in effect since March and  was recently extended into spring 2021.     Contracted Services – The increase in contracted services over the prior year is due to a payment made in June for just over  $1M which was the result of an audit by King County Metro which determined the City had underpaid for water treatment  services from 2014‐2019. The audit assessment expense was accrued to 2019 for financial reporting purposes, but the  payment wasn’t made until 2020.     Capital Outlay ‐ The Metro Fund does not have a capital fund.     2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 17,258,422$   17,007,226$          16,729,775$   (528,647)$        (277,451)$        98.37% Interest and other misc 86,060               ‐                                52,557              (33,503)            52,557              N/A TOTAL REVENUES 17,344,482      17,007,226            16,782,332      (562,150)          (224,894)          98.68% EXPENSES: Contracted Services 16,894,991      17,007,226            18,014,489      (1,119,498)       (1,007,263)       105.92% TOTAL OPERATING EXPENSES 16,894,991      17,007,226            18,014,489      (1,119,498)       (1,007,263)       105.92% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 449,491            ‐                                (1,232,157)       (1,681,648)       (1,232,157)       N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 449,491            ‐                                (1,232,157)       (1,681,648)       (1,232,157)       N/A BEGINNING FUND BALANCE, Jan 1 5,512,418        5,961,906               5,961,906        449,488            ‐                         100.00% ENDING FUND BALANCE, Dec 31 5,961,909$      5,961,906$            4,729,749$      (1,232,160)$    (1,232,157)$    79.33% METRO VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 39 of 45   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.         Charges for services – The decrease in charges for services from the prior year is due to the City not providing services to the  Renton Regional Fire Authority after 12/31/19.    Interdepartmental services – Decreased internal service fund charges are a result of 9 months’ replacement reserve  payments being waived in response to COVID‐19. All vehicle/equipment purchases and replacements are being postponed  one year.    Supplies – Decreased supplies expenses are primarily due to decreased purchases of vehicle parts/maintenance supplies  ($148K), and decreased fuel costs ($285K). The amount of supplies expenses under budget are primarily due to cost savings  associated with fuel purchases ($470K).    Capital Outlay – Decreased capital outlay expenses are due to COVID‐19.     Net Transfers – The decrease in net transfers from the prior year is due to one‐time transfers for new equipment purchases  in 2019 that are not repeated in 2020.      2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 720,518$          ‐$                             73,872$           (646,646)$        73,872$           N/A Interdepartmental services 5,040,320        3,587,714               3,635,986        (1,404,334)       48,272              101.35% Interest and other misc 149,191           12,000                    90,310              (58,881)            78,310              752.58% TOTAL REVENUES 5,910,029        3,599,714               3,800,168        (2,109,861)       200,454           105.57% EXPENSES: Personnel 1,124,873        1,089,183               1,052,975        71,898              36,208              96.68% Supplies 1,439,235        1,496,153               1,001,827        437,408           494,326           66.96% Contracted Services 302,546           133,166                  285,599           16,947              (152,433)          214.47% Internal Services 29,483              32,697                    32,697              (3,214)                ‐                         100.00% TOTAL OPERATING EXPENSES 2,896,137        2,751,199               2,373,098        523,039           378,101           86.26% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 3,013,892        848,515                  1,427,070        (1,586,822)       578,555           168.18% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 4,757,098        2,154,000               1,902,622        2,854,476        251,378           88.33% NET TRANSFERS 2,102,000         ‐                                 ‐                         (2,102,000)        ‐                         N/A CHANGE IN FUND BALANCE 358,794           (1,305,485)             (475,552)          (834,346)          829,933           N/A BEGINNING FUND BALANCE, Jan 1 6,493,018        6,851,811               6,851,811        358,793            ‐                         100.00% ENDING FUND BALANCE, Dec 31 6,851,812$      5,546,326$            6,376,259$      (475,553)$        829,933$         114.96% VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 40 of 45   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.        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 under budget are primarily due to lower than expected Workers’ Compensation  ($515K) and Unemployment Benefit ($75K) claims.    Contracted Services ‐ The increase in contracted services expenses over the prior year is primarily due to increased Liability  claims ($211K) and increased external insurance premiums ($151K).    Transfers Out –The remaining reserve originally intended to be transferred to the General Fund over a five year period to  offset the loss of revenue from the State for the Benson Hill Annexation ($4.5M) was transferred to the General Fund in July  to offset revenue losses due to COVID‐19. However, after B&O and Retail Sales Tax revenues came in higher than anticipated,  management decided the reserves were not needed and the transfer was reversed in December.      2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 3,152,302$      3,174,506$            3,084,056$      (68,246)$          (90,450)$          97.15% Interest and other misc 627,361           197,000                  400,397           (226,964)          203,397           203.25% TOTAL REVENUES 3,779,663        3,371,506               3,484,453        (295,210)          112,947           103.35% EXPENSES: Personnel 814,417           1,484,232               856,775           (42,358)            627,457           57.73% Supplies ‐                         4,000                       401                   (401)                  3,599                10.03% Contracted Services 1,491,894        1,841,646               1,862,577        (370,683)          (20,931)            101.14% TOTAL OPERATING EXPENSES 2,306,311        3,329,878               2,719,753        (413,442)          610,125           81.68% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,473,352        41,628                    764,700           (708,652)          723,072           1836.98% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TRANSFERS OUT 900,000           4,500,000                ‐                         900,000           4,500,000        0.00% NET TRANSFERS (900,000)          (4,500,000)              ‐                         900,000           4,500,000        N/A CHANGE IN FUND BALANCE 573,352           (4,458,372)             764,700           191,348           5,223,072        N/A BEGINNING FUND BALANCE, Jan 1 18,522,154      19,095,508            19,095,508      573,354            ‐                         100.00% ENDING FUND BALANCE, Dec 31 19,095,506$   14,637,136$          19,860,208$   764,702$         5,223,072$      135.68% INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 41 of 45   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.         Licenses and permits – Licenses and permits represents tech fees paid by permit customers to offset the cost of replacing  the EnerGov permitting system. The amounts over budget are the result of conservative budgeting of the revenue.    Charges for services – The decrease in charges for services from the prior year is due to the City not providing services to the  Renton Regional Fire Authority after 12/31/19.    Interdepartmental services ‐ Increased interdepartmental services revenue over the prior year is due to increased costs in  personnel and contracted services being charged back to the departments.     Personnel – The amount of personnel costs under budget is due to open positions.    Supplies – The amount of supplies under budget is due to minor equipment replacements that were postponed due to COVID‐ 19.    Contracted Services ‐ Increased contracted services expenses over the prior year are the result of increased service contract  costs primarily associated with added cameras and computers in police take‐home vehicles.    Capital Outlay – The amount of capital outlay under budget is due to capital projects that were postponed due to COVID‐19  related issues (telecommuting) and a cyber security incident that required a significant amount of IT personnel resources  during the year.      2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 315,987$         150,000$                253,589$         (62,398)$          103,589$         169.06% Charges for services 913,884            ‐                                 ‐                         (913,884)           ‐                         N/A Interdepartmental services 4,968,389        5,345,584               5,373,361        404,972           27,777              100.52% Interest and other misc 56,719              7,000                       43,857              (12,862)            36,857              626.53% TOTAL REVENUES 6,254,979        5,502,584               5,670,807        (584,172)          168,223           103.06% EXPENSES: Personnel 2,806,661        3,165,906               2,871,867        (65,206)            294,039           90.71% Supplies 520,074           983,155                  525,907           (5,833)               457,248           53.49% Contracted Services 2,103,260        2,416,051               2,420,303        (317,043)          (4,252)               100.18% Internal Services 1,552                1,804                       1,804                (252)                   ‐                         100.00% TOTAL OPERATING EXPENSES 5,431,547        6,566,916               5,819,881        (388,334)          747,035           88.62% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 823,432           (1,064,332)             (149,074)          (972,506)          915,258           N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 359,367           1,076,881               436,562           (77,195)            640,319           40.54% TRANSFERS IN 91,589              18,011                    35,515              (56,074)            17,504              197.19% NET TRANSFERS 91,589              18,011                    35,515              (56,074)            17,504              197.19% CHANGE IN FUND BALANCE 555,654           (2,123,202)             (550,121)          (1,105,775)       1,573,081        N/A BEGINNING FUND BALANCE, Jan 1 3,934,408        4,490,062               4,490,062        555,654            ‐                         100.00% ENDING FUND BALANCE, Dec 31 4,490,062$      2,366,860$            3,939,941$      (550,121)$        1,573,081$      166.46% INFORMATION TECHNOLOGY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 42 of 45   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.         Charges for services ‐ The decrease in charges for services from the prior year is due to the City not providing services to the  Renton Regional Fire Authority after 12/31/19.    Interdepartmental services ‐ The decrease in internal service fund charges is due to COVID‐19. Excess fund balance is being  utilized and planned preventative maintenance is being delayed to reduce the burden on departments paying into the  Facilities Fund. 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.    Personnel – The amount of personnel costs under budget is due to open positions.    Supplies – The decrease in supplies expenses from the prior year is due to purchasing less operating supplies ($61K), a result  of substantially less employees working in City facilities, less small tools/minor equipment ($21K), and less furniture ($22K).     Contracted Services – The decrease in contracted services costs from the prior year is due to a combination of decreased  utility charges ($211K) resulting from the Governor’s stay‐at‐home order and decreased repair/maintenance costs ($379K)  as planned preventative maintenance has been delayed.    Capital Outlay – The amount of capital outlay expenses over budget is due to the purchase of touchless urinals, a new water  heater for the Coulon bathhouse, a compressor replacement at the Public Works shops, and City Hall exterior sign lighting  and retrofit. Cost savings from Contracted Services were utilized for these purchases.   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental ‐$                        ‐$                             21,835$           21,835$           21,835$           N/A Charges for services 861,152            ‐                                 ‐                         (861,152)           ‐                         N/A Interdepartmental services 4,424,369        4,306,771               4,149,775        (274,594)          (156,996)          96.35% Rents, leases, and misc fees 1                         ‐                                1                         ‐                         1                        N/A Interest and other misc 16,506              4,000                       10,426              (6,080)               6,426                260.65% TOTAL REVENUES 5,302,028        4,310,771               4,182,037        (1,119,991)       (128,734)          97.01% EXPENSES: Personnel 2,880,962        3,167,309               2,864,198        16,764              303,111           90.43% Supplies 535,808           339,168                  431,986           103,822           (92,818)            127.37% Contracted Services 2,004,246        1,505,634               1,412,250        591,996           93,384              93.80% Internal Services 66,617              67,450                    68,309              (1,692)               (859)                  101.27% TOTAL OPERATING EXPENSES 5,487,633        5,079,561               4,776,743        710,890           302,818           94.04% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (185,605)          (768,790)                 (594,706)          (409,101)          174,084           N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 10,901               ‐                                129,999           (119,098)          (129,999)          N/A TRANSFERS IN 45,143              2,880                       8,596                (36,547)            5,716                298.47% TRANSFERS OUT 5,220                 ‐                                 ‐                         5,220                 ‐                         N/A NET TRANSFERS 39,923              2,880                       8,596                (31,327)            5,716                298.47% CHANGE IN FUND BALANCE (156,583)          (765,910)                 (716,109)          (559,526)          49,801              N/A BEGINNING FUND BALANCE, Jan 1 1,376,859        1,220,276               1,220,276        (156,583)           ‐                         100.00% ENDING FUND BALANCE, Dec 31 1,220,276$      454,366$                504,167$         (716,109)$        49,801$           110.96% FACILITIES VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 43 of 45   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 decrease in internal service fund charges is due to COVID‐19. Excess fund balance is being  utilized to reduce the burden on departments paying into the Communications Fund. 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.    Contracted Services – The amount of contracted services under budget is primarily due to cost savings related to Community  Relations ($25K), Postage ($57K), and the 2020 Census ($29K).   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 1,104,816$      1,069,076$            341,174$         (763,642)$        (727,902)$        31.91% Interest and other misc 10,578              108,050                  55,471              44,893              (52,579)            51.34% TOTAL REVENUES 1,115,394        1,177,126               396,645           (718,749)          (780,481)          33.70% EXPENSES: Personnel 720,723           851,567                  802,827           (82,104)            48,740              94.28% Supplies 36,651              71,350                    28,372              8,279                42,978              39.76% Contracted Services 237,087           336,679                  209,213           27,874              127,466           62.14% Internal Services 2,967                3,941                       3,941                (974)                   ‐                         100.00% TOTAL OPERATING EXPENSES 997,428           1,263,537               1,044,353        (46,925)            219,184           82.65% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 117,966           (86,411)                   (647,708)          (765,674)          (561,297)          N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TRANSFERS OUT ‐                          ‐                                4,229                (4,229)               (4,229)               N/A NET TRANSFERS ‐                          ‐                                (4,229)               (4,229)               (4,229)               N/A CHANGE IN FUND BALANCE 117,966           (86,411)                   (651,937)          (769,903)          (565,526)          N/A BEGINNING FUND BALANCE, Jan 1 685,593           803,561                  803,561           117,968            ‐                         100.00% ENDING FUND BALANCE, Dec 31 803,559$         717,150$                151,624$         (651,935)$        (565,526)$        21.14% COMMUNICATIONS VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 44 of 45   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 under budget 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 2020 related to 2019 prescription payments.    Personnel – The increase in personnel costs from the prior year is due to increased medical claims. The budget included the  addition of several FTE’s, but many vacant positions were frozen due to COVID‐19. This resulted in lower than expected costs  for medical ($1.7M) and prescriptions ($110K) claims.        2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Premiums 11,201,855$   12,603,106$            11,143,596$   (58,259)$          (1,459,510)$    88.42% Interest and other misc 73,955              46,588                       234,235           160,280           187,647           502.78% TOTAL REVENUES 11,275,810      12,649,694               11,377,831      102,021           (1,271,863)       89.95% EXPENSES: Personnel 9,904,336        12,011,435               10,220,898      (316,562)          1,790,537        85.09% Supplies 13,196              7,500                         6,930                6,266                570                   92.40% Contracted Services 408,077           420,540                    467,791           (59,714)            (47,251)            111.24% Internal Services 58,064              60,430                       60,430              (2,366)                ‐                         100.00% TOTAL OPERATING EXPENSES 10,383,673      12,499,905               10,756,049      (372,376)          1,743,856        86.05% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 892,137           149,789                    621,782           (270,355)          471,993           415.11% TOTAL DEBT SERVICE ‐                          ‐                                   ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                   ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                   ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 892,137           149,789                    621,782           (270,355)          471,993           415.11% BEGINNING FUND BALANCE, Jan 1 4,259,511        5,151,648                 5,151,648        892,137            ‐                         100.00% ENDING FUND BALANCE, Dec 31 5,151,648$      5,301,437$               5,773,430$      621,782$         471,993$         108.90% HEALTH INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 4th Quarter 2020  Page 45 of 45   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 by recommendation of the City’s  Employee Health Plan Board after review of a report prepared by Healthcare Actuaries.         Premiums – The decrease in premiums 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.    Interest and other misc – Interest revenues have exceeded the annual budget as these revenues are budgeted conservatively  in anticipation of market volatility.    Personnel ‐ The increase in personnel expenses over the prior year is primarily due to an increase in prescription costs ($50K),  dental costs ($37K), and payments for long‐term care ($90K), a benefit not previously being utilized. The amount under  budget is primarily due to lower than expected costs for medical ($121K) and long‐term care ($119K) that are being offset by  higher than expected costs for prescriptions ($73K), Medicare ($26K), and dental ($34K).                CONTACT INFORMATION  This report is prepared by the Finance Division of the Administrative Services 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 Misty Baker at mbaker@rentonwa.gov or Kari Roller at kroller@rentonwa.gov. 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 35,898$           45,014$                  74,545$           38,647$           29,531$           165.60% Premiums 2,624,684        131,989                  1,624,684        (1,000,000)       1,492,695        1230.92% Interest and other misc 209,441           67,459                    171,108           (38,333)            103,649           253.65% TOTAL REVENUES 2,870,023        244,462                  1,870,337        (999,686)          1,625,875        765.08% EXPENSES: Personnel 886,017           1,209,429               1,086,163        (200,146)          123,266           89.81% Contracted Services 60,904              38,814                    42,658              18,246              (3,844)               109.90% TOTAL OPERATING EXPENSES 946,921           1,248,243               1,128,821        (181,900)          119,422           90.43% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,923,102        (1,003,781)             741,516           (1,181,586)       1,745,297        N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 1,923,102        (1,003,781)             741,516           (1,181,586)       1,745,297        N/A BEGINNING FUND BALANCE, Jan 1 13,876,628      15,799,729            15,799,729      1,923,101         ‐                         100.00% ENDING FUND BALANCE, Dec 31 15,799,730$   14,795,948$          16,541,245$   741,515$         1,745,297$      111.80% RETIREE HEALTHCARE VARIANCE