Loading...
HomeMy WebLinkAbout201010, October.pdfFINANCE AND  INFORMATION TECHNOLOGY    M   E   M   O   R   A   N   D   U   M       DATE: November 18, 2010    TO: Don Persson, Council President  Members of the Renton City Council     CC: Denis Law, Mayor  Administrators     FROM: Iwen Wang, FIT Administrator     SUBJECT: October 2010 Financial Status Report       At the end of October, general governmental revenues show $110k or 0.1% under budget.  This  includes a $1.8 million favorable property tax collection but otherwise almost all other revenue  categories are under performing.  Unfortunately, the favorable property tax collection is due to  the timing of receipting 2009 October and November property taxes in 2009, which we use to  calculate the 2010 October and November budgeted amounts.  Without the favorable property  tax, revenues are $1.9 million or 2.3% below budget.  This is compared with the $1.6 million  and 2.1% short fall at the end of September.  For the year, we are still expecting a total sales tax  collection to underperform the budget by $1.5 million, gambling tax by $495k, court fines by  $152k, real estate excise tax by $251k, and recreation fees by $146k; for a combined $2.5  million of lower than expected revenue in 2010.    On the expenditures’ side, other than a couple of minor exceptions, all departments are  conserving their spending and are showing favorable variances.  Overall general governmental  funds are showing a 3.2% or $2.8 million savings.  Part of the savings is due to the timing of  certain lump sum payments which are not due until the last quarter of the year, such as  principal payments on the City’s general obligation debts, banking fees, and voter  registration/election costs.  In addition to the timing of disbursements, there is also a risk of  over expenditure in certain areas.  The amount budgeted for 2010 is below the actual cost in  2009 compounded by a rate increase that took effect earlier this year and will likely push the  street lighting costs over budget.  Another risk factor is the potentially more severe winter  weather conditions.  Therefore, while we do expect expenditure savings this year, we project it  will be less than the current level.     The attached report provides more detailed discussion of each revenue sources and our  updated projections for the year.  Please do not hesitate to contact me at x6858 or Hai Nguyen  at x6952 should you have any questions or any suggestions about the report.      General Governmental Funds $% Beginning Fund Balance 13,300,854$       13,300,854$       11,816,561$       11,816,561$       11,955,285$       11,955,285$       11,955,285$       ‐$                   0.0% OPERATING REVENUES Property Tax 29,050,790          21,313,378          30,660,522          22,040,882          31,364,643          22,547,053          24,338,474          1,791,422      7.9% Sales  Tax 20,825,055          16,691,837          17,995,836          15,043,188          18,609,000          15,448,599          14,286,571          (1,162,028)    ‐7.5% Sales  Tax ‐ Annexation  Credit ‐                              ‐                              2,132,110             1,784,145             2,248,000             1,881,122             1,682,805             (198,317)         ‐10.5% Criminal Justice Sales  Tax 1,755,469             1,440,158             1,650,350             1,371,232             1,743,000             1,448,213             1,342,404             (105,809)          ‐7.3% Natural Gas Use  Tax 253,377                  214,611                  242,891                  202,662                  ‐                              ‐                              197,823                  197,823          100.0% Admission  Tax 197,740                  197,740                  260,269                  259,749                  260,000                  259,480                  290,937                  31,457             12.1% Franchise Fees 998,288                  955,811                  1,039,031             1,039,031             1,040,000             1,018,317             1,177,275             158,959          15.6% Electricity Tax 4,580,037             3,766,507             4,963,151             4,130,917             5,150,000             4,286,435             4,132,699             (153,736)         ‐3.6% Gas  Tax 1,565,810             1,284,978             1,891,255             1,623,688             1,858,000             1,595,138             1,273,974             (321,164)         ‐20.1% Transfer  Station 380,961                  311,744                  283,985                  204,686                  230,000                  165,776                  238,487                  72,711             43.9% TV Cable 1,073,168             869,443                  1,263,743             1,039,162             1,250,000             1,027,862             1,138,067             110,205          10.7% Telephone 1,032,048             856,381                  1,037,873             850,792                  960,000                  786,955                  860,359                  73,404             9.3% Cellular Phone 1,748,147             1,442,466             2,027,473             1,639,721             1,900,000             1,536,627             1,848,037             311,409          20.3% City Utilities 2,606,786             2,082,272             2,871,599             2,416,173             2,880,000             2,423,241             2,393,944             (29,297)            ‐1.2% Leasehold Excise  Tax 190,644                  156,855                  146,002                  104,957                  100,000                  71,887                     104,082                  32,195             44.8% Gambling Excise  Tax 2,157,029             1,626,212             2,141,720             1,856,781             2,000,000             1,733,916             1,305,148             (428,768)         ‐24.7% Real Estate Excise  Tax 2,800,103             2,431,360             2,418,456             2,074,791             2,400,000             2,058,960             1,843,473             (215,487)         ‐10.5% Less: Municipal  Facilities CIP REET (450,103)                (183,564)                (1,000,000)            (1,006,533)            (400,000)                (402,613)                (400,000)                2,613                 ‐0.6% EMS Levy 890,998                  689,685                  1,170,657             975,548                  897,095                  870,794                  870,794                  ‐                      0.0% Business  License Fees 485,537                  454,426                  424,413                  401,554                  463,067                  438,126                  407,410                  (30,716)            ‐7.0% Other Licenses and Permits 257,477                  224,739                  176,851                  140,889                  157,250                  125,274                  203,462                  78,188             62.4% Building Permits 2,034,225             1,764,021             1,683,082             1,395,223             1,766,059             1,464,008             1,364,307             (99,701)            ‐6.8% Intergovernmental (Grants, etc)3,734,887             2,431,177             3,820,932             3,390,259             4,507,080             3,696,624             3,696,624             ‐                      0.0% Fire District 25 and 40 Contracts 5,013,549             2,510,970             5,869,198             3,050,973             5,554,723             2,770,532             2,770,532              ‐                      0.0% Records, Duplicating, and Passport Fees 176,950                  155,126                  187,721                  144,653                  217,585                  167,665                  167,398                  (267)                    ‐0.2% Public Safety 524,565                  437,091                  521,484                  446,824                  430,000                  368,438                  384,944                  16,506             4.5% Development Service Fees 903,768                  784,892                  677,955                  508,675                  869,683                  652,530                  777,403                  124,874          19.1% Culture and Recreation 1,678,818             1,542,102             1,631,486             1,495,673             1,572,240             1,441,359             1,307,790             (133,569)         ‐9.3% Interfund/Interdept‐Services 3,072,950             2,446,421             3,225,745             2,670,992             3,335,677             2,762,018             2,651,099             (110,920)         ‐4.0% Fines  and Forfeits 1,057,797             881,713                  1,349,034             1,049,597             1,196,500             930,920                  995,201                  64,281             6.9% Photo Enforcement 803,111                  346,180                  2,368,131             1,931,597             2,250,000             1,835,242             1,558,745             (276,497)         ‐15.1% Seizure Funds  ‐ Federal/State/Local 250,065                  127,710                  99,844                     93,913                     130,693                  122,930                  214,093                  91,163             74.2% Interests and Other Earnings 735,910                  601,658                  535,314                  463,195                  434,300                  375,790                  280,012                  (95,778)             ‐25.5% Rents, Leases, and Concessions 676,919                  604,605                  677,960                  610,157                  720,780                  648,694                  666,168                  17,474             2.7% Contributions and Donations 175,513                  155,757                  150,406                  120,210                  111,900                  89,435                     127,729                  38,295             42.8% Other Miscellaneous 67,355                     74,327                     168,567                  68,940                     111,000                  45,396                     84,312                     38,916             85.7% Refunding Debt and Premiums ‐                              ‐                              ‐                              ‐                              6,613,483             6,613,484             6,613,484             ‐                      0.0% Transfer‐In 381,364                  66,541                     577,004                  537,174                  652,398                  652,398                  652,398                   ‐                      0.0% Total  Operating Revenues 93,687,106          71,757,332          97,342,052          76,172,071          105,584,156       83,958,624          83,848,462          (110,162)         ‐0.1% OPERATING EXPENDITURES Legislative 245,441                  207,134                  247,225                  205,705                  267,957                  224,540                  214,315                  10,224             4.6% City Attorney 1,661,225             1,370,440             1,248,380             1,114,442             1,621,295             1,384,630             1,306,058             78,572             5.7% City Clerk 604,844                  504,700                  646,581                  545,731                  931,014                  781,482                  685,906                  95,576             12.2% Court Services 1,744,122             1,437,973             1,819,731             1,526,494             2,016,361             1,677,240             1,657,900             19,340             1.2% Executive 966,373                  806,820                  1,499,747             1,259,757             1,635,047             1,370,148             1,322,666             47,482             3.5% Hearing Examiner 166,820                  138,823                  171,911                  143,323                  200,440                  166,957                  144,975                  21,982             13.2% Community and Eco  Dvlpmnt Admin ‐                              ‐                              265,269                  223,559                  646,149                  544,550                  531,045                  13,505             2.5% Development Services 4,178,096             3,407,498             3,615,129             3,043,090             3,035,683             2,555,332             2,409,433             145,899          5.7% Economic Development 1,875,749             1,564,957             1,244,175             1,039,705             1,383,047             1,154,634             1,079,397             75,237             6.5% Planning ‐                              ‐                              1,525,460             1,222,164             1,834,707             1,528,923             1,513,880             15,042             1.0% Finance 1,909,652             1,596,485             1,969,936             1,687,645             2,164,890             1,832,612             1,562,272             270,340          14.8% Human Resources 981,306                  841,305                  853,063                  703,950                  918,169                  773,457                  710,580                  62,877             8.1% Police 23,894,898          19,228,288          25,833,756          21,166,303          28,022,582          22,762,746          22,423,952          338,793          1.5% Fire 21,763,640          17,685,486          20,375,286          17,053,966          21,922,009          18,072,568          17,883,348          189,220          1.0% Community Services  Admin 1 1,078,884             915,642                  4,549,381             3,729,757             958,648                  791,239                  886,316                  (95,077)             ‐12.0% Facilities 3,614,850             2,929,553              ‐                              (242)                            ‐                               ‐                               ‐                               ‐                      0.0% Parks 4,892,441             4,029,521             4,820,336             4,004,941             4,584,001             3,791,910             3,461,202             330,707          8.7% Parks Planning & Natural  Resources ‐                               ‐                               ‐                               ‐                              545,943                  454,952                  364,453                  90,499             19.9% Recreation 3,304,279             2,768,815             3,329,077             2,809,440             4,028,463             3,387,696             3,093,550             294,146          8.7% Human Services 1,162,553             931,093                  1,194,142             944,494                  1,406,586             1,119,438             1,015,658             103,780          9.3% Community Resources  & Events 367,627                  261,843                  348,185                  252,448                  375,694                  269,926                  251,804                  18,121             6.7% Library 1,890,886             1,572,381             2,312,128             1,687,415             2,607,263             2,280,221             2,280,221             ‐                      0.0% Museum 136,327                  116,398                  140,801                  118,644                  194,120                  164,641                  159,284                  5,357                3.3% Public Works Administration 886,867                  778,616                  463,533                  392,832                  518,399                  449,701                  429,145                  20,556             4.6% Street Maintenance 3,212,111             2,526,221             3,794,716             3,199,055             3,385,704             2,766,457             2,813,270             (46,812)            ‐1.7% Technical Services 515,708                  435,974                  478,493                  391,289                  ‐                              ‐                              ‐                              ‐                      0.0% Transportation 4,841,955             3,908,768             5,110,639             4,270,922             5,164,058             4,315,563             4,264,455             51,109             1.2% Debt Service 4,263,739             1,258,539             4,176,822             1,165,568             4,494,945             1,303,814             1,303,814             ‐                      0.0% Payment of LTGO Refunding Debt ‐                              ‐                              ‐                              ‐                              6,613,194             6,613,194             6,613,194             ‐                      0.0% Non‐Departmental and Other 5,011,007             3,778,070             5,169,426             3,402,070             4,817,981             3,398,066             2,787,312             610,754          18.0% Total  Operating Expenditures 95,171,399          75,001,341          97,203,328          77,304,467          106,294,348       85,936,635          83,169,404          2,767,231      3.2% Total  Ending Fund Balance 11,816,561$       10,056,844$       11,955,285$       10,684,166$       11,245,093$       9,977,273$          12,634,343$       2,657,070      26.6% 1Facilities was included in Community Services  Admin  in 2009 Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable) 2008 2009 2010 Variance Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual Monthly Financial Report October 2010 Page 1 of 35 Monthly Financial Report October 2010          OVERVIEW  This financial overview reflects the City’s overall financial position for the fiscal year through October 31, 2010.  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 tax, sales/use tax, utility tax, gambling, admissions, and real estate excise tax  represents 69% of all resources supporting general governmental activities.   The following section provides detail  information on property, sales, utility, and other taxes.    Property Tax  October’s collection is $7.1 million,  making the total year‐to‐date  collection $24.3 million or 78% of  the total budget.  In comparison to  the previous year, the City  collected $2.3 million or 10% more.   Compared to the budget, the City is  above projections by $1.8 million  or 8%.  The large difference is due  to the amounts receipted in 2009  for October and November.  Since  the City receipted more of the  second half of property taxes in  November than October of 2009,  the 2010 monthly budget is  skewed.  Based on distribution we  have received in November ($7.4 million), we are projecting property tax collections to meet the projections at year end.            Sales Tax  October 2010 sales tax receipts  totaled $1.4 million.  Compared to  the same month last year, it is $113k  or 7% less.  Compared to the  projected current month’s budget, it  is below projections by $163k or  10%.  The year‐to‐date collection is  $14.3 million or 77% of the sales tax  budget.  This is $757k less than last  year and $1.2 million below budget.   Based on the year‐to‐date collection,  the City is projecting sales tax  revenues to be $17.1 million by the  end of 2010, which is $1.5 million or  8% under budget.      2009 2010 2010 Actual Budget Actual $ % $ % Jan 9,419$               9,635$               51,304$            41,885$         445% 41,669$         432% Feb 303,513            310,483            438,210            134,696         44% 127,727         41% Mar 647,845            662,723            547,632            (100,213)         ‐15% (115,091)         ‐17% Apr 8,063,214        8,248,386        6,660,829        (1,402,385)   ‐17% (1,587,557)   ‐19% May 6,711,943        6,866,083        8,736,691        2,024,747     30% 1,870,608     27% Jun 113,279            115,881            114,982            1,703               2% (899)                   ‐1% Jul 104,757            107,163            87,952               (16,805)            ‐16% (19,211)            ‐18% Aug 66,589               68,118               149,160            82,571            124% 81,042            119% Sep 250,296            256,044            491,642            241,346         96%235,598         92% Oct 5,770,027        5,902,536        7,060,074        1,290,046     22% 1,157,538     20% Nov 8,275,695        8,465,747         Dec 343,945            351,844             YTD  Total 22,040,882$  22,547,053$  24,338,474$  2,297,592$  10% 1,791,422$  8% Annual Total 30,660,522$  31,364,643$   Property Tax Revenues Year  to Date through October 2010 vs. 2009 2010 vs. Budget Month 2009 2010 2010 Actual Budget Actual $ % $ % Jan 1,458,072$     1,459,527$     1,289,364$     (168,709)$   ‐12% (170,163)$       ‐12% Feb 1,863,430        1,834,595        1,728,588        (134,842)      ‐7% (106,007)          ‐6% Mar 1,461,007        1,324,674        1,289,589        (171,418)      ‐12% (35,085)             ‐3% Apr 1,398,021        1,367,908        1,461,123        63,103         5% 93,215              7% May 1,490,778        1,603,693        1,499,335        8,557            1% (104,359)          ‐7% Jun 1,361,808        1,464,336        1,382,049        20,241         1% (82,288)             ‐6% Jul 1,443,891        1,547,213        1,309,429        (134,462)      ‐9% (237,785)          ‐15% Aug 1,551,415        1,662,544        1,470,881        (80,535)         ‐5% (191,663)          ‐12% Sep 1,454,550        1,573,534        1,408,876        (45,674)        ‐3% (164,658)          ‐10% Oct 1,560,217        1,610,574        1,447,338        (112,879)      ‐7% (163,236)          ‐10% Nov 1,440,143        1,636,255         ‐                         Dec 1,512,506        1,524,146         ‐                         YTD  Total 15,043,188$  15,448,599$  14,286,571$  (756,617)$  ‐5% (1,162,028)$  ‐8% Annual Total 17,995,836$  18,609,000$   2010 vs. Budget2010 vs. 2009 Month Year  to Date through October Local Retail Sales  Tax Revenues Page 2 of 35 Monthly Financial Report October 2010        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 2009 2010 Bgt YTD  Act Change 2010/2009 2010 Act vs  Bgt New Construction 2,482,182$     2,329,934$     1,860,961$     (621,220)$    ‐25%$      (468,973)‐20% Auto  Sales 2,736,842        2,851,135        2,513,520        (223,322)       ‐8%         (337,616)‐12% General  Retail 4,879,322        5,043,315        5,002,075        122,753       3%            (41,240)‐1% Manufacturing 789,323            783,022            633,348            (155,975)       ‐20%         (149,675)‐19% Wholesale 789,527            828,520            771,420            (18,107)          ‐2%            (57,100)‐7% Service 2,979,442        3,145,049        3,063,765        84,323          3%            (81,283)‐3% Other 386,550            467,624            441,482            54,932          14%            (26,142)‐6% Total 15,043,188$  15,448,599$  14,286,571$  (756,617)      ‐5%(1,162,028)$  ‐8% Note: Excludes Annexation Credit and Criminal Justice Sales  Tax revenue.      Utility tax  October utility tax revenues are $1.1  million, which is $59k or 5% higher than  the same month last year and ahead of  the budget by $85k or 8%.  The year‐to‐ date collection of $12.1 million is above  the budget by $269k or 2% but is $24k  below 2009.  The unfavorable  comparisons in January and February  are primarily due to higher than normal  electrical and natural gas consumptions  during winter months in 2009 that  distorted the budget for these two  months.  At this time, the City is  projecting utility tax revenues to meet  our 2010 budget by year‐end.      The table below breaks out Utility Tax by source, the lower amount generated from Natural Gas is due to warmer  temperatures in the 1st quarter of 2010 than 2009:    Utility Tax by Type 2009 2010 Bgt YTD  Act Change 2010/2009  2010 Act  vs  Bgt  Electrical 4,130,917$     4,286,435$     4,132,699$     1,782$          0%$      (153,736)‐4% Natural  Gas 1,826,351        1,595,138        1,471,797        (354,554)       ‐19%         (123,342)‐8% Cell 1,639,721        1,536,627        1,848,037        208,315       13%           311,409 20% Phone 850,792            786,955            860,359            9,567             1%              73,404 9% Cable 1,039,162        1,027,862        1,138,067        98,905          10%           110,205 11% Transfer  Station 204,686            165,776            238,487            33,801          17%              72,711 44% City Utilities 2,416,173        2,423,241        2,393,944        (22,228)          ‐1%            (29,297)‐1% YTD  Total 12,107,801$  11,813,890$  12,083,388$  (24,413)$      0%261,354$        2% Annual Total 14,581,971$  14,228,000$   YTD as % of 83% 83%      2009 2010 2010 Actual Budget Actual $ % $ % Jan 1,413,641$     1,379,325$      1,282,930$     (130,711)$   ‐9% (96,395)$    ‐7% Feb 1,485,870        1,449,801         1,354,933        (130,936)      ‐9% (94,868)       ‐7% Mar 1,251,275        1,220,901         1,295,732        44,457         4% 74,831        6% Apr 1,204,619        1,175,377         1,260,110        55,491         5% 84,733        7% May 1,322,947        1,290,833         1,231,700        (91,247)         ‐7% (59,133)       ‐5% Jun 1,070,303        1,044,322         1,165,188        94,885         9% 120,866     12% Jul 1,010,609        986,077              1,140,413        129,803      13% 154,335     16% Aug 1,201,122        1,171,965         1,131,693        (69,429)         ‐6% (40,272)       ‐3% Sep 1,068,035        1,042,109         1,082,231        14,197         1%40,123        4% Oct 1,079,380        1,053,179         1,138,457        59,077         5% 85,279        8% Nov 1,090,897        1,064,416          Dec 1,383,272        1,349,694          YTD  Total 12,107,801$  11,813,890$   12,083,388$  (24,413)$     0% 269,498$  2% Annual Total 14,581,971$  14,228,000$    2010 vs. Budget2010 vs. 2009 Year  to Date through October Utility Tax Revenues Month Page 3 of 35 Monthly Financial Report October 2010        Other Taxes     Real Estate Excise Tax  The City collected $183k in Real Estate  Excise Tax revenues (REET) in October.   This is $25k or 12% below current  month’s budget and $27k or 13% behind  the same month last year.  Year‐to‐date  collection of $1.8 million is $215k or 10%  behind the budget and is also $231k or  11% below 2009.    Almost all REET in recent months are  generated from residential property  transactions.  The activities appear to be  smaller in amount but steady in volume.   We hope this trend will continue and not  stop once the federal stimulus incentive  expires.       Gambling Tax  October’s Gambling Tax  collections total $126k.  Year‐to‐ date total of $1.3 million is $552k  or 30% below the year before; and  $429k or 25% below budget.      The lower tax collection is due to  cross‐the‐board reduction in  gambling activities.  Pull tabs  overall reduced by 30%, partially  due to the change in business at  Cascade Lanes; and card‐rooms  are seeing 32% lower in activities.    Because of these changes, the City  is anticipating around $495k less  in gambling tax revenue collection  than budgeted by the end of the year.    Franchise Fees  Franchise Fees are due quarterly  and the year‐to‐date revenue  collections are $1.2 million.  This is  $184k or 16% above the projected  year‐to‐date budget and $138k or  13% higher than 2009.  2009’s  May collection should have been  recorded in April.  The City has  met the franchise fees 2010  budget.        2009 2010 2010 Actual Budget Actual $ % $ % Jan 231,334$      229,560$      71,303$         (160,031)$   ‐69% (158,257)$   ‐69% Feb 69,290            68,760            107,242         37,952         55% 38,482         56% Mar 183,177         181,800         309,164         125,987      69% 127,364      70% Apr 141,038         139,944         281,746         140,708      100% 141,802      101% May 308,077         305,736         216,814         (91,262)         ‐30% (88,922)         ‐29% Jun 211,295         209,688         191,741         (19,554)         ‐9% (17,947)         ‐9% Jul 201,960         200,400         149,706         (52,253)         ‐26% (50,694)         ‐25% Aug 310,599         308,232         209,369         (101,230)      ‐33% (98,863)         ‐32% Sep 208,046         206,472         123,054         (84,992)        ‐41% (83,418)         ‐40% Oct 209,975         208,368         183,333         (26,642)         ‐13% (25,035)         ‐12% Nov 222,052         220,344          Dec 121,614         120,696          YTD  Total 2,074,791$  2,058,960$  1,843,473$  (231,318)$   ‐11% (215,487)$   ‐10% Annual Total 2,418,456$  2,400,000$   Real Estate Excise  Tax Revenues Year  to Date through October Month 2010 vs. Budget2010 vs. 2009 2009 2010 2010 Actual Budget Actual $ % $ % Jan 7,691$            186,179$      135,608$      127,917$   1663% (50,571)$      ‐27% Feb 391,054         186,179         137,736         (253,317)      ‐65% (48,443)         ‐26% Mar 171,097         159,776         63,054            (108,044)      ‐63% (96,722)         ‐61% Apr 177,856         166,087         196,085         18,229         10% 29,998         18% May 178,840         167,006         133,979         (44,861)         ‐25% (33,027)         ‐20% Jun 186,920         174,551         142,790         (44,130)         ‐24% (31,762)         ‐18% Jul 182,851         170,752         125,614         (57,237)         ‐31% (45,138)         ‐26% Aug 210,237         196,325         138,563         (71,673)         ‐34% (57,762)         ‐29% Sep 173,745         162,248         105,323         (68,423)        ‐39% (56,926)        ‐35% Oct 176,490         164,811         126,396         (50,093)        ‐28% (38,415)        ‐23% Nov 146,960         137,236         ‐                      Dec 137,979         128,849         ‐                      YTD Total 1,856,781$  1,733,916$  1,305,148$  (551,633)$  ‐30% (428,768)$  ‐25% Annual Total 2,141,720$  2,000,000$   Gambling Tax Revenue Month Year to Date through October 2010 vs. 2009 2010 vs. Budget 2009 2010 2010 Actual Budget Actual $ % $ % Jan 259,792$      255,537$      45,703$         (214,089)$   ‐82% (209,834)$   ‐82% Feb 200                    102                    274,776         274,576      137288% 274,674      269037% Apr ‐                     102,746         274,268         274,268      100% 171,521      167% May 258,593         132,005          ‐                     (258,593)     (132,005)      Jul 260,647         244,359         286,523         25,876         10% 42,164         17% Aug ‐                      ‐                     6,691               6,691            100% 6,691            100% Sep ‐                     24,721             ‐                      Oct 259,798         258,846         289,316         29,517         11% 30,469         12% Nov ‐                      ‐                     ‐                      Dec ‐                     21,683            ‐                      YTD Total 1,039,031$  1,018,317$  1,177,275$  138,244$   13% 183,680$   16% Annual Total 1,039,031$  1,040,000$   Franchise  Fees  Revenue Year to Date through October Month 2010 vs. 2009 2010 vs. Budget Page 4 of 35 Monthly Financial Report October 2010        Admission Tax   Admission Tax returns are due  quarterly in January, April, July,  and October each year.  October  2010 collections represent  activities conducted during the 3rd  quarter of 2010.      The report shows an increase of  $31k or 12% from the year before  and $31k or 12% more than  anticipated.       Licenses and Permits  These revenue sources reflect the collection of business licenses; building permits; and other licenses, fees, and permits.   Building Permit Fees and General Business Licenses constitute 82% of the revenue in this category.  As of the end of  October, we have collected 83% of the projected revenue from licenses and permits.  Licenses and Permits totaled $2  million by the end of October, which is $49k less than the budget.  The following sections provide detail information for  Building Permits and Business Licenses revenues.    Building Permits and Fees revenues  totaled $91k in October.  The revenue  swing between the high in January and  the low in February is primarily  attributable to the rush of getting  permits completed prior to the new  school impact fees taking effect.  The  year‐to‐date development fees revenue  of $1.2 million is $103k or 8% less than  the budget and is also $10k or 1% lower  than 2009.  The City is projecting  building permits and fees to be under  the 2010 budget by $124k.              Business Licenses totaled $407k since the start  of the year, which is 1% above last year but 7%  below budget.  The month by month comparison  is not representative due to the payment timing  shift of employers.  The General Fund portion of  the Business Licenses revenue is under the  budget by $31k but $6k above last year.      2009 2010 2010 Actual Budget Actual $ % $ % Jan 57,167$         58,965$         74,777$         17,610$      31% 15,811$      27% Feb ‐                      ‐                     459                    459                 100% 459                 100% Apr 61,163            63,415            66,119            4,956            8% 2,704            4% Jul 70,690            69,911            76,024            5,334            8% 6,114            9% Aug ‐                      ‐                     485                    485                 100% 485                 100% Oct 70,729            67,414            73,073            2,344            3% 5,660            8% Nov 520                    295                     ‐                      YTD Total 259,749$      259,705$      290,937$      31,188$      12% 31,233$      12% Annual Total 260,269$      260,000$       Ye ar  to Date through October Month 2010 vs. 2009 2010 vs. Budget Admission Tax Revenue 2009 2010 2010 Actual Budget Actual $ % $ % Jan 106,633$      114,591$      285,826$      179,192$   168% 171,234$   149% Feb 124,555         133,851         46,586            (77,969)         ‐63% (87,265)         ‐65% Mar 179,330         192,714         82,637            (96,693)         ‐54% (110,076)      ‐57% Apr 114,694         123,254         122,217         7,522            7% (1,037)            ‐1% May 125,344         134,698         102,511         (22,833)         ‐18% (32,187)         ‐24% Jun 131,705         141,534         135,295         3,591            3% (6,238)            ‐4% Jul 106,810         114,781         137,367         30,557         29% 22,585         20% Aug 119,439         128,352         121,011         1,573            1% (7,341)            ‐6% Sep 101,087         108,631         106,602         5,515            5%(2,029)            ‐2% Oct 131,899         141,742         91,156            (40,742)         ‐31% (50,586)         ‐36% Nov 82,516            88,674            ‐                      Dec 169,581         182,237         ‐                      YTD  Total 1,241,496$  1,334,148$  1,231,208$  (10,288)$      ‐1% (102,940)$  ‐8% Annual Total 1,493,593$  1,605,059$   Building Permits and Fees Year  to Date through October 2010 vs. Budget2010 vs. 2009 Month 2009 2010 2010 Actual Budget Actual $ % $ % Jan 81,835$     89,289$     77,955$     (3,880)$   ‐5% (11,334)$   ‐13% Feb 30,180        32,929        33,440        3,260      11% 511              2% Mar 6,337           6,914           5,687           (650)          ‐10% (1,228)         ‐18% Apr 73,055        79,709        77,964        4,908      7% (1,746)         ‐2% May 14,185        15,477        21,558        7,373      52% 6,081         39% Jun 9,352           10,204        4,709           (4,643)      ‐50% (5,495)         ‐54% Jul 80,579        87,918        83,201        2,622      3% (4,717)         ‐5% Aug 20,280        22,127        14,782        (5,498)      ‐27% (7,345)         ‐33% Sep 1,746           1,905           4,475           2,729      156%2,570         135% Oct 84,002        91,653        83,639        (363)         0% (8,014)         ‐9% Nov 18,937        20,662        ‐                  Dec 3,922           4,279           ‐                  YTD Total 401,554$  438,126$  407,410$  5,856$   1% (30,716)$   ‐7% Annual Total 424,413$  463,067$   Business Licenses Month Year to Date through October 2010 vs. Budget2010 vs. 2009 Page 5 of 35 Monthly Financial Report October 2010        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 80%  of the total revenues in  this category.   The year‐to‐date total Intergovernmental revenue is $7.7 million or 65% of the budget.  All grant revenues  also have corresponding expenditures which have been added to the City’s budget through the 2010 carry forward, 2nd  Quarter budget adjustment, and the upcoming Year‐End budget adjustment.    State Shared Revenue collections  totaled $3.4 million since the start  of 2010.  Compared to the  projected budget, State Shared  Revenues are above by $74k or 2%.   Compared to the prior year, the  City is collecting $77k more or up  by 2%.  The actual collection that  lags budget is primarily due to the  reduced criminal justice sales tax  (King County countywide sales tax  decrease).  Based on the collections  so far, the City is projecting State  Shared Revenues to meet the 2010 budget.      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.  Culture, recreation, interfund/interdepartmental‐sales and services  constitute 75% of the total revenue in this category.  The year‐to‐date total charges for services are $5.3 million or 82% of  the budget.  This is 2% below budget projections.  The following sections provide detail information for Plan Review with  Inspection Fees, Recreation, and Interfund Services.    Plan Review and Inspection fees are $773k  since the start of the year.  Compared to the  budget, the City is collecting $121k or 19%  more than anticipated revenue.   Compared  to the prior year, the City is collecting $267k  or 53% more.  The large increases in May,  July, and October are due to payments related  to an environmental impact statement.  The  City is projecting plan review and inspection  fees to exceed the 2010 budget.    2009 2010 2010 Actual Budget Actual $ % $ % Crim Just Sales  Tax 1,371,232$  1,448,213$  1,342,404$  (28,828)$   ‐2% (105,809)$  ‐7% Judicial Contribution 23,918            9,628               22,868            (1,050)$      ‐4% 13,240         138% Crim Just ‐ Pop 17,815            ‐                     18,818            1,002         6% 18,818         100% Crim Just ‐ Spec  Prog 68,011            66,098            71,284            3,273         5% 5,186            8% State  DUI 15,170            8,244               15,677            507              3% 7,433            90% Liquor Profits 447,317         472,347         514,215         66,898      15% 41,868         9% Liquor Excise  Tax 403,630         413,000         419,052         15,422      4% 6,052            1% Fuel  Tax 1,011,801     944,059         1,031,333     19,532      2% 87,275         9% YTD  Total 3,358,895$  3,361,589$  3,435,651$  76,756$   2% 74,062$      2% Annual Total 3,986,791$  3,988,931$   State  Shared Revenues 2010 vs. 2009 Revenue Year  to Date through October 2010 vs. Budget 2009 2010 2010 Actual Budget Actual $ % $ % Jan 35,851$     46,164$     98,294$      62,443$     174% 52,130$     113% Feb 45,883        59,082        41,012         (4,871)          ‐11% (18,070)       ‐31% Mar 86,425        111,287     64,399         (22,026)       ‐25% (46,888)       ‐42% Apr 27,659        35,615        45,065         17,406        63% 9,449           27% May 58,715        75,606        103,250      44,534        76% 27,644        37% Jun 43,085        55,479        60,642         17,557        41% 5,163           9% Jul 61,541        79,245        162,517      100,977     164% 83,273        105% Aug 43,348        55,817        38,649         (4,698)          ‐11% (17,168)       ‐31% Sep 36,509        47,012        34,245         (2,264)          ‐6% (12,767)       ‐27% Oct 67,095        86,397        124,857      57,761        86% 38,460        45% Nov 59,883        77,110         ‐                   Dec 109,397     140,867      ‐                   YTD  Total 506,111$  651,705$  772,930$   266,819$  53% 121,225$  19% Annual  Total 675,391$  869,683$   Month 2010 vs. 2009 2010 vs. Budget Year  to Date through October Plan Review / Inspection Intergovernmental 2009 2010 Bgt YTD  Act Change 2010/2009 2010 Act  vs  Bgt  Fire  District #25 681,675$         810,735$         810,735$         129,060$    19% $                          ‐ 0% Fire  District #40 2,369,298        1,959,797        1,959,797        (409,501)       ‐17%                              ‐ 0% State  Shared Revenue 3,358,895        3,361,589        3,435,651        76,756          2%               74,062 2% Federal  Grants 358,953            562,973            562,973            204,021       57%                              ‐ 0% State  Grants 177,115            200,132            200,132            23,018          13%                              ‐ 0% Other  Grants 719,094            185,689            185,689            (533,405)       ‐74%                              ‐ 0% ARRA Grants 147,435            561,090            561,090            413,655       281%                              ‐ 0% Total  Rev YTD 7,812,464$     7,642,006$     7,716,068$     (96,396)$      ‐1%74,062$           1% Total  Rev Annual 11,340,480$  11,804,803$   YTD  %69% 65% 65% Note:  Includes CJ Sales  Tax. Page 6 of 35 Monthly Financial Report October 2010        Recreation revenues totaled $1.3 million  since the start of the year.  Compared to  the projected monthly budget, the City  collected $978 or 1% more.  Compared to  the same month the prior year, the City  collected $2k or 2% less.  Based on the  current month’s collection, the City is  projecting Recreation revenues to be  under the budget projection for 2010 by  $146k.                    The year‐to‐date collections for Interfund  Service revenues are $2.7 million.   Compared to the projected budget, the  revenues are below by $111k or 4%.   Compared to the prior year, the revenues  are under by $20k or 1%.  Interfund  Services is projected to be slightly under  the budget projection for 2010.  The  majority of these revenues are related to  indirect cost allocation, which are internal  administrative costs.  The remaining costs  consist of Development Services division’s  inspection fees, Transportation division’s  capital investment program  reimbursements, and Maintenance  division’s street maintenance  reimbursements.        Fines and Penalties  These revenue sources contain civil  (penalties, infractions, and parking),  criminal (traffic, non‐traffic, and costs),  and non‐court fines, forfeitures, and  penalties.  The table below breaks  down these fines by type.  The year‐to‐ date total fines and penalties is $2.8  million.  This is $309k or 10% lower  than a year ago and $123k or 4% under  budget.  This difference also includes  $91k higher than budgeted Seizure  Funds received this year.  The use of  Seizure Funds is restricted to drug  enforcement only and not available for  general operating purposes.  Backing  2009 2010 2010 Actual Budget Actual $ % $ % Jan 65,409$         63,034$         62,673$         (2,736)$         ‐4% (361)$             ‐1% Feb 72,988            70,337            64,915            (8,072)            ‐11% (5,422)            ‐8% Mar 81,034            78,092            99,100            18,065         22% 21,008         27% Apr 141,783         136,635         152,452         10,669         8% 15,818         12% May 145,050         139,783         83,760            (61,290)         ‐42% (56,023)         ‐40% Jun 154,237         148,636         193,082         38,844         25% 44,445         30% Jul 429,059         413,478         280,956         (148,103)      ‐35% (132,523)      ‐32% Aug 203,222         195,842         181,356         (21,866)         ‐11% (14,486)         ‐7% Sep 123,439         118,956         111,952         (11,486)        ‐9% (7,004)            ‐6% Oct 79,452            76,566            77,544            (1,907)            ‐2% 978                 1% Nov 61,971            59,720            ‐                      Dec 73,842            71,161            ‐                      YTD  Total 1,495,673$  1,441,359$  1,307,790$  (187,883)$   ‐13% (133,569)$  ‐9% Annual Total 1,631,486$  1,572,240$   Recreation Year to Date through October 2010 vs. 2009 Month 2010 vs. Budget 2009 2010 2010 Actual Budget Actual $ % $ % Jan 253,147$      261,774$      242,658$      (10,489)$   ‐4% (19,116)$      ‐7% Feb 243,496         251,795         273,674         30,178      12% 21,880         9% Mar 286,921         296,700         249,758         (37,163)      ‐13% (46,942)         ‐16% Apr 280,094         289,640         348,019         67,925      24% 58,379         20% May 282,056         291,668         269,154         (12,902)      ‐5% (22,515)         ‐8% Jun 270,778         280,006         275,850         5,072         2% (4,156)            ‐1% Jul 263,897         272,891         263,285         (612)            0% (9,606)            ‐4% Aug 258,386         267,191         248,584         (9,801)         ‐4% (18,607)         ‐7% Sep 265,902         274,964         238,713         (27,189)     ‐10% (36,251)         ‐13% Oct 266,313         275,389         241,403         (24,910)      ‐9% (33,986)         ‐12% Nov 281,154         290,736         ‐                      Dec 273,599         282,923         ‐                      YTD  Total 2,670,992$  2,762,018$  2,651,099$  (19,893)$   ‐1% (110,920)$  ‐4% Annual Total 3,225,745$  3,335,677$   Interfund Services Year to Date through October 2010 vs. 2009 2010 vs. Budget Month 2009 2010 2010 Actual Budget Actual $ % $ % Jan 280,849$      260,504$      239,080$      (41,769)$      ‐15% (21,424)$      ‐8% Feb 285,126         273,615         228,332         (56,794)         ‐20% (45,283)         ‐17% Mar 370,244         346,368         279,311         (90,933)         ‐25% (67,057)         ‐19% Apr 331,546         308,110         294,612         (36,934)         ‐11% (13,498)         ‐4% May 310,888         288,772         276,543         (34,345)         ‐11% (12,229)         ‐4% Jun 330,829         308,278         373,623         42,794         13% 65,345         21% Jul 321,486         320,479         256,225         (65,261)         ‐20% (64,254)         ‐20% Aug 256,668         236,769         319,267         62,598         24% 82,497         35% Sep 269,199         248,930         231,632         (37,567)        ‐14% (17,298)         ‐7% Oct 318,272         297,259         267,539         (50,734)         ‐16% (29,721)         ‐10% Nov 368,928         345,541          ‐                      Dec 372,972         342,568          ‐                      YTD Total 3,075,108$  2,889,084$  2,766,164$  (308,944)$  ‐10% (122,920)$  ‐4% Annual Total 3,817,008$  3,577,193$   2010 vs. Budget2010 vs. 2009 Year  to Date through October Fines  and Penalties by Month Month Page 7 of 35 Monthly Financial Report October 2010        out this amount, we are currently $214k or 7% below budget in Fines and Penalties and we expect to be $183k below  budget at the end of the year.  The projected shortfall is primarily due to substantial declines in the photo enforcement  fines, which we expect to continue.  The decline is due to driver behavior changes in the areas with photo enforcement  programs and is consistent with the experience of other jurisdictions.  These factors contributed to the reduction in photo  enforcement revenue by 42% in September and 19% in October when compared with the same periods in 2009.    Year  to Date through October 2009 2010 2010 Actual Budget Actual $ % $ % Civil Penalties 13,967$         11,961$         12,883$         (1,085)$         ‐8% 922$              8% Civil Infraction Penalties 648,872         589,054         662,196         13,324         2% 73,142         12% Civil Parking Infraction Penalties 136,790         117,160         115,771         (21,018)         ‐15% (1,388)            ‐1% Photo Enforcement  Program 1,931,597     1,835,242     1,558,745     (372,852)      ‐19% (276,497)      ‐15% Criminal Traffic  Misdemeanor  Fines 80,724            64,478            77,242            (3,482)            ‐4% 12,764         20% Criminal Non‐Traffic  Fines 38,230            35,583            29,692            (8,538)            ‐22% (5,891)            ‐17% Criminal Costs 84,713            72,702            84,151            (563)                ‐1% 11,449         16% Seizure Funds  ‐ Federal/State/Local 93,913            122,930         214,093         120,180      128% 91,163         74% Non‐Court Fines, Forfeitures and Penalties 46,301            39,973            11,391            (34,909)         ‐75% (28,582)         ‐72% YTD Total 3,075,108$  2,889,084$  2,766,164$  (308,944)$   ‐10% (122,920)$  ‐4% Annual Total 3,817,008$  3,577,193$   2010 vs. 2009 Revenue 2010 vs. Budget Fines  and Penalties by Type       Included in the Fines and Penalties revenue budget  is $2.3 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.6 million.  The associated  costs includes the equipment provided by American  Traffic Solutions Inc (ATS), we are also dedicating 2  FTEs in the Court Division to process the increased  caseload and 1.1 FTEs in the Police Department for  support services.  These staff’s 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.            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 82% of  the total revenue in this category.  The  year‐to‐date total miscellaneous is $1.2  million.  Compared to the projected year‐ to‐date budget, the revenues are under by  $2k.  Compared to last year, the revenues  are under by $103k or 8%.  2009 2010 2010 Actual Budget Actual $ % $ % Jan 143,245$      127,631$      170,998$      27,753$      19% 43,367$   34% Feb 192,680         181,886         86,124            (106,555)     ‐55% (95,762)      ‐53% Mar 59,923            65,165            115,122         55,199         92% 49,957      77% Apr 100,349         93,113            99,376            (974)                ‐1% 6,263         7% May 156,161         139,519         101,909         (54,252)        ‐35% (37,610)      ‐27% Jun 100,207         98,090            148,339         48,132         48% 50,249      51% Jul 219,671         188,995         158,134         (61,537)        ‐28% (30,861)      ‐16% Aug 80,681            79,488            93,081            12,399         15% 13,593      17% Sep 131,358         115,050         110,810         (20,548)       ‐16% (4,240)         ‐4% Oct 76,125            69,672            73,018            (3,107)           ‐4% 3,346         5% Nov 73,002            66,318            ‐                      Dec 196,289         153,054         ‐                      YTD  Total 1,260,400$  1,158,609$  1,156,910$  (103,490)$ ‐8% (1,699)$     0% Annual  Total 1,529,692$  1,377,980$   Year  to Date through October Month 2010 vs. Budget2010 vs. 2009 Miscellaneous Revenues by Month Favorable Budget Actual Budget Actual (Unfavorable) 1 Jan 173,461$      187,281$      70,097$        71,970$      115,311$         Feb 166,708         135,565         69,919           72,434         63,131               Mar 245,529         172,250         69,697           71,970         100,280            Apr 209,106         162,520         70,260           50,102         112,418            May 192,106         156,204         70,181           67,891         88,313               Jun 223,152         217,862         69,786           67,880         149,982            Jul 143,538         146,429         69,991           68,261         78,167               Aug 143,576         128,118         69,525           53,540         74,577               Sep 149,862         92,140            69,700           67,555         24,585               Oct 188,205         160,378         69,347           67,454         92,923               Nov 240,433         ‐                     70,269           ‐                  ‐                        Dec 174,325         ‐                     73,194           ‐                  ‐                        YTD Total 1,835,242$  1,558,745$  698,501$     659,057$   899,688$         Annual Total 2,250,000$  841,964$      1Actuals  of Revenues and Expenses Revenues Expenses Photo Enforcement Program Year  to Date through October Month Page 8 of 35 Monthly Financial Report October 2010        2009 2010 2010 Actual Budget Actual $ % $ % Interests and Other  Earnings 463,195$      375,790$      280,012$      (183,183)$   ‐40% (95,778)$      ‐25% Rents, Leases, and Concessions 610,157         648,694         666,168         56,011         9% 17,474         3% Contributions/Donations  from Private Sources 120,210         89,435            127,729         7,519            6% 38,295         43% Other 66,838            44,690            83,000            16,163         24% 38,311         86% YTD  Total 1,260,400$  1,158,609$  1,156,910$  (103,490)$  ‐8% (1,699)$        0% Annual Total 1,529,692$  1,377,980$   2010 vs. Budget Miscellaneous Re venues  by Type Year  to Date through October Revenue 2010 vs. 2009         EXPENSES  Overall the City has expended 78% of its budgeted general governmental expenditures at the end of October.  This is 3.2%  or $2.8 million below year‐to‐date budgeted expenditures.  While some of these savings would be realized at the end of the  year, others are due to the timing of the payments.  Below are the explanations for some of the large variances on the  expenditures.  We do expect some expenditure savings at the end of the year, but it will be narrower than the 3.2% we  currently have.     The Finance Department appears to be under budget by $270k.  This is due to the $200,000 banking service fees in the  carry forward budget amendment that will not be paid until year‐end.  The department had a couple of temporary  vacancies in 2010 which also helped the year‐to‐day status.  These positions are now filled and we expect the banking  service fees to be substantially higher than we have budgeted for, therefore we do not expect savings in Finance at the end  of the year.    The Hearing Examiner is under budget by $22k or 13% due to expending less in contracted professional services.    The City Clerk division is under budget by $96k due to lower than anticipated elections costs.  The City is expecting a total of  $127k in election costs, which will be $87k under the projected amount of $214k.    Community Services is under budget in total by $748k due to expending less in temporary/intermittent/seasonal help (for  Parks, Recreation, and Museum) and supplies.       Page 9 of 35 Monthly Financial Report October 2010        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 Bond/Rate  Stabilization  Funds REVENUES: Licenses  and permits ‐                  ‐             ‐              ‐               43,862         33,850       ‐               Grants 61,220           ‐             144              2,699           ‐               500,238     ‐               Charges  for services 44,814           1,643,337  12,444,552  8,631,632    14,188,405  4,160,618  ‐               Interdepartmental services ‐                 ‐             1,969           195,997       132,650       438,633     ‐               Rents, leases, and misc fees 1,514,002      337,104     66,000         84,723         ‐               ‐             ‐               Interest and other misc 12,395           14,114       113,778       404,026       475,767       272,638     151              TOTAL REVENUES 1,632,431      1,994,555  12,626,443  9,319,077    14,840,684  5,405,977  151              EXPENSES: Utility billing ‐                 ‐             113,214       96,222         84,914         133,213     ‐               Utility systems ‐                 ‐             11,168,151  2,139,461    1,904,345    1,734,770  ‐               Utility maintenance ‐                 ‐             226,560       3,638,538    10,252,616  1,383,557  ‐               Transportation 869,630         ‐             ‐              ‐               ‐               ‐             ‐               Golf ‐                 1,444,170  ‐              ‐               ‐               ‐             ‐               TOTAL EXPENSES 869,630         1,444,170  11,507,925  5,874,221    12,241,875  3,251,540  ‐               AMOUNT AVAILABLE FOR DEBT SERVICE 762,801         550,385     1,118,518    3,444,856    2,598,809    2,154,437  151              DEBT SERVICE: Principal 88,579           19,199       ‐              1,246,675    815,776       151,840     ‐               Interest and other debt service costs 16,625           57,684       ‐              480,938       250,164       194,229     ‐               TOTAL DEBT SERVICE 105,204         76,883       ‐              1,727,613    1,065,940    346,069     ‐               CAPITAL PROJECTS 427,509         172,199     ‐              1,703,374    3,068,098    1,521,644  ‐               TRANSFERS IN/(OUT)‐                 ‐             ‐              ‐               ‐               (710,774)    ‐               CHANGE  IN FUND BALANCE 230,088         301,303     1,118,518    13,869         (1,535,229)   (424,050)    151              BEGINNING FUND BALANCE, January 1, 2010 1,049,083      1,085,801  326,034 7,157,108    2,775,538    3,982,842  15,605         ENDING FUND BALANCE, October 31, 2010 1,279,171      1,387,104  1,444,552    7,170,977    1,240,309    3,558,792  15,756           Page 10 of 35 Monthly Financial Report October 2010        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: Grants ‐            986             ‐             ‐                      ‐              ‐               ‐             Charges  for services Equipment rental  m&o 1,780,374  1,635,427   ‐             ‐                      ‐              ‐               ‐             Telecommunications ‐            238,183      ‐             ‐                      ‐              ‐               ‐             Print and mail ‐            89,484        ‐             281,262               ‐              ‐               ‐             Communications ‐            ‐              ‐             450,034               ‐              ‐               ‐             Facilities ‐            ‐              3,480,185   ‐                      ‐              ‐               ‐             Data  cards  and cell  phones ‐            93,726        ‐             ‐                      ‐              ‐               ‐             IT service contracts ‐            209,014      ‐             ‐                      ‐              ‐               ‐             Interest and other misc 55,686       17,817        2,147          876                      65,055         58,225         30,790        Internal service fund  misc: Vehicle/equipment capital  recovery 1,200,833  830,660      ‐             ‐                      ‐              ‐               ‐             Insurance premiums ‐            ‐              ‐             ‐                      1,840,770    ‐               ‐             Worker's  compensation  / unemployment ‐            ‐              ‐             ‐                      1,166,305    ‐               ‐             Benefit premiums ‐            ‐              ‐             ‐                      ‐              8,545,493    1,450,358   Other misc 1,393         ‐              2,414          ‐                      3,611           405,416       ‐             Disposal  of capital  assets ‐            ‐              ‐             ‐                      ‐              ‐               ‐             Insurance recoveries ‐            ‐              ‐             ‐                      124,529       105,511       32,458        TOTAL REVENUES 3,038,286  3,115,297   3,484,746   732,172               3,200,270    9,114,645    1,513,606   EXPENSES: Communications 394,770                Equipment rental 1,868,806   Facilities 3,340,779    Healthcare 7,530,190     Information technology 2,484,565    Print and mail 335,593                Retiree  healthcare 895,214      Risk management Risk management 1,124,301     Unemployement 368,927        Worker's  compensation 1,040,705     TOTAL EXPENSES 1,868,806  2,484,565   3,340,779   730,363               2,533,933    7,530,190    895,214      AMOUNT AVAILABLE FOR CAPITAL 1,169,480  630,732      143,967      1,809                   666,337       1,584,455    618,392      CAPITAL PROJECTS 696,273     362,248      25,000        29,408                 ‐              ‐               ‐             TRANSFERS IN ‐            ‐              ‐             ‐                      ‐              ‐               ‐             TRANSFERS (OUT)‐            ‐              ‐             ‐                      ‐              ‐               ‐             CHANGE IN FUND BALANCE 473,207     268,484      118,967      (27,599)               666,337       1,584,455    618,392      BEGINNING FUND BALANCE, January 1, 2010 4,593,399  1,647,931   91,175        111,818               6,039,509    4,792,452    2,820,473   ENDING FUND BALANCE, October 31, 2010 5,066,606  1,916,415   210,142      84,219                 6,705,846    6,376,907    3,438,865   Page 11 of 35 Monthly Financial Report October 2010        THE SCORE    The South Correctional Entity (SCORE) is a public development authority (PDA) that was formed to build and operate a new  822‐bed misdemeanor jail in South King County.  SCORE is made up of cities located in South King County and they are  Auburn, Burien, Des Moines, Federal Way, Renton, SeaTac, and Tukwila.  The City of Renton is the principle of the PDA as  well as acting as the treasurer and fiscal agent for SCORE during the planning and development phase. The design and  permit work, construction bid opening, and bond sell has been completed.    The current estimated total development and construction costs for the project is around $95 million, including capitalized  interest and startup costs.  The bonding is $87 million with the remaining $8 million to be financed by member  contributions.  The City of Renton is obligated for 36% of the bonds issued.       The table below lists the year to date financing sources and uses of the SCORE:    SCORE REVENUES: Interlocal city contribution Auburn ‐                  Burien 4,000              Des  Moines ‐                  Federal  Way ‐                  Renton ‐                  Seatac 3,000              Tukwila ‐                  Interest and other misc 266,897          Bond proceeds ‐                  Tax Credit  (BABs) 837,545          TOTAL REVENUES 1,111,442       EXPENSES: Salaries  and wages 117,144          Benefits 51,733            Supplies 34,251            Professional services 1,556,190       Intergovernmental 770,369          Construction 39,689,066     TOTAL EXPENSES 42,218,754     AMOUNT AVAILABLE FOR DEBT SERVICE (41,107,312)    DEBT SERVICE: Principal ‐                  Interest and other debt service costs 3,439,680       TOTAL DEBT SERVICE 3,439,680       CHANGE IN FUND BALANCE (44,546,992)    BEGINNING FUND BALANCE, January 1, 2010 80,644,637     ENDING FUND BALANCE, October 31, 2010 36,097,646     Page 12 of 35 Monthly Financial Report October 2010        FUND BALANCE  Page 14 shows the ending fund balance as of October 2010.  The City’s fund balance is a combination of current  deficit/surplus of funds which have accrued from unexpended operating budgets and 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 October, the City has $12.6 million reported in combined general governmental fund balance of the current  year’s operating budget, which is approximately 12% of budgeted operating expenditures.  This is an increase of $679k from  the beginning balance of January 1, 2010.  October’s ending fund balance is over the anticipated General Governmental  Fund Balance of $10 million by $2.6 million.  Although the ending fund balance is above projections, it is consistent with the  prior years’ trends since the City receipted the first half of 2010 property taxes in April and May.  We expect the fund  balance to decrease but be in line with the projected fund balance after May and continue to decrease until we receive the  second half of 2010 property taxes in October and November.    CONTACT INFORMATION  This report is prepared by the Finance Division of the FIT 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 iwang@rentonwa.gov.  Page 13 of 35 Monthly Financial Report October 2010        City  of Renton All Funds ‐ Revenue, Expenditures and Fund Balances Cash  Basis through October 31, 2010 Funds Balance  01/01/2010 Budgeted  Revenue Revenue  10/31/10 Total Funds  Available Budgeted  Expenditure Expenditure  10/31/10 Ending Balance GENERAL GOVERNMENT FUNDS:11,955,285       105,584,156   83,848,462     95,803,747         106,294,348       83,169,405         12,634,342       000 General 8,535,013         74,693,168     55,421,977     63,956,990         72,750,777         57,276,666         6,680,324         001 Community Services 958,009            9,557,924       8,280,623       9,238,632           10,492,749         8,057,325           1,181,307         003 Street 1,391,648         7,456,240       6,577,087       7,968,735           8,549,762           7,077,725           891,010            004 Community Dev Block Grant (6,528)               532,635          204,232          197,704              532,227              374,878              (177,174)           005 Museum 64,705              192,621          193,150          257,855              194,120              159,284              98,571              006 Library 706,011            1,888,252       1,630,973       2,336,984           2,607,263           2,280,221           56,763              009 Farmers  Market 60,571              44,280            47,679            108,250              34,311                23,602                84,648              010 Fire  Memorial 936                   ‐                     315                 1,251                  ‐                          ‐                          1,251                011 Fire  Health & Wellness 4,303                25,000            19,887            24,190                25,000                2,696                  21,494              031 Pa rk  Memorial 175,066             ‐                     1,721              176,787               ‐                           ‐                          176,787            201 Ltd  GO Bonds Gen Govt Debt 1,448                2,033,177       2,035,574       2,037,022           1,984,625           318,588              1,718,434         215 Gen Govt Misc Debt Service 64,103              9,160,859       9,435,244       9,499,347           9,123,514           7,598,420           1,900,927         SPECIAL REVENUE FUNDS: 102 Arterial  Street 200,686            620,000          490,012          690,698              620,000              ‐                          690,698            108 Leased  City Properties 837,613            1,669,586       1,156,798       1,994,411           1,511,561           1,330,357           664,054            110 Hotel  Motel 247,828            245,000          224,111          471,939              310,000              238,383              233,556            118 Reserve for Paths  & Trails 3,264                ‐                     35                   3,299                  ‐                          ‐                          3,299                125 1% For Art 143,796            35,000            1,389              145,185              50,000                8,611                  136,574            127 Cable  Communication 89,391              85,000            51,183            140,574              85,674                45,332                95,242              135 Springbrook Wetlands Bank 459,528            ‐                     200,402          659,930              ‐                          ‐                          659,930            DEBT SERVICE FUNDS: 219 1989 Unlimited GO Bonds 79,340              ‐                     ‐                     79,340                79,340                79,340                ‐                        CAPITAL PROJECT FUNDS (CIP): 303 Community Dev Mitigation 1,066,593         60,000            272,705          1,339,298           ‐                          ‐                          1,339,298         304 Fire  Mitigation 2,363,522         100,000          80,299            2,443,821           560,000              519,996              1,923,825         305 Transportation  Mitigation 2,167,133         200,000          80,003            2,247,136           1,810,000           ‐                          2,247,136         316 Municipal Facilities  CIP 6,933,186         1,333,553       928,410          7,861,596           7,681,771           1,272,047           6,589,549         317 Transportation  CIP 2,892,341         31,352,042     8,352,087       11,244,428         33,183,734         8,142,101           3,102,327         318 So Lake  WA Infrastructure Proj 114,039            ‐                     902                 114,941              114,000              56,471                58,470              326 Housing Opportunity 201,653            ‐                     1,988              203,641              200,000              ‐                          203,641            ENTERPRISE FUNDS: 402 Airport 415,929            1,917,163       1,565,756       1,981,685           1,001,800           869,630              1,112,055         403 Solid Waste Utility 326,034            15,027,000     12,626,443     12,952,477         15,037,130         11,507,925         1,444,552         404 Golf Course 798,278            2,483,545       1,992,703       2,790,981           2,566,837           1,563,528           1,227,453         422 Airport Capital 633,154            1,578,000       66,676            699,830              1,831,485           532,712              167,118            424 Golf Course  Capital 287,523            150,000          1,851              289,374              302,499              129,724              159,650            INTERNAL SERVICE FUNDS: 501 Equipment Repair/Replacement 4,593,399         3,631,241       3,038,285       7,631,684           3,414,047           2,565,078           5,066,606         502 Insurance 6,039,509         3,287,584       3,200,269       9,239,778           4,170,106           2,533,933           6,705,845         503 Information Services 1,647,931         4,194,774       3,115,297       4,763,228           4,841,706           2,846,813           1,916,415         504 Facilities 91,175              4,705,475       3,484,746       3,575,921           4,326,200           3,365,779           210,142            505 Communications 111,818            1,049,671       732,172          843,990              877,560              759,771              84,219              512 Insurance, Healthcare 4,792,452         12,358,471     9,114,646       13,907,098         12,462,810         7,530,190           6,376,908         522 Insurance, Leoff1 Retirees  HC 2,820,473         2,235,684       1,513,607       4,334,080           2,248,907           895,214              3,438,866         FIDUCIARY FUNDS: 611 Firemen's  Pension 4,332,817         300,000          126,111          4,458,928           550,475              315,017              4,143,911         Funds Balance  01/01/2010 Budgeted  Revenue Revenue  10/31/10 Total Funds  Available Budgeted  Expenditure Expenditure  10/31/10 Ending Balance ENTERPRISE FUNDS: COMBINED  UTILITIES 13,931,093       45,033,520     30,765,891     44,696,984         51,412,468         32,711,147         11,985,837       405 Water Utility 4,294,833         11,316,910     9,106,096       13,400,929         11,712,205         7,617,913           5,783,016         406 Waste  Water Utility 1,887,815         6,065,737       4,754,233       6,642,048           6,837,864           5,332,761           1,309,287         407 Surface  Water Utility 2,448,845         5,788,148       4,728,653       7,177,498           6,695,464           3,597,608           3,579,890         416 King  County Metro 46,504              11,211,935     9,644,220       9,690,724           11,211,935         9,175,054           515,670            425 Water Utility Construction 2,862,275         3,460,000       212,982          3,075,257           5,510,000           1,687,295           1,387,962         426 Waste  Water Construction 841,219            3,153,781       1,642,231       2,483,450           3,995,000           3,068,098           (584,648)           427 Surface  Water Construction 1,533,997         4,037,009       677,325          2,211,322           5,450,000           2,232,418           (21,096)             461 Waterworks  Bond Reserve ‐                        ‐                     ‐                     ‐                          ‐                          ‐                          ‐                        471 Wa terworks  Rate  Stabilization 15,605               ‐                     151                 15,756                 ‐                           ‐                          15,756              481 Future W/S Bond Proceeds ‐                        ‐                     ‐                     ‐                          ‐                          ‐                          ‐                        Note:  Waterworks  Utility Funds are managed as a  system and are designated by the  dotted lines.  Page 14 of 35 City of Renton General Government Financial Position 2010 Budget Year General Government Summary  Revenues Expenditures  $ Difference over (under)  w/beginning  balance  11,955,285             January 4,881,556              7,161,528              (2,279,972)             9,675,313               February 10,472,029            15,011,456            (4,539,427)             7,415,858               March 15,590,071            22,695,538            (7,105,467)             4,849,818               April 27,747,760            29,817,438            (2,069,678)             9,885,607               May 48,191,829            43,949,015            4,242,814              16,198,099             June 55,079,253            52,299,100            2,780,152              14,735,437             July 60,897,449            60,400,225            497,224                  12,452,509             August 66,585,570            68,336,283            (1,750,713)             10,204,572             September 71,408,888            76,025,654            (4,616,767)             7,338,518               October 83,848,462            83,169,404            679,058                  12,634,343             November December 1,000,000 2,000,000  3,000,000  4,000,000  5,000,000  6,000,000  7,000,000  70,000,000  80,000,000  90,000,000  100,000,000  110,000,000  DifferenceRev/Exp Revenues Expenditures Difference (7,000,000) (6,000,000) (5,000,000) (4,000,000) (3,000,000) (2,000,000) (1,000,000) ‐ 1,000,000  2,000,000  3,000,000  4,000,000  5,000,000  6,000,000  7,000,000  ‐ 10,000,000  20,000,000  30,000,000  40,000,000  50,000,000  60,000,000  70,000,000  80,000,000  90,000,000  100,000,000  110,000,000  Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec DifferenceRev/Exp Revenues Expenditures Difference Page 15 of 35 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 4,901,598        4,881,556         ‐0.41% Feb 11,015,425      10,472,029       ‐4.93% Mar 16,604,575      15,590,071       ‐6.11% Apr 29,697,444      27,747,760       ‐6.57% May 48,814,541      48,191,829       ‐1.28% Jun 56,141,918      55,079,253       ‐1.89% Jul 61,619,393      60,897,449       ‐1.17% Aug 67,543,287      66,585,570       ‐1.42% Sep 72,338,363      71,408,888       ‐1.28% Oct 83,773,923      83,848,462      0.09% Nov 99,823,464       Dec 105,584,156     Percent of budget 79.41% Property Tax Budget YTD Actual Annual %  over (under) $‐ $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  Millions Total Revenue General Government Budget Actual Last Year $30  $33  Millions Property Tax Budget Actual py g () Jan 9,635                218,705           2169.90% Feb 320,118           489,513           52.92% Mar 982,841           1,037,146        5.53% Apr 9,231,227        7,697,974        ‐16.61% May 16,097,311      16,434,665      2.10% Jun 16,213,191      16,549,647      2.08% Jul 16,320,354      16,637,599      1.94% Aug 16,388,472      16,786,759      2.43% Sep 16,644,516      17,278,401      3.81% Oct 22,547,053      24,338,474      7.95% Nov 31,012,799       Dec 31,364,643       Percent of budget 77.60% $‐ $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  Millions Total Revenue General Government Budget Actual Last Year $‐ $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  $33  Millions Property Tax Budget Actual Last Year Page 16 of 35 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Sales Tax Budget YTD Actual Annual %  over (under) Jan 1,688,260        1,442,659         ‐14.55% Feb 3,848,016        3,376,692         ‐12.25% Mar 5,540,865        4,818,562         ‐13.04% Apr 7,161,203        6,445,782         ‐9.99% May 8,888,836        8,120,233         ‐8.65% Jun 10,537,549      9,663,981         ‐8.29% Jul 12,138,293      11,131,292       ‐8.30% Aug 13,935,185      12,776,450       ‐8.32% Sep 15,628,456      14,350,473       ‐8.18% Oct 17,436,835      15,969,376       ‐8.42% Nov 18,929,142       Dec 20,857,000       Percent of budget 76.57% Note:  Includes Funds 108, 318, 501, and 503.  Excludes CJ Sales Tax and Natural Gas Use Tax. Utility Tax Budget YTD Actual Annual %  over (under) $‐ $3  $6  $9  $12  $15  $18  $21  Millions Sales Tax Budget Actual Last Year $14 $16  Millions Utility Tax Budget Actual y g () Jan 1,379,262        1,282,930        ‐6.98% Feb 2,829,096        2,637,863        ‐6.76% Mar 4,050,000        3,933,596        ‐2.87% Apr 5,225,375        5,193,705        ‐0.61% May 6,516,282        6,425,405        ‐1.39% Jun 7,560,617        7,590,593        0.40% Jul 8,546,617        8,731,006        2.16% Aug 9,718,578        9,862,699        1.48% Sep 10,760,779      10,944,931      1.71% Oct 11,813,935      12,083,388      2.28% Nov 12,878,332       Dec 14,228,000       Percent of budget 84.93% Note:  Includes Natural Gas Use Tax. $‐ $3  $6  $9  $12  $15  $18  $21  Millions Sales Tax Budget Actual Last Year $0  $2  $4  $6  $8  $10  $12  $14  $16  Millions Utility Tax Budget Actual Last Year Page 17 of 35 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Licenses/ Permits Budget YTD Actual Annual %  over (under) Jan 220,191           394,387           79.11% Feb 415,373           496,041           19.42% Mar 640,289           633,007            ‐1.14% Apr 866,016           867,134           0.13% May 1,046,903        1,014,467         ‐3.10% Jun 1,224,807        1,185,796         ‐3.19% Jul 1,451,179        1,444,809         ‐0.44% Aug 1,631,518        1,620,621         ‐0.67% Sep 1,759,093        1,761,961        0.16% Oct 2,024,220        1,975,179         ‐2.42% Nov 2,153,967         Dec 2,386,376         Percent of budget 82.77% Note:  Includes Fund 318. Intergovt'l Budget YTD Actual Annual %  over (under) $11 $12  Millions Intergovernmental Budget Al $‐ $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10  $2.40  Millions Licenses & Permits Budget Actual Last Year g g () Jan 371,847           371,847           0.00% Feb 1,023,691        1,023,691        0.00% Mar 1,536,757        1,536,757        0.00% Apr 2,128,407        2,128,407        0.00% May 2,963,839        2,963,839        0.00% Jun 5,426,368        5,426,368        0.00% Jul 5,897,632        5,897,632        0.00% Aug 6,543,985        6,543,985        0.00% Sep 7,081,151        7,081,151        0.00% Oct 7,809,560        7,809,560        0.00% Nov 11,451,131       Dec 11,804,803       Percent of budget 66.16% Note:  Includes CJ Sales Tax. $‐ $1  $2  $3  $4  $5  $6  $7  $8  $9  $10  $11  $12  Millions Intergovernmental Budget Actual Last Year $‐ $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10  $2.40  Millions Licenses & Permits Budget Actual Last Year Page 18 of 35 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Charges for  Svcs Budget YTD Actual Annual %  over (under) Jan 419,243           445,172           6.18% Feb 848,381           869,415           2.48% Mar 1,387,711        1,336,778         ‐3.67% Apr 1,901,534        1,954,003        2.76% May 2,472,989        2,466,435         ‐0.27% Jun 3,018,488        3,043,138        0.82% Jul 3,868,797        3,828,477         ‐1.04% Aug 4,440,895        4,346,226         ‐2.13% Sep 4,932,422        4,791,514         ‐2.86% Oct 5,419,322        5,288,635         ‐2.41% Nov 5,880,908         Dec 6,425,185         Percent of budget 82.31% Fines &  Forfeits Budget YTD Actual Annual %  over (under) $‐ $1  $2  $3  $4  $5  $6  $7  Millions Charges for Services Budget Actual Last Year $4.00  Millions Fines & Forfeits Budget g () Jan 260,504           239,080           ‐8.22% Feb 534,119           467,413           ‐12.49% Mar 880,487           746,724           ‐15.19% Apr 1,188,597        1,041,335        ‐12.39% May 1,477,369        1,317,878        ‐10.80% Jun 1,785,647        1,691,502        ‐5.27% Jul 2,106,126        1,947,727        ‐7.52% Aug 2,342,895        2,267,132        ‐3.23% Sep 2,591,825        2,500,251        ‐3.53% Oct 2,889,084        2,768,039        ‐4.19% Nov 3,234,625         Dec 3,577,193         Percent of budget 77.38% $‐ $1  $2  $3  $4  $5  $6  $7  Millions Charges for Services Budget Actual Last Year $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  Millions Fines & Forfeits Budget Actual Last Year Page 19 of 35 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Other Taxes Budget YTD Actual Annual %  over (under) Jan 424,298           315,778            ‐25.58% Feb 887,009           854,174            ‐3.70% Mar 1,210,805        1,175,121         ‐2.95% Apr 1,527,046        1,947,556        27.54% May 2,129,929        2,261,610        6.18% Jun 3,055,413        2,591,928         ‐15.17% Jul 3,781,909        3,784,819        0.08% Aug 4,301,294        4,142,037         ‐3.70% Sep 4,584,474        4,349,606         ‐5.12% Oct 5,408,386        5,191,983         ‐4.00% Nov 5,791,753         Dec 6,297,095         Percent of budget 82.45% Misc Budget YTD Actual Annual %  over (under) $1 60 $1.80  Millions Miscellaneous Budget Al $0  $1  $2  $3  $4  $5  $6  $7  Millions Other Taxes Budget Actual Last Year g () Jan 127,631           170,998           33.98% Feb 309,517           257,122           ‐16.93% Mar 374,682           372,244           ‐0.65% Apr 467,795           471,619           0.82% May 607,314           573,528           ‐5.56% Jun 705,404           721,867           2.33% Jul 894,399           880,001           ‐1.61% Aug 973,887           973,082           ‐0.08% Sep 1,088,937        1,083,891        ‐0.46% Oct 1,158,609        1,156,910        ‐0.15% Nov 1,224,926         Dec 1,377,980         Percent of budget 83.96% $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  Millions Miscellaneous Budget Actual Last Year $0  $1  $2  $3  $4  $5  $6  $7  Millions Other Taxes Budget Actual Last Year Page 20 of 35 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Other  Financing Budget YTD Actual Annual %  over (under) Jan 727                    ‐                         0.00% Feb 105                   105                   0.00% Mar 138                   138                   0.00% Apr 245                   245                   0.00% May 6,613,769        6,613,769        0.00% Jun 6,614,434        6,614,434        0.00% Jul 6,614,088        6,614,088        0.00% Aug 7,266,578        7,266,578        0.00% Sep 7,266,711        7,266,711        0.00% Oct 7,266,920        7,266,920        0.00% Nov 7,265,881         Dec 7,265,881         Percent of budget 100.01% REET Budget YTD Actual Annual %  over (under) $3.00 Millions Real Estate Excise Tax Budget $‐ $1.00  $2.00  $3.00  $4.00  $5.00  $6.00  $7.00  $8.00  Millions Other Financing Sources Budget Actual Last Year g () Jan 229,560           71,303              ‐68.94% Feb 298,320           178,545           ‐40.15% Mar 480,120           487,709           1.58% Apr 620,064           769,455           24.09% May 925,800           986,269           6.53% Jun 1,135,488        1,178,010        3.74% Jul 1,335,888        1,327,717        ‐0.61% Aug 1,644,120        1,537,086        ‐6.51% Sep 1,850,592        1,660,140        ‐10.29% Oct 2,058,960        1,843,473        ‐10.47% Nov 2,279,304         Dec 2,400,000         Percent of budget 76.81% Note:  Combines Funds 201, 215, 316, and 318 $0.00 $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 Millions Real Estate Excise Tax Budget Actual Last Year $‐ $1.00  $2.00  $3.00  $4.00  $5.00  $6.00  $7.00  $8.00  Millions Other Financing Sources Budget Actual Last Year Page 21 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 7,273,691        7,161,528         ‐1.54% Feb 15,442,680      15,011,456       ‐2.79% Mar 23,129,139      22,695,538       ‐1.87% Apr 30,707,378      29,817,438       ‐2.90% May 45,202,677      43,949,015       ‐2.77% Jun 53,492,544      52,299,100       ‐2.23% Jul 62,152,697      60,400,225       ‐2.82% Aug 70,248,670      68,336,283       ‐2.72% Sep 78,117,501      76,025,654       ‐2.68% Oct 86,123,086      83,169,404       ‐3.43% Nov 93,884,236       Dec 106,294,349     Percent of budget expended 78.24% Legislative Budget YTD Actual Annual %  over (under) $‐ $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  Millions Total Expenditures General Government Budget Actual Last Year $300,000  Legislative Budget g g () Jan 21,938              21,032              ‐4.13% Feb 44,183              43,671              ‐1.16% Mar 68,592              65,280              ‐4.83% Apr 91,263              87,679              ‐3.93% May 113,769           109,177           ‐4.04% Jun 136,495           131,035           ‐4.00% Jul 158,472           152,284           ‐3.90% Aug 180,456           173,947           ‐3.61% Sep 202,484           195,351           ‐3.52% Oct 224,540           214,315           ‐4.55% Nov 246,799            Dec 267,957            Percent of budget expended 79.98% $‐ $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  Millions Total Expenditures General Government Budget Actual Last Year $‐ $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  Legislative Budget Actual Last Year Page 22 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Court Services Budget YTD Actual Annual %  over (under) Jan 152,880           168,470           10.20% Feb 317,920           328,318           3.27% Mar 483,826           499,117           3.16% Apr 656,729           664,092           1.12% May 829,712           822,296            ‐0.89% Jun 1,004,692        990,091            ‐1.45% Jul 1,173,482        1,168,151         ‐0.45% Aug 1,341,545        1,335,996         ‐0.41% Sep 1,508,802        1,510,390        0.11% Oct 1,677,249        1,657,900         ‐1.15% Nov 1,836,905         Dec 2,016,361         Percent of budget expended 82.22% Executive Budget YTD Actual Annual %  over (under) $‐ $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 $1.80  Millions Executive Budget g () Jan 105,591           134,784           27.65% Feb 250,653           272,736           8.81% Mar 385,511           407,609           5.73% Apr 521,891           539,712           3.41% May 654,166           672,872           2.86% Jun 785,689           800,153           1.84% Jul 935,460           933,696           ‐0.19% Aug 1,087,274        1,038,272        ‐4.51% Sep 1,225,811        1,198,078        ‐2.26% Oct 1,370,153        1,322,666        ‐3.47% Nov 1,499,437         Dec 1,635,047         Percent of budget expended 80.89% $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  $2.00  $2.20  Millions Court Services Budget Actual Last Year $‐ $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  Millions Executive Budget Actual Last Year Page 23 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Finance Budget YTD Actual Annual %  over (under) Jan 254,764           145,053            ‐43.06% Feb 426,592           286,770            ‐32.78% Mar 619,310           443,082            ‐28.46% Apr 794,926           591,163            ‐25.63% May 992,753           770,836            ‐22.35% Jun 1,166,399        926,194            ‐20.59% Jul 1,342,556        1,076,383         ‐19.83% Aug 1,525,165        1,240,000         ‐18.70% Sep 1,700,824        1,420,711         ‐16.47% Oct 1,832,622        1,562,272         ‐14.75% Nov 2,006,095         Dec 2,164,890         Percent of budget expended 72.16% City Attorney Budget YTD Actual Annual %  over (under) $1.60  $1.80  Millions City Attorney Budget At l $‐ $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10  Millions Finance Budget Actual Last Year y y g () Jan 106,795           127,162           19.07% Feb 246,680           266,526           8.05% Mar 403,070           400,465           ‐0.65% Apr 549,408           532,980           ‐2.99% May 691,207           666,194           ‐3.62% Jun 825,807           799,852           ‐3.14% Jul 1,028,793        929,609           ‐9.64% Aug 1,108,058        1,059,996        ‐4.34% Sep 1,244,944        1,190,659        ‐4.36% Oct 1,384,635        1,306,058        ‐5.67% Nov 1,520,418         Dec 1,621,295         Percent of budget expended 80.56% $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  Millions City Attorney Budget Actual Last Year $‐ $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10  Millions Finance Budget Actual Last Year Page 24 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Human  Resources Budget YTD Actual Annual %  over (under) Jan 62,931              71,457              13.55% Feb 148,376           141,160            ‐4.86% Mar 230,102           213,772            ‐7.10% Apr 311,875           283,314            ‐9.16% May 394,684           354,450            ‐10.19% Jun 472,922           428,866            ‐9.32% Jul 547,642           505,205            ‐7.75% Aug 620,352           578,948            ‐6.67% Sep 697,386           650,356            ‐6.74% Oct 773,457           710,580            ‐8.13% Nov 845,873            Dec 918,169            Percent of budget expended 77.39% Public Works Budget YTD Actual Annual %  over (under) $‐ $0.10  $0.20  $0.30  $0.40  $0.50  $0.60  $0.70  $0.80  $0.90  $1.00  Millions Human Resources Budget Actual Last Year $1.20  Millions Public Works Budget g () Jan 40,311              42,532              5.51% Feb 86,173              86,114              ‐0.07% Mar 133,892           129,351           ‐3.39% Apr 179,050           172,378           ‐3.73% May 221,237           215,438           ‐2.62% Jun 264,331           258,597           ‐2.17% Jul 308,727           302,033           ‐2.17% Aug 353,278           346,210           ‐2.00% Sep 394,646           389,451           ‐1.32% Oct 441,919           429,145           ‐2.89% Nov 483,769            Dec 518,399            Percent of budget expended 82.78% Note:  For comparative purposes history does not include Development Svcs division (now in CED). $‐ $0.10  $0.20  $0.30  $0.40  $0.50  $0.60  $0.70  $0.80  $0.90  $1.00  Millions Human Resources Budget Actual Last Year $‐ $0.30  $0.60  $0.90  $1.20  Millions Public Works Budget Actual Last Year Page 25 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Other City  Services Budget YTD Actual Annual %  over (under) Jan 414,785           348,715            ‐15.93% Feb 819,456           701,408            ‐14.41% Mar 1,210,803        1,136,033         ‐6.18% Apr 1,824,496        1,429,727         ‐21.64% May 1,977,632        1,657,444         ‐16.19% Jun 2,363,946        1,849,216         ‐21.77% Jul 2,580,253        2,144,315         ‐16.90% Aug 2,956,550        2,417,038         ‐18.25% Sep 3,332,176        2,583,527         ‐22.47% Oct 3,741,593        2,784,616         ‐25.58% Nov 4,083,716         Dec 4,792,981         Percent of budget expended 58.10% Police Budget YTD Actual Annual %  over (under) $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00  Millions Other City Services Budget Actual Last Year $27  $30  Millions Police Budget Actual g () Jan 2,165,025        2,260,619        4.42% Feb 4,517,801        4,238,853        ‐6.17% Mar 6,790,712        6,677,267        ‐1.67% Apr 8,836,921        8,955,690        1.34% May 11,203,428      11,016,981      ‐1.66% Jun 13,466,812      13,574,734      0.80% Jul 15,954,657      15,859,503      ‐0.60% Aug 18,080,450      18,171,947      0.51% Sep 20,560,448      20,577,677      0.08% Oct 22,762,743      22,423,952      ‐1.49% Nov 25,377,250       Dec 28,022,582       Percent of budget expended 80.02% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00  Millions Other City Services Budget Actual Last Year $‐ $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  Millions Police Budget Actual Last Year Page 26 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Fire & Emerg  Svc Budget YTD Actual Annual %  over (under) Jan 1,838,304        1,768,398         ‐3.80% Feb 4,052,252        4,239,777        4.63% Mar 5,756,484        5,943,458        3.25% Apr 7,466,012        7,607,800        1.90% May 9,173,406        9,312,143        1.51% Jun 10,975,448      11,038,448      0.57% Jul 12,792,783      12,790,432       ‐0.02% Aug 14,560,495      14,548,321       ‐0.08% Sep 16,397,404      16,288,868       ‐0.66% Oct 18,085,144      17,883,348       ‐1.12% Nov 19,884,908       Dec 21,922,009       Percent of budget expended 81.58% City Clerk Budget YTD Actual Annual %  over (under) $‐ $3  $6  $9  $12  $15  $18  $21  $24  Millions Fire & Emergency Services Budget Actual Last Year $1.00 Millions City Clerk Budget y g () Jan 77,013              48,025              ‐37.64% Feb 148,683           92,936              ‐37.49% Mar 257,863           146,137           ‐43.33% Apr 393,130           229,025           ‐41.74% May 465,321           368,812           ‐20.74% Jun 538,843           414,558           ‐23.07% Jul 603,120           459,511           ‐23.81% Aug 661,523           505,723           ‐23.55% Sep 723,147           553,461           ‐23.46% Oct 781,484           685,906           ‐12.23% Nov 843,676            Dec 931,014            Percent of budget expended 73.67% $‐ $3  $6  $9  $12  $15  $18  $21  $24  Millions Fire & Emergency Services Budget Actual Last Year $0.00 $0.20 $0.40 $0.60 $0.80 $1.00 Millions City Clerk Budget Actual Last Year Page 27 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Human  Services Budget YTD Actual Annual %  over (under) Jan 31,267              40,228              28.66% Feb 68,742              72,960              6.14% Mar 97,456              139,024           42.65% Apr 240,125           282,858           17.80% May 298,961           333,690           11.62% Jun 360,953           372,237           3.13% Jul 476,053           475,738            ‐0.07% Aug 528,908           522,266            ‐1.26% Sep 569,793           552,661            ‐3.01% Oct 693,393           640,780            ‐7.59% Nov 748,914            Dec 874,359            Percent of budget expended 73.29% Note:  General Fund only Hearing  Examiner Budget YTD Actual Annual %  over (under) $0.00 $0.10 $0.20 $0.30 $0.40 $0.50 $0.60 $0.70 $0.80 $0.90 $1.00 Millions Human Svcs (Comm Svcs) Budget Actual Last Year $200,000  $220,000  Hearing Examiner Budget g () Jan 16,707              14,619              ‐12.50% Feb 33,528              29,129              ‐13.12% Mar 50,066              43,412              ‐13.29% Apr 67,019              58,097              ‐13.31% May 83,535              72,376              ‐13.36% Jun 99,983              87,146              ‐12.84% Jul 117,131           101,724           ‐13.15% Aug 133,757           116,431           ‐12.95% Sep 150,300           131,145           ‐12.74% Oct 166,956           144,975           ‐13.17% Nov 183,659            Dec 200,440            Percent of budget expended 72.33% $0.00 $0.10 $0.20 $0.30 $0.40 $0.50 $0.60 $0.70 $0.80 $0.90 $1.00 Millions Human Svcs (Comm Svcs) Budget Actual Last Year $‐ $20,000  $40,000  $60,000  $80,000  $100,000  $120,000  $140,000  $160,000  $180,000  $200,000  $220,000  Hearing Examiner Budget Actual Last Year Page 28 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year CED Budget YTD Actual Annual %  over (under) Jan 527,322           555,670           5.38% Feb 1,117,804        1,097,029         ‐1.86% Mar 1,694,350        1,602,874         ‐5.40% Apr 2,239,453        2,116,917         ‐5.47% May 2,803,092        2,646,710         ‐5.58% Jun 3,348,606        3,251,020         ‐2.91% Jul 3,948,563        3,772,492         ‐4.46% Aug 4,527,511        4,317,262         ‐4.64% Sep 5,094,652        5,005,024         ‐1.76% Oct 5,674,356        5,510,153         ‐2.89% Nov 6,234,493         Dec 6,865,275         Percent of budget expended 80.26% Note:  For comparative purposes history includes Development Svcs division (previously in Public Works). Note:  General Fund only General Fund Budget YTD Actual Annual %  over (under)$75  Millions General Fund Budget $‐ $1.50  $3.00  $4.50  $6.00  $7.50  Millions Community & Economic Development Budget Actual Last Year g () Jan 5,767,682        5,746,764        ‐0.36% Feb 12,189,393      11,897,388      ‐2.40% Mar 18,031,280      17,846,883      ‐1.02% Apr 23,980,111      23,551,432      ‐1.79% May 29,651,034      29,019,419      ‐2.13% Jun 35,514,747      34,922,145      ‐1.67% Jul 41,654,185      40,671,076      ‐2.36% Aug 47,312,013      46,372,357      ‐1.99% Sep 53,388,158      52,247,359      ‐2.14% Oct 59,166,024      57,276,666      ‐3.19% Nov 65,394,946       Dec 72,750,777       Percent of budget expended 78.73% $‐ $15  $30  $45  $60  $75  Millions General Fund Budget Actual Last Year $‐ $1.50  $3.00  $4.50  $6.00  $7.50  Millions Community & Economic Development Budget Actual Last Year Page 29 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Community  Svcs Fund Budget YTD Actual Annual %  over (under) Jan 630,299           570,605            ‐9.47% Feb 1,419,564        1,321,394         ‐6.92% Mar 2,185,115        2,026,750         ‐7.25% Apr 2,977,422        2,733,709         ‐8.19% May 3,791,765        3,481,093         ‐8.19% Jun 4,633,283        4,303,348         ‐7.12% Jul 5,779,091        5,324,731         ‐7.86% Aug 6,950,397        6,351,583         ‐8.62% Sep 7,813,005        7,315,110         ‐6.37% Oct 8,658,616        8,057,325         ‐6.94% Nov 9,532,347         Dec 10,492,749       Percent of budget expended 76.79% Street Fund Budget YTD Actual Annual %  over (under) $‐ $2  $4  $6  $8  $10  $12  $14  Millions Community Svcs Fund Budget Actual Last Year $8  $9  Millions Street Fund Budget At l g () Jan 601,390           641,040           6.59% Feb 1,277,334        1,365,252        6.88% Mar 1,960,375        2,078,338        6.02% Apr 2,666,243        2,735,391        2.59% May 3,386,048        3,438,717        1.56% Jun 4,067,122        4,197,932        3.22% Jul 4,805,564        4,826,691        0.44% Aug 5,570,084        5,605,675        0.64% Sep 6,295,873        6,313,022        0.27% Oct 7,009,949        7,077,725        0.97% Nov 7,716,929         Dec 8,549,762         Percent of budget expended 82.78% $‐ $2  $4  $6  $8  $10  $12  $14  Millions Community Svcs Fund Budget Actual Last Year $‐ $1  $2  $3  $4  $5  $6  $7  $8  $9  Millions Street Fund Budget Actual Last Year Page 30 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year CDBG Budget YTD Actual Annual %  over (under) Jan 35,191              13,958               ‐60.34% Feb 75,363              40,304               ‐46.52% Mar 120,736           68,480               ‐43.28% Apr 167,971           100,216            ‐40.34% May 204,663           122,058            ‐40.36% Jun 240,955           153,564            ‐36.27% Jul 275,465           272,301            ‐1.15% Aug 339,295           303,572            ‐10.53% Sep 370,840           332,974            ‐10.21% Oct 429,422           374,878            ‐12.70% Nov 467,929            Dec 532,227            Percent of budget expended 70.44% Library Fund Budget YTD Actual Annual %  over (under)$3.00  Millions Library Fund Budget At l $‐ $100,000  $200,000  $300,000  $400,000  $500,000  $600,000  CDBG Budget Actual Last Year y g () Jan 173,794           173,794           0.00% Feb 229,125           229,125           0.00% Mar 500,663           500,663           0.00% Apr 505,911           505,911           0.00% May 1,067,015        1,067,015        0.00% Jun 1,067,015        1,067,015        0.00% Jul 1,628,119        1,628,119        0.00% Aug 1,628,119        1,628,119        0.00% Sep 1,721,320        1,721,320        0.00% Oct 2,280,221        2,280,221        0.00% Nov 2,218,990         Dec 2,607,263         Percent of budget expended 87.46% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  Millions Library Fund Budget Actual Last Year $‐ $100,000  $200,000  $300,000  $400,000  $500,000  $600,000  CDBG Budget Actual Last Year Page 31 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Museum Fund Budget YTD Actual Annual %  over (under) Jan 15,829              15,310               ‐3.28% Feb 32,775              31,141               ‐4.99% Mar 49,002              46,726               ‐4.64% Apr 65,543              62,643               ‐4.42% May 82,433              78,771               ‐4.44% Jun 99,543              94,929               ‐4.63% Jul 115,981           111,161            ‐4.16% Aug 132,242           127,286            ‐3.75% Sep 148,372           143,470            ‐3.30% Oct 164,641           159,284            ‐3.25% Nov 180,555            Dec 194,120            Percent of budget expended 82.05% Note: Prior to 2009, Museum was part of the Library Fund Farmer's  Market Fund Budget YTD Actual Annual %  over (under) $‐ $20,000  $40,000  $60,000  $80,000  $100,000  $120,000  $140,000  $160,000  $180,000  $200,000  $220,000  Museum Fund Budget Actual Last Year $35,000 $40,000  Farmer's Market Fund Budget At l g () Jan 682                   56                      ‐91.83% Feb 1,530                462                    ‐69.84% Mar 2,581                1,308                ‐49.32% Apr 3,794                1,665                ‐56.11% May 6,315                2,277                ‐63.95% Jun 11,385              19,122              67.96% Jul 17,724              24,521              38.35% Aug 23,587              28,913              22.58% Sep 25,232              33,200              31.58% Oct 28,890              23,602              ‐18.30% Nov 29,897               Dec 34,311               Percent of budget expended 68.79% $‐ $20,000  $40,000  $60,000  $80,000  $100,000  $120,000  $140,000  $160,000  $180,000  $200,000  $220,000  Museum Fund Budget Actual Last Year $‐ $5,000  $10,000  $15,000  $20,000  $25,000  $30,000  $35,000  $40,000  Farmer's Market Fund Budget Actual Last Year Page 32 of 35 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Health &  Wellness Budget YTD Actual Annual %  over (under) Jan 873                    ‐                         0.00% Feb 1,756                 ‐                         0.00% Mar 2,240                 ‐                         0.00% Apr 21,725               ‐                         0.00% May 21,870               ‐                         0.00% Jun 21,870              600                    ‐97.26% Jul 22,616              1,180                 ‐94.78% Aug 22,616              1,770                 ‐92.17% Sep 23,034              2,191                 ‐90.49% Oct 24,096              2,696                 ‐88.81% Nov 24,669               Dec 25,000               Percent of budget expended 10.78% LTGO Funds Budget YTD Actual Annual %  over (under) $11.00  $12.00  Millions LTGO Funds Budget Actual $‐ $5,000  $10,000  $15,000  $20,000  $25,000  $30,000  $35,000  $40,000  $45,000  Fire Health & Wellness Fund Budget Actual Last Year g () Jan ‐                          ‐                         N/A Feb 126,390           126,390           0.00% Mar 126,390           126,390           0.00% Apr 126,471           126,471           0.00% May 6,739,665        6,739,665        0.00% Jun 7,540,445        7,540,445        0.00% Jul 7,540,445        7,540,445        0.00% Aug 7,917,008        7,917,008        0.00% Sep 7,917,008        7,917,008        0.00% Oct 7,917,008        7,917,008        0.00% Nov 7,917,008         Dec 11,108,139       Percent of budget expended 71.27% $‐ $1.00  $2.00  $3.00  $4.00  $5.00  $6.00  $7.00  $8.00  $9.00  $10.00  $11.00  $12.00  Millions LTGO Funds Budget Actual Last Year $‐ $5,000  $10,000  $15,000  $20,000  $25,000  $30,000  $35,000  $40,000  $45,000  Fire Health & Wellness Fund Budget Actual Last Year Page 33 of 35 City of Renton Monthly Enterprise Fund Financial Report ‐ 2010 Budget Year Utilities Budget Revenue Expense Jan 2,801,416        3,901,859      2,612,849       Feb 6,307,320        7,676,067      5,998,348       Mar 9,643,301        11,963,798    8,343,902       Apr 12,048,386      15,716,035    12,647,433     May 16,350,167      19,691,324    15,881,194     Jun 21,455,174      23,695,967    21,496,504     Jul 26,204,723      27,958,146    26,430,562     Aug 29,894,785      31,807,245    29,263,202     Sep 33,313,431      36,506,420    32,642,468     Oct 36,734,374      40,859,646    36,031,261     Nov 40,547,974       Dec 45,924,856       Percent of budget expended 78.46% Note:  Operations only, excludes bond proceeds and transfers to capital. Airport Budget Revenue Expense $0 $5 $10 $15 $20 $25 $30 $35 $40 $45 $50 Millions Utilities Budget Revenue Expense $1.60  $1.80  Millions Airport Budget p g p Jan 66,269              94,268            72,717             Feb 159,667           204,281          156,869           Mar 250,901           310,979          242,660           Apr 329,772           418,081          325,667           May 438,337           517,628          410,185           Jun 517,870           655,253          512,611           Jul 598,355           947,272          604,670           Aug 688,817           1,145,117      692,768           Sep 759,575           1,343,124      790,707           Oct 838,546           1,565,756      869,630           Nov 913,982            Dec 1,001,800         Percent of budget expended 86.81% Note:  Operations only. $0 $5 $10 $15 $20 $25 $30 $35 $40 $45 $50 Millions Utilities Budget Revenue Expense $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  Millions Airport Budget Revenue Expense Page 34 of 35 City of Renton Monthly Enterprise Fund Financial Report ‐ 2010 Budget Year Golf Course Budget Revenue Expense Jan 129,394           68,826            97,947             Feb 258,326           174,258          215,710           Mar 479,768           309,509          434,186           Apr 618,377           505,332          578,898           May 813,533           717,289          741,203           Jun 1,066,444        1,006,321      958,609           Jul 1,232,903        1,301,264      1,111,362       Aug 1,384,039        1,645,422      1,284,140       Sep 1,549,779        1,845,213      1,432,398       Oct 1,857,389        1,992,703      1,563,528       Nov 1,994,766         Dec 2,566,837         Percent of budget expended 60.91% Note:  Operations only. $‐ $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10  $2.40  $2.70  Millions Golf Course Budget Revenue Expense Page 35 of 35