Loading...
HomeMy WebLinkAboutQUARTER 1 2021 H:\Finance\Financial Reporting\Monthly Reports\2021 Reports\QUARTERLY\Cover 1Q2021.docx  ADMINISTRATIVE SERVICES    M   E   M   O   R   A   N   D   U   M       DATE: July 12, 2021     TO: Randy Corman, Council President  Members of Renton City Council     CC: Armondo Pavone, Mayor  Ed VanValey, Chief Administrative Officer     FROM: Kari Roller, ASD Administrator     STAFF CONTACT: Misty Baker, Sr. Finance Analyst     SUBJECT: Quarterly Financial Report 1st 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 March 2021.      General Fund revenues, excluding Interfund transfers, were $25M, which is $582K less  than 2020, but $4.5M over the YTD budget. General Fund expenditures, excluding  Interfund transfers, were $25M, which is $790K more than 2020 and $4M less than the  YTD budget.  Detailed explanations are provided for items with variances exceeding  $100K.    Also provided are tables for each of the City’s other funds with comparison to prior year  and annual budget (YTD budgets are not prepared for City funds, with the exception of  the General Fund). For funds that adopt capital project budgets (which are subject to carry  forward in accordance with City Policy 220‐01), schedules of the project budgets have  also been provided.     Please do not hesitate to contact me at x6869 should you have any questions or any  suggestions about the report.      Page 1 of 41   OVERVIEW  This quarterly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through March 31,  2021. A detailed analysis, including current to prior year and budget to actual comparison is included for each City fund.  Excluded from this report are the City’s fiduciary funds as these funds are held on behalf of others and are not available for  City use. Budget figures shown reflect amounts authorized in ORD 6017, which includes the 1st quarter/carry forward budget  adjustment approved by Council May 3, 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 18,732,107$      73,959,450$    14,272,748$ 18,546,454$   (185,653)$         4,273,706$   25.08% Licenses & Permits 1,787,131            4,776,877          1,589,246       1,684,256         (102,875)            95,010              35.26% Intergovernmental 1,065,400            6,204,385          987,201            1,279,304         213,904              292,103           20.62% Charges for Services 2,133,062            8,169,266          2,102,935       2,381,993         248,931              279,058           29.16% Fines and Penalties 1,031,591            3,829,782          1,016,052       674,603             (356,988)            (341,449)         17.61% Miscellaneous 803,846                1,862,675          562,411            404,333             (399,513)            (158,078)         21.71% Other Financing Sources (Transfer‐In, etc) 25,000                   14,782,012        ‐                        23,980                (1,020)                  23,980              0.16% TOTAL REVENUES 25,578,137         113,584,447    20,530,593    24,994,923      (583,214)            4,464,330      22.01% EXPENDITURES Council 110,254                554,485               168,058            142,485             (32,231)               25,573              25.70% Executive 682,606                2,948,767          827,256            638,881             43,725                 188,375           21.67% Emergency Management 174,699                781,615               128,800            166,324             8,375                    (37,524)            21.28% City Attorney 610,316                2,611,347          682,096            618,748             (8,432)                  63,348              23.69% Court Services 642,518                3,102,930          800,255            663,113             (20,595)               137,142           21.37% Community and Eco Dvlpmnt Admin 378,000                1,614,739          515,554            466,949             (88,949)               48,605              28.92% Development Services 646,498                2,909,376          729,969            574,251             72,247                 155,718           19.74% Economic Development 442,964                3,537,583          529,486            1,729,606         (1,286,642)        (1,200,120)     48.89% Planning 1,034,221            4,954,391          1,258,157       1,078,415         (44,194)               179,742           21.77% Finance 719,412                4,158,944          879,146            848,404             (128,992)            30,742              20.40% City Clerk 433,238                1,473,840          526,603            251,420             181,818              275,183           17.06% Human Resources 366,847                1,656,832          393,177            351,549             15,298                 41,628              21.22% Police 9,424,063            38,317,266       10,333,723    9,038,377         385,686              1,295,346      23.59% Jail Services 1,177,184            4,707,758          1,176,988       1,176,939         245                        49                        25.00% Community Services Admin 143,479                592,057               164,700            140,589             2,890                    24,111              23.75% Leased Properties 166,529                849,876               203,598            185,375             (18,846)               18,223              21.81% Parks & Trails 1,196,758            6,796,819          1,605,670       1,326,607         (129,849)            279,063           19.52% Parks Planning & Natural Resources 352,066                2,049,361          326,603            283,346             68,720                 43,257              13.83% Recreation & Neighborhoods 1,335,846            6,568,899          1,675,174       1,025,404         310,442              649,770           15.61% Human Services 288,130                1,568,140          295,284            237,794             50,336                 57,490              15.16% Museum 66,535                   289,701               80,758               67,064                (529)                       13,694              23.15% Public Works Admin 107,999                497,991               136,019            122,920             (14,921)               13,099              24.68% Street Maintenance 1,400,798            6,580,354          1,712,515       1,489,713         (88,915)               222,802           22.64% Transportation 1,453,101            6,638,464          1,623,671       1,541,101         (88,000)               82,570              23.21% Non‐Departmental and Other 816,226                25,273,904       2,207,111       795,345             20,881                 1,411,766      3.15% TOTAL EXPENDITURES 24,170,287         131,035,439    28,980,371    24,960,719      (790,432)            4,019,652      19.05% Change in Fund Balance 1,407,850            (17,450,992)      (8,449,778)      34,204                (1,373,646)        8,483,982      N/A Beginning Fund Balance 48,056,982         54,391,582       54,391,582    54,391,582      6,334,600          ‐                       100.00% ENDING FUND BALANCE 49,464,832$      36,940,590$    45,941,804$ 54,425,786$   4,960,954$      8,483,982$   147.33% Operating Reserve 13,994,674         8,600,000          8,600,000       8,600,000          Economic Development Reserve 2,500,000            2,500,000          2,500,000       2,500,000          AVAILABLE FUND BALANCE 32,970,158$      25,840,590$    34,841,804$ 43,325,786$    Summary of Sources and Uses Favorable (Unfavorable) 2020 2021 Variance YTD Actual Annual Budget YTD Budget YTD Actual Quarterly Financial Report 1st Quarter 2021  Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 2 of 41   GENERAL FUND REVENUES  The following tables provide a more detailed summary of each revenue category within the General Fund. Detailed  explanations have been provided for variances from prior year or YTD budget in excess of $100K. All variances are shown in  a favourable/(unfavourable) format.    TAXES        Property Tax – Property tax collections by King County have exceeded prior year and YTD budget. $116K of property taxes  collected through March 31 were for prior years’ delinquent taxes, bringing the balance of delinquent taxes receivable to  $191K. 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 $21.5M at March 31.    Local Retail Sales Tax – COVID‐19 will continue to influence the sales tax figures throughout 2021. There are three factors  which are going to impact our sales tax distribution: 1) DOR is providing extensions for some filers, 2) many stores and other  retail locations have been required to be or operating at limited capacity, and 3) some businesses will be closing permanently  due to decreased revenues. However, we are seeing some industries recover and distributions are better than anticipated  to‐date. Please see the monthly sales tax report for more information.    Local Retail Sales Tax – Housing & Related 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 2nd quarter budget  adjustment. The additional sales and use tax is restricted for housing and related services, in accordance with RCW 82.14.530.  An interdepartmental team is currently working on compiling a list of qualifying projects and will present their  recommendations to Council for approval.     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 breakdown of Utility Tax is as follows:      2020 2021 2021 Actual Budget Actual $ % $ % Property Tax 1,062,041            984,973                 1,376,356            314,315              29.6% 391,383              39.7% Local Retail Sales Tax 7,277,582            6,318,391             7,635,399            357,817              4.9% 1,317,008         20.8% Local Retail Sales Tax ‐ Housing & Related Svc ‐                                    ‐                                   273,838                 273,838              100.0% 273,838              100.0% State Sales Tax Credit 159,427                 101,115                 77,163                    (82,264)                ‐51.6% (23,952)                ‐23.7% Criminal Justice Sales Tax 828,690                 777,483                 798,138                 (30,552)                ‐3.7%20,655                 2.7% Natural Gas Use Tax 48,745                    86,065                    41,127                    (7,618)                   ‐15.6% (44,938)                ‐52.2% Admission Tax 53,883                    54,756                     ‐                                   (53,883)               0.0%(54,756)               0.0% Utility Tax 4,337,978            3,640,427             4,290,228            (47,750)                ‐1.1%649,801              17.8% Leasehold Excise Tax 46,879                    30,867                    41,317                    (5,562)                   ‐11.9%10,450                 33.9% Gambling Excise Tax 897,556                 543,343                 828,112                 (69,444)                ‐7.7%284,769              52.4% Real Estate Excise Tax 1,495,896             ‐                                    ‐                                   (1,495,896)        0.0%‐                                N/A B&O Tax 2,523,430            1,735,327             3,184,776            661,346              26.2% 1,449,449         83.5% YTD Total 18,732,107$      14,272,748$       18,546,454$      (185,653)$          ‐1.0%4,273,706$      29.9% Annual Total 78,953,070$      73,959,450$        Taxes by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through March 2020 2021 2021 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Electrical 1,733,702$     1,293,909$         1,601,436$     (132,266)$       ‐7.6% $      307,527 23.8% Natural Gas 684,617            428,316                 627,487            (57,130)             ‐8.3%          199,171 46.5% Cell 167,277            116,021                 141,864            (25,413)             ‐15.2%             25,843 22.3% Phone 135,817            217,101                 170,663            34,846              25.7%           (46,438)‐21.4% Cable 243,494            227,395                 351,424            107,930           44.3%          124,029 54.5% Garbage 173,885            149,533                 184,485            10,600              6.1%             34,952 23.4% City Utilities 1,199,186        1,208,152            1,212,869        13,683              1.1%                4,717 0.4% YTD Total 4,337,978$     3,640,427$         4,290,228$     (47,750)$         ‐1.1%649,801$      17.9% 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 3 of 41   Gambling Excise Tax – COVID‐19 was expected to heavily influence gambling tax revenues and the City reduced the gambling  tax revenue budget accordingly. However, local gaming establishments were able to take mitigating measures such as setting‐ up outdoor gaming areas to lessen losses from COVID‐19 restrictions. While gambling tax revenues are approximately $70K  less than the 1st quarter of 2020, they are $285K above budget.    Real Estate Excise Tax ‐ REET taxes were improperly recorded to the General Fund in the 1st quarter of 2020. The taxes were  subsequently transferred to the appropriate capital project funds where they are properly budgeted and recorded in  accordance with the requirements of RCW 82.46.    Business and Occupation (B&O) Tax – B&O tax revenues rely heavily on the revenue of a limited number of large businesses.  Payments received in the 1st quarter are generally for activity in the 4th quarter of the prior year. $1.3M of the $1.45M over  the 1st quarter budget 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.     LICENSES & PERMITS        Building Permits – The governor’s stay‐at‐home order forced many commercial and most residential construction projects to  stop for an extended period of time. The stay‐at‐home order has now expired, but permit activity has not returned to pre‐ COVID‐19 levels due to an overall decline in the economy and an increase in the price of building materials due to supply  chain disruptions.     INTERGOVERNMENTAL        State Shared Revenue – The decrease in state shared revenues over prior year is almost entirely due to decreases in criminal  justice – high crime and fuel tax revenues. The City no longer qualifies for criminal justice – high crime shared revenues under  the State’s funding formula and COVID‐19 is still influencing fuel tax revenues. However, higher than expected liquor excise  taxes are resulting in overall State Shared Revenues slightly above budget.      2020 2021 2021 Actual Budget Actual $ % $ % Franchise Fees 389,385                 324,300                 390,734                 1,349                    0.3% 66,434                 20.5% Business Licenses 666,064                 614,763                 696,393                 30,329                 4.6% 81,630                 13.3% Animal Licenses 20,210                    25,568                    19,070                    (1,140)                   ‐5.6% (6,498)                   ‐25.4% Building Permits 701,967                 615,378                 568,740                 (133,228)             ‐19.0% (46,638)                ‐7.6% ROW/Street Excavation Permits 9,200                       9,070                       9,235                       35                           0.4% 165                        1.8% Special Event Permits 305                           167                            85                              (220)                        ‐72.1% (82)                           ‐49.0% YTD Total 1,787,131$         1,589,246$          1,684,256$         (102,875)$          ‐5.8%95,010$              6.0% Annual Total 5,199,555$         4,776,877$           Licenses & Permits by Type Year to Date through March Revenue 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % State Shared Revenue 1,040,151$         888,618$              938,997$              (101,154)$          ‐9.7%50,379$              5.7% Federal Grants ‐                                   978                            62,271                    62,271                 100.0% 61,293                 6267.2% State Grants 100                           11,048                    12,705                    12,605                 12605.0% 1,657                    15.0% Local Grants 25,149                    86,557                    265,331                 240,182              955.0% 178,774              206.5% YTD Total 1,065,400$         987,201$              1,279,304$         213,904$           20.1% 292,103$           29.6% Annual Total 9,387,084$         6,204,385$           Intergovernmental by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through March Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 4 of 41   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 budget is entirely due to payments  received for private security services provided in the 4th quarter of 2020.    Development Services – The increase in development services over the prior year is due to an increase in planning fees  ($153K) and inspection services ($16K). The amount over budget is due to planning fees ($269K) offset by lower than  anticipated inspection services ($85K).     Recreation/Farmer’s Market/Events – The decrease in revenues and amount under budget is related to cancelled programs,  as a result of COVID‐19.    Interfund Services – Interfund services revenues increased from the prior year primarily due to increased reimbursement of  staffing costs from CIP projects ($70K) and increased Public Works Admin overhead charges ($91K). The amount over budget  is primarily due to reimbursement of staffing costs from CIP projects.        2020 2021 2021 Tax by Type YTD Actual YTD Budget YTD Actual$%$% Judicial Contribution 10,768$         5,161$            21,529$         10,761$        99.9% 16,368$        317.1% Crim Just ‐ High Crime 70,168             ‐                            ‐                           (70,168)          ‐100.0%‐                          N/A Crim Just ‐ Pop 7,938               5,998               8,393               455                  5.7% 2,395              39.9% Crim Just ‐ Spec Prog 28,492            27,557            29,961            1,469              5.2% 2,404              8.7% State DUI 3,435               4,382               4,142               707                  20.6%(240)                  ‐5.5% Marijuana Distribution 51,820            50,325            49,840            (1,980)             ‐3.8% (485)                  ‐1.0% Liquor Profits 210,157         212,485         208,438         (1,719)             ‐0.8% (4,047)             ‐1.9% Liquor Excise Tax 138,907         108,248         168,960         30,053           21.6% 60,712           56.1% Fuel Tax 518,466         474,462         447,734         (70,732)          ‐13.6% (26,728)          ‐5.6% YTD Total 1,040,151$  888,618$      938,997$      (101,154)$   ‐9.7%50,379$        5.7% 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % Passport Fees 7,945                       13,001                     ‐                                   (7,945)                  0.0%(13,001)               0.0% Court Services 15,582                    7,328                       (11,883)                  (27,464)                ‐176.3% (19,211)                ‐262.1% General Government Services 412                           1,632                       257                           (156)                        ‐37.7% (1,375)                   ‐84.3% Public Safety Services 326,187                 254,464                 429,397                 103,211              31.6% 174,933              68.7% Development Services 504,309                 488,572                 674,315                 170,006              33.7% 185,743              38.0% Transportation Services 43,079                     ‐                                   6,891                       (36,189)                ‐84.0%6,891                    100.0% Recreation/Farmer's Market/Events 140,373                 197,956                 13,188                    (127,185)             ‐90.6% (184,768)             ‐93.3% Interfund Services 1,095,175            1,139,982             1,269,828            174,653              15.9% 129,846              11.4% YTD Total 2,133,062$         2,102,935$          2,381,993$         248,931$           11.7% 279,058$           13.3% Annual Total 7,514,930$         8,169,266$           Year to Date through March Charges for Services by Type Revenue 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 5 of 41   FINES AND PENALTIES        Photo Enforcement Program – Photo enforcement revenues have decreased from prior year due and are under budget due  to reduced citations and slow payments associated with the COVID‐19 pandemic. Traffic volumes have decreased, and school  zone cameras had been turned off as a result of school closures. The school zone cameras have since been turned back on as  in‐person learning resumed in early March.    MISCELLANEOUS REVENUES        Interest and Other Investment Earnings – Interest earnings have decreased from the prior year due to 1) an overall reduction  in interest rates and 2) a timing difference in the recording of interfund interest. Interest and investment earnings have  historically been budgeted conservatively, so the amount of interest under budget is almost entirely due to the interfund  interest payment not being recorded in the 1st quarter.     OTHER FINANCING SOURCES                     2020 2021 2021 Actual Budget Actual $ % $ % Civil Penalties 111,039$              83,805$                 70,312$                 (40,728)$             ‐36.7% (13,494)$             ‐16.1% Photo Enforcement Program 845,228                 885,261                 558,136                 (287,092)             ‐34.0% (327,124)             ‐37.0% Criminal Traffic Misdemeanor Fines 14,918                    13,327                    13,743                    (1,176)                   ‐7.9%416                        3.1% Criminal Non‐Traffic Fines 7,400                       7,259                       1,933                       (5,467)                   ‐73.9% (5,325)                   ‐73.4% Criminal Costs 19,855                    14,620                    17,129                    (2,726)                   ‐13.7%2,508                    17.2% Non‐Court Fines, Forfeitures and Penalties 33,150                    11,780                    13,350                    (19,800)                ‐59.7%1,570                    13.3% YTD Total 1,031,591$         1,016,052$          674,603$              (356,988)$          ‐34.6% (341,449)$          ‐33.6% Annual Total 3,310,279$         3,829,782$           Fines and Penalties by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through March 2020 2021 2021 Actual Budget Actual $ % $ % Interest and Other Investment Earnings 319,913$              220,480$              86,736$                 (233,177)$          ‐72.9% (133,744)$          ‐60.7% Rents, Leases, and Concessions 331,791                 227,637                 281,978                 (49,813)                ‐15.0%54,341                 23.9% Contributions/Donations from Private Sources 53,018                    17,679                    8,445                       (44,573)                ‐84.1% (9,234)                   ‐52.2% Other 99,124                    96,615                    27,174                    (71,950)                ‐72.6% (69,441)                ‐71.9% YTD Total 803,846$              562,411$              404,333$              (399,513)$          ‐49.7% (158,078)$          ‐28.1% Annual Total 2,136,909$         1,862,675$           Miscellaneous by Type Year to Date through March Revenue 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % Transfers from Other Funds 25,000$                  ‐$                                 ‐$                                (25,000)               0.0%‐                                N/A Insurance Recoveries ‐                                    ‐                                   23,980                    23,980                 100.0% 23,980                 100.0% YTD Total 25,000$                  ‐$                                23,980$                 (1,020)$                ‐4.1%23,980$              100.0% Annual Total 17,475,835$      14,782,012$        Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through March Other Financing Sources by Type Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 6 of 41   GENERAL FUND EXPENDITURES  The following tables summarize expenditures by category for each department within the General Fund. Detailed  explanations have been provided for variances from prior year or YTD budget in excess of $100K.     COUNCIL        EXECUTIVE        EMERGENCY MANAGEMENT        CITY ATTORNEY           Council Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 76,183$                414,180$            98,259$            125,011$          (48,828)$            ‐64.1% (26,752)$          ‐27.2% Supplies 795                           2,000                     903                       ‐                               795                       100.0% 903                     100.0% Contracted Services 17,740                   63,316                  49,674               628                        17,112               96.5% 49,046              98.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 15,536                   67,385                  17,419               16,846                (1,310)                  ‐8.4%573                     3.3% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 110,254$             546,881$            166,255$         142,485$          (32,231)$            ‐29.2%23,770$           14.3% 2021 vs. Budget2021 2021 vs. 2020 Executive Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 228,482$             940,177$            261,183$         168,407$          60,075$            26.3% 92,776$           35.5% Supplies 1,005                      7,100                     3,062                   ‐                               1,005                  100.0% 3,062                 100.0% Contracted Services 336,361                1,445,246           362,943            331,413             4,948                  1.5% 31,530              8.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 116,758                556,244               200,068            139,061             (22,303)               ‐19.1%61,007              30.5% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 682,606$             2,948,767$        827,256$         638,881$          43,725$            6.4% 188,375$        22.8% 2021 vs. Budget2021 2021 vs. 2020 Emergency Management Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 120,185$             485,218$            60,131$            102,915$          17,270$            14.4%(42,784)$          ‐71.2% Supplies 103                           2,775                     2                             ‐                               103                       100.0% 2                           100.0% Contracted Services 98                              41,086                  485                      275                        (177)                      ‐180.6%210                     43.3% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 53,619                   252,536               68,182               63,134                (9,515)                  ‐17.7%5,048                 7.4% Transfers Out 694                            ‐                                  ‐                               ‐                               694                       100.0%‐                             0.0% Total Expenditures 174,699$             781,615$            128,800$         166,324$          8,375$               4.8%(37,524)$          ‐29.1% 2021 vs. Budget2021 2021 vs. 2020 City Attorney Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 552,564$             2,350,586$        616,463$         563,906$          (11,342)$            ‐2.1%52,557$           8.5% Supplies 474                           3,550                     887                       ‐                               474                       100.0% 887                     100.0% Contracted Services 5,917                      49,450                  9,534                  2,902                   3,015                  51.0% 6,632                 69.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 51,361                   207,761               55,212               51,940                (579)                      ‐1.1%3,272                 5.9% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 610,316$             2,611,347$        682,096$         618,748$          (8,432)$               ‐1.4%63,348$           9.3% 2021 2021 vs. Budget2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 7 of 41   COURT SERVICES        COMMUNITY AND ECONOMIC DEVELOPMENT ADMIN        Transfers Out – The increase in transfers out over the prior year is due to a change in the timing of the annual transfer to the  Municipal Arts Fund.      DEVELOPMENT SERVICES        Personnel – The decrease in personnel costs over the prior year and the amount of personnel costs under budget is due to  open positions.       Court Services Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 488,355$             2,389,087$        599,319$         504,144$          (15,789)$            ‐3.2%95,175$           15.9% Supplies 461                           7,700                     1,068                  150                        311                       67.5% 918                     86.0% Contracted Services 32,369                   149,716               44,247               19,712                12,657               39.1% 24,535              55.5% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 119,379                556,427               155,621            139,107             (19,728)               ‐16.5%16,514              10.6% Transfers Out 1,954                       ‐                                  ‐                               ‐                               1,954                  100.0%‐                             0.0% Total Expenditures 642,518$             3,102,930$        800,255$         663,113$          (20,595)$            ‐3.2%137,142$        17.1% 2021 2021 vs. Budget2021 vs. 2020 Community and Econ Dvlpmnt Admin Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 97,493$                400,396$            101,019$         70,574$             26,919$            27.6% 30,445$           30.1% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 165                            ‐                                  ‐                              116                        49                          29.7%(116)                    100.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 279,930                1,100,917           295,424            275,229             4,701                  1.7% 20,195              6.8% Transfers Out 412                           121,030               121,030            121,030             (120,618)            ‐29276.2%‐                             0.0% Total Expenditures 378,000$             1,622,343$        517,473$         466,949$          (88,949)$            ‐23.5%50,524$           9.8% 2021 2021 vs. Budget2021 vs. 2020 Development Services Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 601,287$             2,661,020$        660,162$         540,918$          60,369$            10.0% 119,244$        18.1% Supplies 788                           12,250                  2,069                  337                        451                       57.2% 1,732                 83.7% Contracted Services 24,721                   180,862               51,581               19,185                5,536                  22.4% 32,396              62.8% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 19,702                   55,244                  16,157               13,811                5,891                  29.9% 2,346                 14.5% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 646,498$             2,909,376$        729,969$         574,251$          72,247$            11.2% 155,718$        21.3% 2021 2021 vs. Budget2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 8 of 41   ECONOMIC DEVELOPMENT        Contracted Services ‐ The increase in contracted services over the prior year is primarily due to two affordable housing grants  paid in the 1st quarter of 2021 ($99.6K and $700K), offset by decreases in impact fee waivers in the 1st quarter of 2020 that  did not occur in 2021 ($121K). The affordable housing grants paid out in the 1st quarter of 2021 were approved by Council  and budgeted in 2020. They are included in the 1st quarter/carry forward budget adjustment. The YTD budget is calculated  based on payment trends over the two prior years, so the timing of these payments is resulting in the appearance that the  line item is over budget when it is not.    Capital Outlay – Economic Development capital outlay is associated with the Downtown Streetscape project being funded  through a CDBG grant. The amounts over the prior year are due to timing of project planning/construction costs. As with  other capital projects, the entire amount of the project has been budgeted and the budget balance will be carried forward  each year until the project is complete.    PLANNING        Personnel ‐ The amount of personnel costs under the YTD budget is due to open positions.    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.     Economic Development Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 220,216$             916,639$            220,438$         224,475$          (4,259)$               ‐1.9% (4,037)$             ‐1.8% Supplies 662                           6,120                     320                      565                        97                          14.7%(245)                     ‐76.6% Contracted Services 169,246                1,466,076           154,269            810,051             (640,805)            ‐378.6% (655,782)          ‐425.1% Capital Outlay 52,840                   1,148,748           154,459            694,515             (641,675)            ‐1214.4% (540,056)          ‐349.6% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 442,964$             3,537,583$        529,486$         1,729,606$      (1,286,642)$    ‐290.5% (1,200,120)$   ‐226.7% 2021 2021 vs. Budget2021 vs. 2020 Planning Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 996,328$             4,476,281$        1,164,020$    976,510$          19,818$            2.0% 187,510$        16.1% Supplies 1,315                      13,050                  5,269                  107                        1,208                  91.9% 5,162                 98.0% Contracted Services 25,510                   377,081               62,528               79,803                (54,293)               ‐212.8% (17,275)             ‐27.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 11,068                   87,979                  26,340               21,995                (10,927)               ‐98.7%4,345                 16.5% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,034,221$         4,954,391$        1,258,157$    1,078,415$      (44,194)$            ‐4.3%179,742$        14.3% 2021 2021 vs. Budget2021 vs. 2020 Finance Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 484,357$             2,465,985$        621,860$         521,567$          (37,210)$            ‐7.7%100,293$        16.1% Supplies ‐                                  11,500                  612                      131                        (131)                     100.0% 481                     78.6% Contracted Services 128,739                1,212,698           131,689            209,516             (80,777)               ‐62.7% (77,827)             ‐59.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 106,316                468,761               124,985            117,190             (10,874)               ‐10.2%7,795                 6.2% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 719,412$             4,158,944$        879,146$         848,404$          (128,992)$         ‐17.9%30,742$           3.5% 2021 2021 vs. Budget2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 9 of 41   CITY CLERK        Contracted Services – The decrease in contracted services from the prior year and the amount of contracted services under  the YTD budget is due to the timing of election costs. Election costs are recorded when billed by the County.    HUMAN RESOURCES        POLICE        Personnel – The decrease in personnel costs from the prior year is primarily the result of 1) an open position in Police  administration and 2) a reduction in overtime and related benefits. The amount under the YTD budget is due to open positions  resulting in savings in salaries ($555K) and benefits ($350K), offset by overages in private security overtime ($28K).    Contracted Services – The amount of contracted services under the YTD budget is primarily due to savings in operating rentals  associated with school zone cameras that have been turned off due to COVID‐19. These cameras resumed operation in early  March with the return of in‐person learning in the Renton School District.    Internal Services – The amount of internal services under the YTD budget is due to timing. The YTD budget is based off the  prior two years’ spending patterns. In 2020, there was a significant reduction of internal service fund charges in April due to  cost cutting measures put in place in response to COVID‐19. This is skewing the spending pattern. Internal Services should be  approximately 25% of the annual budget and they are 25.36% at March 31.   City Clerk Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 192,428$             911,188$            235,837$         187,548$          4,880$               2.5% 48,289$           20.5% Supplies 669                           6,994                     2,016                  272                        397                       59.3% 1,744                 86.5% Contracted Services 192,359                342,620               229,632            10,341                182,018            94.6% 219,291           95.5% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 47,782                   213,038               59,118               53,259                (5,477)                  ‐11.5%5,859                 9.9% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 433,238$             1,473,840$        526,603$         251,420$          181,818$         42.0% 275,183$        52.3% 2021 2021 vs. Budget2021 vs. 2020 Human Resources Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 282,490$             1,141,385$        284,551$         275,229$          7,261$               2.6% 9,322$              3.3% Supplies 610                           21,828                  2,959                  2,025                   (1,415)                  ‐232.0%934                     31.6% Contracted Services 13,359                   207,663               28,005               2,806                   10,553               79.0% 25,199              90.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 70,388                   285,956               77,662               71,489                (1,101)                  ‐1.6%6,173                 7.9% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 366,847$             1,656,832$        393,177$         351,549$          15,298$            4.2% 41,628$           10.6% 2021 2021 vs. Budget2021 vs. 2020 Police Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 6,611,312$         26,767,472$     7,152,907$    6,268,397$      342,915$         5.2% 884,510$        12.4% Supplies 110,688                547,484               161,775            73,115                37,573               33.9% 88,660              54.8% Contracted Services 1,209,270            4,948,347           1,302,789       1,164,766         44,504               3.7% 138,023           10.6% Capital Outlay ‐                                  41,154                   ‐                              7,350                   (7,350)                 100.0%(7,350)               100.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 1,492,793            6,012,809           1,716,252       1,524,749         (31,956)               ‐2.1%191,503           11.2% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 9,424,063$         38,317,266$     10,333,723$ 9,038,377$      385,686$         4.1% 1,295,346$   12.5% 2021 2021 vs. Budget2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 10 of 41   JAIL SERVICES        COMMUNITY SERVICES ADMIN        LEASED PROPERTIES        PARKS AND TRAILS        Personnel – The amount of personnel costs under the YTD budget is due to vacant positions.        Jail Services Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel ‐$                                ‐$                               ‐$                            ‐$                             ‐$                           0.0%‐$                          0.0% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 1,177,184            4,707,758           1,176,988       1,176,939         245                       0.0% 49                        0.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,177,184$         4,707,758$        1,176,988$    1,176,939$      245$                    0.0% 49$                     0.0% 2021 2021 vs. Budget2021 vs. 2020 Community Services Admin Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 91,682$                378,206$            95,458$            93,465$             (1,783)$               ‐1.9%1,993$              2.1% Supplies 772                           7,200                     1,642                  25                           747                       96.8% 1,617                 98.5% Contracted Services 11,672                   35,544                  19,021               3,854                   7,818                  67.0% 15,167              79.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 38,737                   171,107               48,579               42,777                (4,040)                  ‐10.4%5,802                 11.9% Transfers Out 616                            ‐                                  ‐                              468                        148                       24.0%(468)                    100.0% Total Expenditures 143,479$             592,057$            164,700$         140,589$          2,890$               2.0% 24,111$           14.6% 2021 vs. Budget2021 vs. 20202021 Leased Properties Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 46,234                   185,794               45,209               43,648                2,586$               5.6% 1,561$              3.5% Supplies 65                              2,440                     52                         6,712                   (6,647)                  ‐10226.2% (6,660)                ‐12807.7% Contracted Services 119,518                658,465               157,540            134,221             (14,703)               ‐12.3%23,319              14.8% Capital Outlay ‐                             ‐                            ‐                         ‐                          ‐                              0.0%‐                             0.0% Debt Service ‐                             ‐                            ‐                         ‐                          ‐                              0.0%‐                             0.0% Internal Services 712                           3,177                     797                      794                        (82)                         ‐11.5%3                           0.4% Transfers Out ‐                             ‐                            ‐                         ‐                          ‐                              0.0%‐                             0.0% Total Expenditures 166,529$             849,876$            203,598$         185,375$          (18,846)$            ‐11.3%18,223$           9.0% 2021 2021 vs. 2020 2021 vs. Budget Parks & Trails Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 708,915$             4,059,603$        973,998$         714,096$          (5,181)$               ‐0.7%259,902$        26.7% Supplies 42,607                   248,859               52,023               40,792                1,815                  4.3% 11,231              21.6% Contracted Services 65,565                   745,862               91,218               132,820             (67,255)               ‐102.6% (41,602)             ‐45.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 379,671                1,742,495           488,431            438,899             (59,228)               ‐15.6%49,532              10.1% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,196,758$         6,796,819$        1,605,670$    1,326,607$      (129,849)$         ‐10.9%279,063$        17.4% 2021 2021 vs. Budget2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 11 of 41   PARKS PLANNING AND NATURAL RESOURCES        RECREATION AND NEIGHBORHOODS        Personnel – The decrease in personnel costs from the prior year is the result of recreation facility closures related to COVID‐ 19. The amount of personnel costs under budget is due to open positions.     HUMAN SERVICES        MUSEUM           Parks Planning & Natural Resources Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 220,022$             1,007,634$        230,553$         229,359$          (9,337)$               ‐4.2%1,194$              0.5% Supplies 64                              4,827                     127                      433                        (369)                      ‐576.6% (306)                     ‐240.9% Contracted Services 119,611                960,463               75,898               34,445                85,166               71.2% 41,453              54.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 12,369                   76,437                  20,025               19,109                (6,740)                  ‐54.5%916                     4.6% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 352,066$             2,049,361$        326,603$         283,346$          68,720$            19.5% 43,257$           13.2% 2021 2021 vs. Budget2021 vs. 2020 Recreation & Neighborhoods Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 774,195$             3,844,106$        968,635$         481,759$          292,436$         37.8% 486,876$        50.3% Supplies 36,690                   307,249               67,833               15,441                21,249               57.9% 52,392              77.2% Contracted Services 49,873                   404,336               50,349               24,902                24,971               50.1% 25,447              50.5% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 475,088                2,013,208           588,357            503,302             (28,214)               ‐5.9%85,055              14.5% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,335,846$         6,568,899$        1,675,174$    1,025,404$      310,442$         23.2% 649,770$        38.8% 2021 2021 vs. Budget2021 vs. 2020 Human Services Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 154,318$             646,138$            159,769$         157,749$          (3,431)$               ‐2.2%2,020$              1.3% Supplies 1,981                      15,650                  2,816                  1,597                   384                       19.4% 1,219                 43.3% Contracted Services 102,099                784,439               95,478               47,970                54,129               53.0% 47,508              49.8% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 29,732                   121,913               37,221               30,478                (746)                      ‐2.5%6,743                 18.1% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 288,130$             1,568,140$        295,284$         237,794$          50,336$            17.5% 57,490$           19.5% 2021 vs. Budget2021 vs. 20202021 Museum Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 36,779$                150,777$            39,730$            32,333$             4,446$               12.1% 7,397$              18.6% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 29,756                   138,924               41,028               34,731                (4,975)                  ‐16.7%6,297                 15.3% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 66,535$                289,701$            80,758$            67,064$             (529)$                   ‐0.8%13,694$           17.0% 2021 vs. Budget2021 vs. 20202021 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 12 of 41   PUBLIC WORKS ADMIN        STREET MAINTENANCE        Personnel – The amount of personnel costs under the YTD budget is due to open positions.    Internal Services – The increase in internal service charges over the prior year is due to increased Fleet charges, the result of  adding three large pieces of equipment to the Street Maintenance Fleet inventory in 2019. Fleet charges consist of two  elements 1) quarterly maintenance and operations charges and 2) replacement reserves.     TRANSPORTATION              Public Works Admin Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 80,358$                377,829$            97,442$            93,394$             (13,036)$            ‐16.2%4,048$              4.2% Supplies 249                           800                          67                         98                           151                       60.6%(31)                        ‐46.3% Contracted Services ‐                                  1,650                      ‐                               ‐                                ‐                              0.0%‐                             0.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 27,392                   117,712               38,510               29,428                (2,036)                  ‐7.4%9,082                 23.6% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 107,999$             497,991$            136,019$         122,920$          (14,921)$            ‐13.8%13,099$           9.6% 2021 vs. Budget2021 2021 vs. 2020 Street Maintenance Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 726,067$             3,235,633$        815,849$         669,802$          56,265$            7.7% 146,047$        17.9% Supplies 35,288                   319,798               54,849               42,571                (7,283)                  ‐20.6%12,278              22.4% Contracted Services 247,594                1,128,154           259,818            264,785             (17,191)               ‐6.9% (4,967)                ‐1.9% Capital Outlay ‐                                  5,200                      ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 387,038                1,891,569           581,999            512,555             (125,517)            ‐32.4%69,444              11.9% Transfers Out 4,811                       ‐                                  ‐                               ‐                               4,811                  100.0%‐                             0.0% Total Expenditures 1,400,798$         6,580,354$        1,712,515$    1,489,713$      (88,915)$            ‐6.3%222,802$        13.0% 2021 vs. 20202021 2021 vs. Budget Transportation Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,097,092$         4,552,850$        1,114,638$    1,099,503$      (2,411)$               ‐0.2%15,135$           1.4% Supplies 28,113                   230,702               42,161               41,628                (13,515)               ‐48.1%533                     1.3% Contracted Services 116,820                1,019,483           233,703            191,062             (74,242)               ‐63.6%42,641              18.2% Capital Outlay 13,818                    ‐                                  ‐                               ‐                               13,818               100.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 197,258                835,429               233,169            208,908             (11,650)               ‐5.9%24,261              10.4% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,453,101$         6,638,464$        1,623,671$    1,541,101$      (88,000)$            ‐6.1%82,570$           5.1% 2021 vs. Budget2021 vs. 20202021 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 13 of 41   NON‐DEPARTMENTAL AND OTHER        Personnel ‐ The amount of personnel expenditures under the YTD budget is due to savings from 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.      Non‐Departmental and Other Summary of Uses 2020 Year to Date through March YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 721,999$             3,407,200$        1,001,891$    698,457$          23,542$            3.3% 303,434$        30.3% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 89,520                   2,218,661           1,201,706       93,374                (3,854)                  ‐4.3%1,108,332      92.2% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 4,707                      14,055                  3,514                  3,514                   1,193                  25.3%‐                             0.0% Transfers Out ‐                                  19,633,988         ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 816,226$             25,273,904$     2,207,111$    795,345$          20,881$            2.6% 1,411,766$   64.0% 2021 vs. Budget2021 2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 14 of 41   DEBT SERVICE FUNDS  Debt service funds are used to account for the accumulation of resources for the payment of principal and interest related to  the City’s general obligation bond issues. YTD budgets are not prepared for debt service funds.     GENERAL GOVERNMENTAL MISCELLANEOUS DEBT FUND  The General Governmental Miscellaneous Debt Fund is the only debt service fund maintained by the City.        Charges for services – The decrease in charges for services 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 1st quarter 2021 is the final payment scheduled to be  received from Fire District 40 related to the debt service on the loan.   2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 28,678$                50,983$                  25,546$         (3,132)$         (25,437)$         50.11% Charges for services 193,414                63,648                    63,648           (129,766)       ‐                        100.00% Investment Earnings 14,937                    ‐                                7,526              (7,411)           7,526               N/A TOTAL REVENUES 237,029                114,631                  96,720           (140,309)      (17,911)           84.38% EXPENDITURES: Principal 181,622                5,625,158               188,804         (7,182)           5,436,354       3.36% Interest 99,849                   1,527,861               61,513           38,336          1,466,348       4.03% TOTAL EXPENDITURES 281,471                7,153,019               250,317         31,154          6,902,702       3.50% Transfers In ‐                              7,378,667                ‐                        ‐                     (7,378,667)     0.00% NET TRANSFERS ‐                              7,378,667                ‐                        ‐                     (7,378,667)     0.00% CHANGE IN FUND BALANCE (44,442)                 340,279                  (153,597)        (109,155)      (493,876)          ‐45.14% BEGINNING FUND BALANCE, Jan 1 3,999,457             5,010,629               5,010,629      1,011,172     ‐                        100.00% ENDING FUND BALANCE, Mar 31 3,955,015$           5,350,908$            4,857,032$   902,017$     (493,876)$      90.77% Debt Service Reserve 2,717,575             2,717,575               2,717,575       AVAILABLE FUND BALANCE 1,237,440$           2,633,333$            2,139,457$    VARIANCE FAVORABLE (UNFAVORABLE) GENERAL GOVERNMENTAL MISCELLANEOUS DEBT Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 15 of 41   SPECIAL REVENUE FUNDS  Special revenue funds are used to account for revenues that are to be used for a specific purpose as required by law or  legislative action. YTD budgets are not prepared for special revenue funds.     Hotel/Motel Fund  The Hotel/Motel Fund accounts for monies collected through an increase of 1% in hotel/motel taxes for the purpose of  increasing tourism in the City or Renton, as authorized under RCW 67.28.180. The Lodging Tax Advisory Committee solicits  applications for awards and brings their recommendations to Council for approval at least once per year. Awards for events  are paid to applicants at the conclusion of the event once certain reporting requirements have been met.       Municipal Art Fund  The Municipal Art Fund was established to account for the activities of the Renton Municipal Arts Commission, as outlined in  Renton Municipal Code (RMC) section 2‐8‐7. Expenditures include grants paid to local artists, organizations, and community  groups for arts and culture projects and events that serve the general public in Renton and payments for Public Art capital  projects located throughout the City.         Transfers In – The increase in transfers in from the prior year is due to the timing of the annual transfer. In 2020, the transfer  was not recorded until 2nd quarter.  2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 93,982$                200,000$                42,565$                (51,417)$               (157,435)$             21.28% Contributions ‐                              25,000                      ‐                               ‐                              (25,000)                 0.00% Investment Earnings 3,294                      ‐                                1,210                     (2,084)                    1,210                     N/A TOTAL REVENUES 97,276                   225,000                   43,775                   (53,501)                 (181,225)               19.46% EXPENDITURES: Contracted Services 44,496                   501,197                   56,505                   (12,009)                 444,692                11.27% TOTAL EXPENDITURES 44,496                   501,197                   56,505                   (12,009)                 444,692                11.27% NET TRANSFERS ‐                               ‐                                 ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 52,780                   (276,197)                 (12,730)                 (65,510)                 263,467                4.61% BEGINNING FUND BALANCE, Jan 1 943,889                893,604                   893,604                (50,285)                  ‐                              94.67% ENDING FUND BALANCE, Mar 31 996,669$              617,407$                880,874$              (115,795)$             263,467$              88.38% VARIANCE FAVORABLE (UNFAVORABLE) HOTEL/MOTEL 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 321$                       ‐$                              94$                        (227)$                     94$                        N/A TOTAL REVENUES 321                         ‐                                94                           (227)                       94                           N/A EXPENDITURES: Supplies 200                        200                          32                           168                        168                        16.00% Contracted Services 4,800                     103,200                  22,293                   (17,493)                 80,907                   21.60% Capital Outlay ‐                              15,000                      ‐                               ‐                              15,000                   0.00% TOTAL EXPENDITURES 5,000                     118,400                  22,325                   (17,325)                 96,075                   18.86% Transfers In ‐                              117,900                  117,900                117,900                 ‐                              100.00% NET TRANSFERS ‐                              117,900                  117,900                117,900                 ‐                              100.00% CHANGE IN FUND BALANCE (4,679)                    (500)                         95,669                   100,348                96,169                    ‐19133.80% BEGINNING FUND BALANCE, Jan 1 98,865                   65,000                     65,000                   (33,865)                  ‐                              100.00% ENDING FUND BALANCE, Mar 31 94,186$                64,500$                  160,669$              66,483$                96,169$                249.10% MUNICIPAL ART VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 16 of 41   Cable Communications Fund  The Cable Communications Fund accounts for funding for promotion and development of cable communications as  established by City ordinance. The main use of the fund is to support the broadcasting of City Council meetings on Channel  21.        Springbrook Wetlands Fund  The Springbrook Wetlands Fund was established in 2007 for the purpose of providing accounting for the Springbrook Creek  Wetland and Habitat Mitigation Bank project. The fund will receive revenue by selling Wetlands credits 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: Licenses and permits 20,749$                57,674$                    18,901$                (1,848)$                 (38,773)$               32.77% Investment Earnings 2,063                      ‐                                  908                        (1,155)                    908                        N/A TOTAL REVENUES 22,812                   57,674                      19,809                   (3,003)                    (37,865)                 34.35% EXPENDITURES: Supplies ‐                              6,302                          ‐                               ‐                              6,302                     0.00% Contracted Services 9,360                     51,372                      3,820                     (5,540)                    47,552                   7.44% Capital Outlay ‐                              40,000                       ‐                               ‐                              40,000                   0.00% TOTAL EXPENDITURES 9,360                     97,674                      3,820                     (5,540)                    93,854                   3.91% Transfers In ‐                              40,000                       ‐                               ‐                               ‐                              0.00% NET TRANSFERS ‐                              40,000                       ‐                               ‐                               ‐                              0.00% CHANGE IN FUND BALANCE 13,452                    ‐                                  15,989                   2,537                     15,989                   N/A BEGINNING FUND BALANCE, Jan 1 603,760                677,710                    677,710                73,950                    ‐                              100.00% ENDING FUND BALANCE, Mar 31 617,212$              677,710$                  693,699$              76,487$                15,989$                102.36% CABLE COMMUNICATIONS 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$                24,200$                 ‐$                            100.00% Investment Earnings 1,158                      ‐                                 471                        (687)                       471                        N/A TOTAL REVENUES 1,158                     24,200                      24,671                   23,513                   471                        101.95% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                                  ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 1,158                     24,200                      24,671                   23,513                   471                        101.95% BEGINNING FUND BALANCE, Jan 1 345,658                348,826                   348,826                3,168                      ‐                              100.00% ENDING FUND BALANCE, Mar 31 346,816$              373,026$                 373,497$              26,681$                471$                      100.13% SPRINGBROOK WETLANDS VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 17 of 41   Police Seizure Fund  The Police Seizure Fund was established in the 2nd quarter of 2020 for the purpose of providing transparency in the accounting  for assets seized by Police in accordance with RCW 9A.83.030 and 69.50.505, previously accounted for within the General  Fund. These seizure funds are restricted to use exclusively for the expansion and improvement of controlled substances  related law enforcement activity.        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,118$                   8,118$                   8,118$                   N/A Investment Earnings ‐                               ‐                                 1,098                     1,098                     1,098                     N/A TOTAL REVENUES ‐                               ‐                                 9,216                     9,216                     9,216                     N/A EXPENDITURES: Supplies ‐                              872,449                   20,379                   20,379                   852,070                2.34% Contracted Services ‐                               ‐                                 13,625                   13,625                   (13,625)                 N/A Capital Outlay ‐                               ‐                                 31,504                   31,504                   (31,504)                 N/A TOTAL EXPENDITURES ‐                              872,449                   65,508                   65,508                   806,941                7.51% NET TRANSFERS ‐                               ‐                                  ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE ‐                              (872,449)                  (56,292)                 (56,292)                 816,157                N/A BEGINNING FUND BALANCE, Jan 1 ‐                              872,449                   872,449                872,449                 ‐                              100.00% ENDING FUND BALANCE, Mar 31 ‐$                             ‐$                               816,157$              816,157$              816,157$              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 ‐$                             ‐$                               9,949$                   9,949$                   9,949$                   N/A Investment Earnings ‐                               ‐                                 204                        204                        204                        N/A TOTAL REVENUES ‐                               ‐                                 10,153                   10,153                   10,153                   N/A EXPENDITURES: Contracted Services ‐                              150,637                    ‐                               ‐                              (150,637)               0.00% TOTAL EXPENDITURES ‐                              150,637                    ‐                               ‐                              150,637                0.00% NET TRANSFERS ‐                               ‐                                  ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE ‐                              (150,637)                  10,153                   10,153                   160,790                N/A BEGINNING FUND BALANCE, Jan 1 ‐                              150,637                   150,637                150,637                 ‐                              100.00% ENDING FUND BALANCE, Mar 31 ‐$                             ‐$                               160,790$              160,790$              160,790$              N/A POLICE CSAM SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 18 of 41   CAPITAL PROJECT FUNDS  Capital project funds are used to account for the acquisition and construction of major capital facilities and equipment. YTD  budgets are not prepared for capital project funds. Project budgets are adopted when funding is secured, and balances are  carried forward each year until they are either 1) fully spent or 2) reallocated to another project through the budget  adjustment process.    Community Services Impact Mitigation Fund  This fund accounts for park impact fees collected from developers as authorized under RCW 82.02.050‐.110. These fees are  used to help offset the cost of system improvements necessary to service the new development. Impact fees are held in this  fund and subsequently transferred to the Municipal Facilities CIP Fund when qualifying capital projects are budgeted.        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.         2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 245,993$              86,500$                  70,924$                (175,069)$             (15,576)$               81.99% Investment Earnings 7,004                      ‐                                2,624                     (4,380)                    2,624                     N/A TOTAL REVENUES 252,997                86,500                     73,548                   (179,449)               (12,952)                 85.03% TOTAL EXPENDITURES ‐                               ‐                                 ‐                               ‐                               ‐                              N/A Transfers In ‐                              1,179,783                ‐                               ‐                               ‐                              0.00% Transfers Out ‐                              1,830,328                ‐                               ‐                              1,830,328             0.00% NET TRANSFERS ‐                              (650,545)                  ‐                               ‐                              650,545                0.00% CHANGE IN FUND BALANCE 252,997                (564,045)                 73,548                   (179,449)               637,593                 ‐13.04% BEGINNING FUND BALANCE, Jan 1 1,886,999             1,713,833               1,713,833             (173,166)                ‐                              100.00% ENDING FUND BALANCE, Mar 31 2,139,996$           1,149,788$             1,787,381$           (352,615)$             637,593$              155.45% 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 529,142$              200,000$                 177,329$              (351,813)$             (22,671)$               88.66% Investment Earnings 11,261                    ‐                                 4,764                     (6,497)                    4,764                     N/A TOTAL REVENUES 540,403                200,000                    182,093                (358,310)               (17,907)                 91.05% TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A Transfers Out ‐                              172,869                     ‐                               ‐                              172,869                0.00% NET TRANSFERS ‐                              (172,869)                   ‐                               ‐                              172,869                0.00% CHANGE IN FUND BALANCE 540,403                27,131                      182,093                (358,310)               154,962                N/A BEGINNING FUND BALANCE, Jan 1 2,942,344             3,154,954                3,154,954             212,610                 ‐                              100.00% ENDING FUND BALANCE, Mar 31 3,482,747$           3,182,085$              3,337,047$           (145,700)$             154,962$              104.87% TRANSPORTATION IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 19 of 41   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.        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,250,000$              777,111$              777,111$              (1,472,889)$         34.54% Investment Earnings ‐                               ‐                                 3,496                     3,496                     3,496                     N/A TOTAL REVENUES ‐                              2,250,000                780,607                780,607                (1,469,393)            34.69% TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A Transfers Out ‐                              2,865,000                 ‐                               ‐                              2,865,000             0.00% NET TRANSFERS ‐                              (2,865,000)                ‐                               ‐                              2,865,000             0.00% CHANGE IN FUND BALANCE ‐                              (615,000)                  780,607                780,607                1,395,607              ‐126.93% BEGINNING FUND BALANCE, Jan 1 ‐                              2,042,269                2,042,269             2,042,269              ‐                              100.00% ENDING FUND BALANCE, Mar 31 ‐$                            1,427,269$              2,822,876$           2,822,876$           1,395,607$           197.78% REET 1 VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes ‐$                            2,250,000$              777,111$              777,111$              (1,472,889)$         34.54% Investment Earnings ‐                               ‐                                 4,933                     4,933                     4,933                     N/A TOTAL REVENUES ‐                              2,250,000                782,044                782,044                (1,467,956)            34.76% TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A Transfers In ‐                              3,177,680                 ‐                               ‐                              (3,177,680)            0.00% Transfers Out ‐                              7,066,705                 ‐                               ‐                              7,066,705             0.00% NET TRANSFERS ‐                              (3,889,025)                ‐                               ‐                              3,889,025             0.00% CHANGE IN FUND BALANCE ‐                              (1,639,025)               782,044                782,044                2,421,069              ‐47.71% BEGINNING FUND BALANCE, Jan 1 ‐                              3,411,866                3,411,866             3,411,866              ‐                              100.00% ENDING FUND BALANCE, Mar 31 ‐$                            1,772,841$              4,193,910$           4,193,910$           2,421,069$           236.56% REET 2 VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 20 of 41   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 March 31 is provided on the following page. The budget for personnel costs is  included in the listing for ease of comparison to total expenditures shown in the table above, but personnel costs are not  considered projects and, therefore, any remaining budget would not be carried forward at the end of the year.        2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 398,612$              997,025$               657,353$              258,741$              (339,672)$             65.93% Charges for services 140                         ‐                               133,730                133,590                133,730                N/A Sale of general fixed assets 160,000                 ‐                               80,000                   (80,000)                 80,000                   N/A Investment Earnings 101,531                86,185                    30,200                   (71,331)                 (55,985)                 35.04% TOTAL REVENUES 660,283                1,094,210              901,283                241,000                (192,927)               82.37% EXPENDITURES: Personnel 159,999                731,324                 138,405                (21,593)                 592,919                18.93% Contracted Services 4,604                     123,348                 18,420                   13,816                   104,928                14.93% Capital Outlay 1,217,740             23,006,189            335,909                (881,831)               22,670,280           1.46% TOTAL EXPENDITURES 1,382,343             23,867,946            492,734                (889,608)               23,375,212           2.06% Transfers In ‐                              7,649,008               ‐                               ‐                              (7,649,008)            0.00% Transfers Out ‐                              4,357,463               ‐                               ‐                              4,357,463             0.00% NET TRANSFERS ‐                              3,291,545               ‐                               ‐                              (12,006,471)         0.00% CHANGE IN FUND BALANCE (722,060)               (19,482,191)          408,549                1,130,609             19,890,740            ‐2.10% BEGINNING FUND BALANCE, Jan 1 26,395,567           20,298,663            20,298,663           (6,096,904)             ‐                              100.00% ENDING FUND BALANCE, Mar 31 25,673,507$        816,472$               20,707,212$        (4,966,295)$         19,890,740$        2536.18% MUNICIPAL FACILITIES CIP VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 21 of 41   Municipal Facilities CIP Fund (continued)             PROJECT BUDGET ACTUAL BALANCE CAPITAL PROJECT COORDINATORS 731,324$ 138,405$ 592,919$ SUNSET NEIGHBORHOOD PARK ART 86,856 10,200 76,656 CITY HALL ELEVATORS 1,465,583 42,546 1,423,037 CITY WIDE SECURITY SYSTEM UPGRADES 353,913 4,952 348,961 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 187,216 2,442,072 RCC AUDIO AND VIDEO SYSTEMS 56,000 - 56,000 PUBLIC WORKS SHOPS - GENERATOR REPL 144,000 - 144,000 BOATHOUSE 14,763 7,352 7,411 HENRY MOSES AQUATIC CENTER 88,644 - 88,644 SPORT COURT IMPROVEMENTS 215,000 - 215,000 PARKING LOT AND DRIVEWAY REPAIRS 90,000 - 90,000 IRRIGATION AUTOMATION & CONSERVATION 7,085 - 7,085 URBAN FORESTRY PROGRAM 103,348 11,383 91,965 PARKS MM - PLAYGRDS, KIOSKS & INT SIGNS 325,000 - 325,000 PARKS MM - SHORELINE AND BANK STABILIZAT 182,350 - 182,350 PARKS MM - STRUCTURAL REVIEWS & REPAIRS 14,913 11,914 2,999 SUNSET EIS PARK 149,010 - 149,010 COULON PARK STRUCTURAL IMPROVEMENTS 150 150 - COULON PARK TURF REPLACEMENT 50,788 - 50,788 COULON SWIM BEACH 250,000 - 250,000 LIBERTY PARK IMPROVEMENTS 525,852 - 525,852 TRANSPORTATION LANDSCAPE 90,000 - 90,000 PHILIP ARNOLD PARK IMPROVEMENTS 5,951,133 19,592 5,931,541 KIWANIS PARK 6,062,100 15,621 6,046,479 COULON - WATERWALK 2,538,220 31,072 2,507,148 COULON - TRESTLE BRIDGE 1,429,856 12,331 1,417,525 COULON - ROSEWALL REPAIRS & MAINTENANCE 10,000 - 10,000 TOTAL PROJECT BALANCES 23,867,946$ 492,734$ 23,375,212$ MUNICIPAL FACILITIES CIP PROJECT BUDGETS AT MARCH 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 22 of 41   Capital Improvement Fund  This fund accounts for the City’s Transportation capital projects.        A listing of project budgets and balances at March 31 is provided on the following page.      2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 468,834$              27,558,159$        3,181,248$           2,712,414$           (24,376,911)$       11.54% Charges for services 250,000                 ‐                               ‐                              (250,000)                ‐                              N/A Fines and penalties 5,746                      ‐                              12,837                   7,091                     12,837                   N/A Investment Earnings 62,228                    ‐                              22,911                   (39,317)                 22,911                   N/A TOTAL REVENUES 786,808                27,558,159           3,216,996             2,430,188             (24,341,163)         11.67% EXPENDITURES: Personnel 25,426                   56,000                   13,933                   (11,493)                 42,067                   24.88% Supplies ‐                              40,000                    ‐                               ‐                              40,000                   0.00% Contracted Services 4,475                     28,683                   13,931                   9,456                     14,752                   48.57% Capital Outlay 611,111                44,535,040           1,638,724             1,027,613             42,896,316           3.68% TOTAL EXPENDITURES 641,012                44,659,723           1,666,588             1,025,576             42,993,135           3.73% Transfers In ‐                              2,172,869              ‐                               ‐                              (2,172,869)            0.00% NET TRANSFERS ‐                              2,172,869              ‐                               ‐                              (2,172,869)            0.00% CHANGE IN FUND BALANCE 145,796                (14,928,695)         1,550,408             1,404,612             16,479,103           N/A BEGINNING FUND BALANCE, Jan 1 18,947,853           16,792,413           16,792,413           (2,155,440)             ‐                              100.00% ENDING FUND BALANCE, Mar 31 19,093,649$        1,863,718$           18,342,821$        (750,828)$             16,479,103$        984.21% CAPITAL IMPROVEMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 23 of 41   Capital Improvement Fund (continued)         PROJECT BUDGET ACTUAL BALANCE WALKWAY PGM 267,096$ -$ 267,096$ NE 31ST ST CULVERT 12,228 12,090 138 ARTERIAL CIRCULATION PGM 79,564 12,202 67,362 BRIDGE INSPECTION & REPAIR 245,909 8,246 237,663 ROADWAY SAFETY & GUARDRAIL 89,407 - 89,407 CATCH BASIN REPAIR 250,000 - 250,000 RENTON CONNECTOR 1,747,812 606 1,747,206 STREET OVERLAY PGM 1,465,902 9,507 1,456,395 TRAFFIC SAFETY PGM 117,808 - 117,808 PROJ DEV & PRE-DESIGN 111,733 - 111,733 SO 7TH ST 135,000 - 135,000 ITS PGM 86,128 - 86,128 RENTON AVE EXT PRES 40,920 15,409 25,511 PARK AVE EXTENSION 7,394,795 28,651 7,366,144 RAINIER AVE S/N PHASE 4 4,568,763 32,774 4,535,989 INTERSECT SAFETY & MOBILITY 335,610 - 335,610 NE 31ST ST BRIDGE REPLACEMENT 248,046 15,369 232,677 N 27TH PL CULVERT SCOUR REPAIR 66,622 20,112 46,510 DUVALL AVE 7TH TO SUNSET 6,499,523 1,186 6,498,337 BARRIER FREE 113,883 - 113,883 SIDEWALK REHAB 100,000 - 100,000 LAKE WASHINGTON LOOP TRAIL 2,569,361 50,221 2,519,140 HIGHLANDS TO LANDING 422,490 95,966 326,524 SUNSET BLVD CORRIDOR 4,421,053 24,402 4,396,651 PRES OF TOD 173,496 - 173,496 WILLIAMS AVE S & WELLS AVE S CONV 6,495,074 1,268,641 5,226,433 ARTERIAL REHAB - SW 43RD 1,169,960 - 1,169,960 BRONSON BRIDGE 463,766 13,587 450,179 HOUSER WAY N BRIDGE 531,247 1,792 529,455 WILLIAMS BRIDGE 649,992 1,793 648,199 S 2ND STREET CONVERSION 1,545,494 268 1,545,226 HOUSER WAY INT & PED IMP 730,465 4,640 725,825 RENTON SCHOOL CROSSINGS 688,384 1,196 687,188 SAFE ROUTES TO TRANSIT 763,592 47,930 715,662 I-405 RENTON TO BELLEVUE-TRANS 58,600 - 58,600 TOTAL PROJECT BALANCES 44,659,723$ 1,666,588$ 42,993,135$ CAPITAL IMPROVEMENT PROJECT BUDGETS AT MARCH 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 24 of 41   New Library Development Fund  This fund was used to account for the construction of the new Highlands Library and the renovation of the Cedar River Library.  The fund is no longer needed as the library construction projects were complete in 2016. Closure of the fund and a transfer  of the remaining fund balance is included in the 1st quarter 2021 budget adjustment.         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 235$                       ‐$                             ‐$                            (235)$                      ‐$                            N/A TOTAL REVENUES 235                         ‐                               ‐                              (235)                        ‐                              N/A TOTAL EXPENDITURES ‐                               ‐                               ‐                               ‐                               ‐                              N/A Transfers Out ‐                              16,679                    ‐                               ‐                              16,679                   0.00% NET TRANSFERS ‐                              (16,679)                  ‐                               ‐                              16,679                   N/A CHANGE IN FUND BALANCE 235                        (16,679)                  ‐                              (235)                       16,679                   N/A BEGINNING FUND BALANCE, Jan 1 16,408                   16,679                   16,679                   271                         ‐                              100.00% ENDING FUND BALANCE, Mar 31 16,643$                 ‐$                            16,679$                36$                        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 28,052                    ‐                              11,132                   (16,920)                 11,132                   N/A TOTAL REVENUES 28,052                   75,000                   11,132                   (16,920)                 (63,868)                 14.84% EXPENDITURES: Capital Outlay 163,516                872,775                25,513                   (138,003)               847,262                2.92% TOTAL EXPENDITURES 163,516                872,775                25,513                   (138,003)               847,262                2.92% NET TRANSFERS ‐                               ‐                               ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE (135,464)               (797,775)               (14,381)                 121,083                783,394                N/A BEGINNING FUND BALANCE, Jan 1 8,551,401             8,356,704             8,356,704             (194,697)                ‐                              100.00% ENDING FUND BALANCE, Mar 31 8,415,937$           7,558,929$           8,342,323$           (73,614)$               783,394$              110.36% FAMILY FIRST CENTER VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 25 of 41   ENTERPRISE FUNDS  Enterprise funds are used to account for operations that are financed and operated in a manner similar to private business  enterprises. YTD budgets are not prepared for Enterprise Funds.     Most Enterprise Funds maintain two separate “management funds”, an operating fund and a capital fund. The funds are  consolidated for budget/reporting purposes. Operating budgets lapse at the end of the year. Project budgets are adopted  when funding is secured, and balances are carried forward each year until they are either 1) fully spent or 2) reallocated to  another project through the budget adjustment process. A listing of project balances for each Enterprise Fund is included,  along with a reconciliation to the amounts reported as “Capital Outlay”.     Airport Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Renton Municipal Airport.         Capital Outlay ‐ A listing of project budgets and balances at March 31 is provided on the following page.   2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 29,852$           145,557$                15,709$           (14,143)$          (129,848)$        10.79% Rents, leases, and misc fees 768,019           2,902,353               811,952           43,933              (2,090,401)       27.98% Interest and other misc 21,467              3,857                       10,288              (11,179)            6,431                266.74% TOTAL REVENUES 819,338           3,051,767               837,949           18,611              (2,213,818)       27.46% EXPENSES: Personnel 272,259           1,298,337               257,617           14,642              1,040,720        19.84% Supplies 2,737                35,630                    5,774                (3,037)               29,856              16.21% Contracted Services 95,942              990,150                  79,516              16,426              910,634           8.03% Internal Services 85,681              393,723                  100,067           (14,386)            293,656           25.42% TOTAL OPERATING EXPENSES 456,619           2,717,840               442,974           13,645              2,274,866        16.30% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 362,719           333,927                  394,975           32,256              61,048              118.28% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 132,819           6,047,008               52,569              80,250              5,994,439        0.87% TRANSFERS OUT 1,363                 ‐                                 ‐                         1,363                 ‐                         N/A NET TRANSFERS (1,363)                ‐                                 ‐                         1,363                 ‐                         N/A CHANGE IN FUND BALANCE 228,537           (5,713,081)             342,406           113,869           6,055,487        N/A BEGINNING FUND BALANCE, Jan 1 6,259,402        7,558,405               7,558,405        1,299,003         ‐                         100.00% ENDING FUND BALANCE, Mar 31 6,487,939$      1,845,324$            7,900,811$      1,412,872$      6,055,487$      428.15% Operating Reserve 190,480           216,784                  216,784            AVAILABLE FUND BALANCE 6,297,459$      1,628,540$            7,684,027$       VARIANCE AIRPORT Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 26 of 41   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 142,000$ -$ 142,000$ AIRPORT OFFICE REHAB 2,718,316 - 2,718,316 MAJOR FACILITY MAINTENANCE 451,135 41,426 409,709 SURFACE WATER SYSTEM REHABILITATION 94,496 - 94,496 PAVEMENT MANAGEMENT PROGRAM 505,930 11,143 494,787 SNOW REMOVAL EQUIPMENT 167,000 - 167,000 MASTER PLAN UPDATE 26,277 2,812 23,465 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 6,597,008$ 55,381$ 6,541,627$ Non-capital items included in project budgets (550,000) (2,812) (547,188) Operating fund equipment purchase - - - TOTAL CAPITAL OUTLAY 6,047,008$ 52,569$ 5,994,439$ AIRPORT PROJECT BALANCES AT MARCH 31, 2021 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 89,664$            ‐$                             62,807$           (26,857)$          62,807$           N/A Charges for services 5,258,251        22,636,386            5,189,285        (68,966)            (17,447,101)    22.92% Interest and other misc 9,894                5,000                       3,463                (6,431)               (1,537)               69.26% TOTAL REVENUES 5,357,809        22,641,386            5,255,555        (102,254)          (17,385,831)    23.21% EXPENSES: Personnel 155,464           727,085                  115,590           39,874              611,495           15.90% Supplies 617                   11,900                    341                   276                   11,559              2.87% Contracted Services 4,259,450        21,542,403            4,154,577        104,873           17,387,826      19.29% Internal Services 128,547           307,835                  80,262              48,285              227,573           26.07% TOTAL OPERATING EXPENSES 4,544,078        22,589,223            4,350,770        193,308           18,238,453      19.26% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 813,731           52,163                    904,785           91,054              852,622           1734.53% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 813,731           52,163                    904,785           91,054              852,622           1734.53% BEGINNING FUND BALANCE, Jan 1 2,266,127        2,771,562               2,771,562        505,435            ‐                         100.00% ENDING FUND BALANCE, Mar 31 3,079,858$      2,823,725$            3,676,347$      596,489$         852,622$         130.19% Operating Reserve 400,000           400,000                  400,000            AVAILABLE FUND BALANCE 2,679,858$      2,423,725$            3,276,347$       SOLID WASTE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 27 of 41   Golf Course Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Maplewood Golf Course.         Capital Outlay – A listing of project budgets and balances at March 31 is as follows:           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 280,571$         2,304,205$            428,492$         147,921$         (1,875,713)$    18.60% Rents, leases, and misc fees 47,169              527,600                  34,674              (12,495)            (492,926)          6.57% Interest and other misc 1,611                1,370                       1,471                (140)                  101                   107.37% TOTAL REVENUES 329,351           2,833,175               464,637           135,286           (2,368,538)       16.40% EXPENSES: Personnel 333,370           1,673,092               348,236           (14,866)            1,324,856        20.81% Supplies 79,643              321,500                  53,211              26,432              268,289           16.55% Contracted Services 35,415              176,150                  39,562              (4,147)               136,588           22.46% Internal Services 88,102              350,258                  87,565              537                   262,693           25.00% TOTAL OPERATING EXPENSES 536,530           2,521,000               528,574           7,956                1,992,426        20.97% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (207,179)          312,175                  (63,937)            143,242           (376,112)           ‐20.48% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                         45,000                     ‐                          ‐                         45,000              0.00% TRANSFERS IN 19,000              68,100                    17,025              (1,975)               (51,075)            25.00% TRANSFERS OUT 21,695              68,100                    17,025              4,670                51,075              25.00% NET TRANSFERS (2,695)                ‐                                 ‐                         2,695                 ‐                         N/A CHANGE IN FUND BALANCE (209,874)          267,175                  (63,937)            145,937           (331,112)           ‐23.93% BEGINNING FUND BALANCE, Jan 1 173,750           476,746                  476,746           302,996            ‐                         100.00% ENDING FUND BALANCE, Mar 31 (36,124)$          743,921$                412,809$         448,933$         (331,112)$        55.49% Operating Reserve 585,769           641,500                  641,500            AVAILABLE FUND BALANCE (621,893)$        102,421$                (228,691)$         GOLF COURSE VARIANCE PROJECT BUDGET ACTUAL BALANCE MACHINERY & EQUIPMENT 25,000$ -$ 25,000$ GOLF MM COURSE - MAINTENANCE 43,100 - 43,100 TOTAL PROJECT BALANCES 68,100$ -$ 68,100$ Non-capital items included in project budgets (43,100) - (43,100) Operating fund equipment purchase 20,000 - 20,000 TOTAL CAPITAL OUTLAY 45,000$ -$ 45,000$ GOLF PROJECT BALANCES AT MARCH 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 28 of 41   Water Utility Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the City’s water utility.        Capital Outlay ‐ A listing of project budgets and balances at March 31 is provided on the following page.     2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 3,640,732$      17,314,812$          3,748,189$      107,457$         (13,566,623)$  21.65% Rents, leases, and misc fees 48,809              136,591                  51,334              2,525                (85,257)            37.58% Interest and other misc 319,282           521,000                  219,173           (100,109)          (301,827)          42.07% TOTAL REVENUES 4,008,823        17,972,403            4,018,696        9,873                (13,953,707)    22.36% EXPENSES: Personnel 1,077,642        4,753,110               1,149,257        (71,615)            3,603,853        24.18% Supplies 171,772           885,590                  181,484           (9,712)               704,106           20.49% Contracted Services 708,814           3,290,219               653,816           54,998              2,636,403        19.87% Internal Services 581,918           2,799,928               673,808           (91,890)            2,126,120        24.07% TOTAL OPERATING EXPENSES 2,540,146        11,728,847            2,658,365        (118,219)          9,070,482        22.67% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,468,677        6,243,556               1,360,331        (108,346)          (4,883,225)       21.79% DEBT SERVICE: Principal ‐                         1,563,068                ‐                          ‐                         1,563,068        0.00% Interest ‐                         216,506                   ‐                          ‐                         216,506           0.00% TOTAL DEBT SERVICE ‐                         1,779,574                ‐                          ‐                         1,779,574        0.00% CAPITAL OUTLAY 744,955           35,563,246            659,420           85,535              34,903,826      1.85% TRANSFERS OUT 330                    ‐                                 ‐                         330                    ‐                         N/A NET TRANSFERS (330)                   ‐                                 ‐                         330                    ‐                         N/A CHANGE IN FUND BALANCE 723,392           (31,099,264)           700,911           (22,481)            31,800,175      N/A BEGINNING FUND BALANCE, Jan 1 37,569,067      40,776,314            40,776,314      3,207,247         ‐                         100.00% ENDING FUND BALANCE, Mar 31 38,292,459$   9,677,050$            41,477,225$   3,184,766$      31,800,175$   428.61% Restricted for Debt Service 1,394,050        1,394,050               1,394,050         Operating Reserve 3,072,760        1,624,606               1,624,606         AVAILABLE FUND BALANCE 33,825,649$   6,658,394$            38,458,569$    WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 29 of 41   Water Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE PIPE OVERSIZING COSTS 100,000$ -$ 100,000$ TELEMETRY IMPROVEMENTS-PHASE 4 227,965 2,308 225,657 WATER SYSTEM PLAN UPDATE 334,254 26,128 308,126 UPDATE EMERGENCY RESPONSE PLAN 221,490 4,560 216,930 STEEL/AC WATERMAIN REPLC PLAN 1,553,482 1,100 1,552,382 RESERVOIR RECOATING 194,600 - 194,600 EMERGENCY RESPONSE PROJ 100,000 - 100,000 DOWNTOWN WATER MAIN REPLACEMENT 3,309,613 166,910 3,142,703 WATER PUMP STATIONS REHAB 400,000 - 400,000 RESERVOIR PRV METERS 337,235 7,983 329,252 MPLWD WATER TREATMENT IMPROV - CONST 715,241 - 715,241 MAPLEWOOD PUMP STATION ROOF REPLACEMENT - 743 (743) HIGHLANDS WATER MAIN IMPROVEMENT 1,078,738 2,411 1,076,327 DUVALL AVE NE WATER MAIN REPLACEMENT 457,600 - 457,600 EMERGENCY POWER TO PUMP STATION 290,586 - 290,586 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 - 536,810 AUTOMATIC METER READING CONVERSION 196,115 - 196,115 HIGHLANDS 435-RESERVOIRS REPLACEMENT 23,065,776 17,436 23,048,340 RAINIER AVE S ROAD & UTILITIES IMPRVMNT 300,000 - 300,000 KENNYDALE 320-RESERVOIR 1,390,842 454,876 935,966 BRONSN/HOUSR/WILLIAM BRIDGES WTRMAINREPL 200,000 - 200,000 TOTAL PROJECT BALANCES 35,533,283$ 685,548$ 34,847,735$ Non-capital items included in project budgets - (26,128) 26,128 Operating fund equipment purchase 29,963 - 29,963 TOTAL CAPITAL OUTLAY 35,563,246$ 659,420$ 34,903,826$ WATER UTILITY FUND PROJECT BALANCES AT MARCH 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 30 of 41   Wastewater Utility Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the City’s wastewater utility.        Capital Outlay ‐ A listing of project budgets and balances at March 31 is provided on the following page.   2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 31,775$           62,111$                  18,375$           (13,400)$          (43,736)$          29.58% Charges for services 2,718,672        11,280,375            2,718,718        46                      (8,561,657)       24.10% Fines and penalties ‐                          ‐                                695                   695                   695                   N/A Interest and other misc 195,401           444,000                  175,857           (19,544)            (268,143)          39.61% TOTAL REVENUES 2,945,848        11,786,486            2,913,645        (32,203)            (8,872,841)       24.72% EXPENSES: Personnel 567,578           2,651,185               554,170           13,408              2,097,015        20.90% Supplies 9,863                73,842                    16,040              (6,177)               57,802              21.72% Contracted Services 485,390           2,989,196               505,487           (20,097)            2,483,709        16.91% Internal Services 417,264           1,967,280               494,334           (77,070)            1,472,946        25.13% TOTAL OPERATING EXPENSES 1,480,095        7,681,503               1,570,031        (89,936)            6,111,472        20.44% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,465,753        4,104,983               1,343,614        (122,139)          (2,761,369)       32.73% DEBT SERVICE: Principal ‐                         612,850                   ‐                          ‐                         612,850           0.00% Interest ‐                         97,301                     ‐                          ‐                         97,301              0.00% TOTAL DEBT SERVICE ‐                         710,151                   ‐                         ‐                         710,151           0.00% CAPITAL OUTLAY 147,176           20,241,883            331,771           (184,595)          19,910,112      1.64% NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 1,318,577        (16,847,051)           1,011,843        (306,734)          17,858,894      N/A BEGINNING FUND BALANCE, Jan 1 19,832,351      23,996,217            23,996,217      4,163,866         ‐                         100.00% ENDING FUND BALANCE, Mar 31 21,150,928$   7,149,166$            25,008,060$   3,857,132$      17,858,894$   349.80% Restricted for Debt Service 661,227           661,227                  661,227            Operating Reserve 1,489,966        913,756                  913,756            AVAILABLE FUND BALANCE 18,999,735$   5,574,183$            23,433,077$    WASTEWATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 31 of 41   Wastewater Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE MISCELANEOUS SEWER PROJECTS 379,419$ 349$ 379,070$ 2008 LONG-RANGE WW MANAG PLAN 62,597 14,484 48,113 WASTEWATER OPERATIONS MASTER PLAN 724,622 - 724,622 FALCON RIDGE LS REHAB - 133 (133) THUNDER HILL INT REPL/REHAB 3,074,074 18,134 3,055,940 FORCE MAIN REHABILITATION REPLACEMENT 1,883,308 1,929 1,881,379 LIFT STATION REHABILITATION 1,879,795 1,993 1,877,802 DOWNTOWN SEWER REPLACEMENT/REHAB 7,192,313 242,608 6,949,705 2019 SANITARY SEWER REHAB/REPLACEMENT - 550 (550) 2020 SANITARY SEWER REHAB/REPLACEMENT - 3,927 (3,927) KENNYDALE LAKELINE SEWER UPGRADE 3,344,460 62,396 3,282,064 SANITARY SEWER REHAB/REPLACEMENT 2,478,314 102 2,478,212 TOTAL PROJECT BALANCES 21,018,902$ 346,605$ 20,672,297$ Non-capital items included in project budgets (787,219) (14,834) (772,385) Operating fund equipment purchase 10,200 - 10,200 TOTAL CAPITAL OUTLAY 20,241,883$ 331,771$ 19,910,112$ WASTEWATER UTILITY FUND PROJECT BALANCES AT MARCH 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 32 of 41   King County Metro Fund  This fund accounts for revenues and expenses for operation of the City’s wastewater utility, as it relates to charges for and  payment to King County Metro for water treatment services.        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 4,277,356$      17,607,838$          4,226,071$      (51,285)$          (13,381,767)$  24.00% Interest and other misc 20,073               ‐                                5,872                (14,201)            5,872                N/A TOTAL REVENUES 4,297,429        17,607,838            4,231,943        (65,486)            (13,375,895)    24.03% EXPENSES: Contracted Services 4,244,070        17,607,838            4,369,980        (125,910)          13,237,858      24.82% TOTAL OPERATING EXPENSES 4,244,070        17,607,838            4,369,980        (125,910)          13,237,858      24.82% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 53,359               ‐                                (138,037)          (191,396)          (138,037)          N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 53,359               ‐                                (138,037)          (191,396)          (138,037)          N/A BEGINNING FUND BALANCE, Jan 1 5,961,906        4,729,749               4,729,749        (1,232,157)        ‐                         100.00% ENDING FUND BALANCE, Mar 31 6,015,265$      4,729,749$            4,591,712$      (1,423,553)$    (138,037)$        97.08% Operating Reserve 380,000           380,000                  380,000            AVAILABLE FUND BALANCE 5,635,265$      4,349,749$            4,211,712$       KING COUNTY METRO VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 33 of 41   Surface Water Utility Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the City’s surface water utility.        Capital Outlay ‐ A listing of project budgets and balances at March 31 is provided on the following page.     2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 23,225$           50,708$                  10,500$           (12,725)$          (40,208)$          20.71% Grants / intergovernmental 560,614           11,424,296            229,949           (330,665)          (11,194,347)    2.01% Charges for services 2,939,386        12,101,509            3,249,026        309,640           (8,852,483)       26.85% Interest and other misc 147,609           609,250                  99,013              (48,596)            (510,237)          16.25% TOTAL REVENUES 3,670,834        24,185,763            3,588,488        (82,346)            (20,597,275)    14.84% EXPENSES: Personnel 876,981           3,730,881               938,278           (61,297)            2,792,603        25.15% Supplies 32,131              175,848                  25,264              6,867                150,584           14.37% Contracted Services 373,515           4,198,022               385,637           (12,122)            3,812,385        9.19% Internal Services 520,698           2,643,197               681,256           (160,558)          1,961,941        25.77% TOTAL OPERATING EXPENSES 1,803,325        10,747,948            2,030,435        (227,110)          8,717,513        18.89% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,867,509        13,437,815            1,558,053        (309,456)          (11,879,762)    11.59% DEBT SERVICE: Principal ‐                         499,900                   ‐                          ‐                         499,900           0.00% Interest 130,000           630,950                   ‐                         130,000           630,950           0.00% TOTAL DEBT SERVICE 130,000           1,130,850                ‐                         130,000           1,130,850        0.00% CAPITAL OUTLAY 379,244           19,607,962            503,171           (123,927)          19,104,791      2.57% Transfers Out ‐                         18,347                     ‐                          ‐                         18,347              0.00% NET TRANSFERS ‐                         (18,347)                    ‐                          ‐                         18,347              N/A CHANGE IN FUND BALANCE 1,358,265        (7,319,344)             1,054,882        (303,383)          8,374,226        N/A BEGINNING FUND BALANCE, Jan 1 18,377,556      21,610,356            21,610,356      3,232,800         ‐                         100.00% ENDING FUND BALANCE, Mar 31 19,735,821$   14,291,012$          22,665,238$   2,929,417$      8,374,226$      158.60% Restricted for Debt Service 754,868           754,868                  754,868            Operating Reserve 1,252,915        1,109,340               1,109,340         AVAILABLE FUND BALANCE 17,728,038$   12,426,804$          20,801,030$    SURFACE WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 34 of 41   Surface Water Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE COMP S&SW MGMT PLAN P&D 28,474$ 3,400$ 25,074$ SM DRAINAGE PROBLEMS 578,564 5,774 572,790 PANTHER CR WL MOSQUITO ABATEMENT 95,776 1,071 94,705 MADSEN CREEK SEDIMENT BASIN 84,291 1,107 83,184 SMALL DRAINAGE PROJ-MAPLEWOOD SEDIMENT 101,000 1,026 99,974 WETLAND MITIGATION BANK 109,586 8,295 101,291 ACOE 205 PROJECT 58,737 - 58,737 CEDAR RIVER GRAVEL REMOVAL 2,681,201 43,111 2,638,090 RENTON STORM WATER MANUAL 68,147 - 68,147 GREEN RIVER ECOSYSTEM STUDY 48,177 - 48,177 MISCELLANEOUS/EMERGENCY/STORM PROJECTS 100,000 - 100,000 SURFACE WATER UTILITY GIS 121,755 31,268 90,487 HARDIE AVE S UNDERPASS STORM SYSTEM IMPR 2,391 - 2,391 MONROE AVE/N 2ND ST 826,497 52,008 774,489 STORMWATER FACILITY FENCING PROJECT 262,200 1,528 260,672 CEDAR RIVER 205 LEVEE RECERTIFICATION 4,532,900 9,727 4,523,173 SE 172ND ST/125TH AVE SE 140,399 27,317 113,082 RAINIER AVE/OAKSDALE AVE PUMP STATION UP 147,121 16,336 130,785 NE 16TH/JEFFERSON AVE NE 2,623,430 17,886 2,605,544 DOWNTOWN STORM SYSTEM IMPROVEMENT PROJEC 5,705,777 263,845 5,441,932 HEATHER DOWNS DETENTION POND 786,921 6,876 780,045 MADSEN CRK IMPROV PHASE 1-KCFCD 843,598 21,301 822,297 RAINIER AVE/BENSON RD S - CULVERT REPL - 3,670 (3,670) CMP STORM SYSTEM REPLACEMENT PROJECT 559,038 16,636 542,402 CEDAR RIVER FLOOD RISK REDUCTION 491,545 4,112 487,433 STORMWATER FACILITY RETROFIT STUDY 271,810 42,258 229,552 BURNETT AVE S/WILLIAMS AVE S 495,797 43,556 452,241 WSDOT LA ROW RUNOFF IMPACT MITIGATION 145,471 19,218 126,253 SW 23RD ST DRAINAGE AND FISH PASSAGE IMP 350,000 350,000 TOTAL PROJECT BALANCES 22,260,603$ 641,326$ 21,619,277$ Non-capital items included in project budgets (2,681,201) (138,155) (2,543,046) Operating fund equipment purchase 28,560 - 28,560 TOTAL CAPITAL OUTLAY 19,607,962$ 503,171$ 19,104,791$ SURFACE WATER UTILITY PROJECT BALANCES AT MARCH 31, 2021 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 35 of 41   INTERNAL SERVICE FUNDS  Internal service funds are used to account for the goods and services furnished by one City department to other City  departments on a cost reimbursement basis. YTD budgets are not prepared for Internal Service Funds.    Equipment Rental Fund  This fund accounts for revenues and expenses for administration, purchase, and maintenance of the City’s vehicle and  equipment Fleet services. Departments pay in monthly amounts for maintenance and operations. Replacement reserves are  paid monthly over the estimated useful lives of each individual vehicle or piece of equipment. These reverses are accumulated  in fund balance so that they are available to fund the replacement of the vehicle/equipment when the time comes.            2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 12,773$            ‐$                             27,186$           14,413$           27,186$           N/A Interdepartmental services 1,433,622        6,542,775               1,635,702        202,080           (4,907,073)       25.00% Interest and other misc 22,877              12,000                    8,329                (14,548)            (3,671)               69.41% TOTAL REVENUES 1,469,272        6,554,775               1,671,217        201,945           (4,883,558)       25.50% EXPENSES: Personnel 288,607           1,206,146               276,350           12,257              929,796           22.91% Supplies 252,045           1,496,153               311,695           (59,650)            1,184,458        20.83% Contracted Services 58,341              133,166                  59,272              (931)                  73,894              44.51% Internal Services 9,173                30,338                    7,977                1,196                22,361              26.29% TOTAL OPERATING EXPENSES 608,166           2,865,803               655,294           (47,128)            2,210,509        22.87% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 861,106           3,688,972               1,015,923        154,817           (2,673,049)       27.54% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 272,735           2,423,743               115,671           157,064           2,308,072        4.77% NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 588,371           1,265,229               900,252           311,881           (364,977)          71.15% BEGINNING FUND BALANCE, Jan 1 6,851,811        6,376,259               6,376,259        (475,552)           ‐                         100.00% ENDING FUND BALANCE, Mar 31 7,440,182$      7,641,488$            7,276,511$      (163,671)$        (364,977)$        95.22% EQUIPMENT RENTAL VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 36 of 41   Insurance Fund  This fund accounts for the administration and operation of the City’s self‐insurance programs for property losses, liability,  workers’ compensation, and unemployment compensation. Expenses are paid by the Insurance Fund and rates are charged  to departments based on their claims history over the preceding five years and coverage requirements.           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 786,525$         3,511,775$            775,976$         (10,549)$          (2,735,799)$    22.10% Interest and other misc 75,560              22,000                    85,388              9,828                63,388              388.13% TOTAL REVENUES 862,085           3,533,775               861,364           (721)                  (2,672,411)       24.38% EXPENSES: Personnel 258,715           1,411,787               275,948           (17,233)            1,135,839        19.55% Supplies 374                   6,956                       30                      344                   6,926                0.43% Contracted Services 655,659           2,279,772               672,718           (17,059)            1,607,054        29.51% Internal Services ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TOTAL OPERATING EXPENSES 914,748           3,698,515               948,696           (33,948)            2,749,819        25.65% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (52,663)            (164,740)                 (87,332)            (34,669)            77,408              N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE (52,663)            (164,740)                 (87,332)            (34,669)            77,408              N/A BEGINNING FUND BALANCE, Jan 1 19,095,508      19,860,208            19,860,208      764,700            ‐                         100.00% ENDING FUND BALANCE, Mar 31 19,042,845$   19,695,468$          19,772,876$   730,031$         77,408$           100.39% Operating Reserves 16,479,631      13,952,413            13,952,413       AVAILABLE FUND BALANCE 2,563,214$      5,743,055$            5,820,463$       INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 37 of 41   Information Technology Fund  This fund accounts for the administration, purchase, and operation of the City’s information technology systems, including  computer hardware and software, network servers and infrastructure, phone systems, and cell phones. Expenses are paid by  the Information Technology Fund and rates are charged to departments based on use.            2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 74,067$           150,000$                51,853$           (22,214)$          (98,147)$          34.57% Charges for services ‐                          ‐                                 ‐                          ‐                          ‐                         N/A Interdepartmental services 1,446,529        6,435,901               1,608,975        162,446           (4,826,926)       25.00% Interest and other misc 17,056              7,000                       28,209              11,153              21,209              402.99% TOTAL REVENUES 1,537,652        6,592,901               1,689,037        151,385           (4,903,864)       25.62% EXPENSES: Personnel 761,501           3,292,443               711,094           50,407              2,581,349        21.60% Supplies 119,770           757,555                  122,184           (2,414)               635,371           16.13% Contracted Services 626,630           2,486,071               398,225           228,405           2,087,846        16.02% Internal Services 451                    ‐                                 ‐                         451                    ‐                         N/A TOTAL OPERATING EXPENSES 1,508,352        6,536,069               1,231,503        276,849           5,304,566        18.84% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 29,300              56,832                    457,534           428,234           400,702           805.06% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 14,520              838,000                  9,435                5,085                828,565           1.13% TRANSFERS IN 5,745                21,477                    3,598                (2,147)               (17,879)            16.75% NET TRANSFERS 5,745                21,477                    3,598                (2,147)               (17,879)            16.75% CHANGE IN FUND BALANCE 20,525              (759,691)                 451,697           431,172           1,211,388        N/A BEGINNING FUND BALANCE, Jan 1 4,490,062        3,939,941               3,939,941        (550,121)           ‐                         100.00% ENDING FUND BALANCE, Mar 31 4,510,587$      3,180,250$            4,391,638$      (118,949)$        1,211,388$      138.09% INFORMATION TECHNOLOGY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 38 of 41   Facilities Fund  This fund accounts for the administration, maintenance, and operation of City‐owned facilities. Expenses are paid by the  Facilities Fund and rates are charged to departments based on square footage.            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 1,351,377        5,992,730               1,498,183        146,806           (4,494,547)       25.00% Rents, leases, and misc fees 1                         ‐                                 ‐                         (1)                        ‐                         N/A Interest and other misc 4,388                4,000                       431                   (3,957)               (3,569)               10.78% TOTAL REVENUES 1,377,601        5,996,730               1,498,614        121,013           (4,498,116)       24.99% EXPENSES: Personnel 779,843           3,861,996               722,413           57,430              3,139,583        18.71% Supplies 170,290           307,068                  57,911              112,379           249,157           18.86% Contracted Services 366,201           1,869,621               275,120           91,081              1,594,501        14.72% Internal Services 19,011              129,486                  32,427              (13,416)            97,059              25.04% TOTAL OPERATING EXPENSES 1,335,345        6,168,171               1,087,871        247,474           5,080,300        17.64% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 42,256              (171,441)                 410,743           368,487           582,184           N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 5,704                 ‐                                 ‐                         5,704                 ‐                         N/A Transfers In 7,459                 ‐                                 ‐                         (7,459)                ‐                         N/A NET TRANSFERS 7,459                 ‐                                 ‐                         (7,459)                ‐                         N/A CHANGE IN FUND BALANCE 44,011              (171,441)                 410,743           366,732           582,184           N/A BEGINNING FUND BALANCE, Jan 1 1,220,276        504,167                  504,167           (716,109)           ‐                         100.00% ENDING FUND BALANCE, Mar 31 1,264,287$      332,726$                914,910$         (349,377)$        582,184$         274.97% FACILITIES VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 39 of 41   Communications Fund  This fund accounts for community and intergovernmental relations and communications with the public. Communications is  a major activity of the City’s administration responsible for external communications, employee communications, media  relations, and coordination of all departments in producing the City’s website. Expenses are paid by the Communications  Fund and rates are charged to departments based on usage.           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 283,360$         1,154,732$            288,684$         5,324$              (866,048)$        25.00% Interest and other misc 2,703                1,000                       165                   (2,538)               (835)                  16.50% TOTAL REVENUES 286,063           1,155,732               288,849           2,786                (866,883)          24.99% EXPENSES: Personnel 223,519           810,882                  167,512           56,007              643,370           20.66% Supplies 11,959              55,432                    5,236                6,723                50,196              9.45% Contracted Services 52,388              284,512                  39,306              13,082              245,206           13.82% Internal Services 985                   2,000                       500                   485                   1,500                25.00% TOTAL OPERATING EXPENSES 288,851           1,152,826               212,554           76,297              940,272           18.44% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (2,788)               2,906                       76,295              79,083              73,389              2625.43% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A Transfers Out 329                    ‐                                 ‐                         329                    ‐                         N/A NET TRANSFERS (329)                   ‐                                 ‐                         329                    ‐                         N/A CHANGE IN FUND BALANCE (3,117)               2,906                       76,295              79,412              73,389              2625.43% BEGINNING FUND BALANCE, Jan 1 803,561           151,624                  151,624           (651,937)           ‐                         100.00% ENDING FUND BALANCE, Mar 31 800,444$         154,530$                227,919$         (572,525)$        73,389$           147.49% COMMUNICATIONS VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 40 of 41   Health Insurance Fund  This fund accounts for the City’s self‐insured health insurance program. Expenses/claims are paid by the Health Insurance  Fund and rates are charged to employees and departments based on annual premiums determined by the City’s Employee  Health Plan Board for each type of coverage elected by the employee; paid semi‐monthly in conjunction with each payroll.              2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Premiums 3,029,358$      12,328,055$            3,061,839$      32,481$           (9,266,216)$    24.84% Interest and other misc 17,996              149,488                    96,326              78,330              (53,162)            64.44% TOTAL REVENUES 3,047,354        12,477,543               3,158,165        110,811           (9,319,378)       25.31% EXPENSES: Personnel 2,487,533        12,015,118               2,726,936        (239,403)          9,288,182        22.70% Supplies 6,881                7,500                          ‐                         6,881                7,500                0.00% Contracted Services 134,811           478,037                    133,336           1,475                344,701           27.89% Internal Services 15,107              80,176                       20,044              (4,937)               60,132              25.00% TOTAL OPERATING EXPENSES 2,644,332        12,580,831               2,880,316        (235,984)          9,700,515        22.89% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 403,022           (103,288)                   277,849           (125,173)          381,137           N/A TOTAL DEBT SERVICE ‐                          ‐                                   ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                   ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                   ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 403,022           (103,288)                   277,849           (125,173)          381,137           N/A BEGINNING FUND BALANCE, Jan 1 5,151,648        5,773,429                 5,773,429        621,781            ‐                         100.00% ENDING FUND BALANCE, Mar 31 5,554,670$      5,670,141$               6,051,278$      496,608$         381,137$         106.72% Operating Reserves 3,757,179        3,774,249                 3,774,249         AVAILABLE FUND BALANCE 1,797,491$      1,895,892$               2,277,029$       HEALTH INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2021  Page 41 of 41   Retiree Healthcare Fund  This fund accounts for the City’s self‐insured health insurance program for LEOFF1 retirees. Benefits include medical,  prescription drug, Medicare Part B premiums, long‐term care, and vision coverage for retired law enforcement officers and  firefighters that were employed by the City prior to October 1, 1977. Dependent spouses and children are not covered. 100%  of premiums are provided by the General Fund with annual contributions determined 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$                   ‐$                       (35,245)$          (45,933)$          0.00% Premiums 656,171           2,640,000               656,171            ‐                         (1,983,829)       24.85% Interest and other misc 53,282              20,000                    39,043              (14,239)            19,043              195.22% TOTAL REVENUES 744,698           2,705,933               695,214           (49,484)            (2,010,719)       25.69% EXPENSES: Personnel 299,055           1,333,374               258,713           40,342              1,074,661        19.40% Contracted Services 12,742              29,311                    12,217              525                   17,094              41.68% TOTAL OPERATING EXPENSES 311,797           1,362,685               270,930           40,867              1,091,755        19.88% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 432,901           1,343,248               424,284           (8,617)               (918,964)          31.59% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 432,901           1,343,248               424,284           (8,617)               (918,964)          31.59% BEGINNING FUND BALANCE, Jan 1 15,799,729      16,541,245            16,541,245      741,516            ‐                         100.00% ENDING FUND BALANCE, Mar 31 16,232,630$   17,884,493$          16,965,529$   732,899$         (918,964)$        94.86% Restricted for OPEB 16,232,630      17,884,493            16,965,529       AVAILABLE FUND BALANCE ‐$                        ‐$                              ‐$                        RETIREE HEALTHCARE VARIANCE