Loading...
HomeMy WebLinkAbout201001, January.pdf  General Governmental Funds $% Beginning Fund Balance 13,300,854$       13,300,854$       11,816,561$       11,816,561$       8,363,430$          8,363,430$          11,955,285$       3,591,855$   42.9% OPERATING REVENUES Property Tax 29,050,790          35,974                     30,660,522          9,419                        31,364,643          29,859                     51,304                     21,445             71.8% Sales Tax 20,825,055          1,710,225             17,995,836          1,458,072             18,609,000          1,453,037             1,289,364             (163,673)         ‐11.3% Sales  Tax ‐ Annexation  Credit ‐                              ‐                              2,132,110             171,175                  2,248,000             180,479                  153,295                  (27,184)             ‐15.1% Criminal Justice Sales Tax 1,755,469             122,184                  1,650,350             138,676                  1,743,000             133,501                  126,465                  (7,035)                ‐5.3% Natural  Gas Use  Tax 253,377                   ‐                              242,891                   ‐                               ‐                               ‐                              20,459                     20,459             0.0% Admission  Tax 197,740                  46,705                     260,269                  57,167                     260,000                  58,965                     74,777                     15,811             26.8% Franchise  Fees 998,288                  240,795                  1,039,031             259,792                  1,040,000             255,537                  45,703                     (209,834)          ‐82.1% Electric  Tax 4,580,037             399,717                  4,963,151             523,055                  5,150,000             497,976                  526,090                  28,114             5.6% Gas Tax 1,565,810             182,058                  1,891,255             299,890                  1,858,000             259,023                  247,250                  (11,773)             ‐4.5% Transfer  Station 380,961                  16,925                     283,985                  9,506                        230,000                  9,142                        5,937                        (3,205)                ‐35.1% TV Cable 1,073,168             81,424                     1,263,743             104,315                  1,250,000             99,350                      ‐                              (99,350)             ‐100.0% Phone/Telegraph/Cellular Phone 2,780,196             168,720                  3,065,347             234,359                  2,860,000             197,211                  266,284                  69,073             35.0% City Utilities 2,606,786             191,232                  2,871,599             242,515                  2,880,000             228,022                  216,909                  (11,113)            ‐4.9% Leasehold Excise  Tax 190,644                  ‐                              146,002                  ‐                              100,000                  ‐                              ‐                              ‐                       ‐100.0% Gambling Excise  Tax 2,157,029             12,230                     2,141,720             7,691                        2,000,000             9,268                        135,608                  126,340          1363.1% Real Estate  Excise  Tax 2,800,103             211,833                  2,418,456             231,334                  2,400,000             203,811                  71,303                     (132,508)         ‐65.0% Less: Municipal  Facilities CIP REET (450,103)                (105,916)                (1,000,000)            (139,761)                (400,000)                (67,768)                   (11,884)                   55,885              ‐82.5% EMS Levy 890,998                  85,744                     1,170,657             ‐                              897,095                  ‐                              ‐                              ‐                       ‐100.0% Penalties & Interest on Delinquent Tax 8,125                        94,624                     1,353                         ‐                               ‐                               ‐                              272                            272                     0.0% Business  License Fees 485,537                  34,569                     424,413                  81,835                     463,067                  59,237                     77,955                     18,718             31.6% Other Licenses and Permits 257,477                  12,320                     176,851                  10,254                     157,250                  8,173                        20,561                     12,388             151.6% Building Permits 2,034,225             281,898                  1,683,082             118,697                  1,766,059             190,319                  295,871                  105,552          55.5% Intergovernmental (Grants, etc)3,734,887             353,358                  3,820,932             203,891                  3,895,228             245,381                  245,381                  ‐                      0.0% Fire District 25 and 40 Contracts 5,013,549             ‐                              5,869,198             ‐                              5,554,723             ‐                              ‐                              ‐                       ‐100.0% Records, Duplicating, and Passport Fees 176,950                  16,498                     187,721                  12,792                     217,585                  17,476                     5,553                        (11,922)             ‐68.2% Public Safety 524,565                  38,327                     521,484                  40,270                     430,000                  32,309                     35,994                     3,685                11.4% Development Service Fees 903,768                  69,485                     677,955                  35,851                     696,708                  46,398                     98,294                     51,896             111.9% Culture  and Recreation 1,678,818             67,012                     1,631,486             65,409                     1,572,240             62,894                     62,673                     (221)                    ‐0.4% Interfund/Interdept‐Services 3,072,950             223,664                  3,225,745             253,147                  3,080,927             233,226                  242,658                  9,432                4.0% Fines  and Forfeits 2,110,973             86,341                     3,817,008             280,849                  3,577,193             221,578                  239,080                  17,502             7.9% Less: Red‐Light Photo Surplus ‐                              ‐                              ‐                              ‐                              ‐                              ‐                              (115,311)                (115,311)         0.0% Interests and Other Earnings 735,910                  83,912                     535,314                  76,476                     434,300                  54,795                     21,570                     (33,225)             ‐60.6% Rents, Leases, and Concessions 676,919                  122,753                  677,960                  51,300                     720,780                  92,595                     135,736                  43,142             46.6% Contributions and Donations 175,513                  4,507                        150,406                  9,329                        111,900                  4,750                        3,016                        (1,735)                ‐36.5% Other Miscellaneous 91,070                     28,431                     166,012                  6,140                        111,000                  14,927                     10,676                     (4,251)                ‐28.5% Agency Type  Deposits (31,840)                   57                               1,202                        56                                ‐                               ‐                               ‐                               ‐                       ‐100.0% Transfer ‐In 381,364                   ‐                              577,004                   ‐                              560,000                   ‐                               ‐                               ‐                       ‐100.0% Total  Operating Revenues 93,687,106          4,917,605             97,342,052          4,853,501             97,838,698          4,831,472             4,598,844             (232,628)          ‐4.8% OPERATING EXPENDITURES Legislative 245,441                  20,000                     247,225                  20,336                     267,957                  21,938                     21,032                     907                     4.1% City Attorney 1,661,225             137,592                  1,248,380             54,056                     1,621,295             106,790                  127,162                  (20,372)             ‐19.1% City Clerk 604,844                  58,012                     646,581                  45,501                     931,014                  77,010                     48,025                     28,985             37.6% Court Services 1,744,122             129,000                  1,819,731             141,212                  2,011,393             152,505                  168,470                  (15,966)             ‐10.5% Executive 966,373                  71,955                     1,499,747             87,309                     1,635,047             105,593                  134,784                  (29,192)             ‐27.6% Hearing Examiner 166,820                  13,584                     171,911                  14,648                     200,440                  16,706                     14,619                     2,088                12.5% Community and Eco Dvlpmnt Admin ‐                              ‐                              265,269                  22,791                     550,312                  47,280                     44,995                     2,285                4.8% Development Services 4,178,096             323,486                  3,615,129             301,504                  3,247,282             260,421                  309,206                  (48,786)             ‐18.7% Economic  Development 1,875,749             134,715                  1,244,175             85,932                     1,277,641             90,358                     92,877                     (2,520)                ‐2.8% Planning ‐                              ‐                              1,525,460             104,143                  1,238,235             84,534                     108,648                  (24,113)             ‐28.5% Finance 1,909,652             229,924                  1,969,936             226,614                  1,964,890             231,222                  145,053                  86,170             37.3% Human Resources 981,306                  59,455                     853,063                  66,273                     913,669                  62,623                     71,457                     (8,834)                ‐14.1% Police 23,894,898          1,959,938             25,833,756          1,882,172             27,610,835          2,133,255             2,260,619             (127,364)         ‐6.0% Fire 21,763,640          1,693,108             20,375,286          1,834,119             21,802,109          1,824,939             1,768,398             56,541             3.1% Facilities 3,614,850             253,457                  ‐                              ‐                              ‐                              ‐                              ‐                              ‐                      100.0% Parks 4,892,441             249,871                  4,820,336             246,736                  5,061,804             258,806                  234,762                  24,044             9.3% Recreation 4,383,163             300,820                  7,878,458             491,913                  4,936,795             319,172                  314,405                  4,767                1.5% Human Services 1,162,553             43,438                     1,194,142             55,456                     1,165,599             48,912                     54,186                     (5,274)                ‐10.8% Community Resources  & Events 367,627                  19,439                     348,185                  19,811                     355,694                  19,503                     21,438                     (1,935)                ‐9.9% Library 1,890,886             148,194                  2,312,128             146,852                  2,544,263             178,604                  173,794                  4,810                2.7% Museum 136,327                  11,007                     140,801                  11,589                     194,120                  15,828                     15,310                     519                     3.3% Public Works Administration 886,867                  75,710                     463,533                  39,587                     518,399                  44,261                     42,532                     1,728                3.9% Street Maintenance 3,212,111             215,427                  3,794,716             330,813                  3,366,524             262,448                  240,463                  21,986             8.4% Technical Services 515,708                  32,670                     478,493                  34,353                     ‐                              ‐                              ‐                              ‐                      100.0% Transportation 4,841,955             305,094                  5,110,639             341,612                  5,110,456             332,070                  400,577                  (68,507)             ‐20.6% Debt Service 4,263,739             ‐                              4,176,822             ‐                              4,494,945             ‐                              ‐                              ‐                      100.0% Non‐Departmental 4,622,865             478,667                  4,370,376             299,635                  4,792,981             414,799                  348,715                  66,084             15.9% Other 388,142                  1,578                        799,051                  150                            25,000                     36                               ‐                              36                        100.0% Total  Operating Expenditures 95,171,399          6,966,142             97,203,328          6,905,118             97,838,698          7,109,614             7,161,528             (51,913)            ‐0.7% Total  Ending Fund Balance 11,816,561$       11,252,317$       11,955,285$       9,764,945$          8,363,430$          6,085,288$          9,392,601$          3,307,314      54.3% 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 January 2010 Page 1 of 37 Monthly Financial Report January 2010          OVERVIEW  This financial overview reflects the City’s overall financial position for the fiscal year through January 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 two preceding years.  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 67% of all resources supporting general governmental activities.   The following section provides detail  information on property, sales, utility, and other taxes.    Property Tax  January’s collection is $51k, making  the total year‐to‐date collection $51k  or 0.2% of the total budget.  In  comparison to the previous year, the  City collected $42k or 445% higher.   Compared to the budget, the City is  above projection by $21k or 72%.   This difference in both the prior year  and budget is primarily due to the  homes and commercial properties  that were delinquent in their  property tax payments for 2009 and  making their payments late  2009/early 2010, which would result  in the City recording the amounts in  January.        Sales Tax  January 2010 sales tax receipts totaled  $1.3 million.  Compared to the same  month last year, it is $169k or 12% less.   Compared to the projected current  month’s budget, it is under projections  by $164k or 11%.  Based on the year‐to‐ date collection, the City is projecting  sales tax revenues to be $16.5 million  by the end of 2010, which is $2.1  million under budget.        2009 2010 2010 Actual Budget Actual $ % $ % Jan 1,458,072$     1,453,037$     1,289,364$  (168,709)$   ‐12% (163,673)$   ‐11% Feb 1,863,430        1,810,870        ‐                      Mar 1,461,007        1,324,501        ‐                      Apr 1,398,021        1,367,927        ‐                      May 1,490,778        1,601,481        ‐                      Jun 1,361,808        1,465,350        ‐                      Jul 1,443,891        1,557,501        ‐                      Aug 1,551,415        1,662,993        ‐                      Sep 1,454,550        1,559,837        ‐                      Oct 1,560,217        1,640,973        ‐                      Nov 1,440,143        1,638,470        ‐                      Dec 1,512,506        1,526,059        ‐                      YTD  Total 1,458,072$     1,453,037$     1,289,364$  (168,709)$   ‐12% (163,673)$   ‐11% Annual Total 17,995,836$  18,609,000$   2010 vs. Budget2010 vs. 2009 Month Year  to Date through January Local Retail  Sales  Tax Revenues 2009 2010 2010 Actual Budget Actual $ % $ % Jan 9,419$               29,859$            51,304$            41,885$     445% 21,445$     72% Feb 303,513            343,350             Mar 647,845            683,920             Apr 8,063,214        7,376,995         May 6,711,943        7,741,430         Jun 113,279            121,150             Jul 104,757            134,776             Aug 66,589               85,226                Sep 250,296            150,707             Oct 5,770,027        7,038,559         Nov 8,275,695        7,410,047         Dec 343,945            248,626             YTD  Total 9,419$               29,859$            51,304$            41,885$     445% 21,445$     72% Annual  Total 30,660,522$  31,364,643$   Property Tax Revenues Year to Date through January 2010 vs . 2009 2010 vs. Budget Month Page 2 of 37 Monthly Financial Report January 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 2008 2009 2010 Bgt YTD  Act Chg 10/09 10Act vs  Bgt New Construction 418,276$         325,303$         230,267$         123,561$         (201,741)$       ‐62% $   (106,706)‐46% Auto Sales 296,655            235,477            323,490            211,836            (23,641)             ‐10%       (111,655)‐35% General Retail 518,245            514,191            355,498            486,982            (27,209)             ‐5%         131,484 37% Manufacturing 70,943               70,058               67,115               68,593               (1,466)                ‐2%               1,478 2% Wholesale 78,603               77,473               135,200            68,484               (8,989)                ‐12%          (66,715)‐49% Service 298,054            288,037            299,859            289,984            1,948                 1%             (9,875)‐3% Other 29,450               32,529               41,608               39,924               7,395                 23%             (1,684)‐4% Total 1,710,224$     1,543,068$     1,453,037$     1,289,364$     (253,704)         ‐16%(163,673)$    ‐11% Note: Excludes Annexation  Credit and Criminal Justice Sales  Tax revenue.      Utility tax  January utility taxes revenue totals $1.3  million, which is $131k lower than same  month last year and ahead of budget by  $28k.  The City is projecting utility tax  revenues to meet the 2010 budget by the  end of the year.                        The table below breaks out Utility Tax by source, the lower amount generated from the transfer station is due to reduced  business activity:    Utility Tax by Type 2008 2009 2010 Bgt YTD  Act Chg 10/09 10Act  vs  Bgt Electrical 399,717            523,055            449,460            526,090            1% 17% Natural  Gas 182,058            299,890            185,942            267,709             ‐11% 44% Cell 97,473               154,579            105,940            186,705            21% 76% Phone 71,248               79,780               66,274               79,580               0% 20% Cable 81,424               104,315            94,840                ‐                        0%‐100% Transfer  Station 16,925               9,506                  10,219               5,937                   ‐38%‐42% City Utilities 191,232            242,515            204,987            216,909             ‐11% 6% YTD  Total 1,040,077        1,413,641        1,117,661        1,282,930        ‐9% 15% Annual Total 13,240,334     14,581,971     14,228,000      YTD  as % of 8% 10%8%      2009 2010 2010 Actual Budget Actual $ % $ % Jan 1,413,641$     1,254,767$     1,282,930$  (130,711)$   ‐9% 28,163$     2% Feb 1,485,870        2,587,931         Mar 1,251,275        3,839,141         Apr 1,204,619        4,977,239         May 1,322,947        6,169,119         Jun 1,070,303        7,265,386         Jul 1,010,609        8,404,053         Aug 1,201,122        9,604,469         Sep 1,068,035        10,627,747      Oct 1,079,380        11,729,279      Nov 1,090,897        12,872,783      Dec 1,383,272        14,228,000      YTD  Total 1,413,641$     1,254,767$     1,282,930$  (130,711)$   ‐9% 28,163$     2% Annual Total 14,581,971$  93,559,913$   2010 vs. Budget2010 vs. 2009 Year to Da te through January Utility Tax Revenues Month Page 3 of 37 Monthly Financial Report January 2010        Other Taxes     The City collected $71k in Real Estate  Excise Tax revenues (REET) in January.   This is $133k below current month’s  budget and $160k behind the same  month last year.  A struggling real estate  market is a major factor in the decline of  REET.        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.       January Gambling Tax collections  total $135k.  Year‐to‐date total of  $136k is $128k or 1663% above the  year before; and $128k or 629%  above budget.  The amount budgeted  for January was lower partially due to  the prior year’s collection of $8k  (since the budget is based on the  previous two years’ history) and the  additional collection from the  monthly reporting of larger  taxpayers.                    Franchise Fees are due quarterly and the  year‐to‐date revenue collections are  $46.  This is $210k or 82% under the  projected year‐to‐date budget and  $214k or 82% lower than 2009.        2009 2010 2010 Actual Budget Actual $ % $ % Jan 231,334$      203,811$      71,303$         (160,031)$   ‐69% (132,508)$   ‐65% Feb 69,290            110,531          Mar 183,177         173,727          Apr 141,038         313,557          May 308,077         237,133          Jun 211,295         200,979          Jul 201,960         205,047          Aug 310,599         266,493          Sep 208,046         177,788          Oct 209,975         183,300          Nov 222,052         249,543          Dec 121,614         78,092             YTD  Total 231,334$      203,808$      71,303$         (160,031)$   ‐69% (132,508)$   ‐65% Annual Total 2,418,456$  2,400,000$   2010 vs. 2009 Real Estate Excise  Tax Revenues Ye ar to Date through January Month 2010 vs. Budget 2009 2010 2010 Actual Budget Actual $ % $ % Jan 7,691$            7,182$            135,608$      127,917$      1663% 128,426$   1788% Feb 391,054         365,177          ‐                      Mar 171,097         159,776         ‐                      Apr 177,856         166,087         ‐                      May 178,840         167,006         ‐                      Jun 186,920         174,551         ‐                      Jul 182,851         170,752         ‐                      Aug 210,237         196,325         ‐                      Sep 173,745         162,248         ‐                      Oct 176,490         164,811         ‐                      Nov 146,960         137,236         ‐                      Dec 137,979         128,849         ‐                      YTD  Total 7,691$            18,603$         135,608$      127,917$      1663% 128,426$   629% Annual  Total 2,141,720$  2,000,000$   2010 vs. Budget2010 vs. 2009 Gambling Tax Revenue Month Year  to Date through January 2009 2010 2010 Actual Budget Actual $ % $ % Jan 259,792$      255,537$      45,703$         (214,089)$      ‐82% (209,834)$   ‐82% Feb 200                    102                     ‐                      Mar ‐                      ‐                     ‐                      Apr ‐                     102,746         ‐                      May 258,593         132,005         ‐                      Jun ‐                     ‐                     ‐                      Jul 260,647         244,359         ‐                      Aug ‐                     ‐                     ‐                      Sep ‐                     24,721            ‐                      Oct 259,798         258,846         ‐                      Nov ‐                     ‐                     ‐                      Dec ‐                     21,683            ‐                      YTD Total 259,792$      255,537$      45,703$         (214,089)$     ‐82% (209,834)$  ‐82% Annual  Total 1,039,031$  1,040,000$   Franchise Fees Revenue Year  to Date through January Month 2010 vs. 2009 2010 vs. Budget Page 4 of 37 Monthly Financial Report January 2010        Admission Tax returns are due  quarterly in January, April, July, and  October each year.  January 2010  collections represent activities  conducted during the 4th quarter of  2009.      The report shows an increase of $18k  from the year before, primarily due  to the Landing 14 Regal Cinemas that  opened in mid‐October 2008.  The total 2010 revenue is $16k 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 92% of the revenue in this category.  As of the end of  January, we have collected 17% of the projected revenue from licenses and permits.  The percentage of year‐to‐date actual  to year‐to‐date budget is over by 55%.  Licenses and Permits totaled $394k by the end of January.  The following sections  provide detail information for Building  Permits and Business Licenses revenues.    Building Permits and Fees revenues  totaled $286k in January.  The higher  activity may partially attributable to the  new fee schedule and adopted impact  fees.   The year‐to‐date development  fees revenue is $120k better than the  budget and $179k more than 2009.                      Business Licenses totaled $78k since the start of the  year, which is 5% under last year and 32% above  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 over the budget by $19k and $4k  below last year.      2009 2010 2010 Actual Budget Actual $ % $ % Jan 106,633$      165,811$      285,826$   179,192$        168% 120,015$  72% Feb 124,555         184,933         ‐                   Mar 179,330         167,034         ‐                   Apr 114,694         176,027         ‐                   May 125,344         128,531         ‐                   Jun 131,705         114,774         ‐                   Jul 106,810         110,852         ‐                   Aug 119,439         96,612            ‐                   Sep 101,087         103,413         ‐                   Oct 131,899         136,954         ‐                   Nov 82,516            107,797         ‐                   Dec 169,581         112,320         ‐                   YTD Total 106,633$      165,811$      285,826$   179,192$        168% 120,015$  72% Annual Total 1,493,593$  1,605,059$   Building Permits and Fees Year  to Date through January 2010 vs. Budget2010 vs. 2009 Month 2009 2010 2010 Actual Budget Actual $ % $ % Jan 81,835$     59,237$     77,955$   (3,880)$   ‐5% 18,718$   32% Feb 30,180        28,470        ‐                Mar 6,337           37,791        ‐                Apr 73,055        53,038        ‐                May 14,185        20,801        ‐                Jun 9,352           33,258        ‐                Jul 80,579        57,140        ‐                Aug 20,280        21,268        ‐                Sep 1,746           36,504        ‐                Oct 84,002        88,095        ‐                Nov 18,937        19,872        ‐                Dec 3,922           7,592           ‐                YTD  Total 81,835$     59,237$     77,955$   (3,880)$   ‐5% 18,718$   32% Annual  Total 424,413$  463,067$   Business Licenses Mo nth Year to Date through January 2010 vs. Budget2010 vs. 2009 2009 2010 2010 Actual Budget Actual $ % $ % Jan 57,167$         58,965$         74,777$         17,610$         31% 15,811$      27% Apr 61,163            63,415            ‐                      Jul 70,690            69,911            ‐                      Oct 70,729            67,414            ‐                      Nov 520                    295                    ‐                      YTD  Total 57,167$         58,965$         74,777$         17,610$         31% 15,811$      27% Annual  Total 260,269$      260,000$       Year  to Date through January Month 2010 vs. 2009 2010 vs. Budget Admission Tax Revenue Page 5 of 37 Monthly Financial Report January 2010        Intergovernmental  These revenue sources include  federal (direct and indirect)  grants, state grants, state shared  revenues, local grants,  entitlements, impact payments,  in‐lieu taxes, and service  revenues.  State shared revenues  and Fire Districts’ 25 and 40  contracts compose 81% of the  total revenues in this category.   The year‐to‐date total  Intergovernmental revenue is  $372k or 3% of the budget.    State Shared Revenue collections  totaled $302k since the start of 2010.   Compared to the projected budget,  State Shared Revenues are over by $16k  or 6%.  Compared to the prior year, the  City is collecting $17k less or down by  5%.  The actual collection that lags  budget is primarily due to the reduced  criminal justice sales tax (King County  countywide sales tax decrease).          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 69% of the total revenue in this category.  The year‐to‐date total charges for services are $445k or 7% of the  budget.  This is 14% above budget projections.  The following sections provide detail information for Plan Review with  Inspection Fees, Recreation, and Interfund Services.    Plan Review and Inspection fees are $98k since  the start of the year.  Compared to the budget,  the City is collecting $52k or 112% more than  anticipated revenue.   Compared to the prior  year, the City is collecting $62k or 174% more.      Intergovernmental 2008 2009 2010 Bgt YTD Act Chg 10/09 10Act  vs  Bgt Fire  District #25 ‐                         ‐                        ‐                        ‐                        N/A N/A Fire  District #40 ‐                         ‐                        ‐                        ‐                        N/A N/A State  Shared Revenue 246,571            318,174            301,591            301,591             ‐5% 0% Federal Grants 198,448            5,140                  3,069                  3,069                   ‐40% 0% State  Grants ‐                        5,300                  18,168               18,168               243% 0% Other Grants 30,522               13,953               49,018               49,018               251% 0% ARRA Grants ‐                         ‐                        ‐                        ‐                        N/A N/A Total  Rev YTD 475,542            342,567            371,847            371,847            9% 0% Total  Rev Annual 10,503,905     11,340,480     11,192,951      YTD  %5%3%3%3% Note:  Includes  CJ Sales  Tax. 2009 2010 2010 Actual Budget Actual $ % $ % Crim Just Sales  Tax 138,676$      133,501$      126,465$   (12,211)$   ‐9% (7,035)$    ‐5% Judicial Contribution 12,143            3,468                ‐                  (12,143)$  0% (3,468)      0% Crim Just ‐ Pop 4,291               ‐                     4,619            328              8% 4,619        100% Crim Just ‐ Spec Prog 16,479            14,719            17,557         1,078         7% 2,837        19% State DUI 3,668               2,337               3,942            274              7% 1,606        69% Liquor Profits ‐                     ‐                     ‐                   ‐               N/A ‐              N/A Liquor Excise  Tax 97,810            90,958            103,016      5,205         5% 12,058     13% Fuel Tax 45,107            40,750            45,992         885              2% 5,242        13% YTD  Total 318,174$      285,733$      301,591$   (16,583)$   ‐5% 15,858$  6% Annual Total 3,986,791$  3,988,931$   State Shared Revenues 2010 vs. 2009 Revenue Year to Date through January 2010 vs. Budget 2009 2010 2010 Actual Budget Actual $ % $ % Jan 35,851$     46,473$     98,294$  62,443$  174% 51,821$  112% Feb 45,883        51,359         ‐               Mar 86,425        104,237     ‐               Apr 27,659        45,577        ‐               May 58,715        57,465        ‐               Jun 43,085        47,549        ‐               Jul 61,541        58,692        ‐               Aug 43,348        48,227        ‐               Sep 36,509        45,087        ‐               Oct 67,095        64,910        ‐               Nov 59,883        53,992        ‐               Dec 109,397     73,139        ‐               YTD  Total 35,851$     46,473$     98,294$  62,443$  174% 51,821$  112% Annual Total 675,391$  696,708$   Month 2010 vs . 2009 2010 vs. Budget Year to Date through January Plan Review / Inspection Page 6 of 37 Monthly Financial Report January 2010        Recreation revenues totaled $63k since the start  of the year.  Compared to the projected monthly  budget, the City collected $221 or less.  Compared  to the same month the prior year, the City  collected $3k or 4% less.  Based on the current  month’s collection, the City is projecting  Recreation revenues to meet the budget  projection for 2010.                        The year‐to‐date collections for Interfund  Service revenues are $243k.  Compared to the  projected budget, the revenues are above by  $9k or up by 4%.  Compared to the prior year,  the revenues are under by $10k or down by 4%.                              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 $239k.  This is  $42k lower than a year ago and $18k over  budget.  The increased revenue is almost  entirely due to the Photo Enforcement program  implemented in June 2008.  The higher  revenues also require additional expenses  associated to the program as discussed in the  section below.          2009 2010 2010 Actual Budget Actual $ % $ % Jan 65,409$         62,894$         62,673$      (2,736)$   ‐4% (221)$       0% Feb 72,988            73,627             ‐                   Mar 81,034            76,730             ‐                   Apr 141,783         152,787          ‐                   May 145,050         148,257          ‐                   Jun 154,237         150,313          ‐                   Jul 429,059         390,363          ‐                   Aug 203,222         209,608          ‐                   Sep 123,439         105,960          ‐                   Oct 79,452            72,263             ‐                   Nov 61,971            55,423             ‐                   Dec 73,842            74,015             ‐                   YTD Total 65,409$         62,894$         62,673$      (2,736)$   ‐4% (221)$       0% Annual Total 1,631,486$  1,572,240$   2010 vs. Budget Year  to Date through January 2010 vs. 2009 Month Recreation 2009 2010 2010 Actual Budget Actual $ % $ % Jan 280,849$      221,578$      239,080$   (41,769)$   ‐15% 17,502$  8% Feb 285,126         237,113          Mar 370,244         278,241          Apr 331,546         294,238          May 310,888         200,746          Jun 330,829         252,055          Jul 321,486         260,370          Aug 256,668         239,868          Sep 269,199         321,516          Oct 318,272         367,950          Nov 368,928         414,303          Dec 372,972         489,213          YTD  Total 280,849$      221,571$      239,080$   (41,769)$   ‐15% 17,502$  8% Annual  Total 3,817,008$  3,577,193$   2010 vs. Budget2010 vs. 2009 Year to Date through January Fines  and Penalties by Month Month 2009 2010 2010 Actual Budget Actual $ % $ % Jan 253,147$      233,226$      242,658$   (10,489)$   ‐4% 9,432$    4% Feb 243,496         220,573          ‐                   Mar 286,921         257,268          ‐                   Apr 280,094         254,026         ‐                   May 282,056         249,388         ‐                   Jun 270,778         283,900         ‐                   Jul 263,897         251,656         ‐                   Aug 258,386         247,246         ‐                   Sep 265,902         227,116         ‐                   Oct 266,313         278,719         ‐                   Nov 281,154         295,494         ‐                   Dec 273,599         282,315         ‐                   YTD  Total 253,147$      233,226$      242,658$   (10,489)$   ‐4% 9,432$    4% Annual Total 3,225,745$  3,080,927$   Interfund Services Ye ar to Date through January 2010 vs. 2009 2010 vs. Budget Month Page 7 of 37 Monthly Financial Report January 2010        Year to Date through January 2009 2010 2010 Actual Budget Actual $ % $ % Civil Penalties 958$                 1,026$             ‐$               (958)$         0% (1,026)$     0% Civil Infraction Penalties 58,655            53,836             ‐                  (58,655)     0% (53,836)     0% Civil Parking Infraction Penalties 12,189            11,799             ‐                  (12,189)     0% (11,799)     0% Photo Enforcement  Program 182,568         129,532         187,281      4,713         3% 57,749      45% Crim Traffic  Misdemeanor  Fines 8,896               8,608                ‐                  (8,896)        0% (8,608)        0% Criminal Non‐Traffic  Fines 4,323               3,763                ‐                  (4,323)        0%(3,763)        0% Criminal Costs 8,265               6,852               46,627         38,362      464% 39,776      581% Non‐Court Fines, Forfeitures  and Penalties 4,996               4,414               5,172            176              4% 758              17% YTD  Total 280,849$      219,830$      239,080$   (41,769)$   ‐15% 19,250$   9% 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.   This budget was based on the prior year revenue.   The year‐to‐date collections from this program  equates to $187k.  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 92% of  the total revenue in this category.  The year‐to‐ date total miscellaneous is $171k.  Compared to  the projected year‐to‐date budget, the revenues  are over by $10k or up by 6%.                    Favorable Budget Actual Budget Actual (Unfavorable) 1 Jan 173,461$      187,281$  70,097$     71,970$     115,311$           Feb 166,708          ‐                 69,919         ‐                 ‐                          Mar 245,529         ‐                 69,697        ‐                 ‐                          Apr 209,106         ‐                 70,260        ‐                 ‐                          May 192,106         ‐                 70,181        ‐                 ‐                          Jun 223,152         ‐                 69,786        ‐                 ‐                          Jul 143,538         ‐                 69,991        ‐                 ‐                          Aug 143,576         ‐                 69,525        ‐                 ‐                          Sep 149,862         ‐                 69,700        ‐                 ‐                          Oct 188,205         ‐                 69,347        ‐                 ‐                          Nov 240,433         ‐                 70,269        ‐                 ‐                          Dec 174,325         ‐                 73,194        ‐                 ‐                          YTD  Total 173,461$      187,281$  70,097$     71,970$     115,311$           Annual Total 2,250,000$  841,964$   1Actuals  of Revenues and Expenses Revenues Expenses Red‐Light Photo Enforcement Program Year  to Date through January Month 2009 2010 2010 Actual Budget Actual $ % $ % Jan 143,245$      161,103$      170,998$   27,753$  19% 9,894$    6% Feb 192,680         138,169          Mar 59,923            62,728             Apr 100,349         93,224             May 156,161         166,995          Jun 100,207         95,149             Jul 819,671         477,481          Aug 80,681            73,379             Sep (468,642)        (173,144)         Oct 76,125            66,823             Nov 73,002            90,983             Dec 196,289         125,089          YTD  Total 143,245$      161,103$      170,998$   27,753$  19% 9,894$    6% Annual Total 1,529,692$  1,377,980$   Year  to Date through January Month 2010 vs. Budget2010 vs. 2009 Miscellaneous  Revenues by Month Page 8 of 37 Monthly Financial Report January 2010        2009 2010 2010 Actual Budget Actual $ % $ % Interests  and Other Earnings 76,476$         52,141$         21,570$      (54,906)$   ‐72% (30,571)$   ‐59% Rents, Leases, and Concessions 51,300            92,595            135,736      84,436      165% 43,142      47% Contributions/Donations from  Private Sources 9,329               4,750               3,016            (6,313)         ‐68% (1,735)         ‐37% Other 6,140               11,614            10,676         4,535         74% (938)             ‐8% YTD  Total 143,245$      161,100$      170,998$   27,753$   19% 9,898$      6% Annual  Total 1,529,692$  1,377,980$   2010 vs. Budget Miscellaneous Revenues by Type Year to Date through January Revenue 2010 vs. 2009       EXPENSES  The City has completed the year and our operating costs are running below the trends from prior years.  Overall the City has  expended 7% of its budgeted general governmental expenditures.  The table on page 1 gives the expenditure budgets for  each department.  Some of the budgeted expenditures will be to be carried forward from 2009 to complete projects we  have started and not yet complete as well as budgeted expenditures related to grants.          Page 9 of 37 Monthly Financial Report January 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 ‐                  ‐             ‐              ‐               5,600           5,850         ‐               Grants 4,951             ‐             ‐              ‐               ‐               21,307       ‐               Charges  for services 1,092             52,781       1,205,322    709,742       1,427,238    456,742     ‐               Interdepartmental  services ‐                 ‐             ‐              7,730           7,456           36,307       ‐               Rents, leases, and misc fees 92,598           15,091       6,000           8,598           ‐               ‐             ‐               Interest and other misc 1,276             1,268         1,069           45,169         12,521         9,858         14                TOTAL REVENUES 99,917           69,140       1,212,391    771,239       1,452,815    530,064     14                EXPENSES: Utility billing ‐                  ‐             10,438         7,625           7,625           12,438        ‐               Utility systems ‐                  ‐             521,004       210,266       172,706       163,015      ‐               Utility maintenance ‐                  ‐             15,201         339,181       1,028,002    125,348      ‐               Transportation 72,717            ‐             ‐              ‐               ‐               ‐             ‐               Golf ‐                 95,925       ‐              ‐               ‐               ‐             ‐               TOTAL EXPENSES 72,717           95,925       546,643       557,072       1,208,333    300,801     ‐               AMOUNT AVAILABLE FOR DEBT SERVICE 27,200           (26,785)      665,748       214,167       244,482       229,263     14                DEBT SERVICE: Principal ‐                 1,883         ‐              ‐               ‐               ‐             ‐               Interest and other debt service costs ‐                 139            ‐              ‐               ‐               ‐             ‐               TOTAL DEBT SERVICE ‐                 2,022         ‐              ‐               ‐               ‐             ‐               CAPITAL PROJECTS 22,688           ‐             ‐              41,907         19,995         100,932     ‐               TRANSFERS IN/(OUT)‐                 ‐             ‐              ‐               ‐               ‐             ‐               CHANGE  IN FUND BALANCE 4,512             (28,807)      665,748       172,260       224,487       128,331     14                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, January 31, 2010 1,053,595      1,056,994  991,782       7,329,368    3,000,025    4,111,173  15,619             Page 10 of 37 Monthly Financial Report January 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 ‐             ‐              ‐             ‐                      ‐              ‐               ‐             Charges  for services Equipment rental  m&o 162,730     163,549      ‐             ‐                      ‐              ‐               ‐             Telecommunications ‐            23,794        ‐             ‐                      ‐              ‐               ‐             Print and mail ‐            8,934          ‐             28,110                 ‐              ‐               ‐             Communications ‐            ‐              ‐             44,998                 ‐              ‐               ‐             Facilities ‐            ‐              203,737      ‐                      ‐              ‐               ‐             Data  cards  and cell  phones ‐            9,342          ‐             ‐                      ‐              ‐               ‐             IT service contracts ‐            20,878         ‐             ‐                      ‐              ‐               ‐             Interest and other misc 4,736         2,214          28               126                      5,797           5,630           3,157          Internal service fund misc: Vehicle/equipment capital  recovery 116,322     83,030        ‐             ‐                      ‐              ‐               ‐             Insurance premiums ‐            ‐              ‐             ‐                      114,675       ‐               ‐             Worker's  compensation  / unemployment ‐            ‐              ‐             ‐                      105,647       ‐               ‐             Benefit premiums ‐            ‐              ‐             ‐                      ‐              941,595       146,720      Other misc ‐            ‐              ‐             ‐                      ‐              58,820         ‐             Disposal  of capital  assets ‐            ‐              ‐             ‐                      ‐              ‐               ‐             Insurance recoveries ‐            ‐              ‐             ‐                      15,722         17,451         5,909          TOTAL REVENUES 283,788     311,741      203,765      73,234                 241,841       1,023,496    155,786      EXPENSES: Communications 41,954                  Equipment rental 117,310      Facilities 324,976       Healthcare 899,768        Information technology 260,448       Print and mail ‐              26,510                  Retiree  healthcare 99,756        Risk management 825,172        TOTAL EXPENSES 117,310     260,448      324,976      68,464                 825,172       899,768       99,756        AMOUNT AVAILABLE FOR DEBT SERVICE 166,478     51,293        (121,212)    4,770                   (583,331)     123,728       56,030        DEBT SERVICE: Principal ‐             ‐              ‐             ‐                      ‐              ‐               ‐             Interest and other debt service costs ‐            ‐              ‐             ‐                      ‐              ‐               ‐             TOTAL DEBT SERVICE ‐            ‐              ‐             ‐                      ‐              ‐               ‐             CAPITAL PROJECTS 290,635     9,093          25,000        ‐                      ‐              ‐               ‐             TRANSFERS IN ‐            ‐              ‐             ‐                      ‐              ‐               ‐             TRANSFERS (OUT)‐            ‐              ‐             ‐                      ‐              ‐               ‐             CH ANGE IN FUND BALANCE (124,157)   42,200        (146,212)    4,770                   (583,331)     123,728       56,030        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, January 31, 2010 4,469,242  1,690,131   (55,037)      116,588               5,456,178    4,916,180    2,876,503     Page 11 of 37 Monthly Financial Report January 2010        THE SCORE    The South Correctional Entity (SCORE) is a public development authority (PDA) that 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 cost 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 ‐                  Des  Moines ‐                  Federal  Way ‐                  Renton ‐                  Seatac ‐                  Tukwila ‐                  Interest and other misc 29,229            Bond proceeds ‐                  Tax Credit (BABs)‐                  TOTAL REVENUES 29,229            EXPENSES: Salaries  and wages ‐                  Benefits ‐                  Supplies ‐                  Professional services ‐                  Intergovernmental ‐                  Construction 2,329,943       TOTAL EXPENSES 2,329,943       AMOUNT AVAILABLE FOR DEBT SERVICE (2,300,713)      DEBT SERVICE: Principal ‐                  Interest and other debt service costs 816,324          TOTAL DEBT SERVICE 816,324          CHANGE IN FUND BALANCE (3,117,038)      BEGINNING FUND BALANCE, January 1, 2010 80,644,637     ENDING FUND BALANCE, January 31, 2010 77,527,599     Page 12 of 37 Monthly Financial Report January 2010        FUND BALANCE  Page 14 shows the ending fund balance as of January 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 balances (or beginning balance) includes funds identified as being reserved for specific purposes or required  to meet current year appropriations. These balances also provide financial stability to the City’s operation during uncertain  times and provide a layer of security to bondholders.      Historically the City’s financial policy targeted general government balance at 8% of general government operating  expenditures.  In 2007, due to the additional operating surplus, the City increased the Fund Balance to 10% of the  expenditure budget.  Due to the economy downturn and anticipated revenue shortfall in 2009, the City is expecting to tap  into the General Governmental Fund Balance by $2 million.  This would revert the Fund Balance target to the historical 8%  level.       At the end of January, the City has $9.7 million reported in combined general governmental fund balance of current year  operating budget, which is approximately 10% of budgeted operating expenditures.  The $9.7 million includes the Red‐Light  Photo revenue surplus of $115k.  This is a decrease of $2.8 million from the beginning balance of January 1, 2010.  January’s  ending fund balance is above the anticipated General Governmental Fund Balance of $6.1 million by $3.6 million.  This is  consistent with prior year trends since the City will not received the first portion of property tax revenues for 2010 until  April and May.    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 37 Monthly Financial Report January 2010        City of Renton All Funds ‐ Revenue, Expenditures and Fund Balances Cash  Basis through January 31, 2010 Funds Balance  01/01/2010 Budgeted  Revenue Revenue  01/31/10 Total Funds  Available Budgeted  Expenditure Expenditure  01/31/10 Ending Balance GENERAL GOVERNMENT FUNDS:11,955,285       97,838,698     4,881,557       16,836,842         97,838,698         7,161,527           9,675,315         000 General 8,535,013         75,735,434     3,689,136       12,224,149         71,418,283         5,746,764           6,477,385         001 Community Services 958,009            8,011,778       724,258          1,682,267           10,354,293         570,605              1,111,662         003 Street 1,391,648         6,688,942       400,608          1,792,256           8,476,980           641,040              1,151,216         004 Community Dev Block Grant (6,528)               294,148          (21)                 (6,549)                 296,503              13,958                (20,507)             005 Museum 64,705              192,621          56                   64,761                194,120              15,310                49,451              006 Library 706,011            1,395,801       6,904              712,915              2,544,263           173,794              539,121            009 Farmers  Market 60,571              44,280            213                 60,784                34,311                56                       60,728              010 Fire Memorial 936                   ‐                     ‐                     936                     ‐                          ‐                          936                   011 Fire Health & Wellness 4,303                25,000            662                 4,965                  25,000                ‐                          4,965                031 Park Memorial 175,066            ‐                     189                 175,255              ‐                          ‐                          175,255            201 Ltd  GO Bonds  Gen Govt Debt 1,448                2,982,658       25,281            26,729                1,984,625           ‐                          26,729              215 Gen Govt Misc Debt Service 64,103              2,468,036       34,271            98,374                2,510,320           ‐                          98,374              SPECIAL REVENUE FUNDS: 102 Arterial  Street 200,686            620,000          97,949            298,635              620,000              ‐                          298,635            108 Leased  City Properties 837,613            941,533          20,645            858,258              581,940              22,905                835,353            110 Hotel  Motel 247,828            245,000          11,444            259,272              245,000              21,785                237,487            118 Reserve  for Paths  & Trails 3,264                ‐                     7                     3,271                  ‐                          ‐                          3,271                125 1% For Art 143,796            15,000            160                 143,956              50,000                86                       143,870            127 Cable  Communication 89,391              85,000            1,598              90,989                85,674                2,100                  88,889              135 Springbrook Wetlands  Bank 459,528            ‐                     503                 460,031              ‐                          ‐                          460,031            DEBT SERVICE FUNDS: 219 1989 Unlimited GO Bonds 79,340              ‐                     ‐                     79,340                1,388                  ‐                          79,340              CAPITAL PROJECT FUNDS (CIP): 303 Community Dev Mitigation 1,066,593         60,000            5,066              1,071,659           ‐                          ‐                          1,071,659         304 Fire Mitigation 2,363,522         100,000          6,720              2,370,242           560,000              ‐                          2,370,242         305 Transportation  Mitigation 2,167,133         200,000          14,991            2,182,124           700,000              ‐                          2,182,124         316 Municipal Facilities  CIP 6,933,186         730,000          19,873            6,953,059           1,653,454           8,029                  6,945,030         317 Transportation  CI P 2,892,341         15,692,002     844,617          3,736,958           16,126,973         634,028              3,102,930         318 So Lake  WA Infrastructure Proj 114,039            ‐                     126                 114,165              ‐                          ‐                          114,165            326 Housing Opportunity 201,653            ‐                     223                 201,876              ‐                          ‐                          201,876            ENTERPRISE FUNDS: 402 Airport 415,929            1,917,163       94,268            510,197              1,001,800           72,717                437,480            403 Solid Waste  Utility 326,034            15,000,000     1,212,391       1,538,425           15,000,000         546,642              991,783            404 Golf Course 798,278            2,483,545       68,826            867,104              2,566,837           97,947                769,157            422 Airport Capital 633,154            1,578,000       5,650              638,804              1,578,000           22,688                616,116            424 Golf Course  Capital 287,523            150,000          314                 287,837              150,000              ‐                          287,837            INTERNAL SERVICE FUNDS: 501 Equipment Repair/Replacement 4,593,399         3,631,241       283,788          4,877,187           2,791,684           407,945              4,469,242         502 Insurance 6,039,509         3,287,584       241,842          6,281,351           4,170,106           825,172              5,456,179         503 Information Services 1,647,931         4,105,387       311,741          1,959,672           3,715,819           269,541              1,690,131         504 Facilities 91,175              4,555,485       203,765          294,940              4,176,210           349,976              (55,036)             505 Communications 111,818            1,049,671       73,234            185,052              877,560              68,464                116,588            512 Insurance, Healthcare 4,792,452         12,358,471     1,023,496       5,815,948           12,462,810         899,768              4,916,180         522 Insurance, Leoff1 Retirees  HC 2,820,473         2,235,684       155,787          2,976,260           2,248,907           99,756                2,876,504         FIDUCIARY FUNDS: 611 Firemen's Pension 4,332,817         300,000          1,564              4,334,381           550,475              36,110                4,298,271         Funds Balance  01/01/2010 Budgeted  Revenue Revenue  01/31/10 Total Funds  Available Budgeted  Expenditure Expenditure  01/31/10 Ending Balance ENTERPRISE FUNDS: COMBINED  UTILITIES 13,931,093       44,980,091     2,754,130       16,685,223         42,554,258         2,229,041           14,456,182       405 Water Utility 4,294,833         13,944,271     742,389          5,037,222           11,319,531         557,073              4,480,149         406 Waste Water Utility 1,887,815         6,070,737       462,058          2,349,873           6,389,869           281,385              2,068,488         407 Surface Water Utility 2,448,845         5,768,148       501,023          2,949,868           5,647,923           300,801              2,649,067         416 King County Me tro 46,504              11,211,935     983,999          1,030,503           11,211,935         926,948              103,555            425 Water Utility Construction 2,862,275         2,960,000       28,848            2,891,123           2,960,000           41,907                2,849,216         426 Waste Water Construction 841,219            2,775,000       6,758              847,977              2,775,000           19,995                827,982            427 Surface Water Construction 1,533,997         2,250,000       29,041            1,563,038           2,250,000           100,932              1,462,106         461 Waterworks  Bond Reserve ‐                        ‐                     ‐                     ‐                          ‐                          ‐                          ‐                        471 Waterworks  Rate Stabilization 15,605              ‐                     14                   15,619                ‐                          ‐                          15,619              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 37 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 March April May June July August September October 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 37 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 5,004,449        4,881,556         ‐2.46% Feb 10,889,447       Mar 16,056,309       Apr 27,392,879       May 40,802,650       Jun 46,001,799       Jul 52,423,931       Aug 59,142,514       Sep 64,734,974       Oct 75,764,331       Nov 88,960,814       Dec 97,838,698       Percent of budget 4.99% 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 29,796              218,705           634.01% Feb 373,239            Mar 1,056,988         Apr 8,434,266         May 16,175,687       Jun 16,296,755       Jul 16,431,623       Aug 16,516,621       Sep 16,667,485       Oct 23,706,024       Nov 31,115,921       Dec 31,364,643       Percent of budget 0.70% $‐ $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 37 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Sales Tax Budget YTD Actual Annual %  over (under) Jan 1,700,680        1,442,659         ‐15.17% Feb 3,852,496         Mar 5,442,634         Apr 7,028,600         May 8,624,161         Jun 10,204,496       Jul 11,872,013       Aug 13,636,932       Sep 15,313,835       Oct 17,071,037       Nov 18,638,649       Dec 20,857,000       Percent of budget 6.92% 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,254,767        1,282,930        2.24% Feb 2,587,931         Mar 3,839,141         Apr 4,977,239         May 6,169,119         Jun 7,265,386         Jul 8,404,053         Aug 9,604,469         Sep 10,627,747       Oct 11,729,279       Nov 12,872,783       Dec 14,228,000       Percent of budget 9.02% 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 37 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Licenses/ Permits Budget YTD Actual Annual %  over (under) Jan 254,388           394,387           55.03% Feb 504,909            Mar 746,077            Apr 1,023,875         May 1,215,548         Jun 1,404,525         Jul 1,606,007         Aug 1,628,749         Sep 1,798,373         Oct 2,065,432         Nov 2,222,766         Dec 2,386,376         Percent of budget 16.53% 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 419,176           371,847           ‐11.29% Feb 821,674            Mar 1,183,319         Apr 1,599,585         May 3,428,289         Jun 4,216,608         Jul 4,619,666         Aug 5,371,049         Sep 6,707,488         Oct 7,273,291         Nov 9,074,685         Dec 11,192,951       Percent of budget 3.32% 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 37 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Charges for  Svcs Budget YTD Actual Annual %  over (under) Jan 391,454           445,172           13.72% Feb 793,284            Mar 1,292,872         Apr 1,805,775         May 2,316,759         Jun 2,849,273         Jul 3,617,668         Aug 4,169,074         Sep 4,591,056         Oct 5,060,357         Nov 5,508,367         Dec 5,997,460         Percent of budget 7.42% 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 221,571           239,080           7.90% Feb 458,703            Mar 736,938            Apr 1,031,162         May 1,231,914         Jun 1,483,963         Jul 1,744,347         Aug 1,984,197         Sep 2,305,716         Oct 2,673,666         Nov 3,087,976         Dec 3,577,193         Percent of budget 6.68% $‐ $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 37 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Other Taxes Budget YTD Actual Annual %  over (under) Jan 486,577           315,778            ‐35.10% Feb 942,612            Mar 1,145,379         Apr 1,569,803         May 2,165,949         Jun 2,678,910         Jul 3,221,531         Aug 4,574,021         Sep 4,778,991         Oct 5,430,741         Nov 5,976,195         Dec 6,297,095         Percent of budget 5.01% 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 161,100           170,998           6.14% Feb 299,270            Mar 361,995            Apr 455,229            May 622,213            Jun 717,363            Jul 1,194,846         Aug 1,268,224         Sep 1,095,081         Oct 1,161,913         Nov 1,252,887         Dec 1,377,980         Percent of budget 12.41% $‐ $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 37 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year General Fund Budget YTD Actual Annual %  over (under) Jan 7,408,309        3,689,136         ‐50.20% Feb 12,420,254       Mar 16,796,704       Apr 25,742,707       May 36,654,550       Jun 41,122,011       Jul 41,748,010       Aug 46,494,044       Sep 52,813,385       Oct 63,769,546       Nov 73,021,029       Dec 79,140,146       Percent of budget 4.66% Community  Svcs Fund Budget YTD Actual Annual %  over (under) $‐ $10  $20  $30  $40  $50  $60  $70  $80  Millions General Fund Budget Actual Last Year $13.50  $15.00  Millions Community Svcs Fund Budget g () Jan 1,315,324        724,258           ‐44.94% Feb 1,770,321         Mar 2,187,886         Apr 3,296,864         May 4,438,712         Jun 4,802,461         Jul 6,881,575         Aug 7,561,893         Sep 7,618,923         Oct 7,959,964         Nov 9,637,170         Dec 10,369,127       Percent of budget 6.98% $‐ $10  $20  $30  $40  $50  $60  $70  $80  Millions General Fund Budget Actual Last Year $‐ $1.50  $3.00  $4.50  $6.00  $7.50  $9.00  $10.50  $12.00  $13.50  $15.00  Millions Community Svcs Fund Budget Actual Last Year Page 21 of 37 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Street Fund Budget YTD Actual Annual %  over (under) Jan 1,221,279        400,608            ‐67.20% Feb 1,627,919         Mar 2,015,572         Apr 2,824,276         May 3,658,411         Jun 4,055,812         Jul 5,478,334         Aug 5,937,532         Sep 5,900,487         Oct 6,218,544         Nov 7,417,274         Dec 8,476,981         Percent of budget 4.73% Library Fund Budget YTD Actual Annual %  over (under) $‐ $1  $2  $3  $4  $5  $6  $7  $8  $9  $10  $11  Millions Street Fund Budget Actual Last Year $3.00  $3.30  Millions Library Fund Budget At l y g () Jan 212,022           6,904                ‐96.74% Feb 424,044            Mar 636,066            Apr 848,088            May 1,060,110         Jun 1,272,132         Jul 1,484,153         Aug 1,696,175         Sep 1,908,197         Oct 2,120,219         Nov 2,332,241         Dec 2,544,263         Percent of budget 0.27% $‐ $1  $2  $3  $4  $5  $6  $7  $8  $9  $10  $11  Millions Street Fund Budget Actual Last Year $‐ $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10  $2.40  $2.70  $3.00  $3.30  Millions Library Fund Budget Actual Last Year Page 22 of 37 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Museum Fund Budget YTD Actual Annual %  over (under) Jan 16,177              56                      ‐99.66% Feb 32,353               Mar 48,530               Apr 64,707               May 80,883               Jun 97,060               Jul 113,237            Aug 129,413            Sep 145,590            Oct 161,767            Nov 177,943            Dec 194,120            Percent of budget 0.03% Note: Prior to 2009, Museum was part of the Library Fund LTGO Debt  Funds Budget YTD Actual Annual %  over (under) $4.50  $5.00  Millions LTGO Debt Funds Budget $‐ $0.05  $0.10  $0.15  $0.20  $0.25  Millions Museum Fund Budget Actual Last Year g () Jan 454,787           59,552              ‐86.91% Feb 565,442            Mar 733,780            Apr 1,226,531         May 1,679,551         Jun 1,865,252         Jul 2,384,196         Aug 3,241,482         Sep 3,488,103         Oct 3,681,505         Nov 4,252,882         Dec 4,904,945         Percent of budget 1.21% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00  Millions LTGO Debt Funds Budget Actual Last Year $‐ $0.05  $0.10  $0.15  $0.20  $0.25  Millions Museum Fund Budget Actual Last Year Page 23 of 37 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year REET Budget YTD Actual Annual %  over (under) Jan 203,808           71,303               ‐65.01% Feb 314,352            Mar 488,064            Apr 801,624            May 1,038,768         Jun 1,239,744         Jul 1,444,776         Aug 1,711,272         Sep 1,889,064         Oct 2,072,376         Nov 2,321,904         Dec 2,400,000         Percent of budget 2.97% 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 Page 24 of 37 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 7,055,149        7,161,528        1.51% Feb 15,023,132       Mar 22,448,111       Apr 30,034,524       May 37,370,469       Jun 45,896,133       Jul 54,113,605       Aug 61,992,556       Sep 69,771,711       Oct 77,459,876       Nov 85,382,853       Dec 97,838,698       Percent of budget expended 7.32% 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               Mar 68,592               Apr 91,263               May 113,769            Jun 136,495            Jul 158,472            Aug 180,456            Sep 202,484            Oct 224,540            Nov 246,799            Dec 267,957            Percent of budget expended 7.85% $‐ $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 25 of 37 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Court Services Budget YTD Actual Annual %  over (under) Jan 152,504           168,470           10.47% Feb 317,136            Mar 482,634            Apr 655,111            May 827,668            Jun 1,002,217         Jul 1,170,590         Aug 1,338,240         Sep 1,505,085         Oct 1,673,117         Nov 1,832,379         Dec 2,011,393         Percent of budget expended 8.38% 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            Mar 385,511            Apr 521,891            May 654,166            Jun 785,689            Jul 935,460            Aug 1,087,274         Sep 1,225,811         Oct 1,370,153         Nov 1,499,437         Dec 1,635,047         Percent of budget expended 8.24% $‐ $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 26 of 37 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Finance Budget YTD Actual Annual %  over (under) Jan 226,033           145,053            ‐35.83% Feb 392,881            Mar 586,008            Apr 748,871            May 948,999            Jun 1,109,352         Jul 1,284,766         Aug 1,452,433         Sep 1,602,468         Oct 1,683,322         Nov 1,821,484         Dec 1,964,890         Percent of budget expended 7.38% 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            Mar 403,070            Apr 549,408            May 691,207            Jun 825,807            Jul 1,028,793         Aug 1,108,058         Sep 1,244,944         Oct 1,384,635         Nov 1,520,418         Dec 1,621,295         Percent of budget expended 7.84% $‐ $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 27 of 37 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Human  Resources Budget YTD Actual Annual %  over (under) Jan 62,623              71,457              14.11% Feb 147,649            Mar 228,975            Apr 310,346            May 392,750            Jun 470,604            Jul 544,958            Aug 617,312            Sep 693,968            Oct 769,666            Nov 841,727            Dec 913,669            Percent of budget expended 7.82% 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 37,309              42,532              14.00% Feb 82,363               Mar 127,262            Apr 168,588            May 213,731            Jun 254,321            Jul 297,416            Aug 337,420            Sep 378,618            Oct 419,892            Nov 464,578            Dec 518,399            Percent of budget expended 8.20% 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 28 of 37 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            Mar 1,210,803         Apr 1,824,496         May 1,977,632         Jun 2,363,946         Jul 2,580,253         Aug 2,956,550         Sep 3,332,176         Oct 3,741,593         Nov 4,083,716         Dec 4,792,981         Percent of budget expended 7.28% 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,148,675        2,260,619        5.21% Feb 4,439,546         Mar 6,868,471         Apr 8,916,091         May 10,938,032       Jun 13,468,013       Jul 15,967,622       Aug 18,173,451       Sep 20,403,578       Oct 22,577,932       Nov 24,984,492       Dec 27,610,835       Percent of budget expended 8.19% $‐ $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 29 of 37 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Fire & Emerg  Svc Budget YTD Actual Annual %  over (under) Jan 1,667,207        1,768,398        6.07% Feb 4,039,495         Mar 5,743,330         Apr 7,478,778         May 9,233,411         Jun 10,950,327       Jul 12,762,955       Aug 14,470,932       Sep 16,303,835       Oct 18,165,082       Nov 19,927,128       Dec 21,802,109       Percent of budget expended 8.11% 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,000,000  City Clerk Budget y g () Jan 59,659              48,025              ‐19.50% Feb 133,656            Mar 201,304            Apr 369,538            May 438,200            Jun 506,146            Jul 574,920            Aug 637,419            Sep 700,467            Oct 772,528            Nov 841,106            Dec 931,014            Percent of budget expended 5.16% $‐ $3  $6  $9  $12  $15  $18  $21  $24  Millions Fire & Emergency Services Budget Actual Last Year $‐ $200,000  $400,000  $600,000  $800,000  $1,000,000  City Clerk Budget Actual Last Year Page 30 of 37 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Human  Services Budget YTD Actual Annual %  over (under) Jan 27,446              40,228              46.57% Feb 73,908               Mar 114,486            Apr 248,987            May 317,854            Jun 359,840            Jul 454,615            Aug 521,901            Sep 564,704            Oct 635,570            Nov 713,893            Dec 869,096            Percent of budget expended 4.63% 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 15,540              14,619              ‐5.93% Feb 32,770               Mar 49,078               Apr 65,520               May 82,389               Jun 99,103               Jul 115,586            Aug 132,410            Sep 149,273            Oct 166,203            Nov 183,623            Dec 200,440            Percent of budget expended 7.29% $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 31 of 37 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year CED Budget YTD Actual Annual %  over (under) Jan 506,665           555,670           9.67% Feb 1,035,433         Mar 1,557,734         Apr 2,077,334         May 2,585,381         Jun 3,116,095         Jul 3,643,231         Aug 4,174,950         Sep 4,677,471         Oct 5,185,894         Nov 5,731,302         Dec 6,279,159         Percent of budget expended 8.85% Note:  For comparative purposes history includes Development Svcs division (previously in Public Works). 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,662,041        5,746,764        1.50% Feb 11,966,133       Mar 17,701,021       Apr 23,540,894       May 29,107,950       Jun 34,864,263       Jul 40,891,252       Aug 46,445,452       Sep 52,410,307       Oct 58,082,347       Nov 64,197,180       Dec 71,418,283       Percent of budget expended 8.05% $‐ $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 32 of 37 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Community  Svcs Fund Budget YTD Actual Annual %  over (under) Jan 621,982           570,605            ‐8.26% Feb 1,400,832         Mar 2,156,281         Apr 2,938,134         May 3,741,731         Jun 4,572,145         Jul 5,702,834         Aug 6,858,683         Sep 7,709,910         Oct 8,544,362         Nov 9,406,564         Dec 10,354,293       Percent of budget expended 5.51% 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 596,271           641,040           7.51% Feb 1,266,461         Mar 1,943,687         Apr 2,643,546         May 3,357,223         Jun 4,032,499         Jul 4,764,656         Aug 5,522,667         Sep 6,242,278         Oct 6,950,276         Nov 7,651,237         Dec 8,476,980         Percent of budget expended 7.56% $‐ $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 33 of 37 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year CDBG Budget YTD Actual Annual %  over (under) Jan 18,324              13,958               ‐23.83% Feb 38,050               Mar 56,015               Apr 74,268               May 91,504               Jun 109,680            Jul 128,087            Aug 173,546            Sep 191,770            Oct 213,331            Nov 253,994            Dec 296,503            Percent of budget expended 4.71% Library Fund Budget YTD Actual Annual %  over (under)$3.00  Millions Library Fund Budget At l $‐ $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  CDBG Budget Actual Last Year y g () Jan 152,452           173,794           14.00% Feb 368,766            Mar 558,262            Apr 766,561            May 978,524            Jun 1,208,703         Jul 1,439,442         Aug 1,702,112         Sep 1,902,855         Oct 2,108,177         Nov 2,304,874         Dec 2,544,263         Percent of budget expended 6.83% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  Millions Library Fund Budget Actual Last Year $‐ $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  CDBG Budget Actual Last Year Page 34 of 37 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               Mar 49,002               Apr 65,543               May 82,433               Jun 99,543               Jul 115,981            Aug 132,242            Sep 148,372            Oct 164,641            Nov 180,555            Dec 194,120            Percent of budget expended 7.89% Note: Prior to 2009, Museum was part of the Library Fund LTGO Funds Budget YTD Actual Annual %  over (under) $4.50  $5.00  Millions LTGO Funds Budget $‐ $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 g () Jan 135                   ‐                         0.00% Feb 15,957               Mar 15,957               Apr 15,957               May 15,957               Jun 831,340            Jul 831,430            Aug 831,430            Sep 2,010,544         Oct 2,215,693         Nov 2,295,344         Dec 4,494,945         Percent of budget expended 0.00% $‐ $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00  Millions LTGO Funds 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  Museum Fund Budget Actual Last Year Page 35 of 37 City of Renton Monthly Enterprise Fund Financial Report ‐ 2010 Budget Year Utilities Budget Revenue Expense Jan 2,687,645        3,901,859      2,612,849       Feb 6,051,911         Mar 9,252,598         Apr 11,560,047       May 15,688,175       Jun 20,586,113       Jul 25,143,511       Aug 29,568,558       Sep 32,849,052       Oct 36,131,528       Nov 39,790,235       Dec 49,569,258       Percent of budget expended 5.27% 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 $55 Millions Utilities Budget Revenue Expense $1.20  Millions Airport Budget p g p Jan 66,269              94,268            72,717             Feb 159,667            Mar 250,901            Apr 329,772            May 438,337            Jun 517,870            Jul 598,355            Aug 688,817            Sep 759,575            Oct 838,546            Nov 913,982            Dec 1,001,800         Percent of budget expended 7.26% Note:  Operations only. $0 $5 $10 $15 $20 $25 $30 $35 $40 $45 $50 $55 Millions Utilities Budget Revenue Expense $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  Millions Airport Budget Revenue Expense Page 36 of 37 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            Mar 479,768            Apr 618,377            May 813,533            Jun 1,066,444         Jul 1,232,903         Aug 1,384,039         Sep 1,549,779         Oct 1,857,389         Nov 1,994,766         Dec 2,566,837         Percent of budget expended 3.82% 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 37 of 37