Loading...
HomeMy WebLinkAboutQUARTER 2 2020Page 1 of 38   OVERVIEW  This quarterly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through June 30, 2020.  A detailed analysis, including current to prior year and budget to actual comparison is included for each City fund. Excluded  from this report are the City’s fiduciary funds as these funds are held on behalf of others and are not available for City use.  Budget figures shown include adjustments adopted through Ordinance 5975, which includes budget cuts in response to  COVID‐19. Revenue budgets for 2020 have not been reduced to‐date as the annual impact of COVID‐19 is still uncertain.  Adjustments to the revenue budgets will be proposed to Council prior to the end of the year.    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 41,485,222$      81,535,404$    42,516,785$ 39,938,915$   (1,546,307)$   (2,577,870)     48.98% Licenses & Permits 3,122,404            5,550,877          3,104,445       2,730,287         (392,117)           (374,158)         49.19% Intergovernmental 1,996,380            6,006,330          2,228,163       2,011,472         15,092               (216,691)         33.49% Charges for Services 4,382,763            8,968,213          4,446,529       3,922,097         (460,666)           (524,432)         43.73% Fines and Penalties 2,248,545            4,759,187          1,869,646       1,734,081         (514,464)           (135,565)         36.44% Miscellaneous 1,855,228            2,796,165          1,376,295       1,487,586         (367,642)           111,291           53.20% Other Financing Sources (Transfer‐In, etc) 99,637                   21,551,170       8,633,324       8,651,424         8,551,787        18,100              40.14% Total Revenues 55,190,179         131,167,346    64,175,187    60,475,862      5,285,683        (3,699,325)     46.11% EXPENDITURES Council 186,293                420,924               217,690            211,027             (24,734)              6,663                 50.13% Executive 1,229,299            2,562,066          1,241,370       1,301,766         (72,467)              (60,396)            50.81% Emergency Management 282,489                729,951               335,449            535,049             (252,560)           (199,600)         73.30% City Attorney 1,149,146            2,421,421          1,187,825       1,156,877         (7,731)                 30,948              47.78% Court Services 1,181,156            2,706,695          1,355,932       1,275,518         (94,362)              80,414              47.12% Community and Eco Dvlpmnt Admin 714,754                1,560,726          870,891            938,198             (223,444)           (67,307)            60.11% Development Services 1,118,068            2,600,034          1,256,311       1,268,912         (150,844)           (12,601)            48.80% Economic Development 435,237                3,942,393          1,178,354       808,950             (373,713)           369,404           20.52% Planning 1,902,517            4,370,938          2,098,004       2,021,703         (119,186)           76,301              46.25% Finance 1,478,970            3,709,001          1,631,851       1,478,946         24                          152,905           39.87% City Clerk 729,962                1,175,923          678,073            710,321             19,641               (32,248)            60.41% Human Resources 691,958                1,530,267          745,264            724,979             (33,021)              20,285              47.38% Police 17,287,443         36,077,366       17,921,247    18,762,821      (1,475,378)      (841,574)         52.01% Jail Services 2,883,025            6,518,024          3,259,504       2,354,207         528,818            905,297           36.12% Community Services Admin 608,336                1,534,005          649,362            621,111             (12,775)              28,251              40.49% Parks & Trails 2,434,389            5,103,016          2,345,573       2,414,786         19,603               (69,213)            47.32% Parks Planning & Natural Resources 675,357                2,414,791          1,049,299       900,403             (225,046)           148,896           37.29% Recreation & Neighborhoods 2,823,661            4,879,722          2,087,422       2,475,148         348,513            (387,726)         50.72% Human Services 617,572                1,644,515          704,965            659,706             (42,134)              45,259              40.12% Museum 127,713                225,195               113,034            129,422             (1,709)                 (16,388)            57.47% Public Works Admin 212,956                442,549               222,335            204,636             8,320                  17,699              46.24% Street Maintenance 2,831,686            5,591,654          2,818,796       2,797,589         34,097               21,207              50.03% Transportation 2,899,864            7,059,187          3,051,214       3,123,937         (224,073)           (72,723)            44.25% Non‐Departmental and Other 1,571,499            24,939,163       9,688,457       9,510,774         (7,939,275)      177,683           38.14% Total Expenditures 46,073,350         124,159,526    56,708,222    56,386,786      (10,313,436)   321,436           45.41% Change in Fund Balance 9,116,829            7,007,820          7,466,965       4,089,076         (5,027,753)      (3,377,889)     58.35% Beginning Fund Balance 44,578,377         48,056,982       48,056,982    48,056,982      3,478,605         ‐                       100.00% Ending Fund Balance 53,695,206$      55,064,802$    55,523,947$ 52,146,058$   (1,549,148)$   (3,377,889)     94.70% Summary of Sources and Uses Favorable (Unfavorable) 2019 2020 Variance YTD Actual Annual Budget YTD Budget YTD Actual Quarterly Financial Report 2nd Quarter 2020  Quarterly Financial Report               City of Renton, Washington 2nd Quarter 2020  Page 2 of 38 GENERAL FUND REVENUES  The  following  tables  provide  a  more  detailed  summary  of  each  revenue  category  within  the  General  Fund.  Detailed  explanations have been provided for variances from prior year or YTD budget in excess of $100K. All variances are shown in a   favorable (unfavorable) format.  TAXES  Property Tax – Property tax collections by King County have exceeded prior year and YTD budget. $140K of property taxes  collected through June 30 were for prior years’ delinquent taxes, bringing the balance of delinquent taxes receivable to $84K,  the remainder of taxes collected were for the 2020 levy.  Local Retail Sales Tax – COVID‐19 will heavily influence the sales tax figures throughout 2020. There are three factors which  as going to impact our sales tax distribution: 1) DOR is providing extensions for monthly filers, 2) many stores and other retail  locations have been required to be closed during the governor’s stay‐at‐home order, therefore, little to no sales will be made  during this time, and 3) some businesses will be closing due to decreased revenues. Please see the monthly sales tax report  for more information.   State Sales Tax Credit ‐ The City was awarded $500K per year in sales tax credit revenues under the Local Revitalization  Financing program. This award is to pay the debt service on the LRF bonds issued in 2019 to fund public improvements within  the South Lake Washington Local Revitalization Area. The City began receiving the state sales tax credit revenues in the 3rd  quarter of 2019. 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. The City also received a one‐time payment in the amount of $587K  in May related to sales tax credit revenues owed for the Benson Hill Annexation. This one‐time payment was the result of an  audit at the state level where it was determined the state had underpaid the City in 2019.  Criminal Justice Sales Tax – The criminal justice sales tax is a 0.1% sales tax imposed by the County for criminal justice  purposes. The County must share 90% of the revenues collected with all cities and towns in the county on a per capital basis.  The decrease in criminal justice sales tax directly relates to the decrease in retail sales tax, as described above.   Utility Tax – The decrease in utility tax is due to a combination of factors. Some taxes have decreased while others have  increased. The decrease in electrical taxes is due to a timing difference. A $422K tax payment, due June 30, was not received  until July 6.   2019 2020 2020 Actual Budget Actual $%$% Property Tax 9,328,145$         10,651,492$       11,346,387$      2,018,242$    21.6% 694,894$           6.5% Local Retail Sales Tax 13,554,004      13,936,684   12,684,477  (869,527)     ‐6.4% (1,252,206)    ‐9.0% State Sales Tax Credit ‐ Annexation/LRF ‐    ‐      746,377    746,377      100.0% 746,377    100.0% Criminal Justice Sales Tax 1,549,423   1,414,591      1,444,570     (104,853)     ‐6.8%29,979       2.1% Natural Gas Use Tax 147,158        149,908    82,218       (64,940)        ‐44.1% (67,691)     ‐45.2% Admission Tax 88,107     72,148  83,775       (4,332)     ‐4.9%11,628       16.1% Utility Tax 8,102,687   8,237,505      7,935,376     (167,311)     ‐2.1% (302,129)  ‐3.7% Leasehold Excise Tax 85,775     85,006  61,729       (24,046)        ‐28.0% (23,277)     ‐27.4% Gambling Excise Tax 1,420,296   1,253,596      1,340,441     (79,855)        ‐5.6%86,845       6.9% B&O Tax 7,209,626   6,715,855      4,213,566     (2,996,061)     ‐41.6% (2,502,289)    ‐37.3% YTD Total 41,485,222$      42,516,785$       39,938,915$      (1,546,306)$  ‐3.7% (2,577,870)$     ‐6.1% Annual Total 89,542,897$      81,535,404$        Taxes by Type Revenue 2020 vs. 2019 2020 vs. Budget Year to Date through June Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 3 of 38   The breakdown of Utility Tax is as follows:        Business and Occupation (B&O) Tax – B&O tax revenues rely heavily on the revenue of a limited number of large businesses.  These businesses have seen economic downturn in 2020 as a result of COVID‐19 as well as other factors and, as a result, have  seen considerable loss in revenue including an average decrease of 30% from the top 5 manufacturing companies.    LICENSES & PERMITS        Franchise Fees – Franchise fee revenues were less than anticipated for the first half of 2020. This is likely due to the governor’s  stay‐at‐home order resulting in less construction being done in City right‐of‐ways.     Business Licenses – Business license revenues are lagging behind 2019 and YTD budget at 6/30. This is due to three main  factors: 1) some businesses closed as a result of COVID‐19 revenue losses, 2) extensions were granted in response to COVID‐ 19, and 3) reduced construction and other seasonal activities due to COVID‐19.    Building Permits – The governor’s stay‐at‐home order forced many commercial and most residential construction projects to  stop for an extended period of time. The stay‐at‐home order has now expired, but permit activity is not expected to return  to pre‐COVID‐19 levels for the remainder of 2020 due to an overall decline in the economy.     INTERGOVERNMENTAL           2019 2020 2020 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Electrical 2,843,902$     2,958,973$         2,567,012$     (276,890)$       ‐9.7% $ (391,961)‐13.3% Natural Gas 887,442            883,076                 1,001,836        114,394           12.9%       118,760 13.5% Cell 368,522            360,181                 439,820            71,299              19.4%          79,640 22.1% Phone 463,489            433,554                 312,502            (150,987)          ‐32.6%     (121,052)‐27.9% Cable 709,911            750,330                 609,389            (100,522)          ‐14.2%     (140,941)‐18.8% Garbage 396,016            385,836                 592,172            196,156           49.5%       206,335 53.5% City Utilities 2,433,405        2,465,554            2,412,645        (20,760)             ‐0.8%        (52,909)‐2.2% YTD Total 8,102,687$     8,237,505$         7,935,376$     (167,311)$      ‐2.1%(302,129)$  ‐3.7% 2020 vs. 2019 2020 vs. Budget 2019 2020 2020 Actual Budget Actual $ % $ % Franchise Fees 761,146                 841,964                 732,385                 (28,761)              ‐3.8% (109,579)             ‐13.0% Business Licenses 861,375                 832,178                 720,157                 (141,218)           ‐16.4% (112,021)             ‐13.5% Animal Licenses 42,900                    48,637                    38,330                    (4,570)                 ‐10.7% (10,307)                ‐21.2% Building Permits 1,437,847            1,354,929             1,221,835            (216,013)           ‐15.0% (133,094)             ‐9.8% ROW/Street Excavation Permits 19,085                    26,439                    17,360                    (1,725)                 ‐9.0% (9,079)                   ‐34.3% Special Event Permits 50                              299                            220                           170                      340.0%(79)                           ‐26.4% YTD Total 3,122,404$         3,104,445$          2,730,287$         (392,117)$        ‐12.6% (374,159)$          ‐12.1% Annual Total 5,750,061$         5,550,877$           Year to Date through June Revenue 2020 vs. 2019 2020 vs. Budget Licenses & Permits by Type 2019 2020 2020 Actual Budget Actual $ % $ % State Shared Revenue 1,746,058$         1,755,886$          1,982,220$         236,162$        13.5% 226,334$           12.9% Federal Grants 46,128                    292,264                 3,284                       (42,844)              ‐92.9% (288,980)             ‐98.9% State Grants 21,596                    60,616                    100                           (21,496)              ‐99.5% (60,516)                ‐99.8% Local Grants 182,599                 119,397                 25,869                    (156,730)           ‐85.8% (93,528)                ‐78.3% YTD Total 1,996,380$         2,228,163$          2,011,472$         15,093$           0.8%(216,690)$          ‐9.7% Annual Total 4,820,547$         6,006,330$           Intergovernmental by Type Revenue 2020 vs. 2019 2020 vs. Budget Year to Date through June Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 4 of 38   State Shared Revenue – The increase in state shared revenues over prior year is almost entirely due to a 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:        Federal/State/Local Grants – Federal/State/Local grant revenues vary significantly from year‐to‐year based on what grants  have been awarded and the timing of grant expenditures and related reimbursement requests. Grant revenues are budgeted  at 100% of the award at the time the grant agreement is finalized and any amounts not received are carried forward each  year until either 1) the grant funds are fully received or 2) the grant agreement expires.     CHARGES FOR SERVICES        Development Services – The decrease in development services is almost entirely related to inspection services.    Recreation/Farmer’s Market/Events – The decrease in revenues is related to cancelled programs, as a result of COVID‐19.    Interfund Services – Interfund services revenues increased from the prior year due to increased Fleet and IT charges related  to new Police take‐home vehicles. Interfund services revenues are less than the YTD budget as the budget reflects  reimbursement of staffing costs from CIP projects that staff did not work on during the first half of the year, including  reimbursement for a capital project coordinator position that is vacant.       2019 2020 2020 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Judicial Contribution 10,830$         7,366$            21,536$         10,706$        98.9% 14,170$        192.4% Crim Just ‐ High Crime 147,980         138,359         140,366         (7,614)             ‐5.2%2,007              1.5% Crim Just ‐ Pop 15,185            12,057            15,878            694                  4.6% 3,822              31.7% Crim Just ‐ Spec Prog 54,774            55,377            56,993            2,219              4.1% 1,616              2.9% State DUI 7,571               9,215               6,871               (700)                  ‐9.2% (2,344)             ‐25.4% Marijuana Distribution 105,527          ‐                           103,655         (1,872)             ‐1.8%103,655        100.0% Liquor Profits 424,360         425,027         420,397         (3,963)             ‐0.9% (4,631)             ‐1.1% Liquor Excise Tax 285,257         249,099         300,478         15,220           5.3% 51,378           20.6% Fuel Tax 694,573         859,385         906,049         211,476        30.5% 46,663           5.4% YTD Total 1,746,058$  1,755,886$  1,972,223$  226,165$     13.0%216,337$     12.3% 2020 vs. 2019 2020 vs. Budget 2019 2020 2020 Actual Budget Actual $ % $ % Passport Fees 13,720                    28,486                    8,883                       (4,837)                 ‐35.3% (19,603)                ‐68.8% Court Services 18,544                    3,734                       25,419                    6,874                 37.1% 21,685                 580.8% General Government Services 1,005                       224                            446                           (559)                     ‐55.6%221                        98.6% Public Safety Services 553,555                 479,835                 462,364                 (91,191)              ‐16.5% (17,471)                ‐3.6% Development Services 1,206,052            1,078,087             859,738                 (346,315)           ‐28.7% (218,349)             ‐20.3% Transportation Services 9,664                        ‐                                   43,079                    33,415              345.8% 43,079                 100.0% Recreation/Farmer's Market/Events 499,068                 312,514                 189,316                 (309,752)           ‐62.1% (123,198)             ‐39.4% Interfund Services 2,081,155            2,543,648             2,332,852            251,698           12.1%(210,796)             ‐8.3% YTD Total 4,382,763$         4,446,529$          3,922,097$         (460,666)$        ‐10.5% (524,432)$          ‐11.8% Annual Total 9,251,750$         8,968,213$           Year to Date through June Charges for Services by Type Revenue 2020 vs. 2019 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 5 of 38   FINES AND PENALTIES        Photo Enforcement Program – Photo enforcement revenues have decreased from prior year due to reduced citations as a  result of the governor’s stay‐at‐home order. Traffic volumes have decreased and school zone cameras have been turned off  as a result of school closures.    MISCELLANEOUS REVENUES        Interest and Other Investment Earnings – Since interest earnings can vary greatly based on market conditions, the City has  historically budgeted interest and investment earnings very conservatively.    Rents, Leases, and Concessions ‐ Rental revenue is down from the prior year due to a few vacant City facilities, combined  with cancelled facility space rentals at the Senior Center and Renton Community Center and waived rent for tenants of City  facilities that were ordered closed in March due to COVID‐19.    Other – Other miscellaneous revenues are higher than prior year and higher than the YTD budget due to the receipt of an  unbudgeted payment of $327K under the terms of the Sunset Lane Latecomer Agreement.    OTHER FINANCING SOURCES        Transfers from Other Funds – Transfers from Other Funds have increased from prior year due to a change in accounting for  tax revenues used to support General Fund management funds (Community Services, Streets, Museum).   2019 2020 2020 Actual Budget Actual $ % $ % Civil Penalties 200,785$              275,803$              183,204$              (17,580)$           ‐8.8% (92,599)$             ‐33.6% Photo Enforcement Program 1,911,604            1,507,720             1,421,892            (489,712)           ‐25.6% (85,828)                ‐5.7% Criminal Traffic Misdemeanor Fines 27,769                    37,067                    26,754                    (1,015)                 ‐3.7% (10,313)                ‐27.8% Criminal Non‐Traffic Fines 48,579                    17,321                    11,206                    (37,372)              ‐76.9% (6,115)                   ‐35.3% Criminal Costs 41,672                    17,684                    38,984                    (2,688)                 ‐6.5%21,299                 120.4% Non‐Court Fines, Forfeitures and Penalties 18,136                    14,050                    52,040                    33,904              186.9% 37,990                 270.4% YTD Total 2,248,545$         1,869,646$          1,734,081$         (514,464)$        ‐22.9% (135,565)$          ‐7.3% Annual Total 4,688,980$         4,759,187$           Year to Date through June Revenue 2020 vs. 2019 2020 vs. Budget Fines and Penalties by Type 2019 2020 2020 Actual Budget Actual $ % $ % Interest and Other Investment Earnings 655,578$              383,725$              560,327$              (95,251)$           ‐14.5%176,602$           46.0% Rents, Leases, and Concessions 879,488                 799,911                 413,179                 (466,309)           ‐53.0% (386,732)             ‐48.3% Contributions/Donations from Private Source 109,723                 57,992                    60,426                    (49,298)              ‐44.9%2,433                    4.2% Seizure Funds ‐ Federal/State/Local 43,600                     ‐                                    ‐                                   (43,600)             0.0%‐                                N/A Other 166,840                 134,667                 453,654                 286,814           171.9% 318,987              236.9% YTD Total 1,855,228$         1,376,295$          1,487,586$         (367,642)$        ‐19.8%111,291$           8.1% Annual Total 3,762,854$         2,796,165$           Miscellaneous by Type Year to Date through June Revenue 2020 vs. 2019 2020 vs. Budget 2019 2020 2020 Actual Budget Actual $ % $ % Transfers from Other Funds 94,399$                 8,633,324$          8,633,324$         8,538,926       9045.6%‐                                0.0% Prior Period Adjustment 17                               ‐                                    ‐                                   (17)                       0.0%‐                                N/A Insurance Recoveries 5,221                        ‐                                    ‐                                   (5,221)                0.0%‐                                N/A Sale of Capital Assets ‐                                    ‐                                   18,100                    18,100              100.0% 18,100                 100.0% YTD Total 99,637$                 8,633,324$          8,651,424$         8,551,788$    8583.0% 18,100$              0.2% Annual Total 13,137,402$      21,551,170$        Year to Date through June Other Financing Sources by Type Revenue 2020 vs. 2019 2020 vs. Budget Quarterly Financial Report               City of Renton, Washington 2nd Quarter 2020  Page 6 of 38 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. All variances are shown in a   favorable (unfavorable) format.  COUNCIL  EXECUTIVE  EMERGENCY MANAGEMENT  Supplies – Supplies expenditures in excess of prior year and YTD budget are the result of COVID‐19. The majority, if not all,  of these costs will be reimbursed through the CARES Act grant which will be included in the year‐end budget adjustment.  CITY ATTORNEY  Council 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 146,945$         337,867$        170,628$        160,571$        (13,626)$       ‐9.3%10,057$       5.9% Supplies 606     1,400   418    778   (172)     ‐28.3% (360)     ‐86.3% Contracted Services 11,557     23,316   17,476   18,605    (7,049)   ‐61.0% (1,130)     ‐6.5% Capital Outlay ‐   ‐    ‐    ‐     ‐     0.0%‐     0.0% Debt Service ‐   ‐    ‐    ‐     ‐     0.0%‐     0.0% Internal Services 27,185     58,341   29,169   31,073    (3,888)   ‐14.3% (1,904)     ‐6.5% Transfers Out ‐   ‐    ‐    ‐     ‐     0.0%‐     0.0% Total Expenditures 186,293$         420,924$        217,690$        211,027$        (24,734)$       ‐13.3%6,663$       3.1% 2020 2020 vs. 2019 2020 vs. Budget Executive 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 438,864$         899,204$        441,934$        438,691$        174$       0.0% 3,243$       0.7% Supplies 4,332     8,100   3,316   1,319    3,012    69.5% 1,997    60.2% Contracted Services 561,633     1,366,407    651,946   630,475   (68,842)   ‐12.3%21,472    3.3% Capital Outlay ‐   ‐    ‐    ‐     ‐     0.0%‐     0.0% Debt Service ‐   ‐    ‐    ‐     ‐     0.0%‐     0.0% Internal Services 224,470     288,355   144,174   231,281   (6,811)   ‐3.0% (87,108)     ‐60.4% Transfers Out ‐   ‐    ‐    ‐     ‐     0.0%‐     0.0% Total Expenditures 1,229,299$        2,562,066$        1,241,370$    1,301,766$      (72,467)$       ‐5.9% (60,396)$        ‐4.9% 2020 2020 vs. 2019 2020 vs. Budget Emergency Management 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 196,166$         486,384$        233,486$        237,216$        (41,050)$       ‐20.9% (3,729)$        ‐1.6% Supplies 196     28,500   5,248   105,794   (105,598)   ‐53871.0% (100,546)    ‐1916.0% Contracted Services 8,962     11,361   4,644   84,108    (75,146)   ‐838.5% (79,464)     ‐1711.3% Capital Outlay ‐   18,438   ‐    ‐     ‐     0.0%‐     0.0% Debt Service ‐   ‐    ‐    ‐     ‐     0.0%‐     0.0% Internal Services 77,166     185,268   92,072   107,237   (30,071)   ‐39.0% (15,165)     ‐16.5% Transfers Out ‐   ‐    ‐    694   (694)    100.0%(694)    100.0% Total Expenditures 282,489$         729,951$        335,449$        535,049$        (252,559)$        ‐89.4% (199,599)$      ‐59.5% 2020 vs. Budget20202020 vs. 2019 City Attorney 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,039,034$         2,193,925$        1,079,491$    1,043,840$      (4,806)$       ‐0.5%35,651$       3.3% Supplies 348     3,550   974    853   (505)     ‐145.4%121     12.4% Contracted Services 13,481     41,465   16,124   9,463    4,018    29.8% 6,662    41.3% Capital Outlay ‐   ‐    ‐    ‐     ‐     0.0%‐     0.0% Debt Service ‐   ‐    ‐    ‐     ‐     0.0%‐     0.0% Internal Services 92,133     182,481   91,236   102,721   (10,588)   ‐11.5% (11,485)     ‐12.6% Transfers Out 4,150     ‐    ‐    ‐     4,150    100.0%‐     0.0% Total Expenditures 1,149,146$         2,421,421$        1,187,825$    1,156,877$      (7,731)$       ‐0.7%30,948$       2.6% 2020 vs. 2019 2020 vs. Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 7 of 38   COURT SERVICES        Personnel ‐ The amount of Court Services personnel expenditures under the YTD budget is due to open positions.    COMMUNITY AND ECONOMIC DEVELOPMENT ADMIN        Transfers Out – Transfers out in excess of prior year are the result of a change in the accounting for expenditures associated  with the Renton Municipal Arts Commission. In prior years, the Arts Commission operating budget was accounted for within  the Economic Development division’s budget, while the capital budget was accounted for within the Municipal Arts Fund, a  special revenue fund. In 2019 the decision was made to account for all Arts Commission expenditures within the Municipal  Arts Fund. The General Fund transfer to the Municipal Arts Fund is being recorded in the CED Admin accounts.    DEVELOPMENT SERVICES        Personnel – The increase in personnel costs over the prior year is due to COLA’s, reclassifications, and the addition of a  building inspector/combination position.    ECONOMIC DEVELOPMENT        Court Services 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 886,120$             2,203,800$        1,108,579$    985,231$          (99,111)$            ‐11.2%123,348$        11.1% Supplies 1,531                      7,700                     2,068                  1,044                   487                       31.8% 1,024                 49.5% Contracted Services 64,205                   106,856               51,114               48,531                15,673               24.4% 2,583                 5.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 229,300                388,339               194,172            238,758             (9,458)                  ‐4.1% (44,586)             ‐23.0% Transfers Out ‐                                   ‐                                  ‐                              1,954                   (1,954)                 100.0%(1,954)               100.0% Total Expenditures 1,181,156$         2,706,695$        1,355,932$    1,275,518$      (94,362)$            ‐8.0%80,414$           5.9% 2020 2020 vs. Budget2020 vs. 2019 Community and Eco Dvlpmnt Admin 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 184,865$             389,402$            195,084$         194,204$          (9,338)$               ‐5.1%880$                  0.5% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 440                           850                           ‐                              275                        165                       37.5%(275)                    100.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 525,232                989,334               494,668            559,860             (34,628)               ‐6.6% (65,192)             ‐13.2% Transfers Out 4,217                      181,140               181,140            183,860             (179,643)            ‐4260.2% (2,720)                ‐1.5% Total Expenditures 714,754$             1,560,726$        870,891$         938,198$          (223,444)$         ‐31.3% (67,307)$          ‐7.7% 2020 2020 vs. Budget2020 vs. 2019 Development Services 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,033,017$         2,420,783$        1,175,594$    1,179,720$      (146,703)$         ‐14.2% (4,126)$             ‐0.4% Supplies 2,008                      7,525                     3,469                  1,222                   786                       39.1% 2,247                 64.8% Contracted Services 51,757                   112,912               47,841               55,231                (3,474)                  ‐6.7% (7,390)                ‐15.4% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 31,286                   58,814                  29,407               32,739                (1,453)                  ‐4.6% (3,332)                ‐11.3% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,118,068$         2,600,034$        1,256,311$    1,268,912$      (150,844)$         ‐13.5% (12,601)$          ‐1.0% 2020 2020 vs. Budget2020 vs. 2019 Economic Development 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 315,838$             940,340$            453,062$         433,170$          (117,332)$         ‐37.1%19,892$           4.4% Supplies 569                           62,250                  11,000               778                        (209)                      ‐36.8%10,222              92.9% Contracted Services 105,151                1,957,529           619,259            279,932             (174,781)            ‐166.2%339,327           54.8% Capital Outlay 13,679                   982,274               95,034               95,071                (81,392)               ‐595.0% (37)                       0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 435,237$             3,942,393$        1,178,354$    808,950$          (373,713)$         ‐85.9%369,404$        31.3% 2020 vs. 2019 2020 vs. Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 8 of 38   Personnel ‐  The increase in personnel costs over the prior year is due to COLA’s, reclassifications, and the filling of the Housing  Programs Manager position that was vacant for most of 2019.    Contracted Services ‐ The amount of 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. The amount of contracted services expenditures under the YTD budget is due to grants awarded to support low income  housing and other charitable construction projects that have not been paid out yet. These grants are subject to certain  performance measures being met by the grantee prior to the payment of the grant award.    PLANNING        Personnel – The increase in personnel costs over the prior year is due to COLA’s, reclassifications, and the filling of a  construction inspector position that was vacant in 2019.    FINANCE        Personnel ‐ The amount of Finance personnel expenditures under the YTD budget is due to open positions.    CITY CLERK           Planning 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,837,518$         4,047,047$        2,004,425$    1,952,987$      (115,469)$         ‐6.3%51,438$           2.6% Supplies 4,745                      (15,025)                 (6,022)                1,876                   2,868                  60.5%(7,898)               131.2% Contracted Services 43,614                   249,492               83,741               49,430                (5,816)                  ‐13.3%34,311              41.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 16,640                   31,724                  15,861               17,410                (770)                      ‐4.6% (1,549)                ‐9.8% Transfers Out ‐                                  57,700                   ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,902,517$         4,370,938$        2,098,004$    2,021,703$      (119,186)$         ‐6.3%76,302$           3.6% 2020 vs. 2019 2020 vs. Budget2020 Finance 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,010,852$         2,288,635$        1,162,048$    989,942$          20,910$            2.1% 172,106$        14.8% Supplies 1,667                      11,500                  4,537                  884                        783                       47.0% 3,653                 80.5% Contracted Services 267,768                1,028,521           275,088            268,689             (921)                      ‐0.3%6,399                 2.3% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 198,683                380,345               190,178            219,432             (20,749)               ‐10.4% (29,253)             ‐15.4% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 1,478,970$         3,709,001$        1,631,851$    1,478,946$      24$                       0.0% 152,905$        9.4% 2020 vs. 2019 2020 vs. Budget2020 City Clerk 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 377,555$             723,688$            363,249$         368,364$          9,191$               2.4%(5,115)$             ‐1.4% Supplies 1,220                      4,094                     1,506                  838                        382                       31.3% 668                     44.4% Contracted Services 266,279                288,739               233,617            245,553             20,725               7.8%(11,936)             ‐5.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 84,908                   159,402               79,700               95,565                (10,657)               ‐12.6% (15,865)             ‐19.9% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 729,962$             1,175,923$        678,073$         710,321$          19,641$            2.7%(32,248)$          ‐4.8% 2020 vs. 2019 2020 vs. Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 9 of 38   HUMAN RESOURCES        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 and associated benefits.     Contracted Services – The amount of contracted services over the YTD budget is due to the timing of dispatch services  payments. This timing difference will correct itself by the end of the year.    Internal Services ‐ 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. The amount of internal service charges in excess of  the YTD budget is due to adjustments made to the budget in response to COVID‐19. The internal service fund charges will be  adjusted to budget in July.    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.        Human Resources 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 496,947$             1,153,163$        563,411$         554,362$          (57,415)$            ‐11.6%9,049$              1.6% Supplies 3,646                      8,828                     2,521                  2,031                   1,615                  44.3% 490                     19.4% Contracted Services 54,613                   130,663               60,527               27,809                26,804               49.1% 32,718              54.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 133,755                237,613               118,805            140,777             (7,022)                  ‐5.2% (21,972)             ‐18.5% Transfers Out 2,998                       ‐                                  ‐                               ‐                               2,998                  100.0%‐                             0.0% Total Expenditures 691,958$             1,530,267$        745,264$         724,979$          (33,021)$            ‐4.8%20,285$           2.7% 2020 vs. 2019 2020 vs. Budget2020 Police 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 12,342,873$      25,242,403$     12,516,228$ 12,862,225$   (519,352)$         ‐4.2% (345,997)$       ‐2.8% Supplies 260,941                421,156               170,692            164,548             96,393               36.9% 6,144                 3.6% Contracted Services 2,189,738            4,921,508           2,127,750       2,246,766         (57,029)               ‐2.6% (119,016)          ‐5.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 2,478,676            4,646,155           2,309,464       2,692,169         (213,493)            ‐8.6% (382,705)          ‐16.6% Transfers Out 15,216                   846,143               797,113            797,113             (781,897)            ‐5138.8%‐                             0.0% Total Expenditures 17,287,443$      36,077,366$     17,921,247$ 18,762,821$   (1,475,378)$    ‐8.5% (841,574)$       ‐4.7% 2020 2020 vs. Budget2020 vs. 2019 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 2,883,025            6,518,024           3,259,504       2,354,207         528,818            18.3% 905,298           27.8% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 2,883,025$         6,518,024$        3,259,504$    2,354,207$      528,818$         18.3% 905,298$        27.8% 2020 vs. 2019 2020 vs. Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 10 of 38   COMMUNITY SERVICES ADMIN        PARKS AND TRAILS        Internal Services – Increased internal service fund charges are a result of additional M&O charges and replacement reserve  payments associated with added vehicles. The amount of internal service charges in excess of the YTD budget is due to  adjustments made to the budget in response to COVID‐19. The internal service fund charges will be adjusted to budget in  July.    PARKS PLANNING AND NATURAL RESOURCES        Personnel – The increase in personnel costs over the prior year is due to filling a capital project coordinator position that was  vacant in 2019. The amount of personnel costs under the YTD budget is due to a remaining vacant capital project coordinator  position.    Contracted Services – The increase in contracted services costs over the prior year is due to tree maintenance.    RECREATION AND NEIGHBORHOODS        Community Services Admin 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 236,236$             550,053$            270,026$         273,352$          (37,115)$            ‐15.7% (3,326)$             ‐1.2% Supplies 7,200                      25,184                  11,820               1,319                   5,881                  81.7% 10,501              88.8% Contracted Services 280,535                657,083               304,984            241,881             38,654               13.8% 63,103              20.7% Capital Outlay ‐                                   ‐                                  ‐                              27,188                (27,188)              100.0%(27,188)            100.0% Debt Service ‐                                  175,000                ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 72,862                   126,685               62,533               76,756                (3,894)                  ‐5.3% (14,223)             ‐22.7% Transfers Out 11,502                    ‐                                  ‐                              616                        10,886               94.6%(616)                    100.0% Total Expenditures 608,336$             1,534,005$        649,362$         621,111$          (12,775)$            ‐2.1%28,251$           4.4% 2020 2020 vs. 2019 2020 vs. Budget Parks & Trails 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,469,413$         3,014,187$        1,425,416$    1,440,342$      29,070$            2.0%(14,926)$          ‐1.0% Supplies 121,883                200,434               105,130            70,060                51,823               42.5% 35,070              33.4% Contracted Services 229,639                697,451               223,539            185,807             43,832               19.1% 37,733              16.9% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 613,455                1,190,944           591,488            718,578             (105,123)            ‐17.1% (127,090)          ‐21.5% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 2,434,389$         5,103,016$        2,345,573$    2,414,786$      19,603$            0.8%(69,214)$          ‐3.0% 2020 vs. 2019 2020 vs. Budget2020 Parks Planning & Natural Resources 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 344,373$             1,157,416$        575,267$         451,746$          (107,373)$         ‐31.2%123,521$        21.5% Supplies 766                           4,827                     1,181                  162                        605                       78.9% 1,019                 86.3% Contracted Services 310,457                1,207,061           450,108            423,756             (113,299)            ‐36.5%26,351              5.9% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 19,761                   45,488                  22,744               24,738                (4,977)                  ‐25.2% (1,995)                ‐8.8% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 675,357$             2,414,791$        1,049,299$    900,403$          (225,045)$         ‐33.3%148,897$        14.2% 2020 vs. 2019 2020 vs. Budget2020 Recreation & Neighborhoods 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,489,577$         2,734,261$        1,106,706$    1,363,211$      126,366$         8.5%(256,506)$       ‐23.2% Supplies 115,774                288,019               118,991            48,240                67,534               58.3% 70,751              59.5% Contracted Services 207,661                406,708               136,435            114,974             92,687               44.6% 21,460              15.7% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 914,131                1,447,735           725,291            948,722             (34,591)               ‐3.8% (223,431)          ‐30.8% Transfers Out 96,517                   3,000                     1,500                   ‐                               96,517               100.0% 1,500                 100.0% Total Expenditures 2,823,661$         4,879,722$        2,088,922$    2,475,148$      348,513$         12.3%(386,226)$       ‐18.5% 2020 vs. 2019 2020 vs. Budget2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 11 of 38   Personnel – The decrease in personnel costs from the prior year is the result of recreation facility closures related to COVID‐ 19. The amount of personnel costs over the YTD budget is due to timing differences on the payment of part‐time staffing.  The YTD budget assumes the budget is spread over the same distribution pattern as the prior 2 years, however, the remaining  part‐time staffing budget was removed as part of the COVID‐19 budget cuts approved with the 2nd quarter budget adjustment.  This timing difference will correct itself by the end of the year.    Internal Services  ‐ The amount of internal service charges in excess of the YTD budget is due to adjustments made to the  budget in response to COVID‐19. The internal service fund charges will be adjusted to budget in July.    HUMAN SERVICES        MUSEUM        PUBLIC WORKS ADMIN        STREET MAINTENANCE        Internal Services – Increased internal service fund charges are a result of additional M&O charges and replacement reserve  payments associated with added large equipment.  Human Services 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 285,789$             703,400$            349,202$         306,460$          (20,671)$            ‐7.2%42,742$           12.2% Supplies 6,495                      15,650                  7,527                  2,532                   3,963                  61.0% 4,995                 66.4% Contracted Services 270,953                836,343               303,672            291,176             (20,223)               ‐7.5%12,496              4.1% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 54,335                   89,123                  44,564               59,538                (5,203)                  ‐9.6% (14,975)             ‐33.6% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 617,572$             1,644,515$        704,965$         659,706$          (42,134)$            ‐6.8%45,259$           6.4% 2020 vs. 20192020 2020 vs. Budget Museum 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 72,593$                134,675$            67,778$            69,911$             2,682$               3.7%(2,133)$             ‐3.1% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 55,120                   90,520                  45,256               59,511                (4,391)                  ‐8.0% (14,255)             ‐31.5% Transfers Out ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Total Expenditures 127,713$             225,195$            113,034$         129,422$          (1,709)$               ‐1.3% (16,388)$          ‐14.5% 2020 vs. 20192020 2020 vs. Budget Public Works Admin 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 178,003$             374,676$            188,894$         121,576$          56,427$            31.7% 67,318$           35.6% Supplies 68                              800                          134                      438                        (370)                      ‐540.4% (304)                     ‐228.0% Contracted Services 94                              1,650                     597                      26,700                (26,606)               ‐28262.0% (26,103)             ‐4375.3% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 34,790                   65,423                  32,711               54,785                (19,995)               ‐57.5% (22,074)             ‐67.5% Transfers Out ‐                                   ‐                                  ‐                              1,137                   (1,137)                 100.0%(1,137)               100.0% Total Expenditures 212,956$             442,549$            222,335$         204,636$          8,320$               3.9% 17,700$           8.0% 2020 vs. 20192020 2020 vs. Budget Street Maintenance 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,364,836$         3,030,489$        1,482,320$    1,452,573$      (87,736)$            ‐6.4%29,747$           2.0% Supplies 169,522                279,798               159,228            159,125             10,397               6.1% 103                     0.1% Contracted Services 503,449                1,133,781           531,178            495,119             8,330                  1.7% 36,059              6.8% Capital Outlay ‐                                  5,200                      ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 793,878                1,142,386           646,069            685,962             107,917            13.6%(39,892)             ‐6.2% Transfers Out ‐                                   ‐                                  ‐                              4,811                   (4,811)                 100.0%(4,811)               100.0% Total Expenditures 2,831,686$         5,591,654$        2,818,796$    2,797,589$      34,098$            1.2% 21,207$           0.8% 2020 vs. 20192020 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 12 of 38   TRANSPORTATION        Personnel – The 14.1% increase in salaries and benefits is due to two vacant positions in 2019 that are filled in 2020.    NON‐DEPARTMENTAL AND OTHER        Personnel ‐ The amount of personnel expenditures under the prior year and YTD budget is due to savings from expected  employee separation payments.     Transfers Out – Transfers Out have increased from prior year due to a change in accounting for tax revenues used to support  General Fund management funds (Community Services, Streets, Museum). In the past, these tax revenues were allocated  among the various management funds of the General Fund. Now, 100% of tax revenues are recognized in the General Fund  (000) with transfers to the Community Services Fund (001), the Street Fund (003), and the Museum Fund (005). For budgetary  purposes the transfer in and transfer out amounts are reflected in the General Fund revenues and expenditures. Transfers  between the General Fund and its management funds are eliminated for reporting in the City’s Comprehensive Annual  Financial Report (CAFR).   Transportation 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,929,371$         4,487,507$        2,137,403$    2,173,365$      (243,994)$         ‐12.6% (35,962)$          ‐1.7% Supplies 122,549                223,252               105,912            101,330             21,219               17.3% 4,582                 4.3% Contracted Services 479,068                945,974               486,483            473,237             5,831                  1.2% 13,246              2.7% Capital Outlay ‐                                   ‐                                  ‐                              13,818                (13,818)              100.0%(13,818)            100.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 364,740                642,453               321,415            362,186             2,554                  0.7%(40,771)             ‐12.7% Transfers Out 4,136                      760,000                ‐                               ‐                               4,136                  100.0%‐                             0.0% Total Expenditures 2,899,864$         7,059,187$        3,051,214$    3,123,937$      (224,073)$         ‐7.7% (72,723)$          ‐2.4% 2020 vs. Budget2020 vs. 20192020 Non‐Departmentsl and Other 2019 Summary of Uses YTD Actual Annual Budget YTD Budget YTD Actual $%$% Personnel 1,457,783$         2,407,200$        1,229,295$    1,056,419$      401,364$         27.5% 172,877$        14.1% Supplies ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Contracted Services 105,800                169,651               105,369            100,564             5,237                  4.9% 4,806                 4.6% Capital Outlay ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Debt Service ‐                                   ‐                                  ‐                               ‐                                ‐                              0.0%‐                             0.0% Internal Services 7,916                      18,828                  9,415                  9,414                   (1,498)                  ‐18.9%1                           0.0% Transfers Out ‐                                  22,343,484        8,344,376       8,344,376         (8,344,376)      100.0%‐                             0.0% Total Expenditures 1,571,499$         24,939,163$     9,688,457$    9,510,773$      (7,939,274)$    ‐505.2%177,684$        1.8% 2020 vs. 20192020 2020 vs. Budget Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 13 of 38   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.             2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 3,424,403$            ‐$                              ‐$                    (3,424,403)$ ‐$                     N/A Grants / intergovernmental 63,526                   56,930                    28,678           (34,848)         (28,252)           50.37% Charges for services 186,030                386,827                  193,414         7,384            (193,413)         50.00% Investment Earnings 20,215                    ‐                                22,001           1,786            22,001            N/A TOTAL REVENUES 3,694,174             443,757                  244,093         (3,450,081)   (199,664)         55.01% EXPENDITURES: Principal 175,436                5,405,922               181,622         (6,186)           5,224,300       3.36% Interest 537,898                1,756,464               876,071         (338,173)      880,393          49.88% TOTAL EXPENDITURES 713,334                7,162,386               1,057,693      (344,359)      6,104,693       14.77% TRANSFERS IN ‐                              7,699,250                ‐                        ‐                     (7,699,250)     0.00% NET TRANSFERS ‐                              7,699,250                ‐                        ‐                     (7,699,250)     0.00% CHANGE IN FUND BALANCE 2,980,839             980,621                  (813,600)        (3,794,439)   (1,794,221)      ‐82.97% BEGINNING FUND BALANCE, Jan 1 2,307,173             3,999,457               3,999,457      1,692,284     ‐                        100.00% ENDING FUND BALANCE, Jun 30 5,288,012$           4,980,078$            3,185,857$   (2,102,155)$ (1,794,221)$   63.97% VARIANCE FAVORABLE (UNFAVORABLE) GENERAL GOVERNMENTAL MISCELLANEOUS DEBT Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 14 of 38   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.          2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 201,659$              200,000$                140,524$              (61,135)$               (59,476)$               70.26% Contributions 16,000                    ‐                                 ‐                              (16,000)                  ‐                              N/A Investment Earnings 5,621                      ‐                                5,070                     (551)                       5,070                     N/A TOTAL REVENUES 223,280                200,000                   145,594                (77,686)                 (54,406)                 72.80% EXPENDITURES: Contracted Services 135,103                429,062                   104,381                30,722                   324,681                24.33% TOTAL EXPENDITURES 135,103                429,062                   104,381                30,722                   324,681                24.33% NET TRANSFERS ‐                              (37,500)                     ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 88,177                   (266,562)                 41,213                   (46,964)                 307,775                 ‐15.46% BEGINNING FUND BALANCE, Jan 1 722,387                943,889                   943,889                221,502                 ‐                              130.66% ENDING FUND BALANCE, Jun 30 810,564$              677,327$                985,102$              174,538$              307,775$              121.53% VARIANCE FAVORABLE (UNFAVORABLE) HOTEL/MOTEL 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 683$                       ‐$                              670$                      (13)$                       670$                      N/A TOTAL REVENUES 683                         ‐                                670                        (13)                         670                        N/A EXPENDITURES: Supplies ‐                              200                          290                        (290)                       (90)                         145.00% Contracted Services ‐                              183,460                  15,869                   (15,869)                 167,591                8.65% Capital Outlay 50,683                   88,130                      ‐                              50,683                   88,130                   0.00% TOTAL EXPENDITURES 50,683                   271,790                  16,159                   34,524                   255,631                5.95% TRANSFERS IN ‐                              180,660                  180,660                180,660                (0)                            100.00% NET TRANSFERS ‐                              180,660                  180,660                180,660                 ‐                              100.00% CHANGE IN FUND BALANCE (50,000)                 (91,130)                   165,171                215,171                256,301                 ‐181.25% BEGINNING FUND BALANCE, Jan 1 119,446                98,865                     98,865                   (20,581)                  ‐                              100.00% ENDING FUND BALANCE, Jun 30 69,446$                7,735$                     264,036$              194,590$              256,301$              3413.52% MUNICIPAL ART VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 15 of 38   Cable Communications Fund  The Cable Communications Fund accounts for funding for promotion and development of cable communications as  established by City ordinance. The main use of the fund is to support the broadcasting of City Council meetings on Channel  21.        Springbrook Wetlands Fund  The Springbrook Wetlands Fund was established in 2007 for the purpose of providing accounting for the Springbrook Creek  Wetland and Habitat Mitigation Bank project. The fund will receive revenue by selling Wetlands credits to third parties and  to the City’s internal departments.          2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 40,000$                 ‐$                                ‐$                            (40,000)$                ‐$                            N/A Licenses and permits 42,849                   57,674                      41,132                   (1,717)                    (16,542)                 71.32% Investment Earnings 3,947                      ‐                                  3,182                     (765)                       3,182                     N/A TOTAL REVENUES 86,796                   57,674                      44,314                   (42,482)                 (13,360)                 76.84% EXPENDITURES: Personnel 9,314                      ‐                                   ‐                              (9,314)                     ‐                              N/A Supplies ‐                              6,302                          ‐                               ‐                              6,302                     0.00% Contracted Services 15,040                   51,372                      17,100                   2,060                     34,272                   33.29% Capital Outlay ‐                              40,000                       ‐                               ‐                              40,000                   0.00% TOTAL EXPENDITURES 24,354                   97,674                      17,100                   (7,254)                    80,574                   17.51% NET TRANSFERS ‐                              40,000                       ‐                               ‐                               ‐                              0.00% CHANGE IN FUND BALANCE 62,442                    ‐                                  27,214                   (35,228)                 27,214                   N/A BEGINNING FUND BALANCE, Jan 1 529,159                603,760                    603,760                74,601                    ‐                              100.00% ENDING FUND BALANCE, Jun 30 591,601$              603,760$                  630,974$              39,373$                27,214$                104.51% CABLE COMMUNICATIONS VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 2,282$                    ‐$                               1,778$                   (504)$                     1,778$                   N/A TOTAL REVENUES 2,282                      ‐                                 1,778                     (503)                       1,778                     N/A TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                                  ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 2,282                      ‐                                 1,778                     (503)                       1,778                     N/A BEGINNING FUND BALANCE, Jan 1 340,895                345,658                   345,658                4,763                      ‐                              100.00% ENDING FUND BALANCE, Jun 30 343,177$              345,658$                 347,436$              4,259$                   1,778$                   100.51% SPRINGBROOK WETLANDS VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 16 of 38   Police Seizure Fund  The Police Seizure Fund was established in 2020 for the purpose of providing transparency in the accounting for assets seized  by Police in accordance with RCW 9A.83.030 and 69.50.505, previously accounted for within the General Fund. These seizure  funds are restricted to use exclusively for the expansion and improvement of controlled substances related law enforcement  activity.        Police CSAM Seizure Fund  The Police CSAM Seizure Fund was established in 2020 for the purpose of providing transparency in the accounting for assets  seized by Police in accordance with RCW 9A.88.150, previously accounted for within the General Fund. These seizure funds  are restricted to the exclusive use of enforcing the provisions of chapter 9A.88 RCW, Indecent Exposure‐Prostitution, or  chapter 9.68A RCW, Sexual Exploitation of Children.         2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings ‐$                             ‐$                               704$                      704$                      704$                      N/A TOTAL REVENUES ‐                               ‐                                 704                        704                        704                        N/A EXPENDITURES: Supplies ‐                              711,102                    ‐                               ‐                              (711,102)               0.00% Contracted Services ‐                               ‐                                 862                        862                        862                        N/A TOTAL EXPENDITURES ‐                              711,102                   862                        862                        710,240                0.12% TRANSFERS IN ‐                              711,102                   671,102                671,102                 ‐                              94.37% NET TRANSFERS ‐                              711,102                   671,102                671,102                (40,000)                 94.37% CHANGE IN FUND BALANCE ‐                               ‐                                 670,944                670,944                670,944                N/A BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Jun 30 ‐$                             ‐$                               670,944$              670,944$              670,944$              N/A POLICE SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings ‐$                             ‐$                               132$                      132$                      132$                      N/A TOTAL REVENUES ‐                               ‐                                 132                        132                        132                        N/A TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS IN ‐                              126,011                   126,011                126,011                 ‐                              100.00% NET TRANSFERS ‐                              126,011                   126,011                126,011                 ‐                              100.00% CHANGE IN FUND BALANCE ‐                              126,011                   126,143                126,143                132                        100.10% BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Jun 30 ‐$                            126,011$                 126,143$              126,143$              132$                      100.10% POLICE CSAM SEIZURE VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 17 of 38   CAPITAL PROJECT FUNDS  Capital project funds are used to account for the acquisition and construction of major capital facilities and equipment. YTD  budgets are not prepared for capital project funds. Project budgets are adopted when funding is secured and balances are  carried forward each year until they are either 1) fully spent or 2) reallocated to another project through the budget  adjustment process.    Community Services Impact Mitigation Fund  This fund accounts for park impact fees collected from developers as authorized under RCW 82.02.050‐.110. These fees are  used to help offset the cost of system improvements necessary to service the new development. Impact fees are held in this  fund and subsequently transferred to the Municipal Facilities CIP Fund when qualifying capital projects are budgeted.        Transportation Impact Mitigation Fund  This fund accounts for transportation impact fees collected from developers as authorized under RCW 82.02.050‐.110. These  fees are used to offset the cost of system improvements necessary to serve the new development. Impact fees are held in  this fund and subsequently transferred to the Capital Improvement Fund when qualifying projects are budgeted.         2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Charges for services 194,502$              86,500$                  334,963$              140,461$              248,463$              387.24% Investment Earnings 18,579                    ‐                                10,872                   (7,707)                    10,872                   N/A TOTAL REVENUES 213,081                86,500                     345,835                132,753                259,335                399.81% TOTAL EXPENDITURES ‐                               ‐                                 ‐                               ‐                               ‐                              N/A TRANSFERS OUT ‐                              945,909                   ‐                               ‐                              945,909                0.00% NET TRANSFERS ‐                              (945,909)                  ‐                               ‐                              945,909                0.00% CHANGE IN FUND BALANCE 213,081                (859,409)                 345,835                132,754                1,205,244              ‐40.24% BEGINNING FUND BALANCE, Jan 1 2,578,256             1,886,999               1,886,999             (691,257)                ‐                              100.00% ENDING FUND BALANCE, Jun 30 2,791,337$           1,027,590$             2,232,834$           (558,503)$             1,205,244$           217.29% 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 724,018$              1,435,875$              729,530$              5,512$                   (706,345)$             50.81% Investment Earnings 25,742                    ‐                                 17,583                   (8,159)                    17,583                   N/A TOTAL REVENUES 749,760                1,435,875                747,113                (2,647)                    (688,762)               52.03% TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS OUT ‐                              1,811,987                 ‐                               ‐                              1,811,987             0.00% NET TRANSFERS ‐                              (1,811,987)                ‐                               ‐                              1,811,987             0.00% CHANGE IN FUND BALANCE 749,760                (376,112)                  747,113                (2,647)                    1,123,225              ‐198.64% BEGINNING FUND BALANCE, Jan 1 3,332,524             2,942,344                2,942,344             (390,180)                ‐                              100.00% ENDING FUND BALANCE, Jun 30 4,082,284$           2,566,232$              3,689,457$           (392,827)$             1,123,225$           143.77% TRANSPORTATION IMPACT MITIGATION VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 18 of 38   REET 1 Fund  This fund accounts for the first quarter percent of real estate excise tax (REET) levied in accordance with RCW 82.46.010. The  tax may be used for eligible capital projects, as defined in RCW.82.46.010(6), that are included in the capital facilities element  of the City’s comprehensive plan. REET 1 tax revenues are held in this fund and subsequently transferred to the appropriate  capital project fund when qualifying projects are budgeted.        REET 2 Fund  This fund accounts for the second quarter percent of real estate excise tax (REET) levied in accordance with RCW 82.46.035.  The tax may be used for eligible capital projects, as defined in RCW.82.46.035(5), that are included in the capital facilities  element of the City’s comprehensive plan. REET 2 tax revenues are held in this fund and subsequently transferred to the  appropriate capital project fund when qualifying projects are budgeted.         2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes ‐$                            2,000,000$              1,271,842$           1,271,842$           (728,158)$             63.59% Investment Earnings ‐                               ‐                                 2,244                     2,244                     2,244                     N/A TOTAL REVENUES ‐                              2,000,000                1,274,086             1,274,086             (725,914)               63.70% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS IN ‐                              1,143,855                1,143,855             1,143,855              ‐                              100.00% TRANSFERS OUT ‐                              1,775,000                 ‐                               ‐                              1,775,000             0.00% NET TRANSFERS ‐                              (631,145)                  1,143,855             1,143,855             1,775,000              ‐181.23% CHANGE IN FUND BALANCE ‐                              1,368,855                2,417,941             2,417,941             1,049,086             176.64% BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Jun 30 ‐$                            1,368,855$              2,417,941$           2,417,941$           1,049,086$           176.64% REET 1 VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes ‐$                            2,000,000$              1,271,842$           1,271,842$           (728,158)$             63.59% Investment Earnings ‐                               ‐                                 2,244                     2,244                     2,244                     N/A TOTAL REVENUES ‐                              2,000,000                1,274,086             1,274,086             (725,914)               63.70% EXPENDITURES: TOTAL EXPENDITURES ‐                               ‐                                  ‐                               ‐                               ‐                              N/A TRANSFERS IN ‐                              1,143,855                1,143,855             1,143,855              ‐                              100.00% TRANSFERS OUT ‐                              1,775,000                 ‐                               ‐                              1,775,000             0.00% NET TRANSFERS ‐                              (631,145)                  1,143,855             1,143,855             1,775,000              ‐181.23% CHANGE IN FUND BALANCE ‐                              1,368,855                2,417,941             2,417,941             1,049,086             176.64% BEGINNING FUND BALANCE, Jan 1 ‐                               ‐                                  ‐                               ‐                               ‐                              N/A ENDING FUND BALANCE, Jun 30 ‐$                            1,368,855$              2,417,941$           2,417,941$           1,049,086$           176.64% REET 2 VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 19 of 38     Municipal Facilities CIP Fund  This fund accounts for general governmental facility construction, improvement and renovation; property acquisitions for  parks and City space needs; parks development and equipment; and major maintenance of existing general governmental  assets. Transportation capital improvements are accounted for in a separate fund.        A listing of project budgets and balances at June 30 is provided on the following page. The budget for personnel costs is  included in the listing for ease of comparison to total expenditures shown in the table above, but personnel costs are not  considered projects and, therefore, any remaining budget would not be carried forward at the end of the year.      2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Taxes 892,303$               ‐$                              ‐$                            (892,303)$              ‐$                            N/A Grants / intergovernmental 331,387                3,760,752              522,438                191,051                (3,238,314)            13.89% Charges for services 10,643                    ‐                               141                        (10,502)                 141                        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 194,563                175,910                 147,100                (47,463)                 (28,810)                 83.62% TOTAL REVENUES 1,555,741             4,107,662              829,679                (726,062)               (3,277,983)            20.20% EXPENDITURES: Personnel 182,004                746,459                 331,597                149,593                414,862                44.42% Supplies 78,557                   878,203                  ‐                              (78,557)                 878,203                0.00% Contracted Services 149,518                689,441                 102,974                (46,544)                 586,467                14.94% Capital Outlay 4,898,617             27,533,280            3,991,443             (907,174)               23,541,837           14.50% TOTAL EXPENDITURES 5,308,696             29,847,383            4,426,014             (882,682)               25,421,369           14.83% TRANSFERS IN ‐                              2,772,909               ‐                               ‐                              (2,772,909)            0.00% TRANSFERS OUT 6,378                     2,323,680               ‐                              (6,378)                    2,323,680             0.00% NET TRANSFERS (6,378)                    449,229                  ‐                              6,378                     (5,096,589)            0.00% CHANGE IN FUND BALANCE (3,759,333)            (25,290,492)          (3,596,335)            162,998                21,694,157           14.22% BEGINNING FUND BALANCE, Jan 1 20,675,238           26,395,567            26,395,567           5,720,329              ‐                              100.00% ENDING FUND BALANCE, Jun 30 16,915,905$        1,105,075$            22,799,232$        5,883,327$           21,694,157$        2063.14% MUNICIPAL FACILITIES CIP VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 20 of 38   Municipal Facilities CIP Fund (continued)             PROJECT BUDGET ACTUAL BALANCE CAPITAL PROJECT COORDINATORS 746,459$ 331,597$ 414,862$ SALE OF PARK LAND COSTS 10,000 - 10,000 SUNSET NEIGHBORHOOD PARK ART 224,100 19,850 204,250 CITY HALL ELEVATORS 2,079,704 327,282 1,752,422 SENIOR ACTIVITY CENTER - 1,641 (1,641) CITY WIDE SECURITY SYSTEM UPGRADES 340,055 45,287 294,768 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 CITY HALL MAJOR HVAC AND FIRE COMP REPL 1,796,262 - 1,796,262 4TH FLOOR REMODEL AND POLICE TRAINING CENTER 210,371 386,508 (176,137) BOATHOUSE 323,248 150,506 172,742 HENRY MOSES AQUATIC CENTER 88,644 - 88,644 PARKS RECREATION AND OPEN SPACE PLAN 8,730 8,730 - REGIS PARK ATHLETIC FIELD EXPANSION 300,000 29,894 270,106 SPORT COURT IMPROVEMENTS 150,000 - 150,000 PARKING LOT AND DRIVEWAY REPAIRS 90,000 - 90,000 PATHWAY SIDEWALK PATIO BOARDWALK REPLACE 265,215 - 265,215 IRRIGATION AUTOMATION & CONSERVATION 12,072 - 12,072 URBAN FORESTRY PROGRAM 106,044 - 106,044 PARKS MM - PLAYGRDS, KIOSKS & INT SIGNS 605,640 - 605,640 PARKS MM - LIGHT SYSTEM UPGRADES 110,000 - 110,000 PARKS MM - SHORELINE AND BANK STABILIZAT 182,500 - 182,500 PARKS MM - STRUCTURAL REVIEWS & REPAIRS 579,667 94,244 485,423 SUNSET EIS PARK 4,626,344 2,081,492 2,544,852 COULON PARK STRUCTURAL IMPROVEMENTS 1,038 1,038 - COULON PARK LIGHTING REPAIRS 34,415 - 34,415 COULON PARK TURF REPLACEMENT 124,788 - 124,788 COULON SWIM BEACH 250,000 - 250,000 LIBERTY PARK IMPROVEMENTS 1,551,852 - 1,551,852 TRANSPORTATION LANDSCAPE 90,000 - 90,000 PHILIP ARNOLD PARK IMPROVEMENTS 5,500,000 82,364 5,417,636 COULON - ROSEWALL 50,000 6,929 43,071 COULON - SHORELINE EROSION 100,000 - 100,000 KIWANIS PARK 4,200,388 100,488 4,099,900 COULON - WATERWALK 1,639,975 79,820 1,560,155 COULON - TRESTLE BRIDGE 1,542,881 40,014 1,502,867 FAWCETT PROPERTY PURCHASE ROFR 611,364 602,797 8,567 TOTAL PROJECT BALANCES 29,847,383$ 4,426,014$ 25,421,369$ MUNICIPAL FACILITIES CIP PROJECT BUDGETS AT JUNE 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 21 of 38   Capital Improvement Fund  This fund accounts for the City’s Transportation capital projects.         A listing of project budgets and balances at June 30 is provided on the following page.    2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 588,346$              22,131,453$        880,701$              292,355$              (21,250,752)$       3.98% Charges for services ‐                              250,000                250,000                250,000                 ‐                              100.00% Fines and penalties 45,928                   7,200                     9,012                     (36,916)                 1,812                     125.17% Contributions 238,518                 ‐                               ‐                              (238,518)                ‐                              N/A Investment Earnings 53,177                   70,000                   96,183                   43,006                   26,183                   137.40% TOTAL REVENUES 925,969                22,458,653           1,235,896             309,927                (21,222,757)         5.50% EXPENDITURES: Personnel 239,313                56,000                   53,386                   (185,927)               2,614                     95.33% Supplies 32,974                    ‐                              104,071                71,097                   (104,071)               N/A Contracted Services 6,853                      ‐                              84,351                   77,498                   (84,351)                 N/A Capital Outlay 1,683,520             45,242,768           2,080,070             396,550                43,162,698           4.60% TOTAL EXPENDITURES 1,962,660             45,298,768           2,321,878             359,218                42,976,890           5.13% TRANSFERS IN ‐                              4,669,687              ‐                               ‐                              (4,669,687)            0.00% NET TRANSFERS ‐                              4,669,687              ‐                               ‐                              (4,669,687)            0.00% CHANGE IN FUND BALANCE (1,036,691)            (18,170,428)         (1,085,982)            (49,291)                 17,084,446           N/A BEGINNING FUND BALANCE, Jan 1 5,492,313             18,947,853           18,947,853           13,455,540            ‐                              100.00% ENDING FUND BALANCE, Jun 30 4,455,622$           777,425$              17,861,871$        13,406,249$        17,084,446$        2297.57% CAPITAL IMPROVEMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 22 of 38   Capital Improvement Fund (continued)         PROJECT BUDGET ACTUAL BALANCE WALKWAY PGM 217,096$ -$ 217,096$ NE 31ST ST CULVERT 12,228 - 12,228 ARTERIAL CIRCULATION PGM 100,000 19,611 80,389 BRIDGE INSPECTION & REPAIR 236,916 29,181 207,735 ROADWAY SAFETY & GUARDRAIL 54,407 - 54,407 I-405/44TH GATEWAY SIGNAGE 57,700 - 57,700 RENTON CONNECTOR 1,593,294 7,735 1,585,559 STREET OVERLAY PGM 1,705,830 150,246 1,555,584 TRAFFIC SAFETY PGM 260,507 84,605 175,902 PROJ DEV & PRE-DESIGN 130,000 6,060 123,940 SO 7TH ST 135,000 - 135,000 ITS PGM 159,891 92,253 67,638 RENTON AVE EXT PRES 778,082 17,852 760,230 SW GRADY WAY PRES 7,603 7,205 398 DUVALL AVE NE PRES - 231 (231) PARK AVE EXTENSION 7,712,602 130,154 7,582,448 RAINIER AVE S/N PHASE 4 5,689,029 497,795 5,191,234 INTERSECT SAFETY & MOBILITY 386,934 62,569 324,365 NE 31ST ST BRIDGE REPLACEMENT 251,030 1,451 249,579 N 27TH PL CULVERT SCOUR REPAIR 71,719 2,903 68,816 DUVALL AVE 7TH TO SUNSET 6,910,089 264,371 6,645,718 BARRIER FREE 85,000 5,849 79,151 SIDEWALK REHAB 100,000 - 100,000 LAKE WASHINGTON LOOP TRAIL 1,099,156 64,048 1,035,108 HIGHLANDS TO LANDING 533,310 84,076 449,234 SUNSET BLVD CORRIDOR 1,644,769 108,073 1,536,696 PRES OF TOD 245,001 90,840 154,161 WILLIAMS AVE S & WELLS AVE S CONV 10,385,423 379,360 10,006,063 ARTERIAL REHAB - SW 43RD 220,000 6,385 213,615 BRONSON BRIDGE 611,235 32,976 578,259 HOUSER WAY N BRIDGE 590,985 15,637 575,348 WILLIAMS BRIDGE 713,535 16,293 697,242 NILE BRIDGE 50,000 - 50,000 S 2ND STREET CONVERSION 1,540,750 2,643 1,538,107 HOUSER WAY INT & PED IMP 814,625 69,166 745,459 RENTON SCHOOL CROSSINGS 195,022 72,310 122,712 TOTAL PROJECT BALANCES 45,298,768$ 2,321,878$ 42,976,890$ CAPITAL IMPROVEMENT PROJECT BUDGETS AT JUNE 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 23 of 38   Housing Opportunity Fund  This fund was historically used to account for the Economic Development Reserve and Housing Opportunity Grants. After a  review of the fund, it was determined that the use of the fund did not qualify as a capital project fund under Generally  Accepted Accounting Principles (GAAP) and the fund has been closed. The fund balance was transferred to a management  fund of the General Fund where the fund balance will remain intact until authorized by Council to be spent.        New Library Development Fund  This fund was used to account for the construction of the new Highlands Library and the renovation of the Cedar River Library.  The fund is no longer needed as the library construction projects were complete in 2016. Closure of the fund and a transfer  of the remaining fund balance will be proposed before the end of the year.       2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 18,714$                6,309$                   6,309$                   (12,405)$                ‐$                            100.00% TOTAL REVENUES 18,714                   6,309                     6,309                     (12,405)                  ‐                              100.00% EXPENDITURES: Contracted Services 28,131                    ‐                               ‐                              (28,131)                  ‐                              N/A TOTAL EXPENDITURES 28,131                    ‐                               ‐                              (28,131)                  ‐                              N/A TRANSFERS OUT ‐                              2,576,659             2,576,659             (2,576,659)             ‐                              100.00% NET TRANSFERS ‐                              (2,576,659)            (2,576,659)            2,576,659              ‐                              N/A CHANGE IN FUND BALANCE (9,417)                    (2,570,350)            (2,570,350)            2,592,385              ‐                              N/A BEGINNING FUND BALANCE, Jan 1 2,582,203             2,570,350             2,570,350             (11,853)                  ‐                              100.00% ENDING FUND BALANCE, Jun 30 2,572,786$            ‐$                             ‐$                            2,580,532$            ‐$                            N/A HOUSING OPPORTUNITY VARIANCE FAVORABLE (UNFAVORABLE) 2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Investment Earnings 2,110$                    ‐$                            259$                      (1,851)$                 259$                      N/A TOTAL REVENUES 2,110                      ‐                              259                        (1,852)                    259                        N/A TOTAL EXPENDITURES ‐                               ‐                               ‐                               ‐                               ‐                              N/A NET TRANSFERS ‐                               ‐                               ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE 2,110                      ‐                              259                        (1,852)                    259                        N/A BEGINNING FUND BALANCE, Jan 1 456,591                16,408                   16,408                   (440,183)                ‐                              100.00% ENDING FUND BALANCE, Jun 30 458,701$              16,408$                16,667$                (442,035)$             259$                      101.58% NEW LIBRARY DEVELOPMENT VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 24 of 38   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 31,915                    ‐                              43,113                   11,198                   43,113                   N/A TOTAL REVENUES 69,410                   75,000                   43,113                   (26,297)                 (31,887)                 57.48% EXPENDITURES: Capital Outlay 110,487                648,948                232,728                122,241                416,220                35.86% TOTAL EXPENDITURES 155,065                648,948                232,728                77,663                   416,220                35.86% NET TRANSFERS ‐                               ‐                               ‐                               ‐                               ‐                              N/A CHANGE IN FUND BALANCE (85,655)                 (573,948)               (189,615)               (103,960)               384,333                N/A BEGINNING FUND BALANCE, Jan 1 4,193,806             8,551,401             8,551,401             4,357,595              ‐                              100.00% ENDING FUND BALANCE, Jun 30 4,108,151$           7,977,453$           8,361,786$           4,253,635$           384,333$              104.82% FAMILY FIRST CENTER VARIANCE FAVORABLE (UNFAVORABLE) Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 25 of 38   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 155,015           145,557                  38,152              (116,863)          (107,405)          26.21% Rents, leases, and misc fees 1,310,353        2,902,353               1,456,675        146,322           (1,445,678)       50.19% Interest and other misc 38,501              3,857                       33,460              (5,041)               29,603              867.51% TOTAL REVENUES 1,554,236        3,051,767               1,528,287        (25,949)            (1,523,480)       50.08% EXPENSES: Personnel 548,015           1,109,685               480,208           67,807              629,477           43.27% Supplies 28,016              43,500                    18,425              9,591                25,075              42.36% Contracted Services 220,617           491,088                  198,522           22,095              292,566           40.42% Internal Services 162,629           310,765                  164,582           (1,953)               146,183           52.96% TOTAL OPERATING EXPENSES 959,277           1,955,038               861,737           97,540              1,093,301        44.08% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 594,959           1,096,729               666,550           71,591              (430,179)          60.78% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 68,923              5,893,387               161,865           (92,942)            5,731,522        2.75% TRANSFERS OUT ‐                          ‐                                1,363                (1,363)               (1,363)               N/A NET TRANSFERS ‐                          ‐                                (1,363)               (1,363)               (1,363)               N/A CHANGE IN FUND BALANCE 526,036           (4,796,658)             503,322           (22,714)            5,299,980        N/A BEGINNING FUND BALANCE, Jan 1 4,985,377        6,259,402               6,259,402        1,274,025         ‐                         100.00% ENDING FUND BALANCE, Jun 30 5,511,413$      1,462,744$            6,762,724$      1,251,311$      5,299,980$      462.33% 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 357,263 91,165 266,098 SURFACE WATER SYSTEM REHABILITATION - - - PAVEMENT MANAGEMENT PROGRAM 255,930 - 255,930 SNOW REMOVAL EQUIPMENT 167,000 - 167,000 MASTER PLAN UPDATE 103,850 18,962 84,888 TAXIWAY ALPHA REHABILITATION 1,115,495 - 1,115,495 RUNWAY SAFETY AREA 774,360 - 774,360 ENVIRONMENTAL IMPACT STUDY 400,000 - 400,000 TOTAL PROJECT BALANCES 5,997,237$ 152,021$ 5,845,216$ Non-capital items included in project budgets (103,850) (20,806) (83,044) Operating fund equipment purchase - 30,650 (30,650) TOTAL CAPITAL OUTLAY 5,893,387$ 161,865$ 5,731,522$ AIRPORT PROJECT BALANCES AT JUNE 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 26 of 38   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.         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.    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.    The Solid Waste Fund does not have a capital fund.     2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 167,153$         268,631$                89,664$           (77,489)$          (178,967)$        33.38% Charges for services 10,083,812      19,343,186            10,393,666      309,854           (8,949,520)       53.73% Interest and other misc 16,291              5,000                       16,160              (131)                  11,160              323.20% TOTAL REVENUES 10,267,256      19,616,817            10,499,490      232,234           (9,117,327)       53.52% EXPENSES: Personnel 293,161           579,726                  292,151           1,010                287,575           50.39% Supplies 4,458                10,171                    3,252                1,206                6,919                31.97% Contracted Services 8,985,317        18,338,705            8,882,554        102,763           9,456,151        48.44% Internal Services 239,889           438,482                  252,280           (12,391)            186,202           57.53% TOTAL OPERATING EXPENSES 9,522,825        19,367,084            9,430,237        92,588              9,936,847        48.69% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 744,431           249,733                  1,069,253        324,822           819,520           428.16% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 744,431           249,733                  1,069,253        324,822           819,520           428.16% BEGINNING FUND BALANCE, Jan 1 2,276,333        2,266,127               2,266,127        (10,206)             ‐                         100.00% ENDING FUND BALANCE, Jun 30 3,020,764$      2,515,860$            3,335,380$      314,616$         819,520$         132.57% SOLID WASTE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 27 of 38   Golf Course Fund  This fund accounts for revenues and expenses for administration, debt service, operation, capital improvements, and  maintenance of the Maplewood Golf Course.        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 943,007$         2,294,800$            865,395$         (77,612)$          (1,429,405)$    37.71% Rents, leases, and misc fees 181,239           500,750                  127,900           (53,339)            (372,850)          25.54% Interest and other misc 4,615                1,370                       1,978                (2,637)               608                   144.38% TOTAL REVENUES 1,128,861        2,796,920               995,273           (133,588)          (1,801,647)       35.58% EXPENSES: Personnel 708,162           1,512,192               672,654           35,508              839,538           44.48% Supplies 210,118           321,500                  159,956           50,162              161,544           49.75% Contracted Services 87,056              205,050                  81,711              5,345                123,339           39.85% Internal Services 130,316           341,940                  176,281           (45,965)            165,659           51.55% TOTAL OPERATING EXPENSES 1,135,652        2,380,682               1,090,602        45,050              1,290,080        45.81% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (6,791)               416,238                  (95,329)            (88,538)            (511,567)           ‐22.90% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 14,140              20,000                     ‐                         14,140              20,000              0.00% TRANSFERS IN 36,000              76,000                    38,000              2,000                (38,000)            50.00% TRANSFERS OUT 36,000              76,000                    40,695              (4,695)               35,305              53.55% NET TRANSFERS ‐                          ‐                                (2,695)               (2,695)               (2,695)               N/A CHANGE IN FUND BALANCE (20,931)            396,238                  (98,024)            (77,093)            (494,262)           ‐24.74% BEGINNING FUND BALANCE, Jan 1 110,812           173,750                  173,750           62,938               ‐                         100.00% ENDING FUND BALANCE, Jun 30 89,881$           569,988$                75,726$           (14,155)$          (494,262)$        13.29% GOLF COURSE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 28 of 38   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 7,718,312$      19,180,991$          7,427,277$      (291,035)$        (11,753,714)$  38.72% Rents, leases, and misc fees 99,863              136,591                  84,059              (15,804)            (52,532)            61.54% Interest and other misc 483,995           199,070                  485,804           1,809                286,734           244.04% TOTAL REVENUES 8,302,170        19,516,652            7,997,140        (305,030)          (11,519,512)    40.98% EXPENSES: Personnel 2,124,138        4,640,953               2,157,864        (33,726)            2,483,089        46.50% Supplies 398,381           833,418                  341,899           56,482              491,519           41.02% Contracted Services 1,459,396        3,193,299               1,420,773        38,623              1,772,526        44.49% Internal Services 1,105,323        2,185,563               1,107,657        (2,334)               1,077,906        50.68% TOTAL OPERATING EXPENSES 5,087,238        10,853,233            5,028,193        59,045              5,825,040        46.33% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 3,214,932        8,663,419               2,968,947        (245,985)          (5,694,472)       34.27% DEBT SERVICE: Principal 345,818           1,540,568               345,818            ‐                         1,194,750        22.45% Interest 111,973           241,747                  105,595           6,378                136,152           43.68% TOTAL DEBT SERVICE 457,791           1,782,315               451,413           6,378                1,330,902        25.33% CAPITAL OUTLAY 1,567,011        37,304,963            1,703,057        (136,046)          35,601,906      4.57% TRANSFERS OUT ‐                          ‐                                330                   (330)                  (330)                  N/A NET TRANSFERS ‐                          ‐                                (330)                  (330)                  (330)                  N/A CHANGE IN FUND BALANCE 1,190,130        (30,423,859)           814,147           (375,983)          31,238,006      N/A BEGINNING FUND BALANCE, Jan 1 38,002,973      37,569,067            37,569,067      (433,906)           ‐                         100.00% ENDING FUND BALANCE, Jun 30 39,193,103$   7,145,208$            38,383,214$   (809,889)$        31,238,006$   537.19% WATER UTILITY VARIANCE PROJECT BUDGET ACTUAL BALANCE PIPE OVERSIZING COSTS 100,000$ -$ 100,000$ TELEMETRY IMPROVEMENTS-PHASE 4 250,000 2,138 247,862 WATER SYSTEM PLAN UPDATE 200,000 42,592 157,408 UPDATE EMERGENCY RESPONSE PLAN 250,000 4,673 245,327 STEEL/AC WATERMAIN REPLC PLAN 1,130,000 7,618 1,122,382 RESERVOIR RECOATING 200,000 - 200,000 EMERGENCY RESPONSE PROJ 100,000 - 100,000 DOWNTOWN WATER MAIN REPLACEMENT 3,500,000 109,569 3,390,431 GPS & GIS DATABASE/CONVERSION - (4,432) 4,432 WATER PUMP STATIONS REHAB 400,000 - 400,000 RESERVOIR PRV METERS 300,000 4,086 295,914 MPLWD WATER TREATMENT IMPROV - CONST 770,000 33,440 736,560 MAPLEWOOD PUMP STATION ROOF REPLACEMENT - 7,914 (7,914) HIGHLANDS WATER MAIN IMPROVEMENT 1,100,000 15,822 1,084,178 DUVALL AVE NE WATER MAIN REPLACEMENT 360,000 2,400 357,600 EMERGENCY POWER TO PUMP STATION 300,000 - 300,000 WATER SYSTEM SECURITY IMPROVEMENTS 100,000 - 100,000 AQUIFER MONITORING AND MANAGEMENT 30,000 - 30,000 WATER TREATMENT FILTER MEDIA 400,000 4,648 395,352 WSDOT I-405 WATER RELOCATIONS 300,000 6,174 293,826 AUTOMATIC METER READING CONVERSION 85,000 - 85,000 TRANSMISSION MAIN REPLACEMENT - (248) 248 HIGHLANDS 435-RESERVOIRS REPLACEMENT 23,100,000 16,562 23,083,438 RAINIER AVE S ROAD & UTILITIES IMPRVMNT 300,000 - 300,000 KENNYDALE 320-RESERVOIR 4,000,000 1,498,867 2,501,133 TOTAL PROJECT BALANCES 37,275,000$ 1,751,823$ 35,523,177$ Non-capital items included in project budgets - (48,766) 48,766 Operating fund equipment purchase 29,963 - 29,963 TOTAL CAPITAL OUTLAY 37,304,963$ 1,703,057$ 35,601,906$ WATER UTILITY FUND PROJECT BALANCES AT JUNE 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 29 of 38   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 61,025$           61,802$                  48,275$           (12,750)$          (13,527)$          78.11% Charges for services 5,384,546        11,248,216            5,366,799        (17,747)            (5,881,417)       47.71% Fines and penalties 481                    ‐                                155                   (326)                  155                   N/A Interest and other misc 332,545           320,766                  333,293           748                   12,527              103.91% TOTAL REVENUES 5,778,597        11,630,784            5,748,522        (30,075)            (5,882,262)       49.43% EXPENSES: Personnel 1,116,139        2,456,376               1,145,637        (29,498)            1,310,739        46.64% Supplies 27,187              70,880                    28,002              (815)                  42,878              39.51% Contracted Services 1,122,883        2,944,281               975,115           147,768           1,969,166        33.12% Internal Services 791,868           1,455,392               784,138           7,730                671,254           53.88% TOTAL OPERATING EXPENSES 3,058,077        6,926,929               2,932,892        125,185           3,994,037        42.34% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 2,720,520        4,703,855               2,815,630        95,110              (1,888,225)       59.86% DEBT SERVICE: Principal ‐                         601,300                   ‐                          ‐                         601,300           0.00% Interest 47,859              108,921                  45,398              2,461                63,523              41.68% TOTAL DEBT SERVICE 47,859              710,221                  45,398              2,461                664,823           6.39% CAPITAL OUTLAY 1,920,827        18,163,200            301,238           1,619,589        17,861,962      1.66% TRANSFERS IN 28,356               ‐                                 ‐                         (28,356)             ‐                         N/A NET TRANSFERS 27,588               ‐                                 ‐                         (27,588)             ‐                         N/A CHANGE IN FUND BALANCE 779,422           (14,169,566)           2,468,994        1,689,572        16,638,560      N/A BEGINNING FUND BALANCE, Jan 1 18,879,201      19,832,351            19,832,351      953,150            ‐                         100.00% ENDING FUND BALANCE, Jun 30 19,658,623$   5,662,785$            22,301,345$   2,642,722$      16,638,560$   393.82% WASTEWATER UTILITY VARIANCE PROJECT BUDGET ACTUAL BALANCE MISCELANEOUS SEWER PROJECTS 185,000$ 3,358$ 181,642$ 2008 LONG-RANGE WW MANAG PLAN 97,000 8,360 88,640 WASTEWATER OPERATIONS MASTER PLAN 774,000 8,509 765,491 FALCON RIDGE LS REHAB - 59 (59) THUNDER HILL INT REPL/REHAB 3,110,000 27,137 3,082,863 FORCE MAIN REHABILITATION REPLACEMENT 1,487,000 5,782 1,481,218 LIFT STATION REHABILITATION 1,891,000 7,947 1,883,053 DOWNTOWN SEWER REPLACEMENT/REHAB 7,537,000 164,898 7,372,102 2019 SANITARY SEWER REHAB/REPLACEMENT - 4,253 (4,253) 2020 SANITARY SEWER REHAB/REPLACEMENT 2,700,000 75,424 2,624,576 KENNYDALE LAKELINE SEWER UPGRADE 1,248,000 5,827 1,242,173 TOTAL PROJECT BALANCES 19,029,000$ 311,554$ 18,717,446$ Non-capital items included in project budgets (871,000) (10,316) (860,684) Operating fund equipment purchase 5,200 - 5,200 TOTAL CAPITAL OUTLAY 18,163,200$ 301,238$ 17,861,962$ WASTEWATER UTILITY FUND PROJECT BALANCES AT JUNE 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 30 of 38   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 23,750$           50,456$                  35,225$           11,475$           (15,231)$          69.81% Grants / intergovernmental 705,990           12,356,399            642,014           (63,976)            (11,714,385)    5.20% Charges for services 5,846,943        13,000,699            5,907,533        60,590              (7,093,166)       45.44% Interest and other misc 205,174           135,163                  238,321           33,147              103,158           176.32% TOTAL REVENUES 6,781,857        25,542,717            6,823,093        41,236              (18,719,624)    26.71% EXPENSES: Personnel 1,699,053        3,488,003               1,796,117        (97,064)            1,691,886        51.49% Supplies 65,246              167,949                  58,558              6,688                109,391           34.87% Contracted Services 698,149           4,292,977               867,617           (169,468)          3,425,360        20.21% Internal Services 979,184           1,746,577               955,142           24,042              791,435           54.69% TOTAL OPERATING EXPENSES 3,441,632        9,695,506               3,677,434        (235,802)          6,018,072        37.93% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 3,340,225        15,847,211            3,145,659        (194,566)          (12,701,552)    19.85% DEBT SERVICE: Principal ‐                         488,950                   ‐                          ‐                         488,950           0.00% Interest 316,085           640,845                  313,768           2,317                327,077           48.96% TOTAL DEBT SERVICE 316,085           1,129,795               313,768           2,317                816,027           27.77% CAPITAL OUTLAY 1,299,332        20,310,802            774,712           524,620           19,536,090      3.81% NET TRANSFERS 6,378                 ‐                                 ‐                         (6,378)                ‐                         N/A CHANGE IN FUND BALANCE 1,731,186        (5,593,386)             2,057,179        325,993           7,650,565        N/A BEGINNING FUND BALANCE, Jan 1 16,356,030      18,377,556            18,377,556      2,021,526         ‐                         100.00% ENDING FUND BALANCE, Jun 30 18,087,216$   12,784,170$          20,434,735$   2,347,519$      7,650,565$      159.84% SURFACE WATER UTILITY VARIANCE PROJECT BUDGET ACTUAL BALANCE COMP S&SW MGMT PLAN P&D 172,034$ 58,043$ 113,991$ SM DRAINAGE PROBLEMS 683,923 73,482 610,441 PANTHER CR WL MOSQUITO ABATEMENT 89,767 10,095 79,672 MADSEN CREEK SEDIMENT BASIN 83,738 10,429 73,309 SMALL DRAINAGE PROJ-MAPLEWOOD SEDIMENT 111,314 2,819 108,495 WETLAND MITIGATION BANK 160,345 11,671 148,674 ACOE 205 PROJECT 61,693 2,076 59,617 CEDAR RIVER GRAVEL REMOVAL 2,902,163 106,568 2,795,595 RENTON STORM WATER MANUAL 75,815 5,947 69,868 GREEN RIVER ECOSYSTEM STUDY 48,336 159 48,177 MISCELLANEOUS/EMERGENCY/STORM PROJECTS 100,000 - 100,000 SURFACE WATER UTILITY GIS 125,382 52,520 72,862 HARDIE AVE S UNDERPASS STORM SYSTEM IMPR 2,391 - 2,391 MONROE AVE/N 2ND ST 378,837 135,606 243,231 STORMWATER FACILITY FENCING PROJECT 265,101 2,901 262,200 CEDAR RIVER 205 LEVEE RECERTIFICATION 4,854,386 150,224 4,704,162 SE 172ND ST/125TH AVE SE 232,561 87,884 144,677 RAINIER AVE/OAKSDALE AVE PUMP STATION UP 207,466 44,234 163,232 NE 16TH/JEFFERSON AVE NE 2,768,213 108,822 2,659,391 DOWNTOWN STORM SYSTEM IMPROVEMENT PROJEC 6,030,270 159,944 5,870,326 HEATHER DOWNS DETENTION POND 693,543 6,285 687,258 MADSEN CRK IMPROV PHASE 1-KCFCD 1,033,096 51,885 981,211 RAINIER AVE/BENSON RD S - CULVERT REPL 200,610 20,915 179,695 CMP STORM SYSTEM REPLACEMENT PROJECT 539,934 14,746 525,188 CEDAR RIVER FLOOD RISK REDUCTION 499,658 1,700 497,958 STORMWATER FACILITY RETROFIT STUDY 300,000 1,692 298,308 BURNETT AVE S/WILLIAMS AVE S 467,629 1,616 466,013 WSDOT LA ROW RUNOFF IMPACT MITIGATION 96,200 2,096 94,104 TOTAL PROJECT BALANCES 23,184,405$ 1,124,359$ 22,060,046$ Non-capital items included in project budgets (2,902,163) (349,647) (2,552,516) Operating fund equipment purchase 28,560 - 28,560 TOTAL CAPITAL OUTLAY 20,310,802$ 774,712$ 19,536,090$ SURFACE WATER UTILITY PROJECT BALANCES AT JUNE 30, 2020 Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 31 of 38   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.        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 8,552,070$      17,007,226$          8,416,524$      (135,546)$        (8,590,702)$    49.49% Interest and other misc 43,755               ‐                                32,451              (11,304)            32,451              N/A TOTAL REVENUES 8,595,825        17,007,226            8,448,975        (146,850)          (8,558,251)       49.68% EXPENSES: Contracted Services 8,434,177        17,007,226            9,525,536        (1,091,359)       7,481,690        56.01% TOTAL OPERATING EXPENSES 8,434,177        17,007,226            9,525,536        (1,091,359)       7,481,690        56.01% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 161,648            ‐                                (1,076,561)       (1,238,209)       (1,076,561)       N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 161,648            ‐                                (1,076,561)       (1,238,209)       (1,076,561)       N/A BEGINNING FUND BALANCE, Jan 1 5,512,418        5,961,906               5,961,906        449,488            ‐                         100.00% ENDING FUND BALANCE, Jun 30 5,674,066$      5,961,906$            4,885,345$      (788,721)$        (1,076,561)$    81.94% METRO VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 32 of 38   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.         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 42,497$            ‐$                             17,118$           (25,379)$          17,118$           N/A Interdepartmental services 2,639,775        3,587,714               2,184,394        (455,381)          (1,403,320)       60.89% Interest and other misc 105,626           12,000                    36,155              (69,471)            24,155              301.29% TOTAL REVENUES 2,787,898        3,599,714               2,237,667        (550,231)          (1,362,047)       62.16% EXPENSES: Personnel 549,625           1,089,183               546,371           3,254                542,812           50.16% Supplies 717,808           1,496,153               483,678           234,130           1,012,475        32.33% Contracted Services 161,745           133,166                  122,175           39,570              10,991              91.75% Internal Services 14,741              32,697                    17,015              (2,274)               15,682              52.04% TOTAL OPERATING EXPENSES 1,443,919        2,751,199               1,169,239        274,680           1,581,960        42.50% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,343,979        848,515                  1,068,428        (275,551)          219,913           125.92% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 991,419           2,064,000               925,942           65,477              1,138,058        44.86% NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 352,560           (1,215,485)             142,486           (210,074)          1,357,971        N/A BEGINNING FUND BALANCE, Jan 1 6,493,018        6,851,811               6,851,811        358,793            ‐                         100.00% ENDING FUND BALANCE, Jun 30 6,845,578$      5,636,326$            6,994,297$      148,719$         1,357,971$      124.09% EQUIPMENT RENTAL VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 33 of 38   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.        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 1,544,778$      3,174,506$            1,566,125$      21,347$           (1,608,381)$    49.33% Interest and other misc 225,319           197,000                  112,256           (113,063)          (84,744)            56.98% TOTAL REVENUES 1,770,097        3,371,506               1,678,381        (91,716)            (1,693,125)       49.78% EXPENSES: Personnel 425,995           1,484,232               466,214           (40,219)            1,018,018        31.41% Supplies ‐                         4,000                       374                   (374)                  3,626                9.35% Contracted Services 673,336           1,841,646               826,477           (153,141)          1,015,169        44.88% TOTAL OPERATING EXPENSES 1,099,331        3,329,878               1,293,065        (193,734)          2,036,813        38.83% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 670,766           41,628                    385,316           (285,450)          343,688           925.62% TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TRANSFERS OUT ‐                         4,500,000                ‐                          ‐                         4,500,000        0.00% NET TRANSFERS ‐                         (4,500,000)              ‐                          ‐                         4,500,000        N/A CHANGE IN FUND BALANCE 670,766           (4,458,372)             385,316           (285,450)          4,843,688        N/A BEGINNING FUND BALANCE, Jan 1 18,522,154      19,095,508            19,095,508      573,354            ‐                         100.00% ENDING FUND BALANCE, Jun 30 19,192,920$   14,637,136$          19,480,824$   287,904$         4,843,688$      133.09% INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 34 of 38   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.         Increased interdepartmental services revenue over the prior year is due to increased costs in personnel and contracted  services being charged back to the departments.     Increased personnel charges over the prior year are the result of COLAs and allocating ½ of the Administrative Services  Administrator payroll costs to the IT division beginning in January 2020.    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 163,966$         150,000$                123,004$         (40,962)$          (26,996)$          82.00% Interdepartmental services 2,482,213        5,343,238               2,894,507        412,294           (2,448,731)       54.17% Interest and other misc 28,185              7,000                       25,253              (2,932)               18,253              360.76% TOTAL REVENUES 2,675,826        5,500,238               3,042,764        366,938           (2,457,474)       55.32% EXPENSES: Personnel 1,360,935        3,165,906               1,488,032        (127,097)          1,677,874        47.00% Supplies 277,645           983,155                  224,440           53,205              758,715           22.83% Contracted Services 939,506           2,416,051               1,134,131        (194,625)          1,281,920        46.94% Internal Services 778                   1,804                       902                   (124)                  902                   50.00% TOTAL OPERATING EXPENSES 2,578,864        6,566,916               2,847,505        (268,641)          3,719,411        43.36% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 96,962              (1,066,678)             195,259           98,297              1,261,937        N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 49,222              1,068,500               30,872              18,350              1,037,628        2.89% TRANSFERS IN 37,935              9,630                       12,433              (25,502)            2,803                129.11% NET TRANSFERS 37,935              9,630                       12,433              (25,502)            2,803                129.11% CHANGE IN FUND BALANCE 85,675              (2,125,548)             176,820           91,145              2,302,368        N/A BEGINNING FUND BALANCE, Jan 1 3,934,408        4,490,062               4,490,062        555,654            ‐                         100.00% ENDING FUND BALANCE, Jun 30 4,020,083$      2,364,514$            4,666,882$      646,799$         2,302,368$      197.37% INFORMATION TECHNOLOGY VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 35 of 38   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.         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.     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.    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 2,215,765        4,306,771               2,629,606        413,841           (1,677,165)       61.06% Rents, leases, and misc fees 1                         ‐                                78,499              78,498              78,499              N/A Interest and other misc 8,939                4,000                       6,782                (2,157)               2,782                169.55% TOTAL REVENUES 2,241,727        4,310,771               2,736,722        494,995           (1,574,049)       63.49% EXPENSES: Personnel 1,409,961        3,167,309               1,478,774        (68,813)            1,688,535        46.69% Supplies 178,347           339,168                  293,729           (115,382)          45,439              86.60% Contracted Services 753,116           1,505,634               625,576           127,540           880,058           41.55% Internal Services 33,839              67,450                    35,671              (1,832)               31,779              52.89% TOTAL OPERATING EXPENSES 2,375,263        5,079,561               2,433,750        (58,487)            2,645,811        47.91% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS (133,536)          (768,790)                 302,972           436,508           1,071,762        N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY 10,901               ‐                                5,704                5,197                (5,704)               N/A TRANSFERS IN 12,389              2,880                       8,596                (3,793)               5,716                298.47% TRANSFERS OUT 5,220                 ‐                                 ‐                         5,220                 ‐                         N/A NET TRANSFERS 7,169                2,880                       8,596                1,427                5,716                298.47% CHANGE IN FUND BALANCE (137,268)          (765,910)                 305,864           443,132           1,071,774        N/A BEGINNING FUND BALANCE, Jan 1 1,376,859        1,220,276               1,220,276        (156,583)           ‐                         100.00% ENDING FUND BALANCE, Jun 30 1,239,591$      454,366$                1,526,140$      286,549$         1,071,774$      335.88% FACILITIES VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 36 of 38   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 ‐$                       86,050$                   ‐$                        ‐$                       (86,050)$          0.00% Interdepartmental services 552,384           1,069,076               566,721           14,337              (502,355)          53.01% Interest and other misc 5,102                22,000                    4,133                (969)                  (17,867)            18.79% TOTAL REVENUES 557,486           1,177,126               570,854           13,368              (606,272)          48.50% EXPENSES: Personnel 361,689           851,567                  444,546           (82,857)            407,021           52.20% Supplies 16,786              71,350                    16,622              164                   54,728              23.30% Contracted Services 131,832           336,679                  131,920           (88)                    204,759           39.18% Internal Services 1,485                3,941                       1,971                (486)                  1,970                50.01% TOTAL OPERATING EXPENSES 511,792           1,263,537               595,059           (83,267)            668,478           47.09% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 45,694              (86,411)                   (24,205)            (69,899)            62,206              N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A TRANSFERS OUT ‐                          ‐                                4,229                (4,229)               (4,229)               N/A NET TRANSFERS ‐                          ‐                                (4,229)               (4,229)               (4,229)               N/A CHANGE IN FUND BALANCE 45,694              (86,411)                   (28,434)            (74,128)            57,977              N/A BEGINNING FUND BALANCE, Jan 1 685,593           803,561                  803,561           117,968            ‐                         100.00% ENDING FUND BALANCE, Jun 30 731,287$         717,150$                775,127$         43,840$           57,977$           108.08% COMMUNICATIONS VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 37 of 38   Health Insurance Fund  This fund accounts for the City’s self‐insured health insurance program. Expenses/claims are paid by the Health Insurance  Fund and rates are charged to employees and departments based on annual premiums determined by the City’s Employee  Health Plan Board for each type of coverage elected by the employee; paid semi‐monthly in conjunction with each payroll.         Premiums ‐ Premiums increased over the prior year due to 1) increased rates and 2) additional FTEs.    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 5,561,252$      12,603,106$            6,054,561$      493,309$         (6,548,545)$    48.04% Interest and other misc 32,389              46,588                       28,374              (4,015)               (18,214)            60.90% TOTAL REVENUES 5,593,641        12,649,694               6,082,935        489,294           (6,566,759)       48.09% EXPENSES: Personnel 4,398,645        12,011,435               4,532,508        (133,863)          7,478,927        37.73% Supplies 7,167                7,500                         6,881                286                   619                   91.75% Contracted Services 182,967           420,540                    248,333           (65,366)            172,207           59.05% Internal Services 29,030              60,430                       30,215              (1,185)               30,215              50.00% TOTAL OPERATING EXPENSES 4,617,809        12,499,905               4,817,937        (200,128)          7,681,968        38.54% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 975,832           149,789                    1,264,998        289,166           1,115,209        844.52% TOTAL DEBT SERVICE ‐                          ‐                                   ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                   ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                   ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 975,832           149,789                    1,264,998        289,166           1,115,209        844.52% BEGINNING FUND BALANCE, Jan 1 4,259,511        5,151,648                 5,151,648        892,137            ‐                         100.00% ENDING FUND BALANCE, Jun 30 5,235,343$      5,301,437$               6,416,646$      1,181,303$      1,115,209$      121.04% HEALTH INSURANCE VARIANCE Quarterly Financial Report                                                               City of Renton, Washington 2nd Quarter 2020  Page 38 of 38   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.         The increase in personnel expenses over the prior year is due to an increase in prescription costs and payments for long‐term  care, a benefit not previously being utilized.    CONTACT INFORMATION  This report is prepared by the Finance Division of the Administrative Services Department. For additional financial  information, please also review our website: http://www.rentonwa.gov/.  For any questions about the report, please feel  free to contact Misty Baker at mbaker@rentonwa.gov or Jan Hawn at jhawn@rentonwa.gov.  2019 2020 2020 YTD YTD ACTUAL ANNUAL BUDGET YTD ACTUAL PRIOR YEAR BUDGET % BUDGET REVENUES: Grants / intergovernmental 35,898$           45,014$                  35,245$           (653)$                (9,769)$            78.30% Premiums 1,312,340        131,989                  812,342           (499,998)          680,353           615.46% Interest and other misc 99,666              67,459                    82,166              (17,500)            14,707              121.80% TOTAL REVENUES 1,447,904        244,462                  929,753           (518,151)          685,291           380.33% EXPENSES: Personnel 346,546           1,209,429               539,457           (192,911)          669,972           44.60% Contracted Services 21,188              38,814                    25,959              (4,771)               12,855              66.88% TOTAL OPERATING EXPENSES 367,734           1,248,243               565,416           (197,682)          682,827           45.30% AMOUNT AVAILABLE FOR DEBT SERVICE,  CAPITAL, AND TRANSFERS 1,080,170        (1,003,781)             364,337           (715,833)          1,368,118        N/A TOTAL DEBT SERVICE ‐                          ‐                                 ‐                         ‐                          ‐                         N/A CAPITAL OUTLAY ‐                          ‐                                 ‐                          ‐                          ‐                         N/A NET TRANSFERS ‐                          ‐                                 ‐                          ‐                          ‐                         N/A CHANGE IN FUND BALANCE 1,080,170        (1,003,781)             364,337           (715,833)          1,368,118        N/A BEGINNING FUND BALANCE, Jan 1 13,876,628      15,799,729            15,799,729      1,923,101         ‐                         100.00% ENDING FUND BALANCE, Jun 30 14,956,798$   14,795,948$          16,164,066$   1,207,268$      1,368,118$      109.25% RETIREE HEALTHCARE VARIANCE