HomeMy WebLinkAbout201403, March.pdfADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: May 6, 2014
TO: Don Persson, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: March 2014 Financial Status Report
At the end of March, general governmental revenues show $2 million or 11.2% over budget.
Revenues sources that are higher than expected are: property tax ($519k); sales tax ($71k);
sales tax annexation credit ($61k); utility taxes ($356k); state shared revenue ($193k); real
estate excise tax ($279k); building permits & development service fees ($480k); interfund
services ($66k) and other miscellaneous ($117k). On the down side, the revenue sources that
are underperforming the year to date budget is fines/penalties ($219k below).
General government expenditures showed an unfavorable variance of $61k or 0.3%. See page
9 of report for further expenditure over‐spent explanations.
The attached report provides more detailed discussion of each revenue source and our updated
projections for the year. Please do not hesitate to contact me at x6952 should you have any
questions or any suggestions about the report.
This page is intentionally left blank
General Governmental Funds
$%
Beginning Fund Balance 11,057,551$ 11,057,551$ 15,575,840$ 15,575,840$ 10,751,945$ 10,751,945$ 17,454,261$ 6,702,316 62.3%
OPERATING REVENUES
Property Tax 33,466,364 1,115,068 32,485,690 1,097,866 35,240,495 1,182,448 1,701,026 518,578 43.9%
Sales Tax 18,564,670 4,555,081 20,416,372 5,119,838 20,196,000 5,178,155 5,248,928 70,773 1.4%
Sales Tax ‐ Annexation Credit 2,208,492 548,776 2,418,789 605,458 2,236,262 557,816 618,612 60,797 10.9%
Criminal Justice Sa les Tax 1,924,470 469,776 2,091,174 522,217 2,000,000 494,064 562,564 68,499 13.9%
Natural Gas Use Tax 272,530 135,319 263,660 83,570 300,000 122,469 99,781 (22,688) ‐18.5%
Admission Tax 311,054 74,353 327,258 82,440 308,000 75,656 80,243 4,587 6.1%
Franchise Fees 1,262,188 300,392 1,312,727 315,362 1,260,000 301,311 323,121 21,810 7.2%
Electricity Tax 5,211,111 1,522,488 5,155,789 1,367,581 5,409,000 1,507,913 1,547,772 39,859 2.6%
Natural Gas Utility Tax 1,669,967 698,786 1,550,900 581,317 1,500,520 596,367 694,379 98,012 16.4%
Garbage/Solid Waste 330,607 66,603 397,596 99,887 300,000 68,589 150,679 82,090 119.7%
TV Cable 1,423,664 315,052 1,481,779 332,857 1,529,365 341,046 348,235 7,189 2.1%
Telephone 1,056,420 236,098 917,021 177,601 952,500 199,676 258,930 59,254 29.7%
Cellular Phone 2,183,853 563,415 2,050,312 389,133 2,077,000 467,257 508,427 41,170 8.8%
City Utilities 3,806,281 882,471 3,964,989 901,280 3,791,465 870,260 920,917 50,657 5.8%
Leasehold Excise Tax 158,849 26,202 164,637 10,248 145,000 16,339 10,618 (5,721) ‐35.0%
Gambling Excise Tax 1,691,209 418,076 1,319,585 318,528 1,600,000 391,447 418,580 27,133 6.9%
Real Estate Excise Tax 2,811,902 495,352 4,131,665 624,405 2,900,000 558,851 838,225 279,374 50.0%
Less: CIP REET (943,792) (97,847) (700,000) (120,083) (550,000) (158,968) (158,968) ‐ 0.0%
EMS Levy 885,781 ‐ 916,361 ‐ 900,000 ‐ ‐ ‐ 0.0%
Business License Fees 444,680 117,854 503,766 148,480 533,067 149,692 133,498 (16,194) ‐10.8%
Animal Licenses and Spec Events Permits 91,835 29,922 99,411 27,238 90,000 27,299 28,113 813 3.0%
Building Permits & Development Svc Fees 3,552,369 657,638 4,001,625 862,709 3,705,701 753,544 1,233,397 479,853 63.7%
Intergovt'l (Grants, State Shared, etc) 4,593,185 767,775 3,863,974 1,249,516 3,648,307 1,368,461 1,492,870 124,409 9.1%
Fire District 25 and 40 Contracts 6,155,621 152,200 5,726,895 161,972 5,877,463 151,469 151,469 ‐ 0.0%
Public Safety 485,899 85,430 680,581 186,458 774,535 180,532 206,806 26,274 14.6%
Culture and Recreation 1,494,165 226,174 1,494,580 191,197 1,525,863 213,083 204,853 (8,230) ‐3.9%
Interfund/Interdept‐Services 3,311,715 743,213 3,464,913 876,233 3,121,003 780,251 846,300 66,049 8.5%
Fines and Penalties 1,046,246 181,611 1,137,140 213,349 1,108,500 203,684 258,026 54,343 26.7%
Photo Enforcement 1,976,203 475,558 1,629,524 462,103 1,950,000 507,093 233,688 (273,405) ‐53.9%
Seizure Funds ‐ Federal/State/Local 37,941 11,738 50,639 3,491 180,693 12,458 (470) (12,928) ‐103.8%
Interests and Other Earnings 342,424 20,892 423,609 18,593 745,300 38,416 35,420 (2,996) ‐7.8%
Rents, Leases, and Concessions 822,428 260,753 734,530 265,202 775,464 261,959 262,643 683 0.3%
Contributions and Donations 124,082 37,447 84,320 19,028 87,000 23,576 27,847 4,271 18.1%
Other Miscellaneous 564,571 119,752 684,187 190,133 516,630 135,144 252,357 117,213 86.7%
Other Financing Sources (Transfer‐In, etc) 5,118,188 5,494 299,527 6,974 ‐ ‐ 2,375 2,375 100.0%
Total Operating Revenues 108,457,170 16,218,914 105,545,527 17,392,180 106,735,133 17,577,358 19,541,262 1,963,903 11.2%
OPERATING EXPENDITURES
Council 278,768 68,811 289,911 72,806 295,947 73,699 84,100 (10,401) ‐14.1%
Executive 1,377,109 312,540 1,240,910 297,118 1,349,262 314,202 296,472 17,730 5.6%
City Attorney 1,706,320 419,219 1,922,225 427,953 1,700,639 397,056 419,299 (22,244) ‐5.6%
Court Services 2,074,980 504,905 2,003,104 468,698 2,009,688 479,793 487,984 (8,191) ‐1.7%
Community and Eco Dvlpmnt Admin 942,071 239,249 1,047,860 256,405 1,008,700 251,248 249,681 1,567 0.6%
Development Services 3,103,568 715,648 3,243,702 768,135 2,698,044 630,714 683,399 (52,685) ‐8.4%
Economic Development 529,043 149,151 467,511 109,135 559,126 144,914 136,650 8,264 5.7%
Planning 1,482,233 377,067 1,510,707 350,721 2,217,824 539,305 426,860 112,444 20.8%
Finance 2,221,882 476,115 2,274,147 437,042 2,315,570 470,299 505,966 (35,667) ‐7.6%
City Clerk1 997,434 186,459 1,020,822 202,364 1,106,909 213,249 380,731 (167,482) ‐78.5%
Human Resources 937,412 227,236 904,182 212,385 996,150 237,798 203,164 34,634 14.6%
Police 25,004,580 6,012,336 24,946,784 6,243,286 25,384,645 6,228,151 6,598,483 (370,332) ‐5.9%
Jail Services 3,489,616 294,683 3,814,042 953,517 4,500,000 940,029 940,029 ‐ 0.0%
Fire 24,173,315 6,539,657 24,444,372 6,673,347 25,106,874 6,823,386 6,727,201 96,185 1.4%
Community Services Admin 434,558 108,727 452,146 111,667 477,630 118,717 120,240 (1,524) ‐1.3%
Parks 4,004,054 862,246 4,024,756 851,150 4,179,513 891,933 856,188 35,745 4.0%
Parks Planning & Natural Resources 577,934 124,284 829,250 142,461 685,661 129,973 148,948 (18,975) ‐14.6%
Recreation 4,982,229 999,673 4,846,970 1,002,907 5,063,974 1,031,723 928,117 103,606 10.0%
Human Services 1,193,871 266,033 1,162,330 218,002 1,160,116 238,323 249,760 (11,437) ‐4.8%
Neighborhoods, Resources, & Events 701,673 144,802 770,841 171,351 896,992 192,586 200,847 (8,261) ‐4.3%
Library 278,604 7,500 ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
Museum 216,887 53,787 209,387 51,213 218,308 53,774 49,955 3,819 7.1%
Public Works Admin 470,051 119,164 426,312 119,866 492,345 131,292 95,355 35,938 27.4%
Street Maintenance 3,755,640 935,153 3,814,132 937,528 4,418,539 1,093,100 980,862 112,238 10.3%
Transportation 4,615,160 1,000,881 4,476,854 1,074,529 4,402,279 1,004,897 921,240 83,656 8.3%
Debt Service 9,752,337 250,317 8,048,508 250,317 8,340,863 303,355 303,355 ‐ 0.0%
Non‐Departmental and Other 4,637,555 886,227 5,475,340 1,009,438 3,486,844 633,063 633,063 ‐ 0.0%
Total Operating Expenditures 103,938,882 22,281,867 103,667,105 23,413,342 105,072,444 23,566,580 23,627,952 (61,372) ‐0.3%
Total Ending Fund Balance 15,575,840$ 4,994,598$ 17,454,262$ 9,554,677$ 12,414,634$ 4,762,723$ 13,367,571$ 8,604,847$ 180.7%
1Hearing Examiner is reported under City Clerk
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2012 2013 2014 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report March 2014
Page 1 of 37
Monthly Financial Report March 2014
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through March 31, 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 70% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
March’s collection is $1.6 million,
making the total year‐to‐date collection
$1.7 million or 4.8% of the total budget.
In comparison to the previous year, the
City collected $603k or 55% more.
Compared to the budget, the City is
above projections by $519k or 44%. The
variance from the monthly budget is
due the timing of collections. The City is
projecting property tax to meet the
budget at year‐end.
Sales Tax
March 2014 sales tax receipts totalled
$1.6 million. Compared with the same
month last year, it is $26k or 2% more.
Compared to the projected current
month’s budget, it is $39k or 3% above.
The year‐to‐date collection of $5.2
million is $129k or 3% more than the
prior year and is also $71k 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
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 1,097,866$ 1,182,448$ 1,701,026$ 603,161$ 55% 518,578$ 44%
Annual Total 32,485,690$ 35,240,495$
Property Tax Revenues
Year to Date through March
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 ‐
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 5,119,838$ 5,178,155$ 5,248,928$ 129,090$ 3% 70,773$ 1%
Annual Total 20,416,372$ 20,196,000$
2014 vs. Budget2014 vs. 2013
Month
Year to Date through March
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report March 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 737,881$ 522,226$ 534,836$ (203,045)$ ‐28%$ 12,610 2%
Auto Sales 866,045 936,351 946,498 80,453 9% 10,146 1%
General Retail 1,728,270 1,768,651 1,705,235 (23,035) ‐1% (63,416)‐4%
Manufacturing 301,821 376,675 543,297 241,475 80% 166,622 44%
Wholesale 284,188 300,244 252,914 (31,273) ‐11% (47,329)‐16%
Service 1,061,981 1,141,359 1,118,284 56,303 5% (23,075)‐2%
Other 139,652 132,649 147,864 8,212 6% 15,215 11%
YTD Total 5,119,838$ 5,178,155$ 5,248,928$ 129,090$ 3%70,773$ 1%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
March utility tax revenues are $1.6 million,
which is $438k or 37% higher than the same
month last year and is also ahead of the
budget by $321k or 24%. The year‐to‐date
collection is $4.5 million, which is $596k or
15% higher than the prior year and is also
$356k or 9% 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,367,581$ 1,507,913$ 1,547,772$ 180,190$ 13%$ 39,859 3%
Natural Gas 664,886 718,836 794,160 129,274 19% 75,324 10%
Cell 389,133 467,257 508,427 119,294 31% 41,170 9%
Phone 177,601 199,676 258,930 81,329 46% 59,254 30%
Cable 332,857 341,046 348,235 15,378 5% 7,189 2%
Garbage/Solid Waste 99,887 68,589 150,679 50,793 51% 82,090 120%
City Utilities 901,280 870,260 920,917 19,637 2% 50,657 6%
YTD Total 3,933,225$ 4,173,577$ 4,529,120$ 595,895$ 15%355,543$ 9%
Annual Total 15,782,047$ 15,859,850$
YTD as % of 25% 26%
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
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 3,933,225$ 4,173,577$ 4,529,120$ 595,895$ 15% 355,543$ 9%
Annual Total 15,782,047$ 15,859,850$
2014 vs. Budget2014 vs. 2013
Year to Date through March
Utility Tax Revenues
Month
Page 3 of 37
Monthly Financial Report March 2014
Other Taxes
Real Estate Excise Tax
The City collected $228k in Real Estate Excise
Tax revenues (REET) for March. This is right
on target with the same month last year and
is $30k or 15% more than the current
month’s budget. The year‐to‐date collection
is $838k, which is $214k or 34% more than
the prior year and is also $279k or 50%
above the budget. The higher than expected
variance in February is a result of an audit
done by the Washington State Department
of Revenue ($135k) and 1 large transaction
($119k). The City is projecting REET to meet
the budget at year‐end.
Gambling Tax
March’s Gambling Tax collections
totalled $154k, which is $42k or 38%
above the same month last year and is
also $42k or 38% above the current
month’s budget. The year‐to‐date total
of $419k is $100k or 31% above the year
before and is also $27k or 7% above
budget.
Pull tabs overall had a 7% increase, bingo
increased by 4%, and card‐rooms are
seeing 1% higher in activities when
compared to the prior year. This is
primarily due to payment arrangements
being met for back taxes due in 2012 and
2013. $17k is due to back taxes collected. In addition, Feb. 2013 payments were not made and under collected by
approximately $50k.
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 is $8.7k or 2% higher than
the prior year and is also $22k or 7%
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 ‐
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 318,528$ 391,447$ 418,580$ 100,052$ 31% 27,133$ 7%
Annual Total 1,319,585$ 1,600,000$
2014 vs. 2013 2014 vs. Budget
Gambling Tax Revenue
Month
Year to Date through March
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 314,269$ 300,776$ ‐$ (314,269)$ ‐100% (300,776)$ ‐100%
Feb 200 98 323,121 322,921 161461% 323,023 330063%
Mar 892 437 ‐
Apr 311,986 299,239 ‐
Jul 315,694 303,760 ‐
Oct 321,202 308,381 ‐
Dec 48,484 47,308 ‐
YTD Total 315,362$ 301,311$ 323,121$ 8,652$ 2% 22,247$ 7%
Annual Total 1,312,727$ 1,260,000$
Franchise Fees Revenue
Year to Date through March
Month
2014 vs. 2013 2014 vs. Budget
2013 2014 2014
ActualBudgetActual $%$%
Jan 134,099$ 106,402$ 162,143$ 28,044$ 21% 55,741$ 52%
Feb 262,229 255,153 448,452 186,223 71% 193,299 76%
Mar 228,077 197,296 227,629 (448) 0% 30,334 15%
Apr 197,659 165,760
May 285,948 229,672
Jun 347,890 293,243
Jul 263,807 191,969
Aug 294,056 222,770
Sep 254,318 185,694
Oct 272,776 228,340
Nov 342,535 217,021
Dec 1,248,272 606,681
YTD Total 624,405$ 558,851$ 838,225$ 213,819$ 34% 279,374$ 50%
Annual Total 4,131,665$ 2,900,000$
Month
2014 vs. Budget2014 vs. 2013
Real Estate Excise Tax Revenues
Year to Date through March
Page 4 of 37
Monthly Financial Report March 2014
Admission Tax
Admission Tax returns are due quarterly
in January, April, July, and October of
each year. January 2014 collections
represent activities conducted during the
4th quarter of 2013. The year‐to‐date
collection of $80k is $2.2k or 3% less than
the prior year but is $5k or 6% more than
the budget.
Licenses and Permits
Building Permits and Development Service
Fees
Building Permits and Development Service Fee
revenues totalled $388k in March. The
year‐to‐date development fees revenue of
$1.2 million is $371k or 43% more than the
year before and is also $480k or 64% 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 $5k for March, which is
$7k or 56% below the same month last year and is
also $4k or 44% below the current month’s
budget. The year‐to‐date Business Licenses
revenue of $133k is $15k or 10% below the prior
year and is also $16k or 11% 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
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 862,709$ 753,544$ 1,233,397$ 370,688$ 43% 479,853$ 64%
Annual Total 4,001,625$ 3,705,701$
Building Permits and Development Service Fees
Year to Date through March
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 ‐
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 148,480$ 149,692$ 133,498$ (14,983)$ ‐10% (16,194)$ ‐11%
Annual Total 503,766$ 533,067$
Business Licenses
Month
2014 vs. 2013
Year to Date through March
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 ‐
Jul 87,473 81,342 ‐
Aug 76 37 ‐
Oct 85,616 77,019 ‐
Nov 1,192 575 ‐
Dec 149 672 ‐
YTD Total 82,440$ 75,656$ 80,243$ (2,196)$ ‐3% 5,038$ 6%
Annual Total 327,258$ 308,000$
Month
2014 vs. 2013 2014 vs. Budget
Admission Tax Revenue
Year to Date through Ma rch
Page 5 of 37
Monthly Financial Report March 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 64%
of the total revenues in this
category. The year‐to‐date
total Intergovernmental revenue is $2.2 million or 19% of the budget.
State Shared Revenues
State Shared Revenue collections
totalled $1.3 million since the start of
the year. Compared to the prior year,
State Shared Revenues are above by
$129k or 11%. Compared to the
projected budget, the City is
collecting $193k or 18% 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 57% of the total revenue in this category. The year‐to‐date total charges for services are $1.8 million or 26% of
the budget. The following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $207k 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 $20k or 11% more. Compared to the
year‐to‐date budget, the City is $26k or 15%
more. The reason for the monthly variance
with the prior year and budget is due to the
timing of when Valley Narcotics Enforcement
Team (VNET) contributions/charges for
services are receipted. The City is projecting
Public Safety Services to be very close with the
budget by year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Crim Just Sales Tax 522,217$ 494,064$ 562,564$ 40,346$ 8% 68,499$ 14%
Judicial Contribution 5,699 5,625 5,763 64 1% 138 2%
Crim Just ‐ High Crime 51,491 ‐ 63,559 12,068 23% 63,559 100%
Crim Just ‐ Pop 5,399 ‐ 5,947 547 10% 5,947 100%
Crim Just ‐ Spec Prog 20,228 21,741 22,008 1,780 9% 267 1%
State DUI 4,258 4,535 4,433 176 4% (102) ‐2%
Liquor Profits 211,723 124,448 212,414 691 0% 87,965 71%
Liquor Excise Tax ‐ 118,266 63,322 63,322 100% (54,945) ‐46%
Fuel Tax 309,969 298,689 320,268 10,298 3% 21,579 7%
YTD Total 1,130,985$ 1,067,369$ 1,260,277$ 129,292$ 11% 192,908$ 18%
Annual Total 4,701,889$ 4,515,500$
2014 vs. Budget
State Shared Revenues
2014 vs. 2013
Revenue
Year to Date through March
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 ‐
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 186,458$ 180,532$ 206,806$ 20,348$ 11% 26,274$ 15%
Annual Total 680,581$ 774,535$
Month
2014 vs. 2013
Year to Date through March
Public Safety Services
2014 vs. Budget
Intergovernmental 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
Fire District #25 ‐$ ‐$ ‐$ ‐$ N/A $ ‐ N/A
Fire District #40 161,972 151,469 151,469 (10,503) ‐6%‐ 0%
State Shared Revenue 1,130,985 1,067,369 1,260,277 129,292 11% 192,908 18%
Federal Grants 505,125 722,044 722,044 216,919 43%‐ 0%
State Grants 10,373 7,658 7,658 (2,715) ‐26%‐ 0%
Other Grants/Intgovt 11,079 65,455 65,455 54,376 491%‐ 0%
ARRA Grants 114,171 0 ‐ (114,171) 0%‐ 0%
Total Rev YTD 1,933,705$ 2,013,994$ 2,206,902$ 273,197$ 14%192,908$ 10%
Total Rev Annual 11,682,043$ 11,525,770$
YTD % 17% 17% 19%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
Page 6 of 37
Monthly Financial Report March 2014
Recreation
Recreation revenues totalled $66k for the
current month. Compared to the same month
the prior year, the City collected $13k or 16%
less. Compared to the projected monthly
budget, the City collected $28k or 29% less.
The year‐to‐date collection of $205k is $14k or
7% higher than the year before but is $8k or
4% lower than the year‐to‐date budget. The
City is projecting Recreation revenues to be
very close with the budget at year‐end.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $846k. Compared to the
prior year, the revenues are under by $30k or
3%. Compared to the projected budget, the
revenues are above by $66k or 8%. 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 $492k. This is $184k or 27%
lower than a year ago and is also $219k or
31% 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 ‐
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 191,197$ 213,083$ 204,853$ 13,656$ 7% (8,230)$ ‐4%
An nual Total 1,494,580$ 1,525,863$
Recreation
Year to Date through March
2014 vs. Budget2014 vs. 2013
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 265,873$ 260,084$ 301,808$ 35,935$ 14% 41,725$ 16%
Feb 292,362 260,084 257,027 (35,335) ‐12% (3,057) ‐1%
Mar 317,998 260,084 287,465 (30,533) ‐10% 27,381 11%
Apr 288,610 260,084 ‐
May 299,652 260,084 ‐
Jun 287,569 260,084 ‐
Jul 282,466 260,084 ‐
Aug 352,945 260,084 ‐
Sep 274,525 260,084 ‐
Oct 352,421 260,084 ‐
Nov 286,300 260,084 ‐
Dec 164,190 260,084 ‐
YTD Total 876,233$ 780,251$ 846,300$ (29,934)$ ‐3% 66,049$ 8%
An nual Total 3,464,913$ 3,121,003$
Interfund Services
Year to Date through March
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
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 675,452$ 710,777$ 491,714$ (183,738)$ ‐27% (219,063)$ ‐31%
Annual Total 2,766,663$ 3,058,500$
2014 vs. Budget2014 vs. 2013
Year to Date through March
Fines and Penalties by Month
Month
Page 7 of 37
Monthly Financial Report March 2014
Year to Date through March
2013 2014 2014
Actual Budget Actual $ % $ %
Civil Penalties 1,281$ 2,389$ 1,939$ 658$ 51% (450)$ ‐19%
Civil Infraction Penalties 110,878 107,737 142,809 31,931 29% 35,072 33%
Civil Parking Infraction Penalties 32,564 30,360 45,956 13,392 41% 15,596 51%
Photo Enforcement Program 462,103 507,093 233,688 (228,415) ‐49% (273,405) ‐54%
Criminal Traffic Misdemeanor Fines 19,181 19,311 20,854 1,673 9% 1,543 8%
Criminal Non‐Traffic Fines 4,938 6,132 12,198 7,260 147% 6,066 99%
Criminal Costs 25,844 22,599 29,480 3,636 14% 6,881 30%
Non‐Court Fines, Forfeitures and Penalties 18,664 15,155 4,790 (13,873) ‐74% (10,365) ‐68%
YTD Total 675,452$ 710,777$ 491,714$ (183,738)$ ‐27% (219,063)$ ‐31%
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 $234k. 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 63% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $470k. Compared to
last year, the revenues are above by $66k or
16%. Compared to the projected year‐to‐date
budget, the revenues are over by $77k or
20%. The table on the following page breaks
out miscellaneous revenues by type.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 179,743$ 183,381$ 243,963$ 64,220$ 36% 60,582$ 33%
Feb 76,397 59,957 99,547 23,149 30% 39,590 66%
Mar 147,909 149,166 126,132 (21,777) ‐15% (23,034) ‐15%
Apr 92,872 94,316
May 118,719 202,207
Jun 123,441 122,811
Jul 128,246 117,209
Aug 122,652 124,033
Sep 92,799 88,740
Oct 82,288 81,930
Nov 63,945 81,224
Dec 399,005 674,483
YTD Total 404,049$ 392,504$ 469,642$ 65,593$ 16% 77,138$ 20%
Annual Total 1,628,017$ 1,979,457$
Ye ar to Date through March
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 ‐ 71,661 ‐ ‐
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 Total 507,093$ 233,688$ 220,238$ 161,084$ 72,604$
Annual Total 1,950,000$ 841,964$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through March
Month
Page 8 of 37
Monthly Financial Report March 2014
2013 2014 2014
Actual Budget Actual $ % $ %
Interests and Other Earnings 18,593$ 38,416$ 35,420$ 16,827$ 91% (2,996)$ ‐8%
Rents, Leases, and Concessions 265,202 261,959 262,643 (2,560) ‐1% 683 0%
Contributions/Donations from Private Sources 19,028 23,576 27,847 8,819 46% 4,271 18%
Other 97,734 56,094 144,202 46,467 48% 88,108 157%
Seizure Funds ‐ Federal/State/Local1 3,491 12,458 (470) (3,961) ‐113% (12,928) ‐104%
YTD Total 404,049$ 392,504$ 469,642$ 65,593$ 16% 77,138$ 20%
Annual Total 1,628,017$ 1,979,457$
1Seizure Funds are categorized in Miscellaneous for 2013 and on.
2014 vs. Budget
Miscellaneous Revenues by Type
Year to Date through March
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 22% of its budgeted general governmental expenditures at the end of March. This is $61k or
0.3% above 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 $10k or 14.1%. 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.
City Attorney department is over the year‐to‐date budget by $22k or 5.6%. This is due to an interfund transfer contribution
($160k) done in the prior year that would skew the year‐to‐date budget. Overall City Attorney budget will correct itself
later on in the year.
Court Services department is over the year‐to‐date budget by $8k or 1.7%. This is mainly due to overspending on the year‐
to‐date salaries and benefits budget, supplies and professional services. We will monitor these items to determine if a
budget adjustment is needed.
Administrative Services department is over the year‐to‐date by $203k or 29.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.
Police department is over the year‐to‐date by $370k or 5.9%. This is mainly due to overspending on salaries and benefits
($222k), supplies ($22k), and intergovernmental ($160k) and under spending on services ($70k). The salaries and benefits
variance is due to retro payments (contract settlement) and the budget will be adjusted in April with the 2014 Carry
Forward Budget Adjustment. The variances for the other categories are due to the timing of when payments are made.
Page 9 of 37
Monthly Financial Report March 2014
CASH AND INVESTMENTS – 1ST
QUARTER
The current cash and
investments (C&I)
portfolio is provided in the
table to the right. The
City’s current C&I balance
is $110.7 million, of this
amount; $775k is an
interfund loan investment
(Res 4070) from the
insurance fund (502) to
the golf course fund (404).
This interfund loan is due
in full on December 1st
2015.
Currently the majority of
the portfolio is located in
cash deposits (US Bank).
The rest is spread out
between the State
Investment Pool, various
certificates of deposits,
and the interfund loan.
The existing portfolio yield is approximately .59%. The majority (.39%) is within the cash at US Bank.
Cash
58%
Local Government
Investment Pool
9%
US Federal Agency
Securities
11%Certificates of
Deposit
21%
INTERFUND
INVESTMENT
1%
Distribution by Instrument
(shown as percent of blended Portfolio*)
Deposit Total Maturity Date APY Weighted Yield Current Allocation of
Cash and Investments
Allowed
by Policy
Current Principal
Balance
Cash US Bank ‐ Cash 64,195,480 overnight 0.45% 0.39%58%N/A 64,195,480
GOLF '14 GOLF '14 383,239 12/1/2014 2.25% 0.02%
GOLF '15 GOLF '15 391,853 12/1/2015 2.25% 0.02%
US Treasury Securities
none ‐ N/A N/A 0.00%0% 100%‐
Local Government Investment Pool
3920 State Investment Pool 9,930,561 1/1/2014 0.13% 0.02% 9% 75% 9,930,561
US Federal Agency Securities *
314179A FHLB 1,996,920 8/11/2017 1.00% 0.06%
313169B FHLMC 2,500,000 10/24/2016 0.90% 0.06%
313169C FNMA 2,500,000 10/24/2016 1.06% 0.07%
314179B FHLMC 5,000,000 11/28/2017 1% 0.15%
Certificates of Deposit
113154A First Savings Bank Northwest 5,000,000 2/4/2015 0.92% 0.13%
113164A First Savings Bank Northwest 5,000,000 2/4/2016 1.02% 0.14%
112147a Columbia Bank 2,768,975 1/11/2014 0.69% 0.05%
111167a Columbia Bank 2,015,400 11/9/2016 0.99% 0.05%
212145a Fortune Bank (CDARS) 1,516,108 6/14/2014 0.70% 0.03%
212145b Fortune Bank (CDARS) 1,000,685 12/18/2014 0.65% 0.02%
112145a Fortune Bank (traditional) 252,980 12/23/2014 0.85% 0.01%0% 20%
112146a Umpqua Bank 5,209,717 5/18/2014 0.85% 0.12%
Commencement Bank (CDARS) 1,030,141 9/20/2014 0.65% 0.02%1%
212143a
Commercial Paper
none ‐ N/A N/A 0.00%0.00% 5%‐
TOTAL CASH & INVESTMENTS 110,692,059$ 110,692,059$
11,996,920 100%11%
1% N/A 775,092
1,030,141
20%3%
20%5%5,209,717
2,769,772
By Institution
*Held in our safekeeping account at BNY Trust and Custody
Golf Interfund Loan
20%9%
20%4%
10,000,000
4,784,375
20%
Page 10 of 37
Monthly Financial Report March 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 ‐ ‐ ‐ ‐ 17,660 14,375 ‐
Grants / intergovernmental 365,167 ‐ 33,850 ‐ ‐ 359,247 ‐
Charges for services 35,843 224,964 4,325,189 3,683,489 2,386,343 2,341,432 3,830,909
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 2,154 ‐ ‐ ‐ 95 ‐ ‐
Rents, leases, and misc fees 610,897 38,021 6,413 37,756 ‐ ‐ ‐
Interest and other misc 1,879 528 2,134 70,268 187,772 98,185 2,426
TOTAL REVENUES 1,015,940 263,513 4,367,586 3,791,513 2,591,870 2,813,239 3,833,335
EXPENSES:
Utility billing ‐ ‐ 30,427 30,459 22,035 35,676 ‐
Utility systems ‐ ‐ 3,173,703 1,159,932 700,105 769,854 ‐
Utility maintenance ‐ ‐ 66,842 1,155,976 330,383 508,645 3,653,812
Transportation 1,002,136 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 434,980 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,002,136 434,980 3,270,972 2,346,367 1,052,523 1,314,175 3,653,812
AMOUNT AVAILABLE FOR DEBT SERVICE 13,804 (171,467) 1,096,614 1,445,146 1,539,347 1,499,064 179,523
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ 1,625 ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ 1,625 ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 224,794 13,950 ‐ 214,899 460,625 766,650 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (210,990) (187,042) 1,096,614 1,230,247 1,078,722 732,414 179,523
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, Mar 31 1,458,574 132,119 2,441,497 13,581,199 6,607,088 8,242,699 2,783,085
Page 11 of 37
Monthly Financial Report March 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 ‐ 35,517 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 44,426
Charges for services
Equipment rental m&o 681,343 754,228 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 28,106 ‐ 100,928 ‐ ‐ ‐
Communications ‐ 1,545 ‐ 131,413 ‐ ‐ ‐
Facilities ‐ ‐ 1,063,902 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 35,109 ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ 109,670 ‐ ‐ ‐ ‐ ‐
Interest and other misc 3,683 2,019 1,191 341 6,446 5,933 6,584
Internal service fund misc:
Vehicle / equipment capital recovery 380,383 33,742 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 407,837 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 387,714 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 2,859,512 426,871
Other misc ‐ 2 1,286 ‐ ‐ 73,179 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 37,373 ‐ ‐
TOTAL REVENUES 1,065,409 999,938 1,066,378 232,682 839,370 2,938,624 477,881
EXPENSES:
Communications 124,825
Equipment rental 578,353
Facilities 866,000
Healthcare 3,421,929
Information technology 836,817
Print and mail 79,151
Retiree healthcare 296,466
Risk management
Ri sk management 988,450
Unemployment 17,009
Worker's compensation 381,622
TOTAL EXPENSES 578,353 836,817 866,000 203,976 1,387,081 3,421,929 296,466
AMOUNT AVAILABLE FOR CAPITAL 487,056 163,121 200,378 28,706 (547,711) (483,305) 181,415
CAPITAL PROJECTS 294,624 80,589 34,762 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 192,432 82,532 165,616 28,706 (547,711) (483,305) 181,415
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, Mar 31 4,127,520 2,299,144 1,333,330 376,477 7,082,366 6,450,999 7,389,118
Page 12 of 37
Monthly Financial Report March 2014
FUND BALANCE
Page 14 shows the ending fund balance as of March 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 March, the City has $13.4 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 13% of budgeted operating expenditures. This is a decrease of $4.1 million
from the year’s beginning balance. March’s ending fund balance is over the anticipated General Governmental Fund
Balance of $4.8 million by $8.6 million or 180.7%. Although the ending fund balance is above projections, it is consistent
with the prior years’ trends since the City will receipt the first half of 2014 property taxes in April/May and second half in
October/November.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services Department. For additional financial
information, please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel
free to contact us at hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.
Page 13 of 37
Monthly Financial Report March 2014
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through March 31, 2014
Funds
Balance
01/01/2014
Budgeted
Revenue
Revenue
03/31/14
Total Funds
Available
Budgeted
Expenditure
Expenditure
03/31/14
Ending
Balance
GENERAL GOVERNMENT FUNDS:17,454,261 106,735,133 19,541,262 36,995,523 105,072,444 23,627,952 13,367,571
000 General 12,515,053 77,980,004 14,856,658 27,371,711 76,066,698 19,053,064 8,318,647
001 Community Services 2,124,598 11,288,725 2,046,458 4,171,056 11,224,073 2,238,855 1,932,201
003 Street 1,667,393 8,532,875 1,441,672 3,109,065 8,820,818 1,902,103 1,206,963
004 Community Dev Block Grant (229,834) 296,985 304,785 74,951 296,985 62,322 12,629
005 Museum 52,979 211,281 32 53,011 218,308 49,955 3,056
009 Farmers Market 98,826 59,400 6,356 105,182 79,699 15,008 90,174
011 Fire Health & Wellness 55,094 25,000 6,290 61,384 25,000 2,813 58,571
031 Park Memorial 478 ‐ ‐ 478 ‐ 478 ‐
201 Ltd GO Bonds Gen Govt Debt 833,717 1,749,705 861 834,578 1,749,705 ‐ 834,578
215 Gen Govt Misc Debt Service 335,957 6,591,158 878,150 1,214,107 6,591,158 303,355 910,752
SPECIAL REVENUE FUNDS:
102 Arterial Street 192,689 633,000 150,945 343,634 640,000 ‐ 343,634
108 Leased City Properties 549,887 813,071 127,960 677,847 768,355 118,054 559,793
110 Hotel Motel 185,606 265,000 43,780 229,386 265,000 8,916 220,470
125 1% For Art 97,771 15,000 87 97,858 50,000 7,915 89,943
127 Cable Communication 284,632 85,674 52,563 337,195 85,674 12,137 325,058
135 Springbrook Wetlands Bank 667,613 ‐ 606 668,219 ‐ ‐ 668,219
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 934,618 60,000 27,107 961,725 ‐ ‐ 961,725
304 Fire Mitigation 646,165 50,000 49,667 695,832 ‐ ‐ 695,832
305 Transportation Mitigation 486,185 40,000 54,209 540,394 105,000 ‐ 540,394
316 Municipal Facilities CIP 5,083,524 1,380,000 388,086 5,471,610 1,380,000 1,049,126 4,422,484
317 Transportation CIP 2,687,303 6,345,230 595,810 3,283,113 6,344,820 3,774,537 (491,424)
318 So Lake WA Infrastructure Proj 9,012 ‐ 8 9,020 ‐ ‐ 9,020
326 Housing Opportunity 84,599 ‐ 76 84,675 ‐ ‐ 84,675
336 New Library Development 19,571,748 ‐ 17,665 19,589,413 ‐ 279,610 19,309,803
ENTERPRISE FUNDS:
402 Airport 191,466 1,431,610 649,298 840,764 1,460,825 388,927 451,837
403 Solid Waste Utility 1,344,883 16,419,820 4,367,586 5,712,469 16,503,624 3,270,971 2,441,498
404 Golf Course 33,445 2,487,449 263,256 296,701 2,511,090 449,102 (152,401)
422 Airport Capital 1,478,098 1,757,517 366,643 1,844,741 1,754,739 838,003 1,006,738
424 Golf Course Capital 285,716 50,000 12,754 298,470 50,000 13,950 284,520
INTERNAL SERVICE FUNDS:
501 Equipment R epair/Replacement 3,935,088 4,347,461 1,065,410 5,000,498 3,604,564 872,977 4,127,521
502 Insurance 7,630,077 4,344,062 839,370 8,469,447 3,185,695 1,387,081 7,082,366
503 Information Services 2,216,612 4,010,222 999,937 3,216,549 3,985,711 917,406 2,299,143
504 Facilities 1,167,714 4,092,976 1,066,378 2,234,092 4,087,028 900,762 1,333,330
505 Communications 347,771 896,374 232,682 580,453 909,987 203,975 376,478
512 Insurance, Healthcare 6,934,304 11,622,068 2,938,623 9,872,927 12,059,944 3,421,929 6,450,998
522 Insurance, Le off1 Retirees HC 7,207,703 1,735,684 477,881 7,685,584 1,737,885 296,466 7,389,118
FIDUCIARY FUNDS:
611 Firemen's Pension 4,790,247 300,000 2,365 4,792,612 225,475 46,057 4,746,555
Funds
Balance
01/01/2014
Budgeted
Revenue
Revenue
03/31/14
Total Funds
Available
Budgeted
Expenditure
Expenditure
03/31/14
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 27,993,165 56,834,449 13,029,957 41,023,122 54,106,043 9,809,050 31,214,072
405 Water Utility 8,523,106 13,765,149 3,741,291 12,264,397 10,990,310 1,959,398 10,304,999
406 Waste Water Utility 2,578,193 7,263,934 2,415,322 4,993,515 5,358,324 1,045,200 3,948,315
407 Surface Water Utility 4,342,360 4,863,612 2,360,195 6,702,555 6,696,073 1,157,230 5,545,325
416 King County Metro 2,603,562 15,202,336 3,833,335 6,436,897 15,202,336 3,653,812 2,783,085
425 Water Utility Construction 3,811,904 4,385,000 50,208 3,862,112 4,385,000 601,868 3,260,244
426 Waste Water Construction 2,950,173 3,300,000 176,548 3,126,721 3,250,000 467,947 2,658,774
427 Surface Water Construction 3,167,925 8,054,418 453,044 3,620,969 8,224,000 923,595 2,697,374
471 Waterworks Rate Stabilization 15,942 ‐ 14 15,956 ‐ ‐ 15,956
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 14 of 37
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
May
June
July
August
September
October
November
December
(3,000,000)
(2,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 15 of 37
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,830,059 5,710,991 ‐2.04%
Feb 11,821,814 12,530,792 6.00%
Mar 17,577,358 19,541,262 11.17%
Apr 34,441,952
May 48,397,814
Jun 53,470,617
Jul 59,869,036
Aug 65,144,331
Sep 70,631,024
Oct 87,474,518
Nov 99,427,791
Dec 106,735,133
Percent of budget 18.31%
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
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 4.83%
$(3)
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Budget
Actual
Last Year
Page 16 of 37
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
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 26.16%
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
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 28.56%
Note: Includes Natural Gas Use Tax.
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 17 of 37
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
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 29.71%
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 2,997,981
May 5,419,239
Jun 5,915,393
Jul 6,568,328
Aug 7,119,936
Sep 7,595,205
Oct 8,623,976
Nov 10,949,557
Dec 11,525,770
Percent of budget 19.15%
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 18 of 37
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 448,485 669,010 49.17%
Feb 967,087 1,198,034 23.88%
Mar 1,495,472 1,831,413 22.46%
Apr 2,143,534
May 2,727,966
Jun 3,296,578
Jul 4,077,349
Aug 4,745,880
Sep 5,263,129
Oct 5,848,150
Nov 6,364,546
Dec 6,946,295
Percent of budget 26.37%
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
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 16.08%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 19 of 37
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 616,087 343,410 ‐44.26%
Feb 918,703 1,173,666 27.75%
Mar 1,184,636 1,511,820 27.62%
Apr 1,883,099
May 2,406,312
Jun 2,792,148
Jul 3,693,079
Aug 4,019,731
Sep 4,320,577
Oct 5,145,251
Nov 5,473,745
Dec 6,563,000
Percent of budget 23.04%
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 183,381 243,963 33.04%
Feb 243,338 343,510 41.17%
Mar 392,504 469,642 19.65%
Apr 486,820
May 689,026
Jun 811,837
Jul 929,047
Aug 1,053,080
Sep 1,141,820
Oct 1,223,750
Nov 1,304,974
Dec 1,979,457
Percent of budget 23.73%
$‐
$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 20 of 37
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 ‐
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 21 of 37
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
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 28.90%
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
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 33.28%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions Fees
Budget
Actual
Last Year
Page 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,493,149 8,047,088 7.39%
Feb 16,016,788 15,890,655 ‐0.79%
Mar 23,566,580 23,627,952 0.26%
Apr 34,477,520
May 43,323,981
Jun 51,703,014
Jul 60,864,634
Aug 69,612,016
Sep 78,382,277
Oct 86,811,548
Nov 95,433,862
Dec 105,072,444
Percent of budget expended 22.49%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$300 000
Legislative
Legislative Budget Actual over (under)
Jan 23,600 23,569 ‐0.13%
Feb 48,503 55,960 15.37%
Mar 73,699 84,100 14.11%
Apr 98,693
May 123,150
Jun 147,659
Jul 172,257
Aug 196,241
Sep 220,634
Oct 245,277
Nov 269,840
Dec 295,947
Percent of budget expended 28.42%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 23 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 79,778 76,257 ‐4.41%
Feb 195,660 186,396 ‐4.73%
Mar 314,202 296,472 ‐5.64%
Apr 436,250
May 553,191
Jun 656,617
Jul 770,042
Aug 884,797
Sep 989,853
Oct 1,101,700
Nov 1,212,767
Dec 1,349,262
Percent of budget expended 21.97%
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 130,608 135,206 3.52%
Feb 263,897 276,371 4.73%
Mar 397,056 419,299 5.60%
Apr 538,183
May 667,679
Jun 805,013
Jul 935,343
Aug 1,068,299
Sep 1,207,902
Oct 1,353,064
Nov 1,484,680
Dec 1,700,639
Percent of budget expended 24.66%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00 Budget
Actual
Last Year
Page 24 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 157,338 159,512 1.38%
Feb 317,867 323,167 1.67%
Mar 479,793 487,984 1.71%
Apr 649,498
May 815,721
Jun 997,310
Jul 1,166,280
Aug 1,329,864
Sep 1,492,494
Oct 1,656,756
Nov 1,820,956
Dec 2,009,688
Percent of budget expended 24.28%
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,562 83,232 ‐0.39%
Feb 167,265 166,457 ‐0.48%
Mar 251,248 249,681 ‐0.62%
Apr 337,835
May 419,824
Jun 502,350
Jul 584,984
Aug 667,510
Sep 750,213
Oct 832,697
Nov 914,978
Dec 1,008,700
Percent of budget expended 24.75%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions Development Admin
Budget
Actual
Last Year
Page 25 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 217,541 216,780 ‐0.35%
Feb 421,988 437,105 3.58%
Mar 630,714 683,399 8.35%
Apr 858,769
May 1,074,649
Jun 1,298,823
Jul 1,527,227
Aug 1,771,154
Sep 1,996,938
Oct 2,235,337
Nov 2,464,233
Dec 2,698,044
Percent of budget expended 25.33%
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 68,812 36,443 ‐47.04%
Feb 105,130 80,671 ‐23.27%
Mar 144,914 136,650 ‐5.70%
Apr 187,864
May 227,256
Jun 271,254
Jul 317,530
Aug 367,878
Sep 412,847
Oct 457,115
Nov 506,248
Dec 559,126
Percent of budget expended 24.44%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
Millions
Budget
Actual
Last Year
Page 26 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 173,384 123,910 ‐28.53%
Feb 357,979 264,152 ‐26.21%
Mar 539,305 426,860 ‐20.85%
Apr 721,403
May 903,650
Jun 1,087,086
Jul 1,271,139
Aug 1,473,167
Sep 1,670,789
Oct 1,843,297
Nov 2,022,929
Dec 2,217,824
Percent of budget expended 19.25%
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 152,534 161,643 5.97%
Feb 307,128 331,528 7.94%
Mar 470,299 505,966 7.58%
Apr 641,981
May 818,302
Jun 998,322
Jul 1,182,829
Aug 1,370,261
Sep 1,534,243
Oct 1,687,767
Nov 1,837,345
Dec 2,315,570
Percent of budget expended 21.85%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40 Budget
Actual
Last Year
Page 27 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 62,922 62,855 ‐0.11%
Feb 130,652 183,252 40.26%
Mar 213,249 380,731 78.54%
Apr 287,836
May 489,593
Jun 553,554
Jul 733,334
Aug 813,979
Sep 885,865
Oct 956,762
Nov 1,028,890
Dec 1,106,909
Percent of budget expended 34.40%
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,210 63,751 ‐11.71%
Feb 151,673 131,247 ‐13.47%
Mar 237,798 203,164 ‐14.56%
Apr 318,066
May 394,766
Jun 486,193
Jul 568,667
Aug 653,735
Sep 734,745
Oct 816,748
Nov 900,856
Dec 996,150
Percent of budget expended 20.39%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Budget
Actual
Last Year
Page 28 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Police Budget
YTD
Actual
Annual %
over (under)
Jan 2,401,322 2,620,270 9.12%
Feb 4,794,609 4,935,606 2.94%
Mar 7,168,180 7,538,512 5.17%
Apr 9,888,590
May 12,497,000
Jun 14,865,091
Jul 17,521,427
Aug 19,815,207
Sep 22,443,271
Oct 24,748,356
Nov 27,324,960
Dec 29,884,645
Percent of budget expended 25.23%
Fire &
Emergency YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
Millions Police
Budget
Actual
Last Year
$27
Millions Fire & Emergency Services
Services Budget Actual over (under)
Jan 2,032,671 2,561,083 26.00%
Feb 4,825,761 4,745,812 ‐1.66%
Mar 6,823,386 6,727,201 ‐1.41%
Apr 8,816,124
May 10,978,696
Jun 12,955,980
Jul 14,939,367
Aug 16,954,511
Sep 18,951,590
Oct 20,976,654
Nov 23,030,284
Dec 25,106,874
Percent of budget expended 26.79%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
Budget
Actual
Last Year
Page 29 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 40,991 36,113 ‐11.90%
Feb 79,805 75,787 ‐5.03%
Mar 118,717 120,240 1.28%
Apr 158,710
May 198,306
Jun 237,639
Jul 276,769
Aug 315,575
Sep 353,934
Oct 392,099
Nov 432,386
Dec 477,630
Percent of budget expended 25.17%
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 283,373 271,473 ‐4.20%
Feb 580,106 555,521 ‐4.24%
Mar 891,933 856,188 ‐4.01%
Apr 1,234,823
May 1,564,643
Jun 1,918,574
Jul 2,294,456
Aug 2,692,594
Sep 3,086,642
Oct 3,465,100
Nov 3,818,884
Dec 4,179,513
Percent of budget expended 20.49%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50 Budget
Actual
Last Year
Page 30 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 38,340 43,855 14.38%
Feb 78,685 90,409 14.90%
Mar 129,973 148,948 14.60%
Apr 178,519
May 235,072
Jun 285,622
Jul 336,438
Aug 386,013
Sep 439,420
Oct 495,488
Nov 546,802
Dec 685,661
Percent of budget expended 21.72%
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
$6
Millions Recreation
Recreation Budget Actual over (under)
Jan 314,542 278,944 ‐11.32%
Feb 670,828 603,208 ‐10.08%
Mar 1,031,723 928,117 ‐10.04%
Apr 1,416,138
May 1,776,650
Jun 2,168,143
Jul 2,783,938
Aug 3,446,993
Sep 3,943,611
Oct 4,304,371
Nov 4,657,750
Dec 5,063,974
Percent of budget expended 18.33%
$‐
$1
$2
$3
$4
$5
$6
Budget
Actual
Last Year
Page 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 51,586 47,594 ‐7.74%
Feb 127,385 143,610 12.74%
Mar 238,323 249,760 4.80%
Apr 369,323
May 447,896
Jun 513,447
Jul 645,557
Aug 711,028
Sep 761,451
Oct 902,012
Nov 975,676
Dec 1,160,116
Percent of budget expended 21.53%
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
$900 000
Neighborhoods, Resources, and Events
and Events Budget Actual over (under)
Jan 62,828 57,193 ‐8.97%
Feb 120,749 146,776 21.55%
Mar 192,586 200,847 4.29%
Apr 256,511
May 319,217
Jun 399,294
Jul 498,209
Aug 577,803
Sep 651,443
Oct 718,836
Nov 815,013
Dec 896,992
Percent of budget expended 22.39%
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
Budget
Actual
Last Year
Page 32 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 17,765 16,819 ‐5.33%
Feb 35,760 33,387 ‐6.64%
Mar 53,774 49,955 ‐7.10%
Apr 72,573
May 90,724
Jun 109,066
Jul 127,058
Aug 145,320
Sep 163,690
Oct 182,018
Nov 200,448
Dec 218,308
Percent of budget expended 22.88%
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 43,851 31,793 ‐27.50%
Feb 87,527 63,574 ‐27.37%
Mar 131,292 95,355 ‐27.37%
Apr 177,010
May 219,556
Jun 260,323
Jul 299,379
Aug 338,954
Sep 378,070
Oct 415,960
Nov 453,791
Dec 492,345
Percent of budget expended 19.37%
$‐
$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 33 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 343,343 311,026 ‐9.41%
Feb 733,256 658,352 ‐10.22%
Mar 1,093,100 980,862 ‐10.27%
Apr 1,466,103
May 1,824,610
Jun 2,207,061
Jul 2,567,145
Aug 2,916,086
Sep 3,276,933
Oct 3,641,917
Nov 4,007,746
Dec 4,418,539
Percent of budget expended 22.20%
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 290,664 278,181 ‐4.29%
Feb 644,525 632,259 ‐1.90%
Mar 1,004,897 921,240 ‐8.32%
Apr 1,424,149
May 1,755,620
Jun 2,064,742
Jul 2,445,764
Aug 2,829,910
Sep 3,164,918
Oct 3,525,796
Nov 3,864,338
Dec 4,402,279
Percent of budget expended 20.93%
$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 34 of 37
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 2,780,288
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 3.64%
Non‐
Departmental YTD Annual % $6 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,162,281
May 1,452,852
Jun 1,743,422
Jul 2,033,992
Aug 2,324,563
Sep 2,615,133
Oct 2,905,703
Nov 3,196,274
Dec 3,486,844
Percent of budget expended 18.16%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00 Budget
Actual
Last Year
Page 35 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2014 Budget Year
Utilities Budget Revenue Expense
Jan 3,543,368 6,606,636 3,795,307
Feb 8,194,123 11,939,236 8,329,760
Mar 14,457,565 17,397,529 13,080,021
Apr 19,840,979
May 25,817,307
Jun 32,706,591
Jul 39,359,939
Aug 44,998,005
Sep 51,452,338
Oct 56,265,690
Nov 61,508,796
Dec 70,609,667
Percent of budget expended 16.66%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
Millions Utilities
Budget
Revenue
Expense
$18 00
Millions Airport
Airport Budget Revenue Expense
Jan 36,046 292,698 108,595
Feb 74,054 639,757 472,632
Mar 149,974 1,015,941 1,226,930
Apr 184,702
May 365,320
Jun 579,123
Jul 947,337
Aug 1,952,104
Sep 2,058,604
Oct 3,018,964
Nov 3,069,095
Dec 3,215,564
Percent of budget expended 38.16%
Note: Operations and Capital
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
$18.00
Budget
Revenue
Expense
Page 36 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2014 Budget Year
Golf Course Budget Revenue Expense
Jan 139,883 83,199 128,950
Feb 293,463 157,539 295,744
Mar 477,812 276,011 463,052
Apr 704,146
May 876,363
Jun 1,086,215
Jul 1,270,055
Aug 1,445,653
Sep 1,631,136
Oct 1,807,246
Nov 1,958,689
Dec 2,561,090
Percent of budget expended 18.08%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
Millions Golf Course
Budget
Revenue
Expense
Page 37 of 37