Loading...
HomeMy WebLinkAboutQUARTER 1 2020Page 1 of 36   OVERVIEW  This quarterly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through March 31,  2020. A detailed analysis, including current to prior year and budget to actual comparison is included for each City fund.  Excluded from this report are the City’s fiduciary funds as these funds are held on behalf of others and are not available for  City use. Budget figures shown include adjustments adopted through Ordinance  5969.     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 15,347,411$      81,510,404$    15,340,587$ 18,732,106$   3,384,695$     3,391,519   22.98% Licenses & Permits 1,860,019            5,550,877          1,869,352       1,787,131         (72,888)              (82,221)         32.20% Intergovernmental 972,536                5,663,060          926,301            1,065,400         92,864               139,099       18.81% Charges for Services 2,278,366            9,540,323          2,393,854       2,133,062         (145,304)           (260,792)      22.36% Fines and Penalties 1,114,810            4,759,187          954,158            1,031,591         (83,219)              77,433          21.68% Miscellaneous 982,837                2,843,423          751,528            803,846             (178,991)           52,318          28.27% Other Financing Sources (Transfer‐In, etc) 17                              16,104,450       25,000               25,000                24,983                ‐                   0.16% Total Revenues 22,555,996         125,971,724    22,260,780    25,578,136      3,022,140        3,317,356   20.30% EXPENDITURES Council 96,135                   436,528               129,091            110,255             (14,120)              18,836          25.26% Executive 626,853                2,930,253          748,637            682,606             (55,753)              66,031          23.30% Emergency Management 126,555                789,157               174,255            174,698             (48,143)              (443)                22.14% City Attorney 579,692                2,530,461          620,341            610,315             (30,623)              10,026          24.12% Court Services 599,351                3,043,067          767,219            642,517             (43,166)              124,702       21.11% Community and Eco Dvlpmnt Admin 355,930                1,691,111          377,744            378,000             (22,070)              (256)                22.35% Development Services 549,965                2,794,157          662,199            646,498             (96,533)              15,701          23.14% Economic Development 181,005                3,745,243          495,081            442,964             (261,959)           52,117          11.83% Planning 980,977                4,694,723          1,149,956       1,034,221         (53,244)              115,735       22.03% Finance 709,421                4,073,890          872,430            719,412             (9,991)                 153,018       17.66% City Clerk 483,593                1,410,799          538,714            433,239             50,354               105,475       30.71% Human Resources 322,612                1,686,208          377,173            366,848             (44,236)              10,325          21.76% Police 8,808,325            38,232,980       9,212,684       9,424,063         (615,738)           (211,379)      24.65% Jail Services 1,441,493            6,518,024          1,629,152       1,177,184         264,309            451,968       18.06% Community Services Admin 297,301                1,584,800          318,659            310,008             (12,707)              8,651             19.56% Parks & Trails 1,136,093            6,434,765          1,372,987       1,196,758         (60,665)              176,229       18.60% Parks Planning & Natural Resources 203,405                2,425,388          348,849            352,066             (148,661)           (3,217)            14.52% Recreation & Neighborhoods 1,262,084            6,625,123          1,356,228       1,335,846         (73,762)              20,382          20.16% Human Services 254,606                1,614,277          288,796            288,129             (33,523)              667                  17.85% Museum 63,525                   266,652               66,589               66,534                (3,009)                 55                     24.95% Public Works Admin 106,209                486,696               121,663            107,999             (1,790)                 13,664          22.19% Street Maintenance 1,391,866            6,140,580          1,544,970       1,400,798         (8,932)                 144,172       22.81% Transportation 1,489,876            7,276,975          1,618,805       1,453,101         36,775               165,704       19.97% Non‐Departmental and Other 806,804                27,197,163       948,649            816,227             (9,423)                 132,422       3.00% Total Expenditures 22,873,676         134,629,020    25,740,871    24,170,286      (1,296,610)      1,570,585   17.95% Change in Fund Balance (317,680)               (8,657,296)         (3,480,091)      1,407,850         1,725,530        4,887,941   N/A Beginning Fund Balance 44,578,377         48,056,982       48,056,982    48,056,982      3,478,605         ‐                   100.00% Ending Fund Balance 44,260,697$      39,399,686$    44,576,891$ 49,464,832$   5,204,135$     4,887,941   125.55% Summary of Sources and Uses Favorable (Unfavorable) 2019 2020 Variance YTD Actual Annual Budget YTD Budget YTD Actual Quarterly Financial Report 1st Quarter 2020  Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 2 of 36   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. Variances are shown in a  favourable (unfavourable) format.    TAXES        Property Tax ‐ Property tax revenues over YTD budget can be attributed to timing differences – changes to the recording of  property tax revenues in the 4th quarter of 2019 resulted in the recognition of property tax revenues when received by King  County. Previously property tax revenues were not recognized by the City until King County remitted the revenues to the  City. There is generally a two week lag in the collection of property taxes by King County and their subsequent remittance to  the City so the change in revenue recognition resulted in an additional two weeks’ revenue being recognized in the 1st quarter  of 2020 compared to prior years.     Local Retail Sales Tax ‐ The majority of the increase in local retail sale tax revenues over the prior year is coming from the  services and automotive sectors. The amount over the YTD budget is due to higher than anticipated sales tax revenues  received in the services, automotive, and wholesale sectors. It is important to note that sales tax revenues have a two month  lag between the time of the sale and the City’s receipt of the sales tax from the State, so the revenues recognized in the 1st  quarter of 2020 do not reflect decreased sales due to COVID‐19 closures. See the monthly sales tax report for additional  information.    State Sales Tax Credit ‐ The City was awarded $500K per year in sales tax credit revenues under the Local Revitalization  Financing program. This award is to pay the debt service on the LRF bonds issued in 2019 to fund public improvements within  the South Lake Washington Local Revitalization Area. The City began receiving the state sales tax credit revenues in the 3rd  quarter of 2019. Because the YTD budget is based on prior year collection trends, there are no State Sales Tax Credit revenues  included in the YTD budget until the 3rd quarter of 2020.       2019 2020 2020 Actual Budget Actual $ % $ % Property Tax 996,825$              826,181$              1,062,041$         65,215$           6.5% 235,860$           28.5% Local Retail Sales Tax 7,085,510            7,136,408             7,277,582            192,073           2.7% 141,174              2.0% State Sales Tax Credit ‐ Annexation/LRF ‐                                    ‐                                   159,427                 159,427           100.0% 159,427              100.0% Criminal Justice Sales Tax 806,497                 732,121                 828,690                 22,194              2.8% 96,570                 13.2% Natural Gas Use Tax 81,082                    81,645                    48,745                    (32,337)              ‐39.9% (32,900)                ‐40.3% Admission Tax 48,790                    38,064                    53,883                    5,093                 10.4% 15,819                 41.6% Utility Tax 3,334,834            3,870,256             4,337,978            1,003,144       30.1% 467,722              12.1% Leasehold Excise Tax 39,792                    23,308                    46,879                    7,087                 17.8% 23,571                 101.1% Gambling Excise Tax 610,937                 578,538                 897,556                 286,619           46.9% 319,018              55.1% Real Estate Excise Tax ‐                                    ‐                                   1,495,896            1,495,896       100.0% 1,495,896         100.0% B&O Tax 2,343,145            2,054,066             2,523,430            180,285           7.7% 469,364              22.9% YTD Total 15,347,411$      15,340,587$       18,732,106$      3,384,695$    22.1% 3,391,520$      22.1% Annual Total 89,542,897$      81,510,404$        Taxes by Type Revenue 2020 vs. 2019 2020 vs. Budget Year to Date through March Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 3 of 36   Utility Tax ‐ $1M increase in utility tax revenues from prior year can be attributed to a timing difference. February utility taxes  due in March 2019 were not received until April 2019. This is skewing the prior year revenue. Because the YTD budget is  based on prior years’ collection rates this timing difference lowers the YTD budget for utility taxes. The timing difference will  correct itself in the 2nd quarter. The breakdown of Utility Tax is as follows:       Gambling Excise Tax – The increase in gambling tax revenues is primarily resulting from card game revenues. It is important  to note that there is a one‐month lag in between the gambling activity and the City’s receipt of the associated gambling tax,  so the revenues recognized in the 1st quarter of 2020 do not reflect decreased gambling activity due to COVID‐19 closures.    Real Estate Excise Tax (REET) ‐ $1.5M in REET revenues are recorded in the General Fund in the 1st quarter of 2020 – Budget  amounts shown in this report include adjustments adopted by Council with the 1st quarter / carry forward budget adjustment.  The budget adjustment shifts the REET revenues to the new REET 1 and REET 2 funds, therefore, there is no REET revenue  included in the budget amounts shown in the table. However, because the budget adjustment was not approved by Council  until April 2020, the revenues are still recorded in the General Fund at March 31, 2020. This difference from budget will  correct itself with the transfer of the REET revenues to the new funds in the 2nd quarter.    Business and Occupation (B&O) Tax – B&O tax revenues collected in the 1st quarter, primarily from annual filers based on  2019 activity, was higher than anticipated.    LICENSES & PERMITS           2019 2020 2020 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Electrical 1,015,999$     1,356,165$         1,733,702$     717,702$        70.6% $   377,536 27.8% Natural Gas 333,824            450,680                 684,617            350,793           105.1%       233,937 51.9% Cell 127,295            156,448                 167,277            39,982              31.4%          10,830 6.9% Phone 275,325            247,629                 135,817            (139,508)          ‐50.7%     (111,812)‐45.2% Cable 216,202            289,900                 243,494            27,293              12.6%        (46,405)‐16.0% Garbage 186,529            178,773                 173,885            (12,644)             ‐6.8%           (4,888)‐2.7% City Utilities 1,179,660        1,190,661            1,199,186        19,525              1.7%             8,524 0.7% YTD Total 3,334,834$     3,870,256$         4,337,978$     1,003,144$   30.1%467,722$   12.1% 2020 vs. 2019 2020 vs. Budget 2019 2020 2020 Actual Budget Actual $ % $ % Amusement Licenses ‐$                                 ‐$                                 ‐$                                 ‐$                          N/A ‐$                             N/A Franchise Fees 405,277                 441,203                 389,385                 (15,892)              ‐3.9% (51,818)                ‐11.7% Business Licenses 744,645                 719,663                 666,064                 (78,581)              ‐10.6% (53,599)                ‐7.4% Animal Licenses 21,560                    24,733                    20,210                    (1,350)                 ‐6.3% (4,523)                   ‐18.3% Building Permits 683,801                 673,256                 701,967                 18,166              2.7% 28,711                 4.3% ROW/Street Excavation Permits 4,685                       10,255                    9,200                       4,515                 96.4%(1,055)                   ‐10.3% Special Event Permits 50                              242                            305                           255                      510.0% 63                           26.1% YTD Total 1,860,019$         1,869,352$          1,787,131$         (72,887)$           ‐3.9% (82,221)$             ‐4.4% Annual Total 5,750,061$         5,550,877$           Year to Date through March Revenue 2020 vs. 2019 2020 vs. Budget Licenses & Permits by Type Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 4 of 36   INTERGOVERNMENTAL        State Shared Revenue ‐ The increase in state shared revenues over prior year is almost entirely due to change in accounting  practices related to fuel tax revenues. In prior years fuel tax revenues were split 68/32 between the Street Fund, a  management fund within the General Fund, and the Arterial Street Fund, a special revenue fund. In 2019 the Arterial Street  Fund was deemed unnecessary and in the 3rd quarter of 2019 the fund was closed. 100% of fuel taxes are now being  recognized in the Street (General) Fund. The breakdown of State Shared Revenue is as follows:        CHARGES FOR SERVICES        Development Services – The decrease in development services revenue is almost entirely related to inspection services.     Recreation/Farmer’s Market/Events – The decrease in revenues is primarily related to cancelled programs, a result of the  governor’s stay‐at‐home order in response to COVID‐19.    Interfund  Services ‐ Interfund revenues were less than anticipated as the budget reflects reimbursement of staffing costs  from CIP projects that staff did not work on during the quarter, including reimbursement for a capital project coordinator  position that is vacant.       2019 2020 2020 Actual Budget Actual $ % $ % State Shared Revenue 865,989$              869,963$              1,040,151$         174,162$        20.1% 170,188$           19.6% Federal Grants 2,940                       8,987                        ‐                                   (2,940)                0.0%(8,987)                  0.0% State Grants 15,471                    9,287                       100                           (15,371)              ‐99.4% (9,187)                   ‐98.9% Local Grants 88,136                    38,064                    25,149                    (62,988)              ‐71.5% (12,915)                ‐33.9% YTD Total 972,536$              926,301$              1,065,400$         92,863$           9.5% 139,098$           15.0% Annual Total 4,820,547$         5,663,060$           Intergovernmental by Type Revenue 2020 vs. 2019 2020 vs. Budget Year to Date through March 2019 2020 2020 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Judicial Contribution 5,415$            4,926$            10,768$         5,353$           98.9% 5,842$           118.6% Crim Just ‐ High Crime 74,000            69,186            70,168            (3,832)             ‐5.2%983                  1.4% Crim Just ‐ Pop 7,593               6,029               7,938               345                  4.5% 1,909              31.7% Crim Just ‐ Spec Prog 27,390            27,690            28,492            1,103              4.0% 802                  2.9% State DUI 3,786               4,608               3,435               (351)                  ‐9.3% (1,173)             ‐25.5% Marijuana Distribution 52,766             ‐                           51,820            (946)                  ‐1.8%51,820           100.0% Liquor Profits 212,201         212,526         210,157         (2,044)             ‐1.0% (2,369)             ‐1.1% Liquor Excise Tax 128,697         113,409         138,907         10,211           7.9% 25,499           22.5% Fuel Tax 354,141         431,590         518,465         164,323        46.4% 86,875           20.1% YTD Total 865,989$      869,963$      1,040,151$  174,162$     20.1%170,188$     19.6% 2020 vs. 2019 2020 vs. Budget 2019 2020 2020 Actual Budget Actual $ % $ % Passport Fees 8,365                       17,319                    7,945                       (420)                     ‐5.0% (9,374)                   ‐54.1% Court Services 2,693                       1,441                       15,582                    12,888              478.6% 14,141                 981.6% General Government Services 201                           93                               412                           212                      105.7% 319                        341.5% Public Safety Services 292,583                 277,047                 326,187                 33,604              11.5% 49,140                 17.7% Development Services 686,175                 571,909                 504,309                 (181,866)           ‐26.5% (67,600)                ‐11.8% Transportation Services 8,680                        ‐                                   43,079                    34,399              396.3% 43,079                 100.0% Recreation/Farmer's Market/Events 242,070                 230,726                 140,373                 (101,697)           ‐42.0% (90,353)                ‐39.2% Interfund Services 1,037,598            1,295,319             1,095,175            57,576              5.5%(200,145)             ‐15.5% YTD Total 2,278,366$         2,393,854$          2,133,062$         (145,304)$        ‐6.4% (260,792)$          ‐10.9% Annual Total 9,251,750$         9,540,323$           Year to Date through March Charges for Services by Type Revenue 2020 vs. 2019 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 5 of 36   FINES AND PENALTIES        Photo Enforcement Program – Photo enforcement revenues are less than anticipated due to reduced citations as a result of  the governor’s stay‐at‐home order. Traffic volumes have decreased and school zone cameras have been turned off as a result  of school closures.    MISCELLANEOUS REVENUES        Interest and Other Investment Earnings – Since interest earnings can vary greatly based on market conditions, the City has  historically budgeted interest and investment earnings very conservatively.    Rents, Leases, and Concessions ‐ Rental revenue is down from the prior year due to a few vacant City facilities, combined  with cancelled facility space rentals at the Senior Center and Renton Community Center and waived rent for tenants of City  facilities that were ordered closed in March due to COVID‐19.    OTHER FINANCING SOURCES           2019 2020 2020 Actual Budget Actual $ % $ % Civil Penalties 123,646$              169,421$              111,039$              (12,606)$           ‐10.2% (58,381)$             ‐34.5% Photo Enforcement Program 899,335                 729,381                 845,228                 (54,107)              ‐6.0%115,847              15.9% Criminal Traffic Misdemeanor Fines 17,965                    22,233                    14,918                    (3,047)                 ‐17.0% (7,314)                   ‐32.9% Criminal Non‐Traffic Fines 36,220                    10,181                    7,400                       (28,820)              ‐79.6% (2,780)                   ‐27.3% Criminal Costs 31,224                    17,684                    19,855                    (11,369)              ‐36.4%2,170                    12.3% Non‐Court Fines, Forfeitures and Penalties 6,420                       5,258                       33,150                    26,730              416.4% 27,892                 530.4% YTD Total 1,114,810$         954,158$              1,031,591$         (83,219)$           ‐7.5%77,433$              8.1% Annual Total 4,688,980$         4,759,187$           Year to Date through March Revenue 2020 vs. 2019 2020 vs. Budget Fines and Penalties by Type 2019 2020 2020 Actual Budget Actual $ % $ % Interest and Other Investment Earnings 320,400$              185,609$              319,913$              (487)$                  ‐0.2%134,305$           72.4% Rents, Leases, and Concessions 467,992                 454,612                 331,791                 (136,201)           ‐29.1% (122,821)             ‐27.0% Contributions/Donations from Private Source 97,184                    41,547                    53,018                    (44,166)              ‐45.4%11,470                 27.6% Seizure Funds ‐ Federal/State/Local 16,467                     ‐                                    ‐                                   (16,467)             0.0%‐                                N/A Other 80,793                    69,760                    99,123                    18,331              22.7% 29,364                 42.1% YTD Total 982,837$              751,528$              803,846$              (178,991)$        ‐18.2%52,318$              7.0% Annual Total 3,762,854$         2,843,423$           Year to Date through March Revenue 2020 vs. 2019 2020 vs. Budget Miscellaneous by Type 2019 2020 2020 Actual Budget Actual $ % $ % Transfers from Other Funds ‐$                                25,000$                 25,000$                 25,000              100.0%‐                                0.0% Prior Period Adjustment 17                               ‐                                    ‐                                   (17)                       0.0%‐                                N/A Insurance Recoveries ‐                                    ‐                                    ‐                                    ‐                             N/A ‐                                N/A Sale of Capital Assets ‐                                    ‐                                    ‐                                    ‐                             N/A ‐                                N/A YTD Total 17$                           25,000$                 25,000$                 24,983$           143578.2%‐$                             0.0% Annual Total 13,137,402$      16,104,450$        Year to Date through March Other Financing Sources by Type Revenue 2020 vs. 2019 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 6 of 36   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. Variances are shown in a  favorable (unfavorable) format.     COUNCIL        EXECUTIVE        EMERGENCY MANAGEMENT        CITY ATTORNEY          Council 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 73,391$                309,067$            77,852$            76,183$             (2,793)$               ‐3.8%1,669$          2.1% Supplies 171                           2,000                     436                      795                        (624)                      ‐365.1% (359)                 ‐82.3% Contracted Services 8,981                      63,316                  35,271               17,740                (8,759)                  ‐97.5%17,530          49.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 13,592                   62,145                  15,533               15,536                (1,944)                  ‐14.3% (3)                      0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 96,135$                436,528$            129,091$         110,255$          (14,120)$            ‐14.7%18,837$       14.6% 2020 2020 vs. 2019 2020 vs. Budget Executive 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 218,746$             924,846$            226,178$         228,482$          (9,736)$               ‐4.5% (2,304)$          ‐1.0% Supplies 2,474                      12,800                  2,681                  1,005                   1,469                  59.4% 1,676             62.5% Contracted Services 293,406                1,525,576           403,029            336,361             (42,956)               ‐14.6%66,667          16.5% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 112,228                467,031               116,749            116,758             (4,530)                  ‐4.0% (9)                      0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 626,853$             2,930,253$        748,637$         682,606$          (55,753)$            ‐8.9%66,031$       8.8% 2020 2020 vs. 2019 2020 vs. Budget Emergency Management 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 87,356$                507,809$            115,467$         120,185$          (32,829)$            ‐37.6% (4,717)$          ‐4.1% Supplies 25                              26,013                  487                      103                        (78)                         ‐319.6%384                  78.9% Contracted Services 616                           40,861                  5,024                  98                           518                       84.1% 4,926             98.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 38,559                   214,474               53,277               53,619                (15,060)               ‐39.1% (342)                 ‐0.6% Transfers Out ‐                                   ‐                                  ‐                              694                        (694)                     100.0%(694)                100.0% Total Expenditures 126,555$             789,157$            174,255$         174,698$          (48,143)$            ‐38.0% (444)$              ‐0.3% 2020 2020 vs. 2019 2020 vs. Budget City Attorney 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 528,958$             2,272,019$        560,886$         552,564$          (23,606)$            ‐4.5%8,323$          1.5% Supplies 87                              3,550                     463                      474                        (387)                      ‐443.8% (11)                    ‐2.3% Contracted Services 4,588                      49,450                  7,639                  5,917                   (1,329)                  ‐29.0%1,722             22.5% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 46,059                   205,442               51,353               51,361                (5,302)                  ‐11.5% (8)                      0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% 2020 vs. 2019 2020 vs. Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 7 of 36   COURT SERVICES        Personnel ‐ The amount of Court Services personnel expenditures under the YTD budget is due to open positions.    COMMUNITY AND ECONOMIC DEVELOPMENT ADMIN        DEVELOPMENT SERVICES        ECONOMIC DEVELOPMENT        Contracted Services ‐ The amount of Economic Development contracted services expenditures over the prior year is due to  a $25K Housing Opportunity grant and $121K in impact fee waivers were awarded to multiple non‐profits in the 1st quarter  of 2020 to support low income housing developments. RMC 4‐1‐210 allows for the waiver of 100% of impact fees associated  with certain low income housing developments. State law only allows for an 80% waiver of these fees, so the General Fund  must contribute the remaining 20% of the fees to the impact mitigation funds. Ordinance No. 5973 imposed a six month  moratorium on the submission, acceptance, processing or approval of any application for waived fees under RMC 4‐1‐210  effective June 22, 2020.       Court Services 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 452,454$             2,436,136$        617,339$         488,355$          (35,900)$            ‐7.9%128,984$    20.9% Supplies 699                           7,700                     725                      461                        238                       34.1% 264                  36.4% Contracted Services 31,545                   121,716               29,773               32,369                (823)                      ‐2.6% (2,596)             ‐8.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 114,652                477,515               119,383            119,379             (4,727)                  ‐4.1%4                        0.0% Transfers Out ‐                                   ‐                                  ‐                              1,954                   (1,954)                 100.0%(1,954)            100.0% Total Expenditures 599,351$             3,043,067$        767,219$         642,517$          (43,166)$            ‐7.2%124,703$    16.3% 2020 vs. 2019 2020 vs. Budget2020 Community and Eco Dvlpmnt Admin 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 92,244$                389,402$            97,408$            97,493$             (5,248)$               ‐5.7% (85)$                 ‐0.1% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Contracted Services 275                           850                           ‐                              165                        110                       40.0%(165)                100.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 262,618                1,119,719           279,931            279,930             (17,312)               ‐6.6%1                        0.0% Transfers Out 793                           181,140               412                      412                        380                       48.0%‐                         0.0% Total Expenditures 355,930$             1,691,111$        377,752$         378,000$          (22,070)$            ‐6.2% (248)$              ‐0.1% 2020 vs. 2019 2020 vs. Budget2020 Development Services 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 508,484$             2,589,884$        621,003$         601,287$          (92,803)$            ‐18.3%19,716$       3.2% Supplies 412                           7,525                     2,094                  788                        (376)                      ‐91.3%1,306             62.4% Contracted Services 25,428                   117,941               19,400               24,721                707                       2.8%(5,321)             ‐27.4% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 15,641                   78,807                  19,701               19,702                (4,061)                  ‐26.0% (0)                      0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 549,965$             2,794,157$        662,199$         646,498$          (96,533)$            ‐17.6%15,701$       2.4% 2020 vs. 2019 2020 vs. Budget2020 Economic Development 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 151,734$             940,340$            232,261$         220,216$          (68,482)$            ‐45.1%12,046$       5.2% Supplies 298                           62,250                  4,454                  662                        (364)                      ‐122.0%3,792             85.1% Contracted Services 22,660                   1,760,379           214,506            169,246             (146,586)            ‐646.9%45,260          21.1% Capital Outlay 6,313                      982,274               43,859               52,840                (46,527)               ‐737.0% (8,981)             ‐20.5% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 181,005$             3,745,243$        495,081$         442,964$          (261,959)$         ‐144.7%52,117$       10.5% 2020 vs. 2019 2020 vs. Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 8 of 36   PLANNING        FINANCE        Personnel ‐ The amount of Finance personnel expenditures under the YTD budget is due to open positions.    CITY CLERK        HUMAN RESOURCES           Planning 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 950,045$             4,308,862$        1,086,312$    996,328$          (46,283)$            ‐4.9%89,984$       8.3% Supplies 3,643                      11,600                  2,857                  1,315                   2,328                  63.9% 1,542             54.0% Contracted Services 18,971                   267,772               48,592               25,510                (6,539)                  ‐34.5%23,082          47.5% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 8,318                      48,789                  12,194               11,068                (2,750)                  ‐33.1%1,126             9.2% Transfers Out ‐                                  57,700                   ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 980,977$             4,694,723$        1,149,956$    1,034,221$      (53,244)$            ‐5.4%115,735$    10.1% 2020 vs. 2019 2020 vs. Budget2020 Finance 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 508,263$             2,578,979$        649,967$         484,357$          23,905$            4.7% 165,610$    25.5% Supplies 499                           11,500                  1,471                   ‐                               499                       100.0% 1,471             100.0% Contracted Services 101,313                1,044,548           111,266            128,739             (27,426)               ‐27.1% (17,473)          ‐15.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 99,347                   438,863               109,726            106,316             (6,969)                  ‐7.0%3,410             3.1% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 709,421$             4,073,890$        872,430$         719,412$          (9,991)$               ‐1.4%153,018$    17.5% 2020 vs. 2019 2020 vs. Budget2020 City Clerk 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 188,352$             816,474$            204,441$         192,428$          (4,076)$               ‐2.2%12,013$       5.9% Supplies 179                           6,994                     1,215                  669                        (491)                      ‐274.7%546                  44.9% Contracted Services 252,607                396,201               285,279            192,359             60,248               23.9% 92,920          32.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 42,455                   191,130               47,780               47,782                (5,327)                  ‐12.5% (2)                      0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 483,593$             1,410,799$        538,714$         433,239$          50,355$            10.4% 105,476$    19.6% 2020 vs. 2019 2020 vs. Budget2020 Human Resources 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 245,455$             1,175,163$        284,505$         282,490$          (37,035)$            ‐15.1%2,015$          0.7% Supplies 1,100                      21,828                  3,174                  610                        490                       44.6% 2,564             80.8% Contracted Services 9,061                      207,663               20,623               13,359                (4,299)                  ‐47.4%7,264             35.2% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 63,998                   281,554               68,871               70,388                (6,390)                  ‐10.0% (1,518)             ‐2.2% Transfers Out 2,998                       ‐                                  ‐                               ‐                               2,998                  100.0%‐                         0.0% Total Expenditures 322,612$             1,686,208$        377,173$         366,848$          (44,236)$            ‐13.7%10,325$       2.7% 2020 vs. 2019 2020 vs. Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 9 of 36   POLICE        Personnel ‐ The 8% increase in salaries and benefits over the prior year is primarily the result of COLAs, annual step increases,  and the reclassification of the deputy chief and commander positions. The amount of salaries and benefits over the YTD  budget is primarily due to overtime costs incurred due to backfilling open positions and the performance of private security.  Private security overtime costs are recovered through public safety charges for services revenues.     Contracted Services – The City ended their partnership with the City of Auburn for the Alive and Free Program at the end of  2019 and payments for February and March traffic camera rentals were not made until 2nd quarter 2020 when the invoices  were received from the vendor.    Internal Services ‐ Increased internal service fund charges are a result of additional M&O charges and replacement reserve  payments associated with take home vehicles added in 2019 and 2020.    JAIL SERVICES        Contracted Services ‐ The amount of jail services under prior year and the YTD budget is due to a decrease in the monthly  contract payments to SCORE for 2020. The budget has not been reduced to reflect the reduction in contractual charges, but  will be adjusted before the end of the year.     COMMUNITY SERVICES ADMIN           Police 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 6,119,794$         25,992,291$     6,389,444$    6,611,312$      (491,517)$         ‐8.0% (221,868)$    ‐3.5% Supplies 121,970                568,256               93,158               110,688             11,283               9.3%(17,530)          ‐18.8% Contracted Services 1,326,515            4,929,884           1,256,325       1,209,270         117,245            8.8% 47,054          3.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 1,235,085            5,936,406           1,472,525       1,492,793         (257,708)            ‐20.9% (20,269)          ‐1.4% Transfers Out 4,960                      806,143                ‐                               ‐                               4,960                  100.0%‐                         0.0% Total Expenditures 8,808,325$         38,232,980$     9,211,451$    9,424,063$      (615,738)$         ‐7.0% (212,612)$    ‐2.3% 2020 vs. 2019 2020 vs. Budget2020 Jail Services 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel ‐$                                ‐$                               ‐$                            ‐$                             ‐$                           0.0%‐$                      0.0% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Contracted Services 1,441,493            6,518,024           1,629,152       1,177,184         264,310            18.3% 451,969       27.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 1,441,493$         6,518,024$        1,629,152$    1,177,184$      264,310$         18.3% 451,969$    27.7% 2020 vs. 2019 2020 vs. Budget2020 Community Services Admin 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 117,750$             550,053$            132,687$         137,916$          (20,166)$            ‐17.1% (5,230)$          ‐3.9% Supplies 244                           45,184                  8,776                  837                        (594)                      ‐243.4%7,939             90.5% Contracted Services 138,557                656,768               138,255            131,190             7,367                  5.3% 7,065             5.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                  175,000                ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 36,427                   157,795               38,941               39,449                (3,022)                  ‐8.3% (507)                 ‐1.3% Transfers Out 4,323                       ‐                                  ‐                              616                        3,707                  85.8%(616)                100.0% Total Expenditures 297,301$             1,584,800$        318,659$         310,008$          (12,707)$            ‐4.3%8,651$          2.7% 2020 2020 vs. 2019 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 10 of 36   PARKS AND TRAILS        Personnel ‐ The amount of Parks and Trails personnel expenditures under the YTD budget is due to open parks maintenance  positions.    PARKS PLANNING AND NATURAL RESOURCES        RECREATION AND NEIGHBORHOODS        HUMAN SERVICES           Parks & Trails 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 696,269$             3,929,559$        876,787$         708,915$          (12,646)$            ‐1.8%167,871$    19.1% Supplies 31,402                   238,874               29,670               42,607                (11,204)               ‐35.7% (12,937)          ‐43.6% Contracted Services 103,971                753,359               94,114               65,565                38,406               36.9% 28,549          30.3% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 304,451                1,512,973           372,417            379,671             (75,220)               ‐24.7% (7,254)             ‐1.9% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 1,136,093$         6,434,765$        1,372,987$    1,196,758$      (60,665)$            ‐5.3%176,229$    12.8% 2020 vs. 2019 2020 vs. Budget2020 Parks Planning & Natural Resources 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 156,267$             1,157,416$        271,487$         220,022$          (63,756)$            ‐40.8%51,464$       19.0% Supplies 138                           4,827                     237                      64                           75                          54.0% 173                  73.1% Contracted Services 37,121                   1,213,668           64,756               119,611             (82,491)               ‐222.2% (54,855)          ‐84.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 9,879                      49,477                  12,369               12,369                (2,490)                  ‐25.2%‐                         0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 203,405$             2,425,388$        348,849$         352,066$          (148,662)$         ‐73.1% (3,218)$          ‐0.9% 2020 vs. 2019 2020 vs. Budget2020 Recreation & Neighborhoods 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 710,846$             3,915,684$        769,115$         774,195$          (63,349)$            ‐8.9% (5,080)$          ‐0.7% Supplies 31,120                   279,804               40,526               36,690                (5,570)                  ‐17.9%3,836             9.5% Contracted Services 60,952                   526,285               75,314               49,873                11,079               18.2% 25,442          33.8% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 457,048                1,900,351           471,239            475,088             (18,040)               ‐3.9% (3,849)             ‐0.8% Transfers Out 2,118                      3,000                     33                          ‐                               2,118                  100.0% 33                     100.0% Total Expenditures 1,262,084$         6,625,123$        1,356,228$    1,335,846$      (73,762)$            ‐5.8%20,382$       1.5% 2020 vs. 2019 2020 vs. Budget2020 Human Services 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 139,991$             703,400$            172,607$         154,318$          (14,327)$            ‐10.2%18,289$       10.6% Supplies 1,681                      15,650                  3,590                  1,981                   (300)                      ‐17.8%1,610             44.8% Contracted Services 85,761                   776,343               82,873               102,099             (16,338)               ‐19.1% (19,226)          ‐23.2% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 27,173                   118,884               29,726               29,732                (2,559)                  ‐9.4% (6)                      0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 254,606$             1,614,277$        288,796$         288,129$          (33,523)$            ‐13.2%666$               0.2% 2020 vs. 20192020 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 11 of 36   MUSEUM        PUBLIC WORKS ADMIN        STREET MAINTENANCE        TRANSPORTATION       Personnel – The 14.1% increase in salaries and benefits is due to two vacant positions in 2019 that are filled in 2020.    Contracted Services – The amount of contracted services expenditures under the prior year and YTD budget are due to timing  differences. In prior years, payments under the Commute Trip Reduction Program have been made in the 1st quarter of the  year. In 2020, these payments weren’t made until the 2nd quarter. This timing difference will resolve itself in the 2nd quarter.       Museum 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 35,972$                147,630$            36,841$            36,779$             (807)$                   ‐2.2%62$                  0.2% 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 27,553                   119,022               29,748               29,756                (2,203)                  ‐8.0% (7)                      0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 63,525$                266,652$            66,589$            66,534$             (3,009)$               ‐4.7%55$                  0.1% 2020 vs. 20192020 2020 vs. Budget Public Works Admin 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 88,813$                374,676$            94,259$            80,358$             8,455$               9.5% 13,901$       14.7% Supplies ‐                                  800                           ‐                              249                        (249)                     100.0%(249)                100.0% Contracted Services ‐                                  1,650                     12                          ‐                                ‐                              0.0% 12                     100.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 17,396                   109,570               27,391               27,392                (9,996)                  ‐57.5% (1)                      0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 106,209$             486,696$            121,663$         107,999$          (1,790)$               ‐1.7%13,664$       11.2% 2020 vs. 20192020 2020 vs. Budget Street Maintenance 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 700,300$             3,149,815$        783,827$         726,067$          (25,768)$            ‐3.7%57,760$       7.4% Supplies 84,300                   319,798               75,056               35,288                49,012               58.1% 39,768          53.0% Contracted Services 247,049                1,150,055           271,159            247,594             (545)                      ‐0.2%23,566          8.7% Capital Outlay ‐                                  5,200                      ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 360,218                1,515,712           414,927            387,038             (26,821)               ‐7.4%27,889          6.7% Transfers Out ‐                                   ‐                                  ‐                              4,811                   (4,811)                 100.0%(4,811)            100.0% Total Expenditures 1,391,866$         6,140,580$        1,544,970$    1,400,798$      (8,932)$               ‐0.6%144,172$    9.3% 2020 vs. 20192020 2020 vs. Budget Transportation 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 961,874$             4,545,479$        1,085,939$    1,097,092$      (135,218)$         ‐14.1% (11,153)$       ‐1.0% Supplies 60,841                   226,002               47,827               28,113                32,729               53.8% 19,714          41.2% Contracted Services 282,696                956,824               287,558            116,820             165,876            58.7% 170,738       59.4% Capital Outlay ‐                                   ‐                                  ‐                              13,818                (13,818)              100.0%(13,818)         100.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 181,980                788,670               197,047            197,258             (15,278)               ‐8.4% (211)                 ‐0.1% Transfers Out 2,485                      760,000               433                       ‐                               2,485                  100.0% 433                  100.0% Total Expenditures 1,489,876$         7,276,975$        1,618,805$    1,453,101$      36,774$            2.5% 165,703$    10.2% 2020 vs. 20192020 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 12 of 36   NON‐DEPARTMENTAL AND OTHER        Personnel ‐ The amount of personnel expenditures under the YTD budget is due to savings from expected employee  separation payments.    Non‐Departmentsl and Other 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 708,384$             3,407,200$        850,437$         721,999$          (13,616)$            ‐1.9%128,438$    15.1% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Contracted Services 94,462                   169,651               93,502               89,520                4,942                  5.2% 3,982             4.3% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                         0.0% Internal Services 3,959                      18,828                  4,709                  4,707                   (748)                      ‐18.9%2                        0.0% Transfers Out ‐                                  23,601,484         ‐                               ‐                                ‐                              0.0%‐                         0.0% Total Expenditures 806,804$             27,197,163$     948,649$         816,226$          (9,422)$               ‐1.2%132,423$    14.0% 2020 vs. 20192020 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 13 of 36   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.        Taxes ‐ The decrease in tax revenues from the prior year is due to a change in accounting practices. Tax revenues previously  recognized in the debt service funds are now recognized in the General Fund and recorded as a transfer in to the debt service  fund. The increase in debt service expenditures over the prior year is due to the issuance of Local Revitalization Financing  (LRF) and Parks capital improvement bonds in 2019.    Transfers ‐ Budgeted transfers will be processed before the end of the year.       2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 804,462$               ‐$                              ‐$                    (804,462)$     ‐$                     N/A Grants / intergovernmental 31,763                   56,930                    28,678           (3,085)           (28,252)           50.37% Charges for services 186,030                386,827                  193,414         7,384            (193,413)         50.00% Investment Earnings 9,764                      ‐                                14,937           5,173            14,937            N/A TOTAL REVENUES 1,032,019             443,757                  237,029         (794,990)      (206,728)         53.41% EXPENDITURES: Principal 175,436                5,405,922               181,622         (6,186)           5,224,300       3.36% Interest 109,496                1,756,464               99,849           9,647            1,656,615       5.68% TOTAL EXPENDITURES 284,932                7,162,386               281,471         3,461            6,880,915       3.93% TRANSFERS IN ‐                              7,699,250                ‐                        ‐                     (7,699,250)     0.00% NET TRANSFERS ‐                              7,699,250                ‐                        ‐                     (7,699,250)     0.00% CHANGE IN FUND BALANCE 747,087                980,621                  (44,442)          (791,529)      (1,025,063)      ‐4.53% BEGINNING FUND BALANCE, Jan 1 2,307,173             3,999,457               3,999,457      1,692,284     ‐                        100.00% ENDING FUND BALANCE, Mar 31 3,054,260$           4,980,078$            3,955,015$   900,755$     (1,025,063)$   79.42% VARIANCE FAVORABLE (UNFAVORABLE) GENERAL GOVERNMENTAL MISCELLANEOUS DEBT Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 14 of 36   SPECIAL REVENUE FUNDS  Special revenue funds are used to account for revenues that are to be used for a specific purpose as required by law or  legislative action. YTD budgets are not prepared for special revenue funds.     HOTEL/MOTEL FUND  The Hotel/Motel Fund accounts for monies collected through an increase of 1% in hotel/motel taxes for the purpose of  increasing tourism in the City or Renton, as authorized under RCW 67.28.180. The Lodging Tax Advisory Committee solicits  applications for awards and brings their recommendations to Council for approval at least once per year. Awards for events  are paid to applicants at the conclusion of the event once certain reporting requirements have been met.        MUNICIPAL ART FUND  The Municipal Art Fund was established to account for the activities of the Renton Municipal Arts Commission, as outlined in  Renton Municipal Code (RMC) section 2‐8‐7. Expenditures include grants paid to local artists, organizations, and community  groups for arts and culture projects and events that serve the general public in Renton and payments for Public Art capital  projects located throughout the City.         Transfers ‐ Budgeted transfers will be processed before the end of the year.   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 93,642$                200,000$                93,982$                340$                      (106,018)$             46.99% Contributions 15,000                    ‐                                 ‐                              (15,000)                  ‐                              N/A Investment Earnings 2,731                      ‐                                3,294                     563                        3,294                     N/A TOTAL REVENUES 111,373                200,000                   97,276                   (14,097)                 (102,724)               48.64% EXPENDITURES: Contracted Services 34,667                   429,062                   44,496                   (9,829)                    384,566                10.37% TOTAL EXPENDITURES 34,667                   429,062                   44,496                   (9,829)                    384,566                10.37% NET TRANSFERS ‐                               ‐                                 ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 76,706                   (229,062)                 52,780                   (23,926)                 281,842                 ‐23.04% BEGINNING FUND BALANCE, Jan 1 722,387                943,889                   943,889                221,502                 ‐                              130.66% ENDING FUND BALANCE, Mar 31 799,093$              714,827$                996,669$              197,576$              281,842$              124.73% VARIANCE FAVORABLE (UNFAVORABLE) HOTEL/MOTEL 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 437$                       ‐$                              321$                      (116)$                     321$                      N/A TOTAL REVENUES 437                         ‐                                321                        (116)                       321                        N/A EXPENDITURES: Supplies ‐                              200                          200                        (200)                        ‐                              100.00% Contracted Services ‐                              165,460                  4,800                     (4,800)                    160,660                2.90% Capital Outlay ‐                              88,130                      ‐                               ‐                              88,130                   0.00% TOTAL EXPENDITURES ‐                              253,790                  5,000                     (5,000)                    248,790                1.97% TRANSFERS IN ‐                              180,660                   ‐                               ‐                              (180,660)               0.00% NET TRANSFERS ‐                              180,660                   ‐                               ‐                              (180,660)               0.00% CHANGE IN FUND BALANCE 437                        (73,130)                   (4,679)                    (5,116)                    68,451                   6.40% BEGINNING FUND BALANCE, Jan 1 119,446                98,865                     98,865                   (20,581)                  ‐                              100.00% ENDING FUND BALANCE, Mar 31 119,883$              25,735$                  94,186$                (25,697)$               68,451$                365.98% MUNICIPAL ART VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 15 of 36   CABLE COMMUNICATIONS FUND  The Cable Communications Fund accounts for funding for promotion and development of cable communications as  established by City ordinance. The main use of the fund is to support the broadcasting of City Council meetings on Channel  21.        SPRINGBROOK WETLANDS FUND  The Springbrook Wetlands Fund was established in 2007 for the purpose of providing accounting for the Springbrook Creek  Wetland and Habitat Mitigation Bank project. The fund will receive revenue by selling Wetlands credits to third parties and  to the City’s internal departments.          2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 40,000$                40,000$                     ‐$                            (40,000)$               (40,000)$               0.00% Licenses and permits 21,486                   57,674                      20,749                   (737)                       (36,925)                 35.98% Investment Earnings 2,034                      ‐                                  2,063                     29                           2,063                     N/A TOTAL REVENUES 63,520                   97,674                      22,812                   (40,708)                 (74,862)                 23.36% EXPENDITURES: Personnel 7,927                      ‐                                   ‐                              (7,927)                     ‐                              N/A Supplies ‐                              6,302                          ‐                               ‐                              6,302                     0.00% Contracted Services 2,500                     51,372                      9,360                     6,860                     42,012                   18.22% Capital Outlay ‐                              40,000                       ‐                               ‐                              40,000                   0.00% TOTAL EXPENDITURES 10,427                   97,674                      9,360                     (1,067)                    88,314                   9.58% NET TRANSFERS ‐                               ‐                                   ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 53,093                    ‐                                  13,452                   (39,641)                 13,452                   N/A BEGINNING FUND BALANCE, Jan 1 529,159                603,760                    603,760                74,601                    ‐                              100.00% ENDING FUND BALANCE, Mar 31 582,252$              603,760$                  617,212$              34,960$                13,452$                102.23% CABLE COMMUNICATIONS VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 1,248$                    ‐$                               1,158$                   (90)$                       1,158$                   N/A TOTAL REVENUES 1,248                      ‐                                 1,158                     (90)                         1,158                     N/A TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                                  ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 1,248                      ‐                                 1,158                     (90)                         1,158                     N/A BEGINNING FUND BALANCE, Jan 1 340,895                345,658                   345,658                4,763                      ‐                              100.00% ENDING FUND BALANCE, Mar 31 342,143$              345,658$                 346,816$              4,673$                   1,158$                   100.34% SPRINGBROOK WETLANDS VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 16 of 36   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.        Transfers ‐ Budgeted transfers will be processed before the end of the year.    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.        Transfers ‐ Budgeted transfers will be processed before the end of the year.   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 82,578$                86,500$                  245,993$              163,415$              159,493$              284.38% Investment Earnings 9,586                      ‐                                7,004                     (2,582)                    7,004                     N/A TOTAL REVENUES 92,164                   86,500                     252,997                160,833                166,497                292.48% TOTAL EXPENDITURES ‐                               ‐                                 ‐                               ‐                               ‐                              N/A TRANSFERS OUT ‐                              1,202,364                ‐                               ‐                              1,202,364             0.00% NET TRANSFERS ‐                              (1,202,364)               ‐                               ‐                              1,202,364             0.00% CHANGE IN FUND BALANCE 92,164                   (1,115,864)              252,997                160,833                1,368,861              ‐22.67% BEGINNING FUND BALANCE, Jan 1 2,578,256             1,886,999               1,886,999             (691,257)                ‐                              100.00% ENDING FUND BALANCE, Mar 31 2,670,420$           771,135$                2,139,996$           (530,424)$             1,368,861$           277.51% COMMUNITY SERVICES IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 182,002$              1,435,875$              529,142$              347,140$              (906,733)$             36.85% Investment Earnings 12,497                    ‐                                 11,261                   (1,236)                    11,261                   N/A TOTAL REVENUES 194,499                1,435,875                540,403                345,905                (895,472)               37.64% TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS OUT ‐                              2,500,656                 ‐                               ‐                              2,500,656             0.00% NET TRANSFERS ‐                              (2,500,656)                ‐                               ‐                              2,500,656             0.00% CHANGE IN FUND BALANCE 194,499                (1,064,781)               540,403                345,904                1,605,184              ‐50.75% BEGINNING FUND BALANCE, Jan 1 3,332,524             2,942,344                2,942,344             (390,180)                ‐                              100.00% ENDING FUND BALANCE, Mar 31 3,527,023$           1,877,563$              3,482,747$           (44,276)$               1,605,184$           185.49% TRANSPORTATION IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 17 of 36   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.        Transfers ‐ Budgeted transfers will be processed before the end of the year.     A listing of project budgets and balances at March 31 is provided on the following page. The budget for personnel costs is  included in the listing for ease of comparison to total expenditures shown in the table above, but personnel costs are not  considered projects and, therefore, any remaining budget would not be carried forward at the end of the year.      2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 435,693$               ‐$                              ‐$                            (435,693)$              ‐$                            N/A Grants / intergovernmental 90,378                   3,460,752              398,612                308,234                (3,062,140)            11.52% Charges for services ‐                               ‐                               140                        140                        140                        N/A Sale of general fixed assets ‐                              160,000                 160,000                160,000                 ‐                              100.00% Contributions (37,495)                 11,000                     ‐                              37,495                   (11,000)                 0.00% Investment Earnings 89,194                   10,910                    101,531                12,337                   90,621                   930.62% TOTAL REVENUES 577,770                3,642,662              660,283                82,513                   (2,982,379)            18.13% EXPENDITURES: Personnel 84,603                   903,455                 159,999                75,396                   743,456                17.71% Supplies 56,404                   878,203                  ‐                              (56,404)                 878,203                0.00% Contracted Services 41,508                   688,353                 4,604                     (36,904)                 683,749                0.67% Capital Outlay 2,433,587             27,591,431            1,217,740             (1,215,847)            26,373,691           4.41% TOTAL EXPENDITURES 2,616,102             30,061,442            1,382,343             (1,233,759)            28,679,099           4.60% TRANSFERS IN ‐                              4,327,364               ‐                               ‐                              (4,327,364)            0.00% TRANSFERS OUT ‐                              514,460                  ‐                               ‐                              514,460                0.00% NET TRANSFERS ‐                              3,812,904               ‐                               ‐                              (4,841,824)            0.00% CHANGE IN FUND BALANCE (2,038,332)            (22,605,876)          (722,060)               1,316,272             21,883,816           3.19% BEGINNING FUND BALANCE, Jan 1 20,675,238           26,395,567            26,395,567           5,720,329              ‐                              100.00% ENDING FUND BALANCE, Mar 31 18,636,906$        3,789,691$            25,673,507$        7,036,601$           21,883,816$        677.46% MUNICIPAL FACILITIES CIP VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 18 of 36   MUNICIPAL FACILITIES CIP FUND (continued)             PROJECT BUDGET ACTUAL BALANCE CAPITAL PROJECT COORDINATORS 903,455$ 159,999$ 743,456$ SALE OF PARK LAND COSTS 10,000 - 10,000 SUNSET NEIGHBORHOOD PARK ART 224,100 - 224,100 CITY HALL ELEVATORS 2,079,704 20,000 2,059,704 CITY WIDE SECURITY SYSTEM UPGRADES 340,055 32,442 307,613 COMM SVCS MAINT SHOPS REHAB 299,946 - 299,946 SIGN SHOP IMPROVEMENTS 37,719 34,895 2,824 FIRE STATION 15 957,962 638 957,324 RCC MAJOR HVAC COMPONENT REPLACEMENT 1,200,000 - 1,200,000 CITY HALL MAJOR HVAC AND FIRE COMP REPL 396,262 - 396,262 RCC AUDIO AND VIDEO SYSTEMS 200,000 - 200,000 4TH FLOOR POLICE TRAINING CENTER 329,090 173,223 155,867 BOATHOUSE 323,248 - 323,248 HENRY MOSES AQUATIC CENTER 88,644 - 88,644 PARKS RECREATION AND OPEN SPACE PLAN 8,730 - 8,730 REGIS PARK ATHLETIC FIELD EXPANSION 1,400,946 13,003 1,387,943 SPORT COURT IMPROVEMENTS 150,000 - 150,000 PARKING LOT AND DRIVEWAY REPAIRS 215,000 - 215,000 PATHWAY SIDEWALK PATIO BOARDWALK REPLACE 265,215 - 265,215 IRRIGATION AUTOMATION & CONSERVATION 12,072 - 12,072 URBAN FORESTRY PROGRAM 106,044 - 106,044 PARKS MM - PLAYGRDS, KIOSKS & INT SIGNS 605,640 - 605,640 PARKS MM - LIGHT SYSTEM UPGRADES 110,000 - 110,000 PARKS MM - SHORELINE AND BANK STABILIZAT 182,500 - 182,500 PARKS MM - BOUNDARY, TOPOGRAPHIC & SITE 123,886 - 123,886 PARKS MM - STRUCTURAL REVIEWS & REPAIRS 579,667 4,604 575,063 SUNSET EIS PARK 5,226,344 235,600 4,990,744 TRAILS AND BICYCLE MASTER PLAN (1,088) - (1,088) COULON PARK STRUCTURAL IMPROVEMENTS 153,796 1,038 152,759 COULON PARK LIGHTING REPAIRS 34,415 - 34,415 COULON PARK TURF REPLACEMENT 124,788 - 124,788 COULON SWIM BEACH 250,000 - 250,000 KENYON PROPERTY - BUILDING (22) - (22) 2013 KC PROPOSITION 1 CAP EXP LEVY FUND 258,874 - 258,874 PIAZZA REDEVELOPMENT 1,100,000 - 1,100,000 LIBERTY PARK IMPROVEMENTS 1,551,852 - 1,551,852 TRANSPORTATION LANDSCAPE 90,000 - 90,000 PHILIP ARNOLD PARK IMPROVEMENTS 1,430,674 43,127 1,387,547 COULON - ROSEWALL 110,000 - 110,000 PARKS AND PARK BUILDING ADA TRANSITION 75,000 - 75,000 COULON - SHORELINE EROSION 100,000 - 100,000 KIWANIS PARK 1,999,560 50,713 1,948,848 COULON - WATERWALK 4,100,000 10,265 4,089,735 COULON - TRESTLE BRIDGE 1,705,000 - 1,705,000 FAWCETT PROPERTY PURCHASE ROFR 602,364 602,797 (433) TOTAL PROJECT BALANCES 30,061,442$ 1,382,343$ 28,679,099$ MUNICIPAL FACILITIES CIP PROJECT BUDGETS AT MARCH 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 19 of 36   CAPITAL IMPROVEMENT FUND  This fund accounts for the City’s Transportation capital projects.         Transfers ‐ Budgeted transfers will be processed before the end of the year.     A listing of project budgets and balances at March 31 is provided on the following page.    2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 235,301$              22,131,453$        468,834$              233,533$              (21,662,619)$       2.12% Charges for services ‐                              250,000                250,000                250,000                 ‐                              100.00% Fines and penalties 23,930                    ‐                              5,746                     (18,184)                 5,746                     N/A Contributions 4,962                      ‐                               ‐                              (4,962)                     ‐                              N/A Investment Earnings 20,506                    ‐                              62,228                   41,722                   62,228                   N/A TOTAL REVENUES 284,699                22,381,453           786,808                502,109                (21,594,645)         3.52% EXPENDITURES: Personnel 36,002                    ‐                              25,426                   (10,576)                 (25,426)                 N/A Supplies 32,974                    ‐                               ‐                              (32,974)                  ‐                              N/A Contracted Services 4,346                      ‐                              4,475                     129                        (4,475)                    N/A Capital Outlay 842,912                46,419,080           611,111                (231,801)               45,807,969           1.32% TOTAL EXPENDITURES 916,234                46,419,080           641,012                (275,222)               45,778,068           1.38% TRANSFERS IN ‐                              5,358,356              ‐                               ‐                              (5,358,356)            0.00% NET TRANSFERS ‐                              5,358,356              ‐                               ‐                              (5,358,356)            0.00% CHANGE IN FUND BALANCE (631,535)               (18,679,271)         145,796                777,331                18,825,067           N/A BEGINNING FUND BALANCE, Jan 1 5,492,313             18,947,853           18,947,853           13,455,540            ‐                              100.00% ENDING FUND BALANCE, Mar 31 4,860,778$           268,582$              19,093,649$        14,232,871$        18,825,067$        7109.06% CAPITAL IMPROVEMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 20 of 36   CAPITAL IMPROVEMENT FUND (continued)         PROJECT BUDGET ACTUAL BALANCE WALKWAY PGM 217,096$ -$ 217,096$ NE 31ST ST CULVERT 12,228 - 12,228 ARTERIAL CIRCULATION PGM 259,964 9,540 250,423 BRIDGE INSPECTION & REPAIR 236,916 1,886 235,030 ROADWAY SAFETY & GUARDRAIL 54,407 - 54,407 CATCH BASIN REPAIR 250,000 - 250,000 I-405/44TH GATEWAY SIGNAGE 57,700 - 57,700 RENTON CONNECTOR 1,593,294 4,461 1,588,833 STREET OVERLAY PGM 1,855,830 41,497 1,814,333 TRAFFIC SAFETY PGM 260,507 4,475 256,032 PROJ DEV & PRE-DESIGN 285,270 1,050 284,220 SO 7TH ST 135,000 - 135,000 ITS PGM 159,891 - 159,891 NE 3RD/NE 4TH 20,000 - 20,000 RENTON AVE EXT PRES 778,082 6,620 771,461 SW GRADY WAY PRES 7,603 4,688 2,915 DUVALL AVE NE PRES - 115 (115) PARK AVE EXTENSION 7,712,602 62,964 7,649,638 RAINIER AVE S/N PHASE 4 5,689,029 322,708 5,366,321 LOGAN AVE 250,525 - 250,525 INTERSECT SAFETY & MOBILITY 386,935 23,964 362,970 NE 31ST ST BRIDGE REPLACEMENT 251,030 - 251,030 N 27TH PL CULVERT SCOUR REPAIR 71,719 - 71,719 DUVALL AVE 7TH TO SUNSET 6,910,089 69,063 6,841,027 BARRIER FREE 192,141 (5,401) 197,542 SIDEWALK REHAB 283,736 - 283,736 LAKE WASHINGTON LOOP TRAIL 1,099,157 3,987 1,095,170 HIGHLANDS TO LANDING 533,310 17,156 516,154 SUNSET BLVD CORRIDOR 1,394,769 12,295 1,382,474 PRES OF TOD 245,001 9,405 235,596 WILLIAMS AVE S & WELLS AVE S CONV 10,385,423 17,470 10,367,954 CARR RD IMPROVEMENTS 93,676 - 93,676 ARTERIAL REHAB - SW 43RD 220,000 3,630 216,370 BRONSON BRIDGE 611,235 3,765 607,470 HOUSER WAY N BRIDGE 590,985 3,149 587,836 WILLIAMS BRIDGE 713,535 3,149 710,386 NILE BRIDGE - PRELIM ENG 50,000 - 50,000 S 2ND STREET CONVERSION 1,540,750 1,265 1,539,485 HOUSER WAY INT & PED IMP 814,625 18,112 796,513 RENTON SCHOOL CROSSINGS 195,022 - 195,022 TOTAL PROJECT BALANCES 46,419,080$ 641,012$ 45,778,068$ CAPITAL IMPROVEMENT PROJECT BUDGETS AT MARCH 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 21 of 36   HOUSING OPPORTUNITY FUND  This fund has historically been used to account for the Economic Development Reserve and Housing Opportunity Grants.  After a review of the fund, it has been determined that the use of the fund does not qualify as a capital project fund under  Generally Accepted Accounting Principles (GAAP) and the fund is budgeted to be closed. The fund balance will be transferred  to the General Fund in the 2nd quarter of 2020.        NEW LIBRARY DEVELOPMENT FUND  This fund was used to account for the construction of the new Highlands Library and the renovation of the Cedar River Library.  The fund is no longer needed as the library construction projects were complete in 2016. Closure of the fund and a transfer  of the remaining fund balance will be proposed before the end of the year.       2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 9,468$                   6,309$                   6,309$                   (3,159)$                  ‐$                            100.00% TOTAL REVENUES 9,468                     6,309                     6,309                     (3,158)                     ‐                              100.00% EXPENDITURES: Contracted Services 7,281                      ‐                               ‐                              (7,281)                     ‐                              N/A TOTAL EXPENDITURES 7,281                      ‐                               ‐                              (7,281)                     ‐                              N/A TRANSFERS OUT ‐                              2,576,659             25,000                   (25,000)                 2,551,659             0.97% NET TRANSFERS ‐                              (2,576,659)            (25,000)                 25,000                   2,551,659             N/A CHANGE IN FUND BALANCE 2,187                     (2,570,350)            (18,691)                 29,123                   2,551,659             N/A BEGINNING FUND BALANCE, Jan 1 2,582,203             2,570,350             2,570,350             (11,853)                  ‐                              100.00% ENDING FUND BALANCE, Mar 31 2,584,390$            ‐$                            2,551,659$           17,270$                2,551,659$           N/A HOUSING OPPORTUNITY VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 1,662$                    ‐$                            235$                      (1,427)$                 235$                      N/A TOTAL REVENUES 1,662                      ‐                              235                        (1,427)                    235                        N/A TOTAL EXPENDITURES ‐                               ‐                               ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                               ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 1,662                      ‐                              235                        (1,427)                    235                        N/A BEGINNING FUND BALANCE, Jan 1 456,591                16,408                   16,408                   (440,183)                ‐                              100.00% ENDING FUND BALANCE, Mar 31 458,253$              16,408$                16,643$                (441,610)$             235$                      101.43% NEW LIBRARY DEVELOPMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 22 of 36   FAMILY FIRST CENTER FUND  This fund is used to account for the construction of the new Family First Center. Funds accumulated for the construction of  the Family First Center are maintained in the fund balance until such time that Council authorizes their use through the  approval of contracts and additional project budget is established through the budget adjustment process.        Note ‐ Additional funds designated for the Family First Center are being held in a fund with the Renton Community Foundation  (Foundation). Those funds are not reflected in the City’s records as they are assets of the Foundation, not the City. The City  must apply to the Foundation to receive the funds. Funds transferred from the Foundation will be recorded as contribution  revenue when received by the City.        2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental ‐$                            75,000$                 ‐$                             ‐$                            (75,000)$               0.00% Contributions 37,495                    ‐                               ‐                              (37,495)                  ‐                              N/A Investment Earnings 15,362                    ‐                              28,052                   12,690                   28,052                   N/A TOTAL REVENUES 52,857                   75,000                   28,052                   (24,805)                 (46,948)                 37.40% EXPENDITURES: Capital Outlay 41,012                   648,948                163,516                122,504                485,432                25.20% TOTAL EXPENDITURES 41,012                   648,948                163,516                122,504                485,432                25.20% NET TRANSFERS ‐                               ‐                               ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 11,845                   (573,948)               (135,464)               (147,309)               438,484                N/A BEGINNING FUND BALANCE, Jan 1 4,193,806             8,551,401             8,551,401             4,357,595              ‐                              100.00% ENDING FUND BALANCE, Mar 31 4,205,651$           7,977,453$           8,415,937$           4,210,286$           438,484$              105.50% FAMILY FIRST CENTER VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 23 of 36   ENTERPRISE FUNDS  Enterprise funds are used to account for operations that are financed and operated in a manner similar to private business  enterprises. YTD budgets are not prepared for Enterprise Funds.     Most Enterprise Funds maintain two separate “management funds”, an operating fund and a capital fund. The funds are  consolidated for budget/reporting purposes. Operating budgets lapse at the end of the year. Project budgets are adopted  when funding is secured and balances are carried forward each year until they are either 1) fully spent or 2) reallocated to  another project through the budget adjustment process. A listing of project balances for each Enterprise Fund is included,  along with a reconciliation to the amounts reported as “Capital Projects”.     AIRPORT FUND  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Renton Municipal Airport.           2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 49,750$            ‐$                              ‐$                       (49,750)$           ‐$                       N/A Charges for services 67,876              145,557                  29,852              (38,024)            (115,705)          20.51% Rents, leases, and misc fees 663,965           2,902,353               768,019           104,054           (2,134,334)       26.46% Interest and other misc 19,364              3,857                       21,467              2,103                17,610              556.57% TOTAL REVENUES 800,955           3,051,767               819,338           18,383              (2,232,429)       26.85% EXPENSES: Personnel 272,085           1,172,998               272,259           (174)                  900,739           23.21% Supplies 17,226              43,500                    2,737                14,489              40,763              6.29% Contracted Services 90,946              509,588                  95,942              (4,996)               413,646           18.83% Internal Services 80,920              340,860                  85,681              (4,761)               255,179           25.14% TOTAL OPERATING EXPENSES 461,177           2,066,946               456,619           4,558                1,610,327        22.09% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 339,778           984,821                  362,719           22,941              (622,102)          36.83% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 8,957                6,030,883               132,819           (123,862)          5,898,064        2.20% TRANSFERS OUT ‐                          ‐                                1,363                (1,363)               (1,363)               N/A NET TRANSFERS ‐                          ‐                                (1,363)               (1,363)               (1,363)               N/A CHANGE IN FUND BALANCE 330,821           (5,046,062)             228,537           (102,284)          5,274,599        N/A BEGINNING FUND BALANCE, Jan 1 4,985,377        6,259,402               6,259,402        1,274,025         ‐                         100.00% ENDING FUND BALANCE, Mar 31 5,316,198$      1,213,340$            6,487,939$      1,171,741$      5,274,599$      534.72% VARIANCE AIRPORT PROJECT BUDGET ACTUAL BALANCE MAINTENANCE DREDGING & SHORELINE MITIGAT 60,050$ -$ 60,050$ AIRPORT OFFICE REHAB 2,763,289 41,894 2,721,395 MAJOR FACILITY MAINTENANCE 417,264 73,479 343,785 SURFACE WATER SYSTEM REHABILITATION 44,496 - 44,496 PAVEMENT MANAGEMENT PROGRAM 255,930 - 255,930 SNOW REMOVAL EQUIPMENT 200,000 - 200,000 TAXIWAY ALPHA REHABILITATION 1,115,495 - 1,115,495 RUNWAY SAFETY AREA 774,359 - 774,359 ENVIRONMENTAL IMPACT STUDY 400,000 - 400,000 TOTAL PROJECT BALANCES 6,030,883$ 115,373$ 5,915,510$ Operating fund equipment purchase - 17,446 (17,446) TOTAL CAPITAL OUTLAY 6,030,883$ 132,819$ 5,898,064$ AIRPORT PROJECT BALANCES AT MARCH 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 24 of 36   GOLF COURSE FUND  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Maplewood Golf Course.        Ending Fund Balance ‐ The Golf Course fund balance is negative at March 31. This is not uncommon as November through  March is considered “off‐season”. The Golf Course has ended the 1st quarter with negative fund balance for at least each of  the last five years, but has generated enough revenue during “peak‐season” to bring the fund balance to a positive position  to end the year.     Capital Outlay ‐ The Golf Course has $20K budgeted for capital in 2020. This budget is for equipment purchases in the  operating fund and is not related to a capital project.        2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 214,995$         2,294,800$            280,571$         65,576$           (2,014,229)$    12.23% Rents, leases, and misc fees 46,634              500,750                  47,169              535                   (453,581)          9.42% Interest and other misc 3,515                1,370                       1,611                (1,904)               241                   117.59% TOTAL REVENUES 265,144           2,796,920               329,351           64,207              (2,467,569)       11.78% EXPENSES: Personnel 321,245           1,675,295               333,370           (12,125)            1,341,925        19.90% Supplies 87,877              321,500                  79,643              8,234                241,857           24.77% Contracted Services 26,302              205,050                  35,414              (9,112)               169,636           17.27% Internal Services 64,500              352,407                  88,102              (23,602)            264,305           25.00% TOTAL OPERATING EXPENSES 499,924           2,554,252               536,529           (36,605)            2,017,723        21.01% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (234,780)          242,668                  (207,178)          27,602              (449,846)           ‐85.38% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 14,140              20,000                     ‐                         14,140              20,000              0.00% TRANSFERS IN 18,000              76,000                    19,000              1,000                (57,000)            25.00% TRANSFERS OUT 18,000              76,000                    21,695              (3,695)               54,305              28.55% NET TRANSFERS ‐                          ‐                                (2,695)               (2,695)               (2,695)               N/A CHANGE IN FUND BALANCE (248,920)          222,668                  (209,873)          39,047              (432,541)           ‐94.25% BEGINNING FUND BALANCE, Jan 1 110,812           173,750                  173,750           62,938               ‐                         100.00% ENDING FUND BALANCE, Mar 31 (138,108)$        396,418$                (36,123)$          101,985$         (432,541)$         ‐9.11% GOLF COURSE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 25 of 36   SOLID WASTE FUND  This fund accounts for revenues and expenses for administration and operating of solid waste, recycling, and yard waste  collection services for the City.         Charges for services ‐ The increase in charges for services over the prior year is due to increased rates. The majority of the  increase is coming from commercial and multi‐family steel collections.    Contracted Services ‐ The increase in contracted services expense over the prior year is due to increased payments to the  garbage contractor, which directly relates to the increased rates, as noted above.    Capital Outlay ‐ The Solid Waste Fund does not have a capital fund.   2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 18,898$           268,631$                89,664$           70,766$           (178,967)$        33.38% Charges for services 4,840,174        19,343,186            5,258,251        418,077           (14,084,935)    27.18% Interest and other misc 9,773                5,000                       9,894                121                   4,894                197.88% TOTAL REVENUES 4,868,845        19,616,817            5,357,809        488,964           (14,259,008)    27.31% EXPENSES: Personnel 146,220           631,060                  155,464           (9,244)               475,596           24.64% Supplies 825                   11,900                    617                   208                   11,283              5.18% Contracted Services 4,074,437        18,344,816            4,259,450        (185,013)          14,085,366      23.22% Internal Services 118,267           488,873                  128,547           (10,280)            360,326           26.29% TOTAL OPERATING EXPENSES 4,339,749        19,476,649            4,544,078        (204,329)          14,932,571      23.33% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 529,096           140,168                  813,731           284,635           673,563           580.54% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 529,096           140,168                  813,731           284,635           673,563           580.54% BEGINNING FUND BALANCE, Jan 1 2,276,333        2,266,127               2,266,127        (10,206)             ‐                         100.00% ENDING FUND BALANCE, Mar 31 2,805,429$      2,406,295$            3,079,858$      274,429$         673,563$         127.99% SOLID WASTE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 26 of 36   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.           2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 3,728,041$      19,180,991$          3,640,732$      (87,309)$          (15,540,259)$  18.98% Rents, leases, and misc fees 36,487              136,591                  48,809              12,322              (87,782)            35.73% Interest and other misc 176,416           199,070                  319,283           142,867           120,213           160.39% TOTAL REVENUES 3,940,944        19,516,652            4,008,824        67,880              (15,507,828)    20.54% EXPENSES: Personnel 1,082,706        4,823,623               1,077,640        5,066                3,745,983        22.34% Supplies 166,645           885,590                  171,772           (5,127)               713,818           19.40% Contracted Services 672,532           3,224,874               708,814           (36,282)            2,516,060        21.98% Internal Services 551,673           2,465,733               581,918           (30,245)            1,883,815        23.60% TOTAL OPERATING EXPENSES 2,473,556        11,399,820            2,540,144        (66,588)            8,859,676        22.28% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,467,388        8,116,832               1,468,680        1,292                (6,648,152)       18.09% DEBT SERVICE: Principal ‐                         1,540,568                ‐                          ‐                         1,540,568        0.00% Interest ‐                         241,747                   ‐                          ‐                         241,747           0.00% TOTAL DEBT SERVICE ‐                         1,782,315                ‐                          ‐                         1,782,315        0.00% CAPITAL OUTLAY 483,101           37,304,963            744,955           (261,854)          36,560,008      2.00% TRANSFERS OUT ‐                          ‐                                330                   (330)                  (330)                  N/A NET TRANSFERS ‐                          ‐                                (330)                  (330)                  (330)                  N/A CHANGE IN FUND BALANCE 984,287           (30,970,446)           723,395           (260,892)          31,693,841      N/A BEGINNING FUND BALANCE, Jan 1 38,002,973      37,569,067            37,569,067      (433,906)           ‐                         100.00% ENDING FUND BALANCE, Mar 31 38,987,260$   6,598,621$            38,292,462$   (694,798)$        31,693,841$   580.31% WATER UTILITY VARIANCE PROJECT BUDGET ACTUAL BALANCE PIPE OVERSIZING COSTS 100,000$ -$ 100,000$ TELEMETRY IMPROVEMENTS-PHASE 4 250,000 223 249,777 WATER SYSTEM PLAN UPDATE 200,000 28,555 171,445 UPDATE EMERGENCY RESPONSE PLAN 250,000 - 250,000 STEEL/AC WATERMAIN REPLC PLAN 1,500,000 7,618 1,492,382 RESERVOIR RECOATING 200,000 - 200,000 EMERGENCY RESPONSE PROJ 100,000 - 100,000 DOWNTOWN WATER MAIN REPLACEMENT 3,500,000 64,426 3,435,574 GPS & GIS DATABASE/CONVERSION - (4,432) 4,432 WATER PUMP STATIONS REHAB 400,000 - 400,000 RESERVOIR PRV METERS 300,000 4,086 295,915 MPLWD WATER TREATMENT IMPROV - CONST 400,000 - 400,000 MAPLEWOOD PUMP STATION ROOF REPLACEMENT - 2,445 (2,445) HIGHLANDS WATER MAIN IMPROVEMENT 1,100,000 15,822 1,084,178 DUVALL AVE NE WATER MAIN REPLACEMENT 360,000 - 360,000 EMERGENCY POWER TO PUMP STATION 300,000 - 300,000 WATER SYSTEM SECURITY IMPROVEMENTS 100,000 - 100,000 AQUIFER MONITORING AND MANAGEMENT 30,000 - 30,000 WATER TREATMENT FILTER MEDIA 400,000 579 399,421 WSDOT I-405 WATER RELOCATIONS 300,000 1,346 298,654 AUTOMATIC METER READING CONVERSION 85,000 - 85,000 TRANSMISSION MAIN REPLACEMENT - (248) 248 HIGHLANDS 435-RESERVOIRS REPLACEMENT 23,100,000 8,918 23,091,082 RAINIER AVE S ROAD & UTILITIES IMPRVMNT 300,000 - 300,000 KENNYDALE 320-RESERVOIR 4,000,000 645,519 3,354,481 TOTAL PROJECT BALANCES 37,275,000$ 774,856$ 36,500,144$ Non-capital items included in project budgets - (29,901) 29,901 Operating fund equipment purchase 29,963 - 29,963 TOTAL CAPITAL OUTLAY 37,304,963$ 744,955$ 36,560,008$ WATER UTILITY FUND PROJECT BALANCES AT MARCH 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 27 of 36   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.             2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 27,425$           61,802$                  31,775$           4,350$              (30,027)$          51.41% Charges for services 2,713,107        11,248,216            2,718,672        5,565                (8,529,544)       24.17% Fines and penalties 176                    ‐                                 ‐                         (176)                   ‐                         N/A Interest and other misc 118,705           320,766                  195,402           76,697              (125,364)          60.92% TOTAL REVENUES 2,859,413        11,630,784            2,945,849        86,436              (8,684,935)       25.33% EXPENSES: Personnel 526,688           2,466,376               567,578           (40,890)            1,898,798        23.01% Supplies 7,806                73,842                    9,863                (2,057)               63,979              13.36% Contracted Services 518,804           2,969,297               485,390           33,414              2,483,907        16.35% Internal Services 394,185           1,651,970               417,264           (23,079)            1,234,706        25.26% TOTAL OPERATING EXPENSES 1,447,483        7,161,485               1,480,095        (32,612)            5,681,390        20.67% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,411,930        4,469,299               1,465,754        53,824              (3,003,545)       32.80% DEBT SERVICE: Principal ‐                         601,300                   ‐                          ‐                         601,300           0.00% Interest ‐                         108,921                   ‐                          ‐                         108,921           0.00% TOTAL DEBT SERVICE ‐                         710,221                   ‐                         ‐                         710,221           0.00% CAPITAL OUTLAY 440,958           18,168,200            147,176           293,782           18,021,024      0.81% TRANSFERS IN 28,356               ‐                                 ‐                         (28,356)             ‐                         N/A NET TRANSFERS 28,356               ‐                                 ‐                         (28,356)             ‐                         N/A CHANGE IN FUND BALANCE 999,328           (14,409,122)           1,318,578        319,250           15,727,700      N/A BEGINNING FUND BALANCE, Jan 1 18,879,201      19,832,351            19,832,351      953,150            ‐                         100.00% ENDING FUND BALANCE, Mar 31 19,878,529$   5,423,229$            21,150,929$   1,272,400$      15,727,700$   390.01% WASTEWATER UTILITY VARIANCE PROJECT BUDGET ACTUAL BALANCE MISCELANEOUS SEWER PROJECTS 335,000$ (123)$ 335,123$ 2008 LONG-RANGE WW MANAG PLAN 97,000 2,748 94,252 WASTEWATER OPERATIONS MASTER PLAN 774,000 - 774,000 FALCON RIDGE LS REHAB - 59 (59) THUNDER HILL INT REPL/REHAB 3,110,000 8,876 3,101,124 FORCE MAIN REHABILITATION REPLACEMENT 1,487,000 5,680 1,481,320 LIFT STATION REHABILITATION 1,891,000 7,329 1,883,671 DOWNTOWN SEWER REPLACEMENT/REHAB 4,187,000 102,559 4,084,441 2019 SANITARY SEWER REHAB/REPLACEMENT - 4,108 (4,108) 2020 SANITARY SEWER REHAB/REPLACEMENT 3,750,000 16,546 3,733,454 KENNYDALE LAKELINE SEWER UPGRADE 3,398,000 640 3,397,360 TOTAL PROJECT BALANCES 19,029,000$ 149,357$ 18,879,643$ Non-capital items included in project budgets (871,000) (2,181) (868,819) Operating fund equipment purchase 10,200 - 10,200 TOTAL CAPITAL OUTLAY 18,168,200$ 147,176$ 18,021,024$ WASTEWATER UTILITY FUND PROJECT BALANCES AT MARCH 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 28 of 36   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.          2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 9,750$              50,456$                  23,225$           13,475$           (27,231)$          46.03% Grants / intergovernmental 609,384           12,356,399            560,614           (48,770)            (11,795,785)    4.54% Charges for services 2,923,482        13,000,699            2,939,386        15,904              (10,061,313)    22.61% Interest and other misc 72,776              135,163                  147,608           74,832              12,445              109.21% TOTAL REVENUES 3,615,392        25,542,717            3,670,833        55,441              (21,871,884)    14.37% EXPENSES: Personnel 851,200           3,623,525               876,981           (25,781)            2,746,544        24.20% Supplies 24,205              175,848                  32,131              (7,926)               143,717           18.27% Contracted Services 349,706           4,319,156               373,515           (23,809)            3,945,641        8.65% Internal Services 482,764           2,105,058               520,698           (37,934)            1,584,360        24.74% TOTAL OPERATING EXPENSES 1,707,875        10,223,587            1,803,325        (95,450)            8,420,262        17.64% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,907,517        15,319,130            1,867,508        (40,009)            (13,451,622)    12.19% DEBT SERVICE: Principal ‐                         488,950                   ‐                          ‐                         488,950           0.00% Interest 130,003           640,845                  130,000           3                        510,845           20.29% TOTAL DEBT SERVICE 130,003           1,129,795               130,000           3                        999,795           11.51% CAPITAL OUTLAY 351,324           20,214,602            379,244           (27,920)            19,835,358      1.88% NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 1,426,190        (6,025,267)             1,358,264        (67,926)            7,383,531        N/A BEGINNING FUND BALANCE, Jan 1 16,356,030      18,377,556            18,377,556      2,021,526         ‐                         100.00% ENDING FUND BALANCE, Mar 31 17,782,220$   12,352,289$          19,735,820$   1,953,600$      7,383,531$      159.77% SURFACE WATER UTILITY VARIANCE PROJECT BUDGET ACTUAL BALANCE COMP S&SW MGMT PLAN P&D 172,034$ 21,793$ 150,241$ SM DRAINAGE PROBLEMS 683,923 59,148 624,775 PANTHER CR WL MOSQUITO ABATEMENT 89,767 381 89,386 MADSEN CREEK SEDIMENT BASIN 83,738 7,607 76,131 SMALL DRAINAGE PROJ-MAPLEWOOD SEDIMENT 111,314 181 111,132 WETLAND MITIGATION BANK 160,345 2,774 157,571 ACOE 205 PROJECT 61,693 723 60,970 CEDAR RIVER GRAVEL REMOVAL 2,902,163 39,362 2,862,801 RENTON STORM WATER MANUAL 75,815 1,306 74,510 GREEN RIVER ECOSYSTEM STUDY 48,336 159 48,177 MISCELLANEOUS/EMERGENCY/STORM PROJECTS 100,000 - 100,000 SURFACE WATER UTILITY GIS 125,382 21,007 104,375 HARDIE AVE S UNDERPASS STORM SYSTEM IMPR 2,391 - 2,391 MONROE AVE/N 2ND ST 378,837 35,745 343,092 STORMWATER FACILITY FENCING PROJECT 265,101 2,832 262,269 CEDAR RIVER 205 LEVEE RECERTIFICATION 4,854,386 69,949 4,784,437 SE 172ND ST/125TH AVE SE 182,561 47,040 135,521 RAINIER AVE/OAKSDALE AVE PUMP STATION UP 207,467 4,549 202,918 NE 16TH/JEFFERSON AVE NE 2,768,213 73,605 2,694,608 DOWNTOWN STORM SYSTEM IMPROVEMENT PROJEC 6,030,270 91,668 5,938,602 HEATHER DOWNS DETENTION POND 693,543 4,140 689,403 MADSEN CRK IMPROV PHASE 1-KCFCD 1,033,096 22,035 1,011,061 RAINIER AVE/BENSON RD S - CULVERT REPL 200,610 7,730 192,880 CMP STORM SYSTEM REPLACEMENT PROJECT 589,934 3,512 586,422 CEDAR RIVER FLOOD RISK REDUCTION 499,658 1,700 497,958 STORMWATER FACILITY RETROFIT STUDY 300,000 812 299,188 BURNETT AVE S/WILLIAMS AVE S 467,629 74 467,554 WSDOT LA ROW RUNOFF IMPACT MITIGATION - - - TOTAL PROJECT BALANCES 23,088,205$ 519,830$ 22,568,375$ Non-capital items included in project budgets (2,902,163) (140,587) (2,761,576) Operating fund equipment purchase 28,560 - 28,560 TOTAL CAPITAL OUTLAY 20,214,602$ 379,244$ 19,835,358$ SURFACE WATER UTILITY PROJECT BALANCES AT MARCH 31, 2020 Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 29 of 36   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 Metro Fund does not have a capital fund.     2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 4,298,504$      17,007,226$          4,277,356$      (21,148)$          (12,729,870)$  25.15% Interest and other misc 25,450               ‐                                20,073              (5,377)               20,073              N/A TOTAL REVENUES 4,323,954        17,007,226            4,297,429        (26,525)            (12,709,797)    25.27% EXPENSES: Contracted Services 4,208,170        17,007,226            4,244,070        (35,900)            12,763,156      24.95% TOTAL OPERATING EXPENSES 4,208,170        17,007,226            4,244,070        (35,900)            12,763,156      24.95% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 115,784            ‐                                53,359              (62,425)            53,359              N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 115,784            ‐                                53,359              (62,425)            53,359              N/A BEGINNING FUND BALANCE, Jan 1 5,512,418        5,961,906               5,961,906        449,488            ‐                         100.00% ENDING FUND BALANCE, Mar 31 5,628,202$      5,961,906$            6,015,265$      387,063$         53,359$           100.89% METRO VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 30 of 36   INTERNAL SERVICE FUNDS  Internal service funds are used to account for the goods and services furnished by one City department to other City  departments on a cost reimbursement basis. YTD budgets are not prepared for Internal Service Funds.    EQUIPMENT RENTAL FUND  This fund accounts for revenues and expenses for administration, purchase, and maintenance of the City’s vehicle and  equipment Fleet services. Departments pay in monthly amounts for maintenance and operations. Replacement reserves are  paid monthly over the estimated useful lives of each individual vehicle or piece of equipment. These reverses are accumulated  in fund balance so that they are available to fund the replacement of the vehicle/equipment when the time comes.         Interdepartmental services ‐ Increases in interdepartmental services revenues over the prior year are due to the addition of  police take‐home vehicles.     2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 6,658$               ‐$                             12,773$           6,115$              12,773$           N/A Interdepartmental services 1,311,987        5,650,319               1,433,622        121,635           (4,216,697)       25.37% Interest and other misc 30,973              12,000                    22,877              (8,096)               10,877              190.64% TOTAL REVENUES 1,349,618        5,662,319               1,469,272        119,654           (4,193,047)       25.95% EXPENSES: Personnel 288,656           1,224,163               288,607           49                      935,556           23.58% Supplies 289,194           1,496,153               252,045           37,149              1,244,108        16.85% Contracted Services 58,155              133,166                  58,341              (186)                  74,825              43.81% Internal Services 7,370                36,694                    9,173                (1,803)               27,521              25.00% TOTAL OPERATING EXPENSES 643,375           2,890,176               608,166           35,209              2,282,010        21.04% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 706,243           2,772,143               861,106           154,863           (1,911,037)       31.06% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 548,903           4,064,000               272,735           276,168           3,791,265        6.71% NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 157,340           (1,291,857)             588,371           431,031           1,880,228        N/A BEGINNING FUND BALANCE, Jan 1 6,493,018        6,851,811               6,851,811        358,793            ‐                         100.00% ENDING FUND BALANCE, Mar 31 6,650,358$      5,559,954$            7,440,182$      789,824$         1,880,228$      133.82% EQUIPMENT RENTAL VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 31 of 36   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.        Contracted Services ‐ The increase in contracted services expenses over the prior year are due to Liability claims paid.     2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Interdepartmental services 764,124$         3,193,962$            786,525$         22,401$           (2,407,437)$    24.63% Interest and other misc 111,689           197,000                  75,560              (36,129)            (121,440)          38.36% TOTAL REVENUES 875,813           3,390,962               862,085           (13,728)            (2,528,877)       25.42% EXPENSES: Personnel 252,988           1,484,232               258,715           (5,727)               1,225,517        17.43% Supplies ‐                         6,956                       374                   (374)                  6,582                5.38% Contracted Services 518,535           1,858,146               655,659           (137,124)          1,202,487        35.29% TOTAL OPERATING EXPENSES 771,523           3,349,334               914,748           (143,225)          2,434,586        27.31% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 104,290           41,628                    (52,663)            (156,953)          (94,291)             ‐126.51% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TRANSFERS OUT ‐                         900,000                   ‐                          ‐                         900,000           0.00% NET TRANSFERS ‐                         (900,000)                  ‐                          ‐                         900,000           N/A CHANGE IN FUND BALANCE 104,290           (858,372)                 (52,663)            (156,953)          805,709           N/A BEGINNING FUND BALANCE, Jan 1 18,522,154      19,095,508            19,095,508      573,354            ‐                         100.00% ENDING FUND BALANCE, Mar 31 18,626,444$   18,237,136$          19,042,845$   416,401$         805,709$         104.42% INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 32 of 36   INFORMATION TECHNOLOGY FUND  This fund accounts for the administration, purchase, and operation of the City’s information technology systems, including  computer hardware and software, network servers and infrastructure, phone systems, and cell phones. Expenses are paid by  the Information Technology Fund and rates are charged to departments based on use.         Interdepartmental services ‐ Increased interdepartmental services revenue over the prior year is due to increased costs in  personnel and contracted services being charged back to the departments.     Personnel ‐ Increased personnel costs over the prior year are the result of COLAs and allocating ½ of the Administrative  Services Administrator payroll costs to the IT division beginning in January 2020.    Contracted Services ‐ Increased contracted services expenses over the prior year are the result of increased service contract  costs primarily associated with added cameras and computers in police take‐home vehicles.     2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Licenses and permits 84,680$           150,000$                74,067$           (10,613)$          (75,933)$          49.38% Interdepartmental services 1,238,247        5,761,238               1,446,529        208,282           (4,314,709)       25.11% Interest and other misc 14,589              7,000                       17,057              2,468                10,057              243.67% TOTAL REVENUES 1,337,516        5,918,238               1,537,653        200,137           (4,380,585)       25.98% EXPENSES: Personnel 691,964           3,215,906               761,501           (69,537)            2,454,405        23.68% Supplies 109,872           1,078,155               119,770           (9,898)               958,385           11.11% Contracted Services 558,925           2,467,051               626,629           (67,704)            1,840,422        25.40% Internal Services 391                   1,804                       451                   (60)                    1,353                25.00% TOTAL OPERATING EXPENSES 1,361,152        6,762,916               1,508,351        (147,199)          5,254,565        22.30% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (23,636)            (844,678)                 29,302              52,938              873,980           N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 30,348              1,313,500               14,520              15,828              1,298,980        1.11% TRANSFERS IN 22,676              9,630                       5,745                (16,931)            (3,885)               59.66% NET TRANSFERS 22,676              9,630                       5,745                (16,931)            (3,885)               59.66% CHANGE IN FUND BALANCE (31,308)            (2,148,548)             20,527              51,835              2,169,075        N/A BEGINNING FUND BALANCE, Jan 1 3,934,408        4,490,062               4,490,062        555,654            ‐                         100.00% ENDING FUND BALANCE, Mar 31 3,903,100$      2,341,514$            4,510,589$      607,489$         2,169,075$      192.64% INFORMATION TECHNOLOGY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 33 of 36   FACILITIES FUND  This fund accounts for the administration, maintenance, and operation of City‐owned facilities. Expenses are paid by the  Facilities Fund and rates are charged to departments based on square footage.         Interdepartmental services ‐ The increase in interdepartmental services revenue over the prior year is primarily due to no  longer providing Facility services to the Renton Regional Fire Authority (RRFA). In 2019, the RRFA contributed $844K in  revenue to the Facilities division, which included charges for some direct costs (supplies, utilities, and repairs/maintenance  of the fire stations), but also covered a portion of overhead that now must be absorbed fully by City departments.     Personnel ‐ The increase in personnel costs over the prior year is due to the conversion of supplemental staff to regular  (benefitted) employees and moving 100% of the Golf Course custodian’s salary and benefits to the Facilities Fund, with an  offsetting increase in interdepartmental services revenue, rather than splitting the cost between the two funds as was prior  practice.    Supplies ‐ The increase in supplies expense over the prior year is due to new AED devices installed in City facilities and  custodial supply purchases.     2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental ‐$                        ‐$                             21,835$           21,835$           21,835$           N/A Interdepartmental services 1,107,871        5,321,386               1,312,128        204,257           (4,009,258)       24.66% Rents, leases, and misc fees ‐                          ‐                                39,250              39,250              39,250              N/A Interest and other misc 5,360                4,000                       4,388                (972)                  388                   109.70% TOTAL REVENUES 1,113,231        5,325,386               1,377,601        264,370           (3,947,785)       25.87% EXPENSES: Personnel 690,019           3,828,616               779,843           (89,824)            3,048,773        20.37% Supplies 87,151              328,468                  170,290           (83,139)            158,178           51.84% Contracted Services 386,901           1,869,621               366,201           20,700              1,503,420        19.59% Internal Services 16,312              76,045                    19,011              (2,699)               57,034              25.00% TOTAL OPERATING EXPENSES 1,180,383        6,102,750               1,335,345        (154,962)          4,767,405        21.88% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (67,152)            (777,364)                 42,256              109,408           819,620           N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 12,539               ‐                                5,704                6,835                (5,704)               N/A TRANSFERS IN ‐                         2,880                       7,459                7,459                4,579                258.99% TRANSFERS OUT 5,000                 ‐                                 ‐                         5,000                 ‐                         N/A NET TRANSFERS (5,000)               2,880                       7,459                12,459              4,579                258.99% CHANGE IN FUND BALANCE (84,691)            (774,484)                 44,011              128,702           818,495           N/A BEGINNING FUND BALANCE, Jan 1 1,376,859        1,220,276               1,220,276        (156,583)           ‐                         100.00% ENDING FUND BALANCE, Mar 31 1,292,168$      445,792$                1,264,287$      (27,881)$          818,495$         283.60% FACILITIES VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 34 of 36   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.         2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental ‐$                       80,000$                   ‐$                        ‐$                       (80,000)$          0.00% Interdepartmental services 276,168           1,133,441               283,360           7,192                (850,081)          25.00% Interest and other misc 2,496                1,000                       2,704                208                   1,704                270.40% TOTAL REVENUES 278,664           1,214,441               286,064           7,400                (928,377)          23.56% EXPENSES: Personnel 201,285           876,967                  223,519           (22,234)            653,448           25.49% Supplies 6,193                77,579                    11,959              (5,766)               65,620              15.42% Contracted Services 73,071              342,365                  52,388              20,683              289,977           15.30% Internal Services 744                   3,941                       985                   (241)                  2,956                24.99% TOTAL OPERATING EXPENSES 281,293           1,300,852               288,851           (7,558)               1,012,001        22.20% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (2,629)               (86,411)                   (2,787)               (158)                  83,624              N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TRANSFERS OUT ‐                          ‐                                329                   (329)                  (329)                  N/A NET TRANSFERS ‐                          ‐                                (329)                  (329)                  (329)                  N/A CHANGE IN FUND BALANCE (2,629)               (86,411)                   (3,116)               (487)                  83,295              N/A BEGINNING FUND BALANCE, Jan 1 685,593           803,561                  803,561           117,968            ‐                         100.00% ENDING FUND BALANCE, Mar 31 682,964$         717,150$                800,445$         117,481$         83,295$           111.61% COMMUNICATIONS VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 35 of 36   HEALTH INSURANCE FUND  This fund accounts for the City’s self‐insured health insurance program. Expenses/claims are paid by the Health Insurance  Fund and rates are charged to employees and departments based on annual premiums determined by the City’s Employee  Health Plan Board for each type of coverage elected by the employee; paid semi‐monthly in conjunction with each payroll.         Premiums ‐ Premiums revenue increased over the prior year due to 1) increased rates and 2) additional FTEs.    Personnel – Personnel costs increased over the prior year due to increased medical and dental claims.      2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Premiums 2,770,653$      12,603,106$            3,029,358$      258,705$         (9,573,748)$    24.04% Interest and other misc 17,580              46,588                       17,996              416                   (28,592)            38.63% TOTAL REVENUES 2,788,233        12,649,694               3,047,354        259,121           (9,602,340)       24.09% EXPENSES: Personnel 2,180,636        12,011,435               2,487,535        (306,899)          9,523,900        20.71% Supplies ‐                         7,500                         6,881                (6,881)               619                   91.75% Contracted Services 108,416           447,416                    134,810           (26,394)            312,606           30.13% Internal Services 14,513              60,430                       15,107              (594)                  45,323              25.00% TOTAL OPERATING EXPENSES 2,303,565        12,526,781               2,644,333        (340,768)          9,882,448        21.11% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 484,668           122,913                    403,021           (81,647)            280,108           327.89% TOTAL DEBT SERVICE ‐                          ‐                                   ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                   ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                   ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 484,668           122,913                    403,021           (81,647)            280,108           327.89% BEGINNING FUND BALANCE, Jan 1 4,259,511        5,151,648                 5,151,648        892,137            ‐                         100.00% ENDING FUND BALANCE, Mar 31 4,744,179$      5,274,561$               5,554,669$      810,490$         280,108$         105.31% HEALTH INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 1st Quarter 2020  Page 36 of 36   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.         Personnel ‐ The increase in personnel costs over the prior year is due to an increase in prescription costs and payments for  long‐term care, a benefit not previously being utilized.    CONTACT INFORMATION  This report is prepared by the Finance Division of the Administrative Services Department. For additional financial  information, please also review our website: http://www.rentonwa.gov/.  For any questions about the report, please feel  free to contact Misty Baker at mbaker@rentonwa.gov or Jan Hawn at jhawn@rentonwa.gov.  2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 35,898$           45,014$                  35,245$           (653)$                (9,769)$            78.30% Premiums 656,168           1,131,989               656,171           3                        (475,818)          57.97% Interest and other misc 51,568              67,459                    53,283              1,715                (14,176)            78.99% TOTAL REVENUES 743,634           1,244,462               744,699           1,065                (499,763)          59.84% EXPENSES: Personnel 176,071           1,209,429               299,055           (122,984)          910,374           24.73% Contracted Services 14,075              38,814                    12,742              1,333                26,072              32.83% TOTAL OPERATING EXPENSES 190,146           1,248,243               311,797           (121,651)          936,446           24.98% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 553,488           (3,781)                     432,902           (120,586)          436,683           N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 553,488           (3,781)                     432,902           (120,586)          436,683           N/A BEGINNING FUND BALANCE, Jan 1 13,876,628      15,799,729            15,799,729      1,923,101         ‐                         100.00% ENDING FUND BALANCE, Mar 31 14,430,116$   15,795,948$          16,232,631$   1,802,515$      436,683$         102.76% RETIREE HEALTHCARE VARIANCE