Loading...
HomeMy WebLinkAboutMONTH 2020 04Page 1 of 7   OVERVIEW  This monthly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through April 30, 2020.  A detailed analysis, including budget to actual comparison, will be prepared quarterly in accordance with the City’s financial  management policies.     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 year‐to‐date revenues and expenditures for the General Fund.    General REVENUES: Taxes 27,498,619$       Licenses and permits 1,969,107            Grants / intergovernmental 1,506,601            Charges for services 2,703,107            Fines and penalties 1,288,705            Contributions 866,369               Sale of general fixed assets 18,100                  Investment Earnings 408,410               TOTAL REVENUES 36,259,018          EXPENDITURES: Personnel 20,283,590          Supplies 407,105               Contracted Services 5,996,960            Capital Outlay 115,804               Internal Services 5,133,609            TOTAL EXPENDITURES 31,937,068          TRANSFERS IN 8,633,326            TRANSFERS OUT 9,333,424            NET TRANSFERS (700,098)              CHANGE IN FUND BALANCE 3,621,852            BEGINNING FUND BALANCE, Jan 1 48,056,982          ENDING FUND BALANCE, Apr 30 51,678,834$              Monthly Financial Report April 2020  Monthly Financial Report                                                               City of Renton, Washington April 2020  Page 2 of 7   DEBT SERVICE FUND   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. The table below displays the year‐to‐date revenues and expenditures for the City’s  debt service fund.    General  Governmental  Misc Debt REVENUES: Grants / intergovernmental 222,092$              Investment Earnings 17,878                  TOTAL REVENUES 239,970                EXPENDITURES: Principal 181,622                Interest 99,849                  TOTAL EXPENDITURES 281,471                NET TRANSFERS ‐                             CHANGE IN FUND BALANCE (41,501)                 BEGINNING FUND BALANCE, Jan 1 3,999,457             ENDING FUND BALANCE, Apr 30 3,957,956$               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. The table below displays the year‐to‐date revenues and expenditures for the City’s special revenue funds.    Hotel‐Motel Tax Municipal Art Cable  Communications Springbrook  Wetlands Police Seizure Police CSAM  Seizure REVENUES: Taxes 108,543$               ‐$                             ‐$                             ‐$                             ‐$                             ‐$                             Licenses and permits ‐                               ‐                              41,132                    ‐                               ‐                               ‐                               Investment Earnings 4,037                     391                        2,523                     1,417                      ‐                               ‐                               TOTAL REVENUES 112,580                391                        43,655                   1,417                      ‐                               ‐                               EXPENDITURES: Contracted Services 58,523                   13,450                   15,340                    ‐                               ‐                               ‐                               TOTAL EXPENDITURES 58,523                   13,740                   15,340                    ‐                               ‐                               ‐                               TRANSFERS IN ‐                              180,660                 ‐                               ‐                              671,102                126,011                 NET TRANSFERS ‐                              180,660                 ‐                               ‐                              671,102                126,011                 CHANGE IN FUND BALANCE 54,057                   167,311                28,315                   1,417                     671,102                126,011                 BEGINNING FUND BALANCE, Jan 1 943,889                98,865                   603,760                345,658                 ‐                               ‐                               ENDING FUND BALANCE, Apr 30 997,946$              266,176$              632,075$              347,075$              671,102$              126,011$                      Monthly Financial Report                                                               City of Renton, Washington April 2020  Page 3 of 7   CAPITAL PROJECT FUNDS  Capital project funds are used to account for the acquisition and construction of major capital facilities and equipment. The  table below displays the year‐to‐date revenues and expenditures for the City’s capital project funds.    CS Impact Mitigation Transportation  Impact  Mitigation REET 1REET 2 Municipal  Facilities CIP Capital  Investment Housing  Opportunity New Library  Development Family First  Center REVENUES: Taxes ‐$                         ‐$                        931,645$          931,645$           ‐$                         ‐$                         ‐$                         ‐$                         ‐$                         Grants / intergovernmental ‐                           ‐                           ‐                           ‐                          398,612            561,699             ‐                           ‐                           ‐                           Charges for services 269,092            570,178             ‐                           ‐                          140                    250,000             ‐                           ‐                           ‐                           Fines and penalties ‐                           ‐                           ‐                           ‐                           ‐                          7,123                  ‐                           ‐                           ‐                           Sale of general fixed assets ‐                           ‐                           ‐                           ‐                          160,000             ‐                           ‐                           ‐                           ‐                           Investment Earnings 8,596                 13,855                ‐                           ‐                          120,919            76,507               6,309                 245                    34,335                TOTAL REVENUES 277,688            584,033            931,645            931,645            679,671            895,329            6,309                 245                    34,335                EXPENDITURES: Personnel ‐                           ‐                           ‐                           ‐                          217,283            33,514                ‐                           ‐                           ‐                           Contracted Services ‐                           ‐                           ‐                           ‐                          18,219               12,800                ‐                           ‐                           ‐                           Capital Outlay ‐                           ‐                           ‐                           ‐                          1,903,243         902,341             ‐                           ‐                          195,683             TOTAL EXPENDITURES ‐                           ‐                           ‐                           ‐                          2,138,745         984,683             ‐                           ‐                          195,683             TRANSFERS IN ‐                           ‐                          1,143,855         1,143,855          ‐                          0                          ‐                           ‐                           ‐                           TRANSFERS OUT ‐                           ‐                           ‐                           ‐                           ‐                           ‐                          2,576,659          ‐                           ‐                           NET TRANSFERS ‐                           ‐                          1,143,855         1,143,855          ‐                           ‐                          (2,576,659)         ‐                           ‐                           CHANGE IN FUND BALANCE 277,688            584,033            2,075,500         2,075,500         (1,459,074)        (89,354)             (2,570,350)        245                    (161,348)            BEGINNING FUND BALANCE, Jan 1 1,886,999         2,942,344          ‐                           ‐                          26,395,567       18,947,853       2,570,350         16,408               8,551,401          ENDING FUND BALANCE, Apr 30 2,164,687$       3,526,377$       2,075,500$       2,075,500$       24,936,493$    18,858,499$     ‐$                        16,653$            8,390,053$          Monthly Financial Report                                                               City of Renton, Washington April 2020  Page 4 of 7   ENTERPRISE FUNDS  Enterprise funds are used to account for operations that are financed and operated in a manner similar to private business  enterprises. The table below displays the year‐to‐date revenues and expenses of the City’s enterprise funds.    Airport Solid Waste  Utility Golf Course Water Utility Wastewater  Utility Metro Surface Water  Utility REVENUES: Licenses and permits ‐$                      ‐$                      ‐$                      ‐$                       36,275$             ‐$                     25,475$             Grants / intergovernmental ‐                        89,664              ‐                         ‐                          ‐                          ‐                        560,614             Charges for services 32,284             6,669,809       280,571          4,876,281        3,571,695         5,611,623       4,035,691          Rents, leases, and misc fees 990,850           ‐                        47,169             56,331               ‐                          ‐                         ‐                          Interest and other misc 26,402             12,544             1,853               431,160            253,484            25,611             211,188             TOTAL REVENUES 1,049,536       6,772,016       329,593          5,363,772        3,861,454         5,637,234       4,832,968          EXPENSES: Personnel 349,844          202,790          438,787          1,446,397        765,159             ‐                        1,182,065          Supplies 3,280               3,058               104,486          211,597            16,607               ‐                        41,612               Contracted Services 123,089          5,600,651       56,105             933,921            627,610            5,655,068       517,341             Internal Services 111,528          171,193          117,503          761,042            538,500             ‐                        665,821             TOTAL OPERATING EXPENSES 587,741          5,977,691       716,881          3,352,957        1,947,876         5,655,068       2,406,839          AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 461,795          794,325          (387,288)         2,010,815        1,913,578         (17,834)           2,426,129          DEBT SERVICE: Interest ‐                         ‐                         ‐                         ‐                          ‐                          ‐                        173,333             TOTAL DEBT SERVICE ‐                        ‐                        ‐                        ‐                          ‐                          ‐                       173,333             CAPITAL PROJECTS 144,961           ‐                        ‐                       1,212,513        181,046             ‐                       484,853             TRANSFERS IN ‐                         ‐                        25,333              ‐                          ‐                          ‐                         ‐                          TRANSFERS OUT 1,363                ‐                        28,028             330                    ‐                          ‐                         ‐                          NET TRANSFERS (1,363)              ‐                       (2,695)             (330)                   ‐                          ‐                        ‐                          CHANGE IN FUND BALANCE 315,471          794,325          (389,983)         797,972            1,732,532         (17,834)           1,767,943          BEGINNING FUND BALANCE, Jan 1 6,259,402       2,266,127       173,750          37,569,067      19,832,351       5,961,906       18,377,556        ENDING FUND BALANCE, Apr 30 6,574,873$     3,060,452$     (216,233)$       38,367,039$    21,564,883$    5,944,072$     20,145,499$           Monthly Financial Report                                                               City of Renton, Washington April 2020  Page 5 of 7   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. The table below displays the year‐to‐date revenues and expenses of the City’s  internal service funds.    Equipment  Rental Insurance Information  Technology Facilities Communications Healthcare Retiree  Healthcare REVENUES: Technology Fee ‐$                          ‐$                         85,968$                ‐$                          ‐$                          ‐$                          ‐$                          Grants / intergovernmental ‐                             ‐                             ‐                            21,835                  ‐                             ‐                            35,245                  Charges for services: Equipment rental m&o 1,012,051            ‐                            1,929,672            ‐                             ‐                             ‐                             ‐                             Print and mail ‐                             ‐                             ‐                             ‐                            151,145                ‐                             ‐                             Communications ‐                             ‐                             ‐                             ‐                            226,668                ‐                             ‐                             Facilities ‐                             ‐                             ‐                            1,749,504            ‐                             ‐                             ‐                             Interest and other misc 28,340                 78,193                 18,495                 5,385                   3,304                   21,955                 65,379                  Internal service fund misc: Vehicle / equipment capital recovery 684,942                ‐                             ‐                             ‐                             ‐                             ‐                             ‐                             Insurance premiums ‐                            572,522                ‐                             ‐                             ‐                             ‐                             ‐                             Worker's comp/unemployment ‐                            473,826                ‐                             ‐                             ‐                             ‐                             ‐                             Benefit premiums ‐                             ‐                             ‐                             ‐                             ‐                            3,654,015           541,561                Other misc 139                       ‐                            1,942                   52,333                  ‐                            386,519                ‐                             Insurance recoveries ‐                            12,050                  ‐                             ‐                             ‐                             ‐                             ‐                             TOTAL REVENUES 1,725,472           1,136,591           2,036,077           1,829,057           381,117              4,062,489           642,185               EXPENSES: Personnel 374,504               353,339               1,017,549           1,026,909           298,726               3,178,079           371,723                Supplies 329,549               374                      143,386               243,341               14,488                 6,881                    ‐                             Contracted Services 82,849                 688,471               804,137               476,260               77,487                 177,346               16,042                  Internal Services 11,787                  ‐                            601                      24,393                 1,314                   20,143                  ‐                             TOTAL OPERATING EXPENSES 798,689              1,042,184           1,965,673           1,770,903           392,015              3,382,449           387,765               AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 926,783              94,407                 70,404                 58,154                 (10,898)               680,040              254,420               CAPITAL PROJECTS 441,837               ‐                            17,600                 5,704                    ‐                             ‐                             ‐                             TRANSFERS IN ‐                             ‐                            8,533                   7,459                    ‐                             ‐                             ‐                             TRANSFERS OUT ‐                             ‐                             ‐                             ‐                            329                       ‐                             ‐                             NET TRANSFERS ‐                             ‐                            8,533                   7,459                   (329)                      ‐                             ‐                             CHANGE IN FUND BALANCE 484,946              94,407                 61,337                 59,909                 (11,227)               680,040              254,420               BEGINNING FUND BALANCE, Jan 1 6,851,811           19,095,508         4,490,062           1,220,276           803,561               5,151,648           15,799,729          ENDING FUND BALANCE, Apr 30 7,336,757$         19,189,915$       4,551,399$         1,280,185$         792,334$            5,831,688$         16,054,149$               Monthly Financial Report                                                               City of Renton, Washington April 2020  Page 6 of 7   FIDUCIARY FUNDS  Fiduciary funds are used to account for assets held by the City in a trustee capacity. These assets are not available for City use  as they are not City assets. The table below displays year‐to‐date revenues and expenditures of the City’s fiduciary funds.    Fire Mitigation Firemens' Pension REVENUES: Charges for services 67,091$                 ‐$                             Investment Earnings 8,846                     25,010                    TOTAL REVENUES 75,937                   25,010                    EXPENDITURES: Personnel ‐                              71,187                    TOTAL EXPENDITURES ‐                              71,187                    NET TRANSFERS ‐                               ‐                               CHANGE IN FUND BALANCE 75,937                   (46,177)                  BEGINNING FUND BALANCE, Jan 1 2,120,558             7,565,902              ENDING FUND BALANCE, Apr 30 2,196,495$           7,519,725$               Monthly Financial Report                                                               City of Renton, Washington April 2020  Page 7 of 7   City of Renton All Funds ‐ Revenue, Expenditures and Fund Balances Budgetary Basis through April 30, 2020 Funds Balance  01/01/2020 Budgeted  Revenue Revenue  04/30/20 Total Funds  Available Budgeted  Expenditure Expenditure  04/30/20 Ending Balance GENERAL FUND 48,056,982      125,971,724    44,892,344   92,949,326      134,629,020    41,270,492   51,678,834       SPECIAL REVENUE FUNDS: 1,992,172        1,275,447        1,135,816      3,127,988        780,526           87,603           3,040,385         110 Hotel Motel 943,889           200,000           112,580         1,056,469        429,062           58,523           997,946            125 Municipal Art 98,865              180,660           181,051         279,916           253,790           13,740           266,176            127 Cable Communication 603,760           97,674              43,655           647,415           97,674              15,340           632,075            135 Springbrook Wetlands Bank 345,658            ‐                         1,417             347,075            ‐                          ‐                      347,075            DEBT SERVICE FUND 3,999,457        8,143,007        239,970         4,239,427        7,162,386        281,471         3,957,956         CAPITAL PROJECT FUNDS (CIP): 61,310,922      43,601,229      6,628,610      67,939,532      87,473,609      5,895,770      62,043,762       303 Community Services Mitigation 1,886,999        86,500              277,688         2,164,687        1,202,364         ‐                      2,164,687         305 Transportation Mitigation 2,942,344        1,435,875        584,033         3,526,377        2,500,656         ‐                      3,526,377         308 REET1 ‐                         3,143,855        2,075,500      2,075,500        1,775,000         ‐                      2,075,500         309 REET2 ‐                         3,143,855        2,075,500      2,075,500        1,775,000         ‐                      2,075,500         316 Municipal Facilities CIP 26,395,567      7,970,026        679,671         27,075,238      30,575,902      2,138,745      24,936,493       317 Transportation CIP 18,947,853      27,739,809      895,329         19,843,182      46,419,080      984,683         18,858,499       326 Housing Opportunity 2,570,350        6,309                6,309             2,576,659        2,576,659        2,576,659       ‐                          336 New Library Development 16,408               ‐                         245                 16,653               ‐                          ‐                      16,653               346 New Family First Center Dvlpmnt 8,551,401        75,000              34,335           8,585,736        648,948           195,683         8,390,053         ENTERPRISE FUNDS: 90,440,159      99,238,882      27,871,906   118,312,065    155,326,944    22,871,480   95,440,585       4X2 Airport Operating & CIP 6,259,402        3,051,767        1,049,536      7,308,938        8,097,828        734,065         6,574,873         403 Solid Waste Utility 2,266,127        19,616,816      6,772,016      9,038,143        19,476,649      5,977,691      3,060,452         4X4 Golf Operating & CIP 173,750           2,872,920        354,926         528,676           2,650,253        744,909         (216,233)           4X5 Water Operating & CIP 37,569,067      19,516,652      5,363,772      42,932,839      50,487,098      4,565,800      38,367,039       4X6 Waste Water Operating & CIP 19,832,351      11,630,784      3,861,454      23,693,805      26,039,906      2,128,922      21,564,883       416 King County Metro 5,961,906        17,007,226      5,637,234      11,599,140      17,007,226      5,655,068      5,944,072         4X7 Surface Water Operating & CIP 18,377,556      25,542,717      4,832,968      23,210,524      31,567,984      3,065,025      20,145,499       INTERNAL SERVICE FUNDS: 53,412,595      35,418,012      11,828,980   65,241,575      40,458,552      10,205,148   55,036,427       501 Equipment Repair/Replacement 6,851,811        5,662,319        1,725,472      8,577,283        6,954,176        1,240,526      7,336,757         502 Insurance 19,095,508      3,390,962        1,136,591      20,232,099      4,249,334        1,042,184      19,189,915       503 Information Services 4,490,062        5,927,868        2,044,610      6,534,672        8,076,416        1,983,273      4,551,399         504 Facilities 1,220,276        5,328,266        1,836,516      3,056,792        6,102,750        1,776,607      1,280,185         505 Communications 803,561           1,214,441        381,117         1,184,678        1,300,852        392,344         792,334            512 Insurance, Healthcare 5,151,648        12,649,694      4,062,489      9,214,137        12,526,781      3,382,449      5,831,688         522 Insurance, Leoff1 Retirees HC 15,799,729      1,244,462        642,185         16,441,914      1,248,243        387,765         16,054,149       FIDUCIARY FUNDS: 9,686,460        567,000           100,947         9,787,407        314,283           71,187           9,716,220         304 Fire Mitigation 2,120,558        99,000              75,937           2,196,495        113,808            ‐                      2,196,495         611 Firemen's Pension 7,565,902        468,000           25,010           7,590,912        200,475           71,187           7,519,725         TOTAL FUNDS 268,898,747 314,215,301 92,698,573 361,597,320 426,145,320 80,683,151 280,914,169     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.