HomeMy WebLinkAbout201411, November.pdf ADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: January 7, 2015
TO: Ed Prince, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: November 2014 Financial Status Report
At the end of November, general governmental revenues show $4.4 million or 4.4% over
budget. Revenues sources that are higher than expected are: sales tax ($1.2 million); sales tax
annexation credit ($278k); state shared revenue ($448k); real estate excise tax ($1.2 million);
building permits & development service fees ($751k); interest and other earnings ($413k), and
other miscellaneous ($183k). On the down side, the revenue sources that are underperforming
the year to date budget is fines/penalties ($310k below).
General government expenditures showed a favorable variance of $2.2 million or 2.3%. See
page 9 of report for further expenditure over‐spent explanations.
The attached report provides more detailed discussion of each revenue source and our updated
projections for the year. Please do not hesitate to contact me at x6952 should you have any
questions or any suggestions about the report.
This page is intentionally left blank
General Governmental Funds
$%
Beginning Fund Balance 11,057,551$ 11,057,551$ 15,575,840$ 15,575,840$ 17,454,261$ 17,454,261$ 17,454,261$ ‐ 0.0%
OPERATING REVENUES
Property Tax 33,466,364 33,101,164 32,485,690 32,042,618 35,240,495 34,808,607 34,891,805 83,198 0.2%
Sales Tax 18,564,670 16,939,390 20,416,372 18,730,304 20,196,000 18,495,773 19,670,488 1,174,715 6.4%
Sales Tax ‐ Annexation Credit 2,208,492 2,015,685 2,418,789 2,218,819 2,236,262 2,046,441 2,324,445 278,004 13.6%
Criminal Justice Sales Tax 1,924,470 1,759,137 2,091,174 1,911,568 2,000,000 1,828,203 2,073,416 245,213 13.4%
Natural Gas Use Tax 272,530 271,414 263,660 242,545 300,000 287,562 254,617 (32,945) ‐11.5%
Admission Tax 311,054 309,809 327,258 327,109 308,000 307,328 310,311 2,983 1.0%
Franchise Fees 1,262,188 1,213,993 1,312,727 1,264,244 1,260,000 1,212,692 1,292,767 80,075 6.6%
Electricity Tax 5,211,111 4,750,540 5,155,789 4,721,058 5,409,000 4,941,870 4,690,047 (251,822) ‐5.1%
Natural Gas Utility Tax 1,669,967 1,504,821 1,550,900 1,382,487 1,500,520 1,345,123 1,389,780 44,657 3.3%
Garbage/Solid Waste 330,607 295,244 397,596 369,785 300,000 273,974 522,678 248,704 90.8%
TV Cable 1,423,664 1,297,488 1,481,779 1,352,005 1,529,365 1,394,639 1,385,576 (9,063) ‐0.6%
Telephone 1,056,420 868,430 917,021 813,888 952,500 811,987 868,936 56,949 7.0%
Cellular Phone 2,183,853 1,953,175 2,050,312 1,780,338 2,077,000 1,831,413 1,669,157 (162,257) ‐8.9%
City Utilities 3,806,281 3,485,580 3,964,989 3,635,803 3,791,465 3,474,397 3,639,725 165,328 4.8%
Utility Tax Audit ‐ ‐ ‐ ‐ 400,000 400,000 460,513 60,513 15.1%
Leasehold Excise Tax 158,849 120,295 164,637 124,288 145,000 109,632 130,132 20,499 18.7%
Gambling Excise Tax 1,691,209 1,538,190 1,319,585 1,168,258 1,600,000 1,438,264 1,501,414 63,151 4.4%
Real Estate Excise Tax 2,811,902 2,560,980 4,131,665 2,883,394 2,900,000 3,101,699 4,256,583 1,154,884 37.2%
Less: CIP REET (943,792) (737,047) (700,000) (554,513) (550,000) (807,272) (807,272) ‐ 0.0%
EMS Levy 885,781 442,891 916,361 687,271 900,000 916,361 916,361 ‐ 0.0%
Business License Fees 444,680 441,308 503,766 499,555 533,067 528,805 511,993 (16,812) ‐3.2%
Animal Licenses and Spec Events Permits 91,835 87,803 99,411 93,844 90,000 85,183 92,413 7,230 8.5%
Building Permits & Development Svc Fees 3,552,369 3,118,401 4,001,625 3,653,481 3,705,701 3,313,782 4,064,867 751,084 22.7%
Intergovt'l (Grants, State Shared, etc) 4,593,185 4,192,210 3,863,974 3,518,583 4,216,989 3,820,887 4,016,500 195,612 5.1%
Fire District 25 and 40 Contracts 6,155,621 6,002,346 5,726,895 5,648,511 5,877,463 5,957,394 5,957,394 ‐ 0.0%
Public Safety 485,899 424,291 680,581 627,295 774,535 698,245 780,705 82,459 11.8%
Culture and Recreation 1,494,165 1,433,697 1,494,580 1,431,570 1,525,863 1,462,823 1,455,994 (6,829) ‐0.5%
Interfund/Interdept‐Services 3,311,715 3,015,630 3,464,913 3,300,723 3,332,794 3,055,061 3,006,896 (48,165) ‐1.6%
Fines and Penalties 1,046,246 893,172 1,137,140 976,576 1,108,500 949,497 904,847 (44,650) ‐4.7%
Photo Enforcement 1,976,203 1,795,525 1,629,524 1,509,300 1,950,000 1,787,271 1,522,009 (265,261) ‐14.8%
Seizure Funds ‐ Federal/State/Local 37,941 31,767 50,639 40,876 180,693 145,857 59,593 (86,263) ‐59.1%
Interests and Other Earnings 342,424 91,439 423,609 98,597 770,300 191,094 603,712 412,617 215.9%
Rents, Leases, and Concessions 822,428 748,979 734,530 706,234 756,464 707,030 684,092 (22,938) ‐3.2%
Contributions and Donations 124,082 120,735 84,320 80,715 96,100 92,894 105,287 12,393 13.3%
Other Miscellaneous 564,571 476,459 684,187 627,855 646,630 586,312 769,307 182,996 31.2%
Other Financing Sources (Transfer‐In, etc) 5,118,188 907,701 299,527 24,292 ‐ ‐ 47,257 47,257 100.0%
Total Operating Revenues 108,457,170 97,472,642 105,545,527 97,939,274 108,060,706 101,600,829 106,024,345 4,423,517 4.4%
OPERATING EXPENDITURES
Council 278,768 254,552 289,911 263,960 309,907 282,568 283,891 (1,323) ‐0.5%
Executive 1,377,109 1,231,423 1,240,910 1,121,750 1,359,996 1,222,415 1,190,964 31,451 2.6%
City Attorney 1,706,320 1,563,092 1,922,225 1,604,675 1,863,395 1,626,768 1,666,481 (39,713) ‐2.4%
Court Services 2,074,980 1,901,324 2,003,104 1,793,783 2,094,010 1,897,359 1,808,423 88,936 4.7%
Community and Eco Dvlpmnt Admin 942,071 861,611 1,047,860 943,428 1,012,142 918,100 924,619 (6,519) ‐0.7%
Development Services 3,103,568 2,823,550 3,243,702 2,973,668 3,040,435 2,776,952 2,419,251 357,701 12.9%
Economic Development 529,043 490,160 467,511 412,147 644,063 583,152 577,062 6,089 1.0%
Planning 1,482,233 1,347,651 1,510,707 1,382,280 2,261,206 2,062,499 1,876,321 186,178 9.0%
Finance 2,221,882 1,768,328 2,274,147 1,799,155 2,644,758 2,098,547 2,124,461 (25,915) ‐1.2%
City Clerk 997,434 920,050 1,020,822 955,952 1,125,927 1,046,567 912,188 134,380 12.8%
Human Resources 937,412 850,165 904,182 815,257 1,002,994 907,045 820,519 86,526 9.5%
Police 25,004,580 22,821,018 24,946,784 22,831,367 26,116,637 23,868,954 23,764,096 104,858 0.4%
Jail Services 3,489,616 3,196,779 3,814,042 3,496,206 4,500,000 3,447,083 3,447,083 ‐ 0.0%
Fire 24,173,315 22,184,782 24,444,372 22,411,736 25,219,873 23,133,937 22,967,966 165,971 0.7%
Community Services Admin 434,558 388,455 452,146 414,255 493,982 447,189 427,611 19,577 4.4%
Parks 4,004,054 3,632,323 4,024,756 3,703,721 4,311,514 3,939,495 3,736,620 202,875 5.1%
Parks Planning & Natural Resources 577,934 520,618 829,250 601,585 880,373 702,081 652,989 49,092 7.0%
Recreation 4,982,229 4,567,758 4,846,970 4,472,957 5,111,272 4,701,254 4,413,265 287,988 6.1%
Human Services 1,193,871 1,019,454 1,162,330 962,149 1,250,790 1,051,935 984,040 67,894 6.5%
Neighborhoods, Resources, & Events 701,673 633,941 770,841 703,994 979,716 890,176 754,887 135,289 15.2%
Library 278,604 276,106 ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
Museum 216,887 199,085 209,387 192,315 226,683 208,138 195,746 12,392 6.0%
Public Works Admin 470,051 430,641 426,312 395,530 456,340 420,605 355,520 65,085 15.5%
Street Maintenance 3,755,640 3,368,565 3,814,132 3,497,441 4,595,011 4,167,811 4,113,703 54,108 1.3%
Transportation 4,615,160 4,086,739 4,476,854 3,894,267 4,539,752 3,985,013 3,737,728 247,284 6.2%
Debt Service 9,752,337 2,747,599 8,048,508 3,562,890 8,400,863 3,858,787 3,858,787 ‐ 0.0%
Non‐Departmental and Other 4,637,555 2,705,438 5,475,340 3,530,675 7,821,844 7,699,087 7,699,087 ‐ 0.0%
Total Operating Expenditures 103,938,882 86,791,207 103,667,105 88,737,144 112,263,485 97,943,517 95,713,308 2,230,209 2.3%
Total Ending Fund Balance 15,575,840$ 21,738,986$ 17,454,262$ 24,777,970$ 13,251,482$ 21,111,573$ 27,765,299$ 6,653,726$ 31.5%
Favorable (Unfavorable)
2012 2013 2014 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report November 2014
Page 1 of 36
Monthly Financial Report November 2014
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through November 30, 2014. 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 two years. 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
November’s collection is $4.1
million, making the total year‐to‐
date collection $34.9 million or
99% of the total budget. In
comparison to the previous year,
the City collected $2.8 million or
9% more. Compared to the
budget, the City is above
projections by $83k. The variance
from the monthly budget is due to
the timing of collections. The City
is projecting property tax to meet
the budget at year‐end.
Sales Tax
November 2014 sales tax receipts
totalled $2 million. Compared
with the same month last year, it
is $150k or 8% more. Compared
to the projected current month’s
budget, it is $212k or 12% above.
The year‐to‐date collection of
$19.7 million is $940k or 5% more
than the prior year and is also
$1.2 million or 6% more than
budgeted. As you can see in the
table on the next page, 54% this
entire amount is attributed to a
large transportation
manufacturer, which changed its
reporting method in late
2013/early 2014. 2014’s monthly budgets are generally based on 2006 through 2013 collections. The City is projecting sales tax
to meet the budget at year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 154,945$ 162,468$ (101,807)$ (256,752)$ ‐166% (264,275)$ ‐163%
Feb 25,020 59,096 176,551 151,531 606% 117,455 199%
Mar 917,901 960,884 1,626,283 708,382 77% 665,398 69%
Apr 9,887,324 10,632,911 5,808,865 (4,078,459) ‐41% (4,824,046) ‐45%
May 5,780,361 6,364,899 10,692,069 4,911,708 85% 4,327,171 68%
Jun 88,480 70,363 (244,519) (332,999) ‐376% (314,882) ‐448%
Jul 100,047 292,155 352,287 252,240 252% 60,132 21%
Aug 58,101 3,718 178,936 120,835 208% 175,218 4713%
Sep 548,071 584,469 574,579 26,507 5% (9,890) ‐2%
Oct 10,140,892 10,620,057 11,777,175 1,636,283 16% 1,157,118 11%
Nov 4,341,474 5,057,587 4,051,387 (290,087) ‐7% (1,006,200) ‐20%
Dec 443,072 431,888
YTD Total 32,042,618$ 34,808,607$ 34,891,805$ 2,849,188$ 9% 83,198$ 0%
Annual Total 32,485,690$ 35,240,495$
Property Tax Revenues
Year to Date through November
2014 vs. 2013 2014 vs. Budget
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 1,620,555$ 1,607,453$ 1,607,045$ (13,510)$ ‐1% (408)$ 0%
Feb 1,962,886 2,047,494 2,079,673 116,787 6% 32,179 2%
Mar 1,536,397 1,523,208 1,562,210 25,814 2% 39,002 3%
Apr 1,509,953 1,548,879 1,558,271 48,318 3% 9,393 1%
May 1,732,058 1,762,699 1,759,697 27,639 2% (3,002) 0%
Jun 1,552,807 1,584,050 1,669,870 117,064 8% 85,821 5%
Jul 1,647,860 1,599,650 1,731,929 84,069 5% 132,279 8%
Aug 1,833,347 1,718,742 2,030,161 196,814 11% 311,419 18%
Sep 1,741,262 1,633,772 1,849,720 108,457 6% 215,947 13%
Oct 1,790,411 1,728,992 1,869,025 78,614 4% 140,033 8%
Nov 1,802,768 1,740,835 1,952,887 150,118 8% 212,052 12%
Dec 1,686,069 1,700,227 ‐
YTD Total 18,730,304$ 18,495,773$ 19,670,488$ 940,184$ 5% 1,174,715$ 6%
Annual Total 20,416,372$ 20,196,000$
2014 vs. Budget2014 vs. 2013
Month
Year to Date through November
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report November 2014
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
November utility tax revenues are
$1.2 million, which is $74k or 6%
lower than the same month last
year and is also behind the budget
by $53k or 4%. The year‐to‐date
collection is $14.9 million, which
is $583k or 4% higher than the
prior year and is also $120k or 1%
higher than the budget. The City
is projecting utility tax revenues
to be very close to the budget at
year‐end.
The table below breaks out Utility Tax by source. The variance for Garbage/Solid Waste (not City Utilities) is due to a one‐
time correction (under reporting during September 2013 through December 2013) receipted in February and higher than
expected revenue. The variance for Cellular utilities is due to lower activity and timing of when payments are recorded.
Utility Tax Audit revenues are reported as gross receipts and therefore do not include the audit related expenses.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 1,277,860$ 1,372,593$ 1,373,119$ 95,259$ 7% 526$ 0%
Feb 1,462,236 1,490,351 1,524,563 62,327 4% 34,213 2%
Mar 1,193,129 1,310,634 1,631,438 438,309 37% 320,804 24%
Apr 1,545,257 1,463,692 1,218,999 (326,258) ‐21% (244,693) ‐17%
May 1,338,923 1,362,789 1,380,317 41,394 3% 17,529 1%
Jun 1,189,847 1,151,072 1,376,544 186,698 16% 225,472 20%
Jul 1,259,713 1,698,235 1,526,628 266,915 21% (171,607) ‐10%
Aug 1,280,207 1,218,858 1,270,116 (10,091) ‐1% 51,259 4%
Sep 1,433,293 1,366,340 1,206,313 (226,980) ‐16% (160,027) ‐12%
Oct 1,072,773 1,103,445 1,202,725 129,952 12% 99,280 9%
Nov 1,244,671 1,222,957 1,170,266 (74,405) ‐6% (52,691) ‐4%
Dec 1,484,137 1,498,886
YTD Total 14,297,910$ 14,760,964$ 14,881,028$ 583,119$ 4% 120,064$ 1%
Annual Total 15,782,047$ 16,259,850$
2014 vs. Budget2014 vs. 2013
Year to Date through November
Utility Tax Revenues
Month
Sales Tax by Sector 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
New Construction 2,516,097$ 1,909,454$ 2,090,362$ (425,735)$ ‐17% $ 180,908 9%
Auto Sales 3,460,810 3,612,764 3,769,955 309,145 9% 157,191 4%
General Retail 6,058,388 6,143,344 6,169,128 110,741 2% 25,784 0%
Manufacturing 1,152,420 1,195,891 1,828,938 676,518 59% 633,047 53%
Wholesale 1,032,149 1,077,530 1,062,383 30,233 3% (15,147)‐1%
Service 4,033,126 4,059,410 4,201,906 168,780 4% 142,495 4%
Other 477,313 497,379 547,815 70,503 15% 50,437 10%
YTD Total 18,730,304$ 18,495,773$ 19,670,488$ 940,184$ 5%1,174,715$ 6%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility Tax by Type 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
Electrical 4,721,058$ 4,941,870$ 4,690,047$ (31,011)$ ‐1% $ (251,822)‐5%
Natural Gas 1,625,032 1,632,685 1,644,397 19,365 1% 11,712 1%
Cell 1,780,338 1,831,413 1,669,157 (111,181) ‐6% (162,257)‐9%
Phone 813,888 811,987 868,936 55,048 7% 56,949 7%
Cable 1,352,005 1,394,639 1,385,576 33,571 2% (9,063)‐1%
Garbage/Solid Waste 369,785 273,974 522,678 152,893 41% 248,704 91%
City Utilities 3,635,803 3,474,397 3,639,725 3,921 0% 165,328 5%
Utility Tax Audit ‐ 400,000 460,513 460,513 100% 60,513 15%
YTD Total 14,297,910$ 14,760,964$ 14,881,028$ 583,119$ 4%120,064$ 1%
Annual Total 15,782,047$ 16,259,850$
YTD as % of 91% 91%
Page 3 of 36
Monthly Financial Report November 2014
Other Taxes
Real Estate Excise Tax
The City collected $224k in Real
Estate Excise Tax revenues (REET)
for November. This is $119k or
35% less than the same month
last year but is $40k or 22% more
than the current month’s budget.
The year‐to‐date collection is $4.3
million, which is $1.4 million or
48% more than the prior year and
is also $1.2 million or 37% above
the budget. The higher than
expected variance is due to 13
large transactions in February,
March, April, June, July, October
and November which accounts for
$1.4 million of the total REET
collected. The monthly budget is based on a normalized annual distribution (2012 only). The City has met the current budget,
but we are adjusting the budget in the upcoming year‐end budget amendment.
Gambling Tax
November’s Gambling Tax
collections totalled $157k, which
is $42k or 37% above the same
month last year and is also above
the current month’s budget by
$1.6k or 1%. The year‐to‐date
total of $1.5 million is $333k or
29% above the year and is also
$63k or 4% above budget. Second
half of 2014 has improved due to
new ownerships of 2
establishments.
Pull tabs overall had a 15%
increase, bingo had no change,
and card‐rooms are seeing 30%
higher in activities when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. Due to the timing of
when the payment was received,
the City recorded January’s
payment in February ($323k). The
year‐to‐date total of $1.3 million
is $29k or 2% higher than the
prior year and is also $81k or 7%
above the projected year‐to‐date
budget.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 134,099$ 109,119$ 162,143$ 28,044$ 21% 53,024$ 49%
Feb 262,229 301,209 448,452 186,223 71% 147,243 49%
Mar 228,077 248,682 227,629 (448) 0% (21,053) ‐8%
Apr 197,659 369,133 909,120 711,461 360% 539,987 146%
May 285,948 305,678 262,746 (23,202) ‐8% (42,932) ‐14%
Jun 347,890 468,877 624,342 276,452 79% 155,465 33%
Jul 263,807 245,943 350,214 86,407 33% 104,270 42%
Aug 294,056 290,788 346,677 52,622 18% 55,889 19%
Sep 254,318 225,212 265,534 11,216 4% 40,322 18%
Oct 272,776 352,993 436,050 163,274 60% 83,056 24%
Nov 342,535 184,063 223,675 (118,860) ‐35% 39,612 22%
Dec 1,248,272 (201,699)
YTD Total 2,883,394$ 3,101,699$ 4,256,583$ 1,373,189$ 48% 1,154,884$ 37%
Annual Total 4,131,665$ 2,900,000$
Month
2014 vs. Budget2014 vs. 2013
Real Estate Excise Tax Revenues
Year to Date through November
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 133,504$ 164,456$ 131,776$ (1,728)$ ‐1% (32,679)$ ‐20%
Feb 73,730 115,620 133,109 59,379 81% 17,489 15%
Mar 111,294 111,371 153,695 42,401 38% 42,324 38%
Apr 159,655 168,010 103,980 (55,675) ‐35% (64,030) ‐38%
May 97,660 105,619 138,319 40,659 42% 32,700 31%
Jun 60,074 99,613 135,701 75,627 126% 36,088 36%
Jul 89,157 133,068 122,588 33,432 37% (10,480) ‐8%
Aug 99,930 130,972 130,381 30,452 30% (590) 0%
Sep 116,204 148,130 139,444 23,241 20% (8,686) ‐6%
Oct 112,141 106,090 155,499 43,358 39% 49,408 47%
Nov 114,909 155,314 156,921 42,012 37% 1,607 1%
Dec 151,327 161,736 ‐
YTD Total 1,168,258$ 1,438,264$ 1,501,414$ 333,156$ 29% 63,151$ 4%
Annual Total 1,319,585$ 1,600,000$
2014 vs. 2013 2014 vs. Budget
Gambling Tax Revenue
Month
Year to Date through November
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 314,269$ 300,776$ ‐$ (314,269)$ ‐100% (300,776)$ ‐100%
Feb 200 98 323,121 322,921 161461% 323,023 330063%
Mar 892 437 ‐
Apr 311,986 299,239 323,544 11,558 4% 24,305 8%
Jul 315,694 303,760 324,273 8,579 3% 20,513 7%
Oct 321,202 308,381 321,828 626 0% 13,446 4%
Dec 48,484 47,308 ‐
YTD Total 1,264,244$ 1,212,692$ 1,292,767$ 29,416$ 2% 80,512$ 7%
Annual Total 1,312,727$ 1,260,000$
Franchise Fees Revenue
Ye ar to Date through November
Month
2014 vs. 2013 2014 vs. Budget
Page 4 of 36
Monthly Financial Report November 2014
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year.
October 2014 collections
represent activities conducted
during the 3rd quarter of 2014.
The year‐to‐date collection of
$310k is $16k or 5% less than the
prior year but is $4k or 1% more
than the budget.
Licenses and Permits
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totalled $240k in
November. The year‐to‐date
development fees revenue of $4.1
million is $411k or 11% more than
the year before and is also $751k
or 23% higher than budget. The
higher than expected fees are due
to collecting more in general
building permits, electrical
permits, and plan check fees. The
City has exceeded the budget for
Building Permits and
Development Service Fees, but we
are adjusting the budget in the upcoming year‐end budget amendment.
Business Licenses
Business Licenses totalled $19k
for November, which is $5.6k or
42% above the same month last
year and is also $4.5k or 31%
above the current month’s
budget. The variance in July is
due to a mid‐year correction
made in July 2013. The year‐to‐
date Business Licenses revenue of
$512k is $12k or 2% above the
prior year but is $17k or 3% lower
than the budget. The City is
projecting business licenses to be
under the budget at year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 82,440$ 75,206$ 80,243$ (2,196)$ ‐3% 5,038$ 7%
Feb ‐ 451 ‐
Apr 70,311 72,698 74,163 3,852 5% 1,464 2%
Jun ‐ ‐ 145 145 100% 145 100%
Jul 87,473 81,342 79,130 (8,344) ‐10% (2,213) ‐3%
Aug 76 37 ‐
Oct 85,616 77,019 76,631 (8,986) ‐10% (389) ‐1%
Nov 1,192 575 ‐
Dec 149 672 ‐
YTD Total 327,109$ 307,328$ 310,311$ (15,529)$ ‐5% 4,046$ 1%
Annual Total 327,258$ 308,000$
Month
2014 vs. 2013 2014 vs. Budget
Admission Tax Revenue
Year to Date through November
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 327,584$ 251,556$ 432,890$ 105,306$ 32% 181,335$ 72%
Feb 230,039 215,688 412,317 182,278 79% 196,629 91%
Mar 305,085 286,301 388,190 83,105 27% 101,889 36%
Apr 367,165 315,718 374,004 6,839 2% 58,286 18%
May 386,735 320,878 349,590 (37,145) ‐10% 28,712 9%
Jun 293,386 278,431 516,689 223,303 76% 238,258 86%
Jul 314,991 307,931 288,957 (26,033) ‐8% (18,973) ‐6%
Aug 340,270 351,856 300,184 (40,087) ‐12% (51,672) ‐15%
Sep 254,799 214,610 369,040 114,242 45% 154,430 72%
Oct 440,169 432,077 393,023 (47,146) ‐11% (39,055) ‐9%
Nov 393,258 338,737 239,983 (153,275) ‐39% (98,754) ‐29%
Dec 348,144 391,919
YTD Total 3,653,481$ 3,313,782$ 4,064,867$ 411,386$ 11% 751,084$ 23%
Annual Total 4,001,625$ 3,705,701$
Building Permits and Development Service Fees
Year to Date through November
2014 vs. Budget2014 vs. 2013
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 95,381$ 103,448$ 103,064$ 7,683$ 8% (384)$ 0%
Feb 40,658 36,482 25,013 (15,645) ‐38% (11,469) ‐31%
Mar 12,441 9,762 5,421 (7,020) ‐56% (4,340) ‐44%
Apr 102,648 107,716 97,104 (5,544) ‐5% (10,612) ‐10%
May 33,354 20,233 15,091 (18,263) ‐55% (5,142) ‐25%
Jun 5,701 5,102 7,444 1,743 31% 2,342 46%
Jul 52,586 84,946 109,369 56,783 108% 24,423 29%
Aug 29,210 24,595 16,430 (12,780) ‐44% (8,165) ‐33%
Sep 4,236 4,178 5,290 1,054 25% 1,112 27%
Oct 109,998 117,828 108,777 (1,222) ‐1% (9,051) ‐8%
Nov 13,342 14,515 18,991 5,649 42% 4,476 31%
Dec 4,211 4,262 ‐
YTD Total 499,555$ 528,805$ 511,993$ 12,438$ 2% (16,812)$ ‐3%
Annual Total 503,766$ 533,067$
Business Licenses
Month
2014 vs. 2013
Year to Date through November
2014 vs. Budget
Page 5 of 36
Monthly Financial Report November 2014
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 81%
of the total revenues in
this category. The year‐to‐date total Intergovernmental revenue is $13 million or 100% of the budget.
State Shared Revenues
State Shared Revenue
collections totalled $4.5
million since the start of
the year. Compared to
the prior year, State
Shared Revenues are
above by $327k or 8%.
Compared to the
projected budget, the City
is collecting $448k or 11%
more. The higher than
expected collection is due
to collecting more than
anticipated Criminal Justice Sales Tax, the low budget of Criminal Justice’s High Crime, collecting more than anticipated Liquor
Profits and under collecting in Liquor Excise Taxes.
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 66%
of the total revenue in this category. The year‐to‐date total charges for services are $6.8 million or 95% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled
$781k 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 $153k or 24% more.
Compared to the year‐to‐date
budget, the City is over budget by
$82k or 12%. The large April
variance is due to a private
security police provided for a
large one‐time private business
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 32,322$ 31,574$ 117,639$ 85,317$ 264% 86,066$ 273%
Feb 117,056 100,863 45,139 (71,918) ‐61% (55,725) ‐55%
Mar 37,079 48,095 44,028 6,949 19% (4,067) ‐8%
Apr 64,009 87,936 38,202 (25,806) ‐40% (49,734) ‐57%
May 47,985 60,400 35,540 (12,446) ‐26% (24,860) ‐41%
Jun 36,945 45,438 107,246 70,301 190% 61,808 136%
Jul 69,340 82,484 56,212 (13,128) ‐19% (26,272) ‐32%
Aug 42,753 51,456 64,201 21,448 50% 12,745 25%
Sep 48,986 56,443 44,169 (4,817) ‐10% (12,274) ‐22%
Oct 81,116 78,627 190,822 109,706 135% 112,195 143%
Nov 49,703 54,931 37,507 (12,196) ‐25% (17,423) ‐32%
Dec 53,287 76,290 ‐
YTD Total 627,295$ 698,245$ 780,705$ 153,410$ 24% 82,459$ 12%
Annual Total 680,581$ 774,535$
Month
2014 vs. 2013
Year to Date through November
Public Safety Services
2014 vs. Budget
Intergovernmental 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
Fire District #25 1,157,089$ 1,242,038$ 1,242,038$ 84,949$ 7% $ ‐ 0%
Fire District #40 4,491,422 4,715,356 4,715,356 223,935 5%‐ 0%
State Shared Revenue 4,194,353 4,073,316 4,521,399 327,045 8% 448,083 11%
Federal Grants 1,022,468 1,378,554 1,378,554 356,087 35%‐ 0%
State Grants 63,711 41,174 41,174 (22,537) ‐35%‐ 0%
Other Grants/Intgovt 34,828 1,072,407 1,065,150 1,030,322 2958% (7,258) ‐1%
ARRA Grants 114,792 0 ‐ (114,792) 0%‐ 0%
Total Rev YTD 11,078,662$ 12,522,846$ 12,963,671$ 1,885,009$ 17%440,825$ 4%
Total Rev Annual 11,682,043$ 12,994,452$
YTD %95% 96% 100%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2013 2014 2014
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,911,568$ 1,828,203$ 2,073,416$ 161,847$ 8% 245,213$ 13%
Judicial Contribution 22,796 22,500 22,669 (127) ‐1% 169 1%
Crim Just ‐ High Crime 229,636 ‐ 253,799 24,163 11% 253,799 100%
Crim Just ‐ Pop 22,656 ‐ 24,563 1,906 8% 24,563 100%
Crim Just ‐ Spec Prog 84,328 90,000 91,026 6,698 8% 1,026 1%
State DUI 17,116 18,000 17,201 86 1% (799) ‐4%
Liquor Profits 635,103 502,797 636,899 1,796 0% 134,102 27%
Liquor Excise Tax 63,108 440,000 179,526 116,419 184% (260,474) ‐59%
Fuel Tax 1,208,042 1,171,816 1,222,300 14,257 1% 50,483 4%
YTD Total 4,194,353$ 4,073,316$ 4,521,399$ 327,045$ 8% 448,083$ 11%
Annual Total 4,701,889$ 4,515,500$
2014 vs. Budget
State Shared Revenues
2014 vs. 2013
Revenue
Year to Date through November
Page 6 of 36
Monthly Financial Report November 2014
event in 2013. The large June variance is due to staff reimbursement for training provided to the Basic Law Enforcement
Academy. The large October variance is due to staff reimbursement for the Oso mudslide. The City is projecting Public Safety
Services to be very close to the budget by year‐end.
Recreation
Recreation revenues totalled $36k
for the current month. Compared
to the same month the prior year,
the City collected $29k or 45%
less. Compared to the projected
monthly budget, the City
collected $31k or 46% less. The
year‐to‐date collection of $1.5
million is $24k or 2% higher than
the year before but is $6.8k lower
than the year‐to‐date budget.
The City is projecting Recreation
revenues to be very close with the
budget at year‐end.
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$3 million. Compared to the prior
year, the revenues are under by
$294k or 9%. Compared to the
projected budget, the revenues
are below by $48k or 2%. 2014’s
monthly budgets are based on
1/12th of the annual budget. 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.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 60,546$ 62,601$ 69,522$ 8,976$ 15% 6,921$ 11%
Feb 51,160 56,408 68,873 17,713 35% 12,465 22%
Mar 79,491 94,074 66,458 (13,033) ‐16% (27,616) ‐29%
Apr 170,541 157,142 179,282 8,742 5% 22,140 14%
May 95,710 119,835 106,771 11,061 12% (13,064) ‐11%
Jun 150,284 152,865 172,332 22,047 15% 19,466 13%
Jul 345,126 309,124 318,669 (26,458) ‐8% 9,544 3%
Aug 205,821 238,859 245,982 40,162 20% 7,123 3%
Sep 123,550 118,153 119,109 (4,440) ‐4% 956 1%
Oct 83,685 86,617 72,614 (11,072) ‐13% (14,003) ‐16%
Nov 65,656 67,145 36,383 (29,273) ‐45% (30,763) ‐46%
Dec 63,010 63,040 ‐
YTD Total 1,431,570$ 1,462,823$ 1,455,994$ 24,424$ 2% (6,829)$ 0%
Annual Total 1,494,580$ 1,525,863$
Recreation
Year to Date through November
2014 vs. Budget2014 vs. 2013
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 265,873$ 277,733$ 301,808$ 35,935$ 14% 24,075$ 9%
Feb 292,362 277,733 257,027 (35,335) ‐12% (20,706) ‐7%
Mar 317,998 277,733 287,465 (30,533) ‐10% 9,732 4%
Apr 288,610 277,733 295,489 6,879 2% 17,756 6%
May 299,652 277,733 269,032 (30,619) ‐10% (8,700) ‐3%
Jun 287,569 277,733 277,620 (9,950) ‐3% (113) 0%
Jul 282,466 277,733 244,707 (37,759) ‐13% (33,026) ‐12%
Aug 352,945 277,733 284,344 (68,601) ‐19% 6,611 2%
Sep 274,525 277,733 278,550 4,025 1% 817 0%
Oct 352,421 277,733 256,662 (95,759) ‐27% (21,071) ‐8%
Nov 286,300 277,733 254,192 (32,109) ‐11% (23,541) ‐8%
Dec 164,190 277,733 ‐
YTD Total 3,300,723$ 3,055,061$ 3,006,896$ (293,827)$ ‐9% (48,165)$ ‐2%
Annual Total 3,464,913$ 3,332,794$
Interfund Services
Year to Date through November
2014 vs. 2013 2014 vs. Budget
Month
Page 7 of 36
Monthly Financial Report November 2014
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.4 million. This is $59k or 2%
lower than a year ago and is also
$310k or 11% below the budget.
Included in the Fines and Penalties revenue
budget is $2 million from the Photo
Enforcement program. The monthly budget is
based on the prior year’s revenue. The year‐
to‐date collections from this program equates
to $1.5 million. The budget shortfall is due to
temporary shutting down 4 intersection
cameras in construction areas and lower
activity (driver behaviour changes).
The associated costs includes the equipment
provided by American Traffic Solutions, Inc.
(ATS), dedicated 2 FTEs in the Court Services
Department to process the increased caseload
and 1.1 FTEs in the Police Department for
support services. This staff time, along with a
90% pro tem budget and interpreter costs
amounts to $362k for personnel costs. The
total costs for the program equates to $842k which is represented in the table. April and May expenditures do not include the
monthly equipment rental costs paid to ATS, these costs were recorded in June.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 153,064$ 182,703$ 136,762$ (16,302)$ ‐11% (45,941)$ ‐25%
Feb 247,166 251,253 151,470 (95,696) ‐39% (99,783) ‐40%
Mar 275,222 276,820 203,482 (71,740) ‐26% (73,338) ‐26%
Apr 318,235 312,315 263,785 (54,451) ‐17% (48,530) ‐16%
May 278,783 309,616 208,436 (70,347) ‐25% (101,180) ‐33%
Jun 269,334 307,008 224,214 (45,120) ‐17% (82,794) ‐27%
Jul 236,571 269,780 205,103 (31,468) ‐13% (64,677) ‐24%
Aug 171,565 178,125 258,728 87,162 51% 80,603 45%
Sep 154,604 169,913 247,480 92,876 60% 77,567 46%
Oct 191,919 249,230 239,990 48,072 25% (9,239) ‐4%
Nov 189,412 230,005 287,406 97,994 52% 57,402 25%
Dec 280,787 321,732
YTD Total 2,485,876$ 2,736,768$ 2,426,857$ (59,019)$ ‐2% (309,911)$ ‐11%
Annual Total 2,766,663$ 3,058,500$
2014 vs. Budget2014 vs. 2013
Year to Date through November
Fines and Penalties by Month
Month
Year to Date through November
2013 2014 2014
Actual Budget Actual $ % $ %
Civil Penalties 8,591$ 13,311$ 5,548$ (3,043)$ ‐35% (7,763)$ ‐58%
Civil Infraction Penalties 539,579 518,627 478,132 (61,447) ‐11% (40,495) ‐8%
Civil Parking Infraction Penalties 161,148 159,998 165,479 4,330 3% 5,480 3%
Photo Enforcement Program 1,509,300 1,787,271 1,522,009 12,709 1% (265,261) ‐15%
Criminal Traffic Misdemeanor Fines 88,465 88,008 79,525 (8,939) ‐10% (8,483) ‐10%
Criminal Non‐Traffic Fines 41,110 42,570 38,401 (2,708) ‐7% (4,169) ‐10%
Criminal Costs 112,208 105,823 112,502 293 0% 6,679 6%
Non‐Court Fines, Forfeitures and Penalties 25,474 21,159 25,261 (214) ‐1% 4,102 19%
YTD Total 2,485,876$ 2,736,768$ 2,426,857$ (59,019)$ ‐2% (309,911)$ ‐11%
Annual Total 2,766,663$ 3,058,500$
Revenue
2014 vs. Budget
Fines and Penalties by Type
2014 vs. 2013
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 180,582$ 61,721$ 73,624$ 30,160$ 31,561$
Feb 165,453 68,045 73,336 51,174 16,871
Mar 161,059 103,922 73,278 79,750 24,172
Apr 214,411 166,547 71,661 30,160 136,388
May 214,507 125,097 73,575 30,160 94,937
Jun 207,265 130,264 71,358 179,726 (49,463)
Jul 184,107 144,267 71,451 80,154 64,113
Aug 93,843 176,393 71,108 79,962 96,431
Sep 71,053 175,995 58,646 80,481 95,514
Oct 159,611 160,221 63,603 91,332 68,890
Nov 135,380 209,536 64,079 91,536 118,000
Dec 162,729 ‐ 76,245 ‐ ‐
YTD Total 1,787,271$ 1,522,009$ 765,719$ 824,594$ 697,415$
Annual Total 1,950,000$ 841,964$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through November
Month
Page 8 of 36
Monthly Financial Report November 2014
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.8 million.
Compared to last year, the
revenues are above by $578k or
47%. Compared to the projected
year‐to‐date budget, the revenues
are over by $385k or 27%. The negative amount for July is due to a correction made to move interest earned from Utility tax
audits, originally recorded in June. The large variance in September is due to recording a trued up asset interfund interest
received from Surface Water Utility. This offsets the correction made to the acreage count Street Maintenance pays to Surface
Water. The table below page breaks out miscellaneous revenues by type.
Interest and other earnings are higher due to the interfund interest recorded from Surface Water to Street Maintenance.
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.
EXPENSES
Overall the City has expended 85% of its budgeted general governmental expenditures at the end of November. This is $2.2
million or 2.3% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general
governmental departments.
Council department is over the year‐to‐date budget by $1.3k or 0.5%. This is due to overspending on salaries/benefits and
under spending on professional services and travel/training. We are anticipating the expenditures will be very close to the
budget at year‐end.
City Attorney is over the year‐to‐date budget by $40k or 2.4%. This is due to over spending on professional services. We are
anticipating the expenditures to be under the budget at year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 179,743$ 191,797$ 243,963$ 64,220$ 36% 52,166$ 27%
Feb 76,397 68,789 99,547 23,149 30% 30,758 45%
Mar 147,909 162,425 126,132 (21,777) ‐15% (36,293) ‐22%
Apr 92,872 104,162 70,094 (22,778) ‐25% (34,068) ‐33%
May 118,719 211,517 107,650 (11,069) ‐9% (103,868) ‐49%
Jun 123,441 133,692 257,714 134,273 109% 124,022 93%
Jul 128,246 127,105 (21,407) (149,652) ‐117% (148,512) ‐117%
Aug 122,652 138,445 121,979 (673) ‐1% (16,466) ‐12%
Sep 92,799 98,931 552,749 459,951 496% 453,818 459%
Oct 82,288 93,894 119,594 37,306 45% 25,700 27%
Nov 63,945 91,224 128,732 64,787 101% 37,508 41%
Dec 399,005 702,574
YTD Total 1,229,012$ 1,421,983$ 1,806,747$ 577,735$ 47% 384,764$ 27%
Annual Total 1,628,017$ 2,124,557$
Year to Date through November
Month
2014 vs. Budget2014 vs. 2013
Miscellaneous Revenues by Month
2013 2014 2014
Actual Budget Actual $ % $ %
Interests and Other Earnings 98,597$ 191,094$ 603,712$ 505,114$ 512% 412,617$ 216%
Rents, Leases, and Concessions 706,234 707,030 684,092 (22,142) ‐3% (22,938) ‐3%
Contributions/Donations from Private Sources 80,715 92,894 105,287 24,572 30% 12,393 13%
Other 302,589 285,108 354,063 51,473 17% 68,955 24%
Seizure Funds ‐ Federal/State/Local1 40,876 145,857 59,593 18,718 46% (86,263) ‐59%
YTD Total 1,229,012$ 1,421,983$ 1,806,747$ 577,735$ 47% 384,764$ 27%
Annual Total 1,628,017$ 2,124,557$
1Seizure Funds are categorized in Miscellaneous for 2013 and on.
2014 vs. Budget
Miscellaneous Revenues by Type
Year to Date through November
Revenue
2014 vs. 2013
Page 9 of 36
Monthly Financial Report November 2014
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 ‐ ‐ ‐ ‐ 70,335 45,225 ‐
Grants / intergovernmental 1,045,995 ‐ 117,144 ‐ ‐ 1,166,208 ‐
Charges for services 138,641 1,712,023 15,779,505 15,969,156 8,854,057 9,077,750 13,951,902
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 5,198 ‐ ‐ ‐ 2,139 ‐ ‐
Rents, leases, and misc fees 2,218,893 345,743 64,130 134,491 ‐ ‐ ‐
Interest and other misc 4,933 1,795 7,432 380,550 660,392 607,226 8,129
TOTAL REVENUES 3,413,660 2,059,561 15,968,211 16,484,197 9,586,923 10,896,409 13,960,031
EXPENSES:
Utility billing ‐ ‐ 114,249 97,202 82,504 133,263 ‐
Utility systems ‐ ‐ 14,212,745 4,575,568 2,725,670 3,178,672 ‐
Utility maintenance ‐ ‐ 247,800 4,385,973 1,166,113 2,144,378 13,359,257
Transportation 2,556,446 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,861,448 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 2,556,446 1,861,448 14,574,794 9,058,743 3,974,287 5,456,313 13,359,257
AMOUNT AVAILABLE FOR DEBT SERVICE 857,214 198,113 1,393,418 7,425,454 5,612,636 5,440,096 600,774
DEBT SERVICE:
Principal 101,646 ‐ ‐ 395,175 270,848 42,590 ‐
Interest 3,558 1,625 ‐ 329,405 166,761 618,691 ‐
TOTAL DEBT SERVICE 105,204 1,625 ‐ 724,580 437,609 661,281 ‐
CAPITAL PROJECTS 1,313,439 90,998 ‐ 1,902,007 2,670,292 2,931,123 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ (44,002) (10,194) (9,599) ‐
CHANGE IN FUND BALANCE (561,429) 105,490 1,393,418 4,754,865 2,494,541 1,838,093 600,774
BEGINNING FUND BALANCE, Jan 1 1,669,564 319,161 1,344,883 12,350,952 5,528,366 7,510,285 2,603,562
ENDING FUND BALANCE, Nov 30 1,108,135 424,651 2,738,301 17,105,817 8,022,907 9,348,378 3,204,336
Page 10 of 36
Monthly Financial Report November 2014
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 ‐ 142,803 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 44,426
Charges for services
Equipment rental m&o 2,565,938 2,765,580 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 103,042 ‐ 370,080 ‐ ‐ ‐
Communications ‐ 4,681 ‐ 468,077 ‐ ‐ ‐
Facilities ‐ ‐ 3,900,966 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 128,709 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 402,262 ‐ ‐ ‐ ‐ ‐
Interest and other misc 12,410 6,333 3,678 1,080 36,032 17,702 21,006
Internal service fund misc:
Vehicle / equipment capital recovery 1,394,735 123,750 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,490,977 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 1,542,306 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 10,442,682 1,565,215
Other misc 469 22,700 7,660 164 ‐ 333,641 ‐
Interfund Loan ‐ ‐ ‐ ‐ 139,931 ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 39,759 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries 26,400 ‐ ‐ ‐ 87,637 ‐ ‐
TOTAL REVENUES 4,039,711 3,699,860 3,912,305 839,401 3,296,883 10,794,025 1,630,647
EXPENSES:
Communications 471,078
Equipment rental 2,194,943
Facilities 3,388,143
Healthcare 11,817,047
Information technology 3,158,565
Print and mail 325,258
Retiree healthcare 1,111,421
Risk management:
Risk ma nagement 1,372,495
Unemployment 86,903
Worker's compensation 1,413,363
TOTAL EXPENSES 2,194,943 3,158,565 3,388,143 796,336 2,872,761 11,817,047 1,111,421
AMOUNT AVAILABLE FOR CAPITAL 1,844,768 541,295 524,161 43,065 424,122 (1,023,022) 519,226
CAPITAL PROJECTS 717,914 547,900 495,688 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ (6,386) ‐ ‐ 3,600,000 ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 1,126,854 (12,991) 28,473 43,065 4,024,122 (1,023,022) 519,226
BEGINNING FUND BALANCE, Jan 1 3,935,088 2,216,612 1,167,714 347,771 7,630,077 6,934,304 7,207,703
ENDING FUND BALANCE, Nov 30 5,061,942 2,203,621 1,196,187 390,836 11,654,199 5,911,282 7,726,929
Page 11 of 36
Monthly Financial Report November 2014
FUND BALANCE
Page 13 shows the ending fund balance as of November 2014. The City’s fund balance is a combination of current
deficit/surplus of funds which have accrued from unexpended operating budgets, unanticipated excess revenues, and from
balances accumulated from prior years.
The prior year’s balances (or beginning balance) include funds identified as being reserved for specific purposes or required to
meet the current year’s appropriations. These balances also provide financial stability to the City’s operation during uncertain
times and provide a layer of security to bondholders.
At the end of November, the City has $27.8 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 25% of budgeted operating expenditures. This is an increase of $10.3 million
from the year’s beginning balance. November’s ending fund balance is over the anticipated General Governmental Fund
Balance of $21.1 million by $6.7 million or 31.5%. Although the ending fund balance is above projections, it is consistent with
the prior years’ trends.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services Department. For additional financial information,
please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel free to contact us at
hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.
Page 12 of 36
Monthly Financial Report November 2014
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through November 30, 2014
Funds
Balance
01/01/2014
Budgeted
Revenue
Revenue
11/30/14
Total Funds
Available
Budgeted
Expenditure
Expenditure
11/30/14 Ending Balance
GENERAL GOVERNMENT FUNDS: 17,454,261 108,060,706 106,024,345 123,478,606 112,263,486 95,713,308 27,765,299
000 General 12,515,053 78,095,984 76,279,546 88,794,599 82,362,345 73,563,526 15,231,074
001 Community Services 2,124,598 11,706,752 10,705,341 12,829,939 11,693,059 9,921,501 2,908,438
003 Street 1,667,393 9,028,020 8,759,080 10,426,473 9,134,763 7,851,431 2,575,042
004 Community Dev Block Grant (229,834) 577,004 525,987 296,153 336,973 253,078 43,075
005 Museum 52,979 226,683 226,783 279,762 226,683 195,746 84,016
009 Farmers Market 98,826 60,400 61,689 160,515 83,322 63,393 97,122
011 Fire Health & Wellness 55,094 25,000 23,215 78,309 25,000 5,368 72,941
031 Park Memorial 478 ‐ ‐ 478 478 478 ‐
201 Ltd GO Bonds Gen Govt Debt 833,717 1,749,705 1,753,499 2,587,216 1,749,705 119,700 2,467,516
215 Gen Govt Misc Debt Service 335,957 6,591,158 7,689,206 8,025,163 6,651,158 3,739,087 4,286,076
SPECIAL REVENUE FUNDS: 1,978,198 1,831,745 1,565,571 3,543,769 2,114,993 930,560 2,613,209
102 Arterial Street 192,689 633,000 576,496 769,185 810,000 ‐ 769,185
108 Leased City Properties 549,887 833,071 602,413 1,152,300 853,626 660,159 492,141
110 Hotel Motel 185,606 265,000 294,675 480,281 315,693 242,111 238,170
125 1% For Art 97,771 15,000 258 98,029 50,000 7,135 90,894
127 Cable Communication 284,632 85,674 89,857 374,489 85,674 21,155 353,334
135 Springbrook Wetlands Bank 667,613 ‐ 1,872 669,485 ‐ ‐ 669,485
CAPITAL PROJECT FUNDS (CIP):29,503,154 24,193,031 16,258,413 45,761,567 49,727,635 16,938,006 28,823,561
303 Community Dev Mitigation 934,618 60,000 295,311 1,229,929 ‐ ‐ 1,229,929
304 Fire Mitigation 646,165 50,000 274,211 920,376 ‐ ‐ 920,376
305 Transportation Mitigation 486,185 40,000 623,955 1,110,140 200,000 ‐ 1,110,140
316 Municipal Facilities CIP 5,083,524 3,342,827 2,458,961 7,542,485 8,193,703 3,013,227 4,529,258
317 Transportation CIP 2,687,303 19,250,204 11,100,460 13,787,763 21,228,172 11,585,673 2,202,090
318 So Lake WA Infrastructure Proj 9,012 ‐ 25 9,037 9,012 ‐ 9,037
326 Housing Opportunity 84,599 1,000,000 1,001,785 1,086,384 75,000 ‐ 1,086,384
336 New Library Development 19,571,748 450,000 503,705 20,075,453 20,021,748 2,339,106 17,736,347
ENTERPRISE FUNDS:31,326,773 99,145,679 72,414,826 103,741,599 106,550,073 61,789,073 41,952,526
4X2 Airport Operating & CIP 1,669,564 17,384,184 3,413,660 5,083,224 18,828,270 3,975,088 1,108,136
403 Solid Waste Utility 1,344,883 16,419,820 15,968,212 17,313,095 16,508,948 14,574,794 2,738,301
4X4 Golf Operating & CIP 319,161 2,537,449 2,105,394 2,424,555 2,715,919 1,999,904 424,651
4X5 Water Operating & CIP 12,350,952 18,150,149 16,484,198 28,835,150 19,224,942 11,729,331 17,105,819
4X6 Waste Water Operating & CIP 5,528,366 12,163,934 9,586,922 15,115,288 12,599,029 7,092,382 8,022,906
416 King County Metro 2,603,562 15,202,336 13,960,031 16,563,593 15,202,336 13,359,257 3,204,336
4X7 Surface Water Operating & CIP 7,510,285 17,287,807 10,896,409 18,406,694 21,470,629 9,058,317 9,348,377
INTERNAL SERVICE FUNDS:29,439,269 34,094,877 31,806,445 61,245,714 32,505,399 27,100,716 34,144,998
501 Equipment Repair/Replacement 3,935,088 4,380,718 4,039,711 7,974,799 4,669,709 2,912,857 5,061,942
502 Insurance 7,630,077 7,344,062 6,896,882 14,526,959 3,188,983 2,872,760 11,654,199
503 Information Services 2,216,612 4,010,222 3,693,474 5,910,086 5,358,145 3,706,464 2,203,622
504 Facilities 1,167,714 4,105,749 3,912,305 5,080,019 4,570,541 3,883,831 1,196,188
505 Communications 347,771 896,374 839,401 1,187,172 917,403 796,336 390,836
512 Insurance, Healthcare 6,934,304 11,622,068 10,794,025 17,728,329 12,062,456 11,817,047 5,911,282
522 Insurance, Leoff1 Retirees HC 7,207,703 1,735,684 1,630,647 8,838,350 1,738,162 1,111,421 7,726,929
FIDUCIARY FUNDS:4,790,247 300,000 150,131 4,940,378 225,475 188,736 4,751,642
611 Firemen's Pension 4,790,247 300,000 150,131 4,940,378 225,475 188,736 4,751,642
TOTAL FUNDS 114,491,902 267,626,038 228,219,731 342,711,633 303,387,061 202,660,399 140,051,235
Page 13 of 36
City of Renton
General Government Financial Position
2014 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
17,454,261
January 5,710,991 8,047,088 (2,336,097) 15,118,164
February 12,530,792 15,890,655 (3,359,862) 14,094,399
March 19,541,262 23,627,952 (4,086,690) 13,367,571
April 32,250,423 32,119,009 131,414 17,585,675
May 50,233,421 44,853,913 5,379,508 22,833,769
June 56,390,743 53,545,448 2,845,294 20,299,555
July 62,847,141 62,026,823 820,318 18,274,579
August 68,948,315 70,785,733 (1,837,418) 15,616,843
September 75,770,901 78,798,286 (3,027,385) 14,426,876
October 94,198,592 88,095,548 6,103,044 23,557,305
November 106,024,345 95,713,308 10,311,038 27,765,299
December
(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
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
12,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
Change in Fund
Balance
Rev/Exp Revenues
Expenditures
Change in Fund Balance
Page 14 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,862,470 5,710,991 ‐2.58%
Feb 11,926,762 12,530,792 5.06%
Mar 17,764,602 19,541,262 10.00%
Apr 34,807,961 32,250,423 ‐7.35%
May 48,635,359 50,233,421 3.29%
Jun 53,962,877 56,390,743 4.50%
Jul 60,507,357 62,847,141 3.87%
Aug 65,879,784 68,948,315 4.66%
Sep 71,612,377 75,770,901 5.81%
Oct 88,325,249 94,198,592 6.65%
Nov 101,600,829 106,024,345 4.35%
Dec 108,060,706
Percent of budget 98.12%
Property Tax Budget
YTD
Actual
Annual %
over (under)
Jan 162,468 (101,807) ‐162.66%
Feb 221,564 74,744 ‐66.27%
Mar 1,182,448 1,701,026 43.86%
Apr 11,815,359 7,509,891 ‐36.44%
May 18,180,258 18,201,961 0.12%
Jun 18,250,621 17,957,441 ‐1.61%
Jul 18,542,776 18,309,728 ‐1.26%
Aug 18,546,494 18,488,664 ‐0.31%
Sep 19,130,963 19,063,243 ‐0.35%
Oct 29,751,020 30,840,418 3.66%
Nov 34,808,607 34,891,805 0.24%
Dec 35,240,495
Percent of budget 99.01%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$(3)
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Millions Property Tax
Budget
Actual
Last Year
Page 15 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,780,130 1,796,358 0.91%
Feb 4,049,868 4,122,324 1.79%
Mar 5,735,971 5,867,541 2.29%
Apr 7,449,682 7,607,062 2.11%
May 9,403,295 9,574,693 1.82%
Jun 11,160,683 11,442,944 2.53%
Jul 12,941,079 13,379,782 3.39%
Aug 14,856,274 15,650,879 5.35%
Sep 16,674,205 17,719,960 6.27%
Oct 18,600,929 19,810,455 6.50%
Nov 20,542,214 21,994,933 7.07%
Dec 22,432,262
Percent of budget 98.05%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
Utility Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,372,593 1,373,119 0.04%
Feb 2,862,943 2,897,682 1.21%
Mar 4,173,577 4,529,120 8.52%
Apr 5,637,269 5,748,119 1.97%
May 7,000,058 7,128,436 1.83%
Jun 8,151,130 8,504,980 4.34%
Jul 9,849,365 10,031,609 1.85%
Aug 11,068,223 11,301,725 2.11%
Sep 12,434,563 12,508,038 0.59%
Oct 13,538,008 13,710,762 1.28%
Nov 14,760,964 14,881,028 0.81%
Dec 16,259,850
Percent of budget 91.52%
Note: Includes Natural Gas Use Tax.
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Sales Tax
Budget
Actual
Last Year
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Millions Utility Tax
Budget
Actual
Last Year
Page 16 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 283,179 404,067 42.69%
Feb 483,298 718,566 48.68%
Mar 687,979 929,709 35.14%
Apr 1,005,116 1,321,521 31.48%
May 1,238,954 1,615,047 30.36%
Jun 1,452,511 2,018,843 38.99%
Jul 1,758,517 2,340,772 33.11%
Aug 2,047,093 2,584,102 26.23%
Sep 2,213,029 2,866,227 29.52%
Oct 2,636,671 3,295,605 24.99%
Nov 2,886,417 3,526,439 22.17%
Dec 3,129,504
Percent of budget 112.68%
Note: Franchise Fees
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 804,661 846,109 5.15%
Feb 1,644,685 1,714,034 4.22%
Mar 2,017,623 2,206,902 9.38%
Apr 3,096,296 3,273,493 5.72%
May 5,523,875 5,716,232 3.48%
Jun 6,143,873 6,361,338 3.54%
Jul 6,718,562 6,946,598 3.39%
Aug 7,294,834 7,552,833 3.54%
Sep 7,966,027 8,299,399 4.18%
Oct 8,871,647 9,271,938 4.51%
Nov 12,522,846 12,963,671 3.52%
Dec 12,994,452
Percent of budget 99.76%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
$14
Millions
Intergovernmental
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions Licenses & Permits
Budget
Actual
Last Year
Page 17 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 466,134 669,010 43.52%
Feb 1,002,386 1,198,034 19.52%
Mar 1,548,420 1,831,413 18.28%
Apr 2,214,131 2,482,936 12.14%
May 2,816,212 3,017,160 7.14%
Jun 3,402,473 3,730,690 9.65%
Jul 4,200,894 4,470,663 6.42%
Aug 4,887,074 5,183,570 6.07%
Sep 5,421,972 5,742,786 5.92%
Oct 6,024,642 6,388,133 6.03%
Nov 6,558,687 6,801,674 3.70%
Dec 7,158,086
Percent of budget 95.02%
Note: Excludes FD25 & FD40 contracts
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
Jan 182,703 136,762 ‐25.15%
Feb 433,957 288,232 ‐33.58%
Mar 710,777 491,714 ‐30.82%
Apr 1,023,092 755,499 ‐26.16%
May 1,332,708 963,935 ‐27.67%
Jun 1,639,716 1,188,149 ‐27.54%
Jul 1,909,496 1,393,252 ‐27.04%
Aug 2,087,621 1,651,980 ‐20.87%
Sep 2,257,534 1,899,460 ‐15.86%
Oct 2,506,763 2,139,450 ‐14.65%
Nov 2,736,768 2,426,857 ‐11.32%
Dec 3,058,500
Percent of budget 79.35%
$‐
$1
$2
$3
$4
$5
$6
$7
$8
Millions Charges for Services
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Fines & Forfeits
Budget
Actual
Last Year
Page 18 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 618,804 343,410 ‐44.50%
Feb 967,476 1,173,666 21.31%
Mar 1,284,796 1,511,820 17.67%
Apr 2,039,843 3,008,720 47.50%
May 2,401,309 3,359,954 39.92%
Jun 2,889,486 4,272,641 47.87%
Jul 3,587,180 5,082,426 41.68%
Aug 3,954,237 5,505,875 39.24%
Sep 4,277,220 6,085,885 42.29%
Oct 5,064,812 7,021,935 38.64%
Nov 5,362,343 6,683,935 24.65%
Dec 5,663,000
Percent of budget 118.03%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 191,797 243,963 27.20%
Feb 260,586 343,510 31.82%
Mar 423,011 469,642 11.02%
Apr 527,173 539,736 2.38%
May 738,691 647,386 ‐12.36%
Jun 872,383 905,100 3.75%
Jul 999,488 883,693 ‐11.59%
Aug 1,137,933 1,005,672 ‐11.62%
Sep 1,236,865 1,558,421 26.00%
Oct 1,330,758 1,678,015 26.09%
Nov 1,421,983 1,806,747 27.06%
Dec 2,124,557
Percent of budget 85.04%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
Millions Miscellaneous
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
$7
$8
Millions Other Taxes
Budget
Actual
Last Year
Page 19 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb ‐ ‐ N/A
Mar ‐ 2,375 100.00%
Apr ‐ 3,447 100.00%
May ‐ 8,617 100.00%
Jun ‐ 8,617 100.00%
Jul ‐ 8,617 100.00%
Aug ‐ 23,015 100.00%
Sep ‐ 27,482 100.00%
Oct ‐ 41,880 100.00%
Nov ‐ 47,257 100.00%
Dec ‐
Percent of budget 100.00%
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
Other Financing Sources
Budget
Actual
Last Year
Page 20 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
REET Budget
YTD
Actual
Annual %
over (under)
Jan 94,134 162,143 72.25%
Feb 278,168 610,596 119.51%
Mar 438,277 838,225 91.25%
Apr 577,013 1,747,345 202.83%
May 777,722 2,010,091 158.46%
Jun 1,021,902 2,634,433 157.80%
Jul 1,207,067 2,984,646 147.26%
Aug 1,413,460 3,331,324 135.69%
Sep 1,591,955 3,596,857 125.94%
Oct 1,783,413 4,032,907 126.13%
Nov 2,023,852 4,256,583 110.32%
Dec 2,900,000
Percent of budget 146.78%
Bldg Permits &
Devlpmt Svc
Fees Budget
YTD
Actual
Annual %
over (under)
Jan 251,556 432,890 72.09%
Feb 467,244 845,207 80.89%
Mar 753,544 1,233,397 63.68%
Apr 1,069,262 1,607,401 50.33%
May 1,390,140 1,956,991 40.78%
Jun 1,668,571 2,473,680 48.25%
Jul 1,976,502 2,762,637 39.77%
Aug 2,328,357 3,062,821 31.54%
Sep 2,542,968 3,431,861 34.95%
Oct 2,975,045 3,824,884 28.57%
Nov 3,313,782 4,064,867 22.67%
Dec 3,705,701
Percent of budget 109.69%
$‐
$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
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions Building Permits and Development Service
Fees
Budget
Actual
Last Year
Page 21 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,702,627 8,047,088 4.47%
Feb 16,440,324 15,890,655 ‐3.34%
Mar 24,209,276 23,627,952 ‐2.40%
Apr 33,106,752 32,119,009 ‐2.98%
May 46,456,710 44,853,913 ‐3.45%
Jun 55,167,725 53,545,448 ‐2.94%
Jul 63,950,799 62,026,823 ‐3.01%
Aug 72,406,490 70,785,733 ‐2.24%
Sep 80,559,068 78,798,286 ‐2.19%
Oct 89,966,969 88,095,548 ‐2.08%
Nov 97,943,517 95,713,308 ‐2.28%
Dec 112,263,485
Percent of budget expended 85.26%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 24,713 23,569 ‐4.63%
Feb 50,791 55,960 10.18%
Mar 77,175 84,100 8.97%
Apr 103,348 108,911 5.38%
May 128,959 133,956 3.88%
Jun 154,624 159,997 3.48%
Jul 180,383 185,030 2.58%
Aug 205,498 209,660 2.03%
Sep 231,042 234,318 1.42%
Oct 256,847 259,383 0.99%
Nov 282,568 283,891 0.47%
Dec 309,907
Percent of budget expended 91.61%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
Legislative
Budget
Actual
Last Year
Page 22 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 80,412 76,257 ‐5.17%
Feb 197,216 186,396 ‐5.49%
Mar 316,702 296,472 ‐6.39%
Apr 439,720 407,807 ‐7.26%
May 557,592 517,214 ‐7.24%
Jun 661,840 629,321 ‐4.91%
Jul 776,168 742,514 ‐4.34%
Aug 891,836 861,339 ‐3.42%
Sep 997,727 972,904 ‐2.49%
Oct 1,110,465 1,082,383 ‐2.53%
Nov 1,222,415 1,190,964 ‐2.57%
Dec 1,359,996
Percent of budget expended 87.57%
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 143,108 135,206 ‐5.52%
Feb 289,153 276,371 ‐4.42%
Mar 435,055 419,299 ‐3.62%
Apr 589,689 562,501 ‐4.61%
May 731,578 713,626 ‐2.45%
Jun 882,055 878,900 ‐0.36%
Jul 1,024,858 1,035,254 1.01%
Aug 1,170,538 1,196,303 2.20%
Sep 1,323,502 1,352,254 2.17%
Oct 1,482,556 1,509,944 1.85%
Nov 1,626,768 1,666,481 2.44%
Dec 1,863,395
Percent of budget expended 89.43%
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
Millions Executive
Budget
Actual
Last Year
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
Millions City Attorney
Budget
Actual
Last Year
Page 23 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 163,940 159,512 ‐2.70%
Feb 331,204 323,167 ‐2.43%
Mar 499,924 487,984 ‐2.39%
Apr 676,750 660,115 ‐2.46%
May 849,947 830,863 ‐2.25%
Jun 1,039,155 997,832 ‐3.98%
Jul 1,215,215 1,167,708 ‐3.91%
Aug 1,385,662 1,333,913 ‐3.73%
Sep 1,555,116 1,495,607 ‐3.83%
Oct 1,726,270 1,656,337 ‐4.05%
Nov 1,897,359 1,808,423 ‐4.69%
Dec 2,094,010
Percent of budget expended 86.36%
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 83,847 83,232 ‐0.73%
Feb 167,836 166,457 ‐0.82%
Mar 252,105 249,681 ‐0.96%
Apr 338,988 333,812 ‐1.53%
May 421,256 418,279 ‐0.71%
Jun 504,064 502,746 ‐0.26%
Jul 586,980 587,213 0.04%
Aug 669,788 671,680 0.28%
Sep 752,773 756,148 0.45%
Oct 835,539 840,615 0.61%
Nov 918,100 924,619 0.71%
Dec 1,012,142
Percent of budget expended 91.35%
$‐
$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.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions
Community & Economic
Development Admin
Budget
Actual
Last Year
Page 24 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 245,147 216,780 ‐11.57%
Feb 475,540 437,105 ‐8.08%
Mar 710,754 683,399 ‐3.85%
Apr 967,749 931,956 ‐3.70%
May 1,211,026 1,163,496 ‐3.92%
Jun 1,463,648 1,382,845 ‐5.52%
Jul 1,721,037 1,593,443 ‐7.41%
Aug 1,995,920 1,817,405 ‐8.94%
Sep 2,250,357 2,003,133 ‐10.99%
Oct 2,519,009 2,210,589 ‐12.24%
Nov 2,776,952 2,419,251 ‐12.88%
Dec 3,040,435
Percent of budget expended 79.57%
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 79,265 36,443 ‐54.02%
Feb 121,101 80,671 ‐33.39%
Mar 166,928 136,650 ‐18.14%
Apr 216,402 186,131 ‐13.99%
May 261,778 230,384 ‐11.99%
Jun 312,460 286,843 ‐8.20%
Jul 365,766 353,794 ‐3.27%
Aug 423,762 410,729 ‐3.08%
Sep 475,562 465,775 ‐2.06%
Oct 526,555 520,262 ‐1.20%
Nov 583,152 577,062 ‐1.04%
Dec 644,063
Percent of budget expended 89.60%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
Millions
Economic Development
Budget
Actual
Last Year
Page 25 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 176,776 123,910 ‐29.91%
Feb 364,981 264,152 ‐27.63%
Mar 549,854 426,860 ‐22.37%
Apr 735,514 584,673 ‐20.51%
May 921,326 747,714 ‐18.84%
Jun 1,108,350 922,069 ‐16.81%
Jul 1,296,003 1,107,408 ‐14.55%
Aug 1,501,983 1,300,370 ‐13.42%
Sep 1,703,471 1,486,360 ‐12.75%
Oct 1,879,353 1,698,142 ‐9.64%
Nov 2,062,499 1,876,321 ‐9.03%
Dec 2,261,206
Percent of budget expended 82.98%
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 174,219 161,643 ‐7.22%
Feb 350,791 331,528 ‐5.49%
Mar 537,158 505,966 ‐5.81%
Apr 733,247 678,686 ‐7.44%
May 934,634 852,555 ‐8.78%
Jun 1,140,246 1,129,517 ‐0.94%
Jul 1,350,983 1,336,451 ‐1.08%
Aug 1,565,061 1,578,130 0.84%
Sep 1,752,355 1,770,575 1.04%
Oct 1,927,705 1,946,971 1.00%
Nov 2,098,547 2,124,461 1.23%
Dec 2,644,758
Percent of budget expended 80.33%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
$2.80
Millions Finance
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Millions
Planning
Budget
Actual
Last Year
Page 26 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 64,003 62,855 ‐1.79%
Feb 132,897 183,252 37.89%
Mar 216,913 380,731 75.52%
Apr 292,782 446,560 52.52%
May 498,004 516,105 3.63%
Jun 563,065 583,164 3.57%
Jul 745,933 650,434 ‐12.80%
Aug 827,964 717,774 ‐13.31%
Sep 901,085 783,328 ‐13.07%
Oct 973,200 850,302 ‐12.63%
Nov 1,046,567 912,188 ‐12.84%
Dec 1,125,927
Percent of budget expended 81.02%
Includes Hearing Examiner
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 72,706 63,751 ‐12.32%
Feb 152,715 131,247 ‐14.06%
Mar 239,432 203,164 ‐15.15%
Apr 320,251 294,344 ‐8.09%
May 397,478 365,419 ‐8.07%
Jun 489,534 439,333 ‐10.25%
Jul 572,574 516,316 ‐9.83%
Aug 658,226 597,747 ‐9.19%
Sep 739,793 677,205 ‐8.46%
Oct 822,360 749,118 ‐8.91%
Nov 907,045 820,519 ‐9.54%
Dec 1,002,994
Percent of budget expended 81.81%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Millions Human Resources
Budget
Actual
Last Year
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions City Clerk
Budget
Actual
Last Year
Page 27 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Police Budget
YTD
Actual
Annual %
over (under)
Jan 2,461,536 2,620,270 6.45%
Feb 4,914,804 4,935,606 0.42%
Mar 7,347,775 7,538,512 2.60%
Apr 9,883,702 9,787,131 ‐0.98%
May 12,495,735 12,388,107 ‐0.86%
Jun 14,859,786 14,833,908 ‐0.17%
Jul 17,520,296 17,418,007 ‐0.58%
Aug 19,807,596 19,670,400 ‐0.69%
Sep 22,438,819 22,287,048 ‐0.68%
Oct 24,737,751 24,629,111 ‐0.44%
Nov 27,316,037 27,211,179 ‐0.38%
Dec 30,616,637
Percent of budget expended 88.88%
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 2,041,819 2,561,083 25.43%
Feb 4,847,480 4,745,812 ‐2.10%
Mar 6,854,096 6,727,201 ‐1.85%
Apr 8,855,803 8,701,872 ‐1.74%
May 11,028,108 10,587,000 ‐4.00%
Jun 13,014,291 12,576,090 ‐3.37%
Jul 15,006,605 14,602,905 ‐2.69%
Aug 17,030,818 17,031,941 0.01%
Sep 19,036,886 19,047,501 0.06%
Oct 21,071,064 21,014,198 ‐0.27%
Nov 23,133,937 22,967,966 ‐0.72%
Dec 25,219,873
Percent of budget expended 91.07%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Millions Police
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
Millions Fire & Emergency Services
Budget
Actual
Last Year
Page 28 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 42,394 36,113 ‐14.82%
Feb 82,537 75,787 ‐8.18%
Mar 122,781 120,240 ‐2.07%
Apr 164,144 158,781 ‐3.27%
May 205,095 196,067 ‐4.40%
Jun 245,774 233,851 ‐4.85%
Jul 286,244 273,470 ‐4.46%
Aug 326,379 311,518 ‐4.55%
Sep 366,052 350,076 ‐4.36%
Oct 405,523 387,579 ‐4.42%
Nov 447,189 427,611 ‐4.38%
Dec 493,982
Percent of budget expended 86.56%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 292,322 271,473 ‐7.13%
Feb 598,427 555,521 ‐7.17%
Mar 920,103 856,188 ‐6.95%
Apr 1,273,822 1,154,945 ‐9.33%
May 1,614,058 1,483,776 ‐8.07%
Jun 1,979,168 1,838,337 ‐7.12%
Jul 2,366,921 2,221,396 ‐6.15%
Aug 2,777,634 2,651,206 ‐4.55%
Sep 3,184,127 3,062,286 ‐3.83%
Oct 3,574,538 3,425,754 ‐4.16%
Nov 3,939,495 3,736,620 ‐5.15%
Dec 4,311,514
Percent of budget expended 86.67%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions Parks
Budget
Actual
Last Year
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
$500,000
Community Services Admin
Budget
Actual
Last Year
Page 29 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 49,228 43,855 ‐10.91%
Feb 101,030 90,409 ‐10.51%
Mar 166,883 148,948 ‐10.75%
Apr 229,214 201,429 ‐12.12%
May 301,827 270,042 ‐10.53%
Jun 366,732 323,404 ‐11.81%
Jul 431,978 388,391 ‐10.09%
Aug 495,631 447,522 ‐9.71%
Sep 564,205 520,028 ‐7.83%
Oct 636,195 579,547 ‐8.90%
Nov 702,081 652,989 ‐6.99%
Dec 880,373
Percent of budget expended 74.17%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 317,480 278,944 ‐12.14%
Feb 677,093 603,208 ‐10.91%
Mar 1,041,360 928,117 ‐10.87%
Apr 1,429,365 1,262,485 ‐11.68%
May 1,793,244 1,601,422 ‐10.70%
Jun 2,188,393 1,972,450 ‐9.87%
Jul 2,809,941 2,585,291 ‐7.99%
Aug 3,479,188 3,235,603 ‐7.00%
Sep 3,980,445 3,741,873 ‐5.99%
Oct 4,344,574 4,069,963 ‐6.32%
Nov 4,701,254 4,413,265 ‐6.13%
Dec 5,111,272
Percent of budget expended 86.34%
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
Parks Planning and Natural Resources
Budget
Actual
Last Year
$0.00
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
Millions Recreation
Budget
Actual
Last Year
Page 30 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 55,618 47,594 ‐14.43%
Feb 137,342 143,610 4.56%
Mar 256,950 249,760 ‐2.80%
Apr 398,189 385,688 ‐3.14%
May 482,903 453,886 ‐6.01%
Jun 553,577 503,169 ‐9.11%
Jul 696,013 632,253 ‐9.16%
Aug 766,601 734,148 ‐4.23%
Sep 820,966 778,514 ‐5.17%
Oct 972,513 922,589 ‐5.13%
Nov 1,051,935 984,040 ‐6.45%
Dec 1,250,790
Percent of budget expended 78.67%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 68,622 57,193 ‐16.66%
Feb 131,885 146,776 11.29%
Mar 210,347 200,847 ‐4.52%
Apr 280,168 257,492 ‐8.09%
May 348,656 307,785 ‐11.72%
Jun 436,118 371,803 ‐14.75%
Jul 544,155 472,085 ‐13.24%
Aug 631,090 545,684 ‐13.53%
Sep 711,521 609,069 ‐14.40%
Oct 785,130 680,570 ‐13.32%
Nov 890,176 754,887 ‐15.20%
Dec 979,716
Percent of budget expended 77.05%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions Human Services
Budget
Actual
Last Year
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
$1,000,000
Neighborhoods, Resources, and Events
Budget
Actual
Last Year
Page 31 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 18,447 16,819 ‐8.82%
Feb 37,132 33,387 ‐10.09%
Mar 55,837 49,955 ‐10.53%
Apr 75,357 66,789 ‐11.37%
May 94,204 84,860 ‐9.92%
Jun 113,251 103,291 ‐8.79%
Jul 131,932 121,764 ‐7.71%
Aug 150,895 140,521 ‐6.87%
Sep 169,970 158,841 ‐6.55%
Oct 189,000 177,396 ‐6.14%
Nov 208,138 195,746 ‐5.95%
Dec 226,683
Percent of budget expended 86.35%
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 40,644 31,793 ‐21.78%
Feb 81,126 63,574 ‐21.64%
Mar 121,691 95,355 ‐21.64%
Apr 164,065 127,778 ‐22.12%
May 203,500 160,270 ‐21.24%
Jun 241,286 193,002 ‐20.01%
Jul 277,486 225,599 ‐18.70%
Aug 314,166 258,263 ‐17.79%
Sep 350,422 291,876 ‐16.71%
Oct 385,541 323,823 ‐16.01%
Nov 420,605 355,520 ‐15.47%
Dec 456,340
Percent of budget expended 77.91%
$‐
$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
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
$240,000
Museum Fund
Budget
Actual
Last Year
Page 32 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 357,056 311,026 ‐12.89%
Feb 762,542 658,352 ‐13.66%
Mar 1,136,757 980,862 ‐13.71%
Apr 1,524,658 1,423,475 ‐6.64%
May 1,897,484 1,791,574 ‐5.58%
Jun 2,295,209 2,157,217 ‐6.01%
Jul 2,669,674 2,532,280 ‐5.15%
Aug 3,032,552 2,911,004 ‐4.01%
Sep 3,407,811 3,292,979 ‐3.37%
Oct 3,787,372 3,746,215 ‐1.09%
Nov 4,167,811 4,113,703 ‐1.30%
Dec 4,595,011
Percent of budget expended 89.53%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 299,741 278,181 ‐7.19%
Feb 664,652 632,259 ‐4.87%
Mar 1,036,278 921,240 ‐11.10%
Apr 1,468,622 1,450,448 ‐1.24%
May 1,810,444 1,771,639 ‐2.14%
Jun 2,129,219 2,100,480 ‐1.35%
Jul 2,522,140 2,426,304 ‐3.80%
Aug 2,918,281 2,773,453 ‐4.96%
Sep 3,263,752 3,079,278 ‐5.65%
Oct 3,635,898 3,432,741 ‐5.59%
Nov 3,985,013 3,737,728 ‐6.21%
Dec 4,539,752
Percent of budget expended 82.33%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions Street Maintenance
Budget
Actual
Last Year
$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
Page 33 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 51,520 51,520 0.00%
Feb 302,837 302,837 0.00%
Mar 303,355 303,355 0.00%
Apr 916,538 916,538 0.00%
May 917,058 917,058 0.00%
Jun 1,807,407 1,807,407 0.00%
Jul 2,068,927 2,068,927 0.00%
Aug 2,319,244 2,319,244 0.00%
Sep 2,319,244 2,319,244 0.00%
Oct 3,858,787 3,858,787 0.00%
Nov 3,858,787 3,858,787 0.00%
Dec 8,400,863
Percent of budget expended 45.93%
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 298,065 298,065 0.00%
Feb 467,210 467,210 0.00%
Mar 633,063 633,063 0.00%
Apr 1,028,664 1,028,664 0.00%
May 6,350,814 6,350,814 0.00%
Jun 6,618,473 6,618,473 0.00%
Jul 6,782,586 6,782,586 0.00%
Aug 7,060,175 7,060,175 0.00%
Sep 7,262,067 7,262,067 0.00%
Oct 7,523,227 7,523,227 0.00%
Nov 7,699,087 7,699,087 0.00%
Dec 7,821,844
Percent of budget expended 98.43%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
Millions Non‐Departmental Other City Services
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
Millions Debt Service
Budget
Actual
Last Year
Page 34 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2014 Budget Year
Utilities Budget Revenue Expense
Jan 4,282,915 6,606,636 3,795,307
Feb 9,840,870 11,939,236 8,329,760
Mar 17,396,247 17,397,529 13,080,021
Apr 23,772,199 23,768,876 17,635,562
May 30,981,842 29,697,956 22,628,698
Jun 39,313,999 35,247,583 28,309,030
Jul 47,349,047 41,725,569 34,204,756
Aug 54,084,273 48,485,673 39,583,355
Sep 61,668,578 54,748,613 45,515,835
Oct 67,516,946 61,529,725 50,817,667
Nov 73,775,492 66,895,726 55,804,773
Dec 85,005,884
Percent of budget expended 60.96%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan 211,065 292,698 108,595
Feb 433,615 639,757 472,632
Mar 878,150 1,015,941 1,226,930
Apr 1,081,496 1,499,014 1,410,992
May 2,139,080 1,720,026 1,746,960
Jun 3,390,971 2,031,905 1,929,278
Jul 5,546,997 2,302,052 2,441,832
Aug 11,430,266 2,647,308 2,642,994
Sep 12,053,858 2,941,667 3,272,831
Oct 17,677,109 3,174,847 3,540,047
Nov 17,970,642 3,413,659 3,975,089
Dec 18,828,270
Percent of budget expended 21.11%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
Millions Utilities
Budget
Revenue
Expense
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
$18.00
$20.00
Millions Airport
Budget
Revenue
Expense
Page 35 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2014 Budget Year
Golf Course Budget Revenue Expense
Jan 148,339 83,199 128,950
Feb 311,204 157,539 295,744
Mar 506,698 276,011 463,052
Apr 746,715 478,430 653,009
May 929,343 731,751 898,163
Jun 1,151,882 1,039,218 1,072,304
Jul 1,346,835 1,356,019 1,258,392
Aug 1,533,049 1,664,007 1,449,288
Sep 1,729,746 1,902,271 1,641,315
Oct 1,916,501 2,040,088 1,860,039
Nov 2,077,100 2,105,393 1,999,904
Dec 2,715,919
Percent of budget expended 73.64%
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 36 of 36