HomeMy WebLinkAbout201404, April.pdfADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: June 5, 2014
TO: Don Persson, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: April 2014 Financial Status Report
At the end of April, general governmental revenues show $2.7 million or 7.8% under budget.
This is due to the timing of property tax collections recorded in April. If we remove the $4.3
million unfavorable property tax variance, the City is $1.6 million or 4.5% over budget.
Revenues sources that are higher than expected are: sales tax ($80k); sales tax annexation
credit ($77k); utility taxes ($111k); state shared revenue ($181k); real estate excise tax ($719k);
building permits & development service fees ($538k) and other miscellaneous ($143k). On the
down side, the revenue sources that are underperforming the year to date budget are:
property tax ($4.3 million below) and fines/penalties ($268k below).
General government expenditures showed a favorable variance of $794k or 2.4%. See page 9
of report for further expenditure over‐spent explanations.
The attached report provides more detailed discussion of each revenue source and our updated
projections for the year. Please do not hesitate to contact me at x6952 should you have any
questions or any suggestions about the report.
This page is intentionally left blank
General Governmental Funds
$%
Beginning Fund Balance 11,057,551$ 11,057,551$ 15,575,840$ 15,575,840$ 17,454,261$ 17,454,261$ 17,454,261$ ‐ 0.0%
OPERATING REVENUES
Property Tax 33,466,364 11,127,076 32,485,690 10,985,190 35,240,495 11,815,359 7,509,891 (4,305,468) ‐36.4%
Sales Tax 18,564,670 5,925,812 20,416,372 6,629,791 20,196,000 6,727,034 6,807,199 80,166 1.2%
Sales Tax ‐ Annexation Credit 2,208,492 711,311 2,418,789 783,994 2,236,262 722,648 799,863 77,215 10.7%
Criminal Justice Sales Tax 1,924,470 606,636 2,091,174 668,470 2,000,000 635,069 721,451 86,382 13.6%
Natural Gas Use Tax 272,530 164,028 263,660 107,195 300,000 151,750 135,655 (16,095) ‐10.6%
Admission Tax 311,054 154,705 327,258 152,751 308,000 148,355 154,406 6,052 4.1%
Franchise Fees 1,262,188 599,927 1,312,727 627,348 1,260,000 600,550 646,666 46,115 7.7%
Electricity Tax 5,211,111 1,972,182 5,155,789 1,932,839 5,409,000 2,037,471 1,992,820 (44,651) ‐2.2%
Natural Gas Utility Tax 1,669,967 902,298 1,550,900 803,039 1,500,520 794,473 862,483 68,010 8.6%
Garbage/Solid Waste 330,607 87,625 397,596 131,525 300,000 90,284 191,379 101,095 112.0%
TV Cable 1,423,664 435,101 1,481,779 459,812 1,529,365 471,064 478,060 6,996 1.5%
Telephone 1,056,420 308,743 917,021 251,827 952,500 270,565 274,371 3,807 1.4%
Cellular Phone 2,183,853 736,280 2,050,312 566,096 2,077,000 638,859 578,839 (60,020) ‐9.4%
City Utilities 3,806,281 1,198,213 3,964,989 1,226,148 3,791,465 1,182,803 1,234,510 51,707 4.4%
Leasehold Excise Tax 158,849 36,481 164,637 40,988 145,000 34,725 43,738 9,013 26.0%
Gambling Excise Tax 1,691,209 574,574 1,319,585 478,183 1,600,000 559,457 522,560 (36,897) ‐6.6%
Real Estate Excise Tax 2,811,902 690,220 4,131,665 822,064 2,900,000 1,028,144 1,747,345 719,201 70.0%
Less: CIP REET (943,792) (136,340) (700,000) (158,095) (550,000) (331,387) (331,387) ‐ 0.0%
EMS Levy 885,781 ‐ 916,361 ‐ 900,000 225,392 225,392 ‐ 0.0%
Business License Fees 444,680 206,858 503,766 251,128 533,067 257,408 230,602 (26,806) ‐10.4%
Animal Licenses and Spec Events Permits 91,835 39,385 99,411 36,765 90,000 35,489 36,518 1,028 2.9%
Building Permits & Development Svc Fees 3,552,369 922,924 4,001,625 1,229,874 3,705,701 1,069,262 1,607,401 538,139 50.3%
Intergovt'l (Grants, State Shared, etc) 4,593,185 1,086,517 3,863,974 1,431,975 4,188,188 1,660,341 1,754,785 94,444 5.7%
Fire District 25 and 40 Contracts 6,155,621 799,107 5,726,895 700,813 5,877,463 797,257 797,257 ‐ 0.0%
Public Safety 485,899 153,856 680,581 250,466 774,535 268,467 245,008 (23,459) ‐8.7%
Culture and Recreation 1,494,165 363,431 1,494,580 361,738 1,525,863 370,225 384,136 13,911 3.8%
Interfund/Interdept‐Services 3,311,715 996,283 3,464,913 1,164,844 3,332,794 1,110,931 1,141,789 30,857 2.8%
Fines and Penalties 1,046,246 275,874 1,137,140 313,662 1,108,500 301,587 355,263 53,676 17.8%
Photo Enforcement 1,976,203 654,101 1,629,524 680,026 1,950,000 721,504 400,235 (321,269) ‐44.5%
Seizure Funds ‐ Federal/State/Local 37,941 17,904 50,639 3,491 180,693 12,458 (470) (12,928) ‐103.8%
Interests and Other Earnings 342,424 29,924 423,609 29,926 745,300 58,231 43,538 (14,693) ‐25.2%
Rents, Leases, and Concessions 822,428 317,035 734,530 317,273 756,464 308,185 306,400 (1,785) ‐0.6%
Contributions and Donations 124,082 46,718 84,320 25,736 96,100 33,411 28,512 (4,899) ‐14.7%
Other Miscellaneous 564,571 166,458 684,187 238,837 516,630 177,423 320,761 143,338 80.8%
Other Financing Sources (Transfer‐In, etc) 5,118,188 8,797 299,527 13,343 ‐ ‐ 3,447 3,447 100.0%
Total Operating Revenues 108,457,170 32,180,045 105,545,527 33,559,062 107,476,905 34,984,794 32,250,423 (2,734,371) ‐7.8%
OPERATING EXPENDITURES
Council 278,768 91,998 289,911 97,646 309,907 103,348 108,911 (5,563) ‐5.4%
Executive 1,377,109 427,410 1,240,910 419,061 1,359,996 439,720 407,807 31,913 7.3%
City Attorney 1,706,320 563,552 1,922,225 584,735 1,863,395 589,689 562,501 27,188 4.6%
Court Services 2,074,980 674,406 2,003,104 643,564 2,094,010 676,750 660,115 16,635 2.5%
Community and Eco Dvlpmnt Admin 942,071 322,177 1,047,860 344,293 1,012,142 338,988 333,812 5,176 1.5%
Development Services 2,902,852 890,756 3,243,702 1,060,776 3,040,435 967,749 931,956 35,794 3.7%
Economic Development 529,043 188,315 467,511 146,523 644,063 216,402 186,131 30,271 14.0%
Planning 1,682,948 562,160 1,510,707 480,129 2,261,206 735,514 584,673 150,841 20.5%
Finance 2,221,882 635,592 2,274,147 610,911 2,334,758 647,301 678,686 (31,385) ‐4.8%
City Clerk1 997,434 247,568 1,020,822 277,252 1,125,927 292,782 446,560 (153,778) ‐52.5%
Human Resources 937,412 299,810 904,182 288,203 1,002,994 320,251 294,344 25,908 8.1%
Police 25,004,580 8,318,096 24,946,784 8,188,792 25,925,197 8,567,220 8,533,912 33,308 0.4%
Jail Services 3,489,616 1,162,786 3,814,042 1,271,352 4,500,000 1,253,219 1,253,219 ‐ 0.0%
Fire 24,173,315 8,435,070 24,444,372 8,636,731 25,219,873 8,855,803 8,701,872 153,931 1.7%
Community Services Admin 434,558 143,787 452,146 150,854 493,982 164,144 158,781 5,362 3.3%
Parks 4,004,054 1,179,119 4,024,756 1,192,965 4,311,514 1,273,822 1,154,945 118,877 9.3%
Parks Planning & Natural Resources 577,934 169,504 829,250 196,871 880,373 229,214 201,429 27,785 12.1%
Recreation 4,982,229 1,377,160 4,846,970 1,371,571 5,111,272 1,429,365 1,262,485 166,880 11.7%
Human Services 1,193,871 409,836 1,162,330 340,261 1,221,989 389,020 385,688 3,333 0.9%
Neighborhoods, Resources, & Events 701,673 189,349 770,841 231,744 979,716 280,168 257,492 22,675 8.1%
Library 278,604 58,604 ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
Museum 216,887 71,901 209,387 69,807 226,683 75,357 66,789 8,569 11.4%
Public Works Admin 470,051 158,967 426,312 163,297 456,340 164,065 127,778 36,287 22.1%
Street Maintenance 3,755,640 1,217,508 3,814,132 1,294,196 4,488,268 1,489,239 1,423,475 65,765 4.4%
Transportation 4,615,160 1,428,601 4,476,854 1,512,690 4,539,752 1,468,622 1,450,448 18,174 1.2%
Debt Service 9,752,337 842,026 8,048,508 835,676 8,340,863 916,538 916,538 ‐ 0.0%
Non‐Departmental and Other 4,637,555 1,176,929 5,475,340 1,221,630 7,881,844 1,028,664 1,028,664 ‐ 0.0%
Total Operating Expenditures 103,938,882 31,242,984 103,667,105 31,631,530 111,626,501 32,912,955 32,119,009 793,947 2.4%
Total Ending Fund Balance 15,575,840$ 11,994,612$ 17,454,262$ 17,503,372$ 13,304,665$ 19,526,100$ 17,585,675$ (1,940,424)$ ‐9.9%
1Hearing Examiner is reported under City Clerk
Favorable (Unfavorable)
2012 2013 2014 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report April 2014
Page 1 of 36
Monthly Financial Report April 2014
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through April 30, 2014. Except as
noted, year‐to‐date budgeted (adjusted) revenues and operating expenditures are generally based on the
collection/disbursement patterns for the same period of the preceding two years. The table on the previous page
summarizes the general governmental fund revenues and expenditures.
Revenues
Taxes
The combined collection of property, sales/use, utility, gambling, admissions, and real estate excise taxes represents 74% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
April’s collection is $5.8 million,
making the total year‐to‐date
collection $7.5 million or 21.3% of the
total budget. In comparison to the
previous year, the City collected $3.5
million or 32% less. Compared to the
budget, the City is below projections
by $4.3 million or 36%. The variance
from the monthly budget is due the
timing of collections. The City has
collected $11 million so far for the
month of May. The City is projecting
property tax to meet the budget at
year‐end.
Sales Tax
April 2014 sales tax receipts totalled
$1.6 million. Compared with the same
month last year, it is $48k or 3% more.
Compared to the projected current
month’s budget, it is $9k or 1% above.
The year‐to‐date collection of $6.8
million is $177k or 3% more than the
prior year and is also $80k or 1% more
than budgeted. 2014’s monthly
budgets are generally based on 2006
through 2013 collections. The City is
projecting sales tax to meet the
budget at year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 154,945$ 162,468$ (101,807)$ (256,752)$ ‐166% (264,275)$ ‐163%
Feb 25,020 59,096 176,551 151,531 606% 117,455 199%
Mar 917,901 960,884 1,626,283 708,382 77% 665,398 69%
Apr 9,887,324 10,632,911 5,808,865 (4,078,459) ‐41% (4,824,046) ‐45%
May 5,780,361 6,364,899
Jun 88,480 70,363
Jul 100,047 292,155
Aug 58,101 3,718
Sep 548,071 584,469
Oct 10,140,892 10,620,057
Nov 4,341,474 5,057,587
Dec 443,072 431,888
YTD Total 10,985,190$ 11,815,359$ 7,509,891$ (3,475,299)$ ‐32% (4,305,468)$ ‐36%
Annual Total 32,485,690$ 35,240,495$
Property Tax Revenues
Year to Date through April
2014 vs. 2013 2014 vs. Budget
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 1,620,555$ 1,607,453$ 1,607,045$ (13,510)$ ‐1% (408)$ 0%
Feb 1,962,886 2,047,494 2,079,673 116,787 6% 32,179 2%
Mar 1,536,397 1,523,208 1,562,210 25,814 2% 39,002 3%
Apr 1,509,953 1,548,879 1,558,271 48,318 3% 9,393 1%
May 1,732,058 1,762,699 ‐
Jun 1,552,807 1,584,050 ‐
Jul 1,647,860 1,599,650 ‐
Aug 1,833,347 1,718,742 ‐
Sep 1,741,262 1,633,772 ‐
Oct 1,790,411 1,728,992 ‐
Nov 1,802,768 1,740,835 ‐
Dec 1,686,069 1,700,227 ‐
YTD Total 6,629,791$ 6,727,034$ 6,807,199$ 177,409$ 3% 80,166$ 1%
Annual Total 20,416,372$ 20,196,000$
2014 vs. Budget2014 vs. 2013
Month
Year to Date through April
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report April 2014
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Sales Tax by Sector 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
New Construction 948,361$ 714,450$ 670,423$ (277,938)$ ‐29%$ (44,027)‐6%
Auto Sales 1,144,982 1,230,571 1,235,524 90,542 8% 4,952 0%
General Retail 2,218,143 2,268,455 2,180,827 (37,316) ‐2% (87,628)‐4%
Manufacturing 397,899 487,420 736,732 338,833 85% 249,312 51%
Wholesale 367,102 379,912 324,990 (42,112) ‐11% (54,922)‐14%
Service 1,370,580 1,466,318 1,447,772 77,191 6% (18,546)‐1%
Other 182,723 179,908 210,931 28,209 15% 31,024 17%
YTD Total 6,629,791$ 6,727,034$ 6,807,199$ 177,409$ 3%80,166$ 1%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
April utility tax revenues are $1.2
million, which is $326k or 21% lower
than the same month last year and is
also behind of the budget by $245k or
17%. The year‐to‐date collection is
$5.7 million, which is $270k or 5%
higher than the prior year and is also
$111k or 2% higher than the budget.
The City is projecting utility tax
revenues to be very close to the
budget at year‐end.
The table below breaks out Utility Tax by source. The variance for Garbage/Solid Waste (not City Utilities) is due to a one‐
time correction (under reporting during September 2013 through December 2013) receipted in February.
Utility Tax by Type 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
Electrical 1,932,839$ 2,037,471$ 1,992,820$ 59,981$ 3%$ (44,651)‐2%
Natural Gas 910,234 946,224 998,138 87,904 10% 51,915 5%
Cell 566,096 638,859 578,839 12,744 2% (60,020)‐9%
Phone 251,827 270,565 274,371 22,544 9% 3,807 1%
Cable 459,812 471,064 478,060 18,248 4% 6,996 1%
Garbage/Solid Waste 131,525 90,284 191,379 59,854 46% 101,095 112%
City Utilities 1,226,148 1,182,803 1,234,510 8,362 1% 51,707 4%
YTD Total 5,478,482$ 5,637,269$ 5,748,119$ 269,637$ 5%110,850$ 2%
Annual Total 15,782,047$ 15,859,850$
YTD as % of 35% 36%
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 1,277,860$ 1,372,593$ 1,373,119$ 95,259$ 7% 526$ 0%
Feb 1,462,236 1,490,351 1,524,563 62,327 4% 34,213 2%
Mar 1,193,129 1,310,634 1,631,438 438,309 37% 320,804 24%
Apr 1,545,257 1,463,692 1,218,999 (326,258) ‐21% (244,693) ‐17%
May 1,338,923 1,362,789
Jun 1,189,847 1,151,072
Jul 1,259,713 1,298,235
Aug 1,280,207 1,218,858
Sep 1,433,293 1,366,340
Oct 1,072,773 1,103,445
Nov 1,244,671 1,222,957
Dec 1,484,137 1,498,886
YTD Total 5,478,482$ 5,637,269$ 5,748,119$ 269,637$ 5% 110,850$ 2%
Annual Total 15,782,047$ 15,859,850$
2014 vs. Budget2014 vs. 2013
Year to Date through April
Utility Tax Revenues
Month
Page 3 of 36
Monthly Financial Report April 2014
Other Taxes
Real Estate Excise Tax
The City collected $909k in Real Estate
Excise Tax revenues (REET) for April.
This is $711k or 360% more than the
same month last year and is $540k or
146% more than the current month’s
budget. The year‐to‐date collection is
$1.7 million, which is $925k or 113%
more than the prior year and is also
$719k or 70% above the budget. The
higher than expected variance in April
is due to 3 large transactions (totalling
$619k). The monthly budget is based
on a normalized annual distribution
(2012 only). The City is projecting
REET to meet the budget at year‐end.
Gambling Tax
April’s Gambling Tax collections
totalled $104k, which is $56k or 35%
below the same month last year and is
also $64k or 38% below the current
month’s budget. The year‐to‐date
total of $523k is $44k or 9% above the
year before but is $37k or 7% below
budget. The overall lower activity is
due to 2 establishments filing for
bankruptcy.
Pull tabs overall had a 8% increase,
bingo increased by 5%, and card‐
rooms are seeing 7% lower in activities
when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly in
January, April, July, and October. Due
to the timing of when the payment
was received, the City recorded
January’s payment in February
($323k). The year‐to‐date total of
$647k is $20k or 3% higher than the
prior year and is also $47k or 8% above
the projected year‐to‐date budget.
The City is projecting Franchise Fees to
meet budget at year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 133,504$ 164,456$ 131,776$ (1,728)$ ‐1% (32,679)$ ‐20%
Feb 73,730 115,620 133,109 59,379 81% 17,489 15%
Mar 111,294 111,371 153,695 42,401 38% 42,324 38%
Apr 159,655 168,010 103,980 (55,675) ‐35% (64,030) ‐38%
May 97,660 105,619 ‐
Jun 60,074 99,613 ‐
Jul 89,157 133,068 ‐
Aug 99,930 130,972 ‐
Sep 116,204 148,130 ‐
Oct 112,141 106,090 ‐
Nov 114,909 155,314 ‐
Dec 151,327 161,736 ‐
YTD Total 478,183$ 559,457$ 522,560$ 44,377$ 9% (36,897)$ ‐7%
Annual Total 1,319,585$ 1,600,000$
2014 vs. 2013 2014 vs. Budget
Gambling Tax Revenue
Month
Year to Date through April
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 314,269$ 300,776$ ‐$ (314,269)$ ‐100% (300,776)$ ‐100%
Feb 200 98 323,121 322,921 161461% 323,023 330063%
Apr 311,986 299,239 323,544 11,558 4% 24,305 8%
Jul 315,694 303,760 ‐
Oct 321,202 308,381 ‐
Dec 48,484 47,308 ‐
YTD Total 627,348$ 600,550$ 646,666$ 20,210$ 3% 46,552$ 8%
Annual Total 1,312,727$ 1,260,000$
Franchise Fees Revenue
Year to Date through April
Month
2014 vs. 2013 2014 vs. Budget
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 134,099$ 109,119$ 162,143$ 28,044$ 21% 53,024$ 49%
Feb 262,229 301,209 448,452 186,223 71% 147,243 49%
Mar 228,077 248,682 227,629 (448) 0% (21,053) ‐8%
Apr 197,659 369,133 909,120 711,461 360% 539,987 146%
May 285,948 278,031
Jun 347,890 377,460
Jul 263,807 199,990
Aug 294,056 247,857
Sep 254,318 194,582
Oct 272,776 291,456
Nov 342,535 168,216
Dec 1,248,272 114,264
YTD Total 822,064$ 1,028,144$ 1,747,345$ 925,281$ 113% 719,201$ 70%
Annual Total 4,131,665$ 2,900,000$
Month
2014 vs. Budget2014 vs. 2013
Real Estate Excise Tax Revenues
Year to Date through April
Page 4 of 36
Monthly Financial Report April 2014
Admission Tax
Admission Tax returns are due quarterly
in January, April, July, and October of
each year. April 2014 collections
represent activities conducted during the
1st quarter of 2014. The year‐to‐date
collection of $154k is $1.7k or 1% more
than the prior year and is also $7k or 4%
more than the budget.
Licenses and Permits
Building Permits and Development
Service Fees
Building Permits and Development
Service Fee revenues totalled $374k in
April. The year‐to‐date development fees
revenue of $1.6 million is $378k or 31%
more than the year before and is also
$538k or 50% higher than budget. The
higher than expected fees are due to
collecting more in general building
permits, electrical permits, and plan
check fees. The City is projecting Building
Permits and Development Service Fees to
meet the budget at year‐end.
Business Licenses
Business Licenses totalled $97k for April,
which is $6k or 5% below the same month
last year and is also $11k or 10% below the
current month’s budget. The year‐to‐date
Business Licenses revenue of $231k is $21k
or 8% below the prior year and is also $27k
or 10% lower than the budget. The City is
projecting business licenses to be slightly
under the budget at year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 327,584$ 251,556$ 432,890$ 105,306$ 32% 181,335$ 72%
Feb 230,039 215,688 412,317 182,278 79% 196,629 91%
Mar 305,085 286,301 388,190 83,105 27% 101,889 36%
Apr 367,165 315,718 374,004 6,839 2% 58,286 18%
May 386,735 320,878
Jun 293,386 278,431
Jul 314,991 307,931
Aug 340,270 351,856
Sep 254,799 214,610
Oct 440,169 432,077
Nov 393,258 338,737
Dec 348,144 391,919
YTD Total 1,229,874$ 1,069,262$ 1,607,401$ 377,528$ 31% 538,139$ 50%
Annual Total 4,001,625$ 3,705,701$
Building Permits and Development Service Fees
Year to Date through April
2014 vs. Budget2014 vs. 2013
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 95,381$ 103,448$ 103,064$ 7,683$ 8% (384)$ 0%
Feb 40,658 36,482 25,013 (15,645) ‐38% (11,469) ‐31%
Mar 12,441 9,762 5,421 (7,020) ‐56% (4,340) ‐44%
Apr 102,648 107,716 97,104 (5,544) ‐5% (10,612) ‐10%
May 33,354 20,233 ‐
Jun 5,701 5,102 ‐
Jul 52,586 84,946 ‐
Aug 29,210 24,595 ‐
Sep 4,236 4,178 ‐
Oct 109,998 117,828 ‐
Nov 13,342 14,515 ‐
Dec 4,211 4,262 ‐
YTD Total 251,128$ 257,408$ 230,602$ (20,526)$ ‐8% (26,806)$ ‐10%
Annual Total 503,766$ 533,067$
Business Licenses
Month
2014 vs. 2013
Year to Date through April
2014 vs. Budget
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 82,440$ 75,206$ 80,243$ (2,196)$ ‐3% 5,038$ 7%
Feb ‐ 451 ‐
Apr 70,311 72,698 74,163 3,852 5% 1,464 2%
Jul 87,473 81,342 ‐
Aug 76 37 ‐
Oct 85,616 77,019 ‐
Nov 1,192 575 ‐
Dec 149 672 ‐
YTD Total 152,751$ 148,355$ 154,406$ 1,655$ 1% 6,502$ 4%
Annual Total 327,258$ 308,000$
Month
2014 vs. 2013 2014 vs. Budget
Admission Tax Revenue
Year to Date through April
Page 5 of 36
Monthly Financial Report April 2014
Intergovernmental
These revenue sources
include federal (direct and
indirect) grants, state
grants, state shared
revenues, local grants, and
entitlements. State shared
revenues and Fire Districts’
25 and 40 contracts
compose 75% of the total
revenues in this category.
The year‐to‐date total Intergovernmental revenue is $3.3 million or 27% of the budget.
State Shared Revenues
State Shared Revenue collections
totalled $1.6 million since the
start of the year. Compared to
the prior year, State Shared
Revenues are above by $188k or
13%. Compared to the projected
budget, the City is collecting
$181k or 12% more. The higher
than expected collection is due
to collecting more than
anticipated Criminal Justice Sales
Tax, the low budget of Criminal
Justice’s High Crime and
collecting more than anticipated Liquor Profits.
Charges for Services
These revenue sources consist of general government, public safety, plan review and inspection, culture and recreation,
and interfund/interdepartmental sales and services. Recreation and interfund/interdepartmental sales and services
constitute 61% of the total revenue in this category. The year‐to‐date total charges for services are $2.5 million or 35% of
the budget. The following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $245k 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 $5k or 2% less. Compared to the
year‐to‐date budget, the City is $23k or 9%
less. The reason for the April variance with the
prior year and budget is due to the lower
activity for Police private security. The City is
projecting Public Safety Services to be under
the budget by year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Crim Just Sales Tax 668,470$ 635,069$ 721,451$ 52,981$ 8% 86,382$ 14%
Judicial Contribution 5,699 5,625 11,342 5,643 99% 5,717 102%
Crim Just ‐ High Crime 102,994 ‐ 127,155 24,161 23% 127,155 100%
Crim Just ‐ Pop 10,797 ‐ 11,897 1,100 10% 11,897 100%
Crim Just ‐ Spec Prog 40,452 43,527 44,030 3,577 9% 503 1%
State DUI 8,515 9,080 8,694 180 2% (386) ‐4%
Liquor Profits 211,723 124,448 212,414 691 0% 87,965 71%
Liquor Excise Tax ‐ 248,924 92,598 92,598 100% (156,326) ‐63%
Fuel Tax 405,966 395,547 413,466 7,500 2% 17,919 5%
YTD Total 1,454,615$ 1,462,221$ 1,643,046$ 188,431$ 13% 180,825$ 12%
Annual Total 4,701,889$ 4,515,500$
2014 vs. Budget
State Shared Revenues
2014 vs. 2013
Revenue
Year to Date through April
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 32,322$ 31,574$ 117,639$ 85,317$ 264% 86,066$ 273%
Feb 117,056 100,863 45,139 (71,918) ‐61% (55,725) ‐55%
Mar 37,079 48,095 44,028 6,949 19% (4,067) ‐8%
Apr 64,009 87,936 38,202 (25,806) ‐40% (49,734) ‐57%
May 47,985 60,400 ‐
Jun 36,945 45,438 ‐
Jul 69,340 82,484 ‐
Aug 42,753 51,456 ‐
Sep 48,986 56,443 ‐
Oct 81,116 78,627 ‐
Nov 49,703 54,931 ‐
Dec 53,287 76,290 ‐
YTD Total 250,466$ 268,467$ 245,008$ (5 ,458)$ ‐2% (23,459)$ ‐9%
Annual Total 680,581$ 774,535$
Month
2014 vs. 2013
Year to Date through April
Public Safety Services
2014 vs. Budget
Intergovernmental 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
Fire District #25 538,842$ 594,325$ 594,325$ 55,483$ 10% $ ‐ 0%
Fire District #40 161,972 202,933 202,933 40,961 25%‐ 0%
State Shared Revenue 1,454,615 1,462,221 1,643,046 188,431 13% 180,825 12%
Federal Grants 509,586 736,295 736,295 226,708 44%‐ 0%
State Grants 10,373 22,404 22,404 12,032 116%‐ 0%
Other Grants/Intgovt 11,079 74,490 74,490 63,411 572%‐ 0%
ARRA Grants 114,792 0 ‐ (114,792) 0%‐ 0%
Total Rev YTD 2,801,258$ 3,092,667$ 3,273,493$ 472,234$ 17%180,825$ 6%
Total Rev Annual 11,682,043$ 12,065,651$
YTD % 24% 26% 27%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
Page 6 of 36
Monthly Financial Report April 2014
Recreation
Recreation revenues totalled $179k for the
current month. Compared to the same
month the prior year, the City collected $9k
or 5% more. Compared to the projected
monthly budget, the City collected $22k or
14% more. The year‐to‐date collection of
$384k is $22k or 6% higher than the year
before and is also $14k or 4% higher than
the year‐to‐date budget. The City is
projecting Recreation revenues to be very
close with the budget at year‐end.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $1.1 million.
Compared to the prior year, the revenues
are under by $23k or 2%. Compared to the
projected budget, the revenues are above by
$31k or 3%. 2014’s monthly budgets are
based on 1/12th of the annual budget. The
majority of these revenues are related to
indirect cost allocations, which are internal
administrative costs. The remaining costs
consist of Development Services division’s
inspection fees, Parks Planning and Natural
Resources division’s capital investment
program reimbursements, Transportation
division’s capital investment program
reimbursements, and Maintenance division’s street maintenance reimbursements.
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 on the next page breaks down these
fines by type. The year‐to‐date total fines
and penalties is $755k. This is $238k or 24%
lower than a year ago and is also $268k or
26% below the budget.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 60,546$ 62,601$ 69,522$ 8,976$ 15% 6,921$ 11%
Feb 51,160 56,408 68,873 17,713 35% 12,465 22%
Mar 79,491 94,074 66,458 (13,033) ‐16% (27,616) ‐29%
Apr 170,541 157,142 179,282 8,742 5% 22,140 14%
May 95,710 119,835 ‐
Jun 150,284 152,865 ‐
Jul 345,126 309,124 ‐
Aug 205,821 238,859 ‐
Sep 123,550 118,153 ‐
Oct 83,685 86,617 ‐
Nov 65,656 67,145 ‐
Dec 63,010 63,040 ‐
YTD Total 361,738$ 370,225$ 384,136$ 22,398$ 6% 13,911$ 4%
Annual Total 1,494,580$ 1,525,863$
Recreation
Year to Date through April
2014 vs. Budget2014 vs. 2013
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 265,873$ 277,733$ 301,808$ 35,935$ 14% 24,075$ 9%
Feb 292,362 277,733 257,027 (35,335) ‐12% (20,706) ‐7%
Mar 317,998 277,733 287,465 (30,533) ‐10% 9,732 4%
Apr 288,610 277,733 295,489 6,879 2% 17,756 6%
May 299,652 277,733 ‐
Jun 287,569 277,733 ‐
Jul 282,466 277,733 ‐
Aug 352,945 277,733 ‐
Sep 274,525 277,733 ‐
Oct 352,421 277,733 ‐
Nov 286,300 277,733 ‐
Dec 164,190 277,733 ‐
YTD Total 1,164,844$ 1,110,931$ 1,141,789$ (2 3,055)$ ‐2% 30,857$ 3%
Annual Total 3,464,913$ 3,332,794$
Interfund Services
Year to Date through April
2014 vs. 2013 2014 vs. Budget
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 153,064$ 182,703$ 136,762$ (16,302)$ ‐11% (45,941)$ ‐25%
Feb 247,166 251,253 151,470 (95,696) ‐39% (99,783) ‐40%
Mar 275,222 276,820 203,482 (71,740) ‐26% (73,338) ‐26%
Apr 318,235 312,315 263,785 (54,451) ‐17% (48,530) ‐16%
May 278,783 309,616
Jun 269,334 307,008
Jul 236,571 269,780
Aug 171,565 178,125
Sep 154,604 169,913
Oct 191,919 249,230
Nov 189,412 230,005
Dec 280,787 321,732
YTD Total 993,688$ 1,023,092$ 755,499$ (238,189)$ ‐24% (267,593)$ ‐26%
Annual Total 2,766,663$ 3,058,500$
2014 vs. Budget2014 vs. 2013
Year to Date through April
Fines and Penalties by Month
Month
Page 7 of 36
Monthly Financial Report April 2014
Year to Date through April
2013 2014 2014
Actual Budget Actual $ % $ %
Civil Penalties 2,225$ 3,912$ 2,380$ 155$ 7% (1,532)$ ‐39%
Civil Infraction Penalties 170,199 163,910 199,563 29,364 17% 35,654 22%
Civil Parking Infraction Penalties 46,835 44,315 61,334 14,499 31% 17,019 38%
Photo Enforcement Program 680,026 721,504 400,235 (279,790) ‐41% (321,269) ‐45%
Criminal Traffic Misdemeanor Fines 29,001 28,943 28,120 (881) ‐3% (823) ‐3%
Criminal Non‐Traffic Fines 7,877 9,816 15,460 7,583 96% 5,645 58%
Criminal Costs 38,040 34,707 41,178 3,138 8% 6,471 19%
Non‐Court Fines, Forfeitures and Penalties 19,484 15,984 7,227 (12,256) ‐63% (8,757) ‐55%
YTD Total 993,688$ 1,023,092$ 755,499$ (238,189)$ ‐24% (267,593)$ ‐26%
Annual Total 2,766,663$ 3,058,500$
Revenue
2014 vs. Budget
Fines and Penalties by Type
2014 vs. 2013
Included in the Fines and Penalties revenue budget is
$2 million from the Photo Enforcement program. The
monthly budget is based on the prior year’s revenue.
The year‐to‐date collections from this program
equates to $400k. The budget shortfall is due to
temporary shutting down 4 intersection cameras in
construction areas and lower activity (driver
behaviour changes).
The associated costs includes the equipment
provided by American Traffic Solutions, Inc. (ATS),
dedicated 2 FTEs in the Court Services Department to
process the increased caseload and 1.1 FTEs in the
Police Department for support services. This staff
time, along with a 90% pro tem budget and
interpreter costs amounts to $362k for personnel
costs. The total costs for the program equates to
$842k which is represented in the table.
Miscellaneous
This revenue source reflects the collection of
interest and other earnings, rents, leases, and
concessions, contributions, and donations
from private sources, and other
miscellaneous revenues. Interest and other
earnings along with rents, leases, and
concessions constitute 65% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $540k. Compared to
last year, the revenues are above by $43k or
9%. Compared to the projected year‐to‐date
budget, the revenues are over by $57k or
12%. The table on the following page breaks
out miscellaneous revenues by type.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 179,743$ 180,999$ 243,963$ 64,220$ 36% 62,964$ 35%
Feb 76,397 59,215 99,547 23,149 30% 40,331 68%
Mar 147,909 148,337 126,132 (21,777) ‐15% (22,204) ‐15%
Apr 92,872 93,691 70,094 (22,778) ‐25% (23,597) ‐25%
May 118,719 201,575
Jun 123,441 122,135
Jul 128,246 115,614
Aug 122,652 124,685
Sep 92,799 87,377
Oct 82,288 81,590
Nov 63,945 80,793
Dec 399,005 673,545
YTD Total 496,921$ 482,243$ 539,736$ 42,815$ 9% 57,493$ 12%
Annual Total 1,628,017$ 1,969,557$
Year to Date through April
Month
2014 vs. Budget2014 vs. 2013
Miscellaneous Revenues by Month
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 180,582$ 61,721$ 73,624$ 30,160$ 31,561$
Feb 165,453 68,045 73,336 51,174 16,871
Mar 161,059 103,922 73,278 79,750 24,172
Apr 214,411 166,547 71,661 30,160 136,388
May 214,507 ‐ 73,575 ‐ ‐
Jun 207,265 ‐ 71,358 ‐ ‐
Jul 184,107 ‐ 71,451 ‐ ‐
Aug 93,843 ‐ 71,108 ‐ ‐
Sep 71,053 ‐ 58,646 ‐ ‐
Oct 159,611 ‐ 63,603 ‐ ‐
Nov 135,380 ‐ 64,079 ‐ ‐
Dec 162,729 ‐ 76,245 ‐ ‐
YTD To tal 721,504$ 400,235$ 291,899$ 191,244$ 208,992$
Annual Total 1,950,000$ 841,964$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through April
Month
Page 8 of 36
Monthly Financial Report April 2014
2013 2014 2014
Actual Budget Actual $ % $ %
Interests and Other Earnings 29,926$ 58,231$ 43,538$ 13,612$ 45% (14,693)$ ‐25%
Rents, Leases, and Concessions 317,273 308,185 306,400 (10,873) ‐3% (1,785) ‐1%
Contributions/Donations from Private Sources 25,736 33,411 28,512 2,776 11% (4,899) ‐15%
Other 120,495 69,958 161,756 41,262 34% 91,798 131%
Seizure Funds ‐ Federal/State/Local1 3,491 12,458 (470) (3,961) ‐113% (12,928) ‐104%
YTD Total 496,921$ 482,243$ 539,736$ 42,815$ 9% 57,493$ 12%
Annual Total 1,628,017$ 1,969,557$
1 Seizure Funds are categorized in Miscellaneous for 2013 and on.
2014 vs. Budget
Miscellaneous Revenues by Type
Year to Date through April
Revenue
2014 vs. 2013
Other miscellaneous revenues are higher than the prior year and budget due to higher than expected utility late payment
penalties and miscellaneous reimbursements for Fire.
EXPENSES
Overall the City has expended 29% of its budgeted general governmental expenditures at the end of April. This is $794k or
2.4% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental
departments.
Council department is over the year‐to‐date budget by $5.6k or 5.4%. This is due to an annual membership payment made
to National League Online. The budget for this is included in the upcoming Carry Forward amendment. We anticipate at
year‐end the department will be within budget.
Administrative Services department is over the year‐to‐date by $185k or 19.7%. This is mainly due to the timing of
payments related to Springbrook merchant account fees and elections/voter registration costs compared to the prior year.
We will monitor this item to determine if a budget adjustment is needed.
Page 9 of 36
Monthly Financial Report April 2014
ENTERPRISE FUNDS
The table below gives an analysis of all City Enterprise funds. Displayed are the year‐to‐date revenues and expenditures for
each enterprise. Included in each fund are the capital revenues and expenditures.
Airport Golf Course Solid Waste
Utility Water Utility Wastewater
Utility
Surface
Water
Utility
Metro
REVENUES:
Licenses and permits ‐ ‐ ‐ ‐ 23,610 18,575 ‐
Grants / intergovernmental 651,351 ‐ 117,144 ‐ ‐ 797,565 ‐
Charges for services 48,157 405,064 5,886,254 4,846,771 3,122,384 3,418,054 4,984,926
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 2,177 ‐ ‐ ‐ 95 ‐ ‐
Rents, leases, and misc fees 795,423 56,212 19,239 39,178 ‐ ‐ ‐
Interest and other misc 1,907 489 2,294 79,402 207,052 203,732 2,616
TOTAL REVENUES 1,499,015 461,765 6,024,931 4,965,351 3,353,141 4,437,926 4,987,542
EXPENSES:
Utility billing ‐ ‐ 40,792 39,464 29,528 47,790 ‐
Utility systems ‐ ‐ 4,497,791 1,456,450 941,257 1,008,892 ‐
Utility maintenance ‐ ‐ 89,436 1,495,808 433,360 723,893 4,867,459
Transportation 1,146,321 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 617,323 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,146,321 617,323 4,628,019 2,991,722 1,404,145 1,780,575 4,867,459
AMOUNT AVAILABLE FOR DEBT SERVICE 352,694 (155,558) 1,396,912 1,973,629 1,948,996 2,657,351 120,083
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ 1,625 ‐ 302 121 181 ‐
TOTAL DEBT SERVICE ‐ 1,625 ‐ 302 121 181 ‐
CAPITAL PROJECTS 264,671 17,397 ‐ 378,377 745,303 839,358 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 88,023 (174,580) 1,396,912 1,594,950 1,203,572 1,817,812 120,083
BEGINNING FUND BALANCE, Jan 1 1,669,564 319,161 1,344,883 12,350,952 5,528,366 7,510,285 2,603,562
ENDING FUND BALANCE, Apr 30 1,757,587 144,581 2,741,795 13,945,902 6,731,938 9,328,097 2,723,645
Page 10 of 36
Monthly Financial Report April 2014
INTERNAL SERVICE FUNDS
The table below gives an analysis of all City Internal Service Funds. Displayed are the year‐to‐date revenues and
expenditures for each internal service. Included in each fund are the capital revenues and expenditures.
Equipment
Rental
Information
Technology Facilities Communications Insurance Healthcare Retiree
Healthcare
REVENUES:
Technology Fee ‐ 51,445 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 44,426
Charges for services
Equipment rental m&o 919,975 1,005,647 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 37,473 ‐ 134,572 ‐ ‐ ‐
Communications ‐ 3,090 ‐ 180,706 ‐ ‐ ‐
Facilities ‐ ‐ 1,418,535 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 46,809 ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ 146,244 ‐ ‐ ‐ ‐ ‐
Interest and other misc 3,968 2,176 1,271 365 6,845 6,268 7,047
Internal service fund misc:
Vehicle / equipment capital recovery 507,177 44,993 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 543,794 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 521,615 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 3,806,780 569,164
Other misc ‐ 2 1,286 ‐ ‐ 98,545 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 21,043 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 41,228 ‐ ‐
TOTAL REVENUES 1,452,163 1,337,879 1,421,092 315,643 1,113,482 3,911,593 620,637
EXPENSES:
Communications 169,429
Equipment rental 733,113
Facilities 1,168,739
Healthcare 4,374,238
Information technology 1,114,689
Print and mail 113,775
Retiree healthcare 339,500
Risk management
Risk ma nagement 1,081,554
Unemployment 17,009
Worker's compensation 511,687
TOTAL EXPENSES 733,113 1,114,689 1,168,739 283,204 1,610,250 4,374,238 339,500
AMOUNT AVAILABLE FOR CAPITAL 719,050 223,190 252,353 32,439 (496,768) (462,645) 281,137
CAPITAL PROJECTS 374,875 128,391 38,352 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 344,175 94,799 214,001 32,439 (496,768) (462,645) 281,137
BEGINNING FUND BALANCE, Jan 1 3,935,088 2,216,612 1,167,714 347,771 7,630,077 6,934,304 7,207,703
ENDING FUND BALANCE, Apr 30 4,279,263 2,311,411 1,381,715 380,210 7,133,309 6,471,659 7,488,840
Page 11 of 36
Monthly Financial Report April 2014
FUND BALANCE
Page 13 shows the ending fund balance as of April 2014. The City’s fund balance is a combination of current deficit/surplus
of funds which have accrued from unexpended operating budgets, unanticipated excess revenues, and from balances
accumulated from prior years.
The prior year’s balances (or beginning balance) include funds identified as being reserved for specific purposes or required
to meet the current year’s appropriations. These balances also provide financial stability to the City’s operation during
uncertain times and provide a layer of security to bondholders.
At the end of April, the City has $17.6 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 16% of budgeted operating expenditures. This is an increase of $131k from
the year’s beginning balance. April’s ending fund balance is under the anticipated General Governmental Fund Balance of
$19.5 million by $1.9 million or 9.9%. The fund balance variance is due to the timing of receipting property taxes in April
and May. The fund balance will be back to normal variances after May.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services Department. For additional financial
information, please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel
free to contact us at hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.
Page 12 of 36
Monthly Financial Report April 2014
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through April 30, 2014
Funds
Balance
01/01/2014
Budgeted
Revenue
Revenue
04/30/14
Total Funds
Available
Budgeted
Expenditure
Expenditure
04/30/14
Ending
Balance
GENERAL GOVERNMENT FUNDS:17,454,261 107,476,905 32,250,423 49,704,684 111,626,502 32,119,009 17,585,676
000 General 12,515,053 77,540,984 22,290,021 34,805,074 81,920,905 25,136,895 9,668,179
001 Community Services 2,124,598 11,706,752 3,669,101 5,793,699 11,693,059 3,014,059 2,779,640
003 Street 1,667,393 9,028,020 2,910,328 4,577,721 9,028,020 2,873,922 1,703,799
004 Community Dev Block Grant (229,834) 548,203 304,785 74,951 308,172 85,986 (11,035)
005 Museum 52,979 226,683 56,698 109,677 226,683 66,789 42,888
009 Farmers Market 98,826 60,400 8,671 107,497 83,322 20,596 86,901
011 Fire Health & Wellness 55,094 25,000 8,349 63,443 25,000 3,745 59,698
031 Park Memorial 478 ‐ ‐ 478 478 478 ‐
201 Ltd GO Bonds Gen Govt Debt 833,717 1,749,705 438,248 1,271,965 1,749,705 ‐ 1,271,965
215 Gen Govt Misc Debt Service 335,957 6,591,158 2,564,221 2,900,178 6,591,158 916,538 1,983,640
SPECIAL REVENUE FUNDS:
102 Arterial Street 192,689 633,000 194,835 387,524 810,000 ‐ 387,524
108 Leased City Properties 549,887 833,071 215,831 765,718 853,626 183,953 581,765
110 Hotel Motel 185,606 265,000 59,442 245,048 315,693 41,075 203,973
125 1% For Art 97,771 15,000 91 97,862 50,000 7,050 90,812
127 Cable Communication 284,632 85,674 64,888 349,520 85,674 17,074 332,446
135 Springbrook Wetlands Bank 667,613 ‐ 645 668,258 ‐ ‐ 668,258
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 934,618 60,000 63,000 997,618 ‐ ‐ 997,618
304 Fire Mitigation 646,165 50,000 87,424 733,589 ‐ ‐ 733,589
305 Transportation Mitigation 486,185 40,000 120,662 606,847 200,000 ‐ 606,847
316 Municipal Facilities CIP 5,083,524 3,070,672 700,324 5,783,848 7,921,548 1,192,963 4,590,885
317 Transportation CIP 2,687,303 18,857,104 1,534,784 4,222,087 20,835,072 4,484,917 (262,830)
318 So Lake WA Infrastructure Proj 9,012 ‐ 9 9,021 9,012 ‐ 9,021
326 Housing Opportunity 84,599 1,000,000 81 84,680 75,000 ‐ 84,680
336 New Library Development 19,571,748 450,000 18,844 19,590,592 20,021,748 293,086 19,297,506
ENTERPRISE FUNDS:
402 Airport 191,466 1,505,636 846,150 1,037,616 1,496,624 525,331 512,285
403 Solid Waste Utility 1,344,883 16,419,820 6,024,931 7,369,814 16,508,948 4,628,020 2,741,794
404 Golf Course 33,445 2,487,449 461,491 494,936 2,522,025 635,612 (140,676)
422 Airport Capital 1,478,098 15,878,548 652,865 2,130,963 17,331,646 885,661 1,245,302
424 Golf Course Capital 285,716 50,000 16,939 302,655 193,894 17,397 285,258
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 3,935,088 4,361,968 1,452,162 5,387,250 4,829,709 1,107,988 4,279,262
502 Insurance 7,630,077 7,344,062 1,113,482 8,743,559 3,188,983 1,610,251 7,133,308
503 Information Services 2,216,612 4,010,222 1,337,879 3,554,491 5,358,145 1,243,080 2,311,411
504 Facilities 1,167,714 4,105,749 1,421,092 2,588,806 4,505,641 1,207,091 1,381,715
505 Communications 347,771 896,374 315,643 663,414 917,403 283,204 380,210
512 Insurance, Healthcare 6,934,304 11,622,068 3,911,594 10,845,898 12,062,456 4,374,238 6,471,660
522 Insurance, Leoff1 Retirees HC 7,207,703 1,735,684 620,637 7,828,340 1,738,162 339,500 7,488,840
FIDUCIARY FUNDS:
611 Firemen's Pension 4,790,247 300,000 2,534 4,792,781 225,475 60,226 4,732,555
Funds
Balance
01/01/2014
Budgeted
Revenue
Revenue
04/30/14
Total Funds
Available
Budgeted
Expenditure
Expenditure
04/30/14
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 27,993,165 62,804,226 17,743,960 45,737,125 68,486,436 13,007,542 32,729,583
405 Water Utility 8,523,106 13,765,149 4,915,573 13,438,679 11,453,942 2,566,620 10,872,059
406 Waste Water Utility 2,578,193 7,263,934 3,157,545 5,735,738 5,544,029 1,389,930 4,345,808
407 Surface Water Utility 4,342,360 4,867,612 3,441,387 7,783,747 6,996,129 1,590,810 6,192,937
416 King County Metro 2,603,562 15,202,336 4,987,542 7,591,104 15,202,336 4,867,459 2,723,645
425 Water Utility Construction 3,811,904 4,385,000 49,763 3,861,667 7,771,000 803,780 3,057,887
426 Waste Water Construction 2,950,173 4,900,000 195,596 3,145,769 7,055,000 759,639 2,386,130
427 Surface Water Construction 3,167,925 12,420,195 996,539 4,164,464 14,464,000 1,029,304 3,135,160
471 Waterworks Rate Stabilization 15,942 ‐ 15 15,957 ‐ ‐ 15,957
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 13 of 36
City of Renton
General Government Financial Position
2014 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
17,454,261
January 5,710,991 8,047,088 (2,336,097) 15,118,164
February 12,530,792 15,890,655 (3,359,862) 14,094,399
March 19,541,262 23,627,952 (4,086,690) 13,367,571
April 32,250,423 32,119,009 131,414 17,585,675
May
June
July
August
September
October
November
December
(3,000,000)
(2,000,000)
(1,000,000)
‐
1,000,000
70,000,000
80,000,000
90,000,000
100,000,000
110,000,000
Change in Fund
Balance
Rev/Exp Revenues
Expenditures
Change in Fund Balance
(9,000,000)
(8,000,000)
(7,000,000)
(6,000,000)
(5,000,000)
(4,000,000)
‐
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
60,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Page 14 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,848,043 5,710,991 ‐2.34%
Feb 11,902,762 12,530,792 5.28%
Mar 17,726,513 19,541,262 10.24%
Apr 34,984,794 32,250,423 ‐7.82%
May 46,880,092
Jun 52,175,800
Jul 58,687,597
Aug 64,177,424
Sep 69,709,373
Oct 87,077,580
Nov 100,529,440
Dec 107,476,905
Percent of budget 30.01%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$36
Millions Property Tax
Property Tax Budget Actual over (under)
Jan 162,468 (101,807) ‐162.66%
Feb 221,564 74,744 ‐66.27%
Mar 1,182,448 1,701,026 43.86%
Apr 11,815,359 7,509,891 ‐36.44%
May 18,180,258
Jun 18,250,621
Jul 18,542,776
Aug 18,546,494
Sep 19,130,963
Oct 29,751,020
Nov 34,808,607
Dec 35,240,495
Percent of budget 21.31%
$(3)
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Budget
Actual
Last Year
Page 15 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,780,130 1,796,358 0.91%
Feb 4,049,868 4,122,324 1.79%
Mar 5,735,971 5,867,541 2.29%
Apr 7,449,682 7,607,062 2.11%
May 9,403,295
Jun 11,160,683
Jul 12,941,079
Aug 14,856,274
Sep 16,674,205
Oct 18,600,929
Nov 20,542,214
Dec 22,432,262
Percent of budget 33.91%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Sales Tax
Budget
Actual
Last Year
$16
Millions Utility Tax
Utility Tax Budget Actual over (under)
Jan 1,372,593 1,373,119 0.04%
Feb 2,862,943 2,897,682 1.21%
Mar 4,173,577 4,529,120 8.52%
Apr 5,637,269 5,748,119 1.97%
May 7,000,058
Jun 8,151,130
Jul 9,449,365
Aug 10,668,223
Sep 12,034,563
Oct 13,138,008
Nov 14,360,964
Dec 15,859,850
Percent of budget 36.24%
Note: Includes Natural Gas Use Tax.
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 16 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 283,179 404,067 42.69%
Feb 483,298 718,566 48.68%
Mar 687,979 929,709 35.14%
Apr 1,005,116 1,321,521 31.48%
May 1,238,954
Jun 1,452,511
Jul 1,758,517
Aug 2,047,093
Sep 2,213,029
Oct 2,636,671
Nov 2,886,417
Dec 3,129,504
Percent of budget 42.23%
Note: Franchise Fees
YTD Annual % Millions
Intergovernmental
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Licenses & Permits
Budget
Actual
Last Year
Intergovt'l Budget Actual over (under)
Jan 801,032 846,109 5.63%
Feb 1,641,056 1,714,034 4.45%
Mar 2,013,994 2,206,902 9.58%
Apr 3,092,667 3,273,493 5.85%
May 3,429,438
Jun 4,029,183
Jul 4,814,027
Aug 5,521,461
Sep 6,003,563
Oct 7,491,064
Nov 11,328,975
Dec 12,065,651
Percent of budget 27.13%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
Millions
Budget
Actual
Last Year
Page 17 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 466,134 669,010 43.52%
Feb 1,002,386 1,198,034 19.52%
Mar 1,548,420 1,831,413 18.28%
Apr 2,214,131 2,482,936 12.14%
May 2,816,212
Jun 3,402,473
Jul 4,200,894
Aug 4,887,074
Sep 5,421,972
Oct 6,024,642
Nov 6,558,687
Dec 7,158,086
Percent of budget 34.69%
Note: Excludes FD25 & FD40 contracts
Fines & YTD Annual %
$‐
$1
$2
$3
$4
$5
$6
$7
$8
Millions Charges for Services
Budget
Actual
Last Year
Millions Fines & Forfeits
Forfeits Budget Actual over (under)
Jan 182,703 136,762 ‐25.15%
Feb 433,957 288,232 ‐33.58%
Mar 710,777 491,714 ‐30.82%
Apr 1,023,092 755,499 ‐26.16%
May 1,332,708
Jun 1,639,716
Jul 1,909,496
Aug 2,087,621
Sep 2,257,534
Oct 2,506,763
Nov 2,736,768
Dec 3,058,500
Percent of budget 24.70%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 18 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 618,804 343,410 ‐44.50%
Feb 967,476 1,173,666 21.31%
Mar 1,284,796 1,511,820 17.67%
Apr 2,265,235 3,008,720 32.82%
May 2,795,353
Jun 3,283,530
Jul 4,149,876
Aug 4,516,933
Sep 4,839,916
Oct 5,713,265
Nov 6,010,796
Dec 6,563,000
Percent of budget 45.84%
YTD Annual % Millions Miscellaneous
$‐
$1
$2
$3
$4
$5
$6
$7
$8
Millions Other Taxes
Budget
Actual
Last Year
Misc Budget Actual over (under)
Jan 180,999 243,963 34.79%
Feb 240,215 343,510 43.00%
Mar 388,551 469,642 20.87%
Apr 482,243 539,736 11.92%
May 683,818
Jun 805,952
Jul 921,566
Aug 1,046,251
Sep 1,133,629
Oct 1,215,219
Nov 1,296,012
Dec 1,969,557
Percent of budget 27.40%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00 Budget
Actual
Last Year
Page 19 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb ‐ ‐ N/A
Mar ‐ 2,375 100.00%
Apr ‐ 3,447 100.00%
May ‐
Jun ‐
Jul ‐
Aug ‐
Sep ‐
Oct ‐
Nov ‐
Dec ‐
Percent of budget 100.00%
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
Other Financing Sources
Budget
Actual
Last Year
Page 20 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
REET Budget
YTD
Actual
Annual %
over (under)
Jan 94,134 162,143 72.25%
Feb 278,168 610,596 119.51%
Mar 438,277 838,225 91.25%
Apr 577,013 1,747,345 202.83%
May 777,722
Jun 1,021,902
Jul 1,207,067
Aug 1,413,460
Sep 1,591,955
Oct 1,783,413
Nov 2,023,852
Dec 2,900,000
Percent of budget 60.25%
Bldg Permits &
Devlpmt Svc YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions
Real Estate Excise Tax
Budget
Actual
Last Year
Millions Building Permits and Development Service
Fees Budget Actual over (under)
Jan 251,556 432,890 72.09%
Feb 467,244 845,207 80.89%
Mar 753,544 1,233,397 63.68%
Apr 1,069,262 1,607,401 50.33%
May 1,390,140
Jun 1,668,571
Jul 1,976,502
Aug 2,328,357
Sep 2,542,968
Oct 2,975,045
Nov 3,313,782
Dec 3,705,701
Percent of budget 43.38%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions Fees
Budget
Actual
Last Year
Page 21 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,656,884 8,047,088 5.10%
Feb 16,346,895 15,890,655 ‐2.79%
Mar 24,067,020 23,627,952 ‐1.82%
Apr 32,912,955 32,119,009 ‐2.41%
May 46,011,003
Jun 54,927,418
Jul 64,644,477
Aug 73,936,346
Sep 83,251,821
Oct 92,225,305
Nov 101,392,393
Dec 111,626,501
Percent of budget expended 28.77%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$350 000
Legislative
Legislative Budget Actual over (under)
Jan 24,713 23,569 ‐4.63%
Feb 50,791 55,960 10.18%
Mar 77,175 84,100 8.97%
Apr 103,348 108,911 5.38%
May 128,959
Jun 154,624
Jul 180,383
Aug 205,498
Sep 231,042
Oct 256,847
Nov 282,568
Dec 309,907
Percent of budget expended 35.14%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
Budget
Actual
Last Year
Page 22 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 80,412 76,257 ‐5.17%
Feb 197,216 186,396 ‐5.49%
Mar 316,702 296,472 ‐6.39%
Apr 439,720 407,807 ‐7.26%
May 557,592
Jun 661,840
Jul 776,168
Aug 891,836
Sep 997,727
Oct 1,110,465
Nov 1,222,415
Dec 1,359,996
Percent of budget expended 29.99%
YTD Annual %
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
Millions Executive
Budget
Actual
Last Year
$2 00
Millions City Attorney
City Attorney Budget Actual over (under)
Jan 143,108 135,206 ‐5.52%
Feb 289,153 276,371 ‐4.42%
Mar 435,055 419,299 ‐3.62%
Apr 589,689 562,501 ‐4.61%
May 731,578
Jun 882,055
Jul 1,024,858
Aug 1,170,538
Sep 1,323,502
Oct 1,482,556
Nov 1,626,768
Dec 1,863,395
Percent of budget expended 30.19%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00 Budget
Actual
Last Year
Page 23 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 163,940 159,512 ‐2.70%
Feb 331,204 323,167 ‐2.43%
Mar 499,924 487,984 ‐2.39%
Apr 676,750 660,115 ‐2.46%
May 849,947
Jun 1,039,155
Jul 1,215,215
Aug 1,385,662
Sep 1,555,116
Oct 1,726,270
Nov 1,897,359
Dec 2,094,010
Percent of budget expended 31.52%
YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
Millions Court Services
Budget
Actual
Last Year
Millions
Community & Economic
Dl Ad iCED Admin Budget Actual over (under)
Jan 83,847 83,232 ‐0.73%
Feb 167,836 166,457 ‐0.82%
Mar 252,105 249,681 ‐0.96%
Apr 338,988 333,812 ‐1.53%
May 421,256
Jun 504,064
Jul 586,980
Aug 669,788
Sep 752,773
Oct 835,539
Nov 918,100
Dec 1,012,142
Percent of budget expended 32.98%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions Development Admin
Budget
Actual
Last Year
Page 24 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 245,147 216,780 ‐11.57%
Feb 475,540 437,105 ‐8.08%
Mar 710,754 683,399 ‐3.85%
Apr 967,749 931,956 ‐3.70%
May 1,211,026
Jun 1,463,648
Jul 1,721,037
Aug 1,995,920
Sep 2,250,357
Oct 2,519,009
Nov 2,776,952
Dec 3,040,435
Percent of budget expended 30.65%
Economic YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
Millions
Economic Development
Development Budget Actual over (under)
Jan 79,265 36,443 ‐54.02%
Feb 121,101 80,671 ‐33.39%
Mar 166,928 136,650 ‐18.14%
Apr 216,402 186,131 ‐13.99%
May 261,778
Jun 312,460
Jul 365,766
Aug 423,762
Sep 475,562
Oct 526,555
Nov 583,152
Dec 644,063
Percent of budget expended 28.90%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
Millions
Budget
Actual
Last Year
Page 25 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 176,776 123,910 ‐29.91%
Feb 364,981 264,152 ‐27.63%
Mar 549,854 426,860 ‐22.37%
Apr 735,514 584,673 ‐20.51%
May 921,326
Jun 1,108,350
Jul 1,296,003
Aug 1,501,983
Sep 1,703,471
Oct 1,879,353
Nov 2,062,499
Dec 2,261,206
Percent of budget expended 25.86%
YTD Annual % $2 40
Millions Finance
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Millions
Planning
Budget
Actual
Last Year
Finance Budget Actual over (under)
Jan 153,798 161,643 5.10%
Feb 309,673 331,528 7.06%
Mar 474,196 505,966 6.70%
Apr 647,301 678,686 4.85%
May 825,083
Jun 1,006,594
Jul 1,192,630
Aug 1,381,616
Sep 1,546,956
Oct 1,701,753
Nov 1,852,570
Dec 2,334,758
Percent of budget expended 29.07%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40 Budget
Actual
Last Year
Page 26 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 64,003 62,855 ‐1.79%
Feb 132,897 183,252 37.89%
Mar 216,913 380,731 75.52%
Apr 292,782 446,560 52.52%
May 498,004
Jun 563,065
Jul 745,933
Aug 827,964
Sep 901,085
Oct 973,200
Nov 1,046,567
Dec 1,125,927
Percent of budget expended 39.66%
Includes Hearing Examiner
Human YTD Annual % $1 00
Millions Human Resources
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions City Clerk
Budget
Actual
Last Year
Resources Budget Actual over (under)
Jan 72,706 63,751 ‐12.32%
Feb 152,715 131,247 ‐14.06%
Mar 239,432 203,164 ‐15.15%
Apr 320,251 294,344 ‐8.09%
May 397,478
Jun 489,534
Jul 572,574
Aug 658,226
Sep 739,793
Oct 822,360
Nov 907,045
Dec 1,002,994
Percent of budget expended 29.35%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Budget
Actual
Last Year
Page 27 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Police Budget
YTD
Actual
Annual %
over (under)
Jan 2,445,788 2,620,270 7.13%
Feb 4,883,369 4,935,606 1.07%
Mar 7,300,805 7,538,512 3.26%
Apr 9,820,439 9,787,131 ‐0.34%
May 12,723,189
Jun 15,133,723
Jul 17,838,638
Aug 20,173,278
Sep 22,849,319
Oct 25,195,504
Nov 27,818,990
Dec 30,425,197
Percent of budget expended 32.17%
Fire &
Emergency YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Millions Police
Budget
Actual
Last Year
$27
Millions Fire & Emergency Services
Services Budget Actual over (under)
Jan 2,041,819 2,561,083 25.43%
Feb 4,847,480 4,745,812 ‐2.10%
Mar 6,854,096 6,727,201 ‐1.85%
Apr 8,855,803 8,701,872 ‐1.74%
May 11,028,108
Jun 13,014,291
Jul 15,006,605
Aug 17,030,818
Sep 19,036,886
Oct 21,071,064
Nov 23,133,937
Dec 25,219,873
Percent of budget expended 34.50%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
Budget
Actual
Last Year
Page 28 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 42,394 36,113 ‐14.82%
Feb 82,537 75,787 ‐8.18%
Mar 122,781 120,240 ‐2.07%
Apr 164,144 158,781 ‐3.27%
May 205,095
Jun 245,774
Jul 286,244
Aug 326,379
Sep 366,052
Oct 405,523
Nov 447,189
Dec 493,982
Percent of budget expended 32.14%
YTD Annual % $4 50
Millions Parks
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
$500,000
Community Services Admin
Budget
Actual
Last Year
Parks Budget Actual over (under)
Jan 292,322 271,473 ‐7.13%
Feb 598,427 555,521 ‐7.17%
Mar 920,103 856,188 ‐6.95%
Apr 1,273,822 1,154,945 ‐9.33%
May 1,614,058
Jun 1,979,168
Jul 2,366,921
Aug 2,777,634
Sep 3,184,127
Oct 3,574,538
Nov 3,939,495
Dec 4,311,514
Percent of budget expended 26.79%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50 Budget
Actual
Last Year
Page 29 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 49,228 43,855 ‐10.91%
Feb 101,030 90,409 ‐10.51%
Mar 166,883 148,948 ‐10.75%
Apr 229,214 201,429 ‐12.12%
May 301,827
Jun 366,732
Jul 431,978
Aug 495,631
Sep 564,205
Oct 636,195
Nov 702,081
Dec 880,373
Percent of budget expended 22.88%
YTD Annual %
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
Parks Planning and Natural Resources
Budget
Actual
Last Year
$5 50
Millions Recreation
Recreation Budget Actual over (under)
Jan 317,480 278,944 ‐12.14%
Feb 677,093 603,208 ‐10.91%
Mar 1,041,360 928,117 ‐10.87%
Apr 1,429,365 1,262,485 ‐11.68%
May 1,793,244
Jun 2,188,393
Jul 2,809,941
Aug 3,479,188
Sep 3,980,445
Oct 4,344,574
Nov 4,701,254
Dec 5,111,272
Percent of budget expended 24.70%
$0.00
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
Budget
Actual
Last Year
Page 30 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 54,337 47,594 ‐12.41%
Feb 134,179 143,610 7.03%
Mar 251,034 249,760 ‐0.51%
Apr 389,020 385,688 ‐0.86%
May 471,784
Jun 540,831
Jul 679,987
Aug 748,949
Sep 802,062
Oct 950,120
Nov 1,027,713
Dec 1,221,989
Percent of budget expended 31.56%
Neighborhoods
, Resources, YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions Human Services
Budget
Actual
Last Year
$1 000 000
Neighborhoods, Resources, and Events
and Events Budget Actual over (under)
Jan 68,622 57,193 ‐16.66%
Feb 131,885 146,776 11.29%
Mar 210,347 200,847 ‐4.52%
Apr 280,168 257,492 ‐8.09%
May 348,656
Jun 436,118
Jul 544,155
Aug 631,090
Sep 711,521
Oct 785,130
Nov 890,176
Dec 979,716
Percent of budget expended 26.28%
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
$1,000,000
Budget
Actual
Last Year
Page 31 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 18,447 16,819 ‐8.82%
Feb 37,132 33,387 ‐10.09%
Mar 55,837 49,955 ‐10.53%
Apr 75,357 66,789 ‐11.37%
May 94,204
Jun 113,251
Jul 131,932
Aug 150,895
Sep 169,970
Oct 189,000
Nov 208,138
Dec 226,683
Percent of budget expended 29.46%
Public Works YTD Annual % $500 000
Public Works Admin
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
$240,000
Museum Fund
Budget
Actual
Last Year
Admin Budget Actual over (under)
Jan 40,644 31,793 ‐21.78%
Feb 81,126 63,574 ‐21.64%
Mar 121,691 95,355 ‐21.64%
Apr 164,065 127,778 ‐22.12%
May 203,500
Jun 241,286
Jul 277,486
Aug 314,166
Sep 350,422
Oct 385,541
Nov 420,605
Dec 456,340
Percent of budget expended 28.00%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
$500,000
Budget
Actual
Last Year
Page 32 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 348,761 311,026 ‐10.82%
Feb 744,828 658,352 ‐11.61%
Mar 1,110,350 980,862 ‐11.66%
Apr 1,489,239 1,423,475 ‐4.42%
May 1,853,405
Jun 2,241,891
Jul 2,607,657
Aug 2,962,105
Sep 3,328,647
Oct 3,699,390
Nov 4,070,992
Dec 4,488,268
Percent of budget expended 31.72%
YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions Street Maintenance
Budget
Actual
Last Year
$5 0
Millions Transportation
Transportation Budget Actual over (under)
Jan 299,741 278,181 ‐7.19%
Feb 664,652 632,259 ‐4.87%
Mar 1,036,278 921,240 ‐11.10%
Apr 1,468,622 1,450,448 ‐1.24%
May 1,810,444
Jun 2,129,219
Jul 2,522,140
Aug 2,918,281
Sep 3,263,752
Oct 3,635,898
Nov 3,985,013
Dec 4,539,752
Percent of budget expended 31.95%
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
$4.5
$5.0
Budget
Actual
Last Year
Page 33 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 51,520 51,520 0.00%
Feb 302,837 302,837 0.00%
Mar 303,355 303,355 0.00%
Apr 916,538 916,538 0.00%
May 3,475,360
Jun 4,170,432
Jul 4,865,503
Aug 5,560,575
Sep 6,255,647
Oct 6,950,719
Nov 7,645,791
Dec 8,340,863
Percent of budget expended 10.99%
Non‐
Departmental YTD Annual % $8 00
Millions Non‐Departmental Other City Services
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
Millions Debt Service
Budget
Actual
Last Year
Other City Budget Actual over (under)
Jan 298,065 298,065 0.00%
Feb 467,210 467,210 0.00%
Mar 633,063 633,063 0.00%
Apr 1,028,664 1,028,664 0.00%
May 3,284,102
Jun 3,940,922
Jul 4,597,742
Aug 5,254,563
Sep 5,911,383
Oct 6,568,203
Nov 7,225,024
Dec 7,881,844
Percent of budget expended 13.05%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00 Budget
Actual
Last Year
Page 34 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2014 Budget Year
Utilities Budget Revenue Expense
Jan 4,282,421 6,606,636 3,795,307
Feb 9,839,723 11,939,236 8,329,760
Mar 17,394,389 17,397,529 13,080,021
Apr 23,769,707 23,768,876 17,635,562
May 30,978,426
Jun 39,309,642
Jul 47,343,798
Aug 54,078,194
Sep 61,661,742
Oct 67,509,352
Nov 73,767,095
Dec 84,995,384
Percent of budget expended 17.53%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
Millions Utilities
Budget
Revenue
Expense
$20 00
Millions Airport
Airport Budget Revenue Expense
Jan 211,065 292,698 108,595
Feb 433,615 639,757 472,632
Mar 878,150 1,015,941 1,226,930
Apr 1,081,496 1,499,014 1,410,992
May 2,139,080
Jun 3,390,971
Jul 5,546,997
Aug 11,430,266
Sep 12,053,858
Oct 17,677,109
Nov 17,970,642
Dec 18,828,270
Percent of budget expended 7.49%
Note: Operations and Capital
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
$18.00
$20.00
Budget
Revenue
Expense
Page 35 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2014 Budget Year
Golf Course Budget Revenue Expense
Jan 148,339 83,199 128,950
Feb 311,204 157,539 295,744
Mar 506,698 276,011 463,052
Apr 746,715 478,430 653,009
May 929,343
Jun 1,151,882
Jul 1,346,835
Aug 1,533,049
Sep 1,729,746
Oct 1,916,501
Nov 2,077,100
Dec 2,715,919
Percent of budget expended 24.04%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
Millions Golf Course
Budget
Revenue
Expense
Page 36 of 36