Loading...
HomeMy WebLinkAbout201311, November.pdfADMINISTRATIVE SERVICES  DEPARTMENT    M   E   M   O   R   A   N   D   U   M       DATE: January 2, 2014     TO: Don Persson, Council President  Members of the Renton City Council     CC: Denis Law, Mayor  Administrators     FROM: Hai Nguyen, Sr. Finance Analyst     SUBJECT: November 2013 Financial Status Report       At the end of November, general governmental revenues show $3.9 million or 4.1% over  budget.  Revenues sources that are higher than expected are: property tax ($626k); sales tax  ($1.7 million); sales tax annexation credit ($284k); real estate excise tax ($279k); building  permits & development service fees ($932k); state shared revenues ($412k); public safety  services ($295k); interfund services ($263k); rents, leases, and concessions ($113k); and other  miscellaneous ($183k).  On the down side, the revenue sources that are underperforming the  year to date budget are: utility taxes ($388k below); gambling taxes ($287k below);  culture/recreation services ($121k below); fines/penalties ($234k below); seizure funds ($110k  below, restricted to drug enforcement only and is not available for general operating purposes)  and interest ($100k below).    General government expenditures showed a favorable variance of $2 million or 2.3%.  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        32,078,777     33,466,364          33,101,164     31,741,366       31,416,250    32,042,618      626,368          2.0% Sales Tax 17,729,731        16,305,899     18,564,670          16,939,390     18,604,000       17,044,107    18,730,304      1,686,197      9.9% Sales Tax ‐ Annexation Credit 2,033,954           1,864,549        2,208,492             2,015,685        2,119,680          1,934,626       2,218,819         284,192          14.7% Criminal Justice Sales  Tax 1,809,757           1,664,620        1,924,470             1,759,137        1,932,500          1,766,478       1,911,568         145,090          8.2% Natural  Gas Use Tax 249,407                233,040            272,530                  271,414             300,000               280,313            242,545             (37,767)             ‐13.5% Admission Tax 308,200                308,200            311,054                  309,809             308,000               306,768            327,109             20,341             6.6% Franchise Fees 1,234,448           1,187,337        1,262,188             1,213,993        1,260,000          1,211,889       1,264,244         52,355             4.3% Electricity Tax 5,166,711           4,658,706        5,211,111             4,750,540        5,468,000          4,984,724       4,721,058         (263,666)         ‐5.3% Natural  Gas Utility Tax 1,848,806           1,637,345        1,669,967             1,504,821        1,656,000          1,492,235       1,382,487         (109,749)          ‐7.4% Transfer  Station 297,474                274,190            330,607                  295,244             300,000               267,911            369,785             101,875          38.0% TV Cable 1,385,275           1,265,493        1,423,664             1,297,488        1,477,648          1,346,688       1,352,005         5,317                0.4% Telephone 966,827                896,516            1,056,420             868,430             1,000,000          822,051            813,888             (8,163)                ‐1.0% Cellular Phone 2,054,183           1,930,887        2,183,853             1,953,175        2,200,000          1,967,617       1,780,338         (187,279)         ‐9.5% City Utilities 3,516,179           3,227,799        3,806,281             3,485,580        3,849,014          3,524,712       3,635,803         111,091          3.2% Leasehold Excise  Tax 162,593                123,748            158,849                  120,295             145,000               109,807            124,288             14,481             13.2% Gambling Excise  Tax 1,671,414           1,500,517        1,691,209             1,538,190        1,600,000          1,455,233       1,168,258         (286,975)         ‐19.7% Real Estate  Excise  Tax 2,074,059           1,908,728        2,811,902             2,560,980        2,600,000          2,604,852       2,883,394         278,541          10.7% Less: Municipal Facilities CIP REET (400,000)              (340,844)           (943,792)                (737,047)           (500,000)             (554,513)          (554,513)            ‐                      0.0% EMS Levy 868,873                727,762            885,781                  442,891             900,000               687,271            687,271             ‐                      0.0% Business License Fees 442,451                447,230            444,680                  441,308             533,067               529,025            499,555             (29,470)            ‐5.6% Animal  Licenses and Spec Events  Permits 232,534                186,886            242,668                  215,074             90,000                  85,657               92,664                7,006                8.2% Building Permits & Development Svc Fees 2,772,779           2,556,370        3,401,537             2,991,129        3,123,413          2,722,293       3,654,661         932,368          34.2% Intergovt'l (Grants, State Shared, etc) 4,737,323           3,828,783        4,593,185             4,192,210        3,471,505          3,252,159       3,518,583         266,424          8.2% Fire District 25 and 40 Contracts 6,110,668           5,982,201        6,155,621             6,002,346        5,865,056          5,648,511       5,648,511          ‐                      0.0% Public Safety 484,985                438,838            485,899                  424,291             380,229               332,019            627,295             295,276          88.9% Culture and Recreation 1,493,540           1,444,650        1,494,165             1,433,697        1,618,486          1,552,988       1,431,570         (121,418)         ‐7.8% Interfund/Interdept‐Services 3,070,506           2,761,852        3,311,715             3,015,630        3,313,830          3,037,678       3,300,723         263,045          8.7% Fines and Penalties 1,163,602           985,088            1,046,246             893,172             1,108,500          948,229            976,576             28,347             3.0% Photo Enforcement 1,897,782           1,716,724        1,976,203             1,795,525        1,950,000          1,771,718       1,509,300         (262,418)         ‐14.8% Seizure Funds  ‐ Federal/State/Local 83,220                   83,220               37,941                     31,767                180,693               151,290            40,876                (110,414)         ‐73.0% Interests and Other  Earnings 107,183                95,267               342,424                  91,439                745,300               199,020            98,597                (100,423)         ‐50.5% Rents, Leases, and Concessions 744,834                685,910            822,428                  748,979             650,929               592,796            706,234             113,438          19.1% Contributions and Donations 196,586                181,939            124,082                  120,735             93,100                  90,589               80,715                (9,873)                ‐10.9% Other Miscellaneous 529,147                426,864            564,571                  476,459             516,369               444,812            627,855             183,043          41.2% Other Financing Sources  (Transfer‐In, etc) 1,073,507           699,192            5,118,188             907,701             254,868               45,201               24,292                (20,909)             ‐46.3% Total Operating Revenues 100,476,431     93,974,281     108,457,170       97,472,642     100,856,553    94,073,001    97,939,274      3,866,273      4.1% OPERATING EXPENDITURES Council 271,236                248,619            278,768                  254,552             290,291               265,573            263,960             1,613                0.6% Executive 1,566,906           1,373,408        1,377,109             1,231,423        1,322,364          1,170,013       1,121,750         48,263             4.1% City Attorney 1,596,609           1,454,358        1,706,320             1,563,092        1,915,103          1,749,576       1,604,675         144,901          8.3% Court Services 2,084,170           1,901,814        2,074,980             1,901,324        2,026,149          1,852,716       1,793,783         58,933             3.2% Community and Eco  Dvlpmnt Admin 929,814                852,682            942,071                  861,611             1,020,208          934,318            943,428             (9,110)                ‐1.0% Development Services 2,810,736           2,575,597        3,103,568             2,823,550        3,358,299          3,065,780       2,973,668         92,112             3.0% Economic Development 659,981                603,589            529,043                  490,160             570,280               524,583            412,147             112,437          21.4% Planning 1,447,781           1,324,065        1,482,233             1,347,651        1,541,592          1,405,692       1,382,280         23,412             1.7% Finance 2,134,667           1,701,582        2,221,882             1,768,328        2,242,682          1,786,254       1,799,155         (12,901)            ‐0.7% City Clerk1 796,758                737,553            997,434                  920,050             1,101,505          1,017,649       955,952             61,698             6.1% Human Resources 888,252                803,493            937,412                  850,165             977,094               885,037            815,257             69,780             7.9% Police 24,737,346        22,471,849     25,004,580          22,821,018     25,379,201       23,109,214    22,831,367      277,846          1.2% Jail Services 6,206,735           3,950,206        3,489,616             3,196,779        3,750,000          3,496,206       3,496,206         ‐                      0.0% Fire 22,511,597        20,660,951     24,173,315          22,184,782     24,197,056       22,207,188    22,411,736      (204,549)         ‐0.9% Community Services  Admin 416,284                376,608            434,558                  388,455             450,911               405,451            414,255             (8,804)                ‐2.2% Parks 3,829,676           3,513,912        4,004,054             3,632,323        4,153,621          3,789,095       3,703,721         85,373             2.3% Parks  Planning & Natural  Resources 551,423                510,697            577,934                  520,618             934,005               852,923            601,585             251,338          29.5% Recreation 4,974,002           4,581,590        4,982,229             4,567,758        5,130,300          4,714,526       4,472,957         241,568          5.1% Human Services 1,247,294           1,084,769        1,193,871             1,019,454        1,196,052          1,030,967       962,149             68,817             6.7% Neighborhoods, Resources, & Events 675,534                575,306            701,673                  633,941             914,955               803,370            703,994             99,376             12.4% Library 2,030,000           2,027,619        278,604                  276,106             ‐                           ‐                        ‐                         ‐                      0.0% Museum 210,620                192,989            216,887                  199,085             211,080               193,585            192,315             1,270                0.7% Public Works Admin 452,538                414,834            470,051                  430,641             483,035               442,662            395,530             47,132             10.6% Street Maintenance 3,534,025           3,248,591        3,755,640             3,368,565        4,294,894          3,898,668       3,497,441         401,227          10.3% Transportation 4,509,066           4,054,370        4,615,160             4,086,739        4,579,081          4,085,694       3,894,267         191,426          4.7% Debt Service 4,822,566           1,556,640        9,752,337             2,747,599        8,034,283          3,562,890       3,562,890          ‐                      0.0% Non‐Departmental and Other 4,930,383           4,673,927        4,637,555             2,705,438        5,641,350          3,530,675       3,530,675          ‐                      0.0% Total Operating Expenditures 100,825,999     87,471,619     103,938,882       86,791,207     105,715,391    90,780,304    88,737,144      2,043,160      2.3% Total Ending Fund Balance 11,057,551$     17,909,782$  15,575,840$       21,738,986$  10,717,001$    18,868,536$ 24,777,969$   5,909,433$   31.3% 1Hearing Examiner is reported under City Clerk Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable) 2011 2012 2013 Variance Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual   Monthly Financial Report November 2013 Page 1 of 37 Monthly Financial Report November 2013      OVERVIEW  This financial overview reflects the City’s overall financial position for the fiscal year through November 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 75% of  all resources supporting general governmental activities.   The following section provides detail information on property,  sales, utility, and other taxes.    Property Tax  November’s collection is $4.3 million,  making the total year‐to‐date collection  $32 million or 100.9% of the total budget.   In comparison to the previous year, the  City collected $1.1 million or 3% less.   Compared to the budget, the City is  above projections by $626k or 2%.   2013’s monthly budgets are based on  2010 through 2012 collections.  The  variance from the monthly budget is due  the timing of collections.  The City has  exceeded the current budget.  We  adjusted the budget in December to  reflect updated projections.        Sales Tax  November 2013 sales tax receipts totalled  $1.8 million.  Compared with the same  month last year, it is $94k or 5% more.   Compared to the projected current  month’s budget, it is $181k or 11% above.   The year‐to‐date collection of $18.7  million is $1.8 million or 11% more than  the prior year and is also $1.7 million or  10% more than budgeted.  The increase is  primarily attributed to several major  projects underway in both Building  Construction and Heavy and Civil  projects, which account for $642k of the  budget variance.  Another item is a 1‐ time audit correction in the  manufacturing sector for 2012 that  reduced activity in 2012 by $131k.  If we remove all of these items, we are $1 million or 6% over 2012 and $1 million or 6%  more than budget.  We adjusted the budget in December to reflect updated projections.    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        5,780,361       (351,089)          ‐6% (1,027,138)    ‐15% Jun 43,203               69,561               88,480               45,277              105% 18,919            27% Jul 446,717            218,293            100,047            (346,670)          ‐78% (118,246)        ‐54% Aug (51,143)              13,620               58,101               109,245            ‐214% 44,482            327% Sep 545,753            415,826            548,071            2,319                 0% 132,245         32% Oct 9,734,384        7,408,344        10,140,892    406,508           4% 2,732,549    37% Nov 5,123,725        6,825,452        4,341,474       (782,251)          ‐15% (2,483,978)    ‐36% Dec 365,200            325,116             YTD Total 33,101,164$  31,416,250$  32,042,618$ (1,058,547)$   ‐3% 626,368$      2% Annual  Total 33,466,364$  31,741,366$   Property Tax  Revenues Year to Date through November 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        1,732,058        132,874         8% 106,357         7% Jun 1,482,794        1,471,334        1,552,807        70,013            5% 81,473            6% Jul 1,505,142        1,462,124        1,647,860        142,718         9% 185,736         13% Aug 1,583,903        1,588,018        1,833,347        249,443         16% 245,328         15% Sep 1,472,566        1,508,206        1,741,262        268,697         18% 233,056         15% Oct 1,660,941        1,588,803        1,790,411        129,470         8% 201,608         13% Nov 1,709,049        1,622,090        1,802,768        93,719            5% 180,678         11% Dec 1,625,280        1,559,893         ‐                         YTD  Total 16,939,390$  17,044,107$  18,730,304$  1,790,913$  11% 1,686,197$  10% Annual  Total 18,564,670$  18,604,000$   2013 vs. Budget2013 vs. 2012 Month Year to Date through November Local Retail Sales  Tax  Revenues Page 2 of 37 Monthly Financial Report November 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 1,602,550$     1,677,611$     2,516,097$     913,548$       57%$        838,487 50% Auto  Sales 3,098,992        3,092,502        3,460,810        361,819          12%           368,309 12% General Retail 5,957,206        6,002,988        6,058,388        101,182          2%              55,400 1% Manufacturing 951,888            943,268            1,152,420        200,532          21%           209,152 22% Wholesale 1,062,528        1,072,952        1,032,149        (30,379)            ‐3%            (40,803)‐4% Service 3,869,521        3,879,074        4,033,126        163,605          4%           154,052 4% Other 396,706            375,713            477,313            80,607             20%           101,600 27% YTD  Total 16,939,390$  17,044,107$  18,730,304$  1,790,913$  11%1,686,197$    10% Note: Excludes  Annexation  Credit and Criminal Justice Sales  Tax revenue.        Utility tax   November utility tax revenues are $1.2  million, which is $48k or 4% higher than  the same month last year and is also  ahead of the budget by $31k or 3%.  The  year‐to‐date collection is $14.3 million,  which is $129k or 1% lower than the prior  year and is also $388k or 3% lower than  the budget. The City is projecting utility  tax revenues to be under budget at year‐ end.  We adjusted the budget in  December to reflect updated projections.                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 and therefore we are projecting a combined unfavorable variance of $329k or 5%.  Cell and  Phone variances are due the timing of receipts compared to 2012 (which should mostly catch up at the end of the year, but  we are projecting a combined unfavorable budget variance of $245k or 8%).    Utility Tax  by Type 2012 2013 Bgt YTD Act Change  2013/2012  2013 Act  vs  Bgt  Electrical 4,750,540$     4,984,724$     4,721,058$     (29,482)$         ‐1%$      (263,666)‐5% Natural  Gas 1,776,235        1,772,548        1,625,032        (151,203)        ‐9%         (147,516)‐8% Cell 1,953,175        1,967,617        1,780,338        (172,837)        ‐9%         (187,279)‐10% Phone 868,430            822,051            813,888            (54,543)            ‐6%               (8,163)‐1% Cable 1,297,488        1,346,688        1,352,005        54,517             4%                 5,317 0% Transfer  Station 295,244            267,911            369,785            74,542             25%           101,875 38% City Utilities 3,485,580        3,524,712        3,635,803        150,223          4%           111,091 3% YTD  Total 14,426,692$  14,686,250$  14,297,910$  (128,783)$     ‐1%(388,341)$       ‐3% Annual Total 15,954,432$  16,250,662$   YTD  as % of 90% 90%      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         1,338,923        (55,185)         ‐4% (84,235)        ‐6% Jun 1,108,588        1,140,870         1,189,847        81,259         7% 48,977         4% Jul 1,340,939        1,370,103         1,259,713        (81,225)         ‐6% (110,390)     ‐8% Aug 1,153,724        1,180,346         1,280,207        126,484      11% 99,861         8% Sep 1,301,158        1,332,309         1,433,293        132,136      10% 100,985      8% Oct 1,126,772        1,153,538         1,072,773        (53,999)         ‐5% (80,766)        ‐7% Nov 1,196,932        1,213,641         1,244,671        47,739         4% 31,030         3% Dec 1,527,740        1,564,412          YTD  Total 14,426,692$  14,686,250$   14,297,910$  (128,783)$  ‐1% (388,341)$  ‐3% Annual Total 15,954,432$  16,250,662$    2013 vs. Budget2013 vs. 2012 Year  to Date through November Utility Tax  Revenues Month Page 3 of 37 Monthly Financial Report November 2013      Other Taxes     Real Estate Excise Tax  The City collected $343k in Real Estate  Excise Tax revenues (REET) for November.   This is $28k or 7% below the same month  last year but is $150k or 78% more than the  current month’s budget.  The year‐to‐date  collection is $2.9 million, which is $322k or  13% more than the prior year and is also  $279k or 11% above the budget.  The City  has met the budget for REET.                Gambling Tax  November’s Gambling Tax collections  totalled $115k, which is $62k or 35%  below the same month last year and is  also $53k or 32% below the current  month’s budget.  The year‐to‐date  total of $1.2 million is $370k or 24%  below the year before and is also  $287k or 20% below budget.  The  decline in revenue is mainly due to  payment plans with two (2)  establishments that will be paid in full  by March 2015.  The City is also seeing  a decline in overall activity.    Pull tabs overall had a 4% decrease,  bingo decreased by 9%, and card‐ rooms are seeing 36% lower in activities when compared to the prior year.        Franchise Fees  Franchise Fees are due quarterly and  the year‐to‐date revenue collections  are $1.3 million or 100% of the  budget.  This is $50k or 4% higher than  the prior year and is also $52k or 4%  above the projected year‐to‐date  budget.  The City has exceeded the  budget for Franchise Fees.  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         283,619         285,948         32,501         13% 2,329            1% Jun 347,179         380,093         347,890         711                 0% (32,203)        ‐8% Jul 177,839         211,158         263,807         85,967         48% 52,649         25% Aug 222,933         257,653         294,056         71,123         32% 36,403         14% Sep 173,212         205,159         254,318         81,106         47% 49,160         24% Oct 326,027         293,997         272,776         (53,251)         ‐16% (21,221)        ‐7% Nov 370,123         192,446         342,535         (27,588)        ‐7% 150,090      78% Dec 250,922         (4,852)               YTD  Total 2,560,980$  2,604,852$  2,883,394$  322,414$   13% 278,541$   11% Annual  Total 2,811,902$  2,600,000$   Real Estate Excise  Tax  Revenues Year to Date through November Month 2013 vs. Budget2013 vs. 2012 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            97,660            (3,428)           ‐3% 2,024            2% Jun 127,372         120,502         60,074            (67,298)        ‐53% (60,428)        ‐50% Jul 161,244         152,548         89,157            (72,087)        ‐45% (63,391)        ‐42% Aug 146,526         138,623         99,930            (46,596)        ‐32% (38,694)        ‐28% Sep 162,540         153,774         116,204         (46,336)        ‐29% (37,570)        ‐24% Oct 87,494            82,776            112,141         24,647         28% 29,365         35% Nov 177,352         167,787         114,909         (62,443)        ‐35% (52,878)        ‐32% Dec 153,019         144,767         ‐                      YTD  Total 1,538,190$  1,455,233$  1,168,258$  (369,932)$  ‐24% (286,975)$  ‐20% Annual  Total 1,691,209$  1,600,000$   Year to Date through November 2013 vs. 2012 2013 vs. Budget Gambling Tax  Revenue Month 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         315,694         10,630         3% 11,158         4% Oct 309,001         308,466         321,202         12,200         4% 12,736         4% Dec 48,195            48,111            ‐                      YTD Total 1,213,993$  1,211,889$  1,264,244$  50,251$      4% 52,355$      4% Annual  Total 1,262,188$  1,260,000$   Mo nth 2013 vs. 2012 2013 vs. Budget Franchise Fees  Revenue Year to Date through November Page 4 of 37 Monthly Financial Report November 2013      Admission Tax   Admission Tax returns are due  quarterly in January, April, July, and  October of each year.  October 2013  collections represent activities  conducted during the 3rd quarter of  2013.  The year‐to‐date collection of  $327k is $18k or 6% more than the  prior year and is also $21k or 7% more  than the budget.  The City has  exceeded the budget for Admissions  Tax.      Licenses and Permits    Building Permits and Development Service  Fees  Building Permits and Development Service  Fee revenues totalled $393k in November.   The year‐to‐date development fees revenue  of $3.7 million is $751k or 26% more than  the year before and is also $932k or 34%  higher than budget.  The higher than  expected fees are due to collecting more in  general building permits, electrical permits,  street excavations, and plan check fees.  The  City has exceeded the current budget for  Building Permits and Development Services  Fees.  We adjusted the budget in December  to reflect updated projections.            Business Licenses  Business Licenses totalled $13k for November,  which is $858 or 7% above the same month last  year but is $2k or 11% below the current month’s  budget.  The year‐to‐date Business Licenses  revenue of $500k is $58k or 13% above the prior  year but is $29k or 6% lower than the budget.   The variance for July is due to correcting the  percentages distributed between the General  fund and Transportation CIP fund.  The City is  projecting business licenses to be under the  budget at year‐end.      2012 2013 2013 Actual Budget Actual $ % $ % Jan 151,891$      150,030$      327,644$      175,754$   116% 177,614$   118% Feb 185,509         182,234         230,104         44,595         24% 47,870         26% Mar 253,914         237,278         305,160         51,246         20% 67,882         29% Apr 249,923         243,068         367,285         117,362      47% 124,217      51% May 277,438         236,982         386,795         109,358      39% 149,814      63% Jun 284,208         245,409         293,386         9,178            3% 47,977         20% Jul 292,686         278,792         315,496         22,809         8% 36,703         13% Aug 360,657         347,350         340,335         (20,322)         ‐6% (7,014)            ‐2% Sep 174,587         154,690         254,869         80,281         46% 100,179      65% Oct 400,995         384,228         440,279         39,284         10% 56,051         15% Nov 271,519         262,232         393,308         121,789      45% 131,077      50% Dec 406,375         401,120          YTD  Total 2,903,327$  2,722,293$  3,654,661$  751,334$   26% 932,368$   34% Annual  Total 3,309,702$  3,123,413$   Building Permits and Development Service Fees Year  to Date through November 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           33,354        30,709      1161% 30,183      952% Jun 3,377           4,048           5,701           2,324         69% 1,653         41% Jul 98,553        118,142     52,586        (45,967)      ‐47% (65,556)      ‐55% Aug 14,550        17,442        29,210        14,661      101% 11,769      67% Sep 3,197           3,833           4,236           1,039         32% 403              11% Oct 99,644        119,450     109,998     10,354      10% (9,452)         ‐8% Nov 12,484        14,965        13,342        858              7% (1,623)         ‐11% Dec 3,372           4,042           ‐                  YTD  Total 441,308$  529,025$  499,555$  58,247$   13% (29,470)$  ‐6% Annual Total 444,680$  533,067$   2013 vs. 2012 Year to Date through November 2013 vs. Budget Business Licenses Month 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            87,473            6,370            8% 7,166            9% Aug ‐                     ‐                     76                       76                    100% 76                    100% Oct 74,001            73,275            85,616            11,615         16% 12,342         17% Nov ‐                     ‐                     1,192               1,192            100% 1,192            100% Dec 1,244               1,232               ‐                      YTD  Total 309,809$      306,768$      327,109$      18,233$      6% 21,265$      7% Annual Total 311,054$      308,000$       Month 2013 vs. 2012 2013 vs. Budget Admission Tax  Revenue Year  to Date through November Page 5 of 37 Monthly Financial Report November 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 89% of  the total revenues in this  category.   The year‐to‐date total Intergovernmental revenue is $11.1 million or 98% of the budget.       State Shared Revenues  State Shared Revenue collections  totalled $4.2 million since the start  of the year.  Compared to the prior  year, State Shared Revenues are  below by $140k or 3%.  Compared  to the projected budget, the City is  collecting $412k or 11% 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 69% of the total revenue in this category.  The year‐to‐date total charges for services are $6.9 million or 105% of  the budget.  This is 15% above budget projections.  The following sections provide detail information for Public Safety,  Recreation, and Interfund Services.       2012 2013 2013 Actual Budget Actual $ % $ % Crim Just Sales  Tax 1,759,137$     1,766,478$  1,911,568$   152,431$   9% 145,090$   8% Judicial Contribution 22,632                22,500            22,796              164                 1% 296                 1% Crim Just ‐ High Crime 196,270              ‐                     229,636           33,366         17% 229,636      100% Crim Just ‐ Pop 20,976                ‐                     22,656              1,680            8% 22,656         100% Crim Just ‐ Spec Prog 78,864                90,000            84,328              5,465            7% (5,672)            ‐6% State  DUI 17,397                18,000            17,116              (281)                ‐2% (884)                ‐5% Liquor Profits 717,552             494,451         635,103           (82,449)         ‐11% 140,651      28% Liquor Excise  Tax 342,495             220,000         63,108              (279,387)     ‐82% (156,892)     ‐71% Fuel Tax 1,178,999        1,171,410     1,208,042      29,044         2% 36,633         3% YTD  Total 4,334,322$     3,782,839$  4,194,353$   (139,968)$  ‐3% 411,515$   11% Annual  Total 4,825,202$     4,208,000$   Year  to Date through November State  Shared Revenues 2013 vs. 2012 Revenue 2013 vs. Budget Intergovernmental 2012 2013 Bgt YTD  Act Change  2013/2012 2013 Act vs Bgt  Fire District #25 1,345,623$     1,157,089$     1,157,089$     (188,534)$      ‐14% $                          ‐ 0% Fire District #40 4,656,723        4,491,422        4,491,422        (165,301)         ‐4%‐                            0% State Shared Revenue 4,334,322        3,782,839        4,194,353        (139,968)         ‐3% 411,515          11% Federal Grants 959,359            1,022,468        1,022,468        63,108             7%‐                            0% State Grants 140,439            63,711               63,711               (76,729)            ‐55%‐                            0% Other Grants/Intgovt 123,235            34,828               34,828               (88,407)            ‐72%‐                            0% ARRA Grants 393,992            114,792            114,792            (279,201)         ‐71%‐                            0% Total  Rev YTD 11,953,693$  10,667,148$  11,078,662$  (875,031)$     ‐7%411,515$        4% Total  Rev Annual 12,673,276$  11,269,061$   YTD  % 94% 95% 98% Note:  Includes CJ Sales  Tax and FD25  & FD40 contracts Page 6 of 37 Monthly Financial Report November 2013      Public Safety Services  Public Safety Services totalled $627k 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 $203k or 48% more.  Compared to  the year‐to‐date budget, the City is $295k or  89% more.  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 $627k receipted for Public Safety Services, $147k is for  intergovernmental.        Recreation  Recreation revenues totalled $66k for the  current month.  Compared to the same month  the prior year, the City collected almost the  same amount.  Compared to the projected  monthly budget, the City collected $6k or 8%  less.  The primary reason that recreation fees  are lower is due to the new cost recovery  policy approved by council in 2012 which  reduces or eliminates those programs that do  not meet recovery objectives.  This revenue  reduction translates into a savings of $242k in  the Recreation Division of the Community  Services Department.          Interfund Services  The year‐to‐date collections for Interfund  Services revenues are $3.3 million.  Compared  to the prior year, the revenues are over by  $285k or 9%.  Compared to the projected  budget, the revenues are above by $263k or  9%.  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.  We  adjusted the budget in December to reflect updated projections.  2012 2013 2013 Actual Budget Actual $ % $ % Jan 15,229$         11,917$          32,322$         17,093$     112% 20,405$      171% Feb 34,848            27,269             117,056         82,208        236% 89,787         329% Mar 35,353            27,665             37,079            1,726           5% 9,414            34% Apr 68,426            53,545             64,009            (4,418)           ‐6% 10,463         20% May 42,979            33,632             47,985            5,007           12% 14,353         43% Jun 31,486            24,639             36,945            5,459           17% 12,306         50% Jul 54,883            42,948             69,340            14,457        26% 26,393         61% Aug 34,742            27,187             42,753            8,010           23% 15,566         57% Sep 36,019            28,186             48,986            12,967        36% 20,800         74% Oct 37,300            29,188             81,116            43,817        117% 51,928         178% Nov 33,025            25,843             49,703            16,678        51% 23,860         92% Dec 61,608            48,210             ‐                      YTD  Total 424,291$      332,019$       627,295$      203,004$  48% 295,276$   89% Annual  Total 485,899$      380,229$        Month 2013 vs. 2012 Year  to Date through November 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         95,710            (43,303)         ‐31% (54,870)         ‐36% Jun 149,137         161,546         150,284         1,147            1% (11,262)         ‐7% Jul 260,363         282,026         345,126         84,763         33% 63,100         22% Aug 262,038         283,841         205,821         (56,217)         ‐21% (78,020)         ‐27% Sep 107,879         116,855         123,550         15,670         15% 6,694            6% Oct 85,973            93,126            83,685            (2,288)            ‐3% (9,441)            ‐10% Nov 65,863            71,343            65,656            (207)               0% (5,687)            ‐8% Dec 60,467            65,498             ‐                      YTD  Total 1,433,697$  1,552,988$  1,431,570$  (2,127)$        0% (121,418)$  ‐8% Annual  Total 1,494,165$  1,618,486$   Recreation Year  to Date through November 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         299,652         7,711            3% 23,499         9% Jun 275,112         276,153         287,569         12,457         5% 11,417         4% Jul 217,828         276,153         282,466         64,638         30% 6,314            2% Aug 345,690         276,153         352,945         7,255            2% 76,793         28% Sep 273,570         276,153         274,525         955                 0% (1,628)            ‐1% Oct 338,304         276,153         352,421         14,117         4% 76,269         28% Nov 276,902         276,153         286,300         9,398            3% 10,148         4% Dec 296,085         276,153          ‐                      YTD  Total 3,015,630$  3,037,678$  3,300,723$  285,092$   9% 263,045$   9% Annual  Total 3,311,715$  3,313,830$   2013 vs. Budget Month Interfund Services Year  to Date through November 2013 vs. 2012 Page 7 of 37 Monthly Financial Report November 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 below breaks down these fines by  type.  The year‐to‐date total fines and  penalties is $2.5 million.  This is $235k or 9%  lower than a year ago and is also $234k or  9% below the budget.  The City is projecting  fines and penalties to be under the budget  at year‐end.            Year  to Date through November 2012 2013 2013 Actual Budget Actual $ % $ % Civil Penalties 7,831$            13,054$         8,591$            760$              10% (4,462)$         ‐34% Civil Infraction Penalties 532,546         518,027         539,579         7,033            1% 21,553         4% Civil Parking Infraction Penalties 141,095         159,647         161,148         20,054         14% 1,501            1% Photo Enforcement Program 1,795,525     1,771,718     1,509,300     (286,225)     ‐16% (262,418)     ‐15% Criminal Traffic  Misdemeanor Fines 75,400            86,943            88,465            13,065         17% 1,521            2% Criminal Non‐Traffic  Fines 23,466            42,872            41,110            17,644         75% (1,762)            ‐4% Criminal Costs 112,077         105,686         112,208         131                 0% 6,522            6% Seizure  Funds  ‐ Federal/State/Local 1 31,767            ‐                   ‐                   (31,767)      0%‐                  N/A Non‐Court Fines, Forfeitures and Penalties 758                    22,000            25,474            24,717         3263% 3,474            16% YTD Total 2,720,463$  2,719,947$  2,485,876$  (234,588)$  ‐9% (234,071)$  ‐9% Annual Total 3,060,389$  3,058,500$   1 Seizure  Funds  are categorized in Miscellaneous  for 2013 and on. 2013 vs. 2012 Revenue 2013 vs. Budget Fines  and Penalties by Type       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  $1.5 million.  The budget shortfall in January 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 budget shortfall starting in June is  due to temporary shutting down cameras in  construction areas.  These revenues should pick up  after construction is near completion.    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         278,783         (27,641)        ‐9% (31,922)         ‐10% Jun 318,091         312,586         269,334         (48,758)         ‐15% (43,252)         ‐14% Jul 274,243         277,336         236,571         (37,672)         ‐14% (40,765)         ‐15% Aug 168,187         171,297         171,565         3,378            2% 268                 0% Sep 179,166         176,075         154,604         (24,562)         ‐14% (21,470)         ‐12% Oct 278,866         280,183         191,919         (86,947)         ‐31% (88,264)         ‐32% Nov 247,607         251,568         189,412         (58,195)         ‐24% (62,156)         ‐25% Dec 339,926         338,553          YTD  Total 2,720,463$  2,719,947$  2,485,876$  (234,588)$  ‐9% (234,071)$  ‐9% Annual  Total 3,060,389$  3,058,500$   Month 2013 vs. Budget2013 vs. 2012 Year to Date through November Fines  and Penalties by 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         181,018         74,599           60,361         120,657            Jun 218,587         161,729         74,570           56,521         105,208            Jul 186,121         151,808         74,882           56,398         95,411               Aug 91,365            80,932            74,285           56,345         24,586               Sep 71,743            58,676            50,884           55,930         2,747                  Oct 191,799         100,760         65,641           51,130         49,629               Nov 153,910         94,351            66,315           51,346         43,005               Dec 178,282          ‐                     66,397           ‐                  ‐                        YTD Total 1,771,718$  1,509,300$  775,567$     628,941$   880,359$         Annual Total 1,950,000$  841,964$      1Actuals  of Revenues  and Expenses Expenses Photo Enforcement Program Year to Date through November Month Revenues Page 8 of 37 Monthly Financial Report November 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 65% of the total  revenue in this category.  The year‐to‐date  total miscellaneous is $1.2 million.  Compared  to last year, the revenues are below by $4k.   Compared to the projected year‐to‐date  budget, the revenues are over by $48k or 4%.   The table below breaks out miscellaneous  revenues by type:      2012 2013 2013 ActualBudgetActual$%$% Interests  and Other  Earnings 91,439$         199,020$      98,597$         7,159$         8% (100,423)$   ‐50% Rents, Leases, and Concessions 748,979         592,796         706,234         (42,745)         ‐6% 113,438      19% Contributions/Donations  from  Private Sources 120,735         90,589            80,715            (40,020)         ‐33% (9,873)            ‐11% Other 272,056         147,201         302,589         30,533         11% 155,388      106% Seizure Funds ‐ Federal/State/Local 1 ‐                   151,290       40,876          40,876       100% (110,414)      ‐73% YTD  Total 1,233,209$  1,180,896$  1,229,012$  (4,198)$        0% 48,116$      4% 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 November Revenue 2013 vs. 2012     Rents, leases and concessions are higher than the prior year and budget due to higher than expected picnic shelter rentals,  facility/fitness area rentals at the community center and food concession payments at Coulon Park.    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.  The use of Seizure Funds is restricted to drug  enforcement only and is not available for general operating purposes.      EXPENSES  Overall the City has expended 84% of its budgeted general governmental expenditures at the end of November.  This is $2  million or 2.3% below year‐to‐date budgeted expenditures.  See below for summary of unfavorable items for general  governmental departments.    Fire department is over the year‐to‐date budget by $205k. This is mainly due to overspending in overtime ($435k),  supplies/capital ($74k), intergovernmental ($103k), and under spending on salaries and benefits ($265k) and general  professional services ($144k).  We adjusted the department’s budget by $442k in December to recognize SAFER/EMPG  grants, which will keep the department within budget by year‐end.    2012 2013 2013 Actual Budget Actual $ % $ % Jan 206,151$      163,080$      179,743$      (26,408)$     ‐13% 16,663$      10% Feb 83,823            135,969         76,397            (7,425)           ‐9% (59,572)         ‐44% Mar 104,421         84,515            147,909         43,488         42% 63,394         75% Apr 98,164            111,835         92,872            (5,291)           ‐5% (18,963)         ‐17% May 145,213         112,179         118,719         (26,494)        ‐18% 6,540            6% Jun 93,832            113,839         123,441         29,609         32% 9,602            8% Jul 112,316         95,083            128,246         15,930         14% 33,163         35% Aug 143,389         131,277         122,652         (20,737)       ‐14% (8,624)            ‐7% Sep 89,588            100,822         92,799            3,211            4% (8,024)            ‐8% Oct 91,608            75,456            82,288            (9,320)           ‐10% 6,832            9% Nov 64,705            56,841            63,945            (760)                ‐1% 7,104            12% Dec 397,713         680,126          YTD  Total 1,233,209$  1,180,896$  1,229,012$  (4,198)$       0% 48,116$      4% Annual Total 1,630,922$  1,861,022$   Year  to Date through November Month 2013 vs. Budget2013 vs. 2012 Miscellaneous Revenues  by Month Page 9 of 37 Monthly Financial Report November 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 ‐                  ‐             ‐                 ‐               58,469         47,131       ‐               Grants  / intergovernmental 8,573,293       ‐             104,987          355              9,316           885,850     ‐               Charges  for services 124,437          1,735,817  14,616,527     15,323,421  8,609,707    8,133,095  14,012,923  Interdepartmental  services ‐                 ‐             ‐                 ‐               ‐               ‐             ‐               Fines  and penalties 7,759              ‐             ‐                 ‐               566              ‐             ‐               Rents, leases, and misc fees 2,182,268       341,832     69,734            131,666       ‐               ‐             ‐               Interest and other misc 6,738              79,374       9,119              523,504       790,824       319,769     5,051           TOTAL REVENUES 10,894,495     2,157,023  14,800,367     15,978,946  9,468,882    9,385,845  14,017,974  EXPENSES: Utility billing ‐                  ‐             107,356          105,357       78,121         127,071      ‐               Utility systems ‐                 ‐             13,672,415     4,598,996    2,672,524    2,937,335  ‐               Utility maintenance ‐                 ‐             267,705          4,266,892    1,122,712    1,899,518  13,133,378  Transportation 1,881,295       ‐             ‐                 ‐               ‐               ‐             ‐               Golf ‐                 1,889,534  ‐                 ‐               ‐               ‐             ‐               TOTAL EXPENSES 1,881,295       1,889,534  14,047,476     8,971,245    3,873,357    4,963,924  13,133,378  AMOUNT AVAILABLE  FOR DEBT SERVICE 9,013,200       267,489     752,891          7,007,701    5,595,525    4,421,921  884,596       DEBT SERVICE: Principal 98,209            ‐             ‐                 664,925       565,383       63,340       ‐               Interest 6,995              ‐             ‐                 348,144       180,798       146,868     ‐               TOTAL DEBT SERVICE 105,204          ‐             ‐                 1,013,069    746,181       210,208     ‐               CAPITAL PROJECTS 9,295,010       15,145       ‐                 2,881,752    2,468,470    1,671,300  ‐               TRANSFERS IN/(OUT)(13,499)          ‐             ‐                 7,526           (3,763)          (8,967)        ‐               CHANGE IN FUND BALANCE (400,513)        252,344     752,891          3,120,406    2,377,111    2,531,446  884,596       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, Nov 30 1,942,411       792,158     2,276,772       12,966,714  5,573,845    8,545,920  2,630,483        Page 10 of 37 Monthly Financial Report November 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 ‐                 116,246        ‐             ‐                      ‐            ‐              ‐             Grants  / intergovernmental 83                   1,024           ‐             ‐                      ‐            ‐              32,467        Charges  for services Equipment rental  m&o 2,507,255       2,799,268    ‐             ‐                      ‐            ‐              ‐             Print and mail ‐                 103,042       ‐             367,294             ‐            ‐              ‐             Communications ‐                 6,090           73,834       469,810             ‐            ‐              ‐             Facilities ‐                 ‐              3,922,173  ‐                      ‐            ‐              ‐             Data cards  and cell  phones ‐                 128,709       ‐             ‐                      ‐            ‐              ‐             IT service contracts ‐                 402,262        ‐             ‐                      ‐            ‐              ‐             Interest and other misc 10,333            5,094           2,754         821                    27,496      18,228        16,900        Internal service fund misc: Vehicle  / equipment capital  recovery 1,303,002       155,833       ‐             ‐                      ‐            ‐              ‐             Insurance premiums ‐                 ‐              ‐             ‐                     1,459,359 ‐              ‐             Worker's  comp/unemployment ‐                 ‐              ‐             ‐                     1,466,175 ‐              ‐             Benefit premiums ‐                 ‐              ‐             ‐                      ‐            8,595,930   1,564,973   Other misc 6,231              12,218         11,638       ‐                     227           102,788      ‐             Interfund Loan ‐                 ‐              ‐             ‐                     136,852    ‐              ‐             Capital  contributions 22,930            ‐              ‐             ‐                      ‐            ‐              ‐             Disposal  of capital  assets 91,261            ‐              ‐             ‐                      ‐            ‐              ‐             Insurance recoveries 25,000            ‐              ‐             ‐                     89,140      359,431      ‐             TOTAL REVENUES 3,966,095       3,729,786    4,010,399  837,925             3,179,249 9,076,377   1,614,340   EXPENSES: Communications 442,939              Equipment rental 2,130,012        Facilities 3,182,764   Healthcare 9,734,970    Information technology 2,978,587     Print and mail 336,010              Retiree  healthcare 960,348      Risk management Ri sk management 1,640,083  Unemployment 45,330       Worker's  compensation 1,313,816  TOTAL EXPENSES 2,130,012       2,978,587    3,182,764  778,949             2,999,229 9,734,970   960,348      AMOUNT AVAILABLE  FOR CAPITAL 1,836,083       751,199       827,635     58,976               180,020    (658,593)     653,992      CAPITAL PROJECTS 1,930,021       548,442       260,326     ‐                      ‐            ‐              ‐             TRANSFERS IN 54,385            89,130         551            ‐                     2,000,000 ‐              ‐             TRANSFERS (OUT)‐                 ‐              ‐             ‐                      ‐            ‐              ‐             CHANGE IN FUND BALANCE (39,553)          291,887       567,860     58,976               2,180,020 (658,593)     653,992      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, Nov 30 3,682,948       2,148,859    1,417,332  362,453             7,166,827 7,240,477   7,136,157      Page 11 of 37 Monthly Financial Report November 2013      FUND BALANCE  Page 13 shows the ending fund balance as of November 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 November, the City has $24.8 million reported in the combined general governmental fund balance of the  current year’s operating budget, which is approximately 23% of budgeted operating expenditures.  This is an increase of  $9.2 million from the year’s beginning balance.  November’s ending fund balance is over the anticipated General  Governmental Fund Balance of $18.9 million by $5.9 million or 31.3%.  Although the ending fund balance is above  projections, it is consistent with the prior years’ trends since the City receipted the first half of 2013 property taxes in  April/May and receipted the 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 November 2013      City  of Renton All Funds ‐ Revenue, Expenditures and Fund  Balances Cash  Basis through November 30, 2013 Funds Balance  01/01/2013 Budgeted  Revenue Revenue  11/30/13 Total Funds   Available Budgeted  Expenditure Expenditure  11/30/13 Ending  Balance GENERAL GOVERNMENT FUNDS:15,575,839 100,856,553 97,939,274   113,515,113 105,715,391 88,737,144   24,777,969  000 General 10,575,369 71,987,103   71,187,030   81,762,399   76,690,192   67,432,413   14,329,987  001 Community Services 1,891,966   11,328,945   10,386,851   12,278,817   11,325,011   9,844,855     2,433,963    003 Street 1,585,553   8,877,257     7,959,512     9,545,065     8,873,975     7,391,709     2,153,357    004 Community Dev Block Grant (13,145)       367,512        86,254          73,109          297,069        231,865        (158,756)      005 Museum 52,369        209,903        209,982        262,351        211,080        192,315        70,037         009 Farmers  Market 90,520        59,400          45,491          136,011        80,414          51,658          84,353         011 Fire Health & Wellness 55,483        25,000          27,181          82,664          25,000          29,439          53,225         031 Park  Memorial 178,367      ‐                    441               178,808        178,367        ‐                    178,808       201 Ltd  GO Bonds  Gen Govt Debt 829,784      1,749,305     1,752,724     2,582,508     1,749,305     134,500        2,448,008    215 Gen Govt Misc Debt Service 329,573      6,252,128     6,283,806     6,613,379     6,284,978     3,428,390     3,184,989    SPECIAL REVENUE FUNDS: 102 Arterial  Street 168,514      643,000        569,448        737,962        600,000        600,000        137,962       108 Leased  City Properties 527,677      797,289        587,201        1,114,878     752,011        714,292        400,586       110 Hotel  Motel 111,256      245,000        293,854        405,110        291,000        217,590        187,520       125 1% For Art 116,142      16,000          11,408          127,550        50,000          29,800          97,750         127 Cable  Communication 257,372      85,674          91,567          348,939        85,674          43,415          305,524       135 Springbrook Wetlands  Bank 665,828       ‐                    1,646            667,474         ‐                     ‐                    667,474       CAPITAL PROJECT FUNDS (CIP): 303 Community Dev Mitigation 1,540,154   60,000          81,387          1,621,541     700,000         ‐                    1,621,541    304 Fire Mitigation 797,417      25,000          94,066          891,483        250,000        ‐                    891,483       305 Transportation  Mitigation 292,627      40,000          238,174        530,801        100,000        100,000        430,801       316 Municipal Facilities CIP 3,474,517   4,361,912     2,641,735     6,116,252     7,735,752     1,882,294     4,233,958    317 Transportation  CIP (391,159)     34,020,559   22,308,268   21,917,109   33,608,158   18,457,506   3,459,603    318 So Lake  WA Infrastructure Proj 52,073        44,874          44,911          96,984          96,947          87,974          9,010           326 Housing Opportunity 84,359        ‐                    222               84,581          75,000          ‐                    84,581         336 New Library Development 19,143,344 1,830,836     46,545          19,189,889   20,974,180   1,097,176     18,092,713  ENTERPRISE FUNDS: 402 Airport 331,939      1,264,418     2,316,675     2,648,614     1,432,346     1,354,779     1,293,835    403 Solid Waste Utility 1,523,881   15,700,852   14,800,367   16,324,248   16,177,073   14,047,476   2,276,772    404 Golf Course 291,978      2,453,669     2,156,373     2,448,351     2,476,366     1,937,925     510,426       422 Airport Capital 2,010,985   15,668,122   8,577,820     10,588,805   17,650,611   9,940,229     648,576       424 Golf Course  Capital 247,836      50,000          46,484          294,320        156,482        12,587          281,733       INTERNAL SERVICE FUNDS: 501 Equipment Repair/Replacement 3,722,501   4,261,224     4,020,479     7,742,980     4,295,028     4,060,033     3,682,947    502 Insurance 4,986,807   5,713,764     5,179,249     10,166,056   3,060,718     2,999,229     7,166,827    503 Information Services 1,856,972   4,188,823     3,818,916     5,675,888     5,326,336     3,527,029     2,148,859    504 Facilities 849,472      4,276,112     4,010,950     4,860,422     4,468,879     3,443,090     1,417,332    505 Communications 303,477      877,773        837,925        1,141,402     893,249        778,950        362,452       512 Insurance, Healthcare 7,899,070   9,329,364     9,076,375     16,975,445   10,904,461   9,734,970     7,240,475    522 Insurance, Leoff1 Retirees  HC 6,482,165   1,735,684     1,614,340     8,096,505     1,737,782     960,348        7,136,157    FIDUCIARY FUNDS: 611 Firemen's  Pension 4,556,003   300,000        427,105        4,983,108     240,475        178,147        4,804,961    Funds Balance  01/01/2013 Budgeted  Revenue Revenue  11/30/13 Total Funds  Available Budgeted  Expenditure Expenditure  11/30/13 Ending  Balance ENTERPRISE FUNDS: COMBINED  UTILITIES 20,803,403 57,384,364   48,859,174   69,662,577   60,603,334   39,945,612   29,716,965  405 Water Utility 5,449,029   13,402,096   14,659,327   20,108,356   11,034,019   8,475,914     11,632,442  406 Waste Water Utility 1,363,629   6,758,645     8,385,597     9,749,226     5,505,490     4,562,788     5,186,438    407 Surface Water Utility 2,269,771   7,963,326     8,066,723     10,336,494   6,180,122     4,415,945     5,920,549    416 King  County Metro 1,745,887   15,126,703   14,017,973   15,763,860   15,126,703   13,133,378   2,630,482    425 Water Utility Construction 4,381,380   3,746,643     1,327,106     5,708,486     8,007,000     4,390,151     1,318,335    426 Waste  Water Construction 1,833,105   3,300,000     1,083,286     2,916,391     4,870,000     2,528,982     387,409       427 Surface Water Construction 3,744,703   7,086,951     1,319,123     5,063,826     9,880,000     2,438,454     2,625,372    471 Waterworks  Rate Stabilization 15,899        ‐                    39                 15,938          ‐                    ‐                    15,938         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 46,893,848            39,883,684            7,010,164              22,586,003             June 52,007,692            48,473,829            3,533,864              19,109,703             July 58,496,912            56,535,685            1,961,227              17,537,066             August 64,000,182            64,579,234            (579,052)                14,996,787             September 69,756,998            72,338,457            (2,581,459)             12,994,380             October 86,460,206            81,277,689            5,182,517              20,758,356             November 97,939,274            88,737,144            9,202,130              24,777,969             December 3,000,000  4,000,000  5,000,000  6,000,000  7,000,000  8,000,000  9,000,000  10,000,000  11,000,000  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) (1,000,000) ‐ 1,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,359,402        5,592,172        4.34% Feb 11,478,844      11,590,564      0.97% Mar 16,855,063      17,392,180      3.19% Apr 31,092,707      33,559,062      7.93% May 45,252,914      46,893,848      3.63% Jun 50,278,277      52,007,692      3.44% Jul 56,607,277      58,496,912      3.34% Aug 61,667,555      64,000,182      3.78% Sep 66,738,488      69,756,998      4.52% Oct 80,491,064      86,460,206      7.42% Nov 94,073,001      97,939,274      4.11% Dec 100,856,553     Percent of budget 97.11% 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      16,765,551      1.82% Jun 16,534,715      16,854,032      1.93% Jul 16,753,008      16,954,079      1.20% Aug 16,766,628      17,012,180      1.46% Sep 17,182,454      17,560,252      2.20% Oct 24,590,798      27,701,144      12.65% Nov 31,416,250      32,042,618      1.99% Dec 31,741,366       Percent of budget 100.95% $‐ $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        9,351,345        7.88% Jun 10,307,140      11,088,148      7.58% Jul 11,940,419      12,931,683      8.30% Aug 13,708,668      14,983,749      9.30% Sep 15,384,395      16,931,533      10.06% Oct 17,162,223      18,934,149      10.32% Nov 18,978,733      20,949,122      10.38% Dec 20,723,680       Percent of budget 101.09% 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        6,817,405         ‐6.55% Jun 8,436,312        8,007,252         ‐5.09% Jul 9,806,416        9,266,965         ‐5.50% Aug 10,986,762      10,547,172       ‐4.00% Sep 12,319,071      11,980,466       ‐2.75% Oct 13,472,609      13,053,238       ‐3.11% Nov 14,686,250      14,297,910       ‐2.64% Dec 16,250,662       Percent of budget 87.98% 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,854           325,005           47.83% Feb 386,512           547,949           41.77% Mar 577,616           747,996           29.50% Apr 857,151           1,091,568        27.35% May 1,039,941        1,368,619        31.61% Jun 1,233,639        1,596,317        29.40% Jul 1,546,609        1,891,884        22.32% Aug 1,840,424        2,172,762        18.06% Sep 1,982,247        2,348,691        18.49% Oct 2,367,813        2,788,939        17.79% Nov 2,572,223        3,077,321        19.64% Dec 2,863,828         Percent of budget 107.45% 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,377,678        1,466,833        6.47% Mar 1,687,937        1,933,705        14.56% Apr 2,496,563        2,801,258        12.20% May 4,899,480        5,218,611        6.51% Jun 5,430,762        5,720,394        5.33% Jul 6,203,725        6,584,190        6.13% Aug 6,663,813        7,051,132        5.81% Sep 7,108,467        7,575,466        6.57% Oct 8,270,685        8,682,607        4.98% Nov 10,667,148      11,078,662      3.86% Dec 11,269,061       Percent of budget 98.31% 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 407,503           485,115           19.05% Feb 859,916           1,051,174        22.24% Mar 1,369,614        1,636,717        19.50% Apr 1,960,890        2,321,588        18.39% May 2,514,144        2,949,916        17.33% Jun 3,065,252        3,543,866        15.61% Jul 3,787,273        4,364,049        15.23% Aug 4,478,128        5,084,872        13.55% Sep 4,951,061        5,643,259        13.98% Oct 5,499,477        6,307,022        14.68% Nov 5,985,046        6,854,412        14.53% Dec 6,520,566         Percent of budget 105.12% 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        1,272,471        1.72% Jun 1,563,488        1,541,804         ‐1.39% Jul 1,840,824        1,778,375         ‐3.39% Aug 2,012,121        1,949,941         ‐3.09% Sep 2,188,195        2,104,545         ‐3.82% Oct 2,468,378        2,296,464         ‐6.96% Nov 2,719,947        2,485,876         ‐8.61% Dec 3,058,500         Percent of budget 81.28% $‐ $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,504,949        2,520,946        0.64% Jun 2,978,377        2,903,455         ‐2.52% Jul 3,905,284        3,837,944         ‐1.72% Aug 4,255,988        4,187,979         ‐1.60% Sep 4,566,014        4,509,594         ‐1.24% Oct 5,526,947        5,507,285         ‐0.36% Nov 5,821,308        5,900,050        1.35% Dec 6,313,000         Percent of budget 93.46% 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,080           179,743           10.22% Feb 299,049           256,140            ‐14.35% Mar 383,564           404,049           5.34% Apr 495,399           496,921           0.31% May 607,578           615,640           1.33% Jun 721,417           739,082           2.45% Jul 816,500           867,327           6.23% Aug 947,776           989,980           4.45% Sep 1,048,599        1,082,778        3.26% Oct 1,124,055        1,165,066        3.65% Nov 1,180,896        1,229,012        4.07% Dec 1,861,022         Percent of budget 66.04% $‐ $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 273                   6,974                2454.48% Apr 438                   13,343              2946.36% May 7,167                13,343              86.17% Jun 7,177                13,343              85.91% Jul 7,220                20,415              182.75% Aug 7,248                20,415              181.66% Sep 7,985                20,415              155.66% Oct 8,079                24,292              200.69% Nov 45,201              24,292               ‐46.26% Dec 254,868            Percent of budget 9.53% $‐ $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           1,108,012        26.98% Jun 1,193,556        1,455,902        21.98% Jul 1,358,006        1,719,709        26.63% Aug 1,564,134        2,013,764        28.75% Sep 1,724,294        2,268,082        31.54% Oct 2,025,764        2,540,858        25.43% Nov 2,367,976        2,883,394        21.77% Dec 2,600,000         Percent of budget 110.90% Bldg Permits  & Devlpmt Svc YTD Annual %  $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  Millions Real Estate Excise Tax Budget Actual Last Year Millions Building Permits and Development Service  Fees Budget Actual over (under) Jan 150,030           327,644           118.39% Feb 332,264           557,749           67.86% Mar 569,542           862,909           51.51% Apr 812,611           1,230,194        51.39% May 1,049,592        1,616,989        54.06% Jun 1,295,001        1,910,374        47.52% Jul 1,573,793        2,225,870        41.43% Aug 1,921,143        2,566,205        33.58% Sep 2,075,833        2,821,074        35.90% Oct 2,460,061        3,261,353        32.57% Nov 2,722,293        3,654,661        34.25% Dec 3,123,413         Percent of budget 117.01% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  Millions 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,463,801        7,563,322        1.33% Feb 16,259,347      15,996,818       ‐1.61% Mar 23,771,912      23,413,342       ‐1.51% Apr 32,103,134      31,631,530       ‐1.47% May 40,743,889      39,883,684       ‐2.11% Jun 49,545,186      48,473,829       ‐2.16% Jul 57,808,775      56,535,685       ‐2.20% Aug 65,993,240      64,579,234       ‐2.14% Sep 73,894,837      72,338,457       ‐2.11% Oct 83,113,053      81,277,689       ‐2.21% Nov 90,780,304      88,737,144       ‐2.25% Dec 105,715,391     Percent of budget expended 83.94% 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           121,071           0.77% Jun 144,309           145,113           0.56% Jul 168,859           169,210           0.21% Aug 192,896           192,361            ‐0.28% Sep 217,082           216,073            ‐0.46% Oct 241,441           239,890            ‐0.64% Nov 265,573           263,960            ‐0.61% Dec 290,291            Percent of budget expended 90.93% $‐ $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           528,321           2.21% Jun 623,960           614,036            ‐1.59% Jul 735,658           718,411            ‐2.34% Aug 847,425           824,425            ‐2.71% Sep 953,811           919,138            ‐3.64% Oct 1,064,489        1,023,885         ‐3.81% Nov 1,170,013        1,121,750         ‐4.13% Dec 1,322,364         Percent of budget expended 84.83% YTD Annual %  $‐ $0.30  $0.60  $0.90  $1.20  $1.50  Millions Executive Budget Actual Last Year $2 40 Millions City Attorney City Attorney Budget Actual 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           724,478            ‐7.96% Jun 947,880           872,824            ‐7.92% Jul 1,105,337        1,013,090         ‐8.35% Aug 1,263,381        1,157,082         ‐8.41% Sep 1,421,095        1,315,727         ‐7.41% Oct 1,593,003        1,460,487         ‐8.32% Nov 1,749,576        1,604,675         ‐8.28% Dec 1,915,103         Percent of budget expended 83.79% $‐ $0.40  $0.80  $1.20  $1.60  $2.00  $2.40 Budget Actual Last Year Page 23 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Court Services Budget YTD Actual Annual %  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           795,263            ‐3.49% Jun 1,016,165        978,124            ‐3.74% Jul 1,185,948        1,141,510         ‐3.75% Aug 1,354,731        1,302,458         ‐3.86% Sep 1,519,505        1,468,967         ‐3.33% Oct 1,684,389        1,633,316         ‐3.03% Nov 1,852,716        1,793,783         ‐3.18% Dec 2,026,149         Percent of budget expended 88.53% YTD Annual %  $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  $2.00  $2.20  Millions Court Services Budget Actual Last Year Millions Community & Economic Dl Ad iCED Admin Budget Actual 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           428,857            ‐0.02% Jun 513,272           514,481           0.24% Jul 597,689           600,318           0.44% Aug 682,197           685,933           0.55% Sep 766,581           771,885           0.69% Oct 850,349           858,042           0.90% Nov 934,318           943,428           0.98% Dec 1,020,208         Percent of budget expended 92.47% $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  Millions Development Admin Budget Actual Last Year Page 24 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Development  Services Budget YTD Actual Annual %  over (under) Jan 267,446           272,362           1.84% Feb 540,517           515,474            ‐4.63% Mar 813,155           768,135            ‐5.54% Apr 1,086,172        1,060,776         ‐2.34% May 1,379,682        1,319,207         ‐4.38% Jun 1,645,056        1,589,997         ‐3.35% Jul 1,929,849        1,867,544         ‐3.23% Aug 2,201,921        2,165,714         ‐1.64% Sep 2,488,019        2,425,328         ‐2.52% Oct 2,780,951        2,704,130         ‐2.76% Nov 3,065,780        2,973,668         ‐3.00% Dec 3,358,299         Percent of budget expended 88.55% Economic YTD Annual %  $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  Millions Development Services Budget Actual Last Year Millions Economic Development Development Budget Actual 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           175,487            ‐28.67% Jun 290,316           211,913            ‐27.01% Jul 339,634           254,764            ‐24.99% Aug 384,572           300,522            ‐21.86% Sep 428,840           341,333            ‐20.41% Oct 472,869           380,375            ‐19.56% Nov 524,583           412,147            ‐21.43% Dec 570,280            Percent of budget expended 72.27% $‐ $0.10  $0.20  $0.30  $0.40  $0.50  $0.60  Millions Budget Actual Last Year Page 25 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Planning Budget YTD Actual Annual %  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           603,248            ‐4.31% Jun 748,996           728,944            ‐2.68% Jul 870,176           856,640            ‐1.56% Aug 1,024,050        993,017            ‐3.03% Sep 1,159,558        1,133,145         ‐2.28% Oct 1,279,389        1,256,275         ‐1.81% Nov 1,405,692        1,382,280         ‐1.67% Dec 1,541,592         Percent of budget expended 89.67% YTD Annual % $2 40 Millions Finance $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  Millions Planning Budget Actual Last Year Finance Budget Actual 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           775,564            ‐4.90% Jun 991,610           942,750            ‐4.93% Jul 1,157,861        1,123,823         ‐2.94% Aug 1,335,063        1,312,345         ‐1.70% Sep 1,499,653        1,491,143         ‐0.57% Oct 1,643,469        1,649,170        0.35% Nov 1,786,254        1,799,155        0.72% Dec 2,242,682         Percent of budget expended 80.22% $‐ $0.40  $0.80  $1.20  $1.60  $2.00  $2.40 Budget Actual Last Year Page 26 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year City Clerk Budget YTD Actual Annual %  over (under) Jan 72,010              61,226               ‐14.97% Feb 144,148           123,564            ‐14.28% Mar 223,753           202,364            ‐9.56% Apr 361,399           277,252            ‐23.28% May 435,793           581,575           33.45% Jun 507,931           636,188           25.25% Jul 710,263           692,263            ‐2.53% Aug 788,236           765,703            ‐2.86% Sep 863,409           830,214            ‐3.84% Oct 937,218           894,171            ‐4.59% Nov 1,017,649        955,952            ‐6.06% Dec 1,101,505         Percent of budget expended 86.79% Includes Hearing Examiner Human YTD Annual % $1 00 Millions Human Resources $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  Millions City Clerk Budget Actual Last Year Resources Budget Actual 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           357,200            ‐6.70% Jun 469,447           439,470            ‐6.39% Jul 552,148           510,868            ‐7.48% Aug 635,001           583,333            ‐8.14% Sep 713,975           658,189            ‐7.81% Oct 797,946           733,652            ‐8.06% Nov 885,037           815,257            ‐7.88% Dec 977,094            Percent of budget expended 83.44% $‐ $0.20  $0.40  $0.60  $0.80  $1.00  Budget Actual Last Year Page 27 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Police Budget YTD Actual Annual %  over (under) Jan 2,428,964        2,521,995        3.83% Feb 4,822,823        4,737,466         ‐1.77% Mar 7,238,322        7,196,803         ‐0.57% Apr 9,709,330        9,460,145         ‐2.57% May 11,923,689      11,645,035       ‐2.34% Jun 14,548,208      14,265,277       ‐1.94% Jul 17,149,272      16,827,604       ‐1.88% Aug 19,396,212      19,071,306       ‐1.68% Sep 21,809,144      21,624,322       ‐0.85% Oct 24,192,123      23,852,347       ‐1.40% Nov 26,605,420      26,327,574       ‐1.04% Dec 29,129,201       Percent of budget expended 90.38% Fire &  Emergency YTD Annual %  $‐ $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  Millions Police Budget Actual Last Year $24 Millions Fire & Emergency Services Services Budget Actual over (under) Jan 1,889,418        2,045,002        8.23% Feb 4,533,817        4,729,656        4.32% Mar 6,447,897        6,673,347        3.50% Apr 8,338,322        8,636,731        3.58% May 10,511,037      10,518,427      0.07% Jun 12,419,816      12,459,420      0.32% Jul 14,337,761      14,457,407      0.83% Aug 16,384,640      16,390,199      0.03% Sep 18,359,431      18,346,018       ‐0.07% Oct 20,275,751      20,390,546      0.57% Nov 22,207,188      22,411,736      0.92% Dec 24,197,056       Percent of budget expended 92.62% $‐ $3  $6  $9  $12  $15  $18  $21  $24  Budget Actual Last Year Page 28 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Community  Services Admin Budget YTD Actual Annual %  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           187,590           0.93% Jun 222,528           225,313           1.25% Jul 259,410           262,830           1.32% Aug 295,998           299,975           1.34% Sep 332,176           336,859           1.41% Oct 367,946           373,747           1.58% Nov 405,451           414,255           2.17% Dec 450,911            Percent of budget expended 91.87% YTD Annual % $4 50 Millions Parks $‐ $0.05  $0.10  $0.15  $0.20  $0.25  $0.30  $0.35  $0.40  $0.45  $0.50  Millions Community Services Admin Budget Actual Last Year Parks Budget Actual 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        1,515,905         ‐1.84% Jun 1,894,848        1,862,252         ‐1.72% Jul 2,261,158        2,236,956         ‐1.07% Aug 2,638,492        2,631,293         ‐0.27% Sep 3,030,537        3,002,198         ‐0.94% Oct 3,420,829        3,373,623         ‐1.38% Nov 3,789,095        3,703,721         ‐2.25% Dec 4,153,621         Percent of budget expended 89.17% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50 Budget Actual Last Year Page 29 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Parks Planning  and Natural  Resources Budget YTD Actual Annual %  over (under) Jan 58,219              42,639               ‐26.76% Feb 117,758           88,359               ‐24.97% Mar 193,484           142,461            ‐26.37% Apr 264,742           196,871            ‐25.64% May 353,686           258,947            ‐26.79% Jun 439,691           310,633            ‐29.35% Jul 513,977           370,751            ‐27.87% Aug 589,503           428,676            ‐27.28% Sep 673,988           484,402            ‐28.13% Oct 766,574           545,724            ‐28.81% Nov 852,923           601,585            ‐29.47% Dec 934,005            Percent of budget expended 64.41% YTD Annual %  $‐ $0.10  $0.20  $0.30  $0.40  $0.50  $0.60  $0.70  $0.80  $0.90  $1.00  Millions Parks Planning and Natural Resources Budget Actual Last Year $6 Millions Recreation Recreation Budget Actual 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        1,698,203         ‐6.20% Jun 2,195,700        2,075,334         ‐5.48% Jul 2,787,526        2,696,025         ‐3.28% Aug 3,446,454        3,343,858         ‐2.98% Sep 3,960,958        3,822,962         ‐3.48% Oct 4,343,623        4,151,697         ‐4.42% Nov 4,714,526        4,472,957         ‐5.12% Dec 5,130,300         Percent of budget expended 87.19% $‐ $1  $2  $3  $4  $5  $6  Budget Actual Last Year Page 30 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Human  Services Budget YTD Actual Annual %  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           431,038            ‐10.07% Jun 542,375           496,606            ‐8.44% Jul 674,923           628,351            ‐6.90% Aug 744,460           695,514            ‐6.57% Sep 805,315           749,137            ‐6.98% Oct 959,873           883,276            ‐7.98% Nov 1,030,967        962,149            ‐6.68% Dec 1,196,052         Percent of budget expended 80.44% Neighborhoods , Resources, YTD Annual %  $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  Millions Human Services Budget Actual Last Year $1 00 Millions Neighborhoods, Resources, and Events and Events Budget Actual 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           288,076            ‐3.47% Jun 378,699           362,006            ‐4.41% Jul 470,110           447,998            ‐4.70% Aug 555,842           518,531            ‐6.71% Sep 632,165           582,563            ‐7.85% Oct 703,188           638,898            ‐9.14% Nov 803,370           703,994            ‐12.37% Dec 914,955            Percent of budget expended 76.94% $‐ $0.10  $0.20  $0.30  $0.40  $0.50  $0.60  $0.70  $0.80  $0.90  $1.00  Budget Actual Last Year Page 31 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Library Fund Budget YTD Actual Annual %  over (under) Jan ‐                          ‐                         N/A Feb ‐                          ‐                         N/A Mar ‐                          ‐                         N/A Apr ‐                          ‐                         N/A May ‐                          ‐                         N/A Jun ‐                          ‐                         N/A Jul ‐                          ‐                         N/A Aug ‐                          ‐                         N/A Sep ‐                          ‐                         N/A Oct ‐                          ‐                         N/A Nov ‐                          ‐                         N/A Dec ‐                          Percent of budget expended N/A YTD Annual %  $‐ $0.05  $0.10  $0.15  $0.20  $0.25  $0.30  Millions Library Fund Budget Actual Last Year $240 000 Museum Fund Museum Fund Budget Actual 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              87,136               ‐0.25% Jun 105,057           104,728            ‐0.31% Jul 122,568           122,060            ‐0.41% Aug 140,200           139,638            ‐0.40% Sep 158,058           157,141            ‐0.58% Oct 175,778           174,718            ‐0.60% Nov 193,585           192,315            ‐0.66% Dec 211,080            Percent of budget expended 91.11% $‐ $30,000  $60,000  $90,000  $120,000  $150,000  $180,000  $210,000  $240,000  Budget Actual Last Year Page 32 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Public Works  Admin Budget YTD Actual Annual %  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           202,081           0.30% Jun 241,508           237,314            ‐1.74% Jul 281,724           269,323            ‐4.40% Aug 322,247           301,882            ‐6.32% Sep 363,226           333,688            ‐8.13% Oct 402,909           364,742            ‐9.47% Nov 442,662           395,530            ‐10.65% Dec 483,035            Percent of budget expended 81.88% Street YTD Annual %  $‐ $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  $350,000  $400,000  $450,000  $500,000  Public Works Admin Budget Actual Last Year $5 00 Millions Street Maintenance Maintenance Budget Actual 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        1,600,743         ‐8.86% Jun 2,128,477        1,924,036         ‐9.61% Jul 2,485,951        2,229,390         ‐10.32% Aug 2,826,956        2,532,782         ‐10.41% Sep 3,174,309        2,856,379         ‐10.02% Oct 3,531,791        3,185,461         ‐9.81% Nov 3,898,668        3,497,441         ‐10.29% Dec 4,294,894         Percent of budget expended 81.43% $‐ $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 33 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Transportation Budget YTD Actual Annual %  over (under) Jan 299,590           311,908           4.11% Feb 677,729           670,659            ‐1.04% Mar 1,055,244        1,074,529        1.83% Apr 1,434,200        1,512,690        5.47% May 1,803,617        1,819,302        0.87% Jun 2,165,731        2,113,464         ‐2.41% Jul 2,562,459        2,490,033         ‐2.83% Aug 2,933,871        2,933,793        0.00% Sep 3,312,264        3,219,909         ‐2.79% Oct 3,700,291        3,582,655         ‐3.18% Nov 4,085,694        3,894,267         ‐4.69% Dec 4,579,081         Percent of budget expended 85.04% YTD Annual % $10 Millions Debt Service $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0 $4.5 $5.0 Millions Transportation Budget Actual Last Year Debt Service Budget Actual 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 835,676           835,676           0.00% Jun 1,776,589        1,776,589        0.00% Jul 1,808,239        1,808,239        0.00% Aug 2,058,556        2,058,556        0.00% Sep 2,058,808        2,058,808        0.00% Oct 3,562,890        3,562,890        0.00% Nov 3,562,890        3,562,890        0.00% Dec 8,034,283         Percent of budget expended 44.35% $‐ $1  $2  $3  $4  $5  $6  $7  $8  $9  $10  Budget Actual Last Year Page 34 of 37 City of Renton Monthly Expenditure Analysis ‐ 2013 Budget Year Non‐ Departmental  Other City Budget YTD Actual Annual %  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 2,385,254        2,385,254        0.00% Jun 2,587,016        2,587,016        0.00% Jul 2,740,276        2,740,276        0.00% Aug 2,950,337        2,950,337        0.00% Sep 3,192,930        3,192,930        0.00% Oct 3,363,972        3,363,972        0.00% Nov 3,530,675        3,530,675        0.00% Dec 5,641,350         Percent of budget expended 62.59% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00  $5.50  $6.00  Millions Non‐Departmental Other City Services 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      27,540,401    22,717,408     Jun 29,148,341      33,144,751    28,759,364     Jul 35,053,685      39,459,369    34,603,156     Aug 40,236,656      46,050,162    39,527,809     Sep 45,248,315      51,921,474    45,278,284     Oct 51,131,985      58,226,205    49,431,907     Nov 56,094,010      63,659,500    53,993,089     Dec 76,780,407       Percent of budget expended 67.57% Note:  Operations and Capital $0 $10 $20 $30 $40 $50 $60 $70 $80 $90 Millions Utilities Budget Revenue Expense $25 00 Millions Airport Airport Budget Revenue Expense Jan 952,240           197,380          132,655           Feb 2,122,025        816,583          272,568           Mar 3,125,407        1,033,561      551,940           Apr 4,353,586        1,326,892      679,773           May 5,959,035        1,542,344      1,344,469       Jun 8,128,195        2,240,528      2,131,340       Jul 9,129,859        3,029,040      3,486,489       Aug 10,602,682      4,424,167      7,184,207       Sep 11,598,621      7,702,430      7,576,205       Oct 13,711,677      10,060,354    11,110,481     Nov 14,718,494      10,894,495    11,295,008     Dec 19,082,957       Percent of budget expended 59.19% Note:  Operations and Capital $‐ $5.00  $10.00  $15.00  $20.00  $25.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           747,089          721,090           Jun 1,133,021        1,010,936      914,581           Jul 1,331,819        1,404,992      1,099,310       Aug 1,513,051        1,694,229      1,422,736       Sep 1,688,936        1,982,981      1,659,746       Oct 1,864,635        2,121,991      1,810,203       Nov 2,024,142        2,202,856      1,950,512       Dec 2,632,848         Percent of budget expended 74.08% 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