HomeMy WebLinkAbout201606, JuneADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: August 8, 2016
TO: Randy Corman, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: June 2016 Financial Status Report
At the end of June, general governmental revenues show $3.1 million or 5% over budget.
Revenue source(s) that are higher than expected are: sales tax ($846k); sales tax annexation
credit ($176k); utility taxes ($164k); gambling taxes ($415k); real estate excise taxes ($170k);
business & occupation taxes ($213k); state shared revenues ($189k); building permits &
development service fees ($276k); public safety ($210k); seizure funds ($658k, restricted to drug
enforcement and not available for general purposes) and interest earnings ($105k). If we remove
seizure funds, general governmental revenues are $2.4 million or 4% over budget. On the down
side, the revenue source(s) that are underperforming the year to date budget are property tax
($116k below); interfund/interdept services ($171k below) and fines & penalties ($165k below).
General government expenditures showed a favorable variance of $4.2 million or 7.4%. See page
10 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 17,454,261$ 17,454,261$ 17,565,282$ 17,565,282$ 19,962,845$ 19,962,845$ 19,962,845$ ‐ 0.0%
OPERATING REVENUES
Property Tax 35,295,390 17,957,441 36,369,429 19,204,760 37,213,314 19,650,371 19,534,107 (116,264) ‐0.6%
Sales Tax 21,512,379 10,236,767 23,439,266 11,098,681 23,999,421 11,638,249 12,484,301 846,051 7.3%
Sales Tax ‐ Annexation Credit 2,542,394 1,206,177 2,778,858 1,316,375 2,748,167 1,302,775 1,479,116 176,341 13.5%
Criminal Justice Sales Tax 2,267,947 1,081,737 2,484,718 1,178,742 2,580,795 1,227,486 1,297,691 70,204 5.7%
Natural Gas Use Tax 271,485 187,378 228,899 144,031 268,000 168,634 130,626 (38,008) ‐22.5%
Admission Tax 310,311 154,551 309,790 151,784 320,000 158,082 140,840 (17,242) ‐10.9%
Franchise Fees 1,342,269 646,666 1,349,154 668,561 1,260,000 615,728 703,549 87,820 14.3%
Electricity Tax 5,167,444 2,834,180 5,012,962 2,428,025 4,946,019 2,556,575 2,868,127 311,552 12.2%
Natural Gas Utility Tax 1,562,341 1,170,336 1,437,552 936,792 1,350,900 948,873 866,072 (82,801) ‐8.7%
Garbage/Solid Waste 573,457 273,920 638,073 291,342 580,000 270,610 335,580 64,970 24.0%
TV Cable 1,518,821 738,225 1,591,866 771,848 1,629,365 790,970 778,525 (12,445) ‐1.6%
Telephone 909,088 470,647 880,233 485,416 952,500 508,936 445,730 (63,206) ‐12.4%
Cellular Phone 1,951,925 908,528 1,674,355 824,961 1,671,056 798,823 796,456 (2,367) ‐0.3%
City Utilities 3,961,052 1,921,766 4,183,165 2,041,493 4,208,377 2,047,943 2,034,188 (13,755) ‐0.7%
Utility Tax Audit 460,513 ‐ 1,962,092 533,218 111,227 111,227 111,227 ‐ 0.0%
Leasehold Excise Tax 171,470 89,256 163,314 84,782 179,000 93,053 87,456 (5,597) ‐6.0%
Gambling Excise Tax 1,650,384 796,580 2,299,156 1,076,516 1,600,000 758,811 1,173,527 414,716 54.7%
Real Estate Excise Tax 4,348,762 2,634,433 4,595,166 2,039,258 4,000,000 2,657,005 2,826,665 169,660 6.4%
Less: CIP REET (1,650,000) (499,628) (1,401,300) (509,815) (2,000,000) (1,413,332) (1,413,332) ‐ 0.0%
EMS Levy 916,361 450,784 936,406 234,102 1,069,454 479,597 479,597 ‐ 0.0%
B&O Taxes ‐ ‐ ‐ ‐ 5,000,000 4,500,000 4,912,972 412,972 9.2%
Less: CIP B&O Taxes ‐ ‐ ‐ ‐ (2,000,000) (1,800,000) (2,000,000) (200,000) 11.1%
Business License Fees 2,965,850 1,455,548 3,125,740 1,543,189 1,921,000 1,345,646 1,211,760 (133,885) ‐9.9%
Less: CIP Business License Fees (2,450,295) (1,202,411) (2,584,164) (1,275,527) (1,619,000) (1,116,865) (1,003,422) 113,443 ‐10.2%
Animal Licenses and Spec Events Permits 95,698 55,724 101,743 56,400 91,000 51,928 52,178 250 0.5%
Building Permits & Development Svc Fees 4,519,234 2,473,680 6,077,055 2,780,238 5,173,368 2,532,793 2,808,493 275,700 10.9%
Intergovt'l (Grants, State Shared, etc) 4,522,540 2,302,258 4,053,617 2,018,764 4,584,490 1,912,048 2,018,515 106,467 5.6%
Fire District 25 and 40 Contracts 5,959,428 2,977,343 6,369,132 3,105,766 6,128,712 3,353,423 3,353,423 ‐ 0.0%
Public Safety 844,375 387,793 649,797 397,045 630,135 330,779 540,590 209,811 63.4%
Culture and Recreation 1,485,123 663,238 1,587,878 566,608 1,727,393 691,320 697,052 5,732 0.8%
Interfund/Interdept‐Services 3,270,503 1,688,441 3,106,430 1,591,272 3,689,406 1,844,703 1,673,746 (170,957) ‐9.3%
Fines and Penalties 962,977 532,553 848,052 381,565 1,126,500 573,825 356,194 (217,631) ‐37.9%
Photo Enforcement 1,719,971 655,596 2,171,184 1,003,547 2,194,000 935,496 988,282 52,786 5.6%
Seizure Funds ‐ Federal/State/Local 68,870 3,346 21,676 6,444 50,000 5,406 663,143 657,737 12166.6%
Interests and Other Earnings 981,630 198,922 973,208 339,812 875,300 241,224 346,710 105,486 43.7%
Rents, Leases, and Concessions 711,070 446,145 762,361 438,102 598,616 359,246 347,693 (11,553) ‐3.2%
Contributions and Donations 113,626 55,876 147,292 60,684 96,700 43,199 43,389 191 0.4%
Other Miscellaneous 879,105 428,331 941,127 483,661 705,630 356,802 451,228 94,426 26.5%
Other Financing Sources (Transfer‐In, etc) 48,632 8,617 270,224 3,718 250,000 6,075 6,075 ‐ 0.0%
Total Operating Revenues 111,782,133 56,390,743 119,555,505 58,502,159 119,910,845 61,537,464 64,628,067 3,090,603 5.0%
OPERATING EXPENDITURES
Council 309,317 159,997 320,877 166,120 375,761 194,452 186,176 8,275 4.3%
Executive 1,338,738 629,321 1,691,189 687,127 1,784,464 775,317 890,444 (115,127) ‐14.8%
City Attorney 1,829,254 878,900 1,791,167 908,816 2,213,353 1,092,924 1,004,061 88,863 8.1%
Court Services 2,016,273 997,832 2,013,364 994,496 2,187,710 1,081,645 1,021,277 60,368 5.6%
Community and Eco Dvlpmnt Admin 1,010,761 502,746 1,183,052 546,093 1,163,302 556,162 575,150 (18,988) ‐3.4%
Development Services 2,659,078 1,382,845 2,632,264 1,300,030 3,225,543 1,635,451 1,370,849 264,601 16.2%
Economic Development 654,007 286,843 658,515 326,497 1,640,872 766,778 461,549 305,228 39.8%
Planning 2,095,706 922,069 2,606,551 1,325,058 3,019,484 1,442,959 1,327,179 115,779 8.0%
Finance 2,644,827 1,129,517 3,132,812 1,245,394 2,953,369 1,213,989 1,337,642 (123,653) ‐10.2%
City Clerk 1,152,246 583,164 1,027,084 404,603 1,151,870 522,077 460,231 61,846 11.8%
Human Resources 922,668 439,333 1,182,629 560,008 1,372,669 651,578 584,313 67,265 10.3%
Police 26,383,640 12,952,983 28,144,699 13,735,488 30,153,639 14,758,464 14,026,779 731,684 5.0%
Jail Services 3,760,273 1,880,926 4,142,266 2,073,022 4,703,000 2,352,230 2,352,230 ‐ 0.0%
Fire 25,240,760 12,576,090 26,536,999 13,459,450 28,869,022 14,516,282 12,826,352 1,689,930 11.6%
Community Services Admin 480,057 233,851 508,766 246,475 655,344 318,337 282,185 36,151 11.4%
Parks 4,070,181 1,838,337 4,411,383 2,010,536 5,065,610 2,298,738 2,027,520 271,217 11.8%
Parks Planning & Natural Resources 722,739 323,404 808,558 338,895 1,292,543 559,036 394,070 164,966 29.5%
Recreation 4,823,865 1,972,450 5,088,483 2,208,240 5,350,288 2,256,569 2,255,376 1,193 0.1%
Human Services 1,159,189 503,169 1,225,835 548,427 1,258,447 554,870 528,283 26,587 4.8%
Neighborhoods, Resources, & Events 875,223 371,803 958,624 401,711 1,096,033 462,305 392,885 69,421 15.0%
Museum 214,291 103,291 227,094 113,004 235,281 115,297 112,304 2,993 2.6%
Public Works Admin 389,493 193,002 387,493 193,206 413,579 205,573 200,630 4,943 2.4%
Street Maintenance 4,503,315 2,157,217 5,061,723 2,452,514 5,420,445 2,612,305 2,494,337 117,968 4.5%
Transportation 4,263,725 2,100,480 4,975,059 2,312,208 6,149,047 2,936,948 2,537,694 399,254 13.6%
Debt Service 8,393,140 1,807,407 6,371,715 814,758 6,248,676 936,921 936,921 ‐ 0.0%
Non‐Departmental and Other 9,758,346 6,618,473 10,069,740 1,632,035 7,048,924 2,637,745 2,637,745 ‐ 0.0%
Total Operating Expenditures 111,671,112 53,545,448 117,157,942 51,004,212 125,048,276 57,454,948 53,224,181 4,230,766 7.4%
Total Ending Fund Balance 17,565,282$ 20,299,555$ 19,962,846$ 25,063,230$ 14,825,414$ 24,045,362$ 31,366,731$ 7,321,369$ 30.4%
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2014 2015 2016 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report June 2016
Page 1 of 38
Monthly Financial Report June 2016
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through June 30, 2016. Except as noted,
year‐to‐date budgeted revenues and operating expenditures are generally based on the collection/disbursement patterns for
the same period of the preceding 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 75% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
June’s collection is $138k, making
the total year‐to‐date collection
$19.5 million or 52.5% of the total
budget. In comparison to the
previous year, the City collected
$329k or 2% more. Compared to
the budget, the City is under
projections by $116k or 1%. The
April/May variance is due to the
timing of collections in the
current year compared to the
prior year.
Sales Tax
June 2016 sales tax receipts
totaled $2.1 million. Compared
with the same month last year, it
is $450k or 27% more. Compared
to the projected current month’s
budget, it is $285k or 15% above.
The year‐to‐date collection of
$12.5 million is $1.4 million or
12% more than the prior year and
is also $846k or 7% more than
budgeted. New Construction,
Auto Sales and Services are the
sectors that are collecting more
than anticipated. 2016’s monthly
budgets are generally based on
2010 through 2015 collections.
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 67,234$ 68,794$ 44,745$ (22,489)$ ‐33% (24,049)$ ‐35%
Feb 307,006 314,129 315,119 8,113 3% 990 0%
Mar 939,218 961,010 1,273,685 334,468 36% 312,675 33%
Apr 10,160,118 10,395,864 7,856,230 (2,303,888) ‐23% (2,539,634) ‐24%
May 7,583,868 7,759,837 9,906,533 2,322,666 31% 2,146,696 28%
Jun 147,318 150,736 137,794 (9,524) ‐6% (12,942) ‐9%
Jul 65,395 66,912
Aug 94,817 97,017
Sep 561,525 574,554
Oct 6,263,616 6,408,951
Nov 9,975,046 10,206,498
Dec 204,271 209,010
YTD Total 19,204,760$ 19,650,371$ 19,534,107$ 329,347$ 2% (116,264)$ ‐1%
Annual Total 36,369,429$ 37,213,314$
Property Tax Revenues
Year to Date through June
2016 vs. 2015 2016 vs. Budget
Month
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 1,758,332$ 1,862,249$ 1,978,530$ 220,198$ 13% 116,281$ 6%
Feb 2,260,395 2,291,583 2,320,497 60,102 3% 28,913 1%
Mar 1,674,147 1,777,535 1,854,773 180,626 11% 77,238 4%
Apr 1,750,506 1,766,278 1,888,875 138,369 8% 122,597 7%
May 1,977,843 2,098,153 2,314,220 336,377 17% 216,067 10%
Jun 1,677,458 1,842,450 2,127,406 449,947 27% 284,956 15%
Jul 1,866,949 1,907,549 ‐
Aug 2,178,289 2,108,862 ‐
Sep 2,100,591 2,030,965 ‐
Oct 2,014,951 2,100,010 ‐
Nov 2,158,753 2,153,518 ‐
Dec 2,021,053 2,060,268 ‐
YTD Total 11,098,681$ 11,638,249$ 12,484,301$ 1,385,620$ 12% 846,051$ 7%
Annual Total 23,439,266$ 23,999,421$
2016 vs. Budget2016 vs. 2015
Month
Year to Date through June
Local Retail Sales Tax Revenues
Page 2 of 38
Monthly Financial Report June 2016
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
June utility tax revenues are $1.1
million, which is $689k or 38%
lower than the same month last
year and is also lower than the
budget by $192k or 15%. The
year‐to‐date collection is $8.4
million, which is $91k or 1% lower
than the prior year but is $164k
or 2% higher than the budget.
The large June variance with the
prior year is due to the
recognition of utility tax audit
proceeds.
The table below breaks out Utility Tax by source. The utility tax audit revenues are gross and do not include the related
audit fees ($26k).
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 1,199,348$ 1,384,085$ 1,509,960$ 310,612$ 26% 125,875$ 9%
Feb 1,371,771 1,418,341 1,597,348 225,577 16% 179,007 13%
Mar 1,544,060 1,553,221 1,423,774 (120,286) ‐8% (129,448) ‐8%
Apr 1,263,898 1,221,113 1,346,282 82,383 7% 125,169 10%
May 1,262,764 1,307,620 1,363,323 100,559 8% 55,703 4%
Jun 1,815,284 1,318,211 1,125,845 (689,439) ‐38% (192,366) ‐15%
Jul 2,175,167 1,165,160
Aug 1,351,000 1,299,385
Sep 1,214,144 1,203,343
Oct 1,204,406 1,193,676
Nov 1,342,058 1,262,186
Dec 1,865,296 1,391,102
YTD Total 8,457,125$ 8,202,591$ 8,366,531$ (90,594)$ ‐1% 163,940$ 2%
Annual Total 17,609,196$ 15,717,444$
2016 vs. Budget2016 vs. 2015
Year to Date through June
Utility Tax Revenues
Month
Sales Tax by Sector 2015 2016 Bgt YTD Act Change 2016/2015 2016 Act vs Bgt
New Construction 1,294,181$ 1,494,550$ 1,967,245$ 673,064$ 52%$ 472,695 32%
Auto Sales 2,160,978 2,258,650 2,379,966 218,988 10% 121,316 5%
General Retail 3,466,859 3,530,670 3,591,628 124,769 4% 60,959 2%
Manufacturing 901,475 864,508 875,243 (26,232) ‐3% 10,735 1%
Wholesale 568,904 579,619 615,668 46,764 8% 36,049 6%
Service 2,419,079 2,608,348 2,760,723 341,644 14% 152,375 6%
Other 287,206 301,905 293,828 6,622 2% (8,077)‐3%
YTD Total 11,098,681$ 11,638,249$ 12,484,301$ 1,385,620$ 12%846,051$ 7%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility Tax by Type 2015 2016 Bgt YTD Act Change 2016/2015 2016 Act vs Bgt
Electrical 2,428,025$ 2,556,575$ 2,868,127$ 440,101$ 18% $ 311,552 12%
Natural Gas 1,080,822 1,117,507 996,698 (84,124) ‐8% (120,809)‐11%
Cell 824,961 798,823 796,456 (28,504) ‐3% (2,367) 0%
Phone 485,416 508,936 445,730 (39,686) ‐8% (63,206)‐12%
Cable 771,848 790,970 778,525 6,678 1% (12,445)‐2%
Garbage/Solid Waste 291,342 270,610 335,580 44,238 15% 64,970 24%
City Utilities 2,041,493 2,047,943 2,034,188 (7,305) 0% (13,755)‐1%
Utility Tax Audit 533,218 111,227 111,227 (421,991) ‐79% ‐ 0%
YTD Total 8,457,125$ 8,202,591$ 8,366,531$ (90,594)$ ‐1%163,940$ 2%
Annual Total 17,609,196$ 15,717,444$
YTD as % of 48% 52%
Page 3 of 38
Monthly Financial Report June 2016
Other Taxes
Real Estate Excise Tax
The City collected $405k in Real
Estate Excise Tax revenues (REET)
for June. This is $73k or 15% less
than the same month last year
and is also $91k or 18% less than
the current month’s budget. The
year‐to‐date collection is $2.8
million, which is $787k or 39%
more than the prior year and is
also $170k or 6% above the
budget. The higher than
expected variance is due to 12
large transactions in December,
January and April which accounts
for $1 million of the total REET
collected.
Gambling Tax
June’s Gambling Tax collections
totaled $185k, which is $11k or
6% above the same month last
year and is also above the current
month’s budget by $60k or 47%.
The year‐to‐date total of $1.2
million is $97k or 9% above the
prior year and is also $415k or
55% above budget. $49k of the
year‐to‐date collections are from
a payment plan of back taxes
earned in 2013/2014.
Pull tabs overall had a 7%
decrease, bingo had a 91%
decrease (bingo establishment
closed December 2015), and card‐rooms are seeing 11% higher in activities when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $704k is $35k or 5% higher
than the prior year and is also
$88k or 14% above the projected
year‐to‐date budget.
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 226,377$ 704,460$ 1,204,479$ 978,102$ 432% 500,019$ 71%
Feb 158,616 262,383 197,327 38,710 24% (65,057) ‐25%
Mar 343,579 254,292 208,452 (135,127) ‐39% (45,840) ‐18%
Apr 438,485 529,653 335,985 (102,500) ‐23% (193,668) ‐37%
May 394,014 410,185 475,244 81,230 21% 65,059 16%
Jun 478,186 496,031 405,179 (73,008) ‐15% (90,853) ‐18%
Jul 563,474 273,630
Aug 281,921 200,643
Sep 449,693 213,186
Oct 497,978 288,868
Nov 325,743 127,159
Dec 437,098 239,509
YTD Total 2,039,258$ 2,657,005$ 2,826,665$ 787,406$ 39% 169,660$ 6%
Annual Total 4,595,166$ 4,000,000$
Real Estate Excise Tax Revenues
Year to Date through June
Month
2016 vs. Budget2016 vs. 2015
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 158,293$ 117,510$ 189,749$ 31,457$ 20% 72,239$ 61%
Feb 184,189 128,540 207,961 23,772 13% 79,420 62%
Mar 169,262 130,833 195,255 25,993 15% 64,421 49%
Apr 207,646 126,243 197,286 (10,361) ‐5% 71,043 56%
May 183,090 130,206 198,234 15,144 8% 68,027 52%
Jun 174,036 125,477 185,042 11,007 6% 59,565 47%
Jul 194,895 128,616 ‐
Aug 226,785 144,692 ‐
Sep 180,986 129,810 ‐
Oct 215,119 150,141 ‐
Nov 212,838 149,793 ‐
Dec 192,018 138,138 ‐
YTD Total 1,076,516$ 758,811$ 1,173,527$ 97,011$ 9% 414,716$ 55%
Annual Total 2,299,156$ 1,600,000$
Gambling Tax Revenue
Month
Year to Date through June
2016 vs. Budget2016 vs. 2015
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 333,343$ 307,326$ 348,118$ 14,775$ 4% 40,792$ 13%
Apr 335,218 308,402 355,430 20,212 6% 47,028 15%
Jul 340,657 311,290 ‐
Oct 339,936 309,807 ‐
Dec ‐ 23,175 ‐
YTD Total 668,561$ 615,728$ 703,549$ 34,987$ 5% 87,820$ 14%
Annual Total 1,349,154$ 1,260,000$
Month
2016 vs. 2015 2016 vs. Budget
Franchise Fees Revenue
Year to Date through June
Page 4 of 38
Monthly Financial Report June 2016
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year. April
2016 collections represent
activities conducted during the 1st
quarter of 2016. The year‐to‐date
collection of $141k is $9k or 7%
less than the prior year and is also
$16k or 11% less than the budget.
Business & Occupation Tax
Business and Occupation (B&O)
Tax is a new revenue source for
the City in 2016. It was adopted
by the Council in the 2015/2016
biennial budget. Businesses with
gross receipts of $1.5 million or
more per year, earned within the
City of Renton, will be required to
file and pay B&O tax, in lieu of the
Per Employee Fee, which is
currently reported as Business
License revenue. Year‐to‐date
receipts totaled $4.9 million. This
is due to one business reporting a
full year’s worth of activity.
Licenses and Permits
Business Licenses
Business Licenses totaled $27k
for June, which is $1k or 5%
above the same month last year
and is also $6k or 31% above the
current month’s budget. The
year‐to‐date Business Licenses
revenue of $1.2 million is $331k
or 21% below the prior year and
is also below the budget by $134k
or 10%. The annual budget was
decreased due to the City
adopting the Business &
Occupation Tax for 2016.
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 83,675$ 84,589$ 76,393$ (7,282)$ ‐9% (8,196)$ ‐10%
Feb 1,371 707 1,360 (11) ‐1% 652 92%
Mar 106 55 ‐
Apr 65,108 71,870 63,088 (2,020) ‐3% (8,782) ‐12%
May 1,523 786 ‐
Jun ‐ 75 ‐
Jul 82,804 83,565 ‐
Oct 75,167 78,334 ‐
Nov 35 18 ‐
YTD Total 151,784$ 158,082$ 140,840$ (9,314)$ ‐7% (16,327)$ ‐11%
Annual Total 309,790$ 320,000$
2016 vs. Budget
Admission Tax Revenue
Year to Date through June
Month
2016 vs. 2015
2015 2016 2016
Actual Budget Actual $ % $ %
Jan ‐$ ‐$ ‐$
Feb ‐ ‐ ‐
Mar ‐ ‐ ‐
Apr ‐ 4,500,000 4,578,349 4,578,349 100% 78,349 2%
May ‐ ‐ 304,032 304,032 100% 304,032 100%
Jun ‐ ‐ 30,591 30,591 100% 30,591 100%
Jul ‐ 250,000 ‐
Aug ‐ ‐ ‐
Sep ‐ ‐ ‐
Oct ‐ 250,000 ‐
Nov ‐ ‐ ‐
Dec ‐ ‐ ‐
YTD Total ‐$ 4,500,000$ 4,912,972$ 4,912,972$ 100% 412,972$ 9%
Annual Total ‐$ 5,000,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through June
Month
2016 vs. 2015 2016 vs. Budget
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 588,093$ 973,876 559,894$ (28,199)$ ‐5% (413,982)$ ‐43%
Feb 222,022 116,051 275,059 53,038 24% 159,009 137%
Mar 26,067 17,169 31,642 5,575 21% 14,473 84%
Apr 513,360 137,602 207,099 (306,261) ‐60% 69,497 51%
May 167,985 80,333 111,131 (56,855) ‐34% 30,797 38%
Jun 25,663 20,615 26,936 1,273 5% 6,321 31%
Jul 645,791 204,797 ‐
Aug 134,328 72,612 ‐
Sep 29,333 18,289 ‐
Oct 637,451 196,327 ‐
Nov 117,394 71,061 ‐
Dec 18,254 12,268 ‐
YTD Total 1,543,189$ 1,345,646$ 1,211,760$ (331,429)$ ‐21% (133,885)$ ‐10%
Annual Total 3,125,740$ 1,921,000$
*Total Business License (GF & CIP)
2016 vs. 2015
Year to Date through June
2016 vs. Budget
Business Licenses*
Month
Page 5 of 38
Monthly Financial Report June 2016
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $438k in June.
The year‐to‐date development
fees revenue of $2.8 million is
$28k or 1% more than the year
before and is also $276k or 11%
higher than budget. The large
variances in January, March and
June are due to large payments
for building permits and plan
review (Southport Developer,
Group Health Projects, and
Boeing).
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 87%
of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $7.1 million or 50% of the budget.
State Shared Revenues
State Shared Revenue
collections totaled $2.9
million since the start of
the year. Compared to
the prior year, State
Shared Revenues are
above by $326k or 13%.
Compared to the
projected budget, the
City is collecting $189k
or 7% more. The higher
than expected
collection is due to
collecting more than
anticipated Criminal Justice’s Sales Tax, Criminal Justice’s High Crime and Liquor Excise Tax.
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 260,603$ 341,282$ 661,363$ 400,760$ 154% 320,081$ 94%
Feb 328,557 364,818 413,420 84,863 26% 48,602 13%
Mar 275,826 319,009 583,658 307,832 112% 264,650 83%
Apr 655,282 492,468 336,108 (319,174) ‐49% (156,360) ‐32%
May 235,121 291,407 376,324 141,204 60% 84,917 29%
Jun 1,024,848 723,808 437,619 (587,229) ‐57% (286,189) ‐40%
Jul 873,549 585,030
Aug 454,971 378,288
Sep 586,213 478,819
Oct 462,191 425,333
Nov 427,863 326,114
Dec 492,031 446,990
YTD Total 2,780,238$ 2,532,793$ 2,808,493$ 28,255$ 1% 275,700$ 11%
Annual Total 6,077,055$ 5,173,368$
Year to Date through June
2016 vs. Budget2016 vs. 2015
Month
Building Permits and Development Service Fees
Intergovernmental 2015 2016 Bgt YTD Act Change 2016/2015 2016 Act vs Bgt
Fire District #25 628,463$ 698,123$ 698,123$ 69,660$ 11% $ ‐ 0%
Fire District #40 2,476,103 2,655,300 2,655,300 179,197 7%‐ 0%
State Shared Revenue 2,565,972 2,703,563 2,892,162 326,189 13% 188,598 7%
Federal Grants 451,430 240,001 240,001 (211,429) ‐47%‐ 0%
State Grants 39,151 39,421 39,421 270 1%‐ 0%
Other Grants/Intgovt 375,056 636,146 624,219 249,163 66% (11,927) ‐2%
ARRA Grants ‐ 0 ‐ ‐ N/A ‐ 0%
Total Rev YTD 6,536,174$ 6,972,554$ 7,149,225$ 613,051$ 9%176,671$ 3%
Total Rev Annual 13,842,673$ 14,363,451$
YTD %47% 49% 50%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2015 2016 2016
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,178,742$ 1,227,486$ 1,297,691$ 118,949$ 10% 70,204$ 6%
Judicial Contribution 10,895 ‐ 12,200 1,305 12% 12,200 100%
Crim Just ‐ High Crime 125,694 118,793 155,458 29,764 24% 36,665 31%
Crim Just ‐ Pop 12,688 11,690 13,231 543 4% 1,542 13%
Crim Just ‐ Spec Prog 46,617 43,608 48,378 1,761 4% 4,770 11%
State DUI 8,544 9,179 7,700 (844) ‐10% (1,479) ‐16%
Marijuana Enforcement ‐ ‐ 5,854 5,854 100% 5,854 100%
Liquor Profits 425,911 425,218 424,476 (1,435) 0% (743) 0%
Liquor Excise Tax 108,837 199,551 234,988 126,151 116% 35,437 18%
Fuel Tax 648,044 668,038 692,185 44,142 7% 24,147 4%
YTD Total 2,565,972$ 2,703,563$ 2,892,162$ 326,189$ 13% 188,598$ 7%
Annual Total 5,439,235$ 5,672,795$
State Shared Revenues
2016 vs. 2015
Revenue
Year to Date through June
2016 vs. Budget
Page 6 of 38
Monthly Financial Report June 2016
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
61% of the total revenue in this category. The year‐to‐date total charges for services are $3.9 million or 48% of the budget.
The following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$541k 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 $142k or 36% more.
Compared to the year‐to‐date
budget, the City is over budget by
$210k or 63%. The variance with
the prior year and budget is due
to collecting 3 large
payments/reimbursements for
electronic home detention and
School Resource Officer programs.
Recreation
Recreation revenues totaled
$240k for the current month.
Compared to the same month the
prior year, the City collected $12k
or 5% more. Compared to the
projected monthly budget, the
City collected $15k or 7% more.
The year‐to‐date collection of
$697k is $130k or 23% higher
than the year before and is also
$6k or 1% higher than the year‐
to‐date budget. The variance
with the prior year and monthly
budget is due to a change in how
the recreation class revenues are
recorded. The City is now
recognizing class revenues as the classes begin instead of when they are paid. The City currently has $327k in class revenues
to be recognized as soon as the classes begin.
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 58,509$ 74,126$ 104,644$ 46,135$ 79% 30,518$ 41%
Feb 42,228 36,766 99,623 57,395 136% 62,858 171%
Mar 62,481 44,821 58,031 (4,450) ‐7% 13,211 29%
Apr 146,715 77,816 51,002 (95,713) ‐65% (26,814) ‐34%
May 55,309 38,231 48,201 (7,108) ‐13% 9,970 26%
Jun 33,004 59,020 179,089 146,085 443% 120,069 203%
Jul 39,540 40,294 ‐
Aug 59,046 51,865 ‐
Sep 23,104 28,310 ‐
Oct 33,339 94,331 ‐
Nov 46,384 35,303 ‐
Dec 51,339 49,254 ‐
YTD Total 398,245$ 330,779$ 540,590$ 142,345$ 36% 209,811$ 63%
Annual Total 650,997$ 630,135$
2016 vs. Budget
Month
2016 vs. 2015
Year to Date through June
Public Safety Services
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 117,124$ 104,917$ 163,783$ 46,659$ 40% 58,866$ 56%
Feb 30,177 55,678 48,009 17,832 59% (7,669) ‐14%
Mar 35,946 57,563 60,615 24,669 69% 3,052 5%
Apr 91,404 152,158 112,627 21,224 23% (39,530) ‐26%
May 64,015 96,002 72,246 8,231 13% (23,756) ‐25%
Jun 227,942 225,001 239,771 11,829 5% 14,769 7%
Jul 428,943 420,247 ‐
Aug 313,197 314,325 ‐
Sep 119,720 134,250 ‐
Oct 55,478 72,003 ‐
Nov 61,601 55,079 ‐
Dec 42,331 40,169 ‐
YTD Total 566,608$ 691,320$ 697,052$ 130,444$ 23% 5,732$ 1%
Annual Total 1,587,878$ 1,727,393$
2016 vs. Budget2016 vs. 2015
Month
Recreation
Year to Date through June
Page 7 of 38
Monthly Financial Report June 2016
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$1.7 million. Compared to the
prior year, the revenues are over
by $82k or 5%. Compared to the
projected budget, the revenues
are below by $171k or 9%.
2016’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.
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
$1.3 million. This is $41k or 3%
lower than a year ago and is also
$165k or 11% below the budget.
The reason for the variance with
the budget is due to a change in
accounting for December 2014’s
revenue. In the past we would
record December through
November, but starting in 2015 we are recording January through December. 2016’s budget is based on 2014/2015 activity.
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 265,068$ 307,451$ 272,841$ 7,774$ 3% (34,609)$ ‐11%
Feb 264,413 307,451 286,748 22,336 8% (20,702) ‐7%
Mar 260,071 307,451 305,054 44,983 17% (2,396) ‐1%
Apr 248,466 307,451 276,238 27,772 11% (31,213) ‐10%
May 260,774 307,451 272,641 11,867 5% (34,809) ‐11%
Jun 292,480 307,451 260,223 (32,257) ‐11% (47,228) ‐15%
Jul 252,451 307,451 ‐
Aug 248,774 307,451 ‐
Sep 247,822 307,451 ‐
Oct 283,145 307,451 ‐
Nov 257,874 307,451 ‐
Dec 225,093 307,451 ‐
YTD Total 1,591,272$ 1,844,703$ 1,673,746$ 82,474$ 5% (170,957)$ ‐9%
Annual Total 3,106,430$ 3,689,406$
2016 vs. Budget
Month
Interfund Services
Year to Date through June
2016 vs. 2015
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 124,856$ 152,177$ 136,421$ 11,565$ 9% (15,756)$ ‐10%
Feb 213,981 215,466 217,667 3,686 2% 2,201 1%
Mar 275,737 281,062 263,648 (12,088) ‐4% (17,414) ‐6%
Apr 245,206 298,933 250,873 5,667 2% (48,060) ‐16%
May 257,217 273,396 214,613 (42,604) ‐17% (58,783) ‐22%
Jun 268,116 288,287 261,254 (6,862) ‐3% (27,033) ‐9%
Jul 221,949 246,930
Aug 280,257 313,023
Sep 272,343 299,806
Oct 260,327 290,029
Nov 281,222 333,431
Dec 318,027 327,959
YTD Total 1,385,113$ 1,509,321$ 1,344,477$ (40,636)$ ‐3% (164,845)$ ‐11%
Annual Total 3,019,236$ 3,320,500$
Month
2016 vs. Budget2016 vs. 2015
Year to Date through June
Fines and Penalties by Month
Year to Date through June
2015 2016 2016
Actual Budget Actual $ % $ %
Civil Penalties 1,645$ 8,854$ 961$ (685)$ ‐42% (7,893)$ ‐89%
Civil Infraction Penalties 183,871 323,167 150,025 (33,846) ‐18% (173,142) ‐54%
Civil Parking Infraction Penalties 65,534 92,468 71,319 5,785 9% (21,149) ‐23%
Photo Enforcement Program 1,003,547 935,496 988,282 (15,265) ‐2% 52,786 6%
Criminal Traffic Misdemeanor Fines 37,269 53,913 31,415 (5,853) ‐16% (22,498) ‐42%
Criminal Non‐Traffic Fines 31,864 25,396 16,019 (15,845) ‐50% (9,377) ‐37%
Criminal Costs 48,120 62,157 43,394 (4,725) ‐10% (18,763) ‐30%
Non‐Court Fines, Forfeitures and Penalties 13,263 7,870 43,061 29,798 225% 35,191 447%
YTD Total 1,385,113$ 1,509,321$ 1,344,477$ (40,636)$ ‐3% (164,845)$ ‐11%
Annual Total 3,019,236$ 3,320,500$
Revenue
2016 vs. Budget
Fines and Penalties by Type
2016 vs. 2015
Page 8 of 38
Monthly Financial Report June 2016
Included in the Fines and Penalties revenue
budget is $2.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 $988k.
The associated costs includes the equipment
provided by American Traffic Solutions, Inc.
(ATS), dedicated 1 FTE 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
50% pro tem budget and interpreter costs
amounts to $320k for personnel costs. The
total costs for the program equates to $1.1
million which is represented in the table. Due
to the timing of when the invoice was received,
January 2016’s equipment rental cost was recorded in February.
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. The year‐to‐date total
miscellaneous is $1.6 million.
Compared to last year, the
revenues are above by $564k or
52%. Compared to the projected
year‐to‐date budget, the
revenues are over by $844k or
105%. The large variance with
the prior year and budget is due
to collecting more than
anticipated Seizure Funds. These funds are restricted to drug enforcement only and are not available for general operating
purposes.
2015 2016 2016
Actual Budget Actual $ % $ %
Jan 269,664$ 199,303$ 258,876$ (10,789)$ ‐4% 59,572$ 30%
Feb 135,539 96,154 802,908 667,369 492% 706,754 735%
Mar 182,386 121,939 125,950 (56,436) ‐31% 4,011 3%
Apr 132,893 84,375 142,439 9,546 7% 58,064 69%
May 144,753 101,131 139,504 (5,249) ‐4% 38,374 38%
Jun 215,629 197,504 174,848 (40,781) ‐19% (22,656) ‐11%
Jul 189,913 64,601
Aug 199,969 130,176
Sep 139,977 306,444
Oct 173,512 120,987
Nov 148,227 111,497
Dec 435,114 388,506
YTD Total 1,080,863$ 800,406$ 1,644,525$ 563,662$ 52% 844,119$ 105%
Annual Total 2,367,576$ 1,922,616$
Year to Date through June
Month
2016 vs. Budget2016 vs. 2015
Miscellaneous Revenues by Month
Favorable
16 Budget 16 Actual 16 Budget 16 Actual (Unfavorable)1
Jan 103,426$ 131,281$ 89,912$ 26,662$ 104,619$
Feb 124,175 167,005 89,912 97,181 69,824
Mar 170,255 184,903 89,912 95,109 89,794
Apr 187,598 168,524 89,912 95,106 73,417
May 163,442 143,229 89,912 95,046 48,182
Jun 186,599 193,341 89,912 95,109 98,232
Jul 164,807 ‐ 89,912 ‐ ‐
Aug 221,543 ‐ 89,912 ‐ ‐
Sep 213,406 ‐ 89,912 ‐ ‐
Oct 195,225 ‐ 89,912 ‐ ‐
Nov 218,318 ‐ 89,912 ‐ ‐
Dec 245,205 ‐ 89,912 ‐ ‐
YTD Total 935,496$ 988,282$ 539,472$ 504,215$ 484,068$
Annual Total 2,194,000$ 1,078,943$
1Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through June
Month
Revenues Expenses
2015 2016 2016
Actual Budget Actual $ % $ %
Interests and Other Earnings 339,812$ 241,224$ 346,710$ 6,898$ 2% 105,486$ 44%
Rents, Leases, and Concessions 438,102 359,246 347,693 (90,409) ‐21% (11,553) ‐3%
Contributions/Donations from Private Sources 60,684 43,199 43,389 (17,294) ‐28% 191 0%
Other 235,822 151,331 243,590 7,768 3% 92,259 61%
Seizure Funds ‐ Federal/State/Local 6,444 5,406 663,143 656,700 10192% 657,737 12167%
YTD Total 1,080,863$ 800,406$ 1,644,525$ 563,662$ 52% 844,119$ 105%
Annual Total 2,367,576$ 1,922,616$
2016 vs. Budget
Miscellaneous Revenues by Type
Year to Date through June
Revenue
2016 vs. 2015
Page 9 of 38
Monthly Financial Report June 2016
EXPENSES
Overall the City has expended 43% of its budgeted general governmental expenditures at the end of June. This is $4.2 million
or 7.4% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental
departments.
Executive department is over the year‐to‐date budget by $115k or 14.8%. This is due to the timing of when Sound Cities
Association, Association of Washington Cities (AWC) and Communities in Schools memberships were corrected in 2015
(August).
Administrative Services (Finance and City Clerk) department is over the year‐to‐date budget by $62k or 3.6%. This is due
higher than expected merchant fees (credit card and ACH transaction costs) and spending patterns of professional services
(utility tax audit services) compared to prior years.
Page 10 of 38
Monthly Financial Report June 2016
CASH AND INVESTMENTS –
2ND 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 $165.9
million.
Currently, the majority
of the portfolio is
located in cash deposits
(US Bank). The rest is
spread out between the
State Investment Pool,
US Federal Agency
Securities, and various
certificates of deposits.
The existing portfolio yield is approximately 0.68%.
Current %
Blended
Allowed
per policy
Current Portfolio
(principal value)
39% N/A $ 65,405,556
0% 100%‐$
30% 75% 49,991,453$
16% 75% 27,198,255$
14% 75% 23,305,444$
0% 25%‐$
TOTAL INVESTMENTS 100% 165,900,708$
*Excluding Cash the portfolio distribution is 50% LGIP; 23% CD's; 27% GSE's
Cash
US Treasury Securities
Local Government Investment Pool
US Federal Agency Securities
Certificates of Deposit
Commercial Paper
By Type
Cash
40%
LGIP
30%
GSE's
16%
CD's
14%
Distribution by Type
By Institution Current %
Blended
Allowed by
Policy
Current Portfolio
(principal value)Maturity Date APY
Weighted
Yield
Blended
Cash US Bank ‐ Cash 39%N/A 65,405,556 overnight 0.45% 0.18%
US Treasury Securities
none 0% 100%‐ N/A N/A N/A
Local Government Investment Pool
3920 State Investment Pool 30% 75%49,991,453 10/1/2014 0.10% 0.15%
US Federal Agency Securities *
314179A FHLB 1,996,920 8/11/2017 1.05%0.01%
315189D FNMA 4,997,500 10/26/2018 1.03%0.03%
314179G FHLB 5,009,485 10/17/2017 0.93%0.03%
315209A FHLMC 1,600,000 5/26/2020 1.75%0.02%
315189C FHLMC 5,000,000 6/1/2018 1.12%0.03%
314189A FNMA 3,745,000 2/15/2018 1.30%0.03%
314179C FNMA 4,849,350 11/28/2017 1.00%0.03%
Certificates of Deposit
115184A First Savings Bank Northwest 5,092,087 2/6/2018 1.03%0.03%
116214A First Savings Bank Northwest 5,154,418 2/3/2021 1.67%0.05%
114174A First Savings Bank Northwest 5,000,000 10/29/2017 1.15%0.03%
116191A Opus 3%5,000,000 2/25/2019 1.00%0.03%
111167a Columbia Bank 1% 2,015,400 11/9/2016 0.99%0.01%
214163A Commencement Bank (CDARS)1%1,043,540 9/15/2016 0.90%0.01%
Commercial Paper
none 0.00% 5%‐ N/A N/AN/A
165,900,708$
75%16%
*Held in our safekeeping account at BNY Trust and Custody
TOTAL CASH & INVESTMENTS
20%
9%
Page 11 of 38
Monthly Financial Report June 2016
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. The negative beginning fund balance for the Golf Course fund is due to receiving less than anticipated user
fees in 2015. This negative balance will be corrected at the end of 2016 due to the Golf Course making its final payment for
debt service (interfund loan) in 2015. 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 ‐ ‐ ‐ ‐ 39,873 24,850 ‐
Grants / intergovernmental 475,099 ‐ 111,688 ‐ ‐ 1,215,632 ‐
Charges for services 70,407 900,638 8,546,300 7,631,443 4,901,488 5,326,847 7,907,104
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 1,959 ‐ ‐ ‐ 517 ‐ ‐
Rents, leases, and misc fees 1,282,207 206,864 63,091 95,693 ‐ ‐ ‐
Interest and other misc 5,214 740 7,542 550,075 560,742 261,649 9,222
TOTAL REVENUES 1,834,886 1,108,242 8,728,621 8,277,211 5,502,620 6,828,978 7,916,326
EXPENSES:
Utility billing ‐ ‐ 71,642 66,050 53,012 87,390 ‐
Utility systems ‐ ‐ 7,680,113 1,710,679 1,591,484 2,289,837 ‐
Utility maintenance ‐ ‐ 145,512 2,607,550 819,403 1,323,242 7,516,675
Transportation 781,246 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 949,446 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 781,246 949,446 7,897,267 4,384,279 2,463,899 3,700,469 7,516,675
AMOUNT AVAILABLE FOR DEBT SERVICE 1,053,640 158,796 831,354 3,892,932 3,038,721 3,128,509 399,651
DEBT SERVICE:
Principal ‐ ‐ ‐ 395,175 213,727 ‐ ‐
Interest ‐ ‐ ‐ 279,122 136,649 380,376 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 674,297 350,376 380,376 ‐
CAPITAL PROJECTS 64,432 ‐ ‐ 499,148 219,544 387,252 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ (5,974) (2,689) ‐
CHANGE IN FUND BALANCE 989,208 158,796 831,354 2,719,487 2,462,827 2,358,192 399,651
BEGINNING FUND BALANCE, Jan 1 1,144,749 (110,056) 2,151,456 22,681,621 11,636,515 10,682,778 3,992,378
ENDING FUND BALANCE, Jun 30 2,133,957 48,740 2,982,810 25,401,108 14,099,342 13,040,970 4,392,029
Page 12 of 38
Monthly Financial Report June 2016
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 ‐ 98,213 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 42,430
Charges for services
Equipment rental m&o 1,418,468 1,825,092 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 26,424 ‐ 214,089 ‐ ‐ ‐
Communications ‐ ‐ ‐ 299,290 ‐ ‐ ‐
Facilities ‐ ‐ 2,476,212 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 80,808 ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ 246,228 ‐ ‐ ‐ ‐ ‐
Interest and other misc 13,616 5,291 3,003 1,297 30,394 16,762 19,336
Internal service fund misc:
Vehicle / equipment capital recovery 1,611,678 73,506 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 950,444 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 954,698 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 6,085,969 1,112,950
Other misc 167 166 9,137 ‐ ‐ 567,408 ‐
Interfund Loan ‐ ‐ ‐ ‐ 146,298 ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 39,223 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 173,277 ‐ ‐
TOTAL REVENUES 3,083,152 2,355,728 2,488,352 514,676 2,255,111 6,670,139 1,174,716
EXPENSES:
Communications 258,312
Equipment rental 1,118,819
Facilities 2,078,060
Healthcare 6,093,844
Information technology 1,906,054
Print and mail 212,084
Retiree healthcare 550,636
Risk management:
Risk ma nagement 1,120,725
Unemployment 66,784
Worker's compensation 931,278
TOTAL EXPENSES 1,118,819 1,906,054 2,078,060 470,396 2,118,787 6,093,844 550,636
AMOUNT AVAILABLE FOR CAPITAL 1,964,333 449,674 410,292 44,280 136,324 576,295 624,080
CAPITAL PROJECTS 236,179 56,557 119,841 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ 21,335 ‐ 12,500 ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 1,728,154 414,452 290,451 56,780 136,324 576,295 624,080
BEGINNING FUND BALANCE, Jan 1 5,620,280 2,327,309 1,259,503 576,333 13,085,310 7,523,267 8,892,488
ENDING FUND BALANCE, Jun 30 7,348,434 2,741,761 1,549,954 633,113 13,221,634 8,099,562 9,516,568
Page 13 of 38
Monthly Financial Report June 2016
FUND BALANCE
Page 15 shows the ending fund balance as of June 2016. 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 June, the City has $31.4 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 $11.4 million
from the year’s beginning balance. June’s ending fund balance is over the anticipated General Governmental Fund Balance
of $24 million by $7.3 million or 30.4%. 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 14 of 38
Monthly Financial Report June 2016
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through June 30, 2016
Funds
Balance
01/01/2016
Budgeted
Revenue
Revenue
06/30/16
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/16 Ending Balance
GENERAL GOVERNMENT FUNDS: 19,962,845 119,910,846 64,628,067 84,590,912 125,048,275 53,224,181 31,366,731
000 General 12,622,447 89,255,466 49,026,432 61,648,879 92,603,349 41,651,982 19,996,897
001 Community Services 2,818,784 12,661,674 6,431,544 9,250,328 13,355,577 5,312,631 3,937,697
003 Street 2,422,668 10,489,584 5,505,283 7,927,951 11,569,492 5,032,031 2,895,920
004 Community Dev Block Grant 66,654 882,158 57,199 123,853 882,158 106,907 16,946
005 Museum 66,388 235,281 117,744 184,132 235,281 112,304 71,828
009 Farmers Market 110,830 113,007 23,528 134,358 104,242 39,405 94,953
011 Fire Health & Wellness 88,406 25,000 12,753 101,159 49,500 32,001 69,158
201 Ltd GO Bonds Gen Govt Debt 845,273 1,755,255 879,880 1,725,153 1,755,255 73,725 1,651,428
215 Gen Govt Mi sc Debt Service 921,395 4,493,421 2,573,704 3,495,099 4,493,421 863,196 2,631,904
SPECIAL REVENUE FUNDS: 1,681,875 1,919,264 968,143 2,650,018 2,653,291 763,532 1,886,486
102 Arterial Street 31,697 650,000 326,086 357,783 650,000 ‐ 357,783
108 Leased City Properties 560,515 931,590 433,263 993,778 1,445,852 665,159 328,619
110 Hotel Motel 315,590 225,000 121,248 436,838 326,298 83,996 352,842
125 1% For Art 111,206 15,000 235 111,441 102,950 ‐ 111,441
127 Cable Communication 330,376 97,674 86,610 416,986 128,191 14,377 402,609
135 Springbrook Wetlands Bank 332,491 ‐ 701 333,192 ‐ ‐ 333,192
CAPITAL PROJECT FUNDS (CIP):21,039,649 37,476,061 7,367,233 28,406,882 54,520,575 6,862,110 21,544,772
303 Community Dev Mitigation 1,239,509 86,500 131,098 1,370,607 ‐ ‐ 1,370,607
304 Fire Mitigation 1,209,670 99,000 192,617 1,402,287 850,000 ‐ 1,402,287
305 Transportation Mitigation 937,248 600,000 293,377 1,230,625 800,000 ‐ 1,230,625
316 Municipal Facilities CIP 9,264,141 8,201,188 3,209,809 12,473,950 17,364,363 1,019,217 11,454,733
317 Transportation CIP 3,947,132 28,489,373 3,530,879 7,478,011 32,081,038 5,087,415 2,390,596
326 Housing Opportunity 1,041,775 ‐ 2,199 1,043,974 25,000 1,500 1,042,474
336 New Library Development 3,400,174 ‐ 7,254 3,407,428 3,400,174 753,978 2,653,450
ENTERPRISE FUNDS:52,179,441 105,611,837 40,221,879 92,401,320 123,482,742 30,302,364 62,098,956
4X2 Airport Operating & CIP 1,144,749 14,755,346 1,834,885 2,979,634 14,164,354 845,678 2,133,956
403 Solid Waste Utility 2,151,456 16,514,320 8,728,621 10,880,077 17,140,339 7,897,266 2,982,811
4X4 Golf Operating & CIP (110,056) 2,812,793 1,133,239 1,023,183 2,295,432 974,444 48,739
4X5 Water Operating & CIP 22,681,621 16,308,371 8,277,211 30,958,832 26,092,307 5,557,723 25,401,109
4X6 Waste Water Operating & CIP 11,636,515 15,324,938 5,502,619 17,139,134 19,415,925 3,039,792 14,099,342
416 King County Metro 3,992,378 16,638,722 7,916,326 11,908,704 16,638,722 7,516,675 4,392,029
4X7 Surface Water Operating & CIP 10,682,778 23,257,347 6,828,978 17,511,756 27,735,663 4,470,786 13,040,970
INTERNAL SERVICE FUNDS:39,284,490 37,726,031 18,575,709 57,860,199 37,371,074 14,749,172 43,111,027
501 Equipment Repair/Replacement 5,620,280 6,164,145 3,083,152 8,703,432 5,514,530 1,354,997 7,348,435
502 Insurance 13,085,310 4,166,201 2,255,112 15,340,422 3,612,594 2,118,787 13,221,635
503 Information Services 2,327,309 4,833,871 2,377,063 4,704,372 5,960,478 1,962,611 2,741,761
504 Facilities 1,259,503 4,953,544 2,488,352 3,747,855 5,407,389 2,197,901 1,549,954
505 Communications 576,333 1,040,239 527,176 1,103,509 1,112,381 470,396 633,113
512 Insurance, Healthcare 7,523,267 14,295,824 6,670,139 14,193,406 14,596,149 6,093,844 8,099,562
522 Insurance, Leoff1 Retirees HC 8,892,488 2,272,207 1,174,715 10,067,203 1,167,553 550,636 9,516,567
FIDUCIARY FUNDS:5,299,035 468,000 155,959 5,454,994 200,475 97,641 5,357,353
611 Firemen's Pension 5,299,035 468,000 155,959 5,454,994 200,475 97,641 5,357,353
TOTAL FUNDS 139,447,335 303,112,039 131,916,990 271,364,325 343,276,432 105,999,000 165,365,325
Page 15 of 38
City of Renton
General Government Financial Position
2016 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
19,962,845
January 7,317,475 8,625,290 (1,307,815) 18,655,030
February 14,715,559 18,026,295 (3,310,736) 16,652,109
March 21,798,267 27,039,048 (5,240,781) 14,722,064
April 40,464,776 35,281,644 5,183,131 25,145,976
May 57,969,563 44,251,964 13,717,599 33,680,444
June 64,628,067 53,224,181 11,403,886 31,366,731
July
August
September
October
November
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
13,000,000
14,000,000
15,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
120,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 16 of 38
City of Renton
Monthly Revenue Analysis ‐ 2016 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 6,116,145 7,317,475 19.64%
Feb 12,464,426 14,715,559 18.06%
Mar 18,997,332 21,798,267 14.74%
Apr 38,307,505 40,464,776 5.63%
May 54,886,764 57,969,563 5.62%
Jun 61,537,464 64,628,067 5.02%
Jul 68,193,300
Aug 74,781,318
Sep 81,299,361
Oct 94,280,392
Nov 110,965,209
Dec 119,910,845
Percent of budget 53.90%
Property Tax Budget
YTD
Actual
Annual %
over (under)
Jan 68,794 44,745 ‐34.96%
Feb 382,923 359,864 ‐6.02%
Mar 1,343,934 1,633,550 21.55%
Apr 11,739,798 9,489,780 ‐19.17%
May 19,499,635 19,396,313 ‐0.53%
Jun 19,650,371 19,534,107 ‐0.59%
Jul 19,717,283
Aug 19,814,300
Sep 20,388,854
Oct 26,797,806
Nov 37,004,304
Dec 37,213,314
Percent of budget 52.49%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
$130
$140
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
$39
Millions Property Tax
Budget
Actual
Last Year
Page 17 of 38
City of Renton
Monthly Revenue Analysis ‐ 2016 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 2,067,608 2,212,710 7.02%
Feb 4,624,605 4,807,357 3.95%
Mar 6,598,572 6,882,003 4.30%
Apr 8,565,740 8,995,034 5.01%
May 10,893,426 11,583,888 6.34%
Jun 12,941,024 13,963,417 7.90%
Jul 15,068,593
Aug 17,435,267
Sep 19,708,241
Oct 22,045,782
Nov 24,451,213
Dec 26,747,588
Percent of budget 52.20%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
Utility Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,384,085 1,509,960 9.09%
Feb 2,802,425 3,107,308 10.88%
Mar 4,355,647 4,531,081 4.03%
Apr 5,576,759 5,877,363 5.39%
May 6,884,379 7,240,686 5.18%
Jun 8,202,591 8,366,531 2.00%
Jul 9,367,751
Aug 10,667,136
Sep 11,870,479
Oct 13,064,155
Nov 14,326,342
Dec 15,717,444
Percent of budget 53.23%
Note: Includes Natural Gas Use Tax.
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
Millions Sales Tax
Budget
Actual
Last Year
$‐
$2
$4
$6
$8
$10
$12
$14
$16
$18
Millions Utility Tax
Budget
Actual
Last Year
Page 18 of 38
City of Renton
Monthly Revenue Analysis ‐ 2016 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 438,371 707,784 61.46%
Feb 735,235 1,079,373 46.81%
Mar 947,143 1,559,970 64.70%
Apr 1,265,530 1,809,916 43.02%
May 1,515,887 2,089,751 37.86%
Jun 1,900,918 2,314,634 21.76%
Jul 2,421,261
Aug 2,748,612
Sep 3,152,452
Oct 3,516,273
Nov 3,759,344
Dec 4,009,000
Percent of budget 57.74%
Note: GF only
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 574,724 589,820 2.63%
Feb 1,180,291 1,223,323 3.65%
Mar 1,726,463 1,784,286 3.35%
Apr 2,346,422 2,487,675 6.02%
May 6,049,855 6,211,081 2.66%
Jun 6,972,553 7,149,225 2.53%
Jul 7,484,094
Aug 8,422,655
Sep 8,960,380
Oct 9,636,964
Nov 10,957,671
Dec 14,363,451
Percent of budget 49.77%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Millions
Intergovernmental
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions Licenses & Permits
Budget
Actual
Last Year
Page 19 of 38
City of Renton
Monthly Revenue Analysis ‐ 2016 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 598,604 640,658 7.03%
Feb 1,117,685 1,197,265 7.12%
Mar 1,699,522 1,777,230 4.57%
Apr 2,480,463 2,377,940 ‐4.13%
May 3,011,873 2,926,771 ‐2.83%
Jun 3,984,858 3,873,402 ‐2.80%
Jul 4,884,650
Aug 5,655,002
Sep 6,237,457
Oct 6,840,019
Nov 7,365,845
Dec 8,007,932
Percent of budget 48.37%
Note: Excludes FD25 & FD40 contracts
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
Jan 152,177 136,421 ‐10.35%
Feb 367,643 354,088 ‐3.69%
Mar 648,705 617,736 ‐4.77%
Apr 947,638 868,609 ‐8.34%
May 1,221,034 1,083,222 ‐11.29%
Jun 1,509,321 1,344,477 ‐10.92%
Jul 1,756,252
Aug 2,069,275
Sep 2,369,080
Oct 2,659,110
Nov 2,992,541
Dec 3,320,500
Percent of budget 40.49%
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
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 20 of 38
City of Renton
Monthly Revenue Analysis ‐ 2016 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 611,646 1,216,500 98.89%
Feb 916,494 1,525,197 66.42%
Mar 1,197,449 1,824,678 52.38%
Apr 4,800,048 7,228,286 50.59%
May 5,103,604 5,968,173 16.94%
Jun 5,569,347 6,431,675 15.48%
Jul 6,482,574
Aug 6,807,221
Sep 7,123,290
Oct 8,089,336
Nov 8,344,672
Dec 8,359,000
Percent of budget 76.94%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 199,303 258,876 29.89%
Feb 295,458 1,061,784 259.37%
Mar 417,397 1,187,734 184.56%
Apr 501,772 1,330,173 165.10%
May 602,903 1,469,677 143.77%
Jun 800,406 1,644,525 105.46%
Jul 865,007
Aug 995,183
Sep 1,301,627
Oct 1,422,614
Nov 1,534,110
Dec 1,922,616
Percent of budget 85.54%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Millions Miscellaneous
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
Millions Other Taxes
Budget
Actual
Last Year
Page 21 of 38
City of Renton
Monthly Revenue Analysis ‐ 2016 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan 20,833 ‐ 0.00%
Feb 41,667 ‐ 0.00%
Mar 62,500 ‐ 0.00%
Apr 83,333 ‐ 0.00%
May 104,167 ‐ 0.00%
Jun 6,075 6,075 0.00%
Jul 145,833
Aug 166,667
Sep 187,500
Oct 208,333
Nov 229,167
Dec 250,000
Percent of budget 2.43%
REET Budget
YTD
Actual
Annual %
over (under)
Jan 704,460 1,204,479 70.98%
Feb 966,843 1,401,806 44.99%
Mar 1,221,136 1,610,258 31.87%
Apr 1,750,788 1,946,242 11.16%
May 2,160,973 2,421,486 12.06%
Jun 2,657,005 2,826,665 6.39%
Jul 2,930,634
Aug 3,131,278
Sep 3,344,464
Oct 3,633,331
Nov 3,760,491
Dec 4,000,000
Percent of budget 70.67%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions
Real Estate Excise Tax
Budget
Actual
Last Year
$0
$2
$4
$6
$8
$10
$12
$14
$16
Mi
l
l
i
o
n
s
Other Financing Sources
Budget
Actual
Last Year
Page 22 of 38
City of Renton
Monthly Revenue Analysis ‐ 2016 Budget Year
Bldg Permits
& Devlpmt Svc
Fees Budget
YTD
Actual
Annual %
over (under)
Jan 341,282 661,363 93.79%
Feb 706,100 1,074,783 52.21%
Mar 1,025,109 1,658,442 61.78%
Apr 1,517,577 1,994,550 31.43%
May 1,808,985 2,370,874 31.06%
Jun 2,532,793 2,808,493 10.89%
Jul 3,117,823
Aug 3,496,111
Sep 3,974,931
Oct 4,400,264
Nov 4,726,378
Dec 5,173,368
Percent of budget 54.29%
B & O Tax Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb ‐ ‐ N/A
Mar ‐ ‐ N/A
Apr 4,500,000 4,578,349 1.74%
May 4,500,000 4,882,381 8.50%
Jun 4,500,000 4,912,972 9.18%
Jul 4,750,000
Aug 4,750,000
Sep 4,750,000
Oct 5,000,000
Nov 5,000,000
Dec 5,000,000
Percent of budget 98.26%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
Millions Building Permits and Development Service
Fees
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
Millions Business & Occupation Tax
Budget
Actual
Last Year
Page 23 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 9,076,609 8,625,290 ‐4.97%
Feb 18,783,983 18,026,295 ‐4.03%
Mar 28,351,504 27,039,048 ‐4.63%
Apr 37,357,304 35,281,644 ‐5.56%
May 46,665,203 44,251,964 ‐5.17%
Jun 57,454,948 53,224,181 ‐7.36%
Jul 71,394,602
Aug 82,198,759
Sep 92,730,306
Oct 102,814,396
Nov 113,026,920
Dec 125,048,276
Percent of budget expended 42.56%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 33,153 34,732 4.76%
Feb 67,972 64,182 ‐5.58%
Mar 102,703 99,419 ‐3.20%
Apr 132,696 129,027 ‐2.77%
May 163,648 156,960 ‐4.09%
Jun 194,452 186,176 ‐4.26%
Jul 224,495
Aug 254,415
Sep 284,228
Oct 314,294
Nov 344,069
Dec 375,761
Percent of budget expended 49.55%
$‐
$20
$40
$60
$80
$100
$120
$140
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
Legislative
Budget
Actual
Last Year
Page 24 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 92,301 192,359 108.40%
Feb 227,599 322,242 41.58%
Mar 363,001 486,643 34.06%
Apr 501,457 616,267 22.90%
May 639,149 744,988 16.56%
Jun 775,317 890,444 14.85%
Jul 916,869
Aug 1,146,554
Sep 1,302,813
Oct 1,437,782
Nov 1,585,169
Dec 1,784,464
Percent of budget expended 49.90%
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 175,034 157,485 ‐10.03%
Feb 349,257 326,649 ‐6.47%
Mar 527,350 498,957 ‐5.38%
Apr 710,479 670,522 ‐5.62%
May 896,957 837,538 ‐6.62%
Jun 1,092,924 1,004,061 ‐8.13%
Jul 1,282,507
Aug 1,475,680
Sep 1,671,064
Oct 1,846,482
Nov 2,021,528
Dec 2,213,353
Percent of budget expended 45.36%
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions City Attorney
Budget
Actual
Last Year
Page 25 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 169,086 163,432 ‐3.34%
Feb 345,603 335,163 ‐3.02%
Mar 524,116 508,523 ‐2.98%
Apr 706,499 678,807 ‐3.92%
May 890,985 849,557 ‐4.65%
Jun 1,081,645 1,021,277 ‐5.58%
Jul 1,265,010
Aug 1,449,036
Sep 1,627,840
Oct 1,805,361
Nov 1,978,143
Dec 2,187,710
Percent of budget expended 46.68%
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 91,015 95,028 4.41%
Feb 182,252 190,655 4.61%
Mar 273,489 286,282 4.68%
Apr 367,204 382,305 4.11%
May 461,902 478,727 3.64%
Jun 556,162 575,150 3.41%
Jul 701,359
Aug 793,589
Sep 886,107
Oct 978,401
Nov 1,070,254
Dec 1,163,302
Percent of budget expended 49.44%
$‐
$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 26 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 254,974 212,162 ‐16.79%
Feb 527,275 448,710 ‐14.90%
Mar 815,154 676,129 ‐17.06%
Apr 1,097,081 892,326 ‐18.66%
May 1,371,466 1,125,595 ‐17.93%
Jun 1,635,451 1,370,849 ‐16.18%
Jul 1,894,868
Aug 2,170,652
Sep 2,415,673
Oct 2,673,307
Nov 2,933,670
Dec 3,225,543
Percent of budget expended 42.50%
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 99,476 50,235 ‐49.50%
Feb 254,064 108,276 ‐57.38%
Mar 385,081 166,805 ‐56.68%
Apr 518,282 287,672 ‐44.50%
May 635,888 361,504 ‐43.15%
Jun 766,778 461,549 ‐39.81%
Jul 911,220
Aug 1,057,447
Sep 1,192,608
Oct 1,319,443
Nov 1,457,424
Dec 1,640,872
Percent of budget expended 28.13%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions
Economic Development
Budget
Actual
Last Year
Page 27 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 206,649 203,948 ‐1.31%
Feb 425,262 411,848 ‐3.15%
Mar 670,051 630,155 ‐5.95%
Apr 908,109 846,345 ‐6.80%
May 1,178,355 1,085,749 ‐7.86%
Jun 1,442,959 1,327,179 ‐8.02%
Jul 1,698,438
Aug 1,951,022
Sep 2,216,643
Oct 2,500,304
Nov 2,749,051
Dec 3,019,484
Percent of budget expended 43.95%
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 170,399 220,501 29.40%
Feb 348,757 434,053 24.46%
Mar 530,075 642,161 21.15%
Apr 710,548 858,782 20.86%
May 899,902 1,085,634 20.64%
Jun 1,213,989 1,337,642 10.19%
Jul 1,412,993
Aug 1,742,187
Sep 1,948,700
Oct 2,152,763
Nov 2,344,422
Dec 2,953,369
Percent of budget expended 45.29%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
$2.80
$3.20
$3.60
Millions Finance
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Planning
Budget
Actual
Last Year
Page 28 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 62,637 67,195 7.28%
Feb 164,231 168,845 2.81%
Mar 303,940 242,432 ‐20.24%
Apr 375,900 313,676 ‐16.55%
May 450,924 384,293 ‐14.78%
Jun 522,077 460,231 ‐11.85%
Jul 593,286
Aug 671,377
Sep 741,134
Oct 834,041
Nov 907,039
Dec 1,151,870
Percent of budget expended 39.96%
Includes Hearing Examiner
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 84,669 89,683 5.92%
Feb 187,462 185,388 ‐1.11%
Mar 299,503 299,054 ‐0.15%
Apr 431,140 395,008 ‐8.38%
May 540,016 491,217 ‐9.04%
Jun 651,578 584,313 ‐10.32%
Jul 766,621
Aug 881,492
Sep 993,608
Oct 1,112,638
Nov 1,219,645
Dec 1,372,669
Percent of budget expended 42.57%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
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 29 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Police Budget
YTD
Actual
Annual %
over (under)
Jan 2,968,400 2,819,381 ‐5.02%
Feb 5,611,554 5,349,745 ‐4.67%
Mar 8,680,365 8,330,684 ‐4.03%
Apr 11,315,325 10,868,880 ‐3.95%
May 14,290,090 13,787,797 ‐3.51%
Jun 17,110,693 16,379,009 ‐4.28%
Jul 20,167,107
Aug 22,840,420
Sep 25,876,796
Oct 28,602,024
Nov 31,665,502
Dec 34,856,639
Percent of budget expended 46.99%
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 2,580,892 2,291,374 ‐11.22%
Feb 5,507,406 5,299,522 ‐3.77%
Mar 7,785,755 7,516,586 ‐3.46%
Apr 10,009,632 9,575,877 ‐4.33%
May 12,237,163 11,745,775 ‐4.02%
Jun 14,516,282 12,826,352 ‐11.64%
Jul 16,843,876
Aug 19,354,057
Sep 21,698,891
Oct 23,942,067
Nov 26,284,984
Dec 28,869,022
Percent of budget expended 44.43%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Millions Police
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Millions Fire & Emergency Services
Budget
Actual
Last Year
Page 30 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 51,383 52,449 2.07%
Feb 106,296 113,335 6.62%
Mar 166,634 155,142 ‐6.90%
Apr 220,283 196,697 ‐10.71%
May 269,995 240,955 ‐10.76%
Jun 318,337 282,185 ‐11.36%
Jul 373,106
Aug 427,414
Sep 481,448
Oct 534,041
Nov 589,514
Dec 655,344
Percent of budget expended 43.06%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 336,143 302,959 ‐9.87%
Feb 700,947 615,902 ‐12.13%
Mar 1,083,549 949,380 ‐12.38%
Apr 1,459,798 1,301,241 ‐10.86%
May 1,864,820 1,638,087 ‐12.16%
Jun 2,298,738 2,027,520 ‐11.80%
Jul 2,803,971
Aug 3,298,106
Sep 3,795,912
Oct 4,241,176
Nov 4,633,809
Dec 5,065,610
Percent of budget expended 40.03%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Parks
Budget
Actual
Last Year
$0
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
Community Services Admin
Budget
Actual
Last Year
Page 31 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 75,967 46,446 ‐38.86%
Feb 155,277 103,226 ‐33.52%
Mar 253,324 165,213 ‐34.78%
Apr 346,004 211,159 ‐38.97%
May 467,457 300,170 ‐35.79%
Jun 559,036 394,070 ‐29.51%
Jul 680,904
Aug 791,212
Sep 915,691
Oct 1,046,163
Nov 1,169,288
Dec 1,292,543
Percent of budget expended 30.49%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 333,154 330,010 ‐0.94%
Feb 695,736 697,557 0.26%
Mar 1,066,633 1,078,551 1.12%
Apr 1,449,320 1,463,787 1.00%
May 1,833,378 1,843,391 0.55%
Jun 2,256,569 2,255,376 ‐0.05%
Jul 2,918,647
Aug 3,604,160
Sep 4,146,992
Oct 4,519,771
Nov 4,905,664
Dec 5,350,288
Percent of budget expended 42.15%
$‐
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
$1,400,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 32 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 49,625 81,352 63.93%
Feb 126,381 213,832 69.20%
Mar 264,698 269,088 1.66%
Apr 420,012 395,807 ‐5.76%
May 487,819 476,551 ‐2.31%
Jun 554,870 528,283 ‐4.79%
Jul 695,477
Aug 788,488
Sep 850,143
Oct 1,008,843
Nov 1,069,886
Dec 1,258,447
Percent of budget expended 41.98%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 68,319 66,354 ‐2.88%
Feb 166,692 144,459 ‐13.34%
Mar 238,120 213,473 ‐10.35%
Apr 307,504 268,788 ‐12.59%
May 377,816 335,059 ‐11.32%
Jun 462,305 392,885 ‐15.02%
Jul 593,251
Aug 692,978
Sep 787,459
Oct 869,444
Nov 954,065
Dec 1,096,033
Percent of budget expended 35.85%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions Human Services
Budget
Actual
Last Year
$‐
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
Neighborhoods, Resources, and Events
Budget
Actual
Last Year
Page 33 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 18,883 19,061 0.94%
Feb 37,795 37,570 ‐0.59%
Mar 56,682 55,330 ‐2.39%
Apr 75,818 73,438 ‐3.14%
May 95,501 92,699 ‐2.93%
Jun 115,297 112,304 ‐2.60%
Jul 135,152
Aug 155,440
Sep 175,323
Oct 195,438
Nov 215,317
Dec 235,281
Percent of budget expended 47.73%
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 33,648 33,119 ‐1.57%
Feb 68,336 67,230 ‐1.62%
Mar 102,357 100,509 ‐1.81%
Apr 136,585 133,872 ‐1.99%
May 171,018 167,151 ‐2.26%
Jun 205,573 200,630 ‐2.40%
Jul 240,151
Aug 275,209
Sep 310,708
Oct 344,670
Nov 378,434
Dec 413,579
Percent of budget expended 48.51%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
Public Works Admin
Budget
Actual
Last Year
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
$240,000
$270,000
Museum Fund
Budget
Actual
Last Year
Page 34 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 395,932 400,277 1.10%
Feb 817,377 805,426 ‐1.46%
Mar 1,243,762 1,236,414 ‐0.59%
Apr 1,720,451 1,676,774 ‐2.54%
May 2,164,177 2,087,428 ‐3.55%
Jun 2,612,305 2,494,337 ‐4.52%
Jul 3,090,003
Aug 3,565,717
Sep 4,014,860
Oct 4,501,814
Nov 4,933,704
Dec 5,420,445
Percent of budget expended 46.02%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 385,313 356,191 ‐7.56%
Feb 848,593 720,619 ‐15.08%
Mar 1,402,988 1,219,946 ‐13.05%
Apr 1,985,654 1,593,069 ‐19.77%
May 2,460,643 2,119,001 ‐13.88%
Jun 2,936,948 2,537,694 ‐13.59%
Jul 3,428,357
Aug 3,947,043
Sep 4,422,467
Oct 4,952,795
Nov 5,426,873
Dec 6,149,047
Percent of budget expended 41.27%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Street Maintenance
Budget
Actual
Last Year
$0.0
$1.0
$2.0
$3.0
$4.0
$5.0
$6.0
$7.0
Millions Transportation
Budget
Actual
Last Year
Page 35 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 44,758 44,758 0.00%
Feb 295,075 295,075 0.00%
Mar 295,075 295,075 0.00%
Apr 295,075 295,075 0.00%
May 295,075 295,075 0.00%
Jun 936,921 936,921 0.00%
Jul 3,645,061
Aug 4,165,784
Sep 4,686,507
Oct 5,207,230
Nov 5,727,953
Dec 6,248,676
Percent of budget expended 14.99%
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 294,800 294,800 0.00%
Feb 566,783 566,783 0.00%
Mar 917,099 917,099 0.00%
Apr 1,156,445 1,156,445 0.00%
May 1,521,060 1,521,060 0.00%
Jun 2,637,745 2,637,745 0.00%
Jul 4,111,872
Aug 4,699,283
Sep 5,286,693
Oct 5,874,103
Nov 6,461,514
Dec 7,048,924
Percent of budget expended 37.42%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
$9.00
$10.00
Millions Non‐Departmental Other City Services
Budget
Actual
Last Year
$‐
$5
$10
$15
$20
$25
Millions Debt Service
Budget
Actual
Last Year
Page 36 of 38
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2016 Budget Year
Utilities Budget Revenue Expense
Jan 6,221,803 6,349,407 3,113,758
Feb 16,178,186 12,660,071 7,764,200
Mar 23,982,509 18,599,026 12,419,394
Apr 29,893,898 24,660,335 17,069,879
May 39,799,392 30,851,439 21,831,008
Jun 52,110,648 37,253,721 28,479,554
Jul 59,609,524
Aug 67,816,343
Sep 76,250,053
Oct 84,074,531
Nov 92,029,531
Dec 107,022,956
Percent of budget expended 21.30%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan 252,834 379,338 102,054
Feb 693,487 746,998 246,569
Mar 3,774,376 1,127,792 409,998
Apr 4,769,280 1,367,786 567,432
May 7,091,951 1,614,567 695,455
Jun 7,846,061 1,834,885 845,678
Jul 8,724,109
Aug 9,883,320
Sep 10,864,768
Oct 11,604,431
Nov 12,859,109
Dec 14,164,354
Percent of budget expended 5.97%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
Millions Utilities
Budget
Revenue
Expense
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
Millions Airport
Budget
Revenue
Expense
Page 37 of 38
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2016 Budget Year
Golf Course Budget Revenue Expense
Jan 116,391 72,468 118,352
Feb 266,941 183,666 290,598
Mar 417,955 302,635 438,062
Apr 589,411 534,799 625,491
May 810,690 828,065 790,152
Jun 967,871 1,133,239 974,444
Jul 1,135,836
Aug 1,308,140
Sep 1,481,465
Oct 1,678,887
Nov 1,805,131
Dec 2,295,432
Percent of budget expended 42.45%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
Millions Golf Course
Budget
Revenue
Expense
Page 38 of 38