Loading...
HomeMy WebLinkAbout201003, March.pdf    General  Governmental  Funds $% Beginning Fund Balance 13,300,854$       13,300,854$       11,816,561$       11,816,561$       11,955,285$       11,955,285$       11,955,285$        ‐$                   0.0% OPERATING REVENUES Property Tax 29,050,790          1,145,756             30,660,522          960,777                  31,364,643          982,841                  1,037,146             54,304             5.5% Sales  Tax 20,825,055          5,339,614             17,995,836          4,782,509             18,609,000          4,618,796             4,307,540             (311,255)          ‐6.7% Sales  Tax ‐ Annexation  Credit ‐                               ‐                              2,132,110             564,676                  2,248,000             595,369                  511,021                  (84,347)             ‐14.2% Criminal Justice Sa les  Tax 1,755,469             383,405                  1,650,350             436,358                  1,743,000             460,855                  413,523                  (47,332)             ‐10.3% Natural  Gas  Use  Tax 253,377                  73,239                     242,891                  56,975                     ‐                              ‐                              73,944                     73,944             0.0% Admission  Tax 197,740                  46,705                     260,269                  57,167                     260,000                  57,108                     75,236                     18,129             31.7% Franchise Fees 998,288                  240,795                  1,039,031             259,992                  1,040,000             260,234                  320,478                  60,244             23.1% Electricity Tax 4,580,037             1,199,377             4,963,151             1,479,929             5,150,000             1,535,645             1,381,772             (153,873)         ‐10.0% Gas  Tax 1,565,810             573,830                  1,891,255             845,949                  1,858,000             831,074                  599,950                  (231,125)         ‐27.8% Transfer  Station 380,961                  67,151                     283,985                  52,193                     230,000                  42,272                     62,164                     19,892             47.1% TV Cable 1,073,168             241,635                  1,263,743             310,738                  1,250,000             307,359                  327,983                  20,624             6.7% Phone/Telegraph/Cellular Phone 2,780,196             651,793                  3,065,347             723,095                  2,860,000             674,655                  822,891                  148,237          22.0% City Utilities 2,606,786             549,558                  2,871,599             681,906                  2,880,000             683,901                  664,892                  (19,009)            ‐2.8% Leasehold Excise  Tax 190,644                  9,416                        146,002                  27,996                     100,000                  19,175                     35,999                     16,824             87.7% Gambling Excise  Tax 2,157,029             498,286                  2,141,720             569,842                  2,000,000             532,135                  336,398                  (195,737)         ‐36.8% Real Estate Excise  Tax 2,800,103             577,456                  2,418,456             483,801                  2,400,000             480,120                  487,709                  7,589                1.6% Less: Municipal  Facilities CIP REET (450,103)                (288,728)                (1,000,000)            (211,038)                (400,000)                (84,415)                   (81,027)                   3,388                 ‐4.0% EMS Levy 890,998                  85,744                     1,170,657             ‐                              897,095                  ‐                              ‐                              ‐                       ‐100.0% Penalties & Interest on Delinquent Tax 8,125                        1,665                        1,353                        73                                ‐                               ‐                              329                            329                     0.0% Business  License Fees 485,537                  128,257                  424,413                  118,353                  463,067                  129,132                  117,082                  (12,050)             ‐9.3% Other Licenses and Permits 257,477                  54,265                     176,851                  39,415                     157,250                  35,046                     62,268                     27,222             77.7% Building Permits 2,034,225             787,036                  1,683,082             455,149                  1,766,059             477,588                  453,658                  (23,930)             ‐5.0% Intergovernmental (Grants, etc) 3,734,887             715,162                  3,820,932             766,431                  3,895,228             1,103,708             1,103,708              ‐                      0.0% Fire District 25 and 40 Contracts 5,013,549             ‐                              5,869,198             8,109                        5,554,723             19,525                     19,525                     ‐                      0.0% Records, Duplicating, and Passport Fees 176,950                  56,151                     187,721                  43,455                     217,585                  50,368                     37,608                     (12,760)             ‐25.3% Public Safety 524,565                  122,076                  521,484                  134,041                  430,000                  110,526                  100,750                  (9,775)                ‐8.8% Development Service Fees 903,768                  289,852                  677,955                  168,159                  696,708                  172,810                  205,641                  32,831             19.0% Culture and Recreation 1,678,818             229,562                  1,631,486             219,431                  1,572,240             211,463                  226,688                  15,226             7.2% Interfund/Interdept‐Services 3,072,950             670,152                  3,225,745             783,565                  3,080,927             748,387                  766,090                  17,703             2.4% Fines  and Forfeits 2,110,973             284,995                  1,448,878             319,771                  1,327,193             292,915                  251,628                  (41,287)             ‐14.1% Photo Enforcement ‐                              ‐                              2,368,131             616,448                  2,250,000             585,698                  495,096                  (90,602)             ‐15.5% Interests and Other  Earnings 735,910                  133,095                  535,314                  111,818                  434,300                  90,718                     73,008                     (17,710)             ‐19.5% Rents, Leases, and Concessions 676,919                  215,574                  677,960                  232,834                  720,780                  247,539                  241,192                  (6,347)                ‐2.6% Contributions and Donations 175,513                  65,759                     150,406                  29,115                     111,900                  21,661                     29,179                     7,518                34.7% Other Miscellaneous 91,070                     49,827                     166,012                  22,081                     111,000                  14,764                     28,864                     14,100             95.5% Agency Type  Deposits (31,840)                   146                            1,202                        175                            ‐                              ‐                              138                            138                     0.0% Transfer ‐In 381,364                  ‐                              577,004                  ‐                              560,000                  ‐                              ‐                              ‐                       ‐100.0% Total  Operating Revenues 93,687,106          15,198,607          97,342,052          16,151,285          97,838,698          16,308,970          15,590,071          (718,899)          ‐4.4% OPERATING EXPENDITURES Legislative 245,441                  64,482                     247,225                  61,632                     267,957                  68,593                     65,280                     3,312                4.8% City Attorney 1,661,225             427,323                  1,248,380             296,034                  1,621,295             403,070                  400,465                  2,605                0.6% City Clerk 604,844                  200,879                  646,581                  145,727                  931,014                  257,862                  146,137                  111,725          43.3% Court Services 1,744,122             392,418                  1,819,731             462,719                  2,011,393             482,628                  499,117                  (16,489)             ‐3.4% Executive 966,373                  232,642                  1,499,747             348,810                  1,635,047             385,505                  407,609                  (22,105)            ‐5.7% Hearing Examiner 166,820                  41,086                     171,911                  43,524                     200,440                  50,067                     43,412                     6,655                13.3% Community and Eco  Dvlpmnt Admin ‐                              ‐                              265,269                  69,432                     550,312                  144,039                  146,045                  (2,006)                ‐1.4% Development Services 4,178,096             977,219                  3,615,129             943,965                  3,247,282             800,519                  836,089                  (35,570)            ‐4.4% Economic  Development 1,875,749             485,912                  1,244,175             318,971                  1,277,641             329,608                  305,673                  23,935             7.3% Planning ‐                              ‐                              1,525,460             330,141                  1,238,235             267,980                  316,376                  (48,396)             ‐18.1% Finance 1,909,652             522,306                  1,969,936             587,513                  1,964,890             562,088                  443,082                  119,006          21.2% Human Resources 981,306                  256,662                  853,063                  203,059                  913,669                  228,979                  213,772                  15,207             6.6% Police 23,894,898          5,611,423             25,833,756          6,439,296             27,610,835          6,690,919             6,677,267             13,652             0.2% Fire 21,763,640          5,110,276             20,375,286          5,931,457             21,802,109          6,014,430             5,943,458             70,972             1.2% Facilities 3,614,850             880,519                  ‐                              ‐                              ‐                              ‐                              ‐                              ‐                      100.0% Parks 4,892,441             778,903                  4,820,336             823,645                  5,061,804             835,166                  854,902                  (19,736)            ‐2.4% Recreation 4,383,163             966,085                  7,878,458             1,911,669             4,936,795             1,158,646             1,107,561             51,085             4.4% Human Services 1,162,553             158,512                  1,194,142             159,707                  1,165,599             157,388                  207,504                  (50,116)             ‐31.8% Community Resources  & Events 367,627                  59,680                     348,185                  62,782                     355,694                  60,853                     64,287                     (3,434)                ‐5.6% Library 1,890,886             469,954                  2,312,128             479,590                  2,544,263             574,799                  500,663                  74,136             12.9% Museum 136,327                  34,097                     140,801                  35,858                     194,120                  49,001                     46,726                     2,275                4.6% Public Works  Administration 886,867                  227,586                  463,533                  119,838                  518,399                  133,371                  129,351                  4,020                3.0% Street  Maintenance 3,212,111             691,057                  3,794,716             924,161                  3,366,524             776,053                  816,882                  (40,829)            ‐5.3% Technical Services 515,708                  145,166                  478,493                  112,967                  ‐                              ‐                              ‐                              ‐                      100.0% Transportation 4,841,955             1,035,809             5,110,639             1,237,670             5,110,456             1,167,385             1,261,456             (94,070)            ‐8.1% Debt Service 4,263,739             41,740                     4,176,822             ‐                              4,494,945             126,390                  126,390                  ‐                      0.0% Non‐Departmental 4,622,865             1,206,502             4,370,376             1,065,371             4,792,981             1,210,803             1,136,033             74,770             6.2% Other 388,142                  2,230                        799,051                  3,202                        25,000                     114                             ‐                              114                     100.0% Total  Operating Expenditures 95,171,399          21,020,467          97,203,328          23,118,739          97,838,698          22,936,258          22,695,538          240,720          1.0% Total  Ending Fund Balance 11,816,561$       7,478,995$          11,955,285$       4,849,107$          11,955,285$       5,327,997$          4,849,818$          (478,179)          ‐9.0% Favorable (Unfavorable) 2008 2009 2010 Variance Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual Monthly Financial Report March 2010 Page 1 of 33 Monthly Financial Report March 2010          OVERVIEW  This financial overview reflects the City’s overall financial position for the fiscal year through March 31, 2010.  Except as  noted, year‐to‐date budgeted revenues and operating expenditures are generally based on the collection/disbursement  patterns for the same period of the preceding year.  The table on the previous page summarizes the general governmental  fund revenues and expenditures.    Revenues    Taxes   The combined collection of property tax, sales/use tax, utility tax, gambling, admissions, and real estate excise tax  represents 70% of all resources supporting general governmental activities.   The following section provides detail  information on property, sales, utility, and other taxes.    Property Tax  March’s collection is $548k, making  the total year‐to‐date collection of  $1 million or 3% of the total budget.   In comparison to the previous year,  the City collected $76k or 8%  higher.  Compared to the budget,  the City is above projections by  $54k or 6%.  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  and February.        Sales Tax  March 2010 sales tax receipts  totaled $1.3 million.  Compared to  the same month last year, it is  $171k or 12% less.  Compared to  the projected current month’s  budget, it is under projections by  $35k or 3%.  The year‐to‐date  collection is $4.3 million or 23% of  the sales tax budget.  This is $475k  less than the last year and $311k  below budget.  Based on the year‐ to‐date collection, the City is  projecting sales tax revenues to be  $17.2 million by the end of 2010,  which is $1.4 million under budget.      2009 2010 2010 Actual Budget Actual $ % $ % Jan 1,458,072$     1,459,527$     1,289,364$  (168,709)$   ‐12% (170,163)$   ‐12% Feb 1,863,430        1,834,595        1,728,588     (134,842)      ‐7% (106,007)      ‐6% Mar 1,461,007        1,324,674        1,289,589     (171,418)      ‐12% (35,085)         ‐3% Apr 1,398,021        1,367,908        ‐                      May 1,490,778        1,603,693        ‐                      Jun 1,361,808        1,464,336        ‐                      Jul 1,443,891        1,547,213        ‐                      Aug 1,551,415        1,662,544        ‐                      Sep 1,454,550        1,573,534        ‐                      Oct 1,560,217        1,610,574        ‐                      Nov 1,440,143        1,636,255        ‐                      Dec 1,512,506        1,524,146        ‐                      YTD Total 4,782,509$     4,618,796$     4,307,540$  (474,968)$   ‐10% (311,255)$  ‐7% Annual Total 17,995,836$  18,609,000$   2010 vs. Budget2010 vs. 2009 Month Year  to Date through March Local Retail  Sales  Tax Revenues 2009 2010 2010 Actual Budget Actual $ % $ % Jan 9,419$               9,635$               51,304$            41,885$     445% 41,669$     432% Feb 303,513            310,483            438,210            134,696     44% 127,727     41% Mar 647,845            662,723            547,632            (100,213)   ‐15% (115,091)    ‐17% Apr 8,063,214        8,248,386         May 6,711,943        6,866,083         Jun 113,279            115,881             Jul 104,757            107,163             Aug 66,589               68,118                Sep 250,296            256,044             Oct 5,770,027        5,902,536         Nov 8,275,695        8,465,747         Dec 343,945            351,844             YTD Total 960,777$         982,841$         1,037,146$     76,369$     8% 54,305$     6% Annual Total 30,660,522$  31,364,643$   Property Tax Revenues Year to Date through March 2010 vs. 2009 2010 vs. Budget Month Page 2 of 33 Monthly Financial Report March 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 1,194,024$     923,975$         666,951$         457,001$         (466,974)$       ‐51% $   (209,950)‐31% Auto Sales 916,333            723,719            772,088            719,899            (3,820)                ‐1%          (52,188)‐7% General Retail 1,589,708        1,589,641        1,597,958        1,594,135        4,494                 0%             (3,824) 0% Manufacturing 234,794            281,277            231,161            212,902            (68,374)             ‐24%          (18,259)‐8% Wholesale 292,725            234,708            255,498            243,265            8,557                 4%          (12,233)‐5% Service 1,004,130        932,882            947,442            952,299            19,417              2%               4,858 1% Other 107,895            96,301               147,698            128,038            31,737              33%          (19,660)‐13% Total 5,339,610$     4,782,504$     4,618,796$     4,307,540$     (474,963)         ‐10%(311,256)$    ‐7% Note: Excludes  Annexation  Credit and Criminal Justice Sales  Tax revenue.      Utility tax  March utility taxes revenue totals $1.3  million, which is $44k higher than the same  month last year and ahead of budget by  $75k.  The year‐to‐date collection of $3.9  million is below the budget by $116k or 3%  and is also $217k or 5% below 2009.  The  unfavorable comparisons in January and  February is primarily due to higher than  normal electrical and natural gas  consumptions during winter months in 2009  that distorted the budget for these two  months.  At this time, the City is projecting  utility tax revenues will meet our 2010  budget by the end of the year.          The table below breaks out Utility Tax by source, the lower amount generated from Natural Gas is due to warmer  temperatures in the 1st quarter of 2010 than 2009:    Utility Tax by Type 2008 2009 2010 Bgt YTD Act Chg 10/09 10Act  vs  Bgt Electrical 1,199,377        1,479,929        1,465,957        1,381,772         ‐7%‐6% Natural Gas 647,069            902,924            528,883            673,894             ‐25% 27% Cell 393,898            467,855            540,839            553,363            18% 2% Phone 257,895            255,239            273,266            269,528            6%‐1% Cable 241,635            310,738            355,815            327,983            6%‐8% Transfer  Station 67,151               52,193               65,470               62,164               19%‐5% City Utilities 549,558            681,906            819,797            664,892            ‐2%‐19% YTD  Total 3,356,584        4,150,785        4,050,027        3,933,596        ‐5%‐3% Annual Total 13,240,334     14,581,971     14,228,000      YTD as % of 25% 28% 28%      2009 2010 2010 Actual Budget Actual $ % $ % Jan 1,413,641$     1,379,325$     1,282,930$   (130,711)$   ‐9% (96,395)$      ‐7% Feb 1,485,870        1,449,801        1,354,933      (130,936)      ‐9% (94,868)         ‐7% Mar 1,251,275        1,220,901        1,295,732      44,457         4% 74,831         6% Apr 1,204,619        1,175,377         May 1,322,947        1,290,833         Jun 1,070,303        1,044,322         Jul 1,010,609        986,077             Aug 1,201,122        1,171,965         Sep 1,068,035        1,042,109         Oct 1,079,380        1,053,179         Nov 1,090,897        1,064,416         Dec 1,383,272        1,349,694         YTD  Total 4,150,785$     4,050,000$     3,933,596$   (217,190)$   ‐5% (116,431)$   ‐3% Annual Total 14,581,971$  14,228,000$   Utility Tax Revenues Month 2010 vs. Budget2010 vs. 2009 Year to Date through March Page 3 of 33 Monthly Financial Report March 2010        Other Taxes     Real Estate Excise Tax  The City collected $309k in Real Estate  Excise Tax revenues (REET) in March.  This  is $127k above current month’s budget  and $126k ahead the same month last  year.  Year‐to‐date collection of $488k is  $8k or 2% ahead the budget and is also  $4k or 1% above 2009.  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.     Gambling Tax  March Gambling Tax collections total  $63k.  Year‐to‐date total of $336k is  $233k or 41% below the year before; and  $195k or 37% below budget.      The lower tax collection is due to cross‐ the‐board reduction in gambling  activities.  Pull tabs overall reduced by  25%, partially due to the change in  business at Cascade Lane; and card‐ rooms are seeing over 30% lower in  activities.    Because these changes, the City is  anticipating around $400k less in  gambling tax revenue collection than budgeted by the end of the year.    Franchise Fees  Franchise Fees are due quarterly and the  year‐to‐date revenue collections are  $320k.  This is $65k or 25% above the  projected year‐to‐date budget and $60k  or 23% higher than 2009.        2009 2010 2010 Actual Budget Actual $ % $ % Jan 259,792$      255,537$      45,703$         (214,089)$      ‐82% (209,834)$   ‐82% Feb 200                    102                    274,776         274,576         137288% 274,674      269037% 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,992$      255,639$      320,478$      60,487$         23% 64,840$      25% Annual Total 1,039,031$  1,040,000$   Franchise Fees  Revenue Year to Date through March Month 2010 vs. 2009 2010 vs. Budget 2009 2010 2010 Actual Budget Actual $ % $ % Jan 231,334$      229,560$      71,303$         (160,031)$   ‐69% (158,257)$   ‐69% Feb 69,290            68,760            107,242         37,952         55% 38,482         56% Mar 183,177         181,800         309,164         125,987      69% 127,364      70% Apr 141,038         139,944          May 308,077         305,736          Jun 211,295         209,688          Jul 201,960         200,400          Aug 310,599         308,232          Sep 208,046         206,472          Oct 209,975         208,368          Nov 222,052         220,344          Dec 121,614         120,696          YTD  Total 483,801$      480,120$      487,709$      3,908$         1% 7,589$         2% Annual  Total 2,418,456$  2,400,000$   2010 vs . 2009 Month 2010 vs. Budget Real Estate Excise  Tax Revenues Year  to Date through March 2009 2010 2010 Actual Budget Actual $ % $ % Jan 7,691$            186,179$      135,608$      127,917$      1663% (50,571)$     ‐27% Feb 391,054         186,179         137,736         (253,317)        ‐65% (48,443)        ‐26% Mar 171,097         159,776         63,054            (108,044)        ‐63% (96,722)        ‐61% Apr 177,856         166,087         ‐                      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 569,842$      532,135$      336,398$      (233,444)$     ‐41% (195,737)$  ‐37% Annual Total 2,141,720$  2,000,000$   Gambling Tax Revenue Month Year  to Date through March 2010 vs. 2009 2010 vs. Budget Page 4 of 33 Monthly Financial Report March 2010        Admission Tax   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 83% of the revenue in this category.  As of the end of March,  we have collected 27% of the projected revenue  from licenses and permits.  The percentage of  year‐to‐date actual to year‐to‐date budget is  under by 1%.  Licenses and Permits totaled $633k  by the end of March.  The following sections  provide detail information for Building Permits  and Business Licenses revenues.    Building Permits and Fees revenues totaled $83k  in March.  The revenue swing between the high in  January and the low in February is primarily  attributable to the rush of getting permit  completed prior to the new school impact fees  took effect.  The year‐to‐date development fees  revenue of $415k is $26k less than the budget but  is $5k higher than 2009.        Business Licenses totaled $117k since the start of  the year, which is 1% under last year and 9%  below budget.  The month by month comparison  is not representative due to the payment timing  shift of employers.  The General Fund portion of  the Business Licenses revenue is under the budget  by $12k and $1k below last year.      2009 2010 2010 Actual Budget Actual $ % $ % Jan 106,633$      114,591$      285,826$   179,192$        168% 171,234$  149% Feb 124,555         133,851         46,586         (77,969)             ‐63% (87,265)       ‐65% Mar 179,330         192,714         82,637         (96,693)             ‐54% (110,076)    ‐57% Apr 114,694         123,254         ‐                   May 125,344         134,698         ‐                   Jun 131,705         141,534         ‐                   Jul 106,810         114,781         ‐                   Aug 119,439         128,352         ‐                   Sep 101,087         108,631         ‐                   Oct 131,899         141,742         ‐                   Nov 82,516            88,674            ‐                   Dec 169,581         182,237         ‐                   YTD Total 410,519$      441,156$      415,049$   4,530$              1% (26,107)$    ‐6% An nual  Total 1,493,593$  1,605,059$   Building Permits and Fees Year to Date through March 2010 vs. Budget2010 vs. 2009 Month 2009 2010 2010 Actual Budget Actual $ % $ % Jan 81,835$     89,289$     77,955$     (3,880)$   ‐5% (11,334)$   ‐13% Feb 30,180        32,929        33,440        3,260      11% 511              2% Mar 6,337           6,914           5,687           (650)          ‐10% (1,228)         ‐18% Apr 73,055        79,709         ‐                  May 14,185        15,477         ‐                  Jun 9,352           10,204        ‐                  Jul 80,579        87,918        ‐                  Aug 20,280        22,127        ‐                  Sep 1,746           1,905           ‐                  Oct 84,002        91,653        ‐                  Nov 18,937        20,662        ‐                  Dec 3,922           4,279           ‐                  YTD  Total 118,353$  129,132$  117,082$  (1,271)$   ‐1% (12,050)$   ‐9% Annual Total 424,413$  463,067$   Business Licenses Month Year to Date through March 2010 vs. Budget2010 vs. 2009 2009 2010 2010 Actual Budget Actual $ % $ % Jan 57,167$         58,965$         74,777$         17,610$         31% 15,811$      27% Feb ‐                      ‐                     459                    459                    100% 459                 100% Apr 61,163            63,415             ‐                      Jul 70,690            69,911            ‐                      Oct 70,729            67,414            ‐                      Nov 520                    295                    ‐                      YTD  Total 57,167$         58,965$         75,236$         18,069$         32% 16,271$      28% Annual Total 260,269$      260,000$       Year to Date through March Month 2010 vs. 2009 2010 vs. Budget Admission Tax Revenue Page 5 of 33 Monthly Financial Report March 2010        Intergovernmental  These revenue sources include federal  (direct and indirect) grants, state  grants, state shared revenues, local  grants, entitlements.  State shared  revenues and Fire Districts’ 25 and 40  contracts compose 63% of the total  revenues in this category.  The year‐to‐ date total Intergovernmental revenue  is $1.5 million or 14% of the budget.   All grant revenues also have  corresponding expenditures which will  be added to the City’s budget through budget adjustment.     State Shared Revenue collections  totaled $944k since the start of 2010.   Compared to the projected budget,  State Shared Revenues are over by  $45k or 5%.  Compared to the prior  year, the City is collecting $53k more or  up by 6%.  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 74% of the total revenue in this category.  The year‐to‐date total charges for services are $1.3 million or 22% of  the budget.  This is 3% 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 $204k since  the start of the year.  Compared to the budget,  the City is collecting $30k or 17% more than  anticipated revenue.   Compared to the prior year,  the City is collecting $35k or 21% more.      Intergovernmental 2008 2009 2010 Bgt YTD Act Chg 10/09 10Act  vs  Bgt Fire  District #25 ‐                         ‐                        ‐                        ‐                        N/A N/A Fire  District #40 ‐                        8,109                  19,525               19,525               141% 0% State  Shared Revenue 718,410            890,192            898,680            943,591            6% 5% Federal  Grants 325,141            178,213            291,186            291,186            63% 0% State  Grants ‐                        83,130               96,391               96,391               16% 0% Other Grants 55,015               51,254               69,161               69,161               35% 0% ARRA Grants ‐                         ‐                        116,903            116,903            100% 0% Total  Rev YTD 1,098,567        1,210,898        1,491,846        1,536,757        27% 3% Total  Rev Annual 10,503,905     11,340,480     11,192,951      YTD  % 10% 11% 13% 14% Note:  Includes CJ Sa les  Tax. 2009 2010 2010 Actual Budget Actual $ % $ % Crim Just Sales  Tax 436,358$      460,855$      413,523$   (22,835)$   ‐5% (47,332)$    ‐10% Judicial Contribution 12,143            4,888               17,229         5,086$      42% 12,341        252% Crim Just ‐ Pop 4,291                ‐                     4,619            328              8% 4,619           100% Crim Just ‐ Spec Prog 16,479            16,015            17,557         1,078         7% 1,542           10% State  DUI 3,668               1,993               3,942            274              7% 1,949           98% Liquor Profits 136,619         144,264         195,587      58,967      43% 51,322        36% Liquor Excise  Tax 97,810            100,081         103,016      5,205         5% 2,935           3% Fuel Tax 182,824         170,583         188,118      5,295         3% 17,535        10% YTD  Total 890,192$      898,680$      943,591$   53,399$   6% 44,911$     5% Annual Total 3,986,791$  3,988,931$   State  Shared Revenues 2010 vs. 2009 Revenue Year to Date through March 2010 vs. Budget 2009 2010 2010 Actual Budget Actual $ % $ % Jan 35,851$     36,982$     98,294$     62,443$  174% 61,312$  166% Feb 45,883        47,331        41,012        (4,871)       ‐11% (6,319)       ‐13% Mar 86,425        89,153        64,399        (22,026)    ‐25% (24,754)    ‐28% Apr 27,659        28,532        ‐                  May 58,715        60,569        ‐                  Jun 43,085        44,445        ‐                  Jul 61,541        63,483        ‐                  Aug 43,348        44,716        ‐                  Sep 36,509        37,662        ‐                  Oct 67,095        69,213        ‐                  Nov 59,883        61,773        ‐                  Dec 109,397     112,850     ‐                  YTD Total 168,159$  173,466$  203,705$  35,547$  21% 30,239$  17% Annual Total 675,391$  696,708$   2010 vs. Budget Year  to Date through March Plan Review / Inspection Month 2010 vs. 2009 Page 6 of 33 Monthly Financial Report March 2010        Recreation revenues totaled $227k since the start  of the year.  Compared to the projected monthly  budget, the City collected $21k or 27% more.   Compared to the same month the prior year, the  City collected $18k or 22% more.  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 $766k.  Compared to the projected  budget, the revenues are above by $18k or up by  2%.  Compared to the prior year, the revenues are  under by $17k or down by 2%.                            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 $747k.  This is $189k lower than a year  ago and $133k under budget.  Part of the  difference is due to the timing of revenue  recognition, which contributed to the variance in  January and will be caught up at the end of the  year.      There are also substantial decline in the photo  enforcement fines, which we expect to continue.   The decline is due to driver behavior changes in  the areas with photo enforcement programs; and the recent change in speed enforcement threshold in school zones.   These factors contributed to the reduction in photo enforcement revenue by 30% in February and 40% in March when  compared with the same period in 2009.  At this point, the City is projecting Fines and Penalties to be under budget by  $700k by the end of 2010.    2009 2010 2010 Actual Budget Actual $ % $ % Jan 65,409$         63,034$         62,673$      (2,736)$      ‐4% (361)$        ‐1% Feb 72,988            70,337            64,915         (8,072)         ‐11% (5,422)       ‐8% Mar 81,034            78,092            99,100         18,065      22% 21,008    27% Apr 141,783         136,635         ‐                   May 145,050         139,783         ‐                   Jun 154,237         148,636         ‐                   Jul 429,059         413,478         ‐                   Aug 203,222         195,842         ‐                   Sep 123,439         118,956         ‐                   Oct 79,452            76,566            ‐                   Nov 61,971            59,720            ‐                   Dec 73,842            71,161            ‐                   YTD  Total 219,431$      211,463$      226,688$   7,257$      3% 15,226$ 7% Annua l  Total 1,631,486$  1,572,240$   Recreation Year to Date through March 2010 vs. 2009 Month 2010 vs. Budget 2009 2010 2010 Actual Budget Actual $ % $ % Jan 280,849$      262,296$      239,080$   (41,769)$      ‐15% (23,215)$      ‐9% Feb 285,126         270,000         228,332      (56,794)         ‐20% (41,668)         ‐15% Mar 370,244         347,334         279,311      (90,933)         ‐25% (68,023)         ‐20% Apr 331,546         310,184         ‐                   May 310,888         290,518         ‐                   Jun 330,829         310,311         ‐                   Jul 321,486         307,795         ‐                   Aug 256,668         238,715         ‐                   Sep 269,199         250,627         ‐                   Oct 318,272         297,690         ‐                   Nov 368,928         345,586         ‐                   Dec 372,972         346,135         ‐                   YTD  Total 936,219$      879,630$      746,724$   (189,496)$   ‐20% (132,907)$   ‐15% Annual Total 3,817,008$  3,577,193$   2010 vs. Budget2010 vs. 2009 Year to Date through March Fines  and Penalties by Month Month 2009 2010 2010 Actual Budget Actual $ % $ % Jan 253,147$      241,782$      242,658$   (10,489)$   ‐4% 876$        0% Feb 243,496         232,565         273,674      30,178      12% 41,110    18% Mar 286,921         274,040         249,758      (37,163)      ‐13% (24,282)   ‐9% Apr 280,094         267,520         ‐                   May 282,056         269,393         ‐                   Jun 270,778         258,622         ‐                   Jul 263,897         252,050         ‐                   Aug 258,386         246,785         ‐                   Sep 265,902         253,965         ‐                   Oct 266,313         254,357         ‐                   Nov 281,154         268,532         ‐                   Dec 273,599         261,316         ‐                   YTD  Total 783,565$      748,387$      766,090$   (17,474)$   ‐2% 17,703$ 2% Annual Total 3,225,745$  3,080,927$   2010 vs. 2009 2010 vs. Budget Month Interfund Services Year  to Date through March Page 7 of 33 Monthly Financial Report March 2010        Year to Date through March 2009 2010 2010 Actual Budget Actual $ % $ % Civil Penalties 3,343$            2,862$            2,434$         (908)$             ‐27% (428)$             ‐15% Civil Infraction Penalties 172,899         156,960         126,678      (46,221)         ‐27% (30,282)         ‐19% Civil Parking Infraction Penalties 37,232            31,889            27,571         (9,661)            ‐26% (4,318)            ‐14% Photo Enforcement Program 616,448         585,698         495,096      (121,352)      ‐20% (90,602)         ‐15% Crim Traffic  Misdemeanor  Fines 25,020            19,985            15,107         (9,913)            ‐40% (4,878)            ‐24% Criminal Non‐Traffic  Fines 14,109            13,132            4,907            (9,203)            ‐65% (8,226)            ‐63% Criminal Costs 52,521            56,459            64,167         11,645         22% 7,707            14% Non‐Court Fines, Forfeitures and Penalties 14,648            12,646            10,765         (3,883)            ‐27% (1,881)            ‐15% YTD Total 936,219$      879,630$      746,724$   (189,496)$   ‐20% (132,907)$   ‐15% Annual Total 3,817,008$  3,577,193$   2010 vs. 2009 Revenue 2010 vs. Budget Fines  and Penalties by Type       Included in the Fines and Penalties revenue budget is  $2.3 million from the Photo Enforcement program.   The budget was based on the prior year revenue.   The year‐to‐date collections from this program  equates to $495k.  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 84% of the total revenue in  this category.  The year‐to‐date total miscellaneous is  $372k.  Compared to the projected year‐to‐date  budget, the revenues are over by $16k or up by 4%.                  2009 2010 2010 Actual Budget Actual $ % $ % Interests and Other Earnings 111,818$      112,386$      73,008$      (38,810)$   ‐35% (39,378)$   ‐35% Rents, Leases, and Concessions 232,834         186,521         241,192      8,358         4% 54,671      29% Contributions/Donations from  Private Sources 29,115            28,957            29,179         64                 0% 222              1% Other 22,081            28,724            28,864         6,783         31% 140              0% YTD  Total 395,848$      356,588$      372,244$   (23,604)$   ‐6% 15,655$   4% Annual Total 1,529,692$  1,377,980$   2010 vs. Budget Miscellaneous Revenues by Type Year to Date through March Revenue 2010 vs. 2009      Favorable 09Actual Budget Actual Budget Actual (Unfavorable) 1 Jan 182,568$     173,461$      187,281$  49,148$     71,970$          115,311$           Feb 175,461        166,708         135,565     49,023        72,434             63,131                 Mar 258,420        245,529         172,250     48,867        71,970             100,280              Apr 220,085        209,106          ‐                 49,262        ‐                      ‐                          May 202,192        192,106         ‐                 49,207        ‐                      ‐                          Jun 234,868        223,152         ‐                 48,930        ‐                      ‐                          Jul 151,075        143,538         ‐                 49,074        ‐                      ‐                          Aug 151,114        143,576         ‐                 48,747        ‐                      ‐                          Sep 157,730        149,862         ‐                 48,869        ‐                      ‐                          Oct 198,086        188,205         ‐                 48,622        ‐                      ‐                          Nov 253,056        240,433         ‐                 49,269        ‐                      ‐                          Dec 183,477        174,325         ‐                 51,319        ‐                      ‐                          YTD Total 616,448$     585,698$      495,096$  147,038$  216,373$       278,722$           Annual Total 2,368,131   2,250,000$  590,336$   1Actuals  of Revenues and Expenses Revenues Expenses Photo Enforcement Program Year to Date through March Month 2009 2010 2010 Actual Budget Actual $ % $ % Jan 143,245$      129,038$      170,998$   27,753$   19% 41,959$   33% Feb 192,680         173,570         86,124         (106,555)   ‐55% (87,446)      ‐50% Mar 59,923            53,980            115,122      55,199      92% 61,142      113% Apr 100,349         90,397             May 156,161         140,673          Jun 100,207         90,269             Jul 219,671         197,884          Aug 80,681            72,680             Sep 131,358         118,330          Oct 76,125            68,575             Nov 73,002            65,762             Dec 196,289         176,822          YTD  Total 395,848$      356,588$      372,244$   (23,604)$   ‐6% 15,655$   4% Annual Total 1,529,692$  1,377,980$   Mi scellaneous  Revenues by Month Year to Date through March Month 2010 vs. Budget2010 vs. 2009 Page 8 of 33 Monthly Financial Report March 2010        EXPENSES  The City has completed the year and our operating costs are running below the trends from prior years.  Overall the City has  expended 23% 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 carried forward from 2009 to complete projects we have  started and not yet completed as well as budgeted expenditures related to grants.            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 ‐                  ‐             ‐              ‐               16,125         14,550       ‐               Grants 61,220           ‐             ‐              ‐               ‐               176,162     ‐               Charges  for services 2,755             251,283     3,737,155    2,265,531    4,262,126    1,237,322  ‐               Interdepartmental services ‐                 ‐             838              69,939         26,578         114,385     ‐               Rents, leases, and misc fees 306,549         54,933       24,000         26,293         ‐               ‐             ‐               Interest and other misc 3,744             3,998         98,465         98,352         51,090         41,276       48                TOTAL REVENUES 374,268         310,214     3,860,458    2,460,115    4,355,919    1,583,695  48                EXPENSES: Utility billing ‐                 ‐             33,149         24,767         24,767         41,149       ‐               Utility systems ‐                 ‐             2,828,389    610,905       541,692       517,939     ‐               Utility maintenance ‐                 ‐             35,832         1,129,452    2,159,166    394,946     ‐               Transportation 242,660         ‐             ‐              ‐               ‐               ‐             ‐               Golf ‐                 385,645     ‐              ‐               ‐               ‐             ‐               TOTAL EXPENSES 242,660         385,645     2,897,370    1,765,124    2,725,625    954,034     ‐               AMOUNT AVAILABLE FOR DEBT SERVICE 131,608         (75,431)      963,088       694,991       1,630,294    629,661     48                DEBT SERVICE: Principal ‐                 5,673         ‐              ‐               ‐               ‐             ‐               Interest and other debt service costs ‐                 393            ‐              875              350              525            ‐               TOTAL DEBT SERVICE ‐                 6,066         ‐              875              350              525            ‐               CAPITAL PROJECTS 86,871           159,439     ‐              185,384       285,486       286,462     ‐               TRANSFERS IN/(OUT)‐                 ‐             ‐              ‐               ‐               ‐             ‐               CHANGE IN FUND BALANCE 44,737           (240,936)    963,088       508,732       1,344,458    342,674     48                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, March  31, 2010 1,093,820      844,865     1,289,122    7,665,840    4,119,996    4,325,516  15,653             Page 9 of 33 Monthly Financial Report March 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 525,164     490,633      ‐             ‐                      ‐              ‐               ‐             Telecommunications ‐            71,436        ‐             ‐                      ‐              ‐               ‐             Print and mail ‐            26,834        ‐             84,366                 ‐              ‐               ‐             Communications ‐            ‐              ‐             135,006               ‐              ‐               ‐             Facilities ‐            ‐              1,044,073   ‐                      ‐              ‐               ‐             Data cards  and cell  phones ‐            28,094        ‐             ‐                      ‐              ‐               ‐             IT service contracts ‐            62,686         ‐             ‐                      ‐              ‐               ‐             Interest and other misc 14,367       5,939          386             333                      18,125         17,415         9,657          Internal service fund misc: Vehicle/equipment capital  recovery 359,714     249,170      ‐             ‐                      ‐              ‐               ‐             Insurance premiums ‐            ‐              ‐             ‐                      552,217       ‐               ‐             Worker's  compensation  / unemployment ‐            ‐              ‐             ‐                      325,649       ‐               ‐             Benefit premiums ‐            ‐              ‐             ‐                      ‐              2,748,443    439,169      Other misc ‐            ‐              ‐             ‐                      ‐              194,716       ‐             Disposal  of capital  assets ‐            ‐              ‐             ‐                      ‐              ‐               ‐             Insurance recoveries ‐            ‐              ‐             ‐                      43,124         39,999         9,838          TOTAL REVENUES 899,245     934,792      1,044,459   219,705               939,115       3,000,573    458,664      EXPENSES: Communications 96,713                  Equipment rental 480,071      Facilities 955,133       Healthcare 2,225,669     Information technology 750,700       Print and mail ‐              121,206                Retiree healthcare 272,590      Risk management 1,015,733     TOTAL EXPENSES 480,071     750,700      955,133      217,919               1,015,733    2,225,669    272,590      AMOUNT AVAILABLE FOR DEBT SERVICE 419,174     184,092      89,326        1,786                   (76,618)       774,904       186,074      DEBT SERVICE: Principal ‐            ‐              ‐             ‐                      ‐              ‐               ‐             Interest and other debt service costs ‐            ‐              ‐             ‐                      ‐              ‐               ‐             TOTAL DEBT SERVICE ‐            ‐              ‐             ‐                      ‐              ‐               ‐             CAPITAL PROJECTS 373,204     129,618      25,000        29,408                 ‐              ‐               ‐             TRANSFERS IN ‐            ‐              ‐             ‐                      ‐              ‐               ‐             TRANSFERS (OUT)‐            ‐              ‐             ‐                      ‐              ‐               ‐             CHANGE  IN FUND BALANCE 45,970       54,474        64,326        (27,622)               (76,618)       774,904       186,074      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, March  31, 2010 4,639,369  1,702,405   155,501      84,196                 5,962,891    5,567,356    3,006,547     Page 10 of 33 Monthly Financial Report March 2010        THE SCORE    The South Correctional Entity (SCORE) is a public development authority (PDA) that was formed to build and operate a new  822‐bed misdemeanor jail in South King County.  SCORE is made up of cities located in South King County and they are  Auburn, Burien, Des Moines, Federal Way, Renton, SeaTac, and Tukwila.  The City of Renton is the principle of the PDA as  well as acting as the treasurer and fiscal agent for SCORE during the planning and development phase. The design and  permit work, construction bid opening, and bond sell has been completed.    The current estimated total development and construction 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 4,000              Des Moines ‐                  Federal  Way ‐                  Renton ‐                  Seatac 3,000              Tukwila ‐                  Interest and other misc 85,609            Bond proceeds ‐                  Tax Credit (BABs)‐                  TOTAL REVENUES 92,609            EXPENSES: Salaries  and wages ‐                  Benefits ‐                  Supplies 604                 Professional services 398,996          Intergovernmental 54,966            Construction 9,682,726       TOTAL EXPENSES 10,137,292     AMOUNT AVAILABLE FOR DEBT SERVICE (10,044,683)    DEBT SERVICE: Principal ‐                  Interest and other debt service costs 860,942          TOTAL DEBT SERVICE 860,942          CHANGE IN FUND BALANCE (10,905,624)    BEGINNING FUND BALANCE, January 1, 2010 80,644,637     ENDING FUND BALANCE, March  31, 2010 69,739,013     Page 11 of 33 Monthly Financial Report March 2010        FUND BALANCE  Page 13 shows the ending fund balance as of March 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.      At the end of March, the City has $4.8 million reported in combined general governmental fund balance of current year  operating budget, which is approximately 5% of budgeted operating expenditures.  This is a decrease of $7.1 million from  the beginning balance of January 1, 2010.  March’s ending fund balance is under the anticipated General Governmental  Fund Balance of $5.7 million by $831k.  Although the ending fund balance is under projections, it 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 12 of 33 Monthly Financial Report March 2010        City  of Renton All Funds ‐ Revenue, Expenditures and Fund Balances Cash  Basis through March  31, 2010 Funds Balance  01/01/2010 Budgeted  Revenue Revenue  03/31/10 Total Funds  Available Budgeted  Expenditure Expenditure  03/31/10 Ending Balance GENERAL GOVERNMENT FUNDS:11,955,285       97,838,698     15,590,071     27,545,356         97,838,698         22,695,538         4,849,818         000 General 8,535,013         74,198,436     11,941,595     20,476,608         71,418,283         17,846,883         2,629,725         001 Community Services 958,009            9,544,866       1,857,318       2,815,327           10,354,293         2,026,750           788,577            003 Street 1,391,648         7,149,882       1,266,240       2,657,888           8,476,980           2,078,338           579,550            004 Community Dev Block Grant (6,528)               294,148          81,177            74,649                296,503              68,480                6,169                005 Museum 64,705              192,621          112                 64,817                194,120              46,726                18,091              006 Library 706,011            1,888,252       19,115            725,126              2,544,263           500,663              224,463            009 Farmers  Market 60,571              44,280            10,900            71,471                34,311                1,308                  70,163              010 Fire Memorial 936                   ‐                     (700)               236                     ‐                          ‐                          236                   011 Fire Health & Wellness 4,303                25,000            6,612              10,915                25,000                ‐                          10,915              031 Park  Memorial 175,066            ‐                     568                 175,634              ‐                          ‐                          175,634            201 Ltd  GO Bonds  Gen Govt Debt 1,448                2,033,177       172,343          173,791              1,984,625           2,400                  171,391            215 Gen Govt Misc Debt Service 64,103              2,468,036       234,791          298,894              2,510,320           123,990              174,904            SPECIAL REVENUE FUNDS: 102 Arterial  Street 200,686            620,000          246,227          446,913              620,000              ‐                          446,913            108 Leased City Properties 837,613            941,533          324,923          1,162,536           581,940              476,218              686,318            110 Hotel Motel 247,828            245,000          87,455            335,283              245,000              115,834              219,449            118 Reserve for Paths  & Trails 3,264                 ‐                     14                   3,278                   ‐                           ‐                          3,278                125 1% For Art 143,796            15,000            472                 144,268              50,000                86                       144,182            127 Cable  Communication 89,391              85,000            13,826            103,217              85,674                8,500                  94,717              135 Springbrook Wetlands Bank 459,528             ‐                     1,499              461,027               ‐                           ‐                          461,027            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            7,384              1,073,977           ‐                          ‐                          1,073,977         304 Fire  Mitigation 2,363,522         100,000          19,401            2,382,923           560,000              ‐                          2,382,923         305 Transportation Mitigation 2,167,133         200,000          (56,970)          2,110,163           700,000              ‐                          2,110,163         316 Municipal  Facilities  CIP 6,933,186         730,000          212,530          7,145,716           1,653,454           461,949              6,683,767         317 Transportation CIP 2,892,341         15,692,002     3,188,960       6,081,301           16,126,973         2,279,622           3,801,679         318 So Lake  WA Infrastructure  Proj 114,039            ‐                     373                 114,412              ‐                          ‐                          114,412            326 Housing Opportunity 201,653            ‐                     661                 202,314              ‐                          ‐                          202,314            ENTERPRISE FUNDS: 402 Airport 415,929            1,917,163       310,979          726,908              1,001,800           242,660              484,248            403 Solid Waste Utility 326,034            15,000,000     3,860,457       4,186,491           15,000,000         2,897,371           1,289,120         404 Golf Course 798,278            2,483,545       309,509          1,107,787           2,566,837           434,186              673,601            422 Airport Capital 633,154            1,578,000       63,290            696,444              1,578,000           86,871                609,573            424 Golf Course  Capital 287,523            150,000          706                 288,229              150,000              116,964              171,265            INTERNAL SERVICE FUNDS: 501 Equipment Repair/Replacement 4,593,399         3,631,241       899,245          5,492,644           2,791,684           853,275              4,639,369         502 Insurance 6,039,509         3,287,584       939,114          6,978,623           4,170,106           1,015,733           5,962,890         503 Information Services 1,647,931         4,105,387       934,792          2,582,723           3,715,819           880,319              1,702,404         504 Facilities 91,175              4,555,485       1,044,459       1,135,634           4,176,210           980,133              155,501            505 Communications 111,818            1,049,671       219,705          331,523              877,560              247,327              84,196              512 Insurance, Healthcare 4,792,452         12,358,471     3,000,573       7,793,025           12,462,810         2,225,669           5,567,356         522 Insurance, Leoff1 Retirees HC 2,820,473         2,235,684       458,663          3,279,136           2,248,907           272,590              3,006,546         FIDUCIARY FUNDS: 611 Firemen's  Pension 4,332,817         300,000          4,553              4,337,370           550,475              102,791              4,234,579         Funds Balance  01/01/2010 Budgeted  Revenue Revenue  03/31/10 Total Funds  Available Budgeted  Expenditure Expenditure  03/31/10 Ending Balance ENTERPRISE FUNDS: COMBINED  UTILITIES 13,931,093       42,352,430     8,399,776       22,330,869         42,554,258         6,203,863           16,127,006       405 Water Utility 4,294,833         11,316,610     2,406,033       6,700,866           11,319,531         1,765,998           4,934,868         406 Waste  Water Utility 1,887,815         6,070,737       1,414,580       3,302,395           6,389,869           821,769              2,480,626         407 Surface Water Utility 2,448,845         5,768,148       1,379,761       3,828,606           5,647,923           954,559              2,874,047         416 Ki ng  County Metro 46,504              11,211,935     2,902,967       2,949,471           11,211,935         1,904,205           1,045,266         425 Water Utility Construction 2,862,275         2,960,000       54,081            2,916,356           2,960,000           185,384              2,730,972         426 Waste  Water Construction 841,219            2,775,000       38,373            879,592              2,775,000           285,486              594,106            427 Surface Water Construction 1,533,997         2,250,000       203,933          1,737,930           2,250,000           286,462              1,451,468         461 Waterworks  Bond Reserve ‐                        ‐                     ‐                     ‐                          ‐                          ‐                          ‐                        471 Waterworks  Rate Stabilization 15,605              ‐                     48                   15,653                ‐                          ‐                          15,653              481 Future W/S Bond Proceeds ‐                        ‐                     ‐                     ‐                          ‐                          ‐                          ‐                        Note:  Waterworks  Utility Funds are managed as a  system and are designated by the  dotted  lines.  Page 13 of 33 City of Renton General Government Financial Position 2010 Budget Year General Government Summary  Revenues Expenditures  $ Difference over (under)  w/beginning  balance  11,955,285             January 4,881,556              7,161,528              (2,279,972)             9,675,313               February 10,472,029            15,011,456            (4,539,427)             7,415,858               March 15,590,071            22,695,538            (7,105,467)             4,849,818               April 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 14 of 33 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 4,878,237        4,881,556        0.07% Feb 10,773,019      10,472,029       ‐2.79% Mar 16,233,397      15,590,071       ‐3.96% Apr 29,019,936       May 43,806,298       Jun 48,958,484       Jul 55,020,570       Aug 60,711,847       Sep 65,338,639       Oct 76,560,738       Nov 92,025,122       Dec 97,838,698       Percent of budget 15.93% Property Tax Budget YTD Actual Annual %  over (under) $‐ $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  Millions Total Revenue General Government Budget Actual Last Year $30  $33  Millions Property Tax Budget Actual py g () Jan 9,635                218,705           2169.90% Feb 320,118           489,513           52.92% Mar 982,841           1,037,146        5.53% Apr 9,231,227         May 16,097,311       Jun 16,213,191       Jul 16,320,354       Aug 16,388,472       Sep 16,644,516       Oct 22,547,053       Nov 31,012,799       Dec 31,364,643       Percent of budget 3.31% $‐ $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 15 of 33 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Sales Tax Budget YTD Actual Annual %  over (under) Jan 1,688,260        1,442,659         ‐14.55% Feb 3,848,016        3,376,692         ‐12.25% Mar 5,540,865        4,818,562         ‐13.04% Apr 7,161,203         May 8,888,836         Jun 10,537,549       Jul 12,138,293       Aug 13,935,185       Sep 15,628,456       Oct 17,436,835       Nov 18,929,142       Dec 20,857,000       Percent of budget 23.10% Note:  Includes Funds 108, 318, 501, and 503.  Excludes CJ Sales Tax and Natural Gas Use Tax. Utility Tax Budget YTD Actual Annual %  over (under) $‐ $3  $6  $9  $12  $15  $18  $21  Millions Sales Tax Budget Actual Last Year $14 $16  Millions Utility Tax Budget Actual y g () Jan 1,379,262        1,282,930        ‐6.98% Feb 2,829,096        2,637,863        ‐6.76% Mar 4,050,000        3,933,596        ‐2.87% Apr 5,225,375         May 6,516,282         Jun 7,560,617         Jul 8,546,617         Aug 9,718,578         Sep 10,760,779       Oct 11,813,935       Nov 12,878,332       Dec 14,228,000       Percent of budget 27.65% 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 16 of 33 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Licenses/ Permits Budget YTD Actual Annual %  over (under) Jan 220,191           394,387           79.11% Feb 415,373           496,041           19.42% Mar 640,289           633,007            ‐1.14% Apr 866,016            May 1,046,903         Jun 1,224,807         Jul 1,451,179         Aug 1,631,518         Sep 1,759,093         Oct 2,024,220         Nov 2,153,967         Dec 2,386,376         Percent of budget 26.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 338,139           371,847           9.97% Feb 787,424           1,023,691        30.01% Mar 1,195,183        1,536,757        28.58% Apr 1,622,082         May 4,801,888         Jun 5,177,187         Jul 5,578,231         Aug 6,648,613         Sep 7,098,457         Oct 7,710,824         Nov 10,857,610       Dec 11,192,951       Percent of budget 13.73% 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 17 of 33 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Charges for  Svcs Budget YTD Actual Annual %  over (under) Jan 391,334           445,172           13.76% Feb 791,905           869,415           9.79% Mar 1,295,331        1,336,778        3.20% Apr 1,774,948         May 2,308,362         Jun 2,817,547         Jul 3,611,251         Aug 4,145,264         Sep 4,604,070         Oct 5,058,558         Nov 5,489,415         Dec 5,997,460         Percent of budget 22.29% 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 262,296           239,080           ‐8.85% Feb 532,296           467,413           ‐12.19% Mar 879,630           746,724           ‐15.11% Apr 1,189,814         May 1,480,333         Jun 1,790,644         Jul 2,098,439         Aug 2,337,154         Sep 2,587,781         Oct 2,885,471         Nov 3,231,058         Dec 3,577,193         Percent of budget 20.87% $‐ $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 18 of 33 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year Other Taxes Budget YTD Actual Annual %  over (under) Jan 424,298           315,778            ‐25.58% Feb 887,009           854,174            ‐3.70% Mar 1,210,805        1,175,121         ‐2.95% Apr 1,527,046         May 2,129,929         Jun 3,055,413         Jul 3,781,909         Aug 4,301,294         Sep 4,584,474         Oct 5,408,386         Nov 5,791,753         Dec 6,297,095         Percent of budget 18.66% 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 129,034           170,998           32.52% Feb 302,604           257,122           ‐15.03% Mar 356,594           372,244           4.39% Apr 446,989            May 587,653            Jun 677,925            Jul 1,416,302         Aug 1,488,990         Sep 1,066,818         Oct 1,135,400         Nov 1,201,158         Dec 1,377,980         Percent of budget 27.01% $‐ $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 19 of 33 City of Renton Monthly Revenue Analysis ‐ 2010 Budget Year REET Budget YTD Actual Annual %  over (under) Jan 229,560           71,303               ‐68.94% Feb 298,320           178,545            ‐40.15% Mar 480,120           487,709           1.58% Apr 620,064            May 925,800            Jun 1,135,488         Jul 1,335,888         Aug 1,644,120         Sep 1,850,592         Oct 2,058,960         Nov 2,279,304         Dec 2,400,000         Percent of budget 20.32% 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 20 of 33 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      15,011,456       ‐0.08% Mar 22,448,111      22,695,538      1.10% 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 23.20% Legislative Budget YTD Actual Annual %  over (under) $‐ $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  Millions Total Expenditures General Government Budget Actual Last Year $300,000  Legislative Budget g g () Jan 21,938              21,032              ‐4.13% Feb 44,183              43,671              ‐1.16% Mar 68,592              65,280              ‐4.83% Apr 91,263               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 24.36% $‐ $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 21 of 33 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           328,318           3.53% Mar 482,634           499,117           3.42% 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 24.81% Executive Budget YTD Actual Annual %  over (under) $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  $2.00  $2.20  Millions Court Services Budget Actual Last Year $1.80  Millions Executive Budget g () Jan 105,591           134,784           27.65% Feb 250,653           272,736           8.81% Mar 385,511           407,609           5.73% Apr 521,891            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 24.93% $‐ $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 22 of 33 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Finance Budget YTD Actual Annual %  over (under) Jan 231,228           145,053            ‐37.27% Feb 387,182           286,770            ‐25.93% Mar 562,096           443,082            ‐21.17% Apr 721,488            May 901,039            Jun 1,058,643         Jul 1,218,526         Aug 1,384,265         Sep 1,543,696         Oct 1,663,318         Nov 1,820,765         Dec 1,964,890         Percent of budget expended 22.55% City Attorney Budget YTD Actual Annual %  over (under) $1.60  $1.80  Millions City Attorney Budget At l $‐ $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10  Millions Finance Budget Actual Last Year y y g () Jan 106,795           127,162           19.07% Feb 246,680           266,526           8.05% Mar 403,070           400,465           ‐0.65% Apr 549,408            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 24.70% $‐ $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 23 of 33 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           141,160            ‐4.39% Mar 228,975           213,772            ‐6.64% 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 23.40% Public Works Budget YTD Actual Annual %  over (under) $‐ $0.10  $0.20  $0.30  $0.40  $0.50  $0.60  $0.70  $0.80  $0.90  $1.00  Millions Human Resources Budget Actual Last Year $1.20  Millions Public Works Budget g () Jan 40,311              42,532              5.51% Feb 86,173              86,114              ‐0.07% Mar 133,892           129,351           ‐3.39% Apr 179,050            May 221,237            Jun 264,331            Jul 308,727            Aug 353,278            Sep 394,646            Oct 441,919            Nov 483,769            Dec 518,399            Percent of budget expended 24.95% 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 24 of 33 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Other City  Services Budget YTD Actual Annual %  over (under) Jan 414,785           348,715            ‐15.93% Feb 819,456           701,408            ‐14.41% Mar 1,210,803        1,136,033         ‐6.18% Apr 1,824,496         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 23.70% 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,133,213        2,260,619        5.97% Feb 4,451,419        4,238,853        ‐4.78% Mar 6,690,934        6,677,267        ‐0.20% Apr 8,707,077         May 11,038,812       Jun 13,268,939       Jul 15,720,229       Aug 17,814,787       Sep 20,258,345       Oct 22,428,281       Nov 25,004,372       Dec 27,610,835       Percent of budget expended 24.18% $‐ $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 25 of 33 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Fire & Emerg  Svc Budget YTD Actual Annual %  over (under) Jan 1,794,155        1,768,398         ‐1.44% Feb 4,263,621        4,239,777         ‐0.56% Mar 6,014,430        5,943,458         ‐1.18% Apr 7,691,011         May 9,423,488         Jun 11,146,615       Jul 12,943,323       Aug 14,652,309       Sep 16,470,345       Oct 18,249,428       Nov 19,955,330       Dec 21,802,109       Percent of budget expended 27.26% City Clerk Budget YTD Actual Annual %  over (under) $‐ $3  $6  $9  $12  $15  $18  $21  $24  Millions Fire & Emergency Services Budget Actual Last Year $1.00 Millions City Clerk Budget y g () Jan 77,013              48,025              ‐37.64% Feb 148,683           92,936              ‐37.49% Mar 257,863           146,137           ‐43.33% Apr 393,130            May 465,321            Jun 538,843            Jul 603,120            Aug 661,523            Sep 723,147            Oct 781,484            Nov 843,676            Dec 931,014            Percent of budget expended 15.70% $‐ $3  $6  $9  $12  $15  $18  $21  $24  Millions Fire & Emergency Services Budget Actual Last Year $0.00 $0.20 $0.40 $0.60 $0.80 $1.00 Millions City Clerk Budget Actual Last Year Page 26 of 33 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Human  Services Budget YTD Actual Annual %  over (under) Jan 31,079              40,228              29.44% Feb 68,328              72,960              6.78% Mar 96,869              139,024           43.52% Apr 238,680            May 297,161            Jun 358,780            Jul 473,188            Aug 525,725            Sep 566,364            Oct 689,219            Nov 744,407            Dec 869,096            Percent of budget expended 16.00% Note:  General Fund only Hearing  Examiner Budget YTD Actual Annual %  over (under) $0.00 $0.10 $0.20 $0.30 $0.40 $0.50 $0.60 $0.70 $0.80 $0.90 $1.00 Millions Human Svcs (Comm Svcs) Budget Actual Last Year $200,000  $220,000  Hearing Examiner Budget g () Jan 16,707              14,619              ‐12.50% Feb 33,528              29,129              ‐13.12% Mar 50,066              43,412              ‐13.29% Apr 67,019               May 83,535               Jun 99,983               Jul 117,131            Aug 133,757            Sep 150,300            Oct 166,956            Nov 183,659            Dec 200,440            Percent of budget expended 21.66% $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 27 of 33 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year CED Budget YTD Actual Annual %  over (under) Jan 482,302           555,670           15.21% Feb 1,022,373        1,097,029        7.30% Mar 1,549,696        1,602,874        3.43% Apr 2,048,262         May 2,563,781         Jun 3,062,722         Jul 3,611,458         Aug 4,140,980         Sep 4,659,701         Oct 5,189,913         Nov 5,702,230         Dec 6,279,159         Percent of budget expended 25.53% Note:  For comparative purposes history includes Development Svcs division (previously in Public Works). Note:  General Fund only General Fund Budget YTD Actual Annual %  over (under)$75  Millions General Fund Budget $‐ $1.50  $3.00  $4.50  $6.00  $7.50  Millions Community & Economic Development Budget Actual Last Year g () Jan 5,662,041        5,746,764        1.50% Feb 11,966,133      11,897,388      ‐0.57% Mar 17,701,021      17,846,883      0.82% 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 24.99% $‐ $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 28 of 33 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        1,321,394         ‐5.67% Mar 2,156,281        2,026,750         ‐6.01% 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 19.57% 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        1,365,252        7.80% Mar 1,943,687        2,078,338        6.93% 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 24.52% $‐ $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 29 of 33 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year CDBG Budget YTD Actual Annual %  over (under) Jan 19,605              13,958               ‐28.80% Feb 41,985              40,304               ‐4.00% Mar 67,262              68,480              1.81% Apr 93,576               May 114,017            Jun 134,236            Jul 153,461            Aug 189,021            Sep 206,595            Oct 239,231            Nov 260,683            Dec 296,503            Percent of budget expended 23.10% 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 178,200           173,794           ‐2.47% Feb 369,656           229,125           ‐38.02% Mar 573,477           500,663           ‐12.70% Apr 777,934            May 977,023            Jun 1,176,467         Jul 1,368,254         Aug 1,579,352         Sep 1,772,156         Oct 1,974,603         Nov 2,165,372         Dec 2,544,263         Percent of budget expended 19.68% $‐ $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 30 of 33 City of Renton Monthly Expenditure Analysis ‐ 2010 Budget Year Museum Fund Budget YTD Actual Annual %  over (under) Jan 15,829              15,310               ‐3.28% Feb 32,775              31,141               ‐4.99% Mar 49,002              46,726               ‐4.64% Apr 65,543               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 24.07% 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 ‐                          ‐                         N/A Feb ‐                         126,390           100.00% Mar 22,250              126,390           468.04% Apr 22,250               May 22,250               Jun 1,078,472         Jul 1,078,472         Aug 1,078,472         Sep 1,078,472         Oct 1,290,948         Nov 1,293,331         Dec 4,494,945         Percent of budget expended 2.81% $‐ $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 31 of 33 City of Renton Monthly Enterprise Fund Financial Report ‐ 2010 Budget Year Utilities Budget Revenue Expense Jan 2,457,102        3,901,859      2,612,849       Feb 5,532,784        7,676,067      5,998,348       Mar 8,458,919        11,963,798    8,343,902       Apr 10,568,438       May 14,342,459       Jun 18,820,257       Jul 22,986,726       Aug 27,032,198       Sep 30,031,294       Oct 33,032,203       Nov 36,377,070       Dec 45,317,258       Percent of budget expended 18.41% Note:  Operations only, excludes bond proceeds and transfers to capital. Airport Budget Revenue Expense $0 $5 $10 $15 $20 $25 $30 $35 $40 $45 $50 Millions Utilities Budget Revenue Expense $1.20  Millions Airport Budget p g p Jan 66,269              94,268            72,717             Feb 159,667           204,281          156,869           Mar 250,901           310,979          242,660           Apr 329,772            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 24.22% Note:  Operations only. $0 $5 $10 $15 $20 $25 $30 $35 $40 $45 $50 Millions Utilities Budget Revenue Expense $‐ $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  Millions Airport Budget Revenue Expense Page 32 of 33 City of Renton Monthly Enterprise Fund Financial Report ‐ 2010 Budget Year Golf Course Budget Revenue Expense Jan 129,394           68,826            97,947             Feb 258,326           174,258          215,710           Mar 479,768           309,509          434,186           Apr 618,377            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 16.92% 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 33 of 33