Loading...
HomeMy WebLinkAbout201701, JanuaryADMINISTRATIVE SERVICES  DEPARTMENT       M   E   M   O   R   A   N   D   U   M       DATE: March 22, 2017     TO: Armondo Pavone, Council President  Members of the Renton City Council     CC: Denis Law, Mayor  Administrators     FROM: Hai Nguyen, Sr. Finance Analyst     SUBJECT: January 2017 Financial Status Report       At the end of January, general governmental revenues show $217k or 3% over budget.  Revenue  source(s) that are higher than expected are: utility taxes ($422k) and seizure funds ($102k,  restricted to drug enforcement and not available for general purposes).  If we remove seizure  funds, general governmental revenues are $115k or 1.6% over budget.  On the down side, the  revenue source(s) that are underperforming the year to date budget is business & occupation  taxes ($433k below).    General government expenditures showed a favorable variance of $144k or 2.1%.  See page 10  of report for further expenditure over‐spent explanations.    The attached report provides more detailed discussion of each revenue source and our updated  projections for the year.  Please do not hesitate to contact me at x6952 should you have any  questions or any suggestions about the report.         This page is intentionally left blank        General Governmental Funds $% Beginning Fund Balance 17,565,282$    17,565,282$   19,962,845$      19,962,845$  17,010,498$    17,010,498$ 26,563,785$   9,553,287      56.2% OPERATING REVENUES Property Tax 36,369,429       67,234             37,038,480       44,745           24,103,395     36,768           55,429              18,661            50.8% Sales Tax 23,439,266       1,758,332       26,353,246       1,978,530      25,700,400     2,031,194     2,092,821        61,627            3.0% Sales Tax ‐ Annexation Credit 2,778,858          208,322           3,114,762          234,180         3,063,280       229,995        247,737            17,741            7.7% Criminal Justice Sales Tax 2,484,718          187,139           2,701,787          204,149         2,679,898       202,181        213,532            11,351            5.6% Natural Gas Use Tax 228,899              25,336             184,638             23,504           228,000           29,024           15,569              (13,455)           ‐46.4% Admission Tax 309,790              83,675             262,506             76,393           320,000           89,502           60,741              (28,762)           ‐32.1% Franchise Fees 1,349,154          333,343           1,406,092          348,118         1,330,000       328,952        380,870            51,918            15.8% Electricity Tax 5,012,962          340,429           5,440,139          509,539         5,396,019       438,764        561,650            122,886          28.0% Natural Gas Utility Tax 1,437,552          190,306           1,327,937          187,353         1,350,900       184,481        222,337            37,857            20.5% Garbage/Solid Waste 638,073              10,033             717,148             50,860           680,000           30,554           52,200              21,646            70.8% TV Cable 1,591,866          134,496           1,619,364          139,333         1,645,659       140,329        140,113            (216)                 ‐0.2% Telephone 880,233              108,404           859,868             64,249           714,875           70,930           109,120            38,190            53.8% Cellular Phone 1,674,355          60,518             1,541,204          98,316           1,521,056       75,133           224,795            149,661          199.2% City Utilities 4,183,165          329,827           4,206,473          325,580         3,941,628       307,924        372,938            65,014            21.1% Utility Tax Audit 1,962,092          ‐                    111,227             111,227         ‐                     ‐                  ‐                     ‐                    0.0% Leasehold Excise Tax 163,314              ‐                    173,769             ‐                   179,000           ‐                  ‐                     ‐                    0.0% Gambling Excise Tax 2,299,156          158,293           2,500,604          189,749         2,000,000       145,025        220,536            75,511            52.1% Real Estate Excise Tax 4,595,166          226,377           6,121,830          1,204,479      4,420,000       708,703        1,028,456        319,752          45.1% Less: CIP REET (1,401,300)         (56,594)            (2,707,676)        (602,240)        (4,420,000)      (708,703)       (1,028,456)       (319,752)        45.1% EMS Levy 936,406              ‐                    479,597             ‐                   ‐                     ‐                  ‐                     ‐                    0.0% B&O Taxes ‐                      ‐                    6,375,322          ‐                   6,800,000       1,360,000     432,319            (927,681)        ‐68.2% Less: CIP B&O Taxes ‐                      ‐                    (2,000,000)        ‐                   (2,473,974)      (494,795)       ‐                     494,795          ‐100.0% Business License Fees 3,125,740          588,093           1,926,510          559,894         1,302,453       294,472        229,270            (65,202)           ‐22.1% Less: CIP Business License Fees (2,584,164)         (486,463)         (1,587,627)        (463,802)        (617,016)         (140,546)       (136,952)          3,594               ‐2.6% Animal Licenses and Spec Events Permits 101,743              9,230               102,905             6,640              92,575             7,655             7,190                (465)                 ‐6.1% Building Permits & Development Svc Fees 6,077,055          260,603           5,293,563          661,363         5,735,368       481,500        399,548            (81,952)            ‐17.0% Intergovt'l (Grants, State Shared, etc) 4,053,617          313,654           3,998,953          385,671         3,708,241       365,144        391,146            26,003            7.1% Fire District 25 and 40 Contracts 6,369,132           ‐                    3,517,779           ‐                  341,939           ‐                  ‐                     ‐                    0.0% Public Safety 649,797              58,509             994,179             104,644         613,081           60,800           64,424              3,624              6.0% Culture and Recreation 1,587,878          117,124           1,632,903          163,783         1,750,923       152,710        152,350            (360)                 ‐0.2% Interfund/Interdept‐Services 3,106,430          265,068           3,377,663          272,841         4,178,976       348,248        330,774            (17,474)           ‐5.0% Fines and Penalties 848,052              3,147               901,592             5,140              824,450           998                6,981                5,983              599.4% Photo Enforcement 2,171,184          121,709           1,959,071          131,281         2,044,000       125,201        127,976            2,775              2.2% Seizure Funds ‐ Federal/State/Local 21,676                ‐                    987,293             ‐                   ‐                     ‐                  101,755            101,755          100.0% Interests and Other Earnings 973,208              50,846             1,058,880          51,219           875,300           43,963           59,675              15,712            35.7% Rents, Leases, and Concessions 762,361              156,463           642,192             149,010         623,195           135,537        164,492            28,955            21.4% Contributions and Donations 147,292              7,247               96,582               ‐                   70,000             2,080             575                   (1,505)              ‐72.4% Other Miscellaneous 941,127              66,484             956,131             101,726         691,812           50,444           62,236              11,792            23.4% Other Financing Sources (Transfer‐In, etc) 270,224              ‐                    2,129,561          ‐                   158,696           13,225           ‐                     (13,225)            ‐100.0% Total Operating Revenues 119,555,505     5,697,180       125,816,444     7,317,475      101,574,129   7,147,391     7,364,146        216,755          3.0% OPERATING EXPENDITURES Council 320,877              32,033             358,550             34,732           368,211           36,183           36,043              140                  0.4% Executive 1,691,189          80,465             1,778,206          192,359         1,946,801       210,597        211,310            (714)                 ‐0.3% Emergency Management*398,808              54,794             370,832             25,024           587,790           60,959           35,052              25,907            42.5% City Attorney 1,791,167          151,100           1,983,834          157,485         2,163,329       176,840        168,105            8,735              4.9% Court Services 2,013,364          151,935           2,075,763          163,432         2,220,656       171,264        169,642            1,622              0.9% Community and Eco Dvlpmnt Admin 1,183,052          88,408             1,161,330          95,028           1,337,991       104,691        109,731            (5,039)              ‐4.8% Development Services 2,632,264          201,493           2,859,410          212,162         3,365,105       253,473        239,337            14,136            5.6% Economic Development 658,515              43,127             1,004,411          50,235           1,104,342       62,001           46,869              15,132            24.4% Planning 2,606,551          197,905           2,716,214          203,948         3,207,796       242,179        221,112            21,067            8.7% Finance 3,132,812          171,705           3,046,824          220,501         3,312,369       210,228        197,230            12,998            6.2% City Clerk 1,027,084          55,655             914,251             67,195           1,121,537       70,972           62,018              8,954              12.6% Human Resources 1,182,629          66,108             1,193,016          89,683           1,321,317       86,650           87,874              (1,224)              ‐1.4% Police 28,144,699       2,351,965       28,891,879       2,427,387      30,291,917     2,538,296     2,564,523        (26,227)            ‐1.0% Jail Services 4,142,266          344,859           4,704,978          391,994         4,850,000       400,352        400,352             ‐                    0.0% Fire* 26,138,192       2,013,057       25,349,755       2,266,350       ‐                     ‐                  ‐                     ‐                    0.0% Community Services Admin 508,766              41,417             585,983             52,449           505,154           43,313           44,101              (788)                 ‐1.8% Parks 4,411,383          291,345           4,445,115          302,959         5,091,258       341,642        309,997            31,646            9.3% Parks Planning & Natural Resources 808,558              46,145             952,980             46,446           1,177,483       61,892           53,458              8,434              13.6% Recreation 5,088,483          338,282           5,096,236          330,010         5,674,455       372,341        347,558            24,783            6.7% Human Services 1,225,835          46,455             1,241,169          81,352           1,279,916       66,308           98,615              (32,307)           ‐48.7% Neighborhoods, Resources, & Events 958,624              57,115             865,551               66,354             1,041,408         70,488             60,703              9,785               13.9% Museum 227,094              18,605             229,543               19,061             236,275             19,490             19,400              89                     0.5% Public Works Admin 387,493              31,422             398,796             33,119           406,398           33,358           33,498              (140)                 ‐0.4% Street Maintenance 5,061,723          387,644           5,041,509          400,277         5,415,126       422,310        408,757            13,553            3.2% Transportation 4,975,059          300,741           5,966,281          356,191         5,669,897       340,428        326,959            13,469            4.0% Debt Service 6,371,715          48,139             6,099,166          44,758           6,066,629       41,377           41,377              ‐                    0.0% Non‐Departmental and Other 10,069,740       455,629           9,883,923          294,800         9,445,551       301,517        301,517            ‐                    0.0% Total Operating Expenditures 117,157,942     8,067,548       119,215,504     8,625,290      99,208,714     6,739,148     6,595,136        144,013          2.1% Total Ending Fund Balance 19,962,845$     15,194,914$   26,563,785$      18,655,030$  19,375,913$    17,418,741$ 27,332,795$   9,914,054$    56.9% *Emergency Management was moved to Executive due to formation of RRFA Favorable (Unfavorable) 2015 2016 2017 Variance Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual   Monthly Financial Report January 2017 Page 1 of 37 Monthly Financial Report January 2017      OVERVIEW  This financial overview reflects the City’s overall financial position for the fiscal year through January 31, 2017.  Except as  noted, year‐to‐date budgeted revenues and operating expenditures are generally based on the collection/disbursement  patterns for the same period of the preceding two years.  The table on the previous page summarizes the general  governmental fund revenues and expenditures.    Revenues    Taxes   The combined collection of property, sales/use, utility, gambling, admissions, and real estate excise taxes represents 70% of  all resources supporting general governmental activities.   The following section provides detail information on property,  sales, utility, and other taxes.    Property Tax  January’s collection is $55k or  0.2% of the total budget.  In  comparison to the previous year,  the City collected $11k or 24%  more.  Compared to the budget,  the City collected $19k or 51%  more.                           Sales Tax  January 2017 sales tax receipts  totaled $2.1 million.  Compared  with the same month last year, it  is $114k or 6% more.  Compared  to the projected current month’s  budget, it is $62k or 3% above.     Auto, Retail, and Wholesale are  the sectors that are collecting  more than anticipated.  2017’s  monthly budgets are generally  based on 2011 through 2016  collections.  2016 2017 2017 Actual Budget Actual $ % $ % Jan 44,745$            36,768$            55,429$            10,684$            24% 18,661$            51% Feb 315,119            204,274             Mar 1,273,685        726,604             Apr 7,856,230        5,915,645         May 9,906,533        5,742,951         Jun 137,794            93,616                Jul 57,174               40,245                Aug 240,536            110,113             Sep 558,716            367,830             Oct 6,233,910        4,103,547         Nov 10,268,791     6,647,038         Dec 145,246            114,763             YTD  Total 44,745$            36,768$            55,429$            10,684$            24% 18,661$            51% Annual  Total 37,038,480$  24,103,395$   Property Tax  Revenues Year  to Date through January 2017 vs. 2016 2017 vs. Budget Month 2016 2017 2017 Actual Budget Actual $ % $ % Jan 1,978,530$     2,031,194$     2,092,821$     114,291$         6% 61,627$            3% Feb 2,320,497        2,422,103         ‐                          Mar 1,854,773        1,886,175        ‐                          Apr 1,888,875        1,881,780        ‐                          May 2,314,220        2,200,305        ‐                          Jun 2,127,406        1,967,578        ‐                          Jul 2,103,896        2,017,854        ‐                          Aug 2,438,277        2,274,282        ‐                          Sep 2,179,438        2,171,299        ‐                          Oct 2,410,824        2,262,292        ‐                          Nov 2,532,820        2,367,730        ‐                          Dec 2,203,689        2,217,808        ‐                          YTD  Total 1,978,530$     2,031,194$     2,092,821$     114,291$         6% 61,627$            3% Annual  Total 26,353,246$  25,700,400$   2017 vs. Budget2017 vs. 2016 Month Year  to Date through January Local Retail Sales  Tax  Revenues Page 2 of 37 Monthly Financial Report January 2017      The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business  sectors:                      Utility tax   January utility tax revenues are  $1.7 million, which is $189k or  13% higher than the same month  last year and is also higher than  the budget by $422k or 33%.  The  large January variance with the  budget is due to lower 2015  activity for Electricity and the  timing of when 2015  Cell/Garbage taxes were  recorded.  The monthly budgets  are based on 2015/2016 activity.            The table below breaks out Utility Tax by source.          Sales  Tax  by Sector 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act  vs  Bgt New Construction 297,334$         364,151$         356,048$         58,714$          20%$            (8,103)‐2% Auto  Sales 402,664            374,236            394,601            (8,064)               ‐2%              20,365 5% General Retail 567,819            585,374            629,217            61,398             11%              43,842 7% Manufacturing 174,190            118,707            111,398            (62,792)            ‐36%               (7,309)‐6% Wholesale 86,478               105,428            120,058            33,580             39%              14,630 14% Service 405,236            434,851            435,680            30,443             8%                      829 0% Other 44,809               48,447               45,820               1,010                2%               (2,627)‐5% YTD  Total 1,978,530$     2,031,194$     2,092,821$     114,291$       6%61,627$           3% Note: Excludes Annexation Credit and Criminal Justice Sales  Tax revenue. 2016 2017 2017 Actual Budget Actual $ % $ % Jan 1,509,960$     1,277,138$     1,698,721$     188,761$         13% 421,584$         33% Feb 1,597,348        1,458,074         Mar 1,423,774        1,462,603         Apr 1,346,282        1,289,233         May 1,363,323        1,284,502         Jun 1,125,845        1,177,807         Jul 1,276,335        1,234,377         Aug 1,247,926        1,269,789         Sep 1,277,502        1,227,003         Oct 1,351,888        1,252,150         Nov 1,128,100        1,206,958         Dec 1,359,717        1,338,504         YTD  Total 1,509,960$     1,277,138$     1,698,721$     188,761$         13% 421,584$         33% Annual  Total 16,007,999$  15,478,137$   2017 vs. Budget2017 vs. 2016 Year  to Da te through January Utility Tax  Revenues Month Utility Tax  by Type 2016 2017 Bgt YTD Act Change 2017/2016  2017 Act  vs  Bgt  Electrical 509,539$         438,764$         561,650$         52,111$          10%$        122,886 28% Natural  Gas 210,857            213,504            237,906            27,050             13%              24,402 11% Cell 98,316               75,133               224,795            126,478          129%           149,661 199% Phone 64,249               70,930               109,120            44,871             70%              38,190 54% Cable 139,333            140,329            140,113            780                    1%                    (216) 0% Garbage/Solid Waste 50,860               30,554               52,200               1,340                3%              21,646 71% City Utilities 325,580            307,924            372,938            47,358             15%              65,014 21% Utility Tax  Audit 111,227            ‐                              ‐                              (111,227)        0%                             ‐ N/A YTD  Total 1,509,960$     1,277,138$     1,698,721$     188,761$       13%421,584$        33% Annual Total 16,007,999$  15,478,137$   YTD  as % of 9%8% Page 3 of 37 Monthly Financial Report January 2017      Other Taxes     Real Estate Excise Tax  The City collected $1 million in  Real Estate Excise Tax revenues  (REET) for January.  This is $176k  or 15% less than the same month  last year but is $320k or 45%  more than the current month’s  budget.  The higher than  expected variance is due to 7  large transactions in December,  which accounts for $696k of the  total REET collected.                Gambling Tax  January’s Gambling Tax  collections totaled $221k, which  is $31k or 16% above the same  month last year and is also above  the current month’s budget by  $76k or 52%.                          Franchise Fees  Franchise Fees are due quarterly  in January, April, July, and  October.  The year‐to‐date total  of $381k is $33k or 9% higher  than the prior year and is also  $52k or 16% above the projected  year‐to‐date budget.  2016 2017 2017 Actual Budget Actual $ % $ % Jan 1,204,479$     708,703$         1,028,456$     (176,023)$        ‐15% 319,752$         45% Feb 197,327            148,787             Mar 208,452            204,512             Apr 335,985            298,627             May 475,244            361,568             Jun 405,179            346,520             Jul 644,038            497,925             Aug 759,583            484,354             Sep 522,472            401,943             Oct 559,552            434,871             Nov 502,139            266,351             Dec 307,382            265,838             YTD  Total 1,204,479$     708,703$         1,028,456$     (176,023)$        ‐15% 319,752$         45% Annual  Total 6,121,830$     4,420,000$      *For 201 7, REET is only in CIP Month 2017 vs. Budget2017 vs. 2016 Real Estate Excise  Tax (REET) Revenues* Year  to Date through January 2016 2017 2017 Actual Budget Actual $ % $ % Jan 189,749$         145,025$         220,536$         30,786$            16% 75,511$            52% Feb 207,961            163,404            ‐                          Mar 195,255            151,889            ‐                          Apr 197,286            168,730            ‐                          May 198,234            158,893            ‐                          Jun 185,042            149,623            ‐                          Jul 194,317            162,180            ‐                          Aug 322,828            229,017            ‐                          Sep 202,409            159,756            ‐                          Oct 242,254            190,582            ‐                          Nov 183,345            165,084            ‐                          Dec 181,924            155,817            ‐                          YTD Total 189,749$         145,025$         220,536$         30,786$            16% 75,511$            52% Annual  Total 2,500,604$     2,000,000$      2017 vs. 2016 Gambling Tax Revenue Month Year  to Date through January 2017 vs. Budget 2016 2017 2017 Actual Budget Actual $ % $ % Jan 348,118$         328,952$         380,870$         32,752$            9% 51,918$            16% Apr 355,430            333,387             ‐                          Jul 343,910            330,451            ‐                          Sep 5,000                  2,414                  ‐                          Oct 348,783            332,455            ‐                          Dec 4,850                  2,341                  ‐                          YTD  Total 348,118$         328,952$         380,870$         32,752$            9% 51,918$            16% Annual  Total 1,406,092$     1,330,000$      Franchise  Fees Revenue Year  to Date through January Month 2017 vs. 2016 2017 vs. Budget Page 4 of 37 Monthly Financial Report January 2017      Admission Tax   Admission Tax returns are due  quarterly in January, April, July,  and October of each year.   January 2017 collections  represent activities conducted  during the 4th quarter of 2016.   The year‐to‐date collection of  $61k is $16k or 20% less than the  prior year and is also $29k or 32%  less than the budget.            Business & Occupation Tax  Business and Occupation (B&O)  Tax is a new revenue source for  the City in 2016.  It was adopted  by the Council in the 2015/2016  biennial budget.  Businesses with  gross receipts of $1.5 million or  more per year, earned within the  City of Renton, will be required to  file and pay B&O tax, in lieu of the  Per Employee Fee, which is  currently reported as Business  License revenue.  Year‐to‐date  receipts totaled $432k.          Licenses and Permits    Business Licenses  Business Licenses totaled $229k  for January, which is $331k or  59% below the same month last  year and is also $65k or 22%  below the current month’s  budget.  The variance with the  prior year is due the City adopting  the Business & Occupation Tax  for 2016 (January 2016  represents 2015 4th quarter  activity).     2016 2017 2017 Actual Budget Actual $ % $ % Jan 76,393$            89,502$            60,741$            (15,652)$            ‐20% (28,762)$            ‐32% Feb 1,360                  1,527                   ‐                          Mar ‐                        59                           ‐                          Apr 63,088               71,681               ‐                          May ‐                        852                       ‐                          Jul 60,763               80,276               ‐                          Sep 518                       289                       ‐                          Oct 58,934               74,983               ‐                          Nov 1,452                  831                       ‐                          YTD  Total 76,393$            89,502$            60,741$            (15,652)$            ‐20% (28,762)$            ‐32% Annual  Total 262,506$         320,000$          2017 vs. Budget Admission  Tax  Revenue Year  to Date through January Month 2017 vs. 2016 2016 2017 2017 Actual Budget Actual $ % $ % Jan ‐$                           1,360,000$     432,319$         432,319$         100% (927,681)$         ‐68% Feb ‐                        170,000             ‐                          Mar ‐                        170,000             ‐                          Apr 4,578,349        1,360,000        ‐                          May 304,032            170,000            ‐                          Jun 30,591               170,000            ‐                          Jul 376,209            1,360,000        ‐                          Aug 334,807            170,000            ‐                          Sep 10,779               170,000            ‐                          Oct 603,622            1,360,000        ‐                          Nov 136,933            170,000            ‐                          Dec ‐                        170,000            ‐                          YTD  Total ‐$                           1,360,000$     432,319$         432,319$         100% (927,681)$        ‐68% Annual  Total 6,375,322$     6,800,000$      *Total Business & Occupation Taxes (GF & CIP) Business & Occupation Taxes* Year  to Date through January Month 2017 vs. 2016 2017 vs. Budget 2016 2017 2017 Actual Budget Actual $ % $ % Jan 559,894$         294,472            229,270$         (330,624)$         ‐59% (65,202)$            ‐22% Feb 275,059            127,682             ‐                          Mar 31,642               14,759                ‐                          Apr 207,099            184,956            ‐                          May 111,131            72,269               ‐                          Jun 26,936               13,489               ‐                          Jul 248,769            228,999            ‐                          Aug 121,095            65,678               ‐                          Sep 22,190               13,573               ‐                          Oct 218,271            222,326            ‐                          Nov 91,870               56,325               ‐                          Dec 12,555               7,925                  ‐                          YTD  Total 559,894$         294,472$         229,270$         (330,624)$        ‐59% (65,202)$            ‐22% Annual  Total 1,926,510$     1,302,453$      *Total Business License (GF & CIP) Business Licenses* Month 2017 vs. 2016 Year  to Date through January 2017 vs. Budget Page 5 of 37 Monthly Financial Report January 2017      Building Permits and  Development Service Fees  Building Permits and  Development Service Fee  revenues totaled $400k in  January.  This is $262k or 40% less  than the year before and is also  $82k or 17% lower than budget.   The large variances in January  2016 is due to large payments for  building permits and plan review  (Southport Developer and Group  Health).            Intergovernmental  These revenue sources  include federal (direct  and indirect) grants,  state grants, state  shared revenues, local  grants, and  entitlements.  State  shared revenues 90% of  the total revenues in this  category.  The year‐to‐ date total  Intergovernmental revenue is $605k or 9% of the budget.       State Shared Revenues  State Shared Revenue  collections totaled  $543k since the start of  the year.  Compared to  the prior year, State  Shared Revenues are  above by $12k or 2%.   Compared to the  projected budget, the  City is collecting $41k or  8% more.  The higher  than expected collection  is due to collecting more  than anticipated  Criminal Justice’s Sales Tax and Liquor Excise Tax.       2016 2017 2017 Actual Budget Actual $ % $ % Jan 661,363$         481,500$         399,548$         (261,815)$         ‐40% (81,952)$            ‐17% Feb 413,420            379,615             Mar 583,658            440,847             Apr 336,108            484,673             May 376,324            310,348             Jun 437,619            698,400             Jul 462,211            691,725             Aug 397,578            438,730             Sep 380,480            498,572             Oct 479,048            478,350             Nov 297,449            359,940             Dec 468,303            472,668             YTD  Total 661,363$         481,500$         399,548$         (261,815)$         ‐40% (81,952)$            ‐17% Annual  Total 5,293,563$     5,735,368$      Building Permits and Development Service  Fees Year  to Date through January 2017 vs. Budget2017 vs. 2016 Month Intergovernmental 2016 2017 Bgt YTD  Act Change 2017/2016 2017 Act  vs  Bgt  Fire District #25 ‐$                            ‐$                            ‐$                            ‐$                         N/A  $                          ‐ N/A Fire District #40 ‐                               ‐                               ‐                               ‐                            N/A ‐                            N/A State  Shared Revenue 531,010            501,960            543,102            12,092             2% 41,142             8% Federal  Grants ‐                              9,173                  9,173                  9,173                100%‐                            0% State  Grants ‐                               ‐                               ‐                               ‐                            N/A ‐                            N/A Other  Grants/Intgovt 58,810               56,191               52,403               (6,407)               ‐11% (3,788)                ‐7% ARRA Grants ‐                               ‐                               ‐                               ‐                            N/A ‐                            N/A Total  Rev YTD 589,820$         567,324$         604,678$         14,858$          3%37,354$           7% Total  Rev Annual 10,698,115$  6,730,078$      YTD % 6 %8 %9 % Note:  Includes  CJ Sales  Tax  and FD25 & FD40 contracts 2016 2017 2017 Actual Budget Actual $ % $ % Crim Just Sales  Tax 204,149$         202,181$         213,532$         9,383$               5% 11,351$            6% Judicial Contribution ‐                         ‐                         ‐                         ‐                         N/A ‐                        N/A Crim Just ‐ High Crime 77,796               62,415               67,721               (10,075)               ‐13% 5,305                  8% Crim Just ‐ Pop 6,626                  5,951                  7,006                  379                       6% 1,054                  18% Crim Just ‐ Spec Prog 24,226               22,130               25,487               1,261                  5% 3,357                  15% State  DUI 3,873                  4,673                  3,863                  (11)                        0% (810)                      ‐17% Marijuana  Enforcement ‐                        ‐                         ‐                         ‐                         N/A ‐                        N/A Liquor Profits ‐                        ‐                         ‐                         ‐                         N/A ‐                        N/A Liquor Excise  Tax 104,339            94,180               113,721            9,382                  9% 19,541               21% Fuel  Tax 110,001            110,430            111,774            1,773                  2% 1,344                  1% YTD  Total 531,010$         501,960$         543,102$         12,092$            2% 41,142$            8% Annual Total 5,933,890$     5,805,528$      2017 vs. Budget State Shared Revenues 2017 vs. 2016 Revenue Year to Date through January Page 6 of 37 Monthly Financial Report January 2017      Charges for Services   These revenue sources consist of general government, public safety, plan review and inspection, culture and recreation, and  interfund/interdepartmental sales and services.  Recreation and interfund/interdepartmental sales and services constitute  64% of the total revenue in this category.  The year‐to‐date total charges for services are $750k or 9% of the budget.  The  following sections provide detail information for Public Safety, Recreation, and Interfund Services.      Public Safety Services  Public Safety Services totaled  $64k since the start of the year.   These services include private  security, adult probation  services, monitoring of prisoners,  and intergovernmental public  safety services (non‐grants).   Compared to the prior year, the  City is collecting $40k or 38% less.   Compared to the year‐to‐date  budget, the City is over budget by  $4k or 6%.  The variance with the  prior year is due to collecting a  large payment/reimbursement  for electronic home detention.        Recreation  Recreation revenues totaled  $152k for the current month.   Compared to the same month  the prior year, the City collected  $11k or 7% less.  Compared to the  projected monthly budget, the  City is right on target.           2016 2017 2017 Actual Budget Actual $ % $ % Jan 104,644$         60,800$            64,424$            (40,221)$            ‐38% 3,624$               6% Feb 99,623               52,862                ‐                          Mar 58,031               44,909                ‐                          Apr 51,002               73,680               ‐                          May 48,201               38,573               ‐                          Jun 179,089            79,037               ‐                          Jul 34,906               27,743               ‐                          Aug 44,439               38,564               ‐                          Sep 67,570               33,790               ‐                          Oct 160,438            72,212               ‐                          Nov 67,763               42,537               ‐                          Dec 78,473               48,375               ‐                          YTD  Total 104,644$         60,800$            64,424$            (40,221)$            ‐38% 3,624$               6% Annual  Total 994,179$         613,081$          Year  to Date through January Public Safety Services 2017 vs. 2016 2017 vs. Budget Month 2016 2017 2017 Actual Budget Actual $ % $ % Jan 163,783$         152,710$         152,350$         (11,433)$            ‐7% (360)$                  0% Feb 48,009               42,505                ‐                          Mar 60,615               52,493                ‐                          Apr 112,627            110,918            ‐                          May 72,246               74,076               ‐                          Jun 239,771            254,264            ‐                          Jul 325,043            409,892            ‐                          Aug 349,650            360,345            ‐                          Sep 107,652            123,607            ‐                          Oct 45,706               55,007               ‐                          Nov 68,324               70,632               ‐                          Dec 39,475               44,472               ‐                          YTD  Total 163,783$         152,710$         152,350$         (11,433)$           ‐7% (360)$                  0% Annual  Total 1,632,903$     1,750,923$      Recreation Year  to Date through January 2017 vs. Budget2017 vs. 2016 Month Page 7 of 37 Monthly Financial Report January 2017      Interfund Services  The year‐to‐date collections for  Interfund Services revenues are  $331k.  Compared to the prior  year, the revenues are over by  $58k or 21%.  Compared to the  projected budget, the revenues  are below by $17k or 5%.  2017’s  monthly budgets are based on  1/12th of the annual budget.  The  majority of these revenues are  related to indirect cost  allocations, which are internal  administrative costs.  The  remaining costs consist of  Development Services division’s  inspection fees, Parks Planning  and Natural Resources division’s capital investment program reimbursements, Transportation division’s capital investment  program reimbursements, and Maintenance division’s street maintenance reimbursements.      Fines and Penalties  These revenue sources contain  civil (penalties, infractions, and  parking), criminal (traffic, non‐ traffic, and costs), and non‐court  fines, forfeitures, and penalties.   The table below breaks down  these fines by type.  The year‐to‐ date total fines and penalties is  $135k.  This is $1k or 1% lower  than a year ago but is $9k or 7%  above the budget.                2016 2017 2017 Actual Budget Actual $ % $ % Jan 272,841$         348,248$         330,774$         57,933$            21% (17,474)$            ‐5% Feb 286,748            348,248             ‐                          Mar 305,054            348,248             ‐                          Apr 276,238            348,248            ‐                          May 272,641            348,248            ‐                          Jun 260,223            348,248            ‐                          Jul 259,888            348,248            ‐                          Aug 273,851            348,248            ‐                          Sep 286,057            348,248            ‐                          Oct 277,517            348,248            ‐                          Nov 295,584            348,248            ‐                          Dec 311,019            348,248            ‐                          YTD  Total 272,841$         348,248$         330,774$         57,933$            21% (17,474)$           ‐5% Annual  Total 3,377,663$     4,178,976$      Interfund Services Ye ar  to Date through January 2017 vs. 2016 2017 vs. Budget Month 2016 2017 2017 Actual Budget Actual $ % $ % Jan 136,421$         126,199$         134,957$         (1,464)$               ‐1% 8,758$               7% Feb 217,667            213,156             Mar 263,648            264,385             Apr 250,873            242,171             May 214,613            231,927             Jun 261,254            261,299             Jul 222,267            219,171             Aug 274,964            252,324             Sep 200,986            232,621             Oct 238,517            243,770             Nov 273,338            270,941             Dec 306,114            310,486             YTD  Total 136,421$         126,199$         134,957$         (1,464)$               ‐1% 8,758$               7% Annual  Total 2,860,662$     2,868,450$      2017 vs. Budget2017 vs. 2016 Year  to Date through January Fines  and Penalties by Month Month Year  to Date through January 2016 2017 2017 Actual Budget Actual $ % $ % Civil Penalties ‐$                            ‐$                            ‐$                            ‐$                           N/A ‐$                           N/A Civil Infraction Penalties ‐                         ‐                         ‐                         ‐                         N/A ‐                        N/A Civil Parking Infraction Penalties ‐                        ‐                         ‐                         ‐                         N/A ‐                        N/A Photo Enforcement Program 131,281            125,201            127,976            (3,305)                  ‐3% 2,775                  2% Criminal Traffic  Misdemeanor  Fines ‐                        ‐                         ‐                         ‐                         N/A ‐                        N/A Criminal Non‐Traffic  Fines ‐                        ‐                         2,485                  2,485                  100% 2,485                  100% Criminal Costs ‐                         ‐                         ‐                         ‐                         N/A ‐                        N/A Non‐Court Fines, Forfeitures  and Penalties 5,140                  998                       4,496                  (644)                      ‐13% 3,498                  350% YTD  Total 136,421$         126,199$         134,957$         (1,464)$               ‐1% 8,758$               7% Annual Total 2,860,662$     2,868,450$      Revenue 2017 vs. Budget Fines  and Penalties by Type 2017 vs. 2016 Page 8 of 37 Monthly Financial Report January 2017      Included in the Fines and Penalties revenue  budget is $2 million from the Photo  Enforcement program.  The monthly budget  is based on the prior year’s revenue.  The  year‐to‐date collections from this program  equates to $128k.      The associated costs includes the equipment  provided by American Traffic Solutions, Inc.  (ATS), dedicated 1 FTE in the Court Services  Department to process the increased  caseload and 1.1 FTEs in the Police  Department for support services.  This staff  time, along with a 50% pro tem budget and  interpreter costs amounts to $318k for  personnel costs.  The total costs for the  program equates to $1.1 million which is  represented in the table.  Due to the timing  of when the invoice was received, January 2017’s equipment rental cost was recorded in February.      Miscellaneous  This revenue source reflects the  collection of interest and other  earnings, rents, leases, and  concessions, contributions, and  donations from private sources,  and other miscellaneous  revenues.  The year‐to‐date  total miscellaneous is $364k.   Compared to last year, the  revenues are above by $105k or  41%.  Compared to the  projected year‐to‐date budget,  the revenues are over by $155k  or 74%.  The large variance with  the prior year and budget is due  to collecting more than  anticipated Seizure Funds.   Seizure Funds are restricted to drug enforcement only and are not available for general operating purposes.           Favorable 17 Budget 17 Actual 17  Budget 17 Actual (Unfavorable)1 Jan 125,201$         127,976$         89,775$            27,432$            100,544$          Feb 157,962             ‐                         89,775               ‐                         ‐                          Mar 189,510            ‐                         89,775               ‐                         ‐                          Apr 165,633            ‐                         89,775               ‐                         ‐                          May 152,426            ‐                         89,775               ‐                         ‐                          Jun 194,994            ‐                         89,775               ‐                         ‐                          Jul 144,851            ‐                         89,775               ‐                         ‐                          Aug 183,427            ‐                         89,775               ‐                         ‐                          Sep 164,770            ‐                         89,775               ‐                         ‐                          Oct 175,856            ‐                         89,775               ‐                         ‐                          Nov 185,108            ‐                         89,775               ‐                         ‐                          Dec 204,263            ‐                         89,775               ‐                         ‐                          YTD  Total 125,201$         127,976$         89,775$            27,432$            100,544$          Annual  Total 2,044,000$     1,077,297$      1Actuals  of Revenues and Expenses ExpensesRevenues Photo Enforcement  Program Year to Date through January Month 2016 2017 2017 Actual Budget Actual $ % $ % Jan 258,876$         209,007$         363,997$         105,122$         41% 154,990$         74% Feb 802,908            110,239             Mar 125,950            117,209             Apr 142,439            105,158             May 139,504            115,995             Jun 174,848            153,488             Jul 181,285            152,155             Aug 294,665            157,045             Sep 160,616            117,537             Oct 152,817            119,343             Nov 327,568            101,491             Dec 425,765            365,451             YTD  Total 258,876$         209,007$         363,997$         105,122$         41% 154,990$         74% Annual Total 3,187,241$     1,824,117$      Year  to Date through January Month 2017 vs. Budget2017 vs. 2016 Miscellaneous Revenues  by Month 2016 2017 2017 Actual Budget Actual $ % $ % Interests and Other Earnings 51,219$            43,963$            59,675$            8,457$               17% 15,712$            36% Rents, Leases, and Concessions 149,010            135,537            164,492            15,483               10% 28,955               21% Contributions/Donations from Private Sources ‐                        2,080                  575                       575                       100% (1,505)                  ‐72% Other 58,647               27,427               37,500               (21,148)               ‐36% 10,073               37% Seizure  Funds ‐ Federal/State/Local ‐                        ‐                         101,755            101,755            100% 101,755            100% YTD  Total 258,876$         209,007$         363,997$         105,122$         41% 154,990$         74% Annual Total 3,187,241$     1,824,117$      2017 vs. Budget Miscellaneous Revenues  by Type Year  to Date through January Revenue 2017 vs. 2016 Page 9 of 37 Monthly Financial Report January 2017      EXPENSES  Overall the City has expended 7% of its budgeted general governmental expenditures at the end of January.  This is $144k or  2.1% below year‐to‐date budgeted expenditures.  See below for summary of unfavorable items for general governmental  departments.      Police department is over the year‐to‐date budget by $26k or 1%.  This is due to the spending patterns of supplies,  professional services, intergovernmental, and interfund services in 2015/2016 compared to 2017.     Page 10 of 37 Monthly Financial Report January 2017      ENTERPRISE FUNDS  The table below gives an analysis of all City Enterprise funds.  Displayed are the year‐to‐date revenues and expenditures for  each enterprise.  Included in each funds are the capital revenues and expenditures.  Airport Golf Course Solid Waste  Utility Water Utility Wastewater  Utility Surface Water  Utility Metro REVENUES: Licenses and permits ‐                   ‐                 ‐                 ‐                 7,900             4,500              ‐                  Grants / intergovernmental ‐                  ‐                 ‐                 ‐                 ‐                  106,541          ‐                  Charges for services 9,923              45,688          1,505,623    1,180,677    818,362        989,318          1,308,872     Interdepartmental services ‐                  ‐                 ‐                 ‐                 ‐                  ‐                   ‐                  Fines and penalties 272                 ‐                 ‐                 ‐                 50                   ‐                   ‐                  Rents, leases, and misc fees 242,770          14,476          ‐                 18,655          ‐                  ‐                   ‐                  Interest and other misc 2,486              180               2,067            23,776          657,797        272,728          2,683             TOTAL REVENUES 255,451          60,344          1,507,690    1,223,108    1,484,109    1,373,087      1,311,555     EXPENSES: Utility billing ‐                  ‐                 9,917            13,692          13,230          23,155            ‐                  Utility systems ‐                  ‐                 571,292        263,344        265,211        236,303          ‐                  Utility maintenance ‐                  ‐                 24,820          370,470        146,968        210,391          1,400,157     Transportation 164,122          ‐                 ‐                 ‐                 ‐                  ‐                   ‐                  Golf ‐                  140,373        ‐                 ‐                 ‐                  ‐                   ‐                  TOTAL EXPENSES 164,122          140,373        606,029        647,506        425,409        469,849          1,400,157     AMOUNT AVAILABLE FOR DEBT SERVICE 91,329            (80,029)         901,661        575,602        1,058,700    903,238          (88,602)          DEBT SERVICE: Principal ‐                  ‐                 ‐                 ‐                 ‐                  ‐                   ‐                  Interest ‐                  ‐                 ‐                 ‐                 ‐                  43,337            ‐                  TOTAL DEBT SERVICE ‐                  ‐                 ‐                 ‐                 ‐                  43,337            ‐                  CAPITAL PROJECTS ‐                  828               ‐                 8,698            15,840          12,249            ‐                  TRANSFERS IN/(OUT)‐                  ‐                 ‐                 ‐                 ‐                  ‐                   ‐                  CHANGE IN FUND BALANCE 91,329            (80,857)         901,661        566,904        1,042,860    847,652          (88,602)          BEGINNING FUND BALANCE, Jan 1 2,619,343      37,088          2,751,417    28,528,934  13,859,662  10,893,975    4,994,658     ENDING FUND BALANCE, Jan 31 2,710,672      (43,769)         3,653,078    29,095,838  14,902,522  11,741,627    4,906,056           Page 11 of 37 Monthly Financial Report January 2017      INTERNAL SERVICE FUNDS  The table below gives an analysis of all City Internal Service Funds.  Displayed are the year‐to‐date revenues and expenditures  for each internal service.  Included in each fund are the capital revenues and expenditures.  Equipment  Rental Information  Technology Facilities Communication s Insurance Healthcare Retiree  Healthcare REVENUES: Technology Fee ‐                11,193        ‐               ‐                     ‐                ‐                ‐                Grants / intergovernmental ‐                ‐               ‐               ‐                     ‐                ‐                ‐                Charges for services Equipment rental m&o 226,694       354,204     ‐               ‐                     ‐                ‐                ‐                Print and mail ‐                ‐               ‐               36,592             ‐                ‐                ‐                Communications ‐                66,209       79,042       53,158             ‐                ‐                ‐                Facilities ‐                ‐               339,546     ‐                     ‐                ‐                ‐                Data cards and cell phones ‐                ‐               ‐               ‐                     ‐                ‐                ‐                IT service contracts ‐                ‐               ‐               ‐                     ‐                ‐                ‐                Interest and other misc 3,545            1,525          834             299                   6,916           2,227            5,414           Internal service fund misc: Vehicle / equipment capital recovery 184,494       40,348       ‐               ‐                     ‐                ‐                ‐                Insurance premiums ‐                ‐               ‐               ‐                     143,067     ‐                ‐                Worker's comp/unemployment ‐                ‐               ‐               ‐                     109,200     ‐                ‐                Benefit premiums ‐                ‐               ‐               ‐                     ‐                765,942       218,720      Other misc 57                 ‐               ‐               ‐                     ‐                74,382         ‐                Interfund Loan ‐                ‐               ‐               ‐                     ‐                ‐                ‐                Capital contributions ‐                ‐               ‐               ‐                     ‐                ‐                ‐                Disposal of capital assets ‐                ‐               ‐               ‐                     ‐                ‐                ‐                Insurance recoveries ‐                ‐               ‐               ‐                     3,799           ‐                ‐                TOTAL REVENUES 414,790       473,479     419,422     90,049             262,982     842,551       224,134      EXPENSES: Communications 45,968              Equipment rental 101,259        Facilities 232,895      Healthcare 722,456        Information technology 443,632      Print and mail 16,525              Retiree healthcare 74,306        Risk management: Risk management 340,130      Unemployment ‐                Worker's compensation 243,203      TOTAL EXPENSES 101,259       443,632     232,895     62,493             583,333     722,456       74,306        AMOUNT AVAILABLE FOR CAPITAL 313,531       29,847       186,527     27,556             (320,351)    120,095       149,828      CAPITAL PROJECTS ‐                8,074          ‐               ‐                     ‐                ‐                ‐                TRANSFERS IN ‐                ‐               ‐               ‐                     ‐                ‐                ‐                TRANSFERS (OUT)‐                ‐               ‐               ‐                     ‐                ‐                ‐                CHANGE IN FUND BALANCE 313,531       21,773       186,527     27,556             (320,351)    120,095       149,828      BEGINNING FUND BALANCE, Jan 1 6,432,053    2,570,374  1,275,053  542,927           12,852,509 4,156,148    10,079,251 ENDING FUND BALANCE, Jan 31 6,745,584    2,592,147  1,461,580  570,483           12,532,158 4,276,243    10,229,079      Page 12 of 37 Monthly Financial Report January 2017      FUND BALANCE  Page 14 shows the ending fund balance as of January 2017.  The City’s fund balance is a combination of current deficit/surplus  of funds which have accrued from unexpended operating budgets, unanticipated excess revenues, and from balances  accumulated from prior years.      The prior year’s balances (or beginning balance) include funds identified as being reserved for specific purposes or required  to meet the current year’s appropriations. These balances also provide financial stability to the City’s operation during  uncertain times and provide a layer of security to bondholders.      At the end of January, the City has $27.3 million reported in the combined general governmental fund balance of the current  year’s operating budget, which is approximately 28% of budgeted operating expenditures.  This is an increase of $769k from  the year’s beginning balance.  January’s ending fund balance is over the anticipated General Governmental Fund Balance of  $17.4 million by $10 million or 56.9%.  Although the ending fund balance is above projections, it is consistent with the prior  years’ trends.      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 hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.  Page 13 of 37 Monthly Financial Report January 2017      City of Renton All Funds ‐ Revenue, Expenditures and Fund Balances Cash Basis through January 31, 2017 Funds Balance  01/01/2017 Budgeted  Revenue Revenue  01/31/17 Total Funds  Available Budgeted  Expenditure Expenditure  01/31/17 Ending Balance GENERAL GOVERNMENT FUNDS: 26,563,785       101,574,129  7,364,146       33,927,931     99,208,714     6,595,136         27,332,795      000 General 18,201,028       71,822,349     5,921,490       24,122,518     67,906,170     4,977,579         19,144,939      001 Community Services 3,769,766         12,336,177     891,120          4,660,886       13,422,904     811,553            3,849,333        003 Street 1,936,367         10,722,085     502,000          2,438,367       11,085,024     735,716            1,702,651        004 Community Dev Block Grant 66,654              424,857          413                  67,067            424,857          5,246                 61,820             005 Museum 72,372              233,936          39                    72,411            236,275          19,400              53,011             009 Farmers Market 90,730              59,400            10,196            100,926          66,855            4,263                 96,663             011 Fire Health & Wellness ‐                         ‐                       ‐                       ‐                       ‐                        ‐                        ‐                        201 Ltd GO Bonds Gen Govt Debt 852,111            1,749,675       456                  852,567          1,749,675       ‐                        852,567           215 Gen Govt Misc Debt Service 1,574,757         4,225,650       38,432            1,613,189       4,316,954       41,377              1,571,812        SPECIAL REVENUE FUNDS:1,599,965         1,974,729       195,018          1,794,983       1,902,670       42,360              1,752,623        102 Arterial Street 63,480              660,000          52,633            116,113          660,000          ‐                        116,113           108 Leased City Properties 276,865            902,550          100,118          376,983          839,996          42,360              334,623           110 Hotel Motel 402,602            265,000          19,587            422,189          265,000          ‐                        422,189           125 1% For Art 128,489            24,505            69                    128,558          15,000            ‐                        128,558           127 Cable Communication 394,504            122,674          22,432            416,936          122,674          ‐                        416,936           135 Springbrook Wetlands Bank 334,025            ‐                       179                  334,204          ‐                        ‐                        334,204           CAPITAL PROJECT FUNDS (CIP):26,202,403       22,464,152     1,802,947       28,005,350     19,574,182     36,898              27,968,452      303 Community Dev Mitigation 1,255,194         86,500            21,257            1,276,451       ‐                        ‐                        1,276,451        304 Fire Mitigation 607,163            99,000            5,228               612,391          158,696          ‐                        612,391           305 Transportation Mitigation 1,497,748         620,000          49,785            1,547,533       1,005,000       ‐                        1,547,533        316 Municipal Facilities CIP 15,038,030       10,352,000     1,036,885       16,074,915     6,399,775       (1,329)               16,076,244      317 Transportation CIP 5,640,494         11,306,652     688,609          6,329,103       12,010,711     38,227              6,290,876        326 Housing Opportunity 1,041,173         ‐                       559                  1,041,732       ‐                        ‐                        1,041,732        336 New Library Development 1,122,601         ‐                       624                  1,123,225       ‐                        ‐                        1,123,225        ENTERPRISE FUNDS:63,685,077       81,744,234     7,215,345       70,900,422     89,940,554     3,934,398         66,966,024      4X2 Airport Operating & CIP 2,619,343         3,122,486       255,452          2,874,795       3,894,902       164,122            2,710,673        403 Solid Waste Utility 2,751,417         19,187,851     1,507,690       4,259,107       19,010,175     606,029            3,653,078        4X4 Golf Operating & CIP 37,088              2,833,044       60,345            97,433            2,539,041       141,202            (43,769)            4X5 Water Operating & CIP 28,528,934       17,180,526     1,223,107       29,752,041     22,500,120     656,205            29,095,836      4X6 Waste Water Operating & CIP 13,859,662       10,024,949     1,484,109       15,343,771     12,137,333     441,249            14,902,522      416 King County Metro 4,994,658         17,505,693     1,311,555       6,306,213       17,505,693     1,400,157         4,906,056        4X7 Surface Water Operating & CIP 10,893,975       11,889,685     1,373,087       12,267,062     12,353,290     525,434            11,741,628      INTERNAL SERVICE FUNDS:37,908,315       30,287,916     2,727,407       40,635,722     31,512,994     2,228,447         38,407,275      501 Equipment Repair/Replacement 6,432,053         6,388,513       414,790          6,846,843       7,126,253       101,259            6,745,584        502 Insurance 12,852,509       3,292,368       262,982          13,115,491     3,571,166       583,333            12,532,158      503 Information Services 2,570,374         5,603,168       473,479          3,043,853       5,560,636       451,705            2,592,148        504 Facilities 1,275,053         4,882,506       419,422          1,694,475       4,981,195       232,895            1,461,580        505 Communications 542,927            1,078,253       90,049            632,976          1,076,474       62,493              570,483           512 Insurance, Healthcare 4,156,148         7,787,779       842,551          4,998,699       8,157,676       722,456            4,276,243        522 Insurance, Leoff1 Retirees HC 10,079,251       1,255,329       224,134          10,303,385     1,039,594       74,306              10,229,079      FIDUCIARY FUNDS:5,578,045         468,000          1,700               5,579,745       210,475          20,669              5,559,076        611 Firemen's Pension 5,578,045         468,000          1,700               5,579,745       210,475          20,669              5,559,076        TOTAL FUNDS 161,537,590 238,513,160 19,306,563    180,844,153 242,349,589 12,857,908    167,986,245  Page 14 of 37 City of Renton General Government Financial Position 2017 Budget Year General Government Summary  Revenues Expenditures  $ Difference over (under)  w/beginning  balance  26,563,785             January 7,364,146              6,595,136              769,010                  27,332,795             February March April May June July August September October November December  (8,000,000)  (7,000,000)  (6,000,000)  (5,000,000)  (4,000,000)  (3,000,000)  (2,000,000)  (1,000,000)  ‐  1,000,000  2,000,000  3,000,000  4,000,000  5,000,000  6,000,000  7,000,000  8,000,000  ‐  10,000,000  20,000,000  30,000,000  40,000,000  50,000,000  60,000,000  70,000,000  80,000,000  90,000,000  100,000,000  110,000,000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Change in Fund  Balance Rev/Exp Revenues Expenditures Change in Fund Balance Page 15 of 37 City of Renton Monthly Revenue Analysis ‐ 2017 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 7,147,391        7,364,146        3.03% Feb 13,502,059       Mar 19,935,029       Apr 32,759,081       May 44,403,500       Jun 50,637,508       Jul 58,132,061       Aug 64,573,204       Sep 70,888,717       Oct 82,302,982       Nov 94,897,374       Dec 101,574,129     Percent of budget 7.25% Property Tax Budget YTD Actual Annual %  over (under) Jan 36,768              55,429              50.75% Feb 241,042            Mar 967,646            Apr 6,883,291         May 12,626,243       Jun 12,719,859       Jul 12,760,104       Aug 12,870,217       Sep 13,238,047       Oct 17,341,593       Nov 23,988,632       Dec 24,103,395       Percent of budget 0.23%  $‐  $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  $110  $120  $130 Millions Total Revenue General Government Budget Actual Last Year  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  $33  $36  $39 Millions Property Tax Budget Actual Last Year Page 16 of 37 City of Renton Monthly Revenue Analysis ‐ 2017 Budget Year Sales Tax Budget YTD Actual Annual %  over (under) Jan 2,261,189        2,340,558        3.51% Feb 4,964,886         Mar 7,067,913         Apr 9,174,172         May 11,640,150       Jun 13,842,125       Jul 16,104,724       Aug 18,663,293       Sep 21,097,526       Oct 23,629,240       Nov 26,285,407       Dec 28,763,680       Percent of budget 8.14% Note:  Excludes CJ Sales Tax and Natural Gas Use Tax. Utility Tax Budget YTD Actual Annual %  over (under) Jan 1,277,138        1,698,721        33.01% Feb 2,735,212         Mar 4,197,814         Apr 5,487,047         May 6,771,549         Jun 7,949,356         Jul 9,183,733         Aug 10,453,523       Sep 11,680,525       Oct 12,932,675       Nov 14,139,633       Dec 15,478,137       Percent of budget 10.97% Note:  Includes Natural Gas Use Tax.  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27  $30 Millions Sales Tax Budget Actual Last Year  $‐  $2  $4  $6  $8  $10  $12  $14  $16 Millions Utility Tax Budget Actual Last Year Page 17 of 37 City of Renton Monthly Revenue Analysis ‐ 2017 Budget Year Licenses &  Permits Budget YTD Actual Annual %  over (under) Jan 586,132           321,764            ‐45.10% Feb 956,756            Mar 1,322,363         Apr 1,688,572         May 1,961,934         Jun 2,264,302         Jul 2,972,183         Aug 3,368,015         Sep 3,791,878         Oct 4,274,238         Nov 4,532,625         Dec 4,815,012         Percent of budget 6.68% Note:  GF only Intergovt'l Budget YTD Actual Annual %  over (under) Jan 567,324           604,678           6.58% Feb 1,018,187         Mar 1,551,290         Apr 2,064,933         May 2,745,943         Jun 3,343,929         Jul 3,833,927         Aug 4,298,546         Sep 4,899,687         Oct 5,449,039         Nov 5,994,932         Dec 6,730,078         Percent of budget 8.98% Note:  Includes CJ Sales Tax and FD25 & FD40 contracts  $‐  $2  $4  $6  $8  $10  $12 Millions Intergovernmental Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00 Millions Licenses & Permits Budget Actual Last Year Page 18 of 37 City of Renton Monthly Revenue Analysis ‐ 2017 Budget Year Charges for  Services Budget YTD Actual Annual %  over (under) Jan 641,725           749,576           16.81% Feb 1,192,622         Mar 1,779,728         Apr 2,574,617         May 3,142,189         Jun 4,270,357         Jul 5,207,148         Aug 6,077,059         Sep 6,705,746         Oct 7,327,762         Nov 7,947,988         Dec 8,677,538         Percent of budget 8.64% Note: Excludes FD25 & FD40 contracts Fines &  Forfeits Budget YTD Actual Annual %  over (under) Jan 126,199           134,957           6.94% Feb 339,355            Mar 603,740            Apr 845,911            May 1,077,838         Jun 1,339,137         Jul 1,558,308         Aug 1,810,632         Sep 2,043,253         Oct 2,287,023         Nov 2,557,964         Dec 2,868,450         Percent of budget 4.70%  $‐  $1  $2  $3  $4  $5  $6  $7  $8  $9 Millions Charges for Services Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00 Millions Fines & Forfeits Budget Actual Last Year Page 19 of 37 City of Renton Monthly Revenue Analysis ‐ 2017 Budget Year Other Taxes Budget YTD Actual Annual %  over (under) Jan 1,428,684        1,094,465         ‐23.39% Feb 1,708,305         Mar 1,968,404         Apr 3,446,027         May 3,713,922         Jun 4,018,000         Jul 5,456,111         Aug 5,805,828         Sep 6,075,201         Oct 7,571,990         Nov 7,846,056         Dec 8,155,026         Percent of budget 13.42% Misc Budget YTD Actual Annual %  over (under) Jan 209,007           363,997           74.16% Feb 319,246            Mar 436,454            Apr 541,612            May 657,607            Jun 811,095            Jul 963,250            Aug 1,120,295         Sep 1,237,832         Oct 1,357,175         Nov 1,458,666         Dec 1,824,117         Percent of budget 19.95%  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50 Millions Miscellaneous Budget Actual Last Year  $‐  $1  $2  $3  $4  $5  $6  $7  $8  $9  $10  $11  $12  $13 Millions Other Taxes Budget Actual Last Year Page 20 of 37 City of Renton Monthly Revenue Analysis ‐ 2017 Budget Year Other  Financing Budget YTD Actual Annual %  over (under) Jan 13,225               ‐                         0.00% Feb 26,449               Mar 39,674               Apr 52,899               May 66,123               Jun 79,348               Jul 92,573               Aug 105,797            Sep 119,022            Oct 132,247            Nov 145,471            Dec 158,696            Percent of budget 0.00% REET Budget YTD Actual Annual %  over (under) Jan 708,703           1,028,456        45.12% Feb 857,491            Mar 1,062,002         Apr 1,360,630         May 1,722,197         Jun 2,068,717         Jul 2,566,642         Aug 3,050,997         Sep 3,452,940         Oct 3,887,811         Nov 4,154,162         Dec 4,420,000         Percent of budget 23.27%  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00  $5.50  $6.00  $6.50 Millions Real Estate Excise Tax Budget Actual Last Year $0 $1 $1 $2 $2 $3 Mi l l i o n s Other Financing Sources Budget Actual Last Year Page 21 of 37 City of Renton Monthly Revenue Analysis ‐ 2017 Budget Year Bldg Permits &  Devlpmt Svc  Fees Budget YTD Actual Annual %  over (under) Jan 481,500           399,548            ‐17.02% Feb 861,115            Mar 1,301,962         Apr 1,786,635         May 2,096,984         Jun 2,795,383         Jul 3,487,109         Aug 3,925,839         Sep 4,424,411         Oct 4,902,760         Nov 5,262,700         Dec 5,735,368         Percent of budget 6.97% B & O Tax Budget YTD Actual Annual %  over (under) Jan 1,360,000        432,319            ‐68.21% Feb 1,530,000         Mar 1,700,000         Apr 3,060,000         May 3,230,000         Jun 3,400,000         Jul 4,760,000         Aug 4,930,000         Sep 5,100,000         Oct 6,460,000         Nov 6,630,000         Dec 6,800,000         Percent of budget 6.36%  $‐  $1.00  $2.00  $3.00  $4.00  $5.00  $6.00 Millions Building Permits and Development Service  Fees Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00  $5.50  $6.00  $6.50  $7.00 Millions Business & Occupation Tax Budget Actual Last Year Page 22 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 6,739,148        6,595,136         ‐2.14% Feb 15,252,027       Mar 23,599,839       Apr 31,313,874       May 39,464,243       Jun 47,517,491       Jul 56,224,122       Aug 64,719,968       Sep 73,192,169       Oct 81,675,601       Nov 89,579,830       Dec 99,208,714       Percent of budget expended 6.65% Legislative Budget YTD Actual Annual %  over (under) Jan 36,183              36,043               ‐0.39% Feb 66,236               Mar 101,649            Apr 131,509            May 161,207            Jun 190,925            Jul 219,892            Aug 249,074            Sep 278,319            Oct 308,035            Nov 337,502            Dec 368,211            Percent of budget expended 9.79%  $‐  $20  $40  $60  $80  $100 Millions Total Expenditures General Government Budget Actual Last Year  $‐  $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  $350,000  $400,000 Legislative Budget Actual Last Year Page 23 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year Executive Budget YTD Actual Annual %  over (under) Jan 210,597           211,310           0.34% Feb 352,795            Mar 532,783            Apr 674,696            May 815,622            Jun 974,868            Jul 1,116,480         Aug 1,276,386         Sep 1,459,974         Oct 1,602,086         Nov 1,744,624         Dec 1,946,801         Percent of budget expended 10.85% Emergency  Management Budget YTD Actual Annual %  over (under) Jan 60,959              35,052               ‐42.50% Feb 100,803            Mar 150,586            Apr 190,380            May 230,495            Jun 277,194            Jul 317,478            Aug 385,782            Sep 432,973            Oct 475,285            Nov 516,615            Dec 587,790            Percent of budget expended 5.96%  $‐  $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10 Millions Executive Budget Actual Last Year  $‐  $100,000  $200,000  $300,000  $400,000  $500,000  $600,000 Emergency Management Budget Actual Last Year Page 24 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year City Attorney Budget YTD Actual Annual %  over (under) Jan 176,840           168,105            ‐4.94% Feb 356,198            Mar 539,974            Apr 727,889            May 911,796            Jun 1,096,207         Jul 1,281,325         Aug 1,466,602         Sep 1,658,357         Oct 1,826,387         Nov 1,995,101         Dec 2,163,329         Percent of budget expended 7.77% Court Services Budget YTD Actual Annual %  over (under) Jan 171,264           169,642            ‐0.95% Feb 352,218            Mar 535,423            Apr 716,857            May 901,397            Jun 1,094,693         Jul 1,278,228         Aug 1,465,440         Sep 1,656,123         Oct 1,839,864         Nov 2,023,061         Dec 2,220,656         Percent of budget expended 7.64%  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  $2.00  $2.20 Millions Court Services Budget Actual Last Year  $‐  $0.40  $0.80  $1.20  $1.60  $2.00  $2.40 Millions City Attorney Budget Actual Last Year Page 25 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year CED Admin Budget YTD Actual Annual %  over (under) Jan 104,691           109,731           4.81% Feb 209,968            Mar 315,244            Apr 422,897            May 531,643            Jun 639,918            Jul 803,016            Aug 909,108            Sep 1,015,431         Oct 1,121,287         Nov 1,226,753         Dec 1,337,991         Percent of budget expended 8.20% Development  Services Budget YTD Actual Annual %  over (under) Jan 253,473           239,337            ‐5.58% Feb 537,134            Mar 814,946            Apr 1,078,514         May 1,355,387         Jun 1,636,621         Jul 1,913,013         Aug 2,202,288         Sep 2,500,917         Oct 2,782,058         Nov 3,060,738         Dec 3,365,105         Percent of budget expended 7.11%  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40 Millions Community & Economic Development Admin Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50 Millions Development Services Budget Actual Last Year Page 26 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year Economic  Development Budget YTD Actual Annual %  over (under) Jan 62,001              46,869               ‐24.41% Feb 153,293            Mar 224,582            Apr 342,747            May 424,864            Jun 523,338            Jul 623,000            Aug 700,815            Sep 773,456            Oct 907,053            Nov 1,008,707         Dec 1,104,342         Percent of budget expended 4.24% Planning Budget YTD Actual Annual %  over (under) Jan 242,179           221,112            ‐8.70% Feb 488,126            Mar 751,373            Apr 1,009,976         May 1,309,628         Jun 1,598,387         Jul 1,862,808         Aug 2,130,592         Sep 2,418,320         Oct 2,693,743         Nov 2,945,967         Dec 3,207,796         Percent of budget expended 6.89%  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20 Millions Economic Development Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50 Millions Planning Budget Actual Last Year Page 27 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year Finance Budget YTD Actual Annual %  over (under) Jan 210,228           197,230            ‐6.18% Feb 420,660            Mar 628,837            Apr 841,612            May 1,068,567         Jun 1,384,542         Jul 1,596,444         Aug 1,959,270         Sep 2,188,971         Oct 2,417,989         Nov 2,632,734         Dec 3,312,369         Percent of budget expended 5.95% City Clerk Budget YTD Actual Annual %  over (under) Jan 70,972              62,018               ‐12.62% Feb 171,187            Mar 252,319            Apr 334,103            May 416,724            Jun 499,628            Jul 585,297            Aug 739,158            Sep 753,269            Oct 858,323            Nov 945,725            Dec 1,121,537         Percent of budget expended 5.53% Includes Hearing Examiner  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20 Millions City Clerk Budget Actual Last Year  $‐  $0.40  $0.80  $1.20  $1.60  $2.00  $2.40  $2.80  $3.20  $3.60 Millions Finance Budget Actual Last Year Page 28 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year Human  Resources Budget YTD Actual Annual %  over (under) Jan 86,650              87,874              1.41% Feb 190,026            Mar 308,824            Apr 423,771            May 530,627            Jun 636,463            Jul 742,522            Aug 856,960            Sep 962,275            Oct 1,081,723         Nov 1,186,626         Dec 1,321,317         Percent of budget expended 6.65% Police Budget YTD Actual Annual %  over (under) Jan 2,938,648        2,964,875        0.89% Feb 5,580,948         Mar 8,715,041         Apr 11,385,347       May 14,397,411       Jun 17,169,439       Jul 20,269,792       Aug 22,985,168       Sep 26,075,758       Oct 28,848,141       Nov 31,783,447       Dec 35,141,917       Percent of budget expended 8.44%  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40 Millions Human Resources Budget Actual Last Year  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  $33  $36 Millions Police Budget Actual Last Year Page 29 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year Community  Services Admin Budget YTD Actual Annual %  over (under) Jan 43,313              44,101              1.82% Feb 91,333               Mar 132,122            Apr 170,865            May 208,694            Jun 243,941            Jul 283,798            Aug 323,291            Sep 362,917            Oct 402,012            Nov 441,115            Dec 505,154            Percent of budget expended 8.73% Parks Budget YTD Actual Annual %  over (under) Jan 341,642           309,997            ‐9.26% Feb 709,382            Mar 1,096,504         Apr 1,489,177         May 1,883,623         Jun 2,321,322         Jul 2,830,040         Aug 3,314,760         Sep 3,815,806         Oct 4,259,572         Nov 4,651,730         Dec 5,091,258         Percent of budget expended 6.09%  $‐  $1.00  $2.00  $3.00  $4.00  $5.00  $6.00 Millions Parks Budget Actual Last Year $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 Community Services Admin Budget Actual Last Year Page 30 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year Parks Planning  and Natural  Resources Budget YTD Actual Annual %  over (under) Jan 61,892              53,458               ‐13.63% Feb 131,533            Mar 211,483            Apr 280,509            May 390,324            Jun 489,944            Jul 587,703            Aug 699,411            Sep 815,101            Oct 930,556            Nov 1,035,110         Dec 1,177,483         Percent of budget expended 4.54% Recreation Budget YTD Actual Annual %  over (under) Jan 372,341           347,558            ‐6.66% Feb 770,723            Mar 1,184,820         Apr 1,608,181         May 2,027,273         Jun 2,486,920         Jul 3,154,292         Aug 3,843,311         Sep 4,403,077         Oct 4,817,996         Nov 5,232,836         Dec 5,674,455         Percent of budget expended 6.12%  $‐  $200,000  $400,000  $600,000  $800,000  $1,000,000  $1,200,000 Parks Planning and Natural Resources Budget Actual Last Year $0.00 $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 $4.00 $4.50 $5.00 $5.50 $6.00 Millions Recreation Budget Actual Last Year Page 31 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year Human  Services Budget YTD Actual Annual %  over (under) Jan 66,308              98,615              48.72% Feb 160,698            Mar 270,295            Apr 418,232            May 491,413            Jun 558,612            Jul 674,029            Aug 774,423            Sep 845,232            Oct 1,010,378         Nov 1,090,523         Dec 1,279,916         Percent of budget expended 7.70% Neighborhoods , Resources,  and Events Budget YTD Actual Annual %  over (under) Jan 70,488              60,703              ‐13.88% Feb 157,901            Mar 234,660            Apr 300,176            May 376,460            Jun 453,629            Jul 572,561            Aug 668,419            Sep 756,275            Oct 837,240            Nov 910,541            Dec 1,041,408         Percent of budget expended 5.83%  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40 Millions Human Services Budget Actual Last Year  $‐  $200,000  $400,000  $600,000  $800,000  $1,000,000  $1,200,000 Neighborhoods, Resources, and Events Budget Actual Last Year Page 32 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year Museum Fund Budget YTD Actual Annual %  over (under) Jan 19,490              19,400               ‐0.46% Feb 38,851               Mar 57,801               Apr 77,036               May 96,758               Jun 116,580            Jul 136,413            Aug 156,373            Sep 176,366            Oct 196,623            Nov 216,498            Dec 236,275            Percent of budget expended 8.21% Public Works  Admin Budget YTD Actual Annual %  over (under) Jan 33,358              33,498              0.42% Feb 68,245               Mar 102,054            Apr 135,775            May 169,617            Jun 203,557            Jul 237,559            Aug 272,046            Sep 306,358            Oct 339,748            Nov 373,069            Dec 406,398            Percent of budget expended 8.24%  $‐  $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  $350,000  $400,000  $450,000 Public Works Admin Budget Actual Last Year  $‐  $30,000  $60,000  $90,000  $120,000  $150,000  $180,000  $210,000  $240,000 Museum Fund Budget Actual Last Year Page 33 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year Street  Maintenance Budget YTD Actual Annual %  over (under) Jan 422,310           408,757            ‐3.21% Feb 851,905            Mar 1,313,322         Apr 1,762,969         May 2,205,454         Jun 2,651,411         Jul 3,128,820         Aug 3,595,499         Sep 4,048,699         Oct 4,498,708         Nov 4,929,955         Dec 5,415,126         Percent of budget expended 7.55% Transportation Budget YTD Actual Annual %  over (under) Jan 340,428           326,959            ‐3.96% Feb 706,499            Mar 1,247,152         Apr 1,619,928         May 2,095,850         Jun 2,513,261         Jul 2,960,840         Aug 3,404,337         Sep 3,854,060         Oct 4,693,977         Nov 5,071,355         Dec 5,669,897         Percent of budget expended 5.77%  $‐  $1.00  $2.00  $3.00  $4.00  $5.00  $6.00 Millions Street Maintenance Budget Actual Last Year $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 Millions Transportation Budget Actual Last Year Page 34 of 37 City of Renton Monthly Expenditure Analysis ‐ 2017 Budget Year Debt Service Budget YTD Actual Annual %  over (under) Jan 41,377              41,377              0.00% Feb 1,011,105         Mar 1,516,657         Apr 2,022,210         May 2,527,762         Jun 3,033,315         Jul 3,538,867         Aug 4,044,419         Sep 4,549,972         Oct 5,055,524         Nov 5,561,077         Dec 6,066,629         Percent of budget expended 0.68% Non‐ Departmental  Other City Budget YTD Actual Annual %  over (under) Jan 301,517           301,517           0.00% Feb 1,574,259         Mar 2,361,388         Apr 3,148,517         May 3,935,646         Jun 4,722,776         Jul 5,509,905         Aug 6,297,034         Sep 7,084,163         Oct 7,871,293         Nov 8,658,422         Dec 9,445,551         Percent of budget expended 3.19%  $‐  $1.00  $2.00  $3.00  $4.00  $5.00  $6.00  $7.00  $8.00  $9.00  $10.00 Millions Non‐Departmental Other City Services Budget Actual Last Year  $‐  $1  $2  $3  $4  $5  $6  $7 Millions Debt Service Budget Actual Last Year Page 35 of 37 City of Renton Monthly Enterprise Fund Financial Report ‐ 2017 Budget Year Utilities Budget Revenue Expense Jan 3,137,933        6,899,538      3,629,075       Feb 7,966,180         Mar 12,785,927       Apr 17,564,889       May 22,485,221       Jun 29,629,728       Jul 34,562,524       Aug 43,874,165       Sep 52,542,001       Oct 67,568,059       Nov 72,950,725       Dec 83,506,611       Percent of budget expended 2.92% Note:  Operations and Capital Airport Budget Revenue Expense Jan 197,822           255,451          164,122           Feb 477,943            Mar 794,755            Apr 1,099,920         May 1,348,103         Jun 1,639,286         Jul 1,932,689         Aug 2,211,019         Sep 2,589,486         Oct 2,995,569         Nov 3,226,692         Dec 3,894,902         Percent of budget expended 4.21% Note:  Operations and Capital $0 $10 $20 $30 $40 $50 $60 $70 $80 $90 Millions Utilities Budget Revenue Expense  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50 Millions Airport Budget Revenue Expense Page 36 of 37 City of Renton Monthly Enterprise Fund Financial Report ‐ 2017 Budget Year Golf Course Budget Revenue Expense Jan 132,696           60,345            141,202           Feb 283,495            Mar 472,641            Apr 635,498            May 809,399            Jun 999,439            Jul 1,218,743         Aug 1,418,310         Sep 1,598,003         Oct 1,787,537         Nov 1,955,753         Dec 2,539,041         Percent of budget expended 5.56% Note:  Operations and Capital  $‐  $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10  $2.40  $2.70 Millions Golf Course Budget Revenue Expense Page 37 of 37