Loading...
HomeMy WebLinkAboutQuarter 3 2020 H:\Finance\Financial Reporting\Monthly Reports\2020 Reports\QUARTERLY\Cover 3Q2020.docx  ADMINISTRATIVE SERVICES    M   E   M   O   R   A   N   D   U   M       DATE: November 19, 2020     TO: Ruth Pérez, Council President  Members of Renton City Council     CC: Armondo Pavone, Mayor     FROM: Jan Hawn, ASD Administrator     STAFF CONTACT: Misty Baker, Sr. Finance Analyst     SUBJECT: Quarterly Financial Report 3rd Quarter 2020       The attached report provides a detailed discussion of General Fund revenues and  expenditures with comparison to prior year and YTD budget through 3rd quarter of 2020.   The City is projecting a significant decrease in revenues due to the statewide shutdown in  response to the COVID‐19 pandemic. Budget appropriations were decreased immediately  for discretionary spending, capital projects and personnel. However, the projected  revenue decrease and the increase to Emergency Management appropriations for COVID‐ 19 response and related CARES Act grant revenue will not be reflected until the 4th quarter  after the year end budget adjustment, referred to Finance Committee during the  November 16th regular City Council Meeting, is approved.     For the end of the 3rd quarter of 2020, General Fund revenues, excluding Interfund  transfers, are $12.1M less than the 3rd quarter of 2019 and $5.6M under the year‐to‐date  (YTD) budget. General Fund expenditures, excluding Interfund transfers, are $1.6M more  than the 3rd quarter of 2019, but $2.9M under the YTD 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 43   OVERVIEW  This quarterly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through September   30, 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 5975, which includes budget cuts in response  to COVID‐19. Reductions to revenue budgets for 2020 will be presented to Council with the year‐end budget adjustment and  are not reflected in the annual budget figures below.    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 63,075,671$      81,535,404$    57,375,948$ 54,994,256$   (8,081,415)$   (2,381,692)     67.45% Licenses & Permits 4,514,168            5,550,877          4,407,428       3,898,393         (615,775)           (509,035)         70.23% Intergovernmental 3,513,832            6,006,330          3,840,199       3,100,156         (413,676)           (740,043)         51.61% Charges for Services 6,994,748            8,968,213          6,698,486       5,703,174         (1,291,574)      (995,312)         63.59% Fines and Penalties 3,414,947            4,759,187          3,307,779       2,525,808         (889,139)           (781,971)         53.07% Miscellaneous 2,832,818            2,796,165          2,133,882       1,982,720         (850,098)           (151,162)         70.91% Other Financing Sources (Transfer‐In, etc) 6,130,641            21,551,170       15,494,506    15,517,922      9,387,281        23,416              72.01% Total Revenues 90,476,825         131,167,346    93,258,227    87,722,429      (2,754,396)      (5,535,798)     66.88% EXPENDITURES Council 272,542                420,924               320,597            311,297             (38,755)              9,300                 73.96% Executive 1,806,865            2,562,066          1,823,338       1,674,762         132,103            148,576           65.37% Emergency Management 460,428                729,951               534,414            2,226,895         (1,766,467)      (1,692,481)     305.07% City Attorney 1,747,999            2,421,421          1,799,867       1,650,183         97,816               149,684           68.15% Court Services 1,767,241            2,706,695          2,029,070       1,826,914         (59,673)              202,156           67.50% Community and Eco Dvlpmnt Admin 1,155,378            1,560,726          1,217,159       1,214,792         (59,414)              2,367                 77.84% Development Services 1,706,657            2,638,176          1,941,392       1,849,201         (142,544)           92,191              70.09% Economic Development 739,004                3,915,768          1,983,204       1,292,562         (553,558)           690,642           33.01% Planning 2,821,288            4,359,422          3,151,895       3,000,401         (179,113)           151,494           68.83% Finance 2,201,301            3,709,001          2,487,322       2,310,374         (109,073)           176,948           62.29% City Clerk 976,446                1,175,923          912,463            933,185             43,261               (20,722)            79.36% Human Resources 1,057,790            1,530,267          1,132,397       1,047,953         9,837                  84,444              68.48% Police 26,010,388         36,080,460       26,743,222    27,134,478      (1,124,090)      (391,256)         75.21% Jail Services 4,324,595            4,707,756          3,530,959       3,531,146         793,449            (187)                    75.01% Community Services Admin 400,124                520,919               393,746            380,852             19,272               12,894              73.11% Leased Properties 494,861                1,013,086          621,271            505,579             (10,718)              115,692           49.90% Parks & Trails 3,937,676            5,103,016          3,835,344       3,663,974         273,702            171,370           71.80% Parks Planning & Natural Resources 1,074,756            2,414,791          1,750,625       1,362,614         (287,858)           388,011           56.43% Recreation & Neighborhoods 4,927,650            4,879,722          3,694,508       3,300,617         1,627,033        393,891           67.64% Human Services 985,889                1,644,515          1,113,421       977,777             8,112                  135,644           59.46% Museum 189,253                225,195               168,598            169,695             19,558               (1,097)               75.35% Public Works Admin 320,851                442,549               334,257            292,344             28,507               41,913              66.06% Street Maintenance 4,112,362            5,591,654          4,155,348       4,136,933         (24,571)              18,415              73.98% Transportation 4,442,782            7,059,187          5,445,505       5,207,535         (764,753)           237,970           73.77% Non‐Departmental and Other 13,944,175         26,749,431       14,706,846    12,895,917      1,048,258        1,810,929      48.21% Total Expenditures 81,878,301         124,162,621    85,826,768    82,897,980      (1,019,679)      2,928,788      66.77% Change in Fund Balance 8,598,524            7,004,725          7,431,459       4,824,449         (3,774,075)      (2,607,010)     68.87% Beginning Fund Balance 44,578,377         48,056,982       48,056,982    48,056,982      3,478,605         ‐                       100.00% Ending Fund Balance 53,176,901$      55,061,707$    55,488,441$ 52,881,431$   (295,470)$        (2,607,010)     96.04% Summary of Sources and Uses Favorable (Unfavorable) 2019 2020 Variance YTD Actual Annual Budget YTD Budget YTD Actual Quarterly Financial Report 3rd Quarter 2020  Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 2 of 43   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. $185K of property taxes  collected through September 30 were for prior years’ delinquent taxes, bringing the balance of delinquent taxes receivable  to $55K. The remainder of taxes collected were for the 2020 levy. The taxes receivable balance for the 2020 levy is just under  $10.1M, with the second half of tax payments due in October.    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.     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 3rd  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 September 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.     Utility Tax – The increase in utility tax is due to a combination of factors. Some taxes have decreased while others have  increased.      2019 2020 2020 Actual Budget Actual $ % $ % Property Tax 11,505,822$      11,551,391$       12,053,143$      547,321$        4.8% 501,753$           4.3% Local Retail Sales Tax 21,109,167         21,256,286          19,718,350         (1,390,816)      ‐6.6% (1,537,936)         ‐7.2% State Sales Tax Credit 84,916                    125,000                 996,410                 911,494           1073.4% 871,410              697.1% Criminal Justice Sales Tax 2,411,546            2,200,158             2,223,320            (188,226)           ‐7.8%23,163                 1.1% Natural Gas Use Tax 185,365                 190,178                 102,181                 (83,183)              ‐44.9% (87,997)                ‐46.3% Admission Tax 150,579                 116,780                 84,889                    (65,690)              ‐43.6% (31,890)                ‐27.3% Utility Tax 11,754,728         11,717,719          12,038,749         284,021           2.4% 321,030              2.7% Leasehold Excise Tax 125,063                 124,100                 139,806                 14,742              11.8% 15,706                 12.7% Gambling Excise Tax 2,254,277            1,858,682             1,696,840            (557,437)           ‐24.7% (161,843)             ‐8.7% Real Estate Excise Tax 4,106,380             ‐                                    ‐                                   (4,106,380)     0.0%‐                                N/A B&O Tax 9,387,828            8,235,656             5,940,567            (3,447,261)      ‐36.7% (2,295,089)         ‐27.9% YTD Total 63,075,671$      57,375,948$       54,994,256$      (8,081,414)$   ‐12.8% (2,381,692)$      ‐4.2% Annual Total 89,542,897$      81,535,404$        Taxes by Type Revenue 2020 vs. 2019 2020 vs. Budget Year to Date through September Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 3 of 43   The breakdown of Utility Tax is as follows:        Gambling Excise Tax – COVID‐19 will heavily influence the gambling tax figures throughout 2020. King County remains in  phase 2 of the Governor’s Safe Start plan. Under the current restrictions card game operations are not permitted to operate  indoors until phase 4.     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 and, as a result, have  seen considerable loss in revenue including an average decrease of 30% from the top 5 manufacturing companies.     LICENSES & PERMITS        Franchise Fees – Franchise fee revenues were less than anticipated for the first three quarters of 2020. This is likely due to  the governor’s stay‐at‐home order resulting in less construction being done in City right‐of‐ways.     Business Licenses – Business license revenues are lagging behind 2019 and YTD budget at 9/30. This is due to three main  factors: 1) some businesses closed as a result of COVID‐19 revenue losses, 2) extensions were granted in response to COVID‐ 19, and 3) reduced construction and other seasonal activities due to 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 is not expected to return  to pre‐COVID‐19 levels for the remainder of 2020 due to an overall decline in the economy.        2019 2020 2020 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Electrical 4,025,550$     3,985,064$         4,153,742$     128,191$        3.2% $   168,678 4.2% Natural Gas 1,052,420        1,012,330            1,260,133        207,714           19.7%       247,803 24.5% Cell 562,855            520,876                 632,785            69,930              12.4%       111,910 21.5% Phone 643,359            620,466                 483,758            (159,601)          ‐24.8%     (136,708)‐22.0% Cable 1,084,641        1,140,946            968,926            (115,715)          ‐10.7%     (172,021)‐15.1% Garbage 620,545            601,093                 784,560            164,016           26.4%       183,467 30.5% City Utilities 3,765,358        3,836,943            3,754,844        (10,514)             ‐0.3%        (82,099)‐2.1% YTD Total 11,754,728$  11,717,719$      12,038,749$  284,021$        2.4%321,030$   2.7% 2020 vs. 2019 2020 vs. Budget 2019 2020 2020 Actual Budget Actual $ % $ % Franchise Fees 1,137,582            1,243,300             1,103,118            (34,464)              ‐3.0% (140,182)             ‐11.3% Business Licenses 916,603                 886,002                 829,957                 (86,646)              ‐9.5% (56,045)                ‐6.3% Animal Licenses 64,290                    73,231                    57,045                    (7,245)                 ‐11.3% (16,186)                ‐22.1% Building Permits 2,364,873            2,167,672             1,883,948            (480,926)           ‐20.3% (283,724)             ‐13.1% ROW/Street Excavation Permits 30,770                    36,868                    24,360                    (6,410)                 ‐20.8% (12,508)                ‐33.9% Special Event Permits 50                              356                            (35)                             (85)                        ‐170.0% (391)                        ‐109.8% YTD Total 4,514,168$         4,407,428$          3,898,393$         (615,776)$        ‐13.6% (509,036)$          ‐11.5% Annual Total 5,750,061$         5,550,877$           Year to Date through September Revenue 2020 vs. 2019 2020 vs. Budget Licenses & Permits by Type Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 4 of 43   INTERGOVERNMENTAL        State Shared Revenue – The decrease in state shared revenues over prior year is almost entirely due to decreases in fuel tax  revenues. COVID‐19 is heavily influencing fuel tax revenues as people are driving less. This decrease is expected to continue  throughout the remainder of 2020. 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 3,172,179$         2,989,293$          2,909,197$         (262,983)$        ‐8.3% (80,097)$             ‐2.7% Federal Grants 90,254                    611,816                 160,978                 70,724              78.4%(450,837)             ‐73.7% State Grants 55,833                    107,490                 100                           (55,733)              ‐99.8% (107,390)             ‐99.9% Local Grants 195,566                 131,600                 29,881                    (165,685)           ‐84.7% (101,719)             ‐77.3% YTD Total 3,513,832$         3,840,199$          3,100,156$         (413,677)$        ‐11.8% (740,043)$          ‐19.3% Annual Total 4,820,547$         6,006,330$           Intergovernmental by Type Revenue 2020 vs. 2019 2020 vs. Budget Year to Date through September 2019 2020 2020 Tax by Type YTD Actual YTD Budget YTD Actual$%$% Judicial Contribution 16,248$         12,289$         32,304$         16,056$        98.8% 20,015$        162.9% Crim Just ‐ High Crime 218,646         208,734         140,366         (78,280)          ‐35.8% (68,368)          ‐32.8% Crim Just ‐ Pop 23,191            18,388            24,351            1,160              5.0% 5,963              32.4% Crim Just ‐ Spec Prog 83,510            84,322            87,233            3,723              4.5% 2,911              3.5% State DUI 11,038            13,629            11,049            10                     0.1%(2,580)             ‐18.9% Marijuana Distribution 157,631          ‐                           153,741         (3,890)             ‐2.5%153,741        100.0% Liquor Profits 636,508         637,514         630,636         (5,872)             ‐0.9% (6,877)             ‐1.1% Liquor Excise Tax 416,253         363,105         475,932         59,679           14.3% 112,827        31.1% Fuel Tax 1,609,154     1,651,312     1,353,585     (255,569)       ‐15.9% (297,727)       ‐18.0% YTD Total 3,172,179$  2,989,293$  2,909,197$  (262,983)$   ‐8.3%(80,097)$      ‐2.7% 2020 vs. 2019 2020 vs. Budget 2019 2020 2020 Actual Budget Actual $ % $ % Passport Fees 26,115                    49,393                    10,493                    (15,622)              ‐59.8% (38,900)                ‐78.8% Court Services 46,102                    7,090                       60,284                    14,182              30.8% 53,194                 750.2% General Government Services 1,798                       384                            516                           (1,282)                 ‐71.3%132                        34.4% Public Safety Services 787,697                 671,382                 544,873                 (242,824)           ‐30.8% (126,509)             ‐18.8% Development Services 1,678,110            1,487,340             1,197,247            (480,863)           ‐28.7% (290,094)             ‐19.5% Transportation Services 17,144                     ‐                                   71,276                    54,132              315.7% 71,276                 100.0% Recreation/Farmer's Market/Events 1,359,035            791,840                 266,774                 (1,092,260)      ‐80.4% (525,065)             ‐66.3% Interfund Services 3,078,748            3,691,056             3,551,711            472,964           15.4%(139,345)             ‐3.8% YTD Total 6,994,748$         6,698,486$          5,703,174$         (1,291,574)$   ‐18.5% (995,311)$          ‐14.9% Annual Total 9,251,750$         8,968,213$           Year to Date through September Charges for Services by Type Revenue 2020 vs. 2019 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 5 of 43   Development Services – The decrease in development services from the prior year is primarily due to inspection services  ($326K) and planning fees ($146K). The amount of development services revenues under the YTD budget is also primarily due  to inspection services ($105K) and planning fees ($123K).     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 Fleet and IT charges related  to new Police take‐home vehicles. 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.    FINES AND PENALTIES        Civil Penalties – The majority of Civil Penalties under the YTD budget are due to less than anticipated traffic and parking  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.    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.    Other – Other miscellaneous revenues are higher than prior year and higher than the YTD budget due to the receipt of an  unbudgeted payment of $327K under the terms of the Sunset Lane Latecomer Agreement (ORD 5961).    2019 2020 2020 Actual Budget Actual $ % $ % Civil Penalties 323,074$              465,084$              284,689$              (38,385)$           ‐11.9% (180,395)$          ‐38.8% Photo Enforcement Program 2,904,710            2,723,102             2,087,211            (817,499)           ‐28.1% (635,892)             ‐23.4% Criminal Traffic Misdemeanor Fines 43,106                    56,323                    42,482                    (624)                     ‐1.4% (13,841)                ‐24.6% Criminal Non‐Traffic Fines 56,778                    22,507                    5,945                       (50,833)              ‐89.5% (16,562)                ‐73.6% Criminal Costs 55,332                    17,684                    49,001                    (6,331)                 ‐11.4%31,317                 177.1% Non‐Court Fines, Forfeitures and Penalties 31,946                    23,078                    56,480                    24,534              76.8% 33,402                 144.7% YTD Total 3,414,947$         3,307,779$          2,525,808$         (889,139)$        ‐26.0% (781,971)$          ‐23.6% Annual Total 4,688,980$         4,759,187$           Year to Date through September Revenue 2020 vs. 2019 2020 vs. Budget Fines and Penalties by Type 2019 2020 2020 Actual Budget Actual $ % $ % Interest and Other Investment Earnings 980,675$              584,401$              783,780$              (196,895)$        ‐20.1%199,378$           34.1% Rents, Leases, and Concessions 1,340,700            1,238,818             601,778                 (738,922)           ‐55.1% (637,040)             ‐51.4% Contributions/Donations from Private Source 199,617                 117,144                 123,565                 (76,051)              ‐38.1%6,422                    5.5% Seizure Funds ‐ Federal/State/Local 71,467                     ‐                                    ‐                                   (71,467)             0.0%‐                                N/A Other 240,360                 193,519                 473,597                 233,237           97.0% 280,078              144.7% YTD Total 2,832,818$         2,133,882$          1,982,720$         (850,099)$        ‐30.0% (151,162)$          ‐7.1% Annual Total 3,762,854$         2,796,165$           Miscellaneous by Type Year to Date through September Revenue 2020 vs. 2019 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 6 of 43   OTHER FINANCING SOURCES        Transfers from Other Funds – 1) Density Transfer funds held in the Municipal Facilities CIP fund transferred to the General  Fund to be used for affordable housing grants in the amount of $515K; 2) funding for Municipal Facilities CIP project balances  reduced in response to COVID‐19 was transferred to the General Fund to offset revenue shortages in the amount of $1.8M;  3) the Housing Opportunity capital projects fund was closed and the fund balance was transferred to a management fund of  the General Fund in the amount of $2.6M; 4) $37,500 was transferred from the Renton Marketing Campaign balance in the  Hotel/Motel Tax Fund for the match on the Port of Seattle grant; and 5) the remaining balance of the Benson Hill Annexation  sales tax credit reserves held in the Insurance Fund was transferred to the General Fund to offset COVID‐19 revenue shortages  in the amount of $4.5M.    Transfers between the General Fund and its management funds are just under $6.1M at 9/30. 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).   2019 2020 2020 Actual Budget Actual $ % $ % Transfers from Other Funds 6,125,403$         15,494,506$       15,494,506$      9,369,104       153.0%‐                                0.0% Prior Period Adjustment 17                               ‐                                    ‐                                   (17)                       0.0%‐                                N/A Insurance Recoveries 5,221                        ‐                                   4,566                       (655)                     ‐12.5%4,566                    100.0% Sale of Capital Assets ‐                                    ‐                                   18,850                    18,850              100.0% 18,850                 100.0% YTD Total 6,130,641$         15,494,506$       15,517,922$      9,387,281$    153.1% 23,416$              0.2% Annual Total 13,137,402$      21,551,170$        Revenue 2020 vs. 2019 2020 vs. Budget Year to Date through September Other Financing Sources by Type Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 7 of 43   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        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        Expenditures related to the COVID‐19 pandemic have been accumulated within the Emergency Management accounts in  anticipation of billing these costs to the CARES Act grant received through the Department of Commerce. An adjustment to  the budget to account for the grant revenue and related expenditures will be presented to Council with the year‐end budget  adjustment proposal. At September 30 the unbudgeted COVID‐19 expenditures are approximately $238K in supplies and  $1.45M in contracted services (which includes small business grants).     Council Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 218,790$             337,867$            254,913$         248,537$          (29,747)$            ‐13.6%6,376$              2.5% Supplies 871                           1,400                     722                      808                        63                          7.2%(87)                        ‐12.0% Contracted Services 12,103                   23,316                  21,207               18,197                (6,094)                  ‐50.4%3,010                 14.2% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 40,778                   58,341                  43,755               43,755                (2,977)                  ‐7.3%0                           0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 272,542$             420,924$            320,597$         311,297$          (38,755)$            ‐14.2%9,300$              2.9% 2020 Prior Year YTD YTD Budget Variance Favorable (Unfavorable) Executive Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 658,164$             899,204$            663,007$         590,330$          67,833$            10.3% 72,676$           11.0% Supplies 2,379                      8,100                     4,562                  1,476                   903                       38.0% 3,086                 67.7% Contracted Services 809,611                1,366,407           939,505            866,693             (57,082)               ‐7.1%72,812              7.8% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 336,712                288,355               216,264            216,263             120,449            35.8% 1                           0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,806,865$         2,562,066$        1,823,338$    1,674,762$      132,103$         7.3% 148,576$        8.1% 2020 Prior Year YTD YTD Budget Variance Favorable (Unfavorable) Emergency Management Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 306,872$             486,384$            358,746$         354,350$          (47,477)$            ‐15.5%4,396$              1.2% Supplies 17,576                   28,500                  27,781               242,176             (224,600)            ‐1277.9% (214,395)          ‐771.7% Contracted Services 20,259                   11,361                  9,162                  1,490,722         (1,470,463)       ‐7258.4% (1,481,560)      ‐16170.9% Capital Outlay ‐                                  18,438                   ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 115,722                185,268               138,726            138,953             (23,231)               ‐20.1% (227)                     ‐0.2% Transfers Out ‐                                   ‐                                  ‐                              694                        (694)                     100.0%(694)                    100.0% Total Expenditures 460,428$             729,951$            534,414$         2,226,895$      (1,766,467)$    ‐383.7% (1,692,481)$   ‐316.7% 2020 Prior Year YTD YTD Budget Variance Favorable (Unfavorable) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 8 of 43   CITY ATTORNEY        Personnel ‐ The amount of personnel costs under the YTD 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        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.    City Attorney Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,584,646$         2,193,925$        1,636,723$    1,497,984$      86,662$            5.5% 138,739$        8.5% Supplies 661                           3,550                     2,137                  853                        (192)                      ‐29.0%1,284                 60.1% Contracted Services 20,334                   41,465                  24,148               14,487                5,847                  28.8% 9,661                 40.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 138,207                182,481               136,859            136,859             1,348                  1.0%(0)                          0.0% Transfers Out 4,150                       ‐                                  ‐                               ‐                               4,150                  100.0%‐                             0.0% Total Expenditures 1,747,999$         2,421,421$        1,799,867$    1,650,183$      97,816$            5.6% 149,684$        8.3% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Court Services Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,332,706$         2,203,800$        1,662,207$    1,465,506$      (132,800)$         ‐10.0%196,701$        11.8% Supplies 2,154                      7,700                     3,094                  1,197                   957                       44.4% 1,897                 61.3% Contracted Services 88,434                   106,856               72,515               67,003                21,431               24.2% 5,512                 7.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 343,948                388,339               291,255            291,255             52,693               15.3% 0                           0.0% Transfers Out ‐                                   ‐                                  ‐                              1,954                   (1,954)                 100.0%(1,954)               100.0% Total Expenditures 1,767,241$         2,706,695$        2,029,070$    1,826,914$      (59,672)$            ‐3.4%202,157$        10.0% Prior Year YTD YTD Budget Variance Favorable (Unfavorable) 2020 Community and Econ Dvlpmnt Admin Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 279,721$             389,402$            294,018$         288,490$          (8,769)$               ‐3.1%5,527$              1.9% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 550                           850                           ‐                              440                        110                       20.0%(440)                    100.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 787,846                989,334               742,001            742,002             45,844               5.8%(1)                          0.0% Transfers Out 87,261                   181,140               181,140            183,860             (96,599)               ‐110.7% (2,720)                ‐1.5% Total Expenditures 1,155,378$         1,560,726$        1,217,159$    1,214,792$      (59,414)$            ‐5.1%2,367$              0.2% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Development Services Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,579,352$         2,458,925$        1,819,955$    1,746,620$      (167,268)$         ‐10.6%73,335$           4.0% Supplies 4,334                      7,525                     5,263                  1,541                   2,793                  64.4% 3,722                 70.7% Contracted Services 76,039                   112,912               72,063               56,929                19,110               25.1% 15,134              21.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 46,931                   58,814                  44,111               44,111                2,820                  6.0%(0)                          0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,706,657$         2,638,176$        1,941,392$    1,849,201$      (142,544)$         ‐8.4%92,191$           4.7% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 9 of 43   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, and $141K 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 September   22, 2020. The amount of contracted services expenditures under the YTD budget is due to grants awarded to support low  income housing and other charitable construction projects that have not been paid out yet. These grants are subject to certain  performance measures being met by the grantee prior to the payment of the grant award.    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.    FINANCE        Personnel ‐ The amount of personnel costs under the YTD budget is due to open positions.       Economic Development Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 499,420$             940,340$            689,996$         636,628$          (137,207)$         ‐27.5%53,369$           7.7% Supplies 9,320                      35,625                  21,533               985                        8,335                  89.4% 20,548              95.4% Contracted Services 191,469                1,957,529           1,002,158       406,043             (214,574)            ‐112.1%596,115           59.5% Capital Outlay 38,794                   982,274               269,516            248,906             (210,112)            ‐541.6%20,610              7.6% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 739,004$             3,915,768$        1,983,204$    1,292,562$      (553,558)$         ‐74.9%690,642$        34.8% Variance Favorable (Unfavorable) Prior Year YTD YTD Budget2020 Planning Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 2,714,521$         4,008,905$        2,978,581$    2,904,469$      (189,949)$         ‐7.0%74,111$           2.5% Supplies 5,561                      11,600                  6,675                  2,299                   3,262                  58.7% 4,376                 65.6% Contracted Services 76,244                   249,492               142,847            69,839                6,405                  8.4% 73,008              51.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 24,962                   31,724                  23,793               23,793                1,169                  4.7%(1)                          0.0% Transfers Out ‐                                  57,700                   ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 2,821,288$         4,359,422$        3,151,895$    3,000,401$      (179,113)$         ‐6.3%151,494$        4.8% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Finance Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,471,884$         2,288,635$        1,721,324$    1,509,087$      (37,203)$            ‐2.5%212,237$        12.3% Supplies 2,219                      11,500                  6,201                  907                        1,312                  59.1% 5,294                 85.4% Contracted Services 429,179                1,028,521           474,535            515,118             (85,939)               ‐20.0% (40,583)             ‐8.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 298,019                380,345               285,261            285,262             12,757               4.3%(0)                          0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 2,201,301$         3,709,001$        2,487,322$    2,310,374$      (109,073)$         ‐5.0%176,947$        7.1% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 10 of 43   CITY CLERK        HUMAN RESOURCES        POLICE        Personnel ‐ The increase in salaries and benefits over the prior year is primarily the result of COLAs, annual step increases,  and the reclassification of the deputy chief and commander positions. The amount of salaries and benefits over the YTD  budget is due to a reduction of the annual budget to account for vacant positions that were frozen in response to COVID‐19  budget cuts. The YTD budget assumes the personnel costs are spread evenly throughout the year, but the savings from these  positions will all occur in the last half of the year. Personnel costs are expected to be under budget at the end of the year.     Contracted Services – The increase in contracted services over the prior year is due to an annual increase in dispatch services  payments of approximately $200K and a timing difference – the September 2019 dispatch services payment was not made  until October 2019. The amount of contracted services over the YTD budget is due to the timing of dispatch services  payments. This timing difference will correct itself by the end of the year.    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.       City Clerk Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 569,990$             723,688$            546,860$         544,280$          25,710$            4.5% 2,580$              0.5% Supplies 1,889                      4,094                     2,261                  941                        948                       50.2% 1,320                 58.4% Contracted Services 276,435                288,739               243,792            268,411             8,024                  2.9%(24,619)             ‐10.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 127,361                159,402               119,551            119,554             7,807                  6.1%(3)                          0.0% Transfers Out 770                            ‐                                  ‐                               ‐                               770                       100.0%‐                             0.0% Total Expenditures 976,446$             1,175,923$        912,463$         933,185$          43,260$            4.4%(20,722)$          ‐2.3% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Human Resources Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 756,359$             1,153,163$        857,667$         817,582$          (61,223)$            ‐8.1%40,085$           4.7% Supplies 13,468                   8,828                     7,066                  2,412                   11,056               82.1% 4,654                 65.9% Contracted Services 81,610                   130,663               89,455               49,751                31,859               39.0% 39,704              44.4% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 200,634                237,613               178,209            178,208             22,426               11.2% 1                           0.0% Transfers Out 5,720                       ‐                                  ‐                               ‐                               5,720                  100.0%‐                             0.0% Total Expenditures 1,057,790$         1,530,267$        1,132,397$    1,047,953$      9,837$               0.9% 84,444$           7.5% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Police Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 18,734,917$      25,260,867$     18,940,905$ 19,128,701$   (393,784)$         ‐2.1% (187,797)$       ‐1.0% Supplies 386,547                419,605               248,937            202,917             183,630            47.5% 46,020              18.5% Contracted Services 3,156,767            4,907,690           3,249,359       3,474,986         (318,219)            ‐10.1% (225,628)          ‐6.9% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 3,716,942            4,646,155           3,466,909       3,490,763         226,179            6.1%(23,854)             ‐0.7% Transfers Out 15,216                   846,143               837,113            837,113             (821,897)            ‐5401.7%‐                             0.0% Total Expenditures 26,010,388$      36,080,460$     26,743,222$ 27,134,480$   (1,124,092)$    ‐4.3% (391,258)$       ‐1.5% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 11 of 43   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 the YTD 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 is due to vacant positions.     Jail Services Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel ‐$                                ‐$                               ‐$                            ‐$                             ‐$                           0.0%‐$                          0.0% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 4,324,595            4,707,756           3,530,959       3,531,146         793,449            18.3%(187)                    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 4,324,595$         4,707,756$        3,530,959$    3,531,146$      793,449$         18.3%(187)$                 0.0% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Community Services Admin Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 255,822$             373,991$            281,813$         274,256$          (18,433)$            ‐7.2%7,557$              2.7% Supplies 5,008                      22,744                  18,859               1,393                   3,615                  72.2% 17,467              92.6% Contracted Services 15,277                   315                          172                      11,688                3,589                  23.5%(11,516)             ‐6698.9% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 107,204                123,869               92,902               92,900                14,305               13.3% 2                           0.0% Transfers Out 16,812                    ‐                                  ‐                              616                        16,196               96.3%(616)                    100.0% Total Expenditures 400,124$             520,919$            393,746$         380,852$          19,272$            4.8% 12,894$           3.3% 2020 Prior Year YTD Variance Favorable (Unfavorable) YTD Budget Leased Properties Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 108,178                176,062               130,364            130,614             (22,436)$            ‐20.7% (251)$                  ‐0.2% Supplies 6,888                      2,440                     1,823                  508                        6,380                  92.6% 1,316                 72.2% Contracted Services 377,702                656,768               486,972            345,158             32,544               8.6% 141,815           29.1% Capital Outlay ‐                             ‐                            ‐                        27,188                (27,188)              100.0%(27,188)            100.0% Debt Service ‐                            175,000                ‐                         ‐                          ‐                              0.0%‐                             0.0% Internal Services 2,093                      2,816                     2,111                  2,112                   (19)                         ‐0.9% (1)                          0.0% Transfers Out ‐                             ‐                            ‐                         ‐                          ‐                              0.0%‐                             0.0% Total Expenditures 494,861$             1,013,086$        621,271$         505,579$          (10,719)$            ‐2.2%115,691$        18.6% 2020 Prior Year YTD YTD Budget Variance Favorable (Unfavorable) Parks & Trails Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 2,312,833$         3,014,187$        2,246,636$    2,153,506$      159,327$         6.9% 93,129$           4.1% Supplies 155,317                200,434               147,206            122,597             32,720               21.1% 24,609              16.7% Contracted Services 542,436                697,451               550,182            480,835             61,601               11.4% 69,347              12.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 927,091                1,190,944           891,320            907,036             20,054               2.2%(15,716)             ‐1.8% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 3,937,676$         5,103,016$        3,835,344$    3,663,974$      273,702$         7.0% 171,370$        4.5% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 12 of 43   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 the YTD 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 the YTD budget is due to budgeted tree maintenance not yet performed.    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 the YTD budget is due to open positions.     Supplies – The decrease in supplies from the prior year and the amount of supplies under the YTD 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           Parks Planning & Natural Resources Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 502,616$             1,157,416$        852,823$         674,293$          (171,676)$         ‐34.2%178,531$        20.9% Supplies 811                           4,827                     2,985                  1,678                   (867)                      ‐106.8%1,307                 43.8% Contracted Services 541,685                1,207,061           860,701            652,529             (110,843)            ‐20.5%208,172           24.2% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 29,643                   45,488                  34,116               34,114                (4,471)                  ‐15.1%2                           0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,074,756$         2,414,791$        1,750,625$    1,362,614$      (287,857)$         ‐26.8%388,011$        22.2% Prior Year YTD Variance Favorable (Unfavorable) YTD Budget2020 Recreation & Neighborhoods Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 2,873,633$         2,734,261$        2,138,720$    1,959,634$      913,998$         31.8% 179,086$        8.4% Supplies 171,793                288,019               222,340            57,286                114,507            66.7% 165,054           74.2% Contracted Services 419,880                406,708               247,649            197,896             221,984            52.9% 49,752              20.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 1,365,827            1,447,735           1,085,799       1,085,800         280,027            20.5%(1)                          0.0% Transfers Out 96,517                   3,000                      ‐                               ‐                               96,517               100.0%‐                             0.0% Total Expenditures 4,927,650$         4,879,722$        3,694,508$    3,300,617$      1,627,033$     33.0% 393,891$        10.7% Variance Favorable (Unfavorable) 2020 YTD BudgetPrior Year YTD Human Services Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 426,037$             703,400$            522,522$         457,076$          (31,039)$            ‐7.3%65,447$           12.5% Supplies 8,713                      15,650                  10,569               4,290                   4,423                  50.8% 6,279                 59.4% Contracted Services 469,642                836,343               513,487            449,481             20,160               4.3% 64,005              12.5% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 81,497                   89,123                  66,843               66,930                14,567               17.9%(86)                        ‐0.1% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 985,889$             1,644,515$        1,113,421$    977,777$          8,112$               0.8% 135,645$        12.2% Variance Favorable (Unfavorable) YTD BudgetPrior Year YTD2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 13 of 43   MUSEUM        PUBLIC WORKS ADMIN        STREET MAINTENANCE        TRANSPORTATION        Personnel – The increase in salaries and benefits is due to two vacant positions in 2019 that are filled in 2020.    Contracted Services – The amount of contracted services under the YTD budget is due to decreased electricity charges for  signals and streetlights and decreased employee ORCA card purchases under the Commute Trip Reduction (CTR) program as  many employees are working from home due to the COVID‐19 pandemic.    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.  Museum Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 106,566$             134,675$            100,710$         101,806$          4,759$               4.5%(1,096)$             ‐1.1% 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 82,687                   90,520                  67,888               67,889                14,798               17.9%(1)                          0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 189,253$             225,195$            168,598$         169,695$          19,557$            10.3%(1,097)$             ‐0.7% Variance Favorable (Unfavorable) YTD BudgetPrior Year YTD2020 Public Works Admin Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 266,781$             374,676$            283,276$         213,035$          53,746$            20.1% 70,241$           24.8% Supplies 112                           800                          328                      449                        (337)                      ‐299.4% (121)                     ‐37.0% Contracted Services 1,773                      1,650                     1,587                  26,900                (25,127)               ‐1417.1% (25,313)             ‐1595.2% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 52,184                   65,423                  49,067               50,823                1,361                  2.6%(1,757)                ‐3.6% Transfers Out ‐                                   ‐                                  ‐                              1,137                   (1,137)                 100.0%(1,137)               100.0% Total Expenditures 320,851$             442,549$            334,257$         292,344$          28,507$            8.9% 41,914$           12.5% Variance Favorable (Unfavorable) BudgetPrior Year2020 Street Maintenance Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 2,106,027$         3,030,489$        2,257,814$    2,176,670$      (70,643)$            ‐3.4%81,144$           3.6% Supplies 279,439                279,798               235,478            309,430             (29,992)               ‐10.7% (73,952)             ‐31.4% Contracted Services 757,523                1,133,781           795,105            763,520             (5,998)                  ‐0.8%31,585              4.0% Capital Outlay ‐                                  5,200                      ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 969,374                1,142,386           866,950            882,502             86,872               9.0%(15,552)             ‐1.8% Transfers Out ‐                                   ‐                                  ‐                              4,811                   (4,811)                 100.0%(4,811)               100.0% Total Expenditures 4,112,362$         5,591,654$        4,155,348$    4,136,933$      (24,571)$            ‐0.6%18,414$           0.4% Prior Year YTD2020 YTD Budget Variance Favorable (Unfavorable) Transportation Summary of Uses 2019 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 3,016,162$         4,487,507$        3,307,059$    3,230,433$      (214,271)$         ‐7.1%76,626$           2.3% Supplies 205,902                223,252               158,926            143,607             62,295               30.3% 15,319              9.6% Contracted Services 669,507                945,974               734,483            574,248             95,259               14.2% 160,235           21.8% Capital Outlay ‐                                   ‐                                  ‐                              13,818                (13,818)              100.0%(13,818)            100.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 547,075                642,453               482,077            482,470             64,605               11.8%(393)                     ‐0.1% Transfers Out 4,136                      760,000               762,959            762,959             (758,823)            ‐18349.0%‐                             0.0% Total Expenditures 4,442,782$         7,059,187$        5,445,505$    5,207,535$      (764,753)$         ‐17.2%237,970$        4.4% Prior Year YTD2020 Variance Favorable (Unfavorable) YTD Budget Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 14 of 43   NON‐DEPARTMENTAL AND OTHER        Personnel ‐ The amount of personnel expenditures under the prior year and YTD budget is due to savings from expected  employee separation payments.     Contracted Services – The amount of contracted services under the YTD budget is due to a $1.8M contingency reserve that  has been set aside for unanticipated costs related to the SCORE.    Transfers Out – Transfers Out have a net decrease from prior year due to 1) an increase in property tax transferred to support  General Fund management funds (001, 003, 005) in the amount of $189K, 2) an increase in property tax transferred to capital  funds in the amount of $662K, 3) a decrease in B&O tax transferred to capital funds in the amount of $2M, 4) an increase in  REET transferred to capital funds in the amount of $281K, and 5) an increase in LRF Sales & Use Tax transferred to the debt  service fund in the amount of $328K.    Transfers between the General Fund and its management funds are just under $6.1M at 9/30. 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 September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 2,158,401$         2,407,200$        1,814,817$    1,647,385$      511,017$         23.7% 167,432$        9.2% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 153,739                1,979,919           1,796,376       152,880             859                       0.6% 1,643,497      91.5% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 11,873                   18,828                  14,122               14,121                (2,248)                  ‐18.9%1                           0.0% Transfers Out 11,620,161         22,343,484        11,081,531    11,081,531      538,631            4.6%‐                             0.0% Total Expenditures 13,944,175$      26,749,431$     14,706,846$ 12,895,916$   1,048,259$     7.5% 1,810,930$   12.3% Prior Year YTD2020 Variance Favorable (Unfavorable) YTD Budget Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 15 of 43   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.        Interest – The increase in interest over the prior year is due to LRF and Parks bonds issued in 2019.    Transfers In – The decrease in transfers in from the prior year is primarily due to timing of the transfers.          2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes ‐$                             ‐$                              ‐$                     ‐$                    ‐$                     N/A Grants / intergovernmental 63,526                   56,930                    28,678           (34,848)         (28,252)           50.37% Charges for services 372,059                386,827                  386,827         14,768           ‐                        100.00% Investment Earnings 37,019                    ‐                                28,545           (8,474)           28,545            N/A TOTAL REVENUES 472,604                443,757                  444,050         (28,554)         293                  100.07% EXPENDITURES: Principal 567,947                5,405,922               580,922         (12,975)         4,825,000       10.75% Interest 645,319                1,756,464               978,142         (332,823)      778,322          55.69% TOTAL EXPENDITURES 1,213,266             7,162,386               1,559,064      (345,798)      5,603,322       21.77% TRANSFERS IN 3,752,828             7,699,250               2,850,961      (901,867)      (4,848,289)     37.03% NET TRANSFERS 3,752,828             6,809,447               2,850,961      (901,867)      (3,958,486)     41.87% CHANGE IN FUND BALANCE 3,012,167             90,818                    1,735,947      (1,276,220)   1,645,129       1911.46% BEGINNING FUND BALANCE, Jan 1 2,307,173             3,999,457               3,999,457      1,692,284     ‐                        100.00% ENDING FUND BALANCE, Sep 30 5,319,340$           4,090,275$            5,735,404$   416,064$     1,645,129$    140.22% VARIANCE FAVORABLE (UNFAVORABLE) GENERAL GOVERNMENTAL MISCELLANEOUS DEBT Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 16 of 43   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.    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.       2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 370,187$              200,000$                179,305$              (190,882)$             (20,695)$               89.65% Contributions 24,000                    ‐                                30,000                   6,000                     30,000                   N/A Investment Earnings 8,283                      ‐                                6,409                     (1,874)                    6,409                     N/A TOTAL REVENUES 402,470                200,000                   215,714                (186,756)               15,714                   107.86% EXPENDITURES: Contracted Services 201,644                429,062                   201,161                483                        227,901                46.88% TOTAL EXPENDITURES 201,644                429,062                   201,161                483                        227,901                46.88% TRANSFERS OUT ‐                              37,500                     37,500                   37,500                    ‐                              100.00% NET TRANSFERS ‐                              (37,500)                    (37,500)                 (37,500)                  ‐                              N/A CHANGE IN FUND BALANCE 200,826                (266,562)                 (22,947)                 (223,773)               243,615                8.61% BEGINNING FUND BALANCE, Jan 1 722,387                943,889                   943,889                221,502                 ‐                              130.66% ENDING FUND BALANCE, Sep 30 923,213$              677,327$                920,942$              (2,271)$                 243,615$              99.75% VARIANCE FAVORABLE (UNFAVORABLE) HOTEL/MOTEL 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 902$                       ‐$                              1,025$                   123$                      1,025$                   N/A TOTAL REVENUES 902                         ‐                                1,025                     123                        1,025                     N/A EXPENDITURES: Supplies ‐                              200                          90                           (90)                         110                        45.00% Contracted Services ‐                              183,460                  48,568                   (48,568)                 134,892                26.47% Capital Outlay 123,813                88,130                      ‐                              123,813                88,130                   0.00% TOTAL EXPENDITURES 123,813                271,790                  48,658                   75,155                   223,132                17.90% TRANSFERS IN 83,000                   180,660                  180,660                97,660                   (0)                            100.00% NET TRANSFERS 83,000                   180,660                  180,660                97,660                    ‐                              100.00% CHANGE IN FUND BALANCE (39,911)                 (91,130)                   133,027                172,938                224,157                 ‐145.97% BEGINNING FUND BALANCE, Jan 1 119,446                98,865                     98,865                   (20,581)                  ‐                              100.00% ENDING FUND BALANCE, Sep 30 79,535$                7,735$                     231,892$              152,357$              224,157$              2997.96% MUNICIPAL ART VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 17 of 43   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.        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.          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 64,179                   57,674                      60,877                   (3,302)                    3,203                     105.55% Investment Earnings 5,840                      ‐                                  4,049                     (1,791)                    4,049                     N/A TOTAL REVENUES 110,019                57,674                      64,926                   (45,092)                 7,252                     112.57% EXPENDITURES: Personnel 9,314                      ‐                                   ‐                              (9,314)                     ‐                              N/A Supplies ‐                              6,302                          ‐                               ‐                              6,302                     0.00% Contracted Services 31,022                   51,372                      29,830                   (1,192)                    21,542                   58.07% Capital Outlay 108                        40,000                       ‐                              (108)                       40,000                   0.00% TOTAL EXPENDITURES 40,444                   97,674                      29,830                   (10,614)                 67,844                   30.54% NET TRANSFERS ‐                              40,000                       ‐                               ‐                               ‐                              0.00% CHANGE IN FUND BALANCE 69,575                    ‐                                  35,096                   (34,478)                 35,096                   N/A BEGINNING FUND BALANCE, Jan 1 529,159                603,760                    603,760                74,601                    ‐                              100.00% ENDING FUND BALANCE, Sep 30 598,734$              603,760$                  638,856$              40,122$                35,096$                105.81% CABLE COMMUNICATIONS VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 3,365$                    ‐$                               2,251$                   (1,114)$                 2,251$                   N/A TOTAL REVENUES 3,365                      ‐                                 2,251                     (1,114)                    2,251                     N/A TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                                  ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 3,365                      ‐                                 2,251                     (1,114)                    2,251                     N/A BEGINNING FUND BALANCE, Jan 1 340,895                345,658                   345,658                4,763                      ‐                              100.00% ENDING FUND BALANCE, Sep 30 344,260$              345,658$                 347,909$              3,649$                   2,251$                   100.65% SPRINGBROOK WETLANDS VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 18 of 43   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.        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.         2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Contributions ‐$                             ‐$                               8,716$                   8,716$                   8,716$                   N/A Investment Earnings ‐                               ‐                                 1,613                     1,613                     1,613                     N/A TOTAL REVENUES ‐                               ‐                                 10,329                   10,329                   10,329                   N/A EXPENDITURES: Supplies ‐                              711,102                   34,869                   34,869                   (676,233)               4.90% Contracted Services ‐                               ‐                                 20,580                   20,580                   20,580                   N/A Capital Outlay ‐                               ‐                                 7,307                     7,307                     7,307                     N/A TOTAL EXPENDITURES ‐                              711,102                   62,756                   62,756                   648,346                8.83% TRANSFERS IN ‐                              711,102                   711,102                711,102                 ‐                              100.00% NET TRANSFERS ‐                              711,102                   711,102                711,102                 ‐                              100.00% CHANGE IN FUND BALANCE ‐                               ‐                                 658,675                658,675                658,675                N/A BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Sep 30 ‐$                             ‐$                               658,675$              658,675$              658,675$              N/A POLICE SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Contributions ‐$                             ‐$                               15,184$                15,184$                15,184$                N/A Investment Earnings ‐                               ‐                                 311                        311                        311                        N/A TOTAL REVENUES ‐                               ‐                                 15,495                   15,495                   15,495                   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                   140,005                140,005                13,994                   111.11% BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Sep 30 ‐$                            126,011$                 140,005$              140,005$              13,994$                111.11% POLICE CSAM SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 19 of 43   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 321,093$              86,500$                  505,723$              184,630$              419,223$              584.65% Investment Earnings 27,533                    ‐                                13,940                   (13,593)                 13,940                   N/A TOTAL REVENUES 348,626                86,500                     519,663                171,037                433,163                600.77% TOTAL EXPENDITURES ‐                               ‐                                 ‐                               ‐                               ‐                              N/A TRANSFERS OUT ‐                              945,909                   ‐                               ‐                              945,909                0.00% NET TRANSFERS ‐                              (945,909)                  ‐                               ‐                              945,909                0.00% CHANGE IN FUND BALANCE 348,626                (859,409)                 519,663                171,037                1,379,072              ‐60.47% BEGINNING FUND BALANCE, Jan 1 2,578,256             1,886,999               1,886,999             (691,257)                ‐                              100.00% ENDING FUND BALANCE, Sep 30 2,926,882$           1,027,590$             2,406,662$           (520,220)$             1,379,072$           234.20% 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,586,813$           1,435,875$              1,691,032$           104,219$              255,157$              117.77% Investment Earnings 39,080                    ‐                                 22,675                   (16,405)                 22,675                   N/A TOTAL REVENUES 1,625,893             1,435,875                1,713,707             87,814                   277,832                119.35% TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS OUT ‐                              1,811,987                 ‐                               ‐                              1,811,987             0.00% NET TRANSFERS ‐                              (1,811,987)                ‐                               ‐                              1,811,987             0.00% CHANGE IN FUND BALANCE 1,625,893             (376,112)                  1,713,707             87,814                   2,089,819              ‐455.64% BEGINNING FUND BALANCE, Jan 1 3,332,524             2,942,344                2,942,344             (390,180)                ‐                              100.00% ENDING FUND BALANCE, Sep 30 4,958,417$           2,566,232$              4,656,051$           (302,366)$             2,089,819$           181.44% TRANSPORTATION IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 20 of 43   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$              2,233,375$           2,233,375$           233,375$              111.67% Investment Earnings ‐                               ‐                                 5,775                     5,775                     5,775                     N/A TOTAL REVENUES ‐                              2,000,000                2,239,150             2,239,150             239,150                111.96% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS IN ‐                              1,143,855                1,143,855             1,143,855              ‐                              100.00% TRANSFERS OUT ‐                              1,775,000                 ‐                               ‐                              1,775,000             0.00% NET TRANSFERS ‐                              (631,145)                  1,143,855             1,143,855             1,775,000              ‐181.23% CHANGE IN FUND BALANCE ‐                              1,368,855                3,383,005             3,383,005             2,014,150             247.14% BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Sep 30 ‐$                            1,368,855$              3,383,005$           3,383,005$           2,014,150$           247.14% REET 1 VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes ‐$                            2,000,000$              2,233,375$           2,233,375$           233,375$              111.67% Investment Earnings ‐                               ‐                                 5,775                     5,775                     5,775                     N/A TOTAL REVENUES ‐                              2,000,000                2,239,150             2,239,150             239,150                111.96% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS IN ‐                              1,143,855                1,143,855             1,143,855             (0)                            100.00% TRANSFERS OUT ‐                              1,775,000                 ‐                               ‐                              1,775,000             0.00% NET TRANSFERS ‐                              (631,145)                  1,143,855             1,143,855             1,775,000              ‐181.23% CHANGE IN FUND BALANCE ‐                              1,368,855                3,383,005             3,383,005             2,014,150             247.14% BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Sep 30 ‐$                            1,368,855$              3,383,005$           3,383,005$           2,014,150$           247.14% REET 2 VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 21 of 43   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 September  30 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 576,619$              3,760,752$            555,083$              (21,536)$               (3,205,669)$         14.76% Charges for services 10,643                    ‐                               140                        (10,503)                 140                        N/A Sale of general fixed assets 160,000                160,000                 560,000                400,000                400,000                350.00% Contributions (37,495)                 11,000                     ‐                              37,495                   (11,000)                 0.00% Investment Earnings 288,922                175,910                 176,405                (112,517)               495                        100.28% TOTAL REVENUES 1,003,029             4,107,662              1,291,628             288,599                (2,816,034)            31.44% EXPENDITURES: Personnel 272,738                746,459                 381,069                108,331                365,390                51.05% Supplies 126,830                878,203                  ‐                              (126,830)               878,203                0.00% Contracted Services 172,865                689,441                 408,562                235,697                280,879                59.26% Capital Outlay 7,449,496             27,533,280            5,148,686             (2,300,810)            22,384,594           18.70% TOTAL EXPENDITURES 8,021,929             29,847,383            5,938,317             (2,083,612)            23,909,066           19.90% TRANSFERS IN ‐                              2,772,909               ‐                               ‐                              (2,772,909)            0.00% TRANSFERS OUT 6,378                     2,323,680              2,323,680             2,317,302              ‐                              100.00% NET TRANSFERS (6,378)                    449,229                 (2,323,680)            (2,317,302)            (2,772,909)             ‐517.26% CHANGE IN FUND BALANCE (7,025,278)            (25,290,492)          (6,970,369)            54,909                   18,320,123           27.56% BEGINNING FUND BALANCE, Jan 1 20,675,238           26,395,567            26,395,567           5,720,329              ‐                              100.00% ENDING FUND BALANCE, Sep 30 13,649,960$        1,105,075$            19,425,198$        5,775,238$           18,320,123$        1757.82% MUNICIPAL FACILITIES CIP VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 22 of 43   Municipal Facilities CIP Fund (continued)             PROJECT BUDGET ACTUAL BALANCE CAPITAL PROJECT COORDINATORS 746,459$ 381,069$ 365,390$ SALE OF PARK LAND COSTS 10,000 10,000 - SUNSET NEIGHBORHOOD PARK ART 224,100 36,801 187,299 CITY HALL ELEVATORS 2,079,704 343,861 1,735,843 SENIOR ACTIVITY CENTER - 1,641 (1,641) 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 - 957,962 CITY HALL MAJOR HVAC AND FIRE COMP REPL 1,796,262 47,658 1,748,604 4TH FLOOR REMODEL AND POLICE TRAINING CENTER 210,371 414,496 (204,125) BOATHOUSE 323,248 307,751 15,497 HENRY MOSES AQUATIC CENTER 88,644 - 88,644 PARKS RECREATION AND OPEN SPACE PLAN 8,730 8,730 - REGIS PARK ATHLETIC FIELD EXPANSION 300,000 32,161 267,839 SPORT COURT IMPROVEMENTS 150,000 - 150,000 PARKING LOT AND DRIVEWAY REPAIRS 90,000 - 90,000 PATHWAY SIDEWALK PATIO BOARDWALK REPLACE 265,215 - 265,215 IRRIGATION AUTOMATION & CONSERVATION 12,072 - 12,072 URBAN FORESTRY PROGRAM 106,044 - 106,044 PARKS MM - PLAYGRDS, KIOSKS & INT SIGNS 605,640 - 605,640 PARKS MM - LIGHT SYSTEM UPGRADES 110,000 - 110,000 PARKS MM - SHORELINE AND BANK STABILIZAT 182,500 - 182,500 PARKS MM - STRUCTURAL REVIEWS & REPAIRS 579,667 389,832 189,835 SUNSET EIS PARK 4,626,344 2,784,418 1,841,926 COULON PARK STRUCTURAL IMPROVEMENTS 1,038 1,038 - COULON PARK LIGHTING REPAIRS 34,415 - 34,415 COULON PARK TURF REPLACEMENT 124,788 - 124,788 COULON SWIM BEACH 250,000 - 250,000 LIBERTY PARK IMPROVEMENTS 1,551,852 - 1,551,852 TRANSPORTATION LANDSCAPE 90,000 - 90,000 PHILIP ARNOLD PARK IMPROVEMENTS 5,500,000 119,761 5,380,239 COULON - ROSEWALL 50,000 7,775 42,225 COULON - SHORELINE EROSION 100,000 - 100,000 KIWANIS PARK 4,200,388 155,822 4,044,566 COULON - WATERWALK 1,639,975 126,045 1,513,930 COULON - TRESTLE BRIDGE 1,542,881 53,793 1,489,088 FAWCETT PROPERTY PURCHASE ROFR 611,364 602,797 8,567 TOTAL PROJECT BALANCES 29,847,383$ 5,938,317$ 23,909,066$ MUNICIPAL FACILITIES CIP PROJECT BUDGETS AT SEPTEMBER 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 23 of 43   Capital Improvement Fund  This fund accounts for the City’s Transportation capital projects.         A listing of project budgets and balances at September 30 is provided on the following page.    2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 775,703$              22,131,453$        1,372,736$           597,033$              (20,758,717)$       6.20% Charges for services ‐                              250,000                250,000                250,000                 ‐                              100.00% Fines and penalties 50,586                   7,200                     21,622                   (28,964)                 14,422                   300.31% Contributions 238,517                 ‐                               ‐                              (238,517)                ‐                              N/A Investment Earnings 97,588                   70,000                   120,484                22,896                   50,484                   172.12% TOTAL REVENUES 1,162,394             22,458,653           1,764,842             602,448                (20,693,811)         7.86% EXPENDITURES: Personnel 93,948                   56,000                   80,879                   (13,069)                 (24,879)                 144.43% Supplies 44,903                    ‐                              147,946                103,043                (147,946)               N/A Contracted Services 25,969                    ‐                              107,700                81,731                   (107,700)               N/A Capital Outlay 3,332,588             45,242,768           4,508,948             1,176,360             40,733,820           9.97% TOTAL EXPENDITURES 3,497,408             45,298,768           4,845,473             1,348,065             40,453,295           10.70% TRANSFERS IN 2,000,000             4,669,687             760,000                (1,240,000)            (3,909,687)            16.28% NET TRANSFERS 2,000,000             4,669,687             760,000                (1,240,000)            (3,909,687)            16.28% CHANGE IN FUND BALANCE (335,014)               (18,170,428)         (2,320,631)            (1,985,617)            15,849,797           N/A BEGINNING FUND BALANCE, Jan 1 5,492,313             18,947,853           18,947,853           13,455,540            ‐                              100.00% ENDING FUND BALANCE, Sep 30 5,157,299$           777,425$              16,627,222$        11,469,923$        15,849,797$        2138.76% CAPITAL IMPROVEMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 24 of 43   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 34,947 65,053 BRIDGE INSPECTION & REPAIR 236,916 33,626 203,290 ROADWAY SAFETY & GUARDRAIL 54,407 - 54,407 I-405/44TH GATEWAY SIGNAGE 57,700 - 57,700 RENTON CONNECTOR 1,593,294 10,036 1,583,258 STREET OVERLAY PGM 1,705,830 196,976 1,508,854 TRAFFIC SAFETY PGM 260,507 133,252 127,255 PROJ DEV & PRE-DESIGN 130,000 19,764 110,236 SO 7TH ST 135,000 - 135,000 ITS PGM 159,891 133,763 26,128 RENTON AVE EXT PRES 778,082 252,944 525,138 SW GRADY WAY PRES 7,603 7,706 (103) DUVALL AVE NE PRES - 507 (507) PARK AVE EXTENSION 7,712,602 207,279 7,505,323 RAINIER AVE S/N PHASE 4 5,689,029 803,973 4,885,056 INTERSECT SAFETY & MOBILITY 386,934 99,717 287,217 NE 31ST ST BRIDGE REPLACEMENT 251,030 2,006 249,024 N 27TH PL CULVERT SCOUR REPAIR 71,719 4,261 67,458 DUVALL AVE 7TH TO SUNSET 6,910,089 315,585 6,594,504 BARRIER FREE 85,000 5,849 79,151 SIDEWALK REHAB 100,000 - 100,000 LAKE WASHINGTON LOOP TRAIL 1,099,156 69,278 1,029,878 HIGHLANDS TO LANDING 533,310 97,592 435,718 SUNSET BLVD CORRIDOR 1,644,769 202,802 1,441,967 PRES OF TOD 245,001 105,595 139,406 WILLIAMS AVE S & WELLS AVE S CONV 10,385,423 1,572,587 8,812,836 ARTERIAL REHAB - SW 43RD 220,000 66,361 153,639 BRONSON BRIDGE 611,235 102,205 509,030 HOUSER WAY N BRIDGE 590,985 70,578 520,407 WILLIAMS BRIDGE 713,535 52,374 661,161 NILE BRIDGE 50,000 - 50,000 S 2ND STREET CONVERSION 1,540,750 3,902 1,536,848 HOUSER WAY INT & PED IMP 814,625 74,781 739,844 RENTON SCHOOL CROSSINGS 195,022 165,227 29,795 TOTAL PROJECT BALANCES 45,298,768$ 4,845,473$ 40,453,295$ CAPITAL IMPROVEMENT PROJECT BUDGETS AT SEPTEMBER 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 25 of 43   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 26,816$                6,309$                   6,309$                   (20,507)$                ‐$                            100.00% TOTAL REVENUES 26,816                   6,309                     6,309                     (20,507)                  ‐                              100.00% EXPENDITURES: Contracted Services 42,984                    ‐                               ‐                              (42,984)                  ‐                              N/A TOTAL EXPENDITURES 42,984                    ‐                               ‐                              (42,984)                  ‐                              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 (16,168)                 (2,570,350)            (2,570,350)            2,599,136              ‐                              N/A BEGINNING FUND BALANCE, Jan 1 2,582,203             2,570,350             2,570,350             (11,853)                  ‐                              100.00% ENDING FUND BALANCE, Sep 30 2,566,035$            ‐$                             ‐$                            2,587,283$            ‐$                            N/A HOUSING OPPORTUNITY VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 3,553$                    ‐$                            271$                      (3,282)$                 271$                      N/A TOTAL REVENUES 3,553                      ‐                              271                        (3,282)                    271                        N/A TOTAL EXPENDITURES ‐                               ‐                               ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                               ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 3,553                      ‐                              271                        (3,282)                    271                        N/A BEGINNING FUND BALANCE, Jan 1 456,591                16,408                   16,408                   (440,183)                ‐                              100.00% ENDING FUND BALANCE, Sep 30 460,144$              16,408$                16,679$                (443,465)$             271$                      101.65% NEW LIBRARY DEVELOPMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 26 of 43   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                    ‐                               ‐                              (37,495)                  ‐                              N/A Investment Earnings 44,756                    ‐                              54,501                   9,745                     54,501                   N/A TOTAL REVENUES 82,251                   75,000                   54,501                   (27,750)                 (20,499)                 72.67% EXPENDITURES: Capital Outlay 310,175                648,948                259,310                (50,865)                 389,638                39.96% TOTAL EXPENDITURES 354,753                648,948                259,310                (95,443)                 389,638                39.96% NET TRANSFERS ‐                               ‐                               ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE (272,502)               (573,948)               (204,809)               67,693                   369,139                N/A BEGINNING FUND BALANCE, Jan 1 4,193,806             8,551,401             8,551,401             4,357,595              ‐                              100.00% ENDING FUND BALANCE, Sep 30 3,921,304$           7,977,453$           8,346,592$           4,425,288$           369,139$              104.63% FAMILY FIRST CENTER VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 27 of 43   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 Projects”.     Airport Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Renton Municipal Airport.           2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 214,009$          ‐$                              ‐$                       (214,009)$         ‐$                       N/A Charges for services 222,066           145,557                  70,084              (151,982)          (75,473)            48.15% Rents, leases, and misc fees 2,129,042        2,902,353               2,212,475        83,433              (689,878)          76.23% Interest and other misc 58,030              3,857                       42,954              (15,076)            39,097              1113.66% TOTAL REVENUES 2,623,764        3,051,767               2,325,513        (298,251)          (726,254)          76.20% EXPENSES: Personnel 817,644           1,109,685               674,075           143,569           435,610           60.74% Supplies 33,737              43,500                    22,085              11,652              21,415              50.77% Contracted Services 471,249           491,088                  273,775           197,474           217,313           55.75% Internal Services 238,741           310,765                  235,446           3,295                75,319              75.76% TOTAL OPERATING EXPENSES 1,561,371        1,955,038               1,205,381        355,990           749,657           61.66% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,062,393        1,096,729               1,120,132        57,739              23,403              102.13% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 163,586           5,893,387               223,324           (59,738)            5,670,063        3.79% TRANSFERS OUT ‐                          ‐                                1,363                (1,363)               (1,363)               N/A NET TRANSFERS ‐                          ‐                                (1,363)               (1,363)               (1,363)               N/A CHANGE IN FUND BALANCE 898,807           (4,796,658)             895,445           (3,362)               5,692,103        N/A BEGINNING FUND BALANCE, Jan 1 4,985,377        6,259,402               6,259,402        1,274,025         ‐                         100.00% ENDING FUND BALANCE, Sep 30 5,884,184$      1,462,744$            7,154,847$      1,270,663$      5,692,103$      489.14% VARIANCE AIRPORT PROJECT BUDGET ACTUAL BALANCE MAINTENANCE DREDGING & SHORELINE MITIGAT 60,050$ -$ 60,050$ AIRPORT OFFICE REHAB 2,763,289 44,973 2,718,316 MAJOR FACILITY MAINTENANCE 357,263 105,777 251,486 PAVEMENT MANAGEMENT PROGRAM 255,930 - 255,930 SNOW REMOVAL EQUIPMENT 167,000 - 167,000 MASTER PLAN UPDATE 103,850 62,730 41,120 TAXIWAY ALPHA REHABILITATION 1,115,495 - 1,115,495 RUNWAY SAFETY AREA 774,360 - 774,360 ENVIRONMENTAL IMPACT STUDY 400,000 - 400,000 TOTAL PROJECT BALANCES 5,997,237$ 213,480$ 5,783,757$ Non-capital items included in project budgets (103,850) (20,806) (83,044) Operating fund equipment purchase - 30,650 (30,650) TOTAL CAPITAL OUTLAY 5,893,387$ 223,324$ 5,670,063$ AIRPORT PROJECT BALANCES AT SEPTEMBER 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 28 of 43   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.         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.    Contracted Services ‐ The increase in contracted services expense over the prior year is due to increased payments to the  garbage contractor, which directly relates to the increased rates, as noted above.    Capital Outlay  ‐ The Solid Waste Fund does not have a capital fund.     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 15,248,045      19,343,186            15,587,987      339,942           (3,755,199)       80.59% Interest and other misc 24,241              5,000                       20,695              (3,546)               15,695              413.90% TOTAL REVENUES 15,439,439      19,616,817            15,698,346      258,907           (3,918,471)       80.02% EXPENSES: Personnel 432,482           579,726                  426,817           5,665                152,909           73.62% Supplies 6,088                10,171                    3,252                2,836                6,919                31.97% Contracted Services 13,863,315      18,338,705            13,634,509      228,806           4,704,196        74.35% Internal Services 355,384           438,482                  340,558           14,826              97,924              77.67% TOTAL OPERATING EXPENSES 14,657,269      19,367,084            14,405,136      252,133           4,961,948        74.38% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 782,170           249,733                  1,293,210        511,040           1,043,477        517.84% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 782,170           249,733                  1,293,210        511,040           1,043,477        517.84% BEGINNING FUND BALANCE, Jan 1 2,276,333        2,266,127               2,266,127        (10,206)             ‐                         100.00% ENDING FUND BALANCE, Sep 30 3,058,503$      2,515,860$            3,559,337$      500,834$         1,043,477$      141.48% SOLID WASTE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 29 of 43   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,672,980$      2,294,800$            1,787,980$      115,000$         (506,820)$        77.91% Rents, leases, and misc fees 385,657           500,750                  276,076           (109,581)          (224,674)          55.13% Interest and other misc 6,773                1,370                       2,667                (4,106)               1,297                194.67% TOTAL REVENUES 2,065,410        2,796,920               2,066,723        1,313                (730,197)          73.89% EXPENSES: Personnel 1,126,902        1,512,192               1,070,421        56,481              441,771           70.79% Supplies 276,517           321,500                  242,422           34,095              79,078              75.40% Contracted Services 187,494           205,050                  126,244           61,250              78,806              61.57% Internal Services 189,642           341,940                  256,533           (66,891)            85,407              75.02% TOTAL OPERATING EXPENSES 1,780,555        2,380,682               1,695,620        84,935              685,062           71.22% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 284,855           416,238                  371,103           86,248              (45,135)            89.16% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 14,140              20,000                     ‐                         14,140              20,000              0.00% TRANSFERS IN 54,000              76,000                    57,000              3,000                (19,000)            75.00% TRANSFERS OUT 54,000              76,000                    59,695              (5,695)               16,305              78.55% NET TRANSFERS ‐                          ‐                                (2,695)               (2,695)               (2,695)               N/A CHANGE IN FUND BALANCE 270,715           396,238                  368,408           97,693              (27,830)            92.98% BEGINNING FUND BALANCE, Jan 1 110,812           173,750                  173,750           62,938               ‐                         100.00% ENDING FUND BALANCE, Sep 30 381,527$         569,988$                542,158$         160,631$         (27,830)$          95.12% GOLF COURSE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 30 of 43   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 decrease in amounts billed through September 30 of only $34K, receipts associated with these billings have decreased   $725K 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.     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 to combination of contracted services  and external taxes that have decreased due to COVID‐19.    Capital Outlay ‐ A listing of project budgets and balances at September 30 is provided on the following page.        2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 13,446,578$   19,180,991$          12,721,901$   (724,677)$        (6,459,090)$    66.33% Fines and penalties ‐                          ‐                                5,600                5,600                5,600                N/A Rents, leases, and misc fees 157,766           136,591                  232,204           74,438              95,613              170.00% Interest and other misc 785,585           199,070                  637,326           (148,259)          438,256           320.15% TOTAL REVENUES 14,389,929      19,516,652            13,597,031      (792,898)          (5,919,621)       69.67% EXPENSES: Personnel 3,216,479        4,640,953               3,226,180        (9,701)               1,414,773        69.52% Supplies 667,056           833,418                  595,044           72,012              238,374           71.40% Contracted Services 2,390,178        3,193,299               2,231,475        158,703           961,824           69.88% Internal Services 1,647,702        2,185,563               1,550,720        96,982              634,843           70.95% TOTAL OPERATING EXPENSES 7,921,415        10,853,233            7,603,419        317,996           3,249,814        70.06% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 6,468,514        8,663,419               5,993,612        (474,902)          (2,669,807)       69.18% DEBT SERVICE: Principal 345,818           1,540,568               345,818            ‐                         1,194,750        22.45% Interest 111,973           241,747                  105,595           6,378                136,152           43.68% TOTAL DEBT SERVICE 457,791           1,782,315               451,413           6,378                1,330,902        25.33% CAPITAL OUTLAY 3,352,288        37,304,963            2,369,026        983,262           34,935,937      6.35% TRANSFERS OUT ‐                          ‐                                330                   (330)                  (330)                  N/A NET TRANSFERS ‐                          ‐                                (330)                  (330)                  (330)                  N/A CHANGE IN FUND BALANCE 2,658,435        (30,423,859)           3,172,843        514,408           33,596,702      N/A BEGINNING FUND BALANCE, Jan 1 38,002,973      37,569,067            37,569,067      (433,906)           ‐                         100.00% ENDING FUND BALANCE, Sep 30 40,661,408$   7,145,208$            40,741,910$   80,502$           33,596,702$   570.20% WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 31 of 43   Water Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE PIPE OVERSIZING COSTS 100,000$ -$ 100,000$ TELEMETRY IMPROVEMENTS-PHASE 4 250,000 5,732 244,268 WATER SYSTEM PLAN UPDATE 200,000 53,223 146,777 UPDATE EMERGENCY RESPONSE PLAN 250,000 15,642 234,358 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 173,731 3,326,269 GPS & GIS DATABASE/CONVERSION - (4,432) 4,432 WATER PUMP STATIONS REHAB 400,000 - 400,000 RESERVOIR PRV METERS 300,000 12,164 287,836 MPLWD WATER TREATMENT IMPROV - CONST 770,000 68,881 701,119 MAPLEWOOD PUMP STATION ROOF REPLACEMENT - 15,401 (15,401) 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 - 300,000 WATER SYSTEM SECURITY IMPROVEMENTS 100,000 - 100,000 AQUIFER MONITORING AND MANAGEMENT 30,000 - 30,000 WATER TREATMENT FILTER MEDIA 400,000 6,092 393,908 WSDOT I-405 WATER RELOCATIONS 300,000 10,508 289,492 AUTOMATIC METER READING CONVERSION 85,000 38,885 46,115 TRANSMISSION MAIN REPLACEMENT - (248) 248 HIGHLANDS 435-RESERVOIRS REPLACEMENT 23,100,000 19,363 23,080,637 RAINIER AVE S ROAD & UTILITIES IMPRVMNT 300,000 - 300,000 KENNYDALE 320-RESERVOIR 4,000,000 1,982,236 2,017,764 TOTAL PROJECT BALANCES 37,275,000$ 2,432,757$ 34,842,243$ Non-capital items included in project budgets - (63,731) 63,731 Operating fund equipment purchase 29,963 - 29,963 TOTAL CAPITAL OUTLAY 37,304,963$ 2,369,026$ 34,935,937$ WATER UTILITY FUND PROJECT BALANCES AT SEPTEMBER 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 32 of 43   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 September 30 of only $27K, receipts associated with these billings have  decreased $149K 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.     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.    Capital Outlay ‐ A listing of project budgets and balances at September 30 is provided on the following page.   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 88,629$           61,802$                  73,400$           (15,229)$          11,598$           118.77% Charges for services 8,161,330        11,248,216            8,012,821        (148,509)          (3,235,395)       71.24% Fines and penalties 616                    ‐                                263                   (353)                  263                   N/A Interest and other misc 631,645           320,766                  500,862           (130,783)          180,096           156.15% TOTAL REVENUES 8,882,220        11,630,784            8,587,346        (294,874)          (3,043,438)       73.83% EXPENSES: Personnel 1,697,308        2,456,376               1,777,776        (80,468)            678,600           72.37% Supplies 48,881              70,880                    50,287              (1,406)               20,593              70.95% Contracted Services 1,754,372        2,644,281               1,496,208        258,164           1,148,073        56.58% Internal Services 1,174,674        1,455,392               1,100,375        74,299              355,017           75.61% TOTAL OPERATING EXPENSES 4,675,235        6,626,929               4,424,646        250,589           2,202,283        66.77% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 4,206,985        5,003,855               4,162,700        (44,285)            (841,155)          83.19% DEBT SERVICE: Principal ‐                         601,300                   ‐                          ‐                         601,300           0.00% Interest 47,859              108,921                  45,398              2,461                63,523              41.68% TOTAL DEBT SERVICE 47,859              710,221                  45,398              2,461                664,823           6.39% CAPITAL OUTLAY 2,519,251        18,463,200            529,316           1,989,935        17,933,884      2.87% TRANSFERS IN 28,356               ‐                                 ‐                         (28,356)             ‐                         N/A NET TRANSFERS 27,588               ‐                                 ‐                         (27,588)             ‐                         N/A CHANGE IN FUND BALANCE 1,667,463        (14,169,566)           3,587,986        1,920,523        17,757,552      N/A BEGINNING FUND BALANCE, Jan 1 18,879,201      19,832,351            19,832,351      953,150            ‐                         100.00% ENDING FUND BALANCE, Sep 30 20,546,664$   5,662,785$            23,420,337$   2,873,673$      17,757,552$   413.58% WASTEWATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 33 of 43     Wastewater Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE MISCELANEOUS SEWER PROJECTS 185,000$ 5,150$ 179,850$ 2008 LONG-RANGE WW MANAG PLAN 97,000 37,711 59,289 WASTEWATER OPERATIONS MASTER PLAN 774,000 8,509 765,491 FALCON RIDGE LS REHAB - 59 (59) AIRPORT LS REHAB - 247 (247) THUNDER HILL INT REPL/REHAB 3,110,000 29,915 3,080,085 FORCE MAIN REHABILITATION REPLACEMENT 1,487,000 7,612 1,479,388 LIFT STATION REHABILITATION 1,891,000 10,265 1,880,735 DOWNTOWN SEWER REPLACEMENT/REHAB 7,537,000 277,604 7,259,396 2019 SANITARY SEWER REHAB/REPLACEMENT - 3,704 (3,704) 2020 SANITARY SEWER REHAB/REPLACEMENT 2,700,000 163,063 2,536,937 KENNYDALE LAKELINE SEWER UPGRADE 1,248,000 14,332 1,233,668 TOTAL PROJECT BALANCES 19,029,000$ 558,171$ 18,470,829$ Non-capital items included in project budgets (571,000) (28,855) (542,145) Operating fund equipment purchase 5,200 - 5,200 TOTAL CAPITAL OUTLAY 18,463,200$ 529,316$ 17,933,884$ WASTEWATER UTILITY FUND PROJECT BALANCES AT SEPTEMBER 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 34 of 43   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 $189K from the prior year, the revenue reflects a smaller increase as accounts receivable balances  increased by 7.65% over the prior year. A moratorium on disconnections for non‐payment has been in effect since March and  was recently extended into spring 2021.    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 increase in contracted services from the prior year is primarily due to professional services  related to the Cedar River Levee Recertification.    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.  2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 40,200$           50,456$                  52,475$           12,275$           2,019$              104.00% Grants / intergovernmental 1,018,172        12,356,399            778,027           (240,145)          (11,578,372)    6.30% Charges for services 8,825,367        13,000,699            8,944,514        119,147           (4,056,185)       68.80% Interest and other misc 541,531           135,163                  291,358           (250,173)          156,195           215.56% TOTAL REVENUES 10,425,270      25,542,717            10,066,374      (358,896)          (15,476,343)    39.41% EXPENSES: Personnel 2,670,262        3,488,003               2,750,768        (80,506)            737,235           78.86% Supplies 98,579              167,949                  81,508              17,071              86,441              48.53% Contracted Services 1,118,934        4,292,977               1,309,798        (190,864)          2,983,179        30.51% Internal Services 1,453,694        1,746,577               1,306,639        147,055           439,938           74.81% TOTAL OPERATING EXPENSES 5,341,469        9,695,506               5,448,713        (107,244)          4,246,793        56.20% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 5,083,801        15,847,211            4,617,661        (466,140)          (11,229,550)    29.14% DEBT SERVICE: Principal ‐                         488,950                   ‐                          ‐                         488,950           0.00% Interest 446,084           640,845                  443,768           2,316                197,077           69.25% TOTAL DEBT SERVICE 446,084           1,129,795               443,768           2,316                686,027           39.28% CAPITAL OUTLAY 2,204,024        20,310,802            1,242,968        961,056           19,067,834      6.12% NET TRANSFERS 5,532                 ‐                                 ‐                         (5,532)                ‐                         N/A CHANGE IN FUND BALANCE 2,439,225        (5,593,386)             2,930,925        491,700           8,524,311        N/A BEGINNING FUND BALANCE, Jan 1 16,356,030      18,377,556            18,377,556      2,021,526         ‐                         100.00% ENDING FUND BALANCE, Sep 30 18,795,255$   12,784,170$          21,308,481$   2,513,226$      8,524,311$      166.68% SURFACE WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 35 of 43   Surface Water Utility Fund (continued)    Capital Outlay ‐ A listing of project budgets and balances at September 30 is provided below:         PROJECT BUDGET ACTUAL BALANCE COMP S&SW MGMT PLAN P&D 172,034$ 123,577$ 48,457$ SM DRAINAGE PROBLEMS 683,923 86,874 597,049 PANTHER CR WL MOSQUITO ABATEMENT 89,767 79,597 10,170 MADSEN CREEK SEDIMENT BASIN 83,738 73,038 10,700 SMALL DRAINAGE PROJ-MAPLEWOOD SEDIMENT 111,314 87,597 23,717 WETLAND MITIGATION BANK 160,345 30,083 130,262 ACOE 205 PROJECT 61,693 2,956 58,737 CEDAR RIVER GRAVEL REMOVAL 2,902,163 131,052 2,771,111 RENTON STORM WATER MANUAL 75,815 6,732 69,083 GREEN RIVER ECOSYSTEM STUDY 48,336 159 48,177 MISCELLANEOUS/EMERGENCY/STORM PROJECTS 100,000 - 100,000 SURFACE WATER UTILITY GIS 125,382 80,682 44,700 HARDIE AVE S UNDERPASS STORM SYSTEM IMPR 2,391 - 2,391 MONROE AVE/N 2ND ST 378,837 193,119 185,718 STORMWATER FACILITY FENCING PROJECT 265,101 2,901 262,200 CEDAR RIVER 205 LEVEE RECERTIFICATION 4,854,386 209,927 4,644,459 SE 172ND ST/125TH AVE SE 232,561 96,206 136,355 RAINIER AVE/OAKSDALE AVE PUMP STATION UP 207,466 71,326 136,140 NE 16TH/JEFFERSON AVE NE 2,768,213 132,035 2,636,178 DOWNTOWN STORM SYSTEM IMPROVEMENT PROJEC 6,030,270 273,460 5,756,810 HEATHER DOWNS DETENTION POND 693,543 17,911 675,632 MADSEN CRK IMPROV PHASE 1-KCFCD 1,033,096 118,307 914,789 RAINIER AVE/BENSON RD S - CULVERT REPL 200,610 28,289 172,321 CMP STORM SYSTEM REPLACEMENT PROJECT 539,934 20,397 519,537 CEDAR RIVER FLOOD RISK REDUCTION 499,658 4,271 495,387 STORMWATER FACILITY RETROFIT STUDY 300,000 3,356 296,644 BURNETT AVE S/WILLIAMS AVE S 467,629 7,973 459,656 DISASTER RESP CEDAR RIVER GRAVEL REMOVAL - 1,183 (1,183) WSDOT LA ROW RUNOFF IMPACT MITIGATION 96,200 3,754 92,446 TOTAL PROJECT BALANCES 23,184,405$ 1,886,762$ 21,297,643$ Non-capital items included in project budgets (2,902,163) (643,794) (2,258,369) Operating fund equipment purchase 28,560 - 28,560 TOTAL CAPITAL OUTLAY 20,310,802$ 1,242,968$ 19,067,834$ SURFACE WATER UTILITY PROJECT BALANCES AT SEPTEMBER 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 36 of 43   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 September 30 of $339K, receipts associated with these billings have decreased  $460K 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.    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 12,992,972$   17,007,226$          12,532,990$   (459,982)$        (4,474,236)$    73.69% Interest and other misc 61,852               ‐                                39,896              (21,956)            39,896              N/A TOTAL REVENUES 13,054,824      17,007,226            12,572,886      (481,938)          (4,434,340)       73.93% EXPENSES: Contracted Services 12,674,889      17,007,226            13,784,380      (1,109,491)       3,222,846        81.05% TOTAL OPERATING EXPENSES 12,674,889      17,007,226            13,784,380      (1,109,491)       3,222,846        81.05% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 379,935            ‐                                (1,211,494)       (1,591,429)       (1,211,494)       N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 379,935            ‐                                (1,211,494)       (1,591,429)       (1,211,494)       N/A BEGINNING FUND BALANCE, Jan 1 5,512,418        5,961,906               5,961,906        449,488            ‐                         100.00% ENDING FUND BALANCE, Sep 30 5,892,353$      5,961,906$            4,750,412$      (1,141,941)$    (1,211,494)$    79.68% METRO VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 37 of 43   INTERNAL SERVICE FUNDS  Internal service funds are used to account for the goods and services furnished by one City department to other City  departments on a cost reimbursement basis. YTD budgets are not prepared for Internal Service Funds.    Equipment Rental Fund  This fund accounts for revenues and expenses for administration, purchase, and maintenance of the City’s vehicle and  equipment Fleet services. Departments pay in monthly amounts for maintenance and operations. Replacement reserves are  paid monthly over the estimated useful lives of each individual vehicle or piece of equipment. These reverses are accumulated  in fund balance so that they are available to fund the replacement of the vehicle/equipment when the time comes.         Interdepartmental services – 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 due to prior year purchases of computer and radio equipment purchases to outfit  new Police take‐home vehicles which are not recurring in the current year.    Capital Outlay – Decreased capital outlay expenses are due to COVID‐19.      2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 57,639$            ‐$                             25,350$           (32,289)$          25,350$           N/A Interdepartmental services 3,784,549        3,587,714               2,730,925        (1,053,624)       (856,789)          76.12% Interest and other misc 126,999           12,000                    45,563              (81,436)            33,563              379.69% TOTAL REVENUES 3,969,187        3,599,714               2,801,838        (1,167,349)       (797,876)          77.84% EXPENSES: Personnel 831,450           1,089,183               798,378           33,072              290,805           73.30% Supplies 1,041,477        1,496,153               737,840           303,637           758,313           49.32% Contracted Services 232,284           133,166                  179,479           52,805              (46,313)            134.78% Internal Services 22,112              32,697                    24,523              (2,411)               8,174                75.00% TOTAL OPERATING EXPENSES 2,127,323        2,751,199               1,740,220        387,103           1,010,979        63.25% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,841,864        848,515                  1,061,618        (780,246)          213,103           125.11% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 2,722,425        2,064,000               1,152,126        1,570,299        911,874           55.82% NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE (880,561)          (1,215,485)             (90,508)            790,053           1,124,977        N/A BEGINNING FUND BALANCE, Jan 1 6,493,018        6,851,811               6,851,811        358,793            ‐                         100.00% ENDING FUND BALANCE, Sep 30 5,612,457$      5,636,326$            6,761,303$      1,148,846$      1,124,977$      119.96% VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 38 of 43   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.     Contracted Services  ‐ The increase in contracted services expenses over the prior year are due to Liability claims paid.    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 was transferred to the General Fund in July to offset  revenue losses due to COVID‐19.     2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 2,379,470$      3,174,506$            2,326,432$      (53,038)$          (848,074)$        73.28% Interest and other misc 315,995           197,000                  176,290           (139,705)          (20,710)            89.49% TOTAL REVENUES 2,695,465        3,371,506               2,502,722        (192,743)          (868,784)          74.23% EXPENSES: Personnel 623,512           1,484,232               670,218           (46,706)            814,014           45.16% Supplies ‐                         4,000                       401                   (401)                  3,599                10.03% Contracted Services 1,225,241        1,841,646               1,691,105        (465,864)          150,541           91.83% TOTAL OPERATING EXPENSES 1,848,753        3,329,878               2,361,724        (512,971)          968,154           70.93% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 846,712           41,628                    140,998           (705,714)          99,370              338.71% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TRANSFERS OUT ‐                         4,500,000               4,500,000        (4,500,000)        ‐                         100.00% NET TRANSFERS ‐                         (4,500,000)             (4,500,000)       (4,500,000)        ‐                         N/A CHANGE IN FUND BALANCE 846,712           (4,458,372)             (4,359,002)       (5,205,714)       99,370              N/A BEGINNING FUND BALANCE, Jan 1 18,522,154      19,095,508            19,095,508      573,354            ‐                         100.00% ENDING FUND BALANCE, Sep 30 19,368,866$   14,637,136$          14,736,506$   (4,632,360)$    99,370$           100.68% INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 39 of 43   Information Technology Fund  This fund accounts for the administration, purchase, and operation of the City’s information technology systems, including  computer hardware and software, network servers and infrastructure, phone systems, and cell phones. Expenses are paid by  the Information Technology Fund and rates are charged to departments based on use.         Interdepartmental services ‐ 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 ‐ Increased personnel charges over the prior year are the result of COLAs and allocating ½ of the Administrative  Services Administrator payroll costs to the IT division beginning in January 2020.    Supplies – Decreased supply charges over the prior year are the result of decreased minor equipment replacements 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.     2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 253,545$         150,000$                187,471$         (66,074)$          37,471$           124.98% Interdepartmental services 3,724,303        5,343,238               4,030,021        305,718           (1,313,217)       75.42% Interest and other misc 40,808              7,000                       31,613              (9,195)               24,613              451.61% TOTAL REVENUES 4,033,370        5,500,238               4,249,105        215,735           (1,251,133)       77.25% EXPENSES: Personnel 2,057,212        3,165,906               2,168,041        (110,829)          997,865           68.48% Supplies 422,271           983,155                  286,595           135,676           696,560           29.15% Contracted Services 1,308,489        2,416,051               1,492,963        (184,474)          923,088           61.79% Internal Services 1,165                1,804                       1,353                (188)                  451                   75.00% TOTAL OPERATING EXPENSES 3,789,137        6,566,916               3,948,952        (159,815)          2,617,964        60.13% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 244,233           (1,066,678)             300,153           55,920              1,366,831        N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 211,979           1,068,500               41,144              170,835           1,027,356        3.85% TRANSFERS IN 47,627              9,630                       15,392              (32,235)            5,762                159.83% NET TRANSFERS 47,627              9,630                       15,392              (32,235)            5,762                159.83% CHANGE IN FUND BALANCE 79,881              (2,125,548)             274,401           194,520           2,399,949        N/A BEGINNING FUND BALANCE, Jan 1 3,934,408        4,490,062               4,490,062        555,654            ‐                         100.00% ENDING FUND BALANCE, Sep 30 4,014,289$      2,364,514$            4,764,463$      750,174$         2,399,949$      201.50% INFORMATION TECHNOLOGY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 40 of 43   Facilities Fund  This fund accounts for the administration, maintenance, and operation of City‐owned facilities. Expenses are paid by the  Facilities Fund and rates are charged to departments based on square footage.         Interdepartmental services ‐ The 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.     Contracted Services – The decrease in contracted services costs from the prior year is due to COVID‐19. This decrease is a  combination of decreased utility charges resulting from the Governor’s stay‐at‐home order and decreased  repair/maintenance costs as planned preventative maintenance has been delayed.   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 Interdepartmental services 3,318,272        4,306,771               3,112,332        (205,940)          (1,194,439)       72.27% Rents, leases, and misc fees 1                         ‐                                1                         ‐                         1                        N/A Interest and other misc 12,659              4,000                       8,266                (4,393)               4,266                206.65% TOTAL REVENUES 3,347,954        4,310,771               3,142,434        (205,520)          (1,168,337)       72.90% EXPENSES: Personnel 2,113,765        3,167,309               2,184,104        (70,339)            983,205           68.96% Supplies 285,907           339,168                  321,244           (35,337)            17,924              94.72% Contracted Services 1,305,094        1,505,634               992,663           312,431           512,971           65.93% Internal Services 50,153              67,450                    51,365              (1,212)               16,085              76.15% TOTAL OPERATING EXPENSES 3,754,919        5,079,561               3,549,376        205,543           1,530,185        69.88% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (406,965)          (768,790)                 (406,942)          23                      361,848           N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 10,901               ‐                                5,704                5,197                (5,704)               N/A TRANSFERS IN 12,389              2,880                       8,596                (3,793)               5,716                298.47% TRANSFERS OUT 5,220                 ‐                                 ‐                         5,220                 ‐                         N/A NET TRANSFERS 7,169                2,880                       8,596                1,427                5,716                298.47% CHANGE IN FUND BALANCE (410,697)          (765,910)                 (404,050)          6,647                361,860           N/A BEGINNING FUND BALANCE, Jan 1 1,376,859        1,220,276               1,220,276        (156,583)           ‐                         100.00% ENDING FUND BALANCE, Sep 30 966,162$         454,366$                816,226$         (149,936)$        361,860$         179.64% FACILITIES VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 41 of 43   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.     Personnel – Increased personnel costs over the prior year are due to COLA’s, step increases, and the addition of the limited‐ term census program manager in 2020.   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental ‐$                       86,050$                  49,690$           49,690$           (36,360)$          57.75% Interdepartmental services 828,600           1,069,076               374,560           (454,040)          (694,516)          35.04% Interest and other misc 7,449                22,000                    4,870                (2,579)               (17,130)            22.14% TOTAL REVENUES 836,049           1,177,126               429,120           (406,929)          (748,006)          36.45% EXPENSES: Personnel 529,778           851,567                  633,054           (103,276)          218,513           74.34% Supplies 25,301              71,350                    21,971              3,330                49,379              30.79% Contracted Services 191,305           336,679                  180,501           10,804              156,178           53.61% Internal Services 2,226                3,941                       2,956                (730)                  985                   75.01% TOTAL OPERATING EXPENSES 748,610           1,263,537               838,482           (89,872)            425,055           66.36% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 87,439              (86,411)                   (409,362)          (496,801)          (322,951)          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 87,439              (86,411)                   (413,591)          (501,030)          (327,180)          N/A BEGINNING FUND BALANCE, Jan 1 685,593           803,561                  803,561           117,968            ‐                         100.00% ENDING FUND BALANCE, Sep 30 773,032$         717,150$                389,970$         (383,062)$        (327,180)$        54.38% COMMUNICATIONS VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 42 of 43   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 ‐ Premiums increased over the prior year due to 1) increased rates and 2) additional FTEs.       2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Premiums 8,366,499$      12,603,106$            8,611,547$      245,048$         (3,991,559)$    68.33% Interest and other misc 51,585              46,588                       122,894           71,309              76,306              263.79% TOTAL REVENUES 8,418,084        12,649,694               8,734,441        316,357           (3,915,253)       69.05% EXPENSES: Personnel 7,018,113        12,011,435               6,992,371        25,742              5,019,064        58.21% Supplies 10,708              7,500                         6,881                3,827                619                   91.75% Contracted Services 296,831           420,540                    381,304           (84,473)            39,236              90.67% Internal Services 43,547              60,430                       45,322              (1,775)               15,108              75.00% TOTAL OPERATING EXPENSES 7,369,199        12,499,905               7,425,878        (56,679)            5,074,027        59.41% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,048,885        149,789                    1,308,563        259,678           1,158,774        873.60% TOTAL DEBT SERVICE ‐                          ‐                                   ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                   ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                   ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 1,048,885        149,789                    1,308,563        259,678           1,158,774        873.60% BEGINNING FUND BALANCE, Jan 1 4,259,511        5,151,648                 5,151,648        892,137            ‐                         100.00% ENDING FUND BALANCE, Sep 30 5,308,396$      5,301,437$               6,460,211$      1,151,815$      1,158,774$      121.86% HEALTH INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2020  Page 43 of 43   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.    Personnel ‐ The increase in personnel expenses over the prior year is due to an increase in prescription costs and payments  for long‐term care, a benefit not previously being utilized.                        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 Jan Hawn at jhawn@rentonwa.gov. 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 35,898$           45,014$                  35,245$           (653)$                (9,769)$            78.30% Premiums 1,968,512        131,989                  1,218,513        (749,999)          1,086,524        923.19% Interest and other misc 147,216           67,459                    104,196           (43,020)            36,737              154.46% TOTAL REVENUES 2,151,626        244,462                  1,357,954        (793,672)          1,113,492        555.49% EXPENSES: Personnel 656,049           1,209,429               801,415           (145,366)          408,014           66.26% Contracted Services 32,219              38,814                    35,925              (3,706)               2,889                92.56% TOTAL OPERATING EXPENSES 688,268           1,248,243               837,340           (149,072)          410,903           67.08% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,463,358        (1,003,781)             520,614           (942,744)          1,524,395        N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 1,463,358        (1,003,781)             520,614           (942,744)          1,524,395        N/A BEGINNING FUND BALANCE, Jan 1 13,876,628      15,799,729            15,799,729      1,923,101         ‐                         100.00% ENDING FUND BALANCE, Sep 30 15,339,986$   14,795,948$          16,320,343$   980,357$         1,524,395$      110.30% RETIREE HEALTHCARE VARIANCE