Loading...
HomeMy WebLinkAbout201304, April.pdfADMINISTRATIVE SERVICES  DEPARTMENT    M   E   M   O   R   A   N   D   U   M       DATE: May 22, 2013     TO: Randy Corman, Council President  Members of the Renton City Council     CC: Denis Law, Mayor  Administrators     FROM: Hai Nguyen, Sr. Finance Analyst     SUBJECT: April 2013 Financial Status Report       At the end of April, general governmental revenues show $2.3 million or 7.5% over budget.   This is due to the timing of property tax collections recorded in April.  If we remove the $1.3  million favourable variance, the City is $1 million or 3.2% over budget.  Revenues sources that  are higher than expected are: sales tax ($452k); sales tax annexation credit ($101k); building  permits & development service fees ($422k); and state shared revenues ($305k).  On the down  side, the revenue sources that are underperforming the year to date budget are: utility taxes  ($394k below); gambling taxes ($65k below); and seizure funds ($82k below).    General government expenditures showed a favourable variance of $394k or 1.2%.  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 11,407,119$       11,407,119$       11,057,551$       11,057,551$       15,575,839$       15,575,839$       15,575,839$       ‐                      0.0% OPERATING REVENUES Property Tax 32,357,894          9,205,472             33,466,364          11,127,076          31,741,366          9,657,654             10,985,190          1,327,536      13.7% Sales  Tax 17,729,731          5,876,031             18,564,670          5,925,812             18,604,000          6,177,830             6,629,791             451,960          7.3% Sales  Tax ‐ Annexation Credit 2,033,954             663,746                  2,208,492             711,311                  2,119,680             682,706                  783,994                  101,288          14.8% Criminal Justice Sales  Tax 1,809,757             562,500                  1,924,470             606,636                  1,932,500             609,167                  668,470                  59,302             9.7% Natural  Gas  Use  Tax 249,407                  109,217                  272,530                  164,028                  300,000                  131,372                  107,195                  (24,177)            ‐18.4% Admission Tax 308,200                  134,463                  311,054                  154,705                  308,000                  153,186                  152,751                  (435)                    ‐0.3% Franchise  Fees 1,234,448             600,206                  1,262,188             599,927                  1,260,000             598,887                  627,348                  28,461             4.8% Electricity Tax 5,166,711             1,928,010             5,211,111             1,972,182             5,468,000             2,069,403             1,932,839             (136,564)         ‐6.6% Natural  Gas  Utility Tax 1,848,806             950,006                  1,669,967             902,298                  1,656,000             894,752                  803,039                  (91,713)             ‐10.3% Transfer  Station 297,474                  74,244                     330,607                  87,625                     300,000                  79,513                     131,525                  52,012             65.4% TV Cable 1,385,275             432,285                  1,423,664             435,101                  1,477,648             451,600                  459,812                  8,213                1.8% Telephone 966,827                  329,404                  1,056,420             308,743                  1,000,000             292,254                  251,827                  (40,427)             ‐13.8% Cellular Phone 2,054,183             711,036                  2,183,853             736,280                  2,200,000             741,724                  566,096                  (175,629)          ‐23.7% City Utilities 3,516,179             1,128,654             3,806,281             1,198,213             3,849,014             1,211,666             1,226,148             14,483             1.2% Leasehold Excise  Tax 162,593                  36,189                     158,849                  36,481                     145,000                  33,301                     40,988                     7,687                23.1% Gambling Excise  Tax 1,671,414             551,756                  1,691,209             574,574                  1,600,000             543,586                  478,183                  (65,403)            ‐12.0% Real  Estate  Excise  Tax 2,074,059             514,275                  2,811,902             690,220                  2,600,000             780,729                  822,064                  41,335             5.3% Less: Municipal Facilities  CIP REET (400,000)                (91,835)                   (943,792)                (136,340)                (500,000)                (158,095)                (158,095)                ‐                      0.0% EMS Levy 868,873                  51,467                     885,781                  ‐                              900,000                  ‐                              ‐                              ‐                      0.0% Business  License Fees 442,451                  195,003                  444,680                  206,858                  533,067                  247,974                  251,128                  3,154                1.3% Animal  Licenses and Spec Events  Permits 232,534                  57,805                     242,668                  81,688                     90,000                     36,099                     36,445                     346                     1.0% Building Permits  & Development Svc Fees 2,772,779             730,608                  3,401,537             880,622                  3,123,413             808,509                  1,230,194             421,684          52.2% Intergovt'l (Grants, State Shared, etc) 4,737,323             1,269,625             4,593,185             1,086,517             3,469,005             1,186,582             1,431,975             245,393          20.7% Fire  District 25 and 40 Contracts 6,110,668             875,762                  6,155,621             799,107                  5,574,526             555,548                  555,548                   ‐                      0.0% Public Safety 484,985                  142,506                  485,899                  153,856                  670,759                  395,731                  395,731                   ‐                      0.0% Culture  and Recreation 1,493,540             397,684                  1,494,165             363,431                  1,618,486             393,670                  361,738                  (31,932)            ‐8.1% Interfund/Interdept‐Services 3,070,506             955,923                  3,311,715             996,283                  3,313,830             1,104,610             1,164,844             60,234             5.5% Fines  and Forfeits 1,163,602             333,659                  1,046,246             275,874                  1,108,500             294,769                  313,662                  18,893             6.4% Photo Enforcement 1,897,782             705,422                  1,976,203             654,101                  1,950,000             645,428                  680,026                  34,598             5.4% Seizure Funds  ‐ Federal/State/Local 83,220                     ‐                              37,941                     17,904                     180,693                  85,266                     3,491                        (81,775)            ‐95.9% Interests and Other  Earnings 107,183                  25,356                     342,424                  29,924                     745,300                  65,131                     29,926                     (35,205)            ‐54.1% Rents, Leases, and Concessions 744,834                  264,766                  822,428                  317,035                  650,929                  250,925                  317,273                  66,348             26.4% Contributions and Donations 196,586                  49,818                     124,082                  46,718                     93,100                     35,053                     25,736                     (9,317)                ‐26.6% Other  Miscellaneous 529,147                  124,491                  564,571                  166,458                  516,369                  164,767                  238,837                  74,069             45.0% Other  Financing Sources  (Transfer‐In, etc) 1,073,507             167,151                  5,118,188             8,797                        250,000                  430                            13,343                     12,913             3003.0% Total  Operating Revenues 100,476,431       30,062,704          108,457,170       32,180,045          100,849,185       31,221,729          33,559,062          2,337,332      7.5% OPERATING EXPENDITURES Council 271,236                  89,659                     278,768                  91,998                     290,291                  95,878                     97,646                     (1,767)               ‐1.8% Executive 1,566,906             480,072                  1,377,109             427,410                  1,322,364             407,614                  419,061                  (11,447)            ‐2.8% Hearing Examiner 59,878                     25,472                     60,368                     21,235                     40,000                     15,537                     6,671                        8,866                57.1% City Attorney 1,596,609             528,480                  1,706,320             563,552                  1,915,103             633,182                  584,735                  48,447             7.7% Court Services 2,084,170             661,478                  2,074,980             674,406                  2,026,149             650,782                  643,564                  7,218                1.1% Community and Eco Dvlpmnt Admin 929,814                  310,112                  942,071                  322,177                  1,020,208             344,608                  344,293                  315                     0.1% Development Services 2,810,736             953,343                  3,103,568             959,516                  3,308,299             1,070,001             1,060,776             9,225                0.9% Economic Development 659,981                  225,181                  529,043                  188,315                  570,280                  198,321                  146,523                  51,798             26.1% Planning 1,447,781             475,330                  1,482,233             493,399                  1,541,592             509,685                  480,129                  29,556             5.8% Finance 2,134,667             620,994                  2,221,882             635,592                  2,242,682             646,871                  610,911                  35,960             5.6% City Clerk 736,880                  315,627                  937,067                  226,333                  1,061,505             343,675                  270,581                  73,093             21.3% Human Resources 888,252                  282,721                  937,412                  299,810                  977,094                  311,770                  288,203                  23,567             7.6% Police 24,737,346          8,219,907             25,004,580          8,318,096             25,376,701          8,437,147             8,188,792             248,355          2.9% Jail Services 6,206,735             749,488                  3,489,616             1,162,786             3,750,000             1,271,352             1,271,352             ‐                      0.0% Fire 22,511,597          7,652,583             24,173,315          8,435,070             24,188,120          8,335,243             8,636,731             (301,488)         ‐3.6% Community Services  Admin 416,284                  136,129                  434,558                  143,787                  450,911                  148,344                  150,854                  (2,510)               ‐1.7% Parks 3,829,676             1,109,451             4,004,054             1,179,119             4,153,621             1,213,451             1,192,965             20,486             1.7% Parks Planning & Natural  Resources 551,423                  150,610                  577,934                  169,504                  755,638                  214,184                  196,871                  17,313             8.1% Recreation 4,974,002             1,408,767             4,982,229             1,377,160             5,130,300             1,435,547             1,371,571             63,976             4.5% Human Services 1,247,294             369,358                  1,193,871             409,836                  1,196,052             381,767                  340,261                  41,506             10.9% Neighborhoods, Resources, & Events 675,534                  167,242                  701,673                  189,349                  914,955                  236,903                  231,744                  5,159                2.2% Library 2,030,000             10,119                     278,604                  58,604                     ‐                              ‐                              ‐                              ‐                      0.0% Museum 210,620                  69,499                     216,887                  71,901                     211,080                  69,816                     69,807                     8                           0.0% Public Works  Admin 452,538                  149,219                  470,051                  158,967                  483,035                  161,356                  163,297                  (1,941)               ‐1.2% Street Maintenance 3,534,025             1,168,482             3,755,640             1,217,508             4,294,894             1,405,768             1,294,196             111,572          7.9% Transportation 4,509,066             1,429,170             4,615,160             1,428,601             4,562,797             1,429,100             1,512,690             (83,590)            ‐5.8% Debt Service 4,822,566             390,380                  9,752,337             842,026                  8,001,433             835,676                  835,676                  ‐                      0.0% Non‐Departmental and Other 4,930,383             2,214,722             4,637,555             1,176,929             4,141,350             1,221,630             1,221,630             ‐                      0.0% Total  Operating Expenditures 100,825,999       30,363,594          103,938,882       31,242,984          103,926,454       32,025,206          31,631,530          393,677          1.2% Total  Ending Fund Balance 11,057,551$       11,106,230$       15,575,840$       11,994,612$       12,498,570$       14,772,362$       17,503,371$       2,731,009$   18.5% Favorable (Unfavorable) 2011 2012 2013 Variance Annual Actual YTD Actual Annual  Budget YTD Budget YTD ActualSummary of Sources and Uses Annual  Actual YTD Actual   Monthly Financial Report April 2013 Page 1 of 37 Monthly Financial Report April 2013      OVERVIEW  This financial overview reflects the City’s overall financial position for the fiscal year through April 30, 2013.  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 year.  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 77% of  all resources supporting general governmental activities.   The following section provides detail information on property,  sales, utility, and other taxes.    Property Tax  April’s collection is $9.9 million, making  the total year‐to‐date collection $11  million or 34.6% of the total budget.  In  comparison to the previous year, the City  collected $142k or 1% less.  Compared to  the budget, the City is above projections  by $1.3 million or 14%.  2013’s monthly  budgets are based on 2010 through 2012  collections.  The variance from the  budget is due the timing of collections.   The City has collected $5.8 million in  May.  If we combine April and May, the  City is right on target with budget  projections.        Sales Tax  April 2013 sales tax receipts totalled $1.5  million.  Compared with the same month last  year, it is $139k or 10% more.  Compared to  the projected current month’s budget, it is  $76k or 5% above.  The year‐to‐date  collection of $6.6 million is $704k or 12%  more than the prior year and is also $452k or  7% more than budgeted.  The City is  projecting sales tax revenues to meet the  budget at year‐end.      2012 2013 2013 Actual Budget Actual $ % $ % Jan 149,112$         218,452$         154,945$         5,834$            4% (63,506)$        ‐29% Feb 85,577               238,602            25,020               (60,557)            ‐71% (213,582)        ‐90% Mar 880,380            747,935            917,901            37,521            4% 169,966         23% Apr 10,012,008     8,452,665        9,887,324       (124,683)         ‐1% 1,434,659    17% May 6,131,450        6,807,499         Jun 43,203               69,561                Jul 446,717            218,293             Aug (51,143)              13,620                Sep 545,753            415,826             Oct 9,734,384        7,408,344         Nov 5,123,725        6,825,452         Dec 365,200            325,116             YTD  Total 11,127,076$  9,657,654$     10,985,190$ (141,886)$      ‐1% 1,327,536$ 14% Annual Total 33,466,364$  31,741,366$   Property Tax Revenues Year to Date through April 2013 vs. 2012 2013 vs. Budget Month 2012 2013 2013 Actual Budget Actual $ % $ % Jan 1,327,548$     1,426,729$     1,620,555$     293,007$   22% 193,826$  14% Feb 1,923,714        1,924,871        1,962,886        39,173         2% 38,015        2% Mar 1,303,820        1,392,437        1,536,397        232,577      18% 143,960     10% Apr 1,370,731        1,433,794        1,509,953        139,222      10% 76,159        5% May 1,599,184        1,625,701         ‐                         Jun 1,482,794        1,471,334         ‐                         Jul 1,505,142        1,462,124         ‐                         Aug 1,583,903        1,588,018         ‐                         Sep 1,472,566        1,508,206         ‐                         Oct 1,660,941        1,588,803         ‐                         Nov 1,709,049        1,622,090         ‐                         Dec 1,625,280        1,559,893         ‐                         YTD  Total 5,925,812$     6,177,830$     6,629,791$     703,978$   12% 451,960$  7% Annual Total 18,564,670$  18,604,000$   2013 vs. Budget2013 vs. 2012 Month Year to Date through April Local Retail Sales  Tax  Revenues Page 2 of 37 Monthly Financial Report April 2013      The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business  sectors:  Sales  Tax by Sector 2012 2013 Bgt YTD  Act Change  2013/2012 2013 Act  vs  Bgt New Construction 514,243$         582,276$         948,361$         434,118$       84%$        366,086 63% Auto  Sales 1,054,395        1,060,593        1,144,982        90,587             9%              84,389 8% General Retail 2,188,496        2,221,696        2,218,143        29,647             1%               (3,553) 0% Manufacturing 336,085            396,764            397,899            61,814             18%                 1,135 0% Wholesale 370,201            381,122            359,591            (10,610)            ‐3%            (21,531)‐6% Service 1,352,548        1,401,178        1,370,580        18,033             1%            (30,598)‐2% Other 109,845            134,201            190,234            80,389             73%              56,032 42% Total 5,925,812$     6,177,830$     6,629,791$     703,978$       12%451,960$        7% Note: Excludes  Annexation Credit and Criminal Justice Sales  Tax revenue.        Utility tax   April utility tax revenues are $1.5 million,  which is $161k or 12% higher than the same  month last year and is also ahead of the  budget by $133k or 9%.  The year‐to‐date  collection is $5.5 million, which is $326k or  6% lower than the prior year and is also  $394k or 7% lower than the budget. The  City is projecting utility tax revenues to be  under budget at year‐end.                The table below breaks out Utility Tax by source.  The Electrical/Natural Gas variance is due to warmer weather  year‐to‐date than the prior year.  Cell and Phone variances are due the timing of receipts compared to 2012 (which should  catch up at the end of the year).    Utility Tax by Type 2012 2013 Bgt YTD Act Change  2013/2012 2013 Act  vs  Bgt  Electrical 1,972,182$     2,069,403$     1,932,839$     (39,343)$         ‐2%$      (136,564)‐7% Natural Gas 1,066,327        1,026,124        910,234            (156,093)         ‐15%         (115,890)‐11% Cell 736,280            741,724            566,096            (170,185)         ‐23%         (175,629)‐24% Phone 308,743            292,254            251,827            (56,916)            ‐18%            (40,427)‐14% Cable 435,101            451,600            459,812            24,711             6%                 8,213 2% Transfer Station 87,625               79,513               131,525            43,900             50%              52,012 65% City Utilities 1,198,213        1,211,666        1,226,148        27,935             2%              14,483 1% YTD  Total 5,804,472$     5,872,284$     5,478,482$     (325,990)$     ‐6%(393,803)$       ‐7% Annual Total 15,954,432$  16,250,662$   YTD  as % of 36% 36%      2012 2013 2013 Actual Budget Actual $ % $ % Jan 1,469,178$     1,494,708$      1,277,860$     (191,318)$  ‐13% (216,848)$  ‐15% Feb 1,512,539        1,497,446         1,462,236        (50,302)        ‐3% (35,210)        ‐2% Mar 1,438,515        1,467,773         1,193,129        (245,387)     ‐17% (274,644)     ‐19% Apr 1,384,240        1,412,358         1,545,257        161,017      12% 132,899      9% May 1,394,109        1,423,158          Jun 1,108,588        1,140,870          Jul 1,340,939        1,370,103          Aug 1,153,724        1,180,346          Sep 1,301,158        1,332,309          Oct 1,126,772        1,153,538          Nov 1,196,932        1,213,641          Dec 1,527,740        1,564,412          YTD  Total 5,804,472$     5,872,284$      5,478,482$     (325,990)$  ‐6% (393,803)$  ‐7% Annual  Total 15,954,432$  16,250,662$    2013 vs. Budget2013 vs. 2012 Year to Date through April Utility Tax Revenues Month Page 3 of 37 Monthly Financial Report April 2013      Other Taxes     Real Estate Excise Tax  The City collected $198k in Real Estate Excise  Tax revenues (REET) for April.  This is $3k or 1%  ahead of the same month last year but is $16k  or 8% lower than the current month’s budget.   The year‐to‐date collection is $822k, which is  $132k or 19% more than the prior year and is  also $41k or 5% above the budget.  The City is  projecting REET to meet the budget at  year‐end.                Gambling Tax  April’s Gambling Tax collections totalled  $160k, which is $3k or 2% above the  same month last year and is also $12k or  8% above the current month’s budget.   The year‐to‐date total of $478k is $96k  or 17% below the year before and is also  $65k or 12% below budget.  The decline  in revenue is mainly due to payment  plans with two (2) establishments that  will be paid in full by year‐end.  The City  is also seeing a decline in overall activity.    Pull tabs overall had a 10% decrease,  bingo decreased by 11%, and card‐rooms  are seeing 19% lower in activities when  compared to the prior year.        Franchise Fees  Franchise Fees are due quarterly and the  year‐to‐date revenue collections are  $627k or 50% of the budget.  This is $27k  or 5% higher than the prior year and is  also $28k or 5% above the projected  year‐to‐date budget.  The City is  projecting franchise fees to be very close  to the budget at year‐end.   2012 2013 2013 Actual Budget Actual $ % $ % Jan 77,631$         95,818$         134,099$      56,468$      73% 38,281$      40% Feb 214,137         243,603         262,229         48,092         22% 18,627         8% Mar 203,583         227,510         228,077         24,494         12% 568                 0% Apr 194,868         213,798         197,659         2,791            1% (16,140)         ‐8% May 253,446         249,828          Jun 347,179         342,222          Jul 177,839         175,300          Aug 222,933         219,750          Sep 173,212         170,739          Oct 326,027         288,609          Nov 370,123         235,620          Dec 250,922         137,204          YTD  Total 690,220$      780,729$      822,064$      131,844$   19% 41,335$      5% Annual  Total 2,811,902$  2,600,000$   Month 2013 vs. Budget2013 vs. 2012 Real Estate  Excise  Tax  Revenues Year  to Date through April 2012 2013 2013 Actual Budget Actual $ % $ % Jan 175,959$      166,470$      133,504$      (42,455)$      ‐24% (32,965)$      ‐20% Feb 143,837         136,080         73,730            (70,107)         ‐49% (62,350)         ‐46% Mar 98,279            92,979            111,294         13,014         13% 18,315         20% Apr 156,498         148,058         159,655         3,158            2% 11,598         8% May 101,088         95,636             ‐                      Jun 127,372         120,502          ‐                      Jul 161,244         152,548         ‐                      Aug 146,526         138,623         ‐                      Sep 162,540         153,774         ‐                      Oct 87,494            82,776            ‐                      Nov 177,352         167,787         ‐                      Dec 153,019         144,767         ‐                      YTD  Total 574,574$      543,586$      478,183$      (96,390)$     ‐17% (65,403)$     ‐12% Annual Total 1,691,209$  1,600,000$   2013 vs. 2012 2013 vs. Budget Gambling Tax  Revenue Month Year to Date through April 2012 2013 2013 Actual Budget Actual $ % $ % Jan 300,392$      299,872$      314,269$      13,877$      5% 14,397$      5% Feb ‐                     ‐                     200                    200                 100% 200                 100% Mar ‐                     ‐                     892                    892                 100% 892                 100% Apr 299,534         299,015         311,986         12,452         4% 12,971         4% Jul 305,065         304,536         ‐                      Oct 309,001         308,466         ‐                      Dec 48,195            48,111            ‐                      YTD  Total 599,927$      598,887$      627,348$      27,421$      5% 28,461$      5% Annual Total 1,262,188$  1,260,000$   Franchise Fees  Revenue Year to Date through April Month 2013 vs. 2012 2013 vs. Budget Page 4 of 37 Monthly Financial Report April 2013      Admission Tax   Admission Tax returns are due quarterly  in January, April, July, and October of  each year.  April 2013 collections  represent activities conducted during the  1st quarter of 2013.  The year‐to‐date  collection of $153k is $1k or 1% less than  the prior year but is right on target with  the budget.  The City is projecting  admission tax revenues 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 $367k in April.  The  year‐to‐date development fees revenue of  $1.2 million is $384k or 45% more than the  year before and is also $422k or 52% higher  than budget.  The higher than expected fees  are due to collecting more in general building  permits, electrical permits, and plan check  fees.  The City is projecting building permits  and development service fees to meet the  budget at year‐end.              Business Licenses  Business Licenses totalled $103k for April, which is  $14k or 15% above the same month last year but is  $4k or 4% below the current month’s budget.  The  year‐to‐date Business Licenses revenue of $251k is  $44k or 21% above the prior year and is also $3k or  1% higher than the budget.  The City is projecting  business licenses to be very close with the budget at  year‐end.      2012 2013 2013 Actual Budget Actual $ % $ % Jan 73,420$         72,699$         82,440$         9,020$         12% 9,741$         13% Feb 934                    925                    ‐                      Apr 80,352            79,563            70,311            (10,041)        ‐12% (9,252)           ‐12% Jul 81,104            80,307            ‐                      Oct 74,001            73,275            ‐                      Dec 1,244               1,232               ‐                      YTD  Total 154,705$      153,186$      152,751$      (1,020)$        ‐1% 489$              0% Annual Total 311,054$      308,000$       Month 2013 vs. 2012 2013 vs. Budget Admission Tax Revenue Year to Date through April 2012 2013 2013 Actual Budget Actual $ % $ % Jan 154,777$      149,263$      327,644$      172,867$   112% 178,381$   120% Feb 185,509         181,341         230,104         44,595         24% 48,763         27% Mar 253,914         236,021         305,160         51,246         20% 69,139         29% Apr 252,351         241,884         367,285         114,934      46% 125,401      52% May 277,438         235,755          Jun 284,208         244,103          Jul 294,286         277,438          Aug 360,657         345,432          Sep 189,832         169,797          Oct 400,995         382,373          Nov 271,519         260,912          Dec 406,375         399,094          YTD  Total 846,552$      808,509$      1,230,194$  383,642$   45% 421,684$   52% Annual Total 3,331,862$  3,123,413$   Building Permits and Development Service  Fees Year  to Date through April 2013 vs. Budget2013 vs. 2012 Month 2012 2013 2013 Actual Budget Actual $ % $ % Jan 88,676$     106,302$  95,381$     6,705$      8% (10,921)$   ‐10% Feb 24,251        29,071        40,658        16,407      68% 11,587      40% Mar 4,927           5,906           12,441        7,515         153% 6,535         111% Apr 89,003        106,694     102,648     13,644      15% (4,047)        ‐4% May 2,645           3,171           ‐                  Jun 3,377           4,048           ‐                  Jul 98,553        118,142     ‐                  Aug 14,550        17,442        ‐                  Sep 3,197           3,833           ‐                  Oct 99,644        119,450     ‐                  Nov 12,484        14,965        ‐                  Dec 3,372           4,042           ‐                  YTD  Total 206,858$  247,974$  251,128$  44,270$   21% 3,154$      1% Annual Total 444,680$  533,067$   Business Licenses Month 2013 vs. 2012 Year to Date through April 2013 vs. Budget Page 5 of 37 Monthly Financial Report April 2013      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 76%  of the total revenues in this  category.   The year‐to‐date  total Intergovernmental revenue is $2.7 million or 24% of the budget.      State Shared Revenues  State Shared Revenue collections  totalled $1.5 million since the start of  the year.  Compared to the prior year,  State Shared Revenues are below by  $61k or 4%.  Compared to the  projected budget, the City is  collecting $305k or 26% more.  The  higher than expected (but lower than  prior year) collection is due to  collecting more than anticipated  Criminal Justice Sales Tax, the low  budget of Criminal Justice’s High Crime and the higher than expected collections for Liquor Profits.  The reason for the  decline in Liquor Excise Tax is also due to the passage of Initiative 1183.  Starting October 2012, the State will divert all  Liquor Excise Taxes that would normally be distributed to local governments to their State General Fund for one year.  The  City will not receive these excise taxes in January 2013, April 2013 and July 2013.  On the October 2013 distribution and on,  local governments will start receiving their portions of the excise taxes less a $10 million (per year) transfer from the State  Liquor Excise Tax Fund to the State General Fund.      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 62% of the total revenue in this category.  The year‐to‐date total charges for services are $2.5 million or 36% of  the budget.  This is 10% above budget projections.  The following sections provide detail information for Public Safety,  Recreation, and Interfund Services.       Intergovernmental 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt  Fire  District #25 646,907$         538,842$         538,842$         (108,065)$      ‐17% $                          ‐ 0% Fire  District #40 152,200            16,707               16,707               (135,494)         ‐89%‐                            0% State  Shared Revenue 1,515,902        1,149,920        1,454,615        (61,287)            ‐4% 304,695          26% Federal Grants 85,002               509,586            509,586            424,584          499% (0)                         0% State  Grants 40,908               10,373               10,373               (30,535)            ‐75% (0)                         0% Other Grants/Intgovt 51,342               11,079               11,079               (40,262)            ‐78% (0)                         0% ARRA Grants ‐                              114,792            114,792            114,792          100%‐                            0% Total Rev YTD 2,492,260$     2,351,298$     2,655,993$     163,733$       7%304,695$        13% Total Rev Annual 12,673,276$  10,976,031$   YTD  % 20% 21% 24% Note:  Includes  CJ Sales  Tax  and FD25  & FD40  contracts 2012 2013 2013 Actual Budget Actual $ % $ % Crim Just Sales  Tax 606,636$          609,167$      668,470$        61,833$      10% 59,302$      10% Judicial Contribution 5,658                   5,625               5,699                 41                    1% 74                    1% Crim Just ‐ High Crime 93,724                ‐                     102,994           9,270            10% 102,994      100% Crim Just ‐ Pop 10,194                ‐                     10,797              603                 6% 10,797         100% Crim Just ‐ Spec Prog 38,473                43,906            40,452              1,979            5% (3,454)            ‐8% State DUI 8,895                   9,204               8,515                 (381)                ‐4% (689)                ‐7% Liquor Profits 123,076             84,809            211,723           88,646         72% 126,913      150% Liquor Excise  Tax 229,464             ‐                     ‐                       (229,464)     0%‐                  N/A Fuel Tax 399,781             397,208         405,966           6,185            2% 8,758            2% YTD  Total 1,515,902$     1,149,920$  1,454,615$   (61,287)$     ‐4% 304,695$   26% Annual  Total 4,825,202$     4,208,000$   2013 vs. Budget State  Shared Revenues 2013 vs. 2012 Revenue Year to Date through April Page 6 of 37 Monthly Financial Report April 2013      Public Safety Services  Public Safety Services totalled $396k 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 $242k or 157% more.  The City is  right on target with the year‐to‐date budget.   The City is projecting public safety services  revenues to meet the budget at year‐end.  The  reason for the large favourable variance with  the prior year is due to a different way of  accounting for intergovernmental services.   Prior to 2013, the City accounted for these  services as general intergovernmental.  Due to the 2013 Budgeting, Accounting, and Reporting System (BARS) Restructuring  Project, the State does not recognize intergovernmental charges for services as separate from charges for services.  Of the  $396k receipted for Public Safety Services, $239k is for intergovernmental.        Recreation  Recreation revenues totalled $171k for the  current month.  Compared to the same month  the prior year, the City collected $33k or 24%  more.  Compared to the projected monthly  budget, the City collected $22k or 15% more.   The primary reason that recreation fees are  lower is due to the new cost recovery policy  approved by council this year which reduces or  eliminates those programs that do not meet  recovery objectives.  This revenue reduction  translates into a savings of $64k in the  Recreation Division of the Community Services  Department.        Interfund Services  The year‐to‐date collections for Interfund  Services revenues are $1.2 million.  Compared  to the prior year, the revenues are over by  $169k or 17%.  Compared to the projected  budget, the revenues are above by $60k or 5%.   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.      2012 2013 2013 Actual Budget Actual $ % $ % Jan 15,229$         32,322$          32,322$         17,093$     112%‐$                     0% Feb 34,848            262,321          262,321         227,473     653%‐                  0% Mar 35,353            37,079             37,079            1,726           5%‐                  0% Apr 68,426            64,009             64,009            (4,418)           ‐6%‐                  0% May 42,979            35,599              ‐                      Jun 31,486            26,080              ‐                      Jul 54,883            45,459             ‐                      Aug 34,742            28,777             ‐                      Sep 36,019            29,834             ‐                      Oct 37,300            30,895             ‐                      Nov 33,025            27,354             ‐                      Dec 61,608            51,030             ‐                      YTD  Total 153,856$      395,731$       395,731$      241,875$  157%‐$                     0% Annual Total 485,899$      670,759$        Month 2013 vs. 2012 Year to Date through April Public Safety Services 2013 vs. Budget 2012 2013 2013 Actual Budget Actual $ % $ % Jan 62,072$         67,237$         60,546$         (1,526)$         ‐2% (6,690)$         ‐10% Feb 59,327            64,264            51,160            (8,167)            ‐14% (13,104)         ‐20% Mar 104,775         113,492         79,491            (25,283)         ‐24% (34,001)         ‐30% Apr 137,257         148,678         170,541         33,284         24% 21,863         15% May 139,013         150,580          ‐                      Jun 149,137         161,546         ‐                      Jul 260,363         282,026         ‐                      Aug 262,038         283,841         ‐                      Sep 107,879         116,855         ‐                      Oct 85,973            93,126            ‐                      Nov 65,863            71,343            ‐                      Dec 60,467            65,498            ‐                      YTD  Total 363,431$      393,670$      361,738$      (1 ,693)$        0% (31,932)$     ‐8% Annual Total 1,494,165$  1,618,486$   Recreation Year to Date through April 2013 vs. Budget2013 vs. 2012 Month 2012 2013 2013 Actual Budget Actual $ % $ % Jan 237,384$      276,153$      265,873$      28,489$      12% (10,279)$      ‐4% Feb 234,758         276,153         292,362         57,604         25% 16,209         6% Mar 271,071         276,153         317,998         46,927         17% 41,846         15% Apr 253,070         276,153         288,610         35,541         14% 12,458         5% May 291,941         276,153          ‐                      Jun 275,112         276,153         ‐                      Jul 217,828         276,153         ‐                      Aug 345,690         276,153         ‐                      Sep 273,570         276,153         ‐                      Oct 338,304         276,153         ‐                      Nov 276,902         276,153         ‐                      Dec 296,085         276,153         ‐                      YTD  Total 996,283$      1,104,610$  1,164,844$  168,561$   17% 60,234$      5% Annual Total 3,311,715$  3,313,830$   Interfund Services Year to Date through April 2013 vs. 2012 2013 vs. Budget Month Page 7 of 37 Monthly Financial Report April 2013      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 on  the following page breaks down these fines  by type.  The year‐to‐date total fines and  penalties is $994k.  This is $46k or 5% higher  than a year ago and is also $53k or 6% above  the budget.  The City is projecting fines and  penalties to meet the budget at year‐end.            Year to Date through April 2012 2013 2013 Actual Budget Actual $ % $ % Civil Penalties 2,601$            4,336$            2,225$            (376)$             ‐14% (2,111)$         ‐49% Civil Infraction Penalties 168,641         164,043         170,199         1,558            1% 6,156            4% Civil Parking Infraction Penalties 36,878            41,727            46,835            9,957            27% 5,108            12% Photo Enforcement Program 654,101         645,428         680,026         25,925         4% 34,598         5% Criminal Traffic  Misdemeanor Fines 24,889            28,699            29,001            4,112            17% 302                 1% Criminal Non‐Traffic  Fines 7,013               12,812            7,877               864                 12% (4,935)            ‐39% Criminal Costs 35,520            33,495            38,040            2,520            7% 4,546            14% Seizure Funds ‐ Federal/State/Local1 17,904            ‐                   ‐                   (17,904)      0%‐                  N/A Non‐Court Fines, Forfeitures and Penalties 333                    9,657               19,484            19,151         5760% 9,827            102% YTD  Total 947,879$      940,197$      993,688$      45,809$      5% 53,491$      6% Annual Total 3,060,389$  3,058,500$   1Seizure Funds  are categorized in Miscellaneous for 2013 and on. Revenue 2013 vs. Budget Fines  and Penalties by Type 2013 vs. 2012       Included in the Fines and Penalties revenue budget is $2  million from the Photo Enforcement program.  The  budget was based on the prior year’s revenue.  The year‐ to‐date collections from this program equates to $680k.   The budget shortfall is due to a change in receipting  operations that resulted in a 1‐month lag for defendant  paid infractions.  December’s receipts will recognize 2  month’s worth of defendant paid infractions.    The associated costs includes the equipment provided by  American Traffic Solutions, Inc. (ATS), dedicated 2 FTEs 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 90% pro  tem budget and interpreter costs amounts to $362k for  personnel costs.  The total costs for the program equates to $842k which is represented in the table.     2012 2013 2013 Actual Budget Actual $ % $ % Jan 183,478$      181,746$      153,064$      (30,413)$      ‐17% (28,682)$      ‐16% Feb 241,050         231,901         247,166         6,116            3% 15,265         7% Mar 244,379         246,962         275,222         30,842         13% 28,259         11% Apr 278,972         279,587         318,235         39,264         14% 38,648         14% May 306,424         310,705          Jun 318,091         312,586          Jul 274,243         277,336          Aug 168,187         171,297          Sep 179,166         176,075          Oct 278,866         280,183          Nov 247,607         251,568          Dec 339,926         338,553          YTD  Total 947,879$      940,197$      993,688$      45,809$      5% 53,491$      6% Annual  Total 3,060,389$  3,058,500$   2013 vs. Budget2013 vs. 2012 Year  to Date through April Fines  and Penalties by Month Month Favorable Budget Actual Budget Actual (Unfavorable) 1 Jan 181,020$      150,459$      74,626$        60,422$      90,037$            Feb 145,300         158,685         74,412           60,116         98,568               Mar 142,933         152,959         74,226           60,184         92,775               Apr 176,175         217,923         71,127           60,187         157,736            May 212,766          ‐                     74,599            ‐                  ‐                        Jun 218,587         ‐                     74,570           ‐                  ‐                        Jul 186,121         ‐                     74,882           ‐                  ‐                        Aug 91,365            ‐                     74,285           ‐                  ‐                        Sep 71,743            ‐                     50,884           ‐                  ‐                        Oct 191,799         ‐                     65,641           ‐                  ‐                        Nov 153,910         ‐                     66,315           ‐                  ‐                        Dec 178,282         ‐                     66,397           ‐                  ‐                        YTD  To tal 645,428$      680,026$      294,390$     240,909$   439,117$         Annual Total 1,950,000$  841,964$      1 Actuals  of Revenues and Expenses Revenues Expenses Photo Enforcement Program Year to Date through April Month Page 8 of 37 Monthly Financial Report April 2013      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 70% of the total  revenue in this category.  The year‐to‐date  total miscellaneous is $497k.  Compared to  last year, the revenues are over by $4k or 1%.   Compared to the projected year‐to‐date  budget, the revenues are under by $2k.  The  table below breaks out miscellaneous  revenues by type:    2012 2013 2013 Actual Budget Actual $ % $ % Interests and Other Earnings 29,924$         65,131$         29,926$         2$                    0% (35,205)$     ‐54% Rents, Leases, and Concessions 317,035         250,925         317,273         238                 0% 66,348         26% Contributions/Donations from  Private Sources 46,718            35,053            25,736            (20,982)        ‐45% (9,317)            ‐27% Other 98,880            62,087            120,495         21,614         22% 58,408         94% Seizure  Funds  ‐ Federal/State/Local1 ‐                   85,266          3,491             3,491          100% (81,775)         ‐96% YTD Total 492,558$      498,462$      496,921$      4,363$         1% (1,540)$        0% Annual  Total 1,630,922$  1,861,022$   1 Seizure Funds  are categorized in Miscellaneous for  2013 and on. 2013 vs. Budget Miscellaneous  Revenues  by Type Year to Date through April Revenue 2013 vs. 2012     Rents, leases and concessions are higher than the prior year and budget due to higher than expected food concession  payments at Coulon Park.    Contributions and donations from private sources are unfavourable due to the timing of donations.    Other miscellaneous revenues are higher than the prior year and budget due to higher than expected utility late payment  penalties and miscellaneous reimbursements for Fire.    Seizure funds are lower than the budget due to the timing of activity.      EXPENSES  Overall the City has expended 30% of its budgeted general governmental expenditures at the end of April.  This is $394k or  1.2% below year‐to‐date budgeted expenditures.  See below for summary of unfavourable items for general governmental  departments.    Council department is over the projected year‐to‐date budget by $2k or 1.8% due to overspending on salaries/benefits,  travel, training, meals and incidentals.  We will monitor these items to determine if a budget amendment is needed at year‐ end.    Executive department is over the projected year‐to‐date budget by $3k or 0.6% due to overspending on salaries/benefits  ($8k) and under spending on general professional services ($6k).    Fire department is over the year‐to‐date budget by $301k or 3.6%.  This is mainly due to overspending in salaries and  benefits ($99k), overtime ($85k), supplies ($140k), intergovernmental ($25k), and under spending on general professional  services ($31k).  We will monitor these items to determine if a budget amendment is needed at year‐end.     2012 2013 2013 Actual Budget Actual $ % $ % Jan 206,151$      163,044$      179,743$      (26,408)$     ‐13% 16,699$      10% Feb 83,823            132,653         76,397            (7,425)          ‐9% (56,256)         ‐42% Mar 104,421         88,693            147,909         43,488         42% 59,216         67% Apr 98,164            114,071         92,872            (5,291)          ‐5% (21,199)         ‐19% May 145,213         112,039          Jun 93,832            118,012          Jul 112,316         97,424             Aug 143,389         124,005          Sep 89,588            105,170          Oct 91,608            78,260             Nov 64,705            58,620             Dec 397,713         669,031          YTD  Total 492,558$      498,462$      496,921$      4,363$         1% (1,540)$        0% Annual Total 1,630,922$  1,861,022$   Year  to Date through April Month 2013 vs. Budget2013 vs. 2012 Miscellaneous Revenues  by Month Page 9 of 37 Monthly Financial Report April 2013      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 ‐                 ‐             ‐                 ‐               17,233         13,805       ‐               Grants  / intergovernmental 531,720          ‐             104,987          ‐               ‐               489,715     ‐               Charges  for services 36,073            415,156     5,104,641       4,877,355    3,021,544    3,039,804  4,860,772    Interdepartmental  services ‐                 ‐             ‐                 ‐               ‐               ‐             ‐               Fines  and penalties 1,262              ‐             ‐                 ‐               73                ‐             ‐               Rents, leases, and misc fees 754,993          72,896       25,358            44,048         ‐               ‐             ‐               Interest and other misc 2,845              651            5,405              69,767         168,532       45,363       1,705           TOTAL REVENUES 1,326,893       488,703     5,240,391       4,991,170    3,207,382    3,588,687  4,862,477    EXPENSES: Utility billing ‐                 ‐             38,247            34,784         27,131         43,215       ‐               Utility systems ‐                 ‐             4,237,469       1,041,538    937,349       817,649     ‐               Utility maintenance ‐                 ‐             94,117            1,549,371    422,947       688,475     4,759,496    Transportation 488,375          ‐             ‐                 ‐               ‐               ‐             ‐               Golf ‐                 555,963     ‐                 ‐               ‐               ‐             ‐               TOTAL EXPENSES 488,375          555,963     4,369,833       2,625,693    1,387,427    1,549,339  4,759,496    AMOUNT AVAILABLE FOR DEBT SERVICE 838,518          (67,260)      870,559          2,365,477    1,819,955    2,039,348  102,981       DEBT SERVICE: Principal ‐                  ‐             ‐                 ‐               ‐               ‐             ‐               Interest ‐                 ‐             ‐                 1,593           943              715            ‐               TOTAL DEBT SERVICE ‐                 ‐             ‐                 1,593           943              715            ‐               CAPITAL PROJECTS 191,398          6,840         ‐                 1,872,340    470,973       480,088     ‐               TRANSFERS IN/(OUT)‐                 ‐             ‐                 7,526           (3,763)          (3,763)        ‐               CHANGE IN FUND BALANCE 647,120          (74,100)      870,559          499,070       1,344,276    1,554,782  102,981       BEGINNING FUND BALANCE, Jan  1 2,342,924       539,814     1,523,881       9,846,308    3,196,734    6,014,474  1,745,887    ENDING FUND BALANCE, Apr 30 2,990,044       465,714     2,394,440       10,345,378  4,541,010    7,569,256  1,848,868        Page 10 of 37 Monthly Financial Report April 2013      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 ‐                 36,029          ‐             ‐                      ‐            ‐              ‐             Grants  / intergovernmental ‐                 ‐              ‐             ‐                      ‐            ‐              32,467        Charges  for services Equipment rental  m&o 902,582          1,017,908    ‐             ‐                      ‐            ‐              ‐             Print and mail ‐                 37,473         ‐             133,571             ‐            ‐              ‐             Communications ‐                 3,000           ‐             175,010             ‐            ‐              ‐             Facilities ‐                 ‐              1,426,239  ‐                      ‐            ‐              ‐             Data  cards  and cell  phones ‐                 46,809         ‐             ‐                      ‐            ‐              ‐             IT service co ntracts ‐                 146,244        ‐             ‐                      ‐            ‐              ‐             Interest and other misc 3,930              1,875           970            303                    4,254        8,127          6,343          Internal service fund misc: Vehicle  / equipment capital  recovery 471,486          56,657         ‐             ‐                      ‐            ‐              ‐             Insurance premiums ‐                 ‐              ‐             ‐                     530,648    ‐              ‐             Worker's  comp/unemployment ‐                 ‐              ‐             ‐                     498,959    ‐              ‐             Benefit premiums ‐                 ‐              ‐             ‐                      ‐            3,857,702   569,128      Other misc 134                 50                8,895         ‐                      ‐            33,269        ‐             Capital  contributions ‐                 ‐              ‐             ‐                      ‐            ‐              ‐             Disposal  of capital  assets 16,400            ‐              ‐             ‐                      ‐            ‐              ‐             Insurance recoveries 25,000            ‐              ‐             ‐                     38,758      5,651          ‐             TOTAL REVENUES 1,419,532       1,346,045    1,436,104  308,884             1,072,619 3,904,749   607,938      EXPENSES: Communications 163,265              Equipment rental 725,349           Facilities 1,176,985   Healthcare 3,707,909    Information technology 1,091,976     Print and mail 131,830              Retiree healthcare 368,242      Risk management Risk management 1,038,060  Unemployment 33,260       Worker's  compensation 454,042     TOTAL EXPENSES 725,349          1,091,976    1,176,985  295,095             1,525,362 3,707,909   368,242      AMOUNT AVAILABLE FOR CAPITAL 694,183          254,069       259,119     13,789               (452,743)   196,840      239,696      CAPITAL PROJECTS 190,099          181,300       70,488       ‐                      ‐            ‐              ‐             TRANSFERS IN ‐                 ‐              551            ‐                      ‐            ‐              ‐             TRANSFERS (OUT)‐                 ‐              ‐             ‐                      ‐            ‐              ‐             CHANGE IN FUND BALANCE 504,084          72,769         189,182     13,789               (452,743)   196,840      239,696      BEGINNING FUND BALANCE, Jan  1 3,722,501       1,856,972    849,472     303,477             4,986,807 7,899,070   6,482,165   ENDING FUND BALANCE, Apr 30 4,226,585       1,929,741    1,038,654  317,266             4,534,064 8,095,910   6,721,861      Page 11 of 37 Monthly Financial Report April 2013      FUND BALANCE  Page 13 shows the ending fund balance as of April 2013.  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 April, the City has $17.5 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 $1.9  million from the year’s beginning balance.  April’s ending fund balance is over the anticipated General Governmental Fund  Balance of $14.8 million by $2.7 million or 18.5%.  Although the ending fund balance is above projections, it is consistent  with the prior years’ trends since the City will receipt the first half of 2013 property taxes in April/May and second half in  October/November.       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 37 Monthly Financial Report April 2013      City  of Renton All Funds ‐ Revenue, Expenditures and Fund Balances Cash  Basis through April 30, 2013 Funds Balance  01/01/2013 Budgeted  Revenue Revenue  04/30/13 Total Funds  Available Budgeted  Expenditure Expenditure  04/30/13 Ending   Balance GENERAL GOVERNMENT FUNDS:15,575,839       100,849,185   33,559,062     49,134,901          103,926,454        31,631,530          17,503,371     000 General 10,575,369       71,979,735     25,006,741     35,582,110          75,128,756          24,703,328          10,878,782     001 Community Services 1,891,966         11,328,945     3,505,874       5,397,840            11,325,011          3,134,738            2,263,103       003 Street 1,585,553         8,877,257       2,732,487       4,318,040            8,857,691            2,806,886            1,511,154       004 Community Dev Block Grant (13,145)             367,512          86,254            73,109                 297,069               66,198                 6,912              005 Museum 52,369              209,903          52,498            104,867               211,080               69,807                 35,059            009 Farmers  Market 90,520              59,400            11,185            101,705               80,414                 9,267                   92,438            011 Fire Health & Wellness 55,483              25,000            12,905            68,388                 25,000                 5,630                   62,758            031 Park  Memorial 178,367            ‐                      170                 178,537               ‐                          ‐                           178,537          201 Ltd  GO Bonds  Gen Govt Debt 829,784            1,749,305       438,234          1,268,018            1,749,305            ‐                           1,268,018       215 Gen Govt Misc  Debt Service 329,573            6,252,128       1,712,713       2,042,286            6,252,128            835,676               1,206,610       SPECIAL REVENUE FUNDS: 102 Arterial  Street 168,514            643,000          191,320          359,834               600,000               ‐                           359,834          108 Leased  City Properties 527,677            797,289          186,328          714,005               752,011               162,978               551,027          110 Hotel  Motel 111,256            245,000          114,047          225,303               291,000               45,785                 179,518          125 1% For Art 116,142            16,000            107                 116,249               50,000                 13,650                 102,599          127 Cable  Communication 257,372            85,674            66,627            323,999               85,674                 26,980                 297,019          135 Springbrook Wetlands  Bank 665,828            ‐                      634                 666,462               ‐                          ‐                           666,462          CAPITAL PROJECT  FUNDS (CIP): 303 Community Dev Mitigation 1,540,154         60,000            27,487            1,567,641            700,000               ‐                           1,567,641       304 Fire  Mitigation 797,417            25,000            31,867            829,284               250,000               ‐                           829,284          305 Transportation Mitigation 292,627            40,000            107,569          400,196               100,000               ‐                           400,196          316 Municipal  Facilities  CIP 3,474,517         4,191,506       574,761          4,049,278            7,557,385            257,370               3,791,908       317 Transportation CIP (391,159)           29,684,866     4,070,548       3,679,389            29,272,465          6,417,935            (2,738,546)      318 So Lake  WA Infrastructure  Proj 52,073              44,874            23                   52,096                 96,947                 55,187                 (3,091)             326 Housing Opportunity 84,359              ‐                      91                   84,450                 75,000                 ‐                           84,450            336 New Library Development 19,143,344       300,000          18,091            19,161,435          19,443,344          150,423               19,011,012     ENTERPRISE FUNDS: 402 Airport 331,939            1,264,418       793,048          1,124,987            1,432,346            488,375               636,612          403 Solid Waste  Utility 1,523,881         15,700,852     5,240,392       6,764,273            16,177,073          4,369,833            2,394,440       404 Golf  Course 291,978            2,453,669       488,459          780,437               2,476,366            575,185               205,252          422 Airport Capital 2,010,985         15,325,895     533,844          2,544,829            17,308,384          191,398               2,353,431       424 Golf Course  Capital 247,836            50,000            16,908            264,744               156,482               4,282                   260,462          INTERNAL SERVICE FUNDS: 501 Equipment Repair/Replacement 3,722,501         4,247,724       1,419,532       5,142,033            4,281,528            915,448               4,226,585       502 I nsurance 4,986,807         5,713,764       1,072,620       6,059,427            3,060,718            1,525,362            4,534,065       503 Information Services 1,856,972         4,188,823       1,346,046       3,203,018            5,326,336            1,273,276            1,929,742       504 Facilities 849,472            4,276,112       1,436,655       2,286,127            4,468,879            1,247,473            1,038,654       505 Communications 303,477            877,773          308,884          612,361               893,249               295,094               317,267          512 Insurance, Healthcare 7,899,070         9,329,364       3,904,748       11,803,818          10,904,461          3,707,909            8,095,909       522 Insurance, Leoff1 Retirees HC 6,482,165         1,735,684       607,938          7,090,103            1,737,782            368,242               6,721,861       FIDUCIARY FUNDS: 611 Firemen's  Pension 4,556,003         300,000          2,084              4,558,087            240,475               70,741                 4,487,346       Funds Balance  01/01/2013 Budgeted  Revenue Revenue  04/30/13 Total Funds  Available Budgeted  Expenditure Expenditure  04/30/13 Ending   Balance ENTERPRISE FUNDS: COMBINED  UTILITIES 20,803,403       57,376,403     16,657,241     37,460,644          60,603,334          13,156,131          24,304,513     405 Water Utility 5,449,029         13,402,096     4,042,569       9,491,598            11,034,019          2,656,054            6,835,544       406 Waste  Water Utility 1,363,629         6,758,645       2,700,932       4,064,561            5,505,490            1,392,133            2,672,428       407 Surface Water Utility 2,269,771         7,963,326       2,863,609       5,133,380            6,180,122            1,553,817            3,579,563       416 King  County Metro 1,745,887         15,126,703     4,862,477       6,608,364            15,126,703          4,759,496            1,848,868       425 Water Utility Construction 4,381,380         3,745,000       956,112          5,337,492            8,007,000            1,843,570            3,493,922       426 Waste  Water Construction 1,833,105         3,300,000       506,449          2,339,554            4,870,000            470,973               1,868,581       427 Surface Water Construction 3,744,703         7,080,633       725,078          4,469,781            9,880,000            480,088               3,989,693       471 Waterworks  Rate Stabilization 15,899              ‐                      15                   15,914                 ‐                          ‐                           15,914            Note:  Waterworks  Utility Funds  are managed  as a  system and are designated by the  dotted lines.  Page 13 of 37 City of Renton General Government Financial Position 2013 Budget Year General Government Summary  Revenues Expenditures  $ Difference over (under)  w/beginning  balance  15,575,839             January 5,592,172              7,563,322              (1,971,150)             13,604,689             February 11,590,564            15,996,818            (4,406,254)             11,169,585             March 17,392,180            23,413,342            (6,021,162)             9,554,677               April 33,559,062            31,631,530            1,927,532              17,503,371             May June July August September October November December (2 000 000) (1,000,000) ‐ 1,000,000  2,000,000  3,000,000  70,000,000  80,000,000  90,000,000  100,000,000  110,000,000  Change in Fund  Balance Rev/Exp Revenues Expenditures Change in Fund Balance (9,000,000) (8,000,000) (7,000,000) (6,000,000) (5,000,000) (4,000,000) (3,000,000) (2,000,000) ‐ 10,000,000  20,000,000  30,000,000  40,000,000  50,000,000  60,000,000  Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Page 14 of 37 City of Renton Monthly Revenue Analysis ‐ 2013 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 5,379,004        5,592,172        3.96% Feb 11,584,025      11,590,564      0.06% Mar 16,972,572      17,392,180      2.47% Apr 31,221,729      33,559,062      7.49% May 45,322,175       Jun 50,479,734       Jul 56,496,886       Aug 61,532,001       Sep 66,648,058       Oct 80,211,794       Nov 93,780,193       Dec 100,849,185     Percent of budget 33.28% YTD Annual %  $‐ $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  $110  Millions Total Revenue General Government Budget Actual Last Year $36 Millions Property Tax Property Tax Budget Actual over (under) Jan 218,452           154,945            ‐29.07% Feb 457,054           179,965            ‐60.62% Mar 1,204,989        1,097,866         ‐8.89% Apr 9,657,654        10,985,190      13.75% May 16,465,154       Jun 16,534,715       Jul 16,753,008       Aug 16,766,628       Sep 17,182,454       Oct 24,590,798       Nov 31,416,250       Dec 31,741,366       Percent of budget 34.61% $‐ $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  $33  $36  Budget Actual Last Year Page 15 of 37 City of Renton Monthly Revenue Analysis ‐ 2013 Budget Year Sales Tax Budget YTD Actual Annual %  over (under) Jan 1,585,548        1,812,385        14.31% Feb 3,729,667        4,006,705        7.43% Mar 5,270,744        5,725,296        8.62% Apr 6,860,537        7,413,785        8.06% May 8,668,156         Jun 10,307,140       Jul 11,940,419       Aug 13,708,668       Sep 15,384,395       Oct 17,162,223       Nov 18,978,733       Dec 20,723,680       Percent of budget 35.77% Note:  Excludes CJ Sales Tax and Natural Gas Use Tax. YTD Annual %  $‐ $3  $6  $9  $12  $15  $18  $21  Millions Sales Tax Budget Actual Last Year $16 Millions Utility Tax Utility Tax Budget Actual over (under) Jan 1,494,708        1,277,860         ‐14.51% Feb 2,992,154        2,740,096         ‐8.42% Mar 4,459,927        3,933,225         ‐11.81% Apr 5,872,284        5,478,482         ‐6.71% May 7,295,443         Jun 8,436,312         Jul 9,806,416         Aug 10,986,762       Sep 12,319,071       Oct 13,472,609       Nov 14,686,250       Dec 16,250,662       Percent of budget 33.71% Note:  Includes Natural Gas Use Tax. $0  $2  $4  $6  $8  $10  $12  $14  $16  Budget Actual Last Year Page 16 of 37 City of Renton Monthly Revenue Analysis ‐ 2013 Budget Year Licenses &  Permits Budget YTD Actual Annual %  over (under) Jan 219,087           325,005           48.34% Feb 384,853           547,949           42.38% Mar 574,699           747,996           30.15% Apr 853,049           1,091,568        27.96% May 1,034,613         Jun 1,227,006         Jul 1,538,622         Aug 1,830,518         Sep 1,987,449         Oct 2,371,160         Nov 2,574,250         Dec 2,863,828         Percent of budget 38.12% Note:  Franchise Fees YTD Annual % Millions Intergovernmental $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  Millions Licenses & Permits Budget Actual Last Year Intergovt'l Budget Actual over (under) Jan 479,441           565,532           17.96% Feb 1,232,413        1,321,568        7.23% Mar 1,542,672        1,771,733        14.85% Apr 2,351,298        2,639,287        12.25% May 4,698,073         Jun 5,357,241         Jul 5,818,948         Aug 6,261,474         Sep 6,730,164         Oct 7,929,977         Nov 10,311,640       Dec 10,976,031       Percent of budget 24.20% Note:  Includes CJ Sales Tax and FD25 & FD40 contracts $‐ $1  $2  $3  $4  $5  $6  $7  $8  $9  $10  $11  $12  $13  Millions Budget Actual Last Year Page 17 of 37 City of Renton Monthly Revenue Analysis ‐ 2013 Budget Year Charges for  Services Budget YTD Actual Annual %  over (under) Jan 427,908           485,115           13.37% Feb 1,115,373        1,196,439        7.27% Mar 1,634,485        1,798,689        10.05% Apr 2,236,225        2,483,560        11.06% May 2,791,445         Jun 3,343,994         Jul 4,068,527         Aug 4,760,972         Sep 5,235,553         Oct 5,785,676         Nov 6,272,756         Dec 6,811,096         Percent of budget 36.22% Note: Excludes FD25 & FD40 contracts Fines & YTD Annual %  $‐ $1  $2  $3  $4  $5  $6  $7  Millions Charges for Services Budget Actual Last Year Millions Fines & Forfeits Forfeits Budget Actual over (under) Jan 181,746           153,064            ‐15.78% Feb 413,648           400,231            ‐3.24% Mar 660,610           675,452           2.25% Apr 940,197           993,688           5.69% May 1,250,902         Jun 1,563,488         Jul 1,840,824         Aug 2,012,121         Sep 2,188,195         Oct 2,468,378         Nov 2,719,947         Dec 3,058,500         Percent of budget 32.49% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  Budget Actual Last Year Page 18 of 37 City of Renton Monthly Revenue Analysis ‐ 2013 Budget Year Other Taxes Budget YTD Actual Annual %  over (under) Jan 609,070           638,523           4.84% Feb 963,161           934,497            ‐2.98% Mar 1,239,788        1,230,900         ‐0.72% Apr 1,951,594        1,963,238        0.60% May 2,500,859         Jun 2,974,287         Jul 3,897,103         Aug 4,247,808         Sep 4,557,833         Oct 5,289,676         Nov 5,584,037         Dec 6,313,000         Percent of budget 31.10% YTD Annual % Millions Miscellaneous $0  $1  $2  $3  $4  $5  $6  $7  Millions Other Taxes Budget Actual Last Year Misc Budget Actual over (under) Jan 163,044           179,743           10.24% Feb 295,698           256,140            ‐13.38% Mar 384,390           404,049           5.11% Apr 498,462           496,921            ‐0.31% May 610,500            Jun 728,512            Jul 825,936            Aug 949,941            Sep 1,055,111         Oct 1,133,371         Nov 1,191,991         Dec 1,861,022         Percent of budget 26.70% $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80 Budget Actual Last Year Page 19 of 37 City of Renton Monthly Revenue Analysis ‐ 2013 Budget Year Other  Financing Budget YTD Actual Annual %  over (under) Jan ‐                          ‐                         N/A Feb 5                        6,974                139374.80% Mar 268                   6,974                2502.14% Apr 430                   13,343              3003.03% May 7,030                 Jun 7,040                 Jul 7,083                 Aug 7,110                 Sep 7,833                 Oct 7,925                 Nov 44,338               Dec 250,000            Percent of budget 5.34% $‐ $1.00  $2.00  $3.00  $4.00  $5.00  $6.00  Millions Other Financing Sources Budget Actual Last Year Page 20 of 37 City of Renton Monthly Revenue Analysis ‐ 2013 Budget Year REET Budget YTD Actual Annual %  over (under) Jan 71,786              134,099           86.80% Feb 269,776           396,328           46.91% Mar 458,016           624,405           36.33% Apr 638,196           822,064           28.81% May 872,560            Jun 1,193,556         Jul 1,358,006         Aug 1,564,134         Sep 1,724,294         Oct 2,025,764         Nov 2,367,976         Dec 2,600,000         Percent of budget 31.62% Bldg Permits &  Devlpmt Svc YTD Annual %  $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  Millions Real Estate Excise Tax Budget Actual Last Year Millions Building Permits and Development Service  Fees Budget Actual over (under) Jan 149,263           327,644           119.51% Feb 330,604           557,749           68.71% Mar 566,625           862,909           52.29% Apr 808,509           1,230,194        52.16% May 1,044,264         Jun 1,288,368         Jul 1,565,806         Aug 1,911,238         Sep 2,081,035         Oct 2,463,407         Nov 2,724,319         Dec 3,123,413         Percent of budget 39.39% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  Millions g p Fees Budget Actual Last Year Page 21 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 7,444,301        7,563,322        1.60% Feb 16,221,403      15,996,818       ‐1.38% Mar 23,711,420      23,413,342       ‐1.26% Apr 32,025,206      31,631,530       ‐1.23% May 42,771,594       Jun 51,096,575       Jul 60,165,457       Aug 68,874,788       Sep 77,517,469       Oct 86,043,550       Nov 94,525,882       Dec 103,926,454     Percent of budget expended 30.44% YTD Annual %  $‐ $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  $110  Millions Total Expenditures General Government Budget Actual Last Year $300 000 Legislative Legislative Budget Actual over (under) Jan 23,231              23,354              0.53% Feb 47,551              47,686              0.28% Mar 71,956              72,806              1.18% Apr 95,878              97,646              1.84% May 120,148            Jun 144,309            Jul 168,859            Aug 192,896            Sep 217,082            Oct 241,441            Nov 265,573            Dec 290,291            Percent of budget expended 33.64% $‐ $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  Budget Actual Last Year Page 22 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Executive Budget YTD Actual Annual %  over (under) Jan 84,700              78,944               ‐6.80% Feb 190,135           186,330            ‐2.00% Mar 296,151           297,118           0.33% Apr 407,614           419,061           2.81% May 516,918            Jun 623,960            Jul 735,658            Aug 847,425            Sep 953,811            Oct 1,064,489         Nov 1,170,013         Dec 1,322,364         Percent of budget expended 31.69% Hearing YTD Annual %  $‐ $0.30  $0.60  $0.90  $1.20  $1.50  Millions Executive Budget Actual Last Year $60 000 Hearing Examiner Examiner Budget Actual over (under) Jan 5,296                 ‐                         0.00% Feb 8,447                856                    ‐89.87% Mar 13,293              2,525                 ‐81.01% Apr 15,537              6,671                 ‐57.06% May 18,668               Jun 21,071               Jul 23,545               Aug 27,015               Sep 29,700               Oct 31,542               Nov 36,403               Dec 40,000               Percent of budget expended 16.68% $‐ $10,000  $20,000  $30,000  $40,000  $50,000  $60,000  Budget Actual Last Year Page 23 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year City Attorney Budget YTD Actual Annual %  over (under) Jan 155,027           141,744            ‐8.57% Feb 314,005           285,967            ‐8.93% Mar 472,262           427,953            ‐9.38% Apr 633,182           584,735            ‐7.65% May 787,132            Jun 947,880            Jul 1,105,337         Aug 1,263,381         Sep 1,421,095         Oct 1,593,003         Nov 1,749,576         Dec 1,915,103         Percent of budget expended 30.53% YTD Annual % $2 20 Millions Court Services $‐ $0.40  $0.80  $1.20  $1.60  $2.00  $2.40  Millions City Attorney Budget Actual Last Year Court Services Budget Actual over (under) Jan 161,056           152,280            ‐5.45% Feb 321,721           310,767            ‐3.40% Mar 485,078           468,698            ‐3.38% Apr 650,782           643,564            ‐1.11% May 824,039            Jun 1,016,165         Jul 1,185,948         Aug 1,354,731         Sep 1,519,505         Oct 1,684,389         Nov 1,852,716         Dec 2,026,149         Percent of budget expended 31.76% $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  $2.00  $2.20  Budget Actual Last Year Page 24 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year CED Admin Budget YTD Actual Annual %  over (under) Jan 85,577              85,287               ‐0.34% Feb 171,360           170,570            ‐0.46% Mar 257,144           256,405            ‐0.29% Apr 344,608           344,293            ‐0.09% May 428,940            Jun 513,272            Jul 597,689            Aug 682,197            Sep 766,581            Oct 850,349            Nov 934,318            Dec 1,020,208         Percent of budget expended 33.75% Development YTD Annual %  $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  Millions Community & Economic Development Admin Budget Actual Last Year Millions Development Services Services Budget Actual over (under) Jan 263,464           272,362           3.38% Feb 532,470           515,474            ‐3.19% Mar 801,048           768,135            ‐4.11% Apr 1,070,001        1,060,776         ‐0.86% May 1,359,141         Jun 1,620,563         Jul 1,901,116         Aug 2,169,138         Sep 2,450,976         Oct 2,739,546         Nov 3,020,135         Dec 3,308,299         Percent of budget expended 32.06% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  Millions Budget Actual Last Year Page 25 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Economic  Development Budget YTD Actual Annual %  over (under) Jan 54,655              75,717              38.54% Feb 109,521           81,391               ‐25.68% Mar 155,477           109,135            ‐29.81% Apr 198,321           146,523            ‐26.12% May 246,022            Jun 290,316            Jul 339,634            Aug 384,572            Sep 428,840            Oct 472,869            Nov 524,583            Dec 570,280            Percent of budget expended 25.69% YTD Annual %  $‐ $0.10  $0.20  $0.30  $0.40  $0.50  $0.60  Millions Economic Development Budget Actual Last Year Millions Planning Planning Budget Actual over (under) Jan 118,936           112,247            ‐5.62% Feb 265,596           237,260            ‐10.67% Mar 381,868           350,721            ‐8.16% Apr 509,685           480,129            ‐5.80% May 630,402            Jun 748,996            Jul 870,176            Aug 1,024,050         Sep 1,159,558         Oct 1,279,389         Nov 1,405,692         Dec 1,541,592         Percent of budget expended 31.15% $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  Millions Budget Actual Last Year Page 26 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Finance Budget YTD Actual Annual %  over (under) Jan 158,336           144,010            ‐9.05% Feb 323,142           284,066            ‐12.09% Mar 485,519           437,042            ‐9.98% Apr 646,871           610,911            ‐5.56% May 815,548            Jun 991,610            Jul 1,157,861         Aug 1,335,063         Sep 1,499,653         Oct 1,643,469         Nov 1,786,254         Dec 2,242,682         Percent of budget expended 27.24% YTD Annual % $1 20 Millions City Clerk $‐ $0.40  $0.80  $1.20  $1.60  $2.00  $2.40  Millions Finance Budget Actual Last Year City Clerk Budget Actual over (under) Jan 64,284              61,226               ‐4.76% Feb 132,790           122,708            ‐7.59% Mar 205,777           199,840            ‐2.89% Apr 343,675           270,581            ‐21.27% May 414,549            Jun 484,479            Jul 688,755            Aug 762,679            Sep 835,208            Oct 907,934            Nov 981,746            Dec 1,061,505         Percent of budget expended 25.49% $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  Budget Actual Last Year Page 27 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Human  Resources Budget YTD Actual Annual %  over (under) Jan 83,400              64,230               ‐22.99% Feb 161,123           134,784            ‐16.35% Mar 240,261           212,385            ‐11.60% Apr 311,770           288,203            ‐7.56% May 382,831            Jun 469,447            Jul 552,148            Aug 635,001            Sep 713,975            Oct 797,946            Nov 885,037            Dec 977,094            Percent of budget expended 29.50% YTD Annual %  $‐ $0.20  $0.40  $0.60  $0.80  $1.00  Millions Human Resources Budget Actual Last Year $30 Millions Police Police Budget Actual over (under) Jan 2,428,756        2,521,995        3.84% Feb 4,822,410        4,737,466         ‐1.76% Mar 7,237,703        7,196,803         ‐0.57% Apr 9,708,499        9,460,145         ‐2.56% May 12,213,787       Jun 14,514,940       Jul 17,110,436       Aug 19,351,851       Sep 21,759,242       Oct 24,136,681       Nov 26,544,437       Dec 29,126,701       Percent of budget expended 32.48% $‐ $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  Budget Actual Last Year Page 28 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Fire &  Emergency  Services Budget YTD Actual Annual %  over (under) Jan 1,888,720        2,045,002        8.27% Feb 4,532,143        4,729,656        4.36% Mar 6,445,515        6,673,347        3.53% Apr 8,335,243        8,636,731        3.62% May 10,507,156       Jun 12,415,229       Jul 14,332,466       Aug 16,378,589       Sep 18,352,651       Oct 20,268,263       Nov 22,198,986       Dec 24,188,120       Percent of budget expended 35.71% Community YTD Annual %  $‐ $3  $6  $9  $12  $15  $18  $21  $24  Millions Fire & Emergency Services Budget Actual Last Year $0 50 Millions Community Services Admin Services Admin Budget Actual over (under) Jan 38,606              37,025               ‐4.09% Feb 74,909              74,364               ‐0.73% Mar 111,787           111,667            ‐0.11% Apr 148,344           150,854           1.69% May 185,868            Jun 222,528            Jul 259,410            Aug 295,998            Sep 332,176            Oct 367,946            Nov 405,451            Dec 450,911            Percent of budget expended 33.46% $‐ $0.05  $0.10  $0.15  $0.20  $0.25  $0.30  $0.35  $0.40  $0.45  $0.50  Budget Actual Last Year Page 29 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Parks Budget YTD Actual Annual %  over (under) Jan 284,059           269,811            ‐5.02% Feb 571,759           563,088            ‐1.52% Mar 881,042           851,150            ‐3.39% Apr 1,213,451        1,192,965         ‐1.69% May 1,544,269         Jun 1,894,848         Jul 2,261,158         Aug 2,638,492         Sep 3,030,537         Oct 3,420,829         Nov 3,789,095         Dec 4,153,621         Percent of budget expended 28.72% Parks Planning  and Natural YTD Annual %  $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  Millions Parks Budget Actual Last Year $0 70 Millions Parks Planning and Natural Resources Resources Budget Actual over (under) Jan 47,101              42,639               ‐9.47% Feb 95,269              88,359               ‐7.25% Mar 156,534           142,461            ‐8.99% Apr 214,184           196,871            ‐8.08% May 286,142            Jun 355,723            Jul 415,823            Aug 476,926            Sep 545,276            Oct 620,182            Nov 690,040            Dec 755,638            Percent of budget expended 26.05% $‐ $0.10  $0.20  $0.30  $0.40  $0.50  $0.60  $0.70  Budget Actual Last Year Page 30 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Recreation Budget YTD Actual Annual %  over (under) Jan 343,076           305,989            ‐10.81% Feb 697,923           650,023            ‐6.86% Mar 1,060,652        1,002,907         ‐5.44% Apr 1,435,547        1,371,571         ‐4.46% May 1,810,378         Jun 2,195,700         Jul 2,787,526         Aug 3,446,454         Sep 3,960,958         Oct 4,343,623         Nov 4,714,526         Dec 5,130,300         Percent of budget expended 26.73% Human YTD Annual % $1 20 Millions Human Services $‐ $1  $2  $3  $4  $5  $6  Millions Recreation Budget Actual Last Year Services Budget Actual over (under) Jan 55,141              45,984               ‐16.61% Feb 122,303           128,054           4.70% Mar 217,326           218,002           0.31% Apr 381,767           340,261            ‐10.87% May 479,318            Jun 542,375            Jul 674,923            Aug 744,460            Sep 805,315            Oct 959,873            Nov 1,030,967         Dec 1,196,052         Percent of budget expended 28.45% $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  Budget Actual Last Year Page 31 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Neighborhoods , Resources,  and Events Budget YTD Actual Annual %  over (under) Jan 55,854              56,917              1.90% Feb 109,166           108,774            ‐0.36% Mar 172,916           171,351            ‐0.91% Apr 236,903           231,744            ‐2.18% May 298,441            Jun 378,699            Jul 470,110            Aug 555,842            Sep 632,165            Oct 703,188            Nov 803,370            Dec 914,955            Percent of budget expended 25.33% YTD Annual % $0 30 Millions Library Fund $‐ $0.10  $0.20  $0.30  $0.40  $0.50  $0.60  $0.70  $0.80  $0.90  $1.00  Millions Neighborhoods, Resources, and Events Budget Actual Last Year Library Fund Budget Actual over (under) Jan ‐                         ‐                         N/A Feb ‐                         ‐                         N/A Mar ‐                         ‐                         N/A Apr ‐                         ‐                         N/A May ‐                          Jun ‐                          Jul ‐                          Aug ‐                          Sep ‐                          Oct ‐                          Nov ‐                          Dec ‐                          Percent of budget expended N/A $‐ $0.05  $0.10  $0.15  $0.20  $0.25  $0.30  Budget Actual Last Year Page 32 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Museum Fund Budget YTD Actual Annual %  over (under) Jan 17,250              16,898               ‐2.04% Feb 34,747              34,090               ‐1.89% Mar 52,190              51,213               ‐1.87% Apr 69,816              69,807               ‐0.01% May 87,358               Jun 105,057            Jul 122,568            Aug 140,200            Sep 158,058            Oct 175,778            Nov 193,585            Dec 211,080            Percent of budget expended 33.07% Public Works YTD Annual % $500 000 Public Works Admin $‐ $30,000  $60,000  $90,000  $120,000  $150,000  $180,000  $210,000  $240,000  Museum Fund Budget Actual Last Year Admin Budget Actual over (under) Jan 40,394              39,971               ‐1.05% Feb 80,618              79,912               ‐0.88% Mar 120,971           119,866            ‐0.91% Apr 161,356           163,297           1.20% May 201,472            Jun 241,508            Jul 281,724            Aug 322,247            Sep 363,226            Oct 402,909            Nov 442,662            Dec 483,035            Percent of budget expended 33.81% $‐ $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  $350,000  $400,000  $450,000  $500,000  Budget Actual Last Year Page 33 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Street  Maintenance Budget YTD Actual Annual %  over (under) Jan 333,344           302,270            ‐9.32% Feb 713,983           641,518            ‐10.15% Mar 1,077,703        937,528            ‐13.01% Apr 1,405,768        1,294,196         ‐7.94% May 1,756,371         Jun 2,128,477         Jul 2,485,951         Aug 2,826,956         Sep 3,174,309         Oct 3,531,791         Nov 3,898,668         Dec 4,294,894         Percent of budget expended 30.13% YTD Annual %  $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00  Millions Street Maintenance Budget Actual Last Year $5 0 Millions Transportation Transportation Budget Actual over (under) Jan 298,525           311,908           4.48% Feb 675,318           670,659            ‐0.69% Mar 1,051,492        1,074,529        2.19% Apr 1,429,100        1,512,690        5.85% May 1,797,203         Jun 2,158,029         Jul 2,553,346         Aug 2,923,438         Sep 3,300,485         Oct 3,687,132         Nov 4,071,164         Dec 4,562,797         Percent of budget expended 33.15% $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0 $4.5 $5.0 Budget Actual Last Year Page 34 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Debt Service Budget YTD Actual Annual %  over (under) Jan ‐                          ‐                         N/A Feb 250,317           250,317           0.00% Mar 250,317           250,317           0.00% Apr 835,676           835,676           0.00% May 3,333,930         Jun 4,000,717         Jul 4,667,503         Aug 5,334,289         Sep 6,001,075         Oct 6,667,861         Nov 7,334,647         Dec 8,001,433         Percent of budget expended 10.44% Non‐ Departmental YTD Annual % $5 00 Millions Non‐Departmental Other City Services $‐ $1  $2  $3  $4  $5  $6  $7  $8  $9  $10  Millions Debt Service Budget Actual Last Year Other City Budget Actual over (under) Jan 355,512           355,512           0.00% Feb 862,677           862,677           0.00% Mar 1,009,438        1,009,438        0.00% Apr 1,221,630        1,221,630        0.00% May 1,725,563         Jun 2,070,675         Jul 2,415,788         Aug 2,760,900         Sep 3,106,013         Oct 3,451,125         Nov 3,796,238         Dec 4,141,350         Percent of budget expended 29.50% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00 Budget Actual Last Year Page 35 of 37 City of Renton Monthly Enterprise Fund Financial Report ‐ 2013 Budget Year Utilities Budget Revenue Expense Jan 3,829,376        5,451,016      3,091,235       Feb 8,589,616        10,484,839    7,162,971       Mar 13,047,174      16,704,949    12,742,494     Apr 17,968,338      21,897,618    17,525,965     May 22,562,679       Jun 29,148,341       Jul 35,053,685       Aug 40,236,656       Sep 45,248,315       Oct 51,131,985       Nov 56,094,010       Dec 76,780,407       Percent of budget expended 23.63% Note:  Operations and Capital $0 $10 $20 $30 $40 $50 $60 $70 $80 $90 Millions Utilities Budget Revenue Expense $20 00 Millions Airport Airport Budget Revenue Expense Jan 935,162           197,380          132,655           Feb 2,083,969        816,583          272,568           Mar 3,069,357        1,033,561      551,940           Apr 4,275,510        1,326,892      679,773           May 5,852,168         Jun 7,982,426         Jul 8,966,127         Aug 10,412,537       Sep 11,390,616       Oct 13,465,777       Nov 14,454,537       Dec 18,740,730       Percent of budget expended 3.63% Note:  Operations and Capital $‐ $2.00  $4.00  $6.00  $8.00  $10.00  $12.00  $14.00  $16.00  $18.00  $20.00  Budget Revenue Expense Page 36 of 37 City of Renton Monthly Enterprise Fund Financial Report ‐ 2013 Budget Year Golf Course Budget Revenue Expense Jan 138,483           59,391            129,801           Feb 283,549           161,197          254,957           Mar 587,345           291,654          404,017           Apr 749,859           505,367          579,467           May 958,900            Jun 1,133,021         Jul 1,331,819         Aug 1,513,051         Sep 1,688,936         Oct 1,864,635         Nov 2,024,142         Dec 2,632,848         Percent of budget expended 22.01% Note:  Operations and Capital $‐ $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10  $2.40  $2.70  $3.00  Millions Golf Course Budget Revenue Expense Page 37 of 37