HomeMy WebLinkAbout201312, December.pdfADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: February 24, 2014
TO: Don Persson, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: December 2013 Financial Status Report
At the end of December, general governmental revenues show $2.1 million or 2% over budget.
Revenues sources that are higher than expected are: property tax ($244k); sales tax ($212k);
sales tax annexation credit ($299k); utility taxes ($181k); real estate excise tax ($1.3 million);
building permits & development service fees ($378k); public safety services including FD25 &
FD40 contacts ($123k); interfund services ($151k); and other miscellaneous ($168k). On the
down side, the revenue sources that are underperforming the year to date budget are:
gambling taxes ($280k below); culture/recreation services ($124k below); fines/penalties
($292k below); seizure funds ($130k below, restricted to drug enforcement only and is not
available for general operating purposes) and interest ($322k below).
General government expenditures showed a favorable variance of $2.6 million or 2.5%. See
page 9 of report for further expenditure over‐spent explanations.
The attached report provides more detailed discussion of each revenue source and our updated
projections for the year. Please do not hesitate to contact me at x6952 should you have any
questions or any suggestions about the report.
This page is intentionally left blank
General Governmental Funds
$%
Beginning Fund Balance 11,407,119$ 11,407,119$ 11,057,551$ 11,057,551$ 10,751,945$ 15,575,839$ 15,575,839$ ‐ 0.0%
OPERATING REVENUES
Property Tax 32,357,894 32,357,894 33,466,364 33,466,364 31,741,366 32,241,366 32,485,690 244,324 0.8%
Sales Tax 17,729,731 17,729,731 18,564,670 18,564,670 18,604,000 20,204,000 20,416,372 212,373 1.1%
Sales Tax ‐ Annexation Credit 2,033,954 2,033,954 2,208,492 2,208,492 2,119,680 2,119,680 2,418,789 299,109 14.1%
Criminal Justice Sales Tax 1,809,757 1,809,757 1,924,470 1,924,470 1,932,500 1,932,500 2,091,174 158,674 8.2%
Natural Gas Use Tax 249,407 249,407 272,530 272,530 300,000 300,000 263,660 (36,340) ‐12.1%
Admission Tax 308,200 308,200 311,054 311,054 308,000 308,000 327,258 19,258 6.3%
Franchise Fees 1,234,448 1,234,448 1,262,188 1,262,188 1,260,000 1,260,000 1,312,727 52,727 4.2%
Electricity Tax 5,166,711 5,166,711 5,211,111 5,211,111 5,468,000 5,218,000 5,155,789 (62,211) ‐1.2%
Natural Gas Utility Tax 1,848,806 1,848,806 1,669,967 1,669,967 1,656,000 1,456,000 1,550,900 94,900 6.5%
Transfer Station 297,474 297,474 330,607 330,607 300,000 300,000 397,596 97,596 32.5%
TV Cable 1,385,275 1,385,275 1,423,664 1,423,664 1,477,648 1,477,648 1,481,779 4,131 0.3%
Telephone 966,827 966,827 1,056,420 1,056,420 1,000,000 1,000,000 917,021 (82,979) ‐8.3%
Cellular Phone 2,054,183 2,054,183 2,183,853 2,183,853 2,200,000 2,000,000 2,050,312 50,312 2.5%
City Utilities 3,516,179 3,516,179 3,806,281 3,806,281 3,849,014 3,849,014 3,964,989 115,975 3.0%
Leasehold Excise Tax 162,593 162,593 158,849 158,849 145,000 145,000 164,637 19,637 13.5%
Gambling Excise Tax 1,671,414 1,671,414 1,691,209 1,691,209 1,600,000 1,600,000 1,319,585 (280,415) ‐17.5%
Real Estate Excise Tax 2,074,059 2,074,059 2,811,902 2,811,902 2,600,000 2,600,000 4,131,665 1,531,665 58.9%
Less: CIP REET (400,000) (400,000) (943,792) (943,792) (500,000) (500,000) (700,000) (200,000) 40.0%
EMS Levy 868,873 868,873 885,781 885,781 900,000 900,000 916,361 16,361 1.8%
Business License Fees 442,451 442,451 444,680 444,680 533,067 533,067 503,766 (29,301) ‐5.5%
Animal Licenses and Spec Events Permits 92,385 92,385 91,835 91,835 90,000 90,000 99,411 9,411 10.5%
Building Permits & Development Svc Fees 2,912,928 2,912,928 3,552,369 3,552,369 3,080,188 3,623,413 4,001,625 378,212 10.4%
Intergovt'l (Grants, State Shared, etc) 4,737,323 4,737,323 4,593,185 4,593,185 2,670,330 4,042,227 3,863,974 (178,253) ‐4.4%
Fire District 25 and 40 Contracts 6,110,668 6,110,668 6,155,621 6,155,621 5,865,056 5,865,056 5,726,895 (138,161) ‐2.4%
Public Safety 484,985 484,985 485,899 485,899 380,229 419,229 680,581 261,352 62.3%
Culture and Recreation 1,493,540 1,493,540 1,494,165 1,494,165 1,633,486 1,618,486 1,494,580 (123,906) ‐7.7%
Interfund/Interdept‐Services 3,070,506 3,070,506 3,311,715 3,311,715 3,004,214 3,313,830 3,464,913 151,083 4.6%
Fines and Penalties 1,163,602 1,163,602 1,046,246 1,046,246 1,108,500 1,108,500 1,137,140 28,640 2.6%
Photo Enforcement 1,897,782 1,897,782 1,976,203 1,976,203 1,950,000 1,950,000 1,629,524 (320,476) ‐16.4%
Seizure Funds ‐ Federal/State/Local 83,220 83,220 37,941 37,941 180,693 180,693 50,639 (130,054) ‐72.0%
Interests and Other Earnings 107,183 107,183 342,424 342,424 645,300 745,300 423,609 (321,691) ‐43.2%
Rents, Leases, and Concessions 744,834 744,834 822,428 822,428 657,929 650,929 734,530 83,601 12.8%
Contributions and Donations 196,586 196,586 124,082 124,082 87,000 94,665 84,320 (10,345) ‐10.9%
Other Miscellaneous 529,147 529,147 564,571 564,571 516,369 516,369 684,187 167,818 32.5%
Other Financing Sources (Transfer‐In, etc) 1,073,507 1,073,507 5,118,188 5,118,188 250,000 274,868 299,527 24,659 9.0%
Total Operating Revenues 100,476,431 100,476,431 108,457,170 108,457,170 99,613,569 103,437,840 105,545,527 2,107,688 2.0%
OPERATING EXPENDITURES
Council 271,236 271,236 278,768 278,768 289,114 290,291 289,911 380 0.1%
Executive 1,566,906 1,566,906 1,377,109 1,377,109 1,318,832 1,322,364 1,240,910 81,454 6.2%
City Attorney 1,596,609 1,596,609 1,706,320 1,706,320 1,872,973 1,915,103 1,922,225 (7,123) ‐0.4%
Court Services 2,084,170 2,084,170 2,074,980 2,074,980 2,009,664 2,026,149 2,003,104 23,045 1.1%
Community and Eco Dvlpmnt Admin 929,814 929,814 942,071 942,071 1,017,853 1,040,208 1,047,860 (7,652) ‐0.7%
Development Services 2,810,736 2,810,736 3,103,568 3,103,568 2,966,891 3,358,299 3,243,702 114,597 3.4%
Economic Development 659,981 659,981 529,043 529,043 546,986 550,280 467,511 82,768 15.0%
Planning 1,447,781 1,447,781 1,482,233 1,482,233 1,454,717 1,541,592 1,510,707 30,885 2.0%
Finance 2,134,667 2,134,667 2,221,882 2,221,882 1,952,608 2,242,682 2,274,147 (31,465) ‐1.4%
City Clerk1 796,758 796,758 997,434 997,434 1,056,822 1,101,505 1,020,822 80,683 7.3%
Human Resources 888,252 888,252 937,412 937,412 971,207 977,094 904,182 72,912 7.5%
Police 24,737,346 24,737,346 25,004,580 25,004,580 24,833,698 25,379,201 24,946,784 432,418 1.7%
Jail Services 6,206,735 6,206,735 3,489,616 3,489,616 3,750,000 3,750,000 3,814,042 (64,042) ‐1.7%
Fire 22,511,597 22,511,597 24,173,315 24,173,315 24,043,143 24,639,458 24,444,372 195,085 0.8%
Community Services Admin 416,284 416,284 434,558 434,558 448,556 454,878 452,146 2,732 0.6%
Parks 3,829,676 3,829,676 4,004,054 4,004,054 4,109,908 4,155,186 4,024,756 130,430 3.1%
Parks Planning & Natural Resources 551,423 551,423 577,934 577,934 662,852 934,005 829,250 104,755 11.2%
Recreation 4,974,002 4,974,002 4,982,229 4,982,229 5,070,152 5,120,246 4,846,970 273,276 5.3%
Human Services 1,247,294 1,247,294 1,193,871 1,193,871 1,124,509 1,275,816 1,162,330 113,485 8.9%
Neighborhoods, Resources, & Events 675,534 675,534 701,673 701,673 884,968 914,955 770,841 144,114 15.8%
Library 2,030,000 2,030,000 278,604 278,604 ‐ ‐ ‐ ‐ 0.0%
Museum 210,620 210,620 216,887 216,887 209,903 217,167 209,387 7,780 3.6%
Public Works Admin 452,538 452,538 470,051 470,051 479,503 483,035 426,312 56,723 11.7%
Street Maintenance 3,534,025 3,534,025 3,755,640 3,755,640 4,264,927 4,294,894 3,814,132 480,762 11.2%
Transportation 4,509,066 4,509,066 4,615,160 4,615,160 4,531,004 4,579,081 4,476,854 102,227 2.2%
Debt Service 4,822,566 4,822,566 9,752,337 9,752,337 8,001,433 8,073,283 8,048,508 24,775 0.3%
Non‐Departmental and Other 4,930,383 4,930,383 4,637,555 4,637,555 1,741,350 5,641,350 5,475,340 166,010 2.9%
Total Operating Expenditures 100,825,999 100,825,999 103,938,882 103,938,882 99,613,569 106,278,122 103,667,105 2,611,017 2.5%
Total Ending Fund Balance 11,057,551$ 11,057,551$ 15,575,840$ 15,575,840$ 10,751,945$ 12,735,557$ 17,454,262$ 4,718,705$ 37.1%
1Hearing Examiner is reported under City Clerk
2011 2012 2013 Variance
Summary of Sources and Uses Annual Actual YTD Actual Annual Actual YTD Actual Original Budget Adjusted Budget YTD Actual Favorable (Unfavorable)
Monthly Financial Report December 2013
Page 1 of 39
Monthly Financial Report December 2013
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through December 31, 2013. Except as
noted, year‐to‐date budgeted (adjusted) revenues and operating expenditures are generally based on the
collection/disbursement patterns for the same period of the preceding year. The table on the previous page summarizes
the general governmental fund revenues and expenditures.
Revenues
Taxes
The combined collection of property, sales/use, utility, gambling, admissions, and real estate excise taxes represents 74% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
December’s collection is $443k, making
the total year‐to‐date collection $32
million or 100.8% of the total budget. In
comparison to the previous year, the City
collected $981k or 3% less. Compared to
the budget, the City is above projections
by $244k or 1%. 2013’s monthly budgets
are based on 2010 through 2012
collections. The variance from the
monthly budget is due the timing of
collections.
Sales Tax
December 2013 sales tax receipts totalled
$1.7 million. Compared with the same
month last year, it is $61k or 4% more.
Compared to the projected current
month’s budget, it is $18k or 1% below.
The year‐to‐date collection of $20.4
million is $1.9 million or 10% more than
the prior year and is also $212k or 1%
more than budgeted. The increase is
primarily attributed to several major
projects underway in both Building
Construction and Heavy and Civil
projects, which account for $646k of the
budget variance. Another item is a 1‐
time audit correction in the
manufacturing sector for 2012 that
reduced activity in 2012 by $131k. If we remove all of these items, we are $1 million or 6% over 2012 and $434k or 2% less
than budget.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 149,112$ 221,893$ 154,945$ 5,834$ 4% (66,948)$ ‐30%
Feb 85,577 242,361 25,020 (60,557) ‐71% (217,341) ‐90%
Mar 880,380 759,716 917,901 37,521 4% 158,184 21%
Apr 10,012,008 8,585,815 9,887,324 (124,683) ‐1% 1,301,510 15%
May 6,131,450 6,914,733 5,780,361 (351,089) ‐6% (1,134,372) ‐16%
Jun 43,203 70,657 88,480 45,277 105% 17,824 25%
Jul 446,717 221,732 100,047 (346,670) ‐78% (121,685) ‐55%
Aug (51,143) 13,834 58,101 109,245 ‐214% 44,267 320%
Sep 545,753 422,377 548,071 2,319 0% 125,695 30%
Oct 9,734,384 7,525,042 10,140,892 406,508 4% 2,615,850 35%
Nov 5,123,725 6,932,969 4,341,474 (782,251) ‐15% (2,591,495) ‐37%
Dec 365,200 330,238 443,072 77,873 21% 112,835 34%
YTD Total 33,466,364$ 32,241,366$ 32,485,690$ (980,674)$ ‐3% 244,324$ 1%
Annual Total 33,466,364$ 32,241,366$
Property Tax Revenues
Year to Date through December
2013 vs. 2012 2013 vs. Budget
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 1,327,548$ 1,535,829$ 1,620,555$ 293,007$ 22% 84,726$ 6%
Feb 1,923,714 2,091,944 1,962,886 39,173 2% (129,058) ‐6%
Mar 1,303,820 1,497,931 1,536,397 232,577 18% 38,466 3%
Apr 1,370,731 1,576,194 1,509,953 139,222 10% (66,242) ‐4%
May 1,599,184 1,762,738 1,732,058 132,874 8% (30,680) ‐2%
Jun 1,482,794 1,598,730 1,552,807 70,013 5% (45,923) ‐3%
Jul 1,505,142 1,574,693 1,647,860 142,718 9% 73,166 5%
Aug 1,583,903 1,733,831 1,833,347 249,443 16% 99,516 6%
Sep 1,472,566 1,628,004 1,741,262 268,697 18% 113,259 7%
Oct 1,660,941 1,729,689 1,790,411 129,470 8% 60,722 4%
Nov 1,709,049 1,770,504 1,802,768 93,719 5% 32,264 2%
Dec 1,625,280 1,703,913 1,686,069 60,789 4% (17,844) ‐1%
YTD Total 18,564,670$ 20,204,000$ 20,416,372$ 1,851,702$ 10% 212,373$ 1%
Annual Total 18,564,670$ 20,204,000$
2013 vs. Budget2013 vs. 2012
Month
Year to Date through December
Local Retail Sales Tax Revenues
Page 2 of 39
Monthly Financial Report December 2013
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Sales Tax by Sector 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
New Construction 1,844,545$ 2,647,231$ 2,694,710$ 850,166$ 46%$ 47,480 2%
Auto Sales 3,361,196 3,668,047 3,731,241 370,045 11% 63,194 2%
General Retail 6,482,942 6,576,429 6,577,601 94,659 1% 1,173 0%
Manufacturing 1,043,859 1,296,515 1,323,363 279,504 27% 26,848 2%
Wholesale 1,169,431 1,173,619 1,174,007 4,576 0% 388 0%
Service 4,221,446 4,331,078 4,362,344 140,898 3% 31,266 1%
Other 441,252 511,082 553,106 111,855 25% 42,024 8%
YTD Total 18,564,670$ 20,204,000$ 20,416,372$ 1,851,702$ 10%212,373$ 1%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
December utility tax revenues are $1.5
million, which is $44k or 3% lower than
the same month last year and is also
behind the budget by $17k or 1%. The
year‐to‐date collection is $15.8 million,
which is $172k or 1% lower than the prior
year but is $181k or 1% higher than the
budget.
The table below breaks out Utility Tax by source.
Utility Tax by Type 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
Electrical 5,211,111$ 5,218,000$ 5,155,789$ (55,322)$ ‐1%$ (62,211)‐1%
Natural Gas 1,942,497 1,756,000 1,814,561 (127,936) ‐7% 58,561 3%
Cell 2,183,853 2,000,000 2,050,312 (133,540) ‐6% 50,312 3%
Phone 1,056,420 1,000,000 917,021 (139,399) ‐13% (82,979)‐8%
Cable 1,423,664 1,477,648 1,481,779 58,114 4% 4,131 0%
Transfer Station 330,607 300,000 397,596 66,989 20% 97,596 33%
City Utilities 3,806,281 3,849,014 3,964,989 158,708 4% 115,975 3%
YTD Total 15,954,432$ 15,600,662$ 15,782,047$ (172,386)$ ‐1%181,385$ 1%
Annual Total 15,954,432$ 15,600,662$
YTD as % of 100% 100%
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 1,469,178$ 1,422,818$ 1,277,860$ (191,318)$ ‐13% (144,958)$ ‐10%
Feb 1,512,539 1,426,084 1,462,236 (50,302) ‐3% 36,152 3%
Mar 1,438,515 1,402,697 1,193,129 (245,387) ‐17% (209,569) ‐15%
Apr 1,384,240 1,350,579 1,545,257 161,017 12% 194,677 14%
May 1,394,109 1,363,203 1,338,923 (55,185) ‐4% (24,279) ‐2%
Jun 1,108,588 1,104,507 1,189,847 81,259 7% 85,340 8%
Jul 1,340,939 1,315,082 1,259,713 (81,225) ‐6% (55,369) ‐4%
Aug 1,153,724 1,144,258 1,280,207 126,484 11% 135,950 12%
Sep 1,301,158 1,284,116 1,433,293 132,136 10% 149,177 12%
Oct 1,126,772 1,116,965 1,072,773 (53,999) ‐5% (44,192) ‐4%
Nov 1,196,932 1,168,940 1,244,671 47,739 4% 75,732 6%
Dec 1,527,740 1,501,412 1,484,137 (43,603) ‐3% (17,275) ‐1%
YTD Total 15,954,432$ 15,600,662$ 15,782,047$ (172,386)$ ‐1% 181,385$ 1%
Annual Total 15,954,432$ 15,600,662$
2013 vs. Budget2013 vs. 2012
Year to Date through December
Utility Tax Revenues
Month
Page 3 of 39
Monthly Financial Report December 2013
Other Taxes
Real Estate Excise Tax
The City collected $1.2 million in Real
Estate Excise Tax revenues (REET) for
December. This is $997k or 397% above
the same month last year and is also $1.1
million or 684% more than the current
month’s budget. The year‐to‐date
collection is $4.1 million, which is $1.3
million or 47% more than the prior year
and is also $1.5 million or 59% above the
budget. The large receipt in December is
due to 3 large transactions that netted the
City about $1 million more than
anticipated.
Gambling Tax
December’s Gambling Tax collections
totalled $151k, which is $2k or 1%
below the same month last year but is
$7k or 5% above the current month’s
budget. The year‐to‐date total of $1.3
million is $372k or 22% below the year
before and is also $280k or 18% below
budget. The decline in revenue is
mainly due to payment plans with two
(2) establishments that will be paid in
full by March 2015. The City is also
seeing a decline in overall activity.
Pull tabs overall had a 2% decrease,
bingo decreased by 8%, and card‐
rooms are seeing 35% lower in
activities when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly and
the year‐to‐date revenue collections
are $1.3 million or 104% of the
budget. This is $51k or 4% higher than
the prior year and is also $53k or 4%
above the projected year‐to‐date
budget.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 77,631$ 78,153$ 134,099$ 56,468$ 73% 55,946$ 72%
Feb 214,137 215,578 262,229 48,092 22% 46,651 22%
Mar 203,583 204,953 228,077 24,494 12% 23,124 11%
Apr 194,868 196,179 197,659 2,791 1% 1,480 1%
May 253,446 255,151 285,948 32,501 13% 30,796 12%
Jun 347,179 349,515 347,890 711 0% (1,625) 0%
Jul 177,839 179,036 263,807 85,967 48% 84,771 47%
Aug 222,933 224,433 294,056 71,123 32% 69,623 31%
Sep 173,212 174,377 254,318 81,106 47% 79,941 46%
Oct 326,027 300,429 272,776 (53,251) ‐16% (27,653) ‐9%
Nov 370,123 263,005 342,535 (27,588) ‐7% 79,530 30%
Dec 250,922 159,190 1,248,272 997,350 397% 1,089,082 684%
YTD Total 2,811,902$ 2,600,000$ 4,131,665$ 1,319,763$ 47% 1,531,665$ 59%
Annual Total 2,811,902$ 2,600,000$
Month
2013 vs. Budget2013 vs. 2012
Real Estate Excise Tax Revenues
Year to Date through December
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 175,959$ 166,470$ 133,504$ (42,455)$ ‐24% (32,965)$ ‐20%
Feb 143,837 136,080 73,730 (70,107) ‐49% (62,350) ‐46%
Mar 98,279 92,979 111,294 13,014 13% 18,315 20%
Apr 156,498 148,058 159,655 3,158 2% 11,598 8%
May 101,088 95,636 97,660 (3,428) ‐3% 2,024 2%
Jun 127,372 120,502 60,074 (67,298) ‐53% (60,428) ‐50%
Jul 161,244 152,548 89,157 (72,087) ‐45% (63,391) ‐42%
Aug 146,526 138,623 99,930 (46,596) ‐32% (38,694) ‐28%
Sep 162,540 153,774 116,204 (46,336) ‐29% (37,570) ‐24%
Oct 87,494 82,776 112,141 24,647 28% 29,365 35%
Nov 177,352 167,787 114,909 (62,443) ‐35% (52,878) ‐32%
Dec 153,019 144,767 151,327 (1,692) ‐1% 6,560 5%
YTD Total 1,691,209$ 1,600,000$ 1,319,585$ (371,624)$ ‐22% (280,415)$ ‐18%
Annual Total 1,691,209$ 1,600,000$
2013 vs. 2012 2013 vs. Budget
Gambling Tax Revenue
Month
Year to Date through December
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 300,392$ 299,872$ 314,269$ 13,877$ 5% 14,397$ 5%
Feb ‐ ‐ 200 200 100% 200 100%
Mar ‐ ‐ 892 892 100% 892 100%
Apr 299,534 299,015 311,986 12,452 4% 12,971 4%
Jul 305,065 304,536 315,694 10,630 3% 11,158 4%
Oct 309,001 308,466 321,202 12,200 4% 12,736 4%
Dec 48,195 48,111 48,484 289 1% 373 1%
YTD Total 1,262,188$ 1,260,000$ 1,312,727$ 50,540$ 4% 52,727$ 4%
An nual Total 1,262,188$ 1,260,000$
Franchise Fees Revenue
Year to Date through December
Month
2013 vs. 2012 2013 vs. Budget
Page 4 of 39
Monthly Financial Report December 2013
Admission Tax
Admission Tax returns are due
quarterly in January, April, July, and
October of each year. October 2013
collections represent activities
conducted during the 3rd quarter of
2013. The year‐to‐date collection of
$327k is $17k or 5% more than the
prior year and is also $20k or 6% more
than the budget.
Licenses and Permits
Building Permits and Development Service
Fees
Building Permits and Development Service
Fee revenues totalled $348k in December.
The year‐to‐date development fees
revenue of $4 million is $449k or 13% more
than the year before and is also $378k or
10% higher than budget. The higher than
expected fees are due to collecting more in
general building permits, electrical permits,
street excavations, and plan check fees.
Business Licenses
Business Licenses totalled $4k for December,
which is $839 or 25% above the same month
last year and is also $168 or 4% above the
current month’s budget. The year‐to‐date
Business Licenses revenue of $504k is $59k
or 13% above the prior year but is $29k or
5% lower than the budget. The variance for
July is due to correcting the percentages
distributed between the General fund and
Transportation CIP fund.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 88,676$ 106,302$ 95,381$ 6,705$ 8% (10,921)$ ‐10%
Feb 24,251 29,071 40,658 16,407 68% 11,587 40%
Mar 4,927 5,906 12,441 7,515 153% 6,535 111%
Apr 89,003 106,694 102,648 13,644 15% (4,047) ‐4%
May 2,645 3,171 33,354 30,709 1161% 30,183 952%
Jun 3,377 4,048 5,701 2,324 69% 1,653 41%
Jul 98,553 118,142 52,586 (45,967) ‐47% (65,556) ‐55%
Aug 14,550 17,442 29,210 14,661 101% 11,769 67%
Sep 3,197 3,833 4,236 1,039 32% 403 11%
Oct 99,644 119,450 109,998 10,354 10% (9,452) ‐8%
Nov 12,484 14,965 13,342 858 7% (1,623) ‐11%
Dec 3,372 4,042 4,211 839 25% 168 4%
YTD Total 444,680$ 533,067$ 503,766$ 59,086$ 13% (29,301)$ ‐5%
Annual Total 444,680$ 533,067$
Business Licenses
Month
2013 vs. 2012
Year to Date through December
2013 vs. Budget
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 73,420$ 72,699$ 82,440$ 9,020$ 12% 9,741$ 13%
Feb 934 925 ‐
Apr 80,352 79,563 70,311 (10,041) ‐12% (9,252) ‐12%
Jul 81,104 80,307 87,473 6,370 8% 7,166 9%
Aug ‐ ‐ 76 76 100% 76 100%
Oct 74,001 73,275 85,616 11,615 16% 12,342 17%
Nov ‐ ‐ 1,192 1,192 100% 1,192 100%
Dec 1,244 1,232 149 (1,095) ‐88% (1,083) ‐88%
YTD Total 311,054$ 308,000$ 327,258$ 17,138$ 5% 20,182$ 6%
Annual Total 311,054$ 308,000$
Month
2013 vs. 2012 2013 vs. Budget
Admission Tax Revenue
Year to Date through December
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 174,925$ 185,998$ 327,584$ 152,659$ 87% 141,586$ 76%
Feb 200,852 214,820 230,039 29,187 15% 15,220 7%
Mar 281,861 283,121 305,085 23,224 8% 21,964 8%
Apr 265,286 281,570 367,165 101,879 38% 85,595 30%
May 292,030 270,456 386,735 94,705 32% 116,280 43%
Jun 300,624 279,642 293,386 (7,239) ‐2% 13,743 5%
Jul 308,608 321,387 314,991 6,382 2% (6,396) ‐2%
Aug 376,862 384,971 340,270 (36,592) ‐10% (44,701) ‐12%
Sep 196,517 182,841 254,799 58,281 30% 71,958 39%
Oct 431,934 452,825 440,169 8,235 2% (12,656) ‐3%
Nov 288,899 302,483 393,258 104,359 36% 90,775 30%
Dec 433,968 463,300 348,144 (85,824) ‐20% (115,156) ‐25%
YTD Total 3,552,369$ 3,623,413$ 4,001,625$ 449,255$ 13% 378,212$ 10%
Annual Total 3,552,369$ 3,623,413$
Building Permits and Development Service Fees
Year to Date through December
2013 vs. Budget2013 vs. 2012
Month
Page 5 of 39
Monthly Financial Report December 2013
Intergovernmental
These revenue sources include
federal (direct and indirect)
grants, state grants, state shared
revenues, local grants, and
entitlements. State shared
revenues and Fire Districts’ 25
and 40 contracts compose 89% of
the total revenues in this
category. The year‐to‐date total
Intergovernmental revenue is $11.7 million or 99% of the budget.
State Shared Revenues
State Shared Revenue collections
totalled $4.7 million since the start
of the year. Compared to the prior
year, State Shared Revenues are
below by $123k or 3%. Compared
to the projected budget, the City is
collecting $494k or 12% more. The
higher than expected (but lower
than prior year) collection is due to
collecting more than anticipated
Criminal Justice Sales Tax, the low
budget of Criminal Justice’s High
Crime and the higher than expected collections for Liquor Profits. The reason for the decline in Liquor Excise Tax is also due
to the passage of Initiative 1183. Starting October 2012, the State will divert all Liquor Excise Taxes that would normally be
distributed to local governments to their State General Fund for one year. The City will not receive these excise taxes in
January 2013, April 2013 and July 2013. On the October 2013 distribution and on, local governments will start receiving
their portions of the excise taxes less a $10 million (per year) transfer from the State Liquor Excise Tax Fund to the State
General Fund.
Charges for Services
These revenue sources consist of general government, public safety, plan review and inspection, culture and recreation,
and interfund/interdepartmental sales and services. Recreation and interfund/interdepartmental sales and services
constitute 68% of the total revenue in this category. The year‐to‐date total charges for services are $7.3 million or 107% of
the budget. The following sections provide detail information for Public Safety, Recreation, and Interfund Services.
2012 2013 2013
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,924,470$ 1,932,500$ 2,091,174$ 166,704$ 9% 158,674$ 8%
Judicial Contribution 22,632 22,500 22,796 164 1% 296 1%
Crim Just ‐ High Crime 196,270 ‐ 229,636 33,366 17% 229,636 100%
Crim Just ‐ Pop 20,976 ‐ 22,656 1,680 8% 22,656 100%
Crim Just ‐ Spec Prog 78,864 90,000 84,328 5,465 7% (5,672) ‐6%
State DUI 17,397 18,000 17,116 (281) ‐2% (884) ‐5%
Liquor Profits 928,773 640,000 846,798 (81,975) ‐9% 206,798 32%
Liquor Excise Tax 342,495 220,000 63,108 (279,387) ‐82% (156,892) ‐71%
Fuel Tax 1,293,325 1,285,000 1,324,277 30,952 2% 39,277 3%
YTD Total 4,825,202$ 4,208,000$ 4,701,889$ (123,313)$ ‐3% 493,889$ 12%
Annual Total 4,825,202$ 4,208,000$
2013 vs. Budget
State Shared Revenues
2013 vs. 2012
Revenue
Year to Date through December
Intergovernmental 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
Fire District #25 1,397,433$ 1,200,000$ 1,183,558$ (213,875)$ ‐15% $ (16,442)‐1%
Fire District #40 4,758,188 4,665,056 4,543,337 (214,851) ‐5% (121,719) ‐3%
State Shared Revenue 4,825,202 4,208,000 4,701,889 (123,313) ‐3% 493,889 12%
Federal Grants 981,308 1,460,478 1,034,828 53,520 5% (425,650) ‐29%
State Grants 160,964 94,324 63,711 (97,254) ‐60% (30,613) ‐32%
Other Grants/Intgovt 156,189 97,754 39,929 (116,260) ‐74% (57,825) ‐59%
ARRA Grants 393,992 114,171 114,792 (279,201) ‐71%621 1%
Total Rev YTD 12,673,276$ 11,839,783$ 11,682,043$ (991,233)$ ‐8%(157,739)$ ‐1%
Total Rev Annual 12,673,276$ 11,839,783$
YTD %100% 100% 99%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
Page 6 of 39
Monthly Financial Report December 2013
Public Safety Services
Public Safety Services totalled $681k since the
start of the year. These services include
private security, adult probation services,
monitoring of prisoners, and
intergovernmental public safety services (non‐
grants). Compared to the prior year, the City is
collecting $195k or 40% more. Compared to
the year‐to‐date budget, the City is $261k or
62% more. The reason for the large favourable
variance with the prior year is due to a
different way of accounting for
intergovernmental services. Prior to 2013, the
City accounted for these services as general
intergovernmental. Due to the 2013
Budgeting, Accounting, and Reporting System (BARS) Restructuring Project, the State does not recognize intergovernmental
charges for services as separate from charges for services. Of the $681k receipted for Public Safety Services, $154k is for
intergovernmental.
Recreation
Recreation revenues totalled $63k for the
current month. Compared to the same month
the prior year, the City collected $2.5k or 4%
more. Compared to the projected monthly
budget, the City collected $2.5k or 4% less.
The primary reason that recreation fees are
lower is due to the new cost recovery policy
approved by council in 2012 which reduces or
eliminates those programs that do not meet
recovery objectives. This revenue reduction
translates into a savings of $273k in the
Recreation Division of the Community Services
Department.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $3.5 million. Compared
to the prior year, the revenues are over by
$153k or 5%. Compared to the projected
budget, the revenues are above by $151k or
5%. The majority of these revenues are
related to indirect cost allocations, which are
internal administrative costs. The remaining
costs consist of Development Services
division’s inspection fees, Parks Planning and
Natural Resources division’s capital investment
program reimbursements, Transportation
division’s capital investment program
reimbursements, and Maintenance division’s
street maintenance reimbursements.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 15,229$ 13,139$ 32,322$ 17,093$ 112% 19,183$ 146%
Feb 34,848 30,067 117,056 82,208 236% 86,990 289%
Mar 35,353 30,502 37,079 1,726 5% 6,577 22%
Apr 68,426 59,037 64,009 (4,418) ‐6% 4,971 8%
May 42,979 37,082 47,985 5,007 12% 10,904 29%
Jun 31,486 27,166 36,945 5,459 17% 9,779 36%
Jul 54,883 47,353 69,340 14,457 26% 21,988 46%
Aug 34,742 29,975 42,753 8,010 23% 12,777 43%
Sep 36,019 31,077 48,986 12,967 36% 17,909 58%
Oct 37,300 32,182 81,116 43,817 117% 48,934 152%
Nov 33,025 28,493 49,703 16,678 51% 21,210 74%
Dec 61,608 53,155 53,287 (8,322) ‐14% 131 0%
YTD Total 485,899$ 419,229$ 680,581$ 194,682$ 40% 261,352$ 62%
Annual Total 485,899$ 419,229$
Month
2013 vs. 2012
Year to Date through December
Public Safety Services
2013 vs. Budget
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 62,072$ 67,237$ 60,546$ (1,526)$ ‐2% (6,690)$ ‐10%
Feb 59,327 64,264 51,160 (8,167) ‐14% (13,104) ‐20%
Mar 104,775 113,492 79,491 (25,283) ‐24% (34,001) ‐30%
Apr 137,257 148,678 170,541 33,284 24% 21,863 15%
May 139,013 150,580 95,710 (43,303) ‐31% (54,870) ‐36%
Jun 149,137 161,546 150,284 1,147 1% (11,262) ‐7%
Jul 260,363 282,026 345,126 84,763 33% 63,100 22%
Aug 262,038 283,841 205,821 (56,217) ‐21% (78,020) ‐27%
Sep 107,879 116,855 123,550 15,670 15% 6,694 6%
Oct 85,973 93,126 83,685 (2,288) ‐3% (9,441) ‐10%
Nov 65,863 71,343 65,656 (207) 0% (5,687) ‐8%
Dec 60,467 65,498 63,010 2,543 4% (2,488) ‐4%
YTD Total 1,494,165$ 1,618,486$ 1,494,580$ 416$ 0% (123,906)$ ‐8%
Annual Total 1,494,165$ 1,618,486$
Recreation
Year to Date through December
2013 vs. Budget2013 vs. 2012
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 237,384$ 276,153$ 265,873$ 28,489$ 12% (10,279)$ ‐4%
Feb 234,758 276,153 292,362 57,604 25% 16,209 6%
Mar 271,071 276,153 317,998 46,927 17% 41,846 15%
Apr 253,070 276,153 288,610 35,541 14% 12,458 5%
May 291,941 276,153 299,652 7,711 3% 23,499 9%
Jun 275,112 276,153 287,569 12,457 5% 11,417 4%
Jul 217,828 276,153 282,466 64,638 30% 6,314 2%
Aug 345,690 276,153 352,945 7,255 2% 76,793 28%
Sep 273,570 276,153 274,525 955 0% (1,628) ‐1%
Oct 338,304 276,153 352,421 14,117 4% 76,269 28%
Nov 276,902 276,153 286,300 9,398 3% 10,148 4%
Dec 296,085 276,153 164,190 (131,895) ‐45% (111,962) ‐41%
YTD Total 3,311,715$ 3,313,830$ 3,464,913$ 153,197$ 5% 151,083$ 5%
Annual Total 3,311,715$ 3,313,830$
Interfund Services
Year to Date through December
2013 vs. 2012 2013 vs. Budget
Month
Page 7 of 39
Monthly Financial Report December 2013
Fines and Penalties
These revenue sources contain civil
(penalties, infractions, and parking), criminal
(traffic, non‐traffic, and costs), and non‐
court fines, forfeitures, and penalties. The
table below breaks down these fines by
type. The year‐to‐date total fines and
penalties is $2.8 million. This is $294k or
10% lower than a year ago and is also $292k
or 10% below the budget.
Year to Date through December
2012 2013 2013
Actual Budget Actual $ % $ %
Civil Penalties 9,299$ 15,500$ 9,824$ 525$ 6% (5,676)$ ‐37%
Civil Infraction Penalties 621,443 604,500 628,202 6,759 1% 23,702 4%
Civil Parking Infraction Penalties 167,920 190,000 190,997 23,077 14% 997 1%
Photo Enforcement Program 1,976,203 1,950,000 1,629,524 (346,679) ‐18% (320,476) ‐16%
Criminal Traffic Misdemeanor Fines 88,457 102,000 101,458 13,001 15% (542) ‐1%
Criminal Non‐Traffic Fines 28,462 52,000 50,417 21,955 77% (1,583) ‐3%
Criminal Costs 129,907 122,500 129,724 (183) 0% 7,224 6%
Seizure Funds ‐ Federal/State/Local1 37,941 ‐ ‐ (37,941) 0%‐ N/A
Non‐Court Fines, Forfeitures and Penalties 758 22,000 26,517 25,760 3401% 4,517 21%
YTD Total 3,060,389$ 3,058,500$ 2,766,663$ (293,726)$ ‐10% (291,837)$ ‐10%
Annual Total 3,060,389$ 3,058,500$
1Seizure Funds are categorized in Miscellaneous for 2013 and on.
Revenue
2013 vs. Budget
Fines and Penalties by Type
2013 vs. 2012
Included in the Fines and Penalties revenue budget is
$2 million from the Photo Enforcement program. The
budget was based on the prior year’s revenue. The
year‐to‐date collections from this program equates to
$1.6 million. The budget shortfall in January is due to a
change in receipting operations that resulted in a 1‐
month lag for defendant paid infractions. December’s
receipts recognized 2 month’s worth of defendant paid
infractions. The budget shortfall starting in June is due
to temporary shutting down cameras in construction
areas. These revenues should pick up after
construction is near completion.
The associated costs includes the equipment provided
by American Traffic Solutions, Inc. (ATS), dedicated 2
FTEs in the Court Services Department to process the
increased caseload and 1.1 FTEs in the Police
Department for support services. This staff time, along with a 90% pro tem budget and interpreter costs amounts to $362k
for personnel costs. The total costs for the program equates to $824k which is represented in the table.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 183,478$ 181,746$ 153,064$ (30,413)$ ‐17% (28,682)$ ‐16%
Feb 241,050 231,901 247,166 6,116 3% 15,265 7%
Mar 244,379 246,962 275,222 30,842 13% 28,259 11%
Apr 278,972 279,587 318,235 39,264 14% 38,648 14%
May 306,424 310,705 278,783 (27,641) ‐9% (31,922) ‐10%
Jun 318,091 312,586 269,334 (48,758) ‐15% (43,252) ‐14%
Jul 274,243 277,336 236,571 (37,672) ‐14% (40,765) ‐15%
Aug 168,187 171,297 171,565 3,378 2% 268 0%
Sep 179,166 176,075 154,604 (24,562) ‐14% (21,470) ‐12%
Oct 278,866 280,183 191,919 (86,947) ‐31% (88,264) ‐32%
Nov 247,607 251,568 189,412 (58,195) ‐24% (62,156) ‐25%
Dec 339,926 338,553 280,787 (59,139) ‐17% (57,766) ‐17%
YTD Total 3,060,389$ 3,058,500$ 2,766,663$ (293,726)$ ‐10% (291,837)$ ‐10%
Annual Total 3,060,389$ 3,058,500$
2013 vs. Budget2013 vs. 2012
Year to Date through December
Fines and Penalties by Month
Month
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 181,020$ 150,459$ 73,013$ 60,422$ 90,037$
Feb 145,300 158,685 72,803 60,116 98,568
Mar 142,933 152,959 72,621 60,184 92,775
Apr 176,175 217,923 69,590 60,187 157,736
May 212,766 181,018 72,987 60,361 120,657
Jun 218,587 161,729 72,958 56,521 105,208
Jul 186,121 151,808 73,264 56,398 95,411
Aug 91,365 80,932 72,679 56,345 24,586
Sep 71,743 58,676 49,784 55,930 2,747
Oct 191,799 100,760 64,222 51,130 49,629
Nov 153,910 94,351 64,881 51,346 43,005
Dec 178,282 120,223 64,962 72,494 47,730
YTD Total 1,950,000$ 1,629,524$ 823,764$ 701,435$ 928,089$
Annual Total 1,950,000$ 823,764$
1 Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through December
Month
Page 8 of 39
Monthly Financial Report December 2013
Miscellaneous
This revenue source reflects the collection of
interest and other earnings, rents, leases, and
concessions, contributions, and donations
from private sources, and other
miscellaneous revenues. Interest and other
earnings along with rents, leases, and
concessions constitute 71% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $1.6 million. Compared
to last year, the revenues are below by $2.9k.
Compared to the projected year‐to‐date
budget, the revenues are under by $235k or
13%. The table below breaks out
miscellaneous revenues by type:
2012 2013 2013
Actual Budget Actual $ % $ %
Interests and Other Earnings 342,424$ 745,300$ 423,609$ 81,185$ 24% (321,691)$ ‐43%
Rents, Leases, and Concessions 822,428 650,929 734,530 (87,898) ‐11% 83,601 13%
Contributions/Donations from Private Sources 124,082 94,665 84,320 (39,762) ‐32% (10,345) ‐11%
Other 341,988 191,000 334,918 (7,070) ‐2% 143,918 75%
Seizure Funds ‐ Federal/State/Local1 ‐ 180,693 50,639 50,639 100% (130,054) ‐72%
YTD Total 1,630,922$ 1,862,587$ 1,628,017$ (2,906)$ 0% (234,570)$ ‐13%
Annual Total 1,630,922$ 1,862,587$
1Seizure Funds are categorized in Miscellaneous for 2013 and on.
2013 vs. Budget
Miscellaneous Revenues by Type
Year to Date through December
Revenue
2013 vs. 2012
Rents, leases and concessions are higher than the prior year and budget due to higher than expected picnic shelter rentals,
facility rentals at the community center and food concession payments at Coulon Park.
Other miscellaneous revenues are higher than the prior year and budget due to higher than expected utility late payment
penalties and miscellaneous reimbursements for Fire.
Seizure funds are lower than the budget due to the timing of activity. The use of Seizure Funds is restricted to drug
enforcement only and is not available for general operating purposes.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 206,151$ 163,431$ 179,743$ (26,408)$ ‐13% 16,312$ 10%
Feb 83,823 136,065 76,397 (7,425) ‐9% (59,668) ‐44%
Mar 104,421 84,541 147,909 43,488 42% 63,368 75%
Apr 98,164 111,952 92,872 (5,291) ‐5% (19,080) ‐17%
May 145,213 112,394 118,719 (26,494) ‐18% 6,325 6%
Jun 93,832 113,925 123,441 29,609 32% 9,516 8%
Jul 112,316 95,092 128,246 15,930 14% 33,154 35%
Aug 143,389 131,691 122,652 (20,737) ‐14% (9,038) ‐7%
Sep 89,588 100,826 92,799 3,211 4% (8,027) ‐8%
Oct 91,608 75,628 82,288 (9,320) ‐10% 6,659 9%
Nov 64,705 56,874 63,945 (760) ‐1% 7,071 12%
Dec 397,713 680,168 399,005 1,292 0% (281,164) ‐41%
YTD Total 1,630,922$ 1,862,587$ 1,628,017$ (2,906)$ 0% (234,570)$ ‐13%
Annual Total 1,630,922$ 1,862,587$
Year to Date through December
Month
2013 vs. Budget2013 vs. 2012
Miscellaneous Revenues by Month
Page 9 of 39
Monthly Financial Report December 2013
EXPENSES
Overall the City has expended 98% of its budgeted (adjusted) general governmental expenditures at the end of December.
This is $2.6 million or 2.5% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for
general governmental departments.
City Attorney department is over the budget by $7k. This is mainly due to overspending on intermittent salaries and
benefits ($13k) and under spending on supplies/minor equipment ($6k).
While the majority of the $2.6 million is savings, approximately $163k (amount will change based on review) will have to be
carried forward/added to 2014 for obligations/services not yet received or been billed and new items needed:
$27.5k for archival of records and hazardous material disposal contingency – Administrative Services/Non‐Dept
$60k for New Market Tax Credit (NMTC) technical service ‐ Community and Economic Development
$24k for replacement of neighbourhood trailer grills (2) ‐ Community Services
$19k for various conferences/training (including travel/incidentals) – Council/Executive
$5k for supplies related to Heart Month grand donation – Fire
$4k for remaining photo enforcement enhancements – Police
$23k for increased costs of One Regional Card for All (ORCA) program – Public Works
Page 10 of 39
Monthly Financial Report December 2013
CASH AND INVESTMENTS –
4TH QUARTER
The current cash and
investments (C&I)
portfolio is provided in
the table to the right.
The City’s current C&I
balance is $115.2 million,
of this amount; $775k is
an interfund loan
investment (Res 4070)
from the insurance fund
(502) to the golf course
fund (404). This
interfund loan is due in
full on December 1st
2015.
Currently the majority of
the portfolio is located in
cash deposits (US Bank).
The rest is spread out
between the State
Investment Pool, various
certificates of deposits, and the interfund loan.
The existing portfolio yield is approximately .57%. The majority (.28%) is within the cash at US Bank.
Cash
61%
Local Government
Investment Pool
8%
US Federal Agency
Securities
9%
Certificates of
Deposit
21%
INTERFUND
INVESTMENT
1%
Distribution by Instrument
(shown as percent of blended Portfolio*)
Deposit Total Maturity Date APY Weighted Yield Current Allocation of
Cash and Investments
Allowed
by Policy
Current Principal
Balance
Cash US Bank ‐ Cash 70,659,013 overnight 0.45% 0.39%61%N/A 70,659,013
GOLF '14 GOLF '14 383,239 12/1/2014 2.25% 0.02%
GOLF '15 GOLF '15 391,853 12/1/2015 2.25% 0.03%
US Treasury Securities
none ‐ N/A N/A 0.00% 0% 100%‐
Local Government Investment Pool
3920 State Investment Pool 9,927,865 1/1/2014 0.13% 0.02% 9% 75% 9,927,865
US Federal Agency Securities *
313169A FNMA 5,000,000 1/0/1900 1.00% 0.14%
313169B FHLMC 2,500,000 10/24/2016 0.90% 0.07%
313169C FNMA 2,500,000 10/24/2016 1.06% 0.08%
Certificates of Deposit
113154A First Savings Bank Northwest 5,000,000 2/4/2015 0.92% 0.13%
113164A First Savings Bank Northwest 5,000,000 2/4/2016 1.02% 0.15%
112147a Columbia Bank 2,768,975 1/11/2014 0.69% 0.06%
111167a Columbia Bank 2,015,400 11/9/2016 0.99% 0.06%
212145a Fortune Bank (CDARS) 1,516,108 6/14/2014 0.70% 0.03%
212145b Fortune Bank (CDARS) 1,000,685 12/18/2014 0.65% 0.02%
112145a Fortune Bank (traditional) 252,980 12/23/2014 0.85% 0.01%0% 20%
112146a Umpqua Bank 5,209,717 5/18/2014 0.85% 0.13%
Commencement Bank (CDARS) 1,030,141 9/20/2014 0.65% 0.02%1%
212143a
Commercial Paper
none ‐ N/A N/A 0.00% 0.00% 5%‐
TOTAL CASH & INVESTMENTS 115,155,976$ 115,155,976$
By Institution
*Held in our safekeeping account at BNY Trust and Custody
Golf Interfund Loan
20%9%
20%4%
10,000,000
4,784,375
20% 1,030,141
20%2%
20%5% 5,209,717
2,769,772
10,000,000 100%9%
1% N/A 775,092
Page 11 of 39
Monthly Financial Report December 2013
ENTERPRISE FUNDS
The table below gives an analysis of all City Enterprise funds. Displayed are the year‐to‐date revenues and expenditures for
each enterprise. Included in each fund are the capital revenues and expenditures.
Airport Golf Course Solid Waste
Utility Water Utility Wastewater
Utility
Surface
Water
Utility
Metro
REVENUES:
Licenses and permits ‐ ‐ ‐ ‐ 61,477 49,619 ‐
Grants / intergovernmental 8,597,763 ‐ 100,563 355 9,316 928,589 ‐
Charges for services 136,197 1,789,463 15,777,316 16,439,413 9,323,355 8,767,121 15,184,436
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 7,759 ‐ ‐ ‐ 568 ‐ ‐
Rents, leases, and misc fees 2,411,793 353,001 82,486 144,410 ‐ ‐ ‐
Interest and other misc 7,180 79,633 9,593 527,906 811,690 321,536 5,600
TOTAL REVENUES 11,160,692 2,222,097 15,969,959 17,112,084 10,206,406 10,066,865 15,190,036
EXPENSES:
Utility billing ‐ ‐ 117,678 113,489 85,676 139,415 ‐
Utility systems ‐ ‐ 15,742,713 5,096,260 2,823,030 3,553,219 ‐
Utility maintenance ‐ ‐ 288,566 4,742,487 1,231,509 2,083,606 14,332,361
Transportation 2,155,102 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 2,022,979 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 2,155,102 2,022,979 16,148,957 9,952,236 4,140,215 5,776,240 14,332,361
AMOUNT AVAILABLE FOR DEBT SERVICE 9,005,590 199,118 (178,999) 7,159,848 6,066,191 4,290,625 857,675
DEBT SERVICE:
Principal 98,209 374,815 ‐ 1,097,325 796,483 274,840 ‐
Interest 6,995 25,846 ‐ 667,009 342,361 292,582 ‐
TOTAL DEBT SERVICE 105,204 400,661 ‐ 1,764,334 1,138,844 567,422 ‐
CAPITAL PROJECTS 9,560,249 19,110 ‐ 2,898,395 2,587,305 1,998,672 ‐
TRANSFERS IN/(OUT)(13,499) ‐ ‐ 7,526 (8,411) (228,719) ‐
CHANGE IN FUND BALANCE (673,362) (220,653) (178,999) 2,504,645 2,331,631 1,495,812 857,675
BEGINNING FUND BALANCE, Jan 1 2,342,924 539,814 1,523,881 9,846,308 3,196,734 6,014,474 1,745,887
ENDING FUND BALANCE, Dec 31 1,669,562 319,161 1,344,882 12,350,953 5,528,365 7,510,286 2,603,562
Page 12 of 39
Monthly Financial Report December 2013
INTERNAL SERVICE FUNDS
The table below gives an analysis of all City Internal Service Funds. Displayed are the year‐to‐date revenues and
expenditures for each internal service. Included in each fund are the capital revenues and expenditures.
Equipment
Rental
Information
Technology Facilities Communications Insurance Healthcare Retiree
Healthcare
REVENUES:
Technology Fee ‐ 123,357 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental 83 1,024 ‐ ‐ ‐ ‐ 32,467
Charges for services
Equipment rental m&o 2,732,401 3,053,748 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 112,409 ‐ 400,683 ‐ ‐ ‐
Communications ‐ 6,090 73,834 509,570 ‐ ‐ ‐
Facilities ‐ ‐ 4,278,735 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 140,409 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 438,836 ‐ ‐ ‐ ‐ ‐
Interest and other misc 11,100 5,543 3,050 896 54,825 19,737 18,388
Internal service fund misc:
Vehicle / equipment capital recovery 1,421,790 170,001 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,592,032 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 1,590,164 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 9,482,293 1,707,409
Other misc 6,231 12,218 12,026 ‐ 227 107,200 ‐
Interfund Loan ‐ ‐ ‐ ‐ 511,666 ‐ ‐
Capital contributions 22,930 ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 91,261 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries 25,000 ‐ ‐ ‐ 97,463 2,169 ‐
TOTAL REVENUES 4,310,796 4,063,635 4,367,645 911,149 3,846,377 9,611,399 1,758,264
EXPENSES:
Communications 485,367
Equipment rental 2,447,975
Facilities 3,522,209
Healthcare 10,576,165
Information technology 3,215,196
Print and mail 381,488
Retiree healthcare 1,032,725
Risk management
Ri sk management 1,721,618
Unemployment 45,330
Worker's compensation 1,436,159
TOTAL EXPENSES 2,447,975 3,215,196 3,522,209 866,855 3,203,107 10,576,165 1,032,725
AMOUNT AVAILABLE FOR CAPITAL 1,862,821 848,439 845,436 44,294 643,270 (964,766) 725,539
CAPITAL PROJECTS 1,981,423 577,929 303,911 ‐ ‐ ‐ ‐
TRANSFERS IN 331,189 89,130 160,551 ‐ 2,000,000 ‐ ‐
TRANSFERS (OUT)‐ ‐ (383,834) ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 212,587 359,640 318,242 44,294 2,643,270 (964,766) 725,539
BEGINNING FUND BALANCE, Jan 1 3,722,501 1,856,972 849,472 303,477 4,986,807 7,899,070 6,482,165
ENDING FUND BALANCE, Dec 31 3,935,088 2,216,612 1,167,714 347,771 7,630,077 6,934,304 7,207,704
Page 13 of 39
Monthly Financial Report December 2013
FUND BALANCE
Page 15 shows the ending fund balance as of December 2013. The City’s fund balance is a combination of current
deficit/surplus of funds which have accrued from unexpended operating budgets, unanticipated excess revenues, and from
balances accumulated from prior years.
The prior year’s balances (or beginning balance) include funds identified as being reserved for specific purposes or required
to meet the current year’s appropriations. These balances also provide financial stability to the City’s operation during
uncertain times and provide a layer of security to bondholders.
At the end of December, the City has $17.5 million reported in the combined general governmental fund balance of the
current year’s operating budget, which is approximately 16% of budgeted operating expenditures. This is an increase of
$1.9 million from the year’s beginning balance. December’s ending fund balance is over the anticipated General
Governmental Fund Balance of $12.7 million by $4.7 million or 37.1%. The reason for the surplus of fund balance is due to
overall revenues being favourable by $2.1 million and overall expenditures being favourable by $2.6 million.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services Department. For additional financial
information, please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel
free to contact us at hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.
Page 14 of 39
Monthly Financial Report December 2013
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through December 31, 2013
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
12/31/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
12/31/13
Ending
Balance
GENERAL GOVERNMENT FUNDS:15,575,839 103,437,840 105,545,527 121,121,366 106,278,122 103,667,105 17,454,262
000 General 10,575,369 74,864,505 77,801,319 88,376,688 77,134,850 75,861,635 12,515,053
001 Community Services 1,891,966 11,080,510 10,921,025 12,812,991 11,320,489 10,688,393 2,124,598
003 Street 1,585,553 8,677,257 8,372,826 9,958,379 8,873,975 8,290,986 1,667,393
004 Community Dev Block Grant (13,145) 460,832 86,317 73,172 374,577 303,005 (229,834)
005 Museum 52,369 209,903 209,997 262,366 217,167 209,387 52,979
009 Farmers Market 90,520 79,400 65,509 156,029 80,414 57,203 98,826
011 Fire Health & Wellness 55,483 25,000 29,232 84,715 25,000 29,621 55,094
031 Park Memorial 178,367 ‐ 478 178,845 178,367 178,367 478
201 Ltd GO Bonds Gen Govt Debt 829,784 1,749,305 1,753,234 2,583,018 1,749,305 1,749,302 833,717
215 Gen Govt Misc Debt Service 329,573 6,291,128 6,305,590 6,635,163 6,323,978 6,299,206 335,957
SPECIAL REVENUE FUNDS:
102 Arterial Street 168,514 643,000 624,175 792,689 600,000 600,000 192,689
108 Leased City Properties 527,677 1,181,123 1,090,184 1,617,861 1,135,845 1,067,974 549,887
110 Hotel Motel 111,256 245,000 314,657 425,913 291,000 240,307 185,606
125 1% For Art 116,142 16,000 11,429 127,571 50,000 29,800 97,771
127 Cable Communication 257,372 85,674 93,131 350,503 85,674 65,870 284,633
135 Springbrook Wetlands Bank 665,828 ‐ 1,785 667,613 ‐ ‐ 667,613
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,540,154 60,000 94,464 1,634,618 700,000 700,000 934,618
304 Fire Mitigation 797,417 25,000 98,748 896,165 250,000 250,000 646,165
305 Transportation Mi tigation 292,627 40,000 247,558 540,185 54,000 54,000 486,185
316 Municipal Facilities CIP 3,474,517 4,377,834 3,711,499 7,186,016 7,743,713 2,102,492 5,083,524
317 Transportation CIP (391,159) 33,586,759 23,827,469 23,436,310 33,146,358 20,749,006 2,687,304
318 So Lake WA Infrastructure Proj 52,073 44,874 44,913 96,986 96,947 87,974 9,012
326 Housing Opportunity 84,359 ‐ 240 84,599 75,000 ‐ 84,599
336 New Library Development 19,143,344 1,830,836 1,850,316 20,993,660 20,974,180 1,421,913 19,571,747
ENTERPRISE FUNDS:
402 Airport 331,939 1,282,820 1,361,341 1,693,280 1,467,346 1,501,814 191,466
403 Solid Waste Utility 1,523,881 15,700,852 15,969,959 17,493,840 16,177,073 16,148,957 1,344,883
404 Golf Course 291,978 2,530,619 2,221,387 2,513,365 2,689,182 2,479,920 33,445
422 Airport Capital 2,010,985 14,039,720 9,799,352 11,810,337 16,025,599 10,332,239 1,478,098
424 Golf Course Capital 247,836 50,000 50,709 298,545 156,482 12,829 285,716
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 3,722,501 4,261,224 4,641,985 8,364,486 4,295,028 4,429,397 3,935,089
502 Insurance 4,986,807 5,713,764 5,846,378 10,833,185 3,060,718 3,203,107 7,630,078
503 Information Services 1,856,972 4,188,823 4,152,765 6,009,737 5,326,336 3,793,125 2,216,612
504 Facilities 849,472 4,349,946 4,528,196 5,377,668 4,542,713 4,209,954 1,167,714
505 Communications 303,477 877,773 911,149 1,214,626 893,249 866,855 347,771
512 Insurance, Healthcare 7,899,070 9,329,364 9,611,399 17,510,469 10,904,461 10,576,165 6,934,304
522 Insurance, Leoff1 Retirees HC 6,482,165 1,735,684 1,758,263 8,240,428 1,737,782 1,032,725 7,207,703
FIDUCIARY FUNDS:
611 Firemen's Pension 4,556,003 300,000 427,661 4,983,664 240,475 193,418 4,790,246
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
12/31/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
12/31/13
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 20,803,403 57,368,442 52,582,916 73,386,319 60,491,286 45,393,155 27,993,164
405 Wa ter Utility 5,449,029 13,402,096 13,068,936 18,517,965 11,034,019 9,994,859 8,523,106
406 Waste Water Utility 1,363,629 6,758,645 6,432,844 7,796,473 5,406,116 5,218,280 2,578,193
407 Surface Water Utility 2,269,771 7,963,326 7,468,577 9,738,348 6,167,448 5,395,988 4,342,360
416 King County Metro 1,745,887 15,126,703 15,190,035 16,935,922 15,126,703 14,332,361 2,603,561
425 Water Utility Construction 4,381,380 3,743,357 4,050,631 8,432,011 8,007,000 4,620,107 3,811,904
426 Waste Wa ter Construction 1,833,105 3,300,000 3,773,563 5,606,668 4,870,000 2,656,495 2,950,173
427 Surface Water Construction 3,744,703 7,074,315 2,598,287 6,342,990 9,880,000 3,175,065 3,167,925
471 Waterworks Rate Stabilization 15,899 ‐ 43 15,942 ‐ ‐ 15,942
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 15 of 39
City of Renton
General Government Financial Position
2013 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
15,575,839
January 5,592,172 7,563,322 (1,971,150) 13,604,689
February 11,590,564 15,996,818 (4,406,254) 11,169,585
March 17,392,180 23,413,342 (6,021,162) 9,554,677
April 33,559,062 31,631,530 1,927,532 17,503,371
May 46,893,848 39,883,684 7,010,164 22,586,003
June 52,007,692 48,473,829 3,533,864 19,109,703
July 58,496,912 56,535,685 1,961,227 17,537,066
August 64,000,182 64,579,234 (579,052) 14,996,787
September 69,756,998 72,338,457 (2,581,459) 12,994,380
October 86,460,206 81,277,689 5,182,517 20,758,356
November 97,939,274 88,737,144 9,202,130 24,777,969
December 105,545,527 103,667,105 1,878,423 17,454,262
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
9,000,000
10,000,000
11,000,000
70,000,000
80,000,000
90,000,000
100,000,000
110,000,000
Change in Fund
Balance
Rev/Exp Revenues
Expenditures
Change in Fund Balance
(9,000,000)
(8,000,000)
(7,000,000)
(6,000,000)
(5,000,000)
(4,000,000)
(3,000,000)
(2,000,000)
(1,000,000)
‐
1,000,000
2,000,000
‐
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
60,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Page 16 of 39
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,345,251 5,592,172 4.62%
Feb 11,254,456 11,590,564 2.99%
Mar 16,763,671 17,392,180 3.75%
Apr 31,420,421 33,559,062 6.81%
May 45,813,664 46,893,848 2.36%
Jun 51,134,745 52,007,692 1.71%
Jul 57,389,850 58,496,912 1.93%
Aug 63,398,116 64,000,182 0.95%
Sep 68,600,594 69,756,998 1.69%
Oct 82,297,710 86,460,206 5.06%
Nov 96,190,279 97,939,274 1.82%
Dec 103,437,840 105,545,527 2.04%
Percent of budget 102.04%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$36
Millions Property Tax
Property Tax Budget Actual over (under)
Jan 221,893 154,945 ‐30.17%
Feb 464,254 179,965 ‐61.24%
Mar 1,223,970 1,097,866 ‐10.30%
Apr 9,809,785 10,985,190 11.98%
May 16,724,518 16,765,551 0.25%
Jun 16,795,175 16,854,032 0.35%
Jul 17,016,907 16,954,079 ‐0.37%
Aug 17,030,741 17,012,180 ‐0.11%
Sep 17,453,117 17,560,252 0.61%
Oct 24,978,160 27,701,144 10.90%
Nov 31,911,128 32,042,618 0.41%
Dec 32,241,366 32,485,690 0.76%
Percent of budget 100.76%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Budget
Actual
Last Year
Page 17 of 39
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,694,648 1,812,385 6.95%
Feb 4,005,840 4,006,705 0.02%
Mar 5,652,411 5,725,296 1.29%
Apr 7,384,604 7,413,785 0.40%
May 9,329,260 9,351,345 0.24%
Jun 11,095,640 11,088,148 ‐0.07%
Jul 12,841,489 12,931,683 0.70%
Aug 14,755,549 14,983,749 1.55%
Sep 16,551,075 16,931,533 2.30%
Oct 18,469,789 18,934,149 2.51%
Nov 20,434,713 20,949,122 2.52%
Dec 22,323,680 22,835,161 2.29%
Percent of budget 102.29%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Sales Tax
Budget
Actual
Last Year
$16
Millions Utility Tax
Utility Tax Budget Actual over (under)
Jan 1,422,818 1,277,860 ‐10.19%
Feb 2,848,902 2,740,096 ‐3.82%
Mar 4,251,600 3,933,225 ‐7.49%
Apr 5,602,179 5,478,482 ‐2.21%
May 6,965,382 6,817,405 ‐2.12%
Jun 8,069,889 8,007,252 ‐0.78%
Jul 9,384,971 9,266,965 ‐1.26%
Aug 10,529,229 10,547,172 0.17%
Sep 11,813,346 11,980,466 1.41%
Oct 12,930,310 13,053,238 0.95%
Nov 14,099,250 14,297,910 1.41%
Dec 15,600,662 15,782,047 1.16%
Percent of budget 101.16%
Note: Includes Natural Gas Use Tax.
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 18 of 39
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 241,251 325,005 34.72%
Feb 420,942 547,949 30.17%
Mar 636,962 747,996 17.43%
Apr 928,618 1,091,568 17.55%
May 1,122,599 1,368,619 21.92%
Jun 1,329,123 1,596,317 20.10%
Jul 1,654,250 1,891,884 14.37%
Aug 1,958,715 2,172,762 10.93%
Sep 2,120,273 2,348,691 10.77%
Oct 2,531,943 2,788,939 10.15%
Nov 2,750,132 3,077,321 11.90%
Dec 3,063,828 3,260,747 6.43%
Percent of budget 106.43%
Note: Franchise Fees
YTD Annual % Millions
Intergovernmental
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Licenses & Permits
Budget
Actual
Last Year
Intergovt'l Budget Actual over (under)
Jan 387,097 565,532 46.10%
Feb 940,149 1,466,833 56.02%
Mar 1,282,477 1,933,705 50.78%
Apr 2,252,313 2,801,258 24.37%
May 4,670,375 5,218,611 11.74%
Jun 5,368,398 5,720,394 6.56%
Jul 5,963,557 6,584,190 10.41%
Aug 7,220,869 7,051,132 ‐2.35%
Sep 7,687,808 7,575,466 ‐1.46%
Oct 8,730,874 8,682,607 ‐0.55%
Nov 11,180,893 11,078,662 ‐0.91%
Dec 11,839,783 11,682,043 ‐1.33%
Percent of budget 98.67%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
Millions
Budget
Actual
Last Year
Page 19 of 39
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 423,297 485,115 14.60%
Feb 898,060 1,051,174 17.05%
Mar 1,431,522 1,636,717 14.33%
Apr 2,054,670 2,321,588 12.99%
May 2,633,658 2,949,916 12.01%
Jun 3,208,699 3,543,866 10.45%
Jul 3,965,563 4,364,049 10.05%
Aug 4,686,178 5,084,872 8.51%
Sep 5,170,418 5,643,259 9.15%
Oct 5,764,322 6,307,022 9.41%
Nov 6,279,014 6,854,412 9.16%
Dec 6,859,566 7,333,398 6.91%
Percent of budget 106.91%
Note: Excludes FD25 & FD40 contracts
Fines & YTD Annual %
$‐
$1
$2
$3
$4
$5
$6
$7
$8
Millions Charges for Services
Budget
Actual
Last Year
Millions Fines & Forfeits
Forfeits Budget Actual over (under)
Jan 181,746 153,064 ‐15.78%
Feb 413,648 400,231 ‐3.24%
Mar 660,610 675,452 2.25%
Apr 940,197 993,688 5.69%
May 1,250,902 1,272,471 1.72%
Jun 1,563,488 1,541,804 ‐1.39%
Jul 1,840,824 1,778,375 ‐3.39%
Aug 2,012,121 1,949,941 ‐3.09%
Sep 2,188,195 2,104,545 ‐3.82%
Oct 2,468,378 2,296,464 ‐6.96%
Nov 2,719,947 2,485,876 ‐8.61%
Dec 3,058,500 2,766,663 ‐9.54%
Percent of budget 90.46%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 20 of 39
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 609,070 638,523 4.84%
Feb 963,161 934,497 ‐2.98%
Mar 1,239,788 1,230,900 ‐0.72%
Apr 1,951,594 1,963,238 0.60%
May 2,500,859 2,520,946 0.80%
Jun 2,974,287 2,903,455 ‐2.38%
Jul 3,897,103 3,837,944 ‐1.52%
Aug 4,247,808 4,187,979 ‐1.41%
Sep 4,557,833 4,509,594 ‐1.06%
Oct 5,289,676 5,507,285 4.11%
Nov 5,584,037 5,900,050 5.66%
Dec 6,313,000 7,472,234 18.36%
Percent of budget 118.36%
YTD Annual % Millions Miscellaneous
$‐
$1
$2
$3
$4
$5
$6
$7
$8
Millions Other Taxes
Budget
Actual
Last Year
Misc Budget Actual over (under)
Jan 163,431 179,743 9.98%
Feb 299,496 256,140 ‐14.48%
Mar 384,037 404,049 5.21%
Apr 495,989 496,921 0.19%
May 608,383 615,640 1.19%
Jun 722,308 739,082 2.32%
Jul 817,399 867,327 6.11%
Aug 949,090 989,980 4.31%
Sep 1,049,916 1,082,778 3.13%
Oct 1,125,545 1,165,066 3.51%
Nov 1,182,419 1,229,012 3.94%
Dec 1,862,587 1,628,017 ‐12.59%
Percent of budget 87.41%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00 Budget
Actual
Last Year
Page 21 of 39
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 5 6,974 139374.80%
Mar 294 6,974 2272.02%
Apr 473 13,343 2720.94%
May 7,729 13,343 72.64%
Jun 7,740 13,343 72.39%
Jul 7,787 20,415 162.16%
Aug 7,817 20,415 161.16%
Sep 8,612 20,415 137.05%
Oct 8,713 24,292 178.81%
Nov 48,748 24,292 ‐50.17%
Dec 274,868 299,527 8.97%
Percent of budget 108.97%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Other Financing Sources
Budget
Actual
Last Year
Page 22 of 39
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
REET Budget
YTD
Actual
Annual %
over (under)
Jan 71,786 134,099 86.80%
Feb 269,776 396,328 46.91%
Mar 458,016 624,405 36.33%
Apr 638,196 822,064 28.81%
May 872,560 1,108,012 26.98%
Jun 1,193,556 1,455,902 21.98%
Jul 1,358,006 1,719,709 26.63%
Aug 1,564,134 2,013,764 28.75%
Sep 1,724,294 2,268,082 31.54%
Oct 2,025,764 2,540,858 25.43%
Nov 2,367,976 2,883,394 21.77%
Dec 2,600,000 4,131,665 58.91%
Percent of budget 158.91%
Bldg Permits &
Devlpmt Svc YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions
Real Estate Excise Tax
Budget
Actual
Last Year
Millions Building Permits and Development Service
Fees Budget Actual over (under)
Jan 185,998 327,584 76.12%
Feb 400,818 557,624 39.12%
Mar 683,939 862,709 26.14%
Apr 965,509 1,229,874 27.38%
May 1,235,964 1,616,609 30.80%
Jun 1,515,607 1,909,994 26.02%
Jul 1,836,994 2,224,985 21.12%
Aug 2,221,965 2,565,255 15.45%
Sep 2,404,806 2,820,054 17.27%
Oct 2,857,631 3,260,223 14.09%
Nov 3,160,113 3,653,481 15.61%
Dec 3,623,413 4,001,625 10.44%
Percent of budget 110.44%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions Fees
Budget
Actual
Last Year
Page 23 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,197,119 7,563,322 5.09%
Feb 16,286,905 15,996,818 ‐1.78%
Mar 23,885,855 23,413,342 ‐1.98%
Apr 32,092,643 31,631,530 ‐1.44%
May 40,295,343 39,883,684 ‐1.02%
Jun 48,875,120 48,473,829 ‐0.82%
Jul 57,036,076 56,535,685 ‐0.88%
Aug 65,362,851 64,579,234 ‐1.20%
Sep 76,648,107 72,338,457 ‐5.62%
Oct 84,490,673 81,277,689 ‐3.80%
Nov 92,519,783 88,737,144 ‐4.09%
Dec 106,278,122 103,667,105 ‐2.46%
Percent of budget expended 97.54%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$300 000
Legislative
Legislative Budget Actual over (under)
Jan 23,231 23,354 0.53%
Feb 47,551 47,686 0.28%
Mar 71,956 72,806 1.18%
Apr 95,878 97,646 1.84%
May 120,148 121,071 0.77%
Jun 144,309 145,113 0.56%
Jul 168,859 169,210 0.21%
Aug 192,896 192,361 ‐0.28%
Sep 217,082 216,073 ‐0.46%
Oct 241,441 239,890 ‐0.64%
Nov 265,573 263,960 ‐0.61%
Dec 290,291 289,911 ‐0.13%
Percent of budget expended 99.87%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 24 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 84,700 78,944 ‐6.80%
Feb 190,135 186,330 ‐2.00%
Mar 296,151 297,118 0.33%
Apr 407,614 419,061 2.81%
May 516,918 528,321 2.21%
Jun 623,960 614,036 ‐1.59%
Jul 735,658 718,411 ‐2.34%
Aug 847,425 824,425 ‐2.71%
Sep 953,811 919,138 ‐3.64%
Oct 1,064,489 1,023,885 ‐3.81%
Nov 1,170,013 1,121,750 ‐4.13%
Dec 1,322,364 1,240,910 ‐6.16%
Percent of budget expended 93.84%
YTD Annual %
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
Millions Executive
Budget
Actual
Last Year
$2 00
Millions City Attorney
City Attorney Budget Actual over (under)
Jan 155,027 141,744 ‐8.57%
Feb 314,005 285,967 ‐8.93%
Mar 472,262 427,953 ‐9.38%
Apr 633,182 584,735 ‐7.65%
May 787,132 724,478 ‐7.96%
Jun 947,880 872,824 ‐7.92%
Jul 1,105,337 1,013,090 ‐8.35%
Aug 1,263,381 1,157,082 ‐8.41%
Sep 1,421,095 1,315,727 ‐7.41%
Oct 1,593,003 1,460,487 ‐8.32%
Nov 1,749,576 1,604,675 ‐8.28%
Dec 1,915,103 1,922,225 0.37%
Percent of budget expended 100.37%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00 Budget
Actual
Last Year
Page 25 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 161,056 152,280 ‐5.45%
Feb 321,721 310,767 ‐3.40%
Mar 485,078 468,698 ‐3.38%
Apr 650,782 643,564 ‐1.11%
May 824,039 795,263 ‐3.49%
Jun 1,016,165 978,124 ‐3.74%
Jul 1,185,948 1,141,510 ‐3.75%
Aug 1,354,731 1,302,458 ‐3.86%
Sep 1,519,505 1,468,967 ‐3.33%
Oct 1,684,389 1,633,316 ‐3.03%
Nov 1,852,716 1,793,783 ‐3.18%
Dec 2,026,149 2,003,104 ‐1.14%
Percent of budget expended 98.86%
YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
Millions Court Services
Budget
Actual
Last Year
Millions
Community & Economic
Dl Ad iCED Admin Budget Actual over (under)
Jan 87,254 85,287 ‐2.26%
Feb 174,720 170,570 ‐2.37%
Mar 262,185 256,405 ‐2.20%
Apr 351,364 344,293 ‐2.01%
May 437,349 428,857 ‐1.94%
Jun 523,334 514,481 ‐1.69%
Jul 609,406 600,318 ‐1.49%
Aug 695,571 685,933 ‐1.39%
Sep 781,609 771,885 ‐1.24%
Oct 867,019 858,042 ‐1.04%
Nov 952,634 943,428 ‐0.97%
Dec 1,040,208 1,047,860 0.74%
Percent of budget expended 100.74%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions Development Admin
Budget
Actual
Last Year
Page 26 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 267,446 272,362 1.84%
Feb 540,517 515,474 ‐4.63%
Mar 813,155 768,135 ‐5.54%
Apr 1,086,172 1,060,776 ‐2.34%
May 1,379,682 1,319,207 ‐4.38%
Jun 1,645,056 1,589,997 ‐3.35%
Jul 1,929,849 1,867,544 ‐3.23%
Aug 2,201,921 2,165,714 ‐1.64%
Sep 2,488,019 2,425,328 ‐2.52%
Oct 2,780,951 2,704,130 ‐2.76%
Nov 3,065,780 2,973,668 ‐3.00%
Dec 3,358,299 3,243,702 ‐3.41%
Percent of budget expended 96.59%
Economic YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
Millions
Economic Development
Development Budget Actual over (under)
Jan 52,738 75,717 43.57%
Feb 105,680 81,391 ‐22.98%
Mar 150,024 109,135 ‐27.26%
Apr 191,366 146,523 ‐23.43%
May 237,394 175,487 ‐26.08%
Jun 280,134 211,913 ‐24.35%
Jul 327,723 254,764 ‐22.26%
Aug 371,084 300,522 ‐19.02%
Sep 413,800 341,333 ‐17.51%
Oct 456,286 380,375 ‐16.64%
Nov 506,186 412,147 ‐18.58%
Dec 550,280 467,511 ‐15.04%
Percent of budget expended 84.96%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
Millions
Budget
Actual
Last Year
Page 27 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 118,936 112,247 ‐5.62%
Feb 265,596 237,260 ‐10.67%
Mar 381,868 350,721 ‐8.16%
Apr 509,685 480,129 ‐5.80%
May 630,402 603,248 ‐4.31%
Jun 748,996 728,944 ‐2.68%
Jul 870,176 856,640 ‐1.56%
Aug 1,024,050 993,017 ‐3.03%
Sep 1,159,558 1,133,145 ‐2.28%
Oct 1,279,389 1,256,275 ‐1.81%
Nov 1,405,692 1,382,280 ‐1.67%
Dec 1,541,592 1,510,707 ‐2.00%
Percent of budget expended 98.00%
YTD Annual % $2 40
Millions Finance
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions
Planning
Budget
Actual
Last Year
Finance Budget Actual over (under)
Jan 158,336 144,010 ‐9.05%
Feb 323,142 284,066 ‐12.09%
Mar 485,519 437,042 ‐9.98%
Apr 646,871 610,911 ‐5.56%
May 815,548 775,564 ‐4.90%
Jun 991,610 942,750 ‐4.93%
Jul 1,157,861 1,123,823 ‐2.94%
Aug 1,335,063 1,312,345 ‐1.70%
Sep 1,499,653 1,491,143 ‐0.57%
Oct 1,643,469 1,649,170 0.35%
Nov 1,786,254 1,799,155 0.72%
Dec 2,242,682 2,274,147 1.40%
Percent of budget expended 101.40%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40 Budget
Actual
Last Year
Page 28 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 72,010 61,226 ‐14.97%
Feb 144,148 123,564 ‐14.28%
Mar 223,753 202,364 ‐9.56%
Apr 361,399 277,252 ‐23.28%
May 435,793 581,575 33.45%
Jun 507,931 636,188 25.25%
Jul 710,263 692,263 ‐2.53%
Aug 788,236 765,703 ‐2.86%
Sep 863,409 830,214 ‐3.84%
Oct 937,218 894,171 ‐4.59%
Nov 1,017,649 955,952 ‐6.06%
Dec 1,101,505 1,020,822 ‐7.32%
Percent of budget expended 92.68%
Includes Hearing Examiner
Human YTD Annual % $1 00
Millions Human Resources
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions City Clerk
Budget
Actual
Last Year
Resources Budget Actual over (under)
Jan 83,400 64,230 ‐22.99%
Feb 161,123 134,784 ‐16.35%
Mar 240,261 212,385 ‐11.60%
Apr 311,770 288,203 ‐7.56%
May 382,831 357,200 ‐6.70%
Jun 469,447 439,470 ‐6.39%
Jul 552,148 510,868 ‐7.48%
Aug 635,001 583,333 ‐8.14%
Sep 713,975 658,189 ‐7.81%
Oct 797,946 733,652 ‐8.06%
Nov 885,037 815,257 ‐7.88%
Dec 977,094 904,182 ‐7.46%
Percent of budget expended 92.54%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Budget
Actual
Last Year
Page 29 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Police Budget
YTD
Actual
Annual %
over (under)
Jan 2,163,914 2,521,995 16.55%
Feb 4,407,225 4,737,466 7.49%
Mar 6,696,434 7,196,803 7.47%
Apr 9,177,538 9,460,145 3.08%
May 11,398,123 11,645,035 2.17%
Jun 13,987,211 14,265,277 1.99%
Jul 16,284,434 16,827,604 3.34%
Aug 18,715,273 19,071,306 1.90%
Sep 21,053,667 21,624,322 2.71%
Oct 23,251,239 23,852,347 2.59%
Nov 25,873,263 26,327,574 1.76%
Dec 29,129,201 28,760,825 ‐1.26%
Percent of budget expended 98.74%
Fire &
Emergency YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
Millions Police
Budget
Actual
Last Year
$27
Millions Fire & Emergency Services
Services Budget Actual over (under)
Jan 1,923,963 2,045,002 6.29%
Feb 4,616,711 4,729,656 2.45%
Mar 6,565,785 6,673,347 1.64%
Apr 8,490,774 8,636,731 1.72%
May 10,703,214 10,518,427 ‐1.73%
Jun 12,646,891 12,459,420 ‐1.48%
Jul 14,599,902 14,457,407 ‐0.98%
Aug 16,684,205 16,390,199 ‐1.76%
Sep 18,695,102 18,346,018 ‐1.87%
Oct 20,646,459 20,390,546 ‐1.24%
Nov 22,613,208 22,411,736 ‐0.89%
Dec 24,639,458 24,444,372 ‐0.79%
Percent of budget expended 99.21%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
Budget
Actual
Last Year
Page 30 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 38,945 37,025 ‐4.93%
Feb 75,568 74,364 ‐1.59%
Mar 112,770 111,667 ‐0.98%
Apr 149,649 150,854 0.81%
May 187,504 187,590 0.05%
Jun 224,486 225,313 0.37%
Jul 261,692 262,830 0.43%
Aug 298,602 299,975 0.46%
Sep 335,099 336,859 0.53%
Oct 371,183 373,747 0.69%
Nov 409,019 414,255 1.28%
Dec 454,878 452,146 ‐0.60%
Percent of budget expended 99.40%
YTD Annual % $4 50
Millions Parks
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
$0.30
$0.35
$0.40
$0.45
$0.50
Millions Community Services Admin
Budget
Actual
Last Year
Parks Budget Actual over (under)
Jan 284,166 269,811 ‐5.05%
Feb 571,975 563,088 ‐1.55%
Mar 881,374 851,150 ‐3.43%
Apr 1,213,908 1,192,965 ‐1.73%
May 1,544,851 1,515,905 ‐1.87%
Jun 1,895,562 1,862,252 ‐1.76%
Jul 2,262,010 2,236,956 ‐1.11%
Aug 2,639,487 2,631,293 ‐0.31%
Sep 3,031,679 3,002,198 ‐0.97%
Oct 3,422,118 3,373,623 ‐1.42%
Nov 3,790,522 3,703,721 ‐2.29%
Dec 4,155,186 4,024,756 ‐3.14%
Percent of budget expended 96.86%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50 Budget
Actual
Last Year
Page 31 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 58,219 42,639 ‐26.76%
Feb 117,758 88,359 ‐24.97%
Mar 193,484 142,461 ‐26.37%
Apr 264,742 196,871 ‐25.64%
May 353,686 258,947 ‐26.79%
Jun 439,691 310,633 ‐29.35%
Jul 513,977 370,751 ‐27.87%
Aug 589,503 428,676 ‐27.28%
Sep 673,988 484,402 ‐28.13%
Oct 766,574 545,724 ‐28.81%
Nov 852,923 601,585 ‐29.47%
Dec 934,005 829,250 ‐11.22%
Percent of budget expended 88.78%
YTD Annual %
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions Parks Planning and Natural Resources
Budget
Actual
Last Year
$6
Millions Recreation
Recreation Budget Actual over (under)
Jan 342,403 305,989 ‐10.63%
Feb 696,555 650,023 ‐6.68%
Mar 1,058,573 1,002,907 ‐5.26%
Apr 1,432,734 1,371,571 ‐4.27%
May 1,806,830 1,698,203 ‐6.01%
Jun 2,191,397 2,075,334 ‐5.30%
Jul 2,782,063 2,696,025 ‐3.09%
Aug 3,439,700 3,343,858 ‐2.79%
Sep 3,953,196 3,822,962 ‐3.29%
Oct 4,335,111 4,151,697 ‐4.23%
Nov 4,705,287 4,472,957 ‐4.94%
Dec 5,120,246 4,846,970 ‐5.34%
Percent of budget expended 94.66%
$‐
$1
$2
$3
$4
$5
$6
Budget
Actual
Last Year
Page 32 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 58,818 45,984 ‐21.82%
Feb 130,459 128,054 ‐1.84%
Mar 231,819 218,002 ‐5.96%
Apr 407,227 340,261 ‐16.44%
May 511,284 431,038 ‐15.69%
Jun 578,545 496,606 ‐14.16%
Jul 719,933 628,351 ‐12.72%
Aug 794,107 695,514 ‐12.42%
Sep 859,021 749,137 ‐12.79%
Oct 1,023,887 883,276 ‐13.73%
Nov 1,099,721 962,149 ‐12.51%
Dec 1,275,816 1,162,330 ‐8.90%
Percent of budget expended 91.10%
Neighborhoods
, Resources, YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions Human Services
Budget
Actual
Last Year
$1 00
Millions Neighborhoods, Resources, and Events
and Events Budget Actual over (under)
Jan 55,854 56,917 1.90%
Feb 109,166 108,774 ‐0.36%
Mar 172,916 171,351 ‐0.91%
Apr 236,903 231,744 ‐2.18%
May 298,441 288,076 ‐3.47%
Jun 378,699 362,006 ‐4.41%
Jul 470,110 447,998 ‐4.70%
Aug 555,842 518,531 ‐6.71%
Sep 632,165 582,563 ‐7.85%
Oct 703,188 638,898 ‐9.14%
Nov 803,370 703,994 ‐12.37%
Dec 914,955 770,841 ‐15.75%
Percent of budget expended 84.25%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Budget
Actual
Last Year
Page 33 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Library Fund Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb ‐ ‐ N/A
Mar ‐ ‐ N/A
Apr ‐ ‐ N/A
May ‐ ‐ N/A
Jun ‐ ‐ N/A
Jul ‐ ‐ N/A
Aug ‐ ‐ N/A
Sep ‐ ‐ N/A
Oct ‐ ‐ N/A
Nov ‐ ‐ N/A
Dec ‐ ‐ N/A
Percent of budget expended N/A
YTD Annual %
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
$0.30
Millions Library Fund
Budget
Actual
Last Year
$240 000
Museum Fund
Museum Fund Budget Actual over (under)
Jan 17,748 16,898 ‐4.79%
Feb 35,749 34,090 ‐4.64%
Mar 53,695 51,213 ‐4.62%
Apr 71,829 69,807 ‐2.81%
May 89,877 87,136 ‐3.05%
Jun 108,087 104,728 ‐3.11%
Jul 126,103 122,060 ‐3.21%
Aug 144,243 139,638 ‐3.19%
Sep 162,616 157,141 ‐3.37%
Oct 180,847 174,718 ‐3.39%
Nov 199,167 192,315 ‐3.44%
Dec 217,167 209,387 ‐3.58%
Percent of budget expended 96.42%
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
$240,000
Budget
Actual
Last Year
Page 34 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 40,394 39,971 ‐1.05%
Feb 80,618 79,912 ‐0.88%
Mar 120,971 119,866 ‐0.91%
Apr 161,356 163,297 1.20%
May 201,472 202,081 0.30%
Jun 241,508 237,314 ‐1.74%
Jul 281,724 269,323 ‐4.40%
Aug 322,247 301,882 ‐6.32%
Sep 363,226 333,688 ‐8.13%
Oct 402,909 364,742 ‐9.47%
Nov 442,662 395,530 ‐10.65%
Dec 483,035 426,312 ‐11.74%
Percent of budget expended 88.26%
Street YTD Annual %
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
$500,000
Public Works Admin
Budget
Actual
Last Year
$4 50
Millions Street Maintenance
Maintenance Budget Actual over (under)
Jan 333,344 302,270 ‐9.32%
Feb 713,983 641,518 ‐10.15%
Mar 1,077,703 937,528 ‐13.01%
Apr 1,405,768 1,294,196 ‐7.94%
May 1,756,371 1,600,743 ‐8.86%
Jun 2,128,477 1,924,036 ‐9.61%
Jul 2,485,951 2,229,390 ‐10.32%
Aug 2,826,956 2,532,782 ‐10.41%
Sep 3,174,309 2,856,379 ‐10.02%
Oct 3,531,791 3,185,461 ‐9.81%
Nov 3,898,668 3,497,441 ‐10.29%
Dec 4,294,894 3,814,132 ‐11.19%
Percent of budget expended 88.81%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Budget
Actual
Last Year
Page 35 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 299,590 311,908 4.11%
Feb 677,729 670,659 ‐1.04%
Mar 1,055,244 1,074,529 1.83%
Apr 1,434,200 1,512,690 5.47%
May 1,803,617 1,819,302 0.87%
Jun 2,165,731 2,113,464 ‐2.41%
Jul 2,562,459 2,490,033 ‐2.83%
Aug 2,933,871 2,933,793 0.00%
Sep 3,312,264 3,219,909 ‐2.79%
Oct 3,700,291 3,582,655 ‐3.18%
Nov 4,085,694 3,894,267 ‐4.69%
Dec 4,579,081 4,476,854 ‐2.23%
Percent of budget expended 97.77%
YTD Annual % $10
Millions Debt Service
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
$4.5
$5.0
Millions Transportation
Budget
Actual
Last Year
Debt Service Budget Actual over (under)
Jan 1,494 ‐ 0.00%
Feb 164,058 250,317 52.58%
Mar 208,045 250,317 20.32%
Apr 400,183 835,676 108.82%
May 404,846 835,676 106.42%
Jun 1,036,094 1,776,589 71.47%
Jul 1,036,094 1,808,239 74.52%
Aug 1,158,244 2,058,556 77.73%
Sep 4,495,757 2,058,808 ‐54.21%
Oct 4,686,987 3,562,890 ‐23.98%
Nov 4,738,224 3,562,890 ‐24.81%
Dec 8,073,283 8,048,508 ‐0.31%
Percent of budget expended 99.69%
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
Budget
Actual
Last Year
Page 36 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 314,132 355,512 13.17%
Feb 1,301,016 862,677 ‐33.69%
Mar 1,574,828 1,009,438 ‐35.90%
Apr 1,999,750 1,221,630 ‐38.91%
May 2,667,993 2,385,254 ‐10.60%
Jun 2,953,917 2,587,016 ‐12.42%
Jul 3,296,397 2,740,276 ‐16.87%
Aug 3,551,212 2,950,337 ‐16.92%
Sep 3,874,503 3,192,930 ‐17.59%
Oct 4,122,489 3,363,972 ‐18.40%
Nov 4,350,946 3,530,675 ‐18.85%
Dec 5,641,350 5,475,340 ‐2.94%
Percent of budget expended 97.06%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
Millions Non‐Departmental Other City Services
Budget
Actual
Last Year
Page 37 of 39
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2013 Budget Year
Utilities Budget Revenue Expense
Jan 3,822,102 5,451,016 3,091,235
Feb 8,574,226 10,484,839 7,162,971
Mar 13,024,597 16,704,949 12,742,494
Apr 17,938,249 21,897,618 17,525,965
May 22,525,197 27,540,401 22,717,408
Jun 29,100,939 33,144,751 28,759,364
Jul 34,997,102 39,459,369 34,603,156
Aug 40,172,098 46,050,162 39,527,809
Sep 45,175,109 51,921,474 45,278,284
Oct 51,050,583 58,226,205 49,431,907
Nov 56,005,354 63,659,500 53,993,089
Dec 76,668,359 68,552,832 61,542,111
Percent of budget expended 76.76%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
Millions Utilities
Budget
Revenue
Expense
$18 00
Millions Airport
Airport Budget Revenue Expense
Jan 872,898 197,380 132,655
Feb 1,945,215 816,583 272,568
Mar 2,864,994 1,033,561 551,940
Apr 3,990,840 1,326,892 679,773
May 5,462,522 1,542,344 1,344,469
Jun 7,450,945 2,240,528 2,131,340
Jul 8,369,150 3,029,040 3,486,489
Aug 9,719,255 4,424,167 7,184,207
Sep 10,632,212 7,702,430 7,576,205
Oct 12,569,206 10,060,354 11,110,481
Nov 13,492,133 10,894,495 11,295,008
Dec 17,492,945 11,160,693 11,834,053
Percent of budget expended 67.65%
Note: Operations and Capital
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
$18.00
Budget
Revenue
Expense
Page 38 of 39
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2013 Budget Year
Golf Course Budget Revenue Expense
Jan 149,676 59,391 129,801
Feb 306,469 161,197 254,957
Mar 634,821 291,654 404,017
Apr 810,471 505,367 579,467
May 1,036,409 747,089 721,090
Jun 1,224,604 1,010,936 914,581
Jul 1,439,471 1,404,992 1,099,310
Aug 1,635,353 1,694,229 1,422,736
Sep 1,825,455 1,982,981 1,659,746
Oct 2,015,355 2,121,991 1,810,203
Nov 2,187,756 2,202,856 1,950,512
Dec 2,845,664 2,272,097 2,492,750
Percent of budget expended 87.60%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
Millions Golf Course
Budget
Revenue
Expense
Page 39 of 39