Loading...
HomeMy WebLinkAboutMONTH 2020 01Page 1 of 7   OVERVIEW  This monthly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through January 31,  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 6,042,435$         Licenses and permits 850,008              Grants / intergovernmental 382,526              Charges for services 706,336              Fines and penalties 369,530              Contributions 259,822              Investment Earnings 126,876              TOTAL REVENUES 8,737,533           EXPENDITURES: Personnel 5,117,905           Supplies 31,925                 Contracted Services 1,334,597           Capital Outlay 300                      Internal Services 1,318,656           TOTAL EXPENDITURES 7,803,383           TRANSFERS IN ‐                           TRANSFERS OUT 1,954                   NET TRANSFERS (1,954)                 CHANGE IN FUND BALANCE 932,196              BEGINNING FUND BALANCE, Jan 1 48,056,982         ENDING FUND BALANCE, Jan 31 48,989,178$             Monthly Financial Report January 2020  Monthly Financial Report                                                               City of Renton, Washington January 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 28,678$                Investment Earnings 7,410                     TOTAL REVENUES 36,088                  EXPENDITURES: Interest 31,154                  TOTAL EXPENDITURES 31,154                  NET TRANSFERS ‐                             CHANGE IN FUND BALANCE 4,934                     BEGINNING FUND BALANCE, Jan 1 3,999,457             ENDING FUND BALANCE, Jan 31 4,004,391$               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.    Arterial Streets Hotel‐Motel Tax Municipal Art Cable  Communications Springbrook  Wetlands REVENUES: Taxes ‐$                          27,123$                ‐$                           ‐$                           ‐$                           Licenses and permits ‐                             ‐                             ‐                            20,749                  ‐                             Grants / intergovernmental 53,953                  ‐                             ‐                             ‐                             ‐                             Investment Earnings ‐                            1,453                    136                       885                       503                        TOTAL REVENUES 53,953                 28,576                 136                       21,634                 503                        EXPENDITURES: Contracted Services ‐                            11,867                  ‐                             ‐                             ‐                             TOTAL EXPENDITURES ‐                            11,867                  ‐                             ‐                             ‐                             NET TRANSFERS ‐                             ‐                             ‐                             ‐                             ‐                             CHANGE IN FUND BALANCE 53,953                 16,709                 136                       21,634                 503                        BEGINNING FUND BALANCE, Jan 1 ‐                            943,889               98,865                 603,760               345,658                ENDING FUND BALANCE, Jan 31 53,953$               960,598$             99,001$               625,394$             346,161$                     Monthly Financial Report                                                               City of Renton, Washington January 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 Municipal  Facilities CIP Capital  Investment Housing  Opportunity New Library  Development Family First  Center REVENUES: Grants / intergovernmental ‐$                       ‐$                       ‐$                      198,789$          ‐$                       ‐$                       ‐$                       Charges for services 80,799              200,322           140                    ‐                         ‐                         ‐                         ‐                         Fines and penalties ‐                         ‐                         ‐                        790                    ‐                         ‐                         ‐                         Investment Earnings 3,241                5,244                40,211              25,528              3,742                211                   11,561               TOTAL REVENUES 84,039              205,567           40,350              225,108           3,742                211                   11,561               EXPENDITURES: Personnel ‐                         ‐                        45,901              8,343                 ‐                         ‐                         ‐                         Contracted Services ‐                         ‐                        322                    ‐                         ‐                         ‐                         ‐                         Capital Outlay ‐                         ‐                        87,582              13,303               ‐                         ‐                        15,459               TOTAL EXPENDITURES ‐                         ‐                        133,804           21,646               ‐                         ‐                        15,459               NET TRANSFERS ‐                         ‐                         ‐                         ‐                         ‐                         ‐                         ‐                         CHANGE IN FUND BALANCE 84,039              205,567           (93,454)            203,462           3,742                211                   (3,898)               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, Jan 31 1,971,038$      3,147,911$      26,302,113$    19,151,315$    2,574,092$      16,619$           8,547,503$         Monthly Financial Report                                                               City of Renton, Washington January 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 ‐$                      ‐$                      ‐$                      ‐$                       9,750$               ‐$                     7,475$               Charges for services 14,476             1,316,712       59,942             1,225,667        908,771            1,442,365       1,068,434          Rents, leases, and misc fees 264,267           ‐                        13,342             16,812               ‐                          ‐                         ‐                          Interest and other misc 9,217               5,012               770                  117,109            52,363              8,669               37,029               TOTAL REVENUES 287,960          1,321,724       74,054             1,359,588        970,884            1,451,034       1,112,938          EXPENSES: Personnel 94,945             52,756             110,546          348,467            188,722             ‐                        287,297             Supplies 1,821               150                  3,715               22,683              1,447                 ‐                        2,594                 Contracted Services 26,698             730,739          1,853               178,334            155,410            1,414,690       91,660               Internal Services 28,405             41,486             29,367             193,087            142,612             ‐                        169,858             TOTAL OPERATING EXPENSES 151,869          825,131          145,481          742,571            488,191            1,414,690       551,409             AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 136,091          496,593          (71,427)           617,017            482,693            36,344             561,529             DEBT SERVICE: Interest ‐                         ‐                         ‐                         ‐                          ‐                          ‐                        43,333               TOTAL DEBT SERVICE ‐                        ‐                        ‐                        ‐                          ‐                          ‐                       43,333               CAPITAL PROJECTS 4,099                ‐                        ‐                       10,441              9,582                 ‐                       20,764               TRANSFERS IN ‐                         ‐                        6,333                ‐                          ‐                          ‐                         ‐                          TRANSFERS OUT ‐                         ‐                        6,333                ‐                          ‐                          ‐                         ‐                          NET TRANSFERS ‐                        ‐                        ‐                        ‐                          ‐                          ‐                        ‐                          CHANGE IN FUND BALANCE 131,992          496,593          (71,427)           606,576            473,111            36,344             497,432             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, Jan 31 6,391,394$     2,762,720$     102,323$        38,175,643$    20,305,462$    5,998,250$     18,874,988$           Monthly Financial Report                                                               City of Renton, Washington January 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 ‐$                          ‐$                         20,674$                ‐$                          ‐$                          ‐$                          ‐$                          Grants / intergovernmental ‐                             ‐                             ‐                            21,835                  ‐                             ‐                             ‐                             Charges for services: Equipment rental m&o 254,491                ‐                            482,176                ‐                             ‐                             ‐                             ‐                             Print and mail ‐                             ‐                             ‐                             ‐                            37,786                  ‐                             ‐                             Communications ‐                             ‐                             ‐                             ‐                            56,667                  ‐                             ‐                             Facilities ‐                             ‐                             ‐                            437,376                ‐                             ‐                             ‐                             Interest and other misc 9,138                   28,176                 6,607                   1,768                   1,177                   7,637                   22,943                  Internal service fund misc: Vehicle / equipment capital recovery 228,314                ‐                             ‐                             ‐                             ‐                             ‐                             ‐                             Insurance premiums ‐                            143,130                ‐                             ‐                             ‐                             ‐                             ‐                             Worker's comp/unemployment ‐                            115,361                ‐                             ‐                             ‐                             ‐                             ‐                             Benefit premiums ‐                             ‐                             ‐                             ‐                             ‐                            916,817               218,724                Other misc 56                          ‐                             ‐                            13,084                  ‐                            97,735                  ‐                             Insurance recoveries ‐                            11,024                  ‐                             ‐                             ‐                             ‐                             ‐                             TOTAL REVENUES 491,999              297,691              509,457              474,062              95,630                 1,022,189           241,667               EXPENSES: Personnel 96,880                 122,618               250,782               261,921               73,792                 843,481               73,437                  Supplies 70,830                  ‐                            48,225                 34,320                 2,239                    ‐                             ‐                             Contracted Services 28,703                 537,856               342,433               29,454                 15,510                 11,171                 226                       Internal Services 3,058                    ‐                            150                      6,337                   328                      5,036                    ‐                             TOTAL OPERATING EXPENSES 199,471              660,474              641,590              332,032              91,869                 859,688              73,663                  AMOUNT AVAILABLE FOR DEBT  SERVICE, CAPITAL, AND TRANSFERS 292,528              (362,783)             (132,133)             142,030              3,761                   162,501              168,004               CAPITAL PROJECTS 116,760               ‐                             ‐                             ‐                             ‐                             ‐                             ‐                             TRANSFERS IN ‐                             ‐                             ‐                            1,954                    ‐                             ‐                             ‐                             TRANSFERS OUT ‐                             ‐                             ‐                             ‐                             ‐                             ‐                             ‐                             NET TRANSFERS ‐                             ‐                             ‐                            1,954                    ‐                             ‐                             ‐                             CHANGE IN FUND BALANCE 175,768              (362,783)             (132,133)             143,984              3,761                   162,501              168,004               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, Jan 31 7,027,579$         18,732,725$       4,357,929$         1,364,260$         807,322$            5,314,149$         15,967,733$               Monthly Financial Report                                                               City of Renton, Washington January 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 18,730$                ‐$                           Investment Earnings 3,139                    9,338                     TOTAL REVENUES 21,869                 9,338                     EXPENDITURES: Personnel ‐                            18,305                  TOTAL EXPENDITURES ‐                            18,305                  NET TRANSFERS ‐                             ‐                             CHANGE IN FUND BALANCE 21,869                 (8,967)                   BEGINNING FUND BALANCE, Jan 1 2,120,558            7,565,902             ENDING FUND BALANCE, Jan 31 2,142,427$          7,556,935$              Monthly Financial Report                                                               City of Renton, Washington January 2020  Page 7 of 7   City of Renton All Funds ‐ Revenue, Expenditures and Fund Balances Budgetary Basis through January 31, 2020 Funds Balance  01/01/2020 Budgeted  Revenue Revenue  01/31/20 Total Funds  Available Budgeted  Expenditure Expenditure  01/31/20 Ending Balance GENERAL FUND 48,056,982      125,388,240    8,737,532      56,794,514      130,877,560    7,805,336      48,989,178       SPECIAL REVENUE FUNDS: 1,992,172        415,574           104,802         2,096,974        215,574           11,867           2,085,107         102 Arterial Street ‐                          ‐                         53,953           53,953               ‐                          ‐                      53,953               110 Hotel Motel 943,889           200,000           28,576           972,465            ‐                         11,867           960,598            125 Municipal Art 98,865              117,900           136                 99,001              117,900            ‐                      99,001               127 Cable Communication 603,760           97,674              21,634           625,394           97,674               ‐                      625,394            135 Springbrook Wetlands Bank 345,658            ‐                         503                 346,161            ‐                          ‐                      346,161            DEBT SERVICE FUND 3,999,457        8,143,007        36,088           4,035,545        8,262,386        31,154           4,004,391         CAPITAL PROJECT FUNDS (CIP): 61,310,922      22,661,048      570,578         61,881,500      23,982,156      170,909         61,710,591       303 Community Services Mitigation 1,886,999        86,500              84,039           1,971,038        600,000            ‐                      1,971,038         305 Transportation Mitigation 2,942,344        1,435,875        205,567         3,147,911        1,340,362         ‐                      3,147,911         316 Municipal Facilities CIP 26,395,567      4,501,550        40,350           26,435,917      4,427,121        133,804         26,302,113       317 Transportation CIP 18,947,853      16,637,123      225,108         19,172,961      17,614,673      21,646           19,151,315       326 Housing Opportunity 2,570,350         ‐                         3,742             2,574,092         ‐                          ‐                      2,574,092         336 New Library Development 16,408               ‐                         211                 16,619               ‐                          ‐                      16,619               346 New Family First Center Dvlpmnt 8,551,401         ‐                         11,561           8,562,962         ‐                         15,459           8,547,503         ENTERPRISE FUNDS: 90,440,159      90,318,611      6,584,515      97,024,674      88,853,358      4,413,894      92,610,780       4X2 Airport Operating & CIP 6,259,402        3,051,767        287,960         6,547,362        2,439,468        155,968         6,391,394         403 Solid Waste Utility 2,266,127        19,505,719      1,321,724      3,587,851        19,401,611      825,131         2,762,720         4X4 Golf Operating & CIP 173,750           2,540,373        80,387           254,137           2,433,929        151,814         102,323            4X5 Water Operating & CIP 37,569,067      19,516,652      1,359,588      38,928,655      21,031,781      753,012         38,175,643       4X6 Waste Water Operating & CIP 19,832,351      11,630,784      970,884         20,803,235      11,952,906      497,773         20,305,462       416 King County Metro 5,961,906        17,007,226      1,451,034      7,412,940        17,007,226      1,414,690      5,998,250         4X7 Surface Water Operating & CIP 18,377,556      17,066,090      1,112,938      19,490,494      14,586,437      615,506         18,874,988       INTERNAL SERVICE FUNDS: 53,412,595      35,335,012      3,134,649      56,547,244      35,643,460      2,975,547      53,571,697       501 Equipment Repair/Replacement 6,851,811        5,662,319        491,999         7,343,810        4,673,176        316,231         7,027,579         502 Insurance 19,095,508      3,390,962        297,691         19,393,199      4,249,334        660,474         18,732,725       503 Information Services 4,490,062        5,924,868        509,457         4,999,519        6,394,677        641,590         4,357,929         504 Facilities 1,220,276        5,328,266        476,016         1,696,292        5,546,397        332,032         1,364,260         505 Communications 803,561           1,134,441        95,630           899,191           1,220,852        91,869           807,322            512 Insurance, Healthcare 5,151,648        12,649,694      1,022,189      6,173,837        12,526,781      859,688         5,314,149         522 Insurance, Leoff1 Retirees HC 15,799,729      1,244,462        241,667         16,041,396      1,032,243        73,663           15,967,733       FIDUCIARY FUNDS: 9,686,460        567,000           31,207           9,717,667        314,283           18,305           9,699,362         304 Fire Mitigation 2,120,558        99,000              21,869           2,142,427        113,808            ‐                      2,142,427         611 Firemen's Pension 7,565,902        468,000           9,338             7,575,240        200,475           18,305           7,556,935         TOTAL FUNDS 268,898,747 282,828,492 19,199,371 288,098,118 288,148,777 15,427,012 272,671,106     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 us at mbaker@rentonwa.gov or jhawn@rentonwa.gov.