HomeMy WebLinkAbout201610, OctoberADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: January 4, 2017
TO: Armondo Pavone, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: October 2016 Financial Status Report
At the end of October, general governmental revenues show $6.2 million or 6.6% over budget.
Revenue source(s) that are higher than expected are: sales tax ($1.8 million); sales tax annexation
credit ($294k); utility taxes ($456k); gambling taxes ($823k); real estate excise taxes ($571k);
business & occupation taxes ($1.2 million); state shared revenues ($313k); franchise fees ($164k);
building permits & development service fees ($128k); public safety ($302k); seizure funds ($753k,
restricted to drug enforcement and not available for general purposes) and other miscellaneous
($150k). If we remove seizure funds, general governmental revenues are $5.4 million or 5.8%
over budget. On the down side, the revenue source(s) that are underperforming the year to date
budget are property tax ($173k below); recreation ($107k below); interfund/interdept services
($303k below) and fines & penalties ($378k below).
General government expenditures showed a favorable variance of $4 million or 4.1%. 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 30,840,418 36,369,429 26,190,113 37,213,314 26,797,806 26,624,443 (173,362) ‐0.6%
Sales Tax 21,512,379 17,717,601 23,439,266 19,259,460 23,999,421 19,785,635 21,616,737 1,831,101 9.3%
Sales Tax ‐ Annexation Credit 2,542,394 2,092,854 2,778,858 2,283,449 2,748,167 2,260,147 2,554,108 293,961 13.0%
Criminal Justice Sales Tax 2,267,947 1,865,100 2,484,718 2,048,498 2,580,795 2,125,164 2,233,414 108,250 5.1%
Natural Gas Use Tax 271,485 239,530 228,899 186,842 268,000 218,758 159,276 (59,482) ‐27.2%
Admission Tax 310,311 310,311 309,790 309,755 320,000 319,982 261,054 (58,928) ‐18.4%
Franchise Fees 1,342,269 1,292,767 1,349,154 1,349,154 1,260,000 1,236,825 1,401,242 164,417 13.3%
Electricity Tax 5,167,444 4,317,284 5,012,962 4,089,520 4,946,019 4,084,337 4,526,885 442,547 10.8%
Natural Gas Utility Tax 1,562,341 1,311,136 1,437,552 1,183,915 1,350,900 1,123,562 1,103,314 (20,248) ‐1.8%
Garbage/Solid Waste 573,457 482,788 638,073 521,082 580,000 480,586 597,420 116,834 24.3%
TV Cable 1,518,821 1,253,377 1,591,866 1,313,457 1,629,365 1,344,497 1,333,081 (11,416) ‐0.8%
Telephone 909,088 756,033 880,233 737,536 952,500 795,064 755,928 (39,136) ‐4.9%
Cellular Phone 1,951,925 1,552,142 1,674,355 1,395,827 1,671,056 1,358,478 1,409,840 51,362 3.8%
City Utilities 3,961,052 3,337,959 4,183,165 3,527,585 4,208,377 3,547,646 3,523,212 (24,434) ‐0.7%
Utility Tax Audit 460,513 460,513 1,962,092 1,446,078 111,227 111,227 111,227 ‐ 0.0%
Leasehold Excise Tax 171,470 130,132 163,314 123,703 179,000 135,718 133,042 (2,676) ‐2.0%
Gambling Excise Tax 1,650,384 1,344,493 2,299,156 1,894,300 1,600,000 1,312,069 2,135,335 823,266 62.7%
Real Estate Excise Tax 4,348,762 4,032,907 4,595,166 3,832,325 4,000,000 4,740,895 5,312,309 571,414 12.1%
Less: CIP REET (1,650,000) (764,850) (1,401,300) (958,081) (2,000,000) (2,656,155) (2,656,155) ‐ 0.0%
EMS Levy 916,361 676,175 936,406 702,305 1,069,454 479,597 479,597 ‐ 0.0%
B&O Taxes ‐ ‐ ‐ ‐ 5,000,000 5,000,000 6,238,389 1,238,389 24.8%
Less: CIP B&O Taxes ‐ ‐ ‐ ‐ (2,000,000) (2,000,000) (2,000,000) ‐ 0.0%
Business License Fees 2,965,850 2,837,151 3,125,740 2,990,092 1,921,000 1,837,672 1,822,085 (15,586) ‐0.8%
Less: CIP Business License Fees (2,450,295) (2,344,149) (2,584,164) (2,472,795) (1,619,000) (1,549,051) (1,504,502) 44,549 ‐2.9%
Animal Licenses and Spec Events Permits 95,698 88,608 101,743 90,597 91,000 82,256 87,498 5,242 6.4%
Building Permits & Development Svc Fees 4,519,234 3,824,884 6,077,055 5,157,161 5,173,368 4,400,264 4,527,811 127,547 2.9%
Intergovt'l (Grants, State Shared, etc) 4,522,540 3,632,238 4,053,617 3,210,136 4,582,476 3,063,686 3,256,481 192,794 6.3%
Fire District 25 and 40 Contracts 5,959,428 3,776,634 6,369,132 3,422,728 6,128,712 3,517,779 3,517,779 ‐ 0.0%
Public Safety 844,375 741,163 649,797 552,074 630,135 545,578 847,943 302,365 55.4%
Culture and Recreation 1,485,123 1,419,612 1,587,878 1,483,946 1,727,393 1,632,145 1,525,104 (107,041) ‐6.6%
Interfund/Interdept‐Services 3,270,503 2,752,705 3,106,430 2,623,464 3,689,406 3,074,505 2,771,059 (303,446) ‐9.9%
Fines and Penalties 962,977 826,977 848,052 663,385 1,126,500 928,633 694,350 (234,283) ‐25.2%
Photo Enforcement 1,719,971 1,312,473 2,171,184 1,756,603 2,194,000 1,730,477 1,586,861 (143,616) ‐8.3%
Seizure Funds ‐ Federal/State/Local 68,870 59,593 21,676 21,676 50,000 44,877 798,230 753,353 1678.7%
Interests and Other Earnings 981,630 545,901 973,208 575,152 875,300 501,964 594,358 92,394 18.4%
Rents, Leases, and Concessions 711,070 660,858 762,361 703,210 598,616 554,185 594,367 40,182 7.3%
Contributions and Donations 113,626 90,257 147,292 124,712 96,700 79,671 87,038 7,367 9.2%
Other Miscellaneous 879,105 683,136 941,127 767,974 705,630 574,840 725,263 150,423 26.2%
Other Financing Sources (Transfer ‐In, etc) 48,632 41,880 270,224 7,607 252,014 6,075 6,075 ‐ 0.0%
Total Operating Revenues 111,782,133 94,198,592 119,555,505 93,114,545 119,910,845 93,627,396 99,791,497 6,164,102 6.6%
OPERATING EXPENDITURES
Council 309,317 259,383 320,877 267,722 375,761 314,294 300,668 13,626 4.3%
Executive 1,338,738 1,082,383 1,691,189 1,358,895 1,784,464 1,437,782 1,463,344 (25,562) ‐1.8%
City Attorney 1,829,254 1,509,944 1,791,167 1,510,380 2,213,353 1,846,482 1,676,659 169,823 9.2%
Court Services 2,016,273 1,656,337 2,013,364 1,669,036 2,187,710 1,805,361 1,718,898 86,463 4.8%
Community and Eco Dvlpmnt Admin 1,010,761 840,615 1,183,052 1,004,505 1,163,302 978,401 960,176 18,225 1.9%
Development Services 2,659,078 2,210,589 2,632,264 2,174,837 3,197,543 2,650,101 2,365,335 284,766 10.7%
Economic Development 654,007 520,262 658,515 535,152 1,666,858 1,340,339 830,695 509,644 38.0%
Planning 2,095,706 1,698,142 2,606,551 2,195,594 3,019,484 2,500,304 2,274,192 226,113 9.0%
Finance 2,644,827 1,946,971 3,132,812 2,264,451 2,953,369 2,152,763 2,246,608 (93,845) ‐4.4%
City Clerk 1,152,246 850,302 1,027,084 727,698 1,151,870 834,041 758,024 76,017 9.1%
Human Resources 922,668 749,118 1,182,629 957,363 1,372,669 1,112,638 987,507 125,132 11.2%
Police 26,383,640 21,495,226 28,144,699 23,140,025 30,153,639 24,682,857 23,568,025 1,114,832 4.5%
Jail Services 3,760,273 3,133,886 4,142,266 3,452,459 4,703,000 3,920,703 3,920,703 ‐ 0.0%
Fire 25,240,760 21,014,198 26,536,999 21,926,869 28,869,022 25,667,731 25,667,731 ‐ 0.0%
Community Services Admin 480,057 386,909 508,766 418,885 655,344 534,041 452,338 81,704 15.3%
Parks 4,070,181 3,425,754 4,411,383 3,675,425 5,065,610 4,241,176 3,734,313 506,863 12.0%
Parks Planning & Natural Resources 722,739 579,547 808,558 659,859 1,292,543 1,046,163 732,271 313,891 30.0%
Recreation 4,823,865 4,070,633 5,088,483 4,303,035 5,350,288 4,519,771 4,344,481 175,290 3.9%
Human Services 1,159,189 922,589 1,225,835 989,382 1,260,461 1,010,457 958,095 52,362 5.2%
Neighborhoods, Resources, & Events 875,223 680,570 958,624 774,155 1,096,033 869,444 692,390 177,054 20.4%
Museum 214,291 177,396 227,094 189,243 235,281 195,438 190,760 4,678 2.4%
Public Works Admin 389,493 323,823 387,493 323,704 413,579 344,670 333,632 11,038 3.2%
Street Maintenance 4,503,315 3,746,215 5,061,723 4,197,786 5,420,445 4,501,814 4,195,645 306,169 6.8%
Transportation 4,263,725 3,432,741 4,975,059 4,008,706 6,149,047 4,952,795 5,049,376 (96,581) ‐2.0%
Debt Service 8,393,140 3,858,787 6,371,715 1,547,614 6,248,676 1,448,946 1,448,946 ‐ 0.0%
Non‐Departmental and Other 9,758,346 7,523,227 10,069,740 6,317,413 7,048,924 3,549,024 3,549,024 ‐ 0.0%
Total Operating Expenditures 111,671,112 88,095,548 117,157,942 90,590,196 125,048,276 98,457,536 94,419,834 4,037,702 4.1%
Total Ending Fund Balance 17,565,282$ 23,557,305$ 19,962,846$ 20,089,631$ 14,825,414$ 15,132,704$ 25,334,508$ 10,201,804$ 67.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 October 2016
Page 1 of 37
Monthly Financial Report October 2016
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through October 31, 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
October’s collection is $6.2
million, making the total year‐to‐
date collection $26.6 million or
71.5% of the total budget. In
comparison to the previous year,
the City collected $434k or 2%
more. Compared to the budget,
the City collecting $173k or 1%
less. The April/May variance is
due to the timing of collections in
the current year compared to the
prior year.
Sales Tax
October 2016 sales tax receipts
totaled $2.4 million. Compared
with the same month last year, it
is $396k or 20% more. Compared
to the projected current month’s
budget, it is $311k or 15% above.
The year‐to‐date collection of
$21.6 million is $2.4 million or
12% more than the prior year and
is also $1.8 million or 9% more
than budgeted. New
Construction, General Retail, 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 57,174 (8,221) ‐13% (9,739) ‐15%
Aug 94,817 97,017 240,536 145,720 154% 143,520 148%
Sep 561,525 574,554 558,716 (2,809) ‐1% (15,838) ‐3%
Oct 6,263,616 6,408,951 6,233,910 (29,706) 0% (175,042) ‐3%
Nov 9,975,046 10,206,498
Dec 204,271 209,010
YTD Total 26,190,113$ 26,797,806$ 26,624,443$ 434,330$ 2% (173,362)$ ‐1%
Annual Total 36,369,429$ 37,213,314$
Property Tax Revenues
Year to Date through October
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 2,103,896 236,948 13% 196,347 10%
Aug 2,178,289 2,108,862 2,438,277 259,988 12% 329,415 16%
Sep 2,100,591 2,030,965 2,179,438 78,848 4% 148,473 7%
Oct 2,014,951 2,100,010 2,410,824 395,874 20% 310,814 15%
Nov 2,158,753 2,153,518 ‐
Dec 2,021,053 2,060,268 ‐
YTD Total 19,259,460$ 19,785,635$ 21,616,737$ 2,357,277$ 12% 1,831,101$ 9%
Annual Total 23,439,266$ 23,999,421$
2016 vs. Budget2016 vs. 2015
Month
Year to Date through October
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report October 2016
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
October utility tax revenues are
$1.4 million, which is $147k or
12% higher than the same month
last year and is higher than the
budget by $158k or 13%. The
year‐to‐date collection is $13.5
million, which is $882k or 6%
lower than the prior year but is
$456k or 3% higher than the
budget. The large June/July
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 1,276,335 (898,831) ‐41% 111,175 10%
Aug 1,351,000 1,299,385 1,247,926 (103,074) ‐8% (51,459) ‐4%
Sep 1,214,144 1,203,343 1,277,502 63,358 5% 74,158 6%
Oct 1,204,406 1,193,676 1,351,888 147,482 12% 158,212 13%
Nov 1,342,058 1,262,186
Dec 1,865,296 1,391,102
YTD Total 14,401,842$ 13,064,155$ 13,520,182$ (881,660)$ ‐6% 456,027$ 3%
Annual Total 17,609,196$ 15,717,444$
2016 vs. Budget2016 vs. 2015
Year to Date through October
Utility Tax Revenues
Month
Sales Tax by Sector 2015 2016 Bgt YTD Act Change 2016/2015 2016 Act vs Bgt
New Construction 2,359,723$ 2,686,684$ 3,779,103$ 1,419,380$ 60%$ 1,092,419 41%
Auto Sales 3,807,998 3,922,682 4,008,906 200,907 5% 86,223 2%
General Retail 5,913,132 5,938,852 6,049,049 135,916 2% 110,196 2%
Manufacturing 1,441,714 1,403,287 1,474,889 33,175 2% 71,602 5%
Wholesale 990,949 1,001,985 1,044,478 53,528 5% 42,493 4%
Service 4,267,401 4,312,959 4,678,744 411,343 10% 365,785 8%
Other 478,542 519,186 581,569 103,027 22% 62,383 12%
YTD Total 19,259,460$ 19,785,635$ 21,616,737$ 2,357,277$ 12%1,831,101$ 9%
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 4,089,520$ 4,084,337$ 4,526,885$ 437,364$ 11%$ 442,547 11%
Natural Gas 1,370,757 1,342,320 1,262,590 (108,167) ‐8% (79,730)‐6%
Cell 1,395,827 1,358,478 1,409,840 14,012 1% 51,362 4%
Phone 737,536 795,064 755,928 18,392 2% (39,136)‐5%
Cable 1,313,457 1,344,497 1,333,081 19,624 1% (11,416)‐1%
Garbage/Solid Waste 521,082 480,586 597,420 76,338 15% 116,834 24%
City Utilities 3,527,585 3,547,646 3,523,212 (4,373) 0% (24,434)‐1%
Utility Tax Audit 1,446,078 111,227 111,227 (1,334,851) ‐92% ‐ 0%
YTD Total 14,401,842$ 13,064,155$ 13,520,182$ (881,660)$ ‐6%456,027$ 3%
Annual Total 17,609,196$ 15,717,444$
YTD as % of 82% 83%
Page 3 of 37
Monthly Financial Report October 2016
Other Taxes
Real Estate Excise Tax
The City collected $560k in Real
Estate Excise Tax revenues (REET)
for October. This is $62k or 12%
more than the same month last
year and is also $33k or 6% more
than the current month’s budget.
The year‐to‐date collection is
$5.3 million, which is $1.5 million
or 39% more than the prior year
and is also $571k or 12% above
the budget. The higher than
expected variance is due to 21
large transactions in December,
January, April, June, July, August,
and September which accounts
for $2.5 million of the total REET collected.
Gambling Tax
October’s Gambling Tax
collections totaled $242k, which
is $27k or 13% above the same
month last year and is above the
current month’s budget by $92k
or 61%. The year‐to‐date total of
$2.1 million is $241k or 13%
above the prior year and is also
$823k or 63% above budget.
$165k of the year‐to‐date
collections are from a payment
plan of back taxes earned in
2013/2014.
Pull tabs overall had a 1%
decrease, bingo had a 94%
decrease (bingo establishment closed December 2015), and card‐rooms are seeing 12% 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 $1.4 million is $52k or 4%
higher than the prior year and is
also $164k or 13% 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 561,776 644,038 80,564 14% 82,262 15%
Aug 281,921 546,907 759,583 477,662 169% 212,676 39%
Sep 449,693 448,739 522,472 72,778 16% 73,732 16%
Oct 497,978 526,469 559,552 61,574 12% 33,083 6%
Nov 325,743 74,079
Dec 437,098 (814,974)
YTD Total 3,832,325$ 4,740,895$ 5,312,309$ 1,479,985$ 39% 571,414$ 12%
Annual Total 4,595,166$ 4,000,000$
Real Estate Excise Tax Revenues
Year to Date through October
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 194,317 (578) 0% 65,701 51%
Aug 226,785 144,692 322,828 96,043 42% 178,136 123%
Sep 180,986 129,810 202,409 21,423 12% 72,600 56%
Oct 215,119 150,141 242,254 27,135 13% 92,113 61%
Nov 212,838 149,793 ‐
Dec 192,018 138,138 ‐
YTD Total 1,894,300$ 1,312,069$ 2,135,335$ 241,035$ 13% 823,266$ 63%
Annual Total 2,299,156$ 1,600,000$
Gambling Tax Revenue
Month
Year to Date through October
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 343,910 3,254 1% 32,621 10%
Sep ‐ ‐ 5,000 5,000 100% 5,000 100%
Oct 339,936 309,807 348,783 8,847 3% 38,976 13%
Dec ‐ 23,175 ‐
YTD Total 1,349,154$ 1,236,825$ 1,401,242$ 52,088$ 4% 164,417$ 13%
Annual Total 1,349,154$ 1,260,000$
Month
2016 vs. 2015 2016 vs. Budget
Franchise Fees Revenue
Year to Date through October
Page 4 of 37
Monthly Financial Report October 2016
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year.
October 2016 collections
represent activities conducted
during the 3rd quarter of 2016.
The year‐to‐date collection of
$261k is $47k or 16% less than
the prior year and is also $58k or
18% less than the budget. The
decline in revenue is due to the
closure of Regal East Valley 13
Theater at the end of 2015.
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 $6.2 million. This
is due to one business reporting a
full year’s worth of activity.
Licenses and Permits
Business Licenses
Business Licenses totaled $218k
for October, which is $419k or
66% below the same month last
year but is $22k or 11% above the
current month’s budget. The
year‐to‐date Business Licenses
revenue of $1.8 million is $1.2
million or 39% below the prior
year and is also below the budget
by $16k or 1%. 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 60,763 (22,042) ‐27% (22,803) ‐27%
Sep ‐ ‐ 518 518 100% 518 100%
Oct 75,167 78,334 58,934 (16,233) ‐22% (19,400) ‐25%
Nov 35 18 ‐
YTD Total 309,755$ 319,982$ 261,054$ (47,071)$ ‐16% (58,012)$ ‐18%
Annual Total 309,790$ 320,000$
2016 vs. Budget
Admission Tax Revenue
Year to Date through October
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 376,209 376,209 100% 126,209 50%
Aug ‐ ‐ 334,807 334,807 100% 334,807 100%
Sep ‐ ‐ 10,779 10,779 100% 10,779 100%
Oct ‐ 250,000 603,622 603,622 100% 353,622 141%
Nov ‐ ‐ ‐
Dec ‐ ‐ ‐
YTD Total ‐$ 5,000,000$ 6,238,389$ 6,238,389$ 100% 1,238,389$ 25%
Annual Total ‐$ 5,000,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through October
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 248,769 (397,022) ‐61% 43,971 21%
Aug 134,328 72,612 121,095 (13,233) ‐10% 48,483 67%
Sep 29,333 18,289 22,190 (7,143) ‐24% 3,901 21%
Oct 637,451 196,327 218,271 (419,180) ‐66% 21,944 11%
Nov 117,394 71,061 ‐
Dec 18,254 12,268 ‐
YTD Total 2,990,092$ 1,837,672$ 1,822,085$ (1,168,007)$ ‐39% (15,586)$ ‐1%
Annual Total 3,125,740$ 1,921,000$
*Total Business License (GF & CIP)
2016 vs. 2015
Year to Date through October
2016 vs. Budget
Business Licenses*
Month
Page 5 of 37
Monthly Financial Report October 2016
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $479k in
October. The year‐to‐date
development fees revenue of
$4.5 million is $629k or 12% less
than the year before but is $128k
or 3% higher than budget. The
large variances in January,
March, June and July are due to
large payments for building
permits and plan review
(Southport Developer, Group
Health, Boeing and Paccar).
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 90%
of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $9.5 million or 66% of the budget.
State Shared Revenues
State Shared Revenue
collections totaled $5
million since the start of
the year. Compared to
the prior year, State
Shared Revenues are
above by $611k or 14%.
Compared to the
projected budget, the
City is collecting $313k
or 7% more. The higher
than expected collection
is due to collecting more
than anticipated
Criminal Justice’s Sales Tax and Criminal Justice’s High Crime.
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 462,211 (411,337) ‐47% (122,819) ‐21%
Aug 454,971 378,288 397,578 (57,393) ‐13% 19,290 5%
Sep 586,213 478,819 380,480 (205,733) ‐35% (98,339) ‐21%
Oct 462,191 425,333 479,048 16,857 4% 53,715 13%
Nov 427,863 326,114
Dec 492,031 446,990
YTD Total 5,157,161$ 4,400,264$ 4,527,811$ (629,350)$ ‐12% 127,547$ 3%
Annual Total 6,077,055$ 5,173,368$
Year to Date through October
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 682,084$ 698,123$ 698,123$ 16,039$ 2% $ ‐ 0%
Fire District #40 2,739,445 2,819,656 2,819,656 80,211 3%‐ 0%
State Shared Revenue 4,384,575 4,683,054 4,996,026 611,451 14% 312,971 7%
Federal Grants 655,667 276,131 276,131 (379,536) ‐58%‐ 0%
State Grants 39,894 51,275 51,274 11,381 29%‐ 0%
Other Grants/Intgovt 880,802 657,987 646,061 (234,742) ‐27% (11,927) ‐2%
ARRA Grants ‐ 0 ‐ ‐ N/A ‐ 0%
Total Rev YTD 9,382,466$ 9,186,226$ 9,487,270$ 104,804$ 1%301,044$ 3%
Total Rev Annual 13,842,673$ 14,361,437$
YTD % 68% 64% 66%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2015 2016 2016
Actual Budget Actual $ % $ %
Crim Just Sales Tax 2,048,498$ 2,125,164$ 2,233,414$ 184,916$ 9% 108,250$ 5%
Judicial Contribution 21,873 ‐ 18,092 (3,781) ‐17% 18,092 100%
Crim Just ‐ High Crime 125,694 177,116 289,982 164,287 131% 112,866 64%
Crim Just ‐ Pop 25,972 24,000 27,122 1,149 4% 3,122 13%
Crim Just ‐ Spec Prog 95,162 89,000 98,887 3,725 4% 9,887 11%
State DUI 14,725 17,000 15,353 628 4% (1,647) ‐10%
Marijuana Enforcement 2,929 ‐ 17,739 14,811 506% 17,739 100%
Liquor Profits 638,833 637,643 636,375 (2,457) 0% (1,267) 0%
Liquor Excise Tax 264,628 440,000 459,427 194,799 74% 19,427 4%
Fuel Tax 1,146,260 1,173,132 1,199,634 53,374 5% 26,502 2%
YTD Total 4,384,575$ 4,683,054$ 4,996,026$ 611,451$ 14% 312,971$ 7%
Annual Total 5,439,235$ 5,672,795$
State Shared Revenues
2016 vs. 2015
Revenue
Year to Date through October
2016 vs. Budget
Page 6 of 37
Monthly Financial Report October 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
64% of the total revenue in this category. The year‐to‐date total charges for services are $6.7 million or 84% of the budget.
The following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$848k 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 $295k or 53%
more. Compared to the year‐to‐
date budget, the City is over
budget by $302k or 55%. The
variance with the prior year and
budget is due to collecting 4 large
payments/reimbursements for
electronic home detention and
School Resource Officer programs.
Recreation
Recreation revenues totaled
$46k for the current month.
Compared to the same month
the prior year, the City collected
$10k or 18% less. Compared to
the projected monthly budget,
the City collected $26k or 37%
less. The year‐to‐date collection
of $1.5 million is $41k or 3%
higher than the year before but is
$107k or 7% lower 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 $112k 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 34,906 (4,634) ‐12% (5,388) ‐13%
Aug 59,046 51,865 44,439 (14,608) ‐25% (7,426) ‐14%
Sep 23,104 28,310 67,570 44,466 192% 39,261 139%
Oct 33,339 94,331 160,438 127,100 381% 66,107 70%
Nov 46,384 35,303 ‐
Dec 51,339 49,254 ‐
YTD Total 553,274$ 545,578$ 847,943$ 294,669$ 53% 302,365$ 55%
Annual Total 650,997$ 630,135$
2016 vs. Budget
Month
2016 vs. 2015
Year to Date through October
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 325,043 (103,900) ‐24% (95,203) ‐23%
Aug 313,197 314,325 349,650 36,453 12% 35,325 11%
Sep 119,720 134,250 107,652 (12,068) ‐10% (26,598) ‐20%
Oct 55,478 72,003 45,706 (9,772) ‐18% (26,297) ‐37%
Nov 61,601 55,079 ‐
Dec 42,331 40,169 ‐
YTD Total 1,483,946$ 1,632,145$ 1,525,104$ 41,158$ 3% (107,041)$ ‐7%
Annual Total 1,587,878$ 1,727,393$
2016 vs. Budget2016 vs. 2015
Month
Recreation
Year to Date through October
Page 7 of 37
Monthly Financial Report October 2016
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$2.8 million. Compared to the
prior year, the revenues are over
by $148k or 6%. Compared to the
projected budget, the revenues
are below by $303k or 10%.
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
$2.3 million. This is $139k or 6%
lower than a year ago and is also
$378k or 14% 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 259,888 7,438 3% (47,562) ‐15%
Aug 248,774 307,451 273,851 25,076 10% (33,600) ‐11%
Sep 247,822 307,451 286,057 38,236 15% (21,393) ‐7%
Oct 283,145 307,451 277,517 (5,628) ‐2% (29,934) ‐10%
Nov 257,874 307,451 ‐
Dec 225,093 307,451 ‐
YTD Total 2,623,464$ 3,074,505$ 2,771,059$ 147,595$ 6% (303,446)$ ‐10%
Annual Total 3,106,430$ 3,689,406$
2016 vs. Budget
Month
Interfund Services
Year to Date through October
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 222,267 318 0% (24,663) ‐10%
Aug 280,257 313,023 274,964 (5,293) ‐2% (38,059) ‐12%
Sep 272,343 299,806 200,986 (71,357) ‐26% (98,820) ‐33%
Oct 260,327 290,029 238,517 (21,810) ‐8% (51,512) ‐18%
Nov 281,222 333,431
Dec 318,027 327,959
YTD Total 2,419,988$ 2,659,110$ 2,281,211$ (138,777)$ ‐6% (377,899)$ ‐14%
Annual Total 3,019,236$ 3,320,500$
Month
2016 vs. Budget2016 vs. 2015
Year to Date through October
Fines and Penalties by Month
Year to Date through October
2015 2016 2016
Actual Budget Actual $ % $ %
Civil Penalties 2,619$ 12,751$ 1,872$ (747)$ ‐29% (10,879)$ ‐85%
Civil Infraction Penalties 306,757 504,886 276,021 (30,736) ‐10% (228,864) ‐45%
Civil Parking Infraction Penalties 127,771 162,210 131,371 3,600 3% (30,839) ‐19%
Photo Enforcement Program 1,756,603 1,730,477 1,586,861 (169,742) ‐10% (143,616) ‐8%
Criminal Traffic Misdemeanor Fines 66,670 90,412 61,921 (4,750) ‐7% (28,491) ‐32%
Criminal Non‐Traffic Fines 48,529 38,232 21,067 (27,461) ‐57% (17,165) ‐45%
Criminal Costs 81,459 101,815 74,861 (6,598) ‐8% (26,954) ‐26%
Non‐Court Fines, Forfeitures and Penalties 29,579 18,328 127,237 97,658 330% 108,909 594%
YTD Total 2,419,988$ 2,659,110$ 2,281,211$ (138,777)$ ‐6% (377,899)$ ‐14%
Annual Total 3,019,236$ 3,320,500$
Revenue
2016 vs. Budget
Fines and Penalties by Type
2016 vs. 2015
Page 8 of 37
Monthly Financial Report October 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 $1.6 million.
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 $2.4 million.
Compared to last year, the
revenues are above by $650k or
36%. Compared to the projected
year‐to‐date budget, the
revenues are over by $1 million
or 71%. 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 181,285 (8,628) ‐5% 116,684 181%
Aug 199,969 130,176 294,665 94,696 47% 164,489 126%
Sep 139,977 306,444 160,616 20,638 15% (145,828) ‐48%
Oct 173,512 120,987 152,817 (20,695) ‐12% 31,830 26%
Nov 148,227 111,497
Dec 435,114 388,506
YTD Total 1,784,234$ 1,422,614$ 2,433,908$ 649,673$ 36% 1,011,294$ 71%
Annual Total 2,367,576$ 1,922,616$
Year to Date through October
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 144,672 89,912 95,037 49,635
Aug 221,543 154,121 89,912 94,934 59,187
Sep 213,406 130,456 89,912 94,875 35,580
Oct 195,225 169,329 89,912 94,953 74,376
Nov 218,318 ‐ 89,912 ‐ ‐
Dec 245,205 ‐ 89,912 ‐ ‐
YTD Total 1,730,477$ 1,586,861$ 899,119$ 884,015$ 702,846$
Annual Total 2,194,000$ 1,078,943$
1Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through October
Month
Revenues Expenses
2015 2016 2016
Actual Budget Actual $ % $ %
Interests and Other Earnings 575,152$ 501,964$ 594,358$ 19,206$ 3% 92,394$ 18%
Rents, Leases, and Concessions 703,210 554,185 594,367 (108,843) ‐15% 40,182 7%
Contributions/Donations from Private Sources 124,712 79,671 87,038 (37,674) ‐30% 7,367 9%
Other 359,484 241,917 359,915 431 0% 117,998 49%
Seizure Funds ‐ Federal/State/Local 21,676 44,877 798,230 776,554 3582% 753,353 1679%
YTD Total 1,784,234$ 1,422,614$ 2,433,908$ 649,673$ 36% 1,011,294$ 71%
Annual Total 2,367,576$ 1,922,616$
2016 vs. Budget
Miscellaneous Revenues by Type
Year to Date through October
Revenue
2016 vs. 2015
Page 9 of 37
Monthly Financial Report October 2016
EXPENSES
Overall the City has expended 76% of its budgeted general governmental expenditures at the end of October. This is $4
million or 4.1% 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 $26k or 1.8%. This is due to overspending on the year‐to‐date
budget for general professional services (public defenders and community/government relations contracts). We believe
the overall actuals will be within budget or very close at year‐end.
Administrative Services (Finance and City Clerk) department is over the year‐to‐date budget by $18k or 0.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. We believe the overall actuals will be within budget or very close at
year‐end.
Page 10 of 37
Monthly Financial Report October 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 ‐ ‐ ‐ ‐ 71,723 46,750 ‐
Grants / intergovernmental 738,465 ‐ 111,688 ‐ 272,616 1,250,194 ‐
Charges for services 121,837 1,689,469 14,327,047 14,869,179 8,372,761 9,067,020 13,547,456
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 2,985 ‐ ‐ ‐ 522 ‐ ‐
Rents, leases, and misc fees 2,166,966 386,056 107,746 158,976 ‐ ‐ ‐
Interest and other misc 8,874 1,461 12,945 5,356,801 3,644,093 2,490,442 16,561
TOTAL REVENUES 3,039,127 2,076,986 14,559,426 20,384,956 12,361,715 12,854,406 13,564,017
EXPENSES:
Utility billing ‐ ‐ 116,918 103,728 84,948 137,916 ‐
Utility systems ‐ ‐ 12,404,092 2,973,310 2,706,214 10,717,810 ‐
Utility maintenance ‐ ‐ 247,789 4,518,331 1,380,360 2,268,958 12,563,918
Transportation 1,404,452 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,664,769 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,404,452 1,664,769 12,768,799 7,595,369 4,171,522 13,124,684 12,563,918
AMOUNT AVAILABLE FOR DEBT SERVICE 1,634,675 412,217 1,790,627 12,789,587 8,190,193 (270,278) 1,000,099
DEBT SERVICE:
Principal ‐ ‐ ‐ 4,948,910 2,908,794 2,044,534 ‐
Interest ‐ ‐ ‐ 323,916 163,160 573,820 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 5,272,826 3,071,954 2,618,354 ‐
CAPITAL PROJECTS 140,908 78,774 ‐ 856,401 3,854,480 3,250,372 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ (5,974) (2,689) ‐
CHANGE IN FUND BALANCE 1,493,767 333,443 1,790,627 6,660,360 1,257,785 (6,141,693) 1,000,099
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, Oct 31 2,638,516 223,387 3,942,083 29,341,981 12,894,300 4,541,085 4,992,477
Page 11 of 37
Monthly Financial Report October 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 ‐ 163,678 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 42,430
Charges for services
Equipment rental m&o 2,369,009 2,805,844 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 43,216 ‐ 343,657 ‐ ‐ ‐
Communications ‐ 259,667 310,000 473,838 ‐ ‐ ‐
Facilities ‐ ‐ 3,830,372 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 125,360 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 396,812 ‐ ‐ ‐ ‐ ‐
Interest and other misc 23,780 9,593 5,542 2,300 51,117 29,698 34,752
Internal service fund misc:
Vehicle / equipment capital recovery 2,419,810 122,502 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,512,377 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 1,494,482 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 9,150,391 1,854,510
Other misc 3,782 166 9,273 ‐ ‐ 875,319 18,229
Interfund Loan ‐ ‐ ‐ ‐ 146,298 ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 85,797 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 202,541 ‐ ‐
TOTAL REVENUES 4,902,178 3,926,838 4,155,188 819,795 3,406,815 10,055,408 1,949,921
EXPENSES:
Communications 453,113
Equipment rental 3,309,434
Facilities 3,571,057
Healthcare 10,716,413
Information technology 3,466,210
Print and mail 327,813
Retiree healthcare 923,428
Risk management:
Risk management 1,790,791
Unemployment 87,557
Worker's compensation 1,417,131
TOTAL EXPENSES 3,309,434 3,466,210 3,571,057 780,926 3,295,479 10,716,413 923,428
AMOUNT AVAILABLE FOR CAPITAL 1,592,744 460,628 584,131 38,869 111,336 (661,005) 1,026,493
CAPITAL PROJECTS 879,955 199,682 172,065 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ 21,335 ‐ 12,500 ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 712,789 282,281 412,066 51,369 111,336 (661,005) 1,026,493
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, Oct 31 6,333,069 2,609,590 1,671,569 627,702 13,196,646 6,862,262 9,918,981
Page 12 of 37
Monthly Financial Report October 2016
FUND BALANCE
Page 14 shows the ending fund balance as of October 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 October, the City has $25.3 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 20% of budgeted operating expenditures. This is an increase of $5.4 million
from the year’s beginning balance. October’s ending fund balance is over the anticipated General Governmental Fund
Balance of $15.1 million by $10.2 million or 67.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 13 of 37
Monthly Financial Report October 2016
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through October 31, 2016
Funds
Balance
01/01/2016
Budgeted
Revenue
Revenue
10/31/16
Total Funds
Available
Budgeted
Expenditure
Expenditure
10/31/16 Ending Balance
GENERAL GOVERNMENT FUNDS: 19,962,845 119,910,846 99,791,497 119,754,342 125,048,275 94,419,834 25,334,508
000 General 12,622,447 89,255,466 75,425,341 88,047,788 92,603,349 73,256,845 14,790,943
001 Community Services 2,818,784 12,661,674 10,418,352 13,237,136 13,355,577 9,865,600 3,371,536
003 Street 2,422,668 10,489,584 8,308,374 10,731,042 11,569,492 9,245,022 1,486,021
004 Community Dev Block Grant 66,654 882,158 75,917 142,571 882,158 219,239 (76,668)
005 Museum 66,388 235,281 176,639 243,027 235,281 190,760 52,267
009 Farmers Market 110,830 113,007 58,844 169,674 104,242 90,192 79,482
011 Fire Health & Wellness 88,406 25,000 21,020 109,426 49,500 103,231 6,195
201 Ltd GO Bonds Gen Govt Debt 845,273 1,755,255 1,321,359 2,166,632 1,755,255 73,725 2,092,907
215 Gen Govt Mi sc Debt Service 921,395 4,493,421 3,985,651 4,907,046 4,493,421 1,375,221 3,531,825
SPECIAL REVENUE FUNDS: 1,681,875 1,919,264 1,766,799 3,448,674 2,653,291 1,170,684 2,277,990
102 Arterial Street 31,697 650,000 565,574 597,271 650,000 ‐ 597,271
108 Leased City Properties 560,515 931,590 803,857 1,364,372 1,445,852 971,509 392,863
110 Hotel Motel 315,590 225,000 264,298 579,888 326,298 143,402 436,486
125 1% For Art 111,206 15,000 412 111,618 102,950 ‐ 111,618
127 Cable Communication 330,376 97,674 131,426 461,802 128,191 55,773 406,029
135 Springbrook Wetlands Bank 332,491 ‐ 1,232 333,723 ‐ ‐ 333,723
CAPITAL PROJECT FUNDS (CIP):21,039,649 37,476,061 14,383,319 35,422,968 54,520,575 12,737,051 22,685,917
303 Community Dev Mitigation 1,239,509 86,500 260,399 1,499,908 ‐ ‐ 1,499,908
304 Fire Mitigation 1,209,670 99,000 231,737 1,441,407 850,000 ‐ 1,441,407
305 Transportation Mitigation 937,248 600,000 553,655 1,490,903 800,000 ‐ 1,490,903
316 Municipal Facilities CIP 9,264,141 8,201,188 4,708,866 13,973,007 17,364,363 2,041,233 11,931,774
317 Transportation CIP 3,947,132 28,489,373 8,613,305 12,560,437 32,081,038 9,717,458 2,842,979
326 Housing Opportunity 1,041,775 ‐ 3,862 1,045,637 25,000 1,500 1,044,137
336 New Library Development 3,400,174 ‐ 11,495 3,411,669 3,400,174 976,860 2,434,809
ENTERPRISE FUNDS:52,179,441 105,611,837 78,882,300 131,061,741 123,482,742 72,487,912 58,573,829
4X2 Airport Operating & CIP 1,144,749 14,755,346 3,039,128 4,183,877 14,164,354 1,545,361 2,638,516
403 Solid Waste Utility 2,151,456 16,514,320 14,559,426 16,710,882 17,140,339 12,768,799 3,942,083
4X4 Golf Operating & CIP (110,056) 2,812,793 2,118,652 2,008,596 2,295,432 1,785,208 223,388
4X5 Water Operating & CIP 22,681,621 16,308,371 20,384,957 43,066,578 26,092,307 13,724,597 29,341,981
4X6 Waste Water Operating & CIP 11,636,515 15,324,938 12,361,715 23,998,230 19,415,925 11,103,929 12,894,301
416 King County Metro 3,992,378 16,638,722 13,564,017 17,556,395 16,638,722 12,563,918 4,992,477
4X7 Surface Water Operating & CIP 10,682,778 23,257,347 12,854,405 23,537,183 27,735,663 18,996,100 4,541,083
INTERNAL SERVICE FUNDS:39,284,490 37,726,031 29,249,980 68,534,470 37,371,074 27,314,650 41,219,820
501 Equipment Repair/Replacement 5,620,280 6,164,145 4,902,179 10,522,459 5,514,530 4,189,389 6,333,070
502 Insurance 13,085,310 4,166,201 3,406,815 16,492,125 3,612,594 3,295,480 13,196,645
503 Information Services 2,327,309 4,833,871 3,948,174 6,275,483 5,960,478 3,665,892 2,609,591
504 Facilities 1,259,503 4,953,544 4,155,188 5,414,691 5,407,389 3,743,122 1,671,569
505 Communications 576,333 1,040,239 832,295 1,408,628 1,112,381 780,926 627,702
512 Insurance, Healthcare 7,523,267 14,295,824 10,055,408 17,578,675 14,596,149 10,716,413 6,862,262
522 Insurance, Leoff1 Retirees HC 8,892,488 2,272,207 1,949,921 10,842,409 1,167,553 923,428 9,918,981
FIDUCIARY F UNDS:5,299,035 468,000 162,567 5,461,602 200,475 171,959 5,289,643
611 Firemen's Pension 5,299,035 468,000 162,567 5,461,602 200,475 171,959 5,289,643
TOTAL FUNDS 139,447,335 303,112,039 224,236,462 363,683,797 343,276,432 208,302,090 155,381,707
Page 14 of 37
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 71,753,118 67,206,203 4,546,916 24,509,761
August 79,378,013 74,281,749 5,096,264 25,059,109
September 85,974,133 81,242,284 4,731,848 24,694,693
October 99,791,497 94,419,834 5,371,663 25,334,508
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 15 of 37
City of Renton
Monthly Revenue Analysis ‐ 2016 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 6,116,313 7,317,475 19.64%
Feb 12,464,762 14,715,559 18.06%
Mar 18,997,836 21,798,267 14.74%
Apr 38,308,176 40,464,776 5.63%
May 54,887,603 57,969,563 5.62%
Jun 61,537,464 64,628,067 5.02%
Jul 68,034,670 71,753,118 5.47%
Aug 74,274,073 79,378,013 6.87%
Sep 80,821,287 85,974,133 6.38%
Oct 93,627,396 99,791,497 6.58%
Nov 110,546,482
Dec 119,910,845
Percent of budget 83.22%
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 19,591,281 ‐0.64%
Aug 19,814,300 19,831,817 0.09%
Sep 20,388,854 20,390,534 0.01%
Oct 26,797,806 26,624,443 ‐0.65%
Nov 37,004,304
Dec 37,213,314
Percent of budget 71.55%
$‐
$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 16 of 37
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 16,317,079 8.29%
Aug 17,435,267 19,044,048 9.23%
Sep 19,708,241 21,480,124 8.99%
Oct 22,045,782 24,170,845 9.64%
Nov 24,451,213
Dec 26,747,588
Percent of budget 90.37%
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 9,642,866 2.94%
Aug 10,667,136 10,890,792 2.10%
Sep 11,870,479 12,168,294 2.51%
Oct 13,064,155 13,520,182 3.49%
Nov 14,326,342
Dec 15,717,444
Percent of budget 86.02%
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 17 of 37
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 2,716,644 12.20%
Aug 2,748,612 3,035,243 10.43%
Sep 3,152,452 3,328,686 5.59%
Oct 3,516,273 3,717,906 5.73%
Nov 3,759,344
Dec 4,009,000
Percent of budget 92.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,465,223 7,708,932 3.26%
Aug 8,076,002 8,340,808 3.28%
Sep 8,663,731 8,934,054 3.12%
Oct 9,186,226 9,487,270 3.28%
Nov 10,537,097
Dec 14,361,437
Percent of budget 66.06%
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 18 of 37
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 4,648,795 ‐4.83%
Aug 5,655,002 5,488,977 ‐2.94%
Sep 6,237,457 6,084,569 ‐2.45%
Oct 6,840,019 6,724,439 ‐1.69%
Nov 7,365,845
Dec 8,007,932
Percent of budget 83.97%
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 1,566,744 ‐10.79%
Aug 2,069,275 1,841,708 ‐11.00%
Sep 2,369,080 2,042,694 ‐13.78%
Oct 2,659,110 2,281,211 ‐14.21%
Nov 2,992,541
Dec 3,320,500
Percent of budget 68.70%
$‐
$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 19 of 37
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 7,728,893 19.23%
Aug 6,807,221 8,778,071 28.95%
Sep 7,123,290 9,258,013 29.97%
Oct 8,089,336 10,825,217 33.82%
Nov 8,344,672
Dec 8,359,000
Percent of budget 129.50%
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 1,825,810 111.07%
Aug 995,183 2,120,475 113.07%
Sep 1,301,627 2,281,090 75.25%
Oct 1,422,614 2,433,908 71.09%
Nov 1,534,110
Dec 1,922,616
Percent of budget 126.59%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Miscellaneous
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
Millions Other Taxes
Budget
Actual
Last Year
Page 20 of 37
City of Renton
Monthly Revenue Analysis ‐ 2016 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan 21,001 ‐ 0.00%
Feb 42,002 ‐ 0.00%
Mar 63,004 ‐ 0.00%
Apr 84,005 ‐ 0.00%
May 105,006 ‐ 0.00%
Jun 6,075 6,075 0.00%
Jul 6,075 6,075 0.00%
Aug 6,075 6,075 0.00%
Sep 6,075 6,075 0.00%
Oct 6,075 6,075 0.00%
Nov 231,013
Dec 252,014
Percent of budget 2.41%
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 3,218,781 3,470,703 7.83%
Aug 3,765,687 4,230,285 12.34%
Sep 4,214,427 4,752,757 12.77%
Oct 4,740,895 5,312,309 12.05%
Nov 4,814,974
Dec 4,000,000
Percent of budget 132.81%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
Millions
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 21 of 37
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 3,270,705 4.90%
Aug 3,496,111 3,668,283 4.92%
Sep 3,974,931 4,048,763 1.86%
Oct 4,400,264 4,527,811 2.90%
Nov 4,726,378
Dec 5,173,368
Percent of budget 87.52%
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 5,289,180 11.35%
Aug 4,750,000 5,623,988 18.40%
Sep 4,750,000 5,634,767 18.63%
Oct 5,000,000 6,238,389 24.77%
Nov 5,000,000
Dec 5,000,000
Percent of budget 124.77%
$‐
$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
$6.00
$6.50
$7.00
Millions Business & Occupation Tax
Budget
Actual
Last Year
Page 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 8,786,532 8,625,290 ‐1.84%
Feb 18,575,748 18,026,295 ‐2.96%
Mar 28,081,780 27,039,048 ‐3.71%
Apr 36,922,905 35,281,644 ‐4.45%
May 46,172,761 44,251,964 ‐4.16%
Jun 55,763,852 53,224,181 ‐4.55%
Jul 70,497,069 67,206,203 ‐4.67%
Aug 78,193,759 74,281,749 ‐5.00%
Sep 85,599,444 81,242,284 ‐5.09%
Oct 98,457,536 94,419,834 ‐4.10%
Nov 113,204,532
Dec 125,048,276
Percent of budget expended 75.51%
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 214,274 ‐4.55%
Aug 254,415 242,571 ‐4.66%
Sep 284,228 271,193 ‐4.59%
Oct 314,294 300,668 ‐4.34%
Nov 344,069
Dec 375,761
Percent of budget expended 80.02%
$‐
$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 23 of 37
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 1,019,792 11.23%
Aug 1,146,554 1,165,850 1.68%
Sep 1,302,813 1,333,539 2.36%
Oct 1,437,782 1,463,344 1.78%
Nov 1,585,169
Dec 1,784,464
Percent of budget expended 82.00%
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 1,173,342 ‐8.51%
Aug 1,475,680 1,341,723 ‐9.08%
Sep 1,671,064 1,512,690 ‐9.48%
Oct 1,846,482 1,676,659 ‐9.20%
Nov 2,021,528
Dec 2,213,353
Percent of budget expended 75.75%
$‐
$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 24 of 37
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 1,191,366 ‐5.82%
Aug 1,449,036 1,363,339 ‐5.91%
Sep 1,627,840 1,546,812 ‐4.98%
Oct 1,805,361 1,718,898 ‐4.79%
Nov 1,978,143
Dec 2,187,710
Percent of budget expended 78.57%
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 671,572 ‐4.25%
Aug 793,589 767,998 ‐3.22%
Sep 886,107 864,286 ‐2.46%
Oct 978,401 960,176 ‐1.86%
Nov 1,070,254
Dec 1,163,302
Percent of budget expended 82.54%
$‐
$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 25 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 252,761 212,162 ‐16.06%
Feb 522,698 448,710 ‐14.15%
Mar 808,078 676,129 ‐16.33%
Apr 1,087,558 892,326 ‐17.95%
May 1,359,560 1,125,595 ‐17.21%
Jun 1,621,254 1,370,849 ‐15.45%
Jul 1,878,419 1,606,944 ‐14.45%
Aug 2,151,809 1,850,577 ‐14.00%
Sep 2,394,704 2,121,707 ‐11.40%
Oct 2,650,101 2,365,335 ‐10.75%
Nov 2,908,204
Dec 3,197,543
Percent of budget expended 73.97%
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 101,051 50,235 ‐50.29%
Feb 258,088 108,276 ‐58.05%
Mar 391,179 166,805 ‐57.36%
Apr 526,490 287,672 ‐45.36%
May 645,958 361,504 ‐44.04%
Jun 778,921 461,549 ‐40.75%
Jul 925,651 563,033 ‐39.17%
Aug 1,074,194 620,177 ‐42.27%
Sep 1,211,495 676,493 ‐44.16%
Oct 1,340,339 830,695 ‐38.02%
Nov 1,480,504
Dec 1,666,858
Percent of budget expended 49.84%
$‐
$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 26 of 37
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 1,553,419 ‐8.54%
Aug 1,951,022 1,797,371 ‐7.88%
Sep 2,216,643 2,047,141 ‐7.65%
Oct 2,500,304 2,274,192 ‐9.04%
Nov 2,749,051
Dec 3,019,484
Percent of budget expended 75.32%
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 1,550,596 9.74%
Aug 1,742,187 1,825,174 4.76%
Sep 1,948,700 2,042,155 4.80%
Oct 2,152,763 2,246,608 4.36%
Nov 2,344,422
Dec 2,953,369
Percent of budget expended 76.07%
$‐
$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 27 of 37
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 541,066 ‐8.80%
Aug 671,377 726,986 8.28%
Sep 741,134 684,984 ‐7.58%
Oct 834,041 758,024 ‐9.11%
Nov 907,039
Dec 1,151,870
Percent of budget expended 65.81%
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 675,537 ‐11.88%
Aug 881,492 786,540 ‐10.77%
Sep 993,608 883,392 ‐11.09%
Oct 1,112,638 987,507 ‐11.25%
Nov 1,219,645
Dec 1,372,669
Percent of budget expended 71.94%
$‐
$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 28 of 37
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,168,189 19,298,967 ‐4.31%
Aug 22,841,664 21,856,456 ‐4.31%
Sep 25,878,279 24,828,222 ‐4.06%
Oct 28,603,560 27,488,728 ‐3.90%
Nov 31,665,502
Dec 34,856,639
Percent of budget expended 78.86%
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 2,291,374 2,291,374 0.00%
Feb 5,299,522 5,299,522 0.00%
Mar 7,516,586 7,516,586 0.00%
Apr 9,575,877 9,575,877 0.00%
May 11,745,775 11,745,775 0.00%
Jun 12,826,352 12,826,352 0.00%
Jul 19,651,039 19,651,039 0.00%
Aug 19,707,735 19,707,735 0.00%
Sep 19,738,507 19,738,507 0.00%
Oct 25,667,731 25,667,731 0.00%
Nov 26,463,270
Dec 28,869,022
Percent of budget expended 88.91%
$‐
$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 29 of 37
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 325,143 ‐12.86%
Aug 427,414 366,838 ‐14.17%
Sep 481,448 409,466 ‐14.95%
Oct 534,041 452,338 ‐15.30%
Nov 589,514
Dec 655,344
Percent of budget expended 69.02%
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 2,449,585 ‐12.64%
Aug 3,298,106 2,895,238 ‐12.22%
Sep 3,795,912 3,344,418 ‐11.89%
Oct 4,241,176 3,734,313 ‐11.95%
Nov 4,633,809
Dec 5,065,610
Percent of budget expended 73.72%
$‐
$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 30 of 37
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 460,928 ‐32.31%
Aug 791,212 556,494 ‐29.67%
Sep 915,691 654,600 ‐28.51%
Oct 1,046,163 732,271 ‐30.00%
Nov 1,169,288
Dec 1,292,543
Percent of budget expended 56.65%
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 2,839,821 ‐2.70%
Aug 3,604,160 3,456,776 ‐4.09%
Sep 4,146,992 3,962,318 ‐4.45%
Oct 4,519,771 4,344,481 ‐3.88%
Nov 4,905,664
Dec 5,350,288
Percent of budget expended 81.20%
$‐
$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 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2016 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 49,704 81,352 63.67%
Feb 126,583 213,832 68.93%
Mar 265,121 269,088 1.50%
Apr 420,684 395,807 ‐5.91%
May 488,600 476,551 ‐2.47%
Jun 555,758 528,283 ‐4.94%
Jul 696,590 613,350 ‐11.95%
Aug 789,750 732,476 ‐7.25%
Sep 851,504 796,475 ‐6.46%
Oct 1,010,457 958,095 ‐5.18%
Nov 1,071,598
Dec 1,260,461
Percent of budget expended 76.01%
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 482,399 ‐18.69%
Aug 692,978 557,046 ‐19.62%
Sep 787,459 616,242 ‐21.74%
Oct 869,444 692,390 ‐20.36%
Nov 954,065
Dec 1,096,033
Percent of budget expended 63.17%
$‐
$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 32 of 37
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 131,860 ‐2.44%
Aug 155,440 151,132 ‐2.77%
Sep 175,323 170,790 ‐2.59%
Oct 195,438 190,760 ‐2.39%
Nov 215,317
Dec 235,281
Percent of budget expended 81.08%
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 234,053 ‐2.54%
Aug 275,209 267,579 ‐2.77%
Sep 310,708 300,887 ‐3.16%
Oct 344,670 333,632 ‐3.20%
Nov 378,434
Dec 413,579
Percent of budget expended 80.67%
$‐
$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 33 of 37
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 2,917,165 ‐5.59%
Aug 3,565,717 3,327,137 ‐6.69%
Sep 4,014,860 3,762,097 ‐6.30%
Oct 4,501,814 4,195,645 ‐6.80%
Nov 4,933,704
Dec 5,420,445
Percent of budget expended 77.40%
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 2,988,891 ‐12.82%
Aug 3,947,043 3,412,556 ‐13.54%
Sep 4,422,467 3,871,910 ‐12.45%
Oct 4,952,795 5,049,376 1.95%
Nov 5,426,873
Dec 6,149,047
Percent of budget expended 82.12%
$‐
$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 34 of 37
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 1,191,679 1,191,679 0.00%
Aug 1,441,996 1,441,996 0.00%
Sep 1,448,946 1,448,946 0.00%
Oct 1,448,946 1,448,946 0.00%
Nov 5,727,953
Dec 6,248,676
Percent of budget expended 23.19%
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 2,860,383 2,860,383 0.00%
Aug 3,063,984 3,063,984 0.00%
Sep 3,353,015 3,353,015 0.00%
Oct 3,549,024 3,549,024 0.00%
Nov 6,461,514
Dec 7,048,924
Percent of budget expended 50.35%
$‐
$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 35 of 37
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 44,115,062 34,016,925
Aug 67,816,343 51,070,788 45,010,257
Sep 76,250,053 57,773,544 54,401,676
Oct 84,074,531 73,724,460 69,154,653
Nov 92,029,531
Dec 107,022,956
Percent of budget expended 52.60%
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 2,081,888 997,029
Aug 9,883,320 2,302,425 1,140,620
Sep 10,864,768 2,536,402 1,335,868
Oct 11,604,431 3,039,128 1,545,361
Nov 12,859,109
Dec 14,164,354
Percent of budget expended 10.91%
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 36 of 37
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 1,437,189 1,243,694
Aug 1,308,140 1,760,424 1,419,407
Sep 1,481,465 1,981,564 1,606,801
Oct 1,678,887 2,118,653 1,785,208
Nov 1,805,131
Dec 2,295,432
Percent of budget expended 77.77%
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 37 of 37