Loading...
HomeMy WebLinkAboutQUARTER 3 2021 Finance Department  Memorandum         DATE: October 27, 2021     TO: Randy Corman, Council President  Members of Renton City Council    CC: Armondo Pavone, Mayor  Ed VanValey, Chief Administrative Officer     FROM: Kari Roller, Finance Administrator     STAFF CONTACT: Misty Baker, Sr. Finance Analyst     SUBJECT: Quarterly Financial Report 3rd Quarter 2021       The attached report provides a detailed discussion of General Fund revenues and  expenditures with comparison to prior year and budget through the end of September  2021.      General Fund revenues, excluding interfund transfers, were $86.1M, which is $13.8M  higher than 2020, and $12M higher than the year‐to‐date (YTD) budget.     General Fund expenditures, excluding interfund transfers, were $74M, which is $4.4M  more than 2020 and $10.5M less than the YTD budget.      Detailed explanations are provided for General Fund revenue and expenditure items with  variances exceeding $100K.    Also provided are tables for each of the City’s other funds with comparison to prior year  and annual budget (YTD budgets are not prepared for City funds, with the exception of  the General Fund). For funds that adopt capital project budgets (which are subject to carry  forward in accordance with City Policy 220‐01), schedules of the project budgets have  also been provided.     Please do not hesitate to contact me at x6869 should you have any questions or any  suggestions about the report.            Page 1 of 40   OVERVIEW  This quarterly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through September  30, 2021. A detailed analysis, including current to prior year and budget to actual comparison is included for each City fund.  Excluded from this report are the City’s fiduciary funds as these funds are held on behalf of others and are not available for  City use. Budget figures shown reflect amounts authorized in ORD 6021, which includes the 2nd quarter budget adjustment  approved July 19, 2021.     GENERAL FUND  The General Fund is used to account for resources that are not generally dedicated for a specific purpose. The General Fund  is used to meet the basic services that the City provides including, but not limited to, police protection, parks and recreation,  human services, municipal court, street maintenance and planning, economic development, and administrative functions.  The table below displays the YTD revenues and expenditures for the General Fund, including comparison to prior year,  comparison to YTD budget amounts, and percentage of annual budget. YTD budget amounts are generally based on the  collection/disbursement patterns for the same period of the preceding two (2) years, with the following exceptions: property  tax revenue budgets are based on the collection patterns over the preceding four (4) years and sales tax revenue budgets are  based on the collection patterns over the preceding five (5) years.      General Fund YTD Prior Year YTD YTD Budget % BUDGET REVENUES Taxes 89,542,897$     63,075,671$    78,953,070$       54,994,257$      80,869,450$    56,657,840$ 65,207,515$   10,213,258$   8,549,675$     80.63% Licenses & Permits 5,750,061           4,514,168          5,199,555             3,898,393            4,776,877          3,672,610       4,202,954         304,561              530,344            87.99% Intergovernmental 4,820,547           3,513,832          9,387,084             3,100,157            6,819,265          3,285,517       4,954,831         1,854,674         1,669,314        72.66% Charges for Services 9,251,750           6,994,748          7,514,930             5,703,174            8,172,266          6,193,828       7,030,084         1,326,910         836,256            86.02% Fines and Penalties 4,688,980           3,414,947          3,310,279             2,525,808            3,829,782          2,851,441       3,432,097         906,289              580,656            89.62% Miscellaneous 3,764,087           2,833,720          2,465,125             1,983,749            1,866,685          1,410,585       1,174,987         (808,762)            (235,598)           62.95% Other Financing Sources (Transfer‐In, etc) 13,239,402        6,213,641          17,656,495          15,698,580         94,575                   ‐                        90,156                (15,608,424)     90,156               95.33% TOTAL REVENUES 131,057,724     90,560,728       124,486,539       87,904,118         106,428,900    74,071,821    86,092,624      (1,811,494)        12,020,803     80.89% EXPENDITURES City Attorney 2,353,520           1,747,999          2,207,330             1,650,183            2,611,347          1,951,472       1,796,759         (146,576)            154,713            68.81% Community and Economic Development 8,933,092           6,546,139          10,628,438          7,405,613            11,969,591       8,657,806       7,487,601         (81,988)               1,170,205        62.56% Council 359,238                272,542               425,744                  311,297                554,485               425,952            377,277             (65,980)               48,675               68.04% Court Services 2,406,014           1,767,241          2,444,436             1,826,915            3,102,930          2,318,501       2,038,188         (211,273)            280,313            65.69% Equity, Housing, and Human Services 1,500,007           994,578               1,507,729             1,000,076            3,228,958          2,439,565       2,353,950         (1,353,874)        85,615               72.90% Executive Services 4,526,126           3,264,434          9,430,132             4,840,770            5,399,818          3,989,551       3,544,399         1,296,368         445,152            65.64% Finance 3,327,937           2,201,301          3,503,205             2,310,374            4,158,944          2,749,785       2,582,043         (271,669)            167,742            62.08% Human Resources 1,438,605           1,057,790          1,393,876             1,047,953            1,662,207          1,237,597       1,104,206         (56,253)               133,391            66.43% Parks and Recreation 13,963,819        10,500,074       11,963,172          8,849,526            16,157,748       11,952,293    9,895,940         (1,046,414)        2,056,353        61.25% Police 43,145,496        30,334,983       37,771,599          30,665,622         43,045,808       31,968,102    30,860,483      (194,858)            1,107,619        71.69% Public Works 15,288,233        9,370,855          13,502,943          10,142,391         14,599,792       10,880,404    9,996,611         145,780              883,793            68.47% Other Non‐Departmental 30,357,614        13,944,175       23,408,019          12,895,917         11,077,125       6,370,924       3,969,277         8,926,640         2,401,647        35.83% TOTAL EXPENDITURES 127,599,701     82,002,111       118,186,624       82,946,637         117,568,753    84,941,952    76,006,734      6,939,903         8,935,218        64.65% Change in Fund Balance 3,458,022           8,558,617          6,299,915             4,957,481            (11,139,853)      (10,870,131)   10,085,890      5,128,409         20,956,021     N/A Beginning Fund Balance 44,697,823        44,697,823       48,155,847          48,155,847         54,456,582       54,456,582    54,456,582      6,300,735          ‐                        100.00% ENDING FUND BALANCE 48,155,845$     53,256,439$    54,455,762$       53,113,328$      43,316,729$    43,586,451$ 64,542,472$   11,429,144$   20,956,021$  149.00% Operating Reserve 13,994,674         9,405,500          9,405,500       9,405,500          Economic Development Reserve 2,500,000            2,500,000          2,500,000       2,500,000          AVAILABLE FUND BALANCE 36,618,654$      31,411,229$    31,680,951$ 52,636,972$    Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable) 2019 2020 2021 Variance Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual Quarterly Financial Report 3rd Quarter 2021  Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 2 of 40   GENERAL FUND REVENUES  The following tables provide a more detailed summary of each revenue category within the General Fund. Detailed  explanations have been provided for variances from prior year or YTD budget in excess of $100K. All variances are shown in  a favourable/(unfavourable) format.    TAXES        Property Tax – Property tax collections by King County have exceeded prior year and YTD budget. $229K of property taxes  collected through September 30 were for prior years’ delinquent taxes, bringing the balance of delinquent taxes receivable  to $63K. The remainder of taxes collected were for the 2021 levy. The 2021 property tax levy, after levy changes by the  assessor’s office, totalled $22,794,007. The taxes receivable balance for the 2021 levy is $10.4M at September 30.     Local Retail Sales Tax – Local retail sales tax exceeded prior year and YTD budget. Please see the September sales tax report  for information regarding sales tax figures by industry. The revenue budget will be adjusted to updated estimates with the  mid‐biennial budget adjustment.    State Sales Tax Credit – The City was awarded $500k per year in sales tax credit revenues under the Local Revitalization  Financing program. This award is to pay the debt service on the LRF bonds issued in 2019 to fund public improvements within  the South Lake Washington Local Revitalization Area.     In accordance with SHB 1406, the City passed ORD 5972 authorizing a .0073 sales and use tax for affordable and supportive  housing. The City began collecting these sales tax credit revenues in December 2020.    The City also received a one‐time payment in the amount of $587K in May 2020 related to sales tax credit revenues owed for  the Benson Hill Annexation. This on‐time payment was the result of an audit at the State level where it was determined the  State had underpaid the City in 2019.    Criminal Justice Sales Tax – The criminal justice sales tax is a 0.1% sales tax imposed by the County for criminal justice  purposes. The County must share 90% of the revenues collected with all cities and towns in the county on a per capita basis.  The increase in criminal justice sales tax directly relates to the increase in local retail sales tax, as described above.    Admission Tax – The amount of admission tax under budget is due to COVID‐19. Many venues were closed or operating at  reduced capacity. The revenue budget will be adjusted to updated estimates with the mid‐biennial budget adjustment.    Utility Tax – The amount of utility tax over budget is due to a combination of factors. Some taxes are under budget while  others have exceeded budget. The revenue budget will be adjusted to updated estimates with the mid‐biennial budget  adjustment. The breakdown of Utility Tax is as follows:    2020 2021 2021 Actual Budget Actual $ % $ % Property Tax 12,053,143         12,373,151          12,435,755         382,612              3.2% 62,604                 0.5% Local Retail Sales Tax 19,718,350         20,036,232          24,058,678         4,340,328         22.0% 4,022,446         20.1% State Sales Tax Credit 996,410                 425,817                 529,936                 (466,474)             ‐46.8%104,119              24.5% Criminal Justice Sales Tax 2,223,320            2,203,743             2,522,510            299,190              13.5% 318,767              14.5% Natural Gas Use Tax 102,181                 190,621                 102,310                 129                        0.1%(88,311)                ‐46.3% Admission Tax 84,889                    125,578                 10,815                    (74,074)                ‐87.3% (114,763)             ‐91.4% Utility Tax 12,038,749         11,480,859          11,783,195         (255,554)             ‐2.1%302,336              2.6% Leasehold Excise Tax 139,806                 94,330                    128,751                 (11,055)                ‐7.9%34,421                 36.5% Gambling Excise Tax 1,696,840            1,722,760             2,768,593            1,071,753         63.2% 1,045,833         60.7% B&O Tax 5,940,567            8,004,748             10,866,972         4,926,405         82.9% 2,862,224         35.8% YTD Total 54,994,255$      56,657,840$       65,207,515$      10,213,260$   18.6% 8,549,675$      15.1% Annual Total 78,953,070$      80,869,450$        Taxes by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through September Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 3 of 40       Gambling Excise Tax – Gambling excise taxes have not only exceeded prior year and YTD budget, but they have exceeded the  same period in 2019 by $514k as well. The revenue budget will be adjusted to updated estimates with the mid‐biennial budget  adjustment.    Business and Occupation (B&O) Tax – B&O tax revenues rely heavily on the revenue of a limited number of large businesses.  Payments received in the 1st quarter of each year are generally for activity in the 4th quarter of the prior year. $1.3M of the  $4.9M over the 2020 revenue is due to one taxpayer who had a 4th quarter amount due for the first time as they had reached  the B&O tax “cap” in prior years; $3M of the $4.9M over the 2020 revenue is due to one taxpayer who has seen large  improvement in revenues over 2020; the rest of the increase is due to various businesses. The revenue budget will be adjusted  to updated estimates with the mid‐biennial budget adjustment.    LICENSES & PERMITS        Franchise Fees – Franchise permits grant authority to a provider to use the City’s right‐of‐way to provide or distribute its  services. Franchises are most commonly used to provide utility or telecommunications service. The amount of franchise fees  over the prior year and over budget are the result of increased permitting activity.    Business Licenses – The amount of business license revenue over budget is due to better than expected economic recovery.  The business license revenue budget was adjusted down at the start of the pandemic and has remained low as it was unknown  how quickly the economy would recover and how many businesses would be able to survive the COVID restrictions placed  on businesses.     Building Permits – Building permit revenues increased from the prior year due primarily to $91K in permit tech fees. In prior  years 100% of tech fees collected were recorded in the Information Technology Fund. Beginning January 1, 2021 a portion of  the tech fees collected is being allocated to the General Fund to offset credit card transaction fees.     2020 2021 2021 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Electrical 4,153,742$     3,848,875$         3,880,364$     (273,378)$       ‐6.6% $         31,489 0.8% Natural Gas 1,260,133        807,494                 1,182,747        (77,386)             ‐6.1%          375,253 46.5% Cell 632,785            470,917                 439,012            (193,773)          ‐30.6%           (31,905)‐6.8% Phone 483,758            595,167                 536,636            52,878              10.9%           (58,531)‐9.8% Cable 968,926            1,015,828            943,884            (25,042)             ‐2.6%           (71,944)‐7.1% Garbage 784,560            582,967                 580,458            (204,102)          ‐26.0%              (2,509)‐0.4% City Utilities 3,754,845        4,159,611            4,220,094        465,249           12.4%             60,483 1.5% YTD Total 12,038,749$  11,480,859$      11,783,195$  (255,554)$      ‐2.1%302,336$      2.6% 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % Franchise Fees 1,103,118            914,425                 1,221,257            118,139              10.7% 306,832              33.6% Business Licenses 829,957                 761,121                 876,922                 46,964                 5.7% 115,801              15.2% Animal Licenses 57,045                    74,272                    54,070                    (2,975)                   ‐5.2% (20,202)                ‐27.2% Building Permits 1,883,948            1,886,773             2,016,855            132,907              7.1% 130,082              6.9% ROW/Street Excavation Permits 24,360                    36,012                    33,340                    8,980                    36.9%(2,672)                   ‐7.4% Special Event Permits (35)                             7                                  510                           545                        ‐1557.1%503                        7142.0% YTD Total 3,898,393$         3,672,610$          4,202,954$         304,561$           7.8% 530,344$           14.4% Annual Total 5,199,555$         4,776,877$           Year to Date through September Revenue 2021 vs. 2020 2021 vs. Budget Licenses & Permits by Type Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 4 of 40   INTERGOVERNMENTAL        State Shared Revenue – 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 increase in public safety services and the amount over the prior year is primarily due to increased  receipts for private security services ($232K) and electronic home detention ($140K). The amount over the YTD budget is  primarily due to higher than anticipated receipts for private security services ($345K) and electronic home detention ($108K),  offset by lower than anticipated receipts for school resource officers ($117K). The revenue budget will be adjusted to updated  estimates with the mid‐biennial budget adjustment.    2020 2021 2021 Actual Budget Actual $ % $ % State Shared Revenue 2,909,197$         2,890,587$          3,387,443            478,246$           16.4% 496,856$           17.2% Federal Grants 160,978                 104,598                 1,187,843            1,026,865         637.9% 1,083,245         1035.6% State Grants 100                           39,686                    86,403                    86,303                 86303.0% 46,717                 117.7% Local Grants 29,881                    250,646                 293,142                 263,261              881.0% 42,496                 17.0% YTD Total 3,100,156$         3,285,517$          4,954,831$         1,854,675$      59.8% 1,669,314$      50.8% Annual Total 9,387,084$         6,819,265$           Intergovernmental by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through September 2020 2021 2021 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Judicial Contribution 32,304$         15,484$         43,051$         10,747$        33.3% 27,567$        178.0% Crim Just ‐ High Crime 140,366          ‐                            ‐                           (140,366)       ‐100.0%‐                          N/A Crim Just ‐ Pop 24,351            18,360            25,744            1,393              5.7% 7,384              40.2% Crim Just ‐ Spec Prog 87,233            84,197            91,733            4,500              5.2% 7,536              9.0% Crim Just ‐ One Time ‐                            ‐                           420,599         420,599        N/A 420,599        100.0% State DUI 11,049            13,404            12,776            1,727              15.6%(628)                  ‐4.7% Marijuana Distribution 153,741         149,826         164,847         11,106           7.2% 15,021           10.0% Liquor Profits 630,636         637,491         625,319         (5,317)             ‐0.8% (12,172)          ‐1.9% Liquor Excise Tax 475,932         360,897         538,356         62,424           13.1% 177,459        49.2% Fuel Tax 1,353,585     1,610,928     1,465,018     111,433        8.2%(145,910)       ‐9.1% YTD Total 2,909,197$  2,890,587$  3,387,443$  478,246$     16.4%496,856$     17.2% 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % Passport Fees 10,493                    29,181                     ‐                                   (10,493)               0.0%(29,181)               0.0% Court Services 60,284                    42,662                    112,179                 51,895                 86.1% 69,517                 162.9% General Government Services 516                           6,158                       407                           (109)                        ‐21.1% (5,751)                   ‐93.4% Public Safety Services 544,873                 548,009                 854,499                 309,626              56.8% 306,490              55.9% Development Services 1,197,247            1,180,040             1,777,161            579,914              48.4% 597,121              50.6% Transportation Services 71,276                     ‐                                   56,659                    (14,617)                ‐20.5%56,659                 100.0% Recreation/Farmer's Market/Events 266,774                 841,532                 316,508                 49,733                 18.6%(525,025)             ‐62.4% Interfund Services 3,551,711            3,546,245             3,912,671            360,960              10.2% 366,426              10.3% YTD Total 5,703,174$         6,193,828$          7,030,084$         1,326,910$      23.3% 836,256$           13.5% Annual Total 7,514,930$         8,172,266$           Year to Date through September Charges for Services by Type Revenue 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 5 of 40   Development Services – The increase in development services over the prior year is primarily due to an increase in planning  fees ($480K) and inspection services ($120K). The amount over budget is primarily due to higher than anticipated planning  fees ($656K) offset by lower than anticipated other development services revenues. The revenue budget will be adjusted to  updated estimates with the mid‐biennial budget adjustment.    Recreation/Farmer’s Market/Events – The decrease in revenues and amount under budget is related to cancelled programs,  as a result of COVID‐19. The revenue budget will be adjusted to updated estimates with the mid‐biennial budget adjustment.    Interfund Services – Interfund services revenues increase from the prior year and the amount over budget is due to  reimbursement of staffing costs from CIP projects.     FINES AND PENALTIES        Photo Enforcement Program – Photo enforcement revenues have increased from prior year due and are over budget due to  increased citations associated with traffic is returning to pre‐COVID‐19 levels. Traffic volumes have increased and school zone  cameras were turned back on as in‐person learning resumed in early March. The photo enforcement revenue budget will be  re‐evaluated during the mid‐biennial budget adjustment.    MISCELLANEOUS REVENUES        Interest and Other Investment Earnings – Interest earnings have decreased from the prior year primarily due to: 1) a  reduction in interfund interest ($375K); and 2) an overall reduction in interest rates. The amount of interest under budget is  almost entirely due to the interfund interest payment not being recorded in 2021. The revenue budget will be adjusted to  with the mid‐biennial budget adjustment.    Rents, Leases, and Concessions – Rents, leases, and concessions revenues increased over the prior year primarily due to rent  waivers provided in 2020 in response to COVID‐19. Rents, leases, and concessions revenues are over budget primarily due to  higher than anticipated concessions from one lessee ($118K); the rest of the amount over budget is due to various rent  budgets that were not adjusted for scheduled increases in rental rates. The revenue budget will be adjusted to updated  estimates with the mid‐biennial budget adjustment.       2020 2021 2021 Actual Budget Actual $ % $ % Civil Penalties 284,689$              217,030$              195,875$              (88,814)$             ‐31.2% (21,155)$             ‐9.7% Photo Enforcement Program 2,087,211            2,533,099             3,103,984            1,016,774         48.7% 570,885              22.5% Criminal Traffic Misdemeanor Fines 42,482                    34,686                    36,622                    (5,860)                   ‐13.8%1,936                    5.6% Criminal Non‐Traffic Fines 5,945                       10,438                    4,120                       (1,826)                   ‐30.7% (6,318)                   ‐60.5% Criminal Costs 49,001                    29,864                    26,998                    (22,003)                ‐44.9% (2,866)                   ‐9.6% Non‐Court Fines, Forfeitures and Penalties 56,480                    26,324                    64,498                    8,018                    14.2% 38,174                 145.0% YTD Total 2,525,808$         2,851,441$          3,432,097$         906,289$           35.9% 580,656$           20.4% Annual Total 3,310,279$         3,829,782$           Fines and Penalties by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through September 2020 2021 2021 Actual Budget Actual $ % $ % Interest and Other Investment Earnings 784,809$              607,744$              213,789$              (571,020)$          ‐72.8% (393,955)$          ‐64.8% Rents, Leases, and Concessions 601,778                 552,875                 734,118                 132,340              22.0% 181,243              32.8% Contributions/Donations from Private Sources 123,565                 42,106                    162,534                 38,969                 31.5% 120,428              286.0% Latecomer Agreement 326,880                  ‐                                    ‐                                   (326,880)            0.0%‐                                N/A Other 146,717                 207,860                 64,546                    (82,171)                ‐56.0% (143,314)             ‐68.9% YTD Total 1,983,749$         1,410,585$          1,174,987$         (808,762)$          ‐40.8% (235,598)$          ‐16.7% Annual Total 2,465,125$         1,866,685$           Miscellaneous by Type Year to Date through September Revenue 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 6 of 40   Latecomer Agreement – Latecomer agreements for Sunset Lane infrastructure improvements were finalized in 2020.  Payments are due from property owners if/when various conditions are met. Conditions were met for one property owner  in 2020 and payment was received. It is not possible to estimate if/when the various conditions will be met for the other  property owners and, therefore, receipt of payments under the agreements will not be budgeted.     Other – Other miscellaneous revenues are under budget primarily due to budgeted utility late payments not received due to  the utility moratorium. The revenue budget will be adjusted to updated estimates with the mid‐biennial budget adjustment.    OTHER FINANCING SOURCES        Transfers from Other Funds – The decrease in transfers from other funds is primarily due to a decrease in the following: 1)  $6.2M decrease in transfers in resulting from a change in recording transfers between the General Fund and its consolidated  management funds. Transfers between the consolidated funds were previously recorded as transfer in revenue and transfer  out expenditures. Transfers between the consolidated funds are now net together to avoid overstating revenues and  expenditures. 2) $2.6M one‐time transfer from the Housing Opportunity Fund. $2.5M of these funds are reserved for the  Economic Development Reserve. 3) $580K one‐time transfer in from Density Transfer fees that were held in the Municipal  Facilities CIP capital project fund. These funds were used to support low‐income housing project grants awarded by CED. 4)  $4.5M one‐time transfer in from the Benson Hill sales tax credit reserves held in the Insurance Fund to offset COVID‐19  revenue losses. 5) $1.8M one‐time transfer in from the Municipal Facilities CIP fund to offset COVID‐19 revenue losses.     2020 2021 2021 Actual Budget Actual $ % $ % Transfers from Other Funds 15,675,164$       ‐$                                23,150$                 (15,652,014)      ‐99.9%23,150                 100.0% Insurance Recoveries 4,566                        ‐                                   25,288                    20,722                 453.8% 25,288                 100.0% Sale of Capital Assets 18,850                     ‐                                   41,718                    22,868                 121.3% 41,718                 100.0% YTD Total 15,698,580$       ‐$                                90,156$                 (15,608,424)$   ‐99.4%90,156$              100.0% Annual Total 17,656,495$      94,575$                  Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through September Other Financing Sources by Type Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 7 of 40   GENERAL FUND EXPENDITURES  The following tables summarize expenditures by category for each department within the General Fund. Detailed  explanations have been provided for variances from prior year or YTD budget in excess of $100K.     CITY ATTORNEY        Personnel – The increase in personnel costs over the prior year is due to filling positions that were held vacant in 2020 in  response to COVID‐19. The amount of personnel costs under budget is due to the budget assuming all positions would be  filled for the entire year.    COMMUNITY AND ECONOMIC DEVELOPMENT        Personnel – The decrease in personnel costs from the prior year is primarily due to the city‐wide reorganization which shifted  two of the Economic Development employees to the new Equity, Housing, and Human Services department. The amount of  personnel costs under the YTD budget is due to open positions primarily in Planning ($414K) and Development Services  ($309K).     Contracted Services – The decrease in contracted services from the prior year is primarily due to Economic Development  grant payments and impact fee waivers for multi‐family housing projects ($274K) and payments for the development of a  Housing Action Plan ($62K) in 2020 that were not repeated in 2021; offset by an increase in Planning payments for  professional services related to the TOD Subarea Plan, Light Rail Transit Conceptual design, and Energy Modeling for ADU  Design ($121K).     The amount of contracted services under the YTD budget is primarily due to Economic Development budgeted amounts  related to a CDBG grant that haven’t been spent ($170K), budgeted amounts related to a Port of Seattle grant that haven’t  been spent ($27K), and various other budgeted professional services that haven’t been spent ($55K); combined with Planning  budget amounts related to the Plans referenced above that haven’t been spent ($118K).     Capital Outlay – The amount of capital outlay over the prior year is due to the Downtown Streetscape project, managed by  Economic Development, that is being funded by a CDBG grant.    Internal Services – The increase in internal services costs over the prior year is due to vehicle replacement reserves that were  not charged May‐Sept in 2020 in response to COVID‐19 budget cuts. These payments resumed in 2021.    City Attorney Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,497,984.00    2,350,586.00   1,762,940.00  1,626,703.00 (128,719)$         ‐8.6%136,237$        7.7% Supplies 853.00                   3,550.00              1,627.00            307.00                546                       64.0% 1,320                 81.1% Contracted Services 14,487.00            49,450.00           18,075.00         13,928.00         559                       3.9% 4,147                 22.9% Capital Outlay ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 136,859.00         207,761.00        155,845.00      155,821.00      (18,962)               ‐13.9%24                        0.0% Transfers Out ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Total Expenditures 1,650,183$         2,611,347$        1,938,487$      1,796,759$      (146,576)$         ‐8.9%141,728$        7.3% 2021 vs. Budget2021 2021 vs. 2020 Community and Economic Development Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 5,576,207            8,079,481           6,059,611         5,230,530         345,677$         6.2% 829,081$        13.7% Supplies 4,915                      29,580                  17,178                 6,990                   (2,075)                  ‐42.2%10,188              59.3% Contracted Services 581,819                1,449,512           758,587              351,071             230,748            39.7% 407,516           53.7% Capital Outlay 248,906                1,163,748           880,744              962,775             (713,869)            ‐286.8% (82,031)             ‐9.3% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 809,906                1,244,140           938,556              933,105             (123,199)            ‐15.2%5,451                 0.6% Transfers Out 183,860                3,130                     3,130                    3,130                   180,730            98.3%‐                             0.0% Total Expenditures 7,405,613$         11,969,591$     8,657,806$      7,487,601$      (81,988)$            ‐1.1%1,170,205$   13.5% 2021 vs. Budget2021 2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 8 of 40   Transfers – The decrease in transfers out is due to a change in recording transfers between the General Fund and its  consolidated management funds. Transfers between the consolidated funds were previously recorded as transfer in revenue  and transfer out expenditures. Transfers between the consolidated funds are now net together to avoid overstating revenues  and expenditures.    COUNCIL        COURT SERVICES        Personnel – The amount of personnel costs under the YTD budget is due to open positions.    Internal Services – The increase in internal services costs over the prior year are primarily due to increased Information  Technology costs ($54K) and increased Facilities costs ($51K).     EQUITY, HOUSING, AND HUMAN SERVICES        The Equity, Housing, and Human Services department is a newly formed department, the result of a city‐wide reorganization  approved by the City Council on July 19, 2021, effective August 1, 2021. 2021 budget and actuals have been shifted to the  newly created department for the entirety of 2021 where the costs are coming from an existing department. Newly created  positions in EHHS Admin and Community Outreach divisions are included in the mid‐biennial budget adjustment and are not  reflected here.    2020 actuals have also been reclassified to the new department, where possible, for comparative purposes. It was not  possible to reclassify 2020 Housing expenditures as they are intermixed with other transactions within the CED – Economic  Development division.     Council Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 248,537                421,784               316,338              325,069             (76,532)$            ‐30.8% (8,731)$             ‐2.8% Supplies 808                           2,000                     1,115                    201                        607                       75.1% 914                     82.0% Contracted Services 18,197                   63,316                  57,892                 1,468                   16,729               91.9% 56,424              97.5% Capital Outlay ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 43,755                   67,385                  50,607                 50,539                (6,784)                  ‐15.5%68                        0.1% Transfers Out ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Total Expenditures 311,297$             554,485$            425,952$           377,277$          (65,980)$            ‐21.2%48,675$           11.4% 2021 vs. Budget2021 2021 vs. 2020 Court Services Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,465,506            2,389,087           1,791,815         1,543,383         (77,877)$            ‐5.3%248,432$        13.9% Supplies 1,197                      7,700                     3,029                    4,289                   (3,092)                  ‐258.3% (1,260)                ‐41.6% Contracted Services 67,003                   149,716               105,018              73,195                (6,192)                  ‐9.2%31,823              30.3% Capital Outlay ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 291,255                556,427               418,639              417,321             (126,066)            ‐43.3%1,318                 0.3% Transfers Out 1,954                       ‐                            ‐                           ‐                         1,954                  100.0%‐                             0.0% Total Expenditures 1,826,915$         3,102,930$        2,318,501$      2,038,188$      (211,273)$         ‐11.6%280,313$        12.1% 2021 vs. Budget2021 2021 vs. 2020 Equity, Housing, and Human Services Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 457,076                909,437               682,078              726,719             (269,643)$         ‐59.0% (44,641)$          ‐6.5% Supplies 4,290                      17,775                  9,563                    6,527                   (2,237)                  ‐52.1%3,036                 31.7% Contracted Services 471,780                2,179,833           1,652,733         1,529,269         (1,057,489)       ‐224.1%123,464           7.5% Capital Outlay ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 66,930                   121,913               95,191                 91,435                (24,505)               ‐36.6%3,756                 3.9% Transfers Out ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Total Expenditures 1,000,076$         3,228,958$        2,439,565$      2,353,950$      (1,353,874)$    ‐135.4%85,615$           3.5% 2021 vs. Budget2021 2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 9 of 40   Personnel – The increase in personnel costs over the prior year is primarily due to two Housing division positions whose 2020  actuals are included in the 2020 actuals for CED – Economic Development.     Contracted Services – The increase in contracted services over the prior year is primarily due to increased Human Services  spending ($137K) and Housing division spending ($912K). The Housing division 2020 actuals are included in the 2020 actuals  for CED – Economic Development.     The amount of contracted services over the YTD budget is primarily due to the timing of Human Services payments ($125K).    EXECUTIVE SERVICES        Personnel – The amount of personnel costs under the YTD budget is due to open positions.    Supplies – The decrease in supplies costs from the prior year is due to COVID‐19 expenditures incurred by Emergency  Management in 2020 that are not repeated in 2021.    Contracted Services – The decrease in contracted services costs from the prior year is due to COVID‐19 small business grants  and human services funding incurred by Emergency Management in 2020 that are not repeated in 2021.     The amount of contracted services under the YTD budget is a combination of budget savings in Admin ($38K), Emergency  Management ($26K), Organizational Development ($22K), and Neighborhood Program ($30K).     Internal Services – The increase in internal services costs over the prior year is primarily due to significantly increased  Communications charges to the Executive Admin division ($143K), combined with increased internal service fund charges  across the other internal service funds.    FINANCE        Personnel ‐ The amount of personnel costs under the YTD budget is due to open positions.    Contracted Services – The amount of contracted services over the prior year and over budget is primarily due to outside legal  fees associated with a utility tax audit. The timing of these expenditures is causing the line item to appear over budget when  it is not.       Executive Services Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,488,960            2,487,519           1,865,640         1,575,375         (86,415)$            ‐5.8%290,265$        15.6% Supplies 249,973                16,869                  10,513                 4,121                   245,852            98.4% 6,392                 60.8% Contracted Services 2,626,373            1,874,952           1,313,372         1,198,875         1,427,498        54.4% 114,497           8.7% Capital Outlay ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 474,770                1,020,478           800,026              766,028             (291,258)            ‐61.3%33,998              4.2% Transfers Out 694                            ‐                            ‐                           ‐                         694                       100.0%‐                             0.0% Total Expenditures 4,840,770$         5,399,818$        3,989,551$      3,544,399$      1,296,371$     26.8% 445,152$        11.2% 2021 vs. Budget2021 2021 vs. 2020 Finance Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,509,087            2,465,985           1,849,489         1,526,369         (17,282)$            ‐1.1%323,120$        17.5% Supplies 907                           11,500                  4,555                    911                        (4)                            ‐0.4%3,644                 80.0% Contracted Services 515,118                1,212,698           541,832              703,192             (188,074)            ‐36.5% (161,360)          ‐29.8% Capital Outlay ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 285,262                468,761               353,909              351,571             (66,309)               ‐23.2%2,338                 0.7% Transfers Out ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Total Expenditures 2,310,374$         4,158,944$        2,749,785$      2,582,043$      (271,669)$         ‐11.8%167,742$        6.1% 2021 vs. Budget2021 2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 10 of 40   HUMAN RESOURCES        PARKS AND RECREATION        Personnel – The amount of personnel costs under the YTD budget is due to open positions. Recreation facilities were closed  to the public for the first half of the year and, therefore, supplemental staff were not utilized during this time.     Supplies – The amount of supplies costs under the YTD budget is primarily due to cost savings in the Recreation division that  are directly related to closed Recreation facilities, as noted above.    Internal Services – The increase in internal services over the prior year is primarily due to the following: 1) increased  Information Technology charges ($125K), 2) increased Print/Mail/Communications charges ($95K), 3) increased Fleet charges  ($126K), and 4) increased Facilities charges ($532K). Internal service fund charges are based on: 1) the internal service fund’s  costs and 2) the department’s proportional share of services provided. Internal service fund charges are based on budget  during the year, but will be adjusted to actual at year end based on the internal service funds’ actual expenses incurred.    POLICE        Personnel – The decrease in personnel costs from the prior year is primarily the result of vacant positions resulting in a  decrease in salaries ($636K), offset by an increase in overtime ($219K). There was also an increase in private security overtime  ($56K) and an increase in benefits ($92K).    Contracted Services – The amount of contracted services under the YTD budget is primarily due to less than anticipated  Emergency Communications charges.     Human Resources Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 817,582                1,141,385           856,039              825,209             (7,627)$               ‐0.9%30,830$           3.6% Supplies 2,412                      21,828                  17,517                 5,485                   (3,073)                  ‐127.4%12,032              68.7% Contracted Services 49,751                   213,038               146,784              59,045                (9,294)                  ‐18.7%87,739              59.8% Capital Outlay ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 178,208                285,956               217,257              214,467             (36,259)               ‐20.3%2,790                 1.3% Transfers Out ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Total Expenditures 1,047,953$         1,662,207$        1,237,597$      1,104,206$      (56,253)$            ‐5.4%133,391$        10.8% 2021 vs. Budget2021 vs. 20202021 Parks and Recreation Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 5,163,495            9,328,342           6,996,258         5,122,648         40,847$            0.8% 1,873,610$   26.8% Supplies 177,574                559,648               382,071              226,552             (48,978)               ‐27.6%155,519           40.7% Contracted Services 1,320,102            2,128,002           1,451,503         1,401,009         (80,907)               ‐6.1%50,494              3.5% Capital Outlay ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 2,187,739            4,141,756           3,122,461         3,106,524         (918,785)            ‐42.0%15,937              0.5% Transfers Out 616                            ‐                            ‐                          39,207                (38,591)               ‐6264.8% (39,207)            100.0% Total Expenditures 8,849,526$         16,157,748$     11,952,293$   9,895,940$      (1,046,414)$    ‐11.8%2,056,353$   17.2% 2021 vs. Budget2021 2021 vs. 2020 Police Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 19,128,698         26,779,338        20,084,505      18,855,819      272,879$         1.4% 1,228,686$   6.1% Supplies 202,917                558,141               358,389              271,705             (68,788)               ‐33.9%86,684              24.2% Contracted Services 7,006,131            9,504,366           6,876,077         7,090,447         (84,316)               ‐1.2% (214,370)          ‐3.1% Capital Outlay ‐                            41,154                  20,305                 20,405                (20,405)              100.0%(100)                     ‐0.5% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 3,490,763            6,162,809           4,628,826         4,622,107         (1,131,344)       ‐32.4%6,719                 0.1% Transfers Out 837,113                 ‐                            ‐                           ‐                         837,113            100.0%‐                             0.0% Total Expenditures 30,665,622$      43,045,808$     31,968,102$   30,860,483$   (194,861)$         ‐0.6%1,107,619$   3.5% 2021 vs. Budget2021 vs. 20202021 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 11 of 40   Internal Services – The increase in internal services is primarily due to increased Fleet equipment replacement charges. These  charges were temporarily suspended in 2020 due to COVID‐19, but resumed January 1, 2021.    Transfers Out – The decrease in transfers out from the prior year is due to one‐time transfers that occurred in 2020. These  transfers were as follows: 1) $711,102 to the new Police Seizure special revenue fund established in 2020, and 2) $126,011  to the new Police CSAM Seizure special revenue fund established in 2020.    PUBLIC WORKS        Personnel – The amount of personnel costs under the YTD budget is primarily due to open positions in Street Maintenance  ($439K) and Transportation Systems ($114K).    Contracted Services – The amount of contracted services under the YTD budget is primarily due to lower than anticipated  Transportation Systems division electricity costs ($170K) and various professional services ($86K).    Internal Services – The increase in internal services over the prior year is primarily due to increases in the following: 1) Street  Maintenance division’s Facilities charges ($100K) and Fleet equipment replacement charges ($409K), 2) Transportation  Systems division’s various internal service fund charges ($101K), 3) Public Works Admin division’s various internal service  fund charges ($37K), and 4) Signal Shop Fleet charges ($43K).     Transfers Out – The decrease in transfers out from the prior year are primarily due to 2020 transfers to the Capital  Improvement capital project fund ($760K) that are not repeated in 2021.    NON‐DEPARTMENTAL AND OTHER        Personnel ‐ The amount of personnel expenditures over the prior year is due to timing of employee separations. The amount  of personnel expenditures under the YTD budget is due to lower than anticipated employee separation payments.     Contracted Services – The amount of contracted services under budget is due to contingency reserves that are set aside for  unanticipated costs related to the SCORE.     Transfers Out – The decrease in transfers out is primarily due to decreases in the following: 1) one‐time transfer of REET  revenues to the new REET1 capital project fund ($1.1M) and REET2 capital project fund ($1.1M), 2) timing difference in the  transfer of LRF Sales & Use Taxes to the debt service fund ($328K), 3) property tax transfers to other funds ($7M). $6M of the  decrease in property tax transfers is due to the change in recording of transfers between consolidated funds.  Public Works Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 5,750,752            8,352,106           6,264,081         5,696,906         53,846$            0.9% 567,175$        9.1% Supplies 453,994                557,217               439,945              414,955             39,039               8.6% 24,990              5.7% Contracted Services 1,709,825            2,849,788           2,023,689         1,740,104         (30,279)               ‐1.8%283,585           14.0% Capital Outlay 41,006                   5,200                      ‐                          17,904                23,102               56.3%(17,904)            100.0% Debt Service ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 1,417,907            2,835,481           2,147,489         2,126,742         (708,835)            ‐50.0%20,747              1.0% Transfers Out 768,907                 ‐                            ‐                           ‐                         768,907            100.0%‐                             0.0% Total Expenditures 10,142,391$      14,599,792$     10,875,204$   9,996,611$      145,780$         1.4% 878,593$        8.1% 2021 2021 vs. 2020 2021 vs. Budget Non‐Departmental and Other Summary of Uses 2020 Year to Date through September YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,647,385            3,407,200           2,555,400         2,217,822         (570,437)$         ‐34.6%337,578$        13.2% Supplies ‐                             ‐                            ‐                           ‐                          ‐                              0.0%‐                             0.0% Contracted Services 152,880                2,561,906           2,314,795         216,274             (63,394)               ‐41.5%2,098,521      90.7% Capital Outlay ‐                             ‐                            ‐                          34,452                (34,452)              100.0%(34,452)            100.0% Debt Service ‐                            225,309                ‐                           ‐                          ‐                              0.0%‐                             0.0% Internal Services 14,121                   14,055                  10,541                 10,541                3,580                  25.4%‐                             0.0% Transfers Out 11,081,531         4,868,655           1,490,188         1,490,188         9,591,343        86.6%‐                             0.0% Total Expenditures 12,895,917$      11,077,125$     6,370,924$      3,969,277$      8,926,640$     69.2% 2,401,647$   37.7% 2021 vs. 20202021 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 12 of 40   DEBT SERVICE FUNDS  Debt service funds are used to account for the accumulation of resources for the payment of principal and interest related to  the City’s general obligation bond issues. YTD budgets are not prepared for debt service funds.     GENERAL GOVERNMENTAL MISCELLANEOUS DEBT FUND  The General Governmental Miscellaneous Debt Fund is the only debt service fund maintained by the City.        Grants/intergovernmental – The decrease in intergovernmental revenue is due to a reduction in payments from Fire District  40 that support the debt service payments on Fire Station 13. The payment received in 2nd quarter 2021 was the final  payment scheduled to be received from Fire District 40 related to the debt service on the loan.    Transfers In – Transfers in will be processed to coincide with the timing of debt service payments.   2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 415,505$              114,631$                114,740$       (300,765)$    109$                100.10% Investment Earnings 28,546                    ‐                                15,705           (12,841)         15,705            N/A TOTAL REVENUES 444,051                114,631                  130,445         (313,606)      15,814            113.80% EXPENDITURES: Principal 580,922                5,625,158               595,158         (14,236)         5,030,000       10.58% Interest 978,141                1,527,861               824,069         154,072        703,792          53.94% TOTAL EXPENDITURES 1,559,063             7,153,019               1,419,227      139,836        5,733,792       19.84% Transfers In 2,850,961             7,378,667               1,490,188      (1,360,773)   (5,888,479)     20.20% NET TRANSFERS 2,850,961             7,378,667               1,490,188      (1,360,773)   (5,888,479)     20.20% CHANGE IN FUND BALANCE 1,735,948             340,279                  201,406         (1,534,542)   (138,873)         59.19% BEGINNING FUND BALANCE, Jan 1 3,999,457             5,010,629               5,010,629      1,011,172     ‐                        100.00% ENDING FUND BALANCE, Sep 30 5,735,405$           5,350,908$            5,212,035$   (523,370)$    (138,873)$      97.40% Debt Service Reserve 2,717,575             2,717,575               2,717,575       AVAILABLE FUND BALANCE 3,017,830$           2,633,333$            2,494,460$    VARIANCE FAVORABLE (UNFAVORABLE) GENERAL GOVERNMENTAL MISCELLANEOUS DEBT Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 13 of 40   SPECIAL REVENUE FUNDS  Special revenue funds are used to account for revenues that are to be used for a specific purpose as required by law or  legislative action. YTD budgets are not prepared for special revenue funds.     Hotel/Motel Fund  The Hotel/Motel Fund accounts for monies collected through an increase of 1% in hotel/motel taxes for the purpose of  increasing tourism in the City or Renton, as authorized under RCW 67.28.180. The Lodging Tax Advisory Committee solicits  applications for awards and brings their recommendations to Council for approval at least once per year. Awards for events  are paid to applicants at the conclusion of the event once certain reporting requirements have been met.        Cable Communications Fund  The Cable Communications Fund accounts for funding for promotion and development of cable communications as  established by City ordinance. The main use of the fund is to support the broadcasting of City Council meetings on Channel  21.      2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 179,305$              200,000$                184,096$              4,791$                   (15,904)$               92.05% Contributions 30,000                   25,000                     25,000                   (5,000)                     ‐                              100.00% Investment Earnings 6,409                      ‐                                2,539                     (3,870)                    2,539                     N/A TOTAL REVENUES 215,714                225,000                   211,635                (4,079)                    (13,365)                 94.06% EXPENDITURES: Contracted Services 201,161                461,197                   226,543                (25,382)                 234,654                49.12% TOTAL EXPENDITURES 201,161                461,197                   226,543                (25,382)                 234,654                49.12% Transfers Out 37,500                   40,000                      ‐                              (37,500)                  ‐                              0.00% NET TRANSFERS (37,500)                 (40,000)                     ‐                              37,500                    ‐                              N/A CHANGE IN FUND BALANCE (22,947)                 (276,197)                 (14,908)                 8,039                     261,289                5.40% BEGINNING FUND BALANCE, Jan 1 943,889                893,604                   893,604                (50,285)                  ‐                              94.67% ENDING FUND BALANCE, Sep 30 920,942$              617,407$                878,696$              (42,246)$               261,289$              95.41% VARIANCE FAVORABLE (UNFAVORABLE) HOTEL/MOTEL 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 60,876$                57,674$                    55,098$                (5,778)$                 (2,576)$                 95.53% Investment Earnings 4,049                      ‐                                  1,962                     (2,087)                    1,962                     N/A TOTAL REVENUES 64,925                   57,674                      57,060                   (7,865)                    (614)                       98.94% EXPENDITURES: Supplies ‐                              6,302                         6,184                     6,184                     118                        98.13% Contracted Services 29,830                   51,372                      34,850                   5,020                     16,522                   67.84% Capital Outlay ‐                              40,000                       ‐                               ‐                              40,000                   0.00% TOTAL EXPENDITURES 29,830                   97,674                      41,034                   11,204                   56,640                   42.01% Transfers In ‐                              40,000                       ‐                               ‐                               ‐                              0.00% NET TRANSFERS ‐                              40,000                       ‐                               ‐                               ‐                              0.00% CHANGE IN FUND BALANCE 35,095                    ‐                                  16,026                   (19,069)                 16,026                   N/A BEGINNING FUND BALANCE, Jan 1 603,760                677,710                    677,710                73,950                    ‐                              100.00% ENDING FUND BALANCE, Sep 30 638,855$              677,710$                  693,736$              54,881$                16,026$                102.36% CABLE COMMUNICATIONS VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 14 of 40   Housing & Supportive Services  In accordance with HB 1590, the City Council passed ORD 5983 authorizing an additional 0.1% sales and use tax, effective  January 1, 2021. The additional sales tax was not authorized at the time the 2021‐2022 budget was prepared. Anticipated  revenues are expected to be included in the mid‐biennial budget adjustment. The additional sales and use tax is restricted  for housing and related services, in accordance with RCW 82.14.530.         Springbrook Wetlands Fund  The Springbrook Wetlands Fund was established in 2007 for the purpose of providing accounting for the Springbrook Creek  Wetland and Habitat Mitigation Bank project. The fund will receive revenue by selling Wetlands credits which will be used to  fund the ongoing maintenance of the wetland in perpetuity.           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes ‐$                             ‐$                               2,170,166$           2,170,166$           2,170,166$           N/A TOTAL REVENUES ‐                               ‐                                  2,170,166             2,170,166             2,170,166             N/A EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                   ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                                   ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE ‐                               ‐                                  2,170,166             2,170,166             2,170,166             N/A BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                   ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Sep 30 ‐$                             ‐$                               2,170,166$           2,170,166$           2,170,166$           N/A HOUSING & SUPPORTIVE SERVICES VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charge for services ‐$                            24,200$                    ‐$                             ‐$                            (24,200)$               0.00% Investment Earnings 2,251                      ‐                                 1,023                     (1,228)                    1,023                     N/A Sale of fixed assets ‐                               ‐                                 867                        867                        867                        N/A TOTAL REVENUES 2,251                     24,200                      1,890                     (361)                       (22,310)                 7.81% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                                  ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 2,251                     24,200                      1,890                     (361)                       (22,310)                 7.81% BEGINNING FUND BALANCE, Jan 1 345,658                348,826                   348,826                3,168                      ‐                              100.00% ENDING FUND BALANCE, Sep 30 347,909$              373,026$                 350,716$              2,807$                   (22,310)$               94.02% SPRINGBROOK WETLANDS VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 15 of 40   Police Seizure Fund  The Police Seizure Fund was established in the 2nd quarter of 2020 for the purpose of providing transparency in the accounting  for assets seized by Police in accordance with RCW 9A.83.030 and 69.50.505, previously accounted for within the General  Fund. These seizure funds are restricted to use exclusively for the expansion and improvement of controlled substances  related law enforcement activity.        Police CSAM Seizure Fund  The Police CSAM Seizure Fund was established in the 2nd quarter of 2020 for the purpose of providing transparency in the  accounting for assets seized by Police in accordance with RCW 9A.88.150, previously accounted for within the General Fund.  These seizure funds are restricted to the exclusive use of enforcing the provisions of chapter 9A.88 RCW, Indecent Exposure‐ Prostitution, or chapter 9.68A RCW, Sexual Exploitation of Children.      2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Contributions 8,716$                    ‐$                               10,836$                2,120$                   10,836$                N/A Investment Earnings 1,613                      ‐                                 2,257                     644                        2,257                     N/A TOTAL REVENUES 10,329                    ‐                                 13,093                   2,764                     13,093                   N/A EXPENDITURES: Supplies 34,869                   872,449                   21,771                   (13,098)                 850,678                2.50% Contracted Services 20,580                    ‐                                 42,054                   21,474                   (42,054)                 N/A Capital Outlay 7,307                      ‐                                 84,404                   77,097                   (84,404)                 N/A TOTAL EXPENDITURES 62,756                   872,449                   148,229                85,473                   724,220                16.99% Transfers In 711,102                 ‐                                  ‐                              (711,102)                ‐                              N/A NET TRANSFERS 711,102                 ‐                                  ‐                              (711,102)                ‐                              N/A CHANGE IN FUND BALANCE 658,675                (872,449)                  (135,136)               (793,811)               737,313                N/A BEGINNING FUND BALANCE, Jan 1 ‐                              872,449                   872,449                872,449                 ‐                              100.00% ENDING FUND BALANCE, Sep 30 658,675$               ‐$                               737,313$              78,638$                737,313$              N/A POLICE SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Fines and penalties 15,184$                 ‐$                               22,380$                7,197$                   22,380$                N/A Investment Earnings 311                         ‐                                 460                        149                        460                        N/A TOTAL REVENUES 15,495                    ‐                                 22,840                   7,345                     22,840                   N/A EXPENDITURES: Contracted Services 1,501                     150,637                    ‐                              (1,501)                    (150,637)               0.00% TOTAL EXPENDITURES 1,501                     150,637                    ‐                              (1,501)                    150,637                0.00% Transfers In 126,011                 ‐                                  ‐                              (126,011)                ‐                              N/A NET TRANSFERS 126,011                 ‐                                  ‐                              (126,011)                ‐                              N/A CHANGE IN FUND BALANCE 140,005                (150,637)                  22,840                   (117,165)               173,477                N/A BEGINNING FUND BALANCE, Jan 1 ‐                              150,637                   150,637                150,637                 ‐                              100.00% ENDING FUND BALANCE, Sep 30 140,005$               ‐$                               173,477$              33,472$                173,477$              N/A POLICE CSAM SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 16 of 40   CAPITAL PROJECT FUNDS  Capital project funds are used to account for the acquisition and construction of major capital facilities and equipment. YTD  budgets are not prepared for capital project funds. Project budgets are adopted when funding is secured, and balances are  carried forward each year until they are either 1) fully spent or 2) reallocated to another project through the budget  adjustment process.    Community Services Impact Mitigation Fund  This fund accounts for park impact fees collected from developers as authorized under RCW 82.02.050‐.110. These fees are  used to help offset the cost of system improvements necessary to service the new development. Impact fees are held in this  fund and subsequently transferred to the Municipal Facilities CIP Fund when qualifying capital projects are budgeted.        Fire Impact Mitigation Fund  This fund accounts for fire impact fees collected from developers as authorized under RCW 82.02.050‐.110. These fees are  used to offset the cost of system improvements necessary to serve the new development. Impact fees are held in this fund  and subsequently transferred to the debt service fund to support the debt service on fire station 13. Once the debt on the  fire station is repaid, the remaining collections will be disbursed to the Renton Regional Fire Authority for use on qualifying  capital projects.       2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 505,723$              86,500$                  204,385$              (301,338)$             117,885$              236.28% Investment Earnings 13,940                    ‐                                5,983                     (7,957)                    5,983                     N/A TOTAL REVENUES 519,663                86,500                     210,368                (309,295)               123,868                243.20% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                 ‐                               ‐                               ‐                              N/A Transfers In ‐                              1,484,964               1,179,783             1,179,783              ‐                              79.45% Transfers Out ‐                              2,080,328                ‐                               ‐                              2,080,328             0.00% NET TRANSFERS ‐                              (595,364)                 1,179,783             1,179,783             1,775,147              ‐198.16% CHANGE IN FUND BALANCE 519,663                (508,864)                 1,390,151             870,488                1,899,015              ‐273.19% BEGINNING FUND BALANCE, Jan 1 1,886,999             1,713,833               1,713,833             (173,166)                ‐                              100.00% ENDING FUND BALANCE, Sep 30 2,406,662$           1,204,969$             3,103,984$           697,322$              1,899,015$           257.60% COMMUNITY SERVICES IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 128,895$              99,000$                  183,880$              54,985$                84,880$                185.74% Investment Earnings 14,163                    ‐                                6,382                     (7,781)                    6,382                     N/A TOTAL REVENUES 143,058                99,000                     190,262                47,204                   91,262                   192.18% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                 ‐                               ‐                               ‐                              N/A Transfers Out 113,806                436,987                   ‐                              (113,806)               436,987                0.00% NET TRANSFERS (113,806)               (436,987)                  ‐                              113,806                436,987                0.00% CHANGE IN FUND BALANCE 29,252                   (337,987)                 190,262                161,010                528,249                 ‐56.29% BEGINNING FUND BALANCE, Jan 1 2,120,558             2,191,452               2,191,452             70,894                    ‐                              100.00% Prior Period Adjustment ‐                               ‐                                 ‐                               ‐                               ‐                              N/A BEGINNING FUND BALANCE, Jan 1 (restated) 2,120,558             2,191,452               2,191,452             70,894                    ‐                              100.00% ENDING FUND BALANCE, Sep 30 2,149,810$           1,853,465$             2,381,714$           231,904$              528,249$              128.50% FIRE IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 17 of 40   Transportation Impact Mitigation Fund  This fund accounts for transportation impact fees collected from developers as authorized under RCW 82.02.050‐.110. These  fees are used to offset the cost of system improvements necessary to serve the new development. Impact fees are held in  this fund and subsequently transferred to the Capital Improvement Fund when qualifying projects are budgeted.        REET 1 Fund  This fund was established in the 2nd quarter of 2020 to account for the first quarter percent of real estate excise tax (REET)  levied in accordance with RCW 82.46.010. The tax may be used for eligible capital projects, as defined in RCW.82.46.010(6),  that are included in the capital facilities element of the City’s comprehensive plan. REET 1 tax revenues are held in this fund  and subsequently transferred to the appropriate capital project fund when qualifying projects are budgeted.         2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 1,691,032$           200,000$                 1,909,674$           218,642$              1,709,674$           954.84% Investment Earnings 22,675                    ‐                                 10,844                   (11,831)                 10,844                   N/A TOTAL REVENUES 1,713,707             200,000                    1,920,518             206,811                1,720,518             960.26% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A Transfers Out ‐                              172,869                     ‐                               ‐                              172,869                0.00% NET TRANSFERS ‐                              (172,869)                   ‐                               ‐                              172,869                0.00% CHANGE IN FUND BALANCE 1,713,707             27,131                      1,920,518             206,811                1,893,387             N/A BEGINNING FUND BALANCE, Jan 1 2,942,344             3,154,954                3,154,954             212,610                 ‐                              100.00% ENDING FUND BALANCE, Sep 30 4,656,051$           3,182,085$              5,075,472$           419,421$              1,893,387$           159.50% TRANSPORTATION IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 2,233,375$           2,250,000$              3,394,381$           1,161,006$           1,144,381$           150.86% Investment Earnings 5,775                      ‐                                 9,524                     3,749                     9,524                     N/A TOTAL REVENUES 2,239,150             2,250,000                3,403,905             1,164,755             1,153,905             151.28% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A Transfers In 1,143,855              ‐                                  ‐                              (1,143,855)             ‐                              N/A Transfers Out ‐                              2,865,000                 ‐                               ‐                              2,865,000             0.00% NET TRANSFERS 1,143,855             (2,865,000)                ‐                              (1,143,855)            2,865,000             0.00% CHANGE IN FUND BALANCE 3,383,005             (615,000)                  3,403,905             20,900                   4,018,905              ‐553.48% BEGINNING FUND BALANCE, Jan 1 ‐                              2,042,269                2,042,269             2,042,269              ‐                              100.00% ENDING FUND BALANCE, Sep 30 3,383,005$           1,427,269$              5,446,174$           2,063,169$           4,018,905$           381.58% REET 1 VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 18 of 40   REET 2 Fund  This fund was established in the 2nd quarter of 2020 to account for the second quarter percent of real estate excise tax (REET)  levied in accordance with RCW 82.46.035. The tax may be used for eligible capital projects, as defined in RCW.82.46.035(5),  that are included in the capital facilities element of the City’s comprehensive plan. REET 2 tax revenues are held in this fund  and subsequently transferred to the appropriate capital project fund when qualifying projects are budgeted.      2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 2,233,375$           2,250,000$              3,394,380$           1,161,005$           1,144,380$           150.86% Investment Earnings 5,775                      ‐                                 14,602                   8,827                     14,602                   N/A TOTAL REVENUES 2,239,150             2,250,000                3,408,982             1,169,832             1,158,982             151.51% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A Transfers In 1,143,855             3,177,680                3,177,680             2,033,825              ‐                              100.00% Transfers Out ‐                              7,066,705                 ‐                               ‐                              7,066,705             0.00% NET TRANSFERS 1,143,855             (3,889,025)               3,177,680             2,033,825             7,066,705              ‐81.71% CHANGE IN FUND BALANCE 3,383,005             (1,639,025)               6,586,662             3,203,657             8,225,687              ‐401.86% BEGINNING FUND BALANCE, Jan 1 ‐                              3,411,866                3,411,866             3,411,866              ‐                              100.00% ENDING FUND BALANCE, Sep 30 3,383,005$           1,772,841$              9,998,528$           6,615,523$           8,225,687$           563.98% REET 2 VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 19 of 40   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.        2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 555,083$              1,302,206$            1,168,042$           612,959$              (134,164)$             89.70% Charges for services 140                         ‐                               157,795                157,655                157,795                N/A Sale of general fixed assets 560,000                 ‐                               80,000                   (480,000)               80,000                   N/A Contributions ‐                              11,000                    11,000                   11,000                    ‐                              100.00% Investment Earnings 176,405                86,185                    58,244                   (118,161)               (27,941)                 67.58% TOTAL REVENUES 1,291,628             1,399,391              1,475,081             183,453                75,690                   105.41% EXPENDITURES: Personnel 381,069                731,324                 383,907                2,838                     347,417                52.49% Contracted Services 408,562                130,384                 32,764                   (375,798)               97,620                   25.13% Capital Outlay 5,148,686             23,889,853            3,227,689             (1,920,997)            20,662,164           13.51% TOTAL EXPENDITURES 5,938,317             24,751,561            3,644,360             (2,293,957)            21,107,201           14.72% Transfers In ‐                              7,899,008               ‐                               ‐                              (7,899,008)            0.00% Transfers Out 2,323,680             4,669,729              4,385,342             2,061,662             284,387                93.91% NET TRANSFERS (2,323,680)            3,229,279              (4,385,342)            (2,061,662)            (8,183,395)             ‐135.80% CHANGE IN FUND BALANCE (6,970,369)            (20,122,891)          (6,554,621)            415,748                13,568,270           32.57% BEGINNING FUND BALANCE, Jan 1 26,395,567           20,298,663            20,298,663           (6,096,904)             ‐                              100.00% ENDING FUND BALANCE, Sep 30 19,425,198$        175,772$               13,744,042$        (5,681,156)$         13,568,270$        7819.24% MUNICIPAL FACILITIES CIP VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 20 of 40   Municipal Facilities CIP Fund (continued)             PROJECT BUDGET ACTUAL BALANCE CAPITAL PROJECT COORDINATORS 731,324$ 383,907$ 347,417$ SUNSET NEIGHBORHOOD PARK ART 86,856 10,200 76,656 CITY HALL ELEVATORS/GENERATOR REPLACEMENT 1,465,583 454,597 1,010,986 CITY WIDE SECURITY SYSTEM UPGRADES 353,913 18,822 335,091 COMM SVCS MAINT SHOPS REHAB 299,946 - 299,946 SIGN SHOP IMPROVEMENTS 2,824 - 2,824 CITY HALL MAJOR HVAC AND FIRE COMP REPL 2,629,288 1,910,395 718,893 RCC AUDIO AND VIDEO SYSTEMS 56,000 - 56,000 CITY HALL - REMODEL 10,000 5,609 4,391 CITY HALL - 7TH FLOOR REMODEL 10,000 1,881 8,119 PUBLIC WORKS SHOPS - GENERATOR REPL 144,000 - 144,000 BOATHOUSE 14,763 7,352 7,411 HENRY MOSES AQUATIC CENTER 88,644 28,912 59,732 SPORT COURT IMPROVEMENTS 215,000 127,434 87,566 PARKING LOT AND DRIVEWAY REPAIRS 90,000 - 90,000 URBAN FORESTRY PROGRAM 103,348 22,622 80,726 PARKS MM - PLAYGRDS, KIOSKS & INT SIGNS 325,000 - 325,000 PARKS MM - STRUCTURAL REVIEWS & REPAIRS 11,915 11,915 - SUNSET EIS PARK 84,010 59,337 24,673 COULON PARK STRUCTURAL IMPROVEMENTS 150 150 - COULON PARK TURF REPLACEMENT 50,788 - 50,788 COULON SWIM BEACH 100,000 - 100,000 LIBERTY PARK IMPROVEMENTS 525,852 246,154 279,698 TRANSPORTATION LANDSCAPE 90,000 - 90,000 PHILIP ARNOLD PARK IMPROVEMENTS 5,951,133 111,504 5,839,629 KIWANIS PARK 6,062,100 27,294 6,034,806 COULON - WATERWALK 3,481,270 143,166 3,338,104 COULON - TRESTLE BRIDGE 1,497,854 70,002 1,427,852 FAWCETT ROFR - PROF SERVICES - 107 (107) COULON - ROSEWALL REPAIRS & MAINTENANCE 10,000 - 10,000 MAY CREEK TRAIL SOUTH 250,000 - 250,000 PARKS AVE N ACQUISITION 10,000 3,000 7,000 TOTAL PROJECT BALANCES 24,751,561$ 3,644,360$ 21,107,201$ MUNICIPAL FACILITIES CIP PROJECT BUDGETS AT SEPTEMBER 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 21 of 40   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.      2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 1,372,736$           28,258,159$        5,644,893$           4,272,157$           (22,613,266)$       19.98% Charges for services 250,000                 ‐                               ‐                              (250,000)                ‐                              N/A Fines and penalties 21,622                    ‐                              29,118                   7,496                     29,118                   N/A Investment Earnings 120,484                 ‐                              46,184                   (74,300)                 46,184                   N/A TOTAL REVENUES 1,764,842             28,258,159           5,720,195             3,955,353             (22,537,964)         20.24% EXPENDITURES: Personnel 80,879                   56,000                   86,339                   5,460                     (30,339)                 154.18% Supplies 147,946                40,000                   20,598                   (127,348)               19,402                   51.50% Contracted Services 107,700                188,248                80,412                   (27,288)                 107,836                42.72% Capital Outlay 4,508,948             45,136,344           9,046,585             4,537,637             36,089,759           20.04% TOTAL EXPENDITURES 4,845,473             45,420,592           9,233,934             4,388,461             36,186,658           20.33% Transfers In 760,000                2,172,869              ‐                              (760,000)               (2,172,869)            0.00% NET TRANSFERS 760,000                2,172,869              ‐                              (760,000)               (2,172,869)            0.00% CHANGE IN FUND BALANCE (2,320,631)            (14,989,564)         (3,513,739)            (1,193,108)            11,475,825           N/A BEGINNING FUND BALANCE, Jan 1 18,947,853           16,792,413           16,792,413           (2,155,440)             ‐                              100.00% ENDING FUND BALANCE, Sep 30 16,627,222$        1,802,849$           13,278,674$        (3,348,548)$         11,475,825$        736.54% CAPITAL IMPROVEMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 22 of 40   Capital Improvement Fund (continued)         PROJECT BUDGET ACTUAL BALANCE WALKWAY PGM 267,096$ -$ 267,096$ NE 31ST ST CULVERT 12,228 12,090 138 ARTERIAL CIRCULATION PGM 79,564 40,614 38,950 BRIDGE INSPECTION & REPAIR 245,909 42,394 203,515 ROADWAY SAFETY & GUARDRAIL 89,407 - 89,407 CATCH BASIN REPAIR 250,000 - 250,000 RENTON CONNECTOR 1,747,812 2,932 1,744,880 STREET OVERLAY PGM 1,465,902 65,458 1,400,444 TRAFFIC SAFETY PGM 117,808 15,949 101,859 PROJ DEV & PRE-DESIGN 186,201 11,623 174,578 SO 7TH ST 835,000 - 835,000 ITS PGM 86,128 9,363 76,765 RENTON AVE EXT PRES 40,920 31,859 9,061 PARK AVE EXTENSION 7,394,795 1,276,504 6,118,291 RAINIER AVE S/N PHASE 4 4,568,763 422,194 4,146,569 INTERSECT SAFETY & MOBILITY 355,610 1,491 354,119 NE 31ST ST BRIDGE REPLACEMENT 248,046 25,661 222,385 N 27TH PL CULVERT SCOUR REPAIR 66,622 35,613 31,009 DUVALL AVE 7TH TO SUNSET 6,499,523 102,967 6,396,556 BARRIER FREE 113,883 56,187 57,696 SIDEWALK REHAB 100,000 - 100,000 LAKE WASHINGTON LOOP TRAIL 2,569,362 1,037,846 1,531,516 HIGHLANDS TO LANDING 422,490 147,360 275,130 SUNSET BLVD CORRIDOR 4,421,053 47,624 4,373,429 PRES OF TOD 173,496 88,585 84,911 WILLIAMS AVE S & WELLS AVE S CONV 6,495,074 4,664,727 1,830,347 ARTERIAL REHAB - SW 43RD 1,169,960 - 1,169,960 BRONSON BRIDGE 463,766 49,138 414,628 HOUSER WAY N BRIDGE 531,247 5,193 526,054 WILLIAMS BRIDGE 649,992 5,193 644,799 S 2ND STREET CONVERSION 1,545,494 1,462 1,544,032 HOUSER WAY INT & PED IMP 730,465 30,912 699,553 RENTON SCHOOL CROSSINGS 688,384 544,684 143,700 SAFE ROUTES TO TRANSIT 763,592 436,306 327,286 SOUND TRANSIT NE 44TH STREET 25,000 22,005 2,995 TOTAL PROJECT BALANCES 45,420,592$ 9,233,934$ 36,186,658$ CAPITAL IMPROVEMENT PROJECT BUDGETS AT SEPTEMBER 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 23 of 40   New Library Development Fund  This fund was used to account for the construction of the new Highlands Library and the renovation of the Cedar River Library.  The fund is no longer needed as the library construction projects were complete in 2016. The fund has been closed and the  remaining fund balance was transferred to the General Fund.        Family First Center Fund  This fund is used to account for the construction of the new Family First Center. Funds accumulated for the construction of  the Family First Center are maintained in the fund balance until such time that Council authorizes their use through the  approval of contracts and additional project budget is established through the budget adjustment process.        Capital Outlay – The decrease in capital outlay from the prior year is due to timing of project costs within the overall project.     Note ‐ Additional funds designated for the Family First Center are being held in a fund with the Renton Community Foundation  (Foundation). Those funds are not reflected in the City’s records as they are assets of the Foundation, not the City. The City  must apply to the Foundation to receive the funds. Funds transferred from the Foundation will be recorded as contribution  revenue when received by the City.    2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 271$                       ‐$                             ‐$                            (271)$                      ‐$                            N/A TOTAL REVENUES 271                         ‐                               ‐                              (271)                        ‐                              N/A TOTAL EXPENDITURES ‐                               ‐                               ‐                               ‐                               ‐                              N/A Transfers Out ‐                              16,679                   16,679                   16,679                    ‐                              100.00% NET TRANSFERS ‐                              (16,679)                 (16,679)                 (16,679)                  ‐                              N/A CHANGE IN FUND BALANCE 271                        (16,679)                 (16,679)                 (16,950)                  ‐                              N/A BEGINNING FUND BALANCE, Jan 1 16,408                   16,679                   16,679                   271                         ‐                              100.00% ENDING FUND BALANCE, Sep 30 16,679$                 ‐$                             ‐$                            (16,679)$                ‐$                            N/A NEW LIBRARY DEVELOPMENT VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental ‐$                            75,000$                 ‐$                             ‐$                            (75,000)$               0.00% Investment Earnings 54,501                    ‐                              23,673                   (30,828)                 23,673                   N/A TOTAL REVENUES 54,501                   75,000                   23,673                   (30,828)                 (51,327)                 31.56% EXPENDITURES: Contracted Services ‐                               ‐                              60,435                   60,435                   (60,435)                 N/A Capital Outlay 259,310                872,775                67,603                   (191,707)               805,172                7.75% TOTAL EXPENDITURES 259,310                872,775                128,038                (131,272)               744,737                14.67% NET TRANSFERS ‐                               ‐                              27,879                   27,879                   27,879                   N/A CHANGE IN FUND BALANCE (204,809)               (797,775)               (76,486)                 128,323                721,289                N/A BEGINNING FUND BALANCE, Jan 1 8,551,401             8,356,704             8,356,704             (194,697)                ‐                              100.00% ENDING FUND BALANCE, Sep 30 8,346,592$           7,558,929$           8,280,218$           (66,374)$               721,289$              109.54% FAMILY FIRST CENTER VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 24 of 40   ENTERPRISE FUNDS  Enterprise funds are used to account for operations that are financed and operated in a manner similar to private business  enterprises. YTD budgets are not prepared for Enterprise Funds.     Most Enterprise Funds maintain two separate “management funds”, an operating fund and a capital fund. The funds are  consolidated for budget/reporting purposes. Operating budgets lapse at the end of the year. Project budgets are adopted  when funding is secured, and balances are carried forward each year until they are either 1) fully spent or 2) reallocated to  another project through the budget adjustment process. A listing of project balances for each Enterprise Fund is included,  along with a reconciliation to the amounts reported as “Capital Outlay”.     Airport Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Renton Municipal Airport.         Capital Outlay ‐ A listing of project budgets and balances at September 30 is provided on the following page.   2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental ‐$                       57,162$                   ‐$                        ‐$                       (57,162)$          0.00% Charges for services 2,282,559        3,047,910               2,476,150        193,591           (571,760)          81.24% Interest and other misc 42,953              4,857                       23,447              (19,506)            18,590              482.75% TOTAL REVENUES 2,325,512        3,109,929               2,499,597        174,085           (610,332)          80.37% EXPENSES: Personnel 674,074           1,322,337               816,777           (142,703)          505,560           61.77% Supplies 22,085              39,471                    19,693              2,392                19,778              49.89% Contracted Services 273,776           1,085,712               371,304           (97,528)            714,408           34.20% Internal Services 235,446           393,723                  295,292           (59,846)            98,431              75.00% TOTAL OPERATING EXPENSES 1,205,381        2,841,243               1,503,066        (297,685)          1,338,177        52.90% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,120,131        268,686                  996,531           (123,600)          727,845           370.89% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 223,324           6,524,125               458,107           (234,783)          6,066,018        7.02% TRANSFERS OUT 1,363                 ‐                                6,276                (4,913)               (6,276)               N/A NET TRANSFERS (1,363)                ‐                                (6,276)               (4,913)               (6,276)               N/A CHANGE IN FUND BALANCE 895,444           (6,255,439)             532,148           (363,296)          6,787,587        N/A BEGINNING FUND BALANCE, Jan 1 6,259,402        7,558,405               7,558,405        1,299,003         ‐                         100.00% ENDING FUND BALANCE, Sep 30 7,154,846$      1,302,966$            8,090,553$      935,707$         6,787,587$      620.93% Operating Reserve 190,480           223,124                  223,124            AVAILABLE FUND BALANCE 6,964,366$      1,079,842$            7,867,429$       VARIANCE AIRPORT Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 25 of 40   Airport Fund (continued)        Solid Waste Fund  This fund accounts for revenues and expenses for administration and operating of solid waste, recycling, and yard waste  collection services for the City.         Capital Outlay ‐ The Solid Waste Fund does not have a capital fund.   PROJECT BUDGET ACTUAL BALANCE MAINTENANCE DREDGING & SHORELINE MITIGAT 163,000$ 31,217$ 131,783$ AIRPORT OFFICE REHAB 2,718,316 - 2,718,316 MAJOR FACILITY MAINTENANCE 511,135 337,879 173,256 SURFACE WATER SYSTEM REHABILITATION 94,496 - 94,496 PAVEMENT MANAGEMENT PROGRAM 805,930 184,356 621,574 SNOW REMOVAL EQUIPMENT 167,000 - 167,000 MASTER PLAN UPDATE 182,394 11,856 170,538 TAXIWAY ALPHA REHABILITATION 1,317,495 - 1,317,495 RUNWAY SAFETY AREA 774,359 - 774,359 ENVIRONMENTAL IMPACT STUDY 400,000 - 400,000 TOTAL PROJECT BALANCES 7,134,125$ 565,308$ 6,568,817$ Non-capital items included in project budgets (610,000) (107,201) (502,799) Operating fund equipment purchase - - - TOTAL CAPITAL OUTLAY 6,524,125$ 458,107$ 6,066,018$ AIRPORT PROJECT BALANCES AT SEPTEMBER 30, 2021 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 89,664$           313,136$                69,496$           (20,168)$          (243,640)$        22.19% Charges for services 15,587,987      22,636,386            15,625,585      37,598              (7,010,801)       69.03% Interest and other misc 20,695              5,000                       7,776                (12,919)            2,776                155.52% TOTAL REVENUES 15,698,346      22,954,522            15,702,857      4,511                (7,251,665)       68.41% EXPENSES: Personnel 426,817           727,085                  388,806           38,011              338,279           53.47% Supplies 3,252                11,900                    471                   2,781                11,429              3.96% Contracted Services 13,634,509      21,855,539            14,178,479      (543,970)          7,677,060        64.87% Internal Services 340,558           307,806                  230,869           109,689           76,937              75.00% TOTAL OPERATING EXPENSES 14,405,136      22,902,330            14,798,625      (393,489)          8,103,705        64.62% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,293,210        52,192                    904,232           (388,978)          852,040           1732.52% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TRANSFERS OUT ‐                          ‐                                94                      (94)                    (94)                    N/A NET TRANSFERS ‐                          ‐                                (94)                    (94)                    (94)                    N/A CHANGE IN FUND BALANCE 1,293,210        52,192                    904,138           (389,072)          851,946           1732.33% BEGINNING FUND BALANCE, Jan 1 2,266,127        2,771,562               2,771,562        505,435            ‐                         100.00% ENDING FUND BALANCE, Sep 30 3,559,337$      2,823,754$            3,675,700$      116,363$         851,946$         130.17% Operating Reserve 400,000           400,000                  400,000            AVAILABLE FUND BALANCE 3,159,337$      2,423,754$            3,275,700$       SOLID WASTE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 26 of 40   Golf Course Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Maplewood Golf Course.         Capital Outlay – A listing of project budgets and balances at September 30 is as follows:           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 1,787,980$      2,304,205$            2,383,998$      596,018$         79,793$           103.46% Rents, leases, and misc fees 276,076           527,600                  345,680           69,604              (181,920)          65.52% Interest and other misc 2,667                226,679                  3,310                643                   (223,369)          1.46% TOTAL REVENUES 2,066,723        3,058,484               2,732,988        666,265           (325,496)          89.36% EXPENSES: Personnel 1,070,421        1,673,092               1,169,634        (99,213)            503,458           69.91% Supplies 242,422           321,704                  288,350           (45,928)            33,354              89.63% Contracted Services 126,244           176,150                  99,897              26,347              76,253              56.71% Internal Services 256,533           350,253                  262,692           (6,159)               87,561              75.00% TOTAL OPERATING EXPENSES 1,695,620        2,521,199               1,820,573        (124,953)          700,626           72.21% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 371,103           537,285                  912,415           541,312           375,130           169.82% DEBT SERVICE: Principal ‐                         29,395                     ‐                          ‐                         29,395              0.00% Interest ‐                         1,416                        ‐                          ‐                         1,416                0.00% TOTAL DEBT SERVICE ‐                         30,811                     ‐                         ‐                         30,811              0.00% CAPITAL OUTLAY ‐                         270,309                  12,662              (12,662)            257,647           4.68% TRANSFERS IN 57,000              68,100                    51,075              (5,925)               (17,025)            75.00% TRANSFERS OUT 59,695              68,100                    51,075              8,620                17,025              75.00% NET TRANSFERS (2,695)                ‐                                 ‐                         2,695                 ‐                         N/A CHANGE IN FUND BALANCE 368,408           236,165                  899,753           531,345           663,588           380.98% BEGINNING FUND BALANCE, Jan 1 173,750           476,746                  476,746           302,996            ‐                         100.00% ENDING FUND BALANCE, Sep 30 542,158$         712,911$                1,376,499$      834,341$         663,588$         193.08% Operating Reserve 585,769           641,500                  641,500            AVAILABLE FUND BALANCE (43,611)$          71,411$                  734,999$          GOLF COURSE VARIANCE PROJECT BUDGET ACTUAL BALANCE MACHINERY & EQUIPMENT 250,309$ -$ 250,309$ GOLF MM COURSE - MAINTENANCE 43,100 - 43,100 TOTAL PROJECT BALANCES 293,409$ -$ 293,409$ Non-capital items included in project budgets (43,100) - (43,100) Operating fund equipment purchase 20,000 12,662 7,338 TOTAL CAPITAL OUTLAY 270,309$ 12,662$ 257,647$ GOLF PROJECT BALANCES AT SEPTEMBER 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 27 of 40   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.        Capital Outlay ‐ A listing of project budgets and balances at September 30 is provided on the following page.     2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 12,721,901$   17,314,812$          14,073,834$   1,351,933$      (3,240,978)$    81.28% Rents, leases, and misc fees 232,204           136,591                  141,129           (91,075)            4,538                103.32% Interest and other misc 637,326           521,000                  459,737           (177,589)          (61,263)            88.24% TOTAL REVENUES 13,597,031      17,972,403            14,674,700      1,077,669        (3,297,703)       81.65% EXPENSES: Personnel 3,226,180        4,753,110               3,452,860        (226,680)          1,300,250        72.64% Supplies 595,044           885,876                  638,118           (43,074)            247,758           72.03% Contracted Services 2,231,474        3,464,394               2,341,678        (110,204)          1,122,716        67.59% Internal Services 1,550,720        2,539,605               1,904,709        (353,989)          634,896           75.00% TOTAL OPERATING EXPENSES 7,603,418        11,642,985            8,337,365        (733,947)          3,305,620        71.61% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 5,993,613        6,329,418               6,337,335        343,722           7,917                100.13% DEBT SERVICE: Principal 345,818           1,563,068               345,818            ‐                         1,217,250        22.12% Interest 105,595           216,506                  98,375              7,220                118,131           45.44% TOTAL DEBT SERVICE 451,413           1,779,574               444,193           7,220                1,335,381        24.96% CAPITAL OUTLAY 2,369,026        35,563,246            2,687,602        (318,576)          32,875,644      7.56% TRANSFERS OUT 330                    ‐                                2,626                (2,296)               (2,626)               N/A NET TRANSFERS (330)                   ‐                                (2,626)               (2,296)               (2,626)               N/A CHANGE IN FUND BALANCE 3,172,844        (31,013,402)           3,202,914        30,070              34,216,316      N/A BEGINNING FUND BALANCE, Jan 1 37,569,067      40,776,314            40,776,314      3,207,247         ‐                         100.00% ENDING FUND BALANCE, Sep 30 40,741,911$   9,762,912$            43,979,228$   3,237,317$      34,216,316$   450.47% Restricted for Debt Service 1,394,050        1,394,050               1,394,050         Operating Reserve 3,072,760        1,614,304               1,614,304         AVAILABLE FUND BALANCE 36,275,101$   6,754,558$            40,970,874$    WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 28 of 40   Water Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE PIPE OVERSIZING COSTS 100,000$ -$ 100,000$ TELEMETRY IMPROVEMENTS-PHASE 4 227,965 4,796 223,169 WATER SYSTEM PLAN UPDATE 334,254 45,064 289,190 UPDATE EMERGENCY RESPONSE PLAN 221,490 14,822 206,668 STEEL/AC WATERMAIN REPLC PLAN 1,553,482 51,770 1,501,712 RESERVOIR RECOATING 194,600 - 194,600 EMERGENCY RESPONSE PROJ 100,000 - 100,000 DOWNTOWN WATER MAIN REPLACEMENT 3,909,613 1,353,048 2,556,565 WATER PUMP STATIONS REHAB 400,000 10,680 389,320 RESERVOIR PRV METERS 337,235 9,983 327,252 MPLWD WATER TREATMENT IMPROV - CONST 715,241 12,890 702,351 HIGHLANDS WATER MAIN IMPROVEMENT 1,078,738 561,720 517,018 DUVALL AVE NE WATER MAIN REPLACEMENT 457,600 139 457,461 EMERGENCY POWER TO PUMP STATION 290,586 454 290,132 WATER SYSTEM SECURITY IMPROVEMENTS 100,000 - 100,000 AQUIFER MONITORING AND MANAGEMENT 30,000 - 30,000 WATER TREATMENT FILTER MEDIA 392,936 1,093 391,843 WSDOT I-405 WATER RELOCATIONS 536,810 2,083 534,727 AUTOMATIC METER READING CONVERSION 196,115 - 196,115 HIGHLANDS 435-RESERVOIRS REPLACEMENT 23,065,776 115,391 22,950,385 RAINIER AVE S ROAD & UTILITIES IMPRVMNT 300,000 - 300,000 KENNYDALE 320-RESERVOIR 790,842 560,013 230,829 BRONSN/HOUSR/WILLIAM BRIDGES WTRMAINREPL 200,000 - 200,000 TOTAL PROJECT BALANCES 35,533,283$ 2,743,946$ 32,789,337$ Non-capital items included in project budgets - (68,530) 68,530 Operating fund equipment purchase 29,963 12,186 17,777 TOTAL CAPITAL OUTLAY 35,563,246$ 2,687,602$ 32,875,644$ WATER UTILITY FUND PROJECT BALANCES AT SEPTEMBER 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 29 of 40   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.        Capital Outlay ‐ A listing of project budgets and balances at September 30 is provided on the following page.   2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 73,400$           62,111$                  74,250$           850$                 12,139$           119.54% Charges for services 8,012,821        11,280,375            8,428,851        416,030           (2,851,524)       74.72% Fines and penalties 263                    ‐                                5,133                4,870                5,133                N/A Interest and other misc 500,862           444,000                  638,984           138,122           194,984           143.92% TOTAL REVENUES 8,587,346        11,786,486            9,147,218        559,872           (2,639,268)       77.61% EXPENSES: Personnel 1,777,775        2,651,185               1,683,762        94,013              967,423           63.51% Supplies 50,287              73,842                    67,240              (16,953)            6,602                91.06% Contracted Services 1,496,209        3,026,771               1,645,237        (149,028)          1,381,534        54.36% Internal Services 1,100,375        1,933,601               1,450,210        (349,835)          483,391           75.00% TOTAL OPERATING EXPENSES 4,424,646        7,685,399               4,846,449        (421,803)          2,838,950        63.06% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 4,162,700        4,101,087               4,300,769        138,069           199,682           104.87% DEBT SERVICE: Principal ‐                         612,850                   ‐                          ‐                         612,850           0.00% Interest 45,398              97,301                    42,551              2,847                54,750              43.73% TOTAL DEBT SERVICE 45,398              710,151                  42,551              2,847                667,600           5.99% CAPITAL OUTLAY 529,316           20,241,883            5,936,064        (5,406,748)       14,305,819      29.33% TRANSFERS OUT ‐                          ‐                                2,251                (2,251)               (2,251)               N/A NET TRANSFERS ‐                          ‐                                (2,251)               (2,251)               (2,251)               N/A CHANGE IN FUND BALANCE 3,587,986        (16,850,947)           (1,680,097)       (5,268,083)       15,170,850      N/A BEGINNING FUND BALANCE, Jan 1 19,832,351      23,996,217            23,996,217      4,163,866         ‐                         100.00% ENDING FUND BALANCE, Sep 30 23,420,337$   7,145,270$            22,316,120$   (1,104,217)$    15,170,850$   312.32% Restricted for Debt Service 661,227           661,227                  661,227            Operating Reserve 1,489,966        914,224                  914,224            AVAILABLE FUND BALANCE 21,269,144$   5,569,819$            20,740,669$    WASTEWATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 30 of 40   Wastewater Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE MISCELANEOUS SEWER PROJECTS 379,419$ 573$ 378,846$ 2008 LONG-RANGE WW MANAG PLAN 62,597 36,331 26,266 WASTEWATER OPERATIONS MASTER PLAN 724,622 467 724,155 THUNDER HILL INT REPL/REHAB 3,074,074 37,824 3,036,250 FORCE MAIN REHABILITATION REPLACEMENT 1,883,308 38,923 1,844,385 LIFT STATION REHABILITATION 1,879,795 41,730 1,838,065 DOWNTOWN SEWER REPLACEMENT/REHAB 7,192,313 5,447,075 1,745,238 KENNYDALE LAKELINE SEWER UPGRADE 3,344,460 357,325 2,987,135 SANITARY SEWER REHAB/REPLACEMENT 2,478,314 16,920 2,461,394 TOTAL PROJECT BALANCES 21,018,902$ 5,977,168$ 15,041,734$ Non-capital items included in project budgets (787,219) (41,104) (746,115) Operating fund equipment purchase 10,200 - 10,200 TOTAL CAPITAL OUTLAY 20,241,883$ 5,936,064$ 14,305,819$ WASTEWATER UTILITY FUND PROJECT BALANCES AT SEPTEMBER 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 31 of 40   King County Metro Fund  This fund accounts for revenues and expenses for operation of the City’s wastewater utility, as it relates to charges for and  payment to King County Metro for water treatment services.        Capital Outlay ‐ The King County Metro Fund does not have a capital fund.     2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 12,532,990$   17,607,838$          13,263,925$   730,935$         (4,343,913)$    75.33% Interest and other misc 39,896               ‐                                12,861              (27,035)            12,861              N/A TOTAL REVENUES 12,572,886      17,607,838            13,276,786      703,900           (4,331,052)       75.40% EXPENSES: Contracted Services 13,784,380      17,607,838            13,015,696      768,684           4,592,142        73.92% TOTAL OPERATING EXPENSES 13,784,380      17,607,838            13,015,696      768,684           4,592,142        73.92% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (1,211,494)        ‐                                261,090           1,472,584        261,090           N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE (1,211,494)        ‐                                261,090           1,472,584        261,090           N/A BEGINNING FUND BALANCE, Jan 1 5,961,906        4,729,749               4,729,749        (1,232,157)        ‐                         100.00% ENDING FUND BALANCE, Sep 30 4,750,412$      4,729,749$            4,990,839$      240,427$         261,090$         105.52% Operating Reserve 380,000           380,000                  380,000            AVAILABLE FUND BALANCE 4,370,412$      4,349,749$            4,610,839$       KING COUNTY METRO VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 32 of 40   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.        Capital Outlay ‐ A listing of project budgets and balances at September 30 is provided on the following page.     2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 52,475$           50,708$                  24,000$           (28,475)$          (26,708)$          47.33% Grants / intergovernmental 778,027           9,605,713               803,689           25,662              (8,802,024)       8.37% Charges for services 8,944,514        12,101,509            9,515,917        571,403           (2,585,592)       78.63% Interest and other misc 291,358           2,519,338               1,129,745        838,387           (1,389,593)       44.84% TOTAL REVENUES 10,066,374      24,277,268            11,473,351      1,406,977        (12,803,917)    47.26% EXPENSES: Personnel 2,750,768        3,730,881               2,786,229        (35,461)            944,652           74.68% Supplies 81,508              177,267                  91,100              (9,592)               86,167              51.39% Contracted Services 1,309,798        4,343,462               1,771,031        (461,233)          2,572,431        40.77% Internal Services 1,306,639        2,557,505               1,918,141        (611,502)          639,364           75.00% TOTAL OPERATING EXPENSES 5,448,713        10,809,115            6,566,501        (1,117,788)       4,242,614        60.75% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 4,617,661        13,468,153            4,906,850        289,189           (8,561,303)       36.43% DEBT SERVICE: Principal ‐                         499,900                   ‐                          ‐                         499,900           0.00% Interest 443,768           630,950                  50,985              392,783           579,965           8.08% TOTAL DEBT SERVICE 443,768           1,130,850               50,985              392,783           1,079,865        4.51% CAPITAL OUTLAY 1,242,968        19,699,466            4,646,198        (3,403,230)       15,053,268      23.59% Transfers Out ‐                         18,347                    20,598              (20,598)            (2,251)               112.27% NET TRANSFERS ‐                         (18,347)                   (20,598)            (20,598)            (2,251)               N/A CHANGE IN FUND BALANCE 2,930,925        (7,380,510)             189,069           (2,741,856)       7,569,579        N/A BEGINNING FUND BALANCE, Jan 1 18,377,556      21,610,356            21,610,356      3,232,800         ‐                         100.00% ENDING FUND BALANCE, Sep 30 21,308,481$   14,229,846$          21,799,425$   490,944$         7,569,579$      153.20% Restricted for Debt Service 754,868           754,868                  754,868            Operating Reserve 1,252,915        1,116,680               1,116,680         AVAILABLE FUND BALANCE 19,300,698$   12,358,298$          19,927,877$    SURFACE WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 33 of 40   Surface Water Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE COMP S&SW MGMT PLAN P&D 28,474$ 11,254$ 17,220$ SM DRAINAGE PROBLEMS 578,564 32,005 546,559 PANTHER CR WL MOSQUITO ABATEMENT 95,776 43,312 52,464 MADSEN CREEK SEDIMENT BASIN 121,675 75,310 46,365 SMALL DRAINAGE PROJ-MAPLEWOOD SEDIMENT 155,120 80,278 74,842 WETLAND MITIGATION BANK 109,586 - 109,586 ACOE 205 PROJECT 58,737 10,281 48,456 CEDAR RIVER GRAVEL REMOVAL 2,681,201 54,564 2,626,637 RENTON STORM WATER MANUAL 68,147 2,109 66,038 GREEN RIVER ECOSYSTEM STUDY 48,177 562 47,615 MISCELLANEOUS/EMERGENCY/STORM PROJECTS 100,000 - 100,000 SURFACE WATER UTILITY GIS 121,755 101,449 20,306 HARDIE AVE S UNDERPASS STORM SYSTEM IMPR 2,391 - 2,391 MONROE AVE/N 2ND ST 826,497 407,885 418,612 STORMWATER FACILITY FENCING PROJECT 262,201 14,537 247,664 CEDAR RIVER 205 LEVEE RECERTIFICATION 4,532,900 235,177 4,297,723 SE 172ND ST/125TH AVE SE 140,399 140,480 (81) RAINIER AVE/OAKSDALE AVE PUMP STATION UP 147,121 28,829 118,292 NE 16TH/JEFFERSON AVE NE 2,623,430 991,025 1,632,405 DOWNTOWN STORM SYSTEM IMPROVEMENT PROJEC 5,705,776 2,555,716 3,150,060 HEATHER DOWNS DETENTION POND 786,921 154,854 632,067 MADSEN CRK IMPROV PHASE 1-KCFCD 843,598 75,048 768,550 RAINIER AVE/BENSON RD S - CULVERT REPL - - - CMP STORM SYSTEM REPLACEMENT PROJECT 559,038 67,832 491,206 CEDAR RIVER FLOOD RISK REDUCTION 491,545 34,575 456,970 STORMWATER FACILITY RETROFIT STUDY 271,810 163,994 107,816 BURNETT AVE S/WILLIAMS AVE S 495,797 138,229 357,568 WSDOT LA ROW RUNOFF IMPACT MITIGATION 145,471 51,427 94,044 SW 23RD ST DRAINAGE AND FISH PASSAGE IMP 350,000 - 350,000 TOTAL PROJECT BALANCES 22,352,107$ 5,470,732$ 16,881,375$ Non-capital items included in project budgets (2,681,201) (824,534) (1,856,667) Operating fund equipment purchase 28,560 - 28,560 TOTAL CAPITAL OUTLAY 19,699,466$ 4,646,198$ 15,053,268$ SURFACE WATER UTILITY PROJECT BALANCES AT SEPTEMBER 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 34 of 40   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.            2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 25,350$            ‐$                             56,194$           30,844$           56,194$           N/A Interdepartmental services 2,730,924        6,451,395               4,932,549        2,201,625        (1,518,846)       76.46% Interest and other misc 45,564              12,000                    122,836           77,272              110,836           1023.63% TOTAL REVENUES 2,801,838        6,463,395               5,111,579        2,309,741        (1,351,816)       79.09% EXPENSES: Personnel 798,378           1,206,146               796,099           2,279                410,047           66.00% Supplies 737,840           1,496,153               975,971           (238,131)          520,182           65.23% Contracted Services 179,478           133,166                  232,198           (52,720)            (99,032)            174.37% Internal Services 24,523              30,338                    22,754              1,769                7,584                75.00% TOTAL OPERATING EXPENSES 1,740,219        2,865,803               2,027,022        (286,803)          838,781           70.73% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,061,619        3,597,592               3,084,557        2,022,938        (513,035)          85.74% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 1,152,126        2,423,743               256,740           895,386           2,167,003        10.59% TRANSFERS IN ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TRANSFERS OUT ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE (90,507)            1,173,849               2,827,817        2,918,324        1,653,968        240.90% BEGINNING FUND BALANCE, Jan 1 6,851,811        6,376,259               6,376,259        (475,552)           ‐                         100.00% ENDING FUND BALANCE, Sep 30 6,761,304$      7,550,108$            9,204,076$      2,442,772$      1,653,968$      121.91% EQUIPMENT RENTAL VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 35 of 40   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.           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 2,326,432$      3,511,775$            2,383,221$      56,789$           (1,128,554)$    67.86% Interest and other misc 176,289           22,000                    223,637           47,348              201,637           1016.53% TOTAL REVENUES 2,502,721        3,533,775               2,606,858        104,137           (926,917)          73.77% EXPENSES: Personnel 670,219           1,411,787               905,961           (235,742)          505,826           64.17% Supplies 401                   6,956                       30                      371                   6,926                0.43% Contracted Services 1,691,104        2,279,772               2,234,238        (543,134)          45,534              98.00% TOTAL OPERATING EXPENSES 2,361,724        3,698,515               3,140,229        (778,505)          558,286           84.91% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 140,997           (164,740)                 (533,371)          (674,368)          (368,631)          N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A Transfers In ‐                          ‐                                 ‐                          ‐                          ‐                         N/A Transfers Out 4,500,000         ‐                                52,868              4,447,132        (52,868)            N/A NET TRANSFERS (4,500,000)        ‐                                (52,868)            4,447,132        (52,868)            N/A CHANGE IN FUND BALANCE (4,359,003)       (164,740)                 (586,239)          3,772,764        (421,499)          N/A BEGINNING FUND BALANCE, Jan 1 19,095,508      19,860,208            19,860,208      764,700            ‐                         100.00% ENDING FUND BALANCE, Sep 30 14,736,505$   19,695,468$          19,273,969$   4,537,464$      (421,499)$        97.86% Operating Reserves 16,479,631      17,708,251            17,708,251       AVAILABLE FUND BALANCE (1,743,126)$    1,987,217$            1,565,718$       INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 36 of 40   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.            2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 187,471$         150,000$                147,064$         (40,407)$          (2,936)$            98.04% Interdepartmental services 4,030,021        6,435,901               4,826,925        796,904           (1,608,976)       75.00% Interest and other misc 31,612              7,000                       36,332              4,720                29,332              519.03% TOTAL REVENUES 4,249,104        6,592,901               5,010,321        761,217           (1,582,580)       76.00% EXPENSES: Personnel 2,168,040        3,292,443               2,152,287        15,753              1,140,156        65.37% Supplies 286,595           757,555                  292,931           (6,336)               464,624           38.67% Contracted Services 1,492,963        2,486,071               1,559,605        (66,642)            926,466           62.73% Internal Services 1,353                 ‐                                 ‐                         1,353                 ‐                         N/A TOTAL OPERATING EXPENSES 3,948,951        6,536,069               4,004,823        (55,872)            2,531,246        61.27% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 300,153           56,832                    1,005,498        705,345           948,666           1769.25% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 41,144              838,000                  118,614           (77,470)            719,386           14.15% TRANSFERS IN 15,392              21,477                    120,203           104,811           98,726              559.68% NET TRANSFERS 15,392              21,477                    120,203           104,811           98,726              559.68% CHANGE IN FUND BALANCE 274,401           (759,691)                 1,007,087        732,686           1,766,778        N/A BEGINNING FUND BALANCE, Jan 1 4,490,062        3,939,941               3,939,941        (550,121)           ‐                         100.00% ENDING FUND BALANCE, Sep 30 4,764,463$      3,180,250$            4,947,028$      182,565$         1,766,778$      155.55% INFORMATION TECHNOLOGY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 37 of 40   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.            2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 21,835$            ‐$                              ‐$                       (21,835)$           ‐$                       N/A Interdepartmental services 3,112,332        5,992,730               4,491,957        1,379,625        (1,500,773)       74.96% Rents, leases, and misc fees 1                         ‐                                 ‐                         (1)                        ‐                         N/A Interest and other misc 8,266                4,000                       1,244                (7,022)               (2,756)               31.10% TOTAL REVENUES 3,142,434        5,996,730               4,493,201        1,350,767        (1,503,529)       74.93% EXPENSES: Personnel 2,184,104        3,861,996               2,192,307        (8,203)               1,669,689        56.77% Supplies 321,244           307,251                  345,266           (24,022)            (38,015)            112.37% Contracted Services 992,662           1,870,336               985,977           6,685                884,359           52.72% Internal Services 51,365              129,486                  97,115              (45,750)            32,371              75.00% TOTAL OPERATING EXPENSES 3,549,375        6,169,069               3,620,665        (71,290)            2,548,404        58.69% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (406,941)          (172,339)                 872,536           1,279,477        1,044,875        N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 5,704                 ‐                                40,063              (34,359)            (40,063)            N/A Transfers In 8,596                 ‐                                 ‐                         (8,596)                ‐                         N/A NET TRANSFERS 8,596                 ‐                                 ‐                         (8,596)                ‐                         N/A CHANGE IN FUND BALANCE (404,049)          (172,339)                 832,473           1,236,522        1,004,812        N/A BEGINNING FUND BALANCE, Jan 1 1,220,276        504,167                  504,167           (716,109)           ‐                         100.00% ENDING FUND BALANCE, Sep 30 816,227$         331,828$                1,336,640$      520,413$         1,004,812$      402.81% FACILITIES VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 38 of 40   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.           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 374,560$         1,154,732$            865,574$         491,014$         (289,158)$        74.96% Interest and other misc 4,870                1,000                       424                   (4,446)               (576)                  42.40% TOTAL REVENUES 429,120           1,155,732               865,998           436,878           (289,734)          74.93% EXPENSES: Personnel 633,054           810,882                  479,772           153,282           331,110           59.17% Supplies 21,971              55,432                    19,665              2,306                35,767              35.48% Contracted Services 180,501           284,512                  115,369           65,132              169,143           40.55% Internal Services 2,956                2,000                       1,500                1,456                500                   75.00% TOTAL OPERATING EXPENSES 838,482           1,152,826               616,306           222,176           536,520           53.46% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (409,362)          2,906                       249,692           659,054           246,786           8592.29% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A Transfers Out 4,229                 ‐                                 ‐                         4,229                 ‐                         N/A NET TRANSFERS (4,229)                ‐                                 ‐                         4,229                 ‐                         N/A CHANGE IN FUND BALANCE (413,591)          2,906                       249,692           663,283           246,786           8592.29% BEGINNING FUND BALANCE, Jan 1 803,561           151,624                  151,624           (651,937)           ‐                         100.00% ENDING FUND BALANCE, Sep 30 389,970$         154,530$                401,316$         11,346$           246,786$         259.70% COMMUNICATIONS VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 39 of 40   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.              2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Premiums 8,611,547$      12,328,055$            9,181,575$      570,028$         (3,146,480)$    74.48% Interest and other misc 122,894           149,488                    257,196           134,302           107,708           172.05% TOTAL REVENUES 8,734,441        12,477,543               9,438,771        704,330           (3,038,772)       75.65% EXPENSES: Personnel 198,130           315,268                    230,702           (32,572)            84,566              73.18% Medical/Dental Claims 6,794,239        11,699,850               8,388,600        (1,594,361)       3,311,250        71.70% Supplies 6,881                7,500                         844                   6,037                6,656                11.25% Contracted Services 381,306           478,037                    338,593           42,713              139,444           70.83% Internal Services 45,322              80,176                       60,132              (14,810)            20,044              75.00% TOTAL OPERATING EXPENSES 7,425,878        12,580,831               9,018,871        (1,592,993)       3,561,960        71.69% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,308,563        (103,288)                   419,900           (888,663)          523,188           N/A TOTAL DEBT SERVICE ‐                          ‐                                   ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                   ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                   ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 1,308,563        (103,288)                   419,900           (888,663)          523,188           N/A BEGINNING FUND BALANCE, Jan 1 5,151,648        5,773,429                 5,773,429        621,781            ‐                         100.00% ENDING FUND BALANCE, Sep 30 6,460,211$      5,670,141$               6,193,329$      (266,882)$        523,188$         109.23% Insurance Reserves 3,757,179        3,774,249                 3,774,249         AVAILABLE FUND BALANCE 2,703,032$      1,895,892$               2,419,080$       HEALTH INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 3rd Quarter 2021  Page 40 of 40   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.                             CONTACT INFORMATION  This report is prepared by the Finance Division of the Administrative Services Department. For additional financial  information, please also review our website: http://www.rentonwa.gov/.  For any questions about the report, please feel  free to contact Misty Baker at mbaker@rentonwa.gov or Kari Roller at kroller@rentonwa.gov. 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 35,245$           45,933$                  40,651$           5,406$              (5,282)$            88.50% Premiums 1,218,513        2,640,000               1,968,513        750,000           (671,487)          74.56% Interest and other misc 104,196           20,000                    111,291           7,095                91,291              556.46% TOTAL REVENUES 1,357,954        2,705,933               2,120,455        762,501           (585,478)          78.36% EXPENSES: Personnel 21,515              99,418                    69,808              (48,293)            29,610              70.22% Medical/Dental Claims 779,900           1,233,956               764,505           15,395              469,451           61.96% Contracted Services 35,925              29,311                    54,364              (18,439)            (25,053)            185.47% TOTAL OPERATING EXPENSES 837,340           1,362,685               888,677           (51,337)            474,008           65.22% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 520,614           1,343,248               1,231,778        711,164           (111,470)          91.70% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 520,614           1,343,248               1,231,778        711,164           (111,470)          91.70% BEGINNING FUND BALANCE, Jan 1 15,799,729      16,541,245            16,541,245      741,516            ‐                         100.00% ENDING FUND BALANCE, Sep 30 16,320,343$   17,884,493$          17,773,023$   1,452,680$      (111,470)$        99.38% Insurance Reserves 16,320,343      17,884,493            17,773,023       AVAILABLE FUND BALANCE ‐$                        ‐$                              ‐$                        RETIREE HEALTHCARE VARIANCE