Loading...
HomeMy WebLinkAboutQUARTER 2 2021 Finance Department  Memorandum         DATE: August 9, 2021     TO: Randy Corman, Council President  Members of Renton City Council    CC: Armondo Pavone, Mayor  Ed VanValey, Chief Administrative Officer     FROM: Kari Roller, Finance Administrator     STAFF CONTACT: Misty Baker, Sr. Finance Analyst     SUBJECT: Quarterly Financial Report 2nd 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 June 2021.      General Fund revenues, excluding interfund transfers, were $60.5M, which is $8.7M  higher than 2020, and $6.9M higher than the year‐to‐date (YTD) budget.     General Fund expenditures, excluding interfund transfers, were $49M, which is $1M  more than 2020 and $5.9M less than the YTD budget.      Detailed explanations are provided for General Fund revenue and expenditure items with  variances exceeding $100K.    Also provided are tables for each of the City’s other funds with comparison to prior year  and annual budget (YTD budgets are not prepared for City funds, with the exception of  the General Fund). For funds that adopt capital project budgets (which are subject to carry  forward in accordance with City Policy 220‐01), schedules of the project budgets have  also been provided.     Please do not hesitate to contact me at x6869 should you have any questions or any  suggestions about the report.            Page 1 of 43   OVERVIEW  This quarterly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through June 30, 2021.  A detailed analysis, including current to prior year and budget to actual comparison is included for each City fund. Excluded  from this report are the City’s fiduciary funds as these funds are held on behalf of others and are not available for City use.  Budget figures shown reflect amounts authorized in ORD 6021, which includes the 2nd quarter budget adjustment approved  July 19, 2021.     GENERAL FUND  The General Fund is used to account for resources that are not generally dedicated for a specific purpose. The General Fund  is used to meet the basic services that the City provides including, but not limited to, police protection, parks and recreation,  human services, municipal court, street maintenance and planning, economic development, and administrative functions.  The table below displays the YTD revenues and expenditures for the General Fund, including comparison to prior year,  comparison to YTD budget amounts, and percentage of annual budget. YTD budget amounts are generally based on the  collection/disbursement patterns for the same period of the preceding two (2) years, with the following exceptions: property  tax revenue budgets are based on the collection patterns over the preceding four (4) years and sales tax revenue budgets are  based on the collection patterns over the preceding five (5) years.      General Fund YTD Prior Year YTD YTD Budget % BUDGET REVENUES Taxes 39,938,916$      80,869,450$    42,196,183$ 47,030,740$   7,091,824$      4,834,557$     58.16% Licenses & Permits 2,730,287            4,776,877          2,553,452       3,090,889         360,602              537,437            64.71% Intergovernmental 2,011,473            6,819,265          1,992,254       2,912,922         901,449              920,668            42.72% Charges for Services 3,922,097            8,172,266          4,022,201       4,458,650         536,553              436,449            54.56% Fines and Penalties 1,734,081            3,829,782          1,904,692       2,240,858         506,777              336,166            58.51% Miscellaneous 1,488,256            1,866,685          966,533            720,826             (767,430)            (245,707)           38.62% Other Financing Sources (Transfer‐In, etc) 8,832,084            94,575                   ‐                        79,877                (8,752,207)        79,877               84.46% TOTAL REVENUES 60,657,194         106,428,900    53,635,315    60,534,762      (122,432)            6,899,447        56.88% EXPENDITURES Council 211,027                554,485               302,821            263,832             (52,805)               38,989               47.58% Executive 1,301,766            2,947,427          1,439,102       1,308,638         (6,872)                  130,464            44.40% Emergency Management 535,049                781,615               377,028            312,927             222,122              64,101               40.04% City Attorney 1,156,877            2,611,347          1,300,976       1,221,531         (64,654)               79,445               46.78% Court Services 1,275,518            3,102,930          1,551,291       1,346,899         (71,381)               204,392            43.41% Community and Economic Development 5,053,924            13,174,098       5,930,730       6,365,243         (1,311,319)        (434,513)           48.32% Finance 1,478,947            4,158,944          1,781,342       1,656,367         (177,420)            124,975            39.83% City Clerk 710,320                1,528,840          875,088            794,165             (83,845)               80,923               51.95% Human Resources 724,979                1,662,207          815,022            732,298             (7,319)                  82,724               44.06% Police 21,117,028         43,239,054       21,416,296    20,169,610      947,418              1,246,686        46.65% Community Services 7,200,575            19,174,012       9,074,399       6,935,910         264,665              2,138,489        36.17% Public Works 6,126,162            13,749,916       6,868,138       6,382,448         (256,286)            485,690            46.42% Non‐Departmental and Other 9,510,773            10,883,880       4,656,634       3,044,148         6,466,625         1,612,486        27.97% TOTAL EXPENDITURES 56,402,945         117,568,755    56,388,867    50,534,016      5,513,407         5,854,851        42.98% Change in Fund Balance 4,254,249            (11,139,855)      (2,753,552)      10,000,746      5,746,497         12,754,298     N/A Beginning Fund Balance 48,155,847         54,456,582       54,456,582    54,456,582      6,300,735          ‐                        100.00% ENDING FUND BALANCE 52,410,096$      43,316,727$    51,703,030$ 64,457,328$   12,047,232$   12,754,298$  148.80% Operating Reserve 13,994,674         11,905,500       11,905,500    11,905,500       Economic Development Reserve 2,500,000            2,500,000          2,500,000       2,500,000          AVAILABLE FUND BALANCE 35,915,422$      28,911,227$    37,297,530$ 50,051,828$    Favorable (Unfavorable) 2020 2021 Variance YTD Actual Annual Budget YTD Budget YTD Actual Summary of Sources and Uses Quarterly Financial Report 2nd Quarter 2021  Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 2 of 43   GENERAL FUND REVENUES  The following tables provide a more detailed summary of each revenue category within the General Fund. Detailed  explanations have been provided for variances from prior year or YTD budget in excess of $100K. All variances are shown in  a favourable/(unfavourable) format.    TAXES        Property Tax – Property tax collections by King County have exceeded prior year and YTD budget. $195K of property taxes  collected through June 30 were for prior years’ delinquent taxes, bringing the balance of delinquent taxes receivable to $98K.  The remainder of taxes collected were for the 2021 levy. The 2021 property tax levy, after levy changes by the assessor’s  office, totalled $22,794,007. The taxes receivable balance for the 2021 levy is $10.9M at June 30.    Local Retail Sales Tax – COVID‐19 will continue to influence the sales tax figures throughout 2021. Some industries such as  construction and manufacturing have not caught up to pre‐pandemic performance, but we should see them improving as  more projects and business activities resume. Some industries such as general retail, services, and automotive/gas have  recovered from the pandemic and exceeded both 2020 and 2019 sales.     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 mid‐biennial 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.     State Sales Tax Credit – The City was awarded $500k per year in sales tax credit revenues under the Local Revitalization  Financing program. This award is to pay the debt service on the LRF bonds issued in 2019 to fund public improvements within  the South Lake Washington Local Revitalization Area.     In accordance with SHB 1406, the City passed ORD 5972 authorizing a .0073 sales and use tax for affordable and supportive  housing. The City began collecting these sales tax credit revenues in December 2020.    The City also received a one‐time payment in the amount of $587K in May 2020 related to sales tax credit revenues owed for  the Benson Hill Annexation. This on‐time payment was the result of an audit at the State level where it was determined the  State had underpaid the City in 2019.    Criminal Justice Sales Tax – The criminal justice sales tax is a 0.1% sales tax imposed by the County for criminal justice  purposes. The County must share 90% of the revenues collected with all cities and towns in the county on a per capita basis.  The increase in criminal justice sales tax directly relates to the increase in local retail sales tax, as described above.    2020 2021 2021 Actual Budget Actual $ % $ % Property Tax 11,346,387         11,820,796          11,973,989         627,602              5.5% 153,193              1.3% Local Retail Sales Tax 12,684,477         13,107,221          15,313,928         2,629,451         20.7% 2,206,707         16.8% Local Retail Sales Tax ‐ Housing & Related Svc ‐                                    ‐                                   1,144,141            1,144,141         100.0% 1,144,141         100.0% State Sales Tax Credit 746,377                 101,115                 141,437                 (604,940)             ‐81.1%40,322                 39.9% Criminal Justice Sales Tax 1,444,570            1,423,556             1,610,496            165,926              11.5% 186,940              13.1% Natural Gas Use Tax 82,218                    152,058                 77,534                    (4,684)                   ‐5.7% (74,524)                ‐49.0% Admission Tax 83,775                    91,667                    1,232                       (82,543)                ‐98.5% (90,435)                ‐98.7% Utility Tax 7,935,376            7,811,939             7,783,912            (151,464)             ‐1.9% (28,027)                ‐0.4% Leasehold Excise Tax 61,729                    52,532                    85,706                    23,977                 38.8% 33,174                 63.2% Gambling Excise Tax 1,340,441            1,203,733             1,699,670            359,229              26.8% 495,937              41.2% B&O Tax 4,213,566            6,431,567             7,198,695            2,985,129         70.8% 767,128              11.9% YTD Total 39,938,916$      42,196,183$       47,030,740$      7,091,824$      17.8% 4,834,557$      11.5% Annual Total 78,953,070$      80,869,450$        Taxes by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through June Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 3 of 43   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:        Gambling Excise Tax – Gambling excise taxes are $359K higher than 2020 and $496K higher than budget. These revenues  have almost recovered to pre‐pandemic levels and are just $216K less than the same period in 2019.     Business and Occupation (B&O) Tax – B&O tax revenues rely heavily on the revenue of a limited number of large businesses.  Payments received in the 1st quarter of each year are generally for activity in the 4th quarter of the prior year. $1.3M of the  $3M over the 2020 revenue is due to one taxpayer who had a 4th quarter amount due for the first time as they had reached  the B&O tax “cap” in prior years. The rest of the increase is due to various businesses.    LICENSES & PERMITS        Franchise Fees – Franchise permits grant authority to a provider to use the City’s right‐of‐way to provide or distribute its  services. Franchises are most commonly used to provide utility or telecommunications service. The amount of franchise fees  over the prior year and over budget are the result of increased permitting activity.    Business Licenses – The amount of business license revenue budget over budget is due to better than expected economic  recovery. The business license revenue budget was adjusted down at the start of the pandemic and has remained low as it  was unknown how quickly the economy would recover and how many businesses would be able to survive the COVID  restrictions placed on businesses. The revenue budget will be adjusted to updated estimates with the mid‐biennial budget  adjustment.    Building Permits – Building permit revenues increased from the prior year due primarily to the following: 1) $60K of tech fees  previously paid into the IT internal service fund have been allocated to the General Fund to offset online permitting credit  card fees; 2) electrical permits issued increased by 331, resulting in a $113K increase in permit revenues; 3) mechanical  permits issued increased by 401, resulting in a $19K increase in permit revenues; 4) $46K in new small cell permits were  issued; and 5) commercial and residential building permits decreased by 57 resulting in a $36K decrease in permit revenues.  Building permit revenues are over budget primarily due to the following: 1) electrical and mechanical permit revenues are  higher than anticipated; and 2) small cell permit revenues were not budgeted as 2021 is the first year collecting these  revenues.      2020 2021 2021 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Electrical 2,567,012$     2,546,177$         2,566,707$     (305)$                 0.0% $         20,530 0.8% Natural Gas 1,001,836        794,556                 960,658            (41,178)             ‐4.1%          166,102 20.9% Cell 439,820            318,375                 274,458            (165,362)          ‐37.6%           (43,917)‐13.8% Phone 312,502            409,757                 353,359            40,857              13.1%           (56,398)‐13.8% Cable 609,389            652,611                 594,479            (14,910)             ‐2.5%           (58,132)‐8.9% Garbage 592,172            409,992                 398,945            (193,227)          ‐32.6%           (11,047)‐2.7% City Utilities 2,412,645        2,680,471            2,635,306        222,661           9.2%           (45,165)‐1.7% YTD Total 7,935,376$     7,811,939$         7,783,912$     (151,464)$      ‐1.9%(28,027)$        ‐0.4% 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % Franchise Fees 732,385                 609,507                 803,215                 70,831                 9.7% 193,709              31.8% Business Licenses 720,157                 689,205                 807,884                 87,727                 12.2% 118,679              17.2% Animal Licenses 38,330                    49,723                    36,330                    (2,000)                   ‐5.2% (13,393)                ‐26.9% Building Permits 1,221,835            1,181,084             1,419,705            197,870              16.2% 238,620              20.2% ROW/Street Excavation Permits 17,360                    23,807                    23,670                    6,310                    36.3%(137)                        ‐0.6% Special Event Permits 220                           127                            85                              (135)                        ‐61.4% (42)                           ‐32.9% YTD Total 2,730,287$         2,553,452$          3,090,889$         360,602$           13.2% 537,437$           21.0% Annual Total 5,199,555$         4,776,877$           Licenses & Permits by Type Year to Date through June Revenue 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 4 of 43   INTERGOVERNMENTAL        State Shared Revenue – The breakdown of State Shared Revenue is as follows:        Federal/State/Local Grants – Federal/State/Local grant revenues vary significantly from year‐to‐year based on what grants  have been awarded and the timing of grant expenditures and related reimbursement requests. Grant revenues are budgeted  at 100% of the award at the time the grant agreement is finalized and any amounts not received are carried forward each  year until either 1) the grant funds are fully received or 2) the grant agreement expires.        2020 2021 2021 Actual Budget Actual $ % $ % State Shared Revenue 1,982,220$         1,724,519$          1,904,233$         (77,987)$             ‐3.9%179,714$           10.4% Federal Grants 3,284                       20,572                    725,698                 722,414              21998.0% 705,126              3427.6% State Grants 100                           15,394                    12,705                    12,605                 12605.0%(2,689)                   ‐17.5% Local Grants 25,869                    231,769                 270,286                 244,417              944.8% 38,517                 16.6% YTD Total 2,011,473$         1,992,254$          2,912,922$         901,449$           44.8% 920,668$           46.2% Annual Total 9,387,084$         6,819,265$           Intergovernmental by Type Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through June 2020 2021 2021 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Judicial Contribution 21,536$         10,322$         21,529$         (7)$                    0.0%11,207$        108.6% Crim Just ‐ High Crime 140,366          ‐                            ‐                           (140,366)       ‐100.0%‐                          N/A Crim Just ‐ Pop 15,878            11,996            16,785            907                  5.7% 4,789              39.9% Crim Just ‐ Spec Prog 56,993            55,115            59,916            2,923              5.1% 4,801              8.7% State DUI 6,871               8,764               8,283               1,412              20.6%(481)                  ‐5.5% Marijuana Distribution 103,655         100,654         99,682            (3,973)             ‐3.8% (972)                  ‐1.0% Liquor Profits 420,397         424,991         416,882         (3,515)             ‐0.8% (8,109)             ‐1.9% Liquor Excise Tax 300,478         236,935         363,146         62,668           20.9% 126,211        53.3% Fuel Tax 916,046         875,742         918,010         1,964              0.2% 42,268           4.8% YTD Total 1,982,220$  1,724,519$  1,904,233$  (77,987)$      ‐3.9%179,714$     10.4% 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 5 of 43   CHARGES FOR SERVICES        Public Safety Services – The increase in public safety services and the amount over budget is due to payments received for  private security services provided in the 4th quarter of 2020 and increased collections of electronic home detention fees.    Development Services – The increase in development services over the prior year is due to an increase in planning fees  ($209K) and inspection services ($61K). The amount over budget is due to planning fees ($354K) offset by lower than  anticipated inspection services ($60K) and administrative fees ($20K).     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 and the amount over budget is due to  reimbursement of staffing costs from CIP projects.     FINES AND PENALTIES        Photo Enforcement Program – Photo enforcement revenues have increased from prior year due and are over budget due to  increased citations associated with traffic is returning to pre‐COVID‐19 levels. Traffic volumes have increased and school zone  cameras were turned back on as in‐person learning resumed in early March. The photo enforcement revenue budget will be  re‐evaluated during the mid‐biennial budget adjustment.       2020 2021 2021 Actual Budget Actual $ % $ % Passport Fees 8,883                       18,017                     ‐                                   (8,883)                  0.0%(18,017)               0.0% Court Services 25,419                    17,630                    32,811                    7,392                    29.1% 15,181                 86.1% General Government Services 446                           3,862                       337                           (109)                        ‐24.4% (3,525)                   ‐91.3% Public Safety Services 462,364                 417,789                 638,775                 176,411              38.2% 220,986              52.9% Development Services 859,738                 847,795                 1,116,623            256,886              29.9% 268,828              31.7% Transportation Services 43,079                     ‐                                   6,891                       (36,189)                ‐84.0%6,891                    100.0% Recreation/Farmer's Market/Events 189,316                 356,313                 85,567                    (103,749)             ‐54.8% (270,746)             ‐76.0% Interfund Services 2,332,852            2,360,795             2,577,647            244,794              10.5% 216,852              9.2% YTD Total 3,922,097$         4,022,201$          4,458,650$         536,553$           13.7% 436,449$           10.9% Annual Total 7,514,930$         8,172,266$           Year to Date through June Charges for Services by Type Revenue 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % Civil Penalties 183,204$              137,121$              141,510$              (41,695)$             ‐22.8%4,389$                 3.2% Photo Enforcement Program 1,421,892            1,691,549             2,006,867            584,974              41.1% 315,318              18.6% Criminal Traffic Misdemeanor Fines 26,754                    22,096                    25,947                    (807)                        ‐3.0%3,851                    17.4% Criminal Non‐Traffic Fines 11,206                    9,949                       3,088                       (8,118)                   ‐72.4% (6,861)                   ‐69.0% Criminal Costs 38,984                    23,086                    26,443                    (12,540)                ‐32.2%3,357                    14.5% Non‐Court Fines, Forfeitures and Penalties 52,040                    20,891                    37,004                    (15,036)                ‐28.9%16,112                 77.1% YTD Total 1,734,081$         1,904,692$          2,240,858$         506,777$           29.2% 336,166$           17.6% Annual Total 3,310,279$         3,829,782$           Year to Date through June Revenue 2021 vs. 2020 2021 vs. Budget Fines and Penalties by Type Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 6 of 43   MISCELLANEOUS REVENUES        Interest and Other Investment Earnings – Interest earnings have decreased from the prior year primarily due to: 1) a timing  difference in the recording of interfund interest ($250K); and 2) an overall reduction in interest rates. The amount of interest  under budget is almost entirely due to the interfund interest payment not being recorded in the 1st half of 2021.    Rents, Leases, and Concessions – Rents, leases, and concessions revenues are over budget primarily due to higher than  anticipated concessions from one lessee ($118K).    Latecomer Agreement – Latecomer agreements for Sunset Lane infrastructure improvements were finalized in 2020.  Payments are due from property owners if/when various conditions are met. Conditions were met for one property owner  in 2020 and payment was received. It is not possible to estimate if/when the various conditions will be met for the other  property owners and, therefore, receipt of payments under the agreements will not be budgeted.     Other – Other miscellaneous revenues are under budget primarily due to budgeted utility late payments not received.    OTHER FINANCING SOURCES      2020 2021 2021 Actual Budget Actual $ % $ % Interest and Other Investment Earnings 560,997$              418,771$              146,272$              (414,725)$          ‐73.9% (272,499)$          ‐65.1% Rents, Leases, and Concessions 413,179                 367,924                 489,236                 76,057                 18.4% 121,312              33.0% Contributions/Donations from Private Sources 60,426                    22,168                    44,203                    (16,223)                ‐26.8%22,035                 99.4% Latecomer Agreement 326,880                  ‐                                    ‐                                   (326,880)            0.0%‐                                N/A Other 126,774                 157,670                 41,115                    (85,659)                ‐67.6% (116,555)             ‐73.9% YTD Total 1,488,256$         966,533$              720,826$              (767,430)$          ‐51.6% (245,707)$          ‐25.4% Annual Total 2,138,245$         1,866,685$           Miscellaneous by Type Year to Date through June Revenue 2021 vs. 2020 2021 vs. Budget 2020 2021 2021 Actual Budget Actual $ % $ % Transfers from Other Funds 8,813,984$          ‐$                                16,679$                 (8,797,305)         ‐99.8%16,679                 100.0% Insurance Recoveries ‐                                    ‐                                   23,980                    23,980                 100.0% 23,980                 100.0% Sale of Capital Assets 18,100                     ‐                                   39,218                    21,118                 116.7% 39,218                 100.0% YTD Total 8,832,084$          ‐$                                79,877$                 (8,752,207)$      ‐99.1%79,877$              100.0% Annual Total 17,656,495$      94,575$                  Revenue 2021 vs. 2020 2021 vs. Budget Year to Date through June Other Financing Sources by Type Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 7 of 43   GENERAL FUND EXPENDITURES  The following tables summarize expenditures by category for each department within the General Fund. Detailed  explanations have been provided for variances from prior year or YTD budget in excess of $100K.     COUNCIL        EXECUTIVE        EMERGENCY MANAGEMENT        Supplies – The amount of supplies under the prior year is due to COVID‐19. In 2020, supplies purchased for combating the  COVID‐19 pandemic, including PPE, cleaners, etc, were charged to the emergency management department. In 2021, these  items are charged to the department purchasing them.    CITY ATTORNEY         Council Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 160,571$             421,784$            210,892$         228,844$          (68,273)$            ‐42.5% (17,952)$          ‐8.5% Supplies 778                           2,000                     1,008                  165                        613                       78.8% 843                     83.6% Contracted Services 18,605                   63,316                  57,228               1,130                   17,475               93.9% 56,098              98.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 31,073                   67,385                  33,693               33,693                (2,620)                  ‐8.4%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 211,027$             554,485$            302,821$         263,832$          (52,805)$            ‐25.0%38,989$           12.9% 2021 vs. Budget2021 2021 vs. 2020 Executive Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 438,691$             940,177$            470,089$         417,822$          20,869$            4.8% 52,267$           11.1% Supplies 1,319                      7,100                     4,411                  121                        1,198                  90.8% 4,290                 97.3% Contracted Services 630,475                1,445,246           687,150            612,573             17,902               2.8% 74,577              10.9% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 231,281                554,904               277,452            278,122             (46,841)               ‐20.3% (670)                     ‐0.2% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,301,766$         2,947,427$        1,439,102$    1,308,638$      (6,872)$               ‐0.5%130,464$        9.1% 2021 vs. Budget2021 2021 vs. 2020 Emergency Management Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 237,216$             485,218$            242,609$         185,905$          51,311$            21.6% 56,704$           23.4% Supplies 105,794                2,775                     415                       ‐                               105,794            100.0% 415                     100.0% Contracted Services 84,108                   41,086                  7,736                  754                        83,354               99.1% 6,982                 90.3% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 107,237                252,536               126,268            126,268             (19,031)               ‐17.7%‐                             0.0% Transfers Out 694                            ‐                                  ‐                               ‐                               694                       100.0%‐                             0.0% Total Expenditures 535,049$             781,615$            377,028$         312,927$          222,122$         41.5% 64,101$           17.0% 2021 vs. Budget2021 2021 vs. 2020 City Attorney Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,043,840$         2,350,586$        1,175,293$    1,109,340$      (65,500)$            ‐6.3%65,953$           5.6% Supplies 853                           3,550                     1,942                  104                        749                       87.8% 1,838                 94.6% Contracted Services 9,463                      49,450                  19,860               8,206                   1,257                  13.3% 11,654              58.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 102,721                207,761               103,881            103,881             (1,160)                  ‐1.1%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,156,877$         2,611,347$        1,300,976$    1,221,531$      (64,654)$            ‐5.6%79,445$           6.1% 2021 2021 vs. Budget2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 8 of 43   COURT SERVICES        Personnel – The amount of personnel costs under the YTD budget is due to open positions.    COMMUNITY AND ECONOMIC DEVELOPMENT ‐ ADMIN        Transfers Out – The amount of transfers under the prior year is due to a change in accounting for transfers between  consolidated funds. In prior years transfers in/out between management funds of the General Fund were shown gross.  Beginning in 2021, these transfers are now being net so that when consolidated the transfers in and transfers out between  the funds are eliminated. Only transfers between the General Fund and the other fund types will be reported. This is  consistent with the treatment of intrafund transfers for external financial reporting.     COMMUNITY AND ECONOMIC DEVELOPMENT ‐ DEVELOPMENT SERVICES        Personnel – The amount of personnel costs under the YTD budget is due to open positions.       Court Services Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 985,231$             2,389,087$        1,194,544$    1,025,533$      (40,302)$            ‐4.1%169,011$        14.1% Supplies 1,044                      7,700                     2,380                  1,016                   28                          2.7% 1,364                 57.3% Contracted Services 48,531                   149,716               76,153               42,136                6,395                  13.2% 34,017              44.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 238,758                556,427               278,214            278,214             (39,456)               ‐16.5%‐                             0.0% Transfers Out 1,954                       ‐                                  ‐                               ‐                               1,954                  100.0%‐                             0.0% Total Expenditures 1,275,518$         3,102,930$        1,551,291$    1,346,899$      (71,381)$            ‐5.6%204,392$        13.2% 2021 2021 vs. Budget2021 vs. 2020 Community and Econ Dvlpmnt Admin Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 194,204$             392,792$            196,396$         135,509$          58,695$            30.2% 60,887$           31.0% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 275                            ‐                                  ‐                              232                        43                          15.6%(232)                    100.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 559,860                1,100,917           550,459            550,459             9,401                  1.7%‐                             0.0% Transfers Out 183,860                3,130                     3,130                  3,130                   180,730            98.3%‐                             0.0% Total Expenditures 938,199$             1,496,839$        749,985$         689,330$          248,869$         26.5% 60,655$           8.1% 2021 2021 vs. Budget2021 vs. 2020 Development Services Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,179,720$         2,661,020$        1,330,510$    1,086,902$      92,818$            7.9% 243,608$        18.3% Supplies 1,222                      12,250                  4,466                  1,098                   124                       10.1% 3,368                 75.4% Contracted Services 55,231                   200,862               123,121            35,960                19,271               34.9% 87,161              70.8% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 32,739                   55,244                  27,622               27,622                5,117                  15.6%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,268,912$         2,929,376$        1,485,719$    1,151,582$      117,330$         9.2% 334,137$        22.5% 2021 2021 vs. Budget2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 9 of 43   COMMUNITY AND ECONOMIC DEVELOPMENT ‐ ECONOMIC DEVELOPMENT        Contracted Services ‐ The increase in contracted services over the prior year is primarily due to two affordable housing grants  paid in the 2nd quarter of 2021 ($99.6K and $700K), offset by decreases in impact fee waivers in the 2nd quarter of 2020 that  did not occur in 2021 ($121K). The affordable housing grants paid out in the 2nd quarter of 2021 were approved by Council  and budgeted in 2020. They are included in the 2nd 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.    COMMUNITY AND ECONOMIC DEVELOPMENT ‐ PLANNING        Personnel ‐ The amount of personnel costs under the YTD budget is due to open positions.    Contracted Services – The amount of contracted services over the prior year is due to contracts for multiple projects including  1) ADU design plans, 2) TOD Subarea Plan, 3) Light Rail Transit Conceptual evaluation, and 4) general structural plan review.     FINANCE        Personnel ‐ The amount of personnel costs under the YTD budget is due to open positions.  Economic Development Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 433,170$             916,639$            458,320$         453,982$          (20,812)$            ‐4.8%4,338$              0.9% Supplies 1,068                      6,320                     517                      1,798                   (730)                      ‐68.4% (1,281)                ‐247.8% Contracted Services 295,801                1,706,785           472,329            911,894             (616,093)            ‐208.3% (439,565)          ‐93.1% Capital Outlay 95,071                   1,163,748           343,144            959,186             (864,115)            ‐908.9% (616,042)          ‐179.5% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 825,110$             3,793,492$        1,274,310$    2,326,860$      (1,501,750)$    ‐182.0% (1,052,550)$   ‐82.6% 2021 2021 vs. Budget2021 vs. 2020 Planning Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,952,987$         4,476,281$        2,238,141$    1,964,427$      (11,440)$            ‐0.6%273,714$        12.2% Supplies 1,876                      13,050                  7,208                  2,823                   (947)                      ‐50.5%4,385                 60.8% Contracted Services 49,430                   377,081               131,377            186,231             (136,801)            ‐276.8% (54,854)             ‐41.8% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 17,410                   87,979                  43,990               43,990                (26,580)               ‐152.7%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 2,021,703$         4,954,391$        2,420,716$    2,197,471$      (175,768)$         ‐8.7%223,245$        9.2% 2021 2021 vs. Budget2021 vs. 2020 Finance Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 989,942$             2,465,985$        1,232,993$    1,015,391$      (25,449)$            ‐2.6%217,602$        17.6% Supplies 884                           11,500                  3,831                  384                        500                       56.6% 3,447                 90.0% Contracted Services 268,689                1,212,698           310,137            406,211             (137,522)            ‐51.2% (96,074)             ‐31.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 219,432                468,761               234,381            234,381             (14,949)               ‐6.8%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,478,947$         4,158,944$        1,781,342$    1,656,367$      (177,420)$         ‐12.0%124,975$        7.0% 2021 2021 vs. Budget2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 10 of 43   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.    CITY CLERK        HUMAN RESOURCES        POLICE        Personnel – The decrease in personnel costs from the prior year is primarily the result of vacant positions resulting in a  decrease in salaries ($383K) and benefits ($38K), offset by an increase in patrol operations overtime ($59K) and private  security overtime ($61K). The amount under the YTD budget is due to open positions resulting in savings in salaries ($635K)  and benefits ($433K), offset by overages in patrol operations overtime ($135K) and private security overtime ($103K).    Supplies – The amount of supplies under the YTD budget is due to lower than expected expenditures for operating supplies  ($78K) and small tools/minor equipment purchases ($52K), $30K of the amount under the YTD budget is associated with  grants.    Contracted Services – The decrease in contracted services costs from the prior year is primarily due to the following: 1)  decreased professional services ($133K ‐ $60K of which is emergency communications costs); 2) decreased operating rentals  ($65K); 3) decreased miscellaneous contracted services ($15K); 4) increased training costs ($33K). The amount of contracted  services under the YTD budget is primarily due to the following: 1) lower than anticipated professional services costs ($50K);  and 2) lower than expected operating rental costs ($179K).     City Clerk Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 368,364$             911,188$            455,594$         372,427$          (4,063)$               ‐1.1%83,167$           18.3% Supplies 838                           6,994                     3,407                  493                        345                       41.2% 2,914                 85.5% Contracted Services 245,553                397,620               309,568            314,726             (69,173)               ‐28.2% (5,158)                ‐1.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 95,565                   213,038               106,519            106,519             (10,954)               ‐11.5%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 710,320$             1,528,840$        875,088$         794,165$          (83,845)$            ‐11.8%80,923$           9.2% 2021 2021 vs. Budget2021 vs. 2020 Human Resources Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 554,362$             1,141,385$        570,693$         553,190$          1,172$               0.2% 17,503$           3.1% Supplies 2,031                      21,828                  9,839                  5,121                   (3,090)                  ‐152.1%4,718                 48.0% Contracted Services 27,809                   213,038               91,512               31,009                (3,200)                  ‐11.5%60,503              66.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 140,777                285,956               142,978            142,978             (2,201)                  ‐1.6%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 724,979$             1,662,207$        815,022$         732,298$          (7,319)$               ‐1.0%82,724$           10.1% 2021 2021 vs. Budget2021 vs. 2020 Police Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 12,862,225$      26,779,339$     13,389,670$ 12,560,230$   301,995$         2.3% 829,440$        6.2% Supplies 164,548                549,607               277,171            146,376             18,172               11.0% 130,795           47.2% Contracted Services 2,246,766            4,953,635           2,291,763       2,065,938         180,828            8.0% 225,825           9.9% Capital Outlay ‐                                  41,154                   ‐                              8,600                   (8,600)                 100.0%(8,600)               100.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 2,692,169            6,207,561           3,103,781       3,034,588         (342,419)            ‐12.7%69,193              2.2% Transfers Out 797,113                 ‐                                  ‐                               ‐                               797,113            100.0%‐                             0.0% Total Expenditures 18,762,821$      38,531,296$     19,062,385$ 17,815,732$   947,089$         5.0% 1,246,653$   6.5% 2021 2021 vs. Budget2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 11 of 43   Internal Services – The amount of internal services costs over the prior year are primarily due to the following: 1) increased  IT charges ($98K); 2) decreased Communications charges ($11K); 3) increased Fleet charges ($241K – equipment replacement  reserve charges were frozen in 2020 in response to COVID budget cuts); 4) decreased Insurance charges ($35K); and 5)  increased Facilities charges ($49K).    Transfers Out – The decrease in transfers out from the prior year is due to the transferring of seizure funds out of the General  Fund and into special revenue funds in 2020. The special revenue funds were established to allow for transparency in  accounting and reporting for the receipt and use of seizure funds.     POLICE ‐ JAIL SERVICES        COMMUNITY SERVICES ‐ ADMIN        COMMUNITY SERVICES ‐ LEASED PROPERTIES           Jail Services Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel ‐$                                ‐$                               ‐$                            ‐$                             ‐$                           0.0%‐$                          0.0% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 2,354,207            4,707,758           2,353,911       2,353,878         329                       0.0% 33                        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 2,354,207$         4,707,758$        2,353,911$    2,353,878$      329$                    0.0% 33$                     0.0% 2021 2021 vs. Budget2021 vs. 2020 Community Services Admin Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 183,879$             378,206$            189,103$         186,925$          (3,046)$               ‐1.7%2,178$              1.2% Supplies 891                           7,200                     2,849                  421                        470                       52.7% 2,428                 85.2% Contracted Services 11,688                   35,544                  20,373               5,809                   5,879                  50.3% 14,564              71.5% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 75,331                   171,107               85,554               85,554                (10,223)               ‐13.6%‐                             0.0% Transfers Out 616                            ‐                                  ‐                              39,207                (38,591)               ‐6264.8% (39,207)            100.0% Total Expenditures 272,405$             592,057$            297,879$         317,916$          (45,511)$            ‐16.7% (20,037)$          ‐6.7% 2021 vs. Budget2021 vs. 20202021 Leased Properties Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 89,472                   185,794               92,897               90,105                (633)$                   ‐0.7%2,792$              3.0% Supplies 428                           2,440                     833                      20,305                (19,877)               ‐4644.2% (19,472)             ‐2337.6% Contracted Services 230,193                658,465               312,571            250,130             (19,937)               ‐8.7%62,441              20.0% Capital Outlay 27,188                    ‐                            ‐                         ‐                         27,188               100.0%‐                             0.0% Debt Service ‐                             ‐                            ‐                         ‐                          ‐                              0.0%‐                             0.0% Internal Services 1,425                      3,177                     1,589                  1,589                   (164)                      ‐11.5%‐                             0.0% Transfers Out ‐                             ‐                            ‐                         ‐                          ‐                              0.0%‐                             0.0% Total Expenditures 348,706$             849,876$            407,890$         362,129$          (13,423)$            ‐3.8%45,761$           11.2% 2021 2021 vs. 2020 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 12 of 43   COMMUNITY SERVICES ‐ PARKS AND TRAILS        Personnel – The amount of personnel costs under the YTD budget is due to vacant positions.     Contracted Services – The amount of contracted services over the prior year is primary due to the following: 1) Pre‐design  costs associated with the relocation of the Cedar River Trail away from the river ($40K); 2) increase in water costs ($21K); 3)  routine parking lot and sport court maintenance that did not occur in the 1st half of 2020 ($20K); and 4) increase in homeless  encampment clean‐up services ($39K).     Internal Services – The amount of internal services costs over the prior year is primarily due to the following: 1) increased IT  charges ($23K); 2) increased Fleet charges ($70K ‐ equipment replacement reserve charges were frozen in April 2020 as part  of COVID budget cuts); and 3) increased Facilities charges ($69K).     COMMUNITY SERVICES ‐ PARKS PLANNING AND NATURAL RESOURCES        Contracted Services – The amount of contracted services under the prior year and the YTD budget is primarily due to tree  maintenance. There was a large contract for a complete tree inventory performed in 2020 that is not repeated in 2021, and  there have been delays in the vendor’s invoicing the City for work performed, which is contributing to the amounts under the  prior year and budget.     COMMUNITY SERVICES ‐ RECREATION AND NEIGHBORHOODS        Personnel – The decrease in personnel costs from the prior year and the amount under budget is due to open positions, the  result of recreation facility closures related to COVID‐19.        Parks & Trails Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,440,342$         4,059,603$        2,029,802$    1,440,100$      242$                    0.0% 589,702$        29.1% Supplies 70,060                   248,859               128,702            93,221                (23,161)               ‐33.1%35,481              27.6% Contracted Services 185,807                774,947               232,704            315,080             (129,273)            ‐69.6% (82,376)             ‐35.4% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 718,578                1,757,711           878,856            878,442             (159,864)            ‐22.2%414                     0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 2,414,787$         6,841,120$        3,270,064$    2,726,843$      (312,056)$         ‐12.9%543,221$        16.6% 2021 2021 vs. Budget2021 vs. 2020 Parks Planning & Natural Resources Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 451,746$             1,007,634$        503,817$         458,693$          (6,947)$               ‐1.5%45,124$           9.0% Supplies 162                           4,827                     615                      1,426                   (1,264)                  ‐780.2% (811)                     ‐131.9% Contracted Services 423,756                960,463               377,685            222,532             201,224            47.5% 155,153           41.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 24,738                   76,437                  38,219               38,219                (13,481)               ‐54.5%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 900,402$             2,049,361$        920,336$         720,870$          179,532$         19.9% 199,466$        21.7% 2021 2021 vs. Budget2021 vs. 2020 Recreation & Neighborhoods Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,363,211$         3,844,106$        1,922,053$    979,491$          383,720$         28.1% 942,562$        49.0% Supplies 48,240                   292,499               135,677            43,458                4,782                  9.9% 92,219              68.0% Contracted Services 114,974                423,096               143,879            61,680                53,294               46.4% 82,199              57.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 948,722                2,012,798           1,006,399       1,006,604         (57,882)               ‐6.1% (205)                    0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 2,475,147$         6,572,499$        3,208,008$    2,091,233$      383,914$         15.5% 1,116,775$   34.8% 2021 2021 vs. Budget2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 13 of 43   COMMUNITY SERVICES ‐ HUMAN SERVICES        Contracted Services – The amount of contracted services under the YTD budget is due to the CDBG Coronavirus grant included  in the 2nd quarter budget adjustment. No expenditures under the grant have been incurred to date.      COMMUNITY SERVICES ‐ MUSEUM        PUBLIC WORKS ‐ ADMIN        PUBLIC WORKS ‐ STREET MAINTENANCE        Personnel – The amount of personnel costs under the prior year and the YTD budget is due to open positions.       Human Services Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 306,460$             646,138$            323,069$         317,853$          (11,393)$            ‐3.7%5,216$              1.6% Supplies 2,532                      15,650                  6,023                  3,319                   (787)                      ‐31.1%2,704                 44.9% Contracted Services 291,176                1,195,617           435,282            200,538             90,638               31.1% 234,744           53.9% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 59,538                   121,998               60,999               60,957                (1,419)                  ‐2.4%42                        0.1% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 659,706$             1,979,403$        825,373$         582,667$          77,039$            11.7% 242,706$        29.4% 2021 vs. Budget2021 vs. 20202021 Museum Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 69,911$                150,777$            75,389$            64,790$             5,121$               7.3% 10,599$           14.1% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 59,511                   138,919               69,460               69,462                (9,951)                  ‐16.7% (2)                          0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 129,422$             289,696$            144,849$         134,252$          (4,830)$               ‐3.7%10,597$           7.3% 2021 vs. Budget2021 vs. 20202021 Public Works Admin Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 121,576$             377,829$            188,915$         186,789$          (65,213)$            ‐53.6%2,126$              1.1% Supplies 438                           800                          171                      145                        293                       66.9% 26                        15.2% Contracted Services 26,700                   1,650                     859                      590                        26,110               97.8% 269                     31.3% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 54,785                   117,712               58,856               58,856                (4,071)                  ‐7.4%‐                             0.0% Transfers Out 1,137                       ‐                                  ‐                               ‐                               1,137                  100.0%‐                             0.0% Total Expenditures 204,636$             497,991$            248,801$         246,380$          (41,744)$            ‐20.4%2,421$              1.0% 2021 vs. Budget2021 2021 vs. 2020 Street Maintenance Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,452,573$         3,235,633$        1,617,817$    1,320,352$      132,221$         9.1% 297,465$        18.4% Supplies 159,125                319,798               149,281            177,830             (18,705)               ‐11.8% (28,549)             ‐19.1% Contracted Services 495,119                1,128,154           524,574            515,897             (20,778)               ‐4.2%8,677                 1.7% Capital Outlay ‐                                  5,200                      ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 685,962                1,923,976           961,988            997,314             (311,352)            ‐45.4% (35,326)             ‐3.7% Transfers Out 4,811                       ‐                                  ‐                               ‐                               4,811                  100.0%‐                             0.0% Total Expenditures 2,797,590$         6,612,761$        3,253,660$    3,011,393$      (213,803)$         ‐7.6%242,267$        7.4% 2021 vs. 20202021 2021 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 14 of 43   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. Replacement reserve charges were  frozen in April 2020 in response to COVID budget cuts.    PUBLIC WORKS ‐ TRANSPORTATION        Contracted Services – The amount of contracted services under the YTD budget is primarily due to the following: 1) lower  than anticipated electricity costs ($105K); and 2) no payments have been made to‐date for professional services under the  “Building the Mobility Network” program ($28K).    NON‐DEPARTMENTAL AND OTHER        Personnel ‐ The amount of personnel expenditures over the prior year is due to timing of employee separations. The amount  of personnel expenditures under the YTD budget is due to lower than anticipated employee separation payments.     Contracted Services – The amount of contracted services under budget is due to contingency reserves that are set aside for  unanticipated costs related to the SCORE.      Transportation Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 2,173,365$         4,552,850$        2,276,425$    2,204,064$      (30,699)$            ‐1.4%72,361$           3.2% Supplies 101,330                230,702               107,884            79,565                21,765               21.5% 28,319              26.2% Contracted Services 473,237                1,019,483           563,303            422,466             50,771               10.7% 140,837           25.0% Capital Outlay 13,818                    ‐                                  ‐                               ‐                               13,818               100.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 362,186                836,129               418,065            418,580             (56,394)               ‐15.6% (515)                     ‐0.1% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 3,123,936$         6,639,164$        3,365,677$    3,124,675$      (739)$                  0.0%241,002$        7.2% 2021 vs. Budget2021 vs. 20202021 Non‐Departmental and Other Summary of Uses 2020 Year to Date through June YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,056,419$         3,407,200$        1,720,301$    1,425,805$      (369,386)$         ‐35.0%294,496$        17.1% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 100,564                2,368,661           1,439,117       121,127             (20,563)               ‐20.4%1,317,990      91.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                  225,309                ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 9,414                      14,055                  7,028                  7,028                   2,386                  25.3%‐                             0.0% Transfers Out 8,344,376            4,868,655           1,490,188       1,490,188         6,854,189        82.1%‐                             0.0% Total Expenditures 9,510,773$         10,883,880$     4,656,634$    3,044,148$      6,466,626$     68.0% 1,612,486$   34.6% 2021 vs. Budget2021 2021 vs. 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 15 of 43   DEBT SERVICE FUNDS  Debt service funds are used to account for the accumulation of resources for the payment of principal and interest related to  the City’s general obligation bond issues. YTD budgets are not prepared for debt service funds.     GENERAL GOVERNMENTAL MISCELLANEOUS DEBT FUND  The General Governmental Miscellaneous Debt Fund is the only debt service fund maintained by the City.        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 2nd quarter 2021 is the final payment scheduled to  be received from Fire District 40 related to the debt service on the loan.    Transfers In – Transfers in will be processed to coincide with the timing of debt service payments.   2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 28,678$                50,983$                  51,092$         22,414$        109$                100.21% Charges for services 193,414                63,648                    63,648           (129,766)       ‐                        100.00% Investment Earnings 22,001                    ‐                                11,471           (10,530)         11,471            N/A TOTAL REVENUES 244,093                114,631                  126,211         (117,882)      11,580            110.10% EXPENDITURES: Principal 181,622                5,625,158               188,804         (7,182)           5,436,354       3.36% Interest 876,071                1,527,861               735,263         140,808        792,598          48.12% TOTAL EXPENDITURES 1,057,693             7,153,019               924,067         133,626        6,228,952       12.92% Transfers In ‐                              7,378,667               1,490,188      1,490,188    (5,888,479)     20.20% NET TRANSFERS ‐                              7,378,667               1,490,188      1,490,188    (5,888,479)     20.20% CHANGE IN FUND BALANCE (813,600)               340,279                  692,332         1,505,932    352,053          203.46% BEGINNING FUND BALANCE, Jan 1 3,999,457             5,010,629               5,010,629      1,011,172     ‐                        100.00% ENDING FUND BALANCE, Jun 30 3,185,857$           5,350,908$            5,702,961$   2,517,104$  352,053$        106.58% Debt Service Reserve 2,717,575             2,717,575               2,717,575       AVAILABLE FUND BALANCE 468,282$              2,633,333$            2,985,386$    VARIANCE FAVORABLE (UNFAVORABLE) GENERAL GOVERNMENTAL MISCELLANEOUS DEBT Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 16 of 43   SPECIAL REVENUE FUNDS  Special revenue funds are used to account for revenues that are to be used for a specific purpose as required by law or  legislative action. YTD budgets are not prepared for special revenue funds.     Hotel/Motel Fund  The Hotel/Motel Fund accounts for monies collected through an increase of 1% in hotel/motel taxes for the purpose of  increasing tourism in the City or Renton, as authorized under RCW 67.28.180. The Lodging Tax Advisory Committee solicits  applications for awards and brings their recommendations to Council for approval at least once per year. Awards for events  are paid to applicants at the conclusion of the event once certain reporting requirements have been met.        Cable Communications Fund  The Cable Communications Fund accounts for funding for promotion and development of cable communications as  established by City ordinance. The main use of the fund is to support the broadcasting of City Council meetings on Channel  21.      2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 140,524$              200,000$                95,725$                (44,799)$               (104,275)$             47.86% Contributions ‐                              25,000                     20,000                   20,000                   (5,000)                    80.00% Investment Earnings 5,070                      ‐                                1,858                     (3,212)                    1,858                     N/A TOTAL REVENUES 145,594                225,000                   117,583                (28,011)                 (107,417)               52.26% EXPENDITURES: Contracted Services 104,381                461,197                   122,415                (18,034)                 338,782                26.54% TOTAL EXPENDITURES 104,381                461,197                   122,415                (18,034)                 338,782                26.54% NET TRANSFERS ‐                              (40,000)                     ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 41,213                   (276,197)                 (4,832)                    (46,045)                 271,365                1.75% BEGINNING FUND BALANCE, Jan 1 943,889                893,604                   893,604                (50,285)                  ‐                              94.67% ENDING FUND BALANCE, Jun 30 985,102$              617,407$                888,772$              (96,330)$               271,365$              90.22% VARIANCE FAVORABLE (UNFAVORABLE) HOTEL/MOTEL 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 41,132$                57,674$                    37,320$                (3,812)$                 (20,354)$               64.71% Investment Earnings 3,182                      ‐                                  1,419                     (1,763)                    1,419                     N/A TOTAL REVENUES 44,314                   57,674                      38,739                   (5,574)                    (18,935)                 67.17% EXPENDITURES: Supplies ‐                              6,302                          ‐                               ‐                              6,302                     0.00% Contracted Services 17,100                   51,372                      17,780                   680                        33,592                   34.61% Capital Outlay ‐                              40,000                       ‐                               ‐                              40,000                   0.00% TOTAL EXPENDITURES 17,100                   97,674                      17,780                   680                        79,894                   18.20% Transfers In ‐                              40,000                       ‐                               ‐                               ‐                              0.00% NET TRANSFERS ‐                              40,000                       ‐                               ‐                               ‐                              0.00% CHANGE IN FUND BALANCE 27,214                    ‐                                  20,959                   (6,254)                    20,959                   N/A BEGINNING FUND BALANCE, Jan 1 603,760                677,710                    677,710                73,950                    ‐                              100.00% ENDING FUND BALANCE, Jun 30 630,974$              677,710$                  698,669$              67,695$                20,959$                103.09% CABLE COMMUNICATIONS VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 17 of 43   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.        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.         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,778                      ‐                                 745                        (1,033)                    745                        N/A TOTAL REVENUES 1,778                     24,200                      24,945                   23,167                   745                        103.08% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                                  ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 1,778                     24,200                      24,945                   23,167                   745                        103.08% BEGINNING FUND BALANCE, Jan 1 345,658                348,826                   348,826                3,168                      ‐                              100.00% ENDING FUND BALANCE, Jun 30 347,436$              373,026$                 373,771$              26,335$                745$                      100.20% SPRINGBROOK WETLANDS VARIANCE FAVORABLE (UNFAVORABLE) 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 704                         ‐                                 1,681                     977                        1,681                     N/A TOTAL REVENUES 704                         ‐                                 9,799                     9,095                     9,799                     N/A EXPENDITURES: Supplies ‐                              872,449                   21,771                   21,771                   850,678                2.50% Contracted Services 862                         ‐                                 24,983                   24,121                   (24,983)                 N/A Capital Outlay ‐                               ‐                                 84,404                   84,404                   (84,404)                 N/A TOTAL EXPENDITURES 862                        872,449                   131,158                130,296                741,291                15.03% NET TRANSFERS 671,102                 ‐                                  ‐                              (671,102)                ‐                              N/A CHANGE IN FUND BALANCE 670,944                (872,449)                  (121,359)               (792,303)               751,090                N/A BEGINNING FUND BALANCE, Jan 1 ‐                              872,449                   872,449                872,449                 ‐                              100.00% ENDING FUND BALANCE, Jun 30 670,944$               ‐$                               751,090$              80,146$                751,090$              N/A POLICE SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 18 of 43   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: Fines and penalties ‐$                             ‐$                               18,948$                18,948$                18,948$                N/A Investment Earnings 132                         ‐                                 328                        196                        328                        N/A TOTAL REVENUES 132                         ‐                                 19,276                   19,144                   19,276                   N/A EXPENDITURES: Contracted Services ‐                              150,637                    ‐                               ‐                              (150,637)               0.00% TOTAL EXPENDITURES ‐                              150,637                    ‐                               ‐                              150,637                0.00% NET TRANSFERS 126,011                 ‐                                  ‐                              (126,011)                ‐                              N/A CHANGE IN FUND BALANCE 126,143                (150,637)                  19,276                   (106,867)               169,913                N/A BEGINNING FUND BALANCE, Jan 1 ‐                              150,637                   150,637                150,637                 ‐                              100.00% ENDING FUND BALANCE, Jun 30 126,143$               ‐$                               169,913$              43,770$                169,913$              N/A POLICE CSAM SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 19 of 43   CAPITAL PROJECT FUNDS  Capital project funds are used to account for the acquisition and construction of major capital facilities and equipment. YTD  budgets are not prepared for capital project funds. Project budgets are adopted when funding is secured, and balances are  carried forward each year until they are either 1) fully spent or 2) reallocated to another project through the budget  adjustment process.    Community Services Impact Mitigation Fund  This fund accounts for park impact fees collected from developers as authorized under RCW 82.02.050‐.110. These fees are  used to help offset the cost of system improvements necessary to service the new development. Impact fees are held in this  fund and subsequently transferred to the Municipal Facilities CIP Fund when qualifying capital projects are budgeted.        Fire Impact Mitigation Fund  This fund accounts for fire impact fees collected from developers as authorized under RCW 82.02.050‐.110. These fees are  used to offset the cost of system improvements necessary to serve the new development. Impact fees are held in this fund  and subsequently transferred to the debt service fund to support the debt service on fire station 13. Once the debt on the  fire station is repaid, the remaining collections will be disbursed to the Renton Regional Fire Authority for use on qualifying  capital projects.       2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 334,963$              86,500$                  164,590$              (170,373)$             78,090$                190.28% Investment Earnings 10,872                    ‐                                3,939                     (6,933)                    3,939                     N/A TOTAL REVENUES 345,835                86,500                     168,529                (177,305)               82,029                   194.83% TOTAL EXPENDITURES ‐                               ‐                                 ‐                               ‐                               ‐                              N/A Transfers In ‐                              1,484,964                ‐                               ‐                               ‐                              0.00% Transfers Out ‐                              2,080,328                ‐                               ‐                              2,080,328             0.00% NET TRANSFERS ‐                              (595,364)                  ‐                               ‐                              595,364                0.00% CHANGE IN FUND BALANCE 345,835                (508,864)                 168,529                (177,306)               677,393                 ‐33.12% BEGINNING FUND BALANCE, Jan 1 1,886,999             1,713,833               1,713,833             (173,166)                ‐                              100.00% ENDING FUND BALANCE, Jun 30 2,232,834$           1,204,969$             1,882,362$           (350,472)$             677,393$              156.22% 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 81,198$                99,000$                  169,036$              87,838$                70,036$                170.74% Investment Earnings 11,143                    ‐                                4,547                     (6,596)                    4,547                     N/A TOTAL REVENUES 92,341                   99,000                     173,583                81,242                   74,583                   175.34% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                 ‐                               ‐                               ‐                              N/A Transfers Out ‐                              436,987                   ‐                               ‐                              436,987                0.00% NET TRANSFERS ‐                              (436,987)                  ‐                               ‐                              436,987                0.00% CHANGE IN FUND BALANCE 92,341                   (337,987)                 173,583                81,242                   511,570                 ‐51.36% BEGINNING FUND BALANCE, Jan 1 2,120,558             2,191,452               2,191,452             70,894                    ‐                              100.00% ENDING FUND BALANCE, Jun 30 2,212,899$           1,853,465$             2,365,035$           152,136$              511,570$              127.60% FIRE IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 20 of 43   Transportation Impact Mitigation Fund  This fund accounts for transportation impact fees collected from developers as authorized under RCW 82.02.050‐.110. These  fees are used to offset the cost of system improvements necessary to serve the new development. Impact fees are held in  this fund and subsequently transferred to the Capital Improvement Fund when qualifying projects are budgeted.        REET 1 Fund  This fund was established in the 2nd quarter of 2020 to account for the first quarter percent of real estate excise tax (REET)  levied in accordance with RCW 82.46.010. The tax may be used for eligible capital projects, as defined in RCW.82.46.010(6),  that are included in the capital facilities element of the City’s comprehensive plan. REET 1 tax revenues are held in this fund  and subsequently transferred to the appropriate capital project fund when qualifying projects are budgeted.           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 729,530$              200,000$                 1,291,265$           561,735$              1,091,265$           645.63% Investment Earnings 17,583                    ‐                                 7,245                     (10,338)                 7,245                     N/A TOTAL REVENUES 747,113                200,000                    1,298,510             551,397                1,098,510             649.26% TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A Transfers Out ‐                              172,869                     ‐                               ‐                              172,869                0.00% NET TRANSFERS ‐                              (172,869)                   ‐                               ‐                              172,869                0.00% CHANGE IN FUND BALANCE 747,113                27,131                      1,298,510             551,397                1,271,379             N/A BEGINNING FUND BALANCE, Jan 1 2,942,344             3,154,954                3,154,954             212,610                 ‐                              100.00% ENDING FUND BALANCE, Jun 30 3,689,457$           3,182,085$              4,453,464$           764,007$              1,271,379$           139.95% TRANSPORTATION IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 1,271,842$           2,250,000$              2,111,656$           839,814$              (138,344)$             93.85% Investment Earnings 2,244                      ‐                                 5,943                     3,699                     5,943                     N/A TOTAL REVENUES 1,274,086             2,250,000                2,117,599             843,513                (132,401)               94.12% TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A Transfers In 1,143,855              ‐                                  ‐                              (1,143,855)             ‐                              N/A Transfers Out ‐                              2,865,000                 ‐                               ‐                              2,865,000             0.00% NET TRANSFERS 1,143,855             (2,865,000)                ‐                              (1,143,855)            2,865,000             0.00% CHANGE IN FUND BALANCE 2,417,941             (615,000)                  2,117,599             (300,342)               2,732,599              ‐344.33% BEGINNING FUND BALANCE, Jan 1 ‐                              2,042,269                2,042,269             2,042,269              ‐                              100.00% ENDING FUND BALANCE, Jun 30 2,417,941$           1,427,269$              4,159,868$           1,741,927$           2,732,599$           291.46% REET 1 VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 21 of 43   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 1,271,842$           2,250,000$              2,111,656$           839,814$              (138,344)$             93.85% Investment Earnings 2,244                      ‐                                 8,405                     6,161                     8,405                     N/A TOTAL REVENUES 1,274,086             2,250,000                2,120,061             845,976                (129,939)               94.22% TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A Transfers In 1,143,855             3,177,680                 ‐                              (1,143,855)            (3,177,680)            0.00% Transfers Out ‐                              7,066,705                 ‐                               ‐                              7,066,705             0.00% NET TRANSFERS 1,143,855             (3,889,025)                ‐                              (1,143,855)            3,889,025             0.00% CHANGE IN FUND BALANCE 2,417,941             (1,639,025)               2,120,061             (297,880)               3,759,086              ‐129.35% BEGINNING FUND BALANCE, Jan 1 ‐                              3,411,866                3,411,866             3,411,866              ‐                              100.00% ENDING FUND BALANCE, Jun 30 2,417,941$           1,772,841$              5,531,927$           3,113,986$           3,759,086$           312.04% REET 2 VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 22 of 43   Municipal Facilities CIP Fund  This fund accounts for general governmental facility construction, improvement, and renovation; property acquisitions for  parks and City space needs; parks development and equipment; and major maintenance of existing general governmental  assets. Transportation capital improvements are accounted for in a separate fund.        A listing of project budgets and balances at June 30 is provided on the following page. The budget for personnel costs is  included in the listing for ease of comparison to total expenditures shown in the table above, but personnel costs are not  considered projects and, therefore, any remaining budget would not be carried forward at the end of the year.        2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 522,438$              1,302,206$            815,534$              293,096$              (486,672)$             62.63% Charges for services 140                         ‐                               157,596                157,456                157,596                N/A Sale of general fixed assets 160,000                 ‐                               80,000                   (80,000)                 80,000                   N/A Investment Earnings 147,100                86,185                    45,185                   (101,915)               (41,000)                 52.43% TOTAL REVENUES 829,678                1,399,391              1,098,315             268,637                (301,076)               78.49% EXPENDITURES: Personnel 331,597                731,324                 276,812                (54,785)                 454,512                37.85% Contracted Services 102,974                130,384                 35,862                   (67,112)                 94,522                   27.50% Capital Outlay 3,991,443             23,889,853            1,229,184             (2,762,259)            22,660,669           5.15% TOTAL EXPENDITURES 4,426,014             24,751,561            1,541,858             (2,884,156)            23,209,703           6.23% Transfers In ‐                              7,899,008               ‐                               ‐                              (7,899,008)            0.00% Transfers Out ‐                              4,669,729               ‐                               ‐                              4,669,729             0.00% NET TRANSFERS ‐                              3,229,279               ‐                               ‐                              (12,568,737)         0.00% CHANGE IN FUND BALANCE (3,596,336)            (20,122,891)          (443,543)               3,152,793             19,679,348           2.20% BEGINNING FUND BALANCE, Jan 1 26,395,567           20,298,663            20,298,663           (6,096,904)             ‐                              100.00% ENDING FUND BALANCE, Jun 30 22,799,231$        175,772$               19,855,120$        (2,944,111)$         19,679,348$        11295.95% MUNICIPAL FACILITIES CIP VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 23 of 43   Municipal Facilities CIP Fund (continued)             PROJECT BUDGET ACTUAL BALANCE CAPITAL PROJECT COORDINATORS 731,324$ 276,812$ 454,512$ REPAIRS AND MAINTENANCE - 17,057 (17,057) SUNSET NEIGHBORHOOD PARK ART 86,856 10,200 76,656 CITY HALL ELEVATORS 1,465,583 442,456 1,023,127 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 407,985 2,221,303 RCC AUDIO AND VIDEO SYSTEMS 56,000 - 56,000 CITY HALL - REMODEL 10,000 674 9,326 CITY HALL - 7TH FLOOR REMODEL 10,000 368 9,632 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 60,968 154,032 PARKING LOT AND DRIVEWAY REPAIRS 90,000 - 90,000 URBAN FORESTRY PROGRAM 103,348 11,769 91,579 PARKS MM - PLAYGRDS, KIOSKS & INT SIGNS 325,000 - 325,000 PARKS MM - STRUCTURAL REVIEWS & REPAIRS 11,915 11,915 - SUNSET EIS PARK 84,010 58,152 25,858 COULON PARK STRUCTURAL IMPROVEMENTS 150 150 - COULON PARK TURF REPLACEMENT 50,788 - 50,788 COULON SWIM BEACH 100,000 - 100,000 LIBERTY PARK IMPROVEMENTS 525,852 - 525,852 TRANSPORTATION LANDSCAPE 90,000 - 90,000 PHILIP ARNOLD PARK IMPROVEMENTS 5,951,133 61,785 5,889,348 KIWANIS PARK 6,062,100 24,743 6,037,357 COULON - WATERWALK 3,481,270 99,821 3,381,449 COULON - TRESTLE BRIDGE 1,497,854 44,699 1,453,155 COULON - ROSEWALL REPAIRS & MAINTENANCE 10,000 - 10,000 MAY CREEK TRAIL SOUTH 250,000 - 250,000 PARKS AVE N ACQUISITION 10,000 - 10,000 TOTAL PROJECT BALANCES 24,751,561$ 1,541,858$ 23,209,703$ MUNICIPAL FACILITIES CIP PROJECT BUDGETS AT JUNE 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 24 of 43   Capital Improvement Fund  This fund accounts for the City’s Transportation capital projects.         A listing of project budgets and balances at June 30 is provided on the following page.      2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 880,701$              28,258,159$        4,903,791$           4,023,090$           (23,354,368)$       17.35% Charges for services 250,000                 ‐                               ‐                              (250,000)                ‐                              N/A Fines and penalties 9,012                      ‐                              22,801                   13,789                   22,801                   N/A Investment Earnings 96,183                    ‐                              34,742                   (61,441)                 34,742                   N/A TOTAL REVENUES 1,235,896             28,258,159           4,961,334             3,725,438             (23,296,825)         17.56% EXPENDITURES: Personnel 53,386                   56,000                   31,407                   (21,979)                 24,593                   56.08% Supplies 104,071                40,000                   1,670                     (102,401)               38,330                   4.18% Contracted Services 84,351                   53,684                   31,953                   (52,398)                 21,731                   59.52% Capital Outlay 2,080,070             45,270,908           6,008,584             3,928,514             39,262,324           13.27% TOTAL EXPENDITURES 2,321,878             45,420,592           6,073,614             3,751,736             39,346,978           13.37% Transfers In 0                             2,172,869              ‐                              (0)                            (2,172,869)            0.00% NET TRANSFERS ‐                              2,172,869              ‐                               ‐                              (2,172,869)            0.00% CHANGE IN FUND BALANCE (1,085,982)            (14,989,564)         (1,112,280)            (26,298)                 13,877,284           N/A BEGINNING FUND BALANCE, Jan 1 18,947,853           16,792,413           16,792,413           (2,155,440)             ‐                              100.00% ENDING FUND BALANCE, Jun 30 17,861,871$        1,802,849$           15,680,133$        (2,181,738)$         13,877,284$        869.74% CAPITAL IMPROVEMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 25 of 43   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 28,204 51,360 BRIDGE INSPECTION & REPAIR 245,909 17,863 228,046 ROADWAY SAFETY & GUARDRAIL 89,407 - 89,407 CATCH BASIN REPAIR 250,000 - 250,000 RENTON CONNECTOR 1,747,812 1,388 1,746,424 STREET OVERLAY PGM 1,465,902 16,410 1,449,492 TRAFFIC SAFETY PGM 117,808 3,144 114,664 PROJ DEV & PRE-DESIGN 186,201 - 186,201 SO 7TH ST 835,000 - 835,000 ITS PGM 86,128 - 86,128 RENTON AVE EXT PRES 40,920 28,633 12,287 PARK AVE EXTENSION 7,394,795 784,741 6,610,054 RAINIER AVE S/N PHASE 4 4,568,763 320,925 4,247,838 INTERSECT SAFETY & MOBILITY 355,610 1,491 354,119 NE 31ST ST BRIDGE REPLACEMENT 248,046 22,176 225,870 N 27TH PL CULVERT SCOUR REPAIR 66,622 32,128 34,494 DUVALL AVE 7TH TO SUNSET 6,499,523 54,875 6,444,648 BARRIER FREE 113,883 42,465 71,418 SIDEWALK REHAB 100,000 - 100,000 LAKE WASHINGTON LOOP TRAIL 2,569,361 397,008 2,172,353 HIGHLANDS TO LANDING 422,490 133,006 289,484 SUNSET BLVD CORRIDOR 4,421,053 31,202 4,389,851 PRES OF TOD 173,497 40,368 133,129 WILLIAMS AVE S & WELLS AVE S CONV 6,495,074 3,373,217 3,121,857 ARTERIAL REHAB - SW 43RD 1,169,960 - 1,169,960 BRONSON BRIDGE 463,766 23,802 439,964 HOUSER WAY N BRIDGE 531,247 3,645 527,602 WILLIAMS BRIDGE 649,992 3,645 646,347 S 2ND STREET CONVERSION 1,545,494 1,265 1,544,229 HOUSER WAY INT & PED IMP 730,465 14,504 715,961 RENTON SCHOOL CROSSINGS 688,384 276,934 411,450 SAFE ROUTES TO TRANSIT 763,592 393,980 369,612 SOUND TRANSIT NE 44TH STREET 25,000 14,505 10,495 TOTAL PROJECT BALANCES 45,420,592$ 6,073,614$ 39,346,978$ Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 26 of 43   New Library Development Fund  This fund was used to account for the construction of the new Highlands Library and the renovation of the Cedar River Library.  The fund is no longer needed as the library construction projects were complete in 2016. The fund has been closed and the  remaining fund balance was transferred to the General Fund.        Family First Center Fund  This fund is used to account for the construction of the new Family First Center. Funds accumulated for the construction of  the Family First Center are maintained in the fund balance until such time that Council authorizes their use through the  approval of contracts and additional project budget is established through the budget adjustment process.        Capital Outlay – The decrease in capital outlay from the prior year is due to timing of project costs within the overall project.     Note ‐ Additional funds designated for the Family First Center are being held in a fund with the Renton Community Foundation  (Foundation). Those funds are not reflected in the City’s records as they are assets of the Foundation, not the City. The City  must apply to the Foundation to receive the funds. Funds transferred from the Foundation will be recorded as contribution  revenue when received by the City.    2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 259$                       ‐$                             ‐$                            (259)$                      ‐$                            N/A TOTAL REVENUES 259                         ‐                               ‐                              (259)                        ‐                              N/A TOTAL EXPENDITURES ‐                               ‐                               ‐                               ‐                               ‐                              N/A Transfers Out ‐                              16,679                   16,679                   16,679                    ‐                              100.00% NET TRANSFERS ‐                              (16,679)                 (16,679)                 (16,679)                  ‐                              N/A CHANGE IN FUND BALANCE 259                        (16,679)                 (16,679)                 (16,938)                  ‐                              N/A BEGINNING FUND BALANCE, Jan 1 16,408                   16,679                   16,679                   271                         ‐                              100.00% ENDING FUND BALANCE, Jun 30 16,667$                 ‐$                             ‐$                            (16,667)$                ‐$                            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 43,113                    ‐                              17,234                   (25,879)                 17,234                   N/A TOTAL REVENUES 43,113                   75,000                   17,234                   (25,879)                 (57,766)                 22.98% EXPENDITURES: Contracted Services ‐                               ‐                              2,904                     2,904                     (2,904)                    N/A Capital Outlay 232,728                872,775                49,758                   (182,970)               823,017                5.70% TOTAL EXPENDITURES 232,728                872,775                52,662                   (180,066)               820,113                6.03% NET TRANSFERS ‐                               ‐                               ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE (189,615)               (797,775)               (35,428)                 154,187                762,347                N/A BEGINNING FUND BALANCE, Jan 1 8,551,401             8,356,704             8,356,704             (194,697)                ‐                              100.00% ENDING FUND BALANCE, Jun 30 8,361,786$           7,558,929$           8,321,276$           (40,510)$               762,347$              110.09% FAMILY FIRST CENTER VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 27 of 43   ENTERPRISE FUNDS  Enterprise funds are used to account for operations that are financed and operated in a manner similar to private business  enterprises. YTD budgets are not prepared for Enterprise Funds.     Most Enterprise Funds maintain two separate “management funds”, an operating fund and a capital fund. The funds are  consolidated for budget/reporting purposes. Operating budgets lapse at the end of the year. Project budgets are adopted  when funding is secured, and balances are carried forward each year until they are either 1) fully spent or 2) reallocated to  another project through the budget adjustment process. A listing of project balances for each Enterprise Fund is included,  along with a reconciliation to the amounts reported as “Capital 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 June 30 is provided on the following page.   2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 38,152$           145,557$                38,529$           377$                 (107,028)$        26.47% Rents, leases, and misc fees 1,456,675        2,902,353               1,612,042        155,367           (1,290,311)       55.54% Interest and other misc 33,460              4,857                       17,135              (16,325)            12,278              352.79% TOTAL REVENUES 1,528,287        3,109,929               1,667,706        139,419           (1,442,223)       53.63% EXPENSES: Personnel 480,207           1,322,337               531,374           (51,167)            790,963           40.18% Supplies 18,425              35,630                    10,069              8,356                25,561              28.26% Contracted Services 198,523           1,084,312               182,987           15,536              901,325           16.88% Internal Services 164,582           398,964                  199,228           (34,646)            199,736           49.94% TOTAL OPERATING EXPENSES 861,737           2,841,243               923,658           (61,921)            1,917,585        32.51% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 666,550           268,686                  744,048           77,498              475,362           276.92% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 161,865           6,524,125               255,671           (93,806)            6,268,454        3.92% TRANSFERS OUT 1,363                 ‐                                 ‐                         1,363                 ‐                         N/A NET TRANSFERS (1,363)                ‐                                 ‐                         1,363                 ‐                         N/A CHANGE IN FUND BALANCE 503,322           (6,255,439)             488,377           (14,945)            6,743,816        N/A BEGINNING FUND BALANCE, Jan 1 6,259,402        7,558,405               7,558,405        1,299,003         ‐                         100.00% ENDING FUND BALANCE, Jun 30 6,762,724$      1,302,966$            8,046,782$      1,284,058$      6,743,816$      617.57% Operating Reserve 190,480           223,124                  223,124            AVAILABLE FUND BALANCE 6,572,244$      1,079,842$            7,823,658$       VARIANCE AIRPORT Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 28 of 43   Airport Fund (continued)        Solid Waste Fund  This fund accounts for revenues and expenses for administration and operating of solid waste, recycling, and yard waste  collection services for the City.         Capital Outlay ‐ The Solid Waste Fund does not have a capital fund.   PROJECT BUDGET ACTUAL BALANCE MAINTENANCE DREDGING & SHORELINE MITIGAT 163,000$ 27,789$ 135,211$ AIRPORT OFFICE REHAB 2,718,316 - 2,718,316 MAJOR FACILITY MAINTENANCE 511,135 168,185 342,950 SURFACE WATER SYSTEM REHABILITATION 94,496 - 94,496 PAVEMENT MANAGEMENT PROGRAM 805,930 61,802 744,128 SNOW REMOVAL EQUIPMENT 167,000 - 167,000 MASTER PLAN UPDATE 182,394 5,265 177,129 TAXIWAY ALPHA REHABILITATION 1,317,495 - 1,317,495 RUNWAY SAFETY AREA 774,359 - 774,359 ENVIRONMENTAL IMPACT STUDY 400,000 - 400,000 TOTAL PROJECT BALANCES 7,134,125$ 263,041$ 6,871,084$ Non-capital items included in project budgets (610,000) (7,370) (602,630) Operating fund equipment purchase - - - TOTAL CAPITAL OUTLAY 6,524,125$ 255,671$ 6,268,454$ AIRPORT PROJECT BALANCES AT JUNE 30, 2021 2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 89,664$           313,136$                69,496$           (20,168)$          (243,640)$        22.19% Charges for services 10,393,666      22,636,386            8,792,529        (1,601,137)       (13,843,857)    38.84% Interest and other misc 16,160              5,000                       5,712                (10,448)            712                   114.24% TOTAL REVENUES 10,499,490      22,954,522            8,867,737        (1,631,753)       (14,086,785)    38.63% EXPENSES: Personnel 292,151           727,085                  252,805           39,346              474,280           34.77% Supplies 3,252                11,900                    471                   2,781                11,429              3.96% Contracted Services 8,882,553        21,855,539            8,112,554        769,999           13,742,985      37.12% Internal Services 252,280           307,806                  159,641           92,639              148,165           51.86% TOTAL OPERATING EXPENSES 9,430,236        22,902,330            8,525,471        904,765           14,376,859      37.23% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,069,254        52,192                    342,266           (726,988)          290,074           655.79% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 1,069,254        52,192                    342,266           (726,988)          290,074           655.78% BEGINNING FUND BALANCE, Jan 1 2,266,127        2,771,562               2,771,562        505,435            ‐                         100.00% ENDING FUND BALANCE, Jun 30 3,335,381$      2,823,754$            3,113,828$      (221,553)$        290,074$         110.27% Operating Reserve 400,000           400,000                  400,000            AVAILABLE FUND BALANCE 2,935,381$      2,423,754$            2,713,828$       SOLID WASTE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 29 of 43   Golf Course Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Maplewood Golf Course.         Capital Outlay – A listing of project budgets and balances at June 30 is as follows:           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 865,395$         2,304,205$            1,392,910$      527,515$         (911,295)$        60.45% Rents, leases, and misc fees 127,900           527,600                  162,057           34,157              (365,543)          30.72% Interest and other misc 1,977                226,679                  2,196                219                   (224,483)          0.97% TOTAL REVENUES 995,272           3,058,484               1,557,163        561,891           (1,501,321)       50.91% EXPENSES: Personnel 672,654           1,673,092               744,799           (72,145)            928,293           44.52% Supplies 159,956           321,500                  185,817           (25,861)            135,683           57.80% Contracted Services 81,711              176,150                  83,706              (1,995)               92,444              47.52% Internal Services 176,281           350,457                  175,129           1,152                175,328           49.97% TOTAL OPERATING EXPENSES 1,090,602        2,521,199               1,189,451        (98,849)            1,331,748        47.18% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (95,330)            537,285                  367,712           463,042           (169,573)          68.44% TOTAL DEBT SERVICE ‐                         30,811                     ‐                         ‐                         30,811              0.00% CAPITAL OUTLAY ‐                         270,309                  12,662              (12,662)            257,647           4.68% TRANSFERS IN 38,000              68,100                    34,050              (3,950)               (34,050)            50.00% TRANSFERS OUT 40,695              68,100                    34,050              6,645                34,050              50.00% NET TRANSFERS (2,695)                ‐                                 ‐                         2,695                 ‐                         N/A CHANGE IN FUND BALANCE (98,025)            236,165                  355,050           453,075           118,885           150.34% BEGINNING FUND BALANCE, Jan 1 173,750           476,746                  476,746           302,996            ‐                         100.00% ENDING FUND BALANCE, Jun 30 75,725$           712,911$                831,796$         756,071$         118,885$         116.68% Operating Reserve 585,769           641,500                  641,500            AVAILABLE FUND BALANCE (510,044)$        71,411$                  190,296$          GOLF COURSE VARIANCE PROJECT BUDGET ACTUAL BALANCE MACHINERY & EQUIPMENT 250,309$ -$ 250,309$ GOLF MM COURSE - MAINTENANCE 43,100 - 43,100 TOTAL PROJECT BALANCES 293,409$ -$ 293,409$ Non-capital items included in project budgets (43,100) - (43,100) Operating fund equipment purchase 20,000 12,662 7,338 TOTAL CAPITAL OUTLAY 270,309$ 12,662$ 257,647$ GOLF PROJECT BALANCES AT JUNE 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 30 of 43   Water Utility Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the City’s water utility.        Capital Outlay ‐ A listing of project budgets and balances at June 30 is provided on the following page.     2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 7,427,277$      17,314,812$          7,841,786$      414,509$         (9,473,026)$    45.29% Rents, leases, and misc fees 84,059              136,591                  92,910              8,851                (43,681)            68.02% Interest and other misc 485,804           521,000                  408,901           (76,903)            (112,099)          78.48% TOTAL REVENUES 7,997,140        17,972,403            8,343,597        346,457           (9,628,806)       46.42% EXPENSES: Personnel 2,157,864        4,753,110               2,308,320        (150,456)          2,444,790        48.56% Supplies 341,899           885,590                  401,156           (59,257)            484,434           45.30% Contracted Services 1,420,775        3,293,552               1,410,782        9,993                1,882,770        42.83% Internal Services 1,107,657        2,710,733               1,343,198        (235,541)          1,367,535        49.55% TOTAL OPERATING EXPENSES 5,028,195        11,642,985            5,463,456        (435,261)          6,179,529        46.92% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 2,968,945        6,329,418               2,880,141        (88,804)            (3,449,277)       45.50% DEBT SERVICE: Principal 345,818           1,563,068               345,818            ‐                         1,217,250        22.12% Interest 105,595           216,506                  98,375              7,220                118,131           45.44% TOTAL DEBT SERVICE 451,413           1,779,574               444,193           7,220                1,335,381        24.96% CAPITAL OUTLAY 1,703,057        35,563,246            1,969,673        (266,616)          33,593,573      5.54% TRANSFERS OUT 330                    ‐                                 ‐                         330                    ‐                         N/A NET TRANSFERS (330)                   ‐                                 ‐                         330                    ‐                         N/A CHANGE IN FUND BALANCE 814,145           (31,013,402)           466,275           (347,870)          31,479,677      N/A BEGINNING FUND BALANCE, Jan 1 37,569,067      40,776,314            40,776,314      3,207,247         ‐                         100.00% ENDING FUND BALANCE, Jun 30 38,383,212$   9,762,912$            41,242,589$   2,859,377$      31,479,677$   422.44% Restricted for Debt Service 1,394,050        1,394,050               1,394,050         Operating Reserve 3,072,760        1,614,304               1,614,304         AVAILABLE FUND BALANCE 33,916,402$   6,754,558$            38,234,235$    WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 31 of 43   Water Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE PIPE OVERSIZING COSTS 100,000$ -$ 100,000$ TELEMETRY IMPROVEMENTS-PHASE 4 227,965 4,796 223,169 WATER SYSTEM PLAN UPDATE 334,254 40,779 293,475 UPDATE EMERGENCY RESPONSE PLAN 221,490 12,953 208,537 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 1,026,370 2,283,243 WATER PUMP STATIONS REHAB 400,000 5,640 394,360 RESERVOIR PRV METERS 337,235 9,983 327,252 MPLWD WATER TREATMENT IMPROV - CONST 715,241 1,924 713,317 HIGHLANDS WATER MAIN IMPROVEMENT 1,078,738 346,101 732,637 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 338 536,472 AUTOMATIC METER READING CONVERSION 196,115 - 196,115 HIGHLANDS 435-RESERVOIRS REPLACEMENT 23,065,776 54,046 23,011,730 RAINIER AVE S ROAD & UTILITIES IMPRVMNT 300,000 - 300,000 KENNYDALE 320-RESERVOIR 1,390,842 510,587 880,255 BRONSN/HOUSR/WILLIAM BRIDGES WTRMAINREPL 200,000 - 200,000 TOTAL PROJECT BALANCES 35,533,283$ 2,015,710$ 33,517,573$ Non-capital items included in project budgets - (46,037) 46,037 Operating fund equipment purchase 29,963 - 29,963 TOTAL CAPITAL OUTLAY 35,563,246$ 1,969,673$ 33,593,573$ WATER UTILITY FUND PROJECT BALANCES AT JUNE 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 32 of 43   Wastewater Utility Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the City’s wastewater utility.        Capital Outlay ‐ A listing of project budgets and balances at June 30 is provided on the following page.   2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 48,275$           62,111$                  36,375$           (11,900)$          (25,736)$          58.56% Charges for services 5,366,799        11,280,375            5,455,571        88,772              (5,824,804)       48.36% Fines and penalties 155                    ‐                                1,439                1,284                1,439                N/A Interest and other misc 333,293           444,000                  456,735           123,442           12,735              102.87% TOTAL REVENUES 5,748,522        11,786,486            5,950,120        201,598           (5,836,366)       50.48% EXPENSES: Personnel 1,145,636        2,651,185               1,119,834        25,802              1,531,351        42.24% Supplies 28,002              73,842                    47,122              (19,120)            26,720              63.81% Contracted Services 975,116           2,992,529               1,044,710        (69,594)            1,947,819        34.91% Internal Services 784,138           1,967,843               1,003,121        (218,983)          964,722           50.98% TOTAL OPERATING EXPENSES 2,932,892        7,685,399               3,214,787        (281,895)          4,470,612        41.83% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 2,815,630        4,101,087               2,735,333        (80,297)            (1,365,754)       66.70% DEBT SERVICE: Principal ‐                         612,850                   ‐                          ‐                         612,850           0.00% Interest 45,398              97,301                    42,551              2,847                54,750              43.73% TOTAL DEBT SERVICE 45,398              710,151                  42,551              2,847                667,600           5.99% CAPITAL OUTLAY 301,238           20,241,883            1,981,361        (1,680,123)       18,260,522      9.79% NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 2,468,994        (16,850,947)           711,421           (1,757,573)       17,562,368      N/A BEGINNING FUND BALANCE, Jan 1 19,832,351      23,996,217            23,996,217      4,163,866         ‐                         100.00% ENDING FUND BALANCE, Jun 30 22,301,345$   7,145,270$            24,707,638$   2,406,293$      17,562,368$   345.79% Restricted for Debt Service 661,227           661,227                  661,227            Operating Reserve 1,489,966        914,224                  914,224            AVAILABLE FUND BALANCE 20,150,152$   5,569,819$            23,132,187$    WASTEWATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 33 of 43   Wastewater Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE MISCELANEOUS SEWER PROJECTS 379,419$ 461$ 378,958$ 2008 LONG-RANGE WW MANAG PLAN 62,597 58,928 3,669 WASTEWATER OPERATIONS MASTER PLAN 724,622 467 724,155 FALCON RIDGE LS REHAB - - - THUNDER HILL INT REPL/REHAB 3,074,074 35,552 3,038,522 FORCE MAIN REHABILITATION REPLACEMENT 1,883,308 15,016 1,868,292 LIFT STATION REHABILITATION 1,879,795 15,709 1,864,086 DOWNTOWN SEWER REPLACEMENT/REHAB 7,192,313 1,682,634 5,509,679 2019 SANITARY SEWER REHAB/REPLACEMENT - - - 2020 SANITARY SEWER REHAB/REPLACEMENT - - - KENNYDALE LAKELINE SEWER UPGRADE 3,344,460 201,050 3,143,410 SANITARY SEWER REHAB/REPLACEMENT 2,478,314 6,528 2,471,786 TOTAL PROJECT BALANCES 21,018,902$ 2,016,345$ 19,002,557$ Non-capital items included in project budgets (787,219) (34,984) (752,235) Operating fund equipment purchase 10,200 - 10,200 TOTAL CAPITAL OUTLAY 20,241,883$ 1,981,361$ 18,260,522$ WASTEWATER UTILITY FUND PROJECT BALANCES AT JUNE 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 34 of 43   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 8,416,524$      17,607,838$          8,571,287$      154,763$         (9,036,551)$    48.68% Interest and other misc 32,451               ‐                                9,219                (23,232)            9,219                N/A TOTAL REVENUES 8,448,975        17,607,838            8,580,506        131,531           (9,027,332)       48.73% EXPENSES: Contracted Services 9,525,536        17,607,838            8,699,340        826,196           8,908,498        49.41% TOTAL OPERATING EXPENSES 9,525,536        17,607,838            8,699,340        826,196           8,908,498        49.41% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (1,076,561)        ‐                                (118,834)          957,727           (118,834)          N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE (1,076,561)        ‐                                (118,834)          957,727           (118,834)          N/A BEGINNING FUND BALANCE, Jan 1 5,961,906        4,729,749               4,729,749        (1,232,157)        ‐                         100.00% ENDING FUND BALANCE, Jun 30 4,885,345$      4,729,749$            4,610,915$      (274,430)$        (118,834)$        97.49% Operating Reserve 380,000           380,000                  380,000            AVAILABLE FUND BALANCE 4,505,345$      4,349,749$            4,230,915$       KING COUNTY METRO VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 35 of 43   Surface Water Utility Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the City’s surface water utility.        Capital Outlay ‐ A listing of project budgets and balances at June 30 is provided on the following page.     2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 35,225$           50,708$                  16,125$           (19,100)$          (34,583)$          31.80% Grants / intergovernmental 642,014           11,515,800            719,282           77,268              (10,796,518)    6.25% Charges for services 5,907,533        12,101,509            6,380,972        473,439           (5,720,537)       52.73% Interest and other misc 238,321           609,250                  380,867           142,546           (228,383)          62.51% TOTAL REVENUES 6,823,093        24,277,267            7,497,246        674,153           (16,780,021)    30.88% EXPENSES: Personnel 1,796,117        3,730,881               1,883,585        (87,468)            1,847,296        50.49% Supplies 58,558              175,848                  48,591              9,967                127,257           27.63% Contracted Services 867,617           4,251,356               878,894           (11,277)            3,372,462        20.67% Internal Services 955,142           2,651,030               1,347,036        (391,894)          1,303,994        50.81% TOTAL OPERATING EXPENSES 3,677,434        10,809,115            4,158,106        (480,672)          6,651,009        38.47% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 3,145,659        13,468,152            3,339,140        193,481           (10,129,012)    24.79% DEBT SERVICE: Principal ‐                         499,900                   ‐                          ‐                         499,900           0.00% Interest 313,768           630,950                  50,985              262,783           579,965           8.08% TOTAL DEBT SERVICE 313,768           1,130,850               50,985              262,783           1,079,865        4.51% CAPITAL OUTLAY 774,712           19,699,466            2,634,633        (1,859,921)       17,064,833      13.37% Transfers Out ‐                         18,347                    18,347              (18,347)             ‐                         100.00% NET TRANSFERS ‐                         (18,347)                   (18,347)            (18,347)             ‐                         N/A CHANGE IN FUND BALANCE 2,057,179        (7,380,511)             635,175           (1,422,004)       8,015,686        N/A BEGINNING FUND BALANCE, Jan 1 18,377,556      21,610,356            21,610,356      3,232,800         ‐                         100.00% ENDING FUND BALANCE, Jun 30 20,434,735$   14,229,845$          22,245,531$   1,810,796$      8,015,686$      156.33% Restricted for Debt Service 754,868           754,868                  754,868            Operating Reserve 1,252,915        1,116,680               1,116,680         AVAILABLE FUND BALANCE 18,426,952$   12,358,297$          20,373,983$    SURFACE WATER UTILITY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 36 of 43   Surface Water Utility Fund (continued)         PROJECT BUDGET ACTUAL BALANCE COMP S&SW MGMT PLAN P&D 28,474$ 5,035$ 23,439$ SM DRAINAGE PROBLEMS 578,564 14,988 563,576 PANTHER CR WL MOSQUITO ABATEMENT 95,776 7,766 88,010 MADSEN CREEK SEDIMENT BASIN 121,675 5,327 116,348 SMALL DRAINAGE PROJ-MAPLEWOOD SEDIMENT 155,120 5,490 149,630 WETLAND MITIGATION BANK 109,586 18,775 90,811 ACOE 205 PROJECT 58,737 2,557 56,180 CEDAR RIVER GRAVEL REMOVAL 2,681,201 60,701 2,620,500 RENTON STORM WATER MANUAL 68,147 1,813 66,334 GREEN RIVER ECOSYSTEM STUDY 48,177 - 48,177 MISCELLANEOUS/EMERGENCY/STORM PROJECTS 100,000 - 100,000 SURFACE WATER UTILITY GIS 121,755 66,457 55,298 HARDIE AVE S UNDERPASS STORM SYSTEM IMPR 2,391 - 2,391 MONROE AVE/N 2ND ST 826,497 224,687 601,810 STORMWATER FACILITY FENCING PROJECT 262,200 8,620 253,580 CEDAR RIVER 205 LEVEE RECERTIFICATION 4,532,900 35,797 4,497,103 SE 172ND ST/125TH AVE SE 140,399 73,290 67,109 RAINIER AVE/OAKSDALE AVE PUMP STATION UP 147,121 21,673 125,448 NE 16TH/JEFFERSON AVE NE 2,623,430 560,627 2,062,803 DOWNTOWN STORM SYSTEM IMPROVEMENT PROJEC 5,705,777 1,505,701 4,200,076 HEATHER DOWNS DETENTION POND 786,921 15,347 771,574 MADSEN CRK IMPROV PHASE 1-KCFCD 843,598 57,734 785,864 RAINIER AVE/BENSON RD S - CULVERT REPL - - - CMP STORM SYSTEM REPLACEMENT PROJECT 559,038 41,577 517,461 CEDAR RIVER FLOOD RISK REDUCTION 491,545 6,074 485,471 STORMWATER FACILITY RETROFIT STUDY 271,810 120,366 151,444 BURNETT AVE S/WILLIAMS AVE S 495,797 77,848 417,949 WSDOT LA ROW RUNOFF IMPACT MITIGATION 145,471 38,364 107,107 SW 23RD ST DRAINAGE AND FISH PASSAGE IMP 350,000 - 350,000 TOTAL PROJECT BALANCES 22,352,107$ 2,976,614$ 19,375,493$ Non-capital items included in project budgets (2,681,201) (341,981) (2,339,220) Operating fund equipment purchase 28,560 - 28,560 TOTAL CAPITAL OUTLAY 19,699,466$ 2,634,633$ 17,064,833$ SURFACE WATER UTILITY PROJECT BALANCES AT JUNE 30, 2021 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 37 of 43   INTERNAL SERVICE FUNDS  Internal service funds are used to account for the goods and services furnished by one City department to other City  departments on a cost reimbursement basis. YTD budgets are not prepared for Internal Service Funds.    Equipment Rental Fund  This fund accounts for revenues and expenses for administration, purchase, and maintenance of the City’s vehicle and  equipment Fleet services. Departments pay in monthly amounts for maintenance and operations. Replacement reserves are  paid monthly over the estimated useful lives of each individual vehicle or piece of equipment. These reverses are accumulated  in fund balance so that they are available to fund the replacement of the vehicle/equipment when the time comes.            2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 17,118$            ‐$                             39,326$           22,208$           39,326$           N/A Interdepartmental services 2,184,394        6,451,395               3,264,164        1,079,770        (3,187,231)       50.60% Interest and other misc 36,155              12,000                    13,931              (22,224)            1,931                116.09% TOTAL REVENUES 2,237,667        6,463,395               3,317,421        1,079,754        (3,145,974)       51.33% EXPENSES: Personnel 546,371           1,206,146               536,982           9,389                669,164           44.52% Supplies 483,678           1,496,153               653,809           (170,131)          842,344           43.70% Contracted Services 122,174           133,166                  167,765           (45,591)            (34,599)            125.98% Internal Services 17,015              30,338                    16,969              46                      13,369              55.93% TOTAL OPERATING EXPENSES 1,169,238        2,865,803               1,375,525        (206,287)          1,490,278        48.00% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,068,429        3,597,592               1,941,896        873,467           (1,655,696)       53.98% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 925,942           2,423,743               253,304           672,638           2,170,439        10.45% NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 142,487           1,173,849               1,688,592        1,546,105        514,743           143.85% BEGINNING FUND BALANCE, Jan 1 6,851,811        6,376,259               6,376,259        (475,552)           ‐                         100.00% ENDING FUND BALANCE, Jun 30 6,994,298$      7,550,108$            8,064,851$      1,070,553$      514,743$         106.82% EQUIPMENT RENTAL VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 38 of 43   Insurance Fund  This fund accounts for the administration and operation of the City’s self‐insurance programs for property losses, liability,  workers’ compensation, and unemployment compensation. Expenses are paid by the Insurance Fund and rates are charged  to departments based on their claims history over the preceding five years and coverage requirements.           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 1,566,125$      3,511,775$            1,559,542$      (6,583)$            (1,952,233)$    44.41% Interest and other misc 112,256           22,000                    161,984           49,728              139,984           736.29% TOTAL REVENUES 1,678,381        3,533,775               1,721,526        43,145              (1,812,249)       48.72% EXPENSES: Personnel 466,215           1,411,787               578,481           (112,266)          833,306           40.98% Supplies 374                   6,956                       30                      344                   6,926                0.43% Contracted Services 826,477           2,279,772               1,216,330        (389,853)          1,063,442        53.35% Internal Services ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TOTAL OPERATING EXPENSES 1,293,066        3,698,515               1,794,841        (501,775)          1,903,674        48.53% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 385,315           (164,740)                 (73,315)            (458,630)          91,425              N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 385,315           (164,740)                 (73,315)            (458,630)          91,425              N/A BEGINNING FUND BALANCE, Jan 1 19,095,508      19,860,208            19,860,208      764,700            ‐                         100.00% ENDING FUND BALANCE, Jun 30 19,480,823$   19,695,468$          19,786,893$   306,070$         91,425$           100.46% Operating Reserves 16,479,631      17,708,251            17,708,251       AVAILABLE FUND BALANCE 3,001,192$      1,987,217$            2,078,642$       INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 39 of 43   Information Technology Fund  This fund accounts for the administration, purchase, and operation of the City’s information technology systems, including  computer hardware and software, network servers and infrastructure, phone systems, and cell phones. Expenses are paid by  the Information Technology Fund and rates are charged to departments based on use.            2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 123,004$         150,000$                99,490$           (23,514)$          (50,510)$          66.33% Interdepartmental services 2,894,507        6,435,901               3,217,950        323,443           (3,217,951)       50.00% Interest and other misc 25,253              7,000                       33,023              7,770                26,023              471.76% TOTAL REVENUES 3,042,764        6,592,901               3,350,463        307,699           (3,242,438)       50.82% EXPENSES: Personnel 1,488,031        3,292,443               1,426,796        61,235              1,865,647        43.34% Supplies 224,440           757,555                  205,389           19,051              552,166           27.11% Contracted Services 1,134,132        2,486,071               1,015,449        118,683           1,470,622        40.85% Internal Services 902                    ‐                                 ‐                         902                    ‐                         N/A TOTAL OPERATING EXPENSES 2,847,505        6,536,069               2,647,634        199,871           3,888,435        40.51% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 195,259           56,832                    702,829           507,570           645,997           1236.68% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 30,872              838,000                  94,904              (64,032)            743,096           11.33% TRANSFERS IN 12,433              21,477                    60,685              48,252              39,208              282.56% NET TRANSFERS 12,433              21,477                    60,685              48,252              39,208              282.56% CHANGE IN FUND BALANCE 176,820           (759,691)                 668,610           491,790           1,428,301        N/A BEGINNING FUND BALANCE, Jan 1 4,490,062        3,939,941               3,939,941        (550,121)           ‐                         100.00% ENDING FUND BALANCE, Jun 30 4,666,882$      3,180,250$            4,608,551$      (58,331)$          1,428,301$      144.91% INFORMATION TECHNOLOGY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 40 of 43   Facilities Fund  This fund accounts for the administration, maintenance, and operation of City‐owned facilities. Expenses are paid by the  Facilities Fund and rates are charged to departments based on square footage.            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 2,708,104        5,992,730               2,996,365        288,261           (2,996,365)       50.00% Rents, leases, and misc fees 1                         ‐                                 ‐                         (1)                        ‐                         N/A Interest and other misc 6,783                4,000                       620                   (6,163)               (3,380)               15.50% TOTAL REVENUES 2,736,723        5,996,730               2,996,985        260,262           (2,999,745)       49.98% EXPENSES: Personnel 1,478,774        3,861,996               1,434,806        43,968              2,427,190        37.15% Supplies 293,729           307,068                  177,143           116,586           129,925           57.69% Contracted Services 625,575           1,869,621               578,197           47,378              1,291,424        30.93% Internal Services 35,671              130,384                  64,841              (29,170)            65,543              49.73% TOTAL OPERATING EXPENSES 2,433,749        6,169,069               2,254,987        178,762           3,914,082        36.55% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 302,974           (172,339)                 741,998           439,024           914,337           N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 5,704                 ‐                                40,063              (34,359)            (40,063)            N/A Transfers In 8,596                 ‐                                 ‐                         (8,596)                ‐                         N/A NET TRANSFERS 8,596                 ‐                                 ‐                         (8,596)                ‐                         N/A CHANGE IN FUND BALANCE 305,866           (172,339)                 701,935           396,069           874,274           N/A BEGINNING FUND BALANCE, Jan 1 1,220,276        504,167                  504,167           (716,109)           ‐                         100.00% ENDING FUND BALANCE, Jun 30 1,526,142$      331,828$                1,206,102$      (320,040)$        874,274$         363.47% FACILITIES VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 41 of 43   Communications Fund  This fund accounts for community and intergovernmental relations and communications with the public. Communications is  a major activity of the City’s administration responsible for external communications, employee communications, media  relations, and coordination of all departments in producing the City’s website. Expenses are paid by the Communications  Fund and rates are charged to departments based on usage.           2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 566,721$         1,154,732$            577,366$         10,645$           (577,366)$        50.00% Interest and other misc 4,133                1,000                       245                   (3,888)               (755)                  24.50% TOTAL REVENUES 570,854           1,155,732               577,611           6,757                (578,121)          49.98% EXPENSES: Personnel 444,546           810,882                  335,367           109,179           475,515           41.36% Supplies 16,622              55,432                    11,147              5,475                44,285              20.11% Contracted Services 131,920           284,512                  85,382              46,538              199,130           30.01% Internal Services 1,971                2,000                       1,000                971                   1,000                50.00% TOTAL OPERATING EXPENSES 595,059           1,152,826               432,896           162,163           719,930           37.55% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (24,205)            2,906                       144,715           168,920           141,809           4979.87% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A Transfers Out 4,229                 ‐                                 ‐                         4,229                 ‐                         N/A NET TRANSFERS (4,229)                ‐                                 ‐                         4,229                 ‐                         N/A CHANGE IN FUND BALANCE (28,434)            2,906                       144,715           173,149           141,809           4979.87% BEGINNING FUND BALANCE, Jan 1 803,561           151,624                  151,624           (651,937)           ‐                         100.00% ENDING FUND BALANCE, Jun 30 775,127$         154,530$                296,339$         (478,788)$        141,809$         191.77% COMMUNICATIONS VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 42 of 43   Health Insurance Fund  This fund accounts for the City’s self‐insured health insurance program. Expenses/claims are paid by the Health Insurance  Fund and rates are charged to employees and departments based on annual premiums determined by the City’s Employee  Health Plan Board for each type of coverage elected by the employee; paid semi‐monthly in conjunction with each payroll.              2020 2021 2021 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Premiums 6,054,561$      12,328,055$            6,111,494$      56,933$           (6,216,561)$    49.57% Interest and other misc 28,374              149,488                    177,291           148,917           27,803              118.60% TOTAL REVENUES 6,082,935        12,477,543               6,288,785        205,850           (6,188,758)       50.40% EXPENSES: Personnel 4,532,506        12,015,118               5,668,807        (1,136,301)       6,346,311        47.18% Supplies 6,881                7,500                         844                   6,037                6,656                11.25% Contracted Services 248,336           478,037                    227,196           21,140              250,841           47.53% Internal Services 30,215              80,176                       40,088              (9,873)               40,088              50.00% TOTAL OPERATING EXPENSES 4,817,938        12,580,831               5,936,935        (1,118,997)       6,643,896        47.19% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,264,997        (103,288)                   351,850           (913,147)          455,138           N/A TOTAL DEBT SERVICE ‐                          ‐                                   ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                   ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                   ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 1,264,997        (103,288)                   351,850           (913,147)          455,138           N/A BEGINNING FUND BALANCE, Jan 1 5,151,648        5,773,429                 5,773,429        621,781            ‐                         100.00% ENDING FUND BALANCE, Jun 30 6,416,645$      5,670,141$               6,125,279$      (291,366)$        455,138$         108.03% Insurance Reserves 3,757,179        3,774,249                 3,774,249         AVAILABLE FUND BALANCE 2,659,466$      1,895,892$               2,351,030$       HEALTH INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2021  Page 43 of 43   Retiree Healthcare Fund  This fund accounts for the City’s self‐insured health insurance program for LEOFF1 retirees. Benefits include medical,  prescription drug, Medicare Part B premiums, long‐term care, and vision coverage for retired law enforcement officers and  firefighters that were employed by the City prior to October 1, 1977. Dependent spouses and children are not covered. 100%  of premiums are provided by the General Fund with annual contributions determined by recommendation of the City’s  Employee Health Plan Board after review of a report prepared by Healthcare Actuaries.                     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 812,342           2,640,000               1,312,342        500,000           (1,327,658)       49.71% Interest and other misc 82,166              20,000                    70,431              (11,735)            50,431              352.16% TOTAL REVENUES 929,753           2,705,933               1,382,773        453,020           (1,323,160)       51.10% EXPENSES: Personnel 539,457           1,333,374               538,744           713                   794,630           40.40% Contracted Services 25,960              29,311                    25,212              748                   4,099                86.02% TOTAL OPERATING EXPENSES 565,417           1,362,685               563,956           1,461                798,729           41.39% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 364,336           1,343,248               818,817           454,481           (524,431)          60.96% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 364,336           1,343,248               818,817           454,481           (524,431)          60.96% BEGINNING FUND BALANCE, Jan 1 15,799,729      16,541,245            16,541,245      741,516            ‐                         100.00% ENDING FUND BALANCE, Jun 30 16,164,065$   17,884,493$          17,360,062$   1,195,997$      (524,431)$        97.07% Insurance Reserves 16,164,065      17,884,493            17,360,062       AVAILABLE FUND BALANCE ‐$                        ‐$                              ‐$                        RETIREE HEALTHCARE VARIANCE