HomeMy WebLinkAbout201807, July
h:\finance\financial reporting\monthly reports\2018 reports\cover 0718.docx
ADMINISTRATIVE SERVICES
M E M O R A N D U M
DATE: September 11, 2018
TO: Ed Prince, Council President
Members of Renton City Council
CC: Denis Law, Mayor
Bob Harrison, Chief Administrative Officer
FROM: Jan Hawn, ASD Administrator
STAFF CONTACT: Marc Gordon, Sr. Finance Analyst
SUBJECT: July 2018 Financial Status Report
At the end of July, general governmental revenues show $6.1M or 10.4% over budget.
Revenue source(s) that are higher than expected are: sales tax ($997K); sales tax
annexation credit ($424K); criminal justice sales tax ($163K); utility taxes ($654K);
gambling taxes ($601K); business & occupation taxes ($3.7M); business license ($20K);
public safety ($316K); and interest & other earnings ($266K). On the down side, the
revenue source(s) that are underperforming the year to date budget are: building permits
& development service fees ($414K below) and fines/penalties ($497K below).
General government expenditures showed a favorable variance of $2.5M or 4.7%. See
page 10 of report for further expenditure over-spent/savings 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 x6937 should
you have any questions or any suggestions about the report.
Ed Prince, Council President
Members of Renton City Council
Page 2 of 2
September 11, 2018
h:\finance\financial reporting\monthly reports\2018 reports\cover 0718.docx
This page is intentionally left blank
Page | 1
Preliminary as of 09/11/2018
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through July 31, 2018. 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 78% of all resources
supporting general governmental activities. The following section provides detail information on property, sales, utility, and other taxes.
Property Tax
Current Month Actual: $90K
YTD Actual: $10.3M
Budgeted YTD: $10.3M
Prior Year Same Month: $70K
Prior Year YTD: $12.9M
Year-to-Year Variance: $(-2.6M), -20%
Actual-to-Budget YTD Variance: $28K, .3%
Narrative: The negative amount for January is due
to the timing of recording January’s receipts in
February. February’s activity corrected the
negative January balance. The total property tax
levy is $5 million less in 2018, which is why the
year-to-year comparison skews low.
Sales Tax
Current Month Actual: $2.4M
YTD Actual: $16.1M
Budgeted YTD: $15.1M
Prior Year Same Month: $2.2M
Prior Year YTD: $15.1M
Year-to-Year Monthly Variance: $149K, 7%
Year-to-Year YTD Variance: $979K, 6%
Actual-to-Budget Monthly Variance: $245K, 11%
Actual-to-Budget YTD Variance: $997K, 7%
Narrative: New Construction and Service are the
sectors generating and collecting more than
anticipated. 2018’s monthly budgets are generally
based on 2013 through 2017 collections.
Monthly Financial Report July 2018
Preliminary
17 018 018
Actual Budget Actual $%$%
Jan 55,429$ 31,649$ (12,745)$ (68,174)$ -123%(44,394)$ -140%
Feb 195,332 161,273 106,364 (88,967) -46%(54,909) -34%
Mar 902,965 687,696 665,471 (237,493) -26%(22,225) -3%
Apr 7,035,332 4,704,879 6,908,633 (126,700) -2%2,203,754 47%
May 4,489,476 4,548,312 2,419,925 (2,069,551) -46%(2,128,388) -47%
Jun 128,834 84,239 108,842 (19,992) -16%24,602 29%
Jul 69,600 40,053 90,072 20,471 29%50,018 125%
Aug 101,349 108,016
Sep 442,694 316,388
Oct 4,057,893 3,251,619
Nov 6,733,813 5,371,847
Dec 143,844 91,336
YTD Total 12,876,968$ 10,258,103$ 10,286,562$ (2,590,407)$ -20%28,459$ 0.3%
Annual Total 24,356,562$ 19,397,308$
Property Tax Revenues
Year to Date through July
018 vs. 17 018 vs. Budget
Month
17 018 018
Actual Budget Actual $%$%
Jan 2,092,821$ 2,096,932$ 2,217,949$ 125,128$ 6%121,017$ 6%
Feb 2,473,715 2,495,067 2,839,044 365,329 15%343,977 14%
Mar 1,945,278 1,990,954 2,099,180 153,902 8%108,226 5%
Apr 1,871,345 1,956,740 2,009,648 138,303 7%52,908 3%
May 2,381,981 2,327,614 2,506,478 124,497 5%178,863 8%
Jun 2,075,555 2,050,822 1,997,751 (77,804) -4%(53,071) -3%
Jul 2,236,477 2,140,543 2,385,665 149,188 7%245,122 11%
Aug 2,421,720 2,378,153 -
Sep 2,162,766 2,236,561 -
Oct 2,273,788 2,332,820 -
Nov 2,347,924 2,426,685 -
Dec 2,048,264 2,250,548 -
YTD Total 15,077,171$ 15,058,673$ 16,055,715$ 978,543$ 6%997,042$ 7%
Annual Total 26,331,634$ 26,683,440$
018 vs. Budget018 vs. 17
Month
Year to Date through July
Local Retail Sales Tax Revenues
Monthly Financial Report July 2018
Page | 2
Preliminary as of 09/11/2018
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business sectors:
Utility tax
Current Month Actual: $1.4M
YTD Actual: $10.1M
Budgeted YTD: $9.5M
Prior Year Same Month: $1.5M
Prior Year YTD: $10.4M
Year-to-Year Monthly Variance: $(-139K), -9%
Year-to-Year YTD Variance: $(-269K), -3%
Actual-to-Budget Monthly Variance: $56K, 4%
Actual-to-Budget YTD Variance: $653K, 7%
Narrative: The large January variance with the
budget is due to the timing of when 2018
Cell/Phone/Garbage taxes were recorded. The
monthly budgets are based on 2016/2017 activity.
The table below breaks out Utility Tax by source. As mentioned last month, the large variance with electrical and natural gas was due to
an error in recording these revenues and has corrected itself in June.
Sales Tax by Sector 17 018 Bgt YTD Act Change 018 /17 018 Act vs Bgt
New Construction 2,413,711$ 2,019,298$ 2,595,496$ 181,785$ 8% $ 576,198 29%
Auto Sales 2,777,927 2,837,868 2,925,929 148,002 5% 88,061 3%
General Retail 4,384,543 4,564,044 4,477,062 92,520 2% (86,981)-2%
Manufacturing 889,563 1,099,417 1,045,621 156,058 18% (53,797)-5%
Wholesale 844,538 792,940 780,600 (63,938) -8% (12,340)-2%
Service 3,311,024 3,343,518 3,838,744 527,720 16% 495,226 15%
Other 455,866 401,588 392,262 (63,604) -14% (9,326)-2%
YTD Total 15,077,171$ 15,058,673$ 16,055,715$ 978,543$ 6%997,042$ 7%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
17 018 018
Actual Budget Actual $%$%
Jan 1,698,721$ 1,472,870$ 1,395,386$ (303,335)$ -18%(77,484)$ -5%
Feb 1,360,589 1,413,168 1,617,972 257,383 19%204,804 14%
Mar 1,197,548 1,249,534 1,579,191 381,643 32%329,657 26%
Apr 1,797,449 1,493,002 1,463,336 (334,113) -19%(29,665) -2%
May 1,464,438 1,341,860 1,414,956 (49,482) -3%73,096 5%
Jun 1,351,607 1,173,122 1,269,602 (82,005) -6%96,480 8%
Jul 1,538,390 1,342,347 1,398,960 (139,430) -9%56,613 4%
Aug 1,185,237 1,155,083
Sep 1,261,199 1,224,457
Oct 1,428,438 1,322,247
Nov 1,267,897 1,143,031
Dec 1,447,690 1,333,404
YTD Total 10,408,741$ 9,485,903$ 10,139,403$ (269,338)$ -3%653,500$ 7%
Annual Total 16,999,203$ 15,664,124$
018 vs. Budget018 vs. 17
Year to Date through July
Utility Tax Revenues
Month
Utility Tax by Type 17 018 Bgt YTD Act Change 018 /17 018 Act vs Bgt
Electrical 3,464,919$ 3,313,088$ 3,158,394$ (306,525)$ -9% $ (154,694)-5%
Natural Gas 1,294,127 1,109,760 1,476,884 182,757 14% 367,124 33%
Cell 940,094 959,285 764,817 (175,277) -19% (194,468)-20%
Phone 564,873 454,426 516,347 (48,526) -9% 61,921 14%
Cable 940,824 942,846 876,165 (64,658) -7% (66,681)-7%
Garbage/Solid Waste 356,201 382,091 427,686 71,485 20% 45,595 12%
City Utilities 2,847,704 2,324,406 2,919,110 71,406 3% 594,703 26%
Utility Tax Audit - - - - N/A - N/A
YTD Total 10,408,741$ 9,485,903$ 10,139,403$ (269,338)$ -3%653,500$ 7%
Annual Total 16,999,203$ 15,664,124$
YTD as % of 61%61%
Monthly Financial Report July 2018
Page | 3
Preliminary as of 09/11/2018
Other Taxes
Real Estate Excise Tax
Current Month Actual: $847K
YTD Actual: $3.8M
Budgeted YTD: $2.8M
Prior Year Same Month: $591K
Prior Year YTD: $4.2M
Year-to-Year Monthly Variance: $255K, 43%
Year-to-Year TYD Variance: $(-331K), -8%
Actual-to-Budget Monthly Variance: $406K, 92%
Actual-to-Budget YTD Variance: $1.0M, 35%
Narrative: The higher than expected variance is
due to 10 large transactions in December and
January which accounts for $708K of the total REET
collected.
Gambling Tax
Current Month Actual: $255K
YTD Actual: $1.7M
Budgeted YTD: $1.1M
Prior Year Same Month: $230K
Prior Year YTD: $1.5M
Year-to-Year Monthly Variance: $25K, 11%
Year-to-Year YTD Variance: $185K, 12%
Actual-to-Budget Monthly Variance: $92K, 56%
Actual-to-Budget YTD Variance: $601K, 54%
Narrative: Gambling tax revenue continues to
outperform budgeted expectations, which can
primarily be attributable to current economic
conditions.
Franchise Fees
Current Month Actual: $344K
YTD Actual: $1.1M
Budgeted YTD: $979K
Prior Year Same Month: $342K
Prior Year YTD: $1.1M
Year-to-Year Monthly Variance: $2K, 1%
Year-to-Year YTD Variance: $(-10K), -1%
Actual-to-Budget Monthly Variance: $37K, 12%
Actual-to-Budget YTD Variance: $148K, 15%
Narrative: Franchise fee revenue is performing
slightly better than expected and right on track
with prior year receipts.
17 018 018
Actual Budget Actual $%$%
Jan 220,536$ 157,924$ 210,929$ (9,607)$ -4%53,004$ 34%
Feb 200,622 157,269 255,285 54,663 27%98,016 62%
Mar 180,839 144,763 245,283 64,444 36%100,520 69%
Apr 219,422 160,397 275,795 56,373 26%115,399 72%
May 248,673 172,020 222,540 (26,133) -11%50,520 29%
Jun 232,889 160,867 252,663 19,775 8%91,796 57%
Jul 230,342 163,457 255,351 25,009 11%91,894 56%
Aug 216,990 207,784 -
Sep 205,141 156,872 -
Oct 215,122 176,050 -
Nov 259,744 170,551 -
Dec 265,048 172,045 -
YTD Total 1,533,322$ 1,116,698$ 1,717,847$ 184,525$ 12%601,149$ 54%
Annual Total 2,695,368$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through July
018 vs. Budget018 vs. 17
17 018 018
Actual Budget Actual $%$%
Jan 380,870$ 326,648$ 371,458$ (9,411)$ -2%44,810$ 14%
Feb 6,300 2,823 16,600 10,300 163%13,777 488%
Mar 9,100 4,078 15,792 6,692 74%11,714 287%
Apr 369,626 324,886 37,420 (332,207) -90%(287,467) -88%
May 7,688 3,445 340,622 332,934 4331%337,177 9788%
Jun 21,325 9,555 1,050 (20,275) -95%(8,505) -89%
Jul 342,363 307,508 344,386 2,023 1%36,878 12%
Aug 7,700 3,450 -
Sep 8,750 6,161 -
Oct 375,128 324,373 -
Nov 10,500 4,705 -
Dec 22,750 12,367 -
YTD Total 1,137,272$ 978,943$ 1,127,328$ (9,944)$ -1%148,385$ 15%
Annual Total 1,562,100$ 1,330,000$
Month
018 vs. 17 018 vs. Budget
Franchise Fees Revenue
Year to Date through July
17 018 018
Actual Budget Actual $%$%
Jan 1,028,456$ 786,056$ 840,316$ (188,139)$ -18%54,260$ 7%
Feb 337,024 210,018 366,011 28,987 9%155,993 74%
Mar 708,868 391,942 291,045 (417,824) -59%(100,897) -26%
Apr 385,517 266,812 405,746 20,230 5%138,934 52%
May 386,087 300,651 607,431 221,344 57%306,780 102%
Jun 747,549 458,002 496,917 (250,632) -34%38,915 8%
Jul 591,137 440,175 846,631 255,494 43%406,456 92%
Aug 672,396 507,194
Sep 633,804 431,443
Oct 359,891 308,343
Nov 775,249 398,534
Dec 585,757 (79,171)
YTD Total 4,184,639$ 2,853,657$ 3,854,099$ (330,540)$ -8%1,000,442$ 35%
Annual Total 7,211,736$ 4,420,000$
*Total REET (GF & CIP)
Real Estate Excise Tax (REET) Revenues*
Year to Date through July
Month
018 vs. Budget018 vs. 17
Monthly Financial Report July 2018
Page | 4
Preliminary as of 09/11/2018
Admission Tax
Current Month Actual: $0
YTD Actual: $115K
Budgeted YTD: $248K
Prior Year Same Month: $51K
Prior Year YTD: $175K
Year-to-Year YTD Variance: $(-61K), -35%
Actual-to-Budget YTD Variance: $(-134K), 54%
Narrative: Admission Tax returns are due
quarterly in January, April, July, and October of
each year. January 2018 collections represent
activities conducted during the 4th quarter of
2017. 2nd Quarter admissions received in August
amounted to $63K
Business & Occupation Tax
Current Month Actual: $841K
YTD Actual: $9.0M
Budgeted YTD: $5.3M
Prior Year Same Month: $1.1M
Prior Year YTD: $4.9M
Year-to-Year Monthly Variance: $(-298K), -26%
Year-to-Year YTD Variance: $1.7M, 23%
Actual-to-Budget Monthly Variance: $(-686K), 45%
Actual-to-Budget YTD Variance: $3.7M, 69%
Narrative: Businesses with gross receipts of $500K or
more per year, earned within the City of Renton, are
now required to file and pay Business and
Occupation (B&O) tax, in lieu of the Business License
registration fee. A large taxpayer hit the maximum
threshold and had a significant payment in April. As
a result, this should flatten out in future months.
Licenses and Permits
Business Licenses
Current Month Actual: $16K
YTD Actual: $941K
Budgeted YTD: $920K
Prior Year Same Month: $218K
Prior Year YTD: $978K
Year-to-Year Monthly Variance: $(-201K), -92%
Year-to-Year YTD Variance: $(-37,925), -4%
Actual-to-Budget Monthly Variance: $(-165K), -91%
Actual-to-Budget YTD Variance: $20K, 2%
Narrative: The variance with the budget and prior
year is due to two things: 1) the City adopting Ordinance 5866 which changed the reporting period from quarterly to annually with a due
date of January, and 2) removing the per employee tax. The reduction in revenue collected from the per employee tax is offset by the
increase in B&O (above). The City projects a decrease in overall Business Licenses.
17 018 018
Actual Budget Actual $%$%
Jan 60,741$ 90,356$ 56,598$ (4,143)$ -7%(33,759)$ -37%
Feb 2,788 2,733 1,473 (1,315) -47%(1,260) -46%
Mar - - 112 112 100%112 100%
Apr 58,566 80,156 54,560 (4,006) -7%(25,597) -32%
May 1,279 842 1,911 633 50%1,069 127%
Jun 785 517 0 (785) (1) (517) (1)
Jul 51,061 73,680 0 (51,061) (1) (73,680) (1)
Aug 1,578 1,040 -
Sep - 341 - -
Oct 1,705 39,955 -
Nov - 956 - -
Dec 44,655 29,423 -
YTD Total 175,220$ 248,285$ 114,654$ (60,566)$ -35%(133,632)$ -54%
Annual Total 223,157$ 320,000$
018 vs. Budget
Admission Tax Revenue
Year to Date through July
Month
018 vs. 17
17 018 018
Actual Budget Actual $%$%
Jan 432,319$ 1,527,200$ 1,301,574$ 869,256$ 201%(225,626)$ -15%
Feb 794,093 190,900 1,013,630 219,536 28%822,730 431%
Mar 13,228 190,900 48,278 35,050 265%(142,622) -75%
Apr 4,626,880 1,527,200 5,430,049 803,168 17%3,902,849 256%
May 316,791 190,900 212,741 (104,050) -33%21,841 11%
Jun 23,491 190,900 172,687 149,196 635%(18,213) -10%
Jul 1,139,041 1,527,200 840,839 (298,202) -26%(686,361) -45%
Aug 399,375 190,900 -
Sep 169,792 190,900 -
Oct 981,417 1,527,200 -
Nov 320,706 190,900 -
Dec 415,901 190,900 -
YTD Total 7,345,843$ 5,345,200$ 9,019,798$ 1,673,954$ 23%3,674,598$ 69%
Annual Total 9,633,034$ 7,636,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through July
Month
018 vs. 17 018 vs. Budget
17 018 018
Actual Budget Actual $%$%
Jan 229,270$ 277,687 574,453$ 345,183$ 151%296,767$ 107%
Feb 157,504 157,567 208,947 51,443 33%51,379 33%
Mar 53,131 33,461 41,777 (11,354) -21%8,316 25%
Apr 157,983 145,552 34,897 (123,086) -78%(110,655) -76%
May 126,086 97,341 33,623 (92,463) -73%(63,718) -65%
Jun 36,375 27,014 30,721 (5,653) -16%3,708 14%
Jul 217,718 181,851 16,354 (201,364) -92%(165,497) -91%
Aug 124,833 95,699 -
Sep 57,640 34,647 -
Oct 187,368 160,619 -
Nov 88,975 73,242 -
Dec 43,847 27,214 -
YTD Total 978,068$ 920,473$ 940,773$ (37,295)$ -4%20,300$ 2%
Annual Total 1,480,730$ 1,311,894$
*Total Business License (GF & CIP)
Business Licenses*
Month
018 vs. 17
Year to Date through July
018 vs. Budget
Monthly Financial Report July 2018
Page | 5
Preliminary as of 09/11/2018
Building Permits and Development Service Fees
Current Month Actual: $485K
YTD Actual: $2.9M
Budgeted YTD: $3.3M
Prior Year Same Month: $265K
Prior Year YTD: $2.9M
Year-to-Year Monthly Variance: $220K, 83%
Year-to-Year YTD Variance: $(-7K), -0.3%
Actual-to-Budget Monthly Variance: $97K, 25%
Actual-to-Budget YTD Variance: $(-414K), -13%
Narrative: The large budget variance in January is
due to large payments for building permits and plan
review (Southport Developer and Group Health)
receipted in January 2016 (monthly budgets is
based on 2016/2017 activity, which accounts for almost half of the year-to-date variance. In addition to this, building permits have been
trending behind for May and June accounting for about $184K of the variance.
Intergovernmental
These revenue sources include federal
(direct and indirect) grants, state grants,
state shared revenues, local grants, and
entitlements. State shared revenues
91% of the total revenues in this
category. The year-to-date total
Intergovernmental revenue is $4.1M or
54% of the budget.
State Shared Revenues
YTD Total: $3.7
Year-to-Year YTD Variance: $182K, 5%
Actual-to-Budget YTD Variance: $274K, 8%
Narrative: The higher than
expected collection is due to
collecting more than anticipated
Criminal Justice’s Sales Tax and
marijuana enforcement. This
large increase was the result of a
“catch-up” payment from the
state in March. In the future, the
cities shared revenue distribution
will be approximately double the
normal bi-monthly distribution
(through June 2019).
17 018 018
Actual Budget Actual $%$%
Jan 399,548$ 567,204$ 314,626$ (84,921)$ -21%(252,577)$ -45%
Feb 277,296 369,165 280,745 3,449 1%(88,420) -24%
Mar 503,290 581,137 588,527 85,237 17%7,389 1%
Apr 265,749 321,507 403,892 138,143 52%82,385 26%
May 558,773 499,771 436,943 (121,831) -22%(62,829) -13%
Jun 611,441 560,415 363,521 (247,920) -41%(196,894) -35%
Jul 264,515 388,411 484,920 220,405 83%96,510 25%
Aug 433,043 444,085
Sep 445,562 441,521
Oct 338,298 436,655
Nov 479,017 414,816
Dec 331,450 427,013
YTD Total 2,880,611$ 3,287,609$ 2,873,173$ (7,438)$ 0%(414,436)$ -13%
Annual Total 4,907,983$ 5,451,699$
Year to Date through July
018 vs. Budget018 vs. 17
Month
Building Permits and Development Service Fees
Intergovernmental 17 018 Bgt YTD Act Change 018 /17 018 Act vs Bgt
Fire District #25 -$ -$ -$ -$ N/A $ - N/A
Fire District #40 170,969 178,830 178,830 7,861 5%- 0%
State Shared Revenue 3,513,017 3,420,378 3,694,760 181,743 5%274,383 8%
Federal Grants 73,397 143,357 56,404 (16,993) -23%(86,952) -61%
State Grants 29,932 59,851 22,679 (7,253) -24%(37,172) -62%
Other Grants/Intgovt 214,629 135,740 129,182 (85,448) -40%(6,558) -5%
ARRA Grants - - - - N/A - N/A
Total Rev YTD 4,001,945$ 3,938,155$ 4,081,855$ 79,910$ 2%143,701$ 4%
Total Rev Annual 7,436,309$ 7,588,646$
YTD %54%52%54%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
17 018 018
Actual Budget Actual $%$%
Crim Just Sales Tax 1,563,288$ 1,554,310$ 1,716,893$ 153,605$ 10%162,583$ 10%
Judicial Contribution 5,570 - 11,025 5,455 98%11,025 100%
Crim Just - High Crime 204,154 196,881 210,584 6,429 3%13,703 7%
Crim Just - Pop 21,331 18,405 22,168 837 4%3,763 20%
Crim Just - Spec Prog 77,480 68,311 80,183 2,703 3%11,873 17%
State DUI 11,541 13,158 11,387 (153) -1%(1,770) -13%
Marijuana Enforcement 23,772 - - (23,772) 0%- N/A
Liquor Profits 427,768 425,244 425,526 (2,242) -1%282 0%
Liquor Excise Tax 356,200 332,449 378,373 22,173 6%45,924 14%
Fuel Tax 821,912 811,622 838,622 16,710 2%27,000 3%
YTD Total 3,513,017$ 3,420,378$ 3,694,760$ 181,743$ 5%274,383$ 8%
Annual Total 6,145,527$ 5,942,169$
State Shared Revenues
018 vs. 17
Revenue
Year to Date through July
018 vs. Budget
Monthly Financial Report July 2018
Page | 6
Preliminary as of 09/11/2018
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 65% of the total
revenue in this category. The year-to-date total charges for services are $5.1M or 58% of the budget. The following sections provide detail
information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
YTD Total: $682K
Year-to-Year YTD Variance: $172K, 34%
Actual-to-Budget YTD Variance: $316, 86%
Narrative: The variance with the prior year is due
to collecting large reimbursements for the School
Resource Officer program.
Recreation
Current Month Actual: $420K
YTD Total: $1.0M
Budgeted YTD: $1.1M
Prior Year Same Month: $482K
Prior Year YTD Total: $1.1M
Year-to-Year Monthly Variance: $(-63K), -13%
Year-to-Year YTD Variance: $(-42K), -4%
Actual-to-Budget Monthly Variance: $(-4K), -1%
Actual-to-Budget YTD Variance: $(-79K), -7%
Narrative: The total variance is primarily related to
aquatic center fees and community center self-
sustaining program fees being behind prior year
figures.
17 018 018
Actual Budget Actual $%$%
Jan 64,424$ 57,002$ 224,932$ 160,509$ 249%167,930$ 295%
Feb 68,705 56,753 60,888 (7,817) -11%4,136 7%
Mar 148,707 69,703 82,789 (65,918) -44%13,086 19%
Apr 61,399 37,896 58,572 (2,827) -5%20,676 55%
May 63,815 37,767 77,233 13,418 21%39,467 105%
Jun 43,374 75,004 84,800 41,426 96%9,796 13%
Jul 59,850 31,948 92,695 32,845 55%60,748 190%
Aug 58,114 34,576 -
Sep 53,908 40,957 -
Oct 52,056 71,643 -
Nov 77,748 49,060 -
Dec 85,628 55,327 -
YTD Total 510,274$ 366,072$ 681,910$ 171,635$ 34%315,838$ 86%
Annual Total 837,728$ 617,635$
018 vs. Budget
Month
018 vs. 17
Year to Date through July
Public Safety Services
17 018 018
Actual Budget Actual $%$%
Jan 152,350$ 165,916$ 138,388$ (13,962)$ -9%(27,528)$ -17%
Feb 38,452 45,377 51,694 13,243 34%6,317 14%
Mar 65,420 66,147 55,300 (10,121) -15%(10,847) -16%
Apr 74,806 98,371 70,321 (4,486) -6%(28,050) -29%
May 84,381 82,203 82,814 (1,568) -2%611 1%
Jun 153,304 206,297 191,108 37,804 25%(15,189) -7%
Jul 482,458 423,801 419,790 (62,669) -13%(4,011) -1%
Aug 382,296 384,147 -
Sep 135,476 127,601 -
Oct 49,113 49,764 -
Nov 58,320 66,466 -
Dec 45,946 44,831 -
YTD Total 1,051,172$ 1,088,113$ 1,009,414$ (41,757)$ -4%(78,698)$ -7%
Annual Total 1,722,323$ 1,760,923$
018 vs. Budget018 vs. 17
Month
Recreation
Year to Date through July
Monthly Financial Report July 2018
Page | 7
Preliminary as of 09/11/2018
Interfund Services
YTD Total: $2.3M
Year-to-Year YTD Variance: $(-46K), -2%
Actual-to-Budget YTD Variance: $(-261K), -10%
Narrative: 2018’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
YTD Total: $1.7M
Year-to-Year YTD Variance: $147K, 9%
Actual-to-Budget YTD Variance: $(-497K), -22%
Narrative: 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 primary
driver of the negative variance is the photo
enforcement program.
17 018 018
Actual Budget Actual $%$%
Jan 330,774$ 363,424$ 341,804$ 11,030$ 3%(21,619)$ -6%
Feb 319,851 363,424 344,339 24,488 8%(19,084) -5%
Mar 377,192 363,424 378,470 1,278 0%15,046 4%
Apr 332,180 363,424 332,894 714 0%(30,530) -8%
May 332,543 363,424 328,765 (3,778) -1%(34,659) -10%
Jun 322,435 363,424 320,735 (1,699) -1%(42,689) -12%
Jul 314,856 363,424 236,427 (78,430) -25%(126,997) -35%
Aug 295,921 363,424 -
Sep 350,908 363,424 -
Oct 321,038 363,424 -
Nov 316,488 363,424 -
Dec 302,147 363,424 -
YTD Total 2,329,831$ 2,543,967$ 2,283,435$ (46,397)$ -2%(260,532)$ -10%
Annual Total 3,916,334$ 4,361,086$
018 vs. Budget
Month
Interfund Services
Year to Date through July
018 vs. 17
17 018 018
Actual Budget Actual $%$%
Jan 134,957$ 206,614$ 141,625$ 6,668$ 5%(64,989)$ -31%
Feb 217,056 309,853 224,814 7,759 4%(85,039) -27%
Mar 212,186 331,630 312,111 99,925 47%(19,518) -6%
Apr 242,816 340,209 137,934 (104,882) -43%(202,275) -59%
May 229,877 312,735 230,762 885 0%(81,973) -26%
Jun 302,666 401,048 235,311 (67,354) -22%(165,737) -41%
Jul 247,260 328,975 451,443 204,183 83%122,468 37%
Aug 298,685 374,734
Sep 220,425 291,346
Oct 274,245 363,684
Nov 240,739 361,754
Dec 325,938 423,905
YTD Total 1,586,818$ 2,231,064$ 1,734,001$ 147,183$ 9%(497,063)$ -22%
Annual Total 2,946,849$ 4,046,487$
Month
018 vs. Budget018 vs. 17
Year to Date through July
Fines and Penalties by Month
Year to Date through July
17 018 018
Actual Budget Actual $%$%
Civil Penalties 1,218$ 2,730$ 851$ (367)$ -30%(1,879)$ -69%
Civil Infraction Penalties 173,426 166,195 180,466 7,040 4%14,271 9%
Civil Parking Infraction Penalties 90,058 121,009 90,076 18 0%(30,933) -26%
Photo Enforcement Program 1,167,915 1,812,314 1,305,491 137,576 12%(506,823) -28%
Criminal Traffic Misdemeanor Fines 41,351 39,162 39,721 (1,631) -4%559 1%
Criminal Non-Traffic Fines 44,150 33,615 45,127 976 2%11,511 34%
Criminal Costs 44,738 47,870 50,924 6,186 14%3,053 6%
Non-Court Fines, Forfeitures and Penalties 23,961 8,168 21,346 (2,615) -11%13,177 161%
YTD Total 1,586,818$ 2,231,064$ 1,734,001$ 147,183$ 9%(497,063)$ -22%
Annual Total 2,946,849$ 4,046,487$
Revenue
018 vs. Budget
Fines and Penalties by Type
018 vs. 17
Monthly Financial Report July 2018
Page | 8
Preliminary as of 09/11/2018
Included in the Fines and Penalties revenue budget is
$1.8M 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.3M.
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 $329K for personnel
costs. The total costs for the program equates to $1.5M
which is represented in the table. Due to the timing of
when the invoice was received, January 2018’s equipment
rental cost was recorded in February.
Miscellaneous
YTD Total: $1.5M
Year-to-Year YTD Variance: $167K, 12%
Actual-to-Budget YTD Variance: $521K, 51%
Narrative: 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. Though the year was
started due to a large variance in Seizure Funds
collected in 2017 and a lack there of in 2018, in May
2018 $227K in Seizure Funds were collected
resulting in a large positive variance. Seizure Funds
are restricted to drug enforcement only and are not
available for general operating purposes.
17 018 018
Actual Budget Actual $%$%
Jan 363,997$ 226,534$ 262,690$ (101,308)$ -28%36,156$ 16%
Feb 148,988 119,730 150,608 1,620 1%30,878 26%
Mar 150,954 115,624 178,170 27,216 18%62,546 54%
Apr 188,887 124,097 152,700 (36,186) -19%28,604 23%
May 152,678 121,318 386,715 234,037 153%265,397 219%
Jun 179,152 145,245 193,674 14,522 8%48,429 33%
Jul 193,718 171,837 221,279 27,561 14%49,442 29%
Aug 198,576 163,060
Sep 151,310 134,049
Oct 156,212 121,675
Nov 125,698 96,289
Dec 468,107 379,164
YTD Total 1,378,374$ 1,024,385$ 1,545,836$ 167,462$ 12%521,451$ 51%
Annual Total 2,478,278$ 1,918,622$
Year to Date through July
Month
018 vs. Budget018 vs. 17
Miscellaneous Revenues by Month
17 018 018
Actual Budget Actual $%$%
Interests and Other Earnings 488,225$ 356,407$ 622,580$ 134,356$ 28%266,173$ 75%
Rents, Leases, and Concessions 419,315 407,675 444,241 24,926 6%36,566 9%
Contributions/Donations from Private Sources 98,558 98,721 86,625 (11,933) -12%(12,096) -12%
Other 212,302 161,582 146,828 (65,474) -31%(14,754) -9%
Seizure Funds - Federal/State/Local 159,974 - 245,561 85,588 54%245,561 100%
YTD Total 1,378,374$ 1,024,385$ 1,545,836$ 167,462$ 12%521,451$ 51%
Annual Total 2,478,278$ 1,918,622$
018 vs. Budget
Miscellaneous Revenues by Type
Year to Date through July
Revenue
018 vs. 17
Favorable
8 Budget 8 Actual 8 Budget 8 Actual (Unfavorable)1
Jan 204,207$ 136,853$ 124,941$ 27,432$ 109,421$
Feb 250,698 154,588 124,941 95,186 59,402
Mar 261,123 179,033 124,941 95,195 83,838
Apr 259,635 122,862 124,941 95,195 27,667
May 250,855 171,477 124,941 95,189 76,288
Jun 326,983 155,145 124,941 95,186 59,959
Jul 258,813 385,533 124,941 27,432 358,101
Aug 298,847 - 124,941 - -
Sep 218,520 - 124,941 - -
Oct 299,333 - 124,941 - -
Nov 291,494 - 124,941 - -
Dec 295,896 - 124,941 - -
YTD Total 1,812,314$ 1,305,491$ 874,590$ 530,816$ 774,675$
Annual Total 3,216,405$ 1,499,297$
1Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through July
Month
Revenues Expenses
Monthly Financial Report July 2018
Page | 9
Preliminary as of 09/11/2018
EXPENSES
Overall, the City has expended 50.8% of its budgeted general governmental expenditures at the end of July. This is $2.5M or 4.9% below
year-to-date budgeted expenditures. See below for summary of unfavorable items for general governmental departments.
City Clerk is over the year‐to‐date budget by $29K or 3.6%. This is in part due to over spending on election costs ($15K) and microfilming
services ($8K). We will monitor this to determine if a budget adjustment is needed at year-end.
Court Services department is over the year-to-date budget by $14K or 1.1%. This is due to over spending on contracted services ($12K),
other attorney fees ($5K), witness fees ($2K), and security ($8K). We will monitor this to determine if a budget adjustment is needed at
year-end.
Transportation, Executive department, Community and Economic Development, and Human Services are all reflecting a negative variance
on their respective expenditures; however, after taking a deeper dive into the specific costs associated with these variances, these are
primarily related to timing differences that are skewing the variance calculation.
Monthly Financial Report July 2018
Page | 10
Preliminary as of 09/11/2018
ENTERPRISE FUNDS
The table below gives an analysis of all City Enterprise funds. Displayed are the year-to-date revenues and expenditures for each enterprise.
Included in each funds are the capital revenues and expenditures.
Airport Golf Course Solid Waste
Utility Water Utility Wastewater
Utility
Surface
Water Utility Metro
REVENUES:
Licenses and permits - - - - 50,400 33,600 -
Grants / intergovernmental 52,887 5,259 83,779 - - 804,044 -
Charges for services 156,870 1,167,081 10,018,199 9,446,604 6,209,308 6,976,084 9,701,589
Interdepartmental services - - - - - - -
Fines and penalties 293 - - - 270 - -
Rents, leases, and misc fees 1,902,836 254,081 - 125,941 - - -
Interest and other misc 26,101 2,335 17,620 951,561 923,156 338,975 35,325
TOTAL REVENUES 2,138,987 1,428,756 10,119,598 10,524,106 7,183,134 8,152,703 9,736,914
EXPENSES:
Utility billing - - 24,244 96,852 80,125 123,946 -
Utility systems - - 9,510,554 2,359,932 2,094,173 2,164,904 -
Utility maintenance - - 211,986 3,365,323 1,303,880 1,802,681 9,602,830
Transportation 1,070,204 - - - - - -
Golf - 1,227,324 - - - - -
TOTAL EXPENSES 1,070,204 1,227,324 9,746,784 5,822,107 3,478,178 4,091,531 9,602,830
AMOUNT AVAILABLE FOR DEBT
SERVICE 1,068,783 201,432 372,815 4,701,999 3,704,956 4,061,172 134,084
DEBT SERVICE:
Principal - - - 345,818 - - -
Interest - - - 118,819 50,707 361,845 -
TOTAL DEBT SERVICE - - - 464,637 50,707 361,845 -
CAPITAL PROJECTS 17,164 - - 1,439,911 1,503,462 1,502,144 -
TRANSFERS IN/(OUT)- - - (846) - (993) -
CHANGE IN FUND BALANCE 1,051,619 201,432 372,815 2,796,605 2,150,787 2,196,190 134,084
BEGINNING FUND BALANCE, Jan 1 3,459,189 5,267 3,000,312 33,913,567 17,410,002 13,934,705 5,089,769
ENDING FUND BALANCE, Jun 30 4,510,808 206,699 3,373,127 36,710,172 19,560,789 16,130,895 5,223,853
Monthly Financial Report July 2018
Page | 11
Preliminary as of 09/11/2018
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 - 153,132 - - - - -
Grants / intergovernmental - - - - - - 45,754
Charges for services
Equipment rental m&o 1,611,619 2,527,524 - - - - -
Print and mail - - - 259,300 - - -
Communications - 409,169 - 389,465 - - -
Facilities - - 2,886,640 - - - -
Data cards and cell phones - - - - - - -
IT service contracts - - - - - - -
Interest and other misc 44,297 23,108 10,114 4,079 114,210 30,830 80,131
Internal service fund misc:
Vehicle / equipment capital recovery 1,214,643 122,969 - - - - -
Insurance premiums - - - - 1,008,976 - -
Worker's comp/unemployment - - - - 804,732 - -
Benefit premiums - - - - - 5,453,426 1,531,064
Other misc 221 10 1 - - 548,919 -
Interfund Loan - - - - - - -
Capital contributions - - - - - - -
Disposal of capital assets 33,568 - - - - - -
Insurance recoveries - - - - 265,497 - -
TOTAL REVENUES 2,904,348 3,235,912 2,896,755 652,844 2,193,415 6,033,175 1,656,949
EXPENSES:
Communications 365,932
Equipment rental 1,462,418
Facilities 2,808,249
Healthcare 6,221,854
Information technology 2,966,143
Print and mail 243,580
Retiree healthcare 449,338
Risk management:
Risk management 1,133,494
Unemployment 33,529
Worker's compensation 724,585
TOTAL EXPENSES 1,462,418 2,966,143 2,808,249 609,512 1,891,608 6,221,854 449,338
AMOUNT AVAILABLE FOR CAPITAL 1,441,930 269,769 88,506 43,332 301,807 (188,679) 1,207,611
CAPITAL PROJECTS 1,534,108 345,154 48,451 - - - -
TRANSFERS IN - 25,635 2,456 - - - -
TRANSFERS (OUT)(3,190) - - - - - -
CHANGE IN FUND BALANCE (95,368) (49,750) 42,511 43,332 301,807 (188,679) 1,207,611
BEGINNING FUND BALANCE, Jan 1 6,882,620 3,737,060 1,530,747 608,145 17,731,130 4,617,488 11,887,344
ENDING FUND BALANCE, Jun 30 6,787,252 3,687,310 1,573,258 651,477 18,032,937 4,428,809 13,094,955
Monthly Financial Report July 2018
Page | 12
Preliminary as of 09/11/2018
FUND BALANCE
Page 14 shows the ending fund balance as of July 2018. 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 July, the City has $45.6M reported in the combined general governmental fund balance of the current year’s operating
budget, which is approximately 44.7% of budgeted operating expenditures. This is an increase of $12.3M from the year’s beginning
balance. July’s ending fund balance is over the anticipated General Governmental Fund Balance of $37.7M by $8.6M or 23.3%. Although
the ending fund balance is above projections, it is consistent with the prior years’ trends. At this time last year, the fund balance was 20.2%
above the projected year-to-date budget, however, the increase in fund balance for the month of July compared to this time last year is
very similar ($8.6M for 2018 vs $6.6M for 2017).
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
mgordon@rentonwa.gov or JDThomas@Rentonwa.gov.
Monthly Financial Report July 2018
Page | 13
Preliminary as of 09/11/2018
City of Renton
All Funds - Revenue, Expenditures and Fund Balances
Cash Basis through July 31, 2018
Funds
Balance
01/01/018
Budgeted
Revenue
Revenue
07/31/18
Total Funds
Available
Budgeted
Expenditure
Expenditure
07/31/18 Ending Balance
GENERAL GOVERNMENT FUNDS:33,284,838 101,078,356 64,087,891 97,372,729 101,896,981 51,789,364 45,583,365
000 General 22,708,066 69,377,185 47,227,220 69,935,286 69,540,779 37,104,737 32,830,549
001 Community Services 4,840,993 13,614,554 7,391,715 12,232,708 13,708,109 6,966,166 5,266,542
003 Street 3,143,904 11,288,240 6,532,515 9,676,419 11,693,231 6,368,267 3,308,152
004 Community Dev Block Grant 54,286 873,366 - 54,286 913,367 135,331 (81,045)
005 Museum 70,992 239,129 119,904 190,896 241,246 143,077 47,820
009 Farmers Market 105,323 89,663 37,830 143,153 97,005 45,010 98,143
201 Ltd GO Bonds Gen Govt Debt 863,732 - 5,556 869,288 - 127 869,162
215 Gen Govt Misc Debt Service 1,497,542 5,596,219 2,773,150 4,270,692 5,703,244 1,026,650 3,244,042
SPECIAL REVENUE FUNDS:2,093,053 1,950,224 1,407,830 3,500,883 2,114,392 619,896 2,880,987
102 Arterial Street 108,438 670,000 396,485 504,923 670,000 - 504,923
108 Leased City Properties 611,055 967,550 672,059 1,283,114 983,406 452,576 830,538
110 Hotel Motel 461,434 200,000 252,790 714,224 309,629 141,224 573,000
125 1% For Art 103,109 15,000 665 103,774 53,683 - 103,774
127 Cable Communication 472,489 97,674 83,659 556,148 97,674 26,096 530,052
135 Springbrook Wetlands Bank 336,528 - 2,172 338,700 - - 338,700
CAPITAL PROJECT FUNDS (CIP):36,295,483 24,993,230 12,856,470 49,151,953 46,832,686 6,417,082 42,734,871
303 Community Services Mitigation 1,909,355 86,500 269,345 2,178,700 - - 2,178,700
304 Fire Mitigation 936,972 99,000 473,570 1,410,542 142,975 - 1,410,542
305 Transportation Mitigation 810,962 632,400 2,317,364 3,128,326 505,000 - 3,128,326
316 Municipal Facilities CIP 19,671,696 7,320,407 6,587,433 26,259,129 24,331,580 3,635,110 22,624,019
317 Transportation CIP 5,808,539 16,854,923 2,935,156 8,743,695 21,522,131 2,664,935 6,078,760
326 Housing Opportunity 2,548,975 - 16,483 2,565,458 - - 2,565,458
336 New Library Development 451,093 - 2,866 453,959 - 12 453,947
346 New Family First Center Dvlpmnt 4,157,891 - 254,253 4,412,144 331,000 117,025 4,295,119
ENTERPRISE FUNDS:76,812,811 86,313,733 49,325,032 126,137,843 133,581,645 40,421,498 85,716,345
4X2 Airport Operating & CIP 3,459,189 3,637,862 2,138,986 5,598,175 6,209,762 1,087,367 4,510,808
403 Solid Waste Utility 3,000,312 19,505,718 10,119,599 13,119,911 19,368,508 9,746,784 3,373,127
4X4 Golf Operating & CIP 5,267 2,287,213 1,469,591 1,474,858 2,287,585 1,268,159 206,699
4X5 Water Operating & CIP 33,913,567 17,420,439 10,524,106 44,437,673 42,826,090 7,727,500 36,710,173
4X6 Waste Water Operating & CIP 17,410,002 10,103,577 7,183,133 24,593,135 21,691,422 5,032,346 19,560,789
416 King County Metro 5,089,769 17,505,693 9,736,913 14,826,682 17,505,693 9,602,830 5,223,852
4X7 Surface Water Operating & CIP 13,934,705 15,853,231 8,152,704 22,087,409 23,692,585 5,956,512 16,130,897
INTERNAL SERVICE FUNDS:46,994,534 30,843,875 19,601,490 66,596,024 34,910,223 18,340,026 48,255,998
501 Equipment Repair/Replacement 6,882,620 6,306,622 2,904,349 9,786,969 8,064,462 2,999,717 6,787,252
502 Insurance 17,731,130 3,307,514 2,193,415 19,924,545 3,315,116 1,891,608 18,032,937
503 Information Services 3,737,060 5,673,080 3,261,546 6,998,606 7,386,392 3,311,297 3,687,309
504 Facilities 1,530,747 5,004,802 2,899,211 4,429,958 5,365,113 2,856,700 1,573,258
505 Communications 608,145 1,102,300 652,844 1,260,989 1,106,329 609,512 651,477
512 Insurance, Healthcare 4,617,488 8,191,708 6,033,176 10,650,664 8,578,084 6,221,854 4,428,810
522 Insurance, Leoff1 Retirees HC 11,887,344 1,257,849 1,656,949 13,544,293 1,094,727 449,338 13,094,955
FIDUCIARY FUNDS:5,832,897 468,000 179,404 6,012,301 200,475 114,095 5,898,206
611 Firemen's Pension 5,832,897 468,000 179,404 6,012,301 200,475 114,095 5,898,206
TOTAL FUNDS 201,313,616 245,647,418 147,458,117 348,771,733 319,536,402 117,701,961 231,069,772
City of Renton
General Government Financial Position
2018 Budget Year
General Government Summary General Government Summary - Budgeted
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
33,284,838
January 8,189,596 6,868,916 1,320,680 34,605,518
February 16,348,402 14,082,847 2,265,555 35,550,393
March 23,642,627 21,729,189 1,913,438 35,198,276
April 41,909,125 28,695,484 13,213,641 46,498,479
May 51,384,537 36,202,262 15,182,276 48,467,114
June 57,592,687 43,674,562 13,918,125 47,202,963
July 64,087,891 51,789,364 12,298,527 45,583,365
August
September
October
November
December
(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
16,000,000
17,000,000
-
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
60,000,000
70,000,000
80,000,000
90,000,000
100,000,000
110,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Change in Fund
Balance
Rev/Exp Revenues
Expenditures
Change in Fund Balance
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,927,790 8,189,596 3.30%
Feb 14,511,384 16,348,402 12.66%
Mar 21,056,246 23,642,627 12.28%
Apr 33,162,580 41,909,125 26.37%
May 43,859,696 51,384,537 17.16%
Jun 50,133,091 57,592,687 14.88%
Jul 58,026,170 64,087,891 10.45%
Aug 64,915,572
Sep 71,262,009
Oct 82,288,508
Nov 93,717,424
Dec 101,078,355
Percent of budget 63.40%
Property Tax Budget
YTD
Actual
Annual %
over (under)
Jan 31,649 (12,745) -140.27%
Feb 192,923 93,620 -51.47%
Mar 880,619 759,091 -13.80%
Apr 5,585,498 7,667,724 37.28%
May 10,133,810 10,087,649 -0.46%
Jun 10,218,049 10,196,490 -0.21%
Jul 10,258,103 10,286,562 0.28%
Aug 10,366,119
Sep 10,682,507
Oct 13,934,125
Nov 19,305,972
Dec 19,397,308
Percent of budget 53.03%
$-
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
$130
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$(3)
$-
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
$39
Millions Property Tax
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 2,260,736 2,481,092 9.75%
Feb 4,948,626 5,657,031 14.32%
Mar 7,092,465 8,004,696 12.86%
Apr 9,200,855 10,252,667 11.43%
May 11,717,901 13,054,786 11.41%
Jun 13,938,141 15,289,603 9.70%
Jul 16,253,766 17,675,268 8.75%
Aug 18,828,019
Sep 21,239,052
Oct 23,758,560
Nov 26,381,491
Dec 28,803,740
Percent of budget 61.36%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
Utility Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,472,870 1,395,386 -5.26%
Feb 2,886,038 3,013,358 4.41%
Mar 4,135,571 4,592,549 11.05%
Apr 5,628,573 6,055,885 7.59%
May 6,970,433 7,470,841 7.18%
Jun 8,143,555 8,740,443 7.33%
Jul 9,485,903 10,139,403 6.89%
Aug 10,640,985
Sep 11,865,442
Oct 13,187,689
Nov 14,330,720
Dec 15,664,124
Percent of budget 64.73%
Note: Includes Natural Gas Use Tax.
$-
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
Millions Sales Tax
Budget
Actual
Last Year
$-
$2
$4
$6
$8
$10
$12
$14
$16
Millions Utility Tax
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 557,333 528,042 -5.26%
Feb 905,781 862,852 -4.74%
Mar 1,389,734 1,387,152 -0.19%
Apr 1,687,685 1,713,974 1.56%
May 2,112,005 2,043,697 -3.23%
Jun 2,486,234 2,300,379 -7.48%
Jul 2,878,222 2,707,591 -5.93%
Aug 3,285,243
Sep 3,652,920
Oct 4,043,793
Nov 4,367,374
Dec 4,636,213
Percent of budget 58.40%
Note: GF only
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 596,547 601,356 0.81%
Feb 1,229,636 1,241,708 0.98%
Mar 1,807,433 1,932,260 6.91%
Apr 2,354,778 2,510,510 6.61%
May 2,771,429 2,960,813 6.83%
Jun 3,384,888 3,643,008 7.63%
Jul 3,938,155 4,242,922 7.74%
Aug 4,607,304
Sep 5,213,913
Oct 5,806,595
Nov 6,313,619
Dec 7,588,646
Percent of budget 55.91%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$-
$1
$2
$3
$4
$5
$6
$7
$8
Millions
Intergovernmental
Budget
Actual
Last Year
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions Licenses & Permits
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 736,564 851,592 15.62%
Feb 1,322,090 1,451,288 9.77%
Mar 1,971,621 2,138,586 8.47%
Apr 2,606,664 2,756,537 5.75%
May 3,288,813 3,419,632 3.98%
Jun 4,176,312 4,174,120 -0.05%
Jul 5,129,315 5,053,517 -1.48%
Aug 6,081,978
Sep 6,744,386
Oct 7,386,036
Nov 8,043,187
Dec 8,785,388
Percent of budget 57.52%
Note: Excludes FD25 & FD40 contracts
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
Jan 206,614 141,625 -31.45%
Feb 516,467 366,439 -29.05%
Mar 848,097 678,550 -19.99%
Apr 1,188,305 816,484 -31.29%
May 1,501,041 1,047,246 -30.23%
Jun 1,902,089 1,282,558 -32.57%
Jul 2,231,064 1,734,001 -22.28%
Aug 2,605,798
Sep 2,897,143
Oct 3,260,828
Nov 3,622,582
Dec 4,046,487
Percent of budget 42.85%
$-
$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
Millions Fines & Forfeits
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 1,826,266 1,940,559 6.26%
Feb 2,150,560 3,235,809 50.46%
Mar 2,455,818 3,545,274 44.36%
Apr 4,311,237 9,378,175 117.53%
May 4,643,962 10,155,990 118.69%
Jun 5,018,275 10,628,530 111.80%
Jul 6,814,257 10,689,792 56.87%
Aug 7,211,253
Sep 7,531,044
Oct 9,340,928
Nov 9,673,557
Dec 10,085,686
Percent of budget 105.99%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 226,534 262,690 15.96%
Feb 346,264 413,298 19.36%
Mar 461,888 591,468 28.05%
Apr 585,985 744,168 26.99%
May 707,303 1,130,883 59.89%
Jun 852,548 1,324,557 55.36%
Jul 1,024,385 1,545,836 50.90%
Aug 1,187,445
Sep 1,321,494
Oct 1,443,169
Nov 1,539,458
Dec 1,918,622
Percent of budget 80.57%
$-
$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
$13
$14
Millions Other Taxes
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan 12,679 - 0.00%
Feb 13,000 13,000 0.00%
Mar 13,000 13,000 0.00%
Apr 13,000 13,000 0.00%
May 13,000 13,000 0.00%
Jun 13,000 13,000 0.00%
Jul 13,000 13,000 0.00%
Aug 101,428
Sep 114,107
Oct 126,785
Nov 139,464
Dec 152,142
Percent of budget 8.54%
REET Budget
YTD
Actual
Annual %
over (under)
Jan 786,056 840,316 6.90%
Feb 996,074 1,206,327 21.11%
Mar 1,388,016 1,497,372 7.88%
Apr 1,654,828 1,903,118 15.00%
May 1,955,479 2,510,550 28.39%
Jun 2,413,482 3,007,467 24.61%
Jul 2,853,657 3,854,099 35.06%
Aug 3,360,851
Sep 3,792,293
Oct 4,100,637
Nov 4,499,171
Dec 4,420,000
Percent of budget 87.20%
$-
$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
$7.50
$8.00
Millions
Real Estate Excise Tax
Budget
Actual
Last Year
$0
$0
$0
$0
$0
$0
$0
MillionsOther Financing Sources
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Bldg Permits &
Devlpmt Svc
Fees Budget
YTD
Actual
Annual %
over (under)
Jan 567,204 314,626 -44.53%
Feb 936,369 595,371 -36.42%
Mar 1,517,506 1,183,898 -21.98%
Apr 1,839,013 1,587,790 -13.66%
May 2,338,784 2,024,732 -13.43%
Jun 2,899,199 2,388,253 -17.62%
Jul 3,287,609 2,873,173 -12.61%
Aug 3,731,695
Sep 4,173,216
Oct 4,609,871
Nov 5,024,686
Dec 5,451,699
Percent of budget 52.70%
B & O Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,527,200 1,301,574 -14.77%
Feb 1,718,100 2,315,204 34.75%
Mar 1,909,000 2,363,482 23.81%
Apr 3,436,200 7,793,531 126.81%
May 3,627,100 8,006,272 120.73%
Jun 3,818,000 8,178,959 114.22%
Jul 5,345,200 9,019,798 68.75%
Aug 5,536,100
Sep 5,727,000
Oct 7,254,200
Nov 7,445,100
Dec 7,636,000
Percent of budget 118.12%
$-
$1.00
$2.00
$3.00
$4.00
$5.00
$6.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
$7.50
$8.00
$8.50
$9.00
$9.50
$10.00
$10.50
Millions Business & Occupation Tax
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,326,356 6,868,916 -6.24%
Feb 14,797,570 14,082,847 -4.83%
Mar 22,457,513 21,729,189 -3.24%
Apr 29,820,622 28,695,484 -3.77%
May 37,758,393 36,202,262 -4.12%
Jun 45,713,728 43,674,562 -4.46%
Jul 54,336,814 51,789,364 -4.69%
Aug 66,330,433
Sep 75,062,345
Oct 83,633,486
Nov 91,792,764
Dec 101,896,981
Percent of budget expended 50.83%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 36,796 38,187 3.78%
Feb 67,098 68,247 1.71%
Mar 102,377 98,763 -3.53%
Apr 133,436 131,800 -1.23%
May 163,576 162,362 -0.74%
Jun 194,460 191,630 -1.46%
Jul 224,009 221,457 -1.14%
Aug 253,784
Sep 283,711
Oct 313,912
Nov 343,921
Dec 374,666
Percent of budget expended 59.11%
$-
$20
$40
$60
$80
$100
$120
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
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 221,352 216,805 -2.05%
Feb 368,780 370,213 0.39%
Mar 535,836 545,152 1.74%
Apr 684,707 699,202 2.12%
May 843,698 846,929 0.38%
Jun 1,016,843 1,019,144 0.23%
Jul 1,167,925 1,173,506 0.48%
Aug 1,346,961
Sep 1,513,208
Oct 1,677,989
Nov 1,826,370
Dec 2,046,962
Percent of budget expended 57.33%
Emergency
Management Budget
YTD
Actual
Annual %
over (under)
Jan 40,141 46,027 14.66%
Feb 84,100 92,381 9.85%
Mar 139,488 143,430 2.83%
Apr 192,211 189,109 -1.61%
May 241,243 241,268 0.01%
Jun 291,079 290,880 -0.07%
Jul 341,927 343,115 0.35%
Aug 420,323
Sep 475,750
Oct 528,258
Nov 579,455
Dec 628,191
Percent of budget expended 54.62%
$-
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
Millions Executive
Budget
Actual
Last Year
$-
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
Emergency Management
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 181,299 177,424 -2.14%
Feb 367,733 359,168 -2.33%
Mar 560,714 542,881 -3.18%
Apr 760,231 728,768 -4.14%
May 948,912 912,104 -3.88%
Jun 1,137,476 1,097,367 -3.53%
Jul 1,327,735 1,281,888 -3.45%
Aug 1,518,134
Sep 1,710,502
Oct 1,899,635
Nov 2,087,929
Dec 2,267,734
Percent of budget expended 56.53%
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 176,384 182,051 3.21%
Feb 359,319 371,810 3.48%
Mar 546,315 561,465 2.77%
Apr 734,460 749,786 2.09%
May 920,481 936,015 1.69%
Jun 1,108,912 1,124,445 1.40%
Jul 1,293,945 1,308,186 1.10%
Aug 1,479,202
Sep 1,674,344
Oct 1,861,659
Nov 2,050,602
Dec 2,250,644
Percent of budget expended 58.12%
$-
$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.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions City Attorney
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 109,523 111,659 1.95%
Feb 219,526 223,634 1.87%
Mar 329,528 335,635 1.85%
Apr 439,743 449,552 2.23%
May 550,170 561,505 2.06%
Jun 665,842 673,328 1.12%
Jul 777,227 785,314 1.04%
Aug 888,696
Sep 1,000,092
Oct 1,110,844
Nov 1,221,394
Dec 1,344,262
Percent of budget expended 58.42%
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 264,534 239,592 -9.43%
Feb 556,675 474,218 -14.81%
Mar 837,976 704,870 -15.88%
Apr 1,122,798 938,343 -16.43%
May 1,411,145 1,182,919 -16.17%
Jun 1,706,788 1,444,178 -15.39%
Jul 1,999,686 1,703,575 -14.81%
Aug 2,295,263
Sep 2,610,625
Oct 2,908,222
Nov 3,230,941
Dec 3,446,946
Percent of budget expended 49.42%
$-
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions
Community & Economic
Development Admin
Budget
Actual
Last Year
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 83,088 54,919 -33.90%
Feb 176,786 142,952 -19.14%
Mar 263,098 191,708 -27.13%
Apr 408,967 236,753 -42.11%
May 602,284 288,153 -52.16%
Jun 767,566 347,114 -54.78%
Jul 901,182 404,143 -55.15%
Aug 1,027,319
Sep 1,180,119
Oct 1,356,648
Nov 1,493,484
Dec 1,671,873
Percent of budget expended 24.17%
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 275,164 230,023 -16.41%
Feb 557,855 479,452 -14.05%
Mar 849,006 743,111 -12.47%
Apr 1,134,716 981,781 -13.48%
May 1,437,433 1,217,342 -15.31%
Jun 1,735,366 1,462,823 -15.71%
Jul 2,022,188 1,714,367 -15.22%
Aug 2,320,523
Sep 2,619,476
Oct 2,906,654
Nov 3,190,797
Dec 3,580,743
Percent of budget expended 47.88%
$-
$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
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions
Planning
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 247,466 215,045 -13.10%
Feb 509,222 446,774 -12.26%
Mar 754,095 674,895 -10.50%
Apr 1,016,230 910,304 -10.42%
May 1,279,092 1,172,940 -8.30%
Jun 1,563,543 1,409,917 -9.83%
Jul 1,846,099 1,720,649 -6.80%
Aug 2,157,827
Sep 2,413,530
Oct 2,676,985
Nov 2,933,444
Dec 3,660,725
Percent of budget expended 47.00%
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 86,384 73,376 -15.06%
Feb 328,209 154,002 -53.08%
Mar 421,047 493,757 17.27%
Apr 516,953 572,896 10.82%
May 613,842 682,037 11.11%
Jun 713,074 765,641 7.37%
Jul 816,413 845,406 3.55%
Aug 988,415
Sep 1,009,569
Oct 1,105,988
Nov 1,209,533
Dec 1,359,565
Percent of budget expended 62.18%
Includes Hearing Examiner
$-
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions City Clerk
Budget
Actual
Last Year
$-
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
$2.80
$3.20
$3.60
$4.00
Millions Finance
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 102,634 93,068 -9.32%
Feb 208,536 196,272 -5.88%
Mar 330,862 299,021 -9.62%
Apr 457,074 416,778 -8.82%
May 568,827 520,504 -8.50%
Jun 680,424 621,117 -8.72%
Jul 794,574 734,589 -7.55%
Aug 917,307
Sep 1,033,849
Oct 1,158,702
Nov 1,271,446
Dec 1,395,877
Percent of budget expended 52.63%
Police Budget
YTD
Actual
Annual %
over (under)
Jan 3,316,808 3,128,806 -5.67%
Feb 6,284,441 6,112,773 -2.73%
Mar 9,768,766 9,490,170 -2.85%
Apr 12,785,960 12,493,987 -2.28%
May 16,197,840 15,900,505 -1.84%
Jun 19,255,973 18,843,188 -2.14%
Jul 22,972,666 22,164,057 -3.52%
Aug 26,085,938
Sep 29,577,322
Oct 32,673,902
Nov 35,936,640
Dec 39,788,478
Percent of budget expended 55.70%
$-
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions Human Resources
Budget
Actual
Last Year
$-
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Millions Police
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 45,023 39,217 -12.90%
Feb 92,353 85,085 -7.87%
Mar 132,149 128,636 -2.66%
Apr 170,514 173,564 1.79%
May 212,599 217,983 2.53%
Jun 250,135 262,197 4.82%
Jul 288,979 298,799 3.40%
Aug 327,923
Sep 366,027
Oct 404,645
Nov 442,821
Dec 532,039
Percent of budget expended 56.16%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 357,710 317,964 -11.11%
Feb 727,225 663,798 -8.72%
Mar 1,131,591 1,030,518 -8.93%
Apr 1,561,601 1,447,411 -7.31%
May 1,979,155 1,838,214 -7.12%
Jun 2,431,245 2,280,317 -6.21%
Jul 2,928,403 2,762,166 -5.68%
Aug 3,453,852
Sep 4,002,184
Oct 4,466,018
Nov 4,890,481
Dec 5,405,059
Percent of budget expended 51.10%
$-
$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
Community Services Admin
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 68,223 57,925 -15.09%
Feb 166,223 124,297 -25.22%
Mar 252,457 197,223 -21.88%
Apr 342,051 290,483 -15.08%
May 457,569 379,727 -17.01%
Jun 584,447 491,882 -15.84%
Jul 693,286 604,217 -12.85%
Aug 835,905
Sep 965,136
Oct 1,074,970
Nov 1,198,627
Dec 1,373,998
Percent of budget expended 43.98%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 423,994 463,109 9.23%
Feb 893,276 895,385 0.24%
Mar 1,376,118 1,324,567 -3.75%
Apr 1,869,292 1,764,803 -5.59%
May 2,334,208 2,199,891 -5.75%
Jun 2,849,384 2,662,864 -6.55%
Jul 3,588,307 3,320,468 -7.46%
Aug 4,359,694
Sep 5,024,875
Oct 5,513,411
Nov 5,994,520
Dec 6,492,163
Percent of budget expended 51.15%
$-
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
$1,400,000
$1,600,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
$6.00
$6.50
$7.00
Millions Recreation
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Human Services Budget
YTD
Actual
Annual %
over (under)
Jan 90,222 55,197 -38.82%
Feb 192,818 184,247 -4.44%
Mar 263,399 243,570 -7.53%
Apr 365,819 339,032 -7.32%
May 496,257 560,102 12.87%
Jun 557,968 616,401 10.47%
Jul 685,922 829,262 20.90%
Aug 808,203
Sep 870,635
Oct 1,044,313
Nov 1,160,522
Dec 1,441,591
Percent of budget expended 57.52%
Neighborhoods,
Resources, and
Events Budget
YTD
Actual
Annual %
over (under)
Jan 127 (68,523) -53868.66%
Feb 271 2,059 660.08%
Mar 414 2,059 397.85%
Apr 537 2,459 357.75%
May 675 2,454 263.61%
Jun 810 7,818 865.29%
Jul 1,011 25,526 2423.60%
Aug 1,192
Sep 1,348
Oct 1,501
Nov 1,633
Dec 1,855
Percent of budget expended 1376.05%
$-
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions Human Services
Budget
Actual
Last Year
$(200,000)
$-
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
Neighborhoods, Resources, and Events
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 19,943 19,889 -0.27%
Feb 39,991 40,634 1.61%
Mar 59,393 60,984 2.68%
Apr 79,159 81,439 2.88%
May 98,532 102,003 3.52%
Jun 118,175 122,512 3.67%
Jul 138,557 143,077 3.26%
Aug 158,827
Sep 179,495
Oct 200,268
Nov 220,924
Dec 241,246
Percent of budget expended 59.31%
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 34,486 34,521 0.10%
Feb 69,669 69,361 -0.44%
Mar 104,789 104,253 -0.51%
Apr 139,642 140,203 0.40%
May 174,360 175,219 0.49%
Jun 209,285 210,071 0.38%
Jul 244,157 248,162 1.64%
Aug 279,239
Sep 314,679
Oct 348,881
Nov 383,025
Dec 417,024
Percent of budget expended 59.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
Museum Fund
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 447,488 428,817 -4.17%
Feb 954,625 859,296 -9.99%
Mar 1,449,328 1,354,087 -6.57%
Apr 1,985,639 1,808,825 -8.90%
May 2,486,690 2,245,930 -9.68%
Jun 2,971,378 2,712,839 -8.70%
Jul 3,449,731 3,166,956 -8.20%
Aug 3,931,101
Sep 4,431,705
Oct 4,919,562
Nov 5,386,040
Dec 5,887,710
Percent of budget expended 53.79%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 349,888 366,141 4.65%
Feb 724,525 818,473 12.97%
Mar 1,160,912 1,370,577 18.06%
Apr 1,600,064 1,829,389 14.33%
May 2,143,162 2,259,514 5.43%
Jun 2,586,186 2,699,517 4.38%
Jul 3,043,717 3,201,311 5.18%
Aug 3,486,730
Sep 3,942,584
Oct 4,745,428
Nov 5,129,615
Dec 5,805,521
Percent of budget expended 55.14%
$-
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
Millions Street Maintenance
Budget
Actual
Last Year
$0.0
$1.0
$2.0
$3.0
$4.0
$5.0
$6.0
Millions Transportation
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 37,996 37,996 0.00%
Feb 288,313 288,313 0.00%
Mar 290,010 290,010 0.00%
Apr 290,010 290,010 0.00%
May 290,010 290,010 0.00%
Jun 777,530 777,530 0.00%
Jul 1,026,776 1,026,776 0.00%
Aug 3,802,163
Sep 4,277,433
Oct 4,752,703
Nov 5,227,974
Dec 5,703,244
Percent of budget expended 18.00%
Non-
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 309,681 309,681 0.00%
Feb 560,003 560,003 0.00%
Mar 797,846 797,846 0.00%
Apr 1,028,809 1,028,809 0.00%
May 1,306,632 1,306,632 0.00%
Jun 1,539,841 1,539,841 0.00%
Jul 1,762,393 1,762,393 0.00%
Aug 3,185,909
Sep 3,584,148
Oct 3,982,387
Nov 4,380,625
Dec 4,778,864
Percent of budget expended 36.88%
$-
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
Millions Non-Departmental Other City Services
Budget
Actual
Last Year
$-
$1
$2
$3
$4
$5
$6
$7
Millions Debt Service
Budget
Actual
Last Year
City of Renton
Monthly Enterprise Fund Financial Report - 2018 Budget Year
Utilities Budget Revenue Expense
Jan - 4,985,834 3,338,103
Feb - 11,573,313 9,275,111
Mar - 20,015,488 15,056,895
Apr - 26,084,578 20,384,128
May - 32,341,402 27,050,704
Jun - 39,797,145 33,020,015
Jul - 45,716,350 38,064,135
Aug -
Sep -
Oct -
Nov -
Dec -
Percent of budget expended 100.00%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan - 237,743 123,513
Feb - 489,156 267,530
Mar - 739,253 442,543
Apr - 1,014,841 611,773
May - 1,249,585 762,052
Jun - 1,478,450 919,610
Jul - 2,138,986 1,087,367
Aug -
Sep -
Oct -
Nov -
Dec -
Percent of budget expended 100.00%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
Millions Utilities
Budget
Revenue
Expense
$-
$0.50
$1.00
$1.50
$2.00
$2.50
Millions Airport
Budget
Revenue
Expense
City of Renton
Monthly Enterprise Fund Financial Report - 2018 Budget Year
Golf Course Budget Revenue Expense
Jan - 66,977 144,831
Feb - 138,056 313,308
Mar - 293,466 480,261
Apr - 503,971 669,183
May - 745,952 876,008
Jun - 1,131,733 1,066,048
Jul - 1,469,591 1,268,159
Aug -
Sep -
Oct -
Nov -
Dec -
Percent of budget expended 100.00%
Note: Operations and Capital
$-
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Golf Course
Budget
Revenue
Expense