Loading...
HomeMy WebLinkAbout201507, July.pdf ADMINISTRATIVE SERVICES  DEPARTMENT    M   E   M   O   R   A   N   D   U   M       DATE: September 9, 2015    TO: Ed Prince, Council President  Members of the Renton City Council     CC: Denis Law, Mayor  Administrators     FROM: Hai Nguyen, Sr. Finance Analyst     SUBJECT: July 2015 Financial Status Report       At the end of July, general governmental revenues show $4.2 million or 6.8% over budget.   Revenue sources that are higher than expected are: property tax ($756k); sales tax ($284k);  sales tax annexation credit ($125k); state shared revenues ($315k); utility taxes ($1 million);  franchise fees ($101k); gambling taxes ($386k); building permits & development service fees  ($913k); public safety ($153k); interest/other earnings ($313kk); and other miscellaneous  ($156k).  On the down side, the revenue sources that are underperforming the year to date  budget is fines/penalties ($328k below).    General government expenditures showed a favorable variance of $1.7 million or 2.6%.  See  page 9 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 15,575,840$     15,575,840$  17,454,262$       17,454,262$  17,565,282$    17,565,282$ 17,565,282$    ‐                      0.0% OPERATING REVENUES Property Tax 32,485,690        16,954,079     35,295,390          18,309,728     36,040,000       18,513,875    19,270,155      756,281          4.1% Sales  Tax 20,416,372        11,562,516     21,512,379          11,968,696     22,239,731       12,681,751    12,965,630      283,878          2.2% Sales  Tax ‐ Annexation Credit 2,418,789           1,369,168        2,542,394             1,411,086        2,519,968          1,412,194       1,537,488         125,294          8.9% Criminal Justice Sales  Tax 2,091,174           1,171,527        2,267,947             1,266,133        2,305,519          1,289,267       1,375,384         86,116             6.7% Natural Gas Use Tax 263,660                169,403            271,485                  205,804             300,000               227,420            164,540             (62,880)            ‐27.6% Admission Tax 327,258                240,224            310,311                  233,681             320,000               237,856            234,588             (3,268)               ‐1.4% Franchise  Fees 1,312,727           943,042            1,342,269             970,939             1,260,000          908,331            1,009,218         100,887          11.1% Electricity Tax 5,155,789           3,049,554        5,167,444             3,141,952        5,365,536          3,218,057       2,825,401         (392,656)         ‐12.2% Natural Gas Utility Tax 1,550,900           1,085,808        1,562,341             1,139,753        1,550,900          1,108,691       1,001,485         (107,206)          ‐9.7% Garbage/Solid Waste 397,596                221,951            573,457                  330,069             400,000               227,390            346,373             118,983          52.3% TV Cable 1,481,779           838,645            1,518,821             867,188             1,579,365          897,865            905,533             7,668                0.9% Telephone 917,021                528,707            909,088                  514,864             952,500               544,327            526,776             (17,552)            ‐3.2% Cellular Phone 2,050,312           1,105,046        1,951,925             1,069,543        1,967,056          1,068,786       964,725             (104,061)         ‐9.7% City Utilities 3,964,989           2,267,850        3,961,052             2,301,923        4,058,377          2,339,864       2,451,380         111,515          4.8% Utility Tax Audit ‐                            ‐                        460,513                  460,513             ‐                           ‐                        1,446,078         1,446,078      100.0% Leasehold Excise  Tax 164,637                82,442               171,470                  89,256                179,000               91,441               84,782                (6,659)               ‐7.3% Gambling Excise  Tax 1,319,585           725,074            1,650,384             919,169             1,600,000          885,796            1,271,410         385,614          43.5% Real  Estate  Excise  Tax 4,131,665           1,719,709        4,348,762             2,984,646        4,000,000          2,513,969       2,602,732         88,763             3.5% Less: CIP REET (700,000)              (330,727)           (1,650,000)            (566,047)           (1,000,000)         (650,683)          (650,683)            ‐                      0.0% EMS Levy 916,361                458,181            916,361                  450,784             920,000               234,102            234,102             ‐                      0.0% Business License Fees 2,911,691           1,986,415        2,965,850             2,093,034        3,006,000          2,086,427       2,188,980         102,552          4.9% Less: CIP Business License Fees (2,407,925)          (1,643,647)      (2,450,295)            (1,730,529)       (2,500,000)         (1,736,323)      (1,811,112)       (74,790)            4.3% Animal  Licenses and Spec Events  Permits 99,411                   66,615               95,698                     65,576                91,000                  60,693               64,170                3,477                5.7% Building Permits & Development Svc Fees 4,001,625           2,224,985        4,519,234             2,762,637        4,679,749          2,740,646       3,653,786         913,140          33.3% Intergovt'l (Grants, State Shared, etc) 3,863,974           2,539,941        4,522,540             2,703,122        3,909,542          2,011,310       2,233,580         222,269          11.1% Fire District 25 and 40 Contracts 5,726,895           2,872,722        5,959,428             2,977,343        6,116,326          3,104,566       3,104,566         ‐                      0.0% Public Safety 680,581                404,737            844,375                  444,005             513,081               285,184            437,785             152,601          53.5% Culture and Recreation 1,494,580           952,859            1,485,123             981,907             1,580,616          1,026,317       995,551             (30,766)            ‐3.0% Interfund/Interdept‐Services 3,464,913           2,034,531        3,270,503             1,933,148        3,147,416          1,835,993       1,843,723         7,730                0.4% Fines  and Penalties 1,137,140           603,794            962,977                  593,389             1,126,500          641,421            455,490             (185,931)         ‐29.0% Photo Enforcement 1,629,524           1,174,581        1,719,971             799,863             2,194,000          1,293,309       1,151,572         (141,737)         ‐11.0% Seizure Funds ‐ Federal/State/Local 50,639                   34,567               68,870                     3,346                   180,693               57,323               6,444                   (50,880)            ‐88.8% Interests  and Other Earnings 423,609                61,350               981,630                  79,505                875,300               87,736               401,205             313,469          357.3% Rents, Leases, and Concessions 734,530                527,965            711,070                  514,153             710,216               511,987            516,109             4,122                0.8% Contributions and Donations 84,320                   52,867               113,626                  65,672                97,000                  58,088               79,984                21,896             37.7% Other Miscellaneous 684,187                420,017            879,105                  482,673             705,369               409,721            566,036             156,315          38.2% Other Financing Sources  (Transfer‐In, etc) 299,527                20,415               48,632                     8,617                   255,000               8,107                  8,107                   0                           0.0% Total Operating Revenues 105,545,527     58,496,912     111,782,133       62,847,141     113,245,760    62,232,808    66,463,072      4,230,264      6.8% OPERATING EXPENDITURES Council 289,911                169,210            309,317                  185,030             335,838               198,534            191,473             7,061                3.6% Executive 1,240,910           718,411            1,338,738             742,514             1,714,717          971,091            814,282             156,809          16.1% City Attorney 1,922,225           1,013,090        1,829,254             1,035,254        2,001,421          1,092,795       1,062,566         30,229             2.8% Court Services 2,003,104           1,141,510        2,016,273             1,167,708        2,148,553          1,234,390       1,162,369         72,021             5.8% Community and Eco Dvlpmnt Admin 1,047,860           600,318            1,010,761             587,213             1,177,608          679,312            735,445             (56,133)            ‐8.3% Development Services 3,243,702           1,867,544        2,659,078             1,593,443        2,964,321          1,738,076       1,514,993         223,083          12.8% Economic  Development 467,511                254,764            654,007                  353,794             1,053,786          571,804            375,085             196,719          34.4% Planning 1,510,707           856,640            2,095,706             1,107,408        2,714,466          1,478,295       1,537,578         (59,283)            ‐4.0% Finance 2,274,147           1,123,823        2,644,827             1,336,451        2,795,120          1,398,007       1,427,769         (29,761)            ‐2.1% City Clerk 1,020,822           692,263            1,152,246             650,434             1,091,558          674,452            472,059             202,393          30.0% Human Resources 904,182                510,868            922,668                  516,316             1,316,577          740,272            659,471             80,802             10.9% Police 24,946,784        14,602,739     26,383,640          15,223,692     28,371,356       16,485,667    16,284,443      201,224          1.2% Jail Services 3,814,042           2,224,865        3,760,273             2,194,316        4,200,000          2,417,882       2,417,882         ‐                      0.0% Fire 24,444,372        14,457,407     25,240,760          14,602,905     26,890,757       15,728,121    15,607,269      120,852          0.8% Community Services  Admin 452,146                262,830            480,727                  273,470             560,787               322,391            290,564             31,827             9.9% Parks 4,024,756           2,236,956        4,070,181             2,221,396        4,870,254          2,682,332       2,473,410         208,922          7.8% Parks Planning & Natural  Resources 829,250                370,751            722,739                  388,391             999,004               488,654            418,287             70,367             14.4% Recreation 4,846,970           2,696,025        4,823,195             2,585,291        5,200,923          2,840,460       2,820,946         19,514             0.7% Human Services 1,162,330           628,351            1,159,189             632,253             1,199,977          651,597            685,824             (34,226)            ‐5.3% Neighborhoods, Resources, & Events 770,841                447,998            875,223                  472,085             1,036,841          579,552            520,522             59,029             10.2% Museum 209,387                122,060            214,291                  121,764             227,761               131,075            131,778             (703)                    ‐0.5% Public Works Admin 426,312                269,323            389,493                  225,599             395,867               240,160            225,570             14,590             6.1% Street Maintenance 3,814,132           2,229,390        4,503,315             2,532,280        5,186,713          2,969,351       2,920,408         48,943             1.6% Transportation 4,476,854           2,490,033        4,263,725             2,426,304        5,076,998          2,855,673       2,724,715         130,958          4.6% Debt Service 8,048,508           1,808,239        8,393,140             2,068,927        6,463,588          1,072,897       1,072,897         ‐                      0.0% Non‐Departmental and Other 5,475,340           2,740,276        9,758,346             6,782,586        6,740,778          5,791,355       5,791,355         ‐                      0.0% Total Operating Expenditures 103,667,105     56,535,685     111,671,112       62,026,823     116,735,570    66,034,196    64,338,959      1,695,237      2.6% Total Ending Fund Balance 17,454,262$     17,537,067$  17,565,283$       18,274,581$  14,075,471$    13,763,894$ 19,689,395$   5,925,501$   43.1% Favorable  (Unfavorable) 2013 2014 2015 Variance Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual Monthly Financial Report July 2015 Page 1 of 36 Monthly Financial Report July 2015        OVERVIEW  This financial overview reflects the City’s overall financial position for the fiscal year through July 31, 2015.  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 74% of all  resources supporting general governmental activities.   The following section provides detail information on property, sales,  utility, and other taxes.    Property Tax  July’s collection is $65k, making  the total year‐to‐date collection  $19.3 million or 53.5% of the total  budget.  In comparison to the  previous year, the City collected  $960k or 5% more.  Compared to  the budget, the City is above  projections by $756k or 4%.  The  variances from prior year and  budget are due to a change in  recognition of REET.  In 2014 and  prior, the City recorded the  activity in the month it occurred.   In 2015, the City is recording REET  in the month the City’s receives  the cash deposit.  The City is  projecting property taxes to meet the budget at year‐end.        Sales Tax  July 2015 sales tax receipts  totalled $1.9 million.  Compared  with the same month last year, it  is $135k or 8% more.  Compared  to the projected current month’s  budget, it is $103k or 6% above.   The year‐to‐date collection of $13  million is $997k or 8% more than  the prior year and is also $284k or  2% more than budgeted.  New  Construction, Auto Sales, General  Retail, and Services are the main  sectors that are collecting more  than anticipated.  2015’s monthly  budgets are generally based on  2010 through 2014 collections.   The City is projecting sales taxes to meet the budget at year‐end.  2014 2015 2015 Actual Budget Actual $ % $ % Jan (101,807)$        27,853$            67,234$            169,041$          ‐166% 39,381$            141% Feb 176,551            292,775            307,006            130,455            74% 14,231               5% Mar 1,626,283        1,066,055        939,218            (687,065)            ‐42% (126,838)            ‐12% Apr 5,808,865        8,037,494        10,160,118     4,351,253        75% 2,122,623        26% May 10,692,069     8,544,299        7,583,868        (3,108,202)       ‐29% (960,431)            ‐11% Jun (244,519)           17,789               147,318            391,837             ‐160% 129,528            728% Jul 352,287            527,609            65,395               (286,892)            ‐81% (462,214)            ‐88% Aug 178,936            427,951             Sep 574,579            515,969             Oct 11,777,175     9,346,477         Nov 4,051,387        6,227,843         Dec 403,584            1,007,885         YTD  Total 18,309,728$  18,513,875$  19,270,155$  960,427$         5% 756,281$         4% Annual Total 35,295,390$  36,040,000$   Property Tax  Revenues Year to Date through July 2015 vs. 2014 2015 vs. Budget Month 2014 2015 2015 Actual Budget Actual $ % $ % Jan 1,607,045$     1,736,775$     1,758,332$     151,287$         9% 21,557$            1% Feb 2,079,673        2,139,897        2,260,395        180,722            9% 120,498            6% Mar 1,562,210        1,658,321        1,674,147        111,937            7% 15,826               1% Apr 1,558,271        1,679,689        1,750,506        192,235            12% 70,817               4% May 1,759,697        1,950,137        1,977,843        218,146            12% 27,706               1% Jun 1,669,870        1,753,064        1,677,458        7,588                  0% (75,606)               ‐4% Jul 1,731,929        1,763,868        1,866,949        135,020            8% 103,080            6% Aug 2,030,161        1,940,381         ‐                         Sep 1,849,720        1,834,221        ‐                         Oct 1,869,025        1,923,863        ‐                         Nov 1,952,887        1,959,088        ‐                         Dec 1,841,892        1,900,427        ‐                         YTD  Total 11,968,696$  12,681,751$  12,965,630$  996,934$         8% 283,878$         2% Annual  Total 21,512,379$  22,239,731$   2015 vs. Budget2015 vs. 2014 Month Year  to Date through July Local Retail Sales  Tax  Revenues Page 2 of 36 Monthly Financial Report July 2015      The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business  sectors:                      Utility tax   July utility tax revenues are $2.2  million, which is $649k or 42%  higher than the same month last  year and is also ahead of the  budget by $989k or 83%.  The  year‐to‐date collection is $10.6  million, which is $601k or 6%  higher than the prior year and is  also $1 million or 10% higher than  the budget.  100% of this  favourable variance is due to one‐ time audit adjustments.  Excluding  audit related collections, the City  is projecting utility tax revenues  to be under the budget at year‐ end.      The table below breaks out Utility Tax by source.  The variance for Electrical and Natural Gas utilities is due to lower activity.   The favourable utility tax audit revenues are gross and do not include the related audit fees (projected to be $372k for  2015).          2014 2015 2015 Actual Budget Actual $ % $ % Jan 1,373,119$     1,371,800$     1,199,348$     (173,771)$         ‐13% (172,452)$         ‐13% Feb 1,524,563        1,510,913        1,371,771        (152,792)            ‐10% (139,143)            ‐9% Mar 1,631,438        1,441,880        1,544,060        (87,378)               ‐5% 102,180            7% Apr 1,218,999        1,419,168        1,263,898        44,900               4% (155,270)            ‐11% May 1,380,317        1,391,839        1,262,764        (117,553)            ‐9% (129,076)            ‐9% Jun 1,376,544        1,310,144        1,815,284        438,740            32% 505,140            39% Jul 1,526,628        1,186,657        2,175,167        648,538            42% 988,510            83% Aug 1,270,116        1,293,475         Sep 1,206,313        1,338,119         Oct 1,202,725        1,163,623         Nov 1,170,266        1,233,232         Dec 1,495,099        1,512,883         YTD  Total 10,031,609$  9,632,402$     10,632,292$  600,683$         6% 999,890$         10% Annual  Total 16,376,127$  16,173,734$   2015 vs. Budget2015 vs. 2014 Year  to Date through July Utility Tax  Revenues Month Sales  Tax  by Sector 2014 2015 Bgt YTD Act Change  2015/2014 2015 Act  vs  Bgt New Construction 1,167,354$     1,375,241$     1,497,447$     330,094$       28%$        122,207 9% Auto  Sales 2,307,070        2,417,183        2,556,135        249,065          11%           138,952 6% General Retail 3,792,234        3,905,297        4,059,742        267,509          7%           154,445 4% Manufacturing 1,167,145        1,209,642        1,033,442        (133,703)         ‐11%         (176,200)‐15% Wholesale 630,450            661,918            667,696            37,246             6%                 5,778 1% Service 2,560,726        2,691,346        2,823,323        262,597          10%           131,977 5% Other 343,718            421,125            327,844            (15,874)            ‐5%            (93,281)‐22% YTD Total 11,968,696$  12,681,751$  12,965,630$  996,934$       8%283,878$        2% Note: Excludes Annexation Credit and Criminal Justice Sales  Tax  revenue. Utility Tax  by Type 2014 2015 Bgt YTD Act Change  2015/2014  2015 Act  vs  Bgt  Electrical 3,141,952$     3,218,057$     2,825,401$     (316,551)$      ‐10%$      (392,656)‐12% Natural  Gas 1,345,558        1,336,112        1,166,025        (179,532)         ‐13%         (170,086)‐13% Cell 1,069,543        1,068,786        964,725            (104,817)         ‐10%         (104,061)‐10% Phone 514,864            544,327            526,776            11,912             2%            (17,552)‐3% Cable 867,188            897,865            905,533            38,345             4%                 7,668 1% Garbage/Solid Waste 330,069            227,390            346,373            16,305             5%           118,983 52% City Utilities 2,301,923        2,339,864        2,451,380        149,457          6%           111,515 5% Utility Tax Audit 460,513            ‐                              1,446,078        985,565          214%       1,446,078 100% YTD  Total 10,031,609$  9,632,402$     10,632,292$  600,683$       6%999,890$        10% Annual Total 16,376,127$  16,173,734$   YTD  as % of 61% 60% Page 3 of 36 Monthly Financial Report July 2015      Other Taxes     Real Estate Excise Tax  The City collected $563k in Real  Estate Excise Tax revenues (REET)  for July.  This is $213k or 61%  more than the same month last  year and is $179k or 47% more  than the current month’s budget.   The year‐to‐date collection is $2.6  million, which is $382k or 13% less  than the prior year but is $89k or  4% above the budget.  The higher  than expected variance is due to  14 large transactions in February,  March, April, May and June which  accounts for $539k of the total  REET collected.  The City is  projecting REET to be very close to  the budget at year‐end.        Gambling Tax  July’s Gambling Tax collections  totalled $195k, which is $72k or  59% above the same month last  year and is also above the current  month’s budget by $81k or 71%.   The year‐to‐date total of $1.3  million is $352k or 38% above the  prior year and is also $386k or  44% above budget.  $77k of the  year‐to‐date collections are from  a payment plan of back taxes  earned in 2013/2014.  The City is  projecting gambling taxes to  exceed the budget at year‐end.    Pull tabs overall had an 11%  increase, bingo had a 21% decrease, and card‐rooms are seeing 59% higher in activities when compared to the prior year.        Franchise Fees  Franchise Fees are due quarterly  in January, April, July, and  October.  The year‐to‐date total  of $1 million is $38k or 4% higher  than the prior year and is also  $101k or 11% above the projected  year‐to‐date budget.  The City is  projecting franchise fees to  exceed the budget at year‐end.     2014 2015 2015 Actual Budget Actual $ % $ % Jan 162,143$         173,895$         226,377$         64,234$            40% 52,482$            30% Feb 448,452            321,137            158,616            (289,836)           ‐65% (162,521)           ‐51% Mar 227,629            266,310            343,579            115,950            51% 77,269               29% Apr 909,120            548,260            438,485            (470,635)           ‐52% (109,775)           ‐20% May 262,746            315,718            394,014            131,268            50% 78,296               25% Jun 624,342            504,632            478,186            (146,155)           ‐23% (26,445)              ‐5% Jul 350,214            384,017            563,474            213,260            61% 179,457            47% Aug 346,677            307,198             Sep 265,534            252,083             Oct 436,050            330,354             Nov 223,675            286,400             Dec 92,179               309,996             YTD  Total 2,984,646$     2,513,969$     2,602,732$     (381,915)$        ‐13% 88,763$            4% Annual Total 4,348,762$     4,000,000$      Month 2015 vs. Budget2015 vs. 2014 Real Estate  Excise  Tax  Revenues Year  to Date through July 2014 2015 2015 Actual Budget Actual $ % $ % Jan 131,776$         142,914$         158,293$         26,516$            20% 15,379$            11% Feb 133,109            111,429            184,189            51,080               38% 72,759               65% Mar 153,695            142,756            169,262            15,567               10% 26,506               19% Apr 103,980            142,027            207,646            103,666            100% 65,619               46% May 138,319            127,128            183,090            44,771               32% 55,962               44% Jun 135,701            105,469            174,036            38,335               28% 68,567               65% Jul 122,588            114,073            194,895            72,306               59% 80,822               71% Aug 130,381            124,075             ‐                         Sep 139,444            137,724            ‐                         Oct 155,499            144,185            ‐                         Nov 156,921            146,442            ‐                         Dec 148,970            161,778            ‐                         YTD  Total 919,169$         885,796$         1,271,410$     352,242$         38% 385,614$         44% Annual  Total 1,650,384$     1,600,000$      2015 vs. 2014 2015 vs. Budget Gambling Tax Revenue Month Year  to Date through July 2014 2015 2015 Actual Budget Actual $ % $ % Jan 323,121$         302,491$         333,343$         10,222$            3% 30,852$            10% Feb ‐                        95                           ‐                         Mar ‐                        424                        ‐                         Apr 323,544            301,608            335,218            11,674               4% 33,610               11% Jul 324,273            303,714            340,657            16,383               5% 36,943               12% Oct 321,828            305,167             ‐                         Dec 49,502               46,502               ‐                         YTD Total 970,939$         908,331$         1,009,218$     38,279$            4% 101,405$         11% Annual  Total 1,342,269$     1,260,000$      Franchise  Fees  Revenue Year  to Date through July Month 2015 vs. 2014 2015 vs. Budget Page 4 of 36 Monthly Financial Report July 2015      Admission Tax   Admission Tax returns are due  quarterly in January, April, July,  and October of each year.  July  2015 collections represent  activities conducted during the 2nd  quarter of 2015.  The year‐to‐date  collection of $235k is $1k more  than the prior year but is $3k or  1% less than the budget.  The City  is projecting admission taxes to be  very close to the budget at year‐ end.          Licenses and Permits    Building Permits and  Development Service Fees  Building Permits and  Development Service Fee  revenues totalled $874k in July.   The year‐to‐date development  fees revenue of $3.7 million is  $891k or 32% more than the year  before and is also $913k or 33%  higher than budget.  The variance  in June/July 2015 is due to a large  payment for building permits and  plan checking fees (Southport  Developer and Group Health  Projects).  The City is projecting  building permits and development  service fees to exceed the budget  at year‐end (due to one‐time large projects: Southport, Group Health, and Ikea).      Business Licenses  Business Licenses totalled $646k  for July, which is $8k or 1% above  the same month last year and is  also $35k or 6% above the current  month’s budget.  The year‐to‐date  Business Licenses revenue of $2.2  million is $96k or 5% above the  prior year and is above the budget  by $103k or 5%.  The City is  projecting business licenses to be  very close to the budget at year‐ end.  2014 2015 2015 Actual Budget Actual $ % $ % Jan 80,243$            81,652$            83,675$            3,432$               4% 2,023$               2% Feb ‐                         ‐                        1,371                  1,371                  100% 1,371                  100% Mar ‐                        ‐                        106                       106                       100% 106                       100% Apr 74,163               72,512               65,108               (9,055)                  ‐12% (7,404)                  ‐10% May ‐                        ‐                        1,523                  1,523                  100% 1,523                  100% Jun 145                       73                          ‐                         Jul 79,130               83,619               82,804               3,675                  5% (815)                      ‐1% Aug ‐                        38                          ‐                         Oct 76,631               81,433               ‐                         Nov ‐                        598                       ‐                         Dec ‐                        75                          ‐                         YTD  Total 233,681$         237,856$         234,588$         1,053$               0% (3,195)$               ‐1% Annual  Total 310,311$         320,000$          Month 2015 vs. 2014 2015 vs. Budget Admission  Tax Revenue Year  to Date through July 2014 2015 2015 Actual Budget Actual $ % $ % Jan 432,890$         417,515$         260,603$         (172,288)$        ‐40% (156,913)$        ‐38% Feb 412,317            354,160            328,557            (83,760)               ‐20% (25,602)              ‐7% Mar 388,190            373,356            275,826            (112,364)           ‐29% (97,530)               ‐26% Apr 374,004            408,228            655,282            281,279            75% 247,055            61% May 349,590            404,850            235,121            (114,469)           ‐33% (169,729)           ‐42% Jun 516,689            448,800            1,024,848        508,160            98% 576,048            128% Jul 288,957            333,738            873,549            584,591            202% 539,811            162% Aug 300,184            353,949             Sep 369,040            343,237             Oct 393,023            463,224             Nov 239,983            351,665             Dec 454,368            427,027             YTD  Total 2,762,637$     2,740,646$     3,653,786$     891,149$         32% 913,140$         33% Annual  Total 4,519,234$     4,679,749$      Building Permits  and Development Service  Fees Year  to Date through July 2015 vs. Budget2015 vs. 2014 Month 2014 2015 2015 Actual Budget Actual $ % $ % Jan 597,369$         544,128$         588,093$         (9,276)$               ‐2% 43,964$            8% Feb 145,936            178,140            222,022            76,086               52% 43,882               25% Mar 28,425               46,252               26,067               (2,358)                  ‐8% (20,185)               ‐44% Apr 557,203            543,071            513,360            (43,843)               ‐8% (29,711)               ‐5% May 86,852               129,015            167,985            81,133               93% 38,971               30% Jun 39,763               34,705               25,663               (14,100)               ‐35% (9,042)                  ‐26% Jul 637,487            611,117            645,791            8,304                  1% 34,674               6% Aug 95,938               134,518             ‐                         Sep 28,686               27,016               ‐                         Oct 619,492            640,673            ‐                         Nov 108,061            95,071               ‐                         Dec 20,639               22,294               ‐                         YTD  Total 2,093,034$     2,086,427$     2,188,980$     95,946$            5% 102,552$         5% Annual  Total 2,965,850$     3,006,000$      *Total Business License (GF & CIP) Business Licenses* Month 2015 vs. 2014 Year to Date through July 2015 vs. Budget Page 5 of 36 Monthly Financial Report July 2015      Intergovernmental  These revenue sources  include federal (direct and  indirect) grants, state  grants, state shared  revenues, local grants, and  entitlements.  State shared  revenues and Fire Districts’  25 and 40 contracts  compose 87% of the total  revenues in this category.   The year‐to‐date total Intergovernmental revenue is $6.9 million or 52% of the budget.       State Shared Revenues  State Shared Revenue  collections totalled $3  million since the start of the  year.  Compared to the  prior year, State Shared  Revenues are above by  $77k or 3%.  Compared to  the projected budget, the  City is collecting $315k or  12% more.  The higher than  expected collection is due  to collecting more than  anticipated Criminal Justice  Sales Tax and the low budget of Criminal Justice’s High Crime.      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 56%  of the total revenue in this category.  The year‐to‐date total charges for services are $5.1 million or 73% of the budget.  The  following sections provide detail information for Public Safety, Recreation, and Interfund Services.      Public Safety Services  Public Safety Services totalled  $438k 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 $6k or 1% less.   Compared to the year‐to‐date  budget, the City is over budget by  $153k or 54%.  The large January  2014 variance is due to the timing  of when Valley Narcotics  Enforcement Team (VNET)  contributions are receipted.  The  2014 2015 2015 Actual Budget Actual $ % $ % Jan 117,639$         50,388$            58,509$            (59,130)$            ‐50% 8,121$               16% Feb 45,139               54,499               42,228               (2,910)                  ‐6% (12,271)               ‐23% Mar 44,028               27,253               62,481               18,453               42% 35,228               129% Apr 38,202               34,344               146,715            108,513            284% 112,371            327% May 35,540               28,065               55,309               19,769               56% 27,243               97% Jun 107,246            48,449               33,004               (74,242)               ‐69% (15,445)               ‐32% Jul 56,212               42,187               39,540               (16,672)               ‐30% (2,647)                  ‐6% Aug 64,201               35,937               ‐                         Sep 44,169               31,301               ‐                         Oct 190,822            91,374               ‐                         Nov 37,507               29,303               ‐                         Dec 65,704               39,982               ‐                         YTD  Total 444,005$         285,184$         437,785$         (6,220)$               ‐1% 152,601$         54% Annual Total 846,409$         513,081$          Month 2015 vs. 2014 Year  to Date through July Public Safety Services 2015 vs. Budget Intergovernmental 2014 2015 Bgt YTD  Act Change  2015/2014 2015 Act  vs Bgt  Fire  District #25 620,568$         628,463$         628,463$         7,896$             1% $                          ‐ 0% Fire  District #40 2,356,775        2,476,103        2,476,103        119,328          5%‐                            0% State  Shared Revenue 2,881,821        2,644,256        2,958,875        77,053             3% 314,619          12% Federal  Grants 934,344            453,556            453,556            (480,788)         ‐51%‐                            0% State  Grants 22,404               39,151               39,151               16,746             75%‐                            0% Other Grants/Intgovt 130,686            397,716            391,484            260,798          200% (6,233)                ‐2% ARRA Grants ‐                              0                             ‐                              ‐                            N/A ‐                            0% Total  Rev YTD 6,946,598$     6,639,245$     6,947,631$     1,033$             0%308,386$        5% Total  Rev Annual 13,664,242$  13,251,387$   YTD  %51% 50% 52% Note:  Includes CJ Sales  Tax  and FD25 & FD40 contracts 2014 2015 2015 Actual Budget Actual $ % $ % Crim Just Sales  Tax 1,266,133$     1,289,267$     1,375,384$     109,251$         9% 86,116$            7% Judicial Contribution 16,968                ‐                        10,895               (6,073)                  ‐36% 10,895               100% Crim Just ‐ High Crime 191,330            ‐                        125,694            (65,636)               ‐34% 125,694            100% Crim Just ‐ Pop 18,245               17,776               19,332               1,086                  6% 1,556                  9% Crim Just ‐ Spec  Prog 67,823               66,090               70,894               3,072                  5% 4,804                  7% State DUI 12,949               12,704               10,847               (2,102)                  ‐16% (1,858)                  ‐15% Liquor Profits 424,823            425,177            425,911            1,087                  0% 734                       0% Liquor Excise  Tax 132,726            120,345            153,491            20,764               16% 33,146               28% Fuel Tax 750,824            712,896            766,428            15,604               2% 53,531               8% YTD  Total 2,881,821$     2,644,256$     2,958,875$     77,053$            3% 314,619$         12% Annual Total 5,045,728$     4,777,519$      2015 vs. Budget State  Shared Revenues 2015 vs. 2014 Revenue Year  to Date through July Page 6 of 36 Monthly Financial Report July 2015      large June 2014 variance is due to staff reimbursement for training provided to the Basic Law Enforcement Academy.  The large  October 2014 variance is due to staff reimbursement for the Oso mudslide.  April 2015 variance is due to receipting $75k  reimbursement for the School Resource Officer (SRO) program.  The City is projecting public safety services to exceed the budget  at year‐end.      Recreation  Recreation revenues totalled  $429k for the current month.   Compared to the same month the  prior year, the City collected  $110k or 35% more.  Compared to  the projected monthly budget,  the City collected $77k or 22%  more.  The year‐to‐date collection  of $996k is $14k or 1% higher  than the year before but is $31k  or 3% lower than the year‐to‐date  budget.  The variance with the  prior year and monthly budget is  due to a change in how the  recreation class revenues are  recorded.  The City is now  recognizing class revenues as the classes begin instead of when they are paid.  The City currently has $177k in class revenues to  be recognized as soon as the classes begin.  The City is projecting recreation revenues to be under the budget at year‐end.        Interfund Services  The year‐to‐date collections for  Interfund Services revenues are  $1.8 million.  Compared to the  prior year, the revenues are under  by $89k or 5%.  Compared to the  projected budget, the revenues  are above by $8k.  2015’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.  The City is projecting interfund services to be very close to the  budget at year‐end.     2014 2015 2015 Actual Budget Actual $ % $ % Jan 69,522$            68,996$            117,124$         47,602$            68% 48,128$            70% Feb 68,873               63,673               30,177               (38,696)               ‐56% (33,495)               ‐53% Mar 66,458               77,421               35,946               (30,513)               ‐46% (41,475)               ‐54% Apr 179,282            185,568            91,404               (87,879)               ‐49% (94,164)               ‐51% May 106,771            107,408            64,015               (42,756)               ‐40% (43,393)               ‐40% Jun 172,332            171,135            227,942            55,610               32% 56,807               33% Jul 318,669            352,117            428,943            110,275            35% 76,826               22% Aug 245,982            239,664             ‐                         Sep 119,109            128,721            ‐                         Oct 72,614               82,910               ‐                         Nov 36,383               54,128               ‐                         Dec 29,129               48,876               ‐                         YTD  Total 981,907$         1,026,317$     995,551$         13,644$            1% (30,766)$           ‐3% Annual  Total 1,485,123$     1,580,616$      Recreation Year to Date through July 2015 vs. Budget2015 vs. 2014 Month 2014 2015 2015 Actual Budget Actual $ % $ % Jan 301,808$         262,285$         265,068$         (36,741)$            ‐12% 2,783$               1% Feb 257,027            262,285            264,413            7,386                  3% 2,128                  1% Mar 287,465            262,285            260,071            (27,393)               ‐10% (2,213)                  ‐1% Apr 295,489            262,285            248,466            (47,023)               ‐16% (13,819)               ‐5% May 269,032            262,285            260,774            (8,259)                  ‐3% (1,511)                  ‐1% Jun 277,620            262,285            292,480            14,860               5% 30,196               12% Jul 244,707            262,285            252,451            7,744                  3% (9,834)                  ‐4% Aug 284,344            262,285             ‐                         Sep 278,550            262,285            ‐                         Oct 256,662            262,285            ‐                         Nov 254,192            262,285            ‐                         Dec 263,607            262,285            ‐                         YTD  Total 1,933,148$     1,835,993$     1,843,723$     (89,426)$           ‐5% 7,730$               0% Annual  Total 3,270,503$     3,147,416$      Interfund Services Year  to Date through July 2015 vs. 2014 2015 vs. Budget Month Page 7 of 36 Monthly Financial Report July 2015      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  $1.6 million.  This is $214k or 15%  higher than a year ago but is  $328k or 17% below the budget.   The reason for the variance with  the prior year and budget is due  to a change in accounting for  December 2014’s revenue.  In the  past we would record December  through November, but starting in 2015 we are recording January through December.  The City is projecting fines and penalties  to be under the budget at year‐end.        Included in the Fines and Penalties revenue  budget is $2.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 $1.2 million.      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 $308k 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 and February 2015’s equipment rental costs were recorded in March.  The City is projecting photo  enforcement program revenues to be under the budget at year‐end.   2014 2015 2015 Actual Budget Actual $ % $ % Jan 136,762$         180,526$         124,856$         (11,906)$            ‐9% (55,670)$            ‐31% Feb 151,470            241,215            213,981            62,511               41% (27,234)               ‐11% Mar 203,482            285,153            275,737            72,255               36% (9,417)                  ‐3% Apr 263,785            357,892            245,206            (18,579)               ‐7% (112,686)            ‐31% May 208,436            298,306            257,217            48,781               23% (41,089)               ‐14% Jun 224,214            299,729            268,116            43,903               20% (31,612)               ‐11% Jul 205,103            271,908            221,949            16,846               8% (49,959)               ‐18% Aug 258,728            261,362             Sep 247,480            243,883             Oct 239,990            262,728             Nov 287,406            292,068             Dec 256,092            325,729             YTD  Total 1,393,252$     1,934,730$     1,607,062$     213,809$         15% (327,669)$        ‐17% Annual  Total 2,682,948$     3,320,500$      2015 vs. Budget2015 vs. 2014 Year to Date through July Fines  and Penalties by Month Month Year  to Date through July 2014 2015 2015 Actual Budget Actual $ % $ % Civil Penalties 3,939$               8,578$               1,878$               (2,061)$               ‐52% (6,701)$               ‐78% Civil Infraction Penalties 322,508            351,366            217,072            (105,435)            ‐33% (134,294)            ‐38% Civil  Parking Infraction Penalties 102,473            104,600            79,429               (23,044)               ‐22% (25,172)               ‐24% Photo Enforcement Program 799,863            1,293,309        1,151,572        351,709            44% (141,737)            ‐11% Criminal Traffic  Misdemeanor Fines 51,312               65,586               43,409               (7,902)                  ‐15% (22,177)               ‐34% Criminal Non‐Traffic  Fines 25,287               26,386               40,732               15,445               61% 14,346               54% Criminal Costs 73,734               70,625               57,313               (16,421)               ‐22% (13,313)               ‐19% Non‐Court Fines, Forfeitures  and Penalties 14,137               14,279               15,657               1,520                  11% 1,378                  10% YTD  Total 1,393,252$     1,934,730$     1,607,062$     213,809$         15% (327,669)$        ‐17% Annual Total 2,682,948$     3,320,500$      Revenue 2015 vs. Budget Fines  and Penalties by Type 2015 vs. 2014 Favorable 15 Budget 15 Actual 15  Budget 15 Actual (Unfavorable) 1 Jan 138,983$         121,709$         88,955$            25,705$            96,004$             Feb 148,513            152,185            88,955               25,705               126,480             Mar 168,263            198,034            88,955               162,480            35,554                Apr 251,837            166,166            88,955               94,253               71,913                May 200,513            164,775            88,955               94,100               70,675                Jun 191,262            200,678            88,955               94,154               106,524             Jul 193,937            148,024            88,955               94,291               53,734                Aug 168,554            ‐                        88,955               ‐                        ‐                         Sep 153,716            ‐                        88,955               ‐                        ‐                         Oct 170,949            ‐                        88,955               ‐                        ‐                         Nov 199,054            ‐                        88,955               ‐                        ‐                         Dec 208,419            ‐                        88,955               ‐                        ‐                         YTD  Total 1,293,309$     1,151,572$     622,685$         590,688$         560,884$          Annual  Total 2,194,000$     1,067,460$      1Actuals  of Revenues  and Expenses ExpensesRevenues Photo Enforcement  Program Year to Date  through July Month Page 8 of 36 Monthly Financial Report July 2015      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.  Interest and other  earnings along with rents, leases,  and concessions constitute 72% of  the total revenue in this category.   The year‐to‐date total  miscellaneous is $1.3 million.   Compared to last year, the  revenues are above by $387k or  44%.  Compared to the projected  year‐to‐date budget, the revenues  are over by $392k or 45%.  The negative amount for July 2014 is due to a correction made to move interest earned from Utility  tax audits, originally recorded in June.  The large variance in January 2015 and September 2014 is due to recording a trued up  asset interfund interest received from Surface Water Utility.  This offsets the correction made to the acreage count Street  Maintenance pays to Surface Water.  The table below page breaks out miscellaneous revenues by type.  The City is projecting  miscellaneous revenues to exceed the budget at year‐end.    Interest and other earnings are higher than the prior year and budget due to the timing of when interfund interest was recorded  from Surface Water to Street Maintenance (prior year, trued up in September).    Other miscellaneous revenues are higher than the prior year and budget due to higher than expected utility late payment  penalties and miscellaneous fire reimbursements.      EXPENSES  Overall the City has expended 55% of its budgeted general governmental expenditures at the end of July.  This is $1.7 million or  2.6% below year‐to‐date budgeted expenditures.  The City did not have any general governmental departments over budget but  we did see some divisions within those departments over budget. Please refer to the General Governmental Funds Summary of  Sources and Uses table on page 1 for details.     2014 2015 2015 Actual Budget Actual $ % $ % Jan 243,963$         195,249$         269,664$         25,701$            11% 74,416$            38% Feb 99,547               79,392               135,539            35,992               36% 56,147               71% Mar 126,132            138,941            182,386            56,253               45% 43,445               31% Apr 70,094               79,092               132,893            62,799               90% 53,801               68% May 107,650            134,915            144,753            37,103               34% 9,837                  7% Jun 257,714            214,161            215,629            (42,085)               ‐16% 1,468                  1% Jul (21,407)              37,022               189,913            211,319             ‐987% 152,890            413% Aug 121,979            120,533             Sep 552,749            422,492             Oct 119,594            105,005             Nov 128,732            105,350             Dec 491,839            533,056             YTD  Total 883,693$         878,773$         1,270,776$     387,083$         44% 392,003$         45% Annual  Total 2,298,586$     2,165,209$      Year to Date through July Month 2015 vs. Budget2015 vs. 2014 Miscellaneous  Revenues  by Month 2014 2015 2015 Actual Budget Actual $ % $ % Interests and Other  Earnings 79,505$            87,736$            401,205$         321,700$         405% 313,469$         357% Rents, Leases, and Concessions 514,153            511,987            516,109            1,956                  0% 4,122                  1% Contributions/Donations  from  Private Sources 65,672               58,088               79,984               14,311               22% 21,896               38% Other 221,016            163,638            267,035            46,018               21% 103,396            63% Seizure  Funds  ‐ Federal/State/Local 3,346                  57,323               6,444                  3,097                  93% (50,880)               ‐89% YTD Total 883,693$         878,773$         1,270,776$     387,083$         44% 392,003$         45% Annual Total 2,298,586$     2,165,209$      2015 vs. Budget Miscellaneous  Revenues  by Type Year to Date through July Revenue 2015 vs. 2014 Page 9 of 36 Monthly Financial Report July 2015      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 fund are the capital revenues and expenditures.    Airport Golf Course Solid Waste  Utility Water Utility Wastewater  Utility Surface Water  Utility Metro REVENUES: Licenses  and permits ‐                 ‐                 ‐                 ‐                 56,975            25,300            ‐                  Grants  / intergovernmental 1,324,831       ‐                 109,496          ‐                 15,161            1,052,680       ‐                  Charges  for services 84,242            1,215,879       10,309,259     9,370,671       5,726,866       6,318,381       9,223,282        Interdepartmental services ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                  Fines  and penalties 1,870              ‐                 ‐                 ‐                 495                 ‐                 ‐                  Rents, leases, and misc fees 1,427,348       249,287          45,892            79,098            ‐                 ‐                 ‐                  Interest and other misc 3,473              8,015              8,598              612,102          647,854          1,091,433       10,214             TOTAL REVENUES 2,841,764       1,473,181       10,473,245     10,061,871     6,447,351       8,487,794       9,233,496        EXPENSES: Utility billing ‐                 ‐                 76,600            70,464            55,166            88,891            ‐                  Utility systems ‐                 ‐                 8,338,957       2,338,966       1,850,982       1,908,598       ‐                  Utility maintenance ‐                 ‐                 162,089          2,953,003       888,118          1,459,628       8,960,810        Transportation 865,836          ‐                 ‐                 ‐                 ‐                 ‐                 ‐                  Golf ‐                 1,136,854       ‐                 ‐                 ‐                 ‐                 ‐                  TOTAL EXPENSES 865,836          1,136,854       8,577,646       5,362,433       2,794,266       3,457,117       8,960,810        AMOUNT AVAILABLE  FOR DEBT SERVICE 1,975,928       336,327          1,895,600       4,699,438       3,653,085       5,030,677       272,686           DEBT SERVICE: Principal ‐                 ‐                 ‐                 395,175          265,745          42,590            ‐                  Interest ‐                 ‐                 ‐                 297,136          148,920          431,026          ‐                  TOTAL DEBT SERVICE ‐                 ‐                 ‐                 692,311          414,665          473,616          ‐                  CAPITAL PROJECTS 1,800,355       ‐                 ‐                 516,480          447,838          2,191,654       ‐                  TRANSFERS IN/(OUT)‐                 ‐                 ‐                 (3,187)            (326)               ‐                 ‐                  CHANGE  IN FUND BALANCE 175,573          336,327          1,895,600       3,487,460       2,790,256       2,365,407       272,686           BEGINNING FUND BALANCE, Jan 1 806,821          (42,911)          1,545,606       15,872,094     7,589,089       7,804,221       3,316,310        ENDING FUND BALANCE, Jul 31 982,394          293,416          3,441,206       19,359,554     10,379,345     10,169,628     3,588,996            Page 10 of 36 Monthly Financial Report July 2015      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 Communications Insurance Healthcare Retiree  Healthcare REVENUES: Technology Fee ‐               100,764       ‐               ‐                     ‐               ‐               ‐                Grants  / intergovernmental ‐               ‐               ‐               ‐                     ‐               ‐               40,057          Charges  for services Equipment rental  m&o 1,621,723    2,046,834    ‐               ‐                     ‐               ‐               ‐                Print and mail ‐               51,431         ‐               245,261             ‐               ‐               ‐                Communications ‐               3,183           ‐               338,036             ‐               ‐               ‐                Facilities ‐               ‐               2,870,863    ‐                     ‐               ‐               ‐                Data cards  and cell  phones ‐               93,584         ‐               ‐                     ‐               ‐               ‐                IT service co ntracts ‐               287,266        ‐               ‐                     ‐               ‐               ‐                Interest and other misc 15,135         6,107           3,864           1,283                 39,717         19,941         23,133          Internal service fund misc: Vehicle  / equipment capital  recovery 1,727,236    99,170         ‐               ‐                     ‐               ‐               ‐                Insurance premiums ‐               ‐               ‐               ‐                     1,082,741    ‐               ‐                Worker's  comp/unemployment ‐               ‐               ‐               ‐                     1,051,207    ‐               ‐                Benefit premiums ‐               ‐               ‐               ‐                     ‐               6,756,898    1,298,849     Other misc 1,778           ‐               3,153           17                      ‐               685,014       ‐                Interfund Loan ‐               ‐               ‐               ‐                     143,079       ‐               ‐                Capital  contributions ‐               ‐               ‐               ‐                     ‐               ‐               ‐                Disposal  of capital  assets 29,088         ‐               ‐               ‐                     ‐               ‐               ‐                Insurance recoveries ‐               ‐               ‐               ‐                     61,530         ‐               ‐                TOTAL REVENUES 3,394,960    2,688,339    2,877,880    584,597             2,378,274    7,461,853    1,362,039     EXPENSES: Communications 242,052              Equipment rental 1,232,354     Facilities 2,425,646     Healthcare 7,312,664     Information technology 2,133,134     Print and mail 201,292              Retiree healthcare 651,147        Risk management: Risk ma nagement 1,410,734     Unemployment 29,303          Worker's  compensation 928,775        TOTAL EXPENSES 1,232,354    2,133,134    2,425,646    443,344             2,368,812    7,312,664    651,147        AMOUNT AVAILABLE FOR CAPITAL 2,162,606    555,205       452,234       141,253             9,462           149,189       710,892        CAPITAL PROJECTS 2,568,396    269,772       167,078       ‐                     ‐               ‐               ‐                TRANSFERS IN 125,500       61,120         ‐               ‐                     1,300,000    ‐               ‐                TRANSFERS (OUT)‐               ‐               ‐               ‐                     ‐               ‐               ‐                CHANGE  IN FUND BALANCE (280,290)      346,553       285,156       141,253             1,309,462    149,189       710,892        BEGINNING FUND BALANCE, Jan 1 5,310,319    1,916,048    1,154,089    383,969             12,069,311  6,675,505    7,711,863     ENDING FUND BALANCE, Jul 31 5,030,029    2,262,601    1,439,245    525,222             13,378,773  6,824,694    8,422,755     Page 11 of 36 Monthly Financial Report July 2015      FUND BALANCE  Page 13 shows the ending fund balance as of July 2015.  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 July, the City has $19.7 million reported in the combined general governmental fund balance of the current year’s  operating budget, which is approximately 17% of budgeted operating expenditures.  This is an increase of $2.1 million from the  year’s beginning balance.  July’s ending fund balance is over the anticipated General Governmental Fund Balance of $13.8  million by $5.9 million or 43.1%.  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 12 of 36 Monthly Financial Report July 2015      City  of Renton All Funds ‐ Revenue, Expenditures and Fund  Balances Cash  Basis through July  31, 2015 Funds Balance  01/01/2015 Budgeted  Revenue Revenue  07/31/15 Total Funds   Available Budgeted  Expenditure Expenditure  07/31/15 Ending  Balance GENERAL GOVERNMENT FUNDS: 17,565,282      113,245,760    80,154,876      97,720,158      116,735,570    78,030,763      19,689,395       000 General 11,159,313      83,431,472      50,268,143      61,427,456      86,638,897      50,918,613      10,508,843       001 Community Services 2,467,703        12,478,920      6,698,803        9,166,506        12,608,356      6,477,961        2,688,545         003 Street 2,147,229        10,096,711      5,730,485        7,877,714        10,263,711      5,645,123        2,232,591         004 Community Dev Block Grant 74,951             462,908           ‐                      74,951             448,804           36,066             38,885              005 Museum 65,500             227,761           114,022           179,522           227,761           131,778           47,744              009 Farmers  Market 104,950           59,400             33,089             138,039           59,453             45,768             92,270              011 Fire Health & Wellness 74,565             25,000             11,909             86,474             25,000             10,753             75,721              201 Ltd  GO Bonds  Gen Govt Debt 838,633           1,749,405        877,997           1,716,630        1,749,405        97,050             1,619,580         215 Gen Govt Misc Debt Service 632,438           4,714,183        16,420,428      17,052,866      4,714,183        14,667,651      2,385,215         SPECIAL REVENUE FUNDS: 1,100,381        1,786,631        987,035           2,087,416        1,807,969        804,493           1,282,923         102 Arterial  Street 14,885             640,000           361,162           376,047           640,000            ‐                      376,047            108 Leased  City Properties 121,014           768,957           388,568           509,582           663,403           638,789           (129,207)          110 Hotel Motel 219,090           265,000           153,191           372,281           283,942           93,831             278,450            125 1% For Art 101,380           15,000             291                  101,671           102,950           ‐                      101,671            127 Cable  Communication 313,090           97,674             82,875             395,965           117,674           71,873             324,092            135 Springbrook Wetlands  Bank 330,922           ‐                      948                  331,870           ‐                      ‐                      331,870            CAPITAL PROJECT FUNDS (CIP):27,979,966      23,803,437      8,253,804        36,233,770      47,027,879      12,807,099      23,426,671       303 Community Dev Mitigation 1,238,600        86,500             192,018           1,430,618        ‐                      ‐                      1,430,618         304 Fire  Mitigation 926,488           99,000             351,444           1,277,932        250,000           ‐                      1,277,932         305 Transportation  Mitigation 844,648           216,500           828,770           1,673,418        391,000           ‐                      1,673,418         316 Municipal  Facilities  CIP 4,493,986        4,718,145        3,754,474        8,248,460        8,918,715        2,875,972        5,372,488         317 Transportation  CIP 4,059,718        18,683,292      3,088,370        7,148,088        22,063,404      2,980,887        4,167,201         326 Housing Opportunity 1,086,766        ‐                      3,060               1,089,826        75,000             50,000             1,039,826         336 New Library Development 15,329,760      ‐                      35,668             15,365,428      15,329,760      6,900,240        8,465,188         ENTERPRISE FUNDS:36,891,230      97,849,061      49,047,868      85,939,098      107,984,277    37,724,556      48,214,542       4X2 Airport Operating & CIP 806,821           16,596,888      2,841,764        3,648,585        16,469,927      2,666,191        982,394            403 Solid Waste  Utility 1,545,606        16,461,726      10,473,246      12,018,852      16,675,139      8,577,645        3,441,207         4X4 Golf Operating & CIP (42,911)           2,655,383        1,502,346        1,459,435        2,616,052        1,166,019        293,416            4X5 Water Operating & CIP 15,872,094      16,272,634      10,061,871      25,933,965      20,799,381      6,574,410        19,359,555       4X6 Waste Water Operating & CIP 7,589,089        11,979,140      6,447,351        14,036,440      13,588,076      3,657,094        10,379,346       416 King  County Metro 3,316,310        16,638,722      9,233,496        12,549,806      16,638,722      8,960,810        3,588,996         4X7 Surface  Water Operating & CIP 7,804,221        17,244,568      8,487,794        16,292,015      21,196,980      6,122,387        10,169,628       INTERNAL SERVICE FUNDS:35,221,104      37,224,840      22,234,562      57,455,666      36,727,348      19,572,347      37,883,319       501 Equipment Repair/Replacement 5,310,319        5,779,036        3,520,461        8,830,780        6,878,442        3,800,750        5,030,030         502 Insurance 12,069,311      5,641,647        3,678,274        15,747,585      3,594,578        2,368,812        13,378,773       503 Information Services 1,916,048        4,631,231        2,749,459        4,665,507        5,606,865        2,402,906        2,262,601         504 Facilities 1,154,089        4,954,325        2,877,880        4,031,969        5,115,716        2,592,724        1,439,245         505 Communications 383,969           992,431           584,597           968,566           991,430           443,344           525,222            512 Insurance, Healthcare 6,675,505        12,954,736      7,461,853        14,137,358      13,424,573      7,312,664        6,824,694         522 Insurance, Leoff1 Retirees HC 7,711,863        2,271,434        1,362,038        9,073,901        1,115,744        651,147           8,422,754         FIDUCIARY FUNDS:5,040,982        468,000           153,495           5,194,477        210,475           121,399           5,073,078         611 Firemen's  Pension 5,040,982        468,000           153,495           5,194,477        210,475           121,399           5,073,078         TOTAL  FUNDS 123,798,945 274,377,729 160,831,640 284,630,585 310,493,518 149,060,657 135,569,928  Page 13 of 36 City of Renton General Government Financial Position 2015 Budget Year General Government Summary  Revenues Expenditures  $ Difference over (under)  w/beginning  balance  17,565,282             January 5,697,180              8,067,548              (2,370,368)             15,194,914             February 11,956,490            17,074,731            (5,118,241)             12,447,041             March 18,465,333            25,740,531            (7,275,198)             10,290,084             April 35,699,323            33,688,640            2,010,683              19,575,965             May 51,254,305            42,084,303            9,170,002              26,735,284             June 58,502,159            51,004,212            7,497,948              25,063,230             July 66,463,072            64,338,959            2,124,113              19,689,395             August September October November December  (9,000,000)  (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  9,000,000  10,000,000  11,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 14 of 36 City of Renton Monthly Revenue Analysis ‐ 2015 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 5,741,881        5,697,180         ‐0.78% Feb 12,058,105      11,956,490       ‐0.84% Mar 18,474,798      18,465,333       ‐0.05% Apr 33,331,883      35,699,323      7.10% May 49,983,090      51,254,305      2.54% Jun 55,989,669      58,502,159      4.49% Jul 62,232,808      66,463,072      6.80% Aug 68,674,474       Sep 75,108,141       Oct 91,031,294       Nov 105,811,430     Dec 113,245,760     Percent of budget 70.78% Property Tax Budget YTD Actual Annual %  over (under) Jan 27,853              67,234              141.39% Feb 320,628           374,240           16.72% Mar 1,386,683        1,313,457         ‐5.28% Apr 9,424,178        11,473,575      21.75% May 17,968,476      19,057,443      6.06% Jun 17,986,266      19,204,760      6.77% Jul 18,513,875      19,270,155      4.08% Aug 18,941,825       Sep 19,457,794       Oct 28,804,271       Nov 35,032,115       Dec 36,040,000       Percent of budget 53.47%  $‐  $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  $110  $120 Millions Total Revenue General Government Budget Actual Last Year  $(3)  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  $33  $36 Millions Property Tax Budget Actual Last Year Page 15 of 36 City of Renton Monthly Revenue Analysis ‐ 2015 Budget Year Sales Tax Budget YTD Actual Annual %  over (under) Jan 1,930,372        1,966,653        1.88% Feb 4,312,924        4,494,673        4.21% Mar 6,156,744        6,366,163        3.40% Apr 8,019,181        8,324,401        3.81% May 10,179,318      10,538,752      3.53% Jun 12,126,605      12,415,056      2.38% Jul 14,093,945      14,503,117      2.90% Aug 16,267,801       Sep 18,318,344       Oct 20,462,487       Nov 22,646,995       Dec 24,759,699       Percent of budget 58.58% Note:  Excludes CJ Sales Tax and Natural Gas Use Tax. Utility Tax Budget YTD Actual Annual %  over (under) Jan 1,371,800        1,199,348         ‐12.57% Feb 2,882,713        2,571,119        ‐10.81% Mar 4,324,593        4,115,178        ‐4.84% Apr 5,743,761        5,379,077        ‐6.35% May 7,135,600        6,641,841        ‐6.92% Jun 8,445,745        8,457,125        0.13% Jul 9,632,402        10,632,292      10.38% Aug 10,925,876       Sep 12,263,996       Oct 13,427,619       Nov 14,660,851       Dec 16,173,734       Percent of budget 65.74% Note:  Includes Natural Gas Use Tax.  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27 Millions Sales Tax Budget Actual Last Year  $‐  $2  $4  $6  $8  $10  $12  $14  $16  $18 Millions Utility Tax Budget Actual Last Year Page 16 of 36 City of Renton Monthly Revenue Analysis ‐ 2015 Budget Year Licenses &  Permits Budget YTD Actual Annual %  over (under) Jan 401,666           299,656            ‐25.40% Feb 703,556           583,727            ‐17.03% Mar 936,587           784,273            ‐16.26% Apr 1,341,646        1,164,263         ‐13.22% May 1,662,501        1,377,137         ‐17.16% Jun 2,022,387        1,717,718         ‐15.06% Jul 2,361,559        2,571,810        8.90% Aug 2,657,556         Sep 2,918,335         Oct 3,399,093         Nov 3,693,994         Dec 3,911,417         Percent of budget 65.75% Note:  GF only Intergovt'l Budget YTD Actual Annual %  over (under) Jan 434,559           500,793           15.24% Feb 1,046,944        1,144,443        9.31% Mar 1,571,828        1,686,664        7.31% Apr 2,644,504        2,889,749        9.27% May 5,550,244        5,820,910        4.88% Jun 6,251,743        6,536,174        4.55% Jul 6,639,245        6,947,631        4.64% Aug 7,298,611         Sep 7,999,550         Oct 8,984,237         Nov 12,573,419       Dec 13,251,387       Percent of budget 52.43% Note:  Includes CJ Sales Tax and FD25 & FD40 contracts  $‐  $2  $4  $6  $8  $10  $12  $14 Millions Intergovernmental Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00 Millions Licenses & Permits Budget Actual Last Year Page 17 of 36 City of Renton Monthly Revenue Analysis ‐ 2015 Budget Year Charges for  Services Budget YTD Actual Annual %  over (under) Jan 534,248           523,882            ‐1.94% Feb 1,045,979        982,531            ‐6.07% Mar 1,605,315        1,508,665         ‐6.02% Apr 2,237,065        2,428,409        8.55% May 2,787,340        2,895,781        3.89% Jun 3,406,478        4,190,545        23.02% Jul 4,183,462        5,100,073        21.91% Aug 4,839,746         Sep 5,375,897         Oct 5,947,939         Nov 6,408,613         Dec 7,009,814         Percent of budget 72.76% Note: Excludes FD25 & FD40 contracts Fines &  Forfeits Budget YTD Actual Annual %  over (under) Jan 180,526           124,856            ‐30.84% Feb 421,742           338,837            ‐19.66% Mar 706,895           614,574           ‐13.06% Apr 1,064,787        859,779           ‐19.25% May 1,363,093        1,116,996        ‐18.05% Jun 1,662,822        1,385,113        ‐16.70% Jul 1,934,730        1,607,062        ‐16.94% Aug 2,196,092         Sep 2,439,975         Oct 2,702,703         Nov 2,994,771         Dec 3,320,500         Percent of budget 48.40%  $‐  $1  $2  $3  $4  $5  $6  $7  $8 Millions Charges for Services Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50 Millions Fines & Forfeits Budget Actual Last Year Page 18 of 36 City of Renton Monthly Revenue Analysis ‐ 2015 Budget Year Other Taxes Budget YTD Actual Annual %  over (under) Jan 644,357           745,094           15.63% Feb 1,048,477        1,061,217        1.22% Mar 1,372,072        1,488,270        8.47% Apr 2,360,868        2,456,370        4.05% May 2,705,211        2,936,494        8.55% Jun 3,242,156        3,511,086        8.29% Jul 3,986,710        4,552,047        14.18% Aug 4,377,660         Sep 4,721,202         Oct 5,563,642         Nov 5,934,771         Dec 6,359,000         Percent of budget 71.58% Misc Budget YTD Actual Annual %  over (under) Jan 195,249           269,664           38.11% Feb 274,641           405,203           47.54% Mar 413,582           587,589           42.07% Apr 492,674           720,482           46.24% May 627,590           865,234           37.87% Jun 841,751           1,080,863        28.41% Jul 878,773           1,270,776        44.61% Aug 999,306            Sep 1,421,798         Oct 1,526,803         Nov 1,632,153         Dec 2,165,209         Percent of budget 58.69%  $‐  $0.50  $1.00  $1.50  $2.00  $2.50 Millions Miscellaneous Budget Actual Last Year  $‐  $1  $2  $3  $4  $5  $6  $7 Millions Other Taxes Budget Actual Last Year Page 19 of 36 City of Renton Monthly Revenue Analysis ‐ 2015 Budget Year Other  Financing Budget YTD Actual Annual %  over (under) Jan 21,250               ‐                         0.00% Feb 500                   500                   0.00% Mar 500                   500                   0.00% Apr 3,218                3,218                0.00% May 3,718                3,718                0.00% Jun 3,718                3,718                0.00% Jul 8,107                8,107                0.00% Aug 170,000            Sep 191,250            Oct 212,500            Nov 233,750            Dec 255,000            Percent of budget 5372.51% $0 $0 $0 $0 $0 $0 $0 Mi l l i o n s Other Financing Sources Budget Actual Last Year Page 20 of 36 City of Renton Monthly Revenue Analysis ‐ 2015 Budget Year REET Budget YTD Actual Annual %  over (under) Jan 173,895           226,377           30.18% Feb 495,032           384,994            ‐22.23% Mar 761,342           728,573            ‐4.30% Apr 1,309,602        1,167,058         ‐10.88% May 1,625,320        1,561,072         ‐3.95% Jun 2,129,952        2,039,258         ‐4.26% Jul 2,513,969        2,602,732        3.53% Aug 2,821,167         Sep 3,073,250         Oct 3,403,605         Nov 3,690,004         Dec 4,000,000         Percent of budget 65.07% Bldg Permits  & Devlpmt Svc  Fees Budget YTD Actual Annual %  over (under) Jan 417,515           260,603            ‐37.58% Feb 771,675           589,160            ‐23.65% Mar 1,145,031        864,986            ‐24.46% Apr 1,553,259        1,520,269        ‐2.12% May 1,958,109        1,755,389        ‐10.35% Jun 2,406,908        2,780,238        15.51% Jul 2,740,646        3,653,786        33.32% Aug 3,094,595         Sep 3,437,832         Oct 3,901,056         Nov 4,252,721         Dec 4,679,749         Percent of budget 78.08%  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50 Millions Real Estate Excise Tax 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 Building Permits and Development Service  Fees Budget Actual Last Year Page 21 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 8,870,600        8,067,548         ‐9.05% Feb 17,801,905      17,074,731       ‐4.08% Mar 26,364,534      25,740,531       ‐2.37% Apr 35,014,766      33,688,640       ‐3.79% May 43,621,787      42,084,303       ‐3.52% Jun 52,637,381      51,004,212       ‐3.10% Jul 66,034,196      64,338,959       ‐2.57% Aug 76,924,507       Sep 86,678,596       Oct 96,121,914       Nov 105,536,315     Dec 116,735,570     Percent of budget expended 66.84% Legislative Budget YTD Actual Annual %  over (under) Jan 26,298              32,033              21.81% Feb 58,089              58,037               ‐0.09% Mar 87,938              88,145              0.23% Apr 115,765           113,635            ‐1.84% May 142,930           140,500            ‐1.70% Jun 171,000           166,120           ‐2.85% Jul 198,534           191,473           ‐3.56% Aug 225,314            Sep 252,423            Oct 279,819            Nov 307,043            Dec 335,838            Percent of budget expended 57.01%  $‐  $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  $110  $120 Millions Total Expenditures General Government Budget Actual Last Year  $‐  $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  $350,000 Legislative Budget Actual Last Year Page 22 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Executive Budget YTD Actual Annual %  over (under) Jan 103,164           80,465               ‐22.00% Feb 247,755           200,055            ‐19.25% Mar 394,565           319,885            ‐18.93% Apr 549,627           443,641            ‐19.28% May 694,977           568,027            ‐18.27% Jun 826,471           687,127            ‐16.86% Jul 971,091           814,282            ‐16.15% Aug 1,120,544         Sep 1,257,659         Oct 1,400,057         Nov 1,537,283         Dec 1,714,717         Percent of budget expended 47.49% City Attorney Budget YTD Actual Annual %  over (under) Jan 147,754           151,100           2.27% Feb 300,008           294,916            ‐1.70% Mar 452,011           443,297            ‐1.93% Apr 612,052           599,643            ‐2.03% May 767,231           753,544            ‐1.78% Jun 934,548           908,816           ‐2.75% Jul 1,092,795        1,062,566        ‐2.77% Aug 1,255,535         Sep 1,423,372         Oct 1,584,730         Nov 1,745,168         Dec 2,001,421         Percent of budget expended 53.09%  $‐  $0.30  $0.60  $0.90  $1.20  $1.50  $1.80 Millions Executive Budget Actual Last Year  $‐  $0.40  $0.80  $1.20  $1.60  $2.00 Millions City Attorney Budget Actual Last Year Page 23 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Court Services Budget YTD Actual Annual %  over (under) Jan 166,668           151,935            ‐8.84% Feb 338,869           313,414            ‐7.51% Mar 511,393           477,408            ‐6.65% Apr 696,880           641,217            ‐7.99% May 869,244           810,280            ‐6.78% Jun 1,056,245        994,496            ‐5.85% Jul 1,234,390        1,162,369         ‐5.83% Aug 1,409,269         Sep 1,584,709         Oct 1,758,480         Nov 1,925,555         Dec 2,148,553         Percent of budget expended 54.10% CED Admin Budget YTD Actual Annual %  over (under) Jan 96,399              88,408               ‐8.29% Feb 192,792           177,244            ‐8.06% Mar 289,500           266,079            ‐8.09% Apr 387,901           358,681            ‐7.53% May 484,593           452,800           ‐6.56% Jun 581,892           546,093           ‐6.15% Jul 679,312           735,445           8.26% Aug 776,605            Sep 874,091            Oct 971,695            Nov 1,068,592         Dec 1,177,608         Percent of budget expended 62.45%  $‐  $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.20  $0.40  $0.60  $0.80  $1.00  $1.20 Millions Community & Economic Development Admin Budget Actual Last Year Page 24 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Development  Services Budget YTD Actual Annual %  over (under) Jan 245,642           201,493            ‐17.97% Feb 478,377           427,863            ‐10.56% Mar 728,947           653,820            ‐10.31% Apr 1,000,731        867,751            ‐13.29% May 1,246,791        1,086,324         ‐12.87% Jun 1,492,934        1,300,030         ‐12.92% Jul 1,738,076        1,514,993         ‐12.84% Aug 2,000,285         Sep 2,223,932         Oct 2,468,126         Nov 2,708,274         Dec 2,964,321         Percent of budget expended 51.11% Economic  Development Budget YTD Actual Annual %  over (under) Jan 105,386           43,127               ‐59.08% Feb 152,275           122,554            ‐19.52% Mar 230,941           171,373            ‐25.79% Apr 312,564           228,439            ‐26.91% May 381,359           278,258           ‐27.04% Jun 468,634           326,497           ‐30.33% Jul 571,804           375,085           ‐34.40% Aug 668,297            Sep 758,365            Oct 846,244            Nov 929,468            Dec 1,053,786         Percent of budget expended 35.59%  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00 Millions Development Services Budget Actual Last Year  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20 Millions Economic Development Budget Actual Last Year Page 25 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Planning Budget YTD Actual Annual %  over (under) Jan 177,750           197,905           11.34% Feb 377,402           398,110           5.49% Mar 585,268           616,614           5.36% Apr 801,453           829,531           3.50% May 1,016,839        1,087,344        6.93% Jun 1,242,681        1,325,058        6.63% Jul 1,478,295        1,537,578        4.01% Aug 1,726,181         Sep 1,971,643         Oct 2,223,724         Nov 2,452,676         Dec 2,714,466         Percent of budget expended 56.64% Finance Budget YTD Actual Annual %  over (under) Jan 173,682           171,705            ‐1.14% Feb 349,801           350,741           0.27% Mar 535,847           531,013            ‐0.90% Apr 732,791           711,350            ‐2.93% May 925,150           907,912            ‐1.86% Jun 1,177,529        1,245,394        5.76% Jul 1,398,007        1,427,769        2.13% Aug 1,642,462         Sep 1,853,414         Oct 2,043,444         Nov 2,229,526         Dec 2,795,120         Percent of budget expended 51.08%  $‐  $0.40  $0.80  $1.20  $1.60  $2.00  $2.40  $2.80 Millions Finance Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00 Millions Planning Budget Actual Last Year Page 26 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year City Clerk Budget YTD Actual Annual %  over (under) Jan 62,327              55,655               ‐10.71% Feb 154,117           127,473            ‐17.29% Mar 292,896           194,321            ‐33.66% Apr 363,579           264,641            ‐27.21% May 551,378           337,039            ‐38.87% Jun 612,495           404,603            ‐33.94% Jul 674,452           472,059            ‐30.01% Aug 745,168            Sep 810,502            Oct 876,269            Nov 938,389            Dec 1,091,558         Percent of budget expended 43.25% Includes Hearing Examiner Human  Resources Budget YTD Actual Annual %  over (under) Jan 92,234              66,108               ‐28.33% Feb 191,724           156,267            ‐18.49% Mar 299,478           256,191            ‐14.45% Apr 419,831           366,906           ‐12.61% May 520,778           462,817           ‐11.13% Jun 633,337           560,008           ‐11.58% Jul 740,272           659,471           ‐10.92% Aug 851,182            Sep 962,393            Oct 1,068,605         Nov 1,178,873         Dec 1,316,577         Percent of budget expended 50.09%  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40 Millions Human Resources Budget Actual Last Year  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20 Millions City Clerk Budget Actual Last Year Page 27 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Police Budget YTD Actual Annual %  over (under) Jan 2,838,312        2,696,824         ‐4.98% Feb 5,338,652        5,110,347         ‐4.28% Mar 8,132,481        8,006,482         ‐1.55% Apr 10,622,411      10,472,025       ‐1.42% May 13,442,707      13,204,343       ‐1.77% Jun 16,063,051      15,808,511       ‐1.58% Jul 18,903,549      18,702,324       ‐1.06% Aug 21,421,969       Sep 24,280,565       Oct 26,807,764       Nov 29,604,248       Dec 32,571,356       Percent of budget expended 57.42% Fire &  Emergency  Services Budget YTD Actual Annual %  over (under) Jan 2,492,921        2,067,851         ‐17.05% Feb 5,128,345        5,131,944        0.07% Mar 7,252,690        7,236,866         ‐0.22% Apr 9,384,058        9,250,808         ‐1.42% May 11,422,752      11,360,848      ‐0.54% Jun 13,549,804      13,459,450      ‐0.67% Jul 15,728,121      15,607,269      ‐0.77% Aug 18,088,845       Sep 20,238,248       Oct 22,409,217       Nov 24,560,558       Dec 26,890,757       Percent of budget expended 58.04%  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  $33 Millions Police Budget Actual Last Year  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27 Millions Fire & Emergency Services Budget Actual Last Year Page 28 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Community  Services Admin Budget YTD Actual Annual %  over (under) Jan 43,966              41,417               ‐5.80% Feb 90,262              84,599               ‐6.27% Mar 139,409           131,187            ‐5.90% Apr 186,134           173,595            ‐6.74% May 230,632           211,318            ‐8.37% Jun 276,022           247,147            ‐10.46% Jul 322,391           290,564            ‐9.87% Aug 367,593            Sep 412,944            Oct 457,663            Nov 506,080            Dec 560,787            Percent of budget expended 51.81% Parks Budget YTD Actual Annual %  over (under) Jan 325,659           291,345            ‐10.54% Feb 673,002           618,104            ‐8.16% Mar 1,027,206        958,044            ‐6.73% Apr 1,412,601        1,289,256         ‐8.73% May 1,804,734        1,638,570        ‐9.21% Jun 2,226,430        2,010,536        ‐9.70% Jul 2,682,332        2,473,410        ‐7.79% Aug 3,178,173         Sep 3,648,648         Oct 4,090,791         Nov 4,476,422         Dec 4,870,254         Percent of budget expended 50.79%  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.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 29 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Parks Planning  and Natural  Resources Budget YTD Actual Annual %  over (under) Jan 55,675              46,145               ‐17.12% Feb 115,072           93,550               ‐18.70% Mar 187,578           151,169            ‐19.41% Apr 256,383           208,488            ‐18.68% May 340,506           283,762            ‐16.66% Jun 408,125           338,895            ‐16.96% Jul 488,654           418,287            ‐14.40% Aug 564,003            Sep 646,544            Oct 724,329            Nov 807,560            Dec 999,004            Percent of budget expended 41.87% Recreation Budget YTD Actual Annual %  over (under) Jan 314,595           338,282           7.53% Feb 674,027           685,764           1.74% Mar 1,038,567        1,048,007        0.91% Apr 1,416,679        1,422,635        0.42% May 1,774,643        1,795,232        1.16% Jun 2,177,027        2,207,568        1.40% Jul 2,840,460        2,820,946        ‐0.69% Aug 3,538,644         Sep 4,068,609         Oct 4,421,871         Nov 4,779,294         Dec 5,200,923         Percent of budget expended 54.24%  $‐  $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 Millions Recreation Budget Actual Last Year Page 30 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Human  Services Budget YTD Actual Annual %  over (under) Jan 48,370              46,455               ‐3.96% Feb 140,421           95,909               ‐31.70% Mar 241,783           251,898           4.18% Apr 375,238           410,324           9.35% May 457,411           470,636           2.89% Jun 516,776           548,427           6.12% Jul 651,597           685,824           5.25% Aug 738,983            Sep 789,632            Oct 933,439            Nov 1,005,972         Dec 1,199,977         Percent of budget expended 57.15% Neighborhoods , Resources,  and Events Budget YTD Actual Annual %  over (under) Jan 71,877              57,115               ‐20.54% Feb 160,969           132,128            ‐17.92% Mar 234,444           197,567            ‐15.73% Apr 308,166           257,014           ‐16.60% May 375,327           324,365           ‐13.58% Jun 462,220           401,711           ‐13.09% Jul 579,552           520,522           ‐10.19% Aug 670,339            Sep 750,598            Oct 831,121            Nov 918,936            Dec 1,036,841         Percent of budget expended 50.20%  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20 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 31 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Museum Fund Budget YTD Actual Annual %  over (under) Jan 18,126              18,605              2.64% Feb 36,275              37,516              3.42% Mar 54,386              56,379              3.67% Apr 73,431              75,445              2.74% May 92,462              94,299              1.99% Jun 111,827           113,004           1.05% Jul 131,075           131,778           0.54% Aug 150,608            Sep 169,866            Oct 189,289            Nov 208,614            Dec 227,761            Percent of budget expended 57.86% Public Works  Admin Budget YTD Actual Annual %  over (under) Jan 34,823              31,422               ‐9.77% Feb 69,626              64,809               ‐6.92% Mar 104,435           96,942               ‐7.17% Apr 141,243           128,823            ‐8.79% May 175,830           161,020           ‐8.42% Jun 208,809           193,206           ‐7.47% Jul 240,160           225,570           ‐6.08% Aug 271,809            Sep 303,553            Oct 334,125            Nov 364,445            Dec 395,867            Percent of budget expended 56.98%  $‐  $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  $350,000  $400,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 32 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Street  Maintenance Budget YTD Actual Annual %  over (under) Jan 382,448           387,644           1.36% Feb 810,592           784,009            ‐3.28% Mar 1,196,298        1,213,907        1.47% Apr 1,694,724        1,612,472         ‐4.85% May 2,115,430        2,027,380         ‐4.16% Jun 2,545,047        2,452,514         ‐3.64% Jul 2,969,351        2,920,408         ‐1.65% Aug 3,394,715         Sep 3,834,705         Oct 4,322,555         Nov 4,746,267         Dec 5,186,713         Percent of budget expended 56.31% Transportation Budget YTD Actual Annual %  over (under) Jan 342,755           300,741            ‐12.26% Feb 756,805           642,729            ‐15.07% Mar 1,159,250        1,186,713        2.37% Apr 1,721,150        1,532,946         ‐10.93% May 2,085,812        1,925,413         ‐7.69% Jun 2,447,685        2,312,208        ‐5.53% Jul 2,855,673        2,724,715        ‐4.59% Aug 3,315,075         Sep 3,658,906         Oct 4,074,919         Nov 4,433,073         Dec 5,076,998         Percent of budget expended 53.67%  $‐  $1.00  $2.00  $3.00  $4.00  $5.00  $6.00 Millions Street Maintenance Budget Actual Last Year $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0 $4.5 $5.0 Millions Transportation Budget Actual Last Year Page 33 of 36 City of Renton Monthly Expenditure Analysis ‐ 2015 Budget Year Debt Service Budget YTD Actual Annual %  over (under) Jan 48,139              48,139              0.00% Feb 298,456           298,456           0.00% Mar 298,456           298,456           0.00% Apr 315,231           315,231           0.00% May 298,751           298,751           0.00% Jun 814,758           814,758           0.00% Jul 1,072,897        1,072,897        0.00% Aug 4,309,059         Sep 4,847,691         Oct 5,386,323         Nov 5,924,956         Dec 6,463,588         Percent of budget expended 16.60% Non‐ Departmental  Other City Budget YTD Actual Annual %  over (under) Jan 455,629           455,629           0.00% Feb 668,193           668,193           0.00% Mar 888,765           888,765           0.00% Apr 1,114,142        1,114,142        0.00% May 1,403,520        1,403,520        0.00% Jun 1,632,035        1,632,035        0.00% Jul 5,791,355        5,791,355        0.00% Aug 4,493,852         Sep 5,055,583         Oct 5,617,315         Nov 6,179,046         Dec 6,740,778         Percent of budget expended 85.92%  $‐  $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  $8  $9 Millions Debt Service Budget Actual Last Year Page 34 of 36 City of Renton Monthly Enterprise Fund Financial Report ‐ 2015 Budget Year Utilities Budget Revenue Expense Jan 5,199,392        5,924,339      3,255,611       Feb 11,168,377      11,761,602    9,177,660       Mar 17,399,993      18,199,879    13,336,961     Apr 23,282,829      24,382,710    16,788,962     May 29,815,221      30,878,316    22,688,463     Jun 37,340,357      37,437,155    29,803,028     Jul 45,172,785      44,703,712    33,891,138     Aug 52,345,600       Sep 60,520,029       Oct 67,617,877       Nov 74,232,293       Dec 88,898,298       Percent of budget expended 31.60% Note:  Operations and Capital Airport Budget Revenue Expense Jan 384,243           211,809          77,274             Feb 1,672,027        801,118          211,920           Mar 4,340,484        1,176,025      1,153,469       Apr 4,991,541        1,410,614      1,457,521       May 6,180,175        2,385,348      2,167,372       Jun 6,825,138        2,633,309      2,397,844       Jul 8,638,312        2,841,764      2,666,191       Aug 9,349,977         Sep 11,578,029       Oct 12,523,403       Nov 14,062,517       Dec 16,469,927       Percent of budget expended 16.19% Note:  Operations and Capital $0 $10 $20 $30 $40 $50 $60 $70 $80 $90 Millions Utilities Budget Revenue Expense  $‐  $2.00  $4.00  $6.00  $8.00  $10.00  $12.00  $14.00  $16.00  $18.00 Millions Airport Budget Revenue Expense Page 35 of 36 City of Renton Monthly Enterprise Fund Financial Report ‐ 2015 Budget Year Golf Course Budget Revenue Expense Jan 136,222           86,725            126,955           Feb 267,568           192,539          271,231           Mar 424,001           356,415          452,194           Apr 608,130           576,883          608,006           May 756,759           835,706          774,384           Jun 959,820           1,183,367      956,202           Jul 1,153,686        1,502,346      1,166,019       Aug 1,493,111         Sep 1,741,845         Oct 1,899,744         Nov 2,046,993         Dec 2,616,052         Percent of budget expended 44.57% 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 36 of 36